$obj = $db->fetch_object($result); $var=!$var; print "<tr $bc[$var]>"; print '<td align="left">'.dol_print_date($db->jdate($obj->date_demande),'day')."</td>\n"; print '<td align="center">'.dol_print_date($db->jdate($obj->date_traite),'day')."</td>\n"; print '<td align="center">'.price($obj->amount).'</td>'; print '<td align="center">'; $withdrawreceipt=new BonPrelevement($db); $withdrawreceipt->id=$obj->fk_prelevement_bons; $withdrawreceipt->ref=$obj->ref; print $withdrawreceipt->getNomUrl(1); print "</td>\n"; print '<td align="center"><a href="'.DOL_URL_ROOT.'/user/fiche.php?id='.$obj->user_id.'">'.img_object($langs->trans("ShowUser"),'user').' '.$obj->login.'</a></td>'; print '<td> </td>'; print '<td> </td>'; print "</tr>\n"; $i++; } $db->free($result); } else {
$result = $db->query($sql); if ($result) { $num = $db->num_rows($result); $i = 0; print "\n<!-- debut table -->\n"; print '<table class="noborder" width="100%">'; print '<tr class="liste_titre"><td>' . $langs->trans("Ref") . '</td>'; print '<td align="center">' . $langs->trans("Date") . '</td><td align="right">' . $langs->trans("Amount") . '</td>'; print '</tr>'; $var = True; while ($i < min($num, $limit)) { $obj = $db->fetch_object($result); $var = !$var; print "<tr " . $bc[$var] . ">"; print "<td>"; $bprev->id = $obj->rowid; $bprev->ref = $obj->ref; print $bprev->getNomUrl(1); print "</td>\n"; print '<td align="center">' . dol_print_date($db->jdate($obj->datec), 'day') . "</td>\n"; print '<td align="right">' . price($obj->amount, 0, $langs, 0, 0, -1, $conf->currency) . "</td>\n"; print "</tr>\n"; $i++; } print "</table><br>"; $db->free($result); } else { dol_print_error($db); } llxFooter(); $db->close();
$invoicestatic = new Facture($db); llxHeader('', $langs->trans("StandingOrder")); $h = 0; $head[$h][0] = DOL_URL_ROOT . '/compta/prelevement/ligne.php?id=' . $id; $head[$h][1] = $langs->trans("Card"); $hselected = $h; $h++; if ($id) { $lipre = new LignePrelevement($db, $user); if ($lipre->fetch($id) == 0) { $bon = new BonPrelevement($db); $bon->fetch($lipre->bon_rowid); dol_fiche_head($head, $hselected, $langs->trans("StandingOrder")); print '<table class="border" width="100%">'; print '<tr><td width="20%">' . $langs->trans("WithdrawalsReceipts") . '</td><td>'; print $bon->getNomUrl(1) . '</td></tr>'; print '<tr><td width="20%">' . $langs->trans("Date") . '</td><td>' . dol_print_date($bon->datec, 'day') . '</td></tr>'; print '<tr><td width="20%">' . $langs->trans("Amount") . '</td><td>' . price($lipre->amount) . '</td></tr>'; print '<tr><td width="20%">' . $langs->trans("Status") . '</td><td>' . $lipre->LibStatut($lipre->statut, 1) . '</td></tr>'; if ($lipre->statut == 3) { $rej = new RejetPrelevement($db, $user); $resf = $rej->fetch($lipre->id); if ($resf == 0) { print '<tr><td width="20%">' . $langs->trans("RefusedReason") . '</td><td>' . $rej->motif . '</td></tr>'; print '<tr><td width="20%">' . $langs->trans("RefusedData") . '</td><td>'; if ($rej->date_rejet == 0) { /* Historique pour certaines install */ print $langs->trans("Unknown"); } else { print dol_print_date($rej->date_rejet, 'day'); }