@RequestMapping("AddQry")
public String queryAdd(Model model, FTZ210205Form form, @PageableDefaults Pageable pageable) {
logger.info("买入返售资产录入查询开始...");
// trans form to queryObject
FtzInMsgCtl query_FtzInMsgCtl = new FtzInMsgCtl();
query_FtzInMsgCtl.setMsgId(form.getQuery_msgId());
query_FtzInMsgCtl.setBranchId(form.getQuery_branchId().trim());
query_FtzInMsgCtl.setAccountName(form.getQuery_accountName());
query_FtzInMsgCtl.setAccountNo(form.getQuery_accountNo());
query_FtzInMsgCtl.setSubAccountNo(form.getQuery_subAccountNo());
query_FtzInMsgCtl.setRsv1(DateUtil.getFormatDateRemoveSprit(form.getQuery_submitDate_start()));
query_FtzInMsgCtl.setRsv2(DateUtil.getFormatDateRemoveSprit(form.getQuery_submitDate_end()));
query_FtzInMsgCtl.setMsgStatus(form.getQuery_msgStatus());
query_FtzInMsgCtl.setMsgStatuss(CommonConst.FTZ_MSG_STATUS_INPUT_STATUS);
query_FtzInMsgCtl.setMsgNo(CommonConst.MSG_NO_210205);
// query DpMppCfg page list
Page<FtzInMsgCtl> page = ftz210205Serv.queryFtzInMsgCtlPage(pageable, query_FtzInMsgCtl);
if (page.getContent().size() > 0) {
List<FtzInMsgCtl> ftzInMsgCtls = page.getContent();
for (FtzInMsgCtl ftzInMsgCtl : ftzInMsgCtls) {
ftzInMsgCtl.setSubmitDate(DateUtil.getFormatDateAddSprit(ftzInMsgCtl.getSubmitDate()));
}
model.addAttribute("page", page);
form.setSelected_msgId("");
form.setSelected_seqNo(null);
} else {
model.addAttribute(ResultMessages.info().add("w.sm.0001"));
logger.info("买入返售资产录入查询结束...");
return "ftzmis/FTZ210205_Input_Qry";
}
logger.info("买入返售资产录入查询结束...");
return "ftzmis/FTZ210205_Input_Qry";
}
@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("AddDtlSubmit")
public String AddDtlSubmit(Model model, FTZ210205Form form, BindingResult result) {
logger.info("买入返售资产录入批量录入开始...");
// 获取录入信息
FtzInMsgCtl insert_FtzInMsgCtl = form.getFtzInMsgCtl();
// 开始校验
ResultMessages resultMessages = ResultMessages.error();
// 申请日期
if (null == insert_FtzInMsgCtl.getSubmitDate()
|| "".equals(insert_FtzInMsgCtl.getSubmitDate().trim())) {
ResultMessage resultMessage = ResultMessage.fromCode("e.ftzmis.210101.0012");
resultMessages.add(resultMessage);
}
// 主账号
if (null == insert_FtzInMsgCtl.getAccountNo()
|| "".equals(insert_FtzInMsgCtl.getAccountNo().trim())) {
ResultMessage resultMessage = ResultMessage.fromCode("e.ftzmis.210101.0033");
resultMessages.add(resultMessage);
}
// 资产负债指标代码
if (null == insert_FtzInMsgCtl.getBalanceCode()
|| "".equals(insert_FtzInMsgCtl.getBalanceCode().trim())) {
ResultMessage resultMessage = ResultMessage.fromCode("e.ftzmis.210101.0007");
resultMessages.add(resultMessage);
}
// 货币
if (null == insert_FtzInMsgCtl.getCurrency()
|| "".equals(insert_FtzInMsgCtl.getCurrency().trim())) {
ResultMessage resultMessage = ResultMessage.fromCode("e.ftzmis.210101.0009");
resultMessages.add(resultMessage);
}
// 日终余额
if (null == insert_FtzInMsgCtl.getBalance()) {
ResultMessage resultMessage = ResultMessage.fromCode("e.ftzmis.210101.0010");
resultMessages.add(resultMessage);
} else {
if (!Validator.CheckAmount(insert_FtzInMsgCtl.getBalance())) {
ResultMessage resultMessage = ResultMessage.fromCode("e.ftzmis.210303.0013");
resultMessages.add(resultMessage);
}
}
// 开户机构代码
if (null == insert_FtzInMsgCtl.getAccOrgCode()
|| "".equals(insert_FtzInMsgCtl.getAccOrgCode().trim())) {
ResultMessage resultMessage = ResultMessage.fromCode("e.ftzmis.210303.0002");
resultMessages.add(resultMessage);
}
if (resultMessages.isNotEmpty()) {
model.addAttribute(resultMessages);
return "ftzmis/FTZ210205_Input_Dtl";
}
insert_FtzInMsgCtl.setMsgId(numberService.getSysIDSequence("", 8));
insert_FtzInMsgCtl.setSubmitDate(
DateUtil.getFormatDateRemoveSprit(insert_FtzInMsgCtl.getSubmitDate()));
insert_FtzInMsgCtl.setWorkDate(procCommonService.queryWorkDate());
UserInf userInfo = ContextConst.getCurrentUser();
insert_FtzInMsgCtl.setMakUserId(userInfo.getUserid());
insert_FtzInMsgCtl.setMakDatetime(DateUtil.getNowInputDateTime());
insert_FtzInMsgCtl.setTotalCount(0);
insert_FtzInMsgCtl.setMsgStatus(CommonConst.FTZ_MSG_STATUS_INPUTING);
insert_FtzInMsgCtl.setMsgNo(CommonConst.MSG_NO_210205);
// 插入信息
insert_FtzInMsgCtl.setBalanceCode(insert_FtzInMsgCtl.getBalanceCode().trim());
int i = ftz210205Serv.insertFtzInMsgCtl(insert_FtzInMsgCtl);
if (i < 1) {
model.addAttribute(ResultMessages.error().add("e.sysrunner.0006"));
} else {
model.addAttribute(ResultMessages.success().add("i.ftzmis.2101.0001"));
}
form.getFtzInMsgCtl()
.setSubmitDate(DateUtil.getFormatDateAddSprit(form.getFtzInMsgCtl().getSubmitDate()));
logger.info("买入返售资产录入批量录入结束...");
form.setInput_flag("upt");
model.addAttribute("pageUrl", "/FTZ210205/UptDtlInit");
return "ftzmis/FTZ210205_Input_Dtl";
}
// 修改之后点击保存
@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";
}