CommandeFournisseurLigne::update()

Complexity

Conditions	13
Paths	512

Size

Total Lines	73
Code Lines	53

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

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

        $error = 0;

        $this->db->begin();

        $sql = "UPDATE " . $this->db->prefix() . $this->table_element . " SET";
        $sql .= "  description='" . $this->db->escape($this->desc) . "'";
        $sql .= ", ref='" . $this->db->escape($this->ref_supplier) . "'";
        $sql .= ", subprice='" . price2num($this->subprice) . "'";
        //$sql.= ",remise='".price2num($remise)."'";
        $sql .= ", remise_percent='" . price2num($this->remise_percent) . "'";

        $sql .= ", vat_src_code = '" . (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 .= ", qty='" . price2num($this->qty) . "'";
        $sql .= ", date_start=" . (!empty($this->date_start) ? "'" . $this->db->idate($this->date_start) . "'" : "null");
        $sql .= ", date_end=" . (!empty($this->date_end) ? "'" . $this->db->idate($this->date_end) . "'" : "null");
        $sql .= ", info_bits='" . $this->db->escape($this->info_bits) . "'";
        $sql .= ", total_ht='" . price2num($this->total_ht) . "'";
        $sql .= ", total_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 .= ", product_type=" . $this->product_type;
        $sql .= ", special_code=" . (!empty($this->special_code) ? $this->special_code : 0);
        $sql .= ($this->fk_unit ? ", fk_unit='" . $this->db->escape($this->fk_unit) . "'" : ", 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) . "::updateline", 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('LINEORDER_SUPPLIER_MODIFY', $user);
                if ($result < 0) {
                    $this->db->rollback();
                    return -1;
                }
                // End call triggers
            }

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