/** * Sessions count * @param ProfileViewsFilter $filter * @param Integer $cacheMinutes * @return Integer */ public function getChatSessionsCount(ChatSessionFilter $filter = null) { if ($filter == null) { $filter = new ChatSessionFilter(); } $filter->setSelectCount(); $sqlQuery = $filter->getSQL(); $this->query->exec($sqlQuery); return $this->query->fetchField('cnt'); }
public function getChatSessions(ChatSessionFilter $filter, $myUserId = null) { $chatSessions = array(); if ($filter == null) { $filter = new ChatSessionFilter(); } $sqlQuery = $filter->getSQL(); $sessionRows = $this->query->exec($sqlQuery)->fetchRecords(); foreach ($sessionRows as $sessionRow) { array_push($chatSessions, $this->getChatSessionObject($sessionRow, $myUserId)); } return $chatSessions; }