27 require
'../../../main.inc.php';
28 require_once DOL_DOCUMENT_ROOT.
'/compta/paiement/cheque/class/remisecheque.class.php';
29 require_once DOL_DOCUMENT_ROOT.
'/compta/bank/class/account.class.php';
32 $langs->loadLangs(array(
'banks',
'categories',
'compta',
'bills'));
36 $socid = $user->socid;
42 $accountstatic =
new Account($db);
49 llxHeader(
'', $langs->trans(
"ChequesArea"));
51 print
load_fiche_titre($langs->trans(
"ChequesArea"),
'', $checkdepositstatic->picto);
53 print
'<div class="fichecenter"><div class="fichethirdleft">';
55 $sql =
"SELECT count(b.rowid)";
56 $sql .=
" FROM ".MAIN_DB_PREFIX.
"bank as b";
57 $sql .=
", ".MAIN_DB_PREFIX.
"bank_account as ba";
58 $sql .=
" WHERE ba.rowid = b.fk_account";
59 $sql .=
" AND ba.entity IN (".getEntity(
'bank_account').
")";
60 $sql .=
" AND b.fk_type = 'CHQ'";
61 $sql .=
" AND b.fk_bordereau = 0";
62 $sql .=
" AND b.amount > 0";
66 print
'<table class="noborder centpercent">';
67 print
'<tr class="liste_titre">';
68 print
'<th colspan="2">'.$langs->trans(
"BankChecks").
"</th>\n";
72 if ($row = $db->fetch_row(
$resql)) {
75 print
'<tr class="oddeven">';
76 print
'<td>'.$langs->trans(
"BankChecksToReceipt").
'</td>';
77 print
'<td class="right">';
78 print
'<a href="'.DOL_URL_ROOT.
'/compta/paiement/cheque/card.php?leftmenu=customers_bills_checks&action=new">'.$num.
'</a>';
86 print
'</div><div class="fichetwothirdright">';
90 $sql =
"SELECT bc.rowid, bc.date_bordereau as db, bc.amount, bc.ref as ref,";
91 $sql .=
" bc.statut, bc.nbcheque,";
92 $sql .=
" ba.ref as bref, ba.label, ba.rowid as bid, ba.number, ba.currency_code, ba.account_number, ba.fk_accountancy_journal,";
94 $sql .=
" FROM ".MAIN_DB_PREFIX.
"bordereau_cheque as bc, ".MAIN_DB_PREFIX.
"bank_account as ba";
95 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"accounting_journal as aj ON aj.rowid = ba.fk_accountancy_journal";
96 $sql .=
" WHERE ba.rowid = bc.fk_bank_account";
97 $sql .=
" AND bc.entity = ".$conf->entity;
98 $sql .=
" ORDER BY bc.date_bordereau DESC, rowid DESC";
99 $sql .= $db->plimit($max);
101 $resql = $db->query($sql);
103 print
'<div class="div-table-responsive-no-min">';
104 print
'<table class="noborder centpercent">';
105 print
'<tr class="liste_titre">';
106 print
'<th>'.$langs->trans(
"LastCheckReceiptShort", $max).
'</th>';
107 print
'<th>'.$langs->trans(
"Date").
"</th>";
108 print
'<th>'.$langs->trans(
"Account").
'</th>';
109 print
'<th class="right">'.$langs->trans(
"NbOfCheques").
'</th>';
110 print
'<th class="right">'.$langs->trans(
"Amount").
'</th>';
111 print
'<th class="right">'.$langs->trans(
"Status").
'</th>';
114 while ($objp = $db->fetch_object(
$resql)) {
115 $checkdepositstatic->id = $objp->rowid;
116 $checkdepositstatic->ref = ($objp->ref ? $objp->ref : $objp->rowid);
117 $checkdepositstatic->statut = $objp->statut;
119 $accountstatic->id = $objp->bid;
120 $accountstatic->ref = $objp->bref;
121 $accountstatic->label = $objp->label;
122 $accountstatic->number = $objp->number;
123 $accountstatic->currency_code = $objp->currency_code;
124 $accountstatic->account_number = $objp->account_number;
125 $accountstatic->accountancy_journal = $objp->code;
126 $accountstatic->fk_accountancy_journal = $objp->fk_accountancy_journal;
128 print
'<tr class="oddeven">'.
"\n";
130 print
'<td class="nowraponall">'.$checkdepositstatic->getNomUrl(1).
'</td>';
131 print
'<td>'.dol_print_date($db->jdate($objp->db),
'day').
'</td>';
132 print
'<td class="nowraponall">'.$accountstatic->getNomUrl(1).
'</td>';
133 print
'<td class="right">'.$objp->nbcheque.
'</td>';
134 print
'<td class="right"><span class="amount">'.price($objp->amount).
'</span></td>';
135 print
'<td class="right">'.$checkdepositstatic->LibStatut($objp->statut, 3).
'</td>';
148 print
'</div></div>';