dolibarr 22.0.5
inventory.class.php
Go to the documentation of this file.
1<?php
2/* Copyright (C) 2007-2019 Laurent Destailleur <eldy@users.sourceforge.net>
3 * Copyright (C) 2014-2016 Juanjo Menent <jmenent@2byte.es>
4 * Copyright (C) 2015 Florian Henry <florian.henry@open-concept.pro>
5 * Copyright (C) 2015 Raphaël Doursenaud <rdoursenaud@gpcsolutions.fr>
6 * Copyright (C) 2024 Frédéric France <frederic.france@free.fr>
7 * Copyright (C) 2024-2025 MDW <mdeweerd@users.noreply.github.com>
8 *
9 * This program is free software; you can redistribute it and/or modify
10 * it under the terms of the GNU General Public License as published by
11 * the Free Software Foundation; either version 3 of the License, or
12 * (at your option) any later version.
13 *
14 * This program is distributed in the hope that it will be useful,
15 * but WITHOUT ANY WARRANTY; without even the implied warranty of
16 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
17 * GNU General Public License for more details.
18 *
19 * You should have received a copy of the GNU General Public License
20 * along with this program. If not, see <https://www.gnu.org/licenses/>.
21 */
22
29// Put here all includes required by your class file
30require_once DOL_DOCUMENT_ROOT.'/core/class/commonobject.class.php';
31require_once DOL_DOCUMENT_ROOT.'/core/class/commonobjectline.class.php';
32//require_once DOL_DOCUMENT_ROOT . '/societe/class/societe.class.php';
33//require_once DOL_DOCUMENT_ROOT . '/product/class/product.class.php';
34
40{
44 public $element = 'inventory';
45
49 public $table_element = 'inventory';
50
54 public $picto = 'inventory';
55
56 const STATUS_DRAFT = 0; // Draft
57 const STATUS_VALIDATED = 1; // Inventory is in process
58 const STATUS_RECORDED = 2; // Inventory is finisged. Stock movement has been recorded.
59 const STATUS_CANCELED = 9; // Canceled
60
87 // BEGIN MODULEBUILDER PROPERTIES
91 public $fields = array(
92 'rowid' => array('type' => 'integer', 'label' => 'TechnicalID', 'visible' => -1, 'enabled' => 1, 'position' => 1, 'notnull' => 1, 'index' => 1, 'comment' => 'Id',),
93 'ref' => array('type' => 'varchar(64)', 'label' => 'Ref', 'visible' => 1, 'enabled' => 1, 'position' => 10, 'notnull' => 1, 'index' => 1, 'searchall' => 1, 'comment' => 'Reference of object', 'css' => 'maxwidth150'),
94 'entity' => array('type' => 'integer', 'label' => 'Entity', 'visible' => 0, 'enabled' => 1, 'position' => 20, 'notnull' => 1, 'index' => 1,),
95 'title' => array('type' => 'varchar(255)', 'label' => 'Label', 'visible' => 1, 'enabled' => 1, 'position' => 25, 'css' => 'minwidth300', 'csslist' => 'tdoverflowmax150', 'alwayseditable' => 1),
96 'fk_warehouse' => array('type' => 'integer:Entrepot:product/stock/class/entrepot.class.php', 'label' => 'Warehouse', 'visible' => 1, 'enabled' => 1, 'position' => 30, 'index' => 1, 'help' => 'InventoryForASpecificWarehouse', 'picto' => 'stock', 'css' => 'minwidth300 maxwidth500 widthcentpercentminusx', 'csslist' => 'tdoverflowmax150'),
97 'fk_product' => array('type' => 'integer:Product:product/class/product.class.php', 'label' => 'Product', 'get_name_url_params' => '0::0:-1:0::1', 'visible' => 1, 'enabled' => 1, 'position' => 32, 'index' => 1, 'help' => 'InventoryForASpecificProduct', 'picto' => 'product', 'css' => 'minwidth300 maxwidth500 widthcentpercentminusx', 'csslist' => 'tdoverflowmax150'),
98 'categories_product' => array('type' => 'chkbxlst:categorie:label:rowid::type=0:0:', 'label' => 'OrProductsWithCategories', 'visible' => 3, 'enabled' => 1, 'position' => 33, 'help' => '', 'picto' => 'category', 'css' => 'minwidth300 maxwidth500 widthcentpercentminusx'),
99 'date_inventory' => array('type' => 'date', 'label' => 'DateValue', 'visible' => 1, 'enabled' => '$conf->global->STOCK_INVENTORY_ADD_A_VALUE_DATE', 'position' => 35, 'csslist' => 'nowraponall'), // This date is not used so disabled by default.
100 'date_creation' => array('type' => 'datetime', 'label' => 'DateCreation', 'enabled' => 1, 'visible' => -2, 'notnull' => 1, 'position' => 500, 'csslist' => 'nowraponall'),
101 'tms' => array('type' => 'timestamp', 'label' => 'DateModification', 'enabled' => 1, 'visible' => -2, 'notnull' => 1, 'position' => 501, 'csslist' => 'nowraponall'),
102 'date_validation' => array('type' => 'datetime', 'label' => 'DateValidation', 'visible' => -2, 'enabled' => 1, 'position' => 502, 'csslist' => 'nowraponall'),
103 'fk_user_creat' => array('type' => 'integer:User:user/class/user.class.php', 'label' => 'UserAuthor', 'enabled' => 1, 'visible' => -2, 'notnull' => 1, 'position' => 510, 'foreignkey' => 'user.rowid', 'csslist' => 'tdoverflowmax150'),
104 'fk_user_modif' => array('type' => 'integer:User:user/class/user.class.php', 'label' => 'UserModif', 'enabled' => 1, 'visible' => -2, 'notnull' => -1, 'position' => 511, 'csslist' => 'tdoverflowmax150'),
105 'fk_user_valid' => array('type' => 'integer:User:user/class/user.class.php', 'label' => 'UserValidation', 'visible' => -2, 'enabled' => 1, 'position' => 512, 'csslist' => 'tdoverflowmax150'),
106 'import_key' => array('type' => 'varchar(14)', 'label' => 'ImportId', 'enabled' => 1, 'visible' => -2, 'notnull' => -1, 'index' => 0, 'position' => 1000),
107 'status' => array('type' => 'integer', 'label' => 'Status', 'visible' => 4, 'enabled' => 1, 'position' => 1000, 'notnull' => 1, 'default' => '0', 'index' => 1, 'arrayofkeyval' => array(0 => 'Draft', 1 => 'Validated', 2 => 'Closed', 9 => 'Canceled'))
108 );
109
113 public $rowid;
114
118 public $ref;
119
123 public $entity;
124
128 public $fk_warehouse;
129
133 public $fk_product;
134
138 public $categories_product;
142 public $date_inventory;
146 public $title;
147
151 public $status;
152
156 public $fk_user_creat;
157
161 public $fk_user_modif;
162
166 public $fk_user_valid;
167
171 public $import_key;
172 // END MODULEBUILDER PROPERTIES
173
174
175
176 // If this object has a subtable with lines
177
181 public $table_element_line = 'inventorydet';
182
186 public $fk_element = 'fk_inventory';
187
191 public $class_element_line = 'Inventoryline';
192
196 protected $childtables = array();
200 protected $childtablesoncascade = array('inventorydet');
201
205 public $lines = array();
206
207
208
214 public function __construct(DoliDB $db)
215 {
216 global $conf;
217
218 $this->db = $db;
219
220 $this->ismultientitymanaged = 1;
221 $this->isextrafieldmanaged = 0;
222
223 if (!getDolGlobalString('MAIN_SHOW_TECHNICAL_ID')) {
224 $this->fields['rowid']['visible'] = 0;
225 }
226 if (!isModEnabled('multicompany')) {
227 $this->fields['entity']['enabled'] = 0;
228 }
229 }
230
231
239 public function create(User $user, $notrigger = 0)
240 {
241 $result = $this->createCommon($user, $notrigger);
242
243 return $result;
244 }
245
254 public function validate(User $user, $notrigger = 0, $include_sub_warehouse = 0)
255 {
256 $this->db->begin();
257
258 $result = 0;
259
260 if ($this->status == self::STATUS_DRAFT) {
261 // Delete inventory
262 $sql = 'DELETE FROM '.$this->db->prefix().'inventorydet WHERE fk_inventory = '.((int) $this->id);
263 $resql = $this->db->query($sql);
264 if (!$resql) {
265 $this->error = $this->db->lasterror();
266 $this->db->rollback();
267 return -1;
268 }
269
270 // Scan existing stock to prefill the inventory
271 $sql = "SELECT ps.rowid, ps.fk_entrepot as fk_warehouse, ps.fk_product, ps.reel,";
272 if (isModEnabled('productbatch')) {
273 $sql .= " COALESCE(pb.batch, '') as batch, pb.qty as qty,";
274 } else {
275 $sql .= " '' as batch, 0 as qty,";
276 }
277 $sql .= " p.ref, p.tobatch";
278 $sql .= " FROM ".$this->db->prefix()."product_stock as ps";
279 if (isModEnabled('productbatch')) {
280 $sql .= " LEFT JOIN ".$this->db->prefix()."product_batch as pb ON pb.fk_product_stock = ps.rowid";
281 }
282 $sql .= ", ".$this->db->prefix()."product as p, ".$this->db->prefix()."entrepot as e";
283 $sql .= " WHERE p.entity IN (".getEntity('product').")";
284 $sql .= " AND e.entity IN (".getEntity('stock').")";
285 $sql .= " AND ps.fk_product = p.rowid AND ps.fk_entrepot = e.rowid";
286 if (!getDolGlobalString('STOCK_SUPPORTS_SERVICES')) {
287 $sql .= " AND p.fk_product_type = 0";
288 }
289 if ($this->fk_product > 0) {
290 $sql .= " AND ps.fk_product = ".((int) $this->fk_product);
291 }
292 if ($this->fk_warehouse > 0) {
293 $sql .= " AND (ps.fk_entrepot = ".((int) $this->fk_warehouse);
294 if (!empty($include_sub_warehouse) && getDolGlobalInt('INVENTORY_INCLUDE_SUB_WAREHOUSE')) {
295 $TChildWarehouses = array();
296 $this->getChildWarehouse($this->fk_warehouse, $TChildWarehouses);
297 if (!empty($TChildWarehouses)) {
298 $sql .= " OR ps.fk_entrepot IN (" . $this->db->sanitize(implode(',', $TChildWarehouses)) . ")";
299 }
300 }
301 $sql .= ')';
302 }
303 if (!empty($this->categories_product)) {
304 $sql .= " AND EXISTS (";
305 $sql .= " SELECT cp.fk_product";
306 $sql .= " FROM ".$this->db->prefix()."categorie_product AS cp";
307 $sql .= " WHERE cp.fk_product = ps.fk_product";
308 $sql .= " AND cp.fk_categorie IN (".$this->db->sanitize($this->categories_product).")";
309 $sql .= ")";
310 }
311 if (getDolGlobalInt('PRODUIT_SOUSPRODUITS')) {
312 $sql .= " AND NOT EXISTS (";
313 $sql .= " SELECT pa.rowid";
314 $sql .= " FROM ".$this->db->prefix()."product_association as pa";
315 $sql .= " WHERE pa.fk_product_pere = ps.fk_product";
316 $sql .= ")";
317 }
318 $sql .= " ORDER BY p.rowid";
319
320 $inventoryline = new InventoryLine($this->db);
321
322 $resql = $this->db->query($sql);
323 if ($resql) {
324 $num = $this->db->num_rows($resql);
325
326 $i = 0;
327 while ($i < $num) {
328 $obj = $this->db->fetch_object($resql);
329
330 $inventoryline->fk_inventory = $this->id;
331 $inventoryline->fk_warehouse = $obj->fk_warehouse;
332 $inventoryline->fk_product = $obj->fk_product;
333 $inventoryline->batch = $obj->batch;
334 $inventoryline->datec = dol_now();
335
336 if (isModEnabled('productbatch')) {
337 if ($obj->batch && empty($obj->tobatch)) {
338 // Bad consistency of data. The product is not a product with lot/serial but we found a stock for some lot/serial.
339 $result = -2;
340 $this->error = 'The product ID='.$obj->ref." has stock with lot/serial but is configured to not manage lot/serial. You must first fix this, this way: Set the product to have 'Management of Lot/Serial' to Yes, then set it back to 'Management of Lot/Serial to No";
341 break;
342 }
343
344 $inventoryline->qty_stock = ($obj->batch ? $obj->qty : $obj->reel); // If there is batch detail, we take qty for batch, else global qty
345 } else {
346 $inventoryline->qty_stock = $obj->reel;
347 }
348 //var_dump($obj->batch.' '.$obj->qty.' '.$obj->reel.' '.$this->error);exit;
349
350 $resultline = $inventoryline->create($user);
351 if ($resultline <= 0) {
352 $this->error = $inventoryline->error;
353 $this->errors = $inventoryline->errors;
354 $result = -1;
355 break;
356 }
357
358 $i++;
359 }
360 } else {
361 $result = -1;
362 $this->error = $this->db->lasterror();
363 }
364 }
365
366 if ($result >= 0) {
367 $result = $this->setStatut($this::STATUS_VALIDATED, null, '', 'INVENTORY_VALIDATED');
368 }
369
370 if ($result > 0) {
371 $this->db->commit();
372 } else {
373 $this->db->rollback();
374 }
375 return $result;
376 }
377
385 public function setDraft(User $user, $notrigger = 0)
386 {
387 $this->db->begin();
388
389 // Delete inventory
390 $sql = 'DELETE FROM '.$this->db->prefix().'inventorydet WHERE fk_inventory = '.((int) $this->id);
391 $resql = $this->db->query($sql);
392 if (!$resql) {
393 $this->error = $this->db->lasterror();
394 $this->db->rollback();
395 return -1;
396 }
397
398 $result = $this->setStatut($this::STATUS_DRAFT, null, '', 'INVENTORY_DRAFT');
399
400 if ($result > 0) {
401 $this->db->commit();
402 } else {
403 $this->db->rollback();
404 }
405 return $result;
406 }
407
415 public function setRecorded(User $user, $notrigger = 0)
416 {
417 $this->db->begin();
418
419 $result = $this->setStatut($this::STATUS_RECORDED, null, '', 'INVENTORY_RECORDED');
420
421 if ($result > 0) {
422 $this->db->commit();
423 } else {
424 $this->db->rollback();
425 return -1;
426 }
427 return $result;
428 }
429
437 public function setCanceled(User $user, $notrigger = 0)
438 {
439 $this->db->begin();
440
441 $result = $this->setStatut($this::STATUS_CANCELED, null, '', 'INVENTORY_CANCELED');
442
443 if ($result > 0) {
444 $this->db->commit();
445 } else {
446 $this->db->rollback();
447 return -1;
448 }
449 return $result;
450 }
451
459 public function createFromClone(User $user, $fromid)
460 {
461 global $hookmanager, $langs;
462 $error = 0;
463
464 dol_syslog(__METHOD__, LOG_DEBUG);
465
466 $object = new self($this->db);
467
468 $this->db->begin();
469
470 // Load source object
471 $object->fetchCommon($fromid);
472 // Reset some properties
473 unset($object->id);
474 unset($object->fk_user_creat);
475 unset($object->import_key);
476
477 // Clear fields
478 $object->ref = "copy_of_".$object->ref;
479 $object->title = $langs->trans("CopyOf")." ".$object->title;
480 // ...
481
482 // Create clone
483 $object->context['createfromclone'] = 'createfromclone';
484 $result = $object->createCommon($user);
485 if ($result < 0) {
486 $error++;
487 $this->error = $object->error;
488 $this->errors = $object->errors;
489 }
490
491 unset($object->context['createfromclone']);
492
493 // End
494 if (!$error) {
495 $this->db->commit();
496 return $object;
497 } else {
498 $this->db->rollback();
499 return -1;
500 }
501 }
502
510 public function fetch($id, $ref = null)
511 {
512 $result = $this->fetchCommon($id, $ref);
513 //if ($result > 0 && !empty($this->table_element_line)) $this->fetchLines();
514 return $result;
515 }
516
522 /*public function fetchLines()
523 {
524 $this->lines=array();
525
526 // Load lines with object MyObjectLine
527
528 return count($this->lines)?1:0;
529 }*/
530
538 public function update(User $user, $notrigger = 0)
539 {
540 return $this->updateCommon($user, $notrigger);
541 }
542
550 public function delete(User $user, $notrigger = 0)
551 {
552 return $this->deleteCommon($user, $notrigger);
553 }
554
563 public function deleteLine(User $user, $idline, $notrigger = 0)
564 {
565 if ($this->status < 0) {
566 $this->error = 'ErrorDeleteLineNotAllowedByObjectStatus';
567 return -2;
568 }
569
570 return $this->deleteLineCommon($user, $idline, $notrigger);
571 }
572
583 public function getNomUrl($withpicto = 0, $option = '', $notooltip = 0, $morecss = '', $save_lastsearch_value = -1)
584 {
585 global $db, $conf, $langs;
586 global $dolibarr_main_authentication, $dolibarr_main_demo;
587 global $menumanager;
588
589 if (!empty($conf->dol_no_mouse_hover)) {
590 $notooltip = 1; // Force disable tooltips
591 }
592
593 $result = '';
594 $companylink = '';
595
596 $label = '<u>'.$langs->trans("Inventory").'</u>';
597 $label .= '<br>';
598 $label .= '<b>'.$langs->trans('Ref').':</b> '.$this->ref;
599
600 $url = dol_buildpath('/product/inventory/card.php', 1).'?id='.$this->id;
601
602 $linkclose = '';
603 if (empty($notooltip)) {
604 if (getDolGlobalString('MAIN_OPTIMIZEFORTEXTBROWSER')) {
605 $label = $langs->trans("ShowInventory");
606 $linkclose .= ' alt="'.dolPrintHTMLForAttribute($label).'"';
607 }
608 $linkclose .= ' title="'.dolPrintHTMLForAttribute($label).'"';
609 $linkclose .= ' class="classfortooltip'.($morecss ? ' '.$morecss : '').'"';
610 } else {
611 $linkclose = ($morecss ? ' class="'.$morecss.'"' : '');
612 }
613
614 $linkstart = '<a href="'.$url.'"';
615 $linkstart .= $linkclose.'>';
616 $linkend = '</a>';
617
618 $result .= $linkstart;
619 if ($withpicto) {
620 $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);
621 }
622 if ($withpicto != 2) {
623 $result .= $this->ref;
624 }
625 $result .= $linkend;
626 //if ($withpicto != 2) $result.=(($addlabel && $this->label) ? $sep . dol_trunc($this->label, ($addlabel > 1 ? $addlabel : 0)) : '');
627
628 return $result;
629 }
630
637 public function getLibStatut($mode = 0)
638 {
639 return $this->LibStatut($this->status, $mode);
640 }
641
642 // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
650 public function LibStatut($status, $mode = 0)
651 {
652 // phpcs:enable
653 global $langs, $hookmanager;
654
655 $labelStatus = array();
656 $labelStatusShort = array();
657 $labelStatus[self::STATUS_DRAFT] = $langs->transnoentitiesnoconv('Draft');
658 $labelStatus[self::STATUS_VALIDATED] = $langs->transnoentitiesnoconv('Validated').' ('.$langs->transnoentitiesnoconv('InventoryStartedShort').')';
659 $labelStatus[self::STATUS_CANCELED] = $langs->transnoentitiesnoconv('Canceled');
660 $labelStatus[self::STATUS_RECORDED] = $langs->transnoentitiesnoconv('Closed');
661 $labelStatusShort[self::STATUS_DRAFT] = $langs->transnoentitiesnoconv('Draft');
662 $labelStatusShort[self::STATUS_VALIDATED] = $langs->transnoentitiesnoconv('InventoryStartedShort');
663 $labelStatusShort[self::STATUS_CANCELED] = $langs->transnoentitiesnoconv('Canceled');
664 $labelStatusShort[self::STATUS_RECORDED] = $langs->transnoentitiesnoconv('Closed');
665
666 $statusType = 'status'.$status;
667 if ($status == self::STATUS_RECORDED) {
668 $statusType = 'status6';
669 }
670
671 $parameters = array('status' => $status, 'mode' => $mode);
672 $reshook = $hookmanager->executeHooks('LibStatut', $parameters, $this); // Note that $action and $object may have been modified by hook
673 if ($reshook > 0) {
674 return $hookmanager->resPrint;
675 }
676 return dolGetStatus($labelStatus[$status], $labelStatusShort[$status], '', $statusType, $mode);
677 }
678
686 public function getKanbanView($option = '', $arraydata = null)
687 {
688 global $conf, $langs;
689
690 $selected = (empty($arraydata['selected']) ? 0 : $arraydata['selected']);
691
692 $return = '<div class="box-flex-item box-flex-grow-zero">';
693 $return .= '<div class="info-box info-box-sm">';
694 $return .= '<span class="info-box-icon bg-infobox-action">';
695 $return .= img_picto('', $this->picto);
696 $return .= '</span>';
697 $return .= '<div class="info-box-content">';
698 $return .= '<span class="info-box-ref inline-block tdoverflowmax150 valignmiddle">'.(method_exists($this, 'getNomUrl') ? $this->getNomUrl() : $this->ref).'</span>';
699 if ($selected >= 0) {
700 $return .= '<input id="cb'.$this->id.'" class="flat checkforselect fright" type="checkbox" name="toselect[]" value="'.$this->id.'"'.($selected ? ' checked="checked"' : '').'>';
701 }
702 if (property_exists($this, 'label')) {
703 $return .= ' <div class="inline-block opacitymedium valignmiddle tdoverflowmax100">'.$this->label.'</div>';
704 }
705 if (property_exists($this, 'amount')) {
706 $return .= '<br>';
707 $return .= '<span class="info-box-label amount">'.price($this->amount, 0, $langs, 1, -1, -1, $conf->currency).'</span>';
708 }
709 if (method_exists($this, 'getLibStatut')) {
710 $return .= '<br><div class="info-box-status">'.$this->getLibStatut(3).'</div>';
711 }
712 $return .= '</div>';
713 $return .= '</div>';
714 $return .= '</div>';
715
716 return $return;
717 }
718
725 public function info($id)
726 {
727 $sql = "SELECT rowid, date_creation as datec, tms as datem, date_validation as datev,";
728 $sql .= " fk_user_creat, fk_user_modif, fk_user_valid";
729 $sql .= " FROM ".$this->db->prefix().$this->table_element." as t";
730 $sql .= " WHERE t.rowid = ".((int) $id);
731 $result = $this->db->query($sql);
732 if ($result) {
733 if ($this->db->num_rows($result)) {
734 $obj = $this->db->fetch_object($result);
735
736 $this->id = $obj->rowid;
737
738 $this->user_creation_id = $obj->fk_user_creat;
739 $this->user_modification_id = $obj->fk_user_modif;
740 $this->user_validation_id = $obj->fk_user_valid;
741
742 $this->date_creation = $this->db->jdate($obj->datec);
743 $this->date_modification = $this->db->jdate($obj->datem);
744 $this->date_validation = $this->db->jdate($obj->datev);
745 }
746
747 $this->db->free($result);
748 } else {
749 dol_print_error($this->db);
750 }
751 }
752
759 public function initAsSpecimen()
760 {
761 $ret = $this->initAsSpecimenCommon();
762 $this->title = '';
763
764 return $ret;
765 }
766
774 public function getChildWarehouse($id, &$TChildWarehouse)
775 {
776 $sql = 'SELECT rowid FROM '.MAIN_DB_PREFIX.'entrepot';
777 $sql .= ' WHERE fk_parent='.(int) $id;
778 $sql .= ' ORDER BY rowid';
779 $resql = $this->db->query($sql);
780 if ($resql && $this->db->num_rows($resql) > 0) {
781 while ($obj = $this->db->fetch_object($resql)) {
782 $TChildWarehouse[] = $obj->rowid;
783 $this->getChildWarehouse($obj->rowid, $TChildWarehouse);
784 }
785 return 1;
786 } else {
787 return -1;
788 }
789 }
790}
791
796{
800 public $element = 'inventoryline';
801
805 public $table_element = 'inventorydet';
806
810 public $parent_element = 'inventory';
811
815 public $fk_parent_attribute = 'fk_inventory';
816
820 public $picto = 'stock';
821
839 // BEGIN MODULEBUILDER PROPERTIES
843 public $fields = array(
844 'rowid' => array('type' => 'integer', 'label' => 'TechnicalID', 'visible' => -1, 'enabled' => 1, 'position' => 1, 'notnull' => 1, 'index' => 1, 'comment' => 'Id',),
845 'fk_inventory' => array('type' => 'integer:Inventory:product/inventory/class/inventory.class.php', 'label' => 'Inventory', 'visible' => 1, 'enabled' => 1, 'position' => 30, 'index' => 1, 'help' => 'LinkToInventory'),
846 'fk_warehouse' => array('type' => 'integer:Entrepot:product/stock/class/entrepot.class.php', 'label' => 'Warehouse', 'visible' => 1, 'enabled' => 1, 'position' => 30, 'index' => 1, 'help' => 'LinkToThirdparty'),
847 'fk_product' => array('type' => 'integer:Product:product/class/product.class.php', 'label' => 'Product', 'visible' => 1, 'enabled' => 1, 'position' => 32, 'index' => 1, 'help' => 'LinkToProduct'),
848 'batch' => array('type' => 'string', 'label' => 'Batch', 'visible' => 1, 'enabled' => 1, 'position' => 32, 'index' => 1, 'help' => 'LinkToProduct'),
849 'datec' => array('type' => 'datetime', 'label' => 'DateCreation', 'enabled' => 1, 'visible' => -2, 'notnull' => 1, 'position' => 500),
850 'tms' => array('type' => 'timestamp', 'label' => 'DateModification', 'enabled' => 1, 'visible' => -2, 'notnull' => 1, 'position' => 501),
851 'qty_stock' => array('type' => 'double', 'label' => 'QtyFound', 'visible' => 1, 'enabled' => 1, 'position' => 32, 'index' => 1, 'help' => 'Qty we found/want (to define during draft edition)'),
852 'qty_view' => array('type' => 'double', 'label' => 'QtyBefore', 'visible' => 1, 'enabled' => 1, 'position' => 33, 'index' => 1, 'help' => 'Qty before (filled once movements are validated)'),
853 'qty_regulated' => array('type' => 'double', 'label' => 'QtyDelta', 'visible' => 1, 'enabled' => 1, 'position' => 34, 'index' => 1, 'help' => 'Qty added or removed (filled once movements are validated)'),
854 'pmp_real' => array('type' => 'double', 'label' => 'PMPReal', 'visible' => 1, 'enabled' => 1, 'position' => 35),
855 'pmp_expected' => array('type' => 'double', 'label' => 'PMPExpected', 'visible' => 1, 'enabled' => 1, 'position' => 36),
856 );
857
861 public $rowid;
862
866 public $fk_inventory;
870 public $fk_warehouse;
874 public $fk_product;
878 public $batch;
882 public $datec;
883
887 public $qty_stock;
888
892 public $qty_view;
893
897 public $qty_regulated;
898
902 public $pmp_real;
906 public $pmp_expected;
907
913 public function __construct($db)
914 {
915 $this->db = $db;
916 $this->ismultientitymanaged = 0;
917
918 $this->isextrafieldmanaged = 0;
919 }
927 public function create(User $user, $notrigger = 0)
928 {
929 return $this->createCommon($user, $notrigger);
930 }
931
939 public function fetch($id, $ref = null)
940 {
941 $result = $this->fetchCommon($id, $ref);
942 //if ($result > 0 && !empty($this->table_element_line)) $this->fetchLines();
943 return $result;
944 }
945
953 public function update(User $user, $notrigger = 0)
954 {
955 return $this->updateCommon($user, $notrigger);
956 }
957
965 public function delete(User $user, $notrigger = 0)
966 {
967 return $this->deleteCommon($user, $notrigger);
968 //return $this->deleteCommon($user, $notrigger, 1);
969 }
970}
if( $user->socid > 0) if(! $user->hasRight('accounting', 'chartofaccount')) $object
Definition card.php:67
Parent class of all other business classes (invoices, contracts, proposals, orders,...
deleteLineCommon(User $user, $idline, $notrigger=0)
Delete a line of object in database.
createCommon(User $user, $notrigger=0)
Create object in the database.
setStatut($status, $elementId=null, $elementType='', $trigkey='', $fieldstatus='fk_statut')
Set status of an object.
updateCommon(User $user, $notrigger=0)
Update object into database.
initAsSpecimenCommon()
Initialise object with example values Id must be 0 if object instance is a specimen.
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.
Class for Inventory.
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.
setRecorded(User $user, $notrigger=0)
Set to inventory to status "Closed".
LibStatut($status, $mode=0)
Return the status.
getKanbanView($option='', $arraydata=null)
Return a thumb for kanban views.
__construct(DoliDB $db)
Constructor.
getLibStatut($mode=0)
Return the label of the status.
info($id)
Charge les information d'ordre info dans l'objet commande.
setDraft(User $user, $notrigger=0)
Go back to draft.
update(User $user, $notrigger=0)
Load object lines in memory from the database.
setCanceled(User $user, $notrigger=0)
Set to Canceled.
validate(User $user, $notrigger=0, $include_sub_warehouse=0)
Validate inventory (start it)
initAsSpecimen()
Initialise object with example values Id must be 0 if object instance is a specimen.
deleteLine(User $user, $idline, $notrigger=0)
Delete a line of object in database.
fetch($id, $ref=null)
Load object in memory from the database.
getChildWarehouse($id, &$TChildWarehouse)
Return the child warehouse of the current one.
createFromClone(User $user, $fromid)
Clone and object into another one.
Class InventoryLine.
update(User $user, $notrigger=0)
Update object into database.
__construct($db)
Constructor.
create(User $user, $notrigger=0)
Create object in database.
fetch($id, $ref=null)
Load object in memory from the database.
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:171
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_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.
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...
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
global $dolibarr_main_demo
Definition index.php:57