<?php
session_start();
include "management/php/functions.php";
$menu = "blog";
$id = intval($_GET['id']);
$selectArticleSql = "select * from `tbl_article` where `delete_flag` = 0 and `id` = '".$id."' ";
$selectArticlePrepare = $connect -> prepare($selectArticleSql);
$selectArticlePrepare -> execute();
$selectArticleRow = $selectArticlePrepare -> fetch(PDO::FETCH_ASSOC);
$updateDate = explode(" ",$selectArticleRow['update_date']);
$date = miladiToJalali2($updateDate[0]);
$short = limitWord($selectArticleRow['full_desc'],25);
?>
<!doctype html>
<html lang="fa">
<head>
    <title><?php echo $selectArticleRow['title']; ?> | گروه کارآفرینان استاد</title>
    <meta name="description" content="<?php echo strip_tags($short); ?>">
    <?php include 'head.php'; ?>
</head>
<body style="direction: rtl;text-align: right">

<header class="header-area">
    <?php include "menu.php"; ?>
</header>

<?php include "modals.php"; ?>


<div class="page-title-area">
    <div class="container">
        <div class="page-title-content">
            <h1><?php echo $selectArticleRow['title']; ?></h1>
            <ul>
                <li><a href="index.php">صفحه اصلی </a> </li>
                <li><a href="blog.php">مقالات </a> </li>
                <li class="active"><h2 style="font-size: unset;font-weight: normal;color: unset;"><?php echo $selectArticleRow['title']; ?></h2></li>
            </ul>
        </div>
    </div>
</div>


<section class="blog-details ptb-100">
    <div class="container">
        <div class="row">
            <div class="col-lg-8">
                <div class="blog-details-content">
                    <div class="blog-details-img mb-2">
                        <img src="<?php echo $selectArticleRow['image']; ?>" alt="<?php echo $selectArticleRow['title']; ?>"> <!-- 860 x 500 -->
                    </div>
                    <div class="blog-top-content mb-3">
                        <div class="news-content blog-content">
                            <h2 class="mb-3"><?php echo $selectArticleRow['title']; ?></h2>
                            <ul class="admin" style="font-size: 12px;">
                                <li>
                                    <a style="font-size: 13px !important;">
                                        <i class="bx bx-user"></i>                                     توسط مدیر
                                    </a>
                                    <a style="font-size: 13px !important;">
                                        <i class="bx bx-calendar"></i> <?php echo $date; ?>
                                    </a>
                                </li>
                            </ul>
                        </div>
                    </div>
                    <div class="blog-top-content">
                        <div class="news-content blog-content">
                            <div class="blog-details" style="text-align: justify;color: #333;">
                                <?php echo $selectArticleRow['full_desc']; ?>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
            <div class="col-lg-4">
                <div class="widget-sidebar">
                    <div class="sidebar-widget search">
                        <h3 style="font-size:18px !important; border-radius: 10px 10px 0 0;"> جستجو کنید</h3>
                        <form class="search-form" action="blog.php" style="border-radius: 0 0 10px 10px;">
                            <input class="form-control" name="search" placeholder="جستجو کردن..." type="text">
                            <button class="search-button" type="submit">
                                <i class="bx bx-search"></i>
                            </button>
                        </form>
                    </div>
                    <div class="sidebar-widget recent-post">
                        <h3 class="widget-title" style="font-size:18px !important;border-radius: 10px 10px 0 0;">پست های محبوب</h3>
                        <ul style="border-radius: 0 0 10px 10px;">
                            <?php
                            $selectArticleSql2 = "select * from `tbl_article` where `delete_flag` = 0 and `id` <> '".$id."' order by rand() limit 7 ";
                            $selectArticlePrepare2 = $connect -> prepare($selectArticleSql2);
                            $selectArticlePrepare2 -> execute();
                            if($selectArticlePrepare2 -> rowCount() > 0){
                                while($selectArticleRows2 = $selectArticlePrepare2 -> fetch(PDO::FETCH_ASSOC)){
                                    $updateDate2 = explode(" ",$selectArticleRows2['update_date']);
                                    $date2 = miladiToJalali2($updateDate2[0]);
                                    
                            ?>
                            <li>
                                <a href="blog-details.php?id=<?php echo $selectArticleRows2['id']; ?>">
                                    » <?php echo $selectArticleRows2['title']; ?>
                                </a>
                            </li>
                            <?php
                                }
                            }
                            ?>
                        </ul>
                    </div>
                    <div class="sidebar-widget tags mb-0">
                        <h3 style="font-size:18px !important;border-radius: 10px 10px 0 0;">برچسب ها</h3>
                        <ul style="border-radius: 0 0 10px 10px;">
                            <?php
                            $tags = explode("-",$selectArticleRow['tag']);
                            foreach ($tags as $tagValue){
                                    echo '<li>
                                        <a href="blog-details.php?id='.$id.'">' . $tagValue . '</a>
                                    </li>';
                            }
                            ?>
                        </ul>
                    </div>
                </div>
            </div>
        </div>
    </div>
</section>

<?php
$blog = $connect -> prepare("select * from `tbl_article` where `delete_flag` = 0 and `group_id` = ".$selectArticleRow['group_id']." and `id` <> ".$id);
$blog -> execute();
if($blog -> rowCount() > 0){
?>
<div class="product-area bg-color pb-70">
    <div class="container">
        <div class="section-title" style="max-width: unset; margin-bottom: 15px;">
            <h2 style="border-bottom: 1px solid #eee;padding-bottom: 11px;font-size: 25px;">مقالات مرتبط</h2>
        </div>
        <div class="related-product owl-theme owl-carousel">
            <?php
                while($blogRow = $blog -> fetch(PDO::FETCH_ASSOC)){
                    $updateDate2 = explode(" ",$blogRow['update_date']);
                    $date2 = miladiToJalali2($updateDate2[0]);
            ?>
                <div class="single-blog" style="padding: 5px; border-radius: 10px;">
                    <div class="blog-img">
                        <a href="blog-details.php?id=<?php echo $blogRow['id']; ?>">
                            <img src="<?php echo $blogRow['image']; ?>" alt="<?php echo $blogRow['title']; ?>">
                        </a>
                    </div>
                    <div class="blog-content pt-2">
                        <ul>
                            <li>
                                <i class="bx bx-calendar"></i>
                                <a><?php echo $date2; ?></a>
                            </li>
                        </ul>
                        <a href="blog-details.php?id=<?php echo $blogRow['id']; ?>">
                            <h3><?php echo $blogRow['title']; ?></h3>
                        </a>
                        <a href="blog-details.php?id=<?php echo $blogRow['id']; ?>" class="read-more">
                            ادامه مطلب
                            <i class="bx bx-left-arrow-alt"></i>
                        </a>
                    </div>
                </div>
            <?php
                }
            ?>
        </div>
    </div>
</div>
<?php
}
?>

<?php include "footer.php"; ?>

<div class="go-top">
    <i class="bx bx-chevrons-up"></i>
    <i class="bx bx-chevrons-up"></i>
</div>


<script data-cfasync="false" src="/cdn-cgi/scripts/5c5dd728/cloudflare-static/email-decode.min.js"></script>
<script src="assets/js/jquery.min.js"></script>

<script src="assets/js/bootstrap.bundle.min.js"></script>

<script src="assets/js/meanmenu.min.js"></script>

<script src="assets/js/owl.carousel.min.js"></script>

<script src="assets/js/wow.min.js"></script>

<script src="assets/js/form-validator.min.js"></script>

<script src="assets/js/contact-form-script.js"></script>

<script src="assets/js/ajaxchimp.min.js"></script>

<script src="assets/js/range-slider.min.js"></script>

<script src="assets/js/custom.js"></script>
</body>
</html>