| | |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | |
| | | import com.example.springboot.mapper.HomeMapper; |
| | | import com.example.springboot.mapper.SpianMapper; |
| | | import com.example.springboot.service.HomeService; |
| | | import com.example.springboot.service.SpianService; |
| | | import com.example.springboot.common.Result; |
| | | import com.example.springboot.component.S7control; |
| | | import com.example.springboot.entity.CarPosition; |
| | | import com.example.springboot.entity.Glass; |
| | | import com.example.springboot.entity.StorageCage; |
| | | import com.example.springboot.entity.alarmmg; |
| | | |
| | | import org.springframework.web.bind.annotation.*; |
| | | |
| | |
| | | @Autowired |
| | | HomeService storageRackService; |
| | | |
| | | @GetMapping("/load") |
| | | public Result selectAll(){ |
| | | List<StorageCage> storageCagelist=homeMapper.selectAll(); |
| | | Map<String, Object> map = new HashMap<>(); |
| | | map.put("list",storageCagelist); |
| | | return Result.success(map); |
| | | } |
| | | @Autowired |
| | | SpianService spianService; |
| | | |
| | | @GetMapping("/loads") |
| | | public Result selectRack(){ |
| | | List<StorageCage> storageCagelist1=homeMapper.selectRack1(); |
| | | List<StorageCage> storageCagelist2=homeMapper.selectRack2(); |
| | | List<StorageCage> storageCagelist3=homeMapper.selectRack3(); |
| | | List<StorageCage> storageCagelist4=homeMapper.selectRack4(); |
| | | @Autowired |
| | | SpianMapper spianMapper; |
| | | |
| | | //查询理片笼使用情况 |
| | | @GetMapping("/load") |
| | | public Result selectAll() { |
| | | List<StorageCage> storageCagelist = homeMapper.selectAll(); |
| | | Map<String, Object> map = new HashMap<>(); |
| | | map.put("list1",storageCagelist1); |
| | | map.put("list2",storageCagelist2); |
| | | map.put("list3",storageCagelist3); |
| | | map.put("list4",storageCagelist4); |
| | | map.put("list", storageCagelist); |
| | | return Result.success(map); |
| | | } |
| | | |
| | | |
| | | @GetMapping("/loadinout") |
| | | public Result selectinout(Integer types){ |
| | | List<StorageCage> storageCageinout=homeMapper.selectinout(types); |
| | | //查询理片笼玻璃情况 |
| | | @GetMapping("/loads") |
| | | public Result selectRack() { |
| | | List<StorageCage> storageCagelist1 = homeMapper.selectRack1(); |
| | | List<StorageCage> storageCagelist2 = homeMapper.selectRack2(); |
| | | List<StorageCage> storageCagelist3 = homeMapper.selectRack3(); |
| | | List<StorageCage> storageCagelist4 = homeMapper.selectRack4(); |
| | | Map<String, Object> map = new HashMap<>(); |
| | | map.put("list",storageCageinout); |
| | | map.put("list1", storageCagelist1); |
| | | map.put("list2", storageCagelist2); |
| | | map.put("list3", storageCagelist3); |
| | | map.put("list4", storageCagelist4); |
| | | return Result.success(map); |
| | | } |
| | | |
| | | //查询进/出片任务 |
| | | @GetMapping("/loadinout") |
| | | public Result selectinout(Integer types) { |
| | | List<StorageCage> storageCageinout = homeMapper.selectinout(types); |
| | | Map<String, Object> map = new HashMap<>(); |
| | | map.put("list", storageCageinout); |
| | | return Result.success(map); |
| | | } |
| | | //按订单出片 |
| | | @GetMapping("/InsertOrder") |
| | | public Result InsertOrder(String orderid){ |
| | | short result=homeMapper.SelectOrder(orderid); |
| | | public Result InsertOrder(String orderid) { |
| | | short result = homeMapper.SelectOrder(orderid); |
| | | Map<String, Object> map = new HashMap<>(); |
| | | if(result>0){ |
| | | if (result > 0) { |
| | | homeMapper.updateOrder(); |
| | | homeMapper.InsertOrder(orderid); |
| | | map.put("message","200"); |
| | | }else{ |
| | | map.put("message","500"); |
| | | map.put("message", "200"); |
| | | } else { |
| | | map.put("message", "500"); |
| | | } |
| | | return Result.success(map); |
| | | } |
| | | |
| | | //根据玻璃id手动上片 |
| | | @GetMapping("/Addglassid") |
| | | public Result Addglassid(Integer glassid){ |
| | | public Result Addglassid(String glassid) { |
| | | Map<String, Object> map = new HashMap<>(); |
| | | short taskno=homeMapper.SelectOutTask(); |
| | | if(taskno>0){ |
| | | map.put("message2","500"); |
| | | }else{ |
| | | map.put("message2","200"); |
| | | //调用伍上片函数 |
| | | |
| | | short taskno = homeMapper.SelectInTask(); |
| | | if (taskno > 0) { |
| | | map.put("message2", "500"); |
| | | } else { |
| | | // 调用伍上片函数 |
| | | short results = spianService.selectAll(glassid); |
| | | if (results == 200) { |
| | | map.put("message2", "200"); |
| | | } else if (results == 300) { |
| | | map.put("message2", "300"); |
| | | } else if (results == 400) { |
| | | map.put("message2", "400"); |
| | | } |
| | | } |
| | | return Result.success(map); |
| | | } |
| | | //手动完成进/出片任务 |
| | | @GetMapping("/UpdateTask") |
| | | public Result UpdateTask(Integer types, Integer shelfrack, String glassid) { |
| | | Map<String, Object> map = new HashMap<>(); |
| | | homeMapper.UpdateTask(types); |
| | | StorageCage glass = homeMapper.SelectGlassInfo(glassid); |
| | | if (types == 0) { |
| | | // spianMapper.UpdataAddCage1(glass.getGlassWidth(),glass.getCage(),glass.getCell()); |
| | | homeMapper.UpdateCageTask1(glassid); |
| | | S7control.getinstance().WriteWord("DB105.14", (short) 0); |
| | | } else { |
| | | |
| | | spianMapper.UpdataOutCage1(glass.getGlassWidth(), glass.getCage(), glass.getCell()); |
| | | homeMapper.UpdateCageTask2(glassid); |
| | | S7control.getinstance().WriteWord("DB105.12", (short) 0); |
| | | } |
| | | map.put("message3", "200"); |
| | | return Result.success(map); |
| | | } |
| | | //查询报警信息 |
| | | @GetMapping("/SelectAlarmmgInfo") |
| | | public Result SelectAlarmmgInfo() { |
| | | List<alarmmg> alarmmg = homeMapper.SelectAlarmmgInfo(); |
| | | Map<String, Object> map = new HashMap<>(); |
| | | map.put("alarmmg", alarmmg); |
| | | return Result.success(map); |
| | | } |
| | | //查询理片笼详情 |
| | | @GetMapping("/SelectCageInfo") |
| | | public Result SelectCageInfo(short cage) { |
| | | List<StorageCage> cageinfo = homeMapper.SelectCageInfo(cage); |
| | | Map<String, Object> map = new HashMap<>(); |
| | | map.put("cageinfo", cageinfo); |
| | | return Result.success(map); |
| | | } |
| | | //手动删除理片笼玻璃 |
| | | @GetMapping("/DeleteByGlassID") |
| | | public Result DeleteByGlassID(String glassid) { |
| | | StorageCage glassinfor = homeMapper.SelectGlassInfo(glassid); |
| | | spianMapper.UpdataOutCage1(glassinfor.getGlassWidth(), glassinfor.getCage(), glassinfor.getCell()); |
| | | homeMapper.DeleteByGlassID(glassid); |
| | | Map<String, Object> map = new HashMap<>(); |
| | | map.put("message3", "200"); |
| | | return Result.success(map); |
| | | } |
| | | //根据玻璃id手动出片 |
| | | @GetMapping("/OutByGlassID") |
| | | public Result OutByGlassID(String glassid) { |
| | | Map<String, Object> map = new HashMap<>(); |
| | | // 调用伍上片函数 |
| | | short result = homeMapper.SelectStorageByGlassId(glassid); |
| | | if (result > 0) { |
| | | Short results = spianService.selectout2(glassid); |
| | | if (results == 200) { |
| | | map.put("message2", "200"); |
| | | } else if (results == 300) { |
| | | map.put("message2", "300"); |
| | | } |
| | | }else{ |
| | | map.put("message2", "500"); |
| | | } |
| | | |
| | | return Result.success(map); |
| | | } |
| | | //加载小车位置 |
| | | @GetMapping("/Loadcarlist") |
| | | public Result Loadcarlist() { |
| | | List<CarPosition> carlist = homeMapper.Loadcarlist(); |
| | | Map<String, Object> map = new HashMap<>(); |
| | | map.put("carlist", carlist); |
| | | return Result.success(map); |
| | | } |
| | | //查询确认密码 |
| | | @GetMapping("/SelectPassword") |
| | | public Result SelectPassword() { |
| | | String pwdct = homeMapper.SelectPassword(); |
| | | Map<String, Object> map = new HashMap<>(); |
| | | map.put("password", pwdct); |
| | | return Result.success(map); |
| | | } |
| | | //根据玻璃id查询玻璃信息 |
| | | @GetMapping("/SelectGlassByGlassID") |
| | | public Result SelectGlassByGlassID(String glassid) { |
| | | Glass Glass = homeMapper.SelectGlassByGlassID(glassid); |
| | | Map<String, Object> map = new HashMap<>(); |
| | | map.put("form", Glass); |
| | | return Result.success(map); |
| | | } |
| | | //启用/禁用理片笼格子 |
| | | @GetMapping("/Disabled") |
| | | public Result Disabled(short cage, short cell, short disabled) { |
| | | homeMapper.Disabled(cage, cell, disabled); |
| | | Map<String, Object> map = new HashMap<>(); |
| | | map.put("message", "200"); |
| | | return Result.success(map); |
| | | } |
| | | //手动往理片笼添加玻璃 |
| | | @PostMapping("/Inglassid") |
| | | public Result Inglassid(short cage, short cell, short tier, @RequestBody Glass glass) { |
| | | Map<String, Object> map = new HashMap<>(); |
| | | short result = homeMapper.SelectStorageByGlassId(glass.getGlassId()); |
| | | if (result > 0) { |
| | | map.put("message", "300"); |
| | | } else { |
| | | homeMapper.Inglassid(glass, cage, cell, tier); |
| | | spianMapper.UpdataAddCage1(glass.getWidth(), cage, cell); |
| | | } |
| | | return Result.success(map); |
| | | } |
| | | |
| | | //查询玻璃信息 |
| | | @PostMapping("/SelectGlass") |
| | | public Result SelectGlass(String orderid) { |
| | | Map<String, Object> map = new HashMap<>(); |
| | | List<Glass> glass=homeMapper.SelectGlass(orderid); |
| | | map.put("glass", glass); |
| | | return Result.success(map); |
| | | } |
| | | |
| | | //手动添加扫码位玻璃 |
| | | @PostMapping("/InsertQueueGlassId") |
| | | public Result InsertQueueGlassId(String glassid,Short id) { |
| | | Map<String, Object> map = new HashMap<>(); |
| | | short result = homeMapper.SelectStorageByGlassId(glassid); |
| | | if (result > 0) { |
| | | map.put("message", "300"); |
| | | }else{ |
| | | homeMapper.InsertQueueGlassId(glassid,id); |
| | | map.put("message", "200"); |
| | | } |
| | | return Result.success(map); |
| | | } |
| | | |
| | | //确认扫码位玻璃信息 |
| | | @PostMapping("/UpdateQueueState") |
| | | public Result UpdateQueueState() { |
| | | homeMapper.UpdateQueueState(); |
| | | Map<String, Object> map = new HashMap<>(); |
| | | map.put("message", "200"); |
| | | return Result.success(map); |
| | | } |
| | | |
| | | //清除上片队列玻璃 |
| | | @PostMapping("/DeleteQueueGlass") |
| | | public Result DeleteQueueGlass(String id) { |
| | | homeMapper.DeleteQueueGlass(id); |
| | | Map<String, Object> map = new HashMap<>(); |
| | | map.put("message", "200"); |
| | | return Result.success(map); |
| | | } |
| | | |
| | | |
| | | } |