HotelDB

Nemáte oprávnění k přístupu na tuto stránku - ENU1"; exit; endif; $aktual_ts = date("YmdHis"); if ($act == "Zvolit"){$act = "list";} switch ($act) { case "Vložit a přiřadit hosta": $od = "$od_rok"."$od_mes"."$od_den"."130000"; $do = "$do_rok"."$do_mes"."$do_den"."120000"; $cross = ""; $dbdatap = mysql_query ("SELECT * FROM pobyty WHERE (C_POKOJE = '$c_pokoje');"); while ($vetap = mysql_fetch_array ($dbdatap)): if(( $vetap['OD'] < $od ) and ( $vetap['DO'] > $od )){ $cross = "zacatek"; break;} if(( $vetap['OD'] < $do ) and ( $vetap['DO'] > $do )){ $cross = "konec"; break;} if(( $vetap['OD'] < $od ) and ( $vetap['DO'] > $od ) and ( $vetap['OD'] < $do ) and ( $vetap['DO'] > $do )){ $cross = "oba"; break;} endwhile; echo "

"; if ($cross != ""):{ echo ""; if ( $cross = "zacatek" ){ echo "Počátek rezervace";} if ( $cross = "zacatek" ){ echo "Konec rezervace";} if ( $cross = "zacatek" ){ echo "Rezervace";} echo " se překrývá s jinou rezervací stejného pokoje ( číslo: $c_pokoje ).

"; echo "

Návrat na formulář úpravy uživatele

"; break;} endif; $zak_cislo = 0; echo "Rezervace pokoje číslo $c_pokoje v termínu od $od_den.$od_mes.$od_rok do $do_den.$do_mes.$do_rok uložena. "; $dbdata = mysql_query ("INSERT INTO pobyty VALUES ( '$c_pobytu', '$c_pokoje', '$zak_cislo', '$stav', '$od', '$do', '$aktual_ts','$dbuser' );"); echo "

Přiřadit hosta

"; break; case "Uložit": $dbdata = mysql_query ("SELECT * FROM pobyty WHERE (C_POBYTU = '$c_pobytu');"); $rows = mysql_num_rows ($dbdata); echo "

"; if ($rows != 1): echo "Nastala neočekávaná chyba v databázi

"; echo "Kontaktujte prosím technického správce.

Tabulka rezervací

"; break; endif; echo "Rezervace aktualizována"; $dbdata = mysql_query ("UPDATE pobyty SET C_POKOJE='$c_pokoje', ZAK_CISLO='$zak_cislo', STAV='$stav', OD='$od', DO='$do', P_TS='$aktual_ts', P_ZAPSAL='$dbuser' WHERE ( C_POBYTU = $c_pobytu ) ;"); echo "

Tabulka rezervací

"; break; case "del": echo "

Chcete zrušit rezervaci ?

"; echo "Zrušit "; echo "Nerušit

"; break; case "delete": echo "

Rezervace zrušena."; $dbdata = mysql_query ("DELETE FROM pobyty WHERE C_POBYTU = '$c_pobytu';"); echo "

Tabulka rezervací

"; break; case "list": if (!isset($act_mes)){$act_mes = date("m");}$act_mes = str_pad($act_mes, 2, "0", STR_PAD_LEFT); if (!isset($act_rok)){$act_rok = date("Y");} if ($act_mes == 1){$mesic = "leden";} if ($act_mes == 2){$mesic = "únor";} if ($act_mes == 3){$mesic = "březen";} if ($act_mes == 4){$mesic = "duben";} if ($act_mes == 5){$mesic = "květen";} if ($act_mes == 6){$mesic = "červen";} if ($act_mes == 7){$mesic = "červenec";} if ($act_mes == 8){$mesic = "srpen";} if ($act_mes == 9){$mesic = "září";} if ($act_mes == 10){$mesic = "říjen";} if ($act_mes == 11){$mesic = "listopad";} if ($act_mes == 12){$mesic = "prosinec";} $pre_mes = $act_mes - 1; $nas_mes = $act_mes + 1; $pre_rok = $act_rok; $nas_rok = $act_rok; if ($pre_mes == 0){$pre_mes = 12; $pre_rok = $act_rok - 1;} if ($nas_mes == 13){$nas_mes = 1; $nas_rok = $act_rok + 1;} $pre_mes = str_pad($pre_mes, 2, "0", STR_PAD_LEFT); $nas_mes = str_pad($nas_mes, 2, "0", STR_PAD_LEFT); echo "Předchozí
Následující"; echo " Tabulka rezervací - měsíc $mesic "; echo ""; echo "
"; echo ""; echo ""; echo ""; echo ""; echo "
"; echo ""; echo ""; $pokoju = 25; $dnu = 31; $c_pokoje = 0; $bet_min = "$act_rok"."$act_mes"."01130000"; $bet_max = "$act_rok"."$act_mes"."31120000"; while ( $c_pokoje <= $pokoju ): echo ""; if ($c_pokoje != 0): $dbdatap = mysql_query("SELECT * FROM pobyty WHERE (C_POKOJE = $c_pokoje) and (OD or DO BETWEEN $bet_min AND $bet_max) ORDER BY OD;"); $i=1; $pokoj = ""; while ($vetap = mysql_fetch_array($dbdatap)): $od = trim($vetap["OD"]); $do = trim($vetap["DO"]); $od_den = substr ($od, 6, 2); $od_mes = substr ($od, 4, 2); $od_rok = substr ($od, 0, 4); $do_den = substr ($do, 6, 2); $do_mes = substr ($do, 4, 2); $do_rok = substr ($do, 0, 4); if ($od_mes == $act_mes): $zobraz_den = $od_den;$zobraz_mes = $act_mes; elseif ($od_mes == $pre_mes): $zobraz_den = "01";$zobraz_mes = $act_mes; else: echo "Chyba"; endif; $pokoj[$od]["ODD"] = $od_den; $pokoj[$od]["ODM"] = $od_mes; $pokoj[$od]["ODR"] = $od_rok; $pokoj[$od]["DOD"] = $do_den; $pokoj[$od]["DOM"] = $do_mes; $pokoj[$od]["DOR"] = $do_rok; $pokoj[$od]["ZD"] = $zobraz_den; $pokoj[$od]["ZM"] = $zobraz_mes; $pokoj[$od]["COLL"] = $do_den - $zobraz_den; $pokoj[$od]["ZAKC"] = trim($vetap["ZAK_CISLO"]); $pokoj[$od]["STAV"] = trim($vetap["STAV"]); $i++; endwhile; endif; if(!isset($pokoj[1]["COLL"]){$pokoj[1]["COLL"] = 3;; for ($den = 0 ; $den <= $dnu ; $den++ ): if( $den != 0 ):$collsp = 0; else: $collsp = 0; endif; if (($den == 1) and ($c_pokoje == 1)) {$cl="BHL";} if (($den != 1) and ($den != $dnu) and ($c_pokoje == 1)) {$cl="BH";} if (($den == $dnu) and ($c_pokoje == 1)) {$cl="BHP";} if (($den == 1) and ($c_pokoje != 1) and ($c_pokoje != $pokoju)) {$cl="BZL";} if (($den != 1) and ($den != $dnu) and ($c_pokoje != 1) and ($c_pokoje != $pokoju)) {$cl="BZ";} if (($den == $dnu) and ($c_pokoje != 1) and ($c_pokoje != $pokoju)) {$cl="BZP";} if (($den == 1) and ($c_pokoje == $pokoju)) {$cl="BZL";} if (($den != 1) and ($den != $dnu) and ($c_pokoje == $pokoju)) {$cl="BZ";} if (($den == $dnu) and ($c_pokoje == $pokoju)) {$cl="BZP";} if ( ($c_pokoje == 0) and ($den == 0) ): $cl = "BR"; echo " \n"; elseif ( ($c_pokoje == 0) and ($den != 0) ): $cl = "BDEN"; echo " \n"; elseif ( ($c_pokoje != 0) and ($den == 0) ): $cl = "BZL"; echo " \n"; elseif ( ($c_pokoje != 0) and ($den != 0) ): $csp = $collsp; if ((!isset($csp)) or ($csp == 0 )): $csp = 0; $cs = ""; elseif ( $den + $csp - 1 > $dnu ): $csp = $dnu - $den + 1; $cs = "colspan="."$csp"; $den = $den + $csp - 1; else: $cs = "colspan="."$csp"; $den = $den + $csp - 1; endif; echo " \n"; endif; endfor; if ($c_pokoje != 0) {echo "";} if ($c_pokoje != 0){$dbdatap = mysql_query("SELECT * FROM pobyty WHERE (C_POKOJE = $c_pokoje) and (OD or DO BETWEEN $bet_min AND $bet_max) ORDER BY OD;");} for ($den = 0 ; $den <= $dnu ; $den++ ): if (($den == $dnu) and ($c_pokoje == $pokoju)) {$cl="BDP";} if (($den != 1) and ($den != $dnu) and ($c_pokoje == $pokoju)) {$cl="BD";} if (($den == 1) and ($c_pokoje == $pokoju)) {$cl="BDL";} if (($den == 1) and ($c_pokoje != 1) and ($c_pokoje != $pokoju)) {$cl="BKL";} if (($den != 1) and ($den != $dnu) and ($c_pokoje != 1) and ($c_pokoje != $pokoju)) {$cl="BK";} if (($den == 1) and ($c_pokoje == 1)) {$cl="BKL";} if (($den == $dnu) and ($c_pokoje != 1) and ($c_pokoje != $pokoju)) {$cl="BKP";} if (($den != 1) and ($den != $dnu) and ($c_pokoje == 1)) {$cl="BK";} if (($den == $dnu) and ($c_pokoje == 1)) {$cl="BKP";} if ( ($c_pokoje != 0) and ($den == 0) ): $cl = "BKL"; echo " \n"; elseif ( ($c_pokoje != 0) and ($den != 0) ): $csp = $collsp; if ((!isset($csp)) or ($csp == 0)): $csp = 0; $cs = " "; elseif ( $den + $csp - 1 > $dnu ): $csp = $dnu - $den + 1; endif; if ( $csp == 0 ): $act_den = str_pad($den, 2, "0", STR_PAD_LEFT); $v_od = "$act_rok"."$act_mes"."$act_den"."130000"; echo " \n"; else: $cs = "colspan="."$csp"; $den = $den + $csp - 1; $v_od = ""; echo " \n"; endif; endif; endfor; echo ""; $c_pokoje++; endwhile; echo "

"; echo ""; echo "$act_mes"; echo ""; echo "	"; echo ""; echo " $den "; echo ""; echo "	"; echo ""; echo " "; echo ""; echo "	"; echo ""; echo " $collsp "; echo ""; echo "
"; echo ""; echo " $c_pokoje "; echo ""; echo "	"; echo "Volné"; echo "	"; echo "V"; echo "

"; echo "
"; break; case "edit": $un = urldecode($un); $dbdata = mysql_query ("SELECT * FROM users WHERE (USERNAME = '$un');"); $veta = mysql_fetch_array($dbdata); $prava = 1; switch ($prava) { case 1: $edttile = "Změna"; $noedit1 = " "; break; default: $edttile = "Prohlížení"; $noedit1 = "DISABLED"; } echo ""; break; case "add": $dbdatap = mysql_query ("SELECT * FROM pobyty ORDER BY C_POBYTU;"); while ($vetap = mysql_fetch_array($dbdatap)): $last_cislo = trim($vetap["C_POBYTU"]); endwhile; if (!isset($last_cislo)){$last_cislo = 0;} $c_pobytu = $last_cislo + 1; $od_den = substr ($od, 6, 2); $od_mes = substr ($od, 4, 2); $od_rok = substr ($od, 0, 4); echo "