28require_once DOL_DOCUMENT_ROOT.
'/core/class/commonobject.class.php';
39 public $element =
'holiday';
44 public $table_element =
'holiday';
50 public $ismultientitymanaged = 0;
55 public $fk_element =
'fk_holiday';
60 public $picto =
'holiday';
67 public $date_create =
'';
74 public $date_debut =
'';
75 public $date_fin =
'';
76 public $date_debut_gmt =
'';
77 public $date_fin_gmt =
'';
89 public $date_valid =
'';
94 public $fk_user_valid;
99 public $date_approval;
104 public $fk_user_approve;
109 public $date_refuse =
'';
114 public $fk_user_refuse;
119 public $date_cancel =
'';
124 public $fk_user_cancel;
127 public $detail_refuse =
'';
134 public $holiday = array();
135 public $events = array();
136 public $logs = array();
138 public $optName =
'';
139 public $optValue =
'';
140 public $optRowid =
'';
184 global $langs, $conf;
185 $langs->load(
"order");
187 if (empty($conf->global->HOLIDAY_ADDON)) {
188 $conf->global->HOLIDAY_ADDON =
'mod_holiday_madonna';
191 if (!empty($conf->global->HOLIDAY_ADDON)) {
194 $file = $conf->global->HOLIDAY_ADDON.
".php";
195 $classname = $conf->global->HOLIDAY_ADDON;
198 $dirmodels = array_merge(array(
'/'), (array) $conf->modules_parts[
'models']);
199 foreach ($dirmodels as $reldir) {
203 $mybool |= @include_once $dir.$file;
206 if ($mybool ===
false) {
211 $obj =
new $classname();
212 $numref = $obj->getNextValue($objsoc, $this);
217 $this->error = $obj->error;
222 print $langs->trans(
"Error").
" ".$langs->trans(
"Error_HOLIDAY_ADDON_NotDefined");
246 $this->db->rollback();
258 public function create($user, $notrigger = 0)
266 if (empty($this->fk_user) || !is_numeric($this->fk_user) || $this->fk_user < 0) {
267 $this->error =
"ErrorBadParameterFkUser";
return -1;
269 if (empty($this->fk_validator) || !is_numeric($this->fk_validator) || $this->fk_validator < 0) {
270 $this->error =
"ErrorBadParameterFkValidator";
return -1;
272 if (empty($this->fk_type) || !is_numeric($this->fk_type) || $this->fk_type < 0) {
273 $this->error =
"ErrorBadParameterFkType";
return -1;
277 $sql =
"INSERT INTO ".MAIN_DB_PREFIX.
"holiday(";
280 $sql .=
"date_create,";
281 $sql .=
"description,";
282 $sql .=
"date_debut,";
286 $sql .=
"fk_validator,";
288 $sql .=
"fk_user_create,";
290 $sql .=
") VALUES (";
292 $sql .=
" ".((int) $this->fk_user).
",";
293 $sql .=
" '".$this->db->idate($now).
"',";
294 $sql .=
" '".$this->db->escape($this->
description).
"',";
295 $sql .=
" '".$this->db->idate($this->date_debut).
"',";
296 $sql .=
" '".$this->db->idate($this->date_fin).
"',";
297 $sql .=
" ".((int) $this->halfday).
",";
299 $sql .=
" ".((int) $this->fk_validator).
",";
300 $sql .=
" ".((int) $this->fk_type).
",";
301 $sql .=
" ".((int) $user->id).
",";
302 $sql .=
" ".((int) $conf->entity);
307 dol_syslog(get_class($this).
"::create", LOG_DEBUG);
308 $resql = $this->db->query($sql);
310 $error++; $this->errors[] =
"Error ".$this->db->lasterror();
314 $this->
id = $this->db->last_insert_id(MAIN_DB_PREFIX.
"holiday");
318 $initialref =
'(PROV'.$this->id.
')';
319 if (!empty($this->
ref)) {
320 $initialref = $this->ref;
323 $sql =
'UPDATE '.MAIN_DB_PREFIX.
"holiday SET ref='".$this->db->escape($initialref).
"' WHERE rowid=".((int) $this->
id);
324 if ($this->db->query($sql)) {
325 $this->
ref = $initialref;
334 if (!$error && !$notrigger) {
348 foreach ($this->errors as $errmsg) {
349 dol_syslog(get_class($this).
"::create ".$errmsg, LOG_ERR);
350 $this->error .= ($this->error ?
', '.$errmsg : $errmsg);
352 $this->db->rollback();
368 public function fetch($id, $ref =
'')
373 $sql .=
" cp.rowid,";
375 $sql .=
" cp.fk_user,";
376 $sql .=
" cp.date_create,";
377 $sql .=
" cp.description,";
378 $sql .=
" cp.date_debut,";
379 $sql .=
" cp.date_fin,";
380 $sql .=
" cp.halfday,";
381 $sql .=
" cp.statut,";
382 $sql .=
" cp.fk_validator,";
383 $sql .=
" cp.date_valid,";
384 $sql .=
" cp.fk_user_valid,";
385 $sql .=
" cp.date_approval,";
386 $sql .=
" cp.fk_user_approve,";
387 $sql .=
" cp.date_refuse,";
388 $sql .=
" cp.fk_user_refuse,";
389 $sql .=
" cp.date_cancel,";
390 $sql .=
" cp.fk_user_cancel,";
391 $sql .=
" cp.detail_refuse,";
392 $sql .=
" cp.note_private,";
393 $sql .=
" cp.note_public,";
394 $sql .=
" cp.fk_user_create,";
395 $sql .=
" cp.fk_type,";
396 $sql .=
" cp.entity";
397 $sql .=
" FROM ".MAIN_DB_PREFIX.
"holiday as cp";
399 $sql .=
" WHERE cp.rowid = ".((int) $id);
401 $sql .=
" WHERE cp.ref = '".$this->db->escape($ref).
"'";
404 dol_syslog(get_class($this).
"::fetch", LOG_DEBUG);
405 $resql = $this->db->query($sql);
407 if ($this->db->num_rows($resql)) {
408 $obj = $this->db->fetch_object($resql);
410 $this->
id = $obj->rowid;
411 $this->
ref = ($obj->ref ? $obj->ref : $obj->rowid);
412 $this->fk_user = $obj->fk_user;
413 $this->date_create = $this->db->jdate($obj->date_create);
415 $this->date_debut = $this->db->jdate($obj->date_debut);
416 $this->date_fin = $this->db->jdate($obj->date_fin);
417 $this->date_debut_gmt = $this->db->jdate($obj->date_debut, 1);
418 $this->date_fin_gmt = $this->db->jdate($obj->date_fin, 1);
419 $this->halfday = $obj->halfday;
420 $this->
statut = $obj->statut;
421 $this->fk_validator = $obj->fk_validator;
422 $this->date_valid = $this->db->jdate($obj->date_valid);
423 $this->fk_user_valid = $obj->fk_user_valid;
424 $this->user_validation_id = $obj->fk_user_valid;
425 $this->date_approval = $this->db->jdate($obj->date_approval);
426 $this->fk_user_approve = $obj->fk_user_approve;
427 $this->date_refuse = $this->db->jdate($obj->date_refuse);
428 $this->fk_user_refuse = $obj->fk_user_refuse;
429 $this->date_cancel = $this->db->jdate($obj->date_cancel);
430 $this->fk_user_cancel = $obj->fk_user_cancel;
431 $this->detail_refuse = $obj->detail_refuse;
432 $this->note_private = $obj->note_private;
433 $this->note_public = $obj->note_public;
434 $this->fk_user_create = $obj->fk_user_create;
435 $this->fk_type = $obj->fk_type;
436 $this->entity = $obj->entity;
444 $this->db->free($resql);
448 $this->error =
"Error ".$this->db->lasterror();
463 global $langs, $conf;
466 $sql .=
" cp.rowid,";
469 $sql .=
" cp.fk_user,";
470 $sql .=
" cp.fk_type,";
471 $sql .=
" cp.date_create,";
472 $sql .=
" cp.description,";
473 $sql .=
" cp.date_debut,";
474 $sql .=
" cp.date_fin,";
475 $sql .=
" cp.halfday,";
476 $sql .=
" cp.statut,";
477 $sql .=
" cp.fk_validator,";
478 $sql .=
" cp.date_valid,";
479 $sql .=
" cp.fk_user_valid,";
480 $sql .=
" cp.date_approval,";
481 $sql .=
" cp.fk_user_approve,";
482 $sql .=
" cp.date_refuse,";
483 $sql .=
" cp.fk_user_refuse,";
484 $sql .=
" cp.date_cancel,";
485 $sql .=
" cp.fk_user_cancel,";
486 $sql .=
" cp.detail_refuse,";
488 $sql .=
" uu.lastname as user_lastname,";
489 $sql .=
" uu.firstname as user_firstname,";
490 $sql .=
" uu.login as user_login,";
491 $sql .=
" uu.statut as user_statut,";
492 $sql .=
" uu.photo as user_photo,";
494 $sql .=
" ua.lastname as validator_lastname,";
495 $sql .=
" ua.firstname as validator_firstname,";
496 $sql .=
" ua.login as validator_login,";
497 $sql .=
" ua.statut as validator_statut,";
498 $sql .=
" ua.photo as validator_photo";
500 $sql .=
" FROM ".MAIN_DB_PREFIX.
"holiday as cp, ".MAIN_DB_PREFIX.
"user as uu, ".MAIN_DB_PREFIX.
"user as ua";
501 $sql .=
" WHERE cp.entity IN (".getEntity(
'holiday').
")";
502 $sql .=
" AND cp.fk_user = uu.rowid AND cp.fk_validator = ua.rowid";
503 $sql .=
" AND cp.fk_user IN (".$this->db->sanitize($user_id).
")";
506 if (!empty($filter)) {
511 if (!empty($order)) {
515 dol_syslog(get_class($this).
"::fetchByUser", LOG_DEBUG);
516 $resql = $this->db->query($sql);
521 $tab_result = $this->holiday;
522 $num = $this->db->num_rows($resql);
531 $obj = $this->db->fetch_object($resql);
533 $tab_result[$i][
'rowid'] = $obj->rowid;
534 $tab_result[$i][
'id'] = $obj->rowid;
535 $tab_result[$i][
'ref'] = ($obj->ref ? $obj->ref : $obj->rowid);
537 $tab_result[$i][
'fk_user'] = $obj->fk_user;
538 $tab_result[$i][
'fk_type'] = $obj->fk_type;
539 $tab_result[$i][
'date_create'] = $this->db->jdate($obj->date_create);
540 $tab_result[$i][
'description'] = $obj->description;
541 $tab_result[$i][
'date_debut'] = $this->db->jdate($obj->date_debut);
542 $tab_result[$i][
'date_fin'] = $this->db->jdate($obj->date_fin);
543 $tab_result[$i][
'date_debut_gmt'] = $this->db->jdate($obj->date_debut, 1);
544 $tab_result[$i][
'date_fin_gmt'] = $this->db->jdate($obj->date_fin, 1);
545 $tab_result[$i][
'halfday'] = $obj->halfday;
546 $tab_result[$i][
'statut'] = $obj->statut;
547 $tab_result[$i][
'fk_validator'] = $obj->fk_validator;
548 $tab_result[$i][
'date_valid'] = $this->db->jdate($obj->date_valid);
549 $tab_result[$i][
'fk_user_valid'] = $obj->fk_user_valid;
550 $tab_result[$i][
'date_approval'] = $this->db->jdate($obj->date_approval);
551 $tab_result[$i][
'fk_user_approve'] = $obj->fk_user_approve;
552 $tab_result[$i][
'date_refuse'] = $this->db->jdate($obj->date_refuse);
553 $tab_result[$i][
'fk_user_refuse'] = $obj->fk_user_refuse;
554 $tab_result[$i][
'date_cancel'] = $this->db->jdate($obj->date_cancel);
555 $tab_result[$i][
'fk_user_cancel'] = $obj->fk_user_cancel;
556 $tab_result[$i][
'detail_refuse'] = $obj->detail_refuse;
558 $tab_result[$i][
'user_firstname'] = $obj->user_firstname;
559 $tab_result[$i][
'user_lastname'] = $obj->user_lastname;
560 $tab_result[$i][
'user_login'] = $obj->user_login;
561 $tab_result[$i][
'user_statut'] = $obj->user_statut;
562 $tab_result[$i][
'user_photo'] = $obj->user_photo;
564 $tab_result[$i][
'validator_firstname'] = $obj->validator_firstname;
565 $tab_result[$i][
'validator_lastname'] = $obj->validator_lastname;
566 $tab_result[$i][
'validator_login'] = $obj->validator_login;
567 $tab_result[$i][
'validator_statut'] = $obj->validator_statut;
568 $tab_result[$i][
'validator_photo'] = $obj->validator_photo;
574 $this->holiday = $tab_result;
578 $this->error =
"Error ".$this->db->lasterror();
595 $sql .=
" cp.rowid,";
598 $sql .=
" cp.fk_user,";
599 $sql .=
" cp.fk_type,";
600 $sql .=
" cp.date_create,";
601 $sql .=
" cp.tms as date_update,";
602 $sql .=
" cp.description,";
603 $sql .=
" cp.date_debut,";
604 $sql .=
" cp.date_fin,";
605 $sql .=
" cp.halfday,";
606 $sql .=
" cp.statut,";
607 $sql .=
" cp.fk_validator,";
608 $sql .=
" cp.date_valid,";
609 $sql .=
" cp.fk_user_valid,";
610 $sql .=
" cp.date_approval,";
611 $sql .=
" cp.fk_user_approve,";
612 $sql .=
" cp.date_refuse,";
613 $sql .=
" cp.fk_user_refuse,";
614 $sql .=
" cp.date_cancel,";
615 $sql .=
" cp.fk_user_cancel,";
616 $sql .=
" cp.detail_refuse,";
618 $sql .=
" uu.lastname as user_lastname,";
619 $sql .=
" uu.firstname as user_firstname,";
620 $sql .=
" uu.login as user_login,";
621 $sql .=
" uu.statut as user_statut,";
622 $sql .=
" uu.photo as user_photo,";
624 $sql .=
" ua.lastname as validator_lastname,";
625 $sql .=
" ua.firstname as validator_firstname,";
626 $sql .=
" ua.login as validator_login,";
627 $sql .=
" ua.statut as validator_statut,";
628 $sql .=
" ua.photo as validator_photo";
630 $sql .=
" FROM ".MAIN_DB_PREFIX.
"holiday as cp, ".MAIN_DB_PREFIX.
"user as uu, ".MAIN_DB_PREFIX.
"user as ua";
631 $sql .=
" WHERE cp.entity IN (".getEntity(
'holiday').
")";
632 $sql .=
" AND cp.fk_user = uu.rowid AND cp.fk_validator = ua.rowid ";
635 if (!empty($filter)) {
640 if (!empty($order)) {
644 dol_syslog(get_class($this).
"::fetchAll", LOG_DEBUG);
645 $resql = $this->db->query($sql);
650 $tab_result = $this->holiday;
651 $num = $this->db->num_rows($resql);
660 $obj = $this->db->fetch_object($resql);
662 $tab_result[$i][
'rowid'] = $obj->rowid;
663 $tab_result[$i][
'id'] = $obj->rowid;
664 $tab_result[$i][
'ref'] = ($obj->ref ? $obj->ref : $obj->rowid);
666 $tab_result[$i][
'fk_user'] = $obj->fk_user;
667 $tab_result[$i][
'fk_type'] = $obj->fk_type;
668 $tab_result[$i][
'date_create'] = $this->db->jdate($obj->date_create);
669 $tab_result[$i][
'date_update'] = $this->db->jdate($obj->date_update);
670 $tab_result[$i][
'description'] = $obj->description;
671 $tab_result[$i][
'date_debut'] = $this->db->jdate($obj->date_debut);
672 $tab_result[$i][
'date_fin'] = $this->db->jdate($obj->date_fin);
673 $tab_result[$i][
'date_debut_gmt'] = $this->db->jdate($obj->date_debut, 1);
674 $tab_result[$i][
'date_fin_gmt'] = $this->db->jdate($obj->date_fin, 1);
675 $tab_result[$i][
'halfday'] = $obj->halfday;
676 $tab_result[$i][
'statut'] = $obj->statut;
677 $tab_result[$i][
'fk_validator'] = $obj->fk_validator;
678 $tab_result[$i][
'date_valid'] = $this->db->jdate($obj->date_valid);
679 $tab_result[$i][
'fk_user_valid'] = $obj->fk_user_valid;
680 $tab_result[$i][
'date_approval'] = $this->db->jdate($obj->date_approval);
681 $tab_result[$i][
'fk_user_approve'] = $obj->fk_user_approve;
682 $tab_result[$i][
'date_refuse'] = $obj->date_refuse;
683 $tab_result[$i][
'fk_user_refuse'] = $obj->fk_user_refuse;
684 $tab_result[$i][
'date_cancel'] = $obj->date_cancel;
685 $tab_result[$i][
'fk_user_cancel'] = $obj->fk_user_cancel;
686 $tab_result[$i][
'detail_refuse'] = $obj->detail_refuse;
688 $tab_result[$i][
'user_firstname'] = $obj->user_firstname;
689 $tab_result[$i][
'user_lastname'] = $obj->user_lastname;
690 $tab_result[$i][
'user_login'] = $obj->user_login;
691 $tab_result[$i][
'user_statut'] = $obj->user_statut;
692 $tab_result[$i][
'user_photo'] = $obj->user_photo;
694 $tab_result[$i][
'validator_firstname'] = $obj->validator_firstname;
695 $tab_result[$i][
'validator_lastname'] = $obj->validator_lastname;
696 $tab_result[$i][
'validator_login'] = $obj->validator_login;
697 $tab_result[$i][
'validator_statut'] = $obj->validator_statut;
698 $tab_result[$i][
'validator_photo'] = $obj->validator_photo;
703 $this->holiday = $tab_result;
707 $this->error =
"Error ".$this->db->lasterror();
720 public function validate($user =
null, $notrigger = 0)
722 global $conf, $langs;
723 require_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
726 $checkBalance =
getDictionaryValue(
'c_holiday_types',
'block_if_negative', $this->fk_type);
728 if ($checkBalance > 0) {
729 $balance = $this->
getCPforUser($this->fk_user, $this->fk_type);
732 $this->error =
'LeaveRequestCreationBlockedBecauseBalanceIsNegative';
738 if (!$error && (preg_match(
'/^[\(]?PROV/i', $this->
ref) || empty($this->
ref) || $this->
ref == $this->
id)) {
746 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"holiday SET";
747 $sql .=
" fk_user_valid = ".((int) $user->id).
",";
748 $sql .=
" date_valid = '".$this->db->idate(
dol_now()).
"',";
749 if (!empty($this->
statut) && is_numeric($this->
statut)) {
750 $sql .=
" statut = ".((int) $this->
statut).
",";
752 $this->error =
'Property status must be a numeric value';
755 $sql .=
" ref = '".$this->db->escape($num).
"'";
756 $sql .=
" WHERE rowid = ".((int) $this->
id);
760 dol_syslog(get_class($this).
"::validate", LOG_DEBUG);
761 $resql = $this->db->query($sql);
763 $error++; $this->errors[] =
"Error ".$this->db->lasterror();
769 $result = $this->
call_trigger(
'HOLIDAY_VALIDATE', $user);
778 $this->oldref = $this->ref;
781 if (preg_match(
'/^[\(]?PROV/i', $this->
ref)) {
783 $sql =
'UPDATE ' . MAIN_DB_PREFIX .
"ecm_files set filename = CONCAT('" . $this->db->escape($this->newref) .
"', SUBSTR(filename, " . (strlen($this->
ref) + 1) .
")), filepath = 'holiday/" . $this->db->escape($this->newref) .
"'";
784 $sql .=
" WHERE filename LIKE '" . $this->db->escape($this->
ref) .
"%' AND filepath = 'holiday/" . $this->db->escape($this->
ref) .
"' and entity = " . ((int) $conf->entity);
785 $resql = $this->db->query($sql);
788 $this->error = $this->db->lasterror();
790 $sql =
'UPDATE '.MAIN_DB_PREFIX.
"ecm_files set filepath = 'holiday/".$this->db->escape($this->newref).
"'";
791 $sql .=
" WHERE filepath = 'holiday/".$this->db->escape($this->
ref).
"' and entity = ".$conf->entity;
792 $resql = $this->db->query($sql);
794 $error++; $this->error = $this->db->lasterror();
800 $dirsource = $conf->holiday->multidir_output[$this->entity] .
'/' . $oldref;
801 $dirdest = $conf->holiday->multidir_output[$this->entity] .
'/' . $newref;
802 if (!$error && file_exists($dirsource)) {
803 dol_syslog(get_class($this) .
"::validate rename dir " . $dirsource .
" into " . $dirdest);
804 if (@rename($dirsource, $dirdest)) {
807 $listoffiles =
dol_dir_list($dirdest,
'files', 1,
'^' . preg_quote($oldref,
'/'));
808 foreach ($listoffiles as $fileentry) {
809 $dirsource = $fileentry[
'name'];
810 $dirdest = preg_replace(
'/^' . preg_quote($oldref,
'/') .
'/', $newref, $dirsource);
811 $dirsource = $fileentry[
'path'] .
'/' . $dirsource;
812 $dirdest = $fileentry[
'path'] .
'/' . $dirdest;
813 @rename($dirsource, $dirdest);
823 foreach ($this->errors as $errmsg) {
824 dol_syslog(get_class($this).
"::validate ".$errmsg, LOG_ERR);
825 $this->error .= ($this->error ?
', '.$errmsg : $errmsg);
827 $this->db->rollback();
843 public function approve($user =
null, $notrigger = 0)
845 global $conf, $langs;
848 $checkBalance =
getDictionaryValue(
'c_holiday_types',
'block_if_negative', $this->fk_type);
850 if ($checkBalance > 0) {
851 $balance = $this->
getCPforUser($this->fk_user, $this->fk_type);
854 $this->error =
'LeaveRequestCreationBlockedBecauseBalanceIsNegative';
860 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"holiday SET";
862 $sql .=
" description= '".$this->db->escape($this->
description).
"',";
864 if (!empty($this->date_debut)) {
865 $sql .=
" date_debut = '".$this->db->idate($this->date_debut).
"',";
869 if (!empty($this->date_fin)) {
870 $sql .=
" date_fin = '".$this->db->idate($this->date_fin).
"',";
874 $sql .=
" halfday = ".((int) $this->halfday).
",";
875 if (!empty($this->
statut) && is_numeric($this->
statut)) {
876 $sql .=
" statut = ".((int) $this->
statut).
",";
880 if (!empty($this->fk_validator)) {
881 $sql .=
" fk_validator = ".((int) $this->fk_validator).
",";
885 if (!empty($this->date_valid)) {
886 $sql .=
" date_valid = '".$this->db->idate($this->date_valid).
"',";
888 $sql .=
" date_valid = NULL,";
890 if (!empty($this->fk_user_valid)) {
891 $sql .=
" fk_user_valid = ".((int) $this->fk_user_valid).
",";
893 $sql .=
" fk_user_valid = NULL,";
895 if (!empty($this->date_approval)) {
896 $sql .=
" date_approval = '".$this->db->idate($this->date_approval).
"',";
898 $sql .=
" date_approval = NULL,";
900 if (!empty($this->fk_user_approve)) {
901 $sql .=
" fk_user_approve = ".((int) $this->fk_user_approve).
",";
903 $sql .=
" fk_user_approve = NULL,";
905 if (!empty($this->date_refuse)) {
906 $sql .=
" date_refuse = '".$this->db->idate($this->date_refuse).
"',";
908 $sql .=
" date_refuse = NULL,";
910 if (!empty($this->fk_user_refuse)) {
911 $sql .=
" fk_user_refuse = ".((int) $this->fk_user_refuse).
",";
913 $sql .=
" fk_user_refuse = NULL,";
915 if (!empty($this->date_cancel)) {
916 $sql .=
" date_cancel = '".$this->db->idate($this->date_cancel).
"',";
918 $sql .=
" date_cancel = NULL,";
920 if (!empty($this->fk_user_cancel)) {
921 $sql .=
" fk_user_cancel = ".((int) $this->fk_user_cancel).
",";
923 $sql .=
" fk_user_cancel = NULL,";
925 if (!empty($this->detail_refuse)) {
926 $sql .=
" detail_refuse = '".$this->db->escape($this->detail_refuse).
"'";
928 $sql .=
" detail_refuse = NULL";
930 $sql .=
" WHERE rowid = ".((int) $this->
id);
934 dol_syslog(get_class($this).
"::approve", LOG_DEBUG);
935 $resql = $this->db->query($sql);
937 $error++; $this->errors[] =
"Error ".$this->db->lasterror();
943 $result = $this->
call_trigger(
'HOLIDAY_APPROVE', $user);
953 foreach ($this->errors as $errmsg) {
954 dol_syslog(get_class($this).
"::approve ".$errmsg, LOG_ERR);
955 $this->error .= ($this->error ?
', '.$errmsg : $errmsg);
957 $this->db->rollback();
972 public function update($user =
null, $notrigger = 0)
974 global $conf, $langs;
977 $checkBalance =
getDictionaryValue(
'c_holiday_types',
'block_if_negative', $this->fk_type);
979 if ($checkBalance > 0 && $this->
statut != self::STATUS_DRAFT) {
980 $balance = $this->
getCPforUser($this->fk_user, $this->fk_type);
983 $this->error =
'LeaveRequestCreationBlockedBecauseBalanceIsNegative';
989 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"holiday SET";
991 $sql .=
" description= '".$this->db->escape($this->
description).
"',";
993 if (!empty($this->date_debut)) {
994 $sql .=
" date_debut = '".$this->db->idate($this->date_debut).
"',";
998 if (!empty($this->date_fin)) {
999 $sql .=
" date_fin = '".$this->db->idate($this->date_fin).
"',";
1003 $sql .=
" halfday = ".$this->halfday.
",";
1004 if (!empty($this->
statut) && is_numeric($this->
statut)) {
1005 $sql .=
" statut = ".$this->statut.
",";
1009 if (!empty($this->fk_validator)) {
1010 $sql .=
" fk_validator = '".$this->db->escape($this->fk_validator).
"',";
1014 if (!empty($this->date_valid)) {
1015 $sql .=
" date_valid = '".$this->db->idate($this->date_valid).
"',";
1017 $sql .=
" date_valid = NULL,";
1019 if (!empty($this->fk_user_valid)) {
1020 $sql .=
" fk_user_valid = ".((int) $this->fk_user_valid).
",";
1022 $sql .=
" fk_user_valid = NULL,";
1024 if (!empty($this->date_approval)) {
1025 $sql .=
" date_approval = '".$this->db->idate($this->date_approval).
"',";
1027 $sql .=
" date_approval = NULL,";
1029 if (!empty($this->fk_user_approve)) {
1030 $sql .=
" fk_user_approve = ".((int) $this->fk_user_approve).
",";
1032 $sql .=
" fk_user_approve = NULL,";
1034 if (!empty($this->date_refuse)) {
1035 $sql .=
" date_refuse = '".$this->db->idate($this->date_refuse).
"',";
1037 $sql .=
" date_refuse = NULL,";
1039 if (!empty($this->fk_user_refuse)) {
1040 $sql .=
" fk_user_refuse = ".((int) $this->fk_user_refuse).
",";
1042 $sql .=
" fk_user_refuse = NULL,";
1044 if (!empty($this->date_cancel)) {
1045 $sql .=
" date_cancel = '".$this->db->idate($this->date_cancel).
"',";
1047 $sql .=
" date_cancel = NULL,";
1049 if (!empty($this->fk_user_cancel)) {
1050 $sql .=
" fk_user_cancel = ".((int) $this->fk_user_cancel).
",";
1052 $sql .=
" fk_user_cancel = NULL,";
1054 if (!empty($this->detail_refuse)) {
1055 $sql .=
" detail_refuse = '".$this->db->escape($this->detail_refuse).
"'";
1057 $sql .=
" detail_refuse = NULL";
1060 $sql .=
" WHERE rowid = ".((int) $this->
id);
1064 dol_syslog(get_class($this).
"::update", LOG_DEBUG);
1065 $resql = $this->db->query($sql);
1067 $error++; $this->errors[] =
"Error ".$this->db->lasterror();
1073 $result = $this->
call_trigger(
'HOLIDAY_MODIFY', $user);
1083 foreach ($this->errors as $errmsg) {
1084 dol_syslog(get_class($this).
"::update ".$errmsg, LOG_ERR);
1085 $this->error .= ($this->error ?
', '.$errmsg : $errmsg);
1087 $this->db->rollback();
1090 $this->db->commit();
1103 public function delete($user, $notrigger = 0)
1105 global $conf, $langs;
1108 $sql =
"DELETE FROM ".MAIN_DB_PREFIX.
"holiday";
1109 $sql .=
" WHERE rowid=".((int) $this->
id);
1113 dol_syslog(get_class($this).
"::delete", LOG_DEBUG);
1114 $resql = $this->db->query($sql);
1116 $error++; $this->errors[] =
"Error ".$this->db->lasterror();
1122 $result = $this->
call_trigger(
'HOLIDAY_DELETE', $user);
1132 foreach ($this->errors as $errmsg) {
1133 dol_syslog(get_class($this).
"::delete ".$errmsg, LOG_ERR);
1134 $this->error .= ($this->error ?
', '.$errmsg : $errmsg);
1136 $this->db->rollback();
1139 $this->db->commit();
1161 foreach ($this->holiday as $infos_CP) {
1172 if ($halfday == 0) {
1173 if ($dateStart >= $infos_CP[
'date_debut'] && $dateStart <= $infos_CP[
'date_fin']) {
1176 if ($dateEnd <= $infos_CP[
'date_fin'] && $dateEnd >= $infos_CP[
'date_debut']) {
1179 } elseif ($halfday == -1) {
1181 if ($dateStart >= $infos_CP[
'date_debut'] && $dateStart <= $infos_CP[
'date_fin']) {
1182 if ($dateStart < $infos_CP[
'date_fin'] || in_array($infos_CP[
'halfday'], array(0, -1))) {
1186 if ($dateEnd <= $infos_CP[
'date_fin'] && $dateEnd >= $infos_CP[
'date_debut']) {
1187 if ($dateStart < $dateEnd) {
1190 if ($dateEnd < $infos_CP[
'date_fin'] || in_array($infos_CP[
'halfday'], array(0, -1))) {
1194 } elseif ($halfday == 1) {
1196 if ($dateStart >= $infos_CP[
'date_debut'] && $dateStart <= $infos_CP[
'date_fin']) {
1197 if ($dateStart < $dateEnd) {
1200 if ($dateStart > $infos_CP[
'date_debut'] || in_array($infos_CP[
'halfday'], array(0, 1))) {
1204 if ($dateEnd <= $infos_CP[
'date_fin'] && $dateEnd >= $infos_CP[
'date_debut']) {
1205 if ($dateEnd > $infos_CP[
'date_debut'] || in_array($infos_CP[
'halfday'], array(0, 1))) {
1209 } elseif ($halfday == 2) {
1211 if ($dateStart >= $infos_CP[
'date_debut'] && $dateStart <= $infos_CP[
'date_fin']) {
1212 if ($dateStart < $infos_CP[
'date_fin'] || in_array($infos_CP[
'halfday'], array(0, -1))) {
1216 if ($dateEnd <= $infos_CP[
'date_fin'] && $dateEnd >= $infos_CP[
'date_debut']) {
1217 if ($dateEnd > $infos_CP[
'date_debut'] || in_array($infos_CP[
'halfday'], array(0, 1))) {
1222 dol_print_error(
'',
'Bad value of parameter halfday when calling function verifDateHolidayCP');
1241 global $langs, $conf;
1243 $isavailablemorning =
true;
1244 $isavailableafternoon =
true;
1247 $sql =
"SELECT cp.rowid, cp.date_debut as date_start, cp.date_fin as date_end, cp.halfday, cp.statut";
1248 $sql .=
" FROM ".MAIN_DB_PREFIX.
"holiday as cp";
1249 $sql .=
" WHERE cp.entity IN (".getEntity(
'holiday').
")";
1250 $sql .=
" AND cp.fk_user = ".(int) $fk_user;
1251 $sql .=
" AND cp.date_debut <= '".$this->db->idate($timestamp).
"' AND cp.date_fin >= '".$this->db->idate($timestamp).
"'";
1252 if ($status !=
'-1') {
1253 $sql .=
" AND cp.statut IN (".$this->db->sanitize($status).
")";
1256 $resql = $this->db->query($sql);
1258 $num_rows = $this->db->num_rows($resql);
1259 if ($num_rows > 0) {
1260 $arrayofrecord = array();
1262 while ($i < $num_rows) {
1263 $obj = $this->db->fetch_object($resql);
1266 $arrayofrecord[$obj->rowid] = array(
'date_start'=>$this->db->jdate($obj->date_start),
'date_end'=>$this->db->jdate($obj->date_end),
'halfday'=>$obj->halfday);
1271 $isavailablemorning =
true;
1272 foreach ($arrayofrecord as $record) {
1273 if ($timestamp == $record[
'date_start'] && $record[
'halfday'] == 2) {
1276 if ($timestamp == $record[
'date_start'] && $record[
'halfday'] == -1) {
1279 $isavailablemorning =
false;
1282 $isavailableafternoon =
true;
1283 foreach ($arrayofrecord as $record) {
1284 if ($timestamp == $record[
'date_end'] && $record[
'halfday'] == 2) {
1287 if ($timestamp == $record[
'date_end'] && $record[
'halfday'] == 1) {
1290 $isavailableafternoon =
false;
1298 $result = array(
'morning'=>$isavailablemorning,
'afternoon'=>$isavailableafternoon);
1299 if (!$isavailablemorning) {
1300 $result[
'morning_reason'] =
'leave_request';
1302 if (!$isavailableafternoon) {
1303 $result[
'afternoon_reason'] =
'leave_request';
1317 global $conf, $langs;
1319 $langs->load(
'holiday');
1320 $nofetch = !empty($params[
'nofetch']);
1323 $datas[
'picto'] =
img_picto(
'', $this->picto).
' <u class="paddingrightonly">'.$langs->trans(
"Holiday").
'</u>';
1324 if (isset($this->
statut)) {
1325 $datas[
'picto'] .=
' '.$this->getLibStatut(5);
1327 $datas[
'ref'] =
'<br><b>'.$langs->trans(
'Ref').
':</b> '.$this->ref;
1329 if (!$nofetch && !empty($this->fk_type)) {
1330 $typeleaves = $this->
getTypes(1, -1);
1331 $labeltoshow = (($typeleaves[$this->fk_type][
'code'] && $langs->trans($typeleaves[$this->fk_type][
'code']) != $typeleaves[$this->fk_type][
'code']) ? $langs->trans($typeleaves[$this->fk_type][
'code']) : $typeleaves[$this->fk_type][
'label']);
1332 $datas[
'type'] =
'<br><b>'.$langs->trans(
"Type") .
':</b> ' . (empty($labeltoshow) ? $langs->trans(
"TypeWasDisabledOrRemoved", $this->fk_type) : $labeltoshow);
1334 if (isset($this->halfday) && !empty($this->date_debut) && !empty($this->date_fin)) {
1335 $listhalfday = array(
1336 'morning' => $langs->trans(
"Morning"),
1337 "afternoon" => $langs->trans(
"Afternoon")
1339 $starthalfday = ($this->halfday == -1 || $this->halfday == 2) ?
'afternoon' :
'morning';
1340 $endhalfday = ($this->halfday == 1 || $this->halfday == 2) ?
'morning' :
'afternoon';
1341 $datas[
'date_start'] =
'<br><b>'.$langs->trans(
'DateDebCP') .
'</b>: '.
dol_print_date($this->date_debut,
'day') .
' <span class="opacitymedium">'.$langs->trans($listhalfday[$starthalfday]).
'</span>';
1342 $datas[
'date_end'] =
'<br><b>'.$langs->trans(
'DateFinCP') .
'</b>: '.
dol_print_date($this->date_fin,
'day') .
' <span class="opacitymedium">'.$langs->trans($listhalfday[$endhalfday]).
'</span>';
1358 public function getNomUrl($withpicto = 0, $save_lastsearch_value = -1, $notooltip = 0, $morecss =
'')
1360 global $conf, $langs, $hookmanager;
1362 if (!empty($conf->dol_no_mouse_hover)) {
1369 'objecttype' => $this->element,
1372 $classfortooltip =
'classfortooltip';
1375 $classfortooltip =
'classforajaxtooltip';
1376 $dataparams =
' data-params="'.dol_escape_htmltag(json_encode($params)).
'"';
1382 $url = DOL_URL_ROOT.
'/holiday/card.php?id='.$this->id;
1387 $add_save_lastsearch_values = ($save_lastsearch_value == 1 ? 1 : 0);
1388 if ($save_lastsearch_value == -1 && preg_match(
'/list\.php/', $_SERVER[
"PHP_SELF"])) {
1389 $add_save_lastsearch_values = 1;
1391 if ($add_save_lastsearch_values) {
1392 $url .=
'&save_lastsearch_values=1';
1397 if (empty($notooltip)) {
1399 $label = $langs->trans(
"ShowMyObject");
1400 $linkclose .=
' alt="'.dol_escape_htmltag($label, 1).
'"';
1402 $linkclose .= ($label ?
' title="'.dol_escape_htmltag($label, 1).
'"' :
' title="tocomplete"');
1403 $linkclose .= $dataparams.
' class="'.$classfortooltip.($morecss ?
' '.$morecss :
'').
'"';
1405 $linkclose = ($morecss ?
' class="'.$morecss.
'"' :
'');
1408 $linkstart =
'<a href="'.$url.
'"';
1409 $linkstart .= $linkclose.
'>';
1412 $result .= $linkstart;
1415 $result .=
img_object(($notooltip ?
'' : $label), ($this->picto ? $this->picto :
'generic'), ($notooltip ? (($withpicto != 2) ?
'class="paddingright"' :
'') :
'class="'.(($withpicto != 2) ?
'paddingright ' :
'').
'"'), 0, 0, $notooltip ? 0 : 1);
1417 if ($withpicto != 2) {
1418 $result .= $this->ref;
1420 $result .= $linkend;
1423 $hookmanager->initHooks(array($this->element .
'dao'));
1424 $parameters = array(
'id'=>$this->
id,
'getnomurl' => &$result);
1425 $reshook = $hookmanager->executeHooks(
'getNomUrl', $parameters, $this, $action);
1427 $result = $hookmanager->resPrint;
1429 $result .= $hookmanager->resPrint;
1455 public function LibStatut($status, $mode = 0, $startdate =
'')
1460 if (empty($this->labelStatus) || empty($this->labelStatusShort)) {
1468 $this->labelStatusShort[
self::STATUS_DRAFT] = $langs->transnoentitiesnoconv(
'DraftCP');
1476 $statusType =
'status6';
1477 if (!empty($startdate) && $startdate >=
dol_now()) {
1478 $statusType =
'status4';
1479 $params = array(
'tooltip'=>$this->labelStatus[$status].
' - '.$langs->trans(
"Forthcoming"));
1481 if ($status == self::STATUS_DRAFT) {
1482 $statusType =
'status0';
1484 if ($status == self::STATUS_VALIDATED) {
1485 $statusType =
'status1';
1487 if ($status == self::STATUS_CANCELED) {
1488 $statusType =
'status5';
1490 if ($status == self::STATUS_REFUSED) {
1491 $statusType =
'status5';
1494 return dolGetStatus($this->labelStatus[$status], $this->labelStatusShort[$status],
'', $statusType, $mode,
'', $params);
1506 public function selectStatutCP($selected =
'', $htmlname =
'select_statut', $morecss =
'minwidth125')
1511 $name = array(
'DraftCP',
'ToReviewCP',
'ApprovedCP',
'CancelCP',
'RefuseCP');
1512 $nb = count($name) + 1;
1515 $out =
'<select name="'.$htmlname.
'" id="'.$htmlname.
'" class="flat'.($morecss ?
' '.$morecss :
'').
'">'.
"\n";
1516 $out .=
'<option value="-1"> </option>'.
"\n";
1519 for ($i = 1; $i < $nb; $i++) {
1520 if ($i == $selected) {
1521 $out .=
'<option value="'.$i.
'" selected>'.$langs->trans($name[$i - 1]).
'</option>'.
"\n";
1523 $out .=
'<option value="'.$i.
'">'.$langs->trans($name[$i - 1]).
'</option>'.
"\n";
1527 $out .=
'</select>'.
"\n";
1530 $out .=
ajax_combobox($htmlname, array(), 0, 0,
'resolve', ($showempty < 0 ? (
string) $showempty :
'-1'), $morecss);
1545 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"holiday_config SET";
1546 $sql .=
" value = '".$this->db->escape($value).
"'";
1547 $sql .=
" WHERE name = '".$this->db->escape($name).
"'";
1549 dol_syslog(get_class($this).
'::updateConfCP name='.$name, LOG_DEBUG);
1550 $result = $this->db->query($sql);
1568 $sql =
"SELECT value";
1569 $sql .=
" FROM ".MAIN_DB_PREFIX.
"holiday_config";
1570 $sql .=
" WHERE name = '".$this->db->escape($name).
"'";
1572 dol_syslog(get_class($this).
'::getConfCP name='.$name.
' createifnotfound='.$createifnotfound, LOG_DEBUG);
1573 $result = $this->db->query($sql);
1576 $obj = $this->db->fetch_object($result);
1579 if ($createifnotfound) {
1580 $sql =
"INSERT INTO ".MAIN_DB_PREFIX.
"holiday_config(name, value)";
1581 $sql .=
" VALUES('".$this->db->escape($name).
"', '".$this->db->escape($createifnotfound).
"')";
1582 $result = $this->db->query($sql);
1584 return $createifnotfound;
1586 $this->error = $this->db->lasterror();
1597 $this->error = $this->db->lasterror();
1612 global $user, $langs;
1616 if (empty($userID) && empty($nbHoliday) && empty($fk_type)) {
1617 $langs->load(
"holiday");
1622 $month = date(
'm', $now);
1626 $lastUpdate = $this->
getConfCP(
'lastUpdate', $newdateforlastupdate);
1627 $monthLastUpdate = $lastUpdate[4].$lastUpdate[5];
1631 if ($month != $monthLastUpdate) {
1634 $users = $this->
fetchUsers(
false,
false,
' AND u.statut > 0');
1635 $nbUser = count($users);
1637 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"holiday_config SET";
1638 $sql .=
" value = '".$this->db->escape($newdateforlastupdate).
"'";
1639 $sql .=
" WHERE name = 'lastUpdate'";
1640 $result = $this->db->query($sql);
1642 $typeleaves = $this->
getTypes(1, 1);
1645 foreach ($users as $userCounter) {
1646 $nbDaysToAdd = (isset($typeleaves[$userCounter[
'type']][
'newbymonth']) ? $typeleaves[$userCounter[
'type']][
'newbymonth'] : 0);
1647 if (empty($nbDaysToAdd)) {
1651 dol_syslog(
"We update leave type id ".$userCounter[
'type'].
" for user id ".$userCounter[
'rowid'], LOG_DEBUG);
1653 $nowHoliday = $userCounter[
'nb_holiday'];
1654 $newSolde = $nowHoliday + $nbDaysToAdd;
1657 $this->
addLogCP($user->id, $userCounter[
'rowid'], $langs->trans(
'HolidaysMonthlyUpdate'), $newSolde, $userCounter[
'type']);
1659 $result = $this->
updateSoldeCP($userCounter[
'rowid'], $newSolde, $userCounter[
'type']);
1668 $this->db->commit();
1671 $this->db->rollback();
1681 $sql =
"SELECT nb_holiday FROM ".MAIN_DB_PREFIX.
"holiday_users";
1682 $sql .=
" WHERE fk_user = ".(int) $userID.
" AND fk_type = ".(
int) $fk_type;
1683 $resql = $this->db->query($sql);
1685 $num = $this->db->num_rows($resql);
1689 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"holiday_users SET";
1690 $sql .=
" nb_holiday = ".((float) $nbHoliday);
1691 $sql .=
" WHERE fk_user = ".(int) $userID.
" AND fk_type = ".(
int) $fk_type;
1692 $result = $this->db->query($sql);
1695 $this->errors[] = $this->db->lasterror();
1699 $sql =
"INSERT INTO ".MAIN_DB_PREFIX.
"holiday_users(nb_holiday, fk_user, fk_type) VALUES (";
1700 $sql .= ((float) $nbHoliday);
1701 $sql .=
", ".(int) $userID.
", ".(
int) $fk_type.
")";
1702 $result = $this->db->query($sql);
1705 $this->errors[] = $this->db->lasterror();
1709 $this->errors[] = $this->db->lasterror();
1732 dol_syslog(get_class($this).
'::createCPusers');
1733 $arrayofusers = $this->
fetchUsers(
false,
true);
1735 foreach ($arrayofusers as $users) {
1736 $sql =
"INSERT INTO ".MAIN_DB_PREFIX.
"holiday_users";
1737 $sql .=
" (fk_user, nb_holiday)";
1738 $sql .=
" VALUES (".((int) $users[
'rowid']).
"', '0')";
1740 $resql = $this->db->query($sql);
1746 $sql =
"INSERT INTO ".MAIN_DB_PREFIX.
"holiday_users";
1747 $sql .=
" (fk_user, nb_holiday)";
1748 $sql .=
" VALUES (".((int) $userid).
"', '0')";
1750 $resql = $this->db->query($sql);
1766 $sql =
"SELECT nb_holiday";
1767 $sql .=
" FROM ".MAIN_DB_PREFIX.
"holiday_users";
1768 $sql .=
" WHERE fk_user = ".(int) $user_id;
1770 $sql .=
" AND fk_type = ".(int) $fk_type;
1773 dol_syslog(get_class($this).
'::getCPforUser user_id='.$user_id.
' type_id='.$fk_type, LOG_DEBUG);
1774 $result = $this->db->query($sql);
1776 $obj = $this->db->fetch_object($result);
1779 return $obj->nb_holiday;
1796 public function fetchUsers($stringlist =
true, $type =
true, $filters =
'')
1800 dol_syslog(get_class($this).
"::fetchUsers", LOG_DEBUG);
1806 if (isModEnabled(
'multicompany') && !empty($conf->global->MULTICOMPANY_TRANSVERSE_MODE)) {
1807 $sql .=
" DISTINCT";
1810 $sql .=
" FROM ".MAIN_DB_PREFIX.
"user as u";
1812 if (isModEnabled(
'multicompany') && !empty($conf->global->MULTICOMPANY_TRANSVERSE_MODE)) {
1813 $sql .=
", ".MAIN_DB_PREFIX.
"usergroup_user as ug";
1814 $sql .=
" WHERE ((ug.fk_user = u.rowid";
1815 $sql .=
" AND ug.entity IN (".getEntity(
'usergroup').
"))";
1816 $sql .=
" OR u.entity = 0)";
1818 $sql .=
" WHERE u.entity IN (".getEntity(
'user').
")";
1820 $sql .=
" AND u.statut > 0";
1821 $sql .=
" AND u.employee = 1";
1826 $resql = $this->db->query($sql);
1831 $num = $this->db->num_rows($resql);
1836 $obj = $this->db->fetch_object($resql);
1839 $stringlist .= $obj->rowid;
1841 $stringlist .=
', '.$obj->rowid;
1850 $this->error =
"Error ".$this->db->lasterror();
1855 $sql =
"SELECT DISTINCT cpu.fk_user";
1856 $sql .=
" FROM ".MAIN_DB_PREFIX.
"holiday_users as cpu, ".MAIN_DB_PREFIX.
"user as u";
1857 $sql .=
" WHERE cpu.fk_user = u.rowid";
1862 $resql = $this->db->query($sql);
1867 $num = $this->db->num_rows($resql);
1872 $obj = $this->db->fetch_object($resql);
1875 $stringlist .= $obj->fk_user;
1877 $stringlist .=
', '.$obj->fk_user;
1886 $this->error =
"Error ".$this->db->lasterror();
1896 if (isModEnabled(
'multicompany') && !empty($conf->global->MULTICOMPANY_TRANSVERSE_MODE)) {
1897 $sql .=
" DISTINCT";
1899 $sql .=
" u.rowid, u.lastname, u.firstname, u.gender, u.photo, u.employee, u.statut, u.fk_user";
1900 $sql .=
" FROM ".MAIN_DB_PREFIX.
"user as u";
1902 if (isModEnabled(
'multicompany') && !empty($conf->global->MULTICOMPANY_TRANSVERSE_MODE)) {
1903 $sql .=
", ".MAIN_DB_PREFIX.
"usergroup_user as ug";
1904 $sql .=
" WHERE ((ug.fk_user = u.rowid";
1905 $sql .=
" AND ug.entity IN (".getEntity(
'usergroup').
"))";
1906 $sql .=
" OR u.entity = 0)";
1908 $sql .=
" WHERE u.entity IN (".getEntity(
'user').
")";
1911 $sql .=
" AND u.statut > 0";
1912 $sql .=
" AND u.employee = 1";
1917 $resql = $this->db->query($sql);
1922 $tab_result = $this->holiday;
1923 $num = $this->db->num_rows($resql);
1927 $obj = $this->db->fetch_object($resql);
1929 $tab_result[$i][
'rowid'] = $obj->rowid;
1930 $tab_result[$i][
'id'] = $obj->rowid;
1931 $tab_result[$i][
'name'] = $obj->lastname;
1932 $tab_result[$i][
'lastname'] = $obj->lastname;
1933 $tab_result[$i][
'firstname'] = $obj->firstname;
1934 $tab_result[$i][
'gender'] = $obj->gender;
1935 $tab_result[$i][
'status'] = $obj->statut;
1936 $tab_result[$i][
'employee'] = $obj->employee;
1937 $tab_result[$i][
'photo'] = $obj->photo;
1938 $tab_result[$i][
'fk_user'] = $obj->fk_user;
1948 $this->errors[] =
"Error ".$this->db->lasterror();
1953 $sql =
"SELECT cpu.fk_type, cpu.nb_holiday, u.rowid, u.lastname, u.firstname, u.gender, u.photo, u.employee, u.statut, u.fk_user";
1954 $sql .=
" FROM ".MAIN_DB_PREFIX.
"holiday_users as cpu, ".MAIN_DB_PREFIX.
"user as u";
1955 $sql .=
" WHERE cpu.fk_user = u.rowid";
1960 $resql = $this->db->query($sql);
1965 $tab_result = $this->holiday;
1966 $num = $this->db->num_rows($resql);
1970 $obj = $this->db->fetch_object($resql);
1972 $tab_result[$i][
'rowid'] = $obj->rowid;
1973 $tab_result[$i][
'id'] = $obj->rowid;
1974 $tab_result[$i][
'name'] = $obj->lastname;
1975 $tab_result[$i][
'lastname'] = $obj->lastname;
1976 $tab_result[$i][
'firstname'] = $obj->firstname;
1977 $tab_result[$i][
'gender'] = $obj->gender;
1978 $tab_result[$i][
'status'] = $obj->statut;
1979 $tab_result[$i][
'employee'] = $obj->employee;
1980 $tab_result[$i][
'photo'] = $obj->photo;
1981 $tab_result[$i][
'fk_user'] = $obj->fk_user;
1983 $tab_result[$i][
'type'] = $obj->fk_type;
1984 $tab_result[$i][
'nb_holiday'] = $obj->nb_holiday;
1992 $this->error =
"Error ".$this->db->lasterror();
2010 $users_validator = array();
2012 $sql =
"SELECT DISTINCT ur.fk_user";
2013 $sql .=
" FROM ".MAIN_DB_PREFIX.
"user_rights as ur, ".MAIN_DB_PREFIX.
"rights_def as rd";
2014 $sql .=
" WHERE ur.fk_id = rd.id and rd.module = 'holiday' AND rd.perms = 'approve'";
2016 $sql .=
" SELECT DISTINCT ugu.fk_user";
2017 $sql .=
" FROM ".MAIN_DB_PREFIX.
"usergroup_user as ugu, ".MAIN_DB_PREFIX.
"usergroup_rights as ur, ".MAIN_DB_PREFIX.
"rights_def as rd";
2018 $sql .=
" WHERE ugu.fk_usergroup = ur.fk_usergroup AND ur.fk_id = rd.id and rd.module = 'holiday' AND rd.perms = 'approve'";
2021 dol_syslog(get_class($this).
"::fetch_users_approver_holiday sql=".$sql);
2022 $result = $this->db->query($sql);
2024 $num_rows = $this->db->num_rows($result); $i = 0;
2025 while ($i < $num_rows) {
2026 $objp = $this->db->fetch_object($result);
2027 array_push($users_validator, $objp->fk_user);
2030 return $users_validator;
2032 $this->error = $this->db->lasterror();
2033 dol_syslog(get_class($this).
"::fetch_users_approver_holiday Error ".$this->error, LOG_ERR);
2046 $sql =
"SELECT count(u.rowid) as compteur";
2047 $sql .=
" FROM ".MAIN_DB_PREFIX.
"user as u";
2048 $sql .=
" WHERE u.statut > 0";
2050 $result = $this->db->query($sql);
2051 $objet = $this->db->fetch_object($result);
2053 return $objet->compteur;
2063 $sql =
"SELECT count(u.rowid) as compteur";
2064 $sql .=
" FROM ".MAIN_DB_PREFIX.
"user as u LEFT OUTER JOIN ".MAIN_DB_PREFIX.
"holiday_users hu ON (hu.fk_user=u.rowid)";
2065 $sql .=
" WHERE u.statut > 0 AND hu.fk_user IS NULL";
2067 $result = $this->db->query($sql);
2068 $objet = $this->db->fetch_object($result);
2070 return $objet->compteur;
2082 if (empty($userCP)) {
2085 dol_syslog(get_class($this).
'::verifNbUsers userDolibarr='.$userDolibarrWithoutCP.
' userCP='.$userCP);
2100 public function addLogCP($fk_user_action, $fk_user_update, $label, $new_solde, $fk_type)
2102 global $conf, $langs;
2110 if ($prev_solde == $new_solde) {
2117 $sql =
"INSERT INTO ".MAIN_DB_PREFIX.
"holiday_logs (";
2118 $sql .=
"date_action,";
2119 $sql .=
"fk_user_action,";
2120 $sql .=
"fk_user_update,";
2121 $sql .=
"type_action,";
2122 $sql .=
"prev_solde,";
2123 $sql .=
"new_solde,";
2125 $sql .=
") VALUES (";
2126 $sql .=
" '".$this->db->idate(
dol_now()).
"',";
2127 $sql .=
" ".((int) $fk_user_action).
",";
2128 $sql .=
" ".((int) $fk_user_update).
",";
2129 $sql .=
" '".$this->db->escape($label).
"',";
2130 $sql .=
" ".((float) $prev_solde).
",";
2131 $sql .=
" ".((float) $new_solde).
",";
2132 $sql .=
" ".((int) $fk_type);
2135 $resql = $this->db->query($sql);
2137 $error++; $this->errors[] =
"Error ".$this->db->lasterror();
2141 $this->optRowid = $this->db->last_insert_id(MAIN_DB_PREFIX.
"holiday_logs");
2146 foreach ($this->errors as $errmsg) {
2147 dol_syslog(get_class($this).
"::addLogCP ".$errmsg, LOG_ERR);
2148 $this->error .= ($this->error ?
', '.$errmsg : $errmsg);
2150 $this->db->rollback();
2153 $this->db->commit();
2154 return $this->optRowid;
2168 $sql .=
" cpl.rowid,";
2169 $sql .=
" cpl.date_action,";
2170 $sql .=
" cpl.fk_user_action,";
2171 $sql .=
" cpl.fk_user_update,";
2172 $sql .=
" cpl.type_action,";
2173 $sql .=
" cpl.prev_solde,";
2174 $sql .=
" cpl.new_solde,";
2175 $sql .=
" cpl.fk_type";
2176 $sql .=
" FROM ".MAIN_DB_PREFIX.
"holiday_logs as cpl";
2177 $sql .=
" WHERE cpl.rowid > 0";
2180 if (!empty($filter)) {
2181 $sql .=
" ".$filter;
2185 if (!empty($order)) {
2189 dol_syslog(get_class($this).
"::fetchLog", LOG_DEBUG);
2190 $resql = $this->db->query($sql);
2195 $tab_result = $this->logs;
2196 $num = $this->db->num_rows($resql);
2205 $obj = $this->db->fetch_object($resql);
2207 $tab_result[$i][
'rowid'] = $obj->rowid;
2208 $tab_result[$i][
'id'] = $obj->rowid;
2209 $tab_result[$i][
'date_action'] = $obj->date_action;
2210 $tab_result[$i][
'fk_user_action'] = $obj->fk_user_action;
2211 $tab_result[$i][
'fk_user_update'] = $obj->fk_user_update;
2212 $tab_result[$i][
'type_action'] = $obj->type_action;
2213 $tab_result[$i][
'prev_solde'] = $obj->prev_solde;
2214 $tab_result[$i][
'new_solde'] = $obj->new_solde;
2215 $tab_result[$i][
'fk_type'] = $obj->fk_type;
2220 $this->logs = $tab_result;
2224 $this->error =
"Error ".$this->db->lasterror();
2241 $sql =
"SELECT rowid, code, label, affect, delay, newbymonth";
2242 $sql .=
" FROM ".MAIN_DB_PREFIX.
"c_holiday_types";
2243 $sql .=
" WHERE (fk_country IS NULL OR fk_country = ".((int) $mysoc->country_id).
')';
2245 $sql .=
" AND active = ".((int) $active);
2248 $sql .=
" AND affect = ".((int) $affect);
2250 $sql .=
" ORDER BY sortorder";
2252 $result = $this->db->query($sql);
2254 $num = $this->db->num_rows($result);
2256 while ($obj = $this->db->fetch_object($result)) {
2257 $types[$obj->rowid] = array(
'id'=> $obj->rowid,
'rowid'=> $obj->rowid,
'code'=> $obj->code,
'label'=>$obj->label,
'affect'=>$obj->affect,
'delay'=>$obj->delay,
'newbymonth'=>$obj->newbymonth);
2280 $sql =
"SELECT f.rowid, f.statut as status,";
2281 $sql .=
" f.date_create as datec,";
2282 $sql .=
" f.tms as date_modification,";
2283 $sql .=
" f.date_valid as datev,";
2284 $sql .=
" f.date_approval as datea,";
2285 $sql .=
" f.date_refuse as dater,";
2286 $sql .=
" f.fk_user_create as fk_user_creation,";
2287 $sql .=
" f.fk_user_modif as fk_user_modification,";
2288 $sql .=
" f.fk_user_valid as fk_user_validation,";
2289 $sql .=
" f.fk_user_approve as fk_user_approval_done,";
2290 $sql .=
" f.fk_validator as fk_user_approval_expected,";
2291 $sql .=
" f.fk_user_refuse as fk_user_refuse";
2292 $sql .=
" FROM ".MAIN_DB_PREFIX.
"holiday as f";
2293 $sql .=
" WHERE f.rowid = ".((int) $id);
2294 $sql .=
" AND f.entity = ".$conf->entity;
2296 $resql = $this->db->query($sql);
2298 if ($this->db->num_rows($resql)) {
2299 $obj = $this->db->fetch_object($resql);
2301 $this->
id = $obj->rowid;
2303 $this->date_creation = $this->db->jdate($obj->datec);
2304 $this->date_modification = $this->db->jdate($obj->date_modification);
2305 $this->date_validation = $this->db->jdate($obj->datev);
2306 $this->date_approval = $this->db->jdate($obj->datea);
2308 if (!empty($obj->fk_user_creation)) {
2309 $cuser =
new User($this->db);
2310 $cuser->fetch($obj->fk_user_creation);
2311 $this->user_creation = $cuser;
2313 if (!empty($obj->fk_user_valid)) {
2314 $vuser =
new User($this->db);
2315 $vuser->fetch($obj->fk_user_valid);
2316 $this->user_validation = $vuser;
2318 if (!empty($obj->fk_user_modification)) {
2319 $muser =
new User($this->db);
2320 $muser->fetch($obj->fk_user_modification);
2321 $this->user_modification = $muser;
2325 if ($obj->fk_user_approval_done) {
2326 $auser =
new User($this->db);
2327 $auser->fetch($obj->fk_user_approval_done);
2328 $this->user_approve = $auser;
2332 $this->db->free($resql);
2348 global $user, $langs;
2352 $this->specimen = 1;
2354 $this->fk_user = $user->id;
2356 $this->date_debut =
dol_now();
2357 $this->date_fin =
dol_now() + (24 * 3600);
2358 $this->date_valid =
dol_now();
2359 $this->fk_validator = $user->id;
2376 $this->nb = array();
2378 $sql =
"SELECT count(h.rowid) as nb";
2379 $sql .=
" FROM ".MAIN_DB_PREFIX.
"holiday as h";
2380 $sql .=
" WHERE h.statut > 1";
2381 $sql .=
" AND h.entity IN (".getEntity(
'holiday').
")";
2382 if (empty($user->rights->expensereport->readall)) {
2383 $userchildids = $user->getAllChildIds(1);
2384 $sql .=
" AND (h.fk_user IN (".$this->db->sanitize(join(
',', $userchildids)).
")";
2385 $sql .=
" OR h.fk_validator IN (".$this->db->sanitize(join(
',', $userchildids)).
"))";
2388 $resql = $this->db->query($sql);
2390 while ($obj = $this->db->fetch_object($resql)) {
2391 $this->nb[
"holidays"] = $obj->nb;
2393 $this->db->free($resql);
2397 $this->error = $this->db->error();
2412 global $conf, $langs;
2420 $sql =
"SELECT h.rowid, h.date_debut";
2421 $sql .=
" FROM ".MAIN_DB_PREFIX.
"holiday as h";
2422 $sql .=
" WHERE h.statut = 2";
2423 $sql .=
" AND h.entity IN (".getEntity(
'holiday').
")";
2424 if (empty($user->rights->expensereport->read_all)) {
2425 $userchildids = $user->getAllChildIds(1);
2426 $sql .=
" AND (h.fk_user IN (".$this->db->sanitize(join(
',', $userchildids)).
")";
2427 $sql .=
" OR h.fk_validator IN (".$this->db->sanitize(join(
',', $userchildids)).
"))";
2430 $resql = $this->db->query($sql);
2432 $langs->load(
"members");
2435 $response->warning_delay = $conf->holiday->approve->warning_delay / 60 / 60 / 24;
2436 $response->label = $langs->trans(
"HolidaysToApprove");
2437 $response->labelShort = $langs->trans(
"ToApprove");
2438 $response->url = DOL_URL_ROOT.
'/holiday/list.php?search_status=2&mainmenu=hrm&leftmenu=holiday';
2441 while ($obj = $this->db->fetch_object($resql)) {
2442 $response->nbtodo++;
2444 if ($this->db->jdate($obj->date_debut) < ($now - $conf->holiday->approve->warning_delay)) {
2445 $response->nbtodolate++;
2452 $this->error = $this->db->error();
2467 $selected = (empty($arraydata[
'selected']) ? 0 : $arraydata[
'selected']);
2469 $return =
'<div class="box-flex-item box-flex-grow-zero">';
2470 $return .=
'<div class="info-box info-box-sm">';
2471 $return .=
'<span class="info-box-icon bg-infobox-action">';
2473 $return .=
'</span>';
2474 $return .=
'<div class="info-box-content">';
2475 $return .=
'<span class="info-box-ref inline-block tdoverflowmax150 valignmiddle">'.$arraydata[
'user']->getNomUrl(-1).
'</span>';
2476 $return .=
'<input id="cb'.$this->id.
'" class="flat checkforselect fright" type="checkbox" name="toselect[]" value="'.$this->
id.
'"'.($selected ?
' checked="checked"' :
'').
'>';
2477 if (property_exists($this,
'fk_type')) {
2480 $return .=
'<div class="info_box-label tdoverflowmax100" title="'.dol_escape_htmltag($arraydata[
'labeltype']).
'">'.
dol_escape_htmltag($arraydata[
'labeltype']).
'</div>';
2482 if (property_exists($this,
'date_debut') && property_exists($this,
'date_fin')) {
2483 $return .=
'<span class="info-box-label small">'.dol_print_date($this->date_debut,
'day').
'</span>';
2484 $return .=
' <span class="opacitymedium small">'.$langs->trans(
"To").
'</span> ';
2485 $return .=
'<span class="info-box-label small">'.dol_print_date($this->date_fin,
'day').
'</span>';
2486 if (!empty($arraydata[
'nbopenedday'])) {
2487 $return .=
' ('.$arraydata[
'nbopenedday'].
')';
2490 if (method_exists($this,
'getLibStatut')) {
2491 $return .=
'<div class="info-box-status margintoponly">'.$this->getLibStatut(3).
'</div>';
2493 $return .=
'</div>';
2494 $return .=
'</div>';
2495 $return .=
'</div>';
ajax_combobox($htmlname, $events=array(), $minLengthToAutocomplete=0, $forcefocus=0, $widthTypeOfAutocomplete='resolve', $idforemptyvalue='-1', $morecss='')
Convert a html select field into an ajax combobox.
Parent class of all other business classes (invoices, contracts, proposals, orders,...
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...
insertExtraFields($trigger='', $userused=null)
Add/Update all extra fields values for the current object.
call_trigger($triggerName, $user)
Call trigger based on this instance.
Class of the module paid holiday.
getTypes($active=-1, $affect=-1)
Return array with list of types.
getNomUrl($withpicto=0, $save_lastsearch_value=-1, $notooltip=0, $morecss='')
Return clicable name (with picto eventually)
verifDateHolidayCP($fk_user, $dateStart, $dateEnd, $halfday=0)
Check if a user is on holiday (partially or completely) into a period.
validate($user=null, $notrigger=0)
Validate leave request.
info($id)
Load information on object.
updateBalance()
Update balance of vacations and check table of users for holidays is complete.
updateConfCP($name, $value)
Met à jour une option du module Holiday Payés.
const STATUS_VALIDATED
Validated status.
load_state_board()
Load this->nb for dashboard.
const STATUS_DRAFT
Draft status.
createCPusers($single=false, $userid='')
Create entries for each user at setup step.
fetch($id, $ref='')
Load object in memory from database.
addLogCP($fk_user_action, $fk_user_update, $label, $new_solde, $fk_type)
addLogCP
verifNbUsers($userDolibarrWithoutCP, $userCP)
Compare le nombre d'utilisateur actif de Dolibarr à celui des utilisateurs des congés payés.
verifDateHolidayForTimestamp($fk_user, $timestamp, $status='-1')
Check that a user is not on holiday for a particular timestamp.
updateSoldeCP($userID='', $nbHoliday='', $fk_type='')
Met à jour le timestamp de la dernière mise à jour du solde des CP.
approve($user=null, $notrigger=0)
Approve leave request.
getNextNumRef($objsoc)
Returns the reference to the following non used Order depending on the active numbering module define...
const STATUS_REFUSED
Refused.
getConfCP($name, $createifnotfound='')
Return value of a conf parameter for leave module TODO Move this into llx_const table.
load_board($user)
Load indicators for dashboard (this->nbtodo and this->nbtodolate)
initAsSpecimen()
Initialise an instance with random values.
selectStatutCP($selected='', $htmlname='select_statut', $morecss='minwidth125')
Affiche un select HTML des statuts de congés payés.
create($user, $notrigger=0)
Créer un congés payés dans la base de données.
countActiveUsersWithoutCP()
Compte le nombre d'utilisateur actifs dans Dolibarr sans CP.
fetchLog($order, $filter)
Liste le log des congés payés.
update($user=null, $notrigger=0)
Update database.
getCPforUser($user_id, $fk_type=0)
Return balance of holiday for one user.
fetch_users_approver_holiday()
Return list of people with permission to validate leave requests.
__construct($db)
Constructor.
getLibStatut($mode=0)
Returns the label status.
fetchAll($order, $filter)
List all holidays of all users.
const STATUS_CANCELED
Canceled.
countActiveUsers()
Compte le nombre d'utilisateur actifs dans Dolibarr.
fetchByUser($user_id, $order='', $filter='')
List holidays for a particular user or list of users.
const STATUS_APPROVED
Approved.
getTooltipContentArray($params)
getTooltipContentArray
fetchUsers($stringlist=true, $type=true, $filters='')
Get list of Users or list of vacation balance.
getKanbanView($option='', $arraydata=null)
Return clicable link of object (with eventually picto)
LibStatut($status, $mode=0, $startdate='')
Returns the label of a status.
Class to manage Dolibarr users.
print $langs trans("Ref").' m m m statut
print $script_file $mode $langs defaultlang(is_numeric($duration_value) ? " delay=". $duration_value :"").(is_numeric($duration_value2) ? " after cd cd cd description as description
Only used if Module[ID]Desc translation string is not found.
dol_dir_list($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.
price2num($amount, $rounding='', $option=0)
Function that return a number with universal decimal format (decimal separator is '.
dol_print_error($db='', $error='', $errors=null)
Displays error message system with all the information to facilitate the diagnosis and the escalation...
img_object($titlealt, $picto, $moreatt='', $pictoisfullpath=false, $srconly=0, $notitle=0)
Show a picto called object_picto (generic function)
dol_print_date($time, $format='', $tzoutput='auto', $outputlangs='', $encodetooutput=false)
Output date in a string format according to outputlangs (or langs if not defined).
dol_now($mode='auto')
Return date for now.
getDolGlobalInt($key, $default=0)
Return dolibarr global constant int value.
img_picto($titlealt, $picto, $moreatt='', $pictoisfullpath=false, $srconly=0, $notitle=0, $alt='', $morecss='', $marginleftonlyshort=2)
Show picto whatever it's its name (generic function)
dol_buildpath($path, $type=0, $returnemptyifnotfound=0)
Return path of url or filesystem.
dol_sanitizeFileName($str, $newstr='_', $unaccent=1)
Clean a string to use it as a file name.
getDictionaryValue($tablename, $field, $id, $checkentity=false, $rowidfield='rowid')
Return the value of a filed into a dictionary for the record $id.
dol_syslog($message, $level=LOG_INFO, $ident=0, $suffixinfilename='', $restricttologhandler='', $logcontext=null)
Write log message into outputs.
dol_escape_htmltag($stringtoescape, $keepb=0, $keepn=0, $noescapetags='', $escapeonlyhtmltags=0, $cleanalsojavascript=0)
Returns text escaped for inclusion in HTML alt or title or value tags, or into values of HTML input f...