| | |
| | | .leftJoin(YwWarehouse.class,YwWarehouse::getId,YwStock::getWarehouseId) |
| | | .leftJoin(YwMaterial.class,YwMaterial::getId,YwStock::getMaterialId) |
| | | .eq(Objects.nonNull(model.getWarehouseId()),YwOutinbound::getWarehouseId,model.getWarehouseId()) |
| | | .and(StringUtils.isNotBlank(model.getMaterialCode()),i->i.like(YwMaterial::getName,model.getMaterialCode()).or().like(YwMaterial::getName,model.getMaterialCode())) |
| | | .like(StringUtils.isNotBlank(model.getMaterialCode()),YwMaterial::getCode,model.getMaterialCode()) |
| | | .and(StringUtils.isNotBlank(model.getMaterialCode()),i->i.like(YwMaterial::getCode,model.getMaterialCode()).or().like(YwMaterial::getName,model.getMaterialCode())) |
| | | .like(StringUtils.isNotBlank(model.getMaterialAttr()),YwMaterial::getAttr,model.getMaterialAttr()) |
| | | .orderByAsc(YwMaterial::getCode) |
| | | ; |