Javascript地图过滤器问题



现在我正在使用Google Maps JavaScript API V3来过滤地图结果。我有两个javascript下拉菜单。当选择一个下拉选项值时,映射将筛选到该设置。因此,如果我选择业务类型"Social Services",地图将只显示这种类型的业务。第二个过滤器针对不同的主题。因此,如果第二个下拉菜单被选中,它将过滤到这个选项值。问题是,当选择第二个或第一个时,它在过滤时忽略了另一个。例如,我希望用户能够从第一个菜单过滤"社会服务",从第二个菜单过滤"机会"。这将显示满足这两个条件的位置。目前,用户只能选择其中之一。

页面如下:

LTI地图

代码如下:

    <html> 
<head> 
<meta name="viewport" content="initial-scale=1.0, user-scalable=no" /> 
<meta http-equiv="content-type" content="text/html; charset=UTF-8"/> 
<!DOCTYPE html>
<title>Met Sacramento Internship Map</title> 
<!-- Style --> 
<style> 
  body { font-family: Arial, sans-serif; }
  #map_canvas { height: 500px; width:600px; }
</style> 
<script type="text/javascript" src="http://maps.google.com/maps/api/js?sensor=false"></script> 
<script type="text/javascript"> 
    var tableid = 567682;
    var layer = new google.maps.FusionTablesLayer(567682); 
  function initialize() {
    var latlng = new google.maps.LatLng(38.59970036588819, -121.541748046875);
    var myOptions = {
      zoom: 8,
      center: latlng,
      mapTypeId: google.maps.MapTypeId.ROADMAP
    };
    var map = new google.maps.Map(document.getElementById("map_canvas"),
        myOptions);
          layer.setMap(map);
  }
    //Change the query based on the user's selection
function interestMap(interest) {
 layer.setQuery("SELECT Address, 'Interest Area' FROM " + tableid + " WHERE 'Interest Area' CONTAINS '" + interest + "'"); 
}
function statusMap(status) {
 layer.setQuery("SELECT Address, 'Status' FROM " + tableid + " WHERE 'Status' CONTAINS '" + status + "'"); 
}
</script>
 </script> 
</head> 
<body onload="initialize();">  
  Internship Status <select onchange="interestMap(this.value);"> 
    <option value="">Interest Areas</option>
<option value="Aerospace">Aerospace</option>
<option value="Animals">Animals</option>
<option value="Architecture">Architecture</option>
<option value="Art/Music/Theatre">Art/Music/Theatre</option>
<option value="Athletics and Martial Arts">Athletics</option>
<option value="Automotive and Transportation">Automotive</option>
<option value="Business">Business</option>
<option value="Community Development">Community Development</option>
<option value="Computers">Computers</option>
<option value="Cosmetology">Cosmetology</option>
<option value="Culinary">Culinary</option>
<option value="Education">Education</option>
<option value="Government and Politics">Politics</option>
<option value="Health Science">Health Science</option>
<option value="Hospitality/Tourism/Event Planning">Event Planning</option>
<option value="Law and Public Safety">Law and Public Safety</option>
<option value="Marketing">Marketing</option>
<option value="Media and Information Technology">Media</option>
<option value="Photography">Photography</option>
<option value="Science and Technology">Science and Technology
</option>
<option value="Social Services">Social Services</option>
  </select>
   Status <select onchange="statusMap(this.value);"> 
    <option value="">Status</option>
<option value="BEING PURSUED">Being Pursued</option>
<option value="HAS INTERN">Has Intern</option>
<option value="NOT TAKING">Not Taking</option>
<option value="OPPORTUNITY">Opportunity</option>
<option value="OVER 18">Over 18</option>
<option value="POTENTIAL?">Potential</option>
<option value="SEE NOTES">See Notes</option>

  </select>
  <div id="map_canvas"></div>
</body> 
</html>

谢谢你的帮助。

我将创建一个基于两个下拉列表中的值进行过滤的函数,而不是有两个不同的过滤函数。

像这样:

function filterResults(){
    var interest = document.getElementById('ddl-interest').value;
    var status = document.getElementById('ddl-status').value;
    layer.setQuery("SELECT Address, 'Interest Area' FROM " + tableid + 
    " WHERE 'Interest Area' CONTAINS '" + interest + "' AND 'Status' CONTAINS '" + status + "'");
}

然后你显然需要给你的下拉列表id 'ddl-interest'和'ddl-status'和调用'filterResults'方法在onchange事件。

最新更新