PaymentVarious::create()

Complexity

Conditions	28
Paths	3192

Size

Total Lines	163
Code Lines	116

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
     *  @param   User   $user   User that create
     *  @return  int            Return integer <0 if KO, >0 if OK
     */
    public function create($user)
    {
        global $conf, $langs;

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

        // Clean parameters
        $this->amount = (float) price2num($this->amount);
        $this->label = trim($this->label);
        $this->note = trim($this->note);

The property Dolibarr\Core\Base\CommonObject::$note has been deprecated: Use $note_private instead.

        $this->fk_bank = (int) $this->fk_bank;
        $this->fk_user_author = (int) $this->fk_user_author;
        $this->fk_user_modif = (int) $this->fk_user_modif;
        $this->fk_account = (int) $this->fk_account;
        if (empty($this->fk_account) && isset($this->accountid)) {  // For compatibility

The property Dolibarr\Code\Compta\Classes\PaymentVarious::$accountid has been deprecated: See fk_account

            $this->fk_account = $this->accountid;
        }

        // Check parameters
        if (!$this->label) {
            $this->error = $langs->trans("ErrorFieldRequired", $langs->transnoentities("Label"));
            return -3;
        }
        if ($this->amount < 0 || $this->amount == '') {
            $this->error = $langs->trans("ErrorFieldRequired", $langs->transnoentities("Amount"));
            return -5;
        }
        if (isModEnabled("bank") && (empty($this->fk_account) || $this->fk_account <= 0)) {
            $this->error = $langs->trans("ErrorFieldRequired", $langs->transnoentities("BankAccount"));
            return -6;
        }
        if (isModEnabled("bank") && (empty($this->type_payment) || $this->type_payment <= 0)) {
            $this->error = $langs->trans("ErrorFieldRequired", $langs->transnoentities("PaymentMode"));
            return -7;
        }

        $this->db->begin();

        // Insert into llx_payment_various
        $sql = "INSERT INTO " . MAIN_DB_PREFIX . "payment_various (";
        $sql .= " datep";
        $sql .= ", datev";
        $sql .= ", sens";
        $sql .= ", amount";
        $sql .= ", fk_typepayment";
        $sql .= ", num_payment";
        if ($this->note) {
            $sql .= ", note";
        }
        $sql .= ", label";
        $sql .= ", accountancy_code";
        $sql .= ", subledger_account";
        $sql .= ", fk_projet";
        $sql .= ", fk_user_author";
        $sql .= ", datec";
        $sql .= ", fk_bank";
        $sql .= ", entity";
        $sql .= ")";
        $sql .= " VALUES (";
        $sql .= "'" . $this->db->idate($this->datep) . "'";
        $sql .= ", '" . $this->db->idate($this->datev) . "'";
        $sql .= ", '" . $this->db->escape($this->sens) . "'";
        $sql .= ", " . price2num($this->amount);
        $sql .= ", '" . $this->db->escape($this->type_payment) . "'";
        $sql .= ", '" . $this->db->escape($this->num_payment) . "'";
        if ($this->note) {
            $sql .= ", '" . $this->db->escape($this->note) . "'";
        }
        $sql .= ", '" . $this->db->escape($this->label) . "'";
        $sql .= ", '" . $this->db->escape($this->accountancy_code) . "'";
        $sql .= ", '" . $this->db->escape($this->subledger_account) . "'";
        $sql .= ", " . ($this->fk_project > 0 ? ((int) $this->fk_project) : 0);
        $sql .= ", " . ((int) $user->id);
        $sql .= ", '" . $this->db->idate($now) . "'";
        $sql .= ", NULL";   // Filled later
        $sql .= ", " . ((int) $conf->entity);
        $sql .= ")";

        dol_syslog(get_class($this) . "::create", LOG_DEBUG);
        $result = $this->db->query($sql);
        if ($result) {
            $this->id = $this->db->last_insert_id(MAIN_DB_PREFIX . "payment_various");
            $this->ref = (string) $this->id;

            if ($this->id > 0) {
                if (isModEnabled("bank") && !empty($this->amount)) {
                    // Insert into llx_bank

                    $acc = new Account($this->db);
                    $result = $acc->fetch($this->fk_account);
                    if ($result <= 0) {
                        dol_print_error($this->db);
                    }

                    // Insert payment into llx_bank
                    // Add link 'payment_various' in bank_url between payment and bank transaction
                    $sign = 1;
                    if ($this->sens == '0') {
                        $sign = -1;
                    }

                    $bank_line_id = $acc->addline(
                        $this->datep,
                        $this->type_payment,
                        $this->label,
                        $sign * abs($this->amount),
                        $this->num_payment,
                        ($this->category_transaction > 0 ? $this->category_transaction : 0),
                        $user,
                        $this->chqemetteur,
                        $this->chqbank,
                        '',
                        $this->datev
                    );

                    // Update fk_bank into llx_payment_various
                    // So we know the payment which has generate the banking ecriture
                    if ($bank_line_id > 0) {
                        $this->update_fk_bank($bank_line_id);
                    } else {
                        $this->error = $acc->error;
                        $error++;
                    }

                    if (!$error) {
                        // Add link 'payment_various' in bank_url between payment and bank transaction
                        $url = constant('BASE_URL') . '/compta/bank/various_payment/card.php?id=';

                        $result = $acc->add_url_line($bank_line_id, $this->id, $url, "(VariousPayment)", "payment_various");
                        if ($result <= 0) {
                            $this->error = $acc->error;
                            $error++;
                        }
                    }

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

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

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