public function getGuino()
{
$ya = date('Y-m-d H:i:s');
$c = new CDbCriteria();
$c->condition = 'estado = :estado AND (inicio_publicacion < :inicio_p OR inicio_publicacion IS NULL) AND (fin_publicacion > :fin_p OR fin_publicacion IS NULL)';
$c->params = array(':estado' => 1, 'inicio_p' => $ya, 'fin_p' => $ya);
$dependencia = new CDbCacheDependency("SELECT GREATEST(MAX(creado), MAX(modificado)) FROM guino WHERE estado = 1 AND (inicio_publicacion < '" . $ya . "' OR inicio_publicacion IS NULL) AND (fin_publicacion > '" . $ya . "' OR fin_publicacion IS NULL)");
return Guino::model()->cache(3600, $dependencia)->find($c);
}
/**
* 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 $id the ID of the model to be loaded
* @return Url the loaded model
* @throws CHttpException
*/
public function loadModel($id)
{
$model = Guino::model()->findByPk($id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
