object(Cake\ORM\Query\SelectQuery) id:0 {
'(help)' => 'This is a Query object, to get the results execute or iterate it.'
'sql' => 'SELECT `FromDepartments`.`id` AS `FromDepartments__id`, `FromDepartments`.`name` AS `FromDepartments__name` FROM `departments` `FromDepartments` WHERE `Departments`.`is_active` = :c0 ORDER BY `Departments`.`name` ASC'
'params' => [
':c0' => [
'value' => true,
'type' => null,
'placeholder' => 'c0',
],
]
'role' => 'write'
'defaultTypes' => [
'FromDepartments__id' => 'integer',
'FromDepartments.id' => 'integer',
'id' => 'integer',
'FromDepartments__name' => 'string',
'FromDepartments.name' => 'string',
'name' => 'string',
'FromDepartments__code' => 'string',
'FromDepartments.code' => 'string',
'code' => 'string',
'FromDepartments__head_employee_id' => 'integer',
'FromDepartments.head_employee_id' => 'integer',
'head_employee_id' => 'integer',
'FromDepartments__parent_id' => 'integer',
'FromDepartments.parent_id' => 'integer',
'parent_id' => 'integer',
'FromDepartments__description' => 'text',
'FromDepartments.description' => 'text',
'description' => 'text',
'FromDepartments__is_active' => 'boolean',
'FromDepartments.is_active' => 'boolean',
'is_active' => 'boolean',
'FromDepartments__created' => 'datetime',
'FromDepartments.created' => 'datetime',
'created' => 'datetime',
'FromDepartments__modified' => 'datetime',
'FromDepartments.modified' => 'datetime',
'modified' => 'datetime',
]
'executed' => false
'decorators' => (int) 0
'hydrate' => true
'formatters' => (int) 1
'mapReducers' => (int) 0
'contain' => [
]
'matching' => [
]
'extraOptions' => [
'valueField' => 'name',
]
'repository' => object(App\Model\Table\DepartmentsTable) id:1 {
'registryAlias' => 'FromDepartments'
'table' => 'departments'
'alias' => 'FromDepartments'
'entityClass' => 'App\Model\Entity\Department'
'associations' => [
(int) 0 => 'HeadEmployees',
(int) 1 => 'ParentDepartments',
(int) 2 => 'ChildDepartments',
(int) 3 => 'Designations',
(int) 4 => 'Employees',
]
'behaviors' => [
(int) 0 => 'Timestamp',
]
'defaultConnection' => 'default'
'connectionName' => 'default'
}
}