cakephp 在查找中有条件

Question

有人能帮我，告诉我如何在 cakephp 中插入 BEETWEN 吗

我的代码示例:

$zaduzenja = $this->Zaduzenja->find('all',array(
                'conditions' => array(
                        'Zaduzenja.placeno' => 0 ),
                'fields' => array('Zaduzenja.obveznici_id', 'SUM(Zaduzenja.zaduzenje) as dug'),
                'group' => 'Zaduzenja.obveznici_id HAVING array(dug BETWEEN ? AND ? => array('.$iznosOd,$iznosDo)'

        ));

但这不起作用，我只希望计算列“dug”检查是否 Dug >=$temp 1 AND Dug <=$temp2，但这仅适用于具有 clausule 的组

Answer 1

为什么不简单呢？

$db = $this->Zaduzenja->getDataSource();

$iznosOd = $db->value($iznosOd, 'double');  // quotes and escapes input to avoid SQL injections
$iznosDo = $db->value($iznosDo, 'double');  // ditto

$zaduzenja = $this->Zaduzenja->find(
    'all',
    array(
        'conditions' => array(
            'Zaduzenja.placeno' => 0 
        ),
        'fields' => array(
            'Zaduzenja.obveznici_id', 
            'SUM(Zaduzenja.zaduzenje) as dug'
        ),
        'group' => "Zaduzenja.obveznici_id HAVING dug BETWEEN $iznosOd AND $iznosDo"
    )
);