From 5d4062b4caf6af878db6049f8dbefe8ffe41a57e Mon Sep 17 00:00:00 2001 From: wu <731351411@qq.com> Date: 星期二, 23 四月 2024 09:48:13 +0800 Subject: [PATCH] 删除多余代码 --- springboot-vue3/src/main/java/com/example/springboot/controller/HomeController.java | 272 ++++++++++++++++++++++++++++++++++++++--------------- 1 files changed, 194 insertions(+), 78 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 db89bb4..c7a5a08 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 @@ -4,6 +4,7 @@ import java.util.HashMap; import java.util.List; import java.util.Map; +import java.util.concurrent.TimeUnit; import org.springframework.beans.factory.annotation.Autowired; @@ -11,7 +12,11 @@ import com.example.springboot.mapper.SpianMapper; import com.example.springboot.service.HomeService; import com.example.springboot.service.JdbcConnections; +import com.example.springboot.service.North_Glass_Buffer1Service; +import com.example.springboot.service.OutSliceServive; import com.example.springboot.service.SpianService; +import com.example.springboot.service.StorageCageService; + import com.example.springboot.common.Result; import com.example.springboot.component.Plchome; import com.example.springboot.component.S7control; @@ -21,9 +26,9 @@ import com.example.springboot.entity.north_glass_buffer1; import com.example.springboot.entity.Out_slice; import com.example.springboot.entity.Queue; +import com.example.springboot.entity.RolePermission; import org.springframework.web.bind.annotation.*; - @RestController @RequestMapping("/home") @@ -32,20 +37,37 @@ HomeMapper homeMapper; @Autowired - HomeService storageRackService; - - @Autowired SpianService spianService; @Autowired SpianMapper spianMapper; @Autowired + OutSliceServive outSliceServive; + + @Autowired + StorageCageService storageCageService; + + @Autowired + North_Glass_Buffer1Service north_Glass_Buffer1Service; + + @Autowired private JdbcConnections jdbcConnections; - + + // 鑾峰彇褰撳墠鐧诲綍鐢ㄦ埛鏉冮檺 + @GetMapping("/SelectPermissionByUserName") + public Result SelectPermissionByUserName(String username) throws SQLException { + Map<String, Object> map = new HashMap<>(); + List<RolePermission> permission = homeMapper.SelectPermissionByUserName(username); + map.put("permission", permission); + return Result.success(map); + } + // 鏌ヨ鐞嗙墖绗间娇鐢ㄦ儏鍐� @GetMapping("/load") public Result selectAll() { + // storageCageService.EndTask(1); + // UpdateTask(2,0,"X12345610402GV"); List<StorageCage> storageCagelist = homeMapper.selectAll(); Map<String, Object> map = new HashMap<>(); map.put("list", storageCagelist); @@ -103,20 +125,21 @@ return Result.success(map); } - // 鎵嬪姩瀹屾垚杩�/鍑虹墖浠诲姟 + // 鎵嬪姩瀹屾垚杩�/鍑虹墖浠诲姟 缁堟杩涚墖/鍑虹墖浠诲姟 @GetMapping("/UpdateTask") public Result UpdateTask(Integer types, Integer shelfrack, String glassid) { + storageCageService.UpdateTask(types, shelfrack, glassid); Map<String, Object> map = new HashMap<>(); - homeMapper.UpdateTask(types); - StorageCage glass = homeMapper.SelectGlassInfo(glassid); - if (types == 0) { - 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("/EndTask") + public Result EndTask(int types) { + storageCageService.EndTask(types); + + Map<String, Object> map = new HashMap<>(); map.put("message3", "200"); return Result.success(map); } @@ -132,7 +155,7 @@ // 鏌ヨ鐞嗙墖绗艰鎯� @GetMapping("/SelectCageInfo") - public Result SelectCageInfo(short cage) throws SQLException { + public Result SelectCageInfo(String cage) throws SQLException { List<StorageCage> cageinfo = homeMapper.SelectCageInfo(cage); Map<String, Object> map = new HashMap<>(); map.put("cageinfo", cageinfo); @@ -142,9 +165,7 @@ // 鎵嬪姩鍒犻櫎鐞嗙墖绗肩幓鐠� @GetMapping("/DeleteByGlassID") public Result DeleteByGlassID(String glassid) { - StorageCage glassinfor = homeMapper.SelectGlassInfo(glassid); - spianMapper.UpdataOutCage1(glassinfor.getGlassWidth(), glassinfor.getCage(), glassinfor.getCell()); - homeMapper.DeleteByGlassID(glassid); + outSliceServive.DeleteByGlassIDs(glassid); Map<String, Object> map = new HashMap<>(); map.put("message3", "200"); return Result.success(map); @@ -155,11 +176,28 @@ public Result OutByGlassID(String glassid) throws SQLException { Map<String, Object> map = new HashMap<>(); Out_slice result = homeMapper.SelectQueueByglassid(glassid); - if(result==null) { - north_glass_buffer1 north_glass_buffer1=jdbcConnections.SelectGlassByGlassIdOrderIdFrameId(glassid, "", ""); - String flip=jdbcConnections.SelectFlipByFrameBarcode(north_glass_buffer1.getFrameBarcode()); - homeMapper.AddOutSliceS(glassid, flip, north_glass_buffer1.getFrameBarcode(), north_glass_buffer1.getglasslengthmm().toString(), north_glass_buffer1.getglassheightmm().toString()); - map.put("message2", "200"); + if (result == null) { + north_glass_buffer1 north_glass_buffer1 = jdbcConnections.SelectGlassByGlassIdOrderIdFrameId(glassid, "", ""); + String flip = jdbcConnections.SelectFlipByFrameBarcode(north_glass_buffer1.getFrameBarcode()); + + if (flip != null) { + String position = jdbcConnections.SelectPositionByFrameBarcode(north_glass_buffer1.getFrameBarcode()); + if (position != null) { + String framelength = jdbcConnections.SelectFrameLengthByFrameBarcode(north_glass_buffer1.getFrameBarcode()); + String frameheight = jdbcConnections.SelectFrameHeightByFrameBarcode(north_glass_buffer1.getFrameBarcode()); + int sequence = homeMapper.SelectMaxSquence(); + homeMapper.AddOutSliceS(glassid, flip, north_glass_buffer1.getFrameBarcode(), + north_glass_buffer1.getglasslengthmm().toString(), north_glass_buffer1.getglassheightmm().toString(), + sequence, position, (short) 0, north_glass_buffer1.getordernumber(), north_glass_buffer1.getlistnumber(), + north_glass_buffer1.getboxnumber(), north_glass_buffer1.getglasslength().toString(), + north_glass_buffer1.getglassheight().toString(), framelength, frameheight); + map.put("message2", "200"); + } else { + map.put("message2", "300"); + } + } else { + map.put("message2", "400"); + } } else { map.put("message2", "500"); } @@ -187,9 +225,9 @@ // 鏍规嵁鐜荤拑id鏌ヨ鐜荤拑淇℃伅 @GetMapping("/SelectGlassByGlassID") public Result SelectGlassByGlassID(String glassid) throws SQLException { - Queue queue=jdbcConnections.SelectGlassByGlassIdOrderIdFrameIdQueue(glassid, "", ""); + Queue queue = jdbcConnections.SelectGlassByGlassIdOrderIdFrameIdQueue(glassid, "", ""); Map<String, Object> map = new HashMap<>(); - if(glassid!=""){ + if (glassid != "") { map.put("form", queue); } return Result.success(map); @@ -209,11 +247,17 @@ public Result Inglassid(short cage, short cell, short tier, @RequestBody Queue queue) { Map<String, Object> map = new HashMap<>(); short result = homeMapper.SelectStorageByGlassId(queue.getglassId()); - if (result > 0) { - map.put("message", "300"); + Double cagewidth = homeMapper.SelectCageWidth(cage, cell); + if (cagewidth - queue.getglasswidth() - 400 < 0 || (cagewidth == 2750 && queue.getglasswidth() > cagewidth)) { + map.put("message", "400"); } else { - homeMapper.Inglassid(queue, cage, cell, tier); - spianMapper.UpdataAddCage1(queue.getglasswidth(), cage, cell); + if (result > 0) { + map.put("message", "300"); + } else { + homeMapper.Inglassid(queue, cage, cell, tier); + spianMapper.UpdataAddCage1(queue.getglasswidth(), cage, cell); + map.put("message", "200"); + } } return Result.success(map); } @@ -229,18 +273,9 @@ // 鎵嬪姩娣诲姞鎵爜浣嶇幓鐠� @PostMapping("/InsertQueueGlassId") - public Result InsertQueueGlassId(Short id,@RequestBody Queue queue) { - Map<String, Object> map = new HashMap<>(); - short result = homeMapper.SelectStorageByGlassId(queue.getglassId()); - if (result > 0) { - map.put("message", "300"); - } else { - homeMapper.InsertQueueGlassId(queue, id); - //璋冪敤浼嶅瓨鍌ㄨ繃绋� - spianService.selectAll(queue.getglassId()); - map.put("message", "200"); - } - return Result.success(map); + public Result InsertQueueGlassId(Short id, @RequestBody Queue queue) { + return storageCageService.InsertQueueGlassId(id, queue); + } // 纭鎵爜浣嶇幓鐠冧俊鎭� @@ -273,48 +308,53 @@ // 鏍规嵁閾濇id鑾峰彇瀵瑰簲鐜荤拑淇℃伅 @PostMapping("/SelectAluminumFrameInfoById") public Result SelectAluminumFrameInfoById(String FrameBarcode) throws SQLException { - List<north_glass_buffer1> listAluminumFrame = jdbcConnections.SelectGlassByGlassIdOrderIdFrameIdss(FrameBarcode); - String flip=jdbcConnections.SelectFlipByFrameBarcode(FrameBarcode); - for (north_glass_buffer1 north_glass_buffer1 : listAluminumFrame) { - north_glass_buffer1.setstorageCage(homeMapper.SelectStorageGlassById(north_glass_buffer1.getbarcode())); - north_glass_buffer1.setOut_slice(homeMapper.SelectQueueByglassid(north_glass_buffer1.getbarcode())); - } + String flip = jdbcConnections.SelectFlipByFrameBarcode(FrameBarcode); + List<north_glass_buffer1> AluminumFrame = north_Glass_Buffer1Service.SelectAluminumFrameInfoById(FrameBarcode); Map<String, Object> map = new HashMap<>(); - map.put("listAluminumFrame", listAluminumFrame); + map.put("AluminumFrame", AluminumFrame); map.put("flip", flip); return Result.success(map); } - - // 鏌ヨ鍑虹墖闃熷垪鏁版嵁 - @PostMapping("/SelectProductionqueue") - public Result SelectProductionqueue() throws SQLException { - List<Out_slice> listoutslice = homeMapper.SelectProductionqueue(); - for (Out_slice out_slice : listoutslice) { - out_slice.setnorth_glass_buffer1s(jdbcConnections.SelectGlassByGlassIdOrderIdFrameId(out_slice.getGlassId(), "", "")); - out_slice.setstorageCage(homeMapper.SelectStorageGlassById(out_slice.getGlassId())); - } - Map<String, Object> maps = new HashMap<>(); - maps.put("listoutslice", listoutslice); - // Plchome.isAllowQueue=false; - return Result.success(maps); - + + // 鏍规嵁閾濇id鍒犻櫎鍑虹墖闃熷垪鐜荤拑 + @PostMapping("/DeleteProductionQueueGlass") + public Result DeleteProductionQueueGlass(String FrameNo) { + return outSliceServive.CompleteQueueByFrameNo(FrameNo); } - // 鏍规嵁鐜荤拑id鍒犻櫎鍑虹墖闃熷垪鐜荤拑 - @PostMapping("/DeleteProductionQueueGlass") - public Result DeleteProductionQueueGlass(Short id) { - homeMapper.DeleteProductionQueueGlass(id); + // 娣诲姞閾濇id瀵瑰簲鐜荤拑鍒板嚭鐗囬槦鍒� + @PostMapping("/AddOutSliceS") + public Result AddOutSliceS(String FrameNo) throws SQLException { + // public Result AddOutSliceS(@RequestBody String[][] AluminumFrames) throws + // SQLException { + north_Glass_Buffer1Service.AddOutSliceS(FrameNo); Map<String, Object> map = new HashMap<>(); map.put("message", "200"); return Result.success(map); } - //娣诲姞鍑虹墖 - @PostMapping("/AddOutSliceS") - public Result AddOutSliceS(@RequestBody String[][] AluminumFrames ) { - for (String[] item : AluminumFrames) { - if(item[1]=="true"){ - homeMapper.AddOutSliceS(item[0],item[2],item[3],item[4],item[5]); + // 淇敼鍑虹墖闃熷垪鍑虹墖鐘舵�� + @PostMapping("/isAllowQueues") + public Result isAllowQueues(Boolean isAllowQueue, @RequestBody List<Out_slice> out_slice) { + Plchome.isAllowQueue = isAllowQueue; + // if (isAllowQueue == true) { + // for (Out_slice out_slice2 : out_slice) { + // homeMapper.UpdateOutSliceSequence(out_slice2.getGlassId(), + // out_slice2.getSequence()); + // } + // } + Map<String, Object> map = new HashMap<>(); + map.put("message", "200"); + return Result.success(map); + } + + // 淇敼鍑虹墖闃熷垪璋冨簭鐘舵�佷笌鍑虹墖闃熷垪璋冨簭 + @PostMapping("/isAllowReorderings") + public Result isAllowReorderings(Boolean isAllowReordering, @RequestBody List<Out_slice> out_slice) { + Plchome.isAllowReordering = isAllowReordering; + if (isAllowReordering == true) { + for (Out_slice out_slice2 : out_slice) { + homeMapper.UpdateOutSliceSequence(out_slice2.getGlassId(), out_slice2.getSequence()); } } Map<String, Object> map = new HashMap<>(); @@ -322,12 +362,88 @@ return Result.success(map); } - //淇敼鍑虹墖闃熷垪鐘舵�� - @PostMapping("/isAllowQueues") - public Result isAllowQueues(Boolean isAllowQueue) { - Plchome.isAllowQueue=isAllowQueue; + // 淇敼鍑虹墖闃熷垪鐘舵�佷笌鍑虹墖闃熷垪璋冨簭 + @PostMapping("/isConfirmStates") + public Result isConfirmStates(Boolean isConfirmStates) { + Plchome.isConfirm = isConfirmStates; Map<String, Object> map = new HashMap<>(); map.put("message", "200"); return Result.success(map); } + + // 鎵嬪姩瀹屾垚浠诲姟 + @PostMapping("/CompleteQueue") + public Result CompleteQueue(String id, String frameid, String glassid) { + return outSliceServive.CompleteQueue(id, frameid, glassid); + } + + // 鎵嬪姩瀹屾垚浠诲姟 + @PostMapping("/FrameStateUpdate") + public Result FrameStateUpdate(String frameno) { + return outSliceServive.FrameStateUpdate(frameno); + } + + // 鎵嬪姩鍐欏叆plc鎵爜浣嶇幓鐠僫d + @PostMapping("/WriteGlassID") + public Result WriteGlassID(String glassid) { + // 鎵爜浣嶅啓鍏ョ幓鐠僫d + spianService.outmesid(glassid, "DB103.286"); + Map<String, Object> map = new HashMap<>(); + map.put("message", "200"); + return Result.success(map); + } + + // 娓呴櫎鎸囧畾浣嶇疆id + @PostMapping("/ClearGlassId") + public Result ClearGlassId(String position, String glassid) { + return storageCageService.ClearGlassId(position, glassid); + } + + // 娓呴櫎寰呯‘璁ら摑妗嗕俊鎭� + @PostMapping("/CloseForm7") + public Result CloseForm7() { + Plchome.AluminumFrame = null; + Map<String, Object> map = new HashMap<>(); + map.put("message", "200"); + return Result.success(map); + } + + // 缁堟杩�/鍑虹墖浠诲姟 + @PostMapping("/TaskStop") + public Result TaskStop(Short num) { + storageCageService.EndTask(num); + Map<String, Object> map = new HashMap<>(); + map.put("message", "200"); + return Result.success(map); + } + + // 杞�ュ仠 + @PostMapping("/SoftEmergencyStop") + public Result SoftEmergencyStop(Short num) { + String position = "DB101.11.3"; + Map<String, Object> map = new HashMap<>(); + if (S7control.getinstance().CheckConnected() == true) { + S7control.getinstance().WriteBit(position, false); + try { + TimeUnit.MILLISECONDS.sleep(300); + } catch (InterruptedException e) { + e.printStackTrace(); + } + S7control.getinstance().WriteBit(position, true); + map.put("message", "200"); + } else { + map.put("message", "300"); + } + return Result.success(map); + } + + // 鍒囨崲PLC鑾峰彇浜岀淮鐮佹柟寮� + @PostMapping("/SwitchScanMethod") + public Result SwitchScanMethod(Boolean scansmethod) { + S7control.getinstance().WriteBit("DB101.11.4", scansmethod); + Map<String, Object> map = new HashMap<>(); + map.put("message", "200"); + return Result.success(map); + } + } -- Gitblit v1.8.0