Dolibarr\Code\Fourn\Classes\FactureFournisseurRec::create()

Complexity

Conditions	50
Paths	> 20000

Size

Total Lines	217
Code Lines	168

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public function create($user, $facFournId, $notrigger = 0)
    {
        global $conf;

        $error = 0;
        $now = dol_now();

        // Clean parameters
        $this->titre = empty($this->titre) ? '' : $this->titre; // deprecated

The property Dolibarr\Code\Fourn\Classes\FactureFournisseurRec::$titre has been deprecated: Use $title

        $this->title = empty($this->title) ? '' : $this->title;
        $keyforref = $this->table_ref_field;
        $this->ref = $this->$keyforref;
        $this->ref_supplier = empty($this->ref_supplier) ? '' : $this->ref_supplier;
        $this->usenewprice = empty($this->usenewprice) ? 0 : $this->usenewprice;
        $this->suspended = empty($this->suspended) ? 0 : $this->suspended;
        // No frequency defined then no next date to execution
        if (empty($this->frequency)) {
            $this->frequency = 0;
            $this->date_when = null;
        }
        $this->frequency = abs($this->frequency);
        $this->nb_gen_done = 0;
        $this->nb_gen_max = empty($this->nb_gen_max) ? 0 : $this->nb_gen_max;
        $this->auto_validate = empty($this->auto_validate) ? 0 : $this->auto_validate;
        $this->generate_pdf = empty($this->generate_pdf) ? 0 : $this->generate_pdf;

        $this->db->begin();

        // On charge la facture fournisseur depuis laquelle on crée la facture fournisseur modèle
        $facfourn_src = new FactureFournisseur($this->db);
        $result = $facfourn_src->fetch($facFournId);
        if ($result > 0) {
            $sql = 'INSERT INTO ' . MAIN_DB_PREFIX . 'facture_fourn_rec (';
            $sql .= 'titre';
            $sql .= ", subtype";
            $sql .= ', ref_supplier';
            $sql .= ', entity';
            $sql .= ', fk_soc';
            $sql .= ', datec';
            $sql .= ', suspended';
            $sql .= ', libelle';
            $sql .= ', total_ttc';
            $sql .= ', fk_user_author';
            $sql .= ', fk_projet';
            $sql .= ', fk_account';
            $sql .= ', fk_cond_reglement';
            $sql .= ', fk_mode_reglement';
            $sql .= ', date_lim_reglement';
            $sql .= ', note_private';
            $sql .= ', note_public';
            $sql .= ', modelpdf';
            $sql .= ', fk_multicurrency';
            $sql .= ', multicurrency_code';
            $sql .= ', multicurrency_tx';
            $sql .= ', usenewprice';
            $sql .= ', frequency';
            $sql .= ', unit_frequency';
            $sql .= ', date_when';
            $sql .= ', date_last_gen';
            $sql .= ', nb_gen_done';
            $sql .= ', nb_gen_max';
            $sql .= ', auto_validate';
            $sql .= ', generate_pdf';
            $sql .= ') VALUES (';
            $sql .= "'" . $this->db->escape($this->title) . "'";
            $sql .= ", " . ($this->subtype ? "'" . $this->db->escape($this->subtype) . "'" : "null");
            $sql .= ", '" . $this->db->escape($this->ref_supplier) . "'";
            $sql .= ", " . ((int) $conf->entity);
            $sql .= ", " . ((int) $facfourn_src->socid);
            $sql .= ", '" . $this->db->idate($now) . "'";
            $sql .= ", " . ((int) $this->suspended);
            $sql .= ", '" . $this->db->escape($this->libelle) . "'";

The property Dolibarr\Code\Fourn\Classes\FactureFournisseurRec::$libelle has been deprecated: Use $label

            $sql .= ", " . (!empty($facfourn_src->total_ttc) ? (float) $facfourn_src->total_ttc : '0');                              // amount
            $sql .= ", " . ((int) $user->id);
            $sql .= ", " . (!empty($this->fk_project) ? ((int) $this->fk_project) : 'NULL');
            $sql .= ", " . (!empty($facfourn_src->fk_account) ? ((int) $facfourn_src->fk_account) : 'NULL');
            $sql .= ", " . ($this->cond_reglement_id > 0 ? (int) $this->cond_reglement_id : 'NULL');
            $sql .= ", " . ($this->mode_reglement_id > 0 ? (int) $this->mode_reglement_id : 'NULL');
            $sql .= ", " . ($facfourn_src->date_echeance > 0 ? "'" . $this->db->idate($facfourn_src->date_echeance) . "'" : 'NULL');      // date_lim_reglement
            $sql .= ", " . (!empty($this->note_private) ? "'" . $this->db->escape($this->note_private) . "'" : 'NULL');
            $sql .= ", " . (!empty($this->note_public) ? "'" . $this->db->escape($this->note_public) . "'" : 'NULL');
            $sql .= ", " . (!empty($this->model_pdf) ? "'" . $this->db->escape($this->model_pdf) . "'" : 'NULL');
            $sql .= ", " . (int) $facfourn_src->fk_multicurrency;
            $sql .= ", '" . $this->db->escape($facfourn_src->multicurrency_code) . "'";
            $sql .= ", " . (float) $facfourn_src->multicurrency_tx;
            $sql .= ", " . (int) $this->usenewprice;
            $sql .= ", " . (int) $this->frequency;
            $sql .= ", '" . $this->db->escape($this->unit_frequency) . "'";
            $sql .= ", " . (!empty($this->date_when) ? "'" . $this->db->idate($this->date_when) . "'" : 'NULL');
            $sql .= ", " . (!empty($this->date_last_gen) ? "'" . $this->db->idate($this->date_last_gen) . "'" : 'NULL');
            $sql .= ", " . (int) $this->nb_gen_done;
            $sql .= ", " . (int) $this->nb_gen_max;
            $sql .= ", " . (int) $this->auto_validate;
            $sql .= ", " . (int) $this->generate_pdf;
            $sql .= ')';

            if ($this->db->query($sql)) {
                $this->id = $this->db->last_insert_id(MAIN_DB_PREFIX . 'facture_fourn_rec');

                // Fields used into addline later
                $this->fk_multicurrency = $facfourn_src->fk_multicurrency;

                $this->multicurrency_code = $facfourn_src->multicurrency_code;
                $this->multicurrency_tx = $facfourn_src->multicurrency_tx;

                // Add lines
                $num = count($facfourn_src->lines);
                for ($i = 0; $i < $num; $i++) {
                    $tva_tx = $facfourn_src->lines[$i]->tva_tx;
                    if (!empty($facfourn_src->lines[$i]->vat_src_code) && !preg_match('/\(/', (string) $tva_tx)) {
                        $tva_tx .= ' (' . $facfourn_src->lines[$i]->vat_src_code . ')';
                    }

                    $result_insert = $this->addline(
                        $facfourn_src->lines[$i]->fk_product,
                        $facfourn_src->lines[$i]->ref_supplier,
                        $facfourn_src->lines[$i]->product_label,
                        $facfourn_src->lines[$i]->desc ? $facfourn_src->lines[$i]->desc : $facfourn_src->lines[$i]->description,
                        $facfourn_src->lines[$i]->pu_ht,
                        $facfourn_src->lines[$i]->pu_ttc,
                        $facfourn_src->lines[$i]->qty,
                        $facfourn_src->lines[$i]->remise_percent,
                        $tva_tx,
                        $facfourn_src->lines[$i]->localtax1_tx,
                        $facfourn_src->lines[$i]->localtax2_tx,
                        'HT',
                        $facfourn_src->lines[$i]->product_type,
                        $facfourn_src->lines[$i]->date_start,
                        $facfourn_src->lines[$i]->date_end,
                        $facfourn_src->lines[$i]->info_bits,
                        $facfourn_src->lines[$i]->special_code,
                        $facfourn_src->lines[$i]->rang,
                        $facfourn_src->lines[$i]->fk_unit
                    );

                    if ($result_insert < 0) {
                        $error++;
                    } else {
                        $objectline = new FactureFournisseurLigneRec($this->db);

                        $result2 = $objectline->fetch($result_insert);
                        if ($result2 > 0) {
                            // Extrafields
                            if (method_exists($facfourn_src->lines[$i], 'fetch_optionals')) {
                                $facfourn_src->lines[$i]->fetch_optionals($facfourn_src->lines[$i]->id);
                                $objectline->array_options = $facfourn_src->lines[$i]->array_options;
                            }

                            $result = $objectline->insertExtraFields();
                            if ($result < 0) {
                                $error++;
                            }
                        } elseif ($result2 < 0) {
                            $this->errors[] = $objectline->error;
                            $error++;
                        }
                    }
                }

                if (!empty($this->linkedObjectsIds) && empty($this->linked_objects)) {  // To use new linkedObjectsIds instead of old linked_objects
                    $this->linked_objects = $this->linkedObjectsIds; // TODO Replace linked_objects with linkedObjectsIds
                }

                // Add object linked
                if (!$error && $this->id && !empty($this->linked_objects) && is_array($this->linked_objects)) {
                    foreach ($this->linked_objects as $origin => $tmp_origin_id) {
                        if (is_array($tmp_origin_id)) {       // New behaviour, if linked_object can have several links per type, so is something like array('contract'=>array(id1, id2, ...))
                            foreach ($tmp_origin_id as $origin_id) {
                                $ret = $this->add_object_linked($origin, $origin_id);
                                if (!$ret) {
                                    $this->error = $this->db->lasterror();
                                    $error++;
                                }
                            }
                        } else { // Old behaviour, if linked_object has only one link per type, so is something like array('contract'=>id1))
                            $origin_id = $tmp_origin_id;
                            $ret = $this->add_object_linked($origin, $origin_id);
                            if (!$ret) {
                                $this->error = $this->db->lasterror();
                                $error++;
                            }
                        }
                    }
                }

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

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

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