<?php
include "../../pidbco/pidbjoin.php";
 ?>
   <style>
   	@media print {
   thead {display: table-header-group;}
    }
   </style>	

  <!--<body style="margin:0px; font-family:Arial, Helvetica, sans-serif; font-size:12px;" onload=" window.print();window.close();"> -->
  	     
     <div id="invoice" style=" height:1010px; margin:0px auto; background-color:#FFFFFF; padding:25px 0px;">
    
    
            <div style="  height:1100px; margin:0px auto;">

             <!--  <div style="text-align:right;margin-top: -25px;  " >
                <img src="../admin/logo.jpg" alt="logo" />                
             </div> -->
             <?php
                 $newDate1 = date('d/m/Y');
			     $ip = $_SERVER['REMOTE_ADDR'];
               ?>
              <div style="text-align:right;margin-top: -25px;  " >
              	<span style=" font-size: 12px;" > Date : <?php echo $newDate1; ?></span><br>
              	<span style=" font-size: 12px; margin-top: 2px;">Ip &nbsp;&nbsp;&nbsp;&nbsp;: <?php echo $ip; ?>&nbsp;&nbsp;</span>
              </div>	

            <div style="text-align:left; margin-top:2px;font-weight:bold; font-size:20px;">
            <?php 
              echo 'REPORTS';
            ?>
         </div>

         <br />

         <div style="width:100%; height:390px;">

            <table style="width:100%; font-size:11px; border:none; ">
               <thead>
                <tr style="text-align:left; background-color:#CCCCCC;">

                  
                    <th style=" border:solid 1px #999999;" width="10%">
                        Exe. BDO
                    </th>
                      <th style=" border:solid 1px #999999;">
                        Report Date
                    </th>
                     <th style="border:solid 1px #999999;" width="10%" >
                        Report
                    </th>
                    
                  </tr>
               </thead>  
              <?php
                        $stmt = mysqli_query($con,"SELECT * FROM `daily_rep_det` ");
                        $i=1;
                        while($res = mysqli_fetch_object($stmt))
                        {
                            $ex_bdo = $res->bdo_id;
                            $qry15 = mysqli_query($con,"SELECT id,emp_name FROM employee_registration WHERE id='$ex_bdo'");
                            $qry15_fet = mysqli_fetch_object($qry15);
                           ?>
        <tr style="line-height:20px;">

       
        <td style="padding-left:5px; border:solid 1px #999999; border-top:none;text-align:center;">
       <?php echo $qry15_fet->emp_name; ?>
        </td>
       <td style="text-align:center; padding-right:5px; border:solid 1px #999999; border-top:none;">
       <?php echo $res->report_date; ?>
       	</td>
        <td style="text-align:center; border:solid 1px #999999; border-top:none;">
       <?php echo $res->report; ?>
        </td>
        
      
        
       
    </tr>
    
<?php
    $p++;
    }
    $stmt->close();
?>
    
 </table>
</div>
<br /><br />
</div>
</div>
</body>