Codeunit 802 Online Map Management
src/Layers/W1/BaseApp/eServices/OnlineMap/OnlineMapManagement.Codeunit.al598 lines, Copyright (c) Microsoft Corporation. MIT
// ------------------------------------------------------------------------------------------------// Copyright (c) Microsoft Corporation. All rights reserved.// Licensed under the MIT License. See License.txt in the project root for license information.// ------------------------------------------------------------------------------------------------namespace Microsoft.eServices.OnlineMap;using Microsoft.Bank.BankAccount;using Microsoft.CRM.Contact;using Microsoft.Foundation.Address;using Microsoft.Foundation.Company;using Microsoft.HumanResources.Employee;using Microsoft.Inventory.Location;using Microsoft.Projects.Project.Job;using Microsoft.Projects.Resources.Resource;using Microsoft.Purchases.Vendor;using Microsoft.Sales.Customer;using Microsoft.Utilities;using System;codeunit 802 "Online Map Management"{ trigger OnRun() begin end; var OnlineMapSetup: Record "Online Map Setup"; OnlineMapParameterSetup: Record "Online Map Parameter Setup"; ThisAddressTxt: Label '&This address'; DirectionsFromLocationTxt: Label '&Directions from my location'; OtherDirectionsTxt: Label '&Other'; OtherMenuQst: Label '&Directions from my company,Directions to my &company,Directions from &another address,Directions to an&other address';#pragma warning disable AA0074 Text002: Label 'There is no default Map setup.';#pragma warning restore AA0074 ShowMapQst: Label 'Show map with:'; GoToOnlineMapQst: Label 'To get a map with route directions, you must set up the map service on the Online Map Setup page. Do you want to go there now?'; ContiueOpeningMapQst: Label 'Do you want to open the map with route directions?';#pragma warning disable AA0074#pragma warning disable AA0470 Text007: Label 'Table %1 has not been set up to use Online Map.';#pragma warning restore AA0470 Text008: Label 'The specified record could not be found.'; Text015: Label 'Bing Maps';#pragma warning restore AA0074 procedure MakeSelectionIfMapEnabled(TableID: Integer; Position: Text[1000]) var OnlineMapSetupLocal: Record "Online Map Setup"; MapSetupPage: Page "Online Map Setup"; OpenOnlineMap: Boolean; begin OnlineMapSetupLocal.SetRange(Enabled, true); OpenOnlineMap := not OnlineMapSetupLocal.IsEmpty(); if not OpenOnlineMap then if Confirm(GoToOnlineMapQst, true) then begin MapSetupPage.RunModal(); if not OnlineMapSetupLocal.IsEmpty() then OpenOnlineMap := Confirm(ContiueOpeningMapQst, true); end; if OpenOnlineMap then MakeSelection(TableID, Position); end; procedure MakeSelection(TableID: Integer; Position: Text[1000]) var [RunOnClient] LocationProvider: DotNet LocationProvider; MainMenu: Text; Selection: Integer; IsHandled: Boolean; begin IsHandled := false; OnBeforeMakeSelection(MainMenu, TableID, Position, Selection, IsHandled); if IsHandled then exit; if LocationProvider.IsAvailable() then MainMenu := StrSubstNo('%1,%2,%3', ThisAddressTxt, DirectionsFromLocationTxt, OtherDirectionsTxt) else MainMenu := StrSubstNo('%1,%2', ThisAddressTxt, OtherDirectionsTxt); Selection := StrMenu(MainMenu, 1, ShowMapQst); OnMakeSelectionAfterStrMenu(Selection, OnlineMapParameterSetup); case Selection of 1: ProcessMap(TableID, Position); 2: if LocationProvider.IsAvailable() then SelectAddress(TableID, Position, 4) else ShowOtherMenu(TableID, Position); 3: ShowOtherMenu(TableID, Position); end; OnAfterMakeSelection(TableID, Position, Selection); end; local procedure ShowOtherMenu(TableID: Integer; Position: Text[1000]) var Selection: Integer; begin Selection := StrMenu(OtherMenuQst, 1, ShowMapQst); case Selection of 0: MakeSelection(TableID, Position); 1: SelectAddress(TableID, Position, 3); 2: SelectAddress(TableID, Position, 2); 3: SelectAddress(TableID, Position, 1); 4: SelectAddress(TableID, Position, 0); end; end; local procedure ProcessWebMap(TableNo: Integer; ToRecPosition: Text[1000]) var Parameters: array[12] of Text[100]; url: Text[1024]; IsHandled: Boolean; begin GetSetup(); BuildParameters(TableNo, ToRecPosition, Parameters, OnlineMapSetup."Distance In", OnlineMapSetup.Route); url := OnlineMapParameterSetup."Map Service"; SubstituteParameters(url, Parameters); IsHandled := false; OnAfterProcessWebMap(url, IsHandled); if not IsHandled then HyperLink(url); end; local procedure ProcessWebDirections(FromNo: Integer; FromRecPosition: Text[1000]; ToNo: Integer; ToRecPosition: Text[1000]; Distance: Option Miles,Kilometers; Route: Option Quickest,Shortest) var Parameters: array[2, 12] of Text[100]; url: Text[1024]; IsHandled: Boolean; begin GetSetup(); BuildParameters(FromNo, FromRecPosition, Parameters[1], Distance, Route); BuildParameters(ToNo, ToRecPosition, Parameters[2], Distance, Route); if FromNo = Database::Geolocation then begin url := OnlineMapParameterSetup."Directions from Location Serv."; SubstituteGPSParameters(url, Parameters[1]); SubstituteParameters(url, Parameters[2]); end else begin url := OnlineMapParameterSetup."Directions Service"; SubstituteParameters(url, Parameters[1]); SubstituteParameters(url, Parameters[2]); end; IsHandled := false; OnAfterProcessWebDirections(url, IsHandled); if not IsHandled then HyperLink(url); end; procedure ProcessMap(TableNo: Integer; ToRecPosition: Text[1000]) begin TestSetupExists(); ProcessWebMap(TableNo, ToRecPosition); end; procedure ProcessDirections(FromNo: Integer; FromRecPosition: Text[1000]; ToNo: Integer; ToRecPosition: Text[1000]; Distance: Option; Route: Option) begin TestSetupExists(); ProcessWebDirections(FromNo, FromRecPosition, ToNo, ToRecPosition, Distance, Route); end; procedure BuildParameters(TableNo: Integer; RecPosition: Text[1000]; var Parameters: array[12] of Text[100]; Distance: Option Miles,Kilometers; Route: Option Quickest,Shortest) var CompanyInfo: Record "Company Information"; CountryRegion: Record "Country/Region"; OnlineMapSetup: Record "Online Map Setup"; OnlineMapParameterSetup: Record "Online Map Parameter Setup"; i: Integer; IsHandled: Boolean; begin Clear(Parameters); if ValidAddresses(TableNo) then GetAddress(TableNo, RecPosition, Parameters) else Error(Text007, Format(TableNo)); if TableNo = Database::Geolocation then exit; IsHandled := false; OnBuildParametersOnBeforeGetOnlineMapSetup(TableNo, IsHandled); if IsHandled then exit; OnlineMapSetup.Get(); OnlineMapSetup.TestField("Map Parameter Setup Code"); OnlineMapParameterSetup.Get(OnlineMapSetup."Map Parameter Setup Code"); CompanyInfo.Get(); if Parameters[5] = '' then Parameters[5] := CompanyInfo."Country/Region Code"; if CountryRegion.Get(CopyStr(Parameters[5], 1, MaxStrLen(CountryRegion.Code))) then Parameters[6] := CountryRegion.Name; if OnlineMapParameterSetup."URL Encode Non-ASCII Chars" then for i := 1 to 6 do Parameters[i] := CopyStr(URLEncode(Parameters[i]), 1, MaxStrLen(Parameters[i])); Parameters[7] := GetCultureInfo(); if OnlineMapParameterSetup."Miles/Kilometers Option List" <> '' then Parameters[8] := SelectStr(Distance + 1, OnlineMapParameterSetup."Miles/Kilometers Option List"); if OnlineMapParameterSetup."Quickest/Shortest Option List" <> '' then Parameters[9] := SelectStr(Route + 1, OnlineMapParameterSetup."Quickest/Shortest Option List"); end; local procedure GetAddress(TableID: Integer; RecPosition: Text[1000]; var Parameters: array[12] of Text[100]) var Geolocation: Record Geolocation; Location: Record Location; RecordRef: RecordRef; IsHandled: Boolean; begin OnBeforeGetAddress(TableID, RecPosition, Parameters, IsHandled); if IsHandled then exit; RecordRef.Open(TableID); RecordRef.SetPosition(RecPosition); if not RecordRef.Find('=') then Error(Text008); case TableID of Database::Location: begin RecordRef.SetTable(Location); Parameters[1] := Format(Location.Address); Parameters[2] := Format(Location.City); Parameters[3] := Format(Location.County); Parameters[4] := Format(Location."Post Code"); Parameters[5] := Format(Location."Country/Region Code"); end; Database::Customer: SetParameters(RecordRef, Parameters, 5, 7, 92, 91, 35); Database::Vendor: SetParameters(RecordRef, Parameters, 5, 7, 92, 91, 35); Database::"Company Information": SetParameters(RecordRef, Parameters, 4, 6, 31, 30, 36); Database::Resource: SetParameters(RecordRef, Parameters, 6, 8, 54, 53, 59); Database::Job: SetParameters(RecordRef, Parameters, 59, 61, 63, 64, 67); Database::"Ship-to Address": SetParameters(RecordRef, Parameters, 5, 7, 92, 91, 35); Database::"Order Address": SetParameters(RecordRef, Parameters, 5, 7, 92, 91, 35); Database::"Bank Account": SetParameters(RecordRef, Parameters, 5, 7, 92, 91, 35); Database::Contact: SetParameters(RecordRef, Parameters, 5, 7, 92, 91, 35); Database::Employee: SetParameters(RecordRef, Parameters, 8, 10, 12, 11, 25); Database::Geolocation: begin RecordRef.SetTable(Geolocation); Parameters[10] := Format(Geolocation.Latitude, 0, 2); Parameters[11] := Format(Geolocation.Longitude, 0, 2); end; end; OnAfterGetAddress(TableID, RecPosition, Parameters, RecordRef); end; local procedure ValidAddresses(TableID: Integer): Boolean var IsValid: Boolean; begin OnBeforeValidAddress(TableID, IsValid); if IsValid then exit(true); IsValid := TableID in [Database::"Bank Account", Database::"Company Information", Database::Contact, Database::Customer, Database::Employee, Database::Job, Database::Location, Database::Resource, Database::"Ship-to Address", Database::"Order Address", Database::Vendor, Database::Geolocation]; OnAfterValidAddress(TableID, IsValid); exit(IsValid); end; local procedure URLEncode(InText: Text[250]) OutText: Text[250] var SystemWebHttpUtility: DotNet HttpUtility; IsHandled: Boolean; begin IsHandled := false; OnBeforeURLEncode(InText, OutText, IsHandled); if IsHandled then exit; SystemWebHttpUtility := SystemWebHttpUtility.HttpUtility(); exit(CopyStr(SystemWebHttpUtility.UrlEncode(InText), 1, MaxStrLen(InText))); end; local procedure GetCultureInfo(): Text[30] var CultureInfo: DotNet CultureInfo; begin CultureInfo := CultureInfo.CultureInfo(WindowsLanguage); exit(CopyStr(CultureInfo.ToString(), 1, 30)); end; local procedure TestSetupExists(): Boolean var OnlineMapSetup: Record "Online Map Setup"; begin if not OnlineMapSetup.Get() then Error(Text002); exit(true); end; procedure TestSetup(): Boolean var OnlineMapSetup: Record "Online Map Setup"; begin exit(not OnlineMapSetup.IsEmpty); end; local procedure SelectAddress(TableNo: Integer; RecPosition: Text[1000]; Direction: Option "To Other","From Other","To Company","From Company","From my location") var CompanyInfo: Record "Company Information"; OnlineMapSetup: Record "Online Map Setup"; OnlineMapAddressSelector: Page "Online Map Address Selector"; OnlineMapLocation: Page "Online Map Location"; Distance: Option Miles,Kilometers; Route: Option Quickest,Shortest; begin if Direction in [Direction::"To Other", Direction::"From Other"] then begin if not (OnlineMapAddressSelector.RunModal() = ACTION::OK) then exit; if OnlineMapAddressSelector.GetRecPosition() = '' then exit; OnlineMapAddressSelector.Getdefaults(Distance, Route) end else begin OnlineMapSetup.Get(); CompanyInfo.Get(); end; case Direction of Direction::"To Other": ProcessDirections( TableNo, RecPosition, OnlineMapAddressSelector.GetTableNo(), OnlineMapAddressSelector.GetRecPosition(), Distance, Route); Direction::"From Other": ProcessDirections( OnlineMapAddressSelector.GetTableNo(), OnlineMapAddressSelector.GetRecPosition(), TableNo, RecPosition, Distance, Route); Direction::"To Company": ProcessDirections( TableNo, RecPosition, Database::"Company Information", CompanyInfo.GetPosition(), OnlineMapSetup."Distance In", OnlineMapSetup.Route); Direction::"From Company": ProcessDirections( Database::"Company Information", CompanyInfo.GetPosition(), TableNo, RecPosition, OnlineMapSetup."Distance In", OnlineMapSetup.Route); Direction::"From my location": begin OnlineMapLocation.SetRecordTo(TableNo, RecPosition); OnlineMapLocation.Run(); end; end; end; procedure SubstituteParameters(var url: Text[1024]; Parameters: array[12] of Text[100]) var ParameterName: Text; parameterNumber: Integer; ParmPos: Integer; IsHandled: Boolean; begin IsHandled := false; OnBeforeSubstituteParameters(url, Parameters, IsHandled); if IsHandled then exit; for parameterNumber := 1 to ArrayLen(Parameters) do begin ParameterName := StrSubstNo('{%1}', parameterNumber); ParmPos := StrPos(url, ParameterName); if ParmPos > 1 then url := CopyStr( CopyStr(url, 1, ParmPos - 1) + Parameters[parameterNumber] + CopyStr(url, ParmPos + StrLen(ParameterName)), 1, MaxStrLen(url)); end; end; local procedure SubstituteGPSParameters(var url: Text[1024]; Parameters: array[12] of Text[100]) var ParameterName: Text; parameterNumber: Integer; ParmPos: Integer; begin for parameterNumber := 10 to ArrayLen(Parameters) do begin ParameterName := StrSubstNo('{%1}', parameterNumber); ParmPos := StrPos(url, ParameterName); if ParmPos > 1 then url := CopyStr( CopyStr(url, 1, ParmPos - 1) + Parameters[parameterNumber] + CopyStr(url, ParmPos + StrLen(ParameterName)), 1, MaxStrLen(url)); end; end; procedure SetupDefault() var OnlineMapSetup: Record "Online Map Setup"; OnlineMapParameterSetup: Record "Online Map Parameter Setup"; IsHandled: Boolean; begin IsHandled := false; OnBeforeSetupDefault(OnlineMapSetup, OnlineMapParameterSetup, IsHandled); if IsHandled then exit; OnlineMapSetup.DeleteAll(); OnlineMapParameterSetup.DeleteAll(); InsertParam( 'BING', Text015, 'https://bing.com/maps/default.aspx?where1={1}+{2}+{6}&v=2&mkt={7}', 'https://bing.com/maps/default.aspx?rtp=adr.{1}+{2}+{6}~adr.{1}+{2}+{6}&v=2&mkt={7}&rtop={9}~0~0', 'https://bing.com/maps/default.aspx?rtp=pos.{10}_{11}~adr.{1}+{2}+{6}&v=2&mkt={7}&rtop={9}~0~0', false, '', '0,1', 'http://go.microsoft.com/fwlink/?LinkId=519372'); OnlineMapSetup."Map Parameter Setup Code" := 'BING'; OnlineMapSetup.Insert(); end; local procedure InsertParam("Code": Code[10]; Name: Text[30]; MapURL: Text[250]; DirectionsURL: Text[250]; DirectionsFromGpsURL: Text[250]; URLEncode: Boolean; MilesKilometres: Text[250]; QuickesShortest: Text[250]; Comment: Text[250]) var OnlineMapParameterSetup: Record "Online Map Parameter Setup"; begin OnlineMapParameterSetup.Init(); OnlineMapParameterSetup.Code := Code; OnlineMapParameterSetup.Name := Name; OnlineMapParameterSetup."Map Service" := MapURL; OnlineMapParameterSetup."Directions Service" := DirectionsURL; OnlineMapParameterSetup."Directions from Location Serv." := DirectionsFromGpsURL; OnlineMapParameterSetup."URL Encode Non-ASCII Chars" := URLEncode; OnlineMapParameterSetup."Miles/Kilometers Option List" := MilesKilometres; OnlineMapParameterSetup."Quickest/Shortest Option List" := QuickesShortest; OnlineMapParameterSetup.Comment := Comment; OnlineMapParameterSetup.Insert(true); end; [EventSubscriber(ObjectType::Table, Database::"Service Connection", 'OnRegisterServiceConnection', '', false, false)] procedure HandleMAPRegisterServiceConnection(var ServiceConnection: Record "Service Connection") var OnlineMapSetupLocal: Record "Online Map Setup"; [SecurityFiltering(SecurityFilter::Ignored)] OnlineMapSetup2: Record "Online Map Setup"; RecRef: RecordRef; begin if not OnlineMapSetupLocal.Get() then begin if not OnlineMapSetup2.WritePermission() then exit; OnlineMapSetupLocal.Init(); OnlineMapSetupLocal.Insert(); end; RecRef.GetTable(OnlineMapSetupLocal); ServiceConnection.Status := ServiceConnection.Status::Enabled; ServiceConnection.Status := ServiceConnection.Status::Disabled; if OnlineMapSetupLocal.Enabled then ServiceConnection.Status := ServiceConnection.Status::Enabled; ServiceConnection.InsertServiceConnection( ServiceConnection, RecRef.RecordId, OnlineMapSetupLocal.TableCaption(), '', PAGE::"Online Map Setup"); end; local procedure GetSetup() var IsHandled: Boolean; begin IsHandled := false; OnBeforeGetSetup(OnlineMapSetup, OnlineMapParameterSetup, IsHandled); if IsHandled then exit; OnlineMapSetup.Get(); OnlineMapSetup.TestField("Map Parameter Setup Code"); OnlineMapParameterSetup.Get(OnlineMapSetup."Map Parameter Setup Code"); end; procedure SetParameters(var RecordRef: RecordRef; var Parameters: array[12] of Text[100]; AddressFieldNo: Integer; CityFieldNo: Integer; CountyFieldNo: Integer; PostCodeFieldNo: Integer; CountryCodeFieldNo: Integer) var FieldRef: FieldRef; begin FieldRef := RecordRef.Field(AddressFieldNo); Parameters[1] := Format(FieldRef); FieldRef := RecordRef.Field(CityFieldNo); Parameters[2] := Format(FieldRef); FieldRef := RecordRef.Field(CountyFieldNo); Parameters[3] := Format(FieldRef); FieldRef := RecordRef.Field(PostCodeFieldNo); Parameters[4] := Format(FieldRef); FieldRef := RecordRef.Field(CountryCodeFieldNo); Parameters[5] := Format(FieldRef); end; [IntegrationEvent(false, false)] local procedure OnAfterGetAddress(TableID: Integer; RecPosition: Text; var Parameters: array[12] of Text[100]; var RecordRef: RecordRef) begin end; [IntegrationEvent(false, false)] local procedure OnAfterMakeSelection(TableID: Integer; Position: Text[1000]; Selection: Integer) begin end; [IntegrationEvent(false, false)] local procedure OnAfterProcessWebMap(url: Text[1024]; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnAfterProcessWebDirections(url: Text[1024]; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnAfterValidAddress(TableID: Integer; var IsValid: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeMakeSelection(var MainMenu: Text; TableID: Integer; Position: Text[1000]; var Selection: Integer; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeGetAddress(TableID: Integer; RecPosition: Text; var Parameters: array[12] of Text[100]; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeGetSetup(var OnlineMapSetup: Record "Online Map Setup"; var OnlineMapParameterSetup: Record "Online Map Parameter Setup"; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeSetupDefault(var OnlineMapSetup: Record "Online Map Setup"; var OnlineMapParameterSetup: Record "Online Map Parameter Setup"; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeSubstituteParameters(var url: Text[1024]; Parameters: array[12] of Text[100]; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeValidAddress(TableID: Integer; var IsValid: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeURLEncode(InText: Text[250]; var OutText: Text[250]; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnMakeSelectionAfterStrMenu(var Selection: Integer; var OnlineMapParameterSetup: Record "Online Map Parameter Setup") begin end; [IntegrationEvent(false, false)] local procedure OnBuildParametersOnBeforeGetOnlineMapSetup(TableNo: Integer; var IsHandled: Boolean) begin end;}