jili2/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(){

        $fRolesId = Db::name('roles')->where('id',$this->rolesId)->where('del',0)->value('parent_id');
        $rolesId = $this->rolesId;
        $rid = 0;
        if($fRolesId != 3){
            $menus = model('Menu')->getMenuTree($this->rolesId,$this->orgId);

            $curUrl = 'index/def';
        }else{
            $auths = model('Roles')->getRolesAuths($this->rolesId,1);
            if($auths){
                $map[] = ['id','in',$auths];
            }else{
                $map[] = ['id','=',0];
            }
            if($rolesId!=1){
                /*3.只有admin管理员可见
                系统设置： 菜单管理、配置管理、安卓版本管理、苹果版本管理、
                模块管理、这些项目，在权限分配里面就不要出现了，不需要分配*/
                $map[] = ['id','not in',[37,38,39,47,48]];
            }
            $lists = Db::name('menu')
                ->where($map)
                ->field('id,title,url,icons,pid,is_btn')
                ->order('sort asc,id asc')
                ->select();

            $lists = $lists?$lists:[];
            $arr = [];
            $curUrl = '';
            foreach ($lists as $k=>$v){
                $v['url'] = model('Menu')->getNavUrl($v['url']);
                $arr[] = $v;

            }

            $menus = list_to_tree($arr, 'pid', 'child');

         //   $curUrl = isset($arr[0])?$arr[0]['url']:'';
            $rid = isset($menus[0])?$menus[0]['id']:'';

            $f = Db::name('menu')->where('pid',$rid)->where('del',0)->where('enable',1)->where($map)->order('sort asc,id asc')->find();
            if($f['url'] && $f['is_btn'] == 0){
                $curUrl = $f['url'];
            }else{
                $ff = Db::name('menu')->where('pid',$f['id'])->where('del',0)->where('enable',1)->where($map)->order('sort asc,id asc')->find();

                if($ff['url'] && $f['is_btn'] == 0){
                    $curUrl = $ff['url'];
                }
            }



            if(!$menus){
                $curUrl ='';
            }

        }
        $this->assign('menus',$menus);


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


        $this->assign('fRolesId',$fRolesId);
        $this->assign('rid',$rid);


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

        // 判断用户是否有派单权限
        $isDispatch = 0;

        if(get_dispatch_auth($this->userId)){
            $isDispatch = 1;
        }
        $this->assign('isDispatch',$isDispatch);


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

        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;




        $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 ocount(){
        $map[] = ['org_id','=',$this->orgId];
        $map[] = ['del','=',0];
        $map[] = ['order_mode','=',1];

        $order = 0;
        $auth = get_dispatch_auth($this->userId);

        if(!is_admin($this->userId)){
//            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];
//                }
//            }
            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;

        }






        $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(){
        // 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);
        // 陪护小程序二维码
        $wxcode2 = Db::name('org')->where('id',$this->orgId)->value('wxqrcode2');
        $this->assign('wxcode2',$wxcode2);
        // 陪护h5
        $phcode = think_encrypt(config("app.app_host").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);

        //本月
        $month = date('Y-m');
        $sMonth = $month.'-1 00:00:00';
        $eMonth = $month.'31 23:59:59';

        //上月
        $tmp_year=substr($month,0,4);
        //切割出月份
        $tmp_mon =substr($month,5,2);

        $tmp_forwardmonth=mktime(0,0,0,$tmp_mon-1,1,$tmp_year);
        $lastMonth=date("Y-m",$tmp_forwardmonth);

        $sLastMonth = $lastMonth.'-1 00:00:00';
        $eLastMonth = $lastMonth.'31 23:59:59';

        $userNums = Db::name('user')
            ->alias('u')
            ->join('user_org uo','uo.user_id=u.id')
            ->where('uo.org_id',$this->orgId)
            ->where('u.del',0)
            ->where('u.enable',1)
            ->count();

        $monthUserNums = Db::name('user')
            ->alias('u')
            ->join('user_org uo','uo.user_id=u.id')
            ->where('uo.org_id',$this->orgId)
            ->where('u.del',0)
            ->where('u.enable',1)
            ->where('u.create_time','>=',$sMonth)
            ->where('u.create_time','<=',$eMonth)
            ->count();
        $lastMonthUserNums = Db::name('user')
            ->alias('u')
            ->join('user_org uo','uo.user_id=u.id')
            ->where('uo.org_id',$this->orgId)
            ->where('u.del',0)
            ->where('u.enable',1)
            ->where('u.create_time','>=',$sLastMonth)
            ->where('u.create_time','<=',$eLastMonth)
            ->count();

        $userLastNums = $monthUserNums-$lastMonthUserNums;
        $userCount = [
            'userNums'=>$userNums,
            'userLastNums'=>$userLastNums,
        ];
        $this->assign('userCount',$userCount);

        $monthOrderNums = Db::name('orders')
            ->where('org_id',$this->orgId)
            ->where('create_yyyymm',date('Ym'))
            ->where('del',0)
            ->count();
        $lastMonthOrderNums = Db::name('orders')
            ->where('org_id',$this->orgId)
            ->where('create_yyyymm',date('Ym',strtotime('-1 month')))
            ->where('del',0)
            ->count();
        $orderLastNums = $monthOrderNums -$lastMonthOrderNums;
        $orderCount = [
            'orderNums'=>$monthOrderNums,
            'orderLastNums'=>$orderLastNums,
        ];
        $this->assign('orderCount',$orderCount);

        $yearOrderNums = Db::name('orders')
            ->where('org_id',$this->orgId)
            ->where('create_yyyy',date('Y'))
            ->where('del',0)
            ->count();
        $lastYearOrderNums = Db::name('orders')
            ->where('org_id',$this->orgId)
            ->where('create_yyyy',date('Y',strtotime('-1 year')))
            ->where('del',0)
            ->count();
        $endYearOrderCount = $yearOrderNums - $lastYearOrderNums;
        if($lastYearOrderNums < 1){
            $orderLastYearNums = 100;
        }else{
            $orderLastYearNums = round($endYearOrderCount/$lastYearOrderNums,2)*100;
        }
        $orderYearCount = [
            'orderYearNums'=>$yearOrderNums,
            'orderLastYearNums'=>$orderLastYearNums,
        ];
        $this->assign('orderYearCount',$orderYearCount);

        $activeUserNums = Db::name('user')
            ->alias('u')
            ->join('user_org uo','uo.user_id=u.id')
            ->where('uo.org_id',$this->orgId)
            ->where('u.del',0)
            ->where('u.enable',1)
            ->where('u.last_login_time','>=',$sMonth)
            ->where('u.last_login_time','<=',$eMonth)
            ->count();
        $lastActiveUserNums = Db::name('user')
            ->alias('u')
            ->join('user_org uo','uo.user_id=u.id')
            ->where('uo.org_id',$this->orgId)
            ->where('u.del',0)
            ->where('u.enable',1)
            ->where('u.last_login_time','>=',$sLastMonth)
            ->where('u.last_login_time','<=',$eLastMonth)
            ->count();
        $activeUserLastNums = $activeUserNums-$lastActiveUserNums;
        $activeUserCount = [
            'activeUserNums'=>$activeUserNums,
            'activeUserLastNums'=>$activeUserLastNums,
        ];
        $this->assign('activeUserCount',$activeUserCount);

        $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);

        $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]['user_name'] = Db::name('user')->where('id',$v['to_user_id'])->value('real_name');
            $todoList[$k]['create_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');
        }

        $this->assign('mode',$mode);
        $this->assign('todoList',$todoList);

        $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->assign('attendanceCount1',$attendanceCount1);




        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(){
        // 判断用户是否是调度
        $level = get_dispatch_auth($this->userId);

        if(!$level){
            $this->error('无权限');
        }
        $map[] = ['org_id','=',$this->orgId];
        $map[] = ['del','=',0];
        $map[] = ['order_mode','=',1];
        $order = 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;
        }





        $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($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);

                    $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($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($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);

                    $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();
    }
}