How to setup relationship in cakephp for a one-to-one recursive relationship?

Question

I am new to cakePHP and I am trying to figure out how to create the following relationship:

The employees.manager_id will point to the employees.id of their manager. So, in other words, employee Jason will have a manager of Jill. Jason is employees.id 1 with employees.manager_id 2. Jill is employees.id 2 and employees.manager_id null.

How do I setup the model controller in such a way that when indexing, adding, editing, etc. that the manager_id should be looked up from the same table. For example, when indexing, I would like to see that 'Jill' is the manager of jason rather than the number 2...

Answer 1

you can define following association:

class Employee extrnds AppModel {
var $belongsTo = array(
            'Parent' => array('className' => 'Employee',
                                'foreignKey' => 'manager_id',
                                'conditions' => '',
                                'fields' => '',
                                'order' => ''
            )
    );
}

Then you can access it by:

$this->Employee->Parent->find('list');