$(function(tableData){
    $.getJSON('src/getDefects.php', {r: $_POST['q'], p: $_POST['p']}, function(reldata) {
        var data = new google.visualization.DataTable();
        data.addRows(reldata.length);
        data.addColumn('string','DatabaseID');
        data.addColumn('string','Synopsis');
        data.addColumn('string','Target Release');
        data.addColumn('string','State');
        $.each(reldata, function(k, val){
            data.setCell(k, 0, val.dbid);
            data.setCell(k, 1, val.synopsis);
            data.setCell(k, 2, val.target_rel);
            data.setCell(k, 3, val.state);
        });

        var options = {'showRowNumber':false ,'allowHtml':true ,sortColumn:1 ,sortAscending:false
                       ,page:'enable' ,width:'100%' ,pagingSymbols:{next:'next' ,prev:'prev'}};

        var v = new google.visualization.DataView(data);
        v.setColumns([1,2,3,4,5]);

        // get distinct values from view list.
        states = v.getDistinctValues(4);

        //itterate through unique states and push on to the array.
        $.each(states, function(k, val){
            cols.push(val);
            rows.push(v.getFilteredRows([{column: 4, value: val}]).length);
        });

        if(v.getNumberOfRows() > 0){
            var tableData = new google.visualization.Table(document.getElementById('table' + verString));
            tableData.draw(v,options);
        }else{
            $('div#table' + verString).prepend('<p><strong>No Issues could be found.</strong></p>');
        }
    });
    google.setOnLoadCallback(tableData);
});

google.load('visualization', '1');
$(function dtable() {
    var wrapper = new google.visualization.ChartWrapper({
        chartType: 'ColumnChart',
        dataTable: [cols,rows],
        options: {'title': 'Issues by State'},
        containerId: 'viz'
    });
    wrapper.draw();
    //google.setOnLoadCallback(dtable);
});