| | |
|---|
| | | |
|---|
| | | import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; |
|---|
| | | import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; |
|---|
| | | import com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper; |
|---|
| | | import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper; |
|---|
| | | import com.baomidou.mybatisplus.core.toolkit.StringUtils; |
|---|
| | | import com.baomidou.mybatisplus.core.toolkit.Wrappers; |
|---|
| | |
|---|
| | | .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(BigStorageCage::getDeviceId, query.getDeviceId()) |
|---|
| | | // .eq(BigStorageCage::getDeviceId, query.getDeviceId()) |
|---|
| | | .orderByAsc(BigStorageCage::getDeviceId) |
|---|
| | | .orderByAsc(BigStorageCage::getSlot); |
|---|
| | | return bigStorageCageMapper.selectJoinList(BigStorageAndDetailsDTO.class, wrapper); |
|---|
| | |
|---|
| | | return baseMapper.selectBigStorageSummary(); |
|---|
| | | } |
|---|
| | | |
|---|
| | | @Override |
|---|
| | | public Boolean resetCage() { |
|---|
| | | bigStorageCageDetailsMapper.delete(Wrappers.<BigStorageCageDetails>lambdaQuery().eq(BigStorageCageDetails::getState, Const.GLASS_STATE_NEW)); |
|---|
| | | this.update(new LambdaUpdateWrapper<BigStorageCage>().set(BigStorageCage::getRemainWidth, slotWidth) |
|---|
| | | .notInSql(BigStorageCage::getSlot, "select distinct slot from big_storage_cage_details where state in ( 100, 102, 103, 104)")); |
|---|
| | | return Boolean.TRUE; |
|---|
| | | } |
|---|
| | | |
|---|
| | | // @Override |
|---|
| | | // public List<Integer> queryFreeDeviceByNotUsed(double thickness) { |
|---|
| | | // return baseMapper.queryFreeDeviceByNotUsed(thickness); |
|---|
