checkReportDataForm.jsp
4.69 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<%@ page import="java.util.Calendar" %>
<%@ page import="weaver.general.Util" %>
<jsp:useBean id="RecordSet" class="weaver.conn.RecordSet" scope="page" />
<%
String formid=Util.null2String(request.getParameter("formid"));
int requestid=Util.getIntValue(request.getParameter("requestid"));
int reportUserId=Util.getIntValue(request.getParameter("reportUserId"));
int crmId=Util.getIntValue(request.getParameter("crmId"));
String year=Util.null2String(request.getParameter("year"));
String month=Util.null2String(request.getParameter("month"));
String day=Util.null2String(request.getParameter("day"));
String date=Util.null2String(request.getParameter("date"));
String src=Util.null2String(request.getParameter("src"));
Calendar today = Calendar.getInstance();
today.add(Calendar.DATE, -1) ;
String currentdate = Util.add0(today.get(Calendar.YEAR), 4) + "-" + Util.add0(today.get(Calendar.MONTH) + 1, 2) + "-" + Util.add0(today.get(Calendar.DAY_OF_MONTH), 2) ;
int inprepId=0;
String inprepfrequence="";
String isInputMultiLine="";
String inprepTableName="";
RecordSet.executeSql("select inprepId,inprepfrequence,isInputMultiLine,inprepTableName from T_InputReport where billId="+formid);
if(RecordSet.next()){
inprepId=Util.getIntValue(RecordSet.getString("inprepId"),0);
inprepfrequence=Util.null2String(RecordSet.getString("inprepfrequence"));
isInputMultiLine=Util.null2String(RecordSet.getString("isInputMultiLine"));
inprepTableName=Util.null2String(RecordSet.getString("inprepTableName"));
if(isInputMultiLine.equals("1")) inprepTableName+="_main";
}
String ret="0";
String thedate = currentdate;
String dspdate = currentdate ;
if(!inprepfrequence.equals("0")) {
switch (Util.getIntValue(inprepfrequence)) {
case 1:
thedate = year + "-01-15" ;
dspdate = year ;
break ;
case 2:
thedate = year + "-"+month+"-15" ;
dspdate = year + "-"+month ;
break ;
case 3:
thedate = year + "-"+month+"-"+day ;
dspdate = year + "-"+month ;
if(day.equals("05")) dspdate += ""+SystemEnv.getHtmlLabelName(84483,user.getLanguage()) ;
if(day.equals("15")) dspdate += ""+SystemEnv.getHtmlLabelName(84484,user.getLanguage()) ;
if(day.equals("25")) dspdate += ""+SystemEnv.getHtmlLabelName(84485,user.getLanguage()) ;
break ;
case 4:
thedate = date;
Calendar todayNew = Calendar.getInstance();
todayNew.set(Calendar.YEAR,Util.getIntValue(date.substring(0,4)));
todayNew.set(Calendar.MONTH,Util.getIntValue(date.substring(5,7))-1);
todayNew.set(Calendar.DAY_OF_MONTH,Util.getIntValue(date.substring(8)));
dspdate = Util.add0(todayNew.get(Calendar.YEAR), 4) + ""+SystemEnv.getHtmlLabelName(15323,user.getLanguage()) + Util.add0(todayNew.get(Calendar.WEEK_OF_YEAR), 2) + ""+SystemEnv.getHtmlLabelName(1926,user.getLanguage());
break;
case 5:
thedate = date ;
dspdate = date ;
break ;
case 6:
thedate = year + "-"+month+"-15" ;
dspdate = year;
if(month.equals("01")) dspdate += ""+SystemEnv.getHtmlLabelName(82520,user.getLanguage()) ;
if(month.equals("07")) dspdate += ""+SystemEnv.getHtmlLabelName(82521,user.getLanguage()) ;
break;
case 7:
thedate = year + "-"+month+"-15" ;
dspdate = year;
if(month.equals("01")) dspdate += ""+SystemEnv.getHtmlLabelName(28287,user.getLanguage()) ;
if(month.equals("04")) dspdate += ""+SystemEnv.getHtmlLabelName(28288,user.getLanguage()) ;
if(month.equals("07")) dspdate += ""+SystemEnv.getHtmlLabelName(28289,user.getLanguage()) ;
if(month.equals("10")) dspdate += ""+SystemEnv.getHtmlLabelName(28290,user.getLanguage());
break;
}
}
String sql=null;
if(!inprepTableName.equals("")){
if(!inprepfrequence.equalsIgnoreCase("0")){
sql="SELECT inputstatus FROM "+inprepTableName+" WHERE inprepdspdate='"+dspdate+"' AND crmid="+crmId+" and requestid <>"+requestid;
}else{//报表无周期限定
sql="SELECT inputstatus FROM "+inprepTableName+" WHERE inputstatus='9' and inprepdspdate='"+dspdate+"' and crmid="+crmId+" AND reportuserid="+reportUserId+" and requestid <>"+requestid;
}
RecordSet.executeSql(sql);
if(RecordSet.next()){
String status=Util.null2String(RecordSet.getString("inputstatus"));
ret=status.equalsIgnoreCase("9")?"2":"1";//status==9,表示已导入数据，但处于草稿状态中。
}
}
%>
<script language="javascript">
parent.checkReportDataReturn("<%=ret%>","<%=thedate%>","<%=dspdate%>","<%=src%>");
</script>