/**
*
* @param Integer $filterByStationCode
* @param Integer $filterBySensorCode
* @param Integer $filterBySensorChannel
* @param Integer $filterByStatus 0|1
* @return Array
*/
public static function getAll(IMETOS $BD, $filterByStationCode = null, $filterBySensorCode = null, $filterBySensorChannel = null, $filterByStatus = null, array $filterById = null)
{
settype($response, 'array');
settype($filters, 'array');
if (isset($filterById)) {
$filterById = implode(',', $filterById);
$filters[] = " `row_id` IN ({$filterById})";
}
if (isset($filterByStationCode)) {
$filters[] = " `f_station_code` = '{$filterByStationCode}'";
}
if (isset($filterBySensorCode)) {
$filters[] = " `f_sensor_code` = '{$filterBySensorCode}'";
}
if (isset($filterBySensorChannel)) {
$filters[] = " `f_sensor_ch` = '{$filterBySensorChannel}'";
}
if (isset($filterByStatus)) {
$filters[] = " `enable_sensor` = '{$filterByStatus}'";
}
$whereCondition = count($filters) > 0 ? 'WHERE ' . implode(' AND ', $filters) : '';
$query = "\n SELECT *\n FROM `seedclima_sensor_info`\n {$whereCondition} \n ORDER BY `priority`,`custom_name`,`f_sensor_user_name`";
//echo "pase por aca 2<br>";
//$BD=new IMETOS();
if ($BD->sql_select($query, $result)) {
if ($BD->getRowCount() > 0) {
while ($sensorInfo = $result->fetch(PDO::FETCH_ASSOC)) {
$sensor = Sensor::load($BD, null, $sensorInfo);
$response[$sensor->getSensorCode() . '_' . $sensor->getSensorCh()] = $sensor;
}
}
return $response;
}
return false;
}
/**
*
*/
private function _setLastDataRetrievedTime(IMETOS $BD)
{
$query = "\n SELECT\n MAX(`last_read_time`) as 'last_read_time'\n FROM\n `seedclima_station_data_retrieve_info`\n WHERE\n `f_station_code` = {$this->getStationCode()}";
if ($BD->sql_select($query, $results)) {
if ($BD->getRowCount() > 0) {
$row = $results->fetch(PDO::FETCH_ASSOC);
$this->_lastDataRetrievedTime = $row['last_read_time'];
} else {
$this->_lastDataRetrievedTime = false;
}
}
}
