协会通知 __h5jLdxUTFhPSfthQCAr __WkIi9lLeMAspqlXzZH7 true 5 true false false false true relatedForm month normal false 0 __Vj4AdKxsA3PDlZKNnlT true public 0){ for(var iterator = datas.iterator();iterator.hasNext();){ var map1 = iterator.next();//取值 var institutional_code= map1.get("institutional_code"); } } var whereStr=" where (n.item_visibility='0' or (n.item_visibility='1' and n.item_organization_code like +'"+institutional_code+"') or (n.item_visibility='2' and '"+getDomainid()+"' in (select item_domain_id from tlk_notice_domain where item_notice_id=n.id ))) " var title = getItemValueAsString("title"); if(isNotNull(title)){ whereStr += " and n.item_title like '%"+title+"%' " ; } var user_name = getItemValueAsString("user_name"); if(isNotNull(user_name)){ whereStr += " and n.item_user_name like '%"+user_name+"%' " ; } var read_status = getItemValueAsString("read_status"); if(isNotNull(read_status)){ if("未读".equals(read_status)){ whereStr += " and r.id is null " ; }else if("已读".equals(read_status)){ whereStr += " and r.id is not null " ; } } var start_time = getItemValueAsDate("create_start_time"); var end_time = getItemValueAsDate("create_end_time"); if(isNotNull(start_time)){ whereStr += " and DATE_FORMAT(n.item_create_time, '%Y-%m-%d') >= '"+format(start_time,"yyyy-MM-dd")+"' " ; } if(isNotNull(end_time)){ whereStr += " and DATE_FORMAT(n.item_create_time, '%Y-%m-%d') <= '"+format(end_time,"yyyy-MM-dd")+"' " ; } var sql="select '"+getDomainid()+"' as domainid,n.id,n.formid,n.applicationid,n.item_title,n.created,"+ "n.item_content,item_file,item_user_name,item_create_time,if(r.id is null ,'未读','已读') as item_read_status from tlk_train_notice n "+ " left join tlk_notice_read r on r.item_notice_id=n.id and r.item_domain_id='"+getDomainid()+"' "+whereStr+" group by n.id order by n.created desc " println(sql) return sql; })()]]> [] 277 02 0 0