<?php
ob_start();
include('headMain.php');
/**
 * Created by PhpStorm.
 * User: adisa
 * Date: 2016-03-24
 * Time: 05:21 PM
 */

	require_once('../connect.php');
$db=db_connect();
				$regNo=$_SESSION['formNo'];
				if (isset($_SESSION['matNo'])){
                    $regNo=$_SESSION['matNo'];
                }
				$res=$db->query("select * from realdata where formNo='$regNo' or matNo='$regNo'");
$res_fetch=$res->fetch(PDO::FETCH_BOTH);
			 $k=$res->rowCount();
			  if ($k>0){
                 echo $otherNo1=$res_fetch['formNo'];
                  $otherNo2=$res_fetch['matNo'];
              }else{
                  $otherNo1=$regNo;
                  $otherNo2=$regNo;
              }
			  $sql="select * from aa_all_payment where regNo='$matNo' or regNo ='$otherNo1'";
				$result=$db->query($sql);
//$result_fetch=$result->fetch(PDO::FETCH_BOTH);
				$num=$result->rowCount();
				$i=0;

				?>


    <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">
        Transactions 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 >
        <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>Pay Session</th>
    </tr>


    </thead>
    <tbody>

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

        <tr>
            <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 echo $a = $row['pay_session'];?></td>
        </tr>
    <?php
    }
        ?>
        </tbody>
        </table>


        </form>
        <p>&nbsp;</p>
    </fieldset></td>
</tr>
</table>
    </div>
    </div>
    </div>
    </div>
    </div>

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