Dolibarr\Code\Reception\Classes\Reception::create()

Complexity

Conditions	33
Paths	> 20000

Size

Total Lines	140
Code Lines	103

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

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

        $now = dol_now();

        $error = 0;

        // Clean parameters
        $this->tracking_number = dol_sanitizeFileName($this->tracking_number);
        if (empty($this->fk_project)) {
            $this->fk_project = 0;
        }
        if (empty($this->weight_units)) {
            $this->weight_units = 0;
        }
        if (empty($this->size_units)) {
            $this->size_units = 0;
        }

        $this->user = $user;

        $this->db->begin();

        $sql = "INSERT INTO " . MAIN_DB_PREFIX . "reception (";
        $sql .= "ref";
        $sql .= ", entity";
        $sql .= ", ref_supplier";
        $sql .= ", date_creation";
        $sql .= ", fk_user_author";
        $sql .= ", date_reception";
        $sql .= ", date_delivery";
        $sql .= ", fk_soc";
        $sql .= ", fk_projet";
        $sql .= ", fk_shipping_method";
        $sql .= ", tracking_number";
        $sql .= ", weight";
        $sql .= ", size";
        $sql .= ", width";
        $sql .= ", height";
        $sql .= ", weight_units";
        $sql .= ", size_units";
        $sql .= ", note_private";
        $sql .= ", note_public";
        $sql .= ", model_pdf";
        $sql .= ", fk_incoterms, location_incoterms";
        $sql .= ") VALUES (";
        $sql .= "'(PROV)'";
        $sql .= ", " . ((int) $conf->entity);
        $sql .= ", " . ($this->ref_supplier ? "'" . $this->db->escape($this->ref_supplier) . "'" : "null");
        $sql .= ", '" . $this->db->idate($now) . "'";
        $sql .= ", " . ((int) $user->id);
        $sql .= ", " . ($this->date_reception > 0 ? "'" . $this->db->idate($this->date_reception) . "'" : "null");
        $sql .= ", " . ($this->date_delivery > 0 ? "'" . $this->db->idate($this->date_delivery) . "'" : "null");
        $sql .= ", " . ((int) $this->socid);
        $sql .= ", " . ((int) $this->fk_project);
        $sql .= ", " . ($this->shipping_method_id > 0 ? ((int) $this->shipping_method_id) : "null");
        $sql .= ", '" . $this->db->escape($this->tracking_number) . "'";
        $sql .= ", " . (is_null($this->weight) ? "NULL" : ((float) $this->weight));
        $sql .= ", " . (is_null($this->trueDepth) ? "NULL" : ((float) $this->trueDepth));
        $sql .= ", " . (is_null($this->trueWidth) ? "NULL" : ((float) $this->trueWidth));
        $sql .= ", " . (is_null($this->trueHeight) ? "NULL" : ((float) $this->trueHeight));
        $sql .= ", " . (is_null($this->weight_units) ? "NULL" : ((float) $this->weight_units));
        $sql .= ", " . (is_null($this->size_units) ? "NULL" : ((float) $this->size_units));
        $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) $this->fk_incoterms;
        $sql .= ", '" . $this->db->escape($this->location_incoterms) . "'";
        $sql .= ")";

        dol_syslog(get_class($this) . "::create", LOG_DEBUG);

        $resql = $this->db->query($sql);

        if ($resql) {
            $this->id = $this->db->last_insert_id(MAIN_DB_PREFIX . "reception");

            $sql = "UPDATE " . MAIN_DB_PREFIX . "reception";
            $sql .= " SET ref = '(PROV" . ((int) $this->id) . ")'";
            $sql .= " WHERE rowid = " . ((int) $this->id);

            dol_syslog(get_class($this) . "::create", LOG_DEBUG);
            if ($this->db->query($sql)) {
                // Insert of lines
                $num = count($this->lines);
                for ($i = 0; $i < $num; $i++) {
                    $this->lines[$i]->fk_reception = $this->id;

                    if (!$this->lines[$i]->create($user) > 0) {
                        $error++;
                    }
                }

                if (!$error && $this->id && $this->origin_id) {
                    $ret = $this->add_object_linked();
                    if (!$ret) {
                        $error++;
                    }
                }

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

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

                if (!$error) {
                    $this->db->commit();
                    return $this->id;
                } else {
                    foreach ($this->errors as $errmsg) {
                        dol_syslog(get_class($this) . "::create " . $errmsg, LOG_ERR);
                        $this->error .= ($this->error ? ', ' . $errmsg : $errmsg);
                    }
                    $this->db->rollback();
                    return -1 * $error;
                }
            } else {
                $error++;
                $this->error = $this->db->lasterror() . " - sql=$sql";
                $this->db->rollback();
                return -2;
            }
        } else {
            $error++;
            $this->error = $this->db->error() . " - sql=$sql";
            $this->db->rollback();
            return -1;
        }