| | |
|---|
| | | } |
|---|
| | | bigStorageCage = bigStorageCageService.getOne(new LambdaQueryWrapper<BigStorageCage>() |
|---|
| | | .eq(BigStorageCage::getEnableState, Const.SLOT_ON) |
|---|
| | | .eq(BigStorageCage::getRemainWidth, slotWidth) |
|---|
| | | .eq(BigStorageCage::getRemainWidth, slotWidth).orderByAsc(BigStorageCage::getSlot) |
|---|
| | | // .notInSql(BigStorageCage::getSlot, "select distinct slot from big_storage_cage_details where state = 0") |
|---|
| | | .inSql(BigStorageCage::getDeviceId, |
|---|
| | | "select distinct device_id from big_storage_cage_details where engineer_id = '" + glassInfo.getEngineerId() + "' and tempering_layout_id = " + glassInfo.getTemperingLayoutId()) |
|---|
| | |
|---|
| | | } |
|---|
| | | for (Integer item : deviceUsedList) { |
|---|
| | | bigStorageCage = bigStorageCageService.getOne(new LambdaQueryWrapper<BigStorageCage>() |
|---|
| | | .eq(BigStorageCage::getRemainWidth, slotWidth) |
|---|
| | | .eq(BigStorageCage::getRemainWidth, slotWidth).orderByAsc(BigStorageCage::getSlot) |
|---|
| | | .eq(BigStorageCage::getEnableState, Const.SLOT_ON) |
|---|
| | | .eq(BigStorageCage::getDeviceId, item) |
|---|
| | | .last("limit 1")); |
|---|
