Dolibarr\Code\Product\Classes\Inventory::validate()

Complexity

Conditions	21
Paths	4613

Size

Total Lines	119
Code Lines	83

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public function validate(User $user, $notrigger = 0, $include_sub_warehouse = 0)
    {
        $this->db->begin();

        $result = 0;

        if ($this->status == self::STATUS_DRAFT) {
            // Delete inventory
            $sql = 'DELETE FROM ' . $this->db->prefix() . 'inventorydet WHERE fk_inventory = ' . ((int) $this->id);
            $resql = $this->db->query($sql);
            if (!$resql) {
                $this->error = $this->db->lasterror();
                $this->db->rollback();
                return -1;
            }

            // Scan existing stock to prefill the inventory
            $sql = "SELECT ps.rowid, ps.fk_entrepot as fk_warehouse, ps.fk_product, ps.reel,";
            if (isModEnabled('productbatch')) {
                $sql .= " pb.batch as batch, pb.qty as qty,";
            } else {
                $sql .= " '' as batch, 0 as qty,";
            }
            $sql .= " p.ref, p.tobatch";
            $sql .= " FROM " . $this->db->prefix() . "product_stock as ps";
            if (isModEnabled('productbatch')) {
                $sql .= " LEFT JOIN " . $this->db->prefix() . "product_batch as pb ON pb.fk_product_stock = ps.rowid";
            }
            $sql .= ", " . $this->db->prefix() . "product as p, " . $this->db->prefix() . "entrepot as e";
            $sql .= " WHERE p.entity IN (" . getEntity('product') . ")";
            $sql .= " AND ps.fk_product = p.rowid AND ps.fk_entrepot = e.rowid";
            if (!getDolGlobalString('STOCK_SUPPORTS_SERVICES')) {
                $sql .= " AND p.fk_product_type = 0";
            }
            if ($this->fk_product > 0) {
                $sql .= " AND ps.fk_product = " . ((int) $this->fk_product);
            }
            if ($this->fk_warehouse > 0) {
                $sql .= " AND (ps.fk_entrepot = " . ((int) $this->fk_warehouse);
                if (!empty($include_sub_warehouse) && getDolGlobalInt('INVENTORY_INCLUDE_SUB_WAREHOUSE')) {
                    $TChildWarehouses = array();
                    $this->getChildWarehouse($this->fk_warehouse, $TChildWarehouses);
                    $sql .= " OR ps.fk_entrepot IN (" . $this->db->sanitize(implode(',', $TChildWarehouses)) . ")";
                }
                $sql .= ')';
            }
            if (!empty($this->categories_product)) {
                $sql .= " AND EXISTS (";
                $sql .= " SELECT cp.fk_product";
                $sql .= " FROM " . $this->db->prefix() . "categorie_product AS cp";
                $sql .= " WHERE cp.fk_product = ps.fk_product";
                $sql .= " AND cp.fk_categorie IN (" . $this->db->sanitize($this->categories_product) . ")";
                $sql .= ")";
            }
            if (getDolGlobalInt('PRODUIT_SOUSPRODUITS')) {
                $sql .= " AND NOT EXISTS (";
                $sql .= " SELECT pa.rowid";
                $sql .= " FROM " . $this->db->prefix() . "product_association as pa";
                $sql .= " WHERE pa.fk_product_pere = ps.fk_product";
                $sql .= ")";
            }
            $sql .= " ORDER BY p.rowid";

            $inventoryline = new InventoryLine($this->db);

            $resql = $this->db->query($sql);
            if ($resql) {
                $num = $this->db->num_rows($resql);

                $i = 0;
                while ($i < $num) {
                    $obj = $this->db->fetch_object($resql);

                    $inventoryline->fk_inventory = $this->id;
                    $inventoryline->fk_warehouse = $obj->fk_warehouse;
                    $inventoryline->fk_product = $obj->fk_product;
                    $inventoryline->batch = $obj->batch;
                    $inventoryline->datec = dol_now();

                    if (isModEnabled('productbatch')) {
                        if ($obj->batch && empty($obj->tobatch)) {
                            // Bad consistency of data. The product is not a product with lot/serial but we found a stock for some lot/serial.
                            $result = -2;
                            $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";
                            break;
                        }

                        $inventoryline->qty_stock = ($obj->batch ? $obj->qty : $obj->reel); // If there is batch detail, we take qty for batch, else global qty
                    } else {
                        $inventoryline->qty_stock = $obj->reel;
                    }
                    //var_dump($obj->batch.' '.$obj->qty.' '.$obj->reel.' '.$this->error);exit;

                    $resultline = $inventoryline->create($user);
                    if ($resultline <= 0) {
                        $this->error = $inventoryline->error;
                        $this->errors = $inventoryline->errors;
                        $result = -1;
                        break;
                    }

                    $i++;
                }
            } else {
                $result = -1;
                $this->error = $this->db->lasterror();
            }
        }

        if ($result >= 0) {
            $result = $this->setStatut($this::STATUS_VALIDATED, null, '', 'INVENTORY_VALIDATED');
        }

        if ($result > 0) {
            $this->db->commit();
        } else {
            $this->db->rollback();
        }
        return $result;
    }