Changeset 65431d3 in intercambio
- Timestamp:
- Dec 5, 2013, 12:42:54 PM (10 years ago)
- Branches:
- master
- Children:
- eb4808c
- Parents:
- 82f1086
- Files:
-
- 2 added
- 4 edited
Legend:
- Unmodified
- Added
- Removed
-
Dashboards/Cuadro 2.cda
r82f1086 r65431d3 12 12 </Connection> 13 13 <Connection id="Ventas" type="sql.jndi"> 14 <Jndi>smid</Jndi> 15 </Connection> 16 <Connection id="sqlAnyo" type="sql.jndi"> 14 17 <Jndi>smid</Jndi> 15 18 </Connection> … … 72 75 <Parameters> 73 76 <Parameter default="cod" name="cod" type="String"/> 77 <Parameter default="anyo" name="anyo" type="String"/> 74 78 </Parameters> 75 79 <Query>(SELECT … … 79 83 "dimension_codigoarancelario" INNER JOIN "hechos_bienesproducidos_empresa" ON "dimension_codigoarancelario"."id" = "hechos_bienesproducidos_empresa"."id_codigo_arancelario" 80 84 INNER JOIN "dimension_empresa" ON "hechos_bienesproducidos_empresa"."id_empresa" = "dimension_empresa"."id" 85 INNER JOIN "dimension_tiempo" ON "hechos_bienesproducidos_empresa"."id_itempo" = "dimension_tiempo"."id" 81 86 WHERE 82 87 dimension_codigoarancelario.codigo LIKE ${cod} 88 AND CAST(dimension_tiempo.anyo AS text) = ${anyo} 83 89 GROUP BY 84 90 Empresa … … 92 98 "dimension_codigoarancelario" INNER JOIN "hechos_bienesproducidos_empresa" ON "dimension_codigoarancelario"."id" = "hechos_bienesproducidos_empresa"."id_codigo_arancelario" 93 99 INNER JOIN "dimension_empresa" ON "hechos_bienesproducidos_empresa"."id_empresa" = "dimension_empresa"."id" 100 INNER JOIN "dimension_tiempo" ON "hechos_bienesproducidos_empresa"."id_itempo" = "dimension_tiempo"."id" 94 101 WHERE 95 dimension_codigoarancelario.codigo LIKE ${cod} anddimension_empresa.id not in (102 dimension_codigoarancelario.codigo LIKE ${cod} AND CAST(dimension_tiempo.anyo AS text) = ${anyo} AND dimension_empresa.id not in ( 96 103 SELECT 97 104 "hechos_bienesproducidos_empresa"."id_empresa" … … 99 106 "dimension_codigoarancelario" INNER JOIN "hechos_bienesproducidos_empresa" ON "dimension_codigoarancelario"."id" = "hechos_bienesproducidos_empresa"."id_codigo_arancelario" 100 107 INNER JOIN "dimension_empresa" ON "hechos_bienesproducidos_empresa"."id_empresa" = "dimension_empresa"."id" 108 INNER JOIN "dimension_tiempo" ON "hechos_bienesproducidos_empresa"."id_itempo" = "dimension_tiempo"."id" 101 109 WHERE 102 110 dimension_codigoarancelario.codigo LIKE ${cod} 111 AND CAST(dimension_tiempo.anyo AS text) = ${anyo} 103 112 GROUP BY 1 104 113 ) 105 ORDER BY Monto DESC)</Query> 114 ORDER BY Monto DESC) 115 ORDER BY 2 DESC</Query> 116 </DataAccess> 117 <DataAccess access="public" cache="true" cacheDuration="3600" connection="sqlAnyo" 118 id="sqlAnyo" 119 type="sql"> 120 <Columns/> 121 <Parameters> 122 <Parameter default="cod" name="cod" type="String"/> 123 </Parameters> 124 <Query>(SELECT '--Seleccione--') 125 UNION 126 (SELECT 127 CAST(dimension_tiempo.anyo AS text) as anyo 128 FROM 129 "dimension_codigoarancelario" INNER JOIN "hechos_bienesproducidos_empresa" ON "dimension_codigoarancelario"."id" = "hechos_bienesproducidos_empresa"."id_codigo_arancelario" 130 INNER JOIN "dimension_tiempo" ON "hechos_bienesproducidos_empresa"."id_itempo" = "dimension_tiempo"."id" 131 WHERE 132 dimension_codigoarancelario.codigo LIKE ${cod} 133 GROUP BY 134 anyo) 135 ORDER BY 1 desc</Query> 106 136 </DataAccess> 107 137 </CDADescriptor> -
Dashboards/Cuadro 2.cdfde
r82f1086 r65431d3 705 705 "name": "columnSpan", 706 706 "type": "Integer", 707 "value": " 10"707 "value": "22" 708 708 }, 709 709 { … … 740 740 "name": "height", 741 741 "type": "Integer", 742 "value": " 650"742 "value": "" 743 743 }, 744 744 { … … 958 958 }, 959 959 { 960 "id": "b54ff9f1-06c7-8bb0-dba7-6b6d4b588161", 960 "id": "0c44c2f0-ec10-22e0-98b2-b156ce2e1d58", 961 "type": "LayoutSpace", 962 "typeDesc": "Space", 963 "parent": "80ee452e-ec84-f906-5977-f16e9be4ccd4", 964 "properties": [ 965 { 966 "name": "height", 967 "value": "", 968 "type": "Integer" 969 }, 970 { 971 "name": "backgroundColor", 972 "value": "", 973 "type": "Color" 974 }, 975 { 976 "name": "cssClass", 977 "value": "", 978 "type": "String" 979 } 980 ] 981 }, 982 { 983 "id": "891265c6-0704-f2be-82e4-9e41ddd5339d", 984 "type": "LayoutRow", 985 "typeDesc": "Row", 986 "parent": "80ee452e-ec84-f906-5977-f16e9be4ccd4", 987 "properties": [ 988 { 989 "name": "name", 990 "value": "", 991 "type": "Id" 992 }, 993 { 994 "name": "height", 995 "value": "220", 996 "type": "Integer" 997 }, 998 { 999 "name": "backgroundColor", 1000 "value": "", 1001 "type": "Color" 1002 }, 1003 { 1004 "name": "roundCorners", 1005 "value": "", 1006 "type": "RoundCorners" 1007 }, 1008 { 1009 "name": "textAlign", 1010 "value": "", 1011 "type": "TextAlign" 1012 }, 1013 { 1014 "name": "cssClass", 1015 "value": "", 1016 "type": "String" 1017 } 1018 ] 1019 }, 1020 { 1021 "id": "2158506a-2a8c-d3ef-bebe-b942ffa89118", 961 1022 "type": "LayoutColumn", 962 1023 "typeDesc": "Column", 963 "parent": " 1b5b2440-ad57-d50a-f6aa-d96f9b209626",964 "properties": [ 965 { 966 "name": "name", 967 " type": "Id",968 " value": "Panel_2"1024 "parent": "891265c6-0704-f2be-82e4-9e41ddd5339d", 1025 "properties": [ 1026 { 1027 "name": "name", 1028 "value": "", 1029 "type": "Id" 969 1030 }, 970 1031 { 971 1032 "name": "columnSpan", 972 " type": "Integer",973 " value": "10"1033 "value": "22", 1034 "type": "Integer" 974 1035 }, 975 1036 { 976 1037 "name": "columnPrepend", 977 " type": "Integer",978 " value": "1"1038 "value": "1", 1039 "type": "Integer" 979 1040 }, 980 1041 { 981 1042 "name": "columnAppend", 982 " type": "Integer",983 " value": "1"1043 "value": "1", 1044 "type": "Integer" 984 1045 }, 985 1046 { 986 1047 "name": "columnPrependTop", 987 " type": "Boolean",988 " value": false1048 "value": "false", 1049 "type": "Boolean" 989 1050 }, 990 1051 { 991 1052 "name": "columnAppendBottom", 992 " type": "Boolean",993 " value": false1053 "value": "false", 1054 "type": "Boolean" 994 1055 }, 995 1056 { 996 1057 "name": "columnBorder", 997 " type": "Boolean",998 " value": false1058 "value": "false", 1059 "type": "Boolean" 999 1060 }, 1000 1061 { 1001 1062 "name": "columnBigBorder", 1002 " type": "Boolean",1003 " value": false1063 "value": "false", 1064 "type": "Boolean" 1004 1065 }, 1005 1066 { 1006 1067 "name": "height", 1007 " type": "Integer",1008 " value": "650"1068 "value": "", 1069 "type": "Integer" 1009 1070 }, 1010 1071 { 1011 1072 "name": "backgroundColor", 1012 " type": "Color",1013 " value": "#e0e0e0"1073 "value": "#e0e0e0", 1074 "type": "Color" 1014 1075 }, 1015 1076 { 1016 1077 "name": "roundCorners", 1017 "type": "RoundCorners", 1018 "value": "cdfdd-round" 1019 }, 1020 { 1021 "name": "textAlign", 1022 "type": "TextAlign", 1023 "value": "" 1024 }, 1025 { 1026 "name": "cssClass", 1027 "type": "String", 1028 "value": "" 1029 } 1030 ] 1031 }, 1032 { 1033 "id": "4b9cb2ca-5fcb-318b-37db-fafb0bd9ce82", 1034 "type": "LayoutSpace", 1035 "typeDesc": "Space", 1036 "parent": "b54ff9f1-06c7-8bb0-dba7-6b6d4b588161", 1037 "properties": [ 1038 { 1039 "name": "height", 1040 "value": "", 1041 "type": "Integer" 1042 }, 1043 { 1044 "name": "backgroundColor", 1045 "value": "", 1046 "type": "Color" 1047 }, 1048 { 1049 "name": "cssClass", 1050 "value": "", 1051 "type": "String" 1052 } 1053 ] 1054 }, 1055 { 1056 "id": "97f7aa77-9005-ce4c-ad21-eb4417d3c1e2", 1057 "type": "LayoutRow", 1058 "typeDesc": "Row", 1059 "parent": "b54ff9f1-06c7-8bb0-dba7-6b6d4b588161", 1060 "properties": [ 1061 { 1062 "name": "name", 1063 "value": "BotonG", 1064 "type": "Id" 1065 }, 1066 { 1067 "name": "height", 1068 "value": "", 1069 "type": "Integer" 1070 }, 1071 { 1072 "name": "backgroundColor", 1073 "value": "", 1074 "type": "Color" 1075 }, 1076 { 1077 "name": "roundCorners", 1078 "value": "", 1078 "value": "cdfdd-round", 1079 1079 "type": "RoundCorners" 1080 1080 }, … … 1092 1092 }, 1093 1093 { 1094 "id": " 945396fb-81a3-b67b-7aaf-b0d1e5f3e587",1094 "id": "6c34005e-65a3-0ccb-65f2-706b1022d419", 1095 1095 "type": "LayoutSpace", 1096 1096 "typeDesc": "Space", 1097 "parent": " b54ff9f1-06c7-8bb0-dba7-6b6d4b588161",1097 "parent": "2158506a-2a8c-d3ef-bebe-b942ffa89118", 1098 1098 "properties": [ 1099 1099 { 1100 1100 "name": "height", 1101 "value": " ",1101 "value": "5", 1102 1102 "type": "Integer" 1103 1103 }, … … 1115 1115 }, 1116 1116 { 1117 "id": " bf07b6e5-19f8-4336-cda2-07727a2b1d11",1117 "id": "64ce17c7-43d5-b105-2c81-34a6fda368ea", 1118 1118 "type": "LayoutRow", 1119 1119 "typeDesc": "Row", 1120 "parent": "b54ff9f1-06c7-8bb0-dba7-6b6d4b588161", 1120 "parent": "2158506a-2a8c-d3ef-bebe-b942ffa89118", 1121 "properties": [ 1122 { 1123 "name": "name", 1124 "value": "BotonG", 1125 "type": "Id" 1126 }, 1127 { 1128 "name": "height", 1129 "value": "", 1130 "type": "Integer" 1131 }, 1132 { 1133 "name": "backgroundColor", 1134 "value": "", 1135 "type": "Color" 1136 }, 1137 { 1138 "name": "roundCorners", 1139 "value": "", 1140 "type": "RoundCorners" 1141 }, 1142 { 1143 "name": "textAlign", 1144 "value": "", 1145 "type": "TextAlign" 1146 }, 1147 { 1148 "name": "cssClass", 1149 "value": "", 1150 "type": "String" 1151 } 1152 ] 1153 }, 1154 { 1155 "id": "44346fc8-bdd2-3afc-ae1f-c9fb664b5235", 1156 "type": "LayoutSpace", 1157 "typeDesc": "Space", 1158 "parent": "2158506a-2a8c-d3ef-bebe-b942ffa89118", 1159 "properties": [ 1160 { 1161 "name": "height", 1162 "value": "5", 1163 "type": "Integer" 1164 }, 1165 { 1166 "name": "backgroundColor", 1167 "value": "", 1168 "type": "Color" 1169 }, 1170 { 1171 "name": "cssClass", 1172 "value": "", 1173 "type": "String" 1174 } 1175 ] 1176 }, 1177 { 1178 "id": "449ae86d-9f70-2e95-4fc5-cd52bca338a6", 1179 "type": "LayoutRow", 1180 "typeDesc": "Row", 1181 "parent": "2158506a-2a8c-d3ef-bebe-b942ffa89118", 1182 "properties": [ 1183 { 1184 "name": "name", 1185 "value": "", 1186 "type": "Id" 1187 }, 1188 { 1189 "name": "height", 1190 "value": "", 1191 "type": "Integer" 1192 }, 1193 { 1194 "name": "backgroundColor", 1195 "value": "", 1196 "type": "Color" 1197 }, 1198 { 1199 "name": "roundCorners", 1200 "value": "", 1201 "type": "RoundCorners" 1202 }, 1203 { 1204 "name": "textAlign", 1205 "value": "", 1206 "type": "TextAlign" 1207 }, 1208 { 1209 "name": "cssClass", 1210 "value": "", 1211 "type": "String" 1212 } 1213 ] 1214 }, 1215 { 1216 "id": "2bdbc406-2aa7-9f19-10eb-9eb721b0e9ce", 1217 "type": "LayoutHtml", 1218 "typeDesc": "Html", 1219 "parent": "449ae86d-9f70-2e95-4fc5-cd52bca338a6", 1220 "properties": [ 1221 { 1222 "name": "name", 1223 "value": "", 1224 "type": "Id" 1225 }, 1226 { 1227 "name": "html", 1228 "value": "<h4 style=\"color:#606060;\" >Seleccionar Año:</h4> ", 1229 "type": "Html" 1230 }, 1231 { 1232 "name": "fontSize", 1233 "value": "", 1234 "type": "Integer" 1235 }, 1236 { 1237 "name": "color", 1238 "value": "", 1239 "type": "Color" 1240 }, 1241 { 1242 "name": "cssClass", 1243 "value": "", 1244 "type": "String" 1245 } 1246 ] 1247 }, 1248 { 1249 "id": "dbea44a9-d4b2-2b12-5596-d3da84b5011e", 1250 "type": "LayoutRow", 1251 "typeDesc": "Row", 1252 "parent": "2158506a-2a8c-d3ef-bebe-b942ffa89118", 1253 "properties": [ 1254 { 1255 "name": "name", 1256 "value": "SelectAnyo", 1257 "type": "Id" 1258 }, 1259 { 1260 "name": "height", 1261 "value": "", 1262 "type": "Integer" 1263 }, 1264 { 1265 "name": "backgroundColor", 1266 "value": "", 1267 "type": "Color" 1268 }, 1269 { 1270 "name": "roundCorners", 1271 "value": "", 1272 "type": "RoundCorners" 1273 }, 1274 { 1275 "name": "textAlign", 1276 "value": "center", 1277 "type": "TextAlign" 1278 }, 1279 { 1280 "name": "cssClass", 1281 "value": "", 1282 "type": "String" 1283 } 1284 ] 1285 }, 1286 { 1287 "id": "df6a6123-cf1a-1bc9-cd76-a5edd62ec8f1", 1288 "type": "LayoutSpace", 1289 "typeDesc": "Space", 1290 "parent": "2158506a-2a8c-d3ef-bebe-b942ffa89118", 1291 "properties": [ 1292 { 1293 "name": "height", 1294 "value": "", 1295 "type": "Integer" 1296 }, 1297 { 1298 "name": "backgroundColor", 1299 "value": "", 1300 "type": "Color" 1301 }, 1302 { 1303 "name": "cssClass", 1304 "value": "", 1305 "type": "String" 1306 } 1307 ] 1308 }, 1309 { 1310 "id": "f534163a-f037-eb71-27d2-9c675378c869", 1311 "type": "LayoutRow", 1312 "typeDesc": "Row", 1313 "parent": "2158506a-2a8c-d3ef-bebe-b942ffa89118", 1121 1314 "properties": [ 1122 1315 { … … 1127 1320 { 1128 1321 "name": "height", 1129 "value": " 550",1322 "value": "", 1130 1323 "type": "Integer" 1131 1324 }, … … 1608 1801 }, 1609 1802 { 1803 "id": "ff5fbd4a-65a4-88da-a592-1c30d32138d4", 1804 "type": "ComponentsSelect", 1805 "typeDesc": "Select Component", 1806 "parent": "SELECTORS", 1807 "properties": [ 1808 { 1809 "name": "name", 1810 "value": "ddlAnyo", 1811 "type": "Id" 1812 }, 1813 { 1814 "name": "parameter", 1815 "value": "${p:anyo}", 1816 "type": "Parameter" 1817 }, 1818 { 1819 "name": "listeners", 1820 "value": "['${p:cod}']", 1821 "type": "Listeners" 1822 }, 1823 { 1824 "name": "parameters", 1825 "value": "[[\"cod\",\"cod\"]]", 1826 "type": "ValuesArray" 1827 }, 1828 { 1829 "name": "valueAsId", 1830 "value": "true", 1831 "type": "Boolean" 1832 }, 1833 { 1834 "name": "externalPlugin", 1835 "value": "", 1836 "type": "String" 1837 }, 1838 { 1839 "name": "dataSource", 1840 "value": "sqlAnyo", 1841 "type": "Datasource" 1842 }, 1843 { 1844 "name": "valuesArray", 1845 "value": "[]", 1846 "type": "ValuesArray" 1847 }, 1848 { 1849 "name": "priority", 1850 "value": 5, 1851 "type": "Integer" 1852 }, 1853 { 1854 "name": "refreshPeriod", 1855 "value": "", 1856 "type": "Integer" 1857 }, 1858 { 1859 "name": "htmlObject", 1860 "value": "SelectAnyo", 1861 "type": "HtmlObject" 1862 }, 1863 { 1864 "name": "executeAtStart", 1865 "value": "true", 1866 "type": "Boolean" 1867 }, 1868 { 1869 "name": "preExecution", 1870 "value": "", 1871 "type": "JavaScript" 1872 }, 1873 { 1874 "name": "postExecution", 1875 "value": "", 1876 "type": "JavaScript" 1877 }, 1878 { 1879 "name": "postFetch", 1880 "value": "", 1881 "type": "JavaScript" 1882 }, 1883 { 1884 "name": "preChange", 1885 "value": "", 1886 "type": "JavaScript" 1887 }, 1888 { 1889 "name": "postChange", 1890 "value": "function Producto() {\n //alert(\"msg\"+a.series);\n Dashboards.fireChange('anyo','0');\n}", 1891 "type": "JavaScript" 1892 }, 1893 { 1894 "name": "tooltip", 1895 "value": "", 1896 "type": "Html" 1897 }, 1898 { 1899 "name": "extraOptions", 1900 "value": "[]", 1901 "type": "OptionArray" 1902 } 1903 ] 1904 }, 1905 { 1610 1906 "id": "GENERIC", 1611 1907 "name": "Generic", … … 1678 1974 }, 1679 1975 { 1976 "id": "d477be50-ae55-eb34-b3ee-cd12ee76ed4c", 1977 "type": "ComponentsParameter", 1978 "typeDesc": "Simple parameter", 1979 "parent": "GENERIC", 1980 "properties": [ 1981 { 1982 "name": "name", 1983 "value": "anyo", 1984 "type": "Id" 1985 }, 1986 { 1987 "name": "propertyValue", 1988 "value": "anyo", 1989 "type": "String" 1990 }, 1991 { 1992 "name": "parameterViewRole", 1993 "value": "unused", 1994 "type": "parameterViewRoleCustom" 1995 }, 1996 { 1997 "name": "bookmarkable", 1998 "value": "false", 1999 "type": "Boolean" 2000 } 2001 ] 2002 }, 2003 { 1680 2004 "id": "OTHERCOMPONENTS", 1681 2005 "name": "Others", … … 1714 2038 { 1715 2039 "name": "oLanguage", 1716 "value": "", 1717 "type": "JavaScript" 2040 "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}", 2041 "type": "JavaScript" 2042 }, 2043 { 2044 "name": "colWidths", 2045 "value": "[\"20%\",\"60%\",\"10%\"]", 2046 "type": "Array" 2047 }, 2048 { 2049 "name": "colSortable", 2050 "value": "[]", 2051 "type": "Array" 2052 }, 2053 { 2054 "name": "parameters", 2055 "value": "[[\"Codigo\",\"Codigo\"]]", 2056 "type": "ValuesArray" 2057 }, 2058 { 2059 "name": "expandParameters", 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" 1718 2072 }, 1719 2073 { … … 1723 2077 }, 1724 2078 { 1725 "name": " colWidths",1726 "value": " [\"20%\",\"60%\",\"10%\"]",1727 "type": " Array"1728 }, 1729 { 1730 "name": " colSortable",1731 "value": " []",1732 "type": " Array"1733 }, 1734 { 1735 "name": " parameters",1736 "value": " [[\"Codigo\",\"Codigo\"]]",1737 "type": " ValuesArray"1738 }, 1739 { 1740 "name": "expand Parameters",1741 "value": " []",1742 "type": " ValuesArray"1743 }, 1744 { 1745 "name": " colHeaders",1746 "value": " [\"Código\",\"Descripción\",\"Total Empresas\"]",1747 "type": " Array"1748 }, 1749 { 1750 "name": " colTypes",1751 "value": " []",1752 "type": " colTypesCustom"2079 "name": "filter", 2080 "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" 1753 2107 }, 1754 2108 { … … 1756 2110 "value": "false", 1757 2111 "type": "Boolean" 1758 },1759 {1760 "name": "filter",1761 "value": "true",1762 "type": "Boolean"1763 },1764 {1765 "name": "info",1766 "value": "true",1767 "type": "Boolean"1768 },1769 {1770 "name": "sort",1771 "value": "true",1772 "type": "Boolean"1773 },1774 {1775 "name": "expandOnClick",1776 "value": "false",1777 "type": "Boolean"1778 },1779 {1780 "name": "paginate",1781 "value": "true",1782 "type": "Boolean"1783 },1784 {1785 "name": "displayLength",1786 "value": "4",1787 "type": "Integer"1788 2112 }, 1789 2113 { … … 1803 2127 }, 1804 2128 { 1805 "name": "sDom",1806 "value": "",1807 "type": "JavaScript"1808 },1809 {1810 2129 "name": "sortBy", 1811 2130 "value": "[]", … … 1813 2132 }, 1814 2133 { 2134 "name": "sDom", 2135 "value": "", 2136 "type": "JavaScript" 2137 }, 2138 { 1815 2139 "name": "refreshPeriod", 1816 2140 "value": "", … … 1849 2173 { 1850 2174 "name": "preExecution", 1851 "value": " ",2175 "value": "function f() {\n$('.dataBarContainer a').each(function(k,v) {\nvar value = sprintf('%.2f',$(this).attr('title').substr($(this).attr('title').indexOf(':')+1));\n$(this).attr('title', value); \n});\n}", 1852 2176 "type": "JavaScript" 1853 2177 }, … … 1874 2198 { 1875 2199 "name": "tooltip", 1876 "value": " ",2200 "value": "Seleccionar Código Arancelario ", 1877 2201 "type": "Html" 1878 2202 }, … … 2145 2469 { 2146 2470 "name": "listeners", 2147 "value": "['${p:cod}' ]",2471 "value": "['${p:cod}','${p:anyo}']", 2148 2472 "type": "Listeners" 2149 2473 }, … … 2155 2479 { 2156 2480 "name": "parameters", 2157 "value": "[[\"cod\",\"cod\"] ]",2481 "value": "[[\"cod\",\"cod\"],[\"anyo\",\"anyo\"]]", 2158 2482 "type": "ValuesArray" 2159 2483 }, … … 2164 2488 }, 2165 2489 { 2490 "name": "width", 2491 "value": "", 2492 "type": "Integer" 2493 }, 2494 { 2166 2495 "name": "height", 2167 "value": "550", 2168 "type": "Integer" 2169 }, 2170 { 2171 "name": "width", 2172 "value": "", 2496 "value": "400", 2173 2497 "type": "Integer" 2174 2498 }, … … 2840 3164 { 2841 3165 "name": "orthoAxisSize", 2842 "value": " ",3166 "value": "-", 2843 3167 "type": "String" 2844 3168 }, … … 2995 3319 { 2996 3320 "name": "plot2ValuesFont", 2997 "value": "1 0px sans-serif",3321 "value": "12px sans-serif", 2998 3322 "type": "String" 2999 3323 }, … … 3075 3399 { 3076 3400 "name": "smallTitleFont", 3077 "value": "1 4px sans-serif",3401 "value": "12px sans-serif", 3078 3402 "type": "String" 3079 3403 }, … … 3130 3454 { 3131 3455 "name": "titleFont", 3132 "value": "1 4px sans-serif",3456 "value": "12px sans-serif", 3133 3457 "type": "String" 3134 3458 }, … … 3255 3579 { 3256 3580 "name": "trendValuesFont", 3257 "value": "1 0px sans-serif",3581 "value": "12px sans-serif", 3258 3582 "type": "String" 3259 3583 }, … … 3523 3847 }, 3524 3848 { 3849 "id": "9ff42054-4d5d-557f-2c52-dc9e928ad75c", 3850 "type": "Componentssql_sqlJndi", 3851 "typeDesc": "sql over sqlJndi", 3852 "parent": "SQL", 3853 "properties": [ 3854 { 3855 "name": "name", 3856 "value": "Ventas", 3857 "type": "Id" 3858 }, 3859 { 3860 "name": "access", 3861 "value": "public", 3862 "type": "Access" 3863 }, 3864 { 3865 "name": "jndi", 3866 "value": "smid", 3867 "type": "Jndi" 3868 }, 3869 { 3870 "name": "query", 3871 "value": "(SELECT\n \"dimension_empresa\".\"razon_social\" AS Empresa,\n sum(\"hechos_bienesproducidos_empresa\".\"medida_monto_venta\") AS Monto\nFROM\n \"dimension_codigoarancelario\" INNER JOIN \"hechos_bienesproducidos_empresa\" ON \"dimension_codigoarancelario\".\"id\" = \"hechos_bienesproducidos_empresa\".\"id_codigo_arancelario\"\n INNER JOIN \"dimension_empresa\" ON \"hechos_bienesproducidos_empresa\".\"id_empresa\" = \"dimension_empresa\".\"id\"\n INNER JOIN \"dimension_tiempo\" ON \"hechos_bienesproducidos_empresa\".\"id_itempo\" = \"dimension_tiempo\".\"id\"\nWHERE\n dimension_codigoarancelario.codigo LIKE ${cod}\n AND CAST(dimension_tiempo.anyo AS text) = ${anyo}\nGROUP BY\n Empresa\nORDER BY Monto DESC\nLIMIT 10)\nUNION\n(SELECT \n 'Otras Empresas' as Empresa,\n sum(\"hechos_bienesproducidos_empresa\".\"medida_monto_venta\") as Monto \nFROM\n \"dimension_codigoarancelario\" INNER JOIN \"hechos_bienesproducidos_empresa\" ON \"dimension_codigoarancelario\".\"id\" = \"hechos_bienesproducidos_empresa\".\"id_codigo_arancelario\"\n INNER JOIN \"dimension_empresa\" ON \"hechos_bienesproducidos_empresa\".\"id_empresa\" = \"dimension_empresa\".\"id\"\n INNER JOIN \"dimension_tiempo\" ON \"hechos_bienesproducidos_empresa\".\"id_itempo\" = \"dimension_tiempo\".\"id\"\nWHERE\n dimension_codigoarancelario.codigo LIKE ${cod} AND CAST(dimension_tiempo.anyo AS text) = ${anyo} AND dimension_empresa.id not in (\n SELECT\n \"hechos_bienesproducidos_empresa\".\"id_empresa\" \nFROM\n \"dimension_codigoarancelario\" INNER JOIN \"hechos_bienesproducidos_empresa\" ON \"dimension_codigoarancelario\".\"id\" = \"hechos_bienesproducidos_empresa\".\"id_codigo_arancelario\"\n INNER JOIN \"dimension_empresa\" ON \"hechos_bienesproducidos_empresa\".\"id_empresa\" = \"dimension_empresa\".\"id\"\n INNER JOIN \"dimension_tiempo\" ON \"hechos_bienesproducidos_empresa\".\"id_itempo\" = \"dimension_tiempo\".\"id\"\nWHERE\n dimension_codigoarancelario.codigo LIKE ${cod}\n AND CAST(dimension_tiempo.anyo AS text) = ${anyo}\nGROUP BY 1 \n )\nORDER BY Monto DESC) \nORDER BY 2 DESC \n", 3872 "type": "SqlQuery" 3873 }, 3874 { 3875 "name": "parameters", 3876 "value": "[[\"cod\",\"cod\",\"String\",\"\"],[\"anyo\",\"anyo\",\"String\",\"\"]]", 3877 "type": "CdaParameters" 3878 }, 3879 { 3880 "name": "outputMode", 3881 "value": "include", 3882 "type": "OutputMode" 3883 }, 3884 { 3885 "name": "cdacolumns", 3886 "value": "[]", 3887 "type": "CdaColumnsArray" 3888 }, 3889 { 3890 "name": "cdacalculatedcolumns", 3891 "value": "[]", 3892 "type": "CdaCalculatedColumnsArray" 3893 }, 3894 { 3895 "name": "output", 3896 "value": "[]", 3897 "type": "IndexArray" 3898 }, 3899 { 3900 "name": "cacheDuration", 3901 "value": 3600, 3902 "type": "Integer" 3903 }, 3904 { 3905 "name": "cache", 3906 "value": "true", 3907 "type": "Boolean" 3908 } 3909 ], 3910 "meta": "CDA", 3911 "meta_conntype": "sql.jndi", 3912 "meta_datype": "sql" 3913 }, 3914 { 3525 3915 "id": "546211ef-c107-b90f-1585-1a4f5830ab63", 3526 3916 "type": "Componentssql_sqlJndi", … … 3530 3920 { 3531 3921 "name": "name", 3532 "value": " Ventas",3922 "value": "sqlAnyo", 3533 3923 "type": "Id" 3534 3924 }, … … 3545 3935 { 3546 3936 "name": "query", 3547 "value": "(SELECT \n \"dimension_empresa\".\"razon_social\" AS Empresa,\n sum(\"hechos_bienesproducidos_empresa\".\"medida_monto_venta\") AS Monto\nFROM\n \"dimension_codigoarancelario\" INNER JOIN \"hechos_bienesproducidos_empresa\" ON \"dimension_codigoarancelario\".\"id\" = \"hechos_bienesproducidos_empresa\".\"id_codigo_arancelario\"\n INNER JOIN \"dimension_empresa\" ON \"hechos_bienesproducidos_empresa\".\"id_empresa\" = \"dimension_empresa\".\"id\"\nWHERE\n dimension_codigoarancelario.codigo LIKE ${cod}\nGROUP BY\n Empresa\nORDER BY Monto DESC\nLIMIT 10)\nUNION\n(SELECT \n 'Otras Empresas' as Empresa,\n sum(\"hechos_bienesproducidos_empresa\".\"medida_monto_venta\") as Monto \nFROM\n \"dimension_codigoarancelario\" INNER JOIN \"hechos_bienesproducidos_empresa\" ON \"dimension_codigoarancelario\".\"id\" = \"hechos_bienesproducidos_empresa\".\"id_codigo_arancelario\"\n INNER JOIN \"dimension_empresa\" ON \"hechos_bienesproducidos_empresa\".\"id_empresa\" = \"dimension_empresa\".\"id\"\nWHERE\n dimension_codigoarancelario.codigo LIKE ${cod} and dimension_empresa.id not in (\n SELECT\n \"hechos_bienesproducidos_empresa\".\"id_empresa\" \nFROM\n \"dimension_codigoarancelario\" INNER JOIN \"hechos_bienesproducidos_empresa\" ON \"dimension_codigoarancelario\".\"id\" = \"hechos_bienesproducidos_empresa\".\"id_codigo_arancelario\"\n INNER JOIN \"dimension_empresa\" ON \"hechos_bienesproducidos_empresa\".\"id_empresa\" = \"dimension_empresa\".\"id\"\nWHERE\n dimension_codigoarancelario.codigo LIKE ${cod}\nGROUP BY 1 \n )\nORDER BY Monto DESC) \n",3937 "value": "(SELECT '--Seleccione--')\nUNION\n(SELECT\n CAST(dimension_tiempo.anyo AS text) as anyo\nFROM\n \"dimension_codigoarancelario\" INNER JOIN \"hechos_bienesproducidos_empresa\" ON \"dimension_codigoarancelario\".\"id\" = \"hechos_bienesproducidos_empresa\".\"id_codigo_arancelario\"\n INNER JOIN \"dimension_tiempo\" ON \"hechos_bienesproducidos_empresa\".\"id_itempo\" = \"dimension_tiempo\".\"id\"\nWHERE\n dimension_codigoarancelario.codigo LIKE ${cod}\nGROUP BY\n anyo)\nORDER BY 1 desc\n ", 3548 3938 "type": "SqlQuery" 3549 3939 }, -
Dashboards/Cuadro 4_tmp.cdfde
r82f1086 r65431d3 3527 3527 }, 3528 3528 { 3529 "name": "colTypes", 3530 "value": "[]", 3531 "type": "colTypesCustom", 3532 "description": "Column Types", 3533 "tooltip": "The table column types", 3534 "order": 40, 3535 "classType": "" 3536 }, 3537 { 3538 "name": "colFormats", 3539 "value": "[]", 3540 "type": "Array", 3541 "description": "Column Formats", 3542 "tooltip": "The table column formats", 3543 "order": 40, 3544 "classType": "advanced" 3545 }, 3546 { 3547 "name": "colWidths", 3548 "value": "[\"40%\",\"50%\",\"10%\"]", 3549 "type": "Array", 3550 "description": "Column Widths", 3551 "tooltip": "The table widths", 3552 "order": 40, 3553 "classType": "advanced" 3554 }, 3555 { 3556 "name": "colSortable", 3557 "value": "[]", 3558 "type": "Array", 3559 "description": "Sortable Column", 3560 "tooltip": "Is the column sortable? Example: [true,false]", 3561 "order": 40, 3562 "classType": "advanced" 3563 }, 3564 { 3565 "name": "parameters", 3566 "value": "[[\"seleccion\",\"seleccion\"]]", 3567 "type": "ValuesArray", 3568 "description": "Parameters", 3569 "tooltip": " Parameters to pass to the component", 3570 "order": 40, 3571 "classType": "" 3572 }, 3573 { 3574 "name": "expandParameters", 3575 "value": "[]", 3576 "type": "ValuesArray", 3577 "description": "Expand Parameters", 3578 "tooltip": " Expand Parameters - arg is column id, value is parameter name to change with column value", 3579 "order": 40, 3580 "classType": "advanced" 3581 }, 3582 { 3529 3583 "name": "colHeaders", 3530 3584 "value": "[\"Producto\",\"Especificaciones Técnicas\",\"Monto de Venta\"]", … … 3536 3590 }, 3537 3591 { 3538 "name": "colTypes",3539 "value": "[]",3540 "type": "colTypesCustom",3541 "description": "Column Types",3542 "tooltip": "The table column types",3543 "order": 40,3544 "classType": ""3545 },3546 {3547 "name": "colFormats",3548 "value": "[]",3549 "type": "Array",3550 "description": "Column Formats",3551 "tooltip": "The table column formats",3552 "order": 40,3553 "classType": "advanced"3554 },3555 {3556 "name": "colWidths",3557 "value": "[\"40%\",\"50%\",\"10%\"]",3558 "type": "Array",3559 "description": "Column Widths",3560 "tooltip": "The table widths",3561 "order": 40,3562 "classType": "advanced"3563 },3564 {3565 "name": "colSortable",3566 "value": "[]",3567 "type": "Array",3568 "description": "Sortable Column",3569 "tooltip": "Is the column sortable? Example: [true,false]",3570 "order": 40,3571 "classType": "advanced"3572 },3573 {3574 "name": "parameters",3575 "value": "[[\"seleccion\",\"seleccion\"]]",3576 "type": "ValuesArray",3577 "description": "Parameters",3578 "tooltip": " Parameters to pass to the component",3579 "order": 40,3580 "classType": ""3581 },3582 {3583 "name": "expandParameters",3584 "value": "[]",3585 "type": "ValuesArray",3586 "description": "Expand Parameters",3587 "tooltip": " Expand Parameters - arg is column id, value is parameter name to change with column value",3588 "order": 40,3589 "classType": "advanced"3590 },3591 {3592 "name": "paginate",3593 "value": "false",3594 "type": "Boolean",3595 "description": "Paginate",3596 "tooltip": "Paginate",3597 "order": 41,3598 "classType": "advanced"3599 },3600 {3601 3592 "name": "displayLength", 3602 3593 "value": "", … … 3649 3640 "description": "Expand On Click", 3650 3641 "tooltip": "If true, expand row when clicked and show content from expandContainerObject", 3642 "order": 41, 3643 "classType": "advanced" 3644 }, 3645 { 3646 "name": "paginate", 3647 "value": "false", 3648 "type": "Boolean", 3649 "description": "Paginate", 3650 "tooltip": "Paginate", 3651 3651 "order": 41, 3652 3652 "classType": "advanced" … … 3680 3680 }, 3681 3681 { 3682 "name": "sDom",3683 "value": "",3684 "type": "JavaScript",3685 "description": "sDom control",3686 "tooltip": "Configuration of where the controls will be in the table",3687 "order": 43,3688 "classType": "advanced"3689 },3690 {3691 3682 "name": "sortBy", 3692 3683 "value": "[]", … … 3694 3685 "description": "Sort by", 3695 3686 "tooltip": "Choose the columns where the sorting will default. Example: [[0,asc],[1,desc]]", 3687 "order": 43, 3688 "classType": "advanced" 3689 }, 3690 { 3691 "name": "sDom", 3692 "value": "", 3693 "type": "JavaScript", 3694 "description": "sDom control", 3695 "tooltip": "Configuration of where the controls will be in the table", 3696 3696 "order": 43, 3697 3697 "classType": "advanced"
Note: See TracChangeset
for help on using the changeset viewer.