Univerzitní mateřská škola Qočna

nám. T. G. Masaryka 3050
760 01, Zlín
sídlí v budově U12

+420 576 036 015

www.qocna.utb.cz


Ředitelna UMŠ

+420 733 593 654, +420 576 036 012


Slunečná třída

+420 57 603 6012


Dešťová třída

+420 57 603 6013


Duhová třída

+420 57 6036 014


Chůvy



Provozní tým



Rada ŠPO



URL PARSER GLOBALS

Folder::array (
  0 => 'www',
  1 => 'kontakty',
)
File::index.php
Get::array (
)

USER STATUS _SESSION

login:
password:

INCLUDE FILES

Files::array (
  0 => '/www/www/_main.php',
  1 => '/www/www/+head.php',
  2 => '/www/www/+header.php',
  3 => '/www/www/kontakty/_index.php',
  4 => '/www/www/kontakty/index.php',
  5 => '/www/www/kontakty/+menu.php',
  6 => '/www/www/+footer.php',
  7 => '/www/www/+foot.php',
)

MYSQL CONNECTIONS 19

	SELECT *
	FROM global_data
	SELECT *
	FROM menu
	WHERE menu_type = 0
	ORDER BY rank, id
		SELECT *
		FROM price

		ORDER BY date DESC
		LIMIT 1
	
		SELECT *
		FROM price

		WHERE date >= '2019-09-01'
		AND date <= '2020-06-30'
	
		SELECT *
		FROM price_teacher

		ORDER BY date DESC
		LIMIT 1
	
		SELECT *
		FROM price_teacher

		WHERE date >= '2019-09-01'
		AND date <= '2020-06-30'
	
	SELECT	menu.*,
			menu_type.link as dir,
			menu_type.color,
			menu_type.name as dir_name
	FROM menu
	LEFT JOIN menu_type
	ON menu.menu_type = menu_type.id

	WHERE menu.link = 'kontakty'
	LIMIT 1
	SELECT *
	FROM class_type



	ORDER BY rank, id
	SELECT m.*,
		p.id as parent_id,
		p.email as email,
		p.phone as phone
	FROM member as m

	LEFT JOIN parent_member as pm
	ON pm.member = m.id

	LEFT JOIN parent as p
	ON pm.parent = p.id

	WHERE m.member_type = 1
	SELECT *
	FROM class_type
	WHERE kids = 1
	SELECT 	A.*,
			t.name as position

	FROM(
		SELECT 	m.*

		FROM member as m

		LEFT JOIN class_type as ct
		ON ct.id = m.class_type

		WHERE kids = 1
		AND ( teacher_type = 3 OR teacher_type = 4 )
		AND member_type = 1
	) as A

	LEFT JOIN teacher_type as t
	ON A.teacher_type = t.id
	SELECT *
	FROM class_type
	WHERE kids = 0
	SELECT *
	FROM class_type
	WHERE kids = 0
	SELECT 	m.*,
			ct.name as ct_name,
			ct.kids

	FROM member as m

	LEFT JOIN class_type as ct
	ON ct.id = m.class_type

	WHERE member_type = 1
	AND ( kids IS NULL
		OR kids = 0
	)
	SELECT *
	FROM class_type
	WHERE kids = 0
	SELECT 	A.*,
			t.name as position

	FROM(
		SELECT 	m.*,
				ct.name as ct_name,
				ct.kids

		FROM member as m

		LEFT JOIN class_type as ct
		ON ct.id = m.class_type

		WHERE member_type = 1

		ORDER BY surname, name
	) as A

	LEFT JOIN teacher_type as t
	ON A.teacher_type = t.id
	SELECT 	A.*,
			t.name as position

	FROM(
		SELECT 	m.*,
				ct.name as ct_name,
				ct.kids

		FROM member as m

		LEFT JOIN class_type as ct
		ON ct.id = m.class_type

		WHERE member_type = 1

		ORDER BY surname, name
	) as A

	LEFT JOIN teacher_type as t
	ON A.teacher_type = t.id
	SELECT 	A.*,
			t.name as position

	FROM(
		SELECT 	m.*,
				ct.name as ct_name,
				ct.kids

		FROM member as m

		LEFT JOIN class_type as ct
		ON ct.id = m.class_type

		WHERE member_type = 1

		ORDER BY surname, name
	) as A

	LEFT JOIN teacher_type as t
	ON A.teacher_type = t.id
SELECT 	B.*,
		C.email as email,
		C.phone as phone
FROM (
	SELECT 	p.email as email,
			p.phone as phone,
			pm.member as member_id
	FROM parent as p
	LEFT JOIN parent_member as pm
	ON p.id = pm.parent
) as C

LEFT JOIN (
	SELECT 	A.*,
			t.name as position

	FROM(
		SELECT 	m.*,
				ct.name as ct_name,
				ct.kids

		FROM member as m

		LEFT JOIN class_type as ct
		ON ct.id = m.class_type

		WHERE member_type = 1

		ORDER BY surname, name
	) as A

	LEFT JOIN teacher_type as t
	ON A.teacher_type = t.id
) as B

on C.member_id = B.id

MODULES 21

mysql__
file__
folder__
mail__
img__
jquery__
bootstrap__
my_bootstrap__
log__
user__
access__
msg__
ajax__
mapycz__
photo_loader__
select_search__
js__
horizontal_menu__
qocna__