}
print '<tr ' . $bc[$var] . '>';
print '<td class="nowrap">' . dol_print_date($db->jdate($objp->do), "day") . "</td>\n";
print '<td class="nowrap">' . dol_print_date($db->jdate($objp->dv), "day");
print "</td>\n";
// Payment type
print '<td class="nowrap">';
$label = $langs->trans("PaymentTypeShort" . $objp->fk_type) != "PaymentTypeShort" . $objp->fk_type ? $langs->trans("PaymentTypeShort" . $objp->fk_type) : $objp->fk_type;
if ($objp->fk_type == 'SOLD') {
$label = ' ';
}
if ($objp->fk_type == 'CHQ' && $objp->fk_bordereau > 0) {
dol_include_once('/compta/paiement/cheque/class/remisecheque.class.php');
$bordereaustatic = new RemiseCheque($db);
$bordereaustatic->id = $objp->fk_bordereau;
$label .= ' ' . $bordereaustatic->getNomUrl(2);
}
print $label;
print "</td>\n";
// Num
print '<td class="nowrap">' . ($objp->num_chq ? $objp->num_chq : "") . "</td>\n";
// Description
print '<td>';
// Show generic description
if (preg_match('/^\\((.*)\\)$/i', $objp->label, $reg)) {
// Generic description because between (). We show it after translating.
print $langs->trans($reg[1]);
} else {
print dol_trunc($objp->label, 60);
}
// Add links after description
print '<input class="flat" type="text" size="6" name="search_amount" value="' . $search_amount . '">';
print '</td>';
print '<td class="liste_titre" align="right"><input type="image" class="liste_titre" name="button_search" src="' . img_picto($langs->trans("Search"), 'search.png', '', '', 1) . '" value="' . dol_escape_htmltag($langs->trans("Search")) . '" title="' . dol_escape_htmltag($langs->trans("Search")) . '">';
print '<input type="image" class="liste_titre" name="button_removefilter" src="' . img_picto($langs->trans("Search"), 'searchclear.png', '', '', 1) . '" value="' . dol_escape_htmltag($langs->trans("RemoveFilter")) . '" title="' . dol_escape_htmltag($langs->trans("RemoveFilter")) . '">';
print "</td></tr>\n";
$var = true;
while ($i < min($num, $limit)) {
$objp = $db->fetch_object($resql);
$var = !$var;
print "<tr " . $bc[$var] . ">";
// Num ref cheque
print '<td width="80">';
$checkdepositstatic->id = $objp->rowid;
$checkdepositstatic->ref = $objp->ref ? $objp->ref : $objp->rowid;
$checkdepositstatic->statut = $objp->statut;
print $checkdepositstatic->getNomUrl(1);
print '</td>';
// Date
print '<td align="center">' . dol_print_date($db->jdate($objp->dp), 'day') . '</td>';
// TODO Use date hour
// Bank
print '<td>';
if ($objp->bid) {
print '<a href="' . DOL_URL_ROOT . '/compta/bank/account.php?account=' . $objp->bid . '">' . img_object($langs->trans("ShowAccount"), 'account') . ' ' . $objp->label . '</a>';
} else {
print ' ';
}
print '</td>';
// Number of cheques
print '<td align="right">' . $objp->nbcheque . '</td>';
// Amount
print '<td>' . $langs->trans('BankAccount') . '</td>';
print '<td colspan="3">';
$accountstatic = new Account($db);
$accountstatic->id = $bankline->fk_account;
$accountstatic->label = $bankline->bank_account_ref . ' - ' . $bankline->bank_account_label;
print $accountstatic->getNomUrl(0);
print '</td>';
print '</tr>';
if ($object->type_code == 'CHQ' && $bankline->fk_bordereau > 0) {
dol_include_once('/compta/paiement/cheque/class/remisecheque.class.php');
$bordereau = new RemiseCheque($db);
$bordereau->fetch($bankline->fk_bordereau);
print '<tr>';
print '<td>' . $langs->trans('CheckReceipt') . '</td>';
print '<td colspan="3">';
print $bordereau->getNomUrl(1);
print '</td>';
print '</tr>';
}
}
}
print '</table>';
/*
* List of invoices
*/
$disable_delete = 0;
$sql = 'SELECT f.rowid as facid, f.facnumber, f.type, f.total_ttc, f.paye, f.fk_statut, pf.amount, s.nom as name, s.rowid as socid';
$sql .= ' FROM ' . MAIN_DB_PREFIX . 'paiement_facture as pf,' . MAIN_DB_PREFIX . 'facture as f,' . MAIN_DB_PREFIX . 'societe as s';
$sql .= ' WHERE pf.fk_facture = f.rowid';
$sql .= ' AND f.fk_soc = s.rowid';
$sql .= ' AND f.entity = ' . $conf->entity;
print '<td>' . $langs->trans("Date") . "</td>";
print '<td>' . $langs->trans("Account") . '</td>';
print '<td align="right">' . $langs->trans("NbOfCheques") . '</td>';
print '<td align="right">' . $langs->trans("Amount") . '</td>';
print '<td align="right">' . $langs->trans("Status") . '</td>';
print "</tr>\n";
$var = true;
while ($objp = $db->fetch_object($resql)) {
$checkdepositstatic->id = $objp->rowid;
$checkdepositstatic->ref = $objp->ref ? $objp->ref : $objp->rowid;
$checkdepositstatic->statut = $objp->statut;
$accountstatic->id = $objp->bid;
$accountstatic->label = $objp->label;
$var = !$var;
print "<tr {$bc[$var]}>\n";
print '<td>' . $checkdepositstatic->getNomUrl(1) . '</td>';
print '<td>' . dol_print_date($db->jdate($objp->db), 'day') . '</td>';
print '<td>' . $accountstatic->getNomUrl(1) . '</td>';
print '<td align="right">' . $objp->nbcheque . '</td>';
print '<td align="right">' . price($objp->amount) . '</td>';
print '<td align="right">' . $checkdepositstatic->LibStatut($objp->statut, 3) . '</td>';
print '</tr>';
}
print "</table>";
$db->free($resql);
} else {
dol_print_error($db);
}
print "</td></tr>\n";
print "</table>\n";
$db->close();
}
$rowspan = 0;
//$user->rights->banque->modifier=false;
//$user->rights->banque->consolidate=true;
// Type of payment / Number
print "<tr><td>" . $langs->trans("Type") . " / " . $langs->trans("Numero");
print "</td>";
if ($user->rights->banque->modifier || $user->rights->banque->consolidate) {
print '<td colspan="3">';
$form->select_types_paiements($objp->fk_type, "value", '', 2);
print '<input type="text" class="flat" name="num_chq" value="' . (empty($objp->num_chq) ? '' : $objp->num_chq) . '">';
if ($objp->receiptid) {
include_once DOL_DOCUMENT_ROOT . '/compta/paiement/cheque/class/remisecheque.class.php';
$receipt = new RemiseCheque($db);
$receipt->fetch($objp->receiptid);
print ' ' . $langs->trans("CheckReceipt") . ': ' . $receipt->getNomUrl(2);
}
print '</td>';
$rowspan = 7;
print '<td align="center" rowspan="' . $rowspan . '" width="20%"><input type="submit" class="button" value="' . $langs->trans("Update") . '">';
print '</td>';
} else {
print '<td colspan="4">' . $objp->fk_type . ' ' . $objp->num_chq . '</td>';
}
print "</tr>";
// Bank of cheque
print "<tr><td>" . $langs->trans("Bank") . "</td>";
if ($user->rights->banque->modifier || $user->rights->banque->consolidate) {
print '<td colspan="3">';
print '<input type="text" class="flat" size="40" name="banque" value="' . (empty($objp->banque) ? '' : $objp->banque) . '">';
print '</td>';
