cakephp在find中有条件 [英] cakephp having condition in find

问题描述

有人可以帮我，并告诉我如何在cakephp中插入BEETWEN

exampleo我的codE：

  $ zaduzenja = $ this-> Zaduzenja-> find（'all'，array（
'conditions'=& '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）'
 
））; 
  / pre> 
 
 
但这不工作，我只想要计算列dug检查是否Dug> = $ temp 1 AND Dug <= $ temp2， 
解决方案
为什么不是这样？
  $ db = $ this-> Zaduzenja-> getDataSource（）; 
 
 $ iznosOd = $ db-> value（$ iznosOd，'double '）; //引号和转义输入，避免SQL注入
 $ 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
）
）; 
  
 
can someone help me, and show me how to insert BEETWEN in having clausule in cakephp

exampleo of my codE:
$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)'

        ));
but this not working, i only want Calculated column "dug" to check if Dug >=$temp 1 AND Dug <=$temp2, but this is posible only in group with having clausule
解决方案
why not simply this?
$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"
    )
);


                        
这篇关于cakephp在find中有条件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！