public function __construct() { $this->_accessKey = '88b43206bc04bb027f1e14ab428ac830'; $this->_secret = 'b316e31501577669aac92578252053e5'; $this->token = '4e6c3665df07a9905e28467c551355a5a1'; $objServerInfo = new \services\helpers\ServerInfo(); $this->_serviceurl = $objServerInfo->getScheme() . "://" . $objServerInfo->getHost() . APPLICATION_BASE; }
/** Function to get dog Profile * @param int $dogId id of the dog * @return array **/ public function getDogProfile($dogId) { $dog = $this->_redbeans->load($this->_name, $dogId); if ($dog) { $objServerInfo = new \services\helpers\ServerInfo(); $dogProfile = $dog->export(false); $dogUrl = $objServerInfo->getScheme() . "://" . $objServerInfo->getHost() . APPLICATION_BASE . 'dogimages/' . $dog['dog_pic']; $picPath = APPLICATION_DIR . "/dogimages/{$dog['dog_pic']}"; $dogProfile['dog_pic'] = @is_file($picPath) ? $dogUrl : null; return $dogProfile; } return array(); }
/** *Function to search having with given location * @param string $query location for which experts are to be searched * @return array * **/ public function searchUsersByLocation($query) { $sql = "SELECT u.id,u.first_name,u.last_name ,u.phone ,GROUP_CONCAT(p.name) as speciality " . "FROM `users` u " . "INNER JOIN `users_profiles` up ON u.id = up.users_id " . "INNER JOIN profiles p ON up.profiles_id = p.id " . "WHERE city LIKE :query OR country LIKE :query OR address LIKE :query " . "GROUP BY u.id"; $profiles = \R::getAll($sql, array(':query' => "%{$query}%")); $objServerInfo = new \services\helpers\ServerInfo(); $usersProfiles = array(); foreach ($profiles as $profile) { $profilepic = $objServerInfo->getScheme() . "://" . $objServerInfo->getHost() . APPLICATION_BASE . 'images/' . $profile['id'] . '_pp.jpg'; $picPath = APPLICATION_DIR . "/images/{$profile['id']}_pp.jpg"; $profile['profilepic'] = @is_file($picPath) ? $profilepic : null; $profile['speciality'] = explode(",", $profile['speciality']); $usersProfiles[] = $profile; } return $usersProfiles; }
/** * Public function to get nearby events * @param string $longitude longitude of current user location * @param string $latitude latitude of current user location * @return array * **/ public function getEventNearbyEvents($longitude, $latitude) { $qry = "SELECT e.*,(((acos(sin((:lat*pi()/180)) * \r\n sin((e.`Latitude`*pi()/180))+cos((:lat*pi()/180)) * \r\n cos((e.`Latitude`*pi()/180)) * cos(((:long- e.`Longitude`)* \r\n pi()/180))))*180/pi())*60*1.1515\r\n ) as distance ,u.first_name,u.last_name,u.id as userid,\r\n COUNT( IF( upe.participation_id = 1, 1, NULL ) ) as num_users_psyes,COUNT( IF( upe.participation_id = 3, 1, NULL ) )as num_users_psmaybe\r\n FROM `events` e\r\n INNER JOIN users u on u.id = e.users_id\r\n LEFT JOIN `users_events_participation` upe ON upe.events_id = e.id\r\n GROUP BY e.id\r\n HAVING distance <= 19 ORDER BY distance"; // distance in miles 30 kms $rowset = \R::getAll($qry, array(':lat' => $latitude, ':long' => $longitude)); $return = array(); $objServerInfo = new \services\helpers\ServerInfo(); if ($rowset) { foreach ($rowset as $row) { unset($row['status']); unset($row['users_id']); unset($row['distance']); $profileUrl = $objServerInfo->getScheme() . "://" . $objServerInfo->getHost() . '/images/' . $row['userid'] . "_pp.jpg"; $profilePic = @getimagesize($profileUrl) ? $profileUrl : null; $row['profilepic'] = $profilePic; $return[] = $row; } } return $return; }
/** * Function to get dogs owned by user * @param int $userId id of the user * @return array * **/ public function getUserOwnedDogs($userId) { $query = "SELECT d.id as dogid,dog_pic,name,gender,date_of_birth,dog_breed_id,db.breed_name " . "FROM dogs d " . "INNER JOIN dog_breed db ON db.id = d.dog_breed_id " . "WHERE users_id = :userid"; $userOwnedDogs = \R::getAll($query, array(':userid' => $userId)); $return = array(); $objServerInfo = new \services\helpers\ServerInfo(); foreach ($userOwnedDogs as $dog) { $dogUrl = $objServerInfo->getScheme() . "://" . $objServerInfo->getHost() . APPLICATION_BASE . 'dogimages/' . $dog['dog_pic']; $picPath = APPLICATION_DIR . "/dogimages/{$dog['dog_pic']}"; $dog['dog_pic'] = @is_file($picPath) ? $dogUrl : null; $return[] = $dog; } return $return; }