Get the related table values in cakephp3

Question

i have 3 tables like A,B and C.. A and B has relation but A and C dont have any connection. B and C related.

In cakephp3 index action returns the A and B relation only .. i Need to take the table C data.

Table Details:

1. Purchase_details
2. measure_inventories
3. measurement_lables

Table details image

Answer 1

You can use contain to get associated table's data..

If you want association of association then you can use recursive too. But if you want this only with one association then you can try this:

$data = $this->PurchaseDetails->find('all')
                    ->contain(['MeasurementInventories' => ['MeasurementLables']])->toArray();

Answer 2

You have to use contain() to get associated table /model data like:-

$data = $this->PurchaseDetails->find()->contain(['MeasurementInventories' => ['MeasurementLables']])->toArray();

If your requirement is to show data only from measurement_lables then you can add select() to get your desired model data like:-

$data = $this->PurchaseDetails->find()->contain(['MeasurementInventories' => ['MeasurementLables']])->select(['MeasurementLables.*'])->toArray();

Note:- while using contain() you should be sure that the models are associated with each other. for example PurchaseDetails model should be associated with MeasurementInventories(belongsTo, hasMany, hasOne etc...)

$this->belongsTo('PurchaseDetails', [
    'className' => 'MeasurementInventories',
    'foreignKey' => 'columnName'            
]);

And MeasurementInventories is associated with MeasurementLables.

$this->belongsTo('MeasurementInventories', [
    'className' => 'MeasurementLables',
    'foreignKey' => 'columnName'            
]);