<?php
ob_start();
include('headMain_ord.php');
require_once('../connect.php');
$db=db_connect();
if (isset($_GET['id'])){
    $transID=$_GET['id'];
    $sql=$db->query("select * from entrancetable where transID='$transID'");
    $sql_fetch=$sql->fetch(PDO::FETCH_BOTH);
    $surname=$sql_fetch['surname'];
    $othername=$sql_fetch['othernames'];
      $formNo=$sql_fetch['formNo'];
        $formType=$sql_fetch['formType'];
    if ($formNo==''){
        $formNo=$sql_fetch['transID'];
    }

    $deptID=$sql_fetch['dept'];
    $sql_dept=$db->query("select * from dept where sn='$deptID'");
    $sql_dept_fetch=$sql_dept->fetch(PDO::FETCH_BOTH);
     $sql_dept_fetch['dOption'];

}else{
    header('location:'.'accountInfo.php');
}
?>

    <div class="row">
        <div class="col-lg-1"></div>
        <div class="col-lg-10">
            <div class="panel panel-default">
                <div class="panel-heading">
                   <h3> Change Details (<?php echo $transID ;?>)</h3>
                </div>
                <div class="panel-body">

                    <div class="row">
                        <div class="col-lg-12">


              <table width="100%" align="center" cellpadding="3" cellspacing="5">
                <tr>
                  <td><fieldset>
                    <form id="form1" role="form" name="form1" method="POST" action="changeDetails_process.php">
                      <table width="100%" cellspacing="5" cellpadding="3">


                        <tr>
                          <td><strong>Application No/Form No.</strong></td>
                          <td>&nbsp;</td>
                          <td bgcolor="#FFFFFF" id="kkk" ><em><strong><?php echo $formNo; ?></strong></em></td>
                            <input type="hidden" name="formNo" value="<?php echo $formNo ;?>">
                        </tr>
                          <tr>
                              <td><strong>Name</strong></td>
                              <td>&nbsp;</td>
                              <td bgcolor="#FFFFFF" id="kkk" ><em><strong><?php echo $surname.' '.$othername; ?></strong></em></td>
                          </tr>
                          <tr>
                              <td><strong>Previous Department</strong></td>
                              <td>&nbsp;</td>
                              <td bgcolor="#FFFFFF" id="kkk" ><em><strong><?php echo  $sql_dept_fetch['dOption']; ?></strong></em></td>
                          </tr>
                          <tr>
                              <td><strong>Change Department to:</strong></td>
                              <td>&nbsp;</td>
                              <td>
                                 <?php

                                  $query="SELECT * FROM dept where ".$formType."=1";
                                  $rs=$db->query($query);
                                  $out='<select name="dept" id="dept1" class="form-control">';
                                      while ($row=$rs->fetch(PDO::FETCH_BOTH)) {
                                         // if($formType)
                                      //$row=mysql_fetch_row($rs);
                                      $out.='<option value="'.$row[0].'">'.$row[3].'</option>';
                                      }
                                     echo $out.='</select>';
?>
                              </td>
                          </tr>
                        <tr>

                          <td><p><br>&nbsp;</td>
                          <td bgcolor="#FFFFFF">&nbsp;</td>
                            <td><input type="submit" class="btn btn-primary" value="Change Department" ></td>
                          <td>&nbsp;</td>
                        </tr>

                        </table>
                      </form>
                    </fieldset></td>
                  </tr>
              </table>

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

                                <div class="col-lg-1"></div>
<?php
include('footMain.php');
ob_end_flush();
?>