getBorrowRequestInfo.jsp
5.03 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
<%@page import="weaver.general.BaseBean"%>
<%@page import="weaver.fna.general.FnaCommon"%>
<%@page import="java.text.DecimalFormat"%>
<%@page import="java.util.HashMap"%>
<%@page import="weaver.fna.maintenance.FnaBorrowAmountControl"%>
<%@page import="org.json.JSONObject"%>
<%@page import="weaver.hrm.HrmUserVarify"%>
<%@page import="weaver.hrm.User"%>
<%@page import="weaver.systeminfo.SystemEnv"%>
<%@page import="weaver.conn.RecordSet"%>
<%@page import="weaver.general.Util"%>
<%@page import="weaver.workflow.field.BrowserComInfo"%>
<jsp:useBean id="rs" class="weaver.conn.RecordSet" scope="page" />
<jsp:useBean id="fnaBudgetControl" class="weaver.fna.maintenance.FnaBudgetControl" scope="page" />
<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<%
DecimalFormat df = new DecimalFormat("#################################################0.00");
StringBuffer result = new StringBuffer();
User user = HrmUserVarify.getUser (request , response) ;
if(user == null){
result.append("{\"flag\":false,\"errorInfo\":\"error！\"}");
}else{
String _____guid1 = Util.null2String(request.getParameter("_____guid1")).trim();
int jklc = Util.getIntValue(request.getParameter("jklc"), -1);
int dnxh = Util.getIntValue(request.getParameter("dnxh"), -1);
int requestid = Util.getIntValue(request.getParameter("requestid"));
boolean _flag = true;//_____guid1.equals(Util.null2String(request.getSession().getAttribute("FnaSubmitRequestJsBorrow.jsp_____"+_____guid1+"_____"+user.getUID())).trim());
String jklc_requestmark = "";
String jklc_dnxhShowName = "";
//借款金额：jkje；已还金额:yhje；审批中待还款金额：spzje；未还金额：whje；
String jkje = "";
String yhje = "";
String spzje = "";
String whje = "";
boolean flag = true;
if(jklc > 0 && _flag){
if(requestid > 0 ){
//查询当前操作人是否在此还款流程中
int userid = user.getUID();
String sql1 = "select * from workflow_currentoperator a where a.userid ="+userid+" and a.requestid ="+requestid;
rs.executeSql(sql1);
if(rs.getCounts()==0){
flag = false;
}else{
//查询当前操作人是否在借款流程中
String sql2 = "select * from workflow_currentoperator a where a.userid ="+userid+" and a.requestid ="+jklc;
rs.executeSql(sql2);
if(rs.getCounts()==0){
String sql3 = "select workflowid from workflow_requestbase where requestid = "+requestid;
rs.executeSql(sql3);
int workflowid = 0;
while(rs.next()){
workflowid = rs.getInt("workflowid");
}
String dt1_field_id = "";
String dt1_field = "";
String sqlN = "select * from fnaFeeWfInfoField where workflowid="+workflowid;
rs.executeSql(sqlN);
while(rs.next()){
String fieldType = Util.null2String(rs.getString("fieldType"));
String fieldId = Util.null2String(rs.getString("fieldId"));
String dtlNumber = Util.null2String(rs.getString("dtlNumber"));
if(Util.getIntValue(dtlNumber)==2 && Util.getIntValue(fieldType)==1){
dt1_field_id = fieldId;
}
}
String sqlM = "select fieldname from workflow_billfield where id="+dt1_field_id;
rs.executeSql(sqlM);
while(rs.next()){
dt1_field = rs.getString("fieldname");
}
String sql4 = "select b.formid from workflow_requestbase a join workflow_base b on a.workflowid = b.id "+
" where a.requestid="+requestid;
rs.executeSql(sql4);
int formid = 0;
while(rs.next()){
formid = rs.getInt("formid");
}
formid = Math.abs(formid);
String tableName = "formtable_main_"+formid;
String tableNameDetail = "formtable_main_"+formid+"_dt2";
String sql5 = "select * from "+tableName+" a join "+tableNameDetail+" b on a.id = b.mainid where b."+dt1_field+"="+jklc+" and a.requestid="+requestid;
rs.executeSql(sql5);
if(rs.getCounts() == 0){
flag = false;
}
}
}
}
if(flag){
if(dnxh > 0){
String sql3 = "select requestmark from workflow_requestbase where requestid = "+jklc;
rs.executeSql(sql3);
if(rs.next()){
jklc_requestmark = Util.null2String(rs.getString("requestmark"));
}
FnaBorrowAmountControl fnaBorrowAmountControl = new FnaBorrowAmountControl();
HashMap<String, String> borrowInfoHm = fnaBorrowAmountControl.getBorrowInfo(jklc, dnxh, 0);
jkje = Util.null2String(borrowInfoHm.get("jkje"));
yhje = Util.null2String(borrowInfoHm.get("yhje"));
spzje = Util.null2String(borrowInfoHm.get("spzje"));
whje = Util.null2String(borrowInfoHm.get("whje"));
jklc_dnxhShowName = FnaCommon.getRequestBorrowDnxhShowName(jklc, dnxh);
}
}
}
if(flag){
result.append("{\"flag\":true,\"errorInfo\":"+JSONObject.quote("")+
",\"requestmark\":"+JSONObject.quote(jklc_requestmark)+
",\"jkje\":"+JSONObject.quote(jkje)+
",\"yhje\":"+JSONObject.quote(yhje)+
",\"spzje\":"+JSONObject.quote(spzje)+
",\"whje\":"+JSONObject.quote(whje)+
",\"dnxhShowName\":"+JSONObject.quote(jklc_dnxhShowName)+
"}");
}else{
result.append("{\"flag\":false,\"errorInfo\":\"当前操作人无权限！\"}");
}
}
%><%=result.toString() %>