Gecko [ www.jdcpatala.org ]

Name	Size	Permission
Barcode Generator	[ DIR ]	drwxr-xr-x
assets	[ DIR ]	drwxr-xr-x
datatable	[ DIR ]	drwxr-xr-x
includes	[ DIR ]	drwxr-xr-x
uploads	[ DIR ]	drwxr-xr-x
add-almirah.php	4.21 KB	-rw-r--r--
add-author.php	4.19 KB	-rw-r--r--
add-book.php	27.85 KB	-rw-r--r--
add-category.php	2.53 KB	-rw-r--r--
add-class.php	4.03 KB	-rw-r--r--
add-currency.php	4.25 KB	-rw-r--r--
add-department.php	4.27 KB	-rw-r--r--
add-language.php	4.25 KB	-rw-r--r--
add-material.php	4.25 KB	-rw-r--r--
add-member-type.php	4.16 KB	-rw-r--r--
add-member.php	21.16 KB	-rw-r--r--
add-publication.php	4.39 KB	-rw-r--r--
add-session.php	4.63 KB	-rw-r--r--
add-shelf.php	4.17 KB	-rw-r--r--
add-source.php	4.21 KB	-rw-r--r--
add-status.php	4.19 KB	-rw-r--r--
add-subject.php	4.09 KB	-rw-r--r--
add-user.php	7.87 KB	-rw-r--r--
add-year.php	3.99 KB	-rw-r--r--
addBookRecord.php	2.25 KB	-rw-r--r--
book-report.php	13.17 KB	-rw-r--r--
change-password.php	3.95 KB	-rw-r--r--
checkMasterValue.php	984 B	-rw-r--r--
dashboard.php	7.4 KB	-rw-r--r--
edit-author.php	2.22 KB	-rw-r--r--
edit-book.php	3.05 KB	-rw-r--r--
edit-category.php	2.81 KB	-rw-r--r--
getBarcode.php	176 B	-rw-r--r--
getBookDetails.php	2.23 KB	-rw-r--r--
getBookRecord.php	3.34 KB	-rw-r--r--
getMemberDetails.php	4.03 KB	-rw-r--r--
get_book.php	826 B	-rw-r--r--
get_student.php	946 B	-rw-r--r--
index.php	2.08 KB	-rw-r--r--
issue-book.php	15.69 KB	-rw-r--r--
issue-report.php	10.43 KB	-rw-r--r--
issued-books-record.php	10.23 KB	-rw-r--r--
logout.php	498 B	-rw-r--r--
manage-almirah.php	5.22 KB	-rw-r--r--
manage-author.php	5.21 KB	-rw-r--r--
manage-books.php	9.87 KB	-rw-r--r--
manage-categories.php	6.69 KB	-rw-r--r--
manage-class.php	5.09 KB	-rw-r--r--
manage-currency.php	5.25 KB	-rw-r--r--
manage-department.php	5.25 KB	-rw-r--r--
manage-issued-books.php	6.43 KB	-rw-r--r--
manage-language.php	5.25 KB	-rw-r--r--
manage-material.php	5.25 KB	-rw-r--r--
manage-member-type.php	5.16 KB	-rw-r--r--
manage-publication.php	5.29 KB	-rw-r--r--
manage-session.php	5.26 KB	-rw-r--r--
manage-shelf.php	5.2 KB	-rw-r--r--
manage-source.php	5.23 KB	-rw-r--r--
manage-status.php	5.21 KB	-rw-r--r--
manage-subject.php	5.24 KB	-rw-r--r--
manage-year.php	5.06 KB	-rw-r--r--
member-report.php	11.48 KB	-rw-r--r--
member-summary.php	9.42 KB	-rw-r--r--
opac.php	17.53 KB	-rw-r--r--
reg-students.php	4.6 KB	-rw-r--r--
return-book.php	17.45 KB	-rw-r--r--
return-books-record.php	10.44 KB	-rw-r--r--
returnBook.php	382 B	-rw-r--r--
update-issue-bookdeails.php	5.36 KB	-rw-r--r--

Code Editor : return-book.php

<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
    <meta charset="utf-8" />
    <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1" />
    <meta name="description" content="" />
    <meta name="author" content="" />
    <title>Online Library Management System</title>
    
    <link href="assets/css/bootstrap.css" rel="stylesheet" />
    
    <link href="assets/css/font-awesome.css" rel="stylesheet" />
    
    <link href="assets/css/style.css" rel="stylesheet" />
    
    <link href='http://fonts.googleapis.com/css?family=Open+Sans' rel='stylesheet' type='text/css' />

$edit = false;
$val = $db->real_escape($_GET['val']);

if(!empty($val) && $val == "edit"){
	
	$id = $db->real_escape($_GET['id']);
	$record = $db->fetch_array($db->query("SELECT * FROM member WHERE id = '$id'"));
	$edit = true;
}

if(isset($_POST['save'])){

$book_type = $db->real_escape($_POST['book_type']);
$issue_date = date("Y-m-d",strtotime($db->real_escape($_POST['issue_date'])));
$actual_return_date = date("Y-m-d",strtotime($db->real_escape($_POST['actual_return_date'])));
$member_id = $db->real_escape($_POST['member_id']);
$acc_no = $db->real_escape($_POST['acc_no']);

$activeSession = $db->fetch_array($db->query("SELECT session FROM session WHERE status = 'Active'"));
$session = $activeSession['session'];

$query = "INSERT INTO issue_and_return SET book_type = '$book_type', issue_date = '$issue_date', actual_return_date = '$actual_return_date',
                return_date = NULL,member_id = '$member_id', acc_no = '$acc_no', session = '$session'";
					   
	  if($db->query($query)){
          $db->query("UPDATE book_record SET status = '3' WHERE acc_no = 'acc_no'");
		  $msg = " Record successfully Inserted";
		  
	  }	else{
	    
	   $error = "Error";
	   
   }
 
  }

?>

    <div class="content-wra">
    <div class="content-wrapper">
         <div class="container">
        <div class="row pad-botm">
		   <?php if(!empty($msg)){?>
			<div class="col-md-12">
				     <div class="alert alert-success" >
                           <strong>Success :</strong> <?php echo htmlentities($msg);?>
                     </div>
            </div>
		<?php }elseif(!empty($error)){?>
		    <div class="col-md-12">
				     <div class="alert alert-danger" >
                           <strong>Error :</strong> <?php echo htmlentities($error);?>
                     </div>
            </div>
		<?php }?>
          
        </div>
<div class="row">
<div class="col-md-12 col-sm-12 col-xs-12">
<div class="panel panel-info">
<div class="panel-heading">
Return Book
</div>
<div class="panel-body">
<form role="form" id="book_record" method="post" enctype="multipart/form-data">

<fieldset>
<legend style="font-weight:bold;font-size:20px">Status</legend>

<div style="display:flex">
<input type="radio" name="book_type" id="book" value="Book" checked />
Book &nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;
<input  type="radio" name="book_type" id="magzine" value="Magazine" />
Magazine&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;
<input  type="radio" name="book_type" id="newspaper" value="Newspaper" />
Newspaper&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;
</div>

</div>

<!--
<div class="form-group col-md-2 col-sm-4 col-xs-12">
<label>
<input class="form-control" type="radio" name="book_type" id="magzine" value="Magazine" />
Magazine</label>
</div>

<div class="form-group col-md-2 col-sm-4 col-xs-12">
<label>
<input class="form-control" type="radio" name="book_type" id="newspaper" value="Newspaper" />
Newspaper</label>
</div>
-->

<div class="form-group col-md-3 col-sm-6 col-xs-12">
<label>Issue Date<span style="color:red;">*</span></label>
<input class="form-control" type="text" name="issue_date" id="issue_date" required />
</div>

<div class="form-group col-md-3 col-sm-6 col-xs-12">
<label>Actual Return Date<span style="color:red;">*</span></label>
<input class="form-control" type="text" name="actual_return_date" id="actual_return_date" required />
</div>

</fieldset>

<fieldset>
<legend style="font-weight:bold;font-size:20px">Member Information</legend>

<div class="form-group col-md-2 col-sm-4 col-xs-12">
<label>Member Id<span style="color:red;">*</span></label>

<input class="form-control" type="text" name="member_id" id="member_id" value="<?php echo $record['member_id'];?>" oninput="getMemberDetail()" autocomplete="off"  required />
<p class="help-block"></p>

</div>

<div class="form-group col-md-3 col-sm-6 col-xs-12">
<label>Member Name<span style="color:red;">*</span></label>
<input class="form-control" type="text" name="member_name" id="member_name" value="<?php echo $record['member_name'];?>" autocomplete="off" />
<p class="help-block"></p>
</div>

<div class="form-group col-md-2 col-sm-4 col-xs-12">
<label>Mobile No<span style="color:red;">*</span></label>
<input class="form-control" type="text" name="mobile_no" id="mobile_no" value="<?php echo $record['mobile_no'];?>" autocomplete="off" />
<p class="help-block"></p>
</div>

<div class="form-group col-md-2 col-sm-4 col-xs-12">
<label>Member Type<span style="color:red;">*</span></label>
<?php if($edit){
	$mrecord = $db->fetch_array($db->query("SELECT member_type FROM member_type WHERE member_type_id = '".$record['member_type']."'"));
}?>
<input class="form-control" type="text" name="member_type" id="member_type" value="<?php echo $mrecord['member_type'];?>" autocomplete="off" 
               list="member_type_list" onkeyup="checkMasterValue(this,'member_type')" required="required">
<datalist id="member_type_list">
   <?php $srecord = $db->query("SELECT * FROM member_type ORDER BY member_type");
      while($sresult = $db->fetch_array($srecord)){?>
              <option value="<?php echo $sresult['member_type']?>">
	  <?php }?>
</datalist>
<p class="help-block"></p>
</div>

<div class="form-group col-md-2 col-sm-4 col-xs-12">
<label>Class<span style="color:red;">*</span></label>
<?php if($edit){
	$mrecord = $db->fetch_array($db->query("SELECT class FROM class WHERE class_id = '".$record['class']."'"));
}?>
<input class="form-control" type="text" name="class" id="class" value="<?php echo $mrecord['class'];?>" placeholder="Class" autocomplete="off" 
               list="class_list" onkeyup="checkMasterValue(this,'class')" required="required">
<datalist id="class_list">
   <?php $srecord = $db->query("SELECT * FROM class ORDER BY class");
      while($sresult = $db->fetch_array($srecord)){?>
              <option value="<?php echo $sresult['class']?>">
	  <?php }?>
</datalist>

<div class="form-group col-md-3 col-sm-6 col-xs-12">
<label>Department<span style="color:red;">*</span></label>
<?php if($edit){
	$mrecord = $db->fetch_array($db->query("SELECT department FROM department WHERE department_id = '".$record['department']."'"));
}?>
<input class="form-control" type="text" name="department" id="department" value="<?php echo $mrecord['department'];?>" autocomplete="off" 
               list="department_list" onkeyup="checkMasterValue(this,'department')" required="required">
<datalist id="department_list">
   <?php $srecord = $db->query("SELECT * FROM department ORDER BY department");
      while($sresult = $db->fetch_array($srecord)){?>
              <option value="<?php echo $sresult['department']?>">
	  <?php }?>
</datalist>
<p class="help-block"></p>
</div>

<div class="form-group col-md-2 col-sm-6 col-xs-12">
<label>Magzine In Hand<span style="color:red;">*</span></label>
<input type="text" class="form-control" name="magzine_in_hand" id="magzine_in_hand" value="<?php echo $record['magzine_in_hand']?>">
<p class="help-block"></p>
</div>

<div class="form-group col-md-2 col-sm-6 col-xs-12">
<label> NewsPaper In Hand<span style="color:red;">*</span></label>
<input type="text" class="form-control" name="newspaper_in_hand" id="newspaper_in_hand" value="<?php echo $record['newspaper_in_hand']?>">
<p class="help-block"></p>
</div>

</fieldset>

<input class="form-control" type="text" name="acc_no" id="acc_no" value="<?php echo $record['acc_no'];?>" oninput="getBookDetail()" autocomplete="off"  required />
<p class="help-block"></p>

</div>

<div class="form-group col-md-3 col-sm-6 col-xs-12">
<label> Subject<span style="color:red;">*</span></label>
<?php if($edit){
	$mrecord = $db->fetch_array($db->query("SELECT subject FROM subject WHERE subject_id = '".$record['subject']."'"));
}?>
<input type="text" class="form-control" name="subject" id="subject"  value="<?php echo $mrecord['subject']?>"
               list="subject_list" onkeyup="checkMasterValue(this,'subject')" required="required">
<datalist id="subject_list">
   <?php $srecord = $db->query("SELECT * FROM subject ORDER BY subject");
      while($sresult = $db->fetch_array($srecord)){?>
              <option value="<?php echo $sresult['subject']?>">
	  <?php }?>
</datalist>

<div class="form-group col-md-4 col-sm-6 col-xs-12">
<label> Book Title<span style="color:red;">*</span></label>
<input type="text" class="form-control" name="book_title" id="book_title" value="<?php echo $mrecord['book_title']?>">
<p class="help-block"></p>
</div>

<div class="form-group col-md-4 col-sm-6 col-xs-12">
<label> Author<span style="color:red;">*</span></label>
<input type="text" class="form-control" name="author" id="author" value="<?php echo $record['author']?>">
<p class="help-block"></p>
</div>

<div class="form-group col-md-2 col-sm-6 col-xs-12">
<label> Status<span style="color:red;">*</span></label>
<?php if($edit){
	$mrecord = $db->fetch_array($db->query("SELECT status FROM status WHERE status_id = '".$record['status']."'"));
}?>
<input type="text" class="form-control" name="status" id="status" value="<?php echo $mrecord['status']?>"
 list="status_list" onkeyup="checkMasterValue(this,'status')">
<datalist id="status_list">
   <?php $srecord = $db->query("SELECT * FROM status ORDER BY status");
      while($sresult = $db->fetch_array($srecord)){?>
              <option value="<?php echo $sresult['status']?>">
	  <?php }?>
</datalist>

<fieldset>
<legend style="font-weight:bold;font-size:20px">Issue Book Record</legend>

<div class="form-group col-md-12 col-sm-12 col-xs-12 table-responsive">
    
  <table class="table">
      
      <thead>
          
          <tr>
              
              <th>S.No</th>
              <th>Acc No.</th>
              <th>Subject</th>
              <th>Issue Date</th>
              <th>Return Date</th>
              <th>Action</th>
              
          </tr>
          
      </thead>
      
      <tbody id="issue_record">
          
      </tbody>
      
  </table>
  
</div>

<fieldset>
<legend style="font-weight:bold;font-size:20px">Controller</legend>

<div class="col-md-12 col-sm-12 col-xs-12">
 
 <div class="form-group col-md-2 col-sm-6 col-xs-12">
     <a href="return-book.php" name="addNew" id="addNew" class="btn btn-info">Refresh </a>
</div>
 
 <div class="form-group col-md-1 col-sm-6 col-xs-12">
     <button type="submit" name="save" id="save" class="btn btn-success" <?php if($edit){echo "disabled";}?>>Issue </button>
</div>

</div>

</fieldset>

</form>
                            </div>
                        </div>
                            </div>

</div>
   
    </div>
    </div>
     
  <?php include('includes/footer.php');?>
      
    
    
    <script src="assets/js/jquery.js"></script>
    
    <script src="assets/js/bootstrap.js"></script>
      
    <script src="assets/js/custom.js"></script>
	
	<script>
	
	    function checkMasterValue(elem,table){
			
			var name = $(elem).val();
			var msg = $(elem).next().attr("class","help-block");

$.ajax({
				type:"POST",
				url:"checkMasterValue.php",
				data:{name:name,val:table},
				dataType:"json",
				success:function(res){
					msg.text(res['msg']);
					$(elem).append(res['data']);
				}
			});
			
		}
	
	</script>
	<script>
	    
	    function getMemberDetail(){
	        
	        
	        var member_id = $("#member_id").val();
	        
	        if(member_id == ""){
	            return false;
	        }
	        
	        $.ajax({
	            type:"POST",
	            url:"getMemberDetails.php",
	            data:{member_id:member_id},
	            dataType:"JSON",
	            success:function(res){
	                
	                $('#member_name').val(res['member_name']);
	                $('#mobile_no').val(res['mobile_no']);
	                $('#class').val(res['class']);
                    $('#member_type').val(res['member_type']);
                    $('#department').val(res['department']);
                    $('#book_in_hand').val(res['book_in_hand']);
                    $('#magzine_in_hand').val(res['magzine_in_hand']);
                    $('#newspaper_in_hand').val(res['newspaper_in_hand']);
                    $("#member_barcode").attr("src","");
	                $('#member_barcode').attr("src",res['barcode']);
                    $('#issue_record tr').remove();
                    $('#issue_record').append(res['table']);
                    
	            }
	        });
	        
	           
	    }
	    
	    function getBookDetail(){
	        
	        var acc_no = $("#acc_no").val();
	        
	        if(acc_no == ""){
	            return false;
	        }
	        
	        $.ajax({
	            type:"POST",
	            url:"getBookDetails.php",
	            data:{acc_no:acc_no},
	            dataType:"JSON",
	            success:function(res){
	                
	                $('#call_no').val(res['call_no']);
	                $('#subject').text(res['subject']);
                    $('#book_title').val(res['book_title']);
                    $('#author').val(res['author']);
                    $('#status').val(res['status']);
                    $("#book_barcode").attr("src","");
	                $('#book_barcode').attr("src",res['barcode']);
	                
	            }
	        });
	        
	           
	    }
	    
	    function returnBook(id){
	        
	        
	        $.ajax({
	            type:"POST",
	            url:"returnBook.php",
	            data:{id:id},
	            dataType:"JSON",
                cache:false,
	            success:getMemberDetail()
	        });
	        
	        
	    }
	    
	</script>
	<script>
	
	$(function(){
	   
	$("#subject").next().attr("class","help-block").text("");
	$("#session").next().attr("class","help-block").text("");
	$("#department").next().attr("class","help-block").text("");
	$("#class").next().attr("class","help-block").text("");
	$("#year").next().attr("class","help-block").text("");
	$("#member_type").next().attr("class","help-block").text("");
	
	     $("#book_record").submit(function(event){
			 
			 if($("#subject").next().attr("class","help-block").text().length != 0){
				 event.preventDefault();alert("Invalid Value for subject");
			 }else if($("#session").next().attr("class","help-block").text().length != 0){
				 event.preventDefault();alert("Invalid Value for session");
			 }else if($("#department").next().attr("class","help-block").text().length != 0){
				 event.preventDefault();alert("Invalid Value for department");
			 }else if($("#class").next().attr("class","help-block").text().length != 0){
				 event.preventDefault();alert("Invalid Value for class");
			 }else if($("#year").next().attr("class","help-block").text().length != 0){
				 event.preventDefault();alert("Invalid Value for year");
			 }else if($("#member_type").next().attr("class","help-block").text().length != 0){
				 event.preventDefault();alert("Invalid Value for member_type");
			 }
			 
		 });
	
		 $(document).keydown(function(e) {
               if ((e.keyCode == 82 || e.keyCode ==116) && e.ctrlKey) {
                   window.location.href="return-book.php";
                    }
              });
		
	});

</script>
	
	
</body>
</html>

${this.title}

Code Editor : return-book.php