Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- if params[:phone] && params[:email] && params[:fax]
- 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)
- results_companies = results_companies.where(:id => data_companies_ids)
- results_companies = results_companies.eager_load(:data_contacts)
- results_contacts = DataContact.where(:data_company_id => data_companies_ids)
- end
- if !params[:phone] && !params[:email] && !params[:fax] && params[:cell]
- 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)
- results_contacts = DataContact.eager_load(results_companies)
- end
- if !params[:phone] && !params[:email] && params[:fax] && !params[:cell]
- 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)
- results_contacts = DataContact.eager_load(results_companies)
- end
- if !params[:phone] && params[:email] && !params[:fax] && !params[:cell]
- 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)
- results_contacts = DataContact.eager_load(results_companies)
- end
- if (params[:phone] && !params[:email] && !params[:fax] && !params[:cell]) || params[:std]
- 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)
- results_contacts = DataContact.eager_load(results_companies)
- end
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement