/**
*
* @param desde
* @param numeroElementos
*/
public function cargar($desde = 0, $numeroElementos = 0)
{
if ($this->_idUsuario) {
$db = FabricaBaseDatos::crear();
$select = $db->select()->from('v_usuario_area')->limit($numeroElementos, $desde)->where('id_usuario = ?', $this->_idUsuario);
$rows = $db->fetchAll($select);
foreach ($rows as $row) {
$unArea = new Area($row['id_area']);
$unArea->set_nombre($row['nombre_area']);
$unArea->set_descripcion($row['descripcion_area']);
$this->_areas->add($unArea);
}
}
return true;
}
$found = true;
break;
}
}
if (!$found) {
$ar = new Area();
array_push($this->arrayOfAreas, $ar->setData($x, $y, $width, $height)->addMeasurement(0));
}
}
}
function toString()
{
$table = '<table cellspacing="0"><tr> <th>Noise Intensity</th></tr>';
foreach ($this->arrayOfAreas as $area) {
$table .= "\n" . '<tr>' . "<td data-x=\"{$area->x}\" data-y=\"{$area->y}\" data-width=\"{$area->width}\"" . "data-height=\"{$area->height}\" >{$area->noiseavg}</td>" . '</tr>';
}
$table .= '</table>';
echo $table;
}
}
$db = new FFDB();
$aps = simplexml_load_file('aps.xml');
if ($db->open("noisepoints")) {
$bssid = "bssid";
$noise = "noise";
$timestamp = "timestamp";
$arrayofareas = new Areas();
$unknowns = array();
// 369235 = 2 hours
// time()*1000
list($usec, $sec) = explode(" ", microtime());
array_push($this->arrayOfAreas, $ar->setData($x, $y)->addMeasurement($noise));
}
return $this;
}
function toString()
{
$measurements = "";
foreach ($this->arrayOfAreas as $area) {
$decibel = $area->noiseavg + 40;
// adds reference value -40dB for silence to make values positive
if ($this->max < $decibel) {
$this->max = $decibel;
}
// the maximum between the averages
$x = $area->x;
$y = $area->y;
$measurements = $measurements . "{x: {$x}, y: {$y}, count: {$decibel}},\n";
}
return $measurements;
}
}
$db = new FFDB();
$aps = simplexml_load_file('aps.xml');
if ($db->open("noisepoints")) {
$bssid = "bssid";
$noise = "noise";
$timestamp = "timestamp";
// TODO: avg over the same area to reduce network IO
$textarea = "<textarea id=\"data\">{";
$measurements = "data: [\n";
$arrayofareas = new Areas();
$ar = new Area();
array_push($this->arrayOfAreas, $ar->setData($x, $y)->addMeasurement($noise));
}
return $this;
}
function toString()
{
$measurements = "";
foreach ($this->arrayOfAreas as $area) {
$decibel = $area->noiseavg + 40;
// adds reference value -40dB for silence to make values positive
if ($this->max < $decibel) {
$this->max = $decibel;
}
// the maximum between the averages
$x = $area->x;
$y = $area->y;
$measurements = $measurements . "{x: {$x}, y: {$y}, count: {$decibel}},\n";
}
return $measurements;
}
}
$ar = new Areas();
$ar->add(24, 34, -30);
$ar->add(24, 34, -60);
//var_dump($ar);
echo $ar->toString();
?>
</body>
</html>
