From 183c3ed6b30e3edf5e44c8bd2128d3be968bc1f4 Mon Sep 17 00:00:00 2001 From: wuyouming666 <2265557248@qq.com> Date: 星期一, 20 五月 2024 13:47:50 +0800 Subject: [PATCH] Merge branch 'master' of http://10.153.19.25:10101/r/CanadaMes --- springboot-vue3/src/main/java/com/example/springboot/service/SpianService.java | 721 ++++++++++++++++++++++++++---------------------------- 1 files changed, 346 insertions(+), 375 deletions(-) diff --git a/springboot-vue3/src/main/java/com/example/springboot/service/SpianService.java b/springboot-vue3/src/main/java/com/example/springboot/service/SpianService.java index 9a6cb6a..0c403e4 100644 --- a/springboot-vue3/src/main/java/com/example/springboot/service/SpianService.java +++ b/springboot-vue3/src/main/java/com/example/springboot/service/SpianService.java @@ -1,16 +1,21 @@ package com.example.springboot.service; -import java.lang.reflect.Array; +import java.io.BufferedReader; +import java.io.FileInputStream; +import java.io.FileNotFoundException; +import java.io.IOException; +import java.io.InputStreamReader; +import java.io.UnsupportedEncodingException; +import java.nio.charset.StandardCharsets; +import java.time.LocalDateTime; import java.util.ArrayList; import java.util.List; - import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; - -import com.example.springboot.common.Result; import com.example.springboot.component.S7control; -import com.example.springboot.entity.Glass; import com.example.springboot.entity.StorageCage; +import com.example.springboot.entity.north_glass_buffer1; +import com.example.springboot.mapper.HomeMapper; import com.example.springboot.mapper.SpianMapper; import com.google.common.primitives.Bytes; @@ -18,13 +23,15 @@ public class SpianService { @Autowired private SpianMapper spianMapper; - + @Autowired + private HomeMapper homeMapper; + public static List<String> result=new ArrayList<String>(); // @GetMapping("/all") - // 杩涚墖浠诲姟,浼犺鍗昳d - // 鎸夎鍗曚紭鍏堣繘鐗� - public Short selectAll(String glassid) { - - int cage1; + public Short selectAll(north_glass_buffer1 glasslist) { + try { + + + int cage1 = 0; int cells; int ids; int prcid; @@ -32,24 +39,41 @@ int prctier; double width; double minwidth = 0; - - Glass glasslist = spianMapper.selectGlass(glassid); // 鑾峰彇鐜荤拑鍙傛暟 + double widths; + // north_glass_buffer1 glasslist = spianMapper.selectGlass(glassid); // 鑾峰彇鐜荤拑鍙傛暟 + // 濡傛灉娌℃湁姝d鏃� if (glasslist == null) { return (300); } - double widths = glasslist.getwidth(); - String orderids = glasslist.getOrderId(); + if(glasslist.getglasslengthmm()>glasslist.getglassheightmm()) { + widths= glasslist.getglasslengthmm(); + }else{ + widths= glasslist.getglassheightmm(); + } + // Map result=new HashMap(); + + String orderids = glasslist.getordernumber(); + String FrameBarcode = glasslist.getFrameBarcode(); + String glassid = glasslist.getbarcode(); List<String> adddresslist = new ArrayList<>(); adddresslist.add("DB105.0");// 杩涚墖杞﹁捣濮嬩綅缃� adddresslist.add("DB105.2");// 杩涚墖杞︾洰鏍囦綅缃� - adddresslist.add("DB105.4");// 杩涚墖绗肩幓鐠冩暟 - adddresslist.add("DB105.12");// 杩涚墖杞﹀惎鍔� 1涓哄惎鍔� + adddresslist.add("DB105.4");// 杩涚墖鐜荤拑瀹� + adddresslist.add("DB105.8");// 杩涚墖绗煎唴宸叉湁鐜荤拑鏁� + adddresslist.add("DB105.16");// 杩涚墖杞﹀惎鍔� 1涓哄惎鍔� + List<Short> datas = new ArrayList<>(); // String orderid="A001"; - // 鑾峰彇璁㈠崟鐩稿叧搴︽渶楂樼殑绗煎瓙鎺掑簭 - List<StorageCage> storageCage = spianMapper.selectAll(orderids.toString()); + // 鑾峰彇閾濇鐩稿叧搴︽渶楂樼殑绗煎瓙鎺掑簭 + List<StorageCage> storageCage = spianMapper.selectAllFbarcode(FrameBarcode, widths, 400); + // 鍒ゆ柇閾濇鎸囧畾绌烘牸鏄惁闇�瑕侀棿闅旂┖闂� + + if (storageCage.size() == 0) { + storageCage = spianMapper.selectAll(orderids, FrameBarcode); + } + if (storageCage == null) { return (400); } @@ -57,331 +81,107 @@ // 淇濆瓨璁㈠崟浼樺厛椤哄簭绗煎瓙鍙� cage1 = storageCage2.getCage(); // 鍒ゆ柇璇ョ瀛愬彿鐩搁偦鏈�澶х殑绌烘牸鏁� - int cages = spianMapper.selectCage(cage1); + StorageCage cages = spianMapper.selectCage(cage1); + + // 濡傛灉鐩搁偦绗煎瓙娌℃湁绌烘牸,鎴栬�呮湁姝e湪鎵ц鐨勫嚭鐗囦换鍔℃椂杩斿洖400 + if (cages == null) { + return (400); + } StorageCage cages1; // 鍒ゆ柇鏄惁鏄浜岀墖闇�瑕佸姞闂撮殧鐗� prctier = spianMapper.selectsum(cage1, storageCage2.getCell());// 浼犵粰prc鐨勬牸瀛愬唴鐜荤拑鏁� if (prctier > 0) { - cages1 = spianMapper.selectCage1(cage1, storageCage2.getCell(), widths + 400); + cages1 = spianMapper.selectCage1(cage1, storageCage2.getCell(), widths + 600); } else { cages1 = spianMapper.selectCage1(cage1, storageCage2.getCell(), widths); } // 鍒ゆ柇閫変腑绗煎瓙鏄惁鏈夊悎閫傚搴︾┖鏍� // 鏈夊悎閫傜┖鏍兼椂杩涚墖 - if (cages1 != null && cages >= 1) { + if (cages1 != null && cages.getCell() >= 1 && storageCage2.getDisabled() == 0) { ids = cages1.getId();// 鏁版嵁搴揑D tiers = cages1.getTier();// 鍐呭鐗� cells = cages1.getCell();// 鏍煎瓙鍙� prcid = cages1.getPrcId();// 浼犵粰prc鐨勭洰鏍囧湴id width = cages1.getWidth();// 鏍煎瓙鍓╀綑瀹藉害 - widths = glasslist.getwidth(); + // 鎵ц杩涚墖 - datas.add((short) 1000); - datas.add((short) prcid); - datas.add((short) prctier); - datas.add((short) 1); - // 鏁版嵁搴撲慨鏀圭瀛愯〃鏂板涓�鏉$幓鐠� - spianMapper.UpdataAddCage(orderids.toString(), glassid, widths, cage1, cells, ids, 2); - spianMapper.UpdataAddCage1(widths, cage1, cells);// 鍑忓皯鏍煎瓙瀹藉害 - spianMapper.Inserttask(0, 0, 1000, ids, glassid.toString());// 鏂板浠诲姟 - S7control.getinstance().WriteWord(adddresslist, datas); + datas.add((short) 1000);// 璧峰浣嶇疆 + datas.add((short) prcid);// 鐩爣浣嶇疆 + datas.add((short) widths);// 杩涚墖鐜荤拑瀹� + datas.add((short) prctier); // 鐜荤拑鏁� + datas.add((short) 1);// 浠诲姟鍚姩 + // 鑾峰彇璇ユ牸瀛愬唴鏄惁鏈夌幓鐠� + int cellint = spianMapper.selectcell(cage1, cells); + if (cellint == 1) { + result.add("杩涚墖浠诲姟|feedstart1:" + datas+ LocalDateTime.now()); + outmesid(glassid, "DB105.20"); + S7control.getinstance().WriteWord(adddresslist, datas); + boolean qidong = listbool("DB105.16"); + int qidong2 = 0; + if (qidong == true) { + qidong2 = 1; + } else { + while (qidong) { + S7control.getinstance().WriteWord("DB105.16", (short) 1);// 鍑虹墖浠诲姟鍙戦�佸瓧鏀逛负1 + qidong = listbool("DB105.16"); + } + } + // 灏嗗鐗囩幓鐠冪殑鏁版嵁鏇存柊鍒板唴鐗� + spianMapper.UpdateDBCageAdd(ids, cage1, cells, 1); + // 灏嗘柊鍏ョ殑鐜荤拑瀛樺叆澶栫墖 + spianMapper.UpdataAddCage2(orderids, glassid, glasslist, cage1, cells, ids - 1, 2,widths); + spianMapper.UpdataAddCage1(widths, cage1, cells);// 鍑忓皯鏍煎瓙瀹藉害 + spianMapper.Inserttask(0, 0, 1000, ids, glassid.toString(), prctier, qidong2);// 鏂板浠诲姟 + result.add("杩涚墖浠诲姟|feedend1" + datas+ LocalDateTime.now()); + - // S7control.getinstance().WriteByte("DB105.16",glassid); + } else { + // 鏁版嵁搴撲慨鏀圭瀛愯〃鏂板涓�鏉$幓鐠� + result.add("杩涚墖浠诲姟|feedstart2" + datas+ LocalDateTime.now()); + outmesid(glassid, "DB105.20"); + S7control.getinstance().WriteWord(adddresslist, datas); + boolean qidong = listbool("DB105.16"); + int qidong2 = 0; + if (qidong == true) { + qidong2 = 1; + } else { + while (qidong) { + S7control.getinstance().WriteWord("DB105.16", (short) 1);// 鍑虹墖浠诲姟鍙戦�佸瓧鏀逛负1 + qidong = listbool("DB105.16"); + } + } + spianMapper.UpdataAddCage2(orderids, glassid, glasslist, cage1, cells, ids, 2,widths); + spianMapper.UpdataAddCage1(widths, cage1, cells);// 鍑忓皯鏍煎瓙瀹藉害 + spianMapper.Inserttask(0, 0, 1000, ids, glassid.toString(), prctier, qidong2);// 鏂板浠诲姟 + result.add("杩涚墖浠诲姟|feedend2" + datas+ LocalDateTime.now()); + + } + return (200); } } return (400); + } catch (Exception e) { + e.printStackTrace(); + return (500); + // TODO: handle exception + } } - public Short selectAll2() { // 澶氱墖涓婄墖 - int cage1; - int cells; - int ids; - int prcid; - int tiers; - int prctier; - double width; - double minwidth = 0; - List<String> adddresslist = new ArrayList<>(); - adddresslist.add("DB105.0");// 杩涚墖杞﹁捣濮嬩綅缃� - adddresslist.add("DB105.2");// 杩涚墖杞︾洰鏍囦綅缃� - adddresslist.add("DB105.4");// 杩涚墖绗肩幓鐠冩暟 - adddresslist.add("DB105.12");// 杩涚墖杞﹀惎鍔� 1涓哄惎鍔� - List<Short> datas = new ArrayList<>(); - - // 鑾峰彇澶氱墖搴忓垪鐜荤拑瀹藉害 - StorageCage queGlass = spianMapper.SelectQueueWidth(); - double widths = queGlass.getWidth(); - String orderids = queGlass.getOrderId(); - int num = spianMapper.SelectQueOrder(); - - if (num == 1) { - - // 鑾峰彇璁㈠崟鐩稿叧搴︽渶楂樼殑绗煎瓙鎺掑簭 - List<StorageCage> storageCage = spianMapper.selectAll(orderids); - if (storageCage == null) { - return (400); - } - for (StorageCage storageCage2 : storageCage) { - // 淇濆瓨璁㈠崟浼樺厛椤哄簭绗煎瓙鍙� - cage1 = storageCage2.getCage(); - // 鍒ゆ柇璇ョ瀛愬彿鐩搁偦鏈�澶х殑绌烘牸鏁� - int cages = spianMapper.selectCage(cage1); - StorageCage cages1; - // 鍒ゆ柇鏄惁鏈夊悎閫傚畬鏁寸┖鏍� - cages1 = spianMapper.selectqueCage1(cage1, storageCage2.getCell(), widths); - // 鍒ゆ柇閫変腑绗煎瓙鏄惁鏈夊悎閫傚搴︾┖鏍� - // 鏈夊悎閫傜┖鏍兼椂杩涚墖 - if (cages1 != null && cages >= 1) { - ids = cages1.getId();// 鏁版嵁搴揑D - cells = cages1.getCell();// 鏍煎瓙鍙� - prcid = cages1.getPrcId();// 浼犵粰prc鐨勭洰鏍囧湴id - // 鏁版嵁搴撲慨鏀圭瀛愯〃鏂板涓�鏉$幓鐠� - for (int i = 2; i > 0; i--) { - Glass qglass = spianMapper.SelectQueueGlass(i); - width = qglass.getwidth();// 鏍煎瓙鍓╀綑瀹藉害 - spianMapper.UpdataAddqueCage(qglass.getOrderId(), qglass.getGlassId(), width, cage1, cells, i, - 1); - spianMapper.UpdataAddCage1(width, cage1, cells);// 鍑忓皯鏍煎瓙瀹藉害 - spianMapper.Inserttask(0, 0, 1000, ids, qglass.getGlassId().toString());// 鏂板浠诲姟 - } - // 鎵ц杩涚墖 - datas.add((short) 1000); - datas.add((short) prcid); - datas.add((short) 0); - datas.add((short) 1); - S7control.getinstance().WriteWord(adddresslist, datas); - - return (200); - - } - } - - } else { - for (int i = 2; i > 0; i--) { - Glass qglass = spianMapper.SelectQueueGlass(i); - String orderid = qglass.getOrderId().toString(); - String glassid = qglass.getGlassId(); - widths = qglass.getwidth(); - List<StorageCage> storageCage = spianMapper.selectAll(orderid); - if (storageCage == null) { - return (400); - } - for (StorageCage storageCage2 : storageCage) { - // 淇濆瓨璁㈠崟浼樺厛椤哄簭绗煎瓙鍙� - cage1 = storageCage2.getCage(); - // 鍒ゆ柇璇ョ瀛愬彿鐩搁偦鏈�澶х殑绌烘牸鏁� - int cages = spianMapper.selectCage(cage1); - StorageCage cages1; - // 鍒ゆ柇鏄惁鏄浜岀墖闇�瑕佸姞闂撮殧鐗� - prctier = spianMapper.selectsum(cage1, storageCage2.getCell());// 浼犵粰prc鐨勬牸瀛愬唴鐜荤拑鏁� - if (prctier > 0) { - cages1 = spianMapper.selectCage1(cage1, storageCage2.getCell(), widths + 400); - } else { - cages1 = spianMapper.selectCage1(cage1, storageCage2.getCell(), widths); - } - // 鍒ゆ柇閫変腑绗煎瓙鏄惁鏈夊悎閫傚搴︾┖鏍� - // 鏈夊悎閫傜┖鏍兼椂杩涚墖 - if (cages1 != null && cages >= 1) { - ids = cages1.getId();// 鏁版嵁搴揑D - tiers = cages1.getTier();// 鍐呭鐗� - cells = cages1.getCell();// 鏍煎瓙鍙� - prcid = cages1.getPrcId();// 浼犵粰prc鐨勭洰鏍囧湴id - width = cages1.getWidth();// 鏍煎瓙鍓╀綑瀹藉害 - widths = qglass.getwidth(); - - // 鎵ц杩涚墖 - datas.add((short) 1000); - datas.add((short) prcid); - datas.add((short) prctier); - datas.add((short) 1); - // 鏁版嵁搴撲慨鏀圭瀛愯〃鏂板涓�鏉$幓鐠� - spianMapper.UpdataAddCage(orderid, glassid, widths, cage1, cells, ids, 2); - spianMapper.UpdataAddCage1(widths, cage1, cells);// 鍑忓皯鏍煎瓙瀹藉害 - spianMapper.Inserttask(0, 0, 1000, ids, glassid.toString());// 鏂板浠诲姟 - // S7control.getinstance().WriteWord(adddresslist, datas); - break; - // S7control.getinstance().WriteByte("DB105.16",glassid); - - } - - } - - } - - } - return (400); - - } - - // 鎸夎鍗曞嚭鐗� - public Result selectout(String orderid) { - - // spianMapper.UpdatetaskOut(); //瀹屾垚涓婁竴娆″嚭鐗囨垨鑰呰皟搴︿换鍔★紝鏀瑰埌plchold閲岋紝鍑虹墖鎴栬皟搴︿换鍔″畬鎴愮珛鍗虫敼鍙樼粨鏉熶换鍔★紱 - // 瀹氫箟PRC鏁版嵁浼犻�佹暟缁� - List<String> adddresslist = new ArrayList<>(); - adddresslist.add("DB105.6");// 鍑虹墖杞﹁捣濮嬩綅缃� - adddresslist.add("DB105.8");// 鍑虹墖杞︾洰鏍囦綅缃� - adddresslist.add("DB105.10");// 鍑虹墖绗肩幓鐠冩暟 - adddresslist.add("DB105.14");// 鍑虹墖杞﹀惎鍔� 1涓哄惎鍔� - List<Short> datas = new ArrayList<>(); - // 鑾峰彇浼樺厛鍑虹墖鐨勪綅缃� - StorageCage cageout = spianMapper.selectOut(orderid); - if (cageout == null) { - return Result.success("200"); - } - // 鍒ゆ柇鏄惁鍚屼竴鏍煎唴閮戒负鍚屼竴璁㈠崟 - - int orders = Integer.valueOf(cageout.getOrderId()).intValue(); - - int cage = cageout.getCage(); // 鍌ㄥ瓨鍑虹墖浣嶇疆锛岀瀛愭牸瀛愬嚑鍙风幓鐠� - int cell = cageout.getCell();// 鍑虹墖鏍煎彿 - int tier = cageout.getTier();// 鍑虹墖鍐呭鐗� - int prcid = cageout.getPrcId();// prcid - String glassid = cageout.getGlassId(); - int prcid2; - int ids; - int cages; - int cells; - double glasswidth = cageout.getGlassWidth(); - // 褰撲竴鏍煎唴閮戒负鍚屼竴璁㈠崟鏃� - - if (orders == 2) { - datas.add((short) prcid); - datas.add((short) 1000); - datas.add((short) 2); - datas.add((short) 1); - spianMapper.UpdatequeOut(cage, cell); - return Result.success("200"); - } else { - // 鍒ゆ柇鏄惁闄ゆ鏍煎瓙鍐呰繕鏈夊叾浠栨牸瀛愭湁鍗曠嫭鐨勮鍗曠幓鐠� - StorageCage pd = spianMapper.SelectQueout(orderid,cage, cell); - // 鍒ゆ柇鐜荤拑鍐呭鐗� - if (tier == 2) { - - // 鍒ゆ柇鐜荤拑鍙洿鎺ュ嚭鐗囨椂 - // 淇敼鏁版嵁搴撶瀛愯〃(鍑虹墖) - datas.add((short) prcid); - datas.add((short) 1000); - datas.add((short) 1); - datas.add((short) 1); - - spianMapper.UpdataOutCage1(glasswidth, cage, cell);// 澧炲姞鍘熸牸瀛愬搴� - spianMapper.UpdataGlassCage("", "", glasswidth, cage, cell, tier, 3);// 娓呴櫎鏍煎瓙鐜荤拑淇℃伅 - spianMapper.Inserttask(1, 0, cageout.getId(), 1000, orderid);// 鏂板浠诲姟 - S7control.getinstance().WriteWord(adddresslist, datas);// 娲惧彂鍑虹墖杞︿换鍔� - outmesid(glassid);// 娲惧彂鍑虹墖ID - if (pd != null) { - cage = pd.getCage(); - cell = pd.getCage(); - // 娓呴櫎鏈牸鏁版嵁鍑虹墖 - spianMapper.UpdatequeOut(cage, cell); - return Result.success("200"); - } - return Result.success(datas);// 缁撴潫 - } else { - // 鑾峰彇鏍煎瓙鐨勭幓鐠冩暟閲� - int state = spianMapper.selectGlassState(cage, cell); - // 鍒ゆ柇鍐呯墖鏄惁闇�瑕佽皟鎷� - if (state == 1) { - // spianMapper.UpdataGlassCage("", "", glasswidth, cage, cell, tier, 0); - datas.add((short) prcid); - datas.add((short) 1000); - datas.add((short) 1); - datas.add((short) 1); - spianMapper.Inserttask(1, 0,prcid, 1000, orderid);// 鏂板浠诲姟 - spianMapper.UpdataOutCage1(glasswidth, cage, cell);// 澧炲姞鍘熸牸瀛愬搴� - spianMapper.UpdataGlassCage("", "", glasswidth, cage, cell, tier, 0);// 娓呴櫎鏍煎瓙鐜荤拑淇℃伅 - //S7control.getinstance().WriteWord(adddresslist, datas);// 娲惧彂鍑虹墖杞︿换鍔� - //outmesid(glassid);// 娲惧彂鍑虹墖ID - if (pd != null) { - cage = pd.getCage(); - cell = pd.getCage(); - // 娓呴櫎鏈牸鏁版嵁鍑虹墖 - spianMapper.UpdatequeOut(cage, cell); - return Result.success("200"); - } - return Result.success(datas);// 缁撴潫 - - } else { - // 鐜荤拑闇�瑕佽皟鎷ㄦ椂锛屽垽鏂睘浜庡摢涓崐鍖虹殑绗煎瓙 - if (cage < 6) { - StorageCage cagecell = spianMapper.selectGlassCage(cage, glasswidth, 0, 6); - if (cagecell == null) { - return Result.success(cagecell); - } - // 鑾峰彇璋冩嫧浣嶇疆杩涜璋冩嫧 - prcid2 = cagecell.getPrcId();// 璋冩嫧鐩爣浣峆RCID - ids = cagecell.getId();// 璋冩嫧鐩爣浣岻D - cages = cagecell.getCage();// 璋冩嫧鐩爣浣嶇瀛� - cells = cagecell.getCell();// 璋冩嫧鐩爣浣嶆牸瀛� - - // 濉叆璋冩嫧鏁版嵁 - datas.add((short) prcid);// 璋冩嫧澶栫墖璧峰浣嶇疆 - datas.add((short) prcid2); - datas.add((short) 2); - datas.add((short) 1); - // 鏇存崲鐜荤拑鐨勭瀛� - String glassids = spianMapper.SelectGlassid(cage, cell); // 鑾峰彇琚皟鎷ㄧ殑鐜荤拑id - spianMapper.UpdateDBCage(ids, cage, cell);// 灏嗗師鏍煎瓙鏁版嵁鏇存柊鍒版柊鏍煎瓙閲� - spianMapper.UpdataAddCage1(glasswidth, cages, cells);// 鍑忓皯鏂版牸瀛愬搴� - spianMapper.UpdataOutCage1(glasswidth, cage, cell);// 澧炲姞鍘熸牸瀛愬搴� - spianMapper.UpdataGlassCage("", "", glasswidth, cage, cell, 2, 3);// 娓呴櫎琚皟鎷ㄦ牸瀛愭暟鎹� - spianMapper.Inserttask(2, 0, cageout.getId(), ids, orderid);// 鏂板璋冨害浠诲姟 - // 浼犺緭mes鏁版嵁,鍧愭爣锛屾暟鎹� - S7control.getinstance().WriteWord(adddresslist, datas);// 娲惧彂鍑虹墖杞︿换鍔� - System.out.println(datas); - outmesid(glassids);// 娲惧彂璋冩嫧鐜荤拑ID - return Result.success(cagecell); // 缁撴潫 - - } else {// 绗煎瓙鍙峰ぇ浜�5鏃� - StorageCage cagecell = spianMapper.selectGlassCage(cage, glasswidth, 5, 11); - if (cagecell == null) { - return Result.success(cagecell); - } - // 鑾峰彇璋冩嫧浣嶇疆杩涜璋冩嫧 - prcid2 = cagecell.getPrcId();// 璋冩嫧鐩爣浣峱rcID - ids = cagecell.getId();// 璋冩嫧鐩爣浣岻D - cages = cagecell.getCage();// 璋冩嫧鐩爣浣嶇瀛� - cells = cagecell.getCell();// 璋冩嫧鐩爣浣嶆牸瀛� - // 濉叆璋冩嫧鏁版嵁 - datas.add((short) prcid); - datas.add((short) prcid2); - datas.add((short) 2); - datas.add((short) 1); - String glassids = spianMapper.SelectGlassid(cage, cell); // 鑾峰彇琚皟鎷ㄧ殑鐜荤拑id - spianMapper.UpdateDBCage(ids, cage, cell);// 灏嗗師鏍煎瓙鏁版嵁鏇存柊鍒版柊鏍煎瓙閲� - spianMapper.Inserttask(2, 0, cageout.getId(), ids, orderid);// 鏂板璋冨害浠诲姟 - spianMapper.UpdataAddCage1(glasswidth, cages, cells);// 鍑忓皯鏂版牸瀛愬搴� - spianMapper.UpdataOutCage1(glasswidth, cage, cell);// 澧炲姞鍘熸牸瀛愬搴� - spianMapper.UpdataGlassCage("", "", glasswidth, cage, cell, 2, 3);// 娓呴櫎琚皟鎷ㄦ牸瀛愭暟鎹� - // 浼犺緭mes鏁版嵁,鍧愭爣锛屾暟鎹� - S7control.getinstance().WriteWord(adddresslist, datas);// 娲惧彂鍑虹墖杞︿换鍔� - - outmesid(glassids);// 娲惧彂璋冩嫧鐜荤拑ID - return Result.success(cagecell); // 缁撴潫 - - } - } - - } - } - - } - - // @GetMapping("/all2") public Short selectout2(String glassid) { - // spianMapper.UpdatetaskOut(); //瀹屾垚涓婁竴娆″嚭鐗囨垨鑰呰皟搴︿换鍔�,鏀瑰埌plchold閲岋紝鍑虹墖鎴栬皟搴︿换鍔″畬鎴愮珛鍗虫敼鍙樼粨鏉熶换鍔★紱 + try { // 瀹氫箟PRC鏁版嵁浼犻�佹暟缁� List<String> adddresslist = new ArrayList<>(); - adddresslist.add("DB105.6");// 鍑虹墖杞﹁捣濮嬩綅缃� - adddresslist.add("DB105.8");// 鍑虹墖杞︾洰鏍囦綅缃� - adddresslist.add("DB105.10");// 鍑虹墖绗肩幓鐠冩暟 - adddresslist.add("DB105.14");// 鍑虹墖杞﹀惎鍔� 1涓哄惎鍔� + char[] a = glassid.toCharArray(); + + adddresslist.add("DB105.10");// 鍑虹墖杞﹁捣濮嬩綅缃� + adddresslist.add("DB105.12");// 鍑虹墖杞︾洰鏍囦綅缃� + adddresslist.add("DB105.14");// 鍑虹墖绗肩幓鐠冩暟 + adddresslist.add("DB105.18");// 鍑虹墖杞﹀惎鍔� 1涓哄惎鍔� List<Short> datas = new ArrayList<>(); // 鑾峰彇浼樺厛鍑虹墖鐨勪綅缃� StorageCage cageout = spianMapper.selectOut2(glassid); @@ -398,6 +198,7 @@ int cages; int cells; double glasswidth = cageout.getGlassWidth(); + // 鍒ゆ柇鐜荤拑鍐呭鐗� if (tier == 2) { int state = spianMapper.selectGlassState(cage, cell);// 鑾峰彇鏍煎瓙鏁伴噺 @@ -407,41 +208,62 @@ datas.add((short) 1000); datas.add((short) state); datas.add((short) 1); - + spianMapper.OverOutSlice(glassid.toString(), 1, 0);// 鏇存柊鍑虹墖闃熷垪浠诲姟鐘舵�佷负杩涜涓� spianMapper.UpdataOutCage1(glasswidth, cage, cell);// 澧炲姞鍘熸牸瀛愬搴� - spianMapper.UpdataGlassCage("", "", glasswidth, cage, cell, tier, 3);// 娓呴櫎鏍煎瓙鐜荤拑淇℃伅 - spianMapper.Inserttask(1, 0, cageout.getId(), 1000, glassid);// 鏂板浠诲姟 - // int state = spianMapper.selectGlassState(cage, cell);//鑾峰彇鏍煎瓙鏁伴噺 - if (state == 2) { - spianMapper.UpdateDBCage1(cage, cell);// 灏嗗唴鐗囨暟鎹洿鏂板埌澶栫墖閲� - spianMapper.UpdateDBCage2(cage, cell);// 娓呴櫎鍐呯墖鏁版嵁 - } - S7control.getinstance().WriteWord(adddresslist, datas);// 娲惧彂鍑虹墖杞︿换鍔� - //outmesid(glassid);// 娲惧彂鍑虹墖ID + spianMapper.UpdataGlassCageState(glassid.toString(), 3);// 鏇存敼绗煎瓙琛ㄧ殑鐜荤拑鐘舵�� + result.add("鍑虹墖浠诲姟|outstart1" + datas+ LocalDateTime.now()); + S7control.getinstance().WriteWord(adddresslist, datas);// 娲惧彂鍑虹墖杞︿换鍔� + //S7control.getinstance().WriteWord("DB105.18", (short) 1);// 鍑虹墖浠诲姟鍙戦�佸瓧鏀逛负1 + boolean qidong = listbool("DB105.18"); + int qidong2 = 0; + if (qidong == true) { + qidong2 = 1; + } else { + while (qidong) { + S7control.getinstance().WriteWord("DB105.18", (short) 1);// 鍑虹墖浠诲姟鍙戦�佸瓧鏀逛负1 + qidong = listbool("DB105.18"); + } + } + spianMapper.Inserttask(1, 0, cageout.getId(), 1000, glassid, state, qidong2);// 鏂板浠诲姟 + outmesid(glassid, "DB105.34");// 娲惧彂鍑虹墖ID + result.add("鍑虹墖浠诲姟|outend1" + datas+ LocalDateTime.now()); return (200);// 缁撴潫 } else { // 鑾峰彇鏍煎瓙鐨勭幓鐠冩暟閲� int state = spianMapper.selectGlassState(cage, cell); // 鍒ゆ柇鍐呯墖鏄惁闇�瑕佽皟鎷� - if (state == 0) { + if (state == 1) { // spianMapper.UpdataGlassCage("", "", glasswidth, cage, cell, tier, 3); datas.add((short) prcid); datas.add((short) 1000); datas.add((short) 1); datas.add((short) 1); - spianMapper.Inserttask(1, 0, cageout.getId(), 1000, glassid);// 鏂板浠诲姟 - spianMapper.UpdataOutCage1(glasswidth, cage, cell);// 澧炲姞鍘熸牸瀛愬搴� - spianMapper.UpdataGlassCage("", "", glasswidth, cage, cell, tier, 3);// 娓呴櫎鏍煎瓙鐜荤拑淇℃伅 - //outmesid(glassid);// 娲惧彂鍑虹墖ID + result.add("鍑虹墖浠诲姟|outstart2" + datas+ LocalDateTime.now()); + outmesid(glassid, "DB105.34");// 娲惧彂鍑虹墖ID S7control.getinstance().WriteWord(adddresslist, datas);// 娲惧彂鍑虹墖杞︿换鍔� - + //S7control.getinstance().WriteWord("DB105.18", (short) 1);// 鍑虹墖浠诲姟鍙戦�佸瓧鏀逛负1 + boolean qidong = listbool("DB105.18"); + int qidong2 = 0; + if (qidong == true) { + qidong2 = 1; + } else { + while (qidong) { + S7control.getinstance().WriteWord("DB105.18", (short) 1);// 鍑虹墖浠诲姟鍙戦�佸瓧鏀逛负1 + qidong = listbool("DB105.18"); + } + } + spianMapper.OverOutSlice(glassid.toString(), 1, 0);// 鏇存柊鍑虹墖闃熷垪浠诲姟鐘舵�佷负杩涜涓� + spianMapper.UpdataOutCage1(glasswidth, cage, cell);// 澧炲姞鍘熸牸瀛愬搴� + spianMapper.UpdataGlassCageState(glassid, 3);// 鏇存敼绗煎瓙琛ㄧ殑鐜荤拑鐘舵�� + spianMapper.Inserttask(1, 0, cageout.getId(), 1000, glassid, 1, qidong2);// 鏂板浠诲姟 + result.add("鍑虹墖浠诲姟|outend2" + datas+ LocalDateTime.now()); return (200);// 缁撴潫 } else { // 鐜荤拑闇�瑕佽皟鎷ㄦ椂锛屽垽鏂睘浜庡摢涓崐鍖虹殑绗煎瓙 if (cage < 6) { - StorageCage cagecell = spianMapper.selectGlassCage(cage, glasswidth, 0, 6); + StorageCage cagecell = spianMapper.selectGlassCage(cage, glasswidth, 0, 6, cell); if (cagecell == null) { return (300); } @@ -457,21 +279,33 @@ datas.add((short) 2); datas.add((short) 1); // 鏇存崲鐜荤拑鐨勭瀛� - String glassids = spianMapper.SelectGlassid(cage, cell); // 鑾峰彇琚皟鎷ㄧ殑鐜荤拑id - spianMapper.UpdateDBCage(ids, cage, cell);// 灏嗗師鏍煎瓙鏁版嵁鏇存柊鍒版柊鏍煎瓙閲� - spianMapper.UpdataAddCage1(glasswidth, cages, cells);// 鍑忓皯鏂版牸瀛愬搴� - spianMapper.UpdataOutCage1(glasswidth, cage, cell);// 澧炲姞鍘熸牸瀛愬搴� - spianMapper.UpdataGlassCage("", "", glasswidth, cage, cell, 2, 3);// 娓呴櫎琚皟鎷ㄦ牸瀛愭暟鎹� - spianMapper.Inserttask(2, 0, cageout.getId(), ids, glassid);// 鏂板璋冨害浠诲姟 - spianMapper.Inserttask(1, 0, cageout.getId(), 1000, glassid);// 鏂板鍑虹墖浠诲姟 - // 浼犺緭mes鏁版嵁,鍧愭爣锛屾暟鎹� - S7control.getinstance().WriteWord(adddresslist, datas);// 娲惧彂鍑虹墖杞︿换鍔� + StorageCage glassids = spianMapper.SelectGlassid(cage, cell); // 鑾峰彇琚皟鎷ㄧ殑鐜荤拑id - outmesid(glassids);// 娲惧彂璋冩嫧鐜荤拑ID + // 浼犺緭mes鏁版嵁,鍧愭爣锛屾暟鎹� + result.add("鍑虹墖浠诲姟|outstart3" + datas+ LocalDateTime.now()); + outmesid(glassids.getGlassId(), "DB105.34");// 娲惧彂璋冩嫧鐜荤拑ID + S7control.getinstance().WriteWord(adddresslist, datas);// 娲惧彂鍑虹墖杞︿换鍔� + //S7control.getinstance().WriteWord("DB105.18", (short) 1);// 鍑虹墖浠诲姟鍙戦�佸瓧鏀逛负1 + boolean qidong = listbool("DB105.18"); + int qidong2 = 0; + if (qidong == true) { + qidong2 = 1; + } else { + while (qidong) { + S7control.getinstance().WriteWord("DB105.18", (short) 1);// 鍑虹墖浠诲姟鍙戦�佸瓧鏀逛负1 + qidong = listbool("DB105.18"); + } + } + spianMapper.UpdataGlassCageState(glassids.getGlassId(), 3);// 鏇存敼绗煎瓙琛ㄧ殑鐜荤拑鐘舵�� + spianMapper.UpdateDBCage(ids, cage, cell, 2);// 灏嗗師鏍煎瓙鏁版嵁鏇存柊鍒版柊鏍煎瓙閲� + spianMapper.UpdataAddCage1(glassids.getGlassWidth(), cages, cells);// 鍑忓皯鏂版牸瀛愬搴� + spianMapper.UpdataOutCage1(glassids.getGlassWidth(), cage, cell);// 澧炲姞鍘熸牸瀛愬搴� + spianMapper.Inserttask(2, 0, cageout.getId(), ids, glassids.getGlassId(), 2, qidong2);// 鏂板璋冨害浠诲姟 + result.add("鍑虹墖浠诲姟|outend3" + datas+ LocalDateTime.now()); return (200); // 缁撴潫 } else {// 绗煎瓙鍙峰ぇ浜�5鏃� - StorageCage cagecell = spianMapper.selectGlassCage(cage, glasswidth, 5, 11); + StorageCage cagecell = spianMapper.selectGlassCage(cage, glasswidth, 5, 11, cell); if (cagecell == null) { return (300); } @@ -485,52 +319,189 @@ datas.add((short) prcid2); datas.add((short) 2); datas.add((short) 1); - String glassids = spianMapper.SelectGlassid(cage, cell); // 鑾峰彇琚皟鎷ㄧ殑鐜荤拑id - spianMapper.Inserttask(2, 0, cageout.getId() + 1, ids, glassid);// 鏂板璋冨害浠诲姟 - spianMapper.Inserttask(1, 0, cageout.getId(), 1000, glassid);// 鏂板鍑虹墖浠诲姟 - spianMapper.UpdateDBCage(ids, cage, cell);// 灏嗗師鏍煎瓙鏁版嵁鏇存柊鍒版柊鏍煎瓙閲� - spianMapper.UpdataAddCage1(glasswidth, cages, cells);// 鍑忓皯鏂版牸瀛愬搴� - spianMapper.UpdataOutCage1(glasswidth, cage, cell);// 澧炲姞鍘熸牸瀛愬搴� - spianMapper.UpdataGlassCage("", "", glasswidth, cage, cell, 2, 3);// 娓呴櫎琚皟鎷ㄦ牸瀛愭暟鎹� + StorageCage glassids = spianMapper.SelectGlassid(cage, cell); // 鑾峰彇琚皟鎷ㄧ殑鐜荤拑id // 浼犺緭mes鏁版嵁,鍧愭爣锛屾暟鎹� + result.add("鍑虹墖浠诲姟|outstart4" + datas+ LocalDateTime.now()); + outmesid(glassids.getGlassId(), "DB105.34");// 娲惧彂璋冩嫧鐜荤拑ID S7control.getinstance().WriteWord(adddresslist, datas);// 娲惧彂鍑虹墖杞︿换鍔� - - outmesid(glassids);// 娲惧彂璋冩嫧鐜荤拑ID + //S7control.getinstance().WriteWord("DB105.18", (short) 1);// 鍑虹墖浠诲姟鍙戦�佸瓧鏀逛负1 + boolean qidong = listbool("DB105.18"); + int qidong2 = 2; + if (qidong == true) { + qidong2 = 1; + } else { + while (qidong) { + S7control.getinstance().WriteWord("DB105.18", (short) 1);// 鍑虹墖浠诲姟鍙戦�佸瓧鏀逛负1 + qidong = listbool("DB105.18"); + } + } + spianMapper.UpdataGlassCageState(glassids.getGlassId(), 3);// 鏇存敼绗煎瓙琛ㄧ殑鐜荤拑鐘舵�� + spianMapper.UpdateDBCage(ids, cage, cell, 2);// 灏嗗師鏍煎瓙鏁版嵁鏇存柊鍒版柊鏍煎瓙閲� + spianMapper.UpdataAddCage1(glassids.getGlassWidth(), cages, cells);// 鍑忓皯鏂版牸瀛愬搴� + spianMapper.UpdataOutCage1(glassids.getGlassWidth(), cage, cell);// 澧炲姞鍘熸牸瀛愬搴� + spianMapper.Inserttask(2, 0, cageout.getId() + 1, ids, glassids.getGlassId(), 2, qidong2);// 鏂板璋冨害浠诲姟 + result.add("鍑虹墖浠诲姟|outend4" + datas+ LocalDateTime.now()); return (200);// 缁撴潫 } } } - + } catch (Exception e) { + e.printStackTrace(); + return (500); + // TODO: handle exception } +} - public void outmesid(String glassid) { - System.out.println("outmesid:" + glassid); + // 娲惧彂浠诲姟鐜荤拑id + public void outmesid(String glassid, String address) { + try { + + + // System.out.println("outmesid:" + glassid); List<Byte> glassidlist = new ArrayList(); - for (char iditem : glassid.toCharArray()) { - glassidlist.add(Byte.valueOf(String.valueOf(iditem))); + char ds[] = glassid.toCharArray(); + for (char iditem : ds) { + glassidlist.add((byte) iditem); } byte[] bytes = Bytes.toArray(glassidlist); System.out.println("outmesidbytes:" + bytes.length); - S7control.getinstance().WriteByte("DB105.30", bytes);// 娲惧彂鍑虹墖id + S7control.getinstance().WriteByte(address, bytes);// 娲惧彂鍑虹墖id + } catch (Exception e) { + e.printStackTrace(); + } } - /*** 淇敼鐢ㄦ埛* @throws SQLException */ - // public static int updateUser(Glass user) throws SQLException {conn = - // getConn(); - // String sql = "update t_user set name=?,gender=?,age=?,score=?"+ " where - // id=?";ps = conn.prepareStatement(sql); - // ps.setString(1, user.getName());ps.setString(2, user.getGender()); - // ps.setInt(3, user.getAge());ps.setDouble(4, user.getScore());ps.setInt(5, - // user.getId());return ps.executeUpdate();} - // /*** 澧炲姞鐢ㄦ埛* @throws SQLException */ - // public static int insertUser(User user) throws SQLException { - // conn = getConn(); - // String sql = "insert into t_user(name,gender,age,score)"+ " values(?,?,?,?)"; - // ps = conn.prepareStatement(sql);ps.setString(1, - // user.getName());ps.setString(2, user.getGender()); - // ps.setInt(3, user.getAge());ps.setDouble(4, user.getScore());return - // ps.executeUpdate(); - // } + // 鑾峰彇鍦板潃鍐呯殑鐜荤拑id杞瓧绗︿覆 + public StringBuilder queGlassid(String address, int count) { + StringBuilder writedstrIdOut = new StringBuilder(); + byte[] writedglassidbytesOut = S7control.getinstance().ReadByte(address, count); + if (writedglassidbytesOut != null) { + // 鑾峰彇鐜荤拑id + for (byte iditem : writedglassidbytesOut) { + writedstrIdOut.append((char) iditem); + } + } + return writedstrIdOut; + } + + // char鏁扮粍杞寲鎴恇it鏁扮粍 + public static byte[] toBytes(char[] chars) { + String s = new String(chars); + return s.getBytes(StandardCharsets.UTF_8); + } + + // bit鏁扮粍杞寲鎴恈har鏁扮粍 + public static char[] toChars(byte[] bytes) { + String s = new String(bytes, StandardCharsets.UTF_8); + return s.toCharArray(); + } + + // 鍒ゆ柇闆嗗悎閲屾槸鍚︿负1 + public boolean listbool(String address) { + List<Short> list = S7control.getinstance().ReadWord(address, 1);// 杩斿洖涓簍ure鏃朵负1 + boolean listbool = list.contains((short) 1); + return listbool; + } + + // 鏍规嵁鐜荤拑id瀹屾垚鍦ㄨ繘琛屼腑鐨勪换鍔� + public void overtask(String glassid) { + + spianMapper.UpdatetaskOut(glassid.toString());// 瀹屾垚涓婁竴娆� 鍑虹墖鎴栬�呰繘鐗囦换鍔� + spianMapper.OverOutSlice(glassid.toString(), 2, 1);// 瀹屾垚鍑虹墖闃熷垪浠诲姟 + spianMapper.UpdataGlassCage(glassid.toString(), 0);// 娓呴櫎鍑虹墖鏍煎瓙鐜荤拑淇℃伅 + spianMapper.UpdateCageOver(glassid.toString(), 0);// 鏇存敼绗煎瓙琛ㄥ嚭鐗囩姸鎬� + spianMapper.UpdateCageadd(glassid.toString(), 1);// 鏇存敼绗煎瓙琛ㄨ繘鐗囩姸鎬� + String barcode = spianMapper.SelectBarcode(glassid.toString());// 鑾峰彇璇ョ幓鐠冪殑閾濇id + //spianMapper.UpdateAddQueue(glassid.toString());// 鎶婅繘鐗囩殑鐜荤拑鏇存柊鍒板嚭鐗囬槦鍒椾腑 + + + } + + + public Short selectAlls(north_glass_buffer1 glasslist) { + try { + + int cage1 = 0; + int cells; + int ids; + int prcid; + int tiers; + int prctier; + double width; + double minwidth = 0; + double widths; + // north_glass_buffer1 glasslist = spianMapper.selectGlass(glassid); // 鑾峰彇鐜荤拑鍙傛暟 + // 濡傛灉娌℃湁姝d鏃� + if (glasslist == null) { + return (300); + } + //鍒ゆ柇鏄惁瀛樺湪绗煎瓙閲� + short result = homeMapper.SelectStorageByGlassId(glasslist.getbarcode()); + if (result > 0) { + return (500); + } + + + if(glasslist.getglasslengthmm()>glasslist.getglassheightmm()) { + widths= glasslist.getglasslengthmm(); + }else{ + widths= glasslist.getglassheightmm(); + } + // Map result=new HashMap(); + + + String orderids = glasslist.getordernumber(); + String FrameBarcode = glasslist.getFrameBarcode(); + String glassid = glasslist.getbarcode(); + + + // String orderid="A001"; + // 鑾峰彇閾濇鐩稿叧搴︽渶楂樼殑绗煎瓙鎺掑簭 + List<StorageCage> storageCage = spianMapper.selectAllFbarcode(FrameBarcode, widths, 400); + // 鍒ゆ柇閾濇鎸囧畾绌烘牸鏄惁闇�瑕侀棿闅旂┖闂� + + if (storageCage.size() == 0) { + storageCage = spianMapper.selectAll(orderids, FrameBarcode); + } + + if (storageCage == null) { + return (400); + } + for (StorageCage storageCage2 : storageCage) { + // 淇濆瓨璁㈠崟浼樺厛椤哄簭绗煎瓙鍙� + cage1 = storageCage2.getCage(); + // 鍒ゆ柇璇ョ瀛愬彿鐩搁偦鏈�澶х殑绌烘牸鏁� + StorageCage cages = spianMapper.selectCage(cage1); + + // 濡傛灉鐩搁偦绗煎瓙娌℃湁绌烘牸,鎴栬�呮湁姝e湪鎵ц鐨勫嚭鐗囦换鍔℃椂杩斿洖400 + if (cages == null) { + return (400); + } + StorageCage cages1; + // 鍒ゆ柇鏄惁鏄浜岀墖闇�瑕佸姞闂撮殧鐗� + prctier = spianMapper.selectsum(cage1, storageCage2.getCell());// 浼犵粰prc鐨勬牸瀛愬唴鐜荤拑鏁� + if (prctier > 0) { + cages1 = spianMapper.selectCage1(cage1, storageCage2.getCell(), widths + 400); + } else { + cages1 = spianMapper.selectCage1(cage1, storageCage2.getCell(), widths); + } + // 鍒ゆ柇閫変腑绗煎瓙鏄惁鏈夊悎閫傚搴︾┖鏍� + // 鏈夊悎閫傜┖鏍兼椂杩涚墖 + if (cages1 != null && cages.getCell() >= 1 && storageCage2.getDisabled() == 0) { + + return (0); + + } + + } + return (400); + } catch (Exception e) { + e.printStackTrace(); + return (500); + // TODO: handle exception + } + + } } -- Gitblit v1.8.0