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;
}
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 boucleTva($texte, $args)
{
$res = "";
$commande_id = lireTag($args, "commande", "int");
if (!empty($commande_id)) {
$commande = new Commande();
if ($commande->charger($commande_id)) {
$venteprod = new Venteprod();
$query = "\n\t\t\t\t\tselect\n\t\t\t\t\t\tsum(prixu * quantite) as totalttc,\n\t\t\t\t\t\ttva\n\t\t\t\t\tfrom\n\t\t\t\t\t\t{$venteprod->table}\n\t\t\t\t\twhere\n\t\t\t\t\t\tcommande={$commande_id}\n\t\t\t\t\tgroup by\n\t\t\t\t\t\ttva\n\t\t\t\t";
$resul = CacheBase::getCache()->query($query);
if (!empty($resul)) {
foreach ($resul as $row) {
if (floatval($row->tva) > 0) {
$tmp = $texte;
$totalht = $row->totalttc / (1 + $row->tva / 100);
$montant = $row->totalttc - $totalht;
$tmp = str_replace("#TAUX", $row->tva, $tmp);
$tmp = str_replace("#MONTANT", formatter_somme($montant), $tmp);
$tmp = str_replace("#TOTALHT", formatter_somme($totalht), $tmp);
$tmp = str_replace("#TOTALTTC", formatter_somme($row->totalttc), $tmp);
$res .= $tmp;
}
}
}
}
}
return $res;
}
function supprcmd($id)
{
$tempcmd = new Commande();
if ($tempcmd->charger($id)) {
$tempcmd->annuler();
}
}
}
if (!isset($client)) {
$client = "";
}
if (!isset($page)) {
$page = 0;
}
if (!isset($classement)) {
$classement = "";
}
?>
<?php
if ($action == "supprimer") {
$tempcmd = new Commande();
if ($tempcmd->charger($id)) {
$tempcmd->annuler();
}
}
?>
<?php
if (empty($_GET['statut'])) {
$_GET['statut'] = Commande::NONPAYE . "," . Commande::PAYE . "," . Commande::TRAITEMENT;
}
if ($_GET['statut'] == '*') {
$search = "";
} else {
if ($_GET['statut'] != "") {
$search = "and statut IN(" . $_GET['statut'] . ")";
}
$adr->adresse2 = $client->adresse2;
$adr->adresse3 = $client->adresse3;
$adr->cpostal = $client->cpostal;
$adr->ville = $client->ville;
$adr->tel = $client->telfixe . " " . $client->telport;
$adr->pays = $client->pays;
$adrcli = $adr->add();
$commande->adrfact = $adrcli;
$commande->adrlivr = $adrcli;
$commande->facture = 0;
$commande->lang = ActionsLang::instance()->get_id_langue_courante();
$devise = ActionsDevises::instance()->get_devise_courante();
$commande->devise = $devise->id;
$commande->taux = $devise->taux;
$idcmd = $commande->add();
$commande->charger($idcmd);
for ($i = 0; $i < $nbart; $i++) {
$produit = new Produit();
$venteprod = new Venteprod();
if ($produit->charger($sessionventeprod[$i]->ref)) {
$produit->stock -= $sessionventeprod[$i]->quantite;
$poids += $produit->poids;
$produit->maj();
}
$venteprod->ref = $sessionventeprod[$i]->ref;
$venteprod->titre = $sessionventeprod[$i]->titre;
$venteprod->quantite = $sessionventeprod[$i]->quantite;
$venteprod->tva = $sessionventeprod[$i]->tva;
$venteprod->prixu = $sessionventeprod[$i]->prixu;
$venteprod->commande = $idcmd;
$venteprod->add();
