function load($id)
{
parent::load($id);
$rs = $this->db->execute($s = Query::generateSelectStm(array($this->table), array(), array(new WhereConstraint($this->table->getColumn(DB::COMMENT_ID), Operator::EQUAL, intval($id))), array()));
if ($this->db->num_rows() != 1) {
throw new Exception("L'oggetto cercato non è stato trovato.");
}
$row = $this->db->fetch_result();
$c = new Comment($row[DB::COMMENT_COMMENT], intval($row[DB::COMMENT_POST]), intval($row[DB::COMMENT_AUTHOR]));
$c->setID(intval($row[DB::COMMENT_ID]))->setCreationDate(date_timestamp_get(date_create_from_format("Y-m-d G:i:s", $row[DB::COMMENT_CREATION_DATE])));
if ($this->loadReports && AuthorizationManager::canUserDo(AuthorizationManager::READ_REPORTS, $c)) {
require_once 'dao/ReportDao.php';
$redao = new ReportDao();
$redao->loadAll($c);
}
return $c;
}
private function createFromDBRow($row)
{
$r = new Resource($row[DB::RESOURCE_OWNER], $row[DB::RESOURCE_PATH], $row[DB::RESOURCE_TYPE]);
$r->setID($row[DB::RESOURCE_ID]);
$r->setDescription($row[DB::RESOURCE_DESCRIPTION])->setCreationDate($row[DB::RESOURCE_CREATION_DATE])->setTags($row[DB::RESOURCE_TAGS]);
if (!is_null($row[DB::RESOURCE_MODIFICATION_DATE])) {
$mod = $row[DB::RESOURCE_MODIFICATION_DATE];
} else {
$mod = $row[DB::RESOURCE_CREATION_DATE];
}
$r->setModificationDate(date_timestamp_get(date_create_from_format("Y-m-d G:i:s", $mod)));
//setto lo stato
$r->setEditable($row[DB::EDITABLE])->setRemovable($row[DB::REMOVABLE]);
$r->setBlackContent($row[DB::BLACK_CONTENT])->setRedContent($row[DB::RED_CONTENT])->setYellowContent($row[DB::YELLOW_CONTENT])->setAutoBlackContent($row[DB::AUTO_BLACK_CONTENT]);
$user = Session::getUser();
if ($this->loadReports && AuthorizationManager::canUserDo(AuthorizationManager::READ_REPORTS, $r)) {
require_once 'dao/ReportDao.php';
$reportDao = new ReportDao();
$reportDao->loadAll($r);
}
//$r->setAccessCount($this->getAccessCount($r));
return $r;
}
private function createFromDBRow($row)
{
$user = new User($row[DB::USER_NICKNAME], $row[DB::USER_E_MAIL], $row[DB::USER_PASSWORD]);
$user->setName($row[DB::USER_NAME])->setSurname($row[DB::USER_SURNAME])->setGender($row[DB::USER_GENDER]);
if (!is_null($row[DB::USER_BIRTHDAY])) {
$user->setBirthday(date_timestamp_get(date_create_from_format("Y-m-d G:i:s", $row[DB::USER_BIRTHDAY])));
}
$user->setBirthplace($row[DB::USER_BIRTHPLACE])->setLivingPlace($row[DB::USER_LIVINGPLACE])->setHobbies($row[DB::USER_HOBBIES])->setJob($row[DB::USER_JOB])->setRole($row[DB::USER_ROLE])->setVisible($row[DB::USER_VISIBLE])->setID(intval($row[DB::USER_ID]))->setCreationDate(date_timestamp_get(date_create_from_format("Y-m-d G:i:s", $row[DB::USER_CREATION_DATE])))->setVerified($row[DB::USER_VERIFIED]);
try {
require_once "dao/ResourceDao.php";
$resourceDao = new ResourceDao();
$user->setAvatar($resourceDao->quickLoad($row[DB::USER_AVATAR]));
} catch (Exception $e) {
// try {
// $user->setAvatar($resourceDao->quickLoad(EMPTY_AVATAR));
// } catch (Exception $e1) {
// //DEBUG da togliere più avanti, quando ci saranno le immagini.
// }
}
if ($this->loadDependences) {
require_once "dao/ContactDao.php";
$contactDao = new ContactDao();
$contactDao->loadAll($user);
require_once "dao/FollowDao.php";
$followDao = new FollowDao();
$followDao->loadAllFollowers($user);
$followDao->loadAllFollows($user);
require_once "dao/FeedbackDao.php";
$feedbackDao = new FeedbackDao();
$feedbackDao->loadAll($user);
}
if ($this->loadReports && AuthorizationManager::canUserDo(AuthorizationManager::READ_REPORTS, $user)) {
require_once 'dao/ReportDao.php';
$reportDao = new ReportDao();
$reportDao->loadAll($user);
}
//setto lo stato
$user->setEditable($row[DB::EDITABLE])->setRemovable($row[DB::REMOVABLE]);
$user->setBlackContent($row[DB::BLACK_CONTENT])->setRedContent($row[DB::RED_CONTENT])->setYellowContent($row[DB::YELLOW_CONTENT])->setAutoBlackContent($row[DB::AUTO_BLACK_CONTENT]);
if ($this->loadAccessCount) {
$user->setAccessCount($this->getAccessCount($user));
}
return $user;
}
function createFromDBRow($row)
{
$type = $row[DB::POST_TYPE];
if ($type == Post::NEWS || $type == Post::VIDEOREP) {
$content = $row[DB::POST_CONTENT];
} else {
$content = unserialize($row[DB::POST_CONTENT]);
}
$data = array("title" => $row[DB::POST_TITLE], "subtitle" => $row[DB::POST_SUBTITLE], "headline" => $row[DB::POST_HEADLINE], "author" => intval($row[DB::POST_AUTHOR]), "tags" => $row[DB::POST_TAGS], "categories" => $row[DB::POST_CATEGORIES], "content" => $content, "visible" => $row[DB::POST_VISIBLE] > 0, "type" => $type, "place" => $row[DB::POST_PLACE]);
if ($type == Post::NEWS) {
require_once "dataobject/News.php";
$p = new News($data);
} else {
if ($type == Post::VIDEOREP) {
require_once "dataobject/VideoReportage.php";
$p = new VideoReportage($data);
} else {
if ($type == Post::ALBUM) {
require_once "dataobject/Album.php";
$p = new Album($data);
} else {
if ($type == Post::MAGAZINE) {
require_once "dataobject/Magazine.php";
$p = new Magazine($data);
} else {
if ($type == Post::PHOTOREP) {
require_once "dataobject/PhotoReportage.php";
$p = new PhotoReportage($data);
} else {
if ($type == Post::PLAYLIST) {
require_once "dataobject/Playlist.php";
$p = new Playlist($data);
} else {
if ($type == Post::COLLECTION) {
require_once "dataobject/Collection.php";
$p = new Collection($data);
} else {
throw new Exception("Errore!!! Il tipo inserito non esiste!");
}
}
}
}
}
}
}
$p->setCreationDate(date_timestamp_get(date_create_from_format("Y-m-d G:i:s", $row[DB::POST_CREATION_DATE])));
$p->setID(intval($row[DB::POST_ID]));
if (!is_null($row[DB::POST_MODIFICATION_DATE])) {
$p->setModificationDate(date_timestamp_get(date_create_from_format("Y-m-d G:i:s", $row[DB::POST_MODIFICATION_DATE])));
} else {
$p->setModificationDate(date_timestamp_get(date_create_from_format("Y-m-d G:i:s", $row[DB::POST_CREATION_DATE])));
}
if ($this->loadComments) {
require_once 'dao/CommentDao.php';
$commentDao = new CommentDao();
$commentDao->loadAll($p);
}
$p->setPermalink($row[DB::POST_PERMALINK]);
require_once 'dao/VoteDao.php';
$voteDao = new VoteDao();
$p->setVote($voteDao->getVote($p));
//setto lo stato
$p->setEditable($row[DB::EDITABLE])->setRemovable($row[DB::REMOVABLE]);
$p->setBlackContent($row[DB::BLACK_CONTENT])->setRedContent($row[DB::RED_CONTENT])->setYellowContent($row[DB::YELLOW_CONTENT])->setAutoBlackContent($row[DB::AUTO_BLACK_CONTENT]);
$user = Session::getUser();
if ($this->loadReports && AuthorizationManager::canUserDo(AuthorizationManager::READ_REPORTS, $r)) {
require_once 'dao/ReportDao.php';
$reportDao = new ReportDao();
$reportDao->loadAll($p);
}
$p->setAccessCount($this->getAccessCount($p));
return $p;
}
/**
* Aggiunge un report al commento selezionato e lo salva nel database.
*
* @param $author: id dell'autore del commento
* @param $comment: variabile di tipo Comment
* @param $report: testo del report
* @return: commento aggiornato.
*/
static function reportComment($author, $comment, $report)
{
$report = Filter::filterText($report);
require_once "dao/ReportDao.php";
require_once "dataobject/Report.php";
$r = new Report($author, $comment, $report);
$reportDao = new ReportDao();
return $reportDao->save($r);
}
