33 require
'../../main.inc.php';
34 require_once DOL_DOCUMENT_ROOT.
'/compta/paiement/class/paiement.class.php';
35 require_once DOL_DOCUMENT_ROOT.
'/compta/bank/class/account.class.php';
36 require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formother.class.php';
37 require_once DOL_DOCUMENT_ROOT.
'/core/lib/date.lib.php';
38 require_once DOL_DOCUMENT_ROOT.
'/accountancy/class/accountingjournal.class.php';
41 $langs->loadLangs(array(
'bills',
'banks',
'compta',
'companies'));
43 $action =
GETPOST(
'action',
'alpha');
44 $massaction =
GETPOST(
'massaction',
'alpha');
45 $confirm =
GETPOST(
'confirm',
'alpha');
46 $optioncss =
GETPOST(
'optioncss',
'alpha');
47 $contextpage =
GETPOST(
'contextpage',
'aZ') ?
GETPOST(
'contextpage',
'aZ') :
'paymentlist';
49 $facid =
GETPOST(
'facid',
'int');
50 $socid =
GETPOST(
'socid',
'int');
51 $userid =
GETPOST(
'userid',
'int');
54 if ($user->socid) $socid = $user->socid;
57 $search_ref =
GETPOST(
"search_ref",
"alpha");
58 $search_date_startday =
GETPOST(
'search_date_startday',
'int');
59 $search_date_startmonth =
GETPOST(
'search_date_startmonth',
'int');
60 $search_date_startyear =
GETPOST(
'search_date_startyear',
'int');
61 $search_date_endday =
GETPOST(
'search_date_endday',
'int');
62 $search_date_endmonth =
GETPOST(
'search_date_endmonth',
'int');
63 $search_date_endyear =
GETPOST(
'search_date_endyear',
'int');
64 $search_date_start =
dol_mktime(0, 0, 0, $search_date_startmonth, $search_date_startday, $search_date_startyear);
65 $search_date_end =
dol_mktime(23, 59, 59, $search_date_endmonth, $search_date_endday, $search_date_endyear);
66 $search_company =
GETPOST(
"search_company",
'alpha');
67 $search_paymenttype =
GETPOST(
"search_paymenttype");
68 $search_account =
GETPOST(
"search_account",
"int");
69 $search_payment_num =
GETPOST(
'search_payment_num',
'alpha');
70 $search_amount =
GETPOST(
"search_amount",
'alpha');
71 $search_status =
GETPOST(
'search_status',
'intcomma');
73 $limit =
GETPOST(
'limit',
'int') ?
GETPOST(
'limit',
'int') : $conf->liste_limit;
74 $sortfield =
GETPOST(
'sortfield',
'aZ09comma');
75 $sortorder =
GETPOST(
'sortorder',
'aZ09comma');
78 if (empty($page) || $page == -1) {
81 $offset = $limit * $page;
82 $pageprev = $page - 1;
83 $pagenext = $page + 1;
95 $fieldstosearchall = array(
96 'p.ref'=>
"RefPayment",
97 's.nom'=>
"ThirdParty",
98 'p.num_paiement'=>
"Numero",
102 $arrayfields = array(
103 'p.ref' => array(
'label'=>
"RefPayment",
'checked'=>1,
'position'=>10),
104 'p.datep' => array(
'label'=>
"Date",
'checked'=>1,
'position'=>20),
105 's.nom' => array(
'label'=>
"ThirdParty",
'checked'=>1,
'position'=>30),
106 'c.libelle' => array(
'label'=>
"Type",
'checked'=>1,
'position'=>40),
107 'transaction' => array(
'label'=>
"BankTransactionLine",
'checked'=>1,
'position'=>50,
'enabled'=>
isModEnabled(
'banque')),
108 'ba.label' => array(
'label'=>
"Account",
'checked'=>1,
'position'=>60,
'enabled'=>(
isModEnabled(
'banque'))),
109 'p.num_paiement' => array(
'label'=>
"Numero",
'checked'=>1,
'position'=>70,
'tooltip'=>
"ChequeOrTransferNumber"),
110 'p.amount' => array(
'label'=>
"Amount",
'checked'=>1,
'position'=>80),
111 'p.statut' => array(
'label'=>
"Status",
'checked'=>1,
'position'=>90,
'enabled'=>(!empty($conf->global->BILL_ADD_PAYMENT_VALIDATION))),
116 $hookmanager->initHooks(array(
'paymentlist'));
123 $parameters = array(
'socid'=>$socid);
124 $reshook = $hookmanager->executeHooks(
'doActions', $parameters, $object, $action);
130 if (empty($reshook)) {
131 include DOL_DOCUMENT_ROOT.
'/core/actions_changeselectedfields.inc.php';
134 if (
GETPOST(
'button_removefilter_x',
'alpha') ||
GETPOST(
'button_removefilter.x',
'alpha') ||
GETPOST(
'button_removefilter',
'alpha')) {
136 $search_date_startday =
'';
137 $search_date_startmonth =
'';
138 $search_date_startyear =
'';
139 $search_date_endday =
'';
140 $search_date_endmonth =
'';
141 $search_date_endyear =
'';
142 $search_date_start =
'';
143 $search_date_end =
'';
144 $search_account =
'';
146 $search_paymenttype =
'';
147 $search_payment_num =
'';
148 $search_company =
'';
152 $search_array_options = array();
162 $accountstatic =
new Account($db);
163 $companystatic =
new Societe($db);
166 llxHeader(
'', $langs->trans(
'ListPayment'));
168 if (
GETPOST(
"orphelins",
"alpha")) {
170 $sql =
"SELECT p.rowid, p.ref, p.datep, p.amount, p.statut, p.num_paiement";
171 $sql .=
", c.code as paiement_code";
174 $parameters = array();
175 $reshook = $hookmanager->executeHooks(
'printFieldListSelect', $parameters);
176 $sql .= $hookmanager->resPrint;
177 $sql .=
" FROM ".MAIN_DB_PREFIX.
"paiement as p LEFT JOIN ".MAIN_DB_PREFIX.
"c_paiement as c ON p.fk_paiement = c.id";
178 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"paiement_facture as pf ON p.rowid = pf.fk_paiement";
179 $sql .=
" WHERE p.entity IN (".getEntity(
'invoice').
")";
180 $sql .=
" AND pf.fk_facture IS NULL";
183 $parameters = array();
184 $reshook = $hookmanager->executeHooks(
'printFieldListWhere', $parameters);
185 $sql .= $hookmanager->resPrint;
188 $sql =
"SELECT DISTINCT p.rowid, p.ref, p.datep, p.fk_bank, p.amount, p.statut, p.num_paiement";
189 $sql .=
", c.code as paiement_code";
190 $sql .=
", ba.rowid as bid, ba.ref as bref, ba.label as blabel, ba.number, ba.account_number as account_number, ba.fk_accountancy_journal as accountancy_journal";
191 $sql .=
", s.rowid as socid, s.nom as name, s.email";
194 $parameters = array();
195 $reshook = $hookmanager->executeHooks(
'printFieldListSelect', $parameters);
196 $sql .= $hookmanager->resPrint;
197 $sql .=
" FROM ".MAIN_DB_PREFIX.
"paiement as p";
198 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"c_paiement as c ON p.fk_paiement = c.id";
199 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"bank as b ON p.fk_bank = b.rowid";
200 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"bank_account as ba ON b.fk_account = ba.rowid";
201 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"paiement_facture as pf ON p.rowid = pf.fk_paiement";
202 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"facture as f ON pf.fk_facture = f.rowid";
203 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"societe as s ON f.fk_soc = s.rowid";
204 if (empty($user->rights->societe->client->voir) && !$socid) {
205 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"societe_commerciaux as sc ON s.rowid = sc.fk_soc";
207 $sql .=
" WHERE p.entity IN (".getEntity(
'invoice').
")";
208 if (empty($user->rights->societe->client->voir) && !$socid) {
209 $sql .=
" AND sc.fk_user = ".((int) $user->id);
212 $sql .=
" AND f.fk_soc = ".((int) $socid);
216 $sql .=
" AND f.fk_user_author IS NULL";
218 $sql .=
" AND f.fk_user_author = ".((int) $userid);
226 if ($search_date_start) {
227 $sql .=
" AND p.datep >= '" . $db->idate($search_date_start) .
"'";
229 if ($search_date_end) {
230 $sql .=
" AND p.datep <= '" . $db->idate($search_date_end) .
"'";
232 if ($search_account > 0) {
233 $sql .=
" AND b.fk_account=".((int) $search_account);
235 if ($search_paymenttype !=
'') {
236 $sql .=
" AND c.code='".$db->escape($search_paymenttype).
"'";
238 if ($search_payment_num !=
'') {
241 if ($search_amount) {
244 if ($search_company) {
249 $sql .=
natural_search(array_keys($fieldstosearchall), $search_all);
253 $parameters = array();
254 $reshook = $hookmanager->executeHooks(
'printFieldListWhere', $parameters);
255 $sql .= $hookmanager->resPrint;
257 $sql .= $db->order($sortfield, $sortorder);
259 $nbtotalofrecords =
'';
260 if (empty($conf->global->MAIN_DISABLE_FULL_SCANLIST)) {
261 $result = $db->query($sql);
262 $nbtotalofrecords = $db->num_rows($result);
265 if (($page * $limit) > $nbtotalofrecords) {
271 $sql .= $db->plimit($limit + 1, $offset);
273 $resql = $db->query($sql);
281 $num = $db->num_rows(
$resql);
284 if (!empty($contextpage) && $contextpage != $_SERVER[
"PHP_SELF"]) {
285 $param .=
'&contextpage='.urlencode($contextpage);
287 if ($limit > 0 && $limit != $conf->liste_limit) {
288 $param .=
'&limit='.urlencode($limit);
292 $param .=
'&orphelins=1';
295 $param .=
'&search_ref='.urlencode($search_ref);
297 if ($search_date_startday) {
298 $param .=
'&search_date_startday='.urlencode($search_date_startday);
300 if ($search_date_startmonth) {
301 $param .=
'&search_date_startmonth='.urlencode($search_date_startmonth);
303 if ($search_date_startyear) {
304 $param .=
'&search_date_startyear='.urlencode($search_date_startyear);
306 if ($search_date_endday) {
307 $param .=
'&search_date_endday='.urlencode($search_date_endday);
309 if ($search_date_endmonth) {
310 $param .=
'&search_date_endmonth='.urlencode($search_date_endmonth);
312 if ($search_date_endyear) {
313 $param .=
'&search_date_endyear='.urlencode($search_date_endyear);
315 if ($search_company) {
316 $param .=
'&search_company='.urlencode($search_company);
318 if ($search_amount !=
'') {
319 $param .=
'&search_amount='.urlencode($search_amount);
321 if ($search_paymenttype) {
322 $param .=
'&search_paymenttype='.urlencode($search_paymenttype);
324 if ($search_account) {
325 $param .=
'&search_account='.urlencode($search_account);
327 if ($search_payment_num) {
328 $param .=
'&search_payment_num='.urlencode($search_payment_num);
330 if ($optioncss !=
'') {
331 $param .=
'&optioncss='.urlencode($optioncss);
334 print
'<form method="POST" action="'.$_SERVER[
"PHP_SELF"].
'">';
335 if ($optioncss !=
'') {
336 print
'<input type="hidden" name="optioncss" value="'.$optioncss.
'">';
338 print
'<input type="hidden" name="token" value="'.newToken().
'">';
339 print
'<input type="hidden" name="action" value="list">';
340 print
'<input type="hidden" name="formfilteraction" id="formfilteraction" value="list">';
341 print
'<input type="hidden" name="sortfield" value="'.$sortfield.
'">';
342 print
'<input type="hidden" name="sortorder" value="'.$sortorder.
'">';
343 print
'<input type="hidden" name="contextpage" value="'.$contextpage.
'">';
345 print_barre_liste($langs->trans(
"ReceivedCustomersPayments"), $page, $_SERVER[
"PHP_SELF"], $param, $sortfield, $sortorder,
'', $num, $nbtotalofrecords,
'bill', 0,
'',
'', $limit, 0, 0, 1);
348 foreach ($fieldstosearchall as $key => $val) {
349 $fieldstosearchall[$key] = $langs->trans($val);
351 print
'<div class="divsearchfieldfilter">'.$langs->trans(
"FilterOnInto", $search_all).join(
', ', $fieldstosearchall).
'</div>';
354 $varpage = empty($contextpage) ? $_SERVER[
"PHP_SELF"] : $contextpage;
355 $selectedfields =
$form->multiSelectArrayWithCheckbox(
'selectedfields', $arrayfields, $varpage);
356 $massactionbutton =
'';
357 if ($massactionbutton) {
358 $selectedfields .=
$form->showCheckAddButtons(
'checkforselect', 1);
362 print
'<div class="div-table-responsive">';
363 print
'<table class="tagtable liste'.($moreforfilter ?
" listwithfilterbefore" :
'').
'">';
365 print
'<tr class="liste_titre_filter">';
368 print
'<tr class="liste_titre_filter">';
369 if (!empty($conf->global->MAIN_VIEW_LINE_NUMBER_IN_LIST)) {
370 print
'<td class="liste_titre">';
375 if (!empty($arrayfields[
'p.ref'][
'checked'])) {
376 print
'<td class="liste_titre left">';
377 print
'<input class="flat" type="text" size="4" name="search_ref" value="'.dol_escape_htmltag($search_ref).
'">';
382 if (!empty($arrayfields[
'p.datep'][
'checked'])) {
383 print
'<td class="liste_titre center">';
384 print
'<div class="nowrap">';
385 print
$form->selectDate($search_date_start ? $search_date_start : -1,
'search_date_start', 0, 0, 1,
'', 1, 0, 0,
'',
'',
'',
'', 1,
'', $langs->trans(
'From'));
387 print
'<div class="nowrap">';
388 print
$form->selectDate($search_date_end ? $search_date_end : -1,
'search_date_end', 0, 0, 1,
'', 1, 0, 0,
'',
'',
'',
'', 1,
'', $langs->trans(
'to'));
394 if (!empty($arrayfields[
's.nom'][
'checked'])) {
395 print
'<td class="liste_titre">';
396 print
'<input class="flat" type="text" size="6" name="search_company" value="'.dol_escape_htmltag($search_company).
'">';
401 if (!empty($arrayfields[
'c.libelle'][
'checked'])) {
402 print
'<td class="liste_titre">';
403 $form->select_types_paiements($search_paymenttype,
'search_paymenttype',
'', 2, 1, 1);
408 if (!empty($arrayfields[
'transaction'][
'checked'])) {
409 print
'<td class="liste_titre">';
410 print
'<input class="flat" type="text" size="4" name="search_payment_num" value="'.dol_escape_htmltag($search_payment_num).
'">';
415 if (!empty($arrayfields[
'p.num_paiement'][
'checked'])) {
416 print
'<td class="liste_titre">';
421 if (!empty($arrayfields[
'ba.label'][
'checked'])) {
422 print
'<td class="liste_titre">';
423 $form->select_comptes($search_account,
'search_account', 0,
'', 1);
428 if (!empty($arrayfields[
'p.amount'][
'checked'])) {
429 print
'<td class="liste_titre right">';
430 print
'<input class="flat" type="text" size="4" name="search_amount" value="'.dol_escape_htmltag($search_amount).
'">';
435 if (!empty($arrayfields[
'p.statut'][
'checked'])) {
436 print
'<td class="liste_titre right">';
441 $parameters = array(
'arrayfields'=>$arrayfields);
442 $reshook = $hookmanager->executeHooks(
'printFieldListOption', $parameters);
443 print $hookmanager->resPrint;
445 print
'<td class="liste_titre maxwidthsearch">';
446 print
$form->showFilterAndCheckAddButtons(0);
451 print
'<tr class="liste_titre">';
452 if (!empty($conf->global->MAIN_VIEW_LINE_NUMBER_IN_LIST)) {
455 if (!empty($arrayfields[
'p.ref'][
'checked'])) {
456 print_liste_field_titre($arrayfields[
'p.ref'][
'label'], $_SERVER[
"PHP_SELF"],
"p.ref",
'', $param,
'', $sortfield, $sortorder);
458 if (!empty($arrayfields[
'p.datep'][
'checked'])) {
459 print_liste_field_titre($arrayfields[
'p.datep'][
'label'], $_SERVER[
"PHP_SELF"],
"p.datep",
'', $param,
'', $sortfield, $sortorder,
'center ');
461 if (!empty($arrayfields[
's.nom'][
'checked'])) {
462 print_liste_field_titre($arrayfields[
's.nom'][
'label'], $_SERVER[
"PHP_SELF"],
"s.nom",
'', $param,
'', $sortfield, $sortorder);
464 if (!empty($arrayfields[
'c.libelle'][
'checked'])) {
465 print_liste_field_titre($arrayfields[
'c.libelle'][
'label'], $_SERVER[
"PHP_SELF"],
"c.libelle",
'', $param,
'', $sortfield, $sortorder);
467 if (!empty($arrayfields[
'p.num_paiement'][
'checked'])) {
468 print_liste_field_titre($arrayfields[
'p.num_paiement'][
'label'], $_SERVER[
"PHP_SELF"],
"p.num_paiement",
'', $param,
'', $sortfield, $sortorder,
'', $arrayfields[
'p.num_paiement'][
'tooltip']);
470 if (!empty($arrayfields[
'transaction'][
'checked'])) {
471 print_liste_field_titre($arrayfields[
'transaction'][
'label'], $_SERVER[
"PHP_SELF"],
'',
'', $param,
'', $sortfield, $sortorder);
473 if (!empty($arrayfields[
'ba.label'][
'checked'])) {
474 print_liste_field_titre($arrayfields[
'ba.label'][
'label'], $_SERVER[
"PHP_SELF"],
"ba.label",
'', $param,
'', $sortfield, $sortorder);
476 if (!empty($arrayfields[
'p.amount'][
'checked'])) {
477 print_liste_field_titre($arrayfields[
'p.amount'][
'label'], $_SERVER[
"PHP_SELF"],
"p.amount",
'', $param,
'class="right"', $sortfield, $sortorder);
479 if (!empty($arrayfields[
'p.statut'][
'checked'])) {
480 print_liste_field_titre($arrayfields[
'p.statut'][
'label'], $_SERVER[
"PHP_SELF"],
"p.statut",
'', $param,
'class="right"', $sortfield, $sortorder);
484 $parameters = array(
'arrayfields'=>$arrayfields,
'param'=>$param,
'sortfield'=>$sortfield,
'sortorder'=>$sortorder);
485 $reshook = $hookmanager->executeHooks(
'printFieldListTitle', $parameters);
486 print $hookmanager->resPrint;
488 print_liste_field_titre($selectedfields, $_SERVER[
"PHP_SELF"],
'',
'',
'',
'align="center"', $sortfield, $sortorder,
'maxwidthsearch ');
492 foreach ($arrayfields as $column) {
493 if ($column[
'checked']) {
499 $totalarray = array();
500 while ($i < min($num, $limit)) {
501 $objp = $db->fetch_object(
$resql);
503 $object->id = $objp->rowid;
504 $object->ref = ($objp->ref ? $objp->ref : $objp->rowid);
506 $companystatic->id = $objp->socid;
507 $companystatic->name = $objp->name;
508 $companystatic->email = $objp->email;
510 print
'<tr class="oddeven">';
513 if (!empty($conf->global->MAIN_VIEW_LINE_NUMBER_IN_LIST)) {
514 print
'<td>'.(($offset * $limit) + $i).
'</td>';
516 $totalarray[
'nbfield']++;
521 if (!empty($arrayfields[
'p.ref'][
'checked'])) {
522 print
'<td>'.$object->getNomUrl(1).
'</td>';
524 $totalarray[
'nbfield']++;
529 if (!empty($arrayfields[
'p.datep'][
'checked'])) {
530 $dateformatforpayment =
'dayhour';
531 print
'<td class="center">'.dol_print_date($db->jdate($objp->datep), $dateformatforpayment,
'tzuser').
'</td>';
533 $totalarray[
'nbfield']++;
538 if (!empty($arrayfields[
's.nom'][
'checked'])) {
540 if ($objp->socid > 0) {
541 print $companystatic->getNomUrl(1,
'', 24);
545 $totalarray[
'nbfield']++;
550 if (!empty($arrayfields[
'c.libelle'][
'checked'])) {
551 print
'<td>'.$langs->trans(
"PaymentTypeShort".$objp->paiement_code).
'</td>';
553 $totalarray[
'nbfield']++;
558 if (!empty($arrayfields[
'p.num_paiement'][
'checked'])) {
559 print
'<td>'.$objp->num_paiement.
'</td>';
561 $totalarray[
'nbfield']++;
566 if (!empty($arrayfields[
'transaction'][
'checked'])) {
568 if ($objp->fk_bank > 0) {
569 $bankline->fetch($objp->fk_bank);
570 print $bankline->getNomUrl(1, 0);
574 $totalarray[
'nbfield']++;
579 if (!empty($arrayfields[
'ba.label'][
'checked'])) {
581 if ($objp->bid > 0) {
582 $accountstatic->id = $objp->bid;
583 $accountstatic->ref = $objp->bref;
584 $accountstatic->label = $objp->blabel;
585 $accountstatic->number = $objp->number;
586 $accountstatic->account_number = $objp->account_number;
589 $accountingjournal->fetch($objp->accountancy_journal);
590 $accountstatic->accountancy_journal = $accountingjournal->code;
592 print $accountstatic->getNomUrl(1);
596 $totalarray[
'nbfield']++;
601 if (!empty($arrayfields[
'p.amount'][
'checked'])) {
602 print
'<td class="right"><span class="amount">'.price($objp->amount).
'</span></td>';
604 $totalarray[
'nbfield']++;
606 $totalarray[
'pos'][$checkedCount] =
'amount';
607 $totalarray[
'val'][
'amount'] += $objp->amount;
611 if (!empty($arrayfields[
'p.statut'][
'checked'])) {
612 print
'<td class="right">';
613 if ($objp->statut == 0) {
614 print
'<a href="card.php?id='.$objp->rowid.
'&action=valide">';
616 print $object->LibStatut($objp->statut, 5);
617 if ($objp->statut == 0) {
622 $totalarray[
'nbfield']++;
629 $totalarray[
'nbfield']++;
638 include DOL_DOCUMENT_ROOT.
'/core/tpl/list_print_total.tpl.php';
643 foreach ($arrayfields as $key => $val) {
644 if (!empty($val[
'checked'])) {
648 print
'<tr><td colspan="'.$colspan.
'" class="opacitymedium">'.$langs->trans(
"NoRecordFound").
'</td></tr>';