/**
* Populate the array of site links
* @param array[] &$list The array which holds the array of link information: loc, frequency, priority
*/
public function populateSitemap(&$list)
{
$offers = Offers::model()->published()->currentSite()->findAll();
$niches = Niches::model()->published()->currentSite()->findAll();
// Add primary items here
$list[] = array('loc' => $this->createAbsoluteUrl('/'), 'frequency' => 'weekly', 'priority' => '1');
$list[] = array('loc' => $this->createAbsoluteUrl('/registration'), 'frequency' => 'yearly', 'priority' => '0.5');
$list[] = array('loc' => $this->createAbsoluteUrl('/login'), 'frequency' => 'monthly', 'priority' => '0.5');
$list[] = array('loc' => $this->createAbsoluteUrl('/past'), 'frequency' => 'monthly', 'priority' => '0.5');
$list[] = array('loc' => $this->createAbsoluteUrl('/privacy.html'), 'frequency' => 'yearly', 'priority' => '0.5');
$list[] = array('loc' => $this->createAbsoluteUrl('/offers/index'), 'frequency' => 'weekly', 'priority' => '1');
foreach ($niches as $row) {
$list[] = array('loc' => $this->createAbsoluteUrl('/niches/view', array('slug' => $row->name)), 'frequency' => 'weekly', 'priority' => '1');
}
foreach ($offers as $row) {
$list[] = array('loc' => $this->createAbsoluteUrl('/offers/view', array('slug' => $row->slug)), 'frequency' => 'weekly', 'priority' => '1');
}
}
/**
* Returns the data model based on the primary key given in the GET variable.
* If the data model is not found, an HTTP exception will be raised.
* @param integer the ID of the model to be loaded
*/
public function loadModel($id)
{
//$model=Niches::model()->findByPk($id);
$model = Niches::model()->find('LOWER(name) = :slug', array(':slug' => strtolower($id)));
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
public function getNiches($site_id)
{
$criteria = new CDbCriteria();
$criteria->condition = 'site_id = :site_id';
$criteria->params = array(':site_id' => $site_id);
$criteria->order = 'name';
$niches = CHtml::listData(Niches::model()->findAll($criteria), 'id', 'name');
return $niches;
}
