OFC2 For Ruby on Rails

Bar code and use explicit statement from database.

def bar_code

@bar = Tablename.find_by_sql("Select name,total from tablename limit 0,5")

array_name =[] ###### declare new array to put value from name
amount = [] ###### declare new array to put value from total
@bar.each do |c|
array_name << c.name #### append value from name to array called array_name
amount << c.total #### append value from total to array named amount
end

title = Title.new("Top 5 Name")

bar = BarGlass.new
bar.values = [BarValue.new(amount[0]), BarValue.new(amount[1]), BarValue.new(amount[2]),BarValue.new(amount[3]),BarValue.new(amount[4])]

chart = OpenFlashChart.new
chart.set_title(title)
chart.add_element(bar)

x = XAxis.new
x.set_range (0,20,2)
chart.set_x_axis(x)
y = YAxis.new
y.set_labels(array)
chart.set_y_axis(y)

render :text => chart.to_s
end


---
Should be working ..:P