123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178 |
- 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<String, Object> params) {
- //查询列表数据
- Query query = new Query(params);
- List<GoodsTransportInfoDetailEntity> 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<String, Object> params) {
- List<GoodsTransportInfoDetailEntity> list = goodsTransportInfoDetailService.queryList(params);
- return R.ok().put("list", list);
- }
- /**
- * 根据是否在途和sku查询
- * @param params
- * @return
- */
- @GetMapping("/searchListByStatusAndSku")
- @ResponseBody
- public R searchListByStatusAndSku(@RequestParam Map<String, Object> 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<GoodsTransportInfoDetailEntity> 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<GoodsTransportInfoDetailExcelDto> goodsTransportInfoDetailExcelDtoList = new ArrayList<>();
- //上传文件
- try {
- GoodsTransportInfoDetailExcelDto goodsTransportInfoDetailExcelDto = new GoodsTransportInfoDetailExcelDto();
- Map<String, Object> beans = new HashMap<String, Object>();
- 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("导入成功!");
- }
- }
|