const express = require('express');
const app = express();
const session = require('express-session');
const path = require('path');
const bodyparser = require('body-parser');
const mysql = require('mysql');
const cookieParser = require('cookie-parser');


//Serve public folders static files
app.use(express.static(path.join(__dirname, 'public')));
app.engine('html', require('ejs').renderFile);
app.set('view engine', 'html');
app.set('views', __dirname + "/public/");

//Use bodyparser to parse POST forms (eg. req.body.'input name')
app.use(bodyparser.urlencoded({extended: false}));

//Use cookie parser to manage cookies
app.use(cookieParser());

//Setup session
app.use(session({secret: 'SepsisMies123'}));

var db = mysql.createConnection({
    host: "localhost",
    user: "dbuser",
    password: "Sepsis123Database",
    database: "AjoneuvonSeuranta"
});

/*
db.connect(function(err) {
    if (err) throw err;
});*/


app.get('/', function(req, res) {
    if (req.session.account_id) {
        console.log("Rendering profile because session exists");
        res.redirect('/profile');
    }
    else {
        console.log("rending index no session");
        res.render('home.html');
    }
});

app.get('/profile', function(req, res) {
    if (req.session.account_id) {
        console.log("Rendering profile because session exists");
        res.render('profile.html');
    }
    else {
        console.log("cant access profile without session");
        res.redirect('/');
    }
});

app.get('/logout', function(req, res) {
    req.session.destroy(function(err) {
        if (err) {
            res.negotiate(err);
        }
    });
    res.redirect('/');
    console.log('Deleted session id!');
});

app.post('/validateLogin', function(req, res) {
    console.log("Trying to login with " + req.body.uname + req.body.psw);
    /*db.query("SELECT * FROM account where user_name = '" + req.body.uname + "' AND password = '" + req.body.psw + "';",
        function(err, result, fields) {
            if (err) throw err;
            if (Object.keys(result).length == 1) {
                console.log("Found user!");
                req.session.account_id = result.account_id;
                res.render('profile.html');
            }
            else {
                console.log("User not found!");
                res.render('index.html');
            }
    });*/
    if (req.body.uname == "user" && req.body.psw == "pass") {
        req.session.account_id = 1;
        res.render('profile.html');
        console.log("Valid user pass!");
    }
    else {
        res.redirect('/');
        console.log("Invalid user pass!");
    }

});

const server = app.listen(8080, function() {
    console.log("Server running at port 8080!");
});