dolibarr 23.0.4
mouvementstock.class.php
Go to the documentation of this file.
1<?php
2/* Copyright (C) 2003-2006 Rodolphe Quiedeville <rodolphe@quiedeville.org>
3 * Copyright (C) 2005-2015 Laurent Destailleur <eldy@users.sourceforge.net>
4 * Copyright (C) 2011 Jean Heimburger <jean@tiaris.info>
5 * Copyright (C) 2014 Cedric GROSS <c.gross@kreiz-it.fr>
6 * Copyright (C) 2024-2025 MDW <mdeweerd@users.noreply.github.com>
7 * Copyright (C) 2024-2025 Frédéric France <frederic.france@free.fr>
8 * Copyright (C) 2026 Jose Martinez <jose.martinez@pichinov.com>
9 *
10 * This program is free software; you can redistribute it and/or modify
11 * it under the terms of the GNU General Public License as published by
12 * the Free Software Foundation; either version 3 of the License, or
13 * (at your option) any later version.
14 *
15 * This program is distributed in the hope that it will be useful,
16 * but WITHOUT ANY WARRANTY; without even the implied warranty of
17 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
18 * GNU General Public License for more details.
19 *
20 * You should have received a copy of the GNU General Public License
21 * along with this program. If not, see <https://www.gnu.org/licenses/>.
22 */
23
35{
39 public $element = 'stockmouvement';
40
44 public $table_element = 'stock_mouvement';
45
46
50 public $product_id;
51
57 public $entrepot_id;
58
62 public $warehouse_id;
63
67 public $qty;
68
77 public $type;
78
82 public $datem = '';
86 public $price;
87
91 public $fk_user_author;
92
96 public $label;
97
103 public $fk_origin;
104
108 public $origin_id;
109
115 public $origintype;
116
120 public $origin_type;
124 public $line_id_oject_src;
128 public $line_id_oject_origin;
129
135 public $inventorycode;
136
140 public $movementcode;
141
145 public $batch;
146
150 public $line_id_object_src;
154 public $line_id_object_origin;
155
159 public $eatby;
160
164 public $sellby;
165
166
167
168 public $fields = array(
169 'rowid' => array('type' => 'integer', 'label' => 'TechnicalID', 'enabled' => 1, 'visible' => -1, 'notnull' => 1, 'position' => 10, 'showoncombobox' => 1),
170 'tms' => array('type' => 'timestamp', 'label' => 'DateModification', 'enabled' => 1, 'visible' => -1, 'notnull' => 1, 'position' => 15),
171 'datem' => array('type' => 'datetime', 'label' => 'Datem', 'enabled' => 1, 'visible' => -1, 'position' => 20),
172 'fk_product' => array('type' => 'integer:Product:product/class/product.class.php:1', 'label' => 'Product', 'enabled' => 1, 'visible' => -1, 'notnull' => 1, 'position' => 25),
173 'fk_entrepot' => array('type' => 'integer:Entrepot:product/stock/class/entrepot.class.php', 'label' => 'Warehouse', 'enabled' => 1, 'visible' => -1, 'notnull' => 1, 'position' => 30),
174 'value' => array('type' => 'double', 'label' => 'Value', 'enabled' => 1, 'visible' => -1, 'position' => 35),
175 'price' => array('type' => 'double(24,8)', 'label' => 'Price', 'enabled' => 1, 'visible' => -1, 'position' => 40),
176 'type_mouvement' => array('type' => 'smallint(6)', 'label' => 'Type mouvement', 'enabled' => 1, 'visible' => -1, 'position' => 45),
177 'fk_user_author' => array('type' => 'integer:User:user/class/user.class.php', 'label' => 'UserAuthor', 'enabled' => 1, 'visible' => -1, 'position' => 50),
178 'label' => array('type' => 'varchar(255)', 'label' => 'Label', 'enabled' => 1, 'visible' => -1, 'position' => 55),
179 'fk_origin' => array('type' => 'integer', 'label' => 'Fk origin', 'enabled' => 1, 'visible' => -1, 'position' => 60),
180 'origintype' => array('type' => 'varchar(32)', 'label' => 'Origintype', 'enabled' => 1, 'visible' => -1, 'position' => 65),
181 'model_pdf' => array('type' => 'varchar(255)', 'label' => 'Model pdf', 'enabled' => 1, 'visible' => 0, 'position' => 70),
182 'fk_projet' => array('type' => 'integer:Project:projet/class/project.class.php:1:(fk_statut:=:1)', 'label' => 'Project', 'enabled' => 'isModEnabled("project")', 'visible' => -1, 'notnull' => 1, 'position' => 75),
183 'inventorycode' => array('type' => 'varchar(128)', 'label' => 'InventoryCode', 'enabled' => 1, 'visible' => -1, 'position' => 80),
184 'batch' => array('type' => 'varchar(30)', 'label' => 'Batch', 'enabled' => 1, 'visible' => -1, 'position' => 85),
185 'eatby' => array('type' => 'date', 'label' => 'Eatby', 'enabled' => 1, 'visible' => -1, 'position' => 90),
186 'sellby' => array('type' => 'date', 'label' => 'Sellby', 'enabled' => 1, 'visible' => -1, 'position' => 95),
187 'fk_project' => array('type' => 'integer:Project:projet/class/project.class.php:1:(fk_statut:=:1)', 'label' => 'Fk project', 'enabled' => 1, 'visible' => -1, 'position' => 100),
188 );
189
190
191
197 public function __construct($db)
198 {
199 $this->db = $db;
200 }
201
202 // phpcs:disable PEAR.NamingConventions.ValidFunctionName.PublicUnderscore
230 public function _create($user, $fk_product, $entrepot_id, $qty, $type, $price = 0, $label = '', $inventorycode = '', $datem = '', $eatby = 0, $sellby = 0, $batch = '', $skip_batch = false, $id_product_batch = 0, $disablestockchangeforsubproduct = 0, $donotcleanemptylines = 0, $force_update_batch = false)
231 {
232 // phpcs:enable
233 global $conf, $langs;
234
235 require_once DOL_DOCUMENT_ROOT.'/product/class/product.class.php';
236 require_once DOL_DOCUMENT_ROOT.'/product/stock/class/productlot.class.php';
237
238 $error = 0;
239 dol_syslog(get_class($this)."::_create start userid=$user->id, fk_product=$fk_product, warehouse_id=$entrepot_id, qty=$qty, type=$type, price=$price, label=$label, inventorycode=$inventorycode, datem=".$datem.", eatby=".$eatby.", sellby=".$sellby.", batch=".$batch.", skip_batch=".json_encode($skip_batch));
240
241 // Call hook at beginning
242 global $action, $hookmanager;
243 $hookmanager->initHooks(array('mouvementstock'));
244
245 if (is_object($hookmanager)) {
246 $parameters = array(
247 'currentcontext' => 'mouvementstock',
248 'user' => &$user,
249 'fk_product' => &$fk_product,
250 'entrepot_id' => &$entrepot_id,
251 'qty' => &$qty,
252 'type' => &$type,
253 'price' => &$price,
254 'label' => &$label,
255 'inventorycode' => &$inventorycode,
256 'datem' => &$datem,
257 'eatby' => &$eatby,
258 'sellby' => &$sellby,
259 'batch' => &$batch,
260 'skip_batch' => &$skip_batch,
261 'id_product_batch' => &$id_product_batch
262 );
263 $reshook = $hookmanager->executeHooks('stockMovementCreate', $parameters, $this, $action); // Note that $action and $object may have been modified by some hooks
264
265 if ($reshook < 0) {
266 if (!empty($hookmanager->resPrint)) {
267 dol_print_error(null, $hookmanager->resPrint);
268 }
269 return $reshook;
270 } elseif ($reshook > 0) {
271 return $reshook;
272 }
273 }
274 // end hook at beginning
275
276 // Clean parameters
277 $price = price2num($price, 'MU'); // Clean value for the casse we receive a float zero value, to have it a real zero value.
278 if (empty($price)) {
279 $price = 0;
280 }
281 $now = (!empty($datem) ? $datem : dol_now());
282
283 //print "livraison fk_product=".$fk_product." entrepot_id=".$entrepot_id; exit;
284
285 // Check parameters
286 if (!($fk_product > 0)) {
287 return 0;
288 }
289 if (!($entrepot_id > 0)) {
290 return 0;
291 }
292
293 if (is_numeric($eatby) && $eatby < 0) {
294 dol_syslog(get_class($this)."::_create start ErrorBadValueForParameterEatBy eatby = ".$eatby);
295 $this->errors[] = 'ErrorBadValueForParameterEatBy';
296 return -1;
297 }
298 if (is_numeric($sellby) && $sellby < 0) {
299 dol_syslog(get_class($this)."::_create start ErrorBadValueForParameterSellBy sellby = ".$sellby);
300 $this->errors[] = 'ErrorBadValueForParameterSellBy';
301 return -1;
302 }
303
304 // Set properties of movement
305 $this->product_id = $fk_product;
306 $this->entrepot_id = $entrepot_id; // deprecated
307 $this->warehouse_id = $entrepot_id;
308 $this->qty = $qty;
309 $this->type = $type;
310 $this->price = price2num($price);
311 $this->label = $label;
312 $this->inventorycode = $inventorycode;
313 $this->datem = $now;
314 $this->batch = $batch;
315
316 $mvid = 0;
317
318 $product = new Product($this->db);
319
320 $result = $product->fetch($fk_product);
321 if ($result < 0) {
322 $this->setErrorsFromObject($product);
323 dol_print_error(null, "Failed to fetch product");
324 return -1;
325 }
326 if ($product->id <= 0) { // Can happen if database is corrupted (a product id exist in stock with product that has been removed)
327 return 0;
328 }
329
330 // Define if we must make the stock change (If product type is a service or if stock is used also for services)
331 // Only record into stock tables will be disabled by this (the rest like writing into lot table or movement of subproucts are done)
332 $movestock = 0;
333 $productChildrenNb = 0;
334 if (getDolGlobalInt('PRODUIT_SOUSPRODUITS')) {
335 $productChildrenNb = $product->hasFatherOrChild(1);
336 }
337
338 if ($product->isStockManaged() && ($productChildrenNb == 0 || getDolGlobalInt('PRODUIT_SOUSPRODUITS_ALSO_ENABLE_PARENT_STOCK_MOVE'))) { // For kit parent, we disable stock move, except if option PRODUIT_SOUSPRODUITS_ALSO_ENABLE_PARENT_STOCK_MOVE is set. For this option on, code must be completed to finish implementation, for example to have kit supported in shipments.
339 $movestock = 1;
340 }
341
342 $this->db->begin();
343
344 // Set value $product->stock_reel and detail per warehouse into $product->stock_warehouse array
345 if ($movestock) {
346 $product->load_stock('novirtual');
347 }
348
349 // Test if product require batch data. If yes, and there is not or values are not correct, we throw an error.
350 if (isModEnabled('productbatch') && $product->hasbatch() && !$skip_batch) {
351 if (empty($batch)) {
352 $langs->load("errors");
353 $this->errors[] = $langs->transnoentitiesnoconv("ErrorTryToMakeMoveOnProductRequiringBatchData", $product->ref);
354 dol_syslog("Try to make a movement of a product with status_batch on without any batch data", LOG_ERR);
355
356 $this->db->rollback();
357 return -2;
358 }
359
360 // An outgoing movement (qty < 0) takes the eat-by/sell-by dates of the lot as they are now: the dates given by
361 // the caller (often a copy kept on the line of a reception or shipment, so maybe outdated since the dates were
362 // corrected on the lot) must not block the movement nor be saved into the lot.
363 if ($qty < 0) {
364 $eatby = '';
365 $sellby = '';
366 }
367
368 // Check table llx_product_lot from batchnumber for same product
369 // If found and eatby/sellby defined into table and provided and differs, return error
370 // If found and eatby/sellby defined into table and not provided, we take value from table
371 // If found and eatby/sellby not defined into table and provided, we update table
372 // If found and eatby/sellby not defined into table and not provided, we do nothing
373 // If not found, we add record
374 $sql = "SELECT pb.rowid, pb.batch, pb.eatby, pb.sellby FROM ".$this->db->prefix()."product_lot as pb";
375 $sql .= " WHERE pb.fk_product = ".((int) $fk_product)." AND pb.batch = '".$this->db->escape($batch)."'";
376
377 dol_syslog(get_class($this)."::_create scan serial for this product to check if eatby and sellby match", LOG_DEBUG);
378
379 $resql = $this->db->query($sql);
380 if ($resql) {
381 $num = $this->db->num_rows($resql);
382 $i = 0;
383 if ($num > 0) {
384 while ($i < $num && $obj = $this->db->fetch_object($resql)) {
385 if ($obj->eatby) {
386 if ($eatby) {
387 $tmparray = dol_getdate((int) $eatby, true);
388 $eatbywithouthour = dol_mktime(0, 0, 0, $tmparray['mon'], $tmparray['mday'], $tmparray['year']);
389 if ($this->db->jdate($obj->eatby) != $eatby && $this->db->jdate($obj->eatby) != $eatbywithouthour) { // We test date without hours and with hours for backward compatibility
390 // If found and eatby/sellby defined into table and provided and differs, return error
391 $langs->load("stocks");
392 $this->errors[] = $langs->transnoentitiesnoconv("ThisSerialAlreadyExistWithDifferentDate", $batch, dol_print_date($this->db->jdate($obj->eatby), 'dayhour'), dol_print_date($eatbywithouthour, 'dayhour'));
393 dol_syslog("ThisSerialAlreadyExistWithDifferentDate batch=".$batch.", eatby found into product_lot = ".$obj->eatby." = ".dol_print_date($this->db->jdate($obj->eatby), 'dayhourrfc')." so eatbywithouthour = ".$eatbywithouthour." = ".dol_print_date($eatbywithouthour)." - eatby provided = ".$eatby." = ".dol_print_date($eatby, 'dayhourrfc'), LOG_ERR);
394 $this->db->rollback();
395 return -3;
396 }
397 } else {
398 $eatby = $obj->eatby; // If found and eatby/sellby defined into table and not provided, we take value from table
399 }
400 } else {
401 if ($eatby) { // If found and eatby/sellby not defined into table and provided, we update table
402 $productlot = new Productlot($this->db);
403 $result = $productlot->fetch($obj->rowid);
404 $productlot->eatby = $eatby;
405 $result = $productlot->update($user);
406 if ($result <= 0) {
407 $this->setErrorsFromObject($productlot);
408 $this->db->rollback();
409 return -5;
410 }
411 }
412 }
413 if ($obj->sellby) {
414 if ($sellby) {
415 $tmparray = dol_getdate((int) $sellby, true);
416 $sellbywithouthour = dol_mktime(0, 0, 0, $tmparray['mon'], $tmparray['mday'], $tmparray['year']);
417 if ($this->db->jdate($obj->sellby) != $sellby && $this->db->jdate($obj->sellby) != $sellbywithouthour) { // We test date without hours and with hours for backward compatibility
418 // If found and eatby/sellby defined into table and provided and differs, return error
419 $this->errors[] = $langs->transnoentitiesnoconv("ThisSerialAlreadyExistWithDifferentDate", $batch, dol_print_date($this->db->jdate($obj->sellby)), dol_print_date($sellby));
420 dol_syslog($langs->transnoentities("ThisSerialAlreadyExistWithDifferentDate", $batch, dol_print_date($this->db->jdate($obj->sellby)), dol_print_date($sellby)), LOG_ERR);
421 $this->db->rollback();
422 return -3;
423 }
424 } else {
425 $sellby = $obj->sellby; // If found and eatby/sellby defined into table and not provided, we take value from table
426 }
427 } else {
428 if ($sellby) { // If found and eatby/sellby not defined into table and provided, we update table
429 $productlot = new Productlot($this->db);
430 $result = $productlot->fetch($obj->rowid);
431 $productlot->sellby = $sellby;
432 $result = $productlot->update($user);
433 if ($result <= 0) {
434 $this->setErrorsFromObject($productlot);
435 $this->db->rollback();
436 return -5;
437 }
438 }
439 }
440
441 $i++;
442 }
443 } else { // If not found, we add record
444 $productlot = new Productlot($this->db);
445 $productlot->origin_type = !empty($this->origin_type) ? $this->origin_type : '';
446 $productlot->origin_id = !empty($this->origin_id) ? $this->origin_id : 0;
447 $productlot->entity = $conf->entity;
448 $productlot->fk_product = $fk_product;
449 $productlot->batch = $batch;
450 // If we are here = first time we manage this batch, so we used dates provided by users to create lot
451 $productlot->eatby = $eatby;
452 $productlot->sellby = $sellby;
453 $result = $productlot->create($user);
454 if ($result <= 0) {
455 $this->setErrorsFromObject($productlot);
456 $this->db->rollback();
457 return -4;
458 }
459 }
460 } else {
461 dol_print_error($this->db);
462 $this->db->rollback();
463 return -1;
464 }
465 }
466
467 // Check if stock is enough when qty is < 0.
468 // THIS MUST BE DONE AT END OF MOVEMENTS
469 // Note that qty should be > 0 with type 0 or 3, < 0 with type 1 or 2.
470 if ($movestock && $qty < 0 && getDolGlobalInt('STOCK_DISALLOW_NEGATIVE_TRANSFER')) {
471 if (isModEnabled('productbatch') && $product->hasbatch() && !$skip_batch) {
472 $foundforbatch = 0;
473 $qtyisnotenough = 0;
474 if (isset($product->stock_warehouse[$entrepot_id])) {
475 foreach ($product->stock_warehouse[$entrepot_id]->detail_batch as $batchcursor => $prodbatch) {
476 // Lot '59' must be different than lot '59c' and also '0123' must be different than '123'
477 if ((string) $batch !== (string) $batchcursor) {
478 continue;
479 }
480
481 $foundforbatch = 1;
482 if ($prodbatch->qty < abs($qty)) {
483 $qtyisnotenough = $prodbatch->qty;
484 }
485 break;
486 }
487 }
488 if (!$foundforbatch || $qtyisnotenough) {
489 $langs->load("stocks");
490 include_once DOL_DOCUMENT_ROOT.'/product/stock/class/entrepot.class.php';
491 $tmpwarehouse = new Entrepot($this->db);
492 $tmpwarehouse->fetch($entrepot_id);
493
494 $this->error = $langs->trans('qtyToTranferLotIsNotEnough', $product->ref, (string) $batch, $qtyisnotenough, $tmpwarehouse->ref);
495 $this->errors[] = $langs->trans('qtyToTranferLotIsNotEnough', $product->ref, (string) $batch, $qtyisnotenough, $tmpwarehouse->ref);
496 $this->db->rollback();
497 return -8;
498 }
499 } else {
500 if ($product->stockable_product == Product::ENABLED_STOCK && (empty($product->stock_warehouse[$entrepot_id]) || empty($product->stock_warehouse[$entrepot_id]->real) || $product->stock_warehouse[$entrepot_id]->real < abs($qty))) {
501 $langs->load("stocks");
502 $this->error = $langs->trans('qtyToTranferIsNotEnough').' : '.$product->ref;
503 $this->errors[] = $langs->trans('qtyToTranferIsNotEnough').' : '.$product->ref;
504 $this->db->rollback();
505 return -8;
506 }
507 }
508 }
509
510 if ($movestock && $product->stockable_product == Product::ENABLED_STOCK) { // Change stock for current product, change for subproduct is done after
511 // Set $origin_type, origin_id and fk_project
512 $fk_project = $this->fk_project;
513 if (!empty($this->origin_type)) { // This is set by caller for tracking reason
514 $origin_type = $this->origin_type;
515 $origin_id = $this->origin_id;
516 if (empty($fk_project) && $origin_type == 'project') {
517 $fk_project = $origin_id;
518 $origin_type = '';
519 $origin_id = 0;
520 }
521 } else {
522 $fk_project = 0;
523 $origin_type = '';
524 $origin_id = 0;
525 }
526
527 // llx_stock_mouvement.label is VARCHAR(255)
528 $label = dol_trunc((string) $label, 255, 'right', 'UTF-8', 1);
529
530 $sql = "INSERT INTO ".$this->db->prefix()."stock_mouvement(";
531 $sql .= " datem, fk_product, batch, eatby, sellby,";
532 $sql .= " fk_entrepot, value, type_mouvement, fk_user_author, label, inventorycode, price, fk_origin, origintype, fk_projet";
533 $sql .= ")";
534 $sql .= " VALUES ('".$this->db->idate($this->datem)."', ".((int) $this->product_id).", ";
535 $sql .= " ".(isset($batch) ? "'".$this->db->escape($batch)."'" : "null").", ";
536 $sql .= " ".($eatby ? "'".$this->db->idate($eatby)."'" : "null").", ";
537 $sql .= " ".($sellby ? "'".$this->db->idate($sellby)."'" : "null").", ";
538 $sql .= " ".((int) $this->entrepot_id).", ".((float) $this->qty).", ".((int) $this->type).",";
539 $sql .= " ".((int) $user->id).",";
540 $sql .= " '".$this->db->escape($label)."',";
541 $sql .= " ".($inventorycode ? "'".$this->db->escape($inventorycode)."'" : "null").",";
542 $sql .= " ".((float) price2num($price)).",";
543 $sql .= " ".((int) $origin_id).",";
544 $sql .= " '".$this->db->escape($origin_type)."',";
545 $sql .= " ".((int) $fk_project);
546 $sql .= ")";
547
548 dol_syslog(get_class($this)."::_create insert record into stock_mouvement", LOG_DEBUG);
549 $resql = $this->db->query($sql);
550
551 if ($resql) {
552 $mvid = $this->db->last_insert_id($this->db->prefix()."stock_mouvement");
553 $this->id = $mvid;
554 } else {
555 $this->error = $this->db->lasterror();
556 $this->errors[] = $this->error;
557 $error = -1;
558 }
559
560 // Define current values for qty and pmp
561 $oldqty = $product->stock_reel;
562 $oldpmp = $product->pmp;
563 $oldqtywarehouse = 0;
564
565 // Test if there is already a record for couple (warehouse / product), so later we will make an update or create.
566 $alreadyarecord = 0;
567 $fk_product_stock = 0;
568 if (!$error) {
569 $sql = "SELECT rowid, reel FROM ".$this->db->prefix()."product_stock";
570 $sql .= " WHERE fk_entrepot = ".((int) $entrepot_id)." AND fk_product = ".((int) $fk_product); // This is a unique key
571
572 dol_syslog(get_class($this)."::_create check if a record already exists in product_stock", LOG_DEBUG);
573 $resql = $this->db->query($sql);
574 if ($resql) {
575 $obj = $this->db->fetch_object($resql);
576 if ($obj) {
577 $alreadyarecord = 1;
578 $oldqtywarehouse = $obj->reel;
579 $fk_product_stock = $obj->rowid;
580 }
581 $this->db->free($resql);
582 } else {
583 $this->errors[] = $this->db->lasterror();
584 $error = -2;
585 }
586 }
587
588 // Calculate new AWP (PMP)
589 $newpmp = 0;
590 if (!$error) {
591 if ($type == 0 || $type == 3) {
592 // After a stock increase
593 // Note: PMP is calculated on stock input only (type of movement = 0 or 3). If type == 0 or 3, qty should be > 0.
594 // Note: Price should always be >0 or 0. PMP should be always >0 (calculated on input)
595 if ($price > 0 || (getDolGlobalString('STOCK_UPDATE_AWP_EVEN_WHEN_ENTRY_PRICE_IS_NULL') && $price == 0 && in_array($this->origin_type, array('order_supplier', 'invoice_supplier')))) {
596 $oldqtytouse = ($oldqty >= 0 ? $oldqty : 0);
597 // We make a test on oldpmp>0 to avoid to use normal rule on old data with no pmp field defined
598 if ($oldpmp > 0 && ($oldqtytouse + $qty) != 0) {
599 $newpmp = price2num((($oldqtytouse * $oldpmp) + ($qty * $price)) / ($oldqtytouse + $qty), 'MU');
600 } else {
601 $newpmp = $price; // For this product, PMP was not yet set. We set it to input price.
602 }
603 //print "oldqtytouse=".$oldqtytouse." oldpmp=".$oldpmp." oldqtywarehousetouse=".$oldqtywarehousetouse." ";
604 //print "qty=".$qty." newpmp=".$newpmp;
605 //exit;
606 } else {
607 $newpmp = $oldpmp;
608 }
609 } else {
610 // ($type == 1 || $type == 2)
611 // -> After a stock decrease, we don't change value of the AWP/PMP of a product.
612 // else
613 // Type of movement unknown
614 $newpmp = $oldpmp;
615 }
616 }
617 // Update stock quantity
618 if (!$error) {
619 if ($alreadyarecord > 0) {
620 $sql = "UPDATE ".$this->db->prefix()."product_stock SET reel = " . ((float) $oldqtywarehouse + (float) $qty);
621 $sql .= " WHERE fk_entrepot = ".((int) $entrepot_id)." AND fk_product = ".((int) $fk_product);
622 } else {
623 $sql = "INSERT INTO ".$this->db->prefix()."product_stock";
624 $sql .= " (reel, fk_entrepot, fk_product) VALUES ";
625 $sql .= " (".((float) $qty).", ".((int) $entrepot_id).", ".((int) $fk_product).")";
626 }
627
628 dol_syslog(get_class($this)."::_create update stock value", LOG_DEBUG);
629 $resql = $this->db->query($sql);
630 if (!$resql) {
631 $this->errors[] = $this->db->lasterror();
632 $error = -3;
633 } elseif (empty($fk_product_stock)) {
634 $fk_product_stock = $this->db->last_insert_id($this->db->prefix()."product_stock");
635 }
636 }
637
638 // Update detail of stock for the lot.
639 if (!$error && isModEnabled('productbatch') && (($product->hasbatch() && !$skip_batch) || $force_update_batch)) {
640 if ($id_product_batch > 0) {
641 $result = $this->createBatch($id_product_batch, $qty);
642 if ($result == -2 && $fk_product_stock > 0) { // The entry for this product batch does not exists anymore, bu we already have a llx_product_stock, so we recreate the batch entry in product_batch
643 $param_batch = array('fk_product_stock' => $fk_product_stock, 'batchnumber' => (string) $batch);
644 $result = $this->createBatch($param_batch, $qty);
645 }
646 } else {
647 $param_batch = array('fk_product_stock' => $fk_product_stock, 'batchnumber' => (string) $batch);
648 $result = $this->createBatch($param_batch, $qty);
649 }
650 if ($result < 0) {
651 $error++;
652 }
653 }
654
655 // Update PMP and denormalized value of stock qty at product level
656 if (!$error) {
657 $newpmp = price2num($newpmp, 'MU');
658
659 // $sql = "UPDATE ".$this->db->prefix()."product SET pmp = ".$newpmp.", stock = ".$this->db->ifsql("stock IS NULL", 0, "stock") . " + ".$qty;
660 // $sql.= " WHERE rowid = ".((int) $fk_product);
661 // Update pmp + denormalized fields because we change content of produt_stock. Warning: Do not use "SET p.stock", does not works with pgsql
662 $sql = "UPDATE ".$this->db->prefix()."product as p SET pmp = ".((float) $newpmp).",";
663 $sql .= " stock=(SELECT SUM(ps.reel) FROM ".$this->db->prefix()."product_stock as ps WHERE ps.fk_product = p.rowid)";
664 $sql .= " WHERE rowid = ".((int) $fk_product);
665
666 dol_syslog(get_class($this)."::_create update AWP", LOG_DEBUG);
667 $resql = $this->db->query($sql);
668 if (!$resql) {
669 $this->errors[] = $this->db->lasterror();
670 $error = -4;
671 }
672 }
673
674 if (empty($donotcleanemptylines)) {
675 // If stock is now 0, we can remove entry into llx_product_stock, but only if there is no child lines into llx_product_batch (detail of batch, because we can imagine
676 // having a lot1/qty=X and lot2/qty=-X, so 0 but we must not loose repartition of different lot.
677 $sql = "DELETE FROM ".$this->db->prefix()."product_stock WHERE reel = 0 AND rowid NOT IN (SELECT fk_product_stock FROM ".$this->db->prefix()."product_batch as pb)";
678 $resql = $this->db->query($sql);
679 // We do not test error, it can fails if there is child in batch details
680 }
681 }
682
683 // Add movement for sub products (recursive call)
684 if (!$error && getDolGlobalString('PRODUIT_SOUSPRODUITS') && !getDolGlobalString('PRODUIT_SOUSPRODUITS_ALWAYS_DISABLE_CHILDREN_STOCK_MOVE') && empty($disablestockchangeforsubproduct)) {
685 $error = $this->_createSubProduct($user, $fk_product, $entrepot_id, $qty, $type, 0, $label, $inventorycode, $datem); // we use 0 as price, because AWP must not change for subproduct
686 }
687
688 if ($movestock && !$error) {
689 // Call trigger
690 if ($product->stockable_product != Product::DISABLED_STOCK ) {
691 $result = $this->call_trigger('STOCK_MOVEMENT', $user);
692 if ($result < 0) {
693 $error++;
694 }
695 }
696 // End call triggers
697 // Check unicity for serial numbered equipment once all movement were done.
698 if (!$error && isModEnabled('productbatch') && $product->hasbatch() && !$skip_batch) {
699 if ($product->status_batch == 2 && $qty > 0) { // We check only if we increased qty
700 if ($this->getBatchCount($fk_product, (string) $batch) > 1) {
701 $error++;
702 $this->errors[] = $langs->trans("TooManyQtyForSerialNumber", $product->ref, (string) $batch);
703 }
704 }
705 }
706 }
707
708 if (!$error) {
709 $this->db->commit();
710 return $mvid;
711 } else {
712 $this->db->rollback();
713 dol_syslog(get_class($this)."::_create error code=".$error, LOG_ERR);
714 return -6;
715 }
716 }
717
718
719
727 public function fetch($id)
728 {
729 dol_syslog(__METHOD__, LOG_DEBUG);
730
731 $sql = "SELECT";
732 $sql .= " t.rowid,";
733 $sql .= " t.tms,";
734 $sql .= " t.datem,";
735 $sql .= " t.fk_product,";
736 $sql .= " t.fk_entrepot,";
737 $sql .= " t.value,";
738 $sql .= " t.price,";
739 $sql .= " t.type_mouvement,";
740 $sql .= " t.fk_user_author,";
741 $sql .= " t.label,";
742 $sql .= " t.fk_origin as origin_id,";
743 $sql .= " t.origintype as origin_type,";
744 $sql .= " t.inventorycode as movementcode,";
745 $sql .= " t.batch,";
746 $sql .= " t.eatby,";
747 $sql .= " t.sellby,";
748 $sql .= " t.fk_projet as fk_project";
749 $sql .= " FROM ".$this->db->prefix().$this->table_element." as t";
750 $sql .= " WHERE t.rowid = ".((int) $id);
751
752 $resql = $this->db->query($sql);
753 if ($resql) {
754 $numrows = $this->db->num_rows($resql);
755 if ($numrows) {
756 $obj = $this->db->fetch_object($resql);
757
758 $this->id = $obj->rowid;
759
760 $this->product_id = $obj->fk_product;
761 $this->warehouse_id = $obj->fk_entrepot;
762 $this->qty = $obj->value;
763 $this->type = $obj->type_mouvement;
764
765 $this->tms = $this->db->jdate($obj->tms);
766 $this->datem = $this->db->jdate($obj->datem);
767 $this->price = $obj->price;
768 $this->fk_user_author = $obj->fk_user_author;
769 $this->label = $obj->label;
770 $this->fk_origin = $obj->origin_id; // For backward compatibility
771 $this->origintype = $obj->origin_type; // For backward compatibility
772 $this->origin_id = $obj->origin_id;
773 $this->origin_type = $obj->origin_type;
774 $this->inventorycode = $obj->movementcode; // For backward compatibility
775 $this->movementcode = $obj->movementcode;
776 $this->batch = $obj->batch;
777 $this->eatby = $this->db->jdate($obj->eatby);
778 $this->sellby = $this->db->jdate($obj->sellby);
779 $this->fk_project = $obj->fk_project;
780 }
781
782 // Retrieve all extrafield
783 $this->fetch_optionals();
784
785 // $this->fetch_lines();
786
787 $this->db->free($resql);
788
789 if ($numrows) {
790 return 1;
791 } else {
792 return 0;
793 }
794 } else {
795 $this->errors[] = 'Error '.$this->db->lasterror();
796 dol_syslog(__METHOD__.' '.implode(',', $this->errors), LOG_ERR);
797
798 return -1;
799 }
800 }
801
802
803
804
819 private function _createSubProduct($user, $idProduct, $entrepot_id, $qty, $type, $price = 0, $label = '', $inventorycode = '', $datem = '')
820 {
821 global $langs;
822
823 $error = 0;
824
825 $sql = "SELECT fk_product_pere, fk_product_fils, qty";
826 $sql .= " FROM ".$this->db->prefix()."product_association";
827 $sql .= " WHERE fk_product_pere = ".((int) $idProduct);
828 $sql .= " AND incdec = 1";
829
830 dol_syslog(__METHOD__.' for parent product '.$idProduct, LOG_DEBUG);
831 $resql = $this->db->query($sql);
832 if ($resql) {
833 // Create movement for each sub-product
834 while ($obj = $this->db->fetch_object($resql)) {
835 $tmpmove = dol_clone($this, 1);
836 $result = $tmpmove->_create($user, $obj->fk_product_fils, $entrepot_id, ($qty * $obj->qty), $type, 0, $label, $inventorycode, $datem); // This will also call _createSubProduct making this recursive
837 if ($result < 0) {
838 $this->error = $tmpmove->error;
839 $this->errors = array_merge($this->errors, $tmpmove->errors);
840 if ($result == -2) {
841 $this->errors[] = $langs->trans('ErrorNoteAlsoThatSubProductCantBeFollowedByLot');
842 }
843 $error = $result;
844 dol_syslog(__METHOD__ . ' Error : ' . $this->errorsToString(), LOG_ERR);
845 break;
846 }
847 unset($tmpmove);
848 }
849
850 $this->db->free($resql);
851 } else {
852 $error = -2;
853 }
854
855 return $error;
856 }
857
858
877 public function livraison($user, $fk_product, $entrepot_id, $qty, $price = 0, $label = '', $datem = '', $eatby = '', $sellby = '', $batch = '', $id_product_batch = 0, $inventorycode = '', $donotcleanemptylines = 0)
878 {
879 $skip_batch = !isModEnabled('productbatch');
880
881 return $this->_create($user, $fk_product, $entrepot_id, (0 - $qty), 2, $price, $label, $inventorycode, $datem, $eatby, $sellby, $batch, $skip_batch, $id_product_batch, 0, $donotcleanemptylines);
882 }
883
903 public function reception($user, $fk_product, $entrepot_id, $qty, $price = 0, $label = '', $eatby = '', $sellby = '', $batch = '', $datem = '', $id_product_batch = 0, $inventorycode = '', $donotcleanemptylines = 0, $disablestockchangeforsubproduct = 0)
904 {
905 $skip_batch = !isModEnabled('productbatch');
906
907 return $this->_create($user, $fk_product, $entrepot_id, $qty, 3, $price, $label, $inventorycode, $datem, $eatby, $sellby, $batch, $skip_batch, $id_product_batch, $disablestockchangeforsubproduct, $donotcleanemptylines);
908 }
909
917 public function calculateBalanceForProductBefore($productidselected, $datebefore)
918 {
919 $nb = 0;
920
921 $sql = "SELECT SUM(value) as nb from ".$this->db->prefix()."stock_mouvement";
922 $sql .= " WHERE fk_product = ".((int) $productidselected);
923 $sql .= " AND datem < '".$this->db->idate($datebefore)."'";
924
925 dol_syslog(get_class($this).__METHOD__, LOG_DEBUG);
926 $resql = $this->db->query($sql);
927 if ($resql) {
928 $obj = $this->db->fetch_object($resql);
929 if ($obj) {
930 $nb = (int) $obj->nb;
931 }
932 return (empty($nb) ? 0 : $nb);
933 } else {
934 dol_print_error($this->db);
935 return -1;
936 }
937 }
938
948 private function createBatch($dluo, $qty)
949 {
950 global $user, $langs;
951
952 $langs->load('productbatch');
953
954 $pdluo = new Productbatch($this->db);
955
956 $vbatchnumber = '';
957 $vfk_product_stock = 0;
958 $result = 0;
959
960 // Try to find an existing record with same batch number or id
961 if (is_numeric($dluo)) {
962 $result = $pdluo->fetch($dluo);
963 if (empty($pdluo->id)) {
964 // We didn't find the line. May be it was deleted before by a previous move in same transaction.
965 $this->error = $langs->trans('CantMoveNonExistantSerial');
966 $this->errors[] = $this->error;
967 $result = -2;
968 }
969 } elseif (is_array($dluo)) {
970 if (isset($dluo['fk_product_stock'])) {
971 $vfk_product_stock = $dluo['fk_product_stock'];
972 $vbatchnumber = $dluo['batchnumber'];
973
974 $result = $pdluo->find($vfk_product_stock, 0, 0, $vbatchnumber); // Search on batch number only (eatby and sellby are deprecated here)
975 } else {
976 dol_syslog(get_class($this)."::createBatch array param dluo must contain at least key fk_product_stock", LOG_ERR);
977 $result = -1;
978 }
979 } else {
980 dol_syslog(get_class($this)."::createBatch error invalid param dluo", LOG_ERR);
981 $result = -1;
982 }
983
984 if ($result >= 0) {
985 // No error
986 if ($pdluo->id > 0) { // product_batch record found
987 //print "Avant ".$pdluo->qty." Apres ".($pdluo->qty + $qty)."<br>";
988 $pdluo->qty += $qty;
989 if ($pdluo->qty == 0) {
990 $result = $pdluo->delete($user, 1);
991 } else {
992 $result = $pdluo->update($user, 1);
993 }
994 } else { // product_batch record not found
995 $pdluo->fk_product_stock = $vfk_product_stock;
996 $pdluo->qty = $qty;
997 $pdluo->eatby = empty($dluo['eatby']) ? '' : $dluo['eatby']; // No more used. Now eatby date is store in table of lot, no more into prouct_batch table.
998 $pdluo->sellby = empty($dluo['sellby']) ? '' : $dluo['sellby']; // No more used. Now sellby date is store in table of lot, no more into prouct_batch table.
999 $pdluo->batch = $vbatchnumber;
1000
1001 $result = $pdluo->create($user, 1);
1002 if ($result < 0) {
1003 $this->setErrorsFromObject($pdluo);
1004 }
1005 }
1006 }
1007
1008 return $result;
1009 }
1010
1011 // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
1019 public function get_origin($origin_id, $origin_type)
1020 {
1021 // phpcs:enable
1022 $origin = '';
1023
1024 switch ($origin_type) {
1025 case 'commande':
1026 require_once DOL_DOCUMENT_ROOT.'/commande/class/commande.class.php';
1027 $origin = new Commande($this->db);
1028 break;
1029 case 'shipping':
1030 require_once DOL_DOCUMENT_ROOT.'/expedition/class/expedition.class.php';
1031 $origin = new Expedition($this->db);
1032 break;
1033 case 'facture':
1034 require_once DOL_DOCUMENT_ROOT.'/compta/facture/class/facture.class.php';
1035 $origin = new Facture($this->db);
1036 break;
1037 case 'order_supplier':
1038 require_once DOL_DOCUMENT_ROOT.'/fourn/class/fournisseur.commande.class.php';
1039 $origin = new CommandeFournisseur($this->db);
1040 break;
1041 case 'invoice_supplier':
1042 require_once DOL_DOCUMENT_ROOT.'/fourn/class/fournisseur.facture.class.php';
1043 $origin = new FactureFournisseur($this->db);
1044 break;
1045 case 'project':
1046 require_once DOL_DOCUMENT_ROOT.'/projet/class/project.class.php';
1047 $origin = new Project($this->db);
1048 break;
1049 case 'mo':
1050 require_once DOL_DOCUMENT_ROOT.'/mrp/class/mo.class.php';
1051 $origin = new Mo($this->db);
1052 break;
1053 case 'user':
1054 require_once DOL_DOCUMENT_ROOT.'/user/class/user.class.php';
1055 $origin = new User($this->db);
1056 break;
1057 case 'reception':
1058 require_once DOL_DOCUMENT_ROOT.'/reception/class/reception.class.php';
1059 $origin = new Reception($this->db);
1060 break;
1061 case 'inventory':
1062 require_once DOL_DOCUMENT_ROOT.'/product/inventory/class/inventory.class.php';
1063 $origin = new Inventory($this->db);
1064 break;
1065 default:
1066 if ($origin_type) {
1067 // Separate origin_type with "@" : left part is class name, right part is module name
1068 $origin_type_array = explode('@', $origin_type);
1069 $classname = $origin_type_array[0];
1070 $modulename = empty($origin_type_array[1]) ? strtolower($classname) : $origin_type_array[1];
1071
1072 // Dolibarr names its class files in lowercase, so use a lowercase file name whatever
1073 // the case of the class name (class names themselves are case insensitive in PHP).
1074 $result = dol_include_once('/'.$modulename.'/class/'.strtolower($classname).'.class.php');
1075
1076 if ($result) {
1077 $classname = ucfirst($classname);
1078 $origin = new $classname($this->db);
1079 }
1080 }
1081 break;
1082 }
1083
1084 if (empty($origin) || !is_object($origin)) {
1085 return '';
1086 }
1087
1088 if ($origin->fetch($origin_id) > 0) {
1089 return $origin->getNomUrl(1);
1090 }
1091
1092 return '';
1093 }
1094
1105 public function setOrigin($origin_element, $origin_id, $line_id_object_src = 0, $line_id_object_origin = 0)
1106 {
1107 $this->origin_type = $origin_element;
1108 $this->origin_id = $origin_id;
1109 $this->line_id_object_src = $line_id_object_src;
1110 $this->line_id_object_origin = $line_id_object_origin;
1111 // For backward compatibility
1112 $this->origintype = $origin_element;
1113 $this->fk_origin = $origin_id;
1114 }
1115
1116
1124 public function initAsSpecimen()
1125 {
1126 // Initialize parameters
1127 $this->id = 0;
1128
1129 // There is no specific properties. All data into insert are provided as method parameter.
1130
1131 return 1;
1132 }
1133
1140 public function getTypeMovement($withlabel = 0)
1141 {
1142 global $langs;
1143
1144 $s = '';
1145 switch ($this->type) {
1146 case "0":
1147 $s = '<span class="fa fa-level-down-alt stockmovemententry stockmovementtransfer" title="'.$langs->trans('StockIncreaseAfterCorrectTransfer').'"></span>';
1148 if ($withlabel) {
1149 $s .= $langs->trans('StockIncreaseAfterCorrectTransfer');
1150 }
1151 break;
1152 case "1":
1153 $s = '<span class="fa fa-level-up-alt stockmovementexit stockmovementtransfer" title="'.$langs->trans('StockDecreaseAfterCorrectTransfer').'"></span>';
1154 if ($withlabel) {
1155 $s .= $langs->trans('StockDecreaseAfterCorrectTransfer');
1156 }
1157 break;
1158 case "2":
1159 $s = '<span class="fa fa-long-arrow-alt-up stockmovementexit stockmovement" title="'.$langs->trans('StockDecrease').'"></span>';
1160 if ($withlabel) {
1161 $s .= $langs->trans('StockDecrease');
1162 }
1163 break;
1164 case "3":
1165 $s = '<span class="fa fa-long-arrow-alt-down stockmovemententry stockmovement" title="'.$langs->trans('StockIncrease').'"></span>';
1166 if ($withlabel) {
1167 $s .= $langs->trans('StockIncrease');
1168 }
1169 break;
1170 }
1171
1172 return $s;
1173 }
1174
1186 public function getNomUrl($withpicto = 0, $option = '', $notooltip = 0, $maxlen = 24, $morecss = '')
1187 {
1188 global $langs;
1189
1190 $result = '';
1191
1192 $label = img_picto('', 'stock', 'class="pictofixedwidth"').'<u>'.$langs->trans("StockMovement").'</u>';
1193 $label .= '<div width="100%">';
1194 $label .= '<b>'.$langs->trans('Ref').':</b> '.$this->id;
1195 $label .= '<br><b>'.$langs->trans('Label').':</b> '.$this->label;
1196 $qtylabel = (($this->qty > 0) ? '<span class="stockmovemententry">+' : '<span class="stockmovementexit">') . $this->qty . '</span>';
1197 if ($this->inventorycode) {
1198 $label .= '<br><b>'.$langs->trans('InventoryCode').':</b> '.$this->inventorycode;
1199 }
1200 $label .= '<br><b>'.$langs->trans('Qty').':</b> ' . $qtylabel;
1201 if ($this->batch) {
1202 $label .= '<br><b>'.$langs->trans('Batch').':</b> '.$this->batch;
1203 }
1204 /* TODO Get also warehouse label in a property instead of id
1205 if ($this->warehouse_id > 0) {
1206 $label .= '<br><b>'.$langs->trans('Warehouse').':</b> '.$this->warehouse_id;
1207 }*/
1208 $label .= '</div>';
1209
1210 // Link to page of warehouse tab
1211 if ($option == 'movements') {
1212 $url = DOL_URL_ROOT.'/product/stock/movement_list.php?search_ref='.$this->id;
1213 } else {
1214 $url = DOL_URL_ROOT.'/product/stock/movement_list.php?id='.$this->warehouse_id.'&msid='.$this->id;
1215 }
1216
1217 $link = '<a href="'.$url.'"'.($notooltip ? '' : ' title="'.dol_escape_htmltag($label, 1).'" class="classfortooltip'.($morecss ? ' '.$morecss : '').'"');
1218 $link .= '>';
1219 $linkend = '</a>';
1220
1221 if ($withpicto) {
1222 $result .= ($link.img_object(($notooltip ? '' : $label), 'stock', ($notooltip ? '' : 'class="classfortooltip"')).$linkend);
1223 if ($withpicto != 2) {
1224 $result .= ' ';
1225 }
1226 }
1227 $result .= $link.$this->id.$linkend;
1228 return $result;
1229 }
1230
1237 public function getLibStatut($mode = 0)
1238 {
1239 return $this->LibStatut($mode);
1240 }
1241
1242 // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
1249 public function LibStatut($mode = 0)
1250 {
1251 // phpcs:enable
1252 global $langs;
1253
1254 if ($mode == 0 || $mode == 1) {
1255 return $langs->trans('StatusNotApplicable');
1256 } elseif ($mode == 2) {
1257 return img_picto($langs->trans('StatusNotApplicable'), 'statut9').' '.$langs->trans('StatusNotApplicable');
1258 } elseif ($mode == 3) {
1259 return img_picto($langs->trans('StatusNotApplicable'), 'statut9');
1260 } elseif ($mode == 4) {
1261 return img_picto($langs->trans('StatusNotApplicable'), 'statut9').' '.$langs->trans('StatusNotApplicable');
1262 } elseif ($mode == 5) {
1263 return $langs->trans('StatusNotApplicable').' '.img_picto($langs->trans('StatusNotApplicable'), 'statut9');
1264 }
1265
1266 return 'Bad value for mode';
1267 }
1268
1279 public function generateDocument($modele, $outputlangs, $hidedetails = 0, $hidedesc = 0, $hideref = 0)
1280 {
1281 global $langs;
1282
1283 $langs->load("stocks");
1284 $outputlangs->load("products");
1285
1286 if (!dol_strlen($modele)) {
1287 $modele = 'stdmovement';
1288
1289 if ($this->model_pdf) {
1290 $modele = $this->model_pdf;
1291 } elseif (getDolGlobalString('MOUVEMENT_ADDON_PDF')) {
1292 $modele = getDolGlobalString('MOUVEMENT_ADDON_PDF');
1293 }
1294 }
1295
1296 $modelpath = "core/modules/stock/doc/";
1297
1298 return $this->commonGenerateDocument($modelpath, $modele, $outputlangs, $hidedetails, $hidedesc, $hideref);
1299 }
1300
1308 public function delete(User $user, $notrigger = 0)
1309 {
1310 return $this->deleteCommon($user, $notrigger);
1311 //return $this->deleteCommon($user, $notrigger, 1);
1312 }
1313
1321 private function getBatchCount($fk_product, $batch)
1322 {
1323 $cpt = 0;
1324
1325 $sql = "SELECT sum(pb.qty) as cpt";
1326 $sql .= " FROM ".$this->db->prefix()."product_batch as pb";
1327 $sql .= " INNER JOIN ".$this->db->prefix()."product_stock as ps ON ps.rowid = pb.fk_product_stock";
1328 $sql .= " WHERE ps.fk_product = " . ((int) $fk_product);
1329 $sql .= " AND pb.batch = '" . $this->db->escape($batch) . "'";
1330
1331 $result = $this->db->query($sql);
1332 if ($result) {
1333 if ($this->db->num_rows($result)) {
1334 $obj = $this->db->fetch_object($result);
1335 $cpt = $obj->cpt;
1336 }
1337
1338 $this->db->free($result);
1339 } else {
1340 dol_print_error($this->db);
1341 return -1;
1342 }
1343
1344 return $cpt;
1345 }
1346
1352 public function reverseMovement()
1353 {
1354 global $user;
1355
1356 $formattedDate = "REVERT-" .($this->inventorycode ? $this->inventorycode : dol_print_date($this->datem, '%Y%m%d%His'));
1357 if ($this->inventorycode == $formattedDate) {
1358 return -1;
1359 }
1360
1361 $newlabel = 'Revert '.$this->label;
1362 // type is 0=input (stock increase by a stock transfer), 1=output (stock decrease by a stock transfer), 2=output (stock decrease), 3=input (stock increase)
1363 // Note that qty should be > 0 with 0 or 3, < 0 with 1 or 2.
1364 if ($this->type == 0) {
1365 $newtype = 1;
1366 } elseif ($this->type == 1) {
1367 $newtype = 0;
1368 } elseif ($this->type == 2) {
1369 $newtype = 3;
1370 } elseif ($this->type == 3) {
1371 $newtype = 2;
1372 } else {
1373 return -1;
1374 }
1375 $newqty = - $this->qty;
1376
1377 $this->db->begin();
1378
1379 $result = $this->_create($user, $this->product_id, $this->warehouse_id, $newqty, $newtype, 0, $newlabel, $formattedDate, '', 0, 0, $this->batch);
1380
1381 if ($result > 0) {
1382 $this->db->commit();
1383 return 1;
1384 } else {
1385 $this->db->rollback();
1386 return -1;
1387 }
1388 }
1389
1398 public function getDateLastMovementProductBatch($fk_entrepot, $fk_product, $batch)
1399 {
1400 $date = '';
1401
1402 $sql = "SELECT MAX(datem) as datem";
1403 $sql .= " FROM ".MAIN_DB_PREFIX."stock_mouvement";
1404 $sql .= " WHERE fk_product = " . ((int) $fk_product);
1405 $sql .= " AND fk_entrepot = " .((int) $fk_entrepot);
1406 $sql .= " AND batch = '" . $this->db->escape($batch) . "'";
1407
1408 $result = $this->db->query($sql);
1409 if ($result) {
1410 if ($this->db->num_rows($result)) {
1411 $dateObj = $this->db->fetch_object($result);
1412 $date = $dateObj->datem;
1413 }
1414 $this->db->free($result);
1415 } else {
1416 dol_print_error($this->db);
1417 return $date;
1418 }
1419
1420 return $date;
1421 }
1422}
Class to manage predefined suppliers products.
Class to manage customers orders.
Parent class of all other business classes (invoices, contracts, proposals, orders,...
fetch_optionals($rowid=null, $optionsArray=null)
Function to get extra fields of an object into $this->array_options This method is in most cases call...
commonGenerateDocument($modelspath, $modele, $outputlangs, $hidedetails, $hidedesc, $hideref, $moreparams=null)
Common function for all objects extending CommonObject for generating documents.
setErrorsFromObject($object)
setErrorsFromObject
errorsToString()
Method to output saved errors.
deleteCommon(User $user, $notrigger=0, $forcechilddeletion=0)
Delete object in database.
Class to manage warehouses.
Class to manage suppliers invoices.
Class to manage invoices.
Class for Inventory.
Class for Mo.
Definition mo.class.php:35
Class to manage stock movements.
__construct($db)
Constructor.
generateDocument($modele, $outputlangs, $hidedetails=0, $hidedesc=0, $hideref=0)
Create object on disk.
getNomUrl($withpicto=0, $option='', $notooltip=0, $maxlen=24, $morecss='')
Return a link (with optionally the picto) Use this->id,this->lastname, this->firstname.
setOrigin($origin_element, $origin_id, $line_id_object_src=0, $line_id_object_origin=0)
Set attribute origin_type and fk_origin to object.
_create($user, $fk_product, $entrepot_id, $qty, $type, $price=0, $label='', $inventorycode='', $datem='', $eatby=0, $sellby=0, $batch='', $skip_batch=false, $id_product_batch=0, $disablestockchangeforsubproduct=0, $donotcleanemptylines=0, $force_update_batch=false)
Add a movement of stock (in one direction only).
LibStatut($mode=0)
Return the label of the status.
createBatch($dluo, $qty)
Create or update batch record (update table llx_product_batch).
reception($user, $fk_product, $entrepot_id, $qty, $price=0, $label='', $eatby='', $sellby='', $batch='', $datem='', $id_product_batch=0, $inventorycode='', $donotcleanemptylines=0, $disablestockchangeforsubproduct=0)
Increase stock for product and subproducts.
getBatchCount($fk_product, $batch)
Retrieve number of equipment for a product lot/serial.
get_origin($origin_id, $origin_type)
Return Url link of origin object.
livraison($user, $fk_product, $entrepot_id, $qty, $price=0, $label='', $datem='', $eatby='', $sellby='', $batch='', $id_product_batch=0, $inventorycode='', $donotcleanemptylines=0)
Decrease stock for product and subproducts.
fetch($id)
Load object in memory from the database.
_createSubProduct($user, $idProduct, $entrepot_id, $qty, $type, $price=0, $label='', $inventorycode='', $datem='')
Create movement in database for all subproducts.
initAsSpecimen()
Initialise an instance with random values.
getDateLastMovementProductBatch($fk_entrepot, $fk_product, $batch)
Retrieve date of last stock movement for.
getTypeMovement($withlabel=0)
Return html string with picto for type of movement.
reverseMovement()
Reverse movement for object by updating infos.
calculateBalanceForProductBefore($productidselected, $datebefore)
Count number of product in stock before a specific date.
getLibStatut($mode=0)
Return label statut.
Class to manage products or services.
const DISABLED_STOCK
Stockable product.
Manage record for batch number management.
Class with list of lots and properties.
Class to manage projects.
Class to manage receptions.
Class to manage Dolibarr users.
dol_now($mode='gmt')
Return date for now.
dol_mktime($hour, $minute, $second, $month, $day, $year, $gm='auto', $check=1)
Return a timestamp date built from detailed information (by default a local PHP server timestamp) Rep...
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)
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.
price($amount, $form=0, $outlangs='', $trunc=1, $rounding=-1, $forcerounding=-1, $currency_code='')
Function to format a value into an amount for visual output Function used into PDF and HTML pages.
getDolGlobalInt($key, $default=0)
Return a Dolibarr global constant int value.
if(!function_exists( 'dol_getprefix')) dol_include_once($relpath, $classname='')
Make an include_once using default root and alternate root if it fails.
dol_clone($srcobject, $native=2)
Create a clone of instance of object (new instance with same value for each properties) With native =...
dol_print_date($time, $format='', $tzoutput='auto', $outputlangs=null, $encodetooutput=false, $decorate=0)
Output date in a string format according to outputlangs (or langs if not defined).
dol_print_error($db=null, $error='', $errors=null)
Displays error message system with all the information to facilitate the diagnosis and the escalation...
dol_trunc($string, $size=40, $trunc='right', $stringencoding='UTF-8', $nodot=0, $display=0)
Truncate a string to a particular length adding '…' if string larger than length.
getDolGlobalString($key, $default='')
Return a Dolibarr global constant string value.
isModEnabled($module)
Is Dolibarr module enabled.
dol_syslog($message, $level=LOG_INFO, $ident=0, $suffixinfilename='', $restricttologhandler='', $logcontext=null)
Write log message into outputs.
dol_getdate($timestamp, $fast=false, $forcetimezone='')
Return an array with locale date info.
if(preg_match('/(crypted|dolcrypt):/i', $dolibarr_main_db_pass)||!empty($dolibarr_main_db_encrypted_pass)) $conf db type
'integer', 'integer:ObjectClass:PathToClass[:AddCreateButtonOrNot[:Filter[:Sortfield]]]',...
Definition repair.php:132