index.js

const express = require("express");
const port = 8032;
const axios = require("axios");
const db = require("./config/mongoose");
const cookieParser = require("cookie-parser");
const session = require("express-session");
const passport = require("passport");
const passportLocal = require("./config/passport-local-strategy");
const mongoStore = require("connect-mongo")(session);
const passportGoogle = require("./config/passport-google-oauth2-strategy");
const flash = require("connect-flash");
const customMware = require("./config/middleware");
const { google } = require("googleapis");
//const request = require('request-promise');
const cheerio = require("cheerio");
const https = require("https");
//const professorsList = require('./config/professors');
const fs = require("fs");
const Admin = require("./models/admin");
const expressLayouts = require("express-ejs-layouts");

const app = express();

app.set("view engine", "ejs");
app.set("views", "./views");

app.use("/assets", express.static("./assets"));
app.use(expressLayouts);
app.use(express.urlencoded());
app.use(cookieParser());
app.use(
  session({
    name: "nodues",
    secret: "blahsomething",
    saveUninitialized: false,
    resave: false,
    cookie: {
      maxAge: 1000 * 60 * 100,
    },
    store: new mongoStore(
      {
        mongooseConnection: db,
        autoRemove: "disabled",
      },
      (err) => {
        if (err) {
          console.log("Error in setting up connect-mongo");
        }
      }
    ),
  })
);
app.use(passport.initialize());
app.use(passport.session());
app.use(passport.setAuthenticatedUser);
app.use(flash());
app.use(customMware.setFlash);
app.use("/", require("./routes/index"));

app.listen(port, async (err) => {
  if (err) {
    console.log("Error in running the server", err);
    return;
  }
  console.log("Server is running perfectly fine on port: ", port);

  //Admin Details
  var spreadsheetId = "1hXUEUHWGt3TyrhvWPh25U8KlmutxcTVx2qfAdPHyCEY";
  var auth = new google.auth.GoogleAuth({
    keyFile: "credentials.json",
    scopes: "https://www.googleapis.com/auth/spreadsheets",
  });
  var client = await auth.getClient();
  var googleSheets = google.sheets({ version: "v4", auth: client });
  var metadata = await googleSheets.spreadsheets.get({
    auth: auth,
    spreadsheetId: spreadsheetId,
  });
  var data = await googleSheets.spreadsheets.values.get({
    auth: auth,
    spreadsheetId: spreadsheetId,
    range: "Sheet1",
  });
  global.admins_data = data.data.values;

  fs.readFile("./data/admins.json", (err, data) => {
    if (err) {
      console.log("Error in writing to admins file: ", err);
      return;
    }
    if (data != JSON.stringify(global.admins_data)) {
      fs.writeFile(
        "./data/admins.json",
        JSON.stringify(global.admins_data),
        (err) => {
          if (err) {
            console.log("Error in writing to admins file: ", err);
            return;
          }
        }
      );
    }
  });
  Admin.db.collection.drop();
  Admin.addAdmins(global.admins_data);

  //Professors List
  var spreadsheetId = "1L-mCmog-GlNVKQlV_6Jvo9WyQKZpr-S346ijUlPj0gM";
  var auth = new google.auth.GoogleAuth({
    keyFile: "credentials.json",
    scopes: "https://www.googleapis.com/auth/spreadsheets",
  });
  var client = await auth.getClient();
  var googleSheets = google.sheets({ version: "v4", auth: client });
  var metadata = await googleSheets.spreadsheets.get({
    auth: auth,
    spreadsheetId: spreadsheetId,
  });
  var data = await googleSheets.spreadsheets.values.get({
    auth: auth,
    spreadsheetId: spreadsheetId,
    range: "Sheet1",
  });
  professors_data = data.data.values;
  professors_data.shift();

  fs.readFile("./data/professors.json", (err, data) => {
    if (err) {
      console.log("Error in writing to admins file: ", err);
      return;
    }
    if (data != JSON.stringify(professors_data)) {
      fs.writeFile(
        "./data/professors.json",
        JSON.stringify(professors_data),
        (err) => {
          if (err) {
            console.log("Error in writing to admins file: ", err);
            return;
          }
        }
      );
    }
  });
  var proffNames = {};
  for (var i in professors_data) {
    if(i==0){
      continue;
    }
    proffNames[professors_data[i][1]] = professors_data[i][0];
  }
  var text = `    
    const getProffName = (email) => {
        return proffNames[email];
    }

    module.exports.proffNames = proffNames;

    const isProff = (email) => {
        
        if (email in proffNames) {
            return true;
        } else {
            return false;
        }
    } 
    module.exports={getProffName,isProff}; 
    `;

  fs.writeFile(
    "./data/getProffName.js",
    "var proffNames = " + JSON.stringify(proffNames) + "\n" + text,
    (err) => {
      if (err) {
        console.log("Error in writing to admins file: ", err);
        return;
      }
    }
  );

  //Students List
  var spreadsheetId = "1NfsIc8CO7n4CvqkmtmGhoOQgL7lGKAmlbk3konSuCxY";
  var auth = new google.auth.GoogleAuth({
    keyFile: "credentials.json",
    scopes: "https://www.googleapis.com/auth/spreadsheets",
  });
  var client = await auth.getClient();
  var googleSheets = google.sheets({ version: "v4", auth: client });
  var metadata = await googleSheets.spreadsheets.get({
    auth: auth,
    spreadsheetId: spreadsheetId,
  });
  var data = await googleSheets.spreadsheets.values.get({
    auth: auth,
    spreadsheetId: spreadsheetId,
    range: "Sheet1",
  });
  students_data = data.data.values;
  fs.readFile("./data/students.json", (err, data) => {
    if (err) {
      console.log("Error in writing to studnts file: ", err);
      return;
    }
    if (data != JSON.stringify(students_data)) {
      fs.writeFile(
        "./data/students.json",
        JSON.stringify(students_data),
        (err) => {
          if (err) {
            console.log("Error in writing to students file: ", err);
            return;
          }
        }
      );
    }
  });

  function changeNameFormat(name) {
    if (name.substring(0, 9) == "Academics") {
      return "academics";
    }
    var arr = name.split(" ");
    var newName = arr[0].toLowerCase();
    for (var i = 1; i < arr.length; i++) {
      if (arr[i] == "&") {
        arr[i] = "and";
      }
      newName = newName + arr[i][0].toUpperCase() + arr[i].substring(1);
    }
    return newName;
  }

  var adminNames = {};
  var names = [];
  for (var i in global.admins_data) {
    adminNames[global.admins_data[i][1]] = changeNameFormat(
      global.admins_data[i][0]
    );
    names.push(changeNameFormat(global.admins_data[i][0]));
  }
  var text = `module.exports.getAdminName = (email) => {
        if (email in adminNames) {
            return adminNames[email];
        } else {
            return 'student';
        }
    };
    module.exports.adminNames = adminNames;`;
  global.admins_data = adminNames;
  fs.writeFile(
    "./data/getAdminName.js",
    "var adminNames = " + JSON.stringify(adminNames) + ";\n" + text,
    (err) => {
      if (err) {
        console.log("Error in writing to admins file: ", err);
        return;
      }
    }
  );
});