public function getMyJourneyAction() { $this->view->layout()->disableLayout(); $this->_helper->viewRenderer->setNoRender(true); $userId = $this->_getParam('userId'); $gapperLocationM = new Application_Model_GapperLocation(); $where = "user_id='{$userId}'"; $order = "addedon desc"; $gapperLocations = $gapperLocationM->fetchAll($where, $order); if (count($gapperLocations) > 0) { $i = 0; foreach ($gapperLocations as $location) { $coord[$i]['lat'] = $location->getLatitude(); $coord[$i]['lng'] = $location->getLongitude(); $coord[$i]['id'] = $location->getId(); $i++; } $arrayResult = array('error' => 0, 'coord' => $coord); } else { $arrayResult = array('error' => 1); } echo Zend_Json::encode($arrayResult); }
private function setModel($row) { $model = new Application_Model_GapperLocation(); $model->setId($row->id)->setUserId($row->user_id)->setLongitude($row->longitude)->setLatitude($row->latitude)->setAddress($row->address)->setLatest($row->latest)->setCity($row->city)->setState($row->state)->setCountry($row->country)->setContinent($row->continent)->setRegion($row->region)->setAddedon($row->addedon); return $model; }
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; }
public function indexAction() { if (isset($_SESSION['msg'])) { $this->view->msg = $_SESSION['msg']; unset($_SESSION['msg']); } $userNs = new Zend_Session_Namespace('members'); $userId = $userNs->userId; $form = new Album_Form_Album(); $objModelAlbum = new Album_Model_Album(); $objModelGapperLocation = new Application_Model_GapperLocation(); /*------------- GET GAPPER LOCATION ---------------*/ $yesterday = mktime(0, 0, 0, date("m"), date("d") - 1, date("Y")); $whereGapperLocation = "user_id='{$userId}' and latest=1 AND addedon >= '{$yesterday}'"; $arrGapperLocation = $objModelGapperLocation->fetchAll($whereGapperLocation); if (!empty($arrGapperLocation)) { $this->view->myLatitude = $arrGapperLocation[0]->latitude; $this->view->myLongitude = $arrGapperLocation[0]->longitude; } else { $this->view->myLatitude = ""; $this->view->myLongitude = ""; } /*-------------------------------------------------*/ $elements = $form->getElements(); $form->clearDecorators(); foreach ($elements as $element) { $element->removeDecorator('label'); } /*---------------------- GET USED PHOTO SIZE OF USER --------------------------*/ $arrAlbumCapacity = $objModelAlbum->albumCapacity($userId); $this->view->capacityImage = $arrAlbumCapacity[0]; $this->view->capacityPercent = $arrAlbumCapacity[1]; $request = $this->getRequest(); // Get posted value if ($request->isPost()) { $params = $request->getParams(); // Get all posted value if ($form->isValid($params)) { $option['userId'] = $userId; // LoggedIn UserId $arrLatLang = explode(",", $params['latlang']); $latitude = substr($arrLatLang[0], 1, strlen($arrLatLang[0])); // Longitude of location $longitude = substr($arrLatLang[1], 0, -1); // Latitude of location $option['name'] = $params['name']; $option['description'] = $params['description']; $option['location'] = $params['address']; $option['permission'] = $params['permissions']; $option['longitude'] = $longitude; $option['latitude'] = $latitude; $option['status'] = 1; $albumM = new Album_Model_Album($option); $album_id = $albumM->save(); if ($album_id > 0) { /*----- start tags--------*/ if ($params['tags'] != "" && $params['tags'] != 'Separate Tags by a comma. For example: \' Holiday, London, Travel\'') { $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 Album_Model_AlbumTag(); $albumTagM->setAlbumId($album_id); $albumTagM->setTagId($tag_id); $albumTagM->save(); } } $redirectUrl = "/album/my-photos/album-photos/id/" . $album_id; /*---------- end tags-------*/ //$this->_helper->redirector('index','create-album',"album"); $_SESSION['msg'] = "Album created successfully."; $this->_redirect($redirectUrl); $form->reset(); } else { $_SESSION['msg'] = "Faild to create Album. Please try again."; $this->_redirect('/album/create-album'); } } } $objModelUserPermission = new Application_Model_UserPermission(); $whereUserPermission = "permission_id='5' AND user_id='{$userId}'"; $arrUserPermission = $objModelUserPermission->fetchRow($whereUserPermission); $form->getElement('permissions')->setValue($arrUserPermission->friendGroupId); $this->view->form = $form; }
public function updateMyLocationAction() { $this->_helper->layout->disableLayout(); $this->_helper->viewRenderer->setNoRender(true); $userNs = new Zend_Session_Namespace('members'); $userId = $userNs->userId; $location = new Application_Model_GapperLocation(); $data['latest'] = 0; $location->getMapper()->getDbTable()->update($data, array('user_id = ?' => $userId)); $params = $this->getRequest()->getParams(); $params['userId'] = $userId; $params['latest'] = 1; $location = new Application_Model_GapperLocation($params); $id = $location->save(); if ($id > 0) { $arrayResult = array("id" => $id, 'error' => 0); } else { $arrayResult = array('error' => 1); } echo Zend_Json::encode($arrayResult); }