public function edit($itemID) { parent::edit($itemID); $tags = $this->db->selectAll('Tag', 'ORDER BY Value'); if (is_null($tags)) { throw new DatabaseException('Error loading tags.', 500); } $records = $this->db->fetchAll('SELECT TagID FROM BlogPost_Tag WHERE BlogPostID = :BlogPostID', array('BlogPostID' => $this->view->getData('BlogPost')->ID)); if ($records === false) { throw new DatabaseException('Failed to retrieve blog post tag IDs.', 500); } $itemTagIDs = array(); foreach ($records as $record) { $itemTagIDs[] = $record['TagID']; } try { require_once \CWA\LIB_PATH . 'cwa/io/FileManager.php'; $fileManager = new \CWA\IO\FileManager("../public/images{$this->pathInURL}"); $slug = $this->view->getData('BlogPost')->Slug; $images = $fileManager->getDirectoryListing("{$slug['0']}/{$slug}")->Files; } catch (Exception $ex) { $images = array(); } $this->view->setData(array('BlogPostTagIDs' => $itemTagIDs, 'Images' => $images, 'Tags' => $tags)); }
public function edit($itemID) { parent::edit($itemID); $users = $this->db->selectAll('User', 'ORDER BY FirstName, LastName'); if (is_null($users)) { throw new DatabaseException('Error loading users.', 500); } $records = $this->db->fetchAll('SELECT UserID FROM User_Role WHERE RoleID = :RoleID', array('RoleID' => $this->view->getData('Role')->ID)); if ($records === false) { throw new DatabaseException('Failed to retrieve role user IDs.', 500); } $itemUserIDs = array(); foreach ($records as $record) { $itemUserIDs[] = $record['UserID']; } $this->view->setData(array('Users' => $users, 'RoleUserIDs' => $itemUserIDs)); }