<!-- main-footer -->
<section class="main-footer">
    <div class="auto-container">
        <div class="widget-section">
            <div class="row clearfix">

                <div class="col-lg-3 col-md-6 col-sm-12 footer-column">
                    <div class="footer-widget about-widget">
                        <figure style="margin-bottom: 15px" class="footer-logo pull-left">
                            <a href="<?php echo $site; ?>">
                                <img src="<?php echo $site; ?>/panel/uploads/settings_v/1280x720/<?php echo $logo; ?>" alt="Logo">
                            </a>
                        </figure>
                        <div class="text">
                            <p><?=$misyon?></p>
                        </div>
                    </div>
                </div>

                <div class="col-lg-3 col-md-6 col-sm-12 footer-column">
                    <div class="footer-widget links-widget ml-90">
                        <div class="widget-title">
                            <h3>Hızlı Menü</h3>
                        </div>
                        <div class="widget-content">
                            <ul class="links-list clearfix">

                                <?php
                                $sayfada = 50;
                                $sorgu=$db->prepare("select * from reference");
                                $sorgu->execute();
                                $toplam_icerik=$sorgu->rowCount();
                                $toplam_sayfa = ceil($toplam_icerik / $sayfada);

                                $sayfa = isset($_GET['sayfa']) ? (int) $_GET['sayfa'] : 1;
                                if($sayfa < 1) $sayfa = 1;
                                if($sayfa > $toplam_sayfa) $sayfa = $toplam_sayfa;

                                $limit = ($sayfa - 1) * $sayfada;

                                $refsor=$db->prepare("select * from reference order by rank ASC limit $limit,$sayfada");
                                $refsor->execute();

                                while ($refcek=$refsor->fetch(PDO::FETCH_ASSOC)) {
                                    if ($refcek['isActive']==1){
                                ?>
                                <li>
                                    <a href="sayfa/<?=seo($refcek['title'])."-".$refcek['id']?>">
                                        <?php echo $refcek['title']; ?>
                                    </a>
                                </li>
                                <?php }} ?>

                                <li><a href="kadromuz">Kadromuz</a></li>
                                <li><a href="hizmetlerimiz">Hizmetlerimiz</a></li>
                                <li><a href="foto-galeri">Foto Galeri</a></li>
                                <li><a href="iletisim">İletişim</a></li>

                            </ul>
                        </div>
                    </div>
                </div>

                <div class="col-lg-3 col-md-6 col-sm-12 footer-column">
                    <div class="footer-widget links-widget ml-30">
                        <div class="widget-title">
                            <h3>Hizmetlerimiz</h3>
                        </div>
                        <div class="widget-content">
                            <ul class="links-list clearfix">

                                <?php
                                $sayfada = 50;
                                $sorgu=$db->prepare("select * from services");
                                $sorgu->execute();
                                $toplam_icerik=$sorgu->rowCount();
                                $toplam_sayfa = ceil($toplam_icerik / $sayfada);

                                $sayfa = isset($_GET['sayfa']) ? (int) $_GET['sayfa'] : 1;
                                if($sayfa < 1) $sayfa = 1;
                                if($sayfa > $toplam_sayfa) $sayfa = $toplam_sayfa;

                                $limit = ($sayfa - 1) * $sayfada;

                                $refsor=$db->prepare("select * from services order by rank ASC limit $limit,$sayfada");
                                $refsor->execute();

                                while ($refcek=$refsor->fetch(PDO::FETCH_ASSOC)) {
                                    if ($refcek['isActive']==1){
                                ?>
                                <li>
                                    <a href="hizmet-icerik/<?=seo($refcek['title'])."-".$refcek['id']?>">
                                        <?php echo $refcek['title']; ?>
                                    </a>
                                </li>
                                <?php }} ?>

                            </ul>
                        </div>
                    </div>
                </div>

            </div>
        </div>

        <div class="footer-bottom clearfix">
            <div class="copyright pull-left">
                <p><?=$copy?></p>
            </div>
        </div>

    </div>
</section>
<!-- main-footer end -->


<button class="scroll-top scroll-to-target" data-target="html">
    <span class="fal fa-angle-up"></span>
</button>
</div>

<script src="assets/js/jquery.js"></script>
<script src="assets/js/popper.min.js"></script>
<script src="assets/js/bootstrap.min.js"></script>
<script src="assets/js/owl.js"></script>
<script src="assets/js/wow.js"></script>
<script src="assets/js/validation.js"></script>
<script src="assets/js/jquery.fancybox.js"></script>
<script src="assets/js/appear.js"></script>
<script src="assets/js/scrollbar.js"></script>
<script src="assets/js/jquery.nice-select.min.js"></script>

<script src="assets/js/script.js"></script>

<script src="https://cdn.jsdelivr.net/npm/sweetalert2@11.0.18/dist/sweetalert2.all.js"></script>

<?php include "includes/post.php"; ?>
<?=$footerkod?>

</body>
</html>