DoliModules\Accounting\Model\AccountingAccount::create()

Complexity

Conditions	20
Paths	> 20000

Size

Total Lines	92
Code Lines	59

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

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

        // Clean parameters
        if (isset($this->fk_pcg_version)) {
            $this->fk_pcg_version = trim($this->fk_pcg_version);
        }
        if (isset($this->pcg_type)) {
            $this->pcg_type = trim($this->pcg_type);
        }
        if (isset($this->account_number)) {
            $this->account_number = trim($this->account_number);
        }
        if (isset($this->label)) {
            $this->label = trim($this->label);
        }
        if (isset($this->labelshort)) {
            $this->labelshort = trim($this->labelshort);
        }

        if (empty($this->pcg_type) || $this->pcg_type == '-1') {
            $this->pcg_type = 'XXXXXX';
        }
        // Check parameters
        // Put here code to add control on parameters values

        // Insert request
        $sql = "INSERT INTO " . MAIN_DB_PREFIX . "accounting_account(";
        $sql .= "datec";
        $sql .= ", entity";
        $sql .= ", fk_pcg_version";
        $sql .= ", pcg_type";
        $sql .= ", account_number";
        $sql .= ", account_parent";
        $sql .= ", label";
        $sql .= ", labelshort";
        $sql .= ", fk_accounting_category";
        $sql .= ", fk_user_author";
        $sql .= ", active";
        $sql .= ", reconcilable";
        $sql .= ") VALUES (";
        $sql .= " '" . $this->db->idate($now) . "'";
        $sql .= ", " . ((int) $conf->entity);
        $sql .= ", " . (empty($this->fk_pcg_version) ? 'NULL' : "'" . $this->db->escape($this->fk_pcg_version) . "'");
        $sql .= ", " . (empty($this->pcg_type) ? 'NULL' : "'" . $this->db->escape($this->pcg_type) . "'");
        $sql .= ", " . (empty($this->account_number) ? 'NULL' : "'" . $this->db->escape($this->account_number) . "'");
        $sql .= ", " . (empty($this->account_parent) ? 0 : (int) $this->account_parent);
        $sql .= ", " . (empty($this->label) ? "''" : "'" . $this->db->escape($this->label) . "'");
        $sql .= ", " . (empty($this->labelshort) ? "''" : "'" . $this->db->escape($this->labelshort) . "'");
        $sql .= ", " . (empty($this->account_category) ? 0 : (int) $this->account_category);
        $sql .= ", " . ((int) $user->id);
        $sql .= ", " . (int) $this->active;
        $sql .= ", " . (int) $this->reconcilable;
        $sql .= ")";

        $this->db->begin();

        dol_syslog(get_class($this) . "::create", LOG_DEBUG);
        $resql = $this->db->query($sql);
        if (!$resql) {
            $error++;
            $this->errors[] = "Error " . $this->db->lasterror();
        }

        if (!$error) {
            $this->id = $this->db->last_insert_id(MAIN_DB_PREFIX . "accounting_account");

            // Uncomment this and change MYOBJECT to your own tag if you
            // want this action to call a trigger.
            //if (! $error && ! $notrigger) {

            // // Call triggers
            // $result=$this->call_trigger('MYOBJECT_CREATE',$user);
            // if ($result < 0) $error++;
            // // End call triggers
            //}
        }

        // Commit or rollback
        if ($error) {
            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 {
            $this->db->commit();
            return $this->id;
        }