overdue.php

<?php
$timezone = "America/Chicago";
if(function_exists('date_default_timezone_set')) date_default_timezone_set($timezone);

?>
<style>
.trss{
	background-color:#FFCC99;}
.trss:hover{background-color:#F90;

}

</style>
<SCRIPT language="javascript">

    $(function () {

        // add multiple select / deselect functionality

        $("#selectall").click(function () {

            $('.name').attr('checked', this.checked);

        });



        // if all checkbox are selected, then check the select all checkbox

        // and viceversa

        $(".name").click(function () {



            if ($(".name").length == $(".name:checked").length) {

                $("#selectall").attr("checked", "checked");

            } else {

                $("#selectall").removeAttr("checked");

            }



        });

    });

</SCRIPT>

<?php

if(isset($_POST['overreport'])){
include('overreport.php');
}else{

?>

<table border="0" style="margin-top:20px; margin-left:38px;">
<tr>
<td rowspan="3">&nbsp;</td>
<tr>
<td style="font-size:18px;font-family:Verdana, Geneva, sans-serif; border-bottom:#666 solid 1px; ">List of Overdue Books</td>
</tr>
<tr>
<td style="font-size:12px;font-family:Verdana, Geneva, sans-serif;"><?php echo date_format(date_create(date("Y/m/d")), 'F d, Y');?></td>
</tr>

</tr>
</table>

<form action="" method="post">

<table cellpadding="5px" width="92%" align="center" bordercolor="#999999" class="web" border="0" cellspacing="1" style="border:#666 solid 1px;
 margin-bottom:20px; margin-left:38px; margin-right:45px; font-size:12px;font-family:Verdana, Geneva, sans-serif; margin-top:20px;">
<thead>
<tr bgcolor="#F90" height="30" style="color:#000;  font-weight:bold; text-align:left;" >
<td>No.</td>
   <td class="web" width="100" align="center">Card No</td>
    <td class="web" width="300" align="center">Book Title</td>
    <td class="web" width="200" align="center">Borrower's Name</td>
    <td class="web" width="120" align="center">Due Date</td>
    <td class="web" width="150" align="center">Count&nbsp;of&nbsp;days
    </td>
    <td class="web" width="120" align="center">Fine Amount</td>
</tr>

<?php
$FINE_AMT = 0.25;
$duedate=mysql_query("SELECT *, DATEDIFF(NOW(), due_date) AS due_days, (DATEDIFF(NOW(), due_date)* $FINE_AMT) AS fine FROM `book_loans` WHERE date_in = '0000-00-00' AND due_date < NOW()");



$count=0;
$c=1;
while($row=mysql_fetch_array($duedate)){

$count++;
$borrower=mysql_query("select * from borrower where card_no='".$row['card_no']."'");

$stud=mysql_fetch_array($borrower);

$bo=mysql_query("select * from book where book_id='".$row['book_id']."'");
$book=mysql_fetch_array($bo);

$fineamt = $row['fine'];

?>


<tr class="trss" align="center" >
<td><?php echo $count;?></td>
<td><?php echo $row['card_no']; ?></td>
<td><?php echo $book['title']; ?></td>
<td><?php echo $stud['fname']."&nbsp".$stud['lname']; ?></td>
<td><?php echo date_format(date_create($row['due_date']), 'F d, Y'); ?></td>
<td>
<input type="hidden" name="countdays" value="<?php echo $row['due_days']; ?>">
<?php echo  $row['due_days']; ?></td>
<td><?php echo ("$")."&nbsp".$fineamt; ?></td>
</tr>
<?php




} ?>

</table>


<?php }?>



<div class="footer">
<div class="leftfoot"></div>
<div class="bodyfoot">
<table border="0" style="margin-top:20px; font-family:Verdana, Geneva, sans-serif; font-size:10px;">
<tr>
<?php
 if(isset($_POST['overreport'])){  ?>

 <?php }else{?>
 <td>Count of Over Due Books</td>
<td><input type="text" value="<?php echo $j; ?>" style="padding:2px; width:60px;" readonly="readonly"></td>
  <?php } ?>

  <td>
<?php
 if(isset($_POST['overreport'])){  ?>
<?php }else{?>
  </form>

 <?php } ?>
</td>
</tr>
</table>

</div>
<div class="rightfoot"></div>
</div>
</div>
</body>
</html>