google.load('visualization', '1', {'packages':['piechart']});
google.load("visualization", "1", {packages:["columnchart"]});

function drawChart(js_array, subject, column, q, type, tablename) {
        var amount = 0;
        var note = "";
        //need to creat enought of these for all charts
        
        
        //should make this pass $prev and querytype and whatever back to the menu builder
        //single parts of the query can be changed.
        // Instantiate and draw our chart, passing in some options.

        if (tablename!=='familydetails'){
        var data = new google.visualization.DataTable();
        data.addColumn('string', column);
        data.addColumn('number', 'Frequency');
        var draw=false
        for (var i in js_array) {
        if (i!=="NR"&&i!=="nr"&&i!=="Nr"&&i!=="na"&&i!=="NA"&&i!=="Na"&&js_array[i]!==0){
            data.addRow([i, js_array[i]]);
            draw=true
            }
        else{
            amount=js_array[i]+amount;
        }
        }
        if(amount>0){
        note = "There are "+amount+" entries where this question is<br/>Not recorded or Not Applicable";
        }
        var pattern=new RegExp("monthly_income");
        if(column.match(pattern)!==null){
            note=note+"<br/><br/><b>Amounts are in Indian Rupees</b>";
        }
        if (draw===true){
        var chart = new google.visualization.PieChart(document.getElementById('chart'));
        chart.draw(data, {width: 600, height: 400, is3D: true, title: subject, legendTextColor: '#4A4A4A', titleColor: '#4A4A4A'});
        $('#chart1').text('');
        $('#chart2').text('');
        imageDescriptionAjax3(q, 'description', type, note);
        }
        else{
            $("div.chart").append("There is not yet any good data for this selection");
            $('#chart1').text('');
            $('#chart2').text('');
        }
        }
        ///// do family details
        else{
        var data = new google.visualization.DataTable();
        var data1 = new google.visualization.DataTable();
        var data2 = new google.visualization.DataTable();
        //do total pie
        data.addColumn('string', column);
        data.addColumn('number', 'Frequency');
        var draw=false
        for (var i in js_array) {
        if (i!=="NR"&&i!=="nr"&&i!=="Nr"&&i!=="na"&&i!=="NA"&&i!=="Na"&&js_array[i]!==0&&i!=="end"){
            data.addRow([i, js_array[i][0]+js_array[i][1]]);
            draw=true
            }
        else if(i!=="end"){
            amount=js_array[i][0]+js_array[i][1]+amount;
        }
        }
        //by sex - both
        data1.addColumn('string', column);
        data1.addColumn('number', 'Male Frequency');
        data1.addColumn('number', 'Female Frequency');
        var draw1=false
        for (var i in js_array[0]) {
        if (i!=="NR"&&i!=="nr"&&i!=="Nr"&&i!=="na"&&i!=="NA"&&i!=="Na"&&js_array[i]!==0&&i!=="end"){
            data1.addRow([i, js_array[i][0], js_array[i][1]]);
            draw1=true
            }
        }
        //by avg age in categ - both
        //data2.addColumn('string', column);
        //data2.addColumn('string', column);
        //data2.addColumn('number', 'Frequency');
        //var draw2=false
        //for (var i in js_array[2]) {
        //if (i!=="NR"&&i!=="nr"&&i!=="Nr"&&i!=="na"&&i!=="NA"&&i!=="Na"&&js_array[i]!==0){
            //data2.addRow([i, js_array[2][i]]);
            //draw2=true
            //}
        //}
        //by avg amount in age categ - int only so leave

        if(amount>0){
        note = "There are "+amount+" entries where this question is<br/>Not recorded or Not Applicable";
        }
        var pattern=new RegExp("monthly_income");
        if(column.match(pattern)!==null){
            note=note+"<br/><br/><b>Amounts are in Indian Rupees</b>";
        }

        if (draw===true){
        var chart = new google.visualization.PieChart(document.getElementById('chart'));
        chart.draw(data, {width: 600, height: 400, is3D: true, title: subject, legendTextColor: '#4A4A4A', titleColor: '#4A4A4A'});
        if (draw1===true){
        var chart1 = new google.visualization.ColumnChart(document.getElementById('chart1'));
        chart1.draw(data1, {width: 600, height: 400, is3D: true, title: subject, legendTextColor: '#4A4A4A', titleColor: '#4A4A4A'});
        }
        //if (draw2===true){
        //var chart2 = new google.visualization.PieChart(document.getElementById('chart2'));
        //chart2.draw(data2, {width: 600, height: 400, is3D: true, title: subject, legendTextColor: '#4A4A4A', titleColor: '#4A4A4A'});
        //}
        imageDescriptionAjax3(q, 'description', type, note);
        }
        else{
            $("div.chart").append("There is not yet any good data for this selection");
        }
        }
        
  }