var express = require('express');
var mysql = require('mysql');
var bodyParser = require('body-parser');
var port = process.env.PORT;
var cors = require('cors');
var session = require('express-session');

var connection = mysql.createConnection({
  host: 'localhost',
  user: 'root',
  password: 'vibhuti',
  database: 'RentFaster',
  multipleStatements: true
});
connection.connect();
var app = express();
app.use(function(req, res, next) {
 res.header("Access-Control-Allow-Origin", "*");
 res.header("Access-Control-Allow-Headers", "Origin, X-Requested-With, Content-Type, Accept");
 next();
});

app.use(cors());
app.use(bodyParser.json({ extended: true }));
app.use(bodyParser.urlencoded({ extended: false }));


app.use(session({
   secret: '2C44-4D44-WppQ38S',
   resave: true,
   saveUninitialized: true
}));

if (process.env.NODE_ENV === 'production') {
  // Serve any static files
  app.use(express.static(path.join(__dirname, 'client/build')));
  // Handle React routing, return all requests to React app
  app.get('*', function(req, res) {
    res.sendFile(path.join(__dirname, 'client/build', 'index.html'));
  });
}

app.post('/api/login', (req, res,next) => {

  var email= req.body.email;
  var password= req.body.password;

  var query = connection.query("SELECT * FROM users WHERE email = ? AND password = ?",[email, password],function(err, user) {
    if(user.length == 0) {
      console.log("error");
            console.log(err);

          res.send(err);
        }
        else if(err){


          res.send(err);
        }
        else if(user.length == 1){
          req.session.user = user[0];
          var id = user[0].id;

       res.send({data:id});

           // console.log("sahil");
   //console.log(result);
   //res.end();

        }

});
});

app.get('/api/dashboard', (req, res) => {
  if(req.session.user){

  var query = connection.query('select * from Property;select * from favorites;select * from users;select * from Search',  function(err, result) {
  var
   numRows = result[0].length;
 var   numRows1 = result[1].length;
    var   numRows2 = result[2].length;
    var   numRows3 = result[3].length;

     res.send({data:result[0],data1:result[2],countfav:numRows1,countprop:numRows,countuser:numRows2,countsearch:numRows3});
});
}
else{

  res.send(err);


}
}
);


app.get('/api/profile', (req, res) => {
  if(req.session.user){
   console.log(req.session.user);
  var id = req.session.user.id;
  var query = connection.query('select * from users where id = '+id+'',  function(err, result) {
    console.log("result");
  console.log(result[0]);
     res.send({data:result[0]});
});
}
});

app.get('/api/property', (req, res) => {
  if(req.session.user){
   console.log(req.session.user);
  var id = req.session.user.id;
  var query = connection.query('select * from Property',  function(err, result) {
    console.log("result");
  console.log(result);
     res.send({data:result});
});
}
});

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

  console.log(req.body.id);
  var id = req.body.id;

  var query = connection.query("DELETE FROM users WHERE id = "+id+" ",  function(err, result) {
    if(err) {
            console.log(err);
            res.status(200).json( err);

        }
        else if(result){
       res.send({data:"Record has been Deleted..!!"});



        }
    });
});

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

  var id = req.body.id;

  var query = connection.query("DELETE FROM Property WHERE id = "+id+" ",  function(err, result) {
    if(err) {
            console.log(err);
            res.status(200).json( err);

        }
        else if(result){
       res.send({data:"Record has been Deleted..!!"});



        }

});
});

 app.get('/api/logout', function(req, res){
req.session.destroy(function (data) {
  res.send({data:"1"})

});
});

app.get('/api/currentuser', (req, res) => {
  if(req.session.user){
 var datetime =  new Date();
    console.log(datetime);

  var query = connection.query("SELECT *FROM users WHERE created_at > DATE_SUB(NOW(), INTERVAL 24 HOUR) ",  function(err, result) {


     res.send({data:result});
});
}
else{
  res.redirect('/login');
}
});

app.get('/api/userchart', (req, res) => {
  if(req.session.user){
 var datetime =  new Date();
    console.log(datetime);

  var query = connection.query("SELECT *FROM users WHERE created_at > DATE_SUB(NOW(), INTERVAL 24 HOUR)",  function(err, result) {
  var numRows1 = result.length;

     res.send({countdata:numRows1,data:result});
});
}
else{

}
});

app.get('/api/propertychart', (req, res) => {
  if(req.session.user){
 var datetime =  new Date();

 var sql = "SELECT * FROM Property WHERE Address = ?;SELECT * FROM Property WHERE Address = ?;SELECT * FROM Property WHERE Address = ?";

  var query = connection.query(sql, ["Toronto", "Missisuaga","Brampton"],  function(err, result) {
  var numRows1 = result[0].length;
  var numRows2 = result[1].length;
  var numRows3 = result[2].length;


     res.send({countdata:numRows1,countdata1:numRows2,countdata2:numRows3});
});
}
else{

}
});

app.get('/api/coordinate', (req, res) => {
  if(req.session.user){
 var datetime =  new Date();


  var query = connection.query("SELECT * FROM Property",  function(err, result) {



     res.send({data:result});
});
}
else{

}
});

app.post('/api/updateprofile', (req, res) => {
  if(req.session.user){
    var id =req.body.id;
    var name =req.body.name;
    var role =req.body.role;
    var email =req.body.email;
    var Phone =req.body.Phone;
    var City =req.body.City;
    var Country =req.body.Country;
    var Zip_Code =req.body.Zip_Code;

  var query = 'UPDATE users SET Role = ?,email =?,Phone=?,City=?,Country=?,name=? WHERE id=?';

var query = connection.query(query,[role,email,Phone,City,Country,name,id], function (error, result, rows, fields) {
if(result){

res.send({date:result});

}

});
}
else{

}
});

app.listen(port, () => console.log(`Listening on port ${port}`));