<?php
 /************************************************************
  ***  © Copyright == Emeni Automatiseringstechnieken      ***
  ***  Krekelberg 82, 4708 KP Roosendaal              	   ***
  ***  Telefoon: 0165 - 571241                             ***
  ***  E-mail: info@emeni.nl / www.emeni.nl                ***
  ************************************************************/

	ob_start();
	session_start();
	date_default_timezone_set("Europe/Amsterdam");

	if (isset($_SESSION['code']) && $_SESSION['code'] != "") {
		ini_set("display_errors", "On");
		error_reporting(E_ALL);
	}
  
	# inludes
	require_once("_include/config.php");

	# pagina
	if (isset($_GET['pagid'])) {
		$pagid = intval($_GET['pagid']);
		if ($pagid == "") {
			$pagid = 1;	
		}	
	} 
	else { $pagid = 1; }

	# taal
	if (isset($_GET['lan'])) {
		$lan = mysql_real_escape_string($_GET['lan']);
		if ($lan == "") {
			$lan = "nl";	
		}	
	} 
	else { $lan = "nl"; }

	$check_lan = array("nl", "en");
	if (!in_array($lan, $check_lan)) {	
		$lan = "nl";
	}
	$_SESSION['lan'] = $lan;

	if ($lan != "nl") { 
		$extra = "_".$lan;
	} else { $extra = ""; }
		
	#controleren of pagina bestaat (en actief is) > zo niet dan naar homepage
  if ($db->recordsTellen("id", "tblcontent", "where id=".$pagid."
			and case when IsNull(datumstart)=0 then datediff(datumstart, curdate()) else 0 end <= 0
			and case when IsNull(datumeind)=0 then datediff(datumeind, curdate()) else 0 end >= 0
			and status=0") == 0) { 
		$pagid = 1;
  }

  # paginagegevens
	$arrPag = $cms->paginaGegevens($pagid, $extra);	
	$pag_tekst = $arrPag['tekst'];
	$parents = array($arrPag['parents']);

	# basis gegevens website
	$arrSite = $cms->websiteBasis();	

  # controle beveiligde pagina (op basis van groepenstructuur)
  if ($arrPag['beveiligd'] == 1 && $arrSite['beveiliging'] == 17) {
     # pagina is beveiligd > controleer of bezoeker is ingelogd
     $checkloginSITE = $cms->CheckSITELogin();

     if ($checkloginSITE != "yes") {
        # gebruiker is niet ingelogd > redirect naar inlogpagina
        header("location:/default.php?pagid=3&lan=".$lan);
     }
     else {
				$bezoekersid = $db->veldOphalen ("id", "tblbezoekers", "where code='".$_SESSION['SITEcode']."'");
        $checkrechten = $db->veldOphalen("id","tblbezoekersgroepen",
         "where bezoekersid in ('".$bezoekersid."') and groepid in (".$arrPag['groepen']."0)");   
        if ($checkrechten == "") {
						# bezoeker heeft niet de juist rechten > redirect naar meldingspagina
						header("location:/default.php?pagid=6&lan=".$lan);
        }
    }
  }

  # controle beveiligde pagina (op basis van ip-adres)
  else if ($arrPag['beveiligd'] == 1  && $arrSite['beveiliging'] == 16) {
		$checkip = $db->veldOphalen("id", "tblip", "where ip='".$_SERVER['REMOTE_ADDR']."'");
		if ($checkip == "") {
			header("location:/default.php?pagid=6&lan=".$lan);
		}
		else {
			$checkloginSITE = "yes";
		}
  }  

  else { 
		$checkloginSITE = $cms->CheckSITELogin();
		if (isset($_SESSION['SITEcode'])) {
			$bezoekersid = $db->veldOphalen ("id", "tblbezoekers", "where code='".$_SESSION['SITEcode']."'");
		}
		else { $bezoekersid = 0; }
  }

	# redirect 
	if ($arrPag['linkpagina'] != "") {
		/*header("HTTP/1.1 301 Moved Permanently");*/
		header("location:".$arrPag['linkpagina']);
	}  

	# template
	$template = str_replace("_tpl_", "", $arrPag['sjabloon']);
	$template = str_replace(".htm", "", $template);
	$arrTemplate = array("leeg", "nieuwsbrief");
	if (!in_array($template, $arrTemplate)) { 
		$tpl = $cms->leesTemplate("header", "sub").$cms->leesTemplate($template).$cms->leesTemplate("footer", "sub");
	} 
	else {
		$tpl = $cms->leesTemplate($template);		
	}

	# basisgegevens website
	$arrSite = $cms->websiteBasis();
	$_SESSION['SITEemail_afzender'] = $arrSite['email_afzender'];
	$_SESSION['SITEemail_beheerder'] = $arrSite['email_beheerder'];

	# teksthema-afbeelding
	if ($arrSite['image_thema'] == 1) {
		$pag_image = $arrPag['image_thema'];
		if (is_file($_SERVER['DOCUMENT_ROOT']."/site/images/thema/".$pag_image)) {
			$pag_afbeelding_alt = $db->veldOphalen("omschrijving", "tblfotos", "where concat(folder, '/', naam) ='".$pag_image."'");
			$pag_afbeelding = "<img src=\"/site/images/thema/".$pag_image."\" class=\"thema ".$arrSite['stijl']."\" alt=\"".$pag_afbeelding_alt."\" title=\"".$pag_afbeelding_alt."\" />";
			$tpl = str_replace("[pag_afbeelding_thema]", $pag_afbeelding, $tpl);
		} 
	}

	# tekst-afbeelding
	if ($arrSite['image_content'] != 13) {
		$pag_image = $arrPag['image_content'];
		if (is_file($_SERVER['DOCUMENT_ROOT']."/site/images/content/".$pag_image)) {
			$pag_afbeelding_alt = $db->veldOphalen("omschrijving", "tblfotos", "where concat(folder, '/', naam) ='/images/content/".$pag_image."'");
			if ($pag_afbeelding_alt == "") { $pag_afbeelding_alt = "{lbl_fototoelichting}"; }
			/*$pag_afbeelding = "<a href=\"/site/images/content/".$pag_image."\" class=\"fancybox\" title=\"".$pag_afbeelding_alt."\"><img src=\"/site/images/content/".$pag_image."\" class=\"foto ".$arrSite['stijl']."\" alt=\"".$pag_afbeelding_alt."\" title=\"".$pag_afbeelding_alt."\" /></a>";*/
			$pag_afbeelding = "<img src=\"/site/images/content/".$pag_image."\" alt=\"".$pag_afbeelding_alt."\" title=\"".$pag_afbeelding_alt."\" /><br /><br />";

			
			$tpl = str_replace("[pag_afbeelding_content]", $pag_afbeelding, $tpl);
		} 
	}

	# header
	if ($arrSite['headers'] == 1) {
		$header_overrule = $db->veldOphalen("concat('<span class=\"header\">', naam, '</span>')", "tblheaders", "where overrule=1", "header");
		if ($header_overrule != "") {
			$pag_header = $header_overrule;
		}
		else {
			if ($arrPag['header'] == 0) { 
				$pag_header = $db->veldOphalen("concat('<span class=\"header\">', naam, '</span>')", "tblheaders", "where standaard=1", "header");
			} 
			else {
				$pag_header = $db->veldOphalen("concat('<span class=\"header\">', naam, '</span>')", "tblheaders", "where id=".$arrPag['header'], "header");
			}
		}
		$tpl = str_replace("[pag_header]", $pag_header, $tpl);
	}
	
	# banner
	if ($arrSite['banners'] == 1) {
		$pag_banner = "";
		$sql = "select id, afbeelding, naam, link from tblbanners where overrule=1";
		$record = $db->recordOphalen($sql);
		if (!empty($record)) {
			$pag_banner = $record['afbeelding'];
			$pag_banner_link = $record['link'];
			$pag_banner_alt = $record['naam'];	
		}
		else {
			$banner = $arrPag['banner'];
			if ($banner == 0) { 
				$sql = "select id, afbeelding, naam, link from tblbanners where standaard=1";
				$record = $db->recordOphalen($sql);
				if (!empty($record)) {
					$pag_banner = $record['afbeelding'];
					$pag_banner_link = $record['link'];
					$pag_banner_alt = $record['naam'];
				}
			}
			else {
				$sql = "select id, afbeelding, naam, link from tblbanners where id=".$banner;
				$record = $db->recordOphalen($sql);
				if (!empty($record)) {
					$pag_banner = $record['afbeelding'];
					$pag_banner_link = $record['link'];
					$pag_banner_alt = $record['naam'];	
				}
			}
		}
		if ($pag_banner != "") {
			$tpl = str_replace("[pag_banner]", "<a href=\"".$pag_banner_link."\" class=\"extern\"><img src=\"/site/images/banner/".$pag_banner."\" alt=\"".$pag_banner_alt."\" /></a>", $tpl);
		}
	}

	# tekstkoppeling
	if ($arrSite['tekstkoppeling'] == 1 && $arrPag['tekstkoppeling'] != "") {
		$pag_tekstkoppeling = $db->veldOphalen("tekst".$extra, "tblteksten", "where id=" . $arrPag['tekstkoppeling'], "tekst");
		$tpl = str_replace("[pag_tekstkoppeling]", $pag_tekstkoppeling, $tpl);
	}

	# menu
	if (is_file($hostpath."site/php/menu.php")) {
		include ("site/php/menu.php");
	}		

	# taalswitch
	if($pagid == 35) {
		$pag_urlextra = "/" . $db->veldOphalen("url", "tblwoningen", "where id=" . intval($_GET['item']));
	} else { $pag_urlextra = ""; }

  if ($lan == "en") {
		$pag_url = $_SERVER['SERVER_NAME'] . "/" . $arrPag['link'];
    $tpl = str_replace("[pag_en]",  "<span>{lbl_taalswitch_en}</span>", $tpl);
    $tpl = str_replace("[pag_nl]",  "<a href=\"/" . $arrPag['link'] . $pag_urlextra . "\">{lbl_taalswitch_nl}</a>", $tpl);
    $tpl = str_replace("[pag_homeurl]", $db->veldOphalen("url_en", "tblcontent", "where id=1"), $tpl);
  }
  else {
		$pag_url = $_SERVER['SERVER_NAME']. "/" . $arrPag['link_en'];
    $tpl = str_replace("[pag_en]",  "<a href=\"/" . $arrPag['link_en'] . $pag_urlextra . "\">{lbl_taalswitch_en}</a>", $tpl);
    $tpl = str_replace("[pag_nl]",  "<span>{lbl_taalswitch_nl}</span>", $tpl);
    $tpl = str_replace("[pag_homeurl]", $db->veldOphalen("url", "tblcontent", "where id=1"), $tpl);
  }
	$tpl = str_replace("[pag_url]", $pag_url, $tpl);
	$tpl = str_replace("[pag_lan]", $lan, $tpl);

	# onderliggende pagina's
	if ($arrPag['toonkinderen'] == 1) {
		$sql = "select titel".$extra." as naam, s.url".$extra." as link, samenvatting".$extra." as introtekst 
			from tblcontent c
			left join tblseourls s on c.id=s.pagid
			where c.parent=".$pagid." order by ".$arrPag['sortorder_kinderen'];
		$records = $db->recordsetOphalen($sql);
		if (!empty($records)) {
			$kinderen = "<div id=\"children\"><ul>";
			foreach ($records as $record) {
				$kinderen .= "<li><h2>" . $record['naam'] . "</h2><p>" . $record['introtekst'] . "</p>
					<a href=\"/".$record['link']."\" class=\"readmore\">{lbl_leesverder}</a></li>";
			}
			$kinderen .= "</ul></div>";
		}
		$tpl = str_replace("[pag_kinderen]", $kinderen, $tpl); 		
	}	
	
	# siblings
	if ($arrPag['toonsiblings'] == 1) {
		$sql = "select titel".$extra." as naam, s.url".$extra." as link 
			from tblcontent c
			left join tblseourls s on c.id=s.pagid
			where c.parent=".$arrPag['parent']." and c.id not in (".$pagid.") order by ".$arrPag['sortorder_siblings'];
		$records = $db->recordsetOphalen($sql);
		if (!empty($records)) {
			$siblings = "<ul id=\"links\">";
			foreach ($records as $record) {
				$siblings .= "<li><a href=\"/".$record['link']."\">".$record['naam']."</a></li>";
			}
			$siblings .= "</ul>";
		}
		$tpl = str_replace("[pag_siblings]", $siblings, $tpl); 		
	}	

	# bijlagen
	if ($arrSite['documenten'] == 1) {
		$sql = "select nummer, naam, omschrijving from tblfotos 
			where folder = '/docs/" . $arrPag['documenten'] . "'
			order by nummer";
		$records = $db->recordsetOphalen($sql);
		if (!empty($records)) {
			$pag_documenten = "<div id=\"bijlages\"><div class=\"kop\">" . $arrPag['kop_documenten'] . "</div><ul>";
			foreach ($records as $record) {
				$filetype = $exp->getFiletype($record['naam']);
				$pag_documenten .= "<li class=\"" . $exp->getFiletype($record['naam']) . "\">
					<a href=\"/site/docs/" . $arrPag['documenten'] . "/" . $record['naam'] . "\" class=\"extern\">" .$record['omschrijving'] . "</a> (Download PDF)</li>";
			}
			$pag_documenten .= "</ul></div>";
			$tpl = str_replace("[pag_documenten]", $pag_documenten, $tpl); 	
		}

	}

	# vervangingen
	$pag_naam = $arrPag['naam'.$extra];
	$pag_navtitel = $arrPag['navtitel'.$extra];
	$pag_titel = $arrPag['titel'.$extra];
	$pag_tekst = $arrPag['tekst'.$extra];
	$pag_keywords = $arrPag['keywords'.$extra];
	$pag_description = $arrPag['description'.$extra];
	$pag_samenvatting = $arrPag['samenvatting'.$extra];

	# script
	if ($arrPag['script'] != "0") {
		if (is_file($hostpath."site/php/".$arrPag['script'])) {	
			include ("site/php/".$arrPag['script']);
		}		
	}
	
	$tpl = str_replace("[pag_keywords]", $pag_keywords, $tpl);
	$tpl = str_replace("[pag_description]", $pag_description, $tpl);
	$tpl = str_replace("[pag_titel]", $pag_titel, $tpl);
	$tpl = str_replace("[pag_navtitel]", $pag_navtitel, $tpl);
	$tpl = str_replace("[pag_naam]", $pag_titel, $tpl);
	$tpl = str_replace("[pag_tekst]", $pag_tekst, $tpl);
	$tpl = str_replace("[pag_samenvatting]", $pag_samenvatting, $tpl);

	$tpl = str_replace("[url_nl]", $arrPag['link'], $tpl);
	$tpl = str_replace("[url_en]", $arrPag['link_en'], $tpl);
	$tpl = str_replace("[pag_taal]", $lan, $tpl);

	# foto-album
	$folder = $cms->zoekTussen($pag_tekst, "[fotos_", "]");
	if ($folder != "") {
		$tpl = str_replace("[fotos_".$folder."]", $exp->toonFotos($folder), $tpl);		
	}
	 
  # taalswitch
  if ($arrSite['tweetalig'] == "1") {
		$tpl = str_replace("[pag_taalswitch]", $cms->leesTemplate("taalswitch", "sub"), $tpl); 
  	if ($lan == "nl") {
  		$tpl = str_replace("[pag_nl]", "<span>{lbl_nl}</span>", $tpl);
  		$tpl = str_replace("[pag_en]", "<a href=\"/" . $arrPag['link_en'] . "\">{lbl_en}</a>", $tpl);  
  	}
  	else {
  		$tpl = str_replace("[pag_nl]", "<a href=\"" . $arrPag['link'] . "\">{lbl_nl}</a>", $tpl);
  		$tpl = str_replace("[pag_en]", "<span>{lbl_en}</span>", $tpl);  		  		
  	}
  }

	# vertalingen
	$sql = "select naam, nl, ".$lan." as translation from tblvertalingen";
	$vertalingen = $db->recordsetOphalen($sql);
	foreach ($vertalingen as $vertaling) {
		$trans = $vertaling['translation'];
		if ($trans == "") { $trans = $vertaling['nl']; }
		$trans = str_replace("[break]", "<br />", $trans);
		$trans = str_replace("[", "<", $trans);
		$trans = str_replace("]", " />", $trans);
		$trans = str_replace("&quot;", "\"", $trans);
		$trans = str_replace("&amp;euro;", "&euro;", $trans);
		$tpl = str_replace("{".$vertaling['naam']."}", $trans, $tpl);
	}

  foreach ($arrSite as $key => $field) {
		$tpl = str_replace("[pag_site_".$key."]", $field, $tpl);
  }  

	# opschonen
	$tpl = preg_replace("{\[pag_([a-zA-Z0-9z_]+)]}", "", $tpl);
	$tpl = preg_replace("{\[fotos_([a-zA-Z0-9z_]+)]}", "", $tpl);
	$tpl = preg_replace("{\[v_([a-zA-Z0-9_]+)]}", "", $tpl);
	$tpl = str_replace("[pag_jsdocumentready]", "", $tpl);
	$tpl = str_replace("[pag_js]", "", $tpl);

	# utf-8 header
	if ($pagid != 11) {
		header("Content-type: text/html; charset=utf-8");
	}

	# vervanging target=blank
	$tpl = str_replace("target=\"_blank\"", "class=\"extern\"", $tpl);

	# output
	echo $tpl;

  ob_end_flush();
?>