| | |
|---|
| | | if (endcell == Const.A10_OUT_TARGET_POSITION) { |
|---|
| | | wrapper.innerJoin("(select glass_id, case when height <= width then width else height end as first_length, " + |
|---|
| | | "case when width < height then width else height end as second_length from edg_storage_cage_details) t1 " + |
|---|
| | | "on t.glass_id = t1.glass_id and (t1.first_length >= " + minOneFirstLength + " and t1.second_length >= " + minOneSecondLength); |
|---|
| | | "on t.glass_id = t1.glass_id and (t1.first_length >= " + minOneFirstLength + " and t1.second_length >= " + minOneSecondLength + ")"); |
|---|
| | | } else { |
|---|
| | | wrapper.innerJoin("(select glass_id, case when height <= width then width else height end as first_length, " + |
|---|
| | | "case when width < height then width else height end as second_length from edg_storage_cage_details) t1 " + |
|---|
