CrosstabView - Dev

by mshufrich

HTML

<div id="dataView">
    <div id="table" style="margin: 20px; width: 600px; height: 450px;"></div>
    <div id="filterPanels"></div>
</div>

<link rel="stylesheet" href="http://192.168.1.69:8080/jrs_amber_adv/scripts/adhoc/api/css/adHocView.css" type="text/css" media="screen">

    <script type='text/javascript' src="http://192.168.1.69:8080/jrs_amber_adv/client/visualize.js?_opt=false"></script>

    <!--<link rel="stylesheet" href="http://192.168.1.57:8080/jrs_amber_adv/scripts/adhoc/api/css/adHocView.css" type="text/css" media="screen">

    <script type="text/javascript" src="http://192.168.1.57:8080/jrs_amber_adv/scripts/client/jasper.js"></script>-->

CSS

#typeChooser {
    width: 250px;
}
#dataSelector {
    width: 250px;
}
#table{
    height: 300px;
}

.slider {
    width: 200px;
}

body {
    font-size: 11px;
    line-height: 1.182em;
    font-family: Verdana, Arial, Helvetica, sans-serif;
    font-weight: normal;
}

.tooltip {
    position: absolute;
    padding: 4px;
    text-align: center;
    background: #eee;
    border: solid 1px #ccc;
    z-index: 1000;
    display: none;
    white-space: nowrap;
}

.sliderTick {
    position: absolute;
    background: url(http://gavmacbook.local:8080/jasperserver-pro-adv/themes/default/images/slider_tickMark.png);
    width: 3px;
    height: 23px;
    top: -4px;
    z-index: 0;
    margin-left: -1px;
}

.sliderContainer {
    padding-top: 15px;
}

.tickOverlay {
    position: absolute;
    height: 23px;
    width: 20px;
    left: -10px;
}


#container {
    background-color: #E6E6FA;
    overflow: hidden; 
}

#container > div {  
    border: 1px solid #aaa;
}

/*! perfect-scrollbar - v0.4.6
* http://noraesae.github.com/perfect-scrollbar/
* Copyright (c) 2013 HyeonJe Jun; Licensed MIT */

.ps-container .ps-scrollbar-x-rail{position:absolute;bottom:3px;height:8px;-webkit-border-radius:4px;-moz-border-radius:4px;border-radius:4px;opacity:0.7;filter:alpha(opacity=70);-o-transition:background-color .2s linear,opacity .2s linear;-webkit-transition:background-color.2s linear,opacity .2s linear;-moz-transition:background-color .2s linear,opacity .2s linear;transition:background-color .2s linear,opacity .2s linear}.ps-container:hover .ps-scrollbar-x-rail,.ps-container.hover .ps-scrollbar-x-rail{opacity:.6;filter:alpha(opacity=60)}.ps-container .ps-scrollbar-x-rail:hover,.ps-container .ps-scrollbar-x-rail.hover{/*background-color:#eee;*/opacity:.9;filter:alpha(opacity=90)}.ps-container .ps-scrollbar-x-rail.in-scrolling{opacity:.9;filter:alpha(opacity=90)}.ps-container...

JavaScript

visualize({
    auth: {
        name: "jasperadmin",
        password: "jasperadmin",
        organization: "organization_1"
    }
}, function (v) {
        v("#dataView").adHocView({
        baseUrl: "http://192.168.1.69:8080/jrs_amber_adhoc_rest_api",       
        url: "/public/Ad_Hoc_View",
        crosstab:{
            layout: {
                container: "#table"
            }
        },
        filters: "#filterPanels"
    });
    
});

/*var bi = jasper("http://192.168.1.57:8080/jrs_amber_adv");

//use configured script loader
bi([
    "jquery",
    "adhoc/api/AdHocViewFacade"
], function($, AdHocView){
    "use strict";
    
    var adHocView = new AdHocView({
        baseUrl: "http://build-master.jaspersoft.com:5780/jrs-pro-feature-amber-adhoc-rest-api",
        url: "/public/Samples/Ad_Hoc_Views/10__Calculated_Fields_and_Measures",
        container: "#dataView",
        crosstab:{
            layout: {
                container: "#table"
            }
        },
        filters: "#filterPanels"
    });
    
    /*adHocView.dataModel._metadata.attributes = {
        "version": 0,
        "permissionMask": 1,
        "creationDate": "2014-06-12 03:53:54",
        "updateDate": "2014-05-05 20:39:29",
        "label": "10. Calculated Fields and Measures",
        "description": "18 Sample Calculations",
        "uri": "/public/Samples/Ad_Hoc_Views/10__Calculated_Fields_and_Measures",
        "dataSource": {
            "dataSourceReference": {
                "uri": "/public/Samples/Domains/supermartDomain"
            }
        },
        "query": {
            "type": "Multidimensional",
            "select": {
                "rows": [
                    {
                        "id": "sales_fact_ALL.sales__store.sales__store__region.sales__store__region__sales_country"
                    },
                    {
                        "id": "Measures"
                    }
                ],
                "columns": [
                    {
   ...