Advertisement
Marcelo1979

Untitled

Nov 6th, 2017
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.77 KB | None | 0 0
  1. function buscarIDauto(id_gps, done) {
  2.  
  3. var valor = "";
  4.  
  5. var sql = " SELECT Concat(Coalesce(marca_veh, '-'), ',', Coalesce(modelo_veh, '-'), ',', ";
  6. sql = sql + " Coalesce( ";
  7. sql = sql + " placa_veh, '-'), ',', Coalesce(id_auto, '-')) AS campo1 ";
  8. sql = sql + " FROM vehiculos ";
  9. sql = sql + " WHERE id_gps = '" + id_gps + "' ";
  10. sql = sql + " LIMIT 1 ";
  11.  
  12. //var devolver = "";
  13.  
  14. selectGen(sql, function (err, res) {
  15. if (err) console.error(err);
  16. //console.log(res);
  17.  
  18. //devolver = res;
  19.  
  20. //return res;
  21.  
  22. return done(null, res);
  23. });
  24.  
  25. //return devolver;
  26. }
  27.  
  28. function selectGen(callback) {
  29.  
  30. var sql = " SELECT marca_veh as campo1 FROM vehiculos limit 1 ";
  31.  
  32.  
  33. var con = mysql.createConnection({
  34. host: properties.get('main.db.param.host'),
  35. user: properties.get('main.db.param.user'),
  36. password: properties.get('main.db.param.password'),
  37. database: properties.get('main.db.param.database'),
  38. connectTimeout: parseInt(properties.get('main.db.param.connectTimeout'))
  39. });
  40.  
  41. con.connect(function (err) {
  42.  
  43. if (err) {
  44. console.log("ERROR ON CONNECT DB MYSQL :" + err);
  45. return callback(err);
  46. }
  47.  
  48. con.query(sql, function (err, result, fields) {
  49.  
  50. if (err) {
  51. console.log("ERROR ON QUERY " + sql + " DB MYSQL :" + err);
  52. return callback(err);
  53. }
  54.  
  55. if (result.length > 0) {
  56. //console.log("result[0].campo1 :" + result[0].campo1);
  57. stuff_i_want = result[0].campo1;
  58. return callback("calbback ok :"+result[0].campo1);
  59. } else {
  60. stuff_i_want = '';
  61. return callback('');
  62. }
  63.  
  64. });
  65.  
  66. });
  67.  
  68. }
  69.  
  70. var stuff_i_want = '';
  71. global.varBuscarIDauto = "";
  72.  
  73. selectGen(function (result) {
  74. stuff_i_want = result;
  75. console.log("result " + result);
  76. global.varBuscarIDauto = result;
  77.  
  78. return "return: "+result;
  79. //rest of your code goes in here
  80. });
  81.  
  82. var a = selectGen();
  83. console.log("AAAA :"+ a);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement