gw_fct_getvisitmanager - Giswater/giswater_dbmodel GitHub Wiki

Description

Get dialog and list of all mincuts on network

Input example

SELECT gw_fct_getvisitmanager($${
"client":{"device":4,"infoType":1,"lang":"es", "cur_user":"test_user"},
"form":{},
"data":{"relatedFeature":{"type":"arc", "idName":"arc_id", "id":"2074"},"fields":{},"pageInfo":null}}$$)

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",
  "message": {},
  "version": {
    "value": "3.4.034"
  },
  "body": {
    "feature": {
      "featureType": "visit",
      "tableName": "v_visit_lot_user",
      "idName": "user_id",
      "id": "geoadmin"
    },
    "form": {
      "formId": "F11",
      "formName": "VISIT MANAGER - GEOADMIN",
      "formTabs": [
        {
          "tabName": "tab_data",
          "tabLabel": "General data",
          "tooltip": "Data",
          "tabFunction": {
            "name": "gwGetVisitManager",
            "parameters": {
              "form": {
                "tabData": {
                  "active": true
                },
                "tabLots": {
                  "active": false
                }
              }
            }
          },
          "tabActions": {},
          "active": false
        },
        {
          "tabName": "tab_lot",
          "tabLabel": "Lots",
          "tooltip": "Lots",
          "tabFunction": {
            "name": "gwGetVisitManager",
            "parameters": {
              "form": {
                "tabData": {
                  "active": false
                },
                "tabLots": {
                  "active": true
                }
              }
            }
          },
          "tabActions": [
            {
              "actionName": "actionDelete",
              "actionFunction": "gwSetDelete",
              "actionTooltip": "Delete file",
              "actionTable": {
                "tableName": "om_visit_lot",
                "idName": "id"
              },
              "disabled": false
            },
            {
              "actionName": "changeAction",
              "actionFunction": "gwGetLot",
              "disabled": false
            }
          ],
          "active": false
        },
        {
          "tabName": "tab_done",
          "tabLabel": "Executed visits",
          "tooltip": "Executed visits",
          "tabFunction": {
            "name": "gwGetVisitManager",
            "parameters": {
              "form": {
                "tabData": {
                  "active": false
                },
                "tabLots": {
                  "active": false
                },
                "tabDone": {
                  "active": true
                }
              }
            }
          },
          "tabActions": [
            {
              "actionName": "actionDelete",
              "actionFunction": "gwSetDelete",
              "actionTooltip": "Delete file",
              "actionTable": {
                "tableName": "om_visit",
                "idName": "id"
              },
              "disabled": false
            },
            {
              "actionName": "changeAction",
              "actionFunction": "gwGetVisit",
              "disabled": false
            }
          ],
          "active": true,
          "fields": [
            {
              "label": "Team",
              "columnname": "team_id",
              "column_id": "team_id",
              "widgetname": "data_team_id",
              "widgettype": "combo",
              "widgetfunction": null,
              "widgetaction": null,
              "updateaction": null,
              "changeaction": null,
              "hidden": false,
              "widgetdim": null,
              "datatype": "text",
              "tooltip": null,
              "placeholder": null,
              "iseditable": false,
              "orderby": 1,
              "layoutname": "lyt_data_1",
              "layoutorder": 1,
              "isparent": false,
              "ismandatory": false,
              "linkedaction": null,
              "isautoupdate": false,
              "stylesheet": null,
              "widgetcontrols": null,
              "comboIds": [
                "2",
                "4",
                "1",
                "3"
              ],
              "comboNames": [
                "Albert Team",
                "Equipo 1",
                "Test team",
                null
              ]
            },
            {
              "label": "Startdate",
              "columnname": "startdate",
              "column_id": "startdate",
              "widgetname": "data_startdate",
              "widgettype": "datetime",
              "widgetfunction": "get_visit_manager",
              "widgetaction": "get_visit_manager",
              "updateaction": "get_visit_manager",
              "changeaction": "get_visit_manager",
              "hidden": false,
              "widgetdim": null,
              "datatype": "date",
              "tooltip": null,
              "placeholder": null,
              "iseditable": true,
              "orderby": 2,
              "layoutname": "lyt_data_1",
              "layoutorder": 2,
              "isparent": false,
              "ismandatory": false,
              "linkedaction": null,
              "isautoupdate": false,
              "stylesheet": null,
              "widgetcontrols": null,
              "value": "2020-01-01"
            },
            {
              "label": "Limit",
              "columnname": "limit",
              "column_id": "limit",
              "widgetname": "data_limit",
              "widgettype": "text",
              "widgetfunction": "get_visit_manager",
              "widgetaction": "get_visit_manager",
              "updateaction": "get_visit_manager",
              "changeaction": "get_visit_manager",
              "hidden": false,
              "widgetdim": null,
              "datatype": "integer",
              "tooltip": null,
              "placeholder": null,
              "iseditable": true,
              "orderby": 3,
              "layoutname": "lyt_data_1",
              "layoutorder": 3,
              "isparent": false,
              "ismandatory": false,
              "linkedaction": null,
              "isautoupdate": false,
              "stylesheet": null,
              "widgetcontrols": null,
              "value": "15"
            },
            {
              "widgettype": "list",
              "datatype": "icon",
              "columnname": "fileList",
              "orderby": 6,
              "position": "body",
              "value": null
            }
          ]
        },
        {
          "tabName": "tab_team",
          "tabLabel": "Vehicle load",
          "tooltip": "Vehicle load",
          "tabFunction": {
            "name": "gwGetVisitManager",
            "parameters": {
              "form": {
                "tabData": {
                  "active": false
                },
                "tabLots": {
                  "active": false
                },
                "tabDone": {
                  "active": false
                },
                "tabTeam": {
                  "active": true
                }
              }
            }
          },
          "tabActions": [
            {
              "actionName": "actionAddFile",
              "actionFunction": "gwSetFileInsert",
              "actionTooltip": "Add Photo",
              "disabled": false
            }
          ],
          "active": false,
          "fields": [
            {
              "label": "Team",
              "columnname": "team_id",
              "column_id": "team_id",
              "widgetname": "data_team_id",
              "widgettype": "combo",
              "widgetfunction": null,
              "widgetaction": null,
              "updateaction": null,
              "changeaction": null,
              "hidden": false,
              "widgetdim": null,
              "datatype": "text",
              "tooltip": null,
              "placeholder": null,
              "iseditable": false,
              "orderby": 1,
              "layoutname": "lyt_data_1",
              "layoutorder": 1,
              "isparent": false,
              "ismandatory": false,
              "linkedaction": null,
              "isautoupdate": false,
              "stylesheet": null,
              "widgetcontrols": null,
              "comboIds": [
                "2",
                "4",
                "1",
                "3"
              ],
              "comboNames": [
                "Albert Team",
                "Equipo 1",
                "Test team",
                null
              ]
            },
            {
              "label": "Startdate",
              "columnname": "startdate",
              "column_id": "startdate",
              "widgetname": "data_startdate",
              "widgettype": "datetime",
              "widgetfunction": "get_visit_manager",
              "widgetaction": "get_visit_manager",
              "updateaction": "get_visit_manager",
              "changeaction": "get_visit_manager",
              "hidden": false,
              "widgetdim": null,
              "datatype": "date",
              "tooltip": null,
              "placeholder": null,
              "iseditable": true,
              "orderby": 2,
              "layoutname": "lyt_data_1",
              "layoutorder": 2,
              "isparent": false,
              "ismandatory": false,
              "linkedaction": null,
              "isautoupdate": false,
              "stylesheet": null,
              "widgetcontrols": null,
              "value": "2020-01-01"
            },
            {
              "label": "Limit",
              "columnname": "limit",
              "column_id": "limit",
              "widgetname": "data_limit",
              "widgettype": "text",
              "widgetfunction": "get_visit_manager",
              "widgetaction": "get_visit_manager",
              "updateaction": "get_visit_manager",
              "changeaction": "get_visit_manager",
              "hidden": false,
              "widgetdim": null,
              "datatype": "integer",
              "tooltip": null,
              "placeholder": null,
              "iseditable": true,
              "orderby": 3,
              "layoutname": "lyt_data_1",
              "layoutorder": 3,
              "isparent": false,
              "ismandatory": false,
              "linkedaction": null,
              "isautoupdate": false,
              "stylesheet": null,
              "widgetcontrols": null,
              "value": "15"
            },
            {
              "widgettype": "list",
              "datatype": "icon",
              "columnname": "fileList",
              "orderby": 6,
              "position": "body",
              "value": null
            }
          ]
        }
      ]
    },
    "data": {
      "layerManager": {}
    }
  }
}

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