gw_fct_plan_check_data - Giswater/giswater_dbmodel GitHub Wiki

---

Description

Get attribute table dialog, filters and values from database relation

Input example

SELECT gw_fct_plan_check_data($${
"client":{"device":4, "infoType":1, "lang":"ES"}, 
"form":{}, "feature":{}, 
"data":{"filterFields":{}, "pageInfo":{}, "parameters":{}}}$$);

Output example

{
  "status": "Accepted",
  "message": {
    "level": 1,
    "text": "Process done successfully"
  },
  "version": "3.4.019",
  "body": {
    "form": {},
    "data": {
      "info": {
        "geometryType": "",
        "values": [
          {
            "id": 3339,
            "message": "DATA QUALITY ANALYSIS ACORDING PLAN-PRICE RULES"
          },
          {
            "id": 3340,
            "message": "-------------------------------------------------------------"
          },
          {
            "id": 3341,
            "message": "CRITICAL ERRORS"
          },
          {
            "id": 3342,
            "message": "----------------------"
          },
          {
            "id": 3343,
            "message": "WARNINGS"
          },
          {
            "id": 3344,
            "message": "--------------"
          },
          {
            "id": 3345,
            "message": "INFO"
          },
          {
            "id": 3346,
            "message": "-------"
          },
          {
            "id": 3347,
            "message": "INFO: There is/are no row(s) without values on cat_arc.active column."
          },
          {
            "id": 3348,
            "message": "INFO: There is/are no row(s) without values on cat_arc.cost column."
          },
          {
            "id": 3349,
            "message": "INFO: There is/are no row(s) without values on cat_arc.m2bottom_cost column."
          },
          {
            "id": 3350,
            "message": "INFO: There is/are no row(s) without values on cat_arc.m3protec_cost column."
          },
          {
            "id": 3351,
            "message": "INFO: There is/are no row(s) without values on cat_node.active column."
          },
          {
            "id": 3352,
            "message": "INFO: There is/are no row(s) row(s) without values on cat_node.cost column."
          },
          {
            "id": 3353,
            "message": "INFO: There is/are no row(s) without values on cat_node.cost_unit column."
          },
          {
            "id": 3354,
            "message": "INFO: There is/are no row(s) without values on cat_node.estimated_depth column."
          },
          {
            "id": 3355,
            "message": "INFO: There is/are no row(s) without values on cat_connec.active column column."
          },
          {
            "id": 3356,
            "message": "INFO: There is/are no row(s) without values on cat_connec.cost_ut column."
          },
          {
            "id": 3357,
            "message": "INFO: There is/are no row(s) without values on cat_connec.cost_ml column."
          },
          {
            "id": 3358,
            "message": "INFO: There is/are no row(s) without values on cat_connec.cost_m3 column."
          },
          {
            "id": 3359,
            "message": "INFO: There is/are no row(s) without values on cat_pavement.thickness column."
          },
          {
            "id": 3360,
            "message": "INFO: There is/are no row(s) without values on cat_pavement.m2_cost column."
          },
          {
            "id": 3361,
            "message": "INFO: There is/are no row(s) without values on cat_soil.y_param column."
          },
          {
            "id": 3362,
            "message": "INFO: There is/are no row(s) without values on cat_soil.b column."
          },
          {
            "id": 3363,
            "message": "INFO: There is/are no row(s) without values on cat_soil.m3exc_cost column."
          },
          {
            "id": 3364,
            "message": "INFO: There is/are no row(s) without values on cat_soil.m3fill_cost column."
          },
          {
            "id": 3365,
            "message": "INFO: There is/are no row(s) without values on cat_soil.m3excess_cost column."
          },
          {
            "id": 3366,
            "message": "INFO: There is/are no row(s) without values on cat_soil.m2trenchl_cost column."
          },
          {
            "id": 3367,
            "message": "INFO: The number of rows of row(s) of the plan_arc_x_pavement table is same than the arc table."
          },
          {
            "id": 3368,
            "message": "INFO: There is/are no row(s) without values on row(s) without values on plan_arc_x_pavement.pavcat_id column."
          }
        ]
      },
      "setVisibleLayers": [],
      "point": {},
      "line": {},
      "polygon": {}
    },
    "returnManager": {
      "style": {
        "point": {
          "style": "unique",
          "values": {
            "width": 3,
            "color": [
              255,
              1,
              1
            ],
            "transparency": 0.5
          }
        },
        "line": {
          "style": "unique",
          "values": {
            "width": 3,
            "color": [
              255,
              1,
              1
            ],
            "transparency": 0.5
          }
        },
        "polygon": {
          "style": "unique",
          "values": {
            "width": 3,
            "color": [
              255,
              1,
              1
            ],
            "transparency": 0.5
          }
        }
      },
      "functionId": 2436
    }
  }
}