Modules\Core\Traits\Criteria\ParserOrderByTrait::parserOrderBy()

Complexity

Conditions	6
Paths	8

Size

Total Lines	27
Code Lines	21

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    protected function parserOrderBy()
    {
        $this->orderBy = $this->request->get(config('repository.criteria.params.orderBy', 'orderBy'), null);

The property orderBy does not exist. Although not strictly required by PHP, it is generally a best practice to declare properties explicitly.

        $this->sortedBy = $this->request->get(config('repository.criteria.params.sortedBy', 'sortedBy'), 'asc');

The property sortedBy does not exist. Although not strictly required by PHP, it is generally a best practice to declare properties explicitly.

        $this->sortedBy = !empty($this->sortedBy) ? $this->sortedBy : 'asc';

        if (isset($this->orderBy) && !empty($this->orderBy)) {
            $split = explode('|', $this->orderBy);
            if (count($split) > 1) {
                $table = $this->model->getModel()->getTable();
                $sortTable = $split[0];
                $sortColumn = $split[1];

                $split = explode(':', $sortTable);
                if (count($split) > 1) {
                    $sortTable = $split[0];
                    $keyName = $table.'.'.$split[1];
                } else {
                    $prefix = Str::singular($sortTable);
                    $keyName = $table.'.'.$prefix.'_id';
                }

                $this->model = $this->model->leftJoin($sortTable, $keyName, '=', $sortTable.'.id')
                                           ->orderBy($sortColumn, $this->sortedBy)
                                           ->addSelect($table.'.*');
            } else {
                $this->model = $this->model->orderBy($this->orderBy, $this->sortedBy);
            }
}