ShopController.php 25 KB

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