nizongfeng
/
ZZCX_yii
1
0
Креирај огранак 0
Код Дискусије 0 Захтеви за спајање 0 Издања 0 Вики 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 Комити
1 Грана
96 MiB
 
 
 
 
 
 
Грана: master
Гране Ознаке
${ item.name }
Create branch ${ searchTerm }
from 'master'
${ noResults }
ZZCX_yii/backend/modules/hotel/controllers/HotelController.php

1014 lines
43 KiB
Датотека Пермалинк Blame Историја 

  1. <?php

  2. 

  3. namespace backend\modules\hotel\controllers;

  4. 

  5. //use backend\modules\api\models\OperaHotelBaseRoom;

  6. use backend\modules\api\models\DictType;

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

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

  9. use backend\modules\hotel\models\OperaHotelBaseRoom;

  10. use backend\modules\hotel\models\OperaHotelGift;

  11. use backend\modules\hotel\models\OperaHotelLog;

  12. use backend\modules\hotel\models\OperaSort;

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

  14. use backend\modules\hotel\models\RunHotel;

  15. use common\util\UploadPic;

  16. use Yii;

  17. use backend\modules\hotel\models\OperaHotel;

  18. use backend\modules\hotel\models\RunHotelDistrib;

  19. use yii\db\Exception;

  20. use yii\helpers\ArrayHelper;

  21. use yii\helpers\Url;

  22. use yii\imagine\BaseImage;

  23. use yii\imagine\Image;

  24. use yii\web\Controller;

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

  26. use backend\modules\hotel\models\RunHotelSubRoom;

  27. use backend\modules\hotel\models\OperaHotelRoom;

  28. use backend\modules\hotel\models\RoomRelation;

  29. use backend\modules\hotel\models\HotelRelation;

  30. use backend\modules\hotel\models\OrderHtExceptionList;

  31. use backend\modules\hotel\models\OrderChannelInfo;

  32. use common\components\zOfficeWechat;

  33. use backend\modules\zzcs\models\BaseAreaView;

  34. use yii\helpers\Json;

  35. use yii\web\NotFoundHttpException;

  36. use yii\web\UploadedFile;

  37. 

  38. 

  39. /**

  40.  * Default controller for the `Hotel` module

  41.  */

  42. class HotelController extends BaseController

  43. {

  44.     //    public $layout = "@backend/modules/motorcade/views/layouts/iframe_new";

  45.     public $layout = '@backend/modules/zzcs/views/layouts/zzcs';

  46.     public $enableCsrfValidation = false;

  47. 

  48.     public function actions()

  49.     {

  50.         return [

  51.             'upload' => [

  52.                 'class' => 'kucha\ueditor\UEditorAction',

  53.                 'config' => [

  54.                     'imagePathFormat' => '/upload/hotel/{yyyy}{mm}{dd}/{time}{rand:6}',

  55.                 ],

  56.             ]

  57.         ];

  58.     }

  59. 

  60.     /**

  61.      * 酒店列表

  62.      */

  63.     public function actionIndex()

  64.     {

  65.         $this->layout = "@backend/modules/motorcade/views/layouts/iframe_new";

  66.         $hotel = new OperaHotel();

  67.         $hotel->HOTEL_STATUS = 1;

  68.         $dataProvider = $hotel->getHotelist(Yii::$app->request->queryParams);

  69. 

  70.         return $this->render('index', [

  71.             'model' => $hotel,

  72.             'dataProvider' => $dataProvider,

  73.         ]);

  74.     }

  75. 

  76.     /**

  77.      * @Author wanglg

  78.      * @Desc添加酒店

  79.      * @return string|\yii\web\Response

  80.      */

  81.     public function actionAddHotel()

  82.     {

  83.         $hotel = new OperaHotel(['scenario' => 'addHotel']);

  84.         $base_room = new OperaHotelBaseRoom();

  85.         $gift = new OperaHotelGift();

  86.         $star_level = DictType::findAll(['PARENT_ID' => 30]);

  87.         $data['base_room'][] = $base_room;

  88.         $data['hotel'] = $hotel;

  89.         $data['star_level'] = $star_level;

  90.         $data['gift'][] = $gift;

  91. 

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

  93.             $request = Yii::$app->request->post();

  94. 

  95.             // 添加酒店缩略图begin

  96.             @$hotel_thumb_img_url = $_FILES['OperaHotel']['name']['HOTEL_IMAGE'];

  97.             if($hotel_thumb_img_url && $hotel_thumb_img_url != '' && $hotel_thumb_img_url != Yii::$app->params['motorcadeDefaultImage']) {

  98.                 $hotel_imags_arr = UploadedFile::getInstance($hotel, "HOTEL_IMAGE");

  99.                 $hotel_img_path = Yii::$app->basePath . '/web' . Yii::$app->params['hotelImagePath'];

  100.                 $hotel_img_name = OperaHotelBaseRoom::getImgName($hotel_img_path, '.' . $hotel_imags_arr->extension);

  101.                 $hotel_imags_arr->saveAs($hotel_img_path . $hotel_img_name);

  102.                 $hotel_thum = Image::thumbnail($hotel_img_path . $hotel_img_name, 370, 370);

  103.                 $hotel_thum->save($hotel_img_path . 'hotel_thumb_' . $hotel_img_name);

  104.                 $request['OperaHotel']['HOTEL_IMAGE'] = 'http://' . CS1_DOMAIN . Yii::$app->params['hotelImagePath'] . 'hotel_thumb_' . $hotel_img_name;

  105.                 $img_path = $hotel_img_path . 'hotel_thumb_' . $hotel_img_name;

  106.                 UploadPic::cutPic($img_path, $img_path . '.370x326.' . $hotel_imags_arr->extension, '370', '326');//生成官网展示图片 从中间剪切

  107.                 UploadPic::cutPic($img_path, $img_path . '.180x180.' . $hotel_imags_arr->extension, '180', '180');//生成小图 从中间剪切

  108.             }

  109.             // 添加酒店缩略图end

  110. 

  111.             $hotel_lable_str = '';

  112.             if(!empty($request['hotel_label'])) {

  113.                 foreach ($request['hotel_label'] as $h_lable) {

  114.                     // 将标签用 ， 隔开

  115.                     $hotel_lable_str .= $h_lable . ',';

  116.                 }

  117.             }

  118. 

  119.             // 设置酒店标签

  120.             $request['OperaHotel']['HOTEL_LABEL'] = trim($hotel_lable_str, ',');

  121. 

  122.             $sale_lable_str = '';

  123.             if(!empty($request['sale_label'])) {

  124.                 foreach ($request['sale_label'] as $s_lable) {

  125.                     // 将标签用 ， 隔开

  126.                     $sale_lable_str .= $s_lable . ',';

  127.                 }

  128.             }

  129.             //            售卖标签

  130.             $request['OperaHotel']['SALE_LABEL'] = trim($sale_lable_str, ',');

  131. 

  132.             // 处理地区ID 1. 北京 18. 天津 791.上海  2237. 重庆

  133.             if($request['OperaHotel']['province'] == 1 || $request['OperaHotel']['province'] == 18 || $request['OperaHotel']['province'] == 791 || $request['OperaHotel']['province'] == 2237) {

  134.                 $request['OperaHotel']['AREA_ID'] = $request['OperaHotel']['city'];

  135.             } else {

  136.                 $request['OperaHotel']['AREA_ID'] = $request['OperaHotel']['country'];

  137.             }

  138.             unset($request['OperaHotel']['province']);

  139.             unset($request['OperaHotel']['city']);

  140.             unset($request['OperaHotel']['country']);

  141.             $transaction = Yii::$app->db->beginTransaction();

  142.             $request['OperaHotel']['PRINCIPAL'] = Yii::$app->user->id;

  143.             // 插入基础房型

  144.             try {

  145.                 $link_arr = array_values($request['OperaHotelBaseRoom']);

  146.                 if($hotel->load($request['OperaHotel'], '') && $hotel->validate()) {

  147.                     //                    酒店信息保存

  148.                     if(!$hotel->save()) {

  149.                         throw new \Exception();

  150.                     }

  151.                     $opera_hotel_id = $hotel->HOTEL_ID;

  152.                     Yii::$app->session->set('new_hotel_id', $opera_hotel_id);

  153.                 } else {

  154.                     throw new \Exception();

  155.                 }

  156. 

  157.                 // 添加礼盒信息

  158.                 foreach ($request['OperaHotelGift'] as $itme => $value) {

  159.                     $gift_model = empty($value['ID']) ? new OperaHotelGift(): OperaHotelGift::findOne($value['ID']);

  160.                     $value['HOTEL_ID'] = $opera_hotel_id;

  161.                     if($gift_model->load($value, '') && $gift_model->validate()) {

  162.                         if(!$gift_model->save()) {

  163.                             throw new \Exception('保存礼盒信息失败');

  164.                         }

  165.                     }

  166.                 }

  167. 

  168.                 $room_type_all = '';

  169.                 $i = 0;

  170.                 // 添加基础房型

  171.                 foreach ($link_arr as $key => $value) {

  172.                     $i++;

  173.                     $link_arr[$key]['HOTEL_ID'] = $opera_hotel_id;

  174.                     $base_room_list = new OperaHotelBaseRoom();

  175.                     /******************图片上传BEGIN*********************/

  176.                     @$img_url = $_FILES['OperaHotelBaseRoom']['name'][$key]['ROOM_IMG'];

  177.                     if($img_url && $img_url != '' && $img_url != Yii::$app->params['motorcadeDefaultImage']) {

  178.                         $base_room_list->ROOM_IMG = UploadedFile::getInstance($base_room_list, "[$key]ROOM_IMG");

  179.                         $base_path = Yii::$app->basePath . '/web' . Yii::$app->params['hotelImagePath'];

  180.                         $img_name = OperaHotelBaseRoom::getImgName($base_path, '.' . $base_room_list->ROOM_IMG->extension);

  181.                         $base_room_list->ROOM_IMG->saveAs($base_path . $img_name);

  182.                         $thum_image = Image::thumbnail($base_path . $img_name, OperaHotelBaseRoom::ROOM_PIC_WIDTH, OperaHotelBaseRoom::ROOM_PIC_HEIGHT);

  183.                         $thum_image->save($base_path . 'thumb_' . $img_name); // 图片上传

  184.                         // 保存路径至数据库中

  185.                         $base_room_list->ROOM_IMG = 'http://' . CS1_DOMAIN . Yii::$app->params['hotelImagePath'] . 'thumb_' . $img_name;

  186.                     }

  187. 

  188.                     /******************图片上传END*********************/

  189.                     $link_arr[$key]['BED_TYPE'] = implode(',', $value['BED_TYPE']);

  190.                     if(!($base_room_list->load($link_arr[$key], '') && $base_room_list->validate())) {

  191.                         throw new \Exception();

  192.                     }

  193. 

  194.                     // 添加基础房型

  195.                     if(!$base_room_list->save()) {

  196.                         throw new \Exception();

  197.                     }

  198. 

  199.                     $base_room_id = $base_room_list->MAIN_ID;

  200.                     $new_opera_sort = new OperaSort();

  201.                     $opera_sort_arr = array('hotel_id' => $opera_hotel_id, 'base_room_id' => $base_room_id, 'seq' => $i);

  202. 

  203.                     if($new_opera_sort->load($opera_sort_arr, '') && $new_opera_sort->validate()) {

  204.                         if(!$new_opera_sort->save()) {

  205.                             throw new \Exception();

  206.                         }

  207.                     } else {

  208.                         throw new \Exception();

  209.                     }

  210. 

  211.                     $room_type_all .= $base_room_id . ',';

  212.                 }

  213. 

  214.                 $room_type_all = trim($room_type_all, ',');

  215.                 $uhotel = OperaHotel::findOne($opera_hotel_id);

  216.                 $uhotel->ROOM_TYPE_ALL = $room_type_all;

  217.                 $uhotel->ROOM_TYPE_SALE = $room_type_all;

  218.                 if(!$uhotel->update()) {

  219.                     throw new \Exception();

  220.                 }

  221. 

  222.                 $transaction->commit();

  223.                 Yii::$app->session->setFlash('success', "添加成功！");

  224. 

  225.                 return json_encode(array('code' => 0, 'msg' => 'success'));

  226.                 //                return $this -> redirect('/hotel/hotel/index');

  227.             } catch (\Exception $e) {

  228.                 Yii::$app->session->setFlash('error', "添加失败！");

  229.                 $transaction->rollBack();

  230.             }

  231.         }

  232. 

  233.         return $this->render('base', ['view' => 'addHotel', 'data' => $data]);

  234.     }

  235. 

  236.     /**

  237.      * 更新酒店信息

  238.      */

  239.     public function actionUpdateHotel($hotel_id)

  240.     {

  241.         $hotel = OperaHotel::findOne($hotel_id);

  242.         $hotel->setScenario('addHotel');

  243.         $base_room = new OperaHotelBaseRoom();

  244.         $base_rooms = $base_room->getHotelBaseRoom($hotel_id);

  245.         $gift = OperaHotelGift::findAll(['HOTEL_ID' => $hotel_id, 'CANCEL_FLAG' => 0]);

  246.         $hotel_imgs = BaseImg::findAll(['PRODUCT_ID' => $hotel_id, 'IMG_TYPE' => 25, 'CANCEL_FLAG' => 0]);

  247.         $str_hotel_imgs = '';

  248.         foreach ($hotel_imgs as $item => $img) {

  249.             $str_hotel_imgs .= $img['IMG_URL'] . ',';

  250.         }

  251.         $str_hotel_imgs = trim($str_hotel_imgs, ',');

  252.         $paths = empty($hotel->HOTEL_IMAGE) ? ['/resource/img/default-thumbnail.png']: explode('||', $hotel->HOTEL_IMAGE);

  253.         $area_id = $hotel->AREA_ID;

  254.         // 基础房型

  255.         empty($base_rooms) ? $data['base_room'][] = new OperaHotelBaseRoom(): $data['base_room'] = $base_rooms;

  256.         // 礼盒信息

  257.         empty($gift) ? $data['gift'][] = new OperaHotelGift(): $data['gift'] = $gift;

  258.         $data['imgs'] = $paths;

  259.         $data['hotel'] = $hotel;

  260.         $data['json_imgs'] = $str_hotel_imgs;

  261.         $data['op'] = 'modify';

  262. 

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

  264.             $request = Yii::$app->request->post();

  265. 

  266.             @$hotel_thumb_img_url = $_FILES['OperaHotel']['name']['HOTEL_IMAGE'];

  267.             if($hotel_thumb_img_url && $hotel_thumb_img_url != '' && $hotel_thumb_img_url != Yii::$app->params['motorcadeDefaultImage']) // 上传不为空再上传图片

  268.             {

  269.                 $hotel_imags_arr = UploadedFile::getInstance($hotel, "HOTEL_IMAGE");

  270.                 $hotel_img_path = Yii::$app->basePath . '/web' . Yii::$app->params['hotelImagePath'];

  271.                 $hotel_img_name = OperaHotelBaseRoom::getImgName($hotel_img_path, '.' . $hotel_imags_arr->extension);

  272.                 $hotel_imags_arr->saveAs($hotel_img_path . $hotel_img_name);

  273.                 $hotel_thum = Image::thumbnail($hotel_img_path . $hotel_img_name, 370, 370);

  274.                 $hotel_thum->save($hotel_img_path . 'hotel_thumb_' . $hotel_img_name);

  275.                 $request['OperaHotel']['HOTEL_IMAGE'] = 'http://' . CS1_DOMAIN . Yii::$app->params['hotelImagePath'] . 'hotel_thumb_' . $hotel_img_name;

  276.                 $img_path = $hotel_img_path . 'hotel_thumb_' . $hotel_img_name;

  277.                 UploadPic::cutPic($img_path, $img_path . '.370x326.' . $hotel_imags_arr->extension, '370', '326');//生成官网展示图片 从中间剪切

  278.                 UploadPic::cutPic($img_path, $img_path . '.180x180.' . $hotel_imags_arr->extension, '180', '180');//生成小图 从中间剪切

  279.             }

  280. 

  281.             // 设置对象的Area_id

  282.             empty($request['OperaHotel']['country']) ? $request['OperaHotel']['AREA_ID'] = $request['OperaHotel']['city']: $request['OperaHotel']['AREA_ID'] = $request['OperaHotel']['country'];

  283.             $hotel_lable_str = '';

  284.             if(!empty($request['hotel_label'])) {

  285.                 foreach ($request['hotel_label'] as $h_lable) {

  286.                     // 将标签用 ， 隔开

  287.                     $hotel_lable_str .= $h_lable . ',';

  288.                 }

  289.             }

  290. 

  291.             // 设置酒店标签

  292.             $request['OperaHotel']['HOTEL_LABEL'] = trim($hotel_lable_str, ',');

  293. 

  294.             $sale_lable_str = '';

  295.             if(!empty($request['sale_label'])) {

  296.                 foreach ($request['sale_label'] as $s_lable) {

  297.                     // 将标签用 ， 隔开

  298.                     $sale_lable_str .= $s_lable . ',';

  299.                 }

  300.             }

  301.             $request['OperaHotel']['SALE_LABEL'] = trim($sale_lable_str, ',');

  302.             // 经纬度

  303.             unset($request['OperaHotel']['province']);

  304.             unset($request['OperaHotel']['city']);

  305.             unset($request['OperaHotel']['country']);

  306.             $hotel->base_room = $request['OperaHotelBaseRoom'];

  307.             $transaction = Yii::$app->db->beginTransaction();

  308.             try {

  309.                 if($hotel->load($request) && $hotel->validate()) {

  310.                     if(!$hotel->save()) {

  311.                         throw new \Exception('修改酒店失败');

  312.                     }

  313.                 } else {

  314.                     throw new \Exception('修改酒店失败');

  315.                 }

  316. 

  317.                 // 修改、添加礼盒信息

  318.                 foreach ($request['OperaHotelGift'] as $itme => $value) {

  319.                     $gift_model = empty($value['ID']) ? new OperaHotelGift(): OperaHotelGift::findOne($value['ID']);

  320.                     $value['HOTEL_ID'] = $hotel_id;

  321.                     if($gift_model->load($value, '') && $gift_model->validate()) {

  322.                         if(!$gift_model->save()) {

  323.                             throw new \Exception('保存礼盒信息失败');

  324.                         }

  325.                     }

  326.                 }

  327. 

  328.                 // 修改基础房型信息

  329.                 $room_type_all = '';

  330.                 $i = 0;

  331.                 foreach ($request['OperaHotelBaseRoom'] as $key => $value) {

  332.                     $i++;

  333.                     $base_room = (isset($value['MAIN_ID']) && OperaHotelBaseRoom::findOne($value['MAIN_ID']) != null) ? OperaHotelBaseRoom::findOne($value['MAIN_ID']): new OperaHotelBaseRoom();

  334.                     $value['BED_TYPE'] = implode(',', $value['BED_TYPE']);

  335.                     /******************图片上传BEGIN*********************/

  336.                     @$img_url = $_FILES['OperaHotelBaseRoom']['name'][$key]['ROOM_IMG'];

  337.                     if($img_url && $img_url != '' && $img_url != Yii::$app->params['motorcadeDefaultImage']) {

  338.                         $base_room->ROOM_IMG = UploadedFile::getInstance($base_room, "[$key]ROOM_IMG");

  339.                         $base_path = Yii::$app->basePath . '/web' . Yii::$app->params['hotelImagePath'];

  340.                         $img_name = OperaHotelBaseRoom::getImgName($base_path, '.' . $base_room->ROOM_IMG->extension);

  341.                         $base_room->ROOM_IMG->saveAs($base_path . $img_name);

  342.                         $thum_image = Image::thumbnail($base_path . $img_name, OperaHotelBaseRoom::ROOM_PIC_WIDTH, OperaHotelBaseRoom::ROOM_PIC_HEIGHT);

  343.                         $thum_image->save($base_path . 'thumb_' . $img_name); // 图片上传

  344.                         // 保存路径至数据库中

  345.                         $base_room->ROOM_IMG = 'http://' . CS1_DOMAIN . Yii::$app->params['hotelImagePath'] . 'thumb_' . $img_name;

  346.                     }

  347. 

  348.                     /******************图片上传END*********************/

  349.                     $base_room->HOTEL_ID = $hotel_id;

  350.                     $base_room->BASE_ROOM_NAME = $value['BASE_ROOM_NAME'];

  351.                     $rs = $base_room->load($value, '');

  352.                     if($rs && $base_room->validate()) {

  353.                         if(!$base_room->save()) {

  354.                             throw new \Exception('修改基础房型');

  355.                         }

  356.                         // 房型直连修改

  357.                         $room_relation = RoomRelation::findOne(['ChannelId' => Yii::$app->params['ali']['supplier_id'], 'RoomId' => $base_room->MAIN_ID]);

  358.                         if(!empty($room_relation)){

  359.                             Yii::$app->runAction('hotel/ali/room-update', ['params' => ['hotel_id' => $hotel_id, 'parent_room_type'=>$base_room->MAIN_ID]]);

  360.                         }

  361.                     }

  362. 

  363.                     $opera_sort_arr = array('hotel_id' => $hotel_id, 'base_room_id' => $base_room->MAIN_ID, 'seq' => $i);

  364.                     $opera_sort = (isset($base_room['MAIN_ID']) && OperaSort::findOne(['base_room_id' => $base_room['MAIN_ID'], 'hotel_id' => $hotel_id]) != null) ? OperaSort::findOne(['base_room_id' => $base_room['MAIN_ID'], 'hotel_id' => $hotel_id]): new OperaSort();

  365. 

  366.                     if($opera_sort->load($opera_sort_arr, '') && $opera_sort->validate()) {

  367.                         if(!$opera_sort->save()) {

  368.                             throw new \Exception('修改排序');

  369.                         }

  370.                     }

  371. 

  372.                     $room_type_all .= $base_room->MAIN_ID . ',';

  373.                 }

  374. 

  375.                 $room_type_all = trim($room_type_all, ',');

  376. 

  377.                 if($room_type_all != $hotel->ROOM_TYPE_ALL || $room_type_all != $hotel->ROOM_TYPE_SALE) {

  378.                     $hotel->ROOM_TYPE_ALL = $room_type_all;

  379.                     $hotel->ROOM_TYPE_SALE = $room_type_all;

  380.                     if(!$hotel->update()) {

  381.                         throw new \Exception();

  382.                     }

  383.                 }

  384. 

  385.                 $transaction->commit();

  386.                 Yii::$app->session->setFlash('success', "修改成功！");

  387.                 $already_connenct = HotelRelation::findOne(['HotelId' => $hotel_id, 'ChannelId' => Yii::$app->params['ali']['relation_supplier_id']]);

  388.                 if(!empty($already_connenct)) {

  389.                     Yii::$app->runAction('hotel/ali/add-hotel', ['hotel_id' => $hotel_id]);

  390.                 }

  391.                 return json_encode(array('code' => 0, 'msg' => 'success'));

  392.             } catch (\Exception $e) {

  393.                 Yii::$app->session->setFlash('error', "修改失败！");

  394.                 $transaction->rollBack();

  395. 

  396.                 return json_encode(array('code' => 1, 'msg' => 'error', 'hotel_id' => $hotel_id));

  397.             }

  398.         }

  399.         // 根据地区编号判断AREA_LEVE

  400.         $area = BaseAreaView::findOne(['AREA_ID' => $area_id]);

  401. 

  402.         if($area->AREA_LEVEL == 3) {

  403.             $hotel->country = $area_id;

  404.             $parent_area = $area->PARENT_AREA_ID_LIST;

  405.             $parent_area = trim($parent_area, '{}');

  406.             $parent_arr = explode('}{', $parent_area);

  407.             $hotel->province = $parent_arr[0];

  408.             $hotel->city = $parent_arr[1];

  409.         } else {

  410.             $hotel->country = 0;

  411.             $hotel->city = $area_id;

  412.             $parent_area = $area->PARENT_AREA_ID_LIST;

  413.             $parent_area = trim($parent_area, '{}');

  414.             $hotel->province = $parent_area;

  415.         }

  416. 

  417.         return $this->render('base', ['view' => 'addHotel', 'data' => $data, 'op' => 'modify']);

  418.     }

  419. 

  420.     /**

  421.      * @Author wanglg

  422.      * @Desc 酒店大图多图上传

  423.      * @return string

  424.      */

  425.     public function actionUploadeMulity()

  426.     {

  427.         $hotel_id = empty(Yii::$app->request->get('hotel_id')) ? Yii::$app->session->get('new_hotel_id'): Yii::$app->request->get('hotel_id');

  428. 

  429.         if(empty($hotel_id) || empty($_FILES['file'])) {

  430.             return '缺少必要信息';

  431.         }

  432.         // 上传文件之前查询文件是否存在

  433.         $keys = array('name', 'type', 'tmp_name', 'error', 'size');

  434.         $imgSeq = BaseImg::find()->select(['MAX(SEQ_ID) as seq'])->where(['IMG_TYPE' => 25, 'PRODUCT_ID' => $hotel_id])->asArray()->one();

  435.         $files_arr = array();

  436.         for ($i = 0; $i < count($_FILES['file']['name']); $i++) {

  437.             $file = array_column($_FILES['file'], $i);

  438.             $files_arr[$i] = array_combine($keys, $file);

  439.         }

  440. 

  441.         $tran = Yii::$app->db->beginTransaction();

  442.         foreach ($files_arr as $key => $file) {

  443.             $newModel = new BaseImg();

  444.             $name = $file['name']; // 获取文件名称

  445.             $imgType = strtolower(substr(strrchr($name, '.'), 1)); // 获取文件后缀

  446.             $hotel_img_path = Yii::$app->basePath . '/web' . Yii::$app->params['hotelImagePath']; // 图片路径

  447.             $hotel_img_name = OperaHotelBaseRoom::getImgName($hotel_img_path, '.' . $imgType); // 生成文件名称

  448.             $uploadfile = $hotel_img_path . $hotel_img_name; // 组合上传路径

  449.             list($orgWidth, $orgHeight) = getimagesize($file['tmp_name']);

  450.             $typeArr = array("jpg", "png", "gif");

  451.             if(!in_array($imgType, $typeArr)) {

  452.                 return '请检查上传文件格式';

  453.             }

  454. 

  455.             // 图片等比缩放

  456.             $newImg = imagecreatetruecolor(750, 340);

  457. 

  458.             switch ($imgType) {

  459.                 case 'jpg':

  460.                     $img = imagecreatefromjpeg($file['tmp_name']);

  461.                     break;

  462. 

  463.                 case 'png':

  464.                     $img = imagecreatefrompng($file['tmp_name']);

  465.                     break;

  466. 

  467.                 case 'gif':

  468.                     $img = imagecreatefromgif($file['tmp_name']);

  469.                     break;

  470. 

  471.                 default:

  472.                     //                return json_encode(array('code' => 2, 'msg' => '创建图片失败'));

  473.                     return '创建图片失败';

  474.             }

  475. 

  476.             imagecopyresized($newImg, $img, 0, 0, 0, 0, 750, 340, $orgWidth, $orgHeight);

  477.             // 组合创建文件的函数名称

  478.             $createImgFunName = 'image' . (($imgType == 'jpg') ? 'jpeg': $imgType);

  479.             $createImgFunName($newImg, $uploadfile);

  480.             imagedestroy($newImg);

  481.             imagedestroy($img);

  482. 

  483.             $imgSeq['seq']++;

  484.             $insert_arr = array('SEQ_ID' => $imgSeq['seq'], 'IMG_TYPE' => 25, 'PRODUCT_ID' => $hotel_id, 'IMG_URL' => 'http://' . CS1_DOMAIN . Yii::$app->params['hotelImagePath'] . $hotel_img_name, 'IMG_NAME' => $name);

  485.             // 保存数据再base_img表中

  486.             if($newModel->load($insert_arr, '') && $newModel->validate()) {

  487.                 if(!$newModel->save()) {

  488.                     $tran->rollBack();

  489. 

  490.                     return '上传失败';

  491.                 }

  492.             }

  493.         }

  494. 

  495.         // 记录操作日志信息

  496.         $log_model = new OperaHotelLog();

  497.         $log_model->LOG_TYPE = 1;

  498.         $log_model->HOTEL_ID = $hotel_id;

  499.         $log_model->LOG_DESC = '图片上传：上传图片数量' . count($files_arr);

  500.         $log_model->save();

  501.         $tran->commit();

  502. 

  503.         return '上传成功';

  504.     }

  505. 

  506.     /**

  507.      * @Author wanglg

  508.      * @Desc 酒店图片删除（多图上传）

  509.      * @return bool|string

  510.      */

  511. 

  512.     public function actionDelHotelImg()

  513.     {

  514.         $request = Yii::$app->request->post();

  515.         $model = BaseImg::findOne(['IMG_URL' => $request['src'], 'PRODUCT_ID' => $request['hotel_id'], 'CANCEL_FLAG' => 0, 'IMG_TYPE' => 25]);

  516.         if(!empty($model)) {

  517.             $model->CANCEL_FLAG = 1;

  518.             if(!$model->save()) {

  519.                 return false;

  520.             }

  521.         }

  522.         $name = pathinfo($request['src'])['basename'];

  523.         $path = Yii::$app->basePath . '/web' . Yii::$app->params['hotelImagePath'] . $name;

  524.         unlink($path);

  525.         $log_model = new OperaHotelLog();

  526.         $log_model->LOG_TYPE = 1;

  527.         $log_model->HOTEL_ID = $request['hotel_id'];

  528.         $log_model->LOG_DESC = '删除图片：图片路径：' . $request['src'];

  529.         $log_model->save();

  530. 

  531.         return true;

  532.     }

  533. 

  534.     /**

  535.      * User:Steven

  536.      * Desc:发送消息到企业微信

  537.      * @return bool

  538.      */

  539.     public function actionSendMsg()

  540.     {

  541.         $data = file_get_contents("php://input");

  542.         $arr = json_decode($data, true);

  543.         zOfficeWechat::sendMsg($arr);

  544. 

  545.         return true;

  546.     }

  547. 

  548.     // 省市联动

  549.     public function actionProvincecity()

  550.     {

  551.         $area_id = $area_id = isset($_REQUEST['area_id']) ? $_REQUEST['area_id']: "0";        //默认为0

  552.         if(empty($area_id)) {

  553.             $area_id = "0";

  554.         }

  555.         $obj = new Report();

  556.         $data = $obj->getProvinceCity($area_id);

  557.         echo json_encode($data);

  558.     }

  559. 

  560.     public function beforeAction($action)

  561.     {

  562.         $obj = new Report();

  563.         $supp = $obj->getSuppList();

  564.         $sale = $obj->getSaleList();

  565.         $hotel = $obj->getHotelList();

  566.         $this->view->params['supp'] = $supp;

  567.         array_unshift($sale, ['id' => '0', 'sale_org_name' => '请选择']);

  568.         $this->view->params['sale'] = $sale;

  569.         array_unshift($hotel, ['hotel_id' => '0', 'hotel_name' => '请选择']);

  570.         $this->view->params['hotel'] = $hotel;

  571. 

  572.         return parent::beforeAction($action);

  573.     }

  574. 

  575.     /**

  576.      * User:Steven

  577.      * Desc: 酒店价格预警   渠道的分销价（零售价）低于酒店的结算价时进行报警提醒酒店的运营负责人

  578.      */

  579.     public function actionPriceWarning()

  580.     {

  581.         $query = OperaHotel::find()

  582.             ->innerJoinWith("hotelRelation b", false)

  583.             ->leftJoin('base_user c', 'a.PRINCIPAL=c.ID')

  584.             ->from('opera_hotel a')->where(['a.CANCEL_FLAG' => 0, 'a.HOTEL_STATUS' => 1]);

  585.         $query->select(['a.HOTEL_ID', 'a.HOTEL_NAME', 'a.SUPPLIER_ID', 'a.ROOM_TYPE_SALE', 'a.PRINCIPAL', 'c.USER_NAME']);

  586.         $res = $query->asArray()->all();

  587.         foreach ($res as $val) {

  588.             $rs = array();

  589.             $base_room_arr = explode(',', $val['ROOM_TYPE_SALE']);

  590.             foreach ($base_room_arr as $base_room) {

  591.                 //先查询当前酒店当前房型的所有子房型

  592.                 $sub_room = OperaHotelRoom::find()->innerJoinWith('roomRelation b')->from('opera_hotel_room a')

  593.                     ->where(['a.HOTEL_ID' => $val['HOTEL_ID'], 'a.PARENT_ROOM_TYPE' => $base_room, 'b.ChannelId' => Yii::$app->params['ctrip']['relation_supplier_id'], 'a.CANCEL_FLAG' => 0]);

  594.                 $sub_room->select(['a.ROOM_TYPE', 'a.ROOM_NAME', 'a.INNER_IDENTIFY']);

  595.                 $sub_room = $sub_room->asArray()->all();

  596. 

  597.                 foreach ($sub_room as $s_r) {

  598.                     $run_hotel_sub_room = RunHotelSubRoom::find()->joinWith('operaHotelRoom b')->from('run_hotel_sub_room a')

  599.                         ->where(['a.HOTEL_ID' => $val['HOTEL_ID'], 'a.BASE_ROOM_TYPE' => $base_room, 'a.ROOM_TYPE' => $s_r['ROOM_TYPE'], 'a.IS_ONSALE' => 1]);

  600.                     $run_hotel_sub_room->select(['a.HOTEL_ID', 'a.BASE_ROOM_TYPE', 'a.ROOM_TYPE', 'a.RUN_DATE', 'a.BASE_PRICE_BUYOUT', 'a.BASE_PRICE_RESERVE',

  601.                         'a.BASE_PRICE_INQUIRY', 'b.ROOM_NAME', 'b.INNER_IDENTIFY', 'a.IS_ONSALE', 'a.RUN_STATUS']);

  602.                     $run_hotel_sub_room->andFilterWhere([

  603.                         'between', 'RUN_DATE', date('Y-m-d', time()), date('Y-m-d', strtotime("+30 days")),

  604.                     ]);

  605.                     $rs[] = $run_hotel_sub_room->asArray()->all();

  606.                 }

  607.             }

  608.             foreach ($rs as $value) {

  609.                 $date_str = '';

  610.                 $room_name = '';

  611.                 $res_dis = '';

  612.                 foreach ($value as $item) {

  613.                     //获取该房型下渠道为携程某段日期的房态、房量等信息

  614.                     $room_name = $item['ROOM_NAME'] . $item['INNER_IDENTIFY'];

  615.                     $run_hotel_distrib = RunHotelDistrib::find()

  616.                         ->joinWith('baseSupplier b')->joinWith('baseSupplierSale c')

  617.                         ->leftJoin('opera_room_distrib d', 'd.DISTRIB_ID=a.DISTRIB_ID and d.ROOM_ID=' . $item['operaHotelRoom']['ID'])

  618.                         ->from('run_hotel_distrib a')

  619.                         ->where(['a.HOTEL_ID' => $item['HOTEL_ID'], 'a.BASE_ROOM_TYPE' => $item['BASE_ROOM_TYPE'], 'a.ROOM_TYPE' => $item['ROOM_TYPE'], 'a.RUN_DATE' => $item['RUN_DATE'], 'c.PARENT_TYPE' => 25, 'a.DISTRIB_ID' => Yii::$app->params['ctrip']['supplier_id']]);

  620.                     $run_hotel_distrib->select(['a.DISTRIB_ID', 'a.PROD_PRICE', 'a.CUS_PRICE', 'c.SALE_TYPE', 'b.SUPPLIER_NAME', 'a.RUN_STATUS', 'd.AUTHORITY_STATUS']);

  621.                     $res_dis = $run_hotel_distrib->asArray()->all();

  622.                     $price = $item['BASE_PRICE_BUYOUT'] > 0 ? $item['BASE_PRICE_BUYOUT']: ($item['BASE_PRICE_RESERVE'] > 0 ? $item['BASE_PRICE_RESERVE']: ($item['BASE_PRICE_INQUIRY'] > 0 ? $item['BASE_PRICE_INQUIRY']: 0));

  623. 

  624.                     //（分销177、直营312、代理277）

  625.                     $distribe_price = $res_dis[0]['SALE_TYPE'] == 177 ? $res_dis[0]['PROD_PRICE']: $res_dis[0]['CUS_PRICE'];

  626.                     if($item['IS_ONSALE'] == 1 && $item['RUN_STATUS'] == 1 && $res_dis[0]['RUN_STATUS'] != 329 && $res_dis[0]['AUTHORITY_STATUS'] == 1 && $distribe_price != '' && $price > $distribe_price + 0.1) {

  627.                         //检查是否直连

  628.                         $user = $val['USER_NAME'];

  629.                         $date_str .= $item['RUN_DATE'] . "【$distribe_price" . "/" . $price . "】\n";

  630. 

  631.                     }

  632.                 }

  633.                 if($date_str != '') {

  634.                     $msg = '酒店名称：' . $val['HOTEL_NAME'] . "\n房型名称：" . $room_name . "\n渠道商名称：" . $res_dis[0]['SUPPLIER_NAME'] . "\n异常日期：日期(渠道结算/酒店结算)\n" . $date_str . "\n原因：渠道分销价（或零售价）小于酒店结算价";

  635.                     $arr = array(

  636.                         "agentid" => 1000002,

  637.                         "title" => '酒店价格预警：',

  638.                         "msg" => $msg,

  639.                         "touser" => $user,

  640.                     );

  641.                     zOfficeWechat::sendMsg($arr);

  642.                 }

  643.             }

  644. 

  645.         }

  646.     }

  647. 

  648.     /**

  649.      * User:Steven

  650.      * Desc:（携程直连）添加需要特殊处理的订单

  651.      */

  652.     public function actionAddExceptionOrder()

  653.     {

  654.         $exception_order = new OrderHtExceptionList();

  655.         $exception_order->status = 1;

  656.         if($exception_order->load(Yii::$app->request->post())) {

  657.             $transaction = Yii::$app->db->beginTransaction();

  658.             try {

  659.                 if(!$exception_order->save()) {

  660.                     throw new \Exception();

  661.                 }

  662.                 $transaction->commit();

  663. 

  664.                 return "<script>alert('添加成功！')</script>";

  665.             } catch (\Exception $e) {

  666.                 $transaction->rollBack();

  667. 

  668.                 return "<script>alert('添加失败！')</script>";

  669.             }

  670.         }

  671.         $data['exceptionOrder'] = $exception_order;

  672. 

  673.         return $this->render('base', ['view' => 'addExceptionOrder', 'data' => $data]);

  674.     }

  675. 

  676.     /**

  677.      * User:Steven

  678.      * Desc:(携程直连)我们系统下单失败，但是不希望客人改订，需要在新订失败后返回状态码为1（待确认）

  679.      */

  680.     public function actionUpdateOrderLost()

  681.     {

  682.         $flag = false;

  683.         $orderChannelInfo = new OrderChannelInfo(['scenario' => 'error_order']);

  684.         if(Yii::$app->request->post()) {

  685.             $param = Yii::$app->request->post('OrderChannelInfo');

  686.             $outside_order_id = trim($param['channel_order_id']);

  687.             $order_id = trim($param['ORDER_ID']);

  688.             $effect_count = OrderChannelInfo::updateAll([

  689.                 'ORDER_ID' => $order_id,

  690.             ], "CANCEL_FLAG=0 and channel_order_id=$outside_order_id");

  691.             OrderMain::updateAll([

  692.                 'DOCKING_TYPE' => 556,

  693.                 'CHANNEL_ORDER_STATUS' => 550,

  694.             ], "ORDER_ID=$order_id or PARENT_ORDER_ID=$order_id");

  695.             $flag = true;

  696.         }

  697. 

  698.         $data['orderChannelInfo'] = $orderChannelInfo;

  699.         $data['flag'] = $flag;

  700. 

  701.         return $this->render('base', ['view' => 'updateOrderLost', 'data' => $data]);

  702.     }

  703. 

  704.     /**

  705.      * User:Steven

  706.      * Desc:部分酒店基础房型库存预警

  707.      *

  708.      */

  709.     public function actionRoomCountWarning()

  710.     {

  711.         $run_hotel = new RunHotel();

  712.         $room_arr = array(

  713.             9797,//上海花园饭店  高级房

  714.             150077,//上海花园饭店  豪华房

  715.             /*     100324,//舟山希尔顿  海景房

  716.                  150024, //舟山希尔顿 湖景房*/ //合并房型已拆分

  717.             100074,//舟山希尔顿 豪华湖景大床房

  718.             100075, //舟山希尔顿  豪华湖景双床房

  719.             150101,//昆山皇冠假日酒店  皇冠高级房

  720.             150152,//昆山皇冠假日酒店  皇冠豪华房

  721.             150088,//浦西万怡  豪华房

  722.             9752,    //舟山希尔顿  湖景双床房

  723.             100073,//舟山希尔顿 湖景大床房

  724.             150139,//舟山希尔顿 海景大床房

  725.             150140,//舟山希尔顿 海景双床房

  726.             9931,//上海虹桥元一希尔顿酒店  希尔顿客房(双床)(双早）

  727.             150468,//千岛湖滨江希尔顿度假酒店     希尔顿客房大床

  728.             150469,//千岛湖滨江希尔顿度假酒店     希尔顿客房双床

  729. 

  730.         );

  731.         foreach ($room_arr as $base_room_id) {

  732.             $res = $run_hotel->getRunHotelCount($base_room_id);

  733.             $date_str = '';

  734.             foreach ($res as $item) {

  735.                 if($item['buyout'] < 5) {

  736.                     $date_str .= $item['run_date'] . "【买断余量：" . $item['buyout'] . "】\n";

  737.                 }

  738.             }

  739.             $user = $item['USER_NAME'];

  740.             if($date_str != '') {

  741.                 $msg = '酒店名称：' . $item['hotel_name'] . "\n基础房型名称：" . $item['base_room_name'] . "\n" . $date_str . "\n原因：该房型基础房型买断库存数量小于5，请及时关注。";

  742.                 $arr = array(

  743.                     "agentid" => 1000002,

  744.                     "title" => '酒店基础房型买断库存预警：',

  745.                     "msg" => $msg,

  746.                     "touser" => $user,

  747.                 );

  748.                 zOfficeWechat::sendMsg($arr);

  749.             }

  750.         }

  751.     }

  752. 

  753.     /**

  754.      * User:Steven

  755.      * Desc:(徐安)上海花园饭店 合并房型及拆分房型已售数量统计

  756.      * @return string

  757.      */

  758.     public function actionRoomSaledCount()

  759.     {

  760.         $runHotel = new RunHotel();

  761.         $res = $runHotel->getRoomSaledCount();

  762. 

  763.         return $this->render('base', ['view' => 'roomSaledCount', 'data' => $res]);

  764.     }

  765. 

  766.     /**

  767.      * User:Steven

  768.      * Desc:按发单维度订单数据统计  需要按照发单人统计订单，服务于客服的绩效分析

  769.      */

  770.     public function actionGetTemOrder()

  771.     {

  772.         $order_main = new OrderMain();

  773.         $res = $order_main->getTemOrder();

  774. 

  775.         return $this->render('base', ['view' => 'temOrderAnalysis', 'data' => $res]);

  776.     }

  777. 

  778. 

  779.     /**

  780.      * User:Steven

  781.      * Desc:酒店房型排序

  782.      * @return string

  783.      */

  784.     public function actionHotelRoomOrder()

  785.     {

  786.         $operaSort = new OperaSort();

  787.         $hotel_list = $operaSort->getDirectHotel();

  788.         if(Yii::$app->request->isPost || Yii::$app->request->isGet) {

  789.             $HOTEL_ID = is_null(Yii::$app->request->post('HOTEL_ID')) ? Yii::$app->request->get('HOTEL_ID'): Yii::$app->request->post('HOTEL_ID');

  790.         }

  791.         is_null($HOTEL_ID) ? $HOTEL_ID = $hotel_list[0]['HOTEL_ID']: $HOTEL_ID;

  792.         $baseRoomData = $operaSort->getBaseRoomData($HOTEL_ID);

  793.         $roomData = $operaSort->getRoomData($HOTEL_ID);

  794.         foreach ($baseRoomData as $item) {

  795.             $arr[$item['parent_room_type']] = array(

  796.                 'hotel_id' => $item['hotel_id'],

  797.                 'parent_room_name' => $item['base_room_name'],

  798.                 'seq' => $item['seq'],

  799.             );

  800.         }

  801.         foreach ($roomData as $value) {

  802.             $arr[$value['parent_room_type']]['list'][$value['room_type']] = array(

  803.                 'room_name' => $value['room_name'],

  804.                 'inner_identify' => $value['inner_identify'],

  805.                 'seq' => $value['seq'],

  806.             );

  807.         }

  808.         $data['roomData'] = $arr;

  809.         $data['hotel_list'] = $hotel_list;

  810. 

  811.         return $this->render('base', ['view' => 'hotelRoomOrder', 'data' => $data]);

  812.     }

  813. 

  814.     /**

  815.      * 更新房型顺序

  816.      */

  817.     public function actionUpdateRoomOrder()

  818.     {

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

  820.             $request = Yii::$app->request->post();

  821.             if($request['type'] == 1) {//修改基础房型

  822.                 OperaSort::updateAll(['seq' => $request['seq']],

  823.                     ['hotel_id' => $request['hotel_id'], 'base_room_id' => $request['parent_roon_type'], 'room_id' => 0, 'channel_id' => 0]);

  824.             } elseif($request['type'] == 2) {  //修改子房型

  825.                 OperaSort::updateAll(['seq' => $request['seq']],

  826.                     ['hotel_id' => $request['hotel_id'], 'base_room_id' => $request['parent_roon_type'], 'room_id' => $request['room_type'], 'channel_id' => 0]);

  827.             }

  828.         }

  829. 

  830.     }

  831. 

  832.     /**

  833.      * 生成房型排序

  834.      * @return bool

  835.      */

  836.     /*public function actionCreate()

  837.     {

  838.        $res = OperaHotelBaseRoom::find()->select(['HOTEL_ID', 'MAIN_ID'])->where([])->orderBy(['HOTEL_ID' => SORT_ASC, 'MAIN_ID' => SORT_DESC])->asArray()->all();

  839.         foreach ($res as $item) {

  840.             $arr[$item['HOTEL_ID']][] = $item['MAIN_ID'];

  841.         }

  842.         foreach ($arr as $key => $val) {

  843.             $i = 0;

  844.             foreach ($val as $v) {

  845.                 $i++;

  846.                 $model = new OperaSort();

  847.                 $model->base_room_id = $v;

  848.                 $model->channel_id = 0;

  849.                 $model->hotel_id = $key;

  850.                 $model->room_id = 0;

  851.                 $model->seq = $i;

  852.                 $rs=$model->save();

  853.             }

  854.         }

  855. 

  856.         $res = OperaHotelRoom::find()->select(['HOTEL_ID', 'PARENT_ROOM_TYPE', 'ROOM_TYPE'])

  857.             ->orderBy(['HOTEL_ID' => SORT_ASC, 'PARENT_ROOM_TYPE' => SORT_ASC, 'ROOM_TYPE' => SORT_ASC])

  858.             ->asArray()->all();

  859.         foreach ($res as $item) {

  860.             $arr[$item['HOTEL_ID']][$item['PARENT_ROOM_TYPE']][] = $item['ROOM_TYPE'];

  861.         }

  862. 

  863.         foreach ($arr as $key => $value) {

  864.             foreach ($value as $k => $v) {

  865.                 $i = 0;

  866.                 foreach ($v as  $v1) {

  867.                     $i++;

  868.                     $model = new OperaSort();

  869.                     $model->base_room_id = $k;

  870.                     $model->channel_id = 0;

  871.                     $model->hotel_id = $key;

  872.                     $model->room_id = $v1;

  873.                     $model->seq = $i;

  874.                     $rs = $model->save();

  875.                 }

  876. 

  877.             }

  878.         }

  879.         return true;

  880.     }*/

  881. 

  882.     /**

  883.      * User: wanglg

  884.      *

  885.      * 前端选择省市联动返回数据

  886.      *

  887.      * @params integer $pid  父ID

  888.      *

  889.      * @return mixed

  890.      */

  891.     public function actionAreaView()

  892.     {

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

  894.             $baseArea = BaseAreaView::getBaseArea(Yii::$app->request->post('pid'));

  895. 

  896.             return Json::encode($baseArea);

  897.         } else {

  898.             throw new NotFoundHttpException('页面未找到！');

  899.         }

  900.     }

  901. 

  902.     public function action_province()

  903.     {

  904.         $id = $_REQUEST['id'];

  905.         $baseArea = BaseAreaView::findOne(['AREA_ID' => $id]);

  906.         $model = new OperaHotel();

  907.         if($baseArea != null) {

  908.             //选择省

  909.             if($baseArea->PARENT_AREA_ID == 0) {

  910.                 $pid['id1'] = 0;

  911.                 $pid['id2'] = $id;

  912.                 $tmp = BaseAreaView::findOne(['PARENT_AREA_ID' => $id]);

  913.                 if($tmp != null) {

  914.                     $pid['id3'] = $tmp->AREA_ID;

  915.                 } else {

  916.                     $pid['id3'] = '';

  917.                 }

  918.                 $model->province = $id;

  919.             }

  920.             //选择市

  921.             if($baseArea->PARENT_AREA_ID != 0 && $baseArea->AREA_LEVEL == 2) {

  922.                 $pid['id1'] = 0;

  923.                 $pid['id2'] = $baseArea->PARENT_AREA_ID;

  924.                 $pid['id3'] = $baseArea->AREA_ID;

  925.                 $model->province = $baseArea->PARENT_AREA_ID;

  926.                 $model->city = $id;

  927.             }

  928.         }

  929. 

  930.         return $this->renderPartial('_province', ['model' => $model, 'pid' => $pid]);

  931.     }

  932. 

  933.     /**

  934.      * Author:Steven

  935.      * Desc:获取酒店内存中的数据

  936.      */

  937.     public function actionGetMem()

  938.     {

  939.         $this->layout = "@backend/modules/motorcade/views/layouts/iframe_new";

  940.         $cache = Yii::$app->cacheCS;

  941.         $cache->encrypt = false;

  942.         $newOrder = $cache->get('hotel_newOrder');

  943. 

  944.         return $this->render('base', ['view' => 'hotelMemData', 'data' => $newOrder]);

  945.     }

  946. 

  947.     /**

  948.      * @Author wanglg

  949.      * @Desc 比较内存中的订单状态与数据库订单状态是否一致，不一致手动清除缓存中的订单

  950.      * @return string

  951.      */

  952.     public function actionDiffOrder()

  953.     {

  954.         $cache = Yii::$app->cacheCS;

  955.         $cache->encrypt = false;

  956.         $newOrder = $cache->get('hotel_newOrder');

  957.         $order_arr = array();

  958.         foreach ($newOrder as $key => $supplier) {

  959.             foreach ($supplier as $order) {

  960.                 if($order['order_id'] == '1942584' || $order['order_id'] == '1914846') {

  961.                     continue;

  962.                 }

  963.                 $order_id = $order['order_id'];

  964.                 $status = $order['type'];

  965.                 $order_info = OrderMain::findOne(['CANCEL_FLAG' => 0, 'ORDER_PROD_TYPE' => 25, 'ORDER_ID' => $order_id]);

  966.                 if($status != $order_info->ORDER_STATUS && !empty($order_info)) {

  967.                     $order_arr[] = $order_id;

  968.                 }

  969.             }

  970.         }

  971. 

  972.         if(!empty($order_arr)) {

  973.             $orders = implode(',', $order_arr);

  974.             zOfficeWechat::sendMsg([

  975.                 'agentid' => zOfficeWechat::SEND_HOTEL,

  976.                 "title" => '【缓存订单状态不一致通知】检查缓存订单：',

  977.                 "msg" => "订单列表：\n" . $orders,

  978.                 "touser" => 'wanglg',]);

  979. 

  980.             return 1;

  981.         }

  982. 

  983.         return false;

  984.     }

  985. 

  986.     /**

  987.      * Author:Steven

  988.      * Desc:移除内存中个别订单

  989.      * @param $order_id

  990.      * @return string

  991.      */

  992.     public function actionRemoveMem($order_id)

  993.     {

  994.         OrderMain::resetMemcache($order_id);

  995. 

  996.         return \GuzzleHttp\json_encode(['code' => 0]);

  997.     }

  998. 

  999.     public function actionSetOrderSupp($id)

  1000.     {

  1001.         $cache = Yii::$app->cacheCS;

  1002.         $cache->encrypt = false;

  1003.         $newOrder = $cache->get('hotel_newOrder');

  1004.         $order_arr = array();

  1005.         foreach ($newOrder as $key => $supplier) {

  1006.             $tmp[$id] = $supplier;

  1007.             $cache->set('hotel_newOrder', $tmp, 0, 0);

  1008.         }

  1009. 

  1010. 

  1011.     }

  1012. }

  1013. 

  1014. ?>