public function getList($order, $critere, $debut, $nbres) { $query = $this->getRequest('list', $order, $critere, $debut, $nbres); $resul = $this->query($query); $retour = array(); while ($resul && ($row = $this->fetch_object($resul))) { $thisClient = array(); $thisClient['ref'] = $row->ref; $thisClient['entreprise'] = $row->entreprise; $thisClient['nom'] = $row->nom; $thisClient['prenom'] = $row->prenom; $thisClient['email'] = $row->email; $commande = new Commande(); $devise = new Devise(); $querycom = "SELECT id FROM {$commande->table} WHERE client={$row->id} AND statut NOT IN(" . Commande::NONPAYE . "," . Commande::ANNULE . ") ORDER BY date DESC LIMIT 0,1"; $resulcom = $commande->query($querycom); if ($commande->num_rows($resulcom) > 0) { $idcom = $commande->get_result($resulcom, 0, "id"); $commande->charger($idcom); $devise->charger($commande->devise); $thisClient['date'] = strftime("%d/%m/%Y %H:%M:%S", strtotime($commande->date)); $thisClient['somme'] = formatter_somme($commande->total(true, true)) . ' ' . $devise->symbole; } else { $thisClient['date'] = ''; $thisClient['somme'] = ''; } $retour[] = $thisClient; } return $retour; }
/** * Modifier une devise existante * * @param int $id * @param string $nom * @param float $taux * @param string $symbole * @param string $code * @param int $defaut 0 ou 1 */ public function modifier($id, $nom, $taux, $symbole, $code, $defaut) { $devise = new Devise(); if ($devise->charger($id)) { $devise->nom = $nom; $devise->taux = $taux; $devise->symbole = $symbole; $devise->code = $code; $devise->defaut = $defaut; $devise->maj(); ActionsModules::instance()->appel_module("moddevise", $devise); } }
function liste_clients($order, $critere, $debut) { $i = 0; $client = new Client(); $query = "select * from {$client->table} order by {$critere} {$order} limit {$debut},20"; $resul = $client->query($query); while ($resul && ($row = $client->fetch_object($resul))) { $fond = "ligne_" . ($i++ % 2 ? "claire" : "fonce") . "_rub"; $commande = new Commande(); $devise = new Devise(); $querycom = "select id from {$commande->table} where client={$row->id} and statut not in(" . Commande::NONPAYE . "," . Commande::ANNULE . ") order by date DESC limit 0,1"; $resulcom = $commande->query($querycom); $existe = 0; if ($commande->num_rows($resulcom) > 0) { $existe = 1; $idcom = $commande->get_result($resulcom, 0, "id"); $commande->charger($idcom); $devise->charger($commande->devise); $date = strftime("%d/%m/%y %H:%M:%S", strtotime($commande->date)); } $creation = strftime("%d/%m/%y %H:%M:%S", strtotime($row->datecrea)); ?> <ul class="<?php echo $fond; ?> "> <li style="width:122px;"><?php echo $row->ref; ?> </li> <li style="width:110px;"><?php echo $creation; ?> </li> <li style="width:143px;"><?php echo $row->entreprise; ?> </li> <li style="width:243px;"><?php echo $row->nom; ?> <?php echo $row->prenom; ?> </li> <li style="width:110px;"><?php if ($existe) { echo $date; } ?> </li> <li style="width:63px;"><?php if ($existe) { echo formatter_somme($commande->total(true, true)) . ' ' . $devise->symbole; } ?> </li> <li style="width:40px;"><a href="client_visualiser.php?ref=<?php echo $row->ref; ?> " class="txt_vert_11"><?php echo trad('editer', 'admin'); ?> </a></li> <li style="width:25px; text-align:center;"><a href="#" onclick="confirmSupp('<?php echo $row->ref; ?> ')"><img src="gfx/supprimer.gif" width="9" height="9" border="0" /></a></li> </ul> <?php } }
function boucleDevise($texte, $args) { // récupération des arguments $produit = lireTag($args, "produit", "int"); $id = lireTag($args, "id", "int_list"); $somme = lireTag($args, "somme", "float"); $exclusion = lireTag($args, "exclusion", "int_list"); $search = ""; $limit = ""; $res = ""; if ($somme == "") { $somme = 0; } $prod = new Produit(); if (!empty($produit)) { $prod->charger_id($produit); } if ($id != "") { $search .= " and id in({$id})"; } if ($exclusion != "") { $search .= " and id not in({$exclusion})"; } $url = preg_replace('/[\\&\\?]*devise=[0-9]+/', '', url_page_courante()); $url .= strstr($url, '?') == false ? '?' : '&'; $devise = new Devise(); $query = "select * from {$devise->table} where 1 {$search} {$limit}"; $resul = CacheBase::getCache()->query($query); //FIX : test d'existence de la session if (!isset($_SESSION["navig"])) { $_SESSION["navig"] = new Navigation(); } if (!empty($resul)) { foreach ($resul as $row) { $devise->charger($row->id); $prix = $prix2 = $convert = 0; if (!empty($prod->id)) { $prix = $prod->prix * $devise->taux; $prix2 = $prod->prix2 * $devise->taux; } if (!empty($somme)) { $convert = $somme * $devise->taux; } $total = $_SESSION['navig']->panier->total(1) * $devise->taux; $temp = str_replace("#ID", $devise->id, $texte); $temp = str_replace("#PRIX2", formatter_somme($prix2), $temp); $temp = str_replace("#PRIX", formatter_somme($prix), $temp); $temp = str_replace("#TOTAL", formatter_somme($total), $temp); $temp = str_replace("#CONVERT", formatter_somme($convert), $temp); $temp = str_replace("#NOM", $devise->nom, $temp); $temp = str_replace("#CODE", $devise->code, $temp); $temp = str_replace("#TAUX", $devise->taux, $temp); $temp = str_replace("#HTMLSYMBOLE", htmlentities($devise->symbole, ENT_COMPAT, 'UTF-8', false), $temp); $temp = str_replace("#SYMBOLE", $devise->symbole, $temp); $temp = str_replace("#DEFAUT", $devise->defaut, $temp); $temp = str_replace("#COURANTE", $devise->id == ActionsDevises::instance()->get_id_devise_courante() ? "1" : "0", $temp); $temp = str_replace('#URL', $url . 'devise=' . $devise->id, $temp); $res .= $temp; } } return $res; }
require_once "../fonctions/divers.php"; if (!isset($action)) { $action = ""; } if (!isset($statutch)) { $statutch = ""; } ?> <?php $commande = new Commande(); $commande->charger_ref($ref); $modules = new Modules(); $modules->charger_id($commande->paiement); $devise = new Devise(); $devise->charger($commande->devise); if ($statutch) { $commande->setStatutAndSave($statutch); } if (isset($colis) && $colis != "") { $commande->colis = $colis; $commande->maj(); ActionsModules::instance()->appel_module("statut", $commande, $commande->statut); } ?> </head> <body> <div id="wrapper">
function lister_commandes($critere, $order, $debut, $nbres, $search = '') { $commande = new Commande(); $i = 0; $query = "select * from {$commande->table} where 1 {$search} order by {$critere} {$order} limit {$debut},{$nbres}"; $resul = $commande->query($query); while ($resul && ($row = $commande->fetch_object($resul, 'Commande'))) { $client = new Client(); $client->charger_id($row->client); $statutdesc = new Statutdesc(); $statutdesc->charger($row->statut); $devise = new Devise(); $devise->charger($row->devise); $total = formatter_somme($row->total(true, true)); $date = strftime("%d/%m/%y %H:%M:%S", strtotime($row->date)); $fond = "ligne_" . ($i++ % 2 ? "claire" : "fonce") . "_rub"; ?> <ul class="<?php echo $fond; ?> "> <li style="width:142px;"><?php echo $row->ref; ?> </li> <li style="width:104px;"><?php echo $date; ?> </li> <li style="width:200px;"><?php echo $client->entreprise; ?> </li> <li style="width:200px;"><a href="client_visualiser.php?ref=<?php echo $client->ref; ?> "><?php echo $client->nom . " " . $client->prenom; ?> </a></li> <li style="width:59px;"><?php echo $total; ?> <?php echo $devise->symbole; ?> </li> <li style="width:70px;"><?php echo $statutdesc->titre; ?> </li> <li style="width:40px;"><a href="commande_details.php?ref=<?php echo $row->ref; ?> ">éditer</a></li> <?php if ($row->statut != Commande::ANNULE) { ?> <li style="width:35px; text-align:center;"><a href="#" onclick="supprimer('<?php echo $row->id; ?> '); return false;"><img src="gfx/supprimer.gif" width="9" height="9" border="0" /></a></li> <?php } ?> </ul> <?php } }
public function getSearchList($searchTerm, $clientFoundList) { $searchTerm = $this->escape_string(trim($searchTerm)); $return = array(); if ($searchTerm === '' && count($clientFoundList) == 0) { return $return; } $qOrders = "SELECT * FROM " . self::TABLE . "\n WHERE ref like '%{$searchTerm}%'\n OR facture like '%{$searchTerm}%'\n OR transaction like '%{$searchTerm}%'\n " . (count($clientFoundList) > 0 ? " OR client IN (" . implode(',', $clientFoundList) . ")" : '') . "\n " . (strtotime($searchTerm) ? " OR date LIKE '" . date('Y-m-d', strtotime($searchTerm)) . "%'" : '') . "\n LIMIT 100"; $rOrders = $this->query($qOrders); while ($rOrders && ($theOrder = $this->fetch_object($rOrders, 'Commande'))) { $thisOrderArray = array(); $client = new Client(); $client->charger_id($theOrder->client); $statutdesc = new Statutdesc(); $statutdesc->charger($theOrder->statut); $devise = new Devise(); $devise->charger($theOrder->devise); $total = formatter_somme($theOrder->total(true, true)); $date = strftime("%d/%m/%y %H:%M:%S", strtotime($theOrder->date)); $thisOrderArray['ref'] = $theOrder->ref; $thisOrderArray['transaction'] = $theOrder->transaction; $thisOrderArray['facture'] = $theOrder->facture; $thisOrderArray['date'] = $date; $thisOrderArray['client'] = array("entreprise" => $client->entreprise, "ref" => $client->ref, "nom" => $client->nom, "prenom" => $client->prenom); $thisOrderArray['total'] = $total; $thisOrderArray['devise'] = $devise->symbole; $thisOrderArray['titre'] = $statutdesc->titre; $thisOrderArray['statut'] = $theOrder->statut; $thisOrderArray['id'] = $theOrder->id; $return[] = $thisOrderArray; } return $return; }