<?
//  $mydb	= $db->Database;
//	mysql_select_db("kiesmetzorg");
	if($id>0 || $alles=="waar"){
		$sectoren = $db->FetchAll("SELECT * FROM `kiesmetzorg`.`sectoren` ORDER BY titel");
		$smarty->Assign("sectoren", $sectoren);
		
		// mapping i.v.m. samenvoegen 2 regios's overijssel naar 1
		if($_GET['id'] == 15) {
			$id = 14;
		}

		$SQL = "SELECT id, naam, omschrijving, email, url, kwaliteit, actief, AWBZ FROM `kiesmetzorg`.`beheerders` WHERE rechten < 30";
		if($id>0) $SQL.= " AND id = $id";
		$SQL.= " ORDER BY regio";

		$db->Query($SQL);
		while($db->Next_Record()) $regios[$db->Record["id"]] = $db->Record;
		foreach($regios AS $id => $regio){
			$total = 0;
			# aantal instellingen per sector
			for($s=0;$s<count($sectoren);$s++){
				$SQL = "SELECT toelichting FROM `kiesmetzorg`.`beheerder_sector` WHERE beheerder_id = $id AND sector_id = ".$sectoren[$s]["id"];
				$regios[$id]["toelichting"][$sectoren[$s]["id"]] = $db->FetchField("toelichting", $SQL);
				# aantal instellingen
				$SQL = "SELECT COUNT(id) AS n FROM `kiesmetzorg`.`".$sectoren[$s]["tabelnaam"] . "`";
				$SQL.= " WHERE beheerder = $id AND status IN ('online')";
				$n = $db->FetchField("n", $SQL); $total+= $n;
				$regios[$id]["instellingen"][$sectoren[$s]["id"]] = $n;
				# AWBZ
				$SQL = "SELECT COUNT(instelling_id) AS n FROM `kiesmetzorg`.`instelling_awbz`, `kiesmetzorg`.`".$sectoren[$s]["tabelnaam"] ."`";
				$SQL.= " WHERE ".$sectoren[$s]["tabelnaam"].".id = instelling_awbz.instelling_id";
				$SQL.= " AND ".$sectoren[$s]["tabelnaam"].".beheerder = $id";
				$SQL.= " AND instelling_awbz.sector_id = ".$sectoren[$s]["id"];
				$regios[$id]["AWBZ"][$sectoren[$s]["id"]] = $db->FetchField("n", $SQL);
			}
			$regios[$id]["totaal"] = $total;
		}	
		
		$smarty->Assign("regios", $regios);
	}

	//$smarty->debugging=true;

	$smarty->Display("_tpl_kiesmz_deelname.html");
//	mysql_select_db($mydb);

	

function capital($s){
	return strtoupper(substr($s,0,1)).substr($s,1);
}

?>