<?php
/**
+-----------------------------------------------------------------------------------------------------------------------
 * trait ：统计 trait
+-----------------------------------------------------------------------------------------------------------------------
 *
 * PHP version 7
 *
 * @category  App\Models\Traits
 * @package   App\Models\Traits
 * @author    Richer <yangzi1028@163.com>
 * @date      2019年12月18日，14:44:51
 * @copyright 2019-2020 Richer (http://www.umu888.com)
 * @license   http://www.umu888.com License
 * @link      http://www.umu888.com
 */
namespace App\Models\Traits;

use App\Models\Customized\Guide as CustomizedGuide;
use App\Models\Guide;
use App\Models\Order\Order;
use App\Models\Plan\Plan;
use App\Models\Resource\Homestay;
use App\Models\Resource\Hotel;
use App\Models\Resource\Repast;
use App\Models\Resource\Sight;
use App\Models\Specialty;
use App\Models\System\AccessRecord;
use App\Models\Tour\Group as TourGroup;
use App\Models\Tour\Surround as TourSurround;
use App\Models\Tour\Special as TourSpecial;
use App\Models\User\User;
use App\Models\User\Role as UserRole;
use App\Models\Visitor;
use Carbon\Carbon;
use Illuminate\Contracts\View\Factory;
use Illuminate\Support\Arr;

/**
 * Trait StatisticTrait
 *
 * @category  App\Models\Traits
 * @package   App\Models\Traits
 * @author    Richer <yangzi1028@163.com>
 * @date      2019年12月18日，14:44:51
 * @copyright 2019-2020 Richer (http://www.umu888.com)
 * @license   http://www.umu888.com License
 * @link      http://www.umu888.com
 */
trait StatisticTrait
{
    /**
     * 订单统计
     *
     * @param User   $user      用户
     * @param string $user_role 用户角色
     *
     * @return Factory|\Illuminate\View\View
     */
    public function ordersCard($user, $user_role)
    {
        $query = Order::whereIn('status', 1);

        $order['month']     = $this->getGrowthRate($query, $user, $user_role, 'orders', 'month');
        $order['week']      = $this->getGrowthRate($query, $user, $user_role, 'orders', 'week');
        $order['id']        = 'orders';
        $order['box_title'] = '订单统计';
        $order['title']     = '订单总数';
        return $order;
    }

    /**
     * 销售统计
     *
     * @param User   $user      用户
     * @param string $user_role 用户角色
     *
     * @return Factory|\Illuminate\View\View
     */
    public function salesCard($user, $user_role)
    {
        $query = Order::whereIn('status', Order::EFFECTIVE_STATUS_OPTIONS);
        $sales['month']     = $this->getGrowthRate($query, $user, $user_role, 'sales', 'month');
        $sales['week']      = $this->getGrowthRate($query, $user, $user_role, 'sales', 'week');
        $sales['id']        = 'sales';
        $sales['box_title'] = '销售统计';
        $sales['title']     = '销售总额';
        return $sales;
    }

    /**
     * 累计销售总额
     *
     * @param User   $user      用户
     * @param string $user_role 用户角色
     *
     * @return float
     */
    public function getSales($user, $user_role)
    {
        $query = $this->buildOrderSalesQuery(
            Order::whereIn('status', Order::EFFECTIVE_STATUS_OPTIONS),
            $user,
            $user_role
        );
        $data = format_money($query->sum('amount'));

        return $data;
    }

    /**
     * 获取订单数量统计
     *
     * @param User   $user      用户
     * @param string $user_role 用户角色
     *
     * @return int
     */
    public function getOrderCount($user, $user_role)
    {
        $data = $this->buildQuery(
            Order::whereIn('status', Order::EFFECTIVE_STATUS_OPTIONS),
            $user,
            $user_role
        )->count(['id']);
        return  $data;
    }

    /**
     * 获取订单数量统计
     *
     * @param User   $user      用户
     * @param string $user_role 用户角色
     *
     * @return int
     */
    public function getAccessRecordCount($user, $user_role)
    {
        $prefix = config('admin.route.prefix');
        $query = AccessRecord::where('id', '>', 0);

        if ($prefix === 'agency') {
            $query = $query->where('user_id', optional($user)->id)->where('user_id', '>', 0);
        }
        $data = $query->count(['id']);
        return  $data;
    }

    /**
     * 累计玩法案例总量
     *
     * @param User   $user      用户
     * @param string $user_role 用户角色
     *
     * @return int
     */
    public function getBoutiqueNumber($user, $user_role)
    {
        // 跟团游
        $data1 = $this->buildQuery(TourGroup::where('id', '>', 0), $user, $user_role)->count(['id']);
        // 周边游
        $data2 = $this->buildQuery(TourSurround::where('id', '>', 0), $user, $user_role)->count(['id']);
        $data = $data1 + $data2;
        return  $data;
    }

    /**
     * 累计服务人数总量
     *
     * @param User   $user      用户
     * @param string $user_role 用户角色
     *
     * @return int
     */
    public function getPlanServiceNumber($user, $user_role)
    {
        $data = $this->buildQuery(Plan::where('id', '>', 0), $user, $user_role)->sum('service_people');
        return  $data;
    }

    /**
     * 累计来访客户总量
     *
     * @param User   $user      用户
     * @param string $user_role 用户角色
     *
     * @return int
     */
    public function getVisitorNumber($user, $user_role)
    {
        $data = $this->buildQuery(Visitor::where('id', '>', 0), $user, $user_role)->count(['id']);
        //$data = $this->buildQuery(Fan::where('id', '>', 0), $user, $user_role)->count(['id']);
        return  $data;
    }

    /**
     * 对所有的待处理事务进行统计
     * 数据面板统计值：导游派单待选择、导游派单待支付、导游派单待结算、导游预约待支付、行程单待上传、导游预约待结算、待处理产品订单、待处理资源订单
     *
     * @param $type
     * @param User $user 用户
     * @param string $user_role 用户角色
     *
     * @return array
     */
    public function getGrowthRateByType($type, $user, $user_role)
    {
        if ($type === AccessRecord::OBJ_NAME) {
            return $this->getGrowthRateForAccessRecord($user);
        }
        $options =  [
            Plan::OBJ_NAME          => Plan::class,
            Homestay::OBJ_NAME      => Homestay::class,
            Hotel::OBJ_NAME         => Hotel::class,
            Sight::OBJ_NAME         => Sight::class,
            Repast::OBJ_NAME        => Repast::class,
            Specialty::OBJ_NAME     => Specialty::class,
            TourGroup::OBJ_NAME     => TourGroup::class,
            TourSurround::OBJ_NAME  => TourSurround::class,
            TourSpecial::OBJ_NAME   => TourSpecial::class,
            Visitor::OBJ_NAME       => Visitor::class,
            AccessRecord::OBJ_NAME  => \DB::table('access_records'),
            Order::OBJ_NAME         => Order::class,
            'sale'                  => Order::class,
            UserRole::GENERAL       => User::class,
            UserRole::CUSTOMIZER    => User::class,
            UserRole::RESOURCE      => User::class,
            UserRole::TRAVEL_AGENCY => User::class,
        ];

        $class = Arr::get($options, $type) ? : Hotel::class;

        switch ($type) {
            case Plan::OBJ_NAME:
                $query = $class::where('id', '>', 0);
                if (config('admin.route.prefix') === 'agency') {
                    $query = $query->where('category', config('constants.PARTIAL'));
                }
                break;
            case 'sale':
            case Order::OBJ_NAME:
                $query = $class::whereIn('status', Order::EFFECTIVE_STATUS_OPTIONS);
                break;
            case AccessRecord::OBJ_NAME:
                // 页面浏览总量
                $prefix = config('admin.route.prefix');
                $query = $class->where('id', '>', 0);
                if ($prefix === 'agency') {
                    $query = $query->where('user_id', optional($user)->id)->where('user_id', '>', 0);
                }
                break;
            case UserRole::GENERAL:
            case UserRole::CUSTOMIZER:
            case UserRole::TRAVEL_AGENCY:
            case UserRole::AGENT:
            case UserRole::GROUP:
                $query = User::where('role', $type);
                break;
            case UserRole::RESOURCE:
                $query = User::whereIn('role', array_keys(UserRole::RESOURCE_OPTIONS));
                break;
            case Visitor::OBJ_NAME:
                $query = Visitor::where('id', '>', 0);
                break;
            default:
                $query = $class::where('category', config('constants.PARTIAL'));
                break;
        }

        // 对查询条件进行组合
        switch ($type) {
            case 'sale':
            case 'sales':
            case 'orders':
            case Order::OBJ_NAME:
                $query = $this->buildOrderSalesQuery($query, $user, $user_role);
                break;
            case AccessRecord::OBJ_NAME:
                //
                break;
            default:
                $query  = $this->buildQuery($query, $user, $user_role);
                break;
        }

        // 获取统计
//        if ($type !== AccessRecord::OBJ_NAME && $type !== 'sale') {
//            $query  = $this->buildQuery($query, $user, $user_role);
//        }
        if ($type ==='sales' || $type ==='sale') {
            $count  = format_money($query->sum('amount'), true);
        } else {
            $count  = $query->count(['id']);
        }
        $month  = $this->getGrowthRate($query, $user, $user_role, $type, 'month');
        $week   = $this->getGrowthRate($query, $user, $user_role, $type, 'week');
        $day    = $this->getGrowthRate($query, $user, $user_role, $type, 'day');
        $data = [
            'count' => $count,
            'day'   => $day,
            'week'  => $week,
            'month' => $month,
        ];
        return $data;
    }

    /**
     * 对所有的待处理事务进行统计
     * 数据面板统计值：导游派单待选择、导游派单待支付、导游派单待结算、导游预约待支付、行程单待上传、导游预约待结算、待处理产品订单、待处理资源订单
     *
     * @param User $user 用户
     * @param string $user_role 用户角色
     *
     * @return array
     */
    public function getGrowthRatesData($user, $user_role)
    {
        // 获取统计
        // 累计销售总额
        $query = Order::whereIn('status', Order::EFFECTIVE_STATUS_OPTIONS);
        $id     = 'sales';
        $month = $this->getGrowthRate($query, $user, $user_role, $id, 'month');
        $week = $this->getGrowthRate($query, $user, $user_role, $id, 'week');
        $day = $this->getGrowthRate($query, $user, $user_role, $id, 'day');
        $data[$id] = [
            'day' => $day,
            'week' => $week,
            'month' => $month,
        ];

        // 累计商品总销量
        $id     = 'orders';
        $month = $this->getGrowthRate($query, $user, $user_role, $id, 'month');
        $week = $this->getGrowthRate($query, $user, $user_role, $id, 'week');
        $day = $this->getGrowthRate($query, $user, $user_role, $id, 'day');
        $data[$id] = [
            'day'   => $day,
            'week'  => $week,
            'month' => $month,
        ];

        // 页面浏览总量
        $prefix = config('admin.route.prefix');
        $query = AccessRecord::where('id', '>', 0);
        if ($prefix === 'agency') {
            $query = $query->where('user_id', optional($user)->id)->where('user_id', '>', 0);
        }
        $id     = 'access-record';
        $month = $this->getGrowthRate($query, $user, $user_role, $id, 'month');
        $week = $this->getGrowthRate($query, $user, $user_role, $id, 'week');
        $day = $this->getGrowthRate($query, $user, $user_role, $id, 'day');
        $data[$id] = [
            'day' => $day,
            'week' => $week,
            'month' => $month,
        ];

        // 总访客户数
        $id     = 'visitor';
        $query = $this->buildQuery(Visitor::where('id', '>', 0), $user, $user_role);
        $month = $this->getGrowthRate($query, $user, $user_role, $id, 'month');
        $week = $this->getGrowthRate($query, $user, $user_role, $id, 'week');
        $day = $this->getGrowthRate($query, $user, $user_role, $id, 'day');
        $data[$id] = [
            'day' => $day,
            'week' => $week,
            'month' => $month,
        ];

        return $data;
    }

    /**
     * 对所有的待处理事务进行统计
     * 数据面板统计值：导游派单待选择、导游派单待支付、导游派单待结算、导游预约待支付、行程单待上传、导游预约待结算、待处理产品订单、待处理资源订单
     *
     * @param User   $user      用户
     * @param string $user_role 用户角色
     *
     * @return \Illuminate\Http\JsonResponse [type] [description]
     */
    public function getPending($user, $user_role)
    {
        // 导游派单待选择：旅行社提交的定制导游需求未抢单
        $customized_guide_not_grab = $this->buildQuery(
            CustomizedGuide::where('status', CustomizedGuide::SUBMITTED),
            $user,
            $user_role
        )->count(['id']);

        // 导游派单待支付：旅行社提交的定制导游需求已抢单
        $customized_guide_not_pay = $this->buildQuery(
            CustomizedGuide::where('status', CustomizedGuide::GRABBED),
            $user,
            $user_role
        )->count(['id']);

        // 导游派单待结算：旅行社提交的定制导游需求已完成
        $customized_guide_not_settle = $this->buildQuery(
            Order::where('status', Order::COMPLETED),
            $user,
            $user_role
        )
            ->where('orderable_type', [CustomizedGuide::class, CustomizedGuide::OBJ_NAME])
            ->whereDoesntHave('settlement')
            ->count(['id']);

        // 导游预约待支付
        $guide_not_pay = $this->buildQuery(
            Order::where('status', Order::TO_BE_PAID)->where('orderable_type', [Guide::class, Guide::OBJ_NAME]),
            $user,
            $user_role
        )
            ->count(['id']);

        // 行程单待上传

        // 导游预约待结算
        $guide_not_settle = $this->buildQuery(
            Order::where('status', Order::COMPLETED),
            $user,
            $user_role
        )
            ->whereIn('orderable_type', [Guide::class, Guide::class])
            ->whereDoesntHave('settlement')
            ->count(['id']);

        // 待处理订单
        $query_todo = Order::whereIn('status', Order::NEED_TO_DEAL_WITH_STATUS_OPTIONS);
        // 待处理产品订单
        $query_boutique = clone $query_todo;
        $this->buildQuery($query_boutique->whereIn('orderable_type', Order::TOUR_OBJ_NAME), $user, $user_role);
        // 待处理资源订单
        $query_resource = clone $query_todo;
        $this->buildQuery($query_resource->whereIn('orderable_type', Order::RESOURCE_OBJ_NAME), $user, $user_role);
        // 待处理资源订单
        $query_specialty = clone $query_todo;
        $this->buildQuery($query_specialty->whereIn('orderable_type', [Specialty::OBJ_NAME,Specialty::class]), $user, $user_role);

        $data['customized_guide_not_grab']  = $customized_guide_not_grab;
        $data['customized_guide_not_pay']   = $customized_guide_not_pay;
        $data['customized_guide_not_settle']  = $customized_guide_not_settle;
        $data['guide_not_pay']              = $guide_not_pay;
        $data['guide_not_settle']           = $guide_not_settle;
        $data['boutique_order']     = $query_boutique->count(['id']);
        $data['resource_order']     = $query_resource->count(['id']);
        $data['specialty_order']    = $query_specialty->count(['id']);
        return $data;
    }

    /**
     * 获取数据：获取数据并转成echart图表的数据格式
     *
     * @param integer $id        主键id
     * @param User    $user      用户
     * @param string  $user_role 用户角色
     * @param string  $chartType 图表类型
     *
     * @return array
     */
    public function getChartData($id, $user, $user_role, $chartType = 'line')
    {
        $sort           = $this->getSort($id);
        $results        = $this->getBysql($sort, $id, $user, $user_role);
        // 获取图表的名称
        $chartName      = $this->getChartName($id, $sort);
        // 获取新坐标的数据

        $return     = [];
        $legendData = [];  // legend 数据
        $seriess    = []; //
        $xAxisData  = []; // x轴数据集
        $seriesData  = []; //

        switch ($chartType) {
            case 'pie_inner':
                $legendData     = $results['legends'];
                $seriesData[0]['name'] = '客户端类型';
                $seriesData[0]['data'] = $results['client'];
                $seriesData[1]['name'] = '访问模块';
                $seriesData[1]['data'] = $results['modules'];
                $pie_data1      = $results['client'];
                $pie_data2      = $results['modules'];
                break;
            default:
                // 默认为折线图
                $xAxisData      = array_get($results, 'days');
                $seriesData     = array_get($results, 'values');

                $series['name']             = $chartName;
                $legendData[]               = $chartName;
                $series['type']             = $chartType;
                $series['smooth']           = true;// 折线显示为平滑的曲线
                // 设置数据
                $series['data']             = array_get($results, 'values');
                $series['symbolSize']       = 8;//拐点大小

                // 标签 样式
                $label['show']           =  false; // 是否显示
                //$label_normal['color']      = '#01B4F4'; // 颜色
                $label['position']       = '#top'; // 位置
                $textStyle['align']      = 'right';// 水平对齐方式，可选为：'left' | 'right' | 'center'
                $textStyle['baseline']   = 'top';// 垂直对齐方式，可选为：'top' | 'bottom' | 'middle'
                $textStyle['fontSize']   = '14';// 字号 ，单位px
                $textStyle['fontStyle']  = 'italic';// 样式，可选为：'normal' | 'italic' | 'oblique'
                $textStyle['fontWeight'] = '900';// 粗细，可选为：'normal' | 'bold' | 'bolder' | 'lighter' | 100 | 200 |... | 900
                $label['textStyle']      = $textStyle;
                $series['itemStyle']['normal']['label']    = $label;

                // 折线样式设置
                $lineStyle['width'] = 1;
                $lineStyle['shadowColor']   = 'rgba(0,0,0,0)';
                $lineStyle['shadowBlur']    = 5;
                $lineStyle['shadowOffsetX'] = 3;
                $lineStyle['shadowOffsetY'] = 3;
                $series['itemStyle']['normal']['lineStyle']    = $lineStyle;
                //  显示一个区域
                $areaStyle['type'] = 'default';//
                $areaStyle['color'] = '#D5EFFE';

                $series['itemStyle']['normal']['areaStyle']    = $areaStyle;
                $seriess[] = $series;

                break;
        }
        $symbolColor = '#0956ff';
        switch ($id) {
            case 'orders':
                $symbolColor = '#0956ff';
                break;
            case 'sales':
                $symbolColor = '#ff4d00';
                break;
        }
        return [
            'xAxisData'       => $xAxisData ,
            'series'          => $seriess,
            'chartName'       => $chartName,
            'legendData'      => $legendData,
            'chartType'       => $chartType,
            'seriesData'      => $seriesData,
            'symbolColor'     => $symbolColor,
        ];
    }

    /**
     * 获取echart图表的显示名称
     *
     * @param string $objtype 对类型象
     * @param string $sort    排序方式
     *
     * @return string
     */
    public function getChartName($objtype, $sort)
    {
        $name      = '';
        // 根据渲染对象类型设置chart显示名称
        switch ($objtype) {
            case 'users':
                $name      = '会员增长情况';
                break;
            case 'sales':
                $name      = '销售额统计';
                break;
            case 'orders':
                $name      = '订单统计';
                break;
            default:
                // code...
                break;
        }

        // 根据排序方式设置chart显示名称
        switch ($sort) {
            case 'last-week':
                $name      = '最近一周'.$name;
                break;
            case 'week':
                $name      = '本周'.$name;
                break;
            case 'month':
                $name      = '本月'.$name;
                break;
            case 'timerange':
                $startdate  =  request()-> get('startdate');
                $enddate    =  request()-> get('enddate');
                if ($startdate && $enddate) {
                    $name      = $startdate.'至'.$enddate.$name;
                } elseif ($startdate) {
                    $name      = $startdate.'至今'.$name;
                } elseif ($enddate) {
                    $name      = '截止到'.$enddate.$name;
                }

                break;

            default:
                // code...
                break;
        }
        return $name;
    }

    /**
     * 获取每个特定的排序
     *
     * @param string $id id
     *
     * @return mixed|string
     */
    public function getSort($id)
    {
        $sort = 'last-week';
        // 获取排序
        $str = request() -> get('sort');

        if (starts_with($str, $id.'_')) {
            $sort = str_replace($id.'_', '', $str);
        }

        return $sort;
    }

    /**
     * 获取查询结果集
     * 1、获取用户角色，
     * 2、组合查询的SQL语句
     *
     * @param string $type      类型
     * @param string $table     用户
     * @param User   $user      用户
     * @param string $user_role 用户角色
     *
     * @return mixed
     */
    public function getBysql($type, $table, $user, $user_role)
    {
        // 结束时间
        $end_date   = Carbon::tomorrow();
        switch ($type) {
            case 'last-week':// 最近7天
                $start_date = Carbon::parse($end_date)-> subDays(7);
                break;
            case 'week':
                // 本周第一天
                $start_date = now()->startOfWeek();
                break;
            case 'month':
                // 这个月第一天
                $start_date = now()->firstOfMonth();
                break;
            case 'timerange':// 根据时间范围来查询
                $d1 = request()-> get('startdate');
                if (!$d1) {
                    $d1 = '2019-01-01';
                }
                $start_date   = Carbon::parse($d1);

                $d2 = request()-> get('enddate');
                if (!$d2) {
                    $end_date = Carbon::tomorrow();
                } else {
                    $end_date     = Carbon::parse($d2)-> addDays(1);
                }
                break;
            default:
                //
                break;
        }
        // 计算时间差
        $diff     = $end_date->diffInDays($start_date);
        // 获取时间范围
        $start_date = $start_date->toDateString();
        $end_date   = $end_date->toDateString();
        $dates[]    = $start_date;
        for ($i=1; $i<=$diff-1; $i++) {
            $dates[]    = date('Y-m-d', strtotime("$start_date +$i days"));
        }
        $list = [];
        switch ($table) {
            case 'sales':
                $query = Order::whereIn('status', Order::EFFECTIVE_STATUS_OPTIONS)
                    ->whereDate('created_at', '>=', $start_date)
                    ->whereDate('created_at', '<', $end_date)
                    ->groupBy('day');

                $query = $this->buildOrderSalesQuery($query, $user, $user_role);

                $query->select(
                    array(
                        \DB::raw('SUM(amount) as count'),
                        \DB::raw('DATE_FORMAT(created_at, "%Y-%m-%d") AS day')
                    )
                );

                $list = $query->get();
                break;
            case 'orders':
                $query = Order::whereIn('status', Order::EFFECTIVE_STATUS_OPTIONS)
                    ->whereDate('created_at', '>=', $start_date)
                    ->whereDate('created_at', '<', $end_date)
                    ->groupBy('day');

                $query = $this->buildOrderSalesQuery($query, $user, $user_role);

                $query->select(
                    array(
                        \DB::raw('COUNT(id) as count'),
                        \DB::raw('DATE_FORMAT(created_at, "%Y-%m-%d") AS day')
                    )
                );
                $list = $query->get();
                break;
            default:
                $query = \DB::table($table)
                    ->where('created_at', '>=', $start_date)
                    ->where('created_at', '<', $end_date)
                    ->groupBy('day');
                $query = $this->buildQuery($query, $user, $user_role);
                $query->select(
                    array(
                        \DB::raw('COUNT(id) as count'),
                        \DB::raw('DATE_FORMAT(created_at, "%Y-%m-%d") AS day')
                    )
                );
                $list = $query->get();
                break;
        }

        $values = [];
        $days = [] ;
        foreach ($dates as $key => $value) {
            $count = 0;
            if (!empty($list)) {
                foreach ($list as $vo) {
                    if ($value == $vo->day) {
                        $count  = $vo->count;
                    }
                }
            }
            $data['day']    = $value;
            $data['count']  = $count;
            $datas[] = $data;

            $values[]    = $count;
            $days[]      = substr($value, 5);
        }

        $return['days']     = $days;
        $return['values']   = $values;

        return  $return;
    }

    /**
     * 获取同比增长率
     *
     * @param $query
     * @param User $user 用户
     * @param string $user_role 用户角色
     * @param string $objtype 类型
     * @param string $timetype 时间类型
     *
     * @return mixed
     */
    public function getGrowthRate($query, $user, $user_role, $objtype, $timetype = 'month')
    {
        switch ($timetype) {
            case 'month':
                //上个月第一天
                $start_date1 = now()->subMonth()->firstOfMonth()->format('Y-m-d');
                //这个月第一天
                $start_date2 = now()->firstOfMonth()->format('Y-m-d');
                break;
            case 'week':
                // 上周第一天
                $start_date1 = now()->subWeek()->startOfWeek()->format('Y-m-d');
                // 本周第一天
                $start_date2 = now()->startOfWeek()->format('Y-m-d');
                break;
            case 'day':
                // 昨天
                $start_date1 = Carbon::yesterday()->format('Y-m-d');
                // 今天
                $start_date2 = today()->format('Y-m-d');
                break;

            default:
                // code...
                break;
        }

//        $count_last  = 0;
//        $count_this  = 0;
//        $query = Order::whereIn('status', Order::EFFECTIVE_STATUS_OPTIONS);
        // 需要clone一个新的对象
        $query1 = clone $query;
        $query2 = clone $query;
        // 获取上个周期的数据
        $query1 = $query1->whereDate('created_at', '<', $start_date2)->whereDate('created_at', '>=', $start_date1);
        // 获取本周期的数据
        $query2 = $query2->whereDate('created_at', '>=', $start_date2);

        // 根据角色构建查询语句
        switch ($objtype) {
            case 'order':
            case 'orders':
                $query1 = $this->buildOrderSalesQuery($query1, $user, $user_role);
                $query2 = $this->buildOrderSalesQuery($query2, $user, $user_role);
                // 获取上个周期的数据
                $count_last = $query1->count(['id']);
                // 获取本周期的数据
                $count_this = $query2->count(['id']);
                break;
            case 'sales':
            case 'sale':
                $query1 = $this->buildOrderSalesQuery($query1, $user, $user_role);
                $query2 = $this->buildOrderSalesQuery($query2, $user, $user_role);
                // 获取上个周期的数据
                $count_last = $query1->sum('amount');
                // 获取本周期的数据
                $count_this = $query2->sum('amount');
                break;
            default:
                // 获取上个周期的数据
                $count_last = $query1->count(['id']);
                // 获取本周期的数据
                $count_this = $query2->count(['id']);
                break;
        }

        $data['count_last'] = $count_last;
        $data['count']      = $count_this;

//        if ($objtype === 'access-record' && $timetype === 'day') {
//            dump($count_this);
//        }

//        dump($count_last, $count_this);
        // 计算比率
        if ($count_last == 0 && $count_this == 0) {
            $ratio = 0;
        } elseif ($count_last == 0) {
            $ratio = 100;
        } else {
            $ratio = round((($count_this - $count_last)/ $count_last) * 100, 2);
        }


//        if ($objtype === 'access-record' && $timetype === 'day') {
//            dump($ratio);
//        }


        if ($ratio == 0) {
            $data['class']  = 'up';
            $data['icon']   = 'fa-sort-asc';
            $data['color']  = '';
            $ratio = '--';
        } elseif ($ratio > 0) {
            $data['class']  = 'up';
            $data['icon']   = 'fa-sort-asc';
            $data['color']  = 'red';
            $ratio = '+' . abs($ratio).'%';
        } else {
            $data['icon']   = 'up';
            $data['class']  = 'fa-sort-desc';
            $data['color']  = 'blue';
            $ratio          = '-'.abs($ratio) .'%';
        }
        $data['ratio'] = $ratio ;
        return $data;
    }


    /**
     * 对所有的待处理事务进行统计
     * 数据面板统计值：导游派单待选择、导游派单待支付、导游派单待结算、导游预约待支付、行程单待上传、导游预约待结算、待处理产品订单、待处理资源订单
     *
     * @param User $user 用户
     * @return array
     */
    public function getGrowthRateForAccessRecord($user)
    {
        // 页面浏览总量
        $prefix = config('admin.route.prefix');
        $sql_all = 'select count(1) as count from access_records where id > 0';
        if ($prefix === 'agency') {
            $sql_all = $sql_all . ' AND user_id=' .optional($user)->id;
        }

        //上个月第一天
        $start_date1 = now()->subMonth()->firstOfMonth()->format('Y-m-d');
        //这个月第一天
        $start_date2 = now()->firstOfMonth()->format('Y-m-d');

        // 上月数据
        $sql_month_last = $sql_all ." AND `created_at` < '{$start_date2}' AND `created_at` >= '{$start_date1}'";
        // 本月数据
        $sql_month_this = $sql_all ." AND `created_at` > '{$start_date2}'";

        // 上周第一天
        $start_date1 = now()->subWeek()->startOfWeek()->format('Y-m-d');
        // 本周第一天
        $start_date2 = now()->startOfWeek()->format('Y-m-d');
        // 上周数据
        $sql_week_last = $sql_all ." AND `created_at` < '{$start_date2}' AND `created_at` >= '{$start_date1}'";
        // 本周数据
        $sql_week_this = $sql_all ." AND `created_at` > '{$start_date2}'";
        // 昨天
        $start_date1 = Carbon::yesterday()->format('Y-m-d');
        // 今天
        $start_date2 = today()->format('Y-m-d');
        // 昨天数据
        $sql_yesterday = $sql_all ." AND `created_at` < '{$start_date2}' AND `created_at` >= '{$start_date1}'";
        // 今天数据
        $sql_today  = $sql_all ." AND `created_at` > '{$start_date2}'";

        $sql =  $sql_all .' UNION ALL '.
            $sql_month_last .' UNION ALL ' .
            $sql_month_this .' UNION ALL '.
            $sql_week_last . ' UNION ALL '.
            $sql_week_this . ' UNION ALL ' .
            $sql_yesterday . ' UNION ALL ' .
            $sql_today;
        $rs = \DB::select($sql);

        // 获取全部的数据
        $count = $rs[0]->count;

        $data['count'] = $count;

        // 月份数据
        $data += $this->generateData('month', $rs[1]->count, $rs[2]->count);
        // 月份数据
        $data += $this->generateData('week', $rs[3]->count, $rs[4]->count);
        // 月份数据
        $data += $this->generateData('day', $rs[5]->count, $rs[6]->count);
//        dd($data);

        return $data;
    }

    /**
     * 创建数据
     *
     * @param $type
     * @param $count_last
     * @param $count_this
     * @return mixed
     */
    protected function generateData($type, $count_last, $count_this)
    {
        $data['count_last'] = $count_last;
        $data['count']      = $count_this;


        // 计算比率
        if ($count_last == 0 && $count_this == 0) {
            $ratio = 0;
        } elseif ($count_last == 0) {
            $ratio = 100;
        } else {
            $ratio = round((($count_this - $count_last)/ $count_last) * 100, 2);
        }
        if ($ratio == 0) {
            $data['class']  = 'up';
            $data['icon']   = 'fa-sort-asc';
            $data['color']  = '';
            $ratio = '--';
        } elseif ($ratio > 0) {
            $data['class']  = 'up';
            $data['icon']   = 'fa-sort-asc';
            $data['color']  = 'red';
            $ratio = '+' . abs($ratio).'%';
        } else {
            $data['icon']   = 'up';
            $data['class']  = 'fa-sort-desc';
            $data['color']  = 'blue';
            $ratio          = '-'.abs($ratio) .'%';
        }
        $data['ratio'] = $ratio ;

        //
        $return[$type] = $data;
        return $return;
    }
}