/** * Returns the topics table as a presentation model (array of arrays containing * information about each topic, suitable for use by a view) by mirroring * the domain model into a presentation model. The presentation model can be modified * to support the needs of a view, without mangling the raw, real underlying table data. * STAGE 4: Apply business logic to create a presentation model for the view. * @return array of ArrayObjects (containing topic info) indexed by topic id */ public static function getPresentationModel() { if (self::$_presentationModel === null) { foreach (self::getDomainModel() as $row) { $row = new ArrayObject($row->toArray(), ArrayObject::ARRAY_AS_PROPS); $row->user = ZFDemoModel_Users::getById($row->user_id); self::$_presentationModel[$row->topic_id] = $row; ///////////////////////////// // ==> SECTION: l10n <== // create a Locale object for the owner of this post (not the user of this request) $postLocale = new Zend_Locale($row->user->locale); $row->country = ZFModule_Forum::getCountry($postLocale->getRegion()); $userLocale = ZFModule_Forum::getUserLocale(); // locale of the user of this request $userLocale = Zend_Registry::get('userLocale'); $offset = ZFModule_Forum::getTimeOffset(); if ($row->modification_time != $row->creation_time) { $row->modification_time = new Zend_Date($row->modification_time, $userLocale); $row->modification_time->addTimestamp($offset); // express date/time in user's local timezone } else { $row->modification_time = ''; } $row->creation_time = new Zend_Date($row->creation_time, $userLocale); $row->creation_time->addTimestamp($offset); // express date/time in user's local timezone } } return self::$_presentationModel; }
/** * Create a cached set of sets of posts, grouped by topic. * Only one set of posts are created for one topic ($topicId) per invocation. * Cached information lasts only for the duration of this request. */ public static function getPostsByTopicId($topicId) { static $stmt = null; if (!isset(self::$_posts[$topicId])) { $db = Zend_Registry::get('db'); if ($stmt === null) { $q = 'SELECT * FROM posts WHERE topic_id = ? ORDER BY creation_time ASC'; $stmt = $db->prepare($q); if ($stmt === false) { throw new ZFDemo_Exception("Preparing query '{$q}' failed.", 500); } } $stmt->execute(array(intval($topicId))); $posts = array(); foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) { $row = new ArrayObject($row, ArrayObject::ARRAY_AS_PROPS); if ($row->modification_time != $row->creation_time) { $row->modification_time = new Zend_Date($row->modification_time, Zend_Date::ISO_8601); } else { $row->modification_time = ''; } $row->country = ''; $row->creation_time = new Zend_Date($row->creation_time, Zend_Date::ISO_8601); $row->user = ZFDemoModel_Users::getById($row->user_id); $posts[] = $row; } $stmt->closeCursor(); self::$_posts[$topicId] = $posts; } return self::$_posts[$topicId]; }
/** * Returns the topics table as a presentation model (array of arrays containing * information about each topic, suitable for use by a view) by mirroring * the domain model into a presentation model. The presentation model can be modified * to support the needs of a view, without mangling the raw, real underlying table data. * STAGE 4: Apply business logic to create a presentation model for the view. * @return array of ArrayObjects (containing topic info) indexed by topic id */ public static function getPresentationModel() { if (self::$_presentationModel === null) { foreach (self::getDomainModel() as $row) { $row = new ArrayObject($row->toArray(), ArrayObject::ARRAY_AS_PROPS); $row->user = ZFDemoModel_Users::getById($row->user_id); self::$_presentationModel[$row->topic_id] = $row; } } return self::$_presentationModel; }
/** * Create a presentation model of the forum's topics list, appropriate for use by a view. */ public static function getPresentationModel() { $db = Zend_Registry::get('db'); $q = 'SELECT * FROM topics ORDER BY creation_time ASC'; $posts = array(); foreach ($db->query($q) as $row) { $row = new ArrayObject($row, ArrayObject::ARRAY_AS_PROPS); if ($row->modification_time != $row->creation_time) { $row->modification_time = new Zend_Date($row->modification_time, Zend_Date::ISO_8601); } else { $row->modification_time = ''; } $row->country = ''; $row->creation_time = new Zend_Date($row->creation_time, Zend_Date::ISO_8601); $row->user = ZFDemoModel_Users::getById($row->user_id); $topics[] = $row; } return new ArrayObject($topics, ArrayObject::ARRAY_AS_PROPS); }
/** * Returns the posts of a topic as a presentation model (array of arrays containing * information about each post, suitable for use by a view) by mirroring the domain model * into a presentation model. The presentation model can be modified to support * the needs of a view, without mangling the raw, real underlying table data. * STAGE 4: Apply business logic to create a presentation model for the view. * @return array of ArrayObject (post info) */ public static function getPostsByTopicId($topicId) { if (!isset(self::$_presentationModel[$topicId])) { $posts = array(); foreach (self::getDomainModel($topicId) as $row) { $row = new ArrayObject($row->toArray(), ArrayObject::ARRAY_AS_PROPS); $row->user = ZFDemoModel_Users::getById($row->user_id); $posts[] = $row; ///////////////////////////// // ==> SECTION: l10n <== // create a Locale object for the owner of this post (not the user of this request) $postLocale = new Zend_Locale($row->user->locale); $row->country = ZFModule_Forum::getCountry($postLocale->getRegion()); $userLocale = ZFModule_Forum::getUserLocale(); // locale of the user of this request $offset = ZFModule_Forum::getTimeOffset(); if ($row->modification_time != $row->creation_time) { $row->modification_time = new Zend_Date($row->modification_time, $userLocale); $row->modification_time->addTimestamp($offset); // express date/time in user's local timezone } else { $row->modification_time = ''; } $row->creation_time = new Zend_Date($row->creation_time, $userLocale); $row->creation_time->addTimestamp($offset); // express date/time in user's local timezone } // cache result only for duration of this request self::$_presentationModel[$topicId] = $posts; } return self::$_presentationModel[$topicId]; }
/** * Returns the posts of a topic as a presentation model (array of arrays containing * information about each post, suitable for use by a view) by mirroring the domain model * into a presentation model. The presentation model can be modified to support * the needs of a view, without mangling the raw, real underlying table data. * STAGE 4: Apply business logic to create a presentation model for the view. * @return array of ArrayObject (post info) */ public static function getPostsByTopicId($topicId) { if (!isset(self::$_presentationModel[$topicId])) { $posts = array(); foreach (self::getDomainModel($topicId) as $row) { $row = new ArrayObject($row->toArray(), ArrayObject::ARRAY_AS_PROPS); $row->user = ZFDemoModel_Users::getById($row->user_id); $posts[] = $row; } // cache result only for duration of this request self::$_presentationModel[$topicId] = $posts; } return self::$_presentationModel[$topicId]; }