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)
  });
}