| | |
| | | import com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper; |
| | | import com.baomidou.mybatisplus.core.metadata.IPage; |
| | | import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; |
| | | import com.mysql.cj.util.StringUtils; |
| | | import com.zy.asrs.wms.asrs.entity.PickSheet; |
| | | import com.zy.asrs.wms.asrs.entity.PickSheetDetl; |
| | | import com.zy.asrs.wms.asrs.entity.param.PageRequest; |
| | |
| | | import org.springframework.stereotype.Service; |
| | | import org.springframework.transaction.annotation.Transactional; |
| | | |
| | | import java.util.Map; |
| | | import java.util.Objects; |
| | | |
| | | @Service |
| | |
| | | public IPage<PickSheet> getOutFlatSheet(PageRequest params) { |
| | | LambdaQueryWrapper<PickSheet> lambdaQueryWrapper = new LambdaQueryWrapper<>(); |
| | | lambdaQueryWrapper.eq(PickSheet::getDeleted, 0).eq(PickSheet::getStatus, 1); |
| | | if (!Objects.isNull(params.getParams())) { |
| | | lambdaQueryWrapper.eq(!Objects.isNull(params.getParams().get("pickNo")),PickSheet::getPickNo, params.getParams().get("pickNo")) |
| | | .eq(!Objects.isNull(params.getParams().get("id")), PickSheet::getId, params.getParams().get("id")) |
| | | .eq(!Objects.isNull(params.getParams().get("waveNo")), PickSheet::getWaveNo, params.getParams().get("waveNo")); |
| | | Map<String, Object> param = params.getParams(); |
| | | if (!Objects.isNull(param)) { |
| | | lambdaQueryWrapper.eq(!StringUtils.isNullOrEmpty(param.get("pickNo").toString()),PickSheet::getPickNo, param.get("pickNo")) |
| | | .eq(!StringUtils.isNullOrEmpty(param.get("waveNo").toString()), PickSheet::getWaveNo, param.get("waveNo")); |
| | | } |
| | | return this.baseMapper.selectMapsPage(params.getPage(), lambdaQueryWrapper); |
| | | } |