48 lines
1.5 KiB
JavaScript
48 lines
1.5 KiB
JavaScript
const execQuery = require('../connector');
|
|
const db = require('../connector');
|
|
const express = require('express');
|
|
const router = express.Router();
|
|
|
|
const routes = function () {
|
|
|
|
router.get('/list', (req, res) => {
|
|
execQuery('SELECT * FROM listbooks;', [], req, res);
|
|
});
|
|
|
|
router.get('/listSerials/:idserialslote', (req, res) => {
|
|
const idserialslote = req.params.idserialslote;
|
|
execQuery('CALL serialsByLote (?);', [idserialslote], req, res);
|
|
});
|
|
|
|
router.get('/get/:id', (req, res) => {
|
|
const id = req.params.id;
|
|
execQuery('CALL getBook (?);', [id], req, res);
|
|
});
|
|
|
|
router.post('/create', (req, res) => {
|
|
const form = req.body[0];
|
|
const query = 'CALL generateSerialLote (?, ?, ?, ?);';
|
|
execQuery(query, [form.description, form.amount, form.idcourse, form.createdBy], req, res);
|
|
});
|
|
|
|
router.post('/update', (req, res) => {
|
|
const form = req.body[0];
|
|
const query = 'UPDATE serialslote SET description = ? WHERE id = ?;';
|
|
execQuery(query, [form.description, form.id], req, res);
|
|
});
|
|
|
|
router.delete('/delete/:id', (req, res) => {
|
|
const id = req.params.id;
|
|
execQuery('CALL deleteSerialLote (?);', [id], req, res);
|
|
});
|
|
|
|
router.post('/validateBook', (req, res) => {
|
|
const form = req.body[0];
|
|
const query = 'CALL validateBook (?, ?);';
|
|
execQuery(query, [form.idserial, form.userName], req, res);
|
|
});
|
|
|
|
return router;
|
|
}
|
|
|
|
module.exports = routes; |