| | |
| | | @Query("select t from GalssTask t where t.workProcedure='ä¸ç' and t.workState=?1 and t.patternTask.groups=?2") |
| | | public List<GalssTask> findByCounttask(String state,Long groups); |
| | | |
| | | @Query("select t from GalssTask t where t.workProcedure='æµé' and t.workState='å¾
è¯å«' and t.patternTask.groups=?1 order by t.patternTask.id,t.engineeringId") |
| | | public List<GalssTask> findByidentify1(Long groups); |
| | | @Query("select t from GalssTask t where t.workProcedure='æµé' and t.workState='å¾
è¯å«' and t.width>?2 and t.height>?2 and t.patternTask.groups=?1 order by t.patternTask.id,t.engineeringId") |
| | | public List<GalssTask> findByidentify1(Long groups,double minwidths); |
| | | |
| | | @Query("select t from GalssTask t where t.workProcedure='æµé' and t.workState='å¾
è¯å«' and t.patternTask.groups=?1 and (((t.width<=?3 and t.width>=?2) and (t.height<=?5 and t.height>=?4)) or ((t.width<=?5 and t.width>=?4) and (t.height<=?3 and t.height>=?2))) order by t.patternTask.id,t.engineeringId") |
| | | public List<GalssTask> findByidentify2(Long groups,Double minwidth,Double maxwidth,Double minheigth,Double maxheigth); |
| | |
| | | @Query("select t from GalssTask t where t.patternTask.id=?1") |
| | | public List<GalssTask> findpattern(Long id); |
| | | |
| | | @Query("select t from GalssTask t where t.patternTask.id=?1 and t.workState='å¾
è¯å«' and t.workProcedure='æµé'") |
| | | public List<GalssTask> findpattern1(Long id); |
| | | @Query("select t from GalssTask t where t.patternTask.id=?1 and t.width>?2 and t.height>?2 and t.workState='å¾
è¯å«' and t.workProcedure='æµé'") |
| | | public List<GalssTask> findpattern1(Long id,double minwidths); |
| | | |
| | | @Query("select t from GalssTask t where t.patternTask.groups=?1 and t.width>?2 and t.height>?2 and t.patternTask.flag=1 and t.workState='å¾
è¯å«' and t.workProcedure='æµé'") |
| | | public List<GalssTask> findpattern2(Long id,double minwidths); |
| | | |
| | | @Query("select t from GalssTask t where t.typeId=?1 ") |
| | | public List<GalssTask> findbyTypeId1(Long id); |
| | |
| | | //ç»æä»»å¡ |
| | | public String delecttask(Long id,Long line) { |
| | | RawFile rawFile=rawFileDao.findAcceptedByGroup2(id); |
| | | System.out.println(1111); |
| | | int lipiancount =galssTaskDao.finlipian2(rawFile.getFileName()); |
| | | System.out.println(2222); |
| | | int slicecount; |
| | | if (line==1) { |
| | | slicecount=horizontalDao.findfall3(rawFile.getFileName()); |
| | |
| | | System.out.println(slicecount); |
| | | System.out.println(rawFile.getFileName()); |
| | | if(lipiancount>0||slicecount>0){ |
| | | return "redirect:cutmanage/gettasks"; |
| | | return "ççåå¨å½å订åç»ç:ä»»å¡åå¨"+lipiancount+","+slicecount; |
| | | }else{ |
| | | Connection conn=DeviceService.getConnection(); |
| | | try{ |
| | |
| | | } |
| | | } |
| | | |
| | | return "redirect:cutmanage/gettasks"; |
| | | return "ç»ææå"; |
| | | } catch (SQLException e) { |
| | | e.printStackTrace(); |
| | | return "redirect:cutmanage/gettasks"; |
| | | return "æå¡å¨è¿æ¥é误"; |
| | | }finally{ |
| | | messageProcessor.close(conn); |
| | | } |
| | |
| | | slicecount=slicecageDao.findfall3(rawFile.getFileName()); |
| | | } |
| | | if(lipiancount>0||slicecount>0){ |
| | | return "redirect:cutmanage/gettasks"; |
| | | return "ççåå¨å½å订åç»ç:ä»»å¡åå¨"+lipiancount+","+slicecount; |
| | | }else{ |
| | | Connection conn=DeviceService.getConnection(); |
| | | try { |
| | |
| | | } |
| | | |
| | | } |
| | | return "redirect:cutmanage/gettasks"; |
| | | return "䏿æå"; |
| | | } catch (SQLException e) { |
| | | e.printStackTrace(); |
| | | return "redirect:cutmanage/gettasks"; |
| | | return "æå¡å¨è¿æ¥é误"; |
| | | }finally{ |
| | | messageProcessor.close(conn); |
| | | } |
| | |
| | | } |
| | | |
| | | public static Connection getConnection() { |
| | | //localhost 192.168.200.201 192.168.2.6 10.12.0.100 |
| | | //localhost:3307 192.168.200.201 192.168.2.6 10.12.0.100:3306 |
| | | try { |
| | | return DriverManager.getConnection("jdbc:mariadb://localhost:3307/gmms","root",""); |
| | | } catch (SQLException e) { |
| | |
| | | return glass; |
| | | }else{ |
| | | List<GalssTask> glass=new ArrayList<GalssTask>(); |
| | | glass=galssTaskDao.findByidentify1(groups); |
| | | glass=galssTaskDao.findByidentify1(groups,preprocessingGlass.getMinwidths()); |
| | | return glass; |
| | | } |
| | | |
| | |
| | | PreprocessingGlass preprocessingGlass=preprocessingGlassDao.findBygroup(Integer.parseInt(String.valueOf(groups))); |
| | | List<GalssTask> glass; |
| | | if(patternTask!=null){ |
| | | /*glass=galssTaskDao.findpattern1(patternTask.getId());*/ |
| | | glass=galssTaskDao.findByidentify1(groups); |
| | | glass=galssTaskDao.findpattern2(groups,preprocessingGlass.getMinwidths()); |
| | | /*glass=galssTaskDao.findByidentify1(groups);*/ |
| | | glass.addAll(galssTaskDao.findpattern1(patternTask.getId(),preprocessingGlass.getMinwidths())); |
| | | }else if(preprocessingGlass.getStatu().equals("夿°æ®å¹é
")){ |
| | | IdentifyError identifyError=identifyErrorDao.findBygroup(Integer.parseInt(String.valueOf(groups))); |
| | | double minwidth=preprocessingGlass.getActualWidth()-identifyError.getHeigtherror(); |
| | |
| | | glass=galssTaskDao.findByidentify2(groups,minwidth,maxwidth,minheigth,maxheigth); |
| | | return glass; |
| | | }else{ |
| | | glass=galssTaskDao.findByidentify1(groups); |
| | | glass=galssTaskDao.findByidentify1(groups,preprocessingGlass.getMinwidths()); |
| | | } |
| | | |
| | | return glass; |
| | |
| | | html.append("<td></td>"); |
| | | html.append("<td></td>"); |
| | | html.append("<td></td>"); |
| | | html.append("<td>"+slicecages.getFlag() +"</td>"); |
| | | html.append("<td></td>"); |
| | | html.append("<td style='width:200px'>"+slicecages.getFlag() +"</td>"); |
| | | html.append("</tr>"); |
| | | } |
| | | else{ |
| | |
| | | html.append("<td>"+galssTask.getThickness()+"</td>"); |
| | | html.append("<td>"+slicecages.getCount()+"</td>"); |
| | | html.append("<td>"+slicecages.getProcesscardId()+"</td>"); |
| | | html.append("<td>"+slicecages.getFlag() +"</td>"); |
| | | html.append("<td>"+galssTask.getEngineeringId()+"</td>"); |
| | | html.append("<td style='width:200px'>"+slicecages.getFlag() +"</td>"); |
| | | html.append("</tr>"); |
| | | } |
| | | } |
| | |
| | | html.append("<td></td>"); |
| | | html.append("<td></td>"); |
| | | html.append("<td></td>"); |
| | | html.append("<td>"+slicecages.getFlag() +"</td>"); |
| | | html.append("<td></td>"); |
| | | html.append("<td style='width:200px'>"+slicecages.getFlag() +"</td>"); |
| | | html.append("</tr>"); |
| | | } |
| | | else{ |
| | |
| | | html.append("<td>"+galssTask.getThickness()+"</td>"); |
| | | html.append("<td>"+slicecages.getCount()+"</td>"); |
| | | html.append("<td>"+slicecages.getProcesscardId()+"</td>"); |
| | | html.append("<td>"+slicecages.getFlag() +"</td>"); |
| | | html.append("<td>"+galssTask.getEngineeringId()+"</td>"); |
| | | html.append("<td style='width:200px'>"+slicecages.getFlag() +"</td>"); |
| | | html.append("</tr>"); |
| | | } |
| | | } |
| | |
| | | |
| | | //ç»æä»»å¡ |
| | | @RequestMapping(method=RequestMethod.GET,value="/delecttask/{id}/{line}") |
| | | @ResponseBody |
| | | public String delecttask(Model model,@PathVariable("id") Long id,@PathVariable("line") Long line){ |
| | | return cutManageService.delecttask(id,line); |
| | | } |
| | |
| | | //ä¸æä»»å¡ |
| | | |
| | | @RequestMapping(method=RequestMethod.GET,value="/delecttask1/{id}/{line}") |
| | | @ResponseBody |
| | | public String delecttask1(Model model,@PathVariable("id") Long id,@PathVariable("line") Long line){ |
| | | return cutManageService.delecttask1(id,line); |
| | | } |
| | |
| | | #jdbc.url=jdbc:oracle:thin:@127.0.0.1:1521:XE |
| | | #jdbc.username=gmms2 |
| | | #jdbc.password=gmms2 |
| | | #jdbc.url=jdbc:mariadb:// localhost 10.12.0.100/gmms?useUnicode=true&characterEncoding=utf-8&autoReconnect=true |
| | | #jdbc.url=jdbc:mariadb:// localhost:3307 10.12.0.100:3306/gmms?useUnicode=true&characterEncoding=utf-8&autoReconnect=true |
| | | #mysql database setting |
| | | jdbc.driver=org.mariadb.jdbc.Driver |
| | | jdbc.url=jdbc:mariadb://localhost:3307/gmms?useUnicode=true&characterEncoding=utf-8&autoReconnect=true |
| | |
| | | <script type="text/javascript"> |
| | | //忢页é¢èªå¨å·æ° |
| | | |
| | | function delecttask(groups,id) { |
| | | //disableAutoRefresh(); |
| | | $.ajax({ |
| | | async : false, |
| | | var groups=0; |
| | | var id=0; |
| | | var state=0; |
| | | //ç»æä»»å¡å¼¹çª |
| | | function delecttask(groups1,id1) { |
| | | if(typeof stopRefresh === "function"){ |
| | | stopRefresh(); |
| | | } |
| | | $("#add-info1").modal('show'); |
| | | groups=groups1; |
| | | id=id1; |
| | | state=1 |
| | | |
| | | } |
| | | //䏿任å¡å¼¹çª |
| | | function delecttask1(groups1,id1) { |
| | | if(typeof stopRefresh === "function"){ |
| | | stopRefresh(); |
| | | } |
| | | $("#add-info1").modal('show'); |
| | | groups=groups1; |
| | | id=id1; |
| | | state=2 |
| | | |
| | | } |
| | | //ç»æä¸æä»»å¡ |
| | | function delecttask3() { |
| | | if(state==1){ |
| | | $.ajax({ |
| | | async : false, |
| | | |
| | | type : "GET", |
| | | type : "GET", |
| | | |
| | | url : "${ctx}/cutmanage/delecttask/" + id +"/" +groups, |
| | | url : "${ctx}/cutmanage/delecttask/" + id +"/" +groups, |
| | | |
| | | dataType : "text", |
| | | dataType : "text", |
| | | |
| | | success : function(data) { |
| | | window.location.href = "${ctx}/cutmanage/gettask/" + groups; |
| | | } |
| | | }); |
| | | alert(groups); |
| | | success : function(data) { |
| | | alert(groups+"å·çº¿"+data); |
| | | if(data=="ç»ææå"){ |
| | | window.location.href = "${ctx}/cutmanage/gettask/" + groups; |
| | | } |
| | | |
| | | } |
| | | }); |
| | | }else if(state==2){ |
| | | $.ajax({ |
| | | async : false, |
| | | |
| | | type : "GET", |
| | | |
| | | url : "${ctx}/cutmanage/delecttask1/" + id+"/" +groups, |
| | | |
| | | dataType : "text", |
| | | |
| | | success : function(data) { |
| | | alert(groups+"å·çº¿"+data); |
| | | if(data=="䏿æå"){ |
| | | window.location.href = "${ctx}/cutmanage/gettask/" + groups; |
| | | } |
| | | |
| | | } |
| | | }); |
| | | } |
| | | |
| | | } |
| | | //å¼¹çªåæ¶ |
| | | function delecttask4() { |
| | | window.location.href = "${ctx}/cutmanage/gettask/" + groups; |
| | | } |
| | | |
| | | function delecttask1(groups,id) { |
| | | /* function delecttask1(groups,id) { |
| | | //disableAutoRefresh();disableAutoRefresh(); |
| | | $.ajax({ |
| | | async : false, |
| | |
| | | dataType : "text", |
| | | |
| | | success : function(data) { |
| | | window.location.href = "${ctx}/cutmanage/gettask/" + groups; |
| | | alert(groups+"å·çº¿"+data); |
| | | if(data=="䏿æå"){ |
| | | window.location.href = "${ctx}/cutmanage/gettask/" + groups; |
| | | } |
| | | |
| | | } |
| | | }); |
| | | } |
| | | } */ |
| | | |
| | | function updatetask(id) { |
| | | //disableAutoRefresh(); |
| | |
| | | </tbody> |
| | | </table> |
| | | </div> |
| | | |
| | | |
| | | <div class="modal fade" id="add-info1" tabindex="-1" role="dialog" |
| | | aria-labelledby="myModalLabel" aria-hidden="true"> |
| | | <form class="form-horizontal" role="form"> |
| | | <div class="modal-dialog"> |
| | | <div class="modal-content"> |
| | | <div class="modal-header"> |
| | | <button type="button" class="close" onclick="delecttask4()" data-dismiss="modal" |
| | | aria-hidden="true">×</button> |
| | | <h3 class="modal-title" id="DEL_AlertTitle">æä½æç¤ºï¼</h3> |
| | | </div> |
| | | <div class="modal-body" style="text-align: left;"> |
| | | <h3 id="DEL_MsgShow"> |
| | | æ¯å¦ç¡®å®æ§è¡ <span id="DEL_Id" style="sixe: 25px; font-weight: bold"></span> |
| | | <span style="sixe: 20px; color: red; font-weight: bold">ç»æ/ä¸æä»»å¡ |
| | | </span> æä½ï¼ |
| | | </h3> |
| | | </div> |
| | | <div class="modal-footer"> |
| | | |
| | | <button type="button" onclick="delecttask4()" class="btn btn-default btn-lg" |
| | | data-dismiss="modal">å¦</button> |
| | | <button type="button" onclick="delecttask3()" class="btn btn-primary btn-lg" id="addbtnsubmit">æ¯</button> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | </form> |
| | | </div> |
| | | |
| | | |
| | | </section> |
| | | |
| | | <%@ include file="/WEB-INF/views/mes/view/modal_banzu.jsp"%> |
| | |
| | | </div> |
| | | </div> |
| | | <div class="modal-footer" > |
| | | <button type="button" class="btn btn-default btn-lg" |
| | | data-dismiss="modal">å
³é</button> |
| | | <button type="button" class="btn btn-default btn-lg" data-dismiss="modal">å
³é</button> |
| | | <button type="button" onclick="addrack1()" class="btn btn-primary btn-lg" |
| | | id="addbtnsubmit">æäº¤</button> |
| | | </div> |
| | |
| | | <th>å度(mm)</th> |
| | | <th>æ°é</th> |
| | | <th>æµç¨å¡å·</th> |
| | | <th>ç¦ç¨ç¶æ(1为ç¦ç¨)</th> |
| | | <th>å·¥ç¨å·</th> |
| | | <th style="width:200px">ç¦ç¨ç¶æ(1为ç¦ç¨)</th> |
| | | </tr> |
| | | </thead> |
| | | <tbody> |
| | |
| | | <th>å度(mm)</th> |
| | | <th>æ°é</th> |
| | | <th>æµç¨å¡å·</th> |
| | | <th>ç¦ç¨ç¶æ(1为ç¦ç¨)</th> |
| | | <th>å·¥ç¨å·</th> |
| | | <th style="width:200px">ç¦ç¨ç¶æ(1为ç¦ç¨)</th> |
| | | </tr> |
| | | </thead> |
| | | <tbody> |
| | |
| | | #jdbc.url=jdbc:oracle:thin:@127.0.0.1:1521:XE |
| | | #jdbc.username=gmms2 |
| | | #jdbc.password=gmms2 |
| | | #jdbc.url=jdbc:mariadb:// localhost 10.12.0.100/gmms?useUnicode=true&characterEncoding=utf-8&autoReconnect=true |
| | | #jdbc.url=jdbc:mariadb:// localhost:3307 10.12.0.100:3306/gmms?useUnicode=true&characterEncoding=utf-8&autoReconnect=true |
| | | #mysql database setting |
| | | jdbc.driver=org.mariadb.jdbc.Driver |
| | | jdbc.url=jdbc:mariadb://localhost:3307/gmms?useUnicode=true&characterEncoding=utf-8&autoReconnect=true |
| | |
| | | <script type="text/javascript"> |
| | | //忢页é¢èªå¨å·æ° |
| | | |
| | | function delecttask(groups,id) { |
| | | //disableAutoRefresh(); |
| | | $.ajax({ |
| | | async : false, |
| | | var groups=0; |
| | | var id=0; |
| | | var state=0; |
| | | //ç»æä»»å¡å¼¹çª |
| | | function delecttask(groups1,id1) { |
| | | if(typeof stopRefresh === "function"){ |
| | | stopRefresh(); |
| | | } |
| | | $("#add-info1").modal('show'); |
| | | groups=groups1; |
| | | id=id1; |
| | | state=1 |
| | | |
| | | } |
| | | //䏿任å¡å¼¹çª |
| | | function delecttask1(groups1,id1) { |
| | | if(typeof stopRefresh === "function"){ |
| | | stopRefresh(); |
| | | } |
| | | $("#add-info1").modal('show'); |
| | | groups=groups1; |
| | | id=id1; |
| | | state=2 |
| | | |
| | | } |
| | | //ç»æä¸æä»»å¡ |
| | | function delecttask3() { |
| | | if(state==1){ |
| | | $.ajax({ |
| | | async : false, |
| | | |
| | | type : "GET", |
| | | type : "GET", |
| | | |
| | | url : "${ctx}/cutmanage/delecttask/" + id +"/" +groups, |
| | | url : "${ctx}/cutmanage/delecttask/" + id +"/" +groups, |
| | | |
| | | dataType : "text", |
| | | dataType : "text", |
| | | |
| | | success : function(data) { |
| | | window.location.href = "${ctx}/cutmanage/gettask/" + groups; |
| | | } |
| | | }); |
| | | alert(groups); |
| | | success : function(data) { |
| | | alert(groups+"å·çº¿"+data); |
| | | if(data=="ç»ææå"){ |
| | | window.location.href = "${ctx}/cutmanage/gettask/" + groups; |
| | | } |
| | | |
| | | } |
| | | }); |
| | | }else if(state==2){ |
| | | $.ajax({ |
| | | async : false, |
| | | |
| | | type : "GET", |
| | | |
| | | url : "${ctx}/cutmanage/delecttask1/" + id+"/" +groups, |
| | | |
| | | dataType : "text", |
| | | |
| | | success : function(data) { |
| | | alert(groups+"å·çº¿"+data); |
| | | if(data=="䏿æå"){ |
| | | window.location.href = "${ctx}/cutmanage/gettask/" + groups; |
| | | } |
| | | |
| | | } |
| | | }); |
| | | } |
| | | |
| | | } |
| | | //å¼¹çªåæ¶ |
| | | function delecttask4() { |
| | | window.location.href = "${ctx}/cutmanage/gettask/" + groups; |
| | | } |
| | | |
| | | function delecttask1(groups,id) { |
| | | /* function delecttask1(groups,id) { |
| | | //disableAutoRefresh();disableAutoRefresh(); |
| | | $.ajax({ |
| | | async : false, |
| | |
| | | dataType : "text", |
| | | |
| | | success : function(data) { |
| | | window.location.href = "${ctx}/cutmanage/gettask/" + groups; |
| | | alert(groups+"å·çº¿"+data); |
| | | if(data=="䏿æå"){ |
| | | window.location.href = "${ctx}/cutmanage/gettask/" + groups; |
| | | } |
| | | |
| | | } |
| | | }); |
| | | } |
| | | } */ |
| | | |
| | | function updatetask(id) { |
| | | //disableAutoRefresh(); |
| | |
| | | </tbody> |
| | | </table> |
| | | </div> |
| | | |
| | | |
| | | <div class="modal fade" id="add-info1" tabindex="-1" role="dialog" |
| | | aria-labelledby="myModalLabel" aria-hidden="true"> |
| | | <form class="form-horizontal" role="form"> |
| | | <div class="modal-dialog"> |
| | | <div class="modal-content"> |
| | | <div class="modal-header"> |
| | | <button type="button" class="close" onclick="delecttask4()" data-dismiss="modal" |
| | | aria-hidden="true">×</button> |
| | | <h3 class="modal-title" id="DEL_AlertTitle">æä½æç¤ºï¼</h3> |
| | | </div> |
| | | <div class="modal-body" style="text-align: left;"> |
| | | <h3 id="DEL_MsgShow"> |
| | | æ¯å¦ç¡®å®æ§è¡ <span id="DEL_Id" style="sixe: 25px; font-weight: bold"></span> |
| | | <span style="sixe: 20px; color: red; font-weight: bold">ç»æ/ä¸æä»»å¡ |
| | | </span> æä½ï¼ |
| | | </h3> |
| | | </div> |
| | | <div class="modal-footer"> |
| | | |
| | | <button type="button" onclick="delecttask4()" class="btn btn-default btn-lg" |
| | | data-dismiss="modal">å¦</button> |
| | | <button type="button" onclick="delecttask3()" class="btn btn-primary btn-lg" id="addbtnsubmit">æ¯</button> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | </form> |
| | | </div> |
| | | |
| | | |
| | | </section> |
| | | |
| | | <%@ include file="/WEB-INF/views/mes/view/modal_banzu.jsp"%> |
| | |
| | | <th>å度(mm)</th> |
| | | <th>æ°é</th> |
| | | <th>æµç¨å¡å·</th> |
| | | <th>ç¦ç¨ç¶æ(1为ç¦ç¨)</th> |
| | | <th>å·¥ç¨å·</th> |
| | | <th style="width:200px">ç¦ç¨ç¶æ(1为ç¦ç¨)</th> |
| | | </tr> |
| | | </thead> |
| | | <tbody> |
| | |
| | | <th>å度(mm)</th> |
| | | <th>æ°é</th> |
| | | <th>æµç¨å¡å·</th> |
| | | <th>ç¦ç¨ç¶æ(1为ç¦ç¨)</th> |
| | | <th>å·¥ç¨å·</th> |
| | | <th style="width:200px">ç¦ç¨ç¶æ(1为ç¦ç¨)</th> |
| | | </tr> |
| | | </thead> |
| | | <tbody> |
| | |
| | | #Generated by Maven |
| | | #Wed Jun 11 19:52:31 CST 2025 |
| | | #Fri Jun 13 11:06:57 CST 2025 |
| | | version=1.0-SNAPSHOT |
| | | groupId=com.northglass |
| | | artifactId=gmms2 |