gw_fct_setcoordinates - Giswater/giswater_dbmodel GitHub Wiki

Description

Update coordinates point for existing mincut

Input example

SELECT gw_fct_setcoordinates($${
"client":{"device":4, "infoType":1, "lang":"ES", "cur_user":"test_user"}, "form":{}, 
"feature":{}, 
"data":{"x":"419528.73597232", "y":"4576490.8982585", "epsg":"25831", "device":3, "zoom_ratio":"0.14912394710811", "id":"78", "form_id":"F41"}}$$);

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": false,
      "fields": [
        {
          "label": "ID tancament",
          "name": "mincut_id",
          "type": "text",
          "dataType": "text",
          "placeholder": "",
          "disabled": true,
          "value": "83"
        },
        {
          "label": "Ordre treball",
          "name": "work_order",
          "type": "text",
          "dataType": "text",
          "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": "1"
        },
        {
          "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": "1"
        },
        {
          "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": "abofill"
        },
        {
          "label": "Descripció",
          "name": "anl_descript",
          "type": "textarea",
          "dataType": "text",
          "placeholder": "",
          "disabled": false,
          "value": ""
        },
        {
          "label": "Dates",
          "name": "divider",
          "type": "formDivider",
          "dataType": "text",
          "placeholder": null,
          "disabled": true,
          "value": ""
        },
        {
          "label": "Rebut",
          "name": "anl_tstamp",
          "type": "datepickertime",
          "dataType": "date",
          "placeholder": "",
          "disabled": false,
          "value": "2022-05-25 11:44:31"
        },
        {
          "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": "text",
          "dataType": "text",
          "placeholder": "",
          "disabled": false,
          "value": "Sant Boi del Llobregat"
        },
        {
          "label": "Codi postal",
          "name": "postcode",
          "type": "text",
          "dataType": "text",
          "placeholder": "",
          "disabled": false,
          "value": "08830"
        },
        {
          "label": "Carrer",
          "name": "streetaxis_id",
          "type": "combo",
          "dataType": "string",
          "disabled": false,
          "tab": "location",
          "comboNames": [
            "Ronda de Sant Ramon",
            "Ronda de Sant Ramon",
            "Calle Legalitat",
            "Calle de Federico Garcia Lorca",
            "Calle de Galicia",
            "Calle de Salvador Espriu",
            "Calle de Francesc Layret",
            "Calle de la Mare de Deu de Montserrat",
            "Calle de Jordi Rubió i Balaguer",
            "Calle d'Eusebi Güell",
            "Calle de Johan Pfaff",
            "Calle Victoria",
            "Calle d'Antoni Gaudí",
            "Calle de Roselló",
            "Calle Benviure",
            "Calle d'Antoni Rubió i LLuch",
            "Passaje Santa Teresa",
            "Avenida Can Carreras",
            "Calle de Lepant",
            "Avenida del General Prim",
            "Calle de Salvador Seguí",
            "Avenida de Aragó",
            "Calle de Josep Trueta",
            "Calle de Narcis Monturiol",
            "Avenida de la Torre de la Vila"
          ],
          "comboIds": [
            "1-10000C",
            "1-10001C",
            "1-10100C",
            "1-10110C",
            "1-10120C",
            "1-10220C",
            "1-10230C",
            "1-10240C",
            "1-10300C",
            "1-10310C",
            "1-10320C",
            "1-10330C",
            "1-10350C",
            "1-10360C",
            "1-10400C",
            "1-10410C",
            "1-10420C",
            "1-10450C",
            "1-10480C",
            "1-11000C",
            "1-11011C",
            "1-9100C",
            "1-9110C",
            "1-9120C",
            "1-9150C"
          ],
          "selectedId": "1-11000C"
        },
        {
          "label": "Número portal",
          "name": "postnumber",
          "type": "text",
          "dataType": "text",
          "placeholder": "",
          "disabled": false,
          "value": ""
        }
      ]
    },
    {
      "tabName": "Dates",
      "tabLabel": "Execució",
      "tabText": "Dates",
      "active": true,
      "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": false,
          "value": "2022-05-25 11:57:22"
        },
        {
          "label": null,
          "name": "divider",
          "type": "formDivider",
          "dataType": "text",
          "placeholder": null,
          "disabled": false,
          "value": ""
        },
        {
          "label": "Descripció",
          "name": "exec_descript",
          "type": "textarea",
          "dataType": "text",
          "placeholder": "",
          "disabled": false,
          "value": ""
        },
        {
          "label": "Localització real del tall",
          "name": "gw_fct_setcoordinates",
          "type": "button",
          "dataType": "text",
          "placeholder": "",
          "disabled": false,
          "buttonAction": ""
        },
        {
          "label": "Distància",
          "name": "exec_from_plot",
          "type": "text",
          "dataType": "text",
          "placeholder": "",
          "disabled": false,
          "value": ""
        },
        {
          "label": "Profunditat",
          "name": "exec_depth",
          "type": "text",
          "dataType": "text",
          "placeholder": "",
          "disabled": false,
          "value": ""
        },
        {
          "label": "Operari",
          "name": "exec_user",
          "type": "text",
          "dataType": "text",
          "placeholder": "",
          "disabled": false,
          "value": "geoadmin"
        },
        {
          "label": "Apropiat",
          "name": "exec_appropiate",
          "type": "check",
          "dataType": "text",
          "placeholder": "",
          "disabled": false,
          "value": "false"
        },
        {
          "label": null,
          "name": "divider",
          "type": "formDivider",
          "dataType": "text",
          "placeholder": null,
          "disabled": false,
          "value": ""
        },
        {
          "label": "Data Final",
          "name": "exec_end",
          "type": "datepickertime",
          "dataType": "date",
          "placeholder": "",
          "disabled": false,
          "value": "2022-05-25 11:45:03"
        },
        {
          "label": "Finalitzar procediment de tall",
          "name": "gw_fct_setmincut_end",
          "type": "button",
          "dataType": "text",
          "placeholder": "",
          "disabled": false,
          "buttonAction": ""
        }
      ]
    }
  ],
  "geometry": {
    "st_astext": "POINT(419527.932489324 4576490.73308974)"
  },
  "mincut_id": "83",
  "mincutValveLayer": {
    "layer_table_name": "v_anl_mincut_result_valve"
  }
}

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