29require_once DOL_DOCUMENT_ROOT.
'/core/class/commonobject.class.php';
30require_once DOL_DOCUMENT_ROOT.
'/core/lib/date.lib.php';
31require_once DOL_DOCUMENT_ROOT.
'/bom/class/bomline.class.php';
33if (isModEnabled(
'workstation')) {
34 require_once DOL_DOCUMENT_ROOT.
'/workstation/class/workstation.class.php';
49 public $module =
'bom';
54 public $element =
'bom';
59 public $table_element =
'bom_bom';
64 public $picto =
'bom';
71 const STATUS_DRAFT = 0;
72 const STATUS_VALIDATED = 1;
73 const STATUS_CANCELED = 9;
106 public $fields = array(
107 'rowid' => array(
'type' =>
'integer',
'label' =>
'TechnicalID',
'enabled' => 1,
'visible' => -2,
'position' => 1,
'notnull' => 1,
'index' => 1,
'comment' =>
"Id",),
108 'entity' => array(
'type' =>
'integer',
'label' =>
'Entity',
'enabled' => 1,
'visible' => 0,
'notnull' => 1,
'default' => 1,
'index' => 1,
'position' => 5),
109 'ref' => array(
'type' =>
'varchar(128)',
'label' =>
'Ref',
'enabled' => 1,
'noteditable' => 1,
'visible' => 4,
'position' => 10,
'notnull' => 1,
'default' =>
'(PROV)',
'index' => 1,
'searchall' => 1,
'comment' =>
"Reference of BOM",
'showoncombobox' => 1,
'csslist' =>
'nowraponall'),
110 'label' => array(
'type' =>
'varchar(255)',
'label' =>
'Label',
'enabled' => 1,
'visible' => 1,
'position' => 30,
'notnull' => 1,
'searchall' => 1,
'showoncombobox' =>
'2',
'autofocusoncreate' => 1,
'css' =>
'minwidth300 maxwidth400',
'csslist' =>
'tdoverflowmax200'),
111 'bomtype' => array(
'type' =>
'integer',
'label' =>
'Type',
'enabled' => 1,
'visible' => 1,
'position' => 33,
'notnull' => 1,
'default' =>
'0',
'arrayofkeyval' => array(0 =>
'Manufacturing', 1 =>
'Disassemble'),
'css' =>
'minwidth175',
'csslist' =>
'minwidth175 center'),
113 'fk_product' => array(
'type' =>
'integer:Product:product/class/product.class.php:1:((finished:is:null) or (finished:!=:0))',
'label' =>
'Product',
'picto' =>
'product',
'enabled' => 1,
'visible' => 1,
'position' => 35,
'notnull' => 1,
'index' => 1,
'help' =>
'ProductBOMHelp',
'css' =>
'maxwidth500',
'csslist' =>
'tdoverflowmax100'),
114 'description' => array(
'type' =>
'text',
'label' =>
'Description',
'enabled' => 1,
'visible' => -1,
'position' => 60,
'notnull' => -1,),
115 'qty' => array(
'type' =>
'real',
'label' =>
'Quantity',
'enabled' => 1,
'visible' => 1,
'default' => 1,
'position' => 55,
'notnull' => 1,
'isameasure' => 1,
'css' =>
'maxwidth50imp right'),
117 'duration' => array(
'type' =>
'duration',
'label' =>
'EstimatedDuration',
'enabled' => 1,
'visible' => -1,
'position' => 101,
'notnull' => -1,
'css' =>
'maxwidth50imp',
'help' =>
'EstimatedDurationDesc'),
118 'fk_warehouse' => array(
'type' =>
'integer:Entrepot:product/stock/class/entrepot.class.php:0',
'label' =>
'WarehouseForProduction',
'picto' =>
'stock',
'enabled' => 1,
'visible' => -1,
'position' => 102,
'css' =>
'maxwidth500',
'csslist' =>
'tdoverflowmax100'),
119 'note_public' => array(
'type' =>
'html',
'label' =>
'NotePublic',
'enabled' => 1,
'visible' => -2,
'position' => 161,
'notnull' => -1,),
120 'note_private' => array(
'type' =>
'html',
'label' =>
'NotePrivate',
'enabled' => 1,
'visible' => -2,
'position' => 162,
'notnull' => -1,),
121 'date_creation' => array(
'type' =>
'datetime',
'label' =>
'DateCreation',
'enabled' => 1,
'visible' => -2,
'position' => 300,
'notnull' => 1,),
122 'tms' => array(
'type' =>
'timestamp',
'label' =>
'DateModification',
'enabled' => 1,
'visible' => -2,
'position' => 501,
'notnull' => 1,),
123 'date_valid' => array(
'type' =>
'datetime',
'label' =>
'DateValidation',
'enabled' => 1,
'visible' => -2,
'position' => 502,
'notnull' => 0,),
124 'fk_user_creat' => array(
'type' =>
'integer:User:user/class/user.class.php',
'label' =>
'UserCreation',
'picto' =>
'user',
'enabled' => 1,
'visible' => -2,
'position' => 510,
'notnull' => 1,
'foreignkey' =>
'user.rowid',
'csslist' =>
'tdoverflowmax100'),
125 'fk_user_modif' => array(
'type' =>
'integer:User:user/class/user.class.php',
'label' =>
'UserModif',
'picto' =>
'user',
'enabled' => 1,
'visible' => -2,
'position' => 511,
'notnull' => -1,
'csslist' =>
'tdoverflowmax100'),
126 'fk_user_valid' => array(
'type' =>
'integer:User:user/class/user.class.php',
'label' =>
'UserValidation',
'picto' =>
'user',
'enabled' => 1,
'visible' => -2,
'position' => 512,
'notnull' => 0,
'csslist' =>
'tdoverflowmax100'),
127 'import_key' => array(
'type' =>
'varchar(14)',
'label' =>
'ImportId',
'enabled' => 1,
'visible' => -2,
'position' => 1000,
'notnull' => -1,),
128 'model_pdf' => array(
'type' =>
'varchar(255)',
'label' =>
'Model pdf',
'enabled' => 1,
'visible' => 0,
'position' => 1010),
129 'status' => array(
'type' =>
'integer',
'label' =>
'Status',
'enabled' => 1,
'visible' => 2,
'position' => 1000,
'notnull' => 1,
'default' => 0,
'index' => 1,
'arrayofkeyval' => array(0 =>
'Draft', 1 =>
'Enabled', 9 =>
'Disabled')),
165 public $fk_user_creat;
170 public $fk_user_modif;
175 public $fk_user_valid;
180 public $fk_warehouse;
216 public $table_element_line =
'bom_bomline';
221 public $fk_element =
'fk_bom';
226 public $class_element_line =
'BOMLine';
236 protected $childtablesoncascade = array(
'bom_bomline');
241 public $lines = array();
246 public $total_cost = 0;
251 public $unit_cost = 0;
261 global $conf, $langs;
265 $this->ismultientitymanaged = 1;
266 $this->isextrafieldmanaged = 1;
269 $this->fields[
'rowid'][
'visible'] = 0;
271 if (!isModEnabled(
'multicompany') && isset($this->fields[
'entity'])) {
272 $this->fields[
'entity'][
'enabled'] = 0;
276 foreach ($this->fields as $key => $val) {
277 if (isset($val[
'enabled']) && empty($val[
'enabled'])) {
278 unset($this->fields[$key]);
283 foreach ($this->fields as $key => $val) {
284 if (!empty($val[
'arrayofkeyval']) && is_array($val[
'arrayofkeyval'])) {
285 foreach ($val[
'arrayofkeyval'] as $key2 => $val2) {
286 $this->fields[$key][
'arrayofkeyval'][$key2] = $langs->trans($val2);
301 if ($this->efficiency <= 0 || $this->efficiency > 1) {
302 $this->efficiency = 1;
317 global $langs, $hookmanager, $extrafields;
327 $result =
$object->fetchCommon($fromid);
328 if ($result > 0 && !empty(
$object->table_element_line)) {
342 $default_ref = $this->fields[
'ref'][
'default'] ??
null;
343 $object->ref = empty($default_ref) ? $langs->trans(
"copy_of_").$object->ref : $default_ref;
344 $object->label = empty($this->fields[
'label'][
'default']) ? $langs->trans(
"CopyOf").
" ".
$object->label : $this->fields[
'label'][
'default'];
345 $object->status = self::STATUS_DRAFT;
348 if (is_array(
$object->array_options) && count(
$object->array_options) > 0) {
349 $extrafields->fetch_name_optionals_label(
$object->table_element);
350 foreach (
$object->array_options as $key => $option) {
351 $shortkey = preg_replace(
'/options_/',
'', $key);
352 if (!empty($extrafields->attributes[$this->element][
'unique'][$shortkey])) {
354 unset(
$object->array_options[$key]);
360 $object->context[
'createfromclone'] =
'createfromclone';
361 $result =
$object->createCommon($user);
365 $this->errors =
$object->errors;
378 if (property_exists($this,
'socid') && $this->socid ==
$object->socid) {
389 unset(
$object->context[
'createfromclone']);
396 $this->db->rollback();
408 public function fetch($id, $ref =
null)
412 if ($result > 0 && !empty($this->table_element_line)) {
427 $this->lines = array();
442 $this->lines = array();
444 $objectlineclassname = get_class($this).
'Line';
445 if (!class_exists($objectlineclassname)) {
446 $this->error =
'Error, class '.$objectlineclassname.
' not found during call of fetchLinesCommon';
450 $objectline =
new $objectlineclassname($this->db);
452 '@phan-var-force BOMLine $objectline';
454 $sql =
"SELECT ".$objectline->getFieldList(
'l');
455 $sql .=
" FROM ".$this->db->prefix().$objectline->table_element.
" as l";
456 $sql .=
" LEFT JOIN ".$this->db->prefix().
"product as p ON p.rowid = l.fk_product";
457 $sql .=
" WHERE l.fk_".$this->db->escape($this->element).
" = ".((int) $this->
id);
458 $sql .=
" AND p.fk_product_type = ". ((int) $typeproduct);
459 if (isset($objectline->fields[
'position'])) {
460 $sql .= $this->db->order(
'position',
'ASC');
463 $resql = $this->db->query($sql);
465 $num_rows = $this->db->num_rows($resql);
467 while ($i < $num_rows) {
468 $obj = $this->db->fetch_object($resql);
470 $newline =
new $objectlineclassname($this->db);
471 '@phan-var-force BOMLine $newline';
472 $newline->setVarsFromFetchObj($obj);
474 $this->lines[] = $newline;
481 $this->error = $this->db->lasterror();
482 $this->errors[] = $this->error;
499 public function fetchAll($sortorder =
'', $sortfield =
'', $limit = 0, $offset = 0, $filter =
'', $filtermode =
'AND')
507 $sql .=
' FROM '.MAIN_DB_PREFIX.$this->table_element.
' as t';
508 if ($this->ismultientitymanaged) {
509 $sql .=
' WHERE t.entity IN ('.getEntity($this->element).
')';
511 $sql .=
' WHERE 1 = 1';
518 $this->errors[] = $errormessage;
519 dol_syslog(__METHOD__.
' '.implode(
',', $this->errors), LOG_ERR);
523 if (!empty($sortfield)) {
524 $sql .= $this->db->order($sortfield, $sortorder);
526 if (!empty($limit)) {
527 $sql .= $this->db->plimit($limit, $offset);
530 $resql = $this->db->query($sql);
532 $num = $this->db->num_rows($resql);
534 while ($obj = $this->db->fetch_object($resql)) {
535 $record =
new self($this->db);
536 $record->setVarsFromFetchObj($obj);
538 $records[$record->id] = $record;
540 $this->db->free($resql);
544 $this->errors[] =
'Error '.$this->db->lasterror();
545 dol_syslog(__METHOD__.
' '.implode(
',', $this->errors), LOG_ERR);
560 if ($this->efficiency <= 0 || $this->efficiency > 1) {
561 $this->efficiency = 1;
574 public function delete(
User $user, $notrigger = 1)
596 public function addLine($fk_product, $qty, $qty_frozen = 0, $disable_stock_change = 0, $efficiency = 1.0, $position = -1, $fk_bom_child =
null, $import_key =
null, $fk_unit = 0, $array_options = array(), $fk_default_workstation =
null)
598 global $mysoc, $conf, $langs, $user;
600 $logtext =
"::addLine bomid=$this->id, qty=$qty, fk_product=$fk_product, qty_frozen=$qty_frozen, disable_stock_change=$disable_stock_change, efficiency=$efficiency";
601 $logtext .=
", fk_bom_child=$fk_bom_child, import_key=$import_key";
602 dol_syslog(get_class($this).$logtext, LOG_DEBUG);
604 if ($this->statut == self::STATUS_DRAFT) {
605 include_once DOL_DOCUMENT_ROOT.
'/core/lib/price.lib.php';
611 if (empty($qty_frozen)) {
614 if (empty($disable_stock_change)) {
615 $disable_stock_change = 0;
617 if (empty($efficiency)) {
620 if (empty($fk_bom_child)) {
621 $fk_bom_child =
null;
623 if (empty($import_key)) {
626 if (empty($position)) {
631 $efficiency = (float)
price2num($efficiency);
632 $position = (float)
price2num($position);
638 $rankToUse = $position;
639 if ($rankToUse <= 0 or $rankToUse > $rangMax) {
640 $rankToUse = $rangMax + 1;
642 foreach ($this->lines as $bl) {
643 if ($bl->position >= $rankToUse) {
651 $line =
new BOMLine($this->db);
653 $line->context = $this->context;
655 $line->fk_bom = $this->id;
656 $line->fk_product = $fk_product;
658 $line->qty_frozen = $qty_frozen;
659 $line->disable_stock_change = $disable_stock_change;
660 $line->efficiency = $efficiency;
661 $line->fk_bom_child = $fk_bom_child;
662 $line->import_key = $import_key;
663 $line->position = $rankToUse;
664 $line->fk_unit = $fk_unit;
665 $line->fk_default_workstation = $fk_default_workstation;
667 if (is_array($array_options) && count($array_options) > 0) {
668 $line->array_options = $array_options;
671 $result = $line->create($user);
679 dol_syslog(get_class($this).
"::addLine error=".$this->error, LOG_ERR);
680 $this->db->rollback();
684 dol_syslog(get_class($this).
"::addLine status of BOM must be Draft to allow use of ->addLine()", LOG_ERR);
704 public function updateLine($rowid, $qty, $qty_frozen = 0, $disable_stock_change = 0, $efficiency = 1.0, $position = -1, $import_key =
null, $fk_unit = 0, $array_options = array(), $fk_default_workstation =
null)
708 $logtext =
"::updateLine bomid=$this->id, qty=$qty, qty_frozen=$qty_frozen, disable_stock_change=$disable_stock_change, efficiency=$efficiency";
709 $logtext .=
", import_key=$import_key";
710 dol_syslog(get_class($this).$logtext, LOG_DEBUG);
712 if ($this->statut == self::STATUS_DRAFT) {
713 include_once DOL_DOCUMENT_ROOT.
'/core/lib/price.lib.php';
719 if (empty($qty_frozen)) {
722 if (empty($disable_stock_change)) {
723 $disable_stock_change = 0;
725 if (empty($efficiency)) {
728 if (empty($import_key)) {
731 if (empty($position)) {
736 $efficiency = (float)
price2num($efficiency);
737 $position = (float)
price2num($position);
742 $line =
new BOMLine($this->db);
743 $line->fetch($rowid);
744 $line->fetch_optionals();
746 $staticLine = clone $line;
747 $line->oldcopy = $staticLine;
748 $line->context = $this->context;
751 $rankToUse = (int) $position;
752 if ($rankToUse != $line->oldcopy->position) {
753 foreach ($this->lines as $bl) {
754 if ($bl->position >= $rankToUse and $bl->position < ($line->oldcopy->position + 1)) {
758 if ($bl->position <= $rankToUse and $bl->position > ($line->oldcopy->position)) {
766 $line->fk_bom = $this->id;
768 $line->qty_frozen = $qty_frozen;
769 $line->disable_stock_change = $disable_stock_change;
770 $line->efficiency = $efficiency;
771 $line->import_key = $import_key;
772 $line->position = $rankToUse;
775 if (!empty($fk_unit)) {
776 $line->fk_unit = $fk_unit;
780 if (is_array($array_options) && count($array_options) > 0) {
782 foreach ($array_options as $key => $value) {
783 $line->array_options[$key] = $array_options[$key];
786 if ($line->fk_default_workstation != $fk_default_workstation) {
787 $line->fk_default_workstation = ($fk_default_workstation > 0 ? $fk_default_workstation : 0);
790 $result = $line->update($user);
798 dol_syslog(get_class($this).
"::addLine error=".$this->error, LOG_ERR);
799 $this->db->rollback();
803 dol_syslog(get_class($this).
"::addLine status of BOM must be Draft to allow use of ->addLine()", LOG_ERR);
819 $this->error =
'ErrorDeleteLineNotAllowedByObjectStatus';
826 $line =
new BOMLine($this->db);
827 $line->fetch($idline);
828 $line->fetch_optionals();
830 $staticLine = clone $line;
831 $line->oldcopy = $staticLine;
832 $line->context = $this->context;
834 $result = $line->delete($user, $notrigger);
837 foreach ($this->lines as $bl) {
838 if ($bl->position > ($line->oldcopy->position)) {
850 dol_syslog(get_class($this).
"::addLine error=".$this->error, LOG_ERR);
851 $this->db->rollback();
865 global $langs, $conf;
875 $dirmodels = array_merge(array(
'/'), (array) $conf->modules_parts[
'models']);
876 foreach ($dirmodels as $reldir) {
880 $mybool = ((bool) @include_once $dir.$file) || $mybool;
888 $obj =
new $classname();
889 '@phan-var-force ModeleNumRefBoms $obj';
890 $numref = $obj->getNextValue($prod, $this);
895 $this->error = $obj->error;
900 print $langs->trans(
"Error").
" ".$langs->trans(
"Error_BOM_ADDON_NotDefined");
916 require_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
921 if ($this->
status == self::STATUS_VALIDATED) {
922 dol_syslog(get_class($this).
"::validate action abandoned: already validated", LOG_WARNING);
931 if (!$error && (preg_match(
'/^[\(]?PROV/i', $this->
ref) || empty($this->
ref))) {
940 $sql =
"UPDATE ".MAIN_DB_PREFIX.$this->table_element;
941 $sql .=
" SET ref = '".$this->db->escape($num).
"',";
942 $sql .=
" status = ".self::STATUS_VALIDATED.
",";
943 $sql .=
" date_valid='".$this->db->idate($now).
"',";
944 $sql .=
" fk_user_valid = ".((int) $user->id);
945 $sql .=
" WHERE rowid = ".((int) $this->
id);
947 dol_syslog(get_class($this).
"::validate()", LOG_DEBUG);
948 $resql = $this->db->query($sql);
951 $this->error = $this->db->lasterror();
955 if (!$error && !$notrigger) {
965 $this->oldref = $this->ref;
968 if (preg_match(
'/^[\(]?PROV/i', $this->
ref)) {
970 $sql =
'UPDATE '.MAIN_DB_PREFIX.
"ecm_files set filename = CONCAT('".$this->db->escape($this->newref).
"', SUBSTR(filename, ".(strlen($this->
ref) + 1).
")), filepath = 'bom/".$this->db->escape($this->newref).
"'";
971 $sql .=
" WHERE filename LIKE '".$this->db->escape($this->
ref).
"%' AND filepath = 'bom/".$this->db->escape($this->
ref).
"' and entity = ".$conf->entity;
972 $resql = $this->db->query($sql);
975 $this->error = $this->db->lasterror();
977 $sql =
'UPDATE '.MAIN_DB_PREFIX.
"ecm_files set filepath = 'bom/".$this->db->escape($this->newref).
"'";
978 $sql .=
" WHERE filepath = 'bom/".$this->db->escape($this->
ref).
"' and entity = ".$conf->entity;
979 $resql = $this->db->query($sql);
982 $this->error = $this->db->lasterror();
988 $dirsource = $conf->bom->dir_output.
'/'.$oldref;
989 $dirdest = $conf->bom->dir_output.
'/'.$newref;
990 if (!$error && file_exists($dirsource)) {
991 dol_syslog(get_class($this).
"::validate() rename dir ".$dirsource.
" into ".$dirdest);
993 if (@rename($dirsource, $dirdest)) {
996 $listoffiles =
dol_dir_list($conf->bom->dir_output.
'/'.$newref,
'files', 1,
'^'.preg_quote($oldref,
'/'));
997 foreach ($listoffiles as $fileentry) {
998 $dirsource = $fileentry[
'name'];
999 $dirdest = preg_replace(
'/^'.preg_quote($oldref,
'/').
'/', $newref, $dirsource);
1000 $dirsource = $fileentry[
'path'].
'/'.$dirsource;
1001 $dirdest = $fileentry[
'path'].
'/'.$dirdest;
1002 @rename($dirsource, $dirdest);
1012 $this->
status = self::STATUS_VALIDATED;
1016 $this->db->commit();
1019 $this->db->rollback();
1034 if ($this->
status <= self::STATUS_DRAFT) {
1038 return $this->
setStatusCommon($user, self::STATUS_DRAFT, $notrigger,
'BOM_UNVALIDATE');
1048 public function cancel($user, $notrigger = 0)
1051 if ($this->
status != self::STATUS_VALIDATED) {
1055 return $this->
setStatusCommon($user, self::STATUS_CANCELED, $notrigger,
'BOM_CLOSE');
1065 public function reopen($user, $notrigger = 0)
1068 if ($this->
status != self::STATUS_CANCELED) {
1072 return $this->
setStatusCommon($user, self::STATUS_VALIDATED, $notrigger,
'BOM_REOPEN');
1083 global $conf, $langs, $user;
1085 $langs->loadLangs([
'product',
'mrp']);
1090 return [
'optimize' => $langs->trans(
"ShowBillOfMaterials")];
1092 $picto =
img_picto(
'', $this->picto).
' <u class="paddingrightonly">'.$langs->trans(
"BillOfMaterials").
'</u>';
1093 if (isset($this->
status)) {
1094 $picto .=
' '.$this->getLibStatut(5);
1096 $datas[
'picto'] = $picto;
1097 $datas[
'ref'] =
'<br><b>'.$langs->trans(
'Ref').
':</b> '.$this->ref;
1098 if (isset($this->label)) {
1099 $datas[
'label'] =
'<br><b>'.$langs->trans(
'Label').
':</b> '.$this->label;
1101 if (!empty($this->fk_product) && $this->fk_product > 0) {
1102 include_once DOL_DOCUMENT_ROOT.
'/product/class/product.class.php';
1103 $product =
new Product($this->db);
1104 $resultFetch = $product->fetch($this->fk_product);
1105 if ($resultFetch > 0) {
1106 $datas[
'product'] =
"<br><b>".$langs->trans(
"Product").
'</b>: '.$product->ref.
' - '.$product->label;
1123 public function getNomUrl($withpicto = 0, $option =
'', $notooltip = 0, $morecss =
'', $save_lastsearch_value = -1)
1125 global $db, $conf, $langs, $hookmanager;
1127 if (!empty($conf->dol_no_mouse_hover)) {
1134 'objecttype' => $this->element,
1135 'option' => $option,
1137 $classfortooltip =
'classfortooltip';
1140 $classfortooltip =
'classforajaxtooltip';
1141 $dataparams =
' data-params="'.dol_escape_htmltag(json_encode($params)).
'"';
1147 $url = DOL_URL_ROOT.
'/bom/bom_card.php?id='.$this->id;
1149 if ($option !=
'nolink') {
1151 $add_save_lastsearch_values = ($save_lastsearch_value == 1 ? 1 : 0);
1152 if ($save_lastsearch_value == -1 && isset($_SERVER[
"PHP_SELF"]) && preg_match(
'/list\.php/', $_SERVER[
"PHP_SELF"])) {
1153 $add_save_lastsearch_values = 1;
1155 if ($add_save_lastsearch_values) {
1156 $url .=
'&save_lastsearch_values=1';
1161 if (empty($notooltip)) {
1163 $label = $langs->trans(
"ShowBillOfMaterials");
1164 $linkclose .=
' alt="'.dol_escape_htmltag($label, 1).
'"';
1166 $linkclose .= ($label ?
' title="'.dol_escape_htmltag($label, 1).
'"' :
' title="tocomplete"');
1167 $linkclose .= $dataparams.
' class="'.$classfortooltip.($morecss ?
' '.$morecss :
'').
'"';
1169 $linkclose = ($morecss ?
' class="'.$morecss.
'"' :
'');
1172 $linkstart =
'<a href="'.$url.
'"';
1173 $linkstart .= $linkclose.
'>';
1176 $result .= $linkstart;
1178 $result .=
img_object(($notooltip ?
'' : $label), ($this->picto ? $this->picto :
'generic'), (($withpicto != 2) ?
'class="paddingright"' :
''), 0, 0, $notooltip ? 0 : 1);
1180 if ($withpicto != 2) {
1181 $result .= $this->ref;
1183 $result .= $linkend;
1186 global $action, $hookmanager;
1187 $hookmanager->initHooks(array(
'bomdao'));
1188 $parameters = array(
'id' => $this->
id,
'getnomurl' => &$result);
1189 $reshook = $hookmanager->executeHooks(
'getNomUrl', $parameters, $this, $action);
1191 $result = $hookmanager->resPrint;
1193 $result .= $hookmanager->resPrint;
1221 if (empty($this->labelStatus)) {
1224 $this->labelStatus[self::STATUS_DRAFT] = $langs->transnoentitiesnoconv(
'Draft');
1225 $this->labelStatus[self::STATUS_VALIDATED] = $langs->transnoentitiesnoconv(
'Enabled');
1226 $this->labelStatus[self::STATUS_CANCELED] = $langs->transnoentitiesnoconv(
'Disabled');
1229 $statusType =
'status'.$status;
1230 if ($status == self::STATUS_VALIDATED) {
1231 $statusType =
'status4';
1233 if ($status == self::STATUS_CANCELED) {
1234 $statusType =
'status6';
1237 return dolGetStatus($this->labelStatus[$status], $this->labelStatus[$status],
'', $statusType, $mode);
1248 $sql =
'SELECT rowid, date_creation as datec, tms as datem,';
1249 $sql .=
' fk_user_creat, fk_user_modif';
1250 $sql .=
' FROM '.MAIN_DB_PREFIX.$this->table_element.
' as t';
1251 $sql .=
' WHERE t.rowid = '.((int) $id);
1252 $result = $this->db->query($sql);
1254 if ($this->db->num_rows($result)) {
1255 $obj = $this->db->fetch_object($result);
1257 $this->
id = $obj->rowid;
1259 $this->user_creation_id = $obj->fk_user_creat;
1260 $this->user_modification_id = $obj->fk_user_modif;
1261 $this->date_creation = $this->db->jdate($obj->datec);
1262 $this->date_modification = empty($obj->datem) ?
'' : $this->db->jdate($obj->datem);
1265 $this->db->free($result);
1278 $this->lines = array();
1280 $objectline =
new BOMLine($this->db);
1281 $result = $objectline->fetchAll(
'ASC',
'position', 0, 0,
'(fk_bom:=:'.((
int) $this->
id).
')');
1283 if (is_numeric($result)) {
1284 $this->error = $objectline->error;
1285 $this->errors = $objectline->errors;
1288 $this->lines = $result;
1289 return $this->lines;
1304 public function generateDocument($modele, $outputlangs, $hidedetails = 0, $hidedesc = 0, $hideref = 0, $moreparams =
null)
1306 global $conf, $langs;
1308 $langs->load(
"mrp");
1309 $outputlangs->load(
"products");
1314 if ($this->model_pdf) {
1315 $modele = $this->model_pdf;
1321 $modelpath =
"core/modules/bom/doc/";
1322 if (!empty($modele)) {
1323 return $this->
commonGenerateDocument($modelpath, $modele, $outputlangs, $hidedetails, $hidedesc, $hideref, $moreparams);
1339 include_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
1340 include_once DOL_DOCUMENT_ROOT.
'/core/lib/images.lib.php';
1342 $sdir .=
'/'.get_exdir(0, 0, 0, 0, $this,
'bom');
1345 if (file_exists($dir_osencoded)) {
1346 $handle = opendir($dir_osencoded);
1347 if (is_resource($handle)) {
1348 while (($file = readdir($handle)) !==
false) {
1350 $file = mb_convert_encoding($file,
'UTF-8',
'ISO-8859-1');
1370 $this->
ref =
'BOM-123';
1371 $this->date_creation =
dol_now() - 20000;
1385 global $conf, $langs;
1401 $this->db->commit();
1414 global $conf, $hookmanager;
1416 include_once DOL_DOCUMENT_ROOT.
'/product/class/product.class.php';
1417 $this->unit_cost = 0;
1418 $this->total_cost = 0;
1420 $parameters = array();
1421 $reshook = $hookmanager->executeHooks(
'calculateCostsBom', $parameters, $this);
1424 return $hookmanager->resPrint;
1427 if (is_array($this->lines) && count($this->lines)) {
1428 require_once DOL_DOCUMENT_ROOT.
'/fourn/class/fournisseur.product.class.php';
1430 $tmpproduct =
new Product($this->db);
1432 foreach ($this->lines as &$line) {
1433 $tmpproduct->cost_price = 0;
1434 $tmpproduct->pmp = 0;
1435 $result = $tmpproduct->fetch($line->fk_product,
'',
'',
'', 0, 1, 1);
1437 if ($tmpproduct->type == $tmpproduct::TYPE_PRODUCT) {
1438 if (empty($line->fk_bom_child)) {
1440 $this->error = $tmpproduct->error;
1443 $unit_cost = (!empty($tmpproduct->cost_price)) ? $tmpproduct->cost_price : $tmpproduct->pmp;
1444 $line->unit_cost = (float)
price2num($unit_cost);
1445 if (empty($line->unit_cost)) {
1446 if ($productFournisseur->find_min_price_product_fournisseur($line->fk_product) > 0) {
1447 if ($productFournisseur->fourn_remise_percent !=
"0") {
1448 $line->unit_cost = $productFournisseur->fourn_unitprice_with_discount;
1450 $line->unit_cost = $productFournisseur->fourn_unitprice;
1455 $line->total_cost = (float)
price2num($line->qty * $line->unit_cost,
'MT');
1457 $this->total_cost += $line->total_cost;
1459 $bom_child =
new BOM($this->db);
1460 $res = $bom_child->fetch($line->fk_bom_child);
1462 $bom_child->calculateCosts();
1463 $line->childBom[] = $bom_child;
1464 $this->total_cost += (float)
price2num($bom_child->total_cost * $line->qty,
'MT');
1465 $this->total_cost += $line->total_cost;
1467 $this->error = $bom_child->error;
1476 if (isModEnabled(
'workstation') && !empty($line->fk_default_workstation)) {
1478 $res = $workstation->fetch($line->fk_default_workstation);
1481 $line->total_cost = (float)
price2num($qtyhourforline * ($workstation->thm_operator_estimated + $workstation->thm_machine_estimated),
'MT');
1483 $this->error = $workstation->error;
1487 $defaultdurationofservice = $tmpproduct->duration;
1489 $qtyhourservice = 0;
1490 if (preg_match(
'/^(\d+)([a-z]+)$/', $defaultdurationofservice, $reg)) {
1494 if ($qtyhourservice) {
1495 $line->total_cost = (float)
price2num($qtyhourforline / $qtyhourservice * $tmpproduct->cost_price,
'MT');
1497 $line->total_cost = (float)
price2num($line->qty * $tmpproduct->cost_price,
'MT');
1501 $this->total_cost += $line->total_cost;
1505 $this->total_cost = (float)
price2num($this->total_cost,
'MT');
1507 if ($this->qty > 0) {
1508 $this->unit_cost = (float)
price2num($this->total_cost / $this->qty,
'MU');
1509 } elseif ($this->qty < 0) {
1510 $this->unit_cost = (float)
price2num($this->total_cost * $this->qty,
'MU');
1543 if (!empty($this->lines)) {
1544 foreach ($this->lines as $line) {
1545 if (!empty($line->childBom)) {
1546 foreach ($line->childBom as $childBom) {
1547 $childBom->getNetNeeds($TNetNeeds, $line->qty * $qty);
1550 if (empty($TNetNeeds[$line->fk_product][
'qty'])) {
1551 $TNetNeeds[$line->fk_product][
'qty'] = 0.0;
1555 $TNetNeeds[$line->fk_product][
'fk_unit'] = $line->fk_unit;
1556 $TNetNeeds[$line->fk_product][
'qty'] += $line->qty * $qty;
1572 if (!empty($this->lines)) {
1573 foreach ($this->lines as $line) {
1574 if (!empty($line->childBom)) {
1575 foreach ($line->childBom as $childBom) {
1576 $TNetNeeds[$childBom->id][
'bom'] = $childBom;
1577 $TNetNeeds[$childBom->id][
'parentid'] = $this->id;
1581 $TNetNeeds[$childBom->id][
'qty'] = $line->qty * $qty;
1582 $TNetNeeds[$childBom->id][
'level'] = $level;
1583 $childBom->getNetNeedsTree($TNetNeeds, $line->qty * $qty, $level + 1);
1588 if (!isset($TNetNeeds[$this->
id][
'product'])) {
1589 $TNetNeeds[$this->id][
'product'] = array();
1591 if (!isset($TNetNeeds[$this->
id][
'product'][$line->fk_product])) {
1592 $TNetNeeds[$this->id][
'product'][$line->fk_product] = array();
1594 $TNetNeeds[$this->id][
'product'][$line->fk_product][
'fk_unit'] = $line->fk_unit;
1595 if (!isset($TNetNeeds[$this->
id][
'product'][$line->fk_product][
'qty'])) {
1596 $TNetNeeds[$this->id][
'product'][$line->fk_product][
'qty'] = 0.0;
1598 $TNetNeeds[$this->id][
'product'][$line->fk_product][
'qty'] += $line->qty * $qty;
1599 $TNetNeeds[$this->id][
'product'][$line->fk_product][
'level'] = $level;
1617 if ($level > 1000) {
1621 if (empty($bom_id)) {
1622 $bom_id = $this->id;
1625 $sql =
'SELECT l.fk_bom, b.label
1626 FROM '.MAIN_DB_PREFIX.
'bom_bomline l
1627 INNER JOIN '.MAIN_DB_PREFIX.$this->table_element.
' b ON b.rowid = l.fk_bom
1628 WHERE fk_bom_child = '.((int) $bom_id);
1630 $resql = $this->db->query($sql);
1631 if (!empty($resql)) {
1632 while ($res = $this->db->fetch_object($resql)) {
1633 $TParentBom[$res->fk_bom] = $res->fk_bom;
1650 $selected = (empty($arraydata[
'selected']) ? 0 : $arraydata[
'selected']);
1652 $return =
'<div class="box-flex-item box-flex-grow-zero">';
1653 $return .=
'<div class="info-box info-box-sm">';
1654 $return .=
'<span class="info-box-icon bg-infobox-action">';
1656 $return .=
'</span>';
1657 $return .=
'<div class="info-box-content">';
1658 $return .=
'<span class="info-box-ref inline-block tdoverflowmax150 valignmiddle">'.(method_exists($this,
'getNomUrl') ? $this->
getNomUrl() :
'').
'</span>';
1659 if ($selected >= 0) {
1660 $return .=
'<input id="cb'.$this->id.
'" class="flat checkforselect fright" type="checkbox" name="toselect[]" value="'.$this->
id.
'"'.($selected ?
' checked="checked"' :
'').
'>';
1662 $arrayofkeyval = $this->fields[
'bomtype'][
'arrayofkeyval'] ??
null;
1663 if (!empty($arrayofkeyval)) {
1664 $return .=
'<br><span class="info-box-label opacitymedium">'.$langs->trans(
"Type").
' : </span>';
1665 if ($this->bomtype == 0) {
1666 $return .=
'<span class="info-box-label">'.$arrayofkeyval[0].
'</span>';
1668 $return .=
'<span class="info-box-label">'.$arrayofkeyval[1].
'</span>';
1671 if (!empty($arraydata[
'prod'])) {
1672 $prod = $arraydata[
'prod'];
1673 $return .=
'<br><span class="info-box-label">'.$prod->getNomUrl(1).
'</span>';
1675 if (method_exists($this,
'getLibStatut')) {
1676 $return .=
'<br><div class="info-box-status">'.$this->getLibStatut(3).
'</div>';
1679 $return .=
'</div>';
1680 $return .=
'</div>';
1681 $return .=
'</div>';
if( $user->socid > 0) if(! $user->hasRight('accounting', 'chartofaccount')) $object
print $langs trans("AuditedSecurityEvents").'</strong >< span class="opacitymedium"></span >< br > status
Or an array listing all the potential status of the object: array: int of the status => translated la...
static replaceProduct(DoliDB $db, $origin_id, $dest_id)
Function used to replace a product id with another one.
fetchLines()
Load object lines in memory from the database.
is_photo_available($sdir)
Return if at least one photo is available.
__construct(DoliDB $db)
Constructor.
calculateCosts()
BOM costs calculation based on cost_price or pmp of each BOM line.
info($id)
Load the info information in the object.
getLibStatut($mode=0)
Return label of the status.
initAsSpecimen()
Initialise object with example values Id must be 0 if object instance is a specimen.
validate($user, $notrigger=0)
Validate bom.
reopen($user, $notrigger=0)
Reopen if canceled.
cancel($user, $notrigger=0)
Set cancel status.
LibStatut($status, $mode=0)
Return the status.
doScheduledJob()
Action executed by scheduler CAN BE A CRON TASK.
getParentBomTreeRecursive(&$TParentBom, $bom_id=0, $level=1)
Recursively retrieves all parent bom in the tree that leads to the $bom_id bom.
getTooltipContentArray($params)
getTooltipContentArray
fetchLinesbytypeproduct($typeproduct=0)
Load object lines in memory from the database by type of product.
deleteLine(User $user, $idline, $notrigger=0)
Delete a line of object in database.
createFromClone(User $user, $fromid)
Clone an object into another one.
fetch($id, $ref=null)
Load object in memory from the database.
getNomUrl($withpicto=0, $option='', $notooltip=0, $morecss='', $save_lastsearch_value=-1)
Return a link to the object card (with optionally the picto)
updateLine($rowid, $qty, $qty_frozen=0, $disable_stock_change=0, $efficiency=1.0, $position=-1, $import_key=null, $fk_unit=0, $array_options=array(), $fk_default_workstation=null)
Update an BOM line into database.
getNetNeeds(&$TNetNeeds=array(), $qty=0)
Get Net needs by product.
create(User $user, $notrigger=1)
Create object into database.
getNextNumRef($prod)
Returns the reference to the following non used BOM depending on the active numbering module defined ...
generateDocument($modele, $outputlangs, $hidedetails=0, $hidedesc=0, $hideref=0, $moreparams=null)
Create a document onto disk according to template module.
getLinesArray()
Create an array of lines.
setDraft($user, $notrigger=0)
Set draft status.
getKanbanView($option='', $arraydata=null)
Return clickable link of object (with eventually picto)
update(User $user, $notrigger=1)
Update object into database.
fetchAll($sortorder='', $sortfield='', $limit=0, $offset=0, $filter='', $filtermode='AND')
Load list of objects in memory from the database.
addLine($fk_product, $qty, $qty_frozen=0, $disable_stock_change=0, $efficiency=1.0, $position=-1, $fk_bom_child=null, $import_key=null, $fk_unit=0, $array_options=array(), $fk_default_workstation=null)
Add an BOM line into database (linked to BOM)
getNetNeedsTree(&$TNetNeeds=array(), $qty=0, $level=0)
Get/add Net needs Tree by product or bom.
Parent class of all other business classes (invoices, contracts, proposals, orders,...
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.
fetch_product()
Load the product with id $this->fk_product into this->product.
fetchLinesCommon($morewhere='', $noextrafields=0)
Load object in memory from the database.
static commonReplaceProduct(DoliDB $dbs, $origin_id, $dest_id, array $tables, $ignoreerrors=0)
Function used to replace a product id with another one.
line_max($fk_parent_line=0)
Get max value used for position of line (rang)
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.
call_trigger($triggerName, $user)
Call trigger based on this instance.
Class to manage Dolibarr database access.
Class to manage predefined suppliers products.
Class to manage products or services.
Class to manage Dolibarr users.
convertDurationtoHour($duration_value, $duration_unit)
Convert duration to hour.
dol_is_file($pathoffile)
Return if path is a file.
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.
img_object($titlealt, $picto, $moreatt='', $pictoisfullpath=0, $srconly=0, $notitle=0)
Show a picto called object_picto (generic function)
img_picto($titlealt, $picto, $moreatt='', $pictoisfullpath=0, $srconly=0, $notitle=0, $alt='', $morecss='', $marginleftonlyshort=2)
Show picto whatever it's its name (generic function)
dol_osencode($str)
Return a string encoded into OS filesystem encoding.
price2num($amount, $rounding='', $option=0)
Function that return a number with universal decimal format (decimal separator is '.
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.
dol_buildpath($path, $type=0, $returnemptyifnotfound=0)
Return path of url or filesystem.
dol_sanitizeFileName($str, $newstr='_', $unaccent=1)
Clean a string to use it as a file name.
dol_print_error($db=null, $error='', $errors=null)
Displays error message system with all the information to facilitate the diagnosis and the escalation...
getDolGlobalString($key, $default='')
Return a Dolibarr global constant string value.
utf8_check($str)
Check if a string is in UTF8.
dol_syslog($message, $level=LOG_INFO, $ident=0, $suffixinfilename='', $restricttologhandler='', $logcontext=null)
Write log message into outputs.
image_format_supported($file, $acceptsvg=0)
Return if a filename is file name of a supported image format.
measuringUnitString($unit, $measuring_style='', $scale='', $use_short_label=0, $outputlangs=null)
Return translation label of a unit key.