Go to the documentation of this file.
25 require
'../../main.inc.php';
28 $langs->load(
"bills");
31 if ($user->socid > 0) {
33 $socid = $user->socid;
37 $limit =
GETPOST(
'limit',
'int') ?
GETPOST(
'limit',
'int') : $conf->liste_limit;
38 $sortfield =
GETPOST(
'sortfield',
'aZ09comma');
39 $sortorder =
GETPOST(
'sortorder',
'aZ09comma');
41 if (empty($page) || $page == -1) {
44 $offset = $limit * $page;
45 $pageprev = $page - 1;
46 $pagenext = $page + 1;
51 $sortfield =
"p.rowid";
55 if (empty($user->rights->facture->lire)) {
72 $sql =
"SELECT p.rowid, p.datep as dp, p.amount, p.statut";
73 $sql .=
", c.libelle as paiement_type, p.num_paiement as num_payment";
74 $sql .=
" FROM ".MAIN_DB_PREFIX.
"paiement as p LEFT JOIN ".MAIN_DB_PREFIX.
"c_paiement as c ON p.fk_paiement = c.id";
76 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"paiement_facture as pf ON p.rowid = pf.fk_paiement";
77 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"facture as f ON pf.fk_facture = f.rowid";
79 $sql .=
" WHERE p.entity IN (".getEntity(
'invoice').
')';
81 $sql .=
" AND f.fk_soc = ".((int) $socid);
83 $sql .=
" AND p.statut = 0";
85 $sql .= $db->order($sortfield, $sortorder);
88 $nbtotalofrecords =
'';
89 if (empty($conf->global->MAIN_DISABLE_FULL_SCANLIST)) {
90 $result = $db->query($sql);
91 $nbtotalofrecords = $db->num_rows($result);
92 if (($page * $limit) > $nbtotalofrecords) {
98 $sql .= $db->plimit($limit + 1, $offset);
100 $resql = $db->query($sql);
102 $num = $db->num_rows(
$resql);
105 print_barre_liste($langs->trans(
"ReceivedCustomersPaymentsToValid"), $page, $_SERVER[
"PHP_SELF"],
"", $sortfield, $sortorder,
'', $num);
107 print
'<table class="noborder centpercent">';
108 print
'<tr class="liste_titre">';
110 print_liste_field_titre(
"Date", $_SERVER[
"PHP_SELF"],
"dp",
"",
"",
'width="80" align="center"', $sortfield, $sortorder);
112 print_liste_field_titre(
"AmountTTC", $_SERVER[
"PHP_SELF"],
"c.libelle",
"",
"",
'class="right"', $sortfield, $sortorder);
116 while ($i < min($num, $limit)) {
117 $objp = $db->fetch_object(
$resql);
119 print
'<tr class="oddeven">';
120 print
'<td><a href="'.DOL_URL_ROOT.
'/compta/paiement/card.php?id='.$objp->rowid.
'">'.
img_object($langs->trans(
"ShowPayment"),
"payment").
' '.$objp->rowid.
'</a></td>';
121 print
'<td width="80" align="center">'.dol_print_date($db->jdate($objp->dp),
'day').
"</td>\n";
122 print
"<td>$objp->paiement_type $objp->num_payment</td>\n";
123 print
'<td class="right"><span class="amount">'.price($objp->amount).
'</span></td>';
124 print
'<td class="center">';
126 if ($objp->statut == 0) {
127 print
'<a href="card.php?id='.$objp->rowid.
'&action=valide">'.$langs->trans(
"PaymentStatusToValidShort").
'</a>';
GETPOST($paramname, $check='alphanohtml', $method=0, $filter=null, $options=null, $noreplace=0)
Return value of a param into GET or POST supervariable.
print_barre_liste($titre, $page, $file, $options='', $sortfield='', $sortorder='', $morehtmlcenter='', $num=-1, $totalnboflines='', $picto='generic', $pictoisfullpath=0, $morehtmlright='', $morecss='', $limit=-1, $hideselectlimit=0, $hidenavigation=0, $pagenavastextinput=0, $morehtmlrightbeforearrow='')
Print a title with navigation controls for pagination.
GETPOSTISSET($paramname)
Return true if we are in a context of submitting the parameter $paramname from a POST of a form.
print_liste_field_titre($name, $file="", $field="", $begin="", $moreparam="", $moreattrib="", $sortfield="", $sortorder="", $prefix="", $tooltip="", $forcenowrapcolumntitle=0)
Show title line of an array.
img_object($titlealt, $picto, $moreatt='', $pictoisfullpath=false, $srconly=0, $notitle=0)
Show a picto called object_picto (generic function)
if(isModEnabled('facture') &&!empty($user->rights->facture->lire)) if((isModEnabled('fournisseur') &&empty($conf->global->MAIN_USE_NEW_SUPPLIERMOD) && $user->rights->fournisseur->facture->lire)||(isModEnabled('supplier_invoice') && $user->rights->supplier_invoice->lire)) if(isModEnabled('don') &&!empty($user->rights->don->lire)) if(isModEnabled('tax') &&!empty($user->rights->tax->charges->lire)) if(isModEnabled('facture') &&isModEnabled('commande') && $user->rights->commande->lire &&empty($conf->global->WORKFLOW_DISABLE_CREATE_INVOICE_FROM_ORDER)) $resql
Social contributions to pay.
accessforbidden($message='', $printheader=1, $printfooter=1, $showonlymessage=0, $params=null)
Show a message to say access is forbidden and stop program Calling this function terminate execution ...
if(!defined('NOREQUIRESOC')) if(!defined('NOREQUIRETRAN')) if(!defined('NOCSRFCHECK')) if(!defined('NOTOKENRENEWAL')) if(!defined('NOREQUIREMENU')) if(!defined('NOREQUIREHTML')) if(!defined('NOREQUIREAJAX')) llxHeader()
Empty header.