var express = require('express');
var app = express();
var http = require('http').Server(app);
var io = require('socket.io')(http);
var mysql = require('mysql');
const util = require('util');
var bodyParser = require('body-parser');
var session = require('express-session');
var fonctionMaison = require('./fonction.js');
var registerController = require('./controllers/register-controller.js');
var loginController = require('./controllers/login-controller.js');
app.use(bodyParser.json()); // support json encoded bodies
app.use(bodyParser.urlencoded({ extended: true })); // support encoded bodies
app.use(session({ secret: 'fUZG4VjOx9U91Htq2AAA', cookie: { maxAge: 60000 }, saveUninitialized: true,resave: false}));
const config = require('./config.json');
var con = require('./bdd.js')
app.set('view engine', 'ejs');
app.use('/static/', express.static('static'));
app.get('/', function(req, res){
if(req.session.authStatus)
con.query('SELECT * FROM zone', function (err, result, fields) {
if (err) throw err;
var zone = JSON.stringify(result);
zone = JSON.parse(zone);
res.render('index', {zone:zone});
});
else
res.redirect('/login');
}).get('/TV', function(req, res){
res.render('TV');
}).get('/TV/zone/:zone', function(req, res){
con.query("SELECT * FROM com_active INNER JOIN zone ON com_active.ID_Zone = zone.ID_Zone INNER JOIN communication ON com_active.ID_Com = communication.ID_Com WHERE zone.ID_Zone = ? ", [req.params.zone], function(err, result){
if (err) throw err;
var pub = JSON.stringify(result);
pub = JSON.parse(pub);
fonctionMaison.listPubDansZone(req.params.zone,function(err, pub){
if (err) throw err;
res.render('TV', {zone:req.params.zone,pub:pub})
});
});
}).get('/TV/latlng/:lat/:lng', function(req,res){
con.query('CALL cherche_zones(?,?,?,?)', [req.params.lat,req.params.lat,req.params.lng,req.params.lng], function(err, result){
if (err) throw err;
var data = JSON.stringify(result);
data = JSON.parse(data);
var zone = fonctionMaison.choixZone(data[0]);
fonctionMaison.listPubDansZone(zone.ID_Zone,function(err, pub){
if (err) throw err;
res.render('TV', {zone:zone.ID_Zone,pub:pub})
});
//console.log(util.inspect(data[0][0].Nom, false, null, true /* enable colors */))
});
}).get('/map', function(req, res){
con.query('SELECT * FROM zone', function (err, result, fields) {
if (err) throw err;
var zone = JSON.stringify(result);
zone = JSON.parse(zone);
res.render('map', {zone:zone});
});
}).get('/login', function(req, res){
res.render('login');
}).post('/login', loginController, function(req, res){
res.send(''+req.session.authMessage+'
HOME');
}).post('/register', registerController, function(req, res){
res.send(''+res.locals.message+'
HOME');
}).post('/addZone' , function(req, res){
var nord = req.body.N;
var sud = req.body.S;
var est = req.body.E;
var ouest = req.body.O;
var name = req.body.Name;
con.query('CALL add_zone(?,?,?,?,?,?)', [true, name,nord,sud,ouest,est], function(err, result){
});
});
io.on('connection', function(socket){
socket.on('JoinZone', function(zone){
console.log("Join "+zone)
socket.join(zone);
});
socket.on('Communication', function(CommunicationJSON){
var data = JSON.parse(CommunicationJSON);
console.log("JSON : "+CommunicationJSON);
console.log("ZONE "+data.zone);
io.sockets.in(data.zone).emit('Communication', CommunicationJSON);
});
});
http.listen(1234, function(){
console.log('listening on *:1234');
});