Class: AccountantController

Inherits:
AdminController
  • Object
show all
Defined in:
app/controllers/accountant_controller.rb

Instance Method Summary collapse

Instance Method Details

#bucket_array(array, from, to) ⇒ Object

a new bucketet array version is returned a value is creted for every tick between from and two (so all arrays have same length) ticks int he returned array are javascsript times ie milliseconds since 1970



90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
 
# File 'app/controllers/accountant_controller.rb', line 90

def bucket_array( array  , from , to )
  rb_tick = (@days * 24 * 60 * 60).to_i
  js_tick = rb_tick * 1000
  from = (from.to_i / rb_tick) * js_tick
  to = (to.to_i / rb_tick)* js_tick
  ret = {}
  while from <= to
    ret[from] = 0
    from += js_tick
  end
  array.each do |item|
    value = item.send(@price_or)
    index = (item.created_at.to_i / rb_tick)*js_tick
    if ret[index] == nil
      puts "No index #{index} in array (for bucketing) #{ret.to_json}" if Rails.env == "development"
      ret[index] = 0 
    end
    ret[index] = ret[index] + value
  end
  ret.sort
end

#get_bucket(item) ⇒ Object 



67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
 
# File 'app/controllers/accountant_controller.rb', line 67

def get_bucket item
  return "all" if @group_by == "all"
  case @group_by 
  when "by_category"
    item.product.category.blank? ? "blank" : item.product.category.name
  when "by_supplier"
    item.product.supplier.blank? ? "blank" : item.product.supplier.supplier_name
  when "by_product"
    item.product.name
  when "by_product_line"
    return "Basket #{item.basket.id}" if item.product.line_item? and not item.product.product
    return "Basket #{item.basket.id}" unless item.product
    item.product.full_name
#      item.product.line_item? ? item.product.product.name : item.product.name
  else
    pps = item.product.properties.detect{|p,v| p == @group_by}
    pps ? pps.value : "blank"
  end
end

#group_data ⇒ Object 



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/accountant_controller.rb', line 44

def group_data
  @group_by = (params[:group_by] || "all" )
  all = @search.result(:distinct => true )
  flot = {}
  smallest = all.first ? all.first.created_at : Time.now - 1.week
  largest = all.first ? all.last.created_at : Time.now
  if( @group_by == "all" )
    flot["all"] = all
  else
    all.each do |item|
      bucket = get_bucket(item)
      flot[ bucket ] = [] unless flot[bucket]
      flot[ bucket ] << item        
    end
  end
  @flot_data = flot.collect do |label , data |
    buck = bucket_array( data , smallest , largest )
    sum = buck.inject(0.0){|total , val | total + val[1] }.round(2)
    { :label => "#{label} =#{sum}" , :data => buck } 
  end
  @flot_data.sort!{ |a,b| b[:label].split("=")[1].to_f <=> a[:label].split("=")[1].to_f }
end

#report ⇒ Object 



3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
 
# File 'app/controllers/accountant_controller.rb', line 3

def report
  search = params[:q] || {}
  search[:meta_sort] = "created_at asc"
  if search[:created_at_gt].blank?
    search[:created_at_gt] = Time.now - 3.months
  else
    search[:created_at_gt] = Time.zone.parse(search[:created_at_gt]).beginning_of_day rescue Time.zone.now.beginning_of_month
  end
  unless search[:created_at_lt].blank?
    search[:created_at_lt] =
        Time.zone.parse(search[:created_at_lt]).end_of_day rescue search[:created_at_lt]
  end
  @type = params[:type] || "Order"
  search[:basket_kori_type_eq] = @type
  @period = params[:period] || "week"
  @days = 1
  @days = 7 if @period == "week"
  @days = 30.5 if @period == "month"
  @price_or = (params[:price_or] || "total").to_sym
  search[:order_completed_at_present] = true
  search_on = case @group_by
    when "all"
      Item
    when "by_category"
      Item.includes(:category)
    when "by_product"
      Item
    when "by_variant"
      Item
    else
      Item
    end
  @search = search_on.includes(:product).ransack(search)
  @flot_options = { :series => {  :bars =>  { :show => true , :barWidth => @days * 24*60*60*1000 } , :stack => 0 } , 
                    :legend => {  :container => "#legend"} , 
                    :xaxis =>  { :mode => "time" }  
                  }
  group_data
# csv ?      send_data( render_to_string( :csv , :layout => false) , :type => "application/csv" , :filename => "tilaukset.csv") 
end