nizongfeng
/
ZZCX_yii
1
0
Fork 0
Code Issues 0 Pull Requests 0 Releases 0 Wiki Activity
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
3 Commits
1 Branch
96 MiB
 
 
 
 
 
 
Branch: master
Branches Tags
${ item.name }
Create branch ${ searchTerm }
from 'master'
${ noResults }
ZZCX_yii/backend/modules/hotel/controllers/ReportController.php

514 lines
22 KiB
Raw Permalink Blame History 

  1. <?php

  2. 

  3. namespace backend\modules\hotel\controllers;

  4. 

  5. use backend\modules\hotel\models\OrderMain;

  6. use backend\modules\hotel\models\Report;

  7. use backend\modules\hotel\models\SaleReport;

  8. use backend\modules\hotel\models\User;

  9. use backend\modules\zzcs\models\OrderFinanceReparations;

  10. use common\components\zPhpExcel;

  11. use Yii;

  12. use yii\helpers\Json;

  13. 

  14. /**

  15.  * 报表 controller for the `Hotel` module

  16.  */

  17. class ReportController extends HotelController

  18. {

  19.     /**

  20.      * User: wangxj

  21.      *

  22.      * 酒店销售统计

  23.      *

  24.      * @return string

  25.      */

  26.     public function actionSales()

  27.     {

  28.         $this->writeLog('hotelSales');

  29.         $obj = new Report();

  30.         if(Yii::$app->request->isPost)

  31.             $obj->load(Yii::$app->request->post());

  32.         else if(Yii::$app->request->isGet)

  33.             $obj->load(Yii::$app->request->get());

  34.         $data['data'] = $obj->getNewReport();

  35.         $data['model'] = new OrderMain();

  36.         $searchModel = $obj;

  37.         $data['export_url'] = Yii::$app->urlManager->createUrl(['hotel/report/export-hotel-report', 'hotel_id' => $searchModel['hotel_id'], 'Report[org_sale_id]' => $searchModel['org_sale_id'], 'Report[start_date]' => $searchModel['start_date']

  38.             , 'Report[end_date]' => $searchModel['end_date'], 'Report[date_type]' => $searchModel['date_type']]);

  39.         if(Yii::$app->request->isAjax) {

  40.             return $this->renderPartial('report', ['view' => '_hotelSales', 'searchModel' => $searchModel, 'data' => $data]);

  41.         } else {

  42.             return $this->render('report', ['view' => '_hotelSales', 'searchModel' => $searchModel, 'data' => $data]);

  43.         }

  44.     }

  45. 

  46.     /**

  47.      * User: luocj

  48.      *

  49.      * 酒店销售统计订单钻取

  50.      *

  51.      * @return string

  52.      */

  53.     public function actionHotelSalesRoom()

  54.     {

  55.         $obj = new Report();

  56.         if(Yii::$app->request->isPost)

  57.             $obj->load(Yii::$app->request->post());

  58.         else if(Yii::$app->request->isGet)

  59.             $obj->load(Yii::$app->request->get());

  60.         $data = $obj->getOrderList();

  61.         $data['model'] = new OrderMain();

  62.         $searchModel = $obj;

  63.         $data['export_url'] = Yii::$app->urlManager->createUrl(['hotel/report/export-order-list',

  64.             'org_sale_id' => $searchModel['org_sale_id'],

  65.             'hotel_id' => $searchModel['hotel_id'],

  66.             'start_date' => $searchModel['start_date'],

  67.             'end_date' => $searchModel['end_date'],

  68.             'date_type' => $searchModel['date_type'],

  69.             'user_id' => $searchModel['user_id'],

  70.             'room_type' => $searchModel['room_type'],

  71.             'send_user_id' => $searchModel['send_user_id'],

  72.             'principal_id' => $searchModel['principal_id'],

  73.             'purchaser_id' => $searchModel['purchaser_id'],

  74.             'op' => $searchModel['op'],

  75.         ]);

  76.         if(Yii::$app->request->isAjax) {

  77.             return $this->renderPartial('report', ['view' => '_hotelSalesRoom', 'searchModel' => $searchModel, 'data' => $data]);

  78.         } else {

  79.             return $this->render('report', ['view' => '_hotelSalesRoom', 'searchModel' => $searchModel, 'data' => $data]);

  80.         }

  81.     }

  82. 

  83.     /**

  84.      * User: luocj

  85.      *

  86.      * 酒店销售统计二层渠道

  87.      *

  88.      * @return string

  89.      */

  90.     public function actionSalesChannel()

  91.     {

  92.         $obj = new Report();

  93.         if(Yii::$app->request->isPost)

  94.             $obj->load(Yii::$app->request->post());

  95.         else if(Yii::$app->request->isGet)

  96.             $obj->load(Yii::$app->request->get());

  97.         $data['data'] = $obj->getNewReport();

  98.         $data['model'] = new OrderMain();

  99.         $searchModel = $obj;

  100.         $data['export_url'] = Yii::$app->urlManager->createUrl(['hotel/report/export-hotel-report',

  101.             'Report[org_sale_id]' => $searchModel['org_sale_id'],

  102.             'Report[start_date]' => $searchModel['start_date'],

  103.             'Report[end_date]' => $searchModel['end_date'],

  104.             'Report[date_type]' => $searchModel['date_type'],

  105.             'op' => 'orgSale',

  106.             'hotel_id' => $searchModel['hotel_id']]);

  107. 

  108.         if(Yii::$app->request->isAjax) {

  109.             return $this->renderPartial('report', ['view' => '_hotelSalesChannel', 'searchModel' => $searchModel, 'data' => $data]);

  110.         } else {

  111.             return $this->render('report', ['view' => '_hotelSalesChannel', 'searchModel' => $searchModel, 'data' => $data]);

  112.         }

  113.     }

  114. 

  115.     /**

  116.      * User: luocj

  117.      *

  118.      * 酒店销售统计三层房型

  119.      *

  120.      * @return string

  121.      */

  122.     public function actionSalesChannelRoom()

  123.     {

  124.         $obj = new Report();

  125.         if(Yii::$app->request->isPost)

  126.             $obj->load(Yii::$app->request->post());

  127.         else if(Yii::$app->request->isGet)

  128.             $obj->load(Yii::$app->request->get());

  129.         $data['data'] = $obj->getNewReport();

  130.         $data['model'] = new OrderMain();

  131.         $searchModel = $obj;

  132.         $data['export_url'] = Yii::$app->urlManager->createUrl([

  133.             'hotel/report/export-hotel-report',

  134.             'Report[org_sale_id]' => $searchModel['org_sale_id'],

  135.             'Report[start_date]' => $searchModel['start_date'],

  136.             'room_type' => $searchModel['room_type'],

  137.             'Report[end_date]' => $searchModel['end_date'],

  138.             'Report[date_type]' => $searchModel['date_type'],

  139.             'hotel_id' => $searchModel['hotel_id'],

  140.             'org_sale_id' => $searchModel['org_sale_id'],

  141.             'op' => 'roomInfo']);

  142. 

  143.         if(Yii::$app->request->isAjax) {

  144.             return $this->renderPartial('report', ['view' => '_hotelSalesChannelRoom', 'searchModel' => $searchModel, 'data' => $data]);

  145.         } else {

  146.             return $this->render('report', ['view' => '_hotelSalesChannelRoom', 'searchModel' => $searchModel, 'data' => $data]);

  147.         }

  148.     }

  149. 

  150.     /**

  151.      * User: wangxj

  152.      * 客服 采购 运营

  153.      */

  154.     public function actionCustomer()

  155.     {

  156.         $obj = new Report();

  157.         if(Yii::$app->request->isPost)

  158.             $obj->load(Yii::$app->request->post());

  159.         else if(Yii::$app->request->isGet)

  160.             $obj->load(Yii::$app->request->get());

  161.         if($obj->op == 'getInfo') {

  162.             $obj->op = 'cusService';

  163.         }

  164. 

  165.         $data['data'] = $obj->getNewReport();

  166.         $data['model'] = new OrderMain();

  167.         $searchModel = $obj;

  168.         $data['export_url'] = Yii::$app->urlManager->createUrl(['hotel/report/export-hotel-report',

  169.             'Report[org_sale_id]' => $searchModel['org_sale_id'],

  170.             'Report[start_date]' => $searchModel['start_date'],

  171.             'op' => $searchModel['op'],

  172.             'Report[hotel_id]' => $searchModel['hotel_id'],

  173.             'Report[end_date]' => $searchModel['end_date'],

  174.             'Report[date_type]' => $searchModel['date_type']]);

  175. 

  176.         if(Yii::$app->request->isAjax) {

  177.             return $this->renderPartial('report', ['view' => '_allHotelSales', 'searchModel' => $searchModel, 'data' => $data]);

  178.         } else {

  179.             return $this->render('report', ['view' => '_allHotelSales', 'searchModel' => $searchModel, 'data' => $data]);

  180.         }

  181.     }

  182. 

  183.     /**

  184.      * User: wangxj

  185.      *

  186.      * 采购业绩统计

  187.      *

  188.      */

  189.     public function actionPurchase()

  190.     {

  191.         $this->writeLog('Purchase');

  192.         $obj = new Report();

  193.         $obj->load(Yii::$app->request->post());

  194.         $obj->op = 'purchaser';

  195.         $data = $obj->getReportInfo_new();

  196.         if(Yii::$app->request->isAjax) {

  197.             return true;

  198.         } else {

  199.             return $this->render('report', ['view' => '_hotelSales', 'data' => $data]);

  200.         }

  201.     }

  202. 

  203.     /**

  204.      * User:Steven

  205.      *

  206.      * 销售渠道统计

  207.      * @return string

  208.      */

  209.     public function actionSaleChannel()

  210.     {

  211.         $this->writeLog('SaleChannel');

  212.         $obj = new Report();

  213.         $obj->op = 'orgSale';

  214.         if(Yii::$app->request->isPost)

  215.             $obj->load(Yii::$app->request->post());

  216.         else if(Yii::$app->request->isGet)

  217.             $obj->load(Yii::$app->request->get());

  218.         $data['data'] = $obj->getNewReport();

  219.         $data['model'] = new OrderMain();

  220.         $searchModel = $obj;

  221.         $data['export_url'] = Yii::$app->urlManager->createUrl(['hotel/report/export-hotel-report',

  222.             'Report[org_sale_id]' => $searchModel['org_sale_id'],

  223.             'Report[start_date]' => $searchModel['start_date'],

  224.             'Report[end_date]' => $searchModel['end_date'],

  225.             'Report[date_type]' => $searchModel['date_type'],

  226.             'op' => 'orgSale',

  227.             'hotel_id' => $searchModel['hotel_id']]);

  228. 

  229.         if(Yii::$app->request->isAjax) {

  230.             return $this->renderPartial('report', ['view' => '_hotelSalesChannel', 'searchModel' => $searchModel, 'data' => $data, 'url' => 'hotel/report/sales']);

  231.         } else {

  232.             return $this->render('report', ['view' => '_hotelSalesChannel', 'searchModel' => $searchModel, 'data' => $data, 'url' => 'hotel/report/sales']);

  233.         }

  234.     }

  235. 

  236. 

  237.     /**

  238.      * User:luocj

  239.      * 酒店层面维度统计报表

  240.      */

  241.     public function actionExportHotelReport()

  242.     {

  243.         $obj = new Report();

  244.         if(Yii::$app->request->isPost)

  245.             $obj->load(Yii::$app->request->post());

  246.         else if(Yii::$app->request->isGet)

  247.             $obj->load(Yii::$app->request->get());

  248.         $data_temp = $obj->getNewReport();

  249.         if($obj->op == 'getInfo') {

  250.             $tabel_name = '酒店销售统计';

  251.             $first_name = '酒店';

  252.         } elseif($obj->op == 'orgSale') {

  253.             $tabel_name = '酒店销售渠道分布统计';

  254.             $first_name = '渠道';

  255.         } elseif($obj->op == 'roomInfo') {

  256.             $tabel_name = '酒店渠道销售房型统计';

  257.             $first_name = '房型';

  258.         } elseif($obj->op == 'cusService') {

  259.             $tabel_name = '酒店非直连订单客服跟单统计';

  260.             $first_name = '跟单客服';

  261.         } elseif($obj->op == 'purchaser') {

  262.             $tabel_name = '酒店采购业绩统计';

  263.             $first_name = '采购人';

  264.         } elseif($obj->op == 'principal') {

  265.             $tabel_name = '酒店运营业绩统计';

  266.             $first_name = '运营人';

  267.         } elseif($obj->op == 'cusServiceSend') {

  268.             $tabel_name = '酒店直连订单发单工作业绩统计';

  269.             $first_name = '姓名';

  270.         }

  271. 

  272.         //改版后的

  273.         $data['data']['all'][0] = [

  274.             'order_num' => $data_temp['total']['total_order_num'],

  275.             'room_count' => $data_temp['total']['total_room_num'],

  276.             'room_rate' => $data_temp['total']['total_mom_room_count'],

  277.             'sales_value' => $data_temp['total']['total_order_price'],

  278.             'sales_rate' => $data_temp['total']['total_mom_order_price'],

  279.             'cost_value' => $data_temp['total']['total_base_price'],

  280.             'commission_value' => $data_temp['total']['total_commission_total'],

  281.             'peiru_sum' => $data_temp['total']['total_compensate_in'],

  282.             'peichu_sum' => $data_temp['total']['total_compensate_out'],

  283.             'profit_value' => $data_temp['total']['total_order_profit'],

  284.             'profit_rate' => $data_temp['total']['total_mom_profit_value'],

  285.             'gross_rate' => $data_temp['total']['total_price_rate'],

  286. 

  287.         ];

  288.         $data_title = array('序号', $first_name, '订单数', '间夜数', '间夜数月环比', '销售额', '销售额月环比', '采购成本', '渠道佣金', '赔入', '赔出', '毛利', '毛利月环比', '毛利率');

  289.         $data['data']['list'] = [];

  290.         foreach ($data_temp['order_info'] as $k => $v) {

  291.             $data['data']['list'][$k]['num'] = $k + 1;

  292.             if($obj->op == 'getInfo') {

  293.                 $data['data']['list'][$k]['channel_name'] = $v['PARENT_PROD_NAME'];

  294.             } elseif($obj->op == 'orgSale') {

  295.                 $data['data']['list'][$k]['channel_name'] = $v['CHANNEL_NAME'];

  296.             } elseif($obj->op == 'roomInfo') {

  297.                 $data['data']['list'][$k]['channel_name'] = $v['PROD_NAME'];

  298.             } elseif($obj->op == 'cusService') {

  299.                 $data['data']['list'][$k]['channel_name'] = $v['user']['TRUE_NAME'];

  300.             } elseif($obj->op == 'purchaser') {

  301.                 $data['data']['list'][$k]['channel_name'] = $v['PURCHASE_TRUE_NAME'];

  302.             } elseif($obj->op == 'principal') {

  303.                 $data['data']['list'][$k]['principal'] = $v['PRINCIPAL_TRUE_NAME'];

  304.             } elseif($obj->op == 'cusServiceSend') {

  305.                 $data['data']['list'][$k]['channel_name'] = $v['SEND_CREATE_USER'];

  306.             }

  307.             $data['data']['list'][$k]['order_count'] = $v['order_count'];

  308.             $data['data']['list'][$k]['room_count'] = $v['room_count'];

  309.             $data['data']['list'][$k]['room_rate'] = $v['room_count_mom'];

  310.             $data['data']['list'][$k]['sales_value'] = $v['ORDER_PRICE'];

  311.             $data['data']['list'][$k]['sales_rate'] = $v['order_price_mom'];

  312.             $data['data']['list'][$k]['cost_value'] = $v['BASE_PRICE'];

  313.             $data['data']['list'][$k]['commission_value'] = $v['TOTAL_COMMISSION'];

  314.             $data['data']['list'][$k]['peiru'] = $v['compensate_in'];

  315.             $data['data']['list'][$k]['peichu'] = $v['compensate_out'];

  316.             $data['data']['list'][$k]['profit_value'] = $v['PROFIT_VALUE'];

  317.             $data['data']['list'][$k]['profit_rate'] = $v['profit_value_mom'];

  318.             $data['data']['list'][$k]['gross_rate'] = $v['price_rate'];

  319.             //运营、采购负责人

  320.             if($obj->op == 'getInfo') {

  321.                 $data['data']['list'][$k]['principal'] = $v['PRINCIPAL_TRUE_NAME'];

  322.                 $data['data']['list'][$k]['purchase'] = $v['PURCHASE_TRUE_NAME'];

  323.             }

  324.         }

  325. 

  326.         //如果是酒店纬度添加运营和采购

  327.         if($obj->op == 'getInfo') {

  328.             array_push($data_title, '运营负责人');

  329.             array_push($data_title, '采购负责人');

  330.         }

  331.         $this->exportExcel($obj, $tabel_name, $data_title, $data['data']['all'], $data['data']['list']);

  332.     }

  333. 

  334.     /**

  335.      * User :Steven

  336.      *

  337.      * 生成统计报表的数据接口（定时任务维护（每天00:00执行一次））

  338.      */

  339.     public function actionUpdateStatisticsData()

  340.     {

  341.         $obj = new Report();

  342.         $res = $obj->updateStatisticsData();

  343.         $result = ['code' => 0, 'data' => $res];

  344. 

  345.         return Json::encode($result);

  346. 

  347.     }

  348. 

  349. 

  350.     /**

  351.      * User: wangxj

  352.      *

  353.      * 导出订单报表

  354.      */

  355.     public function actionExportOrderList()

  356.     {

  357.         $obj = new Report();

  358.         $obj->load(Yii::$app->request->get());

  359.         $data_title = array('预订时间', '订单编号', '订单渠道', '预订产品', '客人信息', '入住日期', '离店日期', '间夜数', '销售额', '采购成本', '渠道佣金', '毛利', '毛利率', '订单状态', '跟单客服', '运营负责人', '采购负责人', '赔出', '赔入');

  360.         set_time_limit(1200);

  361.         ini_set("memory_limit", "2048M");

  362.         $data = $obj->getOrderList();   //订单列表

  363.         $tmp = $data['data']['dataProvider'];

  364.         $tmp->pagination = false;

  365.         $tmp = $tmp->getModels();

  366.         $data['all'] = [];

  367.         $count = count($tmp);

  368.         if($count > 0) {

  369.             $data['list'] = [];

  370.             foreach ($tmp as $key => $item) {

  371.                 $data['list'][$key]['CREATE_TIME'] = $item['CREATE_TIME'];

  372.                 $data['list'][$key]['ORDER_ID'] = $item['ORDER_ID'];

  373.                 $data['list'][$key]['SUPPLIER_NAME'] = $item['CHANNEL_NAME'];

  374.                 $data['list'][$key]['PROD_NAME'] = $item['PROD_NAME'];

  375.                 $data['list'][$key]['CUSTOMER_NAME'] = $item['CUSTOMER_NAME'] . ' ' . $item['CUSTOMER_MOBILE'];

  376.                 $data['list'][$key]['PROD_START_STATION_DATE'] = $item['PROD_START_STATION_DATE'];

  377.                 $data['list'][$key]['PROD_END_STATION_DATE'] = $item['PROD_END_STATION_DATE'];

  378.                 $data['list'][$key]['room_count'] = $item['room_count'];

  379.                 $data['list'][$key]['ORDER_PRICE'] = $item['ORDER_PRICE'];

  380.                 $data['list'][$key]['BASE_PRICE'] = $item['BASE_PRICE'];

  381.                 $data['list'][$key]['TOTAL_COMMISSION'] = $item['TOTAL_COMMISSION'];

  382.                 $data['list'][$key]['PROFIT'] = $item['ORDER_PRICE'] - $item['BASE_PRICE'] - $item['TOTAL_COMMISSION']+ $item['compensate_in'] - $item['compensate_out'];

  383.                 $item['ORDER_PRICE'] = $item['ORDER_PRICE'] + $item['compensate_in'] - $item['compensate_out'];

  384.                 $data['list'][$key]['PROFIT_RATE'] = $item['ORDER_PRICE'] == 0 ? "0%": number_format((($item['ORDER_PRICE'] - $item['BASE_PRICE'] - $item['TOTAL_COMMISSION']) / abs($item['ORDER_PRICE']) * 100), 2) . '%';

  385.                 $data['list'][$key]['ORDER_STATUS'] = $item['ORDER_STATUS_NAME'];

  386.                 $data['list'][$key]['TRUE_NAME'] = $item['INPUT_CREATE_USER'];

  387.                 $data['list'][$key]['PRINCIPAL'] = User::getPrincipal($item['PRINCIPAL_ID']);

  388.                 $data['list'][$key]['PURCHASE'] = $item['PURCHASE_TRUE_NAME'];

  389.                 $data['list'][$key]['COMPENSATE_OUT'] = $item['compensate_out'];

  390.                 $data['list'][$key]['COMPENSATE_IN'] = $item['compensate_in'];

  391.             }

  392.         }

  393. 

  394.         if($obj->op == 'getInfo') {

  395.             $title = '酒店销售统计';

  396.         } elseif($obj->op == 'orgSale') {

  397.             $title = '酒店销售渠道分布统计';

  398.         } elseif($obj->op == 'roomInfo') {

  399.             $title = '酒店渠道销售房型统计';

  400.         } elseif($obj->op == 'cusService') {

  401.             $title = '酒店非直连订单客服跟单统计';

  402.         } elseif($obj->op == 'purchaser') {

  403.             $title = '酒店采购业绩统计';

  404.         } elseif($obj->op == 'principal') {

  405.             $title = '酒店运营业绩统计';

  406.         } elseif($obj->op == 'cusServiceSend') {

  407.             $title = '酒店直连订单发单工作业绩统计';

  408.         } else {

  409.             $title = '酒店订单统计';

  410.         }

  411.         $this->exportExcel($obj, $title, $data_title, [], $data['list']);

  412.     }

  413. 

  414.     /**

  415.      * User:Steven

  416.      *

  417.      * 导出Excel文件

  418.      * @param $obj Report report对象

  419.      * @param $file_name string 导出文件名称后缀

  420.      * @param $data_title array 数据表头，title

  421.      * @param $data_all array 合计数据列表

  422.      * @param $data_list array 数据列表

  423.      */

  424.     public function exportExcel($obj, $file_name, $data_title, $data_all, $data_list)

  425.     {

  426.         //        require Yii::getAlias('@backend') . "/common/PHPExcel/PHPExcel.php";

  427.         $objPHPExcel = new zPhpExcel();   //实例化PHPExcel类

  428.         $objSheet = $objPHPExcel->getActiveSheet();   //获取当前活动sheet的操作对象

  429.         $sheet_title = $obj['start_date'] . '~' . $obj['end_date'] . ($obj['date_type'] == 1 ? '(预定时间)': ($obj['date_type'] == 2 ? '(入住时间)': '(离店日期)'));

  430.         //        $objSheet->setTitle($file_name);  //给当前活动sheet的操作对象

  431.         $objSheet->setTitle($sheet_title);

  432.         $objPHPExcel->file_name = $file_name;

  433.         $directory = array('A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z');

  434.         $cell_num = count($data_title) - 1;

  435.         $cell = $directory[$cell_num];

  436.         $objSheet->mergeCells("A1:{$cell}1"); //合并单元格

  437.         $objSheet->setCellValue('A1', $sheet_title . $file_name);

  438.         $objSheet->getStyle("A1:{$cell}1")->getFont()->setName('微软雅黑')->setSize(15)->setBold(True);

  439.         $objSheet->getStyle("A1:{$cell}1")->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER)->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);;

  440.         $objSheet->getStyle("A1:{$cell}1")->getFill()->setFillType(\PHPExcel_Style_Fill::FILL_SOLID)->getStartColor()->setRGB('A6A6A6');

  441.         $objSheet->getStyle("A2:{$cell}2")->getFill()->setFillType(\PHPExcel_Style_Fill::FILL_SOLID)->getStartColor()->setRGB('CCCCCC');

  442. 

  443.         foreach ($data_title as $k => $v) {

  444.             $objSheet->setCellValue($directory[$k] . '2', $v);

  445.         }

  446.         $objSheet->setCellValue('A3', '-');

  447.         $objSheet->setCellValue('B3', '合计');

  448.         for ($i = 0; $i < count($data_all); $i++) {

  449.             $list = array_values($data_all[$i]);

  450.             foreach ($list as $k => $v) {

  451.                 $objSheet->setCellValue($directory[$k + 2] . '3', $v);

  452.             }

  453.         }

  454.         for ($j = 0; $j < count($data_list); $j++) {

  455.             $list = array_values($data_list[$j]);

  456.             foreach ($list as $k => $v) {

  457.                 $objSheet->setCellValue($directory[$k] . ($j + 4), $v);

  458.                 $objSheet->getColumnDimension($directory[$k])->setWidth(10);

  459.             }

  460.         }

  461.         $objPHPExcel->output();

  462.     }

  463. 

  464.     /**

  465.      * 导出到浏览器

  466.      * @param $type

  467.      * @param $fileName

  468.      */

  469.     private function browserExport($type, $fileName)

  470.     {

  471.         if($type == '05') {    //输出xls文件

  472.             header('Content-Type: application/vnd.ms-excel');

  473.         } else {    //输出xlsx文件

  474.             header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');

  475.         }

  476.         header('Content-Disposition: attachment;filename="' . $fileName . '"');

  477.         header('Cache-Control: max-age=0');//禁止缓存

  478.     }

  479. 

  480.     function writeLog($log)

  481.     {

  482.         $backtrace = debug_backtrace();

  483.         array_shift($backtrace);

  484.         $dir = __DIR__ . "/../Log/";

  485.         if(!is_dir($dir)) {

  486.             mkdir($dir);

  487.         }

  488.         $filename = $dir . Yii::$app->user->id . '_' . $log . ".log";

  489.         $need_chmod = file_exists($filename);

  490.         $log_str = '[' . date("Y-m-d H:i:s") . ']';

  491.         file_put_contents($filename, $log_str . PHP_EOL, FILE_APPEND);

  492.         if($need_chmod == false) {

  493.             @chmod($filename, 0777);

  494.         }

  495.     }

  496. 

  497.     public function getClientIP()

  498.     {

  499.         global $ip;

  500.         if(getenv("HTTP_CLIENT_IP"))

  501.             $ip = getenv("HTTP_CLIENT_IP");

  502.         else if(getenv("HTTP_X_FORWARDED_FOR"))

  503.             $ip = getenv("HTTP_X_FORWARDED_FOR");

  504.         else if(getenv("REMOTE_ADDR"))

  505.             $ip = getenv("REMOTE_ADDR");

  506.         else $ip = "Unknow";

  507. 

  508.         return $ip;

  509.     }

  510. 

  511. 

  512. }