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

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

global $wpdb;
$TT_EXAM = "sp_exam";
$TT_EXAM_LINKS = "sp_exam_links";
$TT_EXAM_CATEGORY = "sp_exam_category";
$TT_EXAM_ENTITY = "sp_exam_entity";
$NC_AD = "ads_nc_pages";

$limit = 6;  // limit to show exam data
/******** query to get data as per category slug id **********/
$categoryDetailQuery = $wpdb->get_results("SELECT e.exam_name, e.url_slug, e.exam_summary, e.add_date, c.name, c.img_icon, n.name, l.entity_id, l.display_text FROM $TT_EXAM AS e LEFT JOIN $TT_EXAM_CATEGORY AS c ON e.cat_id = c.cat_id LEFT JOIN $TT_EXAM_LINKS as l on e.exam_id=l.exam_id LEFT JOIN $TT_EXAM_ENTITY as n ON n.id=l.entity_id WHERE l.status!='0' and e.status!='0' and n.status!='0' AND c.status!='0' AND c.url_slug='$url_slug' group by e.exam_id order by e.display_order desc limit 0, $limit");
$categoryCount = $wpdb->num_rows;
/******** query to get data for all category **********/
$categoryQuery = $wpdb->get_results("SELECT cat_id,name,url_slug,img_icon from $TT_EXAM_CATEGORY WHERE status='1' order by display_order ASC");
/******** query to get data for heading and navigation category **********/
$categoryData = $wpdb->get_row("SELECT cat_id,full_name,h1_title, name,img_icon from $TT_EXAM_CATEGORY WHERE status='1' AND url_slug='$url_slug'");

$catName = trim($_SERVER['REQUEST_URI'], "/");
$getAd = $wpdb->get_row("select id, ad_image, link from $NC_AD where find_in_set('$catName', page_exam_name) <> 0 and status='1' and type='category'");
?>
<style>
  .mark,
  mark {
    padding: 0px !important;
    background-color: #ff0;
  }
  .NotificationExamFlexBox img{
    width: 50px;
    min-width: 50px;
    max-width: 50px;
  }
</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><?php echo $categoryData->full_name; ?> (<?php echo $categoryData->name; ?>)</h2>
        <?php if ($categoryData->h1_title != '') { ?><h1><?php echo $categoryData->h1_title; ?></h1><?php } ?>
        <p><a href="/">Home</a> / <?php echo $categoryData->name; ?></p>
      </div>
    </div>
  </div>
</section>

<!-- END ALL PAGE HEADER SECTION -->
<!-- google ads section -->
<?php if ($getAd) { ?>
  <section class="ad_horizontal">
    <div class="container">
      <div class="row">
        <div class="col-md-12 col-sm-12 col-xs-12 text-center">
          <a href="<?php echo $getAd->link; ?>" target="_blank" onclick="trackAdClick('<?php echo $getAd->id; ?>', 'exam-category', '<?php echo addslashes($getAd->link); ?>');">
            <img src="/all_uploads/adImage/<?php echo $getAd->ad_image; ?>" alt="">
          </a>
        </div>
      </div>
    </div>
  </section>
<?php } ?>
<section class="ad_horizontal">
    <div class="container">
      <div class="row">
        <div class="col-md-12 col-sm-12 col-xs-12 text-center">
          <!-- 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>
      </div>
    </div>
</section>
<!-- google ads section -->
<!-- SSC PAGE SECTION -->

<section class="NotificationPageSection SSCPageSection">
  <div class="container">
    <div class="row">
      <!-- <img class="AddsImg" src="https://sarkaripariksha.com/ticket_bck/banners/1674217078-banner.png" alt=""> -->
      <div class="col-md-4 col-sm-4 col-xs-12">
        <div class="NotificationLeftBox wow fadeInLeft">
          <h4>Search Category Exams</h4>
          <form action="">
            <i class="fas fa-search"></i>
            <input type="text" id="search_data" placeholder="Exam name, Title or etc...">
          </form>
          <hr>

          <h4>Other Categories</h4>
          <ul>
            <?php foreach ($categoryQuery as $cat) {  ?>
              <li>
                <a href="/<?php echo $cat->url_slug; ?>/">
                  <?php if ($cat->img_icon != '') { ?>
                    <img src="/images/<?php echo $cat->img_icon; ?>" alt="">
                  <?php } ?>
                  <?php echo ucfirst($cat->name); ?>
                </a>
              </li>
            <?php } ?>
          </ul>
        </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 $categoryCount; ?> </span> </b> Category Exams</h4> <a onclick="clearAll();" style="cursor:pointer;">Clear all</a>
          </div>
          <div id="loader" style="display:none">
            <p align="center"><i class="fa fa-spinner fa-spin"></i> Loading...</p>
          </div>

          <div id="categoryList" class="categoryList">
            <?php foreach ($categoryDetailQuery as $exam) {
              if ($exam->display_text != '') {
                $display_text = $exam->display_text;
              } else {
                $display_text = $exam->name;
              } ?>

              <div class="NotificationExamBox wow fadeInUp">
                <div class="NotificationExamFlexBox">
                  <?php if ($exam->img_icon != '') { ?>
                    <img src="/images/<?php echo $exam->img_icon; ?>" alt="">
                  <?php } ?>
                  <div class="NotificationExamBoxDetails">
                    <a href="/exam-details/<?php echo $exam->url_slug; ?>/"><?php echo $exam->exam_name; ?>
                      <h6><?php if (strlen($exam->exam_summary) < 120) {
                            echo $exam->exam_summary;
                          } else {
                            echo substr($exam->exam_summary, 0, 120) . '...';
                          } ?></h6>
                      <p>
                        <span title="<?php echo $display_text; ?>" style="color: #ed2551;"><i class="fas fa-calendar-alt"></i> <?php echo date('jS M Y', strtotime($exam->add_date)); ?></span>
                      </p>
                    </a>
                  </div>
                </div>
              </div>
            <?php } ?>
          </div>

          <div class="loadmore">
            <input type="button" id="loadBtn" class="SeeMoreBtn wow fadeInUp" value="See More">
            <input type="hidden" id="data_row" value="0">
            <input type="hidden" id="data_row1" value="">
          </div>

        </div>
      </div>
    </div>
  </div>
</section>

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

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


  $(document).ready(function() {

    // load more button
    $(document).on('click', '#loadBtn', function() {
      var data_row = Number($('#data_row').val());
      var row_count = $('#countData').text();
      var limit = <?php echo $limit; ?>;
      var url_slug = '<?php echo $url_slug; ?>';
      data_row = data_row + limit;
      $('#data_row').val(data_row);

      var url = '/wp-content/plugins/nc_plugin/api/nc_exam_category_data.php';
      $.ajax({
        url: url,
        type: 'POST',
        data: {
          'data_row': data_row,
          "id": url_slug,
          'limit': limit
        },
        success: function(data) {
          var rowCount = data_row + limit;
          $('.categoryList').append(data);
          $('#countData').html(rowCount);
          var pagenum = $('input[name="page_count"]').val();
          var totalnum = $('input[name="data_row_count"]').val();

          if (parseInt(totalnum) >= parseInt(pagenum)) {
            $("#loadBtn").show();
          } else {
            $("#loadBtn").hide();
          }
        }
      });
    });

    // 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>";
      $('.categoryList').html($('.categoryList').html().replace(/(^\s+|\s+$)/g, ""));

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

    // search function
    function searchExam(search_name) {
      var url_slug = '<?php echo $url_slug; ?>';
      var url = '/wp-content/plugins/nc_plugin/api/nc_exam_category_data.php';
      $.ajax({
        url: url,
        type: 'POST',
        data: {
          "id": url_slug,
          "exam_name": search_name
        },
        beforeSend: function() {
          $('#loader').show();
        },
        success: function(response) {
          if (response != '') {
            $('#loader').hide();
            $('#categoryList').html(response);
            var pagenum = $('input[name="page_count"]').val();
            $('#countData').text(pagenum);
            hightlightTxt(search_name); // function for highlighting data
            $('#loadBtn').css("display", "none");
          }
        }
      });
    }
  });

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

<!-- END SSC PAGE SECTION -->