新建岗点负责人 __XLjD79Km8j8pkSHjTTv __XLjD79Km8j8pkSHjTTv published UTF-8 post /event/insert/post/manager json 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 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+"', 15, '"+'{\"content\":\"您好，您已被设置为'+post_name+'岗点负责人。\",\"post_id\":\"'+post_id+'\",\"title\":\"赛演提醒\",\"type\":15,\"typeName\":\"赛演项目\"'+"}');" insertByDSName("baibaodunFlow",insertsql); var process = getDocumentProcess(); var formProcess = getFormProcess(); var personInfo = formProcess.doView("__SenyxFhJLyj3EJfmqnY"); var personInfoDoc = process.doNew(personInfo,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("post_id",post_id); personInfoDoc.addStringItem("person_id",person_id); personInfoDoc.addStringItem("type",type); process.doCreate(personInfoDoc); personlist+=person_id+";" personNamelist+=name+";" personPhonelist+=telephone+";" var postdoc=findDocument(post_id) var project_id=postdoc.findItem("project_id").getValue(); var projectDoc=findDocument(project_id) var project_start_time = projectDoc.findItem("project_start_time").getValue(); var project_end_time = projectDoc.findItem("project_end_time").getValue(); //检查是否已经有赛演调度台了 var checkdispatch="select id from dispatch.tlk_device where item_binded_assigner_name='赛演临时调度' and item_binded_user_id='"+person_id+"' " var dispatchdatas = queryByDSName("baibaodunFlow",checkdispatch); if(dispatchdatas.size()>0){ var updateDevice = "update dispatch.tlk_device set item_end_time='"+format(adjustDay (project_end_time,1),"yyyy-MM-dd")+"' where item_binded_assigner_name='赛演临时调度' and item_binded_user_id='"+person_id+"' " updateByDSName("baibaodunFlow",updateDevice); }else{ var processDispach = getDocProcess("__KWBHssgPtqkxvqhTKlW"); var deviceFromid="__Zq1ilPC4pdVmDthTXKN"; var deviceSubform = formProcess.doView(deviceFromid); var deviceDetail = processDispach.doNew(deviceSubform, getWebUser(), createParamsTable()); deviceDetail.findItem("binded_user_id").setValue(person_id); deviceDetail.findItem("binded_user_name").setValue(name); deviceDetail.findItem("binded_user_telephone").setValue(telephone); deviceDetail.findItem("binded_user_idnumber").setValue(number); deviceDetail.findItem("name").setValue("移动调度台"); deviceDetail.findItem("device_type").setValue("1"); deviceDetail.findItem("binded_assigner_name").setValue("赛演临时调度"); deviceDetail.findItem("product_pk_id").setValue(post_id); deviceDetail.findItem("reference_number").setValue(personInfoDoc.getId()); var prefix = 98+format(getToday(),"yyyyMMddHHmmss"); var val = countNext2(prefix,false,false,false,4); var code = getLastCount(prefix); if(code<=0){ val=countNext2(prefix,false,false,false,4); }else{ val =getLastCount2(prefix,false,false,false,4); //自动编号的最后编号 } deviceDetail.findItem("number").setValue(val); deviceDetail.findItem("status").setValue(0); deviceDetail.findItem("model").setValue("APP"); deviceDetail.findItem("begin_time").setValue(project_start_time); deviceDetail.findItem("end_time").setValue(adjustDay(project_end_time,1)); deviceDetail.findItem("domain_name").setValue(domainName); deviceDetail.findItem("domain_id").setValue(domainid); deviceDetail.findItem("product_category").setValue("00003"); var prefix = 99+format(getToday(),"yyyyMMddHHmmss"); var val = countNext2(prefix,false,false,false,4); var code = getLastCount(prefix); if(code<=0){ val=countNext2(prefix,false,false,false,4); }else{ val =getLastCount2(prefix,false,false,false,4); //自动编号的最后编号 } deviceDetail.findItem("pk_id").setValue(val+i); deviceDetail.setDomainid(domainid) processDispach.doCreate(deviceDetail); var devicePKId=deviceDetail.findItem("pk_id").getValue() //创建ip记录 var ipfromid="__cB4XfVMvUfMuPjJHtSm"; var ipSubform = formProcess.doView(ipfromid); var ipdoc = processDispach.doNew(ipSubform, getWebUser(), createParamsTable()); ipdoc.findItem("devicePKId").setValue(devicePKId); ipdoc.findItem("type").setValue(""); ipdoc.findItem("ip").setValue(""); ipdoc.findItem("domain_id").setValue(domainid); ipdoc.findItem("domain_name").setValue(domainName); ipdoc.findItem("last_updated_time").setValue(getToday()); ipdoc.findItem("last_updator_id").setValue(domainid); ipdoc.findItem("last_updator_name").setValue(domainName); var prefix = 8+format(getToday(),"yyyyMMddHHmmss"); var val = countNext2(prefix,false,false,false,4); var code = getLastCount(prefix); if(code<=0){ val=countNext2(prefix,false,false,false,4); }else{ val =getLastCount2(prefix,false,false,false,4); //自动编号的最后编号 } ipdoc.findItem("pk_id").setValue(val); ipdoc.setDomainid(domainid) processDispach.doCreate(ipdoc); } } } if(isNotNull(personlist)){ var uppersonlist="update baibaodunflow.tlk_attendance_site_base_info set item_principal= CASE WHEN item_principal IS NULL THEN LEFT('"+personlist+"', CHAR_LENGTH('"+personlist+"') - 1) ELSE CONCAT('"+personlist+"',item_principal) END,item_principalName= CASE WHEN item_principalName IS NULL THEN LEFT('"+personNamelist+"', CHAR_LENGTH('"+personNamelist+"') - 1) ELSE CONCAT('"+personNamelist+"',item_principalName) END,item_principalPhoneNo= CASE WHEN item_principalPhoneNo IS NULL THEN LEFT('"+personPhonelist+"', CHAR_LENGTH('"+personPhonelist+"') - 1) ELSE CONCAT('"+personPhonelist+"',item_principalPhoneNo) END where id=(select item_att_id from tlk_event_post where id='"+post_id+"' )" updateByDSName('baibaodunFlow',uppersonlist) } 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; } })()]]>