<?php
require_once('headMain_sidebar.php');
?>

			<?php
            extract($_POST);
			require_once('../connect.php');
            $db=db_connect();

  $sql1="select * from remitaorder where `regNo`='$serial' and transApproved='True' and paymentType='School Fees'";
//die();
 $result1=$db->query($sql1);
 $num=$result1->rowCount();
//            $result1_fetch=$result1->fetch(PDO::FETCH_BOTH);
while ($result1_fetch=$result1->fetch(PDO::FETCH_BOTH)) {
    //echo $num;
    if ($num > 0) {
        ?>
        <fieldset>
            <legend><h2>Payment Details</h2></legend>
            <table width="70%" cellspacing="5" cellpadding="3">
                <tr>
                    <td width="52%"><strong>Receipt Number</strong></td>
                    <td width="48%"><?php echo $result1_fetch['orderID']; ?></td>
                </tr>
                <tr>
                    <td><strong>Paid By</strong></td>
                    <td><?php echo $regNo = $result1_fetch['regNo'];
                        echo ' <b>(';

                        $result = $db->query("select * from realdata where matNo='$regNo' or formNo='$regNo'");
                        if ($result->rowCount() > 0) {
                            $name_fetch = $result->fetch(PDO::FETCH_BOTH);
                            echo $name_fetch['names'] . ')</b>';
                        }
                        ?></td>
                </tr>
                <tr>
                    <td><strong>Amount</strong></td>
                    <td><?php echo $result1_fetch['amtPaid']; ?></td>
                </tr>
                <tr>
                    <td><strong>Date </strong></td>
                    <td><?php echo $result1_fetch['transDate']; ?></td>
                </tr>
                <tr>
                    <td><strong>Payment Description</strong></td>
                    <td><?php echo $result1_fetch['paymentType']; ?></td>
                </tr>
                <tr>
                    <td><strong>Remita Retrieval Reference </strong></td>
                    <td><?php echo $result1_fetch['remitaRRR']; ?></td>
                </tr>
            </table>
        </fieldset>
    <?php

    } else {
        echo 'Payment Has not Been Made';
    }
}
?>
    <div align="left"><a href="javascript:history.go(-1)" style="font-size: 18px"> Go to Previous page</a></div> <hr>
			

<p>&nbsp;</p>
<script type="text/javascript">
var MenuBar1 = new Spry.Widget.MenuBar("MenuBar1", {imgDown:"../SpryAssets/SpryMenuBarDownHover.gif", imgRight:"../SpryAssets/SpryMenuBarRightHover.gif"});
</script>
</body>
<!-- InstanceEnd --></html>
<?php
include('footMain.php');
?>