31require
'../../main.inc.php';
40require_once DOL_DOCUMENT_ROOT.
'/compta/prelevement/class/bonprelevement.class.php';
41require_once DOL_DOCUMENT_ROOT.
'/compta/bank/class/account.class.php';
44$langs->loadLangs(array(
'banks',
'categories',
'withdrawals'));
46$action =
GETPOST(
'action',
'aZ09') ?
GETPOST(
'action',
'aZ09') :
'view';
47$massaction =
GETPOST(
'massaction',
'alpha');
48$confirm =
GETPOST(
'confirm',
'alpha');
49$cancel =
GETPOST(
'cancel',
'alpha');
50$toselect =
GETPOST(
'toselect',
'array:int');
51$contextpage =
GETPOST(
'contextpage',
'aZ') ?
GETPOST(
'contextpage',
'aZ') :
'directdebitcredittransferlist';
52$backtopage =
GETPOST(
'backtopage',
'alpha');
53$optioncss =
GETPOST(
'optioncss',
'alpha');
54$mode =
GETPOST(
'mode',
'alpha');
57$search_ref =
GETPOST(
'search_ref',
'alpha');
58$search_amount =
GETPOST(
'search_amount',
'alpha');
59$search_status =
GETPOSTISARRAY(
'search_status') ?
GETPOST(
'search_status',
'array:int') : (GETPOSTISSET(
'search_status') ?
GETPOST(
'search_status',
'array:intcomma') : array());
64$sortfield =
GETPOST(
'sortfield',
'aZ09comma');
65$sortorder =
GETPOST(
'sortorder',
'aZ09comma');
67if (empty($page) || $page < 0 ||
GETPOST(
'button_search',
'alpha') ||
GETPOST(
'button_removefilter',
'alpha')) {
71$offset = $limit * $page;
78 $sortfield =
"p.datec";
82$hookmanager->initHooks(array(
'withdrawalsreceiptslist'));
84$usercancreate = $user->hasRight(
'prelevement',
'bons',
'creer');
85$permissiontodelete = $user->hasRight(
'prelevement',
'creer');
86if ($type ==
'bank-transfer') {
87 $usercancreate = $user->hasRight(
'paymentbybanktransfer',
'create');
88 $permissiontodelete = $user->hasRight(
'paymentbybanktransfer',
'create');
94 $socid = $user->socid;
96if ($type ==
'bank-transfer') {
97 $result =
restrictedArea($user,
'paymentbybanktransfer',
'',
'',
'');
104$arrayfields = array();
105foreach (
$object->fields as $key => $val) {
107 if (!empty($val[
'visible'])) {
108 $visible = (int)
dol_eval((
string) $val[
'visible'], 1);
109 $arrayfields[$tableprefix.
'.'.$key] = array(
110 'label' => $val[
'label'],
111 'checked' => (($visible < 0) ?
'0' :
'1'),
112 'enabled' => (
string) (int) (abs($visible) != 3 && (bool)
dol_eval((
string) $val[
'enabled'], 1)),
113 'position' => $val[
'position'],
114 'help' => isset($val[
'help']) ? $val[
'help'] :
''
120include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_array_fields.tpl.php';
122$parameters = array(
'arrayfields' => &$arrayfields);
123$reshook = $hookmanager->executeHooks(
'completeArrayFields', $parameters, $object, $action);
131if (
GETPOST(
'button_removefilter_x',
'alpha') ||
GETPOST(
'button_removefilter.x',
'alpha') ||
GETPOST(
'button_removefilter',
'alpha')) {
134 $search_status = array();
140if (($massaction ==
"delete" || ($action ==
'delete' && $confirm ==
'yes')) && $permissiontodelete) {
146 foreach ($toselect as $toselectid) {
147 $result = $objecttmp->fetch($toselectid);
149 if ($objecttmp->status != $objecttmp::STATUS_DRAFT || $objecttmp->credite > 0 || $objecttmp->date_creation !=
null) {
150 $langs->load(
"errors");
152 $TMsg[] =
'<div class="error">'.$langs->trans(
'ErrorOnlyDraftStatusCanBeDeletedInMassAction', $objecttmp->ref).
'</div><br>';
155 $result = $objecttmp->delete($user);
173 } elseif ($nbok > 0) {
191$objectclass =
'BonPrelevement';
192$objectlabel =
'BonPrelevement';
193if ($type ==
'bank-transfer') {
194 $uploaddir =
$conf->paymentbybanktransfer->dir_output;
196 $uploaddir =
$conf->prelevement->dir_output;
198include DOL_DOCUMENT_ROOT.
'/core/actions_massactions.inc.php';
208$titlekey =
"WithdrawalsReceipts";
209$title = $langs->trans(
"WithdrawalsReceipts");
210if ($type ==
'bank-transfer') {
211 $titlekey =
"BankTransferReceipts";
212 $title = $langs->trans(
"BankTransferReceipts");
217$sql =
"SELECT p.rowid, p.ref, p.amount, p.statut as status, p.date_trans, p.method_trans, p.date_credit, p.fk_bank_account, p.datec, p.tms as datem";
221$sql .=
" FROM ".MAIN_DB_PREFIX.
"prelevement_bons as p";
222$sql .=
" WHERE p.entity IN (".getEntity(
'invoice').
")";
223if ($type ==
'bank-transfer') {
224 $sql .=
" AND p.type = 'bank-transfer'";
226 $sql .=
" AND p.type = 'debit-order'";
234if (is_array($search_status)) {
235 if (!empty($search_status)) {
236 $sql .=
natural_search(
"p.statut", implode(
',', $search_status), 2);
238} elseif ((
string) $search_status !=
'' && (
string) $search_status !=
'-1') {
243$nbtotalofrecords =
'';
246 $sqlforcount = preg_replace(
'/^'.preg_quote($sqlfields,
'/').
'/',
'SELECT COUNT(*) as nbtotalofrecords', $sql);
247 $sqlforcount = preg_replace(
'/GROUP BY .*$/',
'', $sqlforcount);
248 $resql =
$db->query($sqlforcount);
250 $objforcount =
$db->fetch_object($resql);
251 $nbtotalofrecords = $objforcount->nbtotalofrecords;
256 if (($page * $limit) > (
int) $nbtotalofrecords) {
264$sql .=
$db->order($sortfield, $sortorder);
266 $sql .=
$db->plimit($limit + 1, $offset);
269$resql =
$db->query($sql);
275$num =
$db->num_rows($resql);
280llxHeader(
'', $title, $help_url,
'', 0, 0,
'',
'',
'',
'bodyforlist');
282$arrayofselected = is_array($toselect) ? $toselect : array();
284if ($type ==
'bank-transfer') {
285 $query += [
'type' =>
'bank-transfer'];
288 $query += [
'mode' => $mode];
290if (!empty($contextpage) && $contextpage != $_SERVER[
"PHP_SELF"]) {
291 $query += [
'contextpage' => $contextpage];
293if ($limit > 0 && $limit !=
$conf->liste_limit) {
294 $query += [
'limit' => (int) $limit];
296if ($optioncss !=
'') {
297 $query += [
'optioncss' => $optioncss];
300 $query += [
'search_amount' => $search_amount];
302if (is_array($search_status)) {
303 if (!empty($search_status)) {
304 $query += [
'search_status' => implode(
',', $search_status)];
306} elseif ((
string) $search_status !=
'' && (
string) $search_status !=
'-1') {
307 $query += [
'search_status' => (int) $search_status];
310$arrayofmassactions = array(
314if (!empty($permissiontodelete)) {
315 $arrayofmassactions[
'predeletedraft'] =
img_picto(
'',
'delete',
'class="pictofixedwidth"').$langs->trans(
"Delete");
317$massactionbutton = $form->selectMassAction(
'', $arrayofmassactions);
319print
'<form method="POST" id="searchFormList" action="'.$_SERVER[
"PHP_SELF"].
'">'.
"\n";
320print
'<input type="hidden" name="token" value="'.newToken().
'">';
321if ($optioncss !=
'') {
322 print
'<input type="hidden" name="optioncss" value="'.$optioncss.
'">';
324print
'<input type="hidden" name="formfilteraction" id="formfilteraction" value="list">';
325print
'<input type="hidden" name="action" value="list">';
326print
'<input type="hidden" name="sortfield" value="'.$sortfield.
'">';
327print
'<input type="hidden" name="sortorder" value="'.$sortorder.
'">';
328print
'<input type="hidden" name="page" value="'.$page.
'">';
329print
'<input type="hidden" name="contextpage" value="'.$contextpage.
'">';
330print
'<input type="hidden" name="page_y" value="">';
331print
'<input type="hidden" name="mode" value="'.$mode.
'">';
334 print
'<input type="hidden" name="type" value="'.$type.
'">';
336$param = http_build_query($query);
339$newcardbutton .=
dolGetButtonTitle($langs->trans(
'ViewList'),
'',
'fa fa-bars imgforviewmode', $_SERVER[
"PHP_SELF"].
'?mode=common&'.preg_replace(
'/(&|\?)*mode=[^&]+/',
'', $param),
'', ((empty($mode) || $mode ==
'common') ? 2 : 1), array(
'morecss' =>
'reposition'));
340$newcardbutton .=
dolGetButtonTitle($langs->trans(
'ViewKanban'),
'',
'fa fa-th-list imgforviewmode', $_SERVER[
"PHP_SELF"].
'?mode=kanban&'.preg_replace(
'/(&|\?)*mode=[^&]+/',
'', $param),
'', ($mode ==
'kanban' ? 2 : 1), array(
'morecss' =>
'reposition'));
341$newcardbutton .=
dolGetButtonTitle($langs->trans(
'Statistics'),
'',
'fa fa-chart-bar imgforviewmode',
dolBuildUrl(DOL_URL_ROOT.
'/compta/prelevement/stats.php', $query),
'', ($mode ==
'statistics' ? 2 : 1), array(
'morecss' =>
'reposition'));
344 $newcardbutton .=
dolGetButtonTitle($langs->trans(
'NewStandingOrder'),
'',
'fa fa-plus-circle', DOL_URL_ROOT.
'/compta/prelevement/create.php?type='.urlencode($type));
347print_barre_liste($title, $page, $_SERVER[
"PHP_SELF"], $param, $sortfield, $sortorder, $massactionbutton, $num, $nbtotalofrecords,
'generic', 0, $newcardbutton,
'', $limit, 0, 0, 1);
349include DOL_DOCUMENT_ROOT.
'/core/tpl/massactions_pre.tpl.php';
357$parameters = array();
358$reshook = $hookmanager->executeHooks(
'printFieldPreListTitle', $parameters, $object, $action);
359if (empty($reshook)) {
360 $moreforfilter .= $hookmanager->resPrint;
362 $moreforfilter = $hookmanager->resPrint;
365if (!empty($moreforfilter)) {
366 print
'<div class="liste_titre liste_titre_bydiv centpercent">';
367 print $moreforfilter;
371$varpage = empty($contextpage) ? $_SERVER[
"PHP_SELF"] : $contextpage;
372$htmlofselectarray = $form->multiSelectArrayWithCheckbox(
'selectedfields', $arrayfields, $varpage,
$conf->main_checkbox_left_column);
373$selectedfields = ($mode !=
'kanban' ? $htmlofselectarray :
'');
374$selectedfields .= (count($arrayofmassactions) ? $form->showCheckAddButtons(
'checkforselect', 1) :
'');
376print
'<div class="div-table-responsive">';
377print
'<table class="tagtable nobottomiftotal liste'.($moreforfilter ?
" listwithfilterbefore" :
"").
'">'.
"\n";
381print
'<tr class="liste_titre_filter">';
383if (
$conf->main_checkbox_left_column) {
384 print
'<td class="liste_titre center maxwidthsearch">';
385 $searchpicto = $form->showFilterButtons(
'left');
389print
'<td class="liste_titre"><input type="text" class="flat maxwidth100" name="search_ref" value="'.dol_escape_htmltag($search_ref).
'"></td>';
390print
'<td class="liste_titre"> </td>';
391print
'<td class="liste_titre"> </td>';
392print
'<td class="liste_titre"> </td>';
393print
'<td class="liste_titre right"><input type="text" class="flat maxwidth100" name="search_amount" value="'.dol_escape_htmltag($search_amount).
'"></td>';
394print
'<td class="liste_titre"> </td>';
395print
'<td class="liste_titre center minwidth75imp parentonrightofpage">';
396$arrayofstatus = array(
397 BonPrelevement::STATUS_DRAFT => $langs->trans(
'StatusWaiting'),
398 BonPrelevement::STATUS_TRANSFERED => $langs->trans(
'StatusTrans'),
399 BonPrelevement::STATUS_CREDITED => $langs->trans(
'Closed'),
400 BonPrelevement::STATUS_CANCELED => $langs->trans(
'Canceled')
402print $form->multiselectarray(
'search_status', $arrayofstatus, $search_status, 0, 0,
'search_status width200 right onrightofpage', 0, 0,
'');
405if (!
$conf->main_checkbox_left_column) {
406 print
'<td class="liste_titre center maxwidthsearch">';
407 $searchpicto = $form->showFilterButtons();
418print
'<tr class="liste_titre">';
420if (
$conf->main_checkbox_left_column) {
421 print
getTitleFieldOfList($selectedfields, 0, $_SERVER[
"PHP_SELF"],
'',
'',
'',
'', $sortfield, $sortorder,
'center maxwidthsearch ').
"\n";
426print_liste_field_titre(
"DateCreation", $_SERVER[
"PHP_SELF"],
"p.datec",
"", $param,
'', $sortfield, $sortorder,
'center ');
428print_liste_field_titre(
"TransData", $_SERVER[
"PHP_SELF"],
"p.datec",
"", $param,
'', $sortfield, $sortorder,
'center ');
430print_liste_field_titre(
"CreditDate", $_SERVER[
"PHP_SELF"],
"p.datec",
"", $param,
'', $sortfield, $sortorder,
'center ');
432print_liste_field_titre(
"Amount", $_SERVER[
"PHP_SELF"],
"p.amount",
"", $param,
'', $sortfield, $sortorder,
'right ');
434print_liste_field_titre(
"BankAccount", $_SERVER[
"PHP_SELF"],
"p.fk_bank_account",
"", $param,
'', $sortfield, $sortorder);
439if (!
$conf->main_checkbox_left_column) {
440 print
getTitleFieldOfList($selectedfields, 0, $_SERVER[
"PHP_SELF"],
'',
'',
'',
'', $sortfield, $sortorder,
'center maxwidthsearch ').
"\n";
453$imaxinloop = ($limit ? min($num, $limit) : $num);
454while ($i < $imaxinloop) {
455 $obj =
$db->fetch_object($resql);
457 $directdebitorder->id = $obj->rowid;
458 $directdebitorder->ref = $obj->ref;
459 $directdebitorder->date_creation =
$db->jdate($obj->datec);
460 $directdebitorder->date_trans =
$db->jdate($obj->date_trans);
461 $directdebitorder->date_credit =
$db->jdate($obj->date_credit);
462 $directdebitorder->amount = $obj->amount;
463 $directdebitorder->status = $obj->status;
467 if ($mode ==
'kanban') {
469 print
'<tr class="trkanban"><td colspan="'.$savnbfield.
'">';
470 print
'<div class="box-flex-container kanban">';
473 if ($massactionbutton || $massaction) {
475 if (in_array(
$object->id, $arrayofselected)) {
479 print $directdebitorder->getKanbanView(
'', array(
'selected' => in_array($obj->id, $arrayofselected)));
480 if ($i == ($imaxinloop - 1)) {
486 print
'<tr data-rowid="'.$object->id.
'" class="oddeven row-with-select">';
489 if (
$conf->main_checkbox_left_column) {
490 print
'<td class="nowrap center">';
491 if ($massactionbutton || $massaction) {
493 if (in_array(
$object->id, $arrayofselected)) {
496 print
'<input id="cb'.$object->id.
'" class="flat checkforselect" type="checkbox" name="toselect[]" value="'.
$object->id.
'"'.($selected ?
' checked="checked"' :
'').
'>';
505 print $directdebitorder->getNomUrl(1);
511 print
'<td class="center">'.dol_print_date(
$db->jdate($obj->datec),
'day').
"</td>\n";
516 print
'<td class="center">'.dol_print_date(
$db->jdate($obj->date_trans),
'day').
"</td>\n";
521 print
'<td class="center">'.dol_print_date(
$db->jdate($obj->date_credit),
'day').
"</td>\n";
526 print
'<td class="right"><span class="amount">'.price($obj->amount).
"</span></td>\n";
532 if ($obj->fk_bank_account > 0) {
535 $bankaccount->fetch($obj->fk_bank_account);
536 print $bankaccount->getNomUrl(1);
543 print
'<td class="center">';
544 print
$object->LibStatut($obj->status, 5);
551 if (!
$conf->main_checkbox_left_column) {
552 print
'<td class="nowrap center">';
553 if ($massactionbutton || $massaction) {
555 if (in_array(
$object->id, $arrayofselected)) {
558 print
'<input id="cb'.$object->id.
'" class="flat checkforselect" type="checkbox" name="toselect[]" value="'.
$object->id.
'"'.($selected ?
' checked="checked"' :
'').
'>';
572 print
'<tr><td colspan="'.$savnbfield.
'"><span class="opacitymedium">'.$langs->trans(
"None").
'</span></td></tr>';
577$parameters = array(
'arrayfields' => $arrayfields,
'sql' => $sql);
578$reshook = $hookmanager->executeHooks(
'printFieldListFooter', $parameters, $object, $action);
579print $hookmanager->resPrint;
581print
'</table>'.
"\n";
if(! $sortfield) if(! $sortorder) $object
llxFooter($comment='', $zone='private', $disabledoutputofmessages=0)
Empty footer.
if(!defined('NOREQUIRESOC')) if(!defined( 'NOREQUIRETRAN')) if(!defined('NOTOKENRENEWAL')) if(!defined( 'NOREQUIREMENU')) if(!defined('NOREQUIREHTML')) if(!defined( 'NOREQUIREAJAX')) llxHeader($head='', $title='', $help_url='', $target='', $disablejs=0, $disablehead=0, $arrayofjs='', $arrayofcss='', $morequerystring='', $morecssonbody='', $replacemainareaby='', $disablenofollow=0, $disablenoindex=0)
Empty header.
Class to manage bank accounts.
Class to manage withdrawal receipts.
dolBuildUrl($url, $params=[], $addtoken=false, $anchor='')
Return path of url.
dol_eval($s, $returnvalue=1, $hideerrors=1, $onlysimplestring='1')
Replace eval function to add more security.
GETPOSTISARRAY($paramname, $method=0)
Return true if the parameter $paramname is submit from a POST OR GET as an array.
natural_search($fields, $value, $mode=0, $nofirstand=0, $sqltoadd='')
Generate natural SQL search string for a criteria (this criteria can be tested on one or several fiel...
getDolGlobalInt($key, $default=0)
Return a Dolibarr global constant int value.
GETPOST($paramname, $check='alphanohtml', $method=0, $filter=null, $options=null, $noreplace=0, $nodefault=0)
Return value of a param into GET or POST supervariable.
GETPOSTINT($paramname, $method=0, $nodefault=0)
Return the value of a $_GET or $_POST supervariable, converted into integer.
setEventMessages($mesg, $mesgs, $style='mesgs', $messagekey='', $noduplicate=0, $attop=0)
Set event messages in dol_events session object.
print_liste_field_titre($name, $file="", $field="", $begin="", $param="", $moreattrib="", $sortfield="", $sortorder="", $prefix="", $tooltip="", $forcenowrapcolumntitle=0)
Show title line of an array.
print_barre_liste($title, $page, $file, $options='', $sortfield='', $sortorder='', $morehtmlcenter='', $num=-1, $totalnboflines='', $picto='generic', $pictoisfullpath=0, $morehtmlright='', $morecss='', $limit=-1, $selectlimitsuffix=0, $hidenavigation=0, $pagenavastextinput=0, $morehtmlrightbeforearrow='')
Print a title with navigation controls for pagination.
img_picto($titlealt, $picto, $moreatt='', $pictoisfullpath=0, $srconly=0, $notitle=0, $alt='', $morecss='', $marginleftonlyshort=2, $allowothertags=array())
Show picto whatever it's its name (generic function)
dolGetButtonTitle($label, $helpText='', $iconClass='fa fa-file', $url='', $id='', $status=1, $params=array())
Function dolGetButtonTitle : this kind of buttons are used in title in list.
getTitleFieldOfList($name, $thead=0, $file="", $field="", $begin="", $moreparam="", $moreattrib="", $sortfield="", $sortorder="", $prefix="", $disablesortlink=0, $tooltip='', $forcenowrapcolumntitle=0)
Get title line of an array.
dolGetButtonTitleSeparator($moreClass="")
Add space between dolGetButtonTitle.
dol_print_error($db=null, $error='', $errors=null)
Displays error message system with all the information to facilitate the diagnosis and the escalation...
print $langs trans("Show") . '< td style="' . $timeColor . '" align="center"> s</td > badge status0 badge status4 badge status3 Error badge status8< td align="center">< span class="badge ' . $badge . '"></span ></td >< td align="center">< a href="#" class="button button-small" onclick="openLogModal(this)" data-req="' . dol_escape_htmltag($reqSafe) . '" data-res="' . dol_escape_htmltag($resSafe) . '" data-err="' . dol_escape_htmltag($errSafe) . '">< span class="fa fa-search-plus"></span ></a ></td ></tr >< tr >< td colspan="' . $colspan . '" class="opacitymedium"></td ></tr ></table ></div ></form > logModal none logModal none s a JSON string
restrictedArea(User $user, $features, $object=0, $tableandshare='', $feature2='', $dbt_keyfield='fk_soc', $dbt_select='rowid', $isdraft=0, $mode=0)
Check permissions of a user to show a page and an object.