1
0

PayOrderInfoController.java 7.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212
  1. package com.kmall.admin.controller.compared;
  2. import java.util.*;
  3. import com.kmall.admin.dto.AliPaymentOrderDto;
  4. import com.kmall.admin.dto.GoodsDto;
  5. import com.kmall.admin.dto.PayOrderDto;
  6. import com.kmall.admin.dto.WxPaymentOrderDto;
  7. import com.kmall.admin.entity.compared.ImportPayOrderRecordEntity;
  8. import com.kmall.admin.entity.compared.PayOrderInfoEntity;
  9. import com.kmall.admin.fromcomm.entity.SysUserEntity;
  10. import com.kmall.admin.service.compared.ImportPayOrderRecordService;
  11. import com.kmall.admin.service.compared.PayOrderInfoService;
  12. import com.kmall.admin.utils.ShiroUtils;
  13. import com.kmall.common.constant.Dict;
  14. import com.kmall.common.constant.JxlsXmlTemplateName;
  15. import com.kmall.common.utils.PageUtils;
  16. import com.kmall.common.utils.Query;
  17. import com.kmall.common.utils.R;
  18. import com.kmall.common.utils.excel.ExcelUtil;
  19. import org.apache.shiro.authz.annotation.RequiresPermissions;
  20. import org.springframework.beans.factory.annotation.Autowired;
  21. import org.springframework.stereotype.Controller;
  22. import org.springframework.web.bind.annotation.*;
  23. import org.springframework.web.multipart.MultipartFile;
  24. /**
  25. * Controller
  26. *
  27. * @author emato
  28. * @email admin@qhdswl.com
  29. * @date 2020-11-26 10:16:58
  30. */
  31. @Controller
  32. @RequestMapping("payorderinfo")
  33. public class PayOrderInfoController {
  34. @Autowired
  35. private PayOrderInfoService payOrderInfoService;
  36. @Autowired
  37. private ExcelUtil excelUtil;
  38. @Autowired
  39. private ImportPayOrderRecordService importPayOrderRecordService;
  40. /**
  41. * 查看列表
  42. */
  43. @RequestMapping("/list")
  44. // @RequiresPermissions("payorderinfo:list")
  45. @ResponseBody
  46. public R list(@RequestParam Map<String, Object> params) {
  47. //查询列表数据
  48. Query query = new Query(params);
  49. List<PayOrderInfoEntity> payOrderInfoList = payOrderInfoService.queryList(query);
  50. int total = payOrderInfoService.queryTotal(query);
  51. PageUtils pageUtil = new PageUtils(payOrderInfoList, total, query.getLimit(), query.getPage());
  52. return R.ok().put("page", pageUtil);
  53. }
  54. /**
  55. * 查看信息
  56. */
  57. @RequestMapping("/info/{mpoiId}")
  58. // @RequiresPermissions("payorderinfo:info")
  59. @ResponseBody
  60. public R info(@PathVariable("mpoiId") Integer mpoiId) {
  61. PayOrderInfoEntity payOrderInfo = payOrderInfoService.queryObject(mpoiId);
  62. return R.ok().put("payOrderInfo", payOrderInfo);
  63. }
  64. /**
  65. * 保存
  66. */
  67. @RequestMapping("/save")
  68. // @RequiresPermissions("payorderinfo:save")
  69. @ResponseBody
  70. public R save(@RequestBody PayOrderInfoEntity payOrderInfo) {
  71. payOrderInfoService.save(payOrderInfo);
  72. return R.ok();
  73. }
  74. /**
  75. * 修改
  76. */
  77. @RequestMapping("/update")
  78. // @RequiresPermissions("payorderinfo:update")
  79. @ResponseBody
  80. public R update(@RequestBody PayOrderInfoEntity payOrderInfo) {
  81. payOrderInfoService.update(payOrderInfo);
  82. return R.ok();
  83. }
  84. /**
  85. * 删除
  86. */
  87. @RequestMapping("/delete")
  88. // @RequiresPermissions("payorderinfo:delete")
  89. @ResponseBody
  90. public R delete(@RequestBody Integer[]mpoiIds) {
  91. payOrderInfoService.deleteBatch(mpoiIds);
  92. return R.ok();
  93. }
  94. /**
  95. * 查看所有列表
  96. */
  97. @RequestMapping("/queryAll")
  98. @ResponseBody
  99. public R queryAll(@RequestParam Map<String, Object> params) {
  100. List<PayOrderInfoEntity> list = payOrderInfoService.queryList(params);
  101. return R.ok().put("list", list);
  102. }
  103. /**
  104. * 上传文件
  105. */
  106. @RequestMapping("/uploadAlipayOrder")
  107. @ResponseBody
  108. public R uploadAlipayOrder(@RequestParam("file") MultipartFile file) {
  109. // List<PayOrderDto> payOrderDtoList = new ArrayList<>();// 支付订单信息
  110. List<AliPaymentOrderDto> aliPaymentOrderDtoList = new ArrayList<>();
  111. AliPaymentOrderDto aliPaymentOrderDto = new AliPaymentOrderDto();
  112. try {
  113. Map<String, Object> beans = new HashMap<String, Object>();
  114. // beans.put("PayOrderDtoList", payOrderDtoList);
  115. if (file.isEmpty()) {
  116. return R.error("文件不能为空!");
  117. }
  118. beans.put("AliPaymentOrderDto", aliPaymentOrderDto);
  119. beans.put("AliPaymentOrderDtoList", aliPaymentOrderDtoList);
  120. excelUtil.readExcel(JxlsXmlTemplateName.ALI_PAYMENT_ORDER_DTO_List, beans, file.getInputStream());
  121. // excelUtil.readExcel(JxlsXmlTemplateName.ALIPAY_PAY_ORDER_DTO_LIST, beans, file.getInputStream());
  122. } catch (Exception e) {
  123. e.printStackTrace();
  124. return R.error("导入失败!");
  125. }
  126. if(aliPaymentOrderDtoList == null || aliPaymentOrderDtoList.size() == 0){
  127. return R.error("报表格式有误");
  128. }
  129. try {
  130. saveRecord(file);
  131. } catch (Exception e) {
  132. e.printStackTrace();
  133. }
  134. // payOrderInfoService.uploadExcel(payOrderDtoList,Dict.payFlag.item_alipay.getItem());
  135. payOrderInfoService.uploadExceAli(aliPaymentOrderDtoList,Dict.payFlag.item_alipay.getItem());
  136. //上传文件
  137. return R.ok();
  138. }
  139. private void saveRecord(MultipartFile file) {
  140. SysUserEntity user = ShiroUtils.getUserEntity();
  141. ImportPayOrderRecordEntity importPayOrderRecordEntity = new ImportPayOrderRecordEntity();
  142. importPayOrderRecordEntity.setImporter(user.getUserId()+"");
  143. importPayOrderRecordEntity.setImportTime(new Date());
  144. importPayOrderRecordEntity.setCreaterSn(user.getUserId()+"");
  145. importPayOrderRecordEntity.setCreateTime(new Date());
  146. importPayOrderRecordEntity.setImportFileName(file.getOriginalFilename());
  147. importPayOrderRecordService.save(importPayOrderRecordEntity);
  148. }
  149. @RequestMapping("/uploadWXOrder")
  150. @ResponseBody
  151. public R uploadWXOrder(@RequestParam("file") MultipartFile file) {
  152. // List<PayOrderDto> payOrderDtoList = new ArrayList<>();// 支付订单信息
  153. List<WxPaymentOrderDto> wxPaymentOrderDtoList = new ArrayList<>();
  154. try {
  155. WxPaymentOrderDto wxPaymentOrderDto = new WxPaymentOrderDto();
  156. Map<String, Object> beans = new HashMap<String, Object>();
  157. // beans.put("PayOrderDtoList", payOrderDtoList);
  158. beans.put("WxPaymentOrderDto", wxPaymentOrderDto);
  159. beans.put("WxPaymentOrderDtoList", wxPaymentOrderDtoList);
  160. if (file.isEmpty()) {
  161. return R.error("文件不能为空!");
  162. }
  163. // excelUtil.readExcel(JxlsXmlTemplateName.WX_PAY_ORDER_DTO_LIST, beans, file.getInputStream());
  164. excelUtil.readExcel(JxlsXmlTemplateName.WX_PAYMENT_ORDER_DTO_List, beans, file.getInputStream());
  165. } catch (Exception e) {
  166. e.printStackTrace();
  167. return R.error("导入失败!");
  168. }
  169. if(wxPaymentOrderDtoList == null || wxPaymentOrderDtoList.size() == 0){
  170. return R.error("报表格式有误");
  171. }
  172. try {
  173. saveRecord(file);
  174. } catch (Exception e) {
  175. e.printStackTrace();
  176. }
  177. // payOrderInfoService.uploadExcel(payOrderDtoList,Dict.payFlag.item_weixin.getItem());
  178. payOrderInfoService.uploadExceWx(wxPaymentOrderDtoList,Dict.payFlag.item_weixin.getItem());
  179. //上传文件
  180. return R.ok();
  181. }
  182. }