Class: ItemMovedScrapGroupingPickerInput

Inherits:
TomSelectInput
  • Object
show all
Defined in:
app/inputs/item_moved_scrap_grouping_picker_input.rb

Overview

SimpleForm input wrapper: item moved scrap grouping picker.

Instance Method Summary collapse

Methods inherited from TomSelectInput

#input_html_classes

Instance Method Details

#collection ⇒ Object 



9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
 
# File 'app/inputs/item_moved_scrap_grouping_picker_input.rb', line 9

def collection
  sql = "
    select distinct trim(split_part(lineage_expanded,'>',1)) as group1,trim(split_part(lineage_expanded,'>',1)) as group1_position
    from item_ledger_entries le
    inner join items it on le.item_id = it.id
    inner join product_lines pl on it.primary_product_line_id = pl.id
    inner join supplier_items sp on it.id = sp.item_id
    inner join parties pt on sp.supplier_id = pt.id
    where location = 'SCRAP'
    and quantity > 0
    and category = 'RMA_RECEIPT';
  "

  result = ActiveRecord::Base.lease_connection.execute(sql)
  result_data = result.map { |r| [r['group1'], r['group1_position']] }
  result_data.map { |r| [r[0], r[1]] }.uniq.sort
end

#input(wrapper_options = nil) ⇒ Object 



4
5
6
7
 
# File 'app/inputs/item_moved_scrap_grouping_picker_input.rb', line 4

def input(wrapper_options = nil)
  input_html_options[:multiple] = true if input_html_options[:multiple].nil?
  super
end