dolibarr 22.0.5
card.php
Go to the documentation of this file.
1<?php
2/* Copyright (C) 2003 Rodolphe Quiedeville <rodolphe@quiedeville.org>
3 * Copyright (C) 2004-2020 Laurent Destailleur <eldy@users.sourceforge.net>
4 * Copyright (C) 2005-2009 Regis Houssin <regis.houssin@inodbox.com>
5 * Copyright (C) 2015-2023 Alexandre Spangaro <aspangaro@open-dsi.fr>
6 * Copyright (C) 2017 Ferran Marcet <fmarcet@2byte.es>
7 * Copyright (C) 2018-2025 Frédéric France <frederic.france@free.fr>
8 * Copyright (C) 2024-2025 MDW <mdeweerd@users.noreply.github.com>
9 *
10 * This program is free software; you can redistribute it and/or modify
11 * it under the terms of the GNU General Public License as published by
12 * the Free Software Foundation; either version 3 of the License, or
13 * (at your option) any later version.
14 *
15 * This program is distributed in the hope that it will be useful,
16 * but WITHOUT ANY WARRANTY; without even the implied warranty of
17 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
18 * GNU General Public License for more details.
19 *
20 * You should have received a copy of the GNU General Public License
21 * along with this program. If not, see <https://www.gnu.org/licenses/>.
22 */
23
30// Load Dolibarr environment
31require '../main.inc.php';
32require_once DOL_DOCUMENT_ROOT.'/core/class/html.formexpensereport.class.php';
33require_once DOL_DOCUMENT_ROOT.'/core/class/html.formfile.class.php';
34require_once DOL_DOCUMENT_ROOT.'/core/class/html.formmail.class.php';
35require_once DOL_DOCUMENT_ROOT.'/core/class/html.formprojet.class.php';
36require_once DOL_DOCUMENT_ROOT.'/core/class/CMailFile.class.php';
37require_once DOL_DOCUMENT_ROOT.'/projet/class/project.class.php';
38require_once DOL_DOCUMENT_ROOT.'/ecm/class/ecmfiles.class.php';
39require_once DOL_DOCUMENT_ROOT.'/compta/bank/class/account.class.php';
40require_once DOL_DOCUMENT_ROOT.'/core/lib/expensereport.lib.php';
41require_once DOL_DOCUMENT_ROOT.'/core/lib/price.lib.php';
42require_once DOL_DOCUMENT_ROOT.'/core/lib/files.lib.php';
43require_once DOL_DOCUMENT_ROOT.'/core/lib/images.lib.php';
44require_once DOL_DOCUMENT_ROOT.'/core/modules/expensereport/modules_expensereport.php';
45require_once DOL_DOCUMENT_ROOT.'/expensereport/class/expensereport.class.php';
46require_once DOL_DOCUMENT_ROOT.'/expensereport/class/paymentexpensereport.class.php';
47require_once DOL_DOCUMENT_ROOT.'/core/class/doleditor.class.php';
48require_once DOL_DOCUMENT_ROOT.'/core/class/extrafields.class.php';
49if (isModEnabled('accounting')) {
50 require_once DOL_DOCUMENT_ROOT.'/accountancy/class/accountingjournal.class.php';
51}
52
64// Load translation files required by the page
65$langs->loadLangs(array("trips", "bills", "mails"));
66
67$action = GETPOST('action', 'aZ09');
68$cancel = GETPOST('cancel', 'alpha');
69$confirm = GETPOST('confirm', 'alpha');
70$backtopage = GETPOST('backtopage', 'alpha');
71
72$id = GETPOSTINT('id');
73$date_start = dol_mktime(0, 0, 0, GETPOSTINT('date_debutmonth'), GETPOSTINT('date_debutday'), GETPOSTINT('date_debutyear'));
74$date_end = dol_mktime(0, 0, 0, GETPOSTINT('date_finmonth'), GETPOSTINT('date_finday'), GETPOSTINT('date_finyear'));
75$date = dol_mktime(0, 0, 0, GETPOSTINT('datemonth'), GETPOSTINT('dateday'), GETPOSTINT('dateyear'));
76$fk_project = GETPOSTINT('fk_project');
77$vatrate = GETPOST('vatrate', 'alpha');
78$ref = GETPOST("ref", 'alpha');
79$comments = GETPOST('comments', 'restricthtml');
80$fk_c_type_fees = GETPOSTINT('fk_c_type_fees');
81$socid = GETPOSTINT('socid') ? GETPOSTINT('socid') : GETPOSTINT('socid_id');
82
84$childids = $user->getAllChildIds(1);
85
86if (getDolGlobalString('EXPENSEREPORT_PREFILL_DATES_WITH_CURRENT_MONTH')) {
87 if (empty($date_start)) {
88 $date_start = dol_mktime(0, 0, 0, (int) dol_print_date(dol_now(), '%m'), 1, (int) dol_print_date(dol_now(), '%Y'));
89 }
90
91 if (empty($date_end)) {
92 // date('t') => number of days in the month, so last day of the month too
93 $date_end = dol_mktime(0, 0, 0, (int) dol_print_date(dol_now(), '%m'), (int) date('t'), (int) dol_print_date(dol_now(), '%Y'));
94 }
95}
96
97// Hack to use expensereport dir
98$rootfordata = DOL_DATA_ROOT;
99$rootforuser = DOL_DATA_ROOT;
100// If multicompany module is enabled, we redefine the root of data
101if (isModEnabled('multicompany') && !empty($conf->entity) && $conf->entity > 1) {
102 $rootfordata .= '/'.$conf->entity;
103}
104$conf->expensereport->dir_output = $rootfordata.'/expensereport';
105
106// Define $urlwithroot
107$urlwithouturlroot = preg_replace('/'.preg_quote(DOL_URL_ROOT, '/').'$/i', '', trim($dolibarr_main_url_root));
108$urlwithroot = $urlwithouturlroot.DOL_URL_ROOT; // This is to use external domain name found into config file
109//$urlwithroot=DOL_MAIN_URL_ROOT; // This is to use same domain name than current
110
111// PDF
112$hidedetails = (GETPOSTINT('hidedetails') ? GETPOSTINT('hidedetails') : (getDolGlobalString('MAIN_GENERATE_DOCUMENTS_HIDE_DETAILS') ? 1 : 0));
113$hidedesc = (GETPOSTINT('hidedesc') ? GETPOSTINT('hidedesc') : (getDolGlobalString('MAIN_GENERATE_DOCUMENTS_HIDE_DESC') ? 1 : 0));
114$hideref = (GETPOSTINT('hideref') ? GETPOSTINT('hideref') : (getDolGlobalString('MAIN_GENERATE_DOCUMENTS_HIDE_REF') ? 1 : 0));
115
116
117$object = new ExpenseReport($db);
118$extrafields = new ExtraFields($db);
119
120// fetch optionals attributes and labels
121$extrafields->fetch_name_optionals_label($object->table_element);
122
123// Load object
124include DOL_DOCUMENT_ROOT.'/core/actions_fetchobject.inc.php'; // Must be 'include', not 'include_once'
125
126// Initialize a technical object to manage hooks of page. Note that conf->hooks_modules contains an array of hook context
127$hookmanager->initHooks(array('expensereportcard', 'globalcard'));
128
129
130// An existing expense report can be modified only if it is for the user or one of his subordinates, or with the permission to write the expense reports of everybody
131$caneditreport = (empty($object->id) || in_array($object->fk_user_author, $childids) || (getDolGlobalString('MAIN_USE_ADVANCED_PERMS') && $user->hasRight('expensereport', 'writeall_advance')));
132
133$permissionnote = $user->hasRight('expensereport', 'creer') && $caneditreport; // Used by the include of actions_setnotes.inc.php
134$permissiondellink = $user->hasRight('expensereport', 'creer') && $caneditreport; // Used by the include of actions_dellink.inc.php
135$permissiontoadd = $user->hasRight('expensereport', 'creer') && $caneditreport; // Used by the include of actions_addupdatedelete.inc.php and actions_lineupdown.inc.php
136$permissiontoeditextra = $permissiontoadd;
137if (GETPOST('attribute', 'aZ09') && isset($extrafields->attributes[$object->table_element]['perms'][GETPOST('attribute', 'aZ09')])) {
138 // For action 'update_extras', is there a specific permission set for the attribute to update
139 $permissiontoeditextra = dol_eval((string) $extrafields->attributes[$object->table_element]['perms'][GETPOST('attribute', 'aZ09')]);
140}
141
142$upload_dir = $conf->expensereport->dir_output.'/'.dol_sanitizeFileName($object->ref);
143
144$projectRequired = isModEnabled('project') && getDolGlobalString('EXPENSEREPORT_PROJECT_IS_REQUIRED');
145$fileRequired = getDolGlobalString('EXPENSEREPORT_FILE_IS_REQUIRED');
146
147if ($object->id > 0) {
148 // Check current user can read this expense report
149 $canread = 0;
150 if ($user->hasRight('expensereport', 'readall')) {
151 $canread = 1;
152 }
153 if (getDolGlobalString('MAIN_USE_ADVANCED_PERMS') && $user->hasRight('expensereport', 'writeall_advance')) {
154 $canread = 1; // Can create an expense report for everybody, so can also read it
155 }
156 if ($user->hasRight('expensereport', 'lire') && in_array($object->fk_user_author, $childids)) {
157 $canread = 1;
158 }
159 if ($user->hasRight('expensereport', 'approve') && $object->fk_user_validator == $user->id) {
160 $canread = 1; // The user designated to approve this expense report
161 }
162 if (!$canread) {
164 }
165}
166
167$candelete = 0;
168if ($user->hasRight('expensereport', 'supprimer')) {
169 $candelete = 1;
170}
171if ($object->status == ExpenseReport::STATUS_DRAFT && $user->hasRight('expensereport', 'write') && in_array($object->fk_user_author, $childids)) {
172 $candelete = 1;
173}
174
175// Security check
176if ($user->socid) {
177 $socid = $user->socid;
178}
179$result = restrictedArea($user, 'expensereport', $object->id, 'expensereport');
180
181$permissiontoadd = $user->hasRight('expensereport', 'creer') && $caneditreport; // Used by the include of actions_dellink.inc.php
182
183
184/*
185 * Actions
186 */
187
188$error = 0;
189
190$value_unit_ht = price2num(GETPOST('value_unit_ht', 'alpha'), 'MU');
191$value_unit = price2num(GETPOST('value_unit', 'alpha'), 'MU');
192$qty = price2num(GETPOST('qty', 'alpha'));
193
194$parameters = array('socid' => $socid);
195$reshook = $hookmanager->executeHooks('doActions', $parameters, $object, $action); // Note that $action and $object may have been modified by some hooks
196if ($reshook < 0) {
197 setEventMessages($hookmanager->error, $hookmanager->errors, 'errors');
198}
199
200if (empty($reshook)) {
201 $backurlforlist = DOL_URL_ROOT.'/expensereport/list.php';
202
203 if (empty($backtopage) || ($cancel && empty($id))) {
204 if (empty($backtopage) || ($cancel && strpos($backtopage, '__ID__'))) {
205 if (empty($id) && (($action != 'add' && $action != 'create') || $cancel)) {
206 $backtopage = $backurlforlist;
207 } else {
208 $backtopage = DOL_URL_ROOT.'/expensereport/card.php?id='.((!empty($id) && $id > 0) ? $id : '__ID__');
209 }
210 }
211 }
212
213 if ($cancel) {
214 if (!empty($backtopageforcancel)) {
215 header("Location: ".$backtopageforcancel);
216 exit;
217 } elseif (!empty($backtopage)) {
218 header("Location: ".$backtopage);
219 exit;
220 }
221 $action = '';
222
223 $fk_project = '';
224 $date_start = '';
225 $date_end = '';
226 $date = '';
227 $comments = '';
228 $vatrate = '';
229 $value_unit_ht = '';
230 $value_unit = '';
231 $qty = 1;
232 $fk_c_type_fees = -1;
233 }
234
235 // Refuse a status change that the buttons of this page do not offer for the current status of the report
236 $allowedstatusforaction = array(
237 'confirm_validate' => array(ExpenseReport::STATUS_DRAFT),
238 'confirm_save_from_refuse' => array(ExpenseReport::STATUS_REFUSED),
239 'confirm_approve' => array(ExpenseReport::STATUS_VALIDATED),
242 'confirm_setdraft' => array(ExpenseReport::STATUS_VALIDATED),
243 );
244 if ($user->hasRight('expensereport', 'approve') || $user->hasRight('expensereport', 'to_paid')) {
245 $allowedstatusforaction['confirm_cancel'][] = ExpenseReport::STATUS_CLOSED;
246 }
247 if ($user->hasRight('expensereport', 'to_paid')) {
248 $allowedstatusforaction['confirm_setdraft'][] = ExpenseReport::STATUS_APPROVED;
249 }
250 if (array_key_exists($action, $allowedstatusforaction) && $object->id > 0 && !in_array($object->status, $allowedstatusforaction[$action])) {
251 $labelsofallowedstatus = array();
252 foreach ($allowedstatusforaction[$action] as $allowedstatus) {
253 $labelsofallowedstatus[] = $object->LibStatut($allowedstatus, 0);
254 }
255 setEventMessages($langs->trans("StatusOfRefMustBe", $object->ref, implode(' / ', $labelsofallowedstatus)), null, 'errors');
256 $action = '';
257 }
258
259 include DOL_DOCUMENT_ROOT.'/core/actions_linkedfiles.inc.php';
260
261 if (!empty(GETPOST('sendit', 'alpha'))) { // If we just submit a file
262 if ($action == 'updateline') { // Test on permission not required here
263 $action = 'editline'; // To avoid to make the updateline now
264 } else {
265 $action = ''; // To avoid to make the addline now
266 }
267 }
268
269 include DOL_DOCUMENT_ROOT.'/core/actions_setnotes.inc.php'; // Must be 'include', not 'include_once'
270
271 include DOL_DOCUMENT_ROOT.'/core/actions_dellink.inc.php'; // Must be 'include', not 'include_once'
272
273 include DOL_DOCUMENT_ROOT.'/core/actions_lineupdown.inc.php'; // Must be 'include', not 'include_once'
274
275 // Action clone object
276 if ($action == 'confirm_clone' && $confirm == 'yes' && $permissiontoadd) {
277 // @phan-suppress-next-line PhanPluginBothLiteralsBinaryOp
278 if (1 == 0 && !GETPOST('clone_content', 'alpha') && !GETPOST('clone_receivers', 'alpha')) {
279 setEventMessages($langs->trans("NoCloneOptionsSpecified"), null, 'errors');
280 } else {
281 // Check that the new expense report is for a user inside the hierarchy, or that advanced permission for all is set (same rule as for action 'add')
282 $fk_user_author_clone = (GETPOSTINT('fk_user_author') > 0 ? GETPOSTINT('fk_user_author') : $user->id);
283 if ((!getDolGlobalString('MAIN_USE_ADVANCED_PERMS') || !$user->hasRight('expensereport', 'writeall_advance')) && !in_array($fk_user_author_clone, $childids)) {
284 setEventMessages($langs->trans("UserNotInHierachy"), null, 'errors');
285 $action = '';
286 } elseif ($object->id > 0) {
287 // Because createFromClone modifies the object, we must clone it so that we can restore it later if it fails
288 $orig = clone $object;
289
290 $result = $object->createFromClone($user, GETPOSTINT('fk_user_author'));
291 if ($result > 0) {
292 header("Location: ".$_SERVER['PHP_SELF'].'?id='.$result);
293 exit;
294 } else {
295 setEventMessages($object->error, $object->errors, 'errors');
296 $object = $orig;
297 $action = '';
298 }
299 }
300 }
301 }
302
303 if ($action == 'confirm_delete' && GETPOST("confirm", 'alpha') == "yes" && $id > 0 && $candelete) {
304 $object = new ExpenseReport($db);
305 $result = $object->fetch($id);
306 $result = $object->delete($user);
307 if ($result >= 0) {
308 header("Location: index.php");
309 exit;
310 } else {
311 setEventMessages($object->error, $object->errors, 'errors');
312 }
313 }
314
315 if ($action == 'add' && $permissiontoadd) {
316 $object = new ExpenseReport($db);
317
318 $object->date_debut = $date_start;
319 $object->date_fin = $date_end;
320
321 $object->fk_user_author = GETPOSTINT('fk_user_author');
322 if (!($object->fk_user_author > 0)) {
323 $object->fk_user_author = $user->id;
324 }
325
326 // Check that expense report is for a user inside the hierarchy, or that advanced permission for all is set
327 if ((!getDolGlobalString('MAIN_USE_ADVANCED_PERMS') && !$user->hasRight('expensereport', 'creer'))
328 || (getDolGlobalString('MAIN_USE_ADVANCED_PERMS') && !$user->hasRight('expensereport', 'creer') && !$user->hasRight('expensereport', 'writeall_advance'))) {
329 $error++;
330 setEventMessages($langs->trans("NotEnoughPermissions"), null, 'errors');
331 }
332 if (!$error) {
333 if (!getDolGlobalString('MAIN_USE_ADVANCED_PERMS') || !$user->hasRight('expensereport', 'writeall_advance')) {
334 if (!in_array($object->fk_user_author, $childids)) {
335 $error++;
336 setEventMessages($langs->trans("UserNotInHierachy"), null, 'errors');
337 }
338 }
339 }
340
341 $fuser = new User($db);
342 $fuser->fetch($object->fk_user_author);
343
344 $object->status = 1;
345 $object->fk_c_paiement = GETPOSTINT('fk_c_paiement');
346 $object->fk_user_validator = GETPOSTINT('fk_user_validator');
347 $object->note_public = GETPOST('note_public', 'restricthtml');
348 $object->note_private = GETPOST('note_private', 'restricthtml');
349 // Fill array 'array_options' with data from add form
350 if (!$error) {
351 $ret = $extrafields->setOptionalsFromPost(null, $object);
352 if ($ret < 0) {
353 $error++;
354 }
355 }
356
357 if (!$error && !getDolGlobalString('EXPENSEREPORT_ALLOW_OVERLAPPING_PERIODS')) {
358 $overlappingExpenseReportID = $object->periodExists($fuser, $object->date_debut, $object->date_fin);
359
360 if ($overlappingExpenseReportID > 0) {
361 $error++;
362 setEventMessages($langs->trans("ErrorDoubleDeclaration").' <a href="'.$_SERVER['PHP_SELF'].'?id='.$overlappingExpenseReportID.'">'. $langs->trans('ShowTrip').'</a>', null, 'errors');
363 $action = 'create';
364 }
365 }
366
367 if (!$error) {
368 $db->begin();
369
370 $id = $object->create($user);
371 if ($id <= 0) {
372 $error++;
373 }
374
375 if (!$error) {
376 $db->commit();
377 header("Location: ".$_SERVER["PHP_SELF"]."?id=".$id);
378 exit;
379 } else {
380 setEventMessages($object->error, $object->errors, 'errors');
381 $db->rollback();
382 $action = 'create';
383 }
384 }
385 }
386
387 if (($action == 'update' || $action == 'updateFromRefuse') && $permissiontoadd) {
388 $object = new ExpenseReport($db);
389 $object->fetch($id);
390
391 $object->date_debut = $date_start;
392 $object->date_fin = $date_end;
393
394 if ($object->status < 3) {
395 $object->fk_user_validator = GETPOSTINT('fk_user_validator');
396 }
397
398 $object->fk_c_paiement = GETPOSTINT('fk_c_paiement');
399 $object->note_public = GETPOST('note_public', 'restricthtml');
400 $object->note_private = GETPOST('note_private', 'restricthtml');
401 $object->fk_user_modif = $user->id;
402
403 $result = $object->update($user);
404 if ($result > 0) {
405 header("Location: ".$_SERVER["PHP_SELF"]."?id=".GETPOSTINT('id'));
406 exit;
407 } else {
408 setEventMessages($object->error, $object->errors, 'errors');
409 }
410 }
411
412 if ($action == 'update_extras' && $permissiontoeditextra) {
413 $object->oldcopy = dol_clone($object, 2); // @phan-suppress-current-line PhanTypeMismatchProperty
414
415 $attribute_name = GETPOST('attribute', 'aZ09');
416
417 // Fill array 'array_options' with data from update form
418 $ret = $extrafields->setOptionalsFromPost(null, $object, $attribute_name);
419 if ($ret < 0) {
420 $error++;
421 }
422
423 if (!$error) {
424 $result = $object->updateExtraField($attribute_name, 'EXPENSEREPORT_MODIFY');
425 if ($result < 0) {
426 setEventMessages($object->error, $object->errors, 'errors');
427 $error++;
428 }
429 }
430
431 if ($error) {
432 $action = 'edit_extras';
433 }
434 }
435
436 if ($action == "confirm_validate" && GETPOST("confirm", 'alpha') == "yes" && $id > 0 && $permissiontoadd) {
437 $db->begin();
438
439 $object = new ExpenseReport($db);
440 $object->fetch($id);
441
442 $result = $object->setValidate($user);
443
444 if ($result >= 0) {
445 // Define output language
446 if (!getDolGlobalString('MAIN_DISABLE_PDF_AUTOUPDATE')) {
447 $outputlangs = $langs;
448 $newlang = '';
449 if (getDolGlobalInt('MAIN_MULTILANGS') /* && empty($newlang) */ && GETPOST('lang_id', 'aZ09')) {
450 $newlang = GETPOST('lang_id', 'aZ09');
451 }
452 if (getDolGlobalInt('MAIN_MULTILANGS') && empty($newlang)) {
453 $tmpuser = new User($db);
454 $tmpuser->fetch($object->fk_user_author);
455 $newlang = $tmpuser->lang;
456 }
457 if (!empty($newlang)) {
458 $outputlangs = new Translate("", $conf);
459 $outputlangs->setDefaultLang($newlang);
460 }
461 $model = $object->model_pdf;
462 $ret = $object->fetch($id); // Reload to get new records
463
464 $object->generateDocument($model, $outputlangs, $hidedetails, $hidedesc, $hideref);
465 }
466 } else {
467 setEventMessages($object->error, $object->errors, 'errors');
468 $error++;
469 }
470
471 if (!$error && $result > 0 && $object->fk_user_validator > 0) {
472 $langs->load("mails");
473
474 // TO
475 $destinataire = new User($db);
476 $destinataire->fetch($object->fk_user_validator);
477 $emailTo = $destinataire->email;
478
479 // FROM
480 $expediteur = new User($db);
481 $expediteur->fetch($object->fk_user_author);
482 $emailFrom = getDolGlobalString('MAIN_MAIL_EMAIL_FROM');
483
484 if ($emailTo && $emailFrom) {
485 $filename = array();
486 $filedir = array();
487 $mimetype = array();
488
489 // SUBJECT
490 $societeName = getDolGlobalString('MAIN_INFO_SOCIETE_NOM');
491 if (getDolGlobalString('MAIN_APPLICATION_TITLE')) {
492 $societeName = getDolGlobalString('MAIN_APPLICATION_TITLE');
493 }
494
495 $subject = $societeName." - ".$langs->transnoentities("ExpenseReportWaitingForApproval");
496
497 // CONTENT
498 $link = $urlwithroot.'/expensereport/card.php?id='.$object->id;
499 $link = '<a href="'.$link.'">'.$link.'</a>';
500 $message = $langs->transnoentities("ExpenseReportWaitingForApprovalMessage", $expediteur->getFullName($langs), get_date_range($object->date_debut, $object->date_fin, '', $langs), $link);
501
502 // Rebuild pdf
503 /*
504 $object->setDocModel($user,"");
505 $resultPDF = expensereport_pdf_create($db,$id,'',"",$langs);
506
507 if($resultPDF):
508 // ATTACHMENT
509 array_push($filename,dol_sanitizeFileName($object->ref).".pdf");
510 array_push($filedir,$conf->expensereport->dir_output . "/" . dol_sanitizeFileName($object->ref) . "/" . dol_sanitizeFileName($object->ref).".pdf");
511 array_push($mimetype,"application/pdf");
512 */
513
514 // PREPARE SEND
515 $mailfile = new CMailFile($subject, $emailTo, $emailFrom, $message, $filedir, $mimetype, $filename, '', '', 0, -1);
516
517 if (empty($mailfile->error)) {
518 // SEND
519 $result = $mailfile->sendfile();
520 if ($result) {
521 $mesg = $langs->trans('MailSuccessfulySent', $mailfile->getValidAddress($emailFrom, 2), $mailfile->getValidAddress($emailTo, 2));
522 setEventMessages($mesg, null, 'mesgs');
523 } else {
524 $langs->load("other");
525 if (!empty($mailfile->error) || !empty($mailfile->errors)) {
526 $mesg = '';
527 $mesg .= $langs->transnoentities('ErrorFailedToSendMail', dol_escape_htmltag($emailFrom), dol_escape_htmltag($emailTo));
528 if (!empty($mailfile->error)) {
529 $mesg .= '<br>' . $mailfile->error;
530 }
531 if (!empty($mailfile->errors) && is_array($mailfile->errors)) {
532 $mesg .= '<br>' . implode('<br>', $mailfile->errors);
533 }
534 setEventMessages($mesg, null, 'errors');
535 } else {
536 setEventMessages('No mail sent. Feature is disabled by option MAIN_DISABLE_ALL_MAILS', null, 'warnings');
537 }
538 }
539 } else {
540 setEventMessages($mailfile->error, $mailfile->errors, 'errors');
541 $action = '';
542 }
543 } else {
544 setEventMessages($langs->trans("NoEmailSentBadSenderOrRecipientEmail"), null, 'warnings');
545 $action = '';
546 }
547 }
548
549 if (!$error) {
550 $db->commit();
551 header("Location: ".$_SERVER["PHP_SELF"]."?id=".$id);
552 exit;
553 } else {
554 $db->rollback();
555 }
556 }
557
558 if ($action == "confirm_save_from_refuse" && GETPOST("confirm", 'alpha') == "yes" && $id > 0 && $permissiontoadd) {
559 $object = new ExpenseReport($db);
560 $object->fetch($id);
561 $result = $object->set_save_from_refuse($user);
562
563 if ($result > 0) {
564 // Define output language
565 if (!getDolGlobalString('MAIN_DISABLE_PDF_AUTOUPDATE')) {
566 $outputlangs = $langs;
567 $newlang = '';
568 if (getDolGlobalInt('MAIN_MULTILANGS') /* && empty($newlang) */ && GETPOST('lang_id', 'aZ09')) {
569 $newlang = GETPOST('lang_id', 'aZ09');
570 }
571 if (getDolGlobalInt('MAIN_MULTILANGS') && empty($newlang)) {
572 $tmpuser = new User($db);
573 $tmpuser->fetch($object->fk_user_author);
574 $newlang = $tmpuser->lang;
575 }
576 if (!empty($newlang)) {
577 $outputlangs = new Translate("", $conf);
578 $outputlangs->setDefaultLang($newlang);
579 }
580 $model = $object->model_pdf;
581 $ret = $object->fetch($id); // Reload to get new records
582
583 $object->generateDocument($model, $outputlangs, $hidedetails, $hidedesc, $hideref);
584 }
585 }
586
587 if ($result > 0) {
588 // Send mail
589
590 // TO
591 $destinataire = new User($db);
592 $destinataire->fetch($object->fk_user_validator);
593 $emailTo = $destinataire->email;
594
595 // FROM
596 $expediteur = new User($db);
597 $expediteur->fetch($object->fk_user_author);
598 $emailFrom = getDolGlobalString('MAIN_MAIL_EMAIL_FROM');
599
600 if ($emailFrom && $emailTo) {
601 $filename = array();
602 $filedir = array();
603 $mimetype = array();
604
605 // SUBJECT
606 $societeName = getDolGlobalString('MAIN_INFO_SOCIETE_NOM');
607 if (getDolGlobalString('MAIN_APPLICATION_TITLE')) {
608 $societeName = getDolGlobalString('MAIN_APPLICATION_TITLE');
609 }
610
611 $subject = $societeName." - ".$langs->transnoentities("ExpenseReportWaitingForReApproval");
612
613 // CONTENT
614 $link = $urlwithroot.'/expensereport/card.php?id='.$object->id;
615 $link = '<a href="'.$link.'">'.$link.'</a>';
616 $message = $langs->transnoentities("ExpenseReportWaitingForReApprovalMessage", dol_print_date($object->date_refuse, 'day'), $object->detail_refuse, $expediteur->getFullName($langs), get_date_range($object->date_debut, $object->date_fin, '', $langs));
617 $message .= '<br>'.$langs->transnoentities("ExpenseReportWaitingForReApprovalMessage2", $link);
618
619 // Rebuild pdf
620 /*
621 $object->setDocModel($user,"");
622 $resultPDF = expensereport_pdf_create($db,$object,'',"",$langs);
623
624 if($resultPDF)
625 {
626 // ATTACHMENT
627 $filename=array(); $filedir=array(); $mimetype=array();
628 array_push($filename,dol_sanitizeFileName($object->ref).".pdf");
629 array_push($filedir,$conf->expensereport->dir_output . "/" . dol_sanitizeFileName($object->ref) . "/" . dol_sanitizeFileName($object->ref_number).".pdf");
630 array_push($mimetype,"application/pdf");
631 }
632 */
633
634
635 // PREPARE SEND
636 $mailfile = new CMailFile($subject, $emailTo, $emailFrom, $message, $filedir, $mimetype, $filename, '', '', 0, -1);
637
638 if (empty($mailfile->error)) {
639 // SEND
640 $result = $mailfile->sendfile();
641 if ($result) {
642 $mesg = $langs->trans('MailSuccessfulySent', $mailfile->getValidAddress($emailFrom, 2), $mailfile->getValidAddress($emailTo, 2));
643 setEventMessages($mesg, null, 'mesgs');
644 header("Location: ".$_SERVER["PHP_SELF"]."?id=".$id);
645 exit;
646 } else {
647 $langs->load("other");
648 if ($mailfile->error) {
649 $mesg = '';
650 $mesg .= $langs->trans('ErrorFailedToSendMail', $emailFrom, $emailTo);
651 $mesg .= '<br>'.$mailfile->error;
652 setEventMessages($mesg, null, 'errors');
653 } else {
654 setEventMessages('No mail sent. Feature is disabled by option MAIN_DISABLE_ALL_MAILS', null, 'warnings');
655 }
656 }
657 } else {
658 setEventMessages($mailfile->error, $mailfile->errors, 'errors');
659 $action = '';
660 }
661 } else {
662 setEventMessages($langs->trans("NoEmailSentBadSenderOrRecipientEmail"), null, 'warnings');
663 $action = '';
664 }
665 } else {
666 setEventMessages($object->error, $object->errors, 'errors');
667 }
668 }
669
670 // Approve
671 if ($action == "confirm_approve" && GETPOST("confirm", 'alpha') == "yes" && $id > 0 && $user->hasRight('expensereport', 'approve')) {
672 $object = new ExpenseReport($db);
673 $object->fetch($id);
674
675 $result = $object->setApproved($user);
676
677 if ($result > 0) {
678 // Define output language
679 if (!getDolGlobalString('MAIN_DISABLE_PDF_AUTOUPDATE')) {
680 $outputlangs = $langs;
681 $newlang = '';
682 if (getDolGlobalInt('MAIN_MULTILANGS') /* && empty($newlang) */ && GETPOST('lang_id', 'aZ09')) {
683 $newlang = GETPOST('lang_id', 'aZ09');
684 }
685 if (getDolGlobalInt('MAIN_MULTILANGS') && empty($newlang)) {
686 $tmpuser = new User($db);
687 $tmpuser->fetch($object->fk_user_author);
688 $newlang = $tmpuser->lang;
689 }
690 if (!empty($newlang)) {
691 $outputlangs = new Translate("", $conf);
692 $outputlangs->setDefaultLang($newlang);
693 }
694 $model = $object->model_pdf;
695 $ret = $object->fetch($id); // Reload to get new records
696
697 $object->generateDocument($model, $outputlangs, $hidedetails, $hidedesc, $hideref);
698 }
699 }
700
701 if ($result > 0) {
702 // Send mail
703
704 // TO
705 $destinataire = new User($db);
706 $destinataire->fetch($object->fk_user_author);
707 $emailTo = $destinataire->email;
708
709 // CC
710 $emailCC = getDolGlobalString('NDF_CC_EMAILS');
711 if (empty($emailTo)) {
712 $emailTo = $emailCC;
713 }
714
715 // FROM
716 $expediteur = new User($db);
717 $expediteur->fetch($object->fk_user_approve > 0 ? $object->fk_user_approve : $object->fk_user_validator);
718 $emailFrom = getDolGlobalString('MAIN_MAIL_EMAIL_FROM');
719
720 if ($emailFrom && $emailTo) {
721 $filename = array();
722 $filedir = array();
723 $mimetype = array();
724
725 // SUBJECT
726 $societeName = getDolGlobalString('MAIN_INFO_SOCIETE_NOM');
727 if (getDolGlobalString('MAIN_APPLICATION_TITLE')) {
728 $societeName = getDolGlobalString('MAIN_APPLICATION_TITLE');
729 }
730
731 $subject = $societeName." - ".$langs->transnoentities("ExpenseReportApproved");
732
733 // CONTENT
734 $link = $urlwithroot.'/expensereport/card.php?id='.$object->id;
735 $link = '<a href="'.$link.'">'.$link.'</a>';
736 $message = $langs->transnoentities("ExpenseReportApprovedMessage", $object->ref, $destinataire->getFullName($langs), $expediteur->getFullName($langs), $link);
737
738 // Rebuilt pdf
739 /*
740 $object->setDocModel($user,"");
741 $resultPDF = expensereport_pdf_create($db,$object,'',"",$langs);
742
743 if($resultPDF
744 {
745 // ATTACHMENT
746 $filename=array(); $filedir=array(); $mimetype=array();
747 array_push($filename,dol_sanitizeFileName($object->ref).".pdf");
748 array_push($filedir, $conf->expensereport->dir_output."/".dol_sanitizeFileName($object->ref)."/".dol_sanitizeFileName($object->ref).".pdf");
749 array_push($mimetype,"application/pdf");
750 }
751 */
752
753 $mailfile = new CMailFile($subject, $emailTo, $emailFrom, $message, $filedir, $mimetype, $filename, $emailCC, '', 0, -1);
754
755 if (empty($mailfile->error)) {
756 // SEND
757 $result = $mailfile->sendfile();
758 if ($result) {
759 $mesg = $langs->trans('MailSuccessfulySent', $mailfile->getValidAddress($emailFrom, 2), $mailfile->getValidAddress($emailTo, 2));
760 setEventMessages($mesg, null, 'mesgs');
761 header("Location: ".$_SERVER["PHP_SELF"]."?id=".$id);
762 exit;
763 } else {
764 $langs->load("other");
765 if ($mailfile->error) {
766 $mesg = '';
767 $mesg .= $langs->trans('ErrorFailedToSendMail', $emailFrom, $emailTo);
768 $mesg .= '<br>'.$mailfile->error;
769 setEventMessages($mesg, null, 'errors');
770 } else {
771 setEventMessages('No mail sent. Feature is disabled by option MAIN_DISABLE_ALL_MAILS', null, 'warnings');
772 }
773 }
774 } else {
775 setEventMessages($mailfile->error, $mailfile->errors, 'errors');
776 $action = '';
777 }
778 } else {
779 setEventMessages($langs->trans("NoEmailSentBadSenderOrRecipientEmail"), null, 'warnings');
780 $action = '';
781 }
782 } else {
783 setEventMessages($langs->trans("FailedtoSetToApprove"), null, 'warnings');
784 $action = '';
785 }
786 }
787
788 if ($action == "confirm_refuse" && GETPOST('confirm', 'alpha') == "yes" && $id > 0 && $user->hasRight('expensereport', 'approve')) {
789 $object = new ExpenseReport($db);
790 $object->fetch($id);
791
792 $detailRefuse = GETPOST('detail_refuse', 'alpha');
793 $result = $object->setDeny($user, $detailRefuse);
794
795 if ($result > 0) {
796 // Define output language
797 if (!getDolGlobalString('MAIN_DISABLE_PDF_AUTOUPDATE')) {
798 $outputlangs = $langs;
799 $newlang = '';
800 if (getDolGlobalInt('MAIN_MULTILANGS') /* && empty($newlang) */ && GETPOST('lang_id', 'aZ09')) {
801 $newlang = GETPOST('lang_id', 'aZ09');
802 }
803 if (getDolGlobalInt('MAIN_MULTILANGS') && empty($newlang)) {
804 $tmpuser = new User($db);
805 $tmpuser->fetch($object->fk_user_author);
806 $newlang = $tmpuser->lang;
807 }
808 if (!empty($newlang)) {
809 $outputlangs = new Translate("", $conf);
810 $outputlangs->setDefaultLang($newlang);
811 }
812 $model = $object->model_pdf;
813 $ret = $object->fetch($id); // Reload to get new records
814
815 $object->generateDocument($model, $outputlangs, $hidedetails, $hidedesc, $hideref);
816 }
817 }
818
819 if ($result > 0) {
820 // Send mail
821
822 // TO
823 $destinataire = new User($db);
824 $destinataire->fetch($object->fk_user_author);
825 $emailTo = $destinataire->email;
826
827 // FROM
828 $expediteur = new User($db);
829 $expediteur->fetch($object->fk_user_refuse);
830 $emailFrom = getDolGlobalString('MAIN_MAIL_EMAIL_FROM');
831
832 if ($emailFrom && $emailTo) {
833 $filename = array();
834 $filedir = array();
835 $mimetype = array();
836
837 // SUBJECT
838 $societeName = getDolGlobalString('MAIN_INFO_SOCIETE_NOM');
839 if (getDolGlobalString('MAIN_APPLICATION_TITLE')) {
840 $societeName = getDolGlobalString('MAIN_APPLICATION_TITLE');
841 }
842
843 $subject = $societeName." - ".$langs->transnoentities("ExpenseReportRefused");
844
845 // CONTENT
846 $link = $urlwithroot.'/expensereport/card.php?id='.$object->id;
847 $link = '<a href="'.$link.'">'.$link.'</a>';
848 $message = $langs->transnoentities("ExpenseReportRefusedMessage", $object->ref, $destinataire->getFullName($langs), $expediteur->getFullName($langs), $detailRefuse, $link);
849
850 // Rebuilt pdf
851 /*
852 $object->setDocModel($user,"");
853 $resultPDF = expensereport_pdf_create($db,$object,'',"",$langs);
854
855 if($resultPDF
856 {
857 // ATTACHMENT
858 $filename=array(); $filedir=array(); $mimetype=array();
859 array_push($filename,dol_sanitizeFileName($object->ref).".pdf");
860 array_push($filedir, $conf->expensereport->dir_output."/".dol_sanitizeFileName($object->ref)."/".dol_sanitizeFileName($object->ref).".pdf");
861 array_push($mimetype,"application/pdf");
862 }
863 */
864
865 // PREPARE SEND
866 $mailfile = new CMailFile($subject, $emailTo, $emailFrom, $message, $filedir, $mimetype, $filename, '', '', 0, -1);
867
868 if (empty($mailfile->error)) {
869 // SEND
870 $result = $mailfile->sendfile();
871 if ($result) {
872 $mesg = $langs->trans('MailSuccessfulySent', $mailfile->getValidAddress($emailFrom, 2), $mailfile->getValidAddress($emailTo, 2));
873 setEventMessages($mesg, null, 'mesgs');
874 header("Location: ".$_SERVER["PHP_SELF"]."?id=".$id);
875 exit;
876 } else {
877 $langs->load("other");
878 if ($mailfile->error) {
879 $mesg = '';
880 $mesg .= $langs->trans('ErrorFailedToSendMail', $emailFrom, $emailTo);
881 $mesg .= '<br>'.$mailfile->error;
882 setEventMessages($mesg, null, 'errors');
883 } else {
884 setEventMessages('No mail sent. Feature is disabled by option MAIN_DISABLE_ALL_MAILS', null, 'warnings');
885 }
886 }
887 } else {
888 setEventMessages($mailfile->error, $mailfile->errors, 'errors');
889 $action = '';
890 }
891 } else {
892 setEventMessages($langs->trans("NoEmailSentBadSenderOrRecipientEmail"), null, 'warnings');
893 $action = '';
894 }
895 } else {
896 setEventMessages($langs->trans("FailedtoSetToDeny"), null, 'warnings');
897 $action = '';
898 }
899 }
900
901 //var_dump($user->id == $object->fk_user_validator);exit;
902 if ($action == "confirm_cancel" && GETPOST('confirm', 'alpha') == "yes" && $id > 0 && $user->hasRight('expensereport', 'creer')) {
903 if (!GETPOST('detail_cancel', 'alpha')) {
904 setEventMessages($langs->trans("ErrorFieldRequired", $langs->transnoentitiesnoconv("Comment")), null, 'errors');
905 } else {
906 $object = new ExpenseReport($db);
907 $object->fetch($id);
908
909 if ($user->id == $object->fk_user_valid || $user->id == $object->fk_user_author) {
910 $detailCancel = GETPOST('detail_cancel', 'alpha');
911 $result = $object->set_cancel($user, $detailCancel);
912
913 if ($result > 0) {
914 // Define output language
915 if (!getDolGlobalString('MAIN_DISABLE_PDF_AUTOUPDATE')) {
916 $outputlangs = $langs;
917 $newlang = '';
918 if (getDolGlobalInt('MAIN_MULTILANGS') /* && empty($newlang) */ && GETPOST('lang_id', 'aZ09')) {
919 $newlang = GETPOST('lang_id', 'aZ09');
920 }
921 if (getDolGlobalInt('MAIN_MULTILANGS') && empty($newlang)) {
922 $tmpuser = new User($db);
923 $tmpuser->fetch($object->fk_user_author);
924 $newlang = $tmpuser->lang;
925 }
926 if (!empty($newlang)) {
927 $outputlangs = new Translate("", $conf);
928 $outputlangs->setDefaultLang($newlang);
929 }
930 $model = $object->model_pdf;
931 $ret = $object->fetch($id); // Reload to get new records
932
933 $object->generateDocument($model, $outputlangs, $hidedetails, $hidedesc, $hideref);
934 }
935 }
936
937 if ($result > 0) {
938 // Send mail
939
940 // TO
941 $destinataire = new User($db);
942 $destinataire->fetch($object->fk_user_author);
943 $emailTo = $destinataire->email;
944
945 // FROM
946 $expediteur = new User($db);
947 $expediteur->fetch($object->fk_user_cancel);
948 $emailFrom = getDolGlobalString('MAIN_MAIL_EMAIL_FROM');
949
950 if ($emailFrom && $emailTo) {
951 $filename = array();
952 $filedir = array();
953 $mimetype = array();
954
955 // SUBJECT
956 $societeName = getDolGlobalString('MAIN_INFO_SOCIETE_NOM');
957 if (getDolGlobalString('MAIN_APPLICATION_TITLE')) {
958 $societeName = getDolGlobalString('MAIN_APPLICATION_TITLE');
959 }
960
961 $subject = $societeName." - ".$langs->transnoentities("ExpenseReportCanceled");
962
963 // CONTENT
964 $link = $urlwithroot.'/expensereport/card.php?id='.$object->id;
965 $link = '<a href="'.$link.'">'.$link.'</a>';
966 $message = $langs->transnoentities("ExpenseReportCanceledMessage", $object->ref, $destinataire->getFullName($langs), $expediteur->getFullName($langs), $detailCancel, $link);
967
968 // Rebuilt pdf
969 /*
970 $object->setDocModel($user,"");
971 $resultPDF = expensereport_pdf_create($db,$object,'',"",$langs);
972
973 if($resultPDF
974 {
975 // ATTACHMENT
976 $filename=array(); $filedir=array(); $mimetype=array();
977 array_push($filename,dol_sanitizeFileName($object->ref).".pdf");
978 array_push($filedir, $conf->expensereport->dir_output."/".dol_sanitizeFileName($object->ref)."/".dol_sanitizeFileName($object->ref).".pdf");
979 array_push($mimetype,"application/pdf");
980 }
981 */
982
983 // PREPARE SEND
984 $mailfile = new CMailFile($subject, $emailTo, $emailFrom, $message, $filedir, $mimetype, $filename, '', '', 0, -1);
985
986 if (empty($mailfile->error)) {
987 // SEND
988 $result = $mailfile->sendfile();
989 if ($result) {
990 $mesg = $langs->trans('MailSuccessfulySent', $mailfile->getValidAddress($emailFrom, 2), $mailfile->getValidAddress($emailTo, 2));
991 setEventMessages($mesg, null, 'mesgs');
992 header("Location: ".$_SERVER["PHP_SELF"]."?id=".$id);
993 exit;
994 } else {
995 $langs->load("other");
996 if ($mailfile->error) {
997 $mesg = '';
998 $mesg .= $langs->trans('ErrorFailedToSendMail', $emailFrom, $emailTo);
999 $mesg .= '<br>'.$mailfile->error;
1000 setEventMessages($mesg, null, 'errors');
1001 } else {
1002 setEventMessages('No mail sent. Feature is disabled by option MAIN_DISABLE_ALL_MAILS', null, 'warnings');
1003 }
1004 }
1005 } else {
1006 setEventMessages($mailfile->error, $mailfile->errors, 'errors');
1007 $action = '';
1008 }
1009 } else {
1010 setEventMessages($langs->trans("NoEmailSentBadSenderOrRecipientEmail"), null, 'warnings');
1011 $action = '';
1012 }
1013 } else {
1014 setEventMessages($langs->trans("FailedToSetToCancel"), null, 'warnings');
1015 $action = '';
1016 }
1017 } else {
1018 setEventMessages($object->error, $object->errors, 'errors');
1019 }
1020 }
1021 }
1022
1023 if ($action == "confirm_setdraft" && GETPOST('confirm', 'alpha') == "yes" && $id > 0 && $user->hasRight('expensereport', 'creer')) {
1024 $object = new ExpenseReport($db);
1025 $object->fetch($id);
1026 if ($user->id == $object->fk_user_author || $user->id == $object->fk_user_valid || in_array($object->fk_user_author, $childids)) {
1027 $result = $object->setStatut(0);
1028
1029 if ($result > 0) {
1030 // Define output language
1031 if (!getDolGlobalString('MAIN_DISABLE_PDF_AUTOUPDATE')) {
1032 $outputlangs = $langs;
1033 $newlang = '';
1034 if (getDolGlobalInt('MAIN_MULTILANGS') /* && empty($newlang) */ && GETPOST('lang_id', 'aZ09')) {
1035 $newlang = GETPOST('lang_id', 'aZ09');
1036 }
1037 if (getDolGlobalInt('MAIN_MULTILANGS') && empty($newlang)) {
1038 $tmpuser = new User($db);
1039 $tmpuser->fetch($object->fk_user_author);
1040 $newlang = $tmpuser->lang;
1041 }
1042 if (!empty($newlang)) {
1043 $outputlangs = new Translate("", $conf);
1044 $outputlangs->setDefaultLang($newlang);
1045 }
1046 $model = $object->model_pdf;
1047 $ret = $object->fetch($id); // Reload to get new records
1048
1049 $object->generateDocument($model, $outputlangs, $hidedetails, $hidedesc, $hideref);
1050 }
1051 }
1052
1053 if ($result > 0) {
1054 header("Location: ".$_SERVER["PHP_SELF"]."?id=".$id);
1055 exit;
1056 } else {
1057 setEventMessages($object->error, $object->errors, 'errors');
1058 }
1059 } else {
1060 setEventMessages("NOT_AUTHOR", null, 'errors');
1061 }
1062 }
1063
1064 if ($action == 'set_unpaid' && $id > 0 && $user->hasRight('expensereport', 'to_paid')) {
1065 $object = new ExpenseReport($db);
1066 $object->fetch($id);
1067
1068 $result = $object->setUnpaid($user);
1069
1070 if ($result > 0) {
1071 // Define output language
1072 if (!getDolGlobalString('MAIN_DISABLE_PDF_AUTOUPDATE')) {
1073 $outputlangs = $langs;
1074 $newlang = '';
1075 if (getDolGlobalInt('MAIN_MULTILANGS') /* && empty($newlang) */ && GETPOST('lang_id', 'aZ09')) {
1076 $newlang = GETPOST('lang_id', 'aZ09');
1077 }
1078 if (getDolGlobalInt('MAIN_MULTILANGS') && empty($newlang)) {
1079 $tmpuser = new User($db);
1080 $tmpuser->fetch($object->fk_user_author);
1081 $newlang = $tmpuser->lang;
1082 }
1083 if (!empty($newlang)) {
1084 $outputlangs = new Translate("", $conf);
1085 $outputlangs->setDefaultLang($newlang);
1086 }
1087 $model = $object->model_pdf;
1088 $ret = $object->fetch($id); // Reload to get new records
1089
1090 $object->generateDocument($model, $outputlangs, $hidedetails, $hidedesc, $hideref);
1091 }
1092
1093 header("Location: ".$_SERVER["PHP_SELF"]."?id=".$id);
1094 exit;
1095 }
1096 }
1097
1098
1099 if ($action == 'set_paid' && $id > 0 && $user->hasRight('expensereport', 'to_paid')) {
1100 $object = new ExpenseReport($db);
1101 $object->fetch($id);
1102
1103 $result = $object->setPaid($id, $user);
1104
1105 if ($result > 0) {
1106 // Define output language
1107 if (!getDolGlobalString('MAIN_DISABLE_PDF_AUTOUPDATE')) {
1108 $outputlangs = $langs;
1109 $newlang = '';
1110 if (getDolGlobalInt('MAIN_MULTILANGS') /* && empty($newlang) */ && GETPOST('lang_id', 'aZ09')) {
1111 $newlang = GETPOST('lang_id', 'aZ09');
1112 }
1113 if (getDolGlobalInt('MAIN_MULTILANGS') && empty($newlang)) {
1114 $tmpuser = new User($db);
1115 $tmpuser->fetch($object->fk_user_author);
1116 $newlang = $tmpuser->lang;
1117 }
1118 if (!empty($newlang)) {
1119 $outputlangs = new Translate("", $conf);
1120 $outputlangs->setDefaultLang($newlang);
1121 }
1122 $model = $object->model_pdf;
1123 $ret = $object->fetch($id); // Reload to get new records
1124
1125 $object->generateDocument($model, $outputlangs, $hidedetails, $hidedesc, $hideref);
1126 }
1127 }
1128
1129 if ($result > 0) {
1130 // TODO We must never send an email without a setup or confirm option to choose if email is
1131 // sent or not. So we add a hidden constant to avoid this for the moment.
1132 if (getDolGlobalString('EXPENSEREPORT_SEND_EMAIL_ON_STATUS_PAID')) {
1133 // Send mail
1134
1135 // TO
1136 $destinataire = new User($db);
1137 $destinataire->fetch($object->fk_user_author);
1138 $emailTo = $destinataire->email;
1139
1140 // FROM
1141 $expediteur = new User($db);
1142 $expediteur->fetch($user->id);
1143 $emailFrom = getDolGlobalString('MAIN_MAIL_EMAIL_FROM');
1144
1145 if ($emailFrom && $emailTo) {
1146 $filename = array();
1147 $filedir = array();
1148 $mimetype = array();
1149
1150 // SUBJECT
1151 $societeName = getDolGlobalString('MAIN_INFO_SOCIETE_NOM');
1152 if (getDolGlobalString('MAIN_APPLICATION_TITLE')) {
1153 $societeName = getDolGlobalString('MAIN_APPLICATION_TITLE');
1154 }
1155
1156 $subject = $societeName." - ".$langs->transnoentities("ExpenseReportPaid");
1157
1158 // CONTENT
1159 $link = $urlwithroot.'/expensereport/card.php?id='.$object->id;
1160 $link = '<a href="'.$link.'">'.$link.'</a>';
1161 $message = $langs->transnoentities("ExpenseReportPaidMessage", $object->ref, $destinataire->getFullName($langs), $expediteur->getFullName($langs), $link);
1162
1163 // Generate pdf before attachment
1164 $object->setDocModel($user, "");
1165 $resultPDF = expensereport_pdf_create($db, $object, '', "", $langs);
1166
1167 // PREPARE SEND
1168 $mailfile = new CMailFile($subject, $emailTo, $emailFrom, $message, $filedir, $mimetype, $filename, '', '', 0, -1);
1169
1170 if (empty($mailfile->error)) {
1171 // SEND
1172 $result = $mailfile->sendfile();
1173 if ($result) {
1174 $mesg = $langs->trans('MailSuccessfulySent', $mailfile->getValidAddress($emailFrom, 2), $mailfile->getValidAddress($emailTo, 2));
1175 setEventMessages($mesg, null, 'mesgs');
1176
1177 header("Location: ".$_SERVER["PHP_SELF"]."?id=".$id);
1178 exit;
1179 } else {
1180 $langs->load("other");
1181 if ($mailfile->error) {
1182 $mesg = '';
1183 $mesg .= $langs->trans('ErrorFailedToSendMail', $emailFrom, $emailTo);
1184 $mesg .= '<br>'.$mailfile->error;
1185 setEventMessages($mesg, null, 'errors');
1186 } else {
1187 setEventMessages('No mail sent. Feature is disabled by option MAIN_DISABLE_ALL_MAILS', null, 'warnings');
1188 }
1189 }
1190 } else {
1191 setEventMessages($mailfile->error, $mailfile->errors, 'errors');
1192 }
1193 } else {
1194 setEventMessages($langs->trans("NoEmailSentBadSenderOrRecipientEmail"), null, 'warnings');
1195 }
1196 }
1197 } else {
1198 setEventMessages($langs->trans("FailedToSetPaid"), null, 'warnings');
1199 }
1200
1201 $action = '';
1202 }
1203
1204 if ($action == "addline" && $permissiontoadd) {
1205 // First save uploaded file
1206 $fk_ecm_files = 0;
1207 if (GETPOSTISSET('attachfile')) {
1208 $arrayoffiles = GETPOST('attachfile', 'array');
1209 if (is_array($arrayoffiles) && !empty($arrayoffiles[0])) {
1210 include_once DOL_DOCUMENT_ROOT.'/ecm/class/ecmfiles.class.php';
1211 $entityprefix = ($conf->entity != '1') ? $conf->entity.'/' : '';
1212 $relativepath = $entityprefix.'expensereport/'.$object->ref.'/'.$arrayoffiles[0];
1213 $ecmfiles = new EcmFiles($db);
1214 $ecmfiles->fetch(0, '', $relativepath);
1215 $fk_ecm_files = $ecmfiles->id;
1216 }
1217 }
1218
1219 // if VAT is not used in Dolibarr, set VAT rate to 0 because VAT rate is necessary.
1220 if (empty($vatrate)) {
1221 $vatrate = "0.000";
1222 }
1223 $tmpvat = price2num(preg_replace('/\s*\‍(.*\‍)/', '', $vatrate));
1224
1225 $value_unit_ht = price2num(GETPOST('value_unit_ht', 'alpha'), 'MU');
1226 $value_unit = price2num(GETPOST('value_unit', 'alpha'), 'MU');
1227 if (empty($value_unit)) {
1228 $value_unit = price2num((float) $value_unit_ht + ((float) $value_unit_ht * (float) $tmpvat / 100), 'MU');
1229 }
1230
1231 $fk_c_exp_tax_cat = GETPOSTINT('fk_c_exp_tax_cat');
1232
1233 $qty = price2num(GETPOST('qty', 'alpha'));
1234 if (empty($qty)) {
1235 $qty = 1;
1236 }
1237
1238 if (!($fk_c_type_fees > 0)) {
1239 $error++;
1240 setEventMessages($langs->trans("ErrorFieldRequired", $langs->transnoentitiesnoconv("Type")), null, 'errors');
1241 $action = '';
1242 }
1243
1244 if ((float) $tmpvat < 0 || $tmpvat === '') {
1245 $error++;
1246 setEventMessages($langs->trans("ErrorFieldRequired", $langs->transnoentitiesnoconv("VAT")), null, 'errors');
1247 $action = '';
1248 }
1249
1250 // If no date entered
1251 if (empty($date) || $date == "--") {
1252 $error++;
1253 setEventMessages($langs->trans("ErrorFieldRequired", $langs->transnoentitiesnoconv("Date")), null, 'errors');
1254 } elseif ($date < $object->date_debut || $date > ($object->date_fin + (24 * 3600 - 1))) {
1255 // Warning if date out of range or error if this conf is ON
1256 if (getDolGlobalString('EXPENSEREPORT_BLOCK_LINE_CREATION_IF_NOT_BETWEEN_DATES')) {
1257 $error++;
1258 }
1259
1260 $langs->load("errors");
1261 $type = $error > 0 ? 'errors' : 'warnings';
1262 setEventMessages($langs->trans("WarningDateOfLineMustBeInExpenseReportRange"), null, $type);
1263 }
1264
1265 // If no price entered
1266 if ($value_unit == 0) {
1267 $error++;
1268 setEventMessages($langs->trans("ErrorFieldRequired", $langs->transnoentitiesnoconv("PriceUTTC")), null, 'errors');
1269 }
1270
1271 // If no project entered
1272 if ($projectRequired && $fk_project <= 0) {
1273 $error++;
1274 setEventMessages($langs->trans("ErrorFieldRequired", $langs->transnoentitiesnoconv("Project")), null, 'errors');
1275 }
1276
1277 // If no file associated
1278 if ($fileRequired && $fk_ecm_files == 0) {
1279 $error++;
1280 setEventMessages($langs->trans("ErrorFieldRequired", $langs->transnoentitiesnoconv("File")), null, 'errors');
1281 }
1282
1283 if (!$error) {
1284 $type = 0; // TODO What if service ? We should take the type product/service from the type of expense report llx_c_type_fees
1285
1286 // Insert line
1287 $result = $object->addline($qty, $value_unit, $fk_c_type_fees, $vatrate, $date, $comments, $fk_project, $fk_c_exp_tax_cat, $type, $fk_ecm_files);
1288 if ($result > 0) {
1289 $ret = $object->fetch($object->id); // Reload to get new records
1290
1291 if (!getDolGlobalString('MAIN_DISABLE_PDF_AUTOUPDATE')) {
1292 // Define output language
1293 $outputlangs = $langs;
1294 $newlang = GETPOST('lang_id', 'alpha');
1295 if (getDolGlobalInt('MAIN_MULTILANGS') && empty($newlang)) {
1296 $tmpuser = new User($db);
1297 $tmpuser->fetch($object->fk_user_author);
1298 $newlang = $tmpuser->lang;
1299 }
1300 if (!empty($newlang)) {
1301 $outputlangs = new Translate("", $conf);
1302 $outputlangs->setDefaultLang($newlang);
1303 }
1304
1305 $object->generateDocument($object->model_pdf, $outputlangs, $hidedetails, $hidedesc, $hideref);
1306 }
1307
1308 unset($qty);
1309 unset($value_unit_ht);
1310 unset($value_unit);
1311 unset($vatrate);
1312 unset($comments);
1313 unset($fk_c_type_fees);
1314 unset($fk_project);
1315
1316 unset($date);
1317 } else {
1318 $error++;
1319 setEventMessages($object->error, $object->errors, 'errors');
1320 }
1321 }
1322
1323 if (!$error) {
1324 header("Location: ".$_SERVER["PHP_SELF"]."?id=".GETPOSTINT('id'));
1325 exit;
1326 } else {
1327 $action = '';
1328 }
1329 }
1330
1331 // A line can be deleted only when lines can be added or modified: report in draft or refused
1332 if ($action == 'confirm_delete_line' && (empty($object->id) || ($object->status != ExpenseReport::STATUS_DRAFT && $object->status != ExpenseReport::STATUS_REFUSED)) && $permissiontoadd) {
1333 setEventMessages($langs->trans("ErrorDeleteLineNotAllowedByObjectStatus"), null, 'errors');
1334 $action = '';
1335 }
1336
1337 if ($action == 'confirm_delete_line' && GETPOST("confirm", 'alpha') == "yes" && $permissiontoadd) {
1338 $object = new ExpenseReport($db);
1339 $object->fetch($id);
1340
1341 $object_ligne = new ExpenseReportLine($db);
1342 $object_ligne->fetch(GETPOSTINT("rowid"));
1343 $total_ht = $object_ligne->total_ht;
1344 $total_tva = $object_ligne->total_tva;
1345
1346 $result = $object->deleteLine(GETPOSTINT("rowid"), $user);
1347 if ($result >= 0) {
1348 if ($result > 0) {
1349 // Define output language
1350 if (!getDolGlobalString('MAIN_DISABLE_PDF_AUTOUPDATE')) {
1351 $outputlangs = $langs;
1352 $newlang = '';
1353 if (getDolGlobalInt('MAIN_MULTILANGS') /* && empty($newlang) */ && GETPOST('lang_id', 'aZ09')) {
1354 $newlang = GETPOST('lang_id', 'aZ09');
1355 }
1356 if (getDolGlobalInt('MAIN_MULTILANGS') && empty($newlang)) {
1357 $tmpuser = new User($db);
1358 $tmpuser->fetch($object->fk_user_author);
1359 $newlang = $tmpuser->lang;
1360 }
1361 if (!empty($newlang)) {
1362 $outputlangs = new Translate("", $conf);
1363 $outputlangs->setDefaultLang($newlang);
1364 }
1365 $model = $object->model_pdf;
1366 $ret = $object->fetch($id); // Reload to get new records
1367
1368 $object->generateDocument($model, $outputlangs, $hidedetails, $hidedesc, $hideref);
1369 }
1370 }
1371
1372 header("Location: ".$_SERVER["PHP_SELF"]."?id=".GETPOSTINT('id'));
1373 exit;
1374 } else {
1375 setEventMessages($object->error, $object->errors, 'errors');
1376 }
1377 }
1378
1379 if ($action == "updateline" && $permissiontoadd) {
1380 $object = new ExpenseReport($db);
1381 $object->fetch($id);
1382
1383 // First save uploaded file
1384 $fk_ecm_files = 0;
1385 if (GETPOSTISSET('attachfile')) {
1386 $arrayoffiles = GETPOST('attachfile', 'array');
1387 if (is_array($arrayoffiles) && !empty($arrayoffiles[0])) {
1388 include_once DOL_DOCUMENT_ROOT.'/ecm/class/ecmfiles.class.php';
1389 $entityprefix = ($conf->entity != '1') ? $conf->entity.'/' : '';
1390 $relativepath = $entityprefix.'expensereport/'.$object->ref.'/'.$arrayoffiles[0];
1391 $ecmfiles = new EcmFiles($db);
1392 $ecmfiles->fetch(0, '', $relativepath);
1393 $fk_ecm_files = $ecmfiles->id;
1394 }
1395 }
1396
1397 $rowid = GETPOSTINT('rowid');
1398 $type_fees_id = GETPOSTINT('fk_c_type_fees');
1399 $fk_c_exp_tax_cat = GETPOSTINT('fk_c_exp_tax_cat');
1400 $projet_id = $fk_project;
1401 $comments = GETPOST('comments', 'restricthtml');
1402 $qty = price2num(GETPOST('qty', 'alpha'));
1403 $vatrate = GETPOST('vatrate', 'alpha');
1404
1405 // if VAT is not used in Dolibarr, set VAT rate to 0 because VAT rate is necessary.
1406 if (empty($vatrate)) {
1407 $vatrate = "0.000";
1408 }
1409 $tmpvat = price2num(preg_replace('/\s*\‍(.*\‍)/', '', $vatrate));
1410
1411 $value_unit_ht = price2num(GETPOST('value_unit_ht', 'alpha'), 'MU');
1412 $value_unit = price2num(GETPOST('value_unit', 'alpha'), 'MU');
1413 if (empty($value_unit)) {
1414 $value_unit = price2num((float) $value_unit_ht + ((float) $value_unit_ht * (float) $tmpvat / 100), 'MU');
1415 }
1416
1417 if (!GETPOSTINT('fk_c_type_fees') > 0) {
1418 $error++;
1419 setEventMessages($langs->trans("ErrorFieldRequired", $langs->transnoentitiesnoconv("Type")), null, 'errors');
1420 $action = '';
1421 }
1422 if ((float) $tmpvat < 0 || $tmpvat == '') {
1423 $error++;
1424 setEventMessages($langs->trans("ErrorFieldRequired", $langs->transnoentitiesnoconv("Vat")), null, 'errors');
1425 $action = '';
1426 }
1427 // Warning if date out of range
1428 if ($date < $object->date_debut || $date > ($object->date_fin + (24 * 3600 - 1))) {
1429 if (getDolGlobalString('EXPENSEREPORT_BLOCK_LINE_CREATION_IF_NOT_BETWEEN_DATES')) {
1430 $error++;
1431 }
1432
1433 $langs->load("errors");
1434 $type = $error > 0 ? 'errors' : 'warnings';
1435 setEventMessages($langs->trans("WarningDateOfLineMustBeInExpenseReportRange"), null, $type);
1436 }
1437
1438 // If no project entered
1439 if ($projectRequired && $projet_id <= 0) {
1440 $error++;
1441 setEventMessages($langs->trans("ErrorFieldRequired", $langs->transnoentitiesnoconv("Project")), null, 'errors');
1442 }
1443
1444 if (!$error) {
1445 // TODO Use update method of ExpenseReportLine
1446 $result = $object->updateline($rowid, $type_fees_id, $projet_id, (float) $vatrate, $comments, (float) $qty, (float) $value_unit, $date, $id, $fk_c_exp_tax_cat, $fk_ecm_files);
1447 if ($result >= 0) {
1448 if ($result > 0) {
1449 // Define output language
1450 if (!getDolGlobalString('MAIN_DISABLE_PDF_AUTOUPDATE')) {
1451 $outputlangs = $langs;
1452 $newlang = '';
1453 if (getDolGlobalInt('MAIN_MULTILANGS') /* && empty($newlang) */ && GETPOST('lang_id', 'aZ09')) {
1454 $newlang = GETPOST('lang_id', 'aZ09');
1455 }
1456 if (getDolGlobalInt('MAIN_MULTILANGS') && empty($newlang)) {
1457 $tmpuser = new User($db);
1458 $tmpuser->fetch($object->fk_user_author);
1459 $newlang = $tmpuser->lang;
1460 }
1461 if (!empty($newlang)) {
1462 $outputlangs = new Translate("", $conf);
1463 $outputlangs->setDefaultLang($newlang);
1464 }
1465 $model = $object->model_pdf;
1466 $ret = $object->fetch($id); // Reload to get new records
1467
1468 $object->generateDocument($model, $outputlangs, $hidedetails, $hidedesc, $hideref);
1469 }
1470
1471 unset($qty);
1472 unset($value_unit_ht);
1473 unset($value_unit);
1474 unset($vatrate);
1475 unset($comments);
1476 unset($fk_c_type_fees);
1477 unset($fk_project);
1478 unset($date);
1479 }
1480
1481 $action = '';
1482 } else {
1483 setEventMessages($object->error, $object->errors, 'errors');
1484 }
1485 }
1486 }
1487
1488 // Actions when printing a doc from card
1489 include DOL_DOCUMENT_ROOT.'/core/actions_printing.inc.php';
1490
1491 // Actions to send emails
1492 $triggersendname = 'EXPENSEREPORT_SENTBYMAIL';
1493 $autocopy = 'MAIN_MAIL_AUTOCOPY_EXPENSEREPORT_TO';
1494 $trackid = 'exp'.$object->id;
1495 include DOL_DOCUMENT_ROOT.'/core/actions_sendmails.inc.php';
1496
1497 // Actions to build doc
1498 $upload_dir = $conf->expensereport->dir_output;
1499 include DOL_DOCUMENT_ROOT.'/core/actions_builddoc.inc.php';
1500}
1501
1502
1503/*
1504 * View
1505 */
1506
1507$title = $langs->trans("ExpenseReport")." - ".$langs->trans("Card");
1508$help_url = "EN:Module_Expense_Reports|FR:Module_Notes_de_frais";
1509
1510llxHeader("", $title, $help_url);
1511
1512$form = new Form($db);
1513$formfile = new FormFile($db);
1514$formproject = new FormProjets($db);
1515$projecttmp = new Project($db);
1516$paymentexpensereportstatic = new PaymentExpenseReport($db);
1517$bankaccountstatic = new Account($db);
1518$ecmfilesstatic = new EcmFiles($db);
1519$formexpensereport = new FormExpenseReport($db);
1520$remaintopay = 0;
1521
1522// Create
1523if ($action == 'create') {
1524 print load_fiche_titre($langs->trans("NewTrip"), '', 'trip');
1525
1526 print '<form action="'.$_SERVER['PHP_SELF'].'" method="post" name="create">';
1527 print '<input type="hidden" name="token" value="'.newToken().'">';
1528 print '<input type="hidden" name="action" value="add">';
1529 print '<input type="hidden" name="backtopage" value="'.$backtopage.'">';
1530
1531 print dol_get_fiche_head([]);
1532
1533 print '<table class="border centpercent">';
1534 print '<tbody>';
1535
1536 // Date start
1537 print '<tr>';
1538 print '<td class="titlefieldcreate fieldrequired">'.$langs->trans("DateStart").'</td>';
1539 print '<td>';
1540 print $form->selectDate($date_start ? $date_start : -1, 'date_debut', 0, 0, 0, '', 1, 1);
1541 print '</td>';
1542 print '</tr>';
1543
1544 // Date end
1545 print '<tr>';
1546 print '<td class="fieldrequired">'.$langs->trans("DateEnd").'</td>';
1547 print '<td>';
1548 print $form->selectDate($date_end ? $date_end : -1, 'date_fin', 0, 0, 0, '', 1, 1);
1549 print '</td>';
1550 print '</tr>';
1551
1552 // User for expense report
1553 print '<tr>';
1554 print '<td class="fieldrequired">'.$langs->trans("User").'</td>';
1555 print '<td>';
1556 $defaultselectuser = $user->id;
1557 if (GETPOSTINT('fk_user_author') > 0) {
1558 $defaultselectuser = GETPOSTINT('fk_user_author');
1559 }
1560 $include_users = 'hierarchyme';
1561 if (getDolGlobalString('MAIN_USE_ADVANCED_PERMS') && $user->hasRight('expensereport', 'writeall_advance')) {
1562 $include_users = array();
1563 }
1564 $s = $form->select_dolusers($defaultselectuser, "fk_user_author", 0, null, 0, $include_users, '', '0,'.$conf->entity);
1565 print $s;
1566 print '</td>';
1567 print '</tr>';
1568
1569 // Approver
1570 print '<tr>';
1571 print '<td>'.$langs->trans("VALIDATOR").'</td>';
1572 print '<td>';
1573 $object = new ExpenseReport($db);
1574 $include_users = $object->fetch_users_approver_expensereport();
1575 if (empty($include_users)) {
1576 print img_warning().' '.$langs->trans("NobodyHasPermissionToValidateExpenseReport");
1577 } else {
1578 $defaultselectuser = (empty($user->fk_user_expense_validator) ? $user->fk_user : $user->fk_user_expense_validator); // Will work only if supervisor has permission to approve so is inside include_users
1579 if (getDolGlobalString('EXPENSEREPORT_DEFAULT_VALIDATOR')) {
1580 $defaultselectuser = getDolGlobalString('EXPENSEREPORT_DEFAULT_VALIDATOR'); // Can force default approver
1581 }
1582 if (GETPOSTINT('fk_user_validator') > 0) {
1583 $defaultselectuser = GETPOSTINT('fk_user_validator');
1584 }
1585 $s = $form->select_dolusers($defaultselectuser, "fk_user_validator", 1, null, ((empty($defaultselectuser) || !getDolGlobalString('EXPENSEREPORT_DEFAULT_VALIDATOR_UNCHANGEABLE')) ? 0 : 1), $include_users);
1586 print $form->textwithpicto($s, $langs->trans("AnyOtherInThisListCanValidate"));
1587 }
1588 print '</td>';
1589 print '</tr>';
1590
1591 // Payment mode
1592 if (getDolGlobalString('EXPENSEREPORT_ASK_PAYMENTMODE_ON_CREATION')) {
1593 print '<tr>';
1594 print '<td>'.$langs->trans("ModePaiement").'</td>';
1595 print '<td>';
1596 $form->select_types_paiements('', 'fk_c_paiement');
1597 print '</td>';
1598 print '</tr>';
1599 }
1600
1601 // Public note
1602 $note_public = GETPOSTISSET('note_public') ? GETPOST('note_public', 'restricthtml') : '';
1603
1604 print '<tr>';
1605 print '<td class="tdtop">'.$langs->trans('NotePublic').'</td>';
1606 print '<td>';
1607
1608 $doleditor = new DolEditor('note_public', $note_public, '', 80, 'dolibarr_notes', 'In', false, false, !getDolGlobalString('FCKEDITOR_ENABLE_NOTE_PUBLIC') ? 0 : 1, ROWS_3, '90%');
1609 print $doleditor->Create(1);
1610 print '</td></tr>';
1611
1612 // Private note
1613 $note_private = GETPOSTISSET('note_private') ? GETPOST('note_private', 'restricthtml') : '';
1614
1615 if (empty($user->socid)) {
1616 print '<tr>';
1617 print '<td class="tdtop">'.$langs->trans('NotePrivate').'</td>';
1618 print '<td>';
1619
1620 $doleditor = new DolEditor('note_private', $note_private, '', 80, 'dolibarr_notes', 'In', false, false, !getDolGlobalString('FCKEDITOR_ENABLE_NOTE_PRIVATE') ? 0 : 1, ROWS_3, '90%');
1621 print $doleditor->Create(1);
1622 print '</td></tr>';
1623 }
1624
1625 // Other attributes
1626 $parameters = array('colspan' => ' colspan="3"', 'cols' => 3);
1627 $reshook = $hookmanager->executeHooks('formObjectOptions', $parameters, $object, $action); // Note that $action and $object may have been modified by
1628 print $hookmanager->resPrint;
1629 if (empty($reshook)) {
1630 print $object->showOptionals($extrafields, 'create', $parameters);
1631 }
1632
1633 print '<tbody>';
1634 print '</table>';
1635
1636 print dol_get_fiche_end();
1637
1638 print $form->buttonsSaveCancel("AddTrip");
1639
1640 print '</form>';
1641} elseif ($object->id > 0) {
1642 $userauthor = null;
1643 $result = $object->fetch($id, $ref);
1644
1645 if ($result > 0) {
1646 if (!in_array($object->fk_user_author, $childids)) {
1647 if (!$user->hasRight('expensereport', 'readall') && !$user->hasRight('expensereport', 'lire_tous')
1648 && (!getDolGlobalString('MAIN_USE_ADVANCED_PERMS') || !$user->hasRight('expensereport', 'writeall_advance'))) {
1649 print load_fiche_titre($langs->trans('TripCard'), '', 'trip');
1650
1651 print '<div class="tabBar">';
1652 print $langs->trans('NotUserRightToView');
1653 print '</div>';
1654
1655 // End of page
1656 llxFooter();
1657
1658 $db->close();
1659
1660 exit;
1661 }
1662 }
1663
1665
1666 if ($action == 'edit' && ($object->status <= ExpenseReport::STATUS_VALIDATED || $object->status == ExpenseReport::STATUS_REFUSED)) {
1667 print "<form name='update' action=\"".$_SERVER['PHP_SELF']."\" method=\"post\">\n";
1668 print '<input type="hidden" name="token" value="'.newToken().'">';
1669 print '<input type="hidden" name="id" value="'.$id.'">';
1670 print '<input type="hidden" name="backtopage" value="'.$backtopage.'">';
1671
1672 print dol_get_fiche_head($head, 'card', $langs->trans("ExpenseReport"), 0, 'trip', 0, '', '', 0, '', 1);
1673
1674 if ($object->status == ExpenseReport::STATUS_REFUSED) {
1675 print '<input type="hidden" name="action" value="updateFromRefuse">';
1676 } else {
1677 print '<input type="hidden" name="action" value="update">';
1678 }
1679
1680 $linkback = '<a href="'.DOL_URL_ROOT.'/expensereport/list.php?restore_lastsearch_values=1'.(!empty($socid) ? '&socid='.$socid : '').'">'.$langs->trans("BackToList").'</a>';
1681
1682 print '<table class="border centpercent">';
1683
1684 print '<tr>';
1685 print '<td>'.$langs->trans("User").'</td>';
1686 print '<td>';
1687 $userfee = new User($db);
1688 if ($object->fk_user_author > 0) {
1689 $userfee->fetch($object->fk_user_author);
1690 print $userfee->getNomUrl(-1);
1691 }
1692 print '</td></tr>';
1693
1694 // Ref
1695 print '<tr><td class="titlefieldcreate">'.$langs->trans("Ref").'</td><td>';
1696 print $form->showrefnav($object, 'ref', $linkback, 1, 'ref', 'ref', '');
1697 print '</td></tr>';
1698
1699 print '<tr>';
1700 print '<td>'.$langs->trans("DateStart").'</td>';
1701 print '<td>';
1702 print $form->selectDate($object->date_debut, 'date_debut');
1703 print '</td>';
1704 print '</tr>';
1705 print '<tr>';
1706 print '<td>'.$langs->trans("DateEnd").'</td>';
1707 print '<td>';
1708 print $form->selectDate($object->date_fin, 'date_fin');
1709 print '</td>';
1710 print '</tr>';
1711
1712 if (getDolGlobalString('EXPENSEREPORT_ASK_PAYMENTMODE_ON_CREATION')) {
1713 print '<tr>';
1714 print '<td>'.$langs->trans("ModePaiement").'</td>';
1715 print '<td>';
1716 $form->select_types_paiements((string) $object->fk_c_paiement, 'fk_c_paiement');
1717 print '</td>';
1718 print '</tr>';
1719 }
1720
1721 if ($object->status < 3) {
1722 print '<tr>';
1723 print '<td>'.$langs->trans("VALIDATOR").'</td>'; // Approbator
1724 print '<td>';
1725 $include_users = $object->fetch_users_approver_expensereport();
1726 $s = $form->select_dolusers($object->fk_user_validator, "fk_user_validator", 1, null, 0, $include_users);
1727 print $form->textwithpicto($s, $langs->trans("AnyOtherInThisListCanValidate"));
1728 print '</td>';
1729 print '</tr>';
1730 } else {
1731 print '<tr>';
1732 print '<td>'.$langs->trans("VALIDOR").'</td>';
1733 print '<td>';
1734 $userfee = new User($db);
1735 $userfee->fetch($object->fk_user_valid);
1736 print $userfee->getNomUrl(-1);
1737 print '</td></tr>';
1738 }
1739
1740 if ($object->status == ExpenseReport::STATUS_CLOSED) {
1741 print '<tr>';
1742 print '<td>'.$langs->trans("AUTHORPAIEMENT").'</td>';
1743 print '<td>';
1744 $userfee = new User($db);
1745 $userfee->fetch($user->id);
1746 print $userfee->getNomUrl(-1);
1747 print '</td></tr>';
1748 }
1749
1750 // Other attributes
1751 //$cols = 3;
1752 //include DOL_DOCUMENT_ROOT . '/core/tpl/extrafields_edit.tpl.php';
1753
1754 print '</table>';
1755
1756 print dol_get_fiche_end();
1757
1758 print $form->buttonsSaveCancel("Modify");
1759
1760 print '</form>';
1761 } else {
1762 $taxlessUnitPriceDisabled = getDolGlobalString('EXPENSEREPORT_FORCE_LINE_AMOUNTS_INCLUDING_TAXES_ONLY') ? ' disabled' : '';
1763
1764 print dol_get_fiche_head($head, 'card', $langs->trans("ExpenseReport"), -1, 'trip', 0, '', '', 0, '', 1);
1765
1766 $formconfirm = '';
1767
1768 // Clone confirmation
1769 if ($action == 'clone') {
1770 // Create an array for form
1771 $criteriaforfilter = 'hierarchyme';
1772 if (getDolGlobalString('MAIN_USE_ADVANCED_PERMS') && $user->hasRight('expensereport', 'writeall_advance')) {
1773 $criteriaforfilter = '';
1774 }
1775 $formquestion = array(
1776 'text' => '',
1777 0 => array('type' => 'other', 'name' => 'fk_user_author', 'label' => $langs->trans("SelectTargetUser"), 'value' => $form->select_dolusers((GETPOSTINT('fk_user_author') > 0 ? GETPOSTINT('fk_user_author') : $user->id), 'fk_user_author', 0, null, 0, $criteriaforfilter, '', '0', 0, 0, '', 0, '', 'maxwidth150'))
1778 );
1779 // Paiement incomplet. On demande si motif = escompte ou autre
1780 $formconfirm = $form->formconfirm($_SERVER["PHP_SELF"].'?id='.$object->id, $langs->trans('ToClone'), $langs->trans('ConfirmCloneExpenseReport', $object->ref), 'confirm_clone', $formquestion, 'yes', 1);
1781 }
1782
1783 if ($action == 'save') {
1784 $formconfirm = $form->formconfirm($_SERVER["PHP_SELF"]."?id=".$id, $langs->trans("SaveTrip"), $langs->trans("ConfirmSaveTrip"), "confirm_validate", "", "", 1);
1785 }
1786
1787 if ($action == 'save_from_refuse') {
1788 $formconfirm = $form->formconfirm($_SERVER["PHP_SELF"]."?id=".$id, $langs->trans("SaveTrip"), $langs->trans("ConfirmSaveTrip"), "confirm_save_from_refuse", "", "", 1);
1789 }
1790
1791 if ($action == 'delete') {
1792 $formconfirm = $form->formconfirm($_SERVER["PHP_SELF"]."?id=".$id, $langs->trans("DeleteTrip"), $langs->trans("ConfirmDeleteTrip"), "confirm_delete", "", "", 1);
1793 }
1794
1795 if ($action == 'validate') {
1796 $formconfirm = $form->formconfirm($_SERVER["PHP_SELF"]."?id=".$id, $langs->trans("ValideTrip"), $langs->trans("ConfirmValideTrip"), "confirm_approve", "", "", 1);
1797 }
1798
1799 if ($action == 'paid') {
1800 $formconfirm = $form->formconfirm($_SERVER["PHP_SELF"]."?id=".$id, $langs->trans("PaidTrip"), $langs->trans("ConfirmPaidTrip"), "confirm_paid", "", "", 1);
1801 }
1802
1803 if ($action == 'cancel') {
1804 $array_input = array('text' => $langs->trans("ConfirmCancelTrip"), 0 => array('type' => "text", 'label' => '<strong>'.$langs->trans("Comment").'</strong>', 'name' => "detail_cancel", 'value' => ""));
1805 $formconfirm = $form->formconfirm($_SERVER["PHP_SELF"]."?id=".$id, $langs->trans("Cancel"), "", "confirm_cancel", $array_input, "", 1);
1806 }
1807
1808 if ($action == 'setdraft') {
1809 $formconfirm = $form->formconfirm($_SERVER["PHP_SELF"]."?id=".$id, $langs->trans("BrouillonnerTrip"), $langs->trans("ConfirmBrouillonnerTrip"), "confirm_setdraft", "", "", 1);
1810 }
1811
1812 if ($action == 'refuse') { // Deny
1813 $array_input = array('text' => $langs->trans("ConfirmRefuseTrip"), 0 => array('type' => "text", 'label' => $langs->trans("Comment"), 'name' => "detail_refuse", 'value' => ""));
1814 $formconfirm = $form->formconfirm($_SERVER["PHP_SELF"]."?id=".$id, $langs->trans("Deny"), '', "confirm_refuse", $array_input, "yes", 1);
1815 }
1816
1817 if ($action == 'delete_line') {
1818 $formconfirm = $form->formconfirm($_SERVER["PHP_SELF"]."?id=".$id."&rowid=".GETPOSTINT('rowid'), $langs->trans("DeleteLine"), $langs->trans("ConfirmDeleteLine"), "confirm_delete_line", '', 'yes', 1);
1819 }
1820
1821 // Call Hook formConfirm
1822 $parameters = array('formConfirm' => $formconfirm);
1823 $reshook = $hookmanager->executeHooks('formConfirm', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
1824 if (empty($reshook)) {
1825 $formconfirm .= $hookmanager->resPrint;
1826 } elseif ($reshook > 0) {
1827 $formconfirm = $hookmanager->resPrint;
1828 }
1829
1830 // Print form confirm
1831 print $formconfirm;
1832
1833 // Expense report card
1834 $linkback = '<a href="'.DOL_URL_ROOT.'/expensereport/list.php?restore_lastsearch_values=1'.(!empty($socid) ? '&socid='.$socid : '').'">'.$langs->trans("BackToList").'</a>';
1835
1836 $morehtmlref = '<div class="refidno">';
1837 $morehtmlref .= '</div>';
1838
1839 dol_banner_tab($object, 'ref', $linkback, 1, 'ref', 'ref', $morehtmlref);
1840
1841 print '<div class="fichecenter">';
1842 print '<div class="fichehalfleft">';
1843 print '<div class="underbanner clearboth"></div>';
1844
1845 print '<table class="border tableforfield centpercent">';
1846
1847 // Author
1848 print '<tr>';
1849 print '<td class="titlefield">'.$langs->trans("User").'</td>';
1850 print '<td>';
1851 if ($object->fk_user_author > 0) {
1852 $userauthor = new User($db);
1853 $result = $userauthor->fetch($object->fk_user_author);
1854 if ($result < 0) {
1855 dol_print_error(null, $userauthor->error);
1856 } elseif ($result > 0) {
1857 print $userauthor->getNomUrl(-1);
1858 }
1859 }
1860 print '</td></tr>';
1861
1862 // Period
1863 print '<tr>';
1864 print '<td class="titlefield">'.$langs->trans("Period").'</td>';
1865 print '<td>';
1866 print get_date_range($object->date_debut, $object->date_fin, 'day', $langs, 0);
1867 print '</td>';
1868 print '</tr>';
1869 if (getDolGlobalString('EXPENSEREPORT_ASK_PAYMENTMODE_ON_CREATION')) {
1870 print '<tr>';
1871 print '<td>'.$langs->trans("ModePaiement").'</td>';
1872 print '<td>'.$object->fk_c_paiement.'</td>';
1873 print '</tr>';
1874 }
1875
1876 // Validation date
1877 print '<tr>';
1878 print '<td>'.$langs->trans("DATE_SAVE").'</td>';
1879 print '<td>'.dol_print_date($object->date_valid, 'dayhour', 'tzuser');
1880 if ($object->status == ExpenseReport::STATUS_VALIDATED && $object->hasDelay('toapprove')) {
1881 print ' '.img_warning($langs->trans("Late").' - '.$langs->trans("ToApprove"));
1882 }
1883 if ($object->status == ExpenseReport::STATUS_APPROVED && $object->hasDelay('topay')) {
1884 print ' '.img_warning($langs->trans("Late").' - '.$langs->trans("ToPay"));
1885 }
1886 print '</td></tr>';
1887 print '</tr>';
1888
1889 // User to inform for approval
1890 if ($object->status <= ExpenseReport::STATUS_VALIDATED) { // informed
1891 print '<tr>';
1892 print '<td>'.$langs->trans("VALIDATOR").'</td>'; // approver
1893 print '<td>';
1894 if ($object->fk_user_validator > 0) {
1895 $userfee = new User($db);
1896 $result = $userfee->fetch($object->fk_user_validator);
1897 if ($result > 0) {
1898 print $userfee->getNomUrl(-1);
1899 }
1900 if (empty($userfee->email) || !isValidEmail($userfee->email)) {
1901 $langs->load("errors");
1902 print img_warning($langs->trans("ErrorBadEMail", $userfee->email));
1903 }
1904 }
1905 print '</td></tr>';
1906 } elseif ($object->status == ExpenseReport::STATUS_CANCELED) {
1907 print '<tr>';
1908 print '<td>'.$langs->trans("CANCEL_USER").'</span></td>';
1909 print '<td>';
1910 if ($object->fk_user_cancel > 0) {
1911 $userfee = new User($db);
1912 $result = $userfee->fetch($object->fk_user_cancel);
1913 if ($result > 0) {
1914 print $userfee->getNomUrl(-1);
1915 }
1916 }
1917 print '</td></tr>';
1918
1919 print '<tr>';
1920 print '<td>'.$langs->trans("MOTIF_CANCEL").'</td>';
1921 print '<td>'.$object->detail_cancel.'</td></tr>';
1922 print '</tr>';
1923 print '<tr>';
1924 print '<td>'.$langs->trans("DATE_CANCEL").'</td>';
1925 print '<td>'.dol_print_date($object->date_cancel, 'dayhour', 'tzuser').'</td></tr>';
1926 print '</tr>';
1927 } else {
1928 print '<tr>';
1929 print '<td>'.$langs->trans("ApprovedBy").'</td>';
1930 print '<td>';
1931 if ($object->fk_user_approve > 0) {
1932 $userapp = new User($db);
1933 $result = $userapp->fetch($object->fk_user_approve);
1934 if ($result > 0) {
1935 print $userapp->getNomUrl(-1);
1936 }
1937 }
1938 print '</td></tr>';
1939
1940 print '<tr>';
1941 print '<td>'.$langs->trans("DateApprove").'</td>';
1942 print '<td>'.dol_print_date($object->date_approve, 'dayhour', 'tzuser').'</td></tr>';
1943 print '</tr>';
1944 }
1945
1946 if ($object->status == ExpenseReport::STATUS_REFUSED || !empty($object->detail_refuse)) {
1947 print '<tr>';
1948 print '<td>'.$langs->trans("REFUSEUR").'</td>';
1949 print '<td>';
1950 $userfee = new User($db);
1951 $result = $userfee->fetch($object->fk_user_refuse);
1952 if ($result > 0) {
1953 print $userfee->getNomUrl(-1);
1954 }
1955 print '</td></tr>';
1956
1957 print '<tr>';
1958 print '<td>'.$langs->trans("DATE_REFUS").'</td>';
1959 print '<td>'.dol_print_date($object->date_refuse, 'dayhour', 'tzuser');
1960 if ($object->detail_refuse) {
1961 print ' - '.$object->detail_refuse;
1962 }
1963 print '</td>';
1964 print '</tr>';
1965 }
1966
1967 if ($object->status == ExpenseReport::STATUS_CLOSED) {
1968 /* TODO this fields are not yet filled
1969 print '<tr>';
1970 print '<td>'.$langs->trans("AUTHORPAIEMENT").'</td>';
1971 print '<td>';
1972 $userfee=new User($db);
1973 $userfee->fetch($object->fk_user_paid);
1974 print $userfee->getNomUrl(-1);
1975 print '</td></tr>';
1976 print '<tr>';
1977 print '<td>'.$langs->trans("DATE_PAIEMENT").'</td>';
1978 print '<td>'.$object->date_paiement.'</td></tr>';
1979 print '</tr>';
1980 */
1981 }
1982
1983 // Other attributes
1984 $cols = 2;
1985 include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_view.tpl.php';
1986
1987 print '</table>';
1988
1989 print '</div>';
1990 print '<div class="fichehalfright">';
1991 print '<div class="underbanner clearboth"></div>';
1992
1993 print '<table class="border tableforfield centpercent">';
1994
1995 // Amount
1996 print '<tr>';
1997 print '<td class="titlefieldmiddle">'.$langs->trans("AmountHT").'</td>';
1998 print '<td class="nowrap amountcard">'.price($object->total_ht, 1, '', 1, - 1, - 1, $conf->currency).'</td>';
1999 $rowspan = 5;
2001 $rowspan++;
2002 } else {
2003 $rowspan += 2;
2004 }
2005 if ($object->status == ExpenseReport::STATUS_REFUSED || !empty($object->detail_refuse)) {
2006 $rowspan += 2;
2007 }
2008 if ($object->status == ExpenseReport::STATUS_CLOSED) {
2009 $rowspan += 2;
2010 }
2011 print "</td>";
2012 print '</tr>';
2013
2014 print '<tr>';
2015 print '<td>'.$langs->trans("AmountVAT").'</td>';
2016 print '<td class="nowrap amountcard">'.price($object->total_tva, 1, '', 1, -1, -1, $conf->currency).'</td>';
2017 print '</tr>';
2018
2019 // Amount Local Taxes
2020 if ($mysoc->localtax1_assuj == "1" || $object->total_localtax1 != 0) { // Localtax1
2021 print '<tr><td>'.$langs->transcountry("AmountLT1", $mysoc->country_code).'</td>';
2022 print '<td class="valuefield">'.price($object->total_localtax1, 1, '', 1, -1, -1, $conf->currency).'</td></tr>';
2023 }
2024 if ($mysoc->localtax2_assuj == "1" || $object->total_localtax2 != 0) { // Localtax2 IRPF
2025 print '<tr><td>'.$langs->transcountry("AmountLT2", $mysoc->country_code).'</td>';
2026 print '<td class="valuefield">'.price($object->total_localtax2, 1, '', 1, -1, -1, $conf->currency).'</td></tr>';
2027 }
2028
2029 print '<tr>';
2030 print '<td>'.$langs->trans("AmountTTC").'</td>';
2031 print '<td class="nowrap amountcard">'.price($object->total_ttc, 1, '', 1, -1, -1, $conf->currency).'</td>';
2032 print '</tr>';
2033
2034 // List of payments already done
2035 $canSeeBankAccount = isModEnabled('bank') && $user->hasRight('banque', 'lire');
2036 $nbcols = 3;
2037 $nbrows = 0;
2038 if ($canSeeBankAccount) {
2039 $nbrows++;
2040 $nbcols++;
2041 }
2042
2043 print '<table class="noborder paymenttable centpercent">';
2044
2045 print '<tr class="liste_titre">';
2046 print '<td class="liste_titre">'.$langs->trans('Payments').'</td>';
2047 print '<td class="liste_titre">'.$langs->trans('Date').'</td>';
2048 print '<td class="liste_titre">'.$langs->trans('Type').'</td>';
2049 if ($canSeeBankAccount) {
2050 print '<td class="liste_titre right">'.$langs->trans('BankAccount').'</td>';
2051 }
2052 print '<td class="liste_titre right">'.$langs->trans('Amount').'</td>';
2053 print '<td class="liste_titre" width="18">&nbsp;</td>';
2054 print '</tr>';
2055
2056 // Payments already done (from payment on this expensereport)
2057 $sql = "SELECT p.rowid, p.num_payment, p.datep as dp, p.amount, p.fk_bank,";
2058 $sql .= "c.code as payment_code, c.libelle as payment_type,";
2059 $sql .= "ba.rowid as baid, ba.ref as baref, ba.label, ba.number as banumber, ba.account_number, ba.fk_accountancy_journal";
2060 $sql .= " FROM ".MAIN_DB_PREFIX."expensereport as e, ".MAIN_DB_PREFIX."payment_expensereport as p";
2061 $sql .= " LEFT JOIN ".MAIN_DB_PREFIX."c_paiement as c ON p.fk_typepayment = c.id";
2062 $sql .= ' LEFT JOIN '.MAIN_DB_PREFIX.'bank as b ON p.fk_bank = b.rowid';
2063 $sql .= ' LEFT JOIN '.MAIN_DB_PREFIX.'bank_account as ba ON b.fk_account = ba.rowid';
2064 $sql .= " WHERE e.rowid = ".((int) $id);
2065 $sql .= " AND p.fk_expensereport = e.rowid";
2066 $sql .= ' AND e.entity IN ('.getEntity('expensereport').')';
2067 $sql .= " ORDER BY dp";
2068
2069 $resql = $db->query($sql);
2070 if ($resql) {
2071 $num = $db->num_rows($resql);
2072 $i = 0;
2073 $totalpaid = 0;
2074 while ($i < $num) {
2075 $objp = $db->fetch_object($resql);
2076
2077 $paymentexpensereportstatic->id = $objp->rowid;
2078 $paymentexpensereportstatic->datep = $db->jdate($objp->dp);
2079 $paymentexpensereportstatic->ref = $objp->rowid;
2080 $paymentexpensereportstatic->num_payment = $objp->num_payment;
2081 $paymentexpensereportstatic->type_code = $objp->payment_code;
2082 $paymentexpensereportstatic->type_label = $objp->payment_type;
2083
2084 print '<tr class="oddeven">';
2085 print '<td>';
2086 print $paymentexpensereportstatic->getNomUrl(1);
2087 print '</td>';
2088 print '<td>'.dol_print_date($db->jdate($objp->dp), 'day')."</td>\n";
2089 $labeltype = $langs->trans("PaymentType".$objp->payment_code) != "PaymentType".$objp->payment_code ? $langs->trans("PaymentType".$objp->payment_code) : $objp->payment_type;
2090 print "<td>".$labeltype.' '.$objp->num_payment."</td>\n";
2091 // Bank account
2092 if ($canSeeBankAccount) {
2093 $bankaccountstatic->id = $objp->baid;
2094 $bankaccountstatic->ref = $objp->baref;
2095 $bankaccountstatic->label = $objp->baref;
2096 $bankaccountstatic->number = $objp->banumber;
2097
2098 if (isModEnabled('accounting')) {
2099 $bankaccountstatic->account_number = $objp->account_number;
2100
2101 $accountingjournal = new AccountingJournal($db);
2102 $accountingjournal->fetch($objp->fk_accountancy_journal);
2103 $bankaccountstatic->accountancy_journal = $accountingjournal->getNomUrl(0, 1, 1, '', 1);
2104 }
2105
2106 print '<td class="right">';
2107 if ($bankaccountstatic->id) {
2108 print $bankaccountstatic->getNomUrl(1, 'transactions');
2109 }
2110 print '</td>';
2111 }
2112 print '<td class="right">'.price($objp->amount)."</td>";
2113 print '<td></td>';
2114 print "</tr>";
2115 $totalpaid += $objp->amount;
2116 $i++;
2117 }
2118 $totalpaid = price2num($totalpaid); // Round $totalpaid to fix floating problem after addition into loop
2119
2120 $remaintopay = price2num($object->total_ttc - (float) $totalpaid);
2121 $resteapayeraffiche = $remaintopay;
2122
2123 if ($remaintopay > 0) {
2124 $cssforamountpaymentcomplete = 'amountremaintopay';
2125 } else {
2126 $cssforamountpaymentcomplete = 'amountpaymentcomplete';
2127 }
2128
2129 if ($object->status == ExpenseReport::STATUS_REFUSED) {
2130 $cssforamountpaymentcomplete = 'amountpaymentneutral strikefordisabled';
2131 } elseif ($object->paid == 1 && $remaintopay > 0) {
2132 $cssforamountpaymentcomplete = 'amountpaymentneutral strikefordisabled';
2133 }
2134 print '<tr><td colspan="'.$nbcols.'" class="right">'.$langs->trans("AlreadyPaid").':</td><td class="right">'.price($totalpaid).'</td><td></td></tr>';
2135 print '<tr><td colspan="'.$nbcols.'" class="right">'.$langs->trans("AmountExpected").':</td><td class="right">'.price($object->total_ttc).'</td><td></td></tr>';
2136
2137 print '<tr><td colspan="'.$nbcols.'" class="right">'.$langs->trans("RemainderToPay").':</td>';
2138 print '<td class="right'.($resteapayeraffiche ? ' amountremaintopay' : (' '.$cssforamountpaymentcomplete)).'">'.price($resteapayeraffiche).'</td><td></td></tr>';
2139
2140 $db->free($resql);
2141 } else {
2142 dol_print_error($db);
2143 }
2144 print "</table>";
2145
2146 print '</div>';
2147 print '</div>';
2148
2149 print '<div class="clearboth"></div><br><br>';
2150
2151 print '<div style="clear: both;"></div>';
2152
2153 $actiontouse = 'updateline';
2154 if (($object->status == ExpenseReport::STATUS_DRAFT || $object->status == ExpenseReport::STATUS_REFUSED) && $action != 'editline') {
2155 $actiontouse = 'addline';
2156 }
2157
2158 print '<form name="expensereport" action="'.$_SERVER["PHP_SELF"].'" enctype="multipart/form-data" method="post" >';
2159 print '<input type="hidden" name="token" value="'.newToken().'">';
2160 print '<input type="hidden" name="action" value="'.$actiontouse.'">';
2161 print '<input type="hidden" name="id" value="'.$object->id.'">';
2162 print '<input type="hidden" name="fk_expensereport" value="'.$object->id.'" />';
2163 print '<input type="hidden" name="backtopage" value="'.$backtopage.'">';
2164 print '<input type="hidden" name="page_y" value="">';
2165
2166 print '<div class="div-table-responsive-no-min">';
2167 print '<table id="tablelines" class="noborder centpercent">';
2168
2169 if (!empty($object->lines)) {
2170 $i = 0;
2171 $total = 0;
2172
2173 print '<tr class="liste_titre headerexpensereportdet">';
2174 print '<td class="center linecollinenb">'.$langs->trans('LineNb').'</td>';
2175 //print '<td class="center">'.$langs->trans('Piece').'</td>';
2176 print '<td class="center linecoldate">'.$langs->trans('Date').'</td>';
2177 if (isModEnabled('project')) {
2178 print '<td class="minwidth100imp linecolproject">'.$langs->trans('Project').'</td>';
2179 }
2180 print '<td class="center linecoltype">'.$langs->trans('Type').'</td>';
2181 if (getDolGlobalString('MAIN_USE_EXPENSE_IK')) {
2182 print '<td class="center linecolcarcategory">'.$langs->trans('CarCategory').'</td>';
2183 }
2184 print '<td class="linecoldescription">'.$langs->trans('Description').'</td>';
2185 print '<td class="right linecolvat">'.$langs->trans('VAT').'</td>';
2186 print '<td class="right linecolpriceuht">'.$langs->trans('PriceUHT').'</td>';
2187 print '<td class="right linecolpriceuttc">'.$langs->trans('PriceUTTC').'</td>';
2188 print '<td class="right linecolqty">'.$langs->trans('Qty').'</td>';
2189 if ($action != 'editline') {
2190 print '<td class="right linecolamountht">'.$langs->trans('AmountHT').'</td>';
2191 print '<td class="right linecolamountttc">'.$langs->trans('AmountTTC').'</td>';
2192 }
2193 // Picture
2194 print '<td>';
2195 print '</td>';
2196
2197 // Information if there's a rule restriction
2198 print '<td>';
2199 print '</td>';
2200
2201 // Ajout des boutons de modification/suppression
2202 if (($object->status < ExpenseReport::STATUS_VALIDATED || $object->status == ExpenseReport::STATUS_REFUSED) && $user->hasRight('expensereport', 'creer')) {
2203 print '<td class="right"></td>';
2204 }
2205 print '</tr>';
2206
2207 foreach ($object->lines as &$line) {
2208 $numline = $i + 1;
2209
2210 if ($action != 'editline' || $line->id != GETPOSTINT('rowid')) {
2211 print '<tr class="oddeven linetr" data-id="'.$line->id.'">';
2212
2213 // Num
2214 print '<td class="center linecollinenb">';
2215 print $numline;
2216 print '</td>';
2217
2218 // Date
2219 print '<td class="center linecoldate">'.dol_print_date($db->jdate($line->date), 'day').'</td>';
2220
2221 // Project
2222 if (isModEnabled('project')) {
2223 print '<td class="lineproject">';
2224 if ($line->fk_project > 0) {
2225 $projecttmp->id = $line->fk_project;
2226 $projecttmp->ref = $line->projet_ref;
2227 $projecttmp->title = $line->projet_title;
2228 print $projecttmp->getNomUrl(1);
2229 }
2230 print '</td>';
2231 }
2232
2233 $titlealt = '';
2234 if (isModEnabled('accounting')) {
2235 require_once DOL_DOCUMENT_ROOT.'/accountancy/class/accountingaccount.class.php';
2236 $accountingaccount = new AccountingAccount($db);
2237 $resaccountingaccount = $accountingaccount->fetch(0, $line->type_fees_accountancy_code, 1);
2238 //$titlealt .= '<span class="opacitymedium">';
2239 $titlealt .= $langs->trans("AccountancyCode").': ';
2240 if ($resaccountingaccount > 0) {
2241 $titlealt .= $accountingaccount->account_number;
2242 } else {
2243 $titlealt .= $langs->trans("NotFound");
2244 }
2245 //$titlealt .= '</span>';
2246 }
2247
2248 // Type of fee
2249 print '<td class="center linecoltype" title="'.dol_escape_htmltag($titlealt).'">';
2250 $labeltype = ($langs->trans(($line->type_fees_code)) == $line->type_fees_code ? $line->type_fees_libelle : $langs->trans($line->type_fees_code));
2251 print $labeltype;
2252 print '</td>';
2253
2254 // IK
2255 if (getDolGlobalString('MAIN_USE_EXPENSE_IK')) {
2256 print '<td class="fk_c_exp_tax_cat linecoltaxcat">';
2257 $exp_tax_cat_label = dol_getIdFromCode($db, $line->fk_c_exp_tax_cat, 'c_exp_tax_cat', 'rowid', 'label');
2258 print $langs->trans($exp_tax_cat_label);
2259 print '</td>';
2260 }
2261
2262 // Comment
2263 print '<td class="left linecolcomment">'.dol_nl2br($line->comments).'</td>';
2264
2265 // VAT rate
2266 $senderissupplier = 0;
2267 $tooltiponprice = '';
2268 $tooltiponpriceend = '';
2269 if (!getDolGlobalString('MAIN_OPTIMIZEFORTEXTBROWSER')) {
2270 $tooltiponprice = $langs->transcountry("TotalHT", $mysoc->country_code).'='.price($line->total_ht);
2271 $tooltiponprice .= '<br>'.$langs->transcountry("TotalVAT", ($senderissupplier ? $object->thirdparty->country_code : $mysoc->country_code)).'='.price($line->total_tva);
2272 if (is_object($object->thirdparty)) {
2273 if ($senderissupplier) {
2274 $seller = $object->thirdparty;
2275 $buyer = $mysoc;
2276 } else {
2277 $seller = $mysoc;
2278 $buyer = $object->thirdparty;
2279 }
2280
2281 if ($mysoc->useLocalTax(1)) {
2282 if (($seller->country_code == $buyer->country_code) || $line->total_localtax1 || $seller->useLocalTax(1)) {
2283 $tooltiponprice .= '<br>'.$langs->transcountry("TotalLT1", $seller->country_code).'='.price($line->total_localtax1);
2284 } else {
2285 $tooltiponprice .= '<br>'.$langs->transcountry("TotalLT1", $seller->country_code).'=<span class="opacitymedium">'.$langs->trans($senderissupplier ? "NotUsedForThisVendor" : "NotUsedForThisCustomer").'</span>';
2286 }
2287 }
2288 if ($mysoc->useLocalTax(2)) {
2289 if ((isset($seller->country_code) && isset($buyer->thirdparty->country_code) && $seller->country_code == $buyer->thirdparty->country_code) || $line->total_localtax2 || $seller->useLocalTax(2)) {
2290 $tooltiponprice .= '<br>'.$langs->transcountry("TotalLT2", $seller->country_code).'='.price($line->total_localtax2);
2291 } else {
2292 $tooltiponprice .= '<br>'.$langs->transcountry("TotalLT2", $seller->country_code).'=<span class="opacitymedium">'.$langs->trans($senderissupplier ? "NotUsedForThisVendor" : "NotUsedForThisCustomer").'</span>';
2293 }
2294 }
2295 }
2296 $tooltiponprice .= '<br>'.$langs->transcountry("TotalTTC", $mysoc->country_code).'='.price($line->total_ttc);
2297
2298 $tooltiponprice = '<span class="classfortooltip" title="'.dol_escape_htmltag($tooltiponprice).'">';
2299 $tooltiponpriceend = '</span>';
2300 }
2301
2302 print '<td class="right linecolvatrate">';
2303 print $tooltiponprice;
2304 print vatrate($line->vatrate.($line->vat_src_code ? ' ('.$line->vat_src_code.')' : ''), true);
2305 print $tooltiponpriceend;
2306 print '</td>';
2307
2308 // Unit price HT
2309 print '<td class="right linecolunitht">';
2310 if (!empty($line->value_unit_ht)) {
2311 print price($line->value_unit_ht);
2312 } else {
2313 $tmpvat = price2num(preg_replace('/\s*\‍(.*\‍)/', '', $line->vatrate));
2314 $pricenettoshow = price2num((float) $line->value_unit / (1 + (float) $tmpvat / 100), 'MU');
2315 print price($pricenettoshow);
2316 }
2317 print '</td>';
2318
2319 print '<td class="right linecolunitttc">'.price($line->value_unit).'</td>';
2320
2321 print '<td class="right linecolqty">'.dol_escape_htmltag((string) $line->qty).'</td>';
2322
2323 if ($action != 'editline') {
2324 print '<td class="right linecoltotalht">'.price($line->total_ht).'</td>';
2325 print '<td class="right linecoltotalttc">'.price($line->total_ttc).'</td>';
2326 }
2327
2328 // Column with preview
2329 print '<td class="center linecolpreview">';
2330 if ($line->fk_ecm_files > 0) {
2331 $modulepart = 'expensereport';
2332 $maxheightmini = 32;
2333
2334 $result = $ecmfilesstatic->fetch($line->fk_ecm_files);
2335 if ($result > 0) {
2336 $relativepath = preg_replace('/^([0-9]+\/)?expensereport\//', '', $ecmfilesstatic->filepath);
2337 $fileinfo = pathinfo($ecmfilesstatic->filepath.'/'.$ecmfilesstatic->filename);
2338 if (image_format_supported($fileinfo['basename']) > 0) {
2339 $minifile = getImageFileNameForSize($fileinfo['basename'], '_mini'); // For new thumbs using same ext (in lower case however) than original
2340 if (!dol_is_file($conf->expensereport->dir_output.'/'.$relativepath.'/'.$minifile)) {
2341 $minifile = getImageFileNameForSize($fileinfo['basename'], '_mini', '.png'); // For backward compatibility of old thumbs that were created with filename in lower case and with .png extension
2342 }
2343 //print $file['path'].'/'.$minifile.'<br>';
2344 $urlforhref = getAdvancedPreviewUrl($modulepart, $relativepath.'/'.$fileinfo['filename'].'.'.strtolower($fileinfo['extension']), 1, '&entity='.(empty($object->entity) ? $conf->entity : $object->entity));
2345 if (empty($urlforhref)) {
2346 $urlforhref = DOL_URL_ROOT.'/viewimage.php?modulepart='.$modulepart.'&entity='.(empty($object->entity) ? $conf->entity : $object->entity).'&file='.urlencode($relativepath.$fileinfo['filename'].'.'.strtolower($fileinfo['extension']));
2347 print '<a href="'.$urlforhref.'" class="aphoto" target="_blank" rel="noopener noreferrer">';
2348 } else {
2349 print '<a href="'.$urlforhref['url'].'" class="'.$urlforhref['css'].'" target="'.$urlforhref['target'].'" mime="'.$urlforhref['mime'].'">';
2350 }
2351 print '<img class="photo" height="'.$maxheightmini.'" src="'.DOL_URL_ROOT.'/viewimage.php?modulepart='.$modulepart.'&entity='.(empty($object->entity) ? $conf->entity : $object->entity).'&file='.urlencode($relativepath.'/'.$minifile).'" title="">';
2352 print '</a>';
2353 } else {
2354 if (preg_match('/\.pdf$/i', $ecmfilesstatic->filename)) {
2355 $filepdf = $conf->expensereport->dir_output.'/'.$relativepath.'/'.$ecmfilesstatic->filename;
2356 $fileimage = $conf->expensereport->dir_output.'/'.$relativepath.'/'.$ecmfilesstatic->filename.'_preview.png';
2357 $relativepathimage = $relativepath.'/'.$ecmfilesstatic->filename.'_preview.png';
2358
2359 $pdfexists = file_exists($filepdf);
2360 if ($pdfexists) {
2361 // Conversion du PDF en image png si fichier png non existent
2362 if (!file_exists($fileimage) || (filemtime($fileimage) < filemtime($filepdf))) {
2363 if (!getDolGlobalString('MAIN_DISABLE_PDF_THUMBS')) { // If you experience trouble with pdf thumb generation and imagick, you can disable here.
2364 include_once DOL_DOCUMENT_ROOT.'/core/lib/files.lib.php';
2365 $ret = dol_convert_file($filepdf, 'png', $fileimage, '0'); // Convert first page of PDF into a file _preview.png
2366 if ($ret < 0) {
2367 $error++;
2368 }
2369 }
2370 }
2371 }
2372
2373 if ($pdfexists && !$error) {
2374 $heightforphotref = 70;
2375 if (!empty($conf->dol_optimize_smallscreen)) {
2376 $heightforphotref = 60;
2377 }
2378 $urlforhref = getAdvancedPreviewUrl($modulepart, $relativepath.'/'.$fileinfo['filename'].'.'.strtolower($fileinfo['extension']), 1, '&entity='.(empty($object->entity) ? $conf->entity : $object->entity));
2379 print '<a href="'.$urlforhref['url'].'" class="'.$urlforhref['css'].'" target="'.$urlforhref['target'].'" mime="'.$urlforhref['mime'].'">';
2380 // If the preview file is found we display the thumb
2381 if (file_exists($fileimage)) {
2382 print '<img height="'.$heightforphotref.'" class="photo photowithmargin photowithborder" src="'.DOL_URL_ROOT.'/viewimage.php?modulepart=apercu'.$modulepart.'&amp;file='.urlencode($relativepathimage).'">';
2383 } else {
2384 // Else, we display an icon
2385 print img_mime($ecmfilesstatic->filename);
2386 }
2387 print '</a>';
2388 }
2389 }
2390 }
2391 }
2392 }
2393 print '</td>';
2394
2395 print '<td class="nowrap right linecolwarning">';
2396 print !empty($line->rule_warning_message) ? img_warning(str_replace('\n', ' - ', html_entity_decode($line->rule_warning_message))) : '&nbsp;';
2397 print '</td>';
2398
2399 // Ajout des boutons de modification/suppression
2400 if (($object->status < ExpenseReport::STATUS_VALIDATED || $object->status == ExpenseReport::STATUS_REFUSED) && $permissiontoadd) {
2401 print '<td class="nowrap right linecolaction">';
2402
2403 print '<a class="editfielda reposition paddingrightonly" href="'.$_SERVER["PHP_SELF"].'?id='.$object->id.'&action=editline&token='.newToken().'&rowid='.$line->rowid.'">';
2404 print img_edit();
2405 print '</a> &nbsp; ';
2406 print '<a class="paddingrightonly" href="'.$_SERVER["PHP_SELF"].'?id='.$object->id.'&action=delete_line&token='.newToken().'&rowid='.$line->rowid.'">';
2407 print img_delete();
2408 print '</a>';
2409
2410 print '</td>';
2411 }
2412
2413 print '</tr>';
2414 }
2415
2416 if ($action == 'editline' && $line->id == GETPOSTINT('rowid')) {
2417 // Add line with link to add new file or attach line to an existing file
2418 $colspan = 11;
2419 if (isModEnabled('project')) {
2420 $colspan++;
2421 }
2422 if (getDolGlobalString('MAIN_USE_EXPENSE_IK')) {
2423 $colspan++;
2424 }
2425
2426 print '<!-- line of expense report -->'."\n";
2427 print '<tr class="tredited">';
2428
2429 print '<td class="center">';
2430 print $numline;
2431 print '</td>';
2432
2433 print '<td colspan="'.($colspan - 1).'" class="liste_titre"> ';
2434 print '<a href="" class="commonlink auploadnewfilenow reposition">'.$langs->trans("UploadANewFileNow");
2435 print img_picto($langs->trans("UploadANewFileNow"), 'chevron-down', '', 0, 0, 0, '', 'marginleftonly');
2436 print '</a>';
2437 if (!getDolGlobalString('EXPENSEREPORT_DISABLE_ATTACHMENT_ON_LINES')) {
2438 print ' &nbsp; - &nbsp; <a href="" class="commonlink aattachtodoc reposition">'.$langs->trans("AttachTheNewLineToTheDocument");
2439 print img_picto($langs->trans("AttachTheNewLineToTheDocument"), 'chevron-down', '', 0, 0, 0, '', 'marginleftonly');
2440 print '</a>';
2441 }
2442
2443 print '<!-- Code to open/close section to submit or link files in edit mode -->'."\n";
2444 print '<script type="text/javascript">'."\n";
2445 print '$(document).ready(function() {
2446 $( ".auploadnewfilenow" ).click(function() {
2447 jQuery(".truploadnewfilenow").toggle();
2448 jQuery(".trattachnewfilenow").hide();
2449 return false;
2450 });
2451 $( ".aattachtodoc" ).click(function() {
2452 jQuery(".trattachnewfilenow").toggle();
2453 jQuery(".truploadnewfilenow").hide();
2454 return false;
2455 });';
2456 if (is_array(GETPOST('attachfile', 'array')) && count(GETPOST('attachfile', 'array'))) {
2457 print 'jQuery(".trattachnewfilenow").toggle();'."\n";
2458 }
2459 print '
2460 jQuery("form[name=\"expensereport\"]").submit(function() {
2461 if (jQuery(".truploadnewfilenow").is(":hidden")) {
2462 jQuery("input[name=\"sendit\"]").val("");
2463 }
2464 });
2465 ';
2466 print '
2467 });
2468 ';
2469 print '</script>'."\n";
2470 print '</td></tr>';
2471
2472 $filenamelinked = '';
2473 if ($line->fk_ecm_files > 0) {
2474 $result = $ecmfilesstatic->fetch($line->fk_ecm_files);
2475 if ($result > 0) {
2476 $filenamelinked = $ecmfilesstatic->filename;
2477 }
2478 }
2479
2480 $tredited = 'tredited'; // Case the addfile and linkto file is used for edit (used by following tpl)
2481 include DOL_DOCUMENT_ROOT.'/expensereport/tpl/expensereport_addfile.tpl.php';
2482 include DOL_DOCUMENT_ROOT.'/expensereport/tpl/expensereport_linktofile.tpl.php';
2483
2484 print '<tr class="oddeven tredited">';
2485
2486 print '<td></td>';
2487
2488 // Select date
2489 print '<td class="center">';
2490 print $form->selectDate($line->date, 'date');
2491 print '</td>';
2492
2493 // Select project
2494 if (isModEnabled('project')) {
2495 print '<td class="nowraponall">';
2496 print $formproject->select_projects(-1, (string) $line->fk_project, 'fk_project', 0, 0, $projectRequired ? 0 : 1, 1, 0, 0, 0, '', 1, 0, 'maxwidth300');
2497 print '</td>';
2498 }
2499
2500 // Select type
2501 print '<td class="center">';
2502 print $formexpensereport->selectTypeExpenseReport($line->fk_c_type_fees, 'fk_c_type_fees');
2503 print '</td>';
2504
2505 if (getDolGlobalString('MAIN_USE_EXPENSE_IK')) {
2506 print '<td class="fk_c_exp_tax_cat">';
2507 $params = array('fk_expense' => $object->id, 'fk_expense_det' => $line->id, 'date' => $line->date);
2508 print $form->selectExpenseCategories((string) $line->fk_c_exp_tax_cat, 'fk_c_exp_tax_cat', 1, array(), 'fk_c_type_fees', (int) $userauthor->default_c_exp_tax_cat, $params);
2509 print '</td>';
2510 }
2511
2512 // Add comments
2513 print '<td>';
2514 print '<textarea name="comments" class="flat_ndf centpercent">'.dol_escape_htmltag($line->comments, 0, 1).'</textarea>';
2515 print '</td>';
2516
2517 // VAT
2518 $selectedvat = price2num($line->vatrate).(!empty($line->vat_src_code) ? ' ('.$line->vat_src_code.')' : '');
2519 print '<td class="right">';
2520 // We must use null, null for seller and buyer as we don't know them for expense report.
2521 print $form->load_tva('vatrate', (GETPOSTISSET("vatrate") ? GETPOST("vatrate") : $selectedvat), null, null, 0, 0, '', false, 1, 2);
2522 print '</td>';
2523
2524 // Unit price
2525 print '<td class="right">';
2526 print '<input type="text" min="0" class="right maxwidth50" id="value_unit_ht" name="value_unit_ht" value="'.dol_escape_htmltag(price2num((!empty($line->value_unit_ht) ? $line->value_unit_ht : ""))).'"'.$taxlessUnitPriceDisabled.' />';
2527 print '</td>';
2528
2529 // Unit price with tax
2530 print '<td class="right">';
2531 print '<input type="text" min="0" class="right maxwidth50" id="value_unit" name="value_unit" value="'.dol_escape_htmltag(price2num($line->value_unit)).'" />';
2532 print '</td>';
2533
2534 // Quantity
2535 print '<td class="right">';
2536 print '<input type="text" min="0" class="input_qty right maxwidth50" name="qty" value="'.dol_escape_htmltag((string) $line->qty).'" />'; // We must be able to enter decimal qty
2537 print '</td>';
2538
2539 //print '<td class="right">'.$langs->trans('AmountHT').'</td>';
2540 //print '<td class="right">'.$langs->trans('AmountTTC').'</td>';
2541
2542 // Picture
2543 print '<td class="center">';
2544 //print $line->fk_ecm_files;
2545 print '</td>';
2546 // Information if there's a rule restriction
2547 print '<td class="center">';
2548 print '</td>';
2549
2550 print '<td>';
2551 print '<input type="hidden" name="rowid" value="'.$line->rowid.'">';
2552 print $form->buttonsSaveCancel('Save', 'Cancel', array(), false, 'small');
2553 print '</td>';
2554
2555 print '</tr>';
2556 }
2557
2558 $i++;
2559 }
2560 }
2561
2562 // Add a new line
2563 if (($object->status == ExpenseReport::STATUS_DRAFT || $object->status == ExpenseReport::STATUS_REFUSED) && $action != 'editline' && $permissiontoadd) {
2564 $colspan = 12;
2565 if (getDolGlobalString('MAIN_USE_EXPENSE_IK')) {
2566 $colspan++;
2567 }
2568 if (isModEnabled('project')) {
2569 $colspan++;
2570 }
2571 if ($action != 'editline') {
2572 $colspan++;
2573 }
2574
2575 $nbFiles = $nbLinks = 0;
2576 $arrayoffiles = array();
2577 if (!getDolGlobalString('EXPENSEREPORT_DISABLE_ATTACHMENT_ON_LINES')) {
2578 require_once DOL_DOCUMENT_ROOT.'/core/lib/files.lib.php';
2579 require_once DOL_DOCUMENT_ROOT.'/core/lib/images.lib.php';
2580 require_once DOL_DOCUMENT_ROOT.'/core/class/link.class.php';
2581 $upload_dir = $conf->expensereport->dir_output."/".dol_sanitizeFileName($object->ref);
2582 $arrayoffiles = dol_dir_list($upload_dir, 'files', 0, '', '(\.meta|_preview.*\.png|'.preg_quote(dol_sanitizeFileName($object->ref.'.pdf'), '/').')$');
2583 $nbFiles = count($arrayoffiles);
2584 $nbLinks = Link::count($db, $object->element, $object->id);
2585 }
2586
2587 // Add line with link to add new file or attach to an existing file
2588 print '<tr class="liste_titre">';
2589 print '<td colspan="'.$colspan.'" class="liste_titre expensereportautoload">';
2590 print '<a href="" class="commonlink auploadnewfilenow reposition">'.$langs->trans("UploadANewFileNow");
2591 print img_picto($langs->trans("UploadANewFileNow"), 'chevron-down', '', 0, 0, 0, '', 'marginleftonly');
2592 print '</a>';
2593 if (!getDolGlobalString('EXPENSEREPORT_DISABLE_ATTACHMENT_ON_LINES')) {
2594 print ' &nbsp; - &nbsp; <a href="" class="commonlink aattachtodoc reposition">'.$langs->trans("AttachTheNewLineToTheDocument");
2595 print img_picto($langs->trans("AttachTheNewLineToTheDocument"), 'chevron-down', '', 0, 0, 0, '', 'marginleftonly');
2596 print '</a>';
2597 }
2598
2599 print '<!-- Code to open/close section to submit or link files in the form to add new line -->'."\n";
2600 print '<script type="text/javascript">'."\n";
2601 print '$(document).ready(function() {
2602 $( ".auploadnewfilenow" ).click(function() {
2603 console.log("We click on toggle of auploadnewfilenow");
2604 jQuery(".truploadnewfilenow").toggle();
2605 jQuery(".trattachnewfilenow").hide();
2606 if (jQuery(".truploadnewfilenow").is(":hidden")) {
2607 jQuery("input[name=\"sendit\"]").prop("name", "senditdisabled");
2608 } else {
2609 jQuery("input[name=\"senditdisabled\"]").prop("name", "sendit");
2610 }
2611 // TODO Switch css fa-chevron-dow and add fa-chevron-up
2612 return false;
2613 });
2614 $( ".aattachtodoc" ).click(function() {
2615 console.log("We click on toggle of aattachtodoc");
2616 jQuery(".trattachnewfilenow").toggle();
2617 jQuery(".truploadnewfilenow").hide();
2618 // TODO Switch css fa-chevron-dow and add fa-chevron-up
2619 return false;
2620 });'."\n";
2621 if (is_array(GETPOST('attachfile', 'array')) && count(GETPOST('attachfile', 'array')) && $action != 'updateline') {
2622 print 'jQuery(".trattachnewfilenow").show();'."\n";
2623 }
2624 print '
2625 jQuery("form[name=\"expensereport\"]").submit(function() {
2626 if (jQuery(".truploadnewfilenow").is(":hidden")) {
2627 /* When section to send file is not expanded, we disable the button sendit that submit form to add a new file, so button to submit line will work. */
2628 jQuery("input[name=\"sendit\"]").val("");
2629 jQuery("input[name=\"sendit\"]").prop("name", "senditdisabled");
2630 } else {
2631 jQuery("input[name=\"senditdisabled\"]").prop("name", "sendit");
2632 }
2633 });
2634 ';
2635 print '
2636 });
2637 ';
2638 print '</script>'."\n";
2639 print '</td></tr>';
2640
2641 $tredited = ''; // Case the addfile and linkto file is used for edit (used by following tpl)
2642 include DOL_DOCUMENT_ROOT.'/expensereport/tpl/expensereport_linktofile.tpl.php';
2643 include DOL_DOCUMENT_ROOT.'/expensereport/tpl/expensereport_addfile.tpl.php';
2644
2645 print '<tr class="liste_titre expensereportcreate">';
2646 print '<td></td>';
2647 print '<td class="center expensereportcreatedate">'.$langs->trans('Date').'</td>';
2648 if (isModEnabled('project')) {
2649 print '<td class="minwidth100imp">'.$form->textwithpicto($langs->trans('Project'), $langs->trans("ClosedProjectsAreHidden")).'</td>';
2650 }
2651 print '<td class="center expensereportcreatetype">'.$langs->trans('Type').'</td>';
2652 if (getDolGlobalString('MAIN_USE_EXPENSE_IK')) {
2653 print '<td>'.$langs->trans('CarCategory').'</td>';
2654 }
2655 print '<td class="expensereportcreatedescription">'.$langs->trans('Description').'</td>';
2656 print '<td class="right expensereportcreatevat">'.$langs->trans('VAT').'</td>';
2657 print '<td class="right expensereportcreatepriceuth">'.$langs->trans('PriceUHT').'</td>';
2658 print '<td class="right expensereportcreatepricettc">'.$langs->trans('PriceUTTC').'</td>';
2659 print '<td class="right expensereportcreateqty">'.$langs->trans('Qty').'</td>';
2660 print '<td></td>';
2661 print '<td></td>';
2662 print '<td></td>';
2663 print '<td></td>';
2664 print '<td></td>';
2665 print '</tr>';
2666 print '<tr class="oddeven nohover">';
2667
2668 // Line number
2669 print '<td></td>';
2670
2671 // Select date
2672 print '<td class="center inputdate">';
2673 print $form->selectDate(!empty($date) ? $date : -1, 'date', 0, 0, 0, '', 1, 1);
2674 print '</td>';
2675
2676 // Select project
2677 if (isModEnabled('project')) {
2678 print '<td class="inputproject">';
2679 $formproject->select_projects(-1, !empty($fk_project) ? (string) $fk_project : '0', 'fk_project', 0, 0, $projectRequired ? 0 : 1, -1, 0, 0, 0, '', 0, 0, 'maxwidth300');
2680 print '</td>';
2681 }
2682
2683 // Select type
2684 print '<td class="center inputtype">';
2685 print $formexpensereport->selectTypeExpenseReport(!empty($fk_c_type_fees) ? $fk_c_type_fees : "", 'fk_c_type_fees', 1);
2686 print '</td>';
2687
2688 if (getDolGlobalString('MAIN_USE_EXPENSE_IK')) {
2689 print '<td class="fk_c_exp_tax_cat">';
2690 $params = array('fk_expense' => $object->id);
2691 print $form->selectExpenseCategories('', 'fk_c_exp_tax_cat', 1, array(), 'fk_c_type_fees', $userauthor->default_c_exp_tax_cat, $params, 0);
2692 print '</td>';
2693 }
2694
2695 // Add comments
2696 print '<td class="inputcomment">';
2697 print '<textarea class="flat_ndf centpercent" name="comments" rows="'.ROWS_2.'">'.dol_escape_htmltag(!empty($comments) ? $comments : "", 0, 1).'</textarea>';
2698 print '</td>';
2699
2700 // Select VAT
2701 print '<td class="right inputvat">';
2702 $defaultvat = '';
2703 if (getDolGlobalString('EXPENSEREPORT_NO_DEFAULT_VAT')) {
2704 // If option to have no default VAT on expense report is on, we force MAIN_VAT_DEFAULT_IF_AUTODETECT_FAILS
2705 $conf->global->MAIN_VAT_DEFAULT_IF_AUTODETECT_FAILS = 'none';
2706 }
2707 // We must use null, null for seller and buyer as we don't know them for expense report.
2708 print $form->load_tva('vatrate', (!empty($vatrate) ? $vatrate : $defaultvat), null, null, 0, 0, '', false, 1);
2709 print '</td>';
2710
2711 // Unit price net
2712 print '<td class="right inputpricenet">';
2713 print '<input type="text" class="right maxwidth50" id="value_unit_ht" name="value_unit_ht" value="'.dol_escape_htmltag((!empty($value_unit_ht) ? $value_unit_ht : "")).'"'.$taxlessUnitPriceDisabled.' />';
2714 print '</td>';
2715
2716 // Unit price with tax
2717 print '<td class="right inputtax">';
2718 print '<input type="text" class="right maxwidth50" id="value_unit" name="value_unit" value="'.dol_escape_htmltag((!empty($value_unit) ? $value_unit : "")).'">';
2719 print '</td>';
2720
2721 // Quantity
2722 print '<td class="right inputqty">';
2723 print '<input type="text" min="0" class=" input_qty right maxwidth50" name="qty" value="'.dol_escape_htmltag(!empty($qty) ? $qty : 1).'">'; // We must be able to enter decimal qty
2724 print '</td>';
2725
2726 // Picture
2727 print '<td></td>';
2728
2729 if ($action != 'editline') {
2730 print '<td class="right"></td>';
2731 print '<td class="right"></td>';
2732 print '<td></td>';
2733 }
2734
2735 print '<td class="center inputbuttons">';
2736 print $form->buttonsSaveCancel("Add", '', array(), true, 'reposition');
2737 print '</td>';
2738
2739 print '</tr>';
2740 } // Fin si c'est payé/validé
2741
2742 print '</table>';
2743 print '</div>';
2744
2745 print '<script>
2746
2747 /* JQuery for product free or predefined select */
2748 jQuery(document).ready(function() {
2749 jQuery("#value_unit_ht").keyup(function(event) {
2750 console.log(event.which); // discard event tag and arrows
2751 if (event.which != 9 && (event.which < 37 ||event.which > 40) && jQuery("#value_unit_ht").val() != "") {
2752 jQuery("#value_unit").val("");
2753 }
2754 });
2755 jQuery("#value_unit").keyup(function(event) {
2756 console.log(event.which); // discard event tag and arrows
2757 if (event.which != 9 && (event.which < 37 || event.which > 40) && jQuery("#value_unit").val() != "") {
2758 jQuery("#value_unit_ht").val("");
2759 }
2760 });
2761 ';
2762
2763 if (getDolGlobalString('MAIN_USE_EXPENSE_IK')) {
2764 print '
2765
2766 /* unit price coef calculation */
2767 jQuery(".input_qty, #fk_c_type_fees, #select_fk_c_exp_tax_cat, #vatrate ").change(function(event) {
2768 console.log("We change a parameter");
2769
2770 let type_fee = jQuery("#fk_c_type_fees").find(":selected").val();
2771 let tax_cat = jQuery("#select_fk_c_exp_tax_cat").find(":selected").val();
2772 let tva = jQuery("#vatrate").find(":selected").val();
2773 let qty = jQuery(".input_qty").val();
2774
2775 let path = "'.DOL_URL_ROOT.'/expensereport/ajax/ajaxik.php";
2776 path += "?fk_c_exp_tax_cat="+tax_cat;
2777 path += "&fk_expense="+'.((int) $object->id).';
2778 path += "&vatrate="+tva;
2779 path += "&qty="+qty;
2780
2781 if (type_fee == 4) { // frais_kilométriques
2782 if (tax_cat == "" || parseInt(tax_cat) <= 0){
2783 return ;
2784 }
2785
2786 jQuery.ajax({
2787 url: path,
2788 async: true,
2789 dataType: "json",
2790 success: function(response) {
2791 if (response.response_status == "success"){';
2792
2793 if (getDolGlobalString('EXPENSEREPORT_FORCE_LINE_AMOUNTS_INCLUDING_TAXES_ONLY')) {
2794 print '
2795 jQuery("#value_unit").val(parseFloat(response.data) * (100 + parseFloat(tva)) / 100);
2796 jQuery("#value_unit").trigger("change");
2797 ';
2798 } else {
2799 print '
2800 jQuery("#value_unit_ht").val(response.data);
2801 jQuery("#value_unit_ht").trigger("change");
2802 jQuery("#value_unit").val("");
2803 ';
2804 }
2805
2806 print '
2807 } else if(response.response_status == "error" && response.errorMessage != undefined && response.errorMessage.length > 0 ) {
2808 console.log("We get an error result");
2809 $.jnotify(response.errorMessage, "error", {timeout: 0, type: "error"},{ remove: function (){} } );
2810 }
2811 }
2812 });
2813 }
2814
2815 /*console.log(event.which); // discard event tag and arrows
2816 if (event.which != 9 && (event.which < 37 || event.which > 40) && jQuery("#value_unit").val() != "") {
2817 jQuery("#value_unit_ht").val("");
2818 }*/
2819 });
2820 ';
2821 }
2822
2823 print '
2824
2825 });
2826
2827 </script>';
2828
2829 print '</form>';
2830
2831 print dol_get_fiche_end();
2832 }
2833 } else {
2834 dol_print_error($db);
2835 }
2836} else {
2837 print 'Record not found';
2838
2839 llxFooter();
2840 exit(1);
2841}
2842
2843
2844/*
2845 * Action bar
2846 */
2847
2848print '<div class="tabsAction">';
2849
2850if ($action != 'create' && $action != 'edit' && $action != 'editline') {
2851 $object = new ExpenseReport($db);
2852 $object->fetch($id, $ref);
2853
2854 // Send
2855 if (empty($user->socid)) {
2856 if ($object->status > ExpenseReport::STATUS_DRAFT) {
2857 //if ((empty($conf->global->MAIN_USE_ADVANCED_PERMS) || $user->rights->expensereport->expensereport_advance->send)) {
2858 print '<div class="inline-block divButAction"><a class="butAction" href="'.$_SERVER["PHP_SELF"].'?id='.$object->id.'&action=presend&mode=init#formmailbeforetitle">'.$langs->trans('SendMail').'</a></div>';
2859 //} else
2860 // print '<div class="inline-block divButAction"><a class="butActionRefused classfortooltip" href="#">' . $langs->trans('SendMail') . '</a></div>';
2861 }
2862 }
2863
2864 /* If status is "Draft"
2865 * ET user à droit "creer/supprimer"
2866 * ET fk_user_author == user courant
2867 * Afficher : "Enregistrer" / "Modifier" / "Supprimer"
2868 */
2869 if ($user->hasRight('expensereport', 'creer') && $object->status == ExpenseReport::STATUS_DRAFT) {
2870 if (in_array($object->fk_user_author, $childids) || $user->hasRight('expensereport', 'writeall_advance')) {
2871 // Modify
2872 print '<div class="inline-block divButAction"><a class="butAction" href="'.$_SERVER["PHP_SELF"].'?action=edit&token='.newToken().'&id='.$object->id.'">'.$langs->trans('Modify').'</a></div>';
2873
2874 // Validate
2875 if (count($object->lines) > 0) {
2876 print '<div class="inline-block divButAction"><a class="butAction" href="'.$_SERVER["PHP_SELF"].'?action=save&token='.newToken().'&id='.$object->id.'">'.$langs->trans('ValidateAndSubmit').'</a></div>';
2877 }
2878 }
2879 }
2880
2881 /* If status if "Refused"
2882 * ET user à droit "creer/supprimer"
2883 * ET fk_user_author == user courant
2884 * Afficher : "Enregistrer" / "Modifier" / "Supprimer"
2885 */
2886 if ($user->hasRight('expensereport', 'creer') && $object->status == ExpenseReport::STATUS_REFUSED) {
2887 if ($user->id == $object->fk_user_author || $user->id == $object->fk_user_valid) {
2888 // Modify
2889 print '<div class="inline-block divButAction"><a class="butAction" href="'.$_SERVER["PHP_SELF"].'?action=edit&token='.newToken().'&id='.$object->id.'">'.$langs->trans('Modify').'</a></div>';
2890
2891 // setdraft (le statut refusée est identique à brouillon)
2892 //print '<a class="butAction" href="'.$_SERVER["PHP_SELF"].'?action=brouillonner&id='.$id.'">'.$langs->trans('ReOpen').'</a>';
2893 // Enregistrer depuis le statut "Refusée"
2894 print '<div class="inline-block divButAction"><a class="butAction" href="'.$_SERVER["PHP_SELF"].'?action=save_from_refuse&token='.newToken().'&id='.$object->id.'">'.$langs->trans('ValidateAndSubmit').'</a></div>';
2895 }
2896 }
2897
2898 if ($user->hasRight('expensereport', 'to_paid') && $object->status == ExpenseReport::STATUS_APPROVED) {
2899 if ($user->id == $object->fk_user_author || $user->id == $object->fk_user_valid) {
2900 // setdraft
2901 print '<div class="inline-block divButAction"><a class="butAction" href="'.$_SERVER["PHP_SELF"].'?action=setdraft&token='.newToken().'&id='.$object->id.'">'.$langs->trans('SetToDraft').'</a></div>';
2902 }
2903 }
2904
2905 /* Si l'état est "En attente d'approbation"
2906 * ET user à droit de "approve"
2907 * ET fk_user_validator == user courant
2908 * Afficher : "Valider" / "Refuser" / "Supprimer"
2909 */
2911 if (in_array($object->fk_user_author, $childids)) {
2912 // set draft
2913 print '<div class="inline-block divButAction"><a class="butAction" href="'.$_SERVER["PHP_SELF"].'?action=setdraft&token='.newToken().'&id='.$object->id.'">'.$langs->trans('SetToDraft').'</a></div>';
2914 }
2915 }
2916
2917 if ($user->hasRight('expensereport', 'approve') && $object->status == ExpenseReport::STATUS_VALIDATED) {
2918 //if($object->fk_user_validator==$user->id)
2919 //{
2920 // Validate
2921 print '<div class="inline-block divButAction"><a class="butAction" href="'.$_SERVER["PHP_SELF"].'?action=validate&token='.newToken().'&id='.$object->id.'">'.$langs->trans('Approve').'</a></div>';
2922 // Deny
2923 print '<div class="inline-block divButAction"><a class="butAction" href="'.$_SERVER["PHP_SELF"].'?action=refuse&token='.newToken().'&id='.$object->id.'">'.$langs->trans('Deny').'</a></div>';
2924 //}
2925
2926 if ($user->id == $object->fk_user_author || $user->id == $object->fk_user_valid) {
2927 // Cancel
2928 print '<div class="inline-block divButAction"><a class="butAction" href="'.$_SERVER["PHP_SELF"].'?action=cancel&id='.$object->id.'">'.$langs->trans("Cancel").'</a></div>';
2929 }
2930 }
2931
2932
2933 // If status is Approved
2934 // ---------------------
2935
2936 if ($user->hasRight('expensereport', 'approve') && $object->status == ExpenseReport::STATUS_APPROVED) {
2937 print '<div class="inline-block divButAction"><a class="butAction" href="'.$_SERVER["PHP_SELF"].'?action=refuse&token='.newToken().'&id='.$object->id.'">'.$langs->trans('Deny').'</a></div>';
2938 }
2939
2940 // If bank module is used
2941 if ($user->hasRight('expensereport', 'to_paid') && isModEnabled("bank") && $object->status == ExpenseReport::STATUS_APPROVED) {
2942 // Pay
2943 if ($remaintopay == 0) {
2944 print '<div class="inline-block divButAction"><span class="butActionRefused classfortooltip" title="'.$langs->trans("DisabledBecauseRemainderToPayIsZero").'">'.$langs->trans('DoPayment').'</span></div>';
2945 } else {
2946 print '<div class="inline-block divButAction"><a class="butAction" href="'.DOL_URL_ROOT.'/expensereport/payment/payment.php?id='.$object->id.'&action=create">'.$langs->trans('DoPayment').'</a></div>';
2947 }
2948 }
2949
2950 // If bank module is not used
2951 if (($user->hasRight('expensereport', 'to_paid') || empty(isModEnabled("bank"))) && $object->status == ExpenseReport::STATUS_APPROVED) {
2952 //if ((round($remaintopay) == 0 || !isModEnabled("banque")) && $object->paid == 0)
2953 if ($object->paid == 0) {
2954 print '<div class="inline-block divButAction"><a class="butAction" href="'.$_SERVER["PHP_SELF"].'?id='.$object->id.'&action=set_paid&token='.newToken().'">'.$langs->trans("ClassifyPaid")."</a></div>";
2955 }
2956 }
2957
2958 if ($user->hasRight('expensereport', 'creer') && ($user->id == $object->fk_user_author || $user->id == $object->fk_user_valid) && $object->status == ExpenseReport::STATUS_APPROVED) {
2959 // Cancel
2960 print '<div class="inline-block divButAction"><a class="butAction" href="'.$_SERVER["PHP_SELF"].'?action=cancel&token='.newToken().'&id='.$object->id.'">'.$langs->trans("Cancel").'</a></div>';
2961 }
2962
2963 // If status is Closed
2964 // ---------------------
2965
2966 // TODO Replace this. It should be SetUnpaid and should go back to status unpaid not canceled.
2967 if (($user->hasRight('expensereport', 'approve') || $user->hasRight('expensereport', 'to_paid')) && $object->status == ExpenseReport::STATUS_CLOSED) {
2968 // Cancel
2969 print '<div class="inline-block divButAction"><a class="butAction" href="'.$_SERVER["PHP_SELF"].'?action=cancel&token='.newToken().'&id='.$object->id.'">'.$langs->trans("Cancel").'</a></div>';
2970 }
2971
2972 if ($user->hasRight('expensereport', 'to_paid') && $object->paid && $object->status == ExpenseReport::STATUS_CLOSED) {
2973 // Set unpaid
2974 print '<div class="inline-block divButAction"><a class="butAction" href="'.$_SERVER["PHP_SELF"].'?action=set_unpaid&token='.newToken().'&id='.$object->id.'">'.$langs->trans('ClassifyUnPaid').'</a></div>';
2975 }
2976
2977 // Clone
2978 if ($user->hasRight('expensereport', 'creer')) {
2979 print '<div class="inline-block divButAction"><a class="butAction" href="'.$_SERVER['PHP_SELF'].'?id='.$object->id.'&action=clone&token='.newToken().'">'.$langs->trans("ToClone").'</a></div>';
2980 }
2981
2982 /* If draft, validated, cancel, and user can create, he can always delete its card before it is approved */
2983 if ($user->hasRight('expensereport', 'creer') && $user->id == $object->fk_user_author && $object->status < ExpenseReport::STATUS_APPROVED) {
2984 // Delete
2985 print '<div class="inline-block divButAction"><a class="butActionDelete" href="'.$_SERVER["PHP_SELF"].'?action=delete&token='.newToken().'&id='.$object->id.'">'.$langs->trans('Delete').'</a></div>';
2986 } elseif ($candelete && $object->status != ExpenseReport::STATUS_CLOSED) {
2987 // Delete
2988 print '<div class="inline-block divButAction"><a class="butActionDelete" href="'.$_SERVER["PHP_SELF"].'?action=delete&token='.newToken().'&id='.$object->id.'">'.$langs->trans('Delete').'</a></div>';
2989 }
2990
2991 $parameters = array();
2992 $reshook = $hookmanager->executeHooks('addMoreActionsButtons', $parameters, $object, $action); // Note that $action and $object may have been
2993}
2994
2995print '</div>';
2996
2997
2998// Select mail models is same action as presend
2999if (GETPOST('modelselected', 'alpha')) {
3000 $action = 'presend';
3001}
3002
3003if ($action != 'presend') {
3004 /*
3005 * Generate documents
3006 */
3007
3008 print '<div class="fichecenter"><div class="fichehalfleft">';
3009 print '<a name="builddoc"></a>'; // ancre
3010
3011 if ($user->hasRight('expensereport', 'creer') && $action != 'create' && $action != 'edit') {
3012 $filename = dol_sanitizeFileName($object->ref);
3013 $filedir = $conf->expensereport->dir_output."/".dol_sanitizeFileName($object->ref);
3014 $urlsource = $_SERVER["PHP_SELF"]."?id=".$object->id;
3015 $genallowed = $user->hasRight('expensereport', 'creer');
3016 $delallowed = $user->hasRight('expensereport', 'creer');
3017 $var = true;
3018 print $formfile->showdocuments('expensereport', $filename, $filedir, $urlsource, $genallowed, $delallowed);
3019 $somethingshown = $formfile->numoffiles;
3020 }
3021
3022 // Disabled for expensereport, there is no thirdparty on expensereport, so nothing to define the list of other object we can suggest to link to
3023 /*
3024 if ($action != 'create' && $action != 'edit' && ($id || $ref))
3025 {
3026 $tmparray = $form->showLinkToObjectBlock($object, array(), array('expensereport'), 1);
3027 $linktoelem = $tmparray['linktoelem'];
3028 $htmltoenteralink = $tmparray['htmltoenteralink'];
3029 print $htmltoenteralink;
3030
3031 $somethingshown = $form->showLinkedObjectBlock($object, $linktoelem);
3032 }
3033 */
3034
3035 print '</div><div class="fichehalfright">';
3036 // List of actions on element
3037 include_once DOL_DOCUMENT_ROOT.'/core/class/html.formactions.class.php';
3038 $formactions = new FormActions($db);
3039 $somethingshown = $formactions->showactions($object, 'expensereport', 0);
3040
3041 print '</div></div>';
3042}
3043
3044// Presend form
3045$modelmail = 'expensereport_send';
3046$defaulttopic = 'SendExpenseReportRef';
3047$diroutput = $conf->expensereport->dir_output;
3048$trackid = 'exp'.$object->id;
3049
3050include DOL_DOCUMENT_ROOT.'/core/tpl/card_presend.tpl.php';
3051
3052
3053llxFooter();
3054
3055$db->close();
$id
Support class for third parties, contacts, members, users or resources.
Definition account.php:48
if( $user->socid > 0) if(! $user->hasRight('accounting', 'chartofaccount')) $object
Definition card.php:67
global $dolibarr_main_url_root
llxFooter($comment='', $zone='private', $disabledoutputofmessages=0)
Empty footer.
Definition wrapper.php:91
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.
Definition wrapper.php:73
Class to manage bank accounts.
Class to manage accounting accounts.
Class to manage accounting journals.
Class to send emails (with attachments or not) Usage: $mailfile = new CMailFile($subject,...
Class to manage a WYSIWYG editor.
Class to manage ECM files.
Class to manage Trips and Expenses.
const STATUS_DRAFT
Draft status.
const STATUS_APPROVED
Classified approved.
const STATUS_CANCELED
Classified canceled.
const STATUS_CLOSED
Classified paid.
const STATUS_REFUSED
Classified refused.
const STATUS_VALIDATED
Validated (need to be paid)
Class of expense report details lines.
Class to manage standard extra fields.
Class to manage building of HTML components.
Class to manage generation of HTML components for contract module.
Class to offer components to list and upload files.
Class to manage generation of HTML components Only common components must be here.
Class to manage building of HTML components.
Class to manage payments of expense report.
Class to manage projects.
Class to manage translations.
Class to manage Dolibarr users.
expensereport_prepare_head($object)
Prepare array with list of tabs.
dol_convert_file($fileinput, $ext='png', $fileoutput='', $page='')
Convert an image file or a PDF into another image format.
dol_is_file($pathoffile)
Return if path is a file.
dol_dir_list($utf8_path, $types="all", $recursive=0, $filter="", $excludefilter=null, $sortcriteria="name", $sortorder=SORT_ASC, $mode=0, $nohook=0, $relativename="", $donotfollowsymlinks=0, $nbsecondsold=0)
Scan a directory and return a list of files/directories.
Definition files.lib.php:63
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_getIdFromCode($db, $key, $tablename, $fieldkey='code', $fieldid='id', $entityfilter=0, $filters='', $useCache=true)
Return an id or code from a code or id.
load_fiche_titre($title, $morehtmlright='', $picto='generic', $pictoisfullpath=0, $id='', $morecssontable='', $morehtmlcenter='')
Load a title with picto.
setEventMessages($mesg, $mesgs, $style='mesgs', $messagekey='', $noduplicate=0, $attop=0)
Set event messages in dol_events session object.
vatrate($rate, $addpercent=false, $info_bits=0, $usestarfornpr=0, $html=0)
Return a string with VAT rate label formatted for view output Used into pdf and HTML pages.
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)
img_warning($titlealt='default', $moreatt='', $morecss='pictowarning')
Show warning logo.
img_delete($titlealt='default', $other='class="pictodelete"', $morecss='')
Show delete logo.
GETPOSTINT($paramname, $method=0)
Return the value of a $_GET or $_POST supervariable, converted into integer.
dol_get_fiche_head($links=array(), $active='', $title='', $notab=0, $picto='', $pictoisfullpath=0, $morehtmlright='', $morecss='', $limittoshow=0, $moretabssuffix='', $dragdropfile=0, $morecssdiv='')
Show tabs of a record.
price2num($amount, $rounding='', $option=0)
Function that return a number with universal decimal format (decimal separator is '.
dol_get_fiche_end($notab=0)
Return tab footer of a card.
dol_eval($s, $returnvalue=1, $hideerrors=1, $onlysimplestring='1')
Replace eval function to add more security.
price($amount, $form=0, $outlangs='', $trunc=1, $rounding=-1, $forcerounding=-1, $currency_code='')
Function to format a value into an amount for visual output Function used into PDF and HTML pages.
dol_now($mode='auto')
Return date for now.
img_mime($file, $titlealt='', $morecss='')
Show MIME img of a file.
getDolGlobalInt($key, $default=0)
Return a Dolibarr global constant int value.
dol_print_date($time, $format='', $tzoutput='auto', $outputlangs=null, $encodetooutput=false)
Output date in a string format according to outputlangs (or langs if not defined).
newToken()
Return the value of token currently saved into session with name 'newtoken'.
getImageFileNameForSize($file, $extName, $extImgTarget='')
Return the filename of file to get the thumbs.
get_date_range($date_start, $date_end, $format='', $outputlangs=null, $withparenthesis=1)
Format output for start and end date.
getAdvancedPreviewUrl($modulepart, $relativepath, $alldata=0, $param='')
Return URL we can use for advanced preview links.
GETPOST($paramname, $check='alphanohtml', $method=0, $filter=null, $options=null, $noreplace=0)
Return value of a param into GET or POST supervariable.
dol_clone($object, $native=2)
Create a clone of instance of object (new instance with same value for each properties) With native =...
dol_print_error($db=null, $error='', $errors=null)
Displays error message system with all the information to facilitate the diagnosis and the escalation...
isValidEmail($address, $acceptsupervisorkey=0, $acceptuserkey=0)
Return true if email syntax is ok.
dol_sanitizeFileName($str, $newstr='_', $unaccent=1, $includequotes=0)
Clean a string to use it as a file name.
getDolGlobalString($key, $default='')
Return a Dolibarr global constant string value.
img_edit($titlealt='default', $float=0, $other='')
Show logo edit/modify fiche.
dol_escape_htmltag($stringtoescape, $keepb=0, $keepn=0, $noescapetags='', $escapeonlyhtmltags=0, $cleanalsojavascript=0)
Returns text escaped for inclusion in HTML alt or title or value tags, or into values of HTML input f...
image_format_supported($file, $acceptsvg=0)
Return if a filename is file name of a supported image format.
global $conf
The following vars must be defined: $type2label $form $conf, $lang, The following vars may also be de...
Definition member.php:79
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.
accessforbidden($message='', $printheader=1, $printfooter=1, $showonlymessage=0, $params=null)
Show a message to say access is forbidden and stop program.