31require_once DOL_DOCUMENT_ROOT.
'/core/class/commonobjectline.class.php';
41 public $module =
'hrm';
46 public $element =
'skilldet';
51 public $table_element =
'hrm_skilldet';
66 public $picto =
'skilldet@hrm';
69 const STATUS_DRAFT = 0;
70 const STATUS_VALIDATED = 1;
71 const STATUS_CANCELED = 9;
104 public $fields = array(
105 'rowid' => array(
'type' =>
'integer',
'label' =>
'TechnicalID',
'enabled' => 1,
'position' => 1,
'notnull' => 1,
'visible' => 0,
'noteditable' => 1,
'index' => 1,
'css' =>
'left',
'comment' =>
"Id"),
106 'fk_skill' => array(
'type' =>
'integer:Skill:/hrm/class/skill.class.php',
'label' =>
'fk_skill',
'enabled' => 1,
'position' => 5,
'notnull' => 1,
'visible' => 0,),
107 'rankorder' => array(
'type' =>
'integer',
'label' =>
'rank',
'enabled' => 1,
'position' => 10,
'notnull' => 0,
'visible' => 2,),
108 'description' => array(
'type' =>
'text',
'label' =>
'Description',
'enabled' => 1,
'position' => 60,
'notnull' => 0,
'visible' => 1,),
109 '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',),
110 'fk_user_modif' => array(
'type' =>
'integer:User:user/class/user.class.php',
'label' =>
'UserModif',
'enabled' => 1,
'position' => 511,
'notnull' => -1,
'visible' => 0,),
131 public $fk_user_creat;
135 public $fk_user_modif;
186 $this->ismultientitymanaged = 0;
187 $this->isextrafieldmanaged = 1;
190 $this->fields[
'rowid'][
'visible'] = 0;
192 if (!
isModEnabled(
'multicompany') && isset($this->fields[
'entity'])) {
193 $this->fields[
'entity'][
'enabled'] = 0;
197 foreach ($this->fields as $key => $val) {
198 if (isset($val[
'enabled']) && empty($val[
'enabled'])) {
199 unset($this->fields[$key]);
204 if (is_object($langs)) {
205 foreach ($this->fields as $key => $val) {
206 if (!empty($val[
'arrayofkeyval']) && is_array($val[
'arrayofkeyval'])) {
207 foreach ($val[
'arrayofkeyval'] as $key2 => $val2) {
208 $this->fields[$key][
'arrayofkeyval'][$key2] = $langs->trans($val2);
228 return $resultcreate;
251 $result =
$object->fetchCommon($fromid);
252 if ($result > 0 && !empty(
$object->table_element_line)) {
263 unset(
$object->user_creation_id);
267 if (property_exists(
$object,
'ref')) {
268 $object->ref = empty($this->fields[
'ref'][
'default']) ?
"Copy_Of_".$object->ref : $this->fields[
'ref'][
'default'];
270 if (property_exists(
$object,
'status')) {
271 $object->status = self::STATUS_DRAFT;
273 if (property_exists(
$object,
'date_creation')) {
276 if (property_exists(
$object,
'date_modification')) {
277 $object->date_modification =
null;
281 if (is_array(
$object->array_options) && count(
$object->array_options) > 0) {
282 $extrafields->fetch_name_optionals_label($this->table_element);
283 foreach (
$object->array_options as $key => $option) {
284 $shortkey = preg_replace(
'/options_/',
'', $key);
285 if (!empty($extrafields->attributes[$this->table_element][
'unique'][$shortkey])) {
287 unset(
$object->array_options[$key]);
293 $object->context[
'createfromclone'] =
'createfromclone';
294 $result =
$object->createCommon($user);
307 unset(
$object->context[
'createfromclone']);
314 $this->db->rollback();
326 public function fetch($id, $ref =
null)
329 if ($result > 0 && !empty($this->table_element_line)) {
342 $this->lines = array();
361 public function fetchAll($sortorder =
'', $sortfield =
'', $limit = 0, $offset = 0, $filter =
'', $filtermode =
'AND')
369 $sql .=
' FROM '.MAIN_DB_PREFIX.$this->table_element.
' as t';
370 if (isset($this->ismultientitymanaged) && $this->ismultientitymanaged == 1) {
371 $sql .=
' WHERE t.entity IN ('.getEntity($this->element).
')';
373 $sql .=
' WHERE 1 = 1';
380 $this->errors[] = $errormessage;
381 dol_syslog(__METHOD__.
' '.implode(
',', $this->errors), LOG_ERR);
385 if (!empty($sortfield)) {
386 $sql .= $this->db->order($sortfield, $sortorder);
388 if (!empty($limit)) {
389 $sql .=
" ".$this->db->plimit($limit, $offset);
392 $resql = $this->db->query($sql);
394 $num = $this->db->num_rows($resql);
396 while ($i < ($limit ? min($limit, $num) : $num)) {
397 $obj = $this->db->fetch_object($resql);
399 $record =
new self($this->db);
400 $record->setVarsFromFetchObj($obj);
402 $records[$record->id] = $record;
406 $this->db->free($resql);
410 $this->errors[] =
'Error '.$this->db->lasterror();
411 dol_syslog(__METHOD__.
' '.implode(
',', $this->errors), LOG_ERR);
436 public function delete(
User $user, $notrigger = 0)
453 $this->error =
'ErrorDeleteLineNotAllowedByObjectStatus';
472 require_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
477 if ($this->
status == self::STATUS_VALIDATED) {
478 dol_syslog(get_class($this).
"::validate action abandoned: already validated", LOG_WARNING);
495 if (preg_match(
'/^[\(]?PROV/i', $this->
ref) || empty($this->
ref)) {
498 $num = (string) $this->
ref;
500 $this->newref = $num;
504 $sql =
"UPDATE ".MAIN_DB_PREFIX.$this->table_element;
505 $sql .=
" SET ref = '".$this->db->escape($num).
"',";
506 $sql .=
" status = ".self::STATUS_VALIDATED;
507 if (!empty($this->fields[
'date_validation'])) {
508 $sql .=
", date_validation = '".$this->db->idate($now).
"'";
510 if (!empty($this->fields[
'fk_user_valid'])) {
511 $sql .=
", fk_user_valid = ".((int) $user->id);
513 $sql .=
" WHERE rowid = ".((int) $this->
id);
515 dol_syslog(get_class($this).
"::validate()", LOG_DEBUG);
516 $resql = $this->db->query($sql);
518 dol_print_error($this->db);
519 $this->error = $this->db->lasterror();
523 if (!$error && !$notrigger) {
525 $result = $this->call_trigger(
'HRM_SKILLDET_VALIDATE', $user);
534 $this->oldref = $this->ref;
537 if (preg_match(
'/^[\(]?PROV/i', $this->
ref)) {
539 $sql =
'UPDATE '.MAIN_DB_PREFIX.
"ecm_files set filename = CONCAT('".$this->db->escape($this->newref).
"', SUBSTR(filename, ".(strlen($this->
ref) + 1).
")), filepath = 'skilldet/".$this->db->escape($this->newref).
"'";
540 $sql .=
" WHERE filename LIKE '".$this->db->escape($this->
ref).
"%' AND filepath = 'skilldet/".$this->db->escape($this->
ref).
"' and entity = ".((int)
$conf->entity);
541 $resql = $this->db->query($sql);
544 $this->error = $this->db->lasterror();
546 $sql =
'UPDATE '.MAIN_DB_PREFIX.
"ecm_files set filepath = 'skilldet/".$this->db->escape($this->newref).
"'";
547 $sql .=
" WHERE filepath = 'skilldet/".$this->db->escape($this->
ref).
"' and entity = ".((int)
$conf->entity);
548 $resql = $this->db->query($sql);
551 $this->error = $this->db->lasterror();
557 $dirsource =
$conf->hrm->dir_output.
'/skilldet/'.$oldref;
558 $dirdest =
$conf->hrm->dir_output.
'/skilldet/'.$newref;
559 if (!$error && file_exists($dirsource)) {
560 dol_syslog(get_class($this).
"::validate() rename dir ".$dirsource.
" into ".$dirdest);
562 if (@rename($dirsource, $dirdest)) {
565 $listoffiles =
dol_dir_list(
$conf->hrm->dir_output.
'/skilldet/'.$newref,
'files', 1,
'^'.preg_quote($oldref,
'/'));
566 foreach ($listoffiles as $fileentry) {
567 $dirsource = $fileentry[
'name'];
568 $dirdest = preg_replace(
'/^'.preg_quote($oldref,
'/').
'/', $newref, $dirsource);
569 $dirsource = $fileentry[
'path'].
'/'.$dirsource;
570 $dirdest = $fileentry[
'path'].
'/'.$dirdest;
571 @rename($dirsource, $dirdest);
581 $this->
status = self::STATUS_VALIDATED;
588 $this->db->rollback();
604 if ($this->
status <= self::STATUS_DRAFT) {
615 return $this->
setStatusCommon($user, self::STATUS_DRAFT, $notrigger,
'SKILLDET_UNVALIDATE');
625 public function cancel($user, $notrigger = 0)
628 if ($this->
status != self::STATUS_VALIDATED) {
639 return $this->
setStatusCommon($user, self::STATUS_CANCELED, $notrigger,
'SKILLDET_CANCEL');
649 public function reopen($user, $notrigger = 0)
652 if ($this->
status != self::STATUS_CANCELED) {
663 return $this->
setStatusCommon($user, self::STATUS_VALIDATED, $notrigger,
'SKILLDET_REOPEN');
676 public function getNomUrl($withpicto = 0, $option =
'', $notooltip = 0, $morecss =
'', $save_lastsearch_value = -1)
678 global
$conf, $langs, $hookmanager;
680 if (!empty(
$conf->dol_no_mouse_hover)) {
686 $label = img_picto(
'', $this->picto).
' <u>'.$langs->trans(
"Skilldet").
'</u>';
687 if (isset($this->
status)) {
688 $label .=
' '.$this->getLibStatut(5);
691 $label .=
'<b>'.$langs->trans(
'Ref').
':</b> '.$this->ref;
693 $url =
dol_buildpath(
'/hrm/skilldet_card.php', 1).
'?id='.$this->id;
695 if ($option !=
'nolink') {
697 $add_save_lastsearch_values = ($save_lastsearch_value == 1 ? 1 : 0);
698 if ($save_lastsearch_value == -1 && isset($_SERVER[
"PHP_SELF"]) && preg_match(
'/list\.php/', $_SERVER[
"PHP_SELF"])) {
699 $add_save_lastsearch_values = 1;
701 if ($add_save_lastsearch_values) {
702 $url .=
'&save_lastsearch_values=1';
707 if (empty($notooltip)) {
709 $label = $langs->trans(
"ShowSkilldet");
710 $linkclose .=
' alt="'.dolPrintHTMLForAttribute($label).
'"';
712 $linkclose .=
' title="'.dolPrintHTMLForAttribute($label).
'"';
713 $linkclose .=
' class="classfortooltip'.($morecss ?
' '.$morecss :
'').
'"';
715 $linkclose = ($morecss ?
' class="'.$morecss.
'"' :
'');
718 if ($option ==
'nolink') {
719 $linkstart =
'<span';
721 $linkstart =
'<a href="'.$url.
'"';
723 $linkstart .= $linkclose.
'>';
724 if ($option ==
'nolink') {
725 $linkend =
'</span>';
730 $result .= $linkstart;
732 if (empty($this->showphoto_on_popup)) {
734 $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);
738 require_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
740 list($class, $module) = explode(
'@', $this->picto);
743 $filename = $filearray[0][
'name'];
744 if (!empty($filename)) {
745 $pospoint = strpos($filearray[0][
'name'],
'.');
747 $pathtophoto = $class.
'/'.$this->
ref.
'/thumbs/'.
dol_substr($filename, 0, $pospoint).
'_mini'.
dol_substr($filename, $pospoint);
749 $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>';
751 $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>';
756 $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);
761 if ($withpicto != 2) {
762 $result .= $this->ref;
768 global $action, $hookmanager;
769 $hookmanager->initHooks(array(
'skilldetdao'));
770 $parameters = array(
'id' => $this->
id,
'getnomurl' => &$result);
771 $reshook = $hookmanager->executeHooks(
'getNomUrl', $parameters, $this, $action);
773 $result = $hookmanager->resPrint;
775 $result .= $hookmanager->resPrint;
803 if (empty($this->labelStatus) || empty($this->labelStatusShort)) {
806 $this->labelStatus[self::STATUS_DRAFT] = $langs->transnoentitiesnoconv(
'Draft');
807 $this->labelStatus[self::STATUS_VALIDATED] = $langs->transnoentitiesnoconv(
'Enabled');
808 $this->labelStatus[self::STATUS_CANCELED] = $langs->transnoentitiesnoconv(
'Disabled');
809 $this->labelStatusShort[self::STATUS_DRAFT] = $langs->transnoentitiesnoconv(
'Draft');
810 $this->labelStatusShort[self::STATUS_VALIDATED] = $langs->transnoentitiesnoconv(
'Enabled');
811 $this->labelStatusShort[self::STATUS_CANCELED] = $langs->transnoentitiesnoconv(
'Disabled');
814 $statusType =
'status'.$status;
816 if ($status == self::STATUS_CANCELED) {
817 $statusType =
'status6';
820 return dolGetStatus($this->labelStatus[$status], $this->labelStatusShort[$status],
'', $statusType, $mode);
831 $sql =
'SELECT rowid, date_creation as datec, tms as datem,';
832 $sql .=
' fk_user_creat, fk_user_modif';
833 $sql .=
' FROM '.MAIN_DB_PREFIX.$this->table_element.
' as t';
834 $sql .=
' WHERE t.rowid = '.((int) $id);
835 $result = $this->db->query($sql);
837 if ($this->db->num_rows($result)) {
838 $obj = $this->db->fetch_object($result);
840 $this->
id = $obj->rowid;
842 $this->user_creation_id = $obj->fk_user_creat;
843 $this->user_modification_id = $obj->fk_user_modif;
844 $this->date_creation = $this->db->jdate($obj->datec);
845 $this->date_modification = empty($obj->datem) ?
'' : $this->db->jdate($obj->datem);
848 $this->db->free($result);
850 dol_print_error($this->db);
877 global $langs,
$conf;
881 $conf->global->hrm_SKILLDET_ADDON =
'mod_skilldet_standard';
891 $dirmodels = array_merge(array(
'/'), (array)
$conf->modules_parts[
'models']);
892 foreach ($dirmodels as $reldir) {
896 $mybool = ((bool) @include_once $dir.$file) || $mybool;
900 dol_print_error(
null,
"Failed to include file ".$file);
904 if (class_exists($classname)) {
905 $obj =
new $classname();
906 '@phan-var-force ModeleNumRefEvaluation $obj';
907 $numref = $obj->getNextValue($this);
909 if ($numref !=
'' && $numref !=
'-1') {
912 $this->error = $obj->error;
917 print $langs->trans(
"Error").
" ".$langs->trans(
"ClassNotFound").
' '.$classname;
921 print $langs->trans(
"ErrorNumberingModuleNotSetup", $this->element);
937 public function generateDocument($modele, $outputlangs, $hidedetails = 0, $hidedesc = 0, $hideref = 0, $moreparams =
null)
942 $includedocgeneration = 0;
947 $modele =
'standard_skilldet';
949 if (!empty($this->model_pdf)) {
950 $modele = $this->model_pdf;
956 $modelpath =
"core/modules/hrm/doc/";
958 if ($includedocgeneration && !empty($modele)) {
959 $result = $this->
commonGenerateDocument($modelpath, $modele, $outputlangs, $hidedetails, $hidedesc, $hideref, $moreparams);
if(! $sortfield) if(! $sortorder) $object
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.
Parent class for class inheritance lines of business objects This class is useless for the moment so ...
Class to manage Dolibarr database access.
generateDocument($modele, $outputlangs, $hidedetails=0, $hidedesc=0, $hideref=0, $moreparams=null)
Create a document onto disk according to template module.
update(User $user, $notrigger=0)
Update object into database.
fetchAll($sortorder='', $sortfield='', $limit=0, $offset=0, $filter='', $filtermode='AND')
Load list of objects in memory from the database.
getNextNumRef()
Returns the reference to the following non used object depending on the active numbering module.
initAsSpecimen()
Initialise object with example values Id must be 0 if object instance is a specimen.
cancel($user, $notrigger=0)
Set cancel status.
getLibStatut($mode=0)
Return the label of the status.
getNomUrl($withpicto=0, $option='', $notooltip=0, $morecss='', $save_lastsearch_value=-1)
Return a link to the object card (with optionally the picto)
create(User $user, $notrigger=0)
Create object into database.
LibStatut($status, $mode=0)
Return the status.
fetchLines()
Load object lines in memory from the database.
deleteLine(User $user, $idline, $notrigger=0)
Delete a line of object in database.
__construct(DoliDB $db)
Constructor.
fetch($id, $ref=null)
Load object in memory from the database.
createFromClone(User $user, $fromid)
Clone an object into another one.
validate($user, $notrigger=0)
Validate object.
info($id)
Load the info information in the object.
reopen($user, $notrigger=0)
Set back to validated status.
setDraft($user, $notrigger=0)
Set draft status.
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...
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.
dol_now($mode='gmt')
Return date for now.
dol_strlen($string, $stringencoding='UTF-8', $binarycount=0)
Make a strlen call.
dol_sanitizeFileName($str, $newstr='_', $unaccent=1, $includequotes=0, $allowdash=0)
Clean a string to use it as a file name.
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.