<?php
/**
 * 河长制大屏接口
 * Created by PhpStorm.
 * User: pcl
 * Date: 2022/07/29
 * Time: 09:00
 */

namespace app\api\controller\v1;

use app\common\controller\Api;
use think\Db;
use think\Request;

header('Content-type:text/html; Charset=utf-8');
date_default_timezone_set('PRC');

class Riverdata extends Api
{
    protected $noNeedLogin = ['*'];//*无需验证登陆

    public function __construct(Request $request = null)
    {
        parent::__construct($request);

    }

    /***
     * 今日问题上报列表
     */
    public function getAskList()
    {
        $list = Db::name('river_asklist')
            ->alias('a')
            ->join('river_ask_cat ac', 'a.cat_id=ac.id')
            ->join('river_list l', 'a.river_id=l.id')
            ->whereTime('a.createtime', 'today')
            ->field('a.id,a.title,a.status,a.address,a.lat,a.lng,a.createtime,ac.catname,l.name')
            ->order("a.id desc")
            ->limit(20)
            ->select();
        if (empty($list)) {
            $list = Db::name('river_asklist')
                ->alias('a')
                ->join('river_ask_cat ac', 'a.cat_id=ac.id')
                ->join('river_list l', 'a.river_id=l.id')
                ->field('a.id,a.title,a.status,a.address,a.lat,a.lng,a.createtime,ac.catname,l.name')
                ->order("a.id desc")
                ->limit(20)
                ->select();
        }
        if (!empty($list)) {
            foreach ($list as $k => $v) {
                $list[$k]['createtime'] = date('m/d H:i', $v['createtime']);
            }
        }

        $this->success('获取成功', $list);
    }

    /***
     * 问题详情信息
     */
    public function askInfo()
    {
        $aid = $this->request->post('aid', 0);
        $row = Db::name('river_asklist')
            ->alias('a')
            ->join('river_ask_cat ac', 'a.cat_id=ac.id')
            ->join('river_list l', 'a.river_id=l.id')
            ->join('user u', 'a.user_id=u.id')
            ->where(['a.id' => $aid])
            ->field('a.id,a.title,a.image,a.vdourl,a.status,a.address,a.lat,a.lng,a.createtime,ac.catname,l.name,u.username,u.mobile,u.avatar,u.group_id')
            ->find();
        if (empty($row)) {
            $this->error('内容不存在');
        }
        //处理图片和视频地址
        $row['createtime'] = setdateTimes($row['createtime']);
        if (!empty($row['image'])) {
            $imgarr = explode(',', $row['image']);
            $row['image'] = full_image_kevin($imgarr);
        }
        if (!empty($row['vdourl'])) {
            $vdourlarr = explode(',', $row['vdourl']);
            $row['vdourl'] = full_image_kevin($vdourlarr);
        }

        $this->success('获取成功', $row);
    }

    /***
     * 今日巡河用户及巡河轨迹
     * 列表
     */
    public function getLocationList()
    {
        //巡河列表
        $tday = date('Ymd', time());
        $wh['r.daytime'] = ['=', $tday];
        $wh['r.endtime'] = ['>', 0];
        $list = Db::name('river_patrol_list')
            ->alias('r')
            ->join('river_list l', 'r.river_id=l.id')
            ->join('user u', 'r.user_id=u.id')
            ->where($wh)
            ->field('r.id,r.createtime,r.endtime,r.ordersn,l.name,u.username,u.mobile,u.avatar,u.group_id,r.river_time,r.river_distance')
            ->order('r.id', 'desc')
            ->limit(50)
            ->select();
        if (empty($list)) {
            //今日没有记录，取最新50条
            $wh['r.endtime'] = ['>', 0];
            $list = Db::name('river_patrol_list')
                ->alias('r')
                ->join('river_list l', 'r.river_id=l.id')
                ->join('user u', 'r.user_id=u.id')
                ->where($wh)
                ->field('r.id,r.createtime,r.endtime,r.ordersn,l.name,u.username,u.mobile,u.avatar,u.group_id,r.river_time,r.river_distance')
                ->order('r.id', 'desc')
                ->limit(50)
                ->select();
        }
        $list2 = [];
        $ids2 = [];
        if (!empty($list)) {
            foreach ($list as $k => $v) {

                $ids2[$k] = $v['id'];
                $list2[$k][0] = $v['username'];
                $list2[$k][1] = $v['name'];
                //处理时间
                $list2[$k][2] = set_timearr_to_str($v['river_time']);
                $list2[$k][3] = $v['river_distance'] . 'm';
            }
        } else {
            $list2 = [];
            $ids2 = [];
        }
        $data['id'] = $ids2;
        $data['list'] = $list2;

        $this->success('获取成功', $data);
    }

    /****
     * 用户巡河轨迹详情
     */
    public function patrolInfo()
    {
        $id = $this->request->post('id', 0);
        $list = Db::name('river_patrol_list')
            ->alias('r')
            ->join('river_list l', 'r.river_id=l.id')
            ->join('user u', 'r.user_id=u.id')
            ->where(['r.id' => $id])
            ->field('r.id,r.createtime,r.endtime,r.ordersn,l.name,u.username,u.mobile,u.avatar,u.group_id,r.river_time,r.river_distance')
            ->find();
        if (empty($list)) {
            $this->error('数据不存在');
        }
        if (!empty($list)) {
            $list['river_time_str'] = set_timearr_to_str($list['river_time']);
            $list['river_time'] = json_decode($list['river_time'], true);
            $guiji = Db::name('river_patrol_logs')
                ->where(['ordersn' => $list['ordersn']])
                ->field('id,lat,lng')
                ->order('id', 'asc')
                ->select();
            $list['guiji'] = $guiji;
            $list['createtime'] = setdateTimes($list['createtime']);
            $list['endtime'] = setdateTimes($list['endtime']);
        }

        $this->success('获取成功', $list);
    }

    /****
     * 河湖列表
     */
    public function getRiverList()
    {
        //河流列表
        $helist = Db::name('river_list')
            ->where(['type' => '1', 'river_pid' => 0])
            ->field('id,river_code,name,type,cat_id,river_pid,user_name')
            ->order('id', 'desc')
            ->select();
        if (!empty($helist)) {
            foreach ($helist as $k => $v) {
                //获得分段列表
                $slist = Db::name('river_list')
                    ->where(['river_pid' => $v['id']])
                    ->field('id,river_code,name,type,cat_id,river_pid,user_name')
                    ->order('id', 'asc')
                    ->select();
                $helist[$k]['child'] = $slist;
            }
        }
        $data['heliu'] = $helist;
        //湖泊列表
        $hulist = Db::name('river_list')
            ->where(['type' => '2', 'river_pid' => 0])
            ->field('id,river_code,name,type,cat_id,river_pid,user_name')
            ->order('id', 'desc')
            ->select();
        if (!empty($hulist)) {
            foreach ($hulist as $kk => $vv) {
                //获得分段列表
                $slist2 = Db::name('river_list')
                    ->where(['river_pid' => $vv['id']])
                    ->field('id,river_code,name,type,cat_id,river_pid,user_name')
                    ->order('id', 'asc')
                    ->select();
                $hulist[$kk]['child'] = $slist2;
            }
        }
        $data['hupo'] = $hulist;

        $this->success('获取成功', $data);
    }

    /***
     * 河湖统计、巡河人数、巡河次数、
     * 巡河里程、巡河时长
     */
    public function riverCtAll()
    {
        //河湖统计
        $hehuct = Db::name('river_list')
            ->where(['type' => '1', 'river_pid' => 0])
            ->count();
        $data['heliu_all'] = $hehuct ? $hehuct : 0;
        $huct = Db::name('river_list')
            ->where(['type' => '2', 'river_pid' => 0])
            ->count();
        $data['hupo_all'] = $huct ? $huct : 0;
        //巡河人数
        $userAll = Db::name('river_patrol_list')
            ->group('user_id')
            ->count();
        $data['userAll'] = $userAll ? $userAll : 0;
        //巡河次数
        $numAll = Db::name('river_patrol_list')
            ->count();
        $data['num_All'] = $numAll ? $numAll : 0;
        //巡河时长
        $timeAll = Db::name('river_patrol_list')
            ->sum('river_time_all');
        // 时
        $remain = $timeAll % 86400;
        $hours = ($remain / 3600);
        // 分
        $remain = $timeAll % 3600;
        $mins = ($remain / 60);
        // 秒
        $secs = $remain % 60;
        $time_All = ['hours' => $hours, 'minutes' => $mins, 'seconds' => $secs];
        $data['time_All'] = $time_All;
        //巡河里程
        $distanceAll = Db::name('river_patrol_list')
            ->sum('river_distance');
        $data['distanceAll'] = $distanceAll;

        $this->success('获取成功', $data);
    }

    /***
     * 问题上报统计
     * 数量按分类统计
     */
    public function getAskCt()
    {
        //问题上报总数
        $numall = Db::name('river_asklist')
            ->count();
        $data['num_all'] = $numall ? $numall : 0;
        //未处理
        $status0 = Db::name('river_asklist')
            ->where(['status' => '0'])
            ->count();
        $data['status0'] = $status0 ? $status0 : 0;
        if ($status0 > 0) {
            $data['status0_pct'] = round(($status0 / $numall) * 100, 2);
        } else {
            $data['status0_pct'] = 0;
        }
        //处理中
        $status12 = Db::name('river_asklist')
            ->where(['status' => '1'])
            ->whereOr(['status' => '2'])
            ->count();
        $data['status12'] = $status12 ? $status12 : 0;
        if ($status12 > 0) {
            $data['status12_pct'] = round(($status12 / $numall) * 100, 2);
        } else {
            $data['status12_pct'] = 0;
        }
        //已完成
        $status3 = Db::name('river_asklist')
            ->where(['status' => '3'])
            ->count();
        $data['status3'] = $status3 ? $status3 : 0;
        if ($status3 > 0) {
            $data['status3_pct'] = round(($status3 / $numall) * 100, 2);
        } else {
            $data['status3_pct'] = 0;
        }
        //今日新增数量
        $dayAddCt = Db::name('river_asklist')
            ->whereTime('createtime', 'today')
            ->count();
        $data['dayAddCt'] = $dayAddCt ? $dayAddCt : 0;
        if ($dayAddCt > 0) {
            $data['dayAddCt_pct'] = round(($dayAddCt / $numall) * 100, 2);
        } else {
            $data['dayAddCt_pct'] = 0;
        }

        $this->success('获取成功', $data);
    }

    /****
     * 最新1条问题上报记录
     *
     */
    public function getNewInfo()
    {
        $row = Db::name('river_asklist')
            ->alias('a')
            ->join('river_ask_cat ac', 'a.cat_id=ac.id')
            ->join('river_list l', 'a.river_id=l.id')
            ->join('user u', 'a.user_id=u.id')
            ->where("a.lat>'0'")
            ->field('a.id,a.title,a.image,a.vdourl,a.status,a.address,a.lat,a.lng,a.createtime,ac.catname,l.name,u.nickname,u.avatar,u.mobile')
            ->order('id', 'desc')
            ->find();

        //处理图片和视频地址
        $row['createtime'] = setdateTimes($row['createtime']);
        if (!empty($row['image'])) {
            $imgarr = explode(',', $row['image']);
            $row['image'] = full_image_kevin($imgarr);
        }
        if (!empty($row['vdourl'])) {
            $vdourlarr = explode(',', $row['vdourl']);
            $row['vdourl'] = full_image_kevin($vdourlarr);
        }

        $this->success('获取成功', $row);
    }

    /***
     * 清四乱统计
     * 乱占、乱采、乱堆、乱建
     * [3,4,5,6]
     */
    public function askTypeCt()
    {
        $all = Db::name('river_asklist')
            ->count();
        $row = Db::name('river_asklist')
            ->where(['cat_id' => 3])
            ->count();
        $data['cat3'] = $row ? $row : 0;
        if (!empty($row)) {
            $data['cat3_pct'] = round(($row / $all) * 100, 2);
        } else {
            $data['cat3_pct'] = 0;
        }
        $row4 = Db::name('river_asklist')
            ->where(['cat_id' => 4])
            ->count();
        $data['cat4'] = $row4 ? $row4 : 0;
        if (!empty($row4)) {
            $data['cat4_pct'] = round(($row4 / $all) * 100, 2);
        } else {
            $data['cat4_pct'] = 0;
        }
        $row5 = Db::name('river_asklist')
            ->where(['cat_id' => 5])
            ->count();
        $data['cat5'] = $row5 ? $row5 : 0;
        if (!empty($row5)) {
            $data['cat5_pct'] = round(($row5 / $all) * 100, 2);
        } else {
            $data['cat5_pct'] = 0;
        }
        $row6 = Db::name('river_asklist')
            ->where(['cat_id' => 6])
            ->count();
        $data['cat6'] = $row6 ? $row6 : 0;
        if (!empty($row6)) {
            $data['cat6_pct'] = round(($row6 / $all) * 100, 2);
        } else {
            $data['cat6_pct'] = 0;
        }
        //其他类型的统计
        $wh['cat_id'] = ['not in', [3, 4, 5, 6]];
        $other = Db::name('river_asklist')
            ->where($wh)
            ->count();
        $data['other'] = $other ? $other : 0;
        if (!empty($other)) {
            $data['other_pct'] = round(($other / $all) * 100, 2);
        } else {
            $data['other_pct'] = 0;
        }
        $this->success('获取成功', $data);
    }

}