123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147 |
- <?php
- namespace App\Http\Controllers\Manage\Trade;
- use App\Http\Controllers\Controller;
- use App\Http\Controllers\Manage\Trade\Transformers\SubstituteOrderTransformer;
- use App\Modules\Subscribe\Services\SubstituteOrderService;
- use DB;
- use Illuminate\Http\Request;
- class SubstituteOrdersController extends Controller
- {
-
-
- function getSubstituteOrderInfos(Request $request)
- {
- $end_time = $request->has('end_time') ? $request->input('end_time') : '';
- $start_time = $request->has('start_time') ? $request->input('start_time') : '';
- $distribution_channel_id = $request->has('distribution_channel_id') ? $request->input('distribution_channel_id') : '';
- if (!$start_time) {
- $start_time = date("2018-10-1");
- }
- if (!$end_time) {
- $end_time = date("Y-m-d");
- }
- $result = SubstituteOrderService::substituteStats(false,$start_time, $end_time, $distribution_channel_id);
- foreach ($result as $item) {
- $date = $item->date;
- $distribution_channel_id = $item->distribution_channel_id;
- $item->show_substitute_order_page_uv = SubstituteOrderService::getSubstitutePageUvPv($distribution_channel_id, $date);
- $item->click_substitute_order_pay_button_uv = SubstituteOrderService::getSubstituteButtonUvPv($distribution_channel_id, $date);
- }
- return response()->pagination(new SubstituteOrderTransformer(), $result);
- }
-
- function exportSubstituteOrderInfos(Request $request)
- {
- $end_time = $request->has('end_time') ? $request->input('end_time') : '';
- $start_time = $request->has('start_time') ? $request->input('start_time') : '';
- $distribution_channel_id = $request->has('distribution_channel_id') ? $request->input('distribution_channel_id') : '';
- if (!$start_time) {
- $start_time = date("2018-10-1");
- }
- if (!$end_time) {
- $end_time = date("Y-m-d");
- }
- $result = SubstituteOrderService::substituteStats(true,$start_time, $end_time, $distribution_channel_id);
- header("Content-type:application/vnd.ms-excel");
- header("Content-Disposition:attachment;filename=" . "代付信息" . date("YmdHis") . ".csv");
- echo("\"" . mb_convert_encoding("\"日期\",\"代付人数\",\"代付金额\",\"充值页面代付按钮UV\",\"代付页面UV\",\"代付订单\",\"代付成功订单\"\r\n", "GBK", "UTF-8") . "\",");
- foreach ($result as $item) {
- $date = $item->date;
- $distribution_channel_id = $item->distribution_channel_id;
- $item->show_substitute_order_page_uv = SubstituteOrderService::getSubstitutePageUvPv($distribution_channel_id, $date);
- $item->click_substitute_order_pay_button_uv = SubstituteOrderService::getSubstituteButtonUvPv($distribution_channel_id, $date);
- echo("\"" . mb_convert_encoding($item->date, "GBK", "UTF-8") . "\",");
- echo("\"" . mb_convert_encoding($item->users_num, "GBK", "UTF-8") . "\",");
- echo("\"" . mb_convert_encoding($item->amount, "GBK", "UTF-8") . "\",");
- echo("\"" . mb_convert_encoding($item->click_substitute_order_pay_button_uv, "GBK", "UTF-8") . "\",");
- echo("\"" . mb_convert_encoding($item->show_substitute_order_page_uv, "GBK", "UTF-8") . "\",");
-
- echo("\"" . mb_convert_encoding($item->num, "GBK", "UTF-8") . "\",");
- echo("\"" . $item->success_num . "\"\r\n");
- }
- exit();
- }
- }
|