<!--------------------------------------------------------------------- footer ---------------------------------------------------------->
    <script>
        $(document).ready(function() {
            $("#backtop").click(function(e) {  
                $(window).scrollTop(0);
            });
        });
    </script>
    <?php
        $sql_dataft1 = "SELECT COUNT(`id_weblink`) FROM `data_weblink` WHERE `stt_weblink`=0 ORDER BY `id_weblink` ASC  ";
        $qr_dataft1 = mysqli_query($con_db_main, $sql_dataft1) or trigger_error("SQL", E_USER_ERROR);
        $rs_dataft1 = mysqli_fetch_row($qr_dataft1);
        $num_ft = $rs_dataft1[0];
        $num_pgft = ceil($num_ft/4);
    ?>
    <div class="container bg-ft fix-page" >
        <div class="row ms-2 me-2 mt-0 pt-0" >
            <div class="col text-center " >
                <div class="btn_bachtopmenu mx-auto mb-5" id="backtop"><i class="fas fa-chevron-circle-up me-2"></i>กลับด้านบน</div>
                <div id="slideFooter" class="carousel slide w-100 mt-5 carousel-dark slide" data-bs-ride="carousel" >
                    <div class="carousel-indicators" style="margin-bottom:-2px;">
                        <?php 
                            for($xx=1;$xx<=$num_pgft;$xx++){
                                $y = $xx-1;
                                if($xx==1){ 
                                    echo '<button type="button" data-bs-target="#slideFooter" data-bs-slide-to="0" class="active" aria-current="true"></button>';
                                } 
                                if($xx>1){
                                    echo '<button type="button" data-bs-target="#slideFooter" data-bs-slide-to="'.$y.'" ></button>';
                                }
                            } 
                        ?>
                    </div>
                    <div class="carousel-inner" style="height:90px;">
                        <?php
                                for($x=1;$x <= $num_ft-1;$x++){
                                    if($x==1){ 
                                        echo '<div class="carousel-item active text-center animated fadeIn" data-bs-interval="4000">';
                                        $sql_dataft2 = " SELECT * FROM `data_weblink` WHERE `stt_weblink`=0 ORDER BY `id_weblink` ASC LIMIT 4 ";
                                        $qr_dataft2 = mysqli_query($con_db_main,$sql_dataft2) or die( mysqli_error($con_db_main));
                                        while($rs_dataft2 = mysqli_fetch_array($qr_dataft2)){
                                            echo '<a href="'.$rs_dataft2['link_weblink'].'" target="_blank" title="'.$rs_dataft2['name_weblink'].'"><img src="../'.$rs_dataft2['img_weblink'].'" class="img-fluid ms-4 me-4 border border-5 rounded border-light bg-white" ></a>';
                                        }
                                        echo '</div>';
                                    }          
                                    if( ($x % 4) == 0 ){
                                        echo '<div class="carousel-item text-center animated fadeIn" data-bs-interval="4000">';
                                        $sql_dataft3 = " SELECT * FROM `data_weblink` WHERE `stt_weblink`=0 ORDER BY `id_weblink` ASC LIMIT $x , 4 ";
                                        $qr_dataft3 = mysqli_query($con_db_main,$sql_dataft3) or die( mysqli_error($con_db_main));
                                        while($rs_dataft3 = mysqli_fetch_array($qr_dataft3)){
                                            echo '<a href="'.$rs_dataft3['link_weblink'].'" target="_blank" title="'.$rs_dataft3['name_weblink'].'"><img src="../'.$rs_dataft3['img_weblink'].'" class="img-fluid ms-4 me-4 border border-5 rounded border-light bg-white"></a>';
                                        }
                                        echo '</div>';
                                    }
                                }
                        ?>
                    </div> 
                    <button class="carousel-control-prev" type="button" data-bs-target="#slideFooter" data-bs-slide="prev" style="margin-top:-20px;">
                        <span class="carousel-control-prev-icon" aria-hidden="true"></span>
                        <span class="visually-hidden">Previous</span>
                    </button>
                    <button class="carousel-control-next" type="button" data-bs-target="#slideFooter" data-bs-slide="next" style="margin-top:-20px;">
                        <span class="carousel-control-next-icon" aria-hidden="true"></span>
                        <span class="visually-hidden">Next</span>
                    </button>
                </div>
            </div>
        </div>
        <?php
            ///all
            $sql_total_dtvs = "SELECT sum(`count_visitor`) as total_dtvs FROM `data_visitor` ";
            $qr_total_dtvs = mysqli_query($con_db_main,$sql_total_dtvs) or die( mysqli_error($con_db_main));
            $rs_total_dtvs = mysqli_fetch_assoc($qr_total_dtvs);
            ///day
            $sql_nowday_dtvs = "SELECT `count_visitor` as nowday_dtvs FROM `data_visitor` WHERE `date_visitor`= CURDATE() ";
            $qr_nowday_dtvs = mysqli_query($con_db_main,$sql_nowday_dtvs) or die( mysqli_error($con_db_main));
            $rs_nowday_dtvs = mysqli_fetch_assoc($qr_nowday_dtvs);
            $nowday_dtvs = $rs_nowday_dtvs['nowday_dtvs'];
            ///week
            $firstday = date('Y-m-d', strtotime("this week"));
            $sql_nowweek_dtvs = "SELECT sum(`count_visitor`) as nowweek_dtvs FROM `data_visitor` WHERE ( `date_visitor` BETWEEN '$firstday' AND CURDATE() ) ";
            $qr_nowweek_dtvs = mysqli_query($con_db_main,$sql_nowweek_dtvs) or die( mysqli_error($con_db_main));
            $rs_nowweek_dtvs = mysqli_fetch_assoc($qr_nowweek_dtvs);
            if($rs_nowweek_dtvs['nowweek_dtvs'] ==''){
                $nowweek_dtvs = $nowday_dtvs;
            }else{
                $nowweek_dtvs = $rs_nowweek_dtvs['nowweek_dtvs'];
            }
            ///year
            $sql_nowyear_dtvs = "SELECT sum(`count_visitor`) as nowyear_dtvs FROM `data_visitor` WHERE YEAR(`date_visitor`)= YEAR(CURDATE()) ";
            $qr_nowyear_dtvs = mysqli_query($con_db_main,$sql_nowyear_dtvs) or die( mysqli_error($con_db_main));
            $rs_nowyear_dtvs = mysqli_fetch_assoc($qr_nowyear_dtvs);
            ///month
            $sql_nowmonth_dtvs = "SELECT sum(`count_visitor`) as nowmonth_dtvs FROM `data_visitor` WHERE YEAR(`date_visitor`)=YEAR(CURDATE()) AND MONTH(`date_visitor`)=MONTH(CURDATE())  ";
            $qr_nowmonth_dtvs = mysqli_query($con_db_main,$sql_nowmonth_dtvs) or die( mysqli_error($con_db_main));
            $rs_nowmonth_dtvs = mysqli_fetch_assoc($qr_nowmonth_dtvs);
        ?>
        <div class="row ms-2 me-2 mt-4 pb-4" >
            <div class="col text-center d-flex justify-content-center" >
                <div class="box_visit bg-white row rounded fw-500 fs-12 fcl-cl-2">
                    <div class="col-2 pt-2 pb-2 p-0 bg-cl-2 fcl-cl-1 rounded-start"><i class="fas fa-chart-bar"></i> จำนวน<br>ผู้เข้าชมเว็บไซต์</div>
                    <div class="col pt-2 pb-2 p-0 border-end">วันนี้<br><span class="fs-11"><?php echo $nowday_dtvs; ?></span></div>
                    <div class="col pt-2 pb-2 p-0 border-end">สัปดาห์นี้<br><span class="fs-11"><?php echo $nowweek_dtvs; ?></span></div>
                    <div class="col pt-2 pb-2 p-0 border-end">เดือนนี้<br><span class="fs-11"><?php echo $rs_nowmonth_dtvs['nowmonth_dtvs']; ?></span></div>
                    <div class="col pt-2 pb-2 p-0 border-end">ปีนี้<br><span class="fs-11"><?php echo $rs_nowyear_dtvs['nowyear_dtvs']; ?></span></div>
                    <div class="col pt-2 pb-2 p-0 bg-cl-2 fcl-cl-1 rounded-end">ทั้งหมด<br><?php echo $rs_total_dtvs['total_dtvs']; ?></div>
                </div>
                <div class="ps-4" ><a href="../backup" target="_blank"><img src="img/old_version.png" class="img-fluid2" ></a></div>
            </div>
        </div>
        <div class="row ms-2 me-2" style="padding-bottom:140px;">
            <div class="col text-center">
                <img src="img/Contact-01.png" class="img-fluid " >
            </div>
        </div>

    </div>
    <!------------------------------------------------------------------------------------------------------------------------------------>