<?php
session_start();
/**
 * Created by PhpStorm.
 * User: adisa
 * Date: 2016-03-24
 * Time: 05:21 PM
 */
include('headMain2.php');
				require_once('../connect.php');
				extract($_POST);
//$idNo=$_SESSION['matNo'];
$db=db_connect();
				if (isset($_SESSION['matNo'])) {
                    $regNo = $_SESSION['matNo'];
                    $formNo=$_SESSION['formNo'];
                }elseif(isset($_SESSION['idNo'])) {
                    $regNo = $_SESSION['idNo'];
                    $formNo=$_SESSION['idNo'];
                }
				$sql="select * from remitaorder where (regNo='$regNo' or regNo='$formNo')and regNo<>'' and paymenttype<>'Acceptance Fee' and paymenttype<>'School Fees'  and paymenttype<>'Additional School Fees' and paymentType<>'Admission Slip'";
				$result=$db->query($sql);
//$result_fetch=$result->fetch(PDO::FETCH_BOTH);
				$num=$result->rowCount();
				$i=0;
				?>
    <div class="row">
        <div class="col-lg-10">
        </div>
        <!-- /.col-lg-12 -->
    </div>
    <!-- /.row -->
    <div class="row">
    <div class="col-lg-10 col-lg-offset-1" >
    <div class="panel panel-info">
    <div class="panel-heading">
        Other Payment Transactions
    </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>S/N</th>
        <th>Trans ID</th>
        <th>Remita RR</th>
        <th>Trans Date</th>
        <th>Payment Type</th>
        <th>Trans Amount</th>
        <th>Trans Details</th>
        <th>Trans Approved</th>
        <th>Status</th>
    </tr>
    </thead>
    <tbody>
                <?php
                while ($row=$result->fetch(PDO::FETCH_BOTH)){
                ?>
                <tr class="odd gradeX">
                    <td><?php echo $i +1;?></td>
                    <td><?php echo $orderID= $row['orderID'];?></td>
                    <td><?php echo $row['remitaRRR'];?></td>
                    <td><?php echo $row['transDate'];?></td>
                    <td><?php $_SESSION['regNo']=$row['regNo']; echo $pt=$row['paymentType']; ?></td>
                    <td><?php echo $row['amtPaid'];?></td>
                    <td><?php echo $row['transDetail'];?></td>
                    <td><?php echo $a=$row['transApproved'];?></td>
                    <td>
                        <?php
                        if ($a!='True'){
                            echo '<a href="reQueryb.php?id='.$orderID.'&ptype='.$pt.'"target="_blank">Re-Query</a>';
                        }else{
                            echo '<a href="print/rotherFeePrint.php?id='.$orderID.'&ptype='.$pt.'"target="_blank">Re-Print Reciept</a>';
                        }
                        ++$i;
                        }
                        ?>
                    </td>
                </tr>
            </table>
        </form>
        <p>&nbsp;</p>
    </fieldset></td>
</tr>
</table>
    </div>
    </div>
    </div>
    </div>
    </div>
<?php
include('footMain.php');
?>