function getSelect2ProgramsList($db)
{
$programs = manageProgramEntries::getAllProgramsFromDatabase($db);
$programsArrayForSelect2 = array();
for ($i = 1; $i < count($programs); $i++) {
$programsArrayForSelect2[$i] = array("id" => $i, "text" => $programs[$i]);
}
$programs = json_encode(array_values($programsArrayForSelect2));
return $programs;
}
*/
//----INCLUDE FILES----
include_once "../../digital-logsheets-res/smarty/libs/Smarty.class.php";
include_once "../../digital-logsheets-res/php/database/connectToDatabase.php";
include_once "../../digital-logsheets-res/php/database/manageCategoryEntries.php";
include_once "../../digital-logsheets-res/php/database/manageProgramEntries.php";
require_once "../../digital-logsheets-res/php/objects/logsheetClasses.php";
// create object
$smarty = new Smarty();
session_start();
//database interactions
try {
//connect to database
$db = connectToDatabase();
$categories = manageCategoryEntries::getAllCategoriesFromDatabase($db);
$programs = manageProgramEntries::getAllProgramsFromDatabase($db);
$episodeId = $_SESSION['episodeId'];
$episode = new Episode($db, $episodeId);
$episodeArray = $episode->getObjectAsArray();
//close database connection
$db = NULL;
$errorArray = array("segmentTimeInEpisode" => false, "firstSegmentAlignWithEpisodeStart" => false, "adNumberInteger" => false, "albumRequired" => false, "songRequired" => false, "artistRequired" => false);
$smarty->assign("programs", $programs);
$smarty->assign("categories", $categories);
$smarty->assign("episode", $episodeArray);
$smarty->assign("error", $errorArray);
// display it
echo $smarty->fetch('../../digital-logsheets-res/templates/add-segments.tpl');
} catch (PDOException $e) {
echo 'ERROR: ' . $e->getMessage();
}
public function __construct($db, $componentId)
{
parent::__construct($db, $componentId);
$this->name = manageProgramEntries::getProgramNameFromDatabase($db, $componentId);
}
