提交并返回
__tbpkdfcmhJKEy8hr5hu
__EgAe5Oz8dxeuAZQOhmW
13
default
"+uuid)
if(!isNotNull(uuid)){
return '审核失败，请联系管理员！'
}
var doc=getCurrentDocument();
var tk_people=getItemValueAsString("name")
var tk_idCardNo=getItemValueAsString("idCardNo")
println("tk_idCardNo-------------22222"+tk_idCardNo);
println("tk_people---------->"+tk_people)
var isTrue = doc.getItemValueAsString("isTrue");
if(!isNotNull(isTrue)){
println("没进来???")
return "请勾选材料审核通过或未通过！"
}
var applyId2 = getId();
var now = getToday();
var bizOrderNo =format(now, "yyyyMMddHHmmss");
var materialApproveFailReason = doc.getItemValueAsString("materialApproveFailReason");
if("0".equals(isTrue)) {
var applyInfoDoc2 = findDocument(applyId2);
var uuid2 = applyInfoDoc2.findItem("orderId").getValue();
var namme = applyInfoDoc2.findItem("name").getValue();
var today = getToday();
var sqlp = "select id from tlk_apply_person_refund where item_orderid = '"+uuid2+"' and item_isdelete != '1' and item_refundstate != '2'";
var datastwo = queryByDSName("tms",sqlp);
if(!"[]".equals(datastwo)){
return "该人员已退款，请勿重复提交";
}
if("".equals(materialApproveFailReason)){
return "审核不通过原因必须填写！";
}else{
/*
设置约束，防止多次点击提交
*/
var applyId = getId();
var applyInfo = findDocument(applyId);
var orderId = applyInfo.findItem("orderId").getValue();
var orderInfo = findDocument(orderId);
println("orderId----------------"+orderId);
println("orderInfo----------------"+orderInfo);
var trainId = applyInfo.findItem("trainId").getValue();
var learnId = applyInfo.findItem("learnId").getValue();
var amount = orderInfo.findItem("price").getValue();
//if(amount>0){
// var result = payChack2(amount);
//注释这里
// if("success".equals(result)){
// }else{
// return "平台费用不足，材料审核不通过失败！！！"
// }
// }
var bcx = orderInfo.findItem("pt_money").getValue();
var price = orderInfo.findItem("price").getValue();
if(price>0){
var sqlPayId = "select comId from com_base_info where tlkComId='" + trainId + "'";
println("id--->"+sqlPayId);
var sqlOrderId = "select comId from com_base_info where tlkComId='" + learnId + "'";
var datasPayId = queryByDSName("pay", sqlPayId);
var datasOrderId = queryByDSName("pay", sqlOrderId);
// println("datasId-->"+datasId);
if (datasPayId.size() > 0) {
for (var iterator = datasPayId.iterator(); iterator.hasNext();) {
var map1 = iterator.next();//取值
var comidPay = map1.get("comid");//获取本企业的id
//println("取到公司id")
}
} else {
return "请联系管理员，完善本企业信息！";
}
if (datasOrderId.size() > 0) {
for (var iteratora = datasOrderId.iterator(); iteratora.hasNext();) {
var map2 = iteratora.next();//取值
var comidOrder = map2.get("comid");//获取保安公司企业的id
}
}else {
return "请联系管理员或选择的保安公司，完善保安公司企业信息！";
}
if (comidOrder.equals(comidPay)) {
println("进入了相同的企业分支")
var ss = payChack(learnId, trainId, amount, comidOrder, comidPay);
println("payChack返回了"+ss)
if ("success".equals(ss)) {
} else {
return ss;
}
} else {
println("进入了不同的企业分支")
var ss = payChack(learnId, trainId, amount, comidOrder, comidPay);
println("payChack返回了"+ss)
if ("success".equals(ss)) {
} else {
return ss;
}
}
println("到这里了吗！！！！！！！")
}//注释这里
}
}else{
/*
设置约束，防止多次点击提交
*/
}
try{
var uuid = getItemValueAsString("uuid");
var dd2 = ""//培训公司与平台的流水号
var aa2 = ""//培训公司与保安公司的流水号
var tk_people=getItemValueAsString("name")
var tk_idCardNo=getItemValueAsString("idCardNo")
println("tk_idCardNo-------------22222"+tk_idCardNo);
println("tk_people---------->"+tk_people)
var userid = getWebUser().getId();//当前登入账号的id，用于发送站内信
println("userid-------------------------------->"+userid)
var securityId = getItemValueAsString("securityId");
var now = getToday();
var CurrentTime=format(now,"yyyy-MM");//当前时间 格式化为月份
var formservice = getFormProcess();
var applyId = getId();
var isTrue = getItemValueAsString("isTrue");
println("isTrue-------------------------"+isTrue)
var materialApproveFailReason = getItemValueAsString("materialApproveFailReason");
var idCardNo = getItemValueAsString("idCardNo");
var name = getItemValueAsString("name");
var trainId = getItemValueAsString("trainId");
var learnId = getItemValueAsString("learnId");
println("learnId---------------"+learnId);
var formProcess = getFormProcess();
var subform = formProcess.doView("__gNT3M19at3mtDJdRHXX");
var learnName = getItemValueAsString("learnName");
var trainName = getItemValueAsString("trainName");
var trainSelectId = trainId;
var conName = learnName ;
var domainid = learnId;
var peixunName = trainName;
var materialApproveDate = format(getToday(),"yyyy-MM-dd HH:mm:ss")
println(materialApproveDate);
var materialApprovePerName = getItemValueAsString("materialApprovePerName");
println(materialApprovePerName);
var materialApprovePerIdCardNo = getItemValueAsString("materialCardNo");
println(materialApprovePerIdCardNo);
var now = getToday();
var CurrentTime=format(now,"yyyy-MM");;//当前时间 格式化为月份
var process = getDocumentProcess();
var applyInfo = findDocument(applyId);
println("applyId------------------------"+applyId)
var orderId = applyInfo.findItem("orderId").getValue();
var orderInfo = findDocument(orderId);
println("orderId--------------->"+orderId)
var amount = orderInfo.findItem("price").getValue();
var bcx = orderInfo.findItem("pt_money").getValue();
var pt_money=orderInfo.findItem("pt_money").getValue();//平台服务费
var price = orderInfo.findItem("price").getValue();//费用
var lessonId = orderInfo.findItem("lessonId").getValue();
var lessonName = orderInfo.findItem("lessonName").getValue();
var phone = orderInfo.findItem("mobile").getValue();
var biaoshi1 = orderInfo.findItem("biaoshi1").getValue();
var biaoshi2 = orderInfo.findItem("biaoshi2").getValue();
var CID = orderInfo.findItem("com_ID").getValue();
var PID = orderInfo.findItem("PID").getValue();
var pt_money = orderInfo.findItem("pt_money").getValue();
var form_p_settlement = orderInfo.findItem("form_p_settlement").getValue();
var pay_type = orderInfo.findItem("pay_type").getValue();
var Billing_methods = orderInfo.findItem("Billing_methods").getValue();
var Billing_methods2 = orderInfo.findItem("Billing_methods2").getValue();
var Coping_money = orderInfo.findItem("Coping_money").getValue();
var Coping_p_money = orderInfo.findItem("Coping_p_money").getValue();
var orderName = orderInfo.findItem("orderName").getValue();
var Form_settlement = orderInfo.findItem("Form_settlement").getValue();
if("0".equals(isTrue)) {//不通过
println("phone------------------------"+phone)
println("lessonName------------------------"+lessonName)
var slq=" select ID from tlk_training_table where item_peixunID='"+trainSelectId+"'and date_format(created,'%Y-%m')='"+CurrentTime+"' " ;//or (item_my_domainID='"+domainid+"' and item_companyID='__iZjB3As6MOfttXkZTXo' and date_format(created,'%Y-%m')='"+CurrentTime+"')
println("slq--------------------------->"+slq);
var datas6 = queryByDSName("tms",slq);
println("datas6--------------------------->"+datas6);
if(datas6=="[]"){//无数据的时候 新建
println("进到创建数据了？？？？？？？")
println("公司是同一个不会创建保安和培训数据 这边直接走创建平台数据");
//创建培训公司和平台之间的数据
//意味着收票方是自己 即使保安公司也是培训机构 开票方是平台
var bcxInfo = formservice.doView("__sveeIxudIagr9knJk12");//
println("bcxInfo"+bcxInfo);
println("formservice"+formservice);
var bcxInfoDoc = process.doNew(bcxInfo, getWebUser(), createParamsTable());
println("2");
bcxInfoDoc.addStringItem("my_domainID", domainid);//当前组织域id
bcxInfoDoc.addStringItem("my_domainName", conName);//当前企业域名称
bcxInfoDoc.addStringItem("K_trueStatus", "1");//开票方确认状态
bcxInfoDoc.addStringItem("S_Status", "1");//收票方确认状态
bcxInfoDoc.addStringItem("Kai_type", "1");//开票状态
bcxInfoDoc.addStringItem("type", "1");// 我方应收？？（只能去sql 判断）
bcxInfoDoc.addStringItem("platformid", "__iZjB3As6MOfttXkZTXo");// 平台id
bcxInfoDoc.addStringItem("platform", "1"); //平台类型
bcxInfoDoc.addStringItem("companyID","__iZjB3As6MOfttXkZTXo");//开票方当前平台
bcxInfoDoc.addStringItem("companyName","百川信（北京）信息服务有限公司");//开票方当前平台
bcxInfoDoc.addStringItem("peixunName", peixunName);////收票方是培训机构
bcxInfoDoc.addStringItem("peixunID",trainSelectId);//收票方是培训机构
//bcxInfoDoc.addStringItem("companytype", companytype);//保安公司类型
//bcxInfoDoc.addStringItem("traintype", traintype);// 培训公司类型
bcxInfoDoc.addStringItem("isTrue", "1");//开起平台收费
bcxInfoDoc.addStringItem("money", "10");//平台收取费用
if("1".equals(form_p_settlement)){
bcxInfoDoc.addStringItem("biaoshi", "1");//平台收取费用
}
println(bcxInfoDoc);
process.doCreate(bcxInfoDoc);
//这条数据的id 将来用做业务id
PID=bcxInfoDoc.getId()
println("进来了吗？？？？？？PID------------"+PID)
}else{//表示查到了数据,业务id,是肯定存在的也就是PID,学员那边cid可能会没有就是null,
if("1".equals(form_p_settlement)){
var slqq=" update tlk_training_table set item_biaoshi = '1' where item_peixunID='"+trainSelectId+"'and date_format(created,'%Y-%m')='"+CurrentTime+"' "
println("slqq-------------------"+slqq)
updateByDSName("tms",slqq);
}
println("表示查到了数据")
var iterator = datas6.iterator();
if(iterator.hasNext()){
var map3 = iterator.next();
PID= map3.get("ID");
}
}
var sql2="select ID from tlk_Reconciliation_table where item_my_domainID='"+domainid+"' and item_companyID='"+trainSelectId+"' and date_format(created,'%Y-%m')='"+CurrentTime+"' "
var datas7 = queryByDSName("tms",sql2);
println("datas7--------------------------->"+datas7);
if(datas7=="[]"){
if(!domainid.equals(trainSelectId)){
println("公司不是同一个");
//创建保安公司和培训公司的数据
var comInfo = formservice.doView("__id1XYDTMK5gXL4wCigC");
var comInfoDoc = process.doNew(comInfo, getWebUser(), createParamsTable());
comInfoDoc.addStringItem("my_domainID", domainid);//当前组织域id
comInfoDoc.addStringItem("my_domainName", conName);//当前企业域名称
comInfoDoc.addStringItem("K_trueStatus", "1");//开票方确认状态
comInfoDoc.addStringItem("S_Status", "1");//收票方确认状态
comInfoDoc.addStringItem("Kai_type", "1");//开票状态
comInfoDoc.addStringItem("type", "1");// 我方应收？？（只能去sql 判断）
comInfoDoc.addStringItem("platformid", "__iZjB3As6MOfttXkZTXo");// 平台id
comInfoDoc.addStringItem("platform", "1"); //平台类型
comInfoDoc.addStringItem("companyID", trainSelectId);//开票方当前培训机构的企业域id
comInfoDoc.addStringItem("companyName", peixunName);//开票方当前培训机构的企业域名称
comInfoDoc.addStringItem("peixunName",conName);//收票方当前企业域名称
comInfoDoc.addStringItem("peixunID", domainid);//收票方当前企业域id
//comInfoDoc.addStringItem("companytype", companytype);//保安公司类型
//comInfoDoc.addStringItem("traintype", traintype);// 培训公司类型
comInfoDoc.addStringItem("isTrue", "0");//关闭平台收费
comInfoDoc.addStringItem("b_Business_id",PID);//加一个培训表与平台的id
if("1".equals(Form_settlement)){
comInfoDoc.addStringItem("biaoshi", "1");
}
println(comInfoDoc);
process.doCreate(comInfoDoc);
CID=comInfoDoc.getId()
println("进来了吗？？？？？？CID------------"+CID)
}
}else{
if("1".equals(Form_settlement)){
var slqq=" update tlk_Reconciliation_table set item_biaoshi = '1' where item_my_domainID='"+domainid+"' and item_companyID='"+trainSelectId+"' and date_format(created,'%Y-%m')='"+CurrentTime+"' "
updateByDSName("tms",slqq);
}
println("表示查到了数据")
var iterator4 = datas7.iterator();
if(iterator4.hasNext()){
var map4 = iterator4.next();
CID= map4.get("ID");
}
}
}
//审核通过
if ("1".equals(isTrue)) {
var domainid = getDomainid();
var IsAuthorizeCourses = applyInfo.findItem("IsAuthorizeCourses").getValue();
println("判断");
if ("1".equals(IsAuthorizeCourses)) {
var today = getToday();
var endMonth = getMonth(today) < 10 ? "0" + getMonth(today) : getMonth(today);
var endDay = getDay(today) < 10 ? "0" + getDay(today) : getDay(today);
var endDate = (getYear(today) + 1) + "-" + endMonth + "-" + endDay;
println("hhhhhhhhhhhhhhhhhhh");
applyInfo.findItem("materialApproveStatus").setValue("1");
applyInfo.findItem("messageStatus").setValue("0");//通知状态改成（通知为默认0）
applyInfo.findItem("senderId").setValue(userid);//作于站内信的发送者
println("----------------------------------------------》到这？")
var progress = 0;
var authLessonName = orderInfo.findItem("orderName").getValue();
var authLessonId = orderInfo.findItem("lessonId").getValue();
var sqlLesson = "select MAX(ITEM_PROGRESS) as progress from tlk_lesson_auth_base_info where ITEM_AUTHUSERID='" + idCardNo + "' and item_AUTHLESSONID='" + authLessonId + "' and item_isProgress='1' ";
println("sqlLesson" + sqlLesson);
var datasLesson = queryByDSName("tms", sqlLesson);
//判断是否有相同的历史课程
if (datasLesson.size() > 0) {
for (var iteratorLesson = datasLesson.iterator(); iteratorLesson.hasNext();) {
var map2 = iteratorLesson.next();//取值
progress = map2.get("progress");
println("progress" + progress);
}
}
var formProcess = getFormProcess();
var authInfo = formProcess.doView("__t8b3WI9MCRgmpSycGIZ");
var authInfoDoc = process.doNew(authInfo, getWebUser(), createParamsTable());
authInfoDoc.addStringItem("AUTHLESSONNAME", authLessonName);
authInfoDoc.addStringItem("AUTHLESSONID", authLessonId);
authInfoDoc.addStringItem("AUTHUSERID", idCardNo);
authInfoDoc.addStringItem("authRecordId", applyId);
authInfoDoc.addStringItem("AUTHUSERNAME", name);
authInfoDoc.addStringItem("validityDate", endDate);
authInfoDoc.addStringItem("learnPermission", "1");
authInfoDoc.addStringItem("learnId", learnId);//
authInfoDoc.addStringItem("learnName", learnName);
authInfoDoc.addStringItem("trainName", trainName);
authInfoDoc.addStringItem("trainId", trainId);
authInfoDoc.addStringItem("learnStyle", "2");
authInfoDoc.addStringItem("isProgress", 1);
authInfoDoc.addDoubleItem("progress", parseDouble(progress));
println(authInfoDoc);
process.doCreate(authInfoDoc);
var sql2="update tlk_grade_internship set item_internid='"+applyId+"' where item_idcardno = '"+idCardNo+"' and item_isdelete != '1'";
updateByDSName("tms",sql2);
} else {//是否需要授权课程
println("----------------------------------------------》还是到这？")
applyInfo.findItem("materialApproveStatus").setValue("1");
}
applyInfo.findItem("messageStatus").setValue("0");//通知状态改成（通知默认为0）
applyInfo.findItem("senderId").setValue(userid);//作于站内信的发送者
println("----------------------------------------------》2还是到这？")
} else if("0".equals(isTrue)) {
// 退款时更新learn_order_person 的 item_index 字段
updateByDSName("tms","update tlk_learn_order_person set item_index = now() where item_appid = '" + applyId + "'");
var doc = process.doNew(subform,getWebUser(),createParamsTable());
var OID = doc.getId();
if("0".equals(isTrue)&&price>0 ){//审核不通过才会进行退款
//注释这里
var sqlPayId = "select comId from com_base_info where tlkComId='" + trainId + "'";
println("id--->"+sqlPayId);
var sqlOrderId = "select comId from com_base_info where tlkComId='" + learnId + "'";
var datasPayId = queryByDSName("pay", sqlPayId);
var datasOrderId = queryByDSName("pay", sqlOrderId);
// println("datasId-->"+datasId);
if (datasPayId.size() > 0) {
for (var iterator = datasPayId.iterator(); iterator.hasNext();) {
var map1 = iterator.next();//取值
var comidPay = map1.get("comid");//获取本企业的id
//println("取到公司id")
}
} else {
return "请联系管理员，完善本企业信息！";
}
if (datasOrderId.size() > 0) {
for (var iteratora = datasOrderId.iterator(); iteratora.hasNext();) {
var map2 = iteratora.next();//取值
var comidOrder = map2.get("comid");//获取保安公司企业的id
}
}else {
return "请联系管理员或选择的保安公司，完善保安公司企业信息！";
}
if (comidOrder.equals(comidPay)) {//已将该动作迁移至动作执行后
println("进入了相同的企业分支")
var ss = payChack(learnId, trainId, amount, comidOrder, comidPay);
println("payChack返回了"+ss)
if ("success".equals(ss)) {
var userName = getWebUser().getName();
var businessCode = "01003";
var dd = payPlatform(comidPay, comidOrder, amount, OID, userName, bcx, 1,tk_people,tk_idCardNo,businessCode)
dd2 = dd.substring(8,dd.length);//培训公司与平台的流水号
println("payPlatform返回了"+dd)
if (dd.indexOf("success")>=0) {
} else {
return dd;
}
} else {
return ss;
}
} else {
println("进入了不同的企业分支")
var ss = payChack(learnId, trainId, amount, comidOrder, comidPay);
println("payChack返回了"+ss)
if ("success".equals(ss)) {
var businessCode = "01003";
var aa = payFunction(comidPay, comidOrder, amount, OID, userName, bcx, 1,tk_people,tk_idCardNo,orderrName,orderName,businessCode);
aa2 = aa.substring(8,aa.length);//培训公司与保安公司的流水号
println("payFunction返回了"+aa)
if (aa.indexOf("success")>=0) {
// var businessCode = "01904";
// var dd = payPlatform(comidPay, comidOrder, amount, OID, userName, bcx, 1,tk_people,tk_idCardNo,orderName,businessCode);
// dd2 = dd.substring(8,dd.length);//培训公司与平台的流水号
// println("payPlatform返回了"+dd)
// if (dd.indexOf("success")>=0) {
// }else {
// println("payPlatform---"+dd);
// return "材料审核失败，请联系管理员处理！！"+dd
// }
}
else {
println("payFunction---"+aa);
return "材料审核失败，请联系管理员处理！！"+aa
}
} else {
println("paycheck----"+ss);
return "材料审核失败，请联系管理员处理！！"+ss
}
}
}
println("CID错------------------"+CID);
println("PID错---------------------"+PID);
if(isNotNull(biaoshi1)){
doc.addStringItem("biaoshi1",biaoshi1);//标识1
}
if(isNotNull(biaoshi2)){
doc.addStringItem("biaoshi2",biaoshi2);//标识2
}
doc.addStringItem("orderName",orderName);
doc.addStringItem("com_ID", CID)
doc.addStringItem("PID", PID)//培训公司与平台表的id 这个肯定要作为业务id
doc.addStringItem("Payment_mark", "退款")//缴费标志
doc.addStringItem("pay_type",pay_type)// 付费方式
doc.addStringItem("Billing_methods",Billing_methods)// 结算方式
doc.addStringItem("Billing_methods2",Billing_methods2)// 结算方式
doc.addStringItem("Coping_money",Coping_money)// 结算方式
doc.addStringItem("Coping_p_money",Coping_p_money)// 结算方式
doc.addStringItem("Form_settlement",Form_settlement)//报名费结算形式
doc.addStringItem("form_p_settlement",form_p_settlement)//平台费结算形式
doc.addStringItem("Refund_marks","退款")//平台费结算形式
doc.addStringItem("applyId",applyId);
doc.addStringItem("securityId",securityId);
doc.addStringItem("name",name);
doc.addStringItem("refundDate",format(getToday(),"yyyy-MM-dd HH:mm:ss"));
doc.addStringItem("idCardNo",idCardNo);
doc.addStringItem("lessonId",lessonId);
doc.addStringItem("lessonName",lessonName);
doc.addStringItem("learnId",learnId);
doc.addStringItem("learnName",learnName);
doc.addStringItem("trainName",trainName);
doc.addStringItem("trainId",trainId);
doc.addStringItem("orderId",orderId);
doc.addStringItem("zhudon",1);
doc.addStringItem("amount",price);
doc.addStringItem("pt_money",pt_money);
doc.addStringItem("phone",phone);
doc.addStringItem("type","2");//等级证
doc.addStringItem("refundState","1");//0申请中：1成功退款2：退款拒绝
doc.addStringItem("uuid",uuid);//业务id
process.doCreate(doc);
applyInfo.findItem("materialApproveStatus").setValue("2");
applyInfo.findItem("applyStatus").setValue("2");
applyInfo.findItem("materialApproveFailReason").setValue(materialApproveFailReason);
//退款
var deleteSql = "update tlk_level_train_person set item_isDelete='1',item_orderState='3' where ITEM_APPID = '"+applyId+"'";
println("测试sql----------->"+deleteSql);
updateByDSName("tms", deleteSql);
println("执行到这里了吗？？？？？？？？？")
}else{
println("进来3")
}
applyInfo.findItem("materialApproveDate").setValue(materialApproveDate);
applyInfo.findItem("materialApprovePerName").setValue(materialApprovePerName);
applyInfo.findItem("materialApprovePerIdCardNo").setValue(materialApprovePerIdCardNo);
process.doUpdate(applyInfo);
}catch(e){
return "【审核失败，请联系管理员！】"
}
/*操作银行接口*/
println("isTrue---->"+isTrue)
println("price---->"+price)
try{
if(isNotNull(dd2)&&isNotNull(aa2)){
//更新流水号
println("docid"+doc.getId())
var examPersonInfoDoc = findDocument(doc.getId());
examPersonInfoDoc.findItem("Serial_number").setValue(aa2);
examPersonInfoDoc.findItem("p_Serial_number").setValue(dd2);
process.doUpdate(examPersonInfoDoc);
println("更新流水号结束")
}
}catch(e){
return "审核失败！"
}
})()]]>
0
0
__tbpkdfcmhJKEy8hr5hu
0
false
false
false
false
0
0
0
false
0
0
0
false
true
|