| | |
|---|
| | | import com.mes.bigstorage.entity.BigStorageCage; |
|---|
| | | import com.mes.bigstorage.entity.BigStorageCageDetails; |
|---|
| | | import com.mes.bigstorage.entity.dto.BigStorageAndDetailsDTO; |
|---|
| | | import com.mes.bigstorage.entity.dto.BigStorageSummaryDTO; |
|---|
| | | import com.mes.bigstorage.entity.vo.BigStorageDetailsQueryVO; |
|---|
| | | import com.mes.bigstorage.mapper.BigStorageCageDetailsMapper; |
|---|
| | | import com.mes.bigstorage.mapper.BigStorageCageMapper; |
|---|
| | |
|---|
| | | MPJLambdaWrapper<BigStorageCage> wrapper = new MPJLambdaWrapper<>(); |
|---|
| | | wrapper.selectAll(BigStorageCage.class).selectCollection(BigStorageCageDetails.class, BigStorageCage::getBigStorageCageDetails) |
|---|
| | | .leftJoin(BigStorageCageDetails.class, on -> on.eq(BigStorageCageDetails::getSlot, BigStorageCage::getSlot) |
|---|
| | | .like(StringUtils.isNotBlank(query.getFilmsId()), BigStorageCageDetails::getFilmsId, query.getFilmsId()) |
|---|
| | | .like(StringUtils.isNotBlank(query.getFlowCardId()), BigStorageCageDetails::getFlowCardId, query.getFlowCardId()) |
|---|
| | | .in(BigStorageCageDetails::getState, Const.GLASS_STATE_IN, Const.GLASS_STATE_ARTIFICIAL, Const.GLASS_STATE_OUT_ING)) |
|---|
| | | .eq(BigStorageCageDetails::getDeviceId,query.getDeviceId()) |
|---|
| | | .eq(StringUtils.isNotBlank(query.getFilmsId()),BigStorageCageDetails::getFilmsId,query.getFilmsId()) |
|---|
| | | .eq(StringUtils.isNotBlank(query.getFlowCardId()),BigStorageCageDetails::getFlowCardId,query.getFlowCardId()) |
|---|
| | | .eq(BigStorageCage::getDeviceId, query.getDeviceId()) |
|---|
| | | .orderByAsc(BigStorageCage::getDeviceId) |
|---|
| | | .orderByAsc(BigStorageCage::getSlot); |
|---|
| | | return bigStorageCageMapper.selectJoinList(BigStorageAndDetailsDTO.class, wrapper); |
|---|
| | |
|---|
| | | return baseMapper.queryFreeDeviceByUsed(thickness); |
|---|
| | | } |
|---|
| | | |
|---|
| | | @Override |
|---|
| | | public List<BigStorageSummaryDTO> selectBigStorageSummary() { |
|---|
| | | return baseMapper.selectBigStorageSummary(); |
|---|
| | | } |
|---|
| | | |
|---|
| | | // @Override |
|---|
| | | // public List<Integer> queryFreeDeviceByNotUsed(double thickness) { |
|---|
| | | // return baseMapper.queryFreeDeviceByNotUsed(thickness); |
|---|
