Guest User

Untitled

a guest
Oct 20th, 2017
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.97 KB | None | 0 0
  1. app.post('/usersacces/add', function (req,res) {
  2. var response = [];
  3.  
  4. if (typeof req.body.alias!== 'undefined' &&typeof req.body.nom!== 'undefined' ) {
  5. var alias = req.body.alias, nom = req.body.nom;
  6.  
  7. connection.query('INSERT INTO administration_users_niveaux_acces (alias, nom) VALUES (?, ?)',
  8. [alias, nom],
  9. function(err, result) {
  10. if (!err){
  11.  
  12. if (result.affectedRows != 0) {
  13. response.push({'result' : 'success'});
  14.  
  15. } else {
  16. response.push({'msg' : 'No Result Found'});
  17. }
  18. // When a client connects, we note it in the console
  19. io.sockets.on('connection', function (socket) {
  20. socket.emit('message', 'You are connected!');
  21. console.log('message '+ 'You are connected!');
  22. });
  23. res.setHeader('Content-Type', 'application/json');
  24. res.status(200).send(JSON.stringify(response));
  25. } else {
  26. res.status(400).send(err);
  27. }
  28. });
  29.  
  30. } else {
  31. response.push({'result' : 'error', 'msg' : 'Please fill required details'});
  32. res.setHeader('Content-Type', 'application/json');
  33. res.status(200).send(JSON.stringify(response));
  34. }
  35. });
  36.  
  37. socket.on('message', function(message) {
  38. var databa = [];
  39. $.ajax({
  40. url: '/usersacces'
  41. })
  42. .done(function(data) {
  43. for (var i = 0, len = data[0].items.length; i < len; i++) {
  44. var e1 = data[0].items[i].id;
  45. databa.push(e1);
  46. }
  47. myChart.data.datasets[0].data = databa;
  48. myChart.update();
  49. }).always(function() {
  50. console.log(1);
  51.  
  52. });
  53.  
  54. console.log('The server has a message for you: ' + message);
  55. });
Add Comment
Please, Sign In to add comment