Class: CatalogsController

Inherits:
CrmController show all
Includes:
Controllers::Destroyable, Controllers::Showable
Defined in:
app/controllers/catalogs_controller.rb

Overview

== Schema Information

Table name: catalogs

id :integer not null, primary key
name :string(255)
created_at :datetime
updated_at :datetime
currency :string(255)
currency_symbol :string(255)
store_id :integer
is_discontinued :boolean default(FALSE)
for_admin :boolean default(FALSE), not null
company_id :integer
bom_enabled :boolean default(FALSE), not null
sales_manager_employee_record_id :integer
parent_catalog_id :integer
parent_catalog_discount :decimal(5, 4)

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

Constants included from Www::SeoHelper

Www::SeoHelper::AWARDS, Www::SeoHelper::CA_ADDRESS, Www::SeoHelper::CA_BUSINESS_HOURS, Www::SeoHelper::CA_CONTACT_POINT, Www::SeoHelper::CA_CURRENCIES, Www::SeoHelper::CA_DESCRIPTION, Www::SeoHelper::CA_FOUNDING_DATE, Www::SeoHelper::CA_GLOBAL_LOCATION_NUMBER, Www::SeoHelper::CA_LEGAL_NAME, Www::SeoHelper::CA_LOCAL_BUSINESS, Www::SeoHelper::CA_ONLINE_STORE, Www::SeoHelper::CA_RETURN_POLICY, Www::SeoHelper::CA_SALES_DEPARTMENT, Www::SeoHelper::CA_SERVICE_AREA, Www::SeoHelper::CA_URL, Www::SeoHelper::CA_VAT_ID, Www::SeoHelper::CA_WAREHOUSE_DEPARTMENT, Www::SeoHelper::CA_WAREHOUSE_HOURS, Www::SeoHelper::COMPANY_EMAIL, Www::SeoHelper::COMPANY_LOGO, Www::SeoHelper::COMPANY_NAME, Www::SeoHelper::COMPANY_SLOGAN, Www::SeoHelper::EXPERTISE, Www::SeoHelper::FAX_NUMBER, Www::SeoHelper::GS1_COMPANY_PREFIX, Www::SeoHelper::ISO6523_CODE, Www::SeoHelper::PAYMENT_METHODS, Www::SeoHelper::PHONE_NUMBER, Www::SeoHelper::PRIMARY_NAICS, Www::SeoHelper::REFUND_TYPE, Www::SeoHelper::RETURN_FEES, Www::SeoHelper::RETURN_METHOD, Www::SeoHelper::RETURN_POLICY_CATEGORY, Www::SeoHelper::SECONDARY_NAICS, Www::SeoHelper::SOCIAL_PROFILES, Www::SeoHelper::US_ADDRESS, Www::SeoHelper::US_BUSINESS_HOURS, Www::SeoHelper::US_CONTACT_POINT, Www::SeoHelper::US_CURRENCIES, Www::SeoHelper::US_DESCRIPTION, Www::SeoHelper::US_FOUNDING_DATE, Www::SeoHelper::US_GLOBAL_LOCATION_NUMBER, Www::SeoHelper::US_IMAGE, Www::SeoHelper::US_LEGAL_NAME, Www::SeoHelper::US_LOCAL_BUSINESS, Www::SeoHelper::US_ONLINE_STORE, Www::SeoHelper::US_RETURN_POLICY, Www::SeoHelper::US_SALES_DEPARTMENT, Www::SeoHelper::US_SERVICE_AREA, Www::SeoHelper::US_TAX_ID, Www::SeoHelper::US_URL, Www::SeoHelper::US_WAREHOUSE_DEPARTMENT, Www::SeoHelper::US_WAREHOUSE_HOURS

Constants included from IconHelper

IconHelper::CUSTOM_ICON_MAP, IconHelper::CUSTOM_SVG_DIR, IconHelper::DEFAULT_FAMILY

Instance Method Summary collapse

Methods included from Controllers::Showable

#perform_show

Methods included from Controllers::Destroyable

#destroy, #perform_destroy

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

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?, #stamp_impersonation_context, #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, #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 ApplicationHelper

#better_number_to_currency, #check_force_logout, #check_or_cross, #check_or_times, #embedded_tab_frame_id, #error_messages, #general_disclaimer_on_product_installation_and_local_codes, #gridjs_from_html_table, #gridjs_table, #is_wy_ip, #line_break, #parent_layout, #pass_or_fail, #render_error_messages_list, #render_video_card, #resolved_auth_form_turbo_frame, #return_path_or, #safe_css_color, #set_return_path_if_present, #set_section_if_present, #tab_frame_id, #to_underscore, #track_page?, #turbo_section_wrapper, #turbo_tabs_request?, #url_on_same_domain_as_request, #widget_index_daily_focus_index_path, #working_hours?, #yes_or_no, #yes_or_no_highlighted, #yes_or_no_with_check_or_cross, #youtube_video

Methods included from UppyUploaderHelper

#file_uploader, #image_uploader, #large_file_uploader_s3, #lead_sketch_uploader, #rma_image_uploader, #rma_image_uploader_s3, #uppy_uploader, #video_uploader

Methods included from Www::ImagesHelper

#image_asset_tag, #image_asset_url

Methods included from Www::SeoHelper

#add_page_schema, #add_webpage_schema, #canada?, #company_social_links, #ensure_context_json, #json_ld_script_tag, #local_business_schema, #online_store_id, #online_store_schema, #page_main_entity, #page_main_entity_json, #render_auto_collection_page_schema, #render_collection_page_schema, #render_local_business_schema, #render_online_store_schema, #render_page_schemas, #render_page_video_schemas, #render_webpage_schema, #render_webpage_schema_with_collections, #usa?

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?

Methods included from IconHelper

#account_nav_icon, #fa_icon, #star_rating_html

Instance Method Details

#create ⇒ Object 



157
158
159
160
161
162
163
164
165
 
# File 'app/controllers/catalogs_controller.rb', line 157

def create
  @catalog = Catalog.new(params[:catalog])
  authorize!(:create, @catalog)
  if @catalog.save
    redirect_to_return_path_or_default(catalog_path(@catalog))
  else
    render :new, status: :unprocessable_content
  end
end

#duplicate ⇒ Object 



140
141
142
143
144
145
146
147
148
149
150
 
# File 'app/controllers/catalogs_controller.rb', line 140

def duplicate
  @original_catalog = Catalog.find(params[:id])
  authorize!(:create, Catalog)
  @new_catalog = @original_catalog.deep_dup
  if @new_catalog.save
    redirect_to edit_catalog_path(@new_catalog), notice: 'New catalog created, please update if necessary'
  else
    flash[:error] = "#{@original_catalog.name} could not be duplicated, errors reported: #{@new_catalog.errors.full_messages.to_sentence}"
    redirect_to catalog_path(@original_catalog)
  end
end

#edit ⇒ Object 



152
153
154
155
 
# File 'app/controllers/catalogs_controller.rb', line 152

def edit
  @catalog = Catalog.find(params[:id])
  authorize!(:update, @catalog)
end

#index ⇒ Object 



26
27
28
29
30
31
32
33
 
# File 'app/controllers/catalogs_controller.rb', line 26

def index
  authorize!(:read, Catalog)
  p = params[:q].presence || {}
  p['is_discontinued_eq'] = false if p.empty?
  @q = Catalog.ransack(p)
  @q.sorts = ['parent_catalog_id desc', 'name asc'] if @q.sorts.blank?
  @pagy, @catalogs = pagy(@q.result.select_append("(select count(*) from catalog_items ci where ci.catalog_id = catalogs.id and ci.state = 'active') as active_counter"), limit: 100)
end

#new ⇒ Object 



132
133
134
135
136
137
138
 
# File 'app/controllers/catalogs_controller.rb', line 132

def new
  @store = Store.find(params[:store_id]) if params[:store_id]
  @catalog = (@store&.catalogs || Catalog).new(params[:catalog])
  @catalog.apply_default_locales
  @catalog.apply_default_country
  authorize!(:create, @catalog)
end

#product_line_analysis ⇒ Object 



178
179
180
181
182
 
# File 'app/controllers/catalogs_controller.rb', line 178

def product_line_analysis
  @catalog = Catalog.find(params[:id])
  @q = ProductLine.ransack(params[:q] || { id_in: @catalog.product_line_ids_for_analysis })
  @product_lines = @q.result.order(:lineage_expanded)
end

#show ⇒ Object

GET /catalogs/1



36
37
38
39
 
# File 'app/controllers/catalogs_controller.rb', line 36

def show
  @catalog = Catalog.find(params[:id])
  authorize!(:read, @catalog)
end

#sync_prices ⇒ Object 



184
185
186
187
188
189
190
191
192
193
194
 
# File 'app/controllers/catalogs_controller.rb', line 184

def sync_prices
  @catalog = Catalog.find(params[:id])
  authorize!(:update, @catalog)
  result = Catalog::SynchronizeCatalogPrices.new.process(@catalog, force_sync: true)
  if result.all_items_synchronized?
    flash[:info] = "#{result.catalog_items_updated.size} items updated"
  else
    flash[:warning] = ["#{result.catalog_items_updated.size} items updated", "#{result.catalog_items_failed.size} items failed", *result.messages]
  end
  redirect_to @catalog
end

#tab_images ⇒ Object 



74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
 
# File 'app/controllers/catalogs_controller.rb', line 74

def tab_images
  load_and_authorize_catalog
  @marketplace = helpers.catalog_image_profile_marketplace(@catalog)
  @marketplace_name = helpers.catalog_marketplace_name(@catalog)

  # Get active catalog items with their items, excluding publications
  non_publication_category_ids = ProductCategory.all_non_publication_goods_ids
  @active_catalog_items = @catalog.catalog_items
                                  .where(state: 'active')
                                  .joins(store_item: :item)
                                  .where(items: { product_category_id: non_publication_category_ids })

  # Calculate image statistics
  item_ids = @active_catalog_items.pluck('items.id').uniq
  @total_items = item_ids.count

  # Determine full profile count (excluding SWCH swatch)
  # AMZ has MAIN + PT01-PT11 = 12 main types
  # WAL has MAIN + AD01-AD10 = 11 types
  # WYS has MAIN + I01-I15 = 16 types
  @max_image_count = case @marketplace
                     when :AMZ then 12
                     when :WAL then 11
                     else 16
                     end

  # Count images per item
  image_counts = ImageProfile.where(item_id: item_ids)
                             .where('image_type LIKE ?', "#{@marketplace}_%")
                             .where('image_type NOT LIKE ?', '%SWCH')
                             .group(:item_id)
                             .count

  # Build distribution: how many items have exactly N images
  @image_distribution = (0..@max_image_count).map do |n|
    count = if n.zero?
              @total_items - image_counts.keys.count
            else
              image_counts.count { |_id, c| c == n }
            end
    percentage = @total_items.positive? ? (count.to_f / @total_items * 100).round(1) : 0
    { count: n, items: count, percentage: percentage }
  end
  respond_to do |format|
    format.html { render layout: should_render_layout? }
    format.turbo_stream
  end
end

#tab_items ⇒ Object 



50
51
52
53
54
55
56
 
# File 'app/controllers/catalogs_controller.rb', line 50

def tab_items
  load_and_authorize_catalog
  respond_to do |format|
    format.html { render layout: should_render_layout? }
    format.turbo_stream
  end
end

#tab_overview ⇒ Object

Tab actions for turbo-tabs lazy loading



42
43
44
45
46
47
48
 
# File 'app/controllers/catalogs_controller.rb', line 42

def tab_overview
  load_and_authorize_catalog
  respond_to do |format|
    format.html { render layout: should_render_layout? }
    format.turbo_stream
  end
end

#tab_relationships ⇒ Object 



66
67
68
69
70
71
72
 
# File 'app/controllers/catalogs_controller.rb', line 66

def tab_relationships
  load_and_authorize_catalog
  respond_to do |format|
    format.html { render layout: should_render_layout? }
    format.turbo_stream
  end
end

#tab_settings ⇒ Object 



58
59
60
61
62
63
64
 
# File 'app/controllers/catalogs_controller.rb', line 58

def tab_settings
  load_and_authorize_catalog
  respond_to do |format|
    format.html { render layout: should_render_layout? }
    format.turbo_stream
  end
end

#update ⇒ Object 



167
168
169
170
171
172
173
174
175
176
 
# File 'app/controllers/catalogs_controller.rb', line 167

def update
  @catalog = Catalog.find(params[:id])
  authorize!(:update, @catalog)
  result = Catalog::UpdateCatalog.new.process(@catalog, params[:catalog])
  if result.catalog_updated?
    redirect_to_return_path_or_default(catalog_path(@catalog), notice: result.messages.join(', '))
  else
    render :edit, status: :unprocessable_content
  end
end