public function fetchAll()
{
$resultSet = $this->getDbTable()->fetchAll();
$entries = array();
foreach ($resultSet as $row) {
$entry = new Application_Model_Blog();
$entry->setId($row->id)->setUsername($row->user_name)->setDescription($row->description)->setTitle($row->title)->setDateCreated($row->date_created);
$entries[] = $entry;
}
return $entries;
}
public function developersAction()
{
$getblogs = new Application_Model_Blog($this->registry['DB']);
$userid = array('abdulnizam', 's.mohamedmeeran');
$from = $this->getRequest()->getParam('from');
if (empty($from) && !(is_int($from) || ctype_digit($from))) {
$from = 0;
}
$this->view->blogs = $getblogs->getdeveloperBlogs($userid, $from);
$this->view->mydetails = $this->authIdentity;
$string = md5('freniz');
if ($this->_request->isXmlHttpRequest() && $this->getRequest()->getParam('format') == 'xml' || $this->getRequest()->getParam('Accesscode') == $string) {
$this->_helper->viewRenderer->renderScript('blog/blog.ajax.phtml');
}
}
public static function listBlogs()
{
/***************************************************************
* Fetch an array with all the blogs in it.
*/
$blogs = Application_Model_Blog::getBlogList();
return $blogs;
}
public function testShowAction()
{
//Grab a blog file to test with, any old random one.
$blogs = Application_Model_Blog::getBlogList();
if (sizeof($blogs) < 0) {
return;
}
$params = array('action' => 'show', 'controller' => 'Blog', 'module' => 'default', 'id' => $blogs[0]['file']);
$url = $this->url($this->urlizeOptions($params));
$this->dispatch($url);
// assertions
$this->assertModule($params['module']);
$this->assertController($params['controller']);
$this->assertAction($params['action']);
$this->assertQueryContentContains('div#header-logo h1', 'WebAce');
}
/**
* @Created By : Mahipal Singh Adhikari
* @Created On : 3-Nov-2010
* @Description : Count number of post for a particular category with permission check
* @Input : int - category id
* @Return : Int - number of post
*/
public function countCategoryPosts($category_id)
{
//create database object
$db = Zend_Registry::get('db');
$db->setFetchMode(Zend_Db::FETCH_OBJ);
$total_blogs = 0;
$sql = "SELECT b.id, b.user_id, b.status FROM blog AS b";
$sql .= " JOIN journal AS j ON j.id = b.journal_id";
//$sql .= " WHERE b.status = 5 AND b.publish = 'published'";
$sql .= " WHERE b.publish = 'published'";
$sql .= " AND j.status = 'public' AND j.publish = 'published'";
$sql .= " AND b.category_id={$category_id}";
$blogs = $db->fetchAll($sql);
if (count($blogs) > 0) {
$userNs = new Zend_Session_Namespace('members');
$loggedin_id = $userNs->userId;
foreach ($blogs as $blog) {
$view_my_journal = false;
$blogM = new Application_Model_Blog();
$view_my_journal = $blogM->checkBlogPrivacySettings($blog->user_id, $loggedin_id, $blog->status);
if ($view_my_journal) {
$total_blogs = $total_blogs + 1;
}
}
}
return $total_blogs;
}
/**
* @Created By : Mahipal Singh Adhikari
* @Created On : 4-Nov-2010
* @Description: Display more post on "View More" link from User Journals section
*/
public function viewMorejournalsAction()
{
$this->view->layout()->disableLayout();
$username = $this->_getParam('username');
$user = $this->getLeftPanel($username);
$this->view->userObject = $user;
$userNs = new Zend_Session_Namespace('members');
$this->view->userId = $userNs->userId;
/*------------------------- Set paging START------------------------*/
$settings = new Admin_Model_GlobalSettings();
$page_size = $settings->settingValue('journal_page_size');
//$page_size = 1;
$page = $this->_getParam("page");
$offset = ($page - 1) * $page_size;
/*------------------------- Set paging END------------------------*/
$where = "user_id='{$userNs->userId}'";
$blogm = new Application_Model_Blog();
$whereCond = "user_id='{$user->getId()}' AND status='public' AND publish='published'";
//$whereCond = "user_id='{$user->getId()}'";
$data = $blogm->fetchAll($whereCond, "addedon DESC", $page_size, $offset);
$this->view->data = $data;
if (count($data) == 0) {
$this->_helper->viewRenderer->setNoRender(true);
exit("nodata");
}
}
public function getStreams($userids, $criteria = null, $maxId = 0, $minId = 0, $activitylist = null)
{
if (isset($this->authIdentity) && $this->authIdentity->type == 'user') {
if (round((time() - $this->authIdentity->latime) / 60) > 25) {
$this->authIdentity->latime = time();
$this->_db->update('user_info', array('latime' => new Zend_Db_Expr('now()')), array('userid=?' => $this->authIdentity->userid));
}
/*$as=new Zend_Session_Namespace('activity');
if(!isset($as->activity_upper)){
$as->activity_upper=0;
}
if(!isset($as->activity_lower)){
$as->activity_lower=0;
}
if(!isset($as->activitylist)){
$as->activitylist=array();
}
if(isset($reset) && $reset==1){
$as->activity_upper=0;
$as->activity_lower=0;
$as->activitylist=array();
}
//return array();
*/
if (empty($userids)) {
$userids = array_merge($this->authIdentity->friends, array_keys($this->authIdentity->school), array_keys($this->authIdentity->college), array_keys($this->authIdentity->employer), $this->authIdentity->musics, $this->authIdentity->movies, $this->authIdentity->books, $this->authIdentity->celebrities, $this->authIdentity->games, $this->authIdentity->sports, $this->authIdentity->other);
} else {
$userids = explode(',', $userids);
}
$sub_sql = $this->_db->select()->from('activity as t', array('t.activityid', 't.userid', 't.ruserid', 't.contentid', 't.title', 't.contenttype', 't.contenturl', 't.alternate_contentid'))->joinLeft('activity as r', "t.alternate_contentid=r.alternate_contentid and r.userid in (" . $this->_db->quote($userids) . ") and t.activityid < r.activityid", '')->where("t.ruserid!='{$this->authIdentity->userid}' and t.userid in (?)", $userids);
$sql = $this->_db->select()->from('activity as p', array('p.activityid', 'p.userid', 'p.ruserid', 'p.contentid', 'p.title', 'p.contenttype', 'p.contenturl', 'p.alternate_contentid', 'p.date'))->joinLeft(array('q' => new Zend_Db_Expr('(' . $sub_sql . ')')), 'q.alternate_contentid=p.alternate_contentid and p.activityid < q.activityid', '')->joinLeft('friends_vote', 'p.userid=friends_vote.userid', 'friendlist as sfriends')->where('q.activityid is null and p.ruserid!=?', $this->authIdentity->userid);
if (isset($criteria)) {
if ($criteria == 'higher' && !empty($maxId)) {
$sql = $sql->where('p.activityid > ?', $maxId);
} else {
if ($criteria == 'lower' && !empty($minId)) {
$sql = $sql->where('p.activityid < ?', $minId);
}
}
if (!empty($activitylist)) {
$activitylist = explode(',', $activitylist);
$sql = $sql->where('p.alternate_contentid not in (?)', $activitylist);
}
}
$sql = $sql->where('p.userid in (?)', $userids);
$sql = $sql->order('p.date desc')->limit(20);
$results = $this->_db->fetchAssoc($sql);
$activity_mapper = array();
$posts = array();
$activity_users = array();
$activity_results = array();
$userignore = array();
$db_expr = new Zend_Db_Expr('date_sub(now(),interval 5 day)');
/*if(count($results)>=1){
$as->activity_lower=min(array_keys($results));
$as->activity_higher=max(array_keys($results));
}*/
foreach ($results as $activityid => $values) {
//array_push($as->activitylist, $values['alternate_contentid']);
array_push($activity_users, $values['userid']);
array_push($activity_users, $values['ruserid']);
if ($values['contenttype'] == 'post') {
$activity_mapper['posts'][$activityid] = $values['contentid'];
} else {
if ($values['contenttype'] == 'stature') {
$activity_mapper['statures'][$activityid] = $values['contentid'];
} else {
if ($values['contenttype'] == 'blog') {
$activity_mapper['blogs'][$activityid] = $values['contentid'];
} else {
if ($values['contenttype'] == 'admire') {
$activity_mapper['admires'][$activityid] = $values['contentid'];
} else {
if ($values['contenttype'] == 'image') {
$activity_mapper['images'][$activityid] = $values['contentid'];
} else {
if ($values['contenttype'] == 'video') {
$activity_mapper['videos'][$activityid] = $values['contentid'];
} else {
if ($values['contenttype'] == 'forum') {
$activity_mapper['forums'][$activityid] = $values['contentid'];
} else {
if ($values['contenttype'] == 'user') {
if (!in_array($values['ruserid'], $this->authIdentity->friends) && !in_array($this->authIdentity->userid, $userignore) && !in_array($values['userid'], $userignore)) {
array_push($userignore, $values['userid']);
array_push($userignore, $values['ruserid']);
$activity_mapper['users'][$activityid]['recendusers'] = array($values['ruserid']);
if ($values['contentid'] > 0) {
$suserfriends = unserialize($values['sfriends']);
$activity_results['user'][$activityid]['recendusers'] = array_slice($suserfriends, -($values['contentid'] + 1));
foreach ($activity_results['user'][$activityid]['recendusers'] as $user) {
array_push($activity_users, $user);
}
} else {
$activity_results['user'][$activityid]['recendusers'] = array();
}
} else {
$activity_results['user'][$activityid]['recendusers'] = array();
}
} else {
if ($values['contenttype'] == 'propic') {
//$activity_mapper['propics'][$activityid]=$values['contentid'];
$friends = array_diff($this->authIdentity->friends, array($values['userid']));
if (!empty($friends)) {
$sql = $this->select()->from('activity', array('activityid', 'userid'))->where('userid in(?) and contenttype=\'propic\' and alternate_contentid=\'propic\'', $friends)->where('date > ?', $db_expr);
$propic_results = $this->fetchAll($sql)->toArray();
if (!empty($propic_results)) {
$activity_results['propic'][$activityid]['recendusers'] = $propic_results;
foreach ($propic_results as $user) {
array_push($activity_users, $user);
}
} else {
$activity_results['propic'][$activityid]['recendusers'] = array();
}
} else {
$activity_results['propic'][$activityid]['recendusers'] = array();
}
} else {
if ($values['contenttype'] == 'basic info') {
$friends = array_diff($this->authIdentity->friends, array($values['userid']));
if (!empty($friends)) {
$sql = $this->select()->from('activity', array('activityid', 'userid'))->where('userid in(?) and contenttype=\'basic info\' and alternate_contentid=\'basicinfo\'', $friends)->where('date > ?', $db_expr);
$propic_results = $this->fetchAll($sql)->toArray();
if (!empty($propic_results)) {
$activity_results['basic info'][$activityid]['recendusers'] = $propic_results;
foreach ($propic_results as $user) {
array_push($activity_users, $user);
}
} else {
$activity_results['basic info'][$activityid]['recendusers'] = array();
}
} else {
$activity_results['basic info'][$activityid]['recendusers'] = array();
}
} else {
if ($values['contenttype'] == 'personal info') {
$friends = array_diff($this->authIdentity->friends, array($values['userid']));
if (!empty($friends)) {
$sql = $this->select()->from('activity', array('activityid', 'userid'))->where('userid in(?) and contenttype=\'personal info\' and alternate_contentid=\'personalinfo\'', $friends)->where('date > ?', $db_expr);
$propic_results = $this->fetchAll($sql)->toArray();
if (!empty($propic_results)) {
$activity_results['personal info'][$activityid]['recendusers'] = $propic_results;
foreach ($propic_results as $user) {
array_push($activity_users, $user);
}
} else {
$activity_results['personal info'][$activityid]['recendusers'] = array();
}
} else {
$activity_results['personal info'][$activityid]['recendusers'] = array();
}
} else {
if ($values['contenttype'] == 'mood') {
$friends = array_diff($this->authIdentity->friends, array($values['userid']));
if (!empty($friends)) {
$sql = $this->_db->select()->from('activity', array('activityid', 'userid'))->joinLeft('user_info', 'user_info.userid=activity.userid', 'mood')->where('activity.userid in(?) and contenttype=\'mood\' and alternate_contentid=\'mood\'', $friends)->where('activity.date > ?', $db_expr);
$propic_results = $this->_db->fetchAll($sql);
if (!empty($propic_results)) {
$activity_results['mood'][$activityid]['recendusers'] = $propic_results;
foreach ($propic_results as $user) {
array_push($activity_users, $user);
}
} else {
$activity_results['mood'][$activityid]['recendusers'] = array();
}
} else {
$activity_results['mood'][$activityid]['recendusers'] = array();
}
} else {
if ($values['contenttype'] == 'education info') {
$friends = array_diff($this->authIdentity->friends, array($values['userid']));
if (!empty($friends)) {
$sql = $this->select()->from('activity', array('activityid', 'userid'))->where('userid in(?) and contenttype=\'education info\' and alternate_contentid=\'edcationinfo\'', $friends)->where('date > ?', $db_expr);
$propic_results = $this->fetchAll($sql)->toArray();
if (!empty($propic_results)) {
$activity_results['education info'][$activityid]['recendusers'] = $propic_results;
foreach ($propic_results as $user) {
array_push($activity_users, $user);
}
} else {
$activity_results['education info'][$activityid]['recendusers'] = array();
}
} else {
$activity_results['education info'][$activityid]['recendusers'] = array();
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
if (!empty($activity_mapper['posts'])) {
$posts = new Application_Model_Post($this->_db);
$activity_results['post'] = $posts->getPosts($activity_mapper['posts']);
}
if (!empty($activity_mapper['statures'])) {
$posts = new Application_Model_Stature($this->_db);
$activity_results['stature'] = $posts->getStatures($activity_mapper['statures']);
}
if (!empty($activity_mapper['blogs'])) {
$blogs = new Application_Model_Blog($this->_db);
$activity_results['blog'] = $blogs->getBlogsArray($activity_mapper['blogs']);
}
if (!empty($activity_mapper['admires'])) {
$admires = new Application_Model_Admiration($this->_db);
$activity_results['admire'] = $admires->getAdmirationArray($activity_mapper['admires']);
}
if (!empty($activity_mapper['images'])) {
$images = new Application_Model_Images($this->_db);
$activity_results['image'] = $images->getArrayOfImages($activity_mapper['images']);
}
if (!empty($activity_mapper['videos'])) {
$videos = new Application_Model_Videos($this->_db);
$activity_results['video'] = $videos->getVideos($activity_mapper['videos']);
}
if (!empty($activity_mapper['forums'])) {
$forums = new Application_Model_forum($this->_db);
$activity_results['forum'] = $forums->getTopics($activity_mapper['forums']);
}
$activity_users = array_unique($activity_users);
if (!empty($activity_users)) {
$sql = $this->_db->select()->from('freniz', array('userid', 'username', 'user_type' => 'type', 'user_url' => 'url'))->joinLeft('user_info', 'user_info.userid=freniz.userid', array('sex', 'mood'))->joinLeft('image as user_image', 'user_info.propic=user_image.imageid', 'url as user_imageurl')->joinLeft('pages', 'pages.pageid=freniz.userid', '')->joinLeft('image as page_image', 'pages.pagepic=page_image.imageid', 'url as page_imageurl')->where('freniz.userid in (?)', $activity_users);
$activity_users_minipro = $this->_db->fetchAssoc($sql);
} else {
$activity_users_minipro = array();
}
$final_results['activity'] = $results;
$final_results['results'] = $activity_results;
$final_results['users'] = $activity_users_minipro;
$sql = $this->_db->select()->from('commentactivity', 'max(id) as maxcomment');
$result = $this->_db->fetchRow($sql);
$final_results['maxcomment'] = $result['maxcomment'];
return $final_results;
}
}
/**
* @Created By : Mahipal Singh Adhikari
* @Created On : 27-Jan-2011
* @Description : Report Journal/Wall and other items as abuse to admin
*/
public function reportAbuseAction()
{
$this->view->layout()->disableLayout();
$this->_helper->viewRenderer->setNoRender(true);
//get request parameters
$item_id = $this->_getParam('item_id');
$item_type = $this->_getParam('item_type');
//get logged in user ID
$usersNs = new Zend_Session_Namespace('members');
$user_id = $usersNs->userId;
if ($user_id == "" || $user_id == 0) {
$JsonResultArray = array('error' => 1, 'response' => "Please login to report abuse.");
echo Zend_Json::encode($JsonResultArray);
exit;
}
if ($item_id == "" || $item_id == 0) {
$JsonResultArray = array('error' => 2, 'response' => "No item is selected to report abuse.");
echo Zend_Json::encode($JsonResultArray);
exit;
}
if ($item_type == "") {
$JsonResultArray = array('error' => 2, 'response' => "No item type is selected to report abuse.");
echo Zend_Json::encode($JsonResultArray);
exit;
}
//Get user report abuse info for item
$modelM = new Application_Model_ReportAbuse();
$modelRes = $modelM->fetchRow("item_id={$item_id} AND item_type='{$item_type}' AND user_id={$user_id}");
if ($modelRes && $modelRes->getStatus() == 1) {
$JsonResultArray = array('error' => 2, 'response' => "You've already reported this as abuse.");
echo Zend_Json::encode($JsonResultArray);
exit;
} else {
$params["itemId"] = $item_id;
$params["itemType"] = $item_type;
$params["userId"] = $user_id;
$params["comment"] = "";
$params["status"] = 1;
$modelM->setOptions($params);
$dbRes = $modelM->save();
if ($dbRes) {
//get item type information
$itemTitle = "";
$authorId = "";
$author = "";
if ($item_type == 'blog') {
$blogM = new Application_Model_Blog();
$blogRes = $blogM->find($item_id);
$itemTitle = $blogRes->getTitle();
$authorId = $blogRes->getUserId();
$blog_url = Zend_Registry::get('siteurl') . "/journal/view-post/blog_id/" . $item_id;
$itemTitle = "<a href='" . $blog_url . "' target='_blank'>" . $itemTitle . "</a>";
} else {
if ($item_type == 'wall') {
$wallM = new Application_Model_Wall();
$wallRes = $wallM->find($item_id);
$itemTitle = $wallRes->getStatus();
$authorId = $wallRes->getUserId();
} else {
if ($item_type == 'photo') {
$objModelAlbumPhoto = new Album_Model_AlbumPhoto();
$albumPhotoRes = $objModelAlbumPhoto->find($item_id);
$itemTitle = $albumPhotoRes->getName();
$authorId = $albumPhotoRes->getUserId();
}
}
}
//get Blog/Wall owner/author user information
if ($authorId != "") {
$useAuthor = new Application_Model_User();
$authorRes = $useAuthor->find($authorId);
$author = ucfirst($authorRes->getFirstName()) . " " . ucfirst($authorRes->getLastName()) . " (" . $authorRes->getUsername() . ")";
}
//get user information who is reporting abuse item
$userM = new Application_Model_User();
$userR = $userM->find($user_id);
$reporterName = ucfirst($userR->getFirstName()) . " " . ucfirst($userR->getLastName()) . " (" . $userR->getUsername() . ")";
$reporterEmail = $userR->getEmail();
//Now send report abuse email to Administrator
$settings = new Admin_Model_GlobalSettings();
$admin_email = $settings->settingValue('report_abuse');
//$admin_email = "*****@*****.**";
$mailOptions['receiver_email'] = $admin_email;
$mailOptions['item_type'] = ucfirst($item_type);
$mailOptions['item_title'] = $itemTitle;
$mailOptions['item_author'] = $author;
$mailOptions['reporter_name'] = $reporterName;
$mailOptions['reporter_email'] = $reporterEmail;
//create mail class object and send the email
$Mail = new Base_Mail();
$Mail->sendReportAbuseEmail($mailOptions);
//send response
$JsonResultArray = array('error' => 3, 'response' => "Consider it reported!");
} else {
$JsonResultArray = array('error' => 2, 'response' => "Error occured, please try again later.");
}
}
echo Zend_Json::encode($JsonResultArray);
exit;
}
public function deleteblogAction()
{
if ($this->auth->hasIdentity()) {
$deleteblog = new Application_Model_Blog($this->registry['DB']);
$blogid = $this->getRequest()->getParam('blogid');
$this->view->results = $deleteblog->deleteBlog($blogid);
}
}
public function deleteAction()
{
$id = $this->_getParam('id');
$model = new Application_Model_Blog();
//$model->delete("id={$id}");
//added by Mahipal Adhikari on 5-jan-2011, move Blogs to deleted table before deleting permanently
$model->deleteBlog($id);
//$tag = new Application_Model_BlogTag();
//$tag->delete("blog_id={$id}");
$_SESSION['errorMsg'] = "Journal post has been deleted!";
return $this->_helper->redirector('index', 'journals', "admin");
}
/**
* @Created By : Mahipal Singh Adhikari
* @Created On : 1-Nov-2010
* @Description: Used to edit blog post information
*/
public function editBlogAction()
{
$request = $this->getRequest();
$form = new Application_Form_Blog();
$form->removeElement("weight");
//get blog information for edit
$blog_id = $this->_getParam('id');
//$blog_id = base64_decode($blog_id);
if (isset($blog_id)) {
$objBlog = new Application_Model_Blog();
$blog = $objBlog->find($blog_id);
//get blog tags
$tag = new Application_Model_Tags();
$tags = $blog->getTags();
$tags = $tag->getTagsForEdit($blog_id);
$blog_info["title"] = $blog->getTitle();
$blog_info["status"] = $blog->getStatus();
$blog_info["categoryId"] = $blog->getCategoryId();
$blog_info["location"] = $blog->getLocation();
$blog_info["tags"] = $tags;
$blog_info["content"] = $blog->getContent();
$blog_info["comment"] = $blog->getComment();
$blog_info["publish"] = $blog->getPublish();
$blog_info["weight"] = $blog->getWeight();
$form->populate($blog_info);
}
$elements = $form->getElements();
$form->clearDecorators();
foreach ($elements as $element) {
$element->removeDecorator('label');
}
if ($this->getRequest()->isPost()) {
$params = $request->getParams();
if ($form->isValid($params)) {
$userNs = new Zend_Session_Namespace('members');
$journalM = new Application_Model_Journal();
$journal = $journalM->fetchRow("user_id='{$userNs->userId}'");
if (false !== $journal) {
$params['userId'] = $userNs->userId;
$params['journalId'] = $journal->getId();
$params['featured'] = $blog->getFeatured();
$params['weight'] = $blog->getWeight();
//$params['id'] = $blog_id;
$blogM = new Application_Model_Blog($params);
$blog = $blogM->save();
if ($blog && $blog_id != "") {
//now first delete tags
$albumTagM = new Application_Model_BlogTag();
//$objBlogTag = new Application_Model_BlogTag();
$albumTagM->delete("blog_id = {$blog_id}");
//insert/update blog tags
if ($params['tags'] != "") {
$arrTags = explode(",", $params['tags']);
foreach ($arrTags as $_tag) {
$_tag = trim($_tag);
$tagsM = new Application_Model_Tags();
$tag = $tagsM->fetchRow("tag='{$_tag}'");
if (false === $tag) {
$tagsM->setTag($_tag);
$tag_id = $tagsM->save();
} else {
$tag_id = $tag->getId();
}
//$albumTagM=new Application_Model_BlogTag();
$albumTagM->setBlogId($blog_id);
$albumTagM->setTagId($tag_id);
$albumTagM->save();
}
//end of foreach
}
//end of if
/*----------tags-------*/
$_SESSION["flash_msg"] = "Journal post has been updated successfully.";
$form->reset();
} else {
$_SESSION["flash_msg"] = "Failed to update journal post. Please try again later.";
}
} else {
$_SESSION["flash_msg"] = "Failed to update journal post because you have removed your journal.";
}
//redirect user
//$this->_redirect('/journal/my-journals/');
$this->_redirect($this->view->seoUrl('/journal/my-journals/'));
}
//end of if
}
//end of if
$this->view->form = $form;
}
public function userLikeThisAction()
{
$this->_helper->layout->setLayout('journal-layout-2column');
//$item_id = $this->_getParam("blog_id");
$item_id = $this->_getParam("item_id");
$item_type = $this->_getParam("type");
//$userNs = new Zend_Session_Namespace('members');
//$this->view->userId = $userNs->userId;
$item = false;
$itemTypeText = "";
if ($item_type != "") {
if ($item_type == 'blog') {
$blogM = new Application_Model_Blog();
$this->view->blog = $item = $blogM->find($item_id);
$itemTypeText = "Journal Post";
}
if ($item_type == 'status_comment' || $item_type == 'blog_comment') {
$commentM = new Application_Model_Comment();
$item = $commentM->find($item_id);
$itemTypeText = "Comment";
$item_type = "comment";
}
if ($item_type == 'status') {
$wallM = new Application_Model_Wall();
$item = $wallM->find($item_id);
$itemTypeText = "Wall Post";
}
$this->view->itemTypeText = $itemTypeText;
}
//if item is not exists then redirect to Journal home page
if (false === $item) {
$this->_helper->redirector()->gotoUrl('/journal/index/');
exit;
}
//Now get all positive votes of item
//$where = "item_id = $item_id AND vote=1 AND item_type='blog'";
$where = "item_id = {$item_id} AND vote=1";
if ($item_type == 'comment') {
$where .= " AND (item_type='status_comment' OR item_type='blog_comment')";
} else {
$where .= " AND item_type='{$item_type}'";
}
$voteM = new Application_Model_Vote();
$rawdata = $voteM->fetchAll($where);
//Get all users ID voted on an item
if (false !== $rawdata) {
$user_array = array();
foreach ($rawdata as $row) {
$user_array[] = $row->getUserId();
}
}
//get all users information from above User Ids
$this->view->totalUsers = 0;
if (count($user_array) > 0) {
$usrstr = implode(",", $user_array);
$userM = new Application_Model_User();
$whereuser = "******";
$userData = $userM->fetchAll($whereuser, "first_name ASC");
$this->view->userData = $userData;
$settings = new Admin_Model_GlobalSettings();
$page_size = $settings->settingValue('pagination_size');
//$page_size = 1;
$page = $this->_getParam('page', 1);
$pageObj = new Base_Paginator();
$paginator = $pageObj->fetchPageData($userM, $page, $page_size, $whereuser);
$this->view->totalUsers = $pageObj->getTotalCount();
$this->view->paginator = $paginator;
}
}
private function setModel($row)
{
$user = $row->findParentRow('Application_Model_DbTable_User', 'User');
$model = new Application_Model_Blog();
$model->setId($row->id)->setTitle($row->title)->setStatus($row->status)->setWeight($row->weight)->setCategoryId($row->category_id)->setLocation($row->location)->setTags($row->tags)->setContent($row->content)->setComment($row->comment)->setPublish($row->publish)->setJournalId($row->journal_id)->setFeatured($row->featured)->setUserId($row->user_id)->setAddedon($row->addedon)->setUpdatedon($row->updatedon)->setUserObj($user);
return $model;
}
