ReportConfirmMtiOperation.jsp
6.85 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
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
<%@ page import="weaver.general.Util" %>
<%@ page import="java.util.*" %>
<%@ page language="java" contentType="text/html; charset=GBK" %> <%@ include file="/systeminfo/init.jsp" %>
<jsp:useBean id="RecordSet" class="weaver.conn.RecordSet" scope="page" />
<jsp:useBean id="rs2" class="weaver.conn.RecordSet" scope="page" />
<jsp:useBean id="WfForceDrawBack" class="weaver.workflow.workflow.WfForceDrawBack" scope="page" />
<jsp:useBean id="CustomerInfoComInfo" class="weaver.crm.Maint.CustomerInfoComInfo" scope="page" />
<jsp:useBean id="SysMaintenanceLog" class="weaver.systeminfo.SysMaintenanceLog" scope="page" />
<%
String operation = Util.null2String(request.getParameter("operation"));
String confirmid = Util.null2String(request.getParameter("confirmid"));
String thetable = Util.null2String(request.getParameter("thetable"));
String inputid = Util.null2String(request.getParameter("inputid"));
String crmid = Util.null2String(request.getParameter("crmid"));
String inprepid = Util.null2String(request.getParameter("inprepid"));
String thedate = Util.null2String(request.getParameter("thedate"));
String inprepbudget = Util.null2String(request.getParameter("inprepbudget"));
String inprepname=Util.null2String(request.getParameter("inprepname"));
String dspdate=Util.null2String(request.getParameter("dspdate"));
int totalvalue = Util.getIntValue(request.getParameter("totalvalue"),0) ;
if(operation.equals("edit")){
Hashtable ht = new Hashtable() ;
Enumeration eu = request.getParameterNames() ;
while(eu.hasMoreElements() ) {
String keyname = (String)eu.nextElement() ;
String keyvalue = Util.null2String(request.getParameter(keyname)) ;
double keyvaluedouble = Util.getDoubleValue(keyvalue , 0) ;
ht.put(keyname , ""+keyvaluedouble) ;
}
ArrayList itemfieldnames = new ArrayList() ;
RecordSet.executeProc("T_IRItem_SelectByInprepid",inprepid);
while(RecordSet.next()) {
String itemfieldname = Util.null2String(RecordSet.getString("itemfieldname")) ;
itemfieldnames.add(itemfieldname) ;
}
for ( int i=0 ; i< totalvalue ; i++ ) {
String sql = "" ;
String theinputid = request.getParameter("inputid_"+i) ;
RecordSet.executeProc("T_IRItem_SelectByInprepid",inprepid);
while (RecordSet.next()) {
String itemfieldname = Util.null2String(RecordSet.getString("itemfieldname")) ;
String itemfieldtype = Util.null2String(RecordSet.getString("itemfieldtype")) ;
String itemgongsi = Util.null2String(RecordSet.getString("itemgongsi")) ;
String inputablefact = Util.null2String(RecordSet.getString("inputablefact")) ; // 实际是否可输入
String inputablebudg = Util.null2String(RecordSet.getString("inputablebudg")) ; // 预算是否可输入
String inputablefore = Util.null2String(RecordSet.getString("inputablefore")) ; // 预测是否可输入
String inputable = inputablefact ;
if(inprepbudget.equals("1")) inputable = inputablebudg ;
else if(inprepbudget.equals("2")) inputable = inputablefore ;
if(sql.equals("")) {
sql = " update " + thetable + " set "+ itemfieldname +" = " ;
}
else {
sql += ","+itemfieldname+"=" ;
}
String itemvalue = "" ;
if(itemfieldtype.equals("2")) itemvalue = "" + Util.getIntValue(request.getParameter(itemfieldname+"_"+i),0);
else if(itemfieldtype.equals("3") || (itemfieldtype.equals("5") && inputable.equals("1")) ) itemvalue = "" + Util.getDoubleValue(request.getParameter(itemfieldname+"_"+i),0);
else if(itemfieldtype.equals("5") && !inputable.equals("1") ) {
for( int k = 0 ; k< itemfieldnames.size() ; k++ ) {
itemgongsi = Util.StringReplace( itemgongsi , (String)itemfieldnames.get(k) , "#####&&&") ;
itemgongsi = Util.StringReplace( itemgongsi , "#####&&&", (String)itemfieldnames.get(k)+"_" + i ) ;
}
String thesql = Util.fillValuesToString(itemgongsi, ht) ;
rs2.executeSql(" select " + thesql +" as result ") ;
if(rs2.next())
itemvalue = ""+Util.getDoubleValue(rs2.getString(1),0) ;
else
itemvalue = "0" ;
}
else itemvalue = Util.null2String(request.getParameter(itemfieldname+"_"+i));
if(itemfieldtype.equals("2") || itemfieldtype.equals("3") || itemfieldtype.equals("5") ) {
sql += itemvalue ;
}
else {
sql += "'" + Util.fromScreen2(itemvalue,user.getLanguage()) + "'" ;
}
}
sql += " where inputid = " + theinputid ;
RecordSet.executeSql(sql);
}
if(confirmid.equals("0"))
response.sendRedirect("ReportConfirmMtiDetail.jsp?thetable="+thetable+"&thedate="+thedate+"&inprepid="+inprepid+"&crmid="+crmid+"&inprepbudget="+inprepbudget);
else
response.sendRedirect("ReportConfirmMtiDetail.jsp?confirmid="+confirmid);
}
else if(operation.equals("confirm")){
String sql = " update " + thetable + " set inputstatus='1' where reportdate = '" + thedate +"' and crmid =" + crmid ;
RecordSet.executeSql(sql);
RecordSet.executeProc("T_InputReportConfirm_Delete", confirmid );
response.sendRedirect("ReportConfirm.jsp");
}
else if(operation.equals("check")){
String sql = " update " + thetable + " set inputstatus='2' where reportdate = '" + thedate + "' ";
RecordSet.executeSql(sql);
response.sendRedirect("ReportDetailStatus.jsp?inprepid="+inprepid);
}
else if(operation.equals("reject")){
String sql ="select requestid from "+thetable+"_main where reportdate = '" + thedate +"' and crmid =" + crmid ;
RecordSet.executeSql(sql);
if(RecordSet.next()){
ArrayList requestids=new ArrayList();
requestids.add(RecordSet.getString(1));
WfForceDrawBack.ForceDrawBackToCreater(requestids,request,response,user.getUID(),(user.getLogintype().equals("1")) ? 0 : 1);
}
sql = " update " + thetable + " set inputstatus='9' where reportdate = '" + thedate +"' and crmid =" + crmid ;
RecordSet.executeSql(sql);
sql = " update " + thetable + "_main set inputstatus='9' where reportdate = '" + thedate +"' and crmid =" + crmid ;
RecordSet.executeSql(sql);
SysMaintenanceLog.resetParameter();
SysMaintenanceLog.setRelatedId(Util.getIntValue(inprepid));
SysMaintenanceLog.setRelatedName(inprepname+":"+CustomerInfoComInfo.getCustomerInfoname(crmid)+" "+dspdate);
SysMaintenanceLog.setOperateType("9");
SysMaintenanceLog.setOperateDesc("");
SysMaintenanceLog.setOperateItem("98");
SysMaintenanceLog.setOperateUserid(user.getUID());
SysMaintenanceLog.setClientAddress(request.getRemoteAddr());
SysMaintenanceLog.setSysLogInfo();
response.sendRedirect("ReportDetailStatus.jsp?inprepid="+inprepid);
}
%>