<?php
$actual_link = (isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] === 'on' ? 'https' : 'http') . "://$_SERVER[HTTP_HOST]$_SERVER[REQUEST_URI]";
$url_slug = basename($actual_link);

global $wpdb;
$TT_CITIES = "sp_city";
$TT_STATES = "sp_states";
$TT_KVS_NAVODYA = "sp_kvs_navodya";

ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);

// to get details of kvs school 
$kvsDetail = $wpdb->get_row("SELECT k.latitude,k.longitude,k.address,k.id,k.url_slug , k.type, k.name, k.state_id, s.state_name,s.state_slug,s.image_icon,s.latitude as s_lat,s.longitude as s_lon, k.city_id, c.city, k.pincode, k.address, k.official_website_link, k.online_apply_link, k.online_fee_link, k.result_link, k.addmission_guidelines, k.addmission_details, k.important_emails, k.important_phones FROM $TT_KVS_NAVODYA as k LEFT JOIN $TT_STATES as s on s.state_id=k.state_id LEFT JOIN $TT_CITIES as c on c.city_id=k.city_id WHERE k.url_slug='$url_slug'");
?>
<style>
    .mark,
    mark {
        padding: 0px !important;
        background-color: #ff0;
    }

    .ExamDetailsPageSection .EligibilityBox ul li h5 {
        padding-top: 8px;
    }

    .ExamDetailsPageSection .EligibilityBox ul li h5 b {
        padding: 0px 0 0 !important;
    }

    .ExamDetailsPageSection .EligibilityBox h4 {
        background: #481f79 !important;
    }

    .ExamDetailsPageSection .EligibilityBox ul li i {
        background: #481f79 !important;
    }

    .ExamDetailsPageSection .EligibilityBox ul li h5 b i {
        background: #fff !important;
    }

    .ExamDetailsPageSection .EligibilityBox ul li h5 span {
        display: flex !important;
        gap: 10px;
    }

    .ExamDetailsPageSection .EligibilityBox ul {
        height: 170px !important;
    }

    .ExamDetailsPageSection .EligibilityBox ul li h5 b span i {
        color: #481f79 !important;
    }

    .linkLisi-items {
        box-shadow: 0 0 10px -3px #cecece;
        background: #fff;
        border-radius: 10px;
        height: 150px;
    }

    .linkLisi-items .links-area-box {
        margin-left: 1em;
    margin-top: 2em;
    }

    .linkLisi-items .links-area-box .info-area a {
        background-color: #481f79;
        padding: 6px 8px;
        font-size: 12px;
        color: #fff;
        border-radius: 4px;
    }

    .linkLisi-items .icon-heading {
        background: #481f79;
        color: #fff;
        padding: 14px;
        font-size: 16px;
        border-radius: 10px 10px 0 0;
        text-align: center;
        margin: 0;
    }
</style>

<!-- EXAM DETAILS HEADER PAGE SECTION -->
<?php if($kvsDetail){ ?>
<section class="allPageheaderSection wow fadeInDown">
    <div class="allPageheaderSectionbg"></div>
    <div class="container">
        <div class="row">
            <div class="col-md-12 col-sm-12 col-xs-12">
                <h2><?php echo $kvsDetail->name; ?> (<?php echo $kvsDetail->type; ?>)</h2>
                <h1>Get the most recent information on Kendriya Vidyalaya Sangathan (KVS) including Notifications, Online Applications, Admission Requirements, Official Website and other topics.</h1>
                <p><a href="/">Home</a> / <a href="/kendriya-vidyalaya-sangathan/">kvs</a> / <?php echo $kvsDetail->name; ?></p>
            </div>
        </div>
    </div>
</section>

<!-- END EXAM DEATILS HEADER PAGE SECTION -->

<!-- EXAM DETAILS PAGE SECTION -->
<section class="ExamDetailsPageSection">
    <div class="container">
        <div class="row">
            <div class="col-md-8 col-sm-8 col-xs-12">
                <div class="EligibilityBox">
                    <h4><?php echo $kvsDetail->name . ', ' . $kvsDetail->city; ?></h4>
                    <ul id="custom-scroll">
                        <li>
                            <i class="far fa-user"></i>
                            <h5>
                                Address
                                <b class="" style="display: flex; justify-content: left; gap: 170px; margin-bottom: 10px;">
                                    <span><i class="fa fa-globe"></i> <?php echo $kvsDetail->state_name; ?></span>
                                    <span><i class="fa fa-flag"></i><?php echo $kvsDetail->city; ?></span>
                                </b>

                                <b>
                                    <span><i class="fa fa-location-arrow"></i><?php echo $kvsDetail->address . ', ' . $kvsDetail->pincode; ?> </span>

                                    <?php if ($kvsDetail->important_emails != '') { ?>
                                        <span>
                                            <i class="fa fa-envelope"></i>
                                            <?php echo $kvsDetail->important_emails; ?>
                                        </span>
                                    <?php } ?>

                                    <?php if ($kvsDetail->important_phones != '') { ?>
                                        <span>
                                            <i class="fa fa-phone-square"></i><?php echo $kvsDetail->important_phones; ?>
                                        </span>
                                    <?php } ?>
                                </b>
                            </h5>
                        </li>

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

            <div class="col-md-4 col-sm-4 col-xs-12">
                <div class="linkLisi-items">
                    <h5 class="icon-heading">Important Links</h5>
                    <div class="links-area-box">
                        <span class="info-area">
                            <?php if ($kvsDetail->addmission_details != '') { ?><a href="<?php echo $kvsDetail->addmission_details; ?>" target="_blank">Addmission Details</a><?php } ?>
                            <?php if ($kvsDetail->result_link != '') { ?><a href="<?php echo $kvsDetail->result_link; ?>" target="_blank">Result</a><?php } ?>
                            <?php if ($kvsDetail->online_fee_link != '') { ?><a href="<?php echo $kvsDetail->online_fee_link; ?>" target="_blank">Fee</a><?php } ?>
                            <?php if ($kvsDetail->online_apply_link != '') { ?><a href="<?php echo $kvsDetail->online_apply_link; ?>" target="_blank">Apply</a><?php } ?>
                            <?php if ($kvsDetail->official_website_link != '') { ?><a href="<?php echo $kvsDetail->official_website_link; ?>" target="_blank">Official Website</a><?php } ?>
                        </span>
                    </div>
                </div>
            </div>
        </div>
    </div>
</section>

<?php } else { 
    ?>
    <p>No data found</p>
    <a href="/">Back to Home</a>
    <?php
} ?>
<!-- END EXAM DETAILS PAGE SECTION -->