imagenes.js
1.57 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
const path = require('path')
router.get('/imagenes/:nombre', (req, res) => {
var options = {
root: path.join(__dirname, '/../img'),
dotfiles: 'deny',
headers: {
'x-timestamp': Date.now(),
'x-sent': true
}
}
res.sendFile(req.params.nombre, options, err => {
if (err) console.log(err);
});
});
router.post('/imagenes/guardar', (req, res) => {
let base64 = req.body.base64.split(';base64,').pop();
let path = `${__dirname}/../img/${req.body.name}`;
require('fs').writeFile(path, base64, {encoding: 'base64'} , err => {
if (err) {
console.log(err);
res.status(500).send('Hubo un error');
}
});
knex('ARTICULOS')
.where({
CodArt: req.body.codigo,
CodSec: req.body.sector
})
.then(articulo => {
let idArticulo = articulo[0].id;
knex('ARTICULOS_IMAGEN')
.where('id_articulo', idArticulo)
.del();
knex('ARTICULOS_IMAGEN')
.insert({
id_articulo: idArticulo,
imagen: req.body.name
})
.then(() => {
res.status(200).send({});
})
});
});
router.post('/imagen/borrar', (req, res) => {
let deleted = false
let path = `${__dirname}/../img/${req.body.name}`;
knex('ARTICULOS_IMAGEN')
.where('id_articulo', req.body.id_articulo)
.andWhere('id', req.body.id)
.update({
id_articulo: 0,
})
.then(() => {
try {
require('fs').unlinkSync(path);
deleted = true;
res.status(200).send(deleted);
} catch (err) { }
});
});
module.exports = router;