OrderController.java 36 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795
  1. package com.kmall.admin.controller;
  2. import com.kmall.admin.entity.*;
  3. import com.kmall.manager.manager.wechat.WechatUtil;
  4. import com.kmall.manager.manager.wechat.WechatGlobalUtil;
  5. import com.kmall.manager.manager.wechat.wxglobal.dto.WechatGlobalRefundApiResult;
  6. import com.kmall.admin.service.*;
  7. import com.kmall.admin.service.OrderExceptionRecordService;
  8. import com.kmall.admin.service.OrderProcessRecordService;
  9. import com.kmall.admin.service.OrderService;
  10. import com.kmall.admin.utils.ParamUtils;
  11. import com.kmall.admin.utils.ShiroUtils;
  12. import com.kmall.common.constant.Dict;
  13. import com.kmall.admin.fromcomm.entity.SysUserEntity;
  14. import com.kmall.common.utils.*;
  15. import com.kmall.common.utils.excel.ExcelExport;
  16. import com.kmall.manager.manager.pingan.PinganUtil;
  17. import com.kmall.manager.manager.pingan.dto.PinganResponseDto;
  18. import com.kmall.common.utils.print.ticket.item.Ticket;
  19. import com.kmall.common.utils.wechat.WechatMicropayApiResult;
  20. import com.kmall.common.utils.wechat.WechatRefundApiResult;
  21. import com.kmall.common.utils.wechat.WechatReverseApiResult;
  22. import net.sf.json.JSONObject;
  23. import org.apache.commons.lang3.StringUtils;
  24. import org.apache.commons.logging.Log;
  25. import org.apache.commons.logging.LogFactory;
  26. import org.apache.shiro.authz.annotation.RequiresPermissions;
  27. import org.springframework.beans.factory.annotation.Autowired;
  28. import org.springframework.web.bind.annotation.*;
  29. import javax.servlet.http.HttpServletRequest;
  30. import javax.servlet.http.HttpServletResponse;
  31. import java.math.BigDecimal;
  32. import java.text.ParseException;
  33. import java.text.SimpleDateFormat;
  34. import java.util.*;
  35. /**
  36. * @author Scott
  37. * @email
  38. * @date 2017-08-13 10:41:09
  39. */
  40. @RestController
  41. @RequestMapping("order")
  42. public class OrderController {
  43. private Log logger = LogFactory.getLog(OrderController.class);
  44. @Autowired
  45. private OrderService orderService;
  46. @Autowired
  47. private OrderProcessRecordService orderProcessRecordService;
  48. @Autowired
  49. private OrderRefundService orderRefundService;
  50. @Autowired
  51. private OrderExceptionRecordService orderExceptionRecordService;
  52. @Autowired
  53. private StoreService storeService;
  54. @Autowired
  55. private OrderWXPayRecordService orderWXPayRecordService;
  56. @Autowired
  57. private PinganResponseService pinganResponseService;
  58. /**
  59. * 列表
  60. */
  61. @RequestMapping("/list")
  62. @RequiresPermissions("order:list")
  63. public R list(@RequestParam Map<String, Object> params) {
  64. ParamUtils.setQueryPowerByRoleType(params, "storeId", "merchSn", "thirdPartyMerchCode");
  65. //查询列表数据
  66. Query query = new Query(params);
  67. query.put("isOnfiilineOrder", Dict.isOnfflineOrder.item_0.getItem());
  68. String startTime = (String) params.get("startTime");
  69. String endTime = (String) params.get("endTime");
  70. if(org.apache.commons.lang.StringUtils.isNotEmpty(startTime)) {
  71. try {
  72. startTime = new String(startTime.getBytes("iso-8859-1"), "utf-8");
  73. } catch (Exception e) {
  74. e.printStackTrace();
  75. }
  76. startTime = DateUtils.getDate(startTime);
  77. query.put("startTime", startTime + " 00:00:00");
  78. }
  79. if(org.apache.commons.lang.StringUtils.isNotEmpty(endTime)) {
  80. try {
  81. endTime = new String(endTime.getBytes("iso-8859-1"), "utf-8");
  82. } catch (Exception e) {
  83. e.printStackTrace();
  84. }
  85. endTime = DateUtils.getDate(endTime);
  86. query.put("endTime", endTime + " 59:59:59");
  87. }
  88. List<OrderEntity> orderList = orderService.queryList(query);
  89. int total = orderService.queryTotal(query);
  90. PageUtils pageUtil = new PageUtils(orderList, total, query.getLimit(), query.getPage());
  91. return R.ok().put("page", pageUtil);
  92. }
  93. /**
  94. * 信息
  95. */
  96. @RequestMapping("/info/{id}")
  97. @RequiresPermissions("order:info")
  98. public R info(@PathVariable("id") Long id) {
  99. OrderEntity order = orderService.queryObject(id);
  100. return R.ok().put("order", order);
  101. }
  102. /**
  103. * 信息
  104. */
  105. @RequestMapping("/infos/{id}")
  106. @RequiresPermissions("order:infos")
  107. public R infos(@PathVariable("id") Long id) {
  108. OrderEntity order = orderService.queryInfos(id);
  109. return R.ok().put("order", order);
  110. }
  111. /**
  112. * 保存
  113. */
  114. @RequestMapping("/save")
  115. @RequiresPermissions("order:save")
  116. public R save(@RequestBody OrderEntity order) {
  117. orderService.save(order);
  118. return R.ok();
  119. }
  120. /**
  121. * 修改
  122. */
  123. @RequestMapping("/update")
  124. @RequiresPermissions("order:update")
  125. public R update(@RequestBody OrderEntity order) {
  126. orderService.update(order);
  127. return R.ok();
  128. }
  129. /**
  130. * 删除
  131. */
  132. @RequestMapping("/delete")
  133. @RequiresPermissions("order:delete")
  134. public R delete(@RequestBody Long[] ids) {
  135. orderService.deleteBatch(ids);
  136. return R.ok();
  137. }
  138. /**
  139. * 查看所有列表
  140. */
  141. @RequestMapping("/queryAll")
  142. public R queryAll(@RequestParam Map<String, Object> params) {
  143. ParamUtils.setQueryPowerByRoleType(params, "storeId", "merchSn", "thirdPartyMerchCode");
  144. List<OrderEntity> list = orderService.queryList(params);
  145. return R.ok().put("list", list);
  146. }
  147. /**
  148. * 总计
  149. */
  150. @RequestMapping("/queryTotal")
  151. public R queryTotal(@RequestParam Map<String, Object> params) {
  152. ParamUtils.setQueryPowerByRoleType(params, "storeId", "merchSn", "thirdPartyMerchCode");
  153. int sum = orderService.queryTotal(params);
  154. return R.ok().put("sum", sum);
  155. }
  156. /**
  157. * 确定收货
  158. *
  159. * @param id
  160. * @return
  161. */
  162. @RequestMapping("/confirm")
  163. @RequiresPermissions("order:confirm")
  164. public R confirm(@RequestBody Long id) {
  165. orderService.confirm(id);
  166. return R.ok();
  167. }
  168. /**
  169. * 发货
  170. *
  171. * @param order
  172. * @return
  173. */
  174. @RequestMapping("/sendGoods")
  175. @RequiresPermissions("order:sendGoods")
  176. public R sendGoods(@RequestBody OrderEntity order) {
  177. orderService.sendGoods(order);
  178. return R.ok();
  179. }
  180. /**
  181. * 跟踪快递轨迹
  182. *
  183. * @param id
  184. * @return
  185. */
  186. @RequestMapping("/getLogistics/{id}")
  187. @RequiresPermissions("order:getLogistics")
  188. public R getLogistics(@PathVariable("id") Long id) {
  189. Map result = orderService.getLogistics(id);
  190. return R.ok().put("result", result);
  191. }
  192. /**
  193. * 获取订单清关信息
  194. *
  195. * @param orderSn
  196. * @return
  197. */
  198. @RequestMapping("/getProcess/{orderSn}")
  199. @RequiresPermissions("order:getProcess")
  200. public R getProcess(@PathVariable("orderSn") String orderSn) {
  201. OrderProcessRecordEntity orderProcessRecordEntity = orderProcessRecordService.queryObjectByOrderSn(orderSn);
  202. if (orderProcessRecordEntity != null) {
  203. if (orderProcessRecordEntity.getShipmentStartTime() != null) {
  204. orderProcessRecordEntity.setShipmentStartTimeStr(
  205. DateUtils.format(orderProcessRecordEntity.getShipmentStartTime(), DateUtils.DATE_TIME_PATTERN));
  206. }
  207. if (orderProcessRecordEntity.getShipmentSuccTime() != null) {
  208. orderProcessRecordEntity.setShipmentSuccTimeStr(
  209. DateUtils.format(orderProcessRecordEntity.getShipmentSuccTime(), DateUtils.DATE_TIME_PATTERN));
  210. }
  211. if (orderProcessRecordEntity.getCustomsStartTime() != null) {
  212. orderProcessRecordEntity.setCustomsStartTimeStr(
  213. DateUtils.format(orderProcessRecordEntity.getCustomsStartTime(), DateUtils.DATE_TIME_PATTERN));
  214. }
  215. if (orderProcessRecordEntity.getCustomsSuccTime() != null) {
  216. orderProcessRecordEntity.setCustomsSuccTimeStr(
  217. DateUtils.format(orderProcessRecordEntity.getCustomsSuccTime(), DateUtils.DATE_TIME_PATTERN));
  218. }
  219. if (orderProcessRecordEntity.getWaybillStartTime() != null) {
  220. orderProcessRecordEntity.setWaybillStartTimeStr(
  221. DateUtils.format(orderProcessRecordEntity.getWaybillStartTime(), DateUtils.DATE_TIME_PATTERN));
  222. }
  223. if (orderProcessRecordEntity.getWaybillSuccTime() != null) {
  224. orderProcessRecordEntity.setWaybillSuccTimeStr(
  225. DateUtils.format(orderProcessRecordEntity.getWaybillSuccTime(), DateUtils.DATE_TIME_PATTERN));
  226. }
  227. if (orderProcessRecordEntity.getEleOrderStartTime() != null) {
  228. orderProcessRecordEntity.setEleOrderStartTimeStr(
  229. DateUtils.format(orderProcessRecordEntity.getEleOrderStartTime(), DateUtils.DATE_TIME_PATTERN));
  230. }
  231. if (orderProcessRecordEntity.getEleOrderSuccTime() != null) {
  232. orderProcessRecordEntity.setEleOrderSuccTimeStr(
  233. DateUtils.format(orderProcessRecordEntity.getEleOrderSuccTime(), DateUtils.DATE_TIME_PATTERN));
  234. }
  235. if (orderProcessRecordEntity.getAddOrderStartTime() != null) {
  236. orderProcessRecordEntity.setAddOrderStartTimeStr(
  237. DateUtils.format(orderProcessRecordEntity.getAddOrderStartTime(), DateUtils.DATE_TIME_PATTERN));
  238. }
  239. if (orderProcessRecordEntity.getAddOrderSuccTime() != null) {
  240. orderProcessRecordEntity.setAddOrderSuccTimeStr(
  241. DateUtils.format(orderProcessRecordEntity.getAddOrderSuccTime(), DateUtils.DATE_TIME_PATTERN));
  242. }
  243. if (orderProcessRecordEntity.getPaySuccTime() != null) {
  244. orderProcessRecordEntity.setPaySuccTimeStr(
  245. DateUtils.format(orderProcessRecordEntity.getPaySuccTime(), DateUtils.DATE_TIME_PATTERN));
  246. }
  247. if (orderProcessRecordEntity.getPayStartTime() != null) {
  248. orderProcessRecordEntity.setPayStartTimeStr(
  249. DateUtils.format(orderProcessRecordEntity.getPayStartTime(), DateUtils.DATE_TIME_PATTERN));
  250. }
  251. if (orderProcessRecordEntity.getPaymentStartTime() != null) {
  252. orderProcessRecordEntity.setPaymentStartTimeStr(
  253. DateUtils.format(orderProcessRecordEntity.getPaymentStartTime(), DateUtils.DATE_TIME_PATTERN));
  254. }
  255. if (orderProcessRecordEntity.getPaymentSuccTime() != null) {
  256. orderProcessRecordEntity.setPaymentSuccTimeStr(
  257. DateUtils.format(orderProcessRecordEntity.getPaymentSuccTime(), DateUtils.DATE_TIME_PATTERN));
  258. }
  259. }
  260. return R.ok().put("orderProcessRecordEntity", orderProcessRecordEntity);
  261. }
  262. /**
  263. * 打印小票
  264. *
  265. * @param id
  266. * @return
  267. */
  268. @RequestMapping("/printMsg")
  269. public R printMsg(@RequestBody Long id) {
  270. Ticket ticket = orderService.printMsg(id);
  271. return R.ok().put("ticket", ticket);
  272. }
  273. /**
  274. * 订单取消请求
  275. */
  276. @RequiresPermissions(value = {"order:refund"})
  277. @RequestMapping(value = "cancel", method = RequestMethod.POST)
  278. public Object cancel(Long orderId) {
  279. OrderEntity orderInfo = orderService.queryObject(orderId);
  280. if (null == orderInfo) {
  281. return R.error("订单不存在");
  282. }
  283. if (orderInfo.getOrderStatus() != 0) {
  284. return R.error("订单状态不支持取消");
  285. }
  286. orderService.cancelOrder(orderInfo);
  287. return R.ok();
  288. }
  289. /**
  290. * 订单退款请求
  291. */
  292. @RequiresPermissions(value = {"order:refund"})
  293. @RequestMapping(value = "refund", method = RequestMethod.POST)
  294. public Object refund(Long orderId, String refundId, BigDecimal refundMoney) {
  295. OrderEntity orderInfo = orderService.queryObject(orderId);
  296. if (null == orderInfo) {
  297. return R.error("订单不存在");
  298. }
  299. if (orderInfo.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_401.getItem()) ||
  300. orderInfo.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_402.getItem())) {
  301. return R.error("订单已退款");
  302. }
  303. Double totalActualPrice = orderService.getTotalActualPrice(orderInfo.getMerchOrderSn());
  304. if (totalActualPrice == null) {
  305. totalActualPrice = 0d;
  306. }
  307. OrderProcessRecordEntity processRecordEntity = orderProcessRecordService.queryObjectByOrderSn(orderInfo.getOrderSn());
  308. if(org.apache.commons.lang.StringUtils.isNotEmpty(processRecordEntity.getIsCustomsSend())) {
  309. if (processRecordEntity.getIsCustomsSend().equalsIgnoreCase("2")) {
  310. return R.error("订单正在清关中,不能退款");
  311. }
  312. if (processRecordEntity.getIsCustomsSend().equalsIgnoreCase("1")) {
  313. return R.error("订单已清关完成,不能退款");
  314. }
  315. }
  316. String refundResult = "";
  317. if (orderInfo.getOrderStatus() != Integer.parseInt(Dict.orderStatus.item_0.getItem())) {
  318. if (orderInfo.getPayFlag().equalsIgnoreCase(Dict.payFlag.item_wxglobalpay.getItem())) {
  319. refundResult = wxGlobalRefund(orderInfo, totalActualPrice);
  320. if (StringUtils.isNotBlank(refundResult)) {
  321. return R.error(refundResult);
  322. }
  323. } else if (orderInfo.getPayFlag().equalsIgnoreCase(Dict.payFlag.item_pingan.getItem())) {
  324. refundResult = pinganRefund(orderInfo, refundId);
  325. if (StringUtils.isNotBlank(refundResult)) {
  326. return R.error(refundResult);
  327. }
  328. } else{
  329. refundResult = wxRefund(orderInfo,totalActualPrice);
  330. if(StringUtils.isNotBlank(refundResult)){
  331. return R.error(refundResult);
  332. }
  333. }
  334. }
  335. return R.ok("退款成功");
  336. }
  337. /**
  338. * 平安申请退款
  339. * @param orderInfo
  340. * @return
  341. */
  342. private String pinganRefund(OrderEntity orderInfo, String refundId){
  343. Integer refundAmount = orderInfo.getActualPrice().multiply(new BigDecimal(100)).intValue();
  344. PinganResponseDto responseDto = PinganUtil.pinganPayRefund(orderInfo.getMerchOrderSn(), refundId, refundAmount, null);
  345. if (!Objects.isNull(responseDto)) {
  346. responseDto.setOutNo(orderInfo.getMerchOrderSn());
  347. responseDto.setCreateTime(new Date());
  348. pinganResponseService.save(responseDto);
  349. if ("0".equals(responseDto.getErrcode())) {
  350. JSONObject tradeResult = JSONObject.fromObject(responseDto.getDatajson());
  351. if (Dict.pinganRefundStatus.item_1.getItem().equals(tradeResult.getString("status"))) {
  352. orderService.pinganRefund(orderInfo, tradeResult, refundId);
  353. } else {
  354. OrderRefundEntity mallOrderRefund = orderRefundService.queryObjectByOrderId(orderInfo.getId());
  355. OrderRefundEntity orderRefund = new OrderRefundEntity();
  356. orderRefund.setRefundType(Integer.parseInt(Dict.RefundType.item_1.getItem()));
  357. orderRefund.setRefundMoney(BigDecimal.valueOf(orderInfo.getActualPrice().doubleValue()));
  358. orderRefund.setRefundStatus(Integer.parseInt(Dict.RefundStatus.item_4.getItem()));
  359. orderRefund.setModTime(new Date());
  360. orderRefund.setOutRefundNo(tradeResult.getString("ord_no"));
  361. if (mallOrderRefund != null) {
  362. orderRefund.setId(mallOrderRefund.getId());
  363. orderRefundService.update(orderRefund);//退款记录
  364. }
  365. OrderExceptionRecordEntity mallOrderExceptionRecord = new OrderExceptionRecordEntity();
  366. mallOrderExceptionRecord.setUserId(Integer.parseInt(orderInfo.getUserId() + ""));
  367. mallOrderExceptionRecord.setOrderSn(orderInfo.getOrderSn());
  368. mallOrderExceptionRecord.setExceptionStatus(Dict.exceptionStatus.item_03.getItem());
  369. mallOrderExceptionRecord.setExceptionContent("退款失败");
  370. mallOrderExceptionRecord.setCreateTime(new Date());
  371. orderExceptionRecordService.save(mallOrderExceptionRecord);
  372. return "发起平安支付退款失败!";
  373. }
  374. } else {
  375. return responseDto.getMsg();
  376. }
  377. }
  378. return "";
  379. }
  380. /**
  381. * 微信申请退款
  382. * @param orderInfo
  383. * @param totalActualPrice
  384. * @return
  385. */
  386. private String wxRefund(OrderEntity orderInfo,Double totalActualPrice){
  387. WechatRefundApiResult result = WechatUtil.wxRefund(orderInfo.getMerchOrderSn().toString(), totalActualPrice,
  388. orderInfo.getActualPrice().doubleValue());
  389. if (result.getResult_code().equals(WechatUtil.WXTradeState.SUCCESS.getCode())) {
  390. orderService.refund(orderInfo, result);
  391. } else {
  392. OrderRefundEntity mallOrderRefund = orderRefundService.queryObjectByOrderId(orderInfo.getId());
  393. OrderRefundEntity orderRefund = new OrderRefundEntity();
  394. orderRefund.setRefundType(Integer.parseInt(Dict.RefundType.item_1.getItem()));
  395. orderRefund.setRefundMoney(BigDecimal.valueOf(orderInfo.getActualPrice().doubleValue()));
  396. orderRefund.setRefundStatus(Integer.parseInt(Dict.RefundStatus.item_4.getItem()));
  397. orderRefund.setModTime(new Date());
  398. orderRefund.setOutRefundNo(result.getOut_refund_no());
  399. if (mallOrderRefund != null) {
  400. orderRefund.setId(mallOrderRefund.getId());
  401. orderRefundService.update(orderRefund);//退款记录
  402. }
  403. OrderExceptionRecordEntity mallOrderExceptionRecord = new OrderExceptionRecordEntity();
  404. mallOrderExceptionRecord.setUserId(Integer.parseInt(orderInfo.getUserId() + ""));
  405. mallOrderExceptionRecord.setOrderSn(orderInfo.getOrderSn());
  406. mallOrderExceptionRecord.setExceptionStatus(Dict.exceptionStatus.item_03.getItem());
  407. mallOrderExceptionRecord.setExceptionContent("退款失败" + result.getErr_code_des());
  408. mallOrderExceptionRecord.setCreateTime(new Date());
  409. orderExceptionRecordService.save(mallOrderExceptionRecord);
  410. return result.getErr_code_des();
  411. }
  412. return "";
  413. }
  414. /**
  415. * 微信国际申请退款
  416. * @param orderInfo
  417. * @param totalActualPrice
  418. * @return
  419. */
  420. private String wxGlobalRefund(OrderEntity orderInfo,Double totalActualPrice){
  421. WechatGlobalRefundApiResult result = WechatGlobalUtil.wxRefund(orderInfo.getMerchOrderSn().toString(), totalActualPrice,
  422. orderInfo.getActualPrice().doubleValue());
  423. if (result.getResult_code().equals(WechatUtil.WXTradeState.SUCCESS.getCode())) {
  424. orderService.globalRefund(orderInfo, result);
  425. } else {
  426. OrderRefundEntity mallOrderRefund = orderRefundService.queryObjectByOrderId(orderInfo.getId());
  427. OrderRefundEntity orderRefund = new OrderRefundEntity();
  428. orderRefund.setRefundType(Integer.parseInt(Dict.RefundType.item_1.getItem()));
  429. orderRefund.setRefundMoney(BigDecimal.valueOf(orderInfo.getActualPrice().doubleValue()));
  430. orderRefund.setRefundStatus(Integer.parseInt(Dict.RefundStatus.item_4.getItem()));
  431. orderRefund.setOutRefundNo(result.getOut_refund_no());
  432. orderRefund.setModTime(new Date());
  433. if (mallOrderRefund != null) {
  434. orderRefund.setId(mallOrderRefund.getId());
  435. orderRefundService.update(orderRefund);//退款记录
  436. }
  437. OrderExceptionRecordEntity mallOrderExceptionRecord = new OrderExceptionRecordEntity();
  438. mallOrderExceptionRecord.setUserId(Integer.parseInt(orderInfo.getUserId() + ""));
  439. mallOrderExceptionRecord.setOrderSn(orderInfo.getOrderSn());
  440. mallOrderExceptionRecord.setExceptionStatus(Dict.exceptionStatus.item_03.getItem());
  441. mallOrderExceptionRecord.setExceptionContent("退款失败" + result.getErr_code_des());
  442. mallOrderExceptionRecord.setCreateTime(new Date());
  443. orderExceptionRecordService.save(mallOrderExceptionRecord);
  444. return result.getErr_code_des();
  445. }
  446. return "";
  447. }
  448. /**
  449. * 订单退款请求
  450. */
  451. @RequiresPermissions(value = {"order:offilineRefund"})
  452. @RequestMapping(value = "offilineRefund", method = RequestMethod.POST)
  453. public Object offilineRefund(Long orderId) {
  454. OrderEntity orderInfo = orderService.queryObject(orderId);
  455. if (null == orderInfo) {
  456. return R.error("订单不存在");
  457. }
  458. if (orderInfo.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_401.getItem()) ||
  459. orderInfo.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_402.getItem())) {
  460. return R.error("订单已退款");
  461. }
  462. if (orderInfo.getOrderStatus() != Integer.parseInt(Dict.orderStatus.item_0.getItem())) {
  463. if (Dict.payFlag.item_cash.getItem().equals(orderInfo.getPayFlag())) {
  464. //现金支付,直接修改订单状态
  465. orderService.refund(orderInfo, null);
  466. } else if (Dict.payFlag.item_weixin.getItem().equals(orderInfo.getPayFlag())) {
  467. //微信线下扫码支付
  468. WechatRefundApiResult result = WechatUtil
  469. .wxRefund(orderInfo.getOrderSnWx(), orderInfo.getActualPrice().doubleValue(),
  470. orderInfo.getActualPrice().doubleValue());
  471. if (result.getResult_code().equals(WechatUtil.WXTradeState.SUCCESS.getCode())) {
  472. orderService.refund(orderInfo, result);
  473. } else {
  474. OrderRefundEntity mallOrderRefund = orderRefundService.queryObjectByOrderId(orderInfo.getId());
  475. OrderRefundEntity orderRefund = new OrderRefundEntity();
  476. orderRefund.setRefundType(Integer.parseInt(Dict.RefundType.item_1.getItem()));
  477. orderRefund.setRefundMoney(BigDecimal.valueOf(orderInfo.getActualPrice().doubleValue()));
  478. orderRefund.setRefundStatus(Integer.parseInt(Dict.RefundStatus.item_4.getItem()));
  479. orderRefund.setOutRefundNo(result.getOut_refund_no());
  480. orderRefund.setModTime(new Date());
  481. if (mallOrderRefund != null) {
  482. orderRefund.setId(mallOrderRefund.getId());
  483. orderRefundService.update(orderRefund);//退款记录
  484. }
  485. OrderExceptionRecordEntity mallOrderExceptionRecord = new OrderExceptionRecordEntity();
  486. mallOrderExceptionRecord.setUserId(Integer.parseInt(orderInfo.getUserId() + ""));
  487. mallOrderExceptionRecord.setOrderSn(orderInfo.getOrderSn());
  488. mallOrderExceptionRecord.setExceptionStatus(Dict.exceptionStatus.item_03.getItem());
  489. mallOrderExceptionRecord.setExceptionContent("退款失败" + result.getErr_code_des());
  490. mallOrderExceptionRecord.setCreateTime(new Date());
  491. orderExceptionRecordService.save(mallOrderExceptionRecord);
  492. return R.error(result.getErr_code_des());
  493. }
  494. }
  495. }
  496. return R.ok("退款成功");
  497. }
  498. /**
  499. * 获取首页展示信息--会员购买率相关
  500. *
  501. * @param params
  502. * @return
  503. */
  504. @RequestMapping("/getUserOrderInfo")
  505. public R getUserOrderInfo(@RequestParam Map<String, Object> params) {
  506. ParamUtils.setQueryPowerByRoleType(params, "storeId", "merchSn", "thirdPartyMerchCode");
  507. int result = orderService.getUserOrderInfo(params);
  508. return R.ok().put("result", result);
  509. }
  510. @RequiresPermissions(value = {"order:orderSubmit"})
  511. @RequestMapping(value = "orderSubmit", method = RequestMethod.POST)
  512. @ResponseBody
  513. public R orderSubmit(@RequestBody List<OfflineCartEntity> offlineCartEntityList) {
  514. Map resultObj = null;
  515. try {
  516. SysUserEntity user = ShiroUtils.getUserEntity();
  517. resultObj = orderService.orderSubmit(offlineCartEntityList, user);
  518. if (((Integer) resultObj.get("errno")) != 0) {
  519. return R.error((String) resultObj.get("errmsg"));
  520. }
  521. } catch (Exception e) {
  522. e.printStackTrace();
  523. }
  524. return R.ok("订单提交成功");
  525. }
  526. /**
  527. * 确认付款
  528. *
  529. * @param id
  530. * @return
  531. */
  532. @RequestMapping("/confirmPay")
  533. @RequiresPermissions("order:confirmPay")
  534. public R confirmPay(@RequestBody Long id) {
  535. orderService.confirmPay(id, Dict.payFlag.item_cash.getItem(), null);
  536. return R.ok();
  537. }
  538. @RequestMapping("/offilineOrderList")
  539. @RequiresPermissions("order:offilineOrderList")
  540. public R offilineOrderList(@RequestParam Map<String, Object> params) {
  541. ParamUtils.setQueryPowerByRoleType(params, "storeId", "merchSn", "thirdPartyMerchCode");
  542. //查询列表数据
  543. Query query = new Query(params);
  544. query.put("isOnfiilineOrder", Dict.isOnfflineOrder.item_1.getItem());
  545. List<OrderEntity> orderList = orderService.queryOffilineOrderList(query);
  546. int total = orderService.queryTotal(query);
  547. PageUtils pageUtil = new PageUtils(orderList, total, query.getLimit(), query.getPage());
  548. return R.ok().put("page", pageUtil);
  549. }
  550. @RequestMapping("/offlineInfos/{id}")
  551. @RequiresPermissions("order:offlineInfos")
  552. public R queryObjectBySysUser(@PathVariable("id") Long id) {
  553. OrderEntity order = orderService.queryObjectBySysUser(id);
  554. List<OrderWXPayRecordEntity> payRecords = orderWXPayRecordService.getRecordsByOutTradeNo(order.getOrderSn());
  555. order.setPayRecordList(payRecords);
  556. return R.ok().put("order", order);
  557. }
  558. @RequestMapping("/wxMicropayPay")
  559. @RequiresPermissions("order:wxMicropayPay")
  560. public R wxMicropayPay(Long id, String auth_code) {
  561. R r = null;
  562. SysUserEntity user = ShiroUtils.getUserEntity();
  563. if (user == null) {
  564. throw new RRException("用户登录超时,请重新登录");
  565. }
  566. if (!user.getRoleType().equalsIgnoreCase("2")) {
  567. throw new RRException("该操作只允许店员账户操作");
  568. }
  569. OrderEntity orderEntity = orderService.queryObject(id);
  570. if (orderEntity.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_201.getItem())) {
  571. throw new RRException("此订单已付款!");
  572. }
  573. if (orderEntity.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_301.getItem())) {
  574. throw new RRException("此订单已完成!");
  575. }
  576. if (orderEntity.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_101.getItem())) {
  577. throw new RRException("此订单已取消!");
  578. }
  579. if (orderEntity.getOrderStatus() == Integer.parseInt(Dict.orderStatus.item_102.getItem())) {
  580. throw new RRException("此订单已删除!");
  581. }
  582. //保存支付记录
  583. OrderWXPayRecordEntity orderWXPayRecordCurrent = orderWXPayRecordService.saveRecord(orderEntity);
  584. StoreEntity store = storeService.queryObject(orderEntity.getStoreId());
  585. WechatMicropayApiResult wechatMicropayApiResult = WechatUtil
  586. .wxMicropay(store.getMerchName() + "-" + store.getStoreName(), orderEntity.getOrderBizType(), null,
  587. orderWXPayRecordCurrent.getOutTradeNoWX(), orderEntity.getActualPrice().doubleValue(),
  588. "127.0.0.1", auth_code);
  589. orderWXPayRecordService.updateRecord(orderWXPayRecordCurrent.getId(), wechatMicropayApiResult);
  590. //当支付成功时,修改订单,并把其他支付记录撤销
  591. if (WechatUtil.WXTradeState.SUCCESS.getCode().equals(wechatMicropayApiResult.getTrade_state())) {
  592. //查询当前订单所有的支付记录
  593. List<OrderWXPayRecordEntity> orderWXPayRecordEntitys =
  594. orderWXPayRecordService.getRecordsByOutTradeNo(orderEntity.getOrderSn());
  595. for (OrderWXPayRecordEntity orderWXPayRecordTemp : orderWXPayRecordEntitys) {
  596. //查询出来的记录不等于当前记录,并且未撤销,未关闭时,撤销订单
  597. if (orderWXPayRecordTemp.getId() != orderWXPayRecordCurrent.getId() &&
  598. (!WechatUtil.WXTradeState.REVOKED.getCode().equals(orderWXPayRecordTemp.getTradeState()) ||
  599. !WechatUtil.WXTradeState.CLOSED.getCode().equals(orderWXPayRecordTemp.getTradeState()))) {
  600. WechatReverseApiResult wechatReverseApiResult =
  601. WechatUtil.wxReverse(orderWXPayRecordTemp.getOutTradeNoWX());
  602. //撤销订单成功
  603. if (WechatUtil.WXTradeState.SUCCESS.getCode().equals(wechatReverseApiResult.getReturn_code()) &&
  604. WechatUtil.WXTradeState.SUCCESS.getCode().equals(wechatReverseApiResult.getResult_code())) {
  605. //调用订单查询接口
  606. WechatRefundApiResult wechatRefundApiResult =
  607. WechatUtil.wxOrderQuery(orderWXPayRecordTemp.getOutTradeNoWX());
  608. if (WechatUtil.WXTradeState.SUCCESS.getCode().equals(wechatRefundApiResult.getReturn_code()) &&
  609. WechatUtil.WXTradeState.SUCCESS.getCode().equals(wechatRefundApiResult.getResult_code())) {
  610. // 修改订单支付记录
  611. orderWXPayRecordService
  612. .updateWXPayRecordTradeState(orderWXPayRecordTemp.getId(), wechatRefundApiResult);
  613. }
  614. }
  615. }
  616. }
  617. orderService.confirmPay(id, Dict.payFlag.item_weixin.getItem(), orderWXPayRecordCurrent.getOutTradeNoWX());
  618. r = R.ok();
  619. //用户支付中
  620. } else if (WechatUtil.WXTradeState.USERPAYING.getCode().equals(wechatMicropayApiResult.getTrade_state())) {
  621. r = R.error(WechatUtil.WXTradeState.USERPAYING.getCodeZn() + ",稍等片刻后请刷新页面重新查看订单状态");
  622. //用户支付失败
  623. } else if (WechatUtil.WXTradeState.PAYERROR.getCode().equals(wechatMicropayApiResult.getTrade_state())) {
  624. WechatReverseApiResult wechatReverseApiResult =
  625. WechatUtil.wxReverse(orderWXPayRecordCurrent.getOutTradeNoWX());
  626. //撤销订单成功
  627. if (WechatUtil.WXTradeState.SUCCESS.getCode().equals(wechatReverseApiResult.getReturn_code()) &&
  628. WechatUtil.WXTradeState.SUCCESS.getCode().equals(wechatReverseApiResult.getResult_code())) {
  629. //调用订单查询接口
  630. WechatRefundApiResult wechatRefundApiResult =
  631. WechatUtil.wxOrderQuery(orderWXPayRecordCurrent.getOutTradeNoWX());
  632. if (WechatUtil.WXTradeState.SUCCESS.getCode().equals(wechatRefundApiResult.getReturn_code()) &&
  633. WechatUtil.WXTradeState.SUCCESS.getCode().equals(wechatRefundApiResult.getResult_code())) {
  634. // 修改订单支付记录
  635. orderWXPayRecordService
  636. .updateWXPayRecordTradeState(orderWXPayRecordCurrent.getId(), wechatRefundApiResult);
  637. }
  638. r = R.error(orderWXPayRecordCurrent.getErrCodeDes());
  639. } else {
  640. r = R.error(wechatReverseApiResult.getErr_code_des());
  641. }
  642. }
  643. return r;
  644. }
  645. /**
  646. * 订单导出请求
  647. */
  648. @RequiresPermissions(value = {"order:export"})
  649. @RequestMapping(value = "export")
  650. public Object export(@RequestParam Map<String, Object> params, HttpServletResponse response, HttpServletRequest request) {
  651. ParamUtils.setQueryPowerByRoleType(params, "storeId", "merchSn", "thirdPartyMerchCode");
  652. //查询列表数据
  653. params.put("isOnfiilineOrder", Dict.isOnfflineOrder.item_0.getItem());
  654. String startTime = (String) params.get("startTime");
  655. String endTime = (String) params.get("endTime");
  656. if(org.apache.commons.lang.StringUtils.isNotEmpty(startTime)) {
  657. try {
  658. startTime = new String(startTime.getBytes("iso-8859-1"), "utf-8");
  659. } catch (Exception e) {
  660. e.printStackTrace();
  661. }
  662. startTime = DateUtils.getDate(startTime);
  663. params.put("startTime", startTime + " 00:00:00");
  664. }
  665. if(org.apache.commons.lang.StringUtils.isNotEmpty(endTime)) {
  666. try {
  667. endTime = new String(endTime.getBytes("iso-8859-1"), "utf-8");
  668. } catch (Exception e) {
  669. e.printStackTrace();
  670. }
  671. endTime = DateUtils.getDate(endTime);
  672. params.put("endTime", endTime + " 59:59:59");
  673. }
  674. List<OrderEntity> orderList = orderService.queryExportList(params);
  675. ExcelExport ee = new ExcelExport("订单信息");
  676. String[] header = new String[]{"订单编号","商户订单编号", "所属门店", "订单状态", "SKU", "商品名称", "数量", "销售价", "实际支付金额", "保税模式", "快递公司名称", "快递单编号", "海关清单编号", "收货人姓名", "收件人手机", "收件人省份", "收件人城市", "收件人区县", "收件人地址", "下单时间", "支付流水号"};
  677. List<Map<String, Object>> list = new ArrayList<>();
  678. if (orderList != null && orderList.size() != 0) {
  679. for (OrderEntity orderEntity : orderList) {
  680. LinkedHashMap<String, Object> map = new LinkedHashMap<>();
  681. Integer orderStatus = orderEntity.getOrderStatus();
  682. String orderBizType = orderEntity.getOrderBizType();
  683. map.put("OrderSn", orderEntity.getOrderSn());
  684. map.put("MerchOrderSn", orderEntity.getMerchOrderSn());
  685. map.put("StoreName", orderEntity.getStoreName());
  686. map.put("OrderStatus", StringUtils.isEmpty(orderStatus.toString())? "":Dict.orderStatus.valueOf("item_"+ orderStatus).getItemName());
  687. map.put("SKU", orderEntity.getSku());
  688. map.put("GoodsName", orderEntity.getGoodsName());
  689. map.put("Number", orderEntity.getNumber());
  690. map.put("RetailPrice", orderEntity.getRetailPrice());
  691. map.put("ActualPrice", orderEntity.getActualPrice());
  692. map.put("OrderBizType", StringUtils.isEmpty(orderBizType)? "":Dict.orderBizType.valueOf("item_"+orderBizType).getItemName());
  693. map.put("ShippingName", orderEntity.getShippingName());
  694. map.put("ShippingNo", orderEntity.getShippingNo());
  695. map.put("InvtNo", orderEntity.getOrderProcessRecord()==null?"":orderEntity.getOrderProcessRecord().getInvtNo());
  696. map.put("Consignee", orderEntity.getConsignee());
  697. map.put("Mobile", orderEntity.getMobile());
  698. map.put("Province", orderEntity.getProvince());
  699. map.put("City", orderEntity.getCity());
  700. map.put("District", orderEntity.getDistrict());
  701. map.put("Address", orderEntity.getAddress());
  702. map.put("OrderStartTime", orderEntity.getOrderProcessRecord()==null?"":DateUtils.format(orderEntity.getOrderProcessRecord().getAddOrderStartTime(),"yyyy-MM-dd HH:mm:ss"));
  703. map.put("PayId", orderEntity.getPayTransactionId());
  704. list.add(map);
  705. }
  706. }
  707. ee.addSheetByMap("订单信息", list, header);
  708. ee.export(response);
  709. return R.ok();
  710. }
  711. /**
  712. * 订单修改快递
  713. */
  714. @RequestMapping("/updateExpressInfo")
  715. @RequiresPermissions("order:updateExpressInfo")
  716. public Object updateExpressInfo(@RequestBody OrderEntity orderEntity) {
  717. OrderEntity orderInfo = orderService.queryObject(orderEntity.getId());
  718. if (orderInfo != null){
  719. OrderEntity order = new OrderEntity();
  720. order.setId(orderInfo.getId());
  721. order.setShippingName(orderEntity.getShippingName());
  722. order.setShippingCode(orderEntity.getShippingCode());
  723. order.setShippingNo(orderEntity.getShippingNo());
  724. order.setModerSn(ShiroUtils.getUserEntity().getUsername());
  725. order.setModTime(new Date());
  726. orderService.update(order);
  727. }
  728. return R.ok();
  729. }
  730. }