Module: ArelExtensions::MathFunctions

Included in:
Attributes
Defined in:
lib/arel_extensions/math_functions.rb

Instance Method Summary collapse

Instance Method Details

#*(other) ⇒ Object

Arel does not handle Decimal literal properly



15
16
17
18
19
20
21
22
 
# File 'lib/arel_extensions/math_functions.rb', line 15

def * other
  case other
  when Float, BigDecimal
    super(Arel::Nodes.build_quoted(other))
  else
    super(other)
  end
end

#/(other) ⇒ Object

Arel does not handle Decimal literal properly



25
26
27
28
29
30
31
32
 
# File 'lib/arel_extensions/math_functions.rb', line 25

def / other
  case other
  when Float, BigDecimal
    super(Arel::Nodes.build_quoted(other))
  else
    super(other)
  end
end

#abs ⇒ Object

Abs function returns the absolute value of a number passed as argument #



35
36
37
 
# File 'lib/arel_extensions/math_functions.rb', line 35

def abs
    ArelExtensions::Nodes::Abs.new [self]
end

#ceil ⇒ Object

will rounded up any positive or negative decimal value within the function upwards #



40
41
42
 
# File 'lib/arel_extensions/math_functions.rb', line 40

def ceil
    ArelExtensions::Nodes::Ceil.new [self]
end

#floor ⇒ Object

function rounded up any positive or negative decimal value down to the next least integer



45
46
47
 
# File 'lib/arel_extensions/math_functions.rb', line 45

def floor
    ArelExtensions::Nodes::Floor.new [self]
end

#format_number(format_string, locale = nil) ⇒ Object

function returning a number at a specific format



89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
 
# File 'lib/arel_extensions/math_functions.rb', line 89

def format_number format_string, locale=nil
  begin
    sprintf(format_string,0) # this line is to get the right error message if the format_string is not correct
    m = /^(.*)%([ #+\-0]*)([1-9][0-9]+|[1-9]?)[.]?([0-9]*)([a-zA-Z])(.*)$/.match(format_string)
    opts = {
      :prefix     => m[1],
      :flags      => m[2].split(//).uniq.join,
      :width      => m[3].to_i,
      :precision  => m[4] != '' ? m[4].to_i : 6,
      :type       => m[5],
      :suffix     => m[6],
      :locale    => locale,
      :original_string => format_string
    }
    # opts = {:locale => 'fr_FR', :type => "e"/"f"/"d", :prefix => "$ ", :suffix => " %", :flags => " +-#0", :width => 5, :precision => 6}
    ArelExtensions::Nodes::FormattedNumber.new [self,opts]
  rescue Exception
    Arel::Nodes.build_quoted('Wrong Format')
  end
end

#log10 ⇒ Object

function gives the base 10 log



50
51
52
 
# File 'lib/arel_extensions/math_functions.rb', line 50

def log10
    ArelExtensions::Nodes::Log10.new [self]
end

#pow(exposant = 0) ⇒ Object

function gives the power of a number



55
56
57
 
# File 'lib/arel_extensions/math_functions.rb', line 55

def pow exposant = 0
    ArelExtensions::Nodes::Power.new [self,exposant]
end

#power(exposant = 0) ⇒ Object

function gives the power of a number



60
61
62
 
# File 'lib/arel_extensions/math_functions.rb', line 60

def power exposant = 0
    ArelExtensions::Nodes::Power.new [self,exposant]
end

#round(precision = nil) ⇒ Object

function is used to round a numeric field to the number of decimals specified



80
81
82
83
84
85
86
 
# File 'lib/arel_extensions/math_functions.rb', line 80

def round precision = nil
    if precision
        ArelExtensions::Nodes::Round.new [self, precision]
    else
        ArelExtensions::Nodes::Round.new [self]
    end
end

#std(unbiased = true) ⇒ Object

Aggregate Functions



65
66
67
 
# File 'lib/arel_extensions/math_functions.rb', line 65

def std unbiased = true
  ArelExtensions::Nodes::Std.new [self,unbiased]
end

#variance(unbiased = true) ⇒ Object 



69
70
71
 
# File 'lib/arel_extensions/math_functions.rb', line 69

def variance unbiased = true
  ArelExtensions::Nodes::Variance.new [self,unbiased]
end