data_array = $value; } public function processListViewMulti($seed, $xTemplateSection, $html_varName) { $this->shouldProcess = true; echo "

"; $this->processListViewTwo($seed, $xTemplateSection, $html_varName); echo "".translate('LBL_CHECKALL')." - ".translate('LBL_CLEARALL').""; echo '

'; } 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'] = $_REQUEST['module'] ; return; } } if (strcmp(strtolower($_REQUEST['action']), 'popup') != 0) { $_SESSION['last_search_mod'] = $_REQUEST['module'] ; } //following session variable will track the detail view navigation history. //needs to the reset after each search. $this->setLocalSessionVariable($html_varName, "DETAIL_NAV_HISTORY", false); require_once('include/MassUpdate.php'); $mass = new MassUpdate(); $add_acl_javascript = false; if (!isset($_REQUEST['action'])) { $this->shouldProcess=false; } else { $this->shouldProcess = is_subclass_of($seed, "SugarBean") && (($_REQUEST['action'] == 'index') || ('ListView' == substr($_REQUEST['action'], 0, 8)) /* cn: to include all ListViewXXX.php type views */) && ($_REQUEST['module'] == $seed->module_dir); } //when processing a multi-select popup. if ($this->process_for_popups && $this->multi_select_popup) { $this->shouldProcess =true; } //mass update turned off? if (!$this->show_mass_update) { $this->shouldProcess = false; } if (is_subclass_of($seed, "SugarBean")) { if ($seed->bean_implements('ACL')) { if (!ACLController::checkAccess($seed->module_dir, 'list', true)) { if ($_REQUEST['module'] != 'Home') { ACLController::displayNoAccess(); } return; } if (!ACLController::checkAccess($seed->module_dir, 'export', true)) { $sugar_config['disable_export']= true; } } } //force mass update form if requested. if ($this->force_mass_update) { $this->shouldProcess = true; } if ($this->shouldProcess) { echo $mass->getDisplayMassUpdateForm(true, $this->multi_select_popup); echo $mass->getMassUpdateFormHeader($this->multi_select_popup); $mass->setSugarBean($seed); //C.L. Fix for 10048, do not process handleMassUpdate for multi select popups if (!$this->multi_select_popup) { $mass->handleMassUpdate(); } } $this->processListViewTwo($seed, $xTemplateSection, $html_varName); if ($this->shouldProcess && empty($this->process_for_popups)) { //echo "".translate('LBL_CLEARALL').""; // 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']); } } /** * @return void * @param unknown $data * @param unknown $xTemplateSection * @param unknown $html_varName * @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; global $click_bg; $this->xTemplate->assign("BG_HILITE", $hilite_bg); $this->xTemplate->assign('CHECKALL', SugarThemeRegistry::current()->getImage('blank', '', 1, 1, ".gif", '')); //$this->xTemplate->assign("BG_CLICK", $click_bg); $subpanel_item_count = 0; $oddRow = true; $count = 0; reset($data); //GETTING OFFSET $offset = $this->getOffset($html_varName); //$totaltime = 0; $processed_ids = array(); $fill_additional_fields = array(); //Either retrieve the is_fill_in_additional_fields property from the lone //subpanel or visit each subpanel's subpanels to retrieve the is_fill_in_addition_fields //property $subpanel_list=array(); if ($subpanel_def->isCollection()) { $subpanel_list=$subpanel_def->sub_subpanels; } else { $subpanel_list[]= $subpanel_def; } foreach ($subpanel_list as $this_subpanel) { if ($this_subpanel->is_fill_in_additional_fields()) { $fill_additional_fields[] = $this_subpanel->bean_name; $fill_additional_fields[$this_subpanel->bean_name] = true; } } if (empty($data)) { $this->xTemplate->assign("ROW_COLOR", 'oddListRow'); $thepanel=$subpanel_def; if ($subpanel_def->isCollection()) { $thepanel=$subpanel_def->get_header_panel_def(); } $this->xTemplate->assign("COL_COUNT", count($thepanel->get_list_fields())); $this->xTemplate->parse($xtemplateSection.".nodata"); } foreach ($data as $aVal => $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(); //$aItem->fill_in_additional_detail_fields(); } //rrs bug: 25343 $aItem->call_custom_logic("process_record"); if (isset($parent_data[$aItem->id])) { $aItem->parent_name = $parent_data[$aItem->id]['parent_name']; if (!empty($parent_data[$aItem->id]['parent_name_owner'])) { $aItem->parent_name_owner = $parent_data[$aItem->id]['parent_name_owner']; $aItem->parent_name_mod = $parent_data[$aItem->id]['parent_name_mod']; } } $fields = $aItem->get_list_view_data(); if (isset($processed_ids[$aItem->id])) { continue; } else { $processed_ids[$aItem->id] = 1; } //ADD OFFSET TO ARRAY $fields['OFFSET'] = ($offset + $count + 1); if ($this->shouldProcess) { if ($aItem->ACLAccess('EditView')) { $this->xTemplate->assign('PREROW', ""); } 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', ""); } if ($oddRow) { $ROW_COLOR = 'oddListRow'; $BG_COLOR = $odd_bg; } else { $ROW_COLOR = 'evenListRow'; $BG_COLOR = $even_bg; } $oddRow = !$oddRow; $button_contents = array(); $this->xTemplate->assign("ROW_COLOR", $ROW_COLOR); $this->xTemplate->assign("BG_COLOR", $BG_COLOR); $layout_manager = $this->getLayoutManager(); $layout_manager->setAttribute('context', 'List'); $layout_manager->setAttribute('image_path', $this->local_image_path); $layout_manager->setAttribute('module_name', $subpanel_def->_instance_properties['module']); if (!empty($this->child_focus)) { $layout_manager->setAttribute('related_module_name', $this->child_focus->module_dir); } //AG$subpanel_data = $this->list_field_defs; //$bla = array_pop($subpanel_data); //select which sub-panel to display here, the decision will be made based on the type of //the sub-panel and panel in the bean being processed. if ($subpanel_def->isCollection()) { $thepanel=$subpanel_def->sub_subpanels[$aItem->panel_name]; } else { $thepanel=$subpanel_def; } /* BEGIN - SECURITY GROUPS */ //This check is costly doing it field by field in the below foreach //instead pull up here and do once per record.... $aclaccess_is_owner = false; $aclaccess_in_group = false; global $current_user; if (is_admin($current_user)) { $aclaccess_is_owner = true; } else { $aclaccess_is_owner = $aItem->isOwner($current_user->id); } require_once("modules/SecurityGroups/SecurityGroup.php"); $aclaccess_in_group = SecurityGroup::groupHasAccess($aItem->module_dir, $aItem->id); /* END - SECURITY GROUPS */ //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; } /* BEGIN - SECURITY GROUPS */ /** $field_acl['DetailView'] = $aItem->ACLAccess('DetailView'); $field_acl['ListView'] = $aItem->ACLAccess('ListView'); $field_acl['EditView'] = $aItem->ACLAccess('EditView'); $field_acl['Delete'] = $aItem->ACLAccess('Delete'); */ //pass is_owner, in_group...vars defined above $field_acl['DetailView'] = $aItem->ACLAccess('DetailView', $aclaccess_is_owner, $aclaccess_in_group); $field_acl['ListView'] = $aItem->ACLAccess('ListView', $aclaccess_is_owner, $aclaccess_in_group); $field_acl['EditView'] = $aItem->ACLAccess('EditView', $aclaccess_is_owner, $aclaccess_in_group); $field_acl['Delete'] = $aItem->ACLAccess('Delete', $aclaccess_is_owner, $aclaccess_in_group); /* END - SECURITY GROUPS */ 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' && !empty($list_field['force_query_only_display'])) { //if you are here you have column that is query only but needs to be displayed as blank. This is helpful //for collections such as Activities where you have a field in only one object and wish to show it in the subpanel list $count++; $widget_contents = ' '; $this->xTemplate->assign('CLASS', ""); $this->xTemplate->assign('CELL_COUNT', $count); $this->xTemplate->assign('CELL', $widget_contents); $this->xTemplate->parse($xtemplateSection.".row.cell"); } else { if ($usage != 'query_only') { $list_field['name']=$field_name; $module_field = $field_name.'_mod'; $owner_field = $field_name.'_owner'; if (!empty($aItem->$module_field)) { $list_field['owner_id'] = $aItem->$owner_field; $list_field['owner_module'] = $aItem->$module_field; } else { $list_field['owner_id'] = false; $list_field['owner_module'] = false; } if (isset($list_field['alias'])) { $list_field['name'] = $list_field['alias']; } else { $list_field['name']=$field_name; } $list_field['fields'] = $fields; $list_field['module'] = $aItem->module_dir; $list_field['start_link_wrapper'] = $this->start_link_wrapper; $list_field['end_link_wrapper'] = $this->end_link_wrapper; $list_field['subpanel_id'] = $this->subpanel_id; $list_field += $field_acl; if (isset($aItem->field_defs[strtolower($list_field['name'])])) { require_once('include/SugarFields/SugarFieldHandler.php'); // We need to see if a sugar field exists for this field type first, // if it doesn't, toss it at the old sugarWidgets. This is for // backwards compatibility and will be removed in a future release $vardef = $aItem->field_defs[strtolower($list_field['name'])]; if (isset($vardef['type'])) { $fieldType = isset($vardef['custom_type'])?$vardef['custom_type']:$vardef['type']; $tmpField = SugarFieldHandler::getSugarField($fieldType, true); } else { $tmpField = null; } if ($tmpField != null) { $widget_contents = SugarFieldHandler::displaySmarty($list_field['fields'], $vardef, 'ListView', $list_field); } else { // No SugarField for this particular type // Use the old, icky, SugarWidget for now $widget_contents = $layout_manager->widgetDisplay($list_field); } if (isset($list_field['widget_class']) && $list_field['widget_class'] == 'SubPanelDetailViewLink') { // We need to call into the old SugarWidgets for the time being, so it can generate a proper link with all the various corner-cases handled // So we'll populate the field data with the pre-rendered display for the field $list_field['fields'][$field_name] = $widget_contents; if ('full_name' == $field_name) {//bug #32465 $list_field['fields'][strtoupper($field_name)] = $widget_contents; } //vardef source is non db, assign the field name to varname for processing of column. if (!empty($vardef['source']) && $vardef['source']=='non-db') { $list_field['varname'] = $field_name; } $widget_contents = $layout_manager->widgetDisplay($list_field); } else { if (isset($list_field['widget_class']) && $list_field['widget_class'] == 'SubPanelEmailLink') { $widget_contents = $layout_manager->widgetDisplay($list_field); } } $count++; $this->xTemplate->assign('CELL_COUNT', $count); $this->xTemplate->assign('CLASS', ""); if (empty($widget_contents)) { $widget_contents = ' '; } $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 = ' '; } $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['Delete'])) && '' != ($_content = $layout_manager->widgetDisplay($list_field))) { $button_contents[] = $_content; unset($_content); } else { $button_contents[] = ''; } } 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 = ' '; } $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 (!empty($button_contents)) { $button_contents = array_filter($button_contents); if (!empty($button_contents)) { // this is for inline buttons on listviews // bug#51275: smarty widget to help provide the action menu functionality as it is currently sprinkled throughout the app with html require_once('include/Smarty/plugins/function.sugar_action_menu.php'); $tempid = create_guid(); array_unshift($button_contents, "

" . array_shift($button_contents) . "

"); $action_button = smarty_function_sugar_action_menu(array( 'id' => $tempid, 'buttons' => $button_contents, 'class' => 'clickMenu subpanel records fancymenu button', 'flat' => false //assign flat value as false to display dropdown menu at any other preferences. ), $this->xTemplate); } else { $action_button = ''; } $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() { 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 = (string)SugarThemeRegistry::current(); $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 = $defaultOrder; if (isset($_REQUEST[$orderByDirection])) { $possibleRequestOrderBy = $_REQUEST[$orderByDirection]; if ($possibleRequestOrderBy == 'asc' || $possibleRequestOrderBy == 'desc') { $orderByValue = $possibleRequestOrderBy; } } if (isset($_REQUEST[$orderByColumn])) { $last = $this->getSessionVariable($varName, "OBL"); } if (!empty($last) && $last == $sortBy) { $lastEqualsSortBy = true; } else { $orderByValue = $defaultOrder; $this->setSessionVariable($varName, "OBL", $sortBy); } $desc = $orderByValue == 'desc'; $orderByDirectionValue = false; $this->setSessionVariable($varName, $sortBy . "S", $desc); if (!empty($sortBy)) { if (empty($force_sortorder)) { if (substr_count(strtolower($sortBy), ' desc') == 0 && substr_count(strtolower($sortBy), ' asc') == 0) { if ($sortBy) { $orderByDirectionValue = $desc ? 'asc' : 'desc'; } $this->query_orderby = $sortBy . ' ' . $orderByValue; } } else { $this->query_orderby = $sortBy . ' ' . $force_sortorder; } if (!isset($this->appendToBaseUrl)) { $this->appendToBaseUrl = array(); } if ($orderByDirectionValue) { $this->appendToBaseUrl[$orderByDirection] = $orderByDirectionValue; } $offsetVar = $this->getSessionVariableName($varName, "offset"); if (isset($_REQUEST[$offsetVar])) { $this->appendToBaseUrl[$offsetVar] = $_REQUEST[$offsetVar]; } //Just clear from url... $this->appendToBaseUrl[$orderByColumn] = false; } else { $this->query_orderby = ""; } $this->sortby = $sortBy; return $this->query_orderby; } /**sets the parameters dealing with the db * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc. * All Rights Reserved. * Contributor(s): ______________________________________. */ 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); //SETTING ORDER_BY FOR USE IN DETAILVIEW $this->setLocalSessionVariable($varName, "ORDER_BY_DETAIL", $this->query_orderby); } 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 * @param $localVarName * @return int */ public function getOffset($localVarName) { if ($this->query_where_has_changed || isset($GLOBALS['record_has_changed'])) { $this->setSessionVariable($localVarName, 'offset', 0); } // this might return several kinds of values: 0, '', 'end', etc $offset = $this->getSessionVariable($localVarName, 'offset'); if (isset($offset) && ($offset !== '')) { return $offset; } return 0; } /**INTERNAL FUNCTION sets the offset in the session * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc. * All Rights Reserved. * Contributor(s): ______________________________________. */ 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)])) { $this->setSessionVariable($localVarName, $varName, $_REQUEST[$this->getSessionVariableName($localVarName, $varName)]); } if (isset($_SESSION[$this->getSessionVariableName($localVarName, $varName)])) { return $_SESSION[$this->getSessionVariableName($localVarName, $varName)]; } return ''; } public function getUserVariable($localVarName, $varName) { global $current_user; if ($this->is_dynamic || $localVarName == 'CELL') { return; } if (isset($_REQUEST[$this->getSessionVariableName($localVarName, $varName)])) { $this->setUserVariable($localVarName, $varName, $_REQUEST[$this->getSessionVariableName($localVarName, $varName)]); } return $current_user->getPreference($this->getSessionVariableName($localVarName, $varName)); } /** * helper method to determine sort order by priority of source * 1. explicit in request object * 2. in session variable * 3. subpaneldefs metadata * 4. default 'asc' * @param array $sortOrderList - contains options * @return string 'asc' | 'desc' */ public function calculateSortOrder($sortOrderList) { $priority_map = array( 'request', 'session', 'subpaneldefs', 'default', ); foreach ($priority_map as $p) { if (array_key_exists($p, $sortOrderList)) { $order = strtolower($sortOrderList[$p]); if (in_array($order, array('asc', 'desc'))) { return $order; } } } return 'asc'; } /** * @return void * @param unknown $localVarName * @param unknown $varName * @desc INTERNAL FUNCTION returns the session/query variable name * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc. * All Rights Reserved. * Contributor(s): ______________________________________.. */ public function getSessionVariableName($localVarName, $varName) { return $this->local_current_module."_".$localVarName."_".$varName; } /** * @return void * @param unknown $seed * @param unknown $xTemplateSection * @param unknown $html_varName * @desc INTERNAL FUNCTION Handles List Views using seeds that extend SugarBean $XTemplateSection is the section in the XTemplate file that should be parsed usually main $html_VarName is the variable name used in the XTemplateFile e.g. TASK $seed is a seed that extends SugarBean * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc.. * All Rights Reserved.. * Contributor(s): ______________________________________.. */ public function processSugarBean($xtemplateSection, $html_varName, $seed) { global $list_view_row_count; $current_offset = $this->getOffset($html_varName); $response = array(); //ADDING VCR CONTROL SugarVCR::erase($seed->module_dir); $params = array(); //$filter = array('id', 'full_name'); $filter=array(); $ret_array = $seed->create_new_list_query($this->query_orderby, $this->query_where, $filter, $params, 0, '', true, $seed, true); if (!is_array($params)) { $params = array(); } if (!isset($params['custom_select'])) { $params['custom_select'] = ''; } if (!isset($params['custom_from'])) { $params['custom_from'] = ''; } if (!isset($params['custom_where'])) { $params['custom_where'] = ''; } if (!isset($params['custom_order_by'])) { $params['custom_order_by'] = ''; } $main_query = $ret_array['select'] . $params['custom_select'] . $ret_array['from'] . $params['custom_from'] . $ret_array['where'] . $params['custom_where'] . $ret_array['order_by'] . $params['custom_order_by']; SugarVCR::store($seed->module_dir, $main_query); //ADDING VCR CONTROL if (empty($this->related_field_name)) { $response = $seed->get_list($this->query_orderby, $this->query_where, $current_offset, $this->query_limit); } else { $related_field_name = $this->related_field_name; $response = $seed->get_related_list( $this->child_focus, $related_field_name, $this->query_orderby, $this->query_where, $current_offset, $this->query_limit ); } $list = $response['list']; $row_count = $response['row_count']; $next_offset = $response['next_offset']; $previous_offset = $response['previous_offset']; if (!empty($response['current_offset'])) { $current_offset = $response['current_offset']; } $list_view_row_count = $row_count; $this->processListNavigation($xtemplateSection, $html_varName, $current_offset, $next_offset, $previous_offset, $row_count, null, null, empty($seed->column_fields) ? null : count($seed->column_fields)); return $list; } public function processUnionBeans($sugarbean, $subpanel_def, $html_var = 'CELL', $countOnly = false) { $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); $last_detailview_record = $this->getSessionVariable("detailview", "record"); if (!empty($last_detailview_record) && $last_detailview_record != $sugarbean->id) { $GLOBALS['record_has_changed'] = true; } $this->setSessionVariable("detailview", "record", $sugarbean->id); $current_offset = $this->getOffset($html_var); $module = isset($_REQUEST['module']) ? $_REQUEST['module'] : ''; $response = array(); // choose sort order $sort_order = array(); $sort_order['default'] = 'asc'; // explicit request parameter gets priority over all $sort_order['request'] = isset($_REQUEST['sort_order']) ? $_REQUEST['sort_order'] : null; // see if the session data has a sort order if (isset($_SESSION['last_sub' . $this->subpanel_module . '_order'])) { $sort_order['session'] = $_SESSION['last_sub' . $this->subpanel_module . '_order']; // We swap the order when the request contains an offset (indicating a column sort issued); // otherwise we do not sort. If we don't make this check, then the subpanel listview will // swap ordering each time a new record is entered via quick create forms if (isset($_REQUEST[$module . '_' . $html_var . '_offset'])) { $sort_order['session'] = $sort_order['session'] == 'asc' ? 'desc' : 'asc'; } } else { $sort_order['session'] = null; } // does the metadata have a default sort order? $sort_order['subpaneldefs'] = isset($subpanel_def->_instance_properties['sort_order']) ? $subpanel_def->_instance_properties['sort_order'] : null; $this->sort_order = $this->calculateSortOrder($sort_order); if (isset($subpanel_def->_instance_properties['sort_by'])) { $this->query_orderby = $subpanel_def->_instance_properties['sort_by']; } else { $this->query_orderby = 'id'; } $this->getOrderBy($html_var, $this->query_orderby, $this->sort_order); $_SESSION['last_sub' .$this->subpanel_module. '_order'] = $this->sort_order; $_SESSION['last_sub' .$this->subpanel_module. '_url'] = $this->getBaseURL($html_var); // Bug 8139 - Correct Subpanel sorting on 'name', when subpanel sorting default is 'last_name, first_name' if (($this->sortby == 'name' || $this->sortby == 'last_name') && str_replace(' ', '', trim($subpanel_def->_instance_properties['sort_by'])) == 'last_name,first_name') { $this->sortby = 'last_name '.$this->sort_order.', first_name '; } try { 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, $this->records_per_page, $this->query_limit, $subpanel_def ); $this->response =& $response; } } catch (Exception $ex) { LoggerManager::getLogger()->fatal('[' . __METHOD__ . "] . {$ex->getMessage()}"); return ['list' => [], 'parent_data' => [], 'query' => '']; } $list = $response['list']; if (!$countOnly) { $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 $response; } public function getBaseURL($html_varName) { static $cache = array(); if (!empty($cache[$html_varName])) { return $cache[$html_varName]; } $blockVariables = array('mass', 'uid', 'massupdate', 'delete', 'merge', 'selectCount','current_query_by_page'); if (!empty($this->base_URL)) { return $this->base_URL; } $baseurl = $_SERVER['PHP_SELF']; if (empty($baseurl)) { $baseurl = 'index.php'; } /*fixes an issue with deletes when doing a search*/ foreach (array_merge($_GET, $_POST) as $name=>$value) { //echo ("$name = $value
"); if (!empty($value) && $name != 'sort_order' //&& $name != ListView::getSessionVariableName($html_varName,"ORDER_BY") && $name != ListView::getSessionVariableName($html_varName, "offset") /*&& substr_count($name, "ORDER_BY")==0*/ && !in_array($name, $blockVariables)) { if (is_array($value)) { foreach ($value as $valuename=>$valuevalue) { if (substr_count($baseurl, '?') > 0) { $baseurl .= "&{$name}[]=".$valuevalue; } else { $baseurl .= "?{$name}[]=".$valuevalue; } } } else { $value = urlencode($value); if (substr_count($baseurl, '?') > 0) { $baseurl .= "&$name=$value"; } else { $baseurl .= "?$name=$value"; } } } } if ($_SERVER['REQUEST_METHOD'] == 'POST') { // at this point it is possible that the above foreach already executed resulting in double ?'s in the url if (substr_count($baseurl, '?') == 0) { $baseurl .= '?'; } if (isset($_REQUEST['action'])) { $baseurl.= '&action='.$_REQUEST['action']; } if (isset($_REQUEST['record'])) { $baseurl .= '&record='.$_REQUEST['record']; } if (isset($_REQUEST['module'])) { $baseurl .= '&module='.$_REQUEST['module']; } } $baseurl .= "&".ListView::getSessionVariableName($html_varName, "offset")."="; $cache[$html_varName] = $baseurl; return $baseurl; } /** * @return void * @param unknown $data * @param unknown $xTemplateSection * @param unknown $html_varName * @desc INTERNAL FUNCTION process the List Navigation * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc. * All Rights Reserved. * Contributor(s): ______________________________________.. */ 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 = (int)$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 last page. if ($end_record > $row_count+1) { $end_record = $row_count+1; } // Determine the start location of the last page if ($row_count == 0) { $number_pages = 0; } else { $number_pages = floor(($row_count - 1) / $this->records_per_page); } $last_offset = $number_pages * $this->records_per_page; if (empty($this->query_limit) || $this->query_limit > $this->records_per_page) { $this->base_URL = $this->getBaseURL($html_varName); $dynamic_url = ''; if ($this->is_dynamic) { $dynamic_url .='&'. $this->getSessionVariableName($html_varName, 'ORDER_BY') . '='. $this->getSessionVariable($html_varName, 'ORDER_BY').'&sort_order='.$this->sort_order.'&to_pdf=true&action=SubPanelViewer&subpanel=' . $this->subpanel_module; } $current_URL = htmlentities($this->base_URL.$current_offset.$dynamic_url); $start_URL = htmlentities($this->base_URL."0".$dynamic_url); $previous_URL = htmlentities($this->base_URL.$previous_offset.$dynamic_url); $next_URL = htmlentities($this->base_URL.$next_offset.$dynamic_url); $end_URL = htmlentities($this->base_URL.'end'.$dynamic_url); if (!empty($this->start_link_wrapper)) { $current_URL = $this->start_link_wrapper.$current_URL.$this->end_link_wrapper; $start_URL = $this->start_link_wrapper.$start_URL.$this->end_link_wrapper; $previous_URL = $this->start_link_wrapper.$previous_URL.$this->end_link_wrapper; $next_URL = $this->start_link_wrapper.$next_URL.$this->end_link_wrapper; $end_URL = $this->start_link_wrapper.$end_URL.$this->end_link_wrapper; } $moduleString = htmlspecialchars("{$currentModule}_{$html_varName}_offset"); $moduleStringOrder = htmlspecialchars("{$currentModule}_{$html_varName}_ORDER_BY"); if ($this->shouldProcess && !$this->multi_select_popup) { // check the checkboxes onload echo "\n"; $massUpdateRun = isset($_REQUEST['massupdate']) && $_REQUEST['massupdate'] == 'true'; $uids = empty($_REQUEST['uid']) || $massUpdateRun ? '' : $_REQUEST['uid']; $select_entire_list = ($massUpdateRun) ? 0 : (isset($_POST['select_entire_list']) ? $_POST['select_entire_list'] : (isset($_REQUEST['select_entire_list']) ? htmlspecialchars($_REQUEST['select_entire_list']) : 0)); echo "\n" . "\n". "\n". "\n"; } $GLOBALS['log']->debug("Offsets: (start, previous, next, last)(0, $previous_offset, $next_offset, $last_offset)"); if (0 == $current_offset) { $start_link = ""; $previous_link = ""; } else { if ($this->multi_select_popup) {// nav links for multiselect popup, submit form to save checks. $start_link = ""; $previous_link = ""; } elseif ($this->shouldProcess) { $start_link = ""; $previous_link = ""; } else { $onClick = ''; if (0 != preg_match('/javascript.*/', $start_URL)) { $onClick = "\"$start_URL;\""; } else { $onClick ="'location.href=\"$start_URL\";'"; } $start_link = ""; $onClick = ''; if (0 != preg_match('/javascript.*/', $previous_URL)) { $onClick = "\"$previous_URL;\""; } else { $onClick = "'location.href=\"$previous_URL\";'"; } $previous_link = ""; } } if ($last_offset <= $current_offset) { $end_link = ""; $next_link = ""; } else { if ($this->multi_select_popup) { // nav links for multiselect popup, submit form to save checks. $end_link = ""; if (!empty($sugar_config['disable_count_query'])) { $end_link = ''; } $next_link = ""; } elseif ($this->shouldProcess) { $end_link = ""; $next_link = ""; } else { $onClick = ''; if (0 != preg_match('/javascript.*/', $next_URL)) { $onClick = "\"$next_URL;\""; } else { $onClick ="'location.href=\"$next_URL\";'"; } $next_link = ""; $onClick = ''; if (0 != preg_match('/javascript.*/', $end_URL)) { $onClick = "\"$end_URL;\""; } else { $onClick = "'location.href=\"$end_URL\";'"; } $end_link = ""; } } $GLOBALS['log']->info("Offset (next, current, prev)($next_offset, $current_offset, $previous_offset)"); $GLOBALS['log']->info("Start/end records ($start_record, $end_record)"); $end_record = $end_record-1; $script_href = "records_per_page)}else {sListView.check_all(document.MassUpdate, \"mass[]\", true)};\' href=\'#\'>{$this->local_app_strings['LBL_LISTVIEW_OPTION_CURRENT']} ({$this->records_per_page})‎" . "{$this->local_app_strings['LBL_LISTVIEW_OPTION_ENTIRE']} ({$row_count})‎" . "{$this->local_app_strings['LBL_LISTVIEW_NONE']}"; $close_inline_img = SugarThemeRegistry::current()->getImage('close_inline', 'border=0', null, null, ".gif", $app_strings['LBL_CLOSEINLINE']); echo ""; 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 "\n"; //Bug#52931: Replace with actionMenu //$select_link = "".$this->local_app_strings['LBL_LINK_SELECT']." ".SugarThemeRegistry::current()->getImage('MoreDetail', 'border=0', 11, 7, '.png', $app_strings['LBL_MOREDETAIL']).""; $menuItems = array( "", "{$app_strings['LBL_LISTVIEW_OPTION_CURRENT']} ({$pageTotal})‎", "{$app_strings['LBL_LISTVIEW_OPTION_ENTIRE']} ({$total_label})‎", "{$app_strings['LBL_LISTVIEW_NONE']}", ); require_once('include/Smarty/plugins/function.sugar_action_menu.php'); $select_link = smarty_function_sugar_action_menu(array( 'class' => 'clickMenu selectmenu', 'id' => 'selectLink', 'buttons' => $menuItems, 'flat' => false, ), $this->xTemplate); } else { $select_link = " "; } $export_link = ''; if ($this->show_delete_button) { $delete_link = ''; } else { $delete_link = ' '; } $admin = BeanFactory::newBean('Administration'); $admin->retrieveSettings('system'); $user_merge = $current_user->getPreference('mailmerge_on'); if ($user_merge == 'on' && isset($admin->settings['system_mailmerge_on']) && $admin->settings['system_mailmerge_on']) { echo ""; $merge_link = " | ".$this->local_app_strings['LBL_MAILMERGE'].""; } else { $merge_link = " "; } $selected_objects_span = " | {$this->local_app_strings['LBL_LISTVIEW_SELECTED_OBJECTS']}"; if ($_REQUEST['module'] == 'Home' || $this->local_current_module == 'Import' || $this->show_export_button == false || (!empty($sugar_config['disable_export'])) || (!empty($sugar_config['admin_export_only']) && !( is_admin($current_user) || (ACLController::moduleSupportsACL($_REQUEST['module']) && ACLAction::getUserAccessLevel($current_user->id, $_REQUEST['module'], 'access') == ACL_ALLOW_ENABLED && (ACLAction::getUserAccessLevel($current_user->id, $_REQUEST['module'], 'admin') == ACL_ALLOW_ADMIN || ACLAction::getUserAccessLevel($current_user->id, $_REQUEST['module'], 'admin') == ACL_ALLOW_ADMIN_DEV)) ))) { if ($_REQUEST['module'] != 'InboundEmail' && $_REQUEST['module'] != 'EmailMan' && $_REQUEST['module'] != 'iFrames') { $selected_objects_span = ''; } $export_link = " "; $merge_link = " "; } elseif ($_REQUEST['module'] != "Accounts" && $_REQUEST['module'] != "Cases" && $_REQUEST['module'] != "Contacts" && $_REQUEST['module'] != "Leads" && $_REQUEST['module'] != "Opportunities") { $merge_link = " "; } if ($this->show_paging == true) { if (!empty($sugar_config['disable_count_query'])) { if ($row_count > $end_record) { $row_count .= '+'; } } $html_text = ''; $html_text .= "\n"; $html_text .= "\n"; //$html_text .= "\n"; //$html_text .= "

$export_link$merge_link$selected_objects_span

"; if ($subpanel_def != null) { include_once('include/SubPanel/SubPanelTiles.php'); $subpanelTiles = new SubPanelTiles($sugarbean); $html_text .= "\n"; $html_text .= "\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() { } /** * @return void * @param unknown $data * @param unknown $xTemplateSection * @param unknown $html_varName * @desc INTERNAL FUNCTION handles the rows * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc. * All Rights Reserved. * Contributor(s): ______________________________________.. */ 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 = (int)$this->getOffset($html_varName); $timeStamp = $this->unique_id(); $_SESSION[$html_varName."_FROM_LIST_VIEW"] = $timeStamp; $associated_row_data = array(); //mail merge list $mergeList = array(); $module = ''; //todo what is this? It is using an array as a boolean 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'] = ($offset + $count + 1); $fields['STAMP'] = $timeStamp; if ($this->shouldProcess) { $prerow = ''; if (!isset($this->data_array)) { $prerow .= ""; } $this->xTemplate->assign('PREROW', $prerow); $this->xTemplate->assign('CHECKALL', ""); } if (!isset($this->data_array)) { $tag = $aItem->listviewACLHelper(); $this->xTemplate->assign('TAG', $tag) ; } if ($oddRow) { $ROW_COLOR = 'oddListRow'; $BG_COLOR = $odd_bg; } else { $ROW_COLOR = 'evenListRow'; $BG_COLOR = $even_bg; } $oddRow = !$oddRow; $this->xTemplate->assign('ROW_COLOR', $ROW_COLOR); $this->xTemplate->assign('BG_COLOR', $BG_COLOR); if (isset($this->data_array)) { $this->xTemplate->assign('KEY', $aVal); $this->xTemplate->assign('VALUE', $aItem); $this->xTemplate->assign('INDEX', $count); } else { //AED -- some modules do not have their additionalDetails.php established. Add a check to ensure require_once does not fail // Bug #2786 if ($this->_additionalDetails && $aItem->ACLAccess('DetailView') && (file_exists('modules/' . $aItem->module_dir . '/metadata/additionalDetails.php') || file_exists('custom/modules/' . $aItem->module_dir . '/metadata/additionalDetails.php'))) { $additionalDetailsFile = 'modules/' . $aItem->module_dir . '/metadata/additionalDetails.php'; if (file_exists('custom/modules/' . $aItem->module_dir . '/metadata/additionalDetails.php')) { $additionalDetailsFile = 'custom/modules/' . $aItem->module_dir . '/metadata/additionalDetails.php'; } require_once($additionalDetailsFile); $ad_function = (empty($this->additionalDetailsFunction) ? 'additionalDetails' : $this->additionalDetailsFunction) . $aItem->object_name; $results = $ad_function($fields); $results['string'] = str_replace(array("'", "'"), '\'', $results['string']); // no xss! if (trim($results['string']) == '') { $results['string'] = $app_strings['LBL_NONE']; } $fields[$results['fieldToAddTo']] = $fields[$results['fieldToAddTo']].''; } if ($aItem->ACLAccess('Delete')) { $delete = ''.$this->local_app_strings['LBL_DELETE_INLINE'].''; require_once('include/Smarty/plugins/function.sugar_action_menu.php'); $fields['DELETE_BUTTON'] = smarty_function_sugar_action_menu(array( 'id' => $aItem->module_dir.'_'.$fields['ID'].'_create_button', 'buttons' => array($delete), ), $this); } $this->xTemplate->assign($html_varName, $fields); $aItem->setupCustomFields($aItem->module_dir); $aItem->custom_fields->populateAllXTPL($this->xTemplate, 'detail', $html_varName, $fields); } if (!isset($this->data_array) && $aItem->ACLAccess('DetailView')) { $count++; } if (isset($this->data_array)) { $count++; } if (!isset($this->data_array)) { $aItem->list_view_parse_additional_sections($this->xTemplate, $xtemplateSection); if ($this->xTemplate->exists($xtemplateSection.'.row.pro')) { $this->xTemplate->parse($xtemplateSection.'.row.pro'); } } $this->xTemplate->parse($xtemplateSection . '.row'); if (isset($fields['ID'])) { $associated_row_data[$fields['ID']] = $fields; // Bug 38908: cleanup data for JS to avoid having shuffled around foreach ($fields as $key => $value) { if ($value == ' ') { $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 = ''; $this->xTemplate->assign('ASSOCIATED_JAVASCRIPT_DATA', $associated_javascript_data); } $this->xTemplate->parse($xtemplateSection); } public function getLayoutManager() { require_once('include/generic/LayoutManager.php'); 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') { $layout_manager = $this->getLayoutManager(); $layout_manager->setAttribute('order_by_link', $this->processOrderBy($html_var)); $layout_manager->setAttribute('context', 'HeaderCell'); $layout_manager->setAttribute('image_path', $this->local_image_path); $layout_manager->setAttribute('html_varName', $html_var); $layout_manager->setAttribute('module_name', $source_module); list($orderBy, $desc) = $this->getOrderByInfo($html_var); if ($orderBy == 'amount*1') { $orderBy= 'amount'; } $buttons = false; $col_count = 0; foreach ($subpanel_def->get_list_fields() as $column_name=>$widget_args) { $usage = empty($widget_args['usage']) ? '' : $widget_args['usage']; if ($usage != 'query_only' || !empty($widget_args['force_query_only_display'])) { $imgArrow = ''; if ($orderBy == $column_name || (isset($widget_args['sort_by']) && str_replace('.', '_', $widget_args['sort_by']) == $orderBy)) { $imgArrow = "_down"; if ($this->sort_order == 'asc') { $imgArrow = "_up"; } } if (!preg_match("/_button/i", $column_name)) { $widget_args['name']=$column_name; $widget_args['sort'] = $imgArrow; $widget_args['start_link_wrapper'] = $this->start_link_wrapper; $widget_args['end_link_wrapper'] = $this->end_link_wrapper; $widget_args['subpanel_module'] = $this->subpanel_module; $widget_contents = $layout_manager->widgetDisplay($widget_args); $cell_width = empty($widget_args['width']) ? '' : $widget_args['width']; $this->xTemplate->assign('HEADER_CELL', $widget_contents); static $count; if (!isset($count)) { $count = 0; } else { $count++; } if ($col_count == 0 || $column_name == 'name') { $footable = 'data-toggle="true"'; } else { $footable = 'data-hide="phone"'; if ($col_count > 2) { $footable = 'data-hide="phone,phonelandscape"'; } if ($col_count > 4) { $footable = 'data-hide="phone,phonelandscape,tablet"'; } } $this->xTemplate->assign('FOOTABLE', $footable); $this->xTemplate->assign('CELL_COUNT', $count); $this->xTemplate->assign('CELL_WIDTH', $cell_width); $this->xTemplate->parse('dyn_list_view.header_cell'); } else { $buttons = true; } } ++$col_count; } if ($buttons) { $this->xTemplate->assign('FOOTABLE', ''); $this->xTemplate->assign('HEADER_CELL', " "); $this->xTemplate->assign('CELL_COUNT', $count); $this->xTemplate->assign('CELL_WIDTH', $cell_width); $this->xTemplate->parse('dyn_list_view.header_cell'); } } /** * @return void * @param unknown $seed * @param unknown $xTemplateSection * @param unknown $html_varName * @desc PUBLIC FUNCTION Handles List Views using seeds that extend SugarBean $XTemplateSection is the section in the XTemplate file that should be parsed usually main $html_VarName is the variable name used in the XTemplateFile e.g. TASK $seed is a seed there are two types of seeds one is a subclass of SugarBean, the other is a list usually created from a sugar bean using get_list if no XTemplate is set it will create a new XTemplate * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc.. * All Rights Reserved.. * Contributor(s): ______________________________________.. */ 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=array(); $access = get_workflow_admin_modules_for_user($current_user); for ($i = 0; $i < count($list); $i++) { if (!empty($access[$list[$i]->base_module])) { $tab[]=$list[$i]; } } $list = $tab; } if ($this->is_dynamic) { $this->processHeaderDynamic($xTemplateSection, $html_varName); $this->processListRows($list, $xTemplateSection, $html_varName); } else { $this->processSortArrows($html_varName); if ($isSugarBean) { $seed->parse_additional_headers($this->xTemplate, $xTemplateSection); } $this->xTemplateAssign('CHECKALL', SugarThemeRegistry::current()->getImage('blank', '', 1, 1, ".gif", '')); // Process the order by before processing the pro_nav. The pro_nav requires the order by values to be set $this->processOrderBy($html_varName); $this->processListRows($list, $xTemplateSection, $html_varName); } if ($this->display_header_and_footer) { $this->getAdditionalHeader(); if (!empty($this->header_title)) { echo get_form_header($this->header_title, $this->header_text, false); } } $this->xTemplate->out($xTemplateSection); if (isset($_SESSION['validation'])) { print base64_decode('PGEgaHJlZj0naHR0cDovL3d3dy5zdWdhcmNybS5jb20nPlBPV0VSRUQmbmJzcDtCWSZuYnNwO1NVR0FSQ1JNPC9hPg=='); } } /** * @deprecated * @return string */ public function getArrowStart() { global $log; $log->deprecated('ListView::getArrowStart is now deprecate and will be removed in a future release'); return ''; } /** * @param $upDown * @return string */ public function getArrowUpDownStart($upDown) { if ($upDown === '_down') { return ''; } elseif (($upDown === '_up')) { return ''; } else { return ''; } } /** * @deprecated * @return string */ public function getArrowEnd() { global $log; $log->deprecated('ListView::getArrowEnd is now deprecate and will be removed in a future release'); return ''; } /** * @deprecated * @param $upDown * @return string */ public function getArrowUpDownEnd($upDown) { global $log; $log->deprecated('ListView::getArrowUpDownEnd is now deprecate and will be removed in a future release'); return ''; } 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 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 array($orderBy,$desc); } public function processSortArrows($html_varName) { $this->xTemplateAssign("arrow_start", $this->getArrowStart()); list($orderBy, $desc) = $this->getOrderByInfo($html_varName); $imgArrow = "_up"; if ($desc) { $imgArrow = "_down"; } /** * @deprecated only used by legacy opportunites listview, nothing current. Leaving for BC */ if ($orderBy == 'amount') { $this->xTemplateAssign('amount_arrow', $imgArrow); } else { if ($orderBy == 'amount_usdollar') { $this->xTemplateAssign('amount_usdollar_arrow', $imgArrow); } else { $this->xTemplateAssign($orderBy.'_arrow', $imgArrow); } } $this->xTemplateAssign('arrow_end', $this->getArrowEnd()); } // this is where translation happens for dynamic list views public function loadListFieldDefs(&$subpanel_fields, &$child_focus) { $this->list_field_defs = $subpanel_fields; for ($i=0;$i < count($this->list_field_defs);$i++) { $list_field = $this->list_field_defs[$i]; $field_def = null; $key = ''; if (!empty($list_field['vname'])) { $key = $list_field['vname']; } else { if (isset($list_field['name']) && isset($child_focus->field_defs[$list_field['name']])) { $field_def = $child_focus->field_defs[$list_field['name']]; $key = $field_def['vname']; } } if (!empty($key)) { $list_field['label'] = translate($key, $child_focus->module_dir); $this->list_field_defs[$i]['label'] = preg_replace('/:$/', '', $list_field['label']); } else { $this->list_field_defs[$i]['label'] =' '; } } } 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; } }

"; //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, $this->records_per_page, $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 .= "\n

$select_link $export_link $delete_link $selected_objects_span"; } $html_text .= "

".$start_link." ".$previous_link." (".$start_record." - ".$end_record." ".$this->local_app_strings['LBL_LIST_OF']." ".$row_count.") ".$next_link." ".$end_link."

\n"; $html_text .= "