<?php
/**
 * Created by PhpStorm.
 * User: adisa
 * Date: 3/2/2016
 * Time: 3:30 PM
 */
include('headMain_ord.php');
extract($_POST);
$sql=$db->query("select * from vw_all_payment where course='$dept' and levelID='$level'");
//=$sql->fetch(PDO::FETCH_BOTH);

?>


    <div class="row">
        <div class="col-lg-12">
           <h1 class="page-header"> <b>Department : <?php echo $dept;?><br> Level: <?php echo $level;?></b></h1>
        </div>
        <!-- /.col-lg-12 -->
    </div>
    <!-- /.row -->
    <div class="row">
        <div class="col-lg-12">
            <div class="panel panel-info">
                <div class="panel-heading">
                    Payment Details
                </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 class="panel panel-heading">
                                <th>Form No.</th>
                                <th>Matric No.</th>
                                <th>Full Name</th>
                                <th>Department</th>
                                <th>Level ID</th>
                                <th>Mobile No</th>
                                <th>School Fees</th>
                                <th>Acceptance Fee</th>
                                <th>other Fees</th>
                            </tr>


                            </thead>
                            <tbody>
                            <?php
                                $i=0;
                            //echo $numt;
                            while ($rowt=$sql->fetch(PDO::FETCH_BOTH)){
                                 /*   $regNo=mysql_result($queryt,$i,'regNo');
                                    $qry=mysql_query("select * from realdata where matNo='$regNo'");*/
                                if ($rowt['paymentType']=='School Fees'){
                                    $schFees=$rowt['amtPaid'];
                                    $accPay=0;
                                    $otherPay=0;
                                }
                                if ($rowt['paymentType']=='Acceptance fees'){
                                    $schFees=0;
                                    $accPay=$rowt['amtPaid'];
                                    $otherPay=0;
                                }
                                if (($rowt['paymentType']!='School Fees') and ($rowt['paymentType']!='Acceptance Fees')){
                                    $schFees=0;
                                    $accPay=0;
                                    $otherPay=$rowt['amtPaid'];
                                }

                                    ?>
                                    <tr class="odd gradeX">
                                        <td><?php echo $rowt['formNo']; ?></td>
                                        <td><?php echo $matNo=$rowt['matNo']; ?></td>
                                        <td><?php echo $rowt['names']; ?></td>
                                        <td class="center"><?php echo $rowt['course']; ?></td>
                                        <td class="center"><?php echo $rowt['levelID'];?></td>
                                        <td class="center"><?php echo $rowt['gsm']; ?></td>
                                        <td class="center"><?php echo $schFees;?></td>
                                        <td class="center"><?php echo $accPay;?></td>
                                        <td class="center"><?php echo $otherPay;?></td>
                            </tr>
                            <?php
                            ++$i;
                            }
                            ?>


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