GetUserAuthentication()->applyIdentityToConnectionOptions($result); return $result; } // OnBeforePageExecute event handler class iot_uc502_geoluxPage extends Page { protected function DoBeforeCreate() { $this->SetTitle('Uc502 Geolux'); $this->SetMenuLabel('Uc502 Geolux'); $this->dataset = new TableDataset( PgConnectionFactory::getInstance(), GetConnectionOptions(), '"iot"."uc502_geolux"'); $this->dataset->addFields( array( new DateTimeField('time'), new StringField('device_name'), new StringField('display_name'), new StringField('description'), new StringField('profile_name'), new StringField('application'), new StringField('gateway'), new StringField('instantaneous_speed'), new StringField('averaged_speed'), new StringField('tilt_angle'), new IntegerField('flow_direction'), new IntegerField('relative_signal'), new StringField('instantaneous_snr256'), new IntegerField('instantaneous_snr'), new IntegerField('calculated_water_discharge_integer'), new StringField('calculated_water_discharge_decimal'), new IntegerField('distance_to_water_surface_integer'), new StringField('distance_to_water_surface_decimal'), new IntegerField('measured_water_level_integer'), new StringField('measured_water_level_decimal'), new StringField('level_sensor_snr'), new IntegerField('cross_section_area_integer'), new StringField('cross_section_area_decimal'), new StringField('payload_object'), new StringField('rx_info'), new IntegerField('lora_rssi'), new IntegerField('lora_snr'), new StringField('deduplication_id', false, true) ) ); } protected function DoPrepare() { } protected function CreatePageNavigator() { $result = new CompositePageNavigator($this); $partitionNavigator = new PageNavigator('pnav', $this, $this->dataset); $partitionNavigator->SetRowsPerPage(20); $result->AddPageNavigator($partitionNavigator); return $result; } protected function CreateRssGenerator() { return null; } protected function setupCharts() { } protected function getFiltersColumns() { return array( new FilterColumn($this->dataset, 'time', 'time', 'Time'), new FilterColumn($this->dataset, 'device_name', 'device_name', 'Device Name'), new FilterColumn($this->dataset, 'display_name', 'display_name', 'Display Name'), new FilterColumn($this->dataset, 'description', 'description', 'Description'), new FilterColumn($this->dataset, 'profile_name', 'profile_name', 'Profile Name'), new FilterColumn($this->dataset, 'application', 'application', 'Application'), new FilterColumn($this->dataset, 'gateway', 'gateway', 'Gateway'), new FilterColumn($this->dataset, 'instantaneous_speed', 'instantaneous_speed', 'Instantaneous Speed'), new FilterColumn($this->dataset, 'averaged_speed', 'averaged_speed', 'Averaged Speed'), new FilterColumn($this->dataset, 'tilt_angle', 'tilt_angle', 'Tilt Angle'), new FilterColumn($this->dataset, 'flow_direction', 'flow_direction', 'Flow Direction'), new FilterColumn($this->dataset, 'relative_signal', 'relative_signal', 'Relative Signal'), new FilterColumn($this->dataset, 'instantaneous_snr256', 'instantaneous_snr256', 'Instantaneous Snr256'), new FilterColumn($this->dataset, 'instantaneous_snr', 'instantaneous_snr', 'Instantaneous Snr'), new FilterColumn($this->dataset, 'calculated_water_discharge_integer', 'calculated_water_discharge_integer', 'Calculated Water Discharge Integer'), new FilterColumn($this->dataset, 'calculated_water_discharge_decimal', 'calculated_water_discharge_decimal', 'Calculated Water Discharge Decimal'), new FilterColumn($this->dataset, 'distance_to_water_surface_integer', 'distance_to_water_surface_integer', 'Distance To Water Surface Integer'), new FilterColumn($this->dataset, 'distance_to_water_surface_decimal', 'distance_to_water_surface_decimal', 'Distance To Water Surface Decimal'), new FilterColumn($this->dataset, 'measured_water_level_integer', 'measured_water_level_integer', 'Measured Water Level Integer'), new FilterColumn($this->dataset, 'measured_water_level_decimal', 'measured_water_level_decimal', 'Measured Water Level Decimal'), new FilterColumn($this->dataset, 'level_sensor_snr', 'level_sensor_snr', 'Level Sensor Snr'), new FilterColumn($this->dataset, 'cross_section_area_integer', 'cross_section_area_integer', 'Cross Section Area Integer'), new FilterColumn($this->dataset, 'cross_section_area_decimal', 'cross_section_area_decimal', 'Cross Section Area Decimal'), new FilterColumn($this->dataset, 'payload_object', 'payload_object', 'Payload Object'), new FilterColumn($this->dataset, 'rx_info', 'rx_info', 'Rx Info'), new FilterColumn($this->dataset, 'lora_rssi', 'lora_rssi', 'Lora Rssi'), new FilterColumn($this->dataset, 'lora_snr', 'lora_snr', 'Lora Snr'), new FilterColumn($this->dataset, 'deduplication_id', 'deduplication_id', 'Deduplication Id') ); } protected function setupQuickFilter(QuickFilter $quickFilter, FixedKeysArray $columns) { $quickFilter ->addColumn($columns['time']) ->addColumn($columns['device_name']) ->addColumn($columns['display_name']) ->addColumn($columns['description']) ->addColumn($columns['profile_name']) ->addColumn($columns['application']) ->addColumn($columns['gateway']) ->addColumn($columns['instantaneous_speed']) ->addColumn($columns['averaged_speed']) ->addColumn($columns['tilt_angle']) ->addColumn($columns['flow_direction']) ->addColumn($columns['relative_signal']) ->addColumn($columns['instantaneous_snr256']) ->addColumn($columns['instantaneous_snr']) ->addColumn($columns['calculated_water_discharge_integer']) ->addColumn($columns['calculated_water_discharge_decimal']) ->addColumn($columns['distance_to_water_surface_integer']) ->addColumn($columns['distance_to_water_surface_decimal']) ->addColumn($columns['measured_water_level_integer']) ->addColumn($columns['measured_water_level_decimal']) ->addColumn($columns['level_sensor_snr']) ->addColumn($columns['cross_section_area_integer']) ->addColumn($columns['cross_section_area_decimal']) ->addColumn($columns['lora_rssi']) ->addColumn($columns['lora_snr']) ->addColumn($columns['deduplication_id']); } protected function setupColumnFilter(ColumnFilter $columnFilter) { $columnFilter ->setOptionsFor('time'); } protected function setupFilterBuilder(FilterBuilder $filterBuilder, FixedKeysArray $columns) { $main_editor = new DateTimeEdit('time_edit', false, 'Y-m-d H:i:s'); $filterBuilder->addColumn( $columns['time'], array( FilterConditionOperator::EQUALS => $main_editor, FilterConditionOperator::DOES_NOT_EQUAL => $main_editor, FilterConditionOperator::IS_GREATER_THAN => $main_editor, FilterConditionOperator::IS_GREATER_THAN_OR_EQUAL_TO => $main_editor, FilterConditionOperator::IS_LESS_THAN => $main_editor, FilterConditionOperator::IS_LESS_THAN_OR_EQUAL_TO => $main_editor, FilterConditionOperator::IS_BETWEEN => $main_editor, FilterConditionOperator::IS_NOT_BETWEEN => $main_editor, FilterConditionOperator::DATE_EQUALS => $main_editor, FilterConditionOperator::DATE_DOES_NOT_EQUAL => $main_editor, FilterConditionOperator::TODAY => null, FilterConditionOperator::IS_BLANK => null, FilterConditionOperator::IS_NOT_BLANK => null ) ); $main_editor = new TextEdit('device_name'); $filterBuilder->addColumn( $columns['device_name'], array( FilterConditionOperator::EQUALS => $main_editor, FilterConditionOperator::DOES_NOT_EQUAL => $main_editor, FilterConditionOperator::IS_GREATER_THAN => $main_editor, FilterConditionOperator::IS_GREATER_THAN_OR_EQUAL_TO => $main_editor, FilterConditionOperator::IS_LESS_THAN => $main_editor, FilterConditionOperator::IS_LESS_THAN_OR_EQUAL_TO => $main_editor, FilterConditionOperator::IS_BETWEEN => $main_editor, FilterConditionOperator::IS_NOT_BETWEEN => $main_editor, FilterConditionOperator::CONTAINS => $main_editor, FilterConditionOperator::DOES_NOT_CONTAIN => $main_editor, FilterConditionOperator::BEGINS_WITH => $main_editor, FilterConditionOperator::ENDS_WITH => $main_editor, FilterConditionOperator::IS_LIKE => $main_editor, FilterConditionOperator::IS_NOT_LIKE => $main_editor, FilterConditionOperator::IS_BLANK => null, FilterConditionOperator::IS_NOT_BLANK => null ) ); $main_editor = new TextEdit('display_name_edit'); $main_editor->SetMaxLength(100); $filterBuilder->addColumn( $columns['display_name'], array( FilterConditionOperator::EQUALS => $main_editor, FilterConditionOperator::DOES_NOT_EQUAL => $main_editor, FilterConditionOperator::IS_GREATER_THAN => $main_editor, FilterConditionOperator::IS_GREATER_THAN_OR_EQUAL_TO => $main_editor, FilterConditionOperator::IS_LESS_THAN => $main_editor, FilterConditionOperator::IS_LESS_THAN_OR_EQUAL_TO => $main_editor, FilterConditionOperator::IS_BETWEEN => $main_editor, FilterConditionOperator::IS_NOT_BETWEEN => $main_editor, FilterConditionOperator::CONTAINS => $main_editor, FilterConditionOperator::DOES_NOT_CONTAIN => $main_editor, FilterConditionOperator::BEGINS_WITH => $main_editor, FilterConditionOperator::ENDS_WITH => $main_editor, FilterConditionOperator::IS_LIKE => $main_editor, FilterConditionOperator::IS_NOT_LIKE => $main_editor, FilterConditionOperator::IS_BLANK => null, FilterConditionOperator::IS_NOT_BLANK => null ) ); $main_editor = new TextEdit('description'); $filterBuilder->addColumn( $columns['description'], array( FilterConditionOperator::EQUALS => $main_editor, FilterConditionOperator::DOES_NOT_EQUAL => $main_editor, FilterConditionOperator::IS_GREATER_THAN => $main_editor, FilterConditionOperator::IS_GREATER_THAN_OR_EQUAL_TO => $main_editor, FilterConditionOperator::IS_LESS_THAN => $main_editor, FilterConditionOperator::IS_LESS_THAN_OR_EQUAL_TO => $main_editor, FilterConditionOperator::IS_BETWEEN => $main_editor, FilterConditionOperator::IS_NOT_BETWEEN => $main_editor, FilterConditionOperator::CONTAINS => $main_editor, FilterConditionOperator::DOES_NOT_CONTAIN => $main_editor, FilterConditionOperator::BEGINS_WITH => $main_editor, FilterConditionOperator::ENDS_WITH => $main_editor, FilterConditionOperator::IS_LIKE => $main_editor, FilterConditionOperator::IS_NOT_LIKE => $main_editor, FilterConditionOperator::IS_BLANK => null, FilterConditionOperator::IS_NOT_BLANK => null ) ); $main_editor = new TextEdit('profile_name_edit'); $main_editor->SetMaxLength(100); $filterBuilder->addColumn( $columns['profile_name'], array( FilterConditionOperator::EQUALS => $main_editor, FilterConditionOperator::DOES_NOT_EQUAL => $main_editor, FilterConditionOperator::IS_GREATER_THAN => $main_editor, FilterConditionOperator::IS_GREATER_THAN_OR_EQUAL_TO => $main_editor, FilterConditionOperator::IS_LESS_THAN => $main_editor, FilterConditionOperator::IS_LESS_THAN_OR_EQUAL_TO => $main_editor, FilterConditionOperator::IS_BETWEEN => $main_editor, FilterConditionOperator::IS_NOT_BETWEEN => $main_editor, FilterConditionOperator::CONTAINS => $main_editor, FilterConditionOperator::DOES_NOT_CONTAIN => $main_editor, FilterConditionOperator::BEGINS_WITH => $main_editor, FilterConditionOperator::ENDS_WITH => $main_editor, FilterConditionOperator::IS_LIKE => $main_editor, FilterConditionOperator::IS_NOT_LIKE => $main_editor, FilterConditionOperator::IS_BLANK => null, FilterConditionOperator::IS_NOT_BLANK => null ) ); $main_editor = new TextEdit('application_edit'); $main_editor->SetMaxLength(100); $filterBuilder->addColumn( $columns['application'], array( FilterConditionOperator::EQUALS => $main_editor, FilterConditionOperator::DOES_NOT_EQUAL => $main_editor, FilterConditionOperator::IS_GREATER_THAN => $main_editor, FilterConditionOperator::IS_GREATER_THAN_OR_EQUAL_TO => $main_editor, FilterConditionOperator::IS_LESS_THAN => $main_editor, FilterConditionOperator::IS_LESS_THAN_OR_EQUAL_TO => $main_editor, FilterConditionOperator::IS_BETWEEN => $main_editor, FilterConditionOperator::IS_NOT_BETWEEN => $main_editor, FilterConditionOperator::CONTAINS => $main_editor, FilterConditionOperator::DOES_NOT_CONTAIN => $main_editor, FilterConditionOperator::BEGINS_WITH => $main_editor, FilterConditionOperator::ENDS_WITH => $main_editor, FilterConditionOperator::IS_LIKE => $main_editor, FilterConditionOperator::IS_NOT_LIKE => $main_editor, FilterConditionOperator::IS_BLANK => null, FilterConditionOperator::IS_NOT_BLANK => null ) ); $main_editor = new TextEdit('gateway_edit'); $main_editor->SetMaxLength(100); $filterBuilder->addColumn( $columns['gateway'], array( FilterConditionOperator::EQUALS => $main_editor, FilterConditionOperator::DOES_NOT_EQUAL => $main_editor, FilterConditionOperator::IS_GREATER_THAN => $main_editor, FilterConditionOperator::IS_GREATER_THAN_OR_EQUAL_TO => $main_editor, FilterConditionOperator::IS_LESS_THAN => $main_editor, FilterConditionOperator::IS_LESS_THAN_OR_EQUAL_TO => $main_editor, FilterConditionOperator::IS_BETWEEN => $main_editor, FilterConditionOperator::IS_NOT_BETWEEN => $main_editor, FilterConditionOperator::CONTAINS => $main_editor, FilterConditionOperator::DOES_NOT_CONTAIN => $main_editor, FilterConditionOperator::BEGINS_WITH => $main_editor, FilterConditionOperator::ENDS_WITH => $main_editor, FilterConditionOperator::IS_LIKE => $main_editor, FilterConditionOperator::IS_NOT_LIKE => $main_editor, FilterConditionOperator::IS_BLANK => null, FilterConditionOperator::IS_NOT_BLANK => null ) ); $main_editor = new TextEdit('instantaneous_speed_edit'); $filterBuilder->addColumn( $columns['instantaneous_speed'], array( FilterConditionOperator::EQUALS => $main_editor, FilterConditionOperator::DOES_NOT_EQUAL => $main_editor, FilterConditionOperator::IS_GREATER_THAN => $main_editor, FilterConditionOperator::IS_GREATER_THAN_OR_EQUAL_TO => $main_editor, FilterConditionOperator::IS_LESS_THAN => $main_editor, FilterConditionOperator::IS_LESS_THAN_OR_EQUAL_TO => $main_editor, FilterConditionOperator::IS_BETWEEN => $main_editor, FilterConditionOperator::IS_NOT_BETWEEN => $main_editor, FilterConditionOperator::CONTAINS => $main_editor, FilterConditionOperator::DOES_NOT_CONTAIN => $main_editor, FilterConditionOperator::BEGINS_WITH => $main_editor, FilterConditionOperator::ENDS_WITH => $main_editor, FilterConditionOperator::IS_LIKE => $main_editor, FilterConditionOperator::IS_NOT_LIKE => $main_editor, FilterConditionOperator::IS_BLANK => null, FilterConditionOperator::IS_NOT_BLANK => null ) ); $main_editor = new TextEdit('averaged_speed_edit'); $filterBuilder->addColumn( $columns['averaged_speed'], array( FilterConditionOperator::EQUALS => $main_editor, FilterConditionOperator::DOES_NOT_EQUAL => $main_editor, FilterConditionOperator::IS_GREATER_THAN => $main_editor, FilterConditionOperator::IS_GREATER_THAN_OR_EQUAL_TO => $main_editor, FilterConditionOperator::IS_LESS_THAN => $main_editor, FilterConditionOperator::IS_LESS_THAN_OR_EQUAL_TO => $main_editor, FilterConditionOperator::IS_BETWEEN => $main_editor, FilterConditionOperator::IS_NOT_BETWEEN => $main_editor, FilterConditionOperator::CONTAINS => $main_editor, FilterConditionOperator::DOES_NOT_CONTAIN => $main_editor, FilterConditionOperator::BEGINS_WITH => $main_editor, FilterConditionOperator::ENDS_WITH => $main_editor, FilterConditionOperator::IS_LIKE => $main_editor, FilterConditionOperator::IS_NOT_LIKE => $main_editor, FilterConditionOperator::IS_BLANK => null, FilterConditionOperator::IS_NOT_BLANK => null ) ); $main_editor = new TextEdit('tilt_angle_edit'); $filterBuilder->addColumn( $columns['tilt_angle'], array( FilterConditionOperator::EQUALS => $main_editor, FilterConditionOperator::DOES_NOT_EQUAL => $main_editor, FilterConditionOperator::IS_GREATER_THAN => $main_editor, FilterConditionOperator::IS_GREATER_THAN_OR_EQUAL_TO => $main_editor, FilterConditionOperator::IS_LESS_THAN => $main_editor, FilterConditionOperator::IS_LESS_THAN_OR_EQUAL_TO => $main_editor, FilterConditionOperator::IS_BETWEEN => $main_editor, FilterConditionOperator::IS_NOT_BETWEEN => $main_editor, FilterConditionOperator::CONTAINS => $main_editor, FilterConditionOperator::DOES_NOT_CONTAIN => $main_editor, FilterConditionOperator::BEGINS_WITH => $main_editor, FilterConditionOperator::ENDS_WITH => $main_editor, FilterConditionOperator::IS_LIKE => $main_editor, FilterConditionOperator::IS_NOT_LIKE => $main_editor, FilterConditionOperator::IS_BLANK => null, FilterConditionOperator::IS_NOT_BLANK => null ) ); $main_editor = new TextEdit('flow_direction_edit'); $filterBuilder->addColumn( $columns['flow_direction'], array( FilterConditionOperator::EQUALS => $main_editor, FilterConditionOperator::DOES_NOT_EQUAL => $main_editor, FilterConditionOperator::IS_GREATER_THAN => $main_editor, FilterConditionOperator::IS_GREATER_THAN_OR_EQUAL_TO => $main_editor, FilterConditionOperator::IS_LESS_THAN => $main_editor, FilterConditionOperator::IS_LESS_THAN_OR_EQUAL_TO => $main_editor, FilterConditionOperator::IS_BETWEEN => $main_editor, FilterConditionOperator::IS_NOT_BETWEEN => $main_editor, FilterConditionOperator::IS_BLANK => null, FilterConditionOperator::IS_NOT_BLANK => null ) ); $main_editor = new TextEdit('relative_signal_edit'); $filterBuilder->addColumn( $columns['relative_signal'], array( FilterConditionOperator::EQUALS => $main_editor, FilterConditionOperator::DOES_NOT_EQUAL => $main_editor, FilterConditionOperator::IS_GREATER_THAN => $main_editor, FilterConditionOperator::IS_GREATER_THAN_OR_EQUAL_TO => $main_editor, FilterConditionOperator::IS_LESS_THAN => $main_editor, FilterConditionOperator::IS_LESS_THAN_OR_EQUAL_TO => $main_editor, FilterConditionOperator::IS_BETWEEN => $main_editor, FilterConditionOperator::IS_NOT_BETWEEN => $main_editor, FilterConditionOperator::IS_BLANK => null, FilterConditionOperator::IS_NOT_BLANK => null ) ); $main_editor = new TextEdit('instantaneous_snr256_edit'); $filterBuilder->addColumn( $columns['instantaneous_snr256'], array( FilterConditionOperator::EQUALS => $main_editor, FilterConditionOperator::DOES_NOT_EQUAL => $main_editor, FilterConditionOperator::IS_GREATER_THAN => $main_editor, FilterConditionOperator::IS_GREATER_THAN_OR_EQUAL_TO => $main_editor, FilterConditionOperator::IS_LESS_THAN => $main_editor, FilterConditionOperator::IS_LESS_THAN_OR_EQUAL_TO => $main_editor, FilterConditionOperator::IS_BETWEEN => $main_editor, FilterConditionOperator::IS_NOT_BETWEEN => $main_editor, FilterConditionOperator::CONTAINS => $main_editor, FilterConditionOperator::DOES_NOT_CONTAIN => $main_editor, FilterConditionOperator::BEGINS_WITH => $main_editor, FilterConditionOperator::ENDS_WITH => $main_editor, FilterConditionOperator::IS_LIKE => $main_editor, FilterConditionOperator::IS_NOT_LIKE => $main_editor, FilterConditionOperator::IS_BLANK => null, FilterConditionOperator::IS_NOT_BLANK => null ) ); $main_editor = new TextEdit('instantaneous_snr_edit'); $filterBuilder->addColumn( $columns['instantaneous_snr'], array( FilterConditionOperator::EQUALS => $main_editor, FilterConditionOperator::DOES_NOT_EQUAL => $main_editor, FilterConditionOperator::IS_GREATER_THAN => $main_editor, FilterConditionOperator::IS_GREATER_THAN_OR_EQUAL_TO => $main_editor, FilterConditionOperator::IS_LESS_THAN => $main_editor, FilterConditionOperator::IS_LESS_THAN_OR_EQUAL_TO => $main_editor, FilterConditionOperator::IS_BETWEEN => $main_editor, FilterConditionOperator::IS_NOT_BETWEEN => $main_editor, FilterConditionOperator::IS_BLANK => null, FilterConditionOperator::IS_NOT_BLANK => null ) ); $main_editor = new TextEdit('calculated_water_discharge_integer_edit'); $filterBuilder->addColumn( $columns['calculated_water_discharge_integer'], array( FilterConditionOperator::EQUALS => $main_editor, FilterConditionOperator::DOES_NOT_EQUAL => $main_editor, FilterConditionOperator::IS_GREATER_THAN => $main_editor, FilterConditionOperator::IS_GREATER_THAN_OR_EQUAL_TO => $main_editor, FilterConditionOperator::IS_LESS_THAN => $main_editor, FilterConditionOperator::IS_LESS_THAN_OR_EQUAL_TO => $main_editor, FilterConditionOperator::IS_BETWEEN => $main_editor, FilterConditionOperator::IS_NOT_BETWEEN => $main_editor, FilterConditionOperator::IS_BLANK => null, FilterConditionOperator::IS_NOT_BLANK => null ) ); $main_editor = new TextEdit('calculated_water_discharge_decimal_edit'); $filterBuilder->addColumn( $columns['calculated_water_discharge_decimal'], array( FilterConditionOperator::EQUALS => $main_editor, FilterConditionOperator::DOES_NOT_EQUAL => $main_editor, FilterConditionOperator::IS_GREATER_THAN => $main_editor, FilterConditionOperator::IS_GREATER_THAN_OR_EQUAL_TO => $main_editor, FilterConditionOperator::IS_LESS_THAN => $main_editor, FilterConditionOperator::IS_LESS_THAN_OR_EQUAL_TO => $main_editor, FilterConditionOperator::IS_BETWEEN => $main_editor, FilterConditionOperator::IS_NOT_BETWEEN => $main_editor, FilterConditionOperator::CONTAINS => $main_editor, FilterConditionOperator::DOES_NOT_CONTAIN => $main_editor, FilterConditionOperator::BEGINS_WITH => $main_editor, FilterConditionOperator::ENDS_WITH => $main_editor, FilterConditionOperator::IS_LIKE => $main_editor, FilterConditionOperator::IS_NOT_LIKE => $main_editor, FilterConditionOperator::IS_BLANK => null, FilterConditionOperator::IS_NOT_BLANK => null ) ); $main_editor = new TextEdit('distance_to_water_surface_integer_edit'); $filterBuilder->addColumn( $columns['distance_to_water_surface_integer'], array( FilterConditionOperator::EQUALS => $main_editor, FilterConditionOperator::DOES_NOT_EQUAL => $main_editor, FilterConditionOperator::IS_GREATER_THAN => $main_editor, FilterConditionOperator::IS_GREATER_THAN_OR_EQUAL_TO => $main_editor, FilterConditionOperator::IS_LESS_THAN => $main_editor, FilterConditionOperator::IS_LESS_THAN_OR_EQUAL_TO => $main_editor, FilterConditionOperator::IS_BETWEEN => $main_editor, FilterConditionOperator::IS_NOT_BETWEEN => $main_editor, FilterConditionOperator::IS_BLANK => null, FilterConditionOperator::IS_NOT_BLANK => null ) ); $main_editor = new TextEdit('distance_to_water_surface_decimal_edit'); $filterBuilder->addColumn( $columns['distance_to_water_surface_decimal'], array( FilterConditionOperator::EQUALS => $main_editor, FilterConditionOperator::DOES_NOT_EQUAL => $main_editor, FilterConditionOperator::IS_GREATER_THAN => $main_editor, FilterConditionOperator::IS_GREATER_THAN_OR_EQUAL_TO => $main_editor, FilterConditionOperator::IS_LESS_THAN => $main_editor, FilterConditionOperator::IS_LESS_THAN_OR_EQUAL_TO => $main_editor, FilterConditionOperator::IS_BETWEEN => $main_editor, FilterConditionOperator::IS_NOT_BETWEEN => $main_editor, FilterConditionOperator::CONTAINS => $main_editor, FilterConditionOperator::DOES_NOT_CONTAIN => $main_editor, FilterConditionOperator::BEGINS_WITH => $main_editor, FilterConditionOperator::ENDS_WITH => $main_editor, FilterConditionOperator::IS_LIKE => $main_editor, FilterConditionOperator::IS_NOT_LIKE => $main_editor, FilterConditionOperator::IS_BLANK => null, FilterConditionOperator::IS_NOT_BLANK => null ) ); $main_editor = new TextEdit('measured_water_level_integer_edit'); $filterBuilder->addColumn( $columns['measured_water_level_integer'], array( FilterConditionOperator::EQUALS => $main_editor, FilterConditionOperator::DOES_NOT_EQUAL => $main_editor, FilterConditionOperator::IS_GREATER_THAN => $main_editor, FilterConditionOperator::IS_GREATER_THAN_OR_EQUAL_TO => $main_editor, FilterConditionOperator::IS_LESS_THAN => $main_editor, FilterConditionOperator::IS_LESS_THAN_OR_EQUAL_TO => $main_editor, FilterConditionOperator::IS_BETWEEN => $main_editor, FilterConditionOperator::IS_NOT_BETWEEN => $main_editor, FilterConditionOperator::IS_BLANK => null, FilterConditionOperator::IS_NOT_BLANK => null ) ); $main_editor = new TextEdit('measured_water_level_decimal_edit'); $filterBuilder->addColumn( $columns['measured_water_level_decimal'], array( FilterConditionOperator::EQUALS => $main_editor, FilterConditionOperator::DOES_NOT_EQUAL => $main_editor, FilterConditionOperator::IS_GREATER_THAN => $main_editor, FilterConditionOperator::IS_GREATER_THAN_OR_EQUAL_TO => $main_editor, FilterConditionOperator::IS_LESS_THAN => $main_editor, FilterConditionOperator::IS_LESS_THAN_OR_EQUAL_TO => $main_editor, FilterConditionOperator::IS_BETWEEN => $main_editor, FilterConditionOperator::IS_NOT_BETWEEN => $main_editor, FilterConditionOperator::CONTAINS => $main_editor, FilterConditionOperator::DOES_NOT_CONTAIN => $main_editor, FilterConditionOperator::BEGINS_WITH => $main_editor, FilterConditionOperator::ENDS_WITH => $main_editor, FilterConditionOperator::IS_LIKE => $main_editor, FilterConditionOperator::IS_NOT_LIKE => $main_editor, FilterConditionOperator::IS_BLANK => null, FilterConditionOperator::IS_NOT_BLANK => null ) ); $main_editor = new TextEdit('level_sensor_snr_edit'); $filterBuilder->addColumn( $columns['level_sensor_snr'], array( FilterConditionOperator::EQUALS => $main_editor, FilterConditionOperator::DOES_NOT_EQUAL => $main_editor, FilterConditionOperator::IS_GREATER_THAN => $main_editor, FilterConditionOperator::IS_GREATER_THAN_OR_EQUAL_TO => $main_editor, FilterConditionOperator::IS_LESS_THAN => $main_editor, FilterConditionOperator::IS_LESS_THAN_OR_EQUAL_TO => $main_editor, FilterConditionOperator::IS_BETWEEN => $main_editor, FilterConditionOperator::IS_NOT_BETWEEN => $main_editor, FilterConditionOperator::CONTAINS => $main_editor, FilterConditionOperator::DOES_NOT_CONTAIN => $main_editor, FilterConditionOperator::BEGINS_WITH => $main_editor, FilterConditionOperator::ENDS_WITH => $main_editor, FilterConditionOperator::IS_LIKE => $main_editor, FilterConditionOperator::IS_NOT_LIKE => $main_editor, FilterConditionOperator::IS_BLANK => null, FilterConditionOperator::IS_NOT_BLANK => null ) ); $main_editor = new TextEdit('cross_section_area_integer_edit'); $filterBuilder->addColumn( $columns['cross_section_area_integer'], array( FilterConditionOperator::EQUALS => $main_editor, FilterConditionOperator::DOES_NOT_EQUAL => $main_editor, FilterConditionOperator::IS_GREATER_THAN => $main_editor, FilterConditionOperator::IS_GREATER_THAN_OR_EQUAL_TO => $main_editor, FilterConditionOperator::IS_LESS_THAN => $main_editor, FilterConditionOperator::IS_LESS_THAN_OR_EQUAL_TO => $main_editor, FilterConditionOperator::IS_BETWEEN => $main_editor, FilterConditionOperator::IS_NOT_BETWEEN => $main_editor, FilterConditionOperator::IS_BLANK => null, FilterConditionOperator::IS_NOT_BLANK => null ) ); $main_editor = new TextEdit('cross_section_area_decimal_edit'); $filterBuilder->addColumn( $columns['cross_section_area_decimal'], array( FilterConditionOperator::EQUALS => $main_editor, FilterConditionOperator::DOES_NOT_EQUAL => $main_editor, FilterConditionOperator::IS_GREATER_THAN => $main_editor, FilterConditionOperator::IS_GREATER_THAN_OR_EQUAL_TO => $main_editor, FilterConditionOperator::IS_LESS_THAN => $main_editor, FilterConditionOperator::IS_LESS_THAN_OR_EQUAL_TO => $main_editor, FilterConditionOperator::IS_BETWEEN => $main_editor, FilterConditionOperator::IS_NOT_BETWEEN => $main_editor, FilterConditionOperator::CONTAINS => $main_editor, FilterConditionOperator::DOES_NOT_CONTAIN => $main_editor, FilterConditionOperator::BEGINS_WITH => $main_editor, FilterConditionOperator::ENDS_WITH => $main_editor, FilterConditionOperator::IS_LIKE => $main_editor, FilterConditionOperator::IS_NOT_LIKE => $main_editor, FilterConditionOperator::IS_BLANK => null, FilterConditionOperator::IS_NOT_BLANK => null ) ); $main_editor = new TextEdit('lora_rssi_edit'); $filterBuilder->addColumn( $columns['lora_rssi'], array( FilterConditionOperator::EQUALS => $main_editor, FilterConditionOperator::DOES_NOT_EQUAL => $main_editor, FilterConditionOperator::IS_GREATER_THAN => $main_editor, FilterConditionOperator::IS_GREATER_THAN_OR_EQUAL_TO => $main_editor, FilterConditionOperator::IS_LESS_THAN => $main_editor, FilterConditionOperator::IS_LESS_THAN_OR_EQUAL_TO => $main_editor, FilterConditionOperator::IS_BETWEEN => $main_editor, FilterConditionOperator::IS_NOT_BETWEEN => $main_editor, FilterConditionOperator::IS_BLANK => null, FilterConditionOperator::IS_NOT_BLANK => null ) ); $main_editor = new TextEdit('lora_snr_edit'); $filterBuilder->addColumn( $columns['lora_snr'], array( FilterConditionOperator::EQUALS => $main_editor, FilterConditionOperator::DOES_NOT_EQUAL => $main_editor, FilterConditionOperator::IS_GREATER_THAN => $main_editor, FilterConditionOperator::IS_GREATER_THAN_OR_EQUAL_TO => $main_editor, FilterConditionOperator::IS_LESS_THAN => $main_editor, FilterConditionOperator::IS_LESS_THAN_OR_EQUAL_TO => $main_editor, FilterConditionOperator::IS_BETWEEN => $main_editor, FilterConditionOperator::IS_NOT_BETWEEN => $main_editor, FilterConditionOperator::IS_BLANK => null, FilterConditionOperator::IS_NOT_BLANK => null ) ); $main_editor = new TextEdit('deduplication_id_edit'); $filterBuilder->addColumn( $columns['deduplication_id'], array( FilterConditionOperator::EQUALS => $main_editor, FilterConditionOperator::DOES_NOT_EQUAL => $main_editor, FilterConditionOperator::IS_GREATER_THAN => $main_editor, FilterConditionOperator::IS_GREATER_THAN_OR_EQUAL_TO => $main_editor, FilterConditionOperator::IS_LESS_THAN => $main_editor, FilterConditionOperator::IS_LESS_THAN_OR_EQUAL_TO => $main_editor, FilterConditionOperator::IS_BETWEEN => $main_editor, FilterConditionOperator::IS_NOT_BETWEEN => $main_editor, FilterConditionOperator::CONTAINS => $main_editor, FilterConditionOperator::DOES_NOT_CONTAIN => $main_editor, FilterConditionOperator::BEGINS_WITH => $main_editor, FilterConditionOperator::ENDS_WITH => $main_editor, FilterConditionOperator::IS_LIKE => $main_editor, FilterConditionOperator::IS_NOT_LIKE => $main_editor, FilterConditionOperator::IS_BLANK => null, FilterConditionOperator::IS_NOT_BLANK => null ) ); } protected function AddOperationsColumns(Grid $grid) { $actions = $grid->getActions(); $actions->setCaption($this->GetLocalizerCaptions()->GetMessageString('Actions')); $actions->setPosition(ActionList::POSITION_LEFT); if ($this->GetSecurityInfo()->HasViewGrant()) { $operation = new LinkOperation($this->GetLocalizerCaptions()->GetMessageString('View'), OPERATION_VIEW, $this->dataset, $grid); $operation->setUseImage(true); $actions->addOperation($operation); } } protected function AddFieldColumns(Grid $grid, $withDetails = true) { // // View column for time field // $column = new DateTimeViewColumn('time', 'time', 'Time', $this->dataset); $column->SetOrderable(true); $column->SetDateTimeFormat('Y-m-d H:i:s'); $column->setMinimalVisibility(ColumnVisibility::PHONE); $grid->AddViewColumn($column); // // View column for device_name field // $column = new TextViewColumn('device_name', 'device_name', 'Device Name', $this->dataset); $column->SetOrderable(true); $column->SetMaxLength(75); $column->setMinimalVisibility(ColumnVisibility::PHONE); $grid->AddViewColumn($column); // // View column for display_name field // $column = new TextViewColumn('display_name', 'display_name', 'Display Name', $this->dataset); $column->SetOrderable(true); $column->SetMaxLength(75); $column->setMinimalVisibility(ColumnVisibility::PHONE); $grid->AddViewColumn($column); // // View column for description field // $column = new TextViewColumn('description', 'description', 'Description', $this->dataset); $column->SetOrderable(true); $column->SetMaxLength(75); $column->setMinimalVisibility(ColumnVisibility::PHONE); $grid->AddViewColumn($column); // // View column for profile_name field // $column = new TextViewColumn('profile_name', 'profile_name', 'Profile Name', $this->dataset); $column->SetOrderable(true); $column->SetMaxLength(75); $column->setMinimalVisibility(ColumnVisibility::PHONE); $grid->AddViewColumn($column); // // View column for application field // $column = new TextViewColumn('application', 'application', 'Application', $this->dataset); $column->SetOrderable(true); $column->SetMaxLength(75); $column->setMinimalVisibility(ColumnVisibility::PHONE); $grid->AddViewColumn($column); // // View column for gateway field // $column = new TextViewColumn('gateway', 'gateway', 'Gateway', $this->dataset); $column->SetOrderable(true); $column->SetMaxLength(75); $column->setMinimalVisibility(ColumnVisibility::PHONE); $grid->AddViewColumn($column); // // View column for instantaneous_speed field // $column = new TextViewColumn('instantaneous_speed', 'instantaneous_speed', 'Instantaneous Speed', $this->dataset); $column->SetOrderable(true); $column->setMinimalVisibility(ColumnVisibility::PHONE); $grid->AddViewColumn($column); // // View column for averaged_speed field // $column = new TextViewColumn('averaged_speed', 'averaged_speed', 'Averaged Speed', $this->dataset); $column->SetOrderable(true); $column->setMinimalVisibility(ColumnVisibility::PHONE); $grid->AddViewColumn($column); // // View column for tilt_angle field // $column = new TextViewColumn('tilt_angle', 'tilt_angle', 'Tilt Angle', $this->dataset); $column->SetOrderable(true); $column->setMinimalVisibility(ColumnVisibility::PHONE); $grid->AddViewColumn($column); // // View column for flow_direction field // $column = new NumberViewColumn('flow_direction', 'flow_direction', 'Flow Direction', $this->dataset); $column->SetOrderable(true); $column->setNumberAfterDecimal(0); $column->setThousandsSeparator(','); $column->setDecimalSeparator(''); $column->setMinimalVisibility(ColumnVisibility::PHONE); $grid->AddViewColumn($column); // // View column for relative_signal field // $column = new NumberViewColumn('relative_signal', 'relative_signal', 'Relative Signal', $this->dataset); $column->SetOrderable(true); $column->setNumberAfterDecimal(0); $column->setThousandsSeparator(','); $column->setDecimalSeparator(''); $column->setMinimalVisibility(ColumnVisibility::PHONE); $grid->AddViewColumn($column); // // View column for instantaneous_snr256 field // $column = new TextViewColumn('instantaneous_snr256', 'instantaneous_snr256', 'Instantaneous Snr256', $this->dataset); $column->SetOrderable(true); $column->setMinimalVisibility(ColumnVisibility::PHONE); $grid->AddViewColumn($column); // // View column for instantaneous_snr field // $column = new NumberViewColumn('instantaneous_snr', 'instantaneous_snr', 'Instantaneous Snr', $this->dataset); $column->SetOrderable(true); $column->setNumberAfterDecimal(4); $column->setThousandsSeparator(','); $column->setDecimalSeparator('.'); $column->setMinimalVisibility(ColumnVisibility::PHONE); $grid->AddViewColumn($column); // // View column for calculated_water_discharge_integer field // $column = new NumberViewColumn('calculated_water_discharge_integer', 'calculated_water_discharge_integer', 'Calculated Water Discharge Integer', $this->dataset); $column->SetOrderable(true); $column->setNumberAfterDecimal(0); $column->setThousandsSeparator(','); $column->setDecimalSeparator(''); $column->setMinimalVisibility(ColumnVisibility::PHONE); $grid->AddViewColumn($column); // // View column for calculated_water_discharge_decimal field // $column = new TextViewColumn('calculated_water_discharge_decimal', 'calculated_water_discharge_decimal', 'Calculated Water Discharge Decimal', $this->dataset); $column->SetOrderable(true); $column->setMinimalVisibility(ColumnVisibility::PHONE); $grid->AddViewColumn($column); // // View column for distance_to_water_surface_integer field // $column = new NumberViewColumn('distance_to_water_surface_integer', 'distance_to_water_surface_integer', 'Distance To Water Surface Integer', $this->dataset); $column->SetOrderable(true); $column->setNumberAfterDecimal(0); $column->setThousandsSeparator(','); $column->setDecimalSeparator(''); $column->setMinimalVisibility(ColumnVisibility::PHONE); $grid->AddViewColumn($column); // // View column for distance_to_water_surface_decimal field // $column = new TextViewColumn('distance_to_water_surface_decimal', 'distance_to_water_surface_decimal', 'Distance To Water Surface Decimal', $this->dataset); $column->SetOrderable(true); $column->setMinimalVisibility(ColumnVisibility::PHONE); $grid->AddViewColumn($column); // // View column for measured_water_level_integer field // $column = new NumberViewColumn('measured_water_level_integer', 'measured_water_level_integer', 'Measured Water Level Integer', $this->dataset); $column->SetOrderable(true); $column->setNumberAfterDecimal(0); $column->setThousandsSeparator(','); $column->setDecimalSeparator(''); $column->setMinimalVisibility(ColumnVisibility::PHONE); $grid->AddViewColumn($column); // // View column for measured_water_level_decimal field // $column = new TextViewColumn('measured_water_level_decimal', 'measured_water_level_decimal', 'Measured Water Level Decimal', $this->dataset); $column->SetOrderable(true); $column->setMinimalVisibility(ColumnVisibility::PHONE); $grid->AddViewColumn($column); // // View column for level_sensor_snr field // $column = new TextViewColumn('level_sensor_snr', 'level_sensor_snr', 'Level Sensor Snr', $this->dataset); $column->SetOrderable(true); $column->setMinimalVisibility(ColumnVisibility::PHONE); $grid->AddViewColumn($column); // // View column for cross_section_area_integer field // $column = new NumberViewColumn('cross_section_area_integer', 'cross_section_area_integer', 'Cross Section Area Integer', $this->dataset); $column->SetOrderable(true); $column->setNumberAfterDecimal(0); $column->setThousandsSeparator(','); $column->setDecimalSeparator(''); $column->setMinimalVisibility(ColumnVisibility::PHONE); $grid->AddViewColumn($column); // // View column for cross_section_area_decimal field // $column = new TextViewColumn('cross_section_area_decimal', 'cross_section_area_decimal', 'Cross Section Area Decimal', $this->dataset); $column->SetOrderable(true); $column->setMinimalVisibility(ColumnVisibility::PHONE); $grid->AddViewColumn($column); // // View column for lora_rssi field // $column = new NumberViewColumn('lora_rssi', 'lora_rssi', 'Lora Rssi', $this->dataset); $column->SetOrderable(true); $column->setNumberAfterDecimal(4); $column->setThousandsSeparator(','); $column->setDecimalSeparator('.'); $column->setMinimalVisibility(ColumnVisibility::PHONE); $grid->AddViewColumn($column); // // View column for lora_snr field // $column = new NumberViewColumn('lora_snr', 'lora_snr', 'Lora Snr', $this->dataset); $column->SetOrderable(true); $column->setNumberAfterDecimal(4); $column->setThousandsSeparator(','); $column->setDecimalSeparator('.'); $column->setMinimalVisibility(ColumnVisibility::PHONE); $grid->AddViewColumn($column); } protected function AddSingleRecordViewColumns(Grid $grid) { // // View column for time field // $column = new DateTimeViewColumn('time', 'time', 'Time', $this->dataset); $column->SetOrderable(true); $column->SetDateTimeFormat('Y-m-d H:i:s'); $grid->AddSingleRecordViewColumn($column); // // View column for device_name field // $column = new TextViewColumn('device_name', 'device_name', 'Device Name', $this->dataset); $column->SetOrderable(true); $column->SetMaxLength(75); $grid->AddSingleRecordViewColumn($column); // // View column for display_name field // $column = new TextViewColumn('display_name', 'display_name', 'Display Name', $this->dataset); $column->SetOrderable(true); $column->SetMaxLength(75); $grid->AddSingleRecordViewColumn($column); // // View column for description field // $column = new TextViewColumn('description', 'description', 'Description', $this->dataset); $column->SetOrderable(true); $column->SetMaxLength(75); $grid->AddSingleRecordViewColumn($column); // // View column for profile_name field // $column = new TextViewColumn('profile_name', 'profile_name', 'Profile Name', $this->dataset); $column->SetOrderable(true); $column->SetMaxLength(75); $grid->AddSingleRecordViewColumn($column); // // View column for application field // $column = new TextViewColumn('application', 'application', 'Application', $this->dataset); $column->SetOrderable(true); $column->SetMaxLength(75); $grid->AddSingleRecordViewColumn($column); // // View column for gateway field // $column = new TextViewColumn('gateway', 'gateway', 'Gateway', $this->dataset); $column->SetOrderable(true); $column->SetMaxLength(75); $grid->AddSingleRecordViewColumn($column); // // View column for instantaneous_speed field // $column = new TextViewColumn('instantaneous_speed', 'instantaneous_speed', 'Instantaneous Speed', $this->dataset); $column->SetOrderable(true); $grid->AddSingleRecordViewColumn($column); // // View column for averaged_speed field // $column = new TextViewColumn('averaged_speed', 'averaged_speed', 'Averaged Speed', $this->dataset); $column->SetOrderable(true); $grid->AddSingleRecordViewColumn($column); // // View column for tilt_angle field // $column = new TextViewColumn('tilt_angle', 'tilt_angle', 'Tilt Angle', $this->dataset); $column->SetOrderable(true); $grid->AddSingleRecordViewColumn($column); // // View column for flow_direction field // $column = new NumberViewColumn('flow_direction', 'flow_direction', 'Flow Direction', $this->dataset); $column->SetOrderable(true); $column->setNumberAfterDecimal(0); $column->setThousandsSeparator(','); $column->setDecimalSeparator(''); $grid->AddSingleRecordViewColumn($column); // // View column for relative_signal field // $column = new NumberViewColumn('relative_signal', 'relative_signal', 'Relative Signal', $this->dataset); $column->SetOrderable(true); $column->setNumberAfterDecimal(0); $column->setThousandsSeparator(','); $column->setDecimalSeparator(''); $grid->AddSingleRecordViewColumn($column); // // View column for instantaneous_snr256 field // $column = new TextViewColumn('instantaneous_snr256', 'instantaneous_snr256', 'Instantaneous Snr256', $this->dataset); $column->SetOrderable(true); $grid->AddSingleRecordViewColumn($column); // // View column for instantaneous_snr field // $column = new NumberViewColumn('instantaneous_snr', 'instantaneous_snr', 'Instantaneous Snr', $this->dataset); $column->SetOrderable(true); $column->setNumberAfterDecimal(4); $column->setThousandsSeparator(','); $column->setDecimalSeparator('.'); $grid->AddSingleRecordViewColumn($column); // // View column for calculated_water_discharge_integer field // $column = new NumberViewColumn('calculated_water_discharge_integer', 'calculated_water_discharge_integer', 'Calculated Water Discharge Integer', $this->dataset); $column->SetOrderable(true); $column->setNumberAfterDecimal(0); $column->setThousandsSeparator(','); $column->setDecimalSeparator(''); $grid->AddSingleRecordViewColumn($column); // // View column for calculated_water_discharge_decimal field // $column = new TextViewColumn('calculated_water_discharge_decimal', 'calculated_water_discharge_decimal', 'Calculated Water Discharge Decimal', $this->dataset); $column->SetOrderable(true); $grid->AddSingleRecordViewColumn($column); // // View column for distance_to_water_surface_integer field // $column = new NumberViewColumn('distance_to_water_surface_integer', 'distance_to_water_surface_integer', 'Distance To Water Surface Integer', $this->dataset); $column->SetOrderable(true); $column->setNumberAfterDecimal(0); $column->setThousandsSeparator(','); $column->setDecimalSeparator(''); $grid->AddSingleRecordViewColumn($column); // // View column for distance_to_water_surface_decimal field // $column = new TextViewColumn('distance_to_water_surface_decimal', 'distance_to_water_surface_decimal', 'Distance To Water Surface Decimal', $this->dataset); $column->SetOrderable(true); $grid->AddSingleRecordViewColumn($column); // // View column for measured_water_level_integer field // $column = new NumberViewColumn('measured_water_level_integer', 'measured_water_level_integer', 'Measured Water Level Integer', $this->dataset); $column->SetOrderable(true); $column->setNumberAfterDecimal(0); $column->setThousandsSeparator(','); $column->setDecimalSeparator(''); $grid->AddSingleRecordViewColumn($column); // // View column for measured_water_level_decimal field // $column = new TextViewColumn('measured_water_level_decimal', 'measured_water_level_decimal', 'Measured Water Level Decimal', $this->dataset); $column->SetOrderable(true); $grid->AddSingleRecordViewColumn($column); // // View column for level_sensor_snr field // $column = new TextViewColumn('level_sensor_snr', 'level_sensor_snr', 'Level Sensor Snr', $this->dataset); $column->SetOrderable(true); $grid->AddSingleRecordViewColumn($column); // // View column for cross_section_area_integer field // $column = new NumberViewColumn('cross_section_area_integer', 'cross_section_area_integer', 'Cross Section Area Integer', $this->dataset); $column->SetOrderable(true); $column->setNumberAfterDecimal(0); $column->setThousandsSeparator(','); $column->setDecimalSeparator(''); $grid->AddSingleRecordViewColumn($column); // // View column for cross_section_area_decimal field // $column = new TextViewColumn('cross_section_area_decimal', 'cross_section_area_decimal', 'Cross Section Area Decimal', $this->dataset); $column->SetOrderable(true); $grid->AddSingleRecordViewColumn($column); // // View column for payload_object field // $column = new TextViewColumn('payload_object', 'payload_object', 'Payload Object', $this->dataset); $column->SetOrderable(true); $grid->AddSingleRecordViewColumn($column); // // View column for rx_info field // $column = new TextViewColumn('rx_info', 'rx_info', 'Rx Info', $this->dataset); $column->SetOrderable(true); $grid->AddSingleRecordViewColumn($column); // // View column for lora_rssi field // $column = new NumberViewColumn('lora_rssi', 'lora_rssi', 'Lora Rssi', $this->dataset); $column->SetOrderable(true); $column->setNumberAfterDecimal(4); $column->setThousandsSeparator(','); $column->setDecimalSeparator('.'); $grid->AddSingleRecordViewColumn($column); // // View column for lora_snr field // $column = new NumberViewColumn('lora_snr', 'lora_snr', 'Lora Snr', $this->dataset); $column->SetOrderable(true); $column->setNumberAfterDecimal(4); $column->setThousandsSeparator(','); $column->setDecimalSeparator('.'); $grid->AddSingleRecordViewColumn($column); // // View column for deduplication_id field // $column = new TextViewColumn('deduplication_id', 'deduplication_id', 'Deduplication Id', $this->dataset); $column->SetOrderable(true); $grid->AddSingleRecordViewColumn($column); } protected function AddEditColumns(Grid $grid) { } protected function AddMultiEditColumns(Grid $grid) { // // Edit column for time field // $editor = new DateTimeEdit('time_edit', false, 'Y-m-d H:i:s'); $editColumn = new CustomEditColumn('Time', 'time', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddMultiEditColumn($editColumn); // // Edit column for device_name field // $editor = new TextAreaEdit('device_name_edit', 50, 8); $editColumn = new CustomEditColumn('Device Name', 'device_name', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddMultiEditColumn($editColumn); // // Edit column for display_name field // $editor = new TextEdit('display_name_edit'); $editor->SetMaxLength(100); $editColumn = new CustomEditColumn('Display Name', 'display_name', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddMultiEditColumn($editColumn); } protected function AddToggleEditColumns(Grid $grid) { } protected function AddInsertColumns(Grid $grid) { // // Edit column for time field // $editor = new DateTimeEdit('time_edit', false, 'Y-m-d H:i:s'); $editColumn = new CustomEditColumn('Time', 'time', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for device_name field // $editor = new TextAreaEdit('device_name_edit', 50, 8); $editColumn = new CustomEditColumn('Device Name', 'device_name', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for display_name field // $editor = new TextEdit('display_name_edit'); $editor->SetMaxLength(100); $editColumn = new CustomEditColumn('Display Name', 'display_name', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); $grid->SetShowAddButton(false && $this->GetSecurityInfo()->HasAddGrant()); } private function AddMultiUploadColumn(Grid $grid) { } protected function AddPrintColumns(Grid $grid) { // // View column for time field // $column = new DateTimeViewColumn('time', 'time', 'Time', $this->dataset); $column->SetOrderable(true); $column->SetDateTimeFormat('Y-m-d H:i:s'); $grid->AddPrintColumn($column); // // View column for device_name field // $column = new TextViewColumn('device_name', 'device_name', 'Device Name', $this->dataset); $column->SetOrderable(true); $column->SetMaxLength(75); $grid->AddPrintColumn($column); // // View column for display_name field // $column = new TextViewColumn('display_name', 'display_name', 'Display Name', $this->dataset); $column->SetOrderable(true); $column->SetMaxLength(75); $grid->AddPrintColumn($column); // // View column for description field // $column = new TextViewColumn('description', 'description', 'Description', $this->dataset); $column->SetOrderable(true); $column->SetMaxLength(75); $grid->AddPrintColumn($column); // // View column for profile_name field // $column = new TextViewColumn('profile_name', 'profile_name', 'Profile Name', $this->dataset); $column->SetOrderable(true); $column->SetMaxLength(75); $grid->AddPrintColumn($column); // // View column for application field // $column = new TextViewColumn('application', 'application', 'Application', $this->dataset); $column->SetOrderable(true); $column->SetMaxLength(75); $grid->AddPrintColumn($column); // // View column for gateway field // $column = new TextViewColumn('gateway', 'gateway', 'Gateway', $this->dataset); $column->SetOrderable(true); $column->SetMaxLength(75); $grid->AddPrintColumn($column); // // View column for instantaneous_speed field // $column = new TextViewColumn('instantaneous_speed', 'instantaneous_speed', 'Instantaneous Speed', $this->dataset); $column->SetOrderable(true); $grid->AddPrintColumn($column); // // View column for averaged_speed field // $column = new TextViewColumn('averaged_speed', 'averaged_speed', 'Averaged Speed', $this->dataset); $column->SetOrderable(true); $grid->AddPrintColumn($column); // // View column for tilt_angle field // $column = new TextViewColumn('tilt_angle', 'tilt_angle', 'Tilt Angle', $this->dataset); $column->SetOrderable(true); $grid->AddPrintColumn($column); // // View column for flow_direction field // $column = new NumberViewColumn('flow_direction', 'flow_direction', 'Flow Direction', $this->dataset); $column->SetOrderable(true); $column->setNumberAfterDecimal(0); $column->setThousandsSeparator(','); $column->setDecimalSeparator(''); $grid->AddPrintColumn($column); // // View column for relative_signal field // $column = new NumberViewColumn('relative_signal', 'relative_signal', 'Relative Signal', $this->dataset); $column->SetOrderable(true); $column->setNumberAfterDecimal(0); $column->setThousandsSeparator(','); $column->setDecimalSeparator(''); $grid->AddPrintColumn($column); // // View column for instantaneous_snr256 field // $column = new TextViewColumn('instantaneous_snr256', 'instantaneous_snr256', 'Instantaneous Snr256', $this->dataset); $column->SetOrderable(true); $grid->AddPrintColumn($column); // // View column for instantaneous_snr field // $column = new NumberViewColumn('instantaneous_snr', 'instantaneous_snr', 'Instantaneous Snr', $this->dataset); $column->SetOrderable(true); $column->setNumberAfterDecimal(4); $column->setThousandsSeparator(','); $column->setDecimalSeparator('.'); $grid->AddPrintColumn($column); // // View column for calculated_water_discharge_integer field // $column = new NumberViewColumn('calculated_water_discharge_integer', 'calculated_water_discharge_integer', 'Calculated Water Discharge Integer', $this->dataset); $column->SetOrderable(true); $column->setNumberAfterDecimal(0); $column->setThousandsSeparator(','); $column->setDecimalSeparator(''); $grid->AddPrintColumn($column); // // View column for calculated_water_discharge_decimal field // $column = new TextViewColumn('calculated_water_discharge_decimal', 'calculated_water_discharge_decimal', 'Calculated Water Discharge Decimal', $this->dataset); $column->SetOrderable(true); $grid->AddPrintColumn($column); // // View column for distance_to_water_surface_integer field // $column = new NumberViewColumn('distance_to_water_surface_integer', 'distance_to_water_surface_integer', 'Distance To Water Surface Integer', $this->dataset); $column->SetOrderable(true); $column->setNumberAfterDecimal(0); $column->setThousandsSeparator(','); $column->setDecimalSeparator(''); $grid->AddPrintColumn($column); // // View column for distance_to_water_surface_decimal field // $column = new TextViewColumn('distance_to_water_surface_decimal', 'distance_to_water_surface_decimal', 'Distance To Water Surface Decimal', $this->dataset); $column->SetOrderable(true); $grid->AddPrintColumn($column); // // View column for measured_water_level_integer field // $column = new NumberViewColumn('measured_water_level_integer', 'measured_water_level_integer', 'Measured Water Level Integer', $this->dataset); $column->SetOrderable(true); $column->setNumberAfterDecimal(0); $column->setThousandsSeparator(','); $column->setDecimalSeparator(''); $grid->AddPrintColumn($column); // // View column for measured_water_level_decimal field // $column = new TextViewColumn('measured_water_level_decimal', 'measured_water_level_decimal', 'Measured Water Level Decimal', $this->dataset); $column->SetOrderable(true); $grid->AddPrintColumn($column); // // View column for level_sensor_snr field // $column = new TextViewColumn('level_sensor_snr', 'level_sensor_snr', 'Level Sensor Snr', $this->dataset); $column->SetOrderable(true); $grid->AddPrintColumn($column); // // View column for cross_section_area_integer field // $column = new NumberViewColumn('cross_section_area_integer', 'cross_section_area_integer', 'Cross Section Area Integer', $this->dataset); $column->SetOrderable(true); $column->setNumberAfterDecimal(0); $column->setThousandsSeparator(','); $column->setDecimalSeparator(''); $grid->AddPrintColumn($column); // // View column for cross_section_area_decimal field // $column = new TextViewColumn('cross_section_area_decimal', 'cross_section_area_decimal', 'Cross Section Area Decimal', $this->dataset); $column->SetOrderable(true); $grid->AddPrintColumn($column); // // View column for payload_object field // $column = new TextViewColumn('payload_object', 'payload_object', 'Payload Object', $this->dataset); $column->SetOrderable(true); $grid->AddPrintColumn($column); // // View column for rx_info field // $column = new TextViewColumn('rx_info', 'rx_info', 'Rx Info', $this->dataset); $column->SetOrderable(true); $grid->AddPrintColumn($column); // // View column for lora_rssi field // $column = new NumberViewColumn('lora_rssi', 'lora_rssi', 'Lora Rssi', $this->dataset); $column->SetOrderable(true); $column->setNumberAfterDecimal(4); $column->setThousandsSeparator(','); $column->setDecimalSeparator('.'); $grid->AddPrintColumn($column); // // View column for lora_snr field // $column = new NumberViewColumn('lora_snr', 'lora_snr', 'Lora Snr', $this->dataset); $column->SetOrderable(true); $column->setNumberAfterDecimal(4); $column->setThousandsSeparator(','); $column->setDecimalSeparator('.'); $grid->AddPrintColumn($column); // // View column for deduplication_id field // $column = new TextViewColumn('deduplication_id', 'deduplication_id', 'Deduplication Id', $this->dataset); $column->SetOrderable(true); $grid->AddPrintColumn($column); } protected function AddExportColumns(Grid $grid) { // // View column for time field // $column = new DateTimeViewColumn('time', 'time', 'Time', $this->dataset); $column->SetOrderable(true); $column->SetDateTimeFormat('Y-m-d H:i:s'); $grid->AddExportColumn($column); // // View column for device_name field // $column = new TextViewColumn('device_name', 'device_name', 'Device Name', $this->dataset); $column->SetOrderable(true); $column->SetMaxLength(75); $grid->AddExportColumn($column); // // View column for display_name field // $column = new TextViewColumn('display_name', 'display_name', 'Display Name', $this->dataset); $column->SetOrderable(true); $column->SetMaxLength(75); $grid->AddExportColumn($column); // // View column for description field // $column = new TextViewColumn('description', 'description', 'Description', $this->dataset); $column->SetOrderable(true); $column->SetMaxLength(75); $grid->AddExportColumn($column); // // View column for profile_name field // $column = new TextViewColumn('profile_name', 'profile_name', 'Profile Name', $this->dataset); $column->SetOrderable(true); $column->SetMaxLength(75); $grid->AddExportColumn($column); // // View column for application field // $column = new TextViewColumn('application', 'application', 'Application', $this->dataset); $column->SetOrderable(true); $column->SetMaxLength(75); $grid->AddExportColumn($column); // // View column for gateway field // $column = new TextViewColumn('gateway', 'gateway', 'Gateway', $this->dataset); $column->SetOrderable(true); $column->SetMaxLength(75); $grid->AddExportColumn($column); // // View column for instantaneous_speed field // $column = new TextViewColumn('instantaneous_speed', 'instantaneous_speed', 'Instantaneous Speed', $this->dataset); $column->SetOrderable(true); $grid->AddExportColumn($column); // // View column for averaged_speed field // $column = new TextViewColumn('averaged_speed', 'averaged_speed', 'Averaged Speed', $this->dataset); $column->SetOrderable(true); $grid->AddExportColumn($column); // // View column for tilt_angle field // $column = new TextViewColumn('tilt_angle', 'tilt_angle', 'Tilt Angle', $this->dataset); $column->SetOrderable(true); $grid->AddExportColumn($column); // // View column for flow_direction field // $column = new NumberViewColumn('flow_direction', 'flow_direction', 'Flow Direction', $this->dataset); $column->SetOrderable(true); $column->setNumberAfterDecimal(0); $column->setThousandsSeparator(','); $column->setDecimalSeparator(''); $grid->AddExportColumn($column); // // View column for relative_signal field // $column = new NumberViewColumn('relative_signal', 'relative_signal', 'Relative Signal', $this->dataset); $column->SetOrderable(true); $column->setNumberAfterDecimal(0); $column->setThousandsSeparator(','); $column->setDecimalSeparator(''); $grid->AddExportColumn($column); // // View column for instantaneous_snr256 field // $column = new TextViewColumn('instantaneous_snr256', 'instantaneous_snr256', 'Instantaneous Snr256', $this->dataset); $column->SetOrderable(true); $grid->AddExportColumn($column); // // View column for instantaneous_snr field // $column = new NumberViewColumn('instantaneous_snr', 'instantaneous_snr', 'Instantaneous Snr', $this->dataset); $column->SetOrderable(true); $column->setNumberAfterDecimal(4); $column->setThousandsSeparator(','); $column->setDecimalSeparator('.'); $grid->AddExportColumn($column); // // View column for calculated_water_discharge_integer field // $column = new NumberViewColumn('calculated_water_discharge_integer', 'calculated_water_discharge_integer', 'Calculated Water Discharge Integer', $this->dataset); $column->SetOrderable(true); $column->setNumberAfterDecimal(0); $column->setThousandsSeparator(','); $column->setDecimalSeparator(''); $grid->AddExportColumn($column); // // View column for calculated_water_discharge_decimal field // $column = new TextViewColumn('calculated_water_discharge_decimal', 'calculated_water_discharge_decimal', 'Calculated Water Discharge Decimal', $this->dataset); $column->SetOrderable(true); $grid->AddExportColumn($column); // // View column for distance_to_water_surface_integer field // $column = new NumberViewColumn('distance_to_water_surface_integer', 'distance_to_water_surface_integer', 'Distance To Water Surface Integer', $this->dataset); $column->SetOrderable(true); $column->setNumberAfterDecimal(0); $column->setThousandsSeparator(','); $column->setDecimalSeparator(''); $grid->AddExportColumn($column); // // View column for distance_to_water_surface_decimal field // $column = new TextViewColumn('distance_to_water_surface_decimal', 'distance_to_water_surface_decimal', 'Distance To Water Surface Decimal', $this->dataset); $column->SetOrderable(true); $grid->AddExportColumn($column); // // View column for measured_water_level_integer field // $column = new NumberViewColumn('measured_water_level_integer', 'measured_water_level_integer', 'Measured Water Level Integer', $this->dataset); $column->SetOrderable(true); $column->setNumberAfterDecimal(0); $column->setThousandsSeparator(','); $column->setDecimalSeparator(''); $grid->AddExportColumn($column); // // View column for measured_water_level_decimal field // $column = new TextViewColumn('measured_water_level_decimal', 'measured_water_level_decimal', 'Measured Water Level Decimal', $this->dataset); $column->SetOrderable(true); $grid->AddExportColumn($column); // // View column for level_sensor_snr field // $column = new TextViewColumn('level_sensor_snr', 'level_sensor_snr', 'Level Sensor Snr', $this->dataset); $column->SetOrderable(true); $grid->AddExportColumn($column); // // View column for cross_section_area_integer field // $column = new NumberViewColumn('cross_section_area_integer', 'cross_section_area_integer', 'Cross Section Area Integer', $this->dataset); $column->SetOrderable(true); $column->setNumberAfterDecimal(0); $column->setThousandsSeparator(','); $column->setDecimalSeparator(''); $grid->AddExportColumn($column); // // View column for cross_section_area_decimal field // $column = new TextViewColumn('cross_section_area_decimal', 'cross_section_area_decimal', 'Cross Section Area Decimal', $this->dataset); $column->SetOrderable(true); $grid->AddExportColumn($column); // // View column for payload_object field // $column = new TextViewColumn('payload_object', 'payload_object', 'Payload Object', $this->dataset); $column->SetOrderable(true); $grid->AddExportColumn($column); // // View column for rx_info field // $column = new TextViewColumn('rx_info', 'rx_info', 'Rx Info', $this->dataset); $column->SetOrderable(true); $grid->AddExportColumn($column); // // View column for lora_rssi field // $column = new NumberViewColumn('lora_rssi', 'lora_rssi', 'Lora Rssi', $this->dataset); $column->SetOrderable(true); $column->setNumberAfterDecimal(4); $column->setThousandsSeparator(','); $column->setDecimalSeparator('.'); $grid->AddExportColumn($column); // // View column for lora_snr field // $column = new NumberViewColumn('lora_snr', 'lora_snr', 'Lora Snr', $this->dataset); $column->SetOrderable(true); $column->setNumberAfterDecimal(4); $column->setThousandsSeparator(','); $column->setDecimalSeparator('.'); $grid->AddExportColumn($column); // // View column for deduplication_id field // $column = new TextViewColumn('deduplication_id', 'deduplication_id', 'Deduplication Id', $this->dataset); $column->SetOrderable(true); $grid->AddExportColumn($column); } private function AddCompareColumns(Grid $grid) { // // View column for time field // $column = new DateTimeViewColumn('time', 'time', 'Time', $this->dataset); $column->SetOrderable(true); $column->SetDateTimeFormat('Y-m-d H:i:s'); $grid->AddCompareColumn($column); // // View column for device_name field // $column = new TextViewColumn('device_name', 'device_name', 'Device Name', $this->dataset); $column->SetOrderable(true); $column->SetMaxLength(75); $grid->AddCompareColumn($column); // // View column for display_name field // $column = new TextViewColumn('display_name', 'display_name', 'Display Name', $this->dataset); $column->SetOrderable(true); $column->SetMaxLength(75); $grid->AddCompareColumn($column); // // View column for description field // $column = new TextViewColumn('description', 'description', 'Description', $this->dataset); $column->SetOrderable(true); $column->SetMaxLength(75); $grid->AddCompareColumn($column); // // View column for profile_name field // $column = new TextViewColumn('profile_name', 'profile_name', 'Profile Name', $this->dataset); $column->SetOrderable(true); $column->SetMaxLength(75); $grid->AddCompareColumn($column); // // View column for application field // $column = new TextViewColumn('application', 'application', 'Application', $this->dataset); $column->SetOrderable(true); $column->SetMaxLength(75); $grid->AddCompareColumn($column); // // View column for gateway field // $column = new TextViewColumn('gateway', 'gateway', 'Gateway', $this->dataset); $column->SetOrderable(true); $column->SetMaxLength(75); $grid->AddCompareColumn($column); // // View column for instantaneous_speed field // $column = new TextViewColumn('instantaneous_speed', 'instantaneous_speed', 'Instantaneous Speed', $this->dataset); $column->SetOrderable(true); $grid->AddCompareColumn($column); // // View column for averaged_speed field // $column = new TextViewColumn('averaged_speed', 'averaged_speed', 'Averaged Speed', $this->dataset); $column->SetOrderable(true); $grid->AddCompareColumn($column); // // View column for tilt_angle field // $column = new TextViewColumn('tilt_angle', 'tilt_angle', 'Tilt Angle', $this->dataset); $column->SetOrderable(true); $grid->AddCompareColumn($column); // // View column for flow_direction field // $column = new NumberViewColumn('flow_direction', 'flow_direction', 'Flow Direction', $this->dataset); $column->SetOrderable(true); $column->setNumberAfterDecimal(0); $column->setThousandsSeparator(','); $column->setDecimalSeparator(''); $grid->AddCompareColumn($column); // // View column for relative_signal field // $column = new NumberViewColumn('relative_signal', 'relative_signal', 'Relative Signal', $this->dataset); $column->SetOrderable(true); $column->setNumberAfterDecimal(0); $column->setThousandsSeparator(','); $column->setDecimalSeparator(''); $grid->AddCompareColumn($column); // // View column for instantaneous_snr256 field // $column = new TextViewColumn('instantaneous_snr256', 'instantaneous_snr256', 'Instantaneous Snr256', $this->dataset); $column->SetOrderable(true); $grid->AddCompareColumn($column); // // View column for instantaneous_snr field // $column = new NumberViewColumn('instantaneous_snr', 'instantaneous_snr', 'Instantaneous Snr', $this->dataset); $column->SetOrderable(true); $column->setNumberAfterDecimal(4); $column->setThousandsSeparator(','); $column->setDecimalSeparator('.'); $grid->AddCompareColumn($column); // // View column for calculated_water_discharge_integer field // $column = new NumberViewColumn('calculated_water_discharge_integer', 'calculated_water_discharge_integer', 'Calculated Water Discharge Integer', $this->dataset); $column->SetOrderable(true); $column->setNumberAfterDecimal(0); $column->setThousandsSeparator(','); $column->setDecimalSeparator(''); $grid->AddCompareColumn($column); // // View column for calculated_water_discharge_decimal field // $column = new TextViewColumn('calculated_water_discharge_decimal', 'calculated_water_discharge_decimal', 'Calculated Water Discharge Decimal', $this->dataset); $column->SetOrderable(true); $grid->AddCompareColumn($column); // // View column for distance_to_water_surface_integer field // $column = new NumberViewColumn('distance_to_water_surface_integer', 'distance_to_water_surface_integer', 'Distance To Water Surface Integer', $this->dataset); $column->SetOrderable(true); $column->setNumberAfterDecimal(0); $column->setThousandsSeparator(','); $column->setDecimalSeparator(''); $grid->AddCompareColumn($column); // // View column for distance_to_water_surface_decimal field // $column = new TextViewColumn('distance_to_water_surface_decimal', 'distance_to_water_surface_decimal', 'Distance To Water Surface Decimal', $this->dataset); $column->SetOrderable(true); $grid->AddCompareColumn($column); // // View column for measured_water_level_integer field // $column = new NumberViewColumn('measured_water_level_integer', 'measured_water_level_integer', 'Measured Water Level Integer', $this->dataset); $column->SetOrderable(true); $column->setNumberAfterDecimal(0); $column->setThousandsSeparator(','); $column->setDecimalSeparator(''); $grid->AddCompareColumn($column); // // View column for measured_water_level_decimal field // $column = new TextViewColumn('measured_water_level_decimal', 'measured_water_level_decimal', 'Measured Water Level Decimal', $this->dataset); $column->SetOrderable(true); $grid->AddCompareColumn($column); // // View column for level_sensor_snr field // $column = new TextViewColumn('level_sensor_snr', 'level_sensor_snr', 'Level Sensor Snr', $this->dataset); $column->SetOrderable(true); $grid->AddCompareColumn($column); // // View column for cross_section_area_integer field // $column = new NumberViewColumn('cross_section_area_integer', 'cross_section_area_integer', 'Cross Section Area Integer', $this->dataset); $column->SetOrderable(true); $column->setNumberAfterDecimal(0); $column->setThousandsSeparator(','); $column->setDecimalSeparator(''); $grid->AddCompareColumn($column); // // View column for cross_section_area_decimal field // $column = new TextViewColumn('cross_section_area_decimal', 'cross_section_area_decimal', 'Cross Section Area Decimal', $this->dataset); $column->SetOrderable(true); $grid->AddCompareColumn($column); // // View column for lora_rssi field // $column = new NumberViewColumn('lora_rssi', 'lora_rssi', 'Lora Rssi', $this->dataset); $column->SetOrderable(true); $column->setNumberAfterDecimal(4); $column->setThousandsSeparator(','); $column->setDecimalSeparator('.'); $grid->AddCompareColumn($column); // // View column for lora_snr field // $column = new NumberViewColumn('lora_snr', 'lora_snr', 'Lora Snr', $this->dataset); $column->SetOrderable(true); $column->setNumberAfterDecimal(4); $column->setThousandsSeparator(','); $column->setDecimalSeparator('.'); $grid->AddCompareColumn($column); // // View column for deduplication_id field // $column = new TextViewColumn('deduplication_id', 'deduplication_id', 'Deduplication Id', $this->dataset); $column->SetOrderable(true); $grid->AddCompareColumn($column); } private function AddCompareHeaderColumns(Grid $grid) { } public function GetPageDirection() { return null; } public function isFilterConditionRequired() { return false; } protected function ApplyCommonColumnEditProperties(CustomEditColumn $column) { $column->SetDisplaySetToNullCheckBox(false); $column->SetDisplaySetToDefaultCheckBox(false); $column->SetVariableContainer($this->GetColumnVariableContainer()); } function GetCustomClientScript() { return ; } function GetOnPageLoadedClientScript() { return ; } protected function CreateGrid() { $result = new Grid($this, $this->dataset); if ($this->GetSecurityInfo()->HasDeleteGrant()) $result->SetAllowDeleteSelected(false); else $result->SetAllowDeleteSelected(false); ApplyCommonPageSettings($this, $result); $result->SetUseImagesForActions(true); $result->SetUseFixedHeader(false); $result->SetShowLineNumbers(false); $result->SetShowKeyColumnsImagesInHeader(false); $result->SetViewMode(ViewMode::TABLE); $result->setEnableRuntimeCustomization(true); $result->setAllowCompare(true); $this->AddCompareHeaderColumns($result); $this->AddCompareColumns($result); $result->setMultiEditAllowed($this->GetSecurityInfo()->HasEditGrant() && false); $result->setTableBordered(false); $result->setTableCondensed(false); $result->SetHighlightRowAtHover(false); $result->SetWidth(''); $this->AddOperationsColumns($result); $this->AddFieldColumns($result); $this->AddSingleRecordViewColumns($result); $this->AddEditColumns($result); $this->AddMultiEditColumns($result); $this->AddToggleEditColumns($result); $this->AddInsertColumns($result); $this->AddPrintColumns($result); $this->AddExportColumns($result); $this->AddMultiUploadColumn($result); $this->SetShowPageList(true); $this->SetShowTopPageNavigator(true); $this->SetShowBottomPageNavigator(true); $this->setAllowedActions(array('view')); $this->setPrintListAvailable(true); $this->setPrintListRecordAvailable(false); $this->setPrintOneRecordAvailable(true); $this->setAllowPrintSelectedRecords(true); $this->setExportListAvailable(array('pdf', 'excel', 'word', 'xml', 'csv')); $this->setExportSelectedRecordsAvailable(array('pdf', 'excel', 'word', 'xml', 'csv')); $this->setExportListRecordAvailable(array()); $this->setExportOneRecordAvailable(array('pdf', 'excel', 'word', 'xml', 'csv')); return $result; } protected function setClientSideEvents(Grid $grid) { } protected function doRegisterHandlers() { } protected function doCustomRenderColumn($fieldName, $fieldData, $rowData, &$customText, &$handled) { } protected function doCustomRenderPrintColumn($fieldName, $fieldData, $rowData, &$customText, &$handled) { } protected function doCustomRenderExportColumn($exportType, $fieldName, $fieldData, $rowData, &$customText, &$handled) { } protected function doCustomDrawRow($rowData, &$cellFontColor, &$cellFontSize, &$cellBgColor, &$cellItalicAttr, &$cellBoldAttr) { } protected function doExtendedCustomDrawRow($rowData, &$rowCellStyles, &$rowStyles, &$rowClasses, &$cellClasses) { } protected function doCustomRenderTotal($totalValue, $aggregate, $columnName, &$customText, &$handled) { } protected function doCustomDefaultValues(&$values, &$handled) { } protected function doCustomCompareColumn($columnName, $valueA, $valueB, &$result) { } protected function doBeforeInsertRecord($page, &$rowData, $tableName, &$cancel, &$message, &$messageDisplayTime) { } protected function doBeforeUpdateRecord($page, $oldRowData, &$rowData, $tableName, &$cancel, &$message, &$messageDisplayTime) { } protected function doBeforeDeleteRecord($page, &$rowData, $tableName, &$cancel, &$message, &$messageDisplayTime) { } protected function doAfterInsertRecord($page, $rowData, $tableName, &$success, &$message, &$messageDisplayTime) { } protected function doAfterUpdateRecord($page, $oldRowData, $rowData, $tableName, &$success, &$message, &$messageDisplayTime) { } protected function doAfterDeleteRecord($page, $rowData, $tableName, &$success, &$message, &$messageDisplayTime) { } protected function doCustomHTMLHeader($page, &$customHtmlHeaderText) { } protected function doGetCustomTemplate($type, $part, $mode, &$result, &$params) { } protected function doGetCustomExportOptions(Page $page, $exportType, $rowData, &$options) { } protected function doFileUpload($fieldName, $rowData, &$result, &$accept, $originalFileName, $originalFileExtension, $fileSize, $tempFileName) { } protected function doPrepareChart(Chart $chart) { } protected function doPrepareColumnFilter(ColumnFilter $columnFilter) { } protected function doPrepareFilterBuilder(FilterBuilder $filterBuilder, FixedKeysArray $columns) { } protected function doGetSelectionFilters(FixedKeysArray $columns, &$result) { } protected function doGetCustomFormLayout($mode, FixedKeysArray $columns, FormLayout $layout) { } protected function doGetCustomColumnGroup(FixedKeysArray $columns, ViewColumnGroup $columnGroup) { } protected function doPageLoaded() { } protected function doCalculateFields($rowData, $fieldName, &$value) { } protected function doGetCustomRecordPermissions(Page $page, &$usingCondition, $rowData, &$allowEdit, &$allowDelete, &$mergeWithDefault, &$handled) { } protected function doAddEnvironmentVariables(Page $page, &$variables) { } } SetUpUserAuthorization(); try { $Page = new iot_uc502_geoluxPage("iot_uc502_geolux", "uc502_geolux.php", GetCurrentUserPermissionsForPage("iot.uc502_geolux"), 'UTF-8'); $Page->SetRecordPermission(GetCurrentUserRecordPermissionsForDataSource("iot.uc502_geolux")); GetApplication()->SetMainPage($Page); GetApplication()->Run(); } catch(Exception $e) { ShowErrorPage($e); }