gw_fct_getdimensioning - Giswater/giswater_dbmodel GitHub Wiki
Description
Function to manage dimensioning.
Input example
SELECT gw_fct_getdimensioning($${
"client":{"device":4, "infoType":1, "lang":"ES"},
"form":{}, "feature":{},
"data":{"filterFields":{}, "pageInfo":{},
"coordinates":{"x1":418482.9909557662, "y1":4577973.008625593,
"x2":418513.4491390207, "y2":4577971.030821485}}}$$);
Output example
{
"status": "Accepted",
"message": {},
"version": {
"value": "3.4.021"
},
"body": {
"form": {},
"feature": {
"tableName": "v_edit_dimensions",
"idName": "id",
"id": 1
},
"data": {
"linkPath": {},
"parentFields": {},
"fields": [
{
"label": "state",
"columnname": "state",
"widgetname": "_state",
"widgettype": "combo",
"widgetfunction": null,
"type": "combo",
"name": "state",
"dataType": "integer",
"widgetAction": null,
"updateAction": null,
"changeAction": null,
"position": "body",
"disabled": false,
"hidden": false,
"widgetdim": null,
"datatype": "integer",
"tooltip": null,
"placeholder": null,
"iseditable": true,
"orderby": 1,
"layoutname": "lyt_bot_1",
"layoutorder": 12,
"isparent": true,
"ismandatory": true,
"linkedaction": null,
"isautoupdate": false,
"stylesheet": null,
"widgetcontrols": null,
"comboIds": [
"0",
"1",
"2"
],
"comboNames": [
"OBSOLETE",
"ON_SERVICE",
"PLANIFIED"
],
"selectedId": "1"
},
{
"label": "expl_id",
"columnname": "expl_id",
"widgetname": "_expl_id",
"widgettype": "combo",
"widgetfunction": null,
"type": "combo",
"name": "expl_id",
"dataType": "integer",
"widgetAction": null,
"updateAction": null,
"changeAction": null,
"position": "body",
"disabled": false,
"hidden": false,
"widgetdim": null,
"datatype": "integer",
"tooltip": null,
"placeholder": null,
"iseditable": true,
"orderby": 2,
"layoutname": "lyt_data_2",
"layoutorder": 33,
"isparent": false,
"ismandatory": true,
"linkedaction": null,
"isautoupdate": false,
"stylesheet": {
"label": "color:red; font-weight:bold"
},
"widgetcontrols": null,
"comboIds": [
"1",
"2"
],
"comboNames": [
"expl_01",
"expl_02"
],
"selectedId": "1"
},
{
"label": "observ",
"columnname": "observ",
"widgettype": "text",
"widgetfunction": null,
"type": "text",
"name": "observ",
"dataType": "text",
"widgetAction": null,
"updateAction": null,
"changeAction": null,
"position": "body",
"disabled": false,
"hidden": false,
"widgetdim": null,
"datatype": "text",
"tooltip": null,
"placeholder": null,
"iseditable": true,
"orderby": 3,
"layoutname": "lyt_data_3",
"layoutorder": 15,
"isparent": false,
"ismandatory": false,
"linkedaction": null,
"isautoupdate": false,
"stylesheet": null,
"widgetcontrols": null,
"widgetname": "observ"
},
{
"label": "distance",
"columnname": "distance",
"widgettype": "text",
"widgetfunction": null,
"type": "text",
"name": "distance",
"dataType": "double",
"widgetAction": null,
"updateAction": null,
"changeAction": null,
"position": "body",
"disabled": false,
"hidden": false,
"widgetdim": null,
"datatype": "double",
"tooltip": null,
"placeholder": null,
"iseditable": true,
"orderby": 4,
"layoutname": "lyt_measurements",
"layoutorder": 0,
"isparent": false,
"ismandatory": false,
"linkedaction": null,
"isautoupdate": false,
"stylesheet": null,
"widgetcontrols": null,
"widgetname": "distance"
},
{
"label": "depth",
"columnname": "depth",
"widgettype": "text",
"widgetfunction": null,
"type": "text",
"name": "depth",
"dataType": "double",
"widgetAction": null,
"updateAction": null,
"changeAction": null,
"position": "body",
"disabled": false,
"hidden": false,
"widgetdim": null,
"datatype": "double",
"tooltip": null,
"placeholder": null,
"iseditable": true,
"orderby": 5,
"layoutname": "lyt_measurements",
"layoutorder": 4,
"isparent": false,
"ismandatory": false,
"linkedaction": null,
"isautoupdate": false,
"stylesheet": null,
"widgetcontrols": null,
"widgetname": "depth"
},
{
"label": "feature_type",
"columnname": "feature_type",
"widgettype": "text",
"widgetfunction": null,
"type": "text",
"name": "feature_type",
"dataType": "string",
"widgetAction": null,
"updateAction": null,
"changeAction": null,
"position": "body",
"disabled": false,
"hidden": false,
"widgetdim": null,
"datatype": "string",
"tooltip": null,
"placeholder": null,
"iseditable": true,
"orderby": 6,
"layoutname": "lyt_measurements",
"layoutorder": 6,
"isparent": false,
"ismandatory": false,
"linkedaction": null,
"isautoupdate": false,
"stylesheet": null,
"widgetcontrols": null,
"widgetname": "feature_type"
},
{
"label": "id",
"columnname": "id",
"widgettype": "text",
"widgetfunction": null,
"type": "text",
"name": "id",
"dataType": "integer",
"widgetAction": null,
"updateAction": null,
"changeAction": null,
"position": "body",
"disabled": false,
"hidden": false,
"widgetdim": null,
"datatype": "integer",
"tooltip": null,
"placeholder": null,
"iseditable": true,
"orderby": 7,
"layoutname": "lyt_none",
"layoutorder": 1,
"isparent": false,
"ismandatory": false,
"linkedaction": null,
"isautoupdate": false,
"stylesheet": null,
"widgetcontrols": null,
"widgetname": "id"
},
{
"label": "x_symbol",
"columnname": "x_symbol",
"widgettype": "text",
"widgetfunction": null,
"type": "text",
"name": "x_symbol",
"dataType": "double",
"widgetAction": null,
"updateAction": null,
"changeAction": null,
"position": "body",
"disabled": false,
"hidden": false,
"widgetdim": null,
"datatype": "double",
"tooltip": null,
"placeholder": null,
"iseditable": true,
"orderby": 8,
"layoutname": "lyt_symbology",
"layoutorder": 8,
"isparent": false,
"ismandatory": false,
"linkedaction": null,
"isautoupdate": false,
"stylesheet": null,
"widgetcontrols": null,
"widgetname": "x_symbol"
},
{
"label": "y_symbol",
"columnname": "y_symbol",
"widgettype": "text",
"widgetfunction": null,
"type": "text",
"name": "y_symbol",
"dataType": "double",
"widgetAction": null,
"updateAction": null,
"changeAction": null,
"position": "body",
"disabled": false,
"hidden": false,
"widgetdim": null,
"datatype": "double",
"tooltip": null,
"placeholder": null,
"iseditable": true,
"orderby": 9,
"layoutname": "lyt_symbology",
"layoutorder": 9,
"isparent": false,
"ismandatory": false,
"linkedaction": null,
"isautoupdate": false,
"stylesheet": null,
"widgetcontrols": null,
"widgetname": "y_symbol"
},
{
"label": "direction_arrow",
"columnname": "direction_arrow",
"widgettype": "check",
"widgetfunction": null,
"type": "check",
"name": "direction_arrow",
"dataType": "boolean",
"widgetAction": null,
"updateAction": null,
"changeAction": null,
"position": "body",
"disabled": false,
"hidden": false,
"widgetdim": null,
"datatype": "boolean",
"tooltip": null,
"placeholder": null,
"iseditable": true,
"orderby": 10,
"layoutname": "lyt_symbology",
"layoutorder": 11,
"isparent": false,
"ismandatory": false,
"linkedaction": null,
"isautoupdate": false,
"stylesheet": null,
"widgetcontrols": null,
"widgetname": "direction_arrow"
},
{
"label": "offset_label",
"columnname": "offset_label",
"widgettype": "text",
"widgetfunction": null,
"type": "text",
"name": "offset_label",
"dataType": "double",
"widgetAction": null,
"updateAction": null,
"changeAction": null,
"position": "body",
"disabled": false,
"hidden": false,
"widgetdim": null,
"datatype": "double",
"tooltip": null,
"placeholder": null,
"iseditable": true,
"orderby": 11,
"layoutname": "lyt_symbology",
"layoutorder": 12,
"isparent": false,
"ismandatory": false,
"linkedaction": null,
"isautoupdate": false,
"stylesheet": null,
"widgetcontrols": null,
"widgetname": "offset_label"
},
{
"label": "x_label",
"columnname": "x_label",
"widgettype": "text",
"widgetfunction": null,
"type": "text",
"name": "x_label",
"dataType": "double",
"widgetAction": null,
"updateAction": null,
"changeAction": null,
"position": "body",
"disabled": false,
"hidden": false,
"widgetdim": null,
"datatype": "double",
"tooltip": null,
"placeholder": null,
"iseditable": true,
"orderby": 12,
"layoutname": "lyt_symbology",
"layoutorder": 14,
"isparent": false,
"ismandatory": false,
"linkedaction": null,
"isautoupdate": false,
"stylesheet": null,
"widgetcontrols": null,
"widgetname": "x_label"
},
{
"label": "y_label",
"columnname": "y_label",
"widgettype": "text",
"widgetfunction": null,
"type": "text",
"name": "y_label",
"dataType": "double",
"widgetAction": null,
"updateAction": null,
"changeAction": null,
"position": "body",
"disabled": false,
"hidden": false,
"widgetdim": null,
"datatype": "double",
"tooltip": null,
"placeholder": null,
"iseditable": true,
"orderby": 13,
"layoutname": "lyt_symbology",
"layoutorder": 15,
"isparent": false,
"ismandatory": false,
"linkedaction": null,
"isautoupdate": false,
"stylesheet": null,
"widgetcontrols": null,
"widgetname": "y_label"
},
{
"label": "rotation_label",
"columnname": "rotation_label",
"widgettype": "text",
"widgetfunction": null,
"type": "text",
"name": "rotation_label",
"dataType": "double",
"widgetAction": null,
"updateAction": null,
"changeAction": null,
"position": "body",
"disabled": false,
"hidden": false,
"widgetdim": null,
"datatype": "double",
"tooltip": null,
"placeholder": null,
"iseditable": true,
"orderby": 14,
"layoutname": "lyt_symbology",
"layoutorder": 16,
"isparent": false,
"ismandatory": false,
"linkedaction": null,
"isautoupdate": false,
"stylesheet": null,
"widgetcontrols": null,
"widgetname": "rotation_label"
}
]
}
}
}