<?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');
?>