一. 效果图
二.Java部分
1.1 Controller部分
package com.ruoyi.web.controller.gson.warehousemanagement; import com.alibaba.druid.support.json.JSONUtils; import com.alibaba.fastjson2.JSON; import com.ruoyi.common.config.RuoYiConfig; import com.ruoyi.common.constant.PathConstant; import com.ruoyi.common.core.controller.BaseController; import com.ruoyi.common.core.domain.AjaxResult; import com.ruoyi.common.core.page.TableDataInfo; import com.ruoyi.common.enums.ErrCode; import com.ruoyi.common.exception.ServiceException; import com.ruoyi.common.exception.SwException; import com.ruoyi.common.utils.FormExcelUtil; import com.ruoyi.common.utils.SecurityUtils; import com.ruoyi.common.utils.file.FileUtils; import com.ruoyi.common.utils.ValidUtils; import com.ruoyi.system.domain.Cbpi; import com.ruoyi.system.domain.Cbpm; import com.ruoyi.system.domain.dto.*; import com.ruoyi.system.domain.vo.*; import com.ruoyi.system.service.gson.BaseCheckService; import com.ruoyi.system.service.gson.TakeGoodsService; import io.swagger.annotations.Api; import io.swagger.annotations.ApiOperation; import com.ruoyi.web.utils.Excel2PdfUtil; import com.ruoyi.web.utils.FileCopyUtils; import io.swagger.annotations.Api; import io.swagger.annotations.ApiOperation; import io.swagger.annotations.ApiParam; import lombok.extern.slf4j.Slf4j; import org.apache.commons.lang3.exception.ExceptionUtils; import org.apache.poi.ss.formula.functions.T; import org.apache.poi.xssf.usermodel.XSSFSheet; import org.apache.poi.xssf.usermodel.XSSFWorkbook; import org.springframework.http.MediaType; import org.springframework.security.access.prepost.PreAuthorize; import org.springframework.validation.BindingResult; import org.springframework.web.bind.annotation.*; import javax.annotation.Resource; import javax.servlet.http.HttpServletResponse; import java.io.*; import java.util.ArrayList; import javax.validation.Valid; import java.util.List; /** * ClassName TakeGoodsController * Description * Create by gfy * Date 2022/8/10 16:56 */ @RestController @RequestMapping("/whmanagement") @Api( tags = {"提货单模块"} ) @Slf4j public class TakeGoodsController extends BaseController { @Resource private TakeGoodsService takeGoodsService; /** * 导出提货单excel详情 */ @ApiOperation( value ="导出提货单excel详情", notes = "导出提货单excel详情") @PostMapping("/exportDetail") public void exportDetail(@RequestParam Integer id, HttpServletResponse response){ String excelPaht=""; try { long time = System.currentTimeMillis(); TakeGoodsOrderDetailVo res = takeGoodsService.takeOrderDetail(id); InputStream in = null; XSSFWorkbook wb = null; // in =Thread.currentThread().getContextClassLoader().getResourceAsStream("D:\\data\\模板.xlsx"); excelPaht = RuoYiConfig.getSwprofile() + "提货单_" + res.getOrderNo() + time + ".xlsx"; File is = new File(RuoYiConfig.getSwprofile()+ PathConstant.TAKE_ORDER_DETAIL_EXCEL); wb = new XSSFWorkbook(is); genarateReports(wb, res); String orderNo = res.getOrderNo(); saveExcelToDisk(wb, excelPaht); FileUtils.setAttachmentResponseHeader(response, "提货单_"+res.getOrderNo()+time+".xlsx"); FileUtils.writeBytes(excelPaht, response.getOutputStream()); } catch (SwException e) { // return AjaxResult.error((int) ErrCode.SYS_PARAMETER_ERROR.getErrCode(), e.getMessage()); } catch (Exception e) { log.error("【导出提货单excel详情】接口出现异常,参数${}$,异常${}$", JSON.toJSON(getUserId()), ExceptionUtils.getStackTrace(e)); // return AjaxResult.error((int) ErrCode.UNKNOW_ERROR.getErrCode(), "操作失败"); }finally { FileUtils.deleteFile(excelPaht); } } private static void saveExcelToDisk(XSSFWorkbook wb, String filePath){ File file = new File(filePath); OutputStream os=null; try { os = new FileOutputStream(file); wb.write(os); os.flush(); } catch (FileNotFoundException e) { e.printStackTrace(); } catch (IOException e) { e.printStackTrace(); } finally { try {if(os!=null) { os.close(); } } catch (IOException e) { log.error("error", e);} } } //导入模板2 private static void genarateReports(XSSFWorkbook wb, TakeGoodsOrderDetailVo res) { XSSFSheet sheet1 = wb.getSheetAt(0); // XSSFSheet sheet2 = wb.getSheetAt(1); // 设置公式自动读取，没有这行代码，excel模板中的公式不会自动计算 sheet1.setForceFormulaRecalculation(true); // sheet2.setForceFormulaRecalculation(true); /***设置单个单元格内容*********************************/ // FormExcelUtil.setCellData(sheet1, "2020-07报告", 1, 1); /***第一个表格*********************************/ // ExampleData ea = new ExampleData(); // List<List<Object>> data1 = ea.getData1(10); int addRows=0; //动态插入行 //FormExcelUtil.insertRowsStyleBatch(sheet, startNum, insertRows, styleRow, styleColStart, styleColEnd) //按照styleRow行的格式，在startNum行后添加insertRows行，并且针对styleColStart~ styleColEnd列同步模板行styleRow的格式 // FormExcelUtil.insertRowsStyleBatch(sheet1, 4+addRows, 21, 4, 1, 4); FormExcelUtil.setCellData(sheet1,res.getOrderNo(),4,2); FormExcelUtil.setCellData(sheet1,res.getCustomerNo(),4,4); FormExcelUtil.setCellData(sheet1,res.getOrderDateMsg(),4,7); FormExcelUtil.setCellData(sheet1,res.getCustomerName(),5,2); FormExcelUtil.setCellData(sheet1,res.getWhName(),5,4); FormExcelUtil.setCellData(sheet1,res.getSaleUserName(),5,7); // FormExcelUtil.setCellData(sheet1,res.getSaleUser(),5,4); // FormExcelUtil.setCellData(sheet1,res.getCurrency(),5,6); FormExcelUtil.setCellData(sheet1,res.getContacts(),6,2); FormExcelUtil.setCellData(sheet1,res.getPhone(),6,4); FormExcelUtil.setCellData(sheet1,res.getCurrencyMsg(),7,2); FormExcelUtil.setCellData(sheet1,res.getReceiver(),7,4); FormExcelUtil.setCellData(sheet1,res.getReceivPhone(),8,2); FormExcelUtil.setCellData(sheet1,res.getReceiveAdress(),8,4); FormExcelUtil.setCellData(sheet1,res.getUserName(),15,2); FormExcelUtil.setCellData(sheet1,res.getAuditUserName(),15,4); Double sumQty = res.getSumQty()==null?0:res.getSumQty(); FormExcelUtil.setCellData(sheet1,sumQty,11,4); List<TakeOrderGoodsVo> goods = res.getGoods(); List<List<Object>> data1=new ArrayList<>(); for (int i=0;i<goods.size();i++) { List<Object> rlist=new ArrayList<>(); // SaleOrderSkuVo res=new SaleOrderSkuVo(); // res.setGoodsName("aa"); rlist.add(goods.get(i).getBrand()); rlist.add(goods.get(i).getModel()); rlist.add(goods.get(i).getDescription()); // rlist.add(""); rlist.add(goods.get(i).getQty()); rlist.add(goods.get(i).getScanQty()); rlist.add(goods.get(i).getRemark()); data1.add(rlist); } // FormExcelUtil.insertRowsStyleBatch(sheet, startNum, insertRows, styleRow, styleColStart, styleColEnd) FormExcelUtil.insertRowsStyleBatch(sheet1, 10, data1.size(), 4, 1, 7); FormExcelUtil.setTableData(sheet1, data1, 10, 1); // addRows += data1.size()-2; /***第二个表格*********************************/ // List<List<Object>> data2 = ea.getData2(); // FormExcelUtil.insertRowsStyleBatch(sheet1, 10+addRows, data2.size()-2, 10+addRows, 1, 6); // FormExcelUtil.setTableData(sheet1, data2, 10+addRows, 1); // addRows += data2.size()-2; // /***第三个表格*********************************/ // List<List<Object>> data3 = ea.getData3(); // FormExcelUtil.setTableData(sheet2, data3, 3, 1); } /** * 销售提货单打印 */ @ApiOperation( value ="销售提货单打印", notes = "销售提货单打印" ) @PostMapping("/printTakeOrderOrder") public void printTakeOrderOrder( @RequestParam Integer id,HttpServletResponse response) throws IOException { InputStream in = null; String excelPaht=""; String excelPaht2=""; String pdfPath=""; XSSFWorkbook wb = null; try { long time = System.currentTimeMillis(); TakeGoodsOrderDetailVo res = takeGoodsService.takeOrderDetail(id); // in =Thread.currentThread().getContextClassLoader().getResourceAsStream("D:\\data\\模板.xlsx"); excelPaht = RuoYiConfig.getSwprofile() + "提货单_" + res.getOrderNo() + time + ".xlsx"; // FileCopyUtils.copyFile(RuoYiConfig.getSwprofile()+ PathConstant.TAKE_ORDER_DETAIL_EXCEL,excelPaht); // File is = new File(RuoYiConfig.getSwprofile()); excelPaht2 = RuoYiConfig.getSwprofile() + "模板提货单_" + res.getOrderNo() + time + ".xlsx"; FileCopyUtils.copyFile(new File(RuoYiConfig.getSwprofile()+ PathConstant.TAKE_ORDER_SUGGEST_EXCEL),new File(excelPaht2)); File is = new File(excelPaht2); // wb = new XSSFWorkbook(is); genarateReports(wb, res); String orderNo = res.getOrderNo(); saveExcelToDisk(wb, excelPaht); //转成pdf pdfPath=RuoYiConfig.getSwprofile()+"提货单详情_"+res.getOrderNo()+time+".pdf"; Excel2PdfUtil.excel2pdf(excelPaht,pdfPath); // in=new FileInputStream(new File(pdfPath)); // in.close(); // response.reset(); // response.setCharacterEncoding("UTF-8"); // // 定义输出类型 // response.setContentType("application/octet-stream"); // response.setHeader("content-type", "application/octet-stream"); response.setHeader("Content-Disposition", "attachment; filename=" + "销售订单_"+res.getOrderNo()+time+".pdf"); // response.setHeader("Content-Disposition", "attachment;fileName=" + "销售订单_"+res.getOrderNo()+time+".pdf");// 设置文件名 IOUtils.copy(in,response.getOutputStream()); // StreamUtils.copy(in,response.getOutputStream()); // response.getOutputStream().flush(); // return null; response.setContentType(MediaType.APPLICATION_OCTET_STREAM_VALUE); FileUtils.setAttachmentResponseHeader(response, "提货单详情_"+res.getOrderNo()+time+".pdf"); FileUtils.writeBytes(pdfPath, response.getOutputStream()); } catch (SwException e) { // return AjaxResult.error((int) ErrCode.SYS_PARAMETER_ERROR.getErrCode(), e.getMessage()); } catch (Exception e) { log.error("【销售提货单打印】接口出现异常,参数${}$,异常${}$", JSONUtils.toJSONString(id), ExceptionUtils.getStackTrace(e)); // return AjaxResult.error((int) ErrCode.UNKNOW_ERROR.getErrCode(), "操作失败"); }finally { if(in!=null){ in.close(); } if(wb!=null){ wb.close(); } if(excelPaht!=null){ FileUtils.deleteFile(excelPaht); } if(excelPaht2!=null){ FileUtils.deleteFile(excelPaht2); } if(pdfPath!=null){ FileUtils.deleteFile(pdfPath); } } } /** * 提货单出库建议打印 */ @ApiOperation( value ="提货单出库建议打印", notes = "提货单出库建议打印" ) @PostMapping("/printTakeOrderSuggest") public void printTakeOrderSuggest( @RequestParam Integer id,HttpServletResponse response) throws IOException { InputStream in = null; String excelPaht=""; String excelPaht2=""; String pdfPath=""; XSSFWorkbook wb = null; try { long time = System.currentTimeMillis(); TakeGoodsOrderDetailVo res = takeGoodsService.takeOrderDetail(id); // in =Thread.currentThread().getContextClassLoader().getResourceAsStream("D:\\data\\模板.xlsx"); excelPaht = RuoYiConfig.getSwprofile() + "提货单_出库建议表_" + res.getOrderNo() + time + ".xlsx"; // FileCopyUtils.copyFile(RuoYiConfig.getSwprofile()+ PathConstant.TAKE_ORDER_DETAIL_EXCEL,excelPaht); // File is = new File(RuoYiConfig.getSwprofile()+ PathConstant.TAKE_ORDER_SUGGEST_EXCEL); excelPaht2 = RuoYiConfig.getSwprofile() + "模板提货单_出库建议表_" + res.getOrderNo() + time + ".xlsx"; FileCopyUtils.copyFile(new File(RuoYiConfig.getSwprofile()+ PathConstant.TAKE_ORDER_SUGGEST_EXCEL),new File(excelPaht2)); // File is = new File(RuoYiConfig.getSwprofile()+ PathConstant.TAKE_ORDER_SCANLOG_EXCEL); File is = new File(excelPaht2); wb = new XSSFWorkbook(is); genarateSuggestReports(wb, res); String orderNo = res.getOrderNo(); saveExcelToDisk(wb, excelPaht); //转成pdf pdfPath=RuoYiConfig.getSwprofile()+"提货单出库建议_"+res.getOrderNo()+".pdf"; Excel2PdfUtil.excel2pdf(excelPaht,pdfPath); // in=new FileInputStream(new File(pdfPath)); // in.close(); // response.reset(); // response.setCharacterEncoding("UTF-8"); // // 定义输出类型 // response.setContentType("application/octet-stream"); // response.setHeader("content-type", "application/octet-stream"); response.setHeader("Content-Disposition", "attachment; filename=" + "销售订单_"+res.getOrderNo()+time+".pdf"); // response.setHeader("Content-Disposition", "attachment;fileName=" + "销售订单_"+res.getOrderNo()+time+".pdf");// 设置文件名 IOUtils.copy(in,response.getOutputStream()); // StreamUtils.copy(in,response.getOutputStream()); // response.getOutputStream().flush(); // return null; response.setContentType(MediaType.APPLICATION_OCTET_STREAM_VALUE); FileUtils.setAttachmentResponseHeader(response, "提货单出库建议_"+res.getOrderNo()+".pdf"); FileUtils.writeBytes(pdfPath, response.getOutputStream()); return; } catch (SwException e) { // return AjaxResult.error((int) ErrCode.SYS_PARAMETER_ERROR.getErrCode(), e.getMessage()); } catch (Exception e) { log.error("【提货单出库建议打印】接口出现异常,参数${}$,异常${}$", JSONUtils.toJSONString(id), ExceptionUtils.getStackTrace(e)); // return AjaxResult.error((int) ErrCode.UNKNOW_ERROR.getErrCode(), "操作失败"); }finally { if(in!=null){ in.close(); } if(wb!=null){ wb.close(); } if(excelPaht!=null){ FileUtils.deleteFile(excelPaht); } if(excelPaht2!=null){ FileUtils.deleteFile(excelPaht2); } if(pdfPath!=null){ FileUtils.deleteFile(pdfPath); } } } private void genarateSuggestReports(XSSFWorkbook wb, TakeGoodsOrderDetailVo re) { XSSFSheet sheet1 = wb.getSheetAt(0); // XSSFSheet sheet2 = wb.getSheetAt(1); // 设置公式自动读取，没有这行代码，excel模板中的公式不会自动计算 sheet1.setForceFormulaRecalculation(true); // sheet2.setForceFormulaRecalculation(true); /***设置单个单元格内容*********************************/ // FormExcelUtil.setCellData(sheet1, "2020-07报告", 1, 1); /***第一个表格*********************************/ // ExampleData ea = new ExampleData(); // List<List<Object>> data1 = ea.getData1(10); int addRows=0; //动态插入行 //FormExcelUtil.insertRowsStyleBatch(sheet, startNum, insertRows, styleRow, styleColStart, styleColEnd) //按照styleRow行的格式，在startNum行后添加insertRows行，并且针对styleColStart~ styleColEnd列同步模板行styleRow的格式 // FormExcelUtil.insertRowsStyleBatch(sheet1, 4+addRows, 21, 4, 1, 4); FormExcelUtil.setCellData(sheet1,re.getCustomerName(),2,2); FormExcelUtil.setCellData(sheet1,re.getOrderNo(),2,6); List<TakeOrderSugestVo> goods = re.getSugests(); List<List<Object>> data1=new ArrayList<>(); for (int i=0;i<goods.size();i++) { List<Object> rlist=new ArrayList<>(); // SaleOrderSkuVo res=new SaleOrderSkuVo(); // res.setGoodsName("aa"); rlist.add(goods.get(i).getNumber()); rlist.add(goods.get(i).getGoodClass()); rlist.add(goods.get(i).getBrand()); rlist.add(goods.get(i).getModel()); rlist.add(goods.get(i).getDescription()); rlist.add(goods.get(i).getSn()); rlist.add(goods.get(i).getSku()); rlist.add(goods.get(i).getScanStatus()); // rlist.add(""); data1.add(rlist); } // FormExcelUtil.insertRowsStyleBatch(sheet, startNum, insertRows, styleRow, styleColStart, styleColEnd) FormExcelUtil.insertRowsStyleBatch(sheet1, 4, data1.size(), 3, 1, 8); FormExcelUtil.setTableData(sheet1, data1, 4, 1); // addRows += data1.size()-2; /***第二个表格*********************************/ // List<List<Object>> data2 = ea.getData2(); // FormExcelUtil.insertRowsStyleBatch(sheet1, 10+addRows, data2.size()-2, 10+addRows, 1, 6); // FormExcelUtil.setTableData(sheet1, data2, 10+addRows, 1); // addRows += data2.size()-2; // /***第三个表格*********************************/ // List<List<Object>> data3 = ea.getData3(); // FormExcelUtil.setTableData(sheet2, data3, 3, 1); } /** * 提货单扫码记录打印 */ @ApiOperation( value ="提货单扫码记录打印", notes = "提货单扫码记录打印" ) @PostMapping("/printTakeOrderScanLog") public void printTakeOrderScanLog( @RequestParam Integer id,HttpServletResponse response) throws IOException { InputStream in = null; String excelPaht=""; String excelPaht2=""; String pdfPath=""; XSSFWorkbook wb = null; try { long time = System.currentTimeMillis(); TakeGoodsOrderDetailVo res = takeGoodsService.takeOrderDetail(id); // in =Thread.currentThread().getContextClassLoader().getResourceAsStream("D:\\data\\模板.xlsx"); excelPaht = RuoYiConfig.getSwprofile() + "提货单_扫描记录表" + res.getOrderNo() + time + ".xlsx"; excelPaht2 = RuoYiConfig.getSwprofile() + "模板提货单_扫描记录表" + res.getOrderNo() + time + ".xlsx"; FileCopyUtils.copyFile(new File(RuoYiConfig.getSwprofile()+ PathConstant.TAKE_ORDER_SCANLOG_EXCEL),new File(excelPaht2)); // File is = new File(RuoYiConfig.getSwprofile()+ PathConstant.TAKE_ORDER_SCANLOG_EXCEL); File is = new File(excelPaht2); wb = new XSSFWorkbook(is); genarateScanLogReports(wb, res); String orderNo = res.getOrderNo(); saveExcelToDisk(wb, excelPaht); //转成pdf pdfPath=RuoYiConfig.getSwprofile()+"提货单扫描记录_"+res.getOrderNo()+".pdf"; Excel2PdfUtil.excel2pdf(excelPaht,pdfPath); // in=new FileInputStream(new File(pdfPath)); // in.close(); // response.reset(); // response.setCharacterEncoding("UTF-8"); // // 定义输出类型 // response.setContentType("application/octet-stream"); // response.setHeader("content-type", "application/octet-stream"); response.setHeader("Content-Disposition", "attachment; filename=" + "销售订单_"+res.getOrderNo()+time+".pdf"); // response.setHeader("Content-Disposition", "attachment;fileName=" + "销售订单_"+res.getOrderNo()+time+".pdf");// 设置文件名 IOUtils.copy(in,response.getOutputStream()); // StreamUtils.copy(in,response.getOutputStream()); // response.getOutputStream().flush(); // return null; response.setContentType(MediaType.APPLICATION_OCTET_STREAM_VALUE); FileUtils.setAttachmentResponseHeader(response, "提货单扫描记录_"+res.getOrderNo()+".pdf"); FileUtils.writeBytes(pdfPath, response.getOutputStream()); return; } catch (SwException e) { // return AjaxResult.error((int) ErrCode.SYS_PARAMETER_ERROR.getErrCode(), e.getMessage()); } catch (Exception e) { log.error("【提货单扫码记录打印】接口出现异常,参数${}$,异常${}$", JSONUtils.toJSONString(id), ExceptionUtils.getStackTrace(e)); // return AjaxResult.error((int) ErrCode.UNKNOW_ERROR.getErrCode(), "操作失败"); }finally { if(in!=null){ in.close(); } if(wb!=null){ wb.close(); } if(excelPaht!=null){ boolean b = FileUtils.deleteFile(excelPaht); System.out.println(b); } if(pdfPath!=null){ boolean b = FileUtils.deleteFile(pdfPath); System.out.println(b); } if(excelPaht2!=null){ boolean b = FileUtils.deleteFile(excelPaht2); System.out.println(b); } } } private void genarateScanLogReports(XSSFWorkbook wb, TakeGoodsOrderDetailVo re) { XSSFSheet sheet1 = wb.getSheetAt(0); // XSSFSheet sheet2 = wb.getSheetAt(1); // 设置公式自动读取，没有这行代码，excel模板中的公式不会自动计算 sheet1.setForceFormulaRecalculation(true); // sheet2.setForceFormulaRecalculation(true); /***设置单个单元格内容*********************************/ // FormExcelUtil.setCellData(sheet1, "2020-07报告", 1, 1); /***第一个表格*********************************/ // ExampleData ea = new ExampleData(); // List<List<Object>> data1 = ea.getData1(10); int addRows=0; //动态插入行 //FormExcelUtil.insertRowsStyleBatch(sheet, startNum, insertRows, styleRow, styleColStart, styleColEnd) //按照styleRow行的格式，在startNum行后添加insertRows行，并且针对styleColStart~ styleColEnd列同步模板行styleRow的格式 // FormExcelUtil.insertRowsStyleBatch(sheet1, 4+addRows, 21, 4, 1, 4); FormExcelUtil.setCellData(sheet1,re.getCustomerName(),2,2); FormExcelUtil.setCellData(sheet1,re.getOrderNo(),2,6); List<TakeOrderSugestVo> goods = re.getScans(); List<List<Object>> data1=new ArrayList<>(); for (int i=0;i<goods.size();i++) { List<Object> rlist=new ArrayList<>(); // SaleOrderSkuVo res=new SaleOrderSkuVo(); // res.setGoodsName("aa"); rlist.add(goods.get(i).getNumber()); rlist.add(goods.get(i).getGoodClass()); rlist.add(goods.get(i).getBrand()); rlist.add(goods.get(i).getModel()); rlist.add(goods.get(i).getDescription()); rlist.add(goods.get(i).getSn()); rlist.add(goods.get(i).getSku()); // rlist.add(""); data1.add(rlist); } // FormExcelUtil.insertRowsStyleBatch(sheet, startNum, insertRows, styleRow, styleColStart, styleColEnd) FormExcelUtil.insertRowsStyleBatch(sheet1, 4, data1.size(), 3, 1, 7); FormExcelUtil.setTableData(sheet1, data1, 4, 1); // addRows += data1.size()-2; /***第二个表格*********************************/ // List<List<Object>> data2 = ea.getData2(); // FormExcelUtil.insertRowsStyleBatch(sheet1, 10+addRows, data2.size()-2, 10+addRows, 1, 6); // FormExcelUtil.setTableData(sheet1, data2, 10+addRows, 1); // addRows += data2.size()-2; // /***第三个表格*********************************/ // List<List<Object>> data3 = ea.getData3(); // FormExcelUtil.setTableData(sheet2, data3, 3, 1); } //销售订单调拨建议 @GetMapping("outStockAdviceList") @PreAuthorize("@ss.hasPermi('system:outStockAdviceList:list')") public AjaxResult<TableDataInfo> outStockAdviceList(GsOutStockAdivceDto gsOutStockAdivceDto){ try { startPage(); List<GsOutStockAdivceVo> list= takeGoodsService.saleOrderSuggest(gsOutStockAdivceDto); return AjaxResult.success(getDataTable(list)); } catch (SwException e) { return AjaxResult.error((int) ErrCode.SYS_PARAMETER_ERROR.getErrCode(), e.getMessage()); } catch (Exception e) { log.error("【调拨建议列表】接口出现异常,参数${}$,异常${}$", JSON.toJSON(getUserId()), ExceptionUtils.getStackTrace(e)); return AjaxResult.error((int) ErrCode.UNKNOW_ERROR.getErrCode(), "操作失败"); } } @GetMapping("auditOutStockEnd") @PreAuthorize("@ss.hasPermi('system:outStockAdviceList:end')") public AjaxResult auditOutStockEnd(GsOutStockAdivceDto gsOutStockAdivceDto){ try { gsOutStockAdivceDto.setUserId(Integer.parseInt(SecurityUtils.getUserId()+"")); takeGoodsService.auditOutStockEnd(gsOutStockAdivceDto); return AjaxResult.success(); } catch (SwException e) { return AjaxResult.error((int) ErrCode.SYS_PARAMETER_ERROR.getErrCode(), e.getMessage()); } catch (Exception e) { log.error("【调拨建议标记完成】接口出现异常,参数${}$,异常${}$", JSON.toJSON(getUserId()), ExceptionUtils.getStackTrace(e)); return AjaxResult.error((int) ErrCode.UNKNOW_ERROR.getErrCode(), "操作失败"); } } /** *@author: zhaoguoliang *@date: Create in 2022/9/29 17:31 *根据商品id和仓库id查未被占用的sn商品 */ @GetMapping("selectGoodsSnByWhIdAndGoodsId") public AjaxResult selectGoodsSnByWhIdAndGoodsId(@RequestParam("whId") Integer whId, @RequestParam("goodsId")Integer goodsId) { try { List<GsGoodsSnVo> gsGoodsSnVos =takeGoodsService.selectGoodsSnByWhIdAndGoodsId(whId,goodsId); return AjaxResult.success(gsGoodsSnVos); } catch (SwException e) { return AjaxResult.error((int) ErrCode.SYS_PARAMETER_ERROR.getErrCode(), e.getMessage()); } catch (Exception e) { log.error("【调拨建议标记完成】接口出现异常,参数${}$,异常${}$", JSON.toJSON(whId), ExceptionUtils.getStackTrace(e)); return AjaxResult.error((int) ErrCode.UNKNOW_ERROR.getErrCode(), "操作失败"); } } /** *@author: zhaoguoliang *@date: Create in 2022/9/30 8:52 *销售提货单主表添加保存销售提货单扫描记录数据 */ @PostMapping("mdfTakeSuggest2") public AjaxResult mdfTakeSuggest2(@RequestParam("cbpmDto")CbpmDto cbpmDto) { try { takeGoodsService.mdfTakeSuggest2(cbpmDto); return AjaxResult.success(); } catch (SwException e) { return AjaxResult.error((int) ErrCode.SYS_PARAMETER_ERROR.getErrCode(), e.getMessage()); } catch (Exception e) { log.error("【调拨建议标记完成】接口出现异常,参数${}$,异常${}$", JSON.toJSON(cbpmDto), ExceptionUtils.getStackTrace(e)); return AjaxResult.error((int) ErrCode.UNKNOW_ERROR.getErrCode(), "操作失败"); } } }
1.2 Service 部分
package com.ruoyi.system.service.gson; import com.ruoyi.system.domain.Cbpm; import com.ruoyi.system.domain.dto.*; import com.ruoyi.system.domain.vo.*; import org.apache.ibatis.annotations.Param; import java.util.List; /** * ClassName TakeGoodsService * Description * Create by gfy * Date 2022/8/10 17:51 */ public interface TakeGoodsService { List<TakeGoodsOrderListVo> takeOrderList(TakeGoodsOrderListDto takeGoodsOrderListDto); void addTakeGoodsOrder(TakeGoodsOrderAddDto takeGoodsOrderAddDto); TakeGoodsOrderDetailVo takeOrderDetail(Integer id); TakeGoodsOrderDetailVo takeOrderDetailBySaleId(Integer saleOrderId,Integer whId); void mdfTakeGoodsOrder(TakeGoodsOrderAddDto takeGoodsOrderAddDto); void delTakeGoodsOrder(Integer id, Long userId); void auditTakeOrder(AuditTakeOrderDto auditTakeOrderDto); void mdfTakeSuggest(ChangeSuggestDto changeSuggestDto); int TakeGoodsOrdersm(List<Cbpm> itemList); List<GsOutStockAdivceVo> saleOrderSuggest(GsOutStockAdivceDto gsOutStockAdivceDto); void auditOutStockEnd(GsOutStockAdivceDto gsOutStockAdivceDto); List<GsGoodsSnVo> selectGoodsSnByWhIdAndGoodsId(Integer whId,Integer goodsId); void mdfTakeSuggest2(CbpmDto cbpmDto); }
ServiceImpl 部分
package com.ruoyi.system.service.gson.impl; import com.ruoyi.common.constant.TakeOrderConstants; import com.ruoyi.common.constant.WareHouseType; import com.ruoyi.common.core.domain.entity.Cbpa; import com.ruoyi.common.core.domain.entity.SysUser; import com.ruoyi.common.enums.*; import com.ruoyi.common.exception.SwException; import com.ruoyi.common.utils.NumberToChineseUtil; import com.ruoyi.common.utils.SecurityUtils; import com.ruoyi.common.utils.StringUtils; import com.ruoyi.system.domain.*; import com.ruoyi.system.domain.Do.CbpmTakeOrderDo; import com.ruoyi.system.domain.Do.NumberDo; import com.ruoyi.system.domain.dto.*; import com.ruoyi.system.domain.vo.*; import com.ruoyi.system.mapper.*; import com.ruoyi.system.service.gson.BaseCheckService; import com.ruoyi.system.service.gson.TakeGoodsService; import org.apache.ibatis.session.ExecutorType; import org.apache.ibatis.session.SqlSession; import org.apache.ibatis.session.SqlSessionFactory; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import org.springframework.web.bind.annotation.RequestParam; import javax.annotation.Resource; import java.math.BigDecimal; import java.text.SimpleDateFormat; import java.util.Date; import java.util.HashMap; import java.util.List; import java.util.Map; import java.util.stream.Collectors; /** * ClassName TakeGoodsServiceImpl * Description * Create by gfy * Date 2022/8/10 17:51 */ @Service public class TakeGoodsServiceImpl implements TakeGoodsService { @Resource private CbpkMapper cbpkMapper; @Resource private CboaMapper cboaMapper; @Resource private CbplMapper cbplMapper; @Resource private GsGoodsUseMapper gsGoodsUseMapper; @Resource private NumberGenerate numberGenerate; @Resource private CalaMapper calaMapper; @Resource private CbcaMapper cbcaMapper; @Resource private SysUserMapper sysUserMapper; @Resource private CbwaMapper cbwaMapper; @Resource private CbpbMapper cbpbMapper; @Resource private CbobMapper cbobMapper; @Resource private CbpmMapper cbpmMapper; @Resource private CbpaMapper cbpaMapper; @Resource private GsGoodsSnMapper gsGoodsSnMapper; @Resource private SqlSessionFactory sqlSessionFactory; @Resource private GsOutStockAdivceMapper gsOutStockAdivceMapper; @Resource private BaseCheckService baseCheckService; @Override public List<TakeGoodsOrderListVo> takeOrderList(TakeGoodsOrderListDto takeGoodsOrderListDto) { List<TakeGoodsOrderListVo> res= cbpkMapper.takeOrderList(takeGoodsOrderListDto); return res; } @Transactional @Override public void addTakeGoodsOrder(TakeGoodsOrderAddDto takeGoodsOrderAddDto) { //查出销售订单 检查销售订单是否已复审通过 CboaCriteria oaex=new CboaCriteria(); oaex.createCriteria() .andCboa06EqualTo(DeleteFlagEnum.NOT_DELETE.getCode()) .andCboa07EqualTo(takeGoodsOrderAddDto.getSaleOrderNo()); List<Cboa> cboas = cboaMapper.selectByExample(oaex); if(cboas.size()==0){ throw new SwException("没有查到该销售订单订单"); } Cboa cboa = cboas.get(0); if(!SaleOrderStatusEnums.YIFUSHEN.getCode().equals(cboa.getCboa11())){ throw new SwException("销售订单必须为已复审状态"); } //只有该销售订单在此仓库最新一提货单质检完成之后才能再生成 Cbpk old= cbpkMapper.selectLastBySaleOrderNo(takeGoodsOrderAddDto.getSaleOrderNo()); if(old!=null && TakeOrderCheckStatus.NOCHECK.getCode().equals(old.getCheckStatus())){ throw new SwException("该销售订单的最新提货单需要质检完成之后才能提交新的提货单"); } Cbpk cbpk=new Cbpk(); Date date = new Date(); cbpk.setCbpk02(date); cbpk.setCbpk03(takeGoodsOrderAddDto.getUserId()); cbpk.setCbpk04(date); cbpk.setCbpk05(takeGoodsOrderAddDto.getUserId()); cbpk.setCbpk06(DeleteFlagEnum.NOT_DELETE.getCode()); NumberDo numberDo = new NumberDo(); numberDo.setType(NumberGenerateEnum.TAKEORDER.getCode()); cbpk.setCbpk07(numberGenerate.createOrderNo(numberDo).getOrderNo()); cbpk.setCbpk08(takeGoodsOrderAddDto.getOrderDate()); cbpk.setCbpk09(takeGoodsOrderAddDto.getCustomerId()); cbpk.setCbpk10(takeGoodsOrderAddDto.getWhId()); cbpk.setCbpk11(SaleOrderStatusEnums.YITIJIAO.getCode()); // cbpk.setCbpk12(); // cbpk.setCbpk13(); // cbpk.setCbpk14();/ // cbpk.setCbpk15(); cbpk.setCbpk16(takeGoodsOrderAddDto.getCurrency()); cbpk.setCbpk17(takeGoodsOrderAddDto.getSaleUserId()); cbpk.setCbpk18(takeGoodsOrderAddDto.getContacts()); cbpk.setCbpk19(takeGoodsOrderAddDto.getPhone()); // cbpk.setCbpk20(); cbpk.setCbpk21(takeGoodsOrderAddDto.getReceiveAdress()); // cbpk.setCbpk22(); // cbpk.setCbpk23(); // cbpk.setCbpk24(); // cbpk.setCbpk25(); // cbpk.setCbpk26(); // cbpk.setCbpk27(); // cbpk.setCbpk28(); // cbpk.setCbpk29(); cbpk.setCbpk30(takeGoodsOrderAddDto.getCustomerNo()); cbpk.setCbpk31(TakeOrderConstants.WEIWANCHENG); cbpk.setCheckStatus(TakeOrderCheckStatus.NOCHECK.getCode().byteValue()); cbpk.setSaleOrderNo(takeGoodsOrderAddDto.getSaleOrderNo()); int insert = cbpkMapper.insertWithId(cbpk); Cbpl cbpl=null; for (TakeOrderGoodsDto good : takeGoodsOrderAddDto.getGoods()) { if(good.getGoodsId()==null){ throw new SwException("提货货物不能为空"); } //检查是否已占用了库存 并且提货数量不能大于占用数量 以及历史提货数量减去良品数量 GsGoodsUseCriteria guex=new GsGoodsUseCriteria(); guex.createCriteria() .andGoodsIdEqualTo(good.getGoodsId()) .andOrderNoEqualTo(takeGoodsOrderAddDto.getSaleOrderNo()) .andWhIdEqualTo(takeGoodsOrderAddDto.getWhId()); List<GsGoodsUse> gsGoodsUses = gsGoodsUseMapper.selectByExample(guex); if(gsGoodsUses.size()==0){ throw new SwException("该商品没有在本仓库占用库存，商品:"); } GsGoodsUse goodsUse = gsGoodsUses.get(0); if(good.getQty()>goodsUse.getLockQty()){ throw new SwException("该商品的提货数量不能大于占用数量"); } //未出库数量 Double noOutQty = goodsUse.getNoOutQty(); Double lockQty = goodsUse.getLockQty(); if(good.getQty()+noOutQty>lockQty){ throw new SwException("该商品未出库的提货单数量相加超过占用数量"); } //生成明细表 cbpl=new Cbpl(); cbpl.setCbpk01(cbpk.getCbpk01()); cbpl.setCbpl02(good.getNumber()); cbpl.setCbpl03(date); cbpl.setCbpl04(takeGoodsOrderAddDto.getUserId()); cbpl.setCbpl05(date); cbpl.setCbpl06(takeGoodsOrderAddDto.getUserId()); cbpl.setCbpl07(DeleteFlagEnum.NOT_DELETE.getCode()); cbpl.setCbpl08(good.getGoodsId()); cbpl.setCbpl09(good.getQty()); cbpl.setCbpl10(0.0); cbpl.setCbpl11(good.getPrice()); cbpl.setCbpl12(good.getTotalPrice()); cbpl.setGoodProductQty(good.getQty()); // cbpl.setCbpl13(); // cbpl.setCbpl14(); // cbpl.setCbpl15(); // cbpl.setCbpl16(); cbpl.setGoodProductQty(0.0); cbplMapper.insert(cbpl); // List<Cbpl> list=cbplMapper.selectBySaleOrderNo(takeGoodsOrderAddDto.getSaleOrderNo()); //提货数量 // Double takeQty = list.stream().collect(Collectors.summingDouble(Cbpl::getCbpl09)); //良品数量 // Double goodQty = list.stream().collect(Collectors.summingDouble(Cbpl::getGoodProductQty)); // Double lessQty=takeQty-goodQty; } } @Override public TakeGoodsOrderDetailVo takeOrderDetail(Integer id) { Cbpk cbpk = cbpkMapper.selectByPrimaryKey(id); if(cbpk==null || !DeleteFlagEnum.NOT_DELETE.getCode().equals(cbpk.getCbpk06())){ throw new SwException("没有查到该提货单"); } TakeGoodsOrderDetailVo res=new TakeGoodsOrderDetailVo(); res.setContacts(cbpk.getCbpk18()); res.setCurrency(cbpk.getCbpk16()); res.setOrderNo(cbpk.getCbpk07()); if(CurrencyEnum.CNY.getCode().equals(cbpk.getCbpk16())){ res.setCurrencyMsg(CurrencyEnum.CNY.getMsg()); }else { res.setCurrencyMsg(CurrencyEnum.USD.getMsg()); } res.setCustomerId(cbpk.getCbpk09()); Cbca cbca = cbcaMapper.selectByPrimaryKey(cbpk.getCbpk09()); if(cbca!=null){ res.setCustomerName(cbca.getCbca08()); res.setCustomerLevel(cbca.getCbca28()); } res.setCustomerNo(cbpk.getCbpk30()); res.setOrderDate(cbpk.getCbpk08()); res.setPhone(cbpk.getCbpk19()); res.setReceiveAdress(cbpk.getCbpk21()); res.setReceiver(cbpk.getCbpk18()); res.setReceivPhone(cbpk.getCbpk19()); Cboa cboa=null; if(!StringUtils.isBlank(cbpk.getSaleOrderNo())){ CboaCriteria oaex=new CboaCriteria(); oaex.createCriteria() .andCboa07EqualTo(cbpk.getSaleOrderNo()); List<Cboa> cboas = cboaMapper.selectByExample(oaex); cboa= cboas.get(0); res.setSaleOrderId(cboas.get(0).getCboa01()); } res.setSaleOrderNo(cbpk.getSaleOrderNo()); SysUser user = sysUserMapper.selectByPrimaryKey(cbpk.getCbpk03().longValue()); if(user!=null){ res.setUserId(user.getUserId().intValue()); res.setUserName(user.getNickName()); } if(cbpk.getCbpk12()!=null){ SysUser auditUser = sysUserMapper.selectByPrimaryKey(cbpk.getCbpk12().longValue()); if(auditUser!=null){ res.setAuditUserName(auditUser.getNickName()); } } if(cbpk.getCbpk17()!=null){ SysUser saleUser = sysUserMapper.selectByPrimaryKey(cbpk.getCbpk17().longValue()); if(saleUser!=null){ res.setSaleUserId(saleUser.getUserId().intValue()); res.setSaleUserName(saleUser.getNickName()); } } Cbwa cbwa = cbwaMapper.selectByPrimaryKey(cbpk.getCbpk10()); if(cbwa!=null){ res.setWhName(cbwa.getCbwa09()); res.setWhId(cbwa.getCbwa01()); } if(cbpk.getCheckStatus()!=null){ if(TakeOrderCheckStatus.NOCHECK.getCode().equals(cbpk.getCheckStatus())){ res.setCheckStatus(TakeOrderCheckStatus.NOCHECK.getMsg()); }else { res.setCheckStatus(TakeOrderCheckStatus.CHECK.getMsg()); } } CbplCriteria plex=new CbplCriteria(); plex.createCriteria() .andCbpk01EqualTo(cbpk.getCbpk01()) .andCbpl07EqualTo(DeleteFlagEnum.NOT_DELETE.getCode()); plex.setOrderByClause("CBPL02 desc"); List<Cbpl> cbpls = cbplMapper.selectByExample(plex); List<TakeOrderGoodsVo> goods = res.getGoods(); //zhaoGuoLiang添加销售订单明细表id CboaCriteria cboaCriteria = new CboaCriteria(); cboaCriteria.createCriteria().andCboa07EqualTo(cbpk.getSaleOrderNo()) .andCboa06EqualTo(DeleteFlagEnum.NOT_DELETE.getCode()); List<Cboa> cboaList = cboaMapper.selectByExample(cboaCriteria); List<Cbob> cbobList = null; if(cboaList!=null&&cboaList.size()>0){ CbobCriteria cbobCriteria = new CbobCriteria(); cbobCriteria.createCriteria().andCboa01EqualTo(cboaList.get(0).getCboa01()) .andCbob07EqualTo(DeleteFlagEnum.NOT_DELETE.getCode()); cbobCriteria.setOrderByClause("CBOB03 desc"); cbobList = cbobMapper.selectByExample(cbobCriteria); } // CalaCriteria laexample = new CalaCriteria(); // laexample.createCriteria() // .andCala10EqualTo("商品品牌"); // List<Cala> calas = calaMapper.selectByExample(laexample); // Map<Integer, String> brandMap = new HashMap<>(); // for (Cala cala : calas) { // brandMap.put(cala.getCala01(), cala.getCala08()); // } Map<Integer, String> brandMap = baseCheckService.brandMap(); TakeOrderGoodsVo good=null; Double sumQty=0.0; Double sunPrice=0.0; Map<Integer,TakeOrderGoodsVo> goodsMap=new HashMap<>(); int i = 0; for (Cbpl cbpl : cbpls) { good=new TakeOrderGoodsVo(); // CbpmCriteria pmex=new CbpmCriteria(); // pmex.createCriteria() // .andCbpk01EqualTo(cbpk.getCbpk01()) // .andCb // List<Cbpm> cbpms = cbpmMapper.selectByExample(pmex); // CbpmCriteria pmex=new CbpmCriteria(); // pmex.createCriteria() // .andCbpm07EqualTo(DeleteFlagEnum.NOT_DELETE.getCode()) // .andCbpm08EqualTo(good.getGoodsId()) // .andCbpk01EqualTo(cbpk.getCbpk01()); // List<Cbpm> cbpms = cbpmMapper.selectByExample(pmex); // good.setGoodsNum(Double.valueOf(cbpms.size())); //zhaoGuoLiang添加销售订单明细表id if(cbobList!=null&&cbobList.size()>i){ good.setCbob01(cbobList.get(i).getCbob01()); } good.setCbplId(cbpl.getCbpl01()); Cbpb cbpb = cbpbMapper.selectByPrimaryKey(cbpl.getCbpl08()); if (cbpb != null) { // good.setGoodsNum(); good.setUpc(cbpb.getCbpb15()); good.setBrand(brandMap.get(cbpb.getCbpb10())); good.setDescription(cbpb.getCbpb08()); good.setModel(cbpb.getCbpb12()); Cbpa cbpa = cbpaMapper.selectByPrimaryKey(cbpb.getCbpb14()); if(cbpa!=null){ good.setGoodClass(cbpa.getCbpa07()); } } good.setGoodsId(cbpl.getCbpl08()); if(OrderTypeEnum.GUOJIDINGDAN.getCode().equals(cbpl.getCbpl16())){ good.setOrderClass(OrderTypeEnum.GUOJIDINGDAN.getMsg()); }else { good.setOrderClass(OrderTypeEnum.GUONEIDINGDAN.getMsg()); } if(cboa!=null){ GsGoodsUseCriteria usexample=new GsGoodsUseCriteria(); usexample.createCriteria() .andOrderNoEqualTo(cboa.getCboa07()) .andGoodsIdEqualTo(good.getGoodsId()); List<GsGoodsUse> gsGoodsUses = gsGoodsUseMapper.selectByExample(usexample); if(gsGoodsUses.size()>0){ GsGoodsUse goodsUse = gsGoodsUses.get(0); good.setUseQty(goodsUse.getLockQty()); } CbobCriteria obex=new CbobCriteria(); obex.createCriteria() .andCbob07EqualTo(DeleteFlagEnum.NOT_DELETE.getCode()) .andCbob08EqualTo(good.getGoodsId()) .andCboa01EqualTo(cboa.getCboa01()); List<Cbob> cbobs = cbobMapper.selectByExample(obex); if(cbobs.size()>0){ Cbob cbob=cbobs.get(0); good.setNoSendQty(cbob.getCbob09()-cbob.getCbob10()); good.setOrderQty(cbob.getCbob09()); } } //良品数量 good.setGoodsNum(cbpl.getGoodProductQty()); good.setPrice(cbpl.getCbpl11()); CbpmCriteria pmex=new CbpmCriteria(); pmex.createCriteria() .andCbpm08EqualTo(good.getGoodsId()) .andCbpm11EqualTo(1) .andCbpk01EqualTo(cbpk.getCbpk01()); List<Cbpm> cbpms = cbpmMapper.selectByExample(pmex); good.setScanQty(cbpms.size()); good.setGoodsNum(Double.valueOf(cbpms.size())); //todo // good.setRemark(); good.setQty(cbpl.getCbpl09()); //TODO // good.setSupplierId(); good.setTotalPrice(cbpl.getCbpl12()); sumQty=sumQty+cbpl.getCbpl09(); sunPrice=sunPrice+cbpl.getCbpl11(); res.getGoods().add(good); goodsMap.put(good.getGoodsId(),good); i++; } res.setSumPrice(sunPrice); res.setSumQty(sumQty); res.setCapPrice(NumberToChineseUtil.moneyToChinese(res.getSumPrice())); res.setSumQty(sumQty); // CbpmCriteria pmex=new CbpmCriteria(); // pmex.createCriteria() // .andCbpm07EqualTo(DeleteFlagEnum.NOT_DELETE.getCode()) // .andCbpm08EqualTo(good.getGoodsId()) // .andCbpk01EqualTo(cbpk.getCbpk01()); // pmex.setOrderByClause("CBPM11 ASC"); List<CbpmTakeOrderDo> cbpms = cbpmMapper.selectByTakeId(cbpk.getCbpk01()); //查提货建议表 TakeOrderSugestVo sugest=null; Map<Integer,Integer> scanMap=new HashMap<>(); for (CbpmTakeOrderDo cbpm : cbpms) { sugest=new TakeOrderSugestVo(); TakeOrderGoodsVo takeOrderGoodsVo = goodsMap.get(cbpm.getCbpm08()); if(takeOrderGoodsVo!=null){ sugest.setBrand(takeOrderGoodsVo.getBrand()); sugest.setDescription(takeOrderGoodsVo.getDescription()); sugest.setModel(takeOrderGoodsVo.getModel()); sugest.setGoodClass(takeOrderGoodsVo.getGoodClass()); sugest.setUpc(takeOrderGoodsVo.getUpc()); } sugest.setNumber(cbpm.getCbpm02()); sugest.setScanStatus(ScanStatusEnum.findByKey(cbpm.getCbpm11()).getMsg()); sugest.setBfSn(cbpm.getCbpm12()); sugest.setSku(cbpm.getSku()); sugest.setSn(cbpm.getCbpm09()); res.getSugests().add(sugest); if(ScanStatusEnum.YISAOMA.getCode().equals(cbpm.getCbpm11())){ res.getScans().add(sugest); Integer integer = scanMap.get(takeOrderGoodsVo.getGoodsId()); if(integer==null){ scanMap.put(takeOrderGoodsVo.getGoodsId(),1); }else { scanMap.put(takeOrderGoodsVo.getGoodsId(),integer+1); } } for (TakeOrderGoodsVo resGood : res.getGoods()) { if(scanMap.get(resGood.getGoodsId())==null){ resGood.setScanQty(0); }else { resGood.setScanQty(scanMap.get(resGood.getGoodsId())); } } } if(res.getOrderDate()!=null){ SimpleDateFormat sd=new SimpleDateFormat("yyyy-MM-dd"); String format = sd.format(res.getOrderDate()); res.setOrderDateMsg(format); } return res; } @Override public TakeGoodsOrderDetailVo takeOrderDetailBySaleId(Integer saleOrderId,Integer whId) { Cboa cboa = cboaMapper.selectByPrimaryKey(saleOrderId); TakeGoodsOrderDetailVo res=new TakeGoodsOrderDetailVo(); res.setContacts(cboa.getCboa17()); res.setCurrency(cboa.getCboa16()); if(CurrencyEnum.CNY.getCode().equals(cboa.getCboa16())){ res.setCurrencyMsg(CurrencyEnum.CNY.getMsg()); }else { res.setCurrencyMsg(CurrencyEnum.USD.getMsg()); } res.setCustomerId(cboa.getCboa09()); Cbca cbca = cbcaMapper.selectByPrimaryKey(res.getCustomerId()); if(cbca!=null){ res.setCustomerName(cbca.getCbca08()); res.setCustomerLevel(cbca.getCbca28()); } res.setCustomerNo(cboa.getCboa25()); res.setOrderDate(cboa.getCboa08()); res.setPhone(cboa.getCboa19()); res.setReceiveAdress(cboa.getCboa18()); res.setReceiver(cboa.getCboa17()); res.setReceivPhone(cboa.getCboa19()); res.setSaleOrderId(cboa.getCboa01()); res.setSaleOrderNo(cboa.getCboa07()); // SysUser user = sysUserMapper.selectByPrimaryKey(cbpk.getCbpk03().longValue()); // if(user!=null){ // res.setUserId(user.getUserId().intValue()); // res.setUserName(user.getNickName()); // } SysUser saleUser = sysUserMapper.selectByPrimaryKey(cboa.getCboa10().longValue()); if(saleUser!=null){ res.setSaleUserId(saleUser.getUserId().intValue()); res.setSaleUserName(saleUser.getNickName()); } Cbwa cbwa = cbwaMapper.selectByPrimaryKey(whId); if(cbwa!=null){ res.setWhName(cbwa.getCbwa09()); res.setWhId(cbwa.getCbwa01()); } // if(cbpk.getCheckStatus()!=null){ // if(TakeOrderCheckStatus.NOCHECK.getCode().equals(cbpk.getCheckStatus())){ // res.setCheckStatus(TakeOrderCheckStatus.NOCHECK.getMsg()); // }else { // res.setCheckStatus(TakeOrderCheckStatus.CHECK.getMsg()); // } // // // } CalaCriteria laexample = new CalaCriteria(); laexample.createCriteria() .andCala10EqualTo("商品品牌"); List<Cala> calas = calaMapper.selectByExample(laexample); Map<Integer, String> brandMap = new HashMap<>(); for (Cala cala : calas) { brandMap.put(cala.getCala01(), cala.getCala08()); } // CbobCriteria obex=new CbobCriteria(); // obex.createCriteria() // .andCbob07EqualTo(DeleteFlagEnum.NOT_DELETE.getCode()) // .andCboa01EqualTo(cboa.getCboa01()); // List<Cbob> cbobs = cbobMapper.selectByExample(obex); TakeOrderGoodsVo good=null; //查占用表 GsGoodsUseCriteria usex=new GsGoodsUseCriteria(); usex.createCriteria().andOrderNoEqualTo(cboa.getCboa07()) .andWhIdEqualTo(whId); List<GsGoodsUse> gsGoodsUses = gsGoodsUseMapper.selectByExample(usex); for (GsGoodsUse goodsUse : gsGoodsUses) { good=new TakeOrderGoodsVo(); Cbpb cbpb = cbpbMapper.selectByPrimaryKey(goodsUse.getGoodsId()); if (cbpb != null) { good.setGoodsId(cbpb.getCbpb01()); good.setBrand(brandMap.get(cbpb.getCbpb10())); good.setDescription(cbpb.getCbpb08()); good.setModel(cbpb.getCbpb12()); Cbpa cbpa = cbpaMapper.selectByPrimaryKey(cbpb.getCbpb14()); if(cbpa!=null){ good.setGoodClass(cbpa.getCbpa07()); } } CbobCriteria obex=new CbobCriteria(); obex.createCriteria() .andCbob08EqualTo(goodsUse.getGoodsId()) .andCbob07EqualTo(DeleteFlagEnum.NOT_DELETE.getCode()) .andCboa01EqualTo(cboa.getCboa01()); List<Cbob> cbobs = cbobMapper.selectByExample(obex); if(cbobs.size()>0){ Cbob cbob=cbobs.get(0); good.setNoSendQty(cbob.getCbob09()-cbob.getCbob10()); good.setPrice(cbob.getCbob11()); //todo // good.setRemark(); good.setQty(goodsUse.getLockQty()); good.setTotalPrice(cbob.getCbob12()); //TODO // good.setSupplierId(); } good.setUseQty(goodsUse.getLockQty()); //良品数量 good.setGoodsNum(0.0); res.getGoods().add(good); } return res; } @Transactional @Override public void mdfTakeGoodsOrder(TakeGoodsOrderAddDto takeGoodsOrderAddDto) { //只有在未提交状态下才能编辑 Cbpk cbpk = cbpkMapper.selectByPrimaryKey(takeGoodsOrderAddDto.getId()); if(!SaleOrderStatusEnums.WEITIJIAO.getCode().equals(cbpk.getCbpk11())){ throw new SwException("提货单必须为未提交状态才能修改"); } Date date = new Date(); cbpk.setCbpk04(date); cbpk.setCbpk05(takeGoodsOrderAddDto.getUserId()); cbpk.setCbpk08(takeGoodsOrderAddDto.getOrderDate()); cbpk.setCbpk09(takeGoodsOrderAddDto.getCustomerId()); cbpk.setCbpk10(takeGoodsOrderAddDto.getWhId()); // cbpk.setCbpk12(); // cbpk.setCbpk13(); // cbpk.setCbpk14();/ // cbpk.setCbpk15(); cbpk.setCbpk16(takeGoodsOrderAddDto.getCurrency()); cbpk.setCbpk17(takeGoodsOrderAddDto.getSaleUserId()); cbpk.setCbpk18(takeGoodsOrderAddDto.getContacts()); cbpk.setCbpk19(takeGoodsOrderAddDto.getPhone()); // cbpk.setCbpk20(); cbpk.setCbpk21(takeGoodsOrderAddDto.getReceiveAdress()); // cbpk.setCbpk22(); // cbpk.setCbpk23(); // cbpk.setCbpk24(); // cbpk.setCbpk25(); // cbpk.setCbpk26(); // cbpk.setCbpk27(); // cbpk.setCbpk28(); // cbpk.setCbpk29(); cbpk.setCbpk30(takeGoodsOrderAddDto.getCustomerNo()); cbpk.setCbpk31(TakeOrderConstants.WEIWANCHENG); cbpk.setCheckStatus(TakeOrderCheckStatus.NOCHECK.getCode().byteValue()); cbpk.setSaleOrderNo(takeGoodsOrderAddDto.getSaleOrderNo()); cbpk.setCbpk11(SaleOrderStatusEnums.YITIJIAO.getCode()); int update = cbpkMapper.updateByPrimaryKey(cbpk); Cbpl cbpl=null; //删除cbpl CbplCriteria plex=new CbplCriteria(); plex.createCriteria() .andCbpk01EqualTo(cbpk.getCbpk01()); int i = cbplMapper.deleteByExample(plex); for (TakeOrderGoodsDto good : takeGoodsOrderAddDto.getGoods()) { if(good.getGoodsId()==null){ throw new SwException("提货货物不能为空"); } //检查是否已占用了库存 并且提货数量不能大于占用数量 以及历史提货数量减去良品数量 GsGoodsUseCriteria guex=new GsGoodsUseCriteria(); guex.createCriteria() .andGoodsIdEqualTo(good.getGoodsId()) .andOrderNoEqualTo(takeGoodsOrderAddDto.getSaleOrderNo()) .andWhIdEqualTo(takeGoodsOrderAddDto.getWhId()); List<GsGoodsUse> gsGoodsUses = gsGoodsUseMapper.selectByExample(guex); if(gsGoodsUses.size()==0){ throw new SwException("该商品没有在本仓库占用库存，商品:"+good.getGoodsMsg()); } GsGoodsUse goodsUse = gsGoodsUses.get(0); if(good.getQty()>goodsUse.getLockQty()){ throw new SwException("该商品的提货数量不能大于占用数量"+good.getGoodsMsg()); } //未出库数量 Double noOutQty = goodsUse.getNoOutQty(); Double lockQty = goodsUse.getLockQty(); if(good.getQty()+noOutQty>lockQty){ throw new SwException("该商品未出库的提货单数量相加超过占用数量"+good.getGoodsMsg()); } //生成明细表 cbpl=new Cbpl(); cbpl.setCbpk01(cbpk.getCbpk01()); cbpl.setCbpl02(good.getNumber()); cbpl.setCbpl03(date); cbpl.setCbpl04(takeGoodsOrderAddDto.getUserId()); cbpl.setCbpl05(date); cbpl.setCbpl06(takeGoodsOrderAddDto.getUserId()); cbpl.setCbpl07(DeleteFlagEnum.NOT_DELETE.getCode()); cbpl.setCbpl08(good.getGoodsId()); cbpl.setCbpl09(good.getQty()); cbpl.setCbpl10(0.0); cbpl.setCbpl11(good.getPrice()); cbpl.setCbpl12(good.getTotalPrice()); // cbpl.setCbpl13(); // cbpl.setCbpl14(); // cbpl.setCbpl15(); // cbpl.setCbpl16(); cbpl.setGoodProductQty(0.0); cbplMapper.insert(cbpl); // List<Cbpl> list=cbplMapper.selectBySaleOrderNo(takeGoodsOrderAddDto.getSaleOrderNo()); //提货数量 // Double takeQty = list.stream().collect(Collectors.summingDouble(Cbpl::getCbpl09)); //良品数量 // Double goodQty = list.stream().collect(Collectors.summingDouble(Cbpl::getGoodProductQty)); // Double lessQty=takeQty-goodQty; } } @Transactional @Override public void delTakeGoodsOrder(Integer id, Long userId) { Cbpk cbpk = cbpkMapper.selectByPrimaryKey(id); if(cbpk==null || !DeleteFlagEnum.NOT_DELETE.getCode().equals(cbpk.getCbpk06())){ throw new SwException("没有查到该提货单"); } if(!SaleOrderStatusEnums.WEITIJIAO.getCode().equals(cbpk.getCbpk11())){ throw new SwException("必须在未提交状态下才能删除"); } cbpk.setCbpk06(DeleteFlagEnum.DELETE.getCode()); cbpk.setCbpk05(userId.intValue()); cbpk.setCbpk04(new Date()); cbpkMapper.updateByPrimaryKey(cbpk); } @Transactional @Override public void auditTakeOrder(AuditTakeOrderDto auditTakeOrderDto) { Cbpk cbpk = cbpkMapper.selectByPrimaryKey(auditTakeOrderDto.getTakeOrderId()); //审核通过 生成提货建议表 并让出库建议的货品变成出库中 if(cbpk==null || !DeleteFlagEnum.NOT_DELETE.getCode().equals(cbpk.getCbpk06())){ throw new SwException("没有查到该提货单"); } Date date = new Date(); if(auditTakeOrderDto.getOpType().equals(1)){ if(!SaleOrderStatusEnums.YITIJIAO.getCode().equals(cbpk.getCbpk11())){ throw new SwException("必须在已提交状态下才能审核"); } cbpk.setCbpk11(SaleOrderStatusEnums.YISHENHE.getCode()); cbpk.setCbpk12(auditTakeOrderDto.getUserId()); //生成提货建议单 CbplCriteria plex=new CbplCriteria(); plex.createCriteria() .andCbpl07EqualTo(DeleteFlagEnum.NOT_DELETE.getCode()) .andCbpk01EqualTo(cbpk.getCbpk01()); List<Cbpl> cbpls = cbplMapper.selectByExample(plex); Cbpm cbpm=null; for (Cbpl cbpl : cbpls) { //先入先出 并且未占用 //查找本仓库的占用数量 GsGoodsUseCriteria usex=new GsGoodsUseCriteria(); usex.createCriteria() .andGoodsIdEqualTo(cbpl.getCbpl08()) .andWhIdEqualTo(cbpk.getCbpk10()) .andOrderNoEqualTo(cbpk.getSaleOrderNo()) ; List<GsGoodsUse> gsGoodsUses = gsGoodsUseMapper.selectByExample(usex); if(gsGoodsUses.size()>0){ List<GsGoodsSn> list=gsGoodsSnMapper.selectOutByWhIdAndGoodsId(cbpk.getCbpk10(),cbpl.getCbpl08(),gsGoodsUses.get(0).getLockQty().intValue()); for (int i=0;i< list.size() ;i++) { GsGoodsSn gsGoodsSn = list.get(i); cbpm=new Cbpm(); cbpm.setCbpk01(cbpk.getCbpk01()); cbpm.setCbpm02(i+1); cbpm.setCbpm03(date); cbpm.setCbpm04(auditTakeOrderDto.getUserId()); cbpm.setCbpm05(date); cbpm.setCbpm06(auditTakeOrderDto.getUserId()); cbpm.setCbpm07(DeleteFlagEnum.NOT_DELETE.getCode()); cbpm.setCbpm08(cbpl.getCbpl08()); cbpm.setCbpm09(gsGoodsSn.getSn()); cbpm.setCbpm10(gsGoodsSn.getLocationId()); cbpm.setCbpm11(0); cbpmMapper.insert(cbpm); gsGoodsSn.setStatus(new Byte("2")); gsGoodsSn.setUpdateTime(date); gsGoodsSnMapper.updateByPrimaryKey(gsGoodsSn); } } } }else if(auditTakeOrderDto.getOpType().equals(2)) { //撤销 提交状态变成未提交状态 if(!SaleOrderStatusEnums.YITIJIAO.getCode().equals(cbpk.getCbpk11())){ throw new SwException("必须在待审核状态下才能撤销"); } CbpmCriteria plex=new CbpmCriteria(); plex.createCriteria() .andCbpk01EqualTo(auditTakeOrderDto.getTakeOrderId()); int i = cbpmMapper.deleteByExample(plex); cbpk.setCbpk11(SaleOrderStatusEnums.WEITIJIAO.getCode()); }else if(auditTakeOrderDto.getOpType().equals(3)){ //反审 库建议的货品改为未出库 if(!SaleOrderStatusEnums.YISHENHE.getCode().equals(cbpk.getCbpk11())){ throw new SwException("必须在已审核状态下才能撤销"); } CbpmCriteria scex=new CbpmCriteria(); scex.createCriteria() .andCbpk01EqualTo(auditTakeOrderDto.getTakeOrderId()); List<Cbpm> cbpms = cbpmMapper.selectByExample(scex); // if(cbpms.size()>0){ // throw new SwException("已有扫码的商品，不能反审"); // } cbpk.setCbpk11(SaleOrderStatusEnums.YITIJIAO.getCode()); for (Cbpm cbpm : cbpms) { if(cbpm.getCbpm11()==1){ throw new SwException("已有扫码的商品，不能反审"); } cbpmMapper.deleteByPrimaryKey(cbpm.getCbpm01()); GsGoodsSn gs=new GsGoodsSn(); gs.setStatus(new Byte("1")); GsGoodsSnCriteria example=new GsGoodsSnCriteria(); example.createCriteria() .andSnEqualTo(cbpm.getCbpm09()); int i = gsGoodsSnMapper.updateByExampleSelective(gs,example); } }else if(auditTakeOrderDto.getOpType().equals(4)){ //标记完成 if(!SaleOrderStatusEnums.YISHENHE.getCode().equals(cbpk.getCbpk11())){ throw new SwException("必须在已审核状态下才能标记完成"); } cbpk.setCbpk11(SaleOrderStatusEnums.YIWANCHENG.getCode()); CboaCriteria orderex=new CboaCriteria(); orderex.createCriteria() .andCboa07EqualTo(cbpk.getSaleOrderNo()); List<Cboa> cboas = cboaMapper.selectByExample(orderex); if(cboas.size()>0){ Cboa cboa = cboas.get(0); CbobCriteria obex=new CbobCriteria(); obex.createCriteria() .andCboa01EqualTo(cboa.getCboa01()); List<Cbob> cbobs = cbobMapper.selectByExample(obex); for (Cbob cbob : cbobs) { CbplCriteria plex=new CbplCriteria(); plex.createCriteria() .andCbpk01EqualTo(cbpk.getCbpk01()) .andCbpl08EqualTo(cbob.getCbob08()) .andCbpl07EqualTo(DeleteFlagEnum.NOT_DELETE.getCode()); List<Cbpl> cbpls = cbplMapper.selectByExample(plex); if(cbpls.size()>0){ cbob.setTakeQty(cbpls.get(0).getGoodProductQty()); } } } }else if(auditTakeOrderDto.getOpType().equals(5)){ //取消完成 if(!SaleOrderStatusEnums.YIWANCHENG.getCode().equals(cbpk.getCbpk11())){ throw new SwException("必须在已完成状态下才能取消完成"); } cbpk.setCbpk11(SaleOrderStatusEnums.YISHENHE.getCode()); }else if(auditTakeOrderDto.getOpType().equals(6)){ cbpk.setCheckStatus(new Byte("1")); List<GoodsDto> goods = auditTakeOrderDto.getGoods(); for (GoodsDto good : goods) { Cbpl cbpl=new Cbpl(); cbpl.setCbpl01(good.getPlId()); cbpl.setGoodProductQty(good.getGoodQty()); cbplMapper.updateByPrimaryKeySelective(cbpl); } } cbpk.setCbpk12(auditTakeOrderDto.getUserId()); cbpk.setCbpk05(auditTakeOrderDto.getUserId()); cbpk.setCbpk04(new Date()); cbpkMapper.updateByPrimaryKey(cbpk); return; } @Override public void mdfTakeSuggest(ChangeSuggestDto changeSuggestDto) { Date date = new Date(); List<ChangeSuggestModel> list = changeSuggestDto.getList(); for (ChangeSuggestModel changeSuggestModel : list) { //检查修改的商品是否在建议出库单中存在 CbpmCriteria example=new CbpmCriteria(); example.createCriteria() .andCbpm09EqualTo(changeSuggestModel.getCbpm09()); List<Cbpm> cbpms = cbpmMapper.selectByExample(example); if(cbpms.size()>0 && !cbpms.get(0).getCbpm01().equals(changeSuggestModel.getCbpm01())){ throw new SwException("您选择的Sn商品已经在别的出库单中存在:" + changeSuggestModel.getCbpm09()); } Cbpm cbpm=new Cbpm(); cbpm.setCbpm01(changeSuggestModel.getCbpm01()); cbpm.setCbpm07(changeSuggestModel.getCbpm07()); cbpm.setCbpm08(changeSuggestModel.getCbpm08()); cbpm.setCbpm09(changeSuggestModel.getCbpm09()); cbpm.setCbpm10(changeSuggestModel.getCbpm10()); cbpm.setCbpm05(date); cbpm.setCbpm06(changeSuggestDto.getUserId()); cbpmMapper.updateByPrimaryKey(cbpm); } } @Override public int TakeGoodsOrdersm(List<Cbpm> itemList) { if(itemList.size()==0){ throw new SwException("请选择要扫码的商品"); } SqlSession session = sqlSessionFactory.openSession(ExecutorType.BATCH, false); CbpmMapper mapper = session.getMapper(CbpmMapper.class); Date date = new Date(); Long userid = SecurityUtils.getUserId(); for (int i = 0; i < itemList.size(); i++) { Cbpk cbpk = cbpkMapper.selectByPrimaryKey(itemList.get(i).getCbpk01()); if(!cbpk.getCbpk11().equals(2)){ throw new SwException("审核状态才能扫码"); } CbpmCriteria example=new CbpmCriteria(); example.createCriteria() .andCbpk01EqualTo(cbpk.getCbpk01()) .andCbpm09EqualTo(itemList.get(i).getCbpm09()); List<Cbpm> cbpms = cbpmMapper.selectByExample(example); if(cbpms.size()==0){ throw new SwException("您选择的Sn商品不在出库建议表中" ); } /*GsGoodsSnCriteria example0=new GsGoodsSnCriteria(); example0.createCriteria() .andSnEqualTo(itemList.get(i).getCbpm09()); List<GsGoodsSn> gsGoodsSnss = gsGoodsSnMapper.selectByExample(example0); if(gsGoodsSnss.size()>0){ throw new SwException("替换后sn已存在" ); }*/ CbpmCriteria sfgu=new CbpmCriteria(); sfgu.createCriteria() .andCbpm09EqualTo(itemList.get(i).getCbpm09()) .andCbpm11EqualTo(ScanStatusEnum.YISAOMA.getCode()); List<Cbpm> cbpmss = cbpmMapper.selectByExample(sfgu); if(cbpmss.size()>0){ throw new SwException("sn已扫码" ); } itemList.get(i).setCbpm05(date); itemList.get(i).setCbpm06(Math.toIntExact(userid)); itemList.get(i).setCbpm11(ScanStatusEnum.YISAOMA.getCode()); GsGoodsSnCriteria example1 = new GsGoodsSnCriteria(); example1.createCriteria() .andSnEqualTo(itemList.get(i).getCbpm09()); List<GsGoodsSn> gsGoodsSns = gsGoodsSnMapper.selectByExample(example1); if(gsGoodsSns.size()==0){ throw new SwException("您选择的Sn商品不在货物SN表中" ); } GsGoodsSnCriteria example6 = new GsGoodsSnCriteria(); example6.createCriteria() .andSnEqualTo(itemList.get(i).getCbpm09()) .andStatusEqualTo(GoodsType.yck.getCode()); List<GsGoodsSn> gsGoodsSnss = gsGoodsSnMapper.selectByExample(example6); if(gsGoodsSnss.size()>0){ throw new SwException("您选择的Sn商品已经出库" ); } GsGoodsSn goodsSn = new GsGoodsSn(); goodsSn.setId(gsGoodsSns.get(i).getId()); goodsSn.setCreateTime(gsGoodsSns.get(i).getCreateTime()); goodsSn.setCreateBy(gsGoodsSns.get(i).getCreateBy()); goodsSn.setUpdateTime(date); goodsSn.setUpdateBy(Math.toIntExact(userid)); goodsSn.setWhId(gsGoodsSns.get(i).getWhId()); goodsSn.setGoodsId(gsGoodsSns.get(i).getGoodsId()); goodsSn.setSn(itemList.get(i).getCbpm09()); goodsSn.setGroudStatus(Groudstatus.XJ.getCode()); goodsSn.setStatus(GoodsType.yck.getCode()); goodsSn.setLocationId(null); GsGoodsSnCriteria example2 = new GsGoodsSnCriteria(); example2.createCriteria() .andSnEqualTo(itemList.get(i).getCbpm09()); gsGoodsSnMapper.updateByExample(goodsSn, example2); mapper.updateByExampleSelective(itemList.get(i),example); } // Cbpk cbpk=new Cbpk(); // cbpk.setCbpk01(itemList.get(0).getCbpk01()); //cbpk.setCbpk11(TaskStatus.bjwc.getCode()); // cbpkMapper.updateByPrimaryKeySelective(cbpk); // CbpkCriteria example=new CbpkCriteria(); // example.createCriteria() // .andCbpk01EqualTo(itemList.get(0).getCbpk01()); // cbpkMapper.updateByExampleSelective(cbpk,example); session.commit(); session.clearCache(); return 1; } @Override public List<GsOutStockAdivceVo> saleOrderSuggest(GsOutStockAdivceDto gsOutStockAdivceDto) { List<GsOutStockAdivceVo> list= gsOutStockAdivceMapper.saleOrderSuggest(gsOutStockAdivceDto); Map<Integer, String> brandMap = baseCheckService.brandMap(); for (GsOutStockAdivceVo gsOutStockAdivceVo : list) { if (brandMap.get(Integer.parseInt(gsOutStockAdivceVo.getBrand())) != null) { // gsOutStockAdivceVo.setGoodsMsg((brandMap.get(gsOutStockAdivceVo.getBrand()) + "-" + gsOutStockAdivceVo.getModel() + "-" + gsOutStockAdivceVo.getDescription())); gsOutStockAdivceVo.setBrand(brandMap.get(Integer.parseInt(gsOutStockAdivceVo.getBrand()))); } } return list; } @Override public void auditOutStockEnd(GsOutStockAdivceDto gsOutStockAdivceDto) { GsOutStockAdivce gsOutStockAdivce = gsOutStockAdivceMapper.selectByPrimaryKey(gsOutStockAdivceDto.getId()); if(gsOutStockAdivce==null){ throw new SwException("没有查到该调拨建议"); } if(gsOutStockAdivce.getStatus()!=2){ throw new SwException("必须为待调拨状态才能标记完成"); } Date date = new Date(); gsOutStockAdivce.setUpdateTime(date); gsOutStockAdivce.setUpdateBy(gsOutStockAdivceDto.getUserId()); gsOutStockAdivce.setStatus(new Byte("3")); gsOutStockAdivceMapper.updateByPrimaryKey(gsOutStockAdivce); if(gsOutStockAdivce.getWhId().equals(WareHouseType.GQWWHID)){ return; } //增加占用 GsGoodsUseCriteria exeample=new GsGoodsUseCriteria(); exeample.createCriteria() //cdc仓库id .andWhIdEqualTo(WareHouseType.CDCWHID) .andOrderNoEqualTo(gsOutStockAdivce.getSaleOrderNo()) .andGoodsIdEqualTo(gsOutStockAdivce.getGoodsId()); List<GsGoodsUse> gsGoodsUses = gsGoodsUseMapper.selectByExample(exeample); if(gsGoodsUses.size()>0){ GsGoodsUse goodsUse = gsGoodsUses.get(0); goodsUse.setLockQty(goodsUse.getLockQty()+gsOutStockAdivce.getQty()); goodsUse.setUpdateTime(date); gsGoodsUseMapper.updateByPrimaryKey(goodsUse); }else { GsGoodsUse gsGoodsUse=new GsGoodsUse(); gsGoodsUse.setLockQty(gsOutStockAdivce.getQty()); gsGoodsUse.setUpdateTime(date); gsGoodsUse.setUpdateBy(gsOutStockAdivceDto.getUserId()); gsGoodsUse.setWhId(WareHouseType.CDCWHID); // gsGoodsUse.setOrderType(new Byte("1")); gsGoodsUse.setOrderNo(gsOutStockAdivce.getSaleOrderNo()); gsGoodsUse.setGoodsId(gsOutStockAdivce.getGoodsId()); gsGoodsUse.setCreateTime(date); gsGoodsUse.setCreateBy(gsOutStockAdivceDto.getUserId()); gsGoodsUse.setOrderQty(0.0); gsGoodsUseMapper.insert(gsGoodsUse); } //除CDC和GQW 减去仓库的库存占用 GsGoodsUseCriteria usex=new GsGoodsUseCriteria(); usex.createCriteria() .andWhIdEqualTo(gsOutStockAdivce.getWhId()) .andGoodsIdEqualTo(gsOutStockAdivce.getGoodsId()) .andOrderNoEqualTo(gsOutStockAdivce.getSaleOrderNo()); List<GsGoodsUse> gsGoodsUsessub = gsGoodsUseMapper.selectByExample(usex); if(gsGoodsUsessub.size()>0){ GsGoodsUse goodsUse = gsGoodsUsessub.get(0); if((goodsUse.getLockQty()-gsOutStockAdivce.getQty())>0){ goodsUse.setLockQty(goodsUse.getLockQty()-gsOutStockAdivce.getQty()); goodsUse.setUpdateTime(date); gsGoodsUseMapper.updateByPrimaryKey(goodsUse); }else { gsGoodsUseMapper.deleteByPrimaryKey(goodsUse.getId()); } } } /** *@author: zhaoguoliang *@date: Create in 2022/9/29 17:31 *根据商品id和仓库id查未被占用的sn商品 * */ @Override public List<GsGoodsSnVo> selectGoodsSnByWhIdAndGoodsId(Integer whId, Integer goodsId) { List<GsGoodsSnVo> gsGoodsSnVos = gsGoodsSnMapper.selectGoodsSnByWhIdAndGoodsId(whId,goodsId); Map<Integer, String> integerStringMap = baseCheckService.brandMap(); for (GsGoodsSnVo gsGoodsSnVo:gsGoodsSnVos) { if(gsGoodsSnVo.getCbpb10()!=null){ gsGoodsSnVo.setCbpb10(integerStringMap.get(Integer.parseInt(gsGoodsSnVo.getCbpb10()))); } } return gsGoodsSnVos; } @Override @Transactional public void mdfTakeSuggest2(CbpmDto cbpmDto) { CbpmCriteria cbpmCriteria =new CbpmCriteria(); cbpmCriteria.createCriteria().andCbpk01EqualTo(cbpmDto.getCbpk01()); //出货单中的扫码记录 List<Cbpm> cbpmList = cbpmMapper.selectByExample(cbpmCriteria); //前端传过来的参数 List<CbpmDto.CbpmDtoItem> canList = cbpmDto.getGoodsSnList(); //检查出库单中的商品是否存在，如果不存在，则说明在执行删除操作 //销售提货单主表关联的数据遍历 for(Cbpm cbpm:cbpmList){ int index =0; //前端传来的商品遍历 for (CbpmDto.CbpmDtoItem cbpmDtoItem : canList) { //商品在传来的前端传来的商品中 if(cbpm.getCbpm09().equals(cbpmDtoItem.getSn())){ index =1; } } //index为1则说明此商品未被前端删除，index为0则说明商品不在前端传来的商品集合中，已被前端删除 if(index == 0){ //判断商品是否已扫码 if(cbpm.getCbpm11() == 1){ throw new SwException("您选择删除的Sn商品已扫码:" + cbpm.getCbpm09()); } /* CbpmCriteria cbpmCriteria2 =new CbpmCriteria(); cbpmCriteria2.createCriteria() .andCbpm09EqualTo(cbpm.getCbpm09());*/ //删除CBPM表中的数据 cbpmMapper.deleteByPrimaryKey(cbpm.getCbpm01()); GsGoodsSn gsGoodsSn3 = new GsGoodsSn(); gsGoodsSn3.setStatus((byte) 1L); gsGoodsSn3.setGroudStatus((byte) 1L); GsGoodsSnCriteria gsGoodsSnCriteria =new GsGoodsSnCriteria(); gsGoodsSnCriteria.createCriteria().andSnEqualTo(cbpm.getCbpm09()); gsGoodsSnMapper.updateByExampleSelective(gsGoodsSn3,gsGoodsSnCriteria); } } for (CbpmDto.CbpmDtoItem cbpmDtoItem : canList) { int index =0; for(Cbpm cbpm:cbpmList){ if(cbpm.getCbpm09().equals(cbpmDtoItem.getSn())){ index =1; } } if(index == 0){ //检查修改的商品是否在建议出库单中存在 CbpmCriteria example=new CbpmCriteria(); example.createCriteria() .andCbpm09EqualTo(cbpmDtoItem.getSn()); List<Cbpm> cbpms = cbpmMapper.selectByExample(example); if(cbpms.size()>0){ throw new SwException("您选择的Sn商品已经在别的出库单中存在:" + cbpmDtoItem.getSn()); } Cbpm cbpm=new Cbpm(); cbpm.setCbpm07(0); cbpm.setCbpm08(cbpmDtoItem.getGoodsId()); cbpm.setCbpm09(cbpmDtoItem.getSn()); cbpm.setCbpm10(cbpmDtoItem.getLocationId()); cbpm.setCbpm05(new Date()); cbpm.setCbpk01(cbpmDto.getCbpk01()); cbpm.setCbpm06(Integer.parseInt(SecurityUtils.getUserId()+"")); cbpmMapper.insertSelective(cbpm); GsGoodsSn gsGoodsSn2 = new GsGoodsSn(); gsGoodsSn2.setId(cbpmDtoItem.getId()); gsGoodsSn2.setStatus((byte) 2L); gsGoodsSn2.setGroudStatus((byte) 2L); gsGoodsSnMapper.updateByPrimaryKeySelective(gsGoodsSn2); } /* //检查修改的商品是否在建议出库单中存在 CbpmCriteria example=new CbpmCriteria(); example.createCriteria() .andCbpm09EqualTo(changeSuggestModel.getCbpm09()); List<Cbpm> cbpms = cbpmMapper.selectByExample(example); if(cbpms.size()>0 && !cbpms.get(0).getCbpm01().equals(changeSuggestModel.getCbpm01())){ throw new SwException("您选择的Sn商品已经在别的出库单中存在:" + changeSuggestModel.getCbpm09()); } Cbpm cbpm=new Cbpm(); cbpm.setCbpm01(changeSuggestModel.getCbpm01()); cbpm.setCbpm07(changeSuggestModel.getCbpm07()); cbpm.setCbpm08(changeSuggestModel.getCbpm08()); cbpm.setCbpm09(changeSuggestModel.getCbpm09()); cbpm.setCbpm10(changeSuggestModel.getCbpm10()); cbpm.setCbpm05(date); cbpm.setCbpm06(changeSuggestDto.getUserId()); cbpmMapper.updateByPrimaryKey(cbpm);*/ } } }
1.4 Mapper部分
package com.ruoyi.system.mapper; import com.ruoyi.common.core.domain.entity.SysUser; import com.ruoyi.system.domain.SysUserCriteria; import java.util.List; import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Param; @Mapper public interface SysUserMapper { long countByExample(SysUserCriteria example); int deleteByExample(SysUserCriteria example); int deleteByPrimaryKey(Long userId); int insert(SysUser record); int insertSelective(SysUser record); List<SysUser> selectByExample(SysUserCriteria example); SysUser selectByPrimaryKey(Long userId); int updateByExampleSelective(@Param("record") SysUser record, @Param("example") SysUserCriteria example); int updateByExample(@Param("record") SysUser record, @Param("example") SysUserCriteria example); int updateByPrimaryKeySelective(SysUser record); int updateByPrimaryKey(SysUser record); }
略
1.2 文件处理工具类
package com.ruoyi.common.utils.file; import java.io.File; import java.io.FileInputStream; import java.io.FileNotFoundException; import java.io.FileOutputStream; import java.io.IOException; import java.io.OutputStream; import java.io.UnsupportedEncodingException; import java.net.URLEncoder; import java.nio.charset.StandardCharsets; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import org.apache.commons.io.IOUtils; import org.apache.commons.lang3.ArrayUtils; import com.ruoyi.common.config.RuoYiConfig; import com.ruoyi.common.utils.DateUtils; import com.ruoyi.common.utils.StringUtils; import com.ruoyi.common.utils.uuid.IdUtils; import org.apache.commons.io.FilenameUtils; /** * 文件处理工具类 * * @author ruoyi */ public class FileUtils { public static String FILENAME_PATTERN = "[a-zA-Z0-9_\\-\\|\\.\\u4e00-\\u9fa5]+"; /** * 输出指定文件的byte数组 * * @param filePath 文件路径 * @param os 输出流 * @return */ public static void writeBytes(String filePath, OutputStream os) throws IOException { FileInputStream fis = null; try { File file = new File(filePath); if (!file.exists()) { throw new FileNotFoundException(filePath); } fis = new FileInputStream(file); byte[] b = new byte[1024]; int length; while ((length = fis.read(b)) > 0) { os.write(b, 0, length); } } catch (IOException e) { throw e; } finally { IOUtils.close(os); IOUtils.close(fis); } } /** * 写数据到文件中 * * @param data 数据 * @return 目标文件 * @throws IOException IO异常 */ public static String writeImportBytes(byte[] data) throws IOException { return writeBytes(data, RuoYiConfig.getImportPath()); } /** * 写数据到文件中 * * @param data 数据 * @param uploadDir 目标文件 * @return 目标文件 * @throws IOException IO异常 */ public static String writeBytes(byte[] data, String uploadDir) throws IOException { FileOutputStream fos = null; String pathName = ""; try { String extension = getFileExtendName(data); pathName = DateUtils.datePath() + "/" + IdUtils.fastUUID() + "." + extension; File file = FileUploadUtils.getAbsoluteFile(uploadDir, pathName); fos = new FileOutputStream(file); fos.write(data); } finally { IOUtils.close(fos); } return FileUploadUtils.getPathFileName(uploadDir, pathName); } /** * 删除文件 * * @param filePath 文件 * @return */ public static boolean deleteFile(String filePath) { boolean flag = false; File file = new File(filePath); // 路径为文件且不为空则进行删除 if (file.isFile() && file.exists()) { file.delete(); flag = true; } return flag; } /** * 文件名称验证 * * @param filename 文件名称 * @return true 正常 false 非法 */ public static boolean isValidFilename(String filename) { return filename.matches(FILENAME_PATTERN); } /** * 检查文件是否可下载 * * @param resource 需要下载的文件 * @return true 正常 false 非法 */ public static boolean checkAllowDownload(String resource) { // 禁止目录上跳级别 if (StringUtils.contains(resource, "..")) { return false; } // 检查允许下载的文件规则 if (ArrayUtils.contains(MimeTypeUtils.DEFAULT_ALLOWED_EXTENSION, FileTypeUtils.getFileType(resource))) { return true; } // 不在允许下载的文件规则 return false; } /** * 下载文件名重新编码 * * @param request 请求对象 * @param fileName 文件名 * @return 编码后的文件名 */ public static String setFileDownloadHeader(HttpServletRequest request, String fileName) throws UnsupportedEncodingException { final String agent = request.getHeader("USER-AGENT"); String filename = fileName; if (agent.contains("MSIE")) { // IE浏览器 filename = URLEncoder.encode(filename, "utf-8"); filename = filename.replace("+", " "); } else if (agent.contains("Firefox")) { // 火狐浏览器 filename = new String(fileName.getBytes(), "ISO8859-1"); } else if (agent.contains("Chrome")) { // google浏览器 filename = URLEncoder.encode(filename, "utf-8"); } else { // 其它浏览器 filename = URLEncoder.encode(filename, "utf-8"); } return filename; } /** * 下载文件名重新编码 * * @param response 响应对象 * @param realFileName 真实文件名 */ public static void setAttachmentResponseHeader(HttpServletResponse response, String realFileName) throws UnsupportedEncodingException { String percentEncodedFileName = percentEncode(realFileName); StringBuilder contentDispositionValue = new StringBuilder(); contentDispositionValue.append("attachment; filename=") .append(percentEncodedFileName) .append(";") .append("filename*=") .append("utf-8''") .append(percentEncodedFileName); response.addHeader("Access-Control-Expose-Headers", "Content-Disposition,download-filename"); response.setHeader("Content-disposition", contentDispositionValue.toString()); response.setHeader("download-filename", percentEncodedFileName); } /** * 百分号编码工具方法 * * @param s 需要百分号编码的字符串 * @return 百分号编码后的字符串 */ public static String percentEncode(String s) throws UnsupportedEncodingException { String encode = URLEncoder.encode(s, StandardCharsets.UTF_8.toString()); return encode.replaceAll("\\+", "%20"); } /** * 获取图像后缀 * * @param photoByte 图像数据 * @return 后缀名 */ public static String getFileExtendName(byte[] photoByte) { String strFileExtendName = "jpg"; if ((photoByte[0] == 71) && (photoByte[1] == 73) && (photoByte[2] == 70) && (photoByte[3] == 56) && ((photoByte[4] == 55) || (photoByte[4] == 57)) && (photoByte[5] == 97)) { strFileExtendName = "gif"; } else if ((photoByte[6] == 74) && (photoByte[7] == 70) && (photoByte[8] == 73) && (photoByte[9] == 70)) { strFileExtendName = "jpg"; } else if ((photoByte[0] == 66) && (photoByte[1] == 77)) { strFileExtendName = "bmp"; } else if ((photoByte[1] == 80) && (photoByte[2] == 78) && (photoByte[3] == 71)) { strFileExtendName = "png"; } return strFileExtendName; } /** * 获取文件名称 /profile/upload/2022/04/16/ruoyi.png -- ruoyi.png * * @param fileName 路径名称 * @return 没有文件路径的名称 */ public static String getName(String fileName) { if (fileName == null) { return null; } int lastUnixPos = fileName.lastIndexOf('/'); int lastWindowsPos = fileName.lastIndexOf('\\'); int index = Math.max(lastUnixPos, lastWindowsPos); return fileName.substring(index + 1); } /** * 获取不带后缀文件名称 /profile/upload/2022/04/16/ruoyi.png -- ruoyi * * @param fileName 路径名称 * @return 没有文件路径和后缀的名称 */ public static String getNameNotSuffix(String fileName) { if (fileName == null) { return null; } String baseName = FilenameUtils.getBaseName(fileName); return baseName; } }
三.Vue部分
<div style="margin-left: 5%" v-if="edit == 0"> <el-button v-if="status == 1" type="primary" @click="PrintRows">审 核</el-button> <el-button v-else-if="status == 2" type="primary" @click="PrintRowss">反 审</el-button> <el-button v-else type="primary" @click="PrintRow">质 检</el-button> <el-button type="primary" @click="exportDetail">导出</el-button> <el-button type="primary" @click="printTakeOrderOrder">销售订单打印</el-button> <el-button type="primary" @click="printTakeOrderScanLog">扫码记录打印</el-button> <el-button type="primary" @click="printTakeOrderSuggest">出库建议打印</el-button> <el-button type="primary" @click="handlefanhui">返 回</el-button> </div>
// 销售订单打印 printTakeOrderOrder() { const userId = this.$route.params && this.$route.params.cbpc01; this.download( "/whmanagement/printTakeOrderOrder?id=" + userId, {}, `销售提货订单表—_${new Date().toLocaleDateString()}.xls` ); }, // 出库建议表 printTakeOrderSuggest() { const userId = this.$route.params && this.$route.params.cbpc01; this.download( "/whmanagement/printTakeOrderSuggest?id=" + userId, {}, `出库建议表—_${new Date().toLocaleDateString()}.pdf` ); }, // 扫描记录表 printTakeOrderScanLog() { const userId = this.$route.params && this.$route.params.cbpc01; this.download( "/whmanagement/printTakeOrderScanLog?id=" + userId, {}, `扫描记录表—_${new Date().toLocaleDateString()}.pdf` ); },
