Dolibarr\Code\Contrat\Classes\ContratLigne::update()

Complexity

Conditions	43
Paths	> 20000

Size

Total Lines	182
Code Lines	130

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

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

        $error = 0;

        // Clean parameters
        $this->fk_contrat = (int) $this->fk_contrat;
        $this->fk_product = (int) $this->fk_product;
        $this->statut = (int) $this->statut;
        $this->label = trim($this->label);
        $this->description = trim($this->description);
        $this->vat_src_code = trim($this->vat_src_code);
        $this->tva_tx = trim((string) $this->tva_tx);
        $this->localtax1_tx = trim($this->localtax1_tx);
        $this->localtax2_tx = trim($this->localtax2_tx);
        $this->qty = (float) $this->qty;
        $this->remise_percent = trim((string) $this->remise_percent);
        $this->fk_remise_except = (int) $this->fk_remise_except;
        $this->subprice = (float) price2num($this->subprice);
        $this->price_ht = (float) price2num($this->price_ht);
        $this->info_bits = (int) $this->info_bits;
        $this->fk_user_author = (int) $this->fk_user_author;
        $this->fk_user_ouverture = (int) $this->fk_user_ouverture;
        $this->fk_user_cloture = (int) $this->fk_user_cloture;
        $this->commentaire = trim($this->commentaire);
        $this->rang = (int) $this->rang;
        //if (empty($this->subprice)) $this->subprice = 0;
        if (empty($this->price_ht)) {
            $this->price_ht = 0;
        }
        if (empty($this->total_ht)) {
            $this->total_ht = 0;
        }
        if (empty($this->total_tva)) {
            $this->total_tva = 0;
        }
        if (empty($this->total_ttc)) {
            $this->total_ttc = 0;
        }
        if (empty($this->localtax1_tx)) {
            $this->localtax1_tx = 0;
        }
        if (empty($this->localtax2_tx)) {
            $this->localtax2_tx = 0;
        }
        if (empty($this->remise_percent)) {
            $this->remise_percent = 0;
        }

        // 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.
        $localtaxes_type = getLocalTaxesFromRate($this->tva_tx, 0, $this->thirdparty, $mysoc);

        $tabprice = calcul_price_total($this->qty, $this->price_ht, $this->remise_percent, $this->tva_tx, $this->localtax1_tx, $this->localtax2_tx, 0, 'HT', 0, 1, $mysoc, $localtaxes_type);
        $this->total_ht  = $tabprice[0];
        $this->total_tva = $tabprice[1];
        $this->total_ttc = $tabprice[2];
        $this->total_localtax1 = $tabprice[9];
        $this->total_localtax2 = $tabprice[10];

        if (empty($this->pa_ht)) {
            $this->pa_ht = 0;
        }

        // if buy price not defined, define buyprice as configured in margin admin
        if ($this->pa_ht == 0) {
            $result = $this->defineBuyPrice($this->subprice, $this->remise_percent, $this->fk_product);
            if ($result < 0) {
                return -1;
            } else {
                $this->pa_ht = $result;
            }
        }

        // $this->oldcopy should have been set by the caller of update (here properties were already modified)
        if (empty($this->oldcopy)) {
            dol_syslog("this->oldcopy should have been set by the caller of update (here properties were already modified)", LOG_WARNING);
            $this->oldcopy = dol_clone($this, 2);
        }

        $this->db->begin();

        // Update request
        $sql = "UPDATE " . MAIN_DB_PREFIX . "contratdet SET";
        $sql .= " fk_contrat = " . ((int) $this->fk_contrat) . ",";
        $sql .= " fk_product = " . ($this->fk_product ? ((int) $this->fk_product) : 'null') . ",";
        $sql .= " statut = " . ((int) $this->statut) . ",";
        $sql .= " label = '" . $this->db->escape($this->label) . "',";
        $sql .= " description = '" . $this->db->escape($this->description) . "',";
        $sql .= " date_commande = " . ($this->date_commande != '' ? "'" . $this->db->idate($this->date_commande) . "'" : "null") . ",";
        $sql .= " date_ouverture_prevue = " . ($this->date_start != '' ? "'" . $this->db->idate($this->date_start) . "'" : "null") . ",";
        $sql .= " date_ouverture = " . ($this->date_start_real != '' ? "'" . $this->db->idate($this->date_start_real) . "'" : "null") . ",";
        $sql .= " date_fin_validite = " . ($this->date_end != '' ? "'" . $this->db->idate($this->date_end) . "'" : "null") . ",";
        $sql .= " date_cloture = " . ($this->date_end_real != '' ? "'" . $this->db->idate($this->date_end_real) . "'" : "null") . ",";
        $sql .= " vat_src_code = '" . $this->db->escape($this->vat_src_code) . "',";
        $sql .= " tva_tx = " . price2num($this->tva_tx) . ",";
        $sql .= " localtax1_tx = " . price2num($this->localtax1_tx) . ",";
        $sql .= " localtax2_tx = " . price2num($this->localtax2_tx) . ",";
        $sql .= " qty = " . price2num($this->qty) . ",";
        $sql .= " remise_percent = " . price2num($this->remise_percent) . ",";
        $sql .= " remise = " . ($this->remise ? price2num($this->remise) : "null") . ",";
        $sql .= " fk_remise_except = " . ($this->fk_remise_except > 0 ? $this->fk_remise_except : "null") . ",";
        $sql .= " subprice = " . ($this->subprice != '' ? $this->subprice : "null") . ",";
        $sql .= " price_ht = " . ($this->price_ht != '' ? $this->price_ht : "null") . ",";
        $sql .= " total_ht = " . $this->total_ht . ",";
        $sql .= " total_tva = " . $this->total_tva . ",";
        $sql .= " total_localtax1 = " . $this->total_localtax1 . ",";
        $sql .= " total_localtax2 = " . $this->total_localtax2 . ",";
        $sql .= " total_ttc = " . $this->total_ttc . ",";
        $sql .= " fk_product_fournisseur_price = " . (!empty($this->fk_fournprice) ? $this->fk_fournprice : "NULL") . ",";
        $sql .= " buy_price_ht = '" . price2num($this->pa_ht) . "',";
        $sql .= " info_bits = '" . $this->db->escape($this->info_bits) . "',";
        $sql .= " fk_user_author = " . ($this->fk_user_author >= 0 ? $this->fk_user_author : "NULL") . ",";
        $sql .= " fk_user_ouverture = " . ($this->fk_user_ouverture > 0 ? $this->fk_user_ouverture : "NULL") . ",";
        $sql .= " fk_user_cloture = " . ($this->fk_user_cloture > 0 ? $this->fk_user_cloture : "NULL") . ",";
        $sql .= " commentaire = '" . $this->db->escape($this->commentaire) . "',";
        $sql .= " fk_unit = " . (!$this->fk_unit ? 'NULL' : $this->fk_unit) . ",";
        $sql .= " rang = " . (empty($this->rang) ? '0' : (int) $this->rang);
        $sql .= " WHERE rowid = " . ((int) $this->id);

        dol_syslog(get_only_class($this) . "::update", LOG_DEBUG);
        $resql = $this->db->query($sql);
        if (!$resql) {
            $this->error = "Error " . $this->db->lasterror();
            $error++;
        }

        if (!$error) { // For avoid conflicts if trigger used
            $result = $this->insertExtraFields();
            if ($result < 0) {
                $error++;
            }
        }

        // If we change a planned date (start or end) of one contract line, sync dates for all other services too
        if (!$error && getDolGlobalString('CONTRACT_SYNC_PLANNED_DATE_OF_SERVICES')) {
            dol_syslog(get_only_class($this) . "::update CONTRACT_SYNC_PLANNED_DATE_OF_SERVICES is on so we update date for all lines", LOG_DEBUG);

            if ($this->date_start != $this->oldcopy->date_start) {
                $sql = 'UPDATE ' . MAIN_DB_PREFIX . 'contratdet SET';
                $sql .= " date_ouverture_prevue = " . ($this->date_start != '' ? "'" . $this->db->idate($this->date_start) . "'" : "null");
                $sql .= " WHERE fk_contrat = " . ((int) $this->fk_contrat);

                $resql = $this->db->query($sql);
                if (!$resql) {
                    $error++;
                    $this->error = "Error " . $this->db->lasterror();
                }
            }
            if ($this->date_end != $this->oldcopy->date_end) {
                $sql = 'UPDATE ' . MAIN_DB_PREFIX . 'contratdet SET';
                $sql .= " date_fin_validite = " . ($this->date_end != '' ? "'" . $this->db->idate($this->date_end) . "'" : "null");
                $sql .= " WHERE fk_contrat = " . ((int) $this->fk_contrat);

                $resql = $this->db->query($sql);
                if (!$resql) {
                    $error++;
                    $this->error = "Error " . $this->db->lasterror();
                }
            }
        }

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

        if (!$error) {
            $this->db->commit();
            return 1;
        } else {
            $this->db->rollback();
            $this->errors[] = $this->error;
            return -1;
        }