print '<br><input type="checkbox" name="option" value="late"' . ($option == 'late' ? ' checked' : '') . '> ' . $langs->trans("Late");
print '</td>';
print '<td class="liste_titre" align="left"><input class="flat" type="text" size="8" name="search_societe" value="' . $search_societe . '"></td>';
print '<td class="liste_titre" align="left">';
$form->select_types_paiements($search_paymentmode, 'search_paymentmode', '', 0, 0, 1, 10);
print '</td>';
print '<td class="liste_titre" align="right"><input class="flat" type="text" size="6" name="search_montant_ht" value="' . $search_montant_ht . '"></td>';
print '<td class="liste_titre"></td>';
print '<td class="liste_titre" align="right"><input class="flat" type="text" size="6" name="search_montant_ttc" value="' . $search_montant_ttc . '"></td>';
print '<td class="liste_titre"></td>';
print '<td class="liste_titre" align="right">';
$liststatus = array('0' => $langs->trans("BillShortStatusDraft"), '1' => $langs->trans("BillShortStatusNotPaid"), '2' => $langs->trans("BillShortStatusPaid"), '3' => $langs->trans("BillShortStatusCanceled"));
print $form->selectarray('search_status', $liststatus, $search_status, 1);
print '</td>';
print '<td class="liste_titre" align="center">';
$searchpitco = $form->showFilterAndCheckAddButtons(1, 'checkforselect', 1);
print $searchpitco;
print '</td>';
print "</tr>\n";
if ($num > 0) {
$var = true;
$total_ht = 0;
$total_tva = 0;
$total_ttc = 0;
$totalrecu = 0;
while ($i < min($num, $limit)) {
$objp = $db->fetch_object($resql);
$var = !$var;
$datelimit = $db->jdate($objp->datelimite);
print '<tr ' . $bc[$var] . '>';
print '<td class="nowrap">';
$period_filter .= $langs->trans('to') . ' ' . $form->select_date($req_enddt, 'req_enddt', 0, 0, 1, null, 1, 1, 1);
print '<tr class="liste_titre">';
print '<td colspan="2">' . $period_filter . '</td>';
print '<td>';
//$filtertype=array('TIP'=>'TIP','PRE'=>'PRE',...)
$filtertype = '';
$form->select_types_paiements($paiementtype, 'paiementtype', $filtertype, 2, 1, 1, 8);
print '</td>';
print '<td><input type="text" class="flat" name="req_nb" value="' . $req_nb . '" size="2"></td>';
print '<td><input type="text" class="flat" name="req_desc" value="' . $req_desc . '" size="24"></td>';
print '<td><input type="text" class="flat" name="thirdparty" value="' . $thirdparty . '" size="14"></td>';
print '<td align="right"><input type="text" class="flat" name="req_debit" value="' . $req_debit . '" size="4"></td>';
print '<td align="right"><input type="text" class="flat" name="req_credit" value="' . $req_credit . '" size="4"></td>';
print '<td align="center"> </td>';
print '<td class="liste_titre" align="right">';
$searchpitco = $form->showFilterAndCheckAddButtons(0);
print $searchpitco;
print '</td>';
print "</tr>\n";
/*
* Another solution
* create temporary table solde type=heap select amount from llx_bank limit 100 ;
* select sum(amount) from solde ;
*/
$sql = "SELECT b.rowid, b.dateo as do, b.datev as dv,";
$sql .= " b.amount, b.label, b.rappro, b.num_releve, b.num_chq, b.fk_type, b.fk_bordereau,";
$sql .= " ba.rowid as bankid, ba.ref as bankref, ba.label as banklabel";
if ($mode_search) {
$sql .= ", s.rowid as socid, s.nom as thirdparty";
}
/*
print '</td>';
print '<td class="liste_titre" align="left"><input class="flat" type="text" size="10" name="search_societe" value="' . dol_escape_htmltag($search_societe) . '"></td>';
print '<td class="liste_titre" align="left">';
$form->select_types_paiements($search_paymentmode, 'search_paymentmode', '', 0, 0, 1);
print '</td>';
print '<td class="liste_titre" align="right"><input class="flat" type="text" size="8" name="search_montant_ht" value="' . dol_escape_htmltag($search_montant_ht) . '"></td>';
print '<td class="liste_titre"> </td>';
print '<td class="liste_titre" align="right"><input class="flat" type="text" size="8" name="search_montant_ttc" value="' . dol_escape_htmltag($search_montant_ttc) . '"></td>';
print '<td class="liste_titre"> </td>';
print '<td class="liste_titre"> </td>';
print '<td class="liste_titre" align="right">';
$liststatus = array('paye:0' => $langs->trans("Unpaid"), 'paye:1' => $langs->trans("Paid"));
print $form->selectarray('filtre', $liststatus, $filter, 1);
print '</td>';
print '<td class="liste_titre" align="center">';
$searchpitco = $form->showFilterAndCheckAddButtons(1, empty($mode) ? 'checkformerge' : 'checkforsend');
print $searchpitco;
print '</td>';
print "</tr>\n";
if ($num > 0) {
$var = true;
$total_ht = 0;
$total_tva = 0;
$total_ttc = 0;
$total_paid = 0;
$facturestatic = new Facture($db);
while ($i < $num) {
$objp = $db->fetch_object($resql);
$date_limit = $db->jdate($objp->datelimite);
$var = !$var;
print "<tr " . $bc[$var] . ">";
