zhuishuyun_quickapp/app/Http/Controllers/Channel/SendOrder/SendOrderController.php

<?php
/**
 * Created by PhpStorm.
 * User: hp
 * Date: 2017/11/22
 * Time: 11:36
 */

namespace App\Http\Controllers\Channel\SendOrder;

use App\Http\Controllers\Channel\BaseController;
use App\Http\Controllers\Channel\SendOrder\Transformers\SendOrderTransformer;
use App\Modules\Book\Services\BookConfigService;
use App\Modules\Book\Services\ChapterService;
use App\Modules\Channel\Services\ChannelService;
use App\Modules\OfficialAccount\Services\ForceSubscribeService;
use App\Modules\Promotion\Services\PromotionService;
use App\Modules\SendOrder\Services\SendOrderService;
use App\Modules\Statistic\Services\WapVisitStatService;
use App\Modules\Trade\Services\OrderService;
use App\Modules\User\Services\UserService;
use DB;
use  Hashids;

use Illuminate\Http\Request;

class SendOrderController extends BaseController
{
    /**
     * @apiDefine sendOrder 派单
     */

    /**
     * @apiVersion 1.0.0
     * @api {GET} sendOrder/getSendOrders 获取派单列表
     * @apiGroup sendOrder
     * @apiName getSendOrders
     * @apiParam{Number}  [sendOrder_id]  派单id(可不传)
     * @apiParam{Number}  [book_id]  书本id(可不传)
     * @apiParam{String}  [name]  派单名称(可不传)
     * @apiParam{String}  [book_name] 书名(可不传)
     * @apiParam{String}  [start_time] 开始时间(可不传)
     * @apiParam{String}  [end_time] 结束时间(可不传)
     * @apiParam{String}  [pre_send_date_start] 预计发布时间开始(可不传)
     * @apiParam{String}  [pre_send_date_end] 预计发布时间结束(可不传)
     * @apiParam{String}  [promotion_point] 派单源 微信(默认)or浏览器(微信:1,浏览器:2)
     * @apiSuccess {Number}  id 派单id.
     * @apiSuccess {String}  distribution_channel_id 渠道id
     * @apiSuccess {String}  entrance 入口
     * @apiSuccess {String}  name 渠道名称
     * @apiSuccess {Number}  book_id 书本id
     * @apiSuccess {String}  channel_type 渠道类型
     * @apiSuccess {Number}  document_cover_id  文案封面id
     * @apiSuccess {Number}  headline_id  标题id
     * @apiSuccess {Number}  body_template_id ID. 内容模板id
     * @apiSuccess {Number}  original_guide_id  原文引导id
     * @apiSuccess {Number}  qr_code_id  二维码
     * @apiSuccess {Number}  subscribe_chapter_id 关注章节ID
     * @apiSuccess {Number}  document_end_chapter_seq 结束章节序号
     * @apiSuccess {String}  book_name 图书名称
     * @apiSuccess {String}  chapter_name 章节名称
     * @apiSuccess {String}  updated_at 更新时间
     * @apiSuccess {String}  created_at 创建时间
     * @apiSuccess {String}  pre_send_date 预计发布时间
     * @apiSuccess {String}  sex_preference 性别偏好
     * @apiSuccess {String}  subscribe_chapter_name 关注章节名称
     * @apiSuccess {String}  subscribe_chapter_seq 关注章节序号
     * @apiSuccess {Number}  remark 备注
     * @apiSuccess {Number}  star_num 星星数
     * @apiSuccess {Number}  cost 成本
     * @apiSuccess {Number}  totalChargeAmount 充值总额数
     * @apiSuccess {Number}  registerNum 注册数
     * @apiSuccess {Number}  payUserNum 付费用户数
     * @apiSuccess {Number}  clickNum 点击数数
     * @apiSuccess {Number}  browserClickNum 浏览器端pv
     * @apiSuccess {Number}  browserClickNumUV 浏览器端uv
     * @apiSuccess {Number}  fansNum 粉丝数
     * @apiSuccess {Number}  promotion_page_id  推广页面id
     * @apiSuccess {String}  redirect_url 重定向url
     * @apiSuccess {String}  qrcode 二维码
     * @apiSuccess {String}  domain 域名
     * @apiSuccess {String}  consumeTotalFee 派单下的消费的币的总和
     * @apiSuccess {String}  consumeChargeFee 派单下的消费的充值币
     * @apiSuccess {String}  consumeRewardFee 派单下的消费的奖励币
     * @apiSuccessExample {json} Success-Response:
     *
     *     {
     *         "code": 0,
     *         "msg": "",
     *
     *         "data": [
     *           {
     *               "id": 5,
     *               "distribution_channel_id": null,
     *               "entrance": "书架",
     *               "name": "acai",
     *              "book_id": null,
     *              "channel_type": "AUTHENTICATED",
     *               "chapter_id": null,
     *              "document_cover_id": null,
     *               "headline_id": null,
     *               "body_template_id": null,
     *               "original_guide_id": null,
     *               "subscribe_chapter_id": null,
     *               "book_name": null,
     *               "document_end_chapter_seq"=12.
     *               "sex_preference": "男频",
     *               "chapter_name": null,
     *               "updated_at": "2017-11-22 14:40:46",
     *               "created_at": "2017-11-22 14:40:46",
     *               "pre_send_date": "2018/11/12"
     *               "subscribe_chapter_name": null,
     *               "subscribe_chapter_seq": null,
     *               "remark": "0",
     *              "star_num": 0,
     *              "fansNum": 0,
     *              "cost":1111
     *              "totalChargeAmount": 0,
     *              "registerNum": 0,
     *              "payUserNum": 0,
     *              "clickNum": 0,
     *              "promotion_page_id": 1111,
     *              "redirect_url": ""
     *              "qrcode": ""
     *              "domain":"leque"
     *             "toatlOrderCount":12,
     *             "vipOrderCount":12,
     *             "normalOrderCount":12,
     *            },
     *           {
     *              "id": 11,
     *             "distribution_channel_id": 123,
     *             "entrance": null,
     *             "name": "acai",
     *             "book_id": 111,
     *             "cost":1111
     *             "channel_type": "AUTHENTICATED",
     *             "chapter_id": 1111,
     *             "document_cover_id": 899,
     *             "headline_id": 12334,
     *             "body_template_id": 3455,
     *             "document_end_chapter_seq"=12.
     *             "original_guide_id": 344,
     *             "subscribe_chapter_id": 11111,
     *             "book_name": "dpcq",
     *             "sex_preference": "男频",
     *             "chapter_name": "ssss",
     *              "domain":"leque"
     *             "updated_at": "2017-11-22 14:40:46",
     *             "created_at": "2017-11-22 14:40:46",
     *             "subscribe_chapter_name": null,
     *             "subscribe_chapter_seq": null,
     *             "remark": "0",
     *             "star_num": 0,
     *             "fansNum": 0,
     *             "totalChargeAmount": 0,
     *             "addUserNum": 0,
     *             "payUserNum": 0,
     *             "clickNum": 0,
     *             "toatlOrderCount":12,
     *             "vipOrderCount":12,
     *             "normalOrderCount":12,
     *             "promotion_page_id": null,
     *             "redirect_url": ""
     *             "qrcode": ""
     *            }
     *        ],
     *          "meta": {
     *                 "total": 1,
     *                 "per_page": 15,
     *                 "current_page": 1,
     *                 "last_page": 1,
     *                 "next_page_url": "",
     *                 "prev_page_url": ""
     *             }
     *     }
     */
    function getSendOrders(Request $request)
    {
        $distribution_channel_id = $this->getChannelId();
        $name = $request->has('name') ? $request->input('name') : '';
        $book_id = $request->has('book_id') ? $request->input('book_id') : '';
        $book_name = $request->has('book_name') ? $request->input('book_name') : '';
        $id = $sendOrderId = $request->has('sendOrder_id') ? $request->input('sendOrder_id') : '';
        $promotion_type = $request->has('promotion_type') ? $request->input('promotion_type') : '';
        $import_company_name = $request->has('company_name') ? $request->input('company_name') : '';
        $pre_send_date_end = $request->has('pre_send_date_end') ? $request->input('pre_send_date_end') : '';
        $pre_send_date_start = $request->has('pre_send_date_start') ? $request->input('pre_send_date_start') : '';
        $start_time = $request->has('start_time') && !empty($request->input('start_time')) ? $request->input('start_time') : '';
        $end_time = $request->has('end_time') && !empty($request->input('end_time')) ? date('Y-m-d H:i:s', strtotime($request->input('end_time')) + 86400 - 1) : '';
        $promotion_point = $request->has('promotion_point') ? $request->input('promotion_point') : 1;
        //$data = SendOrderService::getSendOrders($bookId, $distribution_channel_id, $name, $bookName, $sendOrderId, $start_time, $end_time, false);
        $data = SendOrderService::search(compact(
            'book_id',
            'distribution_channel_id',
            'name',
            'pre_send_date_end',
            'import_company_name',
            'pre_send_date_start',
            'promotion_type',
            'pre_send_date',
            'book_name',
            'start_time',
            'end_time',
            'id',
            'promotion_point'
        ));

        $send_order_export_special_channel = env('SEND_ORDER_EXPORT_SPECIAL_CHANNEL');
        $isExistSpecialChannel = in_array($distribution_channel_id, explode(',', $send_order_export_special_channel));

        foreach ($data as $item) {
            $itemName = $item->name;
            if ($isExistSpecialChannel) {
                if (strpos($itemName, "-")) {
                    $strs = explode('-', $itemName);
                    if (count($strs) == 4) {
                        $date = $this->getFormatDate($strs[2], $item->created_at);
                        $strs[2] = date('Y/m/d', strtotime($date));
                        $itemName = implode('-', $strs);
                        if (!$item->pre_send_date) {
                            $item->pre_send_date = $date;
                        }
                    } elseif (count($strs) == 6) {
                        $date = $this->getFullDate($strs[2], $strs[3], $strs[4], $item->created_at);
                        if (!$item->pre_send_date) {
                            $item->pre_send_date = $date;
                        }
                        $itemName = $strs[0] . '-' . $strs[1] . '-' . $date . '-' . $strs[5];
                    }
                }
            }

            $sendOrderId = $item->id;
            $item->name = $itemName;
            $browser_visit_info = SendOrderService::getBrowserUvAndPv($sendOrderId);
            $item->browserClickNum = $browser_visit_info['pv'];
            $item->browserClickNumUV = $browser_visit_info['uv'];
            $item->clickNum = SendOrderService::getPv($sendOrderId);
            $item->clickNumUV = SendOrderService::getUv($sendOrderId);//uv
            $item->payUserNum = OrderService::getPayUserNum($sendOrderId);
            $item->registerNum = UserService::getPromotionTotal($sendOrderId);
            $item->fansNum = ForceSubscribeService::getNewFansNum($sendOrderId);
            $item->continue_read_uv = SendOrderService::getContinueTotalReadUv($item->id);

            if ($promotion_point == 2) {
                $item->promotion_url = 'https://bsite' . encodeDistributionChannelId($distribution_channel_id) . '.leyuee.com/yun/' . $item->id;
            } else {
                $item->promotion_url = 'https://site' . encodeDistributionChannelId($distribution_channel_id) . '.' . $this->getDomainByBid($item->book_id) . '/yun/' . $item->id;
            }
            $item->totalChargeAmount = (float)OrderService::getAmount(['send_order_id' => $sendOrderId]);
//            $item->totalChargeAmount = OrderService::getPromotionRegUserRechargeAmount(['send_order_id' => $item->id]);
            $item->qrcode = "";//"data:image/png;base64," . base64_encode(QrCode::format('png')->size(200)->generate($promotion_url));

//            $bookOrderInfo = BookOrderService::getSendorderTotal($sendOrderId, $start_time, $end_time);
//            $chapterOrderInfo = ChapterOrderService::getSendorderTotal($sendOrderId, $start_time, $end_time);
            $item->consumeChargeFee = 0;//$bookOrderInfo['charge_balance'] + $chapterOrderInfo['charge_balance'];
            $item->consumeRewardFee = 0;//$bookOrderInfo['reward_balance'] + $chapterOrderInfo['reward_balance'];;
            $item->consumeTotalFee = 0;//$item->consumeChargeFee + $item->consumeRewardFee;
        }
        return response()->pagination(new SendOrderTransformer, $data);
    }

    function getFullDate($year, $month, $day, $created_at = '')
    {
        if (strlen($year) != 4) {
            if ($created_at) {
                $year = date('Y', strtotime($created_at));
            } else {
                $year = date('Y');
            }
        }

        if (strlen($month) == 1) {
            $month = '0' . $month;
        }

        if (strlen($day) == 1) {
            $day = '0' . $day;
        }

        $date = $year . $month . $day;
        $date = date('Y/m/d', strtotime($date));
        return $date;
    }

    function getFormatDate($date, $created_at = '')
    {
        $count = strlen($date);
        if ($created_at) {
            $year = date('Y', strtotime($created_at));
        } else {
            $year = date('Y');
        }

        if (2 == $count) {
            $date = $year . '0' . $date[0] . '0' . $date[1];
        } elseif (3 == $count) {
            if (0 === strpos($date, '0')) {
                $date = $year . substr($date, 0, 2) . '0' . $date[2];
            } else {
                $date = $year . '0' . $date;
            }
        } elseif (4 == $count) {
            $date = $year . $date;
        }
        return $date;
    }

    /**
     * 根据图书id获取域名
     * @param $bid
     */
    function getDomainByBid($bid = '')
    {
        $domain = 'leyuee.com';
        //如果图书id为空，则返回默认的域名
        if (!empty($bid)) {
            $bookConfig = BookConfigService::getBookById($bid);
            if ($bookConfig) {
                $domain = $bookConfig->promotion_domain;
            }
        }
        return $domain;
    }

    /**
     * @apiVersion 1.0.0
     * @apiDescription 派单列表导出
     * @api {GET} sendOrder/exportSendOrders 派单列表导出
     * @apiGroup sendOrder
     * @apiName exportSendOrders
     * @apiParam{Number}  [sendOrder_id]  派单id(可不传)
     * @apiParam{Number}  [book_id]  书本id(可不传)
     * @apiParam{String}  [book_name] 书名(可不传)
     * @apiParam{String}  [name]  派单名称(可不传)
     * @apiParam{String}  [pre_send_date_start] 预计发布时间开始(可不传)
     * @apiParam{String}  [pre_send_date_end] 预计发布时间结束(可不传)
     * @apiParam{String}  [start_time] 开始时间(可不传)
     * @apiParam{String}  [end_time] 结束时间(可不传)
     * @apiParam{String}  [promotion_point] 派单源 微信(默认)or浏览器(微信:1,浏览器:2)
     * @apiSuccess {Number}  id 派单id.
     * @apiSuccess {String}  distribution_channel_id 渠道id
     * @apiSuccess {String}  entrance 入口
     * @apiSuccess {String}  name 渠道名称
     * @apiSuccess {Number}  book_id 书本id
     * @apiSuccess {String}  channel_type 渠道类型
     * @apiSuccess {Number}  document_cover_id  文案封面id
     * @apiSuccess {Number}  headline_id  标题id
     * @apiSuccess {Number}  body_template_id ID. 内容模板id
     * @apiSuccess {Number}  original_guide_id  原文引导id
     * @apiSuccess {Number}  subscribe_chapter_id 关注章节ID
     * @apiSuccess {String}  book_name 图书名称
     * @apiSuccess {String}  chapter_name 章节名称
     * @apiSuccess {Number}  cost 成本
     * @apiSuccess {String}  updated_at 更新时间
     * @apiSuccess {String}  created_at 创建时间
     * @apiSuccess {String}  subscribe_chapter_name 关注章节名称
     * @apiSuccess {String}  subscribe_chapter_seq 关注章节序号
     * @apiSuccess {Number}  remark 备注
     * @apiSuccess {Number}  star_num 星星数
     * @apiSuccess {Number}  totalChargeAmount 充值总额数
     * @apiSuccess {Number}  registerNum 注册数
     * @apiSuccess {Number}  payUserNum 付费用户数
     * @apiSuccess {Number}  clickNum 点击数数
     * @apiSuccess {Number}  fansNum 粉丝数
     * @apiSuccess {Number}  promotion_page_id  推广页面id
     * @apiSuccess {String}  redirect_url 重定向url
     * @apiSuccessExample {json} Success-Response:
     *
     *     {
     *         "code": 0,
     *         "msg": "",
     *
     *         "data": [
     *           {
     *               "id": 5,
     *               "distribution_channel_id": null,
     *               "entrance": "书架",
     *               "name": "acai",
     *              "book_id": null,
     *              "channel_type": "AUTHENTICATED",
     *              "chapter_id": null,
     *              "document_cover_id": null,
     *               "headline_id": null,
     *               "body_template_id": null,
     *               "original_guide_id": null,
     *                "subscribe_chapter_id": null,
     *                "book_name": null,
     *                "chapter_name": null,
     *                "updated_at": "2017-11-22 14:40:46",
     *                "created_at": "2017-11-22 14:40:46",
     *                "subscribe_chapter_name": null,
     *                "subscribe_chapter_seq": null,
     *                "remark": "0",
     *                "star_num": 0,
     *                "fansNum": 0,
     *               "cost":111,
     *              "totalChargeAmount": 0,
     *              "registerNum": 0,
     *              "payUserNum": 0,
     *              "clickNum": 0,
     *                "promotion_page_id": 1111,
     *               "redirect_url": ""
     *            },
     *           {
     *              "id": 11,
     *             "distribution_channel_id": 123,
     *             "entrance": null,
     *             "name": "acai",
     *             "book_id": 111,
     *             "channel_type": "AUTHENTICATED",
     *             "chapter_id": 1111,
     *             "document_cover_id": 899,
     *             "headline_id": 12334,
     *             "body_template_id": 3455,
     *             "original_guide_id": 344,
     *             "subscribe_chapter_id": 11111,
     *             "book_name": "dpcq",
     *             "cost":1111
     *             "chapter_name": "ssss",
     *             "updated_at": "2017-11-22 14:40:46",
     *             "created_at": "2017-11-22 14:40:46",
     *             "subscribe_chapter_name": null,
     *             "subscribe_chapter_seq": null,
     *             "remark": "0",
     *             "star_num": 0,
     *              "fansNum": 0,
     *              "totalChargeAmount": 0,
     *              "addUserNum": 0,
     *              "payUserNum": 0,
     *              "clickNum": 0,
     *             "promotion_page_id": null,
     *             "redirect_url": ""
     *            }
     *        ],
     *          "meta": {
     *                 "total": 1,
     *                 "per_page": 15,
     *                 "current_page": 1,
     *                 "last_page": 1,
     *                 "next_page_url": "",
     *                 "prev_page_url": ""
     *             }
     *     }
     */
    function exportSendOrders(Request $request)
    {
        set_time_limit(0);
        $distribution_channel_id = $this->getChannelId();
        $name = $request->has('name') ? $request->input('name') : '';
        $book_id = $request->has('book_id') ? $request->input('book_id') : '';
        $book_name = $request->has('book_name') ? $request->input('book_name') : '';
        $id = $request->has('sendOrder_id') ? $request->input('sendOrder_id') : '';
        $promotion_type = $request->has('promotion_type') ? $request->input('promotion_type') : '';
        $pre_send_date_end = $request->has('pre_send_date_end') ? $request->input('pre_send_date_end') : '';
        $import_company_name = $request->has('company_name') ? $request->input('company_name') : '';
        $pre_send_date_start = $request->has('pre_send_date_start') ? $request->input('pre_send_date_start') : '';
        $start_time = $request->has('start_time') && !empty($request->input('start_time')) ? $request->input('start_time') : '';
        $promotion_point = $request->has('promotion_point') ? $request->input('promotion_point') : 1;

        $send_order_export_special_channel = env('SEND_ORDER_EXPORT_SPECIAL_CHANNEL');
        $isExistSpecialChannel = in_array($distribution_channel_id, explode(',', $send_order_export_special_channel));

        $end_time = $request->has('end_time') && !empty($request->input('end_time')) ? date('Y-m-d H:i:s', strtotime(trim($request->input('end_time'))) + 86400 - 1) : '';
        //$data = SendOrderService::getSendOrders($bookId, $distribution_channel_id, $name, $bookName, $sendOrderId, $start_time, $end_time, true);
        $data = SendOrderService::search(compact('book_id', 'distribution_channel_id', 'name', 'import_company_name', 'pre_send_date_end', 'pre_send_date_start', 'promotion_type', 'book_name', 'start_time', 'end_time', 'id', 'promotion_point'), true);
        header("Content-type:application/vnd.ms-excel");
        header("Content-Disposition:attachment;filename=" . "派单列表" . date("YmdHis") . ".csv");
        $specialChannelIdStats = env('SPECIAL_CHANNEL_STATS', 211);
        if ($isExistSpecialChannel) {
            if (in_array($distribution_channel_id, explode(',', $specialChannelIdStats))) {
                echo mb_convert_encoding("\"推广名称\",\"预计发送时间\",\"推广员\",\"书名\",\"点击数\",\"新增用户\",\"注册用户数\",\"新增关注\",\"新增关注率\",\"新关成本\",\"付费用户\",\"首充用户数\",\"成本\",\"累计充值\",\"累计充值成本率\",\"72小时累计充值总额\",\"72小时累计充值回本率\",\"7日充值总额\",\"公司名称\",\"总粉丝数\",\"累计UV大于20的时间\",\"推广位置\",\"小说来源\",\"推广链接\",\"章节名称\",\"充值总额\",\"充值成本率\",\"30日充值总额\",\"30日回本率\",\"24小时充值总额\",\"24小时回本率\",\"72小时充值总额\",\"72小时回本率\",\"30日累计充值总额\",\"30日累计充值回本率\",\"60日累计充值总额\",\"创建时间\",\"首日累计订阅人数\",\"首日累计订阅总额\",\"三日累计订阅人数\",\"三日累计订阅总额\",\"累计订阅人数\",\"累计订阅总额\"\r\n", 'GBK', 'UTF-8');
            } else {
                echo mb_convert_encoding("\"推广名称\",\"预计发送时间\",\"推广员\",\"书名\",\"点击数\",\"新增用户\",\"注册用户数\",\"新增关注\",\"新增关注率\",\"新关成本\",\"付费用户\",\"首充用户数\",\"成本\",\"累计充值\",\"累计充值成本率\",\"72小时累计充值总额\",\"72小时累计充值回本率\",\"7日充值总额\",\"公司名称\",\"总粉丝数\",\"累计UV大于20的时间\",\"推广位置\",\"小说来源\",\"推广链接\",\"章节名称\",\"充值总额\",\"充值成本率\",\"30日充值总额\",\"30日回本率\",\"24小时充值总额\",\"24小时回本率\",\"72小时充值总额\",\"72小时回本率\",\"30日累计充值总额\",\"30日累计充值回本率\",\"60日累计充值总额\",\"创建时间\"\r\n", 'GBK', 'UTF-8');
            }
        } else {
            echo mb_convert_encoding("\"推广名称\",\"推广链接\",\"书名\",\"章节名称\",\"点击数\",\"新增用户\",\"注册用户数\",\"新增关注\",\"新增关注率\",\"付费用户\",\"首充用户数\",\"充值总额\",\"成本\",\"充值成本率\",\"24小时充值总额\",\"24小时回本率\",\"72小时充值总额\",\"72小时回本率\",\"30日累计充值总额\",\"60日累计充值总额\",\"创建时间\"\r\n", 'GBK', 'UTF-8');
        }

        if ($data) {
            foreach ($data as $item) {

                $item->clickNum = SendOrderService::getPv($item->id);
                $item->clickNumUV = SendOrderService::getUv($item->id);//uv
                $item->payUserNum = OrderService::getPayUserNum($item->id);
                $item->fansNum = ForceSubscribeService::getNewFansNum($item->id);
                $item->registerNum = UserService::getPromotionTotal($item->id);
                $item->totalChargeAmount = (float)OrderService::getAmount(['send_order_id' => $item->id]);
//                $item->totalChargeAmount = OrderService::getPromotionRegUserRechargeAmount(['send_order_id' => $item->id]);

                $itemName = $item->name;
                $promotionUrl = "https://site" . $distribution_channel_id . "." . ($this->getDomainByBid($item->book_id ? $item->book_id : '')) . "/yun/" . $item->id;

                /*$stats_obj = SendOrderStat::where('send_order_id',$item->id)->first();
                $item->one_day_recharge = $stats_obj->recharge_amount_in_one_day;
                $item->three_days_recharge = $stats_obj->recharge_amount_in_three_days;*/

                //计算123 渠道号的 24小时 、72小时、7天,30日充值成本和回本
                $oneDayChargeAmount = 'NAV';
                $threeDayChargeAmount = 'NAV';
                $sevenDayChargeAmount = 'NAV';
                $thirtyDayChargeAmount = 'NAV';
                $promotionRegUserRecharge = 0;  //累计充值
                $promotionRegUserRechargeAmountInOneMonth = 0; //30天累计充值
                $promotionRegUserRechargeAmountInTwoMonth = 0; //60天累计充值
                $promotionRegUserRechargeAmountInThreeDays = 0; //72小时累计充值

                $firstChargeUserNum = SendOrderService::getFirstChargeUserNum($item->id);

                $uv20Time = $item->send_time;//SendOrderService::getUv20Time($item->id);
                if ($uv20Time) {
                    $send_time_24h_later = strtotime($uv20Time) + 86400;
                    $send_time_72h_later = strtotime($uv20Time) + 3 * 86400;
                    $send_time_7d_later = strtotime($uv20Time) + 7 * 86400;
                    $send_time_30d_later = strtotime($uv20Time) + 30 * 86400;
                    $promotionRegUserRecharge = OrderService::getPromotionRegUserRechargeAmount(['send_order_id' => $item->id]);
                    $promotionRegUserRechargeAmountInOneMonth = OrderService::getPromotionRegUserRechargeAmount(['send_order_id' => $item->id, 'end_time' => date("Y-m-d H:i:s", strtotime($uv20Time) + 30 * 86400)]);
                    $promotionRegUserRechargeAmountInThreeDays = OrderService::getPromotionRegUserRechargeAmount(['send_order_id' => $item->id, 'end_time' => date("Y-m-d H:i:s", strtotime($uv20Time) + 3 * 86400)]);
                    $promotionRegUserRechargeAmountInTwoMonth = OrderService::getPromotionRegUserRechargeAmount(['send_order_id' => $item->id, 'end_time' => date("Y-m-d H:i:s", strtotime($uv20Time) + 60 * 86400)]);

                    //计算24小时内的充值
                    if ($send_time_24h_later < time()) {
                        $selctEndTime = date('Y-m-d H:i:s', $send_time_24h_later);
                        $oneDayChargeAmount = OrderService::getAmount(['send_order_id' => $item->id, 'begin_time' => $uv20Time, 'end_time' => $selctEndTime]);
                    }

                    //计算72小时内的充值
                    if ($send_time_72h_later < time()) {
                        $selctEndTime = date('Y-m-d H:i:s', $send_time_72h_later);
                        $threeDayChargeAmount = OrderService::getAmount(['send_order_id' => $item->id, 'begin_time' => $uv20Time, 'end_time' => $selctEndTime]);
                    }

                    //计算7日内的充值
                    if ($send_time_7d_later < time()) {
                        $selctEndTime = date('Y-m-d H:i:s', $send_time_7d_later);
                        $sevenDayChargeAmount = OrderService::getAmount(['send_order_id' => $item->id, 'begin_time' => $uv20Time, 'end_time' => $selctEndTime]);
                    }

                    //计算30日内的充值
                    if ($send_time_30d_later < time()) {
                        $selctEndTime = date('Y-m-d H:i:s', $send_time_30d_later);
                        $thirtyDayChargeAmount = OrderService::getAmount(['send_order_id' => $item->id, 'begin_time' => $uv20Time, 'end_time' => $selctEndTime]);
                    }
                }

                if ($isExistSpecialChannel) {
                    $promotionSource = '-';

                    if (strpos($itemName, "-")) {
                        $strs = explode('-', $itemName);
                        if (count($strs) == 4) {
                            $date = $this->getFormatDate($strs[2], $item->created_at);
                            $date = date('Y/m/d', strtotime($date));
                            $promotionSource = $strs[1];
                            echo("\"" . mb_convert_encoding($strs[0], "GBK", "UTF-8") . "\",");
                            echo("\"" . $date . "\",");
                            echo("\"" . mb_convert_encoding($strs[3], "GBK", "UTF-8") . "\",");
                        } elseif (count($strs) == 6) {
                            $promotionSource = $strs[1];
                            $date = $this->getFullDate($strs[2], $strs[3], $strs[4], $item->created_at);
                            echo("\"" . mb_convert_encoding($strs[0], "GBK", "UTF-8") . "\",");
                            echo("\"" . $date . "\",");
                            echo("\"" . mb_convert_encoding($strs[5], "GBK", "UTF-8") . "\",");
                        } else {
                            echo("\"" . mb_convert_encoding($itemName, "GBK", "UTF-8") . "\",");
                            echo("\"" . mb_convert_encoding('-', "GBK", "UTF-8") . "\",");
                            echo("\"" . mb_convert_encoding('-', "GBK", "UTF-8") . "\",");
                        }
                    } else {
                        echo("\"" . mb_convert_encoding($itemName, "GBK", "UTF-8") . "\",");
                        echo("\"" . mb_convert_encoding('-', "GBK", "UTF-8") . "\",");
                        echo("\"" . mb_convert_encoding('-', "GBK", "UTF-8") . "\",");
                    }

                    echo("\"" . mb_convert_encoding($item->book_name ? $item->book_name : '书名为空', "GBK", "UTF-8") . "\",");
                    echo("\"" . $item->clickNum . "\",");
                    echo("\"" . $item->clickNumUV . "\",");
                    echo("\"" . $item->registerNum . "\",");
                    echo("\"" . $item->fansNum . "\",");
                    echo("\"" . ($this->getPersentAmount($item->fansNum, $item->registerNum)) . "\",");
                    echo("\"" . ((int)$item->fansNum != 0 ? round($item->cost / $item->fansNum, 2) : 0) . "\",");
                    echo("\"" . $item->payUserNum . "\",");
                    echo("\"" . $firstChargeUserNum . "\",");
                    echo("\"" . $item->cost . "\",");
                    echo("\"" . $promotionRegUserRecharge . "\",");
                    echo("\"" . ($this->getPersentAmount($promotionRegUserRecharge, $item->cost)) . "\",");
                    echo("\"" . mb_convert_encoding($promotionRegUserRechargeAmountInThreeDays, "GBK", "UTF-8") . "\",");
                    echo("\"" . mb_convert_encoding($this->getPersentAmount($promotionRegUserRechargeAmountInThreeDays, $item->cost), "GBK", "UTF-8") . "\",");

                    echo("\"" . $sevenDayChargeAmount . "\",");
                    echo("\"" . mb_convert_encoding($item->import_company_name ? $item->import_company_name : '未填', "GBK", "UTF-8") . "\",");
                    echo("\"" . $item->fansNum . "\",");
                    echo("\"" . mb_convert_encoding($uv20Time ? $uv20Time : '未到20', "GBK", "UTF-8") . "\",");
                    echo("\"" . $promotionSource . "\",");
                    $cpSource = '未知';
                    if ($item->book_id) {
                        $bookConfig = BookConfigService::getBookById($item->book_id);
                        if ($bookConfig) {
                            $cpSource = $bookConfig->cp_source;
                        }
                    }

                    echo("\"" . mb_convert_encoding($cpSource, "GBK", "UTF-8") . "\",");
                    echo("\"" . $promotionUrl . "\",");
                    echo("\"" . mb_convert_encoding($item->chapter_name ? $item->chapter_name : '章节名称为空', "GBK", "UTF-8") . "\",");
                    echo("\"" . $item->totalChargeAmount . "\",");
                    echo("\"" . ($this->getPersentAmount($item->totalChargeAmount, $item->cost)) . "\",");
                    echo("\"" . mb_convert_encoding($thirtyDayChargeAmount, "GBK", "UTF-8") . "\",");
                    echo("\"" . ($this->getPersentAmount($thirtyDayChargeAmount, $item->cost)) . "\",");
                    echo("\"" . mb_convert_encoding($oneDayChargeAmount, "GBK", "UTF-8") . "\",");
                    echo("\"" . ($this->getPersentAmount($oneDayChargeAmount, $item->cost)) . "\",");
                    echo("\"" . mb_convert_encoding($threeDayChargeAmount, "GBK", "UTF-8") . "\",");
                    echo("\"" . ($this->getPersentAmount($threeDayChargeAmount, $item->cost)) . "\",");
                    echo("\"" . $promotionRegUserRechargeAmountInOneMonth . "\",");
                    //30日累计充值回本率
                    echo("\"" . mb_convert_encoding($this->getPersentAmount($promotionRegUserRechargeAmountInOneMonth, $item->cost), "GBK", "UTF-8") . "\",");
                    echo("\"" . $promotionRegUserRechargeAmountInTwoMonth . "\",");
                    //echo("\"" . $item->created_at->toDateTimeString() . "\"\r\n");

                    if (in_array($distribution_channel_id, explode(',', $specialChannelIdStats))) {
                        echo("\"" . $item->created_at->toDateTimeString() . "\",");
                        if ($item->send_time) {
                            $special_stats_date = date('Y-m-d', strtotime($item->send_time));
                        } else {
                            $special_stats_date = '';
                        }
                        $special_stats = WapVisitStatService::getSpecialChannelIdStats($item->id, $special_stats_date);
                        echo("\"" . $special_stats['first_day_subscribe_num'] . "\",");
                        echo("\"" . $special_stats['first_day_subscribe_amount'] . "\",");
                        echo("\"" . $special_stats['three_day_subscribe_num'] . "\",");
                        echo("\"" . $special_stats['three_day_subscribe_amount'] . "\",");
                        echo("\"" . $special_stats['total_subscribe_num'] . "\",");
                        echo("\"" . $special_stats['total_subscribe_amount'] . "\"\r\n");
                    } else {
                        echo("\"" . $item->created_at->toDateTimeString() . "\"\r\n");
                    }
                } else {
                    echo("\"" . mb_convert_encoding($itemName, "GBK", "UTF-8") . "\",");
                    echo("\"" . $promotionUrl . "\",");
                    echo("\"" . mb_convert_encoding($item->book_name ? $item->book_name : '书名为空', "GBK", "UTF-8") . "\",");
                    echo("\"" . mb_convert_encoding($item->chapter_name ? $item->chapter_name : '章节名称为空', "GBK", "UTF-8") . "\",");
                    echo("\"" . $item->clickNum . "\",");
                    echo("\"" . $item->clickNumUV . "\",");
                    echo("\"" . $item->registerNum . "\",");
                    echo("\"" . $item->fansNum . "\",");
                    echo("\"" . ($this->getPersentAmount($item->fansNum, $item->registerNum)) . "\",");
                    echo("\"" . $item->payUserNum . "\",");
                    echo("\"" . $firstChargeUserNum . "\",");
                    echo("\"" . $item->totalChargeAmount . "\",");
                    echo("\"" . $item->cost . "\",");
                    echo("\"" . ($this->getPersentAmount($item->totalChargeAmount, $item->cost)) . "\",");
                    echo("\"" . mb_convert_encoding($oneDayChargeAmount, "GBK", "UTF-8") . "\",");
                    echo("\"" . ($this->getPersentAmount($oneDayChargeAmount, $item->cost)) . "\",");
                    echo("\"" . mb_convert_encoding($threeDayChargeAmount, "GBK", "UTF-8") . "\",");
                    echo("\"" . ($this->getPersentAmount($threeDayChargeAmount, $item->cost)) . "\",");
                    echo("\"" . $promotionRegUserRechargeAmountInOneMonth . "\",");
                    echo("\"" . $promotionRegUserRechargeAmountInTwoMonth . "\",");
                    echo("\"" . $item->created_at->toDateTimeString() . "\"\r\n");
                }
            }
        }
        exit();
    }

    /**
     * 计算成本率
     * @param $amount 充值金额
     * @param $cost 成本
     * @return int|string
     */
    function getPersentAmount($amount, $cost)
    {
        if (is_numeric($amount)) {
            if (abs($cost) < 0.01) {
                $persentResult = '100%';
            } else {
                $persentResult = round(($amount / $cost) * 100, 2) . '%';
            }
        } else {
            $persentResult = '0%';
        }
        return $persentResult;
    }

    /**
     * @apiVersion 1.0.0
     * @apiDescription 更新派单星级数和备注
     * @api {POST} sendOrder/updateStarNumAndRemark 更新派单星级数和备注
     * @apiGroup sendOrder
     * @apiName updateStarNumAndRemark
     * @apiParam{Number} id 派单id.
     * @apiParam{Number} distribution_channel_id 渠道id.
     * @apiParam{Number} star_num 派单星级数
     * @apiParam{String} remark 派单备注
     * @apiSuccessExample {json} Success-Response:
     *
     *     {
     *         "code": 0,
     *         "msg": "",
     *         "data":[]
     *     }
     */
    function updateStarNumAndRemark(Request $request)
    {
        $distribution_channel_id = $this->getChannelId();
        $id = $request->has('id') ? $request->input('id') : '';
        $remark = $request->has('remark') ? $request->input('remark') : '';
        $starNum = $request->has('star_num') ? $request->input('star_num') : '';
        if (empty($id) || empty($distribution_channel_id) || empty($starNum)) {
            return response()->error("PARAM_EMPTY");
        }

        if (!is_numeric($starNum)) {
            return response()->error("PARAM_ERROR");
        }

        $data = SendOrderService::updateStarNumAndRemark($id, $distribution_channel_id, $starNum, $remark);
        if ($data) {
            return response()->success();
        }
        return response()->error("HANDLE_FAILED");
    }

    /**
     * @apiVersion 1.0.0
     * @apiDescription 生成一个章节内容的派单
     * @api {POST} sendOrder/createFromChapter 生成一个章节内容的派单
     * @apiGroup sendOrder
     * @apiName createFromChapter
     * @apiParam   {String}  name 派单渠道名称.
     * @apiParam{Number} cost 成本.
     * @apiParam   {String}  distribution_channel_id 渠道id
     * @apiParam   {String}  channel_type 派单渠道类型.(允许值: AUTHENTICATED, UNAUTHENTICATED)
     * @apiParam   {String}  book_id  书本id
     * @apiParam   {String} promotion_type 推广类型[INTERVAL、EXTERVAL]. 内部、外部
     * @apiParam   {String}  book_name  书本名称
     * @apiParam   {String}  chapter_id  章节id
     * @apiParam   {String}  qr_code_id 二维码id.
     * @apiParam   {String}  chapter_name  章节名称
     * @apiParam   {String}  headline_id  推广标题id
     * @apiParam   {String}  body_template_id 内容模板id
     * @apiParam   {String}  document_cover_id  文案封面id
     * @apiParam   {String}  original_guide_id  原文引导ID.
     * @apiParam   {String}  subscribe_chapter_id  强制订阅章节id
     * @apiParam   {String}  subscribe_chapter_name  强制订阅章节名称
     * @apiParam   {String}  subscribe_chapter_seq 强制订阅章节序号
     * @apiParam   {String}  document_end_chapter_seq 最后章节序号
     * @apiParam   {String}  sex_preference 性别偏向
     * @apiParam{String}  [promotion_point] 派单源 微信(默认)or浏览器(微信:1,浏览器:2)
     * @apiSuccess {Number}  id 派单id
     * @apiSuccess {String}  promotion_url  推广链接
     * @apiSuccess {String}  name 派单名称
     * @apiSuccessExample {json} Success-Response:
     *
     *     {
     *         "code": 0,
     *         "msg": "",
     *         "data":{"id":5,"promotion_url":"http:\/\/www . xs . com\/promotion\/index\/123456"，"name":"派单名称"}
     *     }
     */
    function createFromChapter(Request $request)
    {
        $distribution_channel_id = $this->getChannelId();
        $name = $request->has('name') ? $request->input('name') : '';
        $promotion_type = $request->has('promotion_type') ? $request->input('promotion_type') : '';
        $cost = $request->has('cost') ? $request->input('cost') : 0;
        $book_id = $request->has('book_id') ? $request->input('book_id') : '';
        $book_name = $request->has('book_name') ? $request->input('book_name') : '';
        $chapter_id = $request->has('chapter_id') ? $request->input('chapter_id') : '';
        $qr_code_id = $request->has('qr_code_id') ? $request->input('qr_code_id') : '';
        $headline_id = $request->has('headline_id') ? $request->input('headline_id') : '';
        $chapter_name = $request->has('chapter_name') ? $request->input('chapter_name') : '';
        $channel_type = $request->has('channel_type') ? $request->input('channel_type') : '';
        $sex_preference = $request->has('sex_preference') ? $request->input('sex_preference') : '';
        $body_template_id = $request->has('body_template_id') ? $request->input('body_template_id') : '';
        $document_cover_id = $request->has('document_cover_id') ? $request->input('document_cover_id') : '';
        $original_guide_id = $request->has('original_guide_id') ? $request->input('original_guide_id') : '';
        $subscribe_chapter_id = $request->has('subscribe_chapter_id') ? $request->input('subscribe_chapter_id') : '';
        $subscribe_chapter_seq = $request->has('subscribe_chapter_seq') ? $request->input('subscribe_chapter_seq') : '';
        $subscribe_chapter_name = $request->has('subscribe_chapter_name') ? $request->input('subscribe_chapter_name') : '';
        $document_end_chapter_seq = $request->has('document_end_chapter_seq') ? $request->input('document_end_chapter_seq') : '';

        if (!$name || !$channel_type || !$promotion_type || !$book_id || !$book_name || !$sex_preference || !$document_end_chapter_seq || !$chapter_id || !$chapter_name || !$original_guide_id || !$headline_id || !$body_template_id || !$document_cover_id || !$document_cover_id || !$subscribe_chapter_id || !$subscribe_chapter_name || !$subscribe_chapter_seq) return response()->error('PARAM_EMPTY');

        if (empty($qr_code_id)) {
            $qr_code_id = 0;
        }

        $promotion_point = $request->has('promotion_point') ? $request->input('promotion_point') : 1;
        if (!in_array($promotion_point, [1, 2])) {
            $promotion_point = 1;
        }

        $redirect_url = "/reader?bid={$book_id}&cid={$chapter_id}";
        $book_id = Hashids::decode($book_id)[0];
        if ($book_id == 2423 && time() >= strtotime('2018-10-10 00:00:00') && time() <= strtotime('2018-10-15 00:00:00')) {
            return response()->error('CONTENT_MAINTAIN');
        }
        if ($promotion_point == 2) {
            $domain = 'leyuee.com';
        } else {
            $domain = $this->getDomainByBid($book_id);
        }
        $charge_type = $this->getBookChargeTypeByBid($book_id);
        $sendOrder = SendOrderService::createFromChapter(compact('name', 'channel_type', 'promotion_type', 'charge_type', 'cost', 'qr_code_id', 'domain', 'sex_preference', 'book_id', 'book_name', 'chapter_id', 'chapter_name', 'document_end_chapter_seq', 'original_guide_id', 'headline_id', 'body_template_id', 'document_cover_id', 'subscribe_chapter_id', 'subscribe_chapter_name', 'subscribe_chapter_seq', 'distribution_channel_id', 'redirect_url', 'promotion_point'));


        if ($promotion_point == 2) {
            $promotion_url = 'https://bsite' . encodeDistributionChannelId($distribution_channel_id) . '.leyuee.com/yun/' . $sendOrder->id;
        } else {
            $promotion_url = 'https://site' . encodeDistributionChannelId($distribution_channel_id) . '.' . $this->getDomainByBid($book_id) . '/yun/' . $sendOrder->id;
        }
        return response()->success(['id' => $sendOrder->id, 'promotion_url' => $promotion_url, 'name' => $name]);
    }

    /**
     * 通过推广模板图片生成
     * @param Request $request
     * @return mixed
     */
    function createFromPromotionImageTemplate(Request $request)
    {
        $distribution_channel_id = $this->getChannelId();
        $book_id = $request->has('book_id') ? $request->input('book_id') : '';


        $cost = $request->has('cost') ? $request->input('cost') : '';
        $name = $request->has('name') ? $request->input('name') : '';
        $book_name = $request->has('book_name') ? $request->input('book_name') : '';
        $promotion_point = $request->has('promotion_point') ? $request->input('promotion_point') : '';
        $promotion_type = $request->has('promotion_type') ? $request->input('promotion_type') : '';
        $channel_type = $request->has('channel_type') ? $request->input('channel_type') : '';
        $chapter_name = $request->has('chapter_name') ? $request->input('chapter_name') : '';
        $chapter_id = $request->has('chapter_id') ? $request->input('chapter_id') : '';
        $headline_id = $request->has('headline_id') ? $request->input('headline_id') : ''; //标题
        $image_id = $request->has('template_image_id') ? $request->input('template_image_id') : ''; //模板图片id
        $original_guide_id = $request->has('original_guide_id') ? $request->input('original_guide_id') : ''; //原文引导
        $subscribe_chapter_seq = $request->has('subscribe_chapter_seq') ? $request->input('subscribe_chapter_seq') : '';
        $subscribe_chapter_name = $request->has('subscribe_chapter_name') ? $request->input('subscribe_chapter_name') : '';
        $subscribe_chapter_id = $request->has('subscribe_chapter_id') ? $request->input('subscribe_chapter_id') : '';
        // 文案标题，推广图模板，原文引导，推广图模式

        $redirect_url = "/reader?bid={$book_id}&cid={$chapter_id}";
        $book_id = Hashids::decode($book_id)[0];
        $domain = $this->getDomainByBid($book_id);
        $charge_type = $this->getBookChargeTypeByBid($book_id);

        if ($book_id == 2423 && time() >= strtotime('2018-10-10 00:00:00') && time() <= strtotime('2018-10-15 00:00:00')) {
            return response()->error('CONTENT_MAINTAIN');
        }

        if (!$headline_id || !$original_guide_id || !$image_id || !$chapter_name || !$book_id || !$subscribe_chapter_id || !$subscribe_chapter_name || !$subscribe_chapter_seq || !$chapter_id || !$channel_type || !$promotion_type || !$name || !$promotion_point || !$book_name) {
            return response()->error('PARAM_EMPTY');
        } else {
            $sendOrder = SendOrderService::createFromChapter(compact('book_id', 'book_name', 'subscribe_chapter_seq', 'subscribe_chapter_name', 'subscribe_chapter_id', 'chapter_name', 'promotion_type', 'promotion_point', 'name', 'cost', 'channel_type', 'headline_id', 'original_guide_id', 'chapter_id', 'charge_type', 'domain', 'distribution_channel_id', 'redirect_url'));
            $promotion_url = 'https://site' . encodeDistributionChannelId($distribution_channel_id) . '.' . $this->getDomainByBid($book_id) . '/yun/' . $sendOrder->id;
            return response()->success(['id' => $sendOrder->id, 'promotion_url' => $promotion_url]);
        }
    }

    /**
     * 根据图书id获取图书的收费类型
     * @param string $bid
     */
    function getBookChargeTypeByBid($bid = '')
    {
        $charge_type = '';
        $bookConfig = BookConfigService::getBookById($bid);
        if ($bookConfig) {
            $charge_type = $bookConfig->charge_type;
        }
        return $charge_type;
    }

    /**
     * @apiVersion 1.0.0
     * @apiDescription 生成目录中的章节的派单
     * @api {POST} sendOrder/createFromDirectory 生成一个目录的派单
     * @apiGroup sendOrder
     * @apiName createFromDirectory
     * @apiParam {String} name 派单渠道名称.
     * @apiParam{Number} cost 成本.
     * @apiParam {String} channel_type 派单渠道类型.(允许值: AUTHENTICATED, UNAUTHENTICATED)
     * @apiParam {String} book_id  书本id
     * @apiParam {String} promotion_type 推广类型[INTERVAL、EXTERVAL]. 内部、外部
     * @apiParam {String} qr_code_id 二维码id.
     * @apiParam {String} book_name  书本名称
     * @apiParam {String} chapter_id  章节id
     * @apiParam {String} chapter_name  章节名称
     * @apiParam {String}  subscribe_chapter_id  强制订阅章节id
     * @apiParam {String}  subscribe_chapter_name  强制订阅章节名称
     * @apiParam {String}  subscribe_chapter_seq 强制订阅章节序号
     * @apiParam{String}  [promotion_point] 派单源 微信(默认)or浏览器(微信:1,浏览器:2)
     * @apiSuccess {Number}  id 派单id
     * @apiSuccess {String}  promotion_url  推广链接
     * @apiSuccess {String}  name 派单名称
     * @apiSuccessExample {json} Success-Response:
     *
     *     {
     *         "code": 0,
     *         "msg": "",
     *         "data":{"id":5,"promotion_url":"http:\/\/www . xs . com\/promotion\/index\/123456"，"name":"派单名称"}
     *     }
     */
    function createFromDirectory(Request $request)
    {
        $distribution_channel_id = $this->getChannelId();
        $name = $request->has('name') ? $request->input('name') : '';
        $cost = $request->has('cost') ? $request->input('cost') : 0;
        $book_id = $request->has('book_id') ? $request->input('book_id') : '';
        $book_name = $request->has('book_name') ? $request->input('book_name') : '';
        $chapter_id = $request->has('chapter_id') ? $request->input('chapter_id') : '';
        $qr_code_id = $request->has('qr_code_id') ? $request->input('qr_code_id') : '';
        $chapter_name = $request->has('chapter_name') ? $request->input('chapter_name') : '';
        $channel_type = $request->has('channel_type') ? $request->input('channel_type') : '';
        $promotion_type = $request->has('promotion_type') ? $request->input('promotion_type') : '';
        $subscribe_chapter_id = $request->has('subscribe_chapter_id') ? $request->input('subscribe_chapter_id') : '';
        $subscribe_chapter_seq = $request->has('subscribe_chapter_seq') ? $request->input('subscribe_chapter_seq') : '';
        $subscribe_chapter_name = $request->has('subscribe_chapter_name') ? $request->input('subscribe_chapter_name') : '';
        $promotion_point = $request->has('promotion_point') ? $request->input('promotion_point') : 1;
        if (!in_array($promotion_point, [1, 2])) {
            $promotion_point = 1;
        }

        if (!$name || !$channel_type || !$promotion_type || !$book_id || !$book_name || !$chapter_id || !$chapter_name || !$subscribe_chapter_id || !$subscribe_chapter_seq || !$subscribe_chapter_name) return response()->error('PARAM_EMPTY');

        if (empty($qr_code_id)) {
            $qr_code_id = 0;
        }
        $redirect_url = "/reader?bid={$book_id}&cid={$chapter_id}";
        $book_id = Hashids::decode($book_id)[0];
        if ($book_id == 2423 && time() >= strtotime('2018-10-10 00:00:00') && time() <= strtotime('2018-10-15 00:00:00')) {
            return response()->error('CONTENT_MAINTAIN');
        }
        if ($promotion_point == 2) {
            $domain = 'leyuee.com';
        } else {
            $domain = $this->getDomainByBid($book_id);
        }
        $charge_type = $this->getBookChargeTypeByBid($book_id);
        $sendOrder = SendOrderService::createFromDirectory(compact(
            'name',
            'channel_type',
            'promotion_type',
            'charge_type',
            'cost',
            'domain',
            'book_id',
            'qr_code_id',
            'book_name',
            'chapter_id',
            'subscribe_chapter_id',
            'subscribe_chapter_name',
            'subscribe_chapter_seq',
            'chapter_name',
            'distribution_channel_id',
            'redirect_url',
            'promotion_point'
        ));

//        $promotion_url = '/yun/' . $sendOrder->id;
        if ($promotion_point == 2) {
            $promotion_url = 'https://bsite' . encodeDistributionChannelId($distribution_channel_id) . '.leyuee.com/yun/' . $sendOrder->id;
        } else {
            $promotion_url = 'https://site' . encodeDistributionChannelId($distribution_channel_id) . '.' . $this->getDomainByBid($book_id) . '/yun/' . $sendOrder->id;
        }
        return response()->success(['id' => $sendOrder->id, 'promotion_url' => $promotion_url, 'name' => $name]);
    }


    function uploadSendOrders(Request $request)
    {
        if (!$request->hasFile('sendOrderFile')) {
            return response()->error('PARAM_EMPTY');
        }
        $qr_code_id = 0;
        $channel_type = 'AUTHENTICATED';
        $distribution_channel_id = $this->getChannelId();
        $file_name = date('YmdHis') . '.csv';
        $file = $request->file('sendOrderFile');
        if (null != $file) {
            $path = $request->sendOrderFile->storeAs('sendorder', $file_name);
            $path = storage_path('app/' . $path);
            header("Content-type:application/vnd.ms-excel");
            header("Content-Disposition:attachment;filename=" . "派单信息" . date("YmdHis") . ".csv");
            echo mb_convert_encoding("\"派单id\",\"渠道名称\",\"成本\",\"预计发送时间\",\"粉丝数\",\"图书名称\",\"图书id\",\"原文链接章节\",\"内外部\",\"公司名称\",\"代理商名称\",\"代理商介绍\",\"原文链接\"\r\n", 'GBK', 'UTF-8');

            $file = fopen($path, "r");
            //遍历读取每一行数据
            $currentIndex = 0;
            while ($data = fgetcsv($file)) {
                \Log::info($data);
                if (!$data[6]) continue;
                if ($currentIndex > 0) {
                    $date = $this->getFormatDate($data[2]);
                    $date = date('Y-m-d', strtotime($date));
                    $data[2] = $date;

                    $name = mb_convert_encoding(trim($data[0]), "UTF-8", "GBK") . '-' . +trim($data[1]) . '-' . trim($data[2]) . '-' . mb_convert_encoding(trim($data[3]), "UTF-8", "GBK");
                    $cost = $data[4];
                    $fan_num = (int)(trim($data[5]) * 10000);
                    \Log::info($fan_num);
                    $book_name = mb_convert_encoding(trim($data[6]), "UTF-8", "GBK");
                    $book_id = trim($data[7]);
                    $chapter_sqp = trim($data[8]);
                    $reciver_promotion_type = mb_convert_encoding(trim($data[9]), "UTF-8", "GBK");
                    $import_company_name = mb_convert_encoding(trim($data[10]), "UTF-8", "GBK");

                    $agent_name = mb_convert_encoding(trim($data[11]), "UTF-8", "GBK");
                    $agent_intro = mb_convert_encoding(trim($data[12]), "UTF-8", "GBK");

                    $chapter = ChapterService::getChapterInfoByBidAndSeq($book_id, $chapter_sqp);
                    $chapter_id = $chapter->id;
                    $chapter_name = $chapter->name;
                    $promotion_type = ($reciver_promotion_type == '内部') ? 'INTERNAL' : 'EXTERNAL';

                    $domain = $this->getDomainByBid($book_id);
                    $charge_type = $this->getBookChargeTypeByBid($book_id);
                    $book_id = Hashids::encode($book_id);
                    $redirect_url = "/reader?bid=$book_id&cid=$chapter_id";
                    $book_id = Hashids::decode($book_id)[0];

                    if (!$name || !$channel_type || !$promotion_type || !$book_id || !$book_name || !$chapter_id || !$chapter_name || !$import_company_name || !$fan_num) {
                        return response()->error('PARAM_EMPTY');
                    }

                    $pre_send_date = $date;
                    $sendOrder = SendOrderService::createFromDirectory(compact('name', 'channel_type', 'promotion_type', 'pre_send_date', 'import_company_name', 'fan_num', 'charge_type', 'cost', 'domain', 'book_id', 'qr_code_id', 'book_name', 'chapter_id', 'chapter_name', 'distribution_channel_id', 'redirect_url'));
                    $promotion_url = 'https://site' . encodeDistributionChannelId($distribution_channel_id) . '.' . $this->getDomainByBid($book_id) . '/yun/' . $sendOrder->id;

                    $send_order_id = $sendOrder->id;

                    if ($agent_name && $agent_intro) {
                        $created_at = date("Y-m-d H:i:s");
                        $updated_at = date("Y-m-d H:i:s");
                        $params = compact('send_order_id', 'agent_name', 'agent_intro', 'created_at', 'updated_at');
                        DB::table('agent_info')->insert($params);
                    }

                    echo("\"" . $sendOrder->id . "\",");
                    echo("\"" . mb_convert_encoding($name, "GBK", "UTF-8") . "\",");
                    echo("\"" . $cost . "\",");
                    echo("\"" . date('Y/m/d', strtotime($date)) . "\",");
                    echo("\"" . $fan_num . "\",");
                    echo("\"" . mb_convert_encoding($book_name, "GBK", "UTF-8") . "\",");
                    echo("\"" . mb_convert_encoding($book_id, "GBK", "UTF-8") . "\",");
                    echo("\"" . $chapter_id . "\",");
                    echo("\"" . mb_convert_encoding($reciver_promotion_type, "GBK", "UTF-8") . "\",");
                    echo("\"" . mb_convert_encoding($import_company_name, "GBK", "UTF-8") . "\",");
                    echo("\"" . mb_convert_encoding($agent_name ? $agent_name : "未知", "GBK", "UTF-8") . "\",");
                    echo("\"" . mb_convert_encoding($agent_intro ? $agent_intro : "未知", "GBK", "UTF-8") . "\",");
                    echo("\"" . $promotion_url . "\"\r\n");
                }
                $currentIndex++;
            }
        }
        exit();
    }

    /**
     * @apiVersion 1.0.0
     * @apiDescription 生成一个页面推广的派单
     * @api {POST} sendOrder/createFromPage 生成一个页面推广的派单
     * @apiGroup sendOrder
     * @apiName createFromPage
     * @apiParam{Number} cost 成本.
     * @apiParam{String} name 派单渠道名称.
     * @apiParam{String} promotion_type 推广类型[INTERVAL、EXTERVAL]. 内部、外部
     * @apiParam{String} qr_code_id 二维码id.
     * @apiParam{String} channel_type 派单渠道类型.(允许值: AUTHENTICATED, UNAUTHENTICATED)
     * @apiParam{String} page_id  页面ID
     * @apiParam{String}  [promotion_point] 派单源 微信(默认)or浏览器(微信:1,浏览器:2)
     * @apiSuccess {Number}  id 派单id
     * @apiSuccess {String}  promotion_url  推广链接
     * @apiSuccess {String}  name 派单名称
     * @apiSuccessExample {json} Success-Response:
     *
     *     {
     *         "code": 0,
     *         "msg": "",
     *         "data":{"id":5,"promotion_url":"http:\/\/www . xs . com\/promotion\/index\/123456"，"name":"派单名称"}
     *     }
     */
    function createFromPage(Request $request)
    {
        $name = $request->has('name') ? $request->input('name') : '';
        $cost = $request->has('cost') ? $request->input('cost') : 0;
        $promotion_type = $request->has('promotion_type') ? $request->input('promotion_type') : '';
        $page_id = $request->has('page_id') ? $request->input('page_id') : '';
        $qr_code_id = $request->has('qr_code_id') ? $request->input('qr_code_id') : '';
        $channel_type = $request->has('channel_type') ? $request->input('channel_type') : '';
        $page = PromotionService::getById($page_id);

        if (!$name || !$channel_type || !$page_id || !$page) return response()->error('PARAM_EMPTY');
        if (empty($qr_code_id)) {
            $qr_code_id = 0;
        }

        $promotion_point = $request->has('promotion_point') ? $request->input('promotion_point') : 1;
        if (in_array($promotion_point, [1, 2])) {
            $promotion_point = 1;
        }

        $entrance = $page->title;
        $redirect_url = $page->link;
        $distribution_channel_id = $this->getChannelId();
        $domain = $this->getDomainByBid();
        $sendOrder = SendOrderService::createFromPage(compact('name', 'channel_type', 'promotion_type', 'cost', 'qr_code_id', 'domain', 'page_id', 'entrance', 'distribution_channel_id', 'redirect_url', 'promotion_point'));
//        $promotion_url = '/yun/' . $sendOrder->id;
        if ($promotion_point == 2) {
            $promotion_url = 'https://bsite' . encodeDistributionChannelId($distribution_channel_id) . '.leyuee.com/yun/' . $sendOrder->id;
        } else {
            $promotion_url = 'https://site' . encodeDistributionChannelId($distribution_channel_id) . '.leyuee.com/yun/' . $sendOrder->id;
        }
        //$promotion_url = 'https://'.$site . encodeDistributionChannelId($distribution_channel_id) . '.' . $this->getDomainByBid('') . '/yun/' . $sendOrder->id;
        return response()->success(['id' => $sendOrder->id, 'promotion_url' => $promotion_url, 'name' => $name]);
    }

    /**
     * @apiVersion 1.0.0
     * @apiDescription 更新派单
     * @api {POST} sendOrder/updateSendOrderInfo 更新派单
     * @apiGroup sendOrder
     * @apiName updateSendOrderInfo
     * @apiParam {Number} id 派单id.
     * @apiParam {String} name 派单名称
     * @apiParam {Number} cost 派单成本
     * @apiParam {String} channel_type 派单渠道类型.(允许值: AUTHENTICATED, UNAUTHENTICATED)
     * @apiSuccessExample {json} Success-Response:
     *
     *     {
     *         "code": 0,
     *         "msg": "",
     *         "data":[]
     *     }
     */
    function updateSendOrderInfo(Request $request)
    {
        $distribution_channel_id = $this->getChannelId();
        $id = $request->has('id') ? $request->input('id') : '';
        $name = $request->has('name') ? $request->input('name') : '';
        $cost = $request->has('cost') ? $request->input('cost') : '';
        $channel_type = $request->has('channel_type') ? $request->input('channel_type') : '';
        $promotion_type = $request->has('promotion_type') ? $request->input('promotion_type') : '';
        $subscribe_chapter_seq = $request->input('subscribe_chapter_seq', '');
        if (empty($name) && empty($channel_type) && empty($cost) && empty($promotion_type)) {
            return response()->error("PARAM_EMPTY");
        }
        $subscribe_chapter = [];
        if ($subscribe_chapter_seq) {
            $send_orders = SendOrderService::getById($id);
            $bid = $send_orders->book_id;
            $chapter_info = ChapterService::getChapterInfoByBidAndSeq($bid, $subscribe_chapter_seq);
            if (!$chapter_info) {
                return response()->error('PARAM_ERROR');
            }
            $subscribe_chapter_id = $chapter_info->id;
            $subscribe_chapter['subscribe_chapter_id'] = $subscribe_chapter_id;
            $subscribe_chapter['subscribe_chapter_seq'] = $subscribe_chapter_seq;
            $subscribe_chapter['subscribe_chapter_name'] = $chapter_info->name;

        }

        $pre_send_date = null;
        $send_order_export_special_channel = env('SEND_ORDER_EXPORT_SPECIAL_CHANNEL');
        $isExistSpecialChannel = in_array($distribution_channel_id, explode(',', $send_order_export_special_channel));
        if ($isExistSpecialChannel && $name && strpos($name, "-")) {
            $strs = explode('-', $name);
            if (count($strs) == 4) {
                $date = $this->getFormatDate($strs[2]);
                $date = date('Y-m-d', strtotime($date));
                $pre_send_date = $date;
            }
        }

        $data = SendOrderService::updateSendOrderInfo($id, $distribution_channel_id, $name, $pre_send_date, $channel_type, $cost, $promotion_type, $subscribe_chapter);
        if ($data) {
            return response()->success();
        } else {
            return response()->error("HANDLE_FAILED");
        }
    }

    /**
     * @apiVersion 1.0.0
     * @apiDescription 删除派单
     * @api {POST} sendOrder/removeSendOrder 删除派单
     * @apiGroup sendOrder
     * @apiName removeSendOrder
     * @apiParam {Number}  id 派单id.
     * @apiSuccessExample {json} Success-Response:
     *
     *     {
     *         "code": 0,
     *         "msg": "",
     *         "data":[]
     *     }
     */
    function removeSendOrder(Request $request)
    {
        $distribution_channel_id = $this->getChannelId();
        $id = $request->has('id') ? $request->input('id') : '';
        $data = SendOrderService::removeSendOrder($id, $distribution_channel_id);
        if ($data) {
            return response()->success();
        } else {
            return response()->error("HANDLE_FAILED");
        }
    }

    /**
     * @apiVersion 1.0.0
     * @apiDescription 设置成本
     * @api {POST} sendOrder/setCost 设置成本
     * @apiGroup sendOrder
     * @apiName setCost
     * @apiParam{Number}id 派单id.
     * @apiParam{Number}cost 成本.
     * @apiSuccessExample {json} Success-Response:
     *
     *     {
     *         "code": 0,
     *         "msg": "",
     *         "data":[]
     *     }
     */
    function setCost(Request $request)
    {
        $distribution_channel_id = $this->getChannelId();
        $id = $request->has('id') ? $request->input('id') : '';
        $cost = $request->has('cost') ? $request->input('cost') : '';
        if (empty($id) || empty($cost)) {
            return response()->error("PARAM_EMPTY");
        }

        if (!is_numeric($cost)) {
            return response()->error("PARAM_ERROR");
        }
        $data = SendOrderService::setSendOrderCost($id, $distribution_channel_id, $cost);
        if ($data) {
            return response()->success(compact('cost'));
        } else {
            return response()->error("HANDLE_FAILED");
        }
    }

    /**
     * 匹配原文链接
     * @param Request $request
     */
    static function checkOriginUrl(Request $request)
    {
        if (!$request->hasFile('orginUrlFile')) {
            return response()->error('PARAM_EMPTY');
        }
        $file_name = date('YmdHis') . '.csv';
        $file = $request->file('orginUrlFile');
        if (null != $file) {
            $path = $request->orginUrlFile->storeAs('orginUrl', $file_name);
            $path = storage_path('app/' . $path);
            header("Content-type:application/vnd.ms-excel");
            header("Content-Disposition:attachment;filename=" . "原文链接" . date("YmdHis") . ".csv");
            echo mb_convert_encoding("\"公众号\",\"正确原文链接\",\"预览图文链接\",\"链接中解析到的url\",\"是否匹配\"\r\n", 'GBK', 'UTF-8');

            $file = fopen($path, "r");
            //遍历读取每一行数据
            $currentIndex = 0;
            while ($data = fgetcsv($file)) {
                \Log::info('data---1：' . json_encode($data));
                if (!$data[0] || !$data[1] || !$data[2]) continue;
                if ($currentIndex > 0) {
                    \Log::info('data---2：' . $data[2]);
                    $data[2] = str_replace('https', 'http', $data[2]);
                    $data[2] = str_replace('http', 'https', $data[2]);
                    $content = ChannelService::getContentByUrl($data[2]);
                    \Log::info($content);
                    $searchUrl = '';
                    $findStrEnd = ';';
                    $findStrBegin = 'msg_source_url =';

                    //解析页面中的msg_source_url的内容
                    $startIndex = strpos($content, $findStrBegin);
                    if ($startIndex > 0) {
                        \Log::info('开始进入了');
                        $endIndex = strpos($content, $findStrEnd, $startIndex);
                        if ($endIndex > $startIndex) {
                            $startIndex = $startIndex + strlen($findStrBegin) + 2;
                            $searchUrl = substr($content, $startIndex, $endIndex - $startIndex - 1);
                        }
                        //判断解析到的msg_source_url是否加密
                        \Log::info($searchUrl);
                        $url_items = parse_url($searchUrl);
                        \Log::info($url_items);
                        $distribution_channel_id = str_replace('site', '', explode('.', $url_items['host'])[0]);
                        if (!is_numeric($distribution_channel_id)) {
                            $deal_distribution_channel_id = decodeDistributionChannelId($distribution_channel_id);
                            //需要解密
                            $searchUrl = str_replace('site' . $distribution_channel_id, 'site' . $deal_distribution_channel_id, $searchUrl);
                        }
                    }

                    //判断上传的url是否加密
                    $deal_url = $data[1];
                    $url_items = parse_url($deal_url);
                    $distribution_channel_id = str_replace('site', '', explode('.', $url_items['host'])[0]);
                    //需要解密
                    if (!is_numeric($distribution_channel_id)) {
                        $deal_distribution_channel_id = decodeDistributionChannelId($distribution_channel_id);
                        $deal_url = str_replace('site' . $distribution_channel_id, 'site' . $deal_distribution_channel_id, $deal_url);
                    }

                    $isMatch = ($searchUrl == $deal_url) ? '匹配' : '不匹配';
                    $data[0] = mb_convert_encoding(trim($data[0]), "UTF-8", "GBK");
                    echo("\"" . mb_convert_encoding($data[0], "GBK", "UTF-8") . "\",");
                    echo("\"" . mb_convert_encoding($data[1], "GBK", "UTF-8") . "\",");
                    echo("\"" . mb_convert_encoding($data[2], "GBK", "UTF-8") . "\",");
                    echo("\"" . mb_convert_encoding($searchUrl ? $searchUrl : '未找到', "GBK", "UTF-8") . "\",");
                    echo("\"" . mb_convert_encoding($isMatch, "GBK", "UTF-8") . "\"\r\n");
                }
                $currentIndex++;
            }
        }
        exit();
    }

    /**
     * 加密、解密原文链接
     * @param Request $request
     */
    function decryptOrEncrptOriginUrl(Request $request)
    {
        $originUrl = $request->has('origin_url') ? $request->input('origin_url') : '';
        if (empty($originUrl)) {
            return response()->error("PARAM_EMPTY");
        }

        $url_items = parse_url($originUrl);
        $distribution_channel_id = str_replace('site', '', explode('.', $url_items['host'])[0]);
        //需要加密
        if (is_numeric($distribution_channel_id)) {
            $deal_distribution_channel_id = encodeDistributionChannelId($distribution_channel_id);
            //需要解密
        } else {
            $deal_distribution_channel_id = decodeDistributionChannelId($distribution_channel_id);
        }

        $originUrl = str_replace('site' . $distribution_channel_id, 'site' . $deal_distribution_channel_id, $originUrl);
        return response()->success(['originUrl' => $originUrl]);
    }
}