出库导出excel

pang.jiabao

8 天以前 c0a718538ba8661f235d524ed335cbf7b1919962

 src/main/java/com/zy/asrs/controller/ManLocDetlController.java

@@ -2,22 +2,22 @@

import com.alibaba.excel.EasyExcel;
import com.alibaba.excel.write.style.column.LongestMatchColumnWidthStyleStrategy;
import com.alibaba.fastjson.JSONArray;
import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.baomidou.mybatisplus.plugins.Page;
import com.core.annotations.ManagerAuth;
import com.core.common.Cools;
import com.core.common.DateUtils;
import com.core.common.R;
import com.zy.asrs.entity.LocDetl;
import com.zy.asrs.entity.LocDetlWarningDTO;
import com.zy.asrs.entity.ManLocDetl;
import com.zy.asrs.entity.Mat;
import com.zy.asrs.entity.*;
import com.zy.asrs.entity.param.LocDetlAdjustParam;
import com.zy.asrs.service.LocCheckService;
import com.zy.asrs.service.LocDetlService;
import com.zy.asrs.service.ManLocDetlService;
import com.zy.asrs.service.MatService;
import com.zy.common.web.BaseController;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
@@ -40,6 +40,20 @@

    @Autowired
    private MatService matService;

    @Autowired
    private LocCheckService locCheckService;

    @RequestMapping(value = "/manlocDetl/orderNo")
    @ManagerAuth
    public R locNoList(@RequestParam String orderNo){

        if (Cools.isEmpty(orderNo)){
            return R.error("无数据");
        }
        List<LocCheck> list = locCheckService.selectList(new EntityWrapper<LocCheck>().eq("order_no", orderNo));
        return R.ok(list);
    }

    @RequestMapping(value = "/manLocDetl/list/auth")
    @ManagerAuth
@@ -146,13 +160,47 @@
                .doWrite(list);
    }

    @RequestMapping(value = "/manlocDetl/updateStockFreeze/auth")
//    @RequestMapping(value = "/manlocDetl/updateStockFreeze/auth")
//    @ManagerAuth(memo = "库位冻结")
//    public R updateStockFreeze(ManLocDetl manLocDetl){
//        if (Cools.isEmpty(manLocDetl) || null==manLocDetl.getMatnr()){
//            return R.error();
//        }
//        manLocDetlService.updateStockFreeze(manLocDetl.getMatnr(), manLocDetl.getLocNo(), manLocDetl.getStockFreeze());
//        return R.ok();
//    }

    @RequestMapping(value = "/manlocDetl/updateStockFreeze")
    @ManagerAuth(memo = "库位冻结")
    public R updateStockFreeze(ManLocDetl manLocDetl){
        if (Cools.isEmpty(manLocDetl) || null==manLocDetl.getMatnr()){
            return R.error();
    public R updateStockFreeze(@RequestParam String param){
        List<ManLocDetl> list = JSONArray.parseArray(param, ManLocDetl.class);
        if (Cools.isEmpty(list)){
            return R.error("无数据");
        }
        manLocDetlService.updateStockFreeze(manLocDetl.getMatnr(), manLocDetl.getLocNo(), manLocDetl.getStockFreeze());
        return R.ok();
        for (ManLocDetl manLocDetl : list){
            manLocDetl.setStockFreeze(0);
            if (manLocDetlService.updateStockFreeze(manLocDetl.getMatnr(), manLocDetl.getLocNo(), manLocDetl.getStockFreeze()) != 1){
                return R.error(manLocDetl.getMatnr()+"冻结失败");
            }

        }
        return R.ok("冻结成功");
    }

    @RequestMapping(value = "/manlocDetl/updateStockDisFreeze")
    @ManagerAuth(memo = "库位解冻")
    public R updateStockDisFreeze(@RequestParam String param){
        List<ManLocDetl> list = JSONArray.parseArray(param, ManLocDetl.class);
        if (Cools.isEmpty(list)){
            return R.error("无数据");
        }
        for (ManLocDetl manLocDetl : list){
            manLocDetl.setStockFreeze(1);
            if (manLocDetlService.updateStockFreeze(manLocDetl.getMatnr(), manLocDetl.getLocNo(), manLocDetl.getStockFreeze()) != 1){
                return R.error(manLocDetl.getMatnr()+"解除冻结失败");
            }

        }
        return R.ok("解除冻结成功");
    }
}