<?php
  require_once"labClass.php";

  $con=new labClass();

  $rQ= $con->getLabToolKitUsedRecords();
 
  if ($rQ->rowCount()>0) {

    $chp=$rQ->fetchAll();
    
      ?>
  <div class="container-fluid" id="co">
    <img src="assets/phead.PNG" width="100%" height="80px">
  <small><h6>LAB TOOLKIT USES RECORDS:</h6></small> 
  <table class="table"><tr>
    <td style="width:15%;">Sort by date range:</td><td style="width:10%;" ><input type="date" style="width:200px;" class="form-control" id="dat1" name="dat1"  value="<?php echo Date("Y-m-d");?>" >
        </td>
        <td>
          and:</td><td style="width:10%;">
          <input type="date" style="width:200px;" class="form-control" id="dat2" name="dat2" value="<?php echo Date("Y-m-d");?>">
       

        </td>
        <td style="width:10%;">  
            <button type="submit" class="btn btn-primary" style="width:100%; height:40px;" onclick=" var dat1=$('#dat1').val(); var dat2=$('#dat2').val();  $.post('toolKitUsedRecordsByDate.php',{dat1:dat1,dat2:dat2},function(data){$('#dpl').html(data).show();});">Generate</button>
 
</td>
       
</tr>

</table>  
  <div class="container-fluid" id="dpl"> 
  <table class="table table-bordered table-striped">
  <thead class="bg-secondary">
   <th>  
        <small><h6>ITEM NAME</h6></small>
      </th>
      <th>  
        <small><h6>USED QTY</h6></small>
      </th>
      <th>  
        <small><h6>DATE ENTERED</h6></small>
      </th>
       
    </thead>
  <tbody>
   
  <?php
 foreach ($chp as $key => $p) 
 {
 
        ?>
    <tr>
      
      <td> 

         <?php echo $p['tName'];?> 
       
      </td> 
      <td> 

         <?php echo $p['iQty'];?> 
       
      </td> 

       <td> 
         <?php echo $p['dateEntry'];?> 
       
      </td>
  
  </tr>

 
  <?php
 
} 
?>
</tbody>
</table>
</div>
</div>
<div>
   <button type="submit" class="btn btn-primary" value="Print" style="width:10%; height:30px;" onclick="printPageArea();">Print </button>
</div>
<?php
}
?>
 

 <script type="text/javascript">
  function printPageArea(){
    var printContent = document.getElementById('co').innerHTML;
    var originalContent = document.body.innerHTML;
    document.body.innerHTML = printContent;
    window.print();
    document.body.innerHTML = originalContent;
}

</script>