CakePHP getting data from multiple models

Question

In my CakePHP application I have a model called 'Customer' which describes (unsurprisingly) an individual customer. I then have a 'Sale' model about a sale. (One customer per sale, many sales per customer). Each sale then has a 'car_id' (which maps to the 'Car' model) and an 'engine_id' (maps to 'Engine model'). Currently when I get the details of one customer, it pulls in the details of each sale associated that that customer, but I want to go one 'step' deeper and have, for each sale, the details of each car and of each engine. How do I do this?

I understand the relationships between the models, but I'm clearly missing something. My current set up is like this...

Customer: $hasMany = 'Sales';

Sale: $hasOne = array('Car', 'Engine');

Obviously the 'Car' and 'Engine' don't have a sale_id associated because they can belong to lots of different sales.

Chuck Burgess · Accepted Answer · 2010-09-07 17:14:02Z

1

As I understand it, your relationship is as follows:

Customer -> Sale -> Car -> Engine

Linear, meaning Car is NOT associated to customer except through the Sale. If this is correct, you only need to set up your relationships in each of the models so they are correctly identified:

Customer hasMany Sale
Sale belongsTo Customer
Sale hasMany Car
Car belongsTo Sale
Car hasMany Engine
Engine belongsTo Car

Then when you query the database, you can do something like:

$this->Customer->find('first', array(
     'conditions' => array('id' => $ID),
     'recursive' => 1          // or 2 depending on your need
  )
);

This will allow you to drill into the data quite easily.

Read more about it here: http://book.cakephp.org/view/73/Retrieving-Your-Data

answered Sep 7, 2010 at 17:14

Chuck Burgess

11.6k5 gold badges44 silver badges76 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Nik Chankov Over a year ago

Just one warning using more than 2 in recursive (even 2 is dangerous) could lead to recursion i.e. Customer hasMany Sale and Sale balongs to Customer. The better option is to use Containable behavior.

bjudson · Accepted Answer · 2010-09-07 20:33:21Z

1

Check out the Containable behavior, it should let you do everything you need: http://book.cakephp.org/view/1323/Containable

In this case, once you enable containable on your models, you can do something like this:

$this->Customer->find('first', array(
    conditions -> array(
        'id' -> $customer_id),
    contain -> array(
        'Sale' -> array(
            'Car', 'Engine'))));

You can also specify which fields and conditions you want for each model within the contain.

edited Sep 7, 2010 at 20:33

answered Sep 7, 2010 at 15:29

bjudson

4,0833 gold badges31 silver badges47 bronze badges

2 Comments

Travis Leleu Over a year ago

Your code won't work -- you need to enclose Sale, Car, Engine in quotes. I also think this is mostly for retrieval of data.

bjudson Over a year ago

Thanks, added the quotes, and also I didn't have enough closing parentheses. As I understood the question, it was about data retrieval.

Jamal Aziz · Accepted Answer · 2010-09-08 07:31:26Z

0

I think your model relationship (and cdburgess) is wrong. It should be like this:

Customer hasMany Sale
Sale belongsTo Customer
Car hasMany Sale
Sale belongsTo Car
Engine hasMany Sale
Sale belongsTo Engine

Then, you can use Containable behaviour to retrieve all related data:

$this->Customer->Behaviors->attach('Containable');
$this->recursive = -1;
$this->Customer->find('first', array(
    'conditions' => array('id' => $ID),
    'contain' => array('Sale' => array('Car', 'Engine'))
));

answered Sep 8, 2010 at 7:31

Jamal Aziz

7103 silver badges5 bronze badges

Collectives™ on Stack Overflow

CakePHP getting data from multiple models

3 Answers 3

1 Comment

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related