<script type="text/javascript" language="javascript" src="../js/jquery-1.7.1.js"></script>
<script type="text/javascript" language="javascript" src="../js/scriptFile2.js"></script>
<?php
require_once('ace_headMain.php');
//echo 'kjhigdqikjd';
?>
<?php
extract($_POST);

$sql="select * from ace_realdata where formNo='$formNo'";
$result=$db->query($sql);
$num=$result->rowCount();
if ($num=='1'){
$result_fetch=$result->fetch(PDO::FETCH_ASSOC);
$names=$result_fetch['names'];
$matNo=$result_fetch['matNo'];
$course=$result_fetch['course'];
$mode=$result_fetch['mode'];

$levelID=$result_fetch['levelID'];
?>
<table width="50%" cellspacing="2" cellpadding="0">
    <tr>
        <td><form id="form1" name="form1" method="post" action="ace_changeOfCourse_process_process.php">
                <fieldset>
                    <legend>Processing Form...</legend>
                    <table width="100%" cellspacing="5" cellpadding="0">
                        <tr>
                            <td colspan="3" align="center"><strong>Mode:-</strong><?php echo $mode;?> <strong>LevelID</strong>:- <?php echo $levelID;?></td>
                        </tr>
                        <tr>
                            <td colspan="3" align="center"><hr /><input type="hidden" name="old_mode" value="<?php echo $mode ;?>"></td>
                        </tr>
                        <tr>
                            <td width="55%"><strong>Form No</strong></td>
                            <td width="5%">&nbsp;</td>
                            <td width="40%"><?php echo $formNo;?>
                                <input type="hidden" name="formNo" id="formNo" value="<?php echo $formNo;?>" /></td>
                        </tr>
                        <tr>
                            <td><strong>Matric Number</strong></td>
                            <td>&nbsp;</td>
                            <td><?php echo $matNo;?>
                                <input type="hidden" name="matNo" id="matNo" value="<?php echo $matNo;?>" /></td>
                        </tr>
                        <tr>
                            <td><strong>Name</strong></td>
                            <td>&nbsp;</td>
                            <td><?php echo $names;?>
                                <input type="hidden" name="names" id="names" value="<?php echo $names;?>" /></td>
                        </tr>
                        <tr>
                            <td><strong>Previous Course</strong></td>
                            <td>&nbsp;</td>
                            <td><?php echo $course;?>
                                <input type="hidden" name="course" id="course" value="<?php echo $course;?>" /></td>
                        </tr>
                        <tr>
                            <td><strong>Amount Paid</strong></td>
                            <td>&nbsp;</td>
                            <td><?php $q=$db->query("select sum(amtPaid) as amtPaid from ace_remitaorder where transApproved='True' and (regNo='$formNo' or regNo='$matNo')");
                                $amt_fetch=$q->fetch(PDO::FETCH_ASSOC); echo $amt=$amt_fetch['amtPaid'];?>
                                <input type="hidden" name="amt" id="amt" value=""<?php echo $amt;?>"" /></td>
                        </tr>
                        <tr>
                            <td><strong>New School</strong></td>
                            <td>&nbsp;</td>
                            <td><label for="select"></label>
                                <select name="txtschools" class="form-control" id="school">
                                    <?php

                                    $query="SELECT distinct dSchool FROM dept";
                                    $rs=$db->query($query);
                                    echo '<option>'.'Select Option...'.'</option>';
                                    while ($row=$rs->fetch(PDO::FETCH_BOTH)){
                                        //$row=mysql_fetch_row($rs);

                                        echo '<option>'.$row[0].'</option>';
                                    }
                                    ?>
                                </select></td>
                        </tr>
                        <tr>
                            <td><strong>New Department</strong></td>
                            <td>&nbsp;</td>
                            <td id="dept"><select name="dept" class="form-control" id="dept">
                                    <option>Select Option...</option>
                                </select></td>
                        </tr>
                        <tr>
                            <td><strong>Mode</strong></td>
                            <td>&nbsp;</td>
                            <td><select name="mode" class="form-control" id="mode">
                                    <option value="1" selected>DPT</option>
                                    <option value="2">RPT</option>
                                    <option value="3">NFT</option>
                                    <option value="4">HFT</option>
                                </select></td>
                        </tr>
                        <tr>
                            <td>&nbsp;</td>
                            <td>&nbsp;</td>
                            <td><input type="submit" name="button" id="button" value="Change Course" onclick="<script> alert('Are you sure');</script> "/></td>
                        </tr>

                    </table>
                    <?php
                    }else{
                        echo "Record Not Found or Not pay Acceptance Fees Yet";
                    }
                    ?>
                </fieldset>
            </form></td>
    </tr>
    <tr>
        <td>&nbsp;</td>
    </tr>
</table>
<!-- 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>