DIV CSS 佈局教程網

整合百度地圖:產品銷售單位位置查看功能的設計與實作
編輯:關於JavaScript     

這個功能來自一個實際專案:食品安全監管系統(MVC5 + EF6 + Bootstrap3)。需求是從某一批產品出發,看它被賣到了哪些省市、各有幾家單位,並在地圖上標出這些單位的位置。以下是實作過程與幾個關鍵設計決策。

一、需求描述

先查產品生產批次資訊,再依批次統計銷售流向。地圖部分需要完成兩件事:依省市聚合單位數量,以及把每個單位的地址轉成座標後標記在地圖上。

二、產品生產批次查詢

從批次列表進入後,可以看到該批產品的詳細資訊。

三、產品銷售地圖

左側表格列出省市與單位家數,右側地圖顯示對應位置。點擊表格中的某一列,地圖會重新定位到該省市並標記其中所有單位。

四、View 層實作

畫面採用左右分割:左邊是 DataTables 表格,右邊是地圖容器。工具列提供「返回列表/上一條/下一條」的導覽。

@{
    ViewBag.Title = "Index";
    Layout = "~/Views/Shared/_TableLayout.cshtml";
}

@*工具欄*@
@section actionBar{
  <button class="btn dark btn-outline btn-circle btn-sm" data-bind="click: returnCommand" id="btnCancel">返回列表</button>
  <button class="btn dark btn-outline btn-circle btn-sm" data-bind="click: prevCommand" id="btnPrev">上一條</button>
  <button class="btn dark btn-outline btn-circle btn-sm" data-bind="click: nextCommand" id="btnNext">下一條</button>
}

@section CustomContent {
<form id="frmObj" name="frmObj" class="form-horizontal form-table-bordered" enctype="multipart/form-data">
  <div class="form-body">

    <div class="portlet box blue">
      <div class="portlet-title">
        <div class="caption"><i class="fa fa-gift"></i>產品生產資訊 </div>
        <div class="tools"><a href="javascript:;" class="collapse"></a></div>
      </div>
      <div class="portlet-body">
        <input type="hidden" id="Id"        name="Id"        data-bind="value:viewmodel.Id" />
        <input type="hidden" id="OrgId"     name="OrgId"     data-bind="value:viewmodel.OrgId" />
        <input type="hidden" id="ProductId" name="ProductId" data-bind="value:viewmodel.ProductId" />

        <div class="form-body">
          <div class="form-group">
            <label class="col-md-1 control-label">備案單位 <span class="required"> * </span></label>
            <div class="col-md-5">
              <input type="text" readonly="readonly" class="form-control"
                     data-bind="value: viewmodel.OrgName" name="OrgName" id="OrgName" />
            </div>
            <label class="col-md-1 control-label">產品名稱 <span class="required"> * </span></label>
            <div class="col-md-5">
              <input type="text" readonly="readonly" class="form-control"
                     data-bind="value: viewmodel.ProductName" name="ProductName" id="ProductName" />
            </div>
          </div>

          <div class="form-group">
            <label class="col-md-1 control-label">生產批號 <span class="required"> * </span></label>
            <div class="col-md-2">
              <input type="text" readonly="readonly" class="form-control"
                     name="BatchNumber" id="BatchNumber" data-bind="value: viewmodel.BatchNumber" />
            </div>
            <label class="control-label col-md-1">注冊日期</label>
            <div class="col-md-2">
              <input type="text" readonly="readonly" class="form-control"
                     name="RegDate" id="RegDate" data-bind="value: viewmodel.RegDate" />
            </div>
            <label class="control-label col-md-1">生產日期</label>
            <div class="col-md-2">
              <input type="text" readonly="readonly" class="form-control"
                     name="ProductMakeDate" id="ProductMakeDate" data-bind="value: viewmodel.ProductMakeDate" />
            </div>
            <label class="control-label col-md-1">過期日期</label>
            <div class="col-md-2">
              <input type="text" readonly="readonly" class="form-control"
                     name="ProductExpDate" id="ProductExpDate" data-bind="value: viewmodel.ProductExpDate" />
            </div>
          </div>
        </div>
      </div>
    </div>

    <div class="portlet box blue">
      <div class="portlet-title">
        <div class="caption"><i class="fa fa-gift"></i>銷售地圖 </div>
        <div class="tools"><a href="javascript:;" class="collapse"></a></div>
      </div>
      <div class="portlet-body">
        <div class="form-body form-group">
          <div class="col-md-5">
            <table class="table table-striped table-bordered table-hover dt-responsive" id="myDataGrid">
              <thead>
                <tr><th>省市</th><th>市區</th><th>單位家數</th></tr>
              </thead>
            </table>
          </div>
          <div class="col-md-7">
            <div style="height:500px;border:1px solid gray" id="divMap"></div>
          </div>
        </div>
      </div>
    </div>

  </div>
</form>
}

五、地圖初始化與標記邏輯

JavaScript 部分以 Knockout 做資料綁定,地圖操作則集中在幾個方法裡。

@section customScript {
<script src="~/Scripts/page/share/_SecondTableLayout.js"></script>
<script type="text/javascript">
var mDataGrid = function () {

  var TableViewModel = SecondTableLayoutViewModel.extend({
    constructor: function (ViewModel) {
      this.base(ViewModel, undefined);

      own.viewmodel = ko.mapping.fromJS(ViewModel);
      own.btnAddVisible = false;
      own.btnEditVisible = false;
      own.btnDelVisible = false;
      own.Caption("生產批號 - " + ViewModel.BatchNumber);

      own.loadTableData(own.tableOptions, ViewModel.ProductID, ViewModel.Id);
      own.ProductId = ViewModel.ProductID;
      own.CurrentId = ViewModel.Id;
      own.InitMap();
    },

    viewmodel: null,
    ProductId: null,
    CurrentId: null,
    PrevId: null,
    NextId: null,
    bMap: null,

    tableOptions: {
      src: $("#myDataGrid"),
      dataTable: {
        "ajax": {
          "url": "/Basic/ProductBatch/GetBAreaStatistics",
          "type": "GET"
        },
        "columns": [
          { "data": "ProvinceName" },
          { "data": "CityName" },
          { "data": "Amount" }
        ]
      }
    },

    loadTableData: function (options, ProductId, BatchId) {
      if (own.grid != undefined) return;

      var table = own.getTable();
      table.clearAjaxParams();
      table.addAjaxParam("ProductId", ProductId);
      table.addAjaxParam("BatchId", BatchId);

      var tableSetting = $.extend({}, {
        onSuccess:  function (grid, response) { own.table_on_success(grid, response); },
        onError:    function (grid)          { own.table_on_error(grid); },
        onDataLoad: function (grid)          { own.table_on_dataload(grid); },
        dataTable: { "bStateSave": true },
        rowClick:  function (grid, rowData)  { own.tableRowClick(grid, rowData); }
      }, options);

      //記下 loadUrl,自刷新時使用
      own.loadUrl = tableSetting.dataTable.ajax.url;
      table.init(tableSetting);
    },

    InitMap: function () {
      //建立 Map 實例
      bMap = new BMap.Map("divMap");
      var point = new BMap.Point(118.060576, 36.842432);
      bMap.centerAndZoom("山東省禹城市", 15);

      //滑鼠滾動縮放
      bMap.enableScrollWheelZoom();
      //縮略圖控件
      bMap.addControl(new BMap.OverviewMapControl({ isOpen: false, anchor: BMAP_ANCHOR_BOTTOM_RIGHT }));
      //縮放平移控件
      bMap.addControl(new BMap.NavigationControl());
      //比例尺控件
      bMap.addControl(new BMap.ScaleControl());
      //地圖類型控件(視需要啟用)
      //bMap.addControl(new BMap.MapTypeControl());
    },

    LoadMap: function (cityName, listEnter) {
      //重新定位城市
      bMap.centerAndZoom(cityName, 12);
      for (var i = 0; i < listEnter.length; i++) {
        own.LoadMarker(cityName, listEnter[i]);
      }
    },

    LoadMarker: function (cityName, enterinfo) {
      //為該城市的單位做標記
      var mGeocoder = new BMap.Geocoder();
      var mAddress = enterinfo.Address;

      //地址為空時,退回用「區域名 + 街道名」組出可查詢的地址
      if (enterinfo.Address == "") {
        mAddress = enterinfo.AreaName + enterinfo.StreetName;
      }
      if (mAddress == "") return;

      mGeocoder.getPoint(mAddress, function(point){
        if (point) {
          var mPoint = new BMap.Point(point.lng, point.lat);
          var marker = new BMap.Marker(mPoint);
          bMap.addOverlay(marker);
          marker.setLabel(new BMap.Label(enterinfo.EnterName, { offset: new BMap.Size(20, -10) }));

          var content = "<table>";
          content += "<tr><td>名稱:" + enterinfo.EnterName + "</td></tr>";
          content += "<tr><td>地址:" + mAddress + "</td></tr>";
          content += "</table>";

          var infowindow = new BMap.InfoWindow(content);
          marker.addEventListener("click", function () {
            this.openInfoWindow(infowindow);
          });
        }
      }, cityName);
    },

    tableRowClick: function (grid, rowData) {
      if (rowData == undefined) return;

      $.post("/Basic/ProductBatch/GetBEnterStatistics", {
        ProductId:    own.ProductId,
        BatchId:      own.CurrentId,
        ProvinceName: rowData.ProvinceName,
        CityName:     rowData.CityName
      }, function (result) {
        if (result.ResultType != undefined) return;
        //重新載入地圖
        own.LoadMap(rowData.ProvinceName + "" + rowData.CityName, result.data);
      });

      this.base(grid, rowData);
    },

    returnCommand: function () {
      App.jumpTo({ url: "/Basic/ProductBatch/Index", data: { Id: this.CurrentId } });
    },

    prevCommand: function () {
      if (this.PrevId == undefined || this.PrevId == null || this.PrevId == "") {
        alert("上一條為空,已沒有其它結果!");
        return;
      }
      App.jumpTo({ url: "/Basic/ProductBatch/IndexMap",
                   data: { ProductId: this.ProductId, BatchId: this.PrevId } });
    },

    nextCommand: function () {
      if (this.NextId == undefined || this.NextId == null || this.NextId == "") {
        alert("下一條為空,已沒有其它結果!");
        return;
      }
      App.jumpTo({ url: "/Basic/ProductBatch/IndexMap",
                   data: { ProductId: this.ProductId, BatchId: this.NextId } });
    }
  });

  return {
    init: function (ViewModel, PrevId, NextId) {
      SecondTableLayoutViewModel.resetKoBindID("divIndexView");
      var node = document.getElementById("divIndexView");
      ko.cleanNode(node);

      var mTableViewModel = new TableViewModel(ViewModel);
      mTableViewModel.ProductId = ViewModel.ProductID;
      mTableViewModel.PrevId = PrevId;
      mTableViewModel.NextId = NextId;
      ko.applyBindings(mTableViewModel, node);
    }
  };
}();

jQuery(document).ready(function () {
  var mPrevId = "@ViewBag.PrevId";
  var mNextId = "@ViewBag.NextId";
  mDataGrid.init(@Html.Raw(ViewBag.ViewModel), mPrevId, mNextId);
});
</script>
}

六、Controller 層

Controller 負責組裝 ViewModel、計算上下一筆的 ID,並提供兩個給前端 AJAX 呼叫的聚合端點。

#region 銷售地圖

public ActionResult IndexMap(Guid ProductId, Guid BatchId)
{
    try
    {
        List<ProductBatchViewModel> list =
            _IProductBatchs.GetEntityList(t => t.IsDelete == false && t.ProductID == ProductId);

        ProductBatchViewModel mViewModel = null;
        string mPrevId = string.Empty, mNextId = string.Empty;

        //讀取當前任務及上、下一筆的標識
        for (int index = 0; index < list.Count; index++)
        {
            if (list[index].Id == BatchId)
            {
                mViewModel = list[index];
                if (list.Count > index + 1) mNextId = list[index + 1].Id.ToString();
                break;
            }
            mPrevId = list[index].Id.ToString();
        }

        if (mViewModel == null)
        {
            return this.ResultError("產品生產資訊不能為空!");
        }

        ViewBag.bCreate = 0;
        ViewBag.ProductId = ProductId;
        ViewBag.PrevId = mPrevId;
        ViewBag.NextId = mNextId;
        ViewBag.ViewModel = mViewModel.ToViewModel();
        return View("_IndexMap");
    }
    catch (Exception e)
    {
        return this.ResultError(e.Message);
    }
}

[Import(typeof(IProductBatchSup))]
public IProductBatchSup _IProductBatchSup;

/// 依省市聚合單位家數
public ActionResult GetBAreaStatistics(Guid ProductId, Guid BatchId)
{
    try
    {
        ReturnResult mReturn = _IProductBatchSup.GetBAreaStatistics(ProductId, BatchId);
        if (mReturn.State == false) return this.ResultError(mReturn.Message);
        return JsonNetResult.toDataTable(mReturn.Result);
    }
    catch (Exception e)
    {
        return this.ResultError(e.Message);
    }
}

/// 依省市取得該區域下的單位清單
public ActionResult GetBEnterStatistics(Guid ProductId, Guid BatchId, string ProvinceName, string CityName)
{
    try
    {
        ReturnResult mReturn =
            _IProductBatchSup.GetBEnterStatistics(ProductId, BatchId, ProvinceName, CityName);
        if (mReturn.State == false) return this.ResultError(mReturn.Message);
        return JsonNetResult.toDataTable(mReturn.Result);
    }
    catch (Exception e)
    {
        return this.ResultError(e.Message);
    }
}

#endregion

七、幾個實作上的關鍵考量

1. 地址轉座標要指定城市,避免誤判

Geocoder.getPoint() 的第三個參數是城市名稱。這一步很重要——同一個「中山路」在全國有幾百條,不指定城市會大量誤命中。範例中把省市名拼起來傳入,就是為了縮小地理檢索的範圍。

2. 地址為空時要有退路

程式裡先檢查 Address,若為空就改用「區域名 + 街道名」組合。這個防禦是必要的——地圖標記失敗不該讓整個頁面掛掉。

3. 重新定位前應清除舊標記

目前 LoadMap() 直接疊加新標記。使用者連續點擊幾個省市之後,圖上會殘留先前區域的標記。實務上應該在重新載入前先清掉:

bMap.clearOverlays();

4. Geocoder 有速率限制

百度地圖的地理編碼介面有每日呼叫量與併發限制。若單一省市下的單位數量大(例如幾十家),迴圈逐一呼叫可能觸發限流。比較穩健的做法是後端先批次轉好座標存進資料庫,前端直接拿座標畫點,完全不依賴即時地理編碼。

5. 資訊視窗的 XSS 風險

content 是用字串拼接 HTML,而 enterinfo.EnterName 與 mAddress 都來自資料庫。如果這些欄位可能包含使用者輸入,就存在 XSS 風險。建議改用 DOM API 建立節點,或在拼接前做 HTML 轉義。

XML學習教程| jQuery入門知識| AJAX入門| Dreamweaver教程| Fireworks入門知識| SEO技巧| SEO優化集錦|
Copyright © DIV+CSS佈局教程網 All Rights Reserved