IntraCityController.php 36 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792
  1. <?php
  2. namespace hd\controllers;
  3. use bizHd\express\classes\ExpressOrderClass;
  4. use bizHd\express\models\ExpressOrder;
  5. use bizHd\order\classes\OrderClass;
  6. use bizHd\order\classes\OrderGoodsClass;
  7. use bizHd\order\classes\OrderItemClass;
  8. use bizHd\shop\classes\MainClass;
  9. use bizHd\user\classes\UserClass;
  10. use common\components\noticeUtil;
  11. use common\components\util;
  12. use hd\models\IntraCity\StoreFeeForm;
  13. use Yii;
  14. use biz\shop\classes\ShopClass;
  15. use yii\helpers\Json;
  16. use common\components\IntraCityExpress;
  17. use yii\db\Query;
  18. use biz\wx\classes\WxMessageClass;
  19. /**
  20. * 同城配送控制器
  21. *
  22. * 提供同城配送相关的API接口
  23. */
  24. class IntraCityController extends BaseController
  25. {
  26. public $guestAccess = ['callback'];
  27. public $useSandbox = true;//是否开启沙箱
  28. /**
  29. * 创建门店
  30. * POST /intra-city/create-store
  31. */
  32. public function actionCreateStore()
  33. {
  34. try {
  35. $shop = $this->shop;
  36. $shopName = $shop->shopName ?? '';
  37. $sjName = $shop->merchantName ?? '';
  38. $name = $shopName == '首店' ? $sjName : $sjName . ' ' . $shopName;
  39. $storeData = [
  40. 'out_store_id' => $this->mainId, //自定义门店编号 -- 从 shopId 改为 dmainId
  41. 'store_name' => $name,
  42. 'address_info' => [
  43. 'province' => $shop->province,
  44. 'city' => $shop->city,
  45. 'area' => $shop->dist,
  46. 'street' => '',
  47. 'house' => $shop->floor ? $shop->address . $shop->floor : $shop->address,
  48. 'lat' => $shop->lat,
  49. 'lng' => $shop->long,
  50. 'phone' => $shop->telephone
  51. ]
  52. ];
  53. // 验证必填参数
  54. $requiredFields = ['out_store_id', 'store_name', 'address_info'];
  55. foreach ($requiredFields as $field) {
  56. if (empty($storeData[$field])) {
  57. util::fail("缺少必填参数:{$field}");
  58. }
  59. }
  60. // 创建门店前,检查是否已经 开通门店权限 (有wxStoreId,即说明开通了)
  61. //$shopExt = ShopExtClass::getByCondition(['shopId' => $shopId], true, false, 'id, wxStoreId');
  62. $shopExt = MainClass::getById($this->mainId, true, 'id, wxStoreId');
  63. // 查询是否存在 wx_store_id,不存在则执行apply
  64. if ($shopExt->wxStoreId == '') {
  65. $re = IntraCityExpress::applyStore();
  66. if (!is_array($re)) {
  67. $re = Json::decode($re, true);
  68. }
  69. if ($re['errcode'] != 0) {
  70. Yii::error("开通门店权限失败:" . $re['errmsg']);
  71. util::fail('开通门店权限失败');
  72. }
  73. }
  74. $result = IntraCityExpress::createStore($storeData);
  75. if ($result['errcode'] === 0) {
  76. // 保存微信门店编号(wx_store_id)
  77. $shopExt->wxStoreId = $result['wx_store_id'];
  78. $shopExt->save();
  79. util::success($result, "门店创建成功");
  80. } else {
  81. Yii::error("门店创建失败:" . $result['errmsg']);
  82. util::fail($result['errmsg']);
  83. }
  84. } catch (\Exception $e) {
  85. Yii::error("门店创建失败:" . $e->getMessage());
  86. util::fail("系统出错");
  87. }
  88. }
  89. /**
  90. * 查询门店创建情况
  91. */
  92. public function actionStore()
  93. {
  94. $shopId = $this->shopId;
  95. // 首先从门店扩展表查询是否已经创建
  96. //$shopExt = ShopExtClass::getByCondition(['shopId' => $shopId], true, false, 'id, wxStoreId');
  97. $shopExt = MainClass::getById($this->mainId, true, 'id, wxStoreId');
  98. if ($shopExt->wxStoreId == '') { // 不存在,则从微信接口查询
  99. $result = IntraCityExpress::getStore($this->mainId);
  100. if ($result['errcode'] === 0) {
  101. $store = $result['store_list'][0];
  102. // 保存 wx_store_id
  103. $shopExt->wxStoreId = $store['wx_store_id'];
  104. $shopExt->save();
  105. util::success($store, "门店查询成功");
  106. } else {
  107. Yii::error("门店查询失败:" . $result['errmsg']);
  108. util::fail('门店查询失败');
  109. }
  110. } else {
  111. $field = 'province, city, dist, lat, long, floor, address';
  112. $shop = ShopClass::getById($shopId, false, $field);
  113. $data = array_merge($shop, $shopExt->toArray());
  114. util::success($data, "门店查询成功");
  115. }
  116. }
  117. /**
  118. * 更新门店
  119. */
  120. public function actionUpdateStore()
  121. {
  122. // 首先从门店扩展表查询是否已经创建
  123. //$shopExt = ShopExtClass::getByCondition(['shopId' => $shopId], false, false, 'id, wxStoreId');
  124. $shopExt = MainClass::getById($this->mainId, false, 'id, wxStoreId');
  125. if ($shopExt['wxStoreId'] == '') {
  126. util::fail('未创建门店,请先创建');
  127. }
  128. $shop = $this->shop;
  129. $shopName = $shop->shopName ?? '';
  130. $sjName = $shop->merchantName ?? '';
  131. $name = $shopName == '首店' ? $sjName : $sjName . ' ' . $shopName;
  132. $storeData = [
  133. 'keys' => ['wx_store_id' => $shopExt['wxStoreId']],
  134. 'content' => [
  135. 'store_name' => $name,
  136. 'address_info' => [
  137. 'province' => $shop->province,
  138. 'city' => $shop->city,
  139. 'area' => $shop->dist,
  140. 'street' => '',
  141. 'house' => $shop->floor ? $shop->address . $shop->floor : $shop->address,
  142. 'lat' => $shop->lat,
  143. 'lng' => $shop->long,
  144. 'phone' => $shop->telephone
  145. ],
  146. //"order_pattern" => 2,
  147. //"service_trans_prefer" => "SFTC" //order_pattern = 2时必填
  148. ]
  149. ];
  150. $result = IntraCityExpress::updateStore($storeData);
  151. if ($result['errcode'] === 0) {
  152. util::success($result, "门店更新成功");
  153. } else {
  154. Yii::error("门店更新失败:" . $result['errmsg']);
  155. util::fail($result['errmsg']);
  156. //util::fail('门店更新失败');
  157. }
  158. }
  159. /**
  160. * 门店运费充值
  161. */
  162. public function actionStoreCharge()
  163. {
  164. $post = Yii::$app->request->post();
  165. $amount = floatval($post['amount']);
  166. $amountTurnFen = $amount * 100;
  167. if ($amountTurnFen < 5000) {
  168. util::fail('50元起充');
  169. }
  170. $expressId = $post['expressId'];
  171. $serviceTransIds = ['SFTC', 'DADA'];
  172. if (!in_array($expressId, $serviceTransIds)) {
  173. util::fail('快递动力ID出错');
  174. }
  175. //$shopExt = ShopExtClass::getByCondition(['shopId' => $shopId], false, false, 'id, wxStoreId');
  176. $shopExt = MainClass::getById($this->mainId, false, 'id, wxStoreId');
  177. if ($shopExt['wxStoreId'] == '') {
  178. util::fail('微信门店编号为空');
  179. }
  180. $wxStoreId = $shopExt['wxStoreId'];
  181. $result = IntraCityExpress::storeCharge($wxStoreId, $expressId, $amountTurnFen);
  182. if ($result['errcode'] === 0) {
  183. util::success($result, "门店余额充值单已生成");
  184. } else {
  185. Yii::error("门店余额充值失败:" . $result['errmsg']);
  186. util::fail('门店余额充值失败');
  187. }
  188. }
  189. /**
  190. * 门店余额查询
  191. */
  192. public function actionStoreBalance()
  193. {
  194. //$shopExt = ShopExtClass::getByCondition(['shopId' => $shopId], false, false, 'id, wxStoreId');
  195. $shopExt = MainClass::getById($this->mainId, false, 'id, wxStoreId');
  196. if ($shopExt['wxStoreId'] == '') {
  197. util::fail('微信门店编号为空');
  198. }
  199. $wxStoreId = $shopExt['wxStoreId'];
  200. $result = IntraCityExpress::getBalance($wxStoreId);
  201. if ($result['errcode'] === 0) {
  202. $data = ['all_balance' => $result['all_balance'] / 100.0];
  203. foreach ($result['balance_detail'] as $item) {
  204. if ($item['service_trans_id'] == 'DADA') {
  205. $data['dada_balance'] = $item['balance'] / 100.0;
  206. }
  207. if ($item['service_trans_id'] == 'SFTC') {
  208. $data['sf_balance'] = $item['balance'] / 100.0;
  209. }
  210. }
  211. util::success($data, "门店余额查询成功");
  212. } else {
  213. Yii::error("门店余额查询失败:" . $result['errmsg']);
  214. util::fail('门店余额查询失败');
  215. }
  216. }
  217. /**
  218. * 查询运费
  219. */
  220. public function actionStoreFee()
  221. {
  222. $post = Yii::$app->request->post();
  223. // 创建表单验证模型
  224. $form = new StoreFeeForm();
  225. $form->setScenario('store_fee');
  226. $form->load($post, ''); // 直接从 post 数据加载,不使用模型名作为前缀
  227. // 执行表单验证
  228. $form->validateForm();
  229. $orderId = $post['orderId'];
  230. $order = OrderClass::getById($orderId);
  231. if (empty($order)) {
  232. util::fail('订单出错');
  233. }
  234. if ($order['mainId'] != $this->mainId) {
  235. util::fail('订单出错');
  236. }
  237. $sn = $order['orderSn'];
  238. $shopId = intval($this->shopId);
  239. if (empty($shopId)) {
  240. util::fail("门店不存在");
  241. }
  242. //$shopExt = ShopExtClass::getByCondition(['shopId' => $shopId], false, false, 'id, wxStoreId');
  243. $shopExt = MainClass::getById($this->mainId, false, 'id, wxStoreId');
  244. if (empty($shopExt)) {
  245. util::fail("微信门店不存在");
  246. }
  247. $itemInfoList = OrderItemClass::getListBySn($sn);
  248. $orderType = 2; // 默认是 2。说明:1花束订单 2花材订单 3花束和花材都有
  249. if (empty($itemInfoList)) {
  250. $orderType = 1;
  251. }
  252. $cargoName = '花材'; // 商品名称,默认是花材
  253. $goodsInfoList = OrderGoodsClass::getListBySn($sn);
  254. if (count($goodsInfoList) == 1) {
  255. $goodsInfo = $goodsInfoList[0];
  256. $cargoName = $goodsInfo['name'];
  257. } else {
  258. if ($orderType != 2) {
  259. util::fail("订单商品数量不正确");
  260. }
  261. }
  262. $cargo = [
  263. 'cargo_name' => $cargoName, // 商品名称 -- $order 中没有,要在 goodsInfo 中取
  264. 'cargo_weight' => intval($post['weight'] * 1000), // 单位:克 -- 把千克转换为克
  265. 'cargo_price' => intval($post['price'] * 100), // 单位:分 -- 把元转换为分
  266. 'cargo_type' => IntraCityExpress::GOODS_TYPE_FLOWER,
  267. 'cargo_num' => intval($post['packageNum'])
  268. ];
  269. $originalLng = doubleval($post['user_lng']);
  270. $originalLat = doubleval($post['user_lat']);
  271. $orderData = [
  272. //'out_store_id' => $shopId,
  273. 'wx_store_id' => $shopExt['wxStoreId'],
  274. 'user_name' => $post['user_name'],
  275. 'user_phone' => $post['user_phone'],
  276. 'user_lng' => $originalLng,
  277. 'user_lat' => $originalLat,
  278. 'user_address' => $post['user_address'],
  279. 'cargo' => $cargo,
  280. //'use_sandbox' => 1 // 如果不需要沙箱,use_sandbox就不传就好了 -- 踩坑人的经验
  281. //'use_sandbox' => getenv('YII_ENV') == 'production' ? 0 : 1 // 根据环境变量判断是否使用沙盒环境 -- 没用,不生效
  282. ];
  283. $result = IntraCityExpress::preAddOrder($orderData);
  284. if ($result['errcode'] === 0) {
  285. util::success($result, "运费查询成功");
  286. } else {
  287. Yii::error("运费查询失败:" . json_encode($result));
  288. util::fail('运费查询失败' . json_encode($result));
  289. }
  290. }
  291. /**
  292. * 创建订单
  293. * POST /intra-city/create-order
  294. */
  295. public function actionCreateOrder()
  296. {
  297. try {
  298. $post = Yii::$app->request->post();
  299. $orderId = $post['orderId'];
  300. $field = 'mainId, status, sendStatus, repeat, forward, orderSn, userId, actPrice, sendNum';
  301. $order = OrderClass::getById($orderId, false, $field);
  302. if (empty($order)) {
  303. util::fail('订单出错');
  304. }
  305. if ($order['mainId'] != $this->mainId) {
  306. util::fail('订单出错');
  307. }
  308. // 不能创建配送的几种订单状态
  309. $notCanCreateStatus = [OrderClass::ORDER_STATUS_UN_PAY, OrderClass::ORDER_STATUS_SENDING, OrderClass::ORDER_STATUS_COMPLETE, OrderClass::ORDER_HAD_REFUND];
  310. if (in_array($order['status'], $notCanCreateStatus)) {
  311. Yii::error('订单号:' . $orderId . ' 的状态是 ' . $order['status'] . ',不允许创建配送');
  312. util::fail('当前订单状态无法创建配送');
  313. }
  314. // 不能创建配送的几种配送状态
  315. $notCanCreateSendStatus = [OrderClass::SEND_STATUS_SENDING, OrderClass::SEND_STATUS_COMPLETED];
  316. if (in_array($order['sendStatus'], $notCanCreateSendStatus)) {
  317. Yii::error('订单号:' . $orderId . ' 的配送状态是 ' . $order['sendStatus'] . ',不允许重复创建配送');
  318. util::fail('当前订单配送状态无法创建配送');
  319. }
  320. if ($order['repeat'] == 1) {
  321. util::fail('收款码订单不支持跑腿');
  322. }
  323. if ($order['forward'] == 1) {
  324. util::fail('售后付款单不支持跑腿');
  325. }
  326. $sn = $order['orderSn'];
  327. $itemInfoList = OrderItemClass::getListBySn($sn, 'id, name, cover, num');
  328. $itemList = [];
  329. $orderType = 2; // 默认是 2。说明:1花束订单 2花材订单 3花束和花材都有
  330. if (empty($itemInfoList)) {
  331. $orderType = 1; // 花束订单
  332. $goodsInfoList = OrderGoodsClass::getListBySn($sn);
  333. $itemCount = 0;
  334. foreach ($goodsInfoList as $itemInfo) {
  335. $itemList[] = [
  336. 'item_name' => $itemInfo['name'],
  337. 'item_pic_url' => $itemInfo['bigCover'],
  338. 'count' => $itemInfo['num'],
  339. ];
  340. $itemCount += $itemInfo['num'];
  341. }
  342. $post['packageNum'] = $itemCount;
  343. } else {
  344. $itemCount = 0;
  345. foreach ($itemInfoList as $itemInfo) {
  346. $itemList[] = [
  347. 'item_name' => $itemInfo['name'],
  348. 'item_pic_url' => $itemInfo['bigCover'],
  349. 'count' => $itemInfo['num'],
  350. ];
  351. $itemCount += $itemInfo['num'];
  352. }
  353. $post['packageNum'] = $itemCount;
  354. }
  355. //$shopExt = ShopExtClass::getByCondition(['shopId' => $shopId], false, false, 'id, wxStoreId');
  356. $shopExt = MainClass::getById($this->mainId, false, 'id, wxStoreId');
  357. if (empty($shopExt)) {
  358. util::fail("微信门店不存在");
  359. }
  360. $cargoName = '花材'; // 商品名称,默认是花材
  361. $goodsInfoList = OrderGoodsClass::getListBySn($sn);
  362. if (count($goodsInfoList) == 1) {
  363. $goodsInfo = $goodsInfoList[0];
  364. $cargoName = $goodsInfo['name'];
  365. } else {
  366. if ($orderType != 2) {
  367. Yii::error('订单商品数量不正确');
  368. util::fail("订单商品数量不正确");
  369. }
  370. }
  371. // 通过 userId 获取 openid(小程序OpenId)
  372. $user = UserClass::getById($order['userId'], false, 'id, miniOpenId');
  373. if (empty($user)) {
  374. Yii::error('获取用户openId出错');
  375. util::fail('数据出错');
  376. }
  377. $cargo = [
  378. 'cargo_name' => $cargoName,
  379. 'cargo_weight' => intval($post['weight'] * 1000),
  380. 'cargo_type' => IntraCityExpress::GOODS_TYPE_FLOWER,
  381. 'cargo_num' => intval($post['packageNum']),
  382. 'cargo_price' => intval($order['actPrice'] * 100), // $order 中有各个价格,请注意
  383. 'item_list' => $itemList,
  384. ];
  385. //生成 store_order_id
  386. $storeOrderId = $orderId;
  387. if ($post['isNew'] == 0) { // 如果不是首次用 $orderId 创建快递配送,则要生成新 store_order_id
  388. // store_order_id 门店订单编号, 即 orderId。如果是重新配送的第n次,订单编号的命名规则为:orderId_copy_n
  389. $query = (new Query())
  390. ->from('xhExpressOrder')
  391. ->where(new \yii\db\Expression('storeOrderId LIKE CONCAT(:prefix, "%")', [':prefix' => $orderId . '_copy_%']));
  392. // $command = $query->createCommand();
  393. // $sql = $command->sql;
  394. $copyOrderCount = $query->count();
  395. $copyOrderCount += 1;
  396. $storeOrderId = $orderId . '_copy_' . $copyOrderCount;
  397. }
  398. $callbackUrl = Yii::$app->params['hdHost'] . '/intra-city/callback';
  399. $orderData = [
  400. 'wx_store_id' => $shopExt['wxStoreId'],
  401. 'store_order_id' => $storeOrderId, //同一个门店订单编号要保证唯一,相同的订单号会重入
  402. 'user_openid' => $user['miniOpenId'],
  403. 'user_lng' => $post['user_lng'],
  404. 'user_lat' => $post['user_lat'],
  405. 'user_address' => $post['user_address'],
  406. 'user_name' => $post['user_name'],
  407. 'user_phone' => $post['user_phone'],
  408. 'order_seq' => $order['sendNum'], // 用于配送员快速寻找到匹配的商品(非必传) -- 对应 xhOrder 表的 sendNum
  409. 'verify_code_type' => 0,
  410. 'order_detail_path' => '/admin/order/detail?id=' . $orderId, // TODO 使用花掌柜的地址,后期要重新选个地址
  411. 'callback_url' => $callbackUrl, // 订单状态回调地址(非必传)
  412. //'use_sandbox' => getenv('YII_ENV') == 'production' ? 0 : 1, // 是否使用沙箱(非必传)
  413. 'cargo' => $cargo
  414. ];
  415. //开发环境允许使用沙箱 ssh
  416. if (getenv('YII_ENV') != 'production') {
  417. if ($this->useSandbox) {
  418. $orderData['use_sandbox'] = 1;
  419. $orderData['user_name'] = '顺丰同城';
  420. $orderData['user_phone'] = 13881979410;
  421. $orderData['user_address'] = '北京市海淀区学清嘉创大厦A座15层';
  422. $orderData['user_lng'] = '116.352954';
  423. $orderData['user_lat'] = '40.014747';
  424. }
  425. }
  426. $result = IntraCityExpress::createOrder($orderData);
  427. if (isset($result['errcode']) && $result['errcode'] === 0) {
  428. OrderClass::updateById($orderId, ['sendStatus' => 1]); // 更新订单状态为配送中
  429. // 保存进 xhExpressOrder 表
  430. $orderData = [
  431. 'mainId' => $this->mainId,
  432. 'shopId' => $this->shopId,
  433. 'deliveryId' => $result['service_trans_id'] ?? '',
  434. 'wxOrderId' => $result['wx_order_id'] ?? '',
  435. 'wxStoreId' => $result['wx_store_id'] ?? '',
  436. 'storeOrderId' => $result['store_order_id'] ?? '',
  437. 'transOrderId' => $result['trans_order_id'] ?? '',
  438. 'distance' => $result['distance'] ?? 0,
  439. 'fee' => $result['fee'] ?? 0,
  440. 'fetchCode' => $result['fetch_code'] ?? '',
  441. 'orderSeq' => $result['order_seq'] ?? ''
  442. ];
  443. ExpressOrderClass::add($orderData);
  444. util::success(['fee' => $result['fee']], '订单创建成功');
  445. } else {
  446. noticeUtil::push("门店 -- " . $this->mainId . ",订单创建失败:" . json_encode($result));
  447. Yii::error("订单创建失败:" . ($result['errmsg'] ?? '未知错误'), 'intracity');
  448. $errorMsg = $result['errmsg'] ?? '';
  449. noticeUtil::push("跑腿单创建失败:" . $errorMsg, '15280215347');
  450. util::fail('提交失败,请确认余额是否充足');
  451. }
  452. } catch (\Exception $e) {
  453. Yii::error("订单创建异常:" . $e->getMessage(), 'intracity');
  454. util::fail("系统出错");
  455. }
  456. }
  457. /**
  458. * 查询订单
  459. * GET /intra-city/get-order
  460. */
  461. public function actionGetOrder()
  462. {
  463. try {
  464. //$shopExt = ShopExtClass::getByCondition(['shopId' => $shopId], false, false, 'id, wxStoreId');
  465. $shopExt = MainClass::getById($this->mainId, false, 'id, wxStoreId');
  466. if (empty($shopExt)) {
  467. util::fail("微信门店不存在");
  468. }
  469. $post = Yii::$app->request->post();
  470. $wxOrderId = isset($post['wx_order_id']) ? $post['wx_order_id'] : '';
  471. $orderId = $post['orderId'];
  472. //$wxStoreId = isset($post['wx_store_id']) ? $post['wx_order_id'] : $shopExt['wxStoreId'];
  473. $wxStoreId = isset($post['wx_store_id']) ? $post['wx_store_id'] : $shopExt['wxStoreId'];
  474. if (empty($wxOrderId) && (empty($orderId) || empty($wxStoreId))) {
  475. util::fail("参数不足:wx_order_id 或 (order_id + wx_store_id) 必须提供一组");
  476. }
  477. $order = OrderClass::getById($orderId, false, 'id, mainId, sendStatus');
  478. if ($order['mainId'] != $this->mainId) {
  479. util::fail('订单未找到');
  480. }
  481. // 检查是否存在重复的订单:如果存在,则使用最后一个订单的 store_order_id
  482. $storeOrderId = $orderId; // ------------------------------------- 注意区分:$storeOrderId , $orderId 。它们有可能不相同
  483. $query = (new Query())
  484. ->from('xhExpressOrder')
  485. ->where(['and',
  486. new \yii\db\Expression('storeOrderId LIKE CONCAT(:prefix, "%")', [':prefix' => $orderId . '_copy_']),
  487. ['status' => 2] // 取完成状态
  488. ])->orderBy('addTime DESC');
  489. $esDatas = $query->all();
  490. $count = count($esDatas);
  491. if ($count > 0) {
  492. $es = $esDatas[0];
  493. $storeOrderId = $es['storeOrderId'];
  494. if ($count > 1) {
  495. noticeUtil::push('同城配送订单重复多于1个. store_order_id:' . $orderId . ',wx_store_id:' . $wxStoreId);
  496. }
  497. }
  498. $result = IntraCityExpress::queryOrder($wxStoreId, $storeOrderId, $wxOrderId);
  499. if (isset($result['errcode']) && $result['errcode'] === 0) {
  500. util::success($result, "查询成功");
  501. } else {
  502. Yii::error("订单查询失败:" . ($result['errmsg'] ?? '未知错误'), 'intracity');
  503. util::fail('订单查询失败: ' . $result['errcode']);
  504. }
  505. } catch (\Exception $e) {
  506. Yii::error("订单查询异常:" . $e->getMessage(), 'intracity');
  507. util::fail("系统出错");
  508. }
  509. }
  510. /**
  511. * 取消订单
  512. * POST /intra-city/cancel-order
  513. */
  514. public function actionCancelOrder()
  515. {
  516. try {
  517. $post = Yii::$app->request->post();
  518. //$shopExt = ShopExtClass::getByCondition(['shopId' => $shopId], false, false, 'id, wxStoreId');
  519. $shopExt = MainClass::getById($this->mainId, false, 'id, wxStoreId');
  520. if (empty($shopExt)) {
  521. util::fail("微信门店不存在");
  522. }
  523. $wxOrderId = isset($post['wx_order_id']) ? $post['wx_order_id'] : '';
  524. $orderId = $post['orderId']; //配送订单创建成功后,也会返回的 store_order_id。 即 orderId
  525. //$wxStoreId = isset($post['wx_store_id']) ? $post['wx_order_id'] : $shopExt['wxStoreId'];
  526. $wxStoreId = isset($post['wx_store_id']) ? $post['wx_store_id'] : $shopExt['wxStoreId'];
  527. if (empty($wxOrderId) && (empty($orderId) || empty($wxStoreId))) {
  528. util::fail("参数不足:wx_order_id 或 (store_order_id + wx_store_id) 必须提供一组");
  529. }
  530. $order = OrderClass::getById($orderId, false, 'id, mainId, sendStatus');
  531. if ($order['mainId'] != $this->mainId) {
  532. util::fail('订单未找到');
  533. }
  534. if ($order['sendStatus'] != 1) {
  535. util::fail('配送单状态不是配送中');
  536. }
  537. // 检查是否存在重复的订单,如果存在,则使用最后一个订单的 store_order_id
  538. $storeOrderId = $orderId; // ------------------------------------- 注意区分:$storeOrderId , $orderId 。它们有可能不相同
  539. $query = (new Query())
  540. ->from('xhExpressOrder')
  541. ->where(['and',
  542. new \yii\db\Expression('storeOrderId LIKE CONCAT(:prefix, "%")', [':prefix' => $orderId . '_copy_']),
  543. ['status' => 1]
  544. ])->orderBy('addTime DESC');
  545. // $command = $query->createCommand();
  546. // $sql = $command->sql;
  547. $esDatas = $query->all();
  548. $count = count($esDatas);
  549. if ($count > 0) {
  550. $es = $esDatas[0];
  551. $storeOrderId = $es['storeOrderId'];
  552. if ($count > 1) {
  553. noticeUtil::push('同城配送订单重复多于1个. store_order_id:' . $orderId . ',wx_store_id:' . $wxStoreId);
  554. }
  555. }
  556. $result = IntraCityExpress::cancelOrder($wxOrderId, $storeOrderId, $wxStoreId);
  557. if (isset($result['errcode']) && $result['errcode'] === 0) {
  558. // 更新订单状态
  559. OrderClass::updateById($orderId, ['sendStatus' => OrderClass::ORDER_STATUS_CANCEL]);//设置为取消状态
  560. $eo = ExpressOrderClass::getByCondition(['storeOrderId' => $storeOrderId, 'wxStoreId' => $wxStoreId], true);
  561. if (!empty($eo)) {
  562. $eo->status = ExpressOrder::STATUS_CANCELED;
  563. $eo->cancelTime = date('Y-m-d H:i:s');
  564. $eo->deductfee = $result['deductfee'];
  565. $eo->save();
  566. }
  567. util::success($result, "订单取消成功");
  568. } else {
  569. if ($result['errcode'] == 934018) { // 93401 -- 订单已取消,请勿重复操作
  570. // 更新订单状态
  571. OrderClass::updateById($orderId, ['sendStatus' => OrderClass::ORDER_STATUS_CANCEL]);//设置为取消状态
  572. util::success($result, "订单取消成功");
  573. }
  574. Yii::error("订单取消失败:" . ($result['errmsg'] ?? '未知错误'), 'intracity');
  575. util::fail('订单取消失败: ' . $result['errcode']);
  576. }
  577. } catch (\Exception $e) {
  578. Yii::error("订单取消异常:" . $e->getMessage(), 'intracity');
  579. util::fail("系统出错");
  580. }
  581. }
  582. /**
  583. * 获取订单列表
  584. * GET /intra-city/order-list
  585. */
  586. public function actionOrderList()
  587. {
  588. }
  589. /**
  590. * 微信回调接口
  591. * POST /intra-city/callback
  592. */
  593. public function actionCallback()
  594. {
  595. $callbackData = Yii::$app->request->post();
  596. if (empty($callbackData)) {
  597. $postStr = file_get_contents('php://input');
  598. // 处理转义字符,将JSON字符串正确解析为数组
  599. $postStr = stripslashes($postStr);
  600. $callbackData = json_decode($postStr, true);
  601. if (empty($callbackData)) {
  602. util::fail('回调请求的数据为空');
  603. }
  604. }
  605. // 从配置中获取安全token
  606. // $token = Yii::$app->params['wx_intracity_token'] ?? 'your_token_here';
  607. // $result = IntraCityExpress::handleOrderCallback($callbackData, $token);
  608. // 记录回调日志
  609. Yii::info('同城配送回调:' . json_encode($callbackData, JSON_UNESCAPED_UNICODE));
  610. $storeOrderId = isset($callbackData['store_order_id']) ? $callbackData['store_order_id'] : 0;
  611. $wxStoreId = isset($callbackData['wx_store_id']) ? $callbackData['wx_store_id'] : ''; //微信门店编号
  612. if (empty($storeOrderId) || empty($wxStoreId)) {
  613. return $this->asJson(['return_code' => 1, 'return_msg' => '请求参数不正确']);
  614. }
  615. try {
  616. // 使用 storeOrderId 与 wxStoreId 去查询 xhExpressOrder 表
  617. $eo = ExpressOrderClass::getByCondition(['storeOrderId' => $storeOrderId, 'wxStoreId' => $wxStoreId], true, false);
  618. if (empty($eo)) {
  619. Yii::error('订单不存在.store_order_id: ' . $storeOrderId . ',wx_store_id: ' . $wxStoreId);
  620. return $this->asJson(['return_code' => 1, 'return_msg' => '系统错误']);
  621. }
  622. // 从 $storeOrderId 提取 orderId
  623. $arr = explode('_', $storeOrderId);
  624. $orderId = intval($arr[0]);
  625. if ($orderId == 0) {
  626. Yii::error('订单号为0. store_order_id: ' . $storeOrderId . ',wx_store_id: ' . $wxStoreId);
  627. return $this->asJson(['return_code' => 1, 'return_msg' => '系统错误']);
  628. }
  629. $tx = Yii::$app->db->beginTransaction(); // ====================== 开启事务
  630. $msg = ''; // 发通知的内容(默认为空,根据情况生成。没有内容则不会发通知)
  631. $orderStatus = intval($callbackData['order_status']);
  632. switch ($orderStatus) {
  633. // 订单创建成功
  634. case IntraCityExpress::ORDER_STATUS_CREATED:
  635. $eo->orderStatus = ExpressOrder::ORDER_STATUS_CREATED;
  636. $eo->status = ExpressOrder::STATUS_CREATED;
  637. // 更新 xhOrder 表的订单状态与配送状态 -- 配送中|已发货
  638. OrderClass::updateById($orderId, ['status' => OrderClass::ORDER_STATUS_SENDING, 'sendStatus' => OrderClass::SEND_STATUS_SENDING]);
  639. break;
  640. // 商家取消订单
  641. case IntraCityExpress::ORDER_STATUS_CANCELED_BY_MERCHANT:
  642. $eo->orderStatus = ExpressOrder::ORDER_STATUS_CANCELED_BY_MERCHANT;
  643. // 更新 xhOrder 表的订单状态与配送状态 -- 待配送|取消
  644. OrderClass::updateById($orderId, ['status' => OrderClass::ORDER_STATUS_UN_SEND, 'sendStatus' => OrderClass::SEND_STATUS_CANCEL]);
  645. $msg = '您有订单已取消配送(订单编号:';
  646. break;
  647. // 配送方取消订单
  648. case IntraCityExpress::ORDER_STATUS_CANCELED_BY_DELIVERY:
  649. $eo->orderStatus = ExpressOrder::ORDER_STATUS_CANCELED_BY_DELIVERY;
  650. $eo->status = ExpressOrder::STATUS_CANCELED;
  651. // 更新 xhOrder 表的订单状态与配送状态 -- 待配送|取消
  652. OrderClass::updateById($orderId, ['status' => OrderClass::ORDER_STATUS_UN_SEND, 'sendStatus' => OrderClass::SEND_STATUS_CANCEL]);
  653. $msg = '您有订单被配送方取消(订单编号:';
  654. break;
  655. // 配送员接单
  656. case IntraCityExpress::ORDER_STATUS_ACCEPTED:
  657. $eo->orderStatus = ExpressOrder::ORDER_STATUS_ACCEPTED;
  658. // 更新 xhOrder 表的订单状态与配送状态 -- 配送中|已发货
  659. OrderClass::updateById($orderId, ['status' => OrderClass::ORDER_STATUS_SENDING, 'sendStatus' => OrderClass::SEND_STATUS_SENDING]); //订单创建时已执行了,这儿重复更新
  660. break;
  661. // 配送员到店
  662. case IntraCityExpress::ORDER_STATUS_ARRIVED:
  663. $eo->orderStatus = ExpressOrder::ORDER_STATUS_ARRIVED;
  664. // 更新 xhOrder 表的订单状态与配送状态 -- 配送中|已发货
  665. OrderClass::updateById($orderId, ['status' => OrderClass::ORDER_STATUS_SENDING, 'sendStatus' => OrderClass::SEND_STATUS_SENDING]); //订单创建时已执行了,这儿重复更新
  666. break;
  667. // 配送中
  668. case IntraCityExpress::ORDER_STATUS_DELIVERING:
  669. $eo->orderStatus = ExpressOrder::ORDER_STATUS_DELIVERING;
  670. break;
  671. // 配送员撤单
  672. case IntraCityExpress::ORDER_STATUS_WITHDRAWN:
  673. $eo->orderStatus = ExpressOrder::ORDER_STATUS_WITHDRAWN;
  674. // 更新 xhOrder 表的订单状态与配送状态 -- 待配送|未发货
  675. OrderClass::updateById($orderId, ['status' => OrderClass::ORDER_STATUS_UN_SEND, 'sendStatus' => OrderClass::SEND_STATUS_UNSEND]);
  676. $msg = '您有订单被配送员取消(订单编号:';
  677. break;
  678. // 配送完成
  679. case IntraCityExpress::ORDER_STATUS_COMPLETED:
  680. $eo->orderStatus = ExpressOrder::ORDER_STATUS_COMPLETED;
  681. $eo->status = ExpressOrder::STATUS_COMPLETED;
  682. // 更新 xhOrder 表的订单状态与配送状态 -- 已完成|已送达
  683. OrderClass::updateById($orderId, ['status' => OrderClass::ORDER_STATUS_COMPLETE, 'sendStatus' => OrderClass::SEND_STATUS_COMPLETED]);
  684. break;
  685. // 配送异常
  686. case IntraCityExpress::ORDER_STATUS_EXCEPTION:
  687. $eo->orderStatus = ExpressOrder::ORDER_STATUS_EXCEPTION;
  688. noticeUtil::push('同城配送异常 --- store_order_id(orderId):' . $storeOrderId . ',wx_store_id:' . $wxStoreId);
  689. // 更新 xhOrder 表的订单状态与配送状态 -- 待配送|未发货
  690. OrderClass::updateById($orderId, ['status' => OrderClass::ORDER_STATUS_UN_SEND, 'sendStatus' => OrderClass::SEND_STATUS_UNSEND]);
  691. $msg = '您有订单配送出现异常(订单编号:';
  692. break;
  693. }
  694. if ($msg != '') { // $msg 不为空,则发通知
  695. $order = OrderClass::getById($orderId, true, 'id, shopId, customName, sendNum');
  696. $shop = ShopClass::getById($order->shopId, true, 'id, ptStyle, mainId');
  697. $result = $msg . $order->sendNum . ')';
  698. WxMessageClass::expressErrorInform($shop, $order->customName, $orderId, $result);
  699. }
  700. $re = $eo->save();
  701. if (!$re) {
  702. noticeUtil::push('同城配送回调更新订单状态失败. store_order_id:' . $storeOrderId . ',wx_store_id:' . $wxStoreId . ',status:' . $eo->status);
  703. Yii::error('更新订单状态失败. store_order_id:' . $storeOrderId . ',wx_store_id:' . $wxStoreId . ',status:' . $eo->status);
  704. $tx->rollBack(); // ====================== 事务回滚
  705. return $this->asJson(['return_code' => 1, 'return_msg' => '系统错误']);
  706. }
  707. $tx->commit(); // ====================== 事务提交
  708. return $this->asJson(['return_code' => 0, 'return_msg' => 'OK']); // 成功状态的返回数据
  709. } catch (\Exception $e) {
  710. Yii::error('同城配送回调处理异常:' . $e->getMessage());
  711. return $this->asJson(['return_code' => 1, 'return_msg' => '系统错误']);
  712. }
  713. }
  714. }