gw_fct_getinfoplan - Giswater/giswater_dbmodel GitHub Wiki
Description
Get dialog and values for specific feature if exists given row list
Input example
SELECT gw_fct_getinfoplan($${
"client":{"device":4, "infoType":1, "lang":"ES"},
"form":{"tabName":"plan"},
"feature":{"featureType":"arc", "tableName":"ve_arc_pipe", "idName":"arc_id", "id":"113854"},
"data":{}}$$)
Output example
"status": "Accepted",
"version": {
"value": "3.4.019"
},
"body": {
"message": {},
"form": {
"tabName": "plan"
},
"feature": {
"featureType": "arc",
"tableName": "ve_arc_pipe",
"idName": "arc_id",
"id": "113854"
},
"data": {
"fields": [
{
"layoutorder": 1,
"orderby": 1,
"label": "m. Polyethylene tube designation PE 100, of 110 mm nominal diameter, 10 bar of nominal pressure",
"columnname": "element",
"widgettype": "label",
"widgetname": "plan_element",
"datatype": "string",
"tooltip": null,
"placeholder": null,
"iseditable": false,
"layoutname": "lyt_plan_1",
"dv_parent_id": null,
"isparent": null,
"ismandatory": null,
"button_function": null,
"dv_querytext": null,
"dv_querytext_filterc": null,
"linkedaction": null,
"isautoupdate": null,
"value": "1 m x 20.09 €/m = 20.09 €",
"stylesheet": null,
"widgetcontrols": null,
"hidden": null
},
{
"layoutorder": 2,
"orderby": 2,
"label": "m2. Revision and trenching of dense soil of more than 0.6 and less than 1.5 m in width",
"columnname": "m2bottom",
"widgettype": "label",
"widgetname": "plan_m2bottom",
"datatype": "string",
"tooltip": null,
"placeholder": null,
"iseditable": false,
"layoutname": "lyt_plan_1",
"dv_parent_id": null,
"isparent": null,
"ismandatory": null,
"button_function": null,
"dv_querytext": null,
"dv_querytext_filterc": null,
"linkedaction": null,
"isautoupdate": null,
"value": "0.610 m2 x 2.57 €/m2 = 1.57 €",
"stylesheet": null,
"widgetcontrols": null,
"hidden": null
},
{
"layoutorder": 3,
"orderby": 3,
"label": "m3. Filling pipe material",
"columnname": "m3protec",
"widgettype": "label",
"widgetname": "plan_m3protec",
"datatype": "string",
"tooltip": null,
"placeholder": null,
"iseditable": false,
"layoutname": "lyt_plan_1",
"dv_parent_id": null,
"isparent": null,
"ismandatory": null,
"button_function": null,
"dv_querytext": null,
"dv_querytext_filterc": null,
"linkedaction": null,
"isautoupdate": null,
"value": "0.193 m3 x 0.00 €/m3 = 0.00 €",
"stylesheet": null,
"widgetcontrols": null,
"hidden": null
},
{
"layoutorder": 4,
"orderby": 4,
"label": "m3. Excavation of trench up to 2 m in width and up to 4 m in depth",
"columnname": "m3exc",
"widgettype": "label",
"widgetname": "plan_m3exc",
"datatype": "string",
"tooltip": null,
"placeholder": null,
"iseditable": false,
"layoutname": "lyt_plan_1",
"dv_parent_id": null,
"isparent": null,
"ismandatory": null,
"button_function": null,
"dv_querytext": null,
"dv_querytext_filterc": null,
"linkedaction": null,
"isautoupdate": null,
"value": "0.678 m3 x 9.03 €/m3 = 6.12 €",
"stylesheet": null,
"widgetcontrols": null,
"hidden": null
},
{
"layoutorder": 5,
"orderby": 5,
"label": "m3. Reversing and trenching of width ditch more than 1.5 and up to 2 m",
"columnname": "m3fill",
"widgettype": "label",
"widgetname": "plan_m3fill",
"datatype": "string",
"tooltip": null,
"placeholder": null,
"iseditable": false,
"layoutname": "lyt_plan_1",
"dv_parent_id": null,
"isparent": null,
"ismandatory": null,
"button_function": null,
"dv_querytext": null,
"dv_querytext_filterc": null,
"linkedaction": null,
"isautoupdate": null,
"value": "0.475 m3 x 8.92 €/m3 = 4.24 €",
"stylesheet": null,
"widgetcontrols": null,
"hidden": null
},
{
"layoutorder": 6,
"orderby": 6,
"label": "m3. Transport of waste to authorized waste management facility, with 12 t truck and waiting time for loa",
"columnname": "m3excess",
"widgettype": "label",
"widgetname": "plan_m3excess",
"datatype": "string",
"tooltip": null,
"placeholder": null,
"iseditable": false,
"layoutname": "lyt_plan_1",
"dv_parent_id": null,
"isparent": null,
"ismandatory": null,
"button_function": null,
"dv_querytext": null,
"dv_querytext_filterc": null,
"linkedaction": null,
"isautoupdate": null,
"value": "0.203 m3 x 8.12 €/m3 = 1.65 €",
"stylesheet": null,
"widgetcontrols": null,
"hidden": null
},
{
"layoutorder": 7,
"orderby": 7,
"label": "m3. Trenchlining of excavation",
"columnname": "m2trenchl",
"widgettype": "label",
"widgetname": "plan_m2trenchl",
"datatype": "string",
"tooltip": null,
"placeholder": null,
"iseditable": false,
"layoutname": "lyt_plan_1",
"dv_parent_id": null,
"isparent": null,
"ismandatory": null,
"button_function": null,
"dv_querytext": null,
"dv_querytext_filterc": null,
"linkedaction": null,
"isautoupdate": null,
"value": "1.099 m3 x 30.00 €/m3 = 32.97 €",
"stylesheet": null,
"widgetcontrols": null,
"hidden": null
},
{
"layoutorder": 8,
"orderby": 8,
"label": "m2. Pavement of continuous hot bituminous mix 10cm thick",
"columnname": "pavement",
"widgettype": "label",
"widgetname": "plan_pavement",
"datatype": "string",
"tooltip": null,
"placeholder": null,
"iseditable": false,
"layoutname": "lyt_plan_1",
"dv_parent_id": null,
"isparent": null,
"ismandatory": null,
"button_function": null,
"dv_querytext": null,
"dv_querytext_filterc": null,
"linkedaction": null,
"isautoupdate": null,
"value": "0.90000 m2 x 21.89 €/m2 = 19.70 €",
"stylesheet": null,
"widgetcontrols": null,
"hidden": null
},
{
"layoutorder": 9,
"orderby": 9,
"label": "ut. Sumatory of connecs cost related to arc. The cost is calculated in combination of parameters depth/length from connec table and catalog price from cat_connec table",
"columnname": "connec",
"widgettype": "label",
"widgetname": "plan_connec",
"datatype": "string",
"tooltip": null,
"placeholder": null,
"iseditable": false,
"layoutname": "lyt_plan_1",
"dv_parent_id": null,
"isparent": null,
"ismandatory": null,
"button_function": null,
"dv_querytext": null,
"dv_querytext_filterc": null,
"linkedaction": null,
"isautoupdate": null,
"value": "4 ut x €/ut = €",
"stylesheet": null,
"widgetcontrols": null,
"hidden": null
},
{
"layoutorder": 103,
"orderby": 10,
"label": "frame1",
"columnname": "frame1",
"widgettype": "divider",
"widgetname": "plan_frame1",
"datatype": "string",
"tooltip": null,
"placeholder": null,
"iseditable": true,
"layoutname": "lyt_plan_1",
"dv_parent_id": null,
"isparent": null,
"ismandatory": false,
"button_function": null,
"dv_querytext": null,
"dv_querytext_filterc": null,
"linkedaction": null,
"isautoupdate": null,
"value": null,
"stylesheet": null,
"widgetcontrols": null,
"hidden": false
},
{
"layoutorder": 104,
"orderby": 11,
"label": "Unitary cost",
"columnname": "initial_cost",
"widgettype": "label",
"widgetname": "plan_initial_cost",
"datatype": "string",
"tooltip": null,
"placeholder": null,
"iseditable": true,
"layoutname": "lyt_plan_1",
"dv_parent_id": null,
"isparent": null,
"ismandatory": false,
"button_function": null,
"dv_querytext": null,
"dv_querytext_filterc": null,
"linkedaction": null,
"isautoupdate": null,
"stylesheet": null,
"widgetcontrols": null,
"hidden": false,
"value": "100.62 €/ml"
},
{
"layoutorder": 105,
"orderby": 12,
"columnname": "length",
"widgettype": "label",
"widgetname": "plan_length",
"datatype": "string",
"tooltip": null,
"placeholder": null,
"iseditable": true,
"layoutname": "lyt_plan_1",
"dv_parent_id": null,
"isparent": null,
"ismandatory": false,
"button_function": null,
"dv_querytext": null,
"dv_querytext_filterc": null,
"linkedaction": null,
"isautoupdate": null,
"stylesheet": null,
"widgetcontrols": null,
"hidden": false,
"label": "Units",
"value": "39.75 ml"
},
{
"layoutorder": 106,
"orderby": 13,
"label": "frame2",
"columnname": "frame2",
"widgettype": "divider",
"widgetname": "plan_frame2",
"datatype": "string",
"tooltip": null,
"placeholder": null,
"iseditable": true,
"layoutname": "lyt_plan_1",
"dv_parent_id": null,
"isparent": null,
"ismandatory": false,
"button_function": null,
"dv_querytext": null,
"dv_querytext_filterc": null,
"linkedaction": null,
"isautoupdate": null,
"value": null,
"stylesheet": null,
"widgetcontrols": null,
"hidden": false
},
{
"layoutorder": 107,
"orderby": 14,
"label": "Total cost",
"columnname": "total_cost",
"widgettype": "label",
"widgetname": "plan_total_cost",
"datatype": "string",
"tooltip": null,
"placeholder": null,
"iseditable": true,
"layoutname": "lyt_plan_1",
"dv_parent_id": null,
"isparent": null,
"ismandatory": false,
"button_function": null,
"dv_querytext": null,
"dv_querytext_filterc": null,
"linkedaction": null,
"isautoupdate": null,
"stylesheet": null,
"widgetcontrols": null,
"hidden": false,
"value": "3999.50 €"
}
]
}
}
}