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

<?php
extract($_POST);
require_once('../connect.php');
$db=db_connect();
$sql1="select * from remitaorder where `orderID`='$serial' or remitaRRR='$serial' and transApproved='True'";
$result1=$db->query($sql1);
$num=$result1->rowCount();
$result1_fetch=$result1->fetch(PDO::FETCH_BOTH);
//echo $num;
if ($num>0){
    ?>
    <fieldset>

        <legend><h2>Payment Details</h2></legend>
        <table width="100%" 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>';
                    } else {

                        $result = $db->query("select * from otherpayment where idNo='$regNo'");
                        if ($result->rowCount() > 0) {
                            $name_fetch = $result->fetch(PDO::FETCH_BOTH);
                            echo $name_fetch['names'] . ')</b>';
                            echo "<div style='color: red'>Note: Not an Active Student</div>";
                        }
                    }
                    ?></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>
			
			<!-- InstanceEndEditable --></td>
            <td align="right" valign="top"><!-- InstanceBeginEditable name="EditRegion4" --><!-- InstanceEndEditable --></td>
          </tr>
        </table></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
      </tr>
    </table></td>
  </tr>
</table>
<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');
?>