添加参与团体 __XLjD79Km8j8pkSHjTTv __XLjD79Km8j8pkSHjTTv published UTF-8 post /event/insert/team json 0){ msg+=team_name+" " }else{ var process = getDocumentProcess(); if("1".equals(status)){ var formProcess = getFormProcess(); var personInfo = formProcess.doView("__FWBpcfmbfVJdb5P7ICp"); var personInfoDoc = process.doNew(personInfo,getWebUser(),createParamsTable()); var jionInfo = formProcess.doView("__lKUfOUG12oV5OSXolZn"); var jionInfoDoc = process.doNew(jionInfo,getWebUser(),createParamsTable()); personInfoDoc.addStringItem("team_name",team_name); personInfoDoc.addStringItem("project_id",project_id); personInfoDoc.addStringItem("team_id",team_id); personInfoDoc.addStringItem("leader_name",leader_name); personInfoDoc.addStringItem("leader_id",leader_id); personInfoDoc.addStringItem("leader_phone",leader_phone); personInfoDoc.addStringItem("team_type",team_type); personInfoDoc.addStringItem("invite_team_name",invite_team_name); personInfoDoc.addStringItem("invite_team_id",invite_team_id); personInfoDoc.addStringItem("outsource_level",outsource_level); personInfoDoc.setDomainid(team_id) process.doCreate(personInfoDoc); jionInfoDoc.addStringItem("project_id",project_id); jionInfoDoc.addStringItem("domain_name",team_name); jionInfoDoc.addStringItem("domain_id",team_id); jionInfoDoc.addStringItem("team_id",personInfoDoc.getId()); jionInfoDoc.addStringItem("outsource_level",outsource_level); jionInfoDoc.setDomainid(team_id) process.doCreate(jionInfoDoc); //获取项目名称 var projectDoc=findDocument(project_id); var project_name=projectDoc.findItem("project_name").getValue() var groupMainsql = "select id,reference_number from obpm2.external_members where member_type=0 and reference_number='"+team_id+"'" var groupMaindatas = queryByDSName("baibaodunFlow",groupMainsql); if(groupMaindatas.size()>0){ for(var groupMainiterator = groupMaindatas.iterator();groupMainiterator.hasNext();){ var groupMaindatasmap1 = groupMainiterator.next();//取值 var person_id = groupMaindatasmap1.get("id"); var domain_id = groupMaindatasmap1.get("reference_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', '您的'+team_name+'团队申请加入'+project_name+"项目审核已通过，请查收。', '"+person_id+"', now(), NULL, '赛演项目', '"+domain_id+"', 13, '"+'{\"content\":\"您的'+team_name+'团队申请加入'+project_name+'项目审核已通过，请查收。\",\"project_id\":\"'+project_id+'\",\"title\":\"赛演提醒\",\"type\":13,\"typeName\":\"赛演项目\"'+"}');" insertByDSName("baibaodunFlow",insertsql); var personsql="select "+ "u.name,"+//姓名 "e.organization_id,"+//组织id "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,reference_number as organization_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 organization_id= personmap1.get("organization_id"); var sex= personmap1.get("sex"); var checked_status= personmap1.get("checked_status"); var number= personmap1.get("number"); } } //检查是否已经有赛演调度台了 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(project_id); deviceDetail.findItem("reference_number").setValue(personInfoDoc.getId()+person_id); 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+i); 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(team_name); deviceDetail.findItem("domain_id").setValue(team_id); 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(team_id) 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(team_id); ipdoc.findItem("domain_name").setValue(team_name); ipdoc.findItem("last_updated_time").setValue(getToday()); ipdoc.findItem("last_updator_id").setValue(team_id); ipdoc.findItem("last_updator_name").setValue(team_name); var prefix = 88+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+i); ipdoc.setDomainid(team_id) processDispach.doCreate(ipdoc); } } } } invitedoc.findItem("status").setValue(status); process.doUpdate(invitedoc); } 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; } })()]]>