scoreboard

a Players scoareboard

by forssux

HTML

<script src="http://www.google.com/jsapi?.js"></script>
<div id='dashboard_div'>
     <h3>PM Work Orders</h3>

    <table>
        <tr style='vertical-align: top'>
            <td style='width: 600px; font-size: 0.8em;'>
                <div id='slider_div' style='width:500px;'></div>
                <br />
                <br />
                <div id='dateSlider_div' style='width:500px;'></div>
                <br />
                <br />
                <div id='dateSliderFin_div' style='width:500px;'></div>
                <br />
                <br />
                <div id='columnChart_div' style='width:500px;'></div>
                <br />
                <br />
            </td>
            <td style='width: 300px; font-size: 0.8em;'>
                <div id='FLfilter_div' style='width:300px;'></div>
                <br />
                <div id='Statfilter_div' style='width:300px;'></div>
                <br />
                <div id='Typefilter_div' style='width:300px;'></div>
                <br />
            </td>
            <td style='width: 1500px'>
                <div id='table_div'></div>
            </td>
        </tr>
    </table>
</div>

JavaScript

google.load('visualization', '1.1', {
    'packages': ['controls']
});

var rows = 0;

///// getting the data ////////

var query = new google.visualization.Query('https://docs.google.com/spreadsheets/d/1XGqGIs36krgKbRjufKJJNRdu1NUBZlgIJek2ojnOo2Y/edit#gid=967698286');

// Apply query language statement.
query.setQuery('SELECT A,B,C  ORDER BY C');

// Send the query with a callback function.
query.send(handleQueryResponse);




///// ----------------------- //////

function handleQueryResponse(response) {
    var dashboard = new google.visualization.Dashboard(
    document.getElementById('dashboard_div'));
    if (response.isError()) {
        alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage());
        return;
    }

    var data = response.getDataTable();






    function drawDashboard() {

        //    var data = google.visualization.arrayToDataTable([
        //        ['Status','Priority','Order No.','Description','Func. Loc.','Type','Start Dt','Fin Date'],
        //        ['RSCH',2,500400,'Hard disk problem (SAP01)','1171-ADMI-0001 ','SM01',new Date(2005, 0, 1),new Date(2009, 0, 2)],
        //        ['INIT',1,501300,'','','SM02',new Date(2007, 0, 1),new Date(2009, 11, 2)],
        //        ['RSCH',1,500400,'Hard disk problem (SAP01)','1171-ADMI-0001 ','SM01',new Date(2005, 0, 1),new Date(2009, 0, 2)],
        //        ['INIT',2,501300,'','','SM02',new Date(2007, 0, 1),new Date(2009, 11, 2)],
        //        ['RSCH',5,500400,'Hard disk problem (SAP01)','1171-ADMI-0001 ','SM01',new Date(2005, 0, 1),new Date(2009, 0, 2)],
        //        ['RDSP',4,501300,'','','SM02',new Date(2007, 0, 1),new Date(2009, 11, 2)]
        //    ]);


        // Create a dashboard.
        dashboard = new google.visualization.Dashboard(
        document.getElementById('dashboard_div'));
        // Create a range slider, passing some options
        var rangeSlider = new google.visualization.ControlWrapper({
            'controlType':...