public function getAllUsers() { $query = "SELECT ut.*, pht.*, pt.* FROM " . USER_TABLE . " ut, " . PHOTO_TABLE . " pht, sat_person pt WHERE ut.userid = pt.personid AND ut.PROFILEPHOTO = pht.PHOTOID and ut.role <> 'ADMIN' "; try { $this->userAutentication(); $objectArray = $this->getDB()->execQuery($query); if (is_null($objectArray)) { return NULL; } else { $objectListDTO = DataModelUtils::getObjectList(PERSONDTO, $objectArray); return $objectListDTO; } } catch (PDOException $pdoe) { throw $pdoe; } catch (Exception $e) { throw $e; } }
public function getUserAlbumList($userId) { $query = "SELECT at.*, pht.* from sat_album at, sat_photo pht WHERE " . " at.COVER = pht.PHOTOID AND " . " at.owner = {$userId} order by at.albumid desc"; try { $this->userAutentication(); $objectArray = $this->getDB()->execQuery($query); if (is_null($objectArray)) { return NULL; } else { $objectListDTO = DataModelUtils::getObjectList(ALBUMDTO, $objectArray); return $objectListDTO; } } catch (PDOException $pdoe) { throw $pdoe; } catch (UserNotAuthenticatedExceptionDTO $authExp) { throw $authExp; } catch (Exception $e) { throw $e; } }
public function getUnreadNotificationList($limit = NULL) { $userLogged = SessionUtils::getUserLogged(); if (is_null($limit)) { $query = "select * from sat_notify where SUBJECT_ID = " . $userLogged->getUserId() . " and IS_READ = 0 order by sent_at desc "; } else { $query = "select * from sat_notify where SUBJECT_ID = " . $userLogged->getUserId() . " and IS_READ = 0 order by sent_at desc "; } try { $objectArray = $this->getDB()->execQuery($query); if (is_null($objectArray)) { return NULL; } else { $objectListDTO = DataModelUtils::getObjectList(NOTIFICATIONDTO, $objectArray); return $objectListDTO; } } catch (PDOException $pdoe) { throw $pdoe; } catch (Exception $e) { throw $e; } }
public function getCommentListByPostId($postId) { $query = "select ct.*,ut.*,pht.* " . " from sat_comment ct, sat_user ut, sat_photo pht " . " where ct.postid = {$postId} and ct.authorid = ut.userid and ut.profilephoto = pht.photoid order by ct.date desc"; try { $this->userAutentication(); $objectArray = $this->getDB()->execQuery($query); if (is_null($objectArray)) { return NULL; } else { $objectListDTO = DataModelUtils::getObjectList(COMMENTDTO, $objectArray); return $objectListDTO; } } catch (PDOException $pdoe) { throw $pdoe; } catch (UserNotAuthenticatedExceptionDTO $authExp) { throw $authExp; } catch (Exception $e) { throw $e; } }
public function getFriendsList($userProfile) { if (!SessionUtils::isAdmin()) { $query = "select ut.*, pt.*, tmp.FRIENDSSINCE \n from sat_user ut, sat_photo pt, ( \n select FRIENDID as USERID,FRIENDSSINCE \n from sat_user_friends \n where USERID = {$userProfile} \n UNION \n select USERID, FRIENDSSINCE \n from sat_user_friends \n where FRIENDID = {$userProfile} \n ) tmp \n where ut.profilephoto = pt.photoid and tmp.USERID = ut.USERID"; } else { $query = "select distinct ut.*, pt.*, NULL AS FRIENDSSINCE from sat_user ut, sat_photo pt where ut.role <> 'ADMIN' and ut.profilephoto = pt.photoid "; } try { $this->userAutentication(); $objectArray = $this->getDB()->execQuery($query); if (is_null($objectArray)) { return NULL; } else { $objectListDTO = DataModelUtils::getObjectList(FRIENDSDTO, $objectArray); return $objectListDTO; } } catch (PDOException $pdoe) { throw $pdoe; } catch (Exception $e) { throw $e; } }
public function getUserInfoByCriteria($formDataObj) { $query = ""; $userLogged = SessionUtils::getUserLogged(); if ($formDataObj[SEARCH_USER_FORM . CRITERIA] === USERNAME) { $query = "select ut.*, pht.*\n from sat_user ut, sat_photo pht\n where ut.username like '%" . $formDataObj[SEARCH_USER_FORM . TARGET] . "%'\n and ut.userid <> " . $userLogged->getUserId() . " \n and ut.userid <> 1 \n and ut.profilephoto = pht.photoid"; } else { if ($formDataObj[SEARCH_USER_FORM . CRITERIA] === EMAIL) { $query = "select ut.*, pht.*\n from sat_user ut, sat_photo pht\n where ut.email like '%" . $formDataObj[SEARCH_USER_FORM . TARGET] . "%'\n and ut.userid <> " . $userLogged->getUserId() . " \n and ut.userid <> 1 \n and ut.profilephoto = pht.photoid"; } } try { $this->userAutentication(); $objectArray = $this->getDB()->execQuery($query); if (is_null($objectArray)) { return NULL; } else { for ($i = 0; $i < sizeof($objectArray); $i++) { $friendid = $objectArray[$i][strtoupper(USERID)]; $internalQuery = "select friendssince \n from sat_user_friends\n where userid = " . $friendid . " and friendid = " . $userLogged->getUserId() . "\n or friendid = " . $friendid . " and userid = " . $userLogged->getUserId(); $friendsSince = $this->getDB()->execQuery($internalQuery); if (!is_null($friendsSince)) { $friendsSince = $friendsSince[0][FRIENDSSINCE]; } $objectArray[$i][strtoupper(FRIENDSSINCE)] = $friendsSince; } return DataModelUtils::getObjectList(FRIENDSDTO, $objectArray); } } catch (UserNotAuthenticatedExceptionDTO $authExp) { throw $authExp; } catch (PDOException $pdoe) { throw $pdoe; } catch (Exception $e) { throw $e; } }
public function getAllUserPhotos($userId) { $query = "SELECT pt.* from " . USER_PHOTO_ALBUMS_TABLE . " upat, sat_photo pt where upat.USERID = {$userId} and upat.PHOTOID = pt.PHOTOID"; try { $this->userAutentication(); $objectArray = $this->getDB()->execQuery($query); if (is_null($objectArray)) { return NULL; } else { $objectListDTO = DataModelUtils::getObjectList(PHOTODTO, $objectArray); return $objectListDTO; } } catch (PDOException $pdoe) { throw $pdoe; } catch (UserNotAuthenticatedExceptionDTO $authExp) { throw $authExp; } catch (Exception $e) { throw $e; } }