include_once "../../digital-logsheets-res/php/database/managePlaylistEntries.php"; include_once "../../digital-logsheets-res/php/database/manageSegmentEntries.php"; $firstName = $_POST['first_name']; $lastName = $_POST['last_name']; $programId = $_POST['program']; $prerecord = isset($_POST['prerecord']); $prerecord_date = $_POST['prerecord_date']; $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);
public function __construct($db, $componentId) { parent::__construct($db, $componentId); $this->segments = managePlaylistEntries::getPlaylistSegmentsFromDatabase($db, $componentId); }
/** * @param $dbConn * @param $episodeId * @return Segment[] */ public static function getAllSegmentsForEpisodeId($dbConn, $episodeId) { $episode = new Episode($dbConn, $episodeId); $playlistId = $episode->getPlaylistId(); $segments = managePlaylistEntries::getPlaylistSegmentsFromDatabase($dbConn, $playlistId); return $segments; }