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] . ">";