Gecko [ fastearnlimited.com ]

Name	Size	Permission	Date
ApiQuery.php	884 B	-rw-r--r--	2023-11-03 02:38
Searchable.php	3.22 KB	-rw-r--r--	2023-11-03 02:38
SupportTicketManager.php	8.2 KB	-rw-r--r--	2023-11-03 02:38

Rename

<?php

namespace App\Traits;

use Carbon\Carbon;
use Illuminate\Validation\ValidationException;

trait Searchable
{

/*
    |--------------------------------------------------------------------------
    | Search Data
    |--------------------------------------------------------------------------
    |
    | This trait basically used in model. This will help to implement search.
    | It could search in multiple column, date to date etc.
    | But this trait unable to make search with multiple table.
    |
    */

public function scopeSearchable($query, $params, $like = true)
    {
        $search = request()->search;
        $search = $like ? "%$search%" : $search;
        $query->where(function($q) use ($params, $search) {
            foreach ($params as $key => $param) {
                $relationData = explode(':', $param);
                if (@$relationData[1]) {
                    $q = $this->relationSearch($q,$relationData[0],$relationData[1],$search);
                }else{
                    $column = $param;
                    $q->orWhere($column, 'LIKE', $search);
                }
            }
        });

return $query;
    }

public function scopeFilter($query, $params)
    {
        foreach ($params as $param) {
            $relationData = explode(':', $param);
            $filters = array_keys(request()->all());
            if (@$relationData[1]) {
                $query = $this->relationFilter($query,$relationData[0],$relationData[1],$filters);
            }else{
                $column = $param;
                if (in_array($column, $filters) && request()->$column != null) {
                    $query->where($column, request()->$column);
                }
            }

}
        return $query;
    }

public function scopeDateFilter($query, $column = 'created_at')
    {
        if (!request()->date) {
            return $query;
        }
        try{
            $date      = explode('-', request()->date);
            $startDate = Carbon::parse(trim($date[0]))->format('Y-m-d');
            $endDate = @$date[1] ? Carbon::parse(trim(@$date[1]))->format('Y-m-d') : $startDate;
        }catch(\Exception $e){
            throw ValidationException::withMessages(['error' => 'Unauthorized action']);
        }

request()->merge(['start_date' => $startDate, 'end_date' => $endDate]);

return  $query->whereDate($column, '>=', $startDate)->whereDate($column, '<=', $endDate);
    }

private function relationSearch($query,$relation,$columns,$search){
        foreach (explode(',', $columns) as $column) {
            $query->orWhereHas($relation, function ($q) use ($column,$search) {
                $q->where($column, 'like', $search);
            });
        }
        return $query;
    }

private function relationFilter($query,$relation,$columns,$filters){
        foreach (explode(',', $columns) as $column) {
            if (in_array($column, $filters) && request()->$column != null) {
                $query->whereHas($relation,function($q) use ($column){
                    $q->where($column,request()->$column);
                });
            }
        }
        return $query;
    }

}