Elep

<?php
/*
 * Your installation or use of this SugarCRM file is subject to the applicable
 * terms available at
 * http://support.sugarcrm.com/Resources/Master_Subscription_Agreements/.
 * If you do not agree to all of the applicable terms or do not have the
 * authority to bind the entity as an authorized representative, then do not
 * install or use this SugarCRM file.
 *
 * Copyright (C) SugarCRM Inc. All rights reserved.
 */

use Sugarcrm\Sugarcrm\Security\InputValidation\InputValidation;
use Sugarcrm\Sugarcrm\Security\InputValidation\Request;

require_once 'include/SugarSmarty/plugins/function.sugar_csrf_form_token.php';

/**
 * ListView - list of many objects
 * @api
 */
class ListView
{
    public $source_module;
    /**
     * @var mixed
     */
    public $subpanel_module;
    /**
     * @var mixed
     */
    public $subpanel_id;
    public $appendToBaseUrl;
    /**
     * @var mixed|string
     */
    public $sortby;
    public $local_module_strings;
    /**
     * @var mixed|mixed[]
     */
    public $response;
    /**
     * @var mixed|string|null|string[]
     */
    public $base_URL;
    /**
     * @var bool|mixed
     */
    public $show_plus;
    /**
     * @var Request
     */
    protected $request;

public $local_theme = null;
    public $local_app_strings = null;
    public $local_image_path = null;
    public $local_current_module = null;
    public $local_mod_strings = null;
    public $records_per_page = 20;

/**
     * @var XTemplate
     */
    public $xTemplate = null;
    public $xTemplatePath = null;
    public $seed_data = null;
    public $query_where = null;
    public $query_limit = -1;
    public $query_orderby = null;
    public $header_title = '';
    public $header_text = '';
    public $initialized = false;
    public $show_export_button = true;
    public $show_delete_button = true;
    public $show_select_menu = true;
    public $show_paging = true;
    public $show_mass_update = true;
    public $show_mass_update_form = true;
    public $query_where_has_changed = false;
    public $display_header_and_footer = true;
    public $baseURL = '';
    public $is_dynamic = false;
    public $inline = false;
    public $start_link_wrapper = '';
    public $end_link_wrapper = '';
    public $list_field_defs = [];

public $shouldProcess = false;
    public $data_array;
    public $related_field_name = '';
    public $child_focus = '';
    public $layout_manager = null;
    public $process_for_popups = false;
    public $multi_select_popup = false;
    // @codingStandardsIgnoreLine PSR2.Classes.PropertyDeclaration.Underscore
    public $_additionalDetails = false;
    public $additionalDetailsFunction = null;
    public $sort_order = '';
    public $force_mass_update = false;
    public $keep_mass_update_form_open = false;
    public $ignorePopulateOnly = false;

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

public 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>';
    }

public 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'] = $this->request->getValidInputRequest('module', 'Assert\Mvc\ModuleName');
                return;
            }
        }

if (strcmp(strtolower($_REQUEST['action']), 'popup') != 0) {
            $_SESSION['last_search_mod'] = $this->request->getValidInputRequest('module', 'Assert\Mvc\ModuleName');
        }
        //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);

$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->ACLAccess('list', true)) {
                if ($_REQUEST['module'] != 'Home') {
                    ACLController::displayNoAccess();
                }
                return;
            }
            if (!$seed->ACLAccess('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();
            }
        }
    }

public 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']);
        }
    }

/**
     * @param $linked_field field to get relationsip name from
     * @param $aItem sugar bean to check against
     * @param $parentBean parent bean
     * @return bool
     */
    protected function checkUnlinkPermission($linked_field, $aItem, $parentBean)
    {
        if (!empty($parentBean)) {
            $parentBean->load_relationship($linked_field);

if (isset($parentBean->$linked_field) && isset($parentBean->$linked_field->def['relationship'])) {
                $relObj = $parentBean->$linked_field->getRelationshipObject();

if (!empty($relObj)) {
                    // relationship def
                    $relDef = $relObj->def;

$fieldsToCheck = [];
                    foreach (['rhs_key', 'relationship_role_column'] as $field) {
                        if (!empty($relDef[$field])) {
                            $fieldsToCheck[] = $relDef[$field];
                        }
                    }

// check if the field is editable, if any field is not, return false
                    foreach ($fieldsToCheck as $field) {
                        if (!empty($field) && !($aItem->ACLFieldAccess($field, 'edit'))) {
                            return false;
                        }
                    }
                }
            }
        }
        return true;
    }

/**
     * @param array $data
     * @param array $parent_data
     * @param string $xTemplateSection
     * @param string $html_varName
     * @param aSubPanel $subpanel_def
     * @desc INTERNAL FUNCTION handles the rows
     */
    public 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;

$this->xTemplate->assign('BG_HILITE', $hilite_bg);
        $this->xTemplate->assign('CHECKALL', SugarThemeRegistry::current()->getImage('blank', '', 1, 1, '.gif', ''));

$subpanel_item_count = 0;
        $oddRow = true;
        $count = 0;
        reset($data);

//GETTING OFFSET
        $offset = $this->getOffset($html_varName);

$processed_ids = [];

$fill_additional_fields = [];
        //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 = [];

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', safeCount($thepanel->get_list_fields()));
            $this->xTemplate->parse($xTemplateSection . '.nodata');
        }

$module_name = '';

foreach ($data as $aItem) {
            $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();
            }

//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'];
                }
            }

if (isset($subpanel_list[strtolower($aItem->module_name)])) {
                if ($module_name != $aItem->module_name) {
                    $subpanel_list_fields = $subpanel_list[strtolower($aItem->module_name)]->get_list_fields();
                    $keyindex = array_search('edit_button', array_keys($subpanel_list_fields));

if ($keyindex !== false) {
                        $subpanel_list_fields = array_slice($subpanel_list_fields, 0, $keyindex, true);
                    }
                }

$aItem->updateDependentFieldForListView($subpanel_list_fields);
            } else {
                $aItem->updateDependentField();
            }

$fields = $aItem->get_list_view_data();
            $fields = $this->formatRowDates($aItem, $fields);

$aItem->ACLFilterFieldList($fields);

if (isset($processed_ids[$aItem->id])) {
                continue;
            }

$processed_ids[$aItem->id] = 1;

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

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 = [];
            $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);
            }

//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');
            $field_acl['field_edit_relate'] = $this->checkUnlinkPermission($linked_field, $aItem, $thepanel->parent_bean);

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['parent_bean'] = $aItem;
                    $list_field = array_merge($list_field, $field_acl);

if (isset($aItem->field_defs[strtolower($list_field['name'])])) {
                        // 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 = $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);
                        } elseif (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 ((($list_field['name'] === 'edit_button' && $field_acl['EditView']) || ($list_field['name'] === 'close_button' && $field_acl['EditView']) || ($list_field['name'] === 'remove_button' && $field_acl['field_edit_relate'])) && '' != ($_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/SugarSmarty/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([
                    'id' => $tempid,
                    'buttons' => $button_contents,
                    'class' => 'clickMenu subpanel records fancymenu button',

// assign flat value as false to display dropdown menu at any other preferences
                    'flat' => false,
                ], $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): ______________________________________.
     */
    public 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): ______________________________________.
     */
    public function __construct()
    {

$this->request = InputValidation::getService();

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): ______________________________________.
     */
    public function setRecordsPerPage($count)
    {
        $this->records_per_page = $count;
    }

/**sets the header title */
    public 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): ______________________________________.
     */
    public 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): ______________________________________.
     */
    public 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): ______________________________________.
     */
    public function initNewXTemplate($XTemplatePath, $modString, $imagePath = null)
    {
        $this->setXTemplatePath($XTemplatePath);
        if (isset($modString)) {
            $this->setModStrings($modString);
        }
        if (isset($imagePath)) {
            $this->setImagePath($imagePath);
        }
    }

public 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 = $this->request->getValidInputRequest($orderByDirection, 'Assert\Sql\OrderDirection', $defaultOrder);

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 = [];
            }
            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): ______________________________________.
     */
    public 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);
    }

public 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): ______________________________________.
     */
    public 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): ______________________________________.
     */
    public 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): ______________________________________.
     */
    public 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): ______________________________________.
     */
    public 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): ______________________________________.
     */
    public 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): ______________________________________.
     */
    public 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): ______________________________________.
     */
    public function setXTemplate($newXTemplate)
    {
        $this->xTemplate = $newXTemplate;
    }

/**returns the XTemplate
     * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc.
     * All Rights Reserved.
     * Contributor(s): ______________________________________.
     */
    public 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): ______________________________________.
     */
    public 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): ______________________________________.
     */
    public function getOffset($localVarName)
    {
        if ($this->query_where_has_changed || isset($GLOBALS['record_has_changed'])) {
            $this->setSessionVariable($localVarName, 'offset', 0);
        }
        $offset = $this->getSessionVariable($localVarName, 'offset');

return is_numeric($offset) ? (int)$offset : $offset;
    }

/**INTERNAL FUNCTION sets the offset in the session
     * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc.
     * All Rights Reserved.
     * Contributor(s): ______________________________________.
     */
    public 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): ______________________________________.
     */
    public function setSessionVariable($localVarName, $varName, $value)
    {
        $_SESSION[$this->local_current_module . '_' . $localVarName . '_' . $varName] = $value;
    }

public 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): ______________________________________.
     */
    public function getSessionVariable($localVarName, $varName)
    {
        //Set any variables pass in through request first
        if (isset($_REQUEST[$this->getSessionVariableName($localVarName, $varName)])) {
            $var = $this->request->getValidInputRequest($this->getSessionVariableName($localVarName, $varName));
            $this->setSessionVariable($localVarName, $varName, $var);
        }

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

return null;
    }

public function getUserVariable($localVarName, $varName)
    {
        global $current_user;
        if ($this->is_dynamic || $localVarName == 'CELL') {
            return;
        }
        if (isset($_REQUEST[$this->getSessionVariableName($localVarName, $varName)])) {
            $var = $this->request->getValidInputRequest($this->getSessionVariableName($localVarName, $varName));
            $this->setUserVariable($localVarName, $varName, $var);
        }
        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'
     */
    public function calculateSortOrder($sortOrderList)
    {
        $priority_map = [
            'request',
            'session',
            'subpaneldefs',
            'default',
        ];

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

/**
     * @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): ______________________________________..
     * @return void
     */
    public function getSessionVariableName($localVarName, $varName)
    {
        return $this->local_current_module . '_' . $localVarName . '_' . $varName;
    }

/**
     * @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): ______________________________________..
     * @return void
     */
    public function processSugarBean($xtemplateSection, $html_varName, $seed)
    {
        global $list_view_row_count;
        $current_offset = intval($this->getOffset($html_varName));
        $response = [];

//ADDING VCR CONTROL
        SugarVCR::erase($seed->module_dir);
        $params = [];
        //$filter = array('id', 'full_name');
        $filter = [];
        $ret_array = $seed->create_new_list_query($this->query_orderby, $this->query_where, $filter, $params, 0, '', true, $seed, true);
        if (!is_array($params)) {
            $params = [];
        }
        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 : safeCount($seed->column_fields));

return $list;
    }

public 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 = intval($this->getOffset($html_var));
        $module = $_REQUEST['module'] ?? '';
        $response = [];

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

// explicit request parameter gets priority over all
        $sort_order['request'] = $_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'] = $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 ['list' => $list, 'parent_data' => $response['parent_data'], 'query' => $response['query']];
    }

public function getBaseURL($html_varName)
    {
        static $cache = [];

if (!empty($cache[$html_varName])) {
            return $cache[$html_varName];
        }
        $blockVariables = ['mass', 'uid', 'massupdate', 'delete', 'merge', 'selectCount', 'current_query_by_page', 'bwcFrame'];
        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 != $this->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 .= '&' . $this->getSessionVariableName($html_varName, 'offset') . '=';
        $cache[$html_varName] = $baseurl;
        return $baseurl;
    }

/**
     * @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): ______________________________________..
     * @return void
     */
    public 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, ENT_COMPAT);
            $start_URL = htmlentities($this->base_URL . '0' . $dynamic_url, ENT_COMPAT);
            $previous_URL = htmlentities($this->base_URL . $previous_offset . $dynamic_url, ENT_COMPAT);
            $next_URL = htmlentities($this->base_URL . $next_offset . $dynamic_url, ENT_COMPAT);
            $end_URL = htmlentities($this->base_URL . 'end' . $dynamic_url, ENT_COMPAT);

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';
                $uid = $this->request->getValidInputRequest('uid', ['Assert\Delimited' => ['constraints' => 'Assert\Guid']]);
                $uids = empty($uid) || $massUpdateRun ? '' : implode(',', $uid);
                $select_entire_list = $massUpdateRun ? 0 : (int)$this->request->getValidInputRequest('select_entire_list');

echo '<textarea style="display: none" name="uid">' . htmlspecialchars($uids, ENT_COMPAT) . '</textarea>' .
                    '<input type="hidden" name="select_entire_list" value="' . $select_entire_list . '">' .
                    '<input type="hidden" name="' . htmlspecialchars($moduleString, ENT_COMPAT) . '" value="0">' .
                    '<input type="hidden" name="' . htmlspecialchars($moduleStringOrder, ENT_COMPAT) . '" value="0">';
            }

$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;

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";

$menuItems = [
                    '<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/SugarSmarty/plugins/function.sugar_action_menu.php';
                $select_link = smarty_function_sugar_action_menu([
                    '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 = Administration::getSettings('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'])) ? safeCount($_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']) && !$current_user->isAdminForModule($_REQUEST['module']))
            ) {
                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

public 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 '';
        }
    }

public function getAdditionalHeader()
    {
    }

/**
     * @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): ______________________________________..
     * @return void
     */
    public 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 = [];

//mail merge list
        $mergeList = [];
        $module = '';

//todo what is this?  It is using an array as a boolean
        foreach ($data as $aVal => $aItem) {
            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'] = is_numeric($offset) ? ($offset + $count + 1) : $offset;

$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
                $additionalDetailsFile = SugarAutoLoader::existingCustomOne('modules/' . $aItem->module_dir . '/metadata/additionalDetails.php');
                if ($this->_additionalDetails && $aItem->ACLAccess('DetailView') && !empty($additionalDetailsFile)) {
                    require_once $additionalDetailsFile;
                    $ad_function = (empty($this->additionalDetailsFunction) ? 'additionalDetails' : $this->additionalDetailsFunction) . $aItem->object_name;
                    $results = $ad_function($fields);
                    $results['string'] = str_replace(['&#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 = "<form border='0' action='index.php' method='post' name='form'>\n";
                    $delete .= smarty_function_sugar_csrf_form_token([], $this);
                    $delete .= "<input type='hidden' name='module' value='" . $aItem->module_dir . "'>\n";
                    $delete .= "<input type='hidden' name='action' value='Delete'>\n";
                    $delete .= "<input type='hidden' name='return_module' value='" . $aItem->module_dir . "'>\n";
                    $delete .= "<input type='hidden' name='return_action' value='index'>\n";
                    $delete .= "<input type='hidden' name='return_id' value=''>\n";
                    $delete .= "<input type='hidden' name='record' value='" . $fields['ID'] . "'>\n";
                    $delete .= "<input class='listViewTdToolsS1 button secondary' name='Delete' id='delete_" . $fields['ID'] . "' onclick='javascript: return confirm(\"" . $this->local_app_strings['NTC_DELETE_CONFIRMATION'] . "\")' type='submit' value='" . $this->local_app_strings['LBL_DELETE_INLINE'] . "'>\n";
                    $delete .= "</form>\n";
                    require_once 'include/SugarSmarty/plugins/function.sugar_action_menu.php';
                    $fields['DELETE_BUTTON'] = smarty_function_sugar_action_menu([
                        'id' => $aItem->module_dir . '_' . $fields['ID'] . '_create_button',
                        'buttons' => [$delete],
                    ], $this);
                }

/* escaped fields values to use in some places in XTemplates to prevent XSS
                   {FIELD|htmlspecialchars} does not work in XTemplates. */
                $fields['ESCAPED'] = array_map(
                    function ($value) {
                        return is_string($value) ? htmlspecialchars($value, ENT_QUOTES, 'UTF-8') : $value;
                    },
                    $fields
                );

$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"
                //. '' . "\n"
                . 'var is_show_fullname = '
                . $is_show_fullname . ";\n"
                . '</script>';
            $this->xTemplate->assign('ASSOCIATED_JAVASCRIPT_DATA', $associated_javascript_data);
        }

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

public function getLayoutManager()
    {
        if ($this->layout_manager == null) {
            $this->layout_manager = new LayoutManager();
        }
        return $this->layout_manager;
    }

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

$count = null;
        $cell_width = null;
        $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);
        [$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;
                    $count = !isset($count) ? 0 : $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');
        }
    }

/**
     * @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): ______________________________________..
     * @return void
     */

public 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 = [];
            $access = get_workflow_admin_modules_for_user($current_user);
            for ($i = 0; $i < safeCount($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);

if ($this->xTemplate->exists('main.pro_nav')) {
                $this->xTemplate->parse('main.pro_nav');
            }

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

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

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

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

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

public static 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}") . "' ";
    }

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

[$width, $height] = $this->getArrowImageSize();

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

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

[$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'>";
    }

public 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;
    }

public static 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;
    }

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

public function processSortArrows($html_varName)
    {

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

[$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);
        } elseif ($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
    public function loadListFieldDefs(&$subpanel_fields, &$child_focus)
    {
        $this->list_field_defs = $subpanel_fields;

for ($i = 0; $i < safeCount($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'];
            } elseif (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;';
            }
        }
    }

public 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): ______________________________________.
     */
    public 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): ______________________________________.
     */
    public 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
     */
    public function setAdditionalDetails($value = true, $function = '')
    {
        if (!empty($function)) {
            $this->additionalDetailsFunction = $function;
        }
        $this->_additionalDetails = $value;
    }

private function formatRowDates(SugarBean $bean, array $row): array
    {
        foreach ($bean->field_defs as $name => $field_def) {
            $nameUpper = strtoupper($name);

if (!isset($row[$nameUpper])) {
                continue;
            }

$row[$nameUpper] = ViewDateFormatter::format($field_def['type'], $row[$nameUpper]);
        }

return $row;
    }
}