FnaShareifoverJsonAjax.jsp
9.08 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
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
<%@page import="weaver.fna.budget.BudgetPeriod"%>
<%@page import="weaver.fna.maintenance.FnaYearsPeriodsListComInfo"%>
<%@page import="java.text.DecimalFormat"%>
<%@page import="weaver.file.FileUpload"%>
<%@page import="weaver.systeminfo.SystemEnv"%>
<%@page import="org.json.JSONObject"%>
<%@page import="weaver.hrm.User"%>
<%@page import="weaver.hrm.HrmUserVarify"%>
<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<%@ page import="weaver.general.*,weaver.conn.*,java.util.*" %>
<jsp:useBean id="rs" class="weaver.conn.RecordSet" scope="page" />
<jsp:useBean id="FnaBudgetControl" class="weaver.fna.maintenance.FnaBudgetControl" scope="page" />
<%
User user = HrmUserVarify.getUser (request , response) ;
if(user==null){
response.sendRedirect("/notice/noright.jsp") ;
return ;
}
String poststr = Util.null2String(request.getParameter("poststr")).trim();//科目+报销类型+报销单位+报销日期+实报金额
int requestid = Util.getIntValue(request.getParameter("requestid"),0);//流程id
int workflowid = Util.getIntValue(request.getParameter("workflowid"),0);//流程id
int isMobile = Util.getIntValue(request.getParameter("isMobile"),0);
String returnStr = "";
try{
DecimalFormat df = new DecimalFormat("#################################################0.00");
int fnaFeeWfInfoId = 0;
String sql = "select * from fnaFeeWfInfo where workflowid = "+workflowid;
rs.executeSql(sql);
if(rs.next()){
fnaFeeWfInfoId = rs.getInt("id");
int fnaWfTypeColl = rs.getInt("fnaWfTypeColl");
int fnaWfTypeReverse = rs.getInt("fnaWfTypeReverse");
}
StringBuffer poststrNew = new StringBuffer("");
if("".equals(returnStr) && !"".equals(poststr)){
FnaYearsPeriodsListComInfo fnaYearsPeriodsListComInfo = new FnaYearsPeriodsListComInfo();
String fieldIdSubject = "";
String fieldIdOrgType = "";
String fieldIdOrgId = "";
String fieldIdOccurdate = "";
String fieldIdAmount = "";
String fieldIdHrmInfo = "";
String fieldIdDepInfo = "";
String fieldIdSubInfo = "";
String fieldIdFccInfo = "";
String fieldIdSubject2 = "";
String fieldIdOrgType2 = "";
String fieldIdOrgId2 = "";
String fieldIdOccurdate2 = "";
String fieldIdHrmInfo2 = "";
String fieldIdDepInfo2 = "";
String fieldIdSubInfo2 = "";
String fieldIdFccInfo2 = "";
sql = "select * from fnaFeeWfInfoField where workflowid = "+workflowid;
rs.executeSql(sql);
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)==1){
if(Util.getIntValue(fieldType)==1){
fieldIdSubject = fieldId;
}else if(Util.getIntValue(fieldType)==2){
fieldIdOrgType = fieldId;
}else if(Util.getIntValue(fieldType)==3){
fieldIdOrgId = fieldId;
}else if(Util.getIntValue(fieldType)==4){
fieldIdOccurdate = fieldId;
}else if(Util.getIntValue(fieldType)==5){
fieldIdAmount = fieldId;
}else if(Util.getIntValue(fieldType)==6){
fieldIdHrmInfo = fieldId;
}else if(Util.getIntValue(fieldType)==7){
fieldIdDepInfo = fieldId;
}else if(Util.getIntValue(fieldType)==8){
fieldIdSubInfo = fieldId;
}else if(Util.getIntValue(fieldType)==9){
fieldIdFccInfo = fieldId;
}
else if(Util.getIntValue(fieldType)==10){
fieldIdSubject2 = fieldId;
}else if(Util.getIntValue(fieldType)==11){
fieldIdOrgType2 = fieldId;
}else if(Util.getIntValue(fieldType)==12){
fieldIdOrgId2 = fieldId;
}else if(Util.getIntValue(fieldType)==13){
fieldIdOccurdate2 = fieldId;
}else if(Util.getIntValue(fieldType)==14){
fieldIdHrmInfo2 = fieldId;
}else if(Util.getIntValue(fieldType)==15){
fieldIdDepInfo2 = fieldId;
}else if(Util.getIntValue(fieldType)==16){
fieldIdSubInfo2 = fieldId;
}else if(Util.getIntValue(fieldType)==17){
fieldIdFccInfo2 = fieldId;
}
}
}
boolean _isSet2field = false;
if(Util.getIntValue(fieldIdSubject2) <= 0){
fieldIdSubject2 = fieldIdSubject;
}else{
_isSet2field = true;
}
if(Util.getIntValue(fieldIdOrgType2) <= 0){
fieldIdOrgType2 = fieldIdOrgType;
}else{
_isSet2field = true;
}
if(Util.getIntValue(fieldIdOrgId2) <= 0){
fieldIdOrgId2 = fieldIdOrgId;
}else{
_isSet2field = true;
}
if(Util.getIntValue(fieldIdOccurdate2) <= 0){
fieldIdOccurdate2 = fieldIdOccurdate;
}else{
_isSet2field = true;
}
if(Util.getIntValue(fieldIdHrmInfo2) <= 0){
fieldIdHrmInfo2 = fieldIdHrmInfo;
}
if(Util.getIntValue(fieldIdDepInfo2) <= 0){
fieldIdDepInfo2 = fieldIdDepInfo;
}
if(Util.getIntValue(fieldIdSubInfo2) <= 0){
fieldIdSubInfo2 = fieldIdSubInfo;
}
if(Util.getIntValue(fieldIdFccInfo2) <= 0){
fieldIdFccInfo2 = fieldIdFccInfo;
}
String[] fnainfo = poststr.split("\\|");
int rowsum = fnainfo.length;
for(int i=0;i<rowsum;i++) {
//调整科目+调整报销类型+调整报销单位+调整报销日期+调整金额+调出科目+调出报销类型+调出报销单位+调出报销日期
//poststr += budgetfeetype+","+orgtype+","+orgid+","+applydate+","+applyamount+","+
//budgetfeetype2+","+orgtype2+","+orgid2+","+applydate2+",postStrEnd";
String[] tempStr = fnainfo[i].split(",");
//调整科目
String subject = "";
if(tempStr.length >= 1){
subject = Util.null2String(tempStr[0]);
}
//调整报销类型 个人部门分部 012-》321
int organizationtype = -1;
if(tempStr.length >= 2){
organizationtype = Util.getIntValue(tempStr[1],-1);
}
//调整报销单位
int organizationid = 0;
if(tempStr.length >= 3){
organizationid = Util.getIntValue(tempStr[2],0);
}
//调整报销日期
String budgetperiod = "";
if(tempStr.length >= 4){
budgetperiod = Util.null2String(tempStr[3]);
}
//调整金额
double applyamount= 0.00;
if(tempStr.length >= 5){
applyamount= Util.getDoubleValue(tempStr[4],0);
}
//调出科目
String subject2 = "";
if(tempStr.length >= 6){
subject2 = Util.null2String(tempStr[5]);
}
//调出报销类型 个人部门分部 012-》321
int organizationtype2 = -1;
if(tempStr.length >= 7){
organizationtype2 = Util.getIntValue(tempStr[6],-1);
}
//调出报销单位
int organizationid2 = 0;
if(tempStr.length >= 8){
organizationid2 = Util.getIntValue(tempStr[7],0);
}
//调出报销日期
String budgetperiod2 = "";
if(tempStr.length >= 9){
budgetperiod2 = Util.null2String(tempStr[8]);
}
if(fieldIdSubject.equals(fieldIdSubject2)){
subject2 = subject;
}
if(fieldIdOrgType.equals(fieldIdOrgType2)){
organizationtype2 = organizationtype;
}
if(fieldIdOrgId.equals(fieldIdOrgId2)){
organizationid2 = organizationid;
}
if(fieldIdOccurdate.equals(fieldIdOccurdate2)){
budgetperiod2 = budgetperiod;
}
if(_isSet2field){
try{
BudgetPeriod bp1 = fnaYearsPeriodsListComInfo.getBudgetPeriod(budgetperiod, Util.getIntValue(subject));
BudgetPeriod bp2 = fnaYearsPeriodsListComInfo.getBudgetPeriod(budgetperiod2, Util.getIntValue(subject2));
if(subject.equals(subject2) && organizationtype == organizationtype2 && organizationid == organizationid2 && bp1.getPeriod() == bp2.getPeriod() && bp1.getPeriodlist() == bp2.getPeriodlist()){
continue;
}
}catch(Exception ex001){}
}
//总是处理调出费用承担主体:如果调整金额<0,则拼装字符串进行费控校验
if(applyamount < 0.00){
if(poststrNew.length() > 0){
poststrNew.append("|");
}
//调整科目+调整报销类型+调整报销单位+调整报销日期+调整金额
poststrNew.append(subject+","+organizationtype+","+organizationid+","+budgetperiod+","+df.format(applyamount * -1.00)+",postStrEnd");
}
if(fieldIdSubject.equals(fieldIdSubject2) && fieldIdOrgType.equals(fieldIdOrgType2) && fieldIdOrgId.equals(fieldIdOrgId2) && fieldIdOccurdate.equals(fieldIdOccurdate2)){
}else{
//如果调入费用承担主体存在则:如果调整金额>0,则拼装字符串进行费控校验(注:调整金额拼装入校验字符串时必须转换成正数)
if(applyamount > 0.00){
if(poststrNew.length() > 0){
poststrNew.append("|");
}
//调整科目+调整报销类型+调整报销单位+调整报销日期+调整金额
poststrNew.append(subject2+","+organizationtype2+","+organizationid2+","+budgetperiod2+","+df.format(applyamount)+",postStrEnd");
}
}
}
if(poststrNew.length() > 0){
FnaBudgetControl.setFromActionType("FnaShareifoverJsonAjax");
returnStr = FnaBudgetControl.checkBudgetListForFnaifoverJsonAjax(poststrNew.toString(), workflowid, requestid, user, false);
}
}
if("".equals(returnStr)){
returnStr = "{\"flag\":true,\"errorInfo\":"+JSONObject.quote("")+"}";
}
}catch(Exception ex1){
new BaseBean().writeLog(ex1);
returnStr = "{\"flag\":false,\"errorInfo\":"+JSONObject.quote(ex1.getMessage())+"}";
}
//new BaseBean().writeLog("returnStr>>>>>>>>>>"+returnStr);
%>
<%=returnStr%>