<?php

include('includes/connect.php');
include('includes/functions.php');

$id_project = $_GET['id_project'];

$sql_project = "
	SELECT
	  projecten.id_project,
	  projecten.id_categorie,
	  projecten.datum,
	  projecten.naam,
	  projecten.opdrachtgever,
	  projecten.website,
	  projecten.locatie,
	  projecten.aankomend,
	  projecten.werkzaamheden,
	  projecten.beschrijving,
	  projecten.hoofdfoto,
  	  categorie.categorie,
  	  projecten.youtube
	FROM
	  categorie
	  RIGHT OUTER JOIN projecten ON (categorie.id_categorie = projecten.id_categorie)
	WHERE projecten.id_project = $id_project
";

$result = mysql_query($sql_project);

while($row = mysql_fetch_array($result)){

	$id_project						= $row[0];
	$id_categorie					= $row[1];
	$datum							= NLDatumLong($row[2]);
	$naam							= $row[3];
	$opdrachtgever					= $row[4];
	$website						= $row[5];
	$locatie						= $row[6];
	$aankomend						= $row[7];
	$werkzaamheden					= $row[8];
	$beschrijving					= $row[9];
	$hoofdfoto						= $row[10];
	$categorie						= $row[11];
	$youtube						= $row[12];
}


if($aankomend == 'T'){
	$title = "Aankomend Event";
}else{
	$title = "GEREALISEERD PROJECT";
}

$sql_project_fotoos = "
	SELECT
	  foto.id_foto,
	  foto.id_project,
	  foto.naam,
	  foto.foto,
	  foto.volgorde
	FROM
	  foto
	WHERE foto.id_project = $id_project
";

$result_fotoos = mysql_query($sql_project_fotoos);

?>
<!DOCTYPE html>
<html lang="en-US">
<head>

<!-- Basic Page Head -->
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>INVERT EVENTS - DETAIL</title>
<meta name="description" content="<?php echo strip_tags($beschrijving); ?>">
<meta name="keywords" content="projecten, kermis, festivals, outdoorevenement, evenementen, evenement, outdoor, indoor, planning, festival">

<!-- Mobile Meta -->
<meta name="viewport" content="width=device-width, initial-scale=1.0, minimum-scale=1.0, maximum-scale=1.0, user-scalable=no">

<!-- Favicons -->
<link rel="shortcut icon" type="image/x-icon" href="assets/img/favicon.ico">
<link rel="apple-touch-icon-precomposed" href="assets/img/apple-touch-icon-precomposed.png">
<link rel="apple-touch-icon-precomposed" sizes="72x72" href="assets/img/apple-touch-icon-72x72-precomposed.png">
<link rel="apple-touch-icon-precomposed" sizes="114x114" href="assets/img/apple-touch-icon-114x114-precomposed.png">
<link rel="apple-touch-icon-precomposed" sizes="144x144" href="assets/img/apple-touch-icon-144x144-precomposed.png">

<!-- Css -->
<link rel="stylesheet" type="text/css" href="assets/css/bootstrap.min.css">
<link rel="stylesheet" type="text/css" href="assets/css/bxslider.css">
<link rel="stylesheet" type="text/css" href="assets/css/font.awesome.min.css">
<link rel="stylesheet" type="text/css" href="assets/css/magnific.popup.css">
<link rel="stylesheet" type="text/css" href="assets/css/owl.carousel.css">
<link rel="stylesheet" type="text/css" href="assets/css/owl.theme.css">
<link rel="stylesheet" type="text/css" href="assets/css/style.css">
<link rel="stylesheet" type="text/css" href="assets/css/responsive.css">

<!-- Google Fonts -->
<link href="http://fonts.googleapis.com/css?family=Roboto:300,400,500,700&amp;subset=latin,latin-ext" rel="stylesheet" type="text/css">
<link href="http://fonts.googleapis.com/css?family=Montserrat:400,700" rel="stylesheet" type="text/css">

</head>
<body>

<script>(function(d, s, id) {
  var js, fjs = d.getElementsByTagName(s)[0];
  if (d.getElementById(id)) return;
  js = d.createElement(s); js.id = id;
  js.src = "//connect.facebook.net/nl_NL/all.js#xfbml=1";
  fjs.parentNode.insertBefore(js, fjs);
}(document, 'script', 'facebook-jssdk'));</script>

<!-- Site Loader -->
<div class="site-loader">
	<img src="assets/img/loader.gif" alt="Loading">
</div>
<!-- Site Loader End -->

<!-- Site Back Top -->
<div class="site-back-top" title="Back to top">
	<i class="fa fa-angle-up"></i>
</div>
<!-- Site Back Top End -->

<!-- Site Header -->
<header>
	<div class="site-wrapper">
        <div class="site-header">
            <!-- Header Top -->
            <div class="header-top">
                <ul class="clearfix">
                    <li class="ht-phone"><i class="fa fa-phone"></i> &nbsp; +31 6 24 28 18 40</li>
                    <li class="ht-lang">
                        <div class="fm-social ">
                   			 <ul class="social-icons social-round clearfix">
                       			 <li class="facebook"><a href="https://www.facebook.com/InvertEvents" target="blank"><i class="fa fa-facebook"></i></a></li>
                        		 <li class="linkedin"><a href="http://nl.linkedin.com/pub/swen-roux/1a/2b3/118" target="blank"><i class="fa fa-linkedin"></i></a></li>
                    </ul>
                </div>
                    </li>
                    <li class="ht-search">

                    </li>
                </ul>
            </div>
            <!-- Header Top End -->

            <!-- Header Bottom -->
            <div class="header-bottom">
                <div class="hb-toggle"><i class="fa fa-bars"></i></div>
                <div class="hb-logo"><a href="index.php"><img src="assets/img/logo.png" alt="Invert events"></a></div>
                <div class="hb-menu">
                    <nav>
                        <ul class="clearfix">
							<li><a href="index.php" >Home</a></li>
                            <li><a href="over_invertevents.php">Wat doet Invert Events</a></li>
                            <li><a href="portfolio.php">Portfolio</a></li>
                            <li><a href="contact-1.php">Contact</a></li>
                        </ul>
                    </nav>
                </div>
            </div>
            <!-- Header Bottom End -->
        </div>
    </div>
    <div class="site-banner">
	<div class="banner-image">
    	<img src="assets/img/slide-1.jpg" alt="Banner">
    </div>
    <div class="banner-caption shadow">
    	<div class="caption-wrapper">
            <h1><?php echo $title; ?></h1>
            <p><?php echo $naam; ?></p>
        </div>
    </div>
</div>
</header>
<!-- Site Header End -->

<!-- Site Main -->
<main>
    <div class="site-wrapper">
        <!-- Section Breadcrumb -->
        <div class="site-block white" id="section-breadcrumb">
            <ol class="breadcrumb">
                <li><a href="index.php">Home</a></li>
                <li><a href="portfolio.php">Portfolio</a></li>
            </ol>
        </div>
        <!-- Section Breadcrumb End -->
        <!-- Section Work Detail -->
        <section class="site-block white" id="section-work-detail">
            <div class="row large">
                <div class="col-md-6 col-sm-6">
                    <h2 class="h1"><?php echo $naam; ?></h2>

                    <div class="works-info type-one">
                        <div class="row">
                            <div class="youtube">
									<?php echo $youtube; ?>
                            </div>
                            <div class="col-md-6 col-sm-6">
                                <h5>Opdrachtgever:</h5>
                                <p><?php echo $opdrachtgever; ?></p>
                            </div>
                            <div class="col-md-6 col-sm-6">
                                <h5>Werkzaamheden:</h5>
                                <p><?php echo $werkzaamheden; ?></p>
                            </div>
                            <div class="col-md-6 col-sm-6">
                                <h5>Datum:</h5>
                                <p><?php echo $datum; ?></p>
                            </div>
                             <div class="col-md-6 col-sm-12">
                                <h5>Locatie:</h5>
                                <p><?php echo $locatie; ?></p>
                            </div>
                            <div class="col-md-6 col-sm-12">
                                <h5>Website:</h5>
                                <p><a href="http://<?php echo $website; ?>" target="blank" class="text-blue"><?php echo $website; ?></a></p>
                            </div>
                        </div>
                    </div>
                    <p class="align-justify">
                    	<?php echo $beschrijving; ?>
                    </p>
                    <br>
                    <div class="fb-like" data-href="http://www.invertevents.nl/portfolio_detail.php?id_project=<?php echo $id_project; ?>" data-layout="standard" data-action="like" data-show-faces="true" data-share="true"></div>
					<div class="mobile-space"></div>
                </div>
                <div class="col-md-6 col-sm-6">
                    <div class="owl-five popup-gallery" id="owl-work">
<?php if(mysql_num_rows($result_fotoos) == 0){ ?>
                        <a href="fotoos/<?php echo $hoofdfoto; ?>"><img src="fotoos/<?php echo $hoofdfoto; ?>" alt="<?php echo $naam; ?>" class="img-full">
                        </a>

<?php
}else{
	while($row = mysql_fetch_array($result_fotoos)){
		  $id_foto			=	$row[0];
		  $id_project		=	$row[1];
		  $foto_naam		=	$row[2];
		  $foto				=	$row[3];
?>
                        <a href="fotoos/<?php echo $foto; ?>"><img src="fotoos/<?php echo $foto; ?>" alt="<?php echo $foto_naam; ?>" class="img-full">
                        </a>
<?php
	}
}
?>
                    </div>
                </div>
            </div>
        </section>
        <!-- Section Work Detail End -->


    </div>
</main>
<!-- Site Main End -->

<?php include('includes/footer.inc'); ?>