Dolibarr\Code\SupplierProposal\Classes\SupplierProposalLine::update()

Complexity

Conditions	35
Paths	> 20000

Size

Total Lines	139
Code Lines	95

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

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

        $error = 0;

        // Clean parameters
        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->total_localtax1)) {
            $this->total_localtax1 = 0;
        }
        if (empty($this->total_localtax2)) {
            $this->total_localtax2 = 0;
        }
        if (empty($this->localtax1_type)) {
            $this->localtax1_type = 0;
        }
        if (empty($this->localtax2_type)) {
            $this->localtax2_type = 0;
        }
        if (empty($this->marque_tx)) {
            $this->marque_tx = 0;
        }
        if (empty($this->marge_tx)) {
            $this->marge_tx = 0;
        }
        if (empty($this->remise_percent)) {
            $this->remise_percent = 0;
        }
        if (empty($this->info_bits)) {
            $this->info_bits = 0;
        }
        if (empty($this->special_code)) {
            $this->special_code = 0;
        }
        if (empty($this->fk_parent_line)) {
            $this->fk_parent_line = 0;
        }
        if (empty($this->fk_fournprice)) {
            $this->fk_fournprice = 0;
        }
        if (empty($this->fk_unit)) {
            $this->fk_unit = 0;
        }
        if (empty($this->subprice)) {
            $this->subprice = 0;
        }

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

        // if buy price not defined, define buyprice as configured in margin admin
        if ($this->pa_ht == 0) {
            $result = $this->defineBuyPrice($this->subprice, $this->remise_percent, $this->fk_product);
            if ($result < 0) {
                return $result;
            } else {
                $this->pa_ht = $result;
            }
        }

        $this->db->begin();

        // Mise a jour ligne en base
        $sql = "UPDATE " . MAIN_DB_PREFIX . "supplier_proposaldet SET";
        $sql .= " description='" . $this->db->escape($this->desc) . "'";
        $sql .= " , label=" . (!empty($this->label) ? "'" . $this->db->escape($this->label) . "'" : "null");
        $sql .= " , product_type=" . ((int) $this->product_type);
        $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 .= " , 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 .= " , qty='" . price2num($this->qty) . "'";
        $sql .= " , subprice=" . price2num($this->subprice);
        $sql .= " , remise_percent=" . price2num($this->remise_percent);
        $sql .= " , info_bits='" . $this->db->escape($this->info_bits) . "'";
        if (empty($this->skip_update_total)) {
            $sql .= " , total_ht=" . price2num($this->total_ht);
            $sql .= " , total_tva=" . price2num($this->total_tva);
            $sql .= " , total_ttc=" . price2num($this->total_ttc);
            $sql .= " , total_localtax1=" . price2num($this->total_localtax1);
            $sql .= " , total_localtax2=" . price2num($this->total_localtax2);
        }
        $sql .= " , fk_product_fournisseur_price=" . (!empty($this->fk_fournprice) ? "'" . $this->db->escape($this->fk_fournprice) . "'" : "null");
        $sql .= " , buy_price_ht=" . price2num($this->pa_ht);
        $sql .= " , special_code=" . ((int) $this->special_code);
        $sql .= " , fk_parent_line=" . ($this->fk_parent_line > 0 ? $this->fk_parent_line : "null");
        if (!empty($this->rang)) {
            $sql .= ", rang=" . ((int) $this->rang);
        }
        $sql .= " , ref_fourn=" . (!empty($this->ref_fourn) ? "'" . $this->db->escape($this->ref_fourn) . "'" : "null");
        $sql .= " , fk_unit=" . ($this->fk_unit ? $this->fk_unit : 'null');

        // 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) {
            if (!$error) {
                $result = $this->insertExtraFields();
                if ($result < 0) {
                    $error++;
                }
            }

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

            $this->db->commit();
            return 1;
        } else {
            $this->error = $this->db->error();
            $this->db->rollback();
            return -2;
        }