66 lines
2.1 KiB
JavaScript
66 lines
2.1 KiB
JavaScript
const express = require('express');
|
|
const api = express.Router();
|
|
const fs = require('fs');
|
|
|
|
require('dotenv').config();
|
|
//mysql
|
|
var mysql = require('mysql2');
|
|
var con = mysql.createConnection({
|
|
host: process.env.MYSQLHOST,
|
|
user: process.env.MYSQLUSER,
|
|
password: process.env.MYSQLPASS,
|
|
port : process.env.MYSQLPORT,
|
|
database: process.env.MYSQLDB,
|
|
insecureAuth : true
|
|
});
|
|
con.connect(function(err) {
|
|
if (err) throw err;
|
|
console.log('Connected!');
|
|
});
|
|
var bodyParser = require('body-parser');
|
|
const {makeid} = require('./func.js');
|
|
|
|
api.use(bodyParser.json());
|
|
|
|
api.post("/loginPanel", function(req, res) {
|
|
var login = req.body.login;
|
|
var password = req.body.password;
|
|
|
|
con.query("SELECT * FROM login WHERE login = ? AND haslo = SHA1(?)", [login, password], function(err, result) {
|
|
//jeżeli znajdziesz wygeneruj token i zapamiętaj go w bazie
|
|
if (result.length > 0) {
|
|
var token = makeid(64);
|
|
con.query("INSERT INTO tokeny (token, typ, userId) VALUES (?, 1, ?)", [token, result[0].id], function(err, result) {
|
|
res.send({response: "Zalogowano", token: token});
|
|
});
|
|
} else {
|
|
res.send(403, {response: "Błędne dane logowania"});
|
|
}
|
|
});
|
|
});
|
|
|
|
api.post("/loginLiczacy", function(req, res) {
|
|
var qr = req.body.qr;
|
|
con.query("SELECT * FROM liczacy WHERE qr = ? AND aktywne = 1", [qr], function(err, result) {
|
|
if(result.length > 0) {
|
|
var token = makeid(64);
|
|
con.query("INSERT INTO tokenyLiczacy (token, typ, userId) VALUES (?, 1, ?)", [token, result[0].id], function(err, result) {
|
|
res.send({response: "Zalogowano", token: token});
|
|
});
|
|
} else {
|
|
res.send(403, {response: "Błędny kod QR"});
|
|
}
|
|
});
|
|
});
|
|
|
|
const apiPanel = require('./apiPanel.js');
|
|
api.use('/panel', apiPanel);
|
|
|
|
const apiLiczacy = require('./apiLiczacy.js');
|
|
api.use('/liczacy', apiLiczacy);
|
|
|
|
api.all('*', function(req, res) {
|
|
res.send(404, {response: "Nie znaleziono"});
|
|
});
|
|
|
|
module.exports = api; |