Have a look at the Containable behaviour, add it to your AppModel (so it is 
always available) and set recursive to -1 in your AppModel. Containable is your 
friend. It gives you complete control over what associated data is returned.

Jeremy Burns
Class Outfit

http://www.classoutfit.com

On 16 Sep 2013, at 14:33:43, Luca Simonella <thermopo...@gmail.com> wrote:

> Hi, this is my first week on CakePhP and I found it awesome.
> I'm developing a web site for my fantasy football championship and I made a 
> few model with the following associations:
> 
> Team has Many Player
> Player belongTo Team
> Player hasMany Vote
> Vote belongTo Player
> 
> So relationships are Team --> Player --> Vote. Now I want to make a view that 
> lists all the players for a specific team AND for each player I want to show 
> statics about their votes. My Player mdoel is made like this:
> 
> class Player extends AppModel{
>       public $belongsTo = 'Team';
>       public $hasMany = array(
>               'Vote' => array(
>                       'className' => 'Vote',
>                       'fields' => array(
>                               'AVG(Voto) as Media',
>                               'SUM(Goal) as Goal',
>                               'SUM(GoalSubito) as GoalSubito',
>                               .... other fields with italian names btw
>                       ),
>                       'group' => array('Giornata')
>               )
>       );      
> }
> 
> when I wrote view for a specific player it works, but If I'm going to wrote 
> the specific team view, data about single player votes does not appear from 
> debug.
> 
> Array
> (
>     [Team] => Array
>         (
>             [ID] => 1
>             [Nome] => Lokomotiv Wagon
>             [Allenatore] => Luca "Ponch" Simonella
>             [Budget] => 320
>             [Stadio] => Julian Ross Stadium Memorial
>             [Maglia] => 
>             [Logo] => 
>             [id] => 1
>         )
> 
>     [Player] => Array
>         (
>             [0] => Array
>                 (
>                     [ID] => 292
>                     [Nome] => AMELIA
>                     [Ruolo] => P
>                     [Squadra] => MILAN
>                     [Quota] => 1
>                     [QuotaIniziale] => 2
>                     [team_id] => 1
>                 )
> 
>             [1] => Array
>                 (
>                     [ID] => 291
>                     [Nome] => ABBIATI
>                     [Ruolo] => P
>                     [Squadra] => MILAN
>                     [Quota] => 13
>                     [QuotaIniziale] => 13
>                     [team_id] => 1
>                 )
> ...
> }
> 
> Have I to use recursive option? How can i go deeply on my association to 
> retrieve data? I hope you could help.
> 
> Thank you
> 
> Luca
> 
> -- 
> Like Us on FaceBook https://www.facebook.com/CakePHP
> Find us on Twitter http://twitter.com/CakePHP
>  
> --- 
> You received this message because you are subscribed to the Google Groups 
> "CakePHP" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to cake-php+unsubscr...@googlegroups.com.
> To post to this group, send email to cake-php@googlegroups.com.
> Visit this group at http://groups.google.com/group/cake-php.
> For more options, visit https://groups.google.com/groups/opt_out.

-- 
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

--- 
You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to cake-php+unsubscr...@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/groups/opt_out.

Reply via email to