blob: 6a39623573529e04c8cc83f435baa8108324de59 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
|
module Api
module V1
class PhoneBookEntriesController < ApplicationController
respond_to :json
def index
query = params[:query]
switchboard = Switchboard.find(params[:switchboard_id])
return nil if query.blank?
current_ability = Ability.new(current_user)
phone_book_entries = PhoneBookEntry.accessible_by(current_ability)
if query.match(/^\+?\d+$/) != nil && switchboard && switchboard.reverse_lookup_activated
# Find by phone number
phone_book_entries_ids = phone_book_entries.map{|entry| entry.id}
found_phone_numbers = PhoneNumber.
where(:phone_numberable_type => 'PhoneBookEntry', :phone_numberable_id => phone_book_entries_ids).
where('number LIKE ?', "#{query}%")
search_result = phone_book_entries.where(:id => found_phone_numbers.map{|entry| entry.phone_numberable_id})
elsif query.match(/^[\"\'](.*)[\"\']$/) != nil
# The User searched for =>'example'<= so he wants an EXACT search for that.
# This is the fasted and most accurate way of searching.
# The order to search is: last_name, first_name and organization.
# It stops searching as soon as it finds results.
#
query = $1
search_result = phone_book_entries.where(:last_name => query)
search_result = phone_book_entries.where(:first_name => query) if search_result.blank?
search_result = phone_book_entries.where(:organization => query) if search_result.blank?
exact_search = true
else
# Search with SQL LIKE
#
search_result = phone_book_entries.
where( '( ( last_name LIKE ? ) OR ( first_name LIKE ? ) OR ( organization LIKE ? ) )',
"#{query}%", "#{query}%", "#{query}%" )
exact_search = false
end
# Let's have a run with our phonetic search.
#
phonetic_query = PhoneBookEntry.koelner_phonetik(query)
phonetic_search_result = phone_book_entries.where(:last_name_phonetic => phonetic_query)
phonetic_search_result = phone_book_entries.where(:first_name_phonetic => phonetic_query) if phonetic_search_result.blank?
phonetic_search_result = phone_book_entries.where(:organization_phonetic => phonetic_query) if phonetic_search_result.blank?
if phonetic_search_result.blank?
# Let's try the search with SQL LIKE. Just in case.
#
phonetic_search_result = phone_book_entries.where( 'last_name_phonetic LIKE ?', "#{phonetic_query}%" )
phonetic_search_result = phone_book_entries.where( 'first_name_phonetic LIKE ?', "#{phonetic_query}%" ) if phonetic_search_result.blank?
phonetic_search_result = phone_book_entries.where( 'organization_phonetic LIKE ?', "#{phonetic_query}%" ) if phonetic_search_result.blank?
end
phonetic_search = true if phonetic_search_result.any?
phone_book_entries = search_result
if phone_book_entries.count == 0 && exact_search == false && phonetic_search
phone_book_entries = phonetic_search_result
end
# Let's sort the results and do pagination.
#
phone_book_entries = phone_book_entries.
order([ :last_name, :first_name, :organization ]).limit(20)
respond_with phone_book_entries
end
end
end
end
|
