Exemplo n.º 1
0
<script>

	/*$(document).ready(function(){
	   // Your code here
		$("#timeframe").val(<?php 
echo "'" . $timeframe . "'";
?>
);
		
	 });*/
    google.load('visualization', '1', {'packages' : ['table']});
    //google.setOnLoadCallback(function() { sendAndDraw('') });
    var firstpass = true;

    <?php 
echo "var dataSourceUrl = '" . Environment::getJSPPath(true) . "mysqldatasource2eh2.jsp';";
?>
        // var dataSourceUrl = 'http://www.pikefin.com/phpdev/gadgetsamples/echodatasource2.php';
           

   // var dataSourceUrl = 'https://spreadsheets.google.com/tq?key=rCaVQNfFDMhOM6ENNYeYZ9Q&pub=1';
    var query1;
   // var query2;
   
   function genericClickHandler(localTableChart,localQueryWrapper) {

		var row = localTableChart.getSelection();
		
		//var test5 = queryWrapper2;

		var dt = localQueryWrapper.currentDataTable;
        	

        	
         	//alert('here 1');
            //var metric1 = document.getElementById('metric-1').value;
      		count++;
         	var str = '' + count;
        
            //var str = 'select ticker,calyear,value where ((calyear=2010 or calyear=2011 or calyear=2012) and ticker=\'WMT\') group by ticker, calyear limit 30 format calyear "%d"';
           // alert('count:' + count);
 			
           
            //var query = new google.visualization.Query('http://localhost:8080/JSPDataSource/mysqldatasource7.jsp?taskid=22');
            
          	<?php 
echo "var datasourceurl='" . Environment::getJSPPath(true) . "/mysqldatasource7_2.jsp';";
//echo "var datasourceurl='".IncFunc::$PHP_ROOT_PATH."/json/gdpmotion.html';";
?>

          	if (window.console) {
              	console.log(datasourceurl);
            }
			//alert(datasourceurl);

          	
            var query = new google.visualization.Query(datasourceurl);
  
            
            query.setQuery(str);

            var options = {};
Exemplo n.º 3
0
					//$( "#a_c" ).val(ui.item.value.split("|")[1]);
					//sendAndDraw(ui.item.value.split("|")[0],ui.item.value.split("|")[1],ui.item.value.split("|")[2]);
					sendAndDraw(ui.item.id,ui.item.label,ui.item.full_name);
				}
			}
		});
	});
	
    google.load('visualization', '1', {'packages' : ['corechart']});
    google.setOnLoadCallback(function() { sendAndDraw(null) });


    <?php 
//echo "var dataSourceUrl = '".Environment::getJSPPath(true)."mysqldatasource2.jsp';";
echo "var dataSourceUrl1 ='" . Environment::getJSPPath(true) . "/mysqldatasource11.jsp';";
echo "var dataSourceUrl2 ='" . Environment::getJSPPath(true) . "/mysqldatasource12.jsp';";
?>
        // var dataSourceUrl = 'http://www.pikefin.com/phpdev/gadgetsamples/echodatasource2.php';
           

   // var dataSourceUrl = 'https://spreadsheets.google.com/tq?key=rCaVQNfFDMhOM6ENNYeYZ9Q&pub=1';
    var query1;
    var query2;



    function sendAndDraw(id,ticker,fullname) {

      var container1 = document.getElementById('chart1');
      var container2 = document.getElementById('chart2');
Exemplo n.º 4
0
   	   	    	return;
   	    	}

        	//document.getElementById('chart-div').innerHTML="<img src=\"../../site/images/spinner3-black.gif\" />";

        	
         	//alert('here 1');
            //var metric1 = document.getElementById('metric-1').value;
      		count++;
         	var str = '' + count;
        
         	<?php 
if ($cache == true) {
    echo "var dataSourceUrl='" . IncFunc::$PHP_ROOT_PATH . "/json/gdpmotion.html';";
} else {
    echo "var dataSourceUrl = '" . Environment::getJSPPath(true) . "/mysqldatasource7.jsp?metricids=" . $metricids . "';";
}
?>

          	if (window.console) {console.log(dataSourceUrl)}
            
            var query = new google.visualization.Query(dataSourceUrl);
  
            
            query.setQuery(str);

            var options = {};

            options['height'] = 600;
            options['width'] = 800;
            options.wmode='opaque';
Exemplo n.º 5
0
            var queryPath = '';


            var tickers_no_spaces = $('#a_c').val().replace(/\s/g, "");

            if (tickers_no_spaces.charAt(tickers_no_spaces.length - 1) == ',')
                tickers_no_spaces = tickers_no_spaces.substr(0,tickers_no_spaces.length-1);

            if ((tickers_no_spaces.split(',')).length > 1) {
                <?php 
echo "queryPath = '" . Environment::getJSPPath(true) . "mysqldatasource15multiple.jsp';";
?>
            }
            else {
            	<?php 
echo "queryPath = '" . Environment::getJSPPath(true) . "mysqldatasource15single.jsp';";
?>
            }

        	/*
        	* metric id of zero means use the default.
        	*/

			queryPath += '?metricid=0';

			if ($('#checkbox1').prop('checked')) {
				queryPath += '&percent=true';
				options.allValuesSuffix='%';
			}
			else {
				queryPath += '&percent=false';
        
        function loadChart() {
        	
         	//alert('here 1');
            //var metric1 = document.getElementById('metric-1').value;
      		count++;
         	var str = '' + count;
        
            //var str = 'select ticker,calyear,value where ((calyear=2010 or calyear=2011 or calyear=2012) and ticker=\'WMT\') group by ticker, calyear limit 30 format calyear "%d"';
           // alert('count:' + count);
 			
           
            //var query = new google.visualization.Query('http://localhost:8080/JSPDataSource/mysqldatasource7.jsp?taskid=22');
            
            <?php 
echo "var query = new google.visualization.Query('" . Environment::getJSPPath(true) . "/mysqldatasource8.jsp?userid=16');";
?>
  
            
            query.setQuery(str);

            var options = {};

            options['height'] = 600;
            options['width'] = 800;

            /*options['state'] =	'{"iconKeySettings":[],';  
            options['state'] +='"stateVersion":3,';  
            options['state'] +='"time":"notime",';  
            options['state'] +='"xAxisOption":"Time",';  
            options['state'] +='"playDuration":15,';  
Exemplo n.º 7
0
IncFunc::linkStyleCSS();
//IncFunc::yuiDropDownJavaScript();
IncFunc::googleGadget();
?>

<script>

    google.load('visualization', '1', {'packages' : ['table']});
    //google.setOnLoadCallback(function() { sendAndDraw('') });
    var firstpass = true;

    <?php 
if ($cache == true) {
    $dataSourceUrl = IncFunc::$PHP_ROOT_PATH . "/json/gdpmotion.html";
} else {
    $dataSourceUrl = Environment::getJSPPath(true) . "/mysqldatasource7.jsp?metricids=" . $metricids;
    if ($abs == true) {
        $dataSourceUrl .= "&abs=true";
    }
}
echo "var dataSourceUrl='" . $dataSourceUrl . "';";
/*if ($cache==true) 
      echo "var dataSourceUrl='".IncFunc::$PHP_ROOT_PATH."/json/gdpmotion.html';";
  else {
  	echo "var dataSourceUrl = '".Environment::getJSPPath(true)."/mysqldatasource7.jsp?metricids=".$metricids."';";
  }*/
?>
       
   var query1;
  
   
Exemplo n.º 8
0
<?php 
IncFunc::icon();
IncFunc::title();
IncFunc::linkStyleCSS();
//IncFunc::yuiDropDownJavaScript();
IncFunc::googleGadget();
IncFunc::googleAnalytics();
?>
<script type="text/javascript">
    google.load('visualization', '1', {'packages' : ['table']});
    //google.setOnLoadCallback(function() { sendAndDraw('') });
    var firstpass = true;

    <?php 
//added cache buster url parameter for ie.
echo "var dataSourceUrl = '" . Environment::getJSPPath(true) . "mysqldatasource2eh2.jsp?randNum=' + new Date().getTime();";
?>
        // var dataSourceUrl = 'http://www.pikefin.com/phpdev/gadgetsamples/echodatasource2.php';
           

   // var dataSourceUrl = 'https://spreadsheets.google.com/tq?key=rCaVQNfFDMhOM6ENNYeYZ9Q&pub=1';
    var query1;
    var query2;
    var query3;
    var query4;
 

	function genericClickHandler(localTableChart,localQueryWrapper) {

		var row = localTableChart.getSelection();
		
Exemplo n.º 9
0
echo "options.title='Comparison of Cumulative GDP Growth (" . $gdpstring . ": Actual and Estimated) to Equity Indexes for Country: " . $countryname . "';";
?>
         	
            




        	
        	
        	/*
        	* metric id of zero means use the default.
        	*/
			<?php 
//echo "alert(\"".$begindate."\");\n";
echo "var queryPath = '" . Environment::getJSPPath(true) . "mysqldatasource15multiplecountry.jsp";
//echo "var queryPath = '".Environment::getJSPPath(true)."mysqldatasource15multiplecountryv2.jsp";
echo "?begindate='+(Date.parse('" . $begindate . "')).getTime()+'";
if (!empty($enddate)) {
    echo "&enddate='+(Date.parse('" . $enddate . "')).getTime()+'";
}
echo "&entityid=" . $entities;
echo "&countryid=" . $countryid;
echo "&taskid=" . $tasks;
//echo "&gdptype=.".$gdptype;
echo "&metricid=" . $metrics . "';";
?>

	
		
				
Exemplo n.º 10
0
			options.backgroundColor = {};
			options.backgroundColor.fill = 'white';
			options.backgroundColor.stroke = '#000';
         	options.backgroundColor.strokeWidth = 8;*/
         	
            




        	//var queryPath = '<?php 
echo Environment::getJSPPath(true);
?>
mysqldatasource1.jsp?begindate=2011-01-01&metricid=1';
        	var queryPath = '<?php 
echo Environment::getJSPPath(true);
?>
mysqldatasource15.jsp?begindate=2011-01-01&alertid=0&metricid=1';

			if(id != undefined){
				queryPath += '&entityid=' + escape(id); 
				//options.title = ticker + " - " + fullname;

				//alert(ticker);
			}
			else
			{
				queryPath += <?php 
echo "'&entityid=" . $entityid . "';";
?>
				<?php 
Exemplo n.º 11
0

        	
        	
        	/*
        	* metric id of zero means use the default.
        	*/
			<?php 
if (sizeof($entities) > 1) {
    echo "var queryPath = '" . Environment::getJSPPath(true) . "mysqldatasource15multiple.jsp?begindate=" . $begindate;
    if (!empty($enddate)) {
        echo "&enddate=" . $enddate;
    }
    echo "&alertid=0&metricid=0';\n";
} else {
    echo "var queryPath = '" . Environment::getJSPPath(true) . "mysqldatasource15.jsp?granularity=minute&begindate=" . $begindate;
    if (!empty($enddate)) {
        echo "&enddate=" . $enddate;
    }
    echo "&alertid=0&metricid=" . $metricid . "';\n";
}
?>
        	title = document.getElementById('chart-title');
			if(id != undefined){
				queryPath += '&entityid=' + escape(id); 

		
				title.innerHTML = ticker + " - " + fullname;
				//options.title = ticker + " - " + fullname;