<?php
include 'header.php';
$POST_TABLE = "naukri_wp_posts";

$strreplace = array(" ", "&");
$replace = array("-", "-");

?>
<script type="text/javascript" charset="utf8" src="assets/js/jquery-1.4.1.min.js"></script>
<script type="text/javascript" charset="utf8" src="assets/js/jquery.dataTables.min.js"></script>
<link rel="stylesheet" href="assets/css/jquery.dataTables.min.css">
<script type="text/javascript">
  jQuery.noConflict();
  jQuery(function($) {
    jQuery('#kvnv').dataTable({
      "bPaginate": true,
      "responsive": true,
      "iDisplayLength": 50,
      "lengthMenu": [
        [100, 150, 200, 500],
        [100, 150, 200, 500]
      ]
    });
  });
</script>
<!-- Main Container -->
<main id="main-container">
  <div class="content content-narrow">
    <?php

    $TABLE_KVS_NVS = "sp_kvs_navodya";
    $TABLE_STATE = "sp_states";
    $TABLE_CITY = "sp_city";

    $query = "SELECT kn.id, kn.type, kn.name, kn.url_slug,  kn.state_id, kn.city_id,kn.pincode,kn.address, kn.longitude, kn.latitude,kn.important_emails, kn.important_phones, kn.official_website_link, kn.online_apply_link, kn.online_fee_link, kn.result_link, kn.other_info,kn.display_order, kn.status,s.state_name ,kn.add_date,c.city as city FROM  $TABLE_KVS_NVS as kn LEFT JOIN $TABLE_STATE as s on s.state_id=kn.state_id LEFT JOIN $TABLE_CITY as c on c.city_id=kn.city_id where kn.type='NVS' order by kn.add_date desc";
    $sql = $db->prepare($query);
    $sql->execute();
    ?>

    <!-- Forms Row -->
    <div class="row">
      <div class="col-lg-12">
        <!-- Bootstrap Forms Validation -->
        <h2 class="content-heading">NVS List</h2>
        <!-- <button name="addpost" class="btn btn-info" onclick="addAllPages()" title="Add All Post For Exams">Add All Page</button> -->

        <div style="overflow-x:auto;">
          <div id="msg"></div>
          <div class="table-responsive">
            <table id="kvnv" class="table table-striped table-bordered dt-responsive nowrap" style="width: 100%; cellspacing: 0;">
              <thead>
                <tr>
                  <th>S.No.</th>
                  <th>Type</th>
                  <th>Edit</th>
                  <th>Delete</th>
                  <th>name</th>
                  <th>url-slug</th>
                  <th>State</th>
                  <th>City</th>
                  <th>Pincode</th>
                  <th>Address</th>
                  <th>longitude</th>
                  <th> latitude</th>
                  <th>Important Email</th>
                  <th>important phones</th>
                  <th>official website link</th>
                  <th>online apply link</th>
                  <th>online fee link</th>
                  <th>result link</th>
                  <th>other info</th>
                  <th>display order</th>
                  <th>status</th>
                </tr>
              </thead>
              <tbody>
                <?php $i = '1';
                while ($row = $sql->fetch()) {
                ?>

                  <tr>
                    <td> <?php echo $i; ?></td>
                    <td><?php echo $row['type']; ?></td>
                    <td><a class="btn btn-info" href="edit_kvs_navodya_list.php?id=<?php echo $row['id']; ?>" title="Edit this exam" target="_blank">Edit</a>

                    </td>
                    <td><a style="color:#fff;" href="kvs_delete.php?id=<?php echo $row['id']; ?>" onclick="return confirm('Are you sure you want to delete')"><button class="btn btn-danger" data-toggle="tooltip" title="Delete this exam!">Delete</button></a></td>
                    <td><?php echo $row['name']; ?></td>
                    <td><?php echo $row['url_slug']; ?></td>
                    <td><?php echo $row['state_name']; ?></td>
                    <td><?php echo $row['city']; ?></td>
                    <td><?php echo $row['pincode']; ?></td>
                    <td><?php echo $row['address']; ?></td>
                    <td><?php echo $row['longitude']; ?></td>
                    <td><?php echo $row['latitude']; ?></td>
                    <td><?php echo $row['important_emails']; ?></td>
                    <td><?php echo $row['important_phones']; ?></td>
                    <td><?php echo $row['official_website_link']; ?></td>
                    <td><?php echo $row['online_apply_link']; ?></td>
                    <td><?php echo $row['online_fee_link']; ?></td>
                    <td><?php echo $row['result_link']; ?></td>
                    <td><?php echo $row['other_info']; ?></td>
                    <td><?php echo $row['display_order']; ?></td>
                    <td><?php echo $row['status']; ?></td>
                  </tr>
                <?php $i++;
                } ?>
              </tbody>

              <!-- <tr class="danger">
              <th colspan='11'>Total </th>
              <td colspan='10 '><?php  //echo $plus['total']; 
                                ?></td>
            </tr>    -->
            </table>
          </div>
        </div>

        <!-- Bootstrap Forms Validation -->

      </div>
    </div>
  </div>
  </div>
</main>

<script>
  //add all pages at once

  // function addAllPages() {
  //   var id = 'nvs-kvs-page';
  //   var site = "add_all_page.php";
  //   jQuery.ajax({
  //     url: site,
  //     type: 'POST',
  //     data: {
  //       id: id
  //     },
  //     success: function(data) {
  //       console.log(data);
  //       $('#msg').html(data);
  //     }
  //   });
  // }
</script>
<?php include 'footer.php'; ?>
<!-- END Main Container -->