<?php
/**
 * Created by PhpStorm.
 * User: adisa
 * Date: 2016-03-24
 * Time: 05:21 PM
 */
require_once('headMain_ord.php');
			//	require_once('../connect.php');
				extract($_POST);

$db=db_connect();


                   // $sql_fetch=$sql->fetch(PDO::FETCH_BOTH);
if(isset($_GET['ict'])){
    $filter=$_GET['ict'];
    $sql=$db->query("select * from siwesbiodata where formType='$filter'");

}else{
    $sql=$db->query("select * from siwesbiodata");
}


				?>
    <div class="row">
        <div class="col-lg-10">

        </div>
        <!-- /.col-lg-12 -->
    </div>
    <!-- /.row -->
    <div class="row">
    <div class="col-lg-12" >
    <div class="panel panel-info">
    <div class="panel-heading">
        Application 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>
        <?php

        if (isset($_GET['id'])){
            if ($_GET['id']==1){
                echo '<td colspan="10"  class="alert alert-success"  align="center" ><button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button> Record Saved Successfully';
            }elseif($_GET['id']==2){
                echo ' <td colspan="10" class="alert alert-success"  align="center" ><button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>Department Changed Successfully';
            }elseif($_GET['id']==3){
                echo ' <td colspan="10" class="alert alert-success"  align="center" ><button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>Form Already Filled';
            }elseif($_GET['id']==4){
                echo ' <td colspan="10" class="alert alert-danger"  align="center" ><button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>An Error Occurred';
            }
        }
        ?>
    </tr>
    <tr >
        <th>S/N</th>
        <th>Matric No</th>
        <th>Names</th>
        <th>Department</th>
        <th>Mode</th>
        <th>Placement</th>
        <th>Secured</th>
        <th>Bank Name</th>
        <th>Account No</th>
        <th>ISW - Code</th>
       <!-- <th>Date Created</th>-->

        <th>Action</th>
    </tr>


    </thead>
    <tbody>

                <?php
                $i=0;
                while ($row=$sql->fetch(PDO::FETCH_BOTH)){
                $matNo= $row['matNo'];
                        //$deptID= $row['dept'];
                        $sql_dept=$db->query("select * from realdata where matNo='$matNo'");
                        $sql_dept_fetch=$sql_dept->fetch(PDO::FETCH_BOTH);
                        $a='True';

                ?>

                <tr class="odd gradeX">
                    <td><?php echo $i +1;?></td>
                    <td><?php echo $row['matNo'];?></td>
                    <td><?php echo $sql_dept_fetch['names'];?></td>
                    <td><?php echo $sql_dept_fetch['course']; $a='True';?></td>
                    <td><?php echo $sql_dept_fetch['mode']; ?></td>
                    <td><?php echo $row['companyName']; ?></td>
                    <td><?php
                        $sql_s=$db->query("select * from siwesconfirm where matNo='$matNo'");
                        $sql_s_fetch=$sql_s->fetch(PDO::FETCH_BOTH);
                        echo $sql_s_fetch['secured'];
                        ?></td>
                    <td><?php echo $row['bankName']; ?></td>
                    <td><?php echo $row['AccountNo']; ?></td>
                    <td><?php
                        $bank= $row['bankName'];
                        $sql_dept_bank=$db->query("select * from bankdetail where bank_name='$bank'");
                        $sql_dept_bank_fetch=$sql_dept_bank->fetch(PDO::FETCH_BOTH);
                        echo $sql_dept_bank_fetch['isw_code'];

                        ?></td>

                    <td>
                        <?php
                        if ($a=='True'){
                           /*echo' <button class="btn btn-primary btn-lg" data-toggle="modal"
                                            data-target="#myModal" value="'.$matNo.' name="matNo2">
                                                Enter Bank Name
                            </button>';*/
                            echo '<a href="bankname.php?id='.$matNo.'" target="_blank">Enter Bank Name</a>';
                        }else{
                           // echo '<a href="print/rotherFeePrint.php?id='.$orderID.'&ptype='.$pt.'"target="_blank">Re-Print Reciept</a>';
                        }
                        ++$i;
                        }
                        ?>


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

<?php
include('footMain.php');
?>
<!-- Modal -->