Dolibarr\Code\Fourn\Classes\ProductFournisseur::update_buyprice()

Complexity

Conditions	76
Paths	> 20000

Size

Total Lines	326
Code Lines	216

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public function update_buyprice(
        $qty,
        $buyprice,
        $user,
        $price_base_type,
        $fourn,
        $availability,
        $ref_fourn,
        $tva_tx,
        $charges = 0,
        $remise_percent = 0,
        $remise = 0,
        $newnpr = 0,
        $delivery_time_days = 0,
        $supplier_reputation = '',
        $localtaxes_array = array(),
        $newdefaultvatcode = '',
        $multicurrency_buyprice = 0,
        $multicurrency_price_base_type = 'HT',
        $multicurrency_tx = 1,
        $multicurrency_code = '',
        $desc_fourn = '',
        $barcode = '',
        $fk_barcode_type = 0,
        $options = array()
    ) {
		// phpcs:enable
        global $conf, $langs;
        //global $mysoc;

        // Clean parameter
        if (empty($qty)) {
            $qty = 0;
        }
        if (empty($buyprice)) {
            $buyprice = 0;
        }
        if (empty($charges)) {
            $charges = 0;
        }
        if (empty($availability)) {
            $availability = 0;
        }
        if (empty($remise_percent)) {
            $remise_percent = 0;
        }
        if (empty($supplier_reputation) || $supplier_reputation == -1) {
            $supplier_reputation = '';
        }
        if ($delivery_time_days != '' && !is_numeric($delivery_time_days)) {
            $delivery_time_days = 0;
        }
        if ($price_base_type == 'TTC') {
            $ttx = $tva_tx;
            $buyprice = $buyprice / (1 + ($ttx / 100));
        }

        // Multicurrency
        $multicurrency_unitBuyPrice = null;
        $fk_multicurrency = null;
        if (isModEnabled("multicurrency")) {
            if (empty($multicurrency_tx)) {
                $multicurrency_tx = 1;
            }
            if (empty($multicurrency_buyprice)) {
                $multicurrency_buyprice = 0;
            }
            if ($multicurrency_price_base_type == 'TTC') {
                $ttx = $tva_tx;
                $multicurrency_buyprice = $multicurrency_buyprice / (1 + ($ttx / 100));
            }
            $multicurrency_buyprice = price2num($multicurrency_buyprice, 'MU');
            $multicurrency_unitBuyPrice = price2num($multicurrency_buyprice / $qty, 'MU');

            $buyprice = $multicurrency_buyprice / $multicurrency_tx;
            $fk_multicurrency = MultiCurrency::getIdFromCode($this->db, $multicurrency_code);
        }

        $buyprice = (float) price2num($buyprice, 'MU');
        $charges = (float) price2num($charges, 'MU');
        $qty = (float) price2num($qty, 'MS');
        $unitBuyPrice = (float) price2num($buyprice / $qty, 'MU');

        // We can have a purchase ref that need to buy 100 min for a given price and with a packaging of 50.
        //$packaging = price2num(((empty($this->packaging) || $this->packaging < $qty) ? $qty : $this->packaging), 'MS');
        $packaging = price2num((empty($this->packaging) ? $qty : $this->packaging), 'MS');

        $error = 0;
        $now = dol_now();

        $newvat = $tva_tx;

        if (count($localtaxes_array) > 0) {
            $localtaxtype1 = $localtaxes_array['0'];
            $localtax1 = $localtaxes_array['1'];
            $localtaxtype2 = $localtaxes_array['2'];
            $localtax2 = $localtaxes_array['3'];
        } else { // old method. deprecated because it can't retrieve type
            $localtaxtype1 = '0';
            $localtax1 = get_localtax($newvat, 1);
            $localtaxtype2 = '0';
            $localtax2 = get_localtax($newvat, 2);
        }
        if (empty($localtax1)) {
            $localtax1 = 0; // If = '' then = 0
        }
        if (empty($localtax2)) {
            $localtax2 = 0; // If = '' then = 0
        }

        $this->db->begin();

        if ($this->product_fourn_price_id > 0) {
            // check if price already logged, if not first log current price
            $logPrices = $this->listProductFournisseurPriceLog($this->product_fourn_price_id);
            if (is_array($logPrices) && count($logPrices) == 0) {
                $currentPfp = new self($this->db);
                $result = $currentPfp->fetch_product_fournisseur_price($this->product_fourn_price_id);
                if ($result > 0 && $currentPfp->fourn_price != 0) {
                    $currentPfpUser = new User($this->db);

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

                    $result = $currentPfpUser->fetch($currentPfp->user_id);
                    if ($result > 0) {
                        $currentPfp->logPrice(
                            $currentPfpUser,
                            $currentPfp->date_creation,
                            $currentPfp->fourn_price,
                            $currentPfp->fourn_qty,
                            $currentPfp->fourn_multicurrency_price,
                            $currentPfp->fourn_multicurrency_unitprice,
                            $currentPfp->fourn_multicurrency_tx,
                            $currentPfp->fourn_multicurrency_id,
                            $currentPfp->fourn_multicurrency_code
                        );
                    }
                }
            }
            $sql = "UPDATE " . MAIN_DB_PREFIX . "product_fournisseur_price";
            $sql .= " SET fk_user = " . ((int) $user->id) . " ,";
            $sql .= " datec = '" . $this->db->idate($now) . "' ,";  // Note: Even if this is an update, we update the creation date as the log of each change is tracked into product_fournisseur_log.
            $sql .= " ref_fourn = '" . $this->db->escape($ref_fourn) . "',";
            $sql .= " desc_fourn = '" . $this->db->escape($desc_fourn) . "',";
            $sql .= " price = " . ((float) $buyprice) . ",";
            $sql .= " quantity = " . ((float) $qty) . ",";
            $sql .= " remise_percent = " . ((float) $remise_percent) . ",";
            $sql .= " remise = " . ((float) $remise) . ",";
            $sql .= " unitprice = " . ((float) $unitBuyPrice) . ",";
            $sql .= " fk_availability = " . ((int) $availability) . ",";
            $sql .= " multicurrency_price = " . (isset($multicurrency_buyprice) ? "'" . $this->db->escape(price2num($multicurrency_buyprice)) . "'" : 'null') . ",";
            $sql .= " multicurrency_unitprice = " . (isset($multicurrency_unitBuyPrice) ? "'" . $this->db->escape(price2num($multicurrency_unitBuyPrice)) . "'" : 'null') . ",";
            $sql .= " multicurrency_tx = " . (isset($multicurrency_tx) ? "'" . $this->db->escape($multicurrency_tx) . "'" : '1') . ",";
            $sql .= " fk_multicurrency = " . (isset($fk_multicurrency) ? "'" . $this->db->escape($fk_multicurrency) . "'" : 'null') . ",";
            $sql .= " multicurrency_code = " . (isset($multicurrency_code) ? "'" . $this->db->escape($multicurrency_code) . "'" : 'null') . ",";
            $sql .= " entity = " . $conf->entity . ",";
            $sql .= " tva_tx = " . price2num($tva_tx) . ",";
            // TODO Add localtax1 and localtax2
            //$sql.= " localtax1_tx=".($localtax1>=0?$localtax1:'NULL').",";
            //$sql.= " localtax2_tx=".($localtax2>=0?$localtax2:'NULL').",";
            //$sql.= " localtax1_type=".($localtaxtype1!=''?"'".$this->db->escape($localtaxtype1)."'":"'0'").",";
            //$sql.= " localtax2_type=".($localtaxtype2!=''?"'".$this->db->escape($localtaxtype2)."'":"'0'").",";
            $sql .= " default_vat_code=" . ($newdefaultvatcode ? "'" . $this->db->escape($newdefaultvatcode) . "'" : "null") . ",";
            $sql .= " info_bits = " . ((int) $newnpr) . ",";
            $sql .= " charges = " . ((float) $charges) . ","; // deprecated
            $sql .= " delivery_time_days = " . ($delivery_time_days != '' ? ((int) $delivery_time_days) : 'null') . ",";
            $sql .= " supplier_reputation = " . (empty($supplier_reputation) ? 'NULL' : "'" . $this->db->escape($supplier_reputation) . "'") . ",";
            $sql .= " barcode = " . (empty($barcode) ? 'NULL' : "'" . $this->db->escape($barcode) . "'") . ",";
            $sql .= " fk_barcode_type = " . (empty($fk_barcode_type) ? 'NULL' : "'" . $this->db->escape($fk_barcode_type) . "'");
            if (getDolGlobalString('PRODUCT_USE_SUPPLIER_PACKAGING')) {
                $sql .= ", packaging = " . (empty($packaging) ? 1 : $packaging);
            }
            $sql .= " WHERE rowid = " . ((int) $this->product_fourn_price_id);

            if (!$error) {
                if (!empty($options) && is_array($options)) {
                    $productfournisseurprice = new ProductFournisseurPrice($this->db);

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

                    $res = $productfournisseurprice->fetch($this->product_fourn_price_id);
                    if ($res > 0) {
                        foreach ($options as $key => $value) {
                            $productfournisseurprice->array_options[$key] = $value;
                        }
                        $res = $productfournisseurprice->update($user);
                        if ($res < 0) {
                            $this->error = $productfournisseurprice->error;
                            $this->errors = $productfournisseurprice->errors;
                            $error++;
                        }
                    }
                }
            }

            // TODO Add price_base_type and price_ttc

            dol_syslog(get_class($this) . '::update_buyprice update knowing id of line = product_fourn_price_id = ' . $this->product_fourn_price_id, LOG_DEBUG);
            $resql = $this->db->query($sql);
            if ($resql) {
                // Call trigger
                $result = $this->call_trigger('SUPPLIER_PRODUCT_BUYPRICE_MODIFY', $user);
                if ($result < 0) {
                    $error++;
                }
                // End call triggers
                if (!$error && !getDolGlobalString('PRODUCT_PRICE_SUPPLIER_NO_LOG')) {
                    $result = $this->logPrice($user, $now, $buyprice, $qty, $multicurrency_buyprice, $multicurrency_unitBuyPrice, $multicurrency_tx, $fk_multicurrency, $multicurrency_code);
                    if ($result < 0) {
                        $error++;
                    }
                }
                if (empty($error)) {
                    $this->db->commit();
                    return $this->product_fourn_price_id;
                } else {
                    $this->db->rollback();
                    return -1;
                }
            } else {
                $this->error = $this->db->error() . " sql=" . $sql;
                $this->db->rollback();
                return -2;
            }
        } else {
            dol_syslog(get_class($this) . '::update_buyprice without knowing id of line, so we delete from company, quantity and supplier_ref and insert again', LOG_DEBUG);

            // Delete price for this quantity
            $sql = "DELETE FROM  " . MAIN_DB_PREFIX . "product_fournisseur_price";
            $sql .= " WHERE fk_soc = " . ((int) $fourn->id) . " AND ref_fourn = '" . $this->db->escape($ref_fourn) . "' AND quantity = " . ((float) $qty) . " AND entity = " . ((int) $conf->entity);
            $resql = $this->db->query($sql);
            if ($resql) {
                // Add price for this quantity to supplier
                $sql = "INSERT INTO " . MAIN_DB_PREFIX . "product_fournisseur_price(";
                $sql .= " multicurrency_price, multicurrency_unitprice, multicurrency_tx, fk_multicurrency, multicurrency_code,";
                $sql .= "datec, fk_product, fk_soc, ref_fourn, desc_fourn, fk_user, price, quantity, remise_percent, remise, unitprice, tva_tx, charges, fk_availability, default_vat_code, info_bits, entity, delivery_time_days, supplier_reputation, barcode, fk_barcode_type";
                if (getDolGlobalString('PRODUCT_USE_SUPPLIER_PACKAGING')) {
                    $sql .= ", packaging";
                }
                $sql .= ") values(";
                $sql .= (isset($multicurrency_buyprice) ? "'" . $this->db->escape(price2num($multicurrency_buyprice)) . "'" : 'null') . ",";
                $sql .= (isset($multicurrency_unitBuyPrice) ? "'" . $this->db->escape(price2num($multicurrency_unitBuyPrice)) . "'" : 'null') . ",";
                $sql .= (isset($multicurrency_tx) ? "'" . $this->db->escape($multicurrency_tx) . "'" : '1') . ",";
                $sql .= (isset($fk_multicurrency) ? "'" . $this->db->escape($fk_multicurrency) . "'" : 'null') . ",";
                $sql .= (isset($multicurrency_code) ? "'" . $this->db->escape($multicurrency_code) . "'" : 'null') . ",";
                $sql .= " '" . $this->db->idate($now) . "',";
                $sql .= " " . ((int) $this->id) . ",";
                $sql .= " " . ((int) $fourn->id) . ",";
                $sql .= " '" . $this->db->escape($ref_fourn) . "',";
                $sql .= " '" . $this->db->escape($desc_fourn) . "',";
                $sql .= " " . ((int) $user->id) . ",";
                $sql .= " " . price2num($buyprice) . ",";
                $sql .= " " . ((float) $qty) . ",";
                $sql .= " " . ((float) $remise_percent) . ",";
                $sql .= " " . ((float) $remise) . ",";
                $sql .= " " . price2num($unitBuyPrice) . ",";
                $sql .= " " . price2num($tva_tx) . ",";
                $sql .= " " . price2num($charges) . ",";
                $sql .= " " . ((int) $availability) . ",";
                $sql .= " " . ($newdefaultvatcode ? "'" . $this->db->escape($newdefaultvatcode) . "'" : "null") . ",";
                $sql .= " " . ((int) $newnpr) . ",";
                $sql .= $conf->entity . ",";
                $sql .= ($delivery_time_days != '' ? ((int) $delivery_time_days) : 'null') . ",";
                $sql .= (empty($supplier_reputation) ? 'NULL' : "'" . $this->db->escape($supplier_reputation) . "'") . ",";
                $sql .= (empty($barcode) ? 'NULL' : "'" . $this->db->escape($barcode) . "'") . ",";
                $sql .= (empty($fk_barcode_type) ? 'NULL' : "'" . $this->db->escape($fk_barcode_type) . "'");
                if (getDolGlobalString('PRODUCT_USE_SUPPLIER_PACKAGING')) {
                    $sql .= ", " . (empty($this->packaging) ? '1' : "'" . $this->db->escape($this->packaging) . "'");
                }
                $sql .= ")";

                $this->product_fourn_price_id = 0;

                $resql = $this->db->query($sql);
                if ($resql) {
                    $this->product_fourn_price_id = $this->db->last_insert_id(MAIN_DB_PREFIX . "product_fournisseur_price");
                } else {
                    $this->error = $this->db->lasterror();
                    $error++;
                }

                if (!$error) {
                    if (!empty($options) && is_array($options)) {
                        $productfournisseurprice = new ProductFournisseurPrice($this->db);
                        $res = $productfournisseurprice->fetch($this->product_fourn_price_id);
                        if ($res > 0) {
                            foreach ($options as $key => $value) {
                                $productfournisseurprice->array_options[$key] = $value;
                            }
                            $res = $productfournisseurprice->update($user);
                            if ($res < 0) {
                                $this->error = $productfournisseurprice->error;
                                $this->errors = $productfournisseurprice->errors;
                                $error++;
                            }
                        }
                    }
                }

                if (!$error && !getDolGlobalString('PRODUCT_PRICE_SUPPLIER_NO_LOG')) {
                    // Add record into log table
                    // $this->product_fourn_price_id must be set
                    $result = $this->logPrice($user, $now, $buyprice, $qty, $multicurrency_buyprice, $multicurrency_unitBuyPrice, $multicurrency_tx, $fk_multicurrency, $multicurrency_code);
                    if ($result < 0) {
                        $error++;
                    }
                }

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

                    if (empty($error)) {
                        $this->db->commit();
                        return $this->product_fourn_price_id;
                    } else {
                        $this->db->rollback();
                        return -1;
                    }
                } else {
                    $this->error = $this->db->lasterror() . " sql=" . $sql;
                    $this->db->rollback();
                    return -2;
                }
            } else {
                $this->error = $this->db->lasterror() . " sql=" . $sql;
                $this->db->rollback();
                return -1;
            }