$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');
}
