Trying to get the sum in Ruby - NameError -


i have items table , trying total amount of purchases using .sum method in ruby. not sure why it's not working.

model.rb

class item < activerecord::base   def profit_calc     sold_for - bought_for - fees - shipping   end    def purchase_total     items.sum(&:bought_for)   end    scope :visible, -> { where(sold: false) }   scope :sold, -> { where(sold: true) } end

schema.rb

create_table "items", force: :cascade |t|   t.string   "description"   t.float    "bought_for"   t.float    "sold_for"   t.float    "fees"   t.float    "shipping"   t.datetime "created_at",                          null: false   t.datetime "updated_at",                          null: false   t.boolean  "sold",                default: false end

items controller:

def statistics   @items = item.all   @items_day = item.all.where('created_at >= ? , created_at <= ?', time.zone.now.beginning_of_day, time.zone.now.end_of_day)   @items_week = item.all.where('created_at >= ? , created_at <= ?', time.zone.now.beginning_of_week, time.zone.now.end_of_week)   @items_month = item.all.where('created_at >= ? , created_at <= ?', time.zone.now.beginning_of_month, time.zone.now.end_of_month) end

statistics.html.erb:

<h1 id="title">statistics</h1> <br>  <table class="table table-striped table-bordered">   <thead>     <tr>       <th>total</th>       <th>today</th>       <th>week</th>       <th>month</th>       <th>total purchases</th>       <th>total fees</th>       <th>total shipping</th>       <th>total sales</th>       <th>total profit</th>     </tr>   </thead>    <tbody>     <tr>       <td><%= number_with_delimiter(@items.count) %></td>       <td><%= @items_day.count %></td>       <td><%= @items_week.count %></td>       <td><%= @items_month.count %></td>       <td><%= number_to_currency(item.purchase_total) %></td>       <td></td>       <td></td>       <td></td>       <td></td>     </tr>   </tbody> </table>

error:

enter image description here

you need class method in model:

def self.purchase_total   to_a.sum(&:bought_for) end

or calculation in sql (which performant):

def self.purchase_total   sum(:bought_for) end

and call method on relation in view:

<td><%= number_to_currency(@items.purchase_total) %></td>

Comments

Post a Comment

Popular posts from this blog

asynchronous - C# WinSCP .NET assembly: How to upload multiple files asynchronously -

i using winscp .net assembly uploading files. want upload multiple files asynchronous way. have created method works single upload. public class uploadingdata { private sessionoptions _sessionoptions; private session _session; //connection etc private void onconnected() { foreach (var fileinfo in localfileslist) { var task = task.factory.startnew(() => uploadfilesasync(fileinfo)); } } private async task uploadfilesasync(string file) { string remotefilepath = _session.translatelocalpathtoremote(file, @"/", "/test_data_upload"); var uploading = _session.putfiles(file, remotefilepath, false); //when done await task.run(() => thread.sleep(1000)); } } please suggest me correct way. thanks you can use backgroundworker class this: string[] images = new string[50]; foreach (var path in images) { backgroundworker
Read more

aws api gateway - SerializationException in posting new Records via Dynamodb Proxy Service in API -

i getting "__type": "com.amazon.coral.service#serializationexception" as reply in postman & in test console in api gateway trying post record directly dynamodb using api proxy services.. referring aws article - https://aws.amazon.com/blogs/compute/using-amazon-api-gateway-as-a-proxy-for-dynamodb/ here's mapping { "tablename": "tablenamegoeshere", "item": { "id" : "$context.requestid" "eventname" : "$input.path('$.eventname')", "timestamp" : $input.path('$.timestamp'), "answers": "$util.parsejson($input.path('$.answers'))" } } update: did asked ... , worked if try add array of json objects gives me above same error - here's trying now. please - couldnt find on google well #set($inputroot = $input.path('$')) { "tablename": "answer", "item": {
Read more

asp.net - Problems sending emails from forum -

i have been redesigning site has message board, has been written guy looked after site. it has few problems , written in .asp , uses .mdb files database. you can see whole thing here . feel free post if helps, test thing have set using original files , new database. the basic problem when posts message, supposed email sent them, have posted it. when replies, originator supposed message, replier has been posted. i’d have thought @ point in process there should script/file in postmessage.asp? the postmessage.asp page below. <% option explicit %> <!-- #include virtual="common/adovbs.inc" --> <html> <head> <meta http-equiv="content-type" content="text/html; charset=windows-1252"> <meta name="generator" content="microsoft frontpage 4.0"> <meta name="progid" content="frontpage.editor.document"> <title>new page 2</title> <base target="_self"
Read more