<?

use Rshu\Site\App;


$conn = App::connect();

$res = $conn->query("
SELECT struct.id, struct.parent, struct.name, struct.weblink,struct.mainPhone,struct.mainLocalPhone, struct.mainEmail,struct.pologenieLink,struct.pologenieOULink, Address.address
FROM rshu_struct2.struct
LEFT JOIN rshu_struct2.Address ON struct.idAddress = Address.id 
WHERE struct.show_in_struct order by struct.sortorder
") or die($conn->error);
$structArr = array();
while(($assoc = $res->fetch_assoc())) {

	$res2 = $conn->query("
	SELECT structChief.idStruct, dolgn.name, person.fio, structChief.posPhone, structChief.posEmail 
	FROM rshu_struct2.structChief
	LEFT JOIN rshu_struct2.dolgn ON structChief.idDolgn = dolgn.id
	LEFT JOIN rshu_struct2.person ON structChief.tabn = person.tabn
	WHERE structChief.idStruct = $assoc[id]
	ORDER BY structOrder
	");
	echo $conn->error;
	$chiefArr = array();
	while(($assoc2 = $res2->fetch_assoc())) {
		$chiefArr[] = $assoc2;
	}
	$res2->free();
	$assoc["chiefArr"] = $chiefArr;
	$assoc["children"] = array();
	$structArr[$assoc["id"]] = $assoc;
}
$res->free();

$structRoot = array();
foreach($structArr as $key => $val) {
	if ($val["parent"]) {
		$structArr[$val["parent"]]["children"][] = $key;
	} else {
		$structRoot[] = $key;
	}
}


$content = "/sveden/struct/include.inc";
$style = "/sveden/css/sveden-special.inc";
$title = "РГГМУ | Структура и Органы Управления Образовательной Организацией";
include $_SERVER["DOCUMENT_ROOT"]."/template/template.inc";