Mk2GoodsTopicPriceController.java 4.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146
  1. package com.kmall.admin.controller.mk;
  2. import java.text.ParseException;
  3. import java.util.ArrayList;
  4. import java.util.HashMap;
  5. import java.util.List;
  6. import java.util.Map;
  7. import com.kmall.admin.dto.StoreGoodsDto;
  8. import com.kmall.admin.dto.StoreTopicGoodsDto;
  9. import com.kmall.admin.entity.mk.Mk2GoodsTopicPriceEntity;
  10. import com.kmall.common.constant.JxlsXmlTemplateName;
  11. import com.kmall.common.utils.PageUtils;
  12. import com.kmall.common.utils.Query;
  13. import com.kmall.common.utils.R;
  14. import com.kmall.common.utils.excel.ExcelUtil;
  15. import org.apache.shiro.authz.annotation.RequiresPermissions;
  16. import org.springframework.beans.factory.annotation.Autowired;
  17. import org.springframework.stereotype.Controller;
  18. import org.springframework.web.bind.annotation.*;
  19. import com.kmall.admin.entity.mk.Mk2GoodsTopicPriceEntity;
  20. import com.kmall.admin.service.mk.Mk2GoodsTopicPriceService;
  21. import org.springframework.web.multipart.MultipartFile;
  22. /**
  23. * 商品活动价格表Controller
  24. *
  25. * @author emato
  26. * @email admin@qhdswl.com
  27. * @date 2020-06-15 10:44:07
  28. */
  29. @Controller
  30. @RequestMapping("mk2goodstopicprice")
  31. public class Mk2GoodsTopicPriceController {
  32. @Autowired
  33. private Mk2GoodsTopicPriceService mk2GoodsTopicPriceService;
  34. @Autowired
  35. private ExcelUtil excelUtil;
  36. /**
  37. * 查看列表
  38. */
  39. @RequestMapping("/list")
  40. // @RequiresPermissions("mk2goodstopicprice:list")
  41. @ResponseBody
  42. public R list(@RequestParam Map<String, Object> params) {
  43. //查询列表数据
  44. Query query = new Query(params);
  45. List<Mk2GoodsTopicPriceEntity> mk2GoodsTopicPriceList = mk2GoodsTopicPriceService.queryList(query);
  46. int total = mk2GoodsTopicPriceService.queryTotal(query);
  47. PageUtils pageUtil = new PageUtils(mk2GoodsTopicPriceList, total, query.getLimit(), query.getPage());
  48. return R.ok().put("page", pageUtil);
  49. }
  50. /**
  51. * 查看信息
  52. */
  53. @RequestMapping("/info/{mgthpId}")
  54. // @RequiresPermissions("mk2goodstopicprice:info")
  55. @ResponseBody
  56. public R info(@PathVariable("mgthpId") Integer mgthpId) {
  57. Mk2GoodsTopicPriceEntity mk2GoodsTopicPrice = mk2GoodsTopicPriceService.queryObject(mgthpId);
  58. return R.ok().put("mk2GoodsTopicPrice", mk2GoodsTopicPrice);
  59. }
  60. /**
  61. * 保存
  62. */
  63. @RequestMapping("/save")
  64. // @RequiresPermissions("mk2goodstopicprice:save")
  65. @ResponseBody
  66. public R save(@RequestBody Mk2GoodsTopicPriceEntity mk2GoodsTopicPrice) {
  67. mk2GoodsTopicPriceService.save(mk2GoodsTopicPrice);
  68. return R.ok();
  69. }
  70. /**
  71. * 修改
  72. */
  73. @RequestMapping("/update")
  74. // @RequiresPermissions("mk2goodstopicprice:update")
  75. @ResponseBody
  76. public R update(@RequestBody Mk2GoodsTopicPriceEntity mk2GoodsTopicPrice) {
  77. mk2GoodsTopicPriceService.update(mk2GoodsTopicPrice);
  78. return R.ok();
  79. }
  80. /**
  81. * 删除
  82. */
  83. @RequestMapping("/delete")
  84. // @RequiresPermissions("mk2goodstopicprice:delete")
  85. @ResponseBody
  86. public R delete(@RequestBody Integer[]mgthpIds) {
  87. mk2GoodsTopicPriceService.deleteBatch(mgthpIds);
  88. return R.ok();
  89. }
  90. /**
  91. * 查看所有列表
  92. */
  93. @RequestMapping("/queryAll")
  94. @ResponseBody
  95. public R queryAll(@RequestParam Map<String, Object> params) {
  96. List<Mk2GoodsTopicPriceEntity> list = mk2GoodsTopicPriceService.queryList(params);
  97. return R.ok().put("list", list);
  98. }
  99. @PostMapping("/goodsTopicPriceUpload")
  100. @ResponseBody
  101. public R storeUpload(@RequestParam("file") MultipartFile file) {
  102. List<StoreTopicGoodsDto> storeTopicGoodsDtoList = new ArrayList<>();//信息
  103. try {
  104. StoreTopicGoodsDto storeTopicGoodsDto = new StoreTopicGoodsDto();
  105. Map<String, Object> beans = new HashMap<String, Object>();
  106. beans.put("storeTopicGoodsDto", storeTopicGoodsDto);
  107. beans.put("storeTopicGoodsDtoList", storeTopicGoodsDtoList);
  108. if (file.isEmpty()) {
  109. return R.error("文件不能为空!");
  110. }
  111. excelUtil.readExcel(JxlsXmlTemplateName.STORE_TOPIC_DTO_LIST, beans, file.getInputStream());
  112. } catch (Exception e) {
  113. e.printStackTrace();
  114. return R.error("导入失败!");
  115. }
  116. try {
  117. mk2GoodsTopicPriceService.uploadExcel(storeTopicGoodsDtoList);
  118. } catch (ParseException e) {
  119. e.printStackTrace();
  120. return R.error("导入失败!");
  121. }
  122. //上传文件
  123. return R.ok("导入成功!");
  124. }
  125. }