require("./mslocjr.php");
openmysqlserver();
MySQL_Select_DB("msekce");
if (isset($_GET["vypis"])){
if ($_GET["vypis"]==1){
print "vypiseme";
die;
}
}
# $myname=BaseName($SCRIPT_FILENAME);
#/*
# if ($myname=="respadm.php"){
# $sp=MySQL_Connect("localhost","jrro","4+6+8+9");
# MySQL_Select_DB("richter");
# $query="SELECT * FROM hesla WHERE user='$PHP_AUTH_USER' AND pwd=PASSWORD('$PHP_AUTH_PW');";
# $ko=1;
# $zaz = MySQL_Query($query);
# while($z = MySQL_Fetch_Array($zaz)){
# $allow=$z["url"];
# }
# if (ERegI($SCRIPT_URI,$allow)){$ko=0;}
# if ($ko){
# Header("WWW-Authenticate: Basic realm=\"Zadejte JINY login nebo heslo");
# exit;
# }
# }
#*/
if (isset($_GET["typ"])){$typ=$_GET["typ"];}else{$typ="";}
if ($typ!="s"){
?>
Rezervace respiria
}?>
# $spojeni=MySQL_Connect("localhost","projektor","projektor");
# MySQL_Select_DB("muuk");
$cas[1]=" 7:20-8:05";
$cas[2]=" 8:10-8:55";
$cas[3]=" 9:00-9:45";
$cas[4]=" 9:50-10:35";
$cas[5]="10:40-11:25";
$cas[6]="11:30-12:15";
$cas[7]="12:20-13:05";
$cas[8]="13:10-13:55";
$cas[9]="14:00-14:45";
$cas[10]="14:50-15:35";
$cas[11]="15:40-16:25";
$cas[12]="16:30-17:15";
$cas[13]="17:20-18:05";
$cas[14]="18:10-18:55";
$cas[15]="19:00-19:45";
?>
$script_n=BaseName($_SERVER["SCRIPT_FILENAME"]);
$akce="";
if (isset($_POST["ACTION"])){
$akce=$_POST["ACTION"];
}else{
if (isset($_GET["ACTION"])){
$akce=$_GET["ACTION"];
}
}
$datum="";
if (isset($_POST["datum"])){
$datum=$_POST["datum"];
}else{
if (isset($_GET["datum"])){
$datum=$_GET["datum"];
}
}
if (isset($_GET["den"])){$denm=$_GET["den"];}else{$denm="";}
if (isset($_GET["mesic"])){$mesicm=$_GET["mesic"];}else{$mesicm="";}
if (isset($_GET["rok"])){$ym=$_GET["mesic"];}else{$ym="";}
if ($akce=="Vyplnit"){
if ($denm || $mesicm){
$d11=Date("w",MkTime(1,0,0,$mesicm,1,$ym));
if ($d11==0){$d11=7;}
$dif=$denm-$d11;
$pd=$d11;
if ($dif<0){$pd=8+$dif;}else{$pd=1+$dif;}
$datum="";
do{
if (Date("m",MkTime(1,0,0,$mesicm,$pd,$ym))==$mesicm){
$datum.=";$ym-$mesicm-$pd";
}
$pd+=7;
} while ($pd<32);
}
$query="SELECT * FROM respirium WHERE datum='$datum'";
$zaz = MySQL_Query($query);
$z = MySQL_Fetch_Array($zaz);
for ($i=1;$i<16;$i++){
$h[$i]=$z["h".$i];
}
if ($typ=="s"){
print "\n";
for ($k=1;$k<16;$k++){
if ($h[$k]){
echo $cas[$k].":".$h[$k]."\n";
}
}
}else{?>
}
}
if ($akce=="Zapsat"){
$datumy=Split(";",$datum);
foreach ($datumy as $datum) {
$h[1]=$_POST["h1"];$h[2]=$_POST["h2"];$h[3]=$_POST["h3"];$h[4]=$_POST["h4"];$h[5]=$_POST["h5"];
$h[6]=$_POST["h6"];$h[7]=$_POST["h7"];$h[8]=$_POST["h8"];$h[9]=$_POST["h9"];$h[10]=$_POST["h10"];
$h[11]=$_POST["h11"];$h[12]=$_POST["h12"];$h[13]=$_POST["h13"];$h[14]=$_POST["h14"];$h[15]=$_POST["h15"];
#zjistim, jestli existuje zaznam
$query="SELECT * FROM respirium WHERE datum='$datum'";
$zaz = MySQL_Query($query);
$z=MySQL_Fetch_Array($zaz);
$delim="";
if ($z['datum']){
$query="UPDATE respirium SET ";
for ($i=1;$i<=15;$i++){$query.=$delim."h$i='".$h[$i]."'";$delim=",";}
$query.="WHERE datum='$datum'";
}else{
$query="INSERT INTO respirium (h1,h2,h3,h4,h5,h6,h7,h8,h9,h10,h11,h12,h13,h14,h15,datum) VALUES ('$h[1]', '$h[2]', '$h[3]', '$h[4]', '$h[5]', '$h[6]', '$h[7]', '$h[8]', '$h[9]', '$h[10]', '$h[11]', '$h[12]', '$h[13]','$h[14]', '$h[15]','$datum')";
}
$all="";
for ($i=1;$i<16;$i++){$all.=$h[$i];}
if (StrLen($all)==0){$query="DELETE FROM respirium WHERE datum='$datum'";}
$q=MySQL_Query($query);
if (!($q)){echo "
Zápis se nezdaøil :-(";}
$akce="";
}
}
if ($akce==""){
echo "
Rezervace respiria
";
echo "
- nova rezervace-prihlasit se
";
if ($script_n=="respadm.php"){
echo "- pro zalohu na jednotlivy den - klikni na prislusne datum
- pro pravidelnou zalohu - klikni na zkratku dne
";
}
echo "
";
?>
| rezervovano cely den |
| rezervovano jen na urcitou hodinu (po kliknuti na dany den se zobrazi hodinovy rozpis) |
Rezervace může provádět pouze sekretářka KPMS - pí. Jandová |
$mme=Array("Leden","Únor","Březen","Duben","Květen","Červen","Červenec","Srpen","Září","Říjen","Listopad","Prosinec");
$mesa=Date("m");
$mesa=IntVal($mesa);$mxm=$mesa+5;
$ya=Date("Y");
for ($me=$mesa;$me<=$mxm;$me++){
if ($me>12){$mes=$me-12;$y=$ya+1;}else{$y=$ya;$mes=$me;}
$dat=MkTime(1,0,0,$mes,1,$y);
$d11=Date("w",$dat);
if ($d11==0){$d11=7;}
//pocet dni v mesici
if ($mes==1 || $mes==3 || $mes==5 || $mes==7 || $mes==8 || $mes==10 || $mes==12){$dnu=31;}
if ($mes==4 || $mes==6 || $mes==9 || $mes==11){$dnu=30;}
$z1=$y%4;$z2=$y%100;$z3=$y%400;
$prestup=0;
if ($z1==0){if ($z2==0 AND $z3!=0){$prestup=0;}else{$prestup=1;}}
if ($mes==2){if ($prestup){$dnu=29;}else{$dnu=28;}}
//prazdna policka
$dl=$d11+$dnu;
for ($i=1;$i<=42;$i++){
if ($i<$d11){$den[$i]=" ";}else{if ($i<$dl){$den[$i]=$i-$d11+1;}else{$den[$i]=" ";}}
}
$mm=$mes-1;
$radek="
$mme[$mm] $y |
";
if ($script_n=="respadm.php"){$href="HREF";}else{$href="HRE";}
$radek.="
Po |
Ut |
St |
Ct |
Pa |
So |
Ne |
";
$radek.="
";
for ($i=1;$i<=42;$i++){
$datum="$y-$mes-".$den[$i];
if ((($i+1)%7)==0 || ($i%7)==0){$color="BGCOLOR=#90e040";}else{$color="";}
if ($den[$i]==" "){
$color="";
}else{
$query="SELECT * FROM respirium WHERE datum='$datum'";
$zaz = MySQL_Query($query);
$z=MySQL_Fetch_Array($zaz);
if ($z['datum']!=""){
$expr=0;
for ($k=1;$k<=15;$k++){
$hi="h".$k;
if ($z[$hi]==""){$expr+=1;}
}
if ($expr>0){$color="BGCOLOR=#fa9664";}else{$color="BGCOLOR=RED";}
if ($expr==15){$color="";}
}
}
if ($den[$i]!=" "){
$radek.="".$den[$i]." | ";
}else{
$radek.="".$den[$i]." | ";
}
if (($i%7)==0){$radek.="
\n
";}
}
$radek.="
";
$mest[$me]="
";
}
echo "
";
for ($me=$mesa;$me<=$mxm;$me++){
echo "".$mest[$me]." | ";
if ((($me-$mesa+1)%3)==0){echo "
";}
}
echo "
";
}
?>
}?>