1
0

PayOrderInfoController.java 6.1 KB

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