CakePHP multiple condition

Multiple condition in find CakePHP

Example 1: If you want this query in CakePHP

SELECT first_name, last_name,joining_date from employees

WHERE id = 047 AND ((joining_date = Last_day(joining_date)

        AND Month(joining_date) IN(3, 6, 9, 12))

        OR (joining_date = '2015-12-10'))

     

$this->Employee->find('all', 

  array('fields' => 

       array('first_name','last_name','joining_date'),

        'conditions' => 

      array('id' => 047,

    'OR' => array(

     array(

      'joining_date = LAST_DAY(joining_date)',

      'MONTH(joining_date)' => array(3,6,9,12)),

    'joining_date' => '2015-12-10'))

    ));

Example 2:

    

$conditions = array(

   'OR' => array(

      array('Employee.name' => 'Sudhir Pandey'),

      array('Employee.name' => 'Nitish Srivastava')

   ),

   'AND' => array(

      array(

        'OR'=>array(

            array('Employee.status' => 'active'),

            'NOT'=>array(

               array('Employee.status'=> array('inactive', 'suspended'))

            )

        )

     )

   )

);

$this->Employee->find('all',array('conditions'=>$conditions));

It will equivalent result to 

SELECT `Employee`.`id`, `Employee`.`name`, `Employee`.`department`,`Employee`.`created`, `Employee`.`status`

FROM `Employees` AS `Employee` WHERE 

((`Employee`.`name` = ‘Sudhir Pandey’) OR (`Employee`.`name` = ‘Nitish Srivastava’))

AND (`Employee`.`status` = ‘active’) OR (NOT (`Employee`.`status` IN (‘inactive’, ‘suspended’))))

Example 3: Only Create conditions

$conditions = array(

    'AND' => array(

        array(

            'OR' => array(

                array('Event.private' => null),

                array('Event.private' => 0)

            )

        ),

        array(

            'OR' => array(

                array('Gallery.private' => null),

                array('Gallery.private' => 0)

            )

        ),

        array(

            'OR' => array(

                array('User.deleted' => null),

                array('User.deleted' => 0)

            )

        )

    )

);