mysql - cakephp3 从其他模型中选择 count(*)

Question

我有3个型号Employees Customers和Partners

我想显示所有表的计数employees customers和partners在dashboard查看Employees型号。

EmployeesController.php

<?php

namespace App\Controller;

class EmployeesController extends AppController
{
    public function dashboard()
    {

    }

}
?>

我是 cakephp 的新手，我根本不知道如何查询其他模型表。

请向我指出有关此内容的良好教程或文档。会有帮助的

Answer 1

我使用以下代码修复了它。

// Controller
$this->loadModel("Customer");
$query = $this->Customers->find('all', [
    'conditions' => ['Customers.area_cd =' => $this->Auth->user('area_cd')]
]);
$entity_count[0] = $query->count();
$this->loadModel("Employee");
$query = $this->Employees->find('all', [
    'conditions' => ['Employees.area_cd =' => $this->Auth->user('area_cd')]
]);
$entity_count[1] = $query->count();
$this->loadModel("Partner");
$query = $this->Partners->find('all', [
    'conditions' => ['Partners.area_cd =' => $this->Auth->user('area_cd')]
]);
$entity_count[2] = $query->count();

$this->set(compact('entity_count'));

// View
<?= $entity_count[0] ?>