// Global variables
const mysql = require('mysql');
const express = require('express');
const app = express();
const bodyParser = require('body-parser');
const port = process.env.PORT || 5050;
const cors = require('cors');
const urlencodedParser = bodyParser.urlencoded({ extended: true });
const {myEncrypt, myDecrypt} = require('./helpers/password.js');

// Express directories
app.use(express.static(__dirname + '/node_modules'));
app.use('/assets', express.static('stuff'));

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(bodyParser.json());
app.use(cors());

const con = mysql.createConnection({host: "SG-iGreeter-1824-master.servers.mongodirector.com", user: 'Essam', password: 'Essam1000*', database: 'iGreeter', port: 3306});

{/* const con = mysql.createConnection({host: "localhost", user: 'root', password: 'ahmed200', database: 'iGreeter', port: 3306, multipleStatements: true}); */}
con.connect( (err) => {
    if (err) throw err;
    else console.log('Connected Successfully!');
});

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

    /* Extract the data */
    let data = req.query;

    let password = data.password;
    let email = data.email;

    let query = "SELECT ID, First_Name FROM shopOwner WHERE Password=" + JSON.stringify(password) + " and Email=" + JSON.stringify(email);

    con.query(query, function (err, result, fields) {
        if (err || Object.keys(result).length == 0){
            console.log(err);
            res.send('0');
        }
        else{
            res.send(result);
        }
    });
    return;
});


/* Email verification for forget password */
app.post('/FP_EmailVerify', urlencodedParser, (req, res) => {

    /* Extract the data */
    let data = req.query;
    let email = data.email;
    let query = "SELECT * FROM shopOwner WHERE Email=" + JSON.stringify(email);

    con.query(query, function (err, result, fields) {
        if (err || Object.keys(result).length == 0){
            console.log(err);
            res.send('0');
        }
        else{
            res.send('1');
        }
    });
    return;
});


/* Info Changing */
app.post('/ChangePassword', urlencodedParser, (req, res) => {

    /* Extract the data */
    let data = req.query;

    let email = data.email;
    let query = "UPDATE shopOwner SET";

    let values = {};

    /* If Password data is provided for changing */
    if (data.password !== undefined && data.password !== ""){
        values['Password'] = data.password;
    }

    /* If Phone is provided for changing */
    if(data.Phone !== undefined && data.Phone !== ""){
        values['Phone'] = data.Phone;
    }

    /* If Email data is provided for changing */
    if(data.email !== undefined && data.email !== ""){
        values['Email'] = data.email;
    }

    let i = 0;
    for (let key in values){
        if (i == 0){
            query += " " + key + "=" + JSON.stringify(values[key]);
        }
        else {
            query += ", " + key + "=" + JSON.stringify(values[key]);
        }

        i += 1;
    }

    query += " WHERE Email=" + JSON.stringify(email);

    con.query(query, function (err, result, fields) {
        if (err || Object.keys(result).length == 0){
            console.log(err);
            res.send('0');
        }
        else{
            res.send('1');
        }
    });

    return;
});

/* Show contracts of specific shop owner */
app.post('/showContracts', urlencodedParser, (req, res) => {

    /* Extract the data */
    let data = req.query;
    let ID = data.ID;
    let query = "SELECT * FROM shopOwner JOIN Contract ON shopOwner.ID = Contract.Owner_ID JOIN Shop ON Shop.ID = Contract.Shop_ID WHERE shopOwner.ID=" + ID;

    con.query(query, function(err, result, fields) {
        if (err || Object.keys(result).length == 0){
            res.send('0');
        }
        else{
            res.send(result);
        }
    });
});

/* Shop owner profile */
app.post('/Profile', urlencodedParser, (req, res) => {

    /* Extract the data */
    let data = req.query;
    let ID = data.ID;
    let query = "SELECT * FROM shopOwner where ID = " + JSON.stringify(ID);
    con.query(query, function (err, result, fields) {
        if (err || Object.keys(result).length == 0) {
            res.send(0);
            console.log("Err");
        }
        else{
            res.send(result);
        }
    });
    return;
});

/* Shop owner profile */
app.post('/showShops', urlencodedParser, (req, res) => {

    /* Extract the data */
    let data = req.query;
    let ID = data.ID;
    console.log(ID);
    let query =
    "SELECT * FROM (shopOwner JOIN Contract ON Contract.Owner_ID=shopOwner.ID JOIN Shop on Contract.Shop_ID = Shop.ID) WHERE shopOwner.ID=" + JSON.stringify(ID);
    con.query(query, function (err, result) {
        if (err || Object.keys(result).length == 0){
            res.send('0');
            console.log("Bye")
        }
        else{
            res.send(result);
            console.log("Hi")
        }
        });

    return;
});

/* Info Changing */
app.post('/ChangeInfo', urlencodedParser, (req, res) => {

    /* Extract the data */
    let data = req.query;
    let id = data.ID;
    console.log(id);

    let query = "UPDATE shopOwner SET";
    let values = {};

    /* If Password data is provided for changing */
    if (data.Password !== undefined && data.Password !== ""){
        values['Password'] = data.Password;
    }

    /* If Phone is provided for changing */
    if(data.Phone !== undefined && data.Phone !== ""){
        values['Phone'] = data.Phone;
    }

    /* If Email data is provided for changing */
    if(data.Email !== undefined && data.Email !== ""){
        values['Email'] = data.Email;
    }

    /* If First Name data is provided for changing */
    if(data.First_Name !== undefined && data.First_Name !== ""){
        values['First_Name'] = data.First_Name;
    }

    /* If Second Name data is provided for changing */
    if(data.Second_Name !== undefined && data.Second_Name !== ""){
        values['Second_Name'] = data.Second_Name;
    }

    let i = 0;
    for (let key in values){
        if (i == 0){
            query += " " + key + "=" + JSON.stringify(values[key]);
        }
        else {
            query += ", " + key + "=" + JSON.stringify(values[key]);
        }

        i += 1;
    }

    query += " WHERE ID=" + JSON.stringify(id);

    con.query(query, function (err, result, fields) {
        if (err || Object.keys(result).length == 0){
            console.log(err);
            res.send('0');
        }
        else{
            console.log('55555');
            res.send('1');
        }
    });
    return;
});


// Listen to a port
app.listen(port);