tt-5-php-6001/plugin/admin/app/controller/RaffleLogController.php

<?php

namespace plugin\admin\app\controller;

use Illuminate\Support\Arr;
use plugin\admin\app\model\RaffleLog;
use support\Request;
use support\Response;
use support\exception\BusinessException;

/**
 * 邀请规则 
 */
class RaffleLogController extends Crud
{
    
    /**
     * @var RaffleLog
     */
    protected $model = null;

    /**
     * 构造函数
     * @return void
     */
    public function __construct()
    {
        $this->model = new RaffleLog();
    }
    
    /**
     * 浏览
     * @return Response
     */
    public function index(): Response
    {
        return view('raffle-log/index');
    }

    public function select(Request $request):Response
    {
        $param=$request->all();

        $data=RaffleLog::query()->with('userData:id,name,mobile')->with('raffle:id,name')->where(function ($query)use ($param){
            if(Arr::get($param,'id')){
                $query->where('id',$param['id']);
            }
        })
            ->whereExists(function ($query)use ($param){
                $query->from('wa_users')->whereRaw('wa_users.id=wa_raffle_log.user_id');
                if(Arr::get($param,'user_name')){
                    $query->where('name','like','%'.$param['user_name'].'%');
                }
                if(Arr::get($param,'user_mobile')){
                    $query->where('mobile','like','%'.$param['user_mobile'].'%');
                }
            });
        $data=$data->paginate(Arr::get($param,'limit',10))->toArray();
        foreach ($data['data'] as   $k=>$v){
            $data['data'][$k]['user_name']=Arr::get($v['user_data'],'name');
            $data['data'][$k]['user_mobile']=Arr::get($v['user_data'],'mobile');
            $data['data'][$k]['raffle_title']=Arr::get($v['raffle'],'name');
        }

        return json(['code' => 0, 'data' => $data['data'], 'msg' => 'ok','count'=>$data['total']]);
    }

    /**
     * 插入
     * @param Request $request
     * @return Response
     * @throws BusinessException
     */
    public function insert(Request $request): Response
    {
        if ($request->method() === 'POST') {
            return parent::insert($request);
        }
        return view('raffle-log/insert');
    }

    /**
     * 更新
     * @param Request $request
     * @return Response
     * @throws BusinessException
    */
    public function update(Request $request): Response
    {
        if ($request->method() === 'POST') {
            return parent::update($request);
        }
        return view('raffle-log/update');
    }

}