// Website Calls
let express = require('express');
let mysql = require('mysql');
let bodyParser = require('body-parser');
let colors = require('colors');
let app = express();
let error = '',
    success = '';

let func = require('./functions.js');

let SteamUser = require('steam-user');
let SteamTotp = require('steam-totp');
let SteamCommunity = require('steamcommunity');
let TradeOfferManager = require('steam-tradeoffer-manager');
let config = require('./config.json');

let client = new SteamUser();
let community = new SteamCommunity();
let manager = new TradeOfferManager ({
    steam: client,
    community: community,
    language: 'en'
});
var connection = mysql.createConnection({
  host: config.db.host,
  user: config.db.user,
  password: config.db.pass,
  database: config.db.dbname
});
connection.connect((err) => { if (err) { throw err; return; } });

app.set('view engine', 'ejs');

app.use('/assets', express.static('public'));
app.use(bodyParser.urlencoded({extended: false}));
app.use(bodyParser.json());

app.get('/', (req, res) => {
    connection.query('select * from items', function(err, result) {
        if (err) { console.error(err); return false; }
        res.render('pages/index', {prices: result, count: 2, error: error, success: success});
        error = '';success = "";
    });
});


app.get('/update', (req, res) => { res.redirect('/'); });
app.get('/add', (req, res) => { res.redirect('/'); });


app.post('/add', (req, res) => {
    if (req.body.itemName == '' ||req.body.bpurl == '' || req.body.maxStock == '' || req.body.buy_key == '' || req.body.sell_key == '' || req.body.buy_ref == '' || req.body.sell_ref == '' || req.body.quality == '' || req.body.img == '') {
        error = 'All fields most have a value';
        res.redirect('/');
    } else {
        var itemData = { name: req.body.itemName, quality: req.body.quality, maxStock: req.body.maxStock, buy_key: req.body.buy_key, buy_ref: req.body.buy_ref, sell_key: req.body.sell_key, sell_ref: req.body.sell_ref, img: req.body.img, bpurl: req.body.bpurl };
        connection.query('insert into items set ?', itemData, function(err, result) {
            if (err) { console.error(err); return false; }
            res.redirect('/');
        });
    }
});


app.post('/update', (req, res) => {
    if (req.body.itemName == '' || req.body.maxStock == '' || req.body.buy_key == '' || req.body.sell_key == '' || req.body.buy_ref == '' || req.body.sell_ref == '') {
        error = 'All fields most have a value';
        res.redirect('/');
    } else {
        var item = req.body;
        var query1 = connection.query(`update items set maxStock = ${item.maxStock}, buy_key = ${item.buy_key}, buy_ref = ${item.buy_ref}, sell_key =${item.sell_key}, sell_ref = ${item.sell_ref} where name = ?`, item.itemName, function(err, result) {
            if (err) { console.error(err); return false; }
            res.redirect('/');
        });
    }
});


app.get('/delete/:id', (req, res) => {
    if (req.params.id != parseInt(req.params.id)) {
        error = 'the id must be an integer !';
        res.redirect('/');
    } else {
        var query1 = connection.query(`delete from items where itemId = ?`, req.params.id, function(err, result) {
            if (err) { console.error(err); error = 'there was an error deleting the item'; }
            else { success = "item deleted"; }
            res.redirect('/');
        });
    }
});


app.listen(config.port, function() {
    console.log('Listening on port 3000');
});


// require("./bot.js");