| trans("Code"); ?> | trans("Label"); ?> | trans("Qty"); ?> | trans("Discount").' (%)'; ?> | trans("TotalHT"); ?> |
|---|
query (
'SELECT id, ref, label, qte, price, remise_percent, remise, total_ht, total_ttc, tva_tx FROM '.MAIN_DB_PREFIX.'tmp_caisse as c
LEFT JOIN '.MAIN_DB_PREFIX.'product as p ON c.fk_article = p.rowid
ORDER BY id');
if ( $db->num_rows($res) ) {
$ret=array(); $i=0;
while ( $tab = $db->fetch_array($res) )
{
foreach ( $tab as $cle => $valeur )
{
$ret[$i][$cle] = $valeur;
}
$i++;
}
$tab = $ret;
for ( $i = 0; $i < count($tab); $i++ ) {
$remise = $tab[$i]['remise'];
echo ('| '.$tab[$i]['ref'].' | '.$tab[$i]['label'].' | '.$tab[$i]['qte'].' | '.$tab[$i]['remise_percent'].' | '.price2num($tab[$i]['total_ht'],'MT').' '.$conf->monnaie.' |
'."\n");
}
} else {
echo ('Erreur : aucun article
'."\n");
}
?>