public function myStreams($ruserid)
{
if (isset($this->authIdentity)) {
$sql = $this->_db->select()->from('activity', array('activityid', 'userid', 'ruserid', 'contentid', 'title', 'contenttype', 'contenturl', 'alternate_contentid', 'date'))->joinLeft('freniz', 'freniz.userid=activity.ruserid', array('ruserid' => 'userid', 'rusername' => 'username', 'ruserurl' => 'url'))->joinLeft('image', 'image.imageid=freniz.propic', 'image.url as ruserimageurl')->where('ruserid=?', $ruserid)->where('(contenttype=\'post\' and activity.title=\'posted on\') or (contenttype=\'video\' and activity.title=\'post a video on\') or (contenttype=\'image\' and activity.title=\'post image\' and activity.userid!=?) or (contenttype in (\'propic\',\'basicinfo\',\'personalinfo\',\'mood\',\'city\'))', $ruserid);
$results = $this->_db->fetchAssoc($sql);
$myStreamsMapper = array();
foreach ($results as $id => $values) {
switch ($values['contenttype']) {
case 'post':
$myStreamsMapper['posts'][$id] = $values['contentid'];
break;
case 'image':
$myStreamsMapper['images'][$id] = $values['contentid'];
break;
case 'video':
$myStreamsMapper['videos'][$id] = $values['contentid'];
break;
}
}
if (!empty($myStreamsMapper['posts'])) {
$posts = new Application_Model_Post($this->_db);
$myStream_results['post'] = $posts->getPosts($myStreamsMapper['posts']);
}
if (!empty($myStreamsMapper['images'])) {
$images = new Application_Model_Images($this->_db);
$myStream_results['image'] = $images->getArrayOfImages($myStreamsMapper['images']);
}
if (!empty($myStreamsMapper['videos'])) {
$videos = new Application_Model_Videos($this->_db);
$myStream_results['video'] = $videos->getVideos($myStreamsMapper['videos']);
}
$final_results['mystream'] = $results;
$final_results['results'] = $myStream_results;
$sql = $this->_db->select()->from('commentactivity', 'max(id) as maxcomment');
$result = $this->_db->fetchRow($sql);
$final_results['maxcomment'] = $result['maxcomment'];
return $final_results;
}
}
