DoliModules\Accounting\Controller\AccountingAdminController::productaccount()

Complexity

Conditions	43
Paths	> 20000

Size

Total Lines	235
Code Lines	160

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public function productaccount()
    {
        global $conf;
        global $db;
        global $user;
        global $hookmanager;
        global $user;
        global $menumanager;
        global $langs;
        global $mysoc;

// Load translation files required by the page
        $langs->loadLangs(["companies", "compta", "accountancy", "products"]);

// Security check
        if (!isModEnabled('accounting')) {
            accessforbidden();
        }
        if (!$user->hasRight('accounting', 'bind', 'write')) {
            accessforbidden();
        }

// search & action GETPOST
        $action = GETPOST('action', 'aZ09');
        $massaction = GETPOST('massaction', 'alpha');
        $confirm = GETPOST('confirm', 'alpha');
        $optioncss = GETPOST('optioncss', 'alpha');

        $codeventil_buy = GETPOST('codeventil_buy', 'array');
        $codeventil_sell = GETPOST('codeventil_sell', 'array');
        $chk_prod = GETPOST('chk_prod', 'array');
        $default_account = GETPOSTINT('default_account');
        $account_number_buy = GETPOST('account_number_buy');
        $account_number_sell = GETPOST('account_number_sell');
        $changeaccount = GETPOST('changeaccount', 'array');
        $changeaccount_buy = GETPOST('changeaccount_buy', 'array');
        $changeaccount_sell = GETPOST('changeaccount_sell', 'array');
        $searchCategoryProductOperator = (GETPOSTINT('search_category_product_operator') ? GETPOSTINT('search_category_product_operator') : 0);
        $searchCategoryProductList = GETPOST('search_category_product_list', 'array');
        $search_ref = GETPOST('search_ref', 'alpha');
        $search_label = GETPOST('search_label', 'alpha');
        $search_desc = GETPOST('search_desc', 'alpha');
        $search_vat = GETPOST('search_vat', 'alpha');
        $search_current_account = GETPOST('search_current_account', 'alpha');
        $search_current_account_valid = GETPOST('search_current_account_valid', 'alpha');
        if ($search_current_account_valid == '') {
            $search_current_account_valid = 'withoutvalidaccount';
        }
        $search_onsell = GETPOST('search_onsell', 'alpha');
        $search_onpurchase = GETPOST('search_onpurchase', 'alpha');

        $accounting_product_mode = GETPOST('accounting_product_mode', 'alpha');
        $btn_changetype = GETPOST('changetype', 'alpha');

        if (empty($accounting_product_mode)) {
            $accounting_product_mode = 'ACCOUNTANCY_SELL';
        }

        $limit = GETPOSTINT('limit') ? GETPOSTINT('limit') : getDolGlobalInt('ACCOUNTING_LIMIT_LIST_VENTILATION', $conf->liste_limit);
        $sortfield = GETPOST('sortfield', 'aZ09comma');
        $sortorder = GETPOST('sortorder', 'aZ09comma');
        $page = GETPOSTISSET('pageplusone') ? (GETPOSTINT('pageplusone') - 1) : GETPOSTINT("page");
        if (empty($page) || $page == -1) {
            $page = 0;
        }     // If $page is not defined, or '' or -1
        $offset = $limit * $page;
        $pageprev = $page - 1;
        $pagenext = $page + 1;
        if (!$sortfield) {
            $sortfield = "p.ref";
        }
        if (!$sortorder) {
            $sortorder = "ASC";
        }

        if (empty($action)) {
            $action = 'list';
        }

        $arrayfields = [];

        $accounting_product_modes = [
            'ACCOUNTANCY_SELL',
            'ACCOUNTANCY_SELL_INTRA',
            'ACCOUNTANCY_SELL_EXPORT',
            'ACCOUNTANCY_BUY',
            'ACCOUNTANCY_BUY_INTRA',
            'ACCOUNTANCY_BUY_EXPORT',
        ];

        if ($accounting_product_mode == 'ACCOUNTANCY_BUY') {
            $accountancy_field_name = "accountancy_code_buy";
        } elseif ($accounting_product_mode == 'ACCOUNTANCY_BUY_INTRA') {
            $accountancy_field_name = "accountancy_code_buy_intra";
        } elseif ($accounting_product_mode == 'ACCOUNTANCY_BUY_EXPORT') {
            $accountancy_field_name = "accountancy_code_buy_export";
        } elseif ($accounting_product_mode == 'ACCOUNTANCY_SELL') {
            $accountancy_field_name = "accountancy_code_sell";
        } elseif ($accounting_product_mode == 'ACCOUNTANCY_SELL_INTRA') {
            $accountancy_field_name = "accountancy_code_sell_intra";
        } else { // $accounting_product_mode == 'ACCOUNTANCY_SELL_EXPORT'
            $accountancy_field_name = "accountancy_code_sell_export";
        }

        /*
         * Actions
         */

        if (GETPOST('cancel', 'alpha')) {
            $action = 'list';
            $massaction = '';
        }
        if (!GETPOST('confirmmassaction', 'alpha') && $massaction != 'presend' && $massaction != 'confirm_presend') {
            $massaction = '';
        }

        $parameters = [];
        $reshook = $hookmanager->executeHooks('doActions', $parameters, $object, $action); // Note that $action and $object may have been modified by some hooks

The variable $object seems to be never defined.

        if ($reshook < 0) {
            setEventMessages($hookmanager->error, $hookmanager->errors, 'errors');
        }

// Purge search criteria
        if (GETPOST('button_removefilter_x', 'alpha') || GETPOST('button_removefilter.x', 'alpha') || GETPOST('button_removefilter', 'alpha')) { // All test are required to be compatible with all browsers
            $searchCategoryProductOperator = 0;
            $searchCategoryProductList = [];
            $search_ref = '';
            $search_label = '';
            $search_desc = '';
            $search_vat = '';
            $search_onsell = '';
            $search_onpurchase = '';
            $search_current_account = '';
            $search_current_account_valid = '-1';
        }

// Sales or Purchase mode ?
        if ($action == 'update') {
            if (!empty($btn_changetype)) {
                $error = 0;

                if (in_array($accounting_product_mode, $accounting_product_modes)) {
                    if (!dolibarr_set_const($db, 'ACCOUNTING_PRODUCT_MODE', $accounting_product_mode, 'chaine', 0, '', $conf->entity)) {
                        $error++;
                    }
                } else {
                    $error++;
                }
            }

            if (!empty($chk_prod) && $massaction === 'changeaccount') {
                //$msg = '<div><span class="accountingprocessing">' . $langs->trans("Processing") . '...</span></div>';
                if (!empty($chk_prod) && in_array($accounting_product_mode, $accounting_product_modes)) {
                    $accounting = new AccountingAccount($db);

                    //$msg .= '<div><span class="accountingprocessing">' . count($chk_prod) . ' ' . $langs->trans("SelectedLines") . '</span></div>';
                    $arrayofdifferentselectedvalues = [];

                    $cpt = 0;
                    $ok = 0;
                    $ko = 0;
                    foreach ($chk_prod as $productid) {
                        $accounting_account_id = GETPOST('codeventil_' . $productid);

                        $result = 0;
                        if ($accounting_account_id > 0) {
                            $arrayofdifferentselectedvalues[$accounting_account_id] = $accounting_account_id;
                            $result = $accounting->fetch($accounting_account_id, null, 1);
                        }
                        if ($result <= 0) {
                            // setEventMessages(null, $accounting->errors, 'errors');
                            $msg .= '<div><span class="error">' . $langs->trans("ErrorDB") . ' : ' . $langs->trans("Product") . ' ' . $productid . ' ' . $langs->trans("NotVentilatedinAccount") . ' : id=' . $accounting_account_id . '<br> <pre>' . $sql . '</pre></span></div>';

The variable $msg seems to be never defined.

                            $ko++;
                        } else {
                            $sql = '';
                            if (getDolGlobalString('MAIN_PRODUCT_PERENTITY_SHARED')) {
                                $sql_exists = "SELECT rowid FROM " . MAIN_DB_PREFIX . "product_perentity";
                                $sql_exists .= " WHERE fk_product = " . ((int) $productid) . " AND entity = " . ((int) $conf->entity);
                                $resql_exists = $db->query($sql_exists);
                                if (!$resql_exists) {
                                    $msg .= '<div><span class="error">' . $langs->trans("ErrorDB") . ' : ' . $langs->trans("Product") . ' ' . $productid . ' ' . $langs->trans("NotVentilatedinAccount") . ' : id=' . $accounting_account_id . '<br> <pre>' . json_encode($resql_exists) . '</pre></span></div>';
                                    $ko++;
                                } else {
                                    $nb_exists = $db->num_rows($resql_exists);
                                    if ($nb_exists <= 0) {
                                        // insert
                                        $sql = "INSERT INTO " . MAIN_DB_PREFIX . "product_perentity (fk_product, entity, " . $db->sanitize($accountancy_field_name) . ")";
                                        $sql .= " VALUES (" . ((int) $productid) . ", " . ((int) $conf->entity) . ", '" . $db->escape($accounting->account_number) . "')";
                                    } else {
                                        $obj_exists = $db->fetch_object($resql_exists);
                                        // update
                                        $sql = "UPDATE " . MAIN_DB_PREFIX . "product_perentity";
                                        $sql .= " SET " . $db->sanitize($accountancy_field_name) . " = '" . $db->escape($accounting->account_number) . "'";
                                        $sql .= " WHERE rowid = " . ((int) $obj_exists->rowid);
                                    }
                                }
                            } else {
                                $sql = " UPDATE " . MAIN_DB_PREFIX . "product";
                                $sql .= " SET " . $db->sanitize($accountancy_field_name) . " = '" . $db->escape($accounting->account_number) . "'";
                                $sql .= " WHERE rowid = " . ((int) $productid);
                            }

                            dol_syslog("/accountancy/admin/productaccount.php", LOG_DEBUG);

                            $db->begin();

                            if ($db->query($sql)) {
                                $ok++;
                                $db->commit();
                            } else {
                                $ko++;
                                $db->rollback();
                            }
                        }

                        $cpt++;
                    }
                }

                if ($ko) {
                    setEventMessages($langs->trans("XLineFailedToBeBinded", $ko), null, 'errors');
                }
                if ($ok) {
                    setEventMessages($langs->trans("XLineSuccessfullyBinded", $ok), null, 'mesgs');
                }
            }
        }

        /*
         * View
         */
        require_once realpath(BASE_PATH . '/../Dolibarr/Modules/Accounting/Views/admin_productaccount.php');

        $db->close();
        return true;
    }