<?php
	include '../lib/app/init.php';

	use Lib\Tool;
    use Lib\Search;

    /**
     * Variables de recherche
     */
    if(isset($_POST['addRecherche'])){
        Search::postRecherche('projets');
    }
    extract(Search::getRecherche('projets',array('ordre','recherche')));

    /* Pagination */
    extract(Tool::initPaginate(9));
?>
<!doctype html>
<html lang="fr">

<head>
	<meta charset="utf-8">
	<meta name="viewport" content="width=device-width; initial-scale=1;">
	<title>Projets</title>
	<link rel="icon" type="image/png" href="<?= BASEFRONT ?>img/layout/favicon.png">
	<link href="<?= BASEFRONT ?>css/app.css" rel="stylesheet" type="text/css">
</head>

<body>

    <main class="main">

        <?php include'../include/header.php'; ?>

        <div class="contenuTop">
            <div class="inner">

                <div class="contentTopRecherche">

                    <form action="#" method="post">
                        <div class="form-group first">
                            <label>Ordre</label>
                            <select name="ordre" class="form-elem">
                                <option value="alpha_asc" <?= ($ordre == 'alpha_asc') ? 'selected' : '' ?> >Alphabétique croissant</option>
                                <option value="alpha_desc" <?= ($ordre == 'alpha_desc') ? 'selected' : '' ?> >Alphabétique décroissant</option>
                                <option value="created_asc" <?= ($ordre == 'created_asc') ? 'selected' : '' ?> >Date de création croissante</option>
                                <option value="created_desc" <?= ($ordre == 'created_desc') ? 'selected' : '' ?> >Date de création décroissante</option>
                            </select>
                        </div>

                        <div class="form-group last">
                            <label>Rechercher</label>
                            <input type="text" name="recherche" class="form-elem" placeholder="Recherche" value="<?= $recherche ?>">
                        </div>

                        <div class="clear"></div>

                        <div class="form-bouton">
                            <button class="form-submit orange" tpye="submlit" name="addRecherche">Valider</button>
                        </div>
                    </form>

                </div>

            </div>
        </div>

        <?php
            $sql = $bdd->query("SELECT * FROM projet
                                WHERE projetEtat = 1 
                                AND projetAvant = 1 
                                LIMIT 1 ");
            if($sql->rowCount() != 0){
                $data = $sql->fetchObject();

                echo'<section class="section section6">';
                    echo'<div class="inner">';

                        echo'<div class="projetAvant navFull" data-url="'.BASEFRONT.'projet/'.$data->projetSlug.'/'.$data->projetId.'">';

                            echo'<div class="projetAvantLogo">';
                                if(!is_null($data->projetLogo)){
                                    echo'<img src="'.BASEFRONT.'img/projet/logo/'.$data->projetLogo.'">';
                                }else{
                                    echo'<img src="'.BASEFRONT.'img/projet/logo/alt.jpg">';
                                }

                                echo'<div class="projetAvantDate">';
                                    echo'<p>Création<br><span>'.strftime("%d %b %Y",strtotime($data->projetCreated)).'</span></p>';
                                echo'</div>';
                            echo'</div>';

                            echo'<div class="projetAvantContenu">';
                                echo'<h2 class="projetAvantNom">'.$data->projetNom.'</h2>';

                                echo'<p class="projetAvantResume">'.$data->projetResume.'</p>';

                                if(!is_null($data->projetTag)) {
                                    echo '<div class="projetAvantTag">';
                                        $sql2 = $bdd->query("SELECT * FROM tag
                                                             WHERE tagId IN($data->projetTag)");
                                        while($data2 = $sql2->fetchObject()){
                                            echo'<span class="label vert">'.$data2->tagNom.'</span>';
                                        }
                                    echo '</div>';
                                }
                            echo'</div>';

                            echo'<div class="clear"></div>';

                        echo'</div>';

                    echo'</div>';
                echo'</section>';
            }
        ?>

        <section class="section section7">
            <div class="inner">

                <div class="section7Projets">
                        <?php
                            $requete = "SELECT * FROM projet
                                        WHERE projetEtat = 1 
                                        AND projetAvant = 0 ";
                                        if(!empty($recherche))
                                            $requete .= " AND projetNom LIKE '%$recherche%' OR projetDescription LIKE '%$recherche%' OR projetDirigeant LIKE '%$recherche%' OR projetActivite LIKE '%$recherche%' OR projetObjectif LIKE '%$recherche%' OR projetComplementaire LIKE '%$recherche%' ";
                                        if(!empty($ordre)){
                                            if($ordre == 'alpha_asc') $requete .= " ORDER BY projetNom ASC ";
                                            else if ($ordre == 'alpha_desc') $requete .= " ORDER BY projetNom DESC ";
                                            else if(($ordre == 'created_asc')) $requete .= " ORDER BY projetCreated ASC ";
                                            else if(($ordre == 'created_desc')) $requete .= " ORDER BY projetCreated DESC ";
                                        }else $requete .= " ORDER BY projetId DESC ";
                                        $requete .= "LIMIT $debut, $nbPage ";

                            $sql = $bdd->query($requete);
                            while($data = $sql->fetchObject()){
                                echo'<div class="projetListe navFull" data-url="'.BASEFRONT.'projet/'.$data->projetSlug.'/'.$data->projetId.'">';

                                    echo'<p class="projetListeDate">'.strftime("%d %b %Y",strtotime($data->projetCreated)).'</p>';

                                    echo'<div class="projetListeLogo">';
                                        if(!is_null($data->projetLogo)){
                                            echo'<img src="'.BASEFRONT.'img/projet/logo/'.$data->projetLogo.'">';
                                        }else{
                                            echo'<img src="'.BASEFRONT.'img/projet/logo/alt.jpg">';
                                        }
                                    echo'</div>';

                                    echo'<div class="projetListeContenu">';
                                        echo'<h3 class="projetListeNom">'.Tool::tronquer($data->projetNom,60).'</h3>';

                                        echo'<p class="projetListeResume">'.Tool::tronquer($data->projetResume,90).'</p>';

                                        if(!is_null($data->projetTag)) {
                                            echo '<div class="projetListeTag">';
                                                $sql2 = $bdd->query("SELECT * FROM tag
                                                                     WHERE tagId IN($data->projetTag)");
                                                while($data2 = $sql2->fetchObject()){
                                                    echo'<span class="label vert">'.$data2->tagNom.'</span>';
                                                }
                                            echo '</div>';
                                        }

                                        echo '<a href="'.BASEFRONT.'projet/'.$data->projetSlug.'/'.$data->projetId.'" class="projetListePlus">Voir le détail du projet</a>';
                                    echo'</div>';

                                echo'</div>';
                            }
                        ?>

                        <div class="clear"></div>
                </div>

                <div class="section7Citation">
                    <p>&laquo; Ces éléments sont fournis par l'équipe projet et relèvent</p>
                    <p>de leur responsabilité &raquo;</p>
                </div>

                <div class="pagination section7Pagination">
                    <?php
                        $requetePage = "SELECT count(projetId) as total FROM projet 
                                        WHERE projetEtat = 1
                                        AND projetAvant = 0 ";
                                        if(!empty($recherche))
                                            $requete .= " AND projetNom LIKE '%$recherche%' OR projetDescription LIKE '%$recherche%' OR projetDirigeant LIKE '%$recherche%' OR projetActivite LIKE '%$recherche%' OR projetObjectif LIKE '%$recherche%' OR projetComplementaire LIKE '%$recherche%' ";

                        Tool::addPaginate($requetePage,BASEFRONT.'projets',$nbPage,$page, true);
                    ?>
                </div>

                <div class="section7Startup">
                    <a href="#"><img src="<?= BASEFRONT ?>img/layout/btnStartup.svg"></a>
                </div>

            </div>
        </section>

        <?php include'../include/footer.php'; ?>

    </main>

	<script type="text/javascript" src="<?= BASEFRONT ?>js/jquery/jquery.js"></script>
    <script type="text/javascript" src="<?= BASEFRONT ?>js/height.js"></script>
	<script type="text/javascript" src="<?= BASEFRONT ?>js/app.js"></script>	

</body>
</html>