<?php
require_once '__system.php';
require_once '__database.php';
require_once '__misc.php';
require_once 'tools.php';

class pageSample extends page{

function displayTitle(){
echo '<h1>#### ##</h1>';
}

function displayMenu(){
echo "<ul>";
echo "<li><a href='".SCRIPTPATH."/home.php' class='current'>Home</a></li>";
echo "<li><a href='".SCRIPTPATH."/daftar.php'>Pendaftaran</a></li>";
echo "<li><a href='".SCRIPTPATH."/jadwalujian.php'>Jadwal Ujian</a></li>";
echo "<li><a href='".SCRIPTPATH."/help.php'>Panduan</a></li>";
echo "<li><a href='".SCRIPTPATH."/contact.php'>Hubungi Kami</a></li>";
echo "<li><a href='".SCRIPTPATH."/logout.php' class='last'>Logout</a></li>";
echo "</ul>";
}

function displayBody(){
$title = ''; if(array_key_exists('title',$_GET)) $title = $_GET['title'];
$msg = ''; if(array_key_exists('msg', $_GET)) $msg = $_GET['msg'];

$email = ''; if(array_key_exists('email',$_COOKIE)) $email = $_COOKIE['email'];
$pid = selectValue('PID','','person','EMAIL',$email);
$form = selectSimple('PID','apl01',"where PID='{$pid}'");
$form2level1 = '';
//$sudah1 = selectSimple('KONFIRMASI','apl01',"where PID='{$pid}'")=='Sudah';
//$sudah2 = selectSimple('KONFIRMASI','apl02',"where PID='{$pid}'")=='1';
if(selectSimple('KONFIRMASI','apl01',"where PID='{$pid}'")=='Sudah'$sudah1=1; else $sudah1=0;
if($sudah1) $sudah=1; else $sudah=0;
if($sudah){
$q = "select jadwal.TANGGAL,tempat.NAMA,jadwal.ID from peserta left join jadwal on jadwalid=jadwal.id left join tempat on tempatid=tempat.id where peserta.PID='{$pid}';";
$r = mysql_query($q);
if($r){
$a = mysql_num_rows($r);
}

if($a==0){
echo "<form method=post action='/public/pilih.php'>";
echo "<select name=jadwalid>";
$q = "select jadwal.ID,tempat.NAMA,tempat.KAPASITAS,jadwal.TANGGAL,count(peserta.ID) as X from jadwal left join tempat on tempatid=tempat.id left join peserta on jadwalid=jadwal.id group by jadwal.id order by jadwal.TANGGAL,tempat.NAMA;";
$r = mysql_query($q);
if($r){
while($a=mysql_fetch_row($r)){
//print_r($a);
if($a[2]>$a[4]){
echo "<option value='{$a[0]}' />".$a[3]." ".$a[1]." (".$a[4]."/".$a[2].")";
}
}
}
echo "</select>";
echo "<input type=submit value=Pilih />";
echo "</form>";
} else {
$a=mysql_fetch_row($r);
$tanggal = $a[0];
$tempat = $a[1];
$jadwalid = $a[2];
$kursi = '';
//print_r($a);

$q = "select ID,PID,JADWALID from peserta where jadwalid='{$jadwalid}';";
$r = mysql_query($q);
if($r){
$kursi = 1;
while($a=mysql_fetch_row($r)){
if($pid==$a[1]){
break;
}
$kursi++;
}
}
$kursi = str_pad($kursi,3,'0',STR_PAD_LEFT);
$t = implode('-',array_reverse(explode('-',$tanggal)));

echo "<table align =center cellpadding=0 cellspacing=0>";
echo "<tr><td>Tanggal<td>: {$t}";
echo "<tr><td>Tempat<td>: {$tempat}";
echo "<tr><td>Kursi<td>: {$kursi}";
echo "</table>";
}
}else
if((strlen($form)>0)&(strlen($form2level1)>0)){
echo 'Tunggu konfirmasi ####';
}
//echo selectSimple('KONFIRMASI','apl01',"where PID='{$pid}'");
}

}

$page = new pageSample();
$page = null;