<apex:page standardController="Lead" extensions="ldControllerV2">
    
    <apex:form >
        <apex:pageBlock title="Partner in der Umgebung">
       
          
            <apex:panelGrid columns="2">
           <apex:pageBlockSection >
                <apex:pageBlockSection title="Potenzieller Kunde" >

                  <apex:outputLabel value="{!$ObjectType.Lead.Fields.Name.label}" />{!Lead.Salutation} {!Lead.name} <br />
                  <apex:outputLabel value="{!$ObjectType.Lead.Fields.Address.label}" /> 
                  {!Lead.Street} <br />
                  {!Lead.City} <br />
                   {!Lead.PostalCode} <br />
                <apex:outputLabel value="{!$ObjectType.Lead.Fields.Phone.label}" />{!Lead.Phone} <br />
                <apex:outputLabel value="{!$ObjectType.Lead.Fields.EnergySource__c.label}" />{!Lead.EnergySource__c} <br />
         
    
                
                </apex:pageBlockSection>
              
              
   <apex:pageBlockSection title="Partner-Map">
     <!-- Display the address on a map -->
 <apex:map width="600px" height="400px" mapType="roadmap" zoomLevel="11" center="{!Lead.Street},{!Lead.City},{!Lead.State}" rendered="true">
  <apex:mapMarker title="{!Lead.Name} " icon="{!URLFOR($Resource.UserIcon)}" position="{latitude:{!Lead.Latitude}, longitude:{!Lead.Longitude}}"></apex:mapMarker>    
  <apex:repeat value="{!accounts }" var="a">
      <apex:mapMarker title="{!a.Name} - {!a.Skills__c}" position="{latitude:{!a.ShippingLatitude},longitude:{!a.ShippingLongitude}}"/>
  </apex:repeat>     
 </apex:map>
     </apex:pageBlockSection>
            </apex:pageBlockSection>
                </apex:panelGrid>
                   

             <apex:pageBlockSection title="Partner nach Entfernung" id="results" columns="1" >
                 
                           
                 
            <apex:pageBlockTable value="{!accounts}" var="a" width="200%" >
             <apex:column value="{!distances[a.id]}"> <apex:facet name="header">Entfernung</apex:facet></apex:column>
            <apex:column value="{!a.Priority__c}"/>
                <apex:column value="{!a.name}"/>    
         
            <apex:column value="{!a.ShippingStreet}"/>
            <apex:column value="{!a.ShippingCity}"/>
                 <apex:column value="{!a.phone}"/>
               
            <apex:column value="{!a.Skills__c}"/> 
               
                
               
                

            <apex:column >
                <apex:commandLink title="Zuordnen" value="Zuordnen" action="{!processButtonClick}">
             <apex:param name="heatingInstallerID" value="{!a.id}"/>
                </apex:commandLink>
                </apex:column>
             
            </apex:pageBlockTable>
        </apex:pageBlockSection>
         
            
    </apex:pageBlock>
    </apex:form>
</apex:page>

public class ldControllerV2 {
    
    //Lead-Informationen
    public Lead leadRecord{get;set;}
    Decimal leadLatitude ;
    Decimal leadLongitude ;
    
    //Account-Informationen
    public List<Account> acc {get;set;}
    String[] skills{get;set;}
    
    //Condition for a Method
    boolean hasCondition = false;
    
    //Map with Distances
   public Map<String, String> distances{get;set;}
    
    
    //String with Queries 
    String query = 'SELECT Id, Name, ShippingLatitude, ShippingLongitude, ShippingAddress, ShippingStreet, ShippingCity, ShippingState, Phone, Skills__c, Priority__c FROM Account WHERE RecordTypeId=\'01258000000ATCX\' AND ShippingLatitude!=null AND Priority__c !=null' ;
    String recordId = '01258000000ATCX';
  
    //Constructor, assign a List of Accounts, Distances and imports the lead account
    public ldControllerV2(ApexPages.StandardController sc)
    {
        
        acc = new List<Account>();
        this.leadRecord = (Lead) sc.getRecord();        
        this.distances = new Map<String, String>();

       
        if(leadRecord.id != null && leadRecord!=null)
        {
            leadRecord = [select Name,Latitude,Longitude, EnergySource__c from lead where id =:leadRecord.id ];
            leadLatitude  = leadRecord.Latitude;
            leadLongitude = leadRecord.Longitude;
            skills = leadRecord.EnergySource__c.split(';');
        }
    }
    
    public List<Account> getAccounts(){

        //'GEOLOCATION(' + leadLatitude + ', ' + leadLongitude + '), ' +
       
        if(!skills.isEmpty())
      {
            hasCondition =true;
            query += ' AND Skills__c includes (\''+skills[0]+'\'';
      skills.remove(0);
        }
        while(!skills.isEmpty()){
            query +=',\''+skills[0]+'\'';
            skills.remove(0);
        }
    
      if(hasCondition) query +=')';
        hasCondition = false;
      
        Acc = Database.query(query+
                             ' ORDER BY DISTANCE(ShippingAddress, GEOLOCATION(' + leadLatitude + ', ' + leadLongitude + '), \'km\') '+
                             'limit 20');   
        resolveDistances();
        
        return Acc;
    }
    
    
     public PageReference processButtonClick() {
        
    ID heatingInstallerID = System.currentPageReference().getParameters().get('heatingInstallerID');
        leadRecord.ZH_Account__c = heatingInstallerID;
         
         update leadRecord;
         PageReference pg = new PageReference('/'+ leadRecord.Id);
        pg.setRedirect(true);
        return pg;
         
    }
    
    
    public void resolveDistances(){
        
        for(Account a : acc) {
      
            Location accLoc = Location.newInstance(a.ShippingLatitude, a.ShippingLongitude);
            Location leadLoc = Location.newInstance(leadRecord.Latitude, leadRecord.Longitude);
            Integer distance = (Integer) accLoc.getDistance(leadLoc, 'km');
            String km = distance+' km';
            
            this.distances.put(a.ID, km);
        }
        
    }

    public void resolveDistance(Account a){
    
    
    }
    
    
}