Dolibarr\Code\Fourn\Classes\SupplierInvoiceLine::update()

Complexity

Conditions	28
Paths	> 20000

Size

Total Lines	130
Code Lines	85

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

<?php
    public function update($notrigger = 0)
    {
        global $conf;

        $pu = price2num($this->subprice);
        $qty = price2num($this->qty);

        // Check parameters
        if (empty($this->qty)) {
            $this->qty = 0;
        }

        if ($this->product_type < 0) {
            return -1;
        }

        // Clean parameters
        if (empty($this->remise_percent)) {
            $this->remise_percent = 0;
        }
        if (empty($this->tva_tx)) {
            $this->tva_tx = 0;
        }
        if (empty($this->localtax1_tx)) {
            $this->localtax1_tx = 0;
        }
        if (empty($this->localtax2_tx)) {
            $this->localtax2_tx = 0;
        }

        if (empty($this->pa_ht)) {
            $this->pa_ht = 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;
        }

        $fk_product = (int) $this->fk_product;
        $fk_unit = (int) $this->fk_unit;

        $this->db->begin();

        $sql = "UPDATE " . MAIN_DB_PREFIX . "facture_fourn_det SET";
        $sql .= " description = '" . $this->db->escape(empty($this->description) ? $this->desc : $this->description) . "'";

The property Dolibarr\Code\Fourn\Classes\SupplierInvoiceLine::$description has been deprecated: Use $desc

        $sql .= ", ref = '" . $this->db->escape($this->ref_supplier ? $this->ref_supplier : $this->ref) . "'";
        $sql .= ", date_start = " . ($this->date_start != '' ? "'" . $this->db->idate($this->date_start) . "'" : "null");
        $sql .= ", date_end = " . ($this->date_end != '' ? "'" . $this->db->idate($this->date_end) . "'" : "null");
        $sql .= ", pu_ht = " . price2num($this->subprice);
        $sql .= ", pu_ttc = " . price2num($this->pu_ttc);
        $sql .= ", qty = " . price2num($this->qty);
        $sql .= ", remise_percent = " . price2num($this->remise_percent);
        if ($this->fk_remise_except > 0) {
            $sql .= ", fk_remise_except=" . ((int) $this->fk_remise_except);
        } else {
            $sql .= ", fk_remise_except=null";
        }
        $sql .= ", vat_src_code = '" . $this->db->escape(empty($this->vat_src_code) ? '' : $this->vat_src_code) . "'";
        $sql .= ", tva_tx = " . price2num($this->tva_tx);
        $sql .= ", localtax1_tx = " . price2num($this->localtax1_tx);
        $sql .= ", localtax2_tx = " . price2num($this->localtax2_tx);
        $sql .= ", localtax1_type = '" . $this->db->escape($this->localtax1_type) . "'";
        $sql .= ", localtax2_type = '" . $this->db->escape($this->localtax2_type) . "'";
        $sql .= ", total_ht = " . price2num($this->total_ht);
        $sql .= ", tva= " . price2num($this->total_tva);
        $sql .= ", total_localtax1= " . price2num($this->total_localtax1);
        $sql .= ", total_localtax2= " . price2num($this->total_localtax2);
        $sql .= ", total_ttc = " . price2num($this->total_ttc);
        $sql .= ", fk_product = " . ($fk_product > 0 ? (int) $fk_product : 'null');
        $sql .= ", product_type = " . ((int) $this->product_type);
        $sql .= ", info_bits = " . ((int) $this->info_bits);
        $sql .= ", fk_unit = " . ($fk_unit > 0 ? (int) $fk_unit : 'null');

        if (!empty($this->rang)) {
            $sql .= ", rang=" . ((int) $this->rang);
        }

        // Multicurrency
        $sql .= " , multicurrency_subprice=" . price2num($this->multicurrency_subprice);
        $sql .= " , multicurrency_total_ht=" . price2num($this->multicurrency_total_ht);
        $sql .= " , multicurrency_total_tva=" . price2num($this->multicurrency_total_tva);
        $sql .= " , multicurrency_total_ttc=" . price2num($this->multicurrency_total_ttc);

        $sql .= " WHERE rowid = " . ((int) $this->id);

        dol_syslog(get_class($this) . "::update", LOG_DEBUG);
        $resql = $this->db->query($sql);

        if (!$resql) {
            $this->db->rollback();
            $this->error = $this->db->lasterror();
            return -1;
        }

        $this->rowid = $this->id;

The property Dolibarr\Core\Base\CommonObjectLine::$rowid has been deprecated: Try to use id property as possible (even if field into database is still rowid)

        $error = 0;

        if (!$error) {
            $result = $this->insertExtraFields();
            if ($result < 0) {
                $error++;
            }
        }

        if (!$error && !$notrigger) {
            global $langs, $user;

            // Call trigger
            if ($this->call_trigger('LINEBILL_SUPPLIER_MODIFY', $user) < 0) {
                $this->db->rollback();
                return -1;
            }
            // End call triggers
        }

        if ($error) {
            $this->db->rollback();
            return -1;
        }

        $this->db->commit();
        return 1;
    }