显示所有表字段，包括 CakePHP 3 中的许多关联 - Display all tables fields including hasMany associations in CakePHP 3

Display all tables fields including hasMany associations in CakePHP 3

我想获取所有内容并将它们显示在下表中的一个表中：

石油索赔表

    $this->belongsTo('Workers', [
        'foreignKey' => 'worker_id',
        'joinType' => 'INNER'
        //'through' => 'Selections'
    ]);
    $this->belongsTo('Vehicles', [
        'foreignKey' => 'vehicle_id',
        'joinType' => 'INNER'
    ]);

收费索赔表

    $this->belongsTo('Workers', [
        'foreignKey' => 'worker_id',
        'joinType' => 'INNER'
    ]);
    $this->belongsTo('Vehicles', [
        'foreignKey' => 'vehicle_id',
        'joinType' => 'INNER'
    ]);

工作人员表

<?php
namespace App'Model'Table;
use App'Model'Entity'Worker;
use Cake'ORM'Query;
use Cake'ORM'RulesChecker;
use Cake'ORM'Table;
use Cake'Validation'Validator;
/**
 * Workers Model
 *
 */
class WorkersTable extends Table
{
/**
 * Initialize method
 *
 * @param array $config The configuration for the Table.
 * @return void
 */
public function initialize(array $config)
{
    parent::initialize($config);
    $this->hasMany('Petrolclaims', [
        'className' => 'Petrolclaims'
    ]);
    $this->hasMany('Tollclaims', [
        'className' => 'Tollclaims'
    ]);
    $this->table('workers');
    $this->displayField('name');
    $this->primaryKey('id');
}
/**
 * Default validation rules.
 *
 * @param 'Cake'Validation'Validator $validator Validator instance.
 * @return 'Cake'Validation'Validator
 */
public function validationDefault(Validator $validator)
{
    $validator
        ->add('id', 'valid', ['rule' => 'numeric'])
        ->allowEmpty('id', 'create');
    $validator
        ->requirePresence('name', 'create')
        ->notEmpty('name');
    $validator
        ->add('createdDate', 'valid', ['rule' => 'datetime'])
        ->allowEmpty('createdDate', 'create');
    return $validator;
}
}

车辆表

    $this->hasMany('Petrolclaims', [
        'className' => 'Petrolclaims'
    ]);
    $this->hasMany('Tollclaims', [
        'className' => 'Tollclaims'
    ]);

工人控制器

    $results1 = $this->Workers->find('all')
    ->select([
        'Petrolclaims.worker_id', 'Petrolclaims.vehicle_id'
        'Tollclaims.worker_id', 'Tollclaims.vehicle_id', 
        'Workers.id',
        'Vehicles.id'
    ])
    ->order(['Workers.name' => 'ASC'])
    ->contain([
        'Tollclaims','Petrolclaims'
    ]);

我怎样才能做到这一点？

看看这是否有效：

$results1 = $this->Workers->find()
    ->select(['id','name'])
    ->contain([
        'Petrolclaims'=>function ($q) {
            return $q
                ->select(['id','worker_id','vehicle_id'])
                ->autoFields(false);
        },
        'Tollclaims'=>function ($q) {
            return $q
                ->select(['id','worker_id','vehicle_id'])
                ->autoFields(false);
        },
    ])
    ->order(['name' => 'ASC']);

    // EDIT: hasMany data can be accesed by doing the following:
    foreach ($results1 as $worker) {
        echo $worker->petrolclaims[0]->vehicle_id;
    }

_{注意：上述代码未经测试。}

你不需要从表Vehicles中获取数据，因为你只需要Vehicles.id，它已经包含在外键Petrolclaims.vehicle_id和Tollclaims.vehicle_id中。