{
"layout": {
"title": "Two Columns Template",
"rows": [
{
"id": "f035c263-69f6-8048-9039-d0fd580499a6",
"type": "LayoutResourceCode",
"typeDesc": "Resource",
"parent": "UnIqEiD",
"properties": [
{
"name": "name",
"value": "ac",
"type": "Id"
},
{
"name": "resourceType",
"value": "Css",
"type": "Label"
},
{
"name": "resourceCode",
"value": "ul.autobox-hldr-2 li.autobox-input input {\nwidth: 350px;\nmargin: 0;\nborder: 1px solid #666;\noutline: 0;\npadding: 3px 0 2px 2px;\n} \nselect {\n width: 500px;\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": ""
},
{
"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": "ab1cc176-8f71-e9d9-a375-ffd910e24923",
"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": "bd0df637-b92c-b743-f4ba-6a5bc96fa394",
"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": "db6818c8-ade4-70c6-d138-d46fc1656c4a",
"type": "LayoutHtml",
"typeDesc": "Html",
"parent": "bd0df637-b92c-b743-f4ba-6a5bc96fa394",
"properties": [
{
"name": "name",
"value": "",
"type": "Id"
},
{
"name": "html",
"value": "Principales Bienes por empresa
",
"type": "Html"
},
{
"name": "fontSize",
"value": "",
"type": "Integer"
},
{
"name": "color",
"value": "",
"type": "Color"
},
{
"name": "cssClass",
"value": "",
"type": "String"
}
]
},
{
"id": "0304a241-61de-3b21-bba3-ba90e9d17474",
"type": "LayoutSpace",
"typeDesc": "Space",
"parent": "UnIqEiD",
"properties": [
{
"name": "height",
"value": "",
"type": "Integer"
},
{
"name": "backgroundColor",
"value": "",
"type": "Color"
},
{
"name": "cssClass",
"value": "",
"type": "String"
}
]
},
{
"id": "fcdd318a-1c43-10d2-a573-1a47b6866f08",
"type": "LayoutRow",
"typeDesc": "Row",
"parent": "UnIqEiD",
"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": "610a3d25-e87b-f5e5-e836-21cc7f5b125e",
"type": "LayoutColumn",
"typeDesc": "Column",
"parent": "fcdd318a-1c43-10d2-a573-1a47b6866f08",
"properties": [
{
"name": "name",
"value": "NombreFiltro1",
"type": "Id"
},
{
"name": "columnSpan",
"value": "5",
"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": "20",
"type": "Integer"
},
{
"name": "backgroundColor",
"value": "",
"type": "Color"
},
{
"name": "roundCorners",
"value": "",
"type": "RoundCorners"
},
{
"name": "textAlign",
"value": "",
"type": "TextAlign"
},
{
"name": "cssClass",
"value": "",
"type": "String"
}
]
},
{
"id": "f3897100-b137-d0d0-1c8a-c1c3273ded4c",
"type": "LayoutHtml",
"typeDesc": "Html",
"parent": "610a3d25-e87b-f5e5-e836-21cc7f5b125e",
"properties": [
{
"name": "name",
"value": "",
"type": "Id"
},
{
"name": "html",
"value": "RIF ",
"type": "Html"
},
{
"name": "fontSize",
"value": "",
"type": "Integer"
},
{
"name": "color",
"value": "",
"type": "Color"
},
{
"name": "cssClass",
"value": "",
"type": "String"
}
]
},
{
"id": "2a5a4829-be0f-fc85-0c8e-6a36ea1f5323",
"type": "LayoutColumn",
"typeDesc": "Column",
"parent": "fcdd318a-1c43-10d2-a573-1a47b6866f08",
"properties": [
{
"name": "name",
"value": "filtro1",
"type": "Id"
},
{
"name": "columnSpan",
"value": "10",
"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": "20",
"type": "Integer"
},
{
"name": "backgroundColor",
"value": "",
"type": "Color"
},
{
"name": "roundCorners",
"value": "",
"type": "RoundCorners"
},
{
"name": "textAlign",
"value": "",
"type": "TextAlign"
},
{
"name": "cssClass",
"value": "",
"type": "String"
}
]
},
{
"id": "7587ccc6-2f5a-383a-775d-db175aefd2ad",
"type": "LayoutSpace",
"typeDesc": "Space",
"parent": "UnIqEiD",
"properties": [
{
"name": "height",
"value": "",
"type": "Integer"
},
{
"name": "backgroundColor",
"value": "",
"type": "Color"
},
{
"name": "cssClass",
"value": "",
"type": "String"
}
]
},
{
"id": "0e2e30ab-2f4e-e9af-af0d-4503b669be31",
"type": "LayoutRow",
"typeDesc": "Row",
"parent": "UnIqEiD",
"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": "2051d8c0-743b-e6e2-fb4a-79203c70779c",
"type": "LayoutColumn",
"typeDesc": "Column",
"parent": "0e2e30ab-2f4e-e9af-af0d-4503b669be31",
"properties": [
{
"name": "name",
"value": "NombreFiltro2",
"type": "Id"
},
{
"name": "columnSpan",
"value": 5,
"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": "20",
"type": "Integer"
},
{
"name": "backgroundColor",
"value": "",
"type": "Color"
},
{
"name": "roundCorners",
"value": "",
"type": "RoundCorners"
},
{
"name": "textAlign",
"value": "",
"type": "TextAlign"
},
{
"name": "cssClass",
"value": "",
"type": "String"
}
]
},
{
"id": "4ba593cf-a64e-c005-9972-a19afb883e0f",
"type": "LayoutHtml",
"typeDesc": "Html",
"parent": "2051d8c0-743b-e6e2-fb4a-79203c70779c",
"properties": [
{
"name": "name",
"value": "",
"type": "Id"
},
{
"name": "html",
"value": "Nombre ",
"type": "Html"
},
{
"name": "fontSize",
"value": "",
"type": "Integer"
},
{
"name": "color",
"value": "",
"type": "Color"
},
{
"name": "cssClass",
"value": "",
"type": "String"
}
]
},
{
"id": "e9258976-f020-48a2-a032-135c3064f39b",
"type": "LayoutColumn",
"typeDesc": "Column",
"parent": "0e2e30ab-2f4e-e9af-af0d-4503b669be31",
"properties": [
{
"name": "name",
"value": "filtro2",
"type": "Id"
},
{
"name": "columnSpan",
"value": "10",
"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": "20",
"type": "Integer"
},
{
"name": "backgroundColor",
"value": "",
"type": "Color"
},
{
"name": "roundCorners",
"value": "",
"type": "RoundCorners"
},
{
"name": "textAlign",
"value": "",
"type": "TextAlign"
},
{
"name": "cssClass",
"value": "",
"type": "String"
}
]
},
{
"id": "cf492d15-ec38-55ca-4208-745997221ccd",
"type": "LayoutSpace",
"typeDesc": "Space",
"parent": "UnIqEiD",
"properties": [
{
"name": "height",
"value": "",
"type": "Integer"
},
{
"name": "backgroundColor",
"value": "",
"type": "Color"
},
{
"name": "cssClass",
"value": "",
"type": "String"
}
]
},
{
"id": "aa9e3a51-4258-9123-33ed-ba255fad7d04",
"type": "LayoutRow",
"typeDesc": "Row",
"parent": "UnIqEiD",
"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": "e433f710-ec18-a828-1414-80564dbf5855",
"type": "LayoutColumn",
"typeDesc": "Column",
"parent": "aa9e3a51-4258-9123-33ed-ba255fad7d04",
"properties": [
{
"name": "name",
"value": "NombreFiltro3",
"type": "Id"
},
{
"name": "columnSpan",
"value": 5,
"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": "20",
"type": "Integer"
},
{
"name": "backgroundColor",
"value": "",
"type": "Color"
},
{
"name": "roundCorners",
"value": "",
"type": "RoundCorners"
},
{
"name": "textAlign",
"value": "",
"type": "TextAlign"
},
{
"name": "cssClass",
"value": "",
"type": "String"
}
]
},
{
"id": "ab58de57-ac0e-fb2c-e7ac-f68a5ac006e5",
"type": "LayoutHtml",
"typeDesc": "Html",
"parent": "e433f710-ec18-a828-1414-80564dbf5855",
"properties": [
{
"name": "name",
"value": "",
"type": "Id"
},
{
"name": "html",
"value": "Razon Social ",
"type": "Html"
},
{
"name": "fontSize",
"value": "",
"type": "Integer"
},
{
"name": "color",
"value": "",
"type": "Color"
},
{
"name": "cssClass",
"value": "",
"type": "String"
}
]
},
{
"id": "ac45a101-e691-cb4d-8a40-e11c40a23acd",
"type": "LayoutColumn",
"typeDesc": "Column",
"parent": "aa9e3a51-4258-9123-33ed-ba255fad7d04",
"properties": [
{
"name": "name",
"value": "filtro3",
"type": "Id"
},
{
"name": "columnSpan",
"value": "10",
"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": "20",
"type": "Integer"
},
{
"name": "backgroundColor",
"value": "",
"type": "Color"
},
{
"name": "roundCorners",
"value": "",
"type": "RoundCorners"
},
{
"name": "textAlign",
"value": "",
"type": "TextAlign"
},
{
"name": "cssClass",
"value": "",
"type": "String"
}
]
},
{
"id": "6af355d2-ffcc-0219-f622-1b55a415e5fc",
"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": "a75b059a-0f5b-deda-6d3f-aeba72af2fe5",
"type": "LayoutColumn",
"typeDesc": "Column",
"parent": "9b5e4665-60dd-d123-d49a-7cb9072a0540",
"properties": [
{
"name": "name",
"type": "Id",
"value": "Panel_1"
},
{
"name": "columnSpan",
"type": "Integer",
"value": "22"
},
{
"name": "columnPrepend",
"type": "Integer",
"value": "1"
},
{
"name": "columnAppend",
"type": "Integer",
"value": "1"
},
{
"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": "#e0e0e0"
},
{
"name": "roundCorners",
"type": "RoundCorners",
"value": "cdfdd-round"
},
{
"name": "textAlign",
"type": "TextAlign",
"value": ""
},
{
"name": "cssClass",
"type": "String",
"value": ""
}
]
},
{
"id": "3dafab4e-45a0-db42-02fb-134477295117",
"type": "LayoutSpace",
"typeDesc": "Space",
"parent": "a75b059a-0f5b-deda-6d3f-aeba72af2fe5",
"properties": [
{
"name": "height",
"value": "",
"type": "Integer"
},
{
"name": "backgroundColor",
"value": "",
"type": "Color"
},
{
"name": "cssClass",
"value": "",
"type": "String"
}
]
},
{
"id": "c99dd324-c269-c6bf-2ed2-d9c4c1425249",
"type": "LayoutRow",
"typeDesc": "Row",
"parent": "a75b059a-0f5b-deda-6d3f-aeba72af2fe5",
"properties": [
{
"name": "name",
"value": "",
"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": "91244043-481a-eeb6-5916-4f2230e1baf3",
"type": "LayoutHtml",
"typeDesc": "Html",
"parent": "c99dd324-c269-c6bf-2ed2-d9c4c1425249",
"properties": [
{
"name": "name",
"value": "",
"type": "Id"
},
{
"name": "html",
"value": "Principales Productos que elabora según los montos vendidos
\n ",
"type": "Html"
},
{
"name": "fontSize",
"value": "",
"type": "Integer"
},
{
"name": "color",
"value": "",
"type": "Color"
},
{
"name": "cssClass",
"value": "",
"type": "String"
}
]
},
{
"id": "6178eecf-c3b2-9bf9-d33e-609de0312036",
"type": "LayoutRow",
"typeDesc": "Row",
"parent": "a75b059a-0f5b-deda-6d3f-aeba72af2fe5",
"properties": [
{
"name": "name",
"value": "fExportar",
"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": "856d7483-89b4-4ea1-706c-e5f15cd72dfb",
"type": "LayoutSpace",
"typeDesc": "Space",
"parent": "a75b059a-0f5b-deda-6d3f-aeba72af2fe5",
"properties": [
{
"name": "height",
"value": "",
"type": "Integer"
},
{
"name": "backgroundColor",
"value": "",
"type": "Color"
},
{
"name": "cssClass",
"value": "",
"type": "String"
}
]
},
{
"id": "e4cf9b23-0788-e7a9-35b2-fd3704e56ed9",
"type": "LayoutRow",
"typeDesc": "Row",
"parent": "a75b059a-0f5b-deda-6d3f-aeba72af2fe5",
"properties": [
{
"name": "name",
"value": "filtroselec",
"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": "e0e0424a-bac3-004c-5309-f137f252a744",
"type": "LayoutSpace",
"typeDesc": "Space",
"parent": "a75b059a-0f5b-deda-6d3f-aeba72af2fe5",
"properties": [
{
"name": "height",
"value": "",
"type": "Integer"
},
{
"name": "backgroundColor",
"value": "",
"type": "Color"
},
{
"name": "cssClass",
"value": "",
"type": "String"
}
]
},
{
"id": "fdec92a1-eaf6-3f09-cccb-96e5c8460427",
"type": "LayoutRow",
"typeDesc": "Row",
"parent": "a75b059a-0f5b-deda-6d3f-aeba72af2fe5",
"properties": [
{
"name": "name",
"value": "tabla",
"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": "10e638c3-543a-410d-89a6-d5e4b3f1c0f4",
"type": "LayoutRow",
"typeDesc": "Row",
"parent": "UnIqEiD",
"properties": [
{
"name": "name",
"value": "",
"type": "Id"
},
{
"name": "height",
"value": "5",
"type": "Integer"
},
{
"name": "backgroundColor",
"value": "",
"type": "Color"
},
{
"name": "roundCorners",
"value": "",
"type": "RoundCorners"
},
{
"name": "textAlign",
"value": "",
"type": "TextAlign"
},
{
"name": "cssClass",
"value": "",
"type": "String"
}
]
},
{
"id": "6056f259-ef6f-532f-5b0a-8d3bfcd494a5",
"type": "LayoutRow",
"typeDesc": "Row",
"parent": "UnIqEiD",
"properties": [
{
"name": "name",
"value": "ExportarC",
"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": "6e933249-6d80-9b57-95f9-8a47a24ae398",
"type": "LayoutRow",
"typeDesc": "Row",
"parent": "UnIqEiD",
"properties": [
{
"name": "name",
"type": "Id",
"value": "Small_Space"
},
{
"name": "height",
"type": "Integer",
"value": "5"
},
{
"name": "backgroundColor",
"type": "Color",
"value": ""
},
{
"name": "roundCorners",
"type": "RoundCorners",
"value": ""
},
{
"name": "textAlign",
"type": "TextAlign",
"value": ""
},
{
"name": "cssClass",
"type": "String",
"value": ""
}
]
},
{
"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\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": "7c14efa2-b1ea-71e1-13cb-a54abe672e95",
"type": "ComponentsSelect",
"typeDesc": "Select Component",
"parent": "SELECTORS",
"properties": [
{
"name": "name",
"value": "sRIF",
"type": "Id"
},
{
"name": "parameter",
"value": "${p:seleccion}",
"type": "Parameter"
},
{
"name": "listeners",
"value": "[]",
"type": "Listeners"
},
{
"name": "parameters",
"value": "[]",
"type": "ValuesArray"
},
{
"name": "valueAsId",
"value": "true",
"type": "Boolean"
},
{
"name": "externalPlugin",
"value": "",
"type": "String"
},
{
"name": "dataSource",
"value": "Rif",
"type": "Datasource"
},
{
"name": "valuesArray",
"value": "[]",
"type": "ValuesArray"
},
{
"name": "priority",
"value": "1",
"type": "Integer"
},
{
"name": "refreshPeriod",
"value": "",
"type": "Integer"
},
{
"name": "htmlObject",
"value": "${p:filtro1}",
"type": "HtmlObject"
},
{
"name": "executeAtStart",
"value": "true",
"type": "Boolean"
},
{
"name": "preExecution",
"value": "function LimpiarP() {\n //alert(\"msg\"+a.series);\n Dashboards.fireChange('Name','');\n Dashboards.fireChange('Razon','');\n}",
"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": "8ceda82e-db59-cf8c-add6-09f9e32231ea",
"type": "ComponentsSelect",
"typeDesc": "Select Component",
"parent": "SELECTORS",
"properties": [
{
"name": "name",
"value": "sNombre",
"type": "Id"
},
{
"name": "parameter",
"value": "${p:seleccion}",
"type": "Parameter"
},
{
"name": "listeners",
"value": "[]",
"type": "Listeners"
},
{
"name": "parameters",
"value": "[]",
"type": "ValuesArray"
},
{
"name": "valueAsId",
"value": "true",
"type": "Boolean"
},
{
"name": "externalPlugin",
"value": "",
"type": "String"
},
{
"name": "dataSource",
"value": "Nombre",
"type": "Datasource"
},
{
"name": "valuesArray",
"value": "[]",
"type": "ValuesArray"
},
{
"name": "priority",
"value": "1",
"type": "Integer"
},
{
"name": "refreshPeriod",
"value": "",
"type": "Integer"
},
{
"name": "htmlObject",
"value": "${p:filtro2}",
"type": "HtmlObject"
},
{
"name": "executeAtStart",
"value": "true",
"type": "Boolean"
},
{
"name": "preExecution",
"value": "function LimpiarP() {\n //alert(\"msg\"+a.series);\n Dashboards.fireChange('RIF','');\n Dashboards.fireChange('Razon','');\n}",
"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": "5f840956-ef78-82c7-4ba6-7ad86ca111a8",
"type": "ComponentsSelect",
"typeDesc": "Select Component",
"parent": "SELECTORS",
"properties": [
{
"name": "name",
"value": "sRazon",
"type": "Id"
},
{
"name": "parameter",
"value": "${p:seleccion}",
"type": "Parameter"
},
{
"name": "listeners",
"value": "[]",
"type": "Listeners"
},
{
"name": "parameters",
"value": "[]",
"type": "ValuesArray"
},
{
"name": "valueAsId",
"value": "true",
"type": "Boolean"
},
{
"name": "externalPlugin",
"value": "",
"type": "String"
},
{
"name": "dataSource",
"value": "RazonSocial",
"type": "Datasource"
},
{
"name": "valuesArray",
"value": "[]",
"type": "ValuesArray"
},
{
"name": "priority",
"value": "1",
"type": "Integer"
},
{
"name": "refreshPeriod",
"value": "",
"type": "Integer"
},
{
"name": "htmlObject",
"value": "${p:filtro3}",
"type": "HtmlObject"
},
{
"name": "executeAtStart",
"value": "true",
"type": "Boolean"
},
{
"name": "preExecution",
"value": "function LimpiarP() {\n //alert(\"msg\"+a.series);\n Dashboards.fireChange('RIF','');\n Dashboards.fireChange('Name','');\n}",
"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": "GENERIC",
"name": "Generic",
"type": "Label",
"typeDesc": "Group",
"parent": "UnIqEiD",
"properties": [
{
"name": "Group",
"value": "Generic",
"type": "Label"
}
]
},
{
"id": "25e7add4-6f9b-ba4a-1a8e-5e5f775780d5",
"type": "ComponentsParameter",
"typeDesc": "Simple parameter",
"parent": "GENERIC",
"properties": [
{
"name": "name",
"value": "seleccion",
"type": "Id"
},
{
"name": "propertyValue",
"value": "seleccion",
"type": "String"
},
{
"name": "parameterViewRole",
"value": "unused",
"type": "parameterViewRoleCustom"
},
{
"name": "bookmarkable",
"value": "false",
"type": "Boolean"
}
]
},
{
"id": "0cf07562-59e7-61a9-2a58-590d2ae88f0d",
"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": "OTHERCOMPONENTS",
"name": "Others",
"type": "Label",
"typeDesc": "Group",
"parent": "UnIqEiD",
"properties": [
{
"name": "Group",
"value": "Others",
"type": "Label"
}
]
},
{
"id": "80f14204-bc18-146e-6247-c57394111d6f",
"type": "ComponentsTable",
"typeDesc": "table Component",
"parent": "OTHERCOMPONENTS",
"properties": [
{
"name": "name",
"value": "Productos",
"type": "Id"
},
{
"name": "expandContainerObject",
"value": "",
"type": "String"
},
{
"name": "listeners",
"value": "['${p:seleccion}']",
"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": "[\"Producto\",\"Especificaciones Técnicas\",\"Monto de Venta\"]",
"type": "Array"
},
{
"name": "colTypes",
"value": "[]",
"type": "colTypesCustom"
},
{
"name": "colFormats",
"value": "[]",
"type": "Array"
},
{
"name": "colWidths",
"value": "[\"40%\",\"50%\",\"10%\"]",
"type": "Array"
},
{
"name": "colSortable",
"value": "[]",
"type": "Array"
},
{
"name": "parameters",
"value": "[[\"seleccion\",\"seleccion\"]]",
"type": "ValuesArray"
},
{
"name": "expandParameters",
"value": "[]",
"type": "ValuesArray"
},
{
"name": "paginate",
"value": "false",
"type": "Boolean"
},
{
"name": "displayLength",
"value": "",
"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": "PrincipalesProductos",
"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:tabla}",
"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": "efdd871a-1e13-b25d-eecd-15f5400c76b1",
"type": "ComponentsexportButton",
"typeDesc": "Export Button Component",
"parent": "OTHERCOMPONENTS",
"properties": [
{
"name": "name",
"value": "Exportar",
"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": "Productos",
"type": "String"
},
{
"name": "outputType",
"value": "csv",
"type": "String"
},
{
"name": "htmlObject",
"value": "fExportar",
"type": "HtmlObject"
},
{
"name": "executeAtStart",
"value": "true",
"type": "Boolean"
},
{
"name": "preExecution",
"value": "",
"type": "JavaScript"
},
{
"name": "postExecution",
"value": "",
"type": "JavaScript"
},
{
"name": "tooltip",
"value": "",
"type": "Html"
}
]
},
{
"id": "fd9cc85e-3cf4-5bba-7606-18284e3af1f6",
"type": "ComponentstextComponent",
"typeDesc": "Text Component",
"parent": "OTHERCOMPONENTS",
"properties": [
{
"name": "name",
"value": "empresa",
"type": "Id"
},
{
"name": "listeners",
"value": "['${p:seleccion}']",
"type": "Listeners"
},
{
"name": "expression",
"value": "function() {\n return \"Selección: \" + Dashboards.getParameterValue(\"Descrip\");\n}",
"type": "JavaScript"
},
{
"name": "priority",
"value": 5,
"type": "Integer"
},
{
"name": "refreshPeriod",
"value": "",
"type": "Integer"
},
{
"name": "htmlObject",
"value": "filtroselec",
"type": "HtmlObject"
},
{
"name": "executeAtStart",
"value": "true",
"type": "Boolean"
},
{
"name": "preExecution",
"value": "",
"type": "JavaScript"
},
{
"name": "postExecution",
"value": "",
"type": "JavaScript"
},
{
"name": "tooltip",
"value": "",
"type": "Html"
}
]
},
{
"id": "f305e108-94bc-324f-db09-d19e097d4848",
"type": "ComponentsQuery",
"typeDesc": "Query Component",
"parent": "OTHERCOMPONENTS",
"properties": [
{
"name": "name",
"value": "Descripcion",
"type": "Id"
},
{
"name": "listeners",
"value": "['${p:seleccion}']",
"type": "Listeners"
},
{
"name": "parameters",
"value": "[[\"seleccion\",\"seleccion\"]]",
"type": "ValuesArray"
},
{
"name": "resultvar",
"value": "${p:Descrip}",
"type": "Result"
},
{
"name": "dataSource",
"value": "Info",
"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": "bc7f3587-edb6-b732-e68c-9674dc633cc5",
"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": "ExportarC",
"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"
}
]
}
]
},
"datasources": {
"rows": [
{
"id": "SQL",
"name": "SQL Queries",
"type": "Label",
"typeDesc": "Group",
"parent": "UnIqEiD",
"properties": [
{
"name": "Group",
"value": "SQL Queries",
"type": "Label"
}
]
},
{
"id": "2a8e40e4-9e43-8fb9-3ab2-22eb42df0b16",
"type": "Componentssql_sqlJndi",
"typeDesc": "sql over sqlJndi",
"parent": "SQL",
"properties": [
{
"name": "name",
"value": "Rif",
"type": "Id"
},
{
"name": "access",
"value": "public",
"type": "Access"
},
{
"name": "jndi",
"value": "smid",
"type": "Jndi"
},
{
"name": "query",
"value": "SELECT\n \"dimension_empresa\".\"rif\"\nFROM\n \"dimension_empresa\" INNER JOIN \"hechos_bienesproducidos_empresa\" ON \"dimension_empresa\".\"id\" = \"hechos_bienesproducidos_empresa\".\"id_empresa\"\nGROUP BY \"dimension_empresa\".\"rif\"\nORDER BY 1 asc",
"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": "18ebc4de-4d61-c497-a821-987debb493e3",
"type": "Componentssql_sqlJndi",
"typeDesc": "sql over sqlJndi",
"parent": "SQL",
"properties": [
{
"name": "name",
"value": "Nombre",
"type": "Id"
},
{
"name": "access",
"value": "public",
"type": "Access"
},
{
"name": "jndi",
"value": "smid",
"type": "Jndi"
},
{
"name": "query",
"value": "SELECT\n \"dimension_empresa\".\"nombre\"\nFROM\n \"dimension_empresa\" INNER JOIN \"hechos_bienesproducidos_empresa\" ON \"dimension_empresa\".\"id\" = \"hechos_bienesproducidos_empresa\".\"id_empresa\"\nWHERE\n dimension_empresa.nombre NOT LIKE 'NO INDICA'\nGROUP BY\n \"dimension_empresa\".\"nombre\"\nORDER BY\n 1 ASC",
"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": "b658e0be-9a66-6bcb-fe20-0b4643ee942c",
"type": "Componentssql_sqlJndi",
"typeDesc": "sql over sqlJndi",
"parent": "SQL",
"properties": [
{
"name": "name",
"value": "RazonSocial",
"type": "Id"
},
{
"name": "access",
"value": "public",
"type": "Access"
},
{
"name": "jndi",
"value": "smid",
"type": "Jndi"
},
{
"name": "query",
"value": "SELECT\n \"dimension_empresa\".\"razon_social\"\nFROM\n \"dimension_empresa\" INNER JOIN \"hechos_bienesproducidos_empresa\" ON \"dimension_empresa\".\"id\" = \"hechos_bienesproducidos_empresa\".\"id_empresa\"\nGROUP BY\n \"dimension_empresa\".\"razon_social\"\nORDER BY\n 1 ASC",
"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": "5e18f0c2-f6ad-9c78-150d-fc43170bdf25",
"type": "Componentssql_sqlJndi",
"typeDesc": "sql over sqlJndi",
"parent": "SQL",
"properties": [
{
"name": "name",
"value": "PrincipalesProductos",
"type": "Id"
},
{
"name": "access",
"value": "public",
"type": "Access"
},
{
"name": "jndi",
"value": "smid",
"type": "Jndi"
},
{
"name": "query",
"value": "SELECT \n \"dimension_bien\".\"nombre\" AS Name,\n \"dimension_bien\".\"especificaciones_tecnicas\" as Tecn,\n round(sum(\"hechos_bienesproducidos_empresa\".\"medida_monto_venta\")::numeric,2) AS Total\nFROM\n \"dimension_bien\" INNER JOIN \"hechos_bienesproducidos_empresa\" ON \"dimension_bien\".\"id\" = \"hechos_bienesproducidos_empresa\".\"id_bien\"\n INNER JOIN \"dimension_empresa\" ON \"hechos_bienesproducidos_empresa\".\"id_empresa\" = \"dimension_empresa\".\"id\"\nWHERE\n dimension_empresa.rif LIKE ${seleccion}\n OR dimension_empresa.nombre LIKE ${seleccion}\n OR dimension_empresa.razon_social LIKE ${seleccion}\nGROUP BY\n Name,Tecn\nORDER BY\n Total DESC\nLIMIT 10",
"type": "SqlQuery"
},
{
"name": "parameters",
"value": "[[\"seleccion\",\"seleccion\",\"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": "a07fd7ed-d4dd-e031-6451-0d234e510b0a",
"type": "Componentssql_sqlJndi",
"typeDesc": "sql over sqlJndi",
"parent": "SQL",
"properties": [
{
"name": "name",
"value": "Info",
"type": "Id"
},
{
"name": "access",
"value": "public",
"type": "Access"
},
{
"name": "jndi",
"value": "smid",
"type": "Jndi"
},
{
"name": "query",
"value": "SELECT\n \"dimension_empresa\".\"rif\" || ' - ' || \"dimension_empresa\".\"razon_social\"\nFROM\n \"dimension_empresa\" \nWHERE\n dimension_empresa.rif LIKE ${seleccion}\n OR dimension_empresa.nombre LIKE ${seleccion}\n OR dimension_empresa.razon_social LIKE ${seleccion}",
"type": "SqlQuery"
},
{
"name": "parameters",
"value": "[[\"seleccion\",\"seleccion\",\"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 4.cdfde"
}