<?php

include('includes/connect.php');
include('includes/functions.php');
setlocale(LC_ALL, 'nld_nld');

$sql_gerealiseerd = "
	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
	FROM
	  categorie
	  RIGHT OUTER JOIN projecten ON (categorie.id_categorie = projecten.id_categorie)
	WHERE projecten.aankomend = 'F'
	ORDER BY projecten.datum DESC
";

$result_gerealiseerd = mysql_query($sql_gerealiseerd);

$sql_aankomend = "
	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
	FROM
	  categorie
	  RIGHT OUTER JOIN projecten ON (categorie.id_categorie = projecten.id_categorie)
	WHERE projecten.aankomend = 'T'
	ORDER BY projecten.datum DESC
";

$result_aankomend = mysql_query($sql_aankomend);

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

<!-- Basic Page Head -->
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>InvertEvents | Homepagina</title>
<meta name="description" content="Invert Events is een bedrijf dat al sinds 2005 gespecialiseerd is in de (site) productie van evenementen, kermissen en festivals. Enkele voorbeelden waarvoor Invert Events voor ingeschakelt is: Sinterklaas intocht Eindhoven, Ameezing Eindhoven, Best kept secret festival, PSV Kampioenschap, Musical Carnaval X, Lakedance festival, Pop on top en nog veel meer. Wij hebben de kennis over de facilitaire en logistieke voorbereidingen, indeling en inkoop van de juiste materialen voor uw evenement.">
<meta name="author" content="Visual Act">
<meta name="keywords" content="kermis festival evenementen amazing carnaval organisatie psv eindhoven inkoop gespecialiseerd evenement">

<!-- 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>

<!-- 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; tel: +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-slider">
    <ul class="bxslider">
         <li>
            <div class="slide-image">
                <img src="assets/img/slide-4.jpg" alt="Slide">
            </div>
            <div class="slide-caption shadow">
                <div class="caption-wrapper">
                    <p class="text-2"></p>
                    <p class="text-1">FESTIVALS</p>
                    <p><a href="portfolio.php" class="btn btn-black">BEKIJK DEZE PROJECTEN <i class="fa fa-angle-right right"></i></a></p>
                </div>
            </div>
        </li>
        <li>
            <div class="slide-image">
                <img src="assets/img/slide-3.jpg" alt="Slide">
            </div>
            <div class="slide-caption shadow">
                <div class="caption-wrapper">
                    <p class="text-2"></p>
                    <p class="text-1">INDOOR EVENEMENTEN</p>
                    <p><a href="portfolio.php" class="btn btn-black">BEKIJK DEZE PROJECTEN <i class="fa fa-angle-right right"></i></a></p>
                </div>
            </div>
        </li>
        <li>
            <div class="slide-image">
                <img src="assets/img/slide-2.jpg" alt="Slide">
            </div>
            <div class="slide-caption shadow">
                <div class="caption-wrapper">
                    <p class="text-2"></p>
                    <p class="text-1">OUTDOOR EVENEMENTEN</p>
                    <p><a href="portfolio.php" class="btn btn-black">BEKIJK DEZE PROJECTEN <i class="fa fa-angle-right right"></i></a></p>
                </div>
            </div>
        </li>
        <li>
            <div class="slide-image">
                <img src="assets/img/slide-1.jpg" alt="Slide">
            </div>
            <div class="slide-caption shadow">
                <div class="caption-wrapper">
                    <p class="text-2"></p>
                    <p class="text-1">KERMISSEN</p>
                    <p><a href="portfolio.php" class="btn btn-black"> BEKIJK DEZE PROJECTEN <i class="fa fa-angle-right right"></i></a></p>
                </div>
            </div>
        </li>
    </ul>
</div>
</header>
<!-- Site Header End -->

<!-- Site Main -->
<main>
    <div class="site-wrapper">


        <!-- Section Services -->
        <section class="site-block grey" id="section-services">
            <h2 class="section-title">Gerealiseerde projecten</h2>
            <h4 class="section-desc">Gerealiseerde projecten door Invert events.</h4>
            <br>
            <br>
            <div class="row large">
                <div class="services-list type-one owl-two" id="owl-services">
<?php

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

			$id_project_gerealiseerd					= $row[0];
			$id_categorie_gerealiseerd 					= $row[1];
			$datum_gerealiseerd							= NLDatum($row[2]);
			$naam_gerealiseerd							= $row[3];
			$opdrachtgever_gerealiseerd					= $row[4];
			$website_gerealiseerd						= $row[5];
			$locatie_gerealiseerd						= $row[6];
			$aankomend_gerealiseerd						= $row[7];
			$werkzaamheden_gerealiseerd					= $row[8];
			$beschrijving_gerealiseerd					= $row[9];
			$hoofdfoto_gerealiseerd						= $row[10];
			$categorie_gerealiseerd						= $row[11];
?>
						<div class="col-md-12">
							<div class="sh-image"><a href="#"><img src="fotoos/<?php echo $hoofdfoto_gerealiseerd; ?>" alt="<?php echo $naam_gerealiseerd; ?>" class="img-full"></a></div>
							<div class="sh-desc">
								<h4><?php echo $naam_gerealiseerd ?></h4>
								<?php echo $beschrijving_gerealiseerd; ?>
								<p><a href="portfolio-detail.php?id_project=<?php echo $id_project_gerealiseerd ?>" class="btn btn-link">BEKIJK PROJECT</a></p>
							</div>
						</div>
<?php } ?>
                </div>
            </div>
        </section>
        <!-- Section Services End -->



        <!-- Section Blog -->
        <section class="site-grid type-one white" id="section-blog">
            <div class="row">
                <div class="col-md-9">
                    <h3 class="margin-b30">Aankomende Evenementen</h3>
                    <div class="blog-list type-one owl-three" id="owl-blog">

<?php
		while($row = mysql_fetch_array($result_aankomend)){

			$id_project_aankomend					= $row[0];
			$id_categorie_aankomend					= $row[1];
			$datum_aankomend						= NLDatum($row[2]);
			$naam_aankomend							= $row[3];
			$opdrachtgever_aankomend				= $row[4];
			$website_aankomend						= $row[5];
			$locatie_aankomend						= $row[6];
			$aankomend_aankomend					= $row[7];
			$werkzaamheden_aankomend				= $row[8];
			$beschrijving_aankomend					= $row[9];
			$hoofdfoto_aankomend					= $row[10];
			$categorie_aankomend					= $row[11];
?>


                        <div class="bl-post clearfix">
                            <div class="bl-image"><a href="#"><img src="fotoos/<?php echo $hoofdfoto_aankomend ?>" alt="Post Title" class="img-full"></a></div>
                            <div class="bl-desc">
                                <h4><?php echo $naam_aankomend	?></h4>
                                <p class="desc">
                                	<?php $beschrijving_aankomend ?>
                                </p>
                                <p class="info clearfix">
                                    <span class="date"><?php echo $datum_aankomend; ?></span>
                                </p>
                                <p><a href="portfolio-detail.php?id_project=<?php echo $id_project_aankomend ?>" class="btn btn-link">BEKIJK AANKONDIGING</a></p>
                            </div>
                        </div>
<?php } ?>
                    </div>
                </div>
                <div class="col-md-3">
                    <!-- <h3 class="margin-b10">Overige</h3>
                    <nav>
                        <ul class="quick-links">
                            <li><a href="#"><i class="fa fa-file-text-o"></i> diverse</a></li>
                            <li><a href="#"><i class="fa fa-life-ring"></i> support</a></li>
                            <li><a href="#"><i class="fa fa-cog"></i> Links</a></li>
                            <li><a href="#"><i class="fa fa-file-text-o"></i> Algemene voorwaarden</a></li>
                        </ul>
                    </nav>
                    -->
                </div>
            </div>
        </section>
        <!-- Section Blog End -->
    </div>
</main>
<!-- Site Main End -->

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