24 lines
840 B
JavaScript
24 lines
840 B
JavaScript
exports.choixZone = function(zones){
|
|
var zone = zones[0];
|
|
var aireMin = (zones[0].Nord-zones[0].Sud)*(zones[0].Est-zones[0].Ouest)
|
|
for(var i = 1;i<zones.length;i++)
|
|
{
|
|
var aire = (zones[i].Nord-zones[i].Sud)*(zones[i].Est-zones[i].Ouest)
|
|
if(aire<aireMin){
|
|
zone = zones[i];
|
|
aireMin = aire;
|
|
}
|
|
}
|
|
return zone;
|
|
}
|
|
|
|
exports.listPubDansZone = function(zone, callback){
|
|
var con = require('./bdd.js')
|
|
con.query("SELECT * FROM com_active INNER JOIN zone ON com_active.ID_Zone = zone.ID_Zone INNER JOIN communication ON com_active.ID_Com = communication.ID_Com WHERE zone.ID_Zone = ? ", [zone], function(err, result){
|
|
var data = JSON.stringify(result);
|
|
console.log("BLA "+data+ "_____RESULT_____"+result+"___"+[zone]);
|
|
data = JSON.parse(data);
|
|
callback(err, data)
|
|
});
|
|
}
|