<?php
if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
/*********************************************************************************
 * SugarCRM Community Edition is a customer relationship management program developed by
 * SugarCRM, Inc. Copyright (C) 2004-2013 SugarCRM Inc.
 * 
 * This program is free software; you can redistribute it and/or modify it under
 * the terms of the GNU Affero General Public License version 3 as published by the
 * Free Software Foundation with the addition of the following permission added
 * to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
 * IN WHICH THE COPYRIGHT IS OWNED BY SUGARCRM, SUGARCRM DISCLAIMS THE WARRANTY
 * OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
 * 
 * This program is distributed in the hope that it will be useful, but WITHOUT
 * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
 * FOR A PARTICULAR PURPOSE.  See the GNU Affero General Public License for more
 * details.
 * 
 * You should have received a copy of the GNU Affero General Public License along with
 * this program; if not, see http://www.gnu.org/licenses or write to the Free
 * Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
 * 02110-1301 USA.
 * 
 * You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
 * SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
 * 
 * The interactive user interfaces in modified source and object code versions
 * of this program must display Appropriate Legal Notices, as required under
 * Section 5 of the GNU Affero General Public License version 3.
 * 
 * In accordance with Section 7(b) of the GNU Affero General Public License version 3,
 * these Appropriate Legal Notices must retain the display of the "Powered by
 * SugarCRM" logo. If the display of the logo is not reasonably feasible for
 * technical reasons, the Appropriate Legal Notices must display the words
 * "Powered by SugarCRM".
 ********************************************************************************/

require_once('include/EditView/SugarVCR.php');
/**
 * ListView - list of many objects
 * @api
 */
class ListView
{
    var $local_theme= null;
    var $local_app_strings= null;
    var $local_image_path = null;
    var $local_current_module = null;
    var $local_mod_strings = null;
    var $records_per_page = 20;
    var $xTemplate = null;
    var $xTemplatePath = null;
    var $seed_data = null;
    var $query_where = null;
    var $query_limit = -1;
    var $query_orderby = null;
    var $header_title = '';
    var $header_text = '';
    var $initialized = false;
    var $show_export_button = true;
    var $show_delete_button = true;
    var $show_select_menu = true;
    var $show_paging = true;
    var $show_mass_update = true;
    var $show_mass_update_form = true;
    var $query_where_has_changed = false;
    var $display_header_and_footer = true;
    var $baseURL = '';
    var $is_dynamic = false;
    var $inline = false;
    var $start_link_wrapper = '';
    var $end_link_wrapper = '';
    var $list_field_defs = array();

    var $shouldProcess = false;
    var $data_array;
    var $related_field_name = '';
    var $child_focus = '';
    var $layout_manager = null;
    var $process_for_popups = false;
    var $multi_select_popup=false;
    var $_additionalDetails = false;
    var $additionalDetailsFunction = null;
    var $sort_order = '';
    var $force_mass_update=false;
    var $keep_mass_update_form_open=false;
    var $ignorePopulateOnly = false;

function setDataArray($value) {
    $this->data_array = $value;
}

function processListViewMulti($seed, $xTemplateSection, $html_varName) {

    $this->shouldProcess = true;

    echo "<form name='MassUpdate' method='post' action='index.php'>";
    $this->processListViewTwo($seed, $xTemplateSection, $html_varName);

    echo "<a href='javascript:" . ((!$this->multi_select_popup) ? 'sListView.' : ''). "check_all(document.MassUpdate, \"mass[]\", true)'>".translate('LBL_CHECKALL')."</a> - <a href='javascript:sListView.check_all(document.MassUpdate, \"mass[]\", false);'>".translate('LBL_CLEARALL')."</a>";
    echo '<br><br>';
}


function processListView($seed, $xTemplateSection, $html_varName)
{
    global $sugar_config;

    $populateOnly = $this->ignorePopulateOnly ? FALSE : (!empty($sugar_config['save_query']) && $sugar_config['save_query'] == 'populate_only');
    if(isset($seed->module_dir) && $populateOnly) {
        if(empty($GLOBALS['displayListView']) && strcmp(strtolower($_REQUEST['action']), 'popup') != 0 && (!empty($_REQUEST['clear_query']) || $_REQUEST['module'] == $seed->module_dir && ((empty($_REQUEST['query']) || $_REQUEST['query'] == 'MSI')&& (empty($_SESSION['last_search_mod']) || $_SESSION['last_search_mod'] != $seed->module_dir)))) {
            $_SESSION['last_search_mod'] = $_REQUEST['module'] ;
            return;
        }
    }
    if(strcmp(strtolower($_REQUEST['action']), 'popup') != 0){
        $_SESSION['last_search_mod'] = $_REQUEST['module'] ;
    }
    //following session variable will track the detail view navigation history.
    //needs to the reset after each search.
    $this->setLocalSessionVariable($html_varName,"DETAIL_NAV_HISTORY",false);

    require_once('include/MassUpdate.php');
    $mass = new MassUpdate();
    $add_acl_javascript = false;
    if(!isset($_REQUEST['action'])) {
        $this->shouldProcess=false;
    } else {
    $this->shouldProcess = is_subclass_of($seed, "SugarBean")
        && (($_REQUEST['action'] == 'index') || ('ListView' == substr($_REQUEST['action'],0,8)) /* cn: to include all ListViewXXX.php type views */)
        && ($_REQUEST['module'] == $seed->module_dir);
    }

    //when processing a multi-select popup.
    if($this->process_for_popups && $this->multi_select_popup)  $this->shouldProcess =true;
    //mass update turned off?
    if(!$this->show_mass_update) $this->shouldProcess = false;
    if(is_subclass_of($seed, "SugarBean")) {
        if($seed->bean_implements('ACL')) {
            if(!ACLController::checkAccess($seed->module_dir,'list',true)) {
                if($_REQUEST['module'] != 'Home') {
                    ACLController::displayNoAccess();
                }
                return;
            }
            if(!ACLController::checkAccess($seed->module_dir,'export',true)) {
                $sugar_config['disable_export']= true;
            }

        }
    }

    //force mass update form if requested.
    if($this->force_mass_update) {
        $this->shouldProcess = true;
    }

    if($this->shouldProcess) {
        echo $mass->getDisplayMassUpdateForm(true, $this->multi_select_popup);
        echo $mass->getMassUpdateFormHeader($this->multi_select_popup);
        $mass->setSugarBean($seed);

        //C.L. Fix for 10048, do not process handleMassUpdate for multi select popups
        if(!$this->multi_select_popup) {
            $mass->handleMassUpdate();
        }
    }

    $this->processListViewTwo($seed,$xTemplateSection, $html_varName);

    if($this->shouldProcess && empty($this->process_for_popups)) {
        //echo "<a href='javascript:sListView.clear_all(document.MassUpdate, \"mass[]\");'>".translate('LBL_CLEARALL')."</a>";
        // cn: preserves current functionality, exception is InboundEmail
        if($this->show_mass_update_form) {
            echo $mass->getMassUpdateForm();
        }
        if(!$this->keep_mass_update_form_open) {
            echo $mass->endMassUpdateForm();
        }
    }
}


function process_dynamic_listview($source_module, $sugarbean,$subpanel_def)
{
        $this->source_module = $source_module;
        $this->subpanel_module = $subpanel_def->name;
        if(!isset($this->xTemplate))
            $this->createXTemplate();

        $html_var = $this->subpanel_module . "_CELL";

        $list_data = $this->processUnionBeans($sugarbean,$subpanel_def, $html_var);

        $list = $list_data['list'];
        $parent_data = $list_data['parent_data'];

        if($subpanel_def->isCollection()) {
            $thepanel=$subpanel_def->get_header_panel_def();
        } else {
            $thepanel=$subpanel_def;
        }



        $this->process_dynamic_listview_header($thepanel->get_module_name(), $thepanel, $html_var);
        $this->process_dynamic_listview_rows($list,$parent_data, 'dyn_list_view', $html_var,$subpanel_def);

        if($this->display_header_and_footer)
        {
            $this->getAdditionalHeader();
            if(!empty($this->header_title))
            {
                echo get_form_header($this->header_title, $this->header_text, false);
            }
        }

        $this->xTemplate->out('dyn_list_view');

        if(isset($_SESSION['validation']))
        {
            print base64_decode('PGEgaHJlZj0naHR0cDovL3d3dy5zdWdhcmNybS5jb20nPlBPV0VSRUQmbmJzcDtCWSZuYnNwO1NVR0FSQ1JNPC9hPg==');
        }
        if(isset($list_data['query'])) {
            return ($list_data['query']);
        }
    }

/**
 * @return void
 * @param unknown $data
 * @param unknown $xTemplateSection
 * @param unknown $html_varName
 * @desc INTERNAL FUNCTION handles the rows
 */
 function process_dynamic_listview_rows($data,$parent_data, $xtemplateSection, $html_varName, $subpanel_def)
 {
    global $subpanel_item_count;
    global $odd_bg;
    global $even_bg;
    global $hilite_bg;
    global $click_bg;

    $this->xTemplate->assign("BG_HILITE", $hilite_bg);
    $this->xTemplate->assign('CHECKALL', SugarThemeRegistry::current()->getImage('blank', '', 1, 1, ".gif", ''));
    //$this->xTemplate->assign("BG_CLICK", $click_bg);
    $subpanel_item_count = 0;
    $oddRow = true;
    $count = 0;
    reset($data);

    //GETTING OFFSET
    $offset = $this->getOffset($html_varName);
    //$totaltime = 0;
    $processed_ids = array();

    $fill_additional_fields = array();
    //Either retrieve the is_fill_in_additional_fields property from the lone
    //subpanel or visit each subpanel's subpanels to retrieve the is_fill_in_addition_fields
    //property
    $subpanel_list=array();
    if($subpanel_def->isCollection()) {
        $subpanel_list=$subpanel_def->sub_subpanels;
    } else {
        $subpanel_list[]= $subpanel_def;
    }

    foreach($subpanel_list as $this_subpanel)
    {
        if($this_subpanel->is_fill_in_additional_fields())
        {
            $fill_additional_fields[] = $this_subpanel->bean_name;
            $fill_additional_fields[$this_subpanel->bean_name] = true;
        }
    }

    if ( empty($data) ) {
        $this->xTemplate->assign("ROW_COLOR", 'oddListRow');
        $thepanel=$subpanel_def;
        if($subpanel_def->isCollection())
            $thepanel=$subpanel_def->get_header_panel_def();
        $this->xTemplate->assign("COL_COUNT", count($thepanel->get_list_fields()));
        $this->xTemplate->parse($xtemplateSection.".nodata");
    }
    while(list($aVal, $aItem) = each($data))
    {
        $subpanel_item_count++;
        $aItem->check_date_relationships_load();
        // TODO: expensive and needs to be removed and done better elsewhere

        if(!empty($fill_additional_fields[$aItem->object_name])
        || ($aItem->object_name == 'Case' && !empty($fill_additional_fields['aCase']))
        )
        {
            $aItem->fill_in_additional_list_fields();
            //$aItem->fill_in_additional_detail_fields();
        }
        //rrs bug: 25343
        $aItem->call_custom_logic("process_record");

        if(isset($parent_data[$aItem->id])) {

            $aItem->parent_name = $parent_data[$aItem->id]['parent_name'];
            if(!empty($parent_data[$aItem->id]['parent_name_owner'])) {
            $aItem->parent_name_owner =  $parent_data[$aItem->id]['parent_name_owner'];
            $aItem->parent_name_mod =  $parent_data[$aItem->id]['parent_name_mod'];
        }}
        $fields = $aItem->get_list_view_data();
        if(isset($processed_ids[$aItem->id])) {
            continue;

        } else {
            $processed_ids[$aItem->id] = 1;
        }


        //ADD OFFSET TO ARRAY
        $fields['OFFSET'] = ($offset + $count + 1);

        if($this->shouldProcess) {
            if($aItem->ACLAccess('EditView')) {
            $this->xTemplate->assign('PREROW', "<input type='checkbox' class='checkbox' name='mass[]' value='". $fields['ID']. "' />");
            } else {
                $this->xTemplate->assign('PREROW', '');

            }
            if($aItem->ACLAccess('DetailView')) {
                $this->xTemplate->assign('TAG_NAME','a');
            } else {
                $this->xTemplate->assign('TAG_NAME','span');
            }
            $this->xTemplate->assign('CHECKALL', "<input type='checkbox'  title='".$GLOBALS['app_strings']['LBL_SELECT_ALL_TITLE']."' class='checkbox' name='massall' id='massall' value='' onclick='sListView.check_all(document.MassUpdate, \"mass[]\", this.checked);' />");
        }

        if($oddRow)
        {
            $ROW_COLOR = 'oddListRow';
            $BG_COLOR =  $odd_bg;
        }
        else
        {
            $ROW_COLOR = 'evenListRow';
            $BG_COLOR =  $even_bg;
        }
        $oddRow = !$oddRow;
		$button_contents = array();
        $this->xTemplate->assign("ROW_COLOR", $ROW_COLOR);
        $this->xTemplate->assign("BG_COLOR", $BG_COLOR);
        $layout_manager = $this->getLayoutManager();
        $layout_manager->setAttribute('context','List');
        $layout_manager->setAttribute('image_path',$this->local_image_path);
        $layout_manager->setAttribute('module_name', $subpanel_def->_instance_properties['module']);
        if(!empty($this->child_focus))
            $layout_manager->setAttribute('related_module_name',$this->child_focus->module_dir);

        //AG$subpanel_data = $this->list_field_defs;
        //$bla = array_pop($subpanel_data);
        //select which sub-panel to display here, the decision will be made based on the type of
        //the sub-panel and panel in the bean being processed.
        if($subpanel_def->isCollection()) {
            $thepanel=$subpanel_def->sub_subpanels[$aItem->panel_name];
        } else {
            $thepanel=$subpanel_def;
        }
        //get data source name
        $linked_field=$thepanel->get_data_source_name();
        $linked_field_set=$thepanel->get_data_source_name(true);
        static $count;
        if(!isset($count))$count = 0;

        $field_acl['DetailView'] = $aItem->ACLAccess('DetailView');
        $field_acl['ListView'] = $aItem->ACLAccess('ListView');
        $field_acl['EditView'] = $aItem->ACLAccess('EditView');
        $field_acl['Delete'] = $aItem->ACLAccess('Delete');
        foreach($thepanel->get_list_fields() as $field_name=>$list_field)
        {
            //add linked field attribute to the array.
            $list_field['linked_field']=$linked_field;
            $list_field['linked_field_set']=$linked_field_set;

            $usage = empty($list_field['usage']) ? '' : $list_field['usage'];
            if($usage != 'query_only')
            {
                $list_field['name']=$field_name;

                $module_field = $field_name.'_mod';
                $owner_field = $field_name.'_owner';
                if(!empty($aItem->$module_field)) {

                    $list_field['owner_id'] = $aItem->$owner_field;
                    $list_field['owner_module'] = $aItem->$module_field;

                } else {
                    $list_field['owner_id'] = false;
                    $list_field['owner_module'] = false;
                }
                if(isset($list_field['alias'])) $list_field['name'] = $list_field['alias'];
                else $list_field['name']=$field_name;
                $list_field['fields'] = $fields;
                $list_field['module'] = $aItem->module_dir;
                $list_field['start_link_wrapper'] = $this->start_link_wrapper;
                $list_field['end_link_wrapper'] = $this->end_link_wrapper;
                $list_field['subpanel_id'] = $this->subpanel_id;
                $list_field += $field_acl;
                if ( isset($aItem->field_defs[strtolower($list_field['name'])])) {
                    require_once('include/SugarFields/SugarFieldHandler.php');
                    // We need to see if a sugar field exists for this field type first,
                    // if it doesn't, toss it at the old sugarWidgets. This is for
                    // backwards compatibility and will be removed in a future release
                    $vardef = $aItem->field_defs[strtolower($list_field['name'])];
                    if ( isset($vardef['type']) ) {
                        $fieldType = isset($vardef['custom_type'])?$vardef['custom_type']:$vardef['type'];
                        $tmpField = SugarFieldHandler::getSugarField($fieldType,true);
                    } else {
                        $tmpField = NULL;
                    }

                    if ( $tmpField != NULL ) {
                        $widget_contents = SugarFieldHandler::displaySmarty($list_field['fields'],$vardef,'ListView',$list_field);
                    } else {
                        // No SugarField for this particular type
                        // Use the old, icky, SugarWidget for now
                        $widget_contents = $layout_manager->widgetDisplay($list_field);
                    }

                    if ( isset($list_field['widget_class']) && $list_field['widget_class'] == 'SubPanelDetailViewLink' ) {
                        // We need to call into the old SugarWidgets for the time being, so it can generate a proper link with all the various corner-cases handled
                        // So we'll populate the field data with the pre-rendered display for the field
                        $list_field['fields'][$field_name] = $widget_contents;
                        if('full_name' == $field_name){//bug #32465
                           $list_field['fields'][strtoupper($field_name)] = $widget_contents;
                        }

                        //vardef source is non db, assign the field name to varname for processing of column.
                        if(!empty($vardef['source']) && $vardef['source']=='non-db'){
                            $list_field['varname'] = $field_name;

                        }
                        $widget_contents = $layout_manager->widgetDisplay($list_field);
                    } else if(isset($list_field['widget_class']) && $list_field['widget_class'] == 'SubPanelEmailLink' ) {
                        $widget_contents = $layout_manager->widgetDisplay($list_field);
                    }

                 $count++;
                $this->xTemplate->assign('CELL_COUNT', $count);
                $this->xTemplate->assign('CLASS', "");
                if ( empty($widget_contents) ) $widget_contents = '&nbsp;';
                $this->xTemplate->assign('CELL', $widget_contents);
                $this->xTemplate->parse($xtemplateSection.".row.cell");
                } else {
                    // This handles the edit and remove buttons and icon widget
                	if( isset($list_field['widget_class']) && $list_field['widget_class'] == "SubPanelIcon") {
		                $count++;
		                $widget_contents = $layout_manager->widgetDisplay($list_field);
		                $this->xTemplate->assign('CELL_COUNT', $count);
		                $this->xTemplate->assign('CLASS', "");
		                if ( empty($widget_contents) ) $widget_contents = '&nbsp;';
		                $this->xTemplate->assign('CELL', $widget_contents);
		                $this->xTemplate->parse($xtemplateSection.".row.cell");
                	} elseif (preg_match("/button/i", $list_field['name'])) {
                        if ( '' != $_content = $layout_manager->widgetDisplay($list_field) )
                        {
                            $button_contents[] = $_content;
                            unset($_content);
                        }
                	} else {
               			$count++;
               			$this->xTemplate->assign('CLASS', "");
               			$widget_contents = $layout_manager->widgetDisplay($list_field);
		                $this->xTemplate->assign('CELL_COUNT', $count);
		                if ( empty($widget_contents) ) $widget_contents = '&nbsp;';
		                $this->xTemplate->assign('CELL', $widget_contents);
		                $this->xTemplate->parse($xtemplateSection.".row.cell");
                	}
                }

            }
        }


        // Make sure we have at least one button before rendering a column for
        // the action buttons in a list view. Relevant bugs: #51647 and #51640.
        if(isset($button_contents[0])) {
            // this is for inline buttons on listviews
            // bug#51275: smarty widget to help provide the action menu functionality as it is currently sprinkled throughout the app with html
            require_once('include/Smarty/plugins/function.sugar_action_menu.php');
            $tempid = create_guid();
            $button_contents[0] = "<div style='display: inline' id='$tempid'>".$button_contents[0]."</div>";
            $action_button = smarty_function_sugar_action_menu(array(
                'id' => $tempid,
                'buttons' => $button_contents,
                'class' => 'clickMenu subpanel records fancymenu button',
                'flat' => false //assign flat value as false to display dropdown menu at any other preferences.
            ), $this->xTemplate);
            $this->xTemplate->assign('CLASS', "inlineButtons");
            $this->xTemplate->assign('CELL_COUNT', ++$count);
            //Bug#51275 for beta3 pre_script is not required any more
            $this->xTemplate->assign('CELL', $action_button);
            $this->xTemplate->parse($xtemplateSection.".row.cell");
        }


        $aItem->setupCustomFields($aItem->module_dir);
        $aItem->custom_fields->populateAllXTPL($this->xTemplate, 'detail', $html_varName, $fields);

        $count++;

        $this->xTemplate->parse($xtemplateSection.".row");
    }

    $this->xTemplate->parse($xtemplateSection);
}

/**sets whether or not to display the xtemplate header and footer
 * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc.
 * All Rights Reserved.
 * Contributor(s): ______________________________________.
*/
function setDisplayHeaderAndFooter($bool) {
        $this->display_header_and_footer = $bool;
}

/**initializes ListView
 * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc.
 * All Rights Reserved.
 * Contributor(s): ______________________________________.
*/
 function ListView() {


    if(!$this->initialized) {
        global $sugar_config;
        $this->records_per_page = $sugar_config['list_max_entries_per_page'] + 0;
        $this->initialized = true;
        global $app_strings, $currentModule;
        $this->local_theme = SugarThemeRegistry::current()->__toString();
        $this->local_app_strings =$app_strings;
        $this->local_image_path = SugarThemeRegistry::current()->getImagePath();
        $this->local_current_module = $currentModule;
    }
}
/**sets how many records should be displayed per page in the list view
 * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc.
 * All Rights Reserved.
 * Contributor(s): ______________________________________.
*/
 function setRecordsPerPage($count) {
    $this->records_per_page = $count;
}
/**sets the header title */
 function setHeaderTitle($value) {
    $this->header_title = $value;
}
/**sets the header text this is text that's appended to the header table and is usually used for the creation of buttons
 * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc.
 * All Rights Reserved.
 * Contributor(s): ______________________________________.
*/
 function setHeaderText($value) {
    $this->header_text = $value;
}
/**sets the path for the XTemplate HTML file to be used this is only needed to be set if you are allowing ListView to create the XTemplate
 * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc.
 * All Rights Reserved.
 * Contributor(s): ______________________________________.
*/
 function setXTemplatePath($value) {
    $this->xTemplatePath= $value;
}

/**this is a helper function for allowing ListView to create a new XTemplate it groups parameters that should be set into a single function
 * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc.
 * All Rights Reserved.
 * Contributor(s): ______________________________________.
*/
 function initNewXTemplate($XTemplatePath, $modString, $imagePath = null) {
    $this->setXTemplatePath($XTemplatePath);
    if(isset($modString))
        $this->setModStrings($modString);
    if(isset($imagePath))
        $this->setImagePath($imagePath);
}


function getOrderBy($varName, $defaultOrderBy='', $force_sortorder='') {
    $sortBy = $this->getSessionVariable($varName, "ORDER_BY") ;

    $orderByDirection = $this->getSessionVariableName($varName, "order_by_direction");
    $orderByColumn = $this->getSessionVariableName($varName, "ORDER_BY");
    $lastEqualsSortBy = false;
    $defaultOrder = false; //ascending

    if(empty($sortBy)) {
        $this->setUserVariable($varName, "ORDER_BY", $defaultOrderBy);
        $sortBy = $defaultOrderBy;
    } else {
        $this->setUserVariable($varName, "ORDER_BY", $sortBy);
    }

    $desc = $this->getSessionVariable($varName, $sortBy."S");

    if (empty($desc))
        {
            $desc = $defaultOrder;
        }
        $defaultOrder = $desc ? 'desc' : 'asc';
        $orderByValue = $defaultOrder;
        if (isset($_REQUEST[$orderByDirection]))
        {
            $possibleRequestOrderBy = $_REQUEST[$orderByDirection];
            if ($possibleRequestOrderBy == 'asc' || $possibleRequestOrderBy == 'desc')
            {
                $orderByValue = $possibleRequestOrderBy;
            }
        }

        if (isset($_REQUEST[$orderByColumn]))
        {
            $last = $this->getSessionVariable($varName, "OBL");
        }
        if (!empty($last) && $last == $sortBy)
        {
            $lastEqualsSortBy = true;
        } else
        {
            $orderByValue = $defaultOrder;
            $this->setSessionVariable($varName, "OBL", $sortBy);
        }
        $desc = $orderByValue == 'desc';
        $orderByDirectionValue = false;
        $this->setSessionVariable($varName, $sortBy . "S", $desc);
        if (!empty($sortBy))
        {
            if (empty($force_sortorder))
            {
                if (substr_count(strtolower($sortBy), ' desc') == 0 && substr_count(strtolower($sortBy), ' asc') == 0)
                {
                    if ($sortBy)
                    {
                        $orderByDirectionValue = $desc ? 'asc' : 'desc';
                    }
                    $this->query_orderby = $sortBy . ' ' . $orderByValue;
                }
            } else
            {
                $this->query_orderby = $sortBy . ' ' . $force_sortorder;
            }
            if (!isset($this->appendToBaseUrl))
            {
                $this->appendToBaseUrl = array();
            }
            if ($orderByDirectionValue)
            {
                $this->appendToBaseUrl[$orderByDirection] = $orderByDirectionValue;
            }
            $offsetVar = $this->getSessionVariableName($varName, "offset");
            if (isset($_REQUEST[$offsetVar]))
            {
                $this->appendToBaseUrl[$offsetVar] = $_REQUEST[$offsetVar];
            }
            //Just clear from url...
            $this->appendToBaseUrl[$orderByColumn] = false;
    }else {
        $this->query_orderby = "";
    }
    $this->sortby = $sortBy;
    return $this->query_orderby;

}


/**sets the parameters dealing with the db
 * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc.
 * All Rights Reserved.
 * Contributor(s): ______________________________________.
*/
 function setQuery($where, $limit, $orderBy, $varName, $allowOrderByOveride=true) {
    $this->query_where = $where;
    if($this->getSessionVariable("query", "where") != $where) {
        $this->query_where_has_changed = true;
        $this->setSessionVariable("query", "where", $where);
    }

    $this->query_limit = $limit;
    if(!$allowOrderByOveride) {
        $this->query_orderby = $orderBy;
        return;
    }
    $this->getOrderBy($varName, $orderBy);

    $this->setLocalSessionVariable($varName, "QUERY_WHERE", $where);

    //SETTING ORDER_BY FOR USE IN DETAILVIEW
    $this->setLocalSessionVariable($varName, "ORDER_BY_DETAIL", $this->query_orderby);
}

function displayArrow() {

}

/**sets the theme used only use if it is different from the global
 * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc.
 * All Rights Reserved.
 * Contributor(s): ______________________________________.
*/
 function setTheme($theme) {
    $this->local_theme = $theme;
    if(isset($this->xTemplate))$this->xTemplate->assign("THEME", $this->local_theme);
}

/**sets the AppStrings used only use if it is different from the global
 * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc.
 * All Rights Reserved.
 * Contributor(s): ______________________________________.
*/
 function setAppStrings($app_strings) {
    unset($this->local_app_strings);
    $this->local_app_strings = $app_strings;
    if(isset($this->xTemplate))$this->xTemplate->assign("APP", $this->local_app_strings);
}

/**sets the ModStrings used
 * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc.
 * All Rights Reserved.
 * Contributor(s): ______________________________________.
*/
 function setModStrings($mod_strings) {
    unset($this->local_module_strings);
    $this->local_mod_strings = $mod_strings;
    if(isset($this->xTemplate))$this->xTemplate->assign("MOD", $this->local_mod_strings);
}

/**sets the ImagePath used
 * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc.
 * All Rights Reserved.
 * Contributor(s): ______________________________________.
*/
 function setImagePath($image_path) {
    $this->local_image_path = $image_path;
    if(empty($this->local_image_path)) {
        $this->local_image_path = SugarThemeRegistry::get($this->local_theme)->getImagePath();
    }
    if(isset($this->xTemplate))$this->xTemplate->assign("IMAGE_PATH", $this->local_image_path);
}

/**sets the currentModule only use if this is different from the global
 * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc.
 * All Rights Reserved.
 * Contributor(s): ______________________________________.
*/
 function setCurrentModule($currentModule) {
    unset($this->local_current_module);
    $this->local_current_module = $currentModule;
    if(isset($this->xTemplate))$this->xTemplate->assign("MODULE_NAME", $this->local_current_module);
}

/**INTERNAL FUNCTION creates an XTemplate DO NOT CALL THIS THIS IS AN INTERNAL FUNCTION
 * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc.
 * All Rights Reserved.
 * Contributor(s): ______________________________________.
*/
 function createXTemplate() {
    if(!isset($this->xTemplate)) {
        if(isset($this->xTemplatePath)) {

            $this->xTemplate = new XTemplate($this->xTemplatePath);
            $this->xTemplate->assign("APP", $this->local_app_strings);
            if(isset($this->local_mod_strings))$this->xTemplate->assign("MOD", $this->local_mod_strings);
            $this->xTemplate->assign("THEME", $this->local_theme);
            $this->xTemplate->assign("IMAGE_PATH", $this->local_image_path);
            $this->xTemplate->assign("MODULE_NAME", $this->local_current_module);
        } else {
            $GLOBALS['log']->error("NO XTEMPLATEPATH DEFINED CANNOT CREATE XTEMPLATE");
        }
    }
}

/**sets the XTemplate telling ListView to use newXTemplate as its current XTemplate
 * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc.
 * All Rights Reserved.
 * Contributor(s): ______________________________________.
*/
 function setXTemplate($newXTemplate) {
    $this->xTemplate = $newXTemplate;
}

/**returns the XTemplate
 * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc.
 * All Rights Reserved.
 * Contributor(s): ______________________________________.
*/
 function getXTemplate() {
    return $this->xTemplate;
}

/**assigns a name value pair to the XTemplate
 * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc.
 * All Rights Reserved.
 * Contributor(s): ______________________________________.
*/
 function xTemplateAssign($name, $value) {

        if(!isset($this->xTemplate)) {
            $this->createXTemplate();
        }
        $this->xTemplate->assign($name, $value);

}

/**INTERNAL FUNCTION returns the offset first checking the query then checking the session if the where clause has changed from the last time it returns 0
 * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc.
 * All Rights Reserved.
 * Contributor(s): ______________________________________.
*/
 function getOffset($localVarName) {
 	if($this->query_where_has_changed || isset($GLOBALS['record_has_changed'])) {
 		$this->setSessionVariable($localVarName,"offset", 0);
 	}
	$offset = $this->getSessionVariable($localVarName,"offset");
	if(isset($offset)) {
		return $offset;
	}
	return 0;
}

/**INTERNAL FUNCTION sets the offset in the session
 * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc.
 * All Rights Reserved.
 * Contributor(s): ______________________________________.
*/
 function setOffset($localVarName, $value) {
        $this->setSessionVariable($localVarName, "offset", $value);
}

/**INTERNAL FUNCTION sets a session variable
 * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc.
 * All Rights Reserved.
 * Contributor(s): ______________________________________.
*/
 function setSessionVariable($localVarName,$varName, $value) {
    $_SESSION[$this->local_current_module."_".$localVarName."_".$varName] = $value;
}

function setUserVariable($localVarName,$varName, $value) {
        if($this->is_dynamic ||  $localVarName == 'CELL')return;
        global $current_user;
        $current_user->setPreference($this->local_current_module."_".$localVarName."_".$varName, $value);
}

/**INTERNAL FUNCTION returns a session variable first checking the query for it then checking the session
 * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc.
 * All Rights Reserved.
 * Contributor(s): ______________________________________.
*/
 function getSessionVariable($localVarName,$varName) {
    //Set any variables pass in through request first
    if(isset($_REQUEST[$this->getSessionVariableName($localVarName, $varName)])) {
        $this->setSessionVariable($localVarName,$varName,$_REQUEST[$this->getSessionVariableName($localVarName, $varName)]);
    }

    if(isset($_SESSION[$this->getSessionVariableName($localVarName, $varName)])) {
        return $_SESSION[$this->getSessionVariableName($localVarName, $varName)];
    }
    return "";
}

function getUserVariable($localVarName, $varName) {
    global $current_user;
    if($this->is_dynamic ||  $localVarName == 'CELL')return;
    if(isset($_REQUEST[$this->getSessionVariableName($localVarName, $varName)])) {

            $this->setUserVariable($localVarName,$varName,$_REQUEST[$this->getSessionVariableName($localVarName, $varName)]);
    }
    return $current_user->getPreference($this->getSessionVariableName($localVarName, $varName));
}


    /**
     * helper method to determine sort order by priority of source
     * 1. explicit in request object
     * 2. in session variable
     * 3. subpaneldefs metadata
     * 4. default 'asc'
     * @param array $sortOrderList - contains options
     * @return string 'asc' | 'desc'
     */
    function calculateSortOrder($sortOrderList)
    {
        $priority_map = array(
          'request',
          'session',
          'subpaneldefs',
          'default',
        );

        foreach($priority_map as $p) {
            if (key_exists($p, $sortOrderList)) {
                $order = strtolower($sortOrderList[$p]);
                if (in_array($order, array('asc', 'desc'))) {
                    return $order;
                }
            }
        }
        return 'asc';
    }


    /**

    * @return void
    * @param unknown $localVarName
    * @param unknown $varName
    * @desc INTERNAL FUNCTION returns the session/query variable name
    * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc.
    * All Rights Reserved.
    * Contributor(s): ______________________________________..
    */
    function getSessionVariableName($localVarName,$varName) {
        return $this->local_current_module."_".$localVarName."_".$varName;
    }

    /**

    * @return void
    * @param unknown $seed
    * @param unknown $xTemplateSection
    * @param unknown $html_varName
    * @desc INTERNAL FUNCTION Handles List Views using seeds that extend SugarBean
        $XTemplateSection is the section in the XTemplate file that should be parsed usually main
        $html_VarName is the variable name used in the XTemplateFile e.g. TASK
        $seed is a seed that extends SugarBean
        * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc..
        * All Rights Reserved..
        * Contributor(s): ______________________________________..
    */
    function processSugarBean($xtemplateSection, $html_varName, $seed) {
        global $list_view_row_count;

        $current_offset = $this->getOffset($html_varName);
        $response = array();

        //ADDING VCR CONTROL
        SugarVCR::erase($seed->module_dir);
        $params = array();
        //$filter = array('id', 'full_name');
        $filter=array();
        $ret_array = $seed->create_new_list_query($this->query_orderby, $this->query_where, $filter, $params, 0, '', true, $seed, true);
        if(!is_array($params)) $params = array();
        if(!isset($params['custom_select'])) $params['custom_select'] = '';
        if(!isset($params['custom_from'])) $params['custom_from'] = '';
        if(!isset($params['custom_where'])) $params['custom_where'] = '';
        if(!isset($params['custom_order_by'])) $params['custom_order_by'] = '';
        $main_query = $ret_array['select'] . $params['custom_select'] . $ret_array['from'] . $params['custom_from'] . $ret_array['where'] . $params['custom_where'] . $ret_array['order_by'] . $params['custom_order_by'];
        SugarVCR::store($seed->module_dir,  $main_query);
        //ADDING VCR CONTROL

        if(empty($this->related_field_name)) {
            $response = $seed->get_list($this->query_orderby, $this->query_where, $current_offset, $this->query_limit);
        } else {
            $related_field_name = $this->related_field_name;
            $response = $seed->get_related_list($this->child_focus,$related_field_name, $this->query_orderby,
            $this->query_where, $current_offset, $this->query_limit);
        }

        $list = $response['list'];
        $row_count = $response['row_count'];
        $next_offset = $response['next_offset'];
        $previous_offset = $response['previous_offset'];

        if(!empty($response['current_offset'])) {
            $current_offset = $response['current_offset'];
        }

        $list_view_row_count = $row_count;
        $this->processListNavigation($xtemplateSection,$html_varName, $current_offset, $next_offset, $previous_offset, $row_count, null, null, empty($seed->column_fields) ? null : count($seed->column_fields));

        return $list;
    }



    function processUnionBeans($sugarbean, $subpanel_def, $html_var = 'CELL') {

		$last_detailview_record = $this->getSessionVariable("detailview", "record");
		if(!empty($last_detailview_record) && $last_detailview_record != $sugarbean->id){
			$GLOBALS['record_has_changed'] = true;
		}
		$this->setSessionVariable("detailview", "record", $sugarbean->id);

		$current_offset = $this->getOffset($html_var);
		$module = isset($_REQUEST['module']) ? $_REQUEST['module'] : '';
		$response = array();

        // choose sort order
        $sort_order = array();
        $sort_order['default'] = 'asc';

        // explicit request parameter gets priority over all
        $sort_order['request'] = isset($_REQUEST['sort_order']) ? $_REQUEST['sort_order'] : null;

        // see if the session data has a sort order
        if (isset($_SESSION['last_sub' . $this->subpanel_module . '_order']))
        {
            $sort_order['session'] = $_SESSION['last_sub' . $this->subpanel_module . '_order'];

            // We swap the order when the request contains an offset (indicating a column sort issued);
            // otherwise we do not sort.  If we don't make this check, then the subpanel listview will
            // swap ordering each time a new record is entered via quick create forms
            if (isset($_REQUEST[$module . '_' . $html_var . '_offset']))
            {
                $sort_order['session'] = $sort_order['session'] == 'asc' ? 'desc' : 'asc';
            }
        }
        else
        {
            $sort_order['session'] = null;
        }

        // does the metadata have a default sort order?
        $sort_order['subpaneldefs'] = isset($subpanel_def->_instance_properties['sort_order']) ?
            $subpanel_def->_instance_properties['sort_order'] : null;

        $this->sort_order = $this->calculateSortOrder($sort_order);


        if (isset($subpanel_def->_instance_properties['sort_by'])) {
            $this->query_orderby = $subpanel_def->_instance_properties['sort_by'];
        } else {
            $this->query_orderby = 'id';
        }

        $this->getOrderBy($html_var,$this->query_orderby, $this->sort_order);

        $_SESSION['last_sub' .$this->subpanel_module. '_order'] = $this->sort_order;
        $_SESSION['last_sub' .$this->subpanel_module. '_url'] = $this->getBaseURL($html_var);

		// Bug 8139 - Correct Subpanel sorting on 'name', when subpanel sorting default is 'last_name, first_name'
		if (($this->sortby == 'name' || $this->sortby == 'last_name') &&
			str_replace(' ', '', trim($subpanel_def->_instance_properties['sort_by'])) == 'last_name,first_name') {
			$this->sortby = 'last_name '.$this->sort_order.', first_name ';
		}

        if(!empty($this->response)){
            $response =& $this->response;
            echo 'cached';
        }else{
            $response = SugarBean::get_union_related_list($sugarbean,$this->sortby, $this->sort_order, $this->query_where, $current_offset, -1,-1,$this->query_limit,$subpanel_def);
            $this->response =& $response;
        }
        $list = $response['list'];
        $row_count = $response['row_count'];
        $next_offset = $response['next_offset'];
        $previous_offset = $response['previous_offset'];
        if(!empty($response['current_offset']))$current_offset = $response['current_offset'];
        global $list_view_row_count;
        $list_view_row_count = $row_count;
        $this->processListNavigation('dyn_list_view', $html_var, $current_offset, $next_offset, $previous_offset, $row_count, $sugarbean,$subpanel_def);

        return array('list'=>$list, 'parent_data'=>$response['parent_data'], 'query'=>$response['query']);
    }

    function getBaseURL($html_varName) {
        static $cache = array();

        if(!empty($cache[$html_varName]))return $cache[$html_varName];
        $blockVariables = array('mass', 'uid', 'massupdate', 'delete', 'merge', 'selectCount','current_query_by_page');
        if(!empty($this->base_URL)) {
            return $this->base_URL;
        }

            $baseurl = $_SERVER['PHP_SELF'];
            if(empty($baseurl)) {
                $baseurl = 'index.php';
            }

            /*fixes an issue with deletes when doing a search*/
            foreach(array_merge($_GET, $_POST) as $name=>$value) {
                //echo ("$name = $value <br/>");
                if(!empty($value) && $name != 'sort_order' //&& $name != ListView::getSessionVariableName($html_varName,"ORDER_BY")
                        && $name != ListView::getSessionVariableName($html_varName,"offset")
                        /*&& substr_count($name, "ORDER_BY")==0*/ && !in_array($name, $blockVariables))
                {
                    if(is_array($value)) {
                        foreach($value as $valuename=>$valuevalue) {
                            if(substr_count($baseurl, '?') > 0)
                                $baseurl	.= "&{$name}[]=".$valuevalue;
                            else
                                $baseurl	.= "?{$name}[]=".$valuevalue;
                        }
                    } else {
                        $value = urlencode($value);
                        if(substr_count($baseurl, '?') > 0) {
                            $baseurl	.= "&$name=$value";
                        } else {
                            $baseurl	.= "?$name=$value";
                        }
                    }
                }
            }


            if($_SERVER['REQUEST_METHOD'] == 'POST') {
                // at this point it is possible that the above foreach already executed resulting in double ?'s in the url
                if(substr_count($baseurl, '?') == 0) {
                    $baseurl .= '?';
                }
                if(isset($_REQUEST['action'])) $baseurl.= '&action='.$_REQUEST['action'];
                if(isset($_REQUEST['record'])) $baseurl .= '&record='.$_REQUEST['record'];
                if(isset($_REQUEST['module'])) $baseurl .= '&module='.$_REQUEST['module'];
            }

            $baseurl .= "&".ListView::getSessionVariableName($html_varName,"offset")."=";
            $cache[$html_varName] = $baseurl;
            return $baseurl;
    }
    /**
    * @return void
    * @param unknown $data
    * @param unknown $xTemplateSection
    * @param unknown $html_varName
    * @desc INTERNAL FUNCTION process the List Navigation
    * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc.
    * All Rights Reserved.
    * Contributor(s): ______________________________________..
    */
    function processListNavigation($xtemplateSection, $html_varName, $current_offset, $next_offset, $previous_offset, $row_count, $sugarbean=null, $subpanel_def=null, $col_count = 20) {

        global $export_module;
        global $sugar_config;
        global $current_user;
        global $currentModule;
        global $app_strings;

        $start_record = $current_offset + 1;

        if(!is_numeric($col_count))
            $col_count = 20;

        if($row_count == 0)
            $start_record = 0;

        $end_record = $start_record + $this->records_per_page;
        // back up the the last page.
        if($end_record > $row_count+1) {
            $end_record = $row_count+1;
        }
        // Determine the start location of the last page
        if($row_count == 0)
            $number_pages = 0;
        else
            $number_pages = floor(($row_count - 1) / $this->records_per_page);

        $last_offset = $number_pages * $this->records_per_page;

        if(empty($this->query_limit)  || $this->query_limit > $this->records_per_page) {
            $this->base_URL = $this->getBaseURL($html_varName);
            $dynamic_url = '';

            if($this->is_dynamic) {
                $dynamic_url .='&'. $this->getSessionVariableName($html_varName,'ORDER_BY') . '='. $this->getSessionVariable($html_varName,'ORDER_BY').'&sort_order='.$this->sort_order.'&to_pdf=true&action=SubPanelViewer&subpanel=' . $this->subpanel_module;
            }

            $current_URL = htmlentities($this->base_URL.$current_offset.$dynamic_url);
            $start_URL = htmlentities($this->base_URL."0".$dynamic_url);
            $previous_URL  = htmlentities($this->base_URL.$previous_offset.$dynamic_url);
            $next_URL  = htmlentities($this->base_URL.$next_offset.$dynamic_url);
            $end_URL  = htmlentities($this->base_URL.'end'.$dynamic_url);

            if(!empty($this->start_link_wrapper)) {
                $current_URL = $this->start_link_wrapper.$current_URL.$this->end_link_wrapper;
                $start_URL = $this->start_link_wrapper.$start_URL.$this->end_link_wrapper;
                $previous_URL = $this->start_link_wrapper.$previous_URL.$this->end_link_wrapper;
                $next_URL = $this->start_link_wrapper.$next_URL.$this->end_link_wrapper;
                $end_URL = $this->start_link_wrapper.$end_URL.$this->end_link_wrapper;
            }

            $moduleString = "{$currentModule}_{$html_varName}_offset";
            $moduleStringOrder = "{$currentModule}_{$html_varName}_ORDER_BY";
            if($this->shouldProcess && !$this->multi_select_popup) {
                // check the checkboxes onload
                echo "<script>YAHOO.util.Event.addListener(window, \"load\", sListView.check_boxes);</script>\n";

                $massUpdateRun = isset($_REQUEST['massupdate']) && $_REQUEST['massupdate'] == 'true';
                $uids = empty($_REQUEST['uid']) || $massUpdateRun ? '' : $_REQUEST['uid'];
                $select_entire_list = ($massUpdateRun) ? 0 : (isset($_POST['select_entire_list']) ? $_POST['select_entire_list'] : (isset($_REQUEST['select_entire_list']) ? $_REQUEST['select_entire_list'] : 0));

                echo "<textarea style='display: none' name='uid'>{$uids}</textarea>\n" .
                    "<input type='hidden' name='select_entire_list' value='{$select_entire_list}'>\n".
                    "<input type='hidden' name='{$moduleString}' value='0'>\n".
                    "<input type='hidden' name='{$moduleStringOrder}' value='0'>\n";

            }


            $GLOBALS['log']->debug("Offsets: (start, previous, next, last)(0, $previous_offset, $next_offset, $last_offset)");

            if(0 == $current_offset) {
                $start_link = "<button type='button' name='listViewStartButton' title='{$this->local_app_strings['LNK_LIST_START']}' class='button' disabled>".SugarThemeRegistry::current()->getImage("start_off","aborder='0' align='absmiddle'",null,null,'.gif',$this->local_app_strings['LNK_LIST_START'])."</button>";
                $previous_link = "<button type='button' name='listViewPrevButton' title='{$this->local_app_strings['LNK_LIST_PREVIOUS']}' class='button' disabled>".SugarThemeRegistry::current()->getImage("previous_off","border='0' align='absmiddle'",null,null,'.gif',$this->local_app_strings['LNK_LIST_PREVIOUS'])."</button>";
            } else {
                if($this->multi_select_popup) {// nav links for multiselect popup, submit form to save checks.
                    $start_link = "<button type='button' class='button' name='listViewStartButton' title='{$this->local_app_strings['LNK_LIST_START']}' onClick='javascript:save_checks(0, \"{$moduleString}\");'>".SugarThemeRegistry::current()->getImage("start","border='0' align='absmiddle'",null,null,'.gif',$this->local_app_strings['LNK_LIST_START'])."</button>";
                    $previous_link = "<button type='button' class='button' name='listViewPrevButton' title='{$this->local_app_strings['LNK_LIST_PREVIOUS']}' onClick='javascript:save_checks($previous_offset, \"{$moduleString}\");'>".SugarThemeRegistry::current()->getImage("previous","border='0' align='absmiddle'",null,null,'.gif',$this->local_app_strings['LNK_LIST_PREVIOUS'])."</button>";
                } elseif($this->shouldProcess) {
                    $start_link = "<button type='button' class='button' name='listViewStartButton' title='{$this->local_app_strings['LNK_LIST_START']}' onClick='location.href=\"$start_URL\"; sListView.save_checks(0, \"{$moduleString}\");'>".SugarThemeRegistry::current()->getImage("start","border='0' align='absmiddle'",null,null,'.gif',$this->local_app_strings['LNK_LIST_START'])."</button>";
                    $previous_link = "<button type='button' class='button' name='listViewPrevButton' title='{$this->local_app_strings['LNK_LIST_PREVIOUS']}' onClick='location.href=\"$previous_URL\"; sListView.save_checks($previous_offset, \"{$moduleString}\");'>".SugarThemeRegistry::current()->getImage("previous","border='0' align='absmiddle'",null,null,'.gif',$this->local_app_strings['LNK_LIST_PREVIOUS'])."</button>";
                } else {
                    $onClick = '';
                    if(0 != preg_match('/javascript.*/', $start_URL)){
                        $onClick = "\"$start_URL;\"";
                    }else{
                        $onClick ="'location.href=\"$start_URL\";'";
                    }
                    $start_link = "<button type='button' class='button' name='listViewStartButton' title='{$this->local_app_strings['LNK_LIST_START']}' onClick=".$onClick.">".SugarThemeRegistry::current()->getImage("start","border='0' align='absmiddle'",null,null,'.gif',$this->local_app_strings['LNK_LIST_START'])."</button>";

                    $onClick = '';
                    if(0 != preg_match('/javascript.*/', $previous_URL)){
                        $onClick = "\"$previous_URL;\"";
                    }else{
                        $onClick = "'location.href=\"$previous_URL\";'";
                    }
                    $previous_link = "<button type='button' class='button' name='listViewPrevButton' title='{$this->local_app_strings['LNK_LIST_PREVIOUS']}' onClick=".$onClick.">".SugarThemeRegistry::current()->getImage("previous","border='0' align='absmiddle'",null,null,'.gif',$this->local_app_strings['LNK_LIST_PREVIOUS'])."</button>";
                }
            }

            if($last_offset <= $current_offset) {
                $end_link = "<button type='button' name='listViewEndButton' title='{$this->local_app_strings['LNK_LIST_END']}' class='button' disabled>".SugarThemeRegistry::current()->getImage("end_off","border='0' align='absmiddle'",null,null,'.gif',$this->local_app_strings['LNK_LIST_END'])."</button>";
                $next_link = "<button type='button' name='listViewNextButton' title='{$this->local_app_strings['LNK_LIST_NEXT']}' class='button' disabled>".SugarThemeRegistry::current()->getImage("next_off","aborder='0' align='absmiddle'",null,null,'.gif',$this->local_app_strings['LNK_LIST_NEXT'])."</button>";
            } else {
                if($this->multi_select_popup) { // nav links for multiselect popup, submit form to save checks.
                    $end_link = "<button type='button' name='listViewEndButton' class='button' title='{$this->local_app_strings['LNK_LIST_END']}' onClick='javascript:save_checks($last_offset, \"{$moduleString}\");'>".SugarThemeRegistry::current()->getImage("end","border='0' align='absmiddle'",null,null,'.gif',$this->local_app_strings['LNK_LIST_END'])."</button>";
                    if(!empty($sugar_config['disable_count_query'])) {
                        $end_link = '';
                    }
                    $next_link = "<button type='button' name='listViewNextButton' title='{$this->local_app_strings['LNK_LIST_NEXT']}' class='button' onClick='javascript:save_checks($next_offset, \"{$moduleString}\");'>".SugarThemeRegistry::current()->getImage("next","border='0' align='absmiddle'",null,null,'.gif',$this->local_app_strings['LNK_LIST_NEXT'])."</button>";
                } elseif($this->shouldProcess) {
                    $end_link = "<button type='button' name='listViewEndButton' class='button' title='{$this->local_app_strings['LNK_LIST_END']}' onClick='location.href=\"$end_URL\"; sListView.save_checks(\"end\", \"{$moduleString}\");'>".SugarThemeRegistry::current()->getImage("end","border='0' align='absmiddle'",null,null,'.gif',$this->local_app_strings['LNK_LIST_END'])."</button>";
                    $next_link = "<button type='button' name='listViewNextButton' class='button' title='{$this->local_app_strings['LNK_LIST_NEXT']}' onClick='location.href=\"$next_URL\"; sListView.save_checks($next_offset, \"{$moduleString}\");'>".SugarThemeRegistry::current()->getImage("next","border='0' align='absmiddle'",null,null,'.gif',$this->local_app_strings['LNK_LIST_NEXT'])."</button>";
                } else {
                    $onClick = '';
                    if(0 != preg_match('/javascript.*/', $next_URL)){
                        $onClick = "\"$next_URL;\"";
                    }else{
                        $onClick ="'location.href=\"$next_URL\";'";
                    }
                    $next_link = "<button type='button' name='listViewNextButton' class='button' title='{$this->local_app_strings['LNK_LIST_NEXT']}' onClick=".$onClick.">".SugarThemeRegistry::current()->getImage("next","border='0' align='absmiddle'",null,null,'.gif',$this->local_app_strings['LNK_LIST_NEXT'])."</button>";

                    $onClick = '';
                    if(0 != preg_match('/javascript.*/', $end_URL)){
                        $onClick = "\"$end_URL;\"";
                    }else{
                        $onClick = "'location.href=\"$end_URL\";'";
                    }
                    $end_link = "<button type='button' name='listViewEndButton' class='button' title='{$this->local_app_strings['LNK_LIST_END']}' onClick=".$onClick.">".SugarThemeRegistry::current()->getImage("end","border='0' align='absmiddle'",null,null,'.gif',$this->local_app_strings['LNK_LIST_END'])."</button>";

                }
            }

            $GLOBALS['log']->info("Offset (next, current, prev)($next_offset, $current_offset, $previous_offset)");
            $GLOBALS['log']->info("Start/end records ($start_record, $end_record)");

            $end_record = $end_record-1;

$script_href = "<a style=\'width: 150px\' name=\"thispage\" class=\'menuItem\' onmouseover=\'hiliteItem(this,\"yes\");\' onmouseout=\'unhiliteItem(this);\' onclick=\'if (document.MassUpdate.select_entire_list.value==1){document.MassUpdate.select_entire_list.value=0;sListView.check_all(document.MassUpdate, \"mass[]\", true, $this->records_per_page)}else {sListView.check_all(document.MassUpdate, \"mass[]\", true)};\' href=\'#\'>{$this->local_app_strings['LBL_LISTVIEW_OPTION_CURRENT']}&nbsp;&#x28;{$this->records_per_page}&#x29;&#x200E;</a>"
 . "<a style=\'width: 150px\' name=\"selectall\" class=\'menuItem\' onmouseover=\'hiliteItem(this,\"yes\");\' onmouseout=\'unhiliteItem(this);\' onclick=\'sListView.check_entire_list(document.MassUpdate, \"mass[]\",true,{$row_count});\' href=\'#\'>{$this->local_app_strings['LBL_LISTVIEW_OPTION_ENTIRE']}&nbsp;&#x28;{$row_count}&#x29;&#x200E;</a>"
 . "<a style=\'width: 150px\' name=\"deselect\" class=\'menuItem\' onmouseover=\'hiliteItem(this,\"yes\");\' onmouseout=\'unhiliteItem(this);\' onclick=\'sListView.clear_all(document.MassUpdate, \"mass[]\", false);\' href=\'#\'>{$this->local_app_strings['LBL_LISTVIEW_NONE']}</a>";

$close_inline_img = SugarThemeRegistry::current()->getImage('close_inline', 'border=0', null, null, ".gif", $app_strings['LBL_CLOSEINLINE']);

            echo "<script>
                function select_dialog() {
                	var \$dialog = \$('<div></div>')
					.html('<a style=\'width: 150px\' name=\"thispage\" class=\'menuItem\' onmouseover=\'hiliteItem(this,\"yes\");\' onmouseout=\'unhiliteItem(this);\' onclick=\'if (document.MassUpdate.select_entire_list.value==1){document.MassUpdate.select_entire_list.value=0;sListView.check_all(document.MassUpdate, \"mass[]\", true, $this->records_per_page)}else {sListView.check_all(document.MassUpdate, \"mass[]\", true)};\' href=\'javascript:void(0)\'>{$this->local_app_strings['LBL_LISTVIEW_OPTION_CURRENT']}&nbsp;&#x28;{$this->records_per_page}&#x29;&#x200E;</a>"
                . "<a style=\'width: 150px\' name=\"selectall\" class=\'menuItem\' onmouseover=\'hiliteItem(this,\"yes\");\' onmouseout=\'unhiliteItem(this);\' onclick=\'sListView.check_entire_list(document.MassUpdate, \"mass[]\",true,{$row_count});\' href=\'javascript:void(0)\'>{$this->local_app_strings['LBL_LISTVIEW_OPTION_ENTIRE']}&nbsp;&#x28;{$row_count}&#x29;&#x200E;</a>"
                . "<a style=\'width: 150px\' name=\"deselect\" class=\'menuItem\' onmouseover=\'hiliteItem(this,\"yes\");\' onmouseout=\'unhiliteItem(this);\' onclick=\'sListView.clear_all(document.MassUpdate, \"mass[]\", false);\' href=\'javascript:void(0)\'>{$this->local_app_strings['LBL_LISTVIEW_NONE']}</a>')
					.dialog({
						autoOpen: false,
						width: 150
					});
					\$dialog.dialog('open');

                }
                </script>";

            if($this->show_select_menu)
            {
                $total_label = "";
                $total = $row_count;
                $pageTotal = ($row_count > 0) ? $end_record - $start_record + 1 : 0;
                if (!empty($GLOBALS['sugar_config']['disable_count_query']) && $GLOBALS['sugar_config']['disable_count_query'] === true && $total > $pageTotal) {
                    $this->show_plus = true;
                    $total =  $pageTotal;
                    $total_label = $total.'+';
                } else {
                    $this->show_plus = false;
                    $total_label = $total;
                }
                echo "<input type='hidden' name='show_plus' value='{$this->show_plus}'>\n";

                //Bug#52931: Replace with actionMenu
                //$select_link = "<a id='select_link' onclick='return select_dialog();' href=\"javascript:void(0)\">".$this->local_app_strings['LBL_LINK_SELECT']."&nbsp;".SugarThemeRegistry::current()->getImage('MoreDetail', 'border=0', 11, 7, '.png', $app_strings['LBL_MOREDETAIL'])."</a>";
                $menuItems = array(
                    "<input title=\"".$app_strings['LBL_SELECT_ALL_TITLE']."\" type='checkbox' class='checkbox massall' name='massall' id='massall' value='' onclick='sListView.check_all(document.MassUpdate, \"mass[]\", this.checked);' /><a href='javascript: void(0);'></a>",
                    "<a  name='thispage' id='button_select_this_page' class='menuItem' onmouseover='hiliteItem(this,\"yes\");' onmouseout='unhiliteItem(this);' onclick='if (document.MassUpdate.select_entire_list.value==1){document.MassUpdate.select_entire_list.value=0;sListView.check_all(document.MassUpdate, \"mass[]\", true, $pageTotal)}else {sListView.check_all(document.MassUpdate, \"mass[]\", true)};' href='#'>{$app_strings['LBL_LISTVIEW_OPTION_CURRENT']}&nbsp;&#x28;{$pageTotal}&#x29;&#x200E;</a>",
                    "<a  name='selectall' id='button_select_all' class='menuItem' onmouseover='hiliteItem(this,\"yes\");' onmouseout='unhiliteItem(this);' onclick='sListView.check_entire_list(document.MassUpdate, \"mass[]\",true,{$total});' href='#'>{$app_strings['LBL_LISTVIEW_OPTION_ENTIRE']}&nbsp;&#x28;{$total_label}&#x29;&#x200E;</a>",
                    "<a name='deselect' id='button_deselect' class='menuItem' onmouseover='hiliteItem(this,\"yes\");' onmouseout='unhiliteItem(this);' onclick='sListView.clear_all(document.MassUpdate, \"mass[]\", false);' href='#'>{$app_strings['LBL_LISTVIEW_NONE']}</a>",
                );
                require_once('include/Smarty/plugins/function.sugar_action_menu.php');
                $select_link = smarty_function_sugar_action_menu(array(
                    'class' => 'clickMenu selectmenu',
                    'id' => 'selectLink',
                    'buttons' => $menuItems,
                    'flat' => false,
                ),$this->xTemplate);

            } else {
                $select_link = "&nbsp;";
            }

            $export_link = '<input class="button" type="button" value="'.$this->local_app_strings['LBL_EXPORT'].'" ' .
                    'onclick="return sListView.send_form(true, \''.$_REQUEST['module'].'\', \'index.php?entryPoint=export\',\''.$this->local_app_strings['LBL_LISTVIEW_NO_SELECTED'].'\')">';

            if($this->show_delete_button) {
                $delete_link = '<input class="button" type="button" id="delete_button" name="Delete" value="'.$this->local_app_strings['LBL_DELETE_BUTTON_LABEL'].'" onclick="return sListView.send_mass_update(\'selected\',\''.$this->local_app_strings['LBL_LISTVIEW_NO_SELECTED'].'\', 1)">';
            } else {
                $delete_link = '&nbsp;';
            }

            $admin = new Administration();
            $admin->retrieveSettings('system');

            $user_merge = $current_user->getPreference('mailmerge_on');
            if($user_merge == 'on' && isset($admin->settings['system_mailmerge_on']) && $admin->settings['system_mailmerge_on']) {
                echo "<script>
                function mailmerge_dialog(el) {
                   	var \$dialog = \$('<div></div>')
					.html('<a style=\'width: 150px\' class=\'menuItem\' onmouseover=\'hiliteItem(this,\"yes\");\' onmouseout=\'unhiliteItem(this);\' onclick=\'return sListView.send_form(true, \"MailMerge\", \"index.php\", \"{$this->local_app_strings['LBL_LISTVIEW_NO_SELECTED']}\")\' href=\'javascript:void(0)\'>{$this->local_app_strings['LBL_LISTVIEW_OPTION_SELECTED']}</a>"
                        . "<a style=\'width: 150px\' class=\'menuItem\' onmouseover=\'hiliteItem(this,\"yes\");\' onmouseout=\'unhiliteItem(this);\' href=\'index.php?action=index&module=MailMerge\'>{$this->local_app_strings['LBL_LISTVIEW_OPTION_CURRENT']}</a>"
                        . "<a style=\'width: 150px\' class=\'menuItem\' onmouseover=\'hiliteItem(this,\"yes\");\' onmouseout=\'unhiliteItem(this);\' href=\'index.php?action=index&module=MailMerge&entire=true\'>{$this->local_app_strings['LBL_LISTVIEW_OPTION_ENTIRE']}</a>')
					.dialog({
						autoOpen: false,
						title: '". $this->local_app_strings['LBL_MAILMERGE']."',
						width: 150,
						position: {
						    my: myPos,
						    at: atPos,
						    of: \$(el)
					 	}
					});

                }
            </script>";
                $merge_link = "&nbsp;|&nbsp;<a id='mailmerge_link' onclick='return mailmerge_dialog(this)'; href=\"javascript:void(0)\">".$this->local_app_strings['LBL_MAILMERGE']."</a>";
            } else {
                $merge_link = "&nbsp;";
            }

            $selected_objects_span = "&nbsp;|&nbsp;{$this->local_app_strings['LBL_LISTVIEW_SELECTED_OBJECTS']}<input  style='border: 0px; background: transparent; font-size: inherit; color: inherit' type='text' readonly name='selectCount[]' value='" . ((isset($_POST['mass'])) ? count($_POST['mass']): 0) . "' />";

            if($_REQUEST['module'] == 'Home' || $this->local_current_module == 'Import'
                || $this->show_export_button == false
                || (!empty($sugar_config['disable_export']))
                || (!empty($sugar_config['admin_export_only'])
                && !(
                        is_admin($current_user)
                        || (ACLController::moduleSupportsACL($_REQUEST['module'])
                            && ACLAction::getUserAccessLevel($current_user->id,$_REQUEST['module'], 'access') == ACL_ALLOW_ENABLED
                            && (ACLAction::getUserAccessLevel($current_user->id, $_REQUEST['module'], 'admin') == ACL_ALLOW_ADMIN ||
                                ACLAction::getUserAccessLevel($current_user->id, $_REQUEST['module'], 'admin') == ACL_ALLOW_ADMIN_DEV)))))
            {
                if ($_REQUEST['module'] != 'InboundEmail' && $_REQUEST['module'] != 'EmailMan' && $_REQUEST['module'] != 'iFrames') {
                    $selected_objects_span = '';
                }
                $export_link = "&nbsp;";
                $merge_link = "&nbsp;";
            } elseif($_REQUEST['module'] != "Accounts" && $_REQUEST['module'] != "Cases" && $_REQUEST['module'] != "Contacts" && $_REQUEST['module'] != "Leads" && $_REQUEST['module'] != "Opportunities") {
                $merge_link = "&nbsp;";
            }

            if($this->show_paging == true) {
                if(!empty($sugar_config['disable_count_query'])) {
                    if($row_count > $end_record) {
                        $row_count .= '+';
                    }
                }

                $html_text = '';
                $html_text .= "<tr class='pagination' role='presentation'>\n";
                $html_text .= "<td COLSPAN=\"$col_count\" align=\"right\">\n";
                //$html_text .= "<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\"><tr><td align=\"left\"  >$export_link$merge_link$selected_objects_span</td>\n";
                //$html_text .= "<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\"><tr><td align=\"left\"  >";
                if ($subpanel_def != null) {
                    include_once('include/SubPanel/SubPanelTiles.php');
                    $subpanelTiles = new SubPanelTiles($sugarbean);
                    $html_text .= "<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\"><tr><td align=\"left\"  >";

                    //attempt to get the query to recreate this subpanel
                    if(!empty($this->response)){
                        $response =& $this->response;
                    }else{
                        $response = SugarBean::get_union_related_list($sugarbean,$this->sortby, $this->sort_order, $this->query_where, $current_offset, -1,-1,$this->query_limit,$subpanel_def);
                        $this->response = $response;
                    }
                    //if query is present, then pass it in as parameter
                    if (isset($response['query']) && !empty($response['query'])){
                        $html_text .= $subpanelTiles->get_buttons($subpanel_def, $response['query']);
                    }else{
                        $html_text .= $subpanelTiles->get_buttons($subpanel_def);
                    }
                }
                else {
                    $html_text .= "<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\"><tr><td align=\"left\"  nowrap>$select_link&nbsp;$export_link&nbsp;$delete_link&nbsp;$selected_objects_span";
                }
                $html_text .= "</td>\n<td nowrap align=\"right\">".$start_link."&nbsp;&nbsp;".$previous_link."&nbsp;&nbsp;<span class='pageNumbers'>(".$start_record." - ".$end_record." ".$this->local_app_strings['LBL_LIST_OF']." ".$row_count.")</span>&nbsp;&nbsp;".$next_link."&nbsp;&nbsp;".$end_link."</td></tr></table>\n";
                $html_text .= "</td>\n";
                $html_text .= "</tr>\n";
                $this->xTemplate->assign("PAGINATION",$html_text);
            }

            //C.L. - Fix for 23461
            if(empty($_REQUEST['action']) || $_REQUEST['action'] != 'Popup') {
                $_SESSION['export_where'] = $this->query_where;
            }
            $this->xTemplate->parse($xtemplateSection.".list_nav_row");
        }
    } // end processListNavigation

    function processOrderBy($html_varName) {

        if(!isset($this->base_URL)) {
            $this->base_URL = $_SERVER['PHP_SELF'];

            if(isset($_SERVER['QUERY_STRING'])) {
                $this->base_URL = preg_replace("/\&".$this->getSessionVariableName($html_varName,"ORDER_BY")."=[0-9a-zA-Z\_\.]*/","",$this->base_URL .'?'.$_SERVER['QUERY_STRING']);
                $this->base_URL = preg_replace("/\&".$this->getSessionVariableName($html_varName,"offset")."=[0-9]*/","",$this->base_URL);
            }
            if($_SERVER['REQUEST_METHOD'] == 'POST') {
                $this->base_URL .= '?';
                if(isset($_REQUEST['action'])) $this->base_URL .= '&action='.$_REQUEST['action'];
                if(isset($_REQUEST['record'])) $this->base_URL .= '&record='.$_REQUEST['record'];
                if(isset($_REQUEST['module'])) $this->base_URL .= '&module='.$_REQUEST['module'];
            }
            $this->base_URL .= "&".$this->getSessionVariableName($html_varName,"offset")."=";
        }

        if($this->is_dynamic) {
            $this->base_URL.='&to_pdf=true&action=SubPanelViewer&subpanel=' . $this->source_module;
        }

        //bug43465 start
        if (isset($this->appendToBaseUrl) && is_array($this->appendToBaseUrl))
        {
            foreach ($this->appendToBaseUrl as $key => $value)
            {
                $fullRequestString = $key . '=' . $value;

                if ($this->base_URL == "/index.php")
                {
                    $this->base_URL .= "?";
                } else
                {
                    if ($fullRequestString == substr($this->baseURL, '-' . strlen($fullRequestString)))
                    {
                        $this->base_URL = preg_replace("/&" . $key . "\=.*/", "", $this->base_URL);
                    } else
                    {
                        $this->base_URL = preg_replace("/&" . $key . "\=.*?&/", "&", $this->base_URL);
                    }
                    $this->base_URL .= "&";
                }
                if (!empty($value))
                {
                    $this->base_URL .= "{$key}={$value}";
                }
            }
        }
        //bug43465 end

        $sort_URL_base = $this->base_URL. "&".$this->getSessionVariableName($html_varName,"ORDER_BY")."=";

        if($sort_URL_base !== "")
        {
            $this->xTemplate->assign("ORDER_BY", $sort_URL_base);
            return $sort_URL_base;
        } else {
            return '';
        }
    }


    function getAdditionalHeader() {

    }


    /**
    * @return void
    * @param unknown $data
    * @param unknown $xTemplateSection
    * @param unknown $html_varName
    * @desc INTERNAL FUNCTION handles the rows
    * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc.
    * All Rights Reserved.
    * Contributor(s): ______________________________________..
    */
    function processListRows($data, $xtemplateSection, $html_varName)
    {
        global $odd_bg;
        global $even_bg;
        global $hilite_bg;
        global $app_strings, $sugar_version, $sugar_config;
        global $currentModule;

        $this->xTemplate->assign('BG_HILITE', $hilite_bg);
        $this->xTemplate->assign('CHECKALL', SugarThemeRegistry::current()->getImage('blank', '', 1, 1, ".gif", ''));
    //$this->xTemplate->assign("BG_CLICK", $click_bg);
        $oddRow = true;
        $count = 0;
        reset($data);

        //GETTING OFFSET
        $offset = $this->getOffset($html_varName);
        $timeStamp = $this->unique_id();
        $_SESSION[$html_varName."_FROM_LIST_VIEW"] = $timeStamp;

        $associated_row_data = array();

        //mail merge list
        $mergeList = array();
        $module = '';
        //todo what is this?  It is using an array as a boolean
        while(list($aVal, $aItem) = each($data))
        {
            if(isset($this->data_array)) {
                $fields = $this->data_array;
            } else {
                $aItem->check_date_relationships_load();
                $fields = $aItem->get_list_view_data();
            }

            if(is_object($aItem)) { // cn: bug 5349
                //add item id to merge list, if the button is clicked
                $mergeList[] = $aItem->id;
                if(empty($module)) {
                    $module = $aItem->module_dir;
                }
            }
            //ADD OFFSET TO ARRAY

                $fields['OFFSET'] = ($offset + $count + 1);

            $fields['STAMP'] = $timeStamp;
            if($this->shouldProcess) {

            $prerow = '';
            if(!isset($this->data_array)) {
                $prerow .= "<input onclick='sListView.check_item(this, document.MassUpdate)' type='checkbox' class='checkbox' name='mass[]' value='". $fields['ID']. "'>";
            }
            $this->xTemplate->assign('PREROW', $prerow);

            $this->xTemplate->assign('CHECKALL', "<input type='checkbox' class='checkbox'  title='".$GLOBALS['app_strings']['LBL_SELECT_ALL_TITLE']."'  name='massall' id='massall' value='' onclick='sListView.check_all(document.MassUpdate, \"mass[]\", this.checked)'>");
            }
            if(!isset($this->data_array)) {
                $tag = $aItem->listviewACLHelper();
                $this->xTemplate->assign('TAG',$tag) ;
            }

            if($oddRow)
            {
                $ROW_COLOR = 'oddListRow';
                $BG_COLOR =  $odd_bg;
            }
            else
            {
                $ROW_COLOR = 'evenListRow';
                $BG_COLOR =  $even_bg;
            }
            $oddRow = !$oddRow;

            $this->xTemplate->assign('ROW_COLOR', $ROW_COLOR);
            $this->xTemplate->assign('BG_COLOR', $BG_COLOR);

            if(isset($this->data_array))
            {
                $this->xTemplate->assign('KEY', $aVal);
                $this->xTemplate->assign('VALUE', $aItem);
                $this->xTemplate->assign('INDEX', $count);

            }
            else
            {
    //AED -- some modules do not have their additionalDetails.php established. Add a check to ensure require_once does not fail
    // Bug #2786
                if($this->_additionalDetails && $aItem->ACLAccess('DetailView') && (file_exists('modules/' . $aItem->module_dir . '/metadata/additionalDetails.php') || file_exists('custom/modules/' . $aItem->module_dir . '/metadata/additionalDetails.php'))) {

                    $additionalDetailsFile = 'modules/' . $aItem->module_dir . '/metadata/additionalDetails.php';
                    if(file_exists('custom/modules/' . $aItem->module_dir . '/metadata/additionalDetails.php')){
                        $additionalDetailsFile = 'custom/modules/' . $aItem->module_dir . '/metadata/additionalDetails.php';
                    }

                    require_once($additionalDetailsFile);
                    $ad_function = (empty($this->additionalDetailsFunction) ? 'additionalDetails' : $this->additionalDetailsFunction) . $aItem->object_name;
                    $results = $ad_function($fields);
                    $results['string'] = str_replace(array("&#039", "'"), '\&#039', $results['string']); // no xss!

                    if(trim($results['string']) == '') $results['string'] = $app_strings['LBL_NONE'];
                    $fields[$results['fieldToAddTo']] = $fields[$results['fieldToAddTo']].'</a>';
                }

                if($aItem->ACLAccess('Delete')) {
                    $delete = '<a class="listViewTdToolsS1" onclick="return confirm(\''.$this->local_app_strings['NTC_DELETE_CONFIRMATION'].'\')" href="'.'index.php?action=Delete&module='.$aItem->module_dir.'&record='.$fields['ID'].'&return_module='.$aItem->module_dir.'&return_action=index&return_id=">'.$this->local_app_strings['LBL_DELETE_INLINE'].'</a>';
                    require_once('include/Smarty/plugins/function.sugar_action_menu.php');
                    $fields['DELETE_BUTTON'] = smarty_function_sugar_action_menu(array(
                        'id' => $aItem->module_dir.'_'.$fields['ID'].'_create_button',
                        'buttons' => array($delete),
                    ), $this);

                }

                $this->xTemplate->assign($html_varName, $fields);
                $aItem->setupCustomFields($aItem->module_dir);
                $aItem->custom_fields->populateAllXTPL($this->xTemplate, 'detail', $html_varName, $fields);
            }
            if(!isset($this->data_array) && $aItem->ACLAccess('DetailView')) {
                $count++;
            }
            if(isset($this->data_array)) {
                $count++;
            }
            if(!isset($this->data_array)) {
                $aItem->list_view_parse_additional_sections($this->xTemplate, $xtemplateSection);

                if($this->xTemplate->exists($xtemplateSection.'.row.pro')) {
                    $this->xTemplate->parse($xtemplateSection.'.row.pro');
                }
            }
            $this->xTemplate->parse($xtemplateSection . '.row');

            if(isset($fields['ID'])) {
                $associated_row_data[$fields['ID']] = $fields;
                // Bug 38908: cleanup data for JS to avoid having &nbsp; shuffled around
                foreach($fields as $key => $value) {
                    if($value == '&nbsp;') {
                        $associated_row_data[$fields['ID']][$key] = '';
                    }
                }
            }
        }

        $_SESSION['MAILMERGE_RECORDS'] = $mergeList;
        $_SESSION['MAILMERGE_MODULE_FROM_LISTVIEW'] = $module;
        if(empty($_REQUEST['action']) || $_REQUEST['action'] != 'Popup') {
            $_SESSION['MAILMERGE_MODULE'] = $module;
        }

        if($this->process_for_popups)
        {
            $json = getJSONobj();
            $is_show_fullname = showFullName() ? 1 : 0;
            $associated_javascript_data = '<script type="text/javascript">' . "\n"
                //. '<!-- // associated javascript data generated by ListView' . "\n"
                . 'var associated_javascript_data = '
                . $json->encode($associated_row_data) . ";\n"
                //. '-->' . "\n"
                . 'var is_show_fullname = '
                . $is_show_fullname . ";\n"
                . '</script>';
            $this->xTemplate->assign('ASSOCIATED_JAVASCRIPT_DATA', $associated_javascript_data);
        }

        $this->xTemplate->parse($xtemplateSection);
    }


    function getLayoutManager()
    {
        require_once('include/generic/LayoutManager.php');
        if($this->layout_manager == null)
        {
            $this->layout_manager = new LayoutManager();
        }
        return $this->layout_manager;
    }


    function process_dynamic_listview_header($source_module, $subpanel_def, $html_var = 'CELL')
    {


        $layout_manager = $this->getLayoutManager();
        $layout_manager->setAttribute('order_by_link',$this->processOrderBy($html_var));
        $layout_manager->setAttribute('context','HeaderCell');
        $layout_manager->setAttribute('image_path',$this->local_image_path);
        $layout_manager->setAttribute('html_varName',$html_var);
        $layout_manager->setAttribute('module_name', $source_module);
        list($orderBy,$desc) = $this->getOrderByInfo($html_var);

        if($orderBy == 'amount*1')
        {
            $orderBy=  'amount';
        }
		$buttons = false;
        foreach($subpanel_def->get_list_fields() as $column_name=>$widget_args)
        {
            $usage = empty($widget_args['usage']) ? '' : $widget_args['usage'];
            if($usage != 'query_only')
            {
                $imgArrow = '';

                if($orderBy == $column_name || (isset($widget_args['sort_by']) && str_replace('.','_',$widget_args['sort_by']) == $orderBy))
                {
                    $imgArrow = "_down";
                    if($this->sort_order == 'asc') {
                        $imgArrow = "_up";
                    }
                }

                if (!preg_match("/_button/i", $column_name)) {
	                $widget_args['name']=$column_name;
	                $widget_args['sort'] = $imgArrow;
	                $widget_args['start_link_wrapper'] = $this->start_link_wrapper;
	                $widget_args['end_link_wrapper'] = $this->end_link_wrapper;
	                $widget_args['subpanel_module'] = $this->subpanel_module;

	                $widget_contents = $layout_manager->widgetDisplay($widget_args);
	                $cell_width = empty($widget_args['width']) ? '' : $widget_args['width'];
	                $this->xTemplate->assign('HEADER_CELL', $widget_contents);
	                static $count;
	            if(!isset($count))$count = 0; else $count++;
	                $this->xTemplate->assign('CELL_COUNT', $count);
	                $this->xTemplate->assign('CELL_WIDTH', $cell_width);
	                $this->xTemplate->parse('dyn_list_view.header_cell');
                } else {
                	$buttons = true;
                }
            }
        }

        if($buttons) {
        			$this->xTemplate->assign('HEADER_CELL', "&nbsp;");
        			$this->xTemplate->assign('CELL_COUNT', $count);
	                $this->xTemplate->assign('CELL_WIDTH', $cell_width);
	                $this->xTemplate->parse('dyn_list_view.header_cell');
        }

    }


    /**
    * @return void
    * @param unknown $seed
    * @param unknown $xTemplateSection
    * @param unknown $html_varName
    * @desc PUBLIC FUNCTION Handles List Views using seeds that extend SugarBean
        $XTemplateSection is the section in the XTemplate file that should be parsed usually main
        $html_VarName is the variable name used in the XTemplateFile e.g. TASK
        $seed is a seed there are two types of seeds one is a subclass of SugarBean, the other is a list usually created from a sugar bean using get_list
        if no XTemplate is set it will create  a new XTemplate
        * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc..
        * All Rights Reserved..
        * Contributor(s): ______________________________________..
    */

    function processListViewTwo($seed, $xTemplateSection, $html_varName) {
        global $current_user;
        if(!isset($this->xTemplate)) {
            $this->createXTemplate();
        }

        $isSugarBean = is_subclass_of($seed, "SugarBean");
        $list = null;

        if($isSugarBean) {
            $list = $this->processSugarBean($xTemplateSection, $html_varName, $seed);
        } else {
            $list = $seed;
        }

        if (is_object($seed) && isset($seed->object_name) && $seed->object_name == 'WorkFlow') {
            $tab=array();
            $access = get_workflow_admin_modules_for_user($current_user);
            for ($i = 0; $i < count($list); $i++) {
                if(!empty($access[$list[$i]->base_module])){
                    $tab[]=$list[$i];
                }
            }
            $list = $tab;
        }

        if($this->is_dynamic) {
            $this->processHeaderDynamic($xTemplateSection,$html_varName);
            $this->processListRows($list,$xTemplateSection, $html_varName);
        } else {
            $this->processSortArrows($html_varName);

            if($isSugarBean) {
                $seed->parse_additional_headers($this->xTemplate, $xTemplateSection);
            }
            $this->xTemplateAssign('CHECKALL', SugarThemeRegistry::current()->getImage('blank', '', 1, 1, ".gif", ''));

            // Process the  order by before processing the pro_nav.  The pro_nav requires the order by values to be set
            $this->processOrderBy($html_varName);


            $this->processListRows($list,$xTemplateSection, $html_varName);
        }

        if($this->display_header_and_footer) {
            $this->getAdditionalHeader();
            if(!empty($this->header_title)) {
                echo get_form_header($this->header_title, $this->header_text, false);
            }
        }

        $this->xTemplate->out($xTemplateSection);

        if(isset($_SESSION['validation'])) {
            print base64_decode('PGEgaHJlZj0naHR0cDovL3d3dy5zdWdhcmNybS5jb20nPlBPV0VSRUQmbmJzcDtCWSZuYnNwO1NVR0FSQ1JNPC9hPg==');
        }
    }

    function getArrowStart() {
        $imgFileParts = pathinfo(SugarThemeRegistry::current()->getImageURL("arrow.gif"));

        return "&nbsp;<!--not_in_theme!--><img border='0' src='".$imgFileParts['dirname']."/".$imgFileParts['filename']."";
    }

    function getArrowUpDownStart($upDown) {
        $ext = ( SugarThemeRegistry::current()->pngSupport ? "png" : "gif" );

        if (!isset($upDown) || empty($upDown)) {
            $upDown = "";
        }
        return "&nbsp;<img border='0' src='".SugarThemeRegistry::current()->getImageURL("arrow{$upDown}.{$ext}")."' ";
    }

	function getArrowEnd() {
		$imgFileParts = pathinfo(SugarThemeRegistry::current()->getImageURL("arrow.gif"));

        list($width,$height) = ListView::getArrowImageSize();

		return '.'.$imgFileParts['extension']."' width='$width' height='$height' align='absmiddle' alt=".translate('LBL_SORT').">";
    }

    function getArrowUpDownEnd($upDown) {
        if (!isset($upDown) || empty($upDown)) {
            $upDown = "";
        }
        $imgFileParts = pathinfo(SugarThemeRegistry::current()->getImageURL("arrow{$upDown}.gif"));

        list($width,$height) = ListView::getArrowUpDownImageSize($upDown);

        //get the right alt tag for the sort
        $sortStr = translate('LBL_ALT_SORT');
        if($upDown == '_down'){
            $sortStr = translate('LBL_ALT_SORT_DESC');
        }elseif($upDown == '_up'){
            $sortStr = translate('LBL_ALT_SORT_ASC');
        }
        return " width='$width' height='$height' align='absmiddle' alt='$sortStr'>";
    }

	function getArrowImageSize() {
	    // jbasicChartDashletsExpColust get the non-sort image's size.. the up and down have be the same.
		$image = SugarThemeRegistry::current()->getImageURL("arrow.gif",false);

        $cache_key = 'arrow_size.'.$image;

        // Check the cache
        $result = sugar_cache_retrieve($cache_key);
        if(!empty($result))
        return $result;

        // No cache hit.  Calculate the value and return.
        $result = getimagesize($image);
        sugar_cache_put($cache_key, $result);
        return $result;
    }

    function getArrowUpDownImageSize($upDown) {
        // just get the non-sort image's size.. the up and down have be the same.
        $image = SugarThemeRegistry::current()->getImageURL("arrow{$upDown}.gif",false);

        $cache_key = 'arrowupdown_size.'.$image;

        // Check the cache
        $result = sugar_cache_retrieve($cache_key);
        if(!empty($result))
        return $result;

        // No cache hit.  Calculate the value and return.
        $result = getimagesize($image);
        sugar_cache_put($cache_key, $result);
        return $result;
    }

	function getOrderByInfo($html_varName)
	{
		$orderBy = $this->getSessionVariable($html_varName, "OBL");
		$desc = $this->getSessionVariable($html_varName, $orderBy.'S');
		$orderBy = str_replace('.', '_', $orderBy);
		return array($orderBy,$desc);
	}

    function processSortArrows($html_varName)
    {

        $this->xTemplateAssign("arrow_start", $this->getArrowStart());

        list($orderBy,$desc) = $this->getOrderByInfo($html_varName);

		$imgArrow = "_up";
		if($desc) {
			$imgArrow = "_down";
		}
		/**
		 * @deprecated only used by legacy opportunites listview, nothing current. Leaving for BC
		 */
		if($orderBy == 'amount')
		{
			$this->xTemplateAssign('amount_arrow', $imgArrow);
		}
		else if($orderBy == 'amount_usdollar')
		{
			$this->xTemplateAssign('amount_usdollar_arrow', $imgArrow);
		}
		else
		{
			$this->xTemplateAssign($orderBy.'_arrow', $imgArrow);
		}

        $this->xTemplateAssign('arrow_end', $this->getArrowEnd());
    }

    // this is where translation happens for dynamic list views
    function loadListFieldDefs(&$subpanel_fields,&$child_focus)
    {
        $this->list_field_defs = $subpanel_fields;

        for($i=0;$i < count($this->list_field_defs);$i++)
        {
            $list_field = $this->list_field_defs[$i];
            $field_def = null;
            $key = '';
            if(!empty($list_field['vname']))
            {
                $key = $list_field['vname'];
            } else if(isset($list_field['name']) &&  isset($child_focus->field_defs[$list_field['name']]))
            {
                    $field_def = $child_focus->field_defs[$list_field['name']];
                    $key = $field_def['vname'];
            }
            if(!empty($key))
            {
                $list_field['label'] = translate($key,$child_focus->module_dir);
                $this->list_field_defs[$i]['label'] = preg_replace('/:$/','',$list_field['label']);
            }
            else
            {
                $this->list_field_defs[$i]['label'] ='&nbsp;';
            }
        }
    }

    function unique_id() {
        return sugar_microtime();
    }

     /**INTERNAL FUNCTION sets a session variable keeping it local to the listview
     not the current_module
     * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc.
     * All Rights Reserved.
     * Contributor(s): ______________________________________.
     */
     function setLocalSessionVariable($localVarName,$varName, $value) {
        $_SESSION[$localVarName."_".$varName] = $value;
     }

     /**INTERNAL FUNCTION returns a session variable that is local to the listview,
     not the current_module
     * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc.
     * All Rights Reserved.
     * Contributor(s): ______________________________________.
     */
 function getLocalSessionVariable($localVarName,$varName) {
    if(isset($_SESSION[$localVarName."_".$varName])) {
        return $_SESSION[$localVarName."_".$varName];
    }
    else{
        return "";
    }
 }

 /* Set to true if you want Additional Details to appear in the listview
  */
 function setAdditionalDetails($value = true, $function = '') {
    if(!empty($function)) $this->additionalDetailsFunction = $function;
    $this->_additionalDetails = $value;
 }

}
?>
