Class: StoreItem

Inherits:
ApplicationRecord show all
Includes:
Models::Auditable
Defined in:
app/models/store_item.rb

Overview

== Schema Information

Table name: store_items
Database name: primary

id :integer not null, primary key
add_to_next_cycle_count :boolean
always_add_to_cycle_count :string
availability_end_date :date
availability_start_date :date
business_days_to_fulfill :integer default(0)
cycle_count_priority :integer default(0)
deficit :integer default(0)
handling_charge :decimal(, ) default(0.0), not null
is_discontinued :boolean default(FALSE)
last_inventory_updated_at :datetime
last_reported_stock :jsonb
location :string default("AVAILABLE"), not null
must_be_shipped_insured :boolean
permanent_qty_available :integer
qty_available :integer default(0)
qty_committed :integer default(0)
qty_on_hand :integer default(0)
quantity_limit :integer
requires_serial_number :boolean default(FALSE)
safety_stock_days :integer
safety_stock_fixed :integer
safety_stock_percentage :decimal(, )
unit_cogs :decimal(, ) default(0.0), not null
created_at :datetime
updated_at :datetime
item_id :integer not null
last_item_ledger_entry_id :integer
store_id :integer

Indexes

idx_item_id_qty_on_hand (item_id,qty_on_hand)
idx_litem_id_is_discontinued (item_id,is_discontinued)
idx_location_store_id (location,store_id)
idx_store_items_unique (item_id,store_id,location) UNIQUE
index_store_items_on_item_id_and_id (item_id,id)
index_store_items_on_last_inventory_updated_at (last_inventory_updated_at) USING brin
index_store_items_store_id (store_id)

Foreign Keys

store_items_item_id_fk (item_id => items.id) ON DELETE => cascade

Constant Summary collapse

BO_JOIN_SQL =

Bo join sql.

"(select sum(line_items.quantity) from line_items inner join orders on orders.id = line_items.resource_id and line_items.resource_type = 'Order' and orders.state = 'crm_back_order'  inner join catalog_items on catalog_items.id = line_items.catalog_item_id where catalog_items.store_item_id = store_items.id)"
POSSIBLE_LOCATIONS =

Possible locations.

%w[AVAILABLE SCRAP OBSOLETE HELD REFURB TECH RESTOCK CLAIM CLAIM_SUBMITTED SERVICEVAN MARKETING].freeze
POSSIBLE_LOCATIONS_FOR_RMAS =

Possible locations for rmas.

%w[AVAILABLE SCRAP REFURB CLAIM RESTOCK].freeze

Constants included from Models::Auditable

Models::Auditable::ALWAYS_IGNORED

Constants included from Schedulable

Schedulable::SIMPLE_FORM_OPTIONS

Instance Attribute Summary collapse

Belongs to collapse

Methods included from Models::Auditable

#creator, #updater

Has and belongs to many collapse

Has many collapse

Delegated Instance Attributes collapse

Class Method Summary collapse

Instance Method Summary collapse

Methods included from Models::Auditable

#all_skipped_columns, #audit_reference_data, #should_not_save_version, #stamp_record

Methods inherited from ApplicationRecord

ransackable_associations, ransackable_attributes, ransortable_attributes, #to_relation

Methods included from Schedulable

config

Methods included from Models::AfterCommittable

#after_commit

Methods included from Models::EventPublishable

#publish_event

Instance Attribute Details

#handling_charge ⇒ Object (readonly) 



102
 
# File 'app/models/store_item.rb', line 102

validates :store_id, :qty_on_hand, :qty_committed, :handling_charge, :location, :unit_cogs, presence: true

#location ⇒ Object (readonly) 



102
 
# File 'app/models/store_item.rb', line 102

validates :store_id, :qty_on_hand, :qty_committed, :handling_charge, :location, :unit_cogs, presence: true

#qty_committed ⇒ Object (readonly) 



102
 
# File 'app/models/store_item.rb', line 102

validates :store_id, :qty_on_hand, :qty_committed, :handling_charge, :location, :unit_cogs, presence: true

#qty_on_hand ⇒ Object (readonly) 



102
 
# File 'app/models/store_item.rb', line 102

validates :store_id, :qty_on_hand, :qty_committed, :handling_charge, :location, :unit_cogs, presence: true

#skip_check_kit_components ⇒ Object

Returns the value of attribute skip_check_kit_components.



56
57
58
 
# File 'app/models/store_item.rb', line 56

def skip_check_kit_components
  @skip_check_kit_components
end

#store_id ⇒ Object (readonly) 



102
 
# File 'app/models/store_item.rb', line 102

validates :store_id, :qty_on_hand, :qty_committed, :handling_charge, :location, :unit_cogs, presence: true

#unit_cogs ⇒ Object (readonly) 



102
 
# File 'app/models/store_item.rb', line 102

validates :store_id, :qty_on_hand, :qty_committed, :handling_charge, :location, :unit_cogs, presence: true

Class Method Details

.active ⇒ ActiveRecord::Relation<StoreItem>

A relation of StoreItems that are active. Active Record Scope

Returns:

See Also:



134
 
# File 'app/models/store_item.rb', line 134

scope :active, -> { includes(:item).where(is_discontinued: false) }

.available ⇒ ActiveRecord::Relation<StoreItem>

A relation of StoreItems that are available. Active Record Scope

Returns:

See Also:



135
 
# File 'app/models/store_item.rb', line 135

scope :available, -> { where(location: 'AVAILABLE') }

.available_first ⇒ ActiveRecord::Relation<StoreItem>

A relation of StoreItems that are available first. Active Record Scope

Returns:

See Also:



133
 
# File 'app/models/store_item.rb', line 133

scope :available_first, -> { order(Arel.sql("location <> 'AVAILABLE', store_id")) }

.backorders_only ⇒ ActiveRecord::Relation<StoreItem>

A relation of StoreItems that are backorders only. Active Record Scope

Returns:

See Also:



137
 
# File 'app/models/store_item.rb', line 137

scope :backorders_only, -> { where("#{BO_JOIN_SQL} > 0") }

.by_amazon_asins ⇒ ActiveRecord::Relation<StoreItem>

A relation of StoreItems that are by amazon asins. Active Record Scope

Returns:

See Also:



151
 
# File 'app/models/store_item.rb', line 151

scope :by_amazon_asins, ->(*asins) { available.includes(:item).where(items: { amazon_asin: [asins].flatten.uniq.compact }) }

.by_skus ⇒ ActiveRecord::Relation<StoreItem>

A relation of StoreItems that are by skus. Active Record Scope

Returns:

See Also:



149
 
# File 'app/models/store_item.rb', line 149

scope :by_skus, ->(*skus) { available.includes(:item).where(items: { sku: [skus].flatten.uniq.compact }) }

.by_upcs ⇒ ActiveRecord::Relation<StoreItem>

A relation of StoreItems that are by upcs. Active Record Scope

Returns:

See Also:



150
 
# File 'app/models/store_item.rb', line 150

scope :by_upcs, ->(*upcs) { available.includes(:item).where(items: { upc: [upcs].flatten.uniq.compact }) }

.category_sorted ⇒ ActiveRecord::Relation<StoreItem>

A relation of StoreItems that are category sorted. Active Record Scope

Returns:

See Also:



138
 
# File 'app/models/store_item.rb', line 138

scope :category_sorted, -> { joins(item: :product_category).order('product_categories.name, items.sku, store_items.store_id') }

.create_fake_fallback_packagings(logger = Rails.logger) ⇒ Object 



494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
 
# File 'app/models/store_item.rb', line 494

def self.create_fake_fallback_packagings(logger = Rails.logger)
  affected_store_items = StoreItem.packaging_smaller_than_shipping_dimensions(tolerance = 0.1) # fraction so 0.1 = within 10%
  store_item_count = affected_store_items.length

  logger.info "$$$ Affected Store Items to process: #{store_item_count}."
  store_item_counter = 0
  affected_store_items.each do |store_item|
    store_item.packagings.reject { |p| p.warehouse_package.can_contain_dimensions?(store_item.shipping_dimensions) }.each do |p|
      logger.debug('Removing packaging', packaging_id: p.id)
      p.destroy
    end
    if store_item.packagings.empty?
      warehouse_package = WarehousePackage.find_or_create_closest_package_within_tolerance(store_item.store_id, store_item.shipping_dimensions, tolerance = 0.0, "FAKE STOPGAP PKG FOR #{store_item.name}", true)
      logger.debug('Found or creating warehouse_package', warehouse_package_id: warehouse_package&.id)
      packaging = Packaging.new(number_items: 1, warehouse_package_id: warehouse_package.id, store_item_id: store_item.id)
      store_item.packagings << packaging
      logger.debug('Creating packaging', packaging_id: packaging&.id)
    end
    logger.info "Processed affected store_item: ID: #{store_item.id}: #{store_item.name}"
    store_item_counter += 1
    logger.info "*** Successfully processed #{store_item_counter} affected shipments out of #{store_item_count},  #{Time.current}"
  end
  true
end

.for_product_line_id_exact ⇒ ActiveRecord::Relation<StoreItem>

A relation of StoreItems that are for product line id exact. Active Record Scope

Returns:

See Also:



144
 
# File 'app/models/store_item.rb', line 144

scope :for_product_line_id_exact, ->(pid) { where('EXISTS(select 1 from item_product_lines ipl where ipl.item_id = items.id and ipl.product_line_id IN (?))', pid) }

.for_product_line_id_with_complimentaries ⇒ ActiveRecord::Relation<StoreItem>

A relation of StoreItems that are for product line id with complimentaries. Active Record Scope

Returns:

See Also:



143
 
# File 'app/models/store_item.rb', line 143

scope :for_product_line_id_with_complimentaries, ->(pid) { for_product_line_id_exact(ProductLine.find(pid).full_complimentary_product_line_ids) }

.in_storage_locations ⇒ ActiveRecord::Relation<StoreItem>

A relation of StoreItems that are in storage locations. Active Record Scope

Returns:

See Also:



147
 
# File 'app/models/store_item.rb', line 147

scope :in_storage_locations, ->(*slids) { where('EXISTS(select 1 from storage_locations_store_items slsi WHERE slsi.store_item_id = store_items.id AND slsi.storage_location_id IN (?))', [slids].flatten.map(&:presence).uniq.compact.map(&:to_i)) }

.item_by_product_category_id ⇒ ActiveRecord::Relation<StoreItem>

A relation of StoreItems that are item by product category id. Active Record Scope

Returns:

See Also:



141
 
# File 'app/models/store_item.rb', line 141

scope :item_by_product_category_id, ->(product_category_ids) { joins(:item).merge(Item.by_product_category_id(product_category_ids)) }

.item_by_product_line_id ⇒ ActiveRecord::Relation<StoreItem>

A relation of StoreItems that are item by product line id. Active Record Scope

Returns:

See Also:



142
 
# File 'app/models/store_item.rb', line 142

scope :item_by_product_line_id, ->(*product_line_ids) { joins(:item).merge(Item.by_product_line_id(product_line_ids)) }

.item_keywords_search ⇒ ActiveRecord::Relation<StoreItem>

A relation of StoreItems that are item keywords search. Active Record Scope

Returns:

See Also:



140
 
# File 'app/models/store_item.rb', line 140

scope :item_keywords_search, ->(keywords) { joins(:item).merge(Item.keywords_search(keywords)) }

.locations_for_select ⇒ Object 



166
167
168
 
# File 'app/models/store_item.rb', line 166

def self.locations_for_select
  POSSIBLE_LOCATIONS.map { |l| [l.humanize, l] }
end

.must_be_shipped_insured ⇒ ActiveRecord::Relation<StoreItem>

A relation of StoreItems that are must be shipped insured. Active Record Scope

Returns:

See Also:



145
 
# File 'app/models/store_item.rb', line 145

scope :must_be_shipped_insured, -> { where(must_be_shipped_insured: true) }

.not_in_catalog_id ⇒ ActiveRecord::Relation<StoreItem>

A relation of StoreItems that are not in catalog id. Active Record Scope

Returns:

See Also:



139
 
# File 'app/models/store_item.rb', line 139

scope :not_in_catalog_id, ->(catalog_id) { where.not('exists(select 1 from catalog_items ci where ci.catalog_id = ? and ci.store_item_id = store_items.id)', catalog_id) }

.packaging_smaller_than_shipping_dimensions(tolerance = 0.0) ⇒ Object

fraction so 0.1 = within 10%



359
360
361
362
363
364
365
 
# File 'app/models/store_item.rb', line 359

def self.packaging_smaller_than_shipping_dimensions(tolerance = 0.0)
  StoreItem.active.select do |store_item|
    store_item.shipping_dimensions && (store_item.packagings.empty? || store_item.packagings.any? do |p|
      p.warehouse_package.nil? || !p.warehouse_package.can_contain_dimensions?(store_item.shipping_dimensions, tolerance)
    end)
  end
end

.ransackable_scopes(_auth_object = nil) ⇒ Object 



162
163
164
 
# File 'app/models/store_item.rb', line 162

def self.ransackable_scopes(_auth_object = nil)
  %i[for_product_line_id_with_complimentaries item_keywords_search item_by_product_line_id item_by_product_category_id in_storage_locations]
end

.stock_items_without_location ⇒ ActiveRecord::Relation<StoreItem>

A relation of StoreItems that are stock items without location. Active Record Scope

Returns:

See Also:



146
 
# File 'app/models/store_item.rb', line 146

scope :stock_items_without_location, -> { where(StoreItem[:qty_on_hand].gteq(1)).where(is_discontinued: false).where('NOT exists(select 1 from storage_locations_store_items slsi where slsi.store_item_id = store_items.id)') }

.warmlyyours_warehouses ⇒ ActiveRecord::Relation<StoreItem>

A relation of StoreItems that are warmlyyours warehouses. Active Record Scope

Returns:

See Also:



148
 
# File 'app/models/store_item.rb', line 148

scope :warmlyyours_warehouses, -> { joins(:store).merge(Store.warmlyyours_warehouses) }

.with_back_order_quantities ⇒ ActiveRecord::Relation<StoreItem>

A relation of StoreItems that are with back order quantities. Active Record Scope

Returns:

See Also:



136
 
# File 'app/models/store_item.rb', line 136

scope :with_back_order_quantities, -> { select("#{BO_JOIN_SQL} as qty_bo, *") }

Instance Method Details

#associated_catalog_items ⇒ ActiveRecord::Relation<CatalogItem>

Returns:

See Also:



80
 
# File 'app/models/store_item.rb', line 80

has_and_belongs_to_many :associated_catalog_items, class_name: 'CatalogItem', inverse_of: :store_items

#available_location? ⇒ Boolean

Returns:

  • (Boolean) 


190
191
192
 
# File 'app/models/store_item.rb', line 190

def available_location?
  location == 'AVAILABLE'
end

#catalog_items ⇒ ActiveRecord::Relation<CatalogItem>

Returns:

See Also:



83
 
# File 'app/models/store_item.rb', line 83

has_many :catalog_items, dependent: :destroy, inverse_of: :store_item

#check_ok_to_destroy ⇒ Object 



352
353
354
355
356
 
# File 'app/models/store_item.rb', line 352

def check_ok_to_destroy
  errors.add(:base, 'Cannot destroy because there are dependent catalog and/or line_items, please discontinue instead') if usage > 0
  errors.add(:base, "Cannot destroy because #{sku} is linked to one or more active kits, please discontinue instead") if is_part_of_an_active_kit?
  errors.none?
end

#deep_dup ⇒ Object 



60
61
62
63
64
65
66
67
68
69
70
71
 
# File 'app/models/store_item.rb', line 60

def deep_dup
  deep_clone(
    include: %i[packagings catalog_items],
    except: :last_item_ledger_entry_id
  ) do |_original, copy|
    if copy.is_a?(StoreItem)
      copy.qty_on_hand = 0
      copy.qty_committed = 0
      copy.unit_cogs = 0
    end
  end
end

#get_kit_store_items ⇒ Object 



375
376
377
 
# File 'app/models/store_item.rb', line 375

def get_kit_store_items
  store.store_items.available.where(item_id: item.get_kit_item_ids)
end

#get_self_and_kit_store_items ⇒ Object 



379
380
381
 
# File 'app/models/store_item.rb', line 379

def get_self_and_kit_store_items
  store.store_items.available.where(item_id: item.get_self_and_kit_item_ids)
end

#has_non_discontinued_catalog_items? ⇒ Boolean

Returns:

  • (Boolean) 


397
398
399
 
# File 'app/models/store_item.rb', line 397

def has_non_discontinued_catalog_items?
  catalog_items.where.not(state: %w[pending_discontinue discontinued]).exists?
end

#inventory_commits ⇒ ActiveRecord::Relation<InventoryCommit>

Returns:

See Also:



88
 
# File 'app/models/store_item.rb', line 88

has_many :inventory_commits

#is_available_to_public ⇒ Object

Alias for Item#is_available_to_public

Returns:

  • (Object) —

    Item#is_available_to_public

See Also:



105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
 
# File 'app/models/store_item.rb', line 105

delegate :sku,
:sku_and_name,
:public_name,
:primary_product_line,
:primary_product_line_id,
:product_category,
:product_lines,
:is_available_to_public,
:is_circuit_check?,
:is_underlayment?,
:is_snow_melt_plaque?,
:is_roughin_kit?,
:is_cable_fit_guide?,
:is_cable_accessory?,
:is_membrane?,
:is_heating_element?,
:is_publication?,
:is_control?,
:is_service?,
:primary_image,
:seo_title,
:seo_keywords,
:seo_description,
:shipping_dimensions,
:is_kit?,
:oversize?,
to: :item

#is_cable_accessory? ⇒ Object

Alias for Item#is_cable_accessory?

Returns:

  • (Object) —

    Item#is_cable_accessory?

See Also:



105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
 
# File 'app/models/store_item.rb', line 105

delegate :sku,
:sku_and_name,
:public_name,
:primary_product_line,
:primary_product_line_id,
:product_category,
:product_lines,
:is_available_to_public,
:is_circuit_check?,
:is_underlayment?,
:is_snow_melt_plaque?,
:is_roughin_kit?,
:is_cable_fit_guide?,
:is_cable_accessory?,
:is_membrane?,
:is_heating_element?,
:is_publication?,
:is_control?,
:is_service?,
:primary_image,
:seo_title,
:seo_keywords,
:seo_description,
:shipping_dimensions,
:is_kit?,
:oversize?,
to: :item

#is_cable_fit_guide? ⇒ Object

Alias for Item#is_cable_fit_guide?

Returns:

  • (Object) —

    Item#is_cable_fit_guide?

See Also:



105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
 
# File 'app/models/store_item.rb', line 105

delegate :sku,
:sku_and_name,
:public_name,
:primary_product_line,
:primary_product_line_id,
:product_category,
:product_lines,
:is_available_to_public,
:is_circuit_check?,
:is_underlayment?,
:is_snow_melt_plaque?,
:is_roughin_kit?,
:is_cable_fit_guide?,
:is_cable_accessory?,
:is_membrane?,
:is_heating_element?,
:is_publication?,
:is_control?,
:is_service?,
:primary_image,
:seo_title,
:seo_keywords,
:seo_description,
:shipping_dimensions,
:is_kit?,
:oversize?,
to: :item

#is_circuit_check? ⇒ Object

Alias for Item#is_circuit_check?

Returns:

  • (Object) —

    Item#is_circuit_check?

See Also:



105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
 
# File 'app/models/store_item.rb', line 105

delegate :sku,
:sku_and_name,
:public_name,
:primary_product_line,
:primary_product_line_id,
:product_category,
:product_lines,
:is_available_to_public,
:is_circuit_check?,
:is_underlayment?,
:is_snow_melt_plaque?,
:is_roughin_kit?,
:is_cable_fit_guide?,
:is_cable_accessory?,
:is_membrane?,
:is_heating_element?,
:is_publication?,
:is_control?,
:is_service?,
:primary_image,
:seo_title,
:seo_keywords,
:seo_description,
:shipping_dimensions,
:is_kit?,
:oversize?,
to: :item

#is_control? ⇒ Object

Alias for Item#is_control?

Returns:

  • (Object) —

    Item#is_control?

See Also:



105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
 
# File 'app/models/store_item.rb', line 105

delegate :sku,
:sku_and_name,
:public_name,
:primary_product_line,
:primary_product_line_id,
:product_category,
:product_lines,
:is_available_to_public,
:is_circuit_check?,
:is_underlayment?,
:is_snow_melt_plaque?,
:is_roughin_kit?,
:is_cable_fit_guide?,
:is_cable_accessory?,
:is_membrane?,
:is_heating_element?,
:is_publication?,
:is_control?,
:is_service?,
:primary_image,
:seo_title,
:seo_keywords,
:seo_description,
:shipping_dimensions,
:is_kit?,
:oversize?,
to: :item

#is_heating_element? ⇒ Object

Alias for Item#is_heating_element?

Returns:

  • (Object) —

    Item#is_heating_element?

See Also:



105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
 
# File 'app/models/store_item.rb', line 105

delegate :sku,
:sku_and_name,
:public_name,
:primary_product_line,
:primary_product_line_id,
:product_category,
:product_lines,
:is_available_to_public,
:is_circuit_check?,
:is_underlayment?,
:is_snow_melt_plaque?,
:is_roughin_kit?,
:is_cable_fit_guide?,
:is_cable_accessory?,
:is_membrane?,
:is_heating_element?,
:is_publication?,
:is_control?,
:is_service?,
:primary_image,
:seo_title,
:seo_keywords,
:seo_description,
:shipping_dimensions,
:is_kit?,
:oversize?,
to: :item

#is_kit? ⇒ Object

Alias for Item#is_kit?

Returns:

  • (Object) —

    Item#is_kit?

See Also:



105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
 
# File 'app/models/store_item.rb', line 105

delegate :sku,
:sku_and_name,
:public_name,
:primary_product_line,
:primary_product_line_id,
:product_category,
:product_lines,
:is_available_to_public,
:is_circuit_check?,
:is_underlayment?,
:is_snow_melt_plaque?,
:is_roughin_kit?,
:is_cable_fit_guide?,
:is_cable_accessory?,
:is_membrane?,
:is_heating_element?,
:is_publication?,
:is_control?,
:is_service?,
:primary_image,
:seo_title,
:seo_keywords,
:seo_description,
:shipping_dimensions,
:is_kit?,
:oversize?,
to: :item

#is_membrane? ⇒ Object

Alias for Item#is_membrane?

Returns:

  • (Object) —

    Item#is_membrane?

See Also:



105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
 
# File 'app/models/store_item.rb', line 105

delegate :sku,
:sku_and_name,
:public_name,
:primary_product_line,
:primary_product_line_id,
:product_category,
:product_lines,
:is_available_to_public,
:is_circuit_check?,
:is_underlayment?,
:is_snow_melt_plaque?,
:is_roughin_kit?,
:is_cable_fit_guide?,
:is_cable_accessory?,
:is_membrane?,
:is_heating_element?,
:is_publication?,
:is_control?,
:is_service?,
:primary_image,
:seo_title,
:seo_keywords,
:seo_description,
:shipping_dimensions,
:is_kit?,
:oversize?,
to: :item

#is_publication? ⇒ Object

Alias for Item#is_publication?

Returns:

  • (Object) —

    Item#is_publication?

See Also:



105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
 
# File 'app/models/store_item.rb', line 105

delegate :sku,
:sku_and_name,
:public_name,
:primary_product_line,
:primary_product_line_id,
:product_category,
:product_lines,
:is_available_to_public,
:is_circuit_check?,
:is_underlayment?,
:is_snow_melt_plaque?,
:is_roughin_kit?,
:is_cable_fit_guide?,
:is_cable_accessory?,
:is_membrane?,
:is_heating_element?,
:is_publication?,
:is_control?,
:is_service?,
:primary_image,
:seo_title,
:seo_keywords,
:seo_description,
:shipping_dimensions,
:is_kit?,
:oversize?,
to: :item

#is_roughin_kit? ⇒ Object

Alias for Item#is_roughin_kit?

Returns:

  • (Object) —

    Item#is_roughin_kit?

See Also:



105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
 
# File 'app/models/store_item.rb', line 105

delegate :sku,
:sku_and_name,
:public_name,
:primary_product_line,
:primary_product_line_id,
:product_category,
:product_lines,
:is_available_to_public,
:is_circuit_check?,
:is_underlayment?,
:is_snow_melt_plaque?,
:is_roughin_kit?,
:is_cable_fit_guide?,
:is_cable_accessory?,
:is_membrane?,
:is_heating_element?,
:is_publication?,
:is_control?,
:is_service?,
:primary_image,
:seo_title,
:seo_keywords,
:seo_description,
:shipping_dimensions,
:is_kit?,
:oversize?,
to: :item

#is_service? ⇒ Object

Alias for Item#is_service?

Returns:

  • (Object) —

    Item#is_service?

See Also:



105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
 
# File 'app/models/store_item.rb', line 105

delegate :sku,
:sku_and_name,
:public_name,
:primary_product_line,
:primary_product_line_id,
:product_category,
:product_lines,
:is_available_to_public,
:is_circuit_check?,
:is_underlayment?,
:is_snow_melt_plaque?,
:is_roughin_kit?,
:is_cable_fit_guide?,
:is_cable_accessory?,
:is_membrane?,
:is_heating_element?,
:is_publication?,
:is_control?,
:is_service?,
:primary_image,
:seo_title,
:seo_keywords,
:seo_description,
:shipping_dimensions,
:is_kit?,
:oversize?,
to: :item

#is_snow_melt_plaque? ⇒ Object

Alias for Item#is_snow_melt_plaque?

Returns:

  • (Object) —

    Item#is_snow_melt_plaque?

See Also:



105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
 
# File 'app/models/store_item.rb', line 105

delegate :sku,
:sku_and_name,
:public_name,
:primary_product_line,
:primary_product_line_id,
:product_category,
:product_lines,
:is_available_to_public,
:is_circuit_check?,
:is_underlayment?,
:is_snow_melt_plaque?,
:is_roughin_kit?,
:is_cable_fit_guide?,
:is_cable_accessory?,
:is_membrane?,
:is_heating_element?,
:is_publication?,
:is_control?,
:is_service?,
:primary_image,
:seo_title,
:seo_keywords,
:seo_description,
:shipping_dimensions,
:is_kit?,
:oversize?,
to: :item

#is_underlayment? ⇒ Object

Alias for Item#is_underlayment?

Returns:

  • (Object) —

    Item#is_underlayment?

See Also:



105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
 
# File 'app/models/store_item.rb', line 105

delegate :sku,
:sku_and_name,
:public_name,
:primary_product_line,
:primary_product_line_id,
:product_category,
:product_lines,
:is_available_to_public,
:is_circuit_check?,
:is_underlayment?,
:is_snow_melt_plaque?,
:is_roughin_kit?,
:is_cable_fit_guide?,
:is_cable_accessory?,
:is_membrane?,
:is_heating_element?,
:is_publication?,
:is_control?,
:is_service?,
:primary_image,
:seo_title,
:seo_keywords,
:seo_description,
:shipping_dimensions,
:is_kit?,
:oversize?,
to: :item

#item ⇒ Item

Returns:

See Also:



77
 
# File 'app/models/store_item.rb', line 77

belongs_to :item, inverse_of: :store_items, optional: true

#kit_component_inventory_commits ⇒ ActiveRecord::Relation<InventoryCommit>

Returns:

See Also:



89
 
# File 'app/models/store_item.rb', line 89

has_many :kit_component_inventory_commits, class_name: 'InventoryCommit', foreign_key: 'kit_store_item_id'

#last_cycle_count ⇒ Object 



194
195
196
 
# File 'app/models/store_item.rb', line 194

def last_cycle_count
  CycleCountItem.joins(:cycle_count).where(cycle_counts: { store_id: store_id }, item_id: item_id, location: location, state: 'processed').order(updated_at: :desc).first
end

#last_item_ledger_entry ⇒ ItemLedgerEntry

Returns:

See Also:



78
 
# File 'app/models/store_item.rb', line 78

belongs_to :last_item_ledger_entry, class_name: 'ItemLedgerEntry', optional: true

#line_items ⇒ ActiveRecord::Relation<LineItem>

Returns:

See Also:



84
 
# File 'app/models/store_item.rb', line 84

has_many :line_items, through: :catalog_items

#move_location(new_location, quantity: nil, gl_date: nil, serial_number_id: nil) ⇒ Object 



383
384
385
386
387
388
389
390
391
392
393
394
395
 
# File 'app/models/store_item.rb', line 383

def move_location(new_location, quantity: nil, gl_date: nil, serial_number_id: nil)
  gl_date ||= Date.current
  quantity ||= qty_on_hand
  line_items = {
    0 => {
      store_item_id: id,
      qty: quantity,
      serial_number_id: serial_number_id,
      new_location: new_location
    }
  }
  ItemLedgerEntry.location_transfer(store, line_items, gl_date, nil)
end

#name ⇒ Object 



371
372
373
 
# File 'app/models/store_item.rb', line 371

def name
  "#{item.sku} / Store Item #{id}"
end

#next_available ⇒ Object 



269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
 
# File 'app/models/store_item.rb', line 269

def next_available
  logger.tagged("Item #{item.sku} -> next_available") do
    if item.is_kit?
      logger.debug 'Kit detected'
      # Get all order data
      buildable_qty = []
      buildable_date = []
      # We only analyze items with no availability
      get_kit_store_items.select { |si| si.qty_available <= 0 }.each do |ksi|
        logger.debug "Looking at next availability for #{ksi.item.sku}, store_item_id: #{ksi.id}"
        # Focus only on those components with no quantities
        if (ksi_next_available = ksi.next_available)
          buildable_qty << ksi_next_available.next_available_qty
          buildable_date << ksi_next_available.next_available_date
        end
        logger.debug "Next availability returned #{ksi_next_available.inspect}"
      end
      # Our most conservative approach will be the smallest quantity buildable at the latest date
      next_avail_qty = buildable_qty.min
      next_avail_date = buildable_date.compact.max
      return nil unless next_avail_qty && next_avail_date

      return OpenStruct.new(next_available_qty: buildable_qty.min,
                            next_available_date: buildable_date.compact.max).freeze

    elsif (earliest_order_data = safe_on_order_first)
      logger.debug 'Non kit with quantities on order'
      return OpenStruct.new(next_available_qty: earliest_order_data[:total_open],
                            next_available_date: earliest_order_data[:promised_delivery_date]).freeze
    else
      logger.debug 'Non kit, nothing on order'
      return nil
    end
  end
end

#next_available_with_depth_limit(max_depth: 10, current_depth: 0) ⇒ Object

Depth-limited version to prevent infinite recursion



306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
 
# File 'app/models/store_item.rb', line 306

def next_available_with_depth_limit(max_depth: 10, current_depth: 0)
  # Prevent infinite recursion
  if current_depth >= max_depth
    logger.warn "Maximum depth limit (#{max_depth}) reached for store item #{id} (item: #{item&.sku}). Possible circular reference in kit structure."
    return nil
  end

  logger.tagged("Item #{item.sku} -> next_available_with_depth_limit (depth: #{current_depth})") do
    if item.is_kit?
      logger.debug 'Kit detected'
      # Get all order data
      buildable_qty = []
      buildable_date = []
      # We only analyze items with no availability
      get_kit_store_items.select { |si| si.qty_available <= 0 }.each do |ksi|
        logger.debug "Looking at next availability for #{ksi.item.sku}, store_item_id: #{ksi.id}"
        # Focus only on those components with no quantities, using depth-limited version
        if (ksi_next_available = ksi.next_available_with_depth_limit(max_depth: max_depth, current_depth: current_depth + 1))
          buildable_qty << ksi_next_available.next_available_qty
          buildable_date << ksi_next_available.next_available_date
        end
        logger.debug "Next availability returned #{ksi_next_available.inspect}"
      end
      # Our most conservative approach will be the smallest quantity buildable at the latest date
      next_avail_qty = buildable_qty.min
      next_avail_date = buildable_date.compact.max
      return nil unless next_avail_qty && next_avail_date

      return OpenStruct.new(next_available_qty: buildable_qty.min,
                            next_available_date: buildable_date.compact.max).freeze

    elsif (earliest_order_data = safe_on_order_first)
      logger.debug 'Non kit with quantities on order'
      return OpenStruct.new(next_available_qty: earliest_order_data[:total_open],
                            next_available_date: earliest_order_data[:promised_delivery_date]).freeze
    else
      logger.debug 'Non kit, nothing on order'
      return nil
    end
  end
end

#ok_to_destroy? ⇒ Boolean

Returns:

  • (Boolean) 


234
235
236
 
# File 'app/models/store_item.rb', line 234

def ok_to_destroy?
  (usage == 0) && !is_part_of_an_active_kit?
end

#on_hand_and_committed ⇒ Object 



367
368
369
 
# File 'app/models/store_item.rb', line 367

def on_hand_and_committed
  "#{qty_on_hand} (#{qty_committed})"
end

#on_order ⇒ Object 



265
266
267
 
# File 'app/models/store_item.rb', line 265

def on_order
  Inventory::ItemOnOrder.new.process(store_id: store_id, item_id: item_id).on_order
end

#oversize? ⇒ Object

Alias for Item#oversize?

Returns:

  • (Object) —

    Item#oversize?

See Also:



105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
 
# File 'app/models/store_item.rb', line 105

delegate :sku,
:sku_and_name,
:public_name,
:primary_product_line,
:primary_product_line_id,
:product_category,
:product_lines,
:is_available_to_public,
:is_circuit_check?,
:is_underlayment?,
:is_snow_melt_plaque?,
:is_roughin_kit?,
:is_cable_fit_guide?,
:is_cable_accessory?,
:is_membrane?,
:is_heating_element?,
:is_publication?,
:is_control?,
:is_service?,
:primary_image,
:seo_title,
:seo_keywords,
:seo_description,
:shipping_dimensions,
:is_kit?,
:oversize?,
to: :item

#packages_select_options ⇒ Object 



226
227
228
229
230
231
232
 
# File 'app/models/store_item.rb', line 226

def packages_select_options
  WarehousePackage
    .active
    .by_store_id(store_id)
    .select { |wp| wp.can_contain_dimensions?(shipping_dimensions, 0.1) }
    .sort_by { |p| [p.length, p.width, p.height, p.description] }.map { |wp| [wp.description, wp.id] }
end

#packagings ⇒ ActiveRecord::Relation<Packaging>

Returns:

See Also:



86
 
# File 'app/models/store_item.rb', line 86

has_many :packagings, -> { order('packagings.number_items ASC') }, dependent: :destroy, inverse_of: :store_item

#perform_edi_actions ⇒ Object 



401
402
403
404
 
# File 'app/models/store_item.rb', line 401

def perform_edi_actions
  # Reserved for future EDI actions when items are discontinued
  nil unless saved_change_to_is_discontinued? && is_discontinued?
end

#primary_image ⇒ Object

Alias for Item#primary_image

Returns:

  • (Object) —

    Item#primary_image

See Also:



105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
 
# File 'app/models/store_item.rb', line 105

delegate :sku,
:sku_and_name,
:public_name,
:primary_product_line,
:primary_product_line_id,
:product_category,
:product_lines,
:is_available_to_public,
:is_circuit_check?,
:is_underlayment?,
:is_snow_melt_plaque?,
:is_roughin_kit?,
:is_cable_fit_guide?,
:is_cable_accessory?,
:is_membrane?,
:is_heating_element?,
:is_publication?,
:is_control?,
:is_service?,
:primary_image,
:seo_title,
:seo_keywords,
:seo_description,
:shipping_dimensions,
:is_kit?,
:oversize?,
to: :item

#primary_product_line ⇒ Object

Alias for Item#primary_product_line

Returns:

  • (Object) —

    Item#primary_product_line

See Also:



105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
 
# File 'app/models/store_item.rb', line 105

delegate :sku,
:sku_and_name,
:public_name,
:primary_product_line,
:primary_product_line_id,
:product_category,
:product_lines,
:is_available_to_public,
:is_circuit_check?,
:is_underlayment?,
:is_snow_melt_plaque?,
:is_roughin_kit?,
:is_cable_fit_guide?,
:is_cable_accessory?,
:is_membrane?,
:is_heating_element?,
:is_publication?,
:is_control?,
:is_service?,
:primary_image,
:seo_title,
:seo_keywords,
:seo_description,
:shipping_dimensions,
:is_kit?,
:oversize?,
to: :item

#primary_product_line_id ⇒ Object

Alias for Item#primary_product_line_id

Returns:

  • (Object) —

    Item#primary_product_line_id

See Also:



105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
 
# File 'app/models/store_item.rb', line 105

delegate :sku,
:sku_and_name,
:public_name,
:primary_product_line,
:primary_product_line_id,
:product_category,
:product_lines,
:is_available_to_public,
:is_circuit_check?,
:is_underlayment?,
:is_snow_melt_plaque?,
:is_roughin_kit?,
:is_cable_fit_guide?,
:is_cable_accessory?,
:is_membrane?,
:is_heating_element?,
:is_publication?,
:is_control?,
:is_service?,
:primary_image,
:seo_title,
:seo_keywords,
:seo_description,
:shipping_dimensions,
:is_kit?,
:oversize?,
to: :item

#product_category ⇒ Object

Alias for Item#product_category

Returns:

  • (Object) —

    Item#product_category

See Also:



105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
 
# File 'app/models/store_item.rb', line 105

delegate :sku,
:sku_and_name,
:public_name,
:primary_product_line,
:primary_product_line_id,
:product_category,
:product_lines,
:is_available_to_public,
:is_circuit_check?,
:is_underlayment?,
:is_snow_melt_plaque?,
:is_roughin_kit?,
:is_cable_fit_guide?,
:is_cable_accessory?,
:is_membrane?,
:is_heating_element?,
:is_publication?,
:is_control?,
:is_service?,
:primary_image,
:seo_title,
:seo_keywords,
:seo_description,
:shipping_dimensions,
:is_kit?,
:oversize?,
to: :item

#product_lines ⇒ Object

Alias for Item#product_lines

Returns:

  • (Object) —

    Item#product_lines

See Also:



105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
 
# File 'app/models/store_item.rb', line 105

delegate :sku,
:sku_and_name,
:public_name,
:primary_product_line,
:primary_product_line_id,
:product_category,
:product_lines,
:is_available_to_public,
:is_circuit_check?,
:is_underlayment?,
:is_snow_melt_plaque?,
:is_roughin_kit?,
:is_cable_fit_guide?,
:is_cable_accessory?,
:is_membrane?,
:is_heating_element?,
:is_publication?,
:is_control?,
:is_service?,
:primary_image,
:seo_title,
:seo_keywords,
:seo_description,
:shipping_dimensions,
:is_kit?,
:oversize?,
to: :item

#public_name ⇒ Object

Alias for Item#public_name

Returns:

  • (Object) —

    Item#public_name

See Also:



105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
 
# File 'app/models/store_item.rb', line 105

delegate :sku,
:sku_and_name,
:public_name,
:primary_product_line,
:primary_product_line_id,
:product_category,
:product_lines,
:is_available_to_public,
:is_circuit_check?,
:is_underlayment?,
:is_snow_melt_plaque?,
:is_roughin_kit?,
:is_cable_fit_guide?,
:is_cable_accessory?,
:is_membrane?,
:is_heating_element?,
:is_publication?,
:is_control?,
:is_service?,
:primary_image,
:seo_title,
:seo_keywords,
:seo_description,
:shipping_dimensions,
:is_kit?,
:oversize?,
to: :item

#qty_available ⇒ Object 



212
213
214
215
216
217
218
219
220
221
222
223
224
 
# File 'app/models/store_item.rb', line 212

def qty_available
  # Mirror the DB trigger store_items_update_qty_available, which keeps the
  # persisted column in sync on every insert/update as:
  #   qty_available = COALESCE(permanent_qty_available, GREATEST(qty_on_hand - qty_committed, 0))
  # We recompute on the fly so the value is correct on an unsaved/dirty record,
  # before the trigger has run on save.
  if qty_on_hand_changed? || qty_committed_changed? || permanent_qty_available_changed?
    permanent_qty_available || [(qty_on_hand || 0) - (qty_committed || 0), 0].max
  else
    # Persisted, unmodified record: trust the trigger-maintained column.
    permanent_qty_available || super
  end
end

#qty_available_outside_order(order) ⇒ Object 



238
239
240
241
242
243
244
245
 
# File 'app/models/store_item.rb', line 238

def qty_available_outside_order(order)
  committed_from_order = inventory_commits.joins(:line_item).where(line_items: { resource_type: 'Order', resource_id: order.id }).sum(:quantity)
  # use the calculated qty_committed here as it takes into account any adjusted committed count where kits are involved
  # then subtract whatever is already committed on this order
  qt_avail = permanent_qty_available # This takes preference over any other reported qty
  qt_avail ||= qty_on_hand
  (qt_avail - qty_committed) + committed_from_order
end

#qty_backordered ⇒ Object 



255
256
257
258
259
260
261
262
263
 
# File 'app/models/store_item.rb', line 255

def qty_backordered
  @qty_backordered ||= ((begin
    qty_bo
  rescue StandardError
    nil
  end) || StoreItem.joins('INNER JOIN catalog_items ON catalog_items.store_item_id = store_items.id INNER JOIN line_items ON line_items.catalog_item_id = catalog_items.id INNER JOIN orders ON line_items.resource_id = orders.id').where(
    "store_items.id = ? and line_items.resource_type = 'Order' and orders.state = 'crm_back_order'", id
  ).sum('line_items.quantity')).to_i
end

#qty_on_hand_in_location(location = 'AVAILABLE') ⇒ Object 



202
203
204
 
# File 'app/models/store_item.rb', line 202

def qty_on_hand_in_location(location = 'AVAILABLE')
  item.store_items.where(location: location, store_id: store_id).pluck(:qty_on_hand)&.first
end

#qty_on_hand_with_held ⇒ Object 



206
207
208
209
210
 
# File 'app/models/store_item.rb', line 206

def qty_on_hand_with_held
  r = qty_on_hand || 0
  r += qty_on_hand_in_location('HELD') || 0 if available_location?
  r
end

#qty_on_shelf ⇒ Object 



247
248
249
 
# File 'app/models/store_item.rb', line 247

def qty_on_shelf
  qty_on_hand_with_held - qty_shipping
end

#qty_shipping ⇒ Object 



251
252
253
 
# File 'app/models/store_item.rb', line 251

def qty_shipping
  line_items.joins(:delivery).where(deliveries: { state: Delivery::SHIPPING_STATES }).sum(:quantity)
end

#safety_stock_description ⇒ Object 



182
183
184
185
186
187
188
 
# File 'app/models/store_item.rb', line 182

def safety_stock_description
  return safety_stock_fixed.to_s if safety_stock_fixed
  return "#{safety_stock_days} days" if safety_stock_days
  return "#{safety_stock_percentage * 100}%" if safety_stock_percentage

  '50%'
end

#selection_name ⇒ Object 



178
179
180
 
# File 'app/models/store_item.rb', line 178

def selection_name
  "#{item.sku} (#{location} / #{store.short_name}) - #{item.name}"
end

#seo_description ⇒ Object

Alias for Item#seo_description

Returns:

  • (Object) —

    Item#seo_description

See Also:



105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
 
# File 'app/models/store_item.rb', line 105

delegate :sku,
:sku_and_name,
:public_name,
:primary_product_line,
:primary_product_line_id,
:product_category,
:product_lines,
:is_available_to_public,
:is_circuit_check?,
:is_underlayment?,
:is_snow_melt_plaque?,
:is_roughin_kit?,
:is_cable_fit_guide?,
:is_cable_accessory?,
:is_membrane?,
:is_heating_element?,
:is_publication?,
:is_control?,
:is_service?,
:primary_image,
:seo_title,
:seo_keywords,
:seo_description,
:shipping_dimensions,
:is_kit?,
:oversize?,
to: :item

#seo_keywords ⇒ Object

Alias for Item#seo_keywords

Returns:

  • (Object) —

    Item#seo_keywords

See Also:



105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
 
# File 'app/models/store_item.rb', line 105

delegate :sku,
:sku_and_name,
:public_name,
:primary_product_line,
:primary_product_line_id,
:product_category,
:product_lines,
:is_available_to_public,
:is_circuit_check?,
:is_underlayment?,
:is_snow_melt_plaque?,
:is_roughin_kit?,
:is_cable_fit_guide?,
:is_cable_accessory?,
:is_membrane?,
:is_heating_element?,
:is_publication?,
:is_control?,
:is_service?,
:primary_image,
:seo_title,
:seo_keywords,
:seo_description,
:shipping_dimensions,
:is_kit?,
:oversize?,
to: :item

#seo_title ⇒ Object

Alias for Item#seo_title

Returns:

  • (Object) —

    Item#seo_title

See Also:



105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
 
# File 'app/models/store_item.rb', line 105

delegate :sku,
:sku_and_name,
:public_name,
:primary_product_line,
:primary_product_line_id,
:product_category,
:product_lines,
:is_available_to_public,
:is_circuit_check?,
:is_underlayment?,
:is_snow_melt_plaque?,
:is_roughin_kit?,
:is_cable_fit_guide?,
:is_cable_accessory?,
:is_membrane?,
:is_heating_element?,
:is_publication?,
:is_control?,
:is_service?,
:primary_image,
:seo_title,
:seo_keywords,
:seo_description,
:shipping_dimensions,
:is_kit?,
:oversize?,
to: :item

#serial_numbers ⇒ ActiveRecord::Relation<SerialNumber>

Returns:

See Also:



85
 
# File 'app/models/store_item.rb', line 85

has_many :serial_numbers, dependent: :destroy

#shipping_dimensions ⇒ Object

Alias for Item#shipping_dimensions

Returns:

  • (Object) —

    Item#shipping_dimensions

See Also:



105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
 
# File 'app/models/store_item.rb', line 105

delegate :sku,
:sku_and_name,
:public_name,
:primary_product_line,
:primary_product_line_id,
:product_category,
:product_lines,
:is_available_to_public,
:is_circuit_check?,
:is_underlayment?,
:is_snow_melt_plaque?,
:is_roughin_kit?,
:is_cable_fit_guide?,
:is_cable_accessory?,
:is_membrane?,
:is_heating_element?,
:is_publication?,
:is_control?,
:is_service?,
:primary_image,
:seo_title,
:seo_keywords,
:seo_description,
:shipping_dimensions,
:is_kit?,
:oversize?,
to: :item

#shipping_weight ⇒ Object 



348
349
350
 
# File 'app/models/store_item.rb', line 348

def shipping_weight
  item&.base_weight || 0.0
end

#sku ⇒ Object

Alias for Item#sku

Returns:

  • (Object) —

    Item#sku

See Also:



105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
 
# File 'app/models/store_item.rb', line 105

delegate :sku,
:sku_and_name,
:public_name,
:primary_product_line,
:primary_product_line_id,
:product_category,
:product_lines,
:is_available_to_public,
:is_circuit_check?,
:is_underlayment?,
:is_snow_melt_plaque?,
:is_roughin_kit?,
:is_cable_fit_guide?,
:is_cable_accessory?,
:is_membrane?,
:is_heating_element?,
:is_publication?,
:is_control?,
:is_service?,
:primary_image,
:seo_title,
:seo_keywords,
:seo_description,
:shipping_dimensions,
:is_kit?,
:oversize?,
to: :item

#sku_and_name ⇒ Object

Alias for Item#sku_and_name

Returns:

  • (Object) —

    Item#sku_and_name

See Also:



105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
 
# File 'app/models/store_item.rb', line 105

delegate :sku,
:sku_and_name,
:public_name,
:primary_product_line,
:primary_product_line_id,
:product_category,
:product_lines,
:is_available_to_public,
:is_circuit_check?,
:is_underlayment?,
:is_snow_melt_plaque?,
:is_roughin_kit?,
:is_cable_fit_guide?,
:is_cable_accessory?,
:is_membrane?,
:is_heating_element?,
:is_publication?,
:is_control?,
:is_service?,
:primary_image,
:seo_title,
:seo_keywords,
:seo_description,
:shipping_dimensions,
:is_kit?,
:oversize?,
to: :item

#storage_locations ⇒ ActiveRecord::Relation<StorageLocation>

Returns:

See Also:



81
 
# File 'app/models/store_item.rb', line 81

has_and_belongs_to_many :storage_locations

#store ⇒ Store

Returns:

See Also:



76
 
# File 'app/models/store_item.rb', line 76

belongs_to :store, optional: true

#store_item_audits ⇒ ActiveRecord::Relation<StoreItemAudit>

Returns:

See Also:



87
 
# File 'app/models/store_item.rb', line 87

has_many :store_item_audits, dependent: :destroy

#to_s ⇒ Object 



174
175
176
 
# File 'app/models/store_item.rb', line 174

def to_s
  "#{item.sku} - #{store.name} - #{location} [#{id}]"
end

#unlimited_inventory? ⇒ Boolean

Returns:

  • (Boolean) 


170
171
172
 
# File 'app/models/store_item.rb', line 170

def unlimited_inventory?
  permanent_qty_available && permanent_qty_available > 0
end

#update_availability ⇒ Object 



406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
 
# File 'app/models/store_item.rb', line 406

def update_availability
  sync_status_with_availability_date
  availability_description = "Available from #{availability_start_date || 'anytime'} until #{availability_end_date || 'anytime'}"
  messages = [availability_description]
  if is_discontinued_changed?
    if is_discontinued
      # attempts to discontinue all catalog items
      catalog_items.each(&:discontinue)
    end
    result = save ? :updated : :error
    messages += errors.full_messages
  else
    result = :unchanged
  end

  available = !is_discontinued
  messages << 'Publication has no redirection path' if !available && item.redirection_path.blank? && is_publication?
  {
    result: result,
    available: available,
    messages: messages
  }
end

#usage ⇒ Object 



198
199
200
 
# File 'app/models/store_item.rb', line 198

def usage
  line_items.count
end