基于SpringBoot+Thymeleaf的erp进销存仓库管理系统（前后端代码）

package com.erp.service.impl; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.erp.entity.OrderDetail; import com.erp.entity.Orders; import com.erp.form.OrdersAddForm; import com.erp.form.OrdersSearchForm; import com.erp.form.ReportForm; import com.erp.mapper.OrderDetailMapper; import com.erp.mapper.OrdersMapper; import com.erp.mapper.SupplierMapper; import com.erp.mo.OrdersMO; import com.erp.service.OrdersService; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import com.erp.util.CommonUtils; import com.erp.util.PageObject; import com.erp.vo.OrdersVO; import com.erp.vo.ReportVO; import org.apache.commons.lang.StringUtils; import org.springframework.beans.BeanUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import java.math.BigDecimal; import java.time.LocalDateTime; import java.util.ArrayList; import java.util.List; /** * <p> * 服务实现类 * </p> * * @author admin * @since 2024-02-12 */ @Service public class OrdersServiceImpl extends ServiceImpl<OrdersMapper, Orders> implements OrdersService { @Autowired private OrdersMapper ordersMapper; @Autowired private OrderDetailMapper orderDetailMapper; @Autowired private SupplierMapper supplierMapper; @Override public PageObject ordersList(PageObject pageObject, OrdersSearchForm form) { // List<OrdersVO> ordersVOS=new ArrayList<>(); // List<Orders> orders=this.ordersMapper.selectList(null); // for (Orders order : orders){ // OrdersVO ordersVO =new OrdersVO(); // BeanUtils.copyProperties(order,ordersVO); // Supplier supplier = this.supplierMapper.selectById(order.getSupplierId()); // ordersVO.setSupplierName(supplier.getSupplierName()); // QueryWrapper<OrderDetail> queryWrapper=new QueryWrapper<>(); // queryWrapper.eq("order_no",order.getOrderNo()); // List<OrderDetail> orderDetailList = this.orderDetailMapper.selectList(queryWrapper); // OrderDetail orderDetail = orderDetailList.get(0); // BeanUtils.copyProperties(orderDetail,ordersVO); // ordersVOS.add(ordersVO); // } // return ordersVOS; Long index=(pageObject.getCurrent()-1)*pageObject.getSize(); Long length=pageObject.getSize(); List<OrdersVO> ordersVOList = this.ordersMapper.ordersVOList(index,length,form); PageObject result=new PageObject(); result.setData(ordersVOList); result.setSize(pageObject.getSize()); result.setCurrent(pageObject.getCurrent()); result.setTotal(this.ordersMapper.ordersVOCount(form)); return result; } @Override public PageObject ordersReturnList(PageObject pageObject, OrdersSearchForm form) { Long index = (pageObject.getCurrent()-1)*pageObject.getSize(); Long length = pageObject.getSize(); List<OrdersVO> ordersVOList = this.ordersMapper.ordersReturnVOList(index,length,form); PageObject result = new PageObject(); result.setData(ordersVOList); result.setSize(pageObject.getSize()); result.setCurrent(pageObject.getCurrent()); result.setTotal(this.ordersMapper.ordersReturnVOCount(form)); return result; } @Override public boolean batchDelete(String orderNoArr) { String[] split = orderNoArr.split(","); List<String> orderNoList = new ArrayList<>(); for (String orderNo : split) { // QueryWrapper<Orders> ordersQueryWrapper = new QueryWrapper<>(); // ordersQueryWrapper.eq("order_no", orderNo); // int delete = this.ordersMapper.delete(ordersQueryWrapper); // if(delete != 1) return false; // QueryWrapper<OrderDetail> orderDetailQueryWrapper = new QueryWrapper<>(); // orderDetailQueryWrapper.eq("order_no", orderNo); // int delete1 = this.orderDetailMapper.delete(orderDetailQueryWrapper); // if(delete1 != 1) return false; orderNoList.add(orderNo); } OrdersMO ordersMO = new OrdersMO(); ordersMO.setOrderNos(orderNoList); int i = this.ordersMapper.batchDelete(ordersMO); if(i == 0) return false; int i1 = this.orderDetailMapper.batchDelete(ordersMO); if(i1 == 0) return false; return true; } @Override public boolean batchVerify(String orderNoArr) { String[] split = orderNoArr.split(","); List<String> orderNoList = new ArrayList<>(); for (String orderNo : split) { orderNoList.add(orderNo); } OrdersMO ordersMO = new OrdersMO(); ordersMO.setOrderNos(orderNoList); int i = this.ordersMapper.batchVerify(ordersMO); if(i == 0) return false; return true; } @Override public boolean batchInvalid(String orderNoArr) { String[] split = orderNoArr.split(","); List<String> orderNoList = new ArrayList<>(); for (String orderNo : split) { orderNoList.add(orderNo); } OrdersMO ordersMO = new OrdersMO(); ordersMO.setOrderNos(orderNoList); int i = this.ordersMapper.batchInvalid(ordersMO); if(i == 0) return false; return true; } @Override public boolean save(OrdersAddForm ordersAddForm) { Orders orders=new Orders(); BeanUtils.copyProperties(ordersAddForm,orders); Integer count=this.ordersMapper.selectCount(null); orders.setOrderNo(CommonUtils.createOrderNo(count,ordersAddForm.getOrderType())); orders.setEmployeeName("小明"); if (StringUtils.isNotBlank(ordersAddForm.getOrderDate())){ orders.setOrderDate(CommonUtils.parseString2(ordersAddForm.getOrderDate())); }else { orders.setOrderDate(LocalDateTime.now()); } int insert=this.ordersMapper.insert(orders); if(insert==0) return false; String orderDetailsStr=ordersAddForm.getOrderDetailsStr(); String [] split=orderDetailsStr.split("&"); for (String orderDetailStr : split) { String[] split1=orderDetailsStr.split(","); OrderDetail orderDetail=new OrderDetail(); orderDetail.setMaterialId(Integer.parseInt(split1[0])); orderDetail.setMaterialCode(split1[1]); orderDetail.setMaterialName(split1[2]); orderDetail.setStyle(split1[3]); orderDetail.setUnitName(split1[4]); orderDetail.setOrderId(split1[5]); orderDetail.setBatchNo(split1[6]); orderDetail.setOrderCount(new BigDecimal(split1[7])); orderDetail.setOrderFlag(split1[8]); if(orderDetail.getOrderFlag().equals("冲红")){ orderDetail.setOrderCount(new BigDecimal("-"+split1[7])); } else { orderDetail.setOrderCount(new BigDecimal(split1[7])); } orderDetail.setStorageId(Integer.parseInt(split1[9])); orderDetail.setStorageName(split1[10]); orderDetail.setOrderNo(orders.getOrderNo()); int insert1 = this.orderDetailMapper.insert(orderDetail); if(insert1==0) return false; } return true; } @Override public boolean update(OrdersAddForm ordersAddForm) { //更新Orders Orders orders = new Orders(); BeanUtils.copyProperties(ordersAddForm, orders); Integer count = this.ordersMapper.selectCount(null); orders.setEmployeeName("小明"); if(com.baomidou.mybatisplus.core.toolkit.StringUtils.isNotBlank(ordersAddForm.getOrderDate())){ orders.setOrderDate(CommonUtils.parseString2(ordersAdd