28 require_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).
"',";
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();
794 $dirsource = $conf->holiday->multidir_output[$this->entity] .
'/' . $oldref;
795 $dirdest = $conf->holiday->multidir_output[$this->entity] .
'/' . $newref;
796 if (!$error && file_exists($dirsource)) {
797 dol_syslog(get_class($this) .
"::validate rename dir " . $dirsource .
" into " . $dirdest);
798 if (@rename($dirsource, $dirdest)) {
801 $listoffiles =
dol_dir_list($dirdest,
'files', 1,
'^' . preg_quote($oldref,
'/'));
802 foreach ($listoffiles as $fileentry) {
803 $dirsource = $fileentry[
'name'];
804 $dirdest = preg_replace(
'/^' . preg_quote($oldref,
'/') .
'/', $newref, $dirsource);
805 $dirsource = $fileentry[
'path'] .
'/' . $dirsource;
806 $dirdest = $fileentry[
'path'] .
'/' . $dirdest;
807 @rename($dirsource, $dirdest);
817 foreach ($this->errors as $errmsg) {
818 dol_syslog(get_class($this).
"::validate ".$errmsg, LOG_ERR);
819 $this->error .= ($this->error ?
', '.$errmsg : $errmsg);
821 $this->db->rollback();
837 public function approve($user =
null, $notrigger = 0)
839 global $conf, $langs;
842 $checkBalance =
getDictionaryValue(
'c_holiday_types',
'block_if_negative', $this->fk_type);
844 if ($checkBalance > 0) {
845 $balance = $this->
getCPforUser($this->fk_user, $this->fk_type);
848 $this->error =
'LeaveRequestCreationBlockedBecauseBalanceIsNegative';
854 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"holiday SET";
858 if (!empty($this->date_debut)) {
859 $sql .=
" date_debut = '".$this->db->idate($this->date_debut).
"',";
863 if (!empty($this->date_fin)) {
864 $sql .=
" date_fin = '".$this->db->idate($this->date_fin).
"',";
868 $sql .=
" halfday = ".((int) $this->halfday).
",";
869 if (!empty($this->statut) && is_numeric($this->statut)) {
870 $sql .=
" statut = ".((int) $this->statut).
",";
874 if (!empty($this->fk_validator)) {
875 $sql .=
" fk_validator = ".((int) $this->fk_validator).
",";
879 if (!empty($this->date_valid)) {
880 $sql .=
" date_valid = '".$this->db->idate($this->date_valid).
"',";
882 $sql .=
" date_valid = NULL,";
884 if (!empty($this->fk_user_valid)) {
885 $sql .=
" fk_user_valid = ".((int) $this->fk_user_valid).
",";
887 $sql .=
" fk_user_valid = NULL,";
889 if (!empty($this->date_approval)) {
890 $sql .=
" date_approval = '".$this->db->idate($this->date_approval).
"',";
892 $sql .=
" date_approval = NULL,";
894 if (!empty($this->fk_user_approve)) {
895 $sql .=
" fk_user_approve = ".((int) $this->fk_user_approve).
",";
897 $sql .=
" fk_user_approve = NULL,";
899 if (!empty($this->date_refuse)) {
900 $sql .=
" date_refuse = '".$this->db->idate($this->date_refuse).
"',";
902 $sql .=
" date_refuse = NULL,";
904 if (!empty($this->fk_user_refuse)) {
905 $sql .=
" fk_user_refuse = ".((int) $this->fk_user_refuse).
",";
907 $sql .=
" fk_user_refuse = NULL,";
909 if (!empty($this->date_cancel)) {
910 $sql .=
" date_cancel = '".$this->db->idate($this->date_cancel).
"',";
912 $sql .=
" date_cancel = NULL,";
914 if (!empty($this->fk_user_cancel)) {
915 $sql .=
" fk_user_cancel = ".((int) $this->fk_user_cancel).
",";
917 $sql .=
" fk_user_cancel = NULL,";
919 if (!empty($this->detail_refuse)) {
920 $sql .=
" detail_refuse = '".$this->db->escape($this->detail_refuse).
"'";
922 $sql .=
" detail_refuse = NULL";
924 $sql .=
" WHERE rowid = ".((int) $this->
id);
928 dol_syslog(get_class($this).
"::approve", LOG_DEBUG);
929 $resql = $this->db->query(
$sql);
931 $error++; $this->errors[] =
"Error ".$this->db->lasterror();
937 $result = $this->
call_trigger(
'HOLIDAY_APPROVE', $user);
947 foreach ($this->errors as $errmsg) {
948 dol_syslog(get_class($this).
"::approve ".$errmsg, LOG_ERR);
949 $this->error .= ($this->error ?
', '.$errmsg : $errmsg);
951 $this->db->rollback();
966 public function update($user =
null, $notrigger = 0)
968 global $conf, $langs;
971 $checkBalance =
getDictionaryValue(
'c_holiday_types',
'block_if_negative', $this->fk_type);
973 if ($checkBalance > 0 && $this->statut != self::STATUS_DRAFT) {
974 $balance = $this->
getCPforUser($this->fk_user, $this->fk_type);
977 $this->error =
'LeaveRequestCreationBlockedBecauseBalanceIsNegative';
983 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"holiday SET";
987 if (!empty($this->date_debut)) {
988 $sql .=
" date_debut = '".$this->db->idate($this->date_debut).
"',";
992 if (!empty($this->date_fin)) {
993 $sql .=
" date_fin = '".$this->db->idate($this->date_fin).
"',";
997 $sql .=
" halfday = ".$this->halfday.
",";
998 if (!empty($this->statut) && is_numeric($this->statut)) {
999 $sql .=
" statut = ".$this->statut.
",";
1003 if (!empty($this->fk_validator)) {
1004 $sql .=
" fk_validator = '".$this->db->escape($this->fk_validator).
"',";
1008 if (!empty($this->date_valid)) {
1009 $sql .=
" date_valid = '".$this->db->idate($this->date_valid).
"',";
1011 $sql .=
" date_valid = NULL,";
1013 if (!empty($this->fk_user_valid)) {
1014 $sql .=
" fk_user_valid = ".((int) $this->fk_user_valid).
",";
1016 $sql .=
" fk_user_valid = NULL,";
1018 if (!empty($this->date_approval)) {
1019 $sql .=
" date_approval = '".$this->db->idate($this->date_approval).
"',";
1021 $sql .=
" date_approval = NULL,";
1023 if (!empty($this->fk_user_approve)) {
1024 $sql .=
" fk_user_approve = ".((int) $this->fk_user_approve).
",";
1026 $sql .=
" fk_user_approve = NULL,";
1028 if (!empty($this->date_refuse)) {
1029 $sql .=
" date_refuse = '".$this->db->idate($this->date_refuse).
"',";
1031 $sql .=
" date_refuse = NULL,";
1033 if (!empty($this->fk_user_refuse)) {
1034 $sql .=
" fk_user_refuse = ".((int) $this->fk_user_refuse).
",";
1036 $sql .=
" fk_user_refuse = NULL,";
1038 if (!empty($this->date_cancel)) {
1039 $sql .=
" date_cancel = '".$this->db->idate($this->date_cancel).
"',";
1041 $sql .=
" date_cancel = NULL,";
1043 if (!empty($this->fk_user_cancel)) {
1044 $sql .=
" fk_user_cancel = ".((int) $this->fk_user_cancel).
",";
1046 $sql .=
" fk_user_cancel = NULL,";
1048 if (!empty($this->detail_refuse)) {
1049 $sql .=
" detail_refuse = '".$this->db->escape($this->detail_refuse).
"'";
1051 $sql .=
" detail_refuse = NULL";
1054 $sql .=
" WHERE rowid = ".((int) $this->
id);
1058 dol_syslog(get_class($this).
"::update", LOG_DEBUG);
1059 $resql = $this->db->query(
$sql);
1061 $error++; $this->errors[] =
"Error ".$this->db->lasterror();
1067 $result = $this->
call_trigger(
'HOLIDAY_MODIFY', $user);
1077 foreach ($this->errors as $errmsg) {
1078 dol_syslog(get_class($this).
"::update ".$errmsg, LOG_ERR);
1079 $this->error .= ($this->error ?
', '.$errmsg : $errmsg);
1081 $this->db->rollback();
1084 $this->db->commit();
1097 public function delete($user, $notrigger = 0)
1099 global $conf, $langs;
1102 $sql =
"DELETE FROM ".MAIN_DB_PREFIX.
"holiday";
1103 $sql .=
" WHERE rowid=".((int) $this->
id);
1107 dol_syslog(get_class($this).
"::delete", LOG_DEBUG);
1108 $resql = $this->db->query(
$sql);
1110 $error++; $this->errors[] =
"Error ".$this->db->lasterror();
1116 $result = $this->
call_trigger(
'HOLIDAY_DELETE', $user);
1126 foreach ($this->errors as $errmsg) {
1127 dol_syslog(get_class($this).
"::delete ".$errmsg, LOG_ERR);
1128 $this->error .= ($this->error ?
', '.$errmsg : $errmsg);
1130 $this->db->rollback();
1133 $this->db->commit();
1155 foreach ($this->holiday as $infos_CP) {
1166 if ($halfday == 0) {
1167 if ($dateStart >= $infos_CP[
'date_debut'] && $dateStart <= $infos_CP[
'date_fin']) {
1170 if ($dateEnd <= $infos_CP[
'date_fin'] && $dateEnd >= $infos_CP[
'date_debut']) {
1173 } elseif ($halfday == -1) {
1175 if ($dateStart >= $infos_CP[
'date_debut'] && $dateStart <= $infos_CP[
'date_fin']) {
1176 if ($dateStart < $infos_CP[
'date_fin'] || in_array($infos_CP[
'halfday'], array(0, -1))) {
1180 if ($dateEnd <= $infos_CP[
'date_fin'] && $dateEnd >= $infos_CP[
'date_debut']) {
1181 if ($dateStart < $dateEnd) {
1184 if ($dateEnd < $infos_CP[
'date_fin'] || in_array($infos_CP[
'halfday'], array(0, -1))) {
1188 } elseif ($halfday == 1) {
1190 if ($dateStart >= $infos_CP[
'date_debut'] && $dateStart <= $infos_CP[
'date_fin']) {
1191 if ($dateStart < $dateEnd) {
1194 if ($dateStart > $infos_CP[
'date_debut'] || in_array($infos_CP[
'halfday'], array(0, 1))) {
1198 if ($dateEnd <= $infos_CP[
'date_fin'] && $dateEnd >= $infos_CP[
'date_debut']) {
1199 if ($dateEnd > $infos_CP[
'date_debut'] || in_array($infos_CP[
'halfday'], array(0, 1))) {
1203 } elseif ($halfday == 2) {
1205 if ($dateStart >= $infos_CP[
'date_debut'] && $dateStart <= $infos_CP[
'date_fin']) {
1206 if ($dateStart < $infos_CP[
'date_fin'] || in_array($infos_CP[
'halfday'], array(0, -1))) {
1210 if ($dateEnd <= $infos_CP[
'date_fin'] && $dateEnd >= $infos_CP[
'date_debut']) {
1211 if ($dateEnd > $infos_CP[
'date_debut'] || in_array($infos_CP[
'halfday'], array(0, 1))) {
1216 dol_print_error(
'',
'Bad value of parameter halfday when calling function verifDateHolidayCP');
1235 global $langs, $conf;
1237 $isavailablemorning =
true;
1238 $isavailableafternoon =
true;
1241 $sql =
"SELECT cp.rowid, cp.date_debut as date_start, cp.date_fin as date_end, cp.halfday, cp.statut";
1242 $sql .=
" FROM ".MAIN_DB_PREFIX.
"holiday as cp";
1243 $sql .=
" WHERE cp.entity IN (".getEntity(
'holiday').
")";
1244 $sql .=
" AND cp.fk_user = ".(int) $fk_user;
1245 $sql .=
" AND cp.date_debut <= '".$this->db->idate($timestamp).
"' AND cp.date_fin >= '".$this->db->idate($timestamp).
"'";
1246 if ($status !=
'-1') {
1247 $sql .=
" AND cp.statut IN (".$this->db->sanitize($status).
")";
1250 $resql = $this->db->query(
$sql);
1252 $num_rows = $this->db->num_rows($resql);
1253 if ($num_rows > 0) {
1254 $arrayofrecord = array();
1256 while ($i < $num_rows) {
1257 $obj = $this->db->fetch_object($resql);
1260 $arrayofrecord[$obj->rowid] = array(
'date_start'=>$this->db->jdate($obj->date_start),
'date_end'=>$this->db->jdate($obj->date_end),
'halfday'=>$obj->halfday);
1265 $isavailablemorning =
true;
1266 foreach ($arrayofrecord as $record) {
1267 if ($timestamp == $record[
'date_start'] && $record[
'halfday'] == 2) {
1270 if ($timestamp == $record[
'date_start'] && $record[
'halfday'] == -1) {
1273 $isavailablemorning =
false;
1276 $isavailableafternoon =
true;
1277 foreach ($arrayofrecord as $record) {
1278 if ($timestamp == $record[
'date_end'] && $record[
'halfday'] == 2) {
1281 if ($timestamp == $record[
'date_end'] && $record[
'halfday'] == 1) {
1284 $isavailableafternoon =
false;
1292 $result = array(
'morning'=>$isavailablemorning,
'afternoon'=>$isavailableafternoon);
1293 if (!$isavailablemorning) {
1294 $result[
'morning_reason'] =
'leave_request';
1296 if (!$isavailableafternoon) {
1297 $result[
'afternoon_reason'] =
'leave_request';
1311 global $conf, $langs;
1313 $langs->load(
'holiday');
1314 $nofetch = !empty($params[
'nofetch']);
1317 $datas[
'picto'] =
img_picto(
'', $this->picto).
' <u class="paddingrightonly">'.$langs->trans(
"Holiday").
'</u>';
1318 if (isset($this->statut)) {
1319 $datas[
'picto'] .=
' '.$this->getLibStatut(5);
1321 $datas[
'ref'] =
'<br><b>'.$langs->trans(
'Ref').
':</b> '.$this->ref;
1323 if (!$nofetch && !empty($this->fk_type)) {
1324 $typeleaves = $this->
getTypes(1, -1);
1325 $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']);
1326 $datas[
'type'] =
'<br><b>'.$langs->trans(
"Type") .
':</b> ' . (empty($labeltoshow) ? $langs->trans(
"TypeWasDisabledOrRemoved", $this->fk_type) : $labeltoshow);
1328 if (isset($this->halfday) && !empty($this->date_debut) && !empty($this->date_fin)) {
1329 $listhalfday = array(
1330 'morning' => $langs->trans(
"Morning"),
1331 "afternoon" => $langs->trans(
"Afternoon")
1333 $starthalfday = ($this->halfday == -1 || $this->halfday == 2) ?
'afternoon' :
'morning';
1334 $endhalfday = ($this->halfday == 1 || $this->halfday == 2) ?
'morning' :
'afternoon';
1335 $datas[
'date_start'] =
'<br><b>'.$langs->trans(
'DateDebCP') .
'</b>: '.
dol_print_date($this->date_debut,
'day') .
' <span class="opacitymedium">'.$langs->trans($listhalfday[$starthalfday]).
'</span>';
1336 $datas[
'date_end'] =
'<br><b>'.$langs->trans(
'DateFinCP') .
'</b>: '.
dol_print_date($this->date_fin,
'day') .
' <span class="opacitymedium">'.$langs->trans($listhalfday[$endhalfday]).
'</span>';
1351 public function getNomUrl($withpicto = 0, $save_lastsearch_value = -1, $notooltip = 0)
1353 global $langs, $hookmanager;
1359 'objecttype' => $this->element,
1362 $classfortooltip =
'classfortooltip';
1365 $classfortooltip =
'classforajaxtooltip';
1366 $dataparams =
' data-params="'.dol_escape_htmltag(json_encode($params)).
'"';
1372 $url = DOL_URL_ROOT.
'/holiday/card.php?id='.$this->id;
1377 $add_save_lastsearch_values = ($save_lastsearch_value == 1 ? 1 : 0);
1378 if ($save_lastsearch_value == -1 && preg_match(
'/list\.php/', $_SERVER[
"PHP_SELF"])) {
1379 $add_save_lastsearch_values = 1;
1381 if ($add_save_lastsearch_values) {
1382 $url .=
'&save_lastsearch_values=1';
1385 $linkstart =
'<a href="'.$url.
'"';
1386 $linkstart .= ($label ?
' title="'.dol_escape_htmltag($label, 1).
'"' :
' title="tocomplete"');
1387 $linkstart .= $dataparams.
' class="'.$classfortooltip.
'">';
1390 $result .= $linkstart;
1392 $result .=
img_object(($notooltip ?
'' : $label), $this->picto, ($notooltip ? (($withpicto != 2) ?
'class="paddingright"' :
'') : $dataparams.
' class="'.(($withpicto != 2) ?
'paddingright ' :
'').$classfortooltip.
'"'), 0, 0, $notooltip ? 0 : 1);
1394 if ($withpicto != 2) {
1395 $result .= $this->ref;
1397 $result .= $linkend;
1399 $hookmanager->initHooks(array($this->element .
'dao'));
1400 $parameters = array(
'id'=>$this->
id,
'getnomurl' => &$result);
1401 $reshook = $hookmanager->executeHooks(
'getNomUrl', $parameters, $this, $action);
1403 $result = $hookmanager->resPrint;
1405 $result .= $hookmanager->resPrint;
1419 return $this->
LibStatut($this->statut, $mode, $this->date_debut);
1431 public function LibStatut($status, $mode = 0, $startdate =
'')
1436 if (empty($this->labelStatus) || empty($this->labelStatusShort)) {
1444 $this->labelStatusShort[
self::STATUS_DRAFT] = $langs->transnoentitiesnoconv(
'DraftCP');
1452 $statusType =
'status6';
1453 if (!empty($startdate) && $startdate >=
dol_now()) {
1454 $statusType =
'status4';
1455 $params = array(
'tooltip'=>$this->labelStatus[$status].
' - '.$langs->trans(
"Forthcoming"));
1457 if ($status == self::STATUS_DRAFT) {
1458 $statusType =
'status0';
1460 if ($status == self::STATUS_VALIDATED) {
1461 $statusType =
'status1';
1463 if ($status == self::STATUS_CANCELED) {
1464 $statusType =
'status5';
1466 if ($status == self::STATUS_REFUSED) {
1467 $statusType =
'status5';
1470 return dolGetStatus($this->labelStatus[$status], $this->labelStatusShort[$status],
'', $statusType, $mode,
'', $params);
1482 public function selectStatutCP($selected =
'', $htmlname =
'select_statut', $morecss =
'minwidth125')
1487 $name = array(
'DraftCP',
'ToReviewCP',
'ApprovedCP',
'CancelCP',
'RefuseCP');
1488 $nb = count($name) + 1;
1491 $out =
'<select name="'.$htmlname.
'" id="'.$htmlname.
'" class="flat'.($morecss ?
' '.$morecss :
'').
'">'.
"\n";
1492 $out .=
'<option value="-1"> </option>'.
"\n";
1495 for ($i = 1; $i < $nb; $i++) {
1496 if ($i == $selected) {
1497 $out .=
'<option value="'.$i.
'" selected>'.$langs->trans($name[$i - 1]).
'</option>'.
"\n";
1499 $out .=
'<option value="'.$i.
'">'.$langs->trans($name[$i - 1]).
'</option>'.
"\n";
1503 $out .=
'</select>'.
"\n";
1506 $out .=
ajax_combobox($htmlname, array(), 0, 0,
'resolve', ($showempty < 0 ? (
string) $showempty :
'-1'), $morecss);
1521 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"holiday_config SET";
1522 $sql .=
" value = '".$this->db->escape($value).
"'";
1523 $sql .=
" WHERE name = '".$this->db->escape($name).
"'";
1525 dol_syslog(get_class($this).
'::updateConfCP name='.$name, LOG_DEBUG);
1526 $result = $this->db->query(
$sql);
1544 $sql =
"SELECT value";
1545 $sql .=
" FROM ".MAIN_DB_PREFIX.
"holiday_config";
1546 $sql .=
" WHERE name = '".$this->db->escape($name).
"'";
1548 dol_syslog(get_class($this).
'::getConfCP name='.$name.
' createifnotfound='.$createifnotfound, LOG_DEBUG);
1549 $result = $this->db->query(
$sql);
1552 $obj = $this->db->fetch_object($result);
1555 if ($createifnotfound) {
1556 $sql =
"INSERT INTO ".MAIN_DB_PREFIX.
"holiday_config(name, value)";
1557 $sql .=
" VALUES('".$this->db->escape($name).
"', '".$this->db->escape($createifnotfound).
"')";
1558 $result = $this->db->query(
$sql);
1560 return $createifnotfound;
1562 $this->error = $this->db->lasterror();
1573 $this->error = $this->db->lasterror();
1588 global $user, $langs;
1592 if (empty($userID) && empty($nbHoliday) && empty($fk_type)) {
1593 $langs->load(
"holiday");
1598 $month = date(
'm', $now);
1602 $lastUpdate = $this->
getConfCP(
'lastUpdate', $newdateforlastupdate);
1603 $monthLastUpdate = $lastUpdate[4].$lastUpdate[5];
1607 if ($month != $monthLastUpdate) {
1610 $users = $this->
fetchUsers(
false,
false,
' AND u.statut > 0');
1611 $nbUser = count($users);
1613 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"holiday_config SET";
1614 $sql .=
" value = '".$this->db->escape($newdateforlastupdate).
"'";
1615 $sql .=
" WHERE name = 'lastUpdate'";
1616 $result = $this->db->query(
$sql);
1618 $typeleaves = $this->
getTypes(1, 1);
1621 foreach ($users as $userCounter) {
1622 $nbDaysToAdd = (isset($typeleaves[$userCounter[
'type']][
'newbymonth']) ? $typeleaves[$userCounter[
'type']][
'newbymonth'] : 0);
1623 if (empty($nbDaysToAdd)) {
1627 dol_syslog(
"We update leave type id ".$userCounter[
'type'].
" for user id ".$userCounter[
'rowid'], LOG_DEBUG);
1629 $nowHoliday = $userCounter[
'nb_holiday'];
1630 $newSolde = $nowHoliday + $nbDaysToAdd;
1633 $this->
addLogCP($user->id, $userCounter[
'rowid'], $langs->trans(
'HolidaysMonthlyUpdate'), $newSolde, $userCounter[
'type']);
1635 $result = $this->
updateSoldeCP($userCounter[
'rowid'], $newSolde, $userCounter[
'type']);
1644 $this->db->commit();
1647 $this->db->rollback();
1657 $sql =
"SELECT nb_holiday FROM ".MAIN_DB_PREFIX.
"holiday_users";
1658 $sql .=
" WHERE fk_user = ".(int) $userID.
" AND fk_type = ".(
int) $fk_type;
1659 $resql = $this->db->query(
$sql);
1661 $num = $this->db->num_rows($resql);
1665 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"holiday_users SET";
1666 $sql .=
" nb_holiday = ".((float) $nbHoliday);
1667 $sql .=
" WHERE fk_user = ".(int) $userID.
" AND fk_type = ".(
int) $fk_type;
1668 $result = $this->db->query(
$sql);
1671 $this->errors[] = $this->db->lasterror();
1675 $sql =
"INSERT INTO ".MAIN_DB_PREFIX.
"holiday_users(nb_holiday, fk_user, fk_type) VALUES (";
1677 $sql .=
", ".(int) $userID.
", ".(
int) $fk_type.
")";
1678 $result = $this->db->query(
$sql);
1681 $this->errors[] = $this->db->lasterror();
1685 $this->errors[] = $this->db->lasterror();
1708 dol_syslog(get_class($this).
'::createCPusers');
1709 $arrayofusers = $this->
fetchUsers(
false,
true);
1711 foreach ($arrayofusers as $users) {
1712 $sql =
"INSERT INTO ".MAIN_DB_PREFIX.
"holiday_users";
1713 $sql .=
" (fk_user, nb_holiday)";
1714 $sql .=
" VALUES (".((int) $users[
'rowid']).
"', '0')";
1716 $resql = $this->db->query(
$sql);
1722 $sql =
"INSERT INTO ".MAIN_DB_PREFIX.
"holiday_users";
1723 $sql .=
" (fk_user, nb_holiday)";
1724 $sql .=
" VALUES (".((int) $userid).
"', '0')";
1726 $resql = $this->db->query(
$sql);
1742 $sql =
"SELECT nb_holiday";
1743 $sql .=
" FROM ".MAIN_DB_PREFIX.
"holiday_users";
1744 $sql .=
" WHERE fk_user = ".(int) $user_id;
1746 $sql .=
" AND fk_type = ".(int) $fk_type;
1749 dol_syslog(get_class($this).
'::getCPforUser user_id='.$user_id.
' type_id='.$fk_type, LOG_DEBUG);
1750 $result = $this->db->query(
$sql);
1752 $obj = $this->db->fetch_object($result);
1755 return $obj->nb_holiday;
1772 public function fetchUsers($stringlist =
true, $type =
true, $filters =
'')
1776 dol_syslog(get_class($this).
"::fetchUsers", LOG_DEBUG);
1782 if (
isModEnabled(
'multicompany') && !empty($conf->global->MULTICOMPANY_TRANSVERSE_MODE)) {
1783 $sql .=
" DISTINCT";
1786 $sql .=
" FROM ".MAIN_DB_PREFIX.
"user as u";
1788 if (
isModEnabled(
'multicompany') && !empty($conf->global->MULTICOMPANY_TRANSVERSE_MODE)) {
1789 $sql .=
", ".MAIN_DB_PREFIX.
"usergroup_user as ug";
1790 $sql .=
" WHERE ((ug.fk_user = u.rowid";
1791 $sql .=
" AND ug.entity IN (".getEntity(
'usergroup').
"))";
1792 $sql .=
" OR u.entity = 0)";
1794 $sql .=
" WHERE u.entity IN (".getEntity(
'user').
")";
1796 $sql .=
" AND u.statut > 0";
1797 $sql .=
" AND u.employee = 1";
1802 $resql = $this->db->query(
$sql);
1807 $num = $this->db->num_rows($resql);
1812 $obj = $this->db->fetch_object($resql);
1815 $stringlist .= $obj->rowid;
1817 $stringlist .=
', '.$obj->rowid;
1826 $this->error =
"Error ".$this->db->lasterror();
1831 $sql =
"SELECT DISTINCT cpu.fk_user";
1832 $sql .=
" FROM ".MAIN_DB_PREFIX.
"holiday_users as cpu, ".MAIN_DB_PREFIX.
"user as u";
1833 $sql .=
" WHERE cpu.fk_user = u.rowid";
1838 $resql = $this->db->query(
$sql);
1843 $num = $this->db->num_rows($resql);
1848 $obj = $this->db->fetch_object($resql);
1851 $stringlist .= $obj->fk_user;
1853 $stringlist .=
', '.$obj->fk_user;
1862 $this->error =
"Error ".$this->db->lasterror();
1872 if (
isModEnabled(
'multicompany') && !empty($conf->global->MULTICOMPANY_TRANSVERSE_MODE)) {
1873 $sql .=
" DISTINCT";
1875 $sql .=
" u.rowid, u.lastname, u.firstname, u.gender, u.photo, u.employee, u.statut, u.fk_user";
1876 $sql .=
" FROM ".MAIN_DB_PREFIX.
"user as u";
1878 if (
isModEnabled(
'multicompany') && !empty($conf->global->MULTICOMPANY_TRANSVERSE_MODE)) {
1879 $sql .=
", ".MAIN_DB_PREFIX.
"usergroup_user as ug";
1880 $sql .=
" WHERE ((ug.fk_user = u.rowid";
1881 $sql .=
" AND ug.entity IN (".getEntity(
'usergroup').
"))";
1882 $sql .=
" OR u.entity = 0)";
1884 $sql .=
" WHERE u.entity IN (".getEntity(
'user').
")";
1887 $sql .=
" AND u.statut > 0";
1888 $sql .=
" AND u.employee = 1";
1893 $resql = $this->db->query(
$sql);
1898 $tab_result = $this->holiday;
1899 $num = $this->db->num_rows($resql);
1903 $obj = $this->db->fetch_object($resql);
1905 $tab_result[$i][
'rowid'] = $obj->rowid;
1906 $tab_result[$i][
'id'] = $obj->rowid;
1907 $tab_result[$i][
'name'] = $obj->lastname;
1908 $tab_result[$i][
'lastname'] = $obj->lastname;
1909 $tab_result[$i][
'firstname'] = $obj->firstname;
1910 $tab_result[$i][
'gender'] = $obj->gender;
1911 $tab_result[$i][
'status'] = $obj->statut;
1912 $tab_result[$i][
'employee'] = $obj->employee;
1913 $tab_result[$i][
'photo'] = $obj->photo;
1914 $tab_result[$i][
'fk_user'] = $obj->fk_user;
1924 $this->errors[] =
"Error ".$this->db->lasterror();
1929 $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";
1930 $sql .=
" FROM ".MAIN_DB_PREFIX.
"holiday_users as cpu, ".MAIN_DB_PREFIX.
"user as u";
1931 $sql .=
" WHERE cpu.fk_user = u.rowid";
1936 $resql = $this->db->query(
$sql);
1941 $tab_result = $this->holiday;
1942 $num = $this->db->num_rows($resql);
1946 $obj = $this->db->fetch_object($resql);
1948 $tab_result[$i][
'rowid'] = $obj->rowid;
1949 $tab_result[$i][
'id'] = $obj->rowid;
1950 $tab_result[$i][
'name'] = $obj->lastname;
1951 $tab_result[$i][
'lastname'] = $obj->lastname;
1952 $tab_result[$i][
'firstname'] = $obj->firstname;
1953 $tab_result[$i][
'gender'] = $obj->gender;
1954 $tab_result[$i][
'status'] = $obj->statut;
1955 $tab_result[$i][
'employee'] = $obj->employee;
1956 $tab_result[$i][
'photo'] = $obj->photo;
1957 $tab_result[$i][
'fk_user'] = $obj->fk_user;
1959 $tab_result[$i][
'type'] = $obj->fk_type;
1960 $tab_result[$i][
'nb_holiday'] = $obj->nb_holiday;
1968 $this->error =
"Error ".$this->db->lasterror();
1986 $users_validator = array();
1988 $sql =
"SELECT DISTINCT ur.fk_user";
1989 $sql .=
" FROM ".MAIN_DB_PREFIX.
"user_rights as ur, ".MAIN_DB_PREFIX.
"rights_def as rd";
1990 $sql .=
" WHERE ur.fk_id = rd.id and rd.module = 'holiday' AND rd.perms = 'approve'";
1992 $sql .=
" SELECT DISTINCT ugu.fk_user";
1993 $sql .=
" FROM ".MAIN_DB_PREFIX.
"usergroup_user as ugu, ".MAIN_DB_PREFIX.
"usergroup_rights as ur, ".MAIN_DB_PREFIX.
"rights_def as rd";
1994 $sql .=
" WHERE ugu.fk_usergroup = ur.fk_usergroup AND ur.fk_id = rd.id and rd.module = 'holiday' AND rd.perms = 'approve'";
1997 dol_syslog(get_class($this).
"::fetch_users_approver_holiday sql=".
$sql);
1998 $result = $this->db->query(
$sql);
2000 $num_rows = $this->db->num_rows($result); $i = 0;
2001 while ($i < $num_rows) {
2002 $objp = $this->db->fetch_object($result);
2003 array_push($users_validator, $objp->fk_user);
2006 return $users_validator;
2008 $this->error = $this->db->lasterror();
2009 dol_syslog(get_class($this).
"::fetch_users_approver_holiday Error ".$this->error, LOG_ERR);
2022 $sql =
"SELECT count(u.rowid) as compteur";
2023 $sql .=
" FROM ".MAIN_DB_PREFIX.
"user as u";
2024 $sql .=
" WHERE u.statut > 0";
2026 $result = $this->db->query(
$sql);
2027 $objet = $this->db->fetch_object($result);
2029 return $objet->compteur;
2039 $sql =
"SELECT count(u.rowid) as compteur";
2040 $sql .=
" FROM ".MAIN_DB_PREFIX.
"user as u LEFT OUTER JOIN ".MAIN_DB_PREFIX.
"holiday_users hu ON (hu.fk_user=u.rowid)";
2041 $sql .=
" WHERE u.statut > 0 AND hu.fk_user IS NULL";
2043 $result = $this->db->query(
$sql);
2044 $objet = $this->db->fetch_object($result);
2046 return $objet->compteur;
2058 if (empty($userCP)) {
2061 dol_syslog(get_class($this).
'::verifNbUsers userDolibarr='.$userDolibarrWithoutCP.
' userCP='.$userCP);
2076 public function addLogCP($fk_user_action, $fk_user_update, $label, $new_solde, $fk_type)
2078 global $conf, $langs;
2086 if ($prev_solde == $new_solde) {
2093 $sql =
"INSERT INTO ".MAIN_DB_PREFIX.
"holiday_logs (";
2094 $sql .=
"date_action,";
2095 $sql .=
"fk_user_action,";
2096 $sql .=
"fk_user_update,";
2097 $sql .=
"type_action,";
2098 $sql .=
"prev_solde,";
2099 $sql .=
"new_solde,";
2101 $sql .=
") VALUES (";
2103 $sql .=
" ".((int) $fk_user_action).
",";
2104 $sql .=
" ".((int) $fk_user_update).
",";
2105 $sql .=
" '".$this->db->escape($label).
"',";
2106 $sql .=
" ".((float) $prev_solde).
",";
2107 $sql .=
" ".((float) $new_solde).
",";
2108 $sql .=
" ".((int) $fk_type);
2111 $resql = $this->db->query(
$sql);
2113 $error++; $this->errors[] =
"Error ".$this->db->lasterror();
2117 $this->optRowid = $this->db->last_insert_id(MAIN_DB_PREFIX.
"holiday_logs");
2122 foreach ($this->errors as $errmsg) {
2123 dol_syslog(get_class($this).
"::addLogCP ".$errmsg, LOG_ERR);
2124 $this->error .= ($this->error ?
', '.$errmsg : $errmsg);
2126 $this->db->rollback();
2129 $this->db->commit();
2130 return $this->optRowid;
2144 $sql .=
" cpl.rowid,";
2145 $sql .=
" cpl.date_action,";
2146 $sql .=
" cpl.fk_user_action,";
2147 $sql .=
" cpl.fk_user_update,";
2148 $sql .=
" cpl.type_action,";
2149 $sql .=
" cpl.prev_solde,";
2150 $sql .=
" cpl.new_solde,";
2151 $sql .=
" cpl.fk_type";
2152 $sql .=
" FROM ".MAIN_DB_PREFIX.
"holiday_logs as cpl";
2153 $sql .=
" WHERE cpl.rowid > 0";
2156 if (!empty($filter)) {
2157 $sql .=
" ".$filter;
2161 if (!empty($order)) {
2165 dol_syslog(get_class($this).
"::fetchLog", LOG_DEBUG);
2166 $resql = $this->db->query(
$sql);
2171 $tab_result = $this->logs;
2172 $num = $this->db->num_rows($resql);
2181 $obj = $this->db->fetch_object($resql);
2183 $tab_result[$i][
'rowid'] = $obj->rowid;
2184 $tab_result[$i][
'id'] = $obj->rowid;
2185 $tab_result[$i][
'date_action'] = $obj->date_action;
2186 $tab_result[$i][
'fk_user_action'] = $obj->fk_user_action;
2187 $tab_result[$i][
'fk_user_update'] = $obj->fk_user_update;
2188 $tab_result[$i][
'type_action'] = $obj->type_action;
2189 $tab_result[$i][
'prev_solde'] = $obj->prev_solde;
2190 $tab_result[$i][
'new_solde'] = $obj->new_solde;
2191 $tab_result[$i][
'fk_type'] = $obj->fk_type;
2196 $this->logs = $tab_result;
2200 $this->error =
"Error ".$this->db->lasterror();
2217 $sql =
"SELECT rowid, code, label, affect, delay, newbymonth";
2218 $sql .=
" FROM ".MAIN_DB_PREFIX.
"c_holiday_types";
2219 $sql .=
" WHERE (fk_country IS NULL OR fk_country = ".((int) $mysoc->country_id).
')';
2221 $sql .=
" AND active = ".((int) $active);
2224 $sql .=
" AND affect = ".((int) $affect);
2226 $sql .=
" ORDER BY sortorder";
2228 $result = $this->db->query(
$sql);
2230 $num = $this->db->num_rows($result);
2232 while ($obj = $this->db->fetch_object($result)) {
2233 $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);
2256 $sql =
"SELECT f.rowid, f.statut as status,";
2257 $sql .=
" f.date_create as datec,";
2258 $sql .=
" f.tms as date_modification,";
2259 $sql .=
" f.date_valid as datev,";
2260 $sql .=
" f.date_approval as datea,";
2261 $sql .=
" f.date_refuse as dater,";
2262 $sql .=
" f.fk_user_create as fk_user_creation,";
2263 $sql .=
" f.fk_user_modif as fk_user_modification,";
2264 $sql .=
" f.fk_user_valid as fk_user_validation,";
2265 $sql .=
" f.fk_user_approve as fk_user_approval_done,";
2266 $sql .=
" f.fk_validator as fk_user_approval_expected,";
2267 $sql .=
" f.fk_user_refuse as fk_user_refuse";
2268 $sql .=
" FROM ".MAIN_DB_PREFIX.
"holiday as f";
2269 $sql .=
" WHERE f.rowid = ".((int) $id);
2270 $sql .=
" AND f.entity = ".$conf->entity;
2272 $resql = $this->db->query(
$sql);
2274 if ($this->db->num_rows($resql)) {
2275 $obj = $this->db->fetch_object($resql);
2277 $this->
id = $obj->rowid;
2279 $this->date_creation = $this->db->jdate($obj->datec);
2280 $this->date_modification = $this->db->jdate($obj->date_modification);
2281 $this->date_validation = $this->db->jdate($obj->datev);
2282 $this->date_approval = $this->db->jdate($obj->datea);
2284 if (!empty($obj->fk_user_creation)) {
2285 $cuser =
new User($this->db);
2286 $cuser->fetch($obj->fk_user_creation);
2287 $this->user_creation = $cuser;
2289 if (!empty($obj->fk_user_valid)) {
2290 $vuser =
new User($this->db);
2291 $vuser->fetch($obj->fk_user_valid);
2292 $this->user_validation = $vuser;
2294 if (!empty($obj->fk_user_modification)) {
2295 $muser =
new User($this->db);
2296 $muser->fetch($obj->fk_user_modification);
2297 $this->user_modification = $muser;
2301 if ($obj->fk_user_approval_done) {
2302 $auser =
new User($this->db);
2303 $auser->fetch($obj->fk_user_approval_done);
2304 $this->user_approve = $auser;
2308 $this->db->free($resql);
2324 global $user, $langs;
2328 $this->specimen = 1;
2330 $this->fk_user = $user->id;
2332 $this->date_debut =
dol_now();
2333 $this->date_fin =
dol_now() + (24 * 3600);
2334 $this->date_valid =
dol_now();
2335 $this->fk_validator = $user->id;
2352 $this->nb = array();
2354 $sql =
"SELECT count(h.rowid) as nb";
2355 $sql .=
" FROM ".MAIN_DB_PREFIX.
"holiday as h";
2356 $sql .=
" WHERE h.statut > 1";
2357 $sql .=
" AND h.entity IN (".getEntity(
'holiday').
")";
2358 if (empty($user->rights->expensereport->readall)) {
2359 $userchildids = $user->getAllChildIds(1);
2360 $sql .=
" AND (h.fk_user IN (".$this->db->sanitize(join(
',', $userchildids)).
")";
2361 $sql .=
" OR h.fk_validator IN (".$this->db->sanitize(join(
',', $userchildids)).
"))";
2364 $resql = $this->db->query(
$sql);
2366 while ($obj = $this->db->fetch_object($resql)) {
2367 $this->nb[
"holidays"] = $obj->nb;
2369 $this->db->free($resql);
2373 $this->error = $this->db->error();
2388 global $conf, $langs;
2396 $sql =
"SELECT h.rowid, h.date_debut";
2397 $sql .=
" FROM ".MAIN_DB_PREFIX.
"holiday as h";
2398 $sql .=
" WHERE h.statut = 2";
2399 $sql .=
" AND h.entity IN (".getEntity(
'holiday').
")";
2400 if (empty($user->rights->expensereport->read_all)) {
2401 $userchildids = $user->getAllChildIds(1);
2402 $sql .=
" AND (h.fk_user IN (".$this->db->sanitize(join(
',', $userchildids)).
")";
2403 $sql .=
" OR h.fk_validator IN (".$this->db->sanitize(join(
',', $userchildids)).
"))";
2406 $resql = $this->db->query(
$sql);
2408 $langs->load(
"members");
2411 $response->warning_delay = $conf->holiday->approve->warning_delay / 60 / 60 / 24;
2412 $response->label = $langs->trans(
"HolidaysToApprove");
2413 $response->labelShort = $langs->trans(
"ToApprove");
2414 $response->url = DOL_URL_ROOT.
'/holiday/list.php?search_status=2&mainmenu=hrm&leftmenu=holiday';
2417 while ($obj = $this->db->fetch_object($resql)) {
2418 $response->nbtodo++;
2420 if ($this->db->jdate($obj->date_debut) < ($now - $conf->holiday->approve->warning_delay)) {
2421 $response->nbtodolate++;
2428 $this->error = $this->db->error();
2443 $selected = (empty($arraydata[
'selected']) ? 0 : $arraydata[
'selected']);
2445 $return =
'<div class="box-flex-item box-flex-grow-zero">';
2446 $return .=
'<div class="info-box info-box-sm">';
2447 $return .=
'<span class="info-box-icon bg-infobox-action">';
2449 $return .=
'</span>';
2450 $return .=
'<div class="info-box-content">';
2451 $return .=
'<span class="info-box-ref inline-block tdoverflowmax150 valignmiddle">'.$arraydata[
'user']->getNomUrl(-1).
'</span>';
2452 $return .=
'<input id="cb'.$this->id.
'" class="flat checkforselect fright" type="checkbox" name="toselect[]" value="'.$this->
id.
'"'.($selected ?
' checked="checked"' :
'').
'>';
2453 if (property_exists($this,
'fk_type')) {
2454 $return .=
'<br><span class="opacitymedium">'.$langs->trans(
"Type").
'</span> : ';
2455 $return .=
'<span class="info_box-label maxwidth100">'.$arraydata[
'labeltype'].
'</span>';
2457 if (property_exists($this,
'date_debut') && property_exists($this,
'date_fin')) {
2458 $return .=
'<br><span class="info-box-label">'.dol_print_date($this->date_debut,
'day').
'</span>';
2459 $return .=
' <span class="opacitymedium">'.$langs->trans(
"To").
'</span> ';
2460 $return .=
'<span class="info-box-label">'.dol_print_date($this->date_fin,
'day').
'</span>';
2462 if (method_exists($this,
'getLibStatut')) {
2463 $return .=
'<br><div class="info-box-status margintoponly">'.$this->getLibStatut(3).
'</div>';
2465 $return .=
'</div>';
2466 $return .=
'</div>';
2467 $return .=
'</div>';