cgridveiw to display fetched data via customized query

Question

I am a newbei in yii, when a person clicks on a category display him all products under that particular category in a gridview

view productcategory

    <?php $this->widget('zii.widgets.grid.CGridView', array(
'id'=>'admin-grid',
'dataProvider'=>$model->SelectedCategoryProducts,
'filter'=>$model,
'columns'=>array(
    'Name',
    'Model',
    'Brand',
    'Price',

    array(
        'class'=>'CButtonColumn',
    ),
),
 )); ?>

controller product

    public function actionProductcategory($id)

{

$model= Product::model()->SelectedCategoryProducts($id);
    var_dump($model);


    $this->render('productcategory',array(
        'model'=>$model,'id'=>$id,
    ));

} model product

  public function SelectedCategoryProducts($id)
{
    $dataProvider=new CActiveDataProvider('Product', array(
 'criteria'=>array(
                        'select'=>'name,model,price,brand',
        'condition'=>'category=:category',
                        'params'=>array(':category'=>$id),
    )));
    var_dump($dataProvider);
   return $dataProvider;
   }
CException

Property "CActiveDataProvider.sellerSelectedCategoryProducts" is not defined.

PLEASE HELP! I am losing my mind on this ... not able to display in gridview.

I guess, 'dataProvider'=>$model->SelectedCategoryProducts, In this line SelectedCategoryProducts is function and need id as parameter. You have to be use like : 'dataProvider'=>$model->SelectedCategoryProducts($id) — naveen goyal, Dec 26 '13 at 10:17
:) yes, your application is throwing error for this line ; 'dataProvider'=>$model->sellerSelectedCategoryProducts, — Chaulagai, Dec 26 '13 at 10:17
you have to call the function like `$model->SelectedCategoryProducts()` in cgridview — Kumar V, Dec 26 '13 at 10:19
what should be done to to get it displayed in gridview any idea? — Tested, Dec 26 '13 at 10:20
@tisha you have to pass id. like 1 in your function which is category id in your case — naveen goyal, Dec 26 '13 at 10:20
@kumar_v PHP warning Missing argument 1 for Product::sellerSelectedCategoryProducts(), called in D:\wamp\www\testfolder\protected\views\seller\productcategory.php on line 9 and defined — Tested, Dec 26 '13 at 10:22
ya i am passing category id itself but doesnt wrk :( @naveengoyal — Tested, Dec 26 '13 at 10:24

Let me see · Answer 1 · 2013-12-26T10:31:59.597

0

Hope this might help
Controller file

public function actionProductcategory($id)
      { 
$model=new Product;
$this->render('productcategory',array('model'=>$model,
'id'=>$id));
 }

In View file

'dataProvider'=>$model->SelectedCategoryProducts($id),

UPDATE 1

'columns'=>array(
    'name',
    'model',
    'brand',
    'price',

change them to lowercase which are your original column names

edited Dec 26 '13 at 10:31

answered Dec 26 '13 at 10:24

Let me see

5,063
9
34
47

Property "Product.Name" is not defined. – Tested Dec 26 '13 at 10:28
Trying to get property of non-object – Tested Dec 26 '13 at 10:34
change the attributes name in your SelectedCategoryProducts() too. change them to lowercase – Let me see Dec 26 '13 at 10:38
i did try that Trying to get property of non-object – Tested Dec 26 '13 at 10:41

score 0 · Answer 2 · answered Dec 26 '13 at 10:25

0

Pass $id to your view file.

$this->render('productcategory',array('model'=>$model,'id'=>$id));

Then pass id to model function in ccgridview function.

'dataProvider'=>$model->SelectedCategoryProducts($id),

answered Dec 26 '13 at 10:25

Kumar V

8,810
9
39
58

Property "Product.Name" is not defined. – Tested Dec 26 '13 at 10:28
`Product.name`. not 'Name'. In your table, you have `name`. – Kumar V Dec 26 '13 at 10:31

score 0 · Answer 3 · answered Dec 26 '13 at 11:03

0

        $dataProvider=new CActiveDataProvider('Product', array(
     'criteria'=>array(
                            'select'=>'name,model,price,brand',
            'condition'=>'category=:category',
                            'params'=>array(':category'=>$id),
        )));

this can retrieve needed data.... first check that data is perfect ... is it right after that take second step....

answered Dec 26 '13 at 11:03

Jaimin MosLake

655
1
12
30

CException Property "CActiveDataProvider.sellerSelectedCategoryProducts" is not defined. – Tested Dec 26 '13 at 11:08
but the data is perfect – Tested Dec 26 '13 at 11:09
sellerSelectedCategoryProducts is product model function ...? – Jaimin MosLake Dec 26 '13 at 11:11
basics if you are calling model function it can be called like this $model->functionName() or if it is field of model it can be called like the way u call it... $model->fieldname ... like $model->name if name is a field of data table .... if it is method or function it should be like $model->save() or $model->validate() ... () at the end of method or function name... – Jaimin MosLake Dec 26 '13 at 11:16
SelectedCategoryProducts is function in product model – Tested Dec 26 '13 at 11:19
what is the last error you are getting.... update the question accoording to new errors you are getting... – Jaimin MosLake Dec 26 '13 at 11:22
$model->SelectedCategoryProducts($id = ? ) at 'dataProvider'=>$model->SelectedCategoryProducts, like – Jaimin MosLake Dec 26 '13 at 11:23
'dataProvider'=>$model->SelectedCategoryProducts($id = "value" ), – Jaimin MosLake Dec 26 '13 at 11:24

cgridveiw to display fetched data via customized query

3 Answers3