<?php
ob_start();
ini_set('memory_limit', '512M');
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'];
}*/

?>


    <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>Form No</th>
                                <th>Matric No</th>
                                <th>Payment Type</th>
                                <th>Trans Amount</th>
                                <th>Trans Details</th>
                                <th>Trans Approved</th>
                                <th>Status</th>
                            </tr>


                            </thead>
                            <tbody>

                            <?php
                            $res=$db->query("select * from realdata where formNo in (select regNo from remitaorder where regNo=realdata.formNo and paymentType='School Fees' and transApproved='True')");
                            //$res_fetch=$res->fetch(PDO::FETCH_BOTH);
                            while ($row2=$res->fetch(PDO::FETCH_BOTH)) {
                                $formNo = $row2['formNo'];
                                $matNo = $row2['matNo'];
                                $row2['names'];
                                $k = $res->rowCount();
                                if ($k > 0) {
                                    $sql = "select * from remitaorder where regNo='$formNo' and paymentType='School Fees' and transApproved='True'";
                                    $result = $db->query($sql);
                                    $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 echo $row2['formNo']; ?></td>
                                        <td><?php echo $row2['matNo']; ?></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="reQuery.php?id=' . $orderID . '&ptype=' . $pt . '&formNo=' . $formNo . '">Generate MatNo</a>';
                                            }
                                            ++$i;


                                            ?>

                                        </td>
                                    </tr>
                                <?php
                                }
                            }
                            ?>
                            </tbody>

                        </table>



                    </div>
                </div>
            </div>
        </div>
    </div>



<?php

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