gw_fct_getfeatureinsert - Giswater/giswater_dbmodel GitHub Wiki
Description
Get feature dialog with current user default values on insert operations
Input example
SELECT gw_fct_getfeatureinsert($${
"client":{"device":4, "infoType":1, "lang":"ES"},
"form":{}, "feature":{"tableName":"ve_node_junction"},
"data":{"coordinates":{"x1":418924.6, "y1":4576556.2, "x2":null, "y2":null}}}$$)
Output example
{
"status": "Accepted",
"message": {},
"apiVersion": {
"value": "3.5.002"
},
"body": {
"form": {
"template": "info_feature",
"headerText": "Node",
"visibleTabs": [
{
"tabName": "tab_data",
"tabLabel": "Data",
"tooltip": "Data",
"tabFunction": null,
"tabactions": [
{
"actionName": "actionEdit",
"actionTooltip": "Edit",
"disabled": false
},
{
"actionName": "actionZoom",
"actionTooltip": "Zoom In",
"disabled": false
},
{
"actionName": "actionCentered",
"actionTooltip": "Center",
"disabled": false
},
{
"actionName": "actionZoomOut",
"actionTooltip": "Zoom Out",
"disabled": false
},
{
"actionName": "actionCatalog",
"actionTooltip": "Change Catalog",
"disabled": false
},
{
"actionName": "actionWorkcat",
"actionTooltip": "Add Workcat",
"disabled": false
},
{
"actionName": "actionCopyPaste",
"actionTooltip": "Copy Paste",
"disabled": false
},
{
"actionName": "actionLink",
"actionTooltip": "Open Link",
"disabled": false
},
{
"actionName": "actionHelp",
"actionTooltip": "Help",
"disabled": false
},
{
"actionName": "actionGetParentId",
"actionTooltip": "Set parent_id",
"disabled": false
}
]
},
{
"tabName": "tab_elements",
"tabLabel": "Elem",
"tooltip": "List of related elements",
"tabFunction": null,
"tabactions": [
{
"actionName": "actionEdit",
"actionTooltip": "Edit",
"disabled": false
},
{
"actionName": "actionZoom",
"actionTooltip": "Zoom In",
"disabled": false
},
{
"actionName": "actionCentered",
"actionTooltip": "Center",
"disabled": false
},
{
"actionName": "actionZoomOut",
"actionTooltip": "Zoom Out",
"disabled": false
},
{
"actionName": "actionCatalog",
"actionTooltip": "Change Catalog",
"disabled": false
},
{
"actionName": "actionWorkcat",
"actionTooltip": "Add Workcat",
"disabled": false
},
{
"actionName": "actionCopyPaste",
"actionTooltip": "Copy Paste",
"disabled": false
},
{
"actionName": "actionLink",
"actionTooltip": "Open Link",
"disabled": false
},
{
"actionName": "actionHelp",
"actionTooltip": "Help",
"disabled": false
},
{
"actionName": "actionGetParentId",
"actionTooltip": "Set parent_id",
"disabled": false
}
]
},
{
"tabName": "tab_om",
"tabLabel": "OM",
"tooltip": "List of events",
"tabFunction": null,
"tabactions": [
{
"actionName": "actionEdit",
"actionTooltip": "Edit",
"disabled": false
},
{
"actionName": "actionZoom",
"actionTooltip": "Zoom In",
"disabled": false
},
{
"actionName": "actionCentered",
"actionTooltip": "Center",
"disabled": false
},
{
"actionName": "actionZoomOut",
"actionTooltip": "Zoom Out",
"disabled": false
},
{
"actionName": "actionCatalog",
"actionTooltip": "Change Catalog",
"disabled": false
},
{
"actionName": "actionWorkcat",
"actionTooltip": "Add Workcat",
"disabled": false
},
{
"actionName": "actionCopyPaste",
"actionTooltip": "Copy Paste",
"disabled": false
},
{
"actionName": "actionLink",
"actionTooltip": "Open Link",
"disabled": false
},
{
"actionName": "actionHelp",
"actionTooltip": "Help",
"disabled": false
},
{
"actionName": "actionGetParentId",
"actionTooltip": "Set parent_id",
"disabled": false
}
]
},
{
"tabName": "tab_documents",
"tabLabel": "Doc",
"tooltip": "List of documents",
"tabFunction": null,
"tabactions": [
{
"actionName": "actionEdit",
"actionTooltip": "Edit",
"disabled": false
},
{
"actionName": "actionZoom",
"actionTooltip": "Zoom In",
"disabled": false
},
{
"actionName": "actionCentered",
"actionTooltip": "Center",
"disabled": false
},
{
"actionName": "actionZoomOut",
"actionTooltip": "Zoom Out",
"disabled": false
},
{
"actionName": "actionCatalog",
"actionTooltip": "Change Catalog",
"disabled": false
},
{
"actionName": "actionWorkcat",
"actionTooltip": "Add Workcat",
"disabled": false
},
{
"actionName": "actionCopyPaste",
"actionTooltip": "Copy Paste",
"disabled": false
},
{
"actionName": "actionLink",
"actionTooltip": "Open Link",
"disabled": false
},
{
"actionName": "actionHelp",
"actionTooltip": "Help",
"disabled": false
},
{
"actionName": "actionGetParentId",
"actionTooltip": "Set parent_id",
"disabled": false
}
]
},
{
"tabName": "tab_plan",
"tabLabel": "Cost",
"tooltip": "List of costs",
"tabFunction": null,
"tabactions": [
{
"actionName": "actionEdit",
"actionTooltip": "Edit",
"disabled": false
},
{
"actionName": "actionZoom",
"actionTooltip": "Zoom In",
"disabled": false
},
{
"actionName": "actionCentered",
"actionTooltip": "Center",
"disabled": false
},
{
"actionName": "actionZoomOut",
"actionTooltip": "Zoom Out",
"disabled": false
},
{
"actionName": "actionCatalog",
"actionTooltip": "Change Catalog",
"disabled": false
},
{
"actionName": "actionWorkcat",
"actionTooltip": "Add Workcat",
"disabled": false
},
{
"actionName": "actionCopyPaste",
"actionTooltip": "Copy Paste",
"disabled": false
},
{
"actionName": "actionLink",
"actionTooltip": "Open Link",
"disabled": false
},
{
"actionName": "actionHelp",
"actionTooltip": "Help",
"disabled": false
},
{
"actionName": "actionGetParentId",
"actionTooltip": "Set parent_id",
"disabled": false
}
]
}
]
},
"feature": {
"permissions": {
"status": "Accepted",
"version": {
"value": "3.5.002"
},
"tableName": "ve_node_junction",
"isEditable": true,
"permissions": [
{
"privilege_type": "INSERT"
}
]
},
"tableName": "ve_node_junction",
"idName": "node_id",
"id": "114465",
"featureType": "node",
"childType": "JUNCTION",
"tableParent": "v_edit_node",
"geometry": null,
"zoomCanvasMargin": {
"mts": ""
},
"vdefaultValues": {}
},
"data": {
"linkPath": {},
"editable": true,
"parentFields": [
"node_id",
"code",
"elevation",
"depth",
"node_type",
"sys_type",
"nodecat_id",
"cat_matcat_id",
"cat_pnom",
"cat_dnom",
"epa_type",
"expl_id",
"macroexpl_id",
"sector_id",
"sector_name",
"macrosector_id",
"arc_id",
"parent_id",
"state",
"state_type",
"annotation",
"observ",
"comment",
"minsector_id",
"dma_id",
"dma_name",
"macrodma_id",
"presszone_id",
"presszone_name",
"staticpressure",
"dqa_id",
"dqa_name",
"macrodqa_id",
"soilcat_id",
"function_type",
"category_type",
"fluid_type",
"location_type",
"workcat_id",
"workcat_id_end",
"builtdate",
"enddate",
"buildercat_id",
"ownercat_id",
"muni_id",
"postcode",
"district_id",
"streetname",
"postnumber",
"postcomplement",
"streetname2",
"postnumber2",
"postcomplement2",
"descript",
"svg",
"rotation",
"link",
"verified",
"undelete",
"label",
"label_x",
"label_y",
"label_rotation",
"publish",
"inventory",
"hemisphere",
"num_value",
"nodetype_id",
"tstamp",
"insert_user",
"lastupdate",
"lastupdate_user",
"the_geom",
"adate",
"adescript",
"accessibility",
"dma_style",
"presszone_style"
],
"fields": [
{
"label": "sector",
"columnname": "sector_id",
"widgetname": "data_sector_id",
"widgettype": "combo",
"widgetfunction": null,
"hidden": false,
"widgetdim": null,
"datatype": "integer",
"tooltip": "sector_id - Identificador del sector hidráulico dónde se encuentra un elemento. Si no se modifica la configuración, el programa lo selecciona automáticamente en función de la geometría ",
"placeholder": null,
"iseditable": true,
"orderby": 1,
"layoutname": "lyt_bot_1",
"layoutorder": 1,
"isparent": false,
"ismandatory": false,
"linkedaction": null,
"isautoupdate": false,
"stylesheet": {
"label": "color:red; font-weight:bold"
},
"comboIds": [
"0",
"1",
"2",
"3",
"4",
"5"
],
"comboNames": [
"Undefined",
"sector1-1s",
"sector1-2s",
"sector1-1d",
"sector2-1s",
"sector2-1d"
],
"selectedId": "3",
"widgetcontrols": {}
},
{
"label": "dma",
"columnname": "dma_id",
"widgetname": "data_dma_id",
"widgettype": "combo",
"widgetfunction": null,
"hidden": false,
"widgetdim": null,
"datatype": "integer",
"tooltip": "dma_id - Identificador de la dma a la que pertenece el elemento. Si no se modifica la configuración, el programa la selecciona automáticamente en función de la geometría",
"placeholder": null,
"iseditable": true,
"orderby": 2,
"layoutname": "lyt_bot_1",
"layoutorder": 2,
"isparent": false,
"ismandatory": false,
"linkedaction": null,
"isautoupdate": false,
"stylesheet": null,
"comboIds": [
"0",
"1",
"2",
"4"
],
"comboNames": [
"Undefined",
"dma1-1d",
"dma1-2d",
"source-1"
],
"selectedId": "2",
"widgetcontrols": {}
},
{
"label": "state",
"columnname": "state",
"widgetname": "data_state",
"widgettype": "combo",
"widgetfunction": null,
"hidden": false,
"widgetdim": null,
"datatype": "integer",
"tooltip": "state - Estado del elemento. A escoger entre los 3 tipos de estados disponibles",
"placeholder": null,
"iseditable": true,
"orderby": 3,
"layoutname": "lyt_bot_1",
"layoutorder": 16,
"isparent": true,
"ismandatory": false,
"linkedaction": null,
"isautoupdate": false,
"stylesheet": null,
"comboIds": [
"0",
"1",
"2"
],
"comboNames": [
"OBSOLETE",
"ON_SERVICE",
"PLANIFIED"
],
"selectedId": "1",
"widgetcontrols": {}
},
{
"label": "state_type",
"columnname": "state_type",
"widgetname": "data_state_type",
"widgettype": "combo",
"widgetfunction": null,
"hidden": false,
"widgetdim": null,
"datatype": "integer",
"tooltip": "state_type - Tipo de estado del elemento. Permite obtener más detalle del estado. A seleccionar de los disponibles en función del estado escogido",
"placeholder": null,
"iseditable": true,
"orderby": 4,
"layoutname": "lyt_bot_1",
"layoutorder": 17,
"isparent": false,
"ismandatory": false,
"linkedaction": null,
"isautoupdate": false,
"stylesheet": null,
"comboIds": [
"2",
"5"
],
"comboNames": [
"ON_SERVICE",
"PROVISIONAL"
],
"selectedId": "2",
"widgetcontrols": {}
},
{
"label": "code",
"columnname": "code",
"widgetname": "data_code",
"widgettype": "text",
"widgetfunction": null,
"hidden": false,
"widgetdim": null,
"datatype": "string",
"tooltip": "code - Código usado anteriormente por la empresa. Este se usará en muchas herramientas de Giswater. Si se deja vacío, se rellenará con el id del elemento",
"placeholder": null,
"iseditable": true,
"orderby": 5,
"layoutname": "lyt_data_1",
"layoutorder": 1,
"isparent": false,
"ismandatory": false,
"linkedaction": null,
"isautoupdate": false,
"stylesheet": null,
"widgetcontrols": null,
"value": "114465"
},
{
"label": "elevation",
"columnname": "elevation",
"widgetname": "data_elevation",
"widgettype": "text",
"widgetfunction": null,
"hidden": false,
"widgetdim": null,
"datatype": "double",
"tooltip": "elevation - Elevación del elemento en metros sobre el nivel del mar",
"placeholder": null,
"iseditable": true,
"orderby": 6,
"layoutname": "lyt_data_1",
"layoutorder": 2,
"isparent": false,
"ismandatory": false,
"linkedaction": null,
"isautoupdate": false,
"stylesheet": null,
"value": "",
"widgetcontrols": {}
},
{
"label": "depth",
"columnname": "depth",
"widgetname": "data_depth",
"widgettype": "text",
"widgetfunction": null,
"hidden": false,
"widgetdim": null,
"datatype": "double",
"tooltip": "depth - Profundidad del elemento en metros",
"placeholder": null,
"iseditable": true,
"orderby": 7,
"layoutname": "lyt_data_1",
"layoutorder": 3,
"isparent": false,
"ismandatory": false,
"linkedaction": null,
"isautoupdate": false,
"stylesheet": null,
"value": "",
"widgetcontrols": {}
},
{
"label": "cat_matcat_id",
"columnname": "cat_matcat_id",
"widgetname": "data_cat_matcat_id",
"widgettype": "text",
"widgetfunction": null,
"hidden": false,
"widgetdim": null,
"datatype": "string",
"tooltip": "cat_matcat_id - Material del elemento. No se puede rellenar Se usa el que tenga el campo matcat_id del catálogo correspondiente",
"placeholder": null,
"iseditable": false,
"orderby": 8,
"layoutname": "lyt_data_1",
"layoutorder": 5,
"isparent": false,
"ismandatory": false,
"linkedaction": null,
"isautoupdate": false,
"stylesheet": null,
"widgetcontrols": null,
"value": ""
},
{
"label": "cat_pnom",
"columnname": "cat_pnom",
"widgetname": "data_cat_pnom",
"widgettype": "text",
"widgetfunction": null,
"hidden": false,
"widgetdim": null,
"datatype": "string",
"tooltip": "cat_pnom - Presión nominal del elemento en atm. No se puede rellenar. Se usa el que tenga el campo pnom en el catálogo correspondiente",
"placeholder": null,
"iseditable": false,
"orderby": 9,
"layoutname": "lyt_data_1",
"layoutorder": 6,
"isparent": false,
"ismandatory": false,
"linkedaction": null,
"isautoupdate": false,
"stylesheet": null,
"widgetcontrols": null,
"value": ""
},
{
"label": "cat_dnom",
"columnname": "cat_dnom",
"widgetname": "data_cat_dnom",
"widgettype": "text",
"widgetfunction": null,
"hidden": false,
"widgetdim": null,
"datatype": "string",
"tooltip": "cat_dnom - Díametro nominal del elemento en mm. No se puede rellenar. Se usa el que tenga el campo dnom en el catálogo correspondiente",
"placeholder": null,
"iseditable": false,
"orderby": 10,
"layoutname": "lyt_data_1",
"layoutorder": 7,
"isparent": false,
"ismandatory": false,
"linkedaction": null,
"isautoupdate": false,
"stylesheet": null,
"widgetcontrols": null,
"value": ""
},
{
"label": "work_id",
"columnname": "workcat_id",
"widgetname": "data_workcat_id",
"widgettype": "typeahead",
"widgetfunction": null,
"hidden": false,
"widgetdim": null,
"datatype": "string",
"tooltip": "workcat_id - Relacionado con el catálogo de expedientes de trabajo (cat_work). Expediente que da de alta el elemento",
"placeholder": null,
"iseditable": true,
"orderby": 11,
"layoutname": "lyt_data_1",
"layoutorder": 8,
"parentId": null,
"isparent": false,
"ismandatory": false,
"linkedaction": "action_workcat",
"queryText": "SELECT id, id as idval FROM cat_work WHERE id IS NOT NULL",
"queryTextFilter": null,
"isautoupdate": false,
"orderById": null,
"isNullValue": null,
"stylesheet": null,
"widgetcontrols": null,
"value": "work1"
},
{
"label": "builtdate",
"columnname": "builtdate",
"widgetname": "data_builtdate",
"widgettype": "datetime",
"widgetfunction": null,
"hidden": false,
"widgetdim": null,
"datatype": "date",
"tooltip": "builtdate - Fecha de alta del elemento. En inserción de nuevos elementos se muestra la fecha del día",
"placeholder": null,
"iseditable": true,
"orderby": 12,
"layoutname": "lyt_data_1",
"layoutorder": 9,
"isparent": false,
"ismandatory": false,
"linkedaction": null,
"isautoupdate": false,
"stylesheet": null,
"widgetcontrols": null,
"value": ""
},
{
"label": "owner",
"columnname": "ownercat_id",
"widgetname": "data_ownercat_id",
"widgettype": "combo",
"widgetfunction": null,
"hidden": false,
"widgetdim": null,
"datatype": "string",
"tooltip": "ownercat_id - Relacionado con el catálogo de propietarios (cat_owner)",
"placeholder": null,
"iseditable": true,
"orderby": 13,
"layoutname": "lyt_data_1",
"layoutorder": 11,
"isparent": false,
"ismandatory": false,
"linkedaction": null,
"isautoupdate": false,
"stylesheet": null,
"widgetcontrols": null,
"comboIds": [
"",
"owner1",
"owner2",
"owner3"
],
"comboNames": [
"",
"owner1",
"owner2",
"owner3"
],
"selectedId": "owner1"
},
{
"label": "work_id_end",
"columnname": "workcat_id_end",
"widgetname": "data_workcat_id_end",
"widgettype": "typeahead",
"widgetfunction": null,
"hidden": false,
"widgetdim": null,
"datatype": "string",
"tooltip": "workcat_id_end - Relacionado con el catálogo de expedientes de trabajo (cat_work). Expediente que da de baja el elemento",
"placeholder": "Only when state is obsolete",
"iseditable": true,
"orderby": 14,
"layoutname": "lyt_data_1",
"layoutorder": 12,
"parentId": null,
"isparent": false,
"ismandatory": false,
"linkedaction": null,
"queryText": "SELECT id, id as idval FROM cat_work WHERE id IS NOT NULL",
"queryTextFilter": null,
"isautoupdate": false,
"orderById": null,
"isNullValue": null,
"stylesheet": null,
"widgetcontrols": null,
"value": ""
},
{
"label": "enddate",
"columnname": "enddate",
"widgetname": "data_enddate",
"widgettype": "datetime",
"widgetfunction": null,
"hidden": false,
"widgetdim": null,
"datatype": "date",
"tooltip": "enddate - Fecha de baja del elemento. Solo se rellenará si el elemento se encuentra en estado de baja. ",
"placeholder": null,
"iseditable": true,
"orderby": 15,
"layoutname": "lyt_data_1",
"layoutorder": 13,
"isparent": false,
"ismandatory": false,
"linkedaction": null,
"isautoupdate": false,
"stylesheet": null,
"widgetcontrols": null,
"value": ""
},
{
"label": "staticpressure",
"columnname": "staticpressure",
"widgetname": "data_staticpressure",
"widgettype": "text",
"widgetfunction": null,
"hidden": false,
"widgetdim": null,
"datatype": "integer",
"tooltip": "staticpressure - Presión estática calculada dinámicamente y vinculada con la zona de presión",
"placeholder": null,
"iseditable": false,
"orderby": 16,
"layoutname": "lyt_data_1",
"layoutorder": 17,
"isparent": false,
"ismandatory": false,
"linkedaction": null,
"isautoupdate": false,
"stylesheet": null,
"value": "",
"widgetcontrols": {}
},
{
"label": "minsector_id",
"columnname": "minsector_id",
"widgetname": "data_minsector_id",
"widgettype": "text",
"widgetfunction": null,
"hidden": false,
"widgetdim": null,
"datatype": "integer",
"tooltip": "minsector_id - Identificador del minsector (sector mínimo de la red) al que pertenece el elemento",
"placeholder": null,
"iseditable": false,
"orderby": 17,
"layoutname": "lyt_data_1",
"layoutorder": 20,
"isparent": false,
"ismandatory": false,
"linkedaction": null,
"isautoupdate": false,
"stylesheet": null,
"value": "",
"widgetcontrols": {}
},
{
"label": "hemisphere",
"columnname": "hemisphere",
"widgetname": "data_hemisphere",
"widgettype": "text",
"widgetfunction": null,
"hidden": false,
"widgetdim": null,
"datatype": "string",
"tooltip": "hemisphere - Actualiza el valor de rotación. Puede ser calculado automáticamente sumando 180 grados a la rotación o manualmente por el usuario clicando en el mapa",
"placeholder": null,
"iseditable": true,
"orderby": 18,
"layoutname": "lyt_data_1",
"layoutorder": 997,
"isparent": false,
"ismandatory": false,
"linkedaction": null,
"isautoupdate": false,
"stylesheet": null,
"widgetcontrols": null,
"value": ""
},
{
"label": "parent_id",
"columnname": "parent_id",
"widgetname": "data_parent_id",
"widgettype": "typeahead",
"widgetfunction": null,
"hidden": false,
"widgetdim": null,
"datatype": "string",
"tooltip": "parent_id - Identificador de su nodo pariente. Un nodo padre puede tener varios otros nodos contenidos dentro de él",
"placeholder": "Optional: Node_id of the parent node",
"iseditable": true,
"orderby": 19,
"layoutname": "lyt_data_1",
"layoutorder": 998,
"parentId": null,
"isparent": false,
"ismandatory": false,
"linkedaction": null,
"queryText": "SELECT node_id AS id, node_id AS idval FROM node WHERE node_id IS NOT NULL",
"queryTextFilter": null,
"isautoupdate": false,
"orderById": null,
"isNullValue": null,
"stylesheet": null,
"widgetcontrols": null,
"value": ""
},
{
"label": "arc_id",
"columnname": "arc_id",
"widgetname": "data_arc_id",
"widgettype": "typeahead",
"widgetfunction": null,
"hidden": false,
"widgetdim": null,
"datatype": "string",
"tooltip": "arc_id - Id del arco al que se vincula. Pensado para elementos que no rompen la red y por lo tanto solo se vinculan con un tramo",
"placeholder": "Optional: Arc_id of related arc",
"iseditable": false,
"orderby": 20,
"layoutname": "lyt_data_2",
"layoutorder": 0,
"parentId": null,
"isparent": false,
"ismandatory": false,
"linkedaction": null,
"queryText": "SELECT arc_id as id, arc_id as idval FROM arc WHERE arc_id IS NOT NULL",
"queryTextFilter": null,
"isautoupdate": false,
"orderById": null,
"isNullValue": true,
"stylesheet": null,
"widgetcontrols": null,
"value": ""
},
{
"label": "soilcat_id",
"columnname": "soilcat_id",
"widgetname": "data_soilcat_id",
"widgettype": "combo",
"widgetfunction": null,
"hidden": false,
"widgetdim": null,
"datatype": "string",
"tooltip": "soilcat_id - Relacionado con el catalogo de suelos (cat_soil)",
"placeholder": null,
"iseditable": true,
"orderby": 21,
"layoutname": "lyt_data_2",
"layoutorder": 2,
"isparent": false,
"ismandatory": false,
"linkedaction": null,
"isautoupdate": false,
"stylesheet": null,
"widgetcontrols": null,
"comboIds": [
"",
"soil1",
"soil2",
"soil3"
],
"comboNames": [
"",
"soil1",
"soil2",
"soil3"
],
"selectedId": "soil1"
},
{
"label": "function_type",
"columnname": "function_type",
"widgetname": "data_function_type",
"widgettype": "combo",
"widgetfunction": null,
"hidden": false,
"widgetdim": null,
"datatype": "string",
"tooltip": "function_type - Tipo de función a escoger en el desplegable personalizado por el usuario en la tabla man_type_function",
"placeholder": null,
"iseditable": true,
"orderby": 22,
"layoutname": "lyt_data_2",
"layoutorder": 3,
"isparent": false,
"ismandatory": false,
"linkedaction": null,
"isautoupdate": false,
"stylesheet": null,
"widgetcontrols": null,
"comboIds": [
"",
"St. Function"
],
"comboNames": [
"",
"St. Function"
],
"selectedId": ""
},
{
"label": "category_type",
"columnname": "category_type",
"widgetname": "data_category_type",
"widgettype": "combo",
"widgetfunction": null,
"hidden": false,
"widgetdim": null,
"datatype": "string",
"tooltip": "category_type - Tipo de categoría a escoger en el desplegable personalizado por el usuario en la tabla man_type_category",
"placeholder": null,
"iseditable": true,
"orderby": 23,
"layoutname": "lyt_data_2",
"layoutorder": 4,
"isparent": false,
"ismandatory": false,
"linkedaction": null,
"isautoupdate": false,
"stylesheet": null,
"widgetcontrols": null,
"comboIds": [
"",
"St. Category"
],
"comboNames": [
"",
"St. Category"
],
"selectedId": ""
},
{
"label": "fluid_type",
"columnname": "fluid_type",
"widgetname": "data_fluid_type",
"widgettype": "combo",
"widgetfunction": null,
"hidden": false,
"widgetdim": null,
"datatype": "string",
"tooltip": "fluid_type - Tipo de fluido a escoger en el desplegable personalizado por el usuario en la tabla man_type_fluid",
"placeholder": null,
"iseditable": true,
"orderby": 24,
"layoutname": "lyt_data_2",
"layoutorder": 5,
"isparent": false,
"ismandatory": false,
"linkedaction": null,
"isautoupdate": false,
"stylesheet": null,
"widgetcontrols": null,
"comboIds": [
"",
"St. Fluid"
],
"comboNames": [
"",
"St. Fluid"
],
"selectedId": ""
},
{
"label": "location_type",
"columnname": "location_type",
"widgetname": "data_location_type",
"widgettype": "combo",
"widgetfunction": null,
"hidden": false,
"widgetdim": null,
"datatype": "string",
"tooltip": "location_type - Tipo de localización a escoger en el desplegable personalizado por el usuario en la tabla man_type_location",
"placeholder": null,
"iseditable": true,
"orderby": 25,
"layoutname": "lyt_data_2",
"layoutorder": 6,
"isparent": false,
"ismandatory": false,
"linkedaction": null,
"isautoupdate": false,
"stylesheet": null,
"widgetcontrols": null,
"comboIds": [
"",
"St. Location"
],
"comboNames": [
"",
"St. Location"
],
"selectedId": ""
},
{
"label": "Catalog label",
"columnname": "label",
"widgetname": "data_label",
"widgettype": "text",
"widgetfunction": null,
"hidden": false,
"widgetdim": null,
"datatype": "string",
"tooltip": "label - Etiqueta procediente del catalogo de nodos, por esto no será editable en el formulario",
"placeholder": null,
"iseditable": false,
"orderby": 26,
"layoutname": "lyt_data_2",
"layoutorder": 15,
"isparent": false,
"ismandatory": false,
"linkedaction": null,
"isautoupdate": false,
"stylesheet": null,
"widgetcontrols": null,
"value": ""
},
{
"label": "label_y",
"columnname": "label_y",
"widgetname": "data_label_y",
"widgettype": "text",
"widgetfunction": null,
"hidden": false,
"widgetdim": null,
"datatype": "string",
"tooltip": "label_y - Campo para establecer la coordenada Y de la etiqueta ",
"placeholder": null,
"iseditable": true,
"orderby": 27,
"layoutname": "lyt_data_2",
"layoutorder": 16,
"isparent": false,
"ismandatory": false,
"linkedaction": null,
"isautoupdate": false,
"stylesheet": null,
"widgetcontrols": null,
"value": ""
},
{
"label": "label_x",
"columnname": "label_x",
"widgetname": "data_label_x",
"widgettype": "text",
"widgetfunction": null,
"hidden": false,
"widgetdim": null,
"datatype": "string",
"tooltip": "label_x - Campo para establecer la coordenada X de la etiqueta ",
"placeholder": null,
"iseditable": true,
"orderby": 28,
"layoutname": "lyt_data_2",
"layoutorder": 17,
"isparent": false,
"ismandatory": false,
"linkedaction": null,
"isautoupdate": false,
"stylesheet": null,
"widgetcontrols": null,
"value": ""
},
{
"label": "label_rotation",
"columnname": "label_rotation",
"widgetname": "data_label_rotation",
"widgettype": "text",
"widgetfunction": null,
"hidden": false,
"widgetdim": null,
"datatype": "double",
"tooltip": "label_rotation - Campo opcional para establecer, en grados, la rotación de la etiqueta",
"placeholder": null,
"iseditable": true,
"orderby": 29,
"layoutname": "lyt_data_2",
"layoutorder": 18,
"isparent": false,
"ismandatory": false,
"linkedaction": null,
"isautoupdate": false,
"stylesheet": null,
"value": "",
"widgetcontrols": {}
},
{
"label": "rotation",
"columnname": "rotation",
"widgetname": "data_rotation",
"widgettype": "text",
"widgetfunction": null,
"hidden": false,
"widgetdim": null,
"datatype": "double",
"tooltip": "rotation - Rotación del símbolo. Por defecto se calcula automáticamente en función de los ángulos de los arcos vinculados",
"placeholder": null,
"iseditable": true,
"orderby": 30,
"layoutname": "lyt_data_2",
"layoutorder": 23,
"isparent": false,
"ismandatory": false,
"linkedaction": null,
"isautoupdate": false,
"stylesheet": null,
"value": "",
"widgetcontrols": {}
},
{
"label": "verified",
"columnname": "verified",
"widgetname": "data_verified",
"widgettype": "combo",
"widgetfunction": null,
"hidden": false,
"widgetdim": null,
"datatype": "string",
"tooltip": "verified - Para establecer si el elemento esta verificado o no",
"placeholder": null,
"iseditable": true,
"orderby": 31,
"layoutname": "lyt_data_2",
"layoutorder": 30,
"isparent": false,
"ismandatory": false,
"linkedaction": null,
"isautoupdate": false,
"stylesheet": null,
"widgetcontrols": null,
"comboIds": [
"",
"TO REVIEW",
"VERIFIED"
],
"comboNames": [
"",
"TO REVIEW",
"VERIFIED"
],
"selectedId": "VERIFIED"
},
{
"label": "Presszone",
"columnname": "presszone_id",
"widgetname": "data_presszone_id",
"widgettype": "combo",
"widgetfunction": null,
"hidden": false,
"widgetdim": null,
"datatype": "string",
"tooltip": "presszonecat_id - Relacionado con el catálogo de zonas de presión",
"placeholder": null,
"iseditable": true,
"orderby": 32,
"layoutname": "lyt_data_2",
"layoutorder": 31,
"isparent": false,
"ismandatory": false,
"linkedaction": null,
"isautoupdate": false,
"stylesheet": null,
"widgetcontrols": null,
"comboIds": [
"0",
"1",
"3",
"4"
],
"comboNames": [
"Undefined",
"pzone1-1s",
"pzone1-1d",
"pzone1-2d"
],
"selectedId": "3"
},
{
"label": "Dqa",
"columnname": "dqa_id",
"widgetname": "data_dqa_id",
"widgettype": "combo",
"widgetfunction": null,
"hidden": false,
"widgetdim": null,
"datatype": "integer",
"tooltip": "dqa_id - Identificador de la dqa(zona de calidad del agua) a la que pertenece el elemento",
"placeholder": null,
"iseditable": false,
"orderby": 33,
"layoutname": "lyt_data_2",
"layoutorder": 32,
"isparent": false,
"ismandatory": false,
"linkedaction": null,
"isautoupdate": false,
"stylesheet": null,
"comboIds": [
"0",
"1",
"2",
"3",
"4"
],
"comboNames": [
"Undefined",
"dqa1-1d",
"dqa2-1d",
"dqa1-1s",
"dqa2-1s"
],
"selectedId": "",
"widgetcontrols": {}
},
{
"label": "exploitation",
"columnname": "expl_id",
"widgetname": "data_expl_id",
"widgettype": "combo",
"widgetfunction": null,
"hidden": false,
"widgetdim": null,
"datatype": "integer",
"tooltip": "expl_id - Explotación a la que pertenece el elemento. Si no se modifica la configuración, el programa lo selecciona automáticamente en función de la geometría",
"placeholder": null,
"iseditable": true,
"orderby": 34,
"layoutname": "lyt_data_2",
"layoutorder": 33,
"isparent": true,
"ismandatory": false,
"linkedaction": null,
"isautoupdate": false,
"stylesheet": {
"label": "color:red; font-weight:bold"
},
"comboIds": [
"0",
"1",
"2"
],
"comboNames": [
"Undefined",
"expl_01",
"expl_02"
],
"selectedId": "1",
"widgetcontrols": {}
},
{
"label": "municipality",
"columnname": "muni_id",
"widgetname": "data_muni_id",
"widgettype": "combo",
"widgetfunction": null,
"hidden": false,
"widgetdim": null,
"datatype": "integer",
"tooltip": "muni_id - Municipio al que pertenece el elemento. Si no se modifica la configuración, el programa lo selecciona automáticamente en función de la geometría",
"placeholder": null,
"iseditable": true,
"orderby": 35,
"layoutname": "lyt_data_3",
"layoutorder": 0,
"isparent": true,
"ismandatory": false,
"linkedaction": null,
"isautoupdate": false,
"stylesheet": null,
"comboIds": [
"1",
"2"
],
"comboNames": [
"Sant Boi del Llobregat",
"Sant Esteve de les Roures"
],
"selectedId": "1",
"widgetcontrols": {}
},
{
"label": "postcode",
"columnname": "postcode",
"widgetname": "data_postcode",
"widgettype": "text",
"widgetfunction": null,
"hidden": false,
"widgetdim": null,
"datatype": "string",
"tooltip": "postcode - Código postal del municipio",
"placeholder": null,
"iseditable": true,
"orderby": 36,
"layoutname": "lyt_data_3",
"layoutorder": 1,
"isparent": false,
"ismandatory": false,
"linkedaction": null,
"isautoupdate": false,
"stylesheet": null,
"widgetcontrols": null,
"value": ""
},
{
"label": "district",
"columnname": "district_id",
"widgetname": "data_district_id",
"widgettype": "combo",
"widgetfunction": null,
"hidden": false,
"widgetdim": null,
"datatype": "integer",
"tooltip": "district_id - Identificador del barrio con el que se vincula el elemento. A escoger entre los disponibles en el desplegable (se filtra en función del municipio seleccionado)",
"placeholder": null,
"iseditable": true,
"orderby": 37,
"layoutname": "lyt_data_3",
"layoutorder": 2,
"isparent": false,
"ismandatory": false,
"linkedaction": null,
"isautoupdate": false,
"stylesheet": null,
"comboIds": [
"1",
"2"
],
"comboNames": [
"Camps Blancs",
"Marianao"
],
"selectedId": "",
"widgetcontrols": {}
},
{
"label": "streetname",
"columnname": "streetname",
"widgetname": "data_streetname",
"widgettype": "typeahead",
"widgetfunction": null,
"hidden": false,
"widgetdim": null,
"datatype": "string",
"tooltip": "streetaxis_id - Identificador de la calle con la que se vincula el elemento. A escoger entre los disponibles en el desplegable (se filtra en función de las explotaciones seleccionadas)",
"placeholder": null,
"iseditable": true,
"orderby": 38,
"layoutname": "lyt_data_3",
"layoutorder": 3,
"parentId": "muni_id",
"isparent": false,
"ismandatory": false,
"linkedaction": null,
"queryText": "SELECT id AS id, a.name AS idval FROM ext_streetaxis a JOIN ext_municipality m USING (muni_id) WHERE id IS NOT NULL",
"queryTextFilter": "AND m.name",
"isautoupdate": false,
"orderById": null,
"isNullValue": true,
"stylesheet": null,
"widgetcontrols": null,
"value": ""
},
{
"label": "postnumber",
"columnname": "postnumber",
"widgetname": "data_postnumber",
"widgettype": "typeahead",
"widgetfunction": null,
"hidden": false,
"widgetdim": null,
"datatype": "integer",
"tooltip": "postnumber - Número de calle",
"placeholder": null,
"iseditable": true,
"orderby": 39,
"layoutname": "lyt_data_3",
"layoutorder": 4,
"parentId": "streetname",
"isparent": false,
"ismandatory": false,
"linkedaction": null,
"queryText": "SELECT a.postnumber AS id, a.postnumber AS idval FROM ext_address a JOIN ext_streetaxis m ON streetaxis_id=m.id WHERE a.id IS NOT NULL",
"queryTextFilter": "AND m.name",
"isautoupdate": false,
"orderById": null,
"isNullValue": null,
"stylesheet": null,
"value": "",
"widgetcontrols": {}
},
{
"label": "postcomplement",
"columnname": "postcomplement",
"widgetname": "data_postcomplement",
"widgettype": "text",
"widgetfunction": null,
"hidden": false,
"widgetdim": null,
"datatype": "string",
"tooltip": "postcomplement - Complemento opcional del número de calle",
"placeholder": null,
"iseditable": true,
"orderby": 40,
"layoutname": "lyt_data_3",
"layoutorder": 5,
"isparent": false,
"ismandatory": false,
"linkedaction": null,
"isautoupdate": false,
"stylesheet": null,
"widgetcontrols": null,
"value": ""
},
{
"label": "streetname2",
"columnname": "streetname2",
"widgetname": "data_streetname2",
"widgettype": "typeahead",
"widgetfunction": null,
"hidden": false,
"widgetdim": null,
"datatype": "string",
"tooltip": "streetaxis2_id - Identificador de la segunda calle con la que se vincula el elemento. A escoger entre los disponibles en el desplegable (se filtra en función de las explotaciones seleccionadas)",
"placeholder": null,
"iseditable": true,
"orderby": 41,
"layoutname": "lyt_data_3",
"layoutorder": 6,
"parentId": "muni_id",
"isparent": false,
"ismandatory": false,
"linkedaction": null,
"queryText": "SELECT id AS id, a.name AS idval FROM ext_streetaxis a JOIN ext_municipality m USING (muni_id) WHERE id IS NOT NULL",
"queryTextFilter": "AND m.name",
"isautoupdate": false,
"orderById": null,
"isNullValue": true,
"stylesheet": null,
"widgetcontrols": null,
"value": ""
},
{
"label": "postnumber2",
"columnname": "postnumber2",
"widgetname": "data_postnumber2",
"widgettype": "typeahead",
"widgetfunction": null,
"hidden": false,
"widgetdim": null,
"datatype": "integer",
"tooltip": "postnumber2 - Segundo número de calle",
"placeholder": null,
"iseditable": true,
"orderby": 42,
"layoutname": "lyt_data_3",
"layoutorder": 7,
"parentId": "streetname2",
"isparent": false,
"ismandatory": false,
"linkedaction": null,
"queryText": "SELECT a.postnumber AS id, a.postnumber AS idval FROM ext_address a JOIN ext_streetaxis m ON streetaxis_id=m.id WHERE a.id IS NOT NULL",
"queryTextFilter": "AND m.name",
"isautoupdate": false,
"orderById": null,
"isNullValue": null,
"stylesheet": null,
"value": "",
"widgetcontrols": {}
},
{
"label": "postcomplement2",
"columnname": "postcomplement2",
"widgetname": "data_postcomplement2",
"widgettype": "text",
"widgetfunction": null,
"hidden": false,
"widgetdim": null,
"datatype": "string",
"tooltip": "postcomplement2 - Complemento opcional del segundo número de calle",
"placeholder": null,
"iseditable": true,
"orderby": 43,
"layoutname": "lyt_data_3",
"layoutorder": 8,
"isparent": false,
"ismandatory": false,
"linkedaction": null,
"isautoupdate": false,
"stylesheet": null,
"widgetcontrols": null,
"value": ""
},
{
"label": "descript",
"columnname": "descript",
"widgetname": "data_descript",
"widgettype": "text",
"widgetfunction": null,
"hidden": false,
"widgetdim": null,
"datatype": "string",
"tooltip": "descript - Campo opcional para añadir una descripción del elemento",
"placeholder": null,
"iseditable": true,
"orderby": 44,
"layoutname": "lyt_data_3",
"layoutorder": 13,
"isparent": false,
"ismandatory": false,
"linkedaction": null,
"isautoupdate": false,
"stylesheet": null,
"widgetcontrols": null,
"value": ""
},
{
"label": "annotation",
"columnname": "annotation",
"widgetname": "data_annotation",
"widgettype": "text",
"widgetfunction": null,
"hidden": false,
"widgetdim": null,
"datatype": "string",
"tooltip": "annotation - Campo opcional para añadir anotaciones sobre el elemento",
"placeholder": null,
"iseditable": true,
"orderby": 45,
"layoutname": "lyt_data_3",
"layoutorder": 14,
"isparent": false,
"ismandatory": false,
"linkedaction": null,
"isautoupdate": false,
"stylesheet": null,
"widgetcontrols": null,
"value": ""
},
{
"label": "observ",
"columnname": "observ",
"widgetname": "data_observ",
"widgettype": "text",
"widgetfunction": null,
"hidden": false,
"widgetdim": null,
"datatype": "string",
"tooltip": "observ - Campo opcional para añadir observaciones sobre el elemento",
"placeholder": null,
"iseditable": true,
"orderby": 46,
"layoutname": "lyt_data_3",
"layoutorder": 15,
"isparent": false,
"ismandatory": false,
"linkedaction": null,
"isautoupdate": false,
"stylesheet": null,
"widgetcontrols": null,
"value": ""
},
{
"label": "Last update",
"columnname": "lastupdate",
"widgetname": "data_lastupdate",
"widgettype": "text",
"widgetfunction": null,
"hidden": false,
"widgetdim": null,
"datatype": "date",
"tooltip": "lastupdate - Última vez que se ha actualizado este elemento",
"placeholder": null,
"iseditable": false,
"orderby": 47,
"layoutname": "lyt_data_3",
"layoutorder": 16,
"isparent": false,
"ismandatory": false,
"linkedaction": null,
"isautoupdate": false,
"stylesheet": null,
"widgetcontrols": null,
"value": ""
},
{
"label": "Last update user",
"columnname": "lastupdate_user",
"widgetname": "data_lastupdate_user",
"widgettype": "text",
"widgetfunction": null,
"hidden": false,
"widgetdim": null,
"datatype": "string",
"tooltip": "lastupdate_user - Último usuario que ha actualizado este elemento",
"placeholder": null,
"iseditable": false,
"orderby": 48,
"layoutname": "lyt_data_3",
"layoutorder": 17,
"isparent": false,
"ismandatory": false,
"linkedaction": null,
"isautoupdate": false,
"stylesheet": null,
"widgetcontrols": null,
"value": ""
},
{
"label": "link",
"columnname": "link",
"widgetname": "data_link",
"widgettype": "hyperlink",
"widgetfunction": "set_open_url",
"hidden": false,
"widgetdim": null,
"datatype": "string",
"tooltip": "link - URL del enlace que se abrirá al clicar el botón de la barra del formulario. Se debe editar desde la base de datos. Se concatena link_path (de las tablas type) + link",
"placeholder": null,
"iseditable": false,
"orderby": 49,
"layoutname": "lyt_data_3",
"layoutorder": 18,
"isparent": false,
"ismandatory": false,
"linkedaction": "action_link",
"isautoupdate": false,
"stylesheet": null,
"widgetcontrols": null,
"value": ""
},
{
"label": "node_id",
"columnname": "node_id",
"widgetname": "data_node_id",
"widgettype": "text",
"widgetfunction": null,
"hidden": false,
"widgetdim": null,
"datatype": "string",
"tooltip": "node_id - Identificador del nodo. No es necesario introducirlo, es un serial automático",
"placeholder": null,
"iseditable": false,
"orderby": 50,
"layoutname": "lyt_none",
"layoutorder": 1,
"isparent": false,
"ismandatory": false,
"linkedaction": null,
"isautoupdate": false,
"stylesheet": null,
"widgetcontrols": null,
"value": "114465"
},
{
"label": "node_type",
"columnname": "node_type",
"widgetname": "data_node_type",
"widgettype": "text",
"widgetfunction": null,
"hidden": false,
"widgetdim": null,
"datatype": "string",
"tooltip": "node_type - Tipo de nodo. Se rellena automáticamente en función de nodecat_id",
"placeholder": null,
"iseditable": false,
"orderby": 51,
"layoutname": "lyt_top_1",
"layoutorder": 2,
"isparent": true,
"ismandatory": false,
"linkedaction": null,
"isautoupdate": false,
"stylesheet": null,
"widgetcontrols": null,
"value": "JUNCTION"
},
{
"label": "nodecat_id",
"columnname": "nodecat_id",
"widgetname": "data_nodecat_id",
"widgettype": "typeahead",
"widgetfunction": null,
"hidden": false,
"widgetdim": null,
"datatype": "string",
"tooltip": "nodecat_id - A seleccionar del catálogo de nodos. Se filtra en función del elemento que insertes",
"placeholder": null,
"iseditable": true,
"orderby": 52,
"layoutname": "lyt_top_1",
"layoutorder": 7,
"parentId": "node_type",
"isparent": false,
"ismandatory": true,
"linkedaction": "action_catalog",
"queryText": "SELECT id, id as idval FROM cat_node WHERE id IS NOT NULL",
"queryTextFilter": " AND nodetype_id",
"isautoupdate": false,
"orderById": null,
"isNullValue": null,
"stylesheet": null,
"widgetcontrols": {},
"value": ""
},
{
"label": "epa type",
"columnname": "epa_type",
"widgetname": "data_epa_type",
"widgettype": "combo",
"widgetfunction": null,
"hidden": false,
"widgetdim": null,
"datatype": "string",
"tooltip": "epa_type - Tipo de nodo que se usará para el modelo hidráulico. No es necesario introducirlo, es automático en función del nodecat.",
"placeholder": null,
"iseditable": true,
"orderby": 53,
"layoutname": "lyt_top_1",
"layoutorder": 11,
"isparent": false,
"ismandatory": false,
"linkedaction": null,
"isautoupdate": false,
"stylesheet": null,
"widgetcontrols": null,
"comboIds": [
"INLET",
"JUNCTION",
"NOT DEFINED",
"PUMP",
"RESERVOIR",
"SHORTPIPE",
"TANK",
"VALVE"
],
"comboNames": [
"INLET",
"JUNCTION",
"NOT DEFINED",
"PUMP",
"RESERVOIR",
"SHORTPIPE",
"TANK",
"VALVE"
],
"selectedId": "JUNCTION"
}
]
},
"returnManager": {
"style": {
"ruberband": {
"width": 3,
"color": [
255,
0,
0
],
"transparency": 0.5
}
},
"zoom": {
"margin": 50
},
"functionId": 2582
}
}
}