| Server IP : 109.234.164.53 / Your IP : 216.73.216.110 Web Server : Apache System : Linux cervelle.o2switch.net 4.18.0-553.32.1.lve.el8.x86_64 #1 SMP Thu Dec 19 13:14:03 UTC 2024 x86_64 User : computer3 ( 1098) PHP Version : 7.1.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/computer3/litsolide.com/ODLDDD_2/cp-admin/ |
Upload File : |
<?php
include_once('includes/header.php');
$id_volet ="29";
include('includes/volet.php');
/****************************/
if (isset($_POST['edit'])) {
$id_cat = $_POST['id_cat'];
$remise = $_POST['remise'];
$case = $_POST['case'];
if ($case =="") { $cle_promo="0"; } else { $cle_promo="1"; }
if ($remise =="0") { $cle_promo="0"; }
if ($remise =="") { $cle_promo="0"; }
// Enregistre la remise globale dans la categorie
/*************************************************/
$qid = $bdd->prepare("UPDATE " . $GLOBALS['db_table']['categories'] . "
SET promo = :promo, cle_promo = :cle_promo WHERE id = :id");
$qid->execute(array(
'promo' => $remise,
'cle_promo' => $cle_promo,
'id' => $id_cat));
/**********************************************/
/**********************************************/
/**********************************************/
/**********************************************/
if ($remise =="") { $remise ="0"; }
///////////////////////////////////////////////
///////////////////////////////////////////////
// Calcule la remise globale dans les produits
/**********************************************/
// $ccp=0;
$requete2 = $bdd->query("SELECT *, p.id AS pid, p.name AS pname, c.name AS cname FROM " . $GLOBALS['db_table']['products_categories'] . " pc
JOIN " . $GLOBALS['db_table']['products'] . " p
ON pc.id_product = p.id
JOIN " . $GLOBALS['db_table']['categories'] . " c
ON pc.id_category = c.id
ORDER BY id_category ASC");
while ($pro = $requete2->fetch()) {
// Debug
/********/
// $ccp=$ccp+1;
// echo"<br />".$ccp ." -> ".$pro['pid']." ... ".$pro['pname'] ;
// echo"-> ".$pro['cname']." -- ".$pro['promo']." <br />" ;
// Enregistre suivant maud (si remise = 0 ou non)
/***********************************************/
if ($remise =="0") { $maud = "-1"; $pro['cle_promo'] ="1"; } else { $maud ="0"; }
if ($pro['promo'] > $maud ) {
if ($pro['discount_prod'] >0) { if ($pro['cle_promo'] >0) { $discountp = $pro['discount_prod']; } else { $discountp = $pro['promo'] ; } }
if ($pro['discount_prod'] =="0") { if ($pro['cle_promo'] >0) { $discountp = $pro['promo']; } else { $discountp = $pro['promo'] ; } }
$qid = $bdd->prepare("UPDATE " . $GLOBALS['db_table']['products'] . "
SET discount = :discount, promo = :promo WHERE id = :id");
$qid->execute(array(
'discount' => $discountp,
'promo' => $pro['promo'],
'id' => $pro['pid']));
}
}
/**********************************************/
/**********************************************/
/**********************************************/
/**********************************************/
}
?>
<div class="container">
<div class="row">
<div class="span12">
<div class="page-header">
<h1>Remises par catégories
<div class="pull-right">
<a href="products.php" class="btn btn-primary"><i class="icon-arrow-left"></i>Voir les Produits</a>
<a href="category.php" class="btn btn-primary"><i class="icon-arrow-right"></i> Gestion Catégories</a>
</div>
</h1>
<i>La case à cocher permet de garder la remise faite dans la fiche produit (si elle existe)</i>
</div>
</div>
</div>
<table id="" class="table table-bordered table-striped">
<thead>
<tr>
<th class="span3 center">Catégorie</th>
<th class="span1 center">Nbre de produits</th>
<th class="span1 center">Remise en %</th>
<th class="span2 center">Opérations</th>
</tr>
</thead>
<tbody>
<?php
$requete = $bdd->query("SELECT COUNT(pc.id_category) as total, c.* FROM " . $GLOBALS['db_table']['categories'] . " c LEFT JOIN " . $GLOBALS['db_table']['products_categories'] . " pc ON c.id = pc.id_category GROUP BY c.id ORDER BY c.position");
if ($row = $requete->fetch()) {
do {
$id = $row['id'];
?>
<tr class="" id="" style="">
<td class="span1 font12 center">
<?php
$parent_id = $row['parent_id'];
if($parent_id > 0) {
$requet = $bdd->query("SELECT * FROM " . $GLOBALS['db_table']['categories'] . " WHERE id = " . $parent_id);
$catt = $requet->fetch();
echo '<font color="#CC0000"><b>'.$catt['name'].'</b></font> --> '; }
?>
<b><?php echo stripcslashes($row['name']) ?></b>
</td>
<td class="span1 font12 center">
<b><?php echo stripcslashes($row['total']) ?></b>
</td>
<!-- Formulaire -->
<form class="form-horizontal" method="POST" action="promosite.php" enctype="multipart/form-data">
<input name="id_cat" type="hidden" value="<?php echo$row['id'] ?>">
<td class="span1 font12 center">
<?php if ($row['promo'] >0) { $thc="#FF0000"; $vignett ="vignette_promo_cp.png";} else { $thc="#000"; $vignett ="vignette_promo_cp_no.png"; } ?>
<input style="text-align:left;width:100px" name="remise" type="number" min="0" max="100" step="0.00001" value="<?php echo$row['promo']?>"> <font color="<?php echo$thc?>">%</font>
</td>
<td class="center">
<?php
if ($row['cle_promo'] >0) {
echo '<input name="case" checked type="checkbox" />';
} else {
echo '<input name="case" type="checkbox" />';
}
?>
<button type="submit" name="edit" class="btn btn-success"><i class="icon-ok"></i> Enregistrer</button>
<img width="50" src="./assets/img/<?php echo$vignett ?>" alt="" />
</form>
<!-- // Formulaire -->
<?php
$stopd = '0';
$requetedd= $bdd->query("SELECT * FROM " . $GLOBALS['db_table']['categories'] . " WHERE parent_id = " . $id);
if ($rowdd = $requetedd->fetch()) {
do {
$stopd = $stopd + 1;
}while ($rowdd = $requetedd->fetch());
} else {
}
$stop = 0;
if($stopd > 0) { $stop = $stop + 1;}
if($row['total'] > 0) { $stop = $stop + 1;}
?>
</td>
</tr>
<?php
}while ($row = $requete->fetch());
} else {
echo 'Aucune page à afficher !!!';
}
?>
</tbody>
</table>
</div>
<?
include_once('includes/footer.php');
?>