Edit File - File Manager

Edit File: AuthBaseScopes.php

<?php

namespace App\Models\Scopes;

use Illuminate\Support\Facades\Schema;

trait AuthBaseScopes
{

/**
     * Scope a query to search in the model.
     *
     * @param  \Illuminate\Database\Eloquent\Builder  $query
     * @param  array  $searchArray
     * @return \Illuminate\Database\Eloquent\Builder
     */
    public function scopeSearch($query, $searchArray = [])
    {
        $query->where(function ($query) use ($searchArray) {
            if ($searchArray) {
                foreach ($searchArray as $key => $value) {
                    if (str_contains($key, '_id')) {
                        if (null != $value) {
                            $query->Where($key, $value);
                        }
                    } elseif ('order' == $key) {
                    } elseif ('created_at_min' == $key) {
                        if (null != $value) {
                            $query->WhereDate('created_at', '>=', $value);
                        }
                    } elseif ('created_at_max' == $key) {
                        if (null != $value) {
                            $query->WhereDate('created_at', '<=', $value);
                        }
                    } else {
                        if (str_contains($key, '->')) {
                            list($relationship, $field) = explode('->', $key);
                            if (method_exists($this, $relationship)) {
                                $query->whereHas($relationship, function ($query) use ($field, $value) {
                                    $query->where($field, 'like', '%' . $value . '%');
                                });
                            }
                        } else {
                            if (Schema::hasColumn($this->getTable(), $key)) {
                                $query->Where($key, 'like', '%' . $value . '%');
                            }
                        }
                    }
                }
            }
        });
        return $query->orderBy('created_at', request()->searchArray && request()->searchArray['order'] ? request()->searchArray['order'] : 'DESC');
    }
}

Back to File Manager