<?php
/**
 * Created by PhpStorm.
 * User: adisa
 * Date: 01/29/2024
 * Time: 23:42
 */
$ss=$db->query("select * from realdata where usernamea='$usern'")->rowCount();
if ($ss==0) {
    $dbC = db_con_connect();
    $bb = "select * from stdprofile where stdid='$usern'";
    $dbCkT = $dbC->query($bb)->rowCount();
//            echo "am here a";
//           echo $countC = $dbC->query($bb)->rowCount().'hhh';
//            echo "oooooo";
//            echo $dbCk;
//            die();
    if ($dbCkT == 1) {
        $dbCk = $dbC->query($bb);
        $d_fetch = $dbCk->fetch(PDO::FETCH_BOTH);
        $formNo = $d_fetch['applicantID'];
        $matNo = $d_fetch['matricno'];
        $names = $d_fetch['names'];
        $course = $d_fetch['Dept'];
        $levelID = $d_fetch['level'];
        $prog_type = $d_fetch['prog_type'];
        $mode = $d_fetch['entrymode'];
        if ($mode == 'FT') {
            if (($levelID == 'I') and ($prog_type == 'ND')) {
                $levelID = 1;
            }
            if (($levelID == 'II') and ($prog_type == 'ND')) {
                $levelID = 2;
            }
            if (($levelID == 'I') and ($prog_type == 'HND')) {
                $levelID = 3;
            }
            if (($levelID == 'II') and ($prog_type == 'HND')) {
                $levelID = 4;
            }
        }
        if ($mode == 'DPT') {
            if (($levelID == 'I') and ($prog_type == 'ND')) {
                $levelID = 8;
            }
            if (($levelID == 'II') and ($prog_type == 'ND')) {
                $levelID = 9;
            }
            if (($levelID == 'I') and ($prog_type == 'HND')) {
                $levelID = 11;
            }
            if (($levelID == 'II') and ($prog_type == 'HND')) {
                $levelID = 12;
            }
        }
        if ($mode == 'PT') {
            if (($levelID == 'I') and ($prog_type == 'ND')) {
                $levelID = 5;
            }
            if (($levelID == 'II') and ($prog_type == 'ND')) {
                $levelID = 6;
            }
            if (($levelID == 'III') and ($prog_type == 'ND')) {
                $levelID = 7;
            }
        }
        $class = '';

        $state1 = explode('_', $d_fetch['stateOfOrigin']);
        $state = $state1[0];
        $lga = $state1[1];
        $dob = $d_fetch['dob'];
        $gsm = $d_fetch['Phone'];
        $sex = $d_fetch['sex'];
        $address = $d_fetch['ContAddress'];
        $email = $d_fetch['email'];
        $gNames = $d_fetch['next_name'];
        $gGsm = $d_fetch['next_phone'];
        $gAddress = $d_fetch['next_addr'];
        $homeTown = '';
        $usernamea = $d_fetch['stdid'];
        $bab = $dbC->query("select password from logindetails where username='$usernamea'");
        $dbC_count = $bab->rowCount();
        if ($dbC_count == 1) {
            $dbC_fetch = $bab->fetch(PDO::FETCH_BOTH);
            $passworda = $dbC_fetch['password'];
        } else {
            $passworda = $usernamea;
        }
//                $passworda = $d_fetch['password'];
        $fresher = 9;
        $status = '';
        $coursechanged = '';
        $graduated = '';
        $acceptance = 0;
        $summerStatus = 0;
        $otherFee = 0;
        $late = 0;
        $jambNo = $d_fetch['jambno'];
        $activeStatus = '';
        $dateupdtae = date('Y-m-d H:i:s');;
        $maxCourse = 0;

        echo $aspoa = "INSERT INTO realdata (`sn`, `formNo`, `matNo`, `names`, `course`, `levelID`, `class`, `mode`, `state`, `lga`, `dob`, `gsm`, `sex`, `address`, `email`, `gNames`, `gGSM`, `gAddress`, `homeTown`, `usernamea`, `passworda`, `fresher`, `status`, `courseChanged`, `graduated`, `acceptance`, `summerStatus`, `otherFees`, `late`, `jambNo`, `activeStudent`, `dateupdate`, `maxCourse`)
VALUES ('', '$formNo', '$matNo', '$names', '$course', '$levelID', '$class', '$mode', '$state', '$lga', '$dob', '$gsm', '$sex', '$address', '$email', '$gNames', '$gGsm', '$gAddress', '$homeTown', '$usernamea', '$passworda', '$fresher', '$status', '$courseChanged', '$graduated', '$acceptance', '$summerStatus', '$otherFees', '$late', '$jambNo', '$activeStudent', '$dateupdate', '$maxCourse')";

//die();
        $db->query($aspoa);
    } else {
        header('location:login_Consult.php?id=1');
    }
}
?>