CakePHP JOIN无法正常工作

Question

I am new in cakephp and I have searched a lot but couldn't get the solution. My query is not returning any error but it doesn't join the zone table with the disposeTemp table.

public function disposePreview(){

$this->loadModel('DisposeTemp');
$joins = array(
    array(
        'table' => 'zones',                                                                                
        'alias' => 'Zone',                                                                                
        'type' => 'inner',                                                                                                                                                                
        'conditions' => array('DisposeTemp.zone = Zone.id')
    )
);
$options = array(
    'conditions' => array('DisposeTemp.is_delete' => 0,'DisposeTemp.status'=>2),
    'order' => array('Item.item_category_id' => 'asc'),
    'joins' => $joins
);                                         
$getDT = $this->DisposeTemp->find('all', $options);
debug($getDT);
exit;
}

Answer 1

Set foreign key false , as you are not having proper naming convention for foreign key in DisposeTemp table , it was supposed to be zone_id to auto form relationship.

Now in your situation Use.

$joins = array(
    array(
        'table' => 'zones',                                                                                
        'alias' => 'Zone',                                                                                
        'type' => 'inner',       
        'foreignKey' => FALSE,                                                                                                                                                         
        'conditions' => array('DisposeTemp.zone = Zone.id')
    )
);