| 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 ="1";
include('includes/volet.php');
/****************************/
//****************************************************************************************//
//************************************ css pour mails ************************************//
//****************************************************************************************//
$thema = $GLOBALS['bdd']->query('SELECT * FROM info WHERE id = 1');
$resulta = $thema->fetchAll();
$fil = $resulta[0]['fil'] ;
$tfil = $resulta[0]['tfil'] ;
$shop_email_rappel = $resulta[0]['email_rappel'];
$shop_title = $resulta[0]['title'];
$url_shop = $resulta[0]['url'] ;
$sql = $GLOBALS['bdd']->query("SELECT * FROM themes WHERE cle >0");
$list= $sql->fetchAll();
for($i=0; $i<count($list); $i++) {
$Image_Logo = $list[$i]['Image_Logo'];
}
//////////////////////////////////////////////////////////// PAGINATION
require_once('pagination_fonction.php');
//////////////////////////////////////////////////////////// PAGINATION
// Suppression de la commande.
if (isset($_GET['del']))
{
$id = $_GET['del'];
$requete = $bdd->prepare("DELETE FROM orders WHERE id = :id");
$requete->execute(array('id' => $id));
$requete = $bdd->prepare("DELETE FROM orders_products WHERE id_order = :id");
$requete->execute(array('id' => $id));
/*
$requete = $bdd->prepare("DELETE FROM order_status WHERE id_order = :id");
$requete->execute(array('id' => $id));
*/
echo '<script>';
echo 'window.location = "./index.php"';
echo '</script>';
}
// Mise a jour du status de la commande
if (isset($_POST['insere_status']))
{
$sql = $bdd->prepare('INSERT INTO order_status(id_order, date_status, status)
VALUES (:order, :date_status, :status)');
$sql->execute(array('order' => $_POST['id'],
'date_status' => date('Y-m-d H:i:s'),
'status' => $_POST['status']));
$sql = $bdd->query('SELECT title, url, email_contact FROM info
WHERE id = 1');
$infos = $sql->fetch();
$sql = $bdd->prepare('SELECT id, date_insere, id_order, email FROM orders
WHERE id = :order');
$sql->execute(array('order' => $_POST['id']));
$order = $sql->fetch();
// Si module point actif
///////////////////////////
if ($fidel > 0) {
if ($_POST['status'] =='3') {
// Valeur du point
$GLOBALS['db_table']['points'] = 'points';
$GLOBALS['db_table']['orders'] = 'orders';
$GLOBALS['db_table']['customers'] = 'customers';
$idpointe = "1";
$requete = $bdd->query("SELECT * FROM " . $GLOBALS['db_table']['points'] . " WHERE id = " . $idpointe);
$po = $requete->fetch();
$valeur_point = $po['val_point'];
$remise_points = $po['remise'];
// Trouve num customer et total cde
$num_cde = $_POST['id'];
$requetecc = $bdd->query("SELECT customer,sub_total FROM " . $GLOBALS['db_table']['orders'] . " WHERE id = " . $num_cde);
$pocc = $requetecc->fetch();
$num_customer = $pocc['customer'];
$tot_ca = $pocc['sub_total'];
// Trouve solde de points client
$requetebb = $bdd->query("SELECT points FROM " . $GLOBALS['db_table']['customers'] . " WHERE id = " . $num_customer);
$pobb = $requetebb->fetch();
$solde_points = $pobb['points'];
// Points de la cde
$point_deduir = $tot_ca * $valeur_point;
$point_deduits = floor($point_deduir); // arrondi entier inferieur si virgule
// calcul le nouveau solde
$new_solde_points = $solde_points - $point_deduits;
if ($new_solde_points <0) {$new_solde_points ='0'; }
// enregistre les points dans cde
$qidd = $bdd->prepare("UPDATE " . $GLOBALS['db_table']['customers'] . "
SET points = :points WHERE id=:id");
$qidd->execute(array('points' => $new_solde_points,
'id' => $num_customer));
///////////
}
}
//////////////////////////////////////////////////////
if ($gesto > 0) {
if ($_POST['status'] =='3') {
$id_cde = $_POST['id'];
$status_cde = $_POST['status'];
include('debit_stock.php');
}
}
/////////////////////////////////////////////////////
$msg ='
<html lang="fr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>';
if ($emailo < 1) { $msg .='<img src="'.$url_shop.'/templates/shop/img/'.$Image_Logo.'" style="margin:10px; max-width:300px">';
} else {
$msg .='<img src="'.$url_shop.'/templates/shop/img/'.$Image_Logo.'" style="margin:10px;max-width:300px">';
}
$msg .='
<div style="background-color: #'.$fil.'; color:#'.$tfil.'; border-radius: 6px;">
<h3 style="font-size:20px; padding:10px;">Suivi de votre commande</h3>
</div>
<br />';
$msg .= '
Votre commmande du ' . strftime("%d/%m/%Y", strtotime($order['date_insere'])) . ' (Commande N. ' . $order['id_order'] . ' - ' . $order['id'] . ') a été mise à jour le ' . strftime("%d/%m/%Y à %Hh%M", time()) . '. <br /><br />Son nouveau statut est désormais <b>"';
switch ($_POST['status']) {
case '1':
$msg .= ''. $comm_1;
break;
case '2':
$msg .= ''. $comm_2;
break;
case '3':
$msg .= ''. $comm_3;
break;
default:
$msg .= ''. $comm_4;
break;
}
$msg .= '"</b>.<br />Vous pouvez suivre votre commande en cliquant ici : <a href="' . $infos['url'] . '/suivi-de-commande-' . $order['id_order'] . '">Suivi de ma commande</a>';
$msg .= '<br /><br /><b>'.$infos['title'].'</b> vous remercie de votre confiance.<br /><br /><br /><br />';
// Envoi message au client.
require('../includes/phpmailer/class.phpmailer.php');
$mail = new PHPMailer();
$mail->IsMail();
$mail->AddReplyTo($shop_email_rappel, $shop_title);
$mail->AddAddress($order['email']);
$mail->SetFrom($shop_email_rappel, $shop_title);
$mail->Subject = "Suivi de votre commande depuis le site " . $shop_title;
$mail->MsgHTML($msg);
$mail->Send();
echo '<script>';
echo 'window.location = "./index.php"';
echo '</script>';
}
/*******************************************************/
/*******************************************************/
/*******************************************************/
// Mise a jour DU RELICAT EN ATTENTE
////////////////////////////////////
if (isset($_POST['insere_attente']))
{
if ($_POST['attente'] =="0") { }
$exped = $_POST['exped']; // Si 1 ==> enlevement au magasin sinon expedition pour les mails
if ($_POST['attente'] =="1") {
// Si il y a encore des soldes en attente donc attente = 1
//////////////////////////////////////////////////////////
$message = "Un colis concernant un ou plusieurs de vos articles commandés est en traitement.<br />";
if($exped >0) {
$message .= "<br />Enlèvement par vos soins : le colis est disponible.";
} else {
$message .= "<br />Expédition : le colis est en partance.";
}
$message .= "<br /><br />Si vous attendez des autres produits nous vous informerons des prochains traitements...";
}
if ($_POST['attente'] =="2") {
// Si la commande est sold? donc attente = 2
/////////////////////////////////////////////
$idde = $_POST['id'];
$sql = $bdd->query("UPDATE orders SET cde_soldee ='1' WHERE id= '$idde'");
$sql->execute();
$message = "Un colis <b>soldant votre commande</b> et concernant le ou les produits en attente est en traitement.<br />";
if($exped >0) {
$message .= "<br />Enlèvement par vos soins : le colis est disponible.";
} else {
$message .= "<br />Expédition : le colis est en partance.";
}
}
if ($_POST['attente']>0) {
// Email
//////////////
$sql = $bdd->query('SELECT title, url, email_contact FROM info
WHERE id = 1');
$infos = $sql->fetch();
$sql = $bdd->prepare('SELECT id, date_insere, id_order, email FROM orders
WHERE id = :order');
$sql->execute(array('order' => $_POST['id']));
$order = $sql->fetch();
$msg ='
<html lang="fr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>';
if ($emailo < 1) { $msg .='<img src="'.$url_shop.'/templates/shop/img/'.$Image_Logo.'" style="margin:10px; max-width:300px">';
} else {
$msg .='<img src="'.$url_shop.'/templates/shop/img/'.$Image_Logo.'" style="margin:10px;max-width:300px">';
}
$msg .='<div style="background-color: #'.$fil.'; color:#'.$tfil.'; border-radius: 6px;"><h3 style="font-size:20px; padding:10px;">Suivi de votre commande</h3></div><br />';
$msg .= 'Votre commmande du ' . strftime("%d/%m/%Y", strtotime($order['date_insere'])) . ' (Commande N. ' . $order['id_order'] . ' - ' . $order['id'] . ') a été mise à jour.<br />';
$msg .= '<br /><b>'. $message.'</b>';
$msg .= '<br /><br /><b>'.$infos['title'].'</b> vous remercie de votre confiance.<br /><br /><br /><br />';
// Envoi message au client.
require('../includes/phpmailer/class.phpmailer.php');
$mail = new PHPMailer();
$mail->IsMail();
$mail->AddReplyTo($shop_email_rappel, $shop_title);
$mail->AddAddress($order['email']);
$mail->SetFrom($shop_email_rappel, $shop_title);
$mail->Subject = "Suivi de votre commande depuis le site " . $shop_title;
$mail->MsgHTML($msg);
$mail->Send();
echo '<script>';
echo 'window.location = "./index.php"';
echo '</script>';
}
}
?>
<div class="container">
<div class="row">
<div class="span12">
<div class="page-header">
<h1>Liste des commandes</h1>
</div>
</div>
</div>
<table class="table table-bordered table-striped">
<thead>
<tr>
<th class="span1 center">N.Ordre</th>
<th class="span1 center">N.Cde</th>
<th class="span2 center">Nom</th>
<th class="span2 center">Date</th>
<th class="span1 center">Etat</th>
<th class="span1 center">Total</th>
<th class="span1 center">Opérations</th>
</tr>
</thead>
<tbody>
<?php
//////////////////////////////////////////////////////////// PAGINATION
$res = $GLOBALS['bdd']->query("SELECT count(id) AS nb_total FROM orders");
$columns = $res->fetch();
$nb_total = $columns['nb_total'];
//////////////////////////////////////////////////////////// PAGINATION
if (!isset($_GET['debut'])) $_GET['debut'] = 0;
$nb_affichage_par_page = $commeo;
//////////////////////////////////////////////////////////// PAGINATION
$requete = $bdd->query("SELECT o.*, a.firstname, a.lastname, os.status FROM orders o
INNER JOIN address a
ON a.id = o.invoice_address
RIGHT JOIN order_status os
ON os.id_order = o.id
WHERE os.date_status = (SELECT MAX(date_status) FROM order_status
WHERE id_order = o.id)
ORDER BY id DESC LIMIT ".$_GET['debut'].",".$nb_affichage_par_page." ");
if ($row = $requete->fetch()) {
do {
?>
<tr>
<td class="center">
<b><?php echo stripcslashes($row['id']) ?></b>
<?php
// Date_dispo pour les relicats
/******************************/
// mod livraison
/**************/
$sqlp = $GLOBALS['bdd']->prepare('SELECT * FROM carrier WHERE id= :id');
$sqlp->execute(array('id' => '2'));
$carr = $sqlp->fetch();
$type = $carr['name'];
$type2 = $row['carrier'];
// Si = 1 ==> enlevement
////////////////////////
if ($type == $type2) { $exped ="1"; } else { $exped ="0"; }
$nbt_total =0;
$rest = $GLOBALS['bdd']->query("SELECT count(id_order) AS nbt_total FROM orders_products WHERE date_dispo <> '0000-00-00' AND id_order = " . $row['id'] ."");
$columnst = $rest->fetch();
$nbt_total = $columnst['nbt_total'];
if(($nbt_total >0) AND ($row['status'] == "2") AND ($row['cde_soldee'] == "0")) {
?><br /><a href="#" id="<?php echo $row['id']; ?>" data-toggle="modal" data-target="#attente_<?php echo $row['id']; ?>">
<img width="70" style="margin-top:5px" src="assets/img/attente.png" title="Solder la commande">
</a>
<?php
}
?>
<div class="modal hide fade" id="attente_<?php echo $row['id']; ?>" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true" wi>
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-hidden="true">x</button>
<h3 id="attente_title_box">Solder la commande ou partiellement</h3>
</div>
<form action="index.php" method="POST">
<input type="hidden" name="id" value="<?php echo $row['id']; ?>">
<input type="hidden" name="exped" value="<?php echo $exped; ?>">
<div class="modal-body" id="attente_box_content">
<label for="attente"></label>
<select name="attente" data-placeholder="" id="attente">
<option value="0">Aucune action</option>
<option value="1">Traitement partiel</option>
<option value="2">Traitement terminé</option>
</select>
</div>
<div class="modal-footer">
<button class="btn" data-dismiss="modal" aria-hidden="true">Fermer</button>
<input name="insere_attente" type="submit" class="btn btn-primary" value="Enregistrer" />
</div>
</form>
</div>
</td>
<td class="span1 font12 center">
<b><?php echo stripcslashes($row['id_order']) ?></b>
</td>
<td class="center">
<b><?php echo stripcslashes($row['firstname']) ?> <?php echo stripcslashes($row['lastname']) ?></b>
</td>
<td class="center">
<b>
<?php
setlocale (LC_TIME, 'fr_FR.utf8','fra');
echo utf8_encode(strftime("%A %d-%m-%Y", strtotime($row['date_insere'])));
echo'<br />';
echo'<font color="#FF0000">' . $row['carrier'] .'</font>';
?>
</b>
</td>
<td class="center">
<b>
<?php
switch ($row['status']) {
case '1':
echo$comm_1;
break;
case '2':
echo$comm_2;
break;
case '3':
echo$comm_3;
break;
default:
echo$comm_4;
break;
}
?>
</b>
</td>
</td>
<td class="center">
<b><?php echo stripcslashes(number_format($row['total'], 2, ',', ' '))."€" ?> <br /><font color="#CC3300" size="2"><?php echo $row['txt_discount']; ?></font></b>
</td>
<td class="center">
<?php if ($row['status'] !== '3') { ?>
<a href="#" id="<?php echo $row['id']; ?>" data-toggle="modal" data-target="#edit_status_<?php echo $row['id']; ?>">
<img src="assets/img/edit.png" title="Editer le statut de la commande">
</a>
<?php } ?>
<a href="./details_order.php?id=<?php echo $row['id']; ?>">
<img src="assets/img/details.png" title="Détail de la commande">
</a>
<?php if ($row['status'] == '3') { ?>
<a href="./index.php?del=<?php echo $row['id']; ?>" id="'.$id.'" onclick="return confirm('Etes vous sur de vouloir supprimer cette commande ?');">
<img src="assets/img/delete.png" title="Supprimer la commande">
</a>
<?php } ?>
</td>
</tr>
<?php
}while ($row = $requete->fetch());
} else {
echo 'Aucune commande à afficher !!!';
}
?>
</tbody>
</table>
<div class="pagin">
<?php
//////////////////////////////////////////////////////////// PAGINATION
//mysql_free_result ($requete);
echo '<b>'.barre_navigation($nb_total, $nb_affichage_par_page, $_GET['debut'], 8).'</b>';
// on lib?e l'espace m?oire allou?pour cette requ?e
// mysql_free_result ($resultat);
//////////////////////////////////////////////////////////// PAGINATION
?>
<br /><br />
</div>
</div>
<?php
$requete = $bdd->query("SELECT o.*, a.firstname, a.lastname, MAX(os.status) as status FROM orders o
INNER JOIN address a
ON a.id = o.invoice_address
RIGHT JOIN order_status os
ON os.id_order = o.id
GROUP BY o.id
ORDER BY date_insere DESC");
while ($row = $requete->fetch()) {
?>
<div class="modal hide fade" id="edit_status_<?php echo $row['id']; ?>" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true" wi>
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-hidden="true">x</button>
<h3 id="edit_status_title_box">Edition du status de la commande</h3>
</div>
<form action="index.php" method="POST">
<input type="hidden" name="id" value="<?php echo $row['id']; ?>">
<div class="modal-body" id="edit_status_box_content">
<label for="status">Statut :</label>
<select name="status" data-placeholder="Veuillez selectionner le nouveau statut de la commande" id="status">
<option value="0"><?php echo$comm_4; ?></option>
<option value="1"><?php echo$comm_1; ?></option>
<option value="2"><?php echo$comm_2; ?></option>
<option value="3"><?php echo$comm_3; ?></option>
</select>
</div>
<div class="modal-footer">
<button class="btn" data-dismiss="modal" aria-hidden="true">Fermer</button>
<input name="insere_status" type="submit" class="btn btn-primary" value="Enregistrer" />
</div>
</form>
</div>
<?
}
include_once('includes/footer.php');
?>