Changeset 331d4c1 in intercambio
- Timestamp:
- Dec 4, 2013, 10:39:36 AM (10 years ago)
- Branches:
- master
- Children:
- 2f6720e
- Parents:
- f5c32c9
- Files:
-
- 3 edited
Legend:
- Unmodified
- Added
- Removed
-
Dashboards/Cuadro 4.cda
rf5c32c9 r331d4c1 14 14 <Jndi>smid</Jndi> 15 15 </Connection> 16 <Connection id="Info" type="sql.jndi"> 17 <Jndi>smid</Jndi> 18 </Connection> 16 19 </DataSources> 17 20 <DataAccess access="public" cache="true" cacheDuration="3600" connection="Rif" id="Rif" … … 22 25 "dimension_empresa"."rif" 23 26 FROM 24 "dimension_empresa"</Query> 27 "dimension_empresa" INNER JOIN "hechos_bienesproducidos_empresa" ON "dimension_empresa"."id" = "hechos_bienesproducidos_empresa"."id_empresa" 28 GROUP BY "dimension_empresa"."rif" 29 ORDER BY 1 asc</Query> 25 30 </DataAccess> 26 31 <DataAccess access="public" cache="true" cacheDuration="3600" connection="Nombre" … … 32 37 "dimension_empresa"."nombre" 33 38 FROM 34 "dimension_empresa" 39 "dimension_empresa" INNER JOIN "hechos_bienesproducidos_empresa" ON "dimension_empresa"."id" = "hechos_bienesproducidos_empresa"."id_empresa" 35 40 WHERE 36 41 dimension_empresa.nombre NOT LIKE 'NO INDICA' 37 ORDER BY 1 ASC</Query> 42 GROUP BY 43 "dimension_empresa"."nombre" 44 ORDER BY 45 1 ASC</Query> 38 46 </DataAccess> 39 47 <DataAccess access="public" cache="true" cacheDuration="3600" connection="RazonSocial" … … 45 53 "dimension_empresa"."razon_social" 46 54 FROM 47 "dimension_empresa" 48 ORDER BY 1 ASC</Query> 55 "dimension_empresa" INNER JOIN "hechos_bienesproducidos_empresa" ON "dimension_empresa"."id" = "hechos_bienesproducidos_empresa"."id_empresa" 56 GROUP BY 57 "dimension_empresa"."razon_social" 58 ORDER BY 59 1 ASC</Query> 49 60 </DataAccess> 50 61 <DataAccess access="public" cache="true" cacheDuration="3600" … … 72 83 LIMIT 10</Query> 73 84 </DataAccess> 85 <DataAccess access="public" cache="true" cacheDuration="3600" connection="Info" id="Info" 86 type="sql"> 87 <Columns/> 88 <Parameters> 89 <Parameter default="seleccion" name="seleccion" type="String"/> 90 </Parameters> 91 <Query>SELECT 92 "dimension_empresa"."rif" || ' - ' || "dimension_empresa"."razon_social" 93 FROM 94 "dimension_empresa" 95 WHERE 96 dimension_empresa.rif LIKE ${seleccion} 97 OR dimension_empresa.nombre LIKE ${seleccion} 98 OR dimension_empresa.razon_social LIKE ${seleccion}</Query> 99 </DataAccess> 74 100 </CDADescriptor> -
Dashboards/Cuadro 4.cdfde
rf5c32c9 r331d4c1 975 975 }, 976 976 { 977 "id": "d374e32d-5791-a000-6249-a4fb624a2347",978 "type": "LayoutRow",979 "typeDesc": "Row",980 "parent": "UnIqEiD",981 "properties": [982 {983 "name": "name",984 "value": "Boton",985 "type": "Id"986 },987 {988 "name": "height",989 "value": "",990 "type": "Integer"991 },992 {993 "name": "backgroundColor",994 "value": "",995 "type": "Color"996 },997 {998 "name": "roundCorners",999 "value": "",1000 "type": "RoundCorners"1001 },1002 {1003 "name": "textAlign",1004 "value": "center",1005 "type": "TextAlign"1006 },1007 {1008 "name": "cssClass",1009 "value": "",1010 "type": "String"1011 }1012 ]1013 },1014 {1015 "id": "f6f088f8-4f24-1a8d-5882-5eab4e562d73",1016 "type": "LayoutSpace",1017 "typeDesc": "Space",1018 "parent": "UnIqEiD",1019 "properties": [1020 {1021 "name": "height",1022 "value": "",1023 "type": "Integer"1024 },1025 {1026 "name": "backgroundColor",1027 "value": "",1028 "type": "Color"1029 },1030 {1031 "name": "cssClass",1032 "value": "",1033 "type": "String"1034 }1035 ]1036 },1037 {1038 977 "id": "9b5e4665-60dd-d123-d49a-7cb9072a0540", 1039 978 "type": "LayoutRow", … … 1122 1061 "name": "height", 1123 1062 "type": "Integer", 1124 "value": " 600"1063 "value": "440" 1125 1064 }, 1126 1065 { … … 1241 1180 }, 1242 1181 { 1182 "id": "6178eecf-c3b2-9bf9-d33e-609de0312036", 1183 "type": "LayoutRow", 1184 "typeDesc": "Row", 1185 "parent": "a75b059a-0f5b-deda-6d3f-aeba72af2fe5", 1186 "properties": [ 1187 { 1188 "name": "name", 1189 "value": "fExportar", 1190 "type": "Id" 1191 }, 1192 { 1193 "name": "height", 1194 "value": "", 1195 "type": "Integer" 1196 }, 1197 { 1198 "name": "backgroundColor", 1199 "value": "", 1200 "type": "Color" 1201 }, 1202 { 1203 "name": "roundCorners", 1204 "value": "", 1205 "type": "RoundCorners" 1206 }, 1207 { 1208 "name": "textAlign", 1209 "value": "center", 1210 "type": "TextAlign" 1211 }, 1212 { 1213 "name": "cssClass", 1214 "value": "", 1215 "type": "String" 1216 } 1217 ] 1218 }, 1219 { 1220 "id": "856d7483-89b4-4ea1-706c-e5f15cd72dfb", 1221 "type": "LayoutSpace", 1222 "typeDesc": "Space", 1223 "parent": "a75b059a-0f5b-deda-6d3f-aeba72af2fe5", 1224 "properties": [ 1225 { 1226 "name": "height", 1227 "value": "", 1228 "type": "Integer" 1229 }, 1230 { 1231 "name": "backgroundColor", 1232 "value": "", 1233 "type": "Color" 1234 }, 1235 { 1236 "name": "cssClass", 1237 "value": "", 1238 "type": "String" 1239 } 1240 ] 1241 }, 1242 { 1243 1243 "id": "e4cf9b23-0788-e7a9-35b2-fd3704e56ed9", 1244 1244 "type": "LayoutRow", … … 1279 1279 }, 1280 1280 { 1281 "id": " 856d7483-89b4-4ea1-706c-e5f15cd72dfb",1281 "id": "e0e0424a-bac3-004c-5309-f137f252a744", 1282 1282 "type": "LayoutSpace", 1283 1283 "typeDesc": "Space", … … 1340 1340 }, 1341 1341 { 1342 "id": "e0e0424a-bac3-004c-5309-f137f252a744", 1343 "type": "LayoutSpace", 1344 "typeDesc": "Space", 1345 "parent": "a75b059a-0f5b-deda-6d3f-aeba72af2fe5", 1346 "properties": [ 1347 { 1348 "name": "height", 1349 "value": "", 1350 "type": "Integer" 1351 }, 1352 { 1353 "name": "backgroundColor", 1354 "value": "", 1355 "type": "Color" 1356 }, 1357 { 1358 "name": "cssClass", 1359 "value": "", 1360 "type": "String" 1361 } 1362 ] 1363 }, 1364 { 1365 "id": "6178eecf-c3b2-9bf9-d33e-609de0312036", 1342 "id": "10e638c3-543a-410d-89a6-d5e4b3f1c0f4", 1366 1343 "type": "LayoutRow", 1367 1344 "typeDesc": "Row", 1368 "parent": "a75b059a-0f5b-deda-6d3f-aeba72af2fe5", 1369 "properties": [ 1370 { 1371 "name": "name", 1372 "value": "fExportar", 1345 "parent": "UnIqEiD", 1346 "properties": [ 1347 { 1348 "name": "name", 1349 "value": "", 1350 "type": "Id" 1351 }, 1352 { 1353 "name": "height", 1354 "value": "5", 1355 "type": "Integer" 1356 }, 1357 { 1358 "name": "backgroundColor", 1359 "value": "", 1360 "type": "Color" 1361 }, 1362 { 1363 "name": "roundCorners", 1364 "value": "", 1365 "type": "RoundCorners" 1366 }, 1367 { 1368 "name": "textAlign", 1369 "value": "", 1370 "type": "TextAlign" 1371 }, 1372 { 1373 "name": "cssClass", 1374 "value": "", 1375 "type": "String" 1376 } 1377 ] 1378 }, 1379 { 1380 "id": "6056f259-ef6f-532f-5b0a-8d3bfcd494a5", 1381 "type": "LayoutRow", 1382 "typeDesc": "Row", 1383 "parent": "UnIqEiD", 1384 "properties": [ 1385 { 1386 "name": "name", 1387 "value": "ExportarC", 1373 1388 "type": "Id" 1374 1389 }, … … 2030 2045 }, 2031 2046 { 2047 "id": "25e7add4-6f9b-ba4a-1a8e-5e5f775780d5", 2048 "type": "ComponentsParameter", 2049 "typeDesc": "Simple parameter", 2050 "parent": "GENERIC", 2051 "properties": [ 2052 { 2053 "name": "name", 2054 "value": "seleccion", 2055 "type": "Id" 2056 }, 2057 { 2058 "name": "propertyValue", 2059 "value": "seleccion", 2060 "type": "String" 2061 }, 2062 { 2063 "name": "parameterViewRole", 2064 "value": "unused", 2065 "type": "parameterViewRoleCustom" 2066 }, 2067 { 2068 "name": "bookmarkable", 2069 "value": "false", 2070 "type": "Boolean" 2071 } 2072 ] 2073 }, 2074 { 2032 2075 "id": "0cf07562-59e7-61a9-2a58-590d2ae88f0d", 2033 2076 "type": "ComponentsParameter", … … 2037 2080 { 2038 2081 "name": "name", 2039 "value": " seleccion",2082 "value": "Descrip", 2040 2083 "type": "Id" 2041 2084 }, 2042 2085 { 2043 2086 "name": "propertyValue", 2044 "value": " seleccion",2087 "value": "Descrip", 2045 2088 "type": "String" 2046 2089 }, … … 2270 2313 }, 2271 2314 { 2272 "id": "418d8309-3ac8-2fde-c584-ea3b05ae7ae2",2273 "type": "ComponentsbuttonComponent",2274 "typeDesc": "Button Component",2275 "parent": "OTHERCOMPONENTS",2276 "properties": [2277 {2278 "name": "name",2279 "value": "Limpiar",2280 "type": "Id"2281 },2282 {2283 "name": "label",2284 "value": "Limpiar",2285 "type": "String"2286 },2287 {2288 "name": "listeners",2289 "value": "[]",2290 "type": "Listeners"2291 },2292 {2293 "name": "expression",2294 "value": "function LimpiarP() {\n //alert(\"msg\"+a.series);\n Dashboards.fireChange('seleccion',' ');\n}\n",2295 "type": "JavaScript"2296 },2297 {2298 "name": "priority",2299 "value": "0",2300 "type": "Integer"2301 },2302 {2303 "name": "refreshPeriod",2304 "value": "",2305 "type": "Integer"2306 },2307 {2308 "name": "buttonStyle",2309 "value": "themeroller",2310 "type": "TableStyle"2311 },2312 {2313 "name": "htmlObject",2314 "value": "${p:Boton}",2315 "type": "HtmlObject"2316 },2317 {2318 "name": "executeAtStart",2319 "value": "true",2320 "type": "Boolean"2321 },2322 {2323 "name": "preExecution",2324 "value": "",2325 "type": "JavaScript"2326 },2327 {2328 "name": "postExecution",2329 "value": "",2330 "type": "JavaScript"2331 },2332 {2333 "name": "preChange",2334 "value": "",2335 "type": "JavaScript"2336 },2337 {2338 "name": "postChange",2339 "value": "",2340 "type": "JavaScript"2341 },2342 {2343 "name": "tooltip",2344 "value": "",2345 "type": "Html"2346 }2347 ]2348 },2349 {2350 2315 "id": "efdd871a-1e13-b25d-eecd-15f5400c76b1", 2351 2316 "type": "ComponentsexportButton", … … 2438 2403 { 2439 2404 "name": "expression", 2440 "value": "function() {\n return \"Selección: \" + Dashboards.getParameterValue(\" seleccion\");\n}",2405 "value": "function() {\n return \"Selección: \" + Dashboards.getParameterValue(\"Descrip\");\n}", 2441 2406 "type": "JavaScript" 2442 2407 }, … … 2468 2433 { 2469 2434 "name": "postExecution", 2435 "value": "", 2436 "type": "JavaScript" 2437 }, 2438 { 2439 "name": "tooltip", 2440 "value": "", 2441 "type": "Html" 2442 } 2443 ] 2444 }, 2445 { 2446 "id": "f305e108-94bc-324f-db09-d19e097d4848", 2447 "type": "ComponentsQuery", 2448 "typeDesc": "Query Component", 2449 "parent": "OTHERCOMPONENTS", 2450 "properties": [ 2451 { 2452 "name": "name", 2453 "value": "Descripcion", 2454 "type": "Id" 2455 }, 2456 { 2457 "name": "listeners", 2458 "value": "['${p:seleccion}']", 2459 "type": "Listeners" 2460 }, 2461 { 2462 "name": "parameters", 2463 "value": "[[\"seleccion\",\"seleccion\"]]", 2464 "type": "ValuesArray" 2465 }, 2466 { 2467 "name": "resultvar", 2468 "value": "${p:Descrip}", 2469 "type": "Result" 2470 }, 2471 { 2472 "name": "dataSource", 2473 "value": "Info", 2474 "type": "Datasource" 2475 }, 2476 { 2477 "name": "refreshPeriod", 2478 "value": "", 2479 "type": "Integer" 2480 }, 2481 { 2482 "name": "priority", 2483 "value": "1", 2484 "type": "Integer" 2485 }, 2486 { 2487 "name": "htmlObject", 2488 "value": "", 2489 "type": "HtmlObject" 2490 }, 2491 { 2492 "name": "executeAtStart", 2493 "value": "true", 2494 "type": "Boolean" 2495 }, 2496 { 2497 "name": "preExecution", 2498 "value": "", 2499 "type": "JavaScript" 2500 }, 2501 { 2502 "name": "postExecution", 2503 "value": "", 2504 "type": "JavaScript" 2505 }, 2506 { 2507 "name": "postFetch", 2508 "value": "", 2509 "type": "JavaScript" 2510 }, 2511 { 2512 "name": "preChange", 2513 "value": "", 2514 "type": "JavaScript" 2515 }, 2516 { 2517 "name": "postChange", 2518 "value": "", 2519 "type": "JavaScript" 2520 }, 2521 { 2522 "name": "tooltip", 2523 "value": "", 2524 "type": "Html" 2525 } 2526 ] 2527 }, 2528 { 2529 "id": "bc7f3587-edb6-b732-e68c-9674dc633cc5", 2530 "type": "ComponentsbuttonComponent", 2531 "typeDesc": "Button Component", 2532 "parent": "OTHERCOMPONENTS", 2533 "properties": [ 2534 { 2535 "name": "name", 2536 "value": "PDF", 2537 "type": "Id" 2538 }, 2539 { 2540 "name": "label", 2541 "value": "Exportar PDF", 2542 "type": "String" 2543 }, 2544 { 2545 "name": "listeners", 2546 "value": "[]", 2547 "type": "Listeners" 2548 }, 2549 { 2550 "name": "expression", 2551 "value": "function f() { window.print() }", 2552 "type": "JavaScript" 2553 }, 2554 { 2555 "name": "priority", 2556 "value": 5, 2557 "type": "Integer" 2558 }, 2559 { 2560 "name": "refreshPeriod", 2561 "value": "", 2562 "type": "Integer" 2563 }, 2564 { 2565 "name": "buttonStyle", 2566 "value": "themeroller", 2567 "type": "TableStyle" 2568 }, 2569 { 2570 "name": "htmlObject", 2571 "value": "ExportarC", 2572 "type": "HtmlObject" 2573 }, 2574 { 2575 "name": "executeAtStart", 2576 "value": "true", 2577 "type": "Boolean" 2578 }, 2579 { 2580 "name": "preExecution", 2581 "value": "", 2582 "type": "JavaScript" 2583 }, 2584 { 2585 "name": "postExecution", 2586 "value": "", 2587 "type": "JavaScript" 2588 }, 2589 { 2590 "name": "preChange", 2591 "value": "", 2592 "type": "JavaScript" 2593 }, 2594 { 2595 "name": "postChange", 2470 2596 "value": "", 2471 2597 "type": "JavaScript" … … 2519 2645 { 2520 2646 "name": "query", 2521 "value": "SELECT\n \"dimension_empresa\".\"rif\"\nFROM\n \"dimension_empresa\" ",2647 "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", 2522 2648 "type": "SqlQuery" 2523 2649 }, … … 2585 2711 { 2586 2712 "name": "query", 2587 "value": "SELECT\n \"dimension_empresa\".\"nombre\"\nFROM\n \"dimension_empresa\" \nWHERE\n dimension_empresa.nombre NOT LIKE 'NO INDICA'\nORDER BY1 ASC",2713 "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", 2588 2714 "type": "SqlQuery" 2589 2715 }, … … 2651 2777 { 2652 2778 "name": "query", 2653 "value": "SELECT\n \"dimension_empresa\".\"razon_social\"\nFROM\n \"dimension_empresa\" \nORDER BY1 ASC",2779 "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", 2654 2780 "type": "SqlQuery" 2655 2781 }, … … 2718 2844 "name": "query", 2719 2845 "value": "SELECT\n \"dimension_bien\".\"nombre\",\n sum(\"hechos_bienesproducidos_empresa\".\"medida_monto_venta\")\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\ndimension_empresa.rif LIKE ${seleccion}\nOR\ndimension_empresa.nombre LIKE ${seleccion}\nOR\ndimension_empresa.razon_social LIKE ${seleccion} \nGROUP BY 1 \nORDER BY 2 DESC\nLIMIT 10", 2846 "type": "SqlQuery" 2847 }, 2848 { 2849 "name": "parameters", 2850 "value": "[[\"seleccion\",\"seleccion\",\"String\",\"\"]]", 2851 "type": "CdaParameters" 2852 }, 2853 { 2854 "name": "outputMode", 2855 "value": "include", 2856 "type": "OutputMode" 2857 }, 2858 { 2859 "name": "cdacolumns", 2860 "value": "[]", 2861 "type": "CdaColumnsArray" 2862 }, 2863 { 2864 "name": "cdacalculatedcolumns", 2865 "value": "[]", 2866 "type": "CdaCalculatedColumnsArray" 2867 }, 2868 { 2869 "name": "output", 2870 "value": "[]", 2871 "type": "IndexArray" 2872 }, 2873 { 2874 "name": "cacheDuration", 2875 "value": 3600, 2876 "type": "Integer" 2877 }, 2878 { 2879 "name": "cache", 2880 "value": "true", 2881 "type": "Boolean" 2882 } 2883 ], 2884 "meta": "CDA", 2885 "meta_conntype": "sql.jndi", 2886 "meta_datype": "sql" 2887 }, 2888 { 2889 "id": "a07fd7ed-d4dd-e031-6451-0d234e510b0a", 2890 "type": "Componentssql_sqlJndi", 2891 "typeDesc": "sql over sqlJndi", 2892 "parent": "SQL", 2893 "properties": [ 2894 { 2895 "name": "name", 2896 "value": "Info", 2897 "type": "Id" 2898 }, 2899 { 2900 "name": "access", 2901 "value": "public", 2902 "type": "Access" 2903 }, 2904 { 2905 "name": "jndi", 2906 "value": "smid", 2907 "type": "Jndi" 2908 }, 2909 { 2910 "name": "query", 2911 "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}", 2720 2912 "type": "SqlQuery" 2721 2913 },
Note: See TracChangeset
for help on using the changeset viewer.