public function getfriendsbdyAction() { if ($this->auth->hasIdentity()) { $getfriendsbdy = new Application_Model_Friend($this->registry['DB']); $this->view->results = $getfriendsbdy->getfriendsbday(); } }
public function save(Application_Model_Friend $friend) { $data = array('id' => $friend->getId(), 'user_id' => $friend->getUserId(), 'friend_user_id' => $friend->getFriendUserId(), 'confirmed' => $friend->getConfirmed()); if (null === ($id = $friend->getId())) { unset($data['id']); return $this->getDbTable()->insert($data); } else { $this->getDbTable()->update($data, array('id = ?' => $id)); } }
public function confirmAction() { $request = $this->getRequest(); $id = $request->getParam('id'); $user_id = $request->getParam('user_id'); $friend_user_id = $request->getParam('friend_user_id'); $friendMapper = new Application_Model_FriendMapper(); $friend = new Application_Model_Friend(); $friend->setId($id); $friend->setUserId($user_id); $friend->setFriendUserId($friend_user_id); $friend->setConfirmed(1); try { $friendMapper->save($friend); $this->view->msg = 'Friend successfully confirmed'; } catch (Exception $e) { throw new Exception($e->getMessage(), $e->getFile(), $e->getPrevious()); } }
public function autoFriendNameAction() { $this->view->layout()->disableLayout(); $this->_helper->viewRenderer->setNoRender(true); $userNs = new Zend_Session_Namespace('members'); $userId = $userNs->userId; $friendM = new Application_Model_Friend(); $frienddata = $friendM->fetchAll(); $friendids = array(); foreach ($frienddata as $friend) { $friendids[] = $friend->getFriendId(); } $q = strtolower($this->_getParam('term')); if (!$q) { return; } $where = "status='active'"; //$where = "first_name like '%{$q}%' "; $where .= " AND (CONCAT(first_name,' ',last_name ) LIKE '%{$q}%' OR username LIKE '%{$q}%')"; $userM = new Application_Model_User(); $res = $userM->fetchAll($where, null, 11); $result = array(); foreach ($res as $row) { if (in_array($row->getId(), $friendids)) { //array_push($result, array("id"=>$row->getId(), "value" => $row->getFirstName())); $name = $row->getFirstName() . " " . $row->getLastName(); array_push($result, array("id" => $row->getId(), "value" => $name)); } } echo Zend_Json::encode($result); }
public function deleteProfileAction() { $id = $this->getRequest()->getParam('id'); $friendm = new Application_Model_Friend(); $userdata = $friendm->find($id); $userId = $userdata->getUserId(); $friendId = $userdata->getFriendId(); $friendm->delete("id = {$id}"); $friendm->delete("user_id = {$friendId} and friend_id={$userId}"); $this->_redirect('/gapper/my-friends'); }
/** * @Created By : Mahipal Singh Adhikari * @Created On : 28-Dec-2010 * @Description : Get the Login User and User's connection * @Input : $user_id(int), $friend_id(int) * @Return : returns String(connection type) if exists relation otherwise returns False **/ public function getUserConnection($user_id, $friend_id) { $connection = false; //if logged in user viewing own if ($user_id == $friend_id) { $connection = "own"; } //now if user is logged in i.e. $friend_id is not null, check connection with user if (isset($friend_id) && is_numeric($friend_id)) { $friendM = new Application_Model_Friend(); $friend_cond = "user_id='{$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(); $connection = $con_type; } //end if } //end if return $connection; }
public function acceptFAction() { $this->_helper->layout->disableLayout(); $this->_helper->viewRenderer->setNoRender(true); $params = $this->getRequest()->getParams(); $id = $params['id']; $friendM = new Application_Model_Friend(); $friendM = $friendM->find($id); $friendM->setStatus('accept'); $friendM->save(); $fdata['friendId'] = $friendM->getUserId(); $fdata['userId'] = $friendM->getFriendId(); $fdata['connectionType'] = $friendM->getConnectionType(); $fdata['status'] = 'accept'; //print_r($fdata);exit; $friendM = new Application_Model_Friend($fdata); $friendM->save(); //set session and redirect user $_SESSION['session_error_msg'] = "accept"; $this->_redirect($this->view->seoUrl('/gapper/my-messages/')); }
public function getUserFriend($user_id, $detail = false) { $arrFriend = array(); $friendM = new Application_Model_Friend(); $friends = $friendM->fetchAll("user_id='{$user_id}' and status='accept'"); if (count($friends) > 0) { foreach ($friends as $friend) { if ($detail == false) { $arrFriend[] = $friend->getFriendId(); } else { //send friend detail } } } else { return false; } return $arrFriend; }
/** * @Created By : Mahipal Singh Adhikari * @Created On : 17-Nov-2010 * @Description : This function is used to check user privacy settings for his profile * @Input : $user_id(int), $friend_id(int), $permission_id(int) * @Return : boolean(True or False) **/ public function checkUserPrivacySettings($user_id, $friend_id, $permission_id) { $permit = false; //if no parameters sent, return false if (!isset($user_id) && $user_id == "" || !isset($permission_id) && $permission_id) { return false; } //if logged in user viewing own if ($user_id == $friend_id) { return true; } //now get user permission settings $UserPermissionObj = new Application_Model_UserPermission(); $wherePerCond = "user_id='{$user_id}' AND permission_id={$permission_id}"; $permission = $UserPermissionObj->fetchRow($wherePerCond); if (false == $permission) { return false; } $permissionId = $permission->getId(); $permission = $permission->getFriendGroupId(); //echo "<br />permission=".$permission." for id=".$friend_id."<br />"; //if permission is public return true if ($permission == 1) { return true; //display to public } //now if user is logged in i.e. $friend_id is not null, check connection with user if (isset($friend_id) && is_numeric($friend_id)) { $friendM = new Application_Model_Friend(); $friend_cond = "user_id='{$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" && ($permission == 2 || $permission == 4)) { $permit = true; //display to Friends & Family AND Friends, Family and Mates } else { if ($con_type == "family" && ($permission == 2 || $permission == 4)) { $permit = true; //display to Friends & Family AND Friends, Family and Mates } else { if ($con_type == "travelmate" && ($permission == 3 || $permission == 4)) { $permit = true; //display to Travel Mates AND Friends, Family and Mates } else { $permit = false; } } } } else { $permit = false; } } //end if return $permit; }
public function exportAction() { $this->view->layout()->disableLayout(); $this->_helper->viewRenderer->setNoRender(true); include_once LIBRARY_PATH . "/Base/Excel/PHPExcel.php"; $objPHPExcel = new PHPExcel(); $where = "1=1 AND status!='deleted'"; $order = "addedon DESC"; // Add some data $objPHPExcel->setActiveSheetIndex(0)->setCellValue('A1', 'S. No.')->setCellValue('B1', 'Username')->setCellValue('C1', 'First Name')->setCellValue('D1', 'Surname')->setCellValue('E1', 'Email')->setCellValue('F1', 'Gender')->setCellValue('G1', 'Number of Friends')->setCellValue('H1', 'Created On'); $model = new Application_Model_User(); $users = $model->fetchAll($where, $order); if (count($users) > 0) { $i = 2; $sno = 1; foreach ($users as $_user) { //select users Numbers of friends $noOfFriends = 0; $friendM = new Application_Model_Friend(); $userFriends = $friendM->countUserFriends($_user->getId()); $noOfFriends = $userFriends["totalFriends"]; //$country = $_user->findParentRow('Application_Model_DbTable_Country','Country'); // $state = $_user->findParentRow('Application_Model_DbTable_State','State'); $objPHPExcel->setActiveSheetIndex(0)->setCellValue('A' . $i, $sno)->setCellValue('B' . $i, $_user->getUsername())->setCellValue('C' . $i, $_user->getFirstName())->setCellValue('D' . $i, $_user->getLastName())->setCellValue('E' . $i, $_user->getEmail())->setCellValue('F' . $i, ucfirst($_user->getSex()))->setCellValue('G' . $i, $noOfFriends)->setCellValue('H' . $i, date("M j, Y", $_user->getAddedOn())); $i++; $sno++; } } // Rename sheet $objPHPExcel->getActiveSheet()->setTitle('Users'); $objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(10); $objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(35); $objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(15); $objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(15); $objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(45); $objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(15); $objPHPExcel->getActiveSheet()->getColumnDimension('G')->setWidth(15); //$objPHPExcel->getActiveSheet()->getColumnDimension('H')->setWidth(25); //$objPHPExcel->getActiveSheet()->getColumnDimension('I')->setWidth(15); //$objPHPExcel->getActiveSheet()->getColumnDimension('J')->setWidth(15); //$objPHPExcel->getActiveSheet()->getColumnDimension('K')->setWidth(15); // Set active sheet index to the first sheet, so Excel opens this as the first sheet $objPHPExcel->setActiveSheetIndex(0); if ($this->_getParam('type') == 'xls') { // Redirect output to a client’s web browser (Excel5) header('Content-Type: application/vnd.ms-excel'); header('Content-Disposition: attachment;filename="users.xls"'); header('Cache-Control: max-age=0'); $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5'); } else { if ($this->_getParam('type') == 'pdf') { // Redirect output to a client’s web browser (Excel2007) header('Content-Type: application/pdf'); header('Content-Disposition: attachment;filename="users.pdf"'); header('Cache-Control: max-age=0'); $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'PDF'); } else { if ($this->_getParam('type') == 'csv') { // Redirect output to a client’s web browser (Excel5) header('Content-Type: application/vnd.ms-excel'); header('Content-Disposition: attachment;filename="users.csv"'); header('Cache-Control: max-age=0'); $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'CSV'); } } } $objWriter->save('php://output'); }
public function getfriendslistAction() { if ($this->auth->hasIdentity()) { $frd = new Application_Model_Friend($this->registry['DB']); $userid = $this->getRequest()->getParam('userid'); $this->view->results = $frd->getfriends($userid); } }