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

// var session = require('express-session');
// app.use(session({secret: 'ssshhh'}));
// var sess;

var cors = require('cors');
app.use(cors());

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

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

app.get('/', (req, res) => {
  res.send('Halaman Server')
})

app.post('/Login', (req, res) => {

  var Username = req.body.username;
  var Password = req.body.password;

  // console.log(Username);
  // console.log(Password);
  res.end();

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

  var pullData = "SELECT * FROM newusers";
  db.query(pullData, (err, result) => {
    if(err) throw err;
    else {
      var counter = 0;
      for (var i=0; i<result.length; i++)
      {
        if (Username === result[i].Username && encpass === result[i].Password)
        {
          console.log('Login Berhasil');
          counter = counter + 1;
          break;
        }
        else if (i === result.length-1 && counter < 1)
        {
          console.log('Data tidak ditemukan, login gagal');
        }
      }
    }
  });
})

app.post('/Register', function(req, res)
{
  var FullName = req.body.fullname;
  var Username = req.body.username;
  var Email = req.body.email;
  var Password = req.body.password;

  // console.log(FullName);
  // console.log(Username);
  // console.log(Email);
  // console.log(Password);
  res.end();

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

  var sql = "INSERT INTO newusers (FullName, Username, Email, Password) VALUES ('"+FullName+"','"+Username+"','"+Email+"','"+encpass+"')";
  db.query(sql, (err, result) => {
    if(err) throw err;
  });
})

app.listen(3001);