app.js

let express = require("express");
const dotenv = require("dotenv");
const bodyParser = require("body-parser");
const sequelize = require('./util/database')
const morgan = require('morgan');
const cors = require("cors")
const multer = require("multer")
const path = require("path");
const { where } = require("sequelize");
const User = require("./models/models").User
var port = process.env.PORT || 5000;


dotenv.config();


//////////////////////////////////////////////////////////


////////////////////////////////////////////////////////



let app = express();

//Middlewares
const publicdrc = path.resolve(__dirname, 'public')
app.use(express.static(publicdrc))

app.use(cors(

))

app.use(express.json());
app.use(
    bodyParser.urlencoded({
        extended: false,
    })
);
app.set('view engine', 'ejs')
app.use(bodyParser.json());
app.use(express.static(__dirname + '/public'));
const storage = multer.diskStorage({
    destination: (req, file, cb) => {
        cb(null, './public/screenshots')
    },
    filename: (req, file, cb) => {

        cb(null, file.originalname)
    }
})
const upload = multer({ storage });
//routes and logic


app.get("/", (req, res) => {
    res.render("homepage");
});
app.get("/users", (req, res) => {
    User.findAll().then(users => res.send({ status: 200, data: users, message: "Fetched users" })).catch(err => {
        console.log(err);
        res.send({ status: 400, message: "Couldn't fetch users" })
    })
})
app.put("/user", upload.single('file'), async (req, res) => {
    try {
        const data = await JSON.parse(req.body.data)
        if (!data.name || !data.email || !data.phonenumber) {
            console.log("error")
            throw new Error("Invalid Data")
        }
        const user = await User.findOne({ where: { email: data.email } }).then(response => { console.log("response", response); if (response === null) { return false } else { return true } }).catch(err => { return true })
        console.log(user)
        if (user) {
            return res.send({ status: 403, message: "Email already registered" })
        }
        else {
            User.create({
                name: data.name,
                email: data.email,
                phonenumber: data.phonenumber,
                dob: data.dob,
                branch: data.branch,
                batch: data.batch,
                year: data.year,
                admissionyear: data.admissionyear,
                admissionnumber: data.admissionnumber,
                address: data.address,
                specialinterests: data.specialinterests,
                careerpreference: data.careerpreference,
                typeofservice: data.typeofservice,
                accholdersname: data.accholdersname,
                transactionid: data.transactionid,
                imageurl: req.file.originalname,
                istemember: data.istemember,
                leapmembership: data.leapmembership
            }).then(response => {
                console.log(response)
                res.send({ status: 200, message: "User created successfully" })
            }).catch(err => {
                console.log(err)
                res.send({ status: 400, message: "Couldn't register user" })
            })
        }
    }
    catch (err) {
        console.log(err)
        res.send({ status: 400, message: "Couldn't register user" })
    }
})
app.delete("/user", (req, res) => {
    if (req.body.key === String(process.env.KEY)) {
        User.destroy({
            where: {
                email: req.body.email
            }
        }).then(users => res.send({ status: 200, data: users, message: "Deleted user " })).catch(err => {
            console.log(err);
            res.send({ status: 400, message: "Couldn't delete user" })
        })
    }
    else {
        res.send({ status: 403, message: "UnAuthorized" })
    }
})
sequelize.sync().then(result => {
    app.listen(port, () => {
        console.log("server started")
    })
}).catch(err => console.log(err))