technician/api/js/controller/UserAgencyController.php

<?php
    /**
     * Created by PhpStorm.
     * User: Administrator
     * Date: 2020-09-28
     * Time: 10:43
     */
    
    namespace api\js\controller;
    
    
    use api\js\model\AgencyModel;
    use api\js\model\JsCallModel;
    use api\js\model\JsOrderModel;
    use api\js\model\UserModel;
    use cmf\controller\RestUserBaseController;
    use think\Db;

    class UserAgencyController extends RestUserBaseController
    {
    
        /**
         * @throws \think\db\exception\DataNotFoundException
         * @throws \think\db\exception\ModelNotFoundException
         * @throws \think\exception\DbException
         * 获取数量
         */
        public function getnum()
        {
            $user_id = $this->getUserId();
            $UserModel = new UserModel();
            $agency_id = $UserModel::get($user_id)['agency_id'];
           
            if(!$agency_id){
                $this->error('您还不是代理商!');
            }
            $result = get_user_and_userjs($user_id);
            $user_ids_new = $result['user_ids'];
            $user_js_ids_new = $result['user_js_ids'];
            $JsOrderModel = new JsOrderModel();
         
            $money = Db::name('user_money_log')->where(['user_id'=>$user_id,'type'=>5])->sum('money');
            $order_num = $JsOrderModel::where('user_id','in',$user_js_ids_new)->count();
            $user_num = count($user_ids_new);
            $js_num = count($user_js_ids_new);
            $call_num = JsCallModel::where('user_id','in',$user_js_ids_new)->where('agency_is_look',0)->count();
            $this->success('ok',['user_num'=>$user_num,'js_num'=>$js_num,'order_num'=>$order_num,'money'=>$money,'call_num'=>$call_num]);
        
        }
        
        
        /**
         * 查看本地列表
         */
        public function getUserList()
        {
            $user_id = $this->getUserId();
            $UserModel = new UserModel();
            $agency_id = $UserModel::get($user_id)['agency_id'];
    
            if(!$agency_id){
                $this->error('您还不是代理商!');
            }
            $district_id = $this->request->param('district_id');
            $city_id = $this->request->param('city_id');
            $renk_id = $this->request->param('renk_id');
            $result = get_user_and_userjs($user_id,$district_id,$city_id,$renk_id);
            $where['id'] = $result['user_ids'];
            $page = $this->request->param('page',1);
            $user_list = $UserModel::where($where)->field('id,mobile,user_nickname,avatar,create_time')->order('id','desc')->page($page,20)->select()->each(function ($user_list){
                $user_list['mobile'] = preg_replace("/(\d{3})\d{4}(\d{4})/", "\$1****\$2", $user_list['mobile']);
                return $user_list;
            });
            $this->success('ok',$user_list);
        }
    
        /**
         * 查看技师列表
         */
        public function getJsList()
        {
            $user_id = $this->getUserId();
            $UserModel = new UserModel();
            $agency_id = $UserModel::get($user_id)['agency_id'];
    
            if(!$agency_id){
                $this->error('您还不是代理商!');
            }
            $district_id = $this->request->param('district_id');
            $city_id = $this->request->param('city_id');
            $renk_id = $this->request->param('renk_id');
            $result = get_user_and_userjs($user_id,$district_id,$city_id,$renk_id);
            $where['id'] = $result['user_js_ids'];
        
            $page = $this->request->param('page',1);
            $user_list = $UserModel::with('jsStatus')->where($where)->field('id,mobile,user_nickname,avatar,create_time')->order('id','desc')->page($page,20)->select()->each(function ($user_list){
                $user_list['mobile'] = preg_replace("/(\d{3})\d{4}(\d{4})/", "\$1****\$2", $user_list['mobile']);
                if(!$user_list->js_status){
                    $user_list->js_status = ['js_status'=>0];
                }
                return $user_list;
            });
       
            $this->success('ok',$user_list);
        }
    
        /**
         *技师订单列表
         */
        public function getOrder()
        {
            $user_id = $this->getUserId();
            $UserModel = new UserModel();
            $agency_id = $UserModel::get($user_id)['agency_id'];
            $district_id = $this->request->param('district_id');
            $city_id = $this->request->param('city_id');
            $renk_id = $this->request->param('renk_id');
            if(!$agency_id){
                $this->error('您还不是代理商!');
            }
            $result = get_user_and_userjs($user_id,$district_id,$city_id,$renk_id);
            $JsOrderModel = new JsOrderModel();
            $page = $this->request->param('page',1);
         
            $list = $JsOrderModel::with('project.tag')->where('user_id','in',$result['user_js_ids'])->order('id','desc')->page($page,20)->select();
            $this->success('ok',$list);
        }
    
        
        /**
         * 报警列表
         */
        
        public function getCallList()
        {
            $user_id = $this->getUserId();
            $UserModel = new UserModel();
            $agency_id = $UserModel::get($user_id)['agency_id'];
            $district_id = $this->request->param('district_id');
            if(!$agency_id){
                $this->error('您还不是代理商!');
            }
        
            $city_id = $this->request->param('city_id');
            $renk_id = $this->request->param('renk_id');
            $result = get_user_and_userjs($user_id,$district_id,$city_id,$renk_id);
            $agency_is_look = $this->request->param('agency_is_look',0);
            $page = $this->request->param('page',1);
            $JsCallModel = new JsCallModel();
            $list = $JsCallModel::with('js_user,jsOrder.project')->where('user_id','in',$result['user_js_ids'])->where('agency_is_look',$agency_is_look)->order('id','desc')->page($page,20)->select();
            $this->success('ok',$list);
        }
        
        /**
         * 获取代理的地区
         */
        
        public function getDistrict()
        {
            $user_id = $this->getUserId();
            $agency_id = UserModel::get($user_id)['agency_id'];
    
            if(!$agency_id){
                $this->error('您还不是代理商!');
            }
            $agency_ids = UserModel::where('id',$user_id)->value('agency_id');
   
            $agency_ids_array = explode(',',$agency_ids);

            $list = Db::name('agency')->where('id','in',$agency_ids_array)->field('id,renk_id,city_id,district_id')->select()->each(function ($list){
                if($list['renk_id'] == 1){
                    $list['cityName'] = Db::name('region')->where('id',$list['city_id'])->value('cityName');
                }
                if($list['renk_id'] == 2){
                    $list['cityName'] = Db::name('region')->where('id',$list['district_id'])->value('cityName');
                }
                return $list;
            });
            $this->success('ok',$list);
        }
        
    }