MallPaymentOrderDataController.java 5.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169
  1. package com.kmall.admin.controller;
  2. import com.kmall.admin.entity.MallPaymentOrderDataEntity;
  3. import com.kmall.admin.service.MallPaymentOrderDataService;
  4. import com.kmall.admin.utils.ParamUtils;
  5. import com.kmall.common.constant.Dict;
  6. import com.kmall.common.constant.JxlsXmlTemplateName;
  7. import com.kmall.common.utils.PageUtils;
  8. import com.kmall.common.utils.Query;
  9. import com.kmall.common.utils.R;
  10. import com.kmall.common.utils.RRException;
  11. import com.kmall.common.utils.excel.ExcelUtil;
  12. import org.apache.shiro.authz.annotation.RequiresPermissions;
  13. import org.springframework.beans.factory.annotation.Autowired;
  14. import org.springframework.stereotype.Controller;
  15. import org.springframework.web.bind.annotation.*;
  16. import org.springframework.web.multipart.MultipartFile;
  17. import javax.servlet.http.HttpServletRequest;
  18. import javax.servlet.http.HttpServletResponse;
  19. import java.text.ParseException;
  20. import java.util.ArrayList;
  21. import java.util.HashMap;
  22. import java.util.List;
  23. import java.util.Map;
  24. /**
  25. * 支付订单表Controller
  26. *
  27. * @author emato
  28. * @email admin@qhdswl.com
  29. * @date 2021-04-22 14:54:43
  30. */
  31. @Controller
  32. @RequestMapping("mallpaymentorderdata")
  33. public class MallPaymentOrderDataController {
  34. @Autowired
  35. private MallPaymentOrderDataService mall2PaymentOrderDataService;
  36. @Autowired
  37. private ExcelUtil excelUtil;
  38. /**
  39. * 查看列表
  40. */
  41. @RequestMapping("/list")
  42. @RequiresPermissions("mallpaymentorderdata:list")
  43. @ResponseBody
  44. public R list(@RequestParam Map<String, Object> params) {
  45. //处理时间格式问题
  46. params = ParamUtils.setTimeMap(params);
  47. //查询列表数据
  48. Query query = new Query(params);
  49. List<MallPaymentOrderDataEntity> mall2PaymentOrderDataList = mall2PaymentOrderDataService.queryList(query);
  50. int total = mall2PaymentOrderDataService.queryTotal(query);
  51. PageUtils pageUtil = new PageUtils(mall2PaymentOrderDataList, total, query.getLimit(), query.getPage());
  52. return R.ok().put("page", pageUtil);
  53. }
  54. /**
  55. * 查看信息
  56. */
  57. @RequestMapping("/info/{payOrderId}")
  58. @RequiresPermissions("mallpaymentorderdata:info")
  59. @ResponseBody
  60. public R info(@PathVariable("payOrderId") Integer payOrderId) {
  61. MallPaymentOrderDataEntity mall2PaymentOrderData = mall2PaymentOrderDataService.queryObject(payOrderId);
  62. return R.ok().put("mallPaymentOrderData", mall2PaymentOrderData);
  63. }
  64. /**
  65. * 保存
  66. */
  67. @RequestMapping("/save")
  68. @RequiresPermissions("mallpaymentorderdata:save")
  69. @ResponseBody
  70. public R save(@RequestBody MallPaymentOrderDataEntity mall2PaymentOrderData) {
  71. mall2PaymentOrderDataService.save(mall2PaymentOrderData);
  72. return R.ok();
  73. }
  74. /**
  75. * 修改
  76. */
  77. @RequestMapping("/update")
  78. @RequiresPermissions("mallpaymentorderdata:update")
  79. @ResponseBody
  80. public R update(@RequestBody MallPaymentOrderDataEntity mall2PaymentOrderData) {
  81. mall2PaymentOrderDataService.update(mall2PaymentOrderData);
  82. return R.ok();
  83. }
  84. /**
  85. * 删除
  86. */
  87. @RequestMapping("/delete")
  88. @RequiresPermissions("mallpaymentorderdata:delete")
  89. @ResponseBody
  90. public R delete(@RequestBody Integer[]payOrderIds) {
  91. mall2PaymentOrderDataService.deleteBatch(payOrderIds);
  92. return R.ok();
  93. }
  94. /**
  95. * 查看所有列表
  96. */
  97. @RequestMapping("/queryAll")
  98. @ResponseBody
  99. public R queryAll(@RequestParam Map<String, Object> params) {
  100. List<MallPaymentOrderDataEntity> list = mall2PaymentOrderDataService.queryList(params);
  101. return R.ok().put("list", list);
  102. }
  103. @RequestMapping("/upload")
  104. @RequiresPermissions("mallpaymentorderdata:upload")
  105. @ResponseBody
  106. public R upload(@RequestParam("file") MultipartFile file,@RequestParam Map<String, Object> params) throws Exception {
  107. List<MallPaymentOrderDataEntity> list = new ArrayList<>();
  108. String payFlag = params.get("payFlag").toString();
  109. try {
  110. if (file.isEmpty()) {
  111. throw new RRException("上传文件不能为空");
  112. }
  113. MallPaymentOrderDataEntity mallPaymentOrderDataEntity = new MallPaymentOrderDataEntity();
  114. Map<String, Object> beans = new HashMap<String, Object>();
  115. beans.put("MallPaymentOrderDataEntity", mallPaymentOrderDataEntity);
  116. beans.put("MallPaymentOrderDataEntityList", list);
  117. if (Dict.payFlag.item_weixin.getItem().equals(payFlag)) {
  118. excelUtil.readExcel(JxlsXmlTemplateName.WX_PAYMENT_ORDER_DTO_List, beans, file.getInputStream());
  119. }else if (Dict.payFlag.item_alipay.getItem().equals(payFlag)){
  120. excelUtil.readExcel(JxlsXmlTemplateName.ALI_PAYMENT_ORDER_DTO_List, beans, file.getInputStream());
  121. }
  122. }catch (Exception e) {
  123. e.printStackTrace();
  124. return R.error("导入失败!");
  125. }
  126. try {
  127. mall2PaymentOrderDataService.saveUploadExcel(list, payFlag);
  128. } catch (Exception e) {
  129. e.printStackTrace();
  130. return R.error(e.getMessage());
  131. }
  132. return R.ok("导入成功!");
  133. }
  134. /**
  135. * System Format 导出请求
  136. */
  137. @RequestMapping(value = "exportDataFormat")
  138. @RequiresPermissions("mallpaymentorderdata:exportDataFormat")
  139. @ResponseBody
  140. public R exportSystemFormat(@RequestParam Map<String, Object> params, HttpServletResponse response, HttpServletRequest request) throws ParseException {
  141. params = ParamUtils.setTimeMap(params);
  142. mall2PaymentOrderDataService.exportDataFormatList(params,response);
  143. return R.ok();
  144. }
  145. }