gistfile1.ru

@contracts = Contract.find(:all,:joins =>'inner join sites on sites.id = contracts.site_id inner join cities on cities.id = sites.city_id inner join states st on st.id = cities.state_id inner join countries c on c.id = st.country_id', :conditions => ['deleted = 0 and sites.site_status_id <>3 and (contracts.end_date - current_date)< 240 and (contracts.end_date - current_date) > 0 and contracts.end_date is not null and c.id in (%s)', current_user.contact.country_ids_by_rights("sites","edit").join(",")], :order=>'contracts.end_date asc')