MkActivitiesHalfPriceController.java 4.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145
  1. package com.kmall.admin.controller;
  2. import com.kmall.admin.dto.FullReductionDto;
  3. import com.kmall.admin.entity.MkActivitiesHalfPriceEntity;
  4. import com.kmall.admin.service.MkActivitiesFullReductionService;
  5. import com.kmall.admin.service.MkActivitiesHalfPriceService;
  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.excel.ExcelUtil;
  11. import org.springframework.beans.factory.annotation.Autowired;
  12. import org.springframework.stereotype.Controller;
  13. import org.springframework.web.bind.annotation.*;
  14. import org.springframework.web.multipart.MultipartFile;
  15. import java.util.ArrayList;
  16. import java.util.HashMap;
  17. import java.util.List;
  18. import java.util.Map;
  19. /**
  20. * 商品编码为主要匹配/上传依据,商品条形码为辅助查看而已活动方式满减,满xxx元立减xx元(xController
  21. *
  22. * @author emato
  23. * @email admin@qhdswl.com
  24. * @date 2020-09-23 10:43:25
  25. */
  26. @Controller
  27. @RequestMapping("mkactivitieshalfprice")
  28. public class MkActivitiesHalfPriceController {
  29. @Autowired
  30. private MkActivitiesHalfPriceService mkActivitiesFullReductionService;
  31. @Autowired
  32. private ExcelUtil excelUtil;
  33. /**
  34. * 查看列表
  35. */
  36. @RequestMapping("/list")
  37. // @RequiresPermissions("mkactivitiesfullreduction:list")
  38. @ResponseBody
  39. public R list(@RequestParam Map<String, Object> params) {
  40. //查询列表数据
  41. Query query = new Query(params);
  42. List<MkActivitiesHalfPriceEntity> mkActivitiesFullReductionList = mkActivitiesFullReductionService.queryList(query);
  43. int total = mkActivitiesFullReductionService.queryTotal(query);
  44. PageUtils pageUtil = new PageUtils(mkActivitiesFullReductionList, total, query.getLimit(), query.getPage());
  45. return R.ok().put("page", pageUtil);
  46. }
  47. /**
  48. * 查看信息
  49. */
  50. @RequestMapping("/info/{mafrId}")
  51. // @RequiresPermissions("mkactivitiesfullreduction:info")
  52. @ResponseBody
  53. public R info(@PathVariable("mafrId") Long mafrId) {
  54. MkActivitiesHalfPriceEntity mkActivitiesFullReduction = mkActivitiesFullReductionService.queryObject(mafrId);
  55. return R.ok().put("mkActivitiesFullReduction", mkActivitiesFullReduction);
  56. }
  57. /**
  58. * 保存
  59. */
  60. @RequestMapping("/save")
  61. // @RequiresPermissions("mkactivitiesfullreduction:save")
  62. @ResponseBody
  63. public R save(@RequestBody MkActivitiesHalfPriceEntity mkActivitiesFullReduction) {
  64. mkActivitiesFullReductionService.save(mkActivitiesFullReduction);
  65. return R.ok();
  66. }
  67. /**
  68. * 修改
  69. */
  70. @RequestMapping("/update")
  71. // @RequiresPermissions("mkactivitiesfullreduction:update")
  72. @ResponseBody
  73. public R update(@RequestBody MkActivitiesHalfPriceEntity mkActivitiesFullReduction) {
  74. mkActivitiesFullReductionService.update(mkActivitiesFullReduction);
  75. return R.ok();
  76. }
  77. /**
  78. * 删除
  79. */
  80. @RequestMapping("/delete")
  81. // @RequiresPermissions("mkactivitiesfullreduction:delete")
  82. @ResponseBody
  83. public R delete(@RequestBody Long[]mafrIds) {
  84. mkActivitiesFullReductionService.deleteBatch(mafrIds);
  85. return R.ok();
  86. }
  87. /**
  88. * 查看所有列表
  89. */
  90. @RequestMapping("/queryAll")
  91. @ResponseBody
  92. public R queryAll(@RequestParam Map<String, Object> params) {
  93. List<MkActivitiesHalfPriceEntity> list = mkActivitiesFullReductionService.queryList(params);
  94. return R.ok().put("list", list);
  95. }
  96. /**
  97. * 导入excel
  98. */
  99. @PostMapping("/upload")
  100. @ResponseBody
  101. public R storeUpload(@RequestParam("file") MultipartFile file, String storeId, String mkaId) {
  102. List<FullReductionDto> fullReductionDtoList = new ArrayList<>();//信息
  103. try {
  104. FullReductionDto fullReductionDto= new FullReductionDto();
  105. Map<String, Object> beans = new HashMap<String, Object>();
  106. beans.put("FullReductionDto", fullReductionDto);
  107. beans.put("FullReductionDtoList", fullReductionDtoList);
  108. if (file.isEmpty()) {
  109. return R.error("文件不能为空!");
  110. }
  111. excelUtil.readExcel(JxlsXmlTemplateName.HALF_PRICE_DTO_LIST, beans, file.getInputStream());
  112. } catch (Exception e) {
  113. e.printStackTrace();
  114. return R.error("导入失败!");
  115. }
  116. try {
  117. mkActivitiesFullReductionService.uploadExcel(fullReductionDtoList,storeId,mkaId);
  118. } catch (RuntimeException e){
  119. e.printStackTrace();
  120. return R.error(e.getMessage());
  121. }
  122. //上传文件
  123. return R.ok("导入成功!");
  124. }
  125. }