convert query to cakephp query

Question

where concat(`year`,'-',`month`)  BETWEEN '2013-02'  AND '2013-03';

how to use this query in cake php's custom query pagination like this way..

$conditions = array('concat('Payroll.year','-','Payroll.month')  BETWEEN ? and ?' => array(2013-02, 2013-03));

$staff_list =  $this->Payroll->find("all", array("fields" => array("Payroll.id", "Payroll.month", "Payroll.year"),"conditions"=>$conditions));

thank you.

You did not specify your cakephp version. In cake 2.x you would probably use virtual fields here. — mark
– mark, Commented Mar 28, 2013 at 10:07
Is it possible to use the virtual field name in the where condition apart frm the table fields.. — lrajesh03
– lrajesh03, Commented Mar 28, 2013 at 10:17
$conditions = array('monthyear BETWEEN ? and ?' => array(2013-2, 2013-3)); here monthyear is virtual — lrajesh03
– lrajesh03, Commented Mar 28, 2013 at 10:38

Sudhir Bastakoti · Accepted Answer · 2013-03-28 10:36:15Z

2

yes, you could do: in you model:

var $virtualFields = array(
    'payroll_date' => 'CONCAT(Payroll.year, " ", Payroll.month)'
);

and in controller:

$staff_list =  $this->Payroll->find("all", array(
  "fields" => array("Payroll.id", "Payroll.month", "Payroll.year"),
  "conditions" => array('Payroll.payroll_date BETWEEN ? AND ?' => array('2013-02', '2013-03'))
));

answered Mar 28, 2013 at 10:36

Sudhir Bastakoti

100k15 gold badges163 silver badges169 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

convert query to cakephp query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related