{ "layout": { "title": "Four Columns Template", "rows": [ { "id": "a6766a16-28e7-7895-1c6b-2818cf2eed03", "type": "LayoutResourceCode", "typeDesc": "Resource", "parent": "UnIqEiD", "properties": [ { "name": "name", "value": "style", "type": "Id" }, { "name": "resourceType", "value": "Css", "type": "Label" }, { "name": "resourceCode", "value": "select {\n width: 380px;\n } \n ", "type": "Resource" } ] }, { "id": "e12f9bf3-27f1-beb1-0a68-a5b0facd091b", "type": "LayoutRow", "typeDesc": "Row", "parent": "UnIqEiD", "properties": [ { "name": "name", "type": "Id", "value": "Header" }, { "name": "height", "type": "Integer", "value": "60" }, { "name": "backgroundColor", "type": "Color", "value": "" }, { "name": "roundCorners", "type": "RoundCorners", "value": "" }, { "name": "textAlign", "type": "TextAlign", "value": "" }, { "name": "cssClass", "type": "String", "value": "" } ] }, { "id": "5dc54aa4-6a22-269a-d641-ac5fd3a61298", "type": "LayoutColumn", "typeDesc": "Column", "parent": "e12f9bf3-27f1-beb1-0a68-a5b0facd091b", "properties": [ { "name": "name", "type": "Id", "value": "" }, { "name": "columnSpan", "type": "Integer", "value": "24" }, { "name": "columnPrepend", "type": "Integer", "value": "" }, { "name": "columnAppend", "type": "Integer", "value": "" }, { "name": "columnPrependTop", "type": "Boolean", "value": false }, { "name": "columnAppendBottom", "type": "Boolean", "value": false }, { "name": "columnBorder", "type": "Boolean", "value": false }, { "name": "columnBigBorder", "type": "Boolean", "value": false }, { "name": "height", "type": "Integer", "value": "60" }, { "name": "backgroundColor", "type": "Color", "value": "#118cd4" }, { "name": "roundCorners", "type": "RoundCorners", "value": "cdfdd-round" }, { "name": "textAlign", "type": "TextAlign", "value": "center" }, { "name": "cssClass", "type": "String", "value": "" } ] }, { "id": "061b4661-0c13-ebd5-edc9-dd00f7ef88d2", "type": "LayoutSpace", "typeDesc": "Space", "parent": "5dc54aa4-6a22-269a-d641-ac5fd3a61298", "properties": [ { "name": "height", "value": "", "type": "Integer" }, { "name": "backgroundColor", "value": "", "type": "Color" }, { "name": "cssClass", "value": "", "type": "String" } ] }, { "id": "3b246b4a-6ec6-7990-6189-b21d11589d40", "type": "LayoutRow", "typeDesc": "Row", "parent": "5dc54aa4-6a22-269a-d641-ac5fd3a61298", "properties": [ { "name": "name", "value": "", "type": "Id" }, { "name": "height", "value": "", "type": "Integer" }, { "name": "backgroundColor", "value": "", "type": "Color" }, { "name": "roundCorners", "value": "", "type": "RoundCorners" }, { "name": "textAlign", "value": "", "type": "TextAlign" }, { "name": "cssClass", "value": "", "type": "String" } ] }, { "id": "5f75cbba-c8e0-df8d-5f77-ea3924ed47ab", "type": "LayoutHtml", "typeDesc": "Html", "parent": "3b246b4a-6ec6-7990-6189-b21d11589d40", "properties": [ { "name": "name", "value": "Title", "type": "Id" }, { "name": "html", "value": "

Cantidad de Plantas por CIIU y su Ubicación por Estado

", "type": "Html" }, { "name": "fontSize", "value": "", "type": "Integer" }, { "name": "color", "value": "", "type": "Color" }, { "name": "cssClass", "value": "", "type": "String" } ] }, { "id": "c4f04f0e-1ac6-a829-eb8f-a6a2b58df34b", "type": "LayoutSpace", "typeDesc": "Space", "parent": "UnIqEiD", "properties": [ { "name": "height", "value": "", "type": "Integer" }, { "name": "backgroundColor", "value": "", "type": "Color" }, { "name": "cssClass", "value": "", "type": "String" } ] }, { "id": "9b5e4665-60dd-d123-d49a-7cb9072a0540", "type": "LayoutRow", "typeDesc": "Row", "parent": "UnIqEiD", "properties": [ { "name": "name", "type": "Id", "value": "Body" }, { "name": "height", "type": "Integer", "value": "" }, { "name": "backgroundColor", "type": "Color", "value": "" }, { "name": "roundCorners", "type": "RoundCorners", "value": "" }, { "name": "textAlign", "type": "TextAlign", "value": "" }, { "name": "cssClass", "type": "String", "value": "" } ] }, { "id": "80ee452e-ec84-f906-5977-f16e9be4ccd4", "type": "LayoutColumn", "typeDesc": "Column", "parent": "9b5e4665-60dd-d123-d49a-7cb9072a0540", "properties": [ { "name": "name", "type": "Id", "value": "Body_Content" }, { "name": "columnSpan", "type": "Integer", "value": "24" }, { "name": "columnPrepend", "type": "Integer", "value": "" }, { "name": "columnAppend", "type": "Integer", "value": "" }, { "name": "columnPrependTop", "type": "Boolean", "value": "false" }, { "name": "columnAppendBottom", "type": "Boolean", "value": false }, { "name": "columnBorder", "type": "Boolean", "value": false }, { "name": "columnBigBorder", "type": "Boolean", "value": false }, { "name": "height", "type": "Integer", "value": "" }, { "name": "backgroundColor", "type": "Color", "value": "" }, { "name": "roundCorners", "type": "RoundCorners", "value": "" }, { "name": "textAlign", "type": "TextAlign", "value": "" }, { "name": "cssClass", "type": "String", "value": "" } ] }, { "id": "0d0cb2f5-33a2-c84d-590c-fdbbcaeea8a2", "type": "LayoutRow", "typeDesc": "Row", "parent": "80ee452e-ec84-f906-5977-f16e9be4ccd4", "properties": [ { "name": "name", "value": "RowCombo", "type": "Id" }, { "name": "height", "value": "10", "type": "Integer" }, { "name": "backgroundColor", "value": "", "type": "Color" }, { "name": "roundCorners", "value": "", "type": "RoundCorners" }, { "name": "textAlign", "value": "center", "type": "TextAlign" }, { "name": "cssClass", "value": "heading", "type": "String" } ] }, { "id": "c841f82b-f039-83a9-e469-ebcfb36029c5", "type": "LayoutHtml", "typeDesc": "Html", "parent": "0d0cb2f5-33a2-c84d-590c-fdbbcaeea8a2", "properties": [ { "name": "name", "value": "Seleccione", "type": "Id" }, { "name": "html", "value": "Seleccione CIIU ", "type": "Html" }, { "name": "fontSize", "value": "", "type": "Integer" }, { "name": "color", "value": "", "type": "Color" }, { "name": "cssClass", "value": "", "type": "String" } ] }, { "id": "274b436d-cdf8-a8dd-0659-8183d791a873", "type": "LayoutColumn", "typeDesc": "Column", "parent": "0d0cb2f5-33a2-c84d-590c-fdbbcaeea8a2", "properties": [ { "name": "name", "value": "Combo", "type": "Id" }, { "name": "columnSpan", "value": "24", "type": "Integer" }, { "name": "columnPrepend", "value": "", "type": "Integer" }, { "name": "columnAppend", "value": "", "type": "Integer" }, { "name": "columnPrependTop", "value": "false", "type": "Boolean" }, { "name": "columnAppendBottom", "value": "false", "type": "Boolean" }, { "name": "columnBorder", "value": "false", "type": "Boolean" }, { "name": "columnBigBorder", "value": "false", "type": "Boolean" }, { "name": "height", "value": "", "type": "Integer" }, { "name": "backgroundColor", "value": "", "type": "Color" }, { "name": "roundCorners", "value": "cdfdd-round", "type": "RoundCorners" }, { "name": "textAlign", "value": "center", "type": "TextAlign" }, { "name": "cssClass", "value": "", "type": "String" } ] }, { "id": "fc38ea5a-12e4-5e5d-b0e9-a100dc330763", "type": "LayoutSpace", "typeDesc": "Space", "parent": "80ee452e-ec84-f906-5977-f16e9be4ccd4", "properties": [ { "name": "height", "value": "", "type": "Integer" }, { "name": "backgroundColor", "value": "", "type": "Color" }, { "name": "cssClass", "value": "", "type": "String" } ] }, { "id": "1b5b2440-ad57-d50a-f6aa-d96f9b209626", "type": "LayoutRow", "typeDesc": "Row", "parent": "80ee452e-ec84-f906-5977-f16e9be4ccd4", "properties": [ { "name": "name", "type": "Id", "value": "Row_1" }, { "name": "height", "type": "Integer", "value": "220" }, { "name": "backgroundColor", "type": "Color", "value": "" }, { "name": "roundCorners", "type": "RoundCorners", "value": "" }, { "name": "textAlign", "type": "TextAlign", "value": "" }, { "name": "cssClass", "type": "String", "value": "" } ] }, { "id": "233d1ac7-a9d8-3191-d8cf-7cb8864ef548", "type": "LayoutColumn", "typeDesc": "Column", "parent": "1b5b2440-ad57-d50a-f6aa-d96f9b209626", "properties": [ { "name": "name", "type": "Id", "value": "Panel_1" }, { "name": "columnSpan", "type": "Integer", "value": "10" }, { "name": "columnPrepend", "type": "Integer", "value": "1" }, { "name": "columnAppend", "type": "Integer", "value": "1" }, { "name": "columnPrependTop", "type": "Boolean", "value": "true" }, { "name": "columnAppendBottom", "type": "Boolean", "value": "true" }, { "name": "columnBorder", "type": "Boolean", "value": false }, { "name": "columnBigBorder", "type": "Boolean", "value": false }, { "name": "height", "type": "Integer", "value": "550" }, { "name": "backgroundColor", "type": "Color", "value": "#e0e0e0" }, { "name": "roundCorners", "type": "RoundCorners", "value": "cdfdd-round" }, { "name": "textAlign", "type": "TextAlign", "value": "center" }, { "name": "cssClass", "type": "String", "value": "" } ] }, { "id": "fb47d7f2-4767-e8cd-58ea-2c84872351fd", "type": "LayoutSpace", "typeDesc": "Space", "parent": "233d1ac7-a9d8-3191-d8cf-7cb8864ef548", "properties": [ { "name": "height", "value": "", "type": "Integer" }, { "name": "backgroundColor", "value": "", "type": "Color" }, { "name": "cssClass", "value": "", "type": "String" } ] }, { "id": "73a7027e-aac6-4994-dcb3-e6e724175445", "type": "LayoutRow", "typeDesc": "Row", "parent": "233d1ac7-a9d8-3191-d8cf-7cb8864ef548", "properties": [ { "name": "name", "value": "", "type": "Id" }, { "name": "height", "value": "40", "type": "Integer" }, { "name": "backgroundColor", "value": "", "type": "Color" }, { "name": "roundCorners", "value": "", "type": "RoundCorners" }, { "name": "textAlign", "value": "center", "type": "TextAlign" }, { "name": "cssClass", "value": "", "type": "String" } ] }, { "id": "2c033204-33d0-bf2a-bb61-42d6dd0dc794", "type": "LayoutHtml", "typeDesc": "Html", "parent": "73a7027e-aac6-4994-dcb3-e6e724175445", "properties": [ { "name": "name", "value": "", "type": "Id" }, { "name": "html", "value": "

Cantidad de Plantas por CIIU

", "type": "Html" }, { "name": "fontSize", "value": "", "type": "Integer" }, { "name": "color", "value": "", "type": "Color" }, { "name": "cssClass", "value": "", "type": "String" } ] }, { "id": "e9e24ad6-e02a-918e-ffed-0a8a56206ef0", "type": "LayoutRow", "typeDesc": "Row", "parent": "233d1ac7-a9d8-3191-d8cf-7cb8864ef548", "properties": [ { "name": "name", "value": "Boton", "type": "Id" }, { "name": "height", "value": "40", "type": "Integer" }, { "name": "backgroundColor", "value": "", "type": "Color" }, { "name": "roundCorners", "value": "", "type": "RoundCorners" }, { "name": "textAlign", "value": "", "type": "TextAlign" }, { "name": "cssClass", "value": "", "type": "String" } ] }, { "id": "62dfdc96-c61d-2e6c-8ca0-3592aa28b507", "type": "LayoutRow", "typeDesc": "Row", "parent": "233d1ac7-a9d8-3191-d8cf-7cb8864ef548", "properties": [ { "name": "name", "value": "Plantas", "type": "Id" }, { "name": "height", "value": "450", "type": "Integer" }, { "name": "backgroundColor", "value": "", "type": "Color" }, { "name": "roundCorners", "value": "", "type": "RoundCorners" }, { "name": "textAlign", "value": "", "type": "TextAlign" }, { "name": "cssClass", "value": "", "type": "String" } ] }, { "id": "b54ff9f1-06c7-8bb0-dba7-6b6d4b588161", "type": "LayoutColumn", "typeDesc": "Column", "parent": "1b5b2440-ad57-d50a-f6aa-d96f9b209626", "properties": [ { "name": "name", "type": "Id", "value": "Panel_2" }, { "name": "columnSpan", "type": "Integer", "value": "10" }, { "name": "columnPrepend", "type": "Integer", "value": "1" }, { "name": "columnAppend", "type": "Integer", "value": "1" }, { "name": "columnPrependTop", "type": "Boolean", "value": "true" }, { "name": "columnAppendBottom", "type": "Boolean", "value": "true" }, { "name": "columnBorder", "type": "Boolean", "value": "false" }, { "name": "columnBigBorder", "type": "Boolean", "value": "false" }, { "name": "height", "type": "Integer", "value": "550" }, { "name": "backgroundColor", "type": "Color", "value": "#e0e0e0" }, { "name": "roundCorners", "type": "RoundCorners", "value": "cdfdd-round" }, { "name": "textAlign", "type": "TextAlign", "value": "center" }, { "name": "cssClass", "type": "String", "value": "" } ] }, { "id": "91f5231f-b73a-487a-09c8-e7c66ffe9a7f", "type": "LayoutSpace", "typeDesc": "Space", "parent": "b54ff9f1-06c7-8bb0-dba7-6b6d4b588161", "properties": [ { "name": "height", "value": "5", "type": "Integer" }, { "name": "backgroundColor", "value": "", "type": "Color" }, { "name": "cssClass", "value": "", "type": "String" } ] }, { "id": "5dc150c2-0c20-94d3-cbbc-d7c2fba709ec", "type": "LayoutRow", "typeDesc": "Row", "parent": "b54ff9f1-06c7-8bb0-dba7-6b6d4b588161", "properties": [ { "name": "name", "value": "Descrip2", "type": "Id" }, { "name": "height", "value": "", "type": "Integer" }, { "name": "backgroundColor", "value": "", "type": "Color" }, { "name": "roundCorners", "value": "", "type": "RoundCorners" }, { "name": "textAlign", "value": "center", "type": "TextAlign" }, { "name": "cssClass", "value": "", "type": "String" } ] }, { "id": "f3202c93-c8cf-0792-5ec9-95238a51c4fd", "type": "LayoutSpace", "typeDesc": "Space", "parent": "b54ff9f1-06c7-8bb0-dba7-6b6d4b588161", "properties": [ { "name": "height", "value": "5", "type": "Integer" }, { "name": "backgroundColor", "value": "", "type": "Color" }, { "name": "cssClass", "value": "", "type": "String" } ] }, { "id": "21b1f96a-8ff3-a3c8-351a-ac62a2dfd480", "type": "LayoutRow", "typeDesc": "Row", "parent": "b54ff9f1-06c7-8bb0-dba7-6b6d4b588161", "properties": [ { "name": "name", "value": "BotonG", "type": "Id" }, { "name": "height", "value": "40", "type": "Integer" }, { "name": "backgroundColor", "value": "", "type": "Color" }, { "name": "roundCorners", "value": "", "type": "RoundCorners" }, { "name": "textAlign", "value": "", "type": "TextAlign" }, { "name": "cssClass", "value": "", "type": "String" } ] }, { "id": "b6fe01a2-7808-086c-db55-0892e8a2eab6", "type": "LayoutRow", "typeDesc": "Row", "parent": "b54ff9f1-06c7-8bb0-dba7-6b6d4b588161", "properties": [ { "name": "name", "value": "ChartEstado", "type": "Id" }, { "name": "height", "value": "450", "type": "Integer" }, { "name": "backgroundColor", "value": "", "type": "Color" }, { "name": "roundCorners", "value": "", "type": "RoundCorners" }, { "name": "textAlign", "value": "", "type": "TextAlign" }, { "name": "cssClass", "value": "", "type": "String" } ] }, { "id": "70138d47-25b4-0361-74fc-342219f9426f", "type": "LayoutSpace", "typeDesc": "Space", "parent": "80ee452e-ec84-f906-5977-f16e9be4ccd4", "properties": [ { "name": "height", "value": "", "type": "Integer" }, { "name": "backgroundColor", "value": "", "type": "Color" }, { "name": "cssClass", "value": "", "type": "String" } ] }, { "id": "c8448d39-08ac-51bb-8401-92a8be58b30f", "type": "LayoutRow", "typeDesc": "Row", "parent": "80ee452e-ec84-f906-5977-f16e9be4ccd4", "properties": [ { "name": "name", "type": "Id", "value": "Row_2" }, { "name": "height", "type": "Integer", "value": "220" }, { "name": "backgroundColor", "type": "Color", "value": "" }, { "name": "roundCorners", "type": "RoundCorners", "value": "" }, { "name": "textAlign", "type": "TextAlign", "value": "" }, { "name": "cssClass", "type": "String", "value": "" } ] }, { "id": "73c192d2-26d4-dec3-6696-4d328657fc94", "type": "LayoutColumn", "typeDesc": "Column", "parent": "c8448d39-08ac-51bb-8401-92a8be58b30f", "properties": [ { "name": "name", "type": "Id", "value": "Panel_3" }, { "name": "columnSpan", "type": "Integer", "value": "22" }, { "name": "columnPrepend", "type": "Integer", "value": "1" }, { "name": "columnAppend", "type": "Integer", "value": "1" }, { "name": "columnPrependTop", "type": "Boolean", "value": "true" }, { "name": "columnAppendBottom", "type": "Boolean", "value": "true" }, { "name": "columnBorder", "type": "Boolean", "value": "false" }, { "name": "columnBigBorder", "type": "Boolean", "value": "false" }, { "name": "height", "type": "Integer", "value": "350" }, { "name": "backgroundColor", "type": "Color", "value": "#e0e0e0" }, { "name": "roundCorners", "type": "RoundCorners", "value": "cdfdd-round" }, { "name": "textAlign", "type": "TextAlign", "value": "center" }, { "name": "cssClass", "type": "String", "value": "" } ] }, { "id": "be2ff09a-a2ef-39e6-b839-afd3a1c91c95", "type": "LayoutSpace", "typeDesc": "Space", "parent": "73c192d2-26d4-dec3-6696-4d328657fc94", "properties": [ { "name": "height", "value": "5", "type": "Integer" }, { "name": "backgroundColor", "value": "", "type": "Color" }, { "name": "cssClass", "value": "", "type": "String" } ] }, { "id": "0fdbed62-1d2d-3c7c-fde7-f5ca551d9d16", "type": "LayoutRow", "typeDesc": "Row", "parent": "73c192d2-26d4-dec3-6696-4d328657fc94", "properties": [ { "name": "name", "value": "", "type": "Id" }, { "name": "height", "value": "40", "type": "Integer" }, { "name": "backgroundColor", "value": "", "type": "Color" }, { "name": "roundCorners", "value": "", "type": "RoundCorners" }, { "name": "textAlign", "value": "center", "type": "TextAlign" }, { "name": "cssClass", "value": "", "type": "String" } ] }, { "id": "a972fcd6-66f8-9cf0-cd84-69dbc0733446", "type": "LayoutHtml", "typeDesc": "Html", "parent": "0fdbed62-1d2d-3c7c-fde7-f5ca551d9d16", "properties": [ { "name": "name", "value": "", "type": "Id" }, { "name": "html", "value": "

Principales Empresas

", "type": "Html" }, { "name": "fontSize", "value": "", "type": "Integer" }, { "name": "color", "value": "", "type": "Color" }, { "name": "cssClass", "value": "", "type": "String" } ] }, { "id": "036294e4-630c-4826-62cb-48aac5ab835d", "type": "LayoutRow", "typeDesc": "Row", "parent": "73c192d2-26d4-dec3-6696-4d328657fc94", "properties": [ { "name": "name", "value": "NombreCIIU", "type": "Id" }, { "name": "height", "value": "", "type": "Integer" }, { "name": "backgroundColor", "value": "", "type": "Color" }, { "name": "roundCorners", "value": "", "type": "RoundCorners" }, { "name": "textAlign", "value": "center", "type": "TextAlign" }, { "name": "cssClass", "value": "", "type": "String" } ] }, { "id": "b6fc29f0-065c-7ba3-e163-79b40e3bd79f", "type": "LayoutSpace", "typeDesc": "Space", "parent": "73c192d2-26d4-dec3-6696-4d328657fc94", "properties": [ { "name": "height", "value": "5", "type": "Integer" }, { "name": "backgroundColor", "value": "", "type": "Color" }, { "name": "cssClass", "value": "", "type": "String" } ] }, { "id": "6de08e51-0254-1ffc-628b-c49d7dfc088d", "type": "LayoutRow", "typeDesc": "Row", "parent": "73c192d2-26d4-dec3-6696-4d328657fc94", "properties": [ { "name": "name", "value": "ExportarE", "type": "Id" }, { "name": "height", "value": "", "type": "Integer" }, { "name": "backgroundColor", "value": "", "type": "Color" }, { "name": "roundCorners", "value": "", "type": "RoundCorners" }, { "name": "textAlign", "value": "center", "type": "TextAlign" }, { "name": "cssClass", "value": "", "type": "String" } ] }, { "id": "d4c3b269-e559-f5a0-74ab-d02728553f1c", "type": "LayoutSpace", "typeDesc": "Space", "parent": "73c192d2-26d4-dec3-6696-4d328657fc94", "properties": [ { "name": "height", "value": "", "type": "Integer" }, { "name": "backgroundColor", "value": "", "type": "Color" }, { "name": "cssClass", "value": "", "type": "String" } ] }, { "id": "fdd01f09-f96e-acbb-bc2e-5485dddd8fa1", "type": "LayoutRow", "typeDesc": "Row", "parent": "73c192d2-26d4-dec3-6696-4d328657fc94", "properties": [ { "name": "name", "value": "Principales", "type": "Id" }, { "name": "height", "value": "220", "type": "Integer" }, { "name": "backgroundColor", "value": "", "type": "Color" }, { "name": "roundCorners", "value": "", "type": "RoundCorners" }, { "name": "textAlign", "value": "center", "type": "TextAlign" }, { "name": "cssClass", "value": "", "type": "String" } ] }, { "id": "4d63ae8a-4b6c-1f5d-8cbc-dc4c41997144", "type": "LayoutSpace", "typeDesc": "Space", "parent": "UnIqEiD", "properties": [ { "name": "height", "value": "", "type": "Integer" }, { "name": "backgroundColor", "value": "", "type": "Color" }, { "name": "cssClass", "value": "", "type": "String" } ] }, { "id": "6e7d955c-f662-f8f5-f665-441438972fab", "type": "LayoutRow", "typeDesc": "Row", "parent": "UnIqEiD", "properties": [ { "name": "name", "value": "Imprimir", "type": "Id" }, { "name": "height", "value": "", "type": "Integer" }, { "name": "backgroundColor", "value": "", "type": "Color" }, { "name": "roundCorners", "value": "", "type": "RoundCorners" }, { "name": "textAlign", "value": "center", "type": "TextAlign" }, { "name": "cssClass", "value": "", "type": "String" } ] }, { "id": "e7911e36-fa94-5859-b1af-e6307cd2e926", "type": "LayoutSpace", "typeDesc": "Space", "parent": "UnIqEiD", "properties": [ { "name": "height", "value": "", "type": "Integer" }, { "name": "backgroundColor", "value": "", "type": "Color" }, { "name": "cssClass", "value": "", "type": "String" } ] }, { "id": "64b07960-f21e-b93e-4911-8c2c025d0d3b", "type": "LayoutRow", "typeDesc": "Row", "parent": "UnIqEiD", "properties": [ { "name": "name", "type": "Id", "value": "Footer" }, { "name": "height", "type": "Integer", "value": "50" }, { "name": "backgroundColor", "type": "Color", "value": "#e0e0e0" }, { "name": "roundCorners", "type": "RoundCorners", "value": "cdfdd-round" }, { "name": "textAlign", "type": "TextAlign", "value": "right" }, { "name": "cssClass", "type": "String", "value": "" } ] }, { "id": "e03427a4-44c1-d56c-e8e5-ec4b6b48a612", "type": "LayoutColumn", "typeDesc": "Column", "parent": "64b07960-f21e-b93e-4911-8c2c025d0d3b", "properties": [ { "name": "name", "type": "Id", "value": "Footer_Text" }, { "name": "columnSpan", "type": "Integer", "value": "20" }, { "name": "columnPrepend", "type": "Integer", "value": "" }, { "name": "columnAppend", "type": "Integer", "value": "" }, { "name": "columnPrependTop", "type": "Boolean", "value": "false" }, { "name": "columnAppendBottom", "type": "Boolean", "value": "false" }, { "name": "columnBorder", "type": "Boolean", "value": false }, { "name": "columnBigBorder", "type": "Boolean", "value": false }, { "name": "height", "type": "Integer", "value": "40" }, { "name": "backgroundColor", "type": "Color", "value": "" }, { "name": "roundCorners", "type": "RoundCorners", "value": "" }, { "name": "textAlign", "type": "TextAlign", "value": "right" }, { "name": "cssClass", "type": "String", "value": "" } ] }, { "id": "b45069a3-a949-0502-b04e-c736d142c232", "type": "LayoutHtml", "typeDesc": "Html", "parent": "e03427a4-44c1-d56c-e8e5-ec4b6b48a612", "properties": [ { "name": "name", "type": "Id", "value": "Text" }, { "name": "html", "type": "Html", "value": "

" }, { "name": "fontSize", "value": "", "type": "Integer" }, { "name": "color", "value": "", "type": "Color" }, { "name": "cssClass", "value": "", "type": "String" } ] }, { "id": "e5c22f13-2f56-9638-5a05-b675a84fc695", "type": "LayoutColumn", "typeDesc": "Column", "parent": "64b07960-f21e-b93e-4911-8c2c025d0d3b", "properties": [ { "name": "name", "type": "Id", "value": "Footer_Image" }, { "name": "columnSpan", "type": "Integer", "value": "4" }, { "name": "columnPrepend", "type": "Integer", "value": "" }, { "name": "columnAppend", "type": "Integer", "value": "0" }, { "name": "columnPrependTop", "type": "Boolean", "value": false }, { "name": "columnAppendBottom", "type": "Boolean", "value": false }, { "name": "columnBorder", "type": "Boolean", "value": false }, { "name": "columnBigBorder", "type": "Boolean", "value": false }, { "name": "height", "type": "Integer", "value": "" }, { "name": "backgroundColor", "type": "Color", "value": "" }, { "name": "roundCorners", "type": "RoundCorners", "value": "" }, { "name": "textAlign", "type": "TextAlign", "value": "left" }, { "name": "cssClass", "type": "String", "value": "" } ] }, { "id": "68d6b48f-a44c-99af-7261-38b98e99259e", "type": "LayoutHtml", "typeDesc": "Html", "parent": "e5c22f13-2f56-9638-5a05-b675a84fc695", "properties": [ { "name": "name", "type": "Id", "value": "Image" }, { "name": "html", "type": "Html", "value": "\n " }, { "name": "fontSize", "value": "", "type": "Integer" }, { "name": "color", "value": "", "type": "Color" }, { "name": "cssClass", "value": "", "type": "String" } ] } ] }, "components": { "rows": [ { "id": "SELECTORS", "name": "Selects", "type": "Label", "typeDesc": "Group", "parent": "UnIqEiD", "properties": [ { "name": "Group", "value": "Selects", "type": "Label" } ] }, { "id": "8ad542e6-d456-b942-f3d5-912341b8486f", "type": "ComponentsSelect", "typeDesc": "Select Component", "parent": "SELECTORS", "properties": [ { "name": "name", "value": "Selector", "type": "Id" }, { "name": "parameter", "value": "${p:CIIU}", "type": "Parameter" }, { "name": "listeners", "value": "[]", "type": "Listeners" }, { "name": "parameters", "value": "[]", "type": "ValuesArray" }, { "name": "valueAsId", "value": "false", "type": "Boolean" }, { "name": "externalPlugin", "value": "", "type": "String" }, { "name": "dataSource", "value": "ciiu2digitos", "type": "Datasource" }, { "name": "valuesArray", "value": "[]", "type": "ValuesArray" }, { "name": "priority", "value": 5, "type": "Integer" }, { "name": "refreshPeriod", "value": "", "type": "Integer" }, { "name": "htmlObject", "value": "${p:Combo}", "type": "HtmlObject" }, { "name": "executeAtStart", "value": "true", "type": "Boolean" }, { "name": "preExecution", "value": "", "type": "JavaScript" }, { "name": "postExecution", "value": "", "type": "JavaScript" }, { "name": "postFetch", "value": "", "type": "JavaScript" }, { "name": "preChange", "value": "", "type": "JavaScript" }, { "name": "postChange", "value": "function Producto() {\n //alert(\"msg\"+a.series);\n Dashboards.fireChange('CIIU2','0');\n}", "type": "JavaScript" }, { "name": "tooltip", "value": "", "type": "Html" }, { "name": "extraOptions", "value": "[]", "type": "OptionArray" } ] }, { "id": "bc29c078-3edf-0b08-d6f6-97100fc8ea77", "type": "ComponentsSelect", "typeDesc": "Select Component", "parent": "SELECTORS", "properties": [ { "name": "name", "value": "Selector2", "type": "Id" }, { "name": "parameter", "value": "${p:CIIU2}", "type": "Parameter" }, { "name": "listeners", "value": "['${p:CIIU}']", "type": "Listeners" }, { "name": "parameters", "value": "[[\"CIIU\",\"CIIU\"]]", "type": "ValuesArray" }, { "name": "valueAsId", "value": "false", "type": "Boolean" }, { "name": "externalPlugin", "value": "", "type": "String" }, { "name": "dataSource", "value": "ciiu4digitos", "type": "Datasource" }, { "name": "valuesArray", "value": "[]", "type": "ValuesArray" }, { "name": "priority", "value": 5, "type": "Integer" }, { "name": "refreshPeriod", "value": "", "type": "Integer" }, { "name": "htmlObject", "value": "", "type": "HtmlObject" }, { "name": "executeAtStart", "value": "true", "type": "Boolean" }, { "name": "preExecution", "value": "", "type": "JavaScript" }, { "name": "postExecution", "value": "", "type": "JavaScript" }, { "name": "postFetch", "value": "", "type": "JavaScript" }, { "name": "preChange", "value": "", "type": "JavaScript" }, { "name": "postChange", "value": "", "type": "JavaScript" }, { "name": "tooltip", "value": "", "type": "Html" }, { "name": "extraOptions", "value": "[]", "type": "OptionArray" } ] }, { "id": "OTHERCOMPONENTS", "name": "Others", "type": "Label", "typeDesc": "Group", "parent": "UnIqEiD", "properties": [ { "name": "Group", "value": "Others", "type": "Label" } ] }, { "id": "313cdb73-9503-8b69-53f5-3ea4c0cb75da", "type": "ComponentsTable", "typeDesc": "table Component", "parent": "OTHERCOMPONENTS", "properties": [ { "name": "name", "value": "CIIUTable", "type": "Id" }, { "name": "expandContainerObject", "value": "", "type": "String" }, { "name": "listeners", "value": "['${p:CIIU}']", "type": "Listeners" }, { "name": "oLanguage", "value": "{\n \"sProcessing\": \"Procesando...\",\n \"sLengthMenu\": \"Mostrar _MENU_ registros\",\n \"sZeroRecords\": \"No se encontraron resultados\",\n \"sEmptyTable\": \"Ningún dato disponible en esta tabla\",\n \"sInfo\": \"Mostrando registros del _START_ al _END_ de un total de _TOTAL_ registros\",\n \"sInfoEmpty\": \"Mostrando registros del 0 al 0 de un total de 0 registros\",\n \"sInfoFiltered\": \"(filtrado de un total de _MAX_ registros)\",\n \"sInfoPostFix\": \"\",\n \"sSearch\": \"Buscar:\",\n \"sUrl\": \"\",\n \"sInfoThousands\": \",\",\n \"sLoadingRecords\": \"Cargando...\",\n \"oPaginate\": {\n \"sFirst\": \"Primero\",\n \"sLast\": \"Último\",\n \"sNext\": \"Siguiente\",\n \"sPrevious\": \"Anterior\"\n },\n \"oAria\": {\n \"sSortAscending\": \": Activar para ordenar la columna de manera ascendente\",\n \"sSortDescending\": \": Activar para ordenar la columna de manera descendente\"\n }\n}", "type": "JavaScript" }, { "name": "colHeaders", "value": "[\"CIIU\",\"Descripción\",\"Total Plantas\"]", "type": "Array" }, { "name": "colTypes", "value": "[]", "type": "colTypesCustom" }, { "name": "colFormats", "value": "[]", "type": "Array" }, { "name": "colWidths", "value": "[\"20%\",\"60%\",\"20%\"]", "type": "Array" }, { "name": "colSortable", "value": "[]", "type": "Array" }, { "name": "parameters", "value": "[[\"CIIU\",\"CIIU\"]]", "type": "ValuesArray" }, { "name": "expandParameters", "value": "[]", "type": "ValuesArray" }, { "name": "paginate", "value": "true", "type": "Boolean" }, { "name": "displayLength", "value": "5", "type": "Integer" }, { "name": "lengthChange", "value": "false", "type": "Boolean" }, { "name": "filter", "value": "true", "type": "Boolean" }, { "name": "info", "value": "true", "type": "Boolean" }, { "name": "sort", "value": "true", "type": "Boolean" }, { "name": "expandOnClick", "value": "false", "type": "Boolean" }, { "name": "colSearchable", "value": "[]", "type": "Array" }, { "name": "drawCallback", "value": "", "type": "JavaScript" }, { "name": "dataSource", "value": "CIIUTable4", "type": "Datasource" }, { "name": "sortBy", "value": "[]", "type": "SortByArray" }, { "name": "sDom", "value": "", "type": "JavaScript" }, { "name": "refreshPeriod", "value": "", "type": "Integer" }, { "name": "priority", "value": 5, "type": "Integer" }, { "name": "tableStyle", "value": "themeroller", "type": "TableStyle" }, { "name": "paginationType", "value": "two_button", "type": "PaginationType" }, { "name": "htmlObject", "value": "${p:Plantas}", "type": "HtmlObject" }, { "name": "executeAtStart", "value": "true", "type": "Boolean" }, { "name": "paginateServerside", "value": "false", "type": "Boolean" }, { "name": "preExecution", "value": "", "type": "JavaScript" }, { "name": "postFetch", "value": "", "type": "JavaScript" }, { "name": "postExecution", "value": "", "type": "JavaScript" }, { "name": "preChange", "value": "", "type": "JavaScript" }, { "name": "postChange", "value": "", "type": "JavaScript" }, { "name": "tooltip", "value": "", "type": "Html" }, { "name": "extraOptions", "value": "[]", "type": "OptionArray" }, { "name": "clickAction", "value": "function Producto(a) {\n //alert(\"msg\"+a.series);\n Dashboards.fireChange('CIIU2',a.series);\n}", "type": "JavaScript" } ] }, { "id": "2f0224fa-65d8-7306-8ce8-6dd59e2e79ec", "type": "ComponentsTable", "typeDesc": "table Component", "parent": "OTHERCOMPONENTS", "properties": [ { "name": "name", "value": "Principales", "type": "Id" }, { "name": "expandContainerObject", "value": "", "type": "String" }, { "name": "listeners", "value": "['${p:CIIU2}']", "type": "Listeners" }, { "name": "oLanguage", "value": "{\n \"sProcessing\": \"Procesando...\",\n \"sLengthMenu\": \"Mostrar _MENU_ registros\",\n \"sZeroRecords\": \"No se encontraron resultados\",\n \"sEmptyTable\": \"Ningún dato disponible en esta tabla\",\n \"sInfo\": \"Mostrando registros del _START_ al _END_ de un total de _TOTAL_ registros\",\n \"sInfoEmpty\": \"Mostrando registros del 0 al 0 de un total de 0 registros\",\n \"sInfoFiltered\": \"(filtrado de un total de _MAX_ registros)\",\n \"sInfoPostFix\": \"\",\n \"sSearch\": \"Buscar:\",\n \"sUrl\": \"\",\n \"sInfoThousands\": \",\",\n \"sLoadingRecords\": \"Cargando...\",\n \"oPaginate\": {\n \"sFirst\": \"Primero\",\n \"sLast\": \"Último\",\n \"sNext\": \"Siguiente\",\n \"sPrevious\": \"Anterior\"\n },\n \"oAria\": {\n \"sSortAscending\": \": Activar para ordenar la columna de manera ascendente\",\n \"sSortDescending\": \": Activar para ordenar la columna de manera descendente\"\n }\n}", "type": "JavaScript" }, { "name": "parameters", "value": "[[\"CIIU2\",\"CIIU2\"]]", "type": "ValuesArray" }, { "name": "expandParameters", "value": "[]", "type": "ValuesArray" }, { "name": "colHeaders", "value": "[\"Empresa\",\"RIF\",\"Total Bs\",\"% de Ventas\"]", "type": "Array" }, { "name": "colTypes", "value": "[]", "type": "colTypesCustom" }, { "name": "colFormats", "value": "[]", "type": "Array" }, { "name": "colWidths", "value": "[]", "type": "Array" }, { "name": "colSortable", "value": "[]", "type": "Array" }, { "name": "sort", "value": "false", "type": "Boolean" }, { "name": "expandOnClick", "value": "false", "type": "Boolean" }, { "name": "paginate", "value": "false", "type": "Boolean" }, { "name": "displayLength", "value": "5", "type": "Integer" }, { "name": "lengthChange", "value": "false", "type": "Boolean" }, { "name": "filter", "value": "false", "type": "Boolean" }, { "name": "info", "value": "false", "type": "Boolean" }, { "name": "colSearchable", "value": "[]", "type": "Array" }, { "name": "drawCallback", "value": "", "type": "JavaScript" }, { "name": "dataSource", "value": "PrincipalesEmpresas", "type": "Datasource" }, { "name": "sDom", "value": "", "type": "JavaScript" }, { "name": "sortBy", "value": "[]", "type": "SortByArray" }, { "name": "refreshPeriod", "value": "", "type": "Integer" }, { "name": "priority", "value": 5, "type": "Integer" }, { "name": "tableStyle", "value": "themeroller", "type": "TableStyle" }, { "name": "paginationType", "value": "two_button", "type": "PaginationType" }, { "name": "htmlObject", "value": "${p:Principales}", "type": "HtmlObject" }, { "name": "executeAtStart", "value": "true", "type": "Boolean" }, { "name": "paginateServerside", "value": "false", "type": "Boolean" }, { "name": "preExecution", "value": "", "type": "JavaScript" }, { "name": "postFetch", "value": "", "type": "JavaScript" }, { "name": "postExecution", "value": "", "type": "JavaScript" }, { "name": "preChange", "value": "", "type": "JavaScript" }, { "name": "postChange", "value": "", "type": "JavaScript" }, { "name": "tooltip", "value": "", "type": "Html" }, { "name": "extraOptions", "value": "[]", "type": "OptionArray" }, { "name": "clickAction", "value": "", "type": "JavaScript" } ] }, { "id": "f562b2c1-fae0-5957-4e7a-a6da920b29b8", "type": "ComponentstextComponent", "typeDesc": "Text Component", "parent": "OTHERCOMPONENTS", "properties": [ { "name": "name", "value": "textCIIU", "type": "Id" }, { "name": "listeners", "value": "['${p:CIIU2}']", "type": "Listeners" }, { "name": "expression", "value": "function() {\n return \"Principales Empresas de la actividad CIIU: \" + Dashboards.getParameterValue(\"Descrip\");\n}", "type": "JavaScript" }, { "name": "priority", "value": 5, "type": "Integer" }, { "name": "refreshPeriod", "value": "", "type": "Integer" }, { "name": "htmlObject", "value": "${p:NombreCIIU}", "type": "HtmlObject" }, { "name": "executeAtStart", "value": "true", "type": "Boolean" }, { "name": "preExecution", "value": "", "type": "JavaScript" }, { "name": "postExecution", "value": "", "type": "JavaScript" }, { "name": "tooltip", "value": "", "type": "Html" } ] }, { "id": "29c5082f-404f-44ee-7532-f579e0aea0ff", "type": "ComponentstextComponent", "typeDesc": "Text Component", "parent": "OTHERCOMPONENTS", "properties": [ { "name": "name", "value": "textCIIU2", "type": "Id" }, { "name": "listeners", "value": "['${p:CIIU2}']", "type": "Listeners" }, { "name": "expression", "value": "function() {\n return \"CIIU: \" + Dashboards.getParameterValue(\"Descrip\");\n}", "type": "JavaScript" }, { "name": "priority", "value": 5, "type": "Integer" }, { "name": "refreshPeriod", "value": "", "type": "Integer" }, { "name": "htmlObject", "value": "${p:Descrip2}", "type": "HtmlObject" }, { "name": "executeAtStart", "value": "true", "type": "Boolean" }, { "name": "preExecution", "value": "", "type": "JavaScript" }, { "name": "postExecution", "value": "", "type": "JavaScript" }, { "name": "tooltip", "value": "", "type": "Html" } ] }, { "id": "af09cfed-1e79-a25f-7958-8b545f73d8ea", "type": "ComponentsQuery", "typeDesc": "Query Component", "parent": "OTHERCOMPONENTS", "properties": [ { "name": "name", "value": "DescripCIIU", "type": "Id" }, { "name": "listeners", "value": "['${p:CIIU2}']", "type": "Listeners" }, { "name": "parameters", "value": "[[\"CIIU2\",\"CIIU2\"]]", "type": "ValuesArray" }, { "name": "resultvar", "value": "${p:Descrip}", "type": "Result" }, { "name": "dataSource", "value": "DescripcionCIIU", "type": "Datasource" }, { "name": "refreshPeriod", "value": "", "type": "Integer" }, { "name": "priority", "value": "1", "type": "Integer" }, { "name": "htmlObject", "value": "", "type": "HtmlObject" }, { "name": "executeAtStart", "value": "true", "type": "Boolean" }, { "name": "preExecution", "value": "", "type": "JavaScript" }, { "name": "postExecution", "value": "", "type": "JavaScript" }, { "name": "postFetch", "value": "", "type": "JavaScript" }, { "name": "preChange", "value": "", "type": "JavaScript" }, { "name": "postChange", "value": "", "type": "JavaScript" }, { "name": "tooltip", "value": "", "type": "Html" } ] }, { "id": "8aa9ad14-c73f-b5b1-d07b-7c6c96263af6", "type": "ComponentsexportButton", "typeDesc": "Export Button Component", "parent": "OTHERCOMPONENTS", "properties": [ { "name": "name", "value": "ExportTable", "type": "Id" }, { "name": "label", "value": "Exportar", "type": "String" }, { "name": "listeners", "value": "[]", "type": "Listeners" }, { "name": "parameters", "value": "[]", "type": "ValuesArray" }, { "name": "priority", "value": 5, "type": "Integer" }, { "name": "refreshPeriod", "value": "", "type": "Integer" }, { "name": "componentName", "value": "CIIUTable", "type": "String" }, { "name": "outputType", "value": "csv", "type": "String" }, { "name": "htmlObject", "value": "Boton", "type": "HtmlObject" }, { "name": "executeAtStart", "value": "true", "type": "Boolean" }, { "name": "preExecution", "value": "", "type": "JavaScript" }, { "name": "postExecution", "value": "", "type": "JavaScript" }, { "name": "tooltip", "value": "", "type": "Html" } ] }, { "id": "babafd27-d79f-8e8c-bd07-268fb59bb6e1", "type": "ComponentsexportButton", "typeDesc": "Export Button Component", "parent": "OTHERCOMPONENTS", "properties": [ { "name": "name", "value": "ExportGraf", "type": "Id" }, { "name": "label", "value": "Exportar", "type": "String" }, { "name": "listeners", "value": "[]", "type": "Listeners" }, { "name": "parameters", "value": "[]", "type": "ValuesArray" }, { "name": "priority", "value": 5, "type": "Integer" }, { "name": "refreshPeriod", "value": "", "type": "Integer" }, { "name": "componentName", "value": "Barchart", "type": "String" }, { "name": "outputType", "value": "csv", "type": "String" }, { "name": "htmlObject", "value": "${p:BotonG}", "type": "HtmlObject" }, { "name": "executeAtStart", "value": "true", "type": "Boolean" }, { "name": "preExecution", "value": "", "type": "JavaScript" }, { "name": "postExecution", "value": "", "type": "JavaScript" }, { "name": "tooltip", "value": "", "type": "Html" } ] }, { "id": "d2b18a6c-b69b-100b-6c1c-baca3526766b", "type": "ComponentsexportButton", "typeDesc": "Export Button Component", "parent": "OTHERCOMPONENTS", "properties": [ { "name": "name", "value": "ExportE", "type": "Id" }, { "name": "label", "value": "Exportar", "type": "String" }, { "name": "listeners", "value": "[]", "type": "Listeners" }, { "name": "parameters", "value": "[]", "type": "ValuesArray" }, { "name": "priority", "value": 5, "type": "Integer" }, { "name": "refreshPeriod", "value": "", "type": "Integer" }, { "name": "componentName", "value": "Principales", "type": "String" }, { "name": "outputType", "value": "csv", "type": "String" }, { "name": "htmlObject", "value": "${p:ExportarE}", "type": "HtmlObject" }, { "name": "executeAtStart", "value": "true", "type": "Boolean" }, { "name": "preExecution", "value": "", "type": "JavaScript" }, { "name": "postExecution", "value": "", "type": "JavaScript" }, { "name": "tooltip", "value": "", "type": "Html" } ] }, { "id": "fe03d873-ab1b-c735-fd30-8133512df1b9", "type": "ComponentsbuttonComponent", "typeDesc": "Button Component", "parent": "OTHERCOMPONENTS", "properties": [ { "name": "name", "value": "PDF", "type": "Id" }, { "name": "label", "value": "Exportar PDF", "type": "String" }, { "name": "listeners", "value": "[]", "type": "Listeners" }, { "name": "expression", "value": "function f() { window.print() }", "type": "JavaScript" }, { "name": "priority", "value": 5, "type": "Integer" }, { "name": "refreshPeriod", "value": "", "type": "Integer" }, { "name": "buttonStyle", "value": "themeroller", "type": "TableStyle" }, { "name": "htmlObject", "value": "${p:Imprimir}", "type": "HtmlObject" }, { "name": "executeAtStart", "value": "true", "type": "Boolean" }, { "name": "preExecution", "value": "", "type": "JavaScript" }, { "name": "postExecution", "value": "", "type": "JavaScript" }, { "name": "preChange", "value": "", "type": "JavaScript" }, { "name": "postChange", "value": "", "type": "JavaScript" }, { "name": "tooltip", "value": "", "type": "Html" } ] }, { "id": "GENERIC", "name": "Generic", "type": "Label", "typeDesc": "Group", "parent": "UnIqEiD", "properties": [ { "name": "Group", "value": "Generic", "type": "Label" } ] }, { "id": "4df3fdf0-b29c-cfef-194d-0da354f9abee", "type": "ComponentsParameter", "typeDesc": "Simple parameter", "parent": "GENERIC", "properties": [ { "name": "name", "value": "CIIU", "type": "Id" }, { "name": "propertyValue", "value": "CIIU", "type": "String" }, { "name": "parameterViewRole", "value": "unused", "type": "parameterViewRoleCustom" }, { "name": "bookmarkable", "value": "false", "type": "Boolean" } ] }, { "id": "46640dc6-ca97-4773-de38-a414d4f2419e", "type": "ComponentsParameter", "typeDesc": "Simple parameter", "parent": "GENERIC", "properties": [ { "name": "name", "value": "CIIU2", "type": "Id" }, { "name": "propertyValue", "value": "CIIU2", "type": "String" }, { "name": "parameterViewRole", "value": "unused", "type": "parameterViewRoleCustom" }, { "name": "bookmarkable", "value": "false", "type": "Boolean" } ] }, { "id": "478339e2-da72-ef0a-a02c-89cff3e12a04", "type": "ComponentsParameter", "typeDesc": "Simple parameter", "parent": "GENERIC", "properties": [ { "name": "name", "value": "Descrip", "type": "Id" }, { "name": "propertyValue", "value": "Descrip", "type": "String" }, { "name": "parameterViewRole", "value": "unused", "type": "parameterViewRoleCustom" }, { "name": "bookmarkable", "value": "false", "type": "Boolean" } ] }, { "id": "CHARTS", "name": "Charts", "type": "Label", "typeDesc": "Group", "parent": "UnIqEiD", "properties": [ { "name": "Group", "value": "Charts", "type": "Label" } ] }, { "id": "fad2d57f-38ff-817d-751d-4f1715af7d26", "type": "ComponentscccBarChart", "typeDesc": "CCC Bar Chart", "parent": "CHARTS", "properties": [ { "name": "name", "value": "Barchart", "type": "Id" }, { "name": "title", "value": "Plantas por Estado", "type": "String" }, { "name": "listeners", "value": "['${p:CIIU2}']", "type": "Listeners" }, { "name": "customfunction", "value": "", "type": "JavaScript" }, { "name": "parameters", "value": "[[\"CIIU2\",\"CIIU2\"]]", "type": "ValuesArray" }, { "name": "dataSource", "value": "PlantasxEstado", "type": "Datasource" }, { "name": "height", "value": "400", "type": "Integer" }, { "name": "width", "value": "", "type": "Integer" }, { "name": "refreshPeriod", "value": "", "type": "Integer" }, { "name": "priority", "value": 5, "type": "Integer" }, { "name": "colors", "value": "[]", "type": "Array" }, { "name": "htmlObject", "value": "${p:ChartEstado}", "type": "HtmlObject" }, { "name": "executeAtStart", "value": "true", "type": "Boolean" }, { "name": "preExecution", "value": "", "type": "JavaScript" }, { "name": "postFetch", "value": "", "type": "JavaScript" }, { "name": "postExecution", "value": "", "type": "JavaScript" }, { "name": "preChange", "value": "", "type": "JavaScript" }, { "name": "postChange", "value": "", "type": "JavaScript" }, { "name": "tooltip", "value": "", "type": "Html" }, { "name": "extensionPoints", "value": "[]", "type": "ValuesArray" }, { "name": "animate", "value": true, "type": "Boolean" }, { "name": "barSizeMax", "value": 2000, "type": "Float" }, { "name": "barSizeRatio", "value": 0.9, "type": "Float" }, { "name": "barStackedMargin", "value": 0, "type": "Float" }, { "name": "baseAxisClickAction", "value": "", "type": "JavaScript" }, { "name": "baseAxisDoubleClickAction", "value": "", "type": "JavaScript" }, { "name": "baseAxisGrid", "value": false, "type": "Boolean" }, { "name": "baseAxisLabelSpacingMin", "value": "", "type": "Float" }, { "name": "baseAxisOffset", "value": 0, "type": "Float" }, { "name": "baseAxisOverlappedLabelsMode", "value": "hide", "type": "cccBaseAxisOverlappedLabelsModeCustom" }, { "name": "baseAxisPosition", "value": "", "type": "cccBaseAxisPositionCustom" }, { "name": "baseAxisSize", "value": "", "type": "String" }, { "name": "baseAxisSizeMax", "value": "", "type": "String" }, { "name": "baseAxisTicks", "value": true, "type": "Boolean" }, { "name": "baseAxisTitle", "value": "Estado", "type": "String" }, { "name": "baseAxisTitleAlign", "value": "", "type": "cccBaseAxisTitleAlignCustom" }, { "name": "baseAxisTitleFont", "value": "12px sans-serif", "type": "String" }, { "name": "baseAxisTitleMargins", "value": "0", "type": "String" }, { "name": "baseAxisTitleSize", "value": "", "type": "String" }, { "name": "baseAxisTitleSizeMax", "value": "", "type": "String" }, { "name": "baseAxisTooltipAutoContent", "value": "value", "type": "cccBaseAxisTooltipAutoContentCustom" }, { "name": "baseAxisTooltipEnabled", "value": true, "type": "Boolean" }, { "name": "baseAxisTooltipFormat", "value": "", "type": "JavaScript" }, { "name": "baseAxisVisible", "value": true, "type": "Boolean" }, { "name": "categoryRole", "value": "", "type": "String" }, { "name": "clearSelectionMode", "value": "emptySpaceClick", "type": "cccClearSelectionModeCustom" }, { "name": "clickable", "value": false, "type": "Boolean" }, { "name": "clickAction", "value": "", "type": "JavaScript" }, { "name": "color2AxisColors", "value": "[]", "type": "Array" }, { "name": "color2AxisLegendClickMode", "value": "toggleVisible", "type": "cccColor2AxisLegendClickModeCustom" }, { "name": "color2AxisLegendDrawLine", "value": "", "type": "Boolean" }, { "name": "color2AxisLegendDrawMarker", "value": "", "type": "Boolean" }, { "name": "color2AxisLegendShape", "value": "", "type": "cccColor2AxisLegendShapeCustom" }, { "name": "color2AxisLegendVisible", "value": true, "type": "Boolean" }, { "name": "color2AxisTransform", "value": "", "type": "JavaScript" }, { "name": "color2AxisUnbound", "value": "", "type": "String" }, { "name": "colorRole", "value": "", "type": "String" }, { "name": "colorTransform", "value": "", "type": "JavaScript" }, { "name": "colorUnbound", "value": "", "type": "String" }, { "name": "compatVersion", "value": 2, "type": "Float" }, { "name": "contentMargins", "value": "0", "type": "String" }, { "name": "contentPaddings", "value": "0", "type": "String" }, { "name": "crosstabMode", "value": true, "type": "Boolean" }, { "name": "ctrlSelectMode", "value": true, "type": "Boolean" }, { "name": "dataCategoriesCount", "value": "", "type": "Float" }, { "name": "dataIgnoreMetadataLabels", "value": false, "type": "Boolean" }, { "name": "dataMeasuresInColumns", "value": false, "type": "Boolean" }, { "name": "dataPartRole", "value": "", "type": "String" }, { "name": "dataSeparator", "value": "~", "type": "String" }, { "name": "doubleClickAction", "value": "", "type": "JavaScript" }, { "name": "groupedLabelSep", "value": " ~ ", "type": "String" }, { "name": "hoverable", "value": false, "type": "Boolean" }, { "name": "ignoreNulls", "value": true, "type": "Boolean" }, { "name": "interactive", "value": "", "type": "Boolean" }, { "name": "isMultiValued", "value": false, "type": "Boolean" }, { "name": "leafContentOverflow", "value": "auto", "type": "cccLeafContentOverflowCustom" }, { "name": "legend", "value": "false", "type": "Boolean" }, { "name": "legendAlign", "value": "", "type": "cccLegendAlignCustom" }, { "name": "legendClickMode", "value": "toggleVisible", "type": "cccLegendClickModeCustom" }, { "name": "legendDrawLine", "value": "", "type": "Boolean" }, { "name": "legendDrawMarker", "value": "", "type": "Boolean" }, { "name": "legendFont", "value": "10px sans-serif", "type": "String" }, { "name": "legendItemPadding", "value": 2.5, "type": "Float" }, { "name": "legendMargins", "value": "0", "type": "String" }, { "name": "legendMarkerSize", "value": 15, "type": "Float" }, { "name": "legendPaddings", "value": "5", "type": "String" }, { "name": "legendPosition", "value": "bottom", "type": "cccLegendPositionCustom" }, { "name": "legendShape", "value": "", "type": "cccLegendShapeCustom" }, { "name": "legendSize", "value": "", "type": "String" }, { "name": "legendSizeMax", "value": "", "type": "String" }, { "name": "legendTextMargin", "value": 6, "type": "Float" }, { "name": "legendVisible", "value": true, "type": "Boolean" }, { "name": "margins", "value": "3", "type": "String" }, { "name": "measuresIndexes", "value": "[]", "type": "Array" }, { "name": "multiChartColumnsMax", "value": 3, "type": "Float" }, { "name": "multiChartIndexes", "value": "[]", "type": "Array" }, { "name": "multiChartMax", "value": "", "type": "Float" }, { "name": "multiChartOverflow", "value": "grow", "type": "cccMultiChartOverflowCustom" }, { "name": "multiChartRole", "value": "", "type": "String" }, { "name": "multiChartSingleColFillsHeight", "value": true, "type": "Boolean" }, { "name": "multiChartSingleRowFillsHeight", "value": true, "type": "Boolean" }, { "name": "nullInterpolationMode", "value": "none", "type": "cccNullInterpolationModeCustom" }, { "name": "orientation", "value": "horizontal", "type": "cccOrientationCustom" }, { "name": "ortho2AxisDesiredTickCount", "value": "", "type": "Float" }, { "name": "ortho2AxisDomainRoundMode", "value": "tick", "type": "cccOrtho2AxisDomainRoundModeCustom" }, { "name": "ortho2AxisDomainScope", "value": "global", "type": "cccOrtho2AxisDomainScopeCustom" }, { "name": "ortho2AxisFixedMax", "value": "", "type": "String" }, { "name": "ortho2AxisFixedMin", "value": "", "type": "String" }, { "name": "ortho2AxisGrid", "value": false, "type": "Boolean" }, { "name": "ortho2AxisLabelSpacingMin", "value": "", "type": "Float" }, { "name": "ortho2AxisMinorTicks", "value": true, "type": "Boolean" }, { "name": "ortho2AxisOffset", "value": 0, "type": "Float" }, { "name": "ortho2AxisOriginIsZero", "value": "", "type": "Boolean" }, { "name": "ortho2AxisOverlappedLabelsMode", "value": "hide", "type": "cccOrtho2AxisOverlappedLabelsModeCustom" }, { "name": "ortho2AxisPosition", "value": "", "type": "cccOrtho2AxisPositionCustom" }, { "name": "ortho2AxisSize", "value": "", "type": "String" }, { "name": "ortho2AxisSizeMax", "value": "", "type": "String" }, { "name": "ortho2AxisTickExponentMax", "value": "", "type": "Float" }, { "name": "ortho2AxisTickExponentMin", "value": "", "type": "Float" }, { "name": "ortho2AxisTickFormatter", "value": "", "type": "JavaScript" }, { "name": "ortho2AxisTicks", "value": true, "type": "Boolean" }, { "name": "ortho2AxisTitle", "value": "", "type": "String" }, { "name": "ortho2AxisTitleAlign", "value": "", "type": "cccOrtho2AxisTitleAlignCustom" }, { "name": "ortho2AxisTitleFont", "value": "12px sans-serif", "type": "String" }, { "name": "ortho2AxisTitleMargins", "value": "0", "type": "String" }, { "name": "ortho2AxisTitleSize", "value": "", "type": "String" }, { "name": "ortho2AxisTitleSizeMax", "value": "", "type": "String" }, { "name": "ortho2AxisVisible", "value": true, "type": "Boolean" }, { "name": "ortho2AxisZeroLine", "value": true, "type": "Boolean" }, { "name": "orthoAxisDesiredTickCount", "value": "", "type": "Float" }, { "name": "orthoAxisDomainRoundMode", "value": "tick", "type": "cccOrthoAxisDomainRoundModeCustom" }, { "name": "orthoAxisDomainScope", "value": "global", "type": "cccOrthoAxisDomainScopeCustom" }, { "name": "orthoAxisFixedMax", "value": "", "type": "String" }, { "name": "orthoAxisFixedMin", "value": "", "type": "String" }, { "name": "orthoAxisGrid", "value": false, "type": "Boolean" }, { "name": "orthoAxisLabelSpacingMin", "value": "", "type": "Float" }, { "name": "orthoAxisMinorTicks", "value": true, "type": "Boolean" }, { "name": "orthoAxisOffset", "value": 0, "type": "Float" }, { "name": "orthoAxisOriginIsZero", "value": "", "type": "Boolean" }, { "name": "orthoAxisOverlappedLabelsMode", "value": "hide", "type": "cccOrthoAxisOverlappedLabelsModeCustom" }, { "name": "orthoAxisPosition", "value": "", "type": "cccOrthoAxisPositionCustom" }, { "name": "orthoAxisSize", "value": "", "type": "String" }, { "name": "orthoAxisSizeMax", "value": "", "type": "String" }, { "name": "orthoAxisTickExponentMax", "value": "", "type": "Float" }, { "name": "orthoAxisTickExponentMin", "value": "", "type": "Float" }, { "name": "orthoAxisTickFormatter", "value": "", "type": "JavaScript" }, { "name": "orthoAxisTicks", "value": true, "type": "Boolean" }, { "name": "orthoAxisTitle", "value": "Total Plantas", "type": "String" }, { "name": "orthoAxisTitleAlign", "value": "center", "type": "cccOrthoAxisTitleAlignCustom" }, { "name": "orthoAxisTitleFont", "value": "12px sans-serif", "type": "String" }, { "name": "orthoAxisTitleMargins", "value": "0", "type": "String" }, { "name": "orthoAxisTitleSize", "value": "", "type": "String" }, { "name": "orthoAxisTitleSizeMax", "value": "", "type": "String" }, { "name": "orthoAxisVisible", "value": true, "type": "Boolean" }, { "name": "orthoAxisZeroLine", "value": true, "type": "Boolean" }, { "name": "overflowMarkersVisible", "value": true, "type": "Boolean" }, { "name": "paddings", "value": "0", "type": "String" }, { "name": "panelSizeRatio", "value": "0.9", "type": "Float" }, { "name": "percentValueFormat", "value": "", "type": "JavaScript" }, { "name": "plot2", "value": false, "type": "Boolean" }, { "name": "plot2AreasVisible", "value": false, "type": "Boolean" }, { "name": "plot2ColorAxis", "value": 2, "type": "Float" }, { "name": "plot2DotsVisible", "value": true, "type": "Boolean" }, { "name": "plot2LinesVisible", "value": true, "type": "Boolean" }, { "name": "plot2NullInterpolationMode", "value": "none", "type": "cccPlot2NullInterpolationModeCustom" }, { "name": "plot2OrthoAxis", "value": 1, "type": "Float" }, { "name": "plot2Series", "value": "[]", "type": "Array" }, { "name": "plot2SeriesIndexes", "value": -1, "type": "Array" }, { "name": "plot2Stacked", "value": false, "type": "Boolean" }, { "name": "plot2TrendLabel", "value": "", "type": "String" }, { "name": "plot2TrendType", "value": "", "type": "String" }, { "name": "plot2ValuesAnchor", "value": "", "type": "cccPlot2ValuesAnchorCustom" }, { "name": "plot2ValuesFont", "value": "10px sans-serif", "type": "String" }, { "name": "plot2ValuesMask", "value": "{value}", "type": "String" }, { "name": "plot2ValuesVisible", "value": false, "type": "Boolean" }, { "name": "plotFrameVisible", "value": true, "type": "Boolean" }, { "name": "renderCallback", "value": "", "type": "JavaScript" }, { "name": "selectable", "value": false, "type": "Boolean" }, { "name": "selectionChangedAction", "value": "", "type": "JavaScript" }, { "name": "seriesInRows", "value": "false", "type": "Boolean" }, { "name": "seriesRole", "value": "", "type": "String" }, { "name": "smallAspectRatio", "value": "", "type": "Float" }, { "name": "smallContentMargins", "value": "0", "type": "String" }, { "name": "smallContentPaddings", "value": "0", "type": "String" }, { "name": "smallHeight", "value": "", "type": "String" }, { "name": "smallMargins", "value": "2%", "type": "String" }, { "name": "smallPaddings", "value": "0", "type": "String" }, { "name": "smallTitleAlign", "value": "", "type": "cccSmallTitleAlignCustom" }, { "name": "smallTitleFont", "value": "14px sans-serif", "type": "String" }, { "name": "smallTitleMargins", "value": "0", "type": "String" }, { "name": "smallTitlePaddings", "value": "0", "type": "String" }, { "name": "smallTitlePosition", "value": "top", "type": "cccSmallTitlePositionCustom" }, { "name": "smallTitleSize", "value": "", "type": "String" }, { "name": "smallTitleSizeMax", "value": "", "type": "String" }, { "name": "smallWidth", "value": "", "type": "String" }, { "name": "stacked", "value": false, "type": "Boolean" }, { "name": "timeSeries", "value": "false", "type": "Boolean" }, { "name": "timeSeriesFormat", "value": "%Y-%m-%d", "type": "String" }, { "name": "titleAlign", "value": "", "type": "cccTitleAlignCustom" }, { "name": "titleFont", "value": "14px sans-serif", "type": "String" }, { "name": "titleMargins", "value": "0", "type": "String" }, { "name": "titlePaddings", "value": "0", "type": "String" }, { "name": "titlePosition", "value": "top", "type": "cccTitlePositionCustom" }, { "name": "titleSize", "value": "", "type": "String" }, { "name": "titleSizeMax", "value": "", "type": "String" }, { "name": "tooltipArrowVisible", "value": "", "type": "Boolean" }, { "name": "tooltipEnabled", "value": true, "type": "Boolean" }, { "name": "tooltipFade", "value": true, "type": "Boolean" }, { "name": "tooltipFollowMouse", "value": false, "type": "Boolean" }, { "name": "tooltipFormat", "value": "", "type": "JavaScript" }, { "name": "tooltipGravity", "value": "", "type": "cccTooltipGravityCustom" }, { "name": "tooltipHtml", "value": true, "type": "Boolean" }, { "name": "tooltipOffset", "value": "", "type": "Float" }, { "name": "tooltipOpacity", "value": 0.9, "type": "Float" }, { "name": "tooltipUseCorners", "value": "", "type": "Boolean" }, { "name": "trendAreasVisible", "value": false, "type": "Boolean" }, { "name": "trendColorAxis", "value": 2, "type": "Float" }, { "name": "trendDotsVisible", "value": false, "type": "Boolean" }, { "name": "trendLabel", "value": "", "type": "String" }, { "name": "trendLinesVisible", "value": true, "type": "Boolean" }, { "name": "trendOrthoAxis", "value": 1, "type": "Float" }, { "name": "trendStacked", "value": false, "type": "Boolean" }, { "name": "trendType", "value": "", "type": "String" }, { "name": "trendValuesAnchor", "value": "right", "type": "cccTrendValuesAnchorCustom" }, { "name": "trendValuesFont", "value": "10px sans-serif", "type": "String" }, { "name": "trendValuesMask", "value": "", "type": "String" }, { "name": "trendValuesVisible", "value": false, "type": "Boolean" }, { "name": "userSelectionAction", "value": "", "type": "JavaScript" }, { "name": "valueFormat", "value": "", "type": "JavaScript" }, { "name": "valueRole", "value": "", "type": "String" }, { "name": "valuesAnchor", "value": "", "type": "cccValuesAnchorCustom" }, { "name": "valuesFont", "value": "10px sans-serif", "type": "String" }, { "name": "valuesMask", "value": "", "type": "String" }, { "name": "valuesVisible", "value": "", "type": "Boolean" } ], "meta_cdwSupport": "true" } ] }, "datasources": { "rows": [ { "id": "SQL", "name": "SQL Queries", "type": "Label", "typeDesc": "Group", "parent": "UnIqEiD", "properties": [ { "name": "Group", "value": "SQL Queries", "type": "Label" } ] }, { "id": "4c457161-ca09-6c07-13b3-ab327d26683a", "type": "Componentssql_sqlJndi", "typeDesc": "sql over sqlJndi", "parent": "SQL", "properties": [ { "name": "name", "value": "ciiu2digitos", "type": "Id" }, { "name": "access", "value": "public", "type": "Access" }, { "name": "jndi", "value": "smid", "type": "Jndi" }, { "name": "query", "value": "SELECT\n \"dimension_ciiu\".\"ciiu\", \"dimension_ciiu\".\"ciiu\" || ' - ' ||\"dimension_ciiu\".\"descripcion\" \nFROM\n \"dimension_ciiu\"\nWHERE\n character_length(dimension_ciiu.ciiu) = 2", "type": "SqlQuery" }, { "name": "parameters", "value": "[]", "type": "CdaParameters" }, { "name": "outputMode", "value": "include", "type": "OutputMode" }, { "name": "cdacolumns", "value": "[]", "type": "CdaColumnsArray" }, { "name": "cdacalculatedcolumns", "value": "[]", "type": "CdaCalculatedColumnsArray" }, { "name": "output", "value": "[]", "type": "IndexArray" }, { "name": "cacheDuration", "value": 3600, "type": "Integer" }, { "name": "cache", "value": "true", "type": "Boolean" } ], "meta": "CDA", "meta_conntype": "sql.jndi", "meta_datype": "sql" }, { "id": "4af5bdda-1e33-e349-292a-48c09c3ddc44", "type": "Componentssql_sqlJndi", "typeDesc": "sql over sqlJndi", "parent": "SQL", "properties": [ { "name": "name", "value": "ciiu4digitos", "type": "Id" }, { "name": "access", "value": "public", "type": "Access" }, { "name": "jndi", "value": "smid", "type": "Jndi" }, { "name": "query", "value": "SELECT DISTINCT\n \"dimension_ciiu\".\"ciiu\", \"dimension_ciiu\".\"ciiu\" || ' ' || \"dimension_ciiu\".\"descripcion\"\nFROM\n \"hechos_plantas_ciiu_ue_tipotenencia_parroquia\" INNER JOIN \"dimension_ciiu\" ON \"hechos_plantas_ciiu_ue_tipotenencia_parroquia\".\"id_ciiu\" = \"dimension_ciiu\".\"id\"\n INNER JOIN \"dimension_empresa\" ON \"hechos_plantas_ciiu_ue_tipotenencia_parroquia\".\"id_empresa\" = \"dimension_empresa\".\"id\"\nWHERE\n dimension_ciiu.ciiu LIKE ${CIIU} || '%' and character_length(dimension_ciiu.ciiu) = 4\nGROUP BY\n \"dimension_ciiu\".\"ciiu\",\n \"dimension_ciiu\".\"descripcion\"\nORDER BY\n \"dimension_ciiu\".\"ciiu\" ASC", "type": "SqlQuery" }, { "name": "parameters", "value": "[[\"CIIU\",\"CIIU\",\"String\",\"\"]]", "type": "CdaParameters" }, { "name": "outputMode", "value": "include", "type": "OutputMode" }, { "name": "cdacolumns", "value": "[]", "type": "CdaColumnsArray" }, { "name": "cdacalculatedcolumns", "value": "[]", "type": "CdaCalculatedColumnsArray" }, { "name": "output", "value": "[]", "type": "IndexArray" }, { "name": "cacheDuration", "value": 3600, "type": "Integer" }, { "name": "cache", "value": "true", "type": "Boolean" } ], "meta": "CDA", "meta_conntype": "sql.jndi", "meta_datype": "sql" }, { "id": "4fa906dd-12f9-f9e4-5a8d-99f9179e610a", "type": "Componentssql_sqlJndi", "typeDesc": "sql over sqlJndi", "parent": "SQL", "properties": [ { "name": "name", "value": "CIIUTable4", "type": "Id" }, { "name": "access", "value": "public", "type": "Access" }, { "name": "jndi", "value": "smid", "type": "Jndi" }, { "name": "query", "value": "SELECT DISTINCT\n \"dimension_ciiu\".\"ciiu\" AS ciiu,\n \"dimension_ciiu\".\"descripcion\" AS descripcion,\n count(\"hechos_plantas_ciiu_ue_tipotenencia_parroquia\".\"id_planta\") AS total\nFROM\n \"hechos_plantas_ciiu_ue_tipotenencia_parroquia\" INNER JOIN \"dimension_ciiu\" ON \"hechos_plantas_ciiu_ue_tipotenencia_parroquia\".\"id_ciiu\" = \"dimension_ciiu\".\"id\"\n INNER JOIN \"dimension_empresa\" ON \"hechos_plantas_ciiu_ue_tipotenencia_parroquia\".\"id_empresa\" = \"dimension_empresa\".\"id\"\nWHERE\n dimension_ciiu.ciiu LIKE ${CIIU}||'%'\nGROUP BY\n ciiu,\n descripcion\nORDER BY\n \"dimension_ciiu\".\"ciiu\" ASC", "type": "SqlQuery" }, { "name": "parameters", "value": "[[\"CIIU\",\"CIIU\",\"String\",\"\"]]", "type": "CdaParameters" }, { "name": "outputMode", "value": "include", "type": "OutputMode" }, { "name": "cdacolumns", "value": "[]", "type": "CdaColumnsArray" }, { "name": "cdacalculatedcolumns", "value": "[]", "type": "CdaCalculatedColumnsArray" }, { "name": "output", "value": "[]", "type": "IndexArray" }, { "name": "cacheDuration", "value": 3600, "type": "Integer" }, { "name": "cache", "value": "true", "type": "Boolean" } ], "meta": "CDA", "meta_conntype": "sql.jndi", "meta_datype": "sql" }, { "id": "7bf2dae0-ad23-e898-cbb8-18f95318df63", "type": "Componentssql_sqlJndi", "typeDesc": "sql over sqlJndi", "parent": "SQL", "properties": [ { "name": "name", "value": "PlantasxEstado", "type": "Id" }, { "name": "access", "value": "public", "type": "Access" }, { "name": "jndi", "value": "smid", "type": "Jndi" }, { "name": "query", "value": "SELECT DISTINCT\n \"dimension_estado\".\"nombre\" AS estado,\n count(\"hechos_plantas_ciiu_ue_tipotenencia_parroquia\".\"id_planta\") AS total\nFROM\n \"hechos_plantas_ciiu_ue_tipotenencia_parroquia\" INNER JOIN \"dimension_ciiu\" ON \"hechos_plantas_ciiu_ue_tipotenencia_parroquia\".\"id_ciiu\" = \"dimension_ciiu\".\"id\"\n INNER JOIN \"dimension_empresa\" ON \"hechos_plantas_ciiu_ue_tipotenencia_parroquia\".\"id_empresa\" = \"dimension_empresa\".\"id\"\n INNER JOIN \"dimension_estado\" ON \"hechos_plantas_ciiu_ue_tipotenencia_parroquia\".\"id_estado\" = \"dimension_estado\".\"id\"\nWHERE\n dimension_ciiu.ciiu like ${CIIU2}\nGROUP BY\n estado\nORDER BY\n total asc", "type": "SqlQuery" }, { "name": "parameters", "value": "[[\"CIIU2\",\"CIIU2\",\"String\",\"\"]]", "type": "CdaParameters" }, { "name": "outputMode", "value": "include", "type": "OutputMode" }, { "name": "cdacolumns", "value": "[]", "type": "CdaColumnsArray" }, { "name": "cdacalculatedcolumns", "value": "[]", "type": "CdaCalculatedColumnsArray" }, { "name": "output", "value": "[]", "type": "IndexArray" }, { "name": "cacheDuration", "value": 3600, "type": "Integer" }, { "name": "cache", "value": "true", "type": "Boolean" } ], "meta": "CDA", "meta_conntype": "sql.jndi", "meta_datype": "sql" }, { "id": "7969fc7a-4178-1cde-3b29-fb7534b0c56c", "type": "Componentssql_sqlJndi", "typeDesc": "sql over sqlJndi", "parent": "SQL", "properties": [ { "name": "name", "value": "PrincipalesEmpresas", "type": "Id" }, { "name": "access", "value": "public", "type": "Access" }, { "name": "jndi", "value": "smid", "type": "Jndi" }, { "name": "query", "value": "SELECT \n \"dimension_empresa\".\"razon_social\" AS empresa,\n \"dimension_empresa\".\"rif\" AS rif,\n sum(\"hechos_bienesproducidos_empresa\".\"medida_cantidad_vendida\") AS total,\n round(sum(\"hechos_bienesproducidos_empresa\".\"medida_cantidad_vendida\")/(SELECT \n sum(\"hechos_bienesproducidos_empresa\".\"medida_cantidad_vendida\")\nFROM\n \"dimension_empresa\" INNER JOIN \"hechos_bienesproducidos_empresa\" ON \"dimension_empresa\".\"id\" = \"hechos_bienesproducidos_empresa\".\"id_empresa\"\nWHERE\n dimension_empresa.id IN ( SELECT\n \"dimension_empresa\".\"id\"\nFROM\n \"hechos_plantas_ciiu_ue_tipotenencia_parroquia\" \n INNER JOIN \"dimension_ciiu\" ON \"hechos_plantas_ciiu_ue_tipotenencia_parroquia\".\"id_ciiu\" = \"dimension_ciiu\".\"id\"\n INNER JOIN \"dimension_empresa\" ON \"hechos_plantas_ciiu_ue_tipotenencia_parroquia\".\"id_empresa\" = \"dimension_empresa\".\"id\"\n INNER JOIN \"dimension_estado\" ON \"hechos_plantas_ciiu_ue_tipotenencia_parroquia\".\"id_estado\" = \"dimension_estado\".\"id\"\nWHERE\n dimension_ciiu.ciiu LIKE ${CIIU2}\nGROUP BY\n \"dimension_empresa\".\"id\" ))::numeric*100,2) as Porcentaje\nFROM\n \"dimension_empresa\" INNER JOIN \"hechos_bienesproducidos_empresa\" ON \"dimension_empresa\".\"id\" = \"hechos_bienesproducidos_empresa\".\"id_empresa\"\nWHERE\n dimension_empresa.id IN ( SELECT\n \"dimension_empresa\".\"id\"\nFROM\n \"hechos_plantas_ciiu_ue_tipotenencia_parroquia\" \n INNER JOIN \"dimension_ciiu\" ON \"hechos_plantas_ciiu_ue_tipotenencia_parroquia\".\"id_ciiu\" = \"dimension_ciiu\".\"id\"\n INNER JOIN \"dimension_empresa\" ON \"hechos_plantas_ciiu_ue_tipotenencia_parroquia\".\"id_empresa\" = \"dimension_empresa\".\"id\"\n INNER JOIN \"dimension_estado\" ON \"hechos_plantas_ciiu_ue_tipotenencia_parroquia\".\"id_estado\" = \"dimension_estado\".\"id\"\nWHERE\n dimension_ciiu.ciiu LIKE ${CIIU2}\nGROUP BY\n \"dimension_empresa\".\"id\" )\nGROUP BY \nempresa,\nrif\nORDER BY total DESC\nLIMIT 5\n\n ", "type": "SqlQuery" }, { "name": "parameters", "value": "[[\"CIIU2\",\"CIIU2\",\"String\",\"\"]]", "type": "CdaParameters" }, { "name": "outputMode", "value": "include", "type": "OutputMode" }, { "name": "cdacolumns", "value": "[]", "type": "CdaColumnsArray" }, { "name": "cdacalculatedcolumns", "value": "[]", "type": "CdaCalculatedColumnsArray" }, { "name": "output", "value": "[]", "type": "IndexArray" }, { "name": "cacheDuration", "value": 3600, "type": "Integer" }, { "name": "cache", "value": "true", "type": "Boolean" } ], "meta": "CDA", "meta_conntype": "sql.jndi", "meta_datype": "sql" }, { "id": "f45a7003-97d3-2e46-6a6a-f652533926c1", "type": "Componentssql_sqlJndi", "typeDesc": "sql over sqlJndi", "parent": "SQL", "properties": [ { "name": "name", "value": "DescripcionCIIU", "type": "Id" }, { "name": "access", "value": "public", "type": "Access" }, { "name": "jndi", "value": "smid", "type": "Jndi" }, { "name": "query", "value": "SELECT\n \"dimension_ciiu\".\"ciiu\" || ' - ' || \"dimension_ciiu\".\"descripcion\" as Descr\nFROM\n \"hechos_plantas_ciiu_ue_tipotenencia_parroquia\" INNER JOIN \"dimension_ciiu\" ON \"hechos_plantas_ciiu_ue_tipotenencia_parroquia\".\"id_ciiu\" = \"dimension_ciiu\".\"id\"\n INNER JOIN \"dimension_empresa\" ON \"hechos_plantas_ciiu_ue_tipotenencia_parroquia\".\"id_empresa\" = \"dimension_empresa\".\"id\"\nWHERE\n dimension_ciiu.ciiu LIKE ${CIIU2} || '%' and character_length(dimension_ciiu.ciiu) = 4\nGROUP BY\n \"dimension_ciiu\".\"ciiu\",\n \"dimension_ciiu\".\"descripcion\"\n", "type": "SqlQuery" }, { "name": "parameters", "value": "[[\"CIIU2\",\"CIIU2\",\"String\",\"\"]]", "type": "CdaParameters" }, { "name": "outputMode", "value": "include", "type": "OutputMode" }, { "name": "cdacolumns", "value": "[]", "type": "CdaColumnsArray" }, { "name": "cdacalculatedcolumns", "value": "[]", "type": "CdaCalculatedColumnsArray" }, { "name": "output", "value": "[]", "type": "IndexArray" }, { "name": "cacheDuration", "value": 3600, "type": "Integer" }, { "name": "cache", "value": "true", "type": "Boolean" } ], "meta": "CDA", "meta_conntype": "sql.jndi", "meta_datype": "sql" } ] }, "filename": "/cde/dashboard/Cuadro 1.cdfde" }