赛演风评 __mutXIiSVHCXsKYauE4H __L33UbXrWcu5paxPftP2 赛演风评视图 true 30 true false false false true relatedForm month normal false 0 __AoMnvjs4XcMpRweWX5K true public CURRENT_DATE THEN '未开始' when DATE_FORMAT(p.item_project_end_time, '%Y-%m-%d') < CURRENT_DATE THEN '终止' ELSE '进行中' END) AS item_project_status, " + "concat(date_format(p.ITEM_PROJECT_START_TIME,'%Y-%m-%d'),'至',date_format(p.ITEM_PROJECT_END_TIME,'%Y-%m-%d')) as item_time_range," + "p.ITEM_DOMAIN_NAME," + //"p.ITEM_LINK_3D," + "p.ITEM_ASSESMENT_REPORT " + "from tlk_event_project p where date_format(p.item_project_end_time, '%Y-%m-%d') >= CURRENT_DATE and ifnull(p.ITEM_COVER_PAGE,'')!= '' and ifnull(p.ITEM_LINK_3D,'')!= '' and ifnull(p.ITEM_ASSESMENT_REPORT,'')!= '' " + " and (p.ITEM_OFFICE_POLICE_ID_INDEX = '" + departId + "' or p.ITEM_OFFICE_POLICE_ID_INDEX like '%\\_" + departId + "' or p.ITEM_OFFICE_POLICE_ID_INDEX like '%" + departId + "\\_\\_\\_%' )"; if(isNotNull(s_project_name)){ sql += " and p.ITEM_PROJECT_NAME like '%" + s_project_name + "%' "; } if(isNotNull(s_domain_name)){ sql += " and p.ITEM_DOMAIN_NAME like '%" + s_domain_name + "%' "; } if(isNotNull(s_start_time)){ sql += " and DATE_FORMAT(p.item_project_start_time, '%Y-%m-%d') >= '" + s_start_time + "' "; } if(isNotNull(s_end_time)){ sql += " and DATE_FORMAT(p.item_project_end_time, '%Y-%m-%d') <= '" + s_end_time + "' "; } println("赛演风评监管视图sql========" + sql); return sql; })()]]> [] 1 02 0 0