app.js

const session = require("express-session"),
  bodyParser = require("body-parser"),
  express = require("express"),
  bcrypt = require("bcrypt"),
  app = express(),
  flash = require("connect-flash"),
  middleware = require("./middleware");

app.use(express.static(__dirname + "/public"));
app.set("view engine", "ejs");
app.use(bodyParser.urlencoded({ extended: true }));
app.use(bodyParser.json());

app.use(
  session({
    secret: "this is a random secret key for testing the user login",
    resave: true,
    saveUninitialized: true,
  })
);

app.use(flash());

app.use(function (req, res, next) {
  res.locals.currentUser = req.session.email || null;
  res.locals.error = req.flash("error");
  res.locals.success = req.flash("success");
  res.locals.warning = req.flash("warning");
  next();
});

var PORT = process.env.PORT || 3000;

var connection = require("./models/sql");

var loginRoute = require("./routes/login"),
  adminRoute = require("./routes/adminroutes"),
  airportRoute = require("./routes/airportroutes"),
  flightRoute = require("./routes/flightroutes"),
  userRoute = require("./routes/userroutes"),
  crewRoute = require("./routes/crewroutes");

// ======================================
//          ROUTESSSS REQUIRED
// ====================================
app.use(loginRoute);
app.use(adminRoute);
app.use(airportRoute);
app.use(flightRoute);
app.use(userRoute);
app.use(crewRoute);
// ===============================
// End Of REQUIRE
// =================

// =======================================
// Routes
// ========================

app.get("/logout", middleware.sessionChecker, function (req, res) {
  req.flash("error", "You have been Logged Out!!");
  res.redirect("/login");
  req.session.destroy();
});

app.get("/addadmin", function (req, res) {
  if (PORT == 3000) res.render("./admin/addadmin");
  else {
    console.log("Acceses from Net");
    res.send("You are not authorized to add admin from this port");
  }
});

app.post("/addadmin", function (req, res) {
  if (PORT != 3000) {
    res.send("You are not authorized to add admin from this port");
  }
  var email = req.body.email;
  connection.query("SELECT * FROM userinfo WHERE email = ?", email, function (err, result, fields) {
    if (result && result.length > 0) {
      res.send("User with this email already exists!! Goto <a href='/login'>login</a>");
    } else {
      connection.query("SELECT count(userid) as numb FROM userinfo ", function (err, result, fields) {
        var usercount = parseInt(result[0].numb ? result[0].numb : 0);
        var post = {
          userid: "U" + (usercount + 1),
          pass: req.body.password,
          first_name: req.body.first_name,
          last_name: req.body.last_name,
          email: req.body.email,
          phone: parseInt(req.body.phone),
          passport_number: req.body.passport_number.toUpperCase(),
          dob: req.body.date,
          usertype: "admin",
          occupation: "admin",
        };
        bcrypt.hash(req.body.password, 10, function (err, hash) {
          post.pass = hash;
          connection.query("INSERT INTO userinfo SET ?", post, function (err, result, fields) {
            if (err) {
              console.log(err);
              req.flash("error", "Unable to create Admin");
              res.redirect("/login");
            } else req.flash("success", "Admin Account Created! Please Login to Continue");
            res.redirect("/login");
          });
        });
      });
    }
  });
});

// ===========SEE at LAST===========
app.get("*", function (req, res) {
  res.send("You hit the error route");
});
app.listen(PORT, function () {
  console.log("Server is flying");
});