| | |
|---|
| | | JSONObject jsonObject = new JSONObject(); |
|---|
| | | MPJLambdaWrapper<RawGlassStorageDetails> wrapper = new MPJLambdaWrapper<>(); |
|---|
| | | wrapper.select(RawGlassStorageStation::getSlot) |
|---|
| | | .select(RawGlassStorageDetails::getRemainQuantity) |
|---|
| | | .select("ifnull(remain_quantity, 0) as remain_quantity") |
|---|
| | | .rightJoin(RawGlassStorageStation.class, on -> on.eq(RawGlassStorageStation::getSlot, RawGlassStorageDetails::getSlot) |
|---|
| | | .eq(RawGlassStorageDetails::getState, Const.RAW_GLASS_STATE_IN)) |
|---|
| | | .orderByAsc(RawGlassStorageStation::getSlot); |
|---|
