App\Http\Controllers\Admin\AdminCategoryRegexesController::edit()

Complexity

Conditions	10
Paths	2

Size

Total Lines	81
Code Lines	58

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

<?php
    public function edit(Request $request)
    {
        $this->setAdminPrefs();
        $regexes = new Regexes(['Settings' => null, 'Table_Name' => 'category_regexes']);

        // Set the current action.
        $action = $request->input('action') ?? 'view';

        $regex = [
            'id' => '',
            'group_regex' => '',
            'regex' => '',
            'description' => '',
            'ordinal' => '',
            'categories_id' => '',
            'status' => 1, ];

        $this->smarty->assign('regex', $regex);

        switch ($action) {
            case 'submit':
                if (empty($request->input('group_regex'))) {
                    $this->smarty->assign('error', 'Group regex must not be empty!');
                    break;
                }

                if (empty($request->input('regex'))) {
                    $this->smarty->assign('error', 'Regex cannot be empty');
                    break;
                }

                if (! is_numeric($request->input('ordinal')) || $request->input('ordinal') < 0) {
                    $this->smarty->assign('error', 'Ordinal must be a number, 0 or higher.');
                    break;
                }

                if (empty($request->input('id'))) {
                    $regexes->addRegex($request->all());
                } else {
                    $regexes->updateRegex($request->all());
                }

                return redirect()->to('admin/category_regexes-list');
                break;

break is not strictly necessary here and could be removed.

            case 'view':
            default:
                if ($request->has('id')) {
                    $meta_title = $title = 'Category Regex Edit';
                    $id = $request->input('id');
                    $regex = $regexes->getRegexByID($id);
                } else {
                    $meta_title = $title = 'Category Regex Add';
                }
                $this->smarty->assign('regex', $regex);
                break;
        }

        $this->smarty->assign('status_ids', [Category::STATUS_ACTIVE, Category::STATUS_INACTIVE]);
        $this->smarty->assign('status_names', ['Yes', 'No']);

        $categories_db = Category::query()
            ->select(['c.id', 'c.title', 'cp.title as parent_title'])
            ->from('categories as c')

'categories as c' of type string is incompatible with the type Closure|Illuminate\Database\Eloquent\Builder|Illuminate\Database\Query\Builder expected by parameter $table of Illuminate\Database\Query\Builder::from().

            ->join('root_categories as cp', 'c.root_categories_id', '=', 'cp.id')
            ->whereNotNull('c.root_categories_id')
            ->orderBy('c.id')

'c.id' of type string is incompatible with the type Closure|Illuminate\Database\Eloquent\Builder|Illuminate\Database\Query\Builder expected by parameter $column of Illuminate\Database\Query\Builder::orderBy().

            ->get();
        // Build arrays for Smarty html_options helper. Previously only last row was kept.
        $category_ids = [];
        $category_names = [];
        foreach ($categories_db as $category_db) {
            $category_ids[] = $category_db->id;
            $category_names[] = $category_db->parent_title.' '.$category_db->title.': '.$category_db->id;
        }
        $this->smarty->assign('category_names', $category_names);
        $this->smarty->assign('category_ids', $category_ids);

        $content = $this->smarty->fetch('category_regexes-edit.tpl');
        $this->smarty->assign(compact('title', 'meta_title', 'content'));
        $this->adminrender();
    }