public function __construct($db, $componentId) { parent::__construct($db, $componentId); if ($componentId != null) { manageEpisodeEntries::getEpisodeAttributesFromDatabase($db, $componentId, $this); } }
* * This program is free software: you can redistribute it and/or modify * it under the terms of the GNU General Public License as published by * the Free Software Foundation, either version 3 of the License, or * (at your option) any later version. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU General Public License for more details. * * You should have received a copy of the GNU General Public License * along with this program. If not, see <http://www.gnu.org/licenses/>. */ require_once "../../digital-logsheets-res/smarty/libs/Smarty.class.php"; require_once "../../digital-logsheets-res/php/database/connectToDatabase.php"; require_once "../../digital-logsheets-res/php/database/manageEpisodeEntries.php"; require_once "../../digital-logsheets-res/php/database/manageSegmentEntries.php"; require_once "../../digital-logsheets-res/php/objects/Episode.php"; session_start(); try { //connect to database $db = connectToDatabase(); $episodeId = $_SESSION['episodeId']; $episode = new Episode($db, $episodeId); manageEpisodeEntries::turnOffEpisodeDraftStatus($db, $episode); unset($_SESSION['episodeId']); echo "Episode saved!"; } catch (PDOException $e) { echo $e->getMessage(); }
public function __construct($db) { $this->db = $db; $this->episodes = manageEpisodeEntries::getAllEpisodesFromDatabase($db); }
$episodeStartTime = $_POST['start_datetime']; $episodeDuration = $_POST['episode_duration']; $comment = $_POST['comment']; session_start(); try { $db = connectToDatabase(); $programmerId = 1; //TODO change programmerId once settled how programmers will be stored $playlistId = managePlaylistEntries::createNewPlaylist($db); $episodeStartTime = new DateTime($episodeStartTime, new DateTimeZone('America/Montreal')); $episode_end_time = clone $episodeStartTime; $episodeDurationMins = $episodeDuration * 60; $episodeDurationDateInterval = new DateInterval('PT' . $episodeDurationMins . 'M'); $episode_end_time->add($episodeDurationDateInterval); $episodeObject = new Episode($db, null); $episodeObject->setPlaylist(new Playlist($db, $playlistId)); $episodeObject->setProgram(new Program($db, $programId)); $episodeObject->setProgrammer(new Programmer($db, $programmerId)); $episodeObject->setStartTime($episodeStartTime); $episodeObject->setEndTime($episode_end_time); $episodeObject->setIsPrerecord($prerecord); $episodeObject->setPrerecordDate($prerecord_date); $episodeObject->setComment($comment); $episodeId = manageEpisodeEntries::saveNewEpisode($db, $episodeObject); $_SESSION["episodeId"] = $episodeId; error_log("session episode Id: " . $_SESSION["episodeId"]); header('Location: add-segments.php'); } catch (PDOException $e) { error_log('Error while saving an episode: ' . $e->getMessage()); //TODO: error handling }