@RequestMapping("QryAuthDtlDtl")
public String queryAuthDtlDtl(Model model, FTZ210205Form form) {
FtzInMsgCtl query_FtzInMsgCtl = new FtzInMsgCtl();
query_FtzInMsgCtl.setMsgId(form.getSelected_msgId());
FtzInMsgCtl result_FtzInMsgCtl = ftz210205Serv.queryFtzInMsgCtl(query_FtzInMsgCtl);
form.setFather_makTime(result_FtzInMsgCtl.getMakDatetime());
form.setFather_chkTime(result_FtzInMsgCtl.getChkDatetime());
model.addAttribute("fatherStatus", result_FtzInMsgCtl.getMsgStatus());
FtzInTxnDtl query_FtzInTxnDtl = new FtzInTxnDtl();
query_FtzInTxnDtl.setMsgId(form.getSelected_msgId());
query_FtzInTxnDtl.setSeqNo(form.getSelected_seqNo());
FtzInTxnDtl result_FtzInTxnDtl = ftz210205Serv.queryFtzInTxnDtl(query_FtzInTxnDtl);
if (null == result_FtzInTxnDtl) {
model.addAttribute(ResultMessages.info().add("w.sm.0001"));
return "ftzmis/FTZ210205_Auth_Qry_Dtl";
}
result_FtzInTxnDtl.setTranDate(
DateUtil.getFormatDateAddSprit(result_FtzInTxnDtl.getTranDate()));
result_FtzInTxnDtl.setOrgTranDate(
DateUtil.getFormatDateAddSprit(result_FtzInTxnDtl.getOrgTranDate()));
result_FtzInTxnDtl.setExpireDate(
DateUtil.getFormatDateAddSprit(result_FtzInTxnDtl.getExpireDate()));
result_FtzInTxnDtl.setMakDatetime(
DateUtil.getFormatDateTimeAddSpritAndColon(result_FtzInTxnDtl.getMakDatetime()));
result_FtzInTxnDtl.setChkDatetime(
DateUtil.getFormatDateTimeAddSpritAndColon(result_FtzInTxnDtl.getChkDatetime()));
if (null != result_FtzInTxnDtl.getOppBankCode()
|| !"".equals(result_FtzInTxnDtl.getOppBankCode())) {
FtzBankCode query_FtzBankCode = new FtzBankCode();
query_FtzBankCode.setBankCode(result_FtzInTxnDtl.getOppBankCode());
FtzBankCode result_FtzBankCode = ftz210205Serv.queryFtzBankCode(query_FtzBankCode);
if (null != result_FtzBankCode) {
result_FtzInTxnDtl.setOppBankName(result_FtzBankCode.getBankName());
}
}
form.setFtzInTxnDtl(result_FtzInTxnDtl);
return "ftzmis/FTZ210205_Auth_Qry_Dtl_Dtl";
}
@RequestMapping("UptDtlDtlInit")
public String UptDtlDtlInit(Model model, FTZ210205Form form) {
FtzInMsgCtl query_FtzInMsgCtl = new FtzInMsgCtl();
query_FtzInMsgCtl.setMsgId(form.getSelected_msgId());
FtzInMsgCtl result_FtzInMsgCtl = ftz210205Serv.queryFtzInMsgCtl(query_FtzInMsgCtl);
form.setFather_makTime(result_FtzInMsgCtl.getMakDatetime());
form.setFather_chkTime(result_FtzInMsgCtl.getChkDatetime());
FtzInTxnDtl query_FtzInTxnDtl = new FtzInTxnDtl();
query_FtzInTxnDtl.setMsgId(form.getSelected_msgId());
query_FtzInTxnDtl.setSeqNo(form.getSelected_seqNo());
FtzInTxnDtl result_FtzInTxnDtl = ftz210205Serv.queryFtzInTxnDtl(query_FtzInTxnDtl);
result_FtzInTxnDtl.setTranDate(
DateUtil.getFormatDateAddSprit(result_FtzInTxnDtl.getTranDate()));
result_FtzInTxnDtl.setOrgTranDate(
DateUtil.getFormatDateAddSprit(result_FtzInTxnDtl.getOrgTranDate()));
result_FtzInTxnDtl.setExpireDate(
DateUtil.getFormatDateAddSprit(result_FtzInTxnDtl.getExpireDate()));
result_FtzInTxnDtl.setMakDatetime(
DateUtil.getFormatDateTimeAddSpritAndColon(result_FtzInTxnDtl.getMakDatetime()));
result_FtzInTxnDtl.setChkDatetime(
DateUtil.getFormatDateTimeAddSpritAndColon(result_FtzInTxnDtl.getChkDatetime()));
if (null != result_FtzInTxnDtl.getOppBankCode()
|| !"".equals(result_FtzInTxnDtl.getOppBankCode())) {
FtzBankCode query_FtzBankCode = new FtzBankCode();
query_FtzBankCode.setBankCode(result_FtzInTxnDtl.getOppBankCode());
FtzBankCode result_FtzBankCode = ftz210205Serv.queryFtzBankCode(query_FtzBankCode);
if (null != result_FtzBankCode) {
result_FtzInTxnDtl.setOppBankName(result_FtzBankCode.getBankName());
}
}
form.setFtzInTxnDtl(result_FtzInTxnDtl);
form.setInput_Dtl_flag("upt");
return "ftzmis/FTZ210205_Input_Dtl_Dtl";
}
@RequestMapping("AuthDtlSubmit")
public String AuthDtlSubmit(Model model, FTZ210205Form form) {
FtzInMsgCtl query_FtzInMsgCtl = new FtzInMsgCtl();
query_FtzInMsgCtl.setMsgId(form.getSelected_msgId());
FtzInMsgCtl result_FtzInMsgCtl = ftz210205Serv.queryFtzInMsgCtl(query_FtzInMsgCtl);
if (CommonConst.FTZ_MSG_STATUS_INPUTING.equals(result_FtzInMsgCtl.getMsgStatus())) {
model.addAttribute(ResultMessages.error().add("e.ftzmis.210101.0032"));
return "forward:/FTZ210205/QryAuthDtl";
}
UserInf userInfo = ContextConst.getCurrentUser();
if (userInfo.getUserid().equals(result_FtzInMsgCtl.getMakUserId())) {
model.addAttribute(ResultMessages.error().add("e.ftzmis.210101.0025"));
return "forward:/FTZ210205/QryAuthDtl";
}
FtzInTxnDtl query_FtzInTxnDtl = new FtzInTxnDtl();
query_FtzInTxnDtl.setMsgId(form.getSelected_msgId());
List<FtzInTxnDtl> ftzInTxnDtls = ftz210205Serv.queryFtzInTxnDtlList(query_FtzInTxnDtl);
if (null == ftzInTxnDtls || ftzInTxnDtls.size() < 1) {
FtzInMsgCtl update_FtzInMsgCtl = new FtzInMsgCtl();
update_FtzInMsgCtl.setMsgId(form.getFtzInMsgCtl().getMsgId());
update_FtzInMsgCtl.setMsgNo(CommonConst.MSG_NO_210205);
update_FtzInMsgCtl.setMsgStatus(CommonConst.FTZ_MSG_STATUS_AUTH_SUCC);
update_FtzInMsgCtl.setChkUserId(userInfo.getUserid());
update_FtzInMsgCtl.setRsv1(
DateUtil.getFormatDateTimeRemoveSpritAndColon(form.getFtzInMsgCtl().getMakDatetime()));
update_FtzInMsgCtl.setRsv2(
DateUtil.getFormatDateTimeRemoveSpritAndColon(form.getFtzInMsgCtl().getChkDatetime()));
update_FtzInMsgCtl.setChkDatetime(DateUtil.getNowInputDateTime());
int i = ftz210205Serv.updateFtzInMsgCtl(update_FtzInMsgCtl, null);
if (i < 1) {
model.addAttribute(ResultMessages.error().add("e.ftzmis.2103.0008"));
} else {
model.addAttribute(ResultMessages.success().add("i.ftzmis.210301.0005"));
form.setAuthFinishFlag("1");
return "forward:/FTZ210205/QryAuthDtl";
}
} else {
int count_unAuth = 0;
int count_authFail = 0;
StringBuffer sb_unAuth = new StringBuffer();
StringBuffer sb_authFail = new StringBuffer();
for (FtzInTxnDtl ftzInTxnDtl : ftzInTxnDtls) {
String chkStatus = ftzInTxnDtl.getChkStatus();
if (chkStatus.equals(CommonConst.FTZ_MSG_STATUS_INPUT_COMPLETED)) {
count_unAuth++;
sb_unAuth.append(ftzInTxnDtl.getSeqNo().toString() + ",");
}
if (chkStatus.equals(CommonConst.FTZ_MSG_STATUS_AUTH_FAIL)) {
count_authFail++;
sb_authFail.append(ftzInTxnDtl.getSeqNo().toString() + ",");
}
}
if (count_unAuth > 0) {
model.addAttribute(ResultMessages.error().add("e.ftzmis.210310.0012"));
return "forward:/FTZ210205/QryAuthDtl";
}
if (count_authFail > 0) {
model.addAttribute(
ResultMessages.error()
.add("e.ftzmis.210101.0031", sb_unAuth.subSequence(0, sb_authFail.length() - 1)));
return "forward:/FTZ210205/QryAuthDtl";
}
FtzInMsgCtl update_FtzInMsgCtl = new FtzInMsgCtl();
update_FtzInMsgCtl.setMsgStatus(CommonConst.FTZ_MSG_STATUS_AUTH_SUCC);
if (form.getFtzInMsgCtl().getMsgId() != null
&& !"".equals(form.getFtzInMsgCtl().getMsgId())) {
update_FtzInMsgCtl.setMsgId(form.getFtzInMsgCtl().getMsgId());
} else {
update_FtzInMsgCtl.setMsgId(form.getSelected_msgId());
}
update_FtzInMsgCtl.setMsgNo(CommonConst.MSG_NO_210205);
update_FtzInMsgCtl.setChkUserId(userInfo.getUserid());
update_FtzInMsgCtl.setRsv2(update_FtzInMsgCtl.getChkDatetime());
update_FtzInMsgCtl.setChkDatetime(DateUtil.getNowInputDateTime());
update_FtzInMsgCtl.setChkDatetime(DateUtil.getNowInputDateTime());
int i = ftz210205Serv.updateFtzInMsgCtl(update_FtzInMsgCtl, null);
if (i < 1) {
model.addAttribute(ResultMessages.error().add("e.ftzmis.210301.0008"));
} else {
model.addAttribute(ResultMessages.success().add("i.ftzmis.210301.0005"));
form.setAuthFinishFlag("1");
return "forward:/FTZ210205/QryAuthDtl";
}
}
return "forward:/FTZ210205/QryAuthDtl";
}
// 修改之后点击保存
@RequestMapping("UptDtlSubmit")
public String UptDtlSubmit(
Model model, FTZ210205Form form, BindingResult result, @PageableDefaults Pageable pageable) {
FtzInMsgCtl update_FtzInMsgCtl = form.getFtzInMsgCtl();
// 开始校验
ResultMessages resultMessages = ResultMessages.error();
// 申请日期
if (null == update_FtzInMsgCtl.getSubmitDate()
|| "".equals(update_FtzInMsgCtl.getSubmitDate().trim())) {
ResultMessage resultMessage = ResultMessage.fromCode("e.ftzmis.210101.0012");
resultMessages.add(resultMessage);
}
// 主账号
if (null == update_FtzInMsgCtl.getAccountNo()
|| "".equals(update_FtzInMsgCtl.getAccountNo().trim())) {
ResultMessage resultMessage = ResultMessage.fromCode("e.ftzmis.210101.0033");
resultMessages.add(resultMessage);
}
// 资产负债指标代码
if (null == update_FtzInMsgCtl.getBalanceCode()
|| "".equals(update_FtzInMsgCtl.getBalanceCode().trim())) {
ResultMessage resultMessage = ResultMessage.fromCode("e.ftzmis.210101.0007");
resultMessages.add(resultMessage);
}
// 货币
if (null == update_FtzInMsgCtl.getCurrency()
|| "".equals(update_FtzInMsgCtl.getCurrency().trim())) {
ResultMessage resultMessage = ResultMessage.fromCode("e.ftzmis.210101.0009");
resultMessages.add(resultMessage);
}
// 日终余额
if (null == update_FtzInMsgCtl.getBalance()) {
ResultMessage resultMessage = ResultMessage.fromCode("e.ftzmis.210101.0010");
resultMessages.add(resultMessage);
} else {
if (!Validator.CheckAmount(update_FtzInMsgCtl.getBalance())) {
ResultMessage resultMessage = ResultMessage.fromCode("e.ftzmis.210303.0013");
resultMessages.add(resultMessage);
}
}
// 开户机构代码
if (null == update_FtzInMsgCtl.getAccOrgCode()
|| "".equals(update_FtzInMsgCtl.getAccOrgCode().trim())) {
ResultMessage resultMessage = ResultMessage.fromCode("e.ftzmis.210106.0003");
resultMessages.add(resultMessage);
}
if (resultMessages.isNotEmpty()) {
model.addAttribute(resultMessages);
// 清空页面列表选择Key
form.setSelected_msgId("");
form.setSelected_seqNo(null);
model.addAttribute("pageUrl", "/FTZ210205/UptDtlInit");
return "ftzmis/FTZ210205_Input_Dtl";
}
UserInf userInfo = ContextConst.getCurrentUser();
update_FtzInMsgCtl.setMsgStatus(CommonConst.FTZ_MSG_STATUS_INPUTING);
update_FtzInMsgCtl.setMakUserId(userInfo.getUserid());
update_FtzInMsgCtl.setRsv1(
DateUtil.getFormatDateTimeRemoveSpritAndColon(update_FtzInMsgCtl.getMakDatetime()));
update_FtzInMsgCtl.setRsv2(
DateUtil.getFormatDateTimeRemoveSpritAndColon(update_FtzInMsgCtl.getChkDatetime()));
update_FtzInMsgCtl.setMakDatetime(DateUtil.getNowInputDateTime());
update_FtzInMsgCtl.setSubmitDate(
DateUtil.getFormatDateRemoveSprit(update_FtzInMsgCtl.getSubmitDate()));
int i = ftz210205Serv.updateFtzInMsgCtl(update_FtzInMsgCtl, null);
if (i < 1) {
model.addAttribute(ResultMessages.error().add("e.sysrunner.0003"));
form.setFtzInMsgCtl(ftz210205Serv.queryFtzInMsgCtl(update_FtzInMsgCtl));
form.getFtzInMsgCtl()
.setSubmitDate(DateUtil.getFormatDateAddSprit(form.getFtzInMsgCtl().getSubmitDate()));
FtzInTxnDtl query_FtzInTxnDtl = new FtzInTxnDtl();
query_FtzInTxnDtl.setMsgId(update_FtzInMsgCtl.getMsgId());
// 查询明细数据列表
Page<FtzInTxnDtl> page = ftz210205Serv.queryFtzInTxnDtlPage(pageable, query_FtzInTxnDtl);
if (page.getContent().size() > 0) {
List<FtzInTxnDtl> ftzInTxnDtls = page.getContent();
for (FtzInTxnDtl ftzInTxnDtl : ftzInTxnDtls) {
ftzInTxnDtl.setTranDate(DateUtil.getFormatDateAddSprit(ftzInTxnDtl.getTranDate()));
}
model.addAttribute("page", page);
}
// 清空页面列表选择Key
form.setSelected_msgId("");
form.setSelected_seqNo(null);
model.addAttribute("pageUrl", "/FTZ210205/UptDtlInit");
return "ftzmis/FTZ210205_Input_Dtl";
} else {
model.addAttribute(ResultMessages.success().add("ftzmis.Update.Msg.Ctl.Success"));
}
form.getFtzInMsgCtl()
.setSubmitDate(DateUtil.getFormatDateAddSprit(form.getFtzInMsgCtl().getSubmitDate()));
form.setSelected_msgId("");
FtzInTxnDtl query_FtzInTxnDtl = new FtzInTxnDtl();
query_FtzInTxnDtl.setMsgId(form.getFtzInMsgCtl().getMsgId());
// 查询明细数据列表
Page<FtzInTxnDtl> page = ftz210205Serv.queryFtzInTxnDtlPage(pageable, query_FtzInTxnDtl);
if (page.getContent().size() > 0) {
List<FtzInTxnDtl> ftzInTxnDtls = page.getContent();
for (FtzInTxnDtl ftzInTxnDtl : ftzInTxnDtls) {
ftzInTxnDtl.setTranDate(DateUtil.getFormatDateAddSprit(ftzInTxnDtl.getTranDate()));
}
model.addAttribute("page", page);
}
// 清空页面列表选择Key
form.setSelected_msgId("");
form.setSelected_seqNo(null);
model.addAttribute("pageUrl", "/FTZ210205/UptDtlInit");
return "ftzmis/FTZ210205_Input_Dtl";
}