public function abuseReportAction()
{
$sSQL = "SELECT ra.id, ra.item_id, ra.item_type, ra.addedon";
$sSQL .= " ,u.email, u.username, u.first_name, u.last_name, u.sex";
$sSQL .= " FROM report_abuse AS ra";
$sSQL .= " JOIN user AS u ON u.id = ra.user_id";
$sSQL .= " WHERE u.status!='deleted' AND ra.status=1";
$sSQL .= " ORDER BY ra.addedon DESC";
//$settings = new Admin_Model_GlobalSettings();
//$page_size = $settings->settingValue('pagination_size');
$page_size = $this->_getParam('page_size', 25);
$page = $this->_getParam('page', 1);
$pageObj = new Base_Paginator();
$paginator = $pageObj->fetchPageDataRaw($sSQL, $page, $page_size);
//set view variables
$this->view->total = $pageObj->getTotalCount();
$this->view->paginator = $paginator;
}
public function getNearByUser($user_id, $distance = 5, $page_size = 6, $page = 1)
{
$gapperLocationM = new Application_Model_GapperLocation();
$latestlocationresult = $gapperLocationM->fetchRow("user_id='{$user_id}' and latest='1'");
if (false === $latestlocationresult) {
return false;
}
$varLatitude = $latestlocationresult->getLatitude();
$varLongitude = $latestlocationresult->getLongitude();
$query = "SELECT gl.address, gl.latest, gl.user_id, sqrt(power(69.1*(gl.latitude - ({$varLatitude})),2)+ power(69.1*(gl.longitude-({$varLongitude}\t\t\t\t\t))*cos(gl.latitude/57.3),2)) as dist ,gl.latitude, gl.longitude FROM\n gapper_location gl where gl.user_id<>'{$user_id}' and gl.latest='1' group by gl.user_id,dist having dist<{$distance} order by dist\n ";
$pageObj = new Base_Paginator();
$paginator = $pageObj->fetchPageDataRaw($query, $page, $page_size);
$returnArray = array();
foreach ($paginator as $row) {
/**
* @Modified By : Mahipal Singh Adhikari
* @Modified On : 15-Nov-2010
* @Modification: check other users publish location privacy to display others users locations in MAP
**/
$view_map = false;
$userNs = new Zend_Session_Namespace('members');
$loggedin_id = $userNs->userId;
$view_map = $this->checkUserPrivacySettings($row->user_id, $loggedin_id, 3);
/*
//now get user map permission settings
$UserPermissionObj = new Application_Model_UserPermission();
$wherePerCond = "user_id='{$row->user_id}' AND permission_id=3";
$mapPermission = $UserPermissionObj->fetchRow($wherePerCond);
$permissionId = $mapPermission->getId();
$mapPermission = $mapPermission->getFriendGroupId();
//echo "<br />mapPermission=".$mapPermission." for id=".$row->user_id."<br />";
if($mapPermission==1)
{
$view_map = true; //display to public
}
else
{
//now check logged in user connection type with other location users
$friend_id = $user_id; //looged in user id as friend id
$friendM = new Application_Model_Friend();
$friend_cond = "user_id='{$row->user_id}' AND friend_id='{$friend_id}' AND status='accept'";
$conTypeObj = $friendM->fetchRow($friend_cond);
//if logged in user connected with this user
if(false!==$conTypeObj)
{
$con_type = $conTypeObj->getConnectionType();
//echo "<br />connection type=".$con_type."<br />";
if($con_type=="friend" && ($mapPermission==2 || $mapPermission==4))
{
$view_map = true; //display to Friends & Family AND Friends, Family and Mates
}
else if($con_type=="family" && ($mapPermission==2 || $mapPermission==4))
{
$view_map = true; //display to Friends & Family AND Friends, Family and Mates
}
else if($con_type=="travelmate" && ($mapPermission==3 || $mapPermission==4))
{
$view_map = true; //display to Travel Mates AND Friends, Family and Mates
}
else
{
$view_map = false;
}
}//end if
}//end else
*/
//if user display map location is true then get user information
if ($view_map) {
$userM = new Application_Model_User();
$userM = $userM->find($row->user_id);
if (false !== $userM) {
$returnArray[] = array("user_id" => $row->user_id, "dist" => $row->dist, "longitude" => $row->longitude, "latitude" => $row->latitude, "address" => $row->address, 'thumnail' => $userM->getThumbnail(), 'firstName' => $userM->getFirstName(), 'lastName' => $userM->getLastName(), 'username' => $userM->getUsername(), 'thumbnail' => $userM->getThumbnail());
}
}
//end of if
}
//end of foreach
//var_dump($returnArray);exit;
return $returnArray;
}
/**
* @Created By : Mahipal Singh Adhikari
* @Created On : 19-Jan-2011
* @Description: Select all users subscribed for newsletter service
*/
public function newsletterUsersAction()
{
$sSQL = "SELECT u.id, u.email, u.username, u.first_name, u.last_name, u.sex, s.addedon";
$sSQL .= " FROM user AS u";
$sSQL .= " JOIN subscribe AS s ON s.user_id=u.id";
$sSQL .= " WHERE u.status!='deleted' AND s.status=1";
$sSQL .= " ORDER BY s.addedon DESC";
//$settings = new Admin_Model_GlobalSettings();
//$page_size = $settings->settingValue('pagination_size');
$page_size = $this->_getParam('page_size', 25);
$page = $this->_getParam('page', 1);
$pageObj = new Base_Paginator();
$paginator = $pageObj->fetchPageDataRaw($sSQL, $page, $page_size);
//$paginator = $pageObj->fetchPageData($model,$page,$page_size, $where);
//set view variables
$this->view->total_users = $pageObj->getTotalCount();
$this->view->paginator = $paginator;
}
public function getRecentBlogsByUserId($userId, $limit)
{
//create database object
$db = Zend_Registry::get('db');
$db->setFetchMode(Zend_Db::FETCH_OBJ);
$blogs = array();
$sql = " SELECT B.id, B.title, B.status, B.journal_id, B.user_id, B.addedon 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 .= " AND J.status = 'public' AND J.publish = 'published'";
$sql .= " AND J.user_id = '{$userId}' AND B.user_id= '{$userId}'";
//$sql .= " ORDER BY B.addedon DESC LIMIT 0, $limit";
$sql .= " ORDER BY B.addedon DESC";
//$blogs = $db->fetchAll($sql);
//get filtered Journals, i.e. Journals based on their Author permissions
$page = 1;
$page_size = $limit;
$pageObj = new Base_Paginator();
$blogs = $pageObj->fetchPageDataRaw($sql, $page, $page_size);
return $blogs;
}
