Cgridview

[jimueldedicatoria]

Good day guys, I have a simple cgridview for my admin page that display all the records. But I want to hide/skip the first record that it will display or start the cgridview with the 2nd record. Thank you in advance.

<?php $this->widget(‘zii.widgets.grid.CGridView’, array(

'id'=>'shis-medinventory-grid',


'dataProvider'=>$model->search(),


'filter'=>$model,


'columns'=>array(


	'med_name',


	'med_desc',


	array(


		'name'=>'medType.mtype_name',


		'filter'=>CHtml::activeTextField($model,'medType_search'),


	),


	array(


		'class'=>'CButtonColumn',


			'template'=>'{view}{update}{delete}',


			'buttons'=>array(


                   'view'=> array(


                        'url'=>'Yii::app()->createUrl("shisMedinventory/view", array("id"=>$data->med_id))',


                   ),


                   'update'=> array(


                        'url'=>'Yii::app()->createUrl("shisMedinventory/update", array("id"=>$data->med_id))',


                   ),


                   'delete'=> array(


                        'url'=>'Yii::app()->controller->createUrl("shisMedinventory/delete",array("id"=>$data->primaryKey))',


					'visible'=>$visStatus,	


                        ),


                   )


	),


),

)); ?>

[joblo (Joe)]

Maybe you can set the ‘offset’ of the CDbCriteria to 1 in the model::search() method.

Not tested, you have to check what happens on pagination.

public function search()

	{


		$criteria=new CDbCriteria;


                $criteria->offset = 1;  


		$criteria->compare(...);

                ...

        }  

[chandrantwins]

Because of curiosity…

what problem do u have with first record

why you dont need first item

[jimueldedicatoria]

Maybe you can set the ‘offset’ of the CDbCriteria to 1 in the model::search() method.

Not tested, you have to check what happens on pagination.

public function search()

	{


		$criteria=new CDbCriteria;


                $criteria->offset = 1;  


		$criteria->compare(...);

                ...

        }  

tnx for the reply, but sad to say it didnt work

[jimueldedicatoria]

Because of curiosity…

what problem do u have with first record

why you dont need first item

haha, you see that cgridview consist of medicine records. it was use to fill the list of data of dropdownlist in my form consultation and the first item has value no data the second row will be the first medicine. upon loading the adminpage for medicine i dont want the admin to see the no data row and starts the record with the medicine. sorry for my bad english

[chandrantwins]

can u give ur screen schot…

do u want to remove first row from cgridview or dropdownlist ?

[joblo (Joe)]

Maybe you can set the ‘offset’ of the CDbCriteria to 1 in the model::search() method.

Not tested, you have to check what happens on pagination.

public function search()

	{


		$criteria=new CDbCriteria;


                $criteria->offset = 1;  


		$criteria->compare(...);

                ...

        }  

Ok, I took a look at Yii source code.

This does only works without pagination when you set the dataproviders pagination=false.

The pagination handling of the dataprovider adds always a offset 0, 10, … on fetching data when pagination is set. Even a model or criteria scope with ‘offset’=>1 will not work.

So I can’t see a solution out of the box without using your own dataprovider/pagination overriding the CActiveDataprovider/CPagination.

[joblo (Joe)]

In you case it should be easy to add a condition to filter the ‘not medicine’

in the search method:

 $criteria->addCondition(... is not a medicine ...);

 ...

 $criteria->addCondition('id=0');

 ...

 $criteria->addCondition('title is null');  

[ahmed201 (Rifajas)]

otherwise you can extend the grid view and during rendering rows make some counter increments by 1 and check whether counter is 1 or not if it is 1 then ignore it

[jimueldedicatoria]

can u give ur screen schot…

do u want to remove first row from cgridview or dropdownlist ?

tnx for ur reply, well this is the screen shot of the page.

I want to hide that from the list because i want to prevent the user to update/edit that specific data.

[jimueldedicatoria]

In you case it should be easy to add a condition to filter the ‘not medicine’

in the search method:

 $criteria->addCondition(... is not a medicine ...);

 ...

 $criteria->addCondition('id=0');

 ...

 $criteria->addCondition('title is null');  

can you please show me this is my code

public function search()

{


	// @todo Please modify the following code to remove attributes that should not be searched.





	$criteria=new CDbCriteria;


	$criteria->compare('med_id',$this->med_id);


	$criteria->compare('med_name',$this->med_name,true);


	$criteria->compare('med_desc',$this->med_desc,true);


	$criteria->compare('med_typeid',$this->med_typeid);


	$criteria->compare('med_flag',$this->med_flag);


	


	$criteria->with=array('medType');


	$criteria->compare('medType.mtype_name',$this->medType_search, true);





	return new CActiveDataProvider($this, array(


		'criteria'=>$criteria,


	));


	


	/* PAGINATION


	return new CActiveDataProvider(get_class($this), array(


		'criteria' => $criteria,


		'pagination' => false,


		));


		*/


}

[jimueldedicatoria]

In you case it should be easy to add a condition to filter the ‘not medicine’

in the search method:

 $criteria->addCondition(... is not a medicine ...);

 ...

 $criteria->addCondition('id=0');

 ...

 $criteria->addCondition('title is null');  

can you please show me this is my code

public function search()

{


	// @todo Please modify the following code to remove attributes that should not be searched.





	$criteria=new CDbCriteria;


	$criteria->compare('med_id',$this->med_id);


	$criteria->compare('med_name',$this->med_name,true);


	$criteria->compare('med_desc',$this->med_desc,true);


	$criteria->compare('med_typeid',$this->med_typeid);


	$criteria->compare('med_flag',$this->med_flag);


	


	$criteria->with=array('medType');


	$criteria->compare('medType.mtype_name',$this->medType_search, true);





	return new CActiveDataProvider($this, array(


		'criteria'=>$criteria,


	));


}

[jimueldedicatoria]

otherwise you can extend the grid view and during rendering rows make some counter increments by 1 and check whether counter is 1 or not if it is 1 then ignore it

tnx for the reply sir, but i dont have any idea how to do that . can you please show me bacause i am very new in yii.