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

	use Lib\Tool;
    use Lib\Search;

    /**
     * Variables de recherche
     */
    if(isset($_POST['addRecherche'])){
        Search::postRecherche('actualites');
    }
    extract(Search::getRecherche('actualites',array('categorie','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>Actualités</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 class="managerActualites">

    <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>Catégorie</label>
                            <select name="categorie" class="form-elem">
                                <option value="">Choisir une catégorie</option>
                                <?php
                                    $sql = $bdd->query("SELECT * FROM actualite_categorie
                                                        ORDER BY categorieNom ASC ");
                                    while($data = $sql->fetchObject()){
                                        $selected = ($data->categorieId == $categorie) ? 'selected' : '';
                                        echo'<option value="'.$data->categorieId.'" '.$selected.'>'.$data->categorieNom.'</option>';
                                    }
                                ?>
                            </select>
                        </div>

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

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

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

                </div>

            </div>
        </div>

        <?php
            $sql = $bdd->query("SELECT * FROM actualite
                                INNER JOIN actualite_categorie ON actualiteCategorie = categorieId
                                WHERE actualiteEtat = 1 
                                AND actualiteAvant = 1 
                                LIMIT 1 ");
            if($sql->rowCount() != 0){
                $data = $sql->fetchObject();

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

                        echo'<div class="actualiteAvant navFull" data-url="'.BASEFRONT.'actualite/'.$data->actualiteSlug.'/'.$data->actualiteId.'">';

                            echo'<div class="actualiteAvantImage">';
                                echo'<p class="actualiteAvantCategorie label orange">'.$data->categorieNom.'</p>';

                                if(!is_null($data->actualiteImage)){
                                    echo'<img src="'.BASEFRONT.'img/actualite/miniature/'.$data->actualiteImage.'">';
                                }else{
                                    echo'<img src="'.BASEFRONT.'img/actualite/miniature/alt.jpg">';
                                }

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

                                echo'<div class="actualiteAvantDate">';
                                    echo '<p><span>'.date('d').'</span>'.strftime("%b",strtotime($data->actualiteCreated)).'</p>';
                                echo'</div>';
                            echo'</div>';

                            echo'<div class="actualiteAvantContenu">';
                                echo'<h2 class="actualiteAvantTitre">'.$data->actualiteTitre.'</h2>';

                                echo'<p class="actualiteAvantResume">'.$data->actualiteResume.'</p>';
                            echo'</div>';

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

                        echo'</div>';

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

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

                <div class="section9Actualites">
                    <?php
                        $requete = "SELECT * FROM actualite
                                    INNER JOIN actualite_categorie ON actualiteCategorie = categorieId
                                    WHERE actualiteEtat = 1 
                                    AND actualiteAvant = 0 ";
                                    if(!empty($categorie))
                                        $requete .= "AND actualiteCategorie = $categorie ";
                                    if(!empty($recherche))
                                        $requete .= " AND actualiteTitre LIKE '%$recherche%' OR actualiteContenu LIKE '%$recherche%' ";
                                    $requete .= "ORDER BY actualiteId DESC 
                                                 LIMIT $debut, $nbPage  ";

                        $sql = $bdd->query($requete);
                        while($data = $sql->fetchObject()){
                            echo'<div class="actualiteListe navFull" data-url="'.BASEFRONT.'actualite/'.$data->actualiteSlug.'/'.$data->actualiteId.'">';

                                echo'<p class="actualiteListeCategorie label orange">'.$data->categorieNom.'</p>';

                                echo'<div class="actualiteListeImage">';
                                    if(!is_null($data->actualiteImage)){
                                        echo'<img src="'.BASEFRONT.'img/actualite/miniature/'.$data->actualiteImage.'">';
                                    }else{
                                        echo'<img src="'.BASEFRONT.'img/actualite/miniature/alt.jpg">';
                                    }

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

                                    echo'<div class="actualiteListeDate">';
                                        echo '<p><span>'.date('d').'</span>'.strftime("%b",strtotime($data->actualiteCreated)).'</p>';
                                    echo'</div>';
                                echo'</div>';

                                echo'<div class="actualiteListeContenu">';
                                    echo'<h3 class="actualiteListeTitre">'.Tool::tronquer($data->actualiteTitre,60).'</h3>';

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

                                    echo '<a href="'.BASEFRONT.'actualite/'.$data->actualiteSlug.'/'.$data->actualiteId.'" class="actualiteListePlus">Lire la suite</a>';
                                echo'</div>';

                            echo'</div>';
                        }
                    ?>

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

                </div>

                <div class="pagination section9Pagination">
                    <?php
                        $requetePage = "SELECT count(actualiteId) as total FROM actualite 
                                        WHERE actualiteEtat = 1 
                                        AND actualiteAvant = 0 ";
                                        if(!empty($categorie))
                                            $requete .= "AND actualiteCategorie = $categorie ";
                                        if(!empty($recherche))
                                            $requete .= " AND actualiteTitre LIKE '%$recherche%' OR actualiteContenu LIKE '%$recherche%' ";

                        Tool::addPaginate($requetePage,BASEFRONT.'actualites',$nbPage,$page, true);
                    ?>
                </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>