package com.kmall.admin.controller; import java.util.*; import com.kmall.admin.dto.GoodsTransportInfoDetailExcelDto; import com.kmall.admin.entity.GoodsTransportInfoEntity; import com.kmall.admin.utils.ShiroUtils; import com.kmall.common.constant.JxlsXmlTemplateName; import com.kmall.common.utils.PageUtils; import com.kmall.common.utils.Query; import com.kmall.common.utils.R; import com.kmall.common.utils.RRException; import com.kmall.common.utils.excel.ExcelUtil; import org.apache.shiro.authz.annotation.RequiresPermissions; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.*; import com.kmall.admin.entity.GoodsTransportInfoDetailEntity; import com.kmall.admin.service.GoodsTransportInfoDetailService; import org.springframework.web.multipart.MultipartFile; /** * 在途商品明细表Controller * * @author emato * @email admin@qhdswl.com * @date 2020-06-15 18:19:23 */ @RestController @RequestMapping("goodstransportinfodetail") public class GoodsTransportInfoDetailController { @Autowired private GoodsTransportInfoDetailService goodsTransportInfoDetailService; @Autowired private ExcelUtil excelUtil; /** * 查看列表 */ @RequestMapping("/list") // @RequiresPermissions("goodstransportinfodetail:list") @ResponseBody public R list(@RequestParam Map params) { //查询列表数据 Query query = new Query(params); List goodsTransportInfoDetailList = goodsTransportInfoDetailService.queryList(query); int total = goodsTransportInfoDetailService.queryTotal(query); PageUtils pageUtil = new PageUtils(goodsTransportInfoDetailList, total, query.getLimit(), query.getPage()); return R.ok().put("page", pageUtil); } /** * 查看信息 */ @RequestMapping("/info/{transItemId}") // @RequiresPermissions("goodstransportinfodetail:info") @ResponseBody public R info(@PathVariable("transItemId") Integer transItemId) { GoodsTransportInfoDetailEntity goodsTransportInfoDetail = goodsTransportInfoDetailService.queryObject(transItemId); return R.ok().put("goodsTransportInfoDetail", goodsTransportInfoDetail); } /** * 保存 */ @RequestMapping("/save") // @RequiresPermissions("goodstransportinfodetail:save") @ResponseBody public R save(@RequestBody GoodsTransportInfoDetailEntity goodsTransportInfoDetail) { if (goodsTransportInfoDetail.getWayStatus()==null || goodsTransportInfoDetail.getSku() == null){ return R.error("是否在途和sku必须要填"); } goodsTransportInfoDetail.setCreateTime(new Date()); goodsTransportInfoDetail.setModTime(new Date()); goodsTransportInfoDetail.setTstm(new Date()); goodsTransportInfoDetail.setCreaterSn(ShiroUtils.getUserId().toString()); goodsTransportInfoDetail.setModerSn(ShiroUtils.getUserId().toString()); goodsTransportInfoDetailService.save(goodsTransportInfoDetail); return R.ok(); } /** * 修改 */ @RequestMapping("/update") // @RequiresPermissions("goodstransportinfodetail:update") @ResponseBody public R update(@RequestBody GoodsTransportInfoDetailEntity goodsTransportInfoDetail) { if (goodsTransportInfoDetail.getWayStatus()==null || goodsTransportInfoDetail.getSku() == null){ return R.error("是否在途和sku必须要填"); } goodsTransportInfoDetail.setModTime(new Date()); goodsTransportInfoDetail.setTstm(new Date()); goodsTransportInfoDetail.setModerSn(ShiroUtils.getUserId().toString()); goodsTransportInfoDetailService.update(goodsTransportInfoDetail); return R.ok(); } /** * 删除 */ @RequestMapping("/delete") // @RequiresPermissions("goodstransportinfodetail:delete") @ResponseBody public R delete(@RequestBody Integer[]transItemIds) { goodsTransportInfoDetailService.deleteBatch(transItemIds); return R.ok(); } /** * 查看所有列表 */ @RequestMapping("/queryAll") @ResponseBody public R queryAll(@RequestParam Map params) { List list = goodsTransportInfoDetailService.queryList(params); return R.ok().put("list", list); } /** * 根据是否在途和sku查询 * @param params * @return */ @GetMapping("/searchListByStatusAndSku") @ResponseBody public R searchListByStatusAndSku(@RequestParam Map params){ //查询列表数据 Query query = new Query(params); Integer wayStatus = null; if(params.get("wayStatus")!=null && !"".equals(params.get("wayStatus"))){ wayStatus = Integer.parseInt(params.get("wayStatus").toString()); } String sku = (String) params.get("sku"); List goodsTransportInfoDetailList = goodsTransportInfoDetailService.searchListByStatusAndSku(query,wayStatus,sku); int total = goodsTransportInfoDetailService.queryTotalByStatusAndSku(query,wayStatus,sku); PageUtils pageUtil = new PageUtils(goodsTransportInfoDetailList, total, query.getLimit(), query.getPage()); return R.ok().put("page", pageUtil); } /** * 上传文件 */ @PostMapping("/transInfoDetailUpload") @ResponseBody public R transInfoDetailUpload(@RequestParam("file") MultipartFile file) { List goodsTransportInfoDetailExcelDtoList = new ArrayList<>(); //上传文件 try { GoodsTransportInfoDetailExcelDto goodsTransportInfoDetailExcelDto = new GoodsTransportInfoDetailExcelDto(); Map beans = new HashMap(); beans.put("GoodsTransportInfoDetailExcelDto", goodsTransportInfoDetailExcelDto); beans.put("GoodsTransportInfoDetailExcelDtoList", goodsTransportInfoDetailExcelDtoList); if (file.isEmpty()) { return R.error("文件不能为空!"); } excelUtil.readExcel(JxlsXmlTemplateName.Goods_Transport_Info_Detail_Excel_Dto_List, beans, file.getInputStream()); } catch (Exception e) { e.printStackTrace(); return R.error("导入失败!"); } goodsTransportInfoDetailService.saveExcelDtoList(goodsTransportInfoDetailExcelDtoList); return R.ok("导入成功!"); } }