Class: OpportunitySearch

Inherits:
Search show all
Includes:
Models::RepSearchable
Defined in:
app/models/opportunity_search.rb

Overview

== Schema Information

Table name: searches
Database name: primary

id :integer not null, primary key
name :string(255)
persist :boolean default(FALSE)
pinned :boolean default(FALSE), not null
query_params :jsonb
result_set_size :integer default(0)
selected_columns :string is an Array
set_limit :integer default(25)
sort_column :string(255)
sort_columns :string default([]), not null, is an Array
sort_direction :string(255) default("ASC")
type :string(255) not null
created_at :datetime
updated_at :datetime
employee_id :integer

Indexes

employee_id_pinned (employee_id,pinned)
employee_id_type (employee_id,type)

Constant Summary

Constants inherited from Search

Search::DISTANCE_SEARCH_KEYS

Instance Attribute Summary

Attributes inherited from Search

#composite_columns, #pagy_count, #pagy_limit, #pagy_page, #sort_column1, #sort_column2, #sort_column3, #sql_select_columns

Instance Method Summary collapse

Methods inherited from Search

#all_composite_columns, allowed_role_ids, #append_custom_column, #append_ouput_column, #append_to_sql_select_columns, #applicable_sort_terms, #apply_array_match, #apply_criteria, #apply_customer_cross_reference, #apply_distance_search, #apply_select, #apply_sort, #available_events, available_output_columns, #available_output_columns, base_search_class_name, #cleanup_search_results, composite_column, #composite_column, custom_criteria_keys, database_columns, default_columns, default_sort, #discard_excess, #effective_name, #effective_short_name, #employee, #enqueue_navbar_pinned_refresh, #fast_count, favorites, friendly_column_name, #get_pinned_results, #get_sort_term, global_favorite, has_role_for_search?, #human_query_params, instantiate_query_template, #instantiate_resource_updater, #limit_options, main_resource_class, main_resource_table, mass_actions_for_select, #mass_export, maximum_unpersisted_queries, #normalize_for_mass_update, options, options_classes, #output_columns_for_select, #pagy_from_search, #perform, #perform_selected, #pinned_query, #prepend_custom_column, #prepend_output_column, query_favorites_templates, #ransack_probe_params, recent_searches_for_employee_id, #record_list, #refresh_pinned_results, #remove_other_pins, search_name, #search_name, #search_results, search_type, search_type_humanized, select_sort_columns, #select_sort_columns, #select_statement, #set_defaults, #set_sort_term, #sort_columns_for_select, #sort_columns_to_hash, #target_geocoding, unpersisted_queries_quote_reached?, #unrecord_list, #validated_selected_columns, view_resource_class, view_resource_klass, #view_resource_klass, view_resource_table, visible?, with_search_results

Methods inherited from ApplicationRecord

ransackable_associations, ransackable_attributes, ransackable_scopes, ransortable_attributes, #to_relation

Methods included from Models::EventPublishable

#publish_event

Instance Method Details

#apply_custom_criteria(results) ⇒ Object

Legacy IQ global_favorite removed - IQ system deprecated



47
48
49
50
# File 'app/models/opportunity_search.rb', line 47

def apply_custom_criteria(results)
  results = apply_distance_search(results, lat_column: 'latitude', lng_column: 'longitude')
  apply_customer_cross_reference(results, :customer_id)
end

#mass_assign_reps(params, cur_user = nil) ⇒ Object



94
95
96
97
98
99
100
101
102
# File 'app/models/opportunity_search.rb', line 94

def mass_assign_reps(params, cur_user = nil)
  jid = MassSearch::OpportunityAssignRepsWorker.perform_async(
    'search_id'     => id,
    'action_params' => { 'resource_params' => (params[:resource] || {}).to_h, 'activity' => (params[:activity] || {}).to_h },
    'user_id'       => cur_user&.id,
    'locale'        => I18n.locale.to_s
  )
  { status: :ok, job_id: jid }
end

#mass_assign_source(params, cur_user = nil) ⇒ Object



84
85
86
87
88
89
90
91
92
# File 'app/models/opportunity_search.rb', line 84

def mass_assign_source(params, cur_user = nil)
  jid = ::SearchResourceUpdateWorker.perform_async(
    'search_id'     => id,
    'action_params' => { 'resource_params' => { 'source_id' => params[:source_id] } },
    'user_id'       => cur_user&.id,
    'locale'        => I18n.locale.to_s
  )
  { status: :ok, job_id: jid }
end

#mass_googlemap_direct(_params, _cur_user_id = 1) ⇒ Object



52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
# File 'app/models/opportunity_search.rb', line 52

def mass_googlemap_direct(_params, _cur_user_id = 1)
  result_data = []

  search_results.each do |sr|
    unless sr.resource.geocoded?
      sr.resource.geocode
      sr.resource.save if sr.resource.geocoded?
    end
    next unless sr.resource.geocoded?

    result_data <<
      {
        latitude: sr.resource.latitude,
        longitude: sr.resource.longitude,
        title: sr.resource.name,
        resource: sr.resource,
        json: { party_id: sr.resource.customer_id, opportunity_id: sr.resource.id }
      }
  end
  { status: :ok, result_action: 'googlemap_direct', result_data: }
end

#mass_schedule_activity(params, cur_user = nil) ⇒ Object



74
75
76
77
78
79
80
81
82
# File 'app/models/opportunity_search.rb', line 74

def mass_schedule_activity(params, cur_user = nil)
  jid = MassSearch::OpportunityScheduleActivityWorker.perform_async(
    'search_id'     => id,
    'action_params' => { 'activity' => (params[:activity] || {}).to_h, 'campaign_id' => params[:campaign_id] },
    'user_id'       => cur_user&.id,
    'locale'        => I18n.locale.to_s
  )
  { status: :ok, job_id: jid }
end