Cakephp:在一个表中显示数据以及其他表的数据 [英] Cakephp : display data in a table with other table's data
问题描述
我在表格中显示用户，并使用company_id检索公司名称和城市
I'm displaying my users in a table, and I am retrieving the company name and city with company_id
用户:
id lastname firstname company_id role
1 doe john 2 author
2 deo jenne 2 admin
3 deus Joe 1 admin
4 Stewart Rob 1 author
公司:
id name city
1 New-York Company New-York
2 Paris Company Paris
用户显示:
<?php
foreach($users as $user):?>
<tr>
<td><?= $user->lastname?></td>
<td><?= $user->firstname?></td>
<td><?= $user->companies->name ?></td>
<td><?= $user->companies->city?></td>
<td><?= $user->role?></td>
</tr>
<?php endforeach;?>
usersTable.php:
usersTable.php :
<?php
namespace App\Model\Table;
use Cake\ORM\Table;
use Cake\Validation\Validator;
class UsersTable extends Table
{
public function initialize(array $config){
$this->belongsToMany('Companies');
$this->belongsTo('Companies', [
'foreignKey' => 'company_id',
]);
}
}
?>
因此，在我公司的显示屏上，我想检索管理员和作者的姓名，如下所示:
So in my company display, I would like to retrieve admin and author names, like so :
<?php
foreach($companies as $company):?>
<tr>
<td><?= $company->name?></td>
<td><?= $company->city?></td>
<td><?= $company->users-> *adminlastname* ?></td>
<td><?= $company->users-> *adminfirstname* ?></td>
<td><?= $company->users-> *authorlastname* ?></td>
<td><?= $company->users-> *authorfirstname* ?></td>
</tr>
<?php endforeach;?>
我试图让公司ID引用用户中的company_id，以使入门者能够顺利上轨，但没有成功(试图获取非对象的属性)
I have tried getting company id to reference company_id in users for starters to get on track, without success(trying to get property of non-object)
此外，如果我有多个作者和管理员，是否可以使用?每个公司几位管理员的可能性较小，但有可能发生，并且确实有几位作者
Furthermore, would it work if I have several authors and admins ? Less likely to several admins per companies, but can happen, and several authors is definetely possible
companiesTable:
companiesTable :
<?php
namespace App\Model\Table;
use Cake\ORM\Table;
use Cake\Validation\Validator;
class companiesTable extends Table
{
public function initialize(array $config){
//$this->addBehavior('Timestamp');
$this->hasMany('Users');
$this->hasMany('companies', [
'foreignKey' => 'identite',
]);
$this->hasMany('Admins', [
'className' => 'Users',
'conditions' => [
'Admins.role' => 'admin'
]
]);
$this->hasMany('Authors', [
'className' => 'Users',
'conditions' => [
'Admins.role' => 'author'
]
]);
}
public function isOwnedBy($companyId, $userId){
$company = $this
->find('all',['conditions' => ['companies.id'=>$companyId]])
->matching('Users', function ($q) use ($userId) {
return $q->where(['Users.id' => $userId]);
})
->first();
if ($company) return true;
return false;
}
}
添加Companies/index.ctp，仍然太新了，我根本看不出有什么问题...:
Edit : adding Companies/index.ctp, still too new, I do not see at all what's wrong... :
<div class="row">
<div class="medium-4 small-12 columns">
<div style="padding: 22px;">
<h2>companies</h2>
</div>
<div id="customAdd" style="clear:both;padding: 22px;">
<a href="/companies/add" class="button secondary right" data-reveal-id="Modal" data-reveal-ajax="true">add</a>
<div style="clear:both;height:0px;"></div>
</div>
<div id="customSearch" style="clear: both;padding: 22px">
<p style="font-size:36px; display: inline-block;">search for a company</p><input type="text" id="searchBox">
</div>
</div>
<div class="medium-8 small-12 columns">
<div>
<table id="companies" class="cell-border dataTable no-footer">
<thead>
<tr>
<th>name</th>
<th>city</th>
<th>last name</th>
<th>first name</th>
</tr>
</thead>
<tbody>
<?php foreach ($company->users as $user):?>
<tr class='clickable-row' data-href="/companies/edit/<?= $company->id?>">
<td><?= $company->name?></td>
<td><?= $company->city?></td>
<td><?= $company->users[0]->lastname?></td>
<td><?= $company->users[0]->firstname?></td>
</tr>
<?php endforeach;?>
</tbody>
</table>
</div>
</div>
</div>
我遇到这些错误:
Notice (8): Undefined variable: company [APP/Template/Companies/index.ctp, line 36]
Notice (8): Trying to get property of non-object [APP/Template/Companies/index.ctp, line 36]
Warning (2): Invalid argument supplied for foreach() [APP/Template/Companies/index.ctp, line 36]
与此相对应:
<?php foreach ($company->users as $user):?>
CompaniesController:
CompaniesController :
<?php
namespace App\Controller;
use Cake\ORM\TableRegistry;
class CompaniesController extends AppController{
public function index(){
$companies = $this->Companies
->find('all',['order' => ['Companies.name' => 'ASC']]);
$this->set(compact('companies'));
$this->loadModel('Users');
$users = $this->Users->find('all')
->contain(['companies']);
$this->set(compact('users'));
}
public function view($id = null){
$company = $this->Companies->get($id);
$this->set(compact('company'));
}
public function add(){
$company = $this->Companies->newEntity();
if ($this->request->is('post')) {
if ($this->Companies->save($company)) {
$this->Flash->success(__('Your company has been saved.'));
return $this->redirect(['action' => 'index']);
}
$this->Flash->error(__('Unable to add your company.'));
}
$this->set('company', $company);
$this->set(compact('companies'));
}
public function edit($id = null){
$company = $this->Companies->get($id);
if ($this->request->is(['post', 'put'])) {
$company = $this->Companies->patchEntity($company, $this->request->data,['associated' => ['Users']]);
if ($this->Companies->save($company)) {
$this->Flash->success(__('Your company has been updated.'));
return $this->redirect(['action' => 'index']);
}
$this->Flash->error(__('Unable to update your company.'));
}
$this->set('company', $company);
$this->set(compact('companies'));
}
public function delete($id){
$this->request->allowMethod(['post', 'delete']);
$company = $this->Companies->get($id);
if ($this->Companies->delete($company)) {
$this->Flash->success(__('The company with id: {0} has been deleted.', h($id)));
return $this->redirect(['action' => 'index']);
}
}
public function isAuthorized($user){
if ($this->request->action === 'logout') {
return true;
}
if ($this->request->action === 'settings') {
return true;
}
return parent::isAuthorized($user);
}
}
预先感谢
推荐答案
首先，您不能定义多个具有相同名称的关联.假设您有一个company_id字段，从用户的角度来看，这是一个belongsTo关联.
First things first, you cannot define multiple associations with the same name. Given that you have a company_id field, that is a belongsTo association from the users point of view.
鉴于这些先决条件，从公司的角度来看，它自然是一个hasMany关联.我假定您已经在CompaniesTable类中进行了设置，如果没有，那么这就是您首先需要做的.
Given these prerequisites, it's naturally a hasMany association from the companies point of view. I assume that you've set that up already in your CompaniesTable class, if not, then that's what you need to do first.
users属性将是一个User实体对象的数组，因此您需要相应地访问它，即直接通过索引:
The users property will then be an array of User entitiy objects, so you need to access it accordingly, that is either directly via an index:
$company->users[0]->firstname
或对其进行迭代:
foreach ($company->users as $user) {
// $user->firstname
}
如果您需要处理按角色分开的用户，则可以例如对它们进行相应过滤:
If you need to handle the users separated by their roles, then you could for example filter them accordingly:
$admins = collection($company->users)->filter(function ($user) {
return $user->role === 'admin';
});
也许更好，但可以使用条件创建单独的关联:
or maybe better yet create separate associations using conditions:
$this->hasMany('Admins', [
'className' => 'Users',
'conditions' => [
'Admins.role' => 'admin'
]
]);
$this->hasMany('Authors', [
'className' => 'Users',
'conditions' => [
'Admins.role' => 'author'
]
]);
这样，您可以分别包含和访问不同类型的用户:
That way you could contain and access the different types of users separately:
$company->admins
$company->authors
另请参见
