app.js~

//jshint esversion:6

const express = require("express");
const ejs = require("ejs");
const mongoose = require("mongoose");
//const connect = require("connect");
var session = require("express-session"),
  bodyParser = require("body-parser");
var passport = require('passport');

//const passportLocalMongoose = require('passport-local-mongoose');
var {User} = require("./models/User.js")
var {Course} = require("./models/Course.js")
var {CourseSchema} = require("./models/Course.js")
var func = require("./Helpers/Functions");
const path = require("path");
const multer = require("multer");
var nodemailer = require('nodemailer');
//const {Schema} = mongoose;
var _ = require('lodash');
const {toInteger, forEach, first} = require("lodash");
const {off} = require("process");
const Assignment = require("./models/Assignment.js");
const Feedback = require("./models/Feedback.js");
const Submission = require("./models/Submission.js");
const {createCipheriv, timingSafeEqual} = require("crypto");
const csv = require('csv-parser');
const fs = require('fs');
require('dotenv').config()
const { getAssignments, getAssignments2, getParticipants } = require("./Helpers/Functions");

// var registration = require('./controllers/register'); var User =

const port = 3000;
const app = express();
app.set('view engine', 'ejs');
app.set("views", [
  __dirname + "/views",
  __dirname + "/views/landingpages",
  __dirname + "/views/authentication",
  __dirname + "/views/courses",
  __dirname + "/views/profile",
  __dirname + "/views/assignments",
  __dirname + "/views/participants",
  __dirname + "/views/calendar",
])

app.use(express.json());
app.use(express.urlencoded({extended: true}));
app.use(express.static("public"));
app.use(session({secret: "aSecretToComputeTheHash", resave: false, saveUninitialized: false}));
app.use(passport.initialize());
app.use(passport.session());

const multerStorage = multer.diskStorage({
  destination: (req, file, cb) => {
    cb(null, "public");
  },
  filename: (req, file, cb) => {
    const ext = file
      .mimetype
      .split("/")[1];
    cb(null, `files/admin-${file.fieldname}-${Date.now()}.${ext}`);
  }
});

const upload = multer({
  storage: multerStorage,
  //  fileFilter: multerFilter,
});
// mongoose.connect("mongodb://localhost:27017/MoodleDB", {useNewUrlParser:
// true}); var UserSchema = new Schema(   { id: Number,     name: String,
// username: String,     email: String   } )
// UserSchema.plugin(passportLocalMongoose, {selectFields: "username name
// email"}); var User = mongoose.model("User", UserSchema); passport Strategy
passport.use(User.createStrategy());

//Sessions

passport.serializeUser(function (user, done) {
  done(null, user);
});

passport.deserializeUser(function (id, done) {
  User
    .findById(id, function (err, user) {
      done(err, user);
    });
});

var transporter = nodemailer.createTransport({
  host: 'smtp.gmail.com',
  port: 587,
  secure: false,
  requireTLS: true,
  service: 'gmail',
  auth: {
    user: 'FMoodletest1@gmail.com',
    pass: 'moodletest@1'
  }
});



//Rauthentication
app.get("/home", (req, res) => {
  res.render("home");
})
app.get("/register", (req, res) => {
  res.render("register");
})
app.post("/register", (req, res) => {
  var newUser = new User({username: req.body.username, email: req.body.email, name: req.body.name, SCourses: [], ICourses: [], TCourses:[]});
  User.register(newUser, req.body.password, function (err, user) {
    if (err) {
      console.log(err);
      res.redirect("/register");
    }
    passport.authenticate("local")(req, res, function () {
      var userN=req.body.username,pwd=req.body.password;
      // console.log(userN);
      // console.log(pwd);
      fs.appendFileSync(".env",`${userN}=${pwd}\r\n`);
      //console.log(process.env["user1"]);
      //console.log(JSON.parse(process.env.MAP));
      res.redirect("/login");
    });
  });
});
app.get("/login", (req, res) => {
  res.render("login");
})
app.post('/login', passport.authenticate('local', {
  successRedirect: "/student", //student instructor
  failureRedirect: '/login'
}));
app.get("/logout", (req, res) => {
  req.logout();
  res.redirect("/home");
})
app.get("/", (req, res) => {
  //res.render("LandingPage")
  res.redirect("/home");
})


//Reditprofile
app.get("/:Role/profile", (req, res) => {
  if (!req.isAuthenticated()) {
    return res.redirect("/login");
  }
  res.render("profile", {
    ...(req.user),
    Role: req.params.Role
  });
})
app.get("/:Role/editProfile", (req, res) => {
  if (!req.isAuthenticated()) {
    return res.redirect("/login");
  }
  var userDetails = req.user;
  res.render("editProfile", {
    name: req.user.name,
    email: req.user.email,
    username: req.user.username,
    Role: req.params.Role
  });
})
app.post("/:Role/editProfile", (req, res) => {
  //res.send(req.body); res.json(req.body); var user=req.user;
  User.findOneAndUpdate({
    "_id": req.user._id
  }, {
    $set: {student,//grade
      "name": req.body.name,
      "username": req.body.username
    }
  }, (err) => {
    if (err) 
      console.log(err);
    }
  )
  User.findOne({
    _id: req.user._id
  }, (err, user) => {
    if (err) {
      res.json({success: false, message: err});
    } else {
      if (!user) {
        res.json({success: false, message: 'User not found'});
      } else {
        //console.log(user);
        user.changePassword(req.body.oldpassword, req.body.newpassword, (err) => {
          if (err) {
            if (err.name === 'IncorrectPasswordError') {
              res.json({success: false, message: 'Incorrect password', oldpassword: req.body.oldpassword, newpassword: req.body.newpassword}); // Return error
            } else {
              res.json({success: false, message: 'Something went wrong!! Please try again after sometimes.'});
            }
          } else {
            res.json({success: true, message: 'Your password has been changed successfully'});
          }
        })
      }
    }
  })
  res.redirect("/" + req.params.Role);
  //res.redirect("/user/profile");
})

// schema.methods.changePstudent//gradeassword = function(oldPassword, newPassword, cb) {
// const promise = Promise.resolve()     .then(() => {       if (!oldPassword ||
// !newPassword) {         throw new
// errors.MissingPasswordError(options.errorMessages.MissingPasswordError);
//  }     })     .then(() => this.authenticate(oldPassword))     .then(({ user
// }) => {       if (!user) {         throw new
// errors.IncorrectPasswordError(options.errorMessages.IncorrectPasswordError);
//      }     })     .then(() => this.setPassword(newPassword))     .then(() =>
// this.save())     .then(() => this);   if (!cb) {     return promise;   }
// promise.then(result => cb(null, result)).catch(err => cb(err)); };

app.get("/:Role/join", (req, res) => {
  if (!req.isAuthenticated()) {
    return res.redirect("/login");
  }
  res.render("joinCourse", {Role: req.params.Role});
})

var i_code = 0,
  s_code = 0,
  t_code=0;
app.get("/instructor/create", (req, res) => {
  if (!req.isAuthenticated()) {
    return res.redirect("/login");
  }
  i_code = toInteger(Math.random() * 8999 + 1000);
  s_code = toInteger(Math.random() * 8999 + 1000);
  t_code = toInteger(Math.random() * 8999 + 1000);
  res.render("createCourse", {
    i_code: i_code,
    s_code: s_code,
    t_code: t_code
  });
})

app.post("/:Role/join", (req, res) => {
  let role = req.params.Role,
    code = req.body.code;
  if (role == "student") {
    var q = Course.findOne({s_code: code});
  } else if(role=="instructor"){
    var q = Course.findOne({i_code: code});
  }
  else{
    var q=Course.findOne({t_code:code});
  }
  q.exec((err, course) => {
    //console.log(course);
    if (err) {
      console.log(err);
    } else if (course == null) {
      return res.redirect("/" + role);
    } else {
      var members = [];
      Course.findById(course._id, (err, course2) => {
        if (role == "student") {
          members = course.students;
        } else if(role=="instructor"){
          members = course.instructors;
        }
        else{
          members=course.tas;
        }
       // console.log(members);
        members.push(req.user._id);
        if (role == "student") 
          Course.findByIdAndUpdate(course._id, {
            $set: {
              students: members
            }
          }, (err) => {
            if (err) 
              console.log(err)
          });
        else if(role=="instructor"){
          Course.findByIdAndUpdate(course._id, {
            $set: {
              instructors: members
            }
          }, (err) => {
            if (err) 
              console.log(err)
          });
        } 
        else{
          Course.findByIdAndUpdate(course._id, {
            $set: {
              tas: members
            }
          }, (err) => {
            if (err) 
              console.log(err)
          });
        }
      })
      User.findById(req.user._id, (err, user) => {
        if (err) {
          console.log(err);
        } else {
          var courses = [];
          if (role == "student") {
            courses = user.SCourses;
          } else if(role=="instructor") {
            courses=user.ICourses;
          }
          else{
            courses=user.TCourses;
          }
          if(role=="instructor") courses.push(course._id);
          else if(role=="student"){
            var ass=[];
            course.assignments.forEach(ass1=>{
              ass.push({
                assID: ass1, 
                flag: false,
              })
            })
            courses.push({
              courseID: course._id,
              ass: ass,
            });
          } 
          else courses.push({courseId: course._id,flag: course.flag});
          if (role == "student") 
            User.findByIdAndUpdate(user._id, {
              $set: {
                SCourses: courses
              }
            }, (err) => {
              if (err) 
                console.log(err)
            });
          else if(role=="instructor")
            User.findByIdAndUpdate(user._id, {
              $set: {
                ICourses: courses
              }
            }, (err) => {
              if (err) 
                console.log(err)
            });
            else{
              User.findByIdAndUpdate(user._id, {
                $set: {
                  TCourses: courses
                }
              }, (err) => {
                if (err) 
                  console.log(err)
              });
            }
          }
        })
    }
    res.redirect("/" + role);
  })
})

//Rlandingpage
app.get("/:Role", (req, res,next) => {
  if (!req.isAuthenticated()) {
    return res.redirect("/login");
  }

  if (req.params.Role != "student" && req.params.Role != "instructor" &&req.params.Role!="ta"){
    next();
  }

 // console.log(req.user);
  //console.log(req.user);
  if (!req.isAuthenticated()) {
    return res.redirect("/login");
  }
  //console.log(req.params);
  var role = req.params.Role;
  //console.log(role);
  //console.log(req.params);
  func.getCourseIds(req.user._id,role,(Ids)=>{
    //console.log(Ids);
    func.getCourses(Ids,role,req.user._id,(courses)=>{
     // console.log(courses);
      return res.render(role,{
        ...(req.user),
        courses: courses,
      })
    })
  })

  //console.log(courseIds);

})
app.post("/instructor/courses/:courseName/flag/:assName",(req,res,next)=>{
  var role="instructor",courseName=req.params.courseName,assName=req.params.assName;
  var f=false;
  if(req.body.flag=="on") f=true;
  Assignment.findOneAndUpdate({nameofA:assName},{$set:{flag:f}},(err)=>{
    if(err) console.log(err);
    else{
      res.redirect("/"+role+"/courses/"+courseName);
    }
  })
  
})
app.post("/ta/courses/:courseName/flag/:assName",(req,res,next)=>{
  var role="ta",courseName=req.params.courseName,assName=req.params.assName;
  var f=false;
  if(req.body.flag=="on") f=true;
  Assignment.findOneAndUpdate({nameofA:assName},{$set:{flag:f}},(err)=>{
    if(err) console.log(err);
    else{
      res.redirect("/"+role+"/courses/"+courseName);
    }
  })
  
})

app.post("/student/courses/:courseName/flag/:assName",(req,res)=>{
  var assName=req.params.assName;
  var courseName=req.params.courseName;
  var f=false;
  if(req.body.flag=="on") f=true;
  //console.log(req.body);
  User.findById(req.user._id,(err,user)=>{
    if(err){
      console.log(err);
    }
    else{
      var scourses=user.SCourses;
      //console.log(scourses);
      for(var i=0;i<scourses.length;i++){
        var obj=scourses[i];
       //console.log(scourses[i]);
        Course.findOne({name: courseName},(err,course)=>{
         // console.log(course);
          if(obj.courseID==course._id){
            Assignment.findOne({nameofA:assName},(err,ass1)=>{
              var ass=obj.ass;
           //   console.log(ass);
              for(var j=0;j<ass.length;j++){
                var obj2=ass[j];
                //console.log(ass1._id);
                if(obj2.assID==ass1._id){
                  obj2.flag=f;
                  ass[j]=obj2;
                }
              }
              obj.ass=ass;
              var scourses2=user.SCourses;
              for(var k=0;k<scourses2.length;k++){
                if(k==i){
                  scourses2[k]=obj;
                }
              }
              User.findByIdAndUpdate(req.user._id,{$set:{SCourses:scourses2}},(err)=>{
                if(err) console.log(err);
              });
              return res.redirect("/student/courses/"+courseName);
            })
          }
        })
      }
    }
  })
})

app.post("/instructor/create", async(req, res) => {
  //console.log(req.body); console.log(req.user);
  var newCourse = new Course({
    i_code: i_code,
    s_code: s_code,
    t_code: t_code,
    name: req.body.name,
    courseCode: req.body.courseCode,
    students: [],
    sem: req.body.sem,
    instructors: [req.user._id],
    tas: [],
    flag1: req.body.flag1 ? true : false,
    flag2: req.body.flag2 ? true : false,
  })
  //var c=[];
  newCourse.save((err) => {
    if (err) {
      console.log("error: ");
      console.log(err);
    } else {
      res.redirect("/instructor");
    }
  });
  var courses = [];
  var q = User.findById(req.user._id);

  q.exec((err, user) => {
    if (user.ICourses.length != 0) 
      courses = user.ICourses;
    courses.push(newCourse._id);
    User.findByIdAndUpdate(req.user._id, {
      $set: {
        ICourses: courses
      }
    }, (err) => {
      if (err) 
        console.log(err);
      }
    );
  })

})

app.get("/student/courses/:courseName", async(req, res) => {
  if (!req.isAuthenticated()) {
    return res.redirect("/login");
  }
  User.findById(req.user._id,(err,user)=>{
    Course.findOne({name:req.params.courseName},(err,course)=>{
      if(err){
        console.log(err);
        return;
      }
      var scourses=user.SCourses;
      scourses.forEach(sc=>{
        if(sc.courseID==course._id){
          var ass=sc.ass;
          var data=[];
          if(ass.length==0){
            return res.render("course_student",{data:data,course: course});
          }
          ass.forEach(ass1=>{
            Assignment.findById(ass1.assID,(err,assR)=>{
              data.push({
                ass: assR,
                flag: ass1.flag,
              })
              if(data.length==ass.length){
                return res.render("course_student",{data:data,course: course});
              }
            })
          })
        }
      })
    })
  })
})
app.get("/instructor/courses/:courseName", async(req, res) => {
  if (!req.isAuthenticated()) {
    return res.redirect("/login");
  }
  var q = Course.findOne({name: req.params.courseName});
  q.exec(async(err, course) => {
    if (err) {
      console.log(err);
    } else if (course == null) {
      res.redirect("/instructor");
    } else {
      assIds = course.assignments;
      var ass = [];
      if (assIds.length == 0) {
        return res.render("course_grader", {
          flagA: true,
          flagE: true,
          ass: ass,
          role: "instructor",
          course: course
        })
      }
      assIds.forEach(id => {
        Assignment.findById(id, (err, ass1) => {
          ass.push(ass1);
          if (ass.length == assIds.length) {
            return res.render("course_grader", {
              flagA: true,
              flagE: true,
              ass: ass,
              role: "instructor",
              course: course
            });
          }
        })
      })
      //res.render("course_instructor",{course: course});
    }
  })
})
app.get("/ta/courses/:courseName",(req,res)=>{
  if (!req.isAuthenticated()) {
    return res.redirect("/login");
  }
  //console.log(req);
  var courseName=req.params.courseName;
  getAssignments2(courseName,"ta",(course,ass)=>{
    return res.render("course_grader",{
      flagA: course.flag1,
      flagE: course.flag2,
      role: "ta",
      ass: ass,
      course: course
    })
  })

})

app.get("/instructor/courses/:courseName/createAssignment", (req, res) => {
  if (!req.isAuthenticated()) {
    return res.redirect("/login");
  }
  var q = Course.findOne({name: req.params.courseName});
  q.exec(async(err, course) => {
    if (err) {
      console.log(err);
    } else if (course == null) {
      res.redirect("/instructor/courses/" + req.params.courseName);
    } else {
      res.render("createAssignment", {course: course});
    }
  })

})
app.post("/instructor/courses/:courseName/createAssignment", upload.single("myFile"), async(req, res) => {
  //console.log(req.file.filename);
  //console.log(req.body.time);
  var d=new Date(req.body.date+"T"+req.body.time+":00");

    const newFile = await Assignment.create({name: req.file.filename, nameofA: req.body.nameofA, desc: req.body.description, deadline: d,weightage: req.body.weightage,courseName: req.params.courseName,flag: false});
    var q = Course.findOne({name: req.params.courseName});
    q.exec(async(err, course) => {
      var ass = course.assignments;
      var students=course.students;
      ass.push(newFile._id);
      Course.findByIdAndUpdate(course._id, {
        $set: {
          assignments: ass
        }
      }, (err) => {
        if (err) 
          console.log(err)
      });
      if(students.length==0){
        return res.redirect("/instructor/courses/" + req.params.courseName);
      }
      students.forEach(id=>{
        User.findById(id,(err,user)=>{
          var scourses=user.SCourses;
          var ind=0,count=0;
          scourses.forEach(obj=>{
            if(obj.courseID==course._id){
              ind=count;
            }
            count+=1;
          })
          var obj=scourses[ind];
          var ass=obj.ass;
          ass.push({
            assID: newFile._id,
            flag: false,
          })
          //console.log(ass);
          scourses[ind].ass=ass;
          //console.log(scourses);
         // console.log(scourses[ind]);
          User.findByIdAndUpdate(id,{$set: {SCourses: scourses}},(err)=>{
            if(err) {
              console.log(err);
            }
            else{
              res.redirect("/instructor/courses/" + req.params.courseName);
            }
          })
        })
      })
    })
  
});
app.get("/instructor/courses/:courseName/assignments/:assName", (req, res) => {
  if (!req.isAuthenticated()) {
    return res.redirect("/login");
  }
  var courseName=req.params.courseName;
  var assName=req.params.assName;
  Course.findOne({name:courseName},(err,course)=>{
    var students=course.students.length;
    Assignment.findOne({nameofA:assName},(err,ass)=>{
      var ts=Math.floor(Math.abs((ass.deadline-Date.now())/1000));
      var days=Math.floor(Math.abs(ts/(3600*24)));
      var hrs=Math.floor(Math.abs((ts-days*3600*24)/(3600)));
      var mins= Math.floor(Math.abs((ts-days*3600*24-hrs*3600)/60));
      var seconds=Math.floor(Math.abs((ts-days*3600*24-hrs*3600-mins*60)));
      Submission.find({
        courseName: req.params.courseName,
        assName:assName
      },(err,subs)=>{
        if(err){
          console.log(err);
        }
        else{
          res.render("grader_assignment",{
            courseName:courseName,
            ass:ass,
            days: days,
            hrs: hrs,
            mins: mins,
            seconds: seconds,
            students: students,
            subs: subs
          });
        }
      })

    })
  })

})
app.get("/student/:courseName/grades" , (req,res)=> {
 if (!req.isAuthenticated()) {
        return res.redirect("/login");
  }
  var courseName=req.params.courseName;
  User.findById(req.user._id,(err,user)=>{
  	
      var sc=user.SCourses;
      sc.forEach(obj=>{
          Course.findById(obj.courseID,(err,course)=>{
              
              if(course.name==courseName){
              	  Submission.find({courseName:courseName,studentID:user._id},(err,subs)=>{
              	  	//console.log(subs.assName);
              	  }) 
              	  var t=0;
              	  var names = [];
              	  var grades = [];
                  var total =0 ;
                  Submission.find({courseName:courseName,studentID:user._id},(err,subs)=>{
                  	//console.log(subs.grade);
                  	
                  	subs.forEach(sub=>{
                  		t=t+1;
                      		var grade =(sub.grade);
                      		var assName = sub.assName;
                      		names = names.push(assName);
                      		grades = grades.push(grade);
                      		console.log(grades);
                      		Assignment.findOne({nameofA:assName},(err,ass)=>{
                      			var weightage = ass.weightage;
                      			total= total + weightage * grade ;
                      			//res.send(" Total Grade ( 0-10 ) : " + total/100);
                      			
                      		if(t==subs.length){
                      		//console.log(names);
                      			 res.render("grades_student",{
            					courseName:courseName,
            					total : total/100,
            					subs:subs,
            					names : names,
            					grades: grades
            				
            					
            				})
            			}
            	
                      			
                      			
                      			
                      		})
                      	//console.log(total)
                      	
                      
                  })
                  //console.log(total);
                  //res.render("grades_student",{
            	//courseName:courseName,
            	//total : total,
            		
            		//subs1: subs1
              });
          
      }
  })
  })
})
});

   
  	
	
app.get("/ta/courses/:courseName/assignments/:assName", (req, res) => {
  if (!req.isAuthenticated()) {
    return res.redirect("/login");
  }
  var courseName=req.params.courseName;
  var assName=req.params.assName;
  Course.findOne({name:courseName},(err,course)=>{
    var students=course.students.length;
    Assignment.findOne({nameofA:assName},(err,ass)=>{
      var ts=Math.floor(Math.abs((ass.deadline-Date.now())/1000));
      var days=Math.floor(Math.abs(ts/(3600*24)));
      var hrs=Math.floor(Math.abs((ts-days*3600*24)/(3600)));
      var mins= Math.floor(Math.abs((ts-days*3600*24-hrs*3600)/60));
      var seconds=Math.floor(Math.abs((ts-days*3600*24-hrs*3600-mins*60)));
      Submission.find({
        courseName: req.params.courseName,
        assName:assName
      },(err,subs)=>{
        if(err){
          console.log(err);
        }
        else{
          res.render("grader_assignment",{
            courseName:courseName,
            ass:ass,
            days: days,
            hrs: hrs,
            mins: mins,
            seconds: seconds,
            students: students,
            subs: subs
          });
        }
      })

    })
  })

})
app.get("/student/courses/:courseName/assignments/:assName", (req, res) => {  
  if (!req.isAuthenticated()) {
    return res.redirect("/login");
  }
  var assName=req.params.assName;
  var courseName=req.params.courseName;
  var q = Course.findOne({name: req.params.courseName});
  q.exec(async(err, course) => {
    if (err) {
      console.log(err);
    } else if (course == null) {
      res.redirect("/student");
    } else {
      Assignment.findOne({
        nameofA: req.params.assName
      }, (err, ass) => {
        if (err) {
          console.log(err);
        } else if (ass == null) {
          res.redirect("/student");
        } else {
          var ts=Math.floor(Math.abs((ass.deadline-Date.now())/1000));
          var days=Math.floor(Math.abs(ts/(3600*24)));
          var hrs=Math.floor(Math.abs((ts-days*3600*24)/(3600)));
          var mins= Math.floor(Math.abs((ts-days*3600*24-hrs*3600)/60));
          var seconds=Math.floor(Math.abs((ts-days*3600*24-hrs*3600-mins*60)));
          Submission.findOne({
            courseName: req.params.courseName,
            assName:assName,
            studentID: req.user._id
          },(err,sub)=>{
            if(err){
              console.log(err);
            }
            else{
              //console.log(sub);
              res.render("student_assignment",{
                course:course,
                ass:ass,
                days: days,
                hrs: hrs,
                mins: mins,
                seconds: seconds,
                sub: sub
              });
            }
          })
    
        }
      })
    }
  })
})

app.post("/instructor/courses/:courseName/assignments/:assName", upload.single("myFile"), async(req, res) => {

  try {
    // var b=req.file["buffer"]; console.log(b.toString());
    // console.log(b.toString()); console.log("wtf");
    const newF = await Feedback.create({name: req.file.filename, courseName: req.params.courseName, assName: req.params.assName})
    var courseName=req.params.courseName;
    var assName=req.params.assName;
    //console.log(courseName);
    const file = `${__dirname}/public/` + req.file.filename;
    //console.log(courseName);
    fs
    .createReadStream(file)
    .pipe(csv())
    .on("data", (row) => {
     // console.log(req.user);
     // console.log(row.Name + " " + row.grade);
      Submission.findOneAndUpdate({courseName:courseName,assName:assName,studentName:row.Name},{
        $set: {
          "grade": row.grade,
          "feedback": row.feedback
        }
      },
        (err)=>{
        console.log(err);
      })
    })
    .on("end", () => {
      res.json({status: "Successfully uploaded"});
    })
  } catch (err) {
    res.json({err})
  }
})
app.post("/ta/courses/:courseName/assignments/:assName", upload.single("myFile"), async(req, res) => {

  try {
    // var b=req.file["buffer"]; console.log(b.toString());
    // console.log(b.toString()); console.log("wtf");
    const newF = await Feedback.create({name: req.file.filename, courseName: req.params.courseName, assName: req.params.assName})
    var courseName=req.params.courseName;
    var assName=req.params.assName;
    //console.log(courseName);
    const file = `${__dirname}/public/` + req.file.filename;
    //console.log(courseName);
    fs
    .createReadStream(file)
    .pipe(csv())
    .on("data", (row) => {
     // console.log(req.user);
     // console.log(row.Name + " " + row.grade);
      Submission.findOneAndUpdate({courseName:courseName,assName:assName,studentName:row.Name},{
        $set: {
          "grade": row.grade,
          "feedback": row.feedback
        }
      },
        (err)=>{
        console.log(err);
      })
    })
    .on("end", () => {
      res.json({status: "Successfully uploaded"});
    })
  } catch (err) {
    res.json({err})
  }
})

app.get('/download/assignment/:assName', function (req, res) {
  //console.log(req);
  if (!req.isAuthenticated()) {
    return res.redirect("/login");
  }
  var assName = req.params.assName;
  //res.send(req.params.f)
  Assignment.findOne({
    nameofA: assName
  }, (err, ass) => {
    if (err) {
      console.log(err);
    } else {
      var filename = ass.name;
      const file = `${__dirname}/public/` + filename;
      res.download(file);
    }
  })
});
app.get('/download/submissions/:subId', function (req, res) {
  if (!req.isAuthenticated()) {
    return res.redirect("/login");
  }
  Submission.findById(req.params.subId, (err, sub) => {
    if (err) {
      console.log(err);
    } else {
      var filename = sub.name;
      const file = `${__dirname}/public/` + filename;
      
      res.download(file);
    }
  })
});

app.get("/:courseName/neParticipants",(req,res)=>{
  var courseName=req.params.courseName;
  getParticipants(courseName,p=>{
    //console.log(p);
    res.render("neParticipants",{p:p});
  })
})
app.get("/:courseName/eParticipants",(req,res)=>{
  var courseName=req.params.courseName;
  getParticipants(courseName,p=>{
    //console.log(p);
    res.render("eParticipants",{p:p});
  })
})

app.get("/:courseName/eParticipants",(req,res)=>{
  var courseName = req.params.courseName;
  
})
// app.get('/init', function (req, res) {
//   //console.log("in init");
//   events.insertOne({
//     text: "Some Helpful event",
//     start_date: new Date(2018, 8, 1),
//     end_date: new Date(2018, 8, 5)
//   })
//   events.insertOne({
//     text: "Another Cool Event",
//     start_date: new Date(2018, 8, 11),
//     end_date: new Date(2018, 8, 11)
//   })
//   events.insertOne({
//     text: "Super Activity",
//     start_date: new Date(2018, 8, 9),
//     end_date: new Date(2018, 8, 10)
//   })
//   res.send("Test events were added to the database")
// });

app.get("/:Role/calendar",(req,res)=>{
  var role=req.params.Role;
  var s="cal_"+role+".ejs";
  res.render(s);
})



app.get("/student/data", function (req, res) {
  data=[];
  User.findById(req.user._id,(err,user)=>{
    var sc=user.SCourses;
    var lc=0;
    sc.forEach(obj=>{
      Course.findById(obj.courseID,(err,course)=>{
        lc+=1;
        if(err){
          console.log(err);
        }
        else{
          var ass=obj.ass;
          var la=0;
          ass.forEach(obj2=>{
            Assignment.findById(obj2.assID,(err,ass1)=>{
              la+=1;
              if(!obj2.flag){
                data.push({
                  _id: ass1._id,
                  id: ass1.id,
                  text: ass1.nameofA+"("+course.name+")",
                  "start_date": ass1.createdAt,
                  "end_date": ass1.deadline,
                })
              }
              if(lc==sc.length&&la==ass.length){
               // console.log(data);
                return res.send(data);
              }
              
            })
          })
        }
      })
    })
  })

});

app.get("/instructor/data", function (req, res) {
  data=[];  
  //console.log(req.user);
  User.findById(req.user._id,(err,user)=>{
    var tcs=user.ICourses;
    var lc=0;
    //console.log(tcs);
    tcs.forEach(cid=>{
      lc+=1;
      Course.findById(cid,(err,course)=>{
        if(err){
          console.log(err);
        }
        else{
          var assIds=course.assignments;
          var la=0;
          assIds.forEach(assId=>{
            la+=1;
            Assignment.findById(assId,(err,ass1)=>{
              if(err) console.log(err);
              else{
                //console.log(ass1);
                if(!ass1.flag){
                  data.push({
                    _id: ass1._id,
                    id: ass1.id,
                    text: ass1.nameofA+"("+course.name+")",
                    "start_date": ass1.createdAt,
                    "end_date": ass1.deadline,
                  })
                }
                //console.log(la);
                if(lc==tcs.length&&la==assIds.length){
                  return res.send(data)
                }
              }
            })
          })
        }
      })
    })
  })
});

app.get("/ta/data", function (req, res) {
  data=[];  
  //console.log(req.user);
  User.findById(req.user._id,(err,user)=>{
    var tcs=user.TCourses;
    var lc=0;
    //console.log(tcs);
    tcs.forEach(cid=>{
      lc+=1;
      Course.findById(cid,(err,course)=>{
        if(err){
          console.log(err);
        }
        else{
          var assIds=course.assignments;
          var la=0;
          assIds.forEach(assId=>{
            la+=1;
            Assignment.findById(assId,(err,ass1)=>{
              if(err) console.log(err);
              else{
                //console.log(ass1);
                if(!ass1.flag){
                  data.push({
                    _id: ass1._id,
                    id: ass1.id,
                    text: ass1.nameofA+"("+course.name+")",
                    "start_date": ass1.createdAt,
                    "end_date": ass1.deadline,
                  })
                }
                //console.log(la);
                if(lc==tcs.length&&la==assIds.length){
                  return res.send(data)
                }
              }
            })
          })
        }
      })
    })
  })
});

app.get("/:courseName/enroll",(req,res)=>{
  var a=[];
  Course.findOne({name:req.params.courseName},(err,course)=>{
    var eu=course.students;
    course.tas.forEach(u=>eu.push(u));
    course.instructors.forEach(i=>eu.push(i));
    User.count({},(err,count)=>{
      var c=0;
      User.find({},(err,userA)=>{
        if(err){
          console.log(err);
        }
        else{
          userA.forEach(user=>{
            c+=1;
         
         
            var isthere=false;
            eu.forEach(u=>{
              if(u==user._id){
                isthere=true;
              }
            })
          //  console.log(c);
            if(!isthere) a.push(user);
            if(c==count){
              return res.render("enrollUsers.ejs",{a:a,courseName:req.params.courseName});
            }
          })

        }
      })
    })

  })
})

app.post("/:courseName/mail",(req,res)=>{
  var obj=req.body;
  var data=Object.entries(obj);
  //console.log(data);
  data.forEach(x=>{
    var email=x[0];
    var role=x[1];
    Course.findOne({name:req.params.courseName},(err,course)=>{
      var code="";
      if(role=="ta"){
        code=course.t_code;
      }
      else if(role=="student"){
        code=course.s_code;
      }
      else if(role=="instructor"){
        code=course.i_code;
      }
      var mailOptions = {
        from: 'FMoodletest1@gmail.com',
        to: email,
        subject: 'Email invitation to join the course '+course.name,
        text: 'Here is your code to join the course as a '+role+": "+code
      };
      
      transporter.sendMail(mailOptions, function(error, info){
        if (error) {
          console.log(error);
        } else {
          console.log('Email sent: ' + info.response);
        }
      });
    })
  })
  res.redirect("/"+req.params.courseName+"/eParticipants");
})
app.get('/download/:userName/:pwd/assignment/:assName', function (req, res) {
  var userN=req.params.userName, pwd=req.params.pwd;
  console.log(userN);
  console.log(pwd);
  if(process.env[`${userN}`]!=pwd){
    res.redirect("/login");
  }
  else{
    var assName = req.params.assName;
    Assignment.findOne({
      nameofA: assName
    }, (err, ass) => {
      if (err) {
        console.log(err);
      } else {
        var filename = ass.name;
        const file = `${__dirname}/public/` + filename;
        //console.log(file);
        //console.log(filename);
        res.download(file);
      }
    }) 
  }
});

app.post("/student/courses/:courseName/assignments/:assName", upload.single("myFile"), async(req, res) => {
  try {
    const newSub = await Submission.create({
      name: req.file.filename,
      feedback: null,
      grade: null,
      courseName: req.params.courseName,
      assName: req.params.assName,
      studentID: req.user._id,
      studentName: req.user.name,
      FileName: req.body.name
    })
    var q = User.findById(req.user._id);
    q.exec(async(err, user) => {
      var subs = [];
      subs = user.submissions;
      subs.push(newSub._id);
      var mailOptions = {
        from: 'FMoodletest1@gmail.com',
        to: req.user.email,
        subject: 'Assignment Submission'+req.params.courseName,
        text: 'You have succesfully submitted your assignment for the course'
      };
      
      transporter.sendMail(mailOptions, function(error, info){
        if (error) {
          console.log(error);
        } else {
          console.log('Email sent: ' + info.response);
        }
      });
      User.findByIdAndUpdate(req.user._id, {
        $set: {
          submissions: subs
        }
      }, (err) => {
        if (err) 
          console.log(err)
      });
      
      res.redirect("/student/courses/" + req.params.courseName);
    })
  } catch (error) {
    res.json({error});
  }
})

app.post("/upload/:userName/:pwd/:courseName/:assName", upload.single("myFile"),async(req,res)=>{
  console.log(req.body);
  console.log(req.body.file);

})

app.listen(port, function () {
  console.log("Server started on port 3000.");
});