赛演项目 __e9fqI0xm2zROWcaQA3r __XLjD79Km8j8pkSHjTTv 赛演项目 true 10 true false false false 2025-02-15T07:00:34.000+08:00 false relatedForm month normal false 0 __wLZB3bmz6f6n6Kxwiqb true __zNNa8cuUuYsO64cQ2u2 public ='"+today+"') "; }else if ("停用".equals(effective_state)){ whereStr += "and DATE_FORMAT(ITEM_project_end_time, '%Y-%m-%d')<='"+today+"' "; }else { whereStr += "and DATE_FORMAT(item_project_start_time, '%Y-%m-%d')>='"+today+"' "; } } if(isNotNull(project_start_time)){ whereStr += "and ITEM_project_start_time >='"+format(project_start_time,"yyyy-MM-dd")+"' "; } if(isNotNull(project_end_time)){ whereStr += "and ITEM_project_end_time <='"+format(project_end_time,"yyyy-MM-dd")+"' "; } var sql="select '"+getDomainid()+"' as domainid,"+ "id,formid,applicationid,created,"+ "item_project_name,"+//项目名称 "item_project_type,"+//项目类型 "item_project_start_time,"+//项目开始时间 "item_project_end_time,"+//项目结束时间 "case when DATE_FORMAT(now(), '%Y-%m-%d')>=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 where item_domain_id='"+getDomainid()+"'" + whereStr " order by created desc " return sql; })()]]> [] 293 02 0 0