Class: Crm::SiteMapsController

Inherits:

CrmController

Object
ActionController::Base
ApplicationController
CrmController
Crm::SiteMapsController

show all

Defined in:: app/controllers/crm/site_maps_controller.rb

Constant Summary collapse

PATH_PREDICATES =

{
  'contains'    => ->(val) { ['site_maps.path ILIKE ?', "%#{val}%"] },
  'starts_with' => ->(val) { ['site_maps.path ILIKE ?', "#{val}%"] },
  'ends_with'   => ->(val) { ['site_maps.path ILIKE ?', "%#{val}"] },
  'equals'      => ->(val) { ['site_maps.path = ?', val] }
}.freeze

Constants included from Www::SeoHelper

Constants included from IconHelper

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

Instance Method Summary collapse

#action_items ⇒ Object
#add_keyword ⇒ Object
POST /site_maps/:id/add_keyword — add a keyword to this page's list (ad-hoc, not from sync).
#analyze ⇒ Object
#analyze_only ⇒ Object
#analyze_premium ⇒ Object
#apply_suggestion_to_selected ⇒ Object
PATCH /site_maps/:id/apply_suggestion_to_selected — set keyword_target from intent-based suggestion for selected keywords.
#index ⇒ Object
#lookup ⇒ Object
GET /site_maps/lookup.json — TomSelect-compatible search for sitemap paths.
#perform ⇒ Object
#recrawl ⇒ Object
#regenerate ⇒ Object
#show ⇒ Object
#sync_ga4 ⇒ Object
#sync_gsc ⇒ Object
#sync_keywords ⇒ Object
#sync_visits ⇒ Object
#update_keyword_target ⇒ Object
PATCH /site_maps/:id/update_keyword_target?seo_page_keyword_id=123&keyword_target=desired.
#update_seo_targeting ⇒ Object

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, #initialize_crm_lazy_chunks, #record_not_found, #redirect_to_job_or_fallback, #render_edit_action, #set_context, #set_download_path, #stash_file_for_temp_download

Methods inherited from ApplicationController

#account_impersonated?, #add_to_flash, #append_token, #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::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, #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_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!, #authenticate_account_from_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, #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, #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

#action_items ⇒ `Object`

# File 'app/controllers/crm/site_maps_controller.rb', line 292

def action_items
  authorize! :manage, SiteMap
  rec_scope = filtered_recommendations_scope

  paths_with_recs = rec_scope.joins(:site_map)
                             .select('site_maps.path')
                             .distinct
                             .order('site_maps.path')
                             .pluck('site_maps.path')

  @pagy, paginated_paths = pagy_paths(paths_with_recs, limit: 50)

  site_maps_for_paths = SiteMap.where(path: paginated_paths).order(:path, :locale).index_by(&:id)
  site_map_ids = site_maps_for_paths.keys

  recs = rec_scope.where(site_map_id: site_map_ids)
                  .includes(:site_map)
                  .by_priority
                  .order(created_at: :desc)

  @path_groups = build_path_groups(paginated_paths, recs)

  respond_to do |format|
    format.html
    format.turbo_stream
  end
end

#add_keyword ⇒ `Object`

POST /site_maps/:id/add_keyword — add a keyword to this page's list (ad-hoc, not from sync)

# File 'app/controllers/crm/site_maps_controller.rb', line 180

def add_keyword
  authorize! :manage, SiteMap
  @site_map = SiteMap.find(params[:id])
  raw = params[:keyword].to_s.strip
  if raw.blank?
    flash[:error] = 'Keyword cannot be blank.'
    redirect_to site_map_path(@site_map, anchor: 'sm-keywords') and return
  end
  if SeoPageKeyword.noise?(raw)
    flash[:error] = 'Keyword is too short or invalid.'
    redirect_to site_map_path(@site_map, anchor: 'sm-keywords') and return
  end
  existing = @site_map.seo_page_keywords.find_by('LOWER(keyword) = ?', raw.downcase)
  if existing
    flash[:info] = "Keyword already in list."
    redirect_to site_map_path(@site_map, anchor: 'sm-keywords') and return
  end
  @site_map.seo_page_keywords.create!(keyword: raw, position: nil)
  flash[:success] = "Added \"#{raw}\" to this page's keywords."
  redirect_to site_map_path(@site_map, anchor: 'sm-keywords')
rescue ActiveRecord::RecordInvalid => e
  flash[:error] = e.record.errors.full_messages.to_sentence
  redirect_to site_map_path(@site_map, anchor: 'sm-keywords')
end

#analyze ⇒ `Object`

# File 'app/controllers/crm/site_maps_controller.rb', line 67

def analyze
  authorize! :manage, SiteMap
  @site_map = SiteMap.find(params[:id])

  options = { return_path: site_map_path(@site_map) }
  job_id = SeoPageAnalysisWorker.perform_async(@site_map.id, options)

  if job_id
    flash[:info] = 'SEO analysis started. You will be redirected when complete.'
    redirect_to job_path(job_id)
  else
    flash[:warning] = 'An analysis for this page is already running. Please wait for it to finish.'
    redirect_to site_map_path(@site_map)
  end
end

#analyze_only ⇒ `Object`

# File 'app/controllers/crm/site_maps_controller.rb', line 83

def analyze_only
  authorize! :manage, SiteMap
  @site_map = SiteMap.find(params[:id])

  options = { return_path: site_map_path(@site_map), skip_syncs: true }
  job_id = SeoPageAnalysisWorker.perform_async(@site_map.id, options)

  if job_id
    flash[:info] = 'AI analysis started (using existing data). You will be redirected when complete.'
    redirect_to job_path(job_id)
  else
    flash[:warning] = 'An analysis for this page is already running. Please wait for it to finish.'
    redirect_to site_map_path(@site_map)
  end
end

#analyze_premium ⇒ `Object`

# File 'app/controllers/crm/site_maps_controller.rb', line 99

def analyze_premium
  authorize! :manage, SiteMap
  @site_map = SiteMap.find(params[:id])

  options = { return_path: site_map_path(@site_map), premium: true }
  job_id = SeoPageAnalysisWorker.perform_async(@site_map.id, options)

  if job_id
    flash[:info] = 'Premium SEO analysis started (Opus). You will be redirected when complete.'
    redirect_to job_path(job_id)
  else
    flash[:warning] = 'An analysis for this page is already running. Please wait for it to finish.'
    redirect_to site_map_path(@site_map)
  end
end

#apply_suggestion_to_selected ⇒ `Object`

PATCH /site_maps/:id/apply_suggestion_to_selected — set keyword_target from intent-based suggestion for selected keywords

# File 'app/controllers/crm/site_maps_controller.rb', line 163

def apply_suggestion_to_selected
  authorize! :manage, SiteMap
  @site_map = SiteMap.find(params[:id])
  ids = Array(params[:seo_page_keyword_ids]).map(&:to_i).compact.uniq

  updated = 0
  @site_map.seo_page_keywords.where(id: ids).find_each do |pk|
    suggestion = @site_map.suggested_keyword_target_for(pk.keyword, search_volume: pk.search_volume)
    pk.update!(keyword_target: suggestion)
    updated += 1
  end

  flash[:success] = "Applied suggestion to #{updated} keyword(s)."
  redirect_to site_map_path(@site_map, anchor: 'sm-keywords')
end

#index ⇒ `Object`

# File 'app/controllers/crm/site_maps_controller.rb', line 2

def index
  authorize! :manage, SiteMap
  @search_form = Crm::SiteMapSearchForm.new(params)
  @search_form.ransack_search.sorts = 'updated_at desc' if @search_form.ransack_search.sorts.empty?
  @pagy, @site_maps = pagy(:countless, @search_form.results, limit: 50)

  load_index_stats
  load_recommendation_counts
  load_ads_spend

  handle_auto_purge_action if @search_form.auto_purge?
end

#lookup ⇒ `Object`

GET /site_maps/lookup.json — TomSelect-compatible search for sitemap paths

# File 'app/controllers/crm/site_maps_controller.rb', line 54

def lookup
  authorize! :manage, SiteMap

  term = params[:q].to_s.strip
  scope = SiteMap.active.where(locale: 'en-US')
  scope = term.present? ? scope.lookup_search(term) : scope.order(:path)

  render json: TomSelect.format_json_results(self, scope, params[:page], params[:per_page]) { |sm|
    title = sm.extracted_title.presence
    { id: sm.path, text: title ? "#{sm.path} — #{title}" : sm.path }
  }
end

#perform ⇒ `Object`

# File 'app/controllers/crm/site_maps_controller.rb', line 15

def perform
  authorize! :manage, SiteMap
  @search_form = Crm::SiteMapSearchForm.new(params)
  @site_maps = @search_form.results.where(id: params[:smids])

  if params[:fetch].present?
    Cache::SiteCrawler.new.process(pages: @site_maps)
    flash[:info] = 'Cached warmed up for selected urls'
    @site_maps.reload
  elsif params[:purge].present? || params[:purge_all].present?
    urls = @site_maps.map(&:url)
    EdgeCacheWorker.perform_async('urls' => urls)
    flash[:info] = "Edge Cache Purge queued for #{urls.size} url(s)"
  elsif params[:purge_by_tag].present?
    purge_selected_by_tag
  else
    flash[:warning] = 'No action selected'
  end

  @pagy, @site_maps = pagy(:countless, @search_form.results, limit: 50)
  load_index_stats
  load_recommendation_counts
  load_ads_spend
  render :index
end

#recrawl ⇒ `Object`

# File 'app/controllers/crm/site_maps_controller.rb', line 275

def recrawl
  authorize! :manage, SiteMap
  @site_map = SiteMap.find(params[:id])
  Cache::SiteCrawler.new.process(pages: SiteMap.where(id: @site_map.id), extract_content: true)
  @site_map.reload
  schema_summary = @site_map.rendered_schema_types.join(', ').presence || 'none'
  flash[:info] = "Recrawled #{@site_map.path} — Status: #{@site_map.last_status}, Schema: #{schema_summary}"
  redirect_back_or_to site_maps_path
end

#regenerate ⇒ `Object`

# File 'app/controllers/crm/site_maps_controller.rb', line 41

def regenerate
  authorize! :manage, SiteMap
  job_id = ServiceRunner.perform_async([Sitemap::SitemapGenerator.name])
  flash[:info] = "Job #{job_id} was enqued"
  redirect_to_return_path_or_default site_maps_path
end

#show ⇒ `Object`

# File 'app/controllers/crm/site_maps_controller.rb', line 48

def show
  authorize! :manage, SiteMap
  @site_map = SiteMap.find(params[:id])
end

#sync_ga4 ⇒ `Object`

# File 'app/controllers/crm/site_maps_controller.rb', line 245

def sync_ga4
  authorize! :manage, SiteMap
  @site_map = SiteMap.find(params[:id])

  ga4 = Seo::Ga4ApiClient.new
  start_date = 30.days.ago.to_date
  end_date = Date.yesterday
  page_path = "/#{@site_map.locale}#{@site_map.path}"
  metrics = ga4.page_metrics(page_path: page_path, start_date: start_date, end_date: end_date)

  if metrics
    SiteMapDataPoint.bulk_record!(
      site_map: @site_map,
      metrics: { ga4_page_views: metrics[:screen_page_views], ga4_sessions: metrics[:sessions],
                 ga4_users: metrics[:total_users],
                 ga4_bounce_rate: (metrics[:bounce_rate].to_f * 100).round(2),
                 ga4_engagement_rate: (metrics[:engagement_rate].to_f * 100).round(2),
                 ga4_avg_session_duration: metrics[:average_session_duration]&.round(2) },
      period_start: start_date, period_end: end_date
    )
    flash[:success] = "GA4 synced — #{metrics[:screen_page_views]} page views, #{metrics[:sessions]} sessions"
  else
    flash[:info] = "No GA4 data found for #{page_path}"
  end
  redirect_back_or_to site_map_path(@site_map)
rescue StandardError => e
  flash[:error] = "GA4 sync failed: #{e.message}"
  redirect_back_or_to site_map_path(@site_map)
end

#sync_gsc ⇒ `Object`

# File 'app/controllers/crm/site_maps_controller.rb', line 218

def sync_gsc
  authorize! :manage, SiteMap
  @site_map = SiteMap.find(params[:id])

  gsc = Seo::McpClients.gsc
  start_date = 28.days.ago.to_date
  end_date = Date.yesterday
  metrics = gsc.page_metrics(page_url: @site_map.production_url, start_date: start_date, end_date: end_date)

  if metrics
    SiteMapDataPoint.bulk_record!(
      site_map: @site_map,
      metrics: { gsc_clicks: metrics[:clicks], gsc_impressions: metrics[:impressions],
                 gsc_ctr: metrics[:ctr], gsc_avg_position: metrics[:position] },
      period_start: start_date, period_end: end_date
    )
    @site_map.update_columns(seo_clicks: metrics[:clicks])
    flash[:success] = "GSC synced — #{metrics[:clicks]} clicks, #{metrics[:impressions]} impressions"
  else
    flash[:info] = "No GSC data found for #{@site_map.production_url}"
  end
  redirect_back_or_to site_map_path(@site_map)
rescue StandardError => e
  flash[:error] = "GSC sync failed: #{e.message}"
  redirect_back_or_to site_map_path(@site_map)
end

#sync_keywords ⇒ `Object`

# File 'app/controllers/crm/site_maps_controller.rb', line 115

def sync_keywords
  authorize! :manage, SiteMap
  @site_map = SiteMap.find(params[:id])

  result = Seo::KeywordSyncService.new(site_map: @site_map).process

  if result[:error]
    flash[:error] = "Keyword sync failed: #{result[:error]}"
  else
    source = result[:source] == 'gsc' ? 'GSC' : 'Ahrefs'
    flash[:success] = "Synced #{result[:keywords_synced]} keywords via #{source}"
  end

  redirect_back_or_to site_map_path(@site_map)
end

#sync_visits ⇒ `Object`

# File 'app/controllers/crm/site_maps_controller.rb', line 205

def sync_visits
  authorize! :manage, SiteMap
  @site_map = SiteMap.find(params[:id])

  Seo::VisitsSyncService.new(site_map_ids: [@site_map.id]).process
  @site_map.reload
  flash[:success] = "Visit counts synced — 30d: #{@site_map.visit_count_30d || 0}"
  redirect_back_or_to site_map_path(@site_map)
rescue StandardError => e
  flash[:error] = "Visit sync failed: #{e.message}"
  redirect_back_or_to site_map_path(@site_map)
end

#update_keyword_target ⇒ `Object`

PATCH /site_maps/:id/update_keyword_target?seo_page_keyword_id=123&keyword_target=desired

# File 'app/controllers/crm/site_maps_controller.rb', line 145

def update_keyword_target
  authorize! :manage, SiteMap
  @site_map = SiteMap.find(params[:id])
  pk = @site_map.seo_page_keywords.find(params.require(:seo_page_keyword_id))

  value = params[:keyword_target].to_s.strip.presence
  value = nil if value.present? && !SeoPageKeyword.keyword_targets.key?(value)

  if pk.update(keyword_target: value)
    flash[:success] = 'Keyword target updated.'
  else
    flash[:error] = pk.errors.full_messages.to_sentence
  end

  redirect_to site_map_path(@site_map, anchor: 'sm-keywords')
end

#update_seo_targeting ⇒ `Object`

# File 'app/controllers/crm/site_maps_controller.rb', line 131

def update_seo_targeting
  authorize! :manage, SiteMap
  @site_map = SiteMap.find(params[:id])

  if @site_map.update(seo_targeting_params)
    flash[:success] = 'Target keyword updated.'
  else
    flash[:error] = @site_map.errors.full_messages.to_sentence
  end

  redirect_back_or_to site_map_path(@site_map)
end

Class: Crm::SiteMapsController

Constant Summary collapse

Constants included from Controllers::ReferenceFindable

Constants included from Controllers::AnalyticsEvents

Constants included from Controllers::ErrorRendering