/** * * @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; } }