<%@page import="com.northglass.Globel.mes"%> <%@page import="com.northglass.SqlHelper.*"%> <%@page import="org.json.*"%> <%@ page contentType="text/json;charset=UTF-8"%> <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%> <% //String yemian = request.getParameter("gongyi"); String line = request.getParameter("line"); String caozuo = request.getParameter("caozuo"); String leixing = request.getParameter("leixing"); String Id = request.getParameter("Id"); String gongyi = request.getParameter("gongyi"); String lckh = request.getParameter("lckh"); DBSession sn = null; boolean ok = false; //System.out.println("操作类型：" + leixing + ";工艺：" + gongyi+";操作："+caozuo); try { sn = mes.getMesDBHelper().createSession(false); String strSQL = ""; if ("查询".equals(caozuo)) { if ("磨边开合查询".equals(leixing)) { String stime = request.getParameter("stime"); String etime = request.getParameter("etime"); String trigger = request.getParameter("trigger"); String Edg = request.getParameter("Edg"); String banzu = request.getParameter("banzu"); String gby=""; //String isdb = request.getParameter("isdb"); System.out.println(etime); /* if("".equals(etime)||etime==null){ etime="Now()"; }else{ etime="'"+etime+"'"; } */ if("".equals(Edg)||Edg==null||"0".equals(Edg)){ Edg="width,height,SendTime,Line,count(*) as piece,ifnull(banzu,'')"; gby="Recordsid"; }else if("1".equals(Edg)){ Edg="width,SendTime,Line,ifnull(banzu,''),count(*) as piece"; gby="RecordsidW"; }else if("2".equals(Edg)){ Edg="height,SendTime,Line,ifnull(banzu,''),count(*) as piece"; gby="RecordsidH"; } if("".equals(banzu)||banzu==null||"0".equals(banzu)){ banzu=""; }else{ banzu=" banzu='"+banzu+"' and"; } if("1".equals(trigger)){//查询 strSQL = "select "+Edg+" from Y_Edg_Statistics"+ " where Line="+line+" and "+banzu+" SendTime>='"+stime+"' and SendTime<='"+etime+"'"+ " GROUP BY "+gby; }else{//默认 strSQL ="select width,height,SendTime,Line,count(*) as piece,ifnull(banzu,'') from Y_Edg_Statistics"+ " where Line="+line+" and SendTime>=CONCAT(DATE_FORMAT(Now(),'%Y-%m-%d'),' 00:00:00') and SendTime<=CONCAT(DATE_FORMAT(Now(),'%Y-%m-%d'),' 23:59:59')"+ " GROUP BY Recordsid"; } System.out.println(strSQL); } if ("次破类型".equals(leixing)) { strSQL = "select id,cipoleixing from cipoleixing"; } if ("次破原因".equals(leixing)) { strSQL = "select xuhao,cipoyuanyin,cipoleixing from cipoyuanyin"; } if ("班组列表".equals(leixing)) { String gy = gongyi.contains("钢化") ? "钢化" : gongyi; strSQL = "select banzumingcheng from banzu where gongyi='" + gongyi + "'"; } if ("当前班组".equals(leixing)) { gongyi = gongyi.contains("钢化") ? "钢化" : gongyi; strSQL = "select banzu,isPaused from gmms_user_current where gongyi= '" + gongyi + "' and chanxian = " + line; } if ("流程卡详情".equals(leixing)) { if ("钢化".equals(gongyi)) { strSQL = "select processcard_id,stop_rank,galss_id,edg_width,edg_height,concat(thickness,'mm ',color) moxi,work_procedure,work_state,Id from gmms_galss_task_2 where processcard_id = '" + lckh + "' order by stop_rank"; }else if("磨边".equals(gongyi)){ strSQL="SELECT a.processcard_id,b.stop_rank,a.id,a.edg_width,a.edg_height,concat( a.thickness, 'mm ', a.color ) moxi, b.work_procedure,"+ "if((select count(1) from e_pierceds where glass_id = a.id)>0 ,'破损',b.work_state) as state,a.Id,if((select count(1) from e_record_stock where glass_id = a.id)>0 ,1,0) as isReport FROM gmms_galss_task_buffer a LEFT JOIN gmms_galss_task_details b ON a.id = b.id"+ " WHERE a.processcard_id = '"+lckh+"' ORDER BY b.stop_rank desc;"; }else if("仓储".equals(gongyi)){ strSQL="select processcard_id,stop_rank,galss_id,edg_width,edg_height,concat(thickness,'mm ',color) moxi,work_procedure,work_state,Id from gmms_galss_task_shelf where processcard_id = '" + lckh + "' order by stop_rank"; }else if("仓储配对".equals(gongyi)){ strSQL="select gb.processcard_id,count(gb.id) as pricesz,count(gs.id) as prices,gb.edg_width,gb.edg_height,concat(gb.thickness,'mm ',gb.color) as moxi from gmms_galss_task_buffer as gb" +" left join gmms_galss_task_shelf as gs on gs.id=gb.id" +" where gb.processcard_id = '"+lckh+"' group by gb.edg_width,gb.edg_height,gb.thickness,gb.color order by gb.edg_width"; } else { strSQL = "select processcard_id,stop_rank,galss_id,edg_width,edg_height,concat(thickness,'mm ',color) moxi,work_procedure,work_state,Id from gmms_galss_task_shelf where processcard_id = '" + lckh + "' order by stop_rank"; } } if("全部班组".equals(leixing)){ strSQL="select gongxu,banzumingcheng from banzu group by gongxu,banzumingcheng order by gongxu desc"; } if("报工详情".equals(leixing)){ //strSQL="select null, processcard_id,(select count(1) from e_pierceds p where p.processcard_id =s.processcard_id ) as '破损数',count(1) as '完成数' ,concat(s.thinkess,s.color) as '膜系', max(s.create_time) as '完成时间' from e_record_stock s where is_report = 0 and line = "+line+" group by s.processcard_id,s.team_name,concat(s.thinkess,s.color)"; /* strSQL="select null, s.processcard_id,(select count(1) from e_pierceds p where p.processcard_id =s.processcard_id ) as '破损数', "+ "(select IFNULL(sum(tb.edg_width*tb.edg_height),0) from e_pierceds p LEFT JOIN gmms_galss_task_buffer as tb on p.glass_id=tb.id where p.processcard_id =s.processcard_id) as '破损平方', "+ "count(1) as '完成数' ,IFNULL(sum(bf.edg_width*bf.edg_height)/1000000,0) as '完成平方', "+ "concat(s.thinkess,s.color) as '膜系', max(s.create_time) as '完成时间' from e_record_stock s left join gmms_galss_task_buffer as bf on s.glass_id=bf.id where is_report = 0 and line = 3 group by s.processcard_id,s.team_name,concat(s.thinkess,s.color)"; */ strSQL="select null, s.processcard_id,(select count(1) from e_pierceds p where p.processcard_id =s.processcard_id and process='磨边' and is_report!=-1) as '破损数', "+ "count(1) as '完成数' , "+ "concat(s.thinkess,s.color) as '膜系', max(s.create_time) as '完成时间', "+ "(select IFNULL(sum(tb.edg_width*tb.edg_height)/1000000,0) from e_pierceds p LEFT JOIN gmms_galss_task_buffer as tb on p.glass_id=tb.id where p.processcard_id =s.processcard_id and process='磨边' and is_report!=-1) as '破损平方',IFNULL(sum(bf.edg_width*bf.edg_height)/1000000,0) as '完成平方' from e_record_stock s left join gmms_galss_task_buffer as bf on s.glass_id=bf.id where is_report = 0 and line = "+line+" group by s.processcard_id,s.team_name,concat(s.thinkess,s.color) "; } if("钢化报工详情".equals(leixing)){ strSQL="select null, s.processcard_id,(select count(1) from e_pierceds p where p.processcard_id =s.processcard_id and process='钢化' and is_report!=-1) as '破损数', "+ "count(1) as '完成数' , "+ "concat(s.thinkess,s.color) as '膜系', max(s.create_time) as '完成时间', "+ "(select IFNULL(sum(tb.edg_width*tb.edg_height)/1000000,0) from e_pierceds p LEFT JOIN gmms_galss_task_buffer as tb on p.glass_id=tb.id where p.processcard_id =s.processcard_id and process='钢化' and is_report!=-1) as '破损平方',IFNULL(sum(s.width*s.height)/1000000,0) as '完成平方' from e_record_tempering s where is_report != 4 and report_time is null and line = "+line+" group by s.processcard_id,s.team_name,concat(s.thinkess,s.color)"; } if ("次破列表".equals(leixing)) { String info = request.getParameter("cpInfo"); //System.out.println("传入数据："+info); //工艺，班组 String[] s = info.split("-"); if("0".equals(s[2])){ strSQL = "select * from v_cipo where process = '"+s[0]+"' and team_name = '"+s[1]+"' and is_report !=-1"; }if("1".equals(s[2])){ strSQL = "select * from v_cipo where process = '"+s[0]+"' and team_name = '"+s[1]+"' and is_report = 0"; }if("2".equals(s[2])){ //strSQL = "select * from v_cipo where process = '"+s[0]+"' and team_name = '"+s[1]+"' and pierced_cause is null and is_report !=-1"; strSQL = "select * from v_cipo where process = '"+s[0]+"' and team_name = '"+s[1]+"' and is_report !=-1"; }if("3".equals(s[2])){ strSQL = "select * from v_cipo where process = '"+s[0]+"' and team_name = '"+s[1]+"' and is_report !=-1"; } } if("空架".equals(leixing)){ strSQL="select r.id,f.rank from gmms_drop_frame_5 f left join gmms_shelf_rack_2 r on f.rank =r.id where f.groups_ = 100 and f.stops <21 and f.rank is not null and r.processcard_id is null"; } if("仓储配对信息".equals(leixing)){ strSQL="select * from v_cc_cpinfo"; } if("所有膜系".equals(leixing)){ strSQL ="SELECT DISTINCT(glass_id) FROM `gmms_glass_number_color` "; } //System.out.println("信息查询：" + strSQL); if("切割工位模式".equals(leixing)){ strSQL="select gongwei_mode from gmms_prod_line_state where line ="+line; } if("可钢化膜系".equals(leixing)){ strSQL ="select moxi from v_ghq_liuchengka group by moxi order by count(1) desc"; } if("切割原片详情".equals(leixing)){ strSQL ="select null,width,height,thickness,color,batch_id,sum(pieces),dengluname from gmms_cutmanage where groups ="+line+" and BgTime is null "+ "group by width,height,thickness,color,batch_id,dengluname"; } if ("理片笼单双片模式".equals(leixing)) { strSQL = "select lipianlong_mode from gmms_prod_line_state where line =" + line; } if ("原片库存图".equals(leixing)) { strSQL = "select sr.id,sr.create_time,sr.mod_time,rp.pieces,rp.left_pieces,rp.create_time, "+ "(CASE WHEN TO_DAYS(NOW())-TO_DAYS(rp.create_time)<3 THEN "+ " 0 "+ " WHEN TO_DAYS(NOW())-TO_DAYS(rp.create_time)<5 THEN "+ " 1 "+ " WHEN TO_DAYS(NOW())-TO_DAYS(rp.create_time)<8 THEN "+ " 2 "+ " ELSE "+ " 3 "+ " END) as datetype,CONCAT(IFNULL(rp.raw_width,0),'mm'),CONCAT(IFNULL(rp.raw_height,0),'mm'),CONCAT(IFNULL(rp.raw_thickness,0),'mm'),rp.color,rp.batch_id from gmms_shelf_rack as sr left join gmms_raw_package as rp on sr.raw_package_id1=rp.id where sr.raw_package_id1 is not null"; } if ("切裁率图-原片使用".equals(leixing)) { strSQL = "select IFNULL(SUM(gc.width*gc.height)/1000000,0) from "+ "(SELECT DATE_FORMAT(DATE_SUB(DATE_FORMAT(NOW(),'%Y-%m-%d'),INTERVAL (CAST(help_topic_id AS SIGNED INTEGER)) DAY),'%Y-%m-%d') month "+ "FROM mysql.help_topic WHERE help_topic_id < 14 ORDER BY month ASC) as d "+ "left JOIN gmms_cutmanage as gc on d.month=DATE_FORMAT(gc.BgTime,'%Y-%m-%d') group by d.month;"; } if ("切裁率图-原片使用当月".equals(leixing)) { strSQL = "select IFNULL(SUM(width*height)/1000000,0),IFNULL(DATE_FORMAT(BgTime,'%Y-%m'),DATE_FORMAT(NOW(),'%Y-%m-01')) from gmms_cutmanage where BgTime>DATE_FORMAT(NOW(),'%Y-%m-01');"; } if ("单炉最大装载率-面积最大比例差".equals(leixing)) { strSQL = "select IFNULL(maxLoadingRate,0),IFNULL(maxTolerance,0) from gmms_furnace where id=" + line; } if ("单炉最大面积比例差".equals(leixing)) { strSQL = "select IFNULL(maxTolerance,0) from gmms_furnace where id=" + line; } sn.createSql(strSQL); JSONArray a = sn.query().resultToJson(false); if (a != null) { out.print(a.toString()); } else { out.print("[]"); } } if ("修改".equals(caozuo)) { if ("变更班组".equals(leixing)) { String bzinfo = request.getParameter("info"); strSQL = "update gmms_user_current set banzu = '" + bzinfo + "',isPaused=null where gongyi = '" + gongyi + "' and chanxian = " + line; } if("次破".equals(leixing)){ String info = request.getParameter("cpInfo"); //次破类型，次破原因 String[] s = info.split("-"); strSQL="Update e_pierceds set pierced_type = '"+s[0]+"',pierced_cause = '"+s[1]+"' where glass_id = "+Id; } if("提交报工".equals(leixing)){ String info = request.getParameter("cpInfo"); //次破类型，次破原因 String[] s = info.split("-"); strSQL="Update e_pierceds set is_report = 1 where process = '"+s[0]+"' and team_name = '"+s[1]+"' and pierced_type is not null and is_report=0"; } if("班组下班".equals(leixing)){ strSQL = "update gmms_user_current set banzu = null where gongyi = '" + gongyi+ "' and chanxian = " + line; } //System.out.println("修改：" + strSQL); if("变更切割工位模式".equals(leixing)){ strSQL="update gmms_prod_line_state set gongwei_mode= if(gongwei_mode=1,2,1) where line ="+line; } if ("变更理片笼单双片模式".equals(leixing)) { strSQL = "update gmms_prod_line_state set lipianlong_mode= if(lipianlong_mode=1,2,1) where line =" + line; } if ("单炉最大装载率".equals(leixing)) { String value = request.getParameter("value"); strSQL = "update gmms_furnace set maxLoadingRate='"+value+"' where id=" + line; } if ("单炉最大面积比例差".equals(leixing)) { String value = request.getParameter("value"); strSQL = "update gmms_furnace set maxTolerance='"+value+"' where id=" + line; } sn.createSql(strSQL); int s = sn.update(); //System.out.println(s); out.print(s); } if ("次破".equals(caozuo)) { //gongyi = gongyi.contains("钢化") ? "钢化" : gongyi; if ("钢化".equals(gongyi)) { String info = request.getParameter("cpInfo"); //System.out.println("传入信息：" + info); String[] s = info.split("-"); sn.createStdCall("proc_ePiercedsByGlassIdSave", 5); DBSession.StdCallResult scr = sn.stdCall(s[0], s[1], s[2], s[3], s[4]); int rC = scr.ResultCode; String rM = scr.ResultMessage; if (rC == 1) { out.print("OK"); } else { out.print(rC + "_" + rM); } } if ("中空".equals(gongyi)) { String info = request.getParameter("cpInfo"); //System.out.println("中空传入信息：" + info); String[] s = info.split("-"); sn.createStdCall("proc_ePiercedsByGlassIdSave", 5); DBSession.StdCallResult scr = sn.stdCall(s[0], s[1], s[2], s[3], s[4]); int rC = scr.ResultCode; String rM = scr.ResultMessage; if (rC == 1) { out.print("OK"); } else { out.print(rC + "_" + rM); } } if ("仓储".equals(gongyi)) { String info = request.getParameter("cpInfo"); //System.out.println("仓储传入信息：" + info); String[] s = info.split("-"); sn.createStdCall("proc_ePiercedsByGlassIdSave", 5); DBSession.StdCallResult scr = sn.stdCall(s[0], s[1], s[2], s[3], s[4]); int rC = scr.ResultCode; String rM = scr.ResultMessage; if (rC == 1) { out.print("OK"); } else { out.print(rC + "_" + rM); } } if ("磨边".equals(gongyi)) { String info = request.getParameter("cpInfo"); //System.out.println("磨边传入信息：" + info); String[] s = info.split("-"); sn.createStdCall("proc_ePiercedsByGlassIdSave", 5); DBSession.StdCallResult scr = sn.stdCall(s[0], s[1], s[2], s[3], s[4]); int rC = scr.ResultCode; String rM = scr.ResultMessage; if (rC == 1) { out.print("OK"); } else { out.print(rC + "_" + rM); } } } if("取消破损".equals(caozuo)){ strSQL ="INSERT INTO e_record_tempering(processcard_id, glass_id, width, height, thinkess, color, sequence, create_time, line, team_name, type_num, is_report,rank) "+ "select gt.processcard_id,gt.id,gt.edg_width,gt.edg_height,gt.thickness,gt.color,gt.stop_rank,NOW(),ep.line,ep.team_name,gt.edg_speed2,1,0 from gmms_galss_task_buffer as gt "+ "left join e_record_tempering as et on gt.id=et.glass_id "+ "left join e_pierceds as ep on ep.glass_id=gt.id "+ "where et.glass_id is null and ep.glass_id is not null and gt.id='"+Id+"'"; //System.out.println("修改：" + strSQL); sn.createSql(strSQL); int qx = sn.update(); //System.out.println(s); out.print(qx); String strquxiao="Update e_pierceds set is_report=-1 where glass_id = "+Id; sn.createSql(strquxiao); int qxposun = sn.update(); } if("报工确认".equals(caozuo)){ //System.out.println("报工确认数据：" + lckh + ";产线：" + line); sn.createStdCall("proc_eRecordStockByGlassIdSave", 2); DBSession.StdCallResult scr = sn.stdCall(lckh, line); int rC = scr.ResultCode; String rM = scr.ResultMessage; if (rC == 1) { out.print("OK"); } else { out.print(rC + "_" + rM); } } if("报工提交".equals(caozuo)){ sn.createStdCall("proc_eRecordStockByLineUpdata", 1); DBSession.StdCallResult scr = sn.stdCall(line); int rC = scr.ResultCode; String rM = scr.ResultMessage; if (rC == 1) { out.print("OK"); } else { out.print(rC + "_" + rM); } } if("钢化报工提交".equals(caozuo)){ strSQL = "update e_record_tempering set report_time = now() where is_report != 4 and report_time is null and line = " + line; sn.createSql(strSQL); int s = sn.update(); //out.print(s); String postrSQL="update e_pierceds set report_time = now() where is_report != -1 and is_report != 4 and report_time is null and line = "+line+" and process = '钢化'"; sn.createSql(postrSQL); int ps = sn.update(); out.print(ps); } if("切割提交".equals(caozuo)){ strSQL = "update gmms_cutmanage set BgTime=now() where BgTime is null and groups=" + line; System.out.println(strSQL); sn.createSql(strSQL); int s = sn.update(); out.print(s); String bzSQL = "update gmms_user_current set isPaused='暂停' where gongyi = '磨边' and chanxian = " + line; sn.createSql(bzSQL); int ps = sn.update(); } } catch (Exception e) { e.printStackTrace(); } finally { if (sn != null) sn.close(); } %>