public static function getPhotosByAlbum($IDAlbum)
{
$ThePhoto = new self();
$Photos = $ThePhoto->fetchAll("IDParent = '{$IDAlbum}' AND Extension IS NOT NULL");
$Ret = array();
if ($Photos) {
foreach ($Photos as $Photo) {
$ThePhoto = new self();
$Ret[] = $ThePhoto->copyFromDb($Photo);
}
}
return $Ret;
}
public static function getPageAlbums($IDPage)
{
$Ret = array();
$A = new self();
$Albums = $A->fetchAll("IDParent = '{$IDPage}' AND Extension IS NULL", 'Title');
if ($Albums) {
foreach ($Albums as $Album) {
$A = new self();
$Ret[] = $A->copyFromDb($Album);
}
}
return $Ret;
}
public static function getNew($IDParent, $lastID)
{
$TheChat = new self();
$Messages = $TheChat->fetchAll("IDParent = '{$IDParent}' AND IDChat > {$lastID} AND Date + INTERVAL 20 MINUTE > NOW()", "Date");
$Ret = array();
if ($Messages) {
foreach ($Messages as $Message) {
$TheChat = new self();
$Ret[] = $TheChat->copyFromDb($Message);
}
}
return $Ret;
}
public static function getConversation($IDMessage)
{
$TheMessage = new self();
$Select = $TheMessage->select()->join(array('mm' => 'message'), 'message.IDParent = mm.IDParent', array())->where("mm.IDMessage = '{$IDMessage}'")->order("mm.Date");
$Messages = $TheMessage->fetchAll($Select);
$Ret = array();
if ($Messages) {
foreach ($Messages as $Message) {
$TheMessage = new self();
$Ret[] = $TheMessage->copyFromDb($Message);
}
}
return $Ret;
}
public function getSubForums()
{
$TheForum = new self();
$Forums = $TheForum->fetchAll("IDParent = '" . $this->IDForum . "' AND IsForum = '1'", "Position");
$Ret = array();
if ($Forums) {
foreach ($Forums as $Forum) {
$TheForum = new self();
$TheForum->copyFromDb($Forum);
$Ret[] = $TheForum;
}
}
return $Ret;
}
/**
* Ritorna le news di una determinata pagina.
* Se non sono presenti ritorna un array vuoto.
*
* @static
* @param int $IDPage L'identificativo della pagina di cui si vogliono estrarre le news
* @param int $Count
* @param int $Offset
*
* @return array
*/
public static function getPageNews($IDPage, $Count = null, $Offset = null)
{
$Ret = array();
$N = new self();
$News = $N->fetchAll("IDPage = '{$IDPage}' AND IsComment = '0'", 'Date DESC', $Count, $Offset);
if ($News) {
foreach ($News as $New) {
$N = new self();
$N->copyFromDb($New);
$N->Author = Zwe_Model_User::getUserById($N->IDAuthor);
$Ret[] = $N;
}
}
return $Ret;
}
public static function getUsersOnline($Age = 1)
{
$TheOnline = new self();
$Onlines = $TheOnline->fetchAll("Date + INTERVAL {$Age} MINUTE > NOW()", "IDLocation");
$Ret = array();
foreach ($Onlines as $Online) {
$TheOnline = new self();
$TheOnline->copyFromDb($Online);
$TheOnline->User = App_Model_User::getUserById($Online->IDUser);
if ($TheOnline->IDLocation) {
$TheOnline->Location = Mappa_Model_Luogo::get($Online->IDLocation);
}
$Ret[] = $TheOnline;
}
return $Ret;
}
public static function searchUser($Search)
{
$TheUser = new self();
$Users = $TheUser->fetchAll("Name LIKE '%{$Search}%' OR Surname LIKE '%{$Search}%'");
$Ret = array();
if ($Users) {
foreach ($Users as $User) {
$TheUser = new self();
$Ret[] = $TheUser->copyFromDb($User);
}
}
return $Ret;
}
