GoodsTransportInfoDetailController.java 6.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177
  1. package com.kmall.admin.controller;
  2. import java.util.*;
  3. import com.kmall.admin.dto.GoodsTransportInfoDetailExcelDto;
  4. import com.kmall.admin.entity.GoodsTransportInfoEntity;
  5. import com.kmall.admin.utils.ShiroUtils;
  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.apache.shiro.authz.annotation.RequiresPermissions;
  12. import org.springframework.beans.factory.annotation.Autowired;
  13. import org.springframework.stereotype.Controller;
  14. import org.springframework.web.bind.annotation.*;
  15. import com.kmall.admin.entity.GoodsTransportInfoDetailEntity;
  16. import com.kmall.admin.service.GoodsTransportInfoDetailService;
  17. import org.springframework.web.multipart.MultipartFile;
  18. /**
  19. * 在途商品明细表Controller
  20. *
  21. * @author emato
  22. * @email admin@qhdswl.com
  23. * @date 2020-06-15 18:19:23
  24. */
  25. @Controller
  26. @RequestMapping("goodstransportinfodetail")
  27. public class GoodsTransportInfoDetailController {
  28. @Autowired
  29. private GoodsTransportInfoDetailService goodsTransportInfoDetailService;
  30. @Autowired
  31. private ExcelUtil excelUtil;
  32. /**
  33. * 查看列表
  34. */
  35. @RequestMapping("/list")
  36. // @RequiresPermissions("goodstransportinfodetail:list")
  37. @ResponseBody
  38. public R list(@RequestParam Map<String, Object> params) {
  39. //查询列表数据
  40. Query query = new Query(params);
  41. List<GoodsTransportInfoDetailEntity> goodsTransportInfoDetailList = goodsTransportInfoDetailService.queryList(query);
  42. int total = goodsTransportInfoDetailService.queryTotal(query);
  43. PageUtils pageUtil = new PageUtils(goodsTransportInfoDetailList, total, query.getLimit(), query.getPage());
  44. return R.ok().put("page", pageUtil);
  45. }
  46. /**
  47. * 查看信息
  48. */
  49. @RequestMapping("/info/{transItemId}")
  50. // @RequiresPermissions("goodstransportinfodetail:info")
  51. @ResponseBody
  52. public R info(@PathVariable("transItemId") Integer transItemId) {
  53. GoodsTransportInfoDetailEntity goodsTransportInfoDetail = goodsTransportInfoDetailService.queryObject(transItemId);
  54. return R.ok().put("goodsTransportInfoDetail", goodsTransportInfoDetail);
  55. }
  56. /**
  57. * 保存
  58. */
  59. @RequestMapping("/save")
  60. // @RequiresPermissions("goodstransportinfodetail:save")
  61. @ResponseBody
  62. public R save(@RequestBody GoodsTransportInfoDetailEntity goodsTransportInfoDetail) {
  63. if (goodsTransportInfoDetail.getWayStatus()==null || goodsTransportInfoDetail.getSku() == null){
  64. return R.error("是否在途和sku必须要填");
  65. }
  66. goodsTransportInfoDetail.setCreateTime(new Date());
  67. goodsTransportInfoDetail.setModTime(new Date());
  68. goodsTransportInfoDetail.setTstm(new Date());
  69. goodsTransportInfoDetail.setCreaterSn(ShiroUtils.getUserId().toString());
  70. goodsTransportInfoDetail.setModerSn(ShiroUtils.getUserId().toString());
  71. goodsTransportInfoDetailService.save(goodsTransportInfoDetail);
  72. return R.ok();
  73. }
  74. /**
  75. * 修改
  76. */
  77. @RequestMapping("/update")
  78. // @RequiresPermissions("goodstransportinfodetail:update")
  79. @ResponseBody
  80. public R update(@RequestBody GoodsTransportInfoDetailEntity goodsTransportInfoDetail) {
  81. if (goodsTransportInfoDetail.getWayStatus()==null || goodsTransportInfoDetail.getSku() == null){
  82. return R.error("是否在途和sku必须要填");
  83. }
  84. goodsTransportInfoDetail.setModTime(new Date());
  85. goodsTransportInfoDetail.setTstm(new Date());
  86. goodsTransportInfoDetail.setModerSn(ShiroUtils.getUserId().toString());
  87. goodsTransportInfoDetailService.update(goodsTransportInfoDetail);
  88. return R.ok();
  89. }
  90. /**
  91. * 删除
  92. */
  93. @RequestMapping("/delete")
  94. // @RequiresPermissions("goodstransportinfodetail:delete")
  95. @ResponseBody
  96. public R delete(@RequestBody Integer[]transItemIds) {
  97. goodsTransportInfoDetailService.deleteBatch(transItemIds);
  98. return R.ok();
  99. }
  100. /**
  101. * 查看所有列表
  102. */
  103. @RequestMapping("/queryAll")
  104. @ResponseBody
  105. public R queryAll(@RequestParam Map<String, Object> params) {
  106. List<GoodsTransportInfoDetailEntity> list = goodsTransportInfoDetailService.queryList(params);
  107. return R.ok().put("list", list);
  108. }
  109. /**
  110. * 根据是否在途和sku查询
  111. * @param params
  112. * @return
  113. */
  114. @GetMapping("/searchListByStatusAndSku")
  115. @ResponseBody
  116. public R searchListByStatusAndSku(@RequestParam Map<String, Object> params){
  117. //查询列表数据
  118. Query query = new Query(params);
  119. Integer wayStatus = null;
  120. if(params.get("wayStatus")!=null && !"".equals(params.get("wayStatus"))){
  121. wayStatus = Integer.parseInt(params.get("wayStatus").toString());
  122. }
  123. String sku = (String) params.get("sku");
  124. List<GoodsTransportInfoDetailEntity> goodsTransportInfoDetailList = goodsTransportInfoDetailService.searchListByStatusAndSku(query,wayStatus,sku);
  125. int total = goodsTransportInfoDetailService.queryTotalByStatusAndSku(query,wayStatus,sku);
  126. PageUtils pageUtil = new PageUtils(goodsTransportInfoDetailList, total, query.getLimit(), query.getPage());
  127. return R.ok().put("page", pageUtil);
  128. }
  129. /**
  130. * 上传文件
  131. */
  132. @PostMapping("/transInfoDetailUpload")
  133. @ResponseBody
  134. public R transInfoDetailUpload(@RequestParam("file") MultipartFile file) {
  135. List<GoodsTransportInfoDetailExcelDto> goodsTransportInfoDetailExcelDtoList = new ArrayList<>();
  136. //上传文件
  137. try {
  138. GoodsTransportInfoDetailExcelDto goodsTransportInfoDetailExcelDto = new GoodsTransportInfoDetailExcelDto();
  139. Map<String, Object> beans = new HashMap<String, Object>();
  140. beans.put("GoodsTransportInfoDetailExcelDto", goodsTransportInfoDetailExcelDto);
  141. beans.put("GoodsTransportInfoDetailExcelDtoList", goodsTransportInfoDetailExcelDtoList);
  142. if (file.isEmpty()) {
  143. return R.error("文件不能为空!");
  144. }
  145. excelUtil.readExcel(JxlsXmlTemplateName.Goods_Transport_Info_Detail_Excel_Dto_List, beans, file.getInputStream());
  146. } catch (Exception e) {
  147. e.printStackTrace();
  148. return R.error("导入失败!");
  149. }
  150. goodsTransportInfoDetailService.saveExcelDtoList(goodsTransportInfoDetailExcelDtoList);
  151. return R.ok("导入成功!");
  152. }
  153. }