<?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'));
           }
        }
        
        
//send email

if(isset($_POST["campuside"])){
  extract($_POST);
 
  $query=mysqli_query($con,"SELECT mycourses.*,courses.title,students.admno,students.name,students.email,campuses.campusname FROM mycourses, courses,students,campuses WHERE mycourses.courseid=courses.id AND mycourses.studentid=students.id AND students.campus=campuses.id AND campuses.id='$campuside' ORDER BY mycourses.id DESC");
  if(mysqli_num_rows($query)>0){
        
        $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']))
               // ->setTo(array('washiwaweru@gmail.com' => $assoc['name']))
                ->setContentType('text/html; charset=utf-8')
                ->setEncoder(Swift_Encoding::get8BitEncoding())
                ->setBody($email_body);
                
            // Check if file was uploaded and is a valid uploaded file
            if (isset($_FILES['attachment'])) {
                $uploadedFilePath = $_FILES['attachment']['tmp_name'];
                $originalFileName = $_FILES['attachment']['name'];
            
                // Create the attachment
                $attachment = Swift_Attachment::fromPath($uploadedFilePath)
                    ->setFilename($originalFileName);
            
                // Attach the file to the message
                $message->attach($attachment);
            }
        
            $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) ?>