| | |
| | | List<LocMast> locMasts1 = locMastService.queryFreeLocMastEnd0(locMast1.getBay1(), locMast1.getLev1(),locMast1.getRow1()); |
| | | Integer innermostRow = Utils.getInnermostRow(locMasts1.get(0).getLocNo()); |
| | | for (LocMast locMast2:locMasts1){ |
| | | if (locMast2.getRow1().equals(innermostRow)) { |
| | | locMast = locMast2; |
| | | if (locMast2.getLocSts().equals("O")){ |
| | | if (locMast2.getRow1().equals(innermostRow)) { |
| | | locMast = locMast2; |
| | | break; |
| | | } |
| | | }else if (!locMast2.getLocSts().equals("F")){ |
| | | break; |
| | | } |
| | | } |
| | |
| | | from asr_loc_mast |
| | | where bay1=#{bay} |
| | | and lev1=#{lev} |
| | | and loc_sts='O' |
| | | -- and loc_sts='O' |
| | | and loc_no not in ('0100101', '0200101', '0300101', '1200701', '1300701', '1400701', '1900401', '2000401', '2100401') |
| | | <if test="row1 >= 1 and row1 <= 3"> |
| | | and row1 >= 1 and row1 <= 3 |