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;
}
