<?php
/**
 * Created by PhpStorm.
 * User: adisa
 * Date: 03/19/2024
 * Time: 23:32
 */
require_once('../connect.php');
$dbC = db_con_connect();
$db=db_connect();
extract($_POST);
$matNo=$matNo;
if (isset($matNo)){
    $sql=$db->query("select * from realdata where matNo='$matNo'");
    $sql_count=$sql->rowCount();
    if ($sql_count==1) {
        $real_fetch = $sql->fetch(PDO::FETCH_BOTH);
        $names = $real_fetch['names'];
        $namesS=explode(' ',$names);
        $lname=$namesS[0];
        $fname=$namesS[1];
        $mname=$namesS[2];

        $email = $real_fetch['email'];
        $gsm = $real_fetch['gsm'];
        $dept = $real_fetch['course'];
        $levelID = $real_fetch['levelID'];

//        `level`, `entrymode`, `prog_type`,
        if ($levelID=='1') {
            $level = 'I';
            $entrymode = 'FT';
            $prog_type = 'ND';
        }
        if ($levelID=='2') {
            $level = 'II';
            $entrymode = 'FT';
            $prog_type = 'ND';
        }
        if ($levelID=='3') {
            $level = 'I';
            $entrymode = 'FT';
            $prog_type = 'HND';
        }
        if ($levelID=='4') {
            $level = 'II';
            $entrymode = 'FT';
            $prog_type = 'HND';
        }
        if ($levelID=='7') {
            $level = 'III';
            $entrymode = 'PT';
            $prog_type = 'ND';
        }
        if ($levelID=='8') {
            $level = 'I';
            $entrymode = 'DPT';
            $prog_type = 'ND';
        }
        if ($levelID=='9') {
            $level = 'II';
            $entrymode = 'DPT';
            $prog_type = 'ND';
        }
        if ($levelID=='11') {
            $level = 'I';
            $entrymode = 'DPT';
            $prog_type = 'HND';
        }
        if ($levelID=='12') {
            $level = 'II';
            $entrymode = 'DPT';
            $prog_type = 'HND';
        }



     echo   $sql_a = "INSERT INTO `logindetails` ( `username`, `password`, `passcode`, `applicantID`, `applicantEmail`, `names`, `mode`) VALUES
        ( '$matNo', '12345', '$2y$04$zNRigK21QGI8FbzQkjPRI.is32pgaFfmmV7/e8UjWyRc0MDAsTDYC', '$matNo', '$email', '$names', 'FR20')";


       echo $sql_b = "INSERT INTO `stdprofile` ( `applicantID`, `Jambno`, `stdid`, `matricno`, `names`, `surname`, `firstname`, `othername`, `PermtAddress`, `ContAddress`, `Nationality`, `stateOfOrigin`, `lga`, `dob`, `sex`, `SchCode`, `School`, `Deptcode`, `Dept`, `opt`, `level`, `entrymode`, `prog_type`, `email`, `ids`, `facebook`, `maritalStatus`, `Phone`, `PlaceBirth`, `defer1styear`, `religion`, `next_name`, `next_rel`, `next_addr`, `next_phone`, `next_email`, `blood_group`, `entry_session`, `current_session`, `status`, `clrOfficer`, `clrdate`) VALUES
        ('$matNo', '$matNo', '$matNo', '$matNo', '$names', '$namesS[0]', '$namesS[1]', '$namesS[2]', ' ', ' ', ' ', ' ', ' ', '  ', 'Male', 'BUS', ' ', '$deptCode', '$dept', '', '$level', '$entrymode', '$prog_type', '$email', 0, ' ', ' ', '$gsm', ' ', ' ', ' ', ' ', '  ', ' ', ' ', ' ', ' ', '2022/2023', '2024/2025', 'Perceived Graduated', ' ', ' ')";

       echo $sql_c = "INSERT INTO `stdstatus` ( `stdid`, `studentship`, `exStdCheck`, `ndRegNo`, `level`, `finstatus`, `acadstatus`, `acadsession`) VALUES
        ( '$matNo', 'Stalite', ' ', '  ', 'II', 'pending', 'IGS', '2024/2025')";

       $a= $dbC->query($sql_a);
       $b= $dbC->query($sql_b);
       $c= $dbC->query($sql_c);
        if ($c){
            $db->query("UPDATE realdata SET graduated='' where matNo='$matNo'");
        }

        if ($a) echo "logindetails Updated";
        if ($b) echo "stdprofile Updated";
        if ($c) echo "stdstatus Updated";


    } else{
        echo "No record Found";
    }
}else{
    echo "Enter Matriculation Number to Reactivate";
}