gest_film.php

<?php

require_once("php/tools.php");
require_once("php/database.php");

if (! isset($_SESSION["id"]) || $_SESSION["is_admin"] == 0) {
	header ("location: login.php");
	exit();
}

$id = isset($_GET["id"]) ? $_GET["id"] : "";

try {
	$connessione = new Database();
	$generi = $connessione->getGeneri();
	$collezioni = $connessione->getCollezioni();
	$stati = $connessione->getStati();
	$paesi = $connessione->getPaesi();
	$persone = $connessione->getPersone();
	$ruoli = $connessione->getRuoli();
	if ($id != "") {
		$film = $connessione->getFilmById($id);
		$film_generi = $connessione->getGenereByFilmId($id);
		$film_paesi = $connessione->getPaeseByFilmId($id);
		$crew = $connessione->getCrewByFilmId($id);
	}
	unset($connessione);
} catch (Exception) {
	unset($connessione);
	Tools::errCode(500);
	exit();
}

if ($id != "" && empty($film)) {
	Tools::errCode(404);
	exit();
}

$page = Tools::buildPage($_SERVER["SCRIPT_NAME"]);

$tmp = Tools::getSection($page, "crew_sample");
$crew_sample = Tools::getSection($page, "persone_presenti");
Tools::replaceAnchor($crew_sample, "persona_presente", $tmp, true);
Tools::replaceAnchor($tmp, "crew_person_label_id", "");
Tools::replaceAnchor($tmp, "crew_person_input_id", "");
Tools::replaceAnchor($tmp, "crew_person_input_value", "");
Tools::replaceAnchor($tmp, "crew_person_hint", "");
Tools::replaceAnchor($tmp, "crew_person_hidden_id", "");
Tools::replaceAnchor($tmp, "crew_person_hidden_name", "");
Tools::replaceAnchor($tmp, "crew_person_hidden_value", "");
Tools::replaceAnchor($tmp, "crew_role_label_id", "");
Tools::replaceAnchor($tmp, "crew_role_select_id", "");
Tools::replaceAnchor($tmp, "crew_role_select_name", "");
Tools::replaceSection($page, "crew_sample", $tmp);

Tools::toHtml($persone, 1);
$tmp = Tools::getSection($page, "persona");
$res = "";
foreach ($persone as $p) {
	$t = $tmp;
	Tools::replaceAnchor($t, "id", $p["id"]);
	Tools::replaceAnchor($t, "nome", $p["nome"]);
	$res .= $t;
}
Tools::replaceSection($page, "persona", $res);

Tools::toHtml($ruoli, 1);
$tmp = Tools::getSection($page, "ruolo");
$ruolo_sample = $tmp;
$res = "";
foreach ($ruoli as $r) {
	$t = $tmp;
	Tools::replaceAnchor($t, "id", $r["id"]);
	Tools::replaceAnchor($t, "nome", $r["nome"]);
	Tools::replaceAnchor($t, "sel", "");
	$res .= $t;
}
Tools::replaceSection($page, "ruolo", $res);

$tmp = Tools::getSection($page, "nation_sample");
$nation_sample = Tools::getSection($page, "paesi_presenti");
Tools::replaceAnchor($nation_sample, "paese_presente", $tmp, true);
Tools::replaceAnchor($tmp, "nation_label_id", "");
Tools::replaceAnchor($tmp, "nation_input_id", "");
Tools::replaceAnchor($tmp, "nation_input_value", "");
Tools::replaceAnchor($tmp, "nation_hint", "");
Tools::replaceAnchor($tmp, "nation_hidden_id", "");
Tools::replaceAnchor($tmp, "nation_hidden_name", "");
Tools::replaceAnchor($tmp, "nation_hidden_value", "");
Tools::replaceSection($page, "nation_sample", $tmp);

Tools::toHtml($paesi, 1);
$tmp = Tools::getSection($page, "paese");
$res = "";
foreach ($paesi as $p) {
	$t = $tmp;
	Tools::replaceAnchor($t, "id", $p["id"]);
	Tools::replaceAnchor($t, "nome", $p["nome"]);
	$res .= $t;
}
Tools::replaceSection($page, "paese", $res);

if ($id != "") {
	$film = $film[0];
	$title = $film["nome"] . " • Modifica film"; Tools::toHtml($title, 1);
	Tools::replaceAnchor($page, "title", $title);
	Tools::replaceAnchor($page, "bc_id", $id);
	$bc_nome = $film["nome"]; Tools::toHtml($bc_nome);
	Tools::replaceAnchor($page, "bc_nome", $bc_nome);
	Tools::replaceAnchor($page, "intestazione", "Modifica film");
	Tools::replaceAnchor($page, "gest_id", $id);
	Tools::toHtml($film, 0);
	Tools::replaceAnchor($page, "nome", $film["nome"]);
	Tools::replaceAnchor($page, "descrizione", (isset($film["descrizione"]) ? $film["descrizione"] : ""));
	if (isset($film["locandina"])) {
		Tools::replaceAnchor($page, "immagine_webp", "pics/w200_" . $film["locandina"] . ".webp");
		Tools::replaceAnchor($page, "immagine", "pics/w200_" . $film["locandina"] . ".jpg");
	} else {
		Tools::replaceSection($page, "locandina", "");
	}
	Tools::replaceAnchor($page, "data_rilascio", (isset($film["data_rilascio"]) ? $film["data_rilascio"] : ""));
	Tools::replaceAnchor($page, "durata", (isset($film["durata"]) ? $film["durata"] : ""));

	Tools::toHtml($crew, 1);
	$res = "";
	for ($i = 0; $i < count($crew); $i++) {
		$t = $crew_sample;
		Tools::replaceAnchor($t, "crew_person_label_id", $i);
		Tools::replaceAnchor($t, "crew_person_input_id", $i);
		Tools::replaceAnchor($t, "crew_person_input_value", $crew[$i]["p_nome"]);
		Tools::replaceAnchor($t, "crew_person_hint", $i);
		Tools::replaceAnchor($t, "crew_person_hidden_id", $i);
		Tools::replaceAnchor($t, "crew_person_hidden_name", 'name="crew-person[]"');
		Tools::replaceAnchor($t, "crew_person_hidden_value", $crew[$i]["p_id"]);
		Tools::replaceAnchor($t, "crew_role_label_id", $i);
		Tools::replaceAnchor($t, "crew_role_select_id", $i);
		Tools::replaceAnchor($t, "crew_role_select_name", 'name="crew-role[]"');
		$tmp = "";
		foreach ($ruoli as $r) {
			$k = $ruolo_sample;
			Tools::replaceAnchor($k, "id", $r["id"]);
			Tools::replaceAnchor($k, "nome", $r["nome"]);
			Tools::replaceAnchor($k, "sel", ($crew[$i]["r_id"] == $r["id"] ? "selected" : ""));
			$tmp .= $k;
		}
		Tools::replaceSection($t, "ruolo", $tmp);
		$res .= $t;
	}
	Tools::replaceSection($page, "persone_presenti", $res);

	$res = "";
	for ($i = 0; $i < count($film_paesi); $i++) {
		$t = $nation_sample;
		Tools::replaceAnchor($t, "nation_label_id", $i);
		Tools::replaceAnchor($t, "nation_input_id", $i);
		Tools::replaceAnchor($t, "nation_input_value", $film_paesi[$i]["nome"]);
		Tools::replaceAnchor($t, "nation_hint", $i);
		Tools::replaceAnchor($t, "nation_hidden_id", $i);
		Tools::replaceAnchor($t, "nation_hidden_name", 'name="nation[]"');
		Tools::replaceAnchor($t, "nation_hidden_value", $film_paesi[$i]["id"]);
		$res .= $t;
	}
	Tools::replaceSection($page, "paesi_presenti", $res);

	Tools::replaceAnchor($page, "nome_originale", (isset($film["nome_originale"]) ? $film["nome_originale"] : ""));
	Tools::replaceAnchor($page, "budget", (isset($film["budget"]) ? $film["budget"] : ""));
	Tools::replaceAnchor($page, "incassi", (isset($film["incassi"]) ? $film["incassi"] : ""));
	Tools::replaceAnchor($page, "submit_value", "modifica");
	Tools::replaceAnchor($page, "submit", "Modifica");
} else {
	Tools::replaceAnchor($page, "title", "Aggiungi film");
	Tools::replaceSection($page, "breadcrumb", "Aggiungi");
	Tools::replaceAnchor($page, "intestazione", "Aggiungi film");
	Tools::replaceAnchor($page, "gest_id", "");
	Tools::replaceAnchor($page, "nome", "");
	Tools::replaceAnchor($page, "descrizione", "");
	Tools::replaceSection($page, "locandina", "");
	Tools::replaceAnchor($page, "data_rilascio", "");
	Tools::replaceAnchor($page, "durata", "");
	Tools::replaceSection($page, "persone_presenti", "");
	Tools::replaceSection($page, "paesi_presenti", "");
	Tools::replaceAnchor($page, "nome_originale", "");
	Tools::replaceAnchor($page, "budget", "");
	Tools::replaceAnchor($page, "incassi", "");
	Tools::replaceAnchor($page, "submit_value", "aggiungi");
	Tools::replaceAnchor($page, "submit", "Aggiungi");
	Tools::replaceSection($page, "delete", "");
}

Tools::toHtml($stati, 1);
$option = Tools::getSection($page, "stato");
$res = "";
foreach ($stati as $s) {
	$t = $option;
	Tools::replaceAnchor($t, "id", $s["id"]);
	Tools::replaceAnchor($t, "nome", $s["nome"]);
	Tools::replaceAnchor($t, "sel", ((($id != "" && $s["id"] == $film["stato"]) ? "selected" : "")));
	$res .= $t;
}
Tools::replaceSection($page, "stato", $res);

Tools::toHtml($collezioni, 1);
usort($collezioni, fn($a, $b) => $a['nome'] <=> $b['nome']);
$tmp = Tools::getSection($page, "collezione");
$res = "";
foreach ($collezioni as $c) {
	$t = $tmp;
	Tools::replaceAnchor($t, "id", $c["id"]);
	Tools::replaceAnchor($t, "nome", $c["nome"]);
	Tools::replaceAnchor($t, "sel", ((($id != "" && isset($film["collezione"]) && $c["id"] == $film["collezione"]) ? "selected" : "")));
	$res .= $t;
}
Tools::replaceSection($page, "collezione", $res);

if ($id != "") {
	$fg = [];
	foreach ($film_generi as $t)
		array_push($fg, $t["id"]);
}
$generi_sorted = $generi;
Tools::toHtml($generi_sorted, 1);
usort($generi_sorted, fn($a, $b) => $a['nome'] <=> $b['nome']);
Tools::toHtml($generi, 2);
$option = Tools::getSection($page, "genere");
$res = "";
foreach ($generi_sorted as $g) {
	$t = $option;
	Tools::replaceAnchor($t, "genere_label_id", $g["id"]);
	Tools::replaceAnchor($t, "genere_input_id", $g["id"]);
	Tools::replaceAnchor($t, "genere_label_nome", $generi[$g["id"]]["nome"]);
	Tools::replaceAnchor($t, "checked", ($id != "" && in_array($g["id"], $fg) ? "checked" : ""));
	Tools::replaceAnchor($t, "id", $g["id"]);
	$res .= $t;
}
Tools::replaceSection($page, "genere", $res);

Tools::showPage($page);

?>