Changeset d13507c in intercambio
- Timestamp:
- Dec 9, 2013, 10:11:23 AM (10 years ago)
- Branches:
- master
- Children:
- 9d2557d
- Parents:
- eb4808c
- Location:
- Dashboards
- Files:
-
- 3 edited
Legend:
- Unmodified
- Added
- Removed
-
Dashboards/Cuadro 1.cda
rfccfcae rd13507c 94 94 estado 95 95 ORDER BY 96 total DESC</Query>96 total asc</Query> 97 97 </DataAccess> 98 98 <DataAccess access="public" cache="true" cacheDuration="3600" -
Dashboards/Cuadro 1.cdfde
r82f1086 rd13507c 2033 2033 }, 2034 2034 { 2035 "name": "expandParameters",2036 "value": "[]",2037 "type": "ValuesArray"2038 },2039 {2040 2035 "name": "colHeaders", 2041 2036 "value": "[\"CIIU\",\"Descripción\",\"Total Plantas\"]", … … 2068 2063 }, 2069 2064 { 2065 "name": "expandParameters", 2066 "value": "[]", 2067 "type": "ValuesArray" 2068 }, 2069 { 2070 "name": "paginate", 2071 "value": "true", 2072 "type": "Boolean" 2073 }, 2074 { 2075 "name": "displayLength", 2076 "value": "5", 2077 "type": "Integer" 2078 }, 2079 { 2080 "name": "lengthChange", 2081 "value": "false", 2082 "type": "Boolean" 2083 }, 2084 { 2085 "name": "filter", 2086 "value": "true", 2087 "type": "Boolean" 2088 }, 2089 { 2090 "name": "info", 2091 "value": "true", 2092 "type": "Boolean" 2093 }, 2094 { 2095 "name": "sort", 2096 "value": "true", 2097 "type": "Boolean" 2098 }, 2099 { 2070 2100 "name": "expandOnClick", 2071 2101 "value": "false", 2072 "type": "Boolean"2073 },2074 {2075 "name": "paginate",2076 "value": "true",2077 "type": "Boolean"2078 },2079 {2080 "name": "displayLength",2081 "value": "5",2082 "type": "Integer"2083 },2084 {2085 "name": "lengthChange",2086 "value": "false",2087 "type": "Boolean"2088 },2089 {2090 "name": "filter",2091 "value": "true",2092 "type": "Boolean"2093 },2094 {2095 "name": "info",2096 "value": "true",2097 "type": "Boolean"2098 },2099 {2100 "name": "sort",2101 "value": "true",2102 2102 "type": "Boolean" 2103 2103 }, … … 2118 2118 }, 2119 2119 { 2120 "name": "sortBy", 2121 "value": "[]", 2122 "type": "SortByArray" 2123 }, 2124 { 2120 2125 "name": "sDom", 2121 2126 "value": "", 2122 2127 "type": "JavaScript" 2123 },2124 {2125 "name": "sortBy",2126 "value": "[]",2127 "type": "SortByArray"2128 2128 }, 2129 2129 { … … 2231 2231 }, 2232 2232 { 2233 "name": "colSortable",2234 "value": "[]",2235 "type": "Array"2236 },2237 {2238 2233 "name": "parameters", 2239 2234 "value": "[[\"CIIU2\",\"CIIU2\"]]", … … 2266 2261 }, 2267 2262 { 2268 "name": " info",2269 "value": " false",2270 "type": " Boolean"2263 "name": "colSortable", 2264 "value": "[]", 2265 "type": "Array" 2271 2266 }, 2272 2267 { … … 2297 2292 { 2298 2293 "name": "filter", 2294 "value": "false", 2295 "type": "Boolean" 2296 }, 2297 { 2298 "name": "info", 2299 2299 "value": "false", 2300 2300 "type": "Boolean" … … 2316 2316 }, 2317 2317 { 2318 "name": "sDom", 2319 "value": "", 2320 "type": "JavaScript" 2321 }, 2322 { 2318 2323 "name": "sortBy", 2319 2324 "value": "[]", 2320 2325 "type": "SortByArray" 2321 },2322 {2323 "name": "sDom",2324 "value": "",2325 "type": "JavaScript"2326 2326 }, 2327 2327 { … … 3047 3047 }, 3048 3048 { 3049 "name": "width",3050 "value": "",3051 "type": "Integer"3052 },3053 {3054 3049 "name": "height", 3055 3050 "value": "400", 3051 "type": "Integer" 3052 }, 3053 { 3054 "name": "width", 3055 "value": "", 3056 3056 "type": "Integer" 3057 3057 }, … … 3528 3528 { 3529 3529 "name": "orientation", 3530 "value": " vertical",3530 "value": "horizontal", 3531 3531 "type": "cccOrientationCustom" 3532 3532 }, … … 4428 4428 { 4429 4429 "name": "query", 4430 "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 DESC",4430 "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", 4431 4431 "type": "SqlQuery" 4432 4432 }, -
Dashboards/Cuadro 2.cdfde
reb4808c rd13507c 2042 2042 }, 2043 2043 { 2044 "name": "colSortable", 2045 "value": "[]", 2046 "type": "Array" 2047 }, 2048 { 2049 "name": "parameters", 2050 "value": "[[\"Codigo\",\"Codigo\"]]", 2051 "type": "ValuesArray" 2052 }, 2053 { 2054 "name": "expandParameters", 2055 "value": "[]", 2056 "type": "ValuesArray" 2057 }, 2058 { 2059 "name": "colHeaders", 2060 "value": "[\"Código\",\"Descripción\",\"Total Empresas\"]", 2061 "type": "Array" 2062 }, 2063 { 2064 "name": "colTypes", 2065 "value": "[]", 2066 "type": "colTypesCustom" 2067 }, 2068 { 2069 "name": "colFormats", 2070 "value": "[]", 2071 "type": "Array" 2072 }, 2073 { 2044 2074 "name": "colWidths", 2045 2075 "value": "[\"20%\",\"60%\",\"10%\"]", … … 2047 2077 }, 2048 2078 { 2049 "name": " colSortable",2050 "value": " []",2051 "type": " Array"2052 }, 2053 { 2054 "name": " parameters",2055 "value": " [[\"Codigo\",\"Codigo\"]]",2056 "type": " ValuesArray"2057 }, 2058 { 2059 "name": "expand Parameters",2060 "value": " []",2061 "type": " ValuesArray"2062 }, 2063 { 2064 "name": " colHeaders",2065 "value": " [\"Código\",\"Descripción\",\"Total Empresas\"]",2066 "type": " Array"2067 }, 2068 { 2069 "name": " colTypes",2070 "value": " []",2071 "type": " colTypesCustom"2072 }, 2073 { 2074 "name": " colFormats",2075 "value": " []",2076 "type": " Array"2079 "name": "info", 2080 "value": "true", 2081 "type": "Boolean" 2082 }, 2083 { 2084 "name": "sort", 2085 "value": "true", 2086 "type": "Boolean" 2087 }, 2088 { 2089 "name": "expandOnClick", 2090 "value": "false", 2091 "type": "Boolean" 2092 }, 2093 { 2094 "name": "paginate", 2095 "value": "true", 2096 "type": "Boolean" 2097 }, 2098 { 2099 "name": "displayLength", 2100 "value": "4", 2101 "type": "Integer" 2102 }, 2103 { 2104 "name": "lengthChange", 2105 "value": "false", 2106 "type": "Boolean" 2077 2107 }, 2078 2108 { 2079 2109 "name": "filter", 2080 2110 "value": "true", 2081 "type": "Boolean"2082 },2083 {2084 "name": "info",2085 "value": "true",2086 "type": "Boolean"2087 },2088 {2089 "name": "sort",2090 "value": "true",2091 "type": "Boolean"2092 },2093 {2094 "name": "expandOnClick",2095 "value": "false",2096 "type": "Boolean"2097 },2098 {2099 "name": "paginate",2100 "value": "true",2101 "type": "Boolean"2102 },2103 {2104 "name": "displayLength",2105 "value": "4",2106 "type": "Integer"2107 },2108 {2109 "name": "lengthChange",2110 "value": "false",2111 2111 "type": "Boolean" 2112 2112 }, … … 2127 2127 }, 2128 2128 { 2129 "name": "sDom", 2130 "value": "", 2131 "type": "JavaScript" 2132 }, 2133 { 2129 2134 "name": "sortBy", 2130 2135 "value": "[]", … … 2132 2137 }, 2133 2138 { 2134 "name": "sDom",2135 "value": "",2136 "type": "JavaScript"2137 },2138 {2139 2139 "name": "refreshPeriod", 2140 2140 "value": "", … … 2208 2208 { 2209 2209 "name": "clickAction", 2210 "value": "function cod(a) {\n // alert(\"msg\"+a.series);\n alert(\"Seleccione año \");\n Dashboards.fireChange('cod',a.series);\n}",2210 "value": "function cod(a) {\n // alert(\"msg\"+a.series);\n alert(\"Seleccione año en la parte inferior de la tabla, para Visualizar los Montos de Ventas de las 10 Principales Empresas\");\n Dashboards.fireChange('cod',a.series);\n}", 2211 2211 "type": "JavaScript" 2212 2212 } … … 2488 2488 }, 2489 2489 { 2490 "name": "width",2491 "value": "",2492 "type": "Integer"2493 },2494 {2495 2490 "name": "height", 2496 2491 "value": "400", 2492 "type": "Integer" 2493 }, 2494 { 2495 "name": "width", 2496 "value": "", 2497 2497 "type": "Integer" 2498 2498 },
Note: See TracChangeset
for help on using the changeset viewer.