新建岗点小组人员
__XLjD79Km8j8pkSHjTTv
__XLjD79Km8j8pkSHjTTv
published
UTF-8
post
/event/insert/group/person
json
0){
}else {
result.put("code","500");
result.put("msg","您所在的团队未加入该岗点对应项目，请联系团队负责加入项目！");
result.put("state", false);
return result;
}
var checksql="select 1 from tlk_event_project p left join tlk_event_post pos on p.id=pos.item_project_id left join tlk_event_post_group_person per on per.item_post_id=pos.id where p.id='"+project_id+"' and per.item_person_id='"+person_id+"' "
var datas = queryByDSName("baibaodunFlow",checksql);
if(datas.size()>0){
msg+=name+" "
}else{
if("0".equals(type)){//智能人事，person_id为职员id
var personsql="select "+
"u.name,"+//姓名
"u.telephone,"+//电话号码
"case u.sex when '1' then '男' when '2' then '女' else '未知' end as sex,"+//性别
"case u.checked_status when '0' then '未提交' when '1' then '已核验' when '2' then '已提交' end AS checked_status," + //身份核验
"c.number "+//身份证号
"from (select id,tenant_user_id from obpm2.tenant_employees where id='"+person_id+"' ) e inner join obpm2.tenant_users u on e.tenant_user_id=u.id "+
"inner join obpm2.tenant_user_credentials c on c.id = u.selected_credential_id "
}else if("1".equals(type)){//团体人员，person_id为团体人员id
var personsql="select "+
"u.name,"+//姓名
"u.telephone,"+//电话号码
"case u.sex when '1' then '男' when '2' then '女' else '未知' end as sex,"+//性别
"case u.checked_status when '0' then '未提交' when '1' then '已核验' when '2' then '已提交' end AS checked_status," + //身份核验
"c.number "+//身份证号
"from (select id,tenant_user_id from obpm2.external_members where id='"+person_id+"' ) e inner join obpm2.tenant_users u on e.tenant_user_id=u.id "+
"inner join obpm2.tenant_user_credentials c on c.id = u.selected_credential_id "
}
var persondatas = queryByDSName("baibaodunFlow",personsql);
if(persondatas.size()>0){
for(var personiterator = persondatas.iterator();personiterator.hasNext();){
var personmap1 = personiterator.next();//取值
var name= personmap1.get("name");
var telephone= personmap1.get("telephone");
var sex= personmap1.get("sex");
var checked_status= personmap1.get("checked_status");
var number= personmap1.get("number");
}
}
var process = getDocumentProcess();
var formProcess = getFormProcess();
var personInfo = formProcess.doView("__ZAVM0jeNje9qVgmLo48");
var personInfoLog = formProcess.doView("__p45ldH65wsmjiKLRb6g");
var attpersoninfo = formProcess.doView("__sgTQqGCJDqTyPf6vN1Q");
var personInfoDoc = process.doNew(personInfo,getWebUser(),createParamsTable());
var personInfoLogDoc = process.doNew(personInfoLog,getWebUser(),createParamsTable());
var attpersoninfoDoc = process.doNew(attpersoninfo,getWebUser(),createParamsTable());
personInfoDoc.addStringItem("name",name);
personInfoDoc.addStringItem("sex",sex);
personInfoDoc.addStringItem("number",number);
personInfoDoc.addStringItem("telephone",telephone);
personInfoDoc.addStringItem("domain_name",domainName);
personInfoDoc.addStringItem("checked_status",checked_status);
personInfoDoc.addStringItem("domain_id",domainid);
personInfoDoc.addStringItem("person_id",person_id);
personInfoDoc.addStringItem("post_id",post_id);
personInfoDoc.addStringItem("group_id",group_id);
personInfoDoc.addStringItem("reporting_state","未报到");
personInfoLogDoc.addStringItem("name",name);
personInfoLogDoc.addStringItem("id_number",number);
personInfoLogDoc.addStringItem("phone",telephone);
personInfoLogDoc.addStringItem("person_id",person_id);
personInfoLogDoc.addStringItem("band_person",getWebUser().getName());
personInfoLogDoc.addDateItem("band_time",getToday());
personInfoLogDoc.addStringItem("group_id",group_id);
attpersoninfoDoc.addStringItem("securityName",name); //驻勤人员名称
attpersoninfoDoc.addStringItem("securityId",person_id); //驻勤人员id
attpersoninfoDoc.addStringItem("from_type",type); //驻勤人员类型
attpersoninfoDoc.addStringItem("documentType",'1'); //证件类型
attpersoninfoDoc.addStringItem("documentID",number); //证件号码
attpersoninfoDoc.addStringItem("phone",telephone); //手机号
attpersoninfoDoc.addStringItem("isCertified",checked_status); //实名状态
attpersoninfoDoc.addStringItem("createdUser",getWebUser().getName()); //创建者
var postDoc=findDocument(post_id);
var attId = postDoc.findItem("att_id").getValue()
attpersoninfoDoc.addStringItem("attendanceSiteId",attId); //驻勤id
attpersoninfoDoc.addStringItem("domain_id",getDomainid()); //企业id
attpersoninfoDoc.addStringItem("person_status",'1');
attpersoninfoDoc.addStringItem("push_attendance",'1');
process.doCreate(attpersoninfoDoc)
process.doCreate(personInfoLogDoc);
personInfoDoc.addStringItem("log_id",personInfoLogDoc.getId())
personInfoDoc.addStringItem("att_person_id",attpersoninfoDoc.getId())
process.doCreate(personInfoDoc);
var uuidfo = new Packages.cn.myapps.util.sequence.Sequence(); //设置id
var uuid = uuidfo.getSequence()
var insertsql="INSERT INTO `obpm2`.`mc_notice`(`ID`, `IS_READ`, `SUMMARY`, `TO_USER_ID`, `CREATE_TIME`, `LINK_PARAMS`, `MODULE`, `DOMAIN_ID`, `SUBJECT_TYPE`, `CONTENT`) VALUES ('"+uuid+"', b'0', '您好，您已被安排至'+post_name+"岗点，请至【执勤管理】中查看。', '"+person_id+"', now(), NULL, '赛演项目', '"+domainid+"', 14, '"+'{\"content\":\"您已被安排至'+post_name+'岗点，请至【执勤管理】中查看。\",\"post_id\":\"'+post_id+'\",\"title\":\"赛演提醒\",\"type\":14,\"typeName\":\"赛演项目\"'+"}');"
insertByDSName("baibaodunFlow",insertsql);
}
}
result.put("code","200");
if(isNotNull(msg)){
msg+=" 已是当前项目人员，无需再次加入！"
}else{
msg+="加入成功！"
}
result.put("msg",msg);
result.put("state", true);
return result;
}else{
result.put("code","500");
result.put("msg","请求体不能为空！");
result.put("state", false);
return result;
}
})()]]>