zhuishuyun_quickapp/app/Http/Controllers/Manage/Channel/BusinessChannelController.php

<?php
/**
 * Created by PhpStorm.
 * User: tandunzhao
 * Date: 2017/12/26
 * Time: 下午5:32
 */

namespace App\Http\Controllers\Manage\Channel;

use App\Http\Controllers\Manage\Channel\Transformers\BusinessChannelDayStatTransformer;
use App\Http\Controllers\Manage\Channel\Transformers\BusinessChannelStatTransformer;
use App\Http\Controllers\Manage\Channel\Transformers\BusinessCompanyStatTransformer;
use App\Http\Controllers\Manage\Channel\Transformers\BusinessStatDataTransformer;
use App\Http\Controllers\Manage\Finance\BaseController;
use App\Modules\Channel\Models\BusinessChannelStat;
use App\Modules\Channel\Services\BusinessChannelDayStatService;
use App\Modules\Channel\Services\BusinessChannelStatService;
use App\Modules\Channel\Services\ChannelService;
use App\Modules\Channel\Services\CompanyService;
use App\Modules\Manage\Services\ManageService;
use App\Modules\SendOrder\Services\SendOrderService;
use App\Modules\Trade\Services\OrderDayStatService;
use App\Modules\Trade\Services\OrderService;
use App\Modules\Trade\Services\OrderStatService;
use App\Modules\User\Services\UserService;
use DB;
use Illuminate\Http\Request;

class BusinessChannelController extends BaseController
{

    /**
     * @apiVersion 1.0.0
     * @apiDescription 商务渠道数据统计每日列表
     * @api {GET} channel/getBusinessChannelDayList 商务渠道数据统计每日列表
     * @apiGroup channel
     * @apiName channel/getBusinessChannelDayList
     * @apiParam   {Number}  [distribution_channel_id] 渠道id.(可不传，获取所有渠道)
     * @apiParam   {String}  [distribution_channel_name] 渠道名称.(可不传，获取所有渠道)
     * @apiParam   {String}  [search_name] 搜索名称
     * @apiParam   {String}  [start_time] 开始时间(可不传)
     * @apiParam   {String}  [end_time] 结束时间(可不传)
     * @apiParam   {Number}  [is_enabled] 0:待审核； 1:已审核.(可不传)
     * @apiParam   {Number}  [distribution_manages_id] 管理员ID.(可不传)
     * @apiSuccess {Number}  id 渠道ID.
     * @apiSuccess {String}  name 渠道名称.
     * @apiSuccess {String}  phone 手机号码.
     * @apiSuccess {String}  pay_merchant 支付商户.
     * @apiSuccess {String}  nickname 昵称.
     * @apiSuccess {String}  latest_login_time  最后登陆时间.
     * @apiSuccess {String}  latest_login_ip 最后登陆IP.
     * @apiSuccess {String}  remark 备注.
     * @apiSuccess {String}  register_ip 注册IP.
     * @apiSuccess {String}  person_in_charge_name 负责人.
     * @apiSuccess {String}  create_time 注册时间
     * @apiSuccess {Number}  distribution_manages_id 管理员ID
     * @apiSuccess {String}  distribution_manages_account 管理员
     * @apiSuccess {String}  distribution_manages_number 管理员
     * @apiSuccess {String}  distribution_manages_nickname 管理员昵称
     * @apiSuccess {String}  business_channel_day_stats_date 统计时间
     * @apiSuccess {String}  business_channel_day_stats_register_user_num 注册用户数
     * @apiSuccess {String}  business_channel_day_stats_send_order_num 派单数
     * @apiSuccessExample {json} Success-Response:
     *
     *     {
     *         "code": 0,
     *         "msg": "",
     *         "data": [
     *             {
     *                  "id": 1,
     *                   "phone": "",
     *                   "name": "121",
     *                   "pay_merchant_id": 1,
     *                   "nickname": "是说",
     *                   "latest_login_time": "",
     *                   "latest_login_ip": "",
     *                   "is_enabled": 1,
     *                   "register_ip": "",
     *                   "remark": "",
     *                   "person_in_charge_name": "波哥帅",
     *                   "create_time": "2017-11-20 18:34:17",
     *                   "distribution_manages_id": 0,
     *                   "distribution_manages_account": "zsy_finance",
     *                   "distribution_manages_number": "",
     *                   "distribution_manages_nickname": "3333",
     *                   "business_channel_day_stats_date": "2017-12-25",
     *                   "business_channel_day_stats_register_user_num": 0,
     *                   "business_channel_day_stats_send_order_num": 0
     *              }
     *          ]
     *     }
     */
    public function getBusinessChannelDayList(Request $request)
    {
        $distribution_channel_id = $request->has('distribution_channel_id') ? $request->input('distribution_channel_id') : '';
        $distribution_channel_name = $request->has('distribution_channel_name') ? $request->input('distribution_channel_name') : '';

        $start_time = $request->has('start_time') && !empty($request->input('start_time')) ? date('Ymd', strtotime($request->input('start_time'))) : '';
        $end_time = $request->has('end_time') && !empty($request->input('end_time')) ? date('Ymd', strtotime($request->input('end_time'))) : '';
        $end_time = self::getMaxDay($end_time);

        $distribution_manages_id = $request->has('distribution_manages_id') ? $request->input('distribution_manages_id') : '';
        $isEnabled = $request->has('is_enabled') ? $request->input('is_enabled') : '';
        $search_name = $request->has('search_name') ? $request->input('search_name') : '';

        //商务，只获取到当前商务下的渠道列表
        if ($this->getLoginUserRole() == "business") {
            $distribution_manages_id = $this->getLoginUserId();
        }
//        dd($this->getLoginUserId());

        $params = [
            'channel_id' => $distribution_channel_id,
            'channel_name' => $distribution_channel_name,
            'start_date' => $start_time,
            'end_date' => $end_time,
            'distribution_manages_id' => $distribution_manages_id,
            'is_enabled' => $isEnabled,
            'search_name' => $search_name,
        ];

        $result = BusinessChannelDayStatService::getList($params);

        return response()->pagination(new BusinessChannelDayStatTransformer(), $result);
    }

    /**
     * @apiVersion 1.0.0
     * @apiDescription 获商务渠道数据统计列表
     * @api {GET} channel/getBusinessChannelList 商务渠道数据统计列表
     * @apiGroup channel
     * @apiName channel/getBusinessChannelList
     * @apiParam   {Number}  [distribution_channel_id] 渠道id.(可不传，获取所有渠道)
     * @apiParam   {String}  [distribution_channel_name] 渠道名称.(可不传，获取所有渠道)
     * @apiParam   {String}  [search_name] 搜索名称
     * @apiParam   {String}  [start_time] 开始时间(可不传)
     * @apiParam   {String}  [end_time] 结束时间(可不传)
     * @apiParam   {Number}  [is_enabled] 0:待审核； 1:已审核.(可不传)
     * @apiParam   {Number}  [distribution_manages_id] 管理员ID.(可不传)
     * @apiParam   {Number}  [yesterday_register_user_num_sort] 昨日注册用户数排序  0:升序，1:降序.(可不传)
     * @apiParam   {Number}  [current_month_register_user_num_sort] 当月注册用户数排序  0:升序，1:降序.(可不传)
     * @apiParam   {Number}  [last_month_register_user_num_sort] 上月注册用户数排序  0:升序，1:降序.(可不传)
     * @apiParam   {Number}  [total_register_user_num_sort] 总注册用户数排序  0:升序，1:降序.(可不传)
     * @apiParam   {Number}  [total_send_order_num_sort] 总派单数  0:升序，1:降序.(可不传)
     * @apiSuccess {Number}  id 渠道ID.
     * @apiSuccess {String}  name 渠道名称.
     * @apiSuccess {String}  phone 手机号码.
     * @apiSuccess {String}  pay_merchant 支付商户.
     * @apiSuccess {String}  nickname 昵称.
     * @apiSuccess {String}  latest_login_time  最后登陆时间.
     * @apiSuccess {String}  latest_login_ip 最后登陆IP.
     * @apiSuccess {String}  remark 备注.
     * @apiSuccess {String}  register_ip 注册IP.
     * @apiSuccess {String}  person_in_charge_name 负责人.
     * @apiSuccess {String}  create_time 注册时间
     * @apiSuccess {Number}  distribution_manages_id 管理员ID
     * @apiSuccess {String}  distribution_manages_account 管理员
     * @apiSuccess {String}  distribution_manages_number 管理员
     * @apiSuccess {String}  distribution_manages_nickname 管理员昵称
     * @apiSuccess {String}  business_channel_stats_today_register_user_num 今日注册用户数
     * @apiSuccess {String}  business_channel_stats_yesterday_register_user_num 昨日注册用户数
     * @apiSuccess {String}  business_channel_stats_current_month_register_user_num 当月注册用户数
     * @apiSuccess {String}  business_channel_stats_last_month_register_user_num 上月注册用户数
     * @apiSuccess {String}  business_channel_stats_total_register_user_num 总注册用户数
     * @apiSuccess {String}  business_channel_stats_total_send_order_num 总派单数
     * @apiSuccessExample {json} Success-Response:
     *
     *     {
     *         "code": 0,
     *         "msg": "",
     *         "data": [
     *             {
     *                  "id": 1,
     *                   "phone": "",
     *                   "name": "121",
     *                   "pay_merchant_id": 1,
     *                   "nickname": "是说",
     *                   "latest_login_time": "",
     *                   "latest_login_ip": "",
     *                   "is_enabled": 1,
     *                   "register_ip": "",
     *                   "remark": "",
     *                   "person_in_charge_name": "波哥帅",
     *                   "create_time": "2017-11-20 18:34:17",
     *                   "distribution_manages_id": 0,
     *                   "distribution_manages_account": "zsy_finance",
     *                   "distribution_manages_number": "",
     *                   "distribution_manages_nickname": "3333",
     *                   "business_channel_stats_today_register_user_num": 4,
     *                   "business_channel_stats_yesterday_register_user_num": 0,
     *                   "business_channel_stats_current_month_register_user_num": 0,
     *                   "business_channel_stats_last_month_register_user_num": 0,
     *                   "business_channel_stats_total_register_user_num": 0,
     *                   "business_channel_stats_total_send_order_num": 0
     *              }
     *          ]
     *     }
     */
    public function getBusinessChannelList(Request $request)
    {
        $distribution_channel_id = $request->has('distribution_channel_id') ? $request->input('distribution_channel_id') : '';
        $distribution_channel_name = $request->has('distribution_channel_name') ? $request->input('distribution_channel_name') : '';

        $start_time = $request->has('start_time') && !empty($request->input('start_time')) ? date('Ymd', strtotime($request->input('start_time'))) : '';
        $end_time = $request->has('end_time') && !empty($request->input('end_time')) ? date('Ymd', strtotime($request->input('end_time'))) : '';
        $end_time = self::getMaxDay($end_time);

        $distribution_manages_id = $request->has('distribution_manages_id') ? $request->input('distribution_manages_id') : '';
        $isEnabled = $request->has('is_enabled') ? $request->input('is_enabled') : '';
        $search_name = $request->has('search_name') ? $request->input('search_name') : '';

        //商务，只获取到当前商务下的渠道列表
        if ($this->getLoginUserRole() == "business") {
            $distribution_manages_id = $this->getLoginUserId();
        }

        $yesterday_register_user_num_sort = $request->has('yesterday_register_user_num_sort') ? $request->input('yesterday_register_user_num_sort') : '';
        $current_month_register_user_num_sort = $request->has('current_month_register_user_num_sort') ? $request->input('current_month_register_user_num_sort') : '';
        $last_month_register_user_num_sort = $request->has('last_month_register_user_num_sort') ? $request->input('last_month_register_user_num_sort') : '';
        $total_register_user_num_sort = $request->has('total_register_user_num_sort') ? $request->input('total_register_user_num_sort') : '';
        $total_send_order_num_sort = $request->has('total_send_order_num_sort') ? $request->input('total_send_order_num_sort') : '';

        $params = [
            'channel_id' => $distribution_channel_id,
            'channel_name' => $distribution_channel_name,
            'start_date' => $start_time,
            'end_date' => $end_time,
            'distribution_manages_id' => $distribution_manages_id,
            'is_enabled' => $isEnabled,
            'search_name' => $search_name,
            'yesterday_register_user_num_sort' => $yesterday_register_user_num_sort,
            'current_month_register_user_num_sort' => $current_month_register_user_num_sort,
            'last_month_register_user_num_sort' => $last_month_register_user_num_sort,
            'total_register_user_num_sort' => $total_register_user_num_sort,
            'total_send_order_num_sort' => $total_send_order_num_sort,
        ];

        $result = BusinessChannelStatService::getList($params);
        $today = date('Y-m-d');

        if ($result) {
            foreach ($result as $item) {
                $item['business_channel_stats_today_register_user_num'] = UserService::getChannelDayTotal($item['id'], $today);
                $item['business_channel_stats_total_register_user_num'] = UserService::getChannelTotal($item['id']);
            }
        }
        return response()->pagination(new BusinessChannelStatTransformer(), $result);
    }

    /**
     * @apiVersion 1.0.0
     * @apiDescription 获商务所有渠道数据统计汇总
     * @api {GET} channel/getBusinessChannelSingle 获商务所有渠道数据统计汇总
     * @apiGroup channel
     * @apiName channel/getBusinessChannelSingle
     * @apiParam   {Number}  [distribution_manages_id] 管理员ID.(可不传)
     * @apiSuccess {String}  today_register_user_num 今日注册用户数
     * @apiSuccess {String}  yesterday_register_user_num 昨日注册用户数
     * @apiSuccess {String}  current_month_register_user_num 当月注册用户数
     * @apiSuccess {String}  last_month_register_user_num 上月注册用户数
     * @apiSuccess {String}  stats_total_register_user_num 总注册用户数
     * @apiSuccess {String}  stats_total_send_order_num 总派单数
     * @apiSuccessExample {json} Success-Response:
     *
     *     {
     *         "code": 0,
     *         "msg": "",
     *         "data": {
     *                   "today_register_user_num": 4,
     *                   "yesterday_register_user_num": 0,
     *                   "current_month_register_user_num": 0,
     *                   "last_month_register_user_num": 0,
     *                   "total_register_user_num": 0,
     *                   "total_send_order_num": 0
     *          }
     *     }
     */
    public function getBusinessChannelSingle(Request $request)
    {

        $distribution_manages_id = $request->has('distribution_manages_id') ? $request->input('distribution_manages_id') : '';
        //商务，只获取到当前商务下的渠道列表
        if ($this->getLoginUserRole() == "business") {
            $distribution_manages_id = $this->getLoginUserId();
        }

        if ($this->getLoginUserRole() == "admin") {
            $distribution_manages_id = '';
        }

        $channelIds = ChannelService::getChannelIdList($distribution_manages_id);

        $yesterStartDay = date('Y-m-d', strtotime(date("Y-m-d") . " -1 day")) . " 00:00:00";
        $yesterEndDay = date('Y-m-d', strtotime(date("Y-m-d"))) . " 00:00:00";
        $toDayEndDay = date('Y-m-d', strtotime(date("Y-m-d"))) . " 23:59:59";
        $last_monthStartDay = date('Y-m', strtotime(date("Y-m") . " -1 month")) . "-01 00:00:00";
        $current_monthStartDay = date('Y-m', strtotime(date("Y-m"))) . "-01  00:00:00";

        $lastMonthStart = date('Y-m-01 00:00:00',strtotime('-1 month'));
        $lastMonthEnd = date('Y-m-d 23:59:59',strtotime(date('Y-m-01').'-1 day'));
        $today_register_user_num = UserService::getChannelsDayToDayTotal($channelIds, $yesterEndDay, $toDayEndDay);

        $currentMonthStart = date('Y-m-01 00:00:00');
//        $yesterday_register_user_num = UserService::getChannelsDayToDayTotal($channelIds, $yesterStartDay, $yesterEndDay);
//        $current_month_register_user_num = UserService::getChannelsDayToDayTotal($channelIds, $current_monthStartDay, $yesterEndDay);
//        $last_month_register_user_num = UserService::getChannelsDayToDayTotal($channelIds, $last_monthStartDay, $current_monthStartDay);
//        $total_register_user_num = UserService::getChannelsDayToDayTotal($channelIds);
//        $total_send_order_num = SendOrderService::getTotalPromotionCountByChannelIds($channelIds);

        $yesterday_register_user_num = BusinessChannelStat::whereIn('distribution_channel_id', $channelIds)
//            ->where('created_at', '>=', $yesterStartDay)
//            ->where('created_at', '<', $yesterEndDay)
            ->sum('yesterday_register_user_num');
        $current_month_register_user_num = BusinessChannelStat::whereIn('distribution_channel_id', $channelIds)
//            ->where('created_at', '>=', $current_monthStartDay)
//            ->where('created_at', '<', $yesterEndDay)
            ->sum('current_month_register_user_num');
        $last_month_register_user_num = BusinessChannelStat::whereIn('distribution_channel_id', $channelIds)
//            ->where('created_at', '>=', $last_monthStartDay)
//            ->where('created_at', '<', $current_monthStartDay)
            ->sum('last_month_register_user_num');
        $total_register_user_num = BusinessChannelStat::whereIn('distribution_channel_id', $channelIds)
            ->sum('total_register_user_num');
        $total_send_order_num = BusinessChannelStat::whereIn('distribution_channel_id', $channelIds)
            ->sum('total_send_order_num');
        $yesterday_new_companies_num = BusinessChannelStat::getNewAddedCompaniesNum($yesterStartDay,$yesterEndDay,$channelIds);
        $yesterday_new_channel_num = BusinessChannelStat::getNewwAddedChannelNum($yesterStartDay,$yesterEndDay,$channelIds);

        $last_month_new_companies_num = BusinessChannelStat::getNewAddedCompaniesNum($currentMonthStart,date('Y-m-d H:i:s'),$channelIds);
        $last_month_new_channel_num = BusinessChannelStat::getNewwAddedChannelNum($currentMonthStart,date('Y-m-d H:i:s'),$channelIds);
        $recharge_data = OrderStatService::getRechargeAmount($channelIds);
        $manage_company_total_charge_amount = $recharge_data->total_recharge_amount_sum;

        $month_begin_time = date('Y-m-01 00:00:00');
        $manage_company_total_charge_amount_current_month = $recharge_data->current_month_recharge_amount_sum;//OrderDayStatService::getRechargeByChannels($channelIds,$time_range=['begin_time' => $month_begin_time, 'end_time' => $yesterEndDay]);
        //$manage_company_total_charge_amount_current_month = OrderService::getAmount($manage_order_params_current_month);

        return response()->success(compact(
            'today_register_user_num',
            'yesterday_register_user_num',
            'current_month_register_user_num',
            'last_month_register_user_num',
            'total_register_user_num',
            'total_send_order_num',
            'last_month_new_companies_num',
            'last_month_new_channel_num',
            'yesterday_new_companies_num',
            'yesterday_new_channel_num',
            'manage_company_total_charge_amount',
            'manage_company_total_charge_amount_current_month'
        ));
    }


    /**
     * @apiVersion 1.0.0
     * @apiDescription 获商务数据统计列表
     * @api {GET} channel/getBusinessDataList 商务数据统计列表
     * @apiGroup channel
     * @apiName channel/getBusinessDataList
     * @apiParam   {String}  [search_name] 搜索名称
     * @apiParam   {String}  [start_time] 开始时间(可不传)
     * @apiParam   {String}  [end_time] 结束时间(可不传)
     * @apiParam   {Number}  [is_enabled]: 0:不可用； 1:可用
     *
     * @apiSuccess {Number}  distribution_manages_id 管理员ID
     * @apiSuccess {String}  distribution_manages_account 管理员
     * @apiSuccess {String}  distribution_manages_number 管理员
     * @apiSuccess {String}  distribution_manages_nickname 管理员昵称
     * @apiSuccess {String}  today_register_user_num 今日注册用户数
     * @apiSuccess {String}  yesterday_register_user_num 昨日注册用户数
     * @apiSuccess {String}  current_month_register_user_num 当月注册用户数
     * @apiSuccess {String}  last_month_register_user_num 上月注册用户数
     * @apiSuccess {String}  total_register_user_num 总注册用户数
     * @apiSuccess {String}  total_send_order_num 总派单数
     * @apiSuccessExample {json} Success-Response:
     *
     *     {
     *         "code": 0,
     *         "msg": "",
     *         "data": [
     *             {
     *                   "distribution_manages_id": 0,
     *                   "distribution_manages_account": "zsy_finance",
     *                   "distribution_manages_nickname": "3333",
     *                   "distribution_manages_latest_login_time": "",
     *                   "distribution_manages_latest_login_ip": "",
     *                   "distribution_manages_is_enabled": 1,
     *                   "distribution_manages_remark": "",
     *                   "distribution_manages_register_ip": "",
     *                   "distribution_manages_create_time": "",
     *                   "distribution_manages_update_time": "",
     *                   "distribution_manages_number": "",
     *                   "today_register_user_num": 4,
     *                   "yesterday_register_user_num": 0,
     *                   "current_month_register_user_num": 0,
     *                   "last_month_register_user_num": 0,
     *                   "total_register_user_num": 0,
     *                   "total_send_order_num": 0
     *              }
     *          ]
     *     }
     */
    public function getBusinessDataList(Request $request)
    {

        $start_time = $request->has('start_time') && !empty($request->input('start_time')) ? date('Ymd', strtotime($request->input('start_time'))) : '';
        $end_time = $request->has('end_time') && !empty($request->input('end_time')) ? date('Ymd', strtotime($request->input('end_time'))) : '';
        $end_time = self::getMaxDay($end_time);

        $isEnabled = $request->has('is_enabled') ? $request->input('is_enabled') : '';
        $search_name = $request->has('search_name') ? $request->input('search_name') : '';

        $params = [
            'start_date' => $start_time,
            'end_date' => $end_time,
            'is_enabled' => $isEnabled,
            'search_name' => $search_name,
        ];

        $business = ManageService::getBusinessManageList($params);

        $today = date('Y-m-d');
        $todayEnd = $today . " 23:59:59";

        if ($business) {
            foreach ($business as $item) {
                $channelIds = ChannelService::getChannelIdList($item['id']);
                $business_channel_stats = BusinessChannelStatService::getBusinessChannelStatSingle($channelIds);

                $item['yesterday_register_user_num'] = $business_channel_stats->yesterday_register_user_num;
                $item['current_month_register_user_num'] = $business_channel_stats->current_month_register_user_num;
                $item['last_month_register_user_num'] = $business_channel_stats->last_month_register_user_num;
                $item['total_register_user_num'] = $business_channel_stats->total_register_user_num;
                $item['total_send_order_num'] = $business_channel_stats->total_send_order_num;

                $item['current_month_new_channels_recharge'] = $business_channel_stats->current_month_new_channels_recharge_sum;
                $item['current_month_channels_recharge'] = $business_channel_stats->current_month_channels_recharge_sum;
                $item['last_month_channels_recharge_sum'] = $business_channel_stats->last_month_channels_recharge_sum;
                $item['last_month_new_channels_recharge_sum'] = $business_channel_stats->last_month_new_channels_recharge_sum;

                $item['today_register_user_num'] = UserService::getChannelsDayToDayTotal($channelIds, $today, $todayEnd);
                $item['current_month_companies_num'] = BusinessChannelStat::getNewAddedCompaniesNum(date('Y-m-01 00:00:00', time()), date('Y-m-d H:i:s'), $channelIds);
                $item['current_month_channel_num'] = BusinessChannelStat::getNewwAddedChannelNum(date('Y-m-01 00:00:00', time()), date('Y-m-d H:i:s'), $channelIds);
                $item['last_month_companies_num'] = BusinessChannelStat::getNewAddedCompaniesNum(date('Y-m-01',strtotime('-1 month')),date('Y-m-d H:i:s',strtotime(date('Y-m-01 23:59:59').' -1 day')),$channelIds);
                $item['last_month_channel_num'] = BusinessChannelStat::getNewwAddedChannelNum(date('Y-m-01',strtotime('-1 month')),date('Y-m-d H:i:s',strtotime(date('Y-m-01 23:59:59').' -1 day')),$channelIds);
            }
        }
        return response()->pagination(new BusinessStatDataTransformer(), $business);
    }


    /**
     * @apiVersion 1.0.0
     * @apiDescription 获商务渠道数据统计列表
     * @api {GET} channel/getBusinessChannelList2 商务渠道数据统计列表
     * @apiGroup channel
     * @apiName channel/getBusinessChannelList2
     * @apiParam   {Number}  [distribution_channel_id] 渠道id.(可不传，获取所有渠道)
     * @apiParam   {String}  [distribution_channel_name] 渠道名称.(可不传，获取所有渠道)
     * @apiParam   {String}  [search_name] 搜索名称
     * @apiParam   {String}  [start_time] 开始时间(可不传)
     * @apiParam   {String}  [end_time] 结束时间(可不传)
     * @apiParam   {Number}  [is_enabled] 0:待审核； 1:已审核.(可不传)
     * @apiParam   {Number}  [distribution_manages_id] 管理员ID.(可不传)
     * @apiParam   {Number}  [yesterday_register_user_num_sort] 昨日注册用户数排序  0:升序，1:降序.(可不传)
     * @apiParam   {Number}  [current_month_register_user_num_sort] 当月注册用户数排序  0:升序，1:降序.(可不传)
     * @apiParam   {Number}  [last_month_register_user_num_sort] 上月注册用户数排序  0:升序，1:降序.(可不传)
     * @apiParam   {Number}  [total_register_user_num_sort] 总注册用户数排序  0:升序，1:降序.(可不传)
     * @apiParam   {Number}  [total_send_order_num_sort] 总派单数  0:升序，1:降序.(可不传)
     * @apiSuccess {Number}  id 渠道ID.
     * @apiSuccess {String}  name 渠道名称.
     * @apiSuccess {String}  phone 手机号码.
     * @apiSuccess {String}  pay_merchant 支付商户.
     * @apiSuccess {String}  nickname 昵称.
     * @apiSuccess {String}  latest_login_time  最后登陆时间.
     * @apiSuccess {String}  latest_login_ip 最后登陆IP.
     * @apiSuccess {String}  remark 备注.
     * @apiSuccess {String}  register_ip 注册IP.
     * @apiSuccess {String}  person_in_charge_name 负责人.
     * @apiSuccess {String}  create_time 注册时间
     * company_name--公司名
     * business_channel_stats_today_register_user_num  今日注册数
     * business_channel_stats_yesterday_register_user_num 昨日注册用户数
     * business_channel_stats_current_month_register_user_num 当月注册用户数
     * business_channel_stats_last_month_register_user_num 上月注册用户数
     * business_channel_stats_total_register_user_num 总注册用户数
     * business_channel_stats_total_send_order_num 总派单数
     * business_channel_stats_service_account_sum 服务号数
     * business_channel_stats_last_week_actual_send_orders_sum 上周实际派单
     * business_channel_stats_current_week_actual_send_orders_sum 本周实际派单
     * business_channel_stats_yesterday_create_orders_sum 昨日创建派单
     * business_channel_stats_last_week_login_day_sum 上周登录天数
     * business_channel_stats_current_week_login_days_sum 本周登录天数
     * business_channel_stats_is_yesterday_login 昨日是否登录
     *
     * @apiSuccess {Number}  distribution_manages_id 管理员ID
     * @apiSuccess {String}  distribution_manages_account 管理员
     * @apiSuccess {String}  distribution_manages_number 管理员
     * @apiSuccess {String}  distribution_manages_nickname 管理员昵称
     * @apiSuccess {String}  business_channel_stats_today_register_user_num 今日注册用户数
     * @apiSuccess {String}  business_channel_stats_yesterday_register_user_num 昨日注册用户数
     * @apiSuccess {String}  business_channel_stats_current_month_register_user_num 当月注册用户数
     * @apiSuccess {String}  business_channel_stats_last_month_register_user_num 上月注册用户数
     * @apiSuccess {String}  business_channel_stats_total_register_user_num 总注册用户数
     * @apiSuccess {String}  business_channel_stats_total_send_order_num 总派单数
     * @apiSuccessExample {json} Success-Response:
     *
     *     {
     *         "code": 0,
     *         "msg": "",
     *         "data": [
     *             {
     *                  "id": 1,
     *                   "phone": "",
     *                   "name": "121",
     *                   "pay_merchant_id": 1,
     *                   "nickname": "是说",
     *                   "latest_login_time": "",
     *                   "latest_login_ip": "",
     *                   "is_enabled": 1,
     *                   "register_ip": "",
     *                   "remark": "",
     *                   "person_in_charge_name": "波哥帅",
     *                   "create_time": "2017-11-20 18:34:17",
     *                   "distribution_manages_id": 0,
     *                   "distribution_manages_account": "zsy_finance",
     *                   "distribution_manages_number": "",
     *                   "distribution_manages_nickname": "3333",
     *                   "business_channel_stats_today_register_user_num": 4,
     *                   "business_channel_stats_yesterday_register_user_num": 0,
     *                   "business_channel_stats_current_month_register_user_num": 0,
     *                   "business_channel_stats_last_month_register_user_num": 0,
     *                   "business_channel_stats_total_register_user_num": 0,
     *                   "business_channel_stats_total_send_order_num": 0
     *              }
     *          ]
     *     }
     */
    public function getBusinessCompanyList(Request $request)
    {
        $distribution_channel_id = $request->has('company_id') ? $request->input('company_id') : '';
        $distribution_channel_name = $request->has('company_name') ? $request->input('company_name') : '';
        $distribution_manages_name = $request->has('manager_name') ? $request->input('manager_name') : '';

        $start_time = $request->has('start_time') && !empty($request->input('start_time')) ? date('Ymd', strtotime($request->input('start_time'))) : '';
        $end_time = $request->has('end_time') && !empty($request->input('end_time')) ? date('Ymd', strtotime($request->input('end_time'))) : '';
        $end_time = self::getMaxDay($end_time);

        $distribution_manages_id = $request->has('distribution_manages_id') ? $request->input('distribution_manages_id') : '';
        $isEnabled = $request->has('is_enabled') ? $request->input('is_enabled') : '';
        $search_name = $request->has('search_name') ? $request->input('search_name') : '';

        //商务，只获取到当前商务下的渠道列表
        if ($this->getLoginUserRole() == "business") {
            $distribution_manages_id = $this->getLoginUserId();
        }

        $yesterday_register_user_num_sort = $request->has('yesterday_register_user_num_sort') ? $request->input('yesterday_register_user_num_sort') : '';
        $current_month_register_user_num_sort = $request->has('current_month_register_user_num_sort') ? $request->input('current_month_register_user_num_sort') : '';
        $last_month_register_user_num_sort = $request->has('last_month_register_user_num_sort') ? $request->input('last_month_register_user_num_sort') : '';
        $total_register_user_num_sort = $request->has('total_register_user_num_sort') ? $request->input('total_register_user_num_sort') : '';
        $total_send_order_num_sort = $request->has('total_send_order_num_sort') ? $request->input('total_send_order_num_sort') : '';

        $params = [
            'company_id' => $distribution_channel_id,
            'company_name' => $distribution_channel_name,
            'manager_name' => $distribution_manages_name,
            'start_date' => $start_time,
            'end_date' => $end_time,
            'distribution_manages_id' => $distribution_manages_id,
            'is_enabled' => $isEnabled,
            'search_name' => $search_name,
            'yesterday_register_user_num_sort' => $yesterday_register_user_num_sort,
            'current_month_register_user_num_sort' => $current_month_register_user_num_sort,
            'last_month_register_user_num_sort' => $last_month_register_user_num_sort,
            'total_register_user_num_sort' => $total_register_user_num_sort,
            'total_send_order_num_sort' => $total_send_order_num_sort,
        ];
        //\Log::info('time_check:getListNew:before--:'.time());
        $result = BusinessChannelStatService::getListNew($params);
       // \Log::info('time_check:getListNew:after--:'.time());
        $today = date('Y-m-d');
        //\Log::info('businessChannelStats:' . json_encode($result));
        if ($result) {
            foreach ($result as $item) {
                $company = DB::table('companies')->where('id', $item['company_id'])->first();
                $distribution_channel_ids = [];
                if ($company) {
                    $company_id = $company->id;
                    $company_name = $company->name;
                   // \Log::info('time_check:getCompanyServiceAccounts:before--'.time());
                    $company_service_account = CompanyService::getCompanyServiceAccounts($company_id);
                   // \Log::info('time_check:getCompanyServiceAccounts:after--'.time());
                    foreach ($company_service_account as $company_service_account_item) {
                        $distribution_channel_ids[] = $company_service_account_item->distribution_channel_id;
                    }
                    $yesterdayEnd = date('Y-m-d', strtotime(date("Y-m-d") . " -1 day")) . " 23:59:59";
                    $recharge_data = OrderStatService::getRechargeAmount($distribution_channel_ids);
                    $item['company_total_charge_amount'] = $recharge_data->total_recharge_amount_sum;// OrderStatService::getRechargeAmount($distribution_channel_ids);

                    $month_begin_time = date('Y-m-01 00:00:00');

                    $item['company_total_charge_amount_current_month'] = $recharge_data->current_month_recharge_amount_sum;//OrderDayStatService::getRechargeByChannels($distribution_channel_ids,$time_range=['begin_time' => $month_begin_time, 'end_time' => $yesterdayEnd]); //OrderService::getAmount($company_order_params_current_month);

                    $item['company_name'] = $company_name;
                    $fans_gender = $company->fans_gender;
                    switch ($fans_gender) {
                        case 1:
                            $item['fans_gender'] = '男粉';
                            break;
                        case 2:
                            $item['fans_gender'] = '女粉';
                            break;
                        case 3:
                            $item['fans_gender'] = '混合粉';
                            break;
                        default:
                            $item['fans_gender'] = '';
                    }
                } else {
                    $item['company_name'] = '';
                    $item['fans_gender'] = '';
                    //\Log::info('company error:' . $item['company_id']);
                }
                //\Log::info('time_check:UserService::getCompanyDayTotal:before:'.time());
                $item['business_channel_stats_today_register_user_num'] = UserService::getCompanyDayTotal($today, $item['company_id']);
                //\Log::info('time_check:UserService::getCompanyTotal:before:'.time());
                $item['business_channel_stats_total_register_user_num'] = UserService::getCompanyTotal($item['company_id']);
                //\Log::info('time_check:UserService::getCompanyTotal:after:'.time());
            }
        }
        return response()->pagination(new BusinessCompanyStatTransformer(), $result);
    }

    public function getCompanyLastWeekPromotion(Request $request)
    {
        $company_id = $request->input('company_id', '');
        if (!$company_id) {
            return response()->error('PARAM_EMPTY');
        }
        $time = $request->input('time', '');
        if (!$time) {
            return response()->error('PARAM_EMPTY');
        }
        if (!in_array($time, ['current', 'last'])) {
            return response()->error('PARAM_ERROR');
        }
        $books = [];
        if ($time == 'current') {
            $current_week_start = date("Y-m-d H:i:s", mktime(0, 0, 0, date("m"), date("d") - date("w") + 1, date("Y")));
            $current_week_end = date("Y-m-d H:i:s", mktime(23, 59, 59, date("m"), date("d") - date("w") + 7, date("Y")));
            $books = SendOrderService::getCompanyPromotionBooks($company_id, $current_week_start, $current_week_end);
            //return response()->success($books);
        }
        if ($time == 'last') {
            $beginLastweek = date('Y-m-d H:i:s', mktime(0, 0, 0, date('m'), date('d') - date('w') + 1 - 7, date('Y')));
            $endLastweek = date('Y-m-d H:i:s', mktime(23, 59, 59, date('m'), date('d') - date('w') + 7 - 7, date('Y')));
            $books = SendOrderService::getCompanyPromotionBooks($company_id, $beginLastweek, $endLastweek);
        }

        return response()->success($books);
    }

    public function getServiceAccount(Request $request)
    {
        $company_id = $request->input('company_id', '');
        if (empty($company_id)) {
            return response()->error('PARAM_EMPTY');
        }
        $accounts = CompanyService::getCompanyServiceAccounts($company_id);
        return response()->success($accounts);
    }
}