def get_values_checked_param_user(self, chk, widget, field, value=None):
elem = {}
elem['widget'] = str(widget.objectName())
elem['chk'] = str(chk.objectName())
if type(widget) is QLineEdit:
value = qt_tools.getWidgetText(self.dlg_config,
widget,
return_string_null=False)
elem['widget_type'] = 'text'
elif type(widget) is QComboBox:
value = qt_tools.get_item_data(self.dlg_config, widget, 0)
elem['widget_type'] = 'combo'
elif type(widget) is QCheckBox:
value = qt_tools.isChecked(self.dlg_config, chk)
elem['widget_type'] = 'check'
elif type(widget) is QDateEdit:
value = qt_tools.getCalendarDate(self.dlg_config, widget)
elem['widget_type'] = 'datetime'
elif type(widget) is QgsDateTimeEdit:
value = qt_tools.getCalendarDate(self.dlg_config, widget)
elem['widget_type'] = 'datetime'
elem['isChecked'] = str(qt_tools.isChecked(self.dlg_config, chk))
elem['value'] = value
self.list_update.append(elem)
def get_values_changed_param_system(self, widget, value=None):
elem = {}
if type(widget) is QLineEdit:
value = qt_tools.getWidgetText(self.dlg_config,
widget,
return_string_null=False)
elif type(widget) is QComboBox:
value = qt_tools.get_item_data(self.dlg_config, widget, 0)
elif type(widget) is QCheckBox:
value = qt_tools.isChecked(self.dlg_config, widget)
elif type(widget) is QDateEdit:
value = qt_tools.getCalendarDate(self.dlg_config, widget)
elem['widget'] = str(widget.objectName())
elem['chk'] = str('')
elem['isChecked'] = str('')
elem['value'] = value
elem['sysRoleId'] = 'role_admin'
self.list_update.append(elem)
def manage_workcat_end_accept(self):
""" Get elements from all the tables and update his data """
# Setting values
self.workcat_id_end = qt_tools.getWidgetText(
self.dlg_work_end, self.dlg_work_end.workcat_id_end)
self.enddate = qt_tools.getCalendarDate(self.dlg_work_end,
self.dlg_work_end.enddate)
self.statetype_id_end = qt_tools.get_item_data(
self.dlg_work_end, self.dlg_work_end.cmb_statetype_end, 0)
if self.workcat_id_end in ('null', None):
message = "Please select a workcat id end"
self.controller.show_warning(message)
return
ids_list = self.get_list_selected_id(
self.dlg_work_end.tbl_cat_work_x_arc)
row = None
if ids_list:
sql = (f"SELECT * FROM v_ui_arc_x_relations "
f"WHERE arc_id IN ( {ids_list}) AND arc_state = '1'")
row = self.controller.get_row(sql)
if row:
self.dlg_work = FeatureEndConnecUi()
self.load_settings(self.dlg_work)
self.dlg_work.btn_cancel.clicked.connect(
partial(self.close_dialog_workcat_list, self.dlg_work))
self.dlg_work.btn_accept.clicked.connect(self.exec_downgrade)
self.set_completer()
table_relations = "v_ui_arc_x_relations"
self.dlg_work.arc_id.textChanged.connect(
partial(self.filter_by_id, self.dlg_work.tbl_arc_x_relations,
self.dlg_work.arc_id, table_relations))
self.tbl_arc_x_relations = self.dlg_work.findChild(
QTableView, "tbl_arc_x_relations")
self.tbl_arc_x_relations.setSelectionBehavior(
QAbstractItemView.SelectRows)
filter_ = ""
for row in self.selected_list:
filter_ += f"arc_id = '{row}' OR "
filter_ = filter_[:-3] + ""
filter_ += " AND arc_state = '1' "
self.fill_table(self.tbl_arc_x_relations, table_relations, filter_)
self.tbl_arc_x_relations.doubleClicked.connect(
partial(self.open_selected_object, self.tbl_arc_x_relations))
self.open_dialog(self.dlg_work, dlg_name='feature_end_connec')
# TODO: Function update_geom_type() don't use parameter ids_list
else:
# Update tablename of every geom_type
ids_list = self.get_list_selected_id(
self.dlg_work_end.tbl_cat_work_x_arc)
self.update_geom_type("arc", ids_list)
ids_list = self.get_list_selected_id(
self.dlg_work_end.tbl_cat_work_x_node)
self.update_geom_type("node", ids_list)
ids_list = self.get_list_selected_id(
self.dlg_work_end.tbl_cat_work_x_connec)
self.update_geom_type("connec", ids_list)
ids_list = self.get_list_selected_id(
self.dlg_work_end.tbl_cat_work_x_element)
self.update_geom_type("element", ids_list)
if str(self.project_type) == 'ud':
ids_list = self.get_list_selected_id(
self.dlg_work_end.tbl_cat_work_x_gully)
self.update_geom_type("gully", ids_list)
self.manage_close(self.dlg_work_end,
self.table_object,
self.cur_active_layer,
force_downgrade=True)
# Remove selection for all layers in TOC
for layer in self.iface.mapCanvas().layers():
if layer.type() == layer.VectorLayer:
layer.removeSelection()
self.iface.mapCanvas().refresh()
def execute_function(self, dialog, combo, result):
dialog.btn_cancel.setEnabled(False)
dialog.progressBar.setMaximum(0)
dialog.progressBar.setMinimum(0)
dialog.progressBar.setVisible(True)
extras = ''
feature_field = ''
# TODO Check if time functions is short or long, activate and set undetermined if not short
# Get function name
function = None
function_name = None
for group, function in list(result['fields'].items()):
if len(function) != 0:
self.save_settings_values(dialog, function)
self.save_parametric_values(dialog, function)
function_name = function[0]['functionname']
break
if function_name is None:
return
# If function is not parametrized, call function(old) without json
if self.is_paramtetric is False:
self.execute_no_parametric(dialog, function_name)
dialog.progressBar.setVisible(False)
dialog.progressBar.setMinimum(0)
dialog.progressBar.setMaximum(1)
dialog.progressBar.setValue(1)
return
if function[0]['input_params']['featureType']:
layer = None
layer_name = qt_tools.get_item_data(dialog, combo, 1)
if layer_name != -1:
layer = self.set_selected_layer(dialog, combo)
if not layer:
dialog.progressBar.setVisible(False)
dialog.progressBar.setMinimum(0)
dialog.progressBar.setMaximum(1)
dialog.progressBar.setValue(1)
return
selection_mode = self.rbt_checked['widget']
extras += f'"selectionMode":"{selection_mode}",'
# Check selection mode and get (or not get) all feature id
feature_id_list = '"id":['
if (selection_mode == 'wholeSelection') or (
selection_mode == 'previousSelection' and layer is None):
feature_id_list += ']'
elif selection_mode == 'previousSelection' and layer is not None:
features = layer.selectedFeatures()
feature_type = qt_tools.get_item_data(dialog,
dialog.cmb_geom_type, 0)
for feature in features:
feature_id = feature.attribute(feature_type + "_id")
feature_id_list += f'"{feature_id}", '
if len(features) > 0:
feature_id_list = feature_id_list[:-2] + ']'
else:
feature_id_list += ']'
if layer_name != -1:
feature_field = f'"tableName":"{layer_name}", '
feature_type = qt_tools.get_item_data(dialog,
dialog.cmb_geom_type, 0)
feature_field += f'"featureType":"{feature_type}", '
feature_field += feature_id_list
widget_list = dialog.grb_parameters.findChildren(QWidget)
widget_is_void = False
extras += '"parameters":{'
for group, function in list(result['fields'].items()):
if len(function) != 0:
if function[0]['return_type'] not in (None, ''):
for field in function[0]['return_type']:
widget = dialog.findChild(QWidget, field['widgetname'])
param_name = widget.objectName()
if type(widget) in ('', QLineEdit):
widget.setStyleSheet(None)
value = qt_tools.getWidgetText(
dialog, widget, False, False)
extras += f'"{param_name}":"{value}", '.replace(
'""', 'null')
if value is '' and widget.property('ismandatory'):
widget_is_void = True
widget.setStyleSheet("border: 1px solid red")
elif type(widget) in ('', QSpinBox, QDoubleSpinBox):
value = qt_tools.getWidgetText(
dialog, widget, False, False)
if value == '':
value = 0
extras += f'"{param_name}":"{value}", '
elif type(widget) in ('', QComboBox):
value = qt_tools.get_item_data(dialog, widget, 0)
extras += f'"{param_name}":"{value}", '
elif type(widget) in ('', QCheckBox):
value = qt_tools.isChecked(dialog, widget)
extras += f'"{param_name}":"{str(value).lower()}", '
elif type(widget) in ('', QgsDateTimeEdit):
value = qt_tools.getCalendarDate(dialog, widget)
if value == "" or value is None:
extras += f'"{param_name}":null, '
else:
extras += f'"{param_name}":"{value}", '
if widget_is_void:
message = "This param is mandatory. Please, set a value"
self.controller.show_warning(message, parameter='')
dialog.progressBar.setVisible(False)
dialog.progressBar.setMinimum(0)
dialog.progressBar.setMaximum(1)
dialog.progressBar.setValue(1)
return
dialog.progressBar.setFormat(f"Running function: {function_name}")
dialog.progressBar.setAlignment(Qt.AlignCenter)
if len(widget_list) > 0:
extras = extras[:-2] + '}'
else:
extras += '}'
body = self.create_body(feature=feature_field, extras=extras)
json_result = self.controller.get_json(function_name,
body,
log_sql=True)
self.add_layer.populate_info_text(dialog, json_result['body']['data'],
True, True, 1, True)
dialog.progressBar.setAlignment(Qt.AlignCenter)
dialog.progressBar.setMinimum(0)
dialog.progressBar.setMaximum(1)
dialog.progressBar.setValue(1)
if json_result is None:
dialog.progressBar.setFormat(
f"Function: {function_name} executed with no result")
return True
if not json_result:
dialog.progressBar.setFormat(
f"Function: {function_name} failed. See log file for more details"
)
return False
try:
dialog.progressBar.setFormat(
f"Function {function_name} has finished")
# getting simbology capabilities
if 'setStyle' in json_result['body']['data']:
set_sytle = json_result['body']['data']['setStyle']
if set_sytle == "Mapzones":
# call function to simbolize mapzones
self.set_style_mapzones()
except KeyError as e:
msg = f"<b>Key: </b>{e}<br>"
msg += f"<b>key container: </b>'body/data/ <br>"
msg += f"<b>Python file: </b>{__name__} <br>"
msg += f"<b>Python function:</b> {self.execute_function.__name__} <br>"
self.show_exceptions_msg(
"Key on returned json from ddbb is missed.", msg)
self.remove_layers()
def manage_document_accept(self,
table_object,
tablename=None,
qtable=None,
item_id=None):
""" Insert or update table 'document'. Add document to selected feature """
# Get values from dialog
doc_id = qt_tools.getWidgetText(self.dlg_add_doc, "doc_id")
doc_type = qt_tools.getWidgetText(self.dlg_add_doc,
"doc_type",
return_string_null=True)
date = qt_tools.getCalendarDate(self.dlg_add_doc,
"date",
datetime_format="yyyy/MM/dd")
observ = qt_tools.getWidgetText(self.dlg_add_doc,
"observ",
return_string_null=False)
path = qt_tools.getWidgetText(self.dlg_add_doc,
"path",
return_string_null=False)
if doc_type == 'null':
message = "You need to insert doc_type"
self.controller.show_warning(message)
return
# Check if this document already exists
sql = (f"SELECT DISTINCT(id)"
f" FROM {table_object}"
f" WHERE id = '{doc_id}'")
row = self.controller.get_row(sql, log_info=False)
# If document not exists perform an INSERT
if row is None:
if doc_id == 'null':
sql = (
f"INSERT INTO doc (doc_type, path, observ, date)"
f" VALUES ('{doc_type}', '{path}', '{observ}', '{date}') RETURNING id;"
)
new_doc_id = self.controller.execute_returning(sql)
sql = ""
doc_id = str(new_doc_id[0])
else:
sql = (
f"INSERT INTO doc (id, doc_type, path, observ, date)"
f" VALUES ('{doc_id}', '{doc_type}', '{path}', '{observ}', '{date}');"
)
# If document exists perform an UPDATE
else:
message = "Are you sure you want to update the data?"
answer = self.controller.ask_question(message)
if not answer:
return
sql = (
f"UPDATE doc "
f" SET doc_type = '{doc_type}', observ = '{observ}', path = '{path}', date = '{date}'"
f" WHERE id = '{doc_id}';")
# Manage records in tables @table_object_x_@geom_type
sql += (f"\nDELETE FROM doc_x_node" f" WHERE doc_id = '{doc_id}';")
sql += (f"\nDELETE FROM doc_x_arc" f" WHERE doc_id = '{doc_id}';")
sql += (f"\nDELETE FROM doc_x_connec" f" WHERE doc_id = '{doc_id}';")
if self.project_type == 'ud':
sql += (f"\nDELETE FROM doc_x_gully"
f" WHERE doc_id = '{doc_id}';")
if self.list_ids['arc']:
for feature_id in self.list_ids['arc']:
sql += (f"\nINSERT INTO doc_x_arc (doc_id, arc_id)"
f" VALUES ('{doc_id}', '{feature_id}');")
if self.list_ids['node']:
for feature_id in self.list_ids['node']:
sql += (f"\nINSERT INTO doc_x_node (doc_id, node_id)"
f" VALUES ('{doc_id}', '{feature_id}');")
if self.list_ids['connec']:
for feature_id in self.list_ids['connec']:
sql += (f"\nINSERT INTO doc_x_connec (doc_id, connec_id)"
f" VALUES ('{doc_id}', '{feature_id}');")
if self.project_type == 'ud' and self.list_ids['gully']:
for feature_id in self.list_ids['gully']:
sql += (f"\nINSERT INTO doc_x_gully (doc_id, gully_id)"
f" VALUES ('{doc_id}', '{feature_id}');")
status = self.controller.execute_sql(sql)
if status:
self.doc_id = doc_id
manage_close(self.dlg_add_doc,
table_object,
excluded_layers=["v_edit_element"],
single_tool_mode=self.single_tool_mode,
layers=self.layers)
if tablename is None:
return
else:
sql = (f"INSERT INTO doc_x_{tablename} (doc_id, {tablename}_id) "
f" VALUES('{doc_id}', '{item_id}')")
self.controller.execute_sql(sql)
expr = f"{tablename}_id = '{item_id}'"
fill_table_object(qtable,
f"{self.schema_name}.v_ui_doc_x_{tablename}",
expr_filter=expr)
def get_values_from_form(self, dialog):
self.enddate = qt_tools.getCalendarDate(dialog, "enddate")
self.workcat_id_end = qt_tools.getWidgetText(dialog, "workcat_id_end")
self.description = qt_tools.getWidgetText(dialog, "descript")