Add the possiblity to search the phone_books in the Switchboard#view

6 files changed, 122 insertions, 2 deletions

diff --git a/app/controllers/api/v1/phone_book_entries_controller.rb b/app/controllers/api/v1/phone_book_entries_controller.rb
new file mode 100644
index 0000000..7cae5a5
--- /dev/null
+++ b/app/controllers/api/v1/phone_book_entries_controller.rb
@@ -0,0 +1,76 @@
+module Api
+  module V1
+    class PhoneBookEntriesController < ApplicationController
+      respond_to :json
+
+      def index
+        query = params[:query]
+        
+        return nil if query.blank?
+
+        current_ability = Ability.new(current_user)
+        phone_book_entries = PhoneBookEntry.accessible_by(current_ability)
+
+        if query.match(/^\+?\d+$/) != nil
+          # 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 ])
+
+        respond_with phone_book_entries
+      end
+ 
+    end
+  end
+end
diff --git a/app/controllers/switchboards_controller.rb b/app/controllers/switchboards_controller.rb
index d162a85..03fd73e 100644
--- a/app/controllers/switchboards_controller.rb
+++ b/app/controllers/switchboards_controller.rb
@@ -58,7 +58,7 @@ class SwitchboardsController < ApplicationController
 
   private
   def switchboard_params
-    params.require(:switchboard).permit(:name, :reload_interval, :show_avatars, :entry_width, :amount_of_displayed_phone_numbers, :blind_transfer_activated, :attended_transfer_activated)
+    params.require(:switchboard).permit(:name, :reload_interval, :show_avatars, :entry_width, :amount_of_displayed_phone_numbers, :blind_transfer_activated, :attended_transfer_activated, :search_activated)
   end
 
   def spread_breadcrumbs
diff --git a/app/serializers/phone_book_entry_serializer.rb b/app/serializers/phone_book_entry_serializer.rb
new file mode 100644
index 0000000..ac25832
--- /dev/null
+++ b/app/serializers/phone_book_entry_serializer.rb
@@ -0,0 +1,14 @@
+class PhoneBookEntrySerializer < ActiveModel::Serializer
+  embed :ids, :include => true
+
+  attributes :id, :first_name, :last_name, :organization, :search_result_display
+  has_many :phone_numbers
+
+  def search_result_display
+    result = "#{object.last_name}, #{object.first_name}".strip.gsub(/^, /,'').gsub(/,$/,'')
+    if result.blank?
+      result = "#{object.organization}"
+    end
+    return result
+  end
+end
diff --git a/app/serializers/switchboard_serializer.rb b/app/serializers/switchboard_serializer.rb
index 7ad7792..8a8bd42 100644
--- a/app/serializers/switchboard_serializer.rb
+++ b/app/serializers/switchboard_serializer.rb
@@ -1,7 +1,7 @@
 class SwitchboardSerializer < ActiveModel::Serializer
   embed :ids, :include => true
 
-  attributes :id, :name, :show_avatars, :blind_transfer_activated, :attended_transfer_activated
+  attributes :id, :name, :show_avatars, :blind_transfer_activated, :attended_transfer_activated, :search_activated
   has_many :switchboard_entries
   has_many :sip_accounts, :through => :switchboard_entries
   has_many :phone_numbers
diff --git a/app/views/switchboards/_form_core.html.haml b/app/views/switchboards/_form_core.html.haml
index a4fd15f..0bfcb86 100644
--- a/app/views/switchboards/_form_core.html.haml
+++ b/app/views/switchboards/_form_core.html.haml
@@ -6,3 +6,4 @@
   = f.input :amount_of_displayed_phone_numbers, :label => t('switchboards.form.amount_of_displayed_phone_numbers.label'), :hint => conditional_hint('switchboards.form.amount_of_displayed_phone_numbers.hint')
   = f.input :blind_transfer_activated, :label => t('switchboards.form.blind_transfer_activated.label'), :hint => conditional_hint('switchboards.form.blind_transfer_activated.hint')
   = f.input :attended_transfer_activated, :label => t('switchboards.form.attended_transfer_activated.label'), :hint => conditional_hint('switchboards.form.attended_transfer_activated.hint')
+  = f.input :search_activated, :label => t('switchboards.form.search_activated.label'), :hint => conditional_hint('switchboards.form.search_activated.hint')
\ No newline at end of file
diff --git a/app/views/switchboards/show.html.erb b/app/views/switchboards/show.html.erb
index 3bc4da4..b2cdbd4 100644
--- a/app/views/switchboards/show.html.erb
+++ b/app/views/switchboards/show.html.erb
@@ -26,6 +26,35 @@
         {{/each}}
       {{/if}}
 
+      {{#if search_activated}}
+        <div class="well span3 pull-right">
+          <p>
+            {{input type="text" value=searchText size="10" placeholder="Suchen..."}}
+          </p>
+          <ul>
+            {{#each phoneBookEntry in searchResults}}
+              <li>
+                {{phoneBookEntry.search_result_display}}<br />
+
+                {{#each phoneNumber in phoneBookEntry.phoneNumbers}}
+                  <span class="label">
+                    {{phoneNumber.number}}
+                  </span>
+
+                  {{#each dispatchableIncomingCall in dispatchableIncomingCalls}}
+                    {{#if blind_transfer_activated}}
+                      <button {{action transfer_blind dispatchableIncomingCall.id phoneNumber.number}} class="btn btn-small">Transfer</button>
+                    {{/if}}
+                    {{#if attended_transfer_activated}}
+                      <button {{action transfer_attended dispatchableIncomingCall.id phoneNumber.number}} class="btn btn-small">Attended Transfer</button>
+                    {{/if}}
+                  {{/each}}
+                {{/each}}
+              </li>
+            {{/each}}
+          </ul>
+        </div>
+      {{/if}}
 
       {{#if switchboardEntrys.length}}
         <ul class="thumbnails">