package cn.szqhyf.qhyffs.app.fs.ctl
import club.newepoch.ijfinal.http.paras.Parameter
import club.newepoch.ijfinal.kit.buildReturn
import club.newepoch.utils.JsonUtils
import cn.szqhyf.qhyffs.app.fs.iservice.BizAbsProfitInfoService
import cn.szqhyf.qhyffs.app.fs.pojo.po.AddOrRevisionIncomePoJo
import cn.szqhyf.qhyffs.app.fs.pojo.po.BizAbsProfitInfo
import cn.szqhyf.qhyffs.app.fs.pojo.po.ModificationFinancialPoJo
import com.jfinal.core.ActionKey
import com.jfinal.core.action.Rest
import com.jfinal.core.pojo.RestMethod
import com.jfinal.ext.render.Return
/**
*金融部ABS收益表Controller
*
*/
open class BizAbsProfitInfoController : QhyffsController() {
/**
* ABS收益表画面一览 (所属大期)的获得方法
*/
@Rest(method = RestMethod.GET)
@ActionKey(value = "/api/finance/biz/abs/profit/periods")
fun periods(): Return {
var r = this.initService<BizAbsProfitInfoService>().periods(iwebReq = getIwebRequest())
return this.buildReturn(data = r)
}
/**
* ABS收益表画面一览(带分页查询)
* @param coreEnterpriseId
* 核心企业
* @param financialInstitutionId
* 计划管理人ID
* @param periods
* 期数
* @param bigPeriodsId
* 所属大区ID
*/
@Rest(method = RestMethod.GET)
@ActionKey(value = "/api/finance/biz/abs/profit/info")
fun index( @Parameter("核心企业ID") coreEnterpriseId: String? =null,
@Parameter("计划管理人ID") financialInstitutionsId: String? =null,
@Parameter("期数") periods: String? =null,
@Parameter("所属大区") bigPeriodsId: String? =null): Return {
var r = this.initService<BizAbsProfitInfoService>().pages(iwebReq = getIwebRequest(),
pageInfo = this.pageInfo,coreEnterpriseId = coreEnterpriseId, financialInstitutionsId = financialInstitutionsId,
periods = periods , bigPeriodsId = bigPeriodsId)
return this.buildReturn(data = r)
}
/**
* 添加收益信息表画面 中 （查询按钮的实现）
* @param coreEnterpriseId
* 核心企业（不允许为空）
* @param financialInstitutionId
* 计划管理人ID（不允许为空）
* @param periodsId
* 期数id（不允许为空）
*/
@Rest(method = RestMethod.GET)
@ActionKey(value = "/api/finance/biz/abs/profit/subject/info")
fun getQuery( @Parameter("核心企业ID", optional = false) coreEnterpriseId: String,
@Parameter("计划管理人ID", optional = false) financialInstitutionsId: String,
@Parameter("期数", optional = false) periods: String )
: Return {
var r = this.initService<BizAbsProfitInfoService>().getQuery(iwebReq = getIwebRequest(),
coreEnterpriseId = coreEnterpriseId, financialInstitutionsId = financialInstitutionsId , periods =periods)
return this.buildReturn(data = r)
}
/**
* 添加收益信息表画面 中 （判断是否跳期的判断依准）
* @param coreEnterpriseId
* 核心企业（不允许为空）
* @param financialInstitutionId
* 计划管理人ID（不允许为空）
* @param periodsId
* 期数id（不允许为空）
*/
@Rest(method = RestMethod.GET)
@ActionKey(value = "/api/finance/biz/abs/profit/periods/check")
fun isjumpPeriods( @Parameter("核心企业ID") coreEnterpriseId: String,
@Parameter("计划管理人ID") financialInstitutionsId: String,
@Parameter("期数") periods: String )
: Return {
var r = this.initService<BizAbsProfitInfoService>().isjumpPeriods(iwebReq = getIwebRequest(),
coreEnterpriseId = coreEnterpriseId, financialInstitutionsId = financialInstitutionsId , periods =periods)
return this.buildReturn(data = r)
}
/**
* 添加收益信息表画面 中 （保存按钮的实现）
* @param coreEnterpriseId
* 核心企业（不允许为空）
* @param financialInstitutionId
* 计划管理人ID（不允许为空）
* @param periodsId
* 期数id（不允许为空）
* @param information
* 信息（费用名称，备注，金额）
* @param financeOpinion
* 意见
* @param releaseDate
* 发行日期
*/
@Rest(method = RestMethod.POST)
@ActionKey(value = "/api/finance/biz/abs/profit/save/subject/info")
fun saveWays( @Parameter("核心企业ID" ,optional = false) coreEnterpriseId: String,
@Parameter("计划管理人ID",optional = false) financialInstitutionsId: String,
@Parameter("期数",optional = false) periods: String,
@Parameter("费用金额备注", optional = false) subjectlist: MutableList<String> ,
@Parameter("意见",optional = false) financeOpinion: String? =null ,
@Parameter("发行日期",optional = false) releaseDate :String? =null
): Return {
val subjectlists:MutableList<AddOrRevisionIncomePoJo> = mutableListOf()
for (subject in subjectlist!!.listIterator() ){
// 解析字符窜转对象
var obj= JsonUtils.parseJson2T(subject,AddOrRevisionIncomePoJo::class.java)
subjectlists.add(obj)
}
var r = this.initService<BizAbsProfitInfoService>().saveWays(iwebReq = getIwebRequest(),
subjectlist = subjectlists, financeOpinion = financeOpinion ,releaseDate = releaseDate , coreEnterpriseId = coreEnterpriseId ,
financialInstitutionsId = financialInstitutionsId , periods = periods)
return this.buildReturn(data = r)
}
/**
* 根据发行日判断是否超过提交期限
* @param releaseDate
* 发行日（不能为空）
*/
@Rest(method = RestMethod.GET)
@ActionKey(value = "/api/finance/biz/abs/profit/releasedate/check")
fun isPassDeadline( @Parameter("发行日") releaseDate: String )
: Return {
var r = this.initService<BizAbsProfitInfoService>().isPassDeadline(iwebReq = getIwebRequest(),
releaseDate = releaseDate)
return this.buildReturn(data = r)
}
/**
* 添加收益信息表画面 中 （提交按钮的实现）
* @param coreEnterpriseId
* 核心企业（不允许为空）
* @param financialInstitutionId
* 计划管理人ID（不允许为空）
* @param periodsId
* 期数id（不允许为空）
* @param information
* 信息（费用名称，备注，金额）
* @param financeOpinion
* 意见
* @param releaseDate
* 发行日期 List<AddOrRevisionIncomePoJo>
*/
@Rest(method = RestMethod.POST)
@ActionKey(value = "/api/finance/biz/abs/profit/submit/subject/info")
fun getSubmit(
@Parameter("核心企业ID") coreEnterpriseId: String,
@Parameter("计划管理人ID") financialInstitutionsId: String,
@Parameter("期数") periods: String,
@Parameter("费用金额备注", optional = false) subjectlist: MutableList<String> ,
@Parameter("意见") financeOpinion: String ,
@Parameter("发行日期") releaseDate :String
) : Return {
val subjectlists:MutableList<AddOrRevisionIncomePoJo> = mutableListOf()
for (subject in subjectlist!!.listIterator() ){
// 解析字符窜转对象
var obj= JsonUtils.parseJson2T(subject,AddOrRevisionIncomePoJo::class.java)
subjectlists.add(obj)
}
var r = this.initService<BizAbsProfitInfoService>().getSubmit(iwebReq = getIwebRequest(),
subjectlist = subjectlists, financeOpinion = financeOpinion ,releaseDate =releaseDate , coreEnterpriseId = coreEnterpriseId ,
financialInstitutionsId =financialInstitutionsId , periods = periods )
return this.buildReturn(data = r)
}
/**
* 修改收益信息表画面中（获取表单的单个信息）
* 根据ABS收益信息表id获取收益共通信息
* @param absProfitId
* 表单的id(ABS收益ID)
*
*/
@Rest(method = RestMethod.GET)
@ActionKey(value = "/api/finance/biz/abs/profit/modify/profit/info")
fun getFormEarningsInformation(
@Parameter("ABS收益ID", optional = false) absProfitId: Long ): Return {
var r = this.initService<BizAbsProfitInfoService>().getFormEarningsInformation(iwebReq = getIwebRequest(), absProfitId = absProfitId)
return this.buildReturn(data = r)
}
/**
* 修改收益信息表画面中（获取表单的单个信息）
* 根据ABS收益ID获取对应科目信息
* @param absProfitId
* 表单的id(ABS收益ID)
*
*/
@Rest(method = RestMethod.GET)
@ActionKey(value = "/api/finance/biz/abs/profit/modify/subject/info")
fun getFormSubjectInformation(
@Parameter("ABS收益ID", optional = false) absProfitId: Long ): Return {
var r = this.initService<BizAbsProfitInfoService>().getFormSubjectInformation(iwebReq = getIwebRequest(), absProfitId = absProfitId)
return this.buildReturn(data = r)
}
/**
* 修改收益信息表画面中
* 保存金融部收益信息
* @param absProfitId
* 表单的id(ABS收益ID)
*@param releaseDate
* 发行日期
*@param financeOpinion
* 金融意见
*@param subjectlist List<ModificationFinancialPoJo>
* 科目ID(基础费用科目ID)，收益明细ID，收益金额，备注
*/
@Rest(method = RestMethod.POST)
@ActionKey(value = "/api/finance/biz/abs/profit/modifysave/subject/info")
fun saveFinance(
@Parameter("ABS收益ID", optional = true) absProfitId: Long,
@Parameter("发行日期", optional = true) releaseDate: String?,
@Parameter("金融部意见", optional = true) financeOpinion: String?,
@Parameter("科目的信息", optional = false) subjectlist: MutableList<String>?,
@Parameter("form表单数据", optional = false) form: String?
): Return {
var subjectlists= mutableListOf<ModificationFinancialPoJo>()
for (subject in subjectlist!!.iterator()){
var obj= JsonUtils.parseJson2T(subject,ModificationFinancialPoJo::class.java)
subjectlists.add(obj)
}
var bizAbsProfitInfo=JsonUtils.parseJson2T(form, BizAbsProfitInfo::class.java)
var r = this.initService<BizAbsProfitInfoService>().saveFinance(iwebReq = getIwebRequest(), absProfitId = absProfitId , releaseDate = releaseDate,
financeOpinion = financeOpinion , subjectlist = subjectlists,bizAbsProfit=bizAbsProfitInfo)
return this.buildReturn(data = r)
}
/**
* 修改收益信息表画面中
* 提交金融部收益信息
* @param absProfitId
* 表单的id(ABS收益ID)
*@param releaseDate
* 发行日期
*@param financeOpinion
* 金融意见
*@param subjectlist MutableList<String>?
* 科目ID(基础费用科目ID)，收益明细ID，收益金额，备注
*/
@Rest(method = RestMethod.POST)
@ActionKey(value = "/api/finance/biz/abs/profit/modifysubmit/subject/info")
fun submitFinance(
@Parameter("ABS收益ID", optional = true) absProfitId: Long ,
@Parameter("发行日期", optional = true) releaseDate: String? ,
@Parameter("金融部意见", optional = true) financeOpinion: String? ,
@Parameter("科目的信息", optional = false) subjectlist: MutableList<String>?,
@Parameter("form表单数据", optional = false) form: String?
): Return {
//遍历
val subjectlists:MutableList<ModificationFinancialPoJo> = mutableListOf()
for (subject in subjectlist!!.listIterator() ){
// 解析字符窜转对象
var obj=JsonUtils.parseJson2T(subject,ModificationFinancialPoJo::class.java)
subjectlists.add(obj)
}
var bizAbsProfit=JsonUtils.parseJson2T(form, BizAbsProfitInfo::class.java)
var r = this.initService<BizAbsProfitInfoService>().submitFinance(iwebReq = getIwebRequest(), absProfitId = absProfitId , releaseDate = releaseDate,
financeOpinion = financeOpinion , subjectlist = subjectlists , bizAbsProfit = bizAbsProfit)
return this.buildReturn(data = r)
}
/**
* 修改收益信息表画面中
* 验证上一期的金融部的所有费用金额与财务部费用是否存在差异
* 未做完
*/
// @Rest(method = RestMethod.GET)
// @ActionKey(value = "/api/finance/biz/abs/profit/releasedate/check33333333333333333")
// fun differenceMoney(
// @Parameter("ABS收益ID", optional = false) absProfitId: Long ,
// @Parameter("发行日期", optional = false) releaseDate: String? ,
// @Parameter("金融部意见", optional = false) financeOpinion: String? ,
// @Parameter("科目的信息", optional = false) subjectlist: List<ModificationFinancialPoJo>?
// ): Return {
//// var r = this.initService<BizAbsProfitInfoService>().submitFinance(iwebReq = getIwebRequest(), absProfitId = absProfitId , releaseDate = releaseDate,
//// financeOpinion = financeOpinion , subjectlist = null)
// // return this.buildReturn(data = r)
// }
}
package cn.szqhyf.qhyffs.app.fs.iservice
import club.newepoch.iweb.ext.IwebReq
import club.newepoch.persistent.db.common.Model
import club.newepoch.persistent.db.common.Page
import club.newepoch.persistent.db.pojo.Record
import club.newepoch.utils.AssertUtils
import cn.szqhyf.qhyffs.app.fs.idal.BizAbsProfitInfoServiceDal
import cn.szqhyf.qhyffs.app.fs.pojo.po.*
import com.jfinal.aop.Before
import com.jfinal.core.PageInfo
import com.jfinal.plugin.activerecord.tx.Tx
import org.apache.poi.ss.formula.functions.T
import java.sql.Timestamp
import java.text.SimpleDateFormat
import java.util.*
/**
* ABS收益明细信息表服务类
*
*/
open class BizAbsProfitInfoService : QhyffsService() {
/**
* ABS收益表管理一览画面
* @param core_enterprise_id
* 核心企业
* @param financial_institutions_id
* 金融机构
* @param periods
* 期数
* @param bigPeriodsId
* 所属大区ID
*/
fun pages(iwebReq: IwebReq, pageInfo: PageInfo, coreEnterpriseId:String ?, financialInstitutionsId:String?, periods: String?, bigPeriodsId:String? ): Page<Record>? {
return this.intDal<BizAbsProfitInfoServiceDal>().pages(iwebReq = iwebReq, pageInfo = pageInfo, coreEnterpriseId = coreEnterpriseId, financialInstitutionsId = financialInstitutionsId, periods = periods , bigPeriodsId = bigPeriodsId)
}
/**
* ABS收益表画面一览 (所属大期)的获得方法
*/
fun periods(iwebReq: IwebReq ): List<Record>? {
return this.intDal<BizAbsProfitInfoServiceDal>().periods(iwebReq= iwebReq)
}
/**
* 添加收益信息表画面 中 （查询按钮的实现）
* @param coreEnterpriseId
* 核心企业
* @param financialInstitutionId
* 计划管理人ID
* @param periodsId
* 期数ID
*/
fun getQuery(iwebReq: IwebReq, coreEnterpriseId:String , financialInstitutionsId:String ,periods: String ): List<Record>? {
if (coreEnterpriseId == null){
AssertUtils.isTrue(false,"核心企业不能为空！")
}
if (financialInstitutionsId == null) {
AssertUtils.isTrue(false, " 计划管理人不能为空")
}
if (periods == null) {
AssertUtils.isTrue(false, " 期数不能为空")
}
var result= this.intDal<BizAbsProfitInfoServiceDal>().getQuery(iwebReq = iwebReq, coreEnterpriseId = coreEnterpriseId, financialInstitutionsId = financialInstitutionsId,periods =periods)
return result
}
/**
* 添加收益信息表画面 中 （判断是否跳期的判断依准）
* @param coreEnterpriseId
* 核心企业（不允许为空）
* @param financialInstitutionId
* 计划管理人ID（不允许为空）
* @param periodsId
* 期数ID（不允许为空）
*/
fun isjumpPeriods(iwebReq: IwebReq, coreEnterpriseId:String , financialInstitutionsId:String ,periods: String ): Boolean {
if (coreEnterpriseId == null){
AssertUtils.isTrue(false,"核心企业不能为空！")
}
if (financialInstitutionsId == null) {
AssertUtils.isTrue(false, " 计划管理人不能为空")
}
if (periods == null) {
AssertUtils.isTrue(false, " 期数不能为空")
}
// true:不存在跳期，false：存在跳期
var periodsCheck = false
var list = this.intDal<BizAbsProfitInfoServiceDal>().isjumpPeriods(iwebReq = iwebReq, coreEnterpriseId = coreEnterpriseId, financialInstitutionsId = financialInstitutionsId,periods =periods)
//如果查询的东西，不为空，不存在跳期
if (list==null){
periodsCheck = true
}
return periodsCheck
}
/**
* 根据发行日判断是否超过提交期限
* @param releaseDate
* 发行日（不能为空）
*/
fun isPassDeadline(iwebReq: IwebReq, releaseDate:String ): Boolean {
if (releaseDate == null){
AssertUtils.isTrue(false,"发行日不能为空！")
}
// true:期限验证通过，false：期限验证不通过
var releaseDateCheck = true
// 定义发行到期日 发行日+1个月
var checkDate = this.subMonth(releaseDate)
//定义工作日
var workDateCount = 0
//循环15次，总会有3次是工作日
for (i in 1..15 step 1) {
if (workDateCount == 3){
break
}
//判断"checkDate"的日期是否在配置的法定日期配置表中：
var isExist=this.intDal<BizAbsProfitInfoServiceDal>().isPassDeadline(iwebReq = iwebReq, releaseDate =releaseDate)
//查询结果为空
if (!isExist ){
var format1 = SimpleDateFormat("yyyy-mm-dd")
var bdate = format1.parse(checkDate)
var cal = Calendar.getInstance()
cal.setTime(bdate);
// 判断是否是周六或周日
if(cal.get(Calendar.DAY_OF_WEEK) != Calendar.SATURDAY && cal.get(Calendar.DAY_OF_WEEK) != Calendar.SUNDAY){
// 说明是工作日
workDateCount++
}
//加一天
checkDate =addOneDay(checkDate)
}else{
if("w".equals(isExist)){
//是工作日
workDateCount++
}
//加一天
checkDate =addOneDay(checkDate)
}
}
//string 转data
var sdf = SimpleDateFormat("yyyy-MM-dd");
if (Date().time > sdf.parse(this.subDay(checkDate)).time){
//说明超过时限
releaseDateCheck = false
}
return releaseDateCheck
}
/****
* 传入具体日期 ，返回具体日期增加一个月。
* @param date 日期(2017-04-13)
* @return 2017-05-13
*/
fun subMonth(date:String) :String{
var sdf = SimpleDateFormat("yyyy-MM-dd");
var dt = sdf.parse(date)
var rightNow = Calendar.getInstance()
rightNow.setTime(dt)
rightNow.add(Calendar.MONTH, 1)
var dt1 = rightNow.getTime()
var reStr = sdf.format(dt1)
return reStr
}
/****
* 传入具体日期 ，返回具体日期减少一天
* @param date 日期(2017-04-13)
* @return 2017-04-12
* @throws ParseException
*/
fun subDay(date:String ):String {
var sdf = SimpleDateFormat("yyyy-MM-dd");
var dt = sdf.parse(date);
var rightNow = Calendar.getInstance();
rightNow.setTime(dt);
rightNow.add(Calendar.DAY_OF_MONTH, -1);
var dt1 = rightNow.getTime();
var reStr = sdf.format(dt1);
return reStr;
}
/****
* 传入具体日期 ，返回具体日期减少一天
* @param date 日期(2017-04-13)
* @return 2017-04-12
* @throws ParseException
*/
fun addOneDay(date:String ):String {
var sdf = SimpleDateFormat("yyyy-MM-dd");
var dt = sdf.parse(date);
var rightNow = Calendar.getInstance();
rightNow.setTime(dt);
rightNow.add(Calendar.DAY_OF_MONTH, 1);
var dt1 = rightNow.getTime();
var reStr = sdf.format(dt1);
return reStr;
}
/**
* 添加收益信息表画面 中 （提交按钮的实现）
* @param coreEnterpriseId
* 核心企业（不允许为空）
* @param financialInstitutionId
* 计划管理人ID（不允许为空）
* @param periodsId
* 期数id（不允许为空）
* @param information
* 信息（费用名称，备注，金额）
* @param financeOpinion
* 意见（不允许为空）
* @param releaseDate
* 发行日期（不允许为空）
*/
fun getSubmit(iwebReq: IwebReq, subjectlist:List<AddOrRevisionIncomePoJo> , financeOpinion:String, releaseDate :String ,
coreEnterpriseId : String , financialInstitutionsId : String , periods : String ): Boolean {
//判断数据保存到表是否成功
var isok=false
if (coreEnterpriseId == null){
AssertUtils.isTrue(false,"核心企业不能为空！")
}
if (financialInstitutionsId == null) {
AssertUtils.isTrue(false, "计划管理人不能为空")
}
if (periods == null) {
AssertUtils.isTrue(false, "期数不能为空")
}
if (financeOpinion == null) {
AssertUtils.isTrue(false, "意见不能为空")
}
if (releaseDate == null) {
AssertUtils.isTrue(false, "发行日期不能为空")
}
//判断当前保存的数据在数据库中是否存在
var list =this.intDal<BizAbsProfitInfoServiceDal>().isExist(iwebReq = iwebReq, coreEnterpriseId =coreEnterpriseId , financialInstitutionsId = financialInstitutionsId , periods =periods)
//遍历financeOpinion
//存在数据
if (list != null){
AssertUtils.isTrue(false, "当前添加的核心企业、金融机构、期数所对应的ABS收益信息已存在!")
}else{
//创造ABS收益信息表的实体对象
var bizAbsProfitInfo = BizAbsProfitInfo()
//设置核心企业id
bizAbsProfitInfo.coreEnterpriseId = coreEnterpriseId
//设置金融机构id
bizAbsProfitInfo.financialInstitutionsId = financialInstitutionsId
//设置期数
bizAbsProfitInfo.periods = Integer.valueOf(periods)
//设置金融部意见
bizAbsProfitInfo.financeOpinion=financeOpinion
// 发行日 release_date
val format = SimpleDateFormat("yyyy-MM-dd")
bizAbsProfitInfo.releaseDate=format.parse(releaseDate)
//设置当前登录的用户
bizAbsProfitInfo.addUserId= "123"
// AdminService().getUserInfo(iwebReq)!!.getStr("id")
//设置当前时间
var date = Date()
var sdf = SimpleDateFormat("yyyy-MM-dd HH:mm:ss")
//获取当前时间
bizAbsProfitInfo.addTime= Timestamp.valueOf(sdf.format(date))
//设置状态00（没有提交审批）
bizAbsProfitInfo.status="03"
this.save(iwebReq = iwebReq, d = bizAbsProfitInfo)
isok = true
}
if (isok){
//再次查询获取刚保存的id
var lists=this.intDal<BizAbsProfitInfoServiceDal>().isExist(iwebReq = iwebReq, coreEnterpriseId =coreEnterpriseId , financialInstitutionsId = financialInstitutionsId , periods =periods)
// 获取其中的id
var id =lists?.getStr("id")
for (content in subjectlist!!){
//创造ABS收益明细表的实体对象
var bizAbsProfitDetail = BizAbsProfitDetail()
//获取费用名称,并设置进去
bizAbsProfitDetail.subjectId= content.subjectId
//获取金额
bizAbsProfitDetail.profit=content.profit
//获取备注
bizAbsProfitDetail.memo=content.memo
//设置获取的id
bizAbsProfitDetail.absProfitId= id
// isTrue=dbp.merge("biz_abs_profit_detail",bizAbsProfitDetail)
this.save(iwebReq = iwebReq, d = bizAbsProfitDetail)
isok =true
}
}
return isok
}
/**
* 添加收益信息表画面 中 （保存按钮的实现）
* @param coreEnterpriseId
* 核心企业（不允许为空）
* @param financialInstitutionId
* 计划管理人ID（不允许为空）
* @param periodsId
* 期数id（不允许为空）
* @param information
* 信息（费用名称，备注，金额）
* @param financeOpinion
* 意见
* @param releaseDate
* 发行日期
*/
fun saveWays(iwebReq: IwebReq, subjectlist:List<AddOrRevisionIncomePoJo> ?, financeOpinion:String? , releaseDate :String? ,
coreEnterpriseId : String , financialInstitutionsId : String , periods : String ): Boolean {
if (coreEnterpriseId == null){
AssertUtils.isTrue(false,"核心企业不能为空！")
}
if (financialInstitutionsId == null) {
AssertUtils.isTrue(false, " 计划管理人不能为空")
}
if (periods == null) {
AssertUtils.isTrue(false, " 期数不能为空")
}
//判断数据保存到表是否成功
var isok = false
var list= this.intDal<BizAbsProfitInfoServiceDal>().isExist(iwebReq = iwebReq, coreEnterpriseId =coreEnterpriseId , financialInstitutionsId = financialInstitutionsId , periods = periods)
//存在数据
if (list != null){
AssertUtils.isTrue(false, "当前添加的核心企业、金融机构、期数所对应的ABS收益信息已存在!")
}else{
//创造ABS收益信息表的实体对象
var bizAbsProfitInfo = BizAbsProfitInfo()
//设置核心企业id
bizAbsProfitInfo.coreEnterpriseId = coreEnterpriseId
//设置金融机构id
bizAbsProfitInfo.financialInstitutionsId = financialInstitutionsId
//设置期数
bizAbsProfitInfo.periods = Integer.valueOf(periods)
//设置金融部意见
bizAbsProfitInfo.financeOpinion = financeOpinion
// 发行日 release_date
val format = SimpleDateFormat("yyyy-MM-dd")
bizAbsProfitInfo.releaseDate = format.parse(releaseDate)
//设置当前登录的用户
bizAbsProfitInfo.addUserId = iwebReq.userId.toString()
// AdminService().getUserInfo(iwebReq)!!.getStr("id")
//获取当前时间
bizAbsProfitInfo.addTime = Date()
//设置状态00（没有提交审批）
bizAbsProfitInfo.status = "00"
this.save(iwebReq = iwebReq,d = bizAbsProfitInfo)
isok = true
}
if (isok){
//再次查询获取刚保存的id
var lists= this.intDal<BizAbsProfitInfoServiceDal>().isExist(iwebReq = iwebReq, coreEnterpriseId = coreEnterpriseId , financialInstitutionsId = financialInstitutionsId , periods =periods)
// 获取其中的id
var id =lists?.getStr("id")
//遍历financeOpinion
for (content in subjectlist!!){
//创造ABS收益明细表的实体对象
var bizAbsProfitDetail = BizAbsProfitDetail()
//获取费用名称,并设置进去
bizAbsProfitDetail.subjectId = content.subjectId
//获取金额
bizAbsProfitDetail.profit = content.profit
//获取备注
bizAbsProfitDetail.memo = content.memo
//设置获取的id
bizAbsProfitDetail.absProfitId = id
this.save(iwebReq = iwebReq, d = bizAbsProfitDetail)
// isTrue=dbp.merge("biz_abs_profit_detail",bizAbsProfitDetail)
isok = true
}
}
return isok
}
/**
* 依据表单ID获取表单项信息
* 根据ABS收益信息表id获取收益共通信息
* @param id
* 表单id(ABS收益ID)
* @return 表单项信息
*/
fun getFormEarningsInformation(iwebReq: IwebReq, absProfitId: Long): Record{
if (absProfitId == null){
AssertUtils.isTrue(false,"ABS收益ID不能为空！")
}
//返回一个对象给前端
var record= this.intDal<BizAbsProfitInfoServiceDal>().getFormEarningsInformation(iwebReq = iwebReq, absProfitId = absProfitId)
return record
}
/**
* 依据表单ID获取表单项信息
* 根据ABS收益ID获取对应科目信息
* @param id
* 表单id(ABS收益ID)
* @return 表单项信息
*/
fun getFormSubjectInformation(iwebReq: IwebReq, absProfitId: Long): List<Record> {
if (absProfitId == null){
AssertUtils.isTrue(false,"ABS收益ID不能为空！")
}
//返回一个集合
var list : List<Record> = this.intDal<BizAbsProfitInfoServiceDal>().getFormSubjectInformation(iwebReq = iwebReq, absProfitId = absProfitId)
//获取期数
var per =list.get(0).getStr("periods")
var periods =Integer.parseInt(per) -1
//获取金融机构
var financialInstitutionsId=list.get(0).getStr("financialInstitutionsId")
//获取核心企业
var coreEnterpriseId= list.get(0).getStr("coreEnterpriseId")
//遍历集合
for (li in list){
//获取科目的id
var subjectId=li.getStr("subjectId")
//查询上一期对应的金额
var record : Record? = this.intDal<BizAbsProfitInfoServiceDal>().beforeMoney(iwebReq = iwebReq, periods = periods ,
financialInstitutionsId = financialInstitutionsId , coreEnterpriseId = coreEnterpriseId ,subjectId =subjectId)
//获取上一期的金额
var profit= record?.getStr("profit")
if (profit == null ){
li.set("lastProfit","")
}else{
li.set("lastProfit",profit)
}
}
return list
}
/**
* 修改收益信息表画面中
* 保存金融部收益信息
* @param absProfitId
* 表单的id(ABS收益ID)
*@param releaseDate
* 发行日期
*@param financeOpinion
* 金融意见
*@param subjectlist
* 科目ID(基础费用科目ID)，收益明细ID，收益金额，备注
*/
fun saveFinance(iwebReq: IwebReq, absProfitId: Long,releaseDate:String ? ,financeOpinion :String? ,
subjectlist :List<ModificationFinancialPoJo>? , bizAbsProfit:BizAbsProfitInfo):Boolean{
if (absProfitId == null){
AssertUtils.isTrue(false,"ABS收益ID不能为空！")
}
//创造ABS收益信息表的实体对象
var bizAbsProfitInfo = BizAbsProfitInfo()
//保存表单的id
bizAbsProfitInfo.id = absProfitId
//保存发行日期 string 转data
val formatter = SimpleDateFormat("yyyy-MM-dd")
// var releaseDate=
bizAbsProfitInfo.releaseDate = formatter.parse(releaseDate)
//保存金融部意见
bizAbsProfitInfo.financeOpinion = financeOpinion
//保存核心企业
bizAbsProfitInfo.coreEnterpriseId = bizAbsProfit.coreEnterpriseId
//保存金融机构
bizAbsProfitInfo.financialInstitutionsId = bizAbsProfit.financialInstitutionsId
//保存状态
bizAbsProfitInfo.status = bizAbsProfit.status
//保存用户id
bizAbsProfitInfo.addUserId = iwebReq.userId.toString()
// this.merge(iwebReq = iwebReq, models = Model<BizAbsProfitInfo>())
this.merge4T(iwebReq = iwebReq, tableName= "biz_abs_profit_info",datas =bizAbsProfitInfo)
var isOk = false
//遍历 subjectlist
for(subject in subjectlist !!){
var profitDetailId= subject.profitDetailId
if (profitDetailId == null){
//创造ABS收益明细表的实体对象
var bizAbsProfitDetail = BizAbsProfitDetail()
//新增数据
bizAbsProfitDetail.subjectId = subject.subjectId
bizAbsProfitDetail.profit = subject.profit
bizAbsProfitDetail.memo = subject.memo
bizAbsProfitDetail.absProfitId = absProfitId.toString()
this.merge4T(iwebReq = iwebReq, tableName= "biz_abs_profit_detail",datas =bizAbsProfitDetail)
isOk = true
}else{
//创造ABS收益明细表的实体对象
var bizAbsProfitDetail = BizAbsProfitDetail()
//更新数据
bizAbsProfitDetail.subjectId = subject.subjectId
bizAbsProfitDetail.profit = subject.profit
bizAbsProfitDetail.memo = subject.memo
bizAbsProfitDetail.id = subject.profitDetailId!!.toLong()
bizAbsProfitDetail.absProfitId = absProfitId.toString()
// this.merge(iwebReq = iwebReq, models = bizAbsProfitDetail as Model<*> )
this.merge4T(iwebReq = iwebReq, tableName= "biz_abs_profit_detail",datas =bizAbsProfitDetail)
isOk = true
}
}
//调用新增的履历，逻辑的方法
if (isOk){
addSavaLogic(iwebReq,absProfitId,subjectlist , "0")
}
return isOk
}
/**
* 修改收益信息表画面中
* 提交金融部收益信息
* @param absProfitId
* 表单的id(ABS收益ID)
*@param releaseDate
* 发行日期
*@param financeOpinion
* 金融意见
*@param subjectlist
* 科目ID(基础费用科目ID)，收益明细ID，收益金额，备注
*/
fun submitFinance(iwebReq: IwebReq, absProfitId: Long,releaseDate:String ? ,financeOpinion :String? ,
subjectlist :MutableList<ModificationFinancialPoJo>?,bizAbsProfit :BizAbsProfitInfo):Boolean{
if (absProfitId == null){
AssertUtils.isTrue(false,"ABS收益ID不能为空！")
}
//创造ABS收益信息表的实体对象
var bizAbsProfitInfo = BizAbsProfitInfo()
//保存表单的id
bizAbsProfitInfo.id = absProfitId
//保存发行日期 string 转data
val formatter = SimpleDateFormat("yyyy-MM-dd")
var releaseDa=formatter.parse(releaseDate.toString())
// (Date)formatter.parseObject(releaseDate)
bizAbsProfitInfo.releaseDate = releaseDa
//保存金融部意见
bizAbsProfitInfo.financeOpinion = financeOpinion
//保存核心企业
bizAbsProfitInfo.coreEnterpriseId = bizAbsProfit.coreEnterpriseId
//保存金融机构
bizAbsProfitInfo.financialInstitutionsId = bizAbsProfit.financialInstitutionsId
//保存状态
bizAbsProfitInfo.status = bizAbsProfit.status
//保存用户id
bizAbsProfitInfo.addUserId = iwebReq.userId.toString()
//状态设置为03（等待审批）
bizAbsProfitInfo.status = "03"
this.merge4T(iwebReq = iwebReq, tableName= "biz_abs_profit_info",datas =bizAbsProfitInfo)
var isOk = false
//遍历 subjectlist
for(subject in subjectlist !!){
var profitDetailId= subject.profitDetailId
if (profitDetailId == null){
//创造ABS收益明细表的实体对象
var bizAbsProfitDetail = BizAbsProfitDetail()
//新增数据
bizAbsProfitDetail.subjectId = subject.subjectId
bizAbsProfitDetail.profit = subject.profit
bizAbsProfitDetail.memo = subject.memo
bizAbsProfitDetail.absProfitId = absProfitId.toString()
// this.save(iwebReq = iwebReq, d = bizAbsProfitDetail)
this.merge4T(iwebReq = iwebReq, tableName= "biz_abs_profit_detail",datas =bizAbsProfitDetail)
isOk = true
}else{
//创造ABS收益明细表的实体对象
var bizAbsProfitDetail = BizAbsProfitDetail()
//更新数据
bizAbsProfitDetail.subjectId = subject.subjectId
bizAbsProfitDetail.profit = subject.profit
bizAbsProfitDetail.memo = subject.memo
bizAbsProfitDetail.id = subject.profitDetailId!!.toLong()
bizAbsProfitDetail.absProfitId = absProfitId.toString()
// this.save(iwebReq = iwebReq, d = bizAbsProfitDetail)
this.merge4T(iwebReq = iwebReq, tableName= "biz_abs_profit_detail",datas =bizAbsProfitDetail)
isOk = true
}
}
//调用新增的履历，逻辑的方法
if (isOk){
addSavaLogic(iwebReq,absProfitId,subjectlist , "1")
}
return isOk
}
/**
*修改页面的保存时候，增加的逻辑
*/
@Before(Tx::class)
fun addSavaLogic(iwebReq: IwebReq,absProfitId: Long,subjectlist :List<ModificationFinancialPoJo>?,submitState:String){
//利用abs_profit_id 获取ABS收益审核结果表的审核数据
var isOk=this.intDal<BizAbsProfitInfoServiceDal>().addSavaLogic(iwebReq,absProfitId)
//等于true时，证明存在审核数据
if (isOk){
// 若存在审核数据：
//a、判断对应的 最大的履历编号对应的履历数据的提交状态：利用abs_profit_id 来查
var recordHistory=this.intDal<BizAbsProfitInfoServiceDal>().bigNumberState(iwebReq,absProfitId)
//若不存在履历 或者 提交状态是已提交，则新增对应的科目修改履历数据；
if (recordHistory == null || recordHistory.getStr("submitState").equals("1")){
//遍历
for(subject in subjectlist !!){
// 科目ID
var subjectId = subject.subjectId
// 修改后的收益金额
var profit = subject.profit
// 判断金额是否有修改，有修改时保存履历, 为true，有修改数据
if( this.intDal<BizAbsProfitInfoServiceDal>().profitModifyState(iwebReq,absProfitId,subjectId,profit)){
//创建ABS收益明细修改履历表实力对象
var bizAbsProfitModifyHistory= BizAbsProfitModifyHistory()
//新增保存
//保存 履历编号
if (recordHistory == null ){
bizAbsProfitModifyHistory.historyNo = 1
}else{
bizAbsProfitModifyHistory.historyNo = recordHistory.getStr("historyNo").toInt()+1
}
//保存abs收益ID
bizAbsProfitModifyHistory.absProfitId = absProfitId!!.toInt()
//保存科目id
bizAbsProfitModifyHistory.subjectId = subject.subjectId
//保存收益
bizAbsProfitModifyHistory.profit = subject.profit
//保存提交状态
bizAbsProfitModifyHistory.submitState = submitState.toInt()
//保存备注
bizAbsProfitModifyHistory.memo = subject.memo
this.save(iwebReq = iwebReq, d = bizAbsProfitModifyHistory)
}
}
}
// b、若存在履历 且 提交状态是未提交：
else if (recordHistory != null && recordHistory.getStr("submitState").equals("0")){
//遍历
for(subject in subjectlist !!){
// 科目ID
var subjectId = subject.subjectId
// 修改后的收益金额
var profit = subject.profit
// 判断金额是否有修改，有修改时保存履历, 为true，有修改数据
if( this.intDal<BizAbsProfitInfoServiceDal>().profitModifyState(iwebReq,absProfitId,subjectId,profit)) {
//查询该履历编号、ABS收益ID 下是否有该科目的履历
var isExist= this.intDal<BizAbsProfitInfoServiceDal>().isExistResume(iwebReq, recordHistory.getStr("historyNo").toInt(),absProfitId!!.toInt())
//如果存在
if (isExist != null ){
//创建ABS收益明细修改履历表实力对象
var bizAbsProfitModifyHistory= BizAbsProfitModifyHistory()
// 修改保存 ，需要id
//保存 履历编号
bizAbsProfitModifyHistory.historyNo = recordHistory.getStr("historyNo").toInt()
//保存abs收益ID
bizAbsProfitModifyHistory.absProfitId = absProfitId.toInt()
//保存科目id
bizAbsProfitModifyHistory.subjectId = subject.subjectId
//保存收益
bizAbsProfitModifyHistory.profit = subject.profit
//保存提交状态
bizAbsProfitModifyHistory.submitState = submitState.toInt()
//保存备注
bizAbsProfitModifyHistory.memo = subject.memo
//保存id（代表是修改）
bizAbsProfitModifyHistory.id = isExist.getStr("id").toLong()
this.save(iwebReq = iwebReq, d = bizAbsProfitModifyHistory)
}else{
//创建ABS收益明细修改履历表实力对象
var bizAbsProfitModifyHistory= BizAbsProfitModifyHistory()
// 新增保存 ，不需要id
//保存 履历编号
bizAbsProfitModifyHistory.historyNo = recordHistory.getStr("historyNo").toInt()
//保存abs收益ID
bizAbsProfitModifyHistory.absProfitId = absProfitId!!.toInt()
//保存科目id
bizAbsProfitModifyHistory.subjectId = subject.subjectId
//保存收益
bizAbsProfitModifyHistory.profit = subject.profit
//保存提交状态
bizAbsProfitModifyHistory.submitState = submitState.toInt()
//保存备注
bizAbsProfitModifyHistory.memo = subject.memo
this.save(iwebReq = iwebReq, d = bizAbsProfitModifyHistory)
}
}
}
}
//如果是提交，继续走下面这个逻辑
if (submitState.equals("1")){
//4、修改画面提交时，将对应的最大编号的履历数据，的提交状态都改成已提交；
//获取对应的最大编号的履历数据中的id
var historyNo=recordHistory.getStr("historyNo")
var recordList =this.intDal<BizAbsProfitInfoServiceDal>().getBigNumberResumeData(iwebReq,historyNo,absProfitId)
//遍历
for ( record in recordList ){
//获取每次的id
var id = record.getStr("id")
//创建ABS收益明细修改履历表实例对象
var bizAbsProfitModifyHistory= BizAbsProfitModifyHistory()
bizAbsProfitModifyHistory.id= id.toLong()
bizAbsProfitModifyHistory.submitState = 1
bizAbsProfitModifyHistory.memo = record.getStr("memo")
this.save(iwebReq = iwebReq, d = bizAbsProfitModifyHistory)
}
}
}else{
//等于false，证明没有数据，则不用保存履历
return
}
}
}
package cn.szqhyf.qhyffs.app.fs.idal
import club.newepoch.admin.app.sys.service.AdminService
import club.newepoch.iweb.IwebConstant
import club.newepoch.iweb.ext.IwebReq
import club.newepoch.persistent.db.common.DbPro
import club.newepoch.persistent.db.common.Page
import club.newepoch.persistent.db.pojo.Record
import club.newepoch.utils.AssertUtils
import club.newepoch.utils.StringUtils
import cn.szqhyf.qhyffs.app.fs.pojo.po.AddOrRevisionIncomePoJo
import cn.szqhyf.qhyffs.app.fs.pojo.po.BizAbsProfitDetail
import cn.szqhyf.qhyffs.app.fs.pojo.po.BizAbsProfitInfo
import com.alibaba.fastjson.JSONObject
import com.jfinal.core.PageInfo
import org.json.JSONArray
import java.sql.Timestamp
import java.util.*
import java.text.SimpleDateFormat
/**
*ABS收益表ServiceDal
*/
open class BizAbsProfitInfoServiceDal : QhyffsDal(){
/**
* ABS收益表管理一览画面
* @param coreEnterpriseId
* 核心企业
* @param financialInstitutionId
* 计划管理人
* @param periods
* 期数
* @param bigPeriodsId
* 所属大区ID
*/
fun pages(iwebReq: IwebReq, pageInfo: PageInfo, coreEnterpriseId:String ?, financialInstitutionsId:String?, periods:String? , bigPeriodsId :String? ): Page<Record>? {
var dbp = DbPro.use(iwebReq.dsName)
var pageIndex = pageInfo?.pageIndex ?: 1
var pageSize = pageInfo?.pageSize ?: IwebConstant.DEFAULT_PAGE_SIZE
var select= """
SELECT
a.id as abs_profit_id ,
a.core_enterprise_id,
a.financial_institutions_id,
a.periods,
a.status ,
c.id
"""
var from="""
FROM
biz_abs_profit_info a,
biz_big_periods_info c,
biz_periods_mapping_info b
WHERE
a.sys_status = 1
AND a.core_enterprise_id = c.core_enterprise_id
AND a.financial_institutions_id = c.financial_institutions_id
AND c.sys_status = 1
AND a.periods = b.periods
AND b.sys_status = 1
AND c.id = b.big_periods_id
"""
var paras = mutableListOf<Any>()
//核心企业
if(StringUtils.notBlank(coreEnterpriseId) ){
from += " AND a.core_enterprise_id = ? "
var coreEnterpriseId="${coreEnterpriseId?.trim()}"
paras.add(coreEnterpriseId)
}
//金融机构
if(StringUtils.notBlank(financialInstitutionsId) ){
from += " AND a.financial_institutions_id = ? "
var financialInstitutionsId="${financialInstitutionsId?.trim()}"
paras.add(financialInstitutionsId)
}
//期数
if(StringUtils.notBlank(periods) ){
from += " AND a.periods = ? "
var periods = "${periods?.trim()}"
paras.add(periods.trim())
}
//所属大区
if (StringUtils.notBlank(bigPeriodsId)){
from += " AND c.id = ? "
var BelongsToRegional = "${bigPeriodsId?.trim()}"
paras.add(BelongsToRegional)
}
// 设置所属大期
var pageList=dbp.paginate(pageIndex,pageSize,select,from,*paras.toTypedArray<Any>())
for (page in pageList.list){
//获取大期id
var bigPeriodsId = page.getStr("id")
//调用获取所属大期的方法
var record = this.getPeriods(iwebReq,bigPeriodsId)
page.set("bigPeriods",record!!.getStr("bigPeriods"))
}
return pageList
}
/**
* 所属大期
*/
fun getPeriods(iwebReq: IwebReq,bigPeriodsId :String ): Record? {
var dbp = DbPro.use(iwebReq.dsName)
var sql= """
SELECT
b.big_periods_id,
concat(
MIN(b.periods),
'~',
MAX(b.periods)
) AS big_periods
FROM
biz_big_periods_info a
LEFT JOIN biz_periods_mapping_info b ON a.id = b.big_periods_id
WHERE
a.sys_status = 1
AND b.sys_status = 1
and b.big_periods_id = ?
GROUP BY
b.big_periods_id
"""
var list = dbp.findFirst(sql ,bigPeriodsId)
return list
}
/**
* ABS收益表画面一览 (所属大期)的获得方法
*/
fun periods(iwebReq: IwebReq): List<Record>? {
var dbp = DbPro.use(iwebReq.dsName)
var sql= """
SELECT
b.big_periods_id,
concat(
MIN(b.periods),
'~',
MAX(b.periods)
) AS big_periods
FROM
biz_big_periods_info a
LEFT JOIN biz_periods_mapping_info b ON a.id = b.big_periods_id
WHERE
a.sys_status = 1
AND b.sys_status = 1
GROUP BY
b.big_periods_id
"""
var list = dbp.find(sql)
/* val json = JSONArray()
for ( li in list ){
val jo = JSONObject()
jo.put("bigPeriods",li.getStr("bigPeriods"))
json.put(jo)
}*/
return list
}
/**
* 添加收益信息表画面 中 （查询按钮）
* @param coreEnterpriseId
* 核心企业（不允许为空）
* @param financialInstitutionId
* 计划管理人ID （不允许为空）
* @param periodsId
* 期数 （不允许为空）
*/
fun getQuery(iwebReq: IwebReq, coreEnterpriseId:String , financialInstitutionsId:String , periods:String ): List<Record>? {
var dbp = DbPro.use(iwebReq.dsName)
var sql= """
SELECT
c.subject_id,
d.name
FROM
biz_big_periods_info a,
biz_periods_mapping_info b,
biz_fs_abs_relation c,
biz_financial_subjects d,
biz_financial_subjects_source e
WHERE
a.id = b.big_periods_id
AND a.id = c.abs_id
AND c.subject_id = d.id
AND d.source_id = e.id
AND a.core_enterprise_id = trim(?)
AND a.financial_institutions_id = trim(?)
AND b.periods = trim(?)
AND e.type in(3,4)
AND a.sys_status = 1
AND b.sys_status= 1
AND c.sys_status=1
AND d.sys_status=1
AND e.sys_status=1
"""
var list = dbp.find(sql,coreEnterpriseId,financialInstitutionsId,periods)
return list
}
/**
* 添加收益信息表画面中 （判断是否跳期的判断依准）
* @param coreEnterpriseId
* 核心企业（不允许为空）
* @param financialInstitutionId
* 计划管理人ID （不允许为空）
* @param periodsId
* 期数 （不允许为空）
*/
fun isjumpPeriods(iwebReq: IwebReq, coreEnterpriseId:String , financialInstitutionsId:String , periods:String ): List<Record>? {
var dbp = DbPro.use(iwebReq.dsName)
if (Integer.valueOf(periods) - 1 > 0){
var jumpSql= """
SELECT
a.id
FROM
biz_abs_profit_info a
WHERE
a.core_enterprise_id = ?
AND a.financial_institutions_id = ?
AND a.periods = (? - 1)
AND a.sys_status = 1
"""
var record= dbp.find(jumpSql,coreEnterpriseId,financialInstitutionsId,periods)
return record
}else{
return null
}
}
/**
* 根据发行日判断是否超过提交期限
* @param releaseDate
* 发行日（不能为空）
*/
fun isPassDeadline(iwebReq: IwebReq,releaseDate: String ): Boolean {
var isOk= true
var dbp = DbPro.use(iwebReq.dsName)
var sql="""
SELECT
a.date_type
FROM
biz_legal_date_configure a
WHERE
a.legal_date = ?
AND a.sys_status = 1
"""
var release=dbp.findFirst(sql,releaseDate)
if(release == null){
isOk=false
}
return isOk
}
/**
* 添加收益信息表画面 中 （判断当前保存的数据在数据库中是否存在）
* @param coreEnterpriseId
* 核心企业（不允许为空）
* @param financialInstitutionId
* 计划管理人ID（不允许为空）
* @param periodsId
* 期数id（不允许为空）
*/
fun isExist(iwebReq: IwebReq, coreEnterpriseId : String , financialInstitutionsId : String , periods :String ): Record? {
var dbp = DbPro.use(iwebReq.dsName)
//判断当前保存的数据在数据库中是否存在
var sql= """
SELECT
a.id
FROM
biz_abs_profit_info a
WHERE
a.core_enterprise_id = ?
AND a.financial_institutions_id = ?
AND a.periods = ?
AND a.sys_status = 1
"""
var list= dbp.findFirst(sql,coreEnterpriseId , financialInstitutionsId ,periods)
return list
}
/**
* 依据表单ID获取表单项信息(修改页面)
* 根据ABS收益信息表id获取收益共通信息
* @param absProfitId
* 表单的id(ABS收益ID)
* @return 表单项信息
*/
fun getFormEarningsInformation(iwebReq: IwebReq, absProfitId: Long?): Record{
var dbp = DbPro.use(iwebReq.dsName)
var sql="""
SELECT
core_enterprise_id,
financial_institutions_id,
periods,
finance_opinion,
release_date
FROM
biz_abs_profit_info
WHERE
id = ?
AND sys_status =1
"""
var record= dbp.findFirst(sql,absProfitId)
var releaseDate =record.getDate("releaseDate").toString()
record.set("releaseDate",releaseDate)
return record
}
/**
* 依据表单ID获取表单项信息(修改页面)
* 根据ABS收益ID获取对应科目信息
* @param absProfitId
* 表单的id(ABS收益ID)
* @return 表单项信息
*/
fun getFormSubjectInformation(iwebReq: IwebReq, absProfitId: Long): List<Record>{
var dbp = DbPro.use(iwebReq.dsName)
var sql="""
SELECT
c.subject_id,
d.name,
g.id AS profit_detail_id,
g.profit,
g.memo,
f.periods,
f.core_enterprise_id,
f.financial_institutions_id
FROM
biz_big_periods_info a,
biz_periods_mapping_info b,
biz_financial_subjects d,
biz_financial_subjects_source e,
biz_abs_profit_info f,
biz_fs_abs_relation c
LEFT JOIN biz_abs_profit_detail g ON g.abs_profit_id = ?
AND g.sys_status = 1
AND c.subject_id = g.subject_id
WHERE
a.id = b.big_periods_id
AND a.id = c.abs_id
AND c.subject_id = d.id
AND d.source_id = e.id
AND a.core_enterprise_id = f.core_enterprise_id
AND a.financial_institutions_id = f.financial_institutions_id
AND b.periods = f.periods
AND f.id = ?
AND e.type IN (3, 4)
AND a.sys_status = 1
AND b.sys_status = 1
AND c.sys_status = 1
AND d.sys_status = 1
AND e.sys_status = 1
AND f.sys_status = 1
"""
var list=dbp.find(sql,absProfitId,absProfitId)
return list
}
/**
* 获取上一期对应的金额
*/
fun beforeMoney(iwebReq: IwebReq, coreEnterpriseId: String , financialInstitutionsId : String ,
periods: Int , subjectId : String): Record?{
var dbp = DbPro.use(iwebReq.dsName)
var sql = """
SELECT
b.profit
FROM
biz_abs_profit_info a,
biz_abs_profit_detail b
WHERE
a.id = b.abs_profit_id
AND a.sys_status = 1
AND b.sys_status = 1
AND a.core_enterprise_id = ?
AND a.financial_institutions_id = ?
AND a.periods = ?
AND b.subject_id = ?
"""
var record= dbp.findFirst(sql,coreEnterpriseId,financialInstitutionsId , periods , subjectId)
return record
}
/**
* 根据abs_profit_id获取ABS收益审核结果表的审核数据
*/
fun addSavaLogic(iwebReq: IwebReq, absProfitId: Long?): Boolean{
//判断是否数据
var isOk = false
var dbp = DbPro.use(iwebReq.dsName)
var sql = """
SELECT
id
FROM
biz_abs_profit_approve_result
WHERE
abs_profit_id = ?
AND sys_status = 1
"""
var record= dbp.find(sql,absProfitId)
//等于true,有数据，等于false，没有数据
if(record.size > 0){
isOk = true
}
return isOk
}
/**
* 判断对应的 最大的履历编号对应的履历数据的提交状态：利用abs_profit_id 来查
*/
fun bigNumberState(iwebReq: IwebReq, absProfitId: Long?): Record{
//判断是否数据
var isOk = false
var dbp = DbPro.use(iwebReq.dsName)
var sql = """
SELECT
id,
history_no,
submit_state
FROM
biz_abs_profit_modify_history
WHERE
abs_profit_id = ?
AND sys_status = 1
ORDER BY history_no DESC
"""
var record= dbp.findFirst(sql,absProfitId)
return record
}
/**
* 根据abs_profit_id、科目ID判断是否修改了金额
*/
fun profitModifyState(iwebReq: IwebReq, absProfitId: Long?, subjectId: Int?, profit: Double?): Boolean{
//判断是否修改数据
var isOk = true
var dbp = DbPro.use(iwebReq.dsName)
var sql = """
SELECT
id,profit
FROM
biz_abs_profit_detail
WHERE
abs_profit_id = ?
and subject_id = ?
and sys_status = 1
"""
var record= dbp.findFirst(sql,absProfitId, subjectId)
// 等于true,有修改数据，等于false， 没有修改数据
if(record !=null && record.getStr("profit").equals(profit)){
isOk = false
}
return isOk
}
/**
* 查询该履历编号、ABS收益ID 下是否有该科目的履历
*/
fun isExistResume(iwebReq: IwebReq, historyNo: Int, absProfitId: Int):Record{
var dbp = DbPro.use(iwebReq.dsName)
var sql = """
SELECT
id
FROM
biz_abs_profit_modify_history
WHERE
abs_profit_id = ?
and history_no = ?
and sys_status = 1
"""
var record= dbp.findFirst(sql,absProfitId, historyNo)
return record
}
/**
* 获取对应的最大编号的履历数据
*/
fun getBigNumberResumeData (iwebReq: IwebReq,historyNo: String,absProfitId:Long ):List<Record>{
var dbp = DbPro.use(iwebReq.dsName)
//利用最大的履历编号，查询对应的id
var idSql ="""
SELECT
id,
memo
FROM
biz_abs_profit_modify_history
WHERE
history_no = ?
and abs_profit_id = ?
and submit_state = 0
and sys_status = 1
"""
var recordList = dbp.find(idSql,historyNo,absProfitId)
return recordList
}
}
