gw_fct_getmincut (js) - Giswater/giswater_dbmodel GitHub Wiki

Description

Get dialog and values for mincut form

Input example

SELECT gw_fct_getmincut($${
"client":{"device":4, "infoType":1, "lang":"ES", "cur_user":"test_user"}, "form":{}, 
"feature":{}, 
"data":{"x":"419534.15219828", "y":"4576491.4086902", "srid_arg":"25831", "mincut_id_arg":null, "device":3, "insert_data":"arc", 
"element_type":{}, "lang":"es"}}$$);

Common input parameters: (client, form, feature)

Specific input parameters: (data)
We always work with names as much autodocumented as possible. If you feel some else please request it to [email protected].

Common output parameters: (status, message, version)

Specific output parameters: (body)
We always work with names as much autodocumented as possible. If you feel some else please request it to [email protected].

Output example

{
  "status": "Accepted",
  "apiVersion": {
    "value": "3.4.034"
  },
  "formInfo": {
    "formId": "F41",
    "formName": "NETWORK MINCUT"
  },
  "formTabs": [
    {
      "tabName": "Type",
      "tabLabel": "General",
      "tabText": "Type",
      "active": true,
      "fields": [
        {
          "label": "ID tancament",
          "name": "mincut_id",
          "type": "text",
          "dataType": "string",
          "placeholder": "",
          "disabled": true,
          "value": ""
        },
        {
          "label": "Ordre treball",
          "name": "work_order",
          "type": "text",
          "dataType": "string",
          "placeholder": "",
          "disabled": false,
          "value": ""
        },
        {
          "label": "Estat",
          "name": "mincut_state",
          "type": "combo",
          "dataType": "string",
          "placeholder": "",
          "disabled": true,
          "comboNames": [
            "Canceled",
            "Finished",
            "In Progress",
            "Planified"
          ],
          "comboIds": [
            "3",
            "2",
            "1",
            "0"
          ],
          "selectedId": "0"
        },
        {
          "label": "Tipus",
          "name": "mincut_type",
          "type": "combo",
          "dataType": "string",
          "placeholder": "",
          "disabled": false,
          "comboNames": [
            "Demo",
            "Real",
            "Test"
          ],
          "comboIds": [
            "Demo",
            "Real",
            "Test"
          ],
          "selectedId": "Real"
        },
        {
          "label": "Causa",
          "name": "anl_cause",
          "type": "combo",
          "dataType": "string",
          "placeholder": "",
          "disabled": false,
          "comboNames": [
            "Accidental",
            "Planified"
          ],
          "comboIds": [
            "1",
            "2"
          ],
          "selectedId": "Accidental"
        },
        {
          "label": "Assignat a",
          "name": "assigned_to",
          "type": "combo",
          "dataType": "string",
          "placeholder": "",
          "disabled": false,
          "comboNames": [
            "abofill",
            "geoadmin",
            "postgres",
            "qgisserver",
            "test",
            "user1",
            "user2",
            "user3",
            "user4"
          ],
          "comboIds": [
            "abofill",
            "geoadmin",
            "postgres",
            "qgisserver",
            "test",
            "user1",
            "user2",
            "user3",
            "user4"
          ],
          "selectedId": "1"
        },
        {
          "label": "Descripció",
          "name": "anl_descript",
          "type": "textarea",
          "dataType": "string",
          "placeholder": "",
          "disabled": false,
          "value": ""
        },
        {
          "label": "Dates",
          "name": "divider",
          "type": "formDivider",
          "dataType": "string",
          "placeholder": null,
          "disabled": true,
          "value": ""
        },
        {
          "label": "Rebut",
          "name": "anl_tstamp",
          "type": "datepickertime",
          "dataType": "date",
          "placeholder": "",
          "disabled": false,
          "value": "2022-05-25 11:48:06"
        },
        {
          "label": "Inici previst",
          "name": "forecast_start",
          "type": "datepickertime",
          "dataType": "date",
          "placeholder": "",
          "disabled": false,
          "value": ""
        },
        {
          "label": "Final previst",
          "name": "forecast_end",
          "type": "datepickertime",
          "dataType": "date",
          "placeholder": "",
          "disabled": false,
          "value": ""
        }
      ]
    },
    {
      "tabName": "Location",
      "tabLabel": "Adreça",
      "tabText": "Location",
      "active": false,
      "fields": [
        {
          "label": "Municipi",
          "name": "muni_id",
          "type": "combo",
          "dataType": "string",
          "disabled": false,
          "tab": "location",
          "comboNames": [
            "Sant Boi del Llobregat"
          ],
          "comboIds": [
            "1"
          ],
          "selectedId": "1"
        },
        {
          "label": "Codi postal",
          "name": "postcode",
          "type": "combo",
          "dataType": "string",
          "disabled": false,
          "tab": "location",
          "comboNames": [
            "08830"
          ],
          "comboIds": [
            "08830"
          ],
          "selectedId": "08830"
        },
        {
          "label": "Carrer",
          "name": "streetaxis_id",
          "type": "combo",
          "dataType": "string",
          "disabled": false,
          "tab": "location",
          "comboNames": [
            "Avenida del General Prim",
            "Avenida de la Torre de la Vila"
          ],
          "comboIds": [
            "1-11000C",
            "1-9150C"
          ],
          "selectedId": "1-11000C"
        },
        {
          "label": "Número portal",
          "name": "postnumber",
          "type": "text",
          "dataType": "string",
          "placeholder": "",
          "disabled": false,
          "value": ""
        }
      ]
    },
    {
      "tabName": "Dates",
      "tabLabel": "Execució",
      "tabText": "Dates",
      "active": false,
      "fields": [
        {
          "label": "Iniciar procediment de tall",
          "name": "gw_fct_setmincut_start",
          "type": "button",
          "dataType": "string",
          "placeholder": "",
          "disabled": false,
          "buttonAction": "mincutStartMincut"
        },
        {
          "label": "Data inici",
          "name": "exec_start",
          "type": "datepickertime",
          "dataType": "date",
          "placeholder": "",
          "disabled": true,
          "value": ""
        },
        {
          "label": null,
          "name": "divider",
          "type": "formDivider",
          "dataType": "string",
          "placeholder": null,
          "disabled": false,
          "value": ""
        },
        {
          "label": "Descripció",
          "name": "exec_descript",
          "type": "textarea",
          "dataType": "string",
          "placeholder": "",
          "disabled": true,
          "value": ""
        },
        {
          "label": "Localització real del tall",
          "name": "gw_fct_setcoordinates",
          "type": "button",
          "dataType": "string",
          "placeholder": "",
          "disabled": true,
          "buttonAction": ""
        },
        {
          "label": "Distància",
          "name": "exec_from_plot",
          "type": "text",
          "dataType": "string",
          "placeholder": "",
          "disabled": true,
          "value": ""
        },
        {
          "label": "Profunditat",
          "name": "exec_depth",
          "type": "text",
          "dataType": "string",
          "placeholder": "",
          "disabled": true,
          "value": ""
        },
        {
          "label": "Operari",
          "name": "exec_user",
          "type": "text",
          "dataType": "string",
          "placeholder": "",
          "disabled": true,
          "value": ""
        },
        {
          "label": "Apropiat",
          "name": "exec_appropiate",
          "type": "check",
          "dataType": "string",
          "placeholder": "",
          "disabled": true,
          "value": ""
        },
        {
          "label": null,
          "name": "divider",
          "type": "formDivider",
          "dataType": "string",
          "placeholder": null,
          "disabled": false,
          "value": ""
        },
        {
          "label": "Data Final",
          "name": "exec_end",
          "type": "datepickertime",
          "dataType": "date",
          "placeholder": "",
          "disabled": true,
          "value": ""
        },
        {
          "label": "Finalitzar procediment de tall",
          "name": "gw_fct_setmincut_end",
          "type": "button",
          "dataType": "string",
          "placeholder": "",
          "disabled": true,
          "buttonAction": ""
        }
      ]
    }
  ],
  "geometry": {
    "st_astext": "POINT(419531.322003921 4576491.64426131)"
  },
  "mincut_id": "FALSE",
  "mincutValveLayer": {
    "layer_table_name": "v_anl_mincut_result_valve"
  }
}

⚠️ **GitHub.com Fallback** ⚠️