public static function getInfoForHandler($sensor_id)
{
$sql = "SELECT `t1`.*, `t2`.`code` AS `metric_code`, `t5`.`code` AS `general_metric_code`\n FROM `" . StationSensorFeature::model()->tableName() . "` `t1`\n LEFT JOIN `" . RefbookMetric::model()->tableName() . "` `t2` ON `t2`.`metric_id` = `t1`.`metric_id`\n LEFT JOIN `" . RefbookMeasurementType::model()->tableName() . "` `t3` ON `t3`.`code` = `t1`.`measurement_type_code`\n LEFT JOIN `" . RefbookMeasurementTypeMetric::model()->tableName() . "` `t4` ON `t4`.`measurement_type_id` = `t3`.`measurement_type_id` AND `t4`.`is_main` = 1\n LEFT JOIN `" . RefbookMetric::model()->tableName() . "` `t5` ON `t5`.`metric_id` = `t4`.`metric_id`\n WHERE `t1`.`sensor_id` = ?";
$arr = Yii::app()->db->createCommand($sql)->queryAll(true, array($sensor_id));
foreach ($arr as $val) {
$arr_key[] = $val['feature_code'];
}
return array_combine($arr_key, $arr);
}
public static function getMetrics($measurement_type_code)
{
$return = array();
$sql = "SELECT `t1`.`metric_id`, `t3`.`html_code`, `t3`.`full_name`\n FROM `" . RefbookMeasurementTypeMetric::model()->tableName() . "` `t1`\n LEFT JOIN `" . RefbookMeasurementType::model()->tableName() . "` `t2` ON `t2`.`measurement_type_id` = `t1`.`measurement_type_id`\n LEFT JOIN `" . RefbookMetric::model()->tableName() . "` `t3` ON `t3`.`metric_id` = `t1`.`metric_id`\n WHERE `t2`.`code` = '" . $measurement_type_code . "' \n ORDER BY `t3`.`full_name`";
$res = Yii::app()->db->createCommand($sql)->queryAll();
if ($res) {
foreach ($res as $key => $value) {
$return[$value['metric_id']] = $value['html_code'] . ' (' . $value['full_name'] . ')';
}
}
return $return;
}
/**
* Load metric array.
*
* @access protected
*/
protected function loadMetrics()
{
$this->_metrics = array();
// Loading default sensor metrics
$metricRecords = RefbookMeasurementTypeMetric::model()->with(array('measurement_type', 'metric'))->findByAllAttributes(array('is_main' => 1));
foreach ($metricRecords as $metricRecord) {
$this->_metrics[$metricRecord->measurement_type->code] = $metricRecord->metric->metric_code;
}
// Loading default calculations' metrics
// ToDo: implement this, when need will appear.
// $calculationRecords = CalculationDBHandler::model()->findAll($criteria);
//
// foreach ($calculationRecords as $calculationRecord)
// {
// $this->_metrics[$metricRecord->measurement_type->code] = $metricRecord->metric->metric_code;
// }
}
/**
* List sensor feature are grouped
*
* @return array|null $this->group_sensor_features
*/
public function getGroupSensorsFeaturesList()
{
if (!$this->group_sensor_features) {
$handlers = SensorDBHandler::getHandlers('aws');
$rs_data = array();
if ($handlers) {
$measurement_codes = array();
foreach ($handlers as $handler) {
$sensor_features = SensorHandler::create($handler->handler_id_code)->getAwsGraphFeatures();
foreach ($sensor_features as $v) {
if ($v['measurement_type_code']) {
$measurement_codes[] = $v['measurement_type_code'];
}
}
// get stations
$stations = array();
$station_ids = array();
$cssClass = "";
if (count($handler->sensors)) {
foreach ($handler->sensors as $sensor) {
$station = array();
$station['station_id_code'] = $sensor->station->station_id_code;
$station['station_id'] = $sensor->station->station_id;
$station['color'] = $sensor->station->color;
$stations[$station['station_id']] = $station;
$station_ids[$station['station_id']] = $station['station_id'];
}
$stations = array_values($stations);
$station_ids = array_values($station_ids);
$cssClass = implode('-station ', $station_ids);
$cssClass .= '-station ';
array_multisort($stations, SORT_STRING, $stations);
}
$this->group_sensor_features[$handler->handler_id_code] = ['name' => $handler->display_name, 'sensor_features' => $sensor_features, 'stations' => $stations, 'class' => $cssClass];
}
// Calculates
$this->group_sensor_features['Temperature']['sensor_features']['calc_1'] = ['feature_name' => 'Dew Point, C degree'];
$this->group_sensor_features['Pressure']['sensor_features']['calc_2'] = ['feature_name' => 'Pressure MSL, hPa'];
// Measurement
$sql = "SELECT `t3`.code, `t5`.`short_name`, `t5`.`full_name`\n FROM `" . RefbookMeasurementType::model()->tableName() . "` `t3`\n LEFT JOIN `" . RefbookMeasurementTypeMetric::model()->tableName() . "` `t4` ON `t4`.`measurement_type_id` = `t3`.`measurement_type_id` AND `t4`.`is_main` = 1\n LEFT JOIN `" . RefbookMetric::model()->tableName() . "` `t5` ON `t5`.`metric_id` = `t4`.`metric_id`\n WHERE `t3`.`code` IN ('" . implode("','", $measurement_codes) . "')";
$rs = CStubActiveRecord::getDbConnect(true)->createCommand($sql)->queryAll();
if ($rs) {
$rs_data = CHtml::listData($rs, 'code', 'short_name');
}
$wd_ws_station_params['stations'] = array();
$wd_ws_station_params['class'] = '';
foreach ($this->group_sensor_features as $handler_id_code => &$group) {
if (in_array($handler_id_code, ['WindDirection', 'WindSpeed']) && in_array('WindSpeed', array_keys($this->group_sensor_features)) && in_array('WindDirection', array_keys($this->group_sensor_features))) {
$station_ids_temp = array();
foreach ($wd_ws_station_params['stations'] as $wd_ws_station) {
$station_ids_temp[] = $wd_ws_station['station_id'];
}
foreach ($group['stations'] as $station) {
if (!in_array($station['station_id'], $station_ids_temp)) {
$wd_ws_station_params['stations'][] = $station;
}
}
$station_ids = array();
foreach ($wd_ws_station_params['stations'] as $wd_ws_station) {
$station_ids[] = $wd_ws_station['station_id'];
}
$wd_ws_station_params['class'] = implode('-station ', $station_ids) . '-station ';
}
if (in_array($handler_id_code, ['TemperatureWater', 'TemperatureSoil'])) {
foreach ($group['sensor_features'] as $key => $value) {
$group['sensor_features'][$key] = $group['name'] . ($rs_data[$value['measurement_type_code']] ? ', ' . $rs_data[$value['measurement_type_code']] : '');
}
} else {
foreach ($group['sensor_features'] as $key => $value) {
$group['sensor_features'][$key] = $value['feature_name'] . ($rs_data[$value['measurement_type_code']] ? ', ' . $rs_data[$value['measurement_type_code']] : '');
}
}
}
}
/**
* Load custom sensor feature */
if (count($this->custom_sensor_features)) {
$this->group_sensor_features['custom'] = ['name' => 'Custom', 'sensor_features' => $this->custom_sensor_features, 'stations' => $wd_ws_station_params['stations'], 'class' => $wd_ws_station_params['class']];
}
}
return (array) $this->group_sensor_features;
}
public function actionSetup()
{
$criteria = new CDbCriteria();
$criteria->condition = "ord > 0";
$criteria->order = "ord ASC";
$meas_types = RefbookMeasurementType::model()->findAll($criteria);
if ($meas_types) {
foreach ($meas_types as $key => $value) {
$sql = "SELECT `t1`.`metric_id`, CONCAT(`t2`.`html_code`, ' (', `t2`.`full_name`, ')') AS `name`, `t1`.`is_main`, `t1`.`measurement_type_metric_id`\n FROM `" . RefbookMeasurementTypeMetric::model()->tableName() . "` `t1`\n LEFT JOIN `" . RefbookMetric::model()->tableName() . "` `t2` ON `t2`.`metric_id` = `t1`.`metric_id`\n WHERE `t1`.`measurement_type_id` = '" . $value->measurement_type_id . "'";
$meas_types[$key]->metrics_list = Yii::app()->db->createCommand($sql)->queryAll();
}
}
if (Yii::app()->request->isPostRequest && isset($_POST['main_metric'])) {
foreach ($_POST['main_metric'] as $key => $value) {
if ($meas_types[$key]->metrics_list) {
foreach ($meas_types[$key]->metrics_list as $v1) {
$update = array('is_main' => $v1['metric_id'] == $value ? 1 : 0);
RefbookMeasurementTypeMetric::model()->updateByPk($v1['measurement_type_metric_id'], $update);
}
}
}
StationSensorFeature::updateMetric();
$DB = array('db' => CStubActiveRecord::getDbConnect(), 'db_long' => CStubActiveRecord::getDbConnect(true));
foreach ($DB as $db) {
$db->createCommand("DELETE FROM `" . ScheduleReportProcessed::model()->tableName() . "`")->query();
$db->createCommand("DELETE FROM `" . ForwardedMessage::model()->tableName() . "`")->query();
$db->createCommand("DELETE FROM `" . StationCalculationData::model()->tableName() . "`")->query();
$db->createCommand("DELETE FROM `" . SeaLevelTrend::model()->tableName() . "`")->query();
$db->createCommand("DELETE FROM `" . SensorDataMinute::model()->tableName() . "`")->query();
$db->createCommand("DELETE FROM `" . SensorData::model()->tableName() . "`")->query();
$db->createCommand("DELETE FROM `" . ListenerLog::model()->tableName() . "`")->query();
}
It::memStatus('admin_metrics_saved');
$this->redirect($this->createUrl('admin/setup'));
}
$this->render('setup', array('meas_types' => $meas_types));
}
public function m_0_4_1()
{
@apache_setenv('no-gzip', 1);
@ini_set('zlib.output_compression', 0);
@ini_set('implicit_flush', 1);
ini_set('memory_limit', '-1');
//ob_start();
$this->flushNotification('...Please wait... Updating is going on... DO NOT LEAVE THIS PAGE!');
$this->flushNotification('<br/>...Going to add "is_last" fields to `listener_log` table...');
$res = Yii::app()->db->createCommand("SHOW COLUMNS FROM `" . ListenerLog::model()->tableName() . "` LIKE 'is_last'")->queryAll();
if (!$res) {
Yii::app()->db->createCommand("ALTER TABLE `" . ListenerLog::model()->tableName() . "` ADD `is_last` tinyint(1) NOT NULL DEFAULT '0' AFTER `is_processed`")->query();
Yii::app()->db->createCommand("COMMIT")->query();
$stations = Yii::app()->db->createCommand("SELECT * FROM `" . Station::model()->tableName() . "`")->queryAll();
if ($stations) {
foreach ($stations as $key => $value) {
ListenerLog::updateIsLastForStation($value['station_id']);
}
}
$this->flushNotification(' ... done');
} else {
$this->flushNotification(' ... not need');
}
$this->flushNotification('<br/>...Going to add "is_processing" column to `listener_log` table...');
$res = Yii::app()->db->createCommand("SHOW COLUMNS FROM `" . ListenerLog::model()->tableName() . "` LIKE 'is_processing'")->queryAll();
if (!$res) {
Yii::app()->db->createCommand("ALTER TABLE `" . ListenerLog::model()->tableName() . "` ADD `is_processing` TINYINT(1) NOT NULL DEFAULT '0' AFTER `is_processed`")->query();
Yii::app()->db->createCommand("COMMIT")->query();
$this->flushNotification(' ... done');
} else {
$this->flushNotification(' ... not need');
}
// station
$this->flushNotification('<br/><br/>Station table:');
$this->flushNotification('<br/>...Going to update "national_aws_number" field at `station` table...');
$res = Yii::app()->db->createCommand("SHOW COLUMNS FROM `" . Station::model()->tableName() . "` LIKE 'national_aws_number'")->queryAll();
if ($res[0]['Null'] == 'NO') {
Yii::app()->db->createCommand("ALTER TABLE `station` CHANGE `national_aws_number` `national_aws_number` int(11) DEFAULT '0'")->query();
Yii::app()->db->createCommand("COMMIT")->query();
$this->flushNotification(' ... done');
} else {
$this->flushNotification(' ... not need');
}
$this->flushNotification('<br/>...Going to add new column "country_id" to `station` table...');
$res = Yii::app()->db->createCommand("SHOW COLUMNS FROM `" . Station::model()->tableName() . "` LIKE 'country_id'")->queryAll();
if (!$res) {
Yii::app()->db->createCommand("ALTER TABLE `station` ADD `country_id` int(11) NOT NULL DEFAULT '0' AFTER `magnetic_north_offset`")->query();
Yii::app()->db->createCommand("COMMIT")->query();
$this->flushNotification(' ... done');
} else {
$this->flushNotification(' ... already exists');
}
$this->flushNotification('<br/>...Going to add new column "city_id" to `station` table...');
$res = Yii::app()->db->createCommand("SHOW COLUMNS FROM `" . Station::model()->tableName() . "` LIKE 'city_id'")->queryAll();
if (!$res) {
Yii::app()->db->createCommand("ALTER TABLE `station` ADD `city_id` int(11) NOT NULL DEFAULT '0' AFTER `country_id`")->query();
Yii::app()->db->createCommand("COMMIT")->query();
$this->flushNotification(' ... done');
} else {
$this->flushNotification(' ... already exists');
}
$this->flushNotification('<br/>...Going to add new column "timezone_offset" to `station` table...');
$res = Yii::app()->db->createCommand("SHOW COLUMNS FROM `" . Station::model()->tableName() . "` LIKE 'timezone_offset'")->queryAll();
if (!$res) {
Yii::app()->db->createCommand("ALTER TABLE `station` ADD `timezone_offset` varchar(20) NOT NULL AFTER `timezone_id`")->query();
Yii::app()->db->createCommand("COMMIT")->query();
$this->flushNotification(' ... done');
} else {
$this->flushNotification(' ... already exists');
}
$this->flushNotification('<br/>...Going to update "timezone_offset" data in `station` table...');
$sql = "SELECT `station_id`, `timezone_id` FROM `" . Station::model()->tableName() . "` WHERE `timezone_offset` = ''";
$res = Yii::app()->db->createCommand($sql)->queryAll();
if ($res) {
foreach ($res as $key => $value) {
$sql = "UPDATE `" . Station::model()->tableName() . "` SET `timezone_offset` = '" . TimezoneWork::getOffsetFromUTC($value['timezone_id'], 1) . "' WHERE `station_id` = '" . $value['station_id'] . "'";
Yii::app()->db->createCommand($sql)->query();
}
Yii::app()->db->createCommand("COMMIT")->query();
$this->flushNotification(' ... done');
} else {
$this->flushNotification(' ... not need');
}
$this->flushNotification('<br/>...Going to add new column "awos_msg_source_folder" to `station` table...');
$res = Yii::app()->db->createCommand("SHOW COLUMNS FROM `" . Station::model()->tableName() . "` LIKE 'awos_msg_source_folder'")->queryAll();
if (!$res) {
Yii::app()->db->createCommand("ALTER TABLE `station` ADD `awos_msg_source_folder` TEXT CHARACTER SET ucs2 COLLATE ucs2_general_ci NOT NULL AFTER `city_id`")->query();
Yii::app()->db->createCommand("COMMIT")->query();
$this->flushNotification(' ... done');
} else {
$this->flushNotification(' ... already exists');
}
// Sensor Data
$this->flushNotification('<br/>...Going to update `sensor_data` table\'s data...');
Yii::app()->db->createCommand("UPDATE `sensor_data` SET `period` = 1440 WHERE `period` = 86400")->query();
Yii::app()->db->createCommand("COMMIT")->query();
$this->flushNotification(' ... done');
//Schedule report
$this->flushNotification('<br/>...Going to create `schedule_report` table...');
$tables = array();
$res = Yii::app()->db->createCommand("SHOW TABLES")->queryAll();
if ($res) {
foreach ($res as $key => $value) {
foreach ($value as $k1 => $v1) {
$tables[] = $v1;
}
}
}
if (!in_array('schedule_report', $tables)) {
$sql = "CREATE TABLE `schedule_report` (\n `schedule_id` int(11) NOT NULL AUTO_INCREMENT,\n `report_type` varchar(50) NOT NULL DEFAULT 'synop' COMMENT 'synop, bufr',\n `station_id` int(11) NOT NULL,\n `period` int(11) NOT NULL DEFAULT '60' COMMENT 'in minutes',\n `method` varchar(20) NOT NULL DEFAULT 'email' COMMENT 'email, ftp',\n `destination_email` varchar(255) NOT NULL,\n `destination_ip` varchar(15) NOT NULL,\n `destination_ip_port` int(5) NOT NULL DEFAULT '21',\n `destination_ip_folder` varchar(255) NOT NULL DEFAULT '/',\n `destination_ip_user` varchar(255) NOT NULL,\n `destination_ip_password` varchar(255) NOT NULL,\n `report_format` varchar(20) NOT NULL DEFAULT 'csv' COMMENT 'txt, csv',\n `last_scheduled_run_fact` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',\n `last_scheduled_run_planned` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',\n `created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',\n `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',\n PRIMARY KEY (`schedule_id`)\n ) ENGINE=InnoDB DEFAULT CHARSET=utf8;";
Yii::app()->db->createCommand($sql)->query();
Yii::app()->db->createCommand("COMMIT")->query();
$this->flushNotification(' ... done');
} else {
$this->flushNotification(' ... already exists');
}
$this->flushNotification('<br/>...Going to create `schedule_report_processed` table...');
if (!in_array('schedule_report_processed', $tables)) {
$sql = "CREATE TABLE `schedule_report_processed` (\n `schedule_processed_id` int(11) NOT NULL AUTO_INCREMENT,\n `schedule_id` int(11) NOT NULL,\n `listener_log_id` int(11) NOT NULL,\n `is_processed` tinyint(1) NOT NULL DEFAULT '0',\n `report_string_initial` text NOT NULL,\n `report_string_changed` text NOT NULL,\n `serialized_report_problems` text NOT NULL,\n `serialized_report_errors` text NOT NULL,\n `serialized_report_explanations` text NOT NULL,\n `is_last` tinyint(1) NOT NULL DEFAULT '0',\n `created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',\n `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',\n PRIMARY KEY (`schedule_processed_id`),\n KEY `schedule_id` (`schedule_id`),\n KEY `listener_log_id` (`listener_log_id`),\n CONSTRAINT `schedule_report_processed_fk` FOREIGN KEY (`schedule_id`) REFERENCES `schedule_report` (`schedule_id`) ON DELETE CASCADE ON UPDATE NO ACTION,\n CONSTRAINT `schedule_report_processed_ibfk_1` FOREIGN KEY (`listener_log_id`) REFERENCES `listener_log` (`log_id`) ON DELETE CASCADE ON UPDATE NO ACTION\n ) ENGINE=InnoDB DEFAULT CHARSET=utf8;";
Yii::app()->db->createCommand($sql)->query();
Yii::app()->db->createCommand("COMMIT")->query();
$this->flushNotification(' ... done');
} else {
$this->flushNotification(' ... already exists');
}
// metrics
$this->flushNotification('<br/><br/>New Metrics:');
$this->flushNotification('<br/>...Going to add new metric "kJ/sq.m" ...');
Yii::app()->db->createCommand("INSERT INTO `refbook_metric` (`metric_id`, `html_code`, `short_name`, `full_name`, `code`) VALUES ('21', 'kJ/sq.m', 'kJ/sq.m', 'Kilo Joule per square meter', 'kjoule_per_sq_meter')")->query();
Yii::app()->db->createCommand("COMMIT")->query();
$this->flushNotification(' ... done');
$this->flushNotification('<br/>...Going to add new metric "feet"...');
Yii::app()->db->createCommand("INSERT INTO `refbook_metric` (`metric_id`, `html_code`, `short_name`, `full_name`, `code`) VALUES ('22', 'ft', 'ft', 'Feet', 'feet')")->query();
Yii::app()->db->createCommand("COMMIT")->query();
$this->flushNotification(' ... done');
$this->flushNotification('<br/>...Going to add new metric "km"...');
Yii::app()->db->createCommand("INSERT INTO `refbook_metric` (`metric_id`,`html_code`,`short_name`,`full_name`,`code`) VALUES (23 , 'km', 'km', 'Kilometer', 'kilometer')")->query();
Yii::app()->db->createCommand("COMMIT")->query();
$this->flushNotification(' ... done');
$this->flushNotification('<br/>...Going to add new relation between "solar radiation" and "kj/sq.m"...');
RefbookMeasurementTypeMetric::model()->deleteByPk(23);
Yii::app()->db->createCommand("INSERT INTO `refbook_measurement_type_metric` (`measurement_type_metric_id`, `measurement_type_id`, `metric_id`, `is_main`) VALUES ('23', '9', '21', '0')")->query();
Yii::app()->db->createCommand("COMMIT")->query();
$this->flushNotification(' ... done');
$this->flushNotification('<br/>...Going to add new measuring type "Cloud Vertical Visibility"...');
Yii::app()->db->createCommand("INSERT INTO `refbook_measurement_type` (`measurement_type_id`, `display_name`, `code`, `ord`) VALUES (16 ,'Cloud Vertical Visibility', 'cloud_vertical_visibility', '14')")->query();
Yii::app()->db->createCommand("COMMIT")->query();
$this->flushNotification(' ... done');
$this->flushNotification('<br/>...Going to add new measuring type "Cloud Height" ...');
Yii::app()->db->createCommand("INSERT INTO `refbook_measurement_type` (`measurement_type_id`, `display_name`, `code`, `ord`) VALUES (17, 'Cloud Height', 'cloud_height', 15)")->query();
Yii::app()->db->createCommand("COMMIT")->query();
$this->flushNotification(' ... done');
$this->flushNotification('<br/>...Going to add new measuring type "Sea Level" ...');
Yii::app()->db->createCommand("INSERT INTO `refbook_measurement_type` (`measurement_type_id`, `display_name`, `code`, `ord`) VALUES (18 , 'Sea Level (Mean, Sigma, Wave Hight)', 'sea_level', '16')")->query();
Yii::app()->db->createCommand("COMMIT")->query();
$this->flushNotification(' ... done');
$this->flushNotification('<br/>...Going to add relation between "Cloud Vertical Visibility" and "ft" ...');
Yii::app()->db->createCommand("INSERT INTO `refbook_measurement_type_metric` (`measurement_type_metric_id`, `measurement_type_id`, `metric_id`, `is_main`) VALUES (24,16,22,1)")->query();
Yii::app()->db->createCommand("COMMIT")->query();
$this->flushNotification(' ... done');
$this->flushNotification('<br/>...Going to add new relation between "Cloud Vertical Visibility" and "meter"...');
Yii::app()->db->createCommand("INSERT INTO `refbook_measurement_type_metric` (`measurement_type_metric_id`, `measurement_type_id`, `metric_id`, `is_main`) VALUES (25,16,11,0)")->query();
Yii::app()->db->createCommand("COMMIT")->query();
$this->flushNotification(' ... done');
$this->flushNotification('<br/>...Going to add new relation between "Cloud Height" and "ft"...');
Yii::app()->db->createCommand("INSERT INTO `refbook_measurement_type_metric` (`measurement_type_metric_id`, `measurement_type_id`, `metric_id`, `is_main`) VALUES (26,17,22,1)")->query();
Yii::app()->db->createCommand("COMMIT")->query();
$this->flushNotification(' ... done');
$this->flushNotification('<br/>...Going to add new relation between "Cloud Height" and "meter"...');
Yii::app()->db->createCommand("INSERT INTO `refbook_measurement_type_metric` (`measurement_type_metric_id`, `measurement_type_id`, `metric_id`, `is_main`) VALUES (27,17,11,0)")->query();
Yii::app()->db->createCommand("COMMIT")->query();
$this->flushNotification(' ... done');
$this->flushNotification('<br/>...Going to add new relation between "Visibility" and "meter"...');
Yii::app()->db->createCommand("INSERT INTO `refbook_measurement_type_metric` (`measurement_type_metric_id`, `measurement_type_id`, `metric_id`, `is_main`) VALUES (28, 11, 11, 1)")->query();
Yii::app()->db->createCommand("COMMIT")->query();
$this->flushNotification(' ... done');
$this->flushNotification('<br/>...Going to add new relation between "Sea Level" and "meter"...');
Yii::app()->db->createCommand("INSERT INTO `refbook_measurement_type_metric` (`measurement_type_metric_id`, `measurement_type_id`, `metric_id`, `is_main`) VALUES (29, 18, 11, 1)")->query();
Yii::app()->db->createCommand("COMMIT")->query();
$this->flushNotification(' ... done');
// sensor handler
$this->flushNotification('<br/>...Going to add new column "awos_station_uses" to `sensor_handler` table...');
$res = Yii::app()->db->createCommand("SHOW COLUMNS FROM `sensor_handler` LIKE 'awos_station_uses'")->queryAll();
if (!$res) {
$res = Yii::app()->db->createCommand("ALTER TABLE `sensor_handler` ADD `awos_station_uses` TINYINT( 1 ) NOT NULL DEFAULT '0'")->query();
Yii::app()->db->createCommand("COMMIT")->query();
$this->flushNotification(' ... done');
} else {
$this->flushNotification(' ... already exists');
}
$this->flushNotification('<br/>...Going to update `sensor_handler` table...');
$sql = "UPDATE `sensor_handler` SET \n `handler_id_code` = 'SeaLevelAWS',\n `display_name` = 'Sea Level and Tide Data',\n `description` = 'Handler \"Sea Level and Tide Data\" : Processes string like \"SL1XXXXYYYYZZZZ\", where <br/>SL1 - device Id; <br/>XXXX - Mean value;<br/>YYYY - Sigma value; <br/>ZZZZ - Wave Height <br/>Example: SL1179017900140 = SL1 sensor sent data: Mean value = 1.79, Sigma value = 1.79, Wave height = 140m.',\n `default_prefix` = 'SL',\n `aws_station_uses` = 1,\n `rain_station_uses` = 0,\n `awos_station_uses` = 0,\n `aws_single_group` = 'sea_level'\n WHERE `handler_id` = 13";
Yii::app()->db->createCommand($sql)->query();
Yii::app()->db->createCommand("COMMIT")->query();
$sql = "UPDATE `sensor_handler` SET \n `handler_id_code` = 'VisibilityAWS',\n `display_name` = 'Visibility',\n `description` = 'Handler \"Visibility\"',\n `default_prefix` = 'VI',\n `aws_station_uses` = 1,\n `rain_station_uses` = 0,\n `awos_station_uses` = 0,\n `aws_single_group` = 'visibility'\n WHERE `handler_id` = 14";
Yii::app()->db->createCommand($sql)->query();
Yii::app()->db->createCommand("COMMIT")->query();
$sql = "UPDATE `sensor_handler` SET `handler_id_code` = 'CloudHeightAWS',\n `display_name` = 'Cloud Height',\n `description` = 'Handler \"Cloud Height\"',\n `default_prefix` = 'CH',\n `aws_station_uses` = 1,\n `rain_station_uses` = 0,\n `awos_station_uses` = 0,\n `aws_single_group` = 'clouds'\n WHERE `handler_id` = 15";
Yii::app()->db->createCommand($sql)->query();
Yii::app()->db->createCommand("COMMIT")->query();
$this->flushNotification(' ... done');
$this->flushNotification('<br/>...Going to update calculation_handler table...');
$res = Yii::app()->db->createCommand("UPDATE `calculation_handler` SET `display_name` = 'Pressure Adjusted to MSL' WHERE `handler_id` = 2");
Yii::app()->db->createCommand("COMMIT")->query();
$this->flushNotification(' ... done');
$bat_path = dirname(Yii::app()->request->scriptFile) . DIRECTORY_SEPARATOR . 'files' . DIRECTORY_SEPARATOR . 'at' . DIRECTORY_SEPARATOR . 'schedule.bat';
$schedule_bat_content = getConfigValue('php_exe_path') . " -f " . dirname(Yii::app()->request->scriptFile) . DIRECTORY_SEPARATOR . "console.php schedule";
file_put_contents($bat_path, $schedule_bat_content);
exec('schtasks /create /sc minute /mo 1 /F /ru "SYSTEM" /tn delaircoScheduleScript /tr ' . $bat_path, $output);
$values = getConfigValue('schedule');
$values['each_minute_process_id'] = 'delaircoScheduleScript';
InstallConfig::setConfigSection('schedule', $values);
$values = getConfigValue('path');
$values['site_url_for_console'] = It::baseUrl();
InstallConfig::setConfigSection('path', $values);
It::memStatus('update__success');
$this->flushNotification('<script type="text/javascript"> setTimeout(function(){document.location.href="' . Yii::app()->controller->createUrl('update/index') . '"}, 10000)</script>');
}