ShopController.php 27 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776
  1. <?php
  2. /**
  3. * Created by PhpStorm.
  4. * User: leo
  5. * Date: 2018/2/24
  6. * Time: 下午12:48
  7. */
  8. namespace backendApi\modules\v1\controllers;
  9. use backendApi\modules\v1\models\exportForms\OrderExportForm;
  10. use backendApi\modules\v1\models\exportForms\ShopExportForm;
  11. use backendApi\modules\v1\models\lists\shop\DecOrderList;
  12. use backendApi\modules\v1\models\lists\shop\GoodsList;
  13. use backendApi\modules\v1\models\lists\shop\OrderDecList;
  14. use backendApi\modules\v1\models\lists\shop\OrderList;
  15. use backendApi\modules\v1\models\lists\shop\OrderPeriodAdjustList;
  16. use backendApi\modules\v1\models\lists\shop\OrderShopList;
  17. use backendApi\modules\v1\models\lists\shop\OrderStandardList;
  18. use backendApi\modules\v1\models\lists\shop\PackageList;
  19. use common\helpers\bonus\CalcCache;
  20. use backendApi\modules\v1\models\lists\shop\RemainPvList;
  21. use backendApi\modules\v1\models\lists\shop\FlowRemainPvList;
  22. use common\helpers\Cache;
  23. use common\helpers\Date;
  24. use common\helpers\Form;
  25. use common\helpers\Log;
  26. use common\helpers\snowflake\SnowFake;
  27. use common\libs\export\module\ShopExport;
  28. use common\models\DeclarationPackage;
  29. use common\models\DecOrder;
  30. use common\models\ExcelOrderShop;
  31. use common\models\forms\DecPackageForm;
  32. use common\models\forms\ExcelOrderDecForm;
  33. use common\models\forms\ExcelOrderShopForm;
  34. use common\models\forms\ExcelOrderStandardForm;
  35. use common\models\forms\OrderDeleteForm;
  36. use common\models\forms\OrderForm;
  37. use common\models\forms\OrderPeriodAdjustForm;
  38. use common\models\forms\ShopGoodsForm;
  39. use common\models\forms\UploadForm;
  40. use common\models\Order;
  41. use common\models\Period;
  42. use common\models\ShopGoods;
  43. use yii\web\UploadedFile;
  44. use yii\base\Exception;
  45. class ShopController extends BaseController {
  46. public $modelClass = DecOrder::class;
  47. public function behaviors() {
  48. $behaviors = parent::behaviors();
  49. //$behaviors['contentNegotiator']['formats']['text/html'] = Response::FORMAT_JSON;
  50. return $behaviors;
  51. }
  52. /**
  53. * 商品列表
  54. * @return mixed
  55. * @throws Exception
  56. * @throws \yii\web\HttpException
  57. */
  58. public function actionIndex() {
  59. $filter = $this->filterCondition([
  60. 'TYPE'=> 'TYPE',
  61. 'GIFT_TYPE'=> 'GIFT_TYPE',
  62. 'STATUS'=> 'STATUS',
  63. 'GOODS_NAME'=> 'GOODS_NAME',
  64. 'GOODS_NO'=> 'GOODS_NO',
  65. 'SELL_TYPE'=> 'SELL_TYPE',
  66. 'SELL_PRICE'=> 'SELL_PRICE',
  67. 'PRICE_PV'=> 'PRICE_PV',
  68. ]);
  69. $condition = $filter['condition'];
  70. $params = $filter['params'];
  71. $condition .= ' ';
  72. $listObj = new GoodsList();
  73. $data = $listObj->getList(['condition'=>$condition, 'params'=>$params]);
  74. return static::notice($data);
  75. }
  76. /**
  77. * 商品列表导出
  78. * @return mixed
  79. * @throws \yii\db\Exception
  80. * @throws \yii\web\HttpException
  81. */
  82. public function actionGoodsListExport()
  83. {
  84. $filter = $this->filterCondition([
  85. 'TYPE'=> 'TYPE',
  86. 'GIFT_TYPE'=> 'GIFT_TYPE',
  87. 'STATUS'=> 'STATUS',
  88. 'GOODS_NAME'=> 'GOODS_NAME',
  89. 'GOODS_NO'=> 'GOODS_NO',
  90. 'SELL_TYPE'=> 'SELL_TYPE',
  91. 'SELL_PRICE'=> 'SELL_PRICE',
  92. 'PRICE_PV'=> 'PRICE_PV',
  93. ]);
  94. $form = new ShopExportForm();
  95. $result = $form->run($filter, '商品列表');
  96. if (!$result) {
  97. return static::notice(Form::formatErrorsForApi($form->getErrors()), 400);
  98. }
  99. return static::notice('导出开始,请到文件管理-导出文件查看');
  100. }
  101. /**
  102. * 添加商品
  103. * @return mixed
  104. * @throws Exception
  105. * @throws \yii\web\HttpException
  106. */
  107. public function actionGoodsAdd() {
  108. if (\Yii::$app->request->isPost) {
  109. $formModel = new ShopGoodsForm();
  110. $formModel->scenario = 'add';
  111. if ($formModel->load(\Yii::$app->request->post(), '') && $result = $formModel->add()) {
  112. return static::notice('商品添加成功');
  113. } else {
  114. return static::notice(Form::formatErrorsForApi($formModel->getErrors()),400);
  115. }
  116. }
  117. return static::notice(['sellType' => ShopGoods::SALE_TYPE, 'goodsType' => ShopGoods::GOODS_TYPE, 'giftType' => ShopGoods::GIFT_TYPE]);
  118. }
  119. /**
  120. * 编辑商品
  121. * @return mixed
  122. * @throws Exception
  123. * @throws \yii\web\HttpException
  124. */
  125. public function actionGoodsEdit() {
  126. $id = \Yii::$app->request->get('id');
  127. if (\Yii::$app->request->isPost) {
  128. $formModel = new ShopGoodsForm();
  129. $formModel->scenario = 'edit';
  130. $formModel->id = $id;
  131. if ($formModel->load(\Yii::$app->request->post(), '') && $result = $formModel->edit()) {
  132. return static::notice('商品编辑成功');
  133. } else {
  134. return static::notice(Form::formatErrorsForApi($formModel->getErrors()),400);
  135. }
  136. }
  137. $data = ShopGoods::findOneAsArray('ID=:ID', [':ID' => $id]);
  138. $data['SELL_TYPE'] = explode(',',$data['SELL_TYPE']);
  139. $data['GIFT_TYPE'] = explode(',',$data['GIFT_TYPE']);
  140. return static::notice(['goodsInfo'=>$data,'sellType' => ShopGoods::SALE_TYPE, 'goodsType' => ShopGoods::GOODS_TYPE, 'giftType' => ShopGoods::GIFT_TYPE]);
  141. }
  142. /**
  143. * 上传图片
  144. * @return mixed
  145. * @throws \yii\base\Exception
  146. * @throws \yii\db\Exception
  147. * @throws \yii\web\HttpException
  148. */
  149. public function actionUpload(){
  150. if(\Yii::$app->request->isPost){
  151. $formModel = new UploadForm();
  152. $formModel->scenario = 'goodsImg';
  153. $formModel->file = UploadedFile::getInstanceByName('file');
  154. $formModel->token = \Yii::$app->request->request('uploadToken');
  155. if($formModel->file && $uploader = $formModel->upload()){
  156. return static::notice($uploader->URL);
  157. } else {
  158. return static::notice(Form::formatErrorsForApi($formModel->getErrors()), 400);
  159. }
  160. } else {
  161. $token = Cache::setUploadToken();
  162. return static::notice($token);
  163. }
  164. }
  165. /**
  166. * 商品上下架
  167. * @return mixed
  168. * @throws Exception
  169. */
  170. public function actionGoodsStatus() {
  171. $id = \Yii::$app->request->get('id');
  172. if (\Yii::$app->request->isPost) {
  173. $formModel = new ShopGoodsForm();
  174. $formModel->scenario = 'changeStatus';
  175. if ($formModel->load(\Yii::$app->request->post(), '') && $result = $formModel->changeStatus()) {
  176. // foreach ($result['logs'] as $k => $value) {
  177. // Log::adminHandle('改变商品状态至' . ShopGoods::STATUS_NAME[$result['status']], 1, $k);
  178. // }
  179. return static::notice('状态设置成功');
  180. } else {
  181. return static::notice(Form::formatErrorsForApi($formModel->getErrors()), 400);
  182. }
  183. }
  184. }
  185. /**
  186. * 删除商品
  187. * @return mixed
  188. * @throws \yii\db\Exception
  189. * @throws \yii\web\HttpException
  190. */
  191. public function actionGoodsDelete(){
  192. $result = static::delete(ShopGoods::class);
  193. return $result;
  194. }
  195. /**
  196. * 套餐列表
  197. * @return mixed
  198. * @throws Exception
  199. * @throws \yii\web\HttpException
  200. */
  201. public function actionPackage() {
  202. $filter = $this->filterCondition([
  203. 'LEVEL_NAME'=> 'DP.LEVEL_ID',
  204. 'PACKAGE_NAME'=> 'DP.PACKAGE_NAME',
  205. 'AMOUNT'=> 'DP.AMOUNT',
  206. 'PV'=> 'DP.PV',
  207. 'STATUS'=> 'DP.STATUS',
  208. 'STORE_NUMS'=>'DP.STORE_NUMS',
  209. 'STATUS_DATE'=>'DP.STATUS_DATE',
  210. 'PACKAGE_DATE'=>'DP.PACKAGE_DATE',
  211. 'PACKAGE_STATUS_DATE'=>'DP.PACKAGE_STATUS_DATE'
  212. ]);
  213. $condition = $filter['condition'];
  214. $params = $filter['params'];
  215. $condition .= ' AND DP.IS_DEL=0';
  216. $listObj = new PackageList();
  217. $data = $listObj->getList(['condition'=>$condition, 'params'=>$params]);
  218. return static::notice($data);
  219. }
  220. /**
  221. * 添加报单套餐
  222. * @return mixed
  223. * @throws \yii\web\HttpException
  224. */
  225. public function actionPackageAdd() {
  226. if (\Yii::$app->request->isPost) {
  227. return static::edit(DecPackageForm::class, '报单套餐添加成功', 'add', null, null, function () {
  228. // Log::adminHandle('添加报单套餐', 1);
  229. });
  230. }
  231. return static::notice('非发请求', 405);
  232. }
  233. /**
  234. * 报单套餐获取
  235. * @return mixed
  236. * @throws \yii\web\HttpException
  237. */
  238. public function actionPackageGet() {
  239. $id = \Yii::$app->request->get('id');
  240. if (\Yii::$app->request->isPost) {
  241. return static::edit(DecPackageForm::class, '套餐编辑成功', 'edit', null, null, function () {
  242. // Log::adminHandle('编辑报单套餐', 1);
  243. });
  244. }
  245. $package = DeclarationPackage::findOneAsArray('ID=:ID', [':ID' => $id]);
  246. return static::notice(['id' => $package['ID'], 'packageName' => $package['PACKAGE_NAME'],'packageNo' => $package['PACKAGE_NO'], 'amount' => $package['AMOUNT'], 'amountPv' => $package['PV'], 'levelId' => $package['LEVEL_ID'], 'packageContent' => $package['PACKAGE_CONTENT'],'storenums' => $package['STORE_NUMS'],'statusdate'=>$package['STATUS_DATE'],'packagedate'=>$package['PACKAGE_DATE'],'packagestatusdate'=>$package['PACKAGE_STATUS_DATE'],'sort'=>$package['SORT']]);
  247. }
  248. /**
  249. * 套餐上下架
  250. * @return mixed
  251. * @throws Exception
  252. */
  253. public function actionPackageStatus() {
  254. $id = \Yii::$app->request->get('id');
  255. if (\Yii::$app->request->isPost) {
  256. $formModel = new DecPackageForm();
  257. $formModel->scenario = 'changeStatus';
  258. if ($formModel->load(\Yii::$app->request->post(), '') && $result = $formModel->changeStatus()) {
  259. return static::notice('状态设置成功');
  260. } else {
  261. return static::notice(Form::formatErrorsForApi($formModel->getErrors()), 400);
  262. }
  263. }
  264. }
  265. /**
  266. * 删除套餐
  267. * @return mixed
  268. * @throws \yii\db\Exception
  269. * @throws \yii\web\HttpException
  270. */
  271. public function actionPackageDelete(){
  272. $result = static::delete(DeclarationPackage::class);
  273. return $result;
  274. }
  275. /**
  276. * 报单表
  277. * @return mixed
  278. * @throws Exception
  279. * @throws \yii\web\HttpException
  280. */
  281. public function actionDecOrderList() {
  282. $filter = $this->filterCondition([
  283. 'DEC_SN'=> 'DO.DEC_SN',
  284. 'ORDER_SN'=> 'DO.ORDER_SN',
  285. 'USER_NAME'=> 'U.USER_NAME',
  286. 'TO_USER_NAME'=> 'TU.USER_NAME',
  287. 'REAL_NAME'=> 'TU.REAL_NAME',
  288. 'ID_CARD'=> 'TU.ID_CARD',
  289. 'MOBILE'=> 'TU.MOBILE',
  290. 'DEC_LV_NAME' => 'TU.DEC_LV',
  291. 'DEC_REAL_NAME'=> 'DU.REAL_NAME',
  292. 'DEC_AMOUNT'=> 'DO.DEC_AMOUNT',
  293. 'DEC_PV'=> 'DO.DEC_PV',
  294. 'PERIOD_NUM'=> 'DO.PERIOD_NUM',
  295. 'REC_USER_NAME'=> 'RU.USER_NAME',
  296. 'CREATED_AT'=> 'DO.CREATED_AT',
  297. 'UPDATED_AT'=> 'DO.UPDATED_AT',
  298. ]);
  299. $condition = $filter['condition'];
  300. $params = $filter['params'];
  301. $condition .= ' AND DO.IS_DEL=0';
  302. $listObj = new DecOrderList();
  303. $data = $listObj->getList(['condition'=>$condition, 'params'=>$params]);
  304. return static::notice($data);
  305. }
  306. /**
  307. * 报单表导出
  308. * @return mixed
  309. * @throws \yii\db\Exception
  310. * @throws \yii\web\HttpException
  311. */
  312. public function actionDecOrderListExport()
  313. {
  314. $filter = $this->filterCondition([
  315. 'DEC_SN'=> 'DO.DEC_SN',
  316. 'ORDER_SN'=> 'DO.ORDER_SN',
  317. 'USER_NAME'=> 'U.USER_NAME',
  318. 'TO_USER_NAME'=> 'TU.USER_NAME',
  319. 'DEC_AMOUNT'=> 'DO.DEC_AMOUNT',
  320. 'DEC_PV'=> 'DO.DEC_PV',
  321. 'PERIOD_NUM'=> 'DO.PERIOD_NUM',
  322. 'CREATED_AT'=> 'DO.CREATED_AT',
  323. 'UPDATED_AT'=> 'DO.UPDATED_AT',
  324. ]);
  325. $filter['condition'] .= ' AND DO.IS_DEL=0';
  326. $form = new ShopExportForm();
  327. $result = $form->run($filter, '报单列表');
  328. if (!$result) {
  329. return static::notice(Form::formatErrorsForApi($form->getErrors()), 400);
  330. }
  331. return static::notice('导出开始,请到文件管理-导出文件查看');
  332. }
  333. /**
  334. * 订单表
  335. * @return mixed
  336. * @throws Exception
  337. * @throws \yii\web\HttpException
  338. */
  339. public function actionOrderList() {
  340. $filter = $this->filterCondition([
  341. 'SN'=> 'O.SN',
  342. 'USER_NAME'=> 'U.USER_NAME',
  343. 'MOBILE'=> 'O.MOBILE',
  344. 'PERIOD_NUM'=> 'O.PERIOD_NUM',
  345. 'CREATED_AT'=> 'O.CREATED_AT',
  346. ]);
  347. // $condition = ' 1=1 ' . $filter['condition'];
  348. // $params = $filter['params'];
  349. // $condition .= $condition ? ' AND O.IS_DELETE=0' : ' O.IS_DELETE=0';
  350. $condition = $filter['condition'];
  351. $params = $filter['params'];
  352. $condition .= ' AND O.IS_DELETE=0';
  353. $listObj = new OrderList();
  354. $data = $listObj->getList(['condition'=>$condition, 'params'=>$params]);
  355. return static::notice($data);
  356. }
  357. // 删除订单
  358. public function actionDeleteOrder() {
  359. if (\Yii::$app->request->isPost) {
  360. $formModel = new OrderDeleteForm();
  361. if ($formModel->load(\Yii::$app->request->post(), '') && $result = $formModel->returnOrder()) {
  362. return static::notice('删除订单成功,请重新生成业绩单,计算奖金');
  363. } else {
  364. return static::notice(Form::formatErrorsForApi($formModel->getErrors()), 400);
  365. }
  366. }
  367. }
  368. /**
  369. * 订单表导出
  370. * @return mixed
  371. * @throws \yii\db\Exception
  372. * @throws \yii\web\HttpException
  373. */
  374. public function actionOrderListExport()
  375. {
  376. $filter = $this->filterCondition([
  377. 'SN'=> 'O.SN',
  378. 'USER_NAME'=> 'U.USER_NAME',
  379. 'MOBILE'=> 'O.MOBILE',
  380. 'PERIOD_NUM'=> 'O.PERIOD_NUM',
  381. 'CREATED_AT'=> 'O.CREATED_AT',
  382. ]);
  383. $filter['condition'] = !$filter['condition'] ? '1=1 AND O.IS_DELETE=0' : ('O.IS_DELETE=0 ' . $filter['condition']);
  384. $form = new ShopExportForm();
  385. $result = $form->run($filter, '订单列表');
  386. if (!$result) {
  387. return static::notice(Form::formatErrorsForApi($form->getErrors()), 400);
  388. }
  389. return static::notice('导出开始,请到文件管理-导出文件查看');
  390. }
  391. /**
  392. * 外部商城订单列表
  393. * @return mixed
  394. * @throws Exception
  395. * @throws \yii\web\HttpException
  396. */
  397. public function actionOrderShopList() {
  398. $filter = $this->filterCondition([
  399. 'SN'=> 'O.SN',
  400. 'USER_NAME'=> 'U.USER_NAME',
  401. 'PERIOD_NUM'=> 'O.PERIOD_NUM',
  402. 'CREATED_AT'=> 'O.CREATED_AT',
  403. ]);
  404. $condition = $filter['condition'];
  405. $params = $filter['params'];
  406. $condition .= ' AND O.IS_DELETE=0';
  407. $listObj = new OrderShopList();
  408. $data = $listObj->getList(['condition'=>$condition, 'params'=>$params]);
  409. return static::notice($data);
  410. }
  411. /**
  412. * 外部商城报单列表
  413. * @return mixed
  414. * @throws Exception
  415. * @throws \yii\web\HttpException
  416. */
  417. public function actionOrderDecList() {
  418. $filter = $this->filterCondition([
  419. 'SN'=> 'O.SN',
  420. 'USER_NAME'=> 'U.USER_NAME',
  421. 'PERIOD_NUM'=> 'O.PERIOD_NUM',
  422. 'CREATED_AT'=> 'O.CREATED_AT',
  423. ]);
  424. $condition = $filter['condition'];
  425. $params = $filter['params'];
  426. $condition .= ' AND O.IS_DELETE=0';
  427. $listObj = new OrderDecList();
  428. $data = $listObj->getList(['condition'=>$condition, 'params'=>$params]);
  429. return static::notice($data);
  430. }
  431. /**
  432. * 分页导入excel文件到待导入数据的表中
  433. * @return mixed
  434. */
  435. public function actionImportOrderShopToExcelTable()
  436. {
  437. // 先上传到服务器文件
  438. if (\Yii::$app->request->isPost) {
  439. $excelImportId = \Yii::$app->request->post('excelImportId');
  440. $rowCount = \Yii::$app->request->post('rowCount');
  441. //$periodNum = \Yii::$app->request->post('periodNum');
  442. $orderDay = \Yii::$app->request->post('orderDay');
  443. $orderType = \Yii::$app->request->post('orderType');
  444. $startRow = \Yii::$app->request->post('startRow');
  445. $limit = \Yii::$app->request->post('limit', 1000);
  446. $errorMsg = '';
  447. try {
  448. if( $startRow == 1 ) {
  449. $excelOrderShop = new ExcelOrderShopForm();
  450. $excelOrderShop->checkStatus($orderDay,$orderType);
  451. }
  452. $excel = new \common\helpers\Excel();
  453. $result = $excel->pageImportCustomDataFromExcel('orderShop', $excelImportId, $rowCount, $startRow, $limit,$orderDay,$orderType);
  454. } catch (\Exception $e) {
  455. $result = false;
  456. $errorMsg = $e->getMessage();
  457. }
  458. // 还有数据
  459. if ($result === 1) {
  460. return static::notice(['finish' => false]);
  461. } elseif ($result === 0) {
  462. return static::notice(['finish' => true]);
  463. } else {
  464. return static::notice('发生错误:' . $errorMsg, 400);
  465. }
  466. }
  467. }
  468. /**
  469. * 导入完成标记
  470. * @return mixed
  471. * @throws \yii\web\HttpException
  472. */
  473. public function actionImportOrderShop() {
  474. //$periodNum = \Yii::$app->request->post('periodNum');
  475. $orderDay = \Yii::$app->request->post('orderDay');
  476. $orderType = \Yii::$app->request->post('orderType');
  477. $excelOrderShop = new ExcelOrderShopForm();
  478. $finishStatus = $excelOrderShop->finished($orderDay,$orderType);
  479. if ($finishStatus) {
  480. return static::notice(['finish' => true]);
  481. } else {
  482. return static::notice('状态更新错误', 400);
  483. }
  484. }
  485. /**
  486. * 报单订单——分页导入excel文件到待导入数据的表中
  487. * @return mixed
  488. */
  489. public function actionImportOrderDecToExcelTable()
  490. {
  491. // 先上传到服务器文件
  492. if (\Yii::$app->request->isPost) {
  493. $excelImportId = \Yii::$app->request->post('excelImportId');
  494. $rowCount = \Yii::$app->request->post('rowCount');
  495. //$periodNum = \Yii::$app->request->post('periodNum');
  496. $orderDay = \Yii::$app->request->post('orderDay');
  497. $startRow = \Yii::$app->request->post('startRow');
  498. $limit = \Yii::$app->request->post('limit', 1000);
  499. $errorMsg = '';
  500. try {
  501. if( $startRow == 1 ) {
  502. $excelOrderShop = new ExcelOrderDecForm();
  503. $excelOrderShop->checkStatus($orderDay);
  504. }
  505. $excel = new \common\helpers\Excel();
  506. $result = $excel->pageImportCustomDataFromExcel('orderDec', $excelImportId, $rowCount, $startRow, $limit,$orderDay);
  507. } catch (\Exception $e) {
  508. $result = false;
  509. $errorMsg = $e->getMessage();
  510. }
  511. // 还有数据
  512. if ($result === 1) {
  513. return static::notice(['finish' => false]);
  514. } elseif ($result === 0) {
  515. return static::notice(['finish' => true]);
  516. } else {
  517. return static::notice('发生错误:' . $errorMsg, 400);
  518. }
  519. }
  520. }
  521. /**
  522. * 报单订单导入完成标记
  523. * @return mixed
  524. * @throws \yii\web\HttpException
  525. */
  526. public function actionImportOrderDec() {
  527. //$periodNum = \Yii::$app->request->post('periodNum');
  528. $orderDay = \Yii::$app->request->post('orderDay');
  529. $excelOrderShop = new ExcelOrderDecForm();
  530. $finishStatus = $excelOrderShop->finished($orderDay);
  531. if ($finishStatus) {
  532. return static::notice(['finish' => true]);
  533. } else {
  534. return static::notice('状态更新错误', 400);
  535. }
  536. }
  537. /**
  538. * 见习达标订单列表
  539. * @return mixed
  540. * @throws Exception
  541. * @throws \yii\web\HttpException
  542. */
  543. public function actionOrderStandardList() {
  544. $filter = $this->filterCondition([
  545. 'SN'=> 'O.SN',
  546. 'USER_NAME'=> 'U.USER_NAME',
  547. 'PERIOD_NUM'=> 'O.PERIOD_NUM',
  548. 'CREATED_AT'=> 'O.CREATED_AT',
  549. ]);
  550. $condition = $filter['condition'];
  551. $params = $filter['params'];
  552. $condition .= ' AND O.IS_DELETE=0';
  553. $listObj = new OrderStandardList();
  554. $data = $listObj->getList(['condition'=>$condition, 'params'=>$params]);
  555. return static::notice($data);
  556. }
  557. /**
  558. * 分页导入excel文件到待导入数据的表中
  559. * @return mixed
  560. * @throws \yii\web\HttpException
  561. */
  562. public function actionImportOrderStandardToExcelTable()
  563. {
  564. // 先上传到服务器文件
  565. if (\Yii::$app->request->isPost) {
  566. $excelImportId = \Yii::$app->request->post('excelImportId');
  567. $rowCount = \Yii::$app->request->post('rowCount');
  568. //$periodNum = \Yii::$app->request->post('periodNum');
  569. $orderMonth = \Yii::$app->request->post('orderMonth');
  570. // $orderType = \Yii::$app->request->post('orderType');
  571. $orderType = 'cash';
  572. $startRow = \Yii::$app->request->post('startRow');
  573. $limit = \Yii::$app->request->post('limit', 1000);
  574. $errorMsg = '';
  575. try {
  576. if( $startRow == 1 ) {
  577. //清空已经导入的表数据
  578. $excelOrderStandard = new ExcelOrderStandardForm();
  579. $excelOrderStandard->checkStatus($orderMonth);
  580. }
  581. $excel = new \common\helpers\Excel();
  582. $result = $excel->pageImportCustomDataFromExcel('orderShopStandard', $excelImportId, $rowCount, $startRow, $limit,$orderMonth,$orderType);
  583. } catch (Exception $e) {
  584. $result = false;
  585. $errorMsg = $e->getMessage();
  586. }
  587. // 还有数据
  588. if ($result === 1) {
  589. return static::notice(['finish' => false]);
  590. } elseif ($result === 0) {
  591. return static::notice(['finish' => true]);
  592. } else {
  593. return static::notice('发生错误:' . $errorMsg, 400);
  594. }
  595. }
  596. }
  597. /**
  598. * 达标订单导入完成标记
  599. * @return mixed
  600. * @throws \yii\web\HttpException
  601. */
  602. public function actionImportOrderStandard() {
  603. $orderMonth = \Yii::$app->request->post('orderMonth');
  604. $excelOrderStandard = new ExcelOrderStandardForm();
  605. $finishStatus = $excelOrderStandard->finished($orderMonth);
  606. if ($finishStatus) {
  607. return static::notice(['finish' => true]);
  608. } else {
  609. return static::notice('状态更新错误', 400);
  610. }
  611. }
  612. /**
  613. * 管理员发货
  614. * @return mixed
  615. * @throws \yii\web\HttpException
  616. */
  617. public function actionOrderDelivery() {
  618. if(\Yii::$app->request->isPost) {
  619. return parent::edit(OrderForm::class, '发货成功', 'adminDelivery', ['adminDelivery']);
  620. }
  621. return static::notice('非法请求', 400);
  622. }
  623. /*
  624. * 剩余BV页
  625. *
  626. */
  627. public function actionRemainPv()
  628. {
  629. $filter = $this->filterCondition([
  630. 'USER_NAME' => 'U.USER_NAME',
  631. ]);
  632. $condition = $filter['condition'];
  633. $params = $filter['params'];
  634. $listObj = new RemainPvList();
  635. $data = $listObj->getList(['condition'=>$condition, 'params'=>$params]);
  636. return static::notice($data);
  637. }
  638. /*
  639. * 剩余BV流水
  640. *
  641. */
  642. public function actionFlowRemainPv()
  643. {
  644. $filter = $this->filterCondition([
  645. 'USER_NAME' => 'U.USER_NAME',
  646. ]);
  647. $condition = $filter['condition'];
  648. $params = $filter['params'];
  649. $listObj = new FlowRemainPvList();
  650. $data = $listObj->getList(['condition'=>$condition, 'params'=>$params]);
  651. return static::notice($data);
  652. }
  653. /**
  654. * 订单详情
  655. * @return mixed
  656. * @throws \yii\web\HttpException
  657. */
  658. public function actionOrderDetail()
  659. {
  660. $orderSn = \Yii::$app->request->get('orderSn');
  661. $order = Order::findOneAsArray('SN=:SN', [':SN' => $orderSn]);
  662. if (!$order) {
  663. return static::notice('订单不存在', 400);
  664. }
  665. $order['ORDER_TYPE'] = $order['ORDER_TYPE'] === 'ZC' ? '首单' : '复消';
  666. // 如果当前订单所在期数已挂网,则不可调整
  667. $period = Period::getInfoByPeriodNum($order['PERIOD_NUM']);
  668. if (!$period) {
  669. return static::notice('期数无效', 400);
  670. }
  671. if ($period['IS_SENT'] > 0) {
  672. return static::notice('订单已挂网', 400);
  673. }
  674. // 根据订单期数查询可调整期数
  675. $availablePeriod = [];
  676. if ($order['PERIOD_NUM']) {
  677. $availablePeriod = Period::getPeriodList(+$order['PERIOD_NUM'] - 1);
  678. foreach ($availablePeriod as $k => $item) {
  679. $availablePeriod[$k]['disabled'] = (+$item['IS_SENT'] > 0) || ($order['PERIOD_NUM'] == $item['PERIOD_NUM']);
  680. }
  681. }
  682. return static::notice(['order' => $order, 'availablePeriod' => $availablePeriod]);
  683. }
  684. /**
  685. * 期数检查
  686. * @return mixed
  687. * @throws \yii\web\HttpException
  688. */
  689. public function actionPeriodInspect()
  690. {
  691. $modernPeriod = \Yii::$app->request->get('modernPeriod');
  692. $period = Period::getInfoByPeriodNum($modernPeriod);
  693. if (!$period) {
  694. return static::notice('期数不存在', 400);
  695. }
  696. if ($period['IS_SENT'] > 0) {
  697. return static::notice('调整后的期数已未挂网', 400);
  698. }
  699. }
  700. /**
  701. * 调整订单期数
  702. * @return mixed
  703. * @throws Exception
  704. * @throws \yii\db\Exception
  705. * @throws \yii\web\HttpException
  706. */
  707. public function actionOrderPeriodAdjust()
  708. {
  709. if (\Yii::$app->request->isPost) {
  710. $formModel = new OrderPeriodAdjustForm();
  711. $formModel->scenario = 'orderPeriodAdjust';
  712. if ($formModel->load(\Yii::$app->request->post(), '') && $formModel->periodAdjust()) {
  713. return static::notice('成功');
  714. } else {
  715. return static::notice(Form::formatErrorsForApi($formModel->getErrors()), 400);
  716. }
  717. } else {
  718. $filter = $this->filterCondition([
  719. 'ORDER_SN' => 'P.ORDER_SN',
  720. 'ORIGIN_PERIOD'=> 'P.ORIGIN_PERIOD',
  721. 'MODERN_PERIOD'=> 'P.MODERN_PERIOD',
  722. 'CREATED_AT'=> 'P.CREATED_AT',
  723. ]);
  724. $listObj = new OrderPeriodAdjustList();
  725. $data = $listObj->getList(['condition' => $filter['condition'], 'params' => $filter['params']]);
  726. return static::notice($data);
  727. }
  728. }
  729. }