80 lines
2.8 KiB
JavaScript
80 lines
2.8 KiB
JavaScript
require('../connector');
|
|
const express = require('express');
|
|
const router = express.Router();
|
|
const formidable = require('formidable');
|
|
|
|
var routes = function () {
|
|
|
|
router.get('/getAllNoticias', function (req, res) {
|
|
ExecuteQuery(`SELECT * FROM noticias;`, req, res);
|
|
});
|
|
|
|
router.get('/getNoticiasEn', function (req, res, next) {
|
|
const sqlQuery = `select
|
|
idnoticias,
|
|
titulo,
|
|
descricao,
|
|
CASE WHEN habilitado = 1 THEN 'Sim' ELSE 'Não' END AS habilitado,
|
|
link
|
|
FROM noticias
|
|
WHERE habilitado = 1;`;
|
|
ExecuteQuery(sqlQuery, req, res);
|
|
});
|
|
|
|
router.get('/getNoticiaByID/:idnoticias', function (req, res, next) {
|
|
const idnoticias = req.params.idnoticias;
|
|
const sqlQuery = `SELECT * FROM noticias WHERE idnoticias = ${idnoticias};`;
|
|
ExecuteQuery(sqlQuery, req, res);
|
|
});
|
|
|
|
router.post('/insertNoticias', function (req, res, next) {
|
|
const idnoticias = req.body.idnoticias;
|
|
const titulo = req.body.titulo;
|
|
const descricao = req.body.descricao;
|
|
const habilitado = req.body.habilitado ? 1 : 0;
|
|
const link = req.body.link;
|
|
const sqlQuery = `INSERT INTO noticias (titulo, descricao, habilitado, link)
|
|
VALUES ('${titulo}', '${descricao}', ${habilitado}, '${link}');`;
|
|
ExecuteQuery(sqlQuery, req, res);
|
|
});
|
|
|
|
router.patch('/updateNoticias', function (req, res, next) {
|
|
const idnoticias = req.body.idnoticias;
|
|
const titulo = req.body.titulo;
|
|
const descricao = req.body.descricao;
|
|
const habilitado = req.body.habilitado ? 1 : 0;
|
|
const link = req.body.link;
|
|
const sqlQuery = `update noticias set
|
|
titulo = '${titulo}',
|
|
descricao = '${descricao}',
|
|
habilitado = ${habilitado},
|
|
link = '${link}'
|
|
where idnoticias = ${idnoticias};`;
|
|
ExecuteQuery(sqlQuery, req, res);
|
|
});
|
|
|
|
router.delete('/deleteNoticias/:idnoticias', function (req, res, next) {
|
|
const idnoticias = req.params.idnoticias;
|
|
const sqlQuery = `DELETE FROM noticias WHERE idnoticias = ${idnoticias};`;
|
|
ExecuteQuery(sqlQuery, req, res);
|
|
});
|
|
|
|
router.post('/copy', (req, res) => {
|
|
let form = new formidable.IncomingForm();
|
|
form.maxFileSize = 600 * 1024 * 1024;
|
|
form.parse(req, function(err,fields,files){
|
|
const fs = require('fs');
|
|
var idnoticias = fields.idnoticias;
|
|
var pathImagem = files.imagem.path;
|
|
var dir = '/var/www/html/imagens/noticias/';
|
|
fs.rename(pathImagem, dir + "noticia_" + idnoticias + ".jpg", function (err) {
|
|
console.log("arquivo copiado com sucesso");
|
|
res.send(true);
|
|
});
|
|
});
|
|
});
|
|
|
|
return router;
|
|
}
|
|
|
|
module.exports = routes; |