dolibarr 25.0.0-alpha
recruitmentjobposition.class.php
Go to the documentation of this file.
1<?php
2/* Copyright (C) 2020 Laurent Destailleur <eldy@users.sourceforge.net>
3/* Copyright (C) 2022 Alexandre Spangaro <aspangaro@open-dsi.fr>
4 * Copyright (C) 2024-2025 Frédéric France <frederic.france@free.fr>
5 * Copyright (C) 2024-2026 MDW <mdeweerd@users.noreply.github.com>
6 *
7 * This program is free software; you can redistribute it and/or modify
8 * it under the terms of the GNU General Public License as published by
9 * the Free Software Foundation; either version 3 of the License, or
10 * (at your option) any later version.
11 *
12 * This program is distributed in the hope that it will be useful,
13 * but WITHOUT ANY WARRANTY; without even the implied warranty of
14 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
15 * GNU General Public License for more details.
16 *
17 * You should have received a copy of the GNU General Public License
18 * along with this program. If not, see <https://www.gnu.org/licenses/>.
19 */
20
27// Put here all includes required by your class file
28require_once DOL_DOCUMENT_ROOT.'/core/class/commonobject.class.php';
29//require_once DOL_DOCUMENT_ROOT . '/societe/class/societe.class.php';
30//require_once DOL_DOCUMENT_ROOT . '/product/class/product.class.php';
31
36{
40 public $module = 'recruitment';
41
45 public $element = 'recruitmentjobposition';
46
50 public $table_element = 'recruitment_recruitmentjobposition';
51
55 public $picto = 'recruitmentjobposition';
56
60 const STATUS_DRAFT = 0;
61
66
71
75 const STATUS_CANCELED = 9;
76
77
103 // BEGIN MODULEBUILDER PROPERTIES
107 public $fields = array(
108 'rowid' => array('type' => 'integer', 'label' => 'TechnicalID', 'enabled' => 1, 'position' => 1, 'notnull' => 1, 'visible' => 0, 'noteditable' => 1, 'index' => 1, 'comment' => "Id"),
109 'entity' => array('type' => 'integer', 'label' => 'Entity', 'enabled' => 1, 'visible' => 0, 'position' => 5, 'notnull' => 1, 'default' => '1', 'index' => 1),
110 'ref' => array('type' => 'varchar(128)', 'label' => 'Ref', 'enabled' => 1, 'position' => 10, 'notnull' => 1, 'visible' => 4, 'noteditable' => 1, 'default' => '(PROV)', 'index' => 1, 'searchall' => 1, 'showoncombobox' => 1, 'comment' => "Reference of object", 'css' => 'nowraponall'),
111 'label' => array('type' => 'varchar(255)', 'label' => 'JobLabel', 'enabled' => 1, 'position' => 30, 'notnull' => 1, 'visible' => 1, 'searchall' => 1, 'css' => 'minwidth500', 'csslist' => 'tdoverflowmax300', 'showoncombobox' => 2, 'autofocusoncreate' => 1),
112 'qty' => array('type' => 'integer', 'label' => 'NbOfEmployeesExpected', 'enabled' => 1, 'position' => 45, 'notnull' => 1, 'visible' => 1, 'default' => '1', 'isameasure' => 1, 'css' => 'maxwidth75imp'),
113 'fk_project' => array('type' => 'integer:Project:projet/class/project.class.php:1', 'label' => 'Project', 'enabled' => 'isModEnabled("project")', 'position' => 52, 'notnull' => -1, 'visible' => -1, 'index' => 1, 'css' => 'maxwidth500', 'picto' => 'project'),
114 'fk_user_recruiter' => array('type' => 'integer:User:user/class/user.class.php:1:(statut:=:1)', 'label' => 'ResponsibleOfRecruitement', 'enabled' => 1, 'position' => 54, 'notnull' => 1, 'visible' => 1, 'foreignkey' => 'user.rowid', 'css' => 'maxwidth500', 'csslist' => 'tdoverflowmax150', 'picto' => 'user'),
115 'email_recruiter' => array('type' => 'varchar(255)', 'label' => 'EmailRecruiter', 'enabled' => 1, 'position' => 54, 'notnull' => 0, 'visible' => -1, 'help' => 'ToUseAGenericEmail', 'picto' => 'email'),
116 'fk_user_supervisor' => array('type' => 'integer:User:user/class/user.class.php:1:(statut:=:1)', 'label' => 'FutureManager', 'enabled' => 1, 'position' => 55, 'notnull' => 0, 'visible' => -1, 'foreignkey' => 'user.rowid', 'css' => 'maxwidth500', 'csslist' => 'tdoverflowmax150', 'picto' => 'user'),
117 'fk_establishment' => array('type' => 'integer:Establishment:hrm/class/establishment.class.php', 'label' => 'Establishment', 'enabled' => 'isModEnabled("hrm")', 'position' => 56, 'notnull' => 0, 'visible' => -1, 'foreignkey' => 'establishment.rowid',),
118 'fk_soc' => array('type' => 'integer:Societe:societe/class/societe.class.php:1:((status:=:1) AND (entity:IN:__SHARED_ENTITIES__))', 'label' => 'WorkPlace', 'enabled' => 'isModEnabled("societe")', 'position' => 57, 'notnull' => -1, 'visible' => -1, 'css' => 'maxwidth500', 'index' => 1, 'help' => "IfJobIsLocatedAtAPartner", 'picto' => 'company'),
119 'date_planned' => array('type' => 'date', 'label' => 'DateExpected', 'enabled' => 1, 'position' => 60, 'notnull' => 0, 'visible' => 1,),
120 'remuneration_suggested' => array('type' => 'varchar(255)', 'label' => 'Remuneration', 'enabled' => 1, 'position' => 62, 'notnull' => 0, 'visible' => 1, 'csslist' => 'tdoverflowmax150'),
121 'description' => array('type' => 'html', 'label' => 'Description', 'enabled' => 1, 'position' => 65, 'notnull' => 0, 'visible' => 3,),
122 'note_public' => array('type' => 'html', 'label' => 'NotePublic', 'enabled' => 1, 'position' => 101, 'notnull' => 0, 'visible' => 0,),
123 'note_private' => array('type' => 'html', 'label' => 'NotePrivate', 'enabled' => 1, 'position' => 102, 'notnull' => 0, 'visible' => 0,),
124 'date_creation' => array('type' => 'datetime', 'label' => 'DateCreation', 'enabled' => 1, 'position' => 500, 'notnull' => 1, 'visible' => -4,),
125 'tms' => array('type' => 'timestamp', 'label' => 'DateModification', 'enabled' => 1, 'position' => 501, 'notnull' => 0, 'visible' => -2,),
126 'fk_user_creat' => array('type' => 'integer:User:user/class/user.class.php', 'label' => 'UserAuthor', 'enabled' => 1, 'position' => 510, 'notnull' => 1, 'visible' => -2, 'foreignkey' => 'user.rowid',),
127 'fk_user_modif' => array('type' => 'integer:User:user/class/user.class.php', 'label' => 'UserModif', 'enabled' => 1, 'position' => 511, 'notnull' => -1, 'visible' => -2,),
128 'last_main_doc' => array('type' => 'varchar(255)', 'label' => 'LastMainDoc', 'enabled' => 1, 'position' => 900, 'notnull' => 0, 'visible' => 0,),
129 'import_key' => array('type' => 'varchar(14)', 'label' => 'ImportId', 'enabled' => 1, 'position' => 1000, 'notnull' => -1, 'visible' => -2,),
130 'model_pdf' => array('type' => 'varchar(255)', 'label' => 'Model pdf', 'enabled' => 1, 'position' => 1010, 'notnull' => -1, 'visible' => 0,),
131 'status' => array('type' => 'smallint', 'label' => 'Status', 'enabled' => 1, 'position' => 1000, 'notnull' => 1, 'visible' => 5, 'default' => '0', 'index' => 1, 'arrayofkeyval' => array(0 => 'Draft', 1 => 'Validated', 3 => 'Recruited', 9 => 'Canceled'),),
132 );
136 public $rowid;
137
141 public $ref;
142
146 public $label;
147
151 public $qty;
152
156 public $fk_soc;
157
161 public $fk_project;
165 public $fk_user_recruiter;
166
170 public $email_recruiter;
171
175 public $remuneration_suggested;
176
180 public $fk_user_supervisor;
184 public $fk_establishment;
188 public $date_planned;
192 public $description;
196 public $note_public;
200 public $note_private;
204 public $fk_user_creat;
208 public $fk_user_modif;
212 public $last_main_doc;
216 public $import_key;
220 public $model_pdf;
224 public $status;
225 // END MODULEBUILDER PROPERTIES
226
227
233 public function __construct(DoliDB $db)
234 {
235 global $conf, $langs;
236
237 $this->db = $db;
238
239 $this->ismultientitymanaged = 1;
240 $this->isextrafieldmanaged = 1;
241
242 if (!getDolGlobalString('MAIN_SHOW_TECHNICAL_ID') && isset($this->fields['rowid'])) {
243 $this->fields['rowid']['visible'] = 0;
244 }
245 if (!isModEnabled('multicompany') && isset($this->fields['entity'])) {
246 $this->fields['entity']['enabled'] = 0;
247 }
248
249 // Example to show how to set values of fields definition dynamically
250 /*if ($user->hasRight('recruitment', 'recruitmentjobposition', 'read')) {
251 $this->fields['myfield']['visible'] = 1;
252 $this->fields['myfield']['noteditable'] = 0;
253 }*/
254
255 // Unset fields that are disabled
256 foreach ($this->fields as $key => $val) {
257 if (isset($val['enabled']) && empty($val['enabled'])) {
258 unset($this->fields[$key]);
259 }
260 }
261
262 // Translate some data of arrayofkeyval
263 if (is_object($langs)) {
264 foreach ($this->fields as $key => $val) {
265 if (!empty($val['arrayofkeyval']) && is_array($val['arrayofkeyval'])) {
266 foreach ($val['arrayofkeyval'] as $key2 => $val2) {
267 $this->fields[$key]['arrayofkeyval'][$key2] = $langs->trans($val2);
268 }
269 }
270 }
271 }
272 }
273
281 public function create(User $user, $notrigger = 0)
282 {
283 return $this->createCommon($user, $notrigger);
284 }
285
293 public function createFromClone(User $user, $fromid)
294 {
295 global $langs, $extrafields;
296 $error = 0;
297
298 dol_syslog(__METHOD__, LOG_DEBUG);
299
300 $object = new self($this->db);
301
302 $this->db->begin();
303
304 // Load source object
305 $result = $object->fetchCommon($fromid);
306 if ($result > 0 && !empty($object->table_element_line)) {
307 $object->fetchLines();
308 }
309
310 // get lines so they will be clone
311 //foreach($this->lines as $line)
312 // $line->fetch_optionals();
313
314 // Reset some properties
315 unset($object->id);
316 unset($object->fk_user_creat);
317 unset($object->import_key);
318
319 // Clear fields
320 if (property_exists($object, 'ref')) {
321 // @phan-suppress-next-line PhanTypeMismatchProperty
322 $object->ref = empty($this->fields['ref']['default']) ? "Copy_Of_".$object->ref : $this->fields['ref']['default'];
323 }
324 if (property_exists($object, 'label')) {
325 // @phan-suppress-next-line PhanTypeInvalidDimOffset
326 $object->label = empty($this->fields['label']['default']) ? $langs->trans("CopyOf")." ".$object->label : $this->fields['label']['default'];
327 }
328 if (property_exists($object, 'status')) {
329 $object->status = self::STATUS_DRAFT;
330 }
331 if (property_exists($object, 'date_creation')) {
332 $object->date_creation = dol_now();
333 }
334 if (property_exists($object, 'date_modification')) {
335 $object->date_modification = null;
336 }
337 // ...
338 // Clear extrafields that are unique
339 if (is_array($object->array_options) && count($object->array_options) > 0) {
340 $extrafields->fetch_name_optionals_label($this->table_element);
341 foreach ($object->array_options as $key => $option) {
342 $shortkey = preg_replace('/options_/', '', $key);
343 if (!empty($extrafields->attributes[$this->element]['unique'][$shortkey])) {
344 //var_dump($key);
345 //var_dump($clonedObj->array_options[$key]); exit;
346 unset($object->array_options[$key]);
347 }
348 }
349 }
350
351 // Create clone
352 $object->context['createfromclone'] = 'createfromclone';
353 $result = $object->createCommon($user);
354 if ($result < 0) {
355 $error++;
357 }
358
359 if (!$error) {
360 // copy internal contacts
361 if ($this->copy_linked_contact($object, 'internal') < 0) {
362 $error++;
363 }
364 }
365
366 unset($object->context['createfromclone']);
367
368 // End
369 if (!$error) {
370 $this->db->commit();
371 return $object;
372 } else {
373 $this->db->rollback();
374 return -1;
375 }
376 }
377
385 public function fetch($id, $ref = null)
386 {
387 $result = $this->fetchCommon($id, $ref);
388 if ($result > 0 && !empty($this->table_element_line)) {
389 $this->fetchLines();
390 }
391 return $result;
392 }
393
399 public function fetchLines()
400 {
401 $this->lines = array();
402
403 $result = $this->fetchLinesCommon();
404 return $result;
405 }
406
407
420 public function fetchAll($sortorder = '', $sortfield = '', $limit = 0, $offset = 0, $filter = '', $filtermode = 'AND')
421 {
422 dol_syslog(__METHOD__, LOG_DEBUG);
423
424 $records = array();
425
426 $sql = 'SELECT ';
427 $sql .= $this->getFieldList();
428 $sql .= ' FROM '.MAIN_DB_PREFIX.$this->table_element.' as t';
429 if (isset($this->ismultientitymanaged) && $this->ismultientitymanaged == 1) {
430 $sql .= ' WHERE t.entity IN ('.getEntity($this->element).')';
431 } else {
432 $sql .= ' WHERE 1 = 1';
433 }
434
435 // Manage filter
436 $errormessage = '';
437 $sql .= forgeSQLFromUniversalSearchCriteria($filter, $errormessage);
438 if ($errormessage) {
439 $this->errors[] = $errormessage;
440 dol_syslog(__METHOD__.' '.implode(',', $this->errors), LOG_ERR);
441 return -1;
442 }
443
444 if (!empty($sortfield)) {
445 $sql .= $this->db->order($sortfield, $sortorder);
446 }
447 if (!empty($limit)) {
448 $sql .= $this->db->plimit($limit, $offset);
449 }
450
451 $resql = $this->db->query($sql);
452 if ($resql) {
453 $num = $this->db->num_rows($resql);
454 $i = 0;
455 while ($i < ($limit ? min($limit, $num) : $num)) {
456 $obj = $this->db->fetch_object($resql);
457
458 $record = new self($this->db);
459 $record->setVarsFromFetchObj($obj);
460
461 $records[$record->id] = $record;
462
463 $i++;
464 }
465 $this->db->free($resql);
466
467 return $records;
468 } else {
469 $this->errors[] = 'Error '.$this->db->lasterror();
470 dol_syslog(__METHOD__.' '.implode(',', $this->errors), LOG_ERR);
471
472 return -1;
473 }
474 }
475
483 public function update(User $user, $notrigger = 0)
484 {
485 return $this->updateCommon($user, $notrigger);
486 }
487
495 public function delete(User $user, $notrigger = 0)
496 {
497 return $this->deleteCommon($user, $notrigger);
498 }
499
508 public function deleteLine(User $user, $idline, $notrigger = 0)
509 {
510 if ($this->status < 0) {
511 $this->error = 'ErrorDeleteLineNotAllowedByObjectStatus';
512 return -2;
513 }
514
515 return $this->deleteLineCommon($user, $idline, $notrigger);
516 }
517
518
526 public function validate($user, $notrigger = 0)
527 {
528 global $conf;
529
530 require_once DOL_DOCUMENT_ROOT.'/core/lib/files.lib.php';
531
532 $error = 0;
533
534 // Protection
535 if ($this->status == self::STATUS_VALIDATED) {
536 dol_syslog(get_class($this)."::validate action abandoned: already validated", LOG_WARNING);
537 return 0;
538 }
539
540 $now = dol_now();
541
542 $this->db->begin();
543
544 // Define new ref
545 if (/* !$error && */ (preg_match('/^[\‍(]?PROV/i', $this->ref) || empty($this->ref))) { // empty should not happened, but when it occurs, the test save life
546 $num = $this->getNextNumRef();
547 } else {
548 $num = (string) $this->ref;
549 }
550 $this->newref = $num;
551
552 if (!empty($num)) {
553 // Validate
554 $sql = "UPDATE ".MAIN_DB_PREFIX.$this->table_element;
555 $sql .= " SET ref = '".$this->db->escape($num)."',";
556 $sql .= " status = ".self::STATUS_VALIDATED;
557 if (!empty($this->fields['date_validation'])) {
558 $sql .= ", date_validation = '".$this->db->idate($now)."',";
559 }
560 if (!empty($this->fields['fk_user_valid'])) { // @phan-suppress-current-line PhanTypeMismatchProperty
561 $sql .= ", fk_user_valid = ".((int) $user->id);
562 }
563 $sql .= " WHERE rowid = ".((int) $this->id);
564
565 dol_syslog(get_class($this)."::validate()", LOG_DEBUG);
566 $resql = $this->db->query($sql);
567 if (!$resql) {
568 dol_print_error($this->db);
569 $this->error = $this->db->lasterror();
570 $error++;
571 }
572
573 if (!$error && !$notrigger) {
574 // Call trigger
575 $result = $this->call_trigger('RECRUITMENTJOBPOSITION_VALIDATE', $user);
576 if ($result < 0) {
577 $error++;
578 }
579 // End call triggers
580 }
581 }
582
583 if (!$error) {
584 $this->oldref = $this->ref;
585
586 // Rename directory if dir was a temporary ref
587 if (preg_match('/^[\‍(]?PROV/i', $this->ref)) {
588 // Now we rename also files into index
589 $sql = 'UPDATE '.MAIN_DB_PREFIX."ecm_files set filename = CONCAT('".$this->db->escape($this->newref)."', SUBSTR(filename, ".(strlen($this->ref) + 1).")), filepath = 'recruitmentjobposition/".$this->db->escape($this->newref)."'";
590 $sql .= " WHERE filename LIKE '".$this->db->escape($this->ref)."%' AND filepath = 'recruitmentjobposition/".$this->db->escape($this->ref)."' and entity = ".((int) $conf->entity);
591 $resql = $this->db->query($sql);
592 if (!$resql) {
593 $error++;
594 $this->error = $this->db->lasterror();
595 }
596 $sql = 'UPDATE '.MAIN_DB_PREFIX."ecm_files set filepath = 'recruitmentjobposition/".$this->db->escape($this->newref)."'";
597 $sql .= " WHERE filepath = 'recruitmentjobposition/".$this->db->escape($this->ref)."' and entity = ".((int) $conf->entity);
598 $resql = $this->db->query($sql);
599 if (!$resql) {
600 $error++;
601 $this->error = $this->db->lasterror();
602 }
603
604 // We rename directory ($this->ref = old ref, $num = new ref) in order not to lose the attachments
605 $oldref = dol_sanitizeFileName($this->ref);
606 $newref = dol_sanitizeFileName($num);
607 $dirsource = $conf->recruitment->dir_output.'/recruitmentjobposition/'.$oldref;
608 $dirdest = $conf->recruitment->dir_output.'/recruitmentjobposition/'.$newref;
609 if (!$error && file_exists($dirsource)) {
610 dol_syslog(get_class($this)."::validate() rename dir ".$dirsource." into ".$dirdest);
611
612 if (@rename($dirsource, $dirdest)) {
613 dol_syslog("Rename ok");
614 // Rename docs starting with $oldref with $newref
615 $listoffiles = dol_dir_list($conf->recruitment->dir_output.'/recruitmentjobposition/'.$newref, 'files', 1, '^'.preg_quote($oldref, '/'));
616 foreach ($listoffiles as $fileentry) {
617 $dirsource = $fileentry['name'];
618 $dirdest = preg_replace('/^'.preg_quote($oldref, '/').'/', $newref, $dirsource);
619 $dirsource = $fileentry['path'].'/'.$dirsource;
620 $dirdest = $fileentry['path'].'/'.$dirdest;
621 @rename($dirsource, $dirdest);
622 }
623 }
624 }
625 }
626 }
627
628 // Set new ref and current status
629 if (!$error) {
630 $this->ref = $num;
632 }
633
634 if (!$error) {
635 $this->db->commit();
636 return 1;
637 } else {
638 $this->db->rollback();
639 return -1;
640 }
641 }
642
643
651 public function setDraft($user, $notrigger = 0)
652 {
653 // Protection
654 if ($this->status <= self::STATUS_DRAFT) {
655 return 0;
656 }
657
658 /*if (! ((empty($conf->global->MAIN_USE_ADVANCED_PERMS) && !empty($user->rights->recruitment->write))
659 || (!empty($conf->global->MAIN_USE_ADVANCED_PERMS) && !empty($user->rights->recruitment->recruitment_advance->validate))))
660 {
661 $this->error='Permission denied';
662 return -1;
663 }*/
664
665 return $this->setStatusCommon($user, self::STATUS_DRAFT, $notrigger, 'RECRUITMENTJOBPOSITION_UNVALIDATE');
666 }
667
675 public function cancel($user, $notrigger = 0)
676 {
677 // Protection
678 if ($this->status != self::STATUS_VALIDATED) {
679 return 0;
680 }
681
682 /*if (! ((empty($conf->global->MAIN_USE_ADVANCED_PERMS) && !empty($user->rights->recruitment->write))
683 || (!empty($conf->global->MAIN_USE_ADVANCED_PERMS) && !empty($user->rights->recruitment->recruitment_advance->validate))))
684 {
685 $this->error='Permission denied';
686 return -1;
687 }*/
688
689 return $this->setStatusCommon($user, self::STATUS_CANCELED, $notrigger, 'RECRUITMENTJOBPOSITION_CLOSE');
690 }
691
701 public function cloture($user, $status, $note = "", $notrigger = 0)
702 {
703 global $langs, $conf;
704
705 $error = 0;
706 $now = dol_now();
707
708 $this->db->begin();
709
710 $newprivatenote = dol_concatdesc($this->note_private, $note);
711
712 $sql = "UPDATE ".MAIN_DB_PREFIX.$this->table_element;
713 $sql .= " SET status = ".((int) $status).", note_private = '".$this->db->escape($newprivatenote)."'";
714 //$sql .= ", date_cloture='".$this->db->idate($now)."', fk_user_cloture=".((int) $user->id);
715 $sql .= " WHERE rowid = ".((int) $this->id);
716
717 $resql = $this->db->query($sql);
718 if ($resql) {
719 $modelpdf = $this->model_pdf;
720 $triggerName = 'RECRUITMENTJOB_CLOSE_REFUSED';
721
722 if ($status == self::STATUS_RECRUITED) {
723 $triggerName = 'RECRUITMENTJOB_CLOSE_RECRUITED';
724 $modelpdf = $this->model_pdf;
725 }
726
727 if (!getDolGlobalString('MAIN_DISABLE_PDF_AUTOUPDATE')) {
728 // Define output language
729 $outputlangs = $langs;
730 if (getDolGlobalInt('MAIN_MULTILANGS')) {
731 $outputlangs = new Translate("", $conf);
732 $newlang = (GETPOST('lang_id', 'aZ09') ? GETPOST('lang_id', 'aZ09') : $this->thirdparty->default_lang);
733 $outputlangs->setDefaultLang($newlang);
734 }
735
736 // PDF
737 $hidedetails = (getDolGlobalString('MAIN_GENERATE_DOCUMENTS_HIDE_DETAILS') ? 1 : 0);
738 $hidedesc = (getDolGlobalString('MAIN_GENERATE_DOCUMENTS_HIDE_DESC') ? 1 : 0);
739 $hideref = (getDolGlobalString('MAIN_GENERATE_DOCUMENTS_HIDE_REF') ? 1 : 0);
740
741 //$ret=$object->fetch($id); // Reload to get new records
742 $this->generateDocument($modelpdf, $outputlangs, $hidedetails, $hidedesc, $hideref);
743 }
744
745 $this->oldcopy = clone $this;
746 $this->status = $status;
747 $this->date_cloture = $now;
748 $this->note_private = $newprivatenote;
749
750 if (!$notrigger /* && empty($error) */) {
751 // Call trigger
752 $result = $this->call_trigger($triggerName, $user);
753 if ($result < 0) {
754 $error++;
755 }
756 // End call triggers
757 }
758
759 if (!$error) {
760 $this->db->commit();
761 return 1;
762 } else {
763 $this->status = $this->oldcopy->status;
764 $this->date_cloture = $this->oldcopy->date_cloture;
765 $this->note_private = $this->oldcopy->note_private;
766
767 $this->db->rollback();
768 return -1;
769 }
770 } else {
771 $this->error = $this->db->lasterror();
772 $this->db->rollback();
773 return -1;
774 }
775 }
776
784 public function reopen($user, $notrigger = 0)
785 {
786 // Protection
787 if ($this->status != self::STATUS_CANCELED) {
788 return 0;
789 }
790
791 /*if (! ((empty($conf->global->MAIN_USE_ADVANCED_PERMS) && !empty($user->rights->recruitment->write))
792 || (!empty($conf->global->MAIN_USE_ADVANCED_PERMS) && !empty($user->rights->recruitment->recruitment_advance->validate))))
793 {
794 $this->error='Permission denied';
795 return -1;
796 }*/
797
798 return $this->setStatusCommon($user, self::STATUS_VALIDATED, $notrigger, 'RECRUITMENTJOBPOSITION_REOPEN');
799 }
800
808 public function getTooltipContentArray($params)
809 {
810 global $langs;
811
812 $langs->load('recruitment');
813
814 $datas = [];
815
816 if (getDolGlobalInt('MAIN_OPTIMIZEFORTEXTBROWSER')) {
817 return ['optimize' => $langs->trans("ShowPositionToBeFilled")];
818 }
819 $datas['picto'] = img_picto('', $this->picto) . ' <u class="paddingrightonly">' . $langs->trans("PositionToBeFilled") . '</u>';
820 if (isset($this->status)) {
821 $datas['picto'] .= ' ' . $this->getLibStatut(5);
822 }
823 if (!empty($this->ref)) {
824 $datas['ref'] = '<br><b>' . $langs->trans('Ref') . ':</b> ' . $this->ref;
825 }
826 if (!empty($this->label)) {
827 $datas['ref'] = '<br>' . $langs->trans('Label') . ':</b> ' . $this->label;
828 }
829
830 return $datas;
831 }
832
843 public function getNomUrl($withpicto = 0, $option = '', $notooltip = 0, $morecss = '', $save_lastsearch_value = -1)
844 {
845 global $conf, $langs, $hookmanager;
846
847 if (!empty($conf->dol_no_mouse_hover)) {
848 $notooltip = 1; // Force disable tooltips
849 }
850
851 $result = '';
852 $params = [
853 'id' => (string) $this->id,
854 'objecttype' => $this->element.($this->module ? '@'.$this->module : ''),
855 'option' => $option,
856 ];
857 $classfortooltip = 'classfortooltip';
858 $dataparams = '';
859 if (getDolGlobalInt('MAIN_ENABLE_AJAX_TOOLTIP')) {
860 $classfortooltip = 'classforajaxtooltip';
861 $dataparams = ' data-params="'.dol_escape_htmltag(json_encode($params)).'"';
862 $label = '';
863 } else {
864 $label = implode($this->getTooltipContentArray($params));
865 }
866
867 $baseurl = DOL_URL_ROOT . '/recruitment/recruitmentjobposition_card.php';
868 $query = ['id' => $this->id];
869 if ($option !== 'nolink') {
870 // Add param to save lastsearch_values or not
871 $add_save_lastsearch_values = ($save_lastsearch_value == 1 ? 1 : 0);
872 if ($save_lastsearch_value == -1 && isset($_SERVER["PHP_SELF"]) && preg_match('/list\.php/', $_SERVER["PHP_SELF"])) {
873 $add_save_lastsearch_values = 1;
874 }
875 if ($add_save_lastsearch_values) {
876 $query += ['save_lastsearch_values' => 1];
877 }
878 }
879 $url = dolBuildUrl($baseurl, $query);
880
881 $linkclose = '';
882 if (empty($notooltip)) {
883 if (getDolGlobalInt('MAIN_OPTIMIZEFORTEXTBROWSER')) {
884 $label = $langs->trans("ShowPositionToBeFilled");
885 $linkclose .= ' alt="'.dolPrintHTMLForAttribute($label).'"';
886 }
887 $linkclose .= ($label ? ' title="'.dolPrintHTMLForAttribute($label).'"' : ' title="tocomplete"');
888 $linkclose .= $dataparams.' class="'.$classfortooltip.($morecss ? ' '.$morecss : '').'"';
889 } else {
890 $linkclose = ($morecss ? ' class="'.$morecss.'"' : '');
891 }
892
893 $linkstart = '<a href="'.$url.'"';
894 $linkstart .= $linkclose.'>';
895 $linkend = '</a>';
896
897 $result .= $linkstart;
898
899 if (empty($this->showphoto_on_popup)) {
900 if ($withpicto) {
901 $result .= img_object(($notooltip ? '' : $label), ($this->picto ? $this->picto : 'generic'), ($notooltip ? (($withpicto != 2) ? 'class="paddingright"' : '') : 'class="'.(($withpicto != 2) ? 'paddingright ' : '').'classfortooltip"'), 0, 0, $notooltip ? 0 : 1);
902 }
903 } else {
904 if ($withpicto) {
905 require_once DOL_DOCUMENT_ROOT.'/core/lib/files.lib.php';
906
907 list($class, $module) = explode('@', $this->picto);
908 $upload_dir = $conf->$module->multidir_output[$conf->entity]."/$class/".dol_sanitizeFileName($this->ref);
909 $filearray = dol_dir_list($upload_dir, "files");
910 $filename = $filearray[0]['name'];
911 if (!empty($filename)) {
912 $pospoint = strpos($filearray[0]['name'], '.');
913
914 $pathtophoto = $class.'/'.$this->ref.'/thumbs/'.dol_substr($filename, 0, $pospoint).'_mini'.dol_substr($filename, $pospoint);
915 if (!getDolGlobalString(strtoupper($module.'_'.$class).'_FORMATLISTPHOTOSASUSERS')) {
916 $result .= '<div class="floatleft inline-block valignmiddle divphotoref"><div class="photoref"><img class="photo'.$module.'" alt="No photo" border="0" src="'.DOL_URL_ROOT.'/viewimage.php?modulepart='.$module.'&entity='.$conf->entity.'&file='.urlencode($pathtophoto).'"></div></div>';
917 } else {
918 $result .= '<div class="floatleft inline-block valignmiddle divphotoref"><img class="photouserphoto userphoto" alt="No photo" border="0" src="'.DOL_URL_ROOT.'/viewimage.php?modulepart='.$module.'&entity='.$conf->entity.'&file='.urlencode($pathtophoto).'"></div>';
919 }
920
921 $result .= '</div>';
922 } else {
923 $result .= img_object(($notooltip ? '' : $label), ($this->picto ? $this->picto : 'generic'), ($notooltip ? (($withpicto != 2) ? 'class="paddingright"' : '') : 'class="'.(($withpicto != 2) ? 'paddingright ' : '').'classfortooltip"'), 0, 0, $notooltip ? 0 : 1);
924 }
925 }
926 }
927
928 if ($withpicto != 2) {
929 $result .= $this->ref;
930 }
931
932 $result .= $linkend;
933 //if ($withpicto != 2) $result.=(($addlabel && $this->label) ? $sep . dol_trunc($this->label, ($addlabel > 1 ? $addlabel : 0)) : '');
934
935 global $action, $hookmanager;
936 $hookmanager->initHooks(array('recruitmentjobpositiondao'));
937 $parameters = array('id' => $this->id, 'getnomurl' => &$result);
938 $reshook = $hookmanager->executeHooks('getNomUrl', $parameters, $this, $action); // Note that $action and $object may have been modified by some hooks
939 if ($reshook > 0) {
940 $result = $hookmanager->resPrint;
941 } else {
942 $result .= $hookmanager->resPrint;
943 }
944
945 return $result;
946 }
947
954 public function getLibStatut($mode = 0)
955 {
956 return $this->LibStatut($this->status, $mode);
957 }
958
959 // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
967 public function LibStatut($status, $mode = 0)
968 {
969 // phpcs:enable
970 if (empty($this->labelStatus) || empty($this->labelStatusShort)) {
971 global $langs;
972 //$langs->load("recruitment");
973 $this->labelStatus[self::STATUS_DRAFT] = $langs->transnoentitiesnoconv('Draft');
974 $this->labelStatus[self::STATUS_VALIDATED] = $langs->transnoentitiesnoconv('Validated');
975 $this->labelStatus[self::STATUS_RECRUITED] = $langs->transnoentitiesnoconv('Recruited');
976 $this->labelStatus[self::STATUS_CANCELED] = $langs->transnoentitiesnoconv('Canceled');
977 $this->labelStatusShort[self::STATUS_DRAFT] = $langs->transnoentitiesnoconv('Draft');
978 $this->labelStatusShort[self::STATUS_VALIDATED] = $langs->transnoentitiesnoconv('Validated');
979 $this->labelStatusShort[self::STATUS_RECRUITED] = $langs->transnoentitiesnoconv('Recruited');
980 $this->labelStatusShort[self::STATUS_CANCELED] = $langs->transnoentitiesnoconv('Canceled');
981 }
982
983 $statusType = 'status'.$status;
984 if ($status == self::STATUS_VALIDATED) {
985 $statusType = 'status4';
986 }
987 if ($status == self::STATUS_RECRUITED) {
988 $statusType = 'status6';
989 }
990 if ($status == self::STATUS_CANCELED) {
991 $statusType = 'status9';
992 }
993
994 return dolGetStatus($this->labelStatus[$status], $this->labelStatusShort[$status], '', $statusType, $mode);
995 }
996
1003 public function info($id)
1004 {
1005 $sql = 'SELECT rowid, date_creation as datec, tms as datem,';
1006 $sql .= ' fk_user_creat, fk_user_modif';
1007 $sql .= ' FROM '.MAIN_DB_PREFIX.$this->table_element.' as t';
1008 $sql .= ' WHERE t.rowid = '.((int) $id);
1009 $result = $this->db->query($sql);
1010 if ($result) {
1011 if ($this->db->num_rows($result)) {
1012 $obj = $this->db->fetch_object($result);
1013
1014 $this->id = $obj->rowid;
1015
1016 $this->user_creation_id = $obj->fk_user_creat;
1017 $this->user_modification_id = $obj->fk_user_modif;
1018 $this->date_creation = $this->db->jdate($obj->datec);
1019 $this->date_modification = empty($obj->datem) ? '' : $this->db->jdate($obj->datem);
1020 }
1021
1022 $this->db->free($result);
1023 } else {
1024 dol_print_error($this->db);
1025 }
1026 }
1027
1034 public function initAsSpecimen()
1035 {
1036 return $this->initAsSpecimenCommon();
1037 }
1038
1044 public function getLinesArray()
1045 {
1046 $this->lines = array();
1047
1048 return $this->lines;
1049 }
1050
1056 public function getNextNumRef()
1057 {
1058 global $langs, $conf;
1059 $langs->load("recruitment");
1060
1061 if (!getDolGlobalString('RECRUITMENT_RECRUITMENTJOBPOSITION_ADDON')) {
1062 $conf->global->RECRUITMENT_RECRUITMENTJOBPOSITION_ADDON = 'mod_recruitmentjobposition_standard';
1063 }
1064
1065 if (getDolGlobalString('RECRUITMENT_RECRUITMENTJOBPOSITION_ADDON')) {
1066 $mybool = false;
1067
1068 $file = getDolGlobalString('RECRUITMENT_RECRUITMENTJOBPOSITION_ADDON') . ".php";
1069 $classname = getDolGlobalString('RECRUITMENT_RECRUITMENTJOBPOSITION_ADDON');
1070
1071 // Include file with class
1072 $dirmodels = array_merge(array('/'), (array) $conf->modules_parts['models']);
1073 foreach ($dirmodels as $reldir) {
1074 $dir = dol_buildpath($reldir."core/modules/recruitment/");
1075
1076 // Load file with numbering class (if found)
1077 $mybool = ((bool) @include_once $dir.$file) || $mybool;
1078 }
1079
1080 if (!$mybool) {
1081 dol_print_error(null, "Failed to include file ".$file);
1082 return '';
1083 }
1084
1085 if (class_exists($classname)) {
1086 $obj = new $classname();
1087 '@phan-var-force ModeleNumRefRecruitmentJobPosition $obj';
1088 $numref = $obj->getNextValue($this);
1089
1090 if ($numref != '' && $numref != '-1') {
1091 return $numref;
1092 } else {
1093 $this->error = $obj->error;
1094 //dol_print_error($this->db,get_class($this)."::getNextNumRef ".$obj->error);
1095 return "";
1096 }
1097 } else {
1098 print $langs->trans("Error")." ".$langs->trans("ClassNotFound").' '.$classname;
1099 return "";
1100 }
1101 } else {
1102 print $langs->trans("ErrorNumberingModuleNotSetup", $this->element);
1103 return "";
1104 }
1105 }
1106
1118 public function generateDocument($modele, $outputlangs, $hidedetails = 0, $hidedesc = 0, $hideref = 0, $moreparams = null)
1119 {
1120 global $conf, $langs;
1121
1122 $result = 0;
1123 $includedocgeneration = 1;
1124
1125 $langs->load("recruitment");
1126
1127 if (!dol_strlen($modele)) {
1128 if (getDolGlobalString('RECRUITMENTJOBPOSITION_ADDON_PDF')) {
1129 $modele = getDolGlobalString('RECRUITMENTJOBPOSITION_ADDON_PDF');
1130 } else {
1131 $modele = ''; // No default value. For job position, we allow to disable all PDF generation
1132 }
1133 }
1134
1135 $modelpath = "core/modules/recruitment/doc/";
1136
1137 if ($includedocgeneration && !empty($modele)) {
1138 $result = $this->commonGenerateDocument($modelpath, $modele, $outputlangs, $hidedetails, $hidedesc, $hideref, $moreparams);
1139 }
1140
1141 return $result;
1142 }
1143
1151 public function doScheduledJob()
1152 {
1153 //global $conf, $langs;
1154
1155 //$conf->global->SYSLOG_FILE = 'DOL_DATA_ROOT/dolibarr_mydedicatedlofile.log';
1156
1157 $error = 0;
1158 $this->output = '';
1159 $this->error = '';
1160
1161 dol_syslog(__METHOD__, LOG_DEBUG);
1162
1163 $now = dol_now();
1164
1165 $this->db->begin();
1166
1167 // ...
1168
1169 $this->db->commit();
1170
1171 return $error;
1172 }
1173
1174
1182 public function getKanbanView($option = '', $arraydata = null)
1183 {
1184 global $langs;
1185
1186 $selected = (empty($arraydata['selected']) ? 0 : $arraydata['selected']);
1187
1188 $return = '<div class="box-flex-item box-flex-grow-zero">';
1189 $return .= '<div class="info-box info-box-sm">';
1190 $return .= '<span class="info-box-icon bg-infobox-action">';
1191 $return .= img_picto('', $this->picto);
1192 $return .= '</span>';
1193 $return .= '<div class="info-box-content">';
1194 $return .= '<span class="info-box-ref inline-block tdoverflowmax150 valignmiddle">'.(method_exists($this, 'getNomUrl') ? $this->getNomUrl(1) : $this->ref).($this->qty > 1 ? ' <span title="'.$langs->trans("NbOfEmployeesExpected").'">('.$this->qty.')</span>' : '').'</span>';
1195 if ($selected >= 0) {
1196 $return .= '<input id="cb'.$this->id.'" class="flat checkforselect fright" type="checkbox" name="toselect[]" value="'.$this->id.'"'.($selected ? ' checked="checked"' : '').'>';
1197 }
1198 /*
1199 if (property_exists($this, 'date_planned')) {
1200 $return .= '<br><span class="opacitymedium">'.$langs->trans("Date").'</span> : <span class="info-box-label">'.dol_print_date($this->db->jdate($this->date_planned), 'day').'</span>';
1201 }*/
1202 if (property_exists($this, 'remuneration_suggested')) {
1203 $return .= '<br><span class="opacitymedium">'.$langs->trans("Remuneration").'</span> : <span class="info-box-label">'.$this->remuneration_suggested.'</span>';
1204 }
1205 if (method_exists($this, 'getLibStatut')) {
1206 $return .= '<br><div class="info-box-status">'.$this->getLibStatut(3).' &nbsp; <span class="opacitymedium" title="'.$langs->trans("RecruitmentCandidatures").'">'.$langs->trans("RecruitmentCandidatures", '', '', '', '', 5).'</span> : <span>';
1207 $return .= $arraydata['nbapplications'];
1208 $return .= '</span></div>';
1209 }
1210 $return .= '</div>';
1211 $return .= '</div>';
1212 $return .= '</div>';
1213 return $return;
1214 }
1215}
if(! $sortfield) if(! $sortorder) $object
Definition account.php:100
$object ref
Definition info.php:90
if(!isModEnabled('ai')||!getDolGlobalString('AI_ASSISTANT_ENABLED')) global $conf
The main.inc.php has been included so the following variable are now defined:
deleteLineCommon(User $user, $idline, $notrigger=0)
Delete a line of object in database.
commonGenerateDocument($modelspath, $modele, $outputlangs, $hidedetails, $hidedesc, $hideref, $moreparams=null)
Common function for all objects extending CommonObject for generating documents.
setErrorsFromObject($object)
setErrorsFromObject
createCommon(User $user, $notrigger=0)
Create object in the database.
getFieldList($alias='', $excludefields=array())
Function to concat keys of fields.
updateCommon(User $user, $notrigger=0)
Update object into database.
setStatusCommon($user, $status, $notrigger=0, $triggercode='')
Set to a status.
initAsSpecimenCommon()
Initialise object with example values Id must be 0 if object instance is a specimen.
copy_linked_contact($objFrom, $source='internal')
Copy contact from one element to current.
fetchLinesCommon($morewhere='', $noextrafields=0)
Load object in memory from the database.
fetchCommon($id, $ref=null, $morewhere='', $noextrafields=0)
Load object in memory from the database.
deleteCommon(User $user, $notrigger=0, $forcechilddeletion=0)
Delete object in database.
Class to manage Dolibarr database access.
Class for RecruitmentJobPosition.
validate($user, $notrigger=0)
Validate object.
deleteLine(User $user, $idline, $notrigger=0)
Delete a line of object in database.
generateDocument($modele, $outputlangs, $hidedetails=0, $hidedesc=0, $hideref=0, $moreparams=null)
Create a document onto disk according to template module.
info($id)
Load the info information in the object.
getTooltipContentArray($params)
getTooltipContentArray
cloture($user, $status, $note="", $notrigger=0)
Close the recruitment.
getNomUrl($withpicto=0, $option='', $notooltip=0, $morecss='', $save_lastsearch_value=-1)
Return a link to the object card (with optionally the picto)
doScheduledJob()
Action executed by scheduler CAN BE A CRON TASK.
setDraft($user, $notrigger=0)
Set draft status.
getLibStatut($mode=0)
Return label of the status.
create(User $user, $notrigger=0)
Create object into database.
LibStatut($status, $mode=0)
Return the status.
getLinesArray()
Create an array of lines.
reopen($user, $notrigger=0)
Set back to validated status.
getKanbanView($option='', $arraydata=null)
Return clickable link of object (with eventually picto)
fetchAll($sortorder='', $sortfield='', $limit=0, $offset=0, $filter='', $filtermode='AND')
Load list of objects in memory from the database.
update(User $user, $notrigger=0)
Update object into database.
fetch($id, $ref=null)
Load object in memory from the database.
cancel($user, $notrigger=0)
Set cancel status.
createFromClone(User $user, $fromid)
Clone an object into another one.
initAsSpecimen()
Initialise object with example values Id must be 0 if object instance is a specimen.
getNextNumRef()
Returns the reference to the following non used object depending on the active numbering module.
fetchLines()
Load object lines in memory from the database.
Class to manage translations.
Class to manage Dolibarr users.
print $langs trans("Ref").' m titre as m m statut as status
Or an array listing all the potential status of the object: array: int of the status => translated la...
Definition index.php:169
dol_dir_list($utf8_path, $types="all", $recursive=0, $filter="", $excludefilter=null, $sortcriteria="name", $sortorder=SORT_ASC, $mode=0, $nohook=0, $relativename="", $donotfollowsymlinks=0, $nbsecondsold=0)
Scan a directory and return a list of files/directories.
Definition files.lib.php:66
dol_now($mode='gmt')
Return date for now.
dol_strlen($string, $stringencoding='UTF-8', $binarycount=0)
Make a strlen call.
dolBuildUrl($url, $params=[], $addtoken=false, $anchor='')
Return path of url.
dol_sanitizeFileName($str, $newstr='_', $unaccent=1, $includequotes=0, $allowdash=0)
Clean a string to use it as a file name.
getDolGlobalInt($key, $default=0)
Return a Dolibarr global constant int value.
GETPOST($paramname, $check='alphanohtml', $method=0, $filter=null, $options=null, $noreplace=0, $nodefault=0)
Return value of a param into GET or POST supervariable.
dol_concatdesc($text1, $text2, $forxml=false, $invert=false)
Concat 2 descriptions with a new line between them (second operand after first one with appropriate n...
forgeSQLFromUniversalSearchCriteria($filter, &$errorstr='', $noand=0, $nopar=0, $noerror=0, $forbiddenfields=array())
forgeSQLFromUniversalSearchCriteria
dol_substr($string, $start, $length=null, $stringencoding='', $trunconbytes=0)
Make a substring.
dol_buildpath($path, $type=0, $returnemptyifnotfound=0)
Return path of url or filesystem.
getDolGlobalString($key, $default='')
Return a Dolibarr global constant string value.
isModEnabled($module)
Is Dolibarr module enabled.
dol_syslog($message, $level=LOG_INFO, $ident=0, $suffixinfilename='', $restricttologhandler='', $logcontext=null)
Write log message into outputs.