28 require
'../../main.inc.php';
30 require_once DOL_DOCUMENT_ROOT.
'/expensereport/class/expensereport.class.php';
31 require_once DOL_DOCUMENT_ROOT.
'/user/class/user.class.php';
32 require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formaccounting.class.php';
33 require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formother.class.php';
34 require_once DOL_DOCUMENT_ROOT.
'/accountancy/class/accountingaccount.class.php';
35 require_once DOL_DOCUMENT_ROOT.
'/core/lib/accounting.lib.php';
36 require_once DOL_DOCUMENT_ROOT.
'/core/lib/date.lib.php';
39 $langs->loadLangs(array(
"bills",
"companies",
"compta",
"accountancy",
"other",
"trips",
"productbatch",
"hrm"));
41 $action =
GETPOST(
'action',
'aZ09');
42 $massaction =
GETPOST(
'massaction',
'alpha');
43 $confirm =
GETPOST(
'confirm',
'alpha');
44 $toselect =
GETPOST(
'toselect',
'array');
45 $contextpage =
GETPOST(
'contextpage',
'aZ') ?
GETPOST(
'contextpage',
'aZ') :
'accountancyexpensereportlist';
46 $optioncss =
GETPOST(
'optioncss',
'aZ');
50 $mesCasesCochees =
GETPOST(
'toselect',
'array');
53 $search_login =
GETPOST(
'search_login',
'alpha');
54 $search_lineid =
GETPOST(
'search_lineid',
'alpha');
55 $search_expensereport =
GETPOST(
'search_expensereport',
'alpha');
56 $search_label =
GETPOST(
'search_label',
'alpha');
57 $search_desc =
GETPOST(
'search_desc',
'alpha');
58 $search_amount =
GETPOST(
'search_amount',
'alpha');
59 $search_account =
GETPOST(
'search_account',
'alpha');
60 $search_vat =
GETPOST(
'search_vat',
'alpha');
61 $search_date_startday =
GETPOST(
'search_date_startday',
'int');
62 $search_date_startmonth =
GETPOST(
'search_date_startmonth',
'int');
63 $search_date_startyear =
GETPOST(
'search_date_startyear',
'int');
64 $search_date_endday =
GETPOST(
'search_date_endday',
'int');
65 $search_date_endmonth =
GETPOST(
'search_date_endmonth',
'int');
66 $search_date_endyear =
GETPOST(
'search_date_endyear',
'int');
67 $search_date_start =
dol_mktime(0, 0, 0, $search_date_startmonth, $search_date_startday, $search_date_startyear);
68 $search_date_end =
dol_mktime(23, 59, 59, $search_date_endmonth, $search_date_endday, $search_date_endyear);
71 $limit =
GETPOST(
'limit',
'int') ?
GETPOST(
'limit',
'int') : (empty($conf->global->ACCOUNTING_LIMIT_LIST_VENTILATION) ? $conf->liste_limit : $conf->global->ACCOUNTING_LIMIT_LIST_VENTILATION);
72 $sortfield =
GETPOST(
'sortfield',
'aZ09comma');
73 $sortorder =
GETPOST(
'sortorder',
'aZ09comma');
75 if (empty($page) || $page < 0) {
78 $offset = $limit * $page;
79 $pageprev = $page - 1;
80 $pagenext = $page + 1;
82 $sortfield =
"erd.date, erd.rowid";
85 if ($conf->global->ACCOUNTING_LIST_SORT_VENTILATION_TODO > 0) {
91 $hookmanager->initHooks(array(
'accountancyexpensereportlist'));
96 $chartaccountcode =
dol_getIdFromCode($db, $conf->global->CHARTOFACCOUNTS,
'accounting_system',
'rowid',
'pcg_version');
102 if ($user->socid > 0) {
105 if (empty($user->rights->accounting->mouvements->lire)) {
114 if (
GETPOST(
'cancel',
'alpha')) {
115 $action =
'list'; $massaction =
'';
117 if (!
GETPOST(
'confirmmassaction',
'alpha') && $massaction !=
'presend' && $massaction !=
'confirm_presend') {
121 $parameters = array();
122 $reshook = $hookmanager->executeHooks(
'doActions', $parameters, $object, $action);
127 if (empty($reshook)) {
129 if (
GETPOST(
'button_removefilter_x',
'alpha') ||
GETPOST(
'button_removefilter.x',
'alpha') ||
GETPOST(
'button_removefilter',
'alpha')) {
131 $search_expensereport =
'';
135 $search_account =
'';
137 $search_date_startday =
'';
138 $search_date_startmonth =
'';
139 $search_date_startyear =
'';
140 $search_date_endday =
'';
141 $search_date_endmonth =
'';
142 $search_date_endyear =
'';
143 $search_date_start =
'';
144 $search_date_end =
'';
145 $search_country =
'';
146 $search_tvaintra =
'';
150 $objectclass =
'ExpenseReport';
151 $objectlabel =
'ExpenseReport';
152 $permissiontoread = $user->hasRight(
'accounting',
'read');
153 $permissiontodelete = $user->hasRight(
'accounting',
'delete');
154 $uploaddir = $conf->expensereport->dir_output;
155 include DOL_DOCUMENT_ROOT .
'/core/actions_massactions.inc.php';
159 if ($massaction ==
'ventil' && $user->rights->accounting->bind->write) {
162 if (!empty($mesCasesCochees)) {
163 $msg =
'<div>'.$langs->trans(
"SelectedLines").
': '.count($mesCasesCochees).
'</div>';
164 $msg .=
'<div class="detail">';
169 foreach ($mesCasesCochees as $maLigneCochee) {
170 $maLigneCourante = explode(
"_", $maLigneCochee);
171 $monId = $maLigneCourante[0];
172 $monCompte =
GETPOST(
'codeventil'.$monId);
174 if ($monCompte <= 0) {
175 $msg .=
'<div><span class="error">'.$langs->trans(
"Lineofinvoice").
' '.$monId.
' - '.$langs->trans(
"NoAccountSelected").
'</span></div>';
178 $sql =
" UPDATE ".MAIN_DB_PREFIX.
"expensereport_det";
179 $sql .=
" SET fk_code_ventilation = ".((int) $monCompte);
180 $sql .=
" WHERE rowid = ".((int) $monId);
183 $accountventilated->fetch($monCompte,
'', 1);
185 dol_syslog(
'accountancy/expensereport/list.php:: sql='.
$sql, LOG_DEBUG);
186 if ($db->query(
$sql)) {
187 $msg .=
'<div><span class="green">'.$langs->trans(
"LineOfExpenseReport").
' '.$monId.
' - '.$langs->trans(
"VentilatedinAccount").
' : '.
length_accountg($accountventilated->account_number).
'</span></div>';
190 $msg .=
'<div><span class="error">'.$langs->trans(
"ErrorDB").
' : '.$langs->trans(
"Lineofinvoice").
' '.$monId.
' - '.$langs->trans(
"NotVentilatedinAccount").
' : '.
length_accountg($accountventilated->account_number).
'<br> <pre>'.
$sql.
'</pre></span></div>';
198 $msg .=
'<div>'.$langs->trans(
"EndProcessing").
'</div>';
211 llxHeader(
'', $langs->trans(
"ExpenseReportsVentilation"));
213 if (empty($chartaccountcode)) {
214 print $langs->trans(
"ErrorChartOfAccountSystemNotSelected");
222 $sql =
"SELECT er.ref, er.rowid as erid, er.date_debut, er.date_valid,";
223 $sql .=
" erd.rowid, erd.fk_c_type_fees, erd.comments, erd.total_ht as price, erd.fk_code_ventilation, erd.tva_tx as tva_tx_line, erd.vat_src_code, erd.date,";
224 $sql .=
" f.id as type_fees_id, f.code as type_fees_code, f.label as type_fees_label, f.accountancy_code as code_buy,";
225 $sql .=
" u.rowid as userid, u.login, u.lastname, u.firstname, u.email, u.gender, u.employee, u.photo, u.statut,";
226 $sql .=
" aa.rowid as aarowid";
227 $parameters = array();
228 $reshook = $hookmanager->executeHooks(
'printFieldListSelect', $parameters);
229 $sql .= $hookmanager->resPrint;
230 $sql .=
" FROM ".MAIN_DB_PREFIX.
"expensereport as er";
231 $sql .=
" INNER JOIN ".MAIN_DB_PREFIX.
"expensereport_det as erd ON er.rowid = erd.fk_expensereport";
232 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"c_type_fees as f ON f.id = erd.fk_c_type_fees";
233 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"user as u ON u.rowid = er.fk_user_author";
234 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"accounting_account as aa ON f.accountancy_code = aa.account_number AND aa.fk_pcg_version = '".$db->escape($chartaccountcode).
"' AND aa.entity = ".$conf->entity;
237 if (!empty($conf->global->ACCOUNTING_DATE_START_BINDING)) {
238 $sql .=
" AND er.date_debut >= '".$db->idate($conf->global->ACCOUNTING_DATE_START_BINDING).
"'";
241 if (strlen(trim($search_login))) {
244 if (strlen(trim($search_expensereport))) {
247 if (strlen(trim($search_label))) {
250 if (strlen(trim($search_desc))) {
253 if (strlen(trim($search_amount))) {
256 if (strlen(trim($search_account))) {
259 if (strlen(trim($search_vat))) {
262 if ($search_date_start) {
263 $sql .=
" AND erd.date >= '".$db->idate($search_date_start).
"'";
265 if ($search_date_end) {
266 $sql .=
" AND erd.date <= '".$db->idate($search_date_end).
"'";
268 $sql .=
" AND er.entity IN (".getEntity(
'expensereport', 0).
")";
271 $parameters = array();
272 $reshook = $hookmanager->executeHooks(
'printFieldListWhere', $parameters);
273 $sql .= $hookmanager->resPrint;
275 $sql .= $db->order($sortfield, $sortorder);
279 if (empty($conf->global->MAIN_DISABLE_FULL_SCANLIST)) {
280 $result = $db->query(
$sql);
288 $sql .= $db->plimit($limit + 1, $offset);
290 dol_syslog(
"accountancy/expensereport/list.php", LOG_DEBUG);
293 if ($db->type ==
'mysqli') {
294 $db->query(
"SET SQL_BIG_SELECTS=1");
297 $result = $db->query(
$sql);
299 $num_lines = $db->num_rows($result);
302 $arrayofselected = is_array($toselect) ? $toselect : array();
305 if (!empty($contextpage) && $contextpage != $_SERVER[
"PHP_SELF"]) {
306 $param .=
'&contextpage='.urlencode($contextpage);
308 if ($limit > 0 && $limit != $conf->liste_limit) {
309 $param .=
'&limit='.urlencode($limit);
312 $param .=
'&search_login='.urlencode($search_login);
314 if ($search_lineid) {
315 $param .=
'&search_lineid='.urlencode($search_lineid);
317 if ($search_date_startday) {
318 $param .=
'&search_date_startday='.urlencode($search_date_startday);
320 if ($search_date_startmonth) {
321 $param .=
'&search_date_startmonth='.urlencode($search_date_startmonth);
323 if ($search_date_startyear) {
324 $param .=
'&search_date_startyear='.urlencode($search_date_startyear);
326 if ($search_date_endday) {
327 $param .=
'&search_date_endday='.urlencode($search_date_endday);
329 if ($search_date_endmonth) {
330 $param .=
'&search_date_endmonth='.urlencode($search_date_endmonth);
332 if ($search_date_endyear) {
333 $param .=
'&search_date_endyear='.urlencode($search_date_endyear);
335 if ($search_expensereport) {
336 $param .=
'&search_expensereport='.urlencode($search_expensereport);
339 $param .=
'&search_label='.urlencode($search_label);
342 $param .=
'&search_desc='.urlencode($search_desc);
344 if ($search_amount) {
345 $param .=
'&search_amount='.urlencode($search_amount);
348 $param .=
'&search_vat='.urlencode($search_vat);
351 $arrayofmassactions = array(
352 'ventil' =>
img_picto(
'',
'check',
'class="pictofixedwidth"').$langs->trans(
"Ventilate")
354 $massactionbutton =
$form->selectMassAction(
'ventil', $arrayofmassactions, 1);
356 print
'<form action="'.$_SERVER[
"PHP_SELF"].
'" method="post">'.
"\n";
357 print
'<input type="hidden" name="action" value="ventil">';
358 if ($optioncss !=
'') {
359 print
'<input type="hidden" name="optioncss" value="'.$optioncss.
'">';
361 print
'<input type="hidden" name="token" value="'.newToken().
'">';
362 print
'<input type="hidden" name="formfilteraction" id="formfilteraction" value="list">';
363 print
'<input type="hidden" name="sortfield" value="'.$sortfield.
'">';
364 print
'<input type="hidden" name="sortorder" value="'.$sortorder.
'">';
365 print
'<input type="hidden" name="page" value="'.$page.
'">';
367 print_barre_liste($langs->trans(
"ExpenseReportLines"), $page, $_SERVER[
"PHP_SELF"], $param, $sortfield, $sortorder, $massactionbutton, $num_lines,
$nbtotalofrecords,
'title_accountancy', 0,
'',
'', $limit);
369 print
'<span class="opacitymedium">'.$langs->trans(
"DescVentilTodoExpenseReport").
'</span></br><br>';
377 print
'<div class="div-table-responsive">';
378 print
'<table class="tagtable liste'.($moreforfilter ?
" listwithfilterbefore" :
"").
'">'.
"\n";
381 print
'<tr class="liste_titre_filter">';
382 print
'<td class="liste_titre"><input type="text" name="search_login" class="maxwidth50" value="'.$search_login.
'"></td>';
383 print
'<td class="liste_titre"></td>';
384 print
'<td class="liste_titre"><input type="text" class="flat maxwidth50" name="search_expensereport" value="'.dol_escape_htmltag($search_expensereport).
'"></td>';
385 if (!empty($conf->global->ACCOUNTANCY_USE_EXPENSE_REPORT_VALIDATION_DATE)) {
386 print
'<td class="liste_titre"></td>';
388 print
'<td class="liste_titre center">';
389 print
'<div class="nowrap">';
390 print
$form->selectDate($search_date_start ? $search_date_start : -1,
'search_date_start', 0, 0, 1,
'', 1, 0, 0,
'',
'',
'',
'', 1,
'', $langs->trans(
'From'));
392 print
'<div class="nowrap">';
393 print
$form->selectDate($search_date_end ? $search_date_end : -1,
'search_date_end', 0, 0, 1,
'', 1, 0, 0,
'',
'',
'',
'', 1,
'', $langs->trans(
'to'));
396 print
'<td class="liste_titre"><input type="text" class="flat maxwidth50" name="search_label" value="'.dol_escape_htmltag($search_label).
'"></td>';
397 print
'<td class="liste_titre"><input type="text" class="flat maxwidthonsmartphone" name="search_desc" value="'.dol_escape_htmltag($search_desc).
'"></td>';
398 print
'<td class="liste_titre right"><input type="text" class="flat maxwidth50 right" name="search_amount" value="'.dol_escape_htmltag($search_amount).
'"></td>';
399 print
'<td class="liste_titre right"><input type="text" class="flat maxwidth50 right" name="search_vat" placeholder="%" size="1" value="'.dol_escape_htmltag($search_vat).
'"></td>';
400 print
'<td class="liste_titre"></td>';
401 print
'<td class="liste_titre"></td>';
402 print
'<td class="center liste_titre">';
403 $searchpicto =
$form->showFilterButtons();
408 print
'<tr class="liste_titre">';
411 print_liste_field_titre(
"ExpenseReport", $_SERVER[
"PHP_SELF"],
"er.ref",
"", $param,
'', $sortfield, $sortorder);
412 if (!empty($conf->global->ACCOUNTANCY_USE_EXPENSE_REPORT_VALIDATION_DATE)) {
413 print_liste_field_titre(
"DateValidation", $_SERVER[
"PHP_SELF"],
"er.date_valid",
"", $param,
'', $sortfield, $sortorder,
'center ');
415 print_liste_field_titre(
"DateOfLine", $_SERVER[
"PHP_SELF"],
"erd.date, erd.rowid",
"", $param,
'', $sortfield, $sortorder,
'center ');
417 print_liste_field_titre(
"Description", $_SERVER[
"PHP_SELF"],
"erd.comments",
"", $param,
'', $sortfield, $sortorder);
418 print_liste_field_titre(
"Amount", $_SERVER[
"PHP_SELF"],
"erd.total_ht",
"", $param,
'', $sortfield, $sortorder,
'right maxwidth50 ');
419 print_liste_field_titre(
"VATRate", $_SERVER[
"PHP_SELF"],
"erd.tva_tx",
"", $param,
'', $sortfield, $sortorder,
'right ');
423 if ($massactionbutton) {
424 $checkpicto =
$form->showCheckAddButtons(
'checkforselect', 1);
431 $userstatic =
new User($db);
434 while ($i < min($num_lines, $limit)) {
435 $objp = $db->fetch_object($result);
437 $objp->aarowid_suggest =
'';
438 $objp->aarowid_suggest = $objp->aarowid;
440 $expensereport_static->ref = $objp->ref;
441 $expensereport_static->id = $objp->erid;
443 $userstatic->id = $objp->userid;
444 $userstatic->login = $objp->login;
445 $userstatic->statut = $objp->statut;
446 $userstatic->email = $objp->email;
447 $userstatic->gender = $objp->gender;
448 $userstatic->firstname = $objp->firstname;
449 $userstatic->lastname = $objp->lastname;
450 $userstatic->employee = $objp->employee;
451 $userstatic->photo = $objp->photo;
453 print
'<tr class="oddeven">';
456 print
'<td class="nowraponall">';
457 print $userstatic->getNomUrl(-1,
'', 0, 0, 24, 1,
'login',
'', 1);
461 print
'<td>'.$objp->rowid.
'</td>';
464 print
'<td>'.$expensereport_static->getNomUrl(1).
'</td>';
467 if (!empty($conf->global->ACCOUNTANCY_USE_EXPENSE_REPORT_VALIDATION_DATE)) {
468 print
'<td class="center">'.dol_print_date($db->jdate($objp->date_valid),
'day').
'</td>';
472 print
'<td class="center">'.dol_print_date($db->jdate($objp->date),
'day').
'</td>';
476 print ($langs->trans($objp->type_fees_code) == $objp->type_fees_code ? $objp->type_fees_label : $langs->trans(($objp->type_fees_code)));
482 $trunclength = empty($conf->global->ACCOUNTING_LENGTH_DESCRIPTION) ? 32 : $conf->global->ACCOUNTING_LENGTH_DESCRIPTION;
483 print
$form->textwithtooltip(
dol_trunc($text, $trunclength), $objp->comments);
487 print
'<td class="right nowraponall amount">';
488 print
price($objp->price);
492 print
'<td class="right">';
493 print
vatrate($objp->tva_tx_line.($objp->vat_src_code ?
' ('.$objp->vat_src_code.
')' :
''));
503 print $formaccounting->select_account($objp->aarowid_suggest,
'codeventil'.$objp->rowid, 1, array(), 0, 0,
'codeventil maxwidth200 maxwidthonsmartphone',
'cachewithshowemptyone');
506 print
'<td class="center">';
507 print
'<input type="checkbox" class="flat checkforselect checkforselect'.$objp->rowid.
'" name="toselect[]" value="'.$objp->rowid.
"_".$i.
'"'.($objp->aarowid ?
"checked" :
"").
'/>';
513 if ($num_lines == 0) {
514 print
'<tr><td colspan="13"><span class="opacitymedium">'.$langs->trans(
"NoRecordFound").
'</span></td></tr>';
524 if ($db->type ==
'mysqli') {
525 $db->query(
"SET SQL_BIG_SELECTS=0");
529 print
'<script type="text/javascript">
530 jQuery(document).ready(function() {
531 jQuery(".codeventil").change(function() {
532 var s=$(this).attr("id").replace("codeventil", "")
533 console.log(s+" "+$(this).val());
534 if ($(this).val() == -1) jQuery(".checkforselect"+s).prop("checked", false);
535 else jQuery(".checkforselect"+s).prop("checked", true);