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); }