<?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");


//lecturer
if(isset($_POST["lecturerid"])){
  $id = trim(mysqli_real_escape_string($con, $_POST["lecturerid"]));
  if(mysqli_query($con,"UPDATE lecturers SET status='1' WHERE id = '$id'")){
      
      $lecdetails=mysqli_fetch_assoc(mysqli_query($con,"SELECT * FROM lecturers WHERE id='$id'"));
      $name=$lecdetails["fullname"];
      $email=$lecdetails["email"];
      
      $link = "https://www.elearning.bibu-edu.us/staff-login";
   $notif = mysqli_fetch_assoc(mysqli_query($con,"SELECT * FROM notification_templates WHERE id='9'"));
      
      $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 => $name))
        ->setContentType('text/html; charset=utf-8')
        ->setBody(str_replace(array("{name}","{account}","{email}","{password}","{link}"),array($name,"1",$email,"",$link),$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["lecturerid2"])){
  $id = trim(mysqli_real_escape_string($con, $_POST["lecturerid2"]));
  if(mysqli_query($con,"UPDATE lecturers SET status='0' WHERE id = '$id'")){
    echo json_encode(array('status' => '200','message' => 'SUCCESS'));
  }
  else{
    echo json_encode(array('status' => '300','message' => 'ERROR'));
   }
  }
  
  if(isset($_POST["lecturerid3"])){
  $id = trim(mysqli_real_escape_string($con, $_POST["lecturerid3"]));
  if(mysqli_query($con,"DELETE FROM lecturers WHERE id = '$id'")){
    echo json_encode(array('status' => '200','message' => 'SUCCESS'));
  }
  else{
    echo json_encode(array('status' => '300','message' => 'ERROR'));
   }
  }
  
    if(isset($_POST["lecid2"])){
        extract($_POST);
  $id = trim(mysqli_real_escape_string($con, $_POST["lecid2"]));
 //$leccourse = implode(',', $leccourse);
 $query=mysqli_query($con,"SELECT assignedcourses FROM lecturers WHERE id = '$id'");
     $currentcourse=mysqli_fetch_assoc($query)["assignedcourses"];
     if($currentcourse!=""){
         $currentcourse=$currentcourse.",".$leccourse;
     }else{
      $currentcourse = $leccourse;    
     }
 $upq="UPDATE lecturers SET assignedcourses='$currentcourse' WHERE id = '$id'";
  if(mysqli_query($con,$upq)){
    echo json_encode(array('status' => '200','message' => 'SUCCESS'));
  }
  else{
    echo json_encode(array('status' => '300','message' => 'ERROR'));
   }
  }
  
  
?>
<?php mysqli_close($con) ?>