DoliModules\Billing\Model\InvoiceLine::insert()

Complexity

Conditions	54
Paths	> 20000

Size

Total Lines	227
Code Lines	164

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

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

        $error = 0;

        $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'.

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

        // Clean parameters
        $this->desc = trim($this->desc);
        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)) {
            $this->remise_percent = 0;
        }
        if (empty($this->info_bits)) {
            $this->info_bits = 0;
        }
        if (empty($this->subprice)) {
            $this->subprice = 0;
        }
        if (empty($this->ref_ext)) {
            $this->ref_ext = '';
        }
        if (empty($this->special_code)) {
            $this->special_code = 0;
        }
        if (empty($this->fk_parent_line)) {
            $this->fk_parent_line = 0;
        }
        if (empty($this->fk_prev_id)) {
            $this->fk_prev_id = 0;
        }
        if (!isset($this->situation_percent) || $this->situation_percent > 100 || (string) $this->situation_percent == '') {
            $this->situation_percent = 100;
        }

        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) {
            $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) {
            $this->error = 'ErrorProductTypeMustBe0orMore';
            return -1;
        }
        if (!empty($this->fk_product) && $this->fk_product > 0) {
            // Check product exists
            $result = Product::isExistingObject('product', $this->fk_product);

The type DoliModules\Billing\Model\Product was not found. Did you mean Product? If so, make sure to prefix the type with \.

            if ($result <= 0) {
                $this->error = 'ErrorProductIdDoesNotExists';
                dol_syslog(get_class($this) . "::insert Error " . $this->error, LOG_ERR);
                return -1;
            }
        }

        $this->db->begin();

        // Update line in database
        $sql = 'INSERT INTO ' . MAIN_DB_PREFIX . 'facturedet';
        $sql .= ' (fk_facture, fk_parent_line, label, description, qty,';
        $sql .= ' vat_src_code, tva_tx, localtax1_tx, localtax2_tx, localtax1_type, localtax2_type,';
        $sql .= ' fk_product, product_type, remise_percent, subprice, ref_ext, fk_remise_except,';
        $sql .= ' date_start, date_end, fk_code_ventilation,';
        $sql .= ' rang, special_code, fk_product_fournisseur_price, buy_price_ht,';
        $sql .= ' info_bits, total_ht, total_tva, total_ttc, total_localtax1, total_localtax2,';
        $sql .= ' situation_percent, fk_prev_id,';
        $sql .= ' fk_unit, fk_user_author, fk_user_modif,';
        $sql .= ' fk_multicurrency, multicurrency_code, multicurrency_subprice, multicurrency_total_ht, multicurrency_total_tva, multicurrency_total_ttc';
        $sql .= ')';
        $sql .= " VALUES (" . $this->fk_facture . ",";
        $sql .= " " . ($this->fk_parent_line > 0 ? $this->fk_parent_line : "null") . ",";
        $sql .= " " . (!empty($this->label) ? "'" . $this->db->escape($this->label) . "'" : "null") . ",";
        $sql .= " '" . $this->db->escape($this->desc) . "',";
        $sql .= " " . price2num($this->qty) . ",";
        $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 .= ' ' . ((!empty($this->fk_product) && $this->fk_product > 0) ? $this->fk_product : "null") . ',';
        $sql .= " " . ((int) $this->product_type) . ",";
        $sql .= " " . price2num($this->remise_percent) . ",";
        $sql .= " " . price2num($this->subprice) . ",";
        $sql .= " '" . $this->db->escape($this->ref_ext) . "',";
        $sql .= ' ' . (!empty($this->fk_remise_except) ? $this->fk_remise_except : "null") . ',';
        $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 .= ' ' . ((int) $this->fk_code_ventilation) . ',';
        $sql .= ' ' . ((int) $this->rang) . ',';
        $sql .= ' ' . ((int) $this->special_code) . ',';
        $sql .= ' ' . (!empty($this->fk_fournprice) ? $this->fk_fournprice : "null") . ',';
        $sql .= ' ' . price2num($this->pa_ht) . ',';
        $sql .= " '" . $this->db->escape($this->info_bits) . "',";
        $sql .= " " . price2num($this->total_ht) . ",";
        $sql .= " " . price2num($this->total_tva) . ",";
        $sql .= " " . price2num($this->total_ttc) . ",";
        $sql .= " " . price2num($this->total_localtax1) . ",";
        $sql .= " " . price2num($this->total_localtax2);
        $sql .= ", " . ((float) $this->situation_percent);
        $sql .= ", " . (!empty($this->fk_prev_id) ? $this->fk_prev_id : "null");
        $sql .= ", " . (!$this->fk_unit ? 'NULL' : $this->fk_unit);
        $sql .= ", " . ((int) $user->id);
        $sql .= ", " . ((int) $user->id);
        $sql .= ", " . (int) $this->fk_multicurrency;
        $sql .= ", '" . $this->db->escape($this->multicurrency_code) . "'";
        $sql .= ", " . price2num($this->multicurrency_subprice);
        $sql .= ", " . price2num($this->multicurrency_total_ht);
        $sql .= ", " . price2num($this->multicurrency_total_tva);
        $sql .= ", " . price2num($this->multicurrency_total_ttc);
        $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 . 'facturedet');
            $this->rowid = $this->id; // For backward compatibility

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

            // If fk_remise_except is defined, the discount is linked to the invoice
            // which flags it as "consumed".
            if ($this->fk_remise_except) {
                $discount = new DiscountAbsolute($this->db);

The type DoliModules\Billing\Model\DiscountAbsolute was not found. Did you mean DiscountAbsolute? If so, make sure to prefix the type with \.

                $result = $discount->fetch($this->fk_remise_except);
                if ($result >= 0) {
                    // Check if discount was found
                    if ($result > 0) {
                        // Check if discount not already affected to another invoice
                        if ($discount->fk_facture_line > 0) {
                            if (empty($noerrorifdiscountalreadylinked)) {
                                $this->error = $langs->trans("ErrorDiscountAlreadyUsed", $discount->id);
                                dol_syslog(get_class($this) . "::insert Error " . $this->error, LOG_ERR);
                                $this->db->rollback();
                                return -3;
                            }
                        } else {
                            $result = $discount->link_to_invoice($this->rowid, 0);
                            if ($result < 0) {
                                $this->error = $discount->error;
                                dol_syslog(get_class($this) . "::insert Error " . $this->error, LOG_ERR);
                                $this->db->rollback();
                                return -3;
                            }
                        }
                    } else {
                        $this->error = $langs->trans("ErrorADiscountThatHasBeenRemovedIsIncluded");
                        dol_syslog(get_class($this) . "::insert Error " . $this->error, LOG_ERR);
                        $this->db->rollback();
                        return -3;
                    }
                } else {
                    $this->error = $discount->error;
                    dol_syslog(get_class($this) . "::insert Error " . $this->error, LOG_ERR);
                    $this->db->rollback();
                    return -3;
                }
            }

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

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