<?php
include_once('../../includes/db_connect.php'); 
include_once "../../includes/swiftmailer/swift_required.php";
header("Content-Type:application/json");
$date = date("Y-m-d H:i:s");
$year = date("Y");




if(isset($_POST["courseid"])){
  extract($_POST);
  $tt=date("d-m-Y",strtotime($today));
  $today=date("D, d M Y",strtotime($today));
  
  if(mysqli_num_rows(mysqli_query($con,"SELECT * FROM mycourses WHERE courseid='$courseid' AND studentid='$studentid'"))<1){
      
      $cd=mysqli_fetch_assoc(mysqli_query($con,"SELECT title,hours FROM courses WHERE id='$courseid'"));
      $coursename=$cd["title"];
      $courseperiod=$cd["hours"];
      
      $std=mysqli_fetch_assoc(mysqli_query($con,"SELECT name,email,admno,campus FROM students WHERE id='$studentid'"));
      $fname=$std["name"];
      $email=$std["email"];
      $admno=$std["admno"];
      $campus=$std["campus"];
      $link="https://www.elearning.bibu-edu.us/dashboard/";
      
      $campus=mysqli_fetch_assoc(mysqli_query($con,"SELECT campusname,lecturer FROM campuses WHERE id='$campus'"));
      $campusname=$campus["campusname"];
      $lecturer=$campus["lecturer"];
      
      $notif = mysqli_fetch_assoc(mysqli_query($con,"SELECT * FROM notification_templates WHERE id='12'"));
      $transport = Swift_SmtpTransport::newInstance('bibu-edu.us', 465, "ssl")
        ->setUsername('notification@bibu-edu.us')
        ->setPassword('@notif2019!');
        
        $mailer = Swift_Mailer::newInstance($transport);
        $message = Swift_Message::newInstance($notif["subject"])
        ->setFrom(array('notification@bibu-edu.us' => 'Breakthrough Open University'))
        ->setTo(array($email => $fname,'Patnju4@gmail.com'=>'admin'))
        ->setContentType('text/html; charset=utf-8')
        ->setBody(str_replace(array("{fullname}","{course}","{link}","{today}","{admno}","{period}","{campus}", "{professor_name}"),array($fname,$coursename,$link,$today,$admno,$courseperiod,$campusname,$lecturer),$notif["body"]));
        $numSent = $mailer->send($message);
      
      mysqli_query($con,"INSERT INTO mycourses(courseid,studentid,enrolldate) VALUES('$courseid','$studentid','$tt')");
    echo json_encode(array('status' => '200','message' => 'SUCCESS'));
  }
  else{
    echo json_encode(array('status' => '300','message' => 'ERROR'));
   }
  }
  
//send email

if(isset($_POST["courseide"])){
  extract($_POST);
 
  $query=mysqli_query($con,"SELECT mycourses.*,students.id AS stdid,students.admno,students.name,students.icon,students.phone,students.email FROM mycourses, students WHERE mycourses.courseid='$courseide' AND mycourses.studentid=students.id");
  if(mysqli_num_rows($query)>0){
      //$assoc=mysqli_fetch_assoc($query);
    //   $notif = mysqli_fetch_assoc(mysqli_query($con,"SELECT * FROM notification_templates WHERE id='14'"));
    //   while($assoc=mysqli_fetch_assoc($query)){
    //       $transport = Swift_SmtpTransport::newInstance('bibu-edu.us', 465, "ssl")
    //         ->setUsername('notification@bibu-edu.us')
    //         ->setPassword('@notif2019!');
    //         $mailer = Swift_Mailer::newInstance($transport);
    //         $message = Swift_Message::newInstance($title)
    //         ->setFrom(array('notification@bibu-edu.us' => 'BREAKTHROUGH INTERNATIONAL BIBLE COLLEGE & UNIVERSITY'))
        
    //         ->setTo(array($assoc['email'] => $assoc['name']))
    //         ->setContentType('text/html; charset=utf-8')
    //         ->setBody(str_replace(array("{message}"),array($message),$notif["body"]));
    //         $numSent = $mailer->send($message);
    //     }
    $notif = mysqli_fetch_assoc(mysqli_query($con, "SELECT * FROM notification_templates WHERE id='14'"));
        
        while ($assoc = mysqli_fetch_assoc($query)) {
            $transport = Swift_SmtpTransport::newInstance('bibu-edu.us', 465, "ssl")
                ->setUsername('notification@bibu-edu.us')
                ->setPassword('@notif2019!');
            
            $mailer = Swift_Mailer::newInstance($transport);
        
            $email_body = mb_convert_encoding($notif["body"], 'UTF-8', 'auto');
            $email_body = str_replace("{message}", $content, $email_body);
        
            $message = Swift_Message::newInstance($title)
                ->setFrom(['notification@bibu-edu.us' => 'BREAKTHROUGH INTERNATIONAL BIBLE COLLEGE & UNIVERSITY'])
                ->setTo(array($assoc['email'] => $assoc['name']))
                ->setContentType('text/html; charset=utf-8')
                ->setEncoder(Swift_Encoding::get8BitEncoding())
                ->setBody($email_body);
        
            $numSent = $mailer->send($message);
        }
      
   
    echo json_encode(array('status' => '200','message' => 'SUCCESS'));
  }
  else{
    echo json_encode(array('status' => '300','message' => 'ERROR'));
   }
  }
  
?>
<?php mysqli_close($con) ?>