ContratLigne::insert()

Complexity

Conditions	14
Paths	2048

Size

Total Lines	83
Code Lines	60

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

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

        $error = 0;

        // Insertion dans la base
        $sql = "INSERT INTO " . MAIN_DB_PREFIX . "contratdet";
        $sql .= " (fk_contrat, label, description, fk_product, qty, vat_src_code, tva_tx,";
        $sql .= " localtax1_tx, localtax2_tx, localtax1_type, localtax2_type, remise_percent, subprice,";
        $sql .= " total_ht, total_tva, total_localtax1, total_localtax2, total_ttc,";
        $sql .= " info_bits,";
        $sql .= " rang,";
        $sql .= " price_ht, remise, fk_product_fournisseur_price, buy_price_ht";
        if ($this->date_start > 0) {
            $sql .= ",date_ouverture_prevue";
        }
        if ($this->date_end > 0) {
            $sql .= ",date_fin_validite";
        }
        $sql .= ") VALUES ($this->fk_contrat, '', '" . $this->db->escape($this->description) . "',";
        $sql .= ($this->fk_product > 0 ? $this->fk_product : "null") . ",";
        $sql .= " '" . $this->db->escape($this->qty) . "',";
        $sql .= " '" . $this->db->escape($this->vat_src_code) . "',";
        $sql .= " '" . $this->db->escape($this->tva_tx) . "',";
        $sql .= " '" . $this->db->escape($this->localtax1_tx) . "',";
        $sql .= " '" . $this->db->escape($this->localtax2_tx) . "',";
        $sql .= " '" . $this->db->escape($this->localtax1_type) . "',";
        $sql .= " '" . $this->db->escape($this->localtax2_type) . "',";
        $sql .= " " . price2num($this->remise_percent) . "," . price2num($this->subprice) . ",";
        $sql .= " " . price2num($this->total_ht) . "," . price2num($this->total_tva) . "," . price2num($this->total_localtax1) . "," . price2num($this->total_localtax2) . "," . price2num($this->total_ttc) . ",";
        $sql .= " '" . $this->db->escape($this->info_bits) . "',";
        $sql .= " " . (empty($this->rang) ? '0' : (int) $this->rang) . ",";
        $sql .= " " . price2num($this->price_ht) . "," . price2num($this->remise) . ",";
        if ($this->fk_fournprice > 0) {
            $sql .= ' ' . ((int) $this->fk_fournprice) . ',';
        } else {
            $sql .= ' null,';
        }
        if ($this->pa_ht > 0) {
            $sql .= ' ' . ((float) price2num($this->pa_ht));
        } else {
            $sql .= ' null';
        }
        if ($this->date_start > 0) {
            $sql .= ",'" . $this->db->idate($this->date_start) . "'";
        }
        if ($this->date_end > 0) {
            $sql .= ",'" . $this->db->idate($this->date_end) . "'";
        }
        $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 . 'contratdet');

            // Insert of extrafields
            if (!$error) {
                $result = $this->insertExtraFields();
                if ($result < 0) {
                    $this->db->rollback();
                    return -1;
                }
            }

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

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