/**
*
* @param Integer $f_station_code
* @param Array $fromArrayValues
* @return Station
*/
public static function load(IMETOS $BD, $f_station_code, $fromArrayValues = false, $userid = 0)
{
$loadedDataArray = false;
if (is_array($fromArrayValues)) {
$loadedDataArray = $fromArrayValues;
} else {
$query = "\n SELECT\n `row_id`,\n `f_station_code`,\n `f_date`,\n `f_dev_id`,\n `f_name`,\n `f_descr`,\n `f_info`,\n `f_uid`,\n `f_status`,\n `f_create_time`,\n `f_master_name`,\n `f_date_min`,\n `f_date_max`,\n `f_date_last_down`,\n `f_date_sens`,\n `f_date_data`,\n `f_date_conf`,\n `f_measure_int`,\n `f_data_int`,\n `f_timezone`,\n `f_latitude`,\n `f_longitude`,\n `f_altitude`,\n `f_hw_ver_major`,\n `f_hw_ver_minor`,\n `f_sw_ver_major`,\n `f_sw_ver_minor`,\n `f_sms_warn_numbers`,\n `f_sms_warn_values`,\n `f_gsm_mcc`,\n `f_gsm_mnc`,\n `f_gprs_apn`,\n `f_gprs_user_id`,\n `f_gprs_passw`,\n `f_sernum`,\n `f_date_comm`,\n `f_user_station_name`,\n `f_user_name`,\n `custom_name`,\n `custom_desc`,\n `custom_image`,\n `enable_station`,\n `show_in_home`,\n `priority`,\n `last_update_date`,\n `last_edition_time`,\n `last_editor`\n FROM\n `seedclima_station_info`\n WHERE\n `f_station_code` = {$f_station_code}\n LIMIT 1";
if ($BD->sql_select($query, $result)) {
if ($BD->getRowCount() > 0) {
//settype($response, 'array');
while ($stationInfo = $result->fetch(PDO::FETCH_ASSOC)) {
$loadedDataArray = $stationInfo;
}
}
}
}
if (is_array($loadedDataArray) && count($loadedDataArray) > 0) {
$station = new Station($loadedDataArray['row_id'], $loadedDataArray['f_station_code'], $loadedDataArray['f_date'], $loadedDataArray['f_dev_id'], $loadedDataArray['f_name'], $loadedDataArray['f_descr'], $loadedDataArray['f_info'], $loadedDataArray['f_uid'], $loadedDataArray['f_status'], $loadedDataArray['f_create_time'], $loadedDataArray['f_master_name'], $loadedDataArray['f_date_min'], $loadedDataArray['f_date_max'], $loadedDataArray['f_date_last_down'], $loadedDataArray['f_date_sens'], $loadedDataArray['f_date_data'], $loadedDataArray['f_date_conf'], $loadedDataArray['f_measure_int'], $loadedDataArray['f_data_int'], $loadedDataArray['f_timezone'], $loadedDataArray['f_latitude'], $loadedDataArray['f_longitude'], $loadedDataArray['f_altitude'], $loadedDataArray['f_hw_ver_major'], $loadedDataArray['f_hw_ver_minor'], $loadedDataArray['f_sw_ver_major'], $loadedDataArray['f_sw_ver_minor'], $loadedDataArray['f_sms_warn_numbers'], $loadedDataArray['f_sms_warn_values'], $loadedDataArray['f_gsm_mcc'], $loadedDataArray['f_gsm_mnc'], $loadedDataArray['f_gprs_apn'], $loadedDataArray['f_gprs_user_id'], $loadedDataArray['f_gprs_passw'], $loadedDataArray['f_sernum'], $loadedDataArray['f_date_comm'], $loadedDataArray['f_user_station_name'], $loadedDataArray['f_user_name'], $loadedDataArray['custom_name'], $loadedDataArray['custom_desc'], $loadedDataArray['custom_image'], $loadedDataArray['enable_station'], $loadedDataArray['show_in_home'], $loadedDataArray['priority'], $loadedDataArray['last_update_date'], $loadedDataArray['last_edition_time'], $loadedDataArray['last_editor']);
$station->_setLastDataRetrievedTime($BD);
$station->_setStatusReport();
$station->_setConfig($userid);
// cargo info de configuracion de estacion para la descarga
return $station;
} else {
return false;
}
}
