dolibarr 25.0.0-alpha
expensereport.class.php
Go to the documentation of this file.
1<?php
2/* Copyright (C) 2011 Dimitri Mouillard <dmouillard@teclib.com>
3 * Copyright (C) 2015 Laurent Destailleur <eldy@users.sourceforge.net>
4 * Copyright (C) 2015 Alexandre Spangaro <aspangaro@open-dsi.fr>
5 * Copyright (C) 2018 Nicolas ZABOURI <info@inovea-conseil.com>
6 * Copyright (c) 2018-2024 Frédéric France <frederic.france@free.fr>
7 * Copyright (C) 2016-2020 Ferran Marcet <fmarcet@2byte.es>
8 * Copyright (C) 2024-2026 MDW <mdeweerd@users.noreply.github.com>
9 * Copyright (C) 2024-2026 Frédéric France <frederic.france@free.fr>
10 * Copyright (C) 2025 William Mead <william@m34d.com>
11 *
12 * This program is free software; you can redistribute it and/or modify
13 * it under the terms of the GNU General Public License as published by
14 * the Free Software Foundation; either version 3 of the License, or
15 * (at your option) any later version.
16 *
17 * This program is distributed in the hope that it will be useful,
18 * but WITHOUT ANY WARRANTY; without even the implied warranty of
19 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
20 * GNU General Public License for more details.
21 *
22 * You should have received a copy of the GNU General Public License
23 * along with this program. If not, see <https://www.gnu.org/licenses/>.
24 */
25
31require_once DOL_DOCUMENT_ROOT.'/core/class/commonobject.class.php';
32require_once DOL_DOCUMENT_ROOT.'/expensereport/class/expensereportline.class.php';
33require_once DOL_DOCUMENT_ROOT.'/expensereport/class/expensereport_ik.class.php';
34require_once DOL_DOCUMENT_ROOT.'/expensereport/class/expensereport_rule.class.php';
35
36
41{
45 public $element = 'expensereport';
46
50 public $table_element = 'expensereport';
51
55 public $table_element_line = 'expensereport_det';
56
60 public $class_element_line = 'ExpenseReportLine';
61
65 public $fk_element = 'fk_expensereport';
66
70 public $picto = 'trip';
71
75 public $lines = array();
76
80 public $line;
81
85 public $date_debut;
86
90 public $date_fin;
91
95 public $date_approbation;
96
100 public $fk_user;
101
105 public $user_approve_id;
106
112 public $status;
113
120 public $fk_statut;
121
125 public $fk_c_paiement;
126
130 public $modepaymentid;
131
135 public $paid;
136
137 // Paiement
141 public $user_paid_infos;
142
146 public $user_author_infos;
147
151 public $user_validator_infos;
152
156 public $rule_warning_message;
157
158 // ACTIONS
159
160 // Create
164 public $date_create;
165
169 public $fk_user_creat;
170
174 public $fk_user_author; // Note fk_user_author is not the 'author' but the guy the expense report is for.
175
176 // Update
180 public $date_modif;
181
185 public $fk_user_modif;
186
187 // Refus
191 public $date_refuse;
192
196 public $detail_refuse;
197
201 public $fk_user_refuse;
202
203 // Annulation
207 public $date_cancel;
208
212 public $detail_cancel;
213
217 public $fk_user_cancel;
218
222 public $fk_user_validator;
223
230 public $datevalid;
231
236 public $date_valid;
237
241 public $fk_user_valid;
242
246 public $user_valid_infos;
247
248 // Approve
252 public $date_approve;
253
257 public $fk_user_approve;
258
263 public $localtax1; // for backward compatibility (real field should be total_localtax1 defined into CommonObject)
268 public $localtax2; // for backward compatibility (real field should be total_localtax2 defined into CommonObject)
269
273 const STATUS_DRAFT = 0;
274
279
284
289
293 const STATUS_CLOSED = 6;
294
298 const STATUS_REFUSED = 99;
299
300 public $fields = array(
301 'rowid' => array('type' => 'integer', 'label' => 'ID', 'enabled' => 1, 'visible' => -1, 'notnull' => 1, 'position' => 10),
302 'ref' => array('type' => 'varchar(50)', 'label' => 'Ref', 'enabled' => 1, 'visible' => -1, 'notnull' => 1, 'showoncombobox' => 1, 'position' => 15),
303 'entity' => array('type' => 'integer', 'label' => 'Entity', 'default' => '1', 'enabled' => 1, 'visible' => -2, 'notnull' => 1, 'position' => 20),
304 'ref_number_int' => array('type' => 'integer', 'label' => 'Ref number int', 'enabled' => 1, 'visible' => -1, 'position' => 25),
305 'ref_ext' => array('type' => 'integer', 'label' => 'RefExt', 'enabled' => 1, 'visible' => 0, 'position' => 30),
306 'total_ht' => array('type' => 'double(24,8)', 'label' => 'Total ht', 'enabled' => 1, 'visible' => -1, 'position' => 35),
307 'total_tva' => array('type' => 'double(24,8)', 'label' => 'Total tva', 'enabled' => 1, 'visible' => -1, 'position' => 40),
308 'localtax1' => array('type' => 'double(24,8)', 'label' => 'Localtax1', 'enabled' => 1, 'visible' => -1, 'position' => 45),
309 'localtax2' => array('type' => 'double(24,8)', 'label' => 'Localtax2', 'enabled' => 1, 'visible' => -1, 'position' => 50),
310 'total_ttc' => array('type' => 'double(24,8)', 'label' => 'Total ttc', 'enabled' => 1, 'visible' => -1, 'position' => 55),
311 'date_debut' => array('type' => 'date', 'label' => 'Date debut', 'enabled' => 1, 'visible' => -1, 'notnull' => 1, 'position' => 60),
312 'date_fin' => array('type' => 'date', 'label' => 'Date fin', 'enabled' => 1, 'visible' => -1, 'notnull' => 1, 'position' => 65),
313 'date_valid' => array('type' => 'datetime', 'label' => 'Date valid', 'enabled' => 1, 'visible' => -1, 'position' => 75),
314 'date_approve' => array('type' => 'datetime', 'label' => 'Date approve', 'enabled' => 1, 'visible' => -1, 'position' => 80),
315 'date_refuse' => array('type' => 'datetime', 'label' => 'Date refuse', 'enabled' => 1, 'visible' => -1, 'position' => 85),
316 'date_cancel' => array('type' => 'datetime', 'label' => 'Date cancel', 'enabled' => 1, 'visible' => -1, 'position' => 90),
317 'fk_user_author' => array('type' => 'integer:User:user/class/user.class.php', 'label' => 'UserAuthor', 'enabled' => 1, 'visible' => -1, 'notnull' => 1, 'position' => 100),
318 'fk_user_modif' => array('type' => 'integer:User:user/class/user.class.php', 'label' => 'UserModif', 'enabled' => 1, 'visible' => -1, 'position' => 105),
319 'fk_user_valid' => array('type' => 'integer:User:user/class/user.class.php', 'label' => 'UserValidation', 'enabled' => 1, 'visible' => -1, 'position' => 110),
320 'fk_user_validator' => array('type' => 'integer:User:user/class/user.class.php', 'label' => 'UserValidation', 'enabled' => 1, 'visible' => -1, 'position' => 115),
321 'fk_user_approve' => array('type' => 'integer:User:user/class/user.class.php', 'label' => 'ApprovedBy', 'enabled' => 1, 'visible' => -1, 'position' => 120),
322 'fk_user_refuse' => array('type' => 'integer:User:user/class/user.class.php', 'label' => 'REFUSEUR', 'enabled' => 1, 'visible' => -1, 'position' => 125),
323 'fk_user_cancel' => array('type' => 'integer:User:user/class/user.class.php', 'label' => 'CANCEL_USER', 'enabled' => 1, 'visible' => -1, 'position' => 130),
324 'fk_c_paiement' => array('type' => 'integer', 'label' => 'PaymentMode', 'enabled' => 1, 'visible' => -1, 'position' => 140),
325 'paid' => array('type' => 'integer', 'label' => 'Paid', 'enabled' => 1, 'visible' => -1, 'notnull' => 1, 'position' => 145),
326 'note_public' => array('type' => 'html', 'label' => 'Note public', 'enabled' => 1, 'visible' => 0, 'position' => 150),
327 'note_private' => array('type' => 'html', 'label' => 'Note private', 'enabled' => 1, 'visible' => 0, 'position' => 155),
328 'detail_refuse' => array('type' => 'varchar(255)', 'label' => 'Detail refuse', 'enabled' => 1, 'visible' => -1, 'position' => 160),
329 'detail_cancel' => array('type' => 'varchar(255)', 'label' => 'Detail cancel', 'enabled' => 1, 'visible' => -1, 'position' => 165),
330 'integration_compta' => array('type' => 'integer', 'label' => 'Integration compta', 'enabled' => 1, 'visible' => -1, 'position' => 170),
331 'fk_bank_account' => array('type' => 'integer', 'label' => 'BankAccount', 'enabled' => 1, 'visible' => -1, 'position' => 175),
332 'fk_multicurrency' => array('type' => 'integer', 'label' => 'Currency', 'enabled' => 1, 'visible' => -1, 'position' => 185),
333 'multicurrency_code' => array('type' => 'varchar(255)', 'label' => 'Multicurrency code', 'enabled' => 1, 'visible' => -1, 'position' => 190),
334 'multicurrency_tx' => array('type' => 'double(24,8)', 'label' => 'Multicurrency tx', 'enabled' => 1, 'visible' => -1, 'position' => 195),
335 'multicurrency_total_ht' => array('type' => 'double(24,8)', 'label' => 'Multicurrency total ht', 'enabled' => 1, 'visible' => -1, 'position' => 200),
336 'multicurrency_total_tva' => array('type' => 'double(24,8)', 'label' => 'Multicurrency total tva', 'enabled' => 1, 'visible' => -1, 'position' => 205),
337 'multicurrency_total_ttc' => array('type' => 'double(24,8)', 'label' => 'Multicurrency total ttc', 'enabled' => 1, 'visible' => -1, 'position' => 210),
338 'extraparams' => array('type' => 'varchar(255)', 'label' => 'Extraparams', 'enabled' => 1, 'visible' => -1, 'position' => 220),
339 'date_create' => array('type' => 'datetime', 'label' => 'Date create', 'enabled' => 1, 'visible' => -1, 'notnull' => 1, 'position' => 300),
340 'tms' => array('type' => 'timestamp', 'label' => 'Tms', 'enabled' => 1, 'visible' => -1, 'notnull' => 1, 'position' => 305),
341 'import_key' => array('type' => 'varchar(14)', 'label' => 'ImportId', 'enabled' => 1, 'visible' => -1, 'position' => 1000),
342 'model_pdf' => array('type' => 'varchar(255)', 'label' => 'Model pdf', 'enabled' => 1, 'visible' => 0, 'position' => 1010),
343 'fk_statut' => array('type' => 'integer', 'label' => 'Status', 'enabled' => 1, 'visible' => -1, 'notnull' => 1, 'position' => 500),
344 );
345
351 public function __construct($db)
352 {
353 $this->db = $db;
354 $this->total_ht = 0;
355 $this->total_ttc = 0;
356 $this->total_tva = 0;
357 $this->total_localtax1 = 0;
358 $this->total_localtax2 = 0;
359 $this->localtax1 = 0; // For backward compatibility
360 $this->localtax2 = 0; // For backward compatibility
361 $this->modepaymentid = 0;
362
363 // List of language codes for status
364 $this->labelStatusShort = array(0 => 'Draft', 2 => 'Validated', 4 => 'Canceled', 5 => 'Approved', 6 => 'Paid', 99 => 'Refused');
365 $this->labelStatus = array(0 => 'Draft', 2 => 'ValidatedWaitingApproval', 4 => 'Canceled', 5 => 'Approved', 6 => 'Paid', 99 => 'Refused');
366
367 $this->fields['ref_ext']['visible'] = getDolGlobalInt('MAIN_LIST_SHOW_REF_EXT');
368 }
369
377 public function create($user, $notrigger = 0)
378 {
379 global $conf, $langs;
380
381 $now = dol_now();
382
383 $error = 0;
384
385 // Check parameters
386 if (empty($this->date_debut) || empty($this->date_fin)) {
387 $this->error = $langs->trans('ErrorFieldRequired', $langs->transnoentitiesnoconv('Date'));
388 return -1;
389 }
390
391 $fuserid = $this->fk_user_author; // Note fk_user_author is not the 'author' but the guy the expense report is for.
392 if (empty($fuserid)) {
393 $fuserid = $user->id;
394 }
395
396 $this->db->begin();
397
398 $sql = "INSERT INTO ".MAIN_DB_PREFIX.$this->table_element." (";
399 $sql .= "ref";
400 $sql .= ",total_ht";
401 $sql .= ",total_ttc";
402 $sql .= ",total_tva";
403 $sql .= ",date_debut";
404 $sql .= ",date_fin";
405 $sql .= ",date_create";
406 $sql .= ",fk_user_creat";
407 $sql .= ",fk_user_author";
408 $sql .= ",fk_user_validator";
409 $sql .= ",fk_user_approve";
410 $sql .= ",fk_user_modif";
411 $sql .= ",fk_statut";
412 $sql .= ",fk_c_paiement";
413 $sql .= ",paid";
414 $sql .= ",note_public";
415 $sql .= ",note_private";
416 $sql .= ",entity";
417 $sql .= ") VALUES(";
418 $sql .= "'(PROV)'";
419 $sql .= ", ".price2num($this->total_ht, 'MT');
420 $sql .= ", ".price2num($this->total_ttc, 'MT');
421 $sql .= ", ".price2num($this->total_tva, 'MT');
422 $sql .= ", '".$this->db->idate($this->date_debut)."'";
423 $sql .= ", '".$this->db->idate($this->date_fin)."'";
424 $sql .= ", '".$this->db->idate($now)."'";
425 $sql .= ", ".((int) $user->id);
426 $sql .= ", ".((int) $fuserid);
427 $sql .= ", ".($this->fk_user_validator > 0 ? ((int) $this->fk_user_validator) : "null");
428 $sql .= ", ".($this->fk_user_approve > 0 ? ((int) $this->fk_user_approve) : "null");
429 $sql .= ", ".($this->fk_user_modif > 0 ? ((int) $this->fk_user_modif) : "null");
430 $sql .= ", ".($this->fk_statut > 1 ? ((int) $this->fk_statut) : 0);
431 $sql .= ", ".($this->modepaymentid ? ((int) $this->modepaymentid) : "null");
432 $sql .= ", 0";
433 $sql .= ", ".($this->note_public ? "'".$this->db->escape($this->note_public)."'" : "null");
434 $sql .= ", ".($this->note_private ? "'".$this->db->escape($this->note_private)."'" : "null");
435 $sql .= ", ".((int) $conf->entity);
436 $sql .= ")";
437
438 $result = $this->db->query($sql);
439 if ($result) {
440 $this->id = $this->db->last_insert_id(MAIN_DB_PREFIX.$this->table_element);
441 $this->ref = '(PROV'.$this->id.')';
442
443 $sql = 'UPDATE '.MAIN_DB_PREFIX.$this->table_element." SET ref='".$this->db->escape($this->ref)."' WHERE rowid=".((int) $this->id);
444 $resql = $this->db->query($sql);
445 if (!$resql) {
446 $this->error = $this->db->lasterror();
447 $error++;
448 }
449
450 if (!$error) {
451 if (is_array($this->lines) && count($this->lines) > 0) {
452 foreach ($this->lines as $line) {
453 // Test and convert into object this->lines[$i]. When coming from REST API, we may still have an array
454 //if (! is_object($line)) $line=json_decode(json_encode($line), false); // convert recursively array into object.
455 if (!is_object($line)) {
456 $line = (object) $line;
457 $newndfline = new ExpenseReportLine($this->db);
458 $newndfline->fk_expensereport = $line->fk_expensereport;
459 $newndfline->fk_c_type_fees = $line->fk_c_type_fees;
460 $newndfline->fk_project = $line->fk_project;
461 $newndfline->vatrate = $line->vatrate;
462 $newndfline->vat_src_code = $line->vat_src_code;
463 $newndfline->localtax1_tx = $line->localtax1_tx;
464 $newndfline->localtax2_tx = $line->localtax2_tx;
465 $newndfline->localtax1_type = $line->localtax1_type;
466 $newndfline->localtax2_type = $line->localtax2_type;
467 $newndfline->comments = $line->comments;
468 $newndfline->qty = $line->qty;
469 $newndfline->value_unit = $line->value_unit;
470 $newndfline->total_ht = $line->total_ht;
471 $newndfline->total_ttc = $line->total_ttc;
472 $newndfline->total_tva = $line->total_tva;
473 $newndfline->total_localtax1 = $line->total_localtax1;
474 $newndfline->total_localtax2 = $line->total_localtax2;
475 $newndfline->date = $line->date;
476 $newndfline->rule_warning_message = $line->rule_warning_message;
477 $newndfline->fk_c_exp_tax_cat = $line->fk_c_exp_tax_cat;
478 $newndfline->fk_ecm_files = $line->fk_ecm_files;
479 } else {
480 $newndfline = $line;
481 }
482 //$newndfline=new ExpenseReportLine($this->db);
483 $newndfline->fk_expensereport = $this->id;
484 $result = $newndfline->insert();
485 if ($result < 0) {
486 $this->error = $newndfline->error;
487 $this->errors = $newndfline->errors;
488 $error++;
489 break;
490 }
491 }
492 }
493 }
494
495 if (!$error) {
496 $result = $this->insertExtraFields();
497 if ($result < 0) {
498 $error++;
499 }
500 }
501
502 if (!$error) {
503 $result = $this->update_price(1);
504 if ($result > 0) {
505 if (!$notrigger) {
506 // Call trigger
507 $result = $this->call_trigger('EXPENSE_REPORT_CREATE', $user);
508
509 if ($result < 0) {
510 $error++;
511 }
512 // End call triggers
513 }
514
515 if (empty($error)) {
516 $this->db->commit();
517 return $this->id;
518 } else {
519 $this->db->rollback();
520 return -4;
521 }
522 } else {
523 $this->db->rollback();
524 return -3;
525 }
526 } else {
527 dol_syslog(get_class($this)."::create error ".$this->error, LOG_ERR);
528 $this->db->rollback();
529 return -2;
530 }
531 } else {
532 $this->error = $this->db->lasterror()." sql=".$sql;
533 $this->db->rollback();
534 return -1;
535 }
536 }
537
545 public function createFromClone(User $user, $fk_user_author)
546 {
547 global $hookmanager;
548
549 $error = 0;
550
551 if (empty($fk_user_author)) {
552 $fk_user_author = $user->id;
553 }
554
555 $this->db->begin();
556
557 // get extrafields so they will be clone
558 //foreach($this->lines as $line)
559 //$line->fetch_optionals();
560
561 // Load source object
562 $objFrom = clone $this;
563
564 $this->id = 0;
565 $this->ref = '';
566 $this->status = 0;
567 $this->fk_statut = 0; // deprecated
568
569 // Clear fields
570 $this->fk_user_creat = $user->id;
571 $this->fk_user_author = $fk_user_author; // Note fk_user_author is not the 'author' but the guy the expense report is for.
572 $this->fk_user_valid = 0;
573 $this->fk_user_approve = 0;
574 $this->date_create = '';
575 $this->date_creation = '';
576 $this->date_validation = '';
577 $this->date_approve = '';
578
579 // Remove link on lines to a joined file
580 if (is_array($this->lines) && count($this->lines) > 0) {
581 foreach ($this->lines as $key => $line) {
582 $this->lines[$key]->fk_ecm_files = 0;
583 }
584 }
585
586 // Create clone
587 $this->context['createfromclone'] = 'createfromclone';
588 $result = $this->create($user);
589 if ($result < 0) {
590 $error++;
591 }
592
593 if (!$error) {
594 // Hook of thirdparty module
595 if (is_object($hookmanager)) {
596 $parameters = array('objFrom' => $objFrom);
597 $action = '';
598 $reshook = $hookmanager->executeHooks('createFrom', $parameters, $this, $action); // Note that $action and $object may have been modified by some hooks
599 if ($reshook < 0) {
600 $this->setErrorsFromObject($hookmanager);
601 $error++;
602 }
603 }
604 }
605
606 unset($this->context['createfromclone']);
607
608 // End
609 if (!$error) {
610 $this->db->commit();
611 return $this->id;
612 } else {
613 $this->db->rollback();
614 return -1;
615 }
616 }
617
618
627 public function update($user, $notrigger = 0, $userofexpensereport = null)
628 {
629 $error = 0;
630 $this->db->begin();
631
632 $sql = "UPDATE ".MAIN_DB_PREFIX.$this->table_element." SET";
633 $sql .= " total_ht = ".((float) $this->total_ht);
634 $sql .= " , total_ttc = ".((float) $this->total_ttc);
635 $sql .= " , total_tva = ".((float) $this->total_tva);
636 if (!empty($this->date_create)) {
637 $sql .= " , date_create = '".$this->db->idate($this->date_create)."'";
638 }
639 $sql .= " , date_debut = '".$this->db->idate($this->date_debut)."'";
640 $sql .= " , date_fin = '".$this->db->idate($this->date_fin)."'";
641 if ($userofexpensereport && is_object($userofexpensereport)) {
642 $sql .= " , fk_user_author = ".($userofexpensereport->id > 0 ? (int) $userofexpensereport->id : "null"); // Note fk_user_author is not the 'author' but the guy the expense report is for.
643 }
644 $sql .= " , fk_user_validator = ".($this->fk_user_validator > 0 ? (int) $this->fk_user_validator : "null");
645 $sql .= " , fk_user_valid = ".($this->fk_user_valid > 0 ? (int) $this->fk_user_valid : "null");
646 $sql .= " , fk_user_approve = ".($this->fk_user_approve > 0 ? (int) $this->fk_user_approve : "null");
647 $sql .= " , fk_user_modif = ".((int) $user->id);
648 $sql .= " , fk_statut = ".($this->fk_statut >= 0 ? (int) $this->fk_statut : 0);
649 $sql .= " , fk_c_paiement = ".($this->fk_c_paiement > 0 ? (int) $this->fk_c_paiement : "null");
650 $sql .= " , note_public = ".(!empty($this->note_public) ? "'".$this->db->escape($this->note_public)."'" : "''");
651 $sql .= " , note_private = ".(!empty($this->note_private) ? "'".$this->db->escape($this->note_private)."'" : "''");
652 $sql .= " , detail_refuse = ".(!empty($this->detail_refuse) ? "'".$this->db->escape($this->detail_refuse)."'" : "''");
653 $sql .= " WHERE rowid = ".((int) $this->id);
654
655 dol_syslog(get_class($this)."::update", LOG_DEBUG);
656 $result = $this->db->query($sql);
657 if ($result) {
658 $result = $this->insertExtraFields();
659 if ($result < 0) {
660 $error++;
661 }
662
663 if (!$error && !$notrigger) {
664 // Call trigger
665 $result = $this->call_trigger('EXPENSE_REPORT_MODIFY', $user);
666 if ($result < 0) {
667 $error++;
668 }
669 // End call triggers
670 }
671
672 if (!$error) {
673 $this->db->commit();
674 return 1;
675 } else {
676 $this->db->rollback();
677 $this->error = $this->db->error();
678 return -2;
679 }
680 } else {
681 $this->db->rollback();
682 $this->error = $this->db->error();
683 return -1;
684 }
685 }
686
694 public function fetch($id, $ref = '')
695 {
696 $sql = "SELECT d.rowid, d.entity, d.ref, d.note_public, d.note_private,"; // DEFAULT
697 $sql .= " d.detail_refuse, d.detail_cancel, d.fk_user_refuse, d.fk_user_cancel,"; // ACTIONS
698 $sql .= " d.date_refuse, d.date_cancel,"; // ACTIONS
699 $sql .= " d.total_ht, d.total_ttc, d.total_tva,";
700 $sql .= " d.localtax1 as total_localtax1, d.localtax2 as total_localtax2,";
701 $sql .= " d.date_debut, d.date_fin, d.date_create, d.tms as date_modif, d.date_valid, d.date_approve,"; // DATES (datetime)
702 $sql .= " d.fk_user_creat, d.fk_user_author, d.fk_user_modif, d.fk_user_validator,";
703 $sql .= " d.fk_user_valid, d.fk_user_approve,";
704 $sql .= " d.fk_statut as status, d.fk_c_paiement, d.paid";
705 $sql .= " FROM ".MAIN_DB_PREFIX.$this->table_element." as d";
706 if ($ref) {
707 $sql .= " WHERE d.ref = '".$this->db->escape($ref)."'";
708 $sql .= " AND d.entity IN (".getEntity('expensereport').")";
709 } else {
710 $sql .= " WHERE d.rowid = ".((int) $id);
711 }
712 //$sql.= $restrict;
713
714 dol_syslog(get_class($this)."::fetch", LOG_DEBUG);
715 $resql = $this->db->query($sql);
716 if ($resql) {
717 $obj = $this->db->fetch_object($resql);
718 if ($obj) {
719 $this->id = $obj->rowid;
720 $this->ref = $obj->ref;
721
722 $this->entity = $obj->entity;
723
724 $this->total_ht = $obj->total_ht;
725 $this->total_tva = $obj->total_tva;
726 $this->total_ttc = $obj->total_ttc;
727 $this->localtax1 = $obj->total_localtax1; // For backward compatibility
728 $this->localtax2 = $obj->total_localtax2; // For backward compatibility
729 $this->total_localtax1 = $obj->total_localtax1;
730 $this->total_localtax2 = $obj->total_localtax2;
731
732 $this->note_public = $obj->note_public;
733 $this->note_private = $obj->note_private;
734 $this->detail_refuse = $obj->detail_refuse;
735 $this->detail_cancel = $obj->detail_cancel;
736
737 $this->date_debut = $this->db->jdate($obj->date_debut);
738 $this->date_fin = $this->db->jdate($obj->date_fin);
739 $this->date_valid = $this->db->jdate($obj->date_valid);
740 $this->date_approve = $this->db->jdate($obj->date_approve);
741 $this->date_create = $this->db->jdate($obj->date_create);
742 $this->date_modif = $this->db->jdate($obj->date_modif);
743 $this->date_refuse = $this->db->jdate($obj->date_refuse);
744 $this->date_cancel = $this->db->jdate($obj->date_cancel);
745
746 $this->fk_user_creat = $obj->fk_user_creat;
747 $this->fk_user_author = $obj->fk_user_author; // Note fk_user_author is not the 'author' but the guy the expense report is for.
748 $this->fk_user_modif = $obj->fk_user_modif;
749 $this->fk_user_validator = $obj->fk_user_validator;
750 $this->fk_user_valid = $obj->fk_user_valid;
751 $this->fk_user_refuse = $obj->fk_user_refuse;
752 $this->fk_user_cancel = $obj->fk_user_cancel;
753 $this->fk_user_approve = $obj->fk_user_approve;
754
755 $user_author = new User($this->db);
756 if ($this->fk_user_author > 0) {
757 $user_author->fetch($this->fk_user_author);
758 }
759
760 $this->user_author_infos = dolGetFirstLastname($user_author->firstname, $user_author->lastname);
761
762 $user_approver = new User($this->db);
763 if ($this->fk_user_approve > 0) {
764 $user_approver->fetch($this->fk_user_approve);
765 } elseif ($this->fk_user_validator > 0) {
766 $user_approver->fetch($this->fk_user_validator); // For backward compatibility
767 }
768 $this->user_validator_infos = dolGetFirstLastname($user_approver->firstname, $user_approver->lastname);
769
770 $this->fk_statut = (int) $obj->status; // deprecated
771 $this->status = (int) $obj->status;
772 $this->fk_c_paiement = $obj->fk_c_paiement;
773 $this->paid = $obj->paid;
774
775 if ($this->status == self::STATUS_APPROVED || $this->status == self::STATUS_CLOSED) {
776 $user_valid = new User($this->db);
777 if ($this->fk_user_valid > 0) {
778 $user_valid->fetch($this->fk_user_valid);
779 }
780 $this->user_valid_infos = dolGetFirstLastname($user_valid->firstname, $user_valid->lastname);
781 }
782
783 $this->fetch_optionals();
784
785 $result = $this->fetch_lines();
786
787 return $result;
788 } else {
789 return 0;
790 }
791 } else {
792 $this->error = $this->db->lasterror();
793 return -1;
794 }
795 }
796
797 // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
808 public function set_paid($id, $fuser, $notrigger = 0)
809 {
810 // phpcs:enable
811 dol_syslog(get_class($this)."::set_paid is deprecated, use setPaid instead", LOG_NOTICE);
812 return $this->setPaid($id, $fuser, $notrigger);
813 }
814
823 public function setPaid($id, $fuser, $notrigger = 0)
824 {
825 $error = 0;
826 $this->db->begin();
827
828 $sql = "UPDATE ".MAIN_DB_PREFIX."expensereport";
829 $sql .= " SET fk_statut = ".self::STATUS_CLOSED.", paid = 1";
830 $sql .= " WHERE rowid = ".((int) $id)." AND fk_statut = ".self::STATUS_APPROVED;
831
832 dol_syslog(get_class($this)."::setPaid", LOG_DEBUG);
833 $resql = $this->db->query($sql);
834 if ($resql) {
835 if ($this->db->affected_rows($resql)) {
836 if (!$notrigger) {
837 // Call trigger
838 $result = $this->call_trigger('EXPENSE_REPORT_PAID', $fuser);
839
840 if ($result < 0) {
841 $error++;
842 }
843 // End call triggers
844 }
845
846 if (empty($error)) {
847 $this->db->commit();
848
850 $this->paid = 1;
851
852 return 1;
853 } else {
854 $this->db->rollback();
855 $this->error = $this->db->error();
856 return -2;
857 }
858 } else {
859 $this->db->commit();
860 return 0;
861 }
862 } else {
863 $this->db->rollback();
864 dol_print_error($this->db);
865 return -1;
866 }
867 }
868
875 public function getLibStatut($mode = 0)
876 {
877 return $this->LibStatut($this->status, $mode);
878 }
879
885 public function getSummary()
886 {
887 $note = preg_replace('/(?:<br\s*\/?>|<\/(?:p|div|li)>)/i', "\n", (string) $this->note_public);
888 return dolGetFirstLineOfText($note);
889 }
890
891 // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
899 public function LibStatut($status, $mode = 0)
900 {
901 // phpcs:enable
902 global $langs;
903
904 $labelStatus = $langs->transnoentitiesnoconv($this->labelStatus[$status]);
905 $labelStatusShort = $langs->transnoentitiesnoconv($this->labelStatusShort[$status]);
906
907 $statuslogo = array(0 => 'status0', 2 => 'status1', 4 => 'status6', 5 => 'status4', 6 => 'status6', 99 => 'status5');
908
909 $statusType = $statuslogo[$status];
910
911 return dolGetStatus($labelStatus, $labelStatusShort, '', $statusType, $mode);
912 }
913
914
921 public function info($id)
922 {
923 global $conf;
924
925 $sql = "SELECT f.rowid,";
926 $sql .= " f.date_create as datec,";
927 $sql .= " f.tms as date_modification,";
928 $sql .= " f.date_valid as datev,";
929 $sql .= " f.date_approve as datea,";
930 $sql .= " f.fk_user_creat as fk_user_creation,";
931 $sql .= " f.fk_user_author as fk_user_author,";
932 $sql .= " f.fk_user_modif as fk_user_modification,";
933 $sql .= " f.fk_user_valid,";
934 $sql .= " f.fk_user_approve";
935 $sql .= " FROM ".MAIN_DB_PREFIX."expensereport as f";
936 $sql .= " WHERE f.rowid = ".((int) $id);
937 $sql .= " AND f.entity = ".((int) $conf->entity);
938
939
940
941 $resql = $this->db->query($sql);
942 if ($resql) {
943 if ($this->db->num_rows($resql)) {
944 $obj = $this->db->fetch_object($resql);
945
946 $this->id = $obj->rowid;
947
948 $this->date_creation = $this->db->jdate($obj->datec);
949 $this->date_modification = $this->db->jdate($obj->date_modification);
950 $this->date_validation = $this->db->jdate($obj->datev);
951 $this->date_approbation = $this->db->jdate($obj->datea);
952
953 $this->user_creation_id = $obj->fk_user_author;
954 $this->user_creation_id = $obj->fk_user_creation;
955 $this->user_validation_id = $obj->fk_user_valid;
956 $this->user_modification_id = $obj->fk_user_modification;
957 $this->user_approve_id = $obj->fk_user_approve;
958 }
959 $this->db->free($resql);
960 } else {
961 dol_print_error($this->db);
962 }
963 }
964
965
966
974 public function initAsSpecimen()
975 {
976 global $user, $langs;
977
978 $now = dol_now();
979
980 // Initialise parameters
981 $this->id = 0;
982 $this->ref = 'SPECIMEN';
983 $this->specimen = 1;
984 $this->entity = 1;
985 $this->date_create = $now;
986 $this->date_debut = $now;
987 $this->date_fin = $now;
988 $this->date_valid = $now;
989 $this->date_approve = $now;
990
991 $type_fees_id = 2; // TF_TRIP
992
993 $this->status = 5;
994
995 $this->fk_user_author = $user->id;
996 $this->fk_user_validator = $user->id;
997 $this->fk_user_valid = $user->id;
998 $this->fk_user_approve = $user->id;
999
1000 $this->note_private = 'Private note';
1001 $this->note_public = 'SPECIMEN';
1002 $nbp = min(1000, GETPOSTINT('nblines') ? GETPOSTINT('nblines') : 5); // We can force the nb of lines to test from command line (but not more than 1000)
1003 $xnbp = 0;
1004 while ($xnbp < $nbp) {
1005 $line = new ExpenseReportLine($this->db);
1006 $line->comments = $langs->trans("Comment")." ".$xnbp;
1007 $line->date = ($now - 3600 * (1 + $xnbp));
1008 $line->total_ht = 100;
1009 $line->total_tva = 20;
1010 $line->total_ttc = 120;
1011 $line->qty = 1;
1012 $line->vatrate = 20;
1013 $line->value_unit = 120;
1014 $line->fk_expensereport = 0;
1015 $line->type_fees_code = 'TRA';
1016 $line->fk_c_type_fees = $type_fees_id;
1017
1018 $line->projet_ref = 'ABC';
1019
1020 $this->lines[$xnbp] = $line;
1021 $xnbp++;
1022
1023 $this->total_ht += $line->total_ht;
1024 $this->total_tva += $line->total_tva;
1025 $this->total_ttc += $line->total_ttc;
1026 }
1027
1028 return 1;
1029 }
1030
1031 // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
1039 public function fetch_line_by_project($projectid, $user)
1040 {
1041 // phpcs:enable
1042 global $langs;
1043
1044 $langs->load('trips');
1045
1046 if ($user->hasRight('expensereport', 'lire')) {
1047 $sql = "SELECT de.fk_expensereport, de.date, de.comments, de.total_ht, de.total_ttc";
1048 $sql .= " FROM ".MAIN_DB_PREFIX."expensereport_det as de";
1049 $sql .= " WHERE de.fk_projet = ".((int) $projectid);
1050
1051 dol_syslog(get_class($this)."::fetch", LOG_DEBUG);
1052 $result = $this->db->query($sql);
1053 if ($result) {
1054 $num = $this->db->num_rows($result);
1055 $i = 0;
1056 $total_HT = 0;
1057 $total_TTC = 0;
1058
1059 while ($i < $num) {
1060 $objp = $this->db->fetch_object($result);
1061
1062 $sql2 = "SELECT d.rowid, d.fk_user_author, d.ref, d.fk_statut as status";
1063 $sql2 .= " FROM ".MAIN_DB_PREFIX."expensereport as d";
1064 $sql2 .= " WHERE d.rowid = ".((int) $objp->fk_expensereport);
1065
1066 $result2 = $this->db->query($sql2);
1067 $obj = $this->db->fetch_object($result2);
1068
1069 $objp->fk_user_author = $obj->fk_user_author;
1070 $objp->ref = $obj->ref;
1071 $objp->fk_c_expensereport_status = $obj->status;
1072 $objp->rowid = $obj->rowid;
1073
1074 $total_HT += $objp->total_ht;
1075 $total_TTC += $objp->total_ttc;
1076 $author = new User($this->db);
1077 $author->fetch($objp->fk_user_author);
1078
1079 print '<tr>';
1080 print '<td>';
1081 print '<a href="'.dolBuildUrl(DOL_URL_ROOT.'/expensereport/card.php', ['id' => $objp->rowid]).'">'.$objp->ref_num.'</a>';
1082 print '</td>';
1083 print '<td class="center">'.dol_print_date($objp->date, 'day').'</td>';
1084 print '<td>'.$author->getNomUrl(1).'</td>';
1085 print '<td>'.$objp->comments.'</td>';
1086 print '<td class="right">'.price($objp->total_ht).'</td>';
1087 print '<td class="right">'.price($objp->total_ttc).'</td>';
1088 print '<td class="right">';
1089
1090 switch ($objp->fk_c_expensereport_status) {
1091 case 4:
1092 print img_picto($langs->trans('StatusOrderCanceled'), 'statut5');
1093 break;
1094 case 1:
1095 print $langs->trans('Draft').' '.img_picto($langs->trans('Draft'), 'statut0');
1096 break;
1097 case 2:
1098 print $langs->trans('TripForValid').' '.img_picto($langs->trans('TripForValid'), 'statut3');
1099 break;
1100 case 5:
1101 print $langs->trans('TripForPaid').' '.img_picto($langs->trans('TripForPaid'), 'statut3');
1102 break;
1103 case 6:
1104 print $langs->trans('TripPaid').' '.img_picto($langs->trans('TripPaid'), 'statut4');
1105 break;
1106 }
1107 /*
1108 if ($status==4) return img_picto($langs->trans('StatusOrderCanceled'),'statut5');
1109 if ($status==1) return img_picto($langs->trans('StatusOrderDraft'),'statut0');
1110 if ($status==2) return img_picto($langs->trans('StatusOrderValidated'),'statut1');
1111 if ($status==2) return img_picto($langs->trans('StatusOrderOnProcess'),'statut3');
1112 if ($status==5) return img_picto($langs->trans('StatusOrderToBill'),'statut4');
1113 if ($status==6) return img_picto($langs->trans('StatusOrderOnProcess'),'statut6');
1114 */
1115 print '</td>';
1116 print '</tr>';
1117
1118 $i++;
1119 }
1120
1121 print '<tr class="liste_total"><td colspan="4">'.$langs->trans("Number").': '.$i.'</td>';
1122 print '<td class="right" width="100">'.$langs->trans("TotalHT").' : '.price($total_HT).'</td>';
1123 print '<td class="right" width="100">'.$langs->trans("TotalTTC").' : '.price($total_TTC).'</td>';
1124 print '<td>&nbsp;</td>';
1125 print '</tr>';
1126 } else {
1127 $this->error = $this->db->lasterror();
1128 return -1;
1129 }
1130 }
1131
1132 return 0;
1133 }
1134
1135 // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
1141 public function fetch_lines()
1142 {
1143 // phpcs:enable
1144 $this->lines = array();
1145
1146 $sql = ' SELECT de.rowid, de.comments, de.qty, de.value_unit, de.date, de.rang,';
1147 $sql .= " de.".$this->db->sanitize($this->fk_element).", de.fk_c_type_fees, de.fk_c_exp_tax_cat, de.fk_projet as fk_project,";
1148 $sql .= ' de.tva_tx, de.vat_src_code,';
1149 $sql .= ' de.localtax1_tx, de.localtax2_tx, de.localtax1_type, de.localtax2_type,';
1150 $sql .= ' de.fk_ecm_files,';
1151 $sql .= ' de.total_ht, de.total_tva, de.total_ttc,';
1152 $sql .= ' de.total_localtax1, de.total_localtax2, de.rule_warning_message,';
1153 $sql .= ' ctf.code as code_type_fees, ctf.label as label_type_fees, ctf.accountancy_code as accountancy_code_type_fees,';
1154 $sql .= ' p.ref as ref_projet, p.title as title_projet';
1155 $sql .= ' FROM '.MAIN_DB_PREFIX.$this->db->sanitize($this->table_element_line).' as de';
1156 $sql .= ' LEFT JOIN '.MAIN_DB_PREFIX.'c_type_fees as ctf ON de.fk_c_type_fees = ctf.id';
1157 $sql .= ' LEFT JOIN '.MAIN_DB_PREFIX.'projet as p ON de.fk_projet = p.rowid';
1158 $sql .= " WHERE de.".$this->db->sanitize($this->fk_element)." = ".((int) $this->id);
1159 if (getDolGlobalString('EXPENSEREPORT_LINES_SORTED_BY_ROWID')) {
1160 $sql .= ' ORDER BY de.rang ASC, de.rowid ASC';
1161 } else {
1162 $sql .= ' ORDER BY de.rang ASC, de.date ASC';
1163 }
1164
1165 $resql = $this->db->query($sql);
1166 if ($resql) {
1167 $num = $this->db->num_rows($resql);
1168 $i = 0;
1169 while ($i < $num) {
1170 $objp = $this->db->fetch_object($resql);
1171
1172 $deplig = new ExpenseReportLine($this->db);
1173
1174 $deplig->rowid = $objp->rowid;
1175 $deplig->id = $objp->rowid;
1176 $deplig->comments = $objp->comments;
1177 $deplig->qty = $objp->qty;
1178 $deplig->value_unit = $objp->value_unit;
1179 $deplig->date = $objp->date;
1180 $deplig->dates = $this->db->jdate($objp->date);
1181
1182 $deplig->fk_expensereport = $objp->fk_expensereport;
1183 $deplig->fk_c_type_fees = $objp->fk_c_type_fees;
1184 $deplig->fk_c_exp_tax_cat = $objp->fk_c_exp_tax_cat;
1185 $deplig->fk_projet = $objp->fk_project; // deprecated
1186 $deplig->fk_project = $objp->fk_project;
1187 $deplig->fk_ecm_files = $objp->fk_ecm_files;
1188
1189 $deplig->total_ht = $objp->total_ht;
1190 $deplig->total_tva = $objp->total_tva;
1191 $deplig->total_ttc = $objp->total_ttc;
1192 $deplig->total_localtax1 = $objp->total_localtax1;
1193 $deplig->total_localtax2 = $objp->total_localtax2;
1194
1195 $deplig->type_fees_code = empty($objp->code_type_fees) ? 'TF_OTHER' : $objp->code_type_fees;
1196 $deplig->type_fees_libelle = $objp->label_type_fees;
1197 $deplig->type_fees_accountancy_code = $objp->accountancy_code_type_fees;
1198
1199 $deplig->tva_tx = $objp->tva_tx;
1200 $deplig->vatrate = $objp->tva_tx;
1201 $deplig->vat_src_code = $objp->vat_src_code;
1202 $deplig->localtax1_tx = $objp->localtax1_tx;
1203 $deplig->localtax2_tx = $objp->localtax2_tx;
1204 $deplig->localtax1_type = $objp->localtax1_type;
1205 $deplig->localtax2_type = $objp->localtax2_type;
1206
1207 $deplig->projet_ref = $objp->ref_projet;
1208 $deplig->projet_title = $objp->title_projet;
1209
1210 $deplig->rule_warning_message = $objp->rule_warning_message;
1211
1212 $deplig->rang = $objp->rang;
1213
1214 $this->lines[$i] = $deplig;
1215
1216 $i++;
1217 }
1218 $this->db->free($resql);
1219 return 1;
1220 } else {
1221 $this->error = $this->db->lasterror();
1222 dol_syslog(get_class($this)."::fetch_lines: Error ".$this->error, LOG_ERR);
1223 return -3;
1224 }
1225 }
1226
1227
1235 public function delete($user = null, $notrigger = 0)
1236 {
1237 global $conf;
1238 require_once DOL_DOCUMENT_ROOT.'/core/lib/files.lib.php';
1239
1240 $error = 0;
1241
1242 // Refuse to delete a report that has payments: they would be left without their expense report
1243 $sql = "SELECT COUNT(rowid) as nb FROM ".MAIN_DB_PREFIX."payment_expensereport WHERE fk_expensereport = ".((int) $this->id);
1244 $resql = $this->db->query($sql);
1245 if (!$resql) {
1246 $this->error = $this->db->lasterror();
1247 return -1;
1248 }
1249 $obj = $this->db->fetch_object($resql);
1250 if ($obj && $obj->nb > 0) {
1251 $this->error = 'ErrorRecordHasChildren';
1252 return -1;
1253 }
1254
1255 $this->db->begin();
1256
1257 if (!$notrigger) {
1258 // Call trigger
1259 $result = $this->call_trigger('EXPENSE_REPORT_DELETE', $user);
1260 if ($result < 0) {
1261 $error++;
1262 }
1263 // End call triggers
1264 }
1265
1266 // Delete extrafields of lines and lines
1267 if (!$error && !empty($this->table_element_line)) {
1268 $tabletodelete = $this->table_element_line;
1269 //$sqlef = "DELETE FROM ".MAIN_DB_PREFIX.$tabletodelete."_extrafields WHERE fk_object IN (SELECT rowid FROM ".MAIN_DB_PREFIX.$tabletodelete." WHERE ".$this->fk_element." = ".((int) $this->id).")";
1270 $sql = "DELETE FROM ".MAIN_DB_PREFIX.$tabletodelete." WHERE ".$this->fk_element." = ".((int) $this->id);
1271 if (!$this->db->query($sql)) {
1272 $error++;
1273 $this->error = $this->db->lasterror();
1274 $this->errors[] = $this->error;
1275 dol_syslog(get_class($this)."::delete error ".$this->error, LOG_ERR);
1276 }
1277 }
1278
1279 if (!$error) {
1280 // Delete linked object
1281 $res = $this->deleteObjectLinked();
1282 if ($res < 0) {
1283 $error++;
1284 }
1285 }
1286
1287 if (!$error) {
1288 // Delete linked contacts
1289 $res = $this->delete_linked_contact();
1290 if ($res < 0) {
1291 $error++;
1292 }
1293 }
1294
1295 // Removed extrafields of object
1296 if (!$error) {
1297 $result = $this->deleteExtraFields();
1298 if ($result < 0) {
1299 $error++;
1300 dol_syslog(get_class($this)."::delete error ".$this->error, LOG_ERR);
1301 }
1302 }
1303
1304 // Delete main record
1305 if (!$error) {
1306 $sql = "DELETE FROM ".MAIN_DB_PREFIX.$this->table_element." WHERE rowid = ".((int) $this->id);
1307 $res = $this->db->query($sql);
1308 if (!$res) {
1309 $error++;
1310 $this->error = $this->db->lasterror();
1311 $this->errors[] = $this->error;
1312 dol_syslog(get_class($this)."::delete error ".$this->error, LOG_ERR);
1313 }
1314 }
1315
1316 // Delete record into ECM index and physically
1317 if (!$error) {
1318 $res = $this->deleteEcmFiles(0); // Deleting files physically is done later with the dol_delete_dir_recursive
1319 $res = $this->deleteEcmFiles(1); // Deleting files physically is done later with the dol_delete_dir_recursive
1320 if (!$res) {
1321 $error++;
1322 }
1323 }
1324
1325 if (!$error) {
1326 // We remove directory
1327 $ref = dol_sanitizeFileName($this->ref);
1328 if ($conf->expensereport->multidir_output[$this->entity] && !empty($this->ref)) {
1329 $dir = $conf->expensereport->multidir_output[$this->entity]."/".$ref;
1330 $file = $dir."/".$ref.".pdf";
1331 if (file_exists($file)) {
1332 dol_delete_preview($this);
1333
1334 if (!dol_delete_file($file, 0, 0, 0, $this)) {
1335 $this->error = 'ErrorFailToDeleteFile';
1336 $this->errors[] = $this->error;
1337 $this->db->rollback();
1338 return 0;
1339 }
1340 }
1341 if (file_exists($dir)) {
1342 $res = @dol_delete_dir_recursive($dir);
1343 if (!$res) {
1344 $this->error = 'ErrorFailToDeleteDir';
1345 $this->errors[] = $this->error;
1346 $this->db->rollback();
1347 return 0;
1348 }
1349 }
1350 }
1351 }
1352
1353 if (!$error) {
1354 dol_syslog(get_class($this)."::delete ".$this->id." by ".$user->id, LOG_DEBUG);
1355 $this->db->commit();
1356 return 1;
1357 } else {
1358 $this->db->rollback();
1359 return -1;
1360 }
1361 }
1362
1370 public function setValidate($fuser, $notrigger = 0)
1371 {
1372 global $conf, $langs, $user;
1373
1374 $error = 0;
1375 $now = dol_now();
1376
1377 // Protection
1378 if ($this->status == self::STATUS_VALIDATED) {
1379 dol_syslog(get_class($this)."::valid action abandoned: already validated", LOG_WARNING);
1380 return 0;
1381 }
1382
1383 $this->date_valid = $now; // Required for the getNextNum later.
1384
1385 // Define new ref
1386 if (preg_match('/^[\‍(]?PROV/i', $this->ref) || empty($this->ref)) { // empty should not happened, but when it occurs, the test save life
1387 $num = $this->getNextNumRef();
1388 } else {
1389 $num = (string) $this->ref;
1390 }
1391 if (empty($num) || $num < 0) {
1392 return -1;
1393 }
1394
1395 $this->newref = dol_sanitizeFileName($num);
1396
1397 $this->db->begin();
1398
1399 // Validate
1400 $sql = "UPDATE ".MAIN_DB_PREFIX.$this->table_element;
1401 $sql .= " SET ref = '".$this->db->escape($num)."',";
1402 $sql .= " fk_statut = ".((int) self::STATUS_VALIDATED).",";
1403 $sql .= " date_valid = '".$this->db->idate($this->date_valid)."',";
1404 $sql .= " fk_user_valid = ".((int) $user->id);
1405 $sql .= " WHERE rowid = ".((int) $this->id);
1406
1407 $resql = $this->db->query($sql);
1408 if ($resql) {
1409 if (!$notrigger) {
1410 // Call trigger
1411 $result = $this->call_trigger('EXPENSE_REPORT_VALIDATE', $fuser);
1412 if ($result < 0) {
1413 $error++;
1414 }
1415 // End call triggers
1416 }
1417
1418 if (!$error) {
1419 $this->oldref = $this->ref;
1420
1421 // Rename directory if dir was a temporary ref
1422 if (preg_match('/^[\‍(]?PROV/i', $this->ref)) {
1423 require_once DOL_DOCUMENT_ROOT.'/core/lib/files.lib.php';
1424
1425 // Now we rename also files into index
1426 $sql = 'UPDATE '.MAIN_DB_PREFIX."ecm_files set filename = CONCAT('".$this->db->escape($this->newref)."', SUBSTR(filename, ".(strlen($this->ref) + 1).")), filepath = 'expensereport/".$this->db->escape($this->newref)."'";
1427 $sql .= " WHERE filename LIKE '".$this->db->escape($this->ref)."%' AND filepath = 'expensereport/".$this->db->escape($this->ref)."' AND entity = ".((int) $this->entity);
1428 $resql = $this->db->query($sql);
1429 if (!$resql) {
1430 $error++;
1431 $this->error = $this->db->lasterror();
1432 }
1433 $sql = 'UPDATE '.MAIN_DB_PREFIX."ecm_files set filepath = 'expensereport/".$this->db->escape($this->newref)."'";
1434 $sql .= " WHERE filepath = 'expensereport/".$this->db->escape($this->ref)."' and entity = ".((int) $conf->entity);
1435 $resql = $this->db->query($sql);
1436 if (!$resql) {
1437 $error++;
1438 $this->error = $this->db->lasterror();
1439 }
1440
1441 // We rename directory ($this->ref = old ref, $num = new ref) in order not to lose the attachments
1442 $oldref = dol_sanitizeFileName($this->ref);
1443 $newref = dol_sanitizeFileName($num);
1444 $dirsource = $conf->expensereport->multidir_output[$this->entity].'/'.$oldref;
1445 $dirdest = $conf->expensereport->multidir_output[$this->entity].'/'.$newref;
1446 if (!$error && file_exists($dirsource)) {
1447 dol_syslog(get_class($this)."::setValidate() rename dir ".$dirsource." into ".$dirdest);
1448
1449 if (@rename($dirsource, $dirdest)) {
1450 dol_syslog("Rename ok");
1451 // Rename docs starting with $oldref with $newref
1452 $listoffiles = dol_dir_list($dirdest, 'files', 1, '^'.preg_quote($oldref, '/'));
1453 foreach ($listoffiles as $fileentry) {
1454 $dirsource = $fileentry['name'];
1455 $dirdest = preg_replace('/^'.preg_quote($oldref, '/').'/', $newref, $dirsource);
1456 $dirsource = $fileentry['path'].'/'.$dirsource;
1457 $dirdest = $fileentry['path'].'/'.$dirdest;
1458 @rename($dirsource, $dirdest);
1459 }
1460 }
1461 }
1462 }
1463 }
1464
1465 // Set new ref and current status
1466 if (!$error) {
1467 $this->ref = $num;
1469 }
1470
1471 if (empty($error)) {
1472 $this->db->commit();
1473 return 1;
1474 } else {
1475 $this->db->rollback();
1476 $this->error = $this->db->error();
1477 return -2;
1478 }
1479 } else {
1480 $this->db->rollback();
1481 $this->error = $this->db->lasterror();
1482 return -1;
1483 }
1484 }
1485
1486 // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
1493 public function set_save_from_refuse($fuser)
1494 {
1495 // phpcs:enable
1496 // Select the start date of the expense report
1497 $sql = 'SELECT date_debut';
1498 $sql .= ' FROM '.MAIN_DB_PREFIX.$this->table_element;
1499 $sql .= " WHERE rowid = ".((int) $this->id);
1500
1501 $result = $this->db->query($sql);
1502
1503 $objp = $this->db->fetch_object($result);
1504
1505 $this->date_debut = $this->db->jdate($objp->date_debut);
1506
1507 if ($this->status != self::STATUS_VALIDATED) {
1508 $sql = 'UPDATE '.MAIN_DB_PREFIX.$this->table_element;
1509 $sql .= " SET fk_statut = ".((int) self::STATUS_VALIDATED);
1510 $sql .= " WHERE rowid = ".((int) $this->id);
1511
1512 dol_syslog(get_class($this)."::set_save_from_refuse", LOG_DEBUG);
1513
1514 if ($this->db->query($sql)) {
1515 return 1;
1516 } else {
1517 $this->error = $this->db->lasterror();
1518 return -1;
1519 }
1520 } else {
1521 dol_syslog(get_class($this)."::set_save_from_refuse expensereport already with save status", LOG_WARNING);
1522 }
1523
1524 return 0;
1525 }
1526
1534 public function setApproved($fuser, $notrigger = 0)
1535 {
1536 $now = dol_now();
1537 $error = 0;
1538
1539 if ($this->status != self::STATUS_APPROVED) {
1540 $this->db->begin();
1541 $sql = 'UPDATE '.MAIN_DB_PREFIX.$this->table_element;
1542 $sql .= " SET ref = '".$this->db->escape($this->ref)."', fk_statut = ".((int) self::STATUS_APPROVED).", fk_user_approve = ".((int) $fuser->id).",";
1543 $sql .= " date_approve='".$this->db->idate($now)."'";
1544 $sql .= " WHERE rowid = ".((int) $this->id);
1545 if ($this->db->query($sql)) {
1547 $this->date_approve = $now;
1548 $this->fk_user_approve = $fuser->id;
1549 if (!$notrigger) {
1550 // Call trigger
1551 $result = $this->call_trigger('EXPENSE_REPORT_APPROVE', $fuser);
1552
1553 if ($result < 0) {
1554 $error++;
1555 }
1556 // End call triggers
1557 }
1558
1559 if (empty($error)) {
1560 $this->db->commit();
1561 return 1;
1562 } else {
1563 $this->db->rollback();
1564 $this->error = $this->db->error();
1565 return -2;
1566 }
1567 } else {
1568 $this->db->rollback();
1569 $this->error = $this->db->lasterror();
1570 return -1;
1571 }
1572 } else {
1573 dol_syslog(get_class($this)."::setApproved expensereport already with approve status", LOG_WARNING);
1574 }
1575
1576 return 0;
1577 }
1578
1587 public function setDeny($fuser, $details, $notrigger = 0)
1588 {
1589 $now = dol_now();
1590 $error = 0;
1591
1592 // date de refus
1593 if ($this->status != self::STATUS_REFUSED) {
1594 $sql = 'UPDATE '.MAIN_DB_PREFIX.$this->table_element;
1595 $sql .= " SET ref = '".$this->db->escape($this->ref)."', fk_statut = ".self::STATUS_REFUSED.", fk_user_refuse = ".((int) $fuser->id).",";
1596 $sql .= " date_refuse='".$this->db->idate($now)."',";
1597 $sql .= " detail_refuse='".$this->db->escape($details)."',";
1598 $sql .= " fk_user_approve = NULL";
1599 $sql .= " WHERE rowid = ".((int) $this->id);
1600 if ($this->db->query($sql)) {
1601 $this->fk_statut = 99; // deprecated
1602 $this->status = 99;
1603 $this->fk_user_refuse = $fuser->id;
1604 $this->detail_refuse = $details;
1605 $this->date_refuse = $now;
1606
1607 if (!$notrigger) {
1608 // Call trigger
1609 $result = $this->call_trigger('EXPENSE_REPORT_DENY', $fuser);
1610
1611 if ($result < 0) {
1612 $error++;
1613 }
1614 // End call triggers
1615 }
1616
1617 if (empty($error)) {
1618 $this->db->commit();
1619 return 1;
1620 } else {
1621 $this->db->rollback();
1622 $this->error = $this->db->error();
1623 return -2;
1624 }
1625 } else {
1626 $this->db->rollback();
1627 $this->error = $this->db->lasterror();
1628 return -1;
1629 }
1630 } else {
1631 dol_syslog(get_class($this)."::setDeny expensereport already with refuse status", LOG_WARNING);
1632 }
1633
1634 return 0;
1635 }
1636
1637 // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
1647 public function set_unpaid($fuser, $notrigger = 0)
1648 {
1649 // phpcs:enable
1650 dol_syslog(get_class($this)."::set_unpaid is deprecated, use setUnpaid instead", LOG_NOTICE);
1651 return $this->setUnpaid($fuser, $notrigger);
1652 }
1653
1661 public function setUnpaid($fuser, $notrigger = 0)
1662 {
1663 $error = 0;
1664
1665 if ($this->paid) {
1666 $this->db->begin();
1667
1668 $sql = 'UPDATE '.MAIN_DB_PREFIX.$this->table_element;
1669 $sql .= " SET paid = 0, fk_statut = ".self::STATUS_APPROVED;
1670 $sql .= " WHERE rowid = ".((int) $this->id);
1671
1672 dol_syslog(get_class($this)."::set_unpaid", LOG_DEBUG);
1673
1674 if ($this->db->query($sql)) {
1675 if (!$notrigger) {
1676 // Call trigger
1677 $result = $this->call_trigger('EXPENSE_REPORT_UNPAID', $fuser);
1678
1679 if ($result < 0) {
1680 $error++;
1681 }
1682 // End call triggers
1683 }
1684
1685 if (empty($error)) {
1686 $this->db->commit();
1687 return 1;
1688 } else {
1689 $this->db->rollback();
1690 $this->error = $this->db->error();
1691 return -2;
1692 }
1693 } else {
1694 $this->db->rollback();
1695 $this->error = $this->db->error();
1696 return -1;
1697 }
1698 } else {
1699 dol_syslog(get_class($this)."::set_unpaid expensereport already with unpaid status", LOG_WARNING);
1700 }
1701
1702 return 0;
1703 }
1704
1705 // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
1714 public function set_cancel($fuser, $detail, $notrigger = 0)
1715 {
1716 // phpcs:enable
1717 $error = 0;
1718 $this->date_cancel = dol_now();
1719 if ($this->status != self::STATUS_CANCELED) {
1720 $this->db->begin();
1721
1722 $sql = 'UPDATE '.MAIN_DB_PREFIX.$this->table_element;
1723 $sql .= " SET fk_statut = ".((int) self::STATUS_CANCELED).", fk_user_cancel = ".((int) $fuser->id);
1724 $sql .= ", date_cancel = '".$this->db->idate($this->date_cancel)."'";
1725 $sql .= ", detail_cancel = '".$this->db->escape($detail)."'";
1726 $sql .= " WHERE rowid = ".((int) $this->id);
1727
1728 dol_syslog(get_class($this)."::set_cancel", LOG_DEBUG);
1729
1730 if ($this->db->query($sql)) {
1731 if (!$notrigger) {
1732 // Call trigger
1733 $result = $this->call_trigger('EXPENSE_REPORT_CANCEL', $fuser);
1734
1735 if ($result < 0) {
1736 $error++;
1737 }
1738 // End call triggers
1739 }
1740
1741 if (empty($error)) {
1742 $this->db->commit();
1743 return 1;
1744 } else {
1745 $this->db->rollback();
1746 $this->error = $this->db->error();
1747 return -2;
1748 }
1749 } else {
1750 $this->db->rollback();
1751 $this->error = $this->db->error();
1752 return -1;
1753 }
1754 } else {
1755 dol_syslog(get_class($this)."::set_cancel expensereport already with cancel status", LOG_WARNING);
1756 }
1757 return 0;
1758 }
1759
1765 public function getNextNumRef()
1766 {
1767 global $langs, $conf;
1768 $langs->load("trips");
1769
1770 if (getDolGlobalString('EXPENSEREPORT_ADDON')) {
1771 $mybool = false;
1772
1773 $file = getDolGlobalString('EXPENSEREPORT_ADDON') . ".php";
1774 $classname = getDolGlobalString('EXPENSEREPORT_ADDON');
1775
1776 // Include file with class
1777 $dirmodels = array_merge(array('/'), (array) $conf->modules_parts['models']);
1778 foreach ($dirmodels as $reldir) {
1779 $dir = dol_buildpath($reldir."core/modules/expensereport/");
1780
1781 // Load file with numbering class (if found)
1782 $mybool = ((bool) @include_once $dir.$file) || $mybool;
1783 }
1784
1785 if (!$mybool) {
1786 dol_print_error(null, "Failed to include file ".$file);
1787 return '';
1788 }
1789
1790 $obj = new $classname();
1791 '@phan-var-force ModeleNumRefExpenseReport $obj';
1792 $numref = $obj->getNextValue($this);
1793
1794 if ($numref != "") {
1795 return $numref;
1796 } else {
1797 $this->error = $obj->error;
1798 $this->errors = $obj->errors;
1799 //dol_print_error($this->db,get_class($this)."::getNextNumRef ".$obj->error);
1800 return -1;
1801 }
1802 } else {
1803 $this->error = "Error_EXPENSEREPORT_ADDON_NotDefined";
1804 return -2;
1805 }
1806 }
1807
1814 public function getTooltipContentArray($params)
1815 {
1816 global $conf, $langs;
1817
1818 $langs->load('trips');
1819
1820 $nofetch = !empty($params['nofetch']);
1821 $moretitle = $params['moretitle'] ?? '';
1822
1823 $datas = array();
1824 $datas['picto'] = img_picto('', $this->picto).' <u class="paddingrightonly">'.$langs->trans("ExpenseReport").'</u>';
1825 if (isset($this->status)) {
1826 $datas['picto'] .= ' '.$this->getLibStatut(5);
1827 }
1828 if ($moretitle) {
1829 $datas['picto'] .= ' - '.$moretitle;
1830 }
1831 if (!empty($this->ref)) {
1832 $datas['ref'] = '<br><b>'.$langs->trans('Ref').':</b> '.$this->ref;
1833 }
1834 if (!empty($this->total_ht)) {
1835 $datas['total_ht'] = '<br><b>'.$langs->trans('AmountHT').':</b> '.price($this->total_ht, 0, $langs, 0, -1, -1, $conf->currency);
1836 }
1837 if (!empty($this->total_tva)) {
1838 $datas['total_tva'] = '<br><b>'.$langs->trans('VAT').':</b> '.price($this->total_tva, 0, $langs, 0, -1, -1, $conf->currency);
1839 }
1840 if (!empty($this->total_ttc)) {
1841 $datas['total_ttc'] = '<br><b>'.$langs->trans('AmountTTC').':</b> '.price($this->total_ttc, 0, $langs, 0, -1, -1, $conf->currency);
1842 }
1843
1844 return $datas;
1845 }
1846
1859 public function getNomUrl($withpicto = 0, $option = '', $max = 0, $short = 0, $moretitle = '', $notooltip = 0, $save_lastsearch_value = -1)
1860 {
1861 global $langs, $hookmanager;
1862
1863 $result = '';
1864
1865 $baseurl = DOL_URL_ROOT.'/expensereport/card.php';
1866 $query = ['id' => $this->id];
1867
1868 if ($short) {
1869 return dolBuildUrl($baseurl, $query);
1870 }
1871
1872 $params = [
1873 'id' => $this->id,
1874 'objecttype' => $this->element,
1875 'option' => $option,
1876 'moretitle' => $moretitle,
1877 'nofetch' => 1,
1878 ];
1879 $classfortooltip = 'classfortooltip';
1880 $dataparams = '';
1881 if (getDolGlobalInt('MAIN_ENABLE_AJAX_TOOLTIP')) {
1882 $classfortooltip = 'classforajaxtooltip';
1883 $dataparams = ' data-params="'.dol_escape_htmltag(json_encode($params)).'"';
1884 $label = '';
1885 } else {
1886 $label = implode($this->getTooltipContentArray($params));
1887 }
1888
1889 if ($option != 'nolink') {
1890 // Add param to save lastsearch_values or not
1891 $add_save_lastsearch_values = ($save_lastsearch_value == 1 ? 1 : 0);
1892 if ($save_lastsearch_value == -1 && isset($_SERVER["PHP_SELF"]) && preg_match('/list\.php/', $_SERVER["PHP_SELF"])) {
1893 $add_save_lastsearch_values = 1;
1894 }
1895 if ($add_save_lastsearch_values) {
1896 $query += ['save_lastsearch_values' => 1];
1897 }
1898 }
1899 $url = dolBuildUrl($baseurl, $query);
1900
1901 $ref = $this->ref;
1902 if (empty($ref)) {
1903 $ref = $this->id;
1904 }
1905
1906 $linkclose = '';
1907 if (empty($notooltip)) {
1908 if (getDolGlobalString('MAIN_OPTIMIZEFORTEXTBROWSER')) {
1909 $label = $langs->trans("ShowExpenseReport");
1910 $linkclose .= ' alt="'.dolPrintHTMLForAttribute($label).'"';
1911 }
1912 $linkclose .= ($label ? ' title="'.dolPrintHTMLForAttribute($label).'"' : ' title="tocomplete"');
1913 $linkclose .= $dataparams.' class="'.$classfortooltip.'"';
1914 }
1915
1916 $linkstart = '<a href="'.$url.'"';
1917 $linkstart .= $linkclose.'>';
1918 $linkend = '</a>';
1919
1920 $result .= $linkstart;
1921 if ($withpicto) {
1922 $result .= img_object(($notooltip ? '' : $label), ($this->picto ? $this->picto : 'generic'), ($notooltip ? (($withpicto != 2) ? 'class="paddingright"' : '') : 'class="'.(($withpicto != 2) ? 'paddingright ' : '').'"'), 0, 0, $notooltip ? 0 : 1);
1923 }
1924 if ($withpicto != 2) {
1925 $result .= ($max ? dol_trunc($ref, $max) : $ref);
1926 }
1927 $result .= $linkend;
1928
1929 global $action;
1930 $hookmanager->initHooks(array($this->element . 'dao'));
1931 $parameters = array('id' => $this->id, 'getnomurl' => &$result);
1932 $reshook = $hookmanager->executeHooks('getNomUrl', $parameters, $this, $action); // Note that $action and $object may have been modified by some hooks
1933 if ($reshook > 0) {
1934 $result = $hookmanager->resPrint;
1935 } else {
1936 $result .= $hookmanager->resPrint;
1937 }
1938 return $result;
1939 }
1940
1941 // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
1949 public function update_totaux_add($ligne_total_ht, $ligne_total_tva)
1950 {
1951 // phpcs:enable
1952 $this->total_ht += (float) $ligne_total_ht;
1953 $this->total_tva += (float) $ligne_total_tva;
1954 $this->total_ttc += $this->total_tva;
1955
1956 $sql = "UPDATE ".MAIN_DB_PREFIX.$this->table_element." SET";
1957 $sql .= " total_ht = ".((float) $this->total_ht);
1958 $sql .= " , total_ttc = ".((float) $this->total_ttc);
1959 $sql .= " , total_tva = ".((float) $this->total_tva);
1960 $sql .= " WHERE rowid = ".((int) $this->id);
1961
1962 $result = $this->db->query($sql);
1963 if ($result) {
1964 return 1;
1965 } else {
1966 $this->error = $this->db->error();
1967 return -1;
1968 }
1969 }
1970
1986 public function addline($qty = 0, $up = 0, $fk_c_type_fees = 0, $vatrate = 0, $date = '', $comments = '', $fk_project = 0, $fk_c_exp_tax_cat = 0, $type = 0, $fk_ecm_files = 0)
1987 {
1988 global $mysoc;
1989
1990 dol_syslog(get_class($this)."::addline qty=$qty, up=$up, fk_c_type_fees=$fk_c_type_fees, vatrate=$vatrate, date=$date, fk_project=$fk_project, type=$type, comments=$comments", LOG_DEBUG);
1991
1992 if ($this->status == self::STATUS_DRAFT || $this->status == self::STATUS_REFUSED) {
1993 if (empty($qty)) {
1994 $qty = 0;
1995 }
1996 if (empty($fk_c_type_fees) || $fk_c_type_fees < 0) {
1997 $fk_c_type_fees = 0;
1998 }
1999 if (empty($fk_c_exp_tax_cat) || $fk_c_exp_tax_cat < 0) {
2000 $fk_c_exp_tax_cat = 0;
2001 }
2002 if (empty($vatrate) || $vatrate < 0) {
2003 $vatrate = 0;
2004 }
2005 if (empty($date)) {
2006 $date = '';
2007 }
2008 if (empty($fk_project)) {
2009 $fk_project = 0;
2010 }
2011
2012 $qty = (float) price2num($qty);
2013 if (!preg_match('/\s*\‍((.*)\‍)/', $vatrate)) {
2014 $vatrate = price2num($vatrate); // $txtva can have format '5.0 (XXX)' or '5'
2015 }
2016 $up = price2num($up);
2017
2018 $this->db->begin();
2019
2020 $this->line = new ExpenseReportLine($this->db);
2021
2022 // We don't know seller and buyer for expense reports
2023 $seller = $mysoc; // We use same than current company (expense report are often done in same country)
2024 $seller->tva_assuj = 1; // Most seller uses vat
2025 $buyer = new Societe($this->db);
2026
2027 $localtaxes_type = getLocalTaxesFromRate($vatrate, 0, $buyer, $seller);
2028
2029 $vat_src_code = '';
2030 $reg = array();
2031 if (preg_match('/\s*\‍((.*)\‍)/', $vatrate, $reg)) {
2032 $vat_src_code = $reg[1];
2033 $vatrate = preg_replace('/\s*\‍(.*\‍)/', '', $vatrate); // Remove code into vatrate.
2034 }
2035 $vatrate = preg_replace('/\*/', '', $vatrate);
2036
2037 $tmp = calcul_price_total($qty, (float) $up, 0, (float) price2num($vatrate), -1, -1, 0, 'TTC', 0, $type, $seller, $localtaxes_type);
2038
2039 $this->line->value_unit = $up;
2040
2041 $this->line->vat_src_code = $vat_src_code;
2042 $this->line->vatrate = price2num($vatrate);
2043 $this->line->localtax1_tx = $localtaxes_type[1];
2044 $this->line->localtax2_tx = $localtaxes_type[3];
2045 $this->line->localtax1_type = $localtaxes_type[0];
2046 $this->line->localtax2_type = $localtaxes_type[2];
2047
2048 $this->line->total_ttc = (float) $tmp[2];
2049 $this->line->total_ht = (float) $tmp[0];
2050 $this->line->total_tva = (float) $tmp[1];
2051 $this->line->total_localtax1 = (float) $tmp[9];
2052 $this->line->total_localtax2 = (float) $tmp[10];
2053
2054 $this->line->fk_expensereport = $this->id;
2055 $this->line->qty = $qty;
2056 $this->line->date = $date;
2057 $this->line->fk_c_type_fees = $fk_c_type_fees;
2058 $this->line->fk_c_exp_tax_cat = $fk_c_exp_tax_cat;
2059 $this->line->comments = $comments;
2060 $this->line->fk_projet = $fk_project; // deprecated
2061 $this->line->fk_project = $fk_project;
2062
2063 $this->line->fk_ecm_files = $fk_ecm_files;
2064
2065 $this->applyOffset();
2066 $this->checkRules($type, $seller);
2067
2068 $result = $this->line->insert(0, true);
2069 if ($result > 0) {
2070 $result = $this->update_price(1); // This method is designed to add line from user input so total calculation must be done using 'auto' mode.
2071 if ($result > 0) {
2072 $this->db->commit();
2073 return $this->line->id;
2074 } else {
2075 $this->db->rollback();
2076 return -1;
2077 }
2078 } else {
2079 $this->error = $this->line->error;
2080 dol_syslog(get_class($this)."::addline error=".$this->error, LOG_ERR);
2081 $this->db->rollback();
2082 return -2;
2083 }
2084 } else {
2085 dol_syslog(get_class($this)."::addline status of expense report must be Draft to allow use of ->addline()", LOG_ERR);
2086 $this->error = 'ErrorExpenseNotDraftAndNotRefused';
2087 return -3;
2088 }
2089 }
2090
2098 public function checkRules($type = 0, $seller = '')
2099 {
2100 global $conf, $langs, $mysoc;
2101
2102 $langs->load('trips');
2103
2104 // We don't know seller and buyer for expense reports
2105 if (!is_object($seller)) {
2106 $seller = $mysoc; // We use same than current company (expense report are often done in same country)
2107 $seller->tva_assuj = 1; // Most seller uses vat
2108 }
2109
2110 $expensereportrule = new ExpenseReportRule($this->db);
2111 $rulestocheck = $expensereportrule->getAllRule($this->line->fk_c_type_fees, $this->line->date, $this->fk_user_author);
2112
2113 $violation = 0;
2114 $rule_warning_message_tab = array();
2115
2116 $current_total_ttc = $this->line->total_ttc;
2117 $new_current_total_ttc = $this->line->total_ttc;
2118
2119 // check if one is violated
2120 foreach ($rulestocheck as $rule) {
2121 if (in_array($rule->code_expense_rules_type, array('EX_DAY', 'EX_MON', 'EX_YEA'))) {
2122 $amount_to_test = $this->line->getExpAmount($rule, $this->fk_user_author, $rule->code_expense_rules_type);
2123 } else {
2124 $amount_to_test = $current_total_ttc; // EX_EXP
2125 }
2126
2127 $amount_to_test = $amount_to_test - $current_total_ttc + $new_current_total_ttc; // if amount as been modified by a previous rule
2128
2129 if ($amount_to_test > $rule->amount) {
2130 $violation++;
2131
2132 if ($rule->restrictive) {
2133 $this->error = 'ExpenseReportConstraintViolationError';
2134 $this->errors[] = $this->error;
2135
2136 $new_current_total_ttc -= $amount_to_test - $rule->amount; // ex: entered 16 EUR, limit 12 EUR, subtracts 4 EUR
2137 $rule_warning_message_tab[] = $langs->trans('ExpenseReportConstraintViolationError', $rule->id, price($amount_to_test, 0, $langs, 1, -1, -1, $conf->currency), price($rule->amount, 0, $langs, 1, -1, -1, $conf->currency));
2138 } else {
2139 $this->error = 'ExpenseReportConstraintViolationWarning';
2140 $this->errors[] = $this->error;
2141
2142 $rule_warning_message_tab[] = $langs->trans('ExpenseReportConstraintViolationWarning', $rule->id, price($amount_to_test, 0, $langs, 1, -1, -1, $conf->currency), price($rule->amount, 0, $langs, 1, -1, -1, $conf->currency));
2143 }
2144
2145 // No break, we should test if another rule is violated
2146 }
2147 }
2148
2149 $this->line->rule_warning_message = implode('\n', $rule_warning_message_tab);
2150
2151 if ($violation > 0) {
2152 $tmp = calcul_price_total($this->line->qty, $new_current_total_ttc / $this->line->qty, 0, $this->line->vatrate, 0, 0, 0, 'TTC', 0, $type, $seller);
2153
2154 $this->line->value_unit = $tmp[5];
2155 $this->line->total_ttc = (float) $tmp[2];
2156 $this->line->total_ht = (float) $tmp[0];
2157 $this->line->total_tva = (float) $tmp[1];
2158 $this->line->total_localtax1 = (float) $tmp[9];
2159 $this->line->total_localtax2 = (float) $tmp[10];
2160
2161 return false;
2162 } else {
2163 return true;
2164 }
2165 }
2166
2174 public function applyOffset($type = 0, $seller = '')
2175 {
2176 global $mysoc;
2177
2178 if (!getDolGlobalString('MAIN_USE_EXPENSE_IK')) {
2179 return false;
2180 }
2181
2182 $userauthor = new User($this->db);
2183 if ($userauthor->fetch($this->fk_user_author) <= 0) {
2184 $this->error = 'ErrorCantFetchUser';
2185 $this->errors[] = 'ErrorCantFetchUser';
2186 return false;
2187 }
2188
2189 // We don't know seller and buyer for expense reports
2190 if (!is_object($seller)) {
2191 $seller = $mysoc; // We use same than current company (expense report are often done in same country)
2192 $seller->tva_assuj = 1; // Most seller uses vat
2193 }
2194
2195 $expenseik = new ExpenseReportIk($this->db);
2196 $range = $expenseik->getRangeByUser($userauthor, $this->line->fk_c_exp_tax_cat);
2197
2198 if (empty($range)) {
2199 $this->error = 'ErrorNoRangeAvailable';
2200 $this->errors[] = 'ErrorNoRangeAvailable';
2201 return false;
2202 }
2203
2204 if (getDolGlobalString('MAIN_EXPENSE_APPLY_ENTIRE_OFFSET')) {
2205 $ikoffset = $range->ikoffset;
2206 } else {
2207 $ikoffset = $range->ikoffset / 12; // The amount of offset is a global value for the year
2208 }
2209
2210 // Test if ikoffset has been applied for the current month
2211 if (!$this->offsetAlreadyGiven()) {
2212 $new_up = $range->coef + ($ikoffset / $this->line->qty);
2213 $tmp = calcul_price_total($this->line->qty, $new_up, 0, $this->line->vatrate, 0, 0, 0, 'TTC', 0, $type, $seller);
2214
2215 $this->line->value_unit = $tmp[5];
2216 $this->line->total_ttc = (float) $tmp[2];
2217 $this->line->total_ht = (float) $tmp[0];
2218 $this->line->total_tva = (float) $tmp[1];
2219 $this->line->total_localtax1 = (float) $tmp[9];
2220 $this->line->total_localtax2 = (float) $tmp[10];
2221
2222 return true;
2223 }
2224
2225 return false;
2226 }
2227
2233 public function offsetAlreadyGiven()
2234 {
2235 $sql = 'SELECT e.rowid FROM '.MAIN_DB_PREFIX.'expensereport e';
2236 $sql .= " INNER JOIN ".MAIN_DB_PREFIX."expensereport_det d ON (e.rowid = d.fk_expensereport)";
2237 $sql .= " INNER JOIN ".MAIN_DB_PREFIX."c_type_fees f ON (d.fk_c_type_fees = f.id AND f.code = 'EX_KME')";
2238 $sql .= " WHERE e.fk_user_author = ".(int) $this->fk_user_author;
2239 $sql .= " AND YEAR(d.date) = '".dol_print_date($this->line->date, '%Y')."' AND MONTH(d.date) = '".dol_print_date($this->line->date, '%m')."'";
2240 if (!empty($this->line->id)) {
2241 $sql .= ' AND d.rowid <> '.((int) $this->line->id);
2242 }
2243
2244 dol_syslog(get_class($this)."::offsetAlreadyGiven");
2245 $resql = $this->db->query($sql);
2246 if ($resql) {
2247 $num = $this->db->num_rows($resql);
2248 if ($num > 0) {
2249 return true;
2250 }
2251 } else {
2252 dol_print_error($this->db);
2253 }
2254
2255 return false;
2256 }
2257
2275 public function updateline($rowid, $type_fees_id, $projet_id, $vatrate, $comments, $qty, $value_unit, $date, $expensereport_id, $fk_c_exp_tax_cat = 0, $fk_ecm_files = 0, $notrigger = 0)
2276 {
2277 global $user, $mysoc;
2278
2279 if (!$this->isLineOfObject($rowid)) {
2280 $this->error = 'ErrorLineIDDoesNotMatchWithObjectID';
2281 return -1;
2282 }
2283
2284 if ($this->status == self::STATUS_DRAFT || $this->status == self::STATUS_REFUSED) {
2285 $this->db->begin();
2286
2287 $error = 0;
2288 $type = 0; // TODO What if type is service ?
2289
2290 // We don't know seller and buyer for expense reports
2291 $seller = $mysoc; // We use same than current company (expense report are often done in same country)
2292 $seller->tva_assuj = 1; // Most seller uses vat
2293 $seller->localtax1_assuj = $mysoc->localtax1_assuj; // We don't know, we reuse the state of company
2294 $seller->localtax2_assuj = $mysoc->localtax1_assuj; // We don't know, we reuse the state of company
2295 $buyer = new Societe($this->db);
2296
2297 $localtaxes_type = getLocalTaxesFromRate($vatrate, 0, $buyer, $seller);
2298
2299 // Clean vat code
2300 $reg = array();
2301 $vat_src_code = '';
2302 if (preg_match('/\‍((.*)\‍)/', (string) $vatrate, $reg)) {
2303 $vat_src_code = $reg[1];
2304 $vatrate = preg_replace('/\s*\‍(.*\‍)/', '', (string) $vatrate); // Remove code into vatrate.
2305 }
2306 $vatrate = preg_replace('/\*/', '', $vatrate);
2307
2308 $tmp = calcul_price_total($qty, $value_unit, 0, (float) price2num($vatrate), -1, -1, 0, 'TTC', 0, $type, $seller, $localtaxes_type);
2309 // calcul total of line
2310 // $total_ttc = price2num($qty*$value_unit, 'MT');
2311
2312 $tx_tva = 1 + (float) $vatrate / 100;
2313
2314 $this->line = new ExpenseReportLine($this->db);
2315 $this->line->comments = $comments;
2316 $this->line->qty = $qty;
2317 $this->line->value_unit = $value_unit;
2318 $this->line->date = $date;
2319
2320 $this->line->fk_expensereport = $expensereport_id;
2321 $this->line->fk_c_type_fees = $type_fees_id;
2322 $this->line->fk_c_exp_tax_cat = $fk_c_exp_tax_cat;
2323 $this->line->fk_projet = $projet_id; // deprecated
2324 $this->line->fk_project = $projet_id;
2325
2326 $this->line->vat_src_code = $vat_src_code;
2327 $this->line->vatrate = price2num($vatrate);
2328 $this->line->localtax1_tx = $localtaxes_type[1];
2329 $this->line->localtax2_tx = $localtaxes_type[3];
2330 $this->line->localtax1_type = $localtaxes_type[0];
2331 $this->line->localtax2_type = $localtaxes_type[2];
2332
2333 $this->line->total_ttc = (float) $tmp[2];
2334 $this->line->total_ht = (float) $tmp[0];
2335 $this->line->total_tva = (float) $tmp[1];
2336 $this->line->total_localtax1 = (float) $tmp[9];
2337 $this->line->total_localtax2 = (float) $tmp[10];
2338
2339 $this->line->fk_ecm_files = $fk_ecm_files;
2340
2341 $this->line->id = ((int) $rowid);
2342
2343 // Select info about the fee type
2344 $sql = "SELECT c.code as code_type_fees, c.label as label_type_fees";
2345 $sql .= " FROM ".MAIN_DB_PREFIX."c_type_fees as c";
2346 $sql .= " WHERE c.id = ".((int) $type_fees_id);
2347 $resql = $this->db->query($sql);
2348 if ($resql) {
2349 $objp_fees = $this->db->fetch_object($resql);
2350 $this->line->type_fees_code = $objp_fees->code_type_fees;
2351 $this->line->type_fees_libelle = $objp_fees->label_type_fees;
2352 $this->db->free($resql);
2353 }
2354
2355 if ($projet_id > 0) {
2356 // Select information about the project
2357 $sql = "SELECT p.ref as ref_projet, p.title as title_projet";
2358 $sql .= " FROM ".MAIN_DB_PREFIX."projet as p";
2359 $sql .= " WHERE p.rowid = ".((int) $projet_id);
2360 $resql = $this->db->query($sql);
2361 if ($resql) {
2362 if ($this->db->num_rows($resql) > 0) {
2363 $objp_projet = $this->db->fetch_object($resql);
2364 $this->line->projet_ref = $objp_projet->ref_projet;
2365 $this->line->projet_title = $objp_projet->title_projet;
2366 }
2367 $this->db->free($resql);
2368 }
2369 }
2370 $this->applyOffset();
2371 $this->checkRules();
2372
2373 $result = $this->line->update($user, $notrigger);
2374 if ($result < 0) {
2375 $error++;
2376 }
2377
2378 if (!$error) {
2379 $this->db->commit();
2380 return 1;
2381 } else {
2382 $this->error = $this->line->error;
2383 $this->errors = $this->line->errors;
2384 $this->db->rollback();
2385 return -2;
2386 }
2387 }
2388
2389 return 0;
2390 }
2391
2400 public function deleteLine($rowid, $fuser = null, $notrigger = 0)
2401 {
2402 $error = 0;
2403
2404 if ($this->id > 0) {
2405 // The line must belong to this expense report
2406 $sql = "SELECT rowid FROM ".$this->db->prefix().$this->table_element_line;
2407 $sql .= " WHERE rowid = ".((int) $rowid)." AND fk_expensereport = ".((int) $this->id);
2408 $resql = $this->db->query($sql);
2409 if (!$resql || !$this->db->num_rows($resql)) {
2410 $this->error = 'ErrorLineIDDoesNotMatchWithObjectID';
2411 return -1;
2412 }
2413 }
2414
2415 $this->db->begin();
2416
2417 if (!$notrigger) {
2418 // Call triggers
2419 $result = $this->call_trigger('EXPENSE_REPORT_DET_DELETE', $fuser);
2420 if ($result < 0) {
2421 $error++;
2422 }
2423 // End call triggers
2424 }
2425
2426 $sql = ' DELETE FROM '.MAIN_DB_PREFIX.$this->table_element_line;
2427 $sql .= ' WHERE rowid = '.((int) $rowid);
2428
2429 dol_syslog(get_class($this)."::deleteline sql=".$sql);
2430 $result = $this->db->query($sql);
2431
2432 if (!$result || $error > 0) {
2433 $this->error = $this->db->error();
2434 dol_syslog(get_class($this)."::deleteline Error ".$this->error, LOG_ERR);
2435 $this->db->rollback();
2436 return -1;
2437 }
2438
2439 $this->update_price(1);
2440
2441 $this->db->commit();
2442
2443 return 1;
2444 }
2445
2454 public function periodExists(User $fuser, $startDate, $endDate)
2455 {
2456 global $conf;
2457
2458 $sql = "SELECT rowid, date_debut, date_fin";
2459 $sql .= " FROM ".MAIN_DB_PREFIX.$this->table_element;
2460 $sql .= " WHERE entity = ".((int) $conf->entity); // not shared, only for the current entity
2461 $sql .= " AND fk_user_author = ".((int) $fuser->id);
2462 $sql .= " AND (date_fin >= '".$this->db->idate($startDate)."' AND date_debut <= '".$this->db->idate($endDate)."')";
2463
2464 $row = $this->db->getRow($sql);
2465
2466 if ($row === false) {
2467 $this->error = $this->db->lasterror();
2468 dol_syslog(__CLASS__."::". __METHOD__." Error ".$this->error, LOG_ERR);
2469 return -1;
2470 }
2471
2472 return $row->rowid ?? 0;
2473 }
2474
2475
2476 // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
2484 {
2485 // phpcs:enable
2486 $users_validator = array();
2487
2488 $sql = "SELECT DISTINCT ur.fk_user";
2489 $sql .= " FROM ".MAIN_DB_PREFIX."user_rights as ur, ".MAIN_DB_PREFIX."rights_def as rd";
2490 $sql .= " WHERE ur.fk_id = rd.id and rd.module = 'expensereport' AND rd.perms = 'approve'"; // Permission 'Approve';
2491 $sql .= " UNION";
2492 $sql .= " SELECT DISTINCT ugu.fk_user";
2493 $sql .= " FROM ".MAIN_DB_PREFIX."usergroup_user as ugu, ".MAIN_DB_PREFIX."usergroup_rights as ur, ".MAIN_DB_PREFIX."rights_def as rd";
2494 $sql .= " WHERE ugu.fk_usergroup = ur.fk_usergroup AND ur.fk_id = rd.id and rd.module = 'expensereport' AND rd.perms = 'approve'"; // Permission 'Approve';
2495 //print $sql;
2496
2497 dol_syslog(get_class($this)."::fetch_users_approver_expensereport sql=".$sql);
2498 $result = $this->db->query($sql);
2499 if ($result) {
2500 $num_rows = $this->db->num_rows($result);
2501 $i = 0;
2502 while ($i < $num_rows) {
2503 $objp = $this->db->fetch_object($result);
2504 array_push($users_validator, $objp->fk_user);
2505 $i++;
2506 }
2507 return $users_validator;
2508 } else {
2509 $this->error = $this->db->lasterror();
2510 dol_syslog(get_class($this)."::fetch_users_approver_expensereport Error ".$this->error, LOG_ERR);
2511 return -1;
2512 }
2513 }
2514
2526 public function generateDocument($modele, $outputlangs, $hidedetails = 0, $hidedesc = 0, $hideref = 0, $moreparams = null)
2527 {
2528 $outputlangs->load("trips");
2529
2530 if (!dol_strlen($modele)) {
2531 if (!empty($this->model_pdf)) {
2532 $modele = $this->model_pdf;
2533 } elseif (getDolGlobalString('EXPENSEREPORT_ADDON_PDF')) {
2534 $modele = getDolGlobalString('EXPENSEREPORT_ADDON_PDF');
2535 }
2536 }
2537
2538 if (!empty($modele)) {
2539 $modelpath = "core/modules/expensereport/doc/";
2540
2541 return $this->commonGenerateDocument($modelpath, $modele, $outputlangs, $hidedetails, $hidedesc, $hideref, $moreparams);
2542 } else {
2543 return 0;
2544 }
2545 }
2546
2553 public function listOfTypes($active = 1)
2554 {
2555 global $langs;
2556 $ret = array();
2557 $sql = "SELECT id, code, label";
2558 $sql .= " FROM ".MAIN_DB_PREFIX."c_type_fees";
2559 $sql .= " WHERE active = ".((int) $active);
2560 dol_syslog(get_class($this)."::listOfTypes", LOG_DEBUG);
2561 $result = $this->db->query($sql);
2562 if ($result) {
2563 $num = $this->db->num_rows($result);
2564 $i = 0;
2565 while ($i < $num) {
2566 $obj = $this->db->fetch_object($result);
2567 $ret[$obj->code] = (($langs->transnoentitiesnoconv($obj->code) != $obj->code) ? $langs->transnoentitiesnoconv($obj->code) : $obj->label);
2568 $i++;
2569 }
2570 } else {
2571 dol_print_error($this->db);
2572 }
2573 return $ret;
2574 }
2575
2581 public function loadStateBoard()
2582 {
2583 global $user;
2584
2585 $this->nb = array();
2586
2587 $sql = "SELECT count(ex.rowid) as nb";
2588 $sql .= " FROM ".MAIN_DB_PREFIX."expensereport as ex";
2589 $sql .= " WHERE ex.fk_statut > 0";
2590 $sql .= " AND ex.entity IN (".getEntity('expensereport').")";
2591 if (!$user->hasRight('expensereport', 'readall')) {
2592 $userchildids = $user->getAllChildIds(1);
2593 $sql .= " AND (ex.fk_user_author IN (".$this->db->sanitize(implode(',', $userchildids)).")";
2594 $sql .= " OR ex.fk_user_validator IN (".$this->db->sanitize(implode(',', $userchildids))."))";
2595 }
2596
2597 $resql = $this->db->query($sql);
2598 if ($resql) {
2599 while ($obj = $this->db->fetch_object($resql)) {
2600 $this->nb["expensereports"] = $obj->nb;
2601 }
2602 $this->db->free($resql);
2603 return 1;
2604 } else {
2605 dol_print_error($this->db);
2606 $this->error = $this->db->error();
2607 return -1;
2608 }
2609 }
2610
2611 // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
2619 public function load_board($user, $option = 'topay')
2620 {
2621 // phpcs:enable
2622 global $conf, $langs;
2623
2624 if ($user->socid) {
2625 return -1; // Protection to prevent calls by external users
2626 }
2627
2628 $now = dol_now();
2629 $warning_delay = ($option == 'toapprove' ? $conf->expensereport->approve->warning_delay : $conf->expensereport->payment->warning_delay);
2630
2631 // The count and the number of late expense reports are computed by the database instead of reading every report. A
2632 // report is late when its validation date is before now minus the warning delay (a report without validation date was
2633 // counted as late, this is kept).
2634 $sql = "SELECT COUNT(ex.rowid) as nb,";
2635 $sql .= " SUM(CASE WHEN ex.date_valid IS NULL OR ex.date_valid < '".$this->db->idate($now - $warning_delay)."' THEN 1 ELSE 0 END) as nblate";
2636 $sql .= " FROM ".MAIN_DB_PREFIX."expensereport as ex";
2637 if ($option == 'toapprove') {
2638 $sql .= " WHERE ex.fk_statut = ".self::STATUS_VALIDATED;
2639 } else {
2640 $sql .= " WHERE ex.fk_statut = ".self::STATUS_APPROVED;
2641 }
2642 $sql .= " AND ex.entity IN (".getEntity('expensereport').")";
2643 if (!$user->hasRight('expensereport', 'readall')) {
2644 $userchildids = $user->getAllChildIds(1);
2645 $sql .= " AND (ex.fk_user_author IN (".$this->db->sanitize(implode(',', $userchildids)).")";
2646 $sql .= " OR ex.fk_user_validator IN (".$this->db->sanitize(implode(',', $userchildids))."))";
2647 }
2648
2649 $resql = $this->db->query($sql);
2650 if ($resql) {
2651 $langs->load("trips");
2652
2653 $response = new WorkboardResponse();
2654 if ($option == 'toapprove') {
2655 $response->warning_delay = $conf->expensereport->approve->warning_delay / 60 / 60 / 24;
2656 $response->label = $langs->trans("ExpenseReportsToApprove");
2657 $response->labelShort = $langs->trans("ToApprove");
2658 $response->url = dolBuildUrl(DOL_URL_ROOT.'/expensereport/list.php', ['mainmenu' => 'hrm', 'statut' => self::STATUS_VALIDATED]);
2659 } else {
2660 $response->warning_delay = $conf->expensereport->payment->warning_delay / 60 / 60 / 24;
2661 $response->label = $langs->trans("ExpenseReportsToPay");
2662 $response->labelShort = $langs->trans("StatusToPay");
2663 $response->url = dolBuildUrl(DOL_URL_ROOT.'/expensereport/list.php', ['mainmenu' => 'hrm', 'statut' => self::STATUS_APPROVED]);
2664 }
2665 $response->img = img_object('', "trip");
2666
2667 $obj = $this->db->fetch_object($resql);
2668 if ($obj) {
2669 $response->nbtodo = (int) $obj->nb;
2670 $response->nbtodolate = (int) $obj->nblate;
2671 }
2672
2673 return $response;
2674 } else {
2675 dol_print_error($this->db);
2676 $this->error = $this->db->error();
2677 return -1;
2678 }
2679 }
2680
2687 public function hasDelay($option)
2688 {
2689 global $conf;
2690
2691 // Only valid expenses reports
2692 if ($option == 'toapprove' && $this->status != 2) {
2693 return false;
2694 }
2695 if ($option == 'topay' && $this->status != 5) {
2696 return false;
2697 }
2698
2699 $now = dol_now();
2700 $warning_delay = (int) ($option == 'toapprove' ? $conf->expensereport->approve->warning_delay : $conf->expensereport->payment->warning_delay);
2701 if ($warning_delay <= 0) {
2702 // No delay configured (MAIN_DELAY_EXPENSEREPORTS / MIN_DELAY_EXPENSEREPORTS_TO_PAY not set), so nothing is late.
2703 return false;
2704 }
2705 return (!empty($this->datevalid) ? $this->datevalid : $this->date_valid) < ($now - $warning_delay);
2706 }
2707
2714 public function getVentilExportCompta($mode = 0)
2715 {
2716 $alreadydispatched = 0;
2717
2718 $type = 'expense_report';
2719
2720 $sql = " SELECT ".($mode ? 'DISTINCT piece_num' : 'COUNT(ab.rowid)')." as nb";
2721 $sql .= " FROM ".MAIN_DB_PREFIX."accounting_bookkeeping as ab WHERE ab.doc_type = '".$this->db->escape($type)."' AND ab.fk_doc = ".((int) $this->id);
2722 $resql = $this->db->query($sql);
2723 if ($resql) {
2724 $obj = $this->db->fetch_object($resql);
2725 if ($obj) {
2726 $alreadydispatched = $obj->nb;
2727 }
2728 } else {
2729 $this->error = $this->db->lasterror();
2730 return -1;
2731 }
2732
2733 if ($alreadydispatched) {
2734 return $alreadydispatched;
2735 }
2736 return 0;
2737 }
2738
2744 public function getSumPayments()
2745 {
2746 $table = 'payment_expensereport';
2747 $field = 'fk_expensereport';
2748
2749 $sql = 'SELECT sum(amount) as amount';
2750 $sql .= ' FROM '.MAIN_DB_PREFIX.$table;
2751 $sql .= " WHERE ".$this->db->sanitize($field)." = ".((int) $this->id);
2752
2753 dol_syslog(get_class($this)."::getSumPayments", LOG_DEBUG);
2754 $resql = $this->db->query($sql);
2755 if ($resql) {
2756 $obj = $this->db->fetch_object($resql);
2757 $this->db->free($resql);
2758 return (empty($obj->amount) ? 0 : $obj->amount);
2759 } else {
2760 $this->error = $this->db->lasterror();
2761 return -1;
2762 }
2763 }
2764
2773 public function computeTotalKm($fk_cat, $qty, $tva)
2774 {
2775 global $langs, $conf;
2776
2777 $cumulYearQty = 0;
2778 $ranges = array();
2779 $coef = 0;
2780
2781
2782 if ($fk_cat < 0) {
2783 $this->error = $langs->trans('ErrorBadParameterCat');
2784 return -1;
2785 }
2786
2787 if ($qty <= 0) {
2788 $this->error = $langs->trans('ErrorBadParameterQty');
2789 return -1;
2790 }
2791
2792 $currentUser = new User($this->db);
2793 $currentUser->fetch($this->fk_user);
2794 $currentUser->loadRights('expensereport');
2795 //Clean
2796 $qty = (float) price2num($qty);
2797
2798 $sql = " SELECT r.range_ik, t.ikoffset, t.coef";
2799 $sql .= " FROM ".MAIN_DB_PREFIX."expensereport_ik t";
2800 $sql .= " LEFT JOIN ".MAIN_DB_PREFIX."c_exp_tax_range r ON r.rowid = t.fk_range";
2801 $sql .= " WHERE t.fk_c_exp_tax_cat = ".(int) $fk_cat;
2802 $sql .= " ORDER BY r.range_ik ASC";
2803
2804 dol_syslog("expenseReport::computeTotalkm sql=".$sql, LOG_DEBUG);
2805
2806 $result = $this->db->query($sql);
2807
2808 if ($result) {
2809 if (getDolGlobalInt('EXPENSEREPORT_CALCULATE_MILEAGE_EXPENSE_COEFFICIENT_ON_CURRENT_YEAR')) {
2810 $arrayDate = dol_getdate(dol_now());
2811 $sql = " SELECT count(n.qty) as cumul FROM ".MAIN_DB_PREFIX."expensereport_det n";
2812 $sql .= " LEFT JOIN ".MAIN_DB_PREFIX."expensereport e ON e.rowid = n.fk_expensereport";
2813 $sql .= " LEFT JOIN ".MAIN_DB_PREFIX."c_type_fees tf ON tf.id = n.fk_c_type_fees";
2814 $sql .= " WHERE e.fk_user_author = ".(int) $this->fk_user_author;
2815 $sql .= " AND YEAR(n.date) = ".(int) $arrayDate['year'];
2816 $sql .= " AND tf.code = 'EX_KME' ";
2817 $sql .= " AND e.fk_statut = ".(int) ExpenseReport::STATUS_VALIDATED;
2818
2819 $resql = $this->db->query($sql);
2820
2821 if ($resql) {
2822 $obj = $this->db->fetch_object($resql);
2823 $cumulYearQty = $obj->cumul;
2824 }
2825
2826 $qty += (float) $cumulYearQty;
2827 }
2828
2829 $num = $this->db->num_rows($result);
2830
2831 if ($num) {
2832 for ($i = 0; $i < $num; $i++) {
2833 $obj = $this->db->fetch_object($result);
2834
2835 $ranges[$i] = $obj;
2836 }
2837 '@phan-var-force Object[] $ranges';
2838
2839 for ($i = 0; $i < $num; $i++) {
2840 if ($i < ($num - 1)) {
2841 // @phan-suppress-next-line PhanTypeInvalidDimOffset
2842 if ($qty > $ranges[$i]->range_ik && $qty < $ranges[$i + 1]->range_ik) {
2843 $coef = $ranges[$i]->coef;
2844 $offset = $ranges[$i]->ikoffset;
2845 }
2846 } else {
2847 if ($qty > $ranges[$i]->range_ik) {
2848 $coef = $ranges[$i]->coef;
2849 $offset = $ranges[$i]->ikoffset;
2850 }
2851 }
2852 }
2853 $total_ht = $coef;
2854 return $total_ht;
2855 } else {
2856 $this->error = $langs->trans('TaxUndefinedForThisCategory');
2857 return 0;
2858 }
2859 } else {
2860 $this->error = $this->db->error()." sql=".$sql;
2861
2862 return -1;
2863 }
2864 }
2865
2873 public function getKanbanView($option = '', $arraydata = null)
2874 {
2875 global $langs;
2876
2877 if ($arraydata === null) {
2878 $arraydata = array();
2879 }
2880
2881 $selected = (empty($arraydata['selected']) ? 0 : $arraydata['selected']);
2882
2883 $return = '<div class="box-flex-item box-flex-grow-zero">';
2884 $return .= '<div class="info-box info-box-sm">';
2885 $return .= '<span class="info-box-icon bg-infobox-action">';
2886 $return .= img_picto('', $this->picto);
2887 $return .= '</span>';
2888 $return .= '<div class="info-box-content">';
2889 $return .= '<span class="info-box-ref inline-block tdoverflowmax150 valignmiddle">' . $this->getNomUrl(1) . '</span>';
2890 if ($selected >= 0) {
2891 $return .= '<input id="cb'.$this->id.'" class="flat checkforselect fright" type="checkbox" name="toselect[]" value="'.$this->id.'"'.($selected ? ' checked="checked"' : '').'>';
2892 }
2893 if (array_key_exists('userauthor', $arraydata) && $arraydata['userauthor'] instanceof User) {
2894 $return .= '<br><span class="info-box-label">'.$arraydata['userauthor']->getNomUrl(-1).'</span>';
2895 }
2896 if (isDolTms($this->date_debut) || isDolTms($this->date_fin)) {
2897 $return .= '<br><span class="info-box-label">'.dol_print_date($this->date_debut, 'day').'</span>';
2898 $return .= ' <span class="opacitymedium">'.$langs->trans("To").'</span> ';
2899 $return .= '<span class="info-box-label">'.dol_print_date($this->date_fin, 'day').'</span>';
2900 }
2901 $return .= '<br><div class="info-box-status">'.$this->getLibStatut(3).'</div>';
2902 $return .= '</div>';
2903 $return .= '</div>';
2904 $return .= '</div>';
2905 return $return;
2906 }
2907}
$object ref
Definition info.php:90
if(!isModEnabled('ai')||!getDolGlobalString('AI_ASSISTANT_ENABLED')) global $conf
The main.inc.php has been included so the following variable are now defined:
fetch_optionals($rowid=null, $optionsArray=null)
Function to get extra fields of an object into $this->array_options This method is in most cases call...
deleteEcmFiles($mode=0)
Delete related files of object in database.
update_price($exclspec=0, $roundingadjust='auto', $nodatabaseupdate=0, $seller=null)
Update total_ht, total_ttc, total_vat, total_localtax1, total_localtax2 for an object (sum of lines).
commonGenerateDocument($modelspath, $modele, $outputlangs, $hidedetails, $hidedesc, $hideref, $moreparams=null)
Common function for all objects extending CommonObject for generating documents.
deleteObjectLinked($sourceid=null, $sourcetype='', $targetid=null, $targettype='', $rowid=0, $f_user=null, $notrigger=0)
Delete all links between an object $this.
setErrorsFromObject($object)
setErrorsFromObject
isLineOfObject($lineid)
Check that a line belongs to this object, using $this->table_element_line and $this->fk_element.
deleteExtraFields()
Delete all extra fields values for the current object.
insertExtraFields($trigger='', $userused=null)
Add/Update all extra fields values for the current object.
delete_linked_contact($source='', $code='')
Delete all links between an object $this and all its contacts in llx_element_contact.
Class to manage Trips and Expenses.
setPaid($id, $fuser, $notrigger=0)
Classify the expense report as paid.
loadStateBoard()
Load the indicators this->nb for the state board.
__construct($db)
Constructor.
checkRules($type=0, $seller='')
Check constraint of rules and update price if needed.
updateline($rowid, $type_fees_id, $projet_id, $vatrate, $comments, $qty, $value_unit, $date, $expensereport_id, $fk_c_exp_tax_cat=0, $fk_ecm_files=0, $notrigger=0)
Update an expense report line.
getNextNumRef()
Return next reference of expense report not already used.
createFromClone(User $user, $fk_user_author)
Load an object from its id and create a new one in database.
addline($qty=0, $up=0, $fk_c_type_fees=0, $vatrate=0, $date='', $comments='', $fk_project=0, $fk_c_exp_tax_cat=0, $type=0, $fk_ecm_files=0)
Add expense report line.
const STATUS_DRAFT
Draft status.
computeTotalKm($fk_cat, $qty, $tva)
Compute the cost of the kilometers expense based on the number of kilometers and the vehicle category...
offsetAlreadyGiven()
If the sql find any rows then the ikoffset is already given (ikoffset is applied at the first expense...
listOfTypes($active=1)
List of types.
const STATUS_APPROVED
Classified approved.
set_save_from_refuse($fuser)
set_save_from_refuse
setValidate($fuser, $notrigger=0)
Set to status validate.
getSumPayments()
Return amount of payments already done.
getLibStatut($mode=0)
Returns the label status.
deleteLine($rowid, $fuser=null, $notrigger=0)
deleteline
set_cancel($fuser, $detail, $notrigger=0)
set_cancel
getNomUrl($withpicto=0, $option='', $max=0, $short=0, $moretitle='', $notooltip=0, $save_lastsearch_value=-1)
Return clickable name (with picto eventually)
set_unpaid($fuser, $notrigger=0)
set_unpaid
getVentilExportCompta($mode=0)
Return if object was dispatched into bookkeeping.
info($id)
Load information on object.
getTooltipContentArray($params)
getTooltipContentArray
hasDelay($option)
Return if an expense report is late or not.
applyOffset($type=0, $seller='')
Method to apply the offset if needed.
const STATUS_CANCELED
Classified canceled.
const STATUS_CLOSED
Classified paid.
const STATUS_REFUSED
Classified refused.
periodExists(User $fuser, $startDate, $endDate)
periodExists
setDeny($fuser, $details, $notrigger=0)
setDeny
getKanbanView($option='', $arraydata=null)
Return clickable link of object (with optional picto)
update($user, $notrigger=0, $userofexpensereport=null)
update
const STATUS_VALIDATED
Validated (need to be paid)
create($user, $notrigger=0)
Create object in database.
load_board($user, $option='topay')
Load indicators for dashboard (this->nbtodo and this->nbtodolate)
set_paid($id, $fuser, $notrigger=0)
Classify the expense report as paid.
getSummary()
Return a short summary of the public note.
generateDocument($modele, $outputlangs, $hidedetails=0, $hidedesc=0, $hideref=0, $moreparams=null)
Create a document onto disk according to template module.
initAsSpecimen()
Initialise an instance with random values.
fetch_users_approver_expensereport()
Return list of people with permission to validate expense reports.
setApproved($fuser, $notrigger=0)
Set status to approved.
LibStatut($status, $mode=0)
Returns the label of a status.
setUnpaid($fuser, $notrigger=0)
set_unpaid
fetch_line_by_project($projectid, $user)
fetch_line_by_project
update_totaux_add($ligne_total_ht, $ligne_total_tva)
Update total of an expense report when you add a line.
Class to manage inventories.
Class of expense report details lines.
Class to manage inventories.
Class to manage third parties objects (customers, suppliers, prospects...)
Class to manage Dolibarr users.
print $langs trans("Ref").' m titre as m m statut as status
Or an array listing all the potential status of the object: array: int of the status => translated la...
Definition index.php:169
global $mysoc
dol_delete_file($file, $disableglob=0, $nophperrors=0, $nohook=0, $object=null, $allowdotdot=false, $indexdatabase=1, $nolog=0)
Remove a file or several files with a mask.
dol_delete_dir_recursive($dir, $count=0, $nophperrors=0, $onlysub=0, &$countdeleted=0, $indexdatabase=1, $nolog=0, $level=0)
Remove a directory $dir and its subdirectories (or only files and subdirectories)
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:66
dol_delete_preview($object)
Delete all preview files linked to object instance.
dol_now($mode='gmt')
Return date for now.
price2num($amount, $rounding='', $option=0, $currencycode='')
Function that return a number with universal decimal format (decimal separator is '.
dolGetFirstLineOfText($text, $nboflines=1, $charset='UTF-8')
Return first line of text.
dol_strlen($string, $stringencoding='UTF-8', $binarycount=0)
Make a strlen call.
dolBuildUrl($url, $params=[], $addtoken=false, $anchor='')
Return path of url.
isDolTms($timestamp)
isDolTms check if a timestamp is valid.
dol_sanitizeFileName($str, $newstr='_', $unaccent=1, $includequotes=0, $allowdash=0)
Clean a string to use it as a file name.
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.
getDolGlobalInt($key, $default=0)
Return a Dolibarr global constant int value.
getLocalTaxesFromRate($vatrate, $local, $buyer, $seller, $firstparamisid=0)
Get type and rate of localtaxes for a particular vat rate/country of a thirdparty.
dolGetFirstLastname($firstname, $lastname, $nameorder=-1)
Return firstname and lastname in correct order.
GETPOSTINT($paramname, $method=0, $nodefault=0)
Return the value of a $_GET or $_POST supervariable, converted into integer.
dol_buildpath($path, $type=0, $returnemptyifnotfound=0)
Return path of url or filesystem.
dol_print_date($time, $format='', $tzoutput='auto', $outputlangs=null, $encodetooutput=false, $decorate=0)
Output date in a string format according to outputlangs (or langs if not defined).
dol_trunc($string, $size=40, $trunc='right', $stringencoding='UTF-8', $nodot=0, $display=0)
Truncate a string to a particular length adding '...' if string larger than length.
getDolGlobalString($key, $default='')
Return a Dolibarr global constant string value.
dol_syslog($message, $level=LOG_INFO, $ident=0, $suffixinfilename='', $restricttologhandler='', $logcontext=null)
Write log message into outputs.
dol_getdate($timestamp, $fast=false, $forcetimezone='')
Return an array with locale date info.
calcul_price_total($qty, $pu, $remise_percent_ligne, $txtva, $uselocaltax1_rate, $uselocaltax2_rate, $notused, $price_base_type, $info_bits, $type, $seller=null, $localtaxes_array=[], $progress=100, $multicurrency_tx=1, $pu_devise=0, $multicurrency_code='')
Calculate totals (net, vat, ...) of a line.
Definition price.lib.php:90