30require
'../main.inc.php';
31require_once DOL_DOCUMENT_ROOT.
'/salaries/class/salary.class.php';
32require_once DOL_DOCUMENT_ROOT.
'/salaries/class/paymentsalary.class.php';
33require_once DOL_DOCUMENT_ROOT.
'/compta/bank/class/account.class.php';
35 require_once DOL_DOCUMENT_ROOT.
'/accountancy/class/accountingjournal.class.php';
47$langs->loadLangs(array(
"compta",
"salaries",
"bills",
"hrm"));
49$action =
GETPOST(
'action',
'aZ09') ?
GETPOST(
'action',
'aZ09') :
'view';
50$massaction =
GETPOST(
'massaction',
'alpha');
52$confirm =
GETPOST(
'confirm',
'alpha');
53$cancel =
GETPOST(
'cancel',
'alpha');
54$toselect =
GETPOST(
'toselect',
'array:int');
55$contextpage =
GETPOST(
'contextpage',
'aZ') ?
GETPOST(
'contextpage',
'aZ') :
'bomlist';
56$backtopage =
GETPOST(
'backtopage',
'alpha');
57$optioncss =
GETPOST(
'optioncss',
'aZ');
58$mode =
GETPOST(
'mode',
'alpha');
63$sortfield =
GETPOST(
'sortfield',
'aZ09comma');
64$sortorder =
GETPOST(
'sortorder',
'aZ09comma');
66if (empty($page) || $page == -1 ||
GETPOST(
'button_search',
'alpha') ||
GETPOST(
'button_removefilter',
'alpha') || (empty($toselect) && $massaction ===
'0')) {
69$offset = $limit * $page;
73 $sortfield =
"s.datep,s.rowid";
76 $sortorder =
"DESC,DESC";
82$diroutputmassaction =
$conf->user->dir_output.
'/temp/massgeneration/'.$user->id;
83$hookmanager->initHooks(array(
'salarieslist'));
86$extrafields->fetch_name_optionals_label(
$object->table_element);
88$search_array_options = $extrafields->getOptionalsFromPost(
$object->table_element,
'',
'search_');
91 $sortfield =
"s.datep,s.rowid";
94 $sortorder =
"DESC,DESC";
97$search_ref =
GETPOST(
'search_ref',
'alpha');
98$search_ref_salary =
GETPOST(
'search_ref_salary',
'alpha');
99$search_user =
GETPOST(
'search_user',
'alpha');
100$search_label =
GETPOST(
'search_label',
'alpha');
105$search_amount =
GETPOST(
'search_amount',
'alpha');
106$search_account =
GETPOST(
'search_account',
'alpha');
107$search_fk_bank =
GETPOST(
'search_fk_bank',
'alpha');
108$search_chq_number =
GETPOST(
'search_chq_number',
'alpha');
110$search_type_id =
GETPOST(
'search_type_id',
'int');
111if (!$search_type_id) {
112 $filtre =
GETPOST(
"filtre",
'restricthtml');
113 $newfiltre = str_replace(
'filtre=',
'', $filtre);
114 $filterarray = explode(
'-', $newfiltre);
115 foreach ($filterarray as $val) {
116 $part = explode(
':', $val);
117 if ($part[0] ==
's.fk_typepayment') {
118 $search_type_id = (int) $part[1];
123$childids = $user->getAllChildIds(1);
126$search_all =
GETPOST(
"search_all",
'alpha');
128foreach (
$object->fields as $key => $val) {
129 if (
GETPOST(
'search_'.$key,
'alpha') !==
'') {
130 $search[$key] =
GETPOST(
'search_'.$key,
'alpha');
135$fieldstosearchall = array();
136foreach (
$object->fields as $key => $val) {
137 if (!empty($val[
'searchall'])) {
138 $fieldstosearchall[
't.'.$key] = $val[
'label'];
143$arrayfields = array();
144foreach (
$object->fields as $key => $val) {
146 if (!empty($val[
'visible'])) {
147 $visible = (int)
dol_eval((
string) $val[
'visible'], 1, 1,
'1');
148 $arrayfields[
't.'.$key] = array(
149 'label' => $val[
'label'],
150 'checked' => (($visible < 0) ? 0 : 1),
151 'enabled' => (abs($visible) != 3 && (bool)
dol_eval((string) $val[
'enabled'], 1)),
152 'position' => $val[
'position'],
153 'help' => isset($val[
'help']) ? $val[
'help'] :
''
158$permissiontoread = $user->hasRight(
'salaries',
'read');
159$permissiontoadd = $user->hasRight(
'salaries',
'write');
160$permissiontodelete = $user->hasRight(
'salaries',
'delete');
164if ($user->socid > 0) {
165 $socid = $user->socid;
175if (
GETPOST(
'cancel',
'alpha')) {
179if (!
GETPOST(
'confirmmassaction',
'alpha') && $massaction !=
'presend' && $massaction !=
'confirm_presend') {
183$parameters = array();
184$reshook = $hookmanager->executeHooks(
'doActions', $parameters,
$object, $action);
186 setEventMessages($hookmanager->error, $hookmanager->errors,
'errors');
189if (empty($reshook)) {
191 include DOL_DOCUMENT_ROOT.
'/core/actions_changeselectedfields.inc.php';
194 if (
GETPOST(
'button_removefilter_x',
'alpha') ||
GETPOST(
'button_removefilter.x',
'alpha') ||
GETPOST(
'button_removefilter',
'alpha')) {
196 $search_ref_salary =
"";
199 $search_date_start =
'';
200 $search_date_end =
'';
201 $search_dateep_start =
'';
202 $search_dateep_end =
'';
204 $search_account =
'';
205 $search_fk_bank =
'';
206 $search_chq_number =
'';
207 $search_type_id =
"";
209 if (
GETPOST(
'button_removefilter_x',
'alpha') ||
GETPOST(
'button_removefilter.x',
'alpha') ||
GETPOST(
'button_removefilter',
'alpha')
210 ||
GETPOST(
'button_search_x',
'alpha') ||
GETPOST(
'button_search.x',
'alpha') ||
GETPOST(
'button_search',
'alpha')) {
215 $objectclass =
'PaymentSalary';
216 $objectlabel =
'SalariesPayments';
217 $uploaddir =
$conf->salaries->dir_output;
220 include DOL_DOCUMENT_ROOT.
'/core/actions_massactions.inc.php';
223 if (!$error && $massaction ==
'buildsepa' && $permissiontoadd) {
224 $objecttmp =
new $objectclass($db);
234$form =
new Form($db);
235$salstatic =
new Salary($db);
237$userstatic =
new User($db);
238$accountstatic =
new Account($db);
245$title = $langs->trans(
'SalariesPayments');
247$sql =
"SELECT u.rowid as uid, u.lastname, u.firstname, u.login, u.email, u.admin, u.photo, u.gender, u.salary as current_salary, u.fk_soc as fk_soc, u.statut as status,";
248$sql .=
" s.rowid, s.fk_user, s.amount, s.salary, sal.rowid as id_salary, sal.label, s.datep as datep, sal.dateep, b.datev as datev, s.fk_typepayment as type, s.num_payment, s.fk_bank,";
249$sql .=
" ba.rowid as bid, ba.ref as bref, ba.number as bnumber, ba.account_number, ba.fk_accountancy_journal, ba.label as blabel, ba.iban_prefix as iban, ba.bic, ba.currency_code, ba.clos,";
250$sql .=
" pst.code as payment_code";
251$sql .=
" FROM ".MAIN_DB_PREFIX.
"payment_salary as s";
252$sql .=
" INNER JOIN ".MAIN_DB_PREFIX.
"salary as sal ON (sal.rowid = s.fk_salary)";
253$sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"c_paiement as pst ON s.fk_typepayment = pst.id";
254$sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"bank as b ON s.fk_bank = b.rowid";
255$sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"bank_account as ba ON b.fk_account = ba.rowid,";
256$sql .=
" ".MAIN_DB_PREFIX.
"user as u";
257$sql .=
" WHERE u.rowid = sal.fk_user";
258$sql .=
" AND s.entity IN (".getEntity(
'payment_salaries').
")";
259if (!$user->hasRight(
'salaries',
'readall')) {
260 if (!$user->hasRight(
'salaries',
'readchild')) {
261 $sql .=
" AND sal.fk_user = ".(int) $user->id;
263 $sql .=
" AND sal.fk_user IN (".$db->sanitize(implode(
',', $childids)).
")";
269 $sql .=
" AND s.rowid=".((int) $search_ref);
271if ($search_ref_salary) {
272 $sql .=
" AND sal.rowid=".((int) $search_ref_salary);
275 $sql .=
natural_search(array(
'u.login',
'u.lastname',
'u.firstname',
'u.email'), $search_user);
280if ($search_date_start) {
281 $sql .=
" AND s.datep >= '".$db->idate($search_date_start).
"'";
283if ($search_date_end) {
284 $sql .=
" AND s.datep <= '".$db->idate($search_date_end).
"'";
286if ($search_dateep_start) {
287 $sql .=
" AND sal.dateep >= '".$db->idate($search_dateep_start).
"'";
289if ($search_dateep_end) {
290 $sql .=
" AND sal.dateep <= '".$db->idate($search_dateep_end).
"'";
295if ($search_account > 0) {
296 $sql .=
" AND b.fk_account=".((int) $search_account);
298if ($search_fk_bank) {
299 $sql .=
" AND s.fk_bank=".((int) $search_fk_bank);
301if ($search_chq_number) {
302 $sql .=
natural_search(array(
's.num_payment'), $search_chq_number);
305if ($search_type_id > 0) {
306 $sql .=
" AND s.fk_typepayment=".((int) $search_type_id);
308$sql .= $db->order($sortfield, $sortorder);
311$nbtotalofrecords = 0;
314 $resql = $db->query($sql);
316 $nbtotalofrecords = $db->num_rows($resql);
318 dol_print_error($db);
321 if (($page * $limit) > (
int) $nbtotalofrecords) {
327if (is_numeric($nbtotalofrecords) && ($limit > $nbtotalofrecords || empty($limit))) {
328 $num = $nbtotalofrecords;
331 $sql .= $db->plimit($limit + 1, $offset);
334 $resql = $db->query($sql);
336 dol_print_error($db);
340 $num = $db->num_rows($resql);
346llxHeader(
'', $title, $help_url,
'', 0, 0,
'',
'',
'',
'bodyforlist');
348$arrayofselected = is_array($toselect) ? $toselect : array();
352 $param .=
'&mode='.urlencode($mode);
354if (!empty($contextpage) && $contextpage != $_SERVER[
"PHP_SELF"]) {
355 $param .=
'&contextpage='.urlencode($contextpage);
357if ($limit > 0 && $limit !=
$conf->liste_limit) {
358 $param .=
'&limit='.((int) $limit);
360if ($search_type_id) {
361 $param .=
'&search_type_id='.urlencode($search_type_id);
363if ($optioncss !=
'') {
364 $param .=
'&optioncss='.urlencode($optioncss);
367 $param .=
'&search_ref='.urlencode($search_ref);
369if ($search_ref_salary) {
370 $param .=
'&search_ref_salary='.urlencode($search_ref_salary);
373 $param .=
'&search_user='.urlencode($search_user);
376 $param .=
'&search_label='.urlencode($search_label);
378if ($search_fk_bank) {
379 $param .=
'&search_fk_bank='.urlencode((
string) ($search_fk_bank));
381if ($search_chq_number) {
382 $param .=
'&search_chq_number='.urlencode((
string) ($search_chq_number));
384if ($search_account) {
385 $param .=
'&search_account='.urlencode((
string) ($search_account));
387if ($search_date_start) {
388 $param .=
'&search_date_startday='.GETPOSTINT(
'search_date_startday').
'&search_date_startmonth='.
GETPOSTINT(
'search_date_startmonth').
'&search_date_startyear='.
GETPOSTINT(
'search_date_startyear');
390if ($search_dateep_start) {
391 $param .=
'&search_dateep_startday='.GETPOSTINT(
'search_dateep_startday').
'&search_dateep_startmonth='.
GETPOSTINT(
'search_dateep_startmonth').
'&search_dateep_startyear='.
GETPOSTINT(
'search_dateep_startyear');
393if ($search_date_end) {
394 $param .=
'&search_date_endday='.GETPOSTINT(
'search_date_endday').
'&search_date_endmonth='.
GETPOSTINT(
'search_date_endmonth').
'&search_date_endyear='.
GETPOSTINT(
'search_date_endyear');
396if ($search_dateep_end) {
397 $param .=
'&search_dateep_endday='.urlencode((
string) (
GETPOSTINT(
'search_dateep_endday'))).
'&search_dateep_endmonth='.urlencode((
string) (
GETPOSTINT(
'search_dateep_endmonth'))).
'&search_dateep_endyear='.urlencode((
string) (
GETPOSTINT(
'search_dateep_endyear')));
400include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_param.tpl.php';
403$arrayofmassactions = array(
408if (
GETPOSTINT(
'nomassaction') || in_array($massaction, array(
'presend',
'predelete'))) {
409 $arrayofmassactions = array();
411$massactionbutton = $form->selectMassAction(
'', $arrayofmassactions);
413print
'<form method="POST" id="searchFormList" action="'.dolBuildUrl($_SERVER[
"PHP_SELF"]).
'">';
414if ($optioncss !=
'') {
415 print
'<input type="hidden" name="optioncss" value="'.$optioncss.
'">';
417print
'<input type="hidden" name="token" value="'.newToken().
'">';
418print
'<input type="hidden" name="formfilteraction" id="formfilteraction" value="list">';
419print
'<input type="hidden" name="action" value="list">';
420print
'<input type="hidden" name="sortfield" value="'.$sortfield.
'">';
421print
'<input type="hidden" name="sortorder" value="'.$sortorder.
'">';
422print
'<input type="hidden" name="contextpage" value="'.$contextpage.
'">';
423print
'<input type="hidden" name="mode" value="'.$mode.
'">';
426$url = DOL_URL_ROOT.
'/salaries/card.php?action=create';
428 $url .=
'&socid='.$socid;
431$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'));
432$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'));
434$newcardbutton =
dolGetButtonTitle($langs->trans(
'NewSalaryPayment'),
'',
'fa fa-plus-circle', $url,
'', $user->hasRight(
'salaries',
'write'));
436print_barre_liste($title, $page, $_SERVER[
"PHP_SELF"], $param, $sortfield, $sortorder, $massactionbutton, $num, $nbtotalofrecords,
'object_payment', 0, $newcardbutton,
'', $limit, 0, 0, 1);
440$varpage = empty($contextpage) ? $_SERVER[
"PHP_SELF"] : $contextpage;
443$selectedfields .= (count($arrayofmassactions) ? $form->showCheckAddButtons(
'checkforselect', 1) :
'');
445print
'<div class="div-table-responsive">';
446print
'<table class="tagtable nobottomiftotal liste'.($moreforfilter ?
" listwithfilterbefore" :
"").
'">'.
"\n";
450print
'<tr class="liste_titre_filter">';
452if (
$conf->main_checkbox_left_column) {
453 print
'<td class="liste_titre maxwidthsearch">';
454 $searchpicto = $form->showFilterButtons();
459print
'<td class="liste_titre left">';
460print
'<input class="flat" type="text" size="3" name="search_ref" value="'.$db->escape($search_ref).
'">';
463print
'<td class="liste_titre center">';
464print
'<input class="flat" type="text" size="3" name="search_ref_salary" value="'.$db->escape($search_ref_salary).
'">';
467print
'<td class="liste_titre"><input type="text" class="flat width150" name="search_label" value="'.$db->escape($search_label).
'"></td>';
469print
'<td class="liste_titre center">';
470print
'<div class="nowrapfordate">';
471print $form->selectDate($search_dateep_start ? $search_dateep_start : -1,
'search_dateep_start', 0, 0, 1,
'', 1, 0, 0,
'',
'',
'',
'', 1,
'', $langs->trans(
'From'));
473print
'<div class="nowrapfordate">';
474print $form->selectDate($search_dateep_end ? $search_dateep_end : -1,
'search_dateep_end', 0, 0, 1,
'', 1, 0, 0,
'',
'',
'',
'', 1,
'', $langs->trans(
'to'));
478print
'<td class="liste_titre center">';
479print
'<div class="nowrapfordate">';
480print $form->selectDate($search_date_start ? $search_date_start : -1,
'search_date_start', 0, 0, 1,
'', 1, 0, 0,
'',
'',
'',
'', 1,
'', $langs->trans(
'From'));
482print
'<div class="nowrapfordate">';
483print $form->selectDate($search_date_end ? $search_date_end : -1,
'search_date_end', 0, 0, 1,
'', 1, 0, 0,
'',
'',
'',
'', 1,
'', $langs->trans(
'to'));
490print
'<td class="liste_titre">';
491print
'<input class="flat" type="text" size="6" name="search_user" value="'.$db->escape($search_user).
'">';
494print
'<td class="liste_titre">';
495print $form->select_types_paiements($search_type_id,
'search_type_id',
'', 0, 1, 1, 16, 1,
'maxwidth150', 1);
498print
'<td class="liste_titre"><input name="search_chq_number" class="flat width50" type="text" value="'.$db->escape($search_chq_number).
'"></td>';
502 print
'<td class="liste_titre">';
503 print
'<input class="flat width50" type="text" name="search_fk_bank" value="'.$db->escape($search_fk_bank).
'">';
507 print
'<td class="liste_titre">';
508 $form->select_comptes($search_account,
'search_account', 0,
'', 1);
512print
'<td class="liste_titre right"><input name="search_amount" class="flat" type="text" size="8" value="'.$db->escape($search_amount).
'"></td>';
515include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_input.tpl.php';
518$parameters = array(
'arrayfields' => $arrayfields);
519$reshook = $hookmanager->executeHooks(
'printFieldListOption', $parameters,
$object);
520print $hookmanager->resPrint;
522if (!
$conf->main_checkbox_left_column) {
523 print
'<td class="liste_titre maxwidthsearch">';
524 $searchpicto = $form->showFilterButtons();
530$totalarray = array();
531$totalarray[
'nbfield'] = 0;
535print
'<tr class="liste_titre">';
537if (
$conf->main_checkbox_left_column) {
538 print
getTitleFieldOfList($selectedfields, 0, $_SERVER[
"PHP_SELF"],
'',
'',
'',
'', $sortfield, $sortorder,
'center maxwidthsearch ').
"\n";
539 $totalarray[
'nbfield']++;
542$totalarray[
'nbfield']++;
544$totalarray[
'nbfield']++;
546$totalarray[
'nbfield']++;
547print_liste_field_titre(
"PeriodEndDate", $_SERVER[
"PHP_SELF"],
"sal.dateep",
"", $param,
'', $sortfield, $sortorder,
'center ');
548$totalarray[
'nbfield']++;
549print_liste_field_titre(
"DatePayment", $_SERVER[
"PHP_SELF"],
"s.datep,s.rowid",
"", $param,
'', $sortfield, $sortorder,
'center ');
550$totalarray[
'nbfield']++;
552$totalarray[
'nbfield']++;
553print_liste_field_titre(
"PaymentMode", $_SERVER[
"PHP_SELF"],
"pst.code",
"", $param,
'', $sortfield, $sortorder);
554$totalarray[
'nbfield']++;
555print_liste_field_titre(
"Numero", $_SERVER[
"PHP_SELF"],
"s.num_payment",
"", $param,
'', $sortfield, $sortorder,
'',
'ChequeOrTransferNumber');
556$totalarray[
'nbfield']++;
558 print_liste_field_titre(
"BankTransactionLine", $_SERVER[
"PHP_SELF"],
"s.fk_bank",
"", $param,
'', $sortfield, $sortorder);
559 $totalarray[
'nbfield']++;
560 print_liste_field_titre(
"BankAccount", $_SERVER[
"PHP_SELF"],
"ba.label",
"", $param,
"", $sortfield, $sortorder);
561 $totalarray[
'nbfield']++;
563print_liste_field_titre(
"PayedByThisPayment", $_SERVER[
"PHP_SELF"],
"s.amount",
"", $param,
'class="right"', $sortfield, $sortorder);
564$totalarray[
'nbfield']++;
566include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_title.tpl.php';
568$parameters = array(
'arrayfields' => $arrayfields,
'param' => $param,
'sortfield' => $sortfield,
'sortorder' => $sortorder);
569$reshook = $hookmanager->executeHooks(
'printFieldListTitle', $parameters,
$object);
570print $hookmanager->resPrint;
572if (!
$conf->main_checkbox_left_column) {
573 print
getTitleFieldOfList($selectedfields, 0, $_SERVER[
"PHP_SELF"],
'',
'',
'',
'', $sortfield, $sortorder,
'center maxwidthsearch ').
"\n";
574 $totalarray[
'nbfield']++;
580$needToFetchEachLine = 0;
581if (isset($extrafields->attributes[
$object->table_element][
'computed']) && is_array($extrafields->attributes[
$object->table_element][
'computed']) && count($extrafields->attributes[
$object->table_element][
'computed']) > 0) {
582 foreach ($extrafields->attributes[
$object->table_element][
'computed'] as $key => $val) {
583 if (!is_null($val) && preg_match(
'/\$object/', $val)) {
584 $needToFetchEachLine++;
593$savnbfield = $totalarray[
'nbfield'];
594$totalarray = array();
595$totalarray[
'nbfield'] = 0;
596$imaxinloop = ($limit ? min($num, $limit) : $num);
597while ($i < $imaxinloop && $resql !==
null) {
598 $obj = $db->fetch_object($resql);
605 $object->setVarsFromFetchObj($obj);
607 $userstatic->id = $obj->uid;
608 $userstatic->lastname = $obj->lastname;
609 $userstatic->firstname = $obj->firstname;
610 $userstatic->admin = $obj->admin;
611 $userstatic->login = $obj->login;
612 $userstatic->email = $obj->email;
613 $userstatic->socid = $obj->fk_soc;
614 $userstatic->statut = (int) $obj->status;
615 $userstatic->status = (int) $obj->status;
616 $userstatic->gender = $obj->gender;
617 $userstatic->photo = $obj->photo;
619 $salstatic->id = $obj->id_salary;
620 $salstatic->ref = $obj->id_salary;
622 $paymentsalstatic->id = $obj->rowid;
623 $paymentsalstatic->ref = (string) $obj->rowid;
624 $paymentsalstatic->amount = $obj->amount;
625 $paymentsalstatic->fk_typepayment = $obj->payment_code;
626 $paymentsalstatic->datec = $obj->dateep;
627 $paymentsalstatic->datep = $obj->datep;
629 $accountlinestatic->id = $obj->fk_bank;
630 $accountlinestatic->ref = $obj->fk_bank;
631 $paymentsalstatic->fk_bank = $accountlinestatic->id;
632 $paymentsalstatic->fk_user_author = $userstatic->id;
634 if ($mode ==
'kanban') {
636 print
'<tr class="trkanban"><td colspan="'.$savnbfield.
'">';
637 print
'<div class="box-flex-container kanban">';
640 print $paymentsalstatic->getKanbanView(
'', array(
'selected' => in_array(
$object->id, $arrayofselected)));
641 if ($i == ($imaxinloop - 1)) {
647 print
'<tr class="oddeven">';
650 if (
$conf->main_checkbox_left_column) {
651 print
'<td class="nowrap center">';
652 if ($massactionbutton || $massaction) {
654 if (in_array(
$object->id, $arrayofselected)) {
657 print
'<input id="cb'.$object->id.
'" class="flat checkforselect" type="checkbox" name="toselect[]" value="'.
$object->id.
'"'.($selected ?
' checked="checked"' :
'').
'>';
661 $totalarray[
'nbfield']++;
666 print
"<td>".$paymentsalstatic->getNomUrl(1).
"</td>\n";
668 $totalarray[
'nbfield']++;
672 print
"<td>".$salstatic->getNomUrl(1).
"</td>\n";
674 $totalarray[
'nbfield']++;
678 print
"<td>".dol_trunc($obj->label, 40).
"</td>\n";
680 $totalarray[
'nbfield']++;
684 print
'<td class="center">'.dol_print_date($db->jdate($obj->dateep),
'day').
"</td>\n";
686 $totalarray[
'nbfield']++;
690 print
'<td class="center">'.dol_print_date($db->jdate($obj->datep),
'day').
"</td>\n";
692 $totalarray[
'nbfield']++;
700 print
'<td class="tdoverflowmax150">'.$userstatic->getNomUrl(-1).
"</td>\n";
702 $totalarray[
'nbfield']++;
707 print $langs->trans(
"PaymentTypeShort".$obj->payment_code);
710 $totalarray[
'nbfield']++;
714 print
'<td>'.$obj->num_payment.
'</td>';
716 $totalarray[
'nbfield']++;
723 $accountlinestatic->id = $obj->fk_bank;
724 print $accountlinestatic->getNomUrl(1);
727 $totalarray[
'nbfield']++;
731 if ($obj->fk_bank > 0) {
733 $accountstatic->id = $obj->bid;
734 $accountstatic->ref = $obj->bref;
735 $accountstatic->number = $obj->bnumber;
736 $accountstatic->iban = $obj->iban;
737 $accountstatic->bic = $obj->bic;
738 $accountstatic->currency_code = $langs->trans(
"Currency".$obj->currency_code);
739 $accountstatic->clos = $obj->clos;
742 $accountstatic->account_number = $obj->account_number;
745 $accountingjournal->fetch($obj->fk_accountancy_journal);
747 $accountstatic->accountancy_journal = $accountingjournal->getNomUrl(0, 1, 1,
'', 1);
749 $accountstatic->label = $obj->blabel;
750 if ($accountstatic->id > 0) {
751 print $accountstatic->getNomUrl(1);
758 $totalarray[
'nbfield']++;
763 print
'<td class="nowrap right"><span class="amount">'.price($obj->amount).
'</span></td>';
765 $totalarray[
'nbfield']++;
768 $totalarray[
'pos'][$totalarray[
'nbfield']] =
'totalttcfield';
771 $totalarray[
'val'][
'totalttcfield'] = $obj->amount;
773 $totalarray[
'val'][
'totalttcfield'] += $obj->amount;
778 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_print_fields.tpl.php';
780 $parameters = array(
'arrayfields' => $arrayfields,
'object' =>
$object,
'obj' => $obj,
'i' => $i,
'totalarray' => &$totalarray);
781 $reshook = $hookmanager->executeHooks(
'printFieldListValue', $parameters,
$object);
782 print $hookmanager->resPrint;
785 if (!
$conf->main_checkbox_left_column) {
786 print
'<td class="nowrap center">';
787 if ($massactionbutton || $massaction) {
789 if (in_array(
$object->id, $arrayofselected)) {
792 print
'<input id="cb'.$object->id.
'" class="flat checkforselect" type="checkbox" name="toselect[]" value="'.
$object->id.
'"'.($selected ?
' checked="checked"' :
'').
'>';
796 $totalarray[
'nbfield']++;
806include DOL_DOCUMENT_ROOT.
'/core/tpl/list_print_total.tpl.php';
818 print
'<tr><td colspan="'.$colspan.
'"><span class="opacitymedium">'.$langs->trans(
"NoRecordFound").
'</span></td></tr>';
822if ($resql !==
null) {
826$parameters = array(
'arrayfields' => $arrayfields,
'sql' => $sql);
827$reshook = $hookmanager->executeHooks(
'printFieldListFooter', $parameters,
$object);
828print $hookmanager->resPrint;
830print
'</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.
if(!isModEnabled('ai')||!getDolGlobalString('AI_ASSISTANT_ENABLED')) global $conf
The main.inc.php has been included so the following variable are now defined:
Class to manage bank accounts.
Class to manage bank transaction lines.
Class to manage accounting journals.
Class to manage payments of salaries.
Class to manage salary payments.
Class to manage Dolibarr users.
dol_now($mode='gmt')
Return date for now.
dol_mktime($hour, $minute, $second, $month, $day, $year, $gm='auto', $check=1)
Return a timestamp date built from detailed information (by default a local PHP server timestamp) Rep...
dol_eval($s, $returnvalue=1, $hideerrors=1, $onlysimplestring='1')
Replace eval function to add more security.
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.
GETPOSTISSET($paramname)
Return true if we are in a context of submitting the parameter $paramname from a POST of a form.
isModEnabled($module)
Is Dolibarr module enabled.
print_liste_field_titre($name, $file="", $field="", $begin="", $param="", $moreattrib="", $sortfield="", $sortorder="", $prefix="", $tooltip="", $forcenowrapcolumntitle=0)
Show title line of an array.
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.
restrictedArea(User $user, $features, $object=0, $tableandshare='', $feature2='', $dbt_keyfield='fk_soc', $dbt_select='rowid', $isdraft=0, $nodie=0, $mode='')
Check permissions of a user to show a page and an object.