guoyao-jiankang/application/admin/controller/Index.php

<?php
namespace app\admin\controller;

use app\common\model\Config;
use think\Db;

class Index extends Auth
{

    public function index(){
        $menus = model('Menu')->getMenuTree($this->rolesId,$this->orgId);
        $this->assign('menus',$menus);
        $userInfo = Db::name('user')
            ->where('id',$this->userId)
            ->find();
        $this->assign('userInfo',$userInfo);

        // 判断用户是否是调度
        $isDispatch = 0;
        if(check_is_dispatch($this->userId) || check_two_dispatch($this->userId)){
            $isDispatch = 1;
        }
        $this->assign('isDispatch',$isDispatch);

        $order = 0;
        // 判断用户是否是调度
        $level1 = check_is_dispatch($this->userId);
        $level2 = check_two_dispatch($this->userId);
        $level2onoff = two_dispatch_off($this->orgId);
        if(!$level1 && !$level2){
            $order = -1;
        }else{
            // 一级调度
            if($level1 || (!$level2onoff && $level2)){
                $map[] = ['org_id','=',$this->orgId];
                $map[] = ['del','=',0];
                $map[] = ['order_mode','=',1];
                if($level2onoff){
                    $map[] = ['is_deal','=',0];
                }
                if(!is_admin($this->userId)){
                    $auth = get_dispatch_auth($this->userId);
                    if($auth){
                        $map[] = ['work_type_mode', 'in', $auth];
                        $where[] = ['o.work_type_mode', 'in', $auth];
                    }else{
                        $map[] = ['work_type_mode', '=', -1];
                        $where[] = ['o.work_type_mode', '=', -1];
                    }
                }
                $order = Db::name('orders')->where($map)->count();

                //$驳回的订单
                $where[] = ['o.del','=',0];
                $where[] = ['t.del','=',0];
                $bh = Db::name('orders')
                    ->alias('o')
                    ->join('todo t','t.order_id=o.id')
                    ->where('t.todo_mode',4)
                    ->where('t.org_id',$this->orgId)
                    ->where('o.order_mode',4)
                    ->where('o.org_id',$this->orgId)
                    ->where($where)
                    ->group('o.id')
                    ->count();

                $order = $order + $bh;

            } else if($level2 && $level2onoff) { // 二级调度
                $rolesId = Db::name('user_roles')->where('user_id',$this->userId)->value('roles_id');
                if(!$rolesId){
                    $order = 0;
                }else{
                    $map[] = ['b.org_id','=',$this->orgId];
                    $map[] = ['b.del','=',0];
                    $map[] = ['b.order_mode','=',1];
                    $map[] = ['b.is_deal','=',1];
                    $map[] = ['a.roles_id','=',$rolesId];
                    if(!is_admin($this->userId)){
                        $auth = get_dispatch_auth($this->userId);
                        if($auth){
                            $map[] = ['b.work_type_mode', 'in', $auth];
                        }else{
                            $map[] = ['b.work_type_mode', '=', -1];
                        }
                    }
                    $order = Db::name('dispatch_log')
                        ->alias('a')
                        ->join('orders b','b.id = a.order_id')
                        ->where($map)
                        ->field('a.*')
                        ->count();
                }

            }
        }
        $complainCount = Db::name('complain')->where('del',0)->where('org_id',$this->orgId)->where('status',0)->where('order_id',0)->count();
        $hiddendangerCount = Db::name('hiddendanger')->where('del',0)->where('org_id',$this->orgId)->where('status',0)->where('order_id',0)->count();
        $endCount = $order+$complainCount+$hiddendangerCount;

        $this->assign('orderNums',$endCount);


        //今日看板
        $dayOrderNums1 = Db::name('orders')
            ->where('org_id',$this->orgId)
            ->where('del',0)
            ->where('order_mode',1)
            ->where('create_time','>=',date('Y-m-d').' 00:00:00')
            ->where('create_time','<=',date('Y-m-d').' 23:59:59')
            ->count();
        $dayOrderNums2 = Db::name('orders')
            ->where('org_id',$this->orgId)
            ->where('del',0)
            ->where('order_mode',4)
            ->where('create_time','>=',date('Y-m-d').' 00:00:00')
            ->where('create_time','<=',date('Y-m-d').' 23:59:59')
            ->count();
        $dayOrderNums3 = Db::name('orders')
            ->where('org_id',$this->orgId)
            ->where('del',0)
            ->where('order_mode',5)
            ->where('create_time','>=',date('Y-m-d').' 00:00:00')
            ->where('create_time','<=',date('Y-m-d').' 23:59:59')
            ->count();
        $dayOrderNums4 = Db::name('orders')
            ->where('org_id',$this->orgId)
            ->where('del',0)
            ->where('order_mode',6)
            ->where('create_time','>=',date('Y-m-d').' 00:00:00')
            ->where('create_time','<=',date('Y-m-d').' 23:59:59')
            ->count();
        $dayOrderNums5 = Db::name('orders')
            ->where('org_id',$this->orgId)
            ->where('del',0)
            ->where('order_mode',2)
            ->where('create_time','>=',date('Y-m-d').' 00:00:00')
            ->where('create_time','<=',date('Y-m-d').' 23:59:59')
            ->count();
        $dayOrderNums6 = Db::name('orders')
            ->where('org_id',$this->orgId)
            ->where('del',0)
            ->where('order_mode',3)
            ->where('create_time','>=',date('Y-m-d').' 00:00:00')
            ->where('create_time','<=',date('Y-m-d').' 23:59:59')
            ->count();
        $dayOrderCount =[
            'count1'=> $dayOrderNums1,
            'count2'=> $dayOrderNums2,
            'count3'=> $dayOrderNums3,
            'count4'=> $dayOrderNums4,
            'count5'=> $dayOrderNums5,
            'count6'=> $dayOrderNums6,
        ];
        $this->assign('dayOrderCount',$dayOrderCount);

        $notice = Db::name('notice')
            ->where('org_id',$this->orgId)
            ->where('del',0)
            ->where('user_id',$this->userId)
            ->field('id,title,create_time')
            ->order('id desc')
            ->limit(2)
            ->select();
        $this->assign('notice',$notice);

        //常用模块
        $module = Db::name('user_menu')->where('user_id',$this->userId)->order('count desc')->select();
        $id = 500;
        $menus = model('Menu')->getMenuTree($this->rolesId,$this->orgId);
        $submenus = [];
        foreach ($menus as $k=>$v){
            if($v['id'] == $id){
                $submenus = $v['child'];
                break;
            }
        }
        $lists11 = [];
        foreach ($submenus as $k=>$v){
//            if(!$v['url']){
//                $v['url'] = url('Index/submenu',['id'=>$v['id'],'t'=>1]);
//            }
            $lists11[] = $v;
        }

        $limit = 8;
        $modules = [];
        foreach ($module as $k=>$v){
            foreach ($lists11 as $kk=>$vv){
                if(count($modules) == $limit){
                    continue;
                }
                if($vv['id'] == $v['menu_id']){
                    $v['title'] = $vv['title'];
                    $v['url'] = $vv['url'];
                    $v['img'] = $vv['img'];
                    $modules[] = $v;
                    break;
                }
            }
        }

        $this->assign('module',$modules);

        $threeMenu = model('Menu')->getMenuTree1($this->rolesId,$this->orgId,'');
        $userEndMenu = [];
        foreach ($threeMenu as $k=>$v){
            if($v['url']){
                $userEndMenu[] = $v;
            }
        }

        $this->assign('userEndMenu',$userEndMenu);

        $authMenuIds = array_column($threeMenu,'id');

        //固定模块
        $fixedModule = Db::name('menu')
            ->where('id',500)
            ->where('del',0)
            ->find();


        $fixedModule1 = Db::name('menu')
            ->where('id',1)
            ->where('del',0)
            ->find();

        $fixedModule2 = Db::name('menu')
            ->where('id',144)
            ->where('del',0)
            ->find();

        $fixedModule3 = Db::name('menu')
            ->where('id',163)
            ->where('del',0)
            ->find();

        $fixedModule4 = Db::name('menu')
            ->where('id',28)
            ->where('del',0)
            ->find();
        $fixedModuleAuth = $fixedModuleAuth1 = $fixedModuleAuth2 = $fixedModuleAuth3 = $fixedModuleAuth4 = 0 ;
        if(in_array($fixedModule['id'],$authMenuIds)){
            $fixedModuleAuth = 1 ;
        }
        if(in_array($fixedModule1['id'],$authMenuIds)){
            $fixedModuleAuth1 = 1 ;
        }
        if(in_array($fixedModule2['id'],$authMenuIds)){
            $fixedModuleAuth2 = 1 ;
        }
        if(in_array($fixedModule3['id'],$authMenuIds)){
            $fixedModuleAuth3 = 1 ;
        }
        if(in_array($fixedModule4['id'],$authMenuIds)){
            $fixedModuleAuth4 = 1 ;
        }

        $this->assign('fixedModule',$fixedModule);
        $this->assign('fixedModule1',$fixedModule1);
        $this->assign('fixedModule2',$fixedModule2);
        $this->assign('fixedModule3',$fixedModule3);
        $this->assign('fixedModule4',$fixedModule4);

        $this->assign('fixedModuleAuth',$fixedModuleAuth);
        $this->assign('fixedModuleAuth1',$fixedModuleAuth1);
        $this->assign('fixedModuleAuth2',$fixedModuleAuth2);
        $this->assign('fixedModuleAuth3',$fixedModuleAuth3);
        $this->assign('fixedModuleAuth4',$fixedModuleAuth4);



        // APP下载二维码
        $download = think_encrypt(url('h5/Index/download','',true,true));
        $this->assign('download',$download);
        // 小程序二维码
        $wxcode = Db::name('org')->where('id',$this->orgId)->value('wxqrcode');
        $this->assign('wxcode',$wxcode);
        // 陪护h5
        $phcode = think_encrypt(config('app.ph_url').'?orgId='.$this->orgId);
        $this->assign('phcode',$phcode);
        // 点餐h5
        $shopcode = think_encrypt(config('app.shop_url').'?orgId='.$this->orgId);
        $this->assign('shopcode',$shopcode);

        // 商城h5
        $xshopcode = think_encrypt(config('app.xshop_url').'?orgId='.$this->orgId);
        $this->assign('xshopcode',$xshopcode);



        return $this->fetch();
    }

    public function ocount(){
        $order = 0;
        // 判断用户是否是调度
        $level1 = check_is_dispatch($this->userId);
        $level2 = check_two_dispatch($this->userId);
        $level2onoff = two_dispatch_off($this->orgId);
        if(!$level1 && !$level2){
            $order = -1;
        }else{
            // 一级调度
            if($level1 || (!$level2onoff && $level2)){
                $map[] = ['org_id','=',$this->orgId];
                $map[] = ['del','=',0];
                $map[] = ['order_mode','=',1];
                if($level2onoff){
                    $map[] = ['is_deal','=',0];
                }
                if(!is_admin($this->userId)){
                    $auth = get_dispatch_auth($this->userId);
                    if($auth){
                        $map[] = ['work_type_mode', 'in', $auth];
                        $where[] = ['o.work_type_mode', 'in', $auth];
                    }else{
                        $map[] = ['work_type_mode', '=', -1];
                        $where[] = ['work_type_mode', '=', -1];
                    }
                }
                $order = Db::name('orders')->where($map)->count();

                //$驳回的订单
                $where[] = ['o.del','=',0];
                $where[] = ['t.del','=',0];
                $bh = Db::name('orders')
                    ->alias('o')
                    ->join('todo t','t.order_id=o.id')
                    ->where('t.todo_mode',4)
                    ->where('t.org_id',$this->orgId)
                    ->where('o.order_mode',4)
                    ->where('o.org_id',$this->orgId)
                    ->where($where)
                    ->group('o.id')
                    ->count();

                $order = $order + $bh;

            } else if($level2 && $level2onoff) { // 二级调度
                $rolesId = Db::name('user_roles')->where('user_id',$this->userId)->value('roles_id');
                if(!$rolesId){
                    $order = 0;
                }else{
                    $map[] = ['b.org_id','=',$this->orgId];
                    $map[] = ['b.del','=',0];
                    $map[] = ['b.order_mode','=',1];
                    $map[] = ['b.is_deal','=',1];
                    $map[] = ['a.roles_id','=',$rolesId];
                    if(!is_admin($this->userId)){
                        $auth = get_dispatch_auth($this->userId);
                        if($auth){
                            $map[] = ['b.work_type_mode', 'in', $auth];
                        }else{
                            $map[] = ['b.work_type_mode', '=', -1];
                        }
                    }
                    $order = Db::name('dispatch_log')
                        ->alias('a')
                        ->join('orders b','b.id = a.order_id')
                        ->where($map)
                        ->field('a.*')
                        ->count();
                }

            }

            $complainCount = Db::name('complain')->where('del',0)->where('org_id',$this->orgId)->where('status',0)->where('order_id',0)->count();
            $hiddendangerCount = Db::name('hiddendanger')->where('del',0)->where('org_id',$this->orgId)->where('status',0)->where('order_id',0)->count();
            $endCount = $order+$complainCount+$hiddendangerCount;
        }
        $this->success('成功','',['count'=>$endCount]);
    }

    public function def(){
        $id = 500;
        $menus = model('Menu')->getMenuTree($this->rolesId,$this->orgId);
        $submenus = [];
        foreach ($menus as $k=>$v){
            if($v['id'] == $id){
                $submenus = $v['child'];
                break;
            }
        }
        $lists = [];
        foreach ($submenus as $k=>$v){
            if(!$v['url']){
//                $v['url'] = url('Index/indexsub',['id'=>$v['id'],'t'=>1]);
            }
            $lists[] = $v;
        }
        $this->assign('lists',$lists);

        // 获取常用模块
        $cys = Db::name('user_menu')
            ->where('user_id',$this->userId)
            ->order('count desc,id asc')
            ->select();

        $cys = $cys?$cys:[];
        $ncys = [];
        foreach ($cys as $k=>$v){
            foreach ($lists as $kk=>$vv){
                if(count($ncys) == 5){
                    continue;
                }
                if($vv['id'] == $v['menu_id']){
                    $v['title'] = $vv['title'];
                    $v['url'] = $vv['url'];
                    $v['img'] = $vv['img'];
                    $ncys[] = $v;
                    break;
                }
            }
        }
        $this->assign('cys',$ncys);

        // 自定义模块
        $usermenus = Db::name('user_menu_group')->where('user_id',$this->userId)->order('sort asc,id asc')->select();

        $usermenus = $usermenus?$usermenus:[];

        $groupMenuList = $usermenus;
        $allmenus = [];
        foreach ($usermenus as $k=>$v){
            $menus = [];
            if($v['menus']){
                $menuids = explode(',',$v['menus']);
                $allmenus = array_merge($allmenus,$menuids);
                foreach ($lists as $kk=>$vv){
                    if(in_array($vv['id'],$menuids)){
                        $menus[] = $vv;
                    }
                }
            }
            $usermenus[$k]['menus'] = $menus;
        }
        $menus = [];
        foreach ($lists as $kk=>$vv){
            if(!$allmenus || !in_array($vv['id'],$allmenus)){
                $menus[] = $vv;
            }
        }

        $usermenus[] = [
            'id' => 0,
            'title' => '综合模块',
            'menus' => $menus
        ];



        $arr[] = [
            'id'=>0,
            'title'=>'综合模块',
        ];

        $this->assign('usermenusgroup',array_merge($arr,$groupMenuList));
        $this->assign('usermenus',$usermenus);




        return $this->fetch();
    }

    public function todo(){
        $mode = input('mode',1);
        $todoList = Db::name('todo')
            ->where('org_id',$this->orgId)
            ->where('del',0)
            ->where('work_type_mode',$mode)
            ->limit(11)
            ->order('id desc')
            ->select();
        foreach ($todoList as $k=>$v){
            $todoList[$k]['work_type_mode_text'] = Db::name('work_type_mode')->where('id',$v['work_type_mode'])->value('name');
            $todoList[$k]['to_user_name'] = Db::name('user')->where('id',$v['to_user_id'])->value('real_name');
            $todoList[$k]['user_name'] = Db::name('user')->where('id',$v['create_user_id'])->value('real_name');
            $todoList[$k]['content'] = Db::name('orders')->where('id',$v['order_id'])->value('content');
            $todomode = Db::name('todo_mode')->where('id',$v['todo_mode'])->find();
            $todoList[$k]['todo_mode_text'] = $todomode?$todomode['in_content']:'';
            $todoList[$k]['todo_mode_color'] = $todomode?$todomode['color']:'';
        }

        //数据返回
        $totalCount = count($todoList);
        $totalPage = 1;
        $result['page'] = 1;
        $result['total'] = $totalPage;
        $result['records'] = $totalCount;
        $result['rows'] = $todoList;
        return json($result);
    }

    public function attendanceCount1(){
        $group = Db::name('attendance_group')
            ->where('del',0)
            ->where('org_id',$this->orgId)
            ->select();

        $groupsId = [];
        $groupsId2 = [];
        $week = date('w');
        foreach ($group as $k=>$v){
            $content = json_decode($v['content'],true);
            if($v['type'] == 1){
                foreach ($content['week'] as $kk=>$vv){
                    if($vv['week'] == $week && $vv['class_id'] > 0){
                        $groupsId[] = $v['id'];
                    }
                }
            }
            if($v['type'] == 2){
                $groupClass = Db::name('attendance_group_class')
                    ->where('group_id',$v['id'])
                    ->where('org_id',$this->orgId)
                    ->where('day',date('Y-m-d'))
                    ->find();
                if($groupClass){
                    $groupsId2[] = $v['id'];
                }
            }
        }
        $endGroupIds = array_unique(array_merge($groupsId,$groupsId2));
        $userCount = Db::name('attendance_group_user')
            ->where('org_id',$this->orgId)
            ->whereIn('group_id',$endGroupIds)
            ->count();
        $userIds = Db::name('attendance_group_user')
            ->where('org_id',$this->orgId)
            ->whereIn('group_id',$endGroupIds)
            ->column('user_id');
        $attendanceNums = 0;
        foreach ($userIds as $k=>$v){
            $attendanceRecord = Db::name('attendance_record')
                ->where('user_id',$v)
                ->where('org_id',$this->orgId)
//                ->where('status',1)
                ->where('create_time','>=',date('Y-m-d').' 00:00:00')
                ->where('create_time','<=',date('Y-m-d').' 23:59:59')
                ->select();
            $flag = 0;
            if($attendanceRecord){
                foreach ($attendanceRecord as $kk=>$vv){
                    if($vv['status'] == 1){

                    }else{
                        $flag = 1;
                    }
                }
                if($flag == 0){
                    $attendanceNums +=1;
                }
            }
        }
        $attendanceNums3 = $userCount-$attendanceNums;
        $attendanceCount1 = [
            'count1' => $userCount, //总人数
            'count2' => $attendanceNums, //在职人数
            'count3' => $attendanceNums3>0?$attendanceNums3:0, //缺勤人数
            'bl' => $userCount>0?round($attendanceNums/$userCount,2)*100:0,
            'bl2' => $userCount>0?round($attendanceNums3/$userCount,2)*100:0,
        ];

        $this->success('','',$attendanceCount1);
    }

    public function changeOrg(){
        if(request()->isAjax()){
            $id = input('id/d');
            $info = Db::name('org')->where('id',$id)->find();
            if($info['type'] != 2){
                $this->error('管理机构不能切换');
            }

            session('orgId',$info['id']);
            session('orgName',$info['name']);
            $this->success('切换成功');

        }else{
            $tree = model('Org')->getTreeByRoles($this->rolesId,$this->userId);
            $this->assign('tree',$tree);
            return $this->fetch();
        }
    }

    public function order(){
        // 判断用户是否是调度
        $level1 = check_is_dispatch($this->userId);
        $level2 = check_two_dispatch($this->userId);
        $level2onoff = two_dispatch_off($this->orgId);
        if(!$level1 && !$level2){
            $this->error('不是调度');
        }
        $order = 0;
        // 一级调度
        if($level1 || (!$level2onoff && $level2)){
            $map[] = ['org_id','=',$this->orgId];
            $map[] = ['del','=',0];
            $map[] = ['order_mode','=',1];
            if($level2onoff){
                $map[] = ['is_deal','=',0];
            }
            if(!is_admin($this->userId)){
                $auth = get_dispatch_auth($this->userId);
                if($auth){
                    $map[] = ['work_type_mode', 'in', $auth];
                    $where[] = ['o.work_type_mode', 'in', $auth];
                }else{
                    $map[] = ['work_type_mode', '=', -1];
                    $where[] = ['o.work_type_mode', '=', -1];
                }
            }
            $order = Db::name('orders')->where($map)->count();


            //$驳回的订单
            $where[] = ['o.del','=',0];
            $where[] = ['t.del','=',0];
            $bh = Db::name('orders')
                ->alias('o')
                ->join('todo t','t.order_id=o.id')
                ->where('t.todo_mode',4)
                ->where('t.org_id',$this->orgId)
                ->where('o.order_mode',4)
                ->where('o.org_id',$this->orgId)
                ->where($where)
                ->group('o.id')
                ->count();

            $order = $order + $bh;
        } else if($level2 && $level2onoff) { // 二级调度
            $rolesId = Db::name('user_roles')->where('user_id',$this->userId)->value('roles_id');
            if(!$rolesId){
                $this->error('无订单');
            }
            $map[] = ['b.org_id','=',$this->orgId];
            $map[] = ['b.del','=',0];
            $map[] = ['b.order_mode','=',1];
            $map[] = ['b.is_deal','=',1];
            $map[] = ['a.roles_id','=',$rolesId];
            if(!is_admin($this->userId)){
                $auth = get_dispatch_auth($this->userId);
                if($auth){
                    $map[] = ['b.work_type_mode', 'in', $auth];
                }else{
                    $map[] = ['b.work_type_mode', '=', -1];
                }
            }
            $order = Db::name('dispatch_log')
                ->alias('a')
                ->join('orders b','b.id = a.order_id')
                ->where($map)
                ->field('a.*')
                ->count();
        }

        $complainCount = Db::name('complain')->where('del',0)->where('org_id',$this->orgId)->where('status',0)->where('order_id',0)->count();
        $hiddendangerCount = Db::name('hiddendanger')->where('del',0)->where('org_id',$this->orgId)->where('status',0)->where('order_id',0)->count();
        $endCount = $order+$complainCount+$hiddendangerCount;

        if(!empty($endCount)){
            $this->success('','',$endCount);
        }else{
            $this->error('无订单');
        }
    }

    public function ordersList() {
        $orderType = input('orderType',1);
        $mode = input('mode', 0);
        $level1 = check_is_dispatch($this->userId);
        $level2 = check_two_dispatch($this->userId);
        $turnoff = two_dispatch_off($this->orgId);
        if (request()->isAjax()) {

            //分页参数
            $length = input('rows', 10, 'intval');   //每页条数
            $page = input('page', 1, 'intval');      //第几页
            $start = ($page - 1) * $length;     //分页开始位置
            //排序
            $sortRow = input('sidx', 'id', 'trim');      //排序列
            $sort = input('sord', 'desc', 'trim');        //排序方式
            $order = $sortRow . ' ' . $sort;

            if($orderType == 1){
                $content = input('content', '', 'trim');
                if ($content) {
                    $map[] = ['content', 'like', '%' . $content . '%'];
                }
                $dep_id = input('dep_id', '', 'trim');
                if ($dep_id != '') {
                    $map[] = ['dep_id', '=', $dep_id];
                }
                $order_mode = input('order_mode', 1);
                $map6 = [];
                if ($order_mode != '') {
                    if($level1 && $turnoff && $mode != 15){ // 一级调度且二级调度开关开着,品质整改例外
                        if ($order_mode == 1) {
                            $map[] = ['is_deal', '=', 0];
                        }else if ($order_mode == 4) {
                            $map6[] = ['is_deal', '=', 1];
                        }
                    }
                    if($order_mode==100){//已挂起
                        $gq = Db::name('todo')
                            ->where('work_type_mode',1)
                            ->where('todo_mode',2)
                            ->where('pause',1)
                            ->column('order_id');
                        if(empty($gq)){
                            $map[] = ['id', '=', -1];
                        }else{
                            $map[] = ['id', 'in', $gq];
                        }
                    }else{
                        $map[] = ['order_mode', '=', $order_mode];
                    }
                }
                $b = input('start', '', 'trim');
                $e = input('end', '', 'trim');
                if ($b) {
                    $b = date('Ymd', strtotime($b));
                    $map[] = ['create_yyyymmdd', '>=', $b];
                }
                if ($e) {
                    $e = date('Ymd', strtotime($e));
                    $map[] = ['create_yyyymmdd', '<=', $e];
                }

                $map[] = ['del', '=', 0];
                $map[] = ['org_id', '=', $this->orgId];
                if($mode==-1){
                    $map[] = ['source_type', '=', 4];
                }
                $type = input('type', '', 'trim');
                $oids = [];
                if ($type != '') {
                    $map1[] = ['parent_id', '=', $type];
                    $type_id = Db::name('order_type')
                        ->where($map1)
                        ->where('org_id', $this->orgId)
                        ->where('enable', 1)
                        ->column('id');
                    if (!empty($type_id)) {
                        $map3[] = ['type_id', 'in', $type_id];
                        $ids = Db::name('order_repair')
                            ->where($map3)
                            ->column('order_id');
                        if (!empty($ids)) {
                            $oids = $ids;
                        }
                        else {
                            $oids = [];
                        }
                    }
                    else {
                        $oids = [];
                    }
                }

                if($level2 && $turnoff){ // 二级调度
                    $roles_id = Db::name('user_roles')
                        ->where('user_id', $this->userId)
                        ->value('roles_id');
                    $ids = Db::name('dispatch_log')
                        ->where('roles_id', $roles_id)
                        ->whereOr('to_user_id', $this->userId)
                        ->column('order_id');
                    if (empty($ids)) {
                        $map[] = ['id', '=', -1];
                    } else {
                        if($type != ''){
                            $oids = array_intersect($oids,$ids);
                            if($oids){
                                $map[] = ['id', 'in', $oids];
                            }else{
                                $map[] = ['id', '=', -1];
                            }
                        }else{
                            $map[] = ['id', 'in', $ids];

                        }
                    }
                }else{
                    if($type != ''){
                        if($oids){
                            $map[] = ['id', 'in', $oids];
                        }else{
                            $map[] = ['id', '=', 0];
                        }
                    }
                }
                if($mode == 15){ // 品质检查,单独处理
                    $map[] = ['work_type_mode','=',$mode];
                }else{
                    $work_type_mode = input('work_type_mode','','trim');
                    if(!is_admin($this->userId)){
                        $auth = get_dispatch_auth($this->userId);
                        if($auth){
                            $map[] = ['work_type_mode', 'in', $auth];
                            if($mode > 0){
                                $map[] = ['work_type_mode', '=', $mode];
                            }else{
                                if($work_type_mode!=''){
                                    $map[] = ['work_type_mode','=',$work_type_mode];
                                }
                            }
                        }else{
                            $map[] = ['work_type_mode', '=', -1];
                        }
                    }else{
                        if($mode > 0){
                            $map[] = ['work_type_mode', '=', $mode];
                        }else{
                            if($work_type_mode!=''){
                                $map[] = ['work_type_mode','=',$work_type_mode];
                            }
                        }
                    }
                }


                $map = empty($map) ? true : $map;
                //数据查询
                $lists = db('orders')->where($map)
                    ->whereOr($map6)
                    ->limit($start, $length)->order($order)->select();

                foreach ($lists as $k => $v) {

                    $lists[$k] = model('orders')->formatOrder($v);

                    if ($turnoff && $level1 && $v['order_mode'] == 1 && $v['is_deal'] == 1) {
                        $lists[$k]['order_mode_text'] = '已派发';
                    }
                    $lists[$k]['bh_nums'] = Db::name('todo')->where('order_id',$v['id'])->where('del',0)->where('todo_mode',4)->count();
                    $gq = Db::name('todo')
                        ->where('order_id',$v['id'])
                        ->where('work_type_mode',1)
                        ->where('todo_mode',2)
                        ->where('pause',1)
                        ->find();
                    $lists[$k]['gq'] = $gq?'存在挂起':'';
                }

                //数据返回
                $totalCount = db('orders')->where($map)->count();
            }elseif($orderType == 2){

                $map[] = ['del','=',0];
                $map[] = ['org_id','=',$this->orgId];

                $hour = (new Config())->getConfig('org_complain_hour',$this->orgId);
                $hour = $hour>0?$hour:0;
                $endTime = date('Y-m-d H:i:s',time() - $hour*60*60);
                $type = input('type/d',0);
                if($hour > 0 && $type == 1){
                    $map[] = ['create_time','<',$endTime];
                    $map[] = ['status','=',0];
                }
                $from = input('from', '', 'trim');
                if ($from!='') {
                    $map[] = ['from','=',$from];
                }
                $map[] = ['status','=',0];
                $map[] = ['order_id','=',0];
                $map= empty($map) ? true: $map;
                //数据查询
                $lists = db('complain')->where($map)
                    ->limit($start,$length)->order($order)->select();

                foreach ($lists as $k=>$v){
                    $lists[$k]['depName'] = Db::name('dep')
                        ->where('id',$v['dep_id'])
                        ->value('title');
//                    $lists[$k]['fromName'] = model('Complain')->from[$v['from']];

                    $lists[$k]['fromName'] = '';
                    if($v['order_id'] > 0  && $v['bus_type'] != 0){
                        if($v['to_from']){
                            $lists[$k]['fromName'] = '一键呼叫';
                        }else{
                            $lists[$k]['fromName'] = '隐患';
                        }
                    }

                    $lists[$k]['worktypemode'] = '';
                    if($v['order_id'] > 0 && in_array($v['bus_type'],[0,1])){
                        $worktype = Db::name('orders')
                            ->alias('o')
                            ->join('work_type_mode w','o.work_type_mode = w.id')
                            ->where('o.id',$v['order_id'])
                            ->value('w.name');
                        $lists[$k]['worktypemode'] = $worktype?$worktype:'';
                    }

                    if($v['hide'] == 1){
                        $lists[$k]['realName'] = '匿名';
                    }else{
                        $lists[$k]['realName'] = Db::name('user')
                            ->where('id',$v['create_user_id'])
                            ->value('real_name');
                    }

                    $orderMode = 0;
                    if($v['order_id'] > 0){
                        $orderMode = Db::name('orders')->where('id',$v['order_id'])->value('order_mode');
                    }

                    $lists[$k]['statusTxt'] = model('Complain')->formatStatus($v['status'],$v['order_id'],$v['id']);
                    $lists[$k]['order_mode'] = $orderMode;

                    if($v['create_time'] < $endTime && $v['status']==0){
                        $lists[$k]['statusTxt'] = $lists[$k]['statusTxt'].'<span style="color:red;">(已超时)</span>';
                    }

                }
                //数据返回
                $totalCount = db('complain')->where($map)->count();
            }elseif ($orderType == 3){
                $map[] = ['del','=',0];
                $map[] = ['org_id','=',$this->orgId];
                $map[] = ['status','=',0];
                $map[] = ['order_id','=',0];
                $from = input('from', '', 'trim');
                if ($from!='') {
                    $map[] = ['from','=',$from];
                }
                $map= empty($map) ? true: $map;
                //数据查询
                $lists = db('hiddendanger')->where($map)
                    ->limit($start,$length)->order($order)->select();
                foreach ($lists as $k=>$v){
                    $lists[$k]['depName'] = Db::name('dep')
                        ->where('id',$v['dep_id'])
                        ->value('title');
//                    $lists[$k]['fromName'] = model('Hiddendanger')->from[$v['from']];
                    $lists[$k]['fromName'] = '';
                    if($v['order_id'] > 0 && $v['bus_type'] != 0){
                        if($v['to_from']){
                            $lists[$k]['fromName'] = '一键呼叫';
                        }else{
                            $lists[$k]['fromName'] = '投诉';
                        }
                    }
                    $lists[$k]['worktypemode'] = '';
                    if($v['order_id'] > 0 && in_array($v['bus_type'],[0,1])){
                        $worktype = Db::name('orders')
                            ->alias('o')
                            ->join('work_type_mode w','o.work_type_mode = w.id')
                            ->where('o.id',$v['order_id'])
                            ->value('w.name');
                        $lists[$k]['worktypemode'] = $worktype?$worktype:'';
                    }
                    $lists[$k]['realName'] = Db::name('user')
                        ->where('id',$v['create_user_id'])
                        ->value('real_name');
//                $lists[$k]['statusTxt'] = $v['status']==1?'已处理':"未处理";
                    $orderMode = 0;
                    if($v['order_id'] > 0){
                        $orderMode = Db::name('orders')->where('id',$v['order_id'])->value('order_mode');
                    }

                    $lists[$k]['statusTxt'] = model('Hiddendanger')->formatStatus($v['status'],$v['order_id'],$v['id']);
                    $lists[$k]['order_mode'] = $orderMode;
                }
                //数据返回
                $totalCount = db('hiddendanger')->where($map)->count();
            }elseif($orderType == 4){

                $order_mode = input('order_mode', 4);
                $map6 = [];
                if ($order_mode != '') {
                    if($level1 && $turnoff && $mode != 15){ // 一级调度且二级调度开关开着,品质整改例外
                        if ($order_mode == 1) {
                            $map[] = ['is_deal', '=', 0];
                        }else if ($order_mode == 4) {
                            $map6[] = ['is_deal', '=', 1];
                        }
                    }
                    if($order_mode==100){//已挂起
                        $gq = Db::name('todo')
                            ->where('work_type_mode',1)
                            ->where('todo_mode',2)
                            ->where('pause',1)
                            ->column('order_id');
                        if(empty($gq)){
                            $map[] = ['id', '=', -1];
                        }else{
                            $map[] = ['id', 'in', $gq];
                        }
                    }else{
                        $map[] = ['order_mode', '=', $order_mode];
                    }
                }
                $map[] = ['del', '=', 0];
                $map[] = ['org_id', '=', $this->orgId];
                if($mode==-1){
                    $map[] = ['source_type', '=', 4];
                }
                $type = input('type', '', 'trim');
                $oids = [];
                if ($type != '') {
                    $map1[] = ['parent_id', '=', $type];
                    $type_id = Db::name('order_type')
                        ->where($map1)
                        ->where('org_id', $this->orgId)
                        ->where('enable', 1)
                        ->column('id');
                    if (!empty($type_id)) {
                        $map3[] = ['type_id', 'in', $type_id];
                        $ids = Db::name('order_repair')
                            ->where($map3)
                            ->column('order_id');
                        if (!empty($ids)) {
                            $oids = $ids;
                        }
                        else {
                            $oids = [];
                        }
                    }
                    else {
                        $oids = [];
                    }
                }

                if($level2 && $turnoff){ // 二级调度
                    $roles_id = Db::name('user_roles')
                        ->where('user_id', $this->userId)
                        ->value('roles_id');
                    $ids = Db::name('dispatch_log')
                        ->where('roles_id', $roles_id)
                        ->whereOr('to_user_id', $this->userId)
                        ->column('order_id');
                    if (empty($ids)) {
                        $map[] = ['id', '=', -1];
                    } else {
                        if($type != ''){
                            $oids = array_intersect($oids,$ids);
                            if($oids){
                                $map[] = ['id', 'in', $oids];
                            }else{
                                $map[] = ['id', '=', -1];
                            }
                        }else{
                            $map[] = ['id', 'in', $ids];

                        }
                    }
                }else{
                    if($type != ''){
                        if($oids){
                            $map[] = ['id', 'in', $oids];
                        }else{
                            $map[] = ['id', '=', 0];
                        }
                    }
                }
                if($mode == 15){ // 品质检查,单独处理
                    $map[] = ['work_type_mode','=',$mode];
                }else{
                    $work_type_mode = input('work_type_mode','','trim');
                    if(!is_admin($this->userId)){
                        $auth = get_dispatch_auth($this->userId);
                        if($auth){
                            $map[] = ['work_type_mode', 'in', $auth];
                            if($mode > 0){
                                $map[] = ['work_type_mode', '=', $mode];
                            }else{
                                if($work_type_mode!=''){
                                    $map[] = ['work_type_mode','=',$work_type_mode];
                                }
                            }
                        }else{
                            $map[] = ['work_type_mode', '=', -1];
                        }
                    }else{
                        if($mode > 0){
                            $map[] = ['work_type_mode', '=', $mode];
                        }else{
                            if($work_type_mode!=''){
                                $map[] = ['work_type_mode','=',$work_type_mode];
                            }
                        }
                    }
                }

                $orderIds = Db::name('todo')
                    ->where('todo_mode',4)
                    ->where('org_id',$this->orgId)
                    ->where('del',0)
                    ->group('order_id')
                    ->column('order_id');

                $map[] = ['id','in',$orderIds];
                $map = empty($map) ? true : $map;
                //数据查询
                $lists = db('orders')
                    ->where($map)
//                    ->whereOr($map6)
                    ->limit($start, $length)
                    ->order($order)
                    ->select();

                foreach ($lists as $k => $v) {

                    $lists[$k] = model('orders')->formatOrder($v);

                    if ($turnoff && $level1 && $v['order_mode'] == 1 && $v['is_deal'] == 1) {
                        $lists[$k]['order_mode_text'] = '已派发';
                    }
                    $lists[$k]['bh_nums'] = Db::name('todo')->where('order_id',$v['id'])->where('del',0)->where('todo_mode',4)->count();
                    $gq = Db::name('todo')
                        ->where('order_id',$v['id'])
                        ->where('work_type_mode',1)
                        ->where('todo_mode',2)
                        ->where('pause',1)
                        ->find();
                    $lists[$k]['gq'] = $gq?'存在挂起':'';
                }

                //数据返回
                $totalCount = db('orders')->where($map)->count();
            }


            $totalPage = ceil($totalCount / $length);
            $result['page'] = $page;
            $result['total'] = $totalPage;
            $result['records'] = $totalCount;
            $result['rows'] = $lists;
            return json($result);
        }
        else {
            if($mode >0){
                $mode_name = $this->getTableField('work_type_mode', ['id' => $mode], 'name');
            }else{
                $mode_name = '';
            }

            $auths = [1,2,3,4,15,0];
            if(!is_admin($this->userId)){
                $auth = get_dispatch_auth($this->userId);
                if($auth){
                    $auths = array_intersect($auths,$auth);
                    if($mode > 0){
                        $auths = array_intersect($auths,[$mode]);
                    }
                }else{
                    $auths = [];
                }
            }
            $this->assign('auths',$auths);

            $dep_list = (new \app\common\model\Dep())->getList();
            $order_type = (new \app\common\model\OrderType())->list();
            $order_mode = Db::name('order_mode')
                ->select();
            $this->assign('dep_list', $dep_list);
            $this->assign('order_type_list', $order_type);
            $this->assign('m_name', $mode_name);
            $this->assign('mode', $mode);
            $this->assign('order_mode_list', $order_mode);
            $this->assign('dispatch_type', check_two_dispatch($this->userId));
            $this->assign('orderType',$orderType);
            return $this->fetch('index/orders');
        }
    }

    //调度查看订单详情
    public function ordersDetail2($id) {
        if (!$id) {
            $this->error('参数错误');
        }
        $type = input('type/d',0);
        $this->assign('type', $type);
        $order = Db::name('orders')->where(['id' => $id])->find();
        $order = model('Orders')->formatOrder($order, 1);
        $order['images'] = !empty($order['images']) ? explode(',', $order['images']) : '';
        $this->assign('info', $order);
        $workTypeName = $this->getTableField('work_type_mode', ['id' => $order['work_type_mode']], 'name');
        $this->assign('meta_title', $workTypeName . '订单详情');
        $level2 = check_two_dispatch($this->userId);
        $level1 = check_is_dispatch($this->userId);
        $turnoff = two_dispatch_off($this->orgId);
        $this->assign('level1', $level1);
        $this->assign('level2', $level2);
        $this->assign('turnoff', $turnoff);
        $this->assign('dispatch_type', $level2);

        return $this->fetch();
    }


    public function searchMenu(){
        $menuName = input('menu_name');
        $list = model('Menu')->getMenuTree1($this->rolesId,$this->orgId,$menuName);

        $tlist = [];
        foreach ($list as $k=>$v){
            if($v['url']){
                $tlist[] = $v;
            }
        }

        $this->success('','',$tlist);
    }
    public function indexsub(){

        $userInfo = Db::name('user')
            ->where('id',$this->userId)
            ->find();
        $this->assign('userInfo',$userInfo);


        $menus = model('Menu')->getMenuTree($this->rolesId,$this->orgId);
        $this->assign('menus',$menus);
        $userInfo = Db::name('user')
            ->where('id',$this->userId)
            ->find();
        $this->assign('userInfo',$userInfo);

        // 判断用户是否是调度
        $isDispatch = 0;
        if(check_is_dispatch($this->userId) || check_two_dispatch($this->userId)){
            $isDispatch = 1;
        }
        $this->assign('isDispatch',$isDispatch);

        $order = 0;
        // 判断用户是否是调度
        $level1 = check_is_dispatch($this->userId);
        $level2 = check_two_dispatch($this->userId);
        $level2onoff = two_dispatch_off($this->orgId);
        if(!$level1 && !$level2){
            $order = -1;
        }else{
            // 一级调度
            if($level1 || (!$level2onoff && $level2)){
                $map[] = ['org_id','=',$this->orgId];
                $map[] = ['del','=',0];
                $map[] = ['order_mode','=',1];
                if($level2onoff){
                    $map[] = ['is_deal','=',0];
                }
                if(!is_admin($this->userId)){
                    $auth = get_dispatch_auth($this->userId);
                    if($auth){
                        $map[] = ['work_type_mode', 'in', $auth];
                        $where[] = ['o.work_type_mode', 'in', $auth];
                    }else{
                        $map[] = ['work_type_mode', '=', -1];
                        $where[] = ['o.work_type_mode', '=', -1];
                    }
                }
                $order = Db::name('orders')->where($map)->count();

                //$驳回的订单
                $where[] = ['o.del','=',0];
                $where[] = ['t.del','=',0];
                $bh = Db::name('orders')
                    ->alias('o')
                    ->join('todo t','t.order_id=o.id')
                    ->where('t.todo_mode',4)
                    ->where('t.org_id',$this->orgId)
                    ->where('o.order_mode',4)
                    ->where('o.org_id',$this->orgId)
                    ->where($where)
                    ->group('o.id')
                    ->count();

                $order = $order + $bh;

            } else if($level2 && $level2onoff) { // 二级调度
                $rolesId = Db::name('user_roles')->where('user_id',$this->userId)->value('roles_id');
                if(!$rolesId){
                    $order = 0;
                }else{
                    $map[] = ['b.org_id','=',$this->orgId];
                    $map[] = ['b.del','=',0];
                    $map[] = ['b.order_mode','=',1];
                    $map[] = ['b.is_deal','=',1];
                    $map[] = ['a.roles_id','=',$rolesId];
                    if(!is_admin($this->userId)){
                        $auth = get_dispatch_auth($this->userId);
                        if($auth){
                            $map[] = ['b.work_type_mode', 'in', $auth];
                        }else{
                            $map[] = ['b.work_type_mode', '=', -1];
                        }
                    }
                    $order = Db::name('dispatch_log')
                        ->alias('a')
                        ->join('orders b','b.id = a.order_id')
                        ->where($map)
                        ->field('a.*')
                        ->count();
                }

            }
        }
        $complainCount = Db::name('complain')->where('del',0)->where('org_id',$this->orgId)->where('status',0)->where('order_id',0)->count();
        $hiddendangerCount = Db::name('hiddendanger')->where('del',0)->where('org_id',$this->orgId)->where('status',0)->where('order_id',0)->count();
        $endCount = $order+$complainCount+$hiddendangerCount;

        $this->assign('orderNums',$endCount);


        return $this->fetch();
    }

    public function menugroup($id = 0){
        if(request()->isPost()){
            $res = model('UserMenuGroup')->updates($this->userId);
            if($res){
                $this->success('操作成功');
            }else{
                $this->error(model('UserMenuGroup')->getError());
            }
        }else{
            if($id){
                $info = db('user_menu_group')->where('id',$id)->find();
                if($info){
                    $info['menus'] = $info['menus']?explode(',',$info['menus']):[];
                }
                $this->assign('info',$info);
            }

            $id = 500;
            $menus = model('Menu')->getMenuTree($this->rolesId,$this->orgId);
            $submenus = [];
            foreach ($menus as $k=>$v){
                if($v['id'] == $id){
                    $submenus = $v['child'];
                    break;
                }
            }
            $this->assign('submenus',$submenus);
            return $this->fetch();
        }
    }

    public function menugroupdel(){
        $id = input('id',0);
        $ret = Db::name('user_menu_group')->where('id',$id)->where('user_id',$this->userId)->delete();
        if($ret){
            $this->success('操作成功');
        }else{
            $this->error('操作失败');
        }
    }

}