<?php include('parent/callMe.php');?>
<?php include('Sessioncheck.php');?>
<?php   

$branch=$_SESSION['branch'];

$sql = "SELECT * FROM eduportal_library_details where branch_id='$branch' ";


$books = $m->query($sql);
 //print_r($categories);

 ?>
<!DOCTYPE HTML>
<html>
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>Print PayRoll Sheet</title>
<link rel="icon" type="image/png" href="img/favicon.png" sizes="32x32" />
<script type="text/javascript">
// window.print();
</script>
<style type="text/css">

tr th {border-top:1px solid gray;border-left:1px solid black;border-bottom:1px solid black;text-align:center;background-color:lightgray;font-size:14px; padding:3px;}
tr td {border-bottom:1px solid gray;border-left:1px solid black;font-size:14px; padding:3px;}
  
.border{border:1px solid black;}
.center{text-align:center;}
.alignment{padding-left:1%;text-align:left;}
.borderTop{
  border-top: none;
}
</style>
</head>
<body style="font-size:12px;">





<br>

<div style="text-align:center;font-size:24px;font-weight:bold;">Library Books List

 </div>

<hr style="width:100%;">
<!-- <div style="width:33%; float:left;font-size:18px; margin-left:10px; "> <b> Month:</b> <?php echo $month[0]['Month_Name'];?> </div> -->


<br><br>
   
    <table style="width:100%;font-size:12px;" cellspacing="0">
          
          <thead>
            <tr>
                <th width="5%">S.No</th>
                <th width="8%">Book Title</th>
                <th width="8%">Book Number</th>
                <th width="8%">ISBN Number</th>
                <th width="8%"> Publisher </th>
                <th width="8%"> Author </th>
                <th width="8%"> Subject </th>
                <th width="8%"> Rack Number </th>
                <th width="8%"> Qty </th>
                <th width="8%"> Available </th>
                <th width="8%"> Book Price </th>
                <th width="8%"> Post Date </th>                                   
            </tr>
        </thead>
        <tbody>
   
<?php 

      $count=1;
      foreach($books as $book)
      { 

        $m->where("class_id", $WorkAssignListVal['class_id']);
        $class=$m->get("edu_class_config");

        $m->where("section_id", $WorkAssignListVal['section_id']);
        $section=$m->get("edu_adm_section_detail");

        $m->where("session_id", $WorkAssignListVal['session_id']);
        $session=$m->get("edu_session_config");
        
      ?>
   			<tr> 
       <td style="text-align:center; padding: 2px;"><?php echo $count++;?></td>        

          <td style="padding: 2px;" > <?php echo $book['book_title'];?></td>

          <td style="padding: 2px;" > <?php echo $book['book_number'];?></td>

          <td style="padding: 2px;" > <?php echo $book['ISBN_number'];?></td>

          <td style="padding: 2px;" > <?php echo $book['publisher'];?></td>

          <td style="padding: 2px;" > <?php echo $book['author'];?></td>

          <td style="padding: 2px;" > <?php echo $book['subject'];?></td>

          <td style="padding: 2px;" > <?php echo $book['rack_number'];?></td>

          <td style="padding: 2px;" > <?php echo $book['qty'];?></td>

          <td style="padding: 2px;" > <?php echo $book[''];?></td>

          <td style="padding: 2px;" > <?php echo $book['book_price'];?></td>

          <td style="padding: 2px;" > <?php echo $book['post_date'];?></td>
                                                                  
      </tr>

       <?php } ?>
     
 
             
        </tbody>
        
    </table><br>
     
      
      

</body>
</html>
