/////////////////////////////////////////////
// NodeCMS                                //
// ---------------------------------------//
// @version 0.1                          //
// @authors Meikel Smirnow              //
/////////////////////////////////////////////
var express = require('express');
var mysql = require('mysql');
var phpjs = require('phpjs');
var bodyParser = require('body-parser');
var path = require('path');
var swig  = require('swig');
var session = require('express-session');

//Settings
var app = express();
app.use(bodyParser.urlencoded({ extended: false }));
app.use(bodyParser.json());
app.engine('html', swig.renderFile);
app.set('view engine', 'html');
app.set('views', __dirname + '/views');
app.set('view cache', false);
swig.setDefaults({ cache: false });
app.use(session({secret: 'asfasdg2314323asf23asd2'}));

var sql = mysql.createConnection({
    host    : '127.0.0.1',
    user    : 'root',
    password: '',
    database: 'test'
});

var current_session;

// MySQL
sql.connect((error) => {
    if(error) {
        console.log('Couldn\'t connect to the database: ' + error);
        process.exit(0);
    }
});

//Define Routes
app.get('/', function(req, res) {
  current_session = req.session;

  if(current_session.username && current_session.password) {
    res.redirect('/me');
  }
  else {
    res.sendFile(__dirname + '/views/index.html');
  }
});

app.post('/login', function(req, res) {
  var username = req.body.username;
  var password = phpjs.md5(req.body.password);
  current_session = req.session;

  var test = sql.query("SELECT * FROM users WHERE username = \"" + mysql.escape(username) + "\" AND password = '" + password + "' LIMIT 1", (error, rows, fields) => {
    if(error) {
      console.log(test);
      console.log('Couldn\'t execute query: ' + error);
      res.end('Couldn\'t execute query: ' + error);
    }
    else {
      if(rows.length > 0) {
        //console.log(test);
        current_session.username = username;
        current_session.password = password;

        res.redirect('/me');
      }
    }
  });
});

app.get('/me', function(res, req) {
  current_session = req.session;
  /*if(!current_session.username && !current_session.password) {
    res.redirect('/');
  }*/

  console.log(req.session);
});

var server = app.listen(1337, () => {
    var host = server.address().address;
    var port = server.address().port;

    console.log('NodeCMS listening at http://%s:%s', host, port);
});