<?php
extract($_POST);
switch ($mode) {

    case 1:
        $mode = 'DPT';
        $mode_value='8';
        $code='02';
        break;
    case 2:
        $mode = 'RPT';
        $mode_value='5';
        $code='03';
        break;
    case 3:
        $mode = 'NFT';
        $mode_value='1';
        $code='01';
        break;
    case 4:
        $mode = 'HFT';
        $mode_value='3';
        $code='01';
        break;
    case 5:
        $mode = 'HDPT';
        $mode_value='11';
        $code='02';
        break;
}


require('../connect.php');
$db=db_connect();

echo $sql_dept="select * from dept where sn='$dept'";
$result_dept=$db->query($sql_dept) or die("No Department selected");
if ($result_dept->rowCount()>0){
    $result_dept_fetch=$result_dept->fetch(PDO::FETCH_ASSOC);
    echo ' <br> Course: ';
    echo $courseNew=$result_dept_fetch['dOption'];
    echo ' <br> Suffix: ';
    if (($mode_value==3) or ($mode_value==11)){
        echo $suffix=trim($result_dept_fetch['hnd']);
    }else{
        echo $suffix=trim($result_dept_fetch['nd']);
    }

    echo ' <br> Year: ';
    echo $year=substr($matNo,2,4);
    echo ' <br> Program Mode: ';
    echo $newMatNoForm=substr($matNo,6,2);
    echo ' <br> MatForm: ';
    echo $newMatNoForm=substr($matNo,8,5);
    echo ' <br> Prefix: ';

    echo $prefix=substr($matNo,11,3);
    echo ' <br> Change from: ';
    $level=$levelID;
    echo $courseC=$course.'('.$old_mode.'-'.$level.')';
    echo ' <br> LevelID: ';


    echo $levelID=$levelID;
    echo ' <br> New Matric No : ';
    echo $newMatNo=$suffix.$year.$code.$newMatNoForm;
    echo '<br>';

  if(strtoupper($matNo)==strtoupper($formNo)){
        $db->query("UPDATE realdata set course='$courseNew',courseChanged='$courseC',matNo='$newMatNo',levelID='$mode_value',mode='$mode',passworda='$newMatNo',usernamea='$newMatNo' where matNo='$matNo'");
      $db->query("UPDATE remitaorder set regNo='$newMatNo' where regNo='$matNo'");
       // $db->query("UPDATE admitted set course='$courseNew',levelID='$mode_value',mode='$mode' where formNo='$formNo'");
        echo "Programme changed From ".$course." to ".$courseNew."(".$mode_value.") Successfully";
    }else{
        echo 'Mat No: '.$matNo .'<br>';
        echo 'Form No:'.$formNo;
        }
}else{
    echo "No Department Selected";
}
?>