community-manage/app/Repositories/Behavior/GenaralRecordRepository.php

<?php
namespace App\Repositories\Behavior;
use App\Models\Behavior;
use App\Models\GeneralRecord;

/**
 * Created by PhpStorm.
 * User: durong
 * Date: 2019/6/14
 * Time: 下午8:45
 */

class GenaralRecordRepository
{
    public function __construct(GeneralRecord $generalRecord,Behavior $behavior)
    {
        $this->generalRecord = $generalRecord;
        $this->behavior = $behavior;
    }

    public function lists($request)
    {
        $perPage = isset($request['per_page']) ? $request['per_page'] : 20;
        $where = [];
        if(isset($request['id'])){
            $where[] = ['id', $request['id']];
        }
        if(isset($request['uid'])){
            $where[] = ['uid', $request['uid']];
        }
        if(isset($request['trigger_type'])){
            $where[] = ['trigger_type', $request['trigger_type']];
        }
        if(isset($request['virus_behavior_id'])){
            $where[] = ['virus_behavior_id', $request['virus_behavior_id']];
        }

        if(isset($request['behavior_identification'])){
            $virus_id = $this->behavior->select('virus_behavior_id')->where('behavior_identification',$request['behavior_identification'])->first();
            if ($virus_id){
                $where[] = ['virus_behavior_id', $virus_id->virus_behavior_id];
            }
        }

        return $this->generalRecord
            ->where($where)
            ->where(function($query) use ($request){
                if(isset($request['created_at'])){
                    $time = explode('_', $request['created_at']);
                    $query->whereBetween('created_at', $time);
                }
            })
            ->orderBy('id','desc')
            ->paginate($perPage);
    }

}