CakePHP conditions for deep associations

Question

I have some deep associations using containable and need to filter back the results. For the sake of this question, let's say we are selling cars and want to narrow the results down by features.

Car hasmany make hasmany model HABTM features

$options = array( 
    'order' => array('Car.price'),
    'contain' => array(
        'make',
        'model' => array(
            'order' => 'Model.name ASC'
        ),
        'features'
    )
);
$cars = $this->Car->find('all', $options);

How would I go about excluding all cars that don't have power windows (Features.name != power_windows).

score 3 · Accepted Answer · answered Sep 26 '13 at 02:31

Containable is only suitable for you to specify what models you wanted to include when fetching data, but not limiting the parent model from fetching data at all. One obvious symptom is that sometimes your parent data may have some null contained data.

So to achieve it, I think we should use joins here so you can specify condition:

$options = array(
    'order' => array('Car.price'),
    'contain' => array(
         'make',
         'model' => array(
             'order' => 'Model.name ASC'
         ),
         'features'
    ),
    'joins' => array(
         array(
             'table' => 'features',
             'alias' => 'Feature',
             'type' => 'LEFT',
             'conditions' => array(
                 'Car.id = Feature.car_id'
             )
         )
     ),
     'conditions' => array(
          'Features.name !=' => 'power_windows',
     )
);

But one drawback of this is that you might have duplicated Car due to joining. That's a separate issue ;)

Thanks Lionel, I didn't know you could use both together... this opens up a lot of possibilities! — Randy Gonzalez, Sep 26 '13 at 05:00

CakePHP conditions for deep associations

1 Answers1