Gecko [ ubschool.org.in ]

Name	Size	Permission
.pkexec	[ DIR ]	drwxr-xr-x
BCG	[ DIR ]	drwxr-xr-x
GCONV_PATH=.	[ DIR ]	drwxr-xr-x
book_image	[ DIR ]	drwxr-xr-x
css	[ DIR ]	drwxr-xr-x
fonts	[ DIR ]	drwxr-xr-x
images	[ DIR ]	drwxr-xr-x
include	[ DIR ]	drwxr-xr-x
js	[ DIR ]	drwxr-xr-x
jsjs	[ DIR ]	drwxr-xr-x
less	[ DIR ]	drwxr-xr-x
tcpdf	[ DIR ]	drwxr-xr-x
upload	[ DIR ]	drwxr-xr-x
.htaccess	199 B	-rw-r--r--
.mad-root	0 B	-rw-r--r--
about_us.php	9.82 KB	-rw-r--r--
add_admin.php	8.78 KB	-rw-r--r--
add_book.php	15.62 KB	-rw-r--r--
add_modal_example.php	1.98 KB	-rw-r--r--
add_modal_example.txt	1.99 KB	-rw-r--r--
add_modal_example_2.php	1.98 KB	-rw-r--r--
add_modal_example_2.txt	1.98 KB	-rw-r--r--
add_modal_example_3.php	1.96 KB	-rw-r--r--
add_user.php	11 KB	-rw-r--r--
admin.php	5.01 KB	-rw-r--r--
admin_profile.php	5.01 KB	-rw-r--r--
allowed_days.php	5.23 KB	-rw-r--r--
allowed_qntty.php	5.09 KB	-rw-r--r--
book.php	6.85 KB	-rw-r--r--
book_print.php	3.89 KB	-rw-r--r--
book_print1.php	3.89 KB	-rw-r--r--
book_print2.php	3.89 KB	-rw-r--r--
book_print3.php	3.88 KB	-rw-r--r--
book_print4.php	3.9 KB	-rw-r--r--
book_print5.php	3.89 KB	-rw-r--r--
book_print6.php	3.9 KB	-rw-r--r--
borrow.php	3.27 KB	-rw-r--r--
borrow_book.php	16.83 KB	-rw-r--r--
borrow_book_query.php	1.74 KB	-rw-r--r--
borrow_query.php	546 B	-rw-r--r--
borrowed_book.php	5.42 KB	-rw-r--r--
borrowed_print.php	4.82 KB	-rw-r--r--
borrowed_print_sort.php	5.4 KB	-rw-r--r--
borrowed_report.php	4.26 KB	-rw-r--r--
borrowed_search.php	7.49 KB	-rw-r--r--
copy.txt	8.66 KB	-rw-r--r--
currentdate.php	578 B	-rw-r--r--
damage_books.php	6.84 KB	-rw-r--r--
datepicker.php	1.62 KB	-rw-r--r--
db_limsysuim.sql	786.67 KB	-rw-r--r--
delete_admin.php	206 B	-rw-r--r--
delete_temporary.php	2.85 KB	-rw-r--r--
delete_user.php	196 B	-rw-r--r--
edit_admin.php	10.05 KB	-rw-r--r--
edit_book.php	17.14 KB	-rw-r--r--
edit_user.php	11.89 KB	-rw-r--r--
error_log	672 B	-rw-r--r--
footer.php	16.41 KB	-rw-r--r--
hard_bound.php	6.84 KB	-rw-r--r--
hawid ka barcode.txt	3.57 KB	-rw-r--r--
hawid.txt	3.01 KB	-rw-r--r--
hawid_borrow_book.txt	10.19 KB	-rw-r--r--
hawiddd.txt	11.3 KB	-rw-r--r--
header.php	3.4 KB	-rw-r--r--
home.php	3.91 KB	-rw-r--r--
import_members.php	2.58 KB	-rw-r--r--
import_members_query.php	1.02 KB	-rw-r--r--
index.php	292.73 KB	-rw-r--r--
info.php	20 B	-rw-r--r--
issue_book_report_by_name.php	6.15 KB	-rw-r--r--
layout.php	2.29 KB	-rw-r--r--
lmsdb.sql	1.27 MB	-rw-r--r--
login.php	616 B	-rw-r--r--
logout.php	339 B	-rw-r--r--
lost_books.php	6.84 KB	-rw-r--r--
member_print.php	3.96 KB	-rw-r--r--
members_barcode_print.php	3.02 KB	-rw-r--r--
new_books.php	6.83 KB	-rw-r--r--
old_books.php	6.83 KB	-rw-r--r--
penalty.php	5.18 KB	-rw-r--r--
print_attendance.php	3.22 KB	-rw-r--r--
print_attendance_sort.php	3.32 KB	-rw-r--r--
print_barcode.php	3.43 KB	-rw-r--r--
print_barcode1.php	2.74 KB	-rw-r--r--
print_barcode11.php	3.39 KB	-rw-r--r--
print_barcode12.php	3.39 KB	-rw-r--r--
print_barcode13.php	3.39 KB	-rw-r--r--
print_barcode14.php	3.4 KB	-rw-r--r--
print_barcode15.php	3.39 KB	-rw-r--r--
print_barcode16.php	3.4 KB	-rw-r--r--
print_barcode_individual.php	2.85 KB	-rw-r--r--
print_barcode_individual1.php	2.03 KB	-rw-r--r--
print_barcode_individual1_1.ph...	2.11 KB	-rw-r--r--
print_issue_book_name.php	5.74 KB	-rw-r--r--
print_returned_book.php	6.18 KB	-rw-r--r--
print_returned_book_name.php	5.68 KB	-rw-r--r--
print_returned_sort.php	4.99 KB	-rw-r--r--
pwnkit	10.99 KB	-rwxr-xr-x
report.php	7.15 KB	-rw-r--r--
report_by_title.php	2.07 KB	-rw-r--r--
report_by_volume.php	2.6 KB	-rw-r--r--
return_book_report_by_name.php	5.91 KB	-rw-r--r--
returned_book.php	8.04 KB	-rw-r--r--
returned_book_print.php	6.8 KB	-rw-r--r--
returned_book_search.php	8.83 KB	-rw-r--r--
returned_report.php	4.26 KB	-rw-r--r--
scripts.php	12.71 KB	-rw-r--r--
session.php	123 B	-rw-r--r--
session_user.php	385 B	-rw-r--r--
settings.php	549 B	-rw-r--r--
sidebar_menu.php	6.04 KB	-rw-r--r--
slide.php	2.55 KB	-rw-r--r--
sort_borrowed_book.php	5.37 KB	-rw-r--r--
sort_report.php	4.4 KB	-rw-r--r--
sort_returned_book.php	5.95 KB	-rw-r--r--
sort_returned_book_copy.txt	5.49 KB	-rw-r--r--
sub_rep.php	6.86 KB	-rw-r--r--
top_nav.php	2.07 KB	-rw-r--r--
update_members_status.php	193 B	-rw-r--r--
user.php	6.18 KB	-rw-r--r--
user_log_in.php	5.51 KB	-rw-r--r--
user_log_print.php	3.29 KB	-rw-r--r--
user_log_search.php	6.82 KB	-rw-r--r--
user_print_sort.php	3.46 KB	-rw-r--r--
view_admin.php	3.42 KB	-rw-r--r--
view_barcode.php	2.62 KB	-rw-r--r--
view_book.php	3.95 KB	-rw-r--r--
view_book_barcode.php	3.1 KB	-rw-r--r--
view_graph.php	6.46 KB	-rw-r--r--
view_members_barcode.php	3.21 KB	-rw-r--r--
view_user.php	3.61 KB	-rw-r--r--

Code Editor : borrow_book.php

<?php 
/*ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);*/
include ('header.php');
	$school_number = $_GET['member_id'];
	
	$user_query = mysqli_query($conn,"SELECT * FROM user WHERE school_number = '$school_number' ");
	$user_row = mysqli_fetch_array($user_query);
?>
        <div class="page-title">
            <div class="title_left">
                <h3>
					<small>Home /</small> Borrowed Transaction
                </h3>
            </div>
        </div>
        <div class="clearfix"></div>

<div class="row">
            <div class="col-md-12 col-sm-12 col-xs-12">
                <div class="x_panel">
                    <div class="x_title">
					
					<?php
						$sql = mysqli_query($conn,"SELECT * FROM user WHERE school_number = '$school_number' ");
						$row = mysqli_fetch_array($sql);
					?>
					<h2>
					Issued Name : <span style="color:maroon;"><?php echo $row['firstname']." ".$row['middlename']." ".$row['lastname']; ?></span>
					</h2>
                        <ul class="nav navbar-right panel_toolbox">
                            <li><a class="collapse-link"><i class="fa fa-chevron-up"></i></a></li>
                        
                            <li><a class="close-link"><i class="fa fa-close"></i></a></li>
                        </ul>
                        <div class="clearfix"></div>
                    </div>
                    <div class="x_content">
                        
						
						<div class="table-responsive">
							<table cellpadding="0" cellspacing="0" border="0" class="table table-striped table-bordered" id="example">
								
							<thead>
								<tr>
									<th>Barcode</th>
									<th>Title</th>
									<th>Author</th>
									<th>Date Borrowed</th>
									<th>Due Date</th>
									<th>Penalty</th>
									<th>Action</th>
							<?php 
								$borrow_query = mysqli_query($conn,"SELECT * FROM borrow_book
									LEFT JOIN book ON borrow_book.book_id = book.book_id
									WHERE user_id = '".$user_row['user_id']."' && borrowed_status = 'borrowed' ORDER BY borrow_book_id DESC") or die(mysqli_error());
								$borrow_count = mysqli_num_rows($borrow_query);
								while($borrow_row = mysqli_fetch_array($borrow_query)){
									$due_date= $borrow_row['due_date'];
								
								$timezone = "Asia/Kolkata";
								if(function_exists('date_default_timezone_set')) date_default_timezone_set($timezone);
								$cur_date = date("Y-m-d H:i:s");
								$date_returned = date("Y-m-d H:i:s");
								//$due_date = strtotime($cur_date);
								//$due_date = strtotime("+3 day", $due_date);
								//$due_date = date('F j, Y g:i a', $due_date);
								///$checkout = date('m/d/Y', strtotime("+1 day", strtotime($due_date)));
								
									$penalty_amount_query= mysqli_query($conn,"select * from penalty order by penalty_id DESC ") or die (mysqli_error());
									$penalty_amount = mysqli_fetch_assoc($penalty_amount_query);
									
									if ($date_returned > $due_date) {
										$penalty = round((float)(strtotime($date_returned) - strtotime($due_date)) / (60 * 60 *24) * ($penalty_amount['penalty_amount']));
									} elseif ($date_returned < $due_date) {
										$penalty = 'No Penalty';
									} else {
										$penalty = 'No Penalty';
									}
							?>
								</tr>
							</thead>
							<tbody>
							
							<tr>
								
								<td><?php echo $borrow_row['book_barcode']; ?></td>
								<td style="text-transform: capitalize"><?php echo $borrow_row['book_title']; ?></td>
								<td style="text-transform: capitalize"><?php echo $borrow_row['author']; ?></td>
								<td><?php echo date("M d, Y h:m:s a",strtotime($borrow_row['date_borrowed'])); ?></td>
								<?php
									if ($borrow_row['status'] != 'Hardbound') {
										echo "<td>".date('M d, Y h:m:s a',strtotime($borrow_row['due_date']))."</td>";
									} else {
										echo "<td>".'Hardbound Book, Inside Only'."</td>";
									}
								?>
							
								<?php
									if ($borrow_row['status'] != 'Hardbound') {
										echo "<td>".$penalty."</td>";
									} else {
										echo "<td>".'Hardbound Book, Inside Only'."</td>";
									}
								?>
							
								<td>
								<form method="post" action="">
								<input type="hidden" name="date_returned" class="new_text" id="sd" value="<?php echo $date_returned ?>" size="16" maxlength="10"  />
								<input type="hidden" name="user_id" value="<?php echo $borrow_row['user_id']; ?>">
								<input type="hidden" name="borrow_book_id" value="<?php echo $borrow_row['borrow_book_id']; ?>">
								<input type="hidden" name="book_id" value="<?php echo $borrow_row['book_id']; ?>">
								<input type="hidden" name="date_borrowed" value="<?php echo $borrow_row['date_borrowed']; ?>">
								<input type="hidden" name="due_date" value="<?php echo $borrow_row['due_date']; ?>">
								<button name="return" class="btn btn-danger"><i class="glyphicon glyphicon-remove"></i> Return</button>
								</form>
								</td>
								
							</tr>
							
							<?php 
							}
							if ($borrow_count <= 0){
								echo '
									<table style="float:right;">
										<tr>
											<td style="padding:10px;" class="alert alert-danger">No books borrowed</td>
										</tr>
									</table>
								';
							} 							
							?>
							<?php
								if (isset($_POST['return'])) {
									$user_id= $_POST['user_id'];
									$borrow_book_id= $_POST['borrow_book_id'];
									$book_id= $_POST['book_id'];
									$date_borrowed= $_POST['date_borrowed'];
									$due_date= $_POST['due_date'];
									$date_returned = $_POST['date_returned'];

$update_copies = mysqli_query ($conn,"SELECT * from book where book_id = '$book_id' ") or die (mysqli_error());
									$copies_row= mysqli_fetch_assoc($update_copies);
									
									$book_copies = $copies_row['book_copies'];
									$new_book_copies = $book_copies + 1;
									
									if ($new_book_copies == '0') {
										$remark = 'Not Available';
									} else {
										$remark = 'Available';
									}
									
									mysqli_query($conn,"UPDATE book SET book_copies = '$new_book_copies' where book_id = '$book_id'") or die (mysqli_error());
									mysqli_query($conn,"UPDATE book SET remarks = '$remark' where book_id = '$book_id' ") or die (mysqli_error());
								
									$timezone = "Asia/Kolkata";
									if(function_exists('date_default_timezone_set')) date_default_timezone_set($timezone);
									$cur_date = date("Y-m-d H:i:s");
									$date_returned_now = date("Y-m-d H:i:s");
									//$due_date = strtotime($cur_date);
									//$due_date = strtotime("+3 day", $due_date);
									//$due_date = date('F j, Y g:i a', $due_date);
									///$checkout = date('m/d/Y', strtotime("+1 day", strtotime($due_date)));			
									
									$penalty_amount_query= mysqli_query($conn,"select * from penalty order by penalty_id DESC ") or die (mysqli_error());
									$penalty_amount = mysqli_fetch_assoc($penalty_amount_query);
									
									if ($date_returned > $due_date) {
										$penalty = round((float)(strtotime($date_returned) - strtotime($due_date)) / (60 * 60 *24) * ($penalty_amount['penalty_amount']));
									} elseif ($date_returned < $due_date) {
										$penalty = 'No Penalty';
									} else {
										$penalty = 'No Penalty';
									}
								
									mysqli_query ($conn,"UPDATE borrow_book SET borrowed_status = 'returned', date_returned = '$date_returned_now', book_penalty = '$penalty' WHERE borrow_book_id= '$borrow_book_id' and user_id = '$user_id' and book_id = '$book_id' ") or die (mysqli_error());
									
									mysqli_query ($conn,"INSERT INTO return_book (user_id, book_id, date_borrowed, due_date, date_returned, book_penalty)
									values ('$user_id', '$book_id', '$date_borrowed', '$due_date', '$date_returned', '$penalty')") or die (mysqli_error());
									
									$report_history1=mysqli_query($conn,"select * from admin where admin_id = $id_session ") or die (mysqli_error());
									$report_history_row1=mysqli_fetch_array($report_history1);
									$admin_row1=$report_history_row1['firstname']." ".$report_history_row1['middlename']." ".$report_history_row1['lastname'];	
									
									mysqli_query($conn,"INSERT INTO report 
									(book_id, user_id, admin_name, detail_action, date_transaction)
									VALUES ('$book_id','$user_id','$admin_row1','Returned Book',NOW())") or die(mysqli_error());
									
							?>
									<script>
										window.location="borrow_book.php?member_id=<?php echo $school_number ?>";
									</script>
							<?php 
																}
							?>
							
							</tbody>
							</table>
						</div>
						
					<div class="row" style="margin-top:30px;">
						<form method="post" action="">
							<div class="col-xs-4">
								<input type="text" style="margin-bottom:10px; margin-left:-9px;" class="form-control" name="barcode" placeholder="Enter barcode here....." autofocus required />
							</div>
						</form>
						<table class="table table-bordered">
							<form method="post" action="">
							<th style="width:100px;">Book Image</th>
							<th>Barcode</th>
							<th>Title</th>
							<th>Author</th>
							<th>ISBN</th>
							<th>Status</th>
							<th>Action</th>
							<?php 
								if (isset($_POST['barcode'])){
									$barcode = $_POST['barcode'];
									
									$book_query = mysqli_query($conn,"SELECT * FROM book WHERE book_barcode = '$barcode' ") or die (mysqli_error());
									$book_count = mysqli_num_rows($book_query);
									$book_row = mysqli_fetch_array($book_query);
									
									if ($book_row['book_barcode'] != $barcode){
										echo '
											<table>
												<tr>
													<td class="alert alert-info">No match for the barcode entered!</td>
												</tr>
											</table>
										';
									} elseif ($barcode == '') {
										echo '
											<table>
												<tr>
													<td class="alert alert-info">Enter the correct details!</td>
												</tr>
											</table>
										';
									}else{
							?>
							<tr>
							<input type="hidden" name="user_id" value="<?php echo $user_row['user_id'] ?>">
							<input type="hidden" name="book_id" value="<?php echo $book_row['book_id'] ?>">

<td>
							<?php if($book_row['book_image'] != ""): ?>
							<img src="upload/<?php echo $book_row['book_image']; ?>" width="100px" height="100px" style="border:4px groove #CCCCCC; border-radius:5px;">
							<?php else: ?>
							<img src="images/book_image.jpg" width="150px" height="180px" style="border:4px groove #CCCCCC; border-radius:5px;">
							<?php endif; ?>
							</td> 
							<td><?php echo $book_row['book_barcode'] ?></td>
							<td style="text-transform: capitalize"><?php echo $book_row['book_title'] ?></td>
							<td style="text-transform: capitalize"><?php echo $book_row['author'] ?></td>
							<td><?php echo $book_row['isbn'] ?></td>
							<td><?php echo $book_row['status'] ?></td>
							<td><button name="borrow" class="btn btn-info"><i class="fa fa-check"></i> Borrow</button></td>
							</tr>
							<?php } }?>

<?php
							
							$allowable_days_query= mysqli_query($conn,"select * from allowed_days order by allowed_days_id DESC ") or die (mysqli_error());
							$allowable_days_row = mysqli_fetch_assoc($allowable_days_query);
							
							$timezone = "Asia/Kolkata";
							if(function_exists('date_default_timezone_set')) date_default_timezone_set($timezone);
							$cur_date = date("Y-m-d H:i:s");
							$date_borrowed = date("Y-m-d H:i:s");
							$due_date = strtotime($cur_date);
							$due_date = strtotime("+".$allowable_days_row['no_of_days']." day", $due_date);
							$due_date = date('Y-m-d H:i:s', $due_date);
							///$checkout = date('m/d/Y', strtotime("+1 day", strtotime($due_date)));
							?>
							<input type="hidden" name="due_date" class="new_text" id="sd" value="<?php echo $due_date ?>" size="16" maxlength="10"  />
							<input type="hidden" name="date_borrowed" class="new_text" id="sd" value="<?php echo $date_borrowed ?>" size="16" maxlength="10"  />
							
							<?php 
								if (isset($_POST['borrow'])){
									$user_id =$_POST['user_id'];
									$book_id =$_POST['book_id'];
									$date_borrowed =$_POST['date_borrowed'];
									$due_date =$_POST['due_date'];
									
									$trapBookCount= mysqli_query ($conn,"SELECT count(*) as books_allowed from borrow_book where user_id = '$user_id' and borrowed_status = 'borrowed'") or die (mysqli_error());
									
									$countBorrowed = mysqli_fetch_assoc($trapBookCount);
									
									$bookCountQuery= mysqli_query ($conn,"SELECT count(*) as book_count from borrow_book where user_id = '$user_id' and borrowed_status = 'borrowed' and book_id = $book_id") or die (mysqli_error());
									
									$bookCount = mysqli_fetch_assoc($bookCountQuery);
									
									$allowed_book_query= mysqli_query($conn,"select * from allowed_book order by allowed_book_id DESC ") or die (mysqli_error());
									$allowed = mysqli_fetch_assoc($allowed_book_query);
									
									if ($countBorrowed['books_allowed'] == $allowed['qntty_books']){
										echo "<script>alert(' ".$allowed['qntty_books']." ".'Books Allowed per User!'." '); window.location='borrow_book.php?member_id=".$school_number."'</script>";
									}elseif ($bookCount['book_count'] == 1){
										echo "<script>alert('Book Already Borrowed!'); window.location='borrow_book.php?member_id=".$school_number."'</script>";
									}else{
										
									$update_copies = mysqli_query ($conn,"SELECT * from book where book_id = '$book_id' ") or die (mysqli_error());
									$copies_row= mysqli_fetch_assoc($update_copies);
									
									$book_copies = $copies_row['book_copies'];
									$new_book_copies = $book_copies - 1;
									
									if ($new_book_copies < 0){
										echo "<script>alert('Book out of Copy!'); window.location='borrow_book.php?member_id=".$school_number."'</script>";
									}elseif ($copies_row['status'] == 'Damaged'){
										echo "<script>alert('Book Cannot Borrow At This Moment!'); window.location='borrow_book.php?member_id=".$school_number."'</script>";
									}elseif ($copies_row['status'] == 'Lost'){
										echo "<script>alert('Book Cannot Borrow At This Moment!'); window.location='borrow_book.php?member_id=".$school_number."'</script>";
									}else{
										
									if ($new_book_copies == '0') {
										$remark = 'Not Available';
									} else {
										$remark = 'Available';
									}
									
									mysqli_query($conn,"UPDATE book SET book_copies = '$new_book_copies' where book_id = '$book_id' ") or die (mysqli_error());
									mysqli_query($conn,"UPDATE book SET remarks = '$remark' where book_id = '$book_id' ") or die (mysql_error());
									
									mysqli_query($conn,"INSERT INTO borrow_book(user_id,book_id,date_borrowed,due_date,borrowed_status)
									VALUES('$user_id','$book_id','$date_borrowed','$due_date','borrowed')") or die (mysqli_error());
									
									$report_history=mysqli_query($conn,"select * from admin where admin_id = $id_session ") or die (mysqli_error());
									$report_history_row=mysqli_fetch_array($report_history);
									$admin_row=$report_history_row['firstname']." ".$report_history_row['middlename']." ".$report_history_row['lastname'];	
									
									mysqli_query($conn,"INSERT INTO report 
									(book_id, user_id, admin_name, detail_action, date_transaction)
									VALUES ('$book_id','$user_id','$admin_row','Borrowed Book',NOW())") or die(mysqli_error());
									
									}
									}
							?>
									<script>
										window.location="borrow_book.php?member_id=<?php echo $school_number ?>";
									</script>
							<?php	
								}
							?>
							</form>
						</table>
						
					</div>
				</div>
						
						
                        
                    </div>
                </div>
            </div>
<?php include ('footer.php'); ?>

${this.title}

Code Editor : borrow_book.php