删除团体 __XLjD79Km8j8pkSHjTTv __XLjD79Km8j8pkSHjTTv published UTF-8 post /event/delete/team json 0){ result.put("code","500"); result.put("msg","需要先把当前团队创建的岗点删除后才可移除！"); result.put("state", false); return result; } //获取项目名称 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, '赛演项目', '"+team_id+"', 11, '"+'{\"content\":\"您的'+team_name+'团队，已被从'+project_name+'项目中移除。\",\"project_id\":\"'+project_id+'\",\"title\":\"赛演提醒\",\"type\":11,\"typeName\":\"赛演项目\"'+"}');" insertByDSName("baibaodunFlow",insertsql); var updateDevice = "update dispatch.tlk_device set item_end_time='"+format(adjustDay (getToday(),-1),"yyyy-MM-dd")+"' where item_binded_assigner_name='赛演临时调度' and item_binded_user_id='"+person_id+"' " updateByDSName("baibaodunFlow",updateDevice); } } //删除团队 var sql ="delete from tlk_event_team where id='"+docids+"'"; deleteByDSName("baibaodunFlow",sql); //删除团队关联表 var sql1 ="delete from tlk_event_join where item_project_id='"+project_id+"' and item_domain_id='"+team_id+"' "; deleteByDSName("baibaodunFlow",sql1); //作废审核表 var sql2 ="update tlk_event_check_team set item_status=3 where item_project_id='"+project_id+"' and item_team_id='"+team_id+"' "; updateByDSName("baibaodunFlow",sql2); result.put("code","200"); result.put("msg","移除成功！"); result.put("state", true); return result; })()]]>