From 4b4545d1e3ad228ba819e3313853a6e987ef36e6 Mon Sep 17 00:00:00 2001 From: wu <731351411@qq.com> Date: 星期三, 20 九月 2023 01:19:50 +0800 Subject: [PATCH] 1,取消在开始进片或出片时结束之前的任务,改为进片车或出片车变空闲后立即结束数据库任务表的任务状态; 2,手动删除玻璃时恢复数据库理片笼信息中的剩余宽度 --- springboot-vue3/src/main/java/com/example/springboot/controller/HomeController.java | 157 ++++++++++++++++++++++++++++++++++++++++------------ 1 files changed, 121 insertions(+), 36 deletions(-) diff --git a/springboot-vue3/src/main/java/com/example/springboot/controller/HomeController.java b/springboot-vue3/src/main/java/com/example/springboot/controller/HomeController.java index f21eb5f..ed33db8 100644 --- a/springboot-vue3/src/main/java/com/example/springboot/controller/HomeController.java +++ b/springboot-vue3/src/main/java/com/example/springboot/controller/HomeController.java @@ -7,9 +7,14 @@ 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.StorageCage; +import com.example.springboot.entity.alarmmg; import org.springframework.web.bind.annotation.*; @@ -22,71 +27,151 @@ @Autowired HomeService storageRackService; - @GetMapping("/load") - public Result selectAll(){ - List<StorageCage> storageCagelist=homeMapper.selectAll(); + @Autowired + SpianService spianService; + + @Autowired + SpianMapper spianMapper; + + @GetMapping("/load") + public Result selectAll() { + List<StorageCage> storageCagelist = homeMapper.selectAll(); Map<String, Object> map = new HashMap<>(); - map.put("list",storageCagelist); + map.put("list", storageCagelist); return Result.success(map); } - @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(); + @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("list1",storageCagelist1); - map.put("list2",storageCagelist2); - map.put("list3",storageCagelist3); - map.put("list4",storageCagelist4); + 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); + + @GetMapping("/loadinout") + public Result selectinout(Integer types) { + List<StorageCage> storageCageinout = homeMapper.selectinout(types); Map<String, Object> map = new HashMap<>(); - map.put("list",storageCageinout); + 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); } @GetMapping("/Addglassid") - public Result Addglassid(Integer glassid){ + public Result Addglassid(short 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.SelectOutTask(); + if (taskno > 0) { + map.put("message2", "500"); + } else { + // 璋冪敤浼嶄笂鐗囧嚱鏁� + short results = spianService.selectAll(Short.toString(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 shelf_rack){ + public Result UpdateTask(Integer types, Integer shelfrack, Integer glassid) { Map<String, Object> map = new HashMap<>(); - homeMapper.UpdateTask(types,shelf_rack); - map.put("message2","200"); + 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(short glassid) { + StorageCage glassinfor= homeMapper.SelectGlassInfo(Integer.valueOf(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); + } + + @GetMapping("/OutByGlassID") + public Result OutByGlassID(String glassid) { + Map<String, Object> map = new HashMap<>(); + // 璋冪敤浼嶄笂鐗囧嚱鏁� + Short results = spianService.selectout2(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("/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); + } + } -- Gitblit v1.8.0