Viewing file:  VideoCtrl.php (1.63 KB) -rwxr-xr-x
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
require_once("BaseController.php");
class VideoCtrl extends GenericCtrl {
var $model = "Video";
/**
* Construtor principal
* Inicia a classe principal de controle informando o Modelo Atual
*/
public function __construct() {
parent::setConnection($this->model);
}
public function getVideosDestaque($limit=10){
$statement = Doctrine_Manager::getInstance()->connection();
$sql = "(SELECT e.ens_video as url, e.ens_titulo as titulo, e.ens_data as data FROM ensino e WHERE e.ens_video != '')
UNION
(SELECT v.vid_link as url, v.vid_nome as titulo, v.vid_data as data FROM videos v WHERE v.vid_status = 'A')
ORDER BY data DESC";
$q = $statement->execute($sql);
return $q->fetchAll();
}
public function getVideos($limit=10, $offSet=0, $count=false){
$statement = Doctrine_Manager::getInstance()->connection();
$sql = "(SELECT e.ens_video as url, e.ens_titulo as titulo, e.ens_data as data, e.ens_resumo as descricao FROM ensino e WHERE e.ens_video != '')
UNION
(SELECT v.vid_link as url, v.vid_nome as titulo, v.vid_data as data, v.vid_descricao as descricao FROM videos v WHERE v.vid_status = 'A')
ORDER BY data DESC";
if($limit){
$sql = $sql." LIMIT ".$limit." OFFSET ".$offSet;
}
$q = $statement->execute($sql);
if($count){
$result = $q->fetchAll();
return count($result);
}else{
return $q->fetchAll();
}
}
}
?>
|