GoodsTransportInfoDetailController.java 6.5 KB

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