个人中心
gpt4 book ai didi

javascript - Google fusion table查询错误-时间比较

转载 作者：行者123 更新时间：2023-11-28 08:25:24 25 4
gpt4 key购买 nike 

    <!DOCTYPE html>
<html>
<head>
<script src="http://maps.googleapis.com/maps/api/js?key=AIzaSyAB-b8aFHZ7a8tICmAbPEhQgQ2Uvf8t1zg&libraries=visualization,places&sensor=false"></script>
<script src="https://www.google.com/fusiontables/DataSource?docid=16IJZkJaz4jlZZnZYsiQEG4POvB0eHBEfuVFGWb3m"></script>
<style type="text/css">
html {height:100%}
body {height: 100%; margin:500;padding:0}
#title {height:80px; margin-top:20px; }
#options{height:50px;}
#time1{width:95px}
#time2{width:95px}
#googleMap{margin-left:325px; margin-top:50px; width: 950px; height: 800px} 
#type-selector {color: #fff;background-color: #4d90fe;padding: 5px 11px 0px 11px;}
#type-selector label {font-family: Roboto;font-size: 13px;font-weight: 300;}
.controls {
        margin-top: 16px;
        border: 1px solid transparent;
        border-radius: 2px 0 0 2px;
        box-sizing: border-box;
        -moz-box-sizing: border-box;
        height: 32px;
        outline: none;
        box-shadow: 0 2px 6px rgba(0, 0, 0, 0.3);
      }
#pac-input {
        background-color: #fff;
        padding: 0 11px 0 13px;
        width: 400px;
        font-family: Roboto;
        font-size: 15px;
        font-weight: 300;
        text-overflow: ellipsis;
      }

      #pac-input:focus {
        border-color: #4d90fe;
        margin-left: -1px;
        padding-left: 14px;  /* Regular padding-left + 1. */
        width: 401px;
      }

</style>
</head>

<body>

<script type="text/javascript">

var map;   //global variable so can be used by all functions to update the map
var tableid='16IJZkJaz4jlZZnZYsiQEG4POvB0eHBEfuVFGWb3m'; //fusion tableid to access the database table
function initialize(){
    google.maps.visualRefresh = true;
var mapProp = {
  center: new google.maps.LatLng(19.119118,73.048439),
  zoom:11,
  scaleControl: true,
  streetViewControl:false,
  mapTypeId:google.maps.MapTypeId.ROADMAP
    };

  //create a new map in div element
  map=new google.maps.Map(document.getElementById("googleMap"),mapProp);

  //add bounds to display search results within mumbai
 var defaultBounds = new google.maps.LatLngBounds(
      new google.maps.LatLng(19.300572, 72.768631),
      new google.maps.LatLng(18.975029, 73.186455));
      map.fitBounds(defaultBounds);

  // Create the search box and link it to the UI element.
  var input =(document.getElementById('pac-input'));
  map.controls[google.maps.ControlPosition.TOP_LEFT].push(input);

  var searchBox = new google.maps.places.SearchBox((input));

  // Listen for the event fired when the user selects an item from the
  // pick list. Retrieve the matching places for that item.
  google.maps.event.addListener(searchBox, 'places_changed', function() {
    var places = searchBox.getPlaces();
    var markers = [];

    for (var i = 0, marker; marker = markers[i]; i++) {
      marker.setMap(null);
    }

    // For each place, get the icon, place name, and location.
    markers = [];
    var bounds = new google.maps.LatLngBounds();

    for (var i = 0, place; place = places[i]; i++) {
      var image = {
        url: place.icon,
        size: new google.maps.Size(71, 71),
        origin: new google.maps.Point(0, 0),
        anchor: new google.maps.Point(17, 34),
        scaledSize: new google.maps.Size(25, 25)
      };

      // Create a marker for each place.
      var marker = new google.maps.Marker({
        map: map,
        icon: image,
        title: place.name,
        position: place.geometry.location
      });

      markers.push(marker);
    bounds.extend(place.geometry.location);
    }
    map.fitBounds(bounds);
  });

  // Bias the SearchBox results towards places that are within the bounds of the current map's viewport.
  google.maps.event.addListener(map, 'bounds_changed', function() {
    var bounds = map.getBounds();
    searchBox.setBounds(bounds);
   });  
}  //end of initialize
var i=0;

 function allmarks(opt)
{
    switch(opt)
    {
    case "None":
    document.getElementById("Timerange").style.display = "none";
    document.getElementById("Raterange").style.display = "none"; 
    initialize();
    break;

    case "All":
    document.getElementById("Timerange").style.display = "none";
    document.getElementById("Raterange").style.display = "none"; 
    while (i!=0){layer.setMap(null);i--;}

    layer = new google.maps.FusionTablesLayer({
    query: {select: 'Latitude',
      from: tableid}});

  layer.setMap(map);
  i++;
  break;

  case "Time" : document.getElementById("Timerange").style.display = "block";
                document.getElementById("Raterange").style.display = "none"; 
                layer.setMap(null);
                break;

  case "Rating" : document.getElementById("Raterange").style.display = "block";
                  document.getElementById("Timerange").style.display = "none"; 
                  layer.setMap(null);
                  break;
    } //end of switch
  } //end of allmarks


  function timefunc()
  {     //function to retrive the input values and  fire query on fusion table
      var x = document.getElementById("time1").value;
      var y = document.getElementById("time2").value;

      var whereClause = 'Time >'+x+' AND Time<='+y; 
      alert(whereClause);

      while (i!=0){layer.setMap(null);i--;}

     layer = new google.maps.FusionTablesLayer({
    query: {
      select: 'Latitude,Longitude,Time,Rating',
      from: tableid,
      where: whereClause
    }
  });
  layer.setMap(map);
  i++;
      }

    function ratefunc()
    {   //function to retrive the input values and  fire query on fusion table
      var k = document.getElementById("rate1").value;
      var l = document.getElementById("rate2").value;
      var a=1;
      var b=5;
      while (i!=0){layer.setMap(null);i--;}


      if(k>5||l>5)
      {alert("Please enter a value between 1 and 5");}
      if(k>l)
      {alert("Please enter a valid range");}

       layer = new google.maps.FusionTablesLayer({
    query: {
      select: 'Latitude,Longitude,Time,Rating',
      from: tableid,
    where:"Rating >"+k+" AND Rating <="+l
    }
  });
  layer.setMap(map);
  i++; }
</script>

<body onload="initialize()">

<div id="title"><h1><center> Visualisation of Parking Requests</center></h1> </div>

<div id="options"> 
<form>
<h3 align="center">Display:
<select name="sortby" onChange="allmarks(this.value)">
<option id="None" value="None">None</option>
<option id="All" value="All"  >All</option>
<option id="Time" value="Time">Time</option>
<option id="Rating" value="Rating">Rating</option>
</select>


<div id="Timerange" style="display:none">
Enter a Time range: <input id="time1" type="time" name="time1">
to : <input id="time2" type="time" name="time2">
<input type="button" name="submit" value="Submit" onclick="timefunc()"/>
</div>

<div id="Raterange" style="display:none">
Enter a Rating range : <input id="rate1" type="number" name="rating1" min="0" max="5" step="0.1" value="1">
to : <input id="rate2"  type="number" name="rating2" min="0" max="5" step="0.1" value="5">

<input type="button" name="submit1" value="Submit" onclick="ratefunc()"/>
</div>
</h3></form></div>

<input id="pac-input" class="controls" type="text" placeholder="Search Box">
<div id="googleMap"></div>

</body>
</html>

我正在开发一个简单的 html 程序，它有一个下拉菜单，其中包含选项“无”、“全部”、“时间”和“评级”。我正在使用 Google 融合表，其中的列具有随机生成的值。列是 Cid、纬度、经度、时间和评级。

当我选择“全部”时。谷歌融合表中的所有点都显示在 map 上，当我选择“评级”时，我可以输入特定范围的值，然后使用这些约束进行查询。当我尝试对“时间”做同样的事情时，我遇到了问题。在函数“timefunc()”中，查询的 where 子句无法正确执行。我在执行过滤后尝试使用 Fusion 表的发布选项，但这没有帮助。

如何克服这个问题？我需要它来显示用户在输入框中输入的时间，但我似乎无法构造适当的查询来运行并显示正确的结果。

最佳答案

我没有在文档中找到有关它的详细信息，但似乎您必须显式地将值作为字符串传递:

var whereClause = "Time >'"+x+"' AND Time<='"+y+"'";

注意:您必须在输入字段中使用格式hh:ss

关于javascript - Google fusion table查询错误-时间比较，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/22488007/

25 4 0
文章推荐： javascript - 在新选项卡而不是弹出窗口中打开网址(单击后)
文章推荐： ios - SWRevealViewController segue 只用 1 个按钮卡住
文章推荐： c++ - C Web 服务器和 Chrome 开发工具问题
文章推荐： javascript - 如何使用 animate 和scrollTop 将浏览器窗口的滚动条或 div 滚动条设置为增量滚动？
行者123
个人简介

我是一名优秀的程序员,十分优秀！

滴滴打车优惠券免费领取
滴滴打车优惠券
全站热门文章
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com