<?php
ob_start();
include('ossce_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'];
                }*/
//$transId = $_GET['orderID'];
//$terminalId = $_GET['terminal_id'];
                  ?>


                  <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 ossce_realdata where formNo in (select regNo from ossce_remitaorder where regNo=ossce_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 ossce_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'];
                if ($pt=='School Fees') {
                    $terminal_id ='7007139452';
                }else{
                    $terminal_id='7007139451';

                }
                ?></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') {
//            etrans_check.php?terminal_id='.$terminal_id. '&ptype=' . $pt .'&orderID='.$orderID.'
            echo '<a href="ossce_etrans_check.php?terminal_id='.$terminal_id. '&formNo=' . $formNo .'&orderID='.$orderID.'" target="_blank">Generate MatNo</a>';
        }
        ++$i;


        ?>

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

                                  </table>



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



              <?php

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