bab-icon/app/Http/Controllers/Contract/ContractsController.php

<?php

namespace App\Http\Controllers\Contract;

use App\Http\Controllers\AdminBaseController;
use App\Http\Requests\ContractCreateRequest;
use App\Http\Requests\ContractUpdateRequest;
use App\Models\Contract;
use App\Repositories\Eloquent\ContractRepositoryEloquent;
use App\Validators\ContractValidator;

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

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

    /**
     * ContractsController constructor.
     *
     * @param ContractRepositoryEloquent $repository
     * @param ContractValidator $validator
     */
    public function __construct(ContractRepositoryEloquent $repository, ContractValidator $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($data)
    {
        $status=['','广播中','交易成功','交易失败','公排出局'];
        foreach ($data as $item){
            $item->{'status'}=empty($status[$item->{'status'}])?'状态异常':$status[$item->{'status'}];
        }
        return $data;
    }

    function _indexJoin()
    {
        return Contract::from('contracts as c')
            ->leftJoin('members as m','m.id','=','c.m_id')
            ->select(['c.id','c.m_id','c.status','c.hash','c.money','c.error_msg','c.created_at','c.updated_at','c.is_out','c.contract_sn','m.address']);
    }

}