<?php include('sections/parts/head.php') ?>
<?php include('sections/parts/header.php') ?>

<?php
$page_id =  407; //id du page News
$cat_id = isset($_GET['cid']) ? $_GET['cid'] : 2; //id par defaut des event recent
$page_children_id = isset($_GET['pid']) ? $_GET['pid'] : 431;
$custom_page_title = "News";
$cat = Type_topic::find_by_id($cat_id);
if ($cat) $custom_page_title = $cat->type_topic_desc;
?>
<!-- page section -->
<?php include_once('sections/parts/page-header.php') ?>
<!--end page section-->

<?php
// On récupère le numéro de la page actuelle
$page = (int)$_GET['page'];
$page = isset($page) ? $page : 1;
//si la page est 0 ou négatif on la met à 1
if ($page <= 0) {
    $page = 1;
}

$limitPerPage = 5;
$offset = ($page - 1) * $limitPerPage;
$topics = Topics::find_by_typetopic($cat_id, $offset, $limitPerPage);
$totalPages = Topics::count_by_typetopic($cat_id);
?>

<!--Blog Sidebar Start-->
<section class="blog-sidebar">
    <div class="container">
        <div class="row">
            <div class="col-xl-8 col-lg-7">
                <div class="blog-sidebar__left">
                    <div class="blog-sidebar__content-box">
                        <?php if (count($topics) > 0) : ?>
                            <?php foreach ($topics as $key => $topic) : ?>
                                <div class="blog-sidebar__single">
                                    <div class="blog-sidebar__img">
                                        <?php if (isset($topic->topic_image_path) && !empty($topic->topic_image_path)) : ?>
                                            <?php
                                            // si image_path contient ',' alors on url est le premier element
                                            $image_path = explode(',', $topic->topic_image_path);
                                            $image_path = $image_path[0];
                                            ?>
                                            <?php if ($image_path !== '' && is_file(FOLDER_MANAGER . $image_path)) : ?>
                                                <img height="" src="<?= FOLDER_MANAGER . $image_path ?>" alt="Image">
                                            <?php else : ?>
                                                <img src="assets/images/ac.jpg" alt="Not Found">
                                            <?php endif; ?>
                                        <?php else : ?>
                                            <img src="assets/images/ac.jpg" alt="Not Found">
                                        <?php endif; ?>
                                        <div class="blog-sidebar__date">
                                            <p><?= date('d', strtotime($topic->topic_date_creation)) ?>
                                                <span><?php $date = new DateTime($topic->topic_date_creation);
                                                        echo $date->format("M"); ?>
                                                </span>
                                            </p>
                                        </div>
                                    </div>
                                    <div class="blog-sidebar__content">
                                        <ul class="blog-sidebar__meta list-unstyled">
                                            <li>
                                                <p><i class="fa fa-user"></i> &nbsp; <?= User_info::find_by_user_account($topic->topic_author)->full_name() ?></p>
                                            </li>
                                            <li>
                                                <p><i class="fa fa-eye"></i> <?= mnber_format_short($topic->topic_views)??0 ?> </p>
                                            </li>
                                             <li>
                                                <p><i class="fa fa-share-alt"></i> <?= mnber_format_short($topic->topic_shares)??0 ?> </p>
                                            </li>
                                             <li>                                            
                                                <p>
                                                    <i class="fa fa-comments"></i> 
                                                <?php 
                                                $nbr_commentaire = Comment_topic::count_valid_by_topic($topic->topic_id);
                                                echo mnber_format_short($nbr_commentaire) ?? 0; ?>
                                                </p>
                                            </li>
                                            <li>
                                                <a> &nbsp; <i class="far fa-calendar"></i>
                                                    <?php $creationDate = new DateTime($topic->topic_date_creation);
                                                    echo $creationDate->format('d M Y'); ?> &nbsp;</a>
                                            </li>
                                        </ul>
                                        <h3 class="blog-sidebar__title">
                                            <a href="<?= $topic->topic_id ?>-post-<?= $topic->topic_url ?>-<?= $page_id ?>#contenu">
                                                <?= $topic->topic_title ?>
                                            </a>
                                        </h3>
                                        <p class="blog-sidebar__text"> <?= $topic->gettextlimit(255) ?> </p>
                                        <div class="blog-sidebar__btn">
                                            <a href="<?= $topic->topic_id ?>-post-<?= $topic->topic_url ?>-<?= $page_id ?>#contenu">Read more<i class="icon-up-right"></i></a>
                                        </div>
                                    </div>
                                </div>
                            <?php endforeach; ?>
                            <nav aria-label="pagination-wrapper centred Page navigation example">
                                <ul class="pagination justify-content-end">
                                    <?php if ($page > 1): ?>
                                    <li class="page-item"> <a class="page-link" href="<?php echo $page_id . '-' . $cat_id . '-' . ($page - 1) . '-news' ?>" tabindex="-1"> <i class="fa fa-angle-left"></i> <span class="sr-only">Previous</span> </a> </li>
                                    <?php endif ?>
                                    <?php if ($page>2): ?>
                                    <li class="page-item"><a class="page-link" href="<?php echo  $page_id . '-' . $cat_id . '-' . ($page - 1) . '-news' ?>"><?php echo ($page - 1) ?></a></li>
                                    <?php endif ?>
                                    <li class="page-item active"><a class="page-link" href="<?php echo  $page_id . '-' . $cat_id . '-' . ($page) . '-news' ?>"><?php echo $page ?></a></li>
                                    <?php if ($page < ceil($totalPages / $limitPerPage)): ?>
                                    <li class="page-item"><a class="page-link" href="<?php echo  $page_id . '-' . $cat_id . '-' . ($page + 1) . '-news' ?>"><?php echo ($page + 1) ?></a></li>
                                    <?php endif ?>
                                    <?php if ($page < ceil($totalPages / $limitPerPage)): ?>
                                    <li class="page-item"> <a class="page-link" href="<?php echo  $page_id . '-' . $cat_id . '-' . ($page + 1) . '-news' ?>"> <i class="fa fa-angle-right"></i> <span class="sr-only">Next</span> </a> </li>
                                    <?php endif ?>
                                
                                </ul>
                            </nav>

                        <?php else : ?>
                            <div class="blog-classic-content text-center">
                                <p>No publications found .</p>
                            </div>
                        <?php endif; ?>
                    </div>
                </div>
            </div>
            <div class="col-xl-4 col-lg-5 blog-sidebar__col">
                <?php include('sections/pages/post-sidebar.php') ?>
            </div>
        </div>
    </div>
</section>
<!--Blog Sidebar End-->

<?php include('sections/parts/footer.php') ?>
<?php include('sections/parts/scripts.php') ?>
<script>
    $(document).ready(function() {
        var page_id = <?= $page_id ?>;
        var page_children_id = <?= $page_children_id ?>;
        var page = <?= $page ?>;

        //verification Head elements
        var head = document.head;
        if (!document.querySelector('meta[name="description"]')) {
            var meta = document.createElement('meta');
            meta.name = "description";
            meta.content = "News | Permanent Mission of sierra Leone in Geneva - <?= Page::find_by_id($page_id)->page_title ?>";
            head.appendChild(meta);
        }
        if (!document.querySelector('meta[name="keywords"]')) {
            var meta = document.createElement('meta');
            meta.name = "keywords";
            meta.content = "News | Permanent Mission of sierra Leone in Geneva - <?= Page::find_by_id($page_id)->page_title ?>";
            head.appendChild(meta);
        }
        if (!document.querySelector('meta[property="og:title"]')) {
            var meta = document.createElement('meta');
            meta.property = "og:title";
            meta.content = "News | Permanent Mission of sierra Leone in Geneva - <?= Page::find_by_id($page_id)->page_title ?>";
            head.appendChild(meta);
        }
        if (!document.querySelector('meta[property="og:description"]')) {
            var meta = document.createElement('meta');
            meta.property = "og:description";
            meta.content = "News | Permanent Mission of sierra Leone in Geneva - <?= Page::find_by_id($page_id)->page_title ?>";
            head.appendChild(meta);
        }
        if (!document.querySelector('meta[property="og:url"]')) {
            var meta = document.createElement('meta');
            meta.property = "og:url";
            meta.content = "News | Permanent Mission of sierra Leone in Geneva - <?= Page::find_by_id($page_id)->page_title ?>";
            head.appendChild(meta);
        }
        if (!document.querySelector('meta[property="og:image"]')) {
            var meta = document.createElement('meta');
            meta.property = "og:image";
            meta.content = "News | Permanent Mission of sierra Leone in Geneva - <?= Page::find_by_id($page_id)->page_title ?>";
            head.appendChild(meta);
        }
        if (!document.querySelector('meta[property="og:site_name"]')) {
            var meta = document.createElement('meta');
            meta.property = "og:site_name";
            meta.content = "News | Permanent Mission of sierra Leone in Geneva - <?= Page::find_by_id($page_id)->page_title ?>";
            head.appendChild(meta);
        }
        if (!document.querySelector('meta[property="og:type"]')) {
            var meta = document.createElement('meta');
            meta.property = "og:type";
            meta.content = "News | Permanent Mission of sierra Leone in Geneva - <?= Page::find_by_id($page_id)->page_title ?>";
            head.appendChild(meta);
        }
        if (!document.querySelector('meta[name="twitter:title"]')) {
            var meta = document.createElement('meta');
            meta.name = "twitter:title";
            meta.content = "News | Permanent Mission of sierra Leone in Geneva - <?= Page::find_by_id($page_id)->page_title ?>";
            head.appendChild(meta);
        }
        if (!document.querySelector('meta[name="twitter:description"]')) {
            var meta = document.createElement('meta');
            meta.name = "twitter:description";
            meta.content = "News | Permanent Mission of sierra Leone in Geneva - <?= Page::find_by_id($page_id)->page_title ?>";
            head.appendChild(meta);
        }
        if (!document.querySelector('meta[name="twitter:image"]')) {
            var meta = document.createElement('meta');
            meta.name = "twitter:image";
            meta.content = "News | Permanent Mission of sierra Leone in Geneva - <?= Page::find_by_id($page_id)->page_title ?>";
            head.appendChild(meta);
        }
        if (!document.querySelector('meta[name="twitter:site"]')) {
            var meta = document.createElement('meta');
            meta.name = "twitter:site";
            meta.content = "News | Permanent Mission of sierra Leone in Geneva - <?= Page::find_by_id($page_id)->page_title ?>";
            head.appendChild(meta);
        }
        if (!document.querySelector('meta[name="twitter:creator"]')) {
            var meta = document.createElement('meta');
            meta.name = "twitter:creator";
            meta.content = "News | Permanent Mission of sierra Leone in Geneva - <?= Page::find_by_id($page_id)->page_title ?>";
            head.appendChild(meta);
        }

        //Mini SEO
        document.title = "<?= Page::find_by_id($page_id)->page_title ?> | Permanent Mission of sierra Leone in Geneva"

        $("meta[name='title']").attr("content", "News | Permanent Mission of sierra Leone in Geneva - <?= Page::find_by_id($page_id)->page_title ?>");

        $("meta[name='description']").attr("content", "News | Permanent Mission of sierra Leone in Geneva - <?= Page::find_by_id($page_id)->page_title ?>");

        $("meta[name='keywords']").attr("content", "News | Permanent Mission of sierra Leone in Geneva - <?= Page::find_by_id($page_id)->page_title ?>");

        $("meta[property='og:title']").attr("content", "News | Permanent Mission of sierra Leone in Geneva - <?= Page::find_by_id($page_id)->page_title ?>");

        $("meta[property='og:description']").attr("content", "News | Permanent Mission of sierra Leone in Geneva - <?= Page::find_by_id($page_id)->page_title ?>");

        $("meta[property='og:url']").attr("content", "News | Permanent Mission of sierra Leone in Geneva - <?= Page::find_by_id($page_id)->page_title ?>");

        $("meta[property='og:image']").attr("content", "News | Permanent Mission of sierra Leone in Geneva - <?= Page::find_by_id($page_id)->page_title ?>");

        $("meta[property='og:site_name']").attr("content", "News | Permanent Mission of sierra Leone in Geneva - <?= Page::find_by_id($page_id)->page_title ?>");

        $("meta[property='og:type']").attr("content", "News | Permanent Mission of sierra Leone in Geneva - <?= Page::find_by_id($page_id)->page_title ?>");


        $("meta[name='twitter:title']").attr("content", "News | Permanent Mission of sierra Leone in Geneva - <?= Page::find_by_id($page_id)->page_title ?>");

        $("meta[name='twitter:description']").attr("content", "News | Permanent Mission of sierra Leone in Geneva - <?= Page::find_by_id($page_id)->page_title ?>");

        $("meta[name='twitter:image']").attr("content", "News | Permanent Mission of sierra Leone in Geneva - <?= Page::find_by_id($page_id)->page_title ?>");

        $("meta[name='twitter:site']").attr("content", "News | Permanent Mission of sierra Leone in Geneva - <?= Page::find_by_id($page_id)->page_title ?>");

        $("meta[name='twitter:creator']").attr("content", "News | Permanent Mission of sierra Leone in Geneva - <?= Page::find_by_id($page_id)->page_title ?>");

        //End Mini SEO
    });
</script>