dreamjob/app/Model/DreamjobJobOpening.php

<?php
App::uses('AppModel', 'Model');
/**
 * MicDjJobsOpening Model
 *
 * @property Company $Company
 * @property Graducation $Graducation
 * @property Kindofjob $Kindofjob
 */
class DreamjobJobOpening extends AppModel {

/**
 * Use database config
 *
 * @var string
 */
	public $useDbConfig = 'dreamjobMain';

/**
 * Use table
 *
 * @var mixed False or table name
 */
	public $useTable = 'mic_dj_jobs_opening';

/**
 * Display field
 *
 * @var string
 */
	public $displayField = 'title';
    public $order = 'startdate';

/**
 * Validation rules
 *
 * @var array
 */
	public $validate = array(
		'id' => array(
			'numeric' => array(
				'rule' => array('numeric'),
				//'message' => 'Your custom message here',
				//'allowEmpty' => false,
				//'required' => false,
				//'last' => false, // Stop validation after this rule
				//'on' => 'create', // Limit validation to 'create' or 'update' operations
			)
		),
		'street' => array(
			'notEmpty' => array(
				'rule' => array('notEmpty'),
				//'message' => 'Your custom message here',
				//'allowEmpty' => false,
				//'required' => false,
				//'last' => false, // Stop validation after this rule
				//'on' => 'create', // Limit validation to 'create' or 'update' operations
			),
		),
		'postcode' => array(
			'notEmpty' => array(
				'rule' => array('notEmpty'),
				//'message' => 'Your custom message here',
				//'allowEmpty' => false,
				//'required' => false,
				//'last' => false, // Stop validation after this rule
				//'on' => 'create', // Limit validation to 'create' or 'update' operations
			),
		),
		'title' => array(
			'notEmpty' => array(
				'rule' => array('notEmpty'),
				//'message' => 'Your custom message here',
				//'allowEmpty' => false,
				//'required' => false,
				//'last' => false, // Stop validation after this rule
				//'on' => 'create', // Limit validation to 'create' or 'update' operations
			),
		),
		'company_id' => array(
			'numeric' => array(
				'rule' => array('numeric'),
				//'message' => 'Your custom message here',
				//'allowEmpty' => false,
				//'required' => false,
				//'last' => false, // Stop validation after this rule
				//'on' => 'create', // Limit validation to 'create' or 'update' operations
			),
		),
		'branch_id' => array(
			'numeric' => array(
				'rule' => array('numeric'),
				//'message' => 'Your custom message here',
				//'allowEmpty' => false,
				//'required' => false,
				//'last' => false, // Stop validation after this rule
				//'on' => 'create', // Limit validation to 'create' or 'update' operations
			),
		),
		'graducation_id' => array(
			'numeric' => array(
				'rule' => array('numeric'),
				//'message' => 'Your custom message here',
				//'allowEmpty' => false,
				//'required' => false,
				//'last' => false, // Stop validation after this rule
				//'on' => 'create', // Limit validation to 'create' or 'update' operations
			),
		),
		'kindofjob_id' => array(
			'numeric' => array(
				'rule' => array('numeric'),
				//'message' => 'Your custom message here',
				//'allowEmpty' => false,
				//'required' => false,
				//'last' => false, // Stop validation after this rule
				//'on' => 'create', // Limit validation to 'create' or 'update' operations
			),
		),
		'startdate' => array(
			'date' => array(
				'rule' => array('date'),
				//'message' => 'Your custom message here',
				//'allowEmpty' => false,
				//'required' => false,
				//'last' => false, // Stop validation after this rule
				//'on' => 'create', // Limit validation to 'create' or 'update' operations
			),
		),
		'enddate' => array(
			'date' => array(
				'rule' => array('date'),
				//'message' => 'Your custom message here',
				//'allowEmpty' => false,
				//'required' => false,
				//'last' => false, // Stop validation after this rule
				//'on' => 'create', // Limit validation to 'create' or 'update' operations
			),
		),
		'active' => array(
			'boolean' => array(
				'rule' => array('boolean'),
				//'message' => 'Your custom message here',
				//'allowEmpty' => false,
				//'required' => false,
				//'last' => false, // Stop validation after this rule
				//'on' => 'create', // Limit validation to 'create' or 'update' operations
			),
		),
		'text' => array(
			'notEmpty' => array(
				'rule' => array('notEmpty'),
				//'message' => 'Your custom message here',
				//'allowEmpty' => false,
				//'required' => false,
				//'last' => false, // Stop validation after this rule
				//'on' => 'create', // Limit validation to 'create' or 'update' operations
			),
		),
	);

	//The Associations below have been created with all possible keys, those that are not needed can be removed

/**
 * belongsTo associations
 *
 * @var array
 */
	public $belongsTo = array(
		'DreamjobCompany' => array(
			'className' => 'DreamjobCompany',
			'foreignKey' => 'company_id'
		),
		'DreamjobUser' => array(
			'className' => 'DreamjobUser',
			'foreignKey' => 'company_id'
		),
		'AppUser' => array(
			'className' => 'AppUser',
			'foreignKey' => 'company_id'
		),
		'DreamjobListGraducation' => array(
			'className' => 'DreamjobListGraducation',
			'foreignKey' => 'graducation_id',
			'conditions' => '',
			'fields' => '',
			'order' => ''
		),
		'DreamjobListKindofjob' => array(
			'className' => 'DreamjobListKindofjob',
			'foreignKey' => 'kindofjob_id',
			'conditions' => '',
			'fields' => '',
			'order' => ''
		),
		'DreamjobListBranch' => array(
			'className' => 'DreamjobListBranch',
			'foreignKey' => 'branch_id',
			'conditions' => '',
			'fields' => '',
			'order' => ''
		),
		'DreamjobListCity' => array(
			'className' => 'DreamjobListCity',
			'foreignKey' => 'city_id',
			'conditions' => '',
			'fields' => '',
			'order' => ''
		)
	);
	
	public $hasOne = array(
        'User' => array(
                'className' => 'User',
                'foreignKey' => false,
                'conditions' => array('DreamjobJobOpening.company_id = AppUser.id  and User.id = AppUser.user_id'),
                'limit' => 1
            )
    );
    
    public $hasMany = array(
		'DreamjobJobApplication' => array(
			'className' => 'DreamjobJobApplication',
			'foreignKey' => 'opening_id'
		),
    );
}