将自定义参数传递给query.send Google查询语言 [英] Pass Custom Parameter to query.send Google Query Language

问题描述

我使用google的图表API创建了一个基于Web的仪表板。我想绘制很多图表，并需要通过此链接将自定义参数传递给handleDataQueryResponse函数： https://developers.google.com/chart/interactive/docs/spreadsheets#sheet-name 。该函数通过query.send（handleDataQueryResponse）调用来调用。我会想我可以通过调用：query.send（function（）{handleDataQueryResponse（parameters）}）;但这一直没有为我工作。有任何想法吗？打开其他方法来使查询及其处理程序可重用！

更多关于google的javascript图表API的信息： https://developers.google.com/chart/interactive/docs/quick_start 。

解决方案

类似这样的工作适合您吗？

  google.charts.load（'current'，{callback：function（）{drawChart0（）; drawChart1（）;}，packages：['corechart'，'table']}）; function drawChart0（） {var chart = new google.visualization.BarChart（document.getElementById（'barchart'））; var query =http://www.google.com/fusiontables/gvizdata?tq=SELECT'Label'as beach，'Pieces total'as Total FROM 1c-FiEDwdwMt55a4AlE8Xuu40rUBR_qeI8ENiHtPV; var options = {animation：{duration：500，startup：true，easing：'out'}，chartArea：{width：'40％'}}; sendQuery（query，chart，options）;}函数drawChart1（）{var chart = new google.visualization.Table（document.getElementById（'tablechart'））; var query =https://docs.google.com/spreadsheets/d/19olM1pEF5qQvvKhwSH3d_X4w2DVfOWDwDtZKNFlMY3w/edit#gid=0&tq=select A，B where A> = date'2016-01-01'; var options = {}; sendQuery（query，chart，options）;} function sendQuery（query，chart，options）{new google.visualization.Query（query）.send（function（response）{chart.draw（response.getDataTable（），options）; }};}  

< script src =https： //www.gstatic.com/charts/loader.js\">< / script>>< div id =barchart ;

I am using google's charts API to create a web-based dashboard. I want to draw many graphs and need to pass custom parameters to the handleDataQueryResponse function from this link: https://developers.google.com/chart/interactive/docs/spreadsheets#sheet-name. This function is called via a query.send(handleDataQueryResponse) call. I would have thought I could do this by calling: query.send(function() { handleDataQueryResponse(parameters) }); but this hasn't been working for me. Any ideas? Open to other approaches to making the query and its handler reusable!

More info on google's javascript chart API here: https://developers.google.com/chart/interactive/docs/quick_start.

解决方案

something like this work for you?

google.charts.load('current', {
  callback: function () {
    drawChart0();
    drawChart1();
  },
  packages:['corechart', 'table']
});

function drawChart0() {
  var chart = new google.visualization.BarChart(document.getElementById('barchart'));
  var query = "http://www.google.com/fusiontables/gvizdata?tq=SELECT 'Label' as beach, 'Pieces total' as Total FROM 1c-FiEDwdwMt55a4AlE8Xuu40rUBR_qeI8ENiHtPV";
  var options = {
    animation: {
      duration: 500,
      startup: true,
      easing: 'out'
    },
    chartArea: {
      width: '40%'
    }
  };
  sendQuery(query, chart, options);
}

function drawChart1() {
  var chart = new google.visualization.Table(document.getElementById('tablechart'));
  var query = "https://docs.google.com/spreadsheets/d/19olM1pEF5qQvvKhwSH3d_X4w2DVfOWDwDtZKNFlMY3w/edit#gid=0&tq=select A, B where A >= date '2016-01-01'";
  var options = {};
  sendQuery(query, chart, options);
}

function sendQuery(query, chart, options) {
  new google.visualization.Query(query).send(function (response) {
    chart.draw(response.getDataTable(), options);
  });
}

<script src="https://www.gstatic.com/charts/loader.js"></script>
<div id="barchart"></div>
<div id="tablechart"></div>

这篇关于将自定义参数传递给query.send Google查询语言的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！