/**
*
* @param PCRequest $request
* @param PCModelApplication $application
* @return bool
*/
public function doLogin($request, $application)
{
$param = $request->getParams();
$userName = $param['uname'];
$pwd = $param['pwd'];
$keys = array('username' => $userName, "account_type" => PCModelUser::$TYPE_DEFAULT);
$user_array = PCModelManager::fetchModelObjectInstances(PCModelUser::getMapper(), $keys, NULL, TRUE);
$user = $user_array[0];
if (isset($user) && strcmp($pwd, $user->getPassword()) == 0) {
$secret = $application->getAppSecret();
$appId = $application->getIdentifier();
$time = time();
$cookieValue = PCAuth::computeHashForString($userName . $time . $secret);
$distantFuture = PCResponseCookie::getDistantFuture();
if (PCMapperToken::setTokenForUserWithIdentifier($user->getIdentifier(), $appId, $cookieValue, $distantFuture)) {
$_SESSION['user'] = $this->user_id = $user->getIdentifier();
$presence_cookie = PCResponseCookie::lifetimeCookie("presence_c", $cookieValue);
//setcookie("presence_c", $cookieValue, $expirationTime,"/");
$user_cookie = PCResponseCookie::lifetimeCookie("user", $user->getIdentifier());
//setcookie("user",$user->getIdentifier(), $expirationTime,"/");
$response = PCResponse::currentResponse();
$response->addCookie($presence_cookie);
$response->addCookie($user_cookie);
} else {
return FALSE;
}
return TRUE;
}
return FALSE;
}
/**
* Elimina il token relativo ad un certo utente e applicazione
* @param string $user_id l'id dell' utente
* @param string $app_id l'id dell' app
* @return boolean
*/
public static function removeTokenForUser($user_id, $app_id){
$conditions = "user_identifier = :user AND app_identifier = :app";
$bindings = array(":user" => $user_id, ":app"=> $app_id );
return PCModelManager::deleteObject(PCModelToken::getMapper(), $conditions, $bindings);
}
/**
*
* @param PCRequest $request
* @param PCAuthCookiesAdapter $adapter
*/
public function __construct($request, $adapter = NULL) {
parent::__construct($request);
$this->adapter = ($adapter == NULL ? new PCAuthDefaultCookiesAdapter() : $adapter);
$this->application = PCModelManager::fetchObjectWithIdentifier(PCModelApplication::getMapper(), PCModelApplication::WEBSITE_APP_ID, NULL, TRUE);
$this->setupSession();
$this->authorize();
}
/**
*
* @param string $userId
* @param string $reviewId
* @param string $text
* @return bool
*/
public static function createReport($userId, $reviewId, $text){
$dateAdded = new DateTime('now', new DateTimeZone('UTC'));
$values = array(
'user_identifier'=> $userId,
"review_identifier"=>$reviewId,
'text'=>$text ,
"date_added"=>$dateAdded->format('Y-m-d H:i:s')
);
return PCModelManager::insertObject(PCModelReport::getMapper(), $values);
}
/**
* Returns TRUE if the category exists
* @param string $identifier
* @retrun bool
*/
public static function existsCategoryWithIdentifier($identifier){
$category = PCModelManager::fetchObjectWithIdentifier(PCModelCategory::getMapper(), $identifier, NULL, TRUE);
return isset($category);
}
/**
* @param PCRequest $request
*/
public function facebookCallbackAction($request) {
PCAutoloader::importLibrary('facebook');
$facebook = new Facebook(array(
"appId" => FB_APP_ID,
"secret" => FB_APP_SECRET,
"cookie" => true
));
$params = $request->getParams();
$user_profile = NULL;
try {
$user = $facebook->getUser();
if (isset($user)) {
$user_profile = $facebook->api('/me');
}
} catch (FacebookApiException $e) {
c_dump($_GET);
error_log("AAAA".$e);
throw new PCExceptionRedirection("/page/register");
}
if (isset($params['reg_username'])){
if (PCMapperUser::validateUsername($params['reg_username']) == FALSE) {
$cont = array("title" => "WebSherpa - Insert Username", "text_error" => "Insert a valid Username; min 6 characters use only characters and numbers and \"_\"", "show_email" => TRUE);
return PCRendererHTML::rendererForView('insertUname', $cont);
}
if (count(PCModelManager::fetchModelObjectInstances(PCModelUser::getMapper(), array("username" => $params['reg_username']))) != 0) {
$cont = array("title" => "WebSherpa - Insert Username", "text_error" => "Username already used, please choose another username.", "show_email" => TRUE);
return PCRendererHTML::rendererForView('insertUname', $cont);
}
$adapter = new PCHelperSocialAdapterFacebook($facebook, $user_profile, $params['reg_username']);
if($request->getAuthHandler()->authorizeOauthUser($adapter)){
throw new PCExceptionRedirection("/");
}
throw new PCExceptionRedirection("/page/register");
}
else{
$adapter = new PCHelperSocialAdapterFacebook($facebook, $user_profile);
if($request->getAuthHandler()->authorizeOauthUser($adapter) === FALSE){
return PCRendererHTML::rendererForView('insertUname', array("title" => "WebSherpa - Insert Username"));
}
throw new PCExceptionRedirection("/");
}
}
public function __construct($request) {
$this->request = $request;
$this->application = PCModelManager::fetchObjectWithIdentifier(PCModelApplication::getMapper(), PCModelApplication::WEBSITE_APP_ID, NULL, TRUE);
$this->setupSession();
}
/**
*
* @param string $user
* @param int $offset
* @return array
*/
public static function getReviewsWithUserIdentifier($user, $offset){
$offset = (int)$offset;
if($offset<0){
return NULL;
}
$keys = array('user_identifier' => $user);
//$elementsToReturn = 10;
$elementsToReturn = PCConfigManager::sharedManager()->getIntegerValue('REVIEWS_PER_CALL');
$limit = ($offset*$elementsToReturn)." , ".$elementsToReturn." ";
$elements = PCModelManager::fetchModelObjectInstances(PCModelReview::getMapper(), $keys, NULL, FALSE, $limit);
return $elements;
}
/**
* @param $identifier string
*/
public function withIdentifier($identifier, $optional_attributes = null, $use_cache = FALSE){
return PCModelManager::fetchModelObjectInstances($this, array("identifier"=>$identifier), $optional_attributes, $use_cache);
}
/**
* XXX evitare utilizzo diretto del database
* @param array $attributes
* @param string $error
* @return boolean
*/
public static function createUserWithAttributes($attributes, &$error) {
$username = $attributes['username'];
$name = $attributes['name'];
$surname = $attributes['surname'];
$email = $attributes['email'];
$password = $attributes['password'];
if (static::validateName($name) == false) {
$error = "Invalid name";
return false;
}
if (static::validateSurname($surname) == false) {
$error = "Invalid surname";
return false;
}
if (static::validateUsername($username) == FALSE) {
$error = "username is not valid (min 5, max 20 chars)";
return false;
}
if (static::validateMail($email) == FALSE) {
$error = "email already registered";
return FALSE;
}
$mapper = PCModelUser::getMapper();
$pdo = PCDatabase::getSharedDatabaseConnection();
$select = "SELECT username ,email FROM " . $mapper->getTableForInsertUpdate() . " WHERE (username = :uname OR email = :mail) AND account_type = :type;";
$prepared = $pdo->prepare($select);
if ($prepared === FALSE) {
c_dump($prepared->errorInfo());
return FALSE;
}
$result = $prepared->execute(array(':uname' => $username, ':mail' => $email, ':type' => PCModelUser::$TYPE_DEFAULT));
if ($result === FALSE) {
ob_start();
print_r($prepared->errorInfo());
$prepared->debugDumpParams();
$contents = ob_get_contents();
ob_end_clean();
error_log($contents);
return FALSE;
}
while ($item = $prepared->fetch(PDO::FETCH_ASSOC)) {
if (strcmp($item['email'], $email) == 0) {
$error = "email already registered";
return FALSE;
} else if (strcmp($item['username'], $username) == 0) {
$error = "username already registered";
return FALSE;
}
}
$date = new DateTime('now', new DateTimeZone('UTC'));
$keys = array(
'creation_date' => $date->format('Y-m-d H:i:s'),
'username' => $username,
'penalities' => '0',
'surname' => $surname,
'name' => $name,
'email' => $email,
'password' => $password
);
return PCModelManager::insertObject($mapper, $keys);
}
/**
* Crea una nuova password(aggiorna il db) e la restituisce. restituisce false in caso negativo
* @param PCModelUser $user_id l' id dell' utente
* @param string $hash l' hash inviato dall'utente
* @param PCModelUser
* @return boolean|string
*/
public static function handleRepassRequest($user_id, $hash, &$user_to_ret) {
$keys = array('request_hash'=>$hash, 'user_id'=>$user_id);
$items = PCModelManager::fetchModelObjectInstances(PCModelRepass::getMapper(), $keys, NULL, TRUE);
if (count($items) <= 0) {
return FALSE;
}
$item = $items[0];
if ($item == NULL || $item->isExpired()) {
c_dump("SCADUTA");
return FALSE;
}
$bindigngs = array(":h" => $hash, ":user"=> $user_id);
PCModelManager::deleteObject(PCModelRepass::getMapper(), "request_hash = :h AND user_id = :user", $bindigngs);
$newPwd = PCMapperRepass::rand_password(8);
$model_user = PCModelManager::fetchObjectWithIdentifier(PCModelUser::getMapper(), $item->getUser_id(), NULL, TRUE);
if($model_user == NULL){
$id = $item->getUser_id();
error_log("User non presente (user_id: $id )");
return FALSE;
}
$newPwdHash = PCAuth::computeHashForString($newPwd);
if(PCMapperUser::changePasswordForUser($model_user, $newPwdHash) == FALSE){
return FALSE;
}
$user_to_ret = $model_user;
return $newPwd;
}
/**
* Restituisce l'utente connesso attualmente (se disponibile)
* @return ModelUser
*/
public static function getCurrentUser(){
if(static::$current_user != NULL) return static::$current_user;
if(isset(static::$current_user_identifier)){
$user = PCModelManager::fetchObjectWithIdentifier(PCModelUser::getMapper(), static::$current_user_identifier, NULL, TRUE);
static::$current_user = $user;
return $user;
}
return NULL;
}
/**
*
* @param PCRequest $request
*/
public function siteAction($request) {
$param = $request->getParams();
$hostName = $request->dequeuePathComponent();
if (isset($hostName)) {
$site = PCMapperWebsite::getSiteWithDomain($hostName);
if (isset($site) == FALSE) {
throw new PCExceptionController("Page not found", 404);
}
$identifier = $site->getIdentifier();
throw new PCExceptionRedirection("/sites/site?id=$identifier");
}
if (isset($param['id']) == FALSE)
throw new PCExceptionController("Page not found", 404);
/** @value PCModelWebsite $site */
$site = PCModelManager::fetchObjectWithIdentifier(PCModelWebsite::getMapper(), $param['id'], NULL, TRUE);
if (!isset($site)) {
throw new PCExceptionController("Page not found", 404);
}
if ($site->cacheIsExpired()) {
$site = PCMapperWebsite::recacheSiteReview($site);
if (isset($site) == FALSE) {
throw new PCExceptionController('Error caching', 500);
}
}
$result = array();
$result['siteCategory'] = PCMapperCategory::nameFromIdentifier($site->getCategory());
$result['site_id'] = $site->getIdentifier();
$result['siteHost'] = $site->getUrl();
$result['reliability'] = $site->getReliability();
$result['contents'] = $site->getContents();
$result['usability'] = $site->getUsability();
$result['averageVote'] = $site->getVote();
$result['votesCount'] = $site->getNumber_of_votes();
$result['dateAdded'] = $site->getDate_added()->format("Y-m-d");
$reviews = PCMapperReview::getReviewsWithSiteIdentifier($site->getIdentifier(), 0);
$reviewsList = array();
foreach ($reviews as $r) {
$reviewArray = array();
$reviewArray["vote"] = sprintf("%.1f", $r->getVote());
$user = PCModelManager::fetchObjectWithIdentifier(PCModelUser::getMapper(), $r->getUserIdentifier(), NULL, TRUE);
$reviewArray["user"] = $user->getUsername();
$reviewArray["date_added"] = $r->getDate_added()->format("Y-m-d");
$reviewArray["comment"] = $r->getComment();
$reviewArray["reviewId"] = $r->getIdentifier();
$reviewArray["userId"] = $r->getUserIdentifier();
$reviewArray['reliability'] = sprintf("%.1f", $r->getReliabilityVote());
$reviewArray['contents'] = sprintf("%.1f", $r->getContentsVote());
$reviewArray['usability'] = sprintf("%.1f", $r->getUsabilityVote());
$reviewsList[] = $reviewArray;
}
$result['reviews'] = $reviewsList;
$result['title'] = "WebSherpa - " . $site->getUrl();
return PCRendererHTML::rendererForView('host', $result);
}
/**
*
* @param string $user_identifier
* @param int $service il codice servizio (es Facebook o Twitter)
* @return array
*/
public static function getOauthConfig($user_identifier, $service ){
$val = array(
"user_identifier" => $user_identifier,
"oauth_provider" => $service
);
$inst = PCModelManager::fetchModelObjectInstances(PCModelUserOauth::getMapper(), $val);
if(count($inst) == 0 ) return NULL;
return $inst[0];
}
/**
* @XXX remove direct database interaction
* @param PCModelWebsite $site
*/
public static function recacheSiteReview($site)
{
//error_log('RECACHING SITE INFO: '.$site->getIdentifier());
$select = "SELECT avg(usability) as usability, avg(reliability) as reliability,";
$select .= " avg(contents) as contents, count(identifier) as count ";
$mapper = PCModelReview::getMapper();
$select .= " FROM " . $mapper->getTableName() . " WHERE site_identifier = :id";
$pdo = PCDatabase::getSharedDatabaseConnection();
$prepared = $pdo->prepare($select);
$result = $prepared->execute(array(":id" => $site->getIdentifier()));
if ($result === FALSE) {
return NULL;
}
$item = $prepared->fetch(PDO::FETCH_ASSOC);
if (!isset($item)) {
return NULL;
}
$usability = (double) $item['usability'];
$reliability = (double) $item['reliability'];
$contents = (double) $item['contents'];
$count = (double) $item['count'];
$cache_time = new DateTime('now', new DateTimeZone('UTC'));
$keys = array('usability' => $usability, 'reliability' => $reliability, 'contents' => $contents, 'number_of_votes' => $count, 'cached' => $cache_time->format('Y-m-d H:i:s'));
$condition = "identifier = :id";
$bindings = array(':id' => $site->getIdentifier());
$websiteMapper = PCModelWebsite::getMapper();
if (PCModelManager::updateObject($websiteMapper, $keys, $condition, $bindings)) {
$site->cached_date = $cache_time;
$site->contents = $contents;
$site->number_of_votes = $count;
$site->reliability = $reliability;
$site->usability = $usability;
PCCache::cacheProvider()->setItem($site, $websiteMapper->getTableName() . $site->getIdentifier());
return $site;
}
return NULL;
}
/**
* Restituisce le recensioni legate ad un sito oppure ad un utente
* @param PCRequest $request
*/
public function getSiteReviewsAction($request) {
$params = $request->getParams();
if( isset($params['offset']) == FALSE) return new PCRendererJSON(array("error" => "missing param 'offset'"), 400);
$offset = $params['offset'];
if( isset($params['site_id'])){
$site_id = $params['site_id'];
$result = array();
$reviews = PCMapperReview::getReviewsWithSiteIdentifier($site_id, $offset);
foreach ($reviews as $r) {
$tmp = array();
$tmp["vote"] = sprintf("%.1f", $r->getVote());
//XXX pensare ad un modo più efficente per risolvere gli identificativi
$user = PCModelManager::fetchObjectWithIdentifier(PCModelUser::getMapper(), $r->getUserIdentifier(), NULL, TRUE);
$tmp["user"] = $user->getUsername();
$tmp["date_added"] = $r->getDate_added()->format("Y-m-d");
$tmp["comment"] = $r->getComment();
$tmp["reviewId"] = $r->getIdentifier();
$tmp["userId"] = $user->getIdentifier();
$tmp['reliability'] = sprintf("%.1f", $r->getReliabilityVote());
$tmp['contents'] = sprintf("%.1f", $r->getContentsVote());
$tmp['usability'] = sprintf("%.1f", $r->getUsabilityVote());
$result[] = $tmp;
}
return new PCRendererJSON($result);
}
if (isset($params['user_id'])) {
$user_id = $params['user_id'];
$result = array();
$user = PCModelManager::fetchObjectWithIdentifier(PCModelUser::getMapper(), $user_id, NULL, TRUE);
if (!isset($user))
new PCRendererJSON(array("error" => "wrong user identifier"), 400);
// $user_name = $user->getUsername();
$reviews = PCMapperReview::getReviewsWithUserIdentifier($user_id, $offset);
foreach ($reviews as $r) {
$tmp = array();
//XXX pensare ad un modo più efficente per risolvere gli identificativi
$site = PCModelManager::fetchObjectWithIdentifier(PCModelWebsite::getMapper(), $r->getSiteIdentifier(), NULL, TRUE);
$tmp["vote"] = sprintf("%.1f",$r->getVote());
$tmp["site"] = $site->getDomain();
$tmp["date_added"] = $r->getDate_added()->format("Y-m-d");
$tmp["comment"] = $r->getComment();
$tmp["reviewId"] = $r->getIdentifier();
$tmp["siteId"] = $site->getIdentifier();
$tmp['reliability'] = sprintf("%.1f",$r->getReliabilityVote());
$tmp['contents'] = sprintf("%.1f",$r->getContentsVote());
$tmp['usability'] = sprintf("%.1f",$r->getUsabilityVote());
$result[] = $tmp;
}
return new PCRendererJSON($result);
}
return new PCRendererJSON(array("error" => "missing param 'site_id' or 'user_id"), 400);
}
