<?php 
include ("include/makeSession.php");
$installment_id=mysqli_query($con,"select * from admin where id='".$_SESSION["ecomid"]."'");
	  $installment_id=mysqli_fetch_array($installment_id); 
$installment_id=$installment_id['menuper'];
	  $menuper=explode(',',$installment_id);
	   
	   if(in_array('Manage Library',$menuper)){
		  
	   }else{
		 
	header("location:index.php");
		   
		}
$_SESSION['page_name']="Library";
include('include/function.php');
include("include/header.php");
include("include/sidebar.php");

if(isset($_REQUEST['did']) && $_REQUEST['did']!=''){
	$dovalue="";
	$doid=$_REQUEST['did'];
	mysqli_query($con,"delete from issue_book where id=".$doid);
	echo '<META HTTP-EQUIV="Refresh" Content="0; URL=view_issue_book.php">';
	exit;
}
if(isset($_REQUEST['upid']) && $_REQUEST['upid']!=''){
	  $dovalue="EditIssueBookEntry";
	  $doid=$_REQUEST['upid'];
	  $upuserresult=mysqli_query($con,"select * from issue_book where id=".$_REQUEST['upid']);
	  $upuserarr=mysqli_fetch_array($upuserresult);
}else{
 	  $dovalue="IssueBook";
	  $doid='';
	 
}
?>   
<div class="content-wrapper">
  <!-- Content Header (Page header) -->
  <section class="content-header">
    <h1> Issue Book <small></small> </h1>
    <ol class="breadcrumb">
      <li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li>
      <li><a href="#">Issue Book</a></li>
    </ol> 
  </section>
  <!-- Main content -->
  
                <?php 
        if(!empty($_SESSION['msg'])){
		    $msg=$_SESSION["msg"];
            echo '<div class="col-md-12">
			<div class="alert alert-danger alert-dismissible">
                <a href="#" class="close" data-dismiss="alert" aria-label="close">&times;</a>
                '.$msg.'
		    </div>'; $_SESSION["msg"]='';} ?>
  
  <section class="content">
    <div class="row">
      <div class="col-md-12">
        <div class="box box-info">
          <div class="box-header">
            <h3 class="box-title"> Issue Book <small></small></h3>
            <!-- tools box -->
            <div class="pull-right box-tools">
              <button class="btn btn-info btn-sm" data-widget="collapse" data-toggle="tooltip" title="Collapse"><i class="fa fa-minus"></i></button>
              <button class="btn btn-info btn-sm" data-widget="remove" data-toggle="tooltip" title="Remove"><i class="fa fa-times"></i></button>
            </div><!-- /. tools -->
          </div><!-- /.box-header -->
          <div class="box-body pad">
            <div class="col-md-8">
<form method="post" action="action_library.php" name="addcategory" id="addcategory" enctype="multipart/form-data"  role="form">
                <input type="hidden"  name="do" value="<?php echo $dovalue;?>" />
                <input type="hidden"  name="doid" value="<?php echo $doid;?>" />
                <input type="hidden"  name="user_id" value="<?php echo $_SESSION["ecomid"];?>" />
                
               <div class="form-group">
                  <label>Student Id *</label>                 
                  <input name="student_id" id="student_id" value="<?php if(isset($_REQUEST['upid'])){ echo $upuserarr['student_id'];}?>" type="text" placeholder="Enter Student Id" class="form-control">
                </div>
                <div class="form-group">
                     <label>Student Name *</label>                 
                  <input name="student_name" id="student_name" value="<?php if(isset($_REQUEST['upid'])){ echo $upuserarr['student_name'];}?>" type="text" placeholder="Enter Student Name" class="form-control" readonly>
                </div>
                <div class="form-group" id="books_issued">
                </div>
                <div class="form-group">
                  <label>Book Name *</label>
                  <select name="book_id" id="book_id" class="form-control subject select-box" required>
                      <option >Select</option>
					  <?php $BookQuery=mysqli_query($con,"select * from book");
	  				 while($BookRow=mysqli_fetch_array($BookQuery)){ 
                     echo '<option value="'.$BookRow['id'].'" '.($upuserarr['book_id'] == $BookRow['id'] ? 'selected="selected"' : '' ).' >'.$BookRow['book_name'].'</option>';
					 } ?>
                                       
                  </select>    
                </div>
                
                <div class="form-group">
                  <label>Isbn *</label>                 
                  <input name="isbn" id="isbn" value="<?php if(isset($_REQUEST['upid'])){ echo $upuserarr['isbn'];}?>" type="text" placeholder="Enter Isbn Number" class="form-control" readonly>
                </div>
                <div class="form-group">
                  <label>Issue Date *</label>                 
                  <input name="issue_date" id="issue_date" value="<?php if(isset($_REQUEST['upid'])){ echo $upuserarr['issue_date'];}else{echo date("Y-m-d");}?>" type="date" placeholder="" class="form-control">
                </div>
                <?php
                //Due Date Calculation:
                    $keep_days=mysqli_fetch_array(mysqli_query($con,"select keep_days from library_settings"))['keep_days'];
                    $datex = strtotime("+".$keep_days." day", strtotime(date("Y-m-d")));
                    $duedate= date("Y-m-d", $datex);
                ?>
                <div class="form-group">
                  <label>Due Date *</label>                 
                  <input name="due_date" id="dob" value="<?php if(isset($_REQUEST['upid'])){ echo $upuserarr['due_date'];} else{ echo $duedate; }?>" type="date" placeholder="" required class="form-control">
                </div>
               
               
                <div class="row">                                                            
                    <div class="col-md-6">
                    <div class="form-group">
                        <input type="submit" id="submit" class="btn btn-primary" value="Issue Book"/>
                    </div>
                    </div>
                </div>
</form>
            </div>
          </div>
        </div><!-- /.box -->
      </div><!-- /.col-->
    </div><!-- ./row -->
  </section><!-- /.content -->
</div>
<?php include('include/footer.php');?>
<script>
    $(document).ready(function(){
        $('.select-box').select2();
        $('#student_id').blur(function(){
	        var vales=$('#student_id').val();
            $.ajax({  
                type: "POST",  
                url: "json_issue_book.php",  
                data: {'id': vales,'operation': "student"}, 
                dataType: "json",			
                success: function(dataString) { 
                    if(dataString.length==0){			
                        $('#student_name').val('');
                        
    		        }else{
            		    $('#student_name').val(dataString[0].name);
            		    if(dataString.length>1){
                		    $('#books_issued').append('<div class="form-group"><label>Already Issued Books:</label></div>');
                		    $('#books_issued').append('<b><div class="row text-success"><div class="col-md-3">Book ID</div><div class="col-md-3">Book Name</div><div class="col-md-3">Book ISBN</div></div></b>');
                		    
                		    for(var i=1;i<dataString.length;i++){
                        		$('#books_issued').append('<div class="row"><div class="col-md-3">'+dataString[i].book_id+'</div><div class="col-md-3">'+dataString[i].book_name+'</div><div class="col-md-3">'+dataString[i].isbn+'</div></div>');
                		    }
            		    }
    			    }
		        }  
            });
        });
        $('#book_id').change(function(){
	        var vales=$('#book_id').val();
            $.ajax({  
                type: "POST",  
                url: "json_issue_book.php",  
                data: {'id': vales,'operation': "book"}, 
                dataType: "json",			
                success: function(dataString) { 
                    if(dataString.length==0){			
                        $('#isbn').val('');
                        
    		        }else{
            		    $('#isbn').val(dataString.isbn);
                		   
    			    }
		        }  
            });
        });
    });
    
</script>