<?php
ob_start();
include('headMain2.php');
/**
 * Created by PhpStorm.
 * User: adisa
 * Date: 2016-03-24
 * Time: 05:21 PM
 */
$terminal_id='7007139451';
require_once('../connect.php');
$db=db_connect();
$regNo=$_SESSION['formNo'];
if (isset($_SESSION['matNo'])){
    $regNo=$_SESSION['matNo'];
}
$res=$db->query("select * from ace_realdata where formNo='$regNo' or matNo='$regNo'");
$res_fetch=$res->fetch(PDO::FETCH_BOTH);
$k=$res->rowCount();
if ($k>0){
    echo $otherNo1=$res_fetch['formNo'];
    $otherNo2=$res_fetch['matNo'];
}else{
    $otherNo1=$regNo;
    $otherNo2=$regNo;
}
$sql="select * from ace_remitaorder where regNo='$formNo' or regNo='$otherNo2'";
$result=$db->query($sql);
//$result_fetch=$result->fetch(PDO::FETCH_BOTH);
$num=$result->rowCount();
$i=0;

?>


    <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 <?php //echo $regNo.'asdkh'; ?>
                </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>Payment Type</th>
                                <th>Trans Amount</th>
                                <th>Trans Details</th>
                                <th>Trans Approved</th>
                                <th>Status</th>
                            </tr>


                            </thead>
                            <tbody>

                            <?php
                            while ($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 $_SESSION['regNo']=$row['regNo']; 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>

                                    <!--            //==========================-->
                                    <!--            <form method = “POST‟ action= “http://demo.etranzact.com/WebConnectPlus/query.jsp‟ >-->
                                    <!--                <input type=hidden name = “TERMINAL_ID” value=‟0000000001‟>-->
                                    <!--                <input type=hidden name = “TRANSACTION_ID” value=‟1234325435435345345435454‟>-->
                                    <!--                <input type=hidden name= “RESPONSE_URL” value=‟http://www.mywebsite.com/processQuery.jsp‟>-->
                                    <!--                <input type="s">-->
                                    <!--            </form>-->
                                    <!--            //===========================-->

                                    <?php
                                    if ($a!='True'){
//                echo '<form method = "POST" action="https://demo.etranzact.com/WebConnectPlus/query.jsp">
//                <input type=hidden name = "TERMINAL_ID" value="0000000001">
//                <input type=hidden name = "TRANSACTION_ID" value="'.$orderID.'">
//                <input type=hidden name= "RESPONSE_URL" value="https://federalpolyede.edu.ng/ace_admin_student/reQueryNew.php">
//                <input type="Submit" name="submit" value="Get Payment Status">
//            </form>';
//                echo '<a href="reQuery.php?id='.$orderID.'&ptype='.$pt.'"target="_blank">Re-Query</a>';
                                        if ($pt=='School Fees') {
                                            $terminal_id ='7007139452';
                                        }else{
                                            $terminal_id='7007139451';

                                        }
//               echo '<a href="https://etranzact.net/WebConnectPlus/query.jsp?TERMINAL_ID='.$terminal_id.'&TRANSACTION_ID='.$orderID.'">Get Status</a>';
                                        echo '<a href="etrans_check.php?terminal_id='.$terminal_id.'&orderID='.$orderID.'">Get Status</a>';
                                    }

                                    ++$i;
                                    }
                                    ?>

                                </td>
                            </tr>
                        </table>
                        </form>
                        <p>&nbsp;</p>
                        </fieldset></td>
                        </tr>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>

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