dolibarr 22.0.5
workstation.class.php
Go to the documentation of this file.
1<?php
2/* Copyright (C) 2017 Laurent Destailleur <eldy@users.sourceforge.net>
3 * Copyright (C) 2020 Gauthier VERDOL <gauthier.verdol@atm-consulting.fr>
4 * Copyright (C) 2023-2024 Frédéric France <frederic.france@free.fr>
5 * Copyright (C) 2024-2025 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
34{
38 public $module = 'workstation';
39
43 public $element = 'workstation';
44
48 public $table_element = 'workstation_workstation';
49
54 public $ismultientitymanaged = 1;
55
59 public $isextrafieldmanaged = 0;
60
64 public $picto = 'workstation';
65
66
67 const STATUS_DISABLED = 0;
68 const STATUS_ENABLED = 1;
69
70
97 // BEGIN MODULEBUILDER PROPERTIES
101 public $fields = array(
102 'rowid' => array('type' => 'integer', 'label' => 'TechnicalID', 'enabled' => 1, 'position' => 1, 'notnull' => 1, 'visible' => 0, 'noteditable' => 1, 'index' => 1, 'css' => 'left', 'comment' => "Id"),
103 'entity' => array('type' => 'integer', 'label' => 'Entity', 'enabled' => 1, 'visible' => 0, 'position' => 5, 'notnull' => 1, 'default' => '1', 'index' => 1),
104 'ref' => array('type' => 'varchar(128)', 'label' => 'Ref', 'enabled' => 1, 'position' => 10, 'notnull' => 1, 'visible' => 1, 'noteditable' => 0, 'default' => '', 'index' => 1, 'searchall' => 1, 'showoncombobox' => 1, 'comment' => "Reference of object", 'csslist' => 'nowraponall'),
105 'label' => array('type' => 'varchar(255)', 'label' => 'Label', 'enabled' => 1, 'position' => 30, 'notnull' => 1, 'visible' => 1, 'searchall' => 1, 'css' => 'minwidth300', 'csslist' => 'tdoverflowmax125', 'showoncombobox' => 2,),
106 'type' => array('type' => 'varchar(8)', 'label' => 'Type', 'enabled' => 1, 'position' => 32, 'default' => '1', 'notnull' => 1, 'visible' => 1, 'arrayofkeyval' => array('HUMAN' => 'Human', 'MACHINE' => 'Machine', 'BOTH' => 'HumanMachine'),),
107 'note_public' => array('type' => 'html', 'label' => 'NotePublic', 'enabled' => 1, 'position' => 61, 'notnull' => 0, 'visible' => 0,),
108 'note_private' => array('type' => 'html', 'label' => 'NotePrivate', 'enabled' => 1, 'position' => 62, 'notnull' => 0, 'visible' => 0,),
109 'date_creation' => array('type' => 'datetime', 'label' => 'DateCreation', 'enabled' => 1, 'position' => 500, 'notnull' => 1, 'visible' => -2, 'csslist' => 'nowraponall'),
110 'tms' => array('type' => 'timestamp', 'label' => 'DateModification', 'enabled' => 1, 'position' => 501, 'notnull' => 0, 'visible' => -2, 'csslist' => 'nowraponall'),
111 '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',),
112 'fk_user_modif' => array('type' => 'integer:User:user/class/user.class.php', 'label' => 'UserModif', 'enabled' => 1, 'position' => 511, 'notnull' => -1, 'visible' => -2,),
113 'import_key' => array('type' => 'varchar(14)', 'label' => 'ImportId', 'enabled' => 1, 'position' => 512, 'notnull' => -1, 'visible' => -2,),
114 'nb_operators_required' => array('type' => 'integer', 'label' => 'NbOperatorsRequired', 'enabled' => 1, 'position' => 50, 'notnull' => 0, 'visible' => 1, 'css' => 'right maxwidth50imp', 'csslist' => 'maxwidth50imp'),
115 'thm_operator_estimated' => array('type' => 'price', 'help' => 'THMOperatorEstimatedHelp','label' => 'THMOperatorEstimated', 'enabled' => 1, 'position' => 50, 'notnull' => 0, 'visible' => 1, 'css' => 'right maxwidth75imp', 'csslist' => 'maxwidth75imp'),
116 'thm_machine_estimated' => array('type' => 'price', 'help' => 'THMMachineEstimatedHelp', 'label' => 'THMMachineEstimated', 'enabled' => 1, 'position' => 50, 'notnull' => 0, 'visible' => 1, 'css' => 'right maxwidth75imp', 'csslist' => 'maxwidth75imp'),
117 'status' => array('type' => 'smallint', 'label' => 'Status', 'enabled' => 1, 'position' => 1000, 'default' => '1', 'notnull' => 1, 'visible' => 1, 'index' => 1, 'arrayofkeyval' => array(0 => 'Disabled', 1 => 'Enabled'),),
118 );
119
123 public $rowid;
124
128 public $ref;
129
133 public $label;
134
138 public $type; // HUMAN, MACHINE, ...
139
143 public $fk_user_creat;
144
148 public $fk_user_modif;
149
153 public $status;
154
158 public $nb_operators_required;
159
163 public $thm_operator_estimated;
164
168 public $thm_machine_estimated;
169
170 // END MODULEBUILDER PROPERTIES
171
175 public $resources;
176
180 public $usergroups;
181
187 public function __construct(DoliDB $db)
188 {
189 global $conf, $langs;
190
191 require_once DOL_DOCUMENT_ROOT.'/workstation/class/workstationusergroup.class.php';
192 require_once DOL_DOCUMENT_ROOT.'/workstation/class/workstationresource.class.php';
193
194 $this->db = $db;
195
196 $this->ismultientitymanaged = 1;
197 $this->isextrafieldmanaged = 0;
198
199 if (!getDolGlobalString('MAIN_SHOW_TECHNICAL_ID') && isset($this->fields['rowid'])) {
200 $this->fields['rowid']['visible'] = 0;
201 }
202 if (empty($conf->multicompany->enabled) && isset($this->fields['entity'])) {
203 $this->fields['entity']['enabled'] = 0;
204 }
205
206 // Unset fields that are disabled
207 foreach ($this->fields as $key => $val) {
208 if (isset($val['enabled']) && empty($val['enabled'])) {
209 unset($this->fields[$key]);
210 }
211 }
212
213 // Translate some data of arrayofkeyval
214 if (is_object($langs)) {
215 foreach ($this->fields as $key => $val) {
216 if (!empty($val['arrayofkeyval']) && is_array($val['arrayofkeyval'])) {
217 foreach ($val['arrayofkeyval'] as $key2 => $val2) {
218 $this->fields[$key]['arrayofkeyval'][$key2] = $langs->trans($val2);
219 }
220 }
221 }
222 }
223 }
224
232 public function create(User $user, $notrigger = 0)
233 {
234 global $db;
235
236 $id = $this->createCommon($user, $notrigger);
237
238 // Usergroups
239 $groups = GETPOST('groups', 'array:int'); // FIXME We should not GETPOST but receive array as parameter
240 if (empty($groups)) {
241 $groups = $this->usergroups; // createFromClone
242 }
243 if (!empty($groups)) {
244 foreach ($groups as $id_group) {
245 $ws_usergroup = new WorkstationUserGroup($db);
246 $ws_usergroup->fk_workstation = $id;
247 $ws_usergroup->fk_usergroup = $id_group;
248 $ws_usergroup->createCommon($user);
249 $this->usergroups[] = $id_group;
250 }
251 }
252
253 // Resources
254 $resources = GETPOST('resources', 'array:int'); // FIXME We should not GETPOST but receive array as parameter
255 if (empty($resources)) {
256 $resources = $this->resources; // createFromClone
257 }
258 if (!empty($resources)) {
259 foreach ($resources as $id_resource) {
260 $ws_resource = new WorkstationResource($db);
261 $ws_resource->fk_workstation = $id;
262 $ws_resource->fk_resource = $id_resource;
263 $ws_resource->createCommon($user);
264 $this->resources[] = $id_resource;
265 }
266 }
267
268 return $id;
269 }
270
278 public function createFromClone(User $user, $fromid)
279 {
280 global $langs, $extrafields;
281 $error = 0;
282
283 dol_syslog(__METHOD__, LOG_DEBUG);
284
285 $object = new self($this->db);
286
287 $this->db->begin();
288
289 // Load source object
290 $result = $object->fetch($fromid);
291 if ($result > 0 && !empty($object->table_element_line)) {
292 $object->fetchLines();
293 }
294
295 // get lines so they will be clone
296 //foreach($this->lines as $line)
297 // $line->fetch_optionals();
298
299 // Reset some properties
300 unset($object->id);
301 unset($object->fk_user_creat);
302 unset($object->import_key);
303
304 // Clear fields
305 if (property_exists($object, 'ref')) {
306 $object->ref = empty($this->fields['ref']['default']) ? "Copy_Of_".$object->ref : $this->fields['ref']['default'];
307 }
308 if (property_exists($object, 'label')) {
309 // @phan-suppress-next-line PhanTypeInvalidDimOffset
310 $object->label = empty($this->fields['label']['default']) ? $langs->trans("CopyOf")." ".$object->label : $this->fields['label']['default'];
311 }
312 if (property_exists($object, 'status')) {
313 $object->status = self::STATUS_DISABLED;
314 }
315 if (property_exists($object, 'date_creation')) {
316 $object->date_creation = dol_now();
317 }
318 if (property_exists($object, 'date_modification')) {
319 $object->date_modification = null;
320 }
321 // ...
322 // Clear extrafields that are unique
323 if (is_array($object->array_options) && count($object->array_options) > 0) {
324 $extrafields->fetch_name_optionals_label($this->table_element);
325 foreach ($object->array_options as $key => $option) {
326 $shortkey = preg_replace('/options_/', '', $key);
327 if (!empty($extrafields->attributes[$this->table_element]['unique'][$shortkey])) {
328 //var_dump($key);
329 //var_dump($clonedObj->array_options[$key]); exit;
330 unset($object->array_options[$key]);
331 }
332 }
333 }
334
335 // Create clone
336 $object->context['createfromclone'] = 'createfromclone';
337 $result = $object->create($user);
338 if ($result < 0) {
339 $error++;
340 $this->error = $object->error;
341 $this->errors = $object->errors;
342 }
343
344 if (!$error) {
345 // copy internal contacts
346 if ($this->copy_linked_contact($object, 'internal') < 0) {
347 $error++;
348 }
349 }
350
351 unset($object->context['createfromclone']);
352
353 // End
354 if (!$error) {
355 $this->db->commit();
356 return $object;
357 } else {
358 $this->db->rollback();
359 return -1;
360 }
361 }
362
370 public function fetch($id, $ref = null)
371 {
372 $result = $this->fetchCommon($id, $ref);
373
374 $this->usergroups = WorkstationUserGroup::getAllGroupsOfWorkstation($this->id);
375 $this->resources = WorkstationResource::getAllResourcesOfWorkstation($this->id);
376
377 if ($result > 0 && !empty($this->table_element_line)) {
378 $this->fetchLines();
379 }
380 return $result;
381 }
382
388 public function fetchLines()
389 {
390 $this->lines = array();
391
392 $result = $this->fetchLinesCommon();
393 return $result;
394 }
395
396
409 public function fetchAll($sortorder = '', $sortfield = '', $limit = 0, $offset = 0, $filter = '', $filtermode = 'AND')
410 {
411 dol_syslog(__METHOD__, LOG_DEBUG);
412
413 $records = array();
414
415 $sql = 'SELECT ';
416 $sql .= $this->getFieldList();
417 $sql .= ' FROM '.MAIN_DB_PREFIX.$this->table_element.' as t';
418 if (isset($this->ismultientitymanaged) && $this->ismultientitymanaged == 1) {
419 $sql .= ' WHERE t.entity IN ('.getEntity($this->element).')';
420 } else {
421 $sql .= ' WHERE 1 = 1';
422 }
423
424 // Manage filter
425 $errormessage = '';
426 $sql .= forgeSQLFromUniversalSearchCriteria($filter, $errormessage);
427 if ($errormessage) {
428 $this->errors[] = $errormessage;
429 dol_syslog(__METHOD__.' '.implode(',', $this->errors), LOG_ERR);
430 return -1;
431 }
432
433 if (!empty($sortfield)) {
434 $sql .= $this->db->order($sortfield, $sortorder);
435 }
436 if (!empty($limit)) {
437 $sql .= $this->db->plimit($limit, $offset);
438 }
439
440 $resql = $this->db->query($sql);
441 if ($resql) {
442 $num = $this->db->num_rows($resql);
443 $i = 0;
444 while ($i < ($limit ? min($limit, $num) : $num)) {
445 $obj = $this->db->fetch_object($resql);
446
447 $record = new self($this->db);
448 $record->setVarsFromFetchObj($obj);
449
450 $records[$record->id] = $record;
451
452 $i++;
453 }
454 $this->db->free($resql);
455
456 return $records;
457 } else {
458 $this->errors[] = 'Error '.$this->db->lasterror();
459 dol_syslog(__METHOD__.' '.implode(',', $this->errors), LOG_ERR);
460
461 return -1;
462 }
463 }
464
472 public function update(User $user, $notrigger = 0)
473 {
474
475 // Usergroups
476 $groups = GETPOST('groups', 'array:int');
478 $this->usergroups = array();
479
480 foreach ($groups as $id_group) {
481 $ws_usergroup = new WorkstationUserGroup($this->db);
482 $ws_usergroup->fk_workstation = $this->id;
483 $ws_usergroup->fk_usergroup = $id_group;
484 $ws_usergroup->createCommon($user);
485 $this->usergroups[] = $id_group;
486 }
487
488 // Resources
489 $resources = GETPOST('resources', 'array:int');
491 $this->resources = array();
492 if (!empty($resources)) {
493 foreach ($resources as $id_resource) {
494 $ws_resource = new WorkstationResource($this->db);
495 $ws_resource->fk_workstation = $this->id;
496 $ws_resource->fk_resource = $id_resource;
497 $ws_resource->createCommon($user);
498 $this->resources[] = $id_resource;
499 }
500 }
501
502 return $this->updateCommon($user, $notrigger);
503 }
504
512 public function delete(User $user, $notrigger = 0)
513 {
514 return $this->deleteCommon($user, $notrigger);
515 //return $this->deleteCommon($user, $notrigger, 1);
516 }
517
526 public function deleteLine(User $user, $idline, $notrigger = 0)
527 {
528 if ($this->status < 0) {
529 $this->error = 'ErrorDeleteLineNotAllowedByObjectStatus';
530 return -2;
531 }
532
533 return $this->deleteLineCommon($user, $idline, $notrigger);
534 }
535
543 public function setStatus($status, $notrigger = 0)
544 {
545 global $user;
546
547 $this->status = $status;
548
549 if (empty($status)) {
550 return $this->setDisabled($user, $notrigger);
551 } else {
552 return $this->setEnabled($user, $notrigger);
553 }
554 }
555
556
564 public function setEnabled($user, $notrigger = 0)
565 {
566 return $this->setStatusCommon($user, self::STATUS_ENABLED, $notrigger, 'WORKSTATION_ENABLED');
567 }
568
569
577 public function setDisabled($user, $notrigger = 0)
578 {
579 return $this->setStatusCommon($user, self::STATUS_DISABLED, $notrigger, 'WORKSTATION_DISABLED');
580 }
581
588 public function getTooltipContentArray($params)
589 {
590 global $conf, $langs;
591
592 $langs->load('mrp');
593
594 $datas = [];
595 $datas['picto'] = img_picto('', $this->picto).' <u>'.$langs->trans("Workstation").'</u>';
596 $datas['ref'] = '<br><b>'.$langs->trans('Ref').':</b> '.$this->ref;
597 if (isset($this->status)) {
598 $datas['status'] = '<br><b>'.$langs->trans("Status").":</b> ".$this->getLibStatut(5);
599 }
600
601 return $datas;
602 }
603
614 public function getNomUrl($withpicto = 0, $option = '', $notooltip = 0, $morecss = '', $save_lastsearch_value = -1)
615 {
616 global $conf, $langs, $hookmanager;
617
618 if (!empty($conf->dol_no_mouse_hover)) {
619 $notooltip = 1; // Force disable tooltips
620 }
621
622 $result = '';
623
624 $params = [
625 'id' => $this->id,
626 'objecttype' => $this->element,
627 ];
628 $classfortooltip = 'classfortooltip';
629 $dataparams = '';
630 if (getDolGlobalInt('MAIN_ENABLE_AJAX_TOOLTIP')) {
631 $classfortooltip = 'classforajaxtooltip';
632 $dataparams = ' data-params="'.dol_escape_htmltag(json_encode($params)).'"';
633 $label = '';
634 } else {
635 $label = implode($this->getTooltipContentArray($params));
636 }
637
638 $url = dol_buildpath('/workstation/workstation_card.php', 1).'?id='.$this->id;
639
640 if ($option != 'nolink') {
641 // Add param to save lastsearch_values or not
642 $add_save_lastsearch_values = ($save_lastsearch_value == 1 ? 1 : 0);
643 if ($save_lastsearch_value == -1 && isset($_SERVER["PHP_SELF"]) && preg_match('/list\.php/', $_SERVER["PHP_SELF"])) {
644 $add_save_lastsearch_values = 1;
645 }
646 if ($add_save_lastsearch_values) {
647 $url .= '&save_lastsearch_values=1';
648 }
649 }
650
651 $linkclose = '';
652 if (empty($notooltip)) {
653 if (getDolGlobalString('MAIN_OPTIMIZEFORTEXTBROWSER')) {
654 $label = $langs->trans("ShowWorkstation");
655 $linkclose .= ' alt="'.dolPrintHTMLForAttribute($label).'"';
656 }
657 $linkclose .= ($label ? ' title="'.dolPrintHTMLForAttribute($label).'"' : ' title="tocomplete"');
658 $linkclose .= $dataparams.' class="'.$classfortooltip.($morecss ? ' '.$morecss : '').'"';
659 } else {
660 $linkclose = ($morecss ? ' class="'.$morecss.'"' : '');
661 }
662
663 $linkstart = '<a href="'.$url.'"';
664 $linkstart .= $linkclose.'>';
665 $linkend = '</a>';
666
667 $result .= $linkstart;
668
669 if (empty($this->showphoto_on_popup)) {
670 if ($withpicto) {
671 $result .= img_object(($notooltip ? '' : $label), ($this->picto ? $this->picto : 'mrp'), (($withpicto != 2) ? 'class="paddingright"' : ''), 0, 0, $notooltip ? 0 : 1);
672 }
673 } else {
674 if ($withpicto) {
675 require_once DOL_DOCUMENT_ROOT.'/core/lib/files.lib.php';
676
677 list($class, $module) = explode('@', $this->picto);
678 $upload_dir = $conf->$module->multidir_output[$conf->entity]."/$class/".dol_sanitizeFileName($this->ref);
679 $filearray = dol_dir_list($upload_dir, "files");
680 $filename = $filearray[0]['name'];
681 if (!empty($filename)) {
682 $pospoint = strpos($filearray[0]['name'], '.');
683
684 $pathtophoto = $class.'/'.$this->ref.'/thumbs/'.substr($filename, 0, $pospoint).'_mini'.substr($filename, $pospoint);
685 if (!getDolGlobalString(strtoupper($module.'_'.$class).'_FORMATLISTPHOTOSASUSERS')) {
686 $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>';
687 } else {
688 $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>';
689 }
690
691 $result .= '</div>';
692 } else {
693 $result .= img_object(($notooltip ? '' : $label), ($this->picto ? $this->picto : 'mrp'), ($notooltip ? (($withpicto != 2) ? 'class="paddingright"' : '') : 'class="'.(($withpicto != 2) ? 'paddingright ' : '').'classfortooltip"'), 0, 0, $notooltip ? 0 : 1);
694 }
695 }
696 }
697
698 if ($withpicto != 2) {
699 $result .= $this->ref;
700 }
701
702 $result .= $linkend;
703 //if ($withpicto != 2) $result.=(($addlabel && $this->label) ? $sep . dol_trunc($this->label, ($addlabel > 1 ? $addlabel : 0)) : '');
704
705 global $action, $hookmanager;
706 $hookmanager->initHooks(array('workstationdao'));
707 $parameters = array('id' => $this->id, 'getnomurl' => &$result);
708 $reshook = $hookmanager->executeHooks('getNomUrl', $parameters, $this, $action); // Note that $action and $object may have been modified by some hooks
709 if ($reshook > 0) {
710 $result = $hookmanager->resPrint;
711 } else {
712 $result .= $hookmanager->resPrint;
713 }
714
715 return $result;
716 }
717
725 public function getKanbanView($option = '', $arraydata = null)
726 {
727 $selected = (empty($arraydata['selected']) ? 0 : $arraydata['selected']);
728
729 $return = '<div class="box-flex-item box-flex-grow-zero">';
730 $return .= '<div class="info-box info-box-sm">';
731 $return .= '<span class="info-box-icon bg-infobox-action">';
732 $return .= img_picto('', $this->picto);
733 $return .= '</span>';
734 $return .= '<div class="info-box-content">';
735 $return .= '<span class="info-box-ref inline-block tdoverflowmax150 valignmiddle">'.(method_exists($this, 'getNomUrl') ? $this->getNomUrl() : $this->ref).'</span>';
736 if ($selected >= 0) {
737 $return .= '<input id="cb'.$this->id.'" class="flat checkforselect fright" type="checkbox" name="toselect[]" value="'.$this->id.'"'.($selected ? ' checked="checked"' : '').'>';
738 }
739 if (property_exists($this, 'label')) {
740 $return .= ' <div class="inline-block opacitymedium valignmiddle tdoverflowmax100">'.$this->label.'</div>';
741 }
742 if (property_exists($this, 'thirdparty') && is_object($this->thirdparty)) {
743 $return .= '<br><div class="info-box-ref tdoverflowmax150">'.$this->thirdparty->getNomUrl(1).'</div>';
744 }
745 if (method_exists($this, 'getLibStatut')) {
746 $return .= '<br><div class="info-box-status">'.$this->getLibStatut(3).'</div>';
747 }
748 $return .= '</div>';
749 $return .= '</div>';
750 $return .= '</div>';
751
752 return $return;
753 }
754
761 public function getLibStatut($mode = 0)
762 {
763 return $this->LibStatut($this->status, $mode);
764 }
765
766 // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
774 public function LibStatut($status, $mode = 0)
775 {
776 // phpcs:enable
777 if (empty($this->labelStatus) || empty($this->labelStatusShort)) {
778 global $langs;
779 //$langs->load("workstation");
780 $this->labelStatus[self::STATUS_DISABLED] = $langs->transnoentitiesnoconv('Disabled');
781 $this->labelStatus[self::STATUS_ENABLED] = $langs->transnoentitiesnoconv('Enabled');
782 $this->labelStatusShort[self::STATUS_DISABLED] = $langs->transnoentitiesnoconv('Disabled');
783 $this->labelStatusShort[self::STATUS_ENABLED] = $langs->transnoentitiesnoconv('Enabled');
784 }
785
786 $statusType = 'status'.$status;
787 //if ($status == self::STATUS_DISABLED) $statusType = 'status6';
788 if ($status == self::STATUS_ENABLED) {
789 $statusType = 'status4';
790 }
791
792 return dolGetStatus($this->labelStatus[$status], $this->labelStatusShort[$status], '', $statusType, $mode);
793 }
794
801 public function info($id)
802 {
803 $sql = 'SELECT rowid, date_creation as datec, tms as datem,';
804 $sql .= ' fk_user_creat, fk_user_modif';
805 $sql .= ' FROM '.MAIN_DB_PREFIX.$this->table_element.' as t';
806 $sql .= ' WHERE t.rowid = '.((int) $id);
807 $result = $this->db->query($sql);
808 if ($result) {
809 if ($this->db->num_rows($result)) {
810 $obj = $this->db->fetch_object($result);
811
812 $this->id = $obj->rowid;
813
814 $this->user_creation_id = $obj->fk_user_creat;
815 $this->user_modification_id = $obj->fk_user_modif;
816 $this->date_creation = $this->db->jdate($obj->datec);
817 $this->date_modification = empty($obj->datem) ? '' : $this->db->jdate($obj->datem);
818 }
819
820 $this->db->free($result);
821 } else {
822 dol_print_error($this->db);
823 }
824 }
825
832 public function initAsSpecimen()
833 {
834 return $this->initAsSpecimenCommon();
835 }
836
842 public function getNextNumRef()
843 {
844 global $langs, $conf;
845 $langs->load("workstation");
846
847 if (!getDolGlobalString('WORKSTATION_WORKSTATION_ADDON')) {
848 $conf->global->WORKSTATION_WORKSTATION_ADDON = 'mod_workstation_standard';
849 }
850
851 if (getDolGlobalString('WORKSTATION_WORKSTATION_ADDON')) {
852 $mybool = false;
853
854 $file = getDolGlobalString('WORKSTATION_WORKSTATION_ADDON') . ".php";
855 $classname = getDolGlobalString('WORKSTATION_WORKSTATION_ADDON');
856
857 // Include file with class
858 $dirmodels = array_merge(array('/'), (array) $conf->modules_parts['models']);
859 foreach ($dirmodels as $reldir) {
860 $dir = dol_buildpath($reldir."core/modules/workstation/");
861
862 // Load file with numbering class (if found)
863 if (file_exists($dir.$file)) {
864 $mybool = ((bool) @include_once $dir.$file) || $mybool;
865 }
866 }
867
868 if (!$mybool) {
869 dol_print_error(null, "Failed to include file ".$file);
870 return '';
871 }
872
873 if (class_exists($classname)) {
874 $obj = new $classname();
875 '@phan-var-force ModeleNumRefWorkstation $obj';
876 $numref = $obj->getNextValue($this);
877
878 if ($numref != '' && $numref != '-1') {
879 return $numref;
880 } else {
881 $this->error = $obj->error;
882 //dol_print_error($this->db,get_class($this)."::getNextNumRef ".$obj->error);
883 return "";
884 }
885 } else {
886 print $langs->trans("Error")." ".$langs->trans("ClassNotFound").' '.$classname;
887 return "";
888 }
889 } else {
890 print $langs->trans("ErrorNumberingModuleNotSetup", $this->element);
891 return "";
892 }
893 }
894
906 public function generateDocument($modele, $outputlangs, $hidedetails = 0, $hidedesc = 0, $hideref = 0, $moreparams = null)
907 {
908 global $conf, $langs;
909
910 $result = 0;
911 $includedocgeneration = 0;
912
913 $langs->load("workstation");
914
915 if (!dol_strlen($modele)) {
916 $modele = 'standard_workstation';
917
918 if ($this->model_pdf) {
919 $modele = $this->model_pdf;
920 } elseif (getDolGlobalString('WORKSTATION_ADDON_PDF')) {
921 $modele = getDolGlobalString('WORKSTATION_ADDON_PDF');
922 }
923 }
924
925 $modelpath = "core/modules/workstation/doc/";
926
927 if ($includedocgeneration) {
928 $result = $this->commonGenerateDocument($modelpath, $modele, $outputlangs, $hidedetails, $hidedesc, $hideref, $moreparams);
929 }
930
931 return $result;
932 }
933}
if( $user->socid > 0) if(! $user->hasRight('accounting', 'chartofaccount')) $object
Definition card.php:67
$object ref
Definition info.php:90
Parent class of all other business classes (invoices, contracts, proposals, orders,...
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.
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 to manage Dolibarr users.
Class for Workstation.
fetch($id, $ref=null)
Load object in memory from the database.
getNextNumRef()
Returns the reference to the following non used object depending on the active numbering module.
createFromClone(User $user, $fromid)
Clone an object into another one.
fetchLines()
Load object lines in memory from the database.
setEnabled($user, $notrigger=0)
Set draft status.
getTooltipContentArray($params)
getTooltipContentArray
getNomUrl($withpicto=0, $option='', $notooltip=0, $morecss='', $save_lastsearch_value=-1)
Return a link to the object card (with optionally the picto)
getKanbanView($option='', $arraydata=null)
Return a thumb for kanban views.
create(User $user, $notrigger=0)
Create object into database.
setDisabled($user, $notrigger=0)
Set draft status.
deleteLine(User $user, $idline, $notrigger=0)
Delete a line of object in database.
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.
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.
getLibStatut($mode=0)
Return the label of the status.
__construct(DoliDB $db)
Constructor.
initAsSpecimen()
Initialise object with example values Id must be 0 if object instance is a specimen.
LibStatut($status, $mode=0)
Return the status.
setStatus($status, $notrigger=0)
Set draft status.
Class to link resource with Workstations.
static getAllResourcesOfWorkstation($fk_workstation)
Function used to get an array with all resources linked to a workstation.
static deleteAllResourcesOfWorkstation($fk_workstation)
Function used to remove all resources linked to a workstation.
Class to link User groups and Workstations.
static deleteAllGroupsOfWorkstation($fk_workstation)
Function used to remove all usergroups linked to a workstation.
static getAllGroupsOfWorkstation($fk_workstation)
Function used to get an array with all usergroups linked to a workstation.
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:171
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:63
img_picto($titlealt, $picto, $moreatt='', $pictoisfullpath=0, $srconly=0, $notitle=0, $alt='', $morecss='', $marginleftonlyshort=2, $allowothertags=array())
Show picto whatever it's its name (generic function)
img_object($titlealt, $picto, $moreatt='', $pictoisfullpath=0, $srconly=0, $notitle=0, $allowothertags=array())
Show a picto called object_picto (generic function)
dol_strlen($string, $stringencoding='UTF-8')
Make a strlen call.
forgeSQLFromUniversalSearchCriteria($filter, &$errorstr='', $noand=0, $nopar=0, $noerror=0)
forgeSQLFromUniversalSearchCriteria
dol_now($mode='auto')
Return date for now.
getDolGlobalInt($key, $default=0)
Return a Dolibarr global constant int value.
dolGetStatus($statusLabel='', $statusLabelShort='', $html='', $statusType='status0', $displayMode=0, $url='', $params=array())
Output the badge of a status.
GETPOST($paramname, $check='alphanohtml', $method=0, $filter=null, $options=null, $noreplace=0)
Return value of a param into GET or POST supervariable.
dol_buildpath($path, $type=0, $returnemptyifnotfound=0)
Return path of url or filesystem.
dol_print_error($db=null, $error='', $errors=null)
Displays error message system with all the information to facilitate the diagnosis and the escalation...
dol_sanitizeFileName($str, $newstr='_', $unaccent=1, $includequotes=0)
Clean a string to use it as a file name.
getDolGlobalString($key, $default='')
Return a Dolibarr global constant string value.
dol_syslog($message, $level=LOG_INFO, $ident=0, $suffixinfilename='', $restricttologhandler='', $logcontext=null)
Write log message into outputs.
global $conf
The following vars must be defined: $type2label $form $conf, $lang, The following vars may also be de...
Definition member.php:79