<?php
/**
* Created by PhpStorm.
* User: hp
* Date: 2017/12/1
* Time: 14:17
*/
namespace App\Http\Controllers\Manage\SendOrder;
use App\Http\Controllers\Controller;
use App\Http\Controllers\Manage\SendOrder\Transformers\SendOrderStatTransformer;
use App\Http\Controllers\Manage\SendOrder\Transformers\SendOrderTransformer;
use App\Modules\Channel\Services\ChannelService;
use App\Modules\OfficialAccount\Services\ForceSubscribeService;
use App\Modules\SendOrder\Services\SendOrderService;
use App\Modules\SendOrder\Services\SendOrderStatService;
use App\Modules\Statistic\Services\SendStatistics;
use App\Modules\Subscribe\Services\BookOrderService;
use App\Modules\Subscribe\Services\ChapterOrderService;
use App\Modules\Trade\Services\OrderService;
use App\Modules\User\Services\UserService;
use Illuminate\Http\Request;
/**
* Class SendOrderController 派单
* @package App\Http\Controllers\Manage\SendOrder
*/
class SendOrderController extends Controller
{
/**
* @apiDefine sendOrder 派单
*/
/**
* @apiVersion 1.0.0
* @api {GET} sendOrder/getSendOrders 获取派单列表
* @apiGroup sendOrder
* @apiName getSendOrders
* @apiParam {Number} [sendOrder_id] 派单id(可不传)
* @apiParam {Number} [channel_id] 渠道id(可不传)
* @apiParam {String} [bookName] 书本名称(可不传)
* @apiParam {Number} [order_status] 内外部派单(1： 内部派单， 2：外部派单)
* @apiParam {String} [name] 派单名称(可不传)
* @apiParam {Number} [book_id] 书本id(可不传)
* @apiParam {Number} [orderBy] 排序(1:12小时，2:7天，3：充值总额) 可不传，默然为创建时间排序
* @apiParam {Number} [orderByType] 排序类型(1:降序，2:升序) 可不传，默然为降序
* @apiParam {String} [start_time] 开始时间(可不传)
* @apiParam {String} [end_time] 结束时间(可不传)
* @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 {String} updated_at 更新时间
* @apiSuccess {String} created_at 创建时间
* @apiSuccess {String} send_time 派单时间
* @apiSuccess {String} subscribe_chapter_name 关注章节名称
* @apiSuccess {String} subscribe_chapter_seq 关注章节序号
* @apiSuccess {Number} document_end_chapter_seq 结束章节序号
* @apiSuccess {String} sex_preference 性别偏好
* @apiSuccess {Number} remark 备注
* @apiSuccess {Number} continue_read_uv 继续阅读用户数
* @apiSuccess {Number} cost 成本
* @apiSuccess {Number} star_num 星星数
* @apiSuccess {Number} totalChargeAmount 充值总额数
* @apiSuccess {Number} registerNum 注册数
* @apiSuccess {Number} payUserNum 付费用户数
* @apiSuccess {Number} clickNum 点击数数
* @apiSuccess {Number} fansNum 粉丝数
* @apiSuccess {Number} toatlOrderCount 总订单数
* @apiSuccess {Number} vipOrderCount Vip用户订单数
* @apiSuccess {Number} normalOrderCount 普通用户订单数
* @apiSuccess {Number} vipPayUserNum Vip用户数
* @apiSuccess {Number} normalPayUserNum 普通用户数
* @apiSuccess {Number} promotion_page_id 推广页面id
* @apiSuccess {String} redirect_url 重定向url
* @apiSuccess {Number} consumeTotalFee 派单下的消费的币的总和
* @apiSuccess {Number} consumeChargeFee 派单下的消费的充值币
* @apiSuccess {Number} consumeRewardFee 派单下的消费的奖励币
* @apiSuccess {Number} firstChargeUserNum 首充用户数
* @apiSuccess {Number} repetitiousChargeUserNum 非首充用户数
* @apiSuccess {String} channel_name 渠道名称
* @apiSuccess {String} charge_type 书本收费方式
* @apiSuccess {Number} weekend_charge_amount 7天充值金额
* @apiSuccess {Number} half_day_charge_amount 12小时充值金额
* @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",
* "send_time": "2017-11-22 14:40:46",
* "subscribe_chapter_name": null,
* "subscribe_chapter_seq": null,
* "document_end_chapter_seq"=12.
* "sex_preference": "男频",
* "remark": "0",
* "star_num": 0,
* "consumeTotalFee": 0,
* "consumeChargeFee": 0,
* "consumeRewardFee": 0,
* "fansNum": 0,
* "cost":111,
* "totalChargeAmount": 0,
* "registerNum": 0,
* "payUserNum": 0,
* "clickNum": 0,
* "vipPayUserNum":0,
* "toatlOrderCount":12,
* "vipOrderCount":12,
* "continue_read_uv": 11,
* "normalOrderCount":12,
* "normalPayUserNum":0,
* "firstChargeUserNum":0,
* "repetitiousChargeUserNum":0,
* "promotion_page_id": 1111,
* "redirect_url": "",
* "channel_name":"渠道名称1",
* "charge_type":"Book",
* "weekend_charge_amount": 71,
* "half_day_charge_amount": 105
* },
* {
* "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,
* "cost":111,
* "continue_read_uv": 11,
* "original_guide_id": 344,
* "subscribe_chapter_id": 11111,
* "book_name": "dpcq",
* "chapter_name": "ssss",
* "updated_at": "2017-11-22 14:40:46",
* "created_at": "2017-11-22 14:40:46",
* "send_time": "2017-11-22 14:40:46",
* "subscribe_chapter_name": null,
* "subscribe_chapter_seq": null,
* "remark": "0",
* "star_num": 0,
* "fansNum": 0,
* "vipPayUserNum":0,
* "normalPayUserNum":0,
* "totalChargeAmount": 0,
* "registerNum": 0,
* "payUserNum": 0,
* "consumeTotalFee": 0,
* "consumeChargeFee": 0,
* "consumeRewardFee": 0,
* "clickNum": 0,
* "toatlOrderCount":12,
* "vipOrderCount":12,
* "normalOrderCount":12,
* "firstChargeUserNum":0,
* "repetitiousChargeUserNum":0,
* "promotion_page_id": null,
* "redirect_url": "",
* "channel_name":"渠道名称1",
* "charge_type":"Book",
* "weekend_charge_amount": 71,
* "half_day_charge_amount": 105
* }
* ],
* "meta": {
* total": 1,
* per_page": 15,
* current_page": 1,
* last_page": 1,
* next_page_url": "",
* prev_page_url": ""
* }
* }
*/
function getSendOrders(Request $request)
{
$name = $request->has('name') ? $request->input('name') : '';
$bookId = $request->has('book_id') ? $request->input('book_id') : '';
$orderBy = $request->has('orderBy') ? $request->input('orderBy') : '';
$orderByType = $request->has('orderByType') ? $request->input('orderByType') : 1;
$order_status = $request->has('order_status') ? $request->input('order_status') : 0;
$orderByType = (0 == $orderByType) ? 1 : $orderByType;
$bookName = $request->has('bookName') ? $request->input('bookName') : '';
$channel_id = $request->has('channel_id') ? $request->input('channel_id') : '';
$sendOrderId = $request->has('sendOrder_id') ? $request->input('sendOrder_id') : '';
$end_time = $request->has('end_time') && !empty($request->input('end_time')) ? $request->input('end_time') : '';
$start_time = $request->has('start_time') && !empty($request->input('start_time')) ? $request->input('start_time') : '';
$gender = $request->has('gender') && !empty($request->input('gender')) ? $request->input('gender') : '';
$params = ['book_id' => $bookId, 'distribution_channel_id' => $channel_id, 'book_name' => $bookName, 'id' => $sendOrderId, 'orderBy' => $orderBy,
'order_status' => $order_status, 'orderByType' => $orderByType, 'name' => $name, 'start_time' => $start_time, 'end_time' => $end_time, 'gender' => $gender];
$data = SendOrderService::getManageSendOrders($params, false);
foreach ($data as $item) {
$sendOrderId = $item->id;
$item->totalChargeAmount = (float)OrderService::getAmount(['send_order_id' => $sendOrderId]);
$item->registerNum = UserService::getPromotionTotal($sendOrderId);;
$item->clickNum = SendOrderService::getPv($sendOrderId);
$item->clickNumUV = SendOrderService::getUv($sendOrderId);
$item->continue_read_uv = SendOrderService::getContinueTotalReadUv($sendOrderId);
$item->channel_name = ChannelService::getChannelNicknameById($item->distribution_channel_id);
$item->fansNum = ForceSubscribeService::getFansNum($sendOrderId);
$item->payUserNum = OrderService::getPayUserNum($sendOrderId);
$item->vipPayUserNum = OrderService::getVipPayUserNum($sendOrderId);
$item->normalPayUserNum = OrderService::getNormaPayUserNum($sendOrderId);
$bookOrderInfo = BookOrderService::getSendorderTotal($sendOrderId, $start_time, $end_time);
$chapterOrderInfo = ChapterOrderService::getSendorderTotal($sendOrderId, $start_time, $end_time);
$item->consumeChargeFee = $bookOrderInfo['charge_balance'] + $chapterOrderInfo['charge_balance'];
$item->consumeRewardFee = $bookOrderInfo['reward_balance'] + $chapterOrderInfo['reward_balance'];;
$item->consumeTotalFee = $item->consumeChargeFee + $item->consumeRewardFee;
$item->toatlOrderCount = OrderService::getOrderCount($sendOrderId);
$item->vipOrderCount = OrderService::getVipOrderCount($sendOrderId);
$item->normalOrderCount = OrderService::getNormalOrderCount($sendOrderId);
$item->firstChargeUserNum = SendOrderService::getFirstChargeUserNum($sendOrderId);
$item->repetitiousChargeUserNum = SendOrderService::getRepetitiousChargeUserNum($sendOrderId);
}
return response()->pagination(new SendOrderTransformer(), $data);
}
/**
* @apiVersion 1.0.0
* @api {GET} sendOrder/exportSendOrders 导出派单列表
* @apiGroup sendOrder
* @apiName exportSendOrders
* @apiParam {Number} [sendOrder_id] 派单id(可不传)
* @apiParam {Number} [book_id] 书本id(可不传)
* @apiParam {String} [name] 派单名称(可不传)
* @apiParam {Number} [order_status] 内外部派单(1： 内部派单， 2：外部派单)
* @apiParam {Number} [orderBy] 排序(1:12小时，2:7天) 可不传，默然为创建时间排序
* @apiParam {String} [bookName] 书本名称(可不传)
* @apiParam {Number} [channel_id] 渠道id(可不传)
* @apiParam {String} [start_time] 开始时间(可不传)
* @apiParam {String} [end_time] 结束时间(可不传)
*
* @apiSuccess {String} created_at 创建时间
* @apiSuccess {Number} distribution_channel_id 渠道id
* @apiSuccess {Number} id 派单id.
* @apiSuccess {Number} cost 成本
* @apiSuccess {Number} book_id 书本id
* @apiSuccess {String} book_name 图书名称
* @apiSuccess {Number} clickNum 点击数数
* @apiSuccess {Number} registerNum 注册数
* @apiSuccess {Number} fansNum 粉丝数
* @apiSuccess {Number} document_end_chapter_seq 结束章节序号
* @apiSuccess {String} sex_preference 性别偏好
* @apiSuccess {Number} continue_read_uv 继续阅读用户数
* @apiSuccess {Number} payUserNum 付费用户数
* @apiSuccess {Number} vipPayUserNum VIP付费用户数
* @apiSuccess {Number} normalPayUserNum 普通付费用户数
* @apiSuccess {Number} totalChargeAmount 充值总额数
* @apiSuccess {Number} clickNumUV 独立用户数
* @apiSuccess {Number} toatlOrderCount 总订单数
* @apiSuccess {Number} vipOrderCount Vip用户订单数
* @apiSuccess {Number} normalOrderCount 普通用户订单数
* @apiSuccess {String} consumeTotalFee 派单下的消费的币的总和
* @apiSuccess {String} consumeChargeFee 派单下的消费的充值币
* @apiSuccess {String} consumeRewardFee 派单下的消费的奖励币
*
* @apiSuccessExample {json} Success-Response:
*
* {
* "code": 0,
* "msg": "",
* "data": [
* {
* "created_at": "2017-11-22 14:40:46",
* "distribution_channel_id": 123,
* "id": 11,
* "book_id": 111,
* "book_name": "dpcq",
* "clickNum": 0,
* "registerNum": 0,
* "fansNum": 0,
* "cost":111,
* "continue_read_uv": 11,
* "payUserNum": 0,
* "vipPayUserNum":0,
* "normalPayUserNum":0,
* "totalChargeAmount": 0,
* "consumeTotalFee": 0,
* "consumeChargeFee": 0,
* "consumeRewardFee": 0,
* "clickNumUV":1.
* "toatlOrderCount":12,
* "vipOrderCount":12,
* "normalOrderCount":12,
* },
* {
* "created_at": "2017-11-22 14:40:46",
* "distribution_channel_id": 123,
* "id": 11,
* "book_id": 111,
* "book_name": "dpcq",
* "clickNum": 0,
* "registerNum": 0,
* "cost":111,
* "continue_read_uv": 11,
* "fansNum": 0,
* "consumeTotalFee": 0,
* "consumeChargeFee": 0,
* "consumeRewardFee": 0,
* "payUserNum": 0,
* "vipPayUserNum":0,
* "normalPayUserNum":0,
* "totalChargeAmount": 0,
* "clickNumUV":1.
* "toatlOrderCount":12,
* "vipOrderCount":12,
* "normalOrderCount":12,
* }
* ]
* }
*/
function exportSendOrders(Request $request)
{
$name = $request->has('name') ? $request->input('name') : '';
$bookId = $request->has('book_id') ? $request->input('book_id') : '';
$orderBy = $request->has('orderBy') ? $request->input('orderBy') : '';
$orderByType = $request->has('orderByType') ? $request->input('orderByType') : 1;
$order_status = $request->has('order_status') ? $request->input('order_status') : 0;
$orderByType = (0 == $orderByType) ? 1 : $orderByType;
$bookName = $request->has('bookName') ? $request->input('bookName') : '';
$channel_id = $request->has('channel_id') ? $request->input('channel_id') : '';
$sendOrderId = $request->has('sendOrder_id') ? $request->input('sendOrder_id') : '';
$end_time = $request->has('end_time') && !empty($request->input('end_time')) ? $request->input('end_time') : '';
$start_time = $request->has('start_time') && !empty($request->input('start_time')) ? $request->input('start_time') : '';
$gender = $request->has('gender') && !empty($request->input('gender')) ? $request->input('gender') : '';
$params = ['book_id' => $bookId, 'distribution_channel_id' => $channel_id, 'book_name' => $bookName, 'id' => $sendOrderId, 'orderBy' => $orderBy,
'order_status' => $order_status, 'orderByType' => $orderByType, 'name' => $name, 'start_time' => $start_time, 'end_time' => $end_time, 'gender' => $gender];
$data = SendOrderService::getManageSendOrders($params, true);
header("Content-type:application/vnd.ms-excel");
header("Content-Disposition:attachment;filename=" . "派单明细" . date("YmdHis") . ".csv");
echo iconv("UTF-8", "GBK", "\"创建时间\",\"派单时间\",\"渠道ID\",\"派单ID\",\"推广书籍ID\",\"推广书籍名称\",\"书籍类型\",\"消费币的总和\",\"消费的充值币\",\"消费的奖励币\",\"点击人数\",\"继续阅读用户数\",\"注册用户数\",\"关注人数\",\"付费用户数\",\"VIP付费用户数\",\"普通付费用户数\",\"充值金额\",\"7天充值金额\",\"12小时充值金额\",\"UV\",\"累计UV大于20的时间\",\"总订单数\",\"成本\",\"VIP用户订单数\",\"普通用户订单数\"\r\n");
if ($data) {
foreach ($data as $item) {
$sendOrderId = $item->id;
$item->totalChargeAmount = (float)OrderService::getAmount(['send_order_id' => $sendOrderId]);
$item->registerNum = UserService::getPromotionTotal($sendOrderId);;
$item->clickNum = SendOrderService::getPv($sendOrderId);
$item->clickNumUV = SendOrderService::getUv($sendOrderId);
$item->payUserNum = OrderService::getPayUserNum($sendOrderId);
$item->fansNum = ForceSubscribeService::getFansNum($sendOrderId);
$item->vipPayUserNum = OrderService::getVipPayUserNum($sendOrderId);
$item->normalPayUserNum = OrderService::getNormaPayUserNum($sendOrderId);
$item->continue_read_uv = SendOrderService::getContinueTotalReadUv($sendOrderId);
$bookOrderInfo = BookOrderService::getSendorderTotal($sendOrderId, $start_time, $end_time);
$chapterOrderInfo = ChapterOrderService::getSendorderTotal($sendOrderId, $start_time, $end_time);
$item->consumeChargeFee = $bookOrderInfo['charge_balance'] + $chapterOrderInfo['charge_balance'];
$item->consumeRewardFee = $bookOrderInfo['reward_balance'] + $chapterOrderInfo['reward_balance'];;
$item->consumeTotalFee = $item->consumeChargeFee + $item->consumeRewardFee;
$item->toatlOrderCount = OrderService::getOrderCount($sendOrderId);
$item->vipOrderCount = OrderService::getVipOrderCount($sendOrderId);
$item->normalOrderCount = OrderService::getNormalOrderCount($sendOrderId);
echo("\"" . $item->created_at->toDateTimeString() . "\",");
echo("\"" . iconv("UTF-8", "GBK", ($item->send_time ? $item->$item->send_time : "未填")) . "\",");
echo("\"" . ($item->distribution_channel_id ? $item->distribution_channel_id : "-1") . "\",");
echo("\"" . ($item->id ? $item->id : "-1") . "\",");
echo("\"" . ($item->book_id ? $item->book_id : "-1") . "\",");
echo("\"" . iconv("UTF-8", "GBK", ($item->book_name ? $item->book_name : "未填")) . "\",");
echo("\"" . iconv("UTF-8", "GBK", ($item->channel_name ? $item->channel_name : "未填")) . "\",");
echo("\"" . $item->consumeTotalFee . "\",");
echo("\"" . $item->consumeChargeFee . "\",");
echo("\"" . $item->consumeRewardFee . "\",");
echo("\"" . $item->clickNum . "\",");
echo("\"" . $item->continue_read_uv . "\",");
echo("\"" . $item->registerNum . "\",");
echo("\"" . $item->fansNum . "\",");
echo("\"" . $item->payUserNum . "\",");
echo("\"" . $item->vipPayUserNum . "\",");
echo("\"" . $item->normalPayUserNum . "\",");
echo("\"" . $item->totalChargeAmount . "\",");
echo("\"" . ($item->weekend_charge_amount ? $item->weekend_charge_amount : 0) . "\",");
echo("\"" . ($item->half_day_charge_amount ? $item->half_day_charge_amount : 0) . "\",");
echo("\"" . $item->clickNumUV . "\",");
$uv20Time = SendOrderService::getUv20Time($sendOrderId);
echo("\"" . iconv("UTF-8", "GBK", ($uv20Time ? $uv20Time : "未到20")) . "\",");
echo("\"" . $item->toatlOrderCount . "\",");
echo("\"" . $item->cost . "\",");
echo("\"" . $item->vipOrderCount . "\",");
echo("\"" . $item->normalOrderCount . "\"\r\n");
}
}
exit();
}
/**
* @apiVersion 1.0.0
* @api {GET} sendOrder/getHistorySendOrders 获取历史派单列表
* @apiGroup sendOrder
* @apiName getHistorySendOrders
* @apiParam {Number} [sendOrder_id] 派单id(可不传)
* @apiParam {Number} [channel_id] 渠道id(可不传)
* @apiParam {String} [bookName] 书本名称(可不传)
* @apiParam {String} [name] 派单名称(可不传)
* @apiParam {Number} [book_id] 书本id(可不传)
* @apiParam {Number} [order_status] 内外部派单(1： 内部派单， 2：外部派单)
* @apiParam {Number} [orderBy] 排序(1:12小时，2:7天, 3：充值总额， 4：首充总额) 可不传，默然为创建时间排序 orderByType
* @apiParam {Number} [orderByType] 排序类型(1:降序，2:升序) 可不传，默然为降序
* @apiParam {String} [start_time] 开始时间(可不传)
* @apiParam {String} [end_time] 结束时间(可不传)
*
* @apiSuccess {Number} id 派单id.
* @apiSuccess {String} name 派单名称
* @apiSuccess {Number} distribution_channel_id 渠道id
* @apiSuccess {String} book_name 图书名称
* @apiSuccess {Number} book_id 书本id
* @apiSuccess {Number} totalChargeAmount 充值总额
* @apiSuccess {String} distribution_channel_name, 渠道名称
* @apiSuccess {String} charge_type 书本收费方式
* @apiSuccess {Number} cost 成本
* @apiSuccess {String} send_time 派单时间
* @apiSuccess {Number} half_day_charge_amount 12小时充值金额
* @apiSuccess {Number} weekend_charge_amount 7天充值金额
* @apiSuccess {Number} firstChargeUserNum 首充用户数
* @apiSuccess {String} updated_at 更新时间
* @apiSuccess {String} created_at 创建时间
* @apiSuccess {Number} fansNum 粉丝数
* @apiSuccess {Number} registerNum 注册数
* @apiSuccess {Number} payUserNum 付费用户数
* @apiSuccess {Number} paid_num 成功订单数
* @apiSuccess {Number} unpaid_num 失败订单数
* @apiSuccess {Number} first_recharge_amount 首充总额
* @apiSuccess {Number} vipPayUserNum VIP付费用户数
* @apiSuccess {Number} normalPayUserNum 普通付费用户数
* @apiSuccess {Number} vipOrderCount vip用户订单数
* @apiSuccess {Number} pv pv数
* @apiSuccess {Number} uv uv数
* @apiSuccess {Number} total_pv 总pv数
* @apiSuccess {Number} total_uv 总uv数
* @apiSuccess {Number} sum_fee 订阅总额
* @apiSuccess {Number} sum_charge_balance 充值总额
* @apiSuccess {Number} sum_reward_balance 奖励总额
* @apiSuccess {Number} date 日期
*
*
* @apiSuccessExample {json} Success-Response:
*
* {
* "code": 0,
* "msg": "",
* "data": [
* {
* "id": 5,
* "name": "acai",
* "distribution_channel_id": "1234",
* "book_name": 书名,
* "book_id": 123,
* "totalChargeAmount": 12,
* "distribution_channel_name":"渠道名称1",
* "charge_type":"Book",
* "cost":111,
* "send_time": "2017-11-22 14:40:46",
* "weekend_charge_amount": 71,
* "half_day_charge_amount": 105,
* "firstChargeUserNum":0,
* "updated_at": "2017-11-22 14:40:46",
* "created_at": "2017-11-22 14:40:46",
* "fansNum": 0,
* "registerNum": 0,
* "payUserNum": 0,
* "paid_num": 123,
* "unpaid_num": 123,
* "first_recharge_amount": 123,
* "vipPayUserNum": 123,
* "normalPayUserNum": 123,
* 'vipOrderCount': 123,
* "pv": 0,
* "uv":0,
* "total_pv":12,
* "total_uv":12,
* "date":"2017-11-22 14:40:46"
* },
* {
* "id": 5,
* "name": "acai",
* "distribution_channel_id": "1234",
* "book_name": 书名,
* "book_id": 123,
* "totalChargeAmount": 12,
* "distribution_channel_name":"渠道名称1",
* "charge_type":"Book",
* "cost":111,
* "send_time": "2017-11-22 14:40:46",
* "weekend_charge_amount": 71,
* "half_day_charge_amount": 105,
* "firstChargeUserNum":0,
* "updated_at": "2017-11-22 14:40:46",
* "created_at": "2017-11-22 14:40:46",
* "fansNum": 0,
* "registerNum": 0,
* "payUserNum": 0,
* "paid_num": 123,
* "unpaid_num": 123,
* "first_recharge_amount": 123,
* "vipPayUserNum": 123,
* "normalPayUserNum": 123,
* 'vipOrderCount': 123,
* "pv": 0,
* "uv":0,
* "total_pv":12,
* "total_uv":12,
* "date":"2017-11-22 14:40:46"
* },
* ],
* "meta": {
* "total": 1,
* "per_page": 15,
* "current_page": 1,
* "last_page": 1,
* "next_page_url": "",
* "prev_page_url": ""
* }
* }
*/
function getHistorySendOrders(Request $request)
{
$name = $request->has('name') ? $request->input('name') : '';
$bid = $request->has('book_id') ? $request->input('book_id') : '';
$order_field = $request->has('orderBy') ? $request->input('orderBy') : '';
$order_type = $request->has('orderByType') && $request->input('orderByType') == 2 ? 'asc' : 'desc';//排序类型
$order_status = $request->has('order_status') ? $request->input('order_status') : 0;//内外部派单 1内部 2外部
$book_name = $request->has('bookName') ? $request->input('bookName') : '';
$distribution_channel_id = $request->has('channel_id') ? $request->input('channel_id') : '';
$send_order_id = $request->has('sendOrder_id') ? $request->input('sendOrder_id') : '';
$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) : '';
$start_time = $request->has('start_time') && !empty($request->input('start_time')) ? $request->input('start_time') : '';
$gender = $request->has('gender') && !empty($request->input('gender')) ? $request->input('gender') : '';
$params = compact('name', 'bid', 'book_name', 'distribution_channel_id', 'send_order_id', 'start_time', 'end_time', 'order_status', 'order_type', 'order_field', 'gender');
$data = SendOrderStatService::getList($params);
//SendStatistics
foreach ($data as &$v) {
$v->beforevipuv = 0;
$v->beforeforcesubuv = 0;
$res = SendStatistics::getBeforeForceSubAndBeforeVipUv($v->bid, $v->send_order_id, date('Y-m-d', strtotime($v->create_time)), false);
$v->beforevipuv = $res['before_vip'];
$v->beforeforcesubuv = $res['before_forcesub'];
}
return response()->pagination(new SendOrderStatTransformer(), $data);
}
/**
* @apiVersion 1.0.0
* @api {GET} sendOrder/exportHistorySendOrders 导出历史派单列表
* @apiGroup sendOrder
* @apiName exportHistorySendOrders
* @apiParam {Number} [sendOrder_id] 派单id(可不传)
* @apiParam {Number} [book_id] 书本id(可不传)
* @apiParam {String} [name] 派单名称(可不传)
* @apiParam {Number} [orderByType] 排序类型(1:降序，2:升序) 可不传，默然为降序
* @apiParam {Number} [order_status] 内外部派单(1： 内部派单， 2：外部派单)
* @apiParam {Number} [orderBy] 排序(1:12小时，2:7天, 3：充值总额， 4：首充总额) 可不传，默然为创建时间排序 orderByType
* @apiParam {String} [bookName] 书本名称(可不传)
* @apiParam {Number} [channel_id] 渠道id(可不传)
* @apiParam {String} [start_time] 开始时间(可不传)
* @apiParam {String} [end_time] 结束时间(可不传)
*
* @apiSuccess {Number} id 派单id.
* @apiSuccess {String} name 派单名称
* @apiSuccess {Number} distribution_channel_id 渠道id
* @apiSuccess {String} book_name 图书名称
* @apiSuccess {Number} book_id 书本id
* @apiSuccess {Number} totalChargeAmount 充值总额
* @apiSuccess {String} distribution_channel_name, 渠道名称
* @apiSuccess {String} charge_type 书本收费方式
* @apiSuccess {Number} cost 成本
* @apiSuccess {String} send_time 派单时间
* @apiSuccess {Number} half_day_charge_amount 12小时充值金额
* @apiSuccess {Number} weekend_charge_amount 7天充值金额
* @apiSuccess {Number} firstChargeUserNum 首充用户数
* @apiSuccess {String} updated_at 更新时间
* @apiSuccess {String} created_at 创建时间
* @apiSuccess {Number} fansNum 粉丝数
* @apiSuccess {Number} registerNum 注册数
* @apiSuccess {Number} payUserNum 付费用户数
* @apiSuccess {Number} paid_num 成功订单数
* @apiSuccess {Number} unpaid_num 失败订单数
* @apiSuccess {Number} first_recharge_amount 首充总额
* @apiSuccess {Number} vipPayUserNum VIP付费用户数数
* @apiSuccess {Number} normalPayUserNum 普通付费用户数数
* @apiSuccess {Number} pv pv数
* @apiSuccess {Number} uv uv数
* @apiSuccess {Number} total_pv 总pv数
* @apiSuccess {Number} total_uv 总uv数
* @apiSuccess {Number} date 日期
*
* @apiSuccessExample {json} Success-Response:
*
* {
* "code": 0,
* "msg": "",
* "data": [
* {
* "id": 5,
* "name": "acai",
* "distribution_channel_id": "1234",
* "book_name": "书名",
* "book_id": 123,
* "totalChargeAmount": 12,
* "distribution_channel_name":"渠道名称1",
* "charge_type":"Book",
* "cost":111,
* "send_time": "2017-11-22 14:40:46",
* "weekend_charge_amount": 71,
* "half_day_charge_amount": 105,
* "firstChargeUserNum":0,
* "updated_at": "2017-11-22 14:40:46",
* "created_at": "2017-11-22 14:40:46",
* "fansNum": 0,
* "registerNum": 0,
* "payUserNum": 0,
* "paid_num": 123,
* "unpaid_num": 123,
* "first_recharge_amount": 123,
* "vipPayUserNum": 123,
* "normalPayUserNum": 123,
* "pv": 0,
* "uv":0,
* "total_pv":12,
* "total_uv":12,
* "date":"2017-11-22 14:40:46"
* },
* {
* "id": 5,
* "name": "acai",
* "distribution_channel_id": "1234",
* "book_name": "书名",
* "book_id": 123,
* "totalChargeAmount": 12,
* "distribution_channel_name":"渠道名称1",
* "charge_type":"Book",
* "cost":111,
* "send_time": "2017-11-22 14:40:46",
* "weekend_charge_amount": 71,
* "half_day_charge_amount": 105,
* "firstChargeUserNum":0,
* "updated_at": "2017-11-22 14:40:46",
* "created_at": "2017-11-22 14:40:46",
* "fansNum": 0,
* "registerNum": 0,
* "payUserNum": 0,
* "paid_num": 123,
* "unpaid_num": 123,
* "first_recharge_amount": 123,
* "vipPayUserNum": 123,
* "normalPayUserNum": 123,
* "pv": 0,
* "uv":0,
* "total_pv":12,
* "total_uv":12,
* "date":"2017-11-22 14:40:46"
* },
* ],
* }
*/
function exportHistorySendOrders(Request $request)
{
\Log::info($request->all());
$name = $request->has('name') ? $request->input('name') : '';
$bid = $request->has('book_id') ? $request->input('book_id') : '';
$order_field = $request->has('orderBy') ? $request->input('orderBy') : '';
$order_type = $request->has('orderByType') && $request->input('orderByType') == 2 ? 'asc' : 'desc';//排序类型
$order_status = $request->has('order_status') ? $request->input('order_status') : 0;//内外部派单 1内部 2外部
$book_name = $request->has('bookName') ? $request->input('bookName') : '';
$distribution_channel_id = $request->has('channel_id') ? $request->input('channel_id') : '';
$send_order_id = $request->has('sendOrder_id') ? $request->input('sendOrder_id') : '';
$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) : '';
$start_time = $request->has('start_time') && !empty($request->input('start_time')) ? $request->input('start_time') : '';
$params = compact('name', 'bid', 'book_name', 'distribution_channel_id', 'send_order_id', 'start_time', 'end_time', 'order_status', 'order_type', 'order_field');
\Log::info('params is:');
\Log::info($request->all());
header("Content-type:application/vnd.ms-excel");
header("Content-Disposition:attachment;filename=" . "派单历史数据" . date("YmdHis") . ".csv");
echo iconv("UTF-8", "GBK", "\"创建时间\",\"派单实际发送时间\",\"派单ID\",\"派单名称\",\"渠道ID\",\"推广书籍名称\",\"推广书籍ID\",\"收费方式\",\"充值金额\",\"渠道名称\",\"成本\",\"派单实际发送时间\",\"12小时充值金额\",\"7天充值金额\",\"24小时充值金额\",\"3天充值金额\",\"首充用户数\",\"数据更新时间\",\"粉丝数\",\"注册用户数\",\"付费用户数\",\"成功订单数\",\"失败订单数\",\"首充总数\",\"VIP付费用户数\",\"普通付费用户数\",\"pv\",\"uv\",\"24小时uv\",\"24小时pv\",\"vip前一章uv\",\"强关前一章uv\"\r\n");
$obj = SendOrderStatService::getObj($params);
$obj->chunk(2000, function ($send_orders) {
foreach ($send_orders as $item) {
$res = SendStatistics::getBeforeForceSubAndBeforeVipUv($item->bid, $item->send_order_id, date('Y-m-d', strtotime($item->create_time)), false);
echo("\"" . $item->create_time . "\",");
echo("\"" . $item->send_time . "\",");
echo("\"" . $item->send_order_id . "\",");
echo("\"" . mb_convert_encoding(($item->name ? $item->name : "未填"), "GBK") . "\",");
echo("\"" . $item->distribution_channel_id . "\",");
echo("\"" . mb_convert_encoding(($item->book_name ? $item->book_name : "未填"), "GBK") . "\",");
echo("\"" . $item->bid . "\",");
echo("\"" . $item->charge_type . "\",");
echo("\"" . $item->recharge_amount . "\",");
echo("\"" . mb_convert_encoding(($item->distribution_channel_name ? $item->distribution_channel_name : "未填"), "GBK") . "\",");
echo("\"" . $item->cost . "\",");
echo("\"" . $item->send_time . "\",");
echo("\"" . $item->recharge_amount_in_half_day . "\",");
echo("\"" . $item->recharge_amount_in_two_weeks . "\",");
echo("\"" . $item->recharge_amount_in_one_day . "\",");
echo("\"" . $item->recharge_amount_in_three_days . "\",");
echo("\"" . $item->first_recharge_user_num . "\",");
echo("\"" . date("Y-m-d H:i:s", strtotime($item->updated_at)) . "\",");
echo("\"" . $item->force_user_num . "\",");
echo("\"" . $item->register_user_num . "\",");
echo("\"" . $item->pay_user_num . "\",");
echo("\"" . $item->paid_num . "\",");
echo("\"" . $item->unpaid_num . "\",");
echo("\"" . $item->first_recharge_amount . "\",");
echo("\"" . $item->year_recharge_user_num . "\",");
echo("\"" . $item->ticket_recharge_user_num . "\",");
echo("\"" . $item->pv . "\",");
echo("\"" . $item->uv . "\",");
//24小时pv、uv
$extra_stat = SendOrderService::getExtraStat($item->send_order_id);
$uv_one_day = $extra_stat ? $extra_stat->uv_one_day : 0;
$pv_one_day = $extra_stat ? $extra_stat->pv_one_day : 0;
echo("\"" . $uv_one_day . "\",");
echo("\"" . $pv_one_day . "\",");
echo("\"" . $res['before_vip'] . "\",");
echo("\"" . $res['before_forcesub'] . "\"\r\n");
}
});
exit();
}
/**
* 加密站点id
* @param Request $request
*/
function encodeSiteId(Request $request)
{
$siteId = $request->has('siteId') ? $request->input('siteId') : '';
if (empty($siteId)) {
return response()->error("PARAM_EMPTY");
}
if (!is_numeric($siteId)) {
return response()->error("PARAM_ERROR");
}
$siteId = encodeDistributionChannelId($siteId);
$url = "https://site" . $siteId . ".leyuee.com";
return response()->success(['url' => $url]);
}
}