<?php
/**
 * Created by PhpStorm.
 * User: adisa
 * Date: 3/2/2016
 * Time: 3:30 PM
 */
include('ace_headMain.php');
?>


    <div class="row">
        <div class="col-lg-12">

        </div>
        <!-- /.col-lg-12 -->
    </div>
    <!-- /.row -->
    <div class="row">
        <div class="col-lg-12">
            <div class="panel panel-info">
                <div class="panel-heading">
                    New Students with their Matric Numbers
                </div>
                <!-- /.panel-heading -->
                <div class="panel-body">
                    <div class="dataTable_wrapper">
                        <table class="table table-striped table-bordered table-hover" id="dataTables-example">
                            <thead>


                            <tr>
                                <th>Form No</th>
                                <th>Matric No</th>
                                <th>Full Name</th>
                                <th>Department</th>
                                <th>Level ID</th>
                                <th>Status</th>
                                <th>Mobile No.</th>
                            </tr>


                            </thead>
                            <tbody>
                            <?php
                                $i=0;
                            $queryt=$db->query("select a.formNo,a.matNo,a.names,a.course,a.levelID,a.gsm, b.amount,a.status from ace_realdata a JOIN ace_vw_schoolfees_2018_2019 b ON b.regNo=a.matNo");
while ($rowr=$queryt->fetch(PDO::FETCH_BOTH)){

                                ?>
                            <tr class="odd gradeX">
                                <td><?php echo $rowr['formNo'];?></td>
                                <td><?php echo $rowr['matNo'];?></td>
                                <td><?php echo $rowr['names'];?></td>
                                <td class="center"><?php  echo $rowr['course'];?></td>
                                <td class="center"><?php $k= $rowr['levelID'];
                                     $r=($db->query("select levelName from leveltb where id='$k'")->fetch(PDO::FETCH_BOTH));
                                    echo $r['levelName'];?></td>
                                <td class="center"><?php echo $rowr['amount'].'['.$rowr['status'].']'; ?></td>
                                <td class="center"><?php echo $rowr['gsm']; ?></td>
                            </tr>
                            <?php
                            ++$i;
                            }
                            ?>


                            </tbody>
                        </table>
                    </div>
                    <!-- /.table-responsive -->
                    <div class="well">
      <?php
include('footMain.php');
?>