// tady se budou jen vypisovat sekce v databazi
// $chair = $_GET["chair"];
$chair = true; // chairman se bude vypisovat
/*
echo "
Program
\n";
*/
$densel = $_GET["densel"];
if(!$densel) $densel = 0;
if($densel==0):
$prog_date="all";
else:
$prog_date = DEN1PROG;
$prok = substr($prog_date,0,4);
$pmesic = substr($prog_date,5,2);
$pden = substr($prog_date, 8, 2) + ($densel-1);
$den = mktime(0, 0, 0, $pmesic, $pden, $prok);
$prog_date = date("Y-m-d", $den);
endif;
// lista pro vyber dnu
$alld[0] = "Full Program";
$alld[1] = "Monday";
$alld[2] = "Tuesday";
$alld[3] = "Wednesday";
$alld[4] = "Thursday";
$alld[5] = "Friday";
$pocetd = count($alld);
echo "
\n";
for($i=0; $i<$pocetd; ++$i):
if($i==$densel) {echo "";}
$jm = $_SERVER["PHP_SELF"];
echo "".$alld[$i]."";
if($i==$densel) {echo "";}
if($i<($pocetd-1)) {echo " | ";}
endfor;
echo "
\n";
include ("./func/dbconnect.php");
if($prog_date=="all"):
$dotaz1 = "select sec_date from ".PROG." group by sec_date order by sec_date";
else:
$dotaz1 = "select sec_date from ".PROG." where sec_date='$prog_date'
group by sec_date";
endif;
// echo "
dotaz1: $dotaz1\n";
@$vysledek1 = mysql_query($dotaz1);
echo "
\n";
while ($zaznam=MySQL_Fetch_Array($vysledek1)) {
$sec_date = $zaznam["sec_date"];
$secrok = substr($sec_date,0,4);
$secmesic = substr($sec_date,5,2);
$secden = substr($sec_date, 8, 2);
$den = mktime(0, 0, 0, $secmesic, $secden, $secrok);
$datum = date("l, j F Y", $den);
echo " |
$datum |
|
\n";
$dotaz = "select * from ".PROG." where sec_date=\"$sec_date\"
order by sec_time";
// echo "dotaz: $dotaz
\n";
@$vysledek = mysql_query($dotaz);
while ($zaznam=MySQL_Fetch_Array($vysledek)) {
$ids = $zaznam["ids"];
$sekce = $zaznam["sekce"];
$typ_sekce = $zaznam["typ_sekce"];
// echo "sekce: $ids|$sekce| $typ_sekce
\n";
$chview = true; // chairman se bude zobrazovat
if($typ_sekce=="coffee break" || $typ_sekce=="lunch"
|| $typ_sekce=="nochair" || $typ_sekce=="concert") {
$chview = false;
}
if(!$chair) $chview = false;
if($sekce=="Conference dinner and organ concert") $chview = false;
$chairman = $zaznam["chairman"];
// $sec_date = $zaznam["sec_date"];
$sec_time = $zaznam["sec_time"];
$duration = $zaznam["duration"];
$pocet_prispevku = $zaznam["pocet_prispevku"];
$pozn = $zaznam["pozn"];
$location = NULL;
$numloc = $zaznam["numloc"];
if($numloc>0) {// urcim location
$dotazloc = "select location from ".LOCATION." where idl=$numloc";
@$vysloc = mysql_query($dotazloc);
while ($zloc=MySQL_Fetch_Array($vysloc)) {
$location = $zloc["location"];
}
}
$pos = strpos($sec_time,":");
$hod = substr($sec_time,0,$pos);
$min = substr($sec_time,$pos+1);
$hodini = $hod;
$minini = $min;
$ch1 = substr($sec_time,0,1);
// echo "ch1:$ch1
\n";
if($ch1==0) $hodini = substr($hod,1);
// echo "sec_time, pos, hod, min: $sec_time, $pos, $hod, $min
\n";
$min1 = $min + $duration;
$do = $min1%60;
$hod1 = ($min1-$do)/60;
if($min<10) $min = "0".$min;
if($do<10) $do = "0".$do;
$od = substr($sec_time,0,5);
// $od = $hodini.":".$minini; // misto 08: bude 8:
$do = ($hod+$hod1).":".$do;
// echo "min1, hod1, zbytek = $min1, $hod1, $zbytek
\n";
echo "\n";
if($org) echo "$ids\n";
echo "$od - $do\n";
if($org) echo " [$sec_time ($duration)]\n";
$sekcecls = $typ_sekce;
if($typ_sekce=="coffee break") {
$sekcecls = "coffee";
}
if($typ_sekce=="free time") {
$sekcecls = "free";
}
echo " | $sekce |
\n";
if(strlen($location)>1) echo "
Location: |
$location |
\n";
if($chview) echo "
chairperson: |
$chairman |
\n";
if($org && $chview) echo " |
Number of contribution: $pocet_prispevku
Session type: $typ_sekce |
\n";
if($org && strlen($pozn)>1)
echo " |
Comment: $pozn |
";
// dotazy do databaze prispevku
$dotazc = "select * from ".SQL_TBL." where idsec=$ids order by poradi";
@$vyslc = mysql_query($dotazc);
$dobasum = 0;
$doba = array();
$poradi = array();
$hodi = array();
$mini = array();
$hodl = array();
$minl = array();
$pos = strpos($sec_time,":");
$hodini = substr($sec_time,0,$pos);
$min = substr($sec_time,$pos+1);
$pos = strpos($min,":");
$minini = substr($min,0,$pos);
$i = 0;
// echo "hodini, minini: $hodini, $minini
\n";
while ($zaznam=MySQL_Fetch_Array($vyslc)) {
$authors[$i] = $zaznam["authors"];
$titlcon[$i] = $zaznam["contriben"];
$reg[$i] = $zaznam["reg"];
$num[$i] = $zaznam["num"];
$doba[$i] = $zaznam["doba"];
$poradi[$i] = $zaznam["doba"];
$dobasum += $zaznam["doba"];
$hodi[$i] = $hodini;
$mini[$i] = $minini;
$min1 = $minini + $doba[$i];
$do = $min1%60;
$hod1 = ($min1-$do)/60;
$hh= $hodini+$hod1;
if($hh<10) $hodl[$i] = "0".$hh;
else $hodl[$i] = $hh;
// $hodl[$i] = $hodini+$hod1;
$mm = $do;
if($mm<10) $minl[$i] = "0".$mm;
else $minl[$i] = $mm;
//$minl[$i] = $do;
$hodini = $hodl[$i];
$minini = $minl[$i];
++$i;
}
$remain = $duration - $dobasum;
if($org) {
echo " |
Total session time: $duration
Time reserved: $dobasum (min) \n";
if($remain<0){
echo "
Remaining time: $remain (min) \n";
}
else {
echo "
Remaining time: $remain (min) \n";
}
echo " |
\n";
}
for($i=0; $i
$hodi[$i]:$mini[$i] - $hodl[$i]:$minl[$i] | \n";
if($fromorg):
$absf = "../pdfabstracts/".$reg[$i]."f.pdf";
else:
$absf = "./pdfabstracts/".$reg[$i]."f.pdf";
endif;
echo "$authors[$i] \n";
// echo "absf: $absf \n";
if(File_Exists($absf)):
echo "".$titlcon[$i]."\n";
else:
echo "$titlcon[$i]\n";
endif;
echo " | \n";
endfor;
// konec dotazu do databaze prispevku
echo "
|
\n";
echo " | |
\n";
}
}
echo "
\n";
?>