jili2/application/api/controller/screen/Onelevel.php

<?php
namespace app\api\controller\screen;

use app\hander\HelpHander;
use think\Controller;
use think\Db;
use think\helper\Str;
use think\Request;

class Onelevel extends Controller{

    private $orgs = []; // 用户拥有的组织id集合，只区分大区管理员和总公司
    private $orgName = ''; //大区名称

    protected function initialize()
    {
        parent::initialize();

//        $token = input('token','','trim');
//        $token = think_decrypt($token);
//        if(!$token){
//            HelpHander::success("无权限");
//        }
//        $ts = explode('|',$token);
//        if($ts[1] != config('app.ucode')){
//            HelpHander::success("无权限");
//        }

        $map[] = ['type','=',2];
        $map[] = ['del','=',0];
        $map[] = ['enable','=',1];
        $orgids = Db::name('org')
            ->where($map)
            ->column('id');
        $this->orgs = $orgids?$orgids:[-1];


    }

    public function todayTodoInfo(){
        $date = date('Ymd');

        $map[] = ['create_yyyymmdd','=',$date];
        $map[] = ['del','=',0];
        $count = Db::name('todo')->where($map)->where('org_id','in',$this->orgs)->count();

        $map[] = ['todo_mode','=',3];
        $overCount = Db::name('todo')->where($map)->where('org_id','in',$this->orgs)->count();
        $list = [0,0,0,0,0,0];
        $overBl = 0;
        if($count > 0){
            $overBl = round($overCount/$count*100,0);
            $len =  strlen($count);
            if($len == 1){
                $count = '00000'.$count;
            }elseif($len == 2){
                $count = '0000'.$count;
            }elseif($len == 3){
                $count = '000'.$count;
            }elseif($len == 4){
                $count = '00'.$count;
            }elseif($len == 5){
                $count = '0'.$count;
            }else{
                $count = '999999';
            }
            $list = str_split($count);
        }
        $data = [
            'list'=>$list,
            'bl'=>$overBl
        ];

        HelpHander::success($data);
    }

    public function todayTodoType(){
        $date = date('Ymd');

        $map[] = ['create_yyyymmdd','=',$date];
        $map[] = ['del','=',0];

        $map[] = ['create_yyyymmdd','=',$date];
        $map[] = ['del','=',0];

        $count = Db::name('todo')->where($map)->where('work_type_mode',1)->where('org_id','in',$this->orgs)->count();
        $count2 = Db::name('todo')->where($map)->where('work_type_mode',2)->where('org_id','in',$this->orgs)->count();
        $count3 = Db::name('todo')->where($map)->where('work_type_mode',3)->where('org_id','in',$this->orgs)->count();
        $count4 = Db::name('todo')->where($map)->where('work_type_mode',4)->where('org_id','in',$this->orgs)->count();


        $map[] = ['todo_mode','=',3];

        //保修
        $bxCount =  Db::name('todo')->where($map)->where('work_type_mode',1)->where('org_id','in',$this->orgs)->count();
        //保洁
        $bjCount =  Db::name('todo')->where($map)->where('work_type_mode',2)->where('org_id','in',$this->orgs)->count();
        //运送
        $ysCount =  Db::name('todo')->where($map)->where('work_type_mode',3)->where('org_id','in',$this->orgs)->count();
        //隐患
        $yhCount =  Db::name('todo')->where($map)->where('work_type_mode',4)->where('org_id','in',$this->orgs)->count();


        $bxBl = $bjBl = $ysBl = $yhBl =0;
        if($count > 0){
            $bxBl  = round($bxCount/$count*100,0);

        }
        if($count2 >0){
            $bjBl  = round($bjCount/$count2*100,0);
        }
        if($count3 >0){
            $ysBl  = round($ysCount/$count3*100,0);
        }
        if($count4 >0){
            $yhBl  = round($yhCount/$count4*100,0);
        }
        $data = [
            'bx'=>['count'=>$bxCount,'bl'=>$bxBl],
            'bj'=>['count'=>$bjCount,'bl'=>$bjBl],
            'ys'=>['count'=>$ysCount,'bl'=>$ysBl],
            'yh'=>['count'=>$yhCount,'bl'=>$yhBl],
        ];
        HelpHander::success($data);
    }

    public function moduleList(){

        $map[] = ['del','=',0];
        $map[] = ['enable','=',1];
        $map[] = ['type','=',2];

        $orgList = Db::name('org')
            ->field('id,name')
            ->where('id','in',$this->orgs)
            ->where($map)
            ->select();
        $bxCount = $bjCount = $ysCount = $yhCount = $pzCount = $xgCount = $phCount = 0;
        foreach ($orgList as $k=>$v){
            $bx = Db::name('todo')->where('org_id',$v['id'])->where('del',0)->where('work_type_mode',1)->find();
            if($bx){
                $bxCount += 1;
            }
            $bj = Db::name('todo')->where('org_id',$v['id'])->where('del',0)->where('work_type_mode',2)->find();
            if($bj){
                $bjCount += 1;
            }
            $ys = Db::name('todo')->where('org_id',$v['id'])->where('del',0)->where('work_type_mode',3)->find();
            if($ys){
                $ysCount += 1;
            }
            $yh = Db::name('todo')->where('org_id',$v['id'])->where('del',0)->where('work_type_mode',4)->find();
            if($yh){
                $yhCount += 1;
            }
            $pz = Db::name('todo')->where('org_id',$v['id'])->where('del',0)->where('work_type_mode',15)->find();
            if($pz){
                $pzCount += 1;
            }
            $xg = Db::name('patrol_record')->where('org_id',$v['id'])->where('patrol_mode',1)->count();
            if($xg){
                $xgCount += 1;
            }
            $ph = Db::name('ph_todo')->where('org_id',$v['id'])->count();
            if($ph){
                $phCount += 1;
            }
        }
        $data = [
            ['name'=>'保修','value'=>$bxCount],
            ['name'=>'保洁','value'=>$bjCount],
            ['name'=>'运送','value'=>$ysCount],
            ['name'=>'隐患预警','value'=>$yhCount],
            ['name'=>'品质整改','value'=>$pzCount],
            ['name'=>'巡更','value'=>$xgCount],
            ['name'=>'陪护','value'=>$phCount],
        ];



        HelpHander::success($data);

    }

    public function commentComplainList(){
        $date =  [
            date('Y',strtotime('-5 years')),
            date('Y',strtotime('-4 years')),
            date('Y',strtotime('-3 years')),
            date('Y',strtotime('-2 years')),
            date('Y',strtotime('-1 years')),
            date('Y'),
        ];
        $list = $list2 = [];
        foreach ($date as $k=>$v){
            $list[] = Db::name('comment')->where('org_id','in',$this->orgs)->where('create_yyyy',$v)->sum('score');
            $list2[] = Db::name('complain')->where('org_id','in',$this->orgs)->where('create_yyyy',$v)->where('del',0)->count();
        }

        $data = [
            'title'=>$date,
            'list1'=>$list,
            'list2'=>$list2,
        ];

        HelpHander::success($data);

    }

    public function projectCount(){

        $count = Db::name('org')->where('parent_id',1)->where('del',0)->where('enable',1)->where('type',1)->count();

        $count1 =  Db::name('org')->where('del',0)->where('enable',1)->where('type',2)->count();

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

        $orderCount = Db::name('orders')
            ->where('del',0)
            ->count();

        $todoCount = Db::name('todo')
            ->where('del',0)
            ->count();

        $task1 = Db::name('patrol_task')
            ->where('del',0)
            ->count();

        $task2 = Db::name('device_task')
            ->where('del',0)
            ->count();

        $taskCount =  $task1 + $task2;

        $commentScore = Db::name('comment')->whereIn('org_id',$this->orgs)->sum('score');

        $data = [
            'count1'=>$count,
            'count2'=>$count1,
            'count3'=>$count2,
            'count4'=>$orderCount,
            'count5'=>$todoCount,
            'count6'=>$taskCount,
            'count7'=>$commentScore
        ];
        HelpHander::success($data);
    }


    public function quarterScore(){


        $org = Db::name('org')
            ->field('id,name')
            ->where('parent_id',1)
            ->where('del',0)
            ->where('enable',1)
            ->where('type',1)
            ->select();

        foreach ($org as $k=>$v){
            $org[$k]['orgs'] =  $this->getAllNextId($v['id']);
        }

        //获取当前季度
        $season = ceil((date('n'))/3);
        //当前季度开始时间戳
        $startTime = date('Y-m-d H:i:s', mktime(0,0,0,$season*3-3+1,1,date('Y')));
        //获取当前季度结束时间戳
        $overTime = date('Y-m-d H:i:s', mktime(23,59,59,$season*3,date('t',mktime(0,0,0,$season*3,1,date("Y"))),date('Y')));

        $where[] = ['create_yyyymm','>=',date('Ym',strtotime($startTime))];
        $where[] = ['create_yyyymm','<=',date('Ym',strtotime($overTime))];
        $where2[] = ['CREATE_YYYYMM','>=',date('Ym',strtotime($startTime))];
        $where2[] = ['CREATE_YYYYMM','<=',date('Ym',strtotime($overTime))];
        foreach ($org as $k=>$v){
            $org[$k]['score'] = Db::name('comment')->whereIn('org_id',$v['orgs'])->where($where)->sum('score');
        }
        $list = list_sort_by($org,'score','desc');

        $top1 = isset($list[0])?$list[0]:null;
        $top2 = isset($list[1])?$list[1]:null;
        $top3 = isset($list[2])?$list[2]:null;
        $top4 = isset($list[3])?$list[3]:null;
        $top5 = isset($list[4])?$list[4]:null;


        HelpHander::success(['top1'=>$top1,'top2'=>$top2,'top3'=>$top3,'top4'=>$top4,'top5'=>$top5]);
    }


    public function quarterScore2(){
        $map[] = ['del','=',0];
        $map[] = ['enable','=',1];
        $map[] = ['type','=',2];

        $org = Db::name('org')
            ->field('id,name')
            ->where('parent_id',1)
            ->where('del',0)
            ->where('enable',1)
            ->where('type',1)
            ->select();

        foreach ($org as $k=>$v){
            $org[$k]['orgs'] =  $this->getAllNextId($v['id']);
        }

        //获取当前季度
        $season = ceil((date('n'))/3);
        //当前季度开始时间戳
        $startTime = date('Y-m-d H:i:s', mktime(0,0,0,$season*3-3+1,1,date('Y')));
        //获取当前季度结束时间戳
        $overTime = date('Y-m-d H:i:s', mktime(23,59,59,$season*3,date('t',mktime(0,0,0,$season*3,1,date("Y"))),date('Y')));


        $where[] = ['create_yyyymm','>=',date('Ym',strtotime($startTime))];
        $where[] = ['create_yyyymm','<=',date('Ym',strtotime($overTime))];
        foreach ($org as $k=>$v){
            if(in_array(3,$v['orgs']) ){
                $org[$k]['price'] = 5.3;
            }else{
                $org[$k]['price'] = 0;
            }

        }
        $list = list_sort_by($org,'score','desc');

        $top1 = isset($list[0])?$list[0]:null;
        $top2 = isset($list[1])?$list[1]:null;
        $top3 = isset($list[2])?$list[2]:null;
        $top4 = isset($list[3])?$list[3]:null;
        $top5 = isset($list[4])?$list[4]:null;

        HelpHander::success(['top1'=>$top1,'top2'=>$top2,'top3'=>$top3,'top4'=>$top4,'top5'=>$top5]);
    }

    public function fcompanyList(){
        $map[] = ['del','=',0];
        $map[] = ['enable','=',1];
        $map[] = ['type','=',2];

        $org = Db::name('org')
            ->field('id,name')
            ->where('parent_id',1)
            ->where('del',0)
            ->where('enable',1)
            ->where('type',1)
            ->select();

        foreach ($org as $k=>$v){
            $org[$k]['orgs'] =  $this->getAllNextId($v['id']);
        }

        $host = request()->domain(true);
        foreach ($org as $k=>$v){
            if(in_array(3,$v['orgs'])){
                $org[$k]['day'] = 256;
                $org[$k]['nums'] = 1;
                $org[$k]['nums2'] = 1;
                $org[$k]['bl'] = 100;
                $org[$k]['imgs'] = [
                    $host.'/screen/images/nh1.png',
                    $host.'/screen/images/nh2.png',
                    $host.'/screen/images/nh3.png',
                ];
            }else{
                $org[$k]['day'] = 0;
                $org[$k]['nums'] = 0;
                $org[$k]['nums2'] = 0;
                $org[$k]['bl'] = 0;
                $org[$k]['imgs'] = [];
            }

        }

        HelpHander::success($org);
    }

    public function nlxhList(){
        $org = Db::name('org')
            ->field('id,name')
            ->where('parent_id',1)
            ->where('del',0)
            ->where('enable',1)
            ->where('type',1)
            ->select();

        foreach ($org as $k=>$v){
            $org[$k]['orgs'] =  $this->getAllNextId($v['id']);
            if(isset($k) && $k==0){
                $org[$k]['value'] =  556;
            }else if(isset($k) && $k==1){
                $org[$k]['value'] =  875;
            }else if(isset($k) && $k==2){
                $org[$k]['value'] =  345;
            }else if(isset($k) && $k==3){
                $org[$k]['value'] =  234;
            }else if(isset($k) && $k==4){
                $org[$k]['value'] =  797;
            }else if(isset($k) && $k==5) {
                $org[$k]['value'] = 887;
            }
        }



        //获取当前季度
        $season = ceil((date('n'))/3);
        //当前季度开始时间戳
        $startTime = date('Y-m-d H:i:s', mktime(0,0,0,$season*3-3+1,1,date('Y')));
        //获取当前季度结束时间戳
        $overTime = date('Y-m-d H:i:s', mktime(23,59,59,$season*3,date('t',mktime(0,0,0,$season*3,1,date("Y"))),date('Y')));


        $list = array_slice(list_sort_by($org,'value','desc'),0,5);

        HelpHander::success($list);

    }


    //巡查图片
    public function patrolImg(){
        $data = Db::name('patrol_record')
            ->where('images','<>','')
            ->whereIn('org_id',$this->orgs)
            ->limit(20)
            ->order('id desc')
            ->select();

        foreach ($data as $k=>$v){
            $img = explode(',',$v['images']);
            if($img){
                $data[$k]['images'] = $img[0];
            }
        }
        if(count($data)>2){
            $key = array_rand($data,3);
            $list[] = $data[$key[0]];
            $list[] = $data[$key[1]];
            $list[] = $data[$key[2]];
        }
        $eList = isset($list)?$list:$data;
        HelpHander::success($eList);
    }

    public function patrolRecordList(){
        $dlist = [
            date('Y-m-d',strtotime('-6 days')),
            date('Y-m-d',strtotime('-5 days')),
            date('Y-m-d',strtotime('-4 days')),
            date('Y-m-d',strtotime('-3 days')),
            date('Y-m-d',strtotime('-2 days')),
            date('Y-m-d',strtotime('-1 days')),
            date('Y-m-d'),
        ];
        $date = [];
        $yCount = [];
        $y2Count = [];
        $y3Count = [];
        $y4Count = [];
        foreach ($dlist as $k=>$v){
            $tt = date('Ymd',strtotime($v));
            $count = Db::name('patrol_record')
                ->whereIn('org_id',$this->orgs)
                ->where('create_yyyymmdd',$tt)
                ->where('patrol_mode',1)
                ->count();
            $count2 = Db::name('patrol_record')
                ->whereIn('org_id',$this->orgs)
                ->where('create_yyyymmdd',$tt)
                ->where('patrol_mode',2)
                ->count();
            $count3 = Db::name('patrol_record')
                ->whereIn('org_id',$this->orgs)
                ->where('create_yyyymmdd',$tt)
                ->where('patrol_mode',3)
                ->count();
            $count4 = Db::name('patrol_record')
                ->whereIn('org_id',$this->orgs)
                ->where('create_yyyymmdd',$tt)
                ->where('patrol_mode',4)
                ->count();
            $date[] =  date('m-d',strtotime($v));
            $yCount[] = $count;
            $y2Count[] = $count2;
            $y3Count[] = $count3;
            $y4Count[] = $count4;
        }
        $data = [
            'date'=>$date,
            'count1'=>$yCount,
            'count2'=>$y2Count,
            'count3'=>$y3Count,
            'count4'=>$y4Count,
        ];
        HelpHander::success($data);
    }


    // 获取所有下级的id集合
    public function getAllNextId($id,$data=[]){
        $pids = DB::name('org')->where('parent_id',$id)->column('id');
        if(count($pids)>0){
            foreach($pids as $v){
                $data[] = $v;
                $data = $this->getAllNextId($v,$data); //注意写$data 返回给上级
            }
        }
        if(count($data)>0){
            return $data;
        }else{
            return [];
        }
    }

    public function getOrgs(){
        $img1 = getSite().'/screen/images/hz01.png';
        $img2 = getSite().'/screen/images/hz02.png';


        $lists1 = Db::name('org')
            ->field('id,name as title,area_screen_img as img')
            ->where('del',0)
            ->where('enable',1)
            ->where('type',1)
            ->order('id asc')
            ->limit(6)
            ->select();
        foreach ($lists1 as $k=>$v){
            if(!$v['img']){
                $lists1[$k]['img'] = $img2;
            }
        }

        $endArea = $lists1 ? end($lists1):[];

        $endAreaId = $endArea ?$endArea['id']:'';

        $lists3 = [];
        if(count($lists1)== 6 && $endAreaId){
            $lists3 = Db::name('org')
                ->field('id,name as title,area_screen_img as img')
                ->where('del',0)
                ->where('enable',1)
                ->where('type',1)
                ->where('id','>',$endAreaId)
                ->order('id asc')
                ->limit(6)
                ->select();
            foreach ($lists3 as $k=>$v){
                if(!$v['img']){
                    $lists3[$k]['img'] = $img2;
                }
            }
        }
        $endArea2 = $lists3 ? end($lists3):[];
        $endAreaId2 = $endArea2 ? $endArea2['id'] : '';

        $lists2 = [];
        if(count($lists3) == 6 && $endAreaId2){
            $lists2 = Db::name('org')
                ->field('id,name as title,area_screen_img as img')
                ->where('del',0)
                ->where('enable',1)
                ->where('type',1)
                ->where('id','>',$endAreaId2)
                ->order('id asc')
                ->limit(6)
                ->select();
            foreach ($lists2 as $k=>$v){
                if(!$v['img']){
                    $lists2[$k]['img'] = $img2;
                }
            }
        }


        HelpHander::success([
            'lists1'=>$lists1,
            'lists2'=>$lists3,
            'lists3'=>$lists2,
            'lists4'=>$lists2,
        ]);
    }

    public function dailyData(){

        $lists = Db::name('org')
            ->field('id,name as title')
            ->where('enable',1)
            ->where('del',0)
            ->where('type',1)
            ->limit(5)
            ->select();

        $orgs = [];
        $pzdata = [];
        $rwdata = [];
        $max = 0;
        foreach ($lists as $k=>$v){
            $map = [];
            $orgs[] = $v['title'];

            $orgIds = $this->getAllNextId($v['id'],[]);
            if($orgIds){
                $map[] = ['org_id','in',$orgIds];
            }else{
                $map[] = ['org_id','=',-1];
            }
            $pzcount = Db::name('daily_record')->where($map)->where('order_id','>',0)->count();
            $pzdata[] = $pzcount;

            $rwcount = Db::name('daily_record')->where($map)->count();
            if($rwcount > $max){
                $max = $rwcount;
            }
            $rwdata[] = $rwcount;
        }

        HelpHander::success([
            'orgs'=>$orgs,
            'pzdata'=>$pzdata,
            'rwdata'=>$rwdata,
        ]);
    }

    public function todoData(){
        $lists = Db::name('org')
            ->field('id,name as title')
            ->where('enable',1)
            ->where('del',0)
            ->where('type',1)
            ->limit(5)
            ->select();
        $orgs = [];
        $y1 = [];
        $y2 = [];
        $max1 = 0;
        $max2 = 0;
        foreach ($lists as $k=>$v){
            $map = [];
            $orgs[] = $v['title'];

            $orgIds = $this->getAllNextId($v['id'],[]);
            if($orgIds){
                $map[] = ['org_id','in',$orgIds];
            }else{
                $map[] = ['org_id','=',-1];
            }
            $pzcount = Db::name('todo')->where($map)->where('todo_mode',3)->where('del',0)->count();
            $xycount = Db::name('todo')->where($map)->where('todo_mode',3)->where('del',0)->sum('xy_time');
            $wccount = Db::name('todo')->where($map)->where('todo_mode',3)->where('del',0)->sum('wc_time');
            $y2c = $pzcount>0?round(($xycount/60)/$pzcount,1):0;
            $y2[] = $y2c;

            if($y2c > $max2){
                $max2 = $y2c;
            }
            $y1c = $pzcount>0?round(($wccount/60)/$pzcount,1):0;
            $y1[] = $y1c;
            if($y1c > $max1){
                $max1 = $y1c;
            }
        }

        HelpHander::success([
            'orgs'=>$orgs,
            'y1'=>$y1,
            'y2'=>$y2,
        ]);
    }

    public function areaList(){

        $lists = Db::name('org')
            ->field('id,name')
            ->where('del',0)
            ->where('enable',1)
            ->where('type',1)
            ->order('sort asc,id asc')
            ->select();

        HelpHander::success($lists);
    }

    public function orgList(){
        $lists = Db::name('org')
            ->where('del',0)
            ->where('enable',1)
            ->where('type',2)
            ->select();

        foreach ($lists as $k=>$v){
            $lists[$k]['img'] = getSite().'/screen/images/maker.png';
        }

        HelpHander::success($lists);

    }


    public function mateTypeCount(){

        $rk = Db::name('company_dispatch')
            ->alias('cd')
            ->join('company_dispatch_goods cdg','cdg.dispatch_id = cd.id')
            ->where('cd.type',0)
            ->where('cd.status',1)
            ->count();

        $xh = Db::name('todo_mate_item')
            ->alias('tmi')
            ->join('mate_goods mi','mi.id=tmi.items_id')
            ->where('mi.del',0)
            ->sum('tmi.total');

        $cz = Db::name('mate_goods_log')
            ->where('type',1)
            ->sum('nums');

        $orderxh = Db::name('todo_mate')
            ->alias('tm')
            ->join('todo_mate_item tmi','tmi.todo_mate_id=tm.id')
            ->sum('tmi.total');

        $data = [
            'rk'=>$rk,
            'xh'=>$xh,
            'cz'=>$cz,
            'orderxh'=>$orderxh,

        ];
        HelpHander::success($data);
    }


    public function deviceTaskList(){
        $list = [];
        for ($i=1;$i<=12;$i++){
            $list[] = $i;
        }
        $x = $y = $y1 = [];
        foreach ($list as $k=>$v){
            $month = $v;
            if($month < 10){
                $month = '0'.$v;
            }

            $x[] = $v.'月';
            $y[] = Db::name('device_task')
                ->where('del',0)
                ->where('create_yyyymm',date('Y').$month)
                ->count();

            $y1[] = Db::name('device_task_delay')
                ->where('create_time','>=',date('Y').'-'.$month.'-01 00:00:00')
                ->where('create_time','<=',date('Y').'-'.$month.'-31 23:59:59')
                ->where('status',1)
                ->count();
        }

        HelpHander::success(['x'=>$x,'y'=>$y,'y1'=>$y1]);
    }

}