bab-icon/app/Http/Controllers/ContractDistribution/ContractDistributionsController.php

<?php

namespace App\Http\Controllers\ContractDistribution;

use App\Http\Controllers\AdminBaseController;
use App\Http\Requests\ContractDistributionCreateRequest;
use App\Http\Requests\ContractDistributionUpdateRequest;
use App\Models\ContractDistribution;
use App\Repositories\Eloquent\ContractDistributionRepositoryEloquent;
use App\Servers\ContractServer;
use App\Validators\ContractDistributionValidator;

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

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

    /**
     * ContractDistributionsController constructor.
     *
     * @param ContractDistributionRepositoryEloquent $repository
     * @param ContractDistributionValidator $validator
     */
    public function __construct(ContractDistributionRepositoryEloquent $repository, ContractDistributionValidator $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)
    {
        $status=['失败','成功','广播失败'];
        foreach ($datum as $value){
            $value->{'type'}=ContractServer::creatServer()->getDistributionArrStr($value->{'type'});
            $value->{'status'}=empty($status[$value->{'status'}])?'状态异常':$status[$value->{'status'}];
        }
        return $datum;
    }

    function _indexJoin()
    {
        return ContractDistribution::from('contract_distributions as cb')
            ->leftJoin('contracts as c','c.id','=','cb.contract_id')
            ->leftJoin('broadcasts as b','b.id','=','cb.broadcast_id')
            ->select(['cb.*','c.contract_sn','b.hash']);
    }

}