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


    <div class="row">
        <div class="col-lg-12">
            <!--<h1 class="page-header"></h1>-->
        </div>
        <!-- /.col-lg-12 -->
    </div>
    <!-- /.row -->
    <div class="row">
        <div class="col-lg-12">
            <div class="panel panel-info">
                <div class="panel-heading">
                    School Fees Payers
                </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>RegNo No.</th>
                                <th>Full Name</th>
                                <th>Receipt No.</th>
                                <th>Remita RR</th>
                                <th>Transaction Date</th>
                                <th>Payment Type</th>
                                <th>Amount Paid</th>
                            </tr>
                            </thead>
                            <tbody>
                            <?php
							 
                                $qry=mysql_query("select regNo, (select names from realdata where matNo=regNo or formNo='regNo') names,amtPaid,paymentType, orderID,remitaRRR, transDate from remitaorder where transApproved='True'");
								echo $num=mysql_num_rows($qry);
								 $i=0;
								 while ($i<$num){
                                    ?>
                                    <tr class="odd gradeX">
                                        <td><?php echo mysql_result($qry,$i,'regNo'); ?></td>
                                        <td><?php echo mysql_result($qry,$i,'names'); ?></td>
                                        <td><?php echo mysql_result($qry,$i,'orderID'); ?></td>
                                        <td class="center"><?php echo mysql_result($qry,$i,'remitaRRR'); ?></td>
                                        <td class="center"><?php echo mysql_result($qry,$i,'transDate'); ?></td>
                                        <td class="center"><?php echo mysql_result($qry,$i,'paymentType'); ?></td>
                                        <td class="center"><?php echo mysql_result($qry,$i,'amtPaid'); ?></td>
                                        
                            </tr>
                            <?php
                            ++$i;
                            }
                            ?>


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