Zpět na seznam"; @$id = $_GET["id"]; if ($id) { $handle = DBConnect(); @$vysledek = mysqli_query($handle, "SELECT D.* FROM DOJO D WHERE D.ID_DOJO='".$id."'"); if ($zaznam = mysqli_fetch_array($vysledek)) { echo "

".@$zaznam["NAME"]."

\n"; //---------- echo "
\n"; echo "

Město

\n"; echo "

".@$zaznam["GROUPCITY"]."

\n"; echo "
"; //---------- echo "
\n"; echo "

Adresa

\n"; echo "

".@$zaznam["STREET"]."

\n"; echo "

".@$zaznam["ZIP"]." ".@$zaznam["CITY"]."

\n"; echo "

".@$zaznam["WWW"]."

\n"; echo "

".@$zaznam["EMAIL"]."

\n"; echo "
"; //---------- echo "
\n"; echo "

Zástupci klubu

\n"; @$vysl_person = mysqli_query($handle, "SELECT P.*, R.* FROM PERSON P, REPRESENT R " ." WHERE R.PERSON_ID=P.ID_PERSON AND R.DOJO_ID=".$id ." ORDER BY FIELD(R.FUNCTION, 'S', 'Z', 'V') DESC"); while ($zaznam_person = mysqli_fetch_array($vysl_person)) { echo "

"; switch (strtolower($zaznam_person["FUNCTION"])) { case 'v': echo 'Vedoucí: '; break; case 'z': echo 'Zástupce: '; break; case 's': echo 'Sekretář: '; break; case 'p': echo 'Pokladník: '; break; } echo $zaznam_person["NAME"]." ".$zaznam_person["SURNAME"]; if ($zaznam_person["PHONE_CELL"] != "") { echo " / ".$zaznam_person["PHONE_CELL"]; } if ($zaznam_person["EMAIL"] != ""){ echo " / ".$zaznam_person["EMAIL"].""; } echo "

\n"; } echo "
"; //---------- echo "
\n"; echo "

Učitelé

\n"; @$vysl_person = mysqli_query($handle, "SELECT P.*, T.* FROM PERSON P, TEACH T " ." WHERE T.PERSON_ID=P.ID_PERSON AND T.DOJO_ID=".$id ." ORDER BY T.ORD ASC"); while ($zaznam_person = mysqli_fetch_array($vysl_person)) { echo "

"; echo $zaznam_person["NAME"]." ".$zaznam_person["SURNAME"]; $grade = getUserGrade($handle, $zaznam_person["ID_PERSON"]); if ($grade != "") { echo " (".$grade.")"; } echo "

\n"; } echo "
"; //---------- echo "
\n"; echo "

Rozvrh

\n"; @$vysledek2 = mysqli_query($handle, "SELECT DISTINCT DAY_OF_WEEK " ." FROM SCHEDULE " ." WHERE DOJO_ID = $id " ." ORDER BY FIELD(DAY_OF_WEEK, 'Po', 'Út', 'St', 'Čt', 'Pá', 'So', 'Ne')"); while (@$zaznam2 = mysqli_fetch_array($vysledek2)) { echo "

".@$zaznam2["DAY_OF_WEEK"]."

\n"; @$result2 = mysqli_query($handle, "SELECT * FROM SCHEDULE " ." WHERE DOJO_ID = $id " ." AND DAY_OF_WEEK = '".@$zaznam2["DAY_OF_WEEK"]."' " ." ORDER BY FIELD(LEFT(HOURS, 2), '00', '01', '1:', '02', '2:', '03', '3:', '04', '4:', '05', '5:', '06', '6:', '07', '7:', '08', '8:', '09', '9:', " ." '10', '11', '12', '13', '14', '15', '16', '17', '18', '19', '20', '21', '22', '23', '24'), HOURS "); while (@$zaznam3 = mysqli_fetch_array($result2)) { echo "

".@$zaznam3["HOURS"]." - ".@$zaznam3["TRAIN_TYPE"]."

"; } } echo "
"; } } echo "
Zpět na seznam
"; ?>