<?php
//session_start();
require_once("../connect.php");
$db=db_connect();
extract($_POST);
//die($userN);
//$matNo=strtoupper($userN);
echo $aspoa="select * from realdata where matNo in (select matNo from coursereg where courseCode='$rs_courseCode' and levelID='$rs_levelID' and semester='$rs_semester') and course='$rs_dept'";
$aspoa=$db->query($aspoa);
 $aspoa_count=$aspoa->rowCount();
//die();
// support functions
require('../PHPMailer/src/PHPMailer.php');
require('../PHPMailer/src/SMTP.php');
require('../PHPMailer/src/Exception.php');

$mail = new PHPMailer\PHPMailer\PHPMailer();
//
//

function SendSMTPLoginMail($email, $username, $lecturer,$courseCode,$type) {
    $mailmsg = "<strong><u>Details</u></strong><BR>";
    $mailmsg .= "<p>Dear $username,</p>This is to inform you that a file has been uploaded to your Student Portal. Kindly login to check your eClass Menu and do the needful.<br>";
    $mailmsg .= "<br>Lecturer: $lecturer";
    $mailmsg .= "<br>Course Code: $courseCode";
    $mailmsg .= "<br>Type: $type";
    $mailmsg .= "<br><br>Thanks you.";
    //
    $reply = SMTPSendMail($email, $mailmsg);
    return $reply;
}
//

function SMTPSendMail($email, $mailmsg)
{
    //Create a new PHPMailer instance
    global $mail;
    //Tell PHPMailer to use SMTP
    $mail->isSMTP();
    $mail->Host = 'mail.federalpolyede.edu.ng';
    //Set the SMTP port number - likely to be 25, 465 or 587
    $mail->Port = 25;
    //Whether to use SMTP authentication
    $mail->SMTPAuth = true;
    // Set email format to HTML
    $mail->isHTML(true);
    //Username to use for SMTP authentication
    $mail->Username = '[email protected]';
    //Password to use for SMTP authentication
    $mail->Password = 'Ku~8h1m9';
    //Set who the message is to be sent from
    $mail->setFrom('[email protected]', 'ICT Tech Support');
    //Set who the message is to be sent to
    $mail->addAddress($email, 'User Feedback');
    //Set the subject line
    $mail->Subject = 'FPE-eClassRoom Notification';
    //Read an HTML message body from an external file, convert referenced images to embedded,
    //convert HTML into a basic plain-text alternative body
    $mail->msgHTML($mailmsg);
    //Replace the plain text body with one created manually
    $retvalue = "";


    if (!$mail->send())
//            echo "am here";
        $retvalue = 'Mailer Error: ' . $mail->ErrorInfo;
    else

        $retvalue = "OK";
    //
    return $retvalue;
}
//
//$_SESSION['sendMailID']=1;
//echo $aspoa_count.'ugig';
//die();
if ($aspoa_count>0) {
//die('fere');
//    $aspoa_fetch = $aspoa->fetch(PDO::FETCH_BOTH);

    while ($row=$aspoa->fetch(PDO::FETCH_BOTH)) {
       echo $email = $row['email'];
//        die();
//   echo $email = '[email protected]';
         $names = $row['names'];
         $password = $row['passworda'];
        $atNo = $row['matNo'];
//die();
        SendSMTPLoginMail($email, $names, $lecturer, $courseCode, $type);
//echo "here";
    }
//    die('here');
    header('location:login.php?sendMailID=1');

} else {
    header('location:login.php?sendMailID=2');
}

?>