Example #1
0
$sql .= $db->plimit(15, 0);
$result = $db->query($sql);
if ($result) {
    $num = $db->num_rows($result);
    $i = 0;
    print '<table class="noborder" width="100%">';
    print '<tr class="liste_titre"><td colspan="2">' . $langs->trans("Warehouses") . '</td></tr>';
    if ($num) {
        $entrepot = new Entrepot($db);
        $var = True;
        while ($i < $num) {
            $objp = $db->fetch_object($result);
            $var = !$var;
            print "<tr " . $bc[$var] . ">";
            print "<td><a href=\"card.php?id={$objp->rowid}\">" . img_object($langs->trans("ShowStock"), "stock") . " " . $objp->label . "</a></td>\n";
            print '<td align="right">' . $entrepot->LibStatut($objp->statut, 5) . '</td>';
            print "</tr>\n";
            $i++;
        }
        $db->free($result);
    }
    print "</table>";
} else {
    dol_print_error($db);
}
//print '</td><td valign="top" width="70%" class="notopnoleftnoright">';
print '</div><div class="fichetwothirdright"><div class="ficheaddleft">';
// Last movements
$max = 10;
$sql = "SELECT p.rowid, p.label as produit,";
$sql .= " e.label as stock, e.rowid as entrepot_id,";