<?php
session_start();
/**
 * Created by PhpStorm.
 * User: adisa
 * Date: 2016-03-24
 * Time: 05:21 PM
 */
require_once('headMain2.php');
require_once('../connect.php');
$db=db_connect();
extract($_POST);
$regNo=$_SESSION['formNo'];
                                            if (isset($_SESSION['matNo'])){
                                                $regNo=$_SESSION['matNo'];
                                            }

                                            $res=$db->query("select * from realdata where formNo='$regNo' or matNo='$regNo'");
                                            $k=$res->rowCount();
                                            if ($k>0){
                                                $res_fetch=$res->fetch(PDO::FETCH_BOTH);
                                                $otherNo1=$res_fetch['formNo'];
                                                $otherNo2=$res_fetch['matNo'];
                                            }else{
                                                $otherNo1=$regNo;
                                                $otherNo2=$regNo;
                                            }
                                            $sql="select * from remitaorder where regNo='$otherNo1' or regNo='$otherNo2'";
                                            $result=$db->query($sql);
                                            $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">
                 Payment Transaction History
            </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>Remita RR</th>
                            <th>Trans Date</th>
                            <th>Date Created</th>
                            <th>Payment ID</th>
                            <th>Payment Type</th>
                            <th>Amount Paid</th>
                            <th>Trans Details</th>
                            <th>Trans Approved</th>
                            <th>Status</th>
                        </tr>


                        </thead>
                        <tbody>



                                                            <?php
                                                            while ($row=$result->fetch(PDO::FETCH_BOTH)){
                                                            ?>

                                                            <tr>
                                                                <td><?php echo $i +1;?></td>
                                                                <!--<td><?php $orderID=$row['orderID'];?></td>-->
                                                                <td><?php echo $row['remitaRRR'];?></td>
                                                                <td><?php echo $row['transDate'];?></td>
                                                                <td><?php echo $row['dateCreated'];?></td>
                                                                <td><?php echo $_SESSION['regNo']=$row['regNo']; ?></td>
                                                                <td><?php 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="reQueryAcceptance.php?id='.$orderID.'&ptype='.$pt.'"target="_blank">Re-Query</a>';
                                                                    }
                                                                    ++$i;
                                                                    }
                                                                    ?>


                                                                </td>
                                                            </tr>
                                                        </table>

                                                    <p>&nbsp;</p>



                                    <!-- InstanceEndEditable -->
                </div>
                </div>
            </div>
        </div>
    </div>


<p>&nbsp;</p>
<script type="text/javascript">
    var MenuBar1 = new Spry.Widget.MenuBar("MenuBar1", {imgDown:"../SpryAssets/SpryMenuBarDownHover.gif", imgRight:"../SpryAssets/SpryMenuBarRightHover.gif"});
</script>

<?php
include('footMain.php');
?>