查询赛演项目 __XLjD79Km8j8pkSHjTTv __XLjD79Km8j8pkSHjTTv published UTF-8 post /event/select/projectInfo json =DATE_FORMAT(item_project_start_time, '%Y-%m-%d') and DATE_FORMAT(now(), '%Y-%m-%d') <=DATE_FORMAT(item_project_end_time, '%Y-%m-%d') THEN '进行中' when DATE_FORMAT(now(), '%Y-%m-%d')<=DATE_FORMAT(item_project_start_time, '%Y-%m-%d') THEN '未开始' ELSE '已结束' END AS item_project_status "+//项目状态 "from tlk_event_project p where item_domain_id='"+getDomainid()+"' "+ "union all "+ "select j.domainid,"+ "p.id,p.formid,p.applicationid,DATE_FORMAT(j.created, '%Y年%m月%d日') as created,"+ "j.item_outsource_level,"+//外包等级 "p.item_project_name,"+//项目名称 "ITEM_COVER_PAGE,"+//封面 "p.item_domain_name,"+//承办单位 "p.item_domain_id,"+//承办单位id "p.item_project_type,"+//项目类型 "p.item_city_name,"+//项目城市 " (select count(1) from tlk_event_post pst LEFT JOIN tlk_event_post_group_person per ON pst.id = per.item_post_id WHERE pst.item_project_id = p.id ) as item_person_number,"+//项目成员 "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,"+//项目结束时间 "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_project_status "+//项目状态 "from tlk_event_join j inner join tlk_event_project p on j.item_project_id=p.id where j.item_domain_id='"+getDomainid()+"' "+ "union all "+ "select j.domainid,"+ "p.id,p.formid,p.applicationid,DATE_FORMAT(p.created, '%Y年%m月%d日') as created,"+ "'0' as item_outsource_level,"+//外包等级 "p.item_project_name,"+//项目名称 "ITEM_COVER_PAGE,"+//封面 "p.item_domain_name,"+//承办单位 "p.item_domain_id,"+//承办单位id "p.item_project_type,"+//项目类型 "p.item_city_name,"+//项目城市 " (select count(1) from tlk_event_post pst LEFT JOIN tlk_event_post_group_person per ON pst.id = per.item_post_id WHERE pst.item_project_id = p.id ) as item_person_number,"+//项目成员 "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,"+//项目结束时间 "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_project_status "+//项目状态 "from tlk_event_manager j inner join tlk_event_project p on j.item_project_id=p.id where j.item_person_id='"+person_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; })()]]>