ico-magnifying_glass
    ico-arrow-big-left

    Salesforce Mashup with jQuery & Google Maps

    PRIZES

    1st

    $2,500

    2nd

    $750

    3rd

    $250

    Register
    Submit
    The challenge is finished.
    Show Deadlinesicon-arrow-up

    Challenge Overview

    Create a Visualforce page that displays sales data on a Google map. Initially display the map for the entire United States. The user will then be able to enter a Country (required), State/Province and City to narrow the addresses that are displayed on the map.
    ��
    Users will be able to filter the results displayed by:
    ��
    1. Project size: a slider from 0 - 250+
    2. Year: a beginning and end year
    3. Type: any combination of the three types
    ��
    There could be multiple sales at the same physical address but the search should return a resultset of distinct addresses that are plotted on the map. When the user clicks on a pin it will populate the right pane with all of the sales for that location. Selecting an individual sales from the right pane will open that record in a new window displaying.
    ��
    For a list of countries to display in the picklist, install the AddressTools package from the AppExchange.
    ��
    For demo purposes, only show sample data for US, Germany and Japan. If you need to geocode records in Salesforce, you can either do so manually or use the results of our SimpleGeo Geolocation Toolkit.
    ��
    The query for sales data is dependent upon the country being searched. The US uses a ���Sales Order��� custom object while Germany and Japan use the Opportunity object. We want to make the search dynamic so if more countries are added it will be easy to configure where the data comes from. Add a ���Search_Opportunities__c��� (boolean) field to the country object in from the AddressTools package. When the user selects a search country, check the value of ���Search_Opportunities__c��� to determine what object to search. You might want to consider implementing some sort of common wrapper object to populate that holds Sales Order or Opportunity data. Here are the fields that you will need:
    ��
    Opportunity
    Size field = Size__c ��: Number(18,2)
    Year ��= CloseDate ��: standard field
    Type = Type ( picklist ) ��: standard field
    Address : BillingAddress fields on related Account (standard fields)
    ��
    Sales Order (new custom object)
    Size = Size__c ��: Number(18,2)
    Year ��= Delivery_Date__c ��: Date type
    Type = Type__c �� : Picklist field
    Country__c : Text field ( size 255 )��
    State__c : Text field ( size 255 )��
    City__c : Text field ��( size 255 )��
    ZipCode__c : Text field ��( size 15 )
    Street__c : Text field ( size 255 )��
    ��
    ��
    Must have adequate test coverage (90%+).

    Reliability Rating and Bonus

    For challenges that have a reliability bonus, the bonus depends on the reliability rating at the moment of registration for that project. A participant with no previous projects is considered to have no reliability rating, and therefore gets no bonus. Reliability bonus does not apply to Digital Run winnings. Since reliability rating is based on the past 15 projects, it can only have 15 discrete values.
    Read more.

    REVIEW STYLE:

    Final Review:

    Community Review Board
    ?

    Approval:

    User Sign-Off
    ?

    CHALLENGE LINKS:

    Review Scorecard