tva.php

Go to the documentation of this file.

<?php
// This file should be in UTF8 without BOM - Accents examples: éèê
// +----------------------------------------------------------------------+
// | Copyright (c) 2004-2015 Advisto SAS, service PEEL - contact@peel.fr  |
// +----------------------------------------------------------------------+
// | This file is part of PEEL Shopping 8.0.0, which is subject to an   |
// | opensource GPL license: you are allowed to customize the code           |
// | for your own needs, but must keep your changes under GPL                |
// | More information: https://www.peel.fr/lire/licence-gpl-70.html          |
// +----------------------------------------------------------------------+
// | Author: Advisto SAS, RCS 479 205 452, France, https://www.peel.fr/      |
// +----------------------------------------------------------------------+
// $Id: tva.php 46935 2015-09-18 08:49:48Z gboussin $
define('IN_PEEL_ADMIN', true);
include("../configuration.inc.php");
necessite_identification();
necessite_priv("admin_manage");

$GLOBALS['DOC_TITLE'] = $GLOBALS['STR_ADMIN_TVA_TITLE'];
include($GLOBALS['repertoire_modele'] . "/admin_haut.php");

if (isset($_POST['mode'])) {
     $mode = $_POST['mode'];
} elseif (isset($_GET['mode'])) {
     $mode = $_GET['mode'];
} else {
     $mode = "liste";
}
$frm = $_POST;
$form_error_object = new FormError();

switch ($mode) {
     case "ajout" :
          affiche_formulaire_ajout_tva($frm);
          break;

     case "modif" :
          affiche_formulaire_modif_tva($_GET['id'], $frm);
          break;

     case "suppr" :
          supprime_tva($_GET['id']);
          affiche_liste_tva();
          break;

     case "insere" :
          if (!verify_token($_SERVER['PHP_SELF'] . $frm['mode'] . $frm['id'])) {
               $form_error_object->add('token', $GLOBALS['STR_INVALID_TOKEN']);
          }
          if (!$form_error_object->count()) {
               insere_tva($_POST);
               affiche_liste_tva();
          } else {
               if ($form_error_object->has_error('token')) {
                    echo $form_error_object->text('token');
               }
               affiche_formulaire_ajout_tva($frm);
          }
          break;

     case "maj" :
          if (!verify_token($_SERVER['PHP_SELF'] . $frm['mode'] . $frm['id'])) {
               $form_error_object->add('token', $GLOBALS['STR_INVALID_TOKEN']);
          }
          if (!$form_error_object->count()) {
               maj_tva($_POST['id'], $_POST);
               affiche_liste_tva();
          } else {
               if ($form_error_object->has_error('token')) {
                    echo $form_error_object->text('token');
               }
               affiche_formulaire_modif_tva($_GET['id'], $frm);
          }
          break;

     default :
          affiche_liste_tva();
          break;
}

include($GLOBALS['repertoire_modele'] . "/admin_bas.php");

function affiche_formulaire_ajout_tva(&$frm)
{
     /* Valeurs par défaut */
     if(empty($frm)) {
          $frm = array();
          $frm['tva'] = "";
     }
     $frm['nouveau_mode'] = "insere";
     $frm['titre_bouton'] = $GLOBALS['STR_ADMIN_ADD'];

     affiche_formulaire_tva($frm);
}

function affiche_formulaire_modif_tva(&$id, &$frm)
{
     if(empty($frm)){
          // Pas de données venant de validation de formulaire, donc on charge le contenu de la base de données
          /* Charge les informations du produit */
          $qid = query("SELECT *
               FROM peel_tva
               WHERE id = '" . intval($id) . "' AND " . get_filter_site_cond('tva', null, true));
          $frm = fetch_assoc($qid);
     }
     if (!empty($frm)) {
          $frm['nouveau_mode'] = "maj";
          $frm['titre_bouton'] = $GLOBALS['STR_ADMIN_TVA_SAVE'];
          affiche_formulaire_tva($frm);
     } else {
          redirect_and_die(get_current_url(false).'?mode=ajout');
     }
}

function affiche_formulaire_tva($frm)
{
     if (!empty($frm['id'])) {
          $id = $frm['id'];
     } else {
          $id = "";
     }
     $tpl = $GLOBALS['tplEngine']->createTemplate('admin_formulaire_tva.tpl');
     $tpl->assign('site_id_select_options', get_site_id_select_options(vb($frm['site_id'])));
     $tpl->assign('action', get_current_url(false) . '?start=0');
     $tpl->assign('form_token', get_form_token_input($_SERVER['PHP_SELF'] . $frm['nouveau_mode'] . intval($id)));
     $tpl->assign('mode', vb($frm['nouveau_mode']));
     $tpl->assign('id', intval($id));
     $tpl->assign('tva', $frm['tva']);
     $tpl->assign('titre_bouton', $frm['titre_bouton']);
     $tpl->assign('STR_ADMIN_WEBSITE', $GLOBALS['STR_ADMIN_WEBSITE']);
     $tpl->assign('STR_ADMIN_TVA_FORM_TITLE', $GLOBALS['STR_ADMIN_TVA_FORM_TITLE']);
     $tpl->assign('STR_ADMIN_VAT_PERCENTAGE', $GLOBALS['STR_ADMIN_VAT_PERCENTAGE']);
     $tpl->assign('STR_BEFORE_TWO_POINTS', $GLOBALS['STR_BEFORE_TWO_POINTS']);
     echo $tpl->fetch();
}
                    

function supprime_tva($id)
{
     query("DELETE FROM peel_tva WHERE id='" . intval($id) . "' AND " . get_filter_site_cond('tva', null, true));
     echo $GLOBALS['tplEngine']->createTemplate('global_success.tpl', array('message' => $GLOBALS['STR_ADMIN_TVA_MSG_DELETED_OK']))->fetch();
}

function insere_tva($frm)
{
     $frm['tva'] = get_float_from_user_input($frm['tva']);
     $qid = query("SELECT *
          FROM peel_tva
          WHERE tva = '" . floatval($frm['tva']) . "' AND " . get_filter_site_cond('tva', null, true));
     if (!fetch_assoc($qid)) {
          $qid = query("INSERT INTO peel_tva (tva, site_id)
               VALUES ('" . floatval($frm['tva']) . "', '" . nohtml_real_escape_string(get_site_id_sql_set_value($frm['site_id'])) . "')");
          echo $GLOBALS['tplEngine']->createTemplate('global_success.tpl', array('message' => $GLOBALS['STR_ADMIN_TVA_MSG_CREATED_OK']))->fetch();
     } else {
          echo $GLOBALS['tplEngine']->createTemplate('global_error.tpl', array('message' => $GLOBALS['STR_ADMIN_TVA_ERR_ALREADY_EXISTS']))->fetch();
     }
}

function maj_tva($id, $frm)
{
     $frm['tva'] = get_float_from_user_input($frm['tva']);
     query("UPDATE peel_tva
          SET tva='" . floatval($frm['tva']) . "', site_id='" . nohtml_real_escape_string(get_site_id_sql_set_value($frm['site_id'])) . "'
          WHERE id='" . intval($frm['id']) . "'  AND " . get_filter_site_cond('tva', null, true));
     echo $GLOBALS['tplEngine']->createTemplate('global_success.tpl', array('message' => $GLOBALS['STR_ADMIN_TVA_MSG_UPDATED_OK']))->fetch();
}

function affiche_liste_tva()
{
     $tpl = $GLOBALS['tplEngine']->createTemplate('admin_liste_tva.tpl');
     $tpl->assign('add_src', $GLOBALS['administrer_url'] . '/images/add.png');
     $tpl->assign('add_href', get_current_url(false) . '?mode=ajout');
     $tpl->assign('drop_src', $GLOBALS['administrer_url'] . '/images/b_drop.png');
     $tpl->assign('edit_src', $GLOBALS['administrer_url'] . '/images/b_edit.png');
     $result = query("SELECT id, tva, site_id
          FROM peel_tva
          WHERE " . get_filter_site_cond('tva', null, true) ." 
          ORDER BY id ASC");
     if (!(num_rows($result) == 0)) {
          $tpl_results = array();
          $i = 0;
          while ($ligne = fetch_assoc($result)) {
               $tpl_results[] = array('tr_rollover' => tr_rollover($i, true),
                    'drop_href' => get_current_url(false) . '?mode=suppr&id=' . $ligne['id'],
                    'modif_href' => get_current_url(false) . '?mode=modif&id=' . $ligne['id'],
                    'tva' => $ligne['tva'],
                    'site_name' => get_site_name($ligne['site_id'])
                    );
               $i++;
          }
          $tpl->assign('results', $tpl_results);
     }
     $tpl->assign('STR_BEFORE_TWO_POINTS', $GLOBALS['STR_BEFORE_TWO_POINTS']);
     $tpl->assign('STR_ADMIN_TVA_TITLE', $GLOBALS['STR_ADMIN_TVA_TITLE']);
     $tpl->assign('STR_ADMIN_TVA_FORM_EXPLAIN', $GLOBALS['STR_ADMIN_TVA_FORM_EXPLAIN']);
     $tpl->assign('STR_ADMIN_TVA_CREATE', $GLOBALS['STR_ADMIN_TVA_CREATE']);
     $tpl->assign('STR_ADMIN_ACTION', $GLOBALS['STR_ADMIN_ACTION']);
     $tpl->assign('STR_ADMIN_VAT_PERCENTAGE', $GLOBALS['STR_ADMIN_VAT_PERCENTAGE']);
     $tpl->assign('STR_ADMIN_DELETE_WARNING', $GLOBALS['STR_ADMIN_DELETE_WARNING']);
     $tpl->assign('STR_ADMIN_TVA_DELETE', $GLOBALS['STR_ADMIN_TVA_DELETE']);
     $tpl->assign('STR_DELETE', $GLOBALS['STR_DELETE']);
     $tpl->assign('STR_ADMIN_TVA_UPDATE', $GLOBALS['STR_ADMIN_TVA_UPDATE']);
     $tpl->assign('STR_ADMIN_TVA_NOTHING_FOUND', $GLOBALS['STR_ADMIN_TVA_NOTHING_FOUND']);
     $tpl->assign('STR_ADMIN_WEBSITE', $GLOBALS['STR_ADMIN_WEBSITE']);
     echo $tpl->fetch();
}