Dolibarr\Code\Comm\Classes\PropaleLigne::insert()

Complexity

Conditions	45
Paths	> 20000

Size

Total Lines	161
Code Lines	115

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

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

        $error = 0;

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

        $pa_ht_isemptystring = (empty($this->pa_ht) && $this->pa_ht == ''); // If true, we can use a default value. If this->pa_ht = '0', we must use '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->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) || !is_numeric($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 (!is_numeric($this->qty)) {
            $this->qty = 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;
        }

        // if buy price not defined, define buyprice as configured in margin admin
        if ($this->pa_ht == 0 && $pa_ht_isemptystring) {
            if (($result = $this->defineBuyPrice($this->subprice, $this->remise_percent, $this->fk_product)) < 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 . 'propaldet';
        $sql .= ' (fk_propal, fk_parent_line, label, description, fk_product, product_type,';
        $sql .= ' fk_remise_except, qty, vat_src_code, tva_tx, 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 .= ' fk_unit,';
        $sql .= ' date_start, date_end';
        $sql .= ', fk_multicurrency, multicurrency_code, multicurrency_subprice, multicurrency_total_ht, multicurrency_total_tva, multicurrency_total_ttc)';
        $sql .= " VALUES (" . $this->fk_propal . ",";
        $sql .= " " . ($this->fk_parent_line > 0 ? "'" . $this->db->escape($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 ? "'" . $this->db->escape($this->fk_product) . "'" : "null") . ",";
        $sql .= " '" . $this->db->escape($this->product_type) . "',";
        $sql .= " " . ($this->fk_remise_except ? "'" . $this->db->escape($this->fk_remise_except) . "'" : "null") . ",";
        $sql .= " " . price2num($this->qty, 'MS') . ",";
        $sql .= " " . (empty($this->vat_src_code) ? "''" : "'" . $this->db->escape($this->vat_src_code) . "'") . ",";
        $sql .= " " . price2num($this->tva_tx) . ",";
        $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) !== '' ? price2num($this->subprice, 'MU') : "null") . ",";
        $sql .= " " . price2num($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) ? "'" . $this->db->escape($this->fk_fournprice) . "'" : "null") . ",";
        $sql .= " " . (isset($this->pa_ht) ? "'" . price2num($this->pa_ht) . "'" : "null") . ",";
        $sql .= ' ' . ((int) $this->special_code) . ',';
        $sql .= ' ' . ((int) $this->rang) . ',';
        $sql .= ' ' . (empty($this->fk_unit) ? 'NULL' : ((int) $this->fk_unit)) . ',';
        $sql .= " " . (!empty($this->date_start) ? "'" . $this->db->idate($this->date_start) . "'" : "null") . ',';
        $sql .= " " . (!empty($this->date_end) ? "'" . $this->db->idate($this->date_end) . "'" : "null");
        $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 .= ')';

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

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)

            if (!$error) {
                $this->id = $this->rowid;

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)

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

            if (!$error && !$notrigger) {
                // Call trigger
                $result = $this->call_trigger('LINEPROPAL_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;
        }