Edit file

File name : controller.php

Content :

<?php

if (!defined('sugarEntry') || !sugarEntry)
    die('Not A Valid Entry Point');

// modules/jjwg_Maps/controller.php

require_once('include/utils.php');
require_once('include/export_utils.php');
require_once("include/Sugar_Smarty.php");
require_once('modules/jjwg_Maps/jjwg_Maps.php');

class jjwg_MapsController extends SugarController {

/**
     * @var settings array
     */
    var $settings = array();

/**
     * $map_marker_data_points is used to store temporary data and prevent duplicate points
     * @var array
     */
    var $map_marker_data_points = array();

/**
     * @var google_maps_response_codes
     *
     */
    var $google_maps_response_codes = array('OK', 'ZERO_RESULTS', 'INVALID_REQUEST', 'OVER_QUERY_LIMIT', 'REQUEST_DENIED');

/**
     * Last Geocoding Status Message
     * @var string
     */
    var $last_status = '';

/**
     * display_object - display module's object (dom field)
     * @var object
     */
    var $display_object;

/**
     * relate_object - relate module's object
     * @var object
     */
    var $relate_object;

/**
     * jjwg_Maps - Maps module's object
     * @var object
     */
    var $bean;
    var $jjwg_Maps; // Deprecated reference

/**
     * jjwg_Address_Cache - Address cache module's object
     * @var object
     */
    var $jjwg_Address_Cache;

/**
     * smarty object for the generic configuration template
     * @var object
     */
    var $sugarSmarty;

/**
     * Constructor
     */
    function __construct() {

parent::__construct();
        // Admin Config Setting
        $this->configuration();
    }

/**
     * @deprecated deprecated since version 7.6, PHP4 Style Constructors are deprecated and will be remove in 7.8, please update your code, use __construct instead
     */
    function jjwg_MapsController(){
        $deprecatedMessage = 'PHP4 Style Constructors are deprecated and will be remove in 7.8, please update your code';
        if(isset($GLOBALS['log'])) {
            $GLOBALS['log']->deprecated($deprecatedMessage);
        }
        else {
            trigger_error($deprecatedMessage, E_USER_DEPRECATED);
        }
        self::__construct();
    }

/**
     * Load Configuration Settings using Administration Module
     * See jjwg_Maps module for settings
     *
     * $GLOBALS['jjwg_config_defaults']
     * $GLOBALS['jjwg_config']
     */
    function configuration() {

$this->bean = new jjwg_Maps();
        $this->jjwg_Maps = &$this->bean; // Set deprecated reference
        $this->settings = $GLOBALS['jjwg_config'];
    }

/**
     * action geocoded_counts
     * Google Maps - Geocode the Addresses
     */
    function action_geocoded_counts() {

$this->view = 'geocoded_counts';
        $GLOBALS['log']->debug(__METHOD__.' START');

$this->bean->geocoded_counts = array();
        $this->bean->geocoded_headings = array('N/A');
        $this->bean->geocoded_module_totals = array();

$responses = array('N/A' => '');
        foreach ($this->google_maps_response_codes as $code) {
            if (!in_array($code, array('OVER_QUERY_LIMIT', 'REQUEST_DENIED'))) {
                $responses[$code] = $code;
                $this->bean->geocoded_headings[] = $code;
            }
        }
        $responses['Approximate'] = 'APPROXIMATE';
        $responses['Empty'] = 'Empty';
        $this->bean->geocoded_headings[] = 'Approximate';
        $this->bean->geocoded_headings[] = 'Empty';

// foreach module
        foreach ($this->settings['valid_geocode_modules'] as $module_type) {

if (!isset($this->bean->geocoded_counts[$module_type])) {
                $this->bean->geocoded_module_totals[$module_type] = 0;
            }

// Define display object from the necessary classes (utils.php)
            $this->display_object = get_module_info($module_type);

foreach ($responses as $response => $code) {

// Create Simple Count Query
                // 09/23/2010: Do not use create_new_list_query() and process_list_query()
                // as they will typically exceeded memory allowed.
                $query = "SELECT count(*) c FROM " . $this->display_object->table_name .
                        " LEFT JOIN " . $this->display_object->table_name . "_cstm " .
                        " ON " . $this->display_object->table_name . ".id = " . $this->display_object->table_name . "_cstm.id_c " .
                        " WHERE " . $this->display_object->table_name . ".deleted = 0 AND ";
                if ($response == 'N/A') {
                    $query .= "(" . $this->display_object->table_name . "_cstm.jjwg_maps_geocode_status_c = '' OR " .
                            $this->display_object->table_name . "_cstm.jjwg_maps_geocode_status_c IS NULL)";
                } else {
                    $query .= $this->display_object->table_name . "_cstm.jjwg_maps_geocode_status_c = '" . $code . "'";
                }
                //var_dump($query);
                $count_result = $this->bean->db->query($query);
                $count = $this->bean->db->fetchByAssoc($count_result);
                if (empty($count)) $count['c'] = 0;
                $this->bean->geocoded_counts[$module_type][$response] = $count['c'];
            } // end foreach response type
            // Get Totals
            $this->bean->geocoded_module_totals[$module_type]++;
            $query = "SELECT count(*) c FROM " . $this->display_object->table_name . " WHERE " . $this->display_object->table_name . ".deleted = 0";
            //var_dump($query);
            $count_result = $this->bean->db->query($query);
            $count = $this->bean->db->fetchByAssoc($count_result);
            $this->bean->geocoded_module_totals[$module_type] = $count['c'];
        } // end each module type
    }

/**
     * action geocode_addresses
     * Google Maps - Geocode the Addresses
     */
    function action_geocode_addresses() {

$GLOBALS['log']->debug(__METHOD__.' START');

if (!empty($_REQUEST['display_module']) && in_array($_REQUEST['display_module'], $this->settings['valid_geocode_modules'])) {
            $geocode_modules = array($_REQUEST['display_module']);
        } else {
            $geocode_modules = $this->settings['valid_geocode_modules'];
        }
        $geocoding_inc = 0;
        $google_geocoding_inc = 0;
        // Define Address Cache Object
        $this->jjwg_Address_Cache = get_module_info('jjwg_Address_Cache');

foreach ($geocode_modules as $module_type) {

$GLOBALS['log']->debug(__METHOD__.' $module_type: '.$module_type);
            // Define display object from the necessary classes (utils.php)
            $this->display_object = get_module_info($module_type);

// Find the Items to Geocode - Get Geocode Addresses Result
            $display_result = $this->bean->getGeocodeAddressesResult($this->display_object->table_name);

/*
             * Iterate through the display rows
             * We build up an array here to prevent locking issues on some DBs (looking at you MSSQL)
             */
            $tmpDisplayResults = array();
            while ($display = $this->bean->db->fetchByAssoc($display_result)) {
                $tmpDisplayResults[] = $display;
            }
            foreach($tmpDisplayResults as $display){

$GLOBALS['log']->debug(__METHOD__.' $display[\'id\': '.$display['id']);
                $geocoding_inc++;
                $aInfo = array();
                $cache_found = false;

// Get address info array (address, status, lat, lng) from defineMapsAddress()
                // This will provide a related address & optionally a status, lat and lng from an account or other object
                $aInfo = $this->bean->defineMapsAddress($this->display_object->object_name, $display);
                //var_dump($aInfo);

// Call Controller Method to Define Custom Address Logic
                $aInfo = $this->defineMapsAddressCustom($aInfo, $this->display_object->object_name, $display);
                //var_dump($aInfo);

// If needed, check the Address Cache Module for Geocode Info
                if (!empty($aInfo['address']) && is_object($this->jjwg_Address_Cache)) {
                    $aInfoCache = $this->jjwg_Address_Cache->getAddressCacheInfo($aInfo);
                    if (!empty($aInfoCache['address'])) {
                        $cache_found = true;
                        $aInfo = $aInfoCache;
                    }
                }

// If needed, Google Maps V3. Geocode the current address (status not set)
                if (!empty($aInfo['address']) && empty($aInfo['status'])) {
                    // Limit Geocode Requests to Google based on $this->settings['google_geocoding_limit']
                    if ($google_geocoding_inc < $this->settings['google_geocoding_limit']) {
                        $aInfoGoogle = $this->bean->getGoogleMapsGeocode($aInfo['address'], false, false);
                        if (!empty($aInfoGoogle)) {
                            $aInfo = $aInfoGoogle;
                            // Set last status
                            $this->last_status = $aInfo['status'];
                        }
                        $google_geocoding_inc++;
                    }
                }

if (empty($aInfo['status'])) {
                    $aInfo['status'] = '';
                }
                if (empty($aInfo['lat']) || !is_numeric($aInfo['lat'])) {
                    $aInfo['lat'] = 0;
                }
                if (empty($aInfo['lng']) || !is_numeric($aInfo['lng'])) {
                    $aInfo['lng'] = 0;
                }

// Successful geocode
                // 'OK' Status
                if (!empty($aInfo['address']) && $aInfo['status'] == 'OK' &&
                        !($aInfo['lng'] == 0 && $aInfo['lat'] == 0)) {

// Save Geocode $aInfo to custom fields
                    $update_result = $this->bean->updateGeocodeInfoByAssocQuery($this->display_object->table_name, $display, $aInfo);

// Save address, lng and lat to cache module - if not already found from cache
                    if (!$cache_found) {
                        $cache_save_result = $this->jjwg_Address_Cache->saveAddressCacheInfo($aInfo);
                    }

// Bad Geocode Results - Recorded
                // Empty Address - indicates no address, no geocode response
                // 'ZERO_RESULTS' - indicates that the geocode was successful but returned no results.
                //     This may occur if the geocode was passed a non-existent address.
                // 'INVALID_REQUEST' - generally indicates that the query (address) is missing.
                // Also, capture empty $aInfo or address.
                } elseif (empty($aInfo) || empty($aInfo['address']) || (!empty($aInfo['address']) &&
                        ($aInfo['status'] == 'ZERO_RESULTS' || $aInfo['status'] == 'INVALID_REQUEST' ||
                        $aInfo['status'] == 'APPROXIMATE'))) {

if (empty($aInfo['status'])) {
                        $aInfo['status'] = 'Empty';
                    }
                    // Save Geocode $aInfo to custom fields
                    $update_result = $this->bean->updateGeocodeInfoByAssocQuery($this->display_object->table_name, $display, $aInfo);

// Bad Geocode Results - Stop
                // 'OVER_QUERY_LIMIT' - indicates that you are over your quota.
                // 'REQUEST_DENIED' - indicates that your request was denied, generally because of lack of a sensor parameter.
                } elseif (!empty($aInfo['address']) &&
                        ($aInfo['status'] == 'OVER_QUERY_LIMIT' || $aInfo['status'] == 'REQUEST_DENIED')) {

// Set above limit to break/stop processing
                    $geocoding_inc = $this->settings['geocoding_limit'] + 1;
                } // end if/else

// Wait 1 Second to Throttle Requests: Rate limit of 10 geocodings per second
                if ($geocoding_inc % 10 == 0)
                    sleep(1);

if ($geocoding_inc > $this->settings['geocoding_limit'])
                    break;
            } // while

if ($geocoding_inc > $this->settings['geocoding_limit'])
                break;
        } // end each module type

// If not cron processing, then redirect.
        if (!isset($_REQUEST['cron'])) {
            // Redirect to the Geocoded Counts Display
            // contains header and exit
            $url = 'index.php?module=jjwg_Maps&action=geocoded_counts';
            if (!empty($this->last_status)) {
                $url .= '&last_status=' . urlencode($this->last_status);
            }
            SugarApplication::redirect($url);
        }

}

/**
     *  Add a number of display_module objects to a target list
     *  Return JSON encoded result count
     */
    function action_add_to_target_list() {

$result = array('post' => $_POST);

// Target List
        $list_id = (!empty($_POST['list_id'])) ? $_POST['list_id'] : '';
        $list = get_module_info('ProspectLists');
        if (!empty($list_id) && is_guid($list_id)) {
            $list->retrieve($list_id);
            $result['list'] = $list;
        }
        // Selected Area IDs - Validate
        $selected_ids = array();
        foreach ($_POST['selected_ids'] as $sel_id) {
            if (is_guid($sel_id)) {
                $selected_ids[] = $sel_id;
            }
        }
        $result['selected_ids'] = $selected_ids;

// Display Module Type
        $module_type = '';
        if (!empty($_POST['display_module']) && in_array($_POST['display_module'], $this->settings['valid_geocode_modules'])) {
            $module_type = $_POST['display_module'];
            $result['module_type'] = $module_type;
            // Define display object
            $this->display_object = get_module_info($module_type);
        }

if (!empty($list) && $list_id == $list->id && !empty($selected_ids) && !empty($this->display_object) &&
                in_array($this->display_object->module_name, array('Accounts', 'Contacts', 'Leads', 'Prospects', 'Users'))) {

$object_name = $this->display_object->object_name;
            $result['object_name'] = $object_name;

if ($object_name == 'Account') {
                $list->load_relationship('accounts');
                foreach ($selected_ids as $sel_id) {
                    $list->accounts->add($sel_id);
                }
            } elseif ($object_name == 'Contact') {
                $list->load_relationship('contacts');
                foreach ($selected_ids as $sel_id) {
                    $list->contacts->add($sel_id);
                }
            } elseif ($object_name == 'Lead') {
                $list->load_relationship('leads');
                foreach ($selected_ids as $sel_id) {
                    $list->leads->add($sel_id);
                }
            } elseif ($object_name == 'Prospect') {
                $list->load_relationship('prospects');
                foreach ($selected_ids as $sel_id) {
                    $list->prospects->add($sel_id);
                }
            } elseif ($object_name == 'User') {
                $list->load_relationship('users');
                foreach ($selected_ids as $sel_id) {
                    $list->users->add($sel_id);
                }
            }
            $result['message'] = 'Target List Updated';
        } else {
            $result['message'] = 'Target List NOT Updated';
        }

// JSON Encoded $result
        header('Content-Type: application/json');
        echo @json_encode($result);
    }

/**
     * export addresses in need of geocoding
     */
    function action_export_geocoding_addresses() {

$address_data = array();
        $addresses = array();

if (!empty($_REQUEST['display_module']) && in_array($_REQUEST['display_module'], $this->settings['valid_geocode_modules'])) {
            $module_type = $_REQUEST['display_module'];
        } else {
            $module_type = $this->settings['valid_geocode_modules'][0];
        }
        // Define display object
        $this->display_object = get_module_info($module_type);

// Find the Items to Geocode - Get Geocode Addresses Result
        $display_result = $this->bean->getGeocodeAddressesResult($this->display_object->table_name, $this->settings['export_addresses_limit']);

$address_data[] = array('address', 'lat', 'lng');
        // Iterate through the display rows
        while ($display = $this->bean->db->fetchByAssoc($display_result)) {

// Get address info array (address, status, lat, lng) from defineMapsAddress()
            // This will provide a related address & optionally a status, lat and lng from an account or other object
            $aInfo = $this->bean->defineMapsAddress($this->display_object->object_name, $display);
            //var_dump($aInfo);

// Call Method to Define Custom Address Logic
            $aInfo = $this->defineMapsAddressCustom($aInfo, $this->display_object->object_name, $display);
            //var_dump($aInfo);

if (!empty($aInfo['address'])) {
                $addresses[] = trim($aInfo['address'], ' ,;."\'');
        }
        }

$addresses = array_unique($addresses);
        foreach ($addresses as $address) {
            $address_data[] = array($address, '', '');
        }

$filename = $module_type . '_Addresses_' . date("Ymd") . ".csv";
        $this->do_list_csv_output($address_data, $filename);
        exit;
    }

/**
     * Custom Override for Defining Maps Address
     *
     * @param $aInfo        address info array(address, status, lat, lng)
     * @param $object_name  signular object name
     * @param $display      fetched row array
     */
    function defineMapsAddressCustom($aInfo, $object_name, $display) {

// Use custom contoller.php with custom logic
        return $aInfo;
    }

/**
     *
     * Export rows of data as a CSV file
     * @param unknown_type $rows
     * @param unknown_type $filename
     */
    private function do_list_csv_output($rows, $filename) {

header("Content-type: application/octet-stream");
        header("Content-Disposition: attachment; filename=\"$filename\"");
        header("Content-Transfer-Encoding: binary");
        if (strpos($_SERVER['HTTP_USER_AGENT'], 'MSIE')) {
            // IE cannot download from sessions without a cache
            header('Cache-Control: public');
        }
        foreach (array_keys($rows) as $key) {
            $row = $rows[$key];
            echo $this->list_row_to_csv($row);
        }
    }

/**
     *
     * Create CSV row for export view
     * @param $fields name value pairs
     * @param $delimiter
     * @param $enclosure
     */
    private function list_row_to_csv($fields, $delimiter = ',', $enclosure = '"') {

$delimiter_esc = preg_quote($delimiter, '/');
        $enclosure_esc = preg_quote($enclosure, '/');
        $output = array();
        foreach ($fields as $field) {
            $output[] = preg_match("/(?:${delimiter_esc}|${enclosure_esc}|\s)/", $field) ? (
                    $enclosure . str_replace($enclosure, $enclosure . $enclosure, $field) . $enclosure
                    ) : $field;
        }

return (join($delimiter, $output) . "\n");
    }

/**
     * action geocoding_test
     * Google Maps - Geocoding Test
     */
    function action_geocoding_test() {

$this->view = 'geocoding_test';

if (!empty($_REQUEST['geocoding_address']) && !empty($_REQUEST['process_trigger']) &&
                strlen($_REQUEST['geocoding_address']) <= 255) {
            $this->bean->geocoding_results = $this->bean->getGoogleMapsGeocode($_REQUEST['geocoding_address'], true, true);
        }
    }

/**
     * action config
     * Google Maps - Config
     */
    function action_config() {

// Admin Only
        if (!empty($GLOBALS['current_user']->is_admin)) {
            if (!empty($_REQUEST['submit'])) {
                // Post-Get-Redirect
                $save_result = $this->bean->saveConfiguration($_REQUEST);
                $config_save_notice = ($save_result == true) ? '1' : '0';
                SugarApplication::redirect('index.php?module=jjwg_Maps&action=config&config_save_notice='.$config_save_notice);
            } else {
                $this->view = 'config';
            }
        } else {
            SugarApplication::redirect('index.php?module=jjwg_Maps&action=index');
        }
    }

/**
     * action reset module geocode info
     * Google Maps - geocoded_counts
     */
    function action_reset_geocoding() {

$display_module = $_REQUEST['display_module'];

// Define display object from the necessary classes (utils.php)
        $this->display_object = get_module_info($display_module);

// Admin Only
        if (!empty($GLOBALS['current_user']->is_admin)) {
            if (is_object($this->display_object)) {
                $delete_result = $this->bean->deleteAllGeocodeInfoByBeanQuery($this->display_object);
                SugarApplication::redirect('index.php?module=jjwg_Maps&action=geocoded_counts');
            } else {
                $this->view = 'geocoded_counts';
            }
        } else {
            SugarApplication::redirect('index.php?module=jjwg_Maps&action=index');
        }
    }

/**
     * delete all address cache
     * Google Maps - geocoded_counts
     */
    function action_delete_all_address_cache() {

// Define Address Cache Object
        $this->jjwg_Address_Cache = get_module_info('jjwg_Address_Cache');

// Admin Only
        if (!empty($GLOBALS['current_user']->is_admin)) {
            if (is_object($this->jjwg_Address_Cache)) {
                // Post-Get-Redirect
                $delete_result = $this->jjwg_Address_Cache->deleteAllAddressCache();
                SugarApplication::redirect('index.php?module=jjwg_Maps&action=geocoded_counts');
            } else {
                $this->view = 'geocoded_counts';
            }
        } else {
            SugarApplication::redirect('index.php?module=jjwg_Maps&action=index');
        }
    }

/**
     * action quick_radius
     * Google Maps - Quick Radius Map
     */
    function action_quick_radius() {

$this->view = 'quick_radius';

if (!isset($_REQUEST['distance'])) $_REQUEST['distance'] = $this->settings['map_default_distance'];
        if (!isset($_REQUEST['unit_type'])) $_REQUEST['unit_type'] = $this->settings['map_default_unit_type'];

}

/**
     * action map_display
     * Google Maps - Output the Page with IFrame to Map Markers
     */
    function action_quick_radius_display() {

$this->view = 'quick_radius_display';
    }

/**
     * action map_display
     * Google Maps - Output the Page with IFrame to Map Markers
     */
    function action_map_display() {

$this->view = 'map_display';
        if (!isset($_REQUEST['current_post'])) $_REQUEST['current_post'] = '';

// Bug: 'current_post' too large for iFrame URL used in Google Library calls
        $_SESSION['jjwg_Maps']['current_post'] = $_REQUEST['current_post'];
        $_REQUEST['current_post'] = 'session';
    }

/**
     * action donate
     * Google Maps - Output the Donate Page
     */
    function action_donate() {

$this->view = 'donate';
    }

/**
     * action map_markers
     * Google Maps - Output the Map Markers
     */
    function action_map_markers() {

header_remove('X-Frame-Options');
        $this->view = 'map_markers';

// Define globals for use in the view.
        $this->bean->map_center = array();
        $this->bean->map_markers = array();
        $this->bean->map_markers_groups = array();
        $this->bean->custom_markers = array();
        $this->bean->custom_areas = array();

// Create New Sugar_Smarty Object
        $this->sugarSmarty = new Sugar_Smarty();
        $this->sugarSmarty->assign("mod_strings", $GLOBALS['mod_strings']);
        $this->sugarSmarty->assign("app_strings", $GLOBALS['app_strings']);
        $this->sugarSmarty->assign('app_list_strings', $GLOBALS['app_list_strings']);
        $this->sugarSmarty->assign('moduleListSingular', $GLOBALS['app_list_strings']['moduleListSingular']);
        $this->sugarSmarty->assign('moduleList', $GLOBALS['app_list_strings']['moduleList']);
        //echo '<pre>';
        //var_dump($_REQUEST);

// Related Map Record Defines the Map
        if (!empty($_REQUEST['record']) ||
                (!empty($_REQUEST['relate_id']) && !empty($_REQUEST['relate_module'])) ||
                (!empty($_REQUEST['quick_address']) && !empty($_REQUEST['display_module']))) {

// If map 'record' then define map details from current module.
            if (@is_guid($_REQUEST['record'])) {
                // Get the map object
                $map = get_module_info($GLOBALS['currentModule']);
                $map->retrieve($_REQUEST['record']);
                // Define map variables
                $map_parent_type = $map->parent_type;
                $map_parent_id = $map->parent_id;
                $map_module_type = $map->module_type;
                $map_unit_type = $map->unit_type;
                $map_distance = $map->distance;
            }
            // Else if a 'relate_id' use it as the Relate Center Point (Lng/Lat)
            else if (@(is_guid($_REQUEST['relate_id']) && !empty($_REQUEST['relate_module']))) {
                // Define map variables
                $map_parent_type = $_REQUEST['relate_module'];
                $map_parent_id = $_REQUEST['relate_id'];
                $map_module_type = (!empty($_REQUEST['display_module'])) ? $_REQUEST['display_module'] : $_REQUEST['relate_module'];
                $map_distance = (!empty($_REQUEST['distance'])) ? $_REQUEST['distance'] : $this->settings['map_default_distance'];
                $map_unit_type = (!empty($_REQUEST['unit_type'])) ? $_REQUEST['unit_type'] : $this->settings['map_default_unit_type'];
            }
            // Else if a 'quick_address' use it as the Center Point (Lng/Lat)
            else if (!empty($_REQUEST['quick_address']) && !empty($_REQUEST['display_module'])) {
                // Define map variables / No Parent
                $map_parent_type = null;
                $map_parent_id = null;
                $map_module_type = (!empty($_REQUEST['display_module'])) ? $_REQUEST['display_module'] : $_REQUEST['relate_module'];
                $map_distance = (!empty($_REQUEST['distance'])) ? $_REQUEST['distance'] : $this->settings['map_default_distance'];
                $map_unit_type = (!empty($_REQUEST['unit_type'])) ? $_REQUEST['unit_type'] : $this->settings['map_default_unit_type'];
            }

// Define display object, note - 'Accounts_Members' is a special display type
            $this->display_object = ($map_module_type == 'Accounts_Members') ? get_module_info('Accounts') : get_module_info($map_module_type);
            $mod_strings_display = return_module_language($GLOBALS['current_language'], $this->display_object->module_name);
            $mod_strings_display = array_merge($mod_strings_display, $GLOBALS['mod_strings']);

// If relate module/id object
            if (!empty($map_parent_type) && !empty($map_parent_id)) {

// Define relate objects
                $this->relate_object = get_module_info($map_parent_type);
                $this->relate_object->retrieve($map_parent_id);
                $mod_strings_related = return_module_language($GLOBALS['current_language'], $this->relate_object->module_name);
                $mod_strings_related = array_merge($mod_strings_related, $GLOBALS['mod_strings']);

// Get the Relate object Assoc Data
                $where_conds = $this->relate_object->table_name . ".id = '" . $map_parent_id . "'";
                $query = $this->relate_object->create_new_list_query("" . $this->relate_object->table_name . ".assigned_user_id", $where_conds, array(), array(), 0, '', false, $this->relate_object, false);
                //var_dump($query);
                $relate_result = $this->bean->db->query($query);
                $relate = $this->bean->db->fetchByAssoc($relate_result);
                // Add Relate (Center Point) Marker
                $this->bean->map_center = $this->getMarkerData($map_parent_type, $relate, true, $mod_strings_related);
                // Define Center Point
                $center_lat = $this->relate_object->jjwg_maps_lat_c;
                $center_lng = $this->relate_object->jjwg_maps_lng_c;
            }
            // Use Quick Address as Center Point
            else {
                // Geocode 'quick_address'
                $aInfo = $this->bean->getGoogleMapsGeocode($_REQUEST['quick_address'], false, true);
                // If not status 'OK', then fail here and exit. Note: Inside of iFrame
                if (!empty($aInfo['status']) && $aInfo['status'] != 'OK' && preg_match('/[A-Z\_]/', $aInfo['status'])) {
                    echo '<br /><br /><div><b>'.$GLOBALS['mod_strings']['LBL_MAP_LAST_STATUS'].': '.$aInfo['status'].'</b></div><br /><br />';
                    exit;
                }
                //var_dump($aInfo);
                // Define Marker Data
                $aInfo['name'] = $_REQUEST['quick_address'];
                $aInfo['id'] = 0;
                $aInfo['module'] = ($map_module_type == 'Accounts_Members') ? 'Accounts' : $map_module_type;
                $aInfo['address'] = $_REQUEST['quick_address'];
                $aInfo['jjwg_maps_address_c'] = $_REQUEST['quick_address'];
                $aInfo['jjwg_maps_lat_c'] = $aInfo['lat'];
                $aInfo['jjwg_maps_lng_c'] = $aInfo['lng'];
                $this->bean->map_center = $this->getMarkerData($map_parent_type, $aInfo, true);
                // Define Center Point
                $center_lat = $aInfo['lat'];
                $center_lng = $aInfo['lng'];
            }
            //var_dump($aInfo);
            // Define $x and $y expressions
            $x = '(69.1*((' . $this->display_object->table_name . '_cstm.jjwg_maps_lat_c)-(' . $center_lat . ')))';
            $y = '(53.0*((' . $this->display_object->table_name . '_cstm.jjwg_maps_lng_c)-(' . $center_lng . ')) * COS((' . $center_lat . ')/57.1))';
            $calc_distance_expression = 'SQRT(' . $x . '*' . $x . '+' . $y . '*' . $y . ')';
            if (strtolower($map_unit_type) == 'km' || strtolower($map_unit_type) == 'kilometer') {
                $calc_distance_expression .= '*1.609'; // 1 mile = 1.609 km
            }

// Find the Items to Display
            // Assume there is no address at 0,0; it's in the Atlantic Ocean!
            $where_conds = "(" . $this->display_object->table_name . "_cstm.jjwg_maps_lat_c != 0 OR " .
                    "" . $this->display_object->table_name . "_cstm.jjwg_maps_lng_c != 0) " .
                    " AND " .
                    "(" . $this->display_object->table_name . "_cstm.jjwg_maps_geocode_status_c = 'OK')" .
                    " AND " .
                    "(" . $calc_distance_expression . " < " . $map_distance . ")";
            $query = $this->display_object->create_new_list_query('display_object_distance', $where_conds, array(), array(), 0, '', false, $this->display_object, false);
            // Add the disply_object_distance into SELECT list
            $query = str_replace('SELECT ', 'SELECT (' . $calc_distance_expression . ') AS display_object_distance, ', $query);
            if ($map_module_type == 'Contacts') { // Contacts - Account Name
                $query = str_replace(' FROM contacts ', ' ,accounts.name AS account_name, accounts.id AS account_id  FROM contacts  ', $query);
                $query = str_replace(' FROM contacts ', ' FROM contacts LEFT JOIN accounts_contacts ON contacts.id=accounts_contacts.contact_id and accounts_contacts.deleted = 0 LEFT JOIN accounts ON accounts_contacts.account_id=accounts.id AND accounts.deleted=0 ', $query);
            } elseif ($map_module_type == 'Opportunities') { // Opps - Account Name
                $query = str_replace(' FROM opportunities ', ' ,accounts.name AS account_name, accounts.id AS account_id  FROM opportunities  ', $query);
                $query = str_replace(' FROM opportunities ', ' FROM opportunities LEFT JOIN accounts_opportunities ON opportunities.id=accounts_opportunities.opportunity_id and accounts_opportunities.deleted = 0 LEFT JOIN accounts ON accounts_opportunities.account_id=accounts.id AND accounts.deleted=0 ', $query);
            } elseif ($map_module_type == 'Accounts_Members') { // 'Accounts_Members' is a special display type
                $query = str_replace(' AND accounts.deleted=0', ' AND accounts.deleted=0 AND accounts.parent_id = \''.$this->bean->db->quote($map_parent_id).'\'', $query);
            }
            //var_dump($query);
            $display_result = $this->bean->db->limitQuery($query, 0, $this->settings['map_markers_limit']);
            while ($display = $this->bean->db->fetchByAssoc($display_result)) {
                if (!empty($map_distance) && !empty($display['id'])) {
                    $marker_data_module_type = ($map_module_type == 'Accounts_Members') ? 'Accounts' : $map_module_type;
                    $marker_data = $this->getMarkerData($marker_data_module_type, $display, false, $mod_strings_display);
                    if (!empty($marker_data)) {
                        $this->bean->map_markers[] = $marker_data;
                    }
                }
            }
            //var_dump($this->bean->map_markers);
            // Next define the Custom Markers and Areas related to this Map
            // Define relate and display objects from the necessary classes (utils.php)
            @$markers_object = get_module_info('jjwg_Markers');
            @$areas_object = get_module_info('jjwg_Areas');

// Relationship Names: jjwg_maps_jjwg_areas and jjwg_maps_jjwg_markers
            // Find the Related Beans: Maps to Markers
            if (@(is_object($markers_object) && is_object($map))) {
                $related_custom_markers = $map->get_linked_beans('jjwg_maps_jjwg_markers', 'jjwg_Markers');
                if ($related_custom_markers) {
                    foreach ($related_custom_markers as $marker_bean) {
                        $marker_data = $this->getMarkerDataCustom($marker_bean);
                        if (!empty($marker_data)) {
                            $this->bean->custom_markers[] = $marker_data;
                        }
                    }
                }
            }

// Find the Related Beans: Maps to Areas
            if (@(is_object($areas_object) && is_object($map))) {
                $related_custom_areas = $map->get_linked_beans('jjwg_maps_jjwg_areas', 'jjwg_Areas');
                if ($related_custom_areas) {
                    foreach ($related_custom_areas as $area_bean) {
                        $area_data = $this->getAreaDataCustom($area_bean);
                        if (!empty($area_data)) {
                            $this->bean->custom_areas[] = $area_data;
                        }
                    }
                }
            }

// Map Target List (ProspectLists)
        } elseif (!empty($_REQUEST['list_id'])) {

$this->bean->map_markers = array();
            $this->display_object = get_module_info('ProspectLists');
            // Use the Export Query
            if (!empty($_REQUEST['list_id'])) {
                $this->display_object->retrieve($_REQUEST['list_id']);
                if ($this->display_object->id == $_REQUEST['list_id']) {
                    $prospect_list_object = $this->display_object;
                    $list_id = $this->display_object->id;
                }
            }

if (!empty($list_id)) {

$list_modules = array('Accounts', 'Contacts', 'Leads', 'Users', 'Prospects');
                $temp_marker_groups = array();

foreach ($list_modules as $display_module) {

$this->display_object = get_module_info($display_module);
                    $mod_strings_display = return_module_language($GLOBALS['current_language'], $this->display_object->module_name);
                    $mod_strings_display = array_merge($mod_strings_display, $GLOBALS['mod_strings']);

// Find the Items to Display
                    // Assume there is no address at 0,0; it's in the Atlantic Ocean!
                    $where_conds = "(" . $this->display_object->table_name . "_cstm.jjwg_maps_lat_c != 0 OR " .
                            "" . $this->display_object->table_name . "_cstm.jjwg_maps_lng_c != 0) " .
                            " AND " .
                            "(" . $this->display_object->table_name . "_cstm.jjwg_maps_geocode_status_c = 'OK')";
                    $query = $this->display_object->create_new_list_query('', $where_conds, array(), array(), 0, '', false, $this->display_object, false);
                    if ($display_module == 'Contacts') { // Contacts - Account Name
                        $query = str_replace(' FROM contacts ', ' ,accounts.name AS account_name, accounts.id AS account_id  FROM contacts  ', $query);
                        $query = str_replace(' FROM contacts ', ' FROM contacts LEFT JOIN accounts_contacts ON contacts.id=accounts_contacts.contact_id and accounts_contacts.deleted = 0 LEFT JOIN accounts ON accounts_contacts.account_id=accounts.id AND accounts.deleted=0 ', $query);
                    }
                    // Add List JOIN
                    $query = str_replace(' FROM '.$this->display_object->table_name.' ', ' FROM '.$this->display_object->table_name.' '.
                            'LEFT JOIN prospect_lists_prospects ON prospect_lists_prospects.related_id = '.$this->display_object->table_name.'.id AND prospect_lists_prospects.deleted=0 '.
                            'LEFT JOIN prospect_lists ON prospect_lists_prospects.prospect_list_id = prospect_lists.id AND prospect_lists.deleted=0 ',
                            $query);
                    // Restrict WHERE to related type and $list_id
                    $query .= ' AND prospect_lists_prospects.related_type = \''.$this->display_object->module_name.'\' AND '.
                            'prospect_lists.id = \''.$this->bean->db->quote($list_id).'\'';
                    //var_dump($query);
                    $display_result = $this->bean->db->limitQuery($query, 0, $this->settings['map_markers_limit']);
                    $display_type_found = false;
                    while ($display = $this->bean->db->fetchByAssoc($display_result)) {
                        if (!empty($display['id'])) {
                            $marker_data = $this->getMarkerData($display_module, $display, false, $mod_strings_display);
                            $marker_data['group'] = $GLOBALS['app_list_strings']['moduleList'][$display_module];
                            if (!empty($marker_data)) {
                                $this->bean->map_markers[] = $marker_data;
                            }
                            $display_type_found = true;
                        }
                    }
                    if ($display_type_found) {
                        $temp_marker_groups[] = $GLOBALS['app_list_strings']['moduleList'][$display_module];
                    }

}

$this->bean->map_markers_groups = $temp_marker_groups;
            }

// Map Records
        } elseif (!empty($_REQUEST['uid']) || !empty($_REQUEST['current_post'])) {

if (in_array($_REQUEST['display_module'], $this->settings['valid_geocode_modules'])) {
                $display_module = $_REQUEST['display_module'];
            } else {
                $display_module = 'Accounts';
            }
            if ($_REQUEST['current_post'] == 'session') {
                $current_post = $_SESSION['jjwg_Maps']['current_post'];
            } else {
                $current_post = $_REQUEST['current_post'];
            }
            $query = '';
            $selected_query = '';
            $records = array();
            $order_by = '';

$this->display_object = get_module_info($display_module);
            $mod_strings_display = return_module_language($GLOBALS['current_language'], $this->display_object->module_name);
            $mod_strings_display = array_merge($mod_strings_display, $GLOBALS['mod_strings']);

if (!empty($_REQUEST['uid'])) {
                // Several records selected or this page
                $records = explode(',', $_REQUEST['uid']);
            } elseif (!empty($current_post)) {
                // Select all records (advanced search)
                $search_array = generateSearchWhere($display_module, $current_post);
                //var_dump($search_array);
                if (!empty($search_array['where'])) {
                    // Related Field Bug: Get relate/link patched 'where' and 'join'
                    @$ret_array = create_export_query_relate_link_patch($display_module, $search_array['searchFields'], $search_array['where']);
                    if(!empty($ret_array['join'])) {
                        @$selected_query = $this->display_object->create_export_query($order_by, $ret_array['where'], $ret_array['join']);
                    } else {
                        @$selected_query = $this->display_object->create_export_query($order_by, $ret_array['where']);
                    }
                    // SugarOnDemand JOIN Bug: If $ret_array['join'] is not included in query, force it in!
                    if (strpos($ret_array['join'], $selected_query) === false) {
                        $selected_query = str_replace(' where ', $ret_array['join'].' where ', $selected_query);
                    }
                    // Avoiding subquery. Let's just record the record ID's for later
                    $selected_result = $this->bean->db->limitQuery($selected_query, 0, $this->settings['map_markers_limit']);
                    while ($display = $this->bean->db->fetchByAssoc($selected_result)) {
                        $records[] = $display['id'];
                    }
                }
            }
            //var_dump($records);

$display_result = $this->bean->db->limitQuery($query, 0, $this->settings['map_markers_limit']);
            $this->bean->map_markers = array();
            while ($display = $this->bean->db->fetchByAssoc($display_result)) {
                if (!empty($search_array['where'])) { // Select all records (advanced search) with where clause
                    if (in_array($display['id'], $records)) {
                        $this->bean->map_markers[] = $this->getMarkerData($display_module, $display, false, $mod_strings_display);
                    }
                } elseif (!empty($_REQUEST['uid'])) { // Several records selected or this page selected
                    if (in_array($display['id'], $records)) {
                        $this->bean->map_markers[] = $this->getMarkerData($display_module, $display, false, $mod_strings_display);
                    }
                } else { // All
                    $this->bean->map_markers[] = $this->getMarkerData($display_module, $display, false, $mod_strings_display);
                }
            }
        }

// Sort marker groups for the view
        sort($this->bean->map_markers_groups);

// Set display object for later use
        $this->bean->display_object = $this->display_object;

// Get Prospect List Array Dropdown
        $list = get_module_info('ProspectLists');
        $list_query = $list->create_list_query('prospect_lists.name', '1=1', 0);
        $list_result = $list->db->query($list_query);
        $list_array = array();
        while ($alist = $list->db->fetchByAssoc($list_result)) {
            if (!empty($alist['name']) && !empty($alist['id'])) {
                $list_array[$alist['id']] = $alist['name'];
            }
        }
        $this->bean->list_array = $list_array;

}

// end function action_map_markers

/**
     * Define marker data for marker display view
     * @param $module_type bean name
     * @param $display bean fields array
     * $param $mod_strings_display mod_strings from display module
     * TODO: Use a custom defined field for the $marker['group']
     */
    function getMarkerData($module_type, $display, $center_marker = false, $mod_strings_display = array()) {

//        echo "<pre>";
//        print_r($display);
//        print_r($mod_strings_display);
//        echo "</pre>";

// Define Marker
        $marker = array();
        // Set only partial display data for efficiency
        $marker['name'] = $display['name'];
        // Or, Set all display data for flexibility
        //$marker = $display;
        if (empty($marker['name'])) {
            $marker['name'] = 'N/A';
        }
        $marker['id'] = $display['id'];
        $marker['module'] = $module_type;
        $marker['address'] = $display['jjwg_maps_address_c'];
        $marker['lat'] = $display['jjwg_maps_lat_c'];
        if (!$this->is_valid_lat($marker['lat'])) {
            $marker['lat'] = '0';
        }
        $marker['lng'] = $display['jjwg_maps_lng_c'];
        if (!$this->is_valid_lng($marker['lng'])) {
            $marker['lng'] = '0';
        }
        // Define a phone field: phone_office, phone_work, phone_mobile
        if (!empty($display['phone_office'])) {
            $marker['phone'] = $display['phone_office'];
        } elseif (!empty($display['phone_work'])) {
            $marker['phone'] = $display['phone_work'];
        } elseif (!empty($display['phone_mobile'])) {
            $marker['phone'] = $display['phone_mobile'];
        } else {
            $marker['phone'] = '';
        }

if ($marker['lat'] != '0' && $marker['lng'] != '0') {

// Check to see if marker point already exists and apply offset if needed
            // This often occurs when an address is only defined by city, state, zip.
            $i = 0;
            while (isset($this->map_marker_data_points[(string) $marker['lat']][(string) $marker['lng']]) &&
            $i < $this->settings['map_markers_limit']) {
                $marker['lat'] = (float) $marker['lat'] + (float) $this->settings['map_duplicate_marker_adjustment'];
                $marker['lng'] = (float) $marker['lng'] + (float) $this->settings['map_duplicate_marker_adjustment'];
                $i++;
            }
            // Set Marker Point as Used (true)
            $this->map_marker_data_points[(string) $marker['lat']][(string) $marker['lng']] = true;

if (isset($display['account_name'])) {
                $marker['account_name'] = $display['account_name'];
            }
            if (isset($display['account_id'])) {
                $marker['account_id'] = $display['account_id'];
            }
            $marker['assigned_user_name'] = (isset($display['assigned_user_name'])) ? $display['assigned_user_name'] : '';
            $marker['image'] = (isset($display['marker_image'])) ? $display['marker_image'] : '';

// Define Marker Group
            if (!$center_marker) {
                // Group Field for the Display Module
                $group_field_name = $this->settings['map_markers_grouping_field'][$module_type];
                $group_field_value = $display[$group_field_name];
                // Check for DOM field types (enum type)
                if (isset($this->display_object->field_name_map[$group_field_name]['type']) &&
                        $this->display_object->field_name_map[$group_field_name]['type'] == 'enum') {
                    $group_field_dom = $this->display_object->field_name_map[$group_field_name]['options'];
                    $marker['group'] = $GLOBALS['app_list_strings'][$group_field_dom][$group_field_value];
                } elseif (!empty($display[$group_field_name])) {
                    $marker['group'] = $display[$group_field_name];
                } else {
                    $marker['group'] = $GLOBALS['mod_strings']['LBL_MAP_NULL_GROUP_NAME']; // null group
                }
                if (!in_array($marker['group'], $this->bean->map_markers_groups)) {
                    $this->bean->map_markers_groups[] = $marker['group'];
                }
            }

/**
             *  Define Dates for Meetings
             *  TimeDate.php to_display_date_time()
             *  Note, date time fields are converted to the User's date time settings
             */
            if ($module_type == 'Meetings') {
                require_once('modules/Meetings/Meeting.php');
                require_once('include/TimeDate.php');
                if (!isset($meetingTimeDate) || !is_object($meetingTimeDate)) {
                    $meetingTimeDate = new TimeDate();
                }
                $display['date_start'] = $meetingTimeDate->to_display_date_time($display['date_start'], true, true, $GLOBALS['current_user']);
                $display['date_end'] = $meetingTimeDate->to_display_date_time($display['date_end'], true, true, $GLOBALS['current_user']);
            }
            $current_user_data = get_object_vars($GLOBALS['current_user']);
            $this->sugarSmarty->assign('current_user', $current_user_data);
            $this->sugarSmarty->assign('current_user_address', $this->bean->defineMapsFormattedAddress($current_user_data, 'address'));
            $this->sugarSmarty->assign("mod_strings", $mod_strings_display);
            // Define Maps Info Window HTML by Sugar Smarty Template
            $this->sugarSmarty->assign("module_type", $module_type);
            $this->sugarSmarty->assign("address", $display['jjwg_maps_address_c']);
            $this->sugarSmarty->assign("fields", $display); // display fields array
            // Use @ error suppression to avoid issues with SugarCRM On-Demand
            $marker['html'] = @$this->sugarSmarty->fetch('./custom/modules/jjwg_Maps/tpls/' . $module_type . 'InfoWindow.tpl');
            if (empty($marker['html'])) {
                $marker['html'] = $this->sugarSmarty->fetch('./modules/jjwg_Maps/tpls/' . $module_type . 'InfoWindow.tpl');
            }
            $marker['html'] = preg_replace('/\n\r/', ' ', $marker['html']);
            //var_dump($marker['html']);
            return $marker;

} else {
            return false;
        }
    }

/**
     * Get Marker Data Custom for Mapping
     * @param $marker_object
     */
    function getMarkerDataCustom($marker_object) {

// Define Marker
        $marker = array();
        $marker['name'] = $marker_object->name;
        if (empty($marker['name'])) {
            $marker['name'] = 'N/A';
        }
        $marker['id'] = $marker_object->id;
        $marker['lat'] = $marker_object->jjwg_maps_lat;
        if (!$this->is_valid_lat($marker['lat'])) {
            $marker['lat'] = '0';
        }
        $marker['lng'] = $marker_object->jjwg_maps_lng;
        if (!$this->is_valid_lng($marker['lng'])) {
            $marker['lng'] = '0';
        }
        $marker['image'] = $marker_object->marker_image;
        if (empty($marker['image'])) {
            $marker['image'] = 'None';
        }

if ($marker['lat'] != '0' || $marker['lng'] != '0') {

$fields = array();
            foreach ($marker_object->column_fields as $field) {
                $fields[$field] = $marker_object->$field;
            }
            // Define Maps Info Window HTML by Sugar Smarty Template
            $this->sugarSmarty->assign("module_type", 'jjwg_Markers');
            $this->sugarSmarty->assign("fields", $fields); // display fields array
            // Use @ error suppression to avoid issues with SugarCRM On-Demand
            $marker['html'] = @$this->sugarSmarty->fetch('./custom/modules/jjwg_Markers/tpls/MarkersInfoWindow.tpl');
            if (empty($marker['html'])) {
                $marker['html'] = $this->sugarSmarty->fetch('./modules/jjwg_Markers/tpls/MarkersInfoWindow.tpl');
            }
            $marker['html'] = preg_replace('/\n\r/', ' ', $marker['html']);
            //var_dump($marker['html']);
            return $marker;

} else {
            return false;
        }
    }

/**
     * Get Area Data Custom for Mapping
     * @param $area_object
     */
    function getAreaDataCustom($area_object) {

// Define Area
        $area = array();
        $area['name'] = $area_object->name;
        if (empty($area['name'])) {
            $area['name'] = 'N/A';
        }
        $area['id'] = $area_object->id;
        $area['coordinates'] = $area_object->coordinates;

// Check for proper coordinates pattern
        if (preg_match('/^[0-9\s\,\.\-]+$/', $area_object->coordinates)) {

$fields = array();
            foreach ($area_object->column_fields as $field) {
                $fields[$field] = $area_object->$field;
            }
            // Define Maps Info Window HTML by Sugar Smarty Template
            $this->sugarSmarty->assign("module_type", 'jjwg_Areas');
            $this->sugarSmarty->assign("fields", $fields); // display fields array
            // Use @ error suppression to avoid issues with SugarCRM On-Demand
            $area['html'] = @$this->sugarSmarty->fetch('./custom/modules/jjwg_Areas/tpls/AreasInfoWindow.tpl');
            if (empty($area['html'])) {
                $area['html'] = $this->sugarSmarty->fetch('./modules/jjwg_Areas/tpls/AreasInfoWindow.tpl');
            }
            $area['html'] = preg_replace('/\n\r/', ' ', $area['html']);
            //var_dump($marker['html']);
            return $area;

} else {
            return false;
        }
    }

/**
     * Check for valid longitude
     * @param $lng float
     */
    function is_valid_lng($lng) {
        return (is_numeric($lng) && $lng >= -180 && $lng <= 180);
    }

/**
     * Check for valid latitude
     * @param $lat float
     */
    function is_valid_lat($lat) {
        return (is_numeric($lat) && $lat >= -90 && $lat <= 90);
    }

}

TERMOREK-IT SHELL 403

Edit file