<?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_INSTITUTION = "sp_institutions";
$TT_INSTITUTION_CATEGORY = "sp_institutions_category";

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

$limit = 13;  // limit to show exam data

// to get details of kvs school as per state id
$instituteDetail = $wpdb->get_results("SELECT i.id, i.institutions_name, i.category_id, ic.category_name, s.state_name, s.image_icon, c.city, i.address FROM $TT_INSTITUTION AS i LEFT JOIN $TT_INSTITUTION_CATEGORY AS ic ON ic.id=i.category_id LEFT JOIN $TT_STATES AS s on s.state_id = i.state_id LEFT JOIN $TT_CITIES AS c ON c.city_id=i.city_id where i.status='1' order by i.display_order limit 0, $limit");
$instituteDetailCount = $wpdb->num_rows;

// to get details of state as per university institution
$instStateCount = $wpdb->get_results("SELECT i.state_id, count(i.id) as scount, s.state_name FROM $TT_INSTITUTION as i LEFT JOIN $TT_STATES as s ON s.state_id=i.state_id WHERE i.status='1' group by i.state_id order by s.state_name");
// to get details of category as per university institution
$instCatCount = $wpdb->get_results("SELECT i.category_id, count(i.id) as ccount, c.category_name FROM $TT_INSTITUTION as i INNER JOIN $TT_INSTITUTION_CATEGORY as c ON c.id=i.category_id WHERE i.status='1' group by i.category_id order by c.display_order
 ");
?>
<style>
    .mark,
    mark {
        padding: 0px !important;
        background-color: #ff0;
    }

    .NotificationRightBox .NotificationExamBox a span {
        background: #085fca;
        font-size: 10px;
        padding: 2px 6px;
        margin-left: 10px;
        border-radius: 4px;
        display: inline-block;
        color: #fff;
        line-height: normal;
    }
</style>

<!-- ALL PAGE HEADER SECTION -->

<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>University Institutions (UI)</h2>
                <h1>Discover more about India's Top Universities and Colleges. Receive updates on announcements, online admission, notifications, the official website, etc.</h1>
                <p><a href="/">Home</a> / University Institutions</p>
            </div>
        </div>
    </div>
</section>

<!-- END ALL PAGE HEADER SECTION -->

<!-- NOTIFICATION PAGE SECTION -->

<section class="NotificationPageSection">
    <div class="container">
        <!-- Display-Horizontal-Full -->
        <ins class="adsbygoogle"
            style="display:block"
            data-ad-client="ca-pub-2967295438144070"
            data-ad-slot="7766773989"
            data-ad-format="auto"
            data-full-width-responsive="true"></ins>
        <script>
            (adsbygoogle = window.adsbygoogle || []).push({});
        </script>
        <div class="row">
            <div class="col-md-4 col-sm-4 col-xs-12">
                <div class="NotificationLeftBox wow fadeInLeft">

                    <div class="d-flex" style="justify-content: space-between;">
                        <h4>Search University or College</h4>
                        <button class="accrd btn btn-default d-md-none mb-2" type="button" data-bs-toggle="collapse" data-bs-target="#mobileSidebar" aria-controls="mobileSidebar" aria-expanded="false" aria-label="Toggle navigation">
                            ☰
                        </button>
                    </div>
                    <form action="">
                        <i class="fas fa-search"></i>
                        <input type="text" id="search_data" placeholder="Exam name, Title or etc...">
                    </form>

                    <hr>

                    <div class="collapse d-md-block" id="mobileSidebar">
                        <h4>Filter By Type</h4>
                        <ul>
                            <li>
                                <?php foreach ($instCatCount as $cat) {  ?>
                            <li><input type="checkbox" name="catg_data" value="catg_<?php echo $cat->category_id; ?>"><label for="catg_<?php echo $cat->category_id; ?>"><?php echo $cat->category_name; ?> <?php echo '(' . $cat->ccount . ')'; ?> </label></li>
                        <?php } ?>
                        </ul>

                        <hr>

                        <h4>Filter By State</h4>
                        <ul>
                            <?php foreach ($instStateCount as $state) { ?>
                                <li><input type="checkbox" name="inst_data" value="state_<?php echo $state->state_id; ?>"><label for="state_<?php echo $state->state_id; ?>"><?php echo $state->state_name; ?> <?php echo '(' . $state->scount . ')'; ?> </label></li>
                            <?php } ?>
                        </ul>
                    </div>
                </div>
            </div>

            <div class="col-md-8 col-sm-8 col-xs-12">
                <div class="NotificationRightBox">
                    <div class="NotificationRightBoxHeader wow fadeInDown">
                        <h4>Show <b><span id="countData"><?php echo $instituteDetailCount; ?> </span> </b>Notification</h4> <a onclick="clearAll();" style="cursor:pointer;">Clear all</a>
                    </div>
                    <?php if ($instituteDetailCount > 0) { ?>
                        <div id="instList" class="instList">
                            <?php foreach ($instituteDetail as $inst) {    ?>
                                <div class="NotificationExamBox wow fadeInUp">
                                    <div class="NotificationExamFlexBox">
                                        <?php if ($inst->image_icon != '') { ?>
                                            <img src="/images/<?php echo $inst->image_icon; ?>" width="60" alt="">
                                        <?php } ?>
                                        <div class="NotificationExamBoxDetails">
                                            <a href="#"><?php echo $inst->institutions_name; ?> <span><?php echo $inst->category_name; ?></span> </a>
                                            <p>
                                                <span title="State" style="color: #ed2551;"><i class="fa fa-globe"></i> <?php echo $inst->state_name; ?></span>
                                                <span title="City" style="color: #ed2551;"><i class="fa fa-flag"></i> <?php echo $inst->city; ?></span> <br>
                                                <span title="Location" style="color: #16a839;"><i class="fa fa-location-arrow"></i> <?php echo $inst->address; ?></span>
                                            </p>
                                        </div>
                                    </div>
                                    <i class="far fa-bookmark"></i>
                                    <i class="fas fa-bookmark" style="display: none;color: #f1c512;"></i>
                                </div>
                            <?php } ?>
                        </div>

                        <div class="loadmore">
                            <input type="button" id="loadBtn" class="SelectStateBtn" style="display:flex; margin: 0 auto;" value="See More">
                            <input type="hidden" id="data_row" value="0">
                            <input type="hidden" id="data_row1" value="">
                        </div>
                        <a id="showBlankData" style="display:none;" href="/university-institution/" class="SeeMoreBtn wow fadeInUp"></a>

                    <?php } else { ?>
                        <div class="NotificationExamBox wow fadeInUp">
                            <div class="NotificationExamFlexBox">
                                <a href="/university-institution/">No information available: Click here to go on home page</a>
                            </div>
                        </div>

                    <?php } ?>
                </div>
            </div>
        </div>
    </div>
</section>

<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.6.1/jquery.min.js"></script>

<script>
    // to highlight text
    function hightlightTxt(search_name) {
        var searchfilter = new RegExp(search_name + "(?=[^>]*<)", "ig");
        var repstr = "<mark>$&</mark>";
        $('.instList').html($('.instList').html().replace(searchfilter, repstr));
    }

    $(document).ready(function() {

        // search data using search field
        $('#search_data').keyup(function() {
            var trim_str = $(this).val();
            var search_name = $.trim(trim_str);

            var searchfilter = new RegExp(search_name + "(?=[^>]*<)", "ig");
            var repstr = "<mark>$&</mark>";
            $('.instList').html($('.instList').html().replace(/(^\s+|\s+$)/g, ""));

            if (search_name != '') {
                hightlightTxt(search_name);
                if (search_name.length >= 2) {
                    searchExam(search_name);
                }
            } else {
                location.reload(true); // clearAll();  // searchExam();
            }
        });

        // search function
        function searchExam(search_name) {

            //state-wise data
            if ($('[name="inst_data"]').is(':checked')) {
                var state_selection = [];
                $.each($("input[name='inst_data']:checked"), function() {
                    state_selection.push($(this).val());
                });
                var state_filter = state_selection.join(", ");
            } else {
                var state_filter = '';
            }
            // category wise data
            if ($('[name="catg_data"]').is(':checked')) {
                var inst_selection = [];
                $.each($("input[name='catg_data']:checked"), function() {
                    inst_selection.push($(this).val());
                });
                var inst_filter = inst_selection.join(", ");
            } else {
                var inst_filter = '';
            }

            var url = '/wp-content/plugins/nc_plugin/api/nc_institute_data.php';
            $.ajax({
                url: url,
                type: 'POST',
                data: {
                    "school_name": search_name,
                    "inst_filter": inst_filter,
                    "state_filter": state_filter
                },
                beforeSend: function() {
                    $('#loader').show();
                },
                success: function(response) {
                    if (response != '') {
                        $('#loader').hide();
                        $('#instList').html(response);
                        var pagenum = $('input[name="page_count"]').val();
                        $('#countData').text(pagenum);
                        hightlightTxt(search_name);
                        $('#loadBtn').css("display", "none");
                    }
                }
            });
        }

        // load more button
        $(document).on('click', '#loadBtn', function() {
            var data_row = Number($('#data_row').val());
            var row_count = $('#countData').text();
            //state-wise data
            if ($('[name="inst_data"]').is(':checked')) {
                var state_selection = [];
                $.each($("input[name='inst_data']:checked"), function() {
                    state_selection.push($(this).val());
                });
                var state_filter = state_selection.join(", ");
            } else {
                var state_filter = '';
            }
            // category wise data
            if ($('[name="catg_data"]').is(':checked')) {
                var inst_selection = [];
                $.each($("input[name='catg_data']:checked"), function() {
                    inst_selection.push($(this).val());
                });
                var inst_filter = inst_selection.join(", ");
            } else {
                var inst_filter = '';
            }
            var limit = <?php echo $limit; ?>;
            data_row = data_row + limit;
            $('#data_row').val(data_row);

            var url = '/wp-content/plugins/nc_plugin/api/nc_institute_data.php';
            $.ajax({
                url: url,
                type: 'POST',
                data: {
                    'data_row': data_row,
                    "inst_filter": inst_filter,
                    "state_filter": state_filter,
                    'limit': limit
                },
                beforeSend: function() {
                    $('#loader').show();
                },
                success: function(data) {
                    $('#loader').hide();
                    var rowCount = data_row + limit;
                    $('.instList').append(data);
                    $('#countData').html(rowCount);
                    var pagenum = $('input[name="page_count"]').val();
                    var totalnum = $('input[name="data_row_count"]').val();

                    if (parseInt(totalnum) > parseInt(rowCount)) {
                        $(".loadmore").show();
                        $('#loadBtn').css("display", "block");
                    } else {
                        $('#loadBtn').css("display", "none");
                        $(".loadmore").hide();
                    }
                }
            });
        });

        // show state-data as per checkbox button
        $('input[name="inst_data"]').on('change', function() {
            var state_selection = [];
            $.each($("input[name='inst_data']:checked"), function() {
                state_selection.push($(this).val());
            });
            if (state_selection.length > 0) {
                var state_filter = state_selection.join(", ");
                showState(state_filter);
            } else {
                if ($('[name="catg_data"]').is(':checked')) {

                } else {
                    location.reload(true);
                }
            }
        });

        // to show university-wise data filter
        $('input[name="catg_data"]').on('change', function() {
            var inst_selection = [];
            $.each($("input[name='catg_data']:checked"), function() {
                inst_selection.push($(this).val());
            });
            if (inst_selection.length > 0) {
                var inst_filter = inst_selection.join(", ");
                showUniversity(inst_filter);
            } else {
                if ($('[name="inst_data"]').is(':checked')) {

                } else {
                    location.reload(true);
                }
            }
        });

        //function to get state wise-data as per input radio button
        function showState(state_filter) {
            $('#search_data').val('');
            var limit = <?php echo $limit; ?>;
            // category wise data
            if ($('[name="catg_data"]').is(':checked')) {
                var inst_selection = [];
                $.each($("input[name='catg_data']:checked"), function() {
                    inst_selection.push($(this).val());
                });
                var inst_filter = inst_selection.join(", ");
            } else {
                var inst_filter = '';
            }
            var url = '/wp-content/plugins/nc_plugin/api/nc_institute_data.php';
            $.ajax({
                url: url,
                type: 'POST',
                data: {
                    "state_filter": state_filter,
                    "inst_filter": inst_filter,
                    "limit": limit
                },
                beforeSend: function() {
                    $('#loader').show();
                },
                success: function(response) {
                    $('#instList').html(response);
                    $('#loader').hide();
                    var pagenum = $('input[name="page_count"]').val();
                    var totalnum = $('input[name="data_row_count"]').val();
                    $('#countData').text(pagenum);
                    $('#data_row1').val(totalnum);

                    if (parseInt(totalnum) > parseInt(pagenum)) {
                        $('#loadBtn').css("display", "block");
                        $(".loadmore").show();
                    } else {
                        $('#loadBtn').css("display", "none");
                        $(".loadmore").hide();
                    }
                }
            });
        }

        //function to get university-data as per input radio button
        function showUniversity(inst_filter) {
            $('#search_data').val('');
            var limit = <?php echo $limit; ?>;
            //state-wise data
            if ($('[name="inst_data"]').is(':checked')) {
                var state_selection = [];
                $.each($("input[name='inst_data']:checked"), function() {
                    state_selection.push($(this).val());
                });
                var state_filter = state_selection.join(", ");
            } else {
                var state_filter = '';
            }
            var url = '/wp-content/plugins/nc_plugin/api/nc_institute_data.php';
            $.ajax({
                url: url,
                type: 'POST',
                data: {
                    "inst_filter": inst_filter,
                    "state_filter": state_filter,
                    "limit": limit
                },
                beforeSend: function() {
                    $('#loader').show();
                },
                success: function(response) {
                    $('#instList').html(response);
                    $('#loader').hide();
                    var pagenum = $('input[name="page_count"]').val();
                    var totalnum = $('input[name="data_row_count"]').val();
                    $('#countData').text(pagenum);
                    $('#data_row1').val(totalnum);

                    if (parseInt(totalnum) > parseInt(pagenum)) {
                        $(".loadmore").show();
                        $('#loadBtn').css("display", "block");
                    } else {
                        $('#loadBtn').css("display", "none");
                        $(".loadmore").hide();
                    }
                }
            });
        }
    });

    // CLEAR ALL DATA FILter
    function clearAll() {
        location.reload(true);
    }
</script>

<!-- END NOTIFICATION PAGE SECTION -->