Dolibarr\Code\Compta\Classes\FactureRec::updateline()

Complexity

Conditions	23
Paths	> 20000

Size

Total Lines	145
Code Lines	104

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public function updateline($rowid, $desc, $pu_ht, $qty, $txtva, $txlocaltax1 = 0, $txlocaltax2 = 0, $fk_product = 0, $remise_percent = 0, $price_base_type = 'HT', $info_bits = 0, $fk_remise_except = 0, $pu_ttc = 0, $type = 0, $rang = -1, $special_code = 0, $label = '', $fk_unit = null, $pu_ht_devise = 0, $notrigger = 0, $date_start_fill = 0, $date_end_fill = 0, $fk_fournprice = null, $pa_ht = 0, $fk_parent_line = 0)
    {
        global $mysoc;

        $facid = $this->id;

        dol_syslog(get_class($this) . "::updateline facid=" . $facid . " rowid=$rowid, desc=$desc, pu_ht=$pu_ht, qty=$qty, txtva=$txtva, txlocaltax1=$txlocaltax1, txlocaltax2=$txlocaltax2, fk_product=$fk_product, remise_percent=$remise_percent, info_bits=$info_bits, fk_remise_except=$fk_remise_except, price_base_type=$price_base_type, pu_ttc=$pu_ttc, type=$type, fk_unit=$fk_unit, pu_ht_devise=$pu_ht_devise", LOG_DEBUG);
        include_once DOL_DOCUMENT_ROOT . '/core/lib/price.lib.php';

        // Clean parameters
        if (empty($remise_percent)) {
            $remise_percent = 0;
        }

        // Check parameters
        if ($type < 0) {
            return -1;
        }

        // Clean parameters
        $remise_percent = price2num($remise_percent);
        $qty = price2num($qty);
        if (empty($info_bits)) {
            $info_bits = 0;
        }
        $pu_ht          = price2num($pu_ht);
        $pu_ttc         = price2num($pu_ttc);
        $pu_ht_devise = price2num($pu_ht_devise);
        if (!preg_match('/\((.*)\)/', (string) $txtva)) {
            $txtva = price2num($txtva); // $txtva can have format '5.0(XXX)' or '5'
        }
        $txlocaltax1    = price2num($txlocaltax1);
        $txlocaltax2    = price2num($txlocaltax2);
        if (empty($txlocaltax1)) {
            $txlocaltax1 = 0;
        }
        if (empty($txlocaltax2)) {
            $txlocaltax2 = 0;
        }

        if (empty($this->multicurrency_subprice)) {
            $this->multicurrency_subprice = 0;
        }
        if (empty($this->multicurrency_total_ht)) {
            $this->multicurrency_total_ht = 0;
        }
        if (empty($this->multicurrency_total_tva)) {
            $this->multicurrency_total_tva = 0;
        }
        if (empty($this->multicurrency_total_ttc)) {
            $this->multicurrency_total_ttc = 0;
        }

        if ($price_base_type == 'HT') {
            $pu = $pu_ht;
        } else {
            $pu = $pu_ttc;
        }

        // Calculate total with, without tax and tax from qty, pu, remise_percent and txtva
        // TRES IMPORTANT: C'est au moment de l'insertion ligne qu'on doit stocker
        // la part ht, tva et ttc, et ce au niveau de la ligne qui a son propre taux tva.

        $localtaxes_type = getLocalTaxesFromRate($txtva, 0, $this->thirdparty, $mysoc);

        // Clean vat code
        $vat_src_code = '';
        $reg = array();
        if (preg_match('/\((.*)\)/', $txtva, $reg)) {
            $vat_src_code = $reg[1];
            $txtva = preg_replace('/\s*\(.*\)/', '', $txtva); // Remove code into vatrate.
        }

        $tabprice = calcul_price_total($qty, $pu, $remise_percent, $txtva, $txlocaltax1, $txlocaltax2, 0, $price_base_type, $info_bits, $type, $mysoc, $localtaxes_type, 100, $this->multicurrency_tx, $pu_ht_devise);

        $total_ht  = $tabprice[0];
        $total_tva = $tabprice[1];
        $total_ttc = $tabprice[2];
        $total_localtax1 = $tabprice[9];
        $total_localtax2 = $tabprice[10];
        $pu_ht  = $tabprice[3];
        $pu_tva = $tabprice[4];
        $pu_ttc = $tabprice[5];

        // MultiCurrency
        $multicurrency_total_ht  = $tabprice[16];
        $multicurrency_total_tva = $tabprice[17];
        $multicurrency_total_ttc = $tabprice[18];
        $pu_ht_devise = $tabprice[19];

        $product_type = $type;
        if ($fk_product) {
            $product = new Product($this->db);
            $result = $product->fetch($fk_product);
            $product_type = $product->type;
        }

        if (empty($fk_parent_line) || $fk_parent_line < 0) {
            $fk_parent_line = 0;
        }

        $sql = "UPDATE " . MAIN_DB_PREFIX . "facturedet_rec SET ";
        $sql .= "fk_facture = " . ((int) $facid);
        $sql .= ", fk_parent_line = " . ($fk_parent_line > 0 ? ((int) $fk_parent_line) : "null");
        $sql .= ", label=" . (!empty($label) ? "'" . $this->db->escape($label) . "'" : "null");
        $sql .= ", description='" . $this->db->escape($desc) . "'";
        $sql .= ", price=" . price2num($pu_ht);
        $sql .= ", qty=" . price2num($qty);
        $sql .= ", tva_tx=" . price2num($txtva);
        $sql .= ", vat_src_code='" . $this->db->escape($vat_src_code) . "'";
        $sql .= ", localtax1_tx=" . ((float) $txlocaltax1);
        $sql .= ", localtax1_type='" . $this->db->escape($localtaxes_type[0]) . "'";
        $sql .= ", localtax2_tx=" . ((float) $txlocaltax2);
        $sql .= ", localtax2_type='" . $this->db->escape($localtaxes_type[2]) . "'";
        $sql .= ", fk_product=" . (!empty($fk_product) ? "'" . $this->db->escape($fk_product) . "'" : "null");
        $sql .= ", product_type=" . ((int) $product_type);
        $sql .= ", remise_percent='" . price2num($remise_percent) . "'";
        $sql .= ", subprice='" . price2num($pu_ht) . "'";
        $sql .= ", total_ht='" . price2num($total_ht) . "'";
        $sql .= ", total_tva='" . price2num($total_tva) . "'";
        $sql .= ", total_localtax1='" . price2num($total_localtax1) . "'";
        $sql .= ", total_localtax2='" . price2num($total_localtax2) . "'";
        $sql .= ", total_ttc='" . price2num($total_ttc) . "'";
        $sql .= ", date_start_fill=" . ((int) $date_start_fill);
        $sql .= ", date_end_fill=" . ((int) $date_end_fill);
        $sql .= ", fk_product_fournisseur_price=" . ($fk_fournprice > 0 ? $fk_fournprice : 'null');
        $sql .= ", buy_price_ht=" . ($pa_ht ? price2num($pa_ht) : 0);
        $sql .= ", info_bits=" . ((int) $info_bits);
        $sql .= ", rang=" . ((int) $rang);
        $sql .= ", special_code=" . ((int) $special_code);
        $sql .= ", fk_unit=" . ($fk_unit ? "'" . $this->db->escape($fk_unit) . "'" : "null");
        $sql .= ', multicurrency_subprice = ' . price2num($pu_ht_devise);
        $sql .= ', multicurrency_total_ht = ' . price2num($multicurrency_total_ht);
        $sql .= ', multicurrency_total_tva = ' . price2num($multicurrency_total_tva);
        $sql .= ', multicurrency_total_ttc = ' . price2num($multicurrency_total_ttc);
        $sql .= " WHERE rowid = " . ((int) $rowid);

        dol_syslog(get_class($this) . "::updateline", LOG_DEBUG);
        if ($this->db->query($sql)) {
            $this->id = $facid;
            $this->update_price(1);
            return 1;
        } else {
            $this->error = $this->db->lasterror();
            return -1;
        }