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

Complexity

Conditions	38
Paths	0

Size

Total Lines	155
Code Lines	111

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

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

        $error = 0;

        dol_syslog(get_class($this) . "::insert rang=" . $this->rang);

        // Clean parameters
        if (empty($this->tva_tx)) {
            $this->tva_tx = 0;
        }
        if (empty($this->vat_src_code)) {
            $this->vat_src_code = '';
        }
        if (empty($this->localtax1_tx)) {
            $this->localtax1_tx = 0;
        }
        if (empty($this->localtax2_tx)) {
            $this->localtax2_tx = 0;
        }
        if (empty($this->localtax1_type)) {
            $this->localtax1_type = 0;
        }
        if (empty($this->localtax2_type)) {
            $this->localtax2_type = 0;
        }
        if (empty($this->total_localtax1)) {
            $this->total_localtax1 = 0;
        }
        if (empty($this->total_localtax2)) {
            $this->total_localtax2 = 0;
        }
        if (empty($this->rang)) {
            $this->rang = 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;
            }
        }

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

        $this->db->begin();

        // Insert line into database
        $sql = 'INSERT INTO ' . MAIN_DB_PREFIX . 'supplier_proposaldet';
        $sql .= ' (fk_supplier_proposal, fk_parent_line, label, description, fk_product, product_type,';
        $sql .= ' date_start, date_end,';
        $sql .= ' fk_remise_except, qty, tva_tx, vat_src_code, localtax1_tx, localtax2_tx, localtax1_type, localtax2_type,';
        $sql .= ' subprice, remise_percent, ';
        $sql .= ' info_bits, ';
        $sql .= ' total_ht, total_tva, total_localtax1, total_localtax2, total_ttc, fk_product_fournisseur_price, buy_price_ht, special_code, rang,';
        $sql .= ' ref_fourn,';
        $sql .= ' fk_multicurrency, multicurrency_code, multicurrency_subprice, multicurrency_total_ht, multicurrency_total_tva, multicurrency_total_ttc, fk_unit)';
        $sql .= " VALUES (" . $this->fk_supplier_proposal . ",";
        $sql .= " " . ($this->fk_parent_line > 0 ? ((int) $this->fk_parent_line) : "null") . ",";
        $sql .= " " . (!empty($this->label) ? "'" . $this->db->escape($this->label) . "'" : "null") . ",";
        $sql .= " '" . $this->db->escape($this->desc) . "',";
        $sql .= " " . ($this->fk_product ? ((int) $this->fk_product) : "null") . ",";
        $sql .= " '" . $this->db->escape($this->product_type) . "',";
        $sql .= " " . ($this->date_start ? "'" . $this->db->idate($this->date_start) . "'" : "null") . ",";
        $sql .= " " . ($this->date_end ? "'" . $this->db->idate($this->date_end) . "'" : "null") . ",";
        $sql .= " " . ($this->fk_remise_except ? ((int) $this->fk_remise_except) : "null") . ",";
        $sql .= " " . price2num($this->qty, 'MS') . ",";
        $sql .= " " . price2num($this->tva_tx) . ",";
        $sql .= " '" . $this->db->escape($this->vat_src_code) . "',";
        $sql .= " " . price2num($this->localtax1_tx) . ",";
        $sql .= " " . price2num($this->localtax2_tx) . ",";
        $sql .= " '" . $this->db->escape($this->localtax1_type) . "',";
        $sql .= " '" . $this->db->escape($this->localtax2_type) . "',";
        $sql .= " " . price2num($this->subprice, 'MU') . ",";
        $sql .= " " . ((float) $this->remise_percent) . ",";
        $sql .= " " . (isset($this->info_bits) ? ((int) $this->info_bits) : "null") . ",";
        $sql .= " " . price2num($this->total_ht, 'MT') . ",";
        $sql .= " " . price2num($this->total_tva, 'MT') . ",";
        $sql .= " " . price2num($this->total_localtax1, 'MT') . ",";
        $sql .= " " . price2num($this->total_localtax2, 'MT') . ",";
        $sql .= " " . price2num($this->total_ttc, 'MT') . ",";
        $sql .= " " . (!empty($this->fk_fournprice) ? ((int) $this->fk_fournprice) : "null") . ",";
        $sql .= " " . (isset($this->pa_ht) ? price2num($this->pa_ht, 'MU') : "null") . ",";
        $sql .= ' ' . ((int) $this->special_code) . ',';
        $sql .= ' ' . ((int) $this->rang) . ',';
        $sql .= " '" . $this->db->escape($this->ref_fourn) . "'";
        $sql .= ", " . ($this->fk_multicurrency > 0 ? ((int) $this->fk_multicurrency) : 'null');
        $sql .= ", '" . $this->db->escape($this->multicurrency_code) . "'";
        $sql .= ", " . price2num($this->multicurrency_subprice, 'CU');
        $sql .= ", " . price2num($this->multicurrency_total_ht, 'CT');
        $sql .= ", " . price2num($this->multicurrency_total_tva, 'CT');
        $sql .= ", " . price2num($this->multicurrency_total_ttc, 'CT');
        $sql .= ", " . ($this->fk_unit ? ((int) $this->fk_unit) : 'null');
        $sql .= ')';

        dol_syslog(get_class($this) . '::insert', LOG_DEBUG);
        $resql = $this->db->query($sql);
        if ($resql) {
            $this->id = $this->db->last_insert_id(MAIN_DB_PREFIX . 'supplier_proposaldet');

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

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

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