/**
* @Created By : Mahipal Singh Adhikari
* @Created On : 10-Dec-2010
* @Description: Used to display more wall on "View More" link from User Travel Wall page
*/
public function viewMorewallAction()
{
$this->view->layout()->disableLayout();
//get logged in user Id
$userNs = new Zend_Session_Namespace('members');
$this->view->userId = $userNs->userId;
//Get user Id
$userId = $this->_getParam('user_id');
$this->view->user_profile_id = $userId;
//fetch all user friends
/*
$friendM = new Application_Model_Friend();
$friends = $friendM->getUserFriend($userId);
$friendStr = $userId;
if(false!==$friends)
{
$friendStr = implode(',',$friends);
$friendStr = $userId.", ".$friendStr;
}*/
$order = "addedon DESC";
//$where = "active_status=1 AND user_id in ({$friendStr} )";
$where = "active_status=1";
$where .= " AND (user_id={$userId} AND profile_id=0)";
//get user status
$where .= " OR (user_id={$userId} AND profile_id={$userId})";
//get user own wall
$where .= " OR (user_id!={$userId} AND profile_id={$userId})";
//get walls posted in users profile
// Fetch all hided post id
$WallHideUserPostM = new Application_Model_WallHideUserPost();
$hidedPost = $WallHideUserPostM->getAllHidePostId($userId);
if (count($hidedPost) > 0) {
$hidePost = implode(",", $hidedPost);
$where .= " AND id NOT IN({$hidePost})";
}
// Fetch all hided post user id
$WallHideUserAllM = new Application_Model_WallHideUserAll();
$hidedAllUsersPost = $WallHideUserAllM->getAllPosterId($userId);
if (count($hidedAllUsersPost) > 0) {
$hidedAllUsersPost = implode(",", $hidedAllUsersPost);
$where .= " AND user_id NOT IN({$hidedAllUsersPost})";
}
/*------------------------- Set paging START------------------------*/
$settings = new Admin_Model_GlobalSettings();
$page_size = $settings->settingValue('friend_page_size');
//$page_size = 10;
$page = $this->_getParam("page");
$offset = ($page - 1) * $page_size;
/*------------------------- Set paging END------------------------*/
$feeds = new Application_Model_Wall();
//$data = $feeds->fetchAll($where, $order, $limit);
$data = $feeds->fetchAll($where, $order, $page_size, $offset);
$this->view->data = $data;
//if no record found then no need to render view and exit
if (count($data) == 0) {
$this->_helper->viewRenderer->setNoRender(true);
exit("nodata");
}
}
/**
* @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 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;
}
}
public function removeTravelWallPostAction()
{
$this->_helper->layout->disableLayout();
$this->_helper->viewRenderer->setNoRender(true);
$params = $this->getRequest()->getParams();
$postId = $params['postId'];
$objModelWall = new Application_Model_Wall();
$objModelVote = new Application_Model_Vote();
$objModelComment = new Application_Model_Comment();
$whereWall = "id='{$postId}'";
$whereVote = "item_id='{$postId}' AND item_type='status'";
$whereComment = "item_id='{$postId}' AND item_type='status'";
$arrComment = $objModelComment->fetchAll($whereComment);
if (!empty($arrComment)) {
foreach ($arrComment as $cmt) {
$whereVt = "item_id='{$cmt->id}' AND item_type='status_comment'";
$objModelVote->delete($whereVt);
}
}
$objModelVote->delete($whereVote);
$objModelComment->delete($whereComment);
$objModelWall->delete($whereWall);
exit;
}
private function setModel($row)
{
$parent = $row->findParentRow('Application_Model_DbTable_User', 'User');
$model = new Application_Model_Wall();
$model->setId($row->id)->setStatus($row->status)->setFacebook($row->facebook)->setAddedon($row->addedon)->setUpdatedon($row->updatedon)->setUserId($row->user_id)->setProfileId($row->profile_id)->setUser($parent)->setActiveStatus($row->active_status);
return $model;
}
