package com.wms_admin.server.service.impl; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.wms_admin.server.entity.OutProduct; import com.wms_admin.server.entity.Product; import com.wms_admin.server.mapper.OutProductMapper; import com.wms_admin.server.mapper.ProductMapper; import com.wms_admin.server.service.OutProductService; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import org.springframework.stereotype.Service; import org.springframework.util.ObjectUtils; import javax.annotation.Resource; import java.util.List; import java.util.Map; /** *

* 服务实现类 *

* * @author 江苏鵷雏网络科技有限公司 * @since 2023-05-24 */ @Service public class OutProductServiceImpl extends ServiceImpl implements OutProductService { @Resource private OutProductMapper mapper; @Resource private ProductMapper addMapper; /** * 分页查询出库历史数据 * @param startTime 开始时间 * @param endTime 结束时间 * @param productModel 型号 * @param page 从多少页开始查询,一共查询多少页数据 * @return */ @Override public IPage SelectOutProductPage(String startTime, String endTime, String productModel, Page page) { return mapper.SelectOutProductPage(startTime, endTime, productModel, page); } @Override public void ListAddOutProduct(Integer orderInformationId, String listCode, String outPerson) { LambdaQueryWrapper wrapper = new LambdaQueryWrapper<>(); wrapper.eq(Product::getId, listCode); Product product = addMapper.selectOne(wrapper); if (!ObjectUtils.isEmpty(product)){ OutProduct outProduct = new OutProduct() .setId(listCode) .setOutPerson(outPerson) .setAddTime(product.getCreateTime()) .setUnit(product.getUnit()) .setOutboundQuantity(product.getIncomingQuantity()) .setProductNameId(product.getProductNameId()) .setProductModelId(product.getProductModelId()) .setOrderInformationId(orderInformationId); // 插入出库表格 mapper.insert(outProduct); // 删除入库表中的信息 addMapper.deleteById(listCode); } } @Override public List ExcelDerive(String startTime, String endTime, String productModel) { return mapper.SelectOutProductPage(startTime, endTime, productModel); } }