添加驻勤人员
__DXZvc8mnEmDqMARhK7G
__DXZvc8mnEmDqMARhK7G
published
UTF-8
post
/zhuqin/tianjia
json
0){
println("此人已存在");
}else {
//}
var sql = "SELECT * FROM vw_employee WHERE ITEM_phone = '"+jsonobject+"' and domainid = '"+domainid+"'";
println("sql==456="+sql);
var datas = queryByDSName("baibaodunFlow",sql);
var t_count1 = countBySQL(sql);
if(t_count1>0){
for(var iterator = datas.iterator();iterator.hasNext();){
var map1 = iterator.next();//取值
var securityName = map1.get("item_securityName"); //保安员姓名
var DeptName = map1.get("item_DeptName"); //所属部门
var jobType = map1.get("item_jobType"); //人员类型
var documentType = map1.get("item_documentType"); //证件类型
var documentID = map1.get("item_documentID"); //证件号码
var phone = map1.get("item_phone"); //手机号
//var uuid = map1.get("id"); //用户id
var uuid = map1.get("item_userID"); //用户id
var isCertified = map1.get("item_isCertified"); //实名状态
var insuranceStatus = map1.get("item_insure"); //投保状态
}
}
else{
// var sql2 = "SELECT * FROM vw_employee WHERE id = '"+jsonobject+"' and domainid = '"+domainid+"'";
var sql2 = "SELECT * FROM vw_employee WHERE item_userID = '"+jsonobject+"' and domainid = '"+domainid+"'";
println("sql==123="+sql2);
var datas2 = queryByDSName("baibaodunFlow",sql2);
var t_count2 = countBySQL(sql2);
if(t_count2>0){
for(var iterator1 = datas2.iterator();iterator1.hasNext();){
var map2 = iterator1.next();//取值
var securityName = map2.get("item_securityName"); //保安员姓名
var DeptName = map2.get("item_DeptName"); //所属部门
var jobType = map2.get("item_jobType"); //人员类型
var documentType = map2.get("item_documentType"); //证件类型
var documentID = map2.get("item_documentID"); //证件号码
var phone = map2.get("item_phone"); //手机号
// var uuid = map2.get("id"); //用户id
var uuid = map2.get("item_userID"); //用户id
var isCertified = map2.get("item_isCertified"); //实名状态
var insuranceStatus = map2.get("item_insure"); //投保状态
}
}
}
/* var query = queryBySQL(sql);//根据id取保安员信息
if(query!=null){
var iter =query.iterator();
if(iter != null && iter.hasNext()){
doc = iter.next();
var securityName = doc.getItemValueAsString("securityName"); //保安员姓名
var DeptName = doc.getItemValueAsString("DeptName"); //所属部门
var jobType = doc.getItemValueAsString("jobType"); //人员类型
var documentType = doc.getItemValueAsString("documentType"); //证件类型
var documentID = doc.getItemValueAsString("documentID"); //证件号码
var phone = doc.getItemValueAsString("phone"); //手机号
var isCertified = doc.getItemValueAsString("isCertified"); //实名状态
var insuranceStatus = doc.getItemValueAsString("insure"); //投保状态
var userID = doc.getItemValueAsString("userID"); //用户id(保安员表的id)
}
}*/
//docreate 插入数据到驻勤人员表
var process = getDocumentProcess();
var formProcess = getFormProcess();
var subform = formProcess.doView("__sgTQqGCJDqTyPf6vN1Q"); //“attendance_site_person_info”表单Id
var doc1 = process.doNew(subform,getWebUser(),createParamsTable());
doc1.addStringItem("securityName",securityName); //驻勤人员名称
doc1.addStringItem("securityId",uuid); //驻勤人员id
//doc1.addStringItem("securityId",jsonobject); //驻勤人员id
//doc1.addStringItem("securityId",userID); //驻勤人员id
doc1.addStringItem("documentType",documentType); //证件类型
doc1.addStringItem("documentID",documentID); //证件号码
doc1.addStringItem("phone",phone); //手机号
doc1.addStringItem("DeptName",DeptName); //所属部门
doc1.addStringItem("jobType",jobType); //人员类型
doc1.addStringItem("isCertified",isCertified); //实名状态
doc1.addStringItem("insuranceStatus",insuranceStatus);//投保状态
doc1.addStringItem("createdUser",userName); //创建者
doc1.addStringItem("attendanceSiteId",attendid); //驻勤id
doc1.addStringItem("domain_id",domainid); //企业id
process.doCreate(doc1);//插入数据至驻勤人员表
println("doc1:--------------------->"+doc1); }}
// var sql=" insert into tlk_jfDevice_2 (id,ITEM_EQUIPTYPE, ITEM_EQUIPNO,ITEM_EQUIPNAME,ITEM_EQUIPTOTAL,ITEM_REMAINQUALITY) values('"+uuid.getSequence()+"','安防器械','"+jsonobject+"','北京','12','12')";
// println("jsonobject=====sql======"+sql);
// var datas = insertByDSName("baibaodunFlow",sql);
// list.add(datas);
// }
// return list;
}
})()]]>