<?php
/**
 * Created by PhpStorm.
 * User: adisa
 * Date: 03/01/2023
 * Time: 10:03
 */
require('../connect.php');
$db =db_connect();
$sola="select * from current";
$sola_exe=$db->query($sola);
if ($sola_exe->rowCount()==1){
    $sola_exe_fetch=$sola_exe->fetch(PDO::FETCH_BOTH);
    $asession=$sola_exe_fetch['asession'];
    $semester=$sola_exe_fetch['asemester'];
}
function new_students($matNo,$levelID,$course,$semester,$asession){
//    require('../connect.php');
    $db =db_connect();
    $sql="select * from coursepool where dept='$course' and levelID='$levelID' and semester='$semester'";
    $sql_exe=$db->query($sql);
    $db->query("DELETE FROM coursereg where matNo='$matNo'");
    while ($row=$sql_exe->fetch(PDO::FETCH_BOTH)){
//        $courseC', '$courseT', '$courseU', '$semester', '$asession', '$levelID
        $matNo=$matNo;
        $courseC=$row['courseCode'];
        $courseT=$row['courseTitle'];
        $courseU=$row['courseUnit'];
        $semester=$row['semester'];
        $sql_in=$db->query("INSERT INTO `fedpoly`.`coursereg` (`sn`, `matNo`, `courseCode`, `courseTitle`, `courseUnit`, `semester`, `asession`, `levelID`) VALUES (NULL, '$matNo', '$courseC', '$courseT', '$courseU', '$semester', '$asession', '$levelID')");
//        echo "INSERT INTO `fedpoly`.`coursereg` (`sn`, `matNo`, `courseCode`, `courseTitle`, `courseUnit`, `semester`, `asession`, `levelID`) VALUES (NULL, '$matNo', '$courseC', '$courseT', '$courseU', '$semester', '$asession', '$levelID')";
    }
}
$sql_biodata="select * from vw_biodata_current where matNo not in (select matNo from courseReg)";
$sql_biodata_exe=$db->query($sql_biodata);
while ($row_b=$sql_biodata_exe->fetch(PDO::FETCH_BOTH)){
    $levelID=$levelID_here=$row_b['levelID'];
    $matNo_here=$row_b['matNo'];
    $course_here=$row_b['course'];



//    $semester='First Semester';
//    $asession='2021/2022';
    if (($levelID==1) or ($levelID==3) or ($levelID==5) or ($levelID==8) or ($levelID==11)){
        new_students($matNo_here,$levelID_here,$course_here,$semester,$asession);
    }
}
?>