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


 $branch=$_SESSION['branch'];
 $month_id=$_REQUEST['month'];
 $class_id=$_REQUEST['class_id'];

 $sql = "SELECT * FROM  edu_student_details  WHERE branch_id='$branch' and class_id='$class_id' and status='0'";
 $WorkAssignListings = $m->query($sql);

 


  $m->where("session_id", $_REQUEST['session']);
  $session=$m->get("edu_session_config");


  // getting branch details

  $m->where("branch_id", $_SESSION['branch']);
  $branch=$m->get("edu_branch_config");

 ?>

<!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 parents Id's 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 {padding:1%;border-bottom:1px solid gray;border-top:1px solid gray;border-left:1px solid gray;text-align:center;background-color:lightgray;font-size:14px;}
tr td {border-bottom:1px solid gray;border-left:1px solid gray;font-size:16px;}
  
.border{border:1px solid black;}
.center{text-align:center;}
.alignment{padding-left:1%;text-align:left;}



@media print {
    #Header, #Footer { display: none !important; }
}
@media screen
   {
      p.bodyText {font-family:verdana, arial, sans-serif;}
   }

   @media print
   {
      p.bodyText {font-family:georgia, times, serif;}
   }
   @media screen, print
   {
      p.bodyText {font-size:10pt}
   }
   @media print {
  a[href]:after {
    content: none !important;
  }
}
</style>
</head>
<body style="font-size:12px;">



<div style="text-align:center;font-size:24px;font-weight:bold;margin:0 auto;"><?php echo $branch[0]['Branch_Name'];?> 

</div>

<br>


    <div style="text-align:center;font-size:18px;font-weight:bold;"> Parents IDs & Password Report
 </div>
 

<hr style="width:100%;" />

<div style="font-size:16px; font-weight: bold;margin-left: 5px;"> Class Name: <?php echo getClassName($m,$_REQUEST['class_id']);?></div>
<table id="listofstudents" class="table table-striped table-bordered" style="width:100%">
 
        <thead>
            <tr>

              
                <th width="5%">S.No</th>
                <th width="15%">Parents Name</th>
                <th width="10%">Adm / Roll No</th>
                <th width="10%"> Id/Cell No </th>
                <th width="10%" style="border-right: 1px solid black;">Password</th>
                                
            </tr>
        </thead>
        <tbody>


   
     
     <?php 
$count=1;
      foreach($WorkAssignListings as $WorkAssignListVal)
      { 
      $cell_number=$WorkAssignListVal['parents_cellno'];
       
       $m->where("parents_cellno", $WorkAssignListVal['cell_no']);
       $parents=$m->get("eduportal_parents_access");

      if ($parents[0]['parents_id']=='') {
        
        continue;
      }
     
      ?>

        <tr>                       
          <td style="text-align:center; padding: 2px;"><?php echo $count++;?></td> 
          <td style="padding: 2px;" > <?php echo $parents[0]['parents_name'];?></td>
          <td style="padding: 2px; text-align:center;" > <?php echo $WorkAssignListVal['ref_no']." / ".$WorkAssignListVal['candidate_roll_no'];?></td>
          <td style="text-align:center;"> <?php echo $parents[0]['parents_cellno'];?></td>
          <td style="padding: 2px;border-right: 1px solid black;text-align:center;" > <?php echo $parents[0]['password'];?></td>
              
       </tr>

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

 </body>
</html>
