yii Cdbcriteria无法正常工作

问题描述：

I want to fetch data from two tables Store and mmm_store_services it's all conditions working fine except this

        if(isset($_POST['Store']['location']) && !empty($_POST['Store']['location'])){ 
        $conditions[] = ' AND t.location = '.$_POST["Store"]["location"];   
    }

here is my all code

        $criteria=new CDbCriteria;

    $conditions = array();
    if(isset($_POST['Store']['category']) && !empty($_POST['Store']['category'])){
        $conditions[] = ' AND mmm_store_services.category_id ='.$_POST['Store']['category'];
    }

    if(isset($_POST['Store']['sub_category']) && !empty($_POST['Store']['sub_category'])){
        $conditions[] = ' AND mmm_store_services.service_id ='.$_POST['Store']['sub_category'];
    }

    if(isset($_POST['Store']['location']) && !empty($_POST['Store']['location'])){ 
        $conditions[] = ' AND t.location = '.$_POST["Store"]["location"];   
    }

    if(isset($_POST['Store']['price']) && !empty($_POST['Store']['price'])){
        $price = explode('-',$_POST['Store']['price']);
        $minPrice = trim($price[0]);
        $maxPrice = trim($price[1]);
        $conditions[] = ' AND mmm_store_services.price between '.$minPrice.' AND '.$maxPrice;
    }


    if(count($conditions)>0){
        $condition = implode(' ',$conditions);
        $criteria->join.='INNER JOIN mmm_store_services ON mmm_store_services.store_id = t.id '.$condition;
    }



    $criteria->compare('t.approve','Y');     
    $model = new CActiveDataProvider('Store', array(
        'criteria'=>$criteria,
        'pagination'=>array('pageSize'=>'2'),
    ));

please give me a solution. thanks.

我想从两个表中获取数据存储 strong>和 mmm_store_services strong >除了这个 p>

  if（isset（$ _ POST ['Store'] ['location']）＆amp;＆amp;！empty（$ _ POST ['  Store'] ['location']））{
 $ conditions [] ='AND t.location ='。$ _ POST [“Store”] [“location”];  
} 
  code>  pre> 
 
 这是我的所有代码 p> 
 
 
  $ criteria = new CDbCriteria; 
 
 $  conditions = array（）; 
 if（isset（$ _ POST ['Store'] ['category']）＆amp;＆amp;！empty（$ _ POST ['Store'] ['category']））{
 $  conditions [] ='AND mmm_store_services.category_id ='。$ _ POST ['Store'] ['category']; 
} 
 
 if（isset（$ _ POST ['Store'] ['sub_category']）＆amp;  ;＆amp;！empty（$ _ POST ['Store'] ['sub_category']））{
 $ conditions [] ='AND mmm_store_services.service_id ='。$ _ POST ['Store'] ['sub_category']; \  n} 
 
 if（isset（$ _ POST ['Store'] ['location']）＆amp;＆amp;！empty（$ _ POST ['Store'] ['location']））{
 $条件[  ] ='AND t.location ='。$ _ POST [“Store”] [“location”];  
} 
 
 if（isset（$ _ POST ['Store'] ['price']）＆amp;＆amp;！empty（$ _ POST ['Store'] ['price']））{
 $ price  = explode（' - '，$ _ POST ['Store'] ['price']）; 
 $ minPrice = trim（$ price [0]）; 
 $ maxPrice = trim（$ price [1]）; \  n $ conditions [] ='和mmm_store_services.price在'。$ minPrice。'之间。  AND'。$ maxPrice; 
} 
 
 
 if（count（$ conditions）＆gt; 0）{
 $ condition = implode（''，$ conditions）; 
 $ criteria-＆gt; join。  ='INNER JOIN mmm_store_services ON mmm_store_services.store_id = t.id'。$ condition; 
} 
 
 
 
 $ criteria-＆gt; compare（'t.approve'，'Y'）;  
 $ model = new CActiveDataProvider（'Store'，array（
'criteria'=＆gt; $ criteria，
'pagination'=＆gt; array（'pageSize'=＆gt;'2'），
））  ; 
  code>  pre> 
 
 请给我一个解决方案。
thanks。 p> 
  div>

答

If your $conditions must be in WHERE part and not in JOIN part, than you are missing WHERE keyword and using CDbCriteria wrong (basically not using it at all).

$criteria = new CDbCriteria();
$flag = false;

if(isset($_POST['Store']['category']) && !empty($_POST['Store']['category'])){
    $criteria->addCondition(['mmm_store_services.category_id' => $_POST['Store']['category']]);
    $flag = true;
}

if(isset($_POST['Store']['sub_category']) && !empty($_POST['Store']['sub_category'])){
    $criteria->addCondition(['mmm_store_services.service_id' => $_POST['Store']['sub_category']]);
    $flag = true;
}

if(isset($_POST['Store']['location']) && !empty($_POST['Store']['location'])){ 
    $criteria->addCondition(['t.location' => $_POST["Store"]["location"]]);
    $flag = true;
}

if(isset($_POST['Store']['price']) && !empty($_POST['Store']['price'])){
    $price = explode('-',$_POST['Store']['price']);
    $minPrice = trim($price[0]);
    $maxPrice = trim($price[1]);
    $criteria->addBetweenCondition('mmm_store_services.price', $minPrice, $maxPrice);
    $flag = true;
}


if($flag){
    $criteria->with = ['mmm_store_service']; // Put `mmm_store_service` to relations of model 'Store'
    $criteria->together = true; // Check if you really need this parameter!
}

$criteria->compare('t.approve', 'Y');   

$model = new CActiveDataProvider('Store', array(
    'criteria' => $criteria,
    'pagination' => array('pageSize'=>'2'),
));

yii Cdbcriteria无法正常工作

相关推荐