221 lines
11 KiB
Plaintext
221 lines
11 KiB
Plaintext
<%@ page contentType="text/html; charset=UTF-8" %>
|
|
<%@ page import="weaver.general.Util" %>
|
|
<%@ page import="java.util.*" %>
|
|
<%@ page import="com.alibaba.fastjson.JSONObject" %>
|
|
<%@ page import="weaver.general.TimeUtil" %>
|
|
<%@ page import="weaver.formmode.setup.ModeRightInfo" %>
|
|
<jsp:useBean id="rs" class="weaver.conn.RecordSet" scope="page" />
|
|
<jsp:useBean id="rs1" class="weaver.conn.RecordSet" scope="page" />
|
|
<jsp:useBean id="rss" class="weaver.conn.RecordSet" scope="page" />
|
|
<jsp:useBean id="rst" class="weaver.conn.RecordSet" scope="page" />
|
|
<%
|
|
JSONObject jsonObject = new JSONObject();
|
|
String year = Util.null2String(request.getParameter("year")); //年份
|
|
boolean bool = false;
|
|
|
|
int creater = 1;
|
|
String currentdate = TimeUtil.getCurrentDateString();
|
|
String currenttime = TimeUtil.getOnlyCurrentTimeString();
|
|
int formmodeid = 44;
|
|
String uuid = UUID.randomUUID().toString();
|
|
|
|
rs.executeQuery("select distinct zbmc from uf_rlcbysbb");
|
|
while(rs.next()){
|
|
//
|
|
String mxid = Util.null2String(rs.getString("id"));
|
|
// 指标名称
|
|
String zbmc = Util.null2String(rs.getString("zbmc"));
|
|
|
|
rs1.executeQuery("select * from uf_rlcbzbmcdz where zbmc='"+ zbmc +"' ");
|
|
rs1.next();
|
|
// 一级指标
|
|
String sjzb1 = Util.null2String(rs1.getString("sjzb1"));
|
|
// 二级指标
|
|
String sjzb2 = Util.null2String(rs1.getString("sjzb2"));
|
|
// 三级指标
|
|
String sjzb3 = Util.null2String(rs1.getString("sjzb3"));
|
|
// 四级指标
|
|
String sjzb4 = Util.null2String(rs1.getString("sjzb4"));
|
|
|
|
// 指标名称 = 一级指标。 那更新下 一级指标
|
|
if(zbmc.equals(sjzb1)){
|
|
rst.executeUpdate("update uf_rlcbysbb set yjzb1='"+ sjzb1 +"' where id = ?",mxid);
|
|
}
|
|
// 指标名称 = 二级指标。 那更新下 二级指标、一级指标
|
|
else if(zbmc.equals(sjzb2)){
|
|
rst.executeUpdate("update uf_rlcbysbb set yjzb1='"+ sjzb1 +"',ejzb='"+ sjzb2 +"' where id = ?",mxid);
|
|
}
|
|
// 指标名称 = 三级指标。 那更新下 三级指标、二级指标、一级指标
|
|
else if(zbmc.equals(sjzb2)){
|
|
rst.executeUpdate("update uf_rlcbysbb set yjzb1='"+ sjzb1 +"',ejzb='"+ sjzb2 +"',sjzb3='"+ sjzb3 +"' where id = ?",mxid);
|
|
}
|
|
// 指标名称 = 四级指标。 那更新下 四级指标、三级指标、二级指标、一级指标
|
|
else if(zbmc.equals(sjzb2)){
|
|
rst.executeUpdate("update uf_rlcbysbb set yjzb1='"+ sjzb1 +"',ejzb='"+ sjzb2 +"',sjzb3='"+ sjzb3 +"',sjzb4='"+ sjzb4 +"' where id = ?",mxid);
|
|
}
|
|
}
|
|
|
|
// 二级指标
|
|
List<String> ejzbList = new ArrayList<>();
|
|
rs.executeQuery("select distinct ejzb from uf_rlcbysbb where ysnf = ? and (ejzb is not null and ejzb <> '') ",year);
|
|
while(rs.next()) {
|
|
String ejzb = Util.null2String(rs.getString("ejzb"));
|
|
ejzbList.add(ejzb);
|
|
}
|
|
for(String ejzb: ejzbList){
|
|
rs.executeQuery("select ejzb,sum(snsjfse)snsjfse,sum(jnykjh)jnykjh,sum(y1)y1,sum(y2)y2,sum(y3)y3," +
|
|
" sum(y4)y4,sum(y5)y5,sum(y6)y6,sum(y7)y7,sum(y8)y8,sum(y9)y9,sum(y10)y10,sum(y11)y11,sum(y12)y12,sum(jnhj)jnhj from uf_rlcbysbb where ysnf = ? and ejzb = ? group by ejzb",year,ejzb);
|
|
while(rs.next()) {
|
|
String zbmc = Util.null2String(rs.getString("ejzb"));
|
|
String snsjfse = Util.null2String(rs.getString("snsjfse"));
|
|
String jnykjh = Util.null2String(rs.getString("jnykjh"));
|
|
String y1 = Util.null2String(rs.getString("y1"));
|
|
String y2 = Util.null2String(rs.getString("y2"));
|
|
String y3 = Util.null2String(rs.getString("y3"));
|
|
String y4 = Util.null2String(rs.getString("y4"));
|
|
String y5 = Util.null2String(rs.getString("y5"));
|
|
String y6 = Util.null2String(rs.getString("y6"));
|
|
String y7 = Util.null2String(rs.getString("y7"));
|
|
String y8 = Util.null2String(rs.getString("y8"));
|
|
String y9 = Util.null2String(rs.getString("y9"));
|
|
String y10 = Util.null2String(rs.getString("y10"));
|
|
String y11 = Util.null2String(rs.getString("y11"));
|
|
String y12 = Util.null2String(rs.getString("y12"));
|
|
String jnhj = Util.null2String(rs.getString("jnhj"));
|
|
|
|
rs1.executeQuery("select * from uf_rlcbysbb where zbmc=?",zbmc);
|
|
if(!rs1.next()){
|
|
|
|
String insertSql = " insert into uf_rlcbysbb(zbmc,snsjfse,jnykjh,y1,y2,y3,y4," +
|
|
"y5,y6,y7,y8,y9,y10,y11,y12,jnhj," +
|
|
"ysnf,modedatacreater,modedatacreatedate,modedatacreatetime,formmodeid,modeuuid) " +
|
|
"values(?,?,?,?,?,?,?," +
|
|
"?,?,?,?,?,?,?,?,?,"+
|
|
"?,?,?,?,?,?) ";
|
|
boolean exeRes = rst.executeUpdate(insertSql,new Object[]{zbmc,snsjfse,jnykjh,y1,y2,y3,y4,
|
|
y5,y6,y7,y8,y9,y10,y11,y12,jnhj,
|
|
year,creater, currentdate, currenttime, formmodeid, uuid});
|
|
int billid = -1;
|
|
if (exeRes) {
|
|
//重构权限
|
|
rss.executeQuery(" select id from uf_rlcbysbb where modeuuid=? ",new Object[]{uuid});
|
|
rss.next();
|
|
billid = rss.getInt("id");
|
|
ModeRightInfo moderight = new ModeRightInfo();
|
|
moderight.editModeDataShare(creater, formmodeid, billid);
|
|
}
|
|
}
|
|
}
|
|
}
|
|
|
|
// 三级指标
|
|
List<String> sjzb3List = new ArrayList<>();
|
|
rs.executeQuery("select distinct sjzb3 from uf_rlcbysbb where ysnf = ? and (sjzb3 is not null and sjzb3 <> '') ",year);
|
|
while(rs.next()) {
|
|
String ejzb = Util.null2String(rs.getString("sjzb3"));
|
|
sjzb3List.add(ejzb);
|
|
}
|
|
for(String sjzb: sjzb3List){
|
|
rs.executeQuery("select sjzb3,sum(snsjfse)snsjfse,sum(jnykjh)jnykjh,sum(y1)y1,sum(y2)y2,sum(y3)y3," +
|
|
" sum(y4)y4,sum(y5)y5,sum(y6)y6,sum(y7)y7,sum(y8)y8,sum(y9)y9,sum(y10)y10,sum(y11)y11,sum(y12)y12,sum(jnhj)jnhj from uf_rlcbysbb where ysnf = ? and sjzb3 = ? group by sjzb3",year,sjzb);
|
|
while(rs.next()) {
|
|
String zbmc = Util.null2String(rs.getString("sjzb3"));
|
|
String snsjfse = Util.null2o(rs.getString("snsjfse"));
|
|
String jnykjh = Util.null2o(rs.getString("jnykjh"));
|
|
String y1 = Util.null2o(rs.getString("y1"));
|
|
String y2 = Util.null2o(rs.getString("y2"));
|
|
String y3 = Util.null2o(rs.getString("y3"));
|
|
String y4 = Util.null2o(rs.getString("y4"));
|
|
String y5 = Util.null2o(rs.getString("y5"));
|
|
String y6 = Util.null2o(rs.getString("y6"));
|
|
String y7 = Util.null2o(rs.getString("y7"));
|
|
String y8 = Util.null2o(rs.getString("y8"));
|
|
String y9 = Util.null2o(rs.getString("y9"));
|
|
String y10 = Util.null2o(rs.getString("y10"));
|
|
String y11 = Util.null2o(rs.getString("y11"));
|
|
String y12 = Util.null2o(rs.getString("y12"));
|
|
String jnhj = Util.null2o(rs.getString("jnhj"));
|
|
|
|
rs1.executeQuery("select * from uf_rlcbysbb where zbmc=?",zbmc);
|
|
if(!rs1.next()){
|
|
|
|
String insertSql = " insert into uf_rlcbysbb(zbmc,snsjfse,jnykjh,y1,y2,y3,y4," +
|
|
"y5,y6,y7,y8,y9,y10,y11,y12,jnhj," +
|
|
"ysnf,modedatacreater,modedatacreatedate,modedatacreatetime,formmodeid,modeuuid) " +
|
|
"values(?,?,?,?,?,?,?," +
|
|
"?,?,?,?,?,?,?,?,?,"+
|
|
"?,?,?,?,?,?) ";
|
|
boolean exeRes = rst.executeUpdate(insertSql,new Object[]{zbmc,snsjfse,jnykjh,y1,y2,y3,y4,
|
|
y5,y6,y7,y8,y9,y10,y11,y12,jnhj,
|
|
year,creater, currentdate, currenttime, formmodeid, uuid});
|
|
int billid = -1;
|
|
if (exeRes) {
|
|
//重构权限
|
|
rss.executeQuery(" select id from uf_rlcbysbb where modeuuid=? ",new Object[]{uuid});
|
|
rss.next();
|
|
billid = rss.getInt("id");
|
|
ModeRightInfo moderight = new ModeRightInfo();
|
|
moderight.editModeDataShare(creater, formmodeid, billid);
|
|
}
|
|
}
|
|
}
|
|
}
|
|
|
|
// 四级指标
|
|
List<String> sjzb4List = new ArrayList<>();
|
|
rs.executeQuery("select distinct sjzb4 from uf_rlcbysbb where ysnf = ? and (sjzb4 is not null and sjzb4 <> '') ",year);
|
|
while(rs.next()) {
|
|
String ejzb = Util.null2String(rs.getString("sjzb4"));
|
|
sjzb4List.add(ejzb);
|
|
}
|
|
for(String sjzb: sjzb4List){
|
|
rs.executeQuery("select sjzb4,sum(snsjfse)snsjfse,sum(jnykjh)jnykjh,sum(y1)y1,sum(y2)y2,sum(y3)y3," +
|
|
" sum(y4)y4,sum(y5)y5,sum(y6)y6,sum(y7)y7,sum(y8)y8,sum(y9)y9,sum(y10)y10,sum(y11)y11,sum(y12)y12,sum(jnhj)jnhj from uf_rlcbysbb where ysnf = ? and sjzb4 = ? group by sjzb4",year,sjzb);
|
|
while(rs.next()) {
|
|
String zbmc = Util.null2String(rs.getString("sjzb4"));
|
|
String snsjfse = Util.null2o(rs.getString("snsjfse"));
|
|
String jnykjh = Util.null2o(rs.getString("jnykjh"));
|
|
String y1 = Util.null2o(rs.getString("y1"));
|
|
String y2 = Util.null2o(rs.getString("y2"));
|
|
String y3 = Util.null2o(rs.getString("y3"));
|
|
String y4 = Util.null2o(rs.getString("y4"));
|
|
String y5 = Util.null2o(rs.getString("y5"));
|
|
String y6 = Util.null2o(rs.getString("y6"));
|
|
String y7 = Util.null2o(rs.getString("y7"));
|
|
String y8 = Util.null2o(rs.getString("y8"));
|
|
String y9 = Util.null2o(rs.getString("y9"));
|
|
String y10 = Util.null2o(rs.getString("y10"));
|
|
String y11 = Util.null2o(rs.getString("y11"));
|
|
String y12 = Util.null2o(rs.getString("y12"));
|
|
String jnhj = Util.null2o(rs.getString("jnhj"));
|
|
|
|
rs1.executeQuery("select * from uf_rlcbysbb where zbmc=?",zbmc);
|
|
if(!rs1.next()){
|
|
|
|
String insertSql = " insert into uf_rlcbysbb(zbmc,snsjfse,jnykjh,y1,y2,y3,y4," +
|
|
"y5,y6,y7,y8,y9,y10,y11,y12,jnhj," +
|
|
"ysnf,modedatacreater,modedatacreatedate,modedatacreatetime,formmodeid,modeuuid) " +
|
|
"values(?,?,?,?,?,?,?," +
|
|
"?,?,?,?,?,?,?,?,?,"+
|
|
"?,?,?,?,?,?) ";
|
|
boolean exeRes = rst.executeUpdate(insertSql,new Object[]{zbmc,snsjfse,jnykjh,y1,y2,y3,y4,
|
|
y5,y6,y7,y8,y9,y10,y11,y12,jnhj,
|
|
year,creater, currentdate, currenttime, formmodeid, uuid});
|
|
int billid = -1;
|
|
if (exeRes) {
|
|
//重构权限
|
|
rss.executeQuery(" select id from uf_rlcbysbb where modeuuid=? ",new Object[]{uuid});
|
|
rss.next();
|
|
billid = rss.getInt("id");
|
|
ModeRightInfo moderight = new ModeRightInfo();
|
|
moderight.editModeDataShare(creater, formmodeid, billid);
|
|
}
|
|
}
|
|
}
|
|
}
|
|
|
|
bool = true;
|
|
jsonObject.put("bool",bool);
|
|
|
|
out.print(jsonObject.toString());
|
|
%> |