I’m a very experienced developer, but new to Yii (and a little less new to PHP). I’ve read most of Agile-Web-Application-Development-with-Yii11-and-PHP5 and seemingly lots of parts of the official documentation and I’ve listened to 50, yes all 50, YiiRadiio pod casts, but do not seem to have the knowledge necessary to accomplish a database select and place the results in a widget in a sidebar.
I have about a dozen database tables all decked out with CRUD using Gii. I have a table called user favorites and its records point to records in other tables. I have tried piecing together the parts necessary to accomplish this, but I just get an empty sidebar. The sidebar is there, just empty. I can place the operations menu from the CRUD pages in the sidebar and it works fine, but I can’t seem to get my widget to do anything.
What I need is an end to end explanation of exactly what to do. I’ve read so many snippets of various kinds that I am now befuddled and don’t know what to do.
I am using the triplet layout from Yii Themes and have applied it in all my controllers. No problem.
I have created a function in the UserFavorite model:
public function findUserFavorites()
{
$dataProvider = new CActiveDataProvider('UserFavorite', array(
'criteria'=>array(
'condition'=>'user_id=3',
'order'=>'insert_datetime DESC',
),
'pagination'=>array(
'pageSize'=>6,
),
));
return $tdataProvider;
}
Inside of my protected folder I have created an extensions folder inside of which I have created a widgets folder inside of which I have placed a Favorites folder which contains a views folder.
In the Favorites folder I have a Favorites.php file which contains:
<?php
//Yii::import(‘zii.widgets.CPortlet’);
class Favorites extends CWidget
{
private $title='User Favorites';
public $displayLimit = 6;
public function getUserFavorites()
{
return UserFavorite::model()->findUserFavorites();
}
protected function renderFavorites()
{
$this->render('favorites');
}
}
In the protected/extensions/widgets/Favorites/views folder I have a favorites.php file which contains:
<ul>
<?php foreach($this->getUserFavorites() as $favorite): ?>
<div class="favorite">
<?php echo CHtml::link(CHtml::encode($favorite->title), array('topic/view', 'id'=>$favorite->item_id)); ?>
</div>
<?php endforeach; ?>
</ul>
Here’s the attributeLabels function from the UserFavorite model so you can see the fields in the table:
public function attributeLabels()
{
return array(
'id' => 'ID',
'user_id' => 'User',
'title' => 'Title',
'description' => 'Description',
'what' => 'What',
'where' => 'Where',
'item_id' => 'Item',
'behavior' => 'Behavior',
'weight' => 'Weight',
'status' => 'Status',
'insert_datetime' => 'Insert Datetime',
'last_edit_datetime' => 'Last Edit Datetime',
'insert_datetime_utc' => 'Insert Datetime Utc',
'last_edit_datetime_utc' => 'Last Edit Datetime Utc',
);
}
The user_id=3 in the findUserFavorites function in the UserFavorite model will be replaced by the current user’s id.
The topic/view in the views file will be replaced by a value determined in a switch statement based on the what field of the user favorite record.
I am doing anything right?
All help is appreciated.
Thanks in advance,
Alex Adams