查询参与团体 __XLjD79Km8j8pkSHjTTv __XLjD79Km8j8pkSHjTTv published UTF-8 post /event/select/team json 0) whereStr+=" and item_invite_team_id='"+domainid+"' " } var sql="select '"+getDomainid()+"' as domainid,"+ "id,formid,applicationid,DATE_FORMAT(created, '%Y年%m月%d日') as created,"+ "if(item_outsource_level=2,concat(item_team_name,'(外包)'),item_team_name) as item_team_name,"+//组织或团队名称 "item_team_id,"+//组织或团队id "CASE item_team_type WHEN '0102' THEN '保安服务公司' WHEN '0103' THEN '保安培训单位' WHEN '0104' THEN '自行招用保安员单位' WHEN '0201' THEN '活动承办方' WHEN '0211' THEN '活动运营方' WHEN '0212' THEN '组委会' WHEN '0213' THEN '公安局' WHEN '0214' THEN '体育局' WHEN '0215' THEN '文旅局' WHEN '0216' THEN '卫健委' WHEN '0217' THEN '政法委' WHEN '0218' THEN '共青团' WHEN '0219' THEN '社团志愿者团队' WHEN '0220' THEN '保安公司' WHEN '0221' THEN '无人机反制公司' WHEN '0302' THEN '培训机构会员单位' WHEN '0301' THEN '其他' WHEN '0403' THEN '中小学、幼儿园' WHEN '0404' THEN '高校' WHEN '0401' THEN '医疗单位' WHEN '0405' THEN '金融单位' WHEN '0402' THEN '文博单位' WHEN '0406' THEN '党政机关' WHEN '0501' THEN '渠道合作方' WHEN '0502' THEN '供应商' WHEN '0601' THEN '社区警务团队' WHEN '0701' THEN '教育单位' WHEN '0702' THEN '医疗单位' WHEN '0703' THEN '金融单位' WHEN '0704' THEN '文博单位' WHEN '0705' THEN '党政机关' ELSE NULL END as item_team_type,"+//类型 "item_outsource_level,"+//外包等级 "item_leader_name,"+//负责人名称 "item_project_id,"+//项目id "item_leader_phone "+//联系电话 "from tlk_event_team where item_project_id='"+project_id+"' " + whereStr+ " order by created desc " var datas = queryByDSName("baibaodunFlow",sql); result.put("data",datas); result.put("code","200"); result.put("msg","OK"); result.put("state", true); return result; }else{ result.put("code","500"); result.put("msg","project_id不能为空！"); result.put("state", false); return result; } }else{ result.put("code","500"); result.put("msg","请求体不能为空！"); result.put("state", false); return result; } })()]]>