Many many thanks Colin i'd never figured it out before to put the
calculation in the user model. My previous solution is to
class Item < ActiveRecord::Bas
def self.balance_per_mutation(category_id, user)
Item.sum :amount,
:include => :journal,
:conditions => ["journals.user_id = ? and items.category_id
= ?", user, category_id]
end
end
And I find the solution is very troublesome cause everytime the amount
data i need to pass current_user. And forgive me If I'm greedy but i
have another problem and actually i think the same problem.
The problem is for autocomplete plugin.. I'm already follow the guide
on Ryan Railscasts for autocomplete association but the guide
assumption is the category autocomplete is not related at all with
user model, so the autocomplete for category is public category.
Now my problem is i want to make autocomplete for category that
display only user related category not combining with other user
category data. In the comment section of Ryan solution is to make a
second virtual att and model callback. I never manage to make it cos
the parameter i need to pass is the current_user and really doesn't
have any clue at all, but I think the solution is the same as before
maybe if i pushed the process into user model, i will achieved it,
hmmmm.... wanna try out... I will post if i succeded. Anw thanks Colin
On Feb 8, 11:42 pm, Colin Law <[email protected]> wrote:
> Are you sure you are trying to calculate the totals in the right place? I
> think the clue may be in the question. You say "every user has their own
> category and their own
> category amount" which suggests that the user owns the amounts, so possibly
> it should be calculated in the user model, where you can get at the users
> categories and journals and hence the items.
>
> 2009/2/8 Geekyra <[email protected]>
>
>
>
> > Hello, can anybody help me, how to pass @current_user (generated by
> > session[user_id] into a model ? for example I have a relationship like
> > below :
>
> > User has many Journals
> > User has many Categories
> > Journals has many Items
> > Items has many Categories
>
> > The problem is I like to sum "amount" field in Item model based on
> > category and user. So every user has their own category and their own
> > category amount. So if I want to make a method that return sum of item
> > amount where do I put it anyway ? On this problem I can't make through
> > association cause User and Item doesn't related at all, they only
> > related by journals data.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby
on Rails: Talk" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
