Class: ItemMovedScrapSupplierPickerInput

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

Instance Method Summary collapse

Methods inherited from TomSelectInput

#input_html_classes

Instance Method Details

#collection ⇒ Object 



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

def collection
  result_data = []
  sql = <<-EOS
    select distinct pt.full_name,sp.supplier_id
    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';
  EOS

  result = ActiveRecord::Base.connection.execute(sql)
  result.each { |r| result_data << [r['full_name'],r['supplier_id'].to_i]}
  result_data.map{|r| [r[0],r[1]]}.uniq.sort
end

#input(wrapper_options = nil) ⇒ Object 



3
4
5
6
 
# File 'app/inputs/item_moved_scrap_supplier_picker_input.rb', line 3

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