FactureFournisseurRec::addline()

Complexity

Conditions	26
Paths	> 20000

Size

Total Lines	163
Code Lines	132

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public function addline($fk_product, $ref, $label, $desc, $pu_ht, $pu_ttc, $qty, $remise_percent, $txtva, $txlocaltax1 = 0, $txlocaltax2 = 0, $price_base_type = 'HT', $type = 0, $date_start = 0, $date_end = 0, $info_bits = 0, $special_code = 0, $rang = -1, $fk_unit = null, $pu_ht_devise = 0)
    {
        global $mysoc, $user;

        include_once DOL_DOCUMENT_ROOT . '/core/lib/price.lib.php';

        $facid = $this->id; //Supplier invoice template ID linked to

        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,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,date_end_fill=$date_end", LOG_DEBUG);

        // Check if object of the line is product or service
        if ($type < 0) {
            return -1;
        }

        if ($this->suspended == self::STATUS_NOTSUSPENDED) {
            $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 into vatrate.
            }

            // Clean parameters
            $fk_product = empty($fk_product) ? 0 : $fk_product;
            $label = empty($label) ? '' : $label;
            $remise_percent = empty($remise_percent) ? 0 : price2num($remise_percent);
            $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);
            $txtva = !empty($txtva) ? $txtva : 0;
            $txlocaltax1 = !empty($txlocaltax1) ? $txlocaltax1 : 0;
            $txlocaltax2 = !empty($txlocaltax2) ? $txlocaltax2 : 0;
            $info_bits = !empty($info_bits) ? $info_bits : 0;
            $info_bits = !empty($info_bits) ? $info_bits : 0;
            $pu = $price_base_type == 'HT' ? $pu_ht : $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];

            $this->db->begin();
            $product_type = $type;
            if ($fk_product) {
                $product = new Product($this->db);
                $result = $product->fetch($fk_product);
                if ($result < 0) {
                    return -1;
                }
                $product_type = $product->type;
                if (empty($label)) {
                    $label = $product->label;
                }
            }

            $sql = 'INSERT INTO ' . MAIN_DB_PREFIX . 'facture_fourn_det_rec (';
            $sql .= 'fk_facture_fourn';
            $sql .= ', fk_product';
            $sql .= ', ref';
            $sql .= ', label';
            $sql .= ', description';
            $sql .= ', pu_ht';
            $sql .= ', pu_ttc';
            $sql .= ', qty';
            $sql .= ', remise_percent';
            $sql .= ', fk_remise_except';
            $sql .= ', vat_src_code';
            $sql .= ', tva_tx';
            $sql .= ', localtax1_tx';
            $sql .= ', localtax1_type';
            $sql .= ', localtax2_tx';
            $sql .= ', localtax2_type';
            $sql .= ', total_ht';
            $sql .= ', total_tva';
            $sql .= ', total_localtax1';
            $sql .= ', total_localtax2';
            $sql .= ', total_ttc';
            $sql .= ', product_type';
            $sql .= ', date_start';
            $sql .= ', date_end';
            $sql .= ', info_bits';
            $sql .= ', special_code';
            $sql .= ', rang';
            $sql .= ', fk_unit';
            $sql .= ', fk_user_author';
            $sql .= ', fk_multicurrency, multicurrency_code, multicurrency_subprice, multicurrency_total_ht, multicurrency_total_tva, multicurrency_total_ttc';
            $sql .= ') VALUES (';
            $sql .= ' ' . (int) $facid;   // source supplier invoice id
            $sql .= ', ' . (!empty($fk_product) ? "'" . $this->db->escape($fk_product) . "'" : 'null');
            $sql .= ', ' . (!empty($ref) ? "'" . $this->db->escape($ref) . "'" : 'null');
            $sql .= ', ' . (!empty($label) ? "'" . $this->db->escape($label) . "'" : 'null');
            $sql .= ", '" . $this->db->escape($desc) . "'";
            $sql .= ', ' . price2num($pu_ht);
            $sql .= ', ' . price2num($pu_ttc);
            $sql .= ', ' . price2num($qty);
            $sql .= ', ' . price2num($remise_percent);
            $sql .= ', null';
            $sql .= ", '" . $this->db->escape($vat_src_code) . "'";
            $sql .= ', ' . price2num($txtva);
            $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 .= ', ' . price2num($total_ht);
            $sql .= ', ' . price2num($total_tva);
            $sql .= ', ' . price2num($total_localtax1);
            $sql .= ', ' . price2num($total_localtax2);
            $sql .= ', ' . price2num($total_ttc);
            $sql .= ', ' . (int) $product_type;
            $sql .= ', ' . ($date_start > 0 ? (int) $date_start : 'NULL');
            $sql .= ', ' . ($date_end > 0 ? (int) $date_end : 'NULL');
            $sql .= ', ' . (int) $info_bits;
            $sql .= ', ' . (int) $special_code;
            $sql .= ', ' . (int) $rang;
            $sql .= ', ' . ($fk_unit ? (int) $fk_unit : 'NULL');
            $sql .= ', ' . (int) $user->id;
            $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 . 'facture_fourn_det_rec');
                $this->update_price();
                $this->id = $facid;
                $this->db->commit();
                return $lineId;
            } else {
                $this->db->rollback();
                $this->error = $this->db->lasterror();

                return -1;
            }
        } else {
            $this->error = 'Recurring Invoice is suspended. adding lines not allowed.';

            return -1;
        }