FactureRec::addline()

Complexity

Conditions	23
Paths	> 20000

Size

Total Lines	174
Code Lines	135

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public function addline($desc, $pu_ht, $qty, $txtva, $txlocaltax1 = 0, $txlocaltax2 = 0, $fk_product = 0, $remise_percent = 0, $price_base_type = 'HT', $info_bits = 0, $fk_remise_except = 0, $pu_ttc = 0, $type = 0, $rang = -1, $special_code = 0, $label = '', $fk_unit = null, $pu_ht_devise = 0, $date_start_fill = 0, $date_end_fill = 0, $fk_fournprice = null, $pa_ht = 0, $fk_parent_line = 0)
    {
        global $mysoc;

        $facid = $this->id;

        dol_syslog(get_class($this) . "::addline facid=$facid,desc=$desc,pu_ht=$pu_ht,qty=$qty,txtva=$txtva,txlocaltax1=$txlocaltax1,txlocaltax2=$txlocaltax2,fk_product=$fk_product,remise_percent=$remise_percent,info_bits=$info_bits,fk_remise_except=$fk_remise_except,price_base_type=$price_base_type,pu_ttc=$pu_ttc,type=$type,fk_unit=$fk_unit,pu_ht_devise=$pu_ht_devise,date_start_fill=$date_start_fill,date_end_fill=$date_end_fill,pa_ht=$pa_ht", LOG_DEBUG);
        include_once DOL_DOCUMENT_ROOT . '/core/lib/price.lib.php';

        // Check parameters
        if ($type < 0) {
            return -1;
        }

        $localtaxes_type = getLocalTaxesFromRate($txtva, 0, $this->thirdparty, $mysoc);

        // Clean vat code
        $reg = array();
        $vat_src_code = '';
        if (preg_match('/\((.*)\)/', (string) $txtva, $reg)) {
            $vat_src_code = $reg[1];
            $txtva = preg_replace('/\s*\(.*\)/', '', (string) $txtva); // Remove code from vatrate.
        }


        // Clean parameters
        $remise_percent = price2num($remise_percent);
        if (empty($remise_percent)) {
            $remise_percent = 0;
        }
        $qty = price2num($qty);
        $pu_ht = price2num($pu_ht);
        $pu_ttc = price2num($pu_ttc);
        if (!preg_match('/\((.*)\)/', $txtva)) {
            $txtva = price2num($txtva); // $txtva can have format '5.0(XXX)' or '5'
        }
        $txlocaltax1 = price2num($txlocaltax1);
        $txlocaltax2 = price2num($txlocaltax2);
        if (empty($txtva)) {
            $txtva = 0;
        }
        if (empty($txlocaltax1)) {
            $txlocaltax1 = 0;
        }
        if (empty($txlocaltax2)) {
            $txlocaltax2 = 0;
        }
        if (empty($info_bits)) {
            $info_bits = 0;
        }

        if ($price_base_type == 'HT') {
            $pu = $pu_ht;
        } else {
            $pu = $pu_ttc;
        }

        // Calcul du total TTC et de la TVA pour la ligne a partir de
        // qty, pu, remise_percent et txtva
        // TRES IMPORTANT: C'est au moment de l'insertion ligne qu'on doit stocker
        // la part ht, tva et ttc, et ce au niveau de la ligne qui a son propre taux tva.

        $tabprice = calcul_price_total($qty, $pu, $remise_percent, $txtva, $txlocaltax1, $txlocaltax2, 0, $price_base_type, $info_bits, $type, $mysoc, $localtaxes_type, 100, $this->multicurrency_tx, $pu_ht_devise);
        $total_ht  = $tabprice[0];
        $total_tva = $tabprice[1];
        $total_ttc = $tabprice[2];
        $total_localtax1 = $tabprice[9];
        $total_localtax2 = $tabprice[10];
        $pu_ht = $tabprice[3];

        // MultiCurrency
        $multicurrency_total_ht  = $tabprice[16];
        $multicurrency_total_tva = $tabprice[17];
        $multicurrency_total_ttc = $tabprice[18];
        $pu_ht_devise = $tabprice[19];

        $product_type = $type;
        if ($fk_product) {
            $product = new Product($this->db);
            $result = $product->fetch($fk_product);
            $product_type = $product->type;
        }

        if (empty($fk_parent_line) || $fk_parent_line < 0) {
            $fk_parent_line = 0;
        }

        // Rank to use
        $ranktouse = $rang;
        if ($ranktouse == -1) {
            $rangmax = $this->line_max(0);
            $ranktouse = $rangmax + 1;
        }

        $sql = "INSERT INTO " . MAIN_DB_PREFIX . "facturedet_rec (";
        $sql .= "fk_facture";
        $sql .= ", fk_parent_line";
        $sql .= ", label";
        $sql .= ", description";
        $sql .= ", price";
        $sql .= ", qty";
        $sql .= ", tva_tx";
        $sql .= ", vat_src_code";
        $sql .= ", localtax1_tx";
        $sql .= ", localtax1_type";
        $sql .= ", localtax2_tx";
        $sql .= ", localtax2_type";
        $sql .= ", fk_product";
        $sql .= ", product_type";
        $sql .= ", remise_percent";
        $sql .= ", subprice";
        $sql .= ", remise";
        $sql .= ", total_ht";
        $sql .= ", total_tva";
        $sql .= ", total_localtax1";
        $sql .= ", total_localtax2";
        $sql .= ", total_ttc";
        $sql .= ", date_start_fill";
        $sql .= ", date_end_fill";
        $sql .= ", fk_product_fournisseur_price";
        $sql .= ", buy_price_ht";
        $sql .= ", info_bits";
        $sql .= ", rang";
        $sql .= ", special_code";
        $sql .= ", fk_unit";
        $sql .= ', fk_multicurrency, multicurrency_code, multicurrency_subprice, multicurrency_total_ht, multicurrency_total_tva, multicurrency_total_ttc';
        $sql .= ") VALUES (";
        $sql .= " " . ((int) $facid);
        $sql .= ", " . ($fk_parent_line > 0 ? ((int) $fk_parent_line) : "null");
        $sql .= ", " . (!empty($label) ? "'" . $this->db->escape($label) . "'" : "null");
        $sql .= ", '" . $this->db->escape($desc) . "'";
        $sql .= ", " . price2num($pu_ht);
        $sql .= ", " . price2num($qty);
        $sql .= ", " . price2num($txtva);
        $sql .= ", '" . $this->db->escape($vat_src_code) . "'";
        $sql .= ", " . price2num($txlocaltax1);
        $sql .= ", '" . $this->db->escape(isset($localtaxes_type[0]) ? $localtaxes_type[0] : '') . "'";
        $sql .= ", " . price2num($txlocaltax2);
        $sql .= ", '" . $this->db->escape(isset($localtaxes_type[2]) ? $localtaxes_type[2] : '') . "'";
        $sql .= ", " . (!empty($fk_product) ? "'" . $this->db->escape($fk_product) . "'" : "null");
        $sql .= ", " . ((int) $product_type);
        $sql .= ", " . price2num($remise_percent);
        $sql .= ", " . price2num($pu_ht);
        $sql .= ", null";
        $sql .= ", " . price2num($total_ht);
        $sql .= ", " . price2num($total_tva);
        $sql .= ", " . price2num($total_localtax1);
        $sql .= ", " . price2num($total_localtax2);
        $sql .= ", " . price2num($total_ttc);
        $sql .= ", " . (int) $date_start_fill;
        $sql .= ", " . (int) $date_end_fill;
        $sql .= ", " . ($fk_fournprice > 0 ? $fk_fournprice : 'null');
        $sql .= ", " . ($pa_ht ? price2num($pa_ht) : 0);
        $sql .= ", " . ((int) $info_bits);
        $sql .= ", " . ((int) $ranktouse);
        $sql .= ", " . ((int) $special_code);
        $sql .= ", " . ($fk_unit ? ((int) $fk_unit) : "null");
        $sql .= ", " . (int) $this->fk_multicurrency;
        $sql .= ", '" . $this->db->escape($this->multicurrency_code) . "'";
        $sql .= ", " . price2num($pu_ht_devise, 'CU');
        $sql .= ", " . price2num($multicurrency_total_ht, 'CT');
        $sql .= ", " . price2num($multicurrency_total_tva, 'CT');
        $sql .= ", " . price2num($multicurrency_total_ttc, 'CT');
        $sql .= ")";

        dol_syslog(get_class($this) . "::addline", LOG_DEBUG);
        if ($this->db->query($sql)) {
            $lineId = $this->db->last_insert_id(MAIN_DB_PREFIX . "facturedet_rec");
            $this->id = $facid;
            $this->update_price(1);
            return $lineId;
        } else {
            $this->error = $this->db->lasterror();
            return -1;
        }