technician/app/back/controller/ApplyController.php

<?php
    /**
     * Created by PhpStorm.
     * User: Administrator
     * Date: 2020-10-20
     * Time: 13:27
     */
    
    namespace app\back\controller;
    
    
    use app\back\model\DistributorLogModel;
    use app\back\model\UserModel;
    use cmf\controller\AdminBaseController;

    class ApplyController extends AdminBaseController
    {
        public function index()
        {
            $DistribtorLogModel = new DistributorLogModel();
            $where = [];
            $page = $this->request->param('page');
            $pw = [];
            $keyword = $this->request->param('keyword');
            if($keyword){
                $this->assign('keyword',$keyword);
                $pw['keyword'] = $keyword;
                $user_ids = UserModel::where(function ($query) use ($keyword){
                    $query->where('user_nickname|mobile','like','%'.$keyword.'%');
                })->field('id')->select();
                $user_ids_new = [];
                foreach ($user_ids as $v){
                    $user_ids_new[] = $v['id'];
                }
                $where['user_id'] = $user_ids_new;
            }
            $status = $this->request->param('status');
            if($status || $status != ''){
                $pw['status'] = $status;
                $this->assign('status',$status);
                $where['chuli_status'] = $status;
            }
            $list = $DistribtorLogModel::with(['user','distributor'])->where($where)->order('id','desc')->paginate(30,false,array($page,url('index'),'query'=>$pw));
            $this->assign('list',$list);
          //  dump($list->toArray());
            $this->assign('page',$list->render());
            return $this->fetch();
        }
    
    
    
        public function apply_delete()
        {
            $id = $this->request->param('id');
            $DistribtorLogModel = new DistributorLogModel();
           // Db::name('user_apply_agency')->where('id',$id)->delete();
            $DistribtorLogModel::destroy($id);
            $this->success('删除成功');
        }
        
        public function apply_set()
        {
            $id = $this->request->param('id');
            $DistribtorLogModel = new DistributorLogModel();
            $info = $DistribtorLogModel::get($id);
            UserModel::where('id',$info['user_id'])->update(['distributor_id'=>$info['distributor_id']]);
            $DistribtorLogModel->allowField(true)->isUpdate(true)->save(['chuli_status'=>1,'chuli_time'=>time()],['id'=>$id]);
            $this->success('设置成功');
        }
    }