Dolibarr\Code\Product\Classes\Product::update()

Complexity

Conditions	134
Paths	> 20000

Size

Total Lines	408
Code Lines	280

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public function update($id, $user, $notrigger = 0, $action = 'update', $updatetype = false)
    {
        global $langs, $conf, $hookmanager;

        $error = 0;

        // Check parameters
        if (!$this->label) {
            $this->label = 'MISSING LABEL';
        }

        // Clean parameters
        if (getDolGlobalInt('MAIN_SECURITY_ALLOW_UNSECURED_REF_LABELS')) {
            $this->ref = trim($this->ref);
        } else {
            $this->ref = dol_string_nospecial(trim($this->ref));
        }
        $this->label = trim($this->label);
        $this->description = trim($this->description);
        $this->note_private = (isset($this->note_private) ? trim($this->note_private) : null);
        $this->note_public = (isset($this->note_public) ? trim($this->note_public) : null);
        $this->net_measure = price2num($this->net_measure);
        $this->net_measure_units = (empty($this->net_measure_units) ? '' : trim($this->net_measure_units));
        $this->weight = price2num($this->weight);
        $this->weight_units = (empty($this->weight_units) ? '' : trim($this->weight_units));
        $this->length = price2num($this->length);
        $this->length_units = (empty($this->length_units) ? '' : trim($this->length_units));
        $this->width = price2num($this->width);
        $this->width_units = (empty($this->width_units) ? '' : trim($this->width_units));
        $this->height = price2num($this->height);
        $this->height_units = (empty($this->height_units) ? '' : trim($this->height_units));
        $this->surface = price2num($this->surface);
        $this->surface_units = (empty($this->surface_units) ? '' : trim($this->surface_units));
        $this->volume = price2num($this->volume);
        $this->volume_units = (empty($this->volume_units) ? '' : trim($this->volume_units));

        // set unit not defined
        if (is_numeric($this->length_units)) {
            $this->width_units = $this->length_units; // Not used yet
        }
        if (is_numeric($this->length_units)) {
            $this->height_units = $this->length_units; // Not used yet
        }

        // Automated compute surface and volume if not filled
        if (empty($this->surface) && !empty($this->length) && !empty($this->width) && $this->length_units == $this->width_units) {
            $this->surface = (float) $this->length * (float) $this->width;
            $this->surface_units = measuring_units_squared($this->length_units);
        }
        if (empty($this->volume) && !empty($this->surface) && !empty($this->height) && $this->length_units == $this->height_units) {
            $this->volume = $this->surface * (float) $this->height;
            $this->volume_units = measuring_units_cubed($this->height_units);
        }

        if (empty($this->tva_tx)) {
            $this->tva_tx = 0;
        }
        if (empty($this->tva_npr)) {
            $this->tva_npr = 0;
        }
        if (empty($this->localtax1_tx)) {
            $this->localtax1_tx = 0;
        }
        if (empty($this->localtax2_tx)) {
            $this->localtax2_tx = 0;
        }
        if (empty($this->localtax1_type)) {
            $this->localtax1_type = '0';
        }
        if (empty($this->localtax2_type)) {
            $this->localtax2_type = '0';
        }
        if (empty($this->status)) {
            $this->status = 0;
        }
        if (empty($this->status_buy)) {
            $this->status_buy = 0;
        }

        if (empty($this->country_id)) {
            $this->country_id = 0;
        }

        if (empty($this->state_id)) {
            $this->state_id = 0;
        }

        // Barcode value
        $this->barcode = (empty($this->barcode) ? '' : trim($this->barcode));

        $this->accountancy_code_buy = trim($this->accountancy_code_buy);
        $this->accountancy_code_buy_intra = (!empty($this->accountancy_code_buy_intra) ? trim($this->accountancy_code_buy_intra) : '');
        $this->accountancy_code_buy_export = trim($this->accountancy_code_buy_export);
        $this->accountancy_code_sell = trim($this->accountancy_code_sell);
        $this->accountancy_code_sell_intra = trim($this->accountancy_code_sell_intra);
        $this->accountancy_code_sell_export = trim($this->accountancy_code_sell_export);


        $this->db->begin();

        $result = 0;
        // Check name is required and codes are ok or unique. If error, this->errors[] is filled
        if ($action != 'add') {
            $result = $this->verify(); // We don't check when update called during a create because verify was already done
        } else {
            // we can continue
            $result = 0;
        }

        if ($result >= 0) {
            // $this->oldcopy should have been set by the caller of update (here properties were already modified)
            if (is_null($this->oldcopy) || (is_object($this->oldcopy) && $this->oldcopy->isEmpty())) {
                $this->oldcopy = dol_clone($this, 1);
            }
            // Test if batch management is activated on existing product
            // If yes, we create missing entries into product_batch
            if ($this->hasbatch() && !$this->oldcopy->hasbatch()) {
                //$valueforundefinedlot = 'Undefined';  // In previous version, 39 and lower
                $valueforundefinedlot = '000000';
                if (getDolGlobalString('STOCK_DEFAULT_BATCH')) {
                    $valueforundefinedlot = getDolGlobalString('STOCK_DEFAULT_BATCH');
                }

                dol_syslog("Flag batch of product id=" . $this->id . " is set to ON, so we will create missing records into product_batch");

                $this->load_stock();
                foreach ($this->stock_warehouse as $idW => $ObjW) {   // For each warehouse where we have stocks defined for this product (for each lines in product_stock)
                    $qty_batch = 0;
                    foreach ($ObjW->detail_batch as $detail) {    // Each lines of detail in product_batch of the current $ObjW = product_stock
                        if ($detail->batch == $valueforundefinedlot || $detail->batch == 'Undefined') {
                            // We discard this line, we will create it later
                            $sqlclean = "DELETE FROM " . $this->db->prefix() . "product_batch WHERE batch in('Undefined', '" . $this->db->escape($valueforundefinedlot) . "') AND fk_product_stock = " . ((int) $ObjW->id);
                            $result = $this->db->query($sqlclean);
                            if (!$result) {
                                dol_print_error($this->db);
                                exit;

Using exit here is not recommended.

                            }
                            continue;
                        }

                        $qty_batch += $detail->qty;
                    }
                    // Quantities in batch details are not same as stock quantity,
                    // so we add a default batch record to complete and get same qty in parent and child table
                    if ($ObjW->real != $qty_batch) {
                        $ObjBatch = new Productbatch($this->db);
                        $ObjBatch->batch = $valueforundefinedlot;
                        $ObjBatch->qty = ($ObjW->real - $qty_batch);
                        $ObjBatch->fk_product_stock = $ObjW->id;

                        if ($ObjBatch->create($user, 1) < 0) {
                            $error++;
                            $this->errors = $ObjBatch->errors;
                        } else {
                            // we also add lot record if not exist
                            $ObjLot = new Productlot($this->db);
                            // @phan-suppress-next-line PhanPluginSuspiciousParamPosition
                            if ($ObjLot->fetch(0, $this->id, $valueforundefinedlot) == 0) {
                                $ObjLot->fk_product = $this->id;
                                $ObjLot->entity = $this->entity;
                                $ObjLot->fk_user_creat = $user->id;
                                $ObjLot->batch = $valueforundefinedlot;
                                if ($ObjLot->create($user, true) < 0) {
                                    $error++;
                                    $this->errors = $ObjLot->errors;
                                }
                            }
                        }
                    }
                }
            }

            // For automatic creation
            if ($this->barcode == -1) {
                $this->barcode = $this->get_barcode($this, $this->barcode_type_code);
            }

            $sql = "UPDATE " . $this->db->prefix() . "product";
            $sql .= " SET label = '" . $this->db->escape($this->label) . "'";

            if ($updatetype && ($this->isProduct() || $this->isService())) {
                $sql .= ", fk_product_type = " . ((int) $this->type);
            }

            $sql .= ", ref = '" . $this->db->escape($this->ref) . "'";
            $sql .= ", ref_ext = " . (!empty($this->ref_ext) ? "'" . $this->db->escape($this->ref_ext) . "'" : "null");
            $sql .= ", default_vat_code = " . ($this->default_vat_code ? "'" . $this->db->escape($this->default_vat_code) . "'" : "null");
            $sql .= ", tva_tx = " . ((float) $this->tva_tx);
            $sql .= ", recuperableonly = " . ((int) $this->tva_npr);
            $sql .= ", localtax1_tx = " . ((float) $this->localtax1_tx);
            $sql .= ", localtax2_tx = " . ((float) $this->localtax2_tx);
            $sql .= ", localtax1_type = " . ($this->localtax1_type != '' ? "'" . $this->db->escape($this->localtax1_type) . "'" : "'0'");
            $sql .= ", localtax2_type = " . ($this->localtax2_type != '' ? "'" . $this->db->escape($this->localtax2_type) . "'" : "'0'");

            $sql .= ", barcode = " . (empty($this->barcode) ? "null" : "'" . $this->db->escape($this->barcode) . "'");
            $sql .= ", fk_barcode_type = " . (empty($this->barcode_type) ? "null" : $this->db->escape($this->barcode_type));

            $sql .= ", tosell = " . (int) $this->status;
            $sql .= ", tobuy = " . (int) $this->status_buy;
            $sql .= ", tobatch = " . ((empty($this->status_batch) || $this->status_batch < 0) ? '0' : (int) $this->status_batch);
            $sql .= ", sell_or_eat_by_mandatory = " . ((empty($this->sell_or_eat_by_mandatory) || $this->sell_or_eat_by_mandatory < 0) ? 0 : (int) $this->sell_or_eat_by_mandatory);
            $sql .= ", batch_mask = '" . $this->db->escape($this->batch_mask) . "'";

            $sql .= ", finished = " . ((!isset($this->finished) || $this->finished < 0 || $this->finished == '') ? "null" : (int) $this->finished);
            $sql .= ", fk_default_bom = " . ((!isset($this->fk_default_bom) || $this->fk_default_bom < 0 || $this->fk_default_bom == '') ? "null" : (int) $this->fk_default_bom);
            $sql .= ", net_measure = " . ($this->net_measure != '' ? "'" . $this->db->escape($this->net_measure) . "'" : 'null');
            $sql .= ", net_measure_units = " . ($this->net_measure_units != '' ? "'" . $this->db->escape($this->net_measure_units) . "'" : 'null');
            $sql .= ", weight = " . ($this->weight != '' ? "'" . $this->db->escape($this->weight) . "'" : 'null');
            $sql .= ", weight_units = " . ($this->weight_units != '' ? "'" . $this->db->escape($this->weight_units) . "'" : 'null');
            $sql .= ", length = " . ($this->length != '' ? "'" . $this->db->escape($this->length) . "'" : 'null');
            $sql .= ", length_units = " . ($this->length_units != '' ? "'" . $this->db->escape($this->length_units) . "'" : 'null');
            $sql .= ", width= " . ($this->width != '' ? "'" . $this->db->escape($this->width) . "'" : 'null');
            $sql .= ", width_units = " . ($this->width_units != '' ? "'" . $this->db->escape($this->width_units) . "'" : 'null');
            $sql .= ", height = " . ($this->height != '' ? "'" . $this->db->escape($this->height) . "'" : 'null');
            $sql .= ", height_units = " . ($this->height_units != '' ? "'" . $this->db->escape($this->height_units) . "'" : 'null');
            $sql .= ", surface = " . ($this->surface != '' ? "'" . $this->db->escape($this->surface) . "'" : 'null');
            $sql .= ", surface_units = " . ($this->surface_units != '' ? "'" . $this->db->escape($this->surface_units) . "'" : 'null');
            $sql .= ", volume = " . ($this->volume != '' ? "'" . $this->db->escape($this->volume) . "'" : 'null');
            $sql .= ", volume_units = " . ($this->volume_units != '' ? "'" . $this->db->escape($this->volume_units) . "'" : 'null');
            $sql .= ", fk_default_warehouse = " . ($this->fk_default_warehouse > 0 ? ((int) $this->fk_default_warehouse) : 'null');
            $sql .= ", fk_default_workstation = " . ($this->fk_default_workstation > 0 ? ((int) $this->fk_default_workstation) : 'null');
            $sql .= ", seuil_stock_alerte = " . ((isset($this->seuil_stock_alerte) && is_numeric($this->seuil_stock_alerte)) ? (float) $this->seuil_stock_alerte : 'null');
            $sql .= ", description = '" . $this->db->escape($this->description) . "'";
            $sql .= ", url = " . ($this->url ? "'" . $this->db->escape($this->url) . "'" : 'null');
            $sql .= ", customcode = '" . $this->db->escape($this->customcode) . "'";
            $sql .= ", fk_country = " . ($this->country_id > 0 ? (int) $this->country_id : 'null');
            $sql .= ", fk_state = " . ($this->state_id > 0 ? (int) $this->state_id : 'null');
            $sql .= ", lifetime = " . ($this->lifetime > 0 ? (int) $this->lifetime : 'null');
            $sql .= ", qc_frequency = " . ($this->qc_frequency > 0 ? (int) $this->qc_frequency : 'null');
            $sql .= ", note = " . (isset($this->note_private) ? "'" . $this->db->escape($this->note_private) . "'" : 'null');
            $sql .= ", note_public = " . (isset($this->note_public) ? "'" . $this->db->escape($this->note_public) . "'" : 'null');
            $sql .= ", duration = '" . $this->db->escape($this->duration_value . $this->duration_unit) . "'";
            if (!getDolGlobalString('MAIN_PRODUCT_PERENTITY_SHARED')) {
                $sql .= ", accountancy_code_buy = '" . $this->db->escape($this->accountancy_code_buy) . "'";
                $sql .= ", accountancy_code_buy_intra = '" . $this->db->escape($this->accountancy_code_buy_intra) . "'";
                $sql .= ", accountancy_code_buy_export = '" . $this->db->escape($this->accountancy_code_buy_export) . "'";
                $sql .= ", accountancy_code_sell= '" . $this->db->escape($this->accountancy_code_sell) . "'";
                $sql .= ", accountancy_code_sell_intra= '" . $this->db->escape($this->accountancy_code_sell_intra) . "'";
                $sql .= ", accountancy_code_sell_export= '" . $this->db->escape($this->accountancy_code_sell_export) . "'";
            }
            $sql .= ", desiredstock = " . ((isset($this->desiredstock) && is_numeric($this->desiredstock)) ? (float) $this->desiredstock : "null");
            $sql .= ", cost_price = " . ($this->cost_price != '' ? $this->db->escape($this->cost_price) : 'null');
            $sql .= ", fk_unit= " . (!$this->fk_unit ? 'NULL' : (int) $this->fk_unit);
            $sql .= ", price_autogen = " . (!$this->price_autogen ? 0 : 1);
            $sql .= ", fk_price_expression = " . ($this->fk_price_expression != 0 ? (int) $this->fk_price_expression : 'NULL');
            $sql .= ", fk_user_modif = " . ($user->id > 0 ? $user->id : 'NULL');
            $sql .= ", mandatory_period = " . ($this->mandatory_period);
            // stock field is not here because it is a denormalized value from product_stock.
            $sql .= " WHERE rowid = " . ((int) $id);

            dol_syslog(get_class($this) . "::update", LOG_DEBUG);

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

                // Multilangs
                if (getDolGlobalInt('MAIN_MULTILANGS')) {
                    if ($this->setMultiLangs($user) < 0) {
                        $this->error = $langs->trans("Error") . " : " . $this->db->error() . " - " . $sql;
                        $this->db->rollback();
                        return -2;
                    }
                }

                $action = 'update';

                // update accountancy for this entity
                if (!$error && getDolGlobalString('MAIN_PRODUCT_PERENTITY_SHARED')) {
                    $this->db->query("DELETE FROM " . $this->db->prefix() . "product_perentity WHERE fk_product = " . ((int) $this->id) . " AND entity = " . ((int) $conf->entity));

                    $sql = "INSERT INTO " . $this->db->prefix() . "product_perentity (";
                    $sql .= " fk_product";
                    $sql .= ", entity";
                    $sql .= ", accountancy_code_buy";
                    $sql .= ", accountancy_code_buy_intra";
                    $sql .= ", accountancy_code_buy_export";
                    $sql .= ", accountancy_code_sell";
                    $sql .= ", accountancy_code_sell_intra";
                    $sql .= ", accountancy_code_sell_export";
                    $sql .= ") VALUES (";
                    $sql .= $this->id;
                    $sql .= ", " . $conf->entity;
                    $sql .= ", '" . $this->db->escape($this->accountancy_code_buy) . "'";
                    $sql .= ", '" . $this->db->escape($this->accountancy_code_buy_intra) . "'";
                    $sql .= ", '" . $this->db->escape($this->accountancy_code_buy_export) . "'";
                    $sql .= ", '" . $this->db->escape($this->accountancy_code_sell) . "'";
                    $sql .= ", '" . $this->db->escape($this->accountancy_code_sell_intra) . "'";
                    $sql .= ", '" . $this->db->escape($this->accountancy_code_sell_export) . "'";
                    $sql .= ")";
                    $result = $this->db->query($sql);
                    if (!$result) {
                        $error++;
                        $this->error = 'ErrorFailedToUpdateAccountancyForEntity';
                    }
                }

                if (!$this->hasbatch() && $this->oldcopy->hasbatch()) {
                    // Selection of all product stock movements that contains batchs
                    $sql = 'SELECT pb.qty, ps.fk_entrepot, pb.batch FROM ' . MAIN_DB_PREFIX . 'product_batch as pb';
                    $sql .= ' INNER JOIN ' . MAIN_DB_PREFIX . 'product_stock as ps ON (ps.rowid = pb.fk_product_stock)';
                    $sql .= ' WHERE ps.fk_product = ' . (int) $this->id;

                    $resql = $this->db->query($sql);
                    if ($resql) {
                        $inventorycode = dol_print_date(dol_now(), '%Y%m%d%H%M%S');

                        while ($obj = $this->db->fetch_object($resql)) {
                            $value = $obj->qty;
                            $fk_entrepot = $obj->fk_entrepot;
                            $price = 0;
                            $dlc = '';
                            $dluo = '';
                            $batch = $obj->batch;

                            // To know how to revert stockMouvement (add or remove)
                            $addOremove = $value > 0 ? 1 : 0; // 1 if remove, 0 if add
                            $label = $langs->trans('BatchStockMouvementAddInGlobal');
                            $res = $this->correct_stock_batch($user, $fk_entrepot, abs($value), $addOremove, $label, $price, $dlc, $dluo, $batch, $inventorycode, '', null, 0, null, true);

                            if ($res > 0) {
                                $label = $langs->trans('BatchStockMouvementAddInGlobal');
                                $res = $this->correct_stock($user, $fk_entrepot, abs($value), (int) empty($addOremove), $label, $price, $inventorycode, '', null, 0);
                                if ($res < 0) {
                                    $error++;
                                }
                            } else {
                                $error++;
                            }
                        }
                    }
                }

                // Actions on extra fields
                if (!$error) {
                    $result = $this->insertExtraFields();
                    if ($result < 0) {
                        $error++;
                    }
                }

                if (!$error && !$notrigger) {
                    // Call trigger
                    $result = $this->call_trigger('PRODUCT_MODIFY', $user);
                    if ($result < 0) {
                        $error++;
                    }
                    // End call triggers
                }

                if (!$error && (is_object($this->oldcopy) && $this->oldcopy->ref !== $this->ref)) {
                    // We remove directory
                    if ($conf->product->dir_output) {
                        $olddir = $conf->product->dir_output . "/" . dol_sanitizeFileName($this->oldcopy->ref);
                        $newdir = $conf->product->dir_output . "/" . dol_sanitizeFileName($this->ref);
                        if (file_exists($olddir)) {
                            //include_once DOL_DOCUMENT_ROOT . '/core/lib/files.lib.php';
                            //$res = dol_move($olddir, $newdir);
                            // do not use dol_move with directory
                            $res = @rename($olddir, $newdir);
                            if (!$res) {
                                $langs->load("errors");
                                $this->error = $langs->trans('ErrorFailToRenameDir', $olddir, $newdir);
                                $error++;
                            }
                        }
                    }
                }

                if (!$error) {
                    if (isModEnabled('variants')) {
                        include_once DOL_DOCUMENT_ROOT . '/variants/class/ProductCombination.class.php';

                        $comb = new ProductCombination($this->db);

The type Dolibarr\Code\Product\Classes\ProductCombination was not found. Did you mean ProductCombination? If so, make sure to prefix the type with \.

                        foreach ($comb->fetchAllByFkProductParent($this->id) as $currcomb) {
                            $currcomb->updateProperties($this, $user);
                        }
                    }

                    $this->db->commit();
                    return 1;
                } else {
                    $this->db->rollback();
                    return -$error;
                }
            } else {
                if ($this->db->errno() == 'DB_ERROR_RECORD_ALREADY_EXISTS') {
                    $langs->load("errors");
                    if (empty($conf->barcode->enabled) || empty($this->barcode)) {
                        $this->error = $langs->trans("Error") . " : " . $langs->trans("ErrorProductAlreadyExists", $this->ref);
                    } else {
                        $this->error = $langs->trans("Error") . " : " . $langs->trans("ErrorProductBarCodeAlreadyExists", $this->barcode);
                    }
                    $this->errors[] = $this->error;
                    $this->db->rollback();
                    return -1;
                } else {
                    $this->error = $langs->trans("Error") . " : " . $this->db->error() . " - " . $sql;
                    $this->errors[] = $this->error;
                    $this->db->rollback();
                    return -2;
                }
            }
        } else {
            $this->db->rollback();
            dol_syslog(get_class($this) . "::Update fails verify " . implode(',', $this->errors), LOG_WARNING);
            return -3;
        }