CakePHP基于hasMany关系在array（）中获取匹配项

Question

PlanDetails hasMany Companies. PlanDetail table has company_id field.

This is all I need to achieve: PlanDetail.company_id = Company.id. So get all Plan Details where PlanDetail.company_id matches Company.id.

Here is the query I have been messing with in the plan_details_controller:

function pd_list_by_company() {
    $this->PlanDetail->unbindModel(array('hasMany' => array('Plan')));
    $comp_id = $this->PlanDetail->Company->find('all');
    $result = $this->PlanDetails->find('all', array('conditions' => array
('Company.id' => 'PlanDetail.company_id')));
    $company_id = $this->PlanDetail->read('company_id');
    }

I cannot just get the results I need.. what am I doing wrong here?

Answer 1

Sounds like a simple condition on the company_id field to me:

$this->PlanDetail->find('all', array('conditions' => array('company_id' => $company_id)))

Or, if you want the company as well and your associations are hooked up correctly:

$company = $this->Company->read(null, $company_id);

// echo $company['Company']
// echo $company['PlanDetail'][0], $company['PlanDetail'][1] etc...

You need to get a $company_id to query on from somewhere, which is usually the URL:

public function pd_list_by_company($company_id)

Then visit this action with the URL /plan_details/pd_list_by_company/42, which can be linked to using $this->Html->link('foobar', array('controller' => 'plan_details', 'action' => 'pd_list_by_company', 42)).

Complete example:

public function view($planId) {
    $plan = $this->PlanDetail->read(null, $planId);
    if (!$plan) {
       $this->cakeError('error404');
    }
    $otherPlansBySameCompany = $this->PlanDetail->find('all', array(
        'conditions' => array('company_id' => $plan['PlanDetail']['company_id'])
    ));
    $this->set(compact('plan', 'otherPlansBySameCompany'));
}