<?php  
include 'header.php';

$count="select count(*) as total from sp_institutions_category";
$sql=$db->prepare($count);
$sql->execute();
$plus=$sql->fetch();

$query="SELECT id, category_name, display_order, status, added_date FROM sp_institutions_category";
$sql=$db->prepare($query);
$sql->execute();

 ?>
 
            <!-- Main Container -->
            <main id="main-container">
               
 <div class="content content-narrow">
  <?php  

if(isset($_REQUEST['submit'])){
	$id=$_REQUEST['id'];
	$category= $_REQUEST['category'];
	$order= $_REQUEST['num'];
	$stat=$_REQUEST['status'];
	
$query="UPDATE sp_institutions_category SET category_name = '$category', display_order = '$order', status = '$stat' WHERE sp_institutions_category.id = '$id'";
	$sql=$db->prepare($query);
	$sql->execute();
     echo "<meta http-equiv='refresh' content='0'>";
}
 
 ?>                  <!-- Forms Row -->
                    <div class="row">
                        <div class="col-lg-12">
                            <!-- Bootstrap Forms Validation -->
                            <h2 class="content-heading">Exam Category List</h2>
                            <table class="table table-striped table-hover text-capitalize">
                            <thead>
                                 <tr class="danger">
								    <th class="text-center">S.no</th>
                                   <th class="text-center">Category Name</th>
                                   <th class="text-center">Display Order </th>
								   <th class="text-center">status</th>
								   <th class="text-center"> Added Date</th>
                                    <th class="text-center">Edit</th>
                                   <th class="text-center">Delete</th>
								   </tr>
								   
						    </thead>
							<?php $i='1';
                             while($row=$sql->fetch()){ 
							?>
							<tr>
							<td class="text-center"><?php  echo $i; ?></td>
							<td class="text-center"><?php  echo $row['category_name']; ?></td>
							<td class="text-center"><?php  echo $row['display_order']; ?></td>
							<td class="text-center"><?php if($row['status']=="1"){echo '<span style="color:green;">Active </span>';}else if($row['status']=="0"){echo '<span style="color:red;">De-Active </span>';} ?></td>
							<td class="text-center"><?php  echo $row['added_date']; ?></td>
							<td class="text-center"><button name="edit"  class="btn btn-info" onclick="selectData(<?php echo $row['id']; ?>)" data-toggle="tooltip" title="Edit this exam">Edit</button></td>
							<td class="text-center"><a style="color:#fff;" href="institutions_category_list_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!" data-placement="bottom">Delete</button></a></td>
							
							</tr>
							 <?php $i++; } ?>
							 <tr class="danger">
							 <th colspan='3'>Total Category</th>
							 <td colspan='4'><?php  echo $plus['total']; ?></td>
							 </tr> 
					         </table>

                            <!-- Bootstrap Forms Validation -->
                        </div>   
                        </div>
                    </div>
                    <!-- END Forms Row -->

                    
                </div>
                <!-------STATUS MODEL------------------------------->
               <div class=" modal fade" id="statusModel" role="dialog">
        <div class="modal-dialog">
            <div class="modal-content">
                <div class="modal-header">
                    <button type="button" class="close" data-dismiss="modal">&times;</button>
                    <h4 class="modal-title">Edit </h4>
                </div>
                <div class="modal-body">
                     <form class="js-validation-bootstrap form-horizontal" action="" method="post" id="form">
					 <input type="hidden" id="id" name="id">
                                        <div class="form-group">
                                            <label class="col-md-4 control-label" for="val-username">Category Name<span class="text-danger">*</span></label>
                                            <div class="col-md-7">
                                                <input class="form-control" type="text" id="cat" name="category" placeholder="">
                                            </div>
                                        </div>
                                       
                                        <div class="form-group">
                                            <label class="col-md-4 control-label" for="val-confirm-password">Display order<span class="text-danger">*</span></label>
                                            <div class="col-md-7">
                                                <input class="form-control" type="number"  id="display" name="num" placeholder="">
                                            </div>
                                        </div>
										<div class="form-group">
                                            <label class="col-md-4 control-label" for="val-email">Status <span class="text-danger">*</span></label>
                                            <div class="col-md-7">
                                                <select name="status" class="form-control">
											  <option  id="status" value=""></option>
											  <option value="1">Active</option>
											  <option value="0">Deactive</option>
											  </select>
                                            </div>
                                        </div>
										<div class="form-group">
                                            <div class="col-md-8 col-md-offset-4">
                                                <button class="btn btn-sm btn-primary" type="submit" name="submit">Submit</button>
                                            </div>
                                        </div>
                                    </form>
                </div>
            </div>
        </div>
    </div>
          <!---------END STATUS MODEL----->          
                <!-- END Page Content -->
            </main>
			
			<script type="text/javascript">
              
                function selectData(id) {
					var base_url = window.location.origin;
         // alert(id);
					  
 $.ajax('institutions_category_list_ajax.php', {
            type: 'POST',
            data: { id:id }, 
            success: function (data) {
            console.log(data);
			document.getElementById("cat").value=data.category_name;
			document.getElementById("display").value=data.display_order;
			document.getElementById("status").value=data.status;
			document.getElementById("id").value=id;
			if(document.getElementById("status").value=="1"){
				document.getElementById("status").innerHTML="Active";
			}
			else if(document.getElementById("status").value=="0"){
				document.getElementById("status").innerHTML="De-Active";
			}
            },
            error: function (jqXhr, textStatus, errorMessage) {
                   

                }
        });
jQuery("#statusModel").modal(); 
                
                }
				
			
            </script>
			<?php  include 'footer.php'; ?>
            <!-- END Main Container -->