Class: StoresController

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

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, #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, #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

#all_addresses ⇒ Object 



73
74
75
76
77
78
79
80
81
82
83
84
85
 
# File 'app/controllers/stores_controller.rb', line 73

def all_addresses
  company_id = params[:company_id].presence
  results = Store.includes(:warehouse_address).order('stores.id ASC')
  results = results.where(company_id: company_id) if company_id
  json_results = results.map do |s|
    {
      id: s.warehouse_address.id,
      recipient: s.warehouse_address.to_s,
      company_id: s.company_id
    }
  end
  render json: json_results
end

#create ⇒ Object 



19
20
21
22
23
24
25
26
 
# File 'app/controllers/stores_controller.rb', line 19

def create
  @store = Store.new(params[:store])
  if @store.save
    redirect_to_return_path_or_default store_path(@store)
  else
    render :new, status: :unprocessable_entity
  end
end

#edit ⇒ Object 



15
16
17
 
# File 'app/controllers/stores_controller.rb', line 15

def edit
  @store = Store.find(params[:id])
end

#index ⇒ Object 



7
8
9
 
# File 'app/controllers/stores_controller.rb', line 7

def index
  @stores = Store.order('name')
end

#inventory ⇒ Object 



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
 
# File 'app/controllers/stores_controller.rb', line 37

def inventory
  @q = ViewStock.ransack(params[:q])
  @pagy, @items = pagy(@q.result, limit: 100)

  sql = <<-SQL
    with amz_items as (
        select distinct i.id as item_id
        from items i
        inner join store_items si on i.id = si.item_id
        where store_id in (3,5)
        and si.location = 'AVAILABLE'

    ), data_result as (
        select sku,
        sum(case when store_id = 3 then qty_on_hand else 0 end) as amazon_us,
        sum(case when store_id = 5 then qty_on_hand else 0 end) as amazon_ca,
        sum(case when store_id = 1 then qty_on_hand else 0 end) as wy_us,
        sum(case when store_id = 2 then qty_on_hand else 0 end) as wy_ca
        from items i
        inner join store_items si on i.id = si.item_id
        inner join amz_items ai on ai.item_id = i.id
        where si.location = 'AVAILABLE'
        group by sku
    )
    select * from data_result order by sku;
  SQL

  @amazon_inventory = ActiveRecord::Base.connection.execute(sql)
end

#lookup ⇒ Object 



87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
 
# File 'app/controllers/stores_controller.rb', line 87

def lookup
  @stores = Store.order('name')
  if store_id = params[:store_id]
    @stores = @stores.where(id: store_id)
  elsif params[:company_id]
    @stores = @stores.where(company_id: params[:company_id])
    if q = params[:q].presence || params[:term].presence
      @stores = @stores.where("name ilike '%#{q}%'")
    end
  else
    @stores = @stores.none
  end
  res = TomSelect.format_json_results(self, @stores, params[:page], params[:per_page]) do |e|
    { id: e.id, text: e.name }
  end
  render json: res
end

#lookup_address ⇒ Object 



105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
 
# File 'app/controllers/stores_controller.rb', line 105

def lookup_address
  if store_id = params[:store_id]
    @store = Store.find(store_id)
    @addresses = Address.where(party_id: @store.consignee_party_id).order('state_code asc')
    if q = params[:q].presence || params[:term].presence
      @addresses = @addresses.where("address_text ilike '%#{q}%'")
    end
  else
    @addresses = []
  end
  res = TomSelect.format_json_results(self, @addresses, params[:page], params[:per_page]) do |e|
    { id: e.id, text: e.to_s }
  end
  render json: res
end

#new ⇒ Object 



11
12
13
 
# File 'app/controllers/stores_controller.rb', line 11

def new
  @store = Store.new(params[:store])
end

#shipped ⇒ Object 



67
68
69
70
71
 
# File 'app/controllers/stores_controller.rb', line 67

def shipped
  @deliveries = Delivery.where(id: params[:delivery_ids])
  @deliveries.each(&:shipped!)
  redirect_back_or_to root_path
end

#stock_items_without_location ⇒ Object 



121
122
123
124
125
 
# File 'app/controllers/stores_controller.rb', line 121

def stock_items_without_location
  @store = Store.find(params[:id])
  @q = @store.store_items.stock_items_without_location.joins(:item).ransack(params[:q])
  @pagy_items, @store_items = pagy(@q.result, limit: 100)
end

#update ⇒ Object 



28
29
30
31
32
33
34
35
 
# File 'app/controllers/stores_controller.rb', line 28

def update
  @store = Store.find(params[:id])
  if @store.update(params[:store])
    redirect_to_return_path_or_default store_path(@store)
  else
    render :edit, status: :unprocessable_entity
  end
end