Advertisement
Guest User

Untitled

a guest
Mar 5th, 2015
173
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Ruby 1.89 KB | None | 0 0
  1. if params[:phone] && params[:email] && params[:fax]
  2.       data_companies_ids = results_companies.eager_load(:data_contacts).where('data_contacts.phone = ?  OR data_contacts.email = ? ', 1, 1,).group('data_contacts.data_company_id').having('count(data_contacts.id) >= ?', 2).limit(1000)
  3.       results_companies = results_companies.where(:id => data_companies_ids)
  4.       results_companies = results_companies.eager_load(:data_contacts)
  5.       results_contacts = DataContact.where(:data_company_id => data_companies_ids)
  6.     end
  7.  
  8.     if !params[:phone] && !params[:email] && !params[:fax] && params[:cell]
  9.       results_companies = results_companies.eager_load(:data_contacts).where('data_contacts.cell = ? ', 1).group('data_contacts.data_company_id').having('count(data_contacts.id)  >= ?', 1)
  10.       results_contacts = DataContact.eager_load(results_companies)
  11.     end
  12.  
  13.     if !params[:phone] && !params[:email] && params[:fax] && !params[:cell]
  14.       results_companies = results_companies.eager_load(:data_contacts).where('data_contacts.fax = ? ', 1).group('data_contacts.data_company_id').having('count(data_contacts.id)  >= ?', 1)
  15.       results_contacts = DataContact.eager_load(results_companies)
  16.     end
  17.  
  18.     if !params[:phone] && params[:email] && !params[:fax] && !params[:cell]
  19.       results_companies = results_companies.eager_load(:data_contacts).where('data_contacts.email = ? ', 1).group('data_contacts.data_company_id').having('count(data_contacts.id)  >= ?', 1)
  20.       results_contacts = DataContact.eager_load(results_companies)
  21.     end
  22.  
  23.     if (params[:phone] && !params[:email] && !params[:fax] && !params[:cell]) || params[:std]
  24.       results_companies = results_companies.eager_load(:data_contacts).where('data_contacts.phone = ? ', 1).group('data_contacts.data_company_id').having('count(data_contacts.id)  >= ?', 1)
  25.       results_contacts = DataContact.eager_load(results_companies)
  26.     end
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement