查询项目岗点 __XLjD79Km8j8pkSHjTTv __XLjD79Km8j8pkSHjTTv published UTF-8 post /event/select/post json 0){ whereStr += " and ((item_post_domain_id in (select item_team_id from tlk_event_team where item_invite_team_id='"+domainid+"') or item_post_domain_id= '"+domainid+"' )" var groupMainsql = "select id from obpm2.external_members where member_type=0 and id='"+userid+"'" var groupMaindatas = queryByDSName("baibaodunFlow",groupMainsql); if(groupMaindatas.size()>0){ whereStr +=" and 1=1 )" }else { whereStr +=" and (id in (select item_post_id from tlk_event_post_manager where item_person_id='"+userid+"') or author='"+userid+"' ) )" } } } var post_name = json["post_name"] if(isNotNull(post_name)){ whereStr += " and item_post_name like '%"+post_name+"%'" } var sql="select domainid,author,"+ "id,created,"+ "item_outsource_level,"+//外包等级 "item_project_name,"+//所属项目名称 "item_domain_name,"+//承办单位名称 "item_post_domain_name,"+//岗点创建组织名称 "item_post_domain_id,"+//岗点创建组织id "item_project_type,"+//项目类型 "item_project_status,"+//项目状态 "item_post_name,"+//岗点名称 "item_attendanceSiteAddress,"+//省市区 "item_attendanceSiteFullAddress,"+//地址 "item_attendanceSiteLongitude,"+//经度 "item_attendanceSiteLatitude,"+//纬度 "item_project_start_time,"+//项目开始时间 "item_project_end_time,"+//项目结束时间 "item_perform_range,"+//执行范围 "item_post_content,"+//岗点内容 "item_is_location,"+//是否定位 "item_post_status,"+//岗点状态 "item_person_number "+//岗点人数 "from ("+ "select p.domainid,p.author,"+ "p.id,DATE_FORMAT(p.created, '%Y年%m月%d日') as created,"+ "'0' as item_outsource_level,"+//外包等级 "pro.item_project_name,"+//所属项目名称 "pro.item_domain_name,"+//承办单位名称 "p.item_post_domain_name,"+//岗点创建组织名称 "p.item_post_domain_id,"+//岗点创建组织id "pro.item_project_type,"+//项目类型 "case when DATE_FORMAT(now(), '%Y-%m-%d')>=DATE_FORMAT(pro.item_project_start_time, '%Y-%m-%d') and DATE_FORMAT(now(), '%Y-%m-%d') <=DATE_FORMAT(pro.item_project_end_time, '%Y-%m-%d') THEN '进行中' when DATE_FORMAT(now(), '%Y-%m-%d')<=DATE_FORMAT(pro.item_project_start_time, '%Y-%m-%d') THEN '未开始' ELSE '已结束' END AS item_project_status,"+//项目状态 "p.item_post_name,"+//岗点名称 "p.item_attendanceSiteAddress,"+//省市区 "p.item_attendanceSiteFullAddress,"+//地址 "p.item_attendanceSiteLongitude,"+//经度 "p.item_attendanceSiteLatitude,"+//纬度 "DATE_FORMAT(p.item_project_start_time, '%Y年%m月%d日') as item_project_start_time,"+//项目开始时间 "DATE_FORMAT(p.item_project_end_time, '%Y年%m月%d日') as item_project_end_time,"+//项目结束时间 "p.item_perform_range,"+//执行范围 "p.item_post_content,"+//岗点内容 "if(p.item_attendanceSiteLongitude=0,'未定位','已定位') as item_is_location,"+//是否定位 "case when DATE_FORMAT(now(), '%Y-%m-%d')>=DATE_FORMAT(p.item_project_start_time, '%Y-%m-%d') and DATE_FORMAT(now(), '%Y-%m-%d') <=DATE_FORMAT(p.item_project_end_time, '%Y-%m-%d') THEN '进行中' when DATE_FORMAT(now(), '%Y-%m-%d')<=DATE_FORMAT(p.item_project_start_time, '%Y-%m-%d') THEN '未开始' ELSE '已结束' END AS item_post_status,"+//岗点状态 "(select count(1) from tlk_event_post_group_person u where u.item_post_id=p.id ) as item_person_number "+//岗点人数 "from tlk_event_project pro inner join tlk_event_post p on pro.id=p.item_project_id where pro.id='"+project_id+"' "+ ") v"+ whereStr + " group by id 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; } })()]]>