| | |
| | | excludeTrash(param); |
| | | EntityWrapper<LocMast> wrapper = new EntityWrapper<>(); |
| | | convert(param, wrapper); |
| | | if (!Cools.isEmpty(orderByField)){wrapper.orderBy(humpToLine(orderByField), "asc".equals(orderByType));} |
| | | if (!Cools.isEmpty(orderByField)) { |
| | | wrapper.orderBy(humpToLine(orderByField), "asc".equals(orderByType)); |
| | | } |
| | | return R.ok(locMastService.selectPage(new Page<>(curr, limit), wrapper)); |
| | | } |
| | | |
| | |
| | | locMastService.updateById(locMast); |
| | | return R.ok(); |
| | | } |
| | | |
| | | public boolean locX(String locNo){ |
| | | switch (locNo){ |
| | | case "1300601": case "1300602": case "1300603": case "1300604": case "1300605": case "1300606": |
| | | case "1300701": case "1300702": case "1300703": case "1300704": case "1300705": case "1300706": |
| | | case "1301301": case "1301302": case "1301303": case "1301304": case "1301305": case "1301306": |
| | | case "1301401": case "1301402": case "1301403": case "1301404": case "1301405": case "1301406": |
| | | case "1302001": case "1302002": case "1302003": case "1302004": case "1302005": case "1302006": |
| | | case "1301205": case "1301206": |
| | | case "1300601": |
| | | case "1300602": |
| | | case "1300603": |
| | | case "1300604": |
| | | case "1300605": |
| | | case "1300606": |
| | | case "1300701": |
| | | case "1300702": |
| | | case "1300703": |
| | | case "1300704": |
| | | case "1300705": |
| | | case "1300706": |
| | | case "1301301": |
| | | case "1301302": |
| | | case "1301303": |
| | | case "1301304": |
| | | case "1301305": |
| | | case "1301306": |
| | | case "1301401": |
| | | case "1301402": |
| | | case "1301403": |
| | | case "1301404": |
| | | case "1301405": |
| | | case "1301406": |
| | | case "1302001": |
| | | case "1302002": |
| | | case "1302003": |
| | | case "1302004": |
| | | case "1302005": |
| | | case "1302006": |
| | | case "1301205": |
| | | case "1301206": |
| | | case "1302402": |
| | | case "1402402": |
| | | return true; |
| | |
| | | locMastService.insertBatch(list); |
| | | return R.ok("初始化成功"); |
| | | } |
| | | |
| | | /** |
| | | * 初始化组 |
| | | */ |
| | | // @GetMapping("/locMast/group") |
| | | private void group(){ |
| | | int i=1; |
| | | for(int row=1;row<17;row++){//列 |
| | | for (int lev=1;lev<8;lev++){//层 |
| | | String s="group1="+i; |
| | | locMastService.updateForSet(s,new EntityWrapper<LocMast>().eq("bay1",row).eq("lev1",lev).ge("row1",1).le("row1",3)); |
| | | i++; |
| | | } |
| | | } |
| | | System.out.println("i="+i); |
| | | for(int row=1;row<17;row++){//排 |
| | | for (int lev=1;lev<8;lev++){//层 |
| | | String s="group1="+i; |
| | | locMastService.updateForSet(s,new EntityWrapper<LocMast>().eq("bay1",row).eq("lev1",lev).ge("row1",5).le("row1",8)); |
| | | i++; |
| | | } |
| | | } |
| | | System.out.println("i="+i); |
| | | for(int row=1;row<17;row++){//排 |
| | | for (int lev=1;lev<8;lev++){//层 |
| | | String s="group1="+i; |
| | | locMastService.updateForSet(s,new EntityWrapper<LocMast>().eq("bay1",row).eq("lev1",lev).ge("row1",9).le("row1",11)); |
| | | i++; |
| | | } |
| | | } |
| | | System.out.println("i="+i); |
| | | for(int row=1;row<17;row++){//排 |
| | | for (int lev=1;lev<8;lev++){//层 |
| | | String s="group1="+i; |
| | | locMastService.updateForSet(s,new EntityWrapper<LocMast>().eq("bay1",row).eq("lev1",lev).ge("row1",13).le("row1",16)); |
| | | i++; |
| | | } |
| | | } |
| | | System.out.println("i="+i); |
| | | for(int row=1;row<17;row++){//排 |
| | | for (int lev=1;lev<8;lev++){//层 |
| | | String s="group1="+i; |
| | | locMastService.updateForSet(s,new EntityWrapper<LocMast>().eq("bay1",row).eq("lev1",lev).ge("row1",17).le("row1",19)); |
| | | i++; |
| | | } |
| | | } |
| | | System.out.println("i="+i); |
| | | for(int row=1;row<17;row++){//排 |
| | | for (int lev=1;lev<8;lev++){//层 |
| | | String s="group1="+i; |
| | | locMastService.updateForSet(s,new EntityWrapper<LocMast>().eq("bay1",row).eq("lev1",lev).ge("row1",21).le("row1",24)); |
| | | i++; |
| | | } |
| | | } |
| | | System.out.println("i="+i); |
| | | for(int row=1;row<17;row++){//排 |
| | | for (int lev=1;lev<8;lev++){//层 |
| | | String s="group1="+i; |
| | | locMastService.updateForSet(s,new EntityWrapper<LocMast>().eq("bay1",row).eq("lev1",lev).ge("row1",25).le("row1",27)); |
| | | i++; |
| | | } |
| | | } |
| | | System.out.println("i="+i); |
| | | for(int row=1;row<17;row++){//排 |
| | | for (int lev=1;lev<8;lev++){//层 |
| | | String s="group1="+i; |
| | | locMastService.updateForSet(s,new EntityWrapper<LocMast>().eq("bay1",row).eq("lev1",lev).ge("row1",29).le("row1",31)); |
| | | i++; |
| | | } |
| | | } |
| | | System.out.println("i="+i); |
| | | } |
| | | } |