php - CGridview 有条件显示相关模型数据

Question

我正在尝试按category_id过滤gridview中的产品记录

我有三张 table

ProductMst(product_id,name)

CategoryMst(category_id,category_nme)

PromotedUserProduct(category_id,product_id) ====> junction table

ProductMst 模型规则如下

   public function relations()
{

    return array(
        'categoryMsts' => array(self::MANY_MANY, 'CategoryMst', 'promoted_user_product(user_product_id, category_id)'),

    );
}

我的 Controller 代码是这样的

         $criteria=new CDbCriteria();
    $categoryCondition=array();
      if(isset($_GET['category_id']) && $_GET['category_id']!==""){     
        $categoryCondition=array('select'=>false,
                'condition'=>'categoryMsts.category_id=1',
                'joinType'=>'INNER JOIN ');
    }

    $criteria->with=array(
            'categoryMsts'=>$categoryCondition);



    $dataProvider=new CActiveDataProvider('UserProductDtl',array(
        'pagination'=>array(
            'pageSize'=>$pagesize,
            ),
        'criteria'=>$criteria,
        ));
    $this->render('index',
        array('dataProvider'=>$dataProvider));

我无法过滤记录，有人可以帮我吗？

Answer 1

改变这个

$categoryCondition=array(
    'select'=>false,
    'condition'=>'category_id=:category_id',
    'params'=>['category_id'=>$_GET['category_id'],
    'joinType'=>'INNER JOIN '
);