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

Complexity

Conditions	41
Paths	> 20000

Size

Total Lines	211
Code Lines	135

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

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

// Load translation files required by the page
        $langs->loadLangs(['accountancy', 'admin', 'bills', 'compta', 'salaries']);

        $action = GETPOST('action', 'aZ09');
        $cancel = GETPOST('cancel', 'alpha');
        $id = GETPOSTINT('id');
        $rowid = GETPOSTINT('rowid');
        $massaction = GETPOST('massaction', 'aZ09');
        $optioncss = GETPOST('optioncss', 'alpha');
        $contextpage = GETPOST('contextpage', 'aZ') ? GETPOST('contextpage', 'aZ') : 'accountingaccountlist'; // To manage different context of search
        $mode = GETPOST('mode', 'aZ'); // The output mode ('list', 'kanban', 'hierarchy', 'calendar', ...)

        $search_account = GETPOST('search_account', 'alpha');
        $search_label = GETPOST('search_label', 'alpha');
        $search_labelshort = GETPOST('search_labelshort', 'alpha');
        $search_accountparent = GETPOST('search_accountparent', 'alpha');
        $search_pcgtype = GETPOST('search_pcgtype', 'alpha');
        $search_import_key = GETPOST('search_import_key', 'alpha');
        $toselect = GETPOST('toselect', 'array');
        $limit = GETPOSTINT('limit') ? GETPOSTINT('limit') : $conf->liste_limit;
        $confirm = GETPOST('confirm', 'alpha');

        $chartofaccounts = GETPOSTINT('chartofaccounts');

        $permissiontoadd = $user->hasRight('accounting', 'chartofaccount');
        $permissiontodelete = $user->hasRight('accounting', 'chartofaccount');

// Security check
        if ($user->socid > 0) {
            accessforbidden();
        }
        if (!$user->hasRight('accounting', 'chartofaccount')) {
            accessforbidden();
        }

// Load variable for pagination
        $limit = GETPOSTINT('limit') ? GETPOSTINT('limit') : $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 = "aa.account_number";
        }
        if (!$sortorder) {
            $sortorder = "ASC";
        }

        $arrayfields = [
            'aa.account_number' => ['label' => "AccountNumber", 'checked' => 1],
            'aa.label' => ['label' => "Label", 'checked' => 1],
            'aa.labelshort' => ['label' => "LabelToShow", 'checked' => 1],
            'aa.account_parent' => ['label' => "Accountparent", 'checked' => 1],
            'aa.pcg_type' => ['label' => "Pcgtype", 'checked' => 1, 'help' => 'PcgtypeDesc'],
            'categories' => ['label' => "AccountingCategories", 'checked' => -1, 'help' => 'AccountingCategoriesDesc'],
            'aa.reconcilable' => ['label' => "Reconcilable", 'checked' => 1],
            'aa.import_key' => ['label' => "ImportId", 'checked' => -1, 'help' => ''],
            'aa.active' => ['label' => "Activated", 'checked' => 1],
        ];

        if (getDolGlobalInt('MAIN_FEATURES_LEVEL') < 2) {
            unset($arrayfields['categories']);
            unset($arrayfields['aa.reconcilable']);
        }

        $accounting = new AccountingAccount($db);

// Initialize technical object to manage hooks. Note that conf->hooks_modules contains array
        $hookmanager->initHooks(['accountancyadminaccount']);


        /*
         * Actions
         */

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

        $parameters = ['chartofaccounts' => $chartofaccounts, 'permissiontoadd' => $permissiontoadd, 'permissiontodelete' => $permissiontodelete];
        $reshook = $hookmanager->executeHooks('doActions', $parameters, $accounting, $action); // Note that $action and $object may have been monowraponalldified by some hooks
        if ($reshook < 0) {
            setEventMessages($hookmanager->error, $hookmanager->errors, 'errors');
        }

        if (empty($reshook)) {
            if (!empty($cancel)) {
                $action = '';
            }

            $objectclass = 'AccountingAccount';
            $uploaddir = $conf->accounting->multidir_output[$conf->entity];
            include DOL_DOCUMENT_ROOT . '/core/actions_massactions.inc.php';

            if ($action == "delete") {
                $action = "";
            }
            include DOL_DOCUMENT_ROOT . '/core/actions_changeselectedfields.inc.php';

            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
                $search_account = "";
                $search_label = "";
                $search_labelshort = "";
                $search_accountparent = "";
                $search_pcgtype = "";
                $search_import_key = "";
                $search_array_options = [];
            }
            if (
                (GETPOSTINT('valid_change_chart') && GETPOSTINT('chartofaccounts') > 0) // explicit click on button 'Change and load' with js on
                || (GETPOSTINT('chartofaccounts') > 0 && GETPOSTINT('chartofaccounts') != getDolGlobalInt('CHARTOFACCOUNTS'))
            ) {    // a submit of form is done and chartofaccounts combo has been modified
                $error = 0;

                if ($chartofaccounts > 0 && $permissiontoadd) {
                    $country_code = '';
                    // Get language code for this $chartofaccounts
                    $sql = 'SELECT code FROM ' . MAIN_DB_PREFIX . 'c_country as c, ' . MAIN_DB_PREFIX . 'accounting_system as a';
                    $sql .= ' WHERE c.rowid = a.fk_country AND a.rowid = ' . (int) $chartofaccounts;
                    $resql = $db->query($sql);
                    if ($resql) {
                        $obj = $db->fetch_object($resql);
                        if ($obj) {
                            $country_code = $obj->code;
                        }
                    } else {
                        dol_print_error($db);
                    }

                    // Try to load sql file
                    if ($country_code) {
                        $sqlfile = DOL_DOCUMENT_ROOT . '/install/mysql/data/llx_accounting_account_' . strtolower($country_code) . '.sql';

                        $offsetforchartofaccount = 0;
                        // Get the comment line '-- ADD CCCNNNNN to rowid...' to find CCCNNNNN (CCC is country num, NNNNN is id of accounting account)
                        // and pass CCCNNNNN + (num of company * 100 000 000) as offset to the run_sql as a new parameter to say to update sql on the fly to add offset to rowid and account_parent value.
                        // This is to be sure there is no conflict for each chart of account, whatever is country, whatever is company when multicompany is used.
                        $tmp = file_get_contents($sqlfile);
                        $reg = [];
                        if (preg_match('/-- ADD (\d+) to rowid/ims', $tmp, $reg)) {
                            $offsetforchartofaccount += $reg[1];
                        }
                        $offsetforchartofaccount += ($conf->entity * 100000000);

                        $result = run_sql($sqlfile, 1, $conf->entity, 1, '', 'default', 32768, 0, $offsetforchartofaccount);

                        if ($result > 0) {
                            setEventMessages($langs->trans("ChartLoaded"), null, 'mesgs');
                        } else {
                            setEventMessages($langs->trans("ErrorDuringChartLoad"), null, 'warnings');
                        }
                    }

                    if (!dolibarr_set_const($db, 'CHARTOFACCOUNTS', $chartofaccounts, 'chaine', 0, '', $conf->entity)) {
                        $error++;
                    }
                } else {
                    $error++;
                }
            }

            if ($action == 'disable' && $permissiontoadd) {
                if ($accounting->fetch($id)) {
                    $mode = GETPOSTINT('mode');
                    $result = $accounting->accountDeactivate($id, $mode);
                    if ($result < 0) {
                        setEventMessages($accounting->error, $accounting->errors, 'errors');
                    }
                }

                $action = 'update';
            } elseif ($action == 'enable' && $permissiontoadd) {
                if ($accounting->fetch($id)) {
                    $mode = GETPOSTINT('mode');
                    $result = $accounting->accountActivate($id, $mode);
                    if ($result < 0) {
                        setEventMessages($accounting->error, $accounting->errors, 'errors');
                    }
                }
                $action = 'update';
            }
        }


        /*
         * View
         */

        require_once realpath(BASE_PATH . '/../Dolibarr/Modules/Accounting/Views/admin_account.php');

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