| | |
|---|
| | | .selectAll(BigStorageCage.class) |
|---|
| | | .leftJoin(BigStorageCageDetails.class, BigStorageCageDetails::getSlot, BigStorageCage::getSlot) |
|---|
| | | .eq(BigStorageCage::getEnableState, Const.SLOT_ON) |
|---|
| | | .eq(BigStorageCageDetails::getEngineerId,glassInfo.getEngineerId()) |
|---|
| | | .eq(BigStorageCageDetails::getTemperingLayoutId, glassInfo.getTemperingLayoutId()) |
|---|
| | | .gt(BigStorageCage::getRemainWidth, Math.max(glassInfo.getWidth(), glassInfo.getHeight())) |
|---|
| | | .last("limit 1"); |
|---|
| | |
|---|
| | | .eq(BigStorageCage::getRemainWidth, slotWidth) |
|---|
| | | .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 tempering_layout_id = " + glassInfo.getTemperingLayoutId()) |
|---|
| | | "select distinct device_id from big_storage_cage_details where engineer_id = "+glassInfo.getEngineerId()+" and tempering_layout_id = " + glassInfo.getTemperingLayoutId()) |
|---|
| | | .last("limit 1")); |
|---|
| | | if (null != bigStorageCage) { |
|---|
| | | bigStorageDTO = new BigStorageDTO(); |
|---|
