";
//                print_r($newUser);
//                die();
            }
            $this->assign('user_list', $newUser);
            return $this->fetch();
        }
        else {
            $data = request()->post();
            $data['org_id'] = $this->orgId;
            if (empty($data['to_user_id'])) {
                $this->error('请选择执行人');
            }
            $data['to_user_id'] = implode(',', $data['to_user_id']);
            $res = $this->model->batchsend($id, $this->userId, $data);
            if (!$res) {
                $this->error($this->model->getError());
            }
            $this->success('操作成功');
        }
    }
    public function onesend($id, $mode = 1) {
        $data = request()->post();
        $data['org_id'] = $this->orgId;
        if (empty($data['to_user_id'])) {
            $this->error('请选择执行人');
        }
       // $data['to_user_id'] = implode(',', $data['to_user_id']);
        $res = $this->model->batchsend($id, $this->userId, $data);
        if (!$res) {
            $this->error($this->model->getError());
        }
        $this->success('操作成功');
    }
    //完成订单
    public function finish($id) {
        $res = $this->model->finish($id);
        if (!$res) {
            $this->error($this->model->getError());
        }
        $this->success('操作成功');
    }
    //批量完成订单
    public function batchfinish($id) {
        $res = $this->model->batchfinish($id);
        if (!$res) {
            $this->error($this->model->getError());
        }
        $this->success('操作成功');
    }
    //评价
    public function comment() {
        $id = input('id');
        $score = input('score');
        $content = input('content');
        if ($score <= 0 || $score > 5) {
            $this->error('参数错误');
        }
        $res = $this->model->addComment($id, $score, $content, $this->userId, $this->orgId);
        if (!$res) {
            $this->error($this->model->getError());
        }
        $this->success('操作成功');
    }

    public function phone() {
        $phone = input('phone','','trim');
        $fp = input('fp','','trim');
        $id = input('id/d',0,'trim');
        if($phone){
            $fp = $fp?base64_decode($fp):'';
            $md5 = md5($this->orgId.'|'.$fp);
            $ret = Db::name('phone_monitor_record')->where('md5',$md5)->find();
            if(!$ret){
                $id = Db::name('phone_monitor_record')->insertGetId([
                    'org_id' => $this->orgId,
                    'phone' => $phone,
                    'path' => $fp,
                    'md5' => $md5,
                    'create_time' => date('Y-m-d H:i:s')
                ]);
            }else{
                $id = $ret['id'];
            }
        }
        $worktype = [
            ['id' => 1, 'title' => '报修'],
            ['id' => 2, 'title' => '保洁'],
            ['id' => 3, 'title' => '运送'],
            ['id' => 4, 'title' => '应急'],
        ];
        $info = Db::name('phone_monitor_record')->where('id',$id)->find();
        if(!$info){
            halt('数据存储失败');
        }
        $this->assign('worktype', $worktype);
        $this->assign('info', $info);
        $this->assign('id', $id);
        return $this->fetch();
    }

    public function phoneAdd() {
        $id = input('id');
        $worktype = [
            ['id' => 1, 'title' => '报修'],
            ['id' => 2, 'title' => '保洁'],
            ['id' => 3, 'title' => '运送'],
            ['id' => 4, 'title' => '应急'],
        ];
        $info = Db::name('phone_monitor')
            ->where('id', $id)->find();
        if (!$info) {
            echo '负责人不存在', exit();
        }
        $info['real_name'] = Db::name('user')
            ->where('id', $info['user_id'])
            ->value('real_name');
        $info['dep'] = Db::name('user_dep')
            ->alias('a')
            ->join('dep b', 'a.dep_id=b.id')
            ->where('a.user_id', $info['user_id'])
            ->value('b.title');
        $this->assign('worktype', $worktype);
        $this->assign('info', $info);
        $this->assign('id', $id);
        return $this->fetch();
    }
    //运送调度订单列表
    public function convey() {
        set_time_limit(0);
        ini_set("memory_limit","1024M");

        $mode = input('mode', 1);
        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;
            $content = input('content', '', 'trim');
            if ($content) {
                $map[] = ['o.content', 'like', '%' . $content . '%'];
            }
            $dep_id = input('dep_id', '', 'trim');
            if ($dep_id != '') {
                $map[] = ['o.dep_id', '=', $dep_id];
            }
            $priority = input('priority', '', 'trim');
            if ($priority) {
                $map[] = ['oc.priority', '=', $priority];
            }
            $s = input('start', '', 'trim');
            $end = input('end', '', 'trim');
            if ($s) {
                $map[] = ['oc.start', '=', $start];
            }
            if ($end) {
                $map[] = ['oc.end', '=', $end];
            }
            $type = input('type', '', 'trim');
            if ($type) {
                $map[] = ['oc.type', '=', $type];
            }
            $xqtime = input('xqtime', '', 'trim');
            $ywctime = input('ywctime', '', 'trim');
            if ($xqtime) {
                $xqtimes = explode(' - ', $xqtime);
                $x1 = date('Ymd', strtotime($xqtimes[0]));
                $x2 = date('Ymd', strtotime($xqtimes[1]));
                $map[] = ['oc.xq_time', '>=', $x1];
                $map[] = ['oc.xq_time', '<=', $x2];
            }else{ // 默认只显示当天的订单
               // $map[] = ['oc.xq_time', '>=', date("Y-m-d")." 00:00:00"];
                $map[] = ['oc.xq_time', '<=', date("Y-m-d")." 23:59:59"];
            }
            if ($ywctime) {
                $ywctimes = explode(' - ', $ywctime);
                $y1 = date('Ymd', strtotime($ywctimes[0]));
                $y2 = date('Ymd', strtotime($ywctimes[1]));
                $map[] = ['oc.ywc_time', '>=', $y1];
                $map[] = ['oc.ywc_time', '<=', $y2];
            }
            $map[] = ['o.del', '=', 0];
            $map[] = ['o.org_id', '=', $this->orgId];
            $map[] = ['o.work_type_mode', '=', 3];
            $map[] = ['o.order_mode', 'in', [1, 4]];
            $status = input('status', '', 'trim');
            $ysName = input('ysname', '');
            if ($ysName) {
                $orders = Db::name('todo')
                    ->alias('t')
                    ->where('t.org_id', $this->orgId)
                    ->where('t.del', 0)
                    ->where('t.work_type_mode', 3)
                    ->where('t.todo_mode', [1, 2, 4])
                    ->where('u.real_name', 'like', '%' . $ysName . '%')
                    ->join('orders o', 'o.id = t.order_id')
                    ->join('user u', 't.to_user_id = u.id')
                    ->group('o.id')
                    ->column('o.id');
                if ($orders) {
                    $map[] = ['o.id', 'in', $orders];
                }
                else {
                    $map[] = ['o.id', '=', 0];
                }
            }
            $map = empty($map) ? true : $map;
            //数据查询
            $lists = db($this->table)->alias('o')
                ->join('order_convey oc', 'oc.order_id=o.id')
                ->field('o.*,oc.type,oc.start,oc.end,oc.xq_time,oc.ywc_time,oc.device_id,oc.name,oc.phone,oc.priority')
                ->where($map)
                ->order(['o.order_mode' => 'asc', 'oc.xq_time' => 'desc'])
                ->select();
//            halt($lists);
            $newret = [];
            $newret1 = [];
            $newret2 = [];
            $newret3 = [];
            $newret4 = [];
            foreach ($lists as $k => $v) {
                $v = $this->model->formatOrder($v);

                $v['bed_number'] = '';
                $ocp = Db::name('order_convey_patient')
                    ->where('order_id', $v['id'])
                    ->find();
                $v['bed_number'] = !empty($ocp)?$ocp['bed_number']:'';

                $todo = Db::name('todo')
                    ->alias('t')
                    ->where('t.order_id', $v['id'])
                    ->join('user u', 'u.id = t.to_user_id')
                    ->where('t.todo_mode', 'in', [1, 2, 3, 4])
                    ->where('t.del', 0)
                    ->field('u.real_name,u.mobile,t.create_time,t.confirm_time')
                    ->order('t.id asc')
                    ->select();
                $users = [];
                $confirmtime = '';
                foreach ($todo as $kk => $vv) {
                    $users[] = $vv['real_name'].($vv['mobile']?'['.$vv['mobile'].']':'');
                    if (!$confirmtime && $vv['confirm_time']) {
                        $confirmtime = $vv['confirm_time'];
                    }
                    else {
                        if ($confirmtime && $vv['confirm_time'] && $vv['confirm_time'] < $confirmtime) {
                            $confirmtime = $vv['confirm_time'];
                        }
                    }
                }
                $v['is_todo'] = $todo?1:0;
                $v['real_names'] = implode(',', $users);
                $v['confirm_time'] = $confirmtime;



                $last = strtotime($v['ywc_time']) - time();
                $v['last_time'] = $last > 0 ? round($last / 60) : 0;
                //是否有延时
                $v['delay'] = 0; // 0=未延迟 1=延迟
                $v['delay_diff'] = 0;
                $v['delay_reason'] = '';
                $delays = Db::name('order_delay')
                    ->where('order_id', $v['id'])
                    ->select();
                $delays = $delays ? $delays : [];
                foreach ($delays as $vv) {
                    if ($vv['status'] == 0) {
                        $v['delay'] = 1;
                        $v['delay_reason'] = $this->gettablefield('delay_reason', ['id' => $vv['delay_reason_id']], 'title');
                        $vv['diff'] = time() - strtotime($vv['start_time']);
                    }
                    $v['delay_diff'] += $vv['diff'];
                }
                $v['delay_diff'] = round($v['delay_diff'] / 60);
                if ($v['delay'] == 1) {
                    $v['status'] = 3;
                } else {
                    if ($v['order_mode'] == 1) {
                        $v['status'] = 1;
                    } else {
                        $v['status'] = 2;
                    }
                }
                $convey = Db::name('convey_cate')
                    ->alias('oc')
                    ->join('time ot', 'ot.id = oc.time_id')
                    ->where('oc.id', $v['type'])
                    ->field('ot.*')
                    ->find();
                $createtime = strtotime($v['create_time']);
                $curtime = time();
                $ct = round(($curtime - $createtime) / 60);
                if ($ct < $convey['yy_time']) {
                    $ss = 0;
                }
                else {
                    if ($ct >= $convey['yy_time'] && $ct < $convey['bz_time']) {
                        $ss = 1;
                    }
                    else {
                        if ($ct >= $convey['bz_time'] && $ct < $convey['jg_time']) {
                            $ss = 2;
                        }
                        else {
                            if ($ct >= $convey['jg_time'] && $ct < $convey['wjjg_time']) {
                                $ss = 3;
                            }
                            else {
                                $ss = 4;
                            }
                        }
                    }
                }
                $v['ss'] = $ss;
                $v['xtime'] = date('H:i', strtotime($v['xq_time']));
                $v['stime'] = $v['send_time'] ? date('H:i', strtotime($v['send_time'])) : "";
                $v['ctime'] = $v['confirm_time'] ? date('H:i', strtotime($v['confirm_time'])) : "";
                $v['starttime'] = '';
                if($v['confirm_time']){ // 如果确认时间不为空
                    $todoconvey = Db::name('todo_convey')
                        ->alias('a')
                        ->join('todo t','t.id = a.todo_id')
                        ->where('t.order_id', $v['id'])
                        ->field('a.*')
                        ->order('a.id asc')
                        ->find();
                    if($todoconvey){
                        $v['starttime'] = date('H:i', strtotime($todoconvey['start_time']));
                    }
                }

                $v['priorityName'] = isset($this->model->priority[$v['priority']])?$this->model->priority[$v['priority']]:'';
                if ($status == 3 && $v['delay'] == 1) { //延时任务
                    $newret[] = $v;
                    $newret1[] = $v;
                }
                if ($status == 1 && $v['order_mode'] == 1) { //新任务
                    $newret[] = $v;
                    $newret2[] = $v;
                }
                if ($status == 2 && $v['order_mode'] == 4) { // 进行中
                    $newret[] = $v;
                    $newret3[] = $v;
                }
                if (!$status || !in_array($status, [1, 2, 3])) {
                    $newret[] = $v;
                    $newret4[] = $v;
                }
                $lists[$k] = $v;
            }
            if(!empty($newret)){
                //$newret = arraySequence($newret,'status');//返回数组中指定的一列
//                $newret1 = $newret1?arraySequence($newret1,'xtime','SORT_DESC'):[];
//                $newret3 = $newret3?arraySequence($newret3,'xtime','SORT_DESC'):[];
//                $newret4 = $newret4?arraySequence($newret4,'xtime','SORT_DESC'):[];
//                $newret = array_merge($newret2,$newret3,$newret4,$newret1);
                $all = [];
                $newret2 = $newret2?arraySequence($newret2,'status'):[];
                $newret3 = $newret3?arraySequence($newret3,'status'):[];
                //$newret4 = $newret4?arraySequence($newret4,'status'):[];
                $newret1 = $newret1?arraySequence($newret1,'status'):[];

                $newret2 = $newret2?arraySequence($newret2,'xtime','SORT_DESC'):[];
                $newret3 = $newret3?arraySequence($newret3,'xtime','SORT_DESC'):[];
              //  $newret4 = $newret4?arraySequence($newret4,'xtime','SORT_DESC'):[];
                $newret1 = $newret1?arraySequence($newret1,'xtime','SORT_DESC'):[];

                foreach ($newret2 as $k=>$v){
                    $all[] = $v;
                }
                foreach ($newret3 as $k=>$v){
                    $all[] = $v;
                }
                foreach ($newret1 as $k=>$v){
                    $all[] = $v;
                }
                $a1 = $a2 = $a3 = [];
                foreach ($newret4 as $k=>$v){
                    if ($v['status'] == 3) { //延时任务
                        $a1[] = $v;
                    }
                    if ($v['status'] == 1) { //新任务
                        $a2[] = $v;
                    }
                    if ($v['status'] == 2) { // 进行中
                        $a3[] = $v;
                    }

                }
                $a1 = $a1?arraySequence($a1,'status'):[];
                $a2 = $a2?arraySequence($a2,'status'):[];
                $a3 = $a3?arraySequence($a3,'status'):[];

                $a1 = $a1?arraySequence($a1,'xtime','SORT_DESC'):[];
                $a2 = $a2?arraySequence($a2,'xtime','SORT_DESC'):[];
                $a3 = $a3?arraySequence($a3,'xtime','SORT_DESC'):[];

                // 预约类型-取15分钟后之前的订单
                $curtime15 = $curtime+60*15;

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

                    if($v['priority'] !=4 && $v['xq_time'] < date('Y-m-d H:i:s',$curtime15) ){
                        $all[] = $v;
                    }

                }
                foreach ($a3 as $k=>$v){
                    if($v['priority'] !=4 && $v['xq_time'] < date('Y-m-d H:i:s',$curtime15) ){
                        $all[] = $v;
                    }
                }
                foreach ($a1 as $k=>$v){
                    if($v['priority'] !=4 && $v['xq_time'] < date('Y-m-d H:i:s',$curtime15) ){
                        $all[] = $v;
                    }
                }
                $newret= $all;
            }
            $sdd[] =['org_id','=',$this->orgId];
            $sdd[] =['del','=',0];
            $sdd[] =['work_type_mode','=',3];
            $sdd[] =['create_yyyymmdd','=',date('Ymd')];
            $dcl = Db::name('orders')
                ->where($sdd)
                ->where('order_mode',1)
                ->count();
            $ypf = Db::name('orders')
                ->where($sdd)
                ->where('order_mode',4)
                ->count();
            $ywc = Db::name('orders')
                ->where($sdd)
                ->where('order_mode','in',[5,6])
                ->count();
            $yqx = Db::name('orders')
                ->where($sdd)
                ->where('order_mode','in',[2,3])
                ->count();
            //数据返回
            $totalCount = count($newret);
            $totalPage = ceil($totalCount / $length);
            $result['dcl'] = $dcl;
            $result['ypf'] = $ypf;
            $result['ywc'] = $ywc;
            $result['yqx'] = $yqx;
            $result['page'] = $page;
            $result['total'] = $totalPage;
            $result['records'] = $totalCount;
            $result['rows'] = $newret;
            return json($result);
        }
        else {
            $mode_name = $this->getTableField('work_type_mode', ['id' => $mode], 'name');
            $order_type = (new \app\common\model\ConveyCate())->getList();
            $order_mode = Db::name('order_mode')
                ->select();
            $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));
            $address = (new \app\common\model\Address())->getListByType(2);
            $this->assign('address', $address);
            $count = Db::name('todo')
                ->where('org_id', $this->orgId)
                ->where('del', 0)
                ->where('work_type_mode', 3)
                ->where('todo_mode', 4)
                ->count();
            $this->assign('count', $count);
            $info = Db::name('config')->where('name','org_order_refresh')
                ->find();
            $orgConfig = Db::name('config_org')
                ->where('config_id',$info['id'])
                ->where('org_id',$this->orgId)
                ->find();
            $value = $orgConfig?$orgConfig['value']:0;
            $this->assign('refresh',$value);
            $sxJg = (new Config())->getConfig('ys_auto_sx',$this->orgId);
            $this->assign('sxJg',$sxJg?$sxJg:30);
            return $this->fetch();
        }
    }

    public function reminder(){
        $id = input('id/d',0);
        $touserids = Db::name('todo')->where('order_id',$id)->where('todo_mode','in',[1,2])->where('del',0)->column('to_user_id');
        if($touserids){
            $touserids = array_unique($touserids);
            send_jpush($touserids,AppMsg::PUSH_WORKER_ORDER_SEND,'您有订单需要处理');
        }

        $this->success('催单成功');
    }

    //运送员状态
    public function conveystatus($id='') {
        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;
            $real_name = input('real_name', '');

            $map8 = [];
            if ($real_name) {
                $map8[] = ['real_name', 'like', '%'.$real_name.'%'];
            }
            $work = input('work', '');
            if ($work!='') {
                $map8[] = ['work', '=',$work];
            }
            $user = (new \app\common\model\WorkTypeMode())->getRolesUser(3, $this->orgId);
            $newUser = [];
            foreach ($user as $k => $v) {
                foreach ($v['user'] as $k1 => $v1) {
                    $newUser[] = $v1['id'];
                }
            }

            $userIds1 = [];
            if($id){
                $ids = explode(',', $id);
                $map[] = ['order_id', 'in', $ids];
                $map[] = ['del', '=', 0];
                $map[] = ['org_id', '=', $this->orgId];
                $map[] = ['work_type_mode', '=', 3];
                $userIds = Db::name('todo')->where($map)->column('to_user_id');
                $userIds1 = $userIds?$userIds:[];
                $newUser = array_intersect($userIds1,$newUser);
            }

            if(empty($newUser)){
                $map8[] = ['id','=',0];
            }else{
                $map8[] = ['id','in',$newUser];
            }
            $mm = [];
            $group = input('group', '');
            if ($group) {
                $uid = Db::name('user_group_user')
                    ->where('group_id',$group)
                    ->column('user_id');
                if(!empty($uid)){
                    $mm[] = ['id','in',$uid];
                }else{
                    $mm[] = ['id','in',[-1]];

                }
            }
            $lists = db('user')
                ->where($mm)
                ->where($map8)
                ->limit($start, $length)
                ->order($order)
                ->select();


            foreach ($lists as $key => $value) {
                $lists[$key]['user_group_title'] = Db::name('user_group')
                    ->alias('ug')
                    ->join('user_group_user ugu','ugu.group_id=ug.id')
                    ->where('ugu.user_id',$value['id'])
                    ->value('ug.title');
                $nums = Db::name('todo')
                    ->where(['to_user_id' => $value['id'], 'work_type_mode' => 3])
                    ->where('create_yyyymmdd', date('Ymd'))
                    ->where('todo_mode', 'in', [1, 2, 3])
                    ->count();
                $lists[$key]['nums'] = $nums;
                $addr = Db::name('order_convey')
                    ->alias('cpr')
                    ->join('todo os', 'cpr.order_id = os.order_id')
                    ->join('orders ods', 'cpr.order_id = ods.id')
                    ->join('address ca', 'ca.id = cpr.start')
                    ->join('address cad', 'cad.id = cpr.end')
                    ->field('os.todo_mode,ca.title as start_name,cad.title as end_name,os.create_time')
                    ->where('os.to_user_id', $value['id'])
                    ->where('os.del', 0)
                    ->where('ods.del', 0)
                    ->order('os.id desc')
                    ->find();
                $lists[$key]['title'] = '';
                $lists[$key]['addr_time'] = '';
                if($addr){
                    if(in_array($addr['todo_mode'],[1,2])){
                        $lists[$key]['title'] = $addr['start_name'];
                    }else{
                        $lists[$key]['title'] = $addr['end_name'];
                    }
                    $lists[$key]['addr_time'] = $addr['create_time'];
                }
                $lists[$key]['worktxt'] = $value['work'] == 1 ? '上班' : '下班';
                $lists[$key]['stationtxt'] = $value['station'] == 1 ? '驻守' : '取消驻守';
            }
            //数据返回
//            $totalCount = db('user')
//                ->where($map1)->count();
            $totalCount = db('user')
                ->where($map8)->count();
            $totalPage = ceil($totalCount / $length);
            $result['page'] = $page;
            $result['total'] = $totalPage;
            $result['records'] = $totalCount;
            $result['rows'] = $lists;
            return json($result);
        }
        else {

            $group = model('UserGroup')->getList();
            $this->assign('group', $group);
            $this->assign('id', $id);
            return $this->fetch();
        }
    }
    //上下班
    public function work($id) {
        $user = Db::name('user')
            ->where('id', $id)
            ->find();
        $value = $user['work'] == 1 ? 0 : 1;
        $res = Db::name('user')
            ->where('id', $id)
            ->update(['work' => $value, 'update_time' => getTime()]);
        $res ? $this->success('操作成功') : $this->error('操作失败');
    }
    //驻守
    public function station($id) {
        $user = Db::name('user')
            ->where('id', $id)
            ->find();
        $value = $user['station'] == 1 ? 0 : 1;
        $res = Db::name('user')
            ->where('id', $id)
            ->update(['station' => $value, 'update_time' => getTime()]);
        $res ? $this->success('操作成功') : $this->error('操作失败');
    }
    //驳回工单列表
    public function bhTodoList() {
        if (request()->isAjax()) {
            $length = input('rows', 10, 'intval');   //每页条数
            $page = input('page', 1, 'intval');      //第几页
            $start = ($page - 1) * $length;     //分页开始位置
            $map[] = ['todo.org_id', '=', $this->orgId];
            $map[] = ['todo.del', '=', 0];
            $map[] = ['todo.todo_mode', '=', 4];
            $map[] = ['todo.work_type_mode', '=', 3];
            $totalCount = Db::name('todo')
                ->alias('todo')
                ->join('orders orders', 'orders.id = todo.order_id')
                ->join('order_convey oc', 'oc.order_id = orders.id')
                ->join('user u', 'u.id = todo.to_user_id')
                ->where($map)
                ->count();
            $totalPage = ceil($totalCount / $length);
            $ret = Db::name('todo')
                ->alias('todo')
                ->join('orders orders', 'orders.id = todo.order_id')
                ->join('order_convey oc', 'oc.order_id = orders.id')
                ->join('user u', 'u.id = todo.to_user_id')
                ->field('orders.*,u.real_name as to_real_name,oc.type,oc.start,oc.end,oc.xq_time,oc.ywc_time,oc.device_id,oc.name,oc.phone,oc.priority,todo.nodo_reason,todo.id,todo.reject_time')
                ->order('oc.xq_time', 'desc')
                ->where($map)
                ->limit($start, $length)
                ->select();
            foreach ($ret as $k => $v) {
                $ret[$k]['start_name'] = $this->gettablefield('address', array('id' => $v['start']), 'title');
                $ret[$k]['end_name'] = $this->gettablefield('address', array('id' => $v['end']), 'title');
                $ret[$k]['type_name'] = $this->gettablefield('convey_cate', array('id' => $v['type']), 'title');
                $ret[$k]['real_name'] = $this->gettablefield('user', array('id' => $v['user_id']), 'real_name');
                $ret[$k]['device_name'] = '';
                if ($v['device_id'] > 0) {
                    $ret[$k]['device_name'] = $this->gettablefield('convey_device', array('id' => $v['device_id']), 'title');
                }
                $last = strtotime($v['ywc_time']) - time();
                $ret[$k]['last_time'] = $last > 0 ? round($last / 60) : 0;
                $ret[$k]['reject_time'] = $v['reject_time'] ? date('Y-m-d h:i', strtotime($v['reject_time'])) : '';
            }
            $result['page'] = $page;
            $result['total'] = $totalPage;
            $result['records'] = $totalCount;
            $result['rows'] = $ret;
            return json($result);
        }
        else {
            return $this->fetch();
        }
    }
    //excel导出
    public function export($mode) {
        set_time_limit(0);
        ini_set("memory_limit", "1024M");
        $meta_title = '订单列表';
        if ($mode == 1) {
            $meta_title = '报修' . $meta_title;
        }
        elseif ($mode == 2) {
            $meta_title = '保洁' . $meta_title;
        }
        elseif ($mode == 3) {
            $meta_title = '运送' . $meta_title;
        }
        elseif ($mode == 4) {
            $meta_title = '应急' . $meta_title;
        }
        elseif ($mode == 15) {
            $meta_title = '品质整改' . $meta_title;
        }elseif ($mode == -1) {
            $meta_title = '一键呼叫' . $meta_title;
        }
        $level1 = check_is_dispatch($this->userId);
        $level2 = check_two_dispatch($this->userId);
        $turnoff = two_dispatch_off($this->orgId);
        $quality_type = input('quality_type','');

        if (request()->isGet()) {
            //排序
            $sortRow = input('sidx', 'a.id', 'trim');      //排序列
            $sort = input('sord', 'desc', 'trim');        //排序方式
            $order = $sortRow . ' ' . $sort;
            $content = input('content', '', 'trim');
            if ($content) {
                $map[] = ['a.content', 'like', '%' . $content . '%'];
            }
            $dep_id = input('dep_id', '', 'trim');
            if ($dep_id != '') {
                $map[] = ['a.dep_id', '=', $dep_id];
            }
            $order_mode = input('order_mode', '', 'trim');
            $map6 = [];
            if ($order_mode != '') {
                if($level1 && $turnoff && $mode != 15){ // 一级调度且二级调度开关开着,品质整改例外
                    if ($order_mode == 1) {
                        $map[] = ['a.is_deal', '=', 0];
                    }else if ($order_mode == 4) {
                        $map6[] = ['a.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[] = ['a.id', '=', -1];
                    }else{
                        $map[] = ['a.id', 'in', $gq];
                    }
                }else{
                    $map[] = ['a.order_mode', '=', $order_mode];
                }
            }
            $b = input('start', '', 'trim');
            $e = input('end', '', 'trim');
            if ($b) {
//                $b = date('Ymd', strtotime($b));
//                $map[] = ['a.create_yyyymmdd', '>=', $b];
                $map[] = ['a.create_time', '>=', $b];

            }
            if ($e) {
//                $e = date('Ymd', strtotime($e));
//                $map[] = ['a.create_yyyymmdd', '<=', $e];
                $map[] = ['a.create_time', '<=', $e];

            }
            $map[] = ['a.del', '=', 0];
            $map[] = ['a.org_id', '=', $this->orgId];
            if($mode==-1){
                $map[] = ['a.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 = [];
                }
            }
            $typeName = input('typeName', '', 'trim');
            if ($typeName != '') {
                $map_11[] = ['a.title', 'like', '%'.$typeName.'%'];
                $typeNameId = Db::name('convey_cate')
                    ->alias('a')
                    ->join('order_convey b','a.id=b.type')
                    ->where($map_11)
                    ->where('a.org_id', $this->orgId)
                    ->where('a.enable', 1)
                    ->where('a.del', 0)
                    ->column('b.order_id');
                if (!empty($typeNameId)) {
                    $map[] = ['a.id', 'in', $typeNameId];

                }
                else {
                    $map[] = ['a.id', '=', -1];

                }
            }
            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[] = ['a.id', '=', -1];
                } else {
                    if($type != ''){
                        $oids = array_intersect($oids,$ids);
                        if($oids){
                            $map[] = ['a.id', 'in', $oids];
                        }else{
                            $map[] = ['a.id', '=', -1];
                        }
                    }else{
                        $map[] = ['a.id', 'in', $ids];

                    }
                }
            }else{
                if($type != ''){
                    if($oids){
                        $map[] = ['a.id', 'in', $oids];
                    }else{
                        $map[] = ['a.id', '=', 0];
                    }
                }
            }

            if($mode == 15){ // 品质检查,单独处理
                $map[] = ['a.work_type_mode','=',$mode];
                if($quality_type !=''){
                    $map[] = ['a.quality_type','=',$quality_type];
                }
            }else{
                $work_type_mode = input('work_type_mode','','trim');
                if(!is_admin($this->userId)){
                    $auth = get_dispatch_auth($this->userId);
                    if($auth){
                        $map[] = ['a.work_type_mode', 'in', $auth];
                        if($mode > 0){
                            $map[] = ['a.work_type_mode', '=', $mode];
                        }else{
                            if($work_type_mode!=''){
                                $map[] = ['a.work_type_mode','=',$work_type_mode];
                            }
                        }
                    }else{
                        $map[] = ['a.work_type_mode', '=', -1];
                    }
                }else{
                    if($mode > 0){
                        $map[] = ['a.work_type_mode', '=', $mode];
                    }else{
                        if($work_type_mode!=''){
                            $map[] = ['a.work_type_mode','=',$work_type_mode];
                        }
                    }
                }
            }
            $sn = input('sn', '', 'trim');
            if ($sn) {
                $map[] = ['a.sn', 'like', '%' . $sn . '%'];
            }
            $from = input('from', '', 'trim');
            if ($from) {
                if($from >3){
                    $map[] = ['a.from','=',0];
                    $map[] = ['a.work_type_mode','=',$from-3];
                }else{
                    $map[] = ['a.from','=',$from];
                }
            }
            $dep_cate = input('dep_cate', '', 'trim');
            if ($dep_cate != '') {
                $depIds = Db::name('dep')
                    ->where('org_id',$this->orgId)
                    ->where('cate_id',$dep_cate)
                    ->where('del',0)
                    ->column('id');
                if(!empty($depIds)){
                    $map[] = ['a.dep_id', 'in', $depIds];
                }else{
                    $map[] = ['a.dep_id', '=', -1];

                }
            }
            $priority = input('priority', '', 'trim');
            if($priority !=''){
                $map[] = ['b.priority', '=',$priority];
            }

            $sddr = input('saddr','','trim');
            if($sddr !=''){
                $map[] = ['b.start','=',$sddr];
            }
            $eddr = input('eaddr','','trim');
            if($eddr !=''){
                $map[] = ['b.end','=',$eddr];
            }
            $toUserName = input('toUserName','','trim');
            if($toUserName !=''){
                $ooids = Db::name('user')
                    ->alias('u')
                    ->join('todo t','t.to_user_id=u.id')
                    ->where('t.del',0)
                    ->where('t.org_id',$this->orgId)
                    ->where('u.real_name',$toUserName)
                    ->column('t.order_id');
                if($ooids){
                    $map[] = ['a.id','in',$ooids];
                }else{
                    $map[] = ['a.id','=',-1];
                }
            }

            $conveyCateId = input('conveyCateId','','trim');
            if($conveyCateId !=''){
                $typeNameId = Db::name('convey_cate')
                    ->alias('a')
                    ->join('order_convey b','a.id=b.type')
                    ->where('a.org_id', $this->orgId)
                    ->where('a.enable', 1)
                    ->where('a.del', 0)
                    ->where('a.id', $conveyCateId)
                    ->column('b.order_id');
                if (!empty($typeNameId)) {
                    $map[] = ['a.id', 'in', $typeNameId];
                }else {
                    $map[] = ['a.id', '=', -1];
                }
            }

            $map = empty($map) ? true : $map;
            //数据查询
            if($mode==3){
                $lists = db($this->table)->where($map)
                    ->alias('a')
                    ->leftJoin('order_convey b','a.id=b.order_id')
                    ->leftJoin('address ad','b.start=ad.id')
                    ->leftJoin('address ade','b.end=ade.id')
                    ->leftJoin('convey_cate cc','b.type=cc.id')
                    ->leftJoin('convey_device cd','b.device_id=cd.id')
                    ->leftJoin('dep dp','a.dep_id=dp.id')
                   // ->leftJoin('dep_cate dc','dp.cate_id=dc.id')
                    ->leftJoin('order_mode om','a.order_mode=om.id')
                    ->field('a.*,om.in_content as order_mode_text,dp.title as dep,cd.title as device_name,cc.title as type_name,b.priority,ad.title as start_name,ade.title as end_name')
                    ->whereOr($map6)
                    ->order($order)
                    ->select();
                foreach ($lists as $k => $v) {
                    // $lists[$k] = $this->model->newFormatOrder($v);
                    $lists[$k]['priority'] = isset($this->model->priority[$v['priority']])?$this->model->priority[$v['priority']]:"";
                    $lists[$k]['task_priority'] = $v['priority']==3?2:0;
                    $lists[$k]['source_type_text'] =$v['from']>0? isset($this->model->source_type[$v['from']])?$this->model->source_type[$v['from']]:'':$this->getTableField('work_type_mode', ['id' => $v['work_type_mode']], 'name');
                    if ($turnoff && $level1 && $v['order_mode'] == 1 && $v['is_deal'] == 1) {
                        $lists[$k]['order_mode_text'] = '已派发';
                    }
                }
            }else{
                $lists = db($this->table)->where($map)
                    ->alias('a')
                    ->leftJoin('order_convey b','a.id=b.order_id')
                    ->field('a.*,b.priority')
                    ->whereOr($map6)
                    ->order($order)->select();
                foreach ($lists as $k => $v) {
                    $lists[$k] = $this->model->newFormatOrder($v);
                    $lists[$k]['priority'] = isset($this->model->priority[$v['priority']])?$this->model->priority[$v['priority']]:"";
                    if ($turnoff && $level1 && $v['order_mode'] == 1 && $v['is_deal'] == 1) {
                        $lists[$k]['order_mode_text'] = '已派发';
                    }
                }
            }

            include_once env('root_path') . '/extend/phpexcel/Classes/PHPExcel.php';
            //实例化PHPExcel类
            $objPHPExcel = new \PHPExcel();
            //激活当前的sheet表
            $objPHPExcel->setActiveSheetIndex(0);
            //设置表格头（即excel表格的第一行）
            if ($mode == 1) {
                $objPHPExcel->setActiveSheetIndex(0)
                    ->setCellValue('A1', '编号')
                    ->setCellValue('B1', '申请时间')
                    ->setCellValue('C1', '内容')
                    ->setCellValue('D1', '所在科室/部门')
                    ->setCellValue('E1', '报修类型')
                    ->setCellValue('F1', '状态')
                    ->setCellValue('G1', '紧急程度')
                    ->setCellValue('H1', '来源')
                    ->setCellValue('I1', '物料名称')
                    ->setCellValue('J1', '单价')
                    ->setCellValue('K1', '数量')
                    ->setCellValue('L1', '总价');
            }
            else {
                if ($mode == 3) {
                    $objPHPExcel->setActiveSheetIndex(0)
                        ->setCellValue('A1', '编号')
                        ->setCellValue('B1', '申请时间')
                        ->setCellValue('C1', '开始地点')
                        ->setCellValue('D1', '结束地点')
                        ->setCellValue('E1', '运送类型')
                        ->setCellValue('F1', '任务备注')
                        ->setCellValue('G1', '所在科室/部门')
                        ->setCellValue('H1', '状态')
                        ->setCellValue('I1', '来源')
                        ->setCellValue('J1', '优先级');
                }
                else {
                    if($mode==0){
                        $objPHPExcel->setActiveSheetIndex(0)
                            ->setCellValue('A1', '编号')
                            ->setCellValue('B1', '申请时间')
                            ->setCellValue('C1', '内容')
                            ->setCellValue('D1', '所在科室/部门')
                            ->setCellValue('E1', '状态')
                            ->setCellValue('F1', '订单类型')
                            ->setCellValue('G1', '来源');
                    }else{

                        if($mode==15){
                            $objPHPExcel->setActiveSheetIndex(0)
                                ->setCellValue('A1', '编号')
                                ->setCellValue('B1', '申请时间')
                                ->setCellValue('C1', '内容')
                                ->setCellValue('D1', '所在科室/部门')
                                ->setCellValue('E1', '状态')
                                ->setCellValue('F1', '来源')
                                ->setCellValue('H1', '部门分类');
                        }else{
                            $objPHPExcel->setActiveSheetIndex(0)
                                ->setCellValue('A1', '编号')
                                ->setCellValue('B1', '申请时间')
                                ->setCellValue('C1', '内容')
                                ->setCellValue('D1', '所在科室/部门')
                                ->setCellValue('E1', '状态')
                                ->setCellValue('F1', '来源');
                        }
                    }

                }
            }
            // 设置表格头水平居中
            $objPHPExcel->setActiveSheetIndex(0)->getStyle('A1')->getAlignment()
                ->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
            $objPHPExcel->setActiveSheetIndex(0)->getStyle('B1')->getAlignment()
                ->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
            $objPHPExcel->setActiveSheetIndex(0)->getStyle('C1')->getAlignment()
                ->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
            $objPHPExcel->setActiveSheetIndex(0)->getStyle('D1')->getAlignment()
                ->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
            $objPHPExcel->setActiveSheetIndex(0)->getStyle('E1')->getAlignment()
                ->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
            $objPHPExcel->setActiveSheetIndex(0)->getStyle('F1')->getAlignment()
                ->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
            $objPHPExcel->setActiveSheetIndex(0)->getStyle('G1')->getAlignment()
                ->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
            $objPHPExcel->setActiveSheetIndex(0)->getStyle('H1')->getAlignment()
                ->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
            //设置列水平居中
            $objPHPExcel->setActiveSheetIndex(0)->getStyle('A')->getAlignment()
                ->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
            $objPHPExcel->setActiveSheetIndex(0)->getStyle('B')->getAlignment()
                ->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
            $objPHPExcel->setActiveSheetIndex(0)->getStyle('C')->getAlignment()
                ->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
            $objPHPExcel->setActiveSheetIndex(0)->getStyle('D')->getAlignment()
                ->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
            $objPHPExcel->setActiveSheetIndex(0)->getStyle('E')->getAlignment()
                ->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
            $objPHPExcel->setActiveSheetIndex(0)->getStyle('F')->getAlignment()
                ->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
            $objPHPExcel->setActiveSheetIndex(0)->getStyle('G')->getAlignment()
                ->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
            $objPHPExcel->setActiveSheetIndex(0)->getStyle('H')->getAlignment()
                ->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
            //设置单元格宽度
            $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('A')->setWidth(10);
            $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('B')->setWidth(20);
            $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('C')->setWidth(20);
            $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('D')->setWidth(20);
            $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('E')->setWidth(20);
            $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('F')->setWidth(50);
            $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('G')->setWidth(20);
            $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('H')->setWidth(20);
            //循环刚取出来的数组，将数据逐一添加到excel表格。
            if ($mode == 1) {
//                halt($lists);
                for ($i = 0; $i < count($lists); $i++) {
                    $objPHPExcel->getActiveSheet()->setCellValue('A' . ($i + 2), $lists[$i]['sn']);
                    $objPHPExcel->getActiveSheet()->setCellValue('B' . ($i + 2), $lists[$i]['create_time']);
                    $objPHPExcel->getActiveSheet()->setCellValue('C' . ($i + 2), $lists[$i]['content']);
                    $objPHPExcel->getActiveSheet()->setCellValue('D' . ($i + 2), $lists[$i]['dep']);
                    $objPHPExcel->getActiveSheet()->setCellValue('E' . ($i + 2), $lists[$i]['order_type']);
                    $objPHPExcel->getActiveSheet()->setCellValue('F' . ($i + 2), $lists[$i]['order_mode_text']);
                    $objPHPExcel->getActiveSheet()->setCellValue('G' . ($i + 2), $lists[$i]['repair_priority']);
                    $objPHPExcel->getActiveSheet()->setCellValue('H' . ($i + 2), $lists[$i]['source_type_text']);
                    $goodsName = $goodsPrice = $goodsNum = $goodsTotal  = '';
                    if(empty($lists[$i]['cons'])){
                        $objPHPExcel->getActiveSheet()->setCellValue('I' . ($i + 2), "");
                        $objPHPExcel->getActiveSheet()->setCellValue('J' . ($i + 2), "");
                        $objPHPExcel->getActiveSheet()->setCellValue('K' . ($i + 2), "");
                        $objPHPExcel->getActiveSheet()->setCellValue('L' . ($i + 2), "");
                    }else{

                        $objPHPExcel->getActiveSheet()->getStyle('I'.($i + 2))->getAlignment()->setWrapText(true);
                        $objPHPExcel->getActiveSheet()->getStyle('J'.($i + 2))->getAlignment()->setWrapText(true);
                        $objPHPExcel->getActiveSheet()->getStyle('K'.($i + 2))->getAlignment()->setWrapText(true);
                        $objPHPExcel->getActiveSheet()->getStyle('L'.($i + 2))->getAlignment()->setWrapText(true);
                        foreach ($lists[$i]['cons'] as $kk=>$vv){
//                            $consstr[] = $vv['title'].'_'.$vv['total'].'_'.$vv['money']."_".$vv['total_money']."_".$vv['realName'];
                            $goodsName.= $vv['title']."\r\n";
                            $goodsPrice.= $vv['money']."\r\n";
                            $goodsNum.= $vv['total']."\r\n";
                            $goodsTotal.= $vv['total_money']."\r\n";
                        }
                        $objPHPExcel->getActiveSheet()->setCellValue('I' . ($i + 2), $goodsName);
                        $objPHPExcel->getActiveSheet()->setCellValue('J' . ($i + 2), $goodsPrice);
                        $objPHPExcel->getActiveSheet()->setCellValue('K' . ($i + 2), $goodsNum);
                        $objPHPExcel->getActiveSheet()->setCellValue('L' . ($i + 2), $goodsTotal);
                    }
                }
            }
            else {
                if ($mode == 3) {
                    for ($i = 0; $i < count($lists); $i++) {
                        $objPHPExcel->getActiveSheet()->setCellValue('A' . ($i + 2), $lists[$i]['sn']);
                        $objPHPExcel->getActiveSheet()->setCellValue('B' . ($i + 2), $lists[$i]['create_time']);
                        $objPHPExcel->getActiveSheet()->setCellValue('C' . ($i + 2), $lists[$i]['start_name']);
                        $objPHPExcel->getActiveSheet()->setCellValue('D' . ($i + 2), $lists[$i]['end_name']);
                        $objPHPExcel->getActiveSheet()->setCellValue('E' . ($i + 2), $lists[$i]['type_name']);
                        $objPHPExcel->getActiveSheet()->setCellValue('F' . ($i + 2), $lists[$i]['content']);
                        $objPHPExcel->getActiveSheet()->setCellValue('G' . ($i + 2), $lists[$i]['dep']);
                        $objPHPExcel->getActiveSheet()->setCellValue('H' . ($i + 2), $lists[$i]['order_mode_text']);
                        $objPHPExcel->getActiveSheet()->setCellValue('I' . ($i + 2), $lists[$i]['source_type_text']);
                        $objPHPExcel->getActiveSheet()->setCellValue('J' . ($i + 2), $lists[$i]['priority']);

                    }
                }
                else {
                    if($mode==0){
                        for ($i = 0; $i < count($lists); $i++) {
                            $objPHPExcel->getActiveSheet()->setCellValue('A' . ($i + 2), $lists[$i]['sn']);
                            $objPHPExcel->getActiveSheet()->setCellValue('B' . ($i + 2), $lists[$i]['create_time']);
                            $objPHPExcel->getActiveSheet()->setCellValue('C' . ($i + 2), $lists[$i]['content']);
                            $objPHPExcel->getActiveSheet()->setCellValue('D' . ($i + 2), $lists[$i]['dep']);
                            $objPHPExcel->getActiveSheet()->setCellValue('E' . ($i + 2), $lists[$i]['order_mode_text']);
                            $objPHPExcel->getActiveSheet()->setCellValue('F' . ($i + 2), $lists[$i]['work_type_mode_text']);
                            $objPHPExcel->getActiveSheet()->setCellValue('G' . ($i + 2), $lists[$i]['source_type_text']);

                        }
                    }else{
                        if($mode==15){
                            for ($i = 0; $i < count($lists); $i++) {
                                $objPHPExcel->getActiveSheet()->setCellValue('A' . ($i + 2), $lists[$i]['sn']);
                                $objPHPExcel->getActiveSheet()->setCellValue('B' . ($i + 2), $lists[$i]['create_time']);
                                $objPHPExcel->getActiveSheet()->setCellValue('C' . ($i + 2), $lists[$i]['content']);
                                $objPHPExcel->getActiveSheet()->setCellValue('D' . ($i + 2), $lists[$i]['dep']);
                                $objPHPExcel->getActiveSheet()->setCellValue('E' . ($i + 2), $lists[$i]['order_mode_text']);
                                $objPHPExcel->getActiveSheet()->setCellValue('F' . ($i + 2), $lists[$i]['source_type_text']);
                                $objPHPExcel->getActiveSheet()->setCellValue('G' . ($i + 2), $lists[$i]['quality_cate_name']);

                            }
                        }else{
                            for ($i = 0; $i < count($lists); $i++) {
                                $objPHPExcel->getActiveSheet()->setCellValue('A' . ($i + 2), $lists[$i]['sn']);
                                $objPHPExcel->getActiveSheet()->setCellValue('B' . ($i + 2), $lists[$i]['create_time']);
                                $objPHPExcel->getActiveSheet()->setCellValue('C' . ($i + 2), $lists[$i]['content']);
                                $objPHPExcel->getActiveSheet()->setCellValue('D' . ($i + 2), $lists[$i]['dep']);
                                $objPHPExcel->getActiveSheet()->setCellValue('E' . ($i + 2), $lists[$i]['order_mode_text']);
                                $objPHPExcel->getActiveSheet()->setCellValue('F' . ($i + 2), $lists[$i]['source_type_text']);

                            }
                        }

                    }
                }
            }
            //设置保存的Excel表格名称
            $filename = $meta_title . '_' . date('YmdHis', time()) . '.xls';
            //设置当前激活的sheet表格名称
            $objPHPExcel->getActiveSheet()->setTitle($meta_title);
            //设置浏览器窗口下载表格
            ob_end_clean();
            header("Content-Type: application/force-download");
            header("Content-Type: application/octet-stream");
            header("Content-Type: application/download");
            header('Content-Disposition:inline;filename="' . $filename);
            //生成excel文件
            $objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
            //下载文件在浏览器窗口
            return $objWriter->save('php://output');
        }
    }

    public function rejectTodoList(){
        $orderId = input('orderId',0);
        if (request()->isAjax()) {
            $length = input('rows', 10, 'intval');   //每页条数
            $page = input('page', 1, 'intval');      //第几页
            $start = ($page - 1) * $length;     //分页开始位置

            $map[] = ['org_id','=',$this->orgId];
            $map[] = ['del','=',0];
            $map[] = ['todo_mode','=',4];
            $map[] = ['order_id','=',$orderId];
            $lists = Db::name('todo')
                ->where($map)
                ->limit($start,$length)
                ->order('id desc')
                ->select();
            $workTypeMode = [
                '0'=>'一键呼叫',
                '1'=>'报修',
                '2'=>'保洁',
                '3'=>'运送',
                '4'=>'应急',
            ];
            foreach ($lists as $k=>$v){
                $lists[$k]['to_user_name'] = Db::name('user')->where('id',$v['to_user_id'])->value('real_name');
                $lists[$k]['work_type_mode_text'] = $workTypeMode[$v['work_type_mode']];
                $lists[$k]['todo_mode_in_content'] = Db::name('todo_mode')->where('id',$v['todo_mode'])->value('in_content');
                $lists[$k]['todo_mode_color'] = Db::name('todo_mode')->where('id',$v['todo_mode'])->value('color');
            }

            $totalCount = Db::name('todo')
                ->where($map)
                ->count();
            $totalPage = ceil($totalCount / $length);
            $result['page'] = $page;
            $result['total'] = $totalPage;
            $result['records'] = $totalCount;
            $result['rows'] = $lists;
            return json($result);
        }
        else {
            $this->assign('orderId',$orderId);
            return $this->fetch();
        }
    }

    public function orderRefreshOff(){
        $info = Db::name('config')->where('name','org_order_refresh')
            ->find();
        $orgConfig = Db::name('config_org')
            ->where('config_id',$info['id'])
            ->where('org_id',$this->orgId)
            ->find();
        if($orgConfig){
            $value = $orgConfig['value']==1?0:1;
            $res = Db::name('config_org')
                ->where('config_id',$info['id'])
                ->where('org_id',$this->orgId)
                ->update(['value'=>$value]);
        }else{
            $value = 1;
            $res = Db::name('config_org')
                ->insertGetId([
                    'config_id'=>$info['id'],
                    'org_id'=>$this->orgId,
                    'value'=>$value,
                ]);
        }
        $res?$this->success('操作成功','',['status'=>$value]):$this->error('操作失败');
    }

    public function print1($id){

        $order = Db::name('orders')->where(['id' => $id])->find();

        $depName = Db::name('dep')
            ->where('id',$order['dep_id'])
            ->value('title');
        $info['depName'] = $depName;
        $info['create_time'] = $order['create_time'];
        $users = Db::name('todo')
            ->alias('t')
            ->join('user u','u.id=t.to_user_id')
            ->where('t.order_id',$order['id'])
            ->column('u.real_name');

        $info['users'] = $users?implode(',',$users):'';
        $info['content'] = $order['content'];
        $info['cons'] = [];

        $tList = Db::name('todo')
            ->where('order_id',$order['id'])
            ->select();
        $total = $totalPrice = 0;
        $signs = [];
        foreach ($tList as $k=>$v){
            if($v['sign']){
                $signs[] = $v['sign'];
            }
            $mate = Db::name('todo_mate_item')
                ->alias('tmi')
                ->join('todo_mate tm','tmi.todo_mate_id = tm.id')
                ->join('mate_goods mg','mg.id = tmi.items_id')
                ->field('tmi.items_id,tmi.total,tmi.money,tmi.total_money,mg.title')
                ->where('tm.todo_id',$v['id'])
                ->select();
            if(!empty($mate)){

                foreach ($mate as $kk=>$todo_mate){
                    $info['cons'][] = [
                        'title' =>$todo_mate['title'],
                        'total' =>$todo_mate['total'],
                        'money' =>$todo_mate['money'],
                        'total_money' =>$todo_mate['total_money'],
                    ];
                    $total +=$todo_mate['total'];
                    $totalPrice +=$todo_mate['total_money'];
                }

            }
        }

        $aa = [
            'title'=>'',
            'total'=>'',
            'money'=>'',
            'total_money'=>'',
        ];
        if(empty($info['cons'])){
            for ($i=1;$i<=4;$i++){
                $info['cons'][] = $aa;
            }
        }elseif (count($info['cons']) <4){
            $ii = 4-count($info['cons']);
            for ($i=1;$i<=$ii;$i++){
                $info['cons'][] = $aa;
            }
        }

        $info['total'] = $total;
        $info['totalPrice'] = round($totalPrice,2);

        $info['signs'] = $signs;

        $this->assign('info', $info);
        return $this->fetch();
    }


    public function withdraw(){
        $id = input('id');

        $info = Db::name('orders')
            ->where('id',$id)
            ->where('del',0)
            ->where('order_mode',4)
            ->find();
        if(!$info){
            $this->error('参数错误');
        }

        $saveOrder = Db::name('orders')
            ->where('id',$id)
            ->update(['order_mode'=>1,'withdraw_time'=>getTime()]);

        $saveTodo = Db::name('todo')
            ->where('order_id',$id)
            ->update(['del'=>1]);

        $todoIds = Db::name('todo')
            ->where('order_id',$id)
            ->where('todo_mode',1)
            ->column('id');

        $task = Db::name('task')
            ->where('type',1)
            ->whereIn('bus_id',$todoIds)
            ->delete();
        if($info['work_type_mode'] == 3){
            Db::name('order_convey_end')->where('order_id',$info['id'])->setField('del',0);
        }


        if(!$saveOrder){
            $this->error('操作失败');
        }

        $this->success('操作成功');

    }


    public function autoSend($id,$form=0) {
        if(request()->isGet() && $form==0){
            $order_type = (new \app\common\model\OrderType())->getList();
            $order_repair = Db::name('order_repair')
                ->where('order_id', $id)
                ->find();
            $this->assign('order_repair', $order_repair);
            $this->assign('order_type_list',$order_type);
            $this->assign('id',$id);
            return $this->fetch();
        }else{
            $type_id = input('type_id/d','');
            if(!empty($type_id)){
                $old = Db::name('order_repair')
                    ->where('order_id', $id)
                    ->find();
                $rData['type_id'] = $type_id;
                if ($old) {
                    $rData['update_time'] = getTime();
                    Db::name('order_repair')
                        ->where('order_id', $id)
                        ->update($rData);
                }
                else {
                    $rData['order_id'] = $id;
                    Db::name('order_repair')
                        ->insert($rData);
                }
            }
            $res = $this->model->autoSend($id);
            if (!$res) {
                $this->error($this->model->getError());
            }
            $this->success('操作成功');
        }

    }

    public function setType($id) {
        if(request()->isGet()){
            $order_type = (new \app\common\model\OrderType())->getList();
            $order_repair = Db::name('order_repair')
                ->where('order_id', $id)
                ->find();
            $this->assign('order_repair', $order_repair);
            $this->assign('order_type_list',$order_type);
            $this->assign('id',$id);
            return $this->fetch();
        }else{
            $type_id = input('type_id/d','');
            if(empty($type_id)){
                $this->error('请选择报修事项');
            }
            $old = Db::name('order_repair')
                ->where('order_id', $id)
                ->find();
            $rData['type_id'] = $type_id;
            if ($old) {
                $rData['update_time'] = getTime();
                $r = Db::name('order_repair')
                    ->where('order_id', $id)
                    ->update($rData);
            }
            else {
                $rData['order_id'] = $id;
                $r =  Db::name('order_repair')
                    ->insert($rData);
            }

            $r?$this->success('操作成功'):$this->error('操作失败');
        }

    }
    public function batchSb(){
        $id = input('ids',[]);
        if(!$id){
            $this->error('参数错误');
        }

        $res = db('user')->where('id','in',$id)->setField('work',1);
        if($res){
            $this->success('操作成功');
        }else{
            $this->error('操作失败');
        }
    }
    public function batchXb(){
        $id = input('ids',[]);
        if(!$id){
            $this->error('参数错误');
        }

        $res = db('user')->where('id','in',$id)->setField('work',0);
        if($res){
            $this->success('操作成功');
        }else{
            $this->error('操作失败');
        }
    }
    public function getTime(){
        $type = input('type');
        $start = input('start');
        $v = Db::name('convey_cate')
            ->where('id',$type)
            ->where('enable',1)
            ->where('del',0)
            ->find();
        if($v['time_id'] > 0){
            $time = Db::name('time')
                ->where('id',$v['time_id'])
                ->find();
            $v['xq_time'] = $start?$start:date('Y-m-d H:i');
            $v['ywc_time'] = date('Y-m-d H:i',strtotime($v['xq_time']) + 60*$time['bz_time']);
        }else{
            $v['xq_time'] = $start?$start:date('Y-m-d H:i');
            $v['ywc_time'] = '';
        }
        $this->success('','',$v);
    }
}