Customer-Service/application/admin/controller/Report.php

<?php

namespace app\admin\controller;


use  app\admin\model\Countmidtable;

/**
 * 报表类
 */
class Report extends Base
{


    /**
     * 工作报表
     *
     * @access public
     * @return array JsonString
     */
    public function index()
    {
        $param = input('param.');
        $startTime = isset($param['start']) ? $param['start'] : date('Y-m-d', strtotime("-6 day"));
        $endTime = isset($param['end']) ? $param['end'] : date('Y-m-d');
        $timeInterval = $this->Date_segmentation($startTime, $endTime);
        $queueData = [];
        $chatData = [];
        $serviceData = [];
        $xData = [];
        foreach ($timeInterval['days_list'] as $k => $value) {
            $allCount = 0;
            $evaluateGood = 0;
            $evaluateSecondary = 0;
            $evaluateBad = 0;
            $evaluateNo = 0;
            $dayBegin = strtotime($value);
            $dayEnd = strtotime($value) + 24 * 60 * 60;
            $chatLogCountWhere['start_time'] = ['between', [$dayBegin, $dayEnd]];
            $join = [
                'alarm b' => 'a.servicelog_id = b.servicelog_id',
            ];
            $field = ['alarm_count', 'evaluate_id', 'system'];
            $system = [];
            $systemCount = [];
            // 查询当天的工单.
            $serviceLog = model('serviceLog')->selectServiceLog($field, $join, $chatLogCountWhere);
            foreach ($serviceLog as $ke => $va) {
                $allCount += $va['alarm_count'];
                if ($va['evaluate_id'] == 1) {
                    $evaluateGood++;
                } elseif ($va['evaluate_id'] == 2) {
                    $evaluateSecondary++;
                } elseif ($va['evaluate_id'] == 3) {
                    $evaluateBad++;
                } elseif ($va['evaluate_id'] == 0) {
                    $evaluateNo++;
                }
                if (!isset($system[$va['system']])) {
                    $system[$va['system']] = 1;
                } else {
                    $system[$va['system']]++;
                }
            }
            // 会话总数.
            $xData[] = $value;
            $chatData[$k] = $allCount;
            // 当天工单总数.
            $serviceData[$k] = model('serviceLog')->countServiceLog($chatLogCountWhere);
        }
        foreach ($system as $k => $v) {
            $systemCount[] = [
                'value' => $v,
                'name' => $k,
            ];
        }

        $queueData =(new  Countmidtable())->getQueryDay($timeInterval['days_list']);


        $this->assign([
            'xData' => json_encode($xData),
            'chatData' => json_encode($chatData),
            'serviceData' => json_encode($serviceData),
            'queueData' => json_encode($queueData),
            'systemCount' => json_encode($systemCount),
            'evaluate' => json_encode([
                'evaluateGood' => $evaluateGood,
                'evaluateSecondary' => $evaluateSecondary,
                'evaluateBad' => $evaluateBad,
                'evaluateNo' => $evaluateNo,
            ]),
        ]);

        return $this->fetch('index');

    }//end index()


    /**
     * 时间分割
     *
     * @access public
     * @return array JsonString
     */
    function Date_segmentation($start_date, $end_date)
    {
        //如果为空，则从今天的0点为开始时间
        if (!empty($start_date))
            $start_date = date('Y-m-d H:i:s', strtotime($start_date));
        else {
            $start_date = date('Y-m-d 00:00:00', time());
        }

        //如果为空，则以明天的0点为结束时间（不存在24:00:00，只会有00:00:00）
        if (!empty($end_date))
            $end_date = date('Y-m-d H:i:s', strtotime($end_date));
        else
            $end_date = date('Y-m-d 00:00:00', strtotime('+1 day'));

        //between 查询 要求必须是从低到高
        if ($start_date > $end_date) {
            $ttt = $start_date;
            $start_date = $end_date;
            $end_date = $ttt;
        } elseif ($start_date == $end_date) {
            echo '时间输入错误';
            die;
        }

        $time_s = strtotime($start_date);
        $time_e = strtotime($end_date);
        $seconds_in_a_day = 86400;

        //生成中间时间点数组（时间戳格式、日期时间格式、日期序列）
        $days_inline_array = array();
        $times_inline_array = array();

        //日期序列
        $days_list = array();
        //判断开始和结束时间是不是在同一天
        $days_inline_array[0] = $start_date;  //初始化第一个时间点
        $times_inline_array[0] = $time_s;     //初始化第一个时间点
        $days_list[] = date('Y-m-d', $time_s);//初始化第一天
        if (date('Y-m-d', $time_s) == date('Y-m-d', $time_e)) {
            $days_inline_array[1] = $end_date;
            $times_inline_array[1] = $time_e;
        } else {
            /**
             * A.取开始时间的第二天凌晨0点
             * B.用结束时间减去A
             * C.用B除86400取商，取余
             * D.用A按C的商循环+86400，取得分割时间点，如果C没有余数，则最后一个时间点 与 循环最后一个时间点一致
             */
            $A_temp = date('Y-m-d 00:00:00', $time_s + $seconds_in_a_day);
            $A = strtotime($A_temp);
            $B = $time_e - $A;
            $C_quotient = floor($B / $seconds_in_a_day);    //商舍去法取整
            $C_remainder = fmod($B, $seconds_in_a_day);               //余数
            $days_inline_array[1] = $A_temp;
            $times_inline_array[1] = $A;
            $days_list[] = date('Y-m-d', $A);              //第二天
            for ($increase_time = $A, $c_count_t = 1; $c_count_t <= $C_quotient; $c_count_t++) {
                $increase_time += $seconds_in_a_day;
                $days_inline_array[] = date('Y-m-d H:i:s', $increase_time);
                $times_inline_array[] = $increase_time;
                $days_list[] = date('Y-m-d', $increase_time);
            }
            $days_inline_array[] = $end_date;
            $times_inline_array[] = $time_e;
        }

        return array(
            'start_date' => $start_date,
            'end_date' => $end_date,
            'days_list' => $days_list,
            'days_inline' => $days_inline_array,
            'times_inline' => $times_inline_array
        );
    }


}//end class