Class: ItemSearch

Inherits:
Search show all
Defined in:
app/models/item_search.rb

Overview

== Schema Information

Table name: searches
Database name: primary

id :integer not null, primary key
name :string(255)
persist :boolean default(FALSE)
pinned :boolean default(FALSE), not null
query_params :jsonb
result_set_size :integer default(0)
selected_columns :string is an Array
set_limit :integer default(25)
sort_column :string(255)
sort_columns :string default([]), not null, is an Array
sort_direction :string(255) default("ASC")
type :string(255) not null
created_at :datetime
updated_at :datetime
employee_id :integer

Indexes

employee_id_pinned (employee_id,pinned)
employee_id_type (employee_id,type)

Constant Summary

Constants inherited from Search

Search::DISTANCE_SEARCH_KEYS

Constants included from Schedulable

Schedulable::SIMPLE_FORM_OPTIONS

Instance Attribute Summary

Attributes inherited from Search

#composite_columns, #pagy_count, #pagy_limit, #pagy_page, #sql_select_columns

Class Method Summary collapse

Instance Method Summary collapse

Methods inherited from Search

#all_composite_columns, allowed_role_ids, #append_custom_column, #append_ouput_column, #append_to_sql_select_columns, #applicable_sort_terms, #apply_array_match, #apply_criteria, #apply_customer_cross_reference, #apply_distance_search, #apply_select, #apply_sort, #available_events, available_output_columns, #available_output_columns, base_search_class_name, #cleanup_search_results, composite_column, #composite_column, custom_criteria_keys, database_columns, default_columns, default_sort, #discard_excess, #effective_name, #effective_short_name, #employee, #enqueue_navbar_pinned_refresh, #fast_count, favorites, friendly_column_name, #get_pinned_results, #get_sort_term, global_favorite, has_role_for_search?, #human_query_params, instantiate_query_template, #instantiate_resource_updater, #limit_options, main_resource_class, main_resource_table, mass_actions_for_select, #mass_export, maximum_unpersisted_queries, #normalize_for_mass_update, options, options_classes, #output_columns_for_select, #pagy_from_search, #perform, #perform_selected, #pinned_query, #prepend_custom_column, #prepend_output_column, query_favorites_templates, recent_searches_for_employee_id, #record_list, #refresh_pinned_results, #remove_other_pins, search_name, #search_name, #search_results, search_type, search_type_humanized, select_sort_columns, #select_sort_columns, #select_statement, #set_defaults, #set_sort_term, #sort_column1, #sort_column1=, #sort_column2, #sort_column2=, #sort_column3, #sort_column3=, #sort_columns_for_select, #sort_columns_to_hash, #target_geocoding, unpersisted_queries_quote_reached?, #unrecord_list, #validated_selected_columns, view_resource_class, view_resource_klass, #view_resource_klass, view_resource_table, visible?, with_search_results

Methods inherited from ApplicationRecord

ransackable_associations, ransackable_attributes, ransackable_scopes, ransortable_attributes, #to_relation

Methods included from Schedulable

config

Methods included from Models::AfterCommittable

#after_commit

Methods included from Models::EventPublishable

#publish_event

Class Method Details

.discounts_collection_for_select ⇒ Object 



75
76
77
 
# File 'app/models/item_search.rb', line 75

def self.discounts_collection_for_select
  [['Inherit catalog settings if any', nil]] + (0..100).to_a.map { |e| ["#{e} %", (e.to_f / 100).round(2)] }
end

Instance Method Details

#apply_custom_criteria(results) ⇒ Object 



40
41
42
43
44
45
 
# File 'app/models/item_search.rb', line 40

def apply_custom_criteria(results)
  query_params.select { |k, _v| k.to_s.index('spec_field_')&.zero? }.map { |k, v| [k.to_s.split(/^spec_field_/).join, v] }.each do |spec_field, spec_value|
    results = results.with_product_specification(spec_field, spec_value)
  end
  results
end

#mass_add_to_next_cycle_count(params, cur_user = nil) ⇒ Object 



119
120
121
122
123
124
125
126
127
128
129
 
# File 'app/models/item_search.rb', line 119

def mass_add_to_next_cycle_count(params, cur_user = nil)
  return { status: :error, message: 'Target Store must be specified' } if params[:target_store_id].blank?

  jid = MassSearch::ItemAddToNextCycleCountWorker.perform_async(
    'search_id'     => id,
    'action_params' => { 'target_store_id' => params[:target_store_id] },
    'user_id'       => cur_user&.id,
    'locale'        => I18n.locale.to_s
  )
  { status: :ok, job_id: jid }
end

#mass_assign_to_catalog(params, cur_user = nil) ⇒ Object 



102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
 
# File 'app/models/item_search.rb', line 102

def mass_assign_to_catalog(params, cur_user = nil)
  return { status: :error, message: 'Access Denied' } unless cur_user..can?(:update, Item)
  return { status: :error, message: 'Target Catalog must be specified' } if params[:target_catalog_id].blank?

  jid = MassSearch::ItemAssignToCatalogWorker.perform_async(
    'search_id'     => id,
    'action_params' => {
      'target_catalog_id'             => params[:target_catalog_id],
      'discount_to_apply'             => params[:discount_to_apply],
      'add_kit_components_to_catalog' => params[:add_kit_components_to_catalog]
    },
    'user_id'       => cur_user&.id,
    'locale'        => I18n.locale.to_s
  )
  { status: :ok, job_id: jid }
end

#mass_compare_specs(context) ⇒ Object 



171
172
173
174
175
176
 
# File 'app/models/item_search.rb', line 171

def mass_compare_specs(context)
  item_ids = search_results.pluck(:resource_id)
  return { status: :error, message: 'No items selected' } if item_ids.blank?

  context.redirect_to context.reports_items_spec_matrix_path(command: { item_ids: })
end

#mass_create_specs(context) ⇒ Object 



178
179
180
181
182
183
 
# File 'app/models/item_search.rb', line 178

def mass_create_specs(context)
  item_ids = search_results.pluck(:resource_id)
  return { status: :error, message: 'No items selected' } if item_ids.blank?

  context.redirect_to context.new_product_specification_path(product_specification: { item_ids: })
end

#mass_export_amazon_multibox_csv(params = {}, cur_user = nil, path = nil) ⇒ Object 



198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
 
# File 'app/models/item_search.rb', line 198

def mass_export_amazon_multibox_csv(params = {}, cur_user = nil, path = nil)
  item_ids = search_results.pluck(:resource_id)
  return { status: :error, message: 'No items selected' } if item_ids.blank?

  file_name = "export_amazon_multibox_#{id}.csv"
  warehouse_code = params[:warehouse_code].presence || 'DFEE'
  warehouse_name_by_warehouse_code = {
    DFEE: 'WarmlyYours Radiant Inc.',
    AMDR: 'WY-RICHMOND HILL'
  }.with_indifferent_access
  units_by_warehouse_code = {
    DFEE: { length: 'in', weight: 'lbs' },
    AMDR: { length: 'cm', weight: 'kg' }
  }.with_indifferent_access
  part_1_column_names_to_item_methods_hash = {
    SKU: :sku, UPC: :upc, ASIN: :amazon_asin, Title: :title_for_amazon, Warehouse: warehouse_code, 'Warehouse name': warehouse_name_by_warehouse_code[warehouse_code]
  }.with_indifferent_access
  part_2_column_names_by_warehouse_code = {
    DFEE: ['Package number', 'Dimension lock', 'Length (in)', 'Height (in)', 'Width (in)', 'Weight (lb)'],
    AMDR: ['Package number', 'Length (cm)', 'Height (cm)', 'Width (cm)', 'Weight (kg)']
  }.with_indifferent_access
  directory_path = path || Rails.root.join(Rails.application.config.x.temp_storage_path.to_s, 'users', cur_user ? cur_user.id.to_s : '')
  FileUtils.mkdir_p(directory_path)
  file_path = Rails.root.join(directory_path, file_name)
  encoding = params[:encoding].presence || 'UTF-8'
  CSV.open(file_path, 'w', force_quotes: true, encoding: encoding) do |csv|
    csv << (part_1_column_names_to_item_methods_hash.keys + part_2_column_names_by_warehouse_code[warehouse_code])
    items = Item.where(id: item_ids)
    items.each do |item|
      item.boxes_shipping_dimensions_and_weights_converted(units: units_by_warehouse_code[warehouse_code], precision: 2).each_with_index do |box, i|
        row = []
        part_1_column_names_to_item_methods_hash.values.each do |value_or_symbol|
          value = value_or_symbol.is_a?(Symbol) ? item.send(value_or_symbol) : value_or_symbol
          if params[:transliterate].to_b
            value = value.delete('™') # Remove trademark symbol otherwise you'd end up with a ?
            value = value.delete('©') # Remove copyright symbol otherwise you'd end up with a ?
            value = value.gsub('′', ' ft.') # Expand prime symbol to its unit definition
            value = value.gsub('’', ' ft.') # Expand prime symbol to its unit definition
            value = value.gsub('ʺ', ' in.') # Expand double-prime symbol to its unit definition
            value = value.gsub('″', ' in.') # Expand double-prime symbol to its unit definition
          end
          value = I18n.transliterate(value) if params[:encoding].to_s == 'ASCII' # Anything else that is unsavory for ASCII can be transliterated, unless our encoding is UTF-8
          row << value
        end
        row << (i + 1) # Package number
        if warehouse_code == 'DFEE'
          row << 'FALSE' # Dimension lock, which is apparently only for DFEE (not AMDR), is always FALSE as far as I can see
        end
        row << box[0] # Length
        row << box[1] # Width
        row << box[2] # Height
        row << box[3] # Weight
        csv << row
      end
    end
  end
  { status: :ok, result_file: file_name, result_file_path: file_path }
end

#mass_print_item_identifier_labels(params, cur_user = nil) ⇒ Object 



131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
 
# File 'app/models/item_search.rb', line 131

def mass_print_item_identifier_labels(params, cur_user = nil)
  print_profile = PrintProfile.where(id: params[:print_profile_id]).first
  quantity = params[:quantity]&.to_i || 1
  size = params[:size] || 'regular'
  target_market = params[:target_market]
  # return { status: :error, message: 'Print Profile must be selected' } unless print_profile
  ru = instantiate_resource_updater(params[:resource])
  result = { status: :ok }
  # If we are not to send to a printer but instead generate a pdf, we need to store this pdf somewhere
  if print_profile.nil?
    combined_pdf = PdfCombinator.new
    file_name = "export_labels_#{id}.pdf"
    directory_path = Rails.root.join(Rails.application.config.x.temp_storage_path.to_s, 'users', (cur_user&.id || 0).to_s)
    FileUtils.mkdir_p(directory_path)
    file_path = Rails.root.join(directory_path, file_name)
    result[:result_file] = file_name
    result[:result_file_path] = file_path
  end

  ru.perform do |item|
    upc_result = Pdf::Label::ItemIdentifier.call(item, size:, target_market:)
    if print_profile
      base64_output = Base64.encode64(upc_result.pdf)
      print_profile.print(base64_output, quantity:)
    else # Download, so let's combine our pdf
      combined_pdf << upc_result.pdf
    end
    { ok: true }
  end
  if print_profile.nil?
    File.open(result[:result_file_path], 'wb') do |file|
      file.write combined_pdf.to_pdf
      file.flush
      file.fsync
    end
  end

  result
end

#mass_refresh_item_specs(context) ⇒ Object 



185
186
187
188
189
190
191
192
193
194
195
196
 
# File 'app/models/item_search.rb', line 185

def mass_refresh_item_specs(context)
  return { status: :error, message: 'Access Denied' } unless context..can?(:update, Item)

  item_ids = perform_selected(selected_columns: %i[id]).ids
  if item_ids.present?
    item_ids.each { |iid| ItemAttributeWorker.perform_async(iid) }
    context.flash[:info] = "#{item_ids.size} queued for spec refresh"
  else
    context.flash[:warning] = 'No item(s) selected'
  end
  context.redirect_to(context.search_path(self))
end

#mass_update(params, cur_user) ⇒ Object

Mass actions section #



82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
 
# File 'app/models/item_search.rb', line 82

def mass_update(params, cur_user)
  return { status: :error, message: 'Access Denied' } unless cur_user..can?(:update, Item)

  resource_params = (params[:resource] || {}).to_h
  add_product_line_ids    = resource_params.delete('add_product_line_ids') || resource_params.delete(:add_product_line_ids) || []
  remove_product_line_ids = resource_params.delete('remove_product_line_ids') || resource_params.delete(:remove_product_line_ids) || []

  jid = MassSearch::ItemUpdateWorker.perform_async(
    'search_id'     => id,
    'action_params' => {
      'resource_params'           => resource_params,
      'add_product_line_ids'      => add_product_line_ids,
      'remove_product_line_ids'   => remove_product_line_ids
    },
    'user_id'       => cur_user&.id,
    'locale'        => I18n.locale.to_s
  )
  { status: :ok, job_id: jid }
end

#ransack_probe_params ⇒ Object 



36
37
38
 
# File 'app/models/item_search.rb', line 36

def ransack_probe_params
  super.reject { |k, _| k.to_s.start_with?('spec_field_') }
end