在职人员邀请驻勤 __DXZvc8mnEmDqMARhK7G __DXZvc8mnEmDqMARhK7G published UTF-8 post /invite/joinAtt json : " + personInfoSql); var query = queryBySQL(personInfoSql);//根据id取保安员信息 if(query!=null){ var process = getDocumentProcess(); var formProcess = getFormProcess(); for( var iter =query.iterator();iter.hasNext();){ var 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 empid = doc.getItemValueAsString("userID"); //employeeid } } //校验这个驻勤邀请是不是当前用户所在企业的 var checksql="select 1 from tlk_attendance_site_base_info where id='"+attId+"' and domainid='"+domainid+"'" var checkdatas = queryByDSName("baibaodunFlow",checksql); if(checkdatas.size()>0){ //校验公司是否打开了自动通过审核 var autosql="select 1 from tlk_invite_show where domainid='"+getDomainid()+"' and item_is_open='1'" var autodatas = queryByDSName("baibaodunFlow",autosql); if(autodatas.size()>0){ //查看这个人当前所在的驻勤点 var attsql="select p.item_securityId,p.item_attendanceSiteId,a.item_attendanceSiteName,a.item_principalName,a.item_principal from tlk_attendance_site_person_info p left join tlk_attendance_site_base_info a on p.item_attendanceSiteId=a.id where p.item_securityId='"+userid+"' and p.domainid='"+domainid+"'" var attdatas = queryByDSName("baibaodunFlow",attsql); if(attdatas.size()>0){//代表已经有驻勤点，需要先删除原本的驻勤点 for(var attiterator = attdatas.iterator();attiterator.hasNext();){ var mapatt = attiterator.next();//取值 securityId = mapatt.get("item_securityId"); attendanceSiteId = mapatt.get("item_attendanceSiteId"); attendanceSiteName = mapatt.get("item_attendanceSiteName"); principalName = mapatt.get("item_principalName"); principal = mapatt.get("item_principal"); } //先删除原本 var deletesql="delete from tlk_attendance_site_person_info where item_securityId='"+securityId+"' and ITEM_attendanceSiteId ='"+attendanceSiteId+"'" deleteByDSName("baibaodunFlow",deletesql); //安排记录也要更新移除 var updateSql = "update tlk_attendance_site_arrange_info set ITEM_LEAVE_ATT_TIME = NOW(),ITEM_LEAVE_ATT_OPERATOR = '" + inviteName +"',LASTMODIFIED = NOW(),LASTMODIFIER = '" + inviteId + "' where ITEM_SECURITYID = '" + securityId+ "' and ITEM_ATTENDANCESITEID = '" + attendanceSiteId + "' and ITEM_LEAVE_ATT_TIME is null;"; println("更新被删除的已关联其他驻勤点的驻勤人员安排信息sql===========》" + updateSql); updateByDSName("baibaodunFlow",updateSql); //插入数据到驻勤人员表 var subform = formProcess.doView("__sgTQqGCJDqTyPf6vN1Q"); //“attendance_site_person_info”表单Id var doc1 = process.doNew(subform,getWebUser(),createParamsTable()); doc1.addStringItem("securityName",securityName); //驻勤人员名称 doc1.addStringItem("securityId",empid); //驻勤人员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",inviteName); //创建者 doc1.addStringItem("attendanceSiteId",attId); //驻勤id doc1.addStringItem("domain_id",getDomainid()); //企业id doc1.addStringItem("person_status",'0'); process.doCreate(doc1);//插入数据至驻勤人员表 println("新增驻勤人员信息:--------------------->"+doc1); //插入数据到驻勤人员安排表 var attArrangeform = formProcess.doView("__MWsyjKTNZFmq3qaGHvx"); //“attendance_site_arrange_info”表单Id var attArrangeDoc = process.doNew(attArrangeform,getWebUser(),createParamsTable()); attArrangeDoc.addStringItem("SECURITYNAME",securityName); //驻勤人员名称 attArrangeDoc.addStringItem("SECURITYID",empid); //驻勤人员id attArrangeDoc.addStringItem("ATTENDANCESITEID",attId); //驻勤id attArrangeDoc.addStringItem("DOCUMENTTYPE",documentType); //证件类型 attArrangeDoc.addStringItem("DOCUMENTID",documentID); //证件号码 attArrangeDoc.addStringItem("PHONE",phone); //手机号 attArrangeDoc.addDateItem("JOIN_ATT_TIME",getToday()); //安排时间 attArrangeDoc.addStringItem("JOIN_ATT_OPERATOR",inviteName); //安排人 process.doCreate(attArrangeDoc);//插入数据至驻勤人员安排表 println("新增驻勤人员安排信息:--------------------->"+attArrangeDoc); //插入到邀请审核表里面 var process = getDocumentProcess(); var formProcess = getFormProcess(); var subform = formProcess.doView("__SNSdH9FvMuczH1C62RY"); var doc1 = process.doNew(subform,getWebUser(),createParamsTable()); doc1.addStringItem("person_name",userName); doc1.addStringItem("person_id",userid); doc1.addStringItem("telephone",phone); doc1.addStringItem("id_number",documentID); doc1.addStringItem("id_number_type",documentType); doc1.addStringItem("invite_person_name",inviteName); doc1.addStringItem("invite_person_id",inviteId); doc1.addStringItem("invite_att_name",attName); doc1.addStringItem("invite_att_id",attId); doc1.addStringItem("original_att_name",attendanceSiteName); doc1.addStringItem("original_att_id",attendanceSiteId); doc1.addStringItem("original_att_head_name",principalName); doc1.addStringItem("original_att_head_id",principal); doc1.addStringItem("status",1); doc1.addStringItem("operator_name","自动确认"); doc1.addDateItem("operator_time",getToday()); doc1.addDateItem("application_join_time",getToday()); process.doCreate(doc1) result.put("code","200"); result.put("msg","提交成功！"); result.put("state", true); return result; } }else{ var process = getDocumentProcess(); var formProcess = getFormProcess(); var subform = formProcess.doView("__SNSdH9FvMuczH1C62RY"); var doc1 = process.doNew(subform,getWebUser(),createParamsTable()); doc1.addStringItem("person_name",userName); doc1.addStringItem("person_id",userid); doc1.addStringItem("telephone",phone); doc1.addStringItem("id_number",documentID); doc1.addStringItem("id_number_type",documentType); doc1.addStringItem("invite_person_name",inviteName); doc1.addStringItem("invite_person_id",inviteId); doc1.addStringItem("invite_att_name",attName); doc1.addStringItem("invite_att_id",attId); doc1.addDateItem("application_join_time",getToday()); process.doCreate(doc1) result.put("code","200"); result.put("msg","提交成功！"); result.put("state", true); return result; } }else{ result.put("code","500"); result.put("msg","当前人员非公司在职员工！"); result.put("state", false); return result; } } } result.put("code","500"); result.put("msg","缺少驻勤点id"); result.put("state", false); return result; })()]]>