<?php
require "php/mysql.php";
session_start();
$podaci = mySqlUpit("select vrednost_postavke1, vrednost_postavke2 from interne_postavke", 2);
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<meta name="title" content="Naslovna - <?php
echo $podaci[2][0];
?>
">
<meta name="author" content="Lazar Stanojević">
<title>Registracija - <?php
echo $podaci[2][0];
?>
</title>
<link rel="stylesheet" type="text/css" href="css/prijava.css">
<link rel="shortcut icon" type="image/x-icon" href="<?php
echo $podaci[0][0];
?>
">
</head>
<body>
<div class="prijava-logo">
<img src="<?php
echo $podaci[1][0];
?>
" alt="Logo"><br>
<?php
require "php/mysql.php";
require "php/funkcije.php";
session_start();
$podaci = mySqlUpit("select vrednost_postavke1, vrednost_postavke2 from interne_postavke", 2);
$linkovi = ispisPrijave(0);
if (!isset($_REQUEST["id"])) {
echo "Nisu uneti parametri!";
exit;
}
if (empty($_SESSION)) {
echo "Morate biti prijavljeni!";
exit;
}
$korisnik = mySqlUpit("select korisnicko_ime, broj_telefona from osobe where idosobe = " . $_SESSION["idkorisnika"], 1);
?>
<!DOCTYPE html>
<html>
<html>
<head>
<meta charset="UTF-8">
<meta name="title" content="Naslovna - <?php
echo $podaci[2][0];
?>
">
<meta name="author" content="Lazar Stanojević">
<title>Potvrda - <?php
echo $podaci[2][0];
?>
</title>
<tr>
<td>Ponovi novu lozinku:</td>
<td><input type="password" id="forma-pw2" value="" ></td>
</tr>
<tr>
<td><input type="button" onClick="promenaLozinke()" value="Promeni"></td>
<td></td>
</tr>
<tr height="70px" valign="bottom">
<td>Promena telefona</td>
<td></td>
</tr>
<tr>
<td>Unesi novi telefon</td>
<td><input type="text" id="forma-tel" value="<?php
echo mySqlUpit("SELECT broj_telefona FROM osobe WHERE idosobe =" . $_SESSION["idkorisnika"], 1)[0];
?>
" ></td>
</tr>
<tr>
<td><input type="button" onClick="promenaTelefona()" value="Promeni"></td>
<td></td>
</tr>
</table>
</td>
</tr>
</table>
</div>
<div id="footer">
<p class="cpr">Copyright © <?php
echo date("Y");
</div>
<div id="sadrzaj">
<table class="prodaja-karte">
<tr class="prodaja-red">
<th width="50px">Broj</th>
<th width="130px">Korisnik</th>
<th width="200px">Naziv filma</th>
<th width="100px">Datum</th>
<th width="70px">Vreme</th>
<th width="50px">Tip</th>
<th width="80px">Sala</th>
<th width="90px">Sedište</th>
<th width="100px">Cena</th>
</tr>
<?php
$prodato = mySqlUpit("select idkarta, korisnicko_ime, pun_naziv, date_format(date(datum), '%d.%c.%Y.'), time_format(time(datum), '%H:%i'), naziv_tipa, naziv, sediste, vrednost from karta, osobe, projekcije, sale, film, tip_projekcije where tip_projekcije_idtip_projekcije = idtip_projekcije and idfilm = film_idfilm and idosobe = osobe_idosobe and idprojekcije = projekcije_idprojekcije and idsale = sale_idsale order by datum desc", 2);
$suma = 0;
for ($i = 0; $i < count($prodato); $i++) {
echo "<tr class=\"prodaja-red\">";
echo "<td>" . $prodato[$i][0] . "</td>";
echo "<td>" . $prodato[$i][1] . "</td>";
echo "<td>" . $prodato[$i][2] . "</td>";
echo "<td>" . $prodato[$i][3] . "</td>";
echo "<td>" . $prodato[$i][4] . "</td>";
echo "<td>" . $prodato[$i][5] . "</td>";
echo "<td>" . $prodato[$i][6] . "</td>";
echo "<td>" . $prodato[$i][7] . "</td>";
echo "<td>" . $prodato[$i][8] . " RSD</td>";
echo "</tr>";
$suma += floatval($prodato[$i][8]);
}
echo $linkovi[2];
?>
" class="kor"><?php
echo $linkovi[4];
?>
</a>
</div>
</div>
</div>
<div id="slika-strane">
<img src="slike/projekcije.png" alt="Korisnički panel">
</div>
<div id="sadrzaj">
<div class="proj-kontejner">
<?php
$film = mySqlUpit("select idfilm, pun_naziv, orig_naziv, url_postera, url_pozadine from film, interni_detalji_filma where film_idfilm = idfilm and aktivan = 1 order by idfilm desc", 2);
for ($i = 0; $i < count($film); $i++) {
echo "<a href=\"film.php?id=" . $film[$i][0] . "\" class=\"repertoar-blok\">";
echo "<img class=\"proj-poster\" src=\"" . $film[$i][3] . "\">";
echo "<span class=\"proj-naziv\">" . $film[$i][1] . "</span>";
echo "<span class=\"proj-orig\">" . $film[$i][2] . "</span>";
echo "<span class=\"proj-pozadina\" style=\"background-image: url('" . $film[$i][4] . "')\"></span>";
echo "</a><br>";
}
?>
</div>
</div>
<div id="footer">
<p class="cpr">Copyright © <?php
echo date("Y");
?>
<td><input type="button" onClick="dodavanjeCene()" value="Dodaj"></td>
</tr>
</table>
</td>
</tr>
<tr>
<td class="admin-kontejner-td">
<table>
<tr>
<th>Promo kod</th>
<th>Količina</th>
<th>Modifikator</th>
<th></th>
</tr>
<?php
$promo = mySqlUpit("select naziv, kolicina, popust from promo_kodovi", 2);
for ($i = 0; $i < count($promo); $i++) {
echo "<tr>";
echo "<td><input type='text' style=\"width:70px\" id='admin-promo-kod" . $promo[$i][0] . "' value='" . $promo[$i][0] . "'></td>";
echo "<td><input type='text' style=\"width:30px\" id='admin-promo-kol" . $promo[$i][0] . "' value='" . $promo[$i][1] . "'></td>";
echo "<td><input type='text' style=\"width:30px\" id='admin-promo-modif" . $promo[$i][0] . "' value='" . $promo[$i][2] . "'></td>";
echo "<td><input type='button' onClick=\"izmenaPromo('" . $promo[$i][0] . "')\" value='Izmeni'></td>";
echo "</tr>";
}
?>
<tr>
<td><input type="text" style="width:70px" id="admin-promo-kod" value=""></td>
<td><input type="text" style="width:30px" id="admin-promo-kol" value=""></td>
<td><input type="text" style="width:30px" id="admin-promo-modif" value=""></td>
<td><input type="button" onClick="dodavanjePromo()" value="Dodaj"></td>
</tr>
echo $film[4];
?>
</span>
</div>
<hr>
<table>
<tr>
<td valign="top"><iframe width="400" height="225" src="https://www.youtube.com/embed/<?php
echo $film[8];
?>
" frameborder="0" allowfullscreen id="film-trailer"></iframe></td>
<td valign="top">
<span class="proj-span">Predstojeće projekcije:</span>
<?php
$projekcije = mySqlUpit("select date_format(date(datum), '%d.%c.%Y.'), time_format(time(datum), '%H:%i'), naziv_tipa, cena, naziv, idprojekcije, date(datum) as dtm from projekcije, tip_projekcije, sale where date(datum) >= curdate() and sale_idsale = idsale and tip_projekcije_idtip_projekcije = idtip_projekcije and film_idfilm = " . $_REQUEST["id"] . " order by dtm asc", 2);
if (empty($projekcije[0]) || mySqlUpit("select film_idfilm from interni_detalji_filma where film_idfilm = " . $_REQUEST["id"] . " and aktivan = 1", 1) == -1) {
echo "Nema predstojećih projekcija!";
} else {
echo "<table id=\"film-tabela\"><tr><th width=\"70\">Sala</th><th width=\"120\">Datum</th><th width=\"70\">Vreme</th><th width=\"70\">Tip</th><th width=\"50\">Cena</th><th width=\"80\"></th></tr>";
for ($i = 0; $i < count($projekcije); $i++) {
echo "<tr><td>" . $projekcije[$i][4] . "</td><td>" . $projekcije[$i][0] . "</td><td>" . $projekcije[$i][1] . "</td><td>" . $projekcije[$i][2] . "</td><td>" . $projekcije[$i][3] . "</td><td><a href='rezervacija.php?film=" . $_REQUEST["id"] . "&projekcija=" . $projekcije[$i][5] . "'>Rezerviši</a></td></tr>";
}
echo "</table>";
}
?>
</td>
</tr>
</table>
</div>
<div id="footer">
<p class="cpr">Copyright © <?php
<?php
require "php/mysql.php";
require "php/funkcije.php";
session_start();
if (isset($_POST['korisnickoime']) && isset($_POST['lozinka'])) {
if (($row = mySqlUpit("SELECT idosobe FROM osobe WHERE korisnicko_ime='" . kontrolaUlaza($_POST['korisnickoime']) . "' and sha1_lozinka='" . sha1($_POST['lozinka']) . "'", 1)) != -1) {
$_SESSION["idkorisnika"] = $row[0];
header("Location: index.php");
} else {
echo "Netačni podaci!";
}
} else {
echo "Nemate dozvolu!";
}
</span>
<span class="rez-tel">Kontakt telefon: <?php
echo $korisnik[1];
?>
</span>
<input type="text" placeholder="Promo kod" id="rezervacija-kod" value=""> <input type="button" id="rezervacija-kod2" onClick="validacijaPromocije()" value="Potvrda">
</div>
<hr>
<div class="rez-sala-div">
<img src="slike/platno.png">
<table class="rez-sedista">
<?php
for ($i = 1; $i <= $rezervacija[7]; $i++) {
echo "<tr>";
for ($j = 1; $j <= $rezervacija[8]; $j++) {
if (mySqlUpit("select idkarta from karta where projekcije_idprojekcije = " . $_REQUEST["projekcija"] . " and sediste = '" . chr($i + 64) . $j . "'", 1) == -1) {
echo "<td class=\"rez-sediste slobodno\"><a href=\"javascript:rezervisiKartu(" . $_SESSION["idkorisnika"] . ", " . $_REQUEST["projekcija"] . ", '" . chr($i + 64) . $j . "')\">" . chr($i + 64) . $j . "</a> ";
} else {
echo "<td class=\"rez-sediste\"><span class=\"zauzeto\">" . chr($i + 64) . $j . "</span>";
}
echo "</td>";
}
echo "</tr>";
}
?>
</table>
</div>
</div>
<div id="footer">
<p class="cpr">Copyright © <?php
echo date("Y");
exit;
}
if (empty($_SESSION)) {
echo "Morate biti prijavljeni!";
exit;
}
if (mySqlUpit("select osobe_idosobe from karta where idkarta = " . $_REQUEST["karta"], 1)[0] != $_SESSION["idkorisnika"]) {
echo "Ne možete pristupiti tuđim kartama!";
exit;
}
$karta = mySqlUpit("select concat(pun_naziv, ' ', naziv_tipa), naziv, sediste, cena, concat(date_format(date(datum), '%d.%c.%Y.'), ' ', time_format(time(datum), '%H:%i')) from karta, tip_projekcije, film, projekcije, sale where sale_idsale = idsale and projekcije_idprojekcije = idprojekcije and film_idfilm = idfilm and idtip_projekcije = tip_projekcije_idtip_projekcije and idkarta = " . $_REQUEST["karta"], 1);
if ($karta == -1) {
echo "Nepostojeća karta!";
exit;
}
$podaci = mySqlUpit("select vrednost_postavke1 from interne_postavke where id_postavke='naziv_sajta'", 1);
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<link rel="stylesheet" type="text/css" href="css/karta.css">
<title><?php
echo $karta[0];
?>
- <?php
echo $podaci[0];
?>
</title>
</head>
function ispisPrijave($nivo)
{
$rez = array();
if (empty($_SESSION)) {
$rez[0] = "Niste prijavljeni";
if ($nivo == 0) {
$rez[1] = "prijava.php";
$rez[2] = "registracija.php";
} else {
$rez[1] = "../prijava.php";
$rez[2] = "../registracija.php";
}
$rez[3] = "Prijava";
$rez[4] = "Registracija";
} else {
$rez[0] = mySqlUpit("SELECT korisnicko_ime FROM osobe WHERE idosobe =" . $_SESSION["idkorisnika"], 1)[0];
if ($nivo == 0) {
$rez[1] = "korisnik.php";
$rez[2] = "odjava.php";
} else {
$rez[1] = "../korisnik.php";
$rez[2] = "../odjava.php";
}
$rez[3] = "Korisnički panel";
$rez[4] = "Odjava";
}
return $rez;
}
if ($listaFilmova[$j][0] == $spisakProjekcija[$i][3]) {
echo " selected=\"selected\" ";
}
echo ">" . $listaFilmova[$j][1] . "</option>";
}
echo "</select></td><td><select id=\"urednik-projekcije-tip" . $spisakProjekcija[$i][0] . "\">";
$spisakTipova = mySqlUpit("select idtip_projekcije, naziv_tipa from tip_projekcije", 2);
for ($j = 0; $j < count($spisakTipova); $j++) {
echo "<option value=\"" . $spisakTipova[$j][0] . "\"";
if ($spisakTipova[$j][0] == $spisakProjekcija[$i][5]) {
echo " selected=\"selected\" ";
}
echo ">" . $spisakTipova[$j][1] . "</option>";
}
echo "</select></td><td><select id=\"urednik-projekcije-sala" . $spisakProjekcija[$i][0] . "\">";
$spisakSala = mySqlUpit("select idsale, naziv from sale", 2);
for ($j = 0; $j < count($spisakSala); $j++) {
echo "<option value=\"" . $spisakSala[$j][0] . "\"";
if ($spisakSala[$j][0] == $spisakProjekcija[$i][4]) {
echo " selected=\"selected\" ";
}
echo ">" . $spisakSala[$j][1] . "</option>";
}
echo "</select></td>";
echo "<td><input type=\"text\" id=\"urednik-projekcije-datum" . $spisakProjekcija[$i][0] . "\" value=\"" . $spisakProjekcija[$i][1] . "\"></td>";
echo "<td><input type=\"text\" id=\"urednik-projekcije-vreme" . $spisakProjekcija[$i][0] . "\" value=\"" . $spisakProjekcija[$i][2] . "\"></td>";
echo "<td><input type=\"button\" onClick=\"izmenaProjekcije(" . $spisakProjekcija[$i][0] . ")\" value=\"Izmeni\"></td>";
echo "</tr>";
}
?>
<tr>
