Class: Crm::RedactorProductPickerController

Inherits:
CrmController show all
Includes:
ActionView::Helpers::NumberHelper
Defined in:
app/controllers/crm/redactor_product_picker_controller.rb

Overview

Controller: redactor product picker.

Constant Summary

Constants included from Controllers::ReferenceFindable

Controllers::ReferenceFindable::ID_EMBEDDED_PATTERNS

Constants included from Controllers::AnalyticsEvents

Controllers::AnalyticsEvents::MAX_QUEUED_EVENTS, Controllers::AnalyticsEvents::SESSION_KEY

Constants included from Controllers::ErrorRendering

Controllers::ErrorRendering::NON_CONTENT_PATH_PREFIXES

Instance Method Summary collapse

Methods inherited from CrmController

#access_denied, #context_id, #context_object, #crm_home_path, #current_ability, #default_url_options, #download_temp, #get_tempfile_path_for_download, #init_status_job_collector, #initialize_crm_lazy_chunks, #persist_enqueued_status_jobs, #record_not_found, #redirect_to_job_or_fallback, #render_edit_action, #set_context, #set_download_path, #stash_file_for_temp_download, #sync_admin_presence_cookie, #touch_employee_last_seen

Methods inherited from ApplicationController

#account_impersonated?, #add_to_flash, #after_sign_in_path_for, #bypass_forgery_protection?, #chat_enabled?, #cloudflare_cleared?, #default_catalog, #default_url_options, #enable_turbo_frames, #find_publication, #fix_invalid_accept_header, #init_js_utils, #is_globals_call?, #layout_by_resource, #locale_store, #redirect_to, #require_employee_for_crm, #set_base_host, #set_real_ip, #set_report_errors_for, #should_render_layout?, #skip_layout_for_turbo_frame?, #stamp_impersonation_context, #tab_frame_breakout_request?, #warmlyyours_canada_ip?, #warmlyyours_ip?, #y

Methods included from Controllers::ReturnPathHandling

#check_for_return_path, #redirect_to_return_path_or_default

Methods included from Controllers::AnalyticsEvents

#consume_queued_analytics_events, #registration_lead_type, #track_event

Methods included from Controllers::DeviceDetection

#device_detector, #is_ie?

Methods included from Controllers::SubdomainDetection

#is_crm_request?, #is_www_request?, #json_request?

Methods included from Controllers::TurboSafeRedirect

#redirect_to

Methods included from Controllers::TrackingDetection

#bot_request?, #gdpr_country?, #gdpr_country_data, #prevent_bots, #set_tracking_cookie, #track_visitor?

Methods included from Controllers::AcceleratedFileSending

#send_file_accelerated, #send_upload_accelerated

Methods included from Controllers::ErrorRendering

#excp_string, #mail_to_for_error_reporting, #render_400, #render_404, #render_406, #render_410, #render_500, #render_invalid_authenticity_token, #render_ip_spoof_error, #render_unpermitted_parameters, #safe_referer_or_fallback

Methods included from Controllers::TurnstileVerification

#load_turnstile_script_tag, #turnstile_lazy_widget, #turnstile_script_tag, #turnstile_widget, #validate_turnstile!

Methods included from Controllers::CloudflareCaching

edge_cached, #edge_cached_action?, #reset_cloudflare_cache, #set_cloudflare_cache, #skip_edge_cache!, #skip_session

Methods included from Controllers::Webpackable

#preload_webpack_fonts, #webpack_css_include, #webpack_css_url, #webpack_js_include, #wpd_is_running?

Methods included from Controllers::Localizable

#cloudflare_country_locale, #determine_request_locale, #geocoder_locale, #guest_user_locale_check, #locale_optional_www_auth_path?, #param_locale, #set_locale, #set_request_locale, #skip_localization?, #warmlyyours_ip_locale

Methods included from Controllers::Authenticable

#access_denied, #authenticate_account, #authenticate_account!, #authenticate_account_from_login_token!, #check_is_a_manager, #check_is_a_sales_manager, #check_is_an_admin, #check_is_an_employee, #check_party, #clear_mismatched_guest_user, #create_guest_user, #credentials?, #current_or_guest_user, #current_or_guest_user_id_read_only, #current_user, #devise_mapping, #fully_logged_in?, #generate_bot_id, #guest_user, #identifiable?, #init_current_user, #initialize_guest, #load_context_user, #logging_in, #resource, #resource_name, #restrict_access_for_non_employees, #scrubbed_request_path, #user_object, #warn_on_session_guest_id_leak

Methods included from UrlsHelper

#catalog_breadcrumb_links, #catalog_link, #catalog_link_for_product_line, #catalog_link_for_sku, #cms_link, #delocalized_path, #path_to_sales_product_sku, #path_to_sales_product_sku_for_product_line, #path_to_sales_product_sku_for_product_line_slug, #product_line_from_catalog_link, #protocol_neutral_url, #sanitize_external_url, #valid_external_url?

Instance Method Details

This method returns an undefined value.

Renders the product picker modal for Redactor integration.



10
11
12
13
 
# File 'app/controllers/crm/redactor_product_picker_controller.rb', line 10

def modal
  render partial: 'crm/redactor_product_picker/modal',
         locals: { callback: params[:callback] || 'productPickerCallback' }
end

#search ⇒ void

This method returns an undefined value.

Searches products for the picker modal.

Supports two query modes:

  • ?q=search_term - Full-text search by name or SKU
  • ?sku=ABC123 - Fetch specific product by SKU (for pre-selection)

Returns paginated product results with pricing, images, and metadata.



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
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
 
# File 'app/controllers/crm/redactor_product_picker_controller.rb', line 24

def search
  # If specific SKU is requested, fetch that product
  if params[:sku].present?
    sku = params[:sku].to_s.strip.upcase
    item = Item.non_publications.find_by(sku: sku)

    if item
      return render json: {
        products: [product_to_json(item)],
        page: 1,
        per_page: 1,
        total_count: 1,
        total_pages: 1,
        last_page: true
      }
    else
      return render json: {
        products: [],
        page: 1,
        per_page: 1,
        total_count: 0,
        total_pages: 0,
        last_page: true
      }
    end
  end

  query = params[:q].to_s.strip
  page = (params[:page] || 1).to_i
  per_page = (params[:per_page] || 20).to_i.clamp(1, 50)

  # Search active items with product category; exclude publications (only products)
  items = Item.active
              .non_publications
              .where.not(product_category_id: nil)
              .includes(:primary_image)

  if query.present?
    # Search by SKU or name (public_short_name is the public display name column)
    items = items.where(
      'items.sku ILIKE :q OR items.name ILIKE :q OR items.public_short_name ILIKE :q',
      q: "%#{query}%"
    )
  end

  # Order by public_short_name (coalesce with name for items without public_short_name)
  items = items.order(Arel.sql('COALESCE(NULLIF(items.public_short_name, \'\'), items.name)'))

  # Paginate
  offset = (page - 1) * per_page
  total_count = items.count
  Rails.logger.info "[ProductPicker] Query: '#{query}', Total count: #{total_count}"

  items = items.offset(offset).limit(per_page)

  total_pages = (total_count.to_f / per_page).ceil
  last_page = page >= total_pages

  products_json = items.map { |item| product_to_json(item) }
  Rails.logger.info "[ProductPicker] Returning #{products_json.size} products"

  render json: {
    products: products_json,
    page: page,
    per_page: per_page,
    total_count: total_count,
    total_pages: total_pages,
    last_page: last_page
  }
rescue StandardError => e
  Rails.logger.error "[ProductPicker] Search error: #{e.class}: #{e.message}"
  Rails.logger.error e.backtrace.first(10).join("\n")
  render json: { error: e.message, products: [] }, status: :internal_server_error
end