调岗管理-修改调岗状态 __DXZvc8mnEmDqMARhK7G __DXZvc8mnEmDqMARhK7G published UTF-8 post /demotion/updateState 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 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",curName); //创建者 doc1.addStringItem("attendanceSiteId",newAttId); //驻勤id doc1.addStringItem("domain_id",getDomainid()); //企业id doc1.addDateItem("reporting_time",getToday()); doc1.addStringItem("person_status",'2'); 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",newAttId); //驻勤id attArrangeDoc.addStringItem("DOCUMENTTYPE",documentType); //证件类型 attArrangeDoc.addStringItem("DOCUMENTID",documentID); //证件号码 attArrangeDoc.addStringItem("PHONE",phone); //手机号 attArrangeDoc.addDateItem("JOIN_ATT_TIME",getToday()); //安排时间 attArrangeDoc.addStringItem("JOIN_ATT_OPERATOR",curName); //安排人 process.doCreate(attArrangeDoc);//插入数据至驻勤人员安排表 println("新增驻勤人员安排信息:--------------------->"+attArrangeDoc); } } }else if("已调回".equals(status)){ var old_att_id = demotiondoc.findItem("att_id").getValue() var new_att_id = demotiondoc.findItem("atted_id").getValue() //先删除原本 var deletesql="delete from tlk_attendance_site_person_info where item_securityId='"+userId+"' and ITEM_attendanceSiteId ='"+new_att_id+"'" deleteByDSName("baibaodunFlow",deletesql); //安排记录也要更新移除 var updateSql = "update tlk_attendance_site_arrange_info set ITEM_LEAVE_ATT_TIME = NOW(),ITEM_LEAVE_ATT_OPERATOR = '" + curName +"',LASTMODIFIED = NOW(),LASTMODIFIER = '" + curId + "' where ITEM_SECURITYID = '" + userId+ "' and ITEM_ATTENDANCESITEID = '" + new_att_id + "' and ITEM_LEAVE_ATT_TIME is null;"; println("更新被删除的已关联其他驻勤点的驻勤人员安排信息sql===========》" + updateSql); updateByDSName("baibaodunFlow",updateSql); //查询基础数据安排到新的 var personInfoSql = "SELECT * FROM att_employee WHERE ITEM_userID = '"+ userId+"'"; println("查询驻勤人员的保安员信息sql-->: " + 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 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",curName); //创建者 doc1.addStringItem("attendanceSiteId",old_att_id); //驻勤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",old_att_id); //驻勤id attArrangeDoc.addStringItem("DOCUMENTTYPE",documentType); //证件类型 attArrangeDoc.addStringItem("DOCUMENTID",documentID); //证件号码 attArrangeDoc.addStringItem("PHONE",phone); //手机号 attArrangeDoc.addDateItem("JOIN_ATT_TIME",getToday()); //安排时间 attArrangeDoc.addStringItem("JOIN_ATT_OPERATOR",curName); //安排人 process.doCreate(attArrangeDoc);//插入数据至驻勤人员安排表 println("新增驻勤人员安排信息:--------------------->"+attArrangeDoc); } } } process.doUpdate(demotiondoc) result.put("code","200"); result.put("msg","修改成功"); result.put("state", true); return result; })()]]>