<?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");
//$today="Sun, 7 Jan 2024";//date("D, d M 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){
      mysqli_query($con,"INSERT INTO mycourses(courseid,studentid,enrolldate) VALUES('$courseid','$studentid','$tt')");
      
      $cd=mysqli_fetch_assoc(mysqli_query($con,"SELECT id, 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'"));
      $campusId = $std["campus"];
      $campus=mysqli_fetch_assoc(mysqli_query($con,"SELECT * FROM campuses WHERE id='$campusId'"));
      $campusName = $campus["campusname"];
      $lecturer = $campus["lecturer"];
      $fname=$std["name"];
      $email=$std["email"];
      $admno=$std["admno"];
      $link="https://www.elearning.bibu-edu.us/dashboard/";
      
      $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))
        ->setContentType('text/html; charset=utf-8')
        ->setBody(str_replace(array("{fullname}","{course}","{link}","{today}","{campus}","{professor_name}","{admno}","{period}"),array($fname,$coursename,$link,$today,$campusName,$lecturer,$admno,$courseperiod),$notif["body"]));
        $numSent = $mailer->send($message);
      
    echo json_encode(array('status' => '200','message' => 'SUCCESS'));
  }
  else{
    echo json_encode(array('status' => '300','message' => 'ERROR'));
   }
  }
  
if(isset($_POST["courseid1"])){
  extract($_POST);
  $tt=date("d-m-Y",strtotime($today));
  $today=date("D, d M Y",strtotime($today));
  $courseid=$courseid1;
  if(mysqli_num_rows(mysqli_query($con,"SELECT * FROM mycourses WHERE courseid='$courseid' AND studentid='$studentid'"))<1){
      mysqli_query($con,"INSERT INTO mycourses(courseid,studentid,enrolldate) VALUES('$courseid','$studentid','$tt')");
      
      $cd=mysqli_fetch_assoc(mysqli_query($con,"SELECT id, 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'"));
      $campusId = $std["campus"];
      $campus=mysqli_fetch_assoc(mysqli_query($con,"SELECT * FROM campuses WHERE id='$campusId'"));
      $campusName = $campus["campusname"];
      $lecturer = $campus["lecturer"];
      $fname=$std["name"];
      $email=$std["email"];
      $admno=$std["admno"];
      $link="https://www.elearning.bibu-edu.us/dashboard/";
      
      $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 Bible College & University'))
        ->setTo(array($email => $fname))
        ->setContentType('text/html; charset=utf-8')
        ->setBody(str_replace(array("{fullname}","{course}","{link}","{today}","{campus}","{professor_name}","{admno}","{period}"),array($fname,$coursename,$link,$today,$campusName,$lecturer,$admno,$courseperiod),$notif["body"]));
        $numSent = $mailer->send($message);
      
    echo json_encode(array('status' => '200','message' => 'SUCCESS'));
  }
  else{
    echo json_encode(array('status' => '300','message' => 'ERROR'));
   }
  }
  
      if(isset($_POST["enrollid"])){
          $id = trim(mysqli_real_escape_string($con, $_POST["enrollid"]));
          if(mysqli_query($con,"UPDATE mycourses SET status='1' WHERE id = '$id'")){
            echo json_encode(array('status' => '200','message' => 'SUCCESS'));
          }
          else{
            echo json_encode(array('status' => '300','message' => 'ERROR'));
           }
        }
        
        if(isset($_POST["completeid"])){
          $id = trim(mysqli_real_escape_string($con, $_POST["completeid"]));
          $date = trim(mysqli_real_escape_string($con, $_POST["completedate"]));
          if(mysqli_query($con,"UPDATE mycourses SET status='1',graddate='$date' WHERE id = '$id'")){
            echo json_encode(array('status' => '200','message' => 'SUCCESS'));
          }
          else{
            echo json_encode(array('status' => '300','message' => 'ERROR'));
           }
        }
        
        if(isset($_POST["courseid3"])){
          $id = trim(mysqli_real_escape_string($con, $_POST["courseid3"]));
          if(mysqli_query($con,"DELETE FROM mycourses WHERE id = '$id'")){
            echo json_encode(array('status' => '200','message' => 'SUCCESS'));
          }
          else{
            echo json_encode(array('status' => '300','message' => 'ERROR'));
           }
        }
  
?>
<?php mysqli_close($con) ?>