814 lines
32 KiB
JavaScript
814 lines
32 KiB
JavaScript
const { sequelize, AdjustableTang , PolicyParameterMaster , Authorization ,DoubleWhammy,DscrLeverageGrid,LeverageUsedForEligCat,ProgramMaster,CheckTypeMaster,PropertyTypeMaster,BusinessActivityMaster} = require('../models')
|
|
const {BankingNorms,BankingNorms2,CreditBureauNorms,DeviationNorms,DeviationNorms2,DeviationNorms3,DeviationNorms4,DeviationNorms5,DeviationNorms6,DeviationNorms7,FinancialsNorms,LoanEligibilityNorms,LoanEligibilityNorms2,LoanEligibilityNorms3,LoanEligibilityNorms4,PropertyNorms,PropertyNorms2,TurnoverTrendNorms } = require('../models')
|
|
const { logMsg } = require('../services/logger.js');
|
|
const policyHelper = require('../services/policy.helper');
|
|
|
|
|
|
|
|
|
|
exports.MasterDataList = async (req, res) =>
|
|
{
|
|
try
|
|
{
|
|
|
|
ProgramMasterData = await ProgramMaster.findAll({attributes:['id','program_name'],where:{is_active:1}});
|
|
CheckTypeMasterData = await CheckTypeMaster.findAll({attributes:['id','check_type'],where:{is_active:1}});
|
|
PropertyTypeMasterData = await PropertyTypeMaster.findAll({attributes:['id','property_type'],where:{is_active:1}});
|
|
BusinessActivityMasterData = await BusinessActivityMaster.findAll({attributes:['id','business_activity_name'],where:{is_active:1}});
|
|
const resData = {ProgramMaster:ProgramMasterData,CheckTypeMaster:CheckTypeMasterData,PropertyTypeMaster:PropertyTypeMasterData,BusinessActivityMaster:BusinessActivityMasterData};
|
|
|
|
res.send({'status':200,'message':"success",'data':resData});
|
|
|
|
} catch(err) {
|
|
res.send({'status':404,
|
|
message: err.message || "Some error occurred while fetching entity applicant masterdata." ,'data': "No data"
|
|
});
|
|
} //end of try catch
|
|
|
|
};
|
|
|
|
|
|
exports.createProgramData = async (req, res) =>
|
|
{
|
|
try
|
|
{
|
|
|
|
|
|
ProgramMaster.create(req.body)
|
|
.then(data => { res.send({'status':200,'message':"success",'data':data}); })
|
|
.catch(err => { res.send({'status':404,message: err.message || "Some error occurred while fetching entity applicant masterdata." ,'data': "No data" }); });
|
|
|
|
} catch(err) {
|
|
res.send({'status':404,
|
|
message: err.message || "Some error occurred while fetching entity applicant masterdata." ,'data': "No data"
|
|
});
|
|
} //end of try catch
|
|
|
|
};
|
|
|
|
exports.updateProgramData = async (req, res) =>
|
|
{
|
|
try
|
|
{
|
|
reqData = req.body;
|
|
id = reqData.id;
|
|
delete reqData.id;
|
|
|
|
ProgramMaster.update(reqData,{ where: { id: id }})
|
|
.then(data => { res.send({'status':200,'message':"success",'data':data}); })
|
|
.catch(err => { res.send({'status':404,message: err.message || "Some error occurred while fetching entity applicant masterdata." ,'data': "No data" }); });
|
|
|
|
} catch(err) {
|
|
res.send({'status':404,
|
|
message: err.message || "Some error occurred while fetching entity applicant masterdata." ,'data': "No data"
|
|
});
|
|
} //end of try catch
|
|
|
|
};
|
|
|
|
|
|
|
|
|
|
exports.createCheckTypeData = async (req, res) =>
|
|
{
|
|
try
|
|
{
|
|
|
|
|
|
CheckTypeMaster.create(req.body)
|
|
.then(data => { res.send({'status':200,'message':"success",'data':data}); })
|
|
.catch(err => { res.send({'status':404,message: err.message || "Some error occurred while fetching entity applicant masterdata." ,'data': "No data" }); });
|
|
|
|
} catch(err) {
|
|
res.send({'status':404,
|
|
message: err.message || "Some error occurred while fetching entity applicant masterdata." ,'data': "No data"
|
|
});
|
|
} //end of try catch
|
|
|
|
};
|
|
|
|
exports.updateCheckTypeData = async (req, res) =>
|
|
{
|
|
try
|
|
{
|
|
reqData = req.body;
|
|
id = reqData.id;
|
|
delete reqData.id;
|
|
|
|
CheckTypeMaster.update(reqData,{ where: { id: id }})
|
|
.then(data => { res.send({'status':200,'message':"success",'data':data}); })
|
|
.catch(err => { res.send({'status':404,message: err.message || "Some error occurred while fetching entity applicant masterdata." ,'data': "No data" }); });
|
|
|
|
} catch(err) {
|
|
res.send({'status':404,
|
|
message: err.message || "Some error occurred while fetching entity applicant masterdata." ,'data': "No data"
|
|
});
|
|
} //end of try catch
|
|
|
|
};
|
|
|
|
|
|
|
|
exports.createPropertyTypeData = async (req, res) =>
|
|
{
|
|
try
|
|
{
|
|
|
|
|
|
PropertyTypeMaster.create(req.body)
|
|
.then(data => { res.send({'status':200,'message':"success",'data':data}); })
|
|
.catch(err => { res.send({'status':404,message: err.message || "Some error occurred while fetching entity applicant masterdata." ,'data': "No data" }); });
|
|
|
|
} catch(err) {
|
|
res.send({'status':404,
|
|
message: err.message || "Some error occurred while fetching entity applicant masterdata." ,'data': "No data"
|
|
});
|
|
} //end of try catch
|
|
|
|
};
|
|
|
|
exports.updatePropertyTypeData = async (req, res) =>
|
|
{
|
|
try
|
|
{
|
|
reqData = req.body;
|
|
id = reqData.id;
|
|
delete reqData.id;
|
|
|
|
PropertyTypeMaster.update(reqData,{ where: { id: id }})
|
|
.then(data => { res.send({'status':200,'message':"success",'data':data}); })
|
|
.catch(err => { res.send({'status':404,message: err.message || "Some error occurred while fetching entity applicant masterdata." ,'data': "No data" }); });
|
|
|
|
} catch(err) {
|
|
res.send({'status':404,
|
|
message: err.message || "Some error occurred while fetching entity applicant masterdata." ,'data': "No data"
|
|
});
|
|
} //end of try catch
|
|
|
|
};
|
|
|
|
|
|
|
|
exports.createBusinessActivityData = async (req, res) =>
|
|
{
|
|
try
|
|
{
|
|
|
|
|
|
BusinessActivityMaster.create(req.body)
|
|
.then(data => { res.send({'status':200,'message':"success",'data':data}); })
|
|
.catch(err => { res.send({'status':404,message: err.message || "Some error occurred while fetching entity applicant masterdata." ,'data': "No data" }); });
|
|
|
|
} catch(err) {
|
|
res.send({'status':404,
|
|
message: err.message || "Some error occurred while fetching entity applicant masterdata." ,'data': "No data"
|
|
});
|
|
} //end of try catch
|
|
|
|
};
|
|
|
|
exports.updateBusinessActivityData = async (req, res) =>
|
|
{
|
|
try
|
|
{
|
|
reqData = req.body;
|
|
id = reqData.id;
|
|
delete reqData.id;
|
|
|
|
BusinessActivityMaster.update(reqData,{ where: { id: id }})
|
|
.then(data => { res.send({'status':200,'message':"success",'data':data}); })
|
|
.catch(err => { res.send({'status':404,message: err.message || "Some error occurred while fetching entity applicant masterdata." ,'data': "No data" }); });
|
|
|
|
} catch(err) {
|
|
res.send({'status':404,
|
|
message: err.message || "Some error occurred while fetching entity applicant masterdata." ,'data': "No data"
|
|
});
|
|
} //end of try catch
|
|
|
|
};
|
|
|
|
|
|
|
|
|
|
// select PolicyParameterMaster data
|
|
exports.PolicyMasterData = async (req, res) =>
|
|
{
|
|
try
|
|
{
|
|
sequelize.query('SELECT section_master.section , policy_parameter_master.parameter , policy_parameter_master.rules , policy_parameter_master.master_key , policy_parameter_master.data , policy_parameter_master.json , policy_parameter_master.table_name FROM policy_parameter_master JOIN section_master ON policy_parameter_master.section_id = section_master.id and section_master.is_active = 1 where policy_parameter_master.is_active = 1 ')
|
|
.then(data =>
|
|
{
|
|
res.send({'status':200,'message':"success",'data':data});
|
|
logMsg.info("Master Data List api call Success");
|
|
})
|
|
.catch(err => {
|
|
res.send({'status':404,
|
|
message: err.message || "Some error occurred while fetching entity applicant masterdata." ,'data': "No data" });
|
|
});
|
|
|
|
} catch(err) {
|
|
res.send({'status':404,
|
|
message: err.message || "Some error occurred while fetching entity applicant masterdata." ,'data': "No data"
|
|
});
|
|
} //end of try catch
|
|
|
|
};
|
|
|
|
|
|
|
|
|
|
exports.createPolicyMasterData = async (req, res) =>
|
|
{
|
|
try
|
|
{
|
|
reqData = req.body;
|
|
if(reqData.json == 1)
|
|
{
|
|
PolicyData = { }
|
|
}else { PolicyData = reqData }
|
|
|
|
PolicyParameterMaster.create(PolicyData)
|
|
.then(data => { res.send({'status':200,'message':"success",'data':data}); })
|
|
.catch(err => { res.send({'status':404,message: err.message || "Some error occurred while fetching entity applicant masterdata." ,'data': "No data" }); });
|
|
|
|
} catch(err) {
|
|
res.send({'status':404,
|
|
message: err.message || "Some error occurred while fetching entity applicant masterdata." ,'data': "No data"
|
|
});
|
|
} //end of try catch
|
|
|
|
};
|
|
|
|
|
|
|
|
exports.updatePolicyMasterData = async (req, res) =>
|
|
{
|
|
try
|
|
{
|
|
reqData = req.body;
|
|
id = reqData.id;
|
|
delete reqData.id;
|
|
if(reqData.json == 1)
|
|
{
|
|
PolicyData = { }
|
|
}else { PolicyData = reqData }
|
|
|
|
PolicyParameterMaster.update(PolicyData,{ where: { id: id }})
|
|
.then(data => { res.send({'status':200,'message':"success",'data':data}); })
|
|
.catch(err => { res.send({'status':404,message: err.message || "Some error occurred while fetching entity applicant masterdata." ,'data': "No data" }); });
|
|
|
|
} catch(err) {
|
|
res.send({'status':404,
|
|
message: err.message || "Some error occurred while fetching entity applicant masterdata." ,'data': "No data"
|
|
});
|
|
} //end of try catch
|
|
|
|
};
|
|
|
|
// select PolicyMasterChildTableData data
|
|
exports.PolicyMasterChildTableData = async (req, res) =>
|
|
{
|
|
try
|
|
{
|
|
Query = 'SELECT * FROM '+req.query.table_name+' where policy_parameter_master_id ='+req.query.master_key;
|
|
console.log(Query);
|
|
sequelize.query(Query)
|
|
.then(data =>
|
|
{
|
|
res.send({'status':200,'message':"success",'data':data[0]});
|
|
logMsg.info("Master Data List api call Success");
|
|
})
|
|
.catch(err => {
|
|
res.send({'status':404,
|
|
message: err.message || "Some error occurred while fetching entity applicant masterdata." ,'data': "No data" });
|
|
});
|
|
|
|
} catch(err) {
|
|
res.send({'status':404,
|
|
message: err.message || "Some error occurred while fetching entity applicant masterdata." ,'data': "No data"
|
|
});
|
|
} //end of try catch
|
|
|
|
};
|
|
|
|
|
|
exports.createPolicyMasterChildData = async (req, res) =>
|
|
{
|
|
try
|
|
{
|
|
modelArray = {
|
|
banking_norms:BankingNorms ,
|
|
banking_norms2:BankingNorms2,
|
|
credit_bureau_norms:CreditBureauNorms,
|
|
deviation_norms:DeviationNorms,
|
|
deviation_norms2:DeviationNorms2,
|
|
deviation_norms3:DeviationNorms3,
|
|
deviation_norms4:DeviationNorms4,
|
|
deviation_norms5:DeviationNorms5,
|
|
deviation_norms6:DeviationNorms6,
|
|
deviation_norms7:DeviationNorms7,
|
|
financials_norms:FinancialsNorms,
|
|
loan_eligibility_norms:LoanEligibilityNorms,
|
|
loan_eligibility_norms2:LoanEligibilityNorms2,
|
|
loan_eligibility_norms3:LoanEligibilityNorms3,
|
|
loan_eligibility_norms4:LoanEligibilityNorms4,
|
|
property_norms:PropertyNorms,
|
|
property_norms2:PropertyNorms2,
|
|
turnover_trend_norms:TurnoverTrendNorms }
|
|
modelName = req.query.table_name;
|
|
|
|
setTimeout(async() => {
|
|
model = modelArray[modelName] ;
|
|
model.create(req.body)
|
|
.then(data=>{ res.send({'status':200,'message':"success",'data':"No data"}); })
|
|
.catch(err=>{ res.send({'status':404,'message':"failed",'data':"No data"}); });
|
|
}, 1500);
|
|
|
|
// req.body.forEach((result, index, array) => {
|
|
// let Queryvalues = '';
|
|
// let Querycolumn = '';
|
|
// Object.keys(result).forEach((key , index , array ) => {
|
|
// //construct column name
|
|
// if(index == 0) { Querycolumn = "('"+key+"',"; }
|
|
// else if (array.length == index + 1 ) { Querycolumn += "'"+key+"')"; }
|
|
// else { Querycolumn += "'"+key+"',"; }
|
|
|
|
// //construct column value
|
|
// if(index == 0) { if (typeof result[key] === 'string' ) { Queryvalues += "('"+result[key]+"',"; } else { Queryvalues += "("+result[key]+","; } }
|
|
// else if (array.length == index + 1 ) { if (typeof result[key] === 'string' ) { Queryvalues += "'"+result[key]+"'),"; } else { Queryvalues += result[key]+"),"; } }
|
|
// else { if (typeof result[key] === 'string' ) { Queryvalues += "'"+result[key]+"',"; } else { Queryvalues += result[key]+","; } }
|
|
|
|
// //track ending of object loop.
|
|
// if(array.length == index+1)
|
|
// {
|
|
// Queryvalues = Queryvalues.slice(0, -1);
|
|
// Query = 'INSERT INTO '+req.query.table_name+' '+Querycolumn+' VALUES'+Queryvalues;
|
|
// // insert data here
|
|
// sequelize.query(Query).then(data => { logMsg.info("Insert Success"); }).catch(err => { logMsg.info("Insert Failed"); });
|
|
// }
|
|
// })
|
|
// })
|
|
|
|
|
|
} catch(err) {
|
|
res.send({'status':404,
|
|
message: err.message || "Some error occurred while fetching entity applicant masterdata." ,'data': "No data"
|
|
});
|
|
} //end of try catch
|
|
|
|
};
|
|
|
|
|
|
|
|
exports.updatePolicyMasterChildData = async (req, res) =>
|
|
{
|
|
try
|
|
{
|
|
modelArray = {
|
|
banking_norms:BankingNorms ,
|
|
banking_norms2:BankingNorms2,
|
|
credit_bureau_norms:CreditBureauNorms,
|
|
deviation_norms:DeviationNorms,
|
|
deviation_norms2:DeviationNorms2,
|
|
deviation_norms3:DeviationNorms3,
|
|
deviation_norms4:DeviationNorms4,
|
|
deviation_norms5:DeviationNorms5,
|
|
deviation_norms6:DeviationNorms6,
|
|
deviation_norms7:DeviationNorms7,
|
|
financials_norms:FinancialsNorms,
|
|
loan_eligibility_norms:LoanEligibilityNorms,
|
|
loan_eligibility_norms2:LoanEligibilityNorms2,
|
|
loan_eligibility_norms3:LoanEligibilityNorms3,
|
|
loan_eligibility_norms4:LoanEligibilityNorms4,
|
|
property_norms:PropertyNorms,
|
|
property_norms2:PropertyNorms2,
|
|
turnover_trend_norms:TurnoverTrendNorms }
|
|
modelName = req.query.table_name;
|
|
|
|
setTimeout(async() => {
|
|
model = modelArray[modelName] ;
|
|
id = req.body.id;
|
|
delete req.body.id;
|
|
model.update(req.body,{ where: { id: id }})
|
|
.then(data=>{ res.send({'status':200,'message':"success",'data':"No data"}); })
|
|
.catch(err=>{ res.send({'status':404,'message':"failed",'data':"No data"}); });
|
|
}, 1500);
|
|
|
|
|
|
|
|
} catch(err) {
|
|
res.send({'status':404,
|
|
message: err.message || "Some error occurred while fetching entity applicant masterdata." ,'data': "No data"
|
|
});
|
|
} //end of try catch
|
|
|
|
};
|
|
|
|
|
|
// select DoubleWhammy data
|
|
exports.DoubleWhammyDataList = async (req, res) =>
|
|
{
|
|
try
|
|
{
|
|
DoubleWhammy.findAll({raw:true, include:[{ model: ProgramMaster,attributes:['program_name'] },{ model: CheckTypeMaster,attributes:['check_type'] },{ model: PropertyTypeMaster,attributes:['property_type'] }] })
|
|
.then(data =>
|
|
{
|
|
res.send({'status':200,'message':"success",'data':data});
|
|
logMsg.info("Master Data List api call Success");
|
|
})
|
|
.catch(err => {
|
|
res.send({'status':404,
|
|
message: err.message || "Some error occurred while fetching entity applicant masterdata." ,'data': "No data" });
|
|
});
|
|
|
|
} catch(err) {
|
|
res.send({'status':404,
|
|
message: err.message || "Some error occurred while fetching entity applicant masterdata." ,'data': "No data"
|
|
});
|
|
} //end of try catch
|
|
|
|
};
|
|
exports.createDoubleWhammy = async (req, res) =>
|
|
{
|
|
try
|
|
{
|
|
|
|
DoubleWhammyData = req.body;
|
|
for(const DoubleWhammyDataValue of DoubleWhammyData)
|
|
{
|
|
|
|
await DoubleWhammy.create(DoubleWhammyDataValue)
|
|
.then(async(data) =>{
|
|
logMsg.info("create Success DoubleWhammy , id = "+id);
|
|
|
|
}).catch(err=>{ logMsg.info("create Failed DoubleWhammy , id = "+id); });
|
|
|
|
}
|
|
setTimeout(() => {
|
|
res.send({'status':200,'message':"success",'data':"No data"});
|
|
}, 1500);
|
|
|
|
} catch(err) {
|
|
res.send({'status':404,message: err.message || "Some error occurred while updating BankCredits." ,'data': "No data" });
|
|
} //end of try catch
|
|
|
|
};
|
|
exports.updateDoubleWhammy = async (req, res) =>
|
|
{
|
|
try
|
|
{
|
|
// Multiple update
|
|
DoubleWhammyData = req.body;
|
|
for(const DoubleWhammyDataValue of DoubleWhammyData)
|
|
{
|
|
id = DoubleWhammyDataValue.id;
|
|
delete DoubleWhammyDataValue.id;
|
|
await DoubleWhammy.update(DoubleWhammyDataValue,{ where: { id: id }})
|
|
.then(async(data) =>{
|
|
logMsg.info("Update Success DoubleWhammy , id = "+id);
|
|
|
|
}).catch(err=>{ logMsg.info("Update Failed DoubleWhammy , id = "+id); });
|
|
|
|
}
|
|
setTimeout(() => {
|
|
res.send({'status':200,'message':"success",'data':"No data"});
|
|
}, 1500);
|
|
|
|
} catch(err) {
|
|
res.send({'status':404,message: err.message || "Some error occurred while updating BankCredits." ,'data': "No data" });
|
|
} //end of try catch
|
|
|
|
};
|
|
|
|
|
|
|
|
exports.DscrLeverageGridDataList = async (req, res) =>
|
|
{
|
|
try
|
|
{
|
|
|
|
VanillaArray = [];
|
|
OtherThenVanillaArray = [];
|
|
data = [ { program : "Vanilla" , child : VanillaArray } , { program : "OtherThenVanilla" , child : OtherThenVanillaArray}];
|
|
|
|
groupByData = await DscrLeverageGrid.findAll({attributes:['program_id','business_activity_id'],group: ["program_id","business_activity_id"] });
|
|
for(const groupByDataValue of groupByData)
|
|
{
|
|
// if(groupByDataValue.program_id == 1 )
|
|
// {
|
|
// VanillaData = await DscrLeverageGrid.findAll({raw:true,where:{program_id : 1 ,business_activity_id : groupByDataValue.business_activity_id }, include:[{ model: ProgramMaster,attributes:['program_name'] },{ model: BusinessActivityMaster,attributes:['business_activity_name'] }] });
|
|
// VanillaArray.push(VanillaData);
|
|
// }
|
|
// else{
|
|
// OtherThenVanillaData = await DscrLeverageGrid.findAll({raw:true,where:{program_id : 8,business_activity_id : groupByDataValue.business_activity_id}, include:[{ model: ProgramMaster,attributes:['program_name'] },{ model: BusinessActivityMaster,attributes:['business_activity_name'] }] });
|
|
// OtherThenVanillaArray.push(OtherThenVanillaData);
|
|
// }
|
|
if(groupByDataValue.program_id == 1 )
|
|
{
|
|
leverageData = await DscrLeverageGrid.findAll({where:{program_id : 1 ,business_activity_id : groupByDataValue.business_activity_id }, attributes:['program_id','business_activity_id','leverage'],group: ["program_id","business_activity_id","leverage"]});
|
|
leverageDataArray = [];
|
|
for(const leverageDataValue of leverageData)
|
|
{
|
|
VanillaData = await DscrLeverageGrid.findAll({raw:true,where:{program_id : 1 ,business_activity_id : leverageDataValue.business_activity_id , leverage : leverageDataValue.leverage }, include:[{ model: ProgramMaster,attributes:['program_name'] },{ model: BusinessActivityMaster,attributes:['business_activity_name'] }] });
|
|
console.log(VanillaData[0]);
|
|
childObj = { data : VanillaData };
|
|
obj = {...leverageDataValue.dataValues, ...childObj};
|
|
leverageDataArray.push(obj);
|
|
}
|
|
VanillaArray.push(leverageDataArray);
|
|
}
|
|
else{
|
|
leverageData = await DscrLeverageGrid.findAll({where:{program_id : 8 ,business_activity_id : groupByDataValue.business_activity_id }, attributes:['program_id','business_activity_id','leverage'],group: ["program_id","business_activity_id","leverage"]});
|
|
leverageArray = [];
|
|
for(const leverageValue of leverageData)
|
|
{
|
|
OtherThenVanillaData = await DscrLeverageGrid.findAll({raw:true,where:{program_id : 8 ,business_activity_id : leverageValue.business_activity_id , leverage : leverageValue.leverage }, include:[{ model: ProgramMaster,attributes:['program_name'] },{ model: BusinessActivityMaster,attributes:['business_activity_name'] }] });
|
|
childObj = { data : OtherThenVanillaData };
|
|
obj = {...leverageValue.dataValues, ...childObj};
|
|
leverageArray.push(obj);
|
|
}
|
|
OtherThenVanillaArray.push(leverageArray);
|
|
}
|
|
|
|
}
|
|
|
|
|
|
res.send({'status':200,'message':"success",'data':data});
|
|
|
|
|
|
} catch(err) {
|
|
res.send({'status':404,
|
|
message: err.message || "Some error occurred while fetching entity applicant masterdata." ,'data': "No data"
|
|
});
|
|
} //end of try catch
|
|
|
|
};
|
|
exports.createDscrLeverageGrid = async (req, res) =>
|
|
{
|
|
try
|
|
{
|
|
|
|
DscrLeverageGridData = req.body;
|
|
for(const DscrLeverageGridDataValue of DscrLeverageGridData)
|
|
{
|
|
|
|
await DscrLeverageGrid.create(DscrLeverageGridDataValue)
|
|
.then(async(data) =>{
|
|
logMsg.info("create Success DoubleWhammy , id = "+id);
|
|
|
|
}).catch(err=>{ logMsg.info("create Failed DoubleWhammy , id = "+id); });
|
|
|
|
}
|
|
setTimeout(() => {
|
|
res.send({'status':200,'message':"success",'data':"No data"});
|
|
}, 1500);
|
|
|
|
} catch(err) {
|
|
res.send({'status':404,message: err.message || "Some error occurred while updating BankCredits." ,'data': "No data" });
|
|
} //end of try catch
|
|
|
|
};
|
|
exports.updateDscrLeverageGrid = async (req, res) =>
|
|
{
|
|
try
|
|
{
|
|
// Multiple update
|
|
DscrLeverageGridData = req.body;
|
|
for(const DscrLeverageGridDataValue of DscrLeverageGridData)
|
|
{
|
|
id = DscrLeverageGridDataValue.id;
|
|
delete DscrLeverageGridDataValue.id;
|
|
await DscrLeverageGrid.update(DscrLeverageGridDataValue,{ where: { id: id }})
|
|
.then(async(data) =>{
|
|
logMsg.info("Update Success DoubleWhammy , id = "+id);
|
|
|
|
}).catch(err=>{ logMsg.info("Update Failed DoubleWhammy , id = "+id); });
|
|
|
|
}
|
|
setTimeout(() => {
|
|
res.send({'status':200,'message':"success",'data':"No data"});
|
|
}, 1500);
|
|
|
|
} catch(err) {
|
|
res.send({'status':404,message: err.message || "Some error occurred while updating BankCredits." ,'data': "No data" });
|
|
} //end of try catch
|
|
|
|
};
|
|
|
|
exports.LeverageUsedForEligCatDataList = async (req, res) =>
|
|
{
|
|
try
|
|
{
|
|
|
|
Vanilla = await LeverageUsedForEligCat.findAll({raw:true,where:{program_id : 1}, include:[{ model: ProgramMaster,attributes:['program_name'] },{ model: BusinessActivityMaster,attributes:['business_activity_name'] }] })
|
|
OtherThenVanilla = await LeverageUsedForEligCat.findAll({raw:true,where:{program_id : 8}, include:[{ model: ProgramMaster,attributes:['program_name'] },{ model: BusinessActivityMaster,attributes:['business_activity_name'] }] })
|
|
|
|
data = {Vanilla : Vanilla , OtherThenVanilla : OtherThenVanilla};
|
|
|
|
res.send({'status':200,'message':"success",'data':data});
|
|
|
|
} catch(err) {
|
|
res.send({'status':404,
|
|
message: err.message || "Some error occurred while fetching entity applicant masterdata." ,'data': "No data"
|
|
});
|
|
} //end of try catch
|
|
|
|
};
|
|
|
|
exports.createLeverageUsedForEligCat = async (req, res) =>
|
|
{
|
|
try
|
|
{
|
|
|
|
LeverageUsedForEligCatData = req.body;
|
|
for(const LeverageUsedForEligCatValue of LeverageUsedForEligCatData)
|
|
{
|
|
|
|
await LeverageUsedForEligCat.create(LeverageUsedForEligCatValue)
|
|
.then(async(data) =>{
|
|
logMsg.info("create Success DoubleWhammy , id = "+id);
|
|
|
|
}).catch(err=>{ logMsg.info("create Failed DoubleWhammy , id = "+id); });
|
|
|
|
}
|
|
setTimeout(() => {
|
|
res.send({'status':200,'message':"success",'data':"No data"});
|
|
}, 1500);
|
|
|
|
} catch(err) {
|
|
res.send({'status':404,message: err.message || "Some error occurred while updating BankCredits." ,'data': "No data" });
|
|
} //end of try catch
|
|
|
|
};
|
|
exports.updateLeverageUsedForEligCat = async (req, res) =>
|
|
{
|
|
try
|
|
{
|
|
// Multiple update
|
|
LeverageUsedForEligCatData = req.body;
|
|
for(const LeverageUsedForEligCatValue of LeverageUsedForEligCatData)
|
|
{
|
|
id = LeverageUsedForEligCatValue.id;
|
|
delete LeverageUsedForEligCatValue.id;
|
|
await LeverageUsedForEligCat.update(LeverageUsedForEligCatValue,{ where: { id: id }})
|
|
.then(async(data) =>{
|
|
logMsg.info("Update Success DoubleWhammy , id = "+id);
|
|
|
|
}).catch(err=>{ logMsg.info("Update Failed DoubleWhammy , id = "+id); });
|
|
|
|
}
|
|
setTimeout(() => {
|
|
res.send({'status':200,'message':"success",'data':"No data"});
|
|
}, 1500);
|
|
|
|
} catch(err) {
|
|
res.send({'status':404,message: err.message || "Some error occurred while updating BankCredits." ,'data': "No data" });
|
|
} //end of try catch
|
|
|
|
};
|
|
|
|
|
|
|
|
|
|
// select AdjustableTang data
|
|
exports.AdjustableTang = async (req, res) =>
|
|
{
|
|
try
|
|
{
|
|
AdjustableTang.findAll({ where : { is_active : 1}}).then(data =>
|
|
{
|
|
res.send({'status':200,'message':"success",'data':data});
|
|
logMsg.info("Master Data List api call Success");
|
|
})
|
|
.catch(err => {
|
|
res.send({'status':404,
|
|
message: err.message || "Some error occurred while fetching entity applicant masterdata." ,'data': "No data" });
|
|
});
|
|
|
|
} catch(err) {
|
|
res.send({'status':404,
|
|
message: err.message || "Some error occurred while fetching entity applicant masterdata." ,'data': "No data"
|
|
});
|
|
} //end of try catch
|
|
|
|
};
|
|
|
|
|
|
|
|
exports.createAdjustableTang = async (req, res) =>
|
|
{
|
|
try
|
|
{
|
|
|
|
AdjustableTangDataArray = req.body;
|
|
for(const AdjustableTangValue of AdjustableTangDataArray)
|
|
{
|
|
|
|
await AdjustableTang.create(AdjustableTangValue)
|
|
.then(async(data) =>{
|
|
logMsg.info("create Success DoubleWhammy , id = "+id);
|
|
|
|
}).catch(err=>{ logMsg.info("create Failed DoubleWhammy , id = "+id); });
|
|
|
|
}
|
|
setTimeout(() => {
|
|
res.send({'status':200,'message':"success",'data':"No data"});
|
|
}, 1500);
|
|
|
|
} catch(err) {
|
|
res.send({'status':404,message: err.message || "Some error occurred while updating BankCredits." ,'data': "No data" });
|
|
} //end of try catch
|
|
|
|
};
|
|
exports.updateAdjustableTang = async (req, res) =>
|
|
{
|
|
try
|
|
{
|
|
// Multiple update
|
|
AdjustableTangDataArray = req.body;
|
|
for(const AdjustableTangValue of AdjustableTangDataArray)
|
|
{
|
|
id = AdjustableTangValue.id;
|
|
delete AdjustableTangValue.id;
|
|
await AdjustableTang.update(AdjustableTangValue,{ where: { id: id }})
|
|
.then(async(data) =>{
|
|
logMsg.info("Update Success DoubleWhammy , id = "+id);
|
|
|
|
}).catch(err=>{ logMsg.info("Update Failed DoubleWhammy , id = "+id); });
|
|
|
|
}
|
|
setTimeout(() => {
|
|
res.send({'status':200,'message':"success",'data':"No data"});
|
|
}, 1500);
|
|
|
|
} catch(err) {
|
|
res.send({'status':404,message: err.message || "Some error occurred while updating BankCredits." ,'data': "No data" });
|
|
} //end of try catch
|
|
|
|
};
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
// select TokenApi data
|
|
exports.TokenApi = async (req, res) =>
|
|
{
|
|
try
|
|
{
|
|
Authorization.findOne({where : { is_active : 1}}).then(async(data) =>
|
|
{
|
|
updated_date = new Date(data.updatedAt).toISOString().slice(0, 10);
|
|
current_date = new Date().toISOString().slice(0, 10);
|
|
if (updated_date == current_date )
|
|
{
|
|
res.send({'status':200,'message':"success",'data':data});
|
|
}
|
|
else
|
|
{
|
|
new_token = await policyHelper.NewToken();
|
|
await Authorization.update({token : new_token},{where : {id : 1}})
|
|
.catch(err=> {res.send({'status':404,
|
|
message: err.message || "Some error occurred while fetching entity applicant masterdata." ,'data': "No data" });
|
|
})
|
|
token_data = await Authorization.findOne({where : { is_active : 1}})
|
|
res.send({'status':200,'message':"success",'data':token_data});
|
|
}
|
|
})
|
|
.catch(err => {
|
|
res.send({'status':404,
|
|
message: err.message || "Some error occurred while fetching entity applicant masterdata." ,'data': "No data" });
|
|
});
|
|
|
|
} catch(err) {
|
|
res.send({'status':404,
|
|
message: err.message || "Some error occurred while fetching entity applicant masterdata." ,'data': "No data"
|
|
});
|
|
} //end of try catch
|
|
|
|
};
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|