/**
*
* @param Integer $rowId
* @param Array $fromArrayValues
* @param Integer $stationCode
* @param Integer $sensorCode
* @param Integer $sensorCh
* @return Sensor
*/
public static function load(IMETOS $BD, $rowId, $fromArrayValues = false, $stationCode = false, $sensorCode = false, $sensorCh = false)
{
if ($stationCode !== false && $sensorCh !== false && $sensorCode !== false) {
$whereCondition = "\n `f_station_code` = " . (int) $stationCode . "\n AND\n `f_sensor_ch` = " . (int) $sensorCh . "\n AND\n `f_sensor_code` = " . (int) $sensorCode . "\n ";
} else {
$whereCondition = "\n `row_id` = " . (int) $rowId;
}
if (is_array($fromArrayValues)) {
$loadedDataArray = $fromArrayValues;
} else {
//echo "pase por aca 1<br>";
$BD = new IMETOS();
$query = "\n SELECT\n `row_id`,\n `f_station_code`,\n `f_sensor_ch` ,\n `f_sensor_code`,\n `f_chain_code`,\n `f_group_code`,\n `f_unit_code`,\n `f_name`,\n `f_unit`,\n `f_div`,\n `f_mul`,\n `f_val_neg` ,\n `f_val_log` ,\n `f_val_last`,\n `f_val_sum` ,\n `f_val_aver`,\n `f_val_min`,\n `f_val_max`,\n `f_val_time`,\n `f_val_user`,\n `f_create_time`,\n `f_val_axilary`,\n `f_user_app`,\n `f_color`,\n `f_sensor_user_name`,\n `f_user_unit_code`,\n `graph_type`,\n `min_expected`,\n `max_expected` ,\n `custom_name`,\n `custom_desc`,\n `custom_image` ,\n `enable_sensor` ,\n `chilling_hours_related` ,\n `degrees_day_related`,\n `wind_rose_related`,\n `priority`,\n `last_edition_time`,\n `last_update_date`,\n `last_editor`\n FROM\n `seedclima_sensor_info`\n WHERE\n {$whereCondition}\n\n LIMIT 1";
if ($BD->sql_select($query, $result)) {
if ($BD->rowCount() > 0) {
settype($response, 'array');
while ($sensorInfo = $result->fetch(PDO::FETCH_ASSOC)) {
$loadedDataArray = $sensorInfo;
}
}
}
}
if (is_array($loadedDataArray) && count($loadedDataArray) > 0) {
/*
echo "f_name------->{$loadedDataArray['f_name']}<br>";
echo "f_unit------->{$loadedDataArray['f_unit']}<br>";
echo "f_unit_code-->{$loadedDataArray['f_unit_code']}<br>";
*
*/
/*
echo "<pre>";
print_r($loadedDataArray);
echo "</pre>";
*
*/
$sensor = new Sensor($loadedDataArray['row_id'], @$loadedDataArray['f_station_code'], @$loadedDataArray['f_sensor_ch'], @$loadedDataArray['f_sensor_code'], @$loadedDataArray['f_chain_code'], @$loadedDataArray['f_group_code'], @$loadedDataArray['f_unit_code'], @$loadedDataArray['f_name'], @$loadedDataArray['f_unit'], @$loadedDataArray['f_div'], @$loadedDataArray['f_mul'], @$loadedDataArray['f_val_neg'], @$loadedDataArray['f_val_log'], @$loadedDataArray['f_val_last'], @$loadedDataArray['f_val_sum'], @$loadedDataArray['f_val_aver'], @$loadedDataArray['f_val_min'], @$loadedDataArray['f_val_max'], @$loadedDataArray['f_val_time'], @$loadedDataArray['f_val_user'], @$loadedDataArray['f_create_time'], @$loadedDataArray['f_val_axilary'], @$loadedDataArray['f_user_app'], @$loadedDataArray['f_color'], @$loadedDataArray['f_sensor_user_name'], @$loadedDataArray['f_user_unit_code'], @$loadedDataArray['graph_type'], @$loadedDataArray['min_expected'], @$loadedDataArray['max_expected'], @$loadedDataArray['custom_name'], @$loadedDataArray['custom_desc'], @$loadedDataArray['custom_image'], @$loadedDataArray['enable_sensor'], @$loadedDataArray['chilling_hours_related'], @$loadedDataArray['degrees_day_related'], @$loadedDataArray['wind_rose_related'], @$loadedDataArray['priority'], @$loadedDataArray['last_edition_time'], @$loadedDataArray['last_update_date'], @$loadedDataArray['last_editor`']);
return $sensor;
} else {
return false;
}
}
