Crocodicstudio\Crudbooster\CBCoreModule\Search

Complexity

Total Complexity

12

Size/Duplication

Total Lines	87
Duplicated Lines	0 %

Importance

Changes

0

5 Methods

Rating	Name	Duplication	Size	Complexity
A	limitRows()	0	4	2
A	searchData()	0	23	3
A	decode()	0	4	1
A	orderRows()	0	6	2
A	filterRow()	0	12	4

<?php

namespace Crocodicstudio\Crudbooster\CBCoreModule;

use Illuminate\Support\Facades\DB;

class Search
{
    private $rows;

    /**
     * @param $data
     * @param $q
     * @param $id
     *
     * @return mixed
     */
    function searchData($data, $q, $id)
    {
        $data = $this->decode($data);
        $fieldValue = $data['field_value'];

        $table = $data['table'];
        $this->rows = DB::table($table);
        $this->rows->select($table.'.*');

        $this->orderRows($data, $fieldValue);
        $this->limitRows($data);

        if ($data['field_label']) {
            $this->rows->addselect($data['field_label'].' as text');
        }

        if ($fieldValue) {
            $this->rows->addselect($fieldValue.' as id');
        }

        $this->filterRow($data, $q, $id, $fieldValue);

        return $this->rows->get();
    }

    /**
     * @param $data
     * @param $fieldValue
     */
    private function orderRows($data, $fieldValue)
    {
        if ($data['sql_orderby']) {
            $this->rows->orderbyRaw($data['sql_orderby']);
        } else {
            $this->rows->orderby($fieldValue, 'desc');
        }
    }

    /**
     * @param $data
     */
    private function limitRows($data)
    {
        $num = (int)$data['limit'] ?: 10;
        $this->rows->take($num);
    }

    /**
     * @param $data
     * @param $q
     * @param $id
     * @param $fieldValue
     */
    private function filterRow($data, $q, $id, $fieldValue)
    {
        if ($data['sql_where']) {
            $this->rows->whereRaw($data['sql_where']);
        }

        if ($q) {
            $this->rows->where($data['field_label'], 'like', '%'.$q.'%');
        }

        if ($id) {
            $this->rows->where($fieldValue, $id);
        }
    }

    /**
     * @param $data
     * @return bool|mixed|string
     */
    private function decode($data)
    {
        $data = base64_decode($data);
        return json_decode($data, true);
    }
}