bab-icon/app/Http/Controllers/Message/MessagesController.php

<?php

namespace App\Http\Controllers\Message;

use App\Http\Controllers\AdminBaseController;
use App\Http\Requests\MessageCreateRequest;
use App\Http\Requests\MessageUpdateRequest;
use App\Repositories\Eloquent\MessageRepositoryEloquent;
use App\Validators\MessageValidator;

/**
 * Class MessagesController.
 *
 * @package namespace App\Http\Controllers;
 */
class MessagesController extends AdminBaseController
{
    /**
     * @var MessageRepositoryEloquent
     */
    protected $repository;

    /**
     * @var MessageValidator
     */
    protected $validator;

    /**
     * MessagesController constructor.
     *
     * @param MessageRepositoryEloquent $repository
     * @param MessageValidator $validator
     */
    public function __construct(MessageRepositoryEloquent $repository, MessageValidator $validator)
    {
        parent::__construct($repository, $validator);
    }

    /**
     * 数据检索
     */
     public function _indexScopeQuery()
        {
            $where = [];
            $search = explode(";", request()->input('search', ""));
            $start = $end = null;
            $fieldSearchable=$this->repository->getFieldsSearchable();
            foreach ($search as $value) {
                if (!empty($value)) {
                    list($one, $tow) = explode(":", $value);
                    if (!empty($fieldSearchable[$one])) {
                        if($fieldSearchable[$one]=='like')$tow="%{$tow}%";
                        $where[]=[$one,$fieldSearchable[$one],$tow];
                    } elseif ($one == 'start') {
                        $start = $tow . " 00:00:00";
                    } elseif ($one == 'end') {
                        $end = $tow . " 23:59:59";
                    } else {
                        continue;
                    }
                }
            }
            return function ($query) use ($where, $start, $end) {

                if ($start) $where[] = ['created_at', '>=', $start];
                if ($end) $where[] = ['created_at', '<=', $end];
                if ($where) {
                    $query->where($where);
                }

            };
        }

   /**
     * 数据更新
     */
    protected function _indexPost($datum)
    {
        return $datum;
    }

}