var express = require('express');
var app = express();
var bodyParser = require('body-parser');
var url = bodyParser.urlencoded({ extended: false });

app.set('view engine', 'ejs');

const mysql = require('mysql');
const db = mysql.createConnection({
    host : 'localhost',
    port: '3307',
    user : 'root',
    password : 'usbw',
    database : 'user'
});
db.connect();

var tarikData = 'SELECT * FROM datauser';
db.query(tarikData, function(err, result) {
    if(err){
        throw err;
    } else {
        for(var i=0; i < result.length; i++){
            cekEmail = result[i].Email;
            cekPassword = result[i].Password;
        }
    }
});

const crypto = require('crypto');
const secret = 'abcdefg';

app.listen(3030);

app.get('/login', function(req, res){
    res.render('login');
})

app.post('/login', url, function(req, res){
    var email = req.body.email;
    var password = req.body.pass;

    // console.log(email);
    // console.log(password);

    const encpass = crypto.createHash('sha256', secret).update(password).digest('hex');
    // console.log(encpass);

    if(email !== cekEmail || encpass !== cekPassword ){
        console.log('Login gagal');
        res.send('Login gagal');
    } else if(req.body.email === cekEmail && encpass === cekPassword) {
        res.send('Login berhasil');
    }
})

app.get('/regis', function(req, res){
    res.render('form');
})

app.post('/regis', url, function(req, res){
    var fullname = req.body.fullname;
    var email = req.body.email;
    var password = req.body.pass;

    console.log(fullname);
    console.log(email);
    console.log(password);

    const encpass = crypto.createHash('sha256', secret).update(password).digest('hex');
    console.log(encpass);

    var sql = "INSERT INTO datauser (FullName, Email, Password) VALUES ('"+fullname+"','"+email+"','"+encpass+"')";
    db.query(sql, (err, result)=>{
    if(err) throw err;
        console.log(result);
    });

    // db.end();
    res.redirect('/regis');
    // res.send('Registrasi berhasil !');
})