Dolibarr\Code\Accountancy\Classes\BookKeeping::update()

Complexity

Conditions	42
Paths	> 20000

Size

Total Lines	125
Code Lines	79

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public function update(User $user, $notrigger = 0, $mode = '')
    {
        global $langs;
        $error = 0;

        dol_syslog(__METHOD__, LOG_DEBUG);

        // Clean parameters
        if (isset($this->doc_type)) {
            $this->doc_type = trim($this->doc_type);
        }
        if (isset($this->doc_ref)) {
            $this->doc_ref = trim($this->doc_ref);
        }
        if (isset($this->fk_doc)) {
            $this->fk_doc = (int) $this->fk_doc;
        }
        if (isset($this->fk_docdet)) {
            $this->fk_docdet = (int) $this->fk_docdet;
        }
        if (isset($this->thirdparty_code)) {
            $this->thirdparty_code = trim($this->thirdparty_code);
        }
        if (isset($this->subledger_account)) {
            $this->subledger_account = trim($this->subledger_account);
        }
        if (isset($this->subledger_label)) {
            $this->subledger_label = trim($this->subledger_label);
        }
        if (isset($this->numero_compte)) {
            $this->numero_compte = trim($this->numero_compte);
        }
        if (isset($this->label_compte)) {
            $this->label_compte = trim($this->label_compte);
        }
        if (isset($this->label_operation)) {
            $this->label_operation = trim($this->label_operation);
        }
        if (isset($this->sens)) {
            $this->sens = trim($this->sens);
        }
        if (isset($this->import_key)) {
            $this->import_key = trim($this->import_key);
        }
        if (isset($this->code_journal)) {
            $this->code_journal = trim($this->code_journal);
        }
        if (isset($this->journal_label)) {
            $this->journal_label = trim($this->journal_label);
        }
        if (isset($this->piece_num)) {
            $this->piece_num = (int) $this->piece_num;
        }

        $result = $this->canModifyBookkeeping($this->id, $mode);
        if ($result < 0) {
            return -1;
        } elseif ($result == 0) {
            if (getDolGlobalString('ACCOUNTANCY_FISCAL_PERIOD_MODE') == 'blockedonclosed') {
                $this->errors[] = $langs->trans('ErrorBookkeepingDocDateIsOnAClosedFiscalPeriod');
            } else {
                $this->errors[] = $langs->trans('ErrorBookkeepingDocDateNotOnActiveFiscalPeriod');
            }
            return -1;
        }

        $this->debit = (float) price2num($this->debit, 'MT');
        $this->credit = (float) price2num($this->credit, 'MT');
        $this->montant = (float) price2num($this->montant, 'MT');

        // Check parameters
        // Put here code to add a control on parameters values

        // Update request
        $sql = 'UPDATE ' . MAIN_DB_PREFIX . $this->table_element . $mode . ' SET';
        $sql .= ' doc_date = ' . (!isset($this->doc_date) || dol_strlen($this->doc_date) != 0 ? "'" . $this->db->idate($this->doc_date) . "'" : 'null') . ',';
        $sql .= ' doc_type = ' . (isset($this->doc_type) ? "'" . $this->db->escape($this->doc_type) . "'" : "null") . ',';
        $sql .= ' doc_ref = ' . (isset($this->doc_ref) ? "'" . $this->db->escape($this->doc_ref) . "'" : "null") . ',';
        $sql .= ' fk_doc = ' . (isset($this->fk_doc) ? $this->fk_doc : "null") . ',';
        $sql .= ' fk_docdet = ' . (isset($this->fk_docdet) ? $this->fk_docdet : "null") . ',';
        $sql .= ' thirdparty_code = ' . (isset($this->thirdparty_code) ? "'" . $this->db->escape($this->thirdparty_code) . "'" : "null") . ',';
        $sql .= ' subledger_account = ' . (isset($this->subledger_account) ? "'" . $this->db->escape($this->subledger_account) . "'" : "null") . ',';
        $sql .= ' subledger_label = ' . (isset($this->subledger_label) ? "'" . $this->db->escape($this->subledger_label) . "'" : "null") . ',';
        $sql .= ' numero_compte = ' . (isset($this->numero_compte) ? "'" . $this->db->escape($this->numero_compte) . "'" : "null") . ',';
        $sql .= ' label_compte = ' . (isset($this->label_compte) ? "'" . $this->db->escape($this->label_compte) . "'" : "null") . ',';
        $sql .= ' label_operation = ' . (isset($this->label_operation) ? "'" . $this->db->escape($this->label_operation) . "'" : "null") . ',';
        $sql .= ' debit = ' . (isset($this->debit) ? $this->debit : "null") . ',';
        $sql .= ' credit = ' . (isset($this->credit) ? $this->credit : "null") . ',';
        $sql .= ' montant = ' . (isset($this->montant) ? $this->montant : "null") . ',';
        $sql .= ' sens = ' . (isset($this->sens) ? "'" . $this->db->escape($this->sens) . "'" : "null") . ',';
        $sql .= ' fk_user_author = ' . (isset($this->fk_user_author) ? $this->fk_user_author : "null") . ',';
        $sql .= ' import_key = ' . (isset($this->import_key) ? "'" . $this->db->escape($this->import_key) . "'" : "null") . ',';
        $sql .= ' code_journal = ' . (isset($this->code_journal) ? "'" . $this->db->escape($this->code_journal) . "'" : "null") . ',';
        $sql .= ' journal_label = ' . (isset($this->journal_label) ? "'" . $this->db->escape($this->journal_label) . "'" : "null") . ',';
        $sql .= ' piece_num = ' . (isset($this->piece_num) ? $this->piece_num : "null");
        $sql .= ' WHERE rowid=' . ((int) $this->id);

        $this->db->begin();

        $resql = $this->db->query($sql);
        if (!$resql) {
            $error++;
            $this->errors[] = 'Error ' . $this->db->lasterror();
            dol_syslog(__METHOD__ . ' ' . implode(',', $this->errors), LOG_ERR);
        }

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

        // // Call triggers
        // $result=$this->call_trigger('MYOBJECT_MODIFY',$user);
        // if ($result < 0) { $error++; //Do also what you must do to rollback action if trigger fail}
        // // End call triggers
        //}

        // Commit or rollback
        if ($error) {
            $this->db->rollback();

            return -1 * $error;
        } else {
            $this->db->commit();

            return 1;
        }