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

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

'; } 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 nvigation 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(); } } } function process_dynamic_listview($source_module, $sugarbean,$subpanel_def) { $this->source_module = $source_module; $this->subpanel_module = $subpanel_def->name; if(!isset($this->xTemplate)) $this->createXTemplate(); $html_var = $this->subpanel_module . "_CELL"; $list_data = $this->processUnionBeans($sugarbean,$subpanel_def, $html_var); $list = $list_data['list']; $parent_data = $list_data['parent_data']; if($subpanel_def->isCollection()) { $thepanel=$subpanel_def->get_header_panel_def(); } else { $thepanel=$subpanel_def; } $this->process_dynamic_listview_header($thepanel->get_module_name(), $thepanel, $html_var); $this->process_dynamic_listview_rows($list,$parent_data, 'dyn_list_view', $html_var,$subpanel_def); if($this->display_header_and_footer) { $this->getAdditionalHeader(); if(!empty($this->header_title)) { echo get_form_header($this->header_title, $this->header_text, false); } } $this->xTemplate->out('dyn_list_view'); if(isset($_SESSION['validation'])) { print base64_decode('PGEgaHJlZj0naHR0cDovL3d3dy5zdWdhcmNybS5jb20nPlBPV0VSRUQmbmJzcDtCWSZuYnNwO1NVR0FSQ1JNPC9hPg=='); } if(isset($list_data['query'])) { return ($list_data['query']); } } /** * @return void * @param unknown $data * @param unknown $xTemplateSection * @param unknown $html_varName * @desc INTERNAL FUNCTION handles the rows */ function process_dynamic_listview_rows($data,$parent_data, $xtemplateSection, $html_varName, $subpanel_def) { global $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); $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 retreive the is_fill_in_addition_fields //property $subpanel_list=array(); if($subpanel_def->isCollection()) { $subpanel_list=$subpanel_def->sub_subpanels; } else { $subpanel_list[]= $subpanel_def; } foreach($subpanel_list as $this_subpanel) { if($this_subpanel->is_fill_in_additional_fields()) { $fill_additional_fields[] = $this_subpanel->bean_name; $fill_additional_fields[$this_subpanel->bean_name] = true; } } if ( empty($data) ) { $this->xTemplate->assign("ROW_COLOR", 'oddListRow'); $thepanel=$subpanel_def; if($subpanel_def->isCollection()) $thepanel=$subpanel_def->get_header_panel_def(); $this->xTemplate->assign("COL_COUNT", count($thepanel->get_list_fields())); $this->xTemplate->parse($xtemplateSection.".nodata"); } while(list($aVal, $aItem) = each($data)) { $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; $this->xTemplate->assign("ROW_COLOR", $ROW_COLOR); $this->xTemplate->assign("BG_COLOR", $BG_COLOR); $layout_manager = $this->getLayoutManager(); $layout_manager->setAttribute('context','List'); $layout_manager->setAttribute('image_path',$this->local_image_path); $layout_manager->setAttribute('module_name', $subpanel_def->_instance_properties['module']); if(!empty($this->child_focus)) $layout_manager->setAttribute('related_module_name',$this->child_focus->module_dir); //AG$subpanel_data = $this->list_field_defs; //$bla = array_pop($subpanel_data); //select which sub-panel to display here, the decision will be made based on the type of //the sub-panel and panel in the bean being processed. if($subpanel_def->isCollection()) { $thepanel=$subpanel_def->sub_subpanels[$aItem->panel_name]; } else { $thepanel=$subpanel_def; } //get data source name $linked_field=$thepanel->get_data_source_name(); $linked_field_set=$thepanel->get_data_source_name(true); 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['DetailView'] = $aItem->ACLAccess('DetailView'); $list_field['ListView'] = $aItem->ACLAccess('ListView'); $list_field['EditView'] = $aItem->ACLAccess('EditView'); $list_field['Delete'] = $aItem->ACLAccess('Delete'); 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 compatibilty 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; } $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); } } else { // This handles the edit and remove buttons $widget_contents = $layout_manager->widgetDisplay($list_field); } static $count; if(!isset($count))$count = 0; else $count++; $this->xTemplate->assign('CELL_COUNT', $count); if ( empty($widget_contents) ) $widget_contents = ' '; $this->xTemplate->assign('CELL', $widget_contents); $this->xTemplate->parse($xtemplateSection.".row.cell"); } } $aItem->setupCustomFields($aItem->module_dir); $aItem->custom_fields->populateAllXTPL($this->xTemplate, 'detail', $html_varName, $fields); $count++; $this->xTemplate->parse($xtemplateSection.".row"); } $this->xTemplate->parse($xtemplateSection); } /**sets whether or not to display the xtemplate header and footer * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc. * All Rights Reserved. * Contributor(s): ______________________________________. */ function setDisplayHeaderAndFooter($bool) { $this->display_header_and_footer = $bool; } /**initializes ListView * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc. * All Rights Reserved. * Contributor(s): ______________________________________. */ function ListView() { if(!$this->initialized) { global $sugar_config; $this->records_per_page = $sugar_config['list_max_entries_per_page'] + 0; $this->initialized = true; global $app_strings, $currentModule; $this->local_theme = SugarThemeRegistry::current()->__toString(); $this->local_app_strings =$app_strings; $this->local_image_path = SugarThemeRegistry::current()->getImagePath(); $this->local_current_module = $currentModule; } } /**sets how many records should be displayed per page in the list view * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc. * All Rights Reserved. * Contributor(s): ______________________________________. */ function setRecordsPerPage($count) { $this->records_per_page = $count; } /**sets the header title */ function setHeaderTitle($value) { $this->header_title = $value; } /**sets the header text this is text thats appended to the header table and is usually used for the creation of buttons * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc. * All Rights Reserved. * Contributor(s): ______________________________________. */ function setHeaderText($value) { $this->header_text = $value; } /**sets the path for the XTemplate HTML file to be used this is only needed to be set if you are allowing ListView to create the XTemplate * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc. * All Rights Reserved. * Contributor(s): ______________________________________. */ function setXTemplatePath($value) { $this->xTemplatePath= $value; } /**this is a helper function for allowing ListView to create a new XTemplate it groups parameters that should be set into a single function * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc. * All Rights Reserved. * Contributor(s): ______________________________________. */ function initNewXTemplate($XTemplatePath, $modString, $imagePath = null) { $this->setXTemplatePath($XTemplatePath); if(isset($modString)) $this->setModStrings($modString); if(isset($imagePath)) $this->setImagePath($imagePath); } function getOrderBy($varName, $defaultOrderBy='', $force_sortorder='') { $sortBy = $this->getSessionVariable($varName, "ORDER_BY") ; if(empty($sortBy)) { $this->setUserVariable($varName, "ORDER_BY", $defaultOrderBy); $sortBy = $defaultOrderBy; } else { $this->setUserVariable($varName, "ORDER_BY", $sortBy); } if($sortBy == 'amount') { $sortBy = 'amount*1'; } if($sortBy == 'amount_usdollar') { $sortBy = 'amount_usdollar*1'; } $desc = $this->getSessionVariable($varName, $sortBy."S"); if(empty($desc)) $desc = false; if(isset($_REQUEST[$this->getSessionVariableName($varName, "ORDER_BY")])) $last = $this->getSessionVariable($varName, "OBL"); if(!empty($last) && $last == $sortBy) { $desc = !$desc; }else { $this->setSessionVariable($varName, "OBL", $sortBy); } $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($desc) { $this->query_orderby = $sortBy.' desc'; } else { $this->query_orderby = $sortBy.' asc'; } } } else { $this->query_orderby = $sortBy . ' ' . $force_sortorder; } }else { $this->query_orderby = ""; } $this->sortby = $sortBy; return $this->query_orderby; } /**sets the parameters dealing with the db * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc. * All Rights Reserved. * Contributor(s): ______________________________________. */ function setQuery($where, $limit, $orderBy, $varName, $allowOrderByOveride=true) { $this->query_where = $where; if($this->getSessionVariable("query", "where") != $where) { $this->query_where_has_changed = true; $this->setSessionVariable("query", "where", $where); } $this->query_limit = $limit; if(!$allowOrderByOveride) { $this->query_orderby = $orderBy; return; } $this->getOrderBy($varName, $orderBy); $this->setLocalSessionVariable($varName, "QUERY_WHERE", $where); //SETTING ORDER_BY FOR USE IN DETAILVIEW $this->setLocalSessionVariable($varName, "ORDER_BY_DETAIL", $this->query_orderby); } function displayArrow() { } /**sets the theme used only use if it is different from the global * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc. * All Rights Reserved. * Contributor(s): ______________________________________. */ function setTheme($theme) { $this->local_theme = $theme; if(isset($this->xTemplate))$this->xTemplate->assign("THEME", $this->local_theme); } /**sets the AppStrings used only use if it is different from the global * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc. * All Rights Reserved. * Contributor(s): ______________________________________. */ function setAppStrings($app_strings) { unset($this->local_app_strings); $this->local_app_strings = $app_strings; if(isset($this->xTemplate))$this->xTemplate->assign("APP", $this->local_app_strings); } /**sets the ModStrings used * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc. * All Rights Reserved. * Contributor(s): ______________________________________. */ function setModStrings($mod_strings) { unset($this->local_module_strings); $this->local_mod_strings = $mod_strings; if(isset($this->xTemplate))$this->xTemplate->assign("MOD", $this->local_mod_strings); } /**sets the ImagePath used * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc. * All Rights Reserved. * Contributor(s): ______________________________________. */ function setImagePath($image_path) { $this->local_image_path = $image_path; if(empty($this->local_image_path)) { $this->local_image_path = SugarThemeRegistry::get($this->local_theme)->getImagePath(); } if(isset($this->xTemplate))$this->xTemplate->assign("IMAGE_PATH", $this->local_image_path); } /**sets the currentModule only use if this is different from the global * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc. * All Rights Reserved. * Contributor(s): ______________________________________. */ function setCurrentModule($currentModule) { unset($this->local_current_module); $this->local_current_module = $currentModule; if(isset($this->xTemplate))$this->xTemplate->assign("MODULE_NAME", $this->local_current_module); } /**INTERNAL FUNCTION creates an XTemplate DO NOT CALL THIS THIS IS AN INTERNAL FUNCTION * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc. * All Rights Reserved. * Contributor(s): ______________________________________. */ function createXTemplate() { if(!isset($this->xTemplate)) { if(isset($this->xTemplatePath)) { $this->xTemplate = new XTemplate($this->xTemplatePath); $this->xTemplate->assign("APP", $this->local_app_strings); if(isset($this->local_mod_strings))$this->xTemplate->assign("MOD", $this->local_mod_strings); $this->xTemplate->assign("THEME", $this->local_theme); $this->xTemplate->assign("IMAGE_PATH", $this->local_image_path); $this->xTemplate->assign("MODULE_NAME", $this->local_current_module); } else { $GLOBALS['log']->error("NO XTEMPLATEPATH DEFINED CANNOT CREATE XTEMPLATE"); } } } /**sets the XTemplate telling ListView to use newXTemplate as its current XTemplate * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc. * All Rights Reserved. * Contributor(s): ______________________________________. */ function setXTemplate($newXTemplate) { $this->xTemplate = $newXTemplate; } /**returns the XTemplate * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc. * All Rights Reserved. * Contributor(s): ______________________________________. */ function getXTemplate() { return $this->xTemplate; } /**assigns a name value pair to the XTemplate * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc. * All Rights Reserved. * Contributor(s): ______________________________________. */ function xTemplateAssign($name, $value) { if(!isset($this->xTemplate)) { $this->createXTemplate(); } $this->xTemplate->assign($name, $value); } /**INTERNAL FUNCTION returns the offset first checking the querey then checking the session if the where clause has changed from the last time it returns 0 * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc. * All Rights Reserved. * Contributor(s): ______________________________________. */ function getOffset($localVarName) { if($this->query_where_has_changed || isset($GLOBALS['record_has_changed'])) { $this->setSessionVariable($localVarName,"offset", 0); } $offset = $this->getSessionVariable($localVarName,"offset"); if(isset($offset)) { return $offset; } return 0; } /**INTERNAL FUNCTION sets the offset in the session * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc. * All Rights Reserved. * Contributor(s): ______________________________________. */ function setOffset($localVarName, $value) { $this->setSessionVariable($localVarName, "offset", $value); } /**INTERNAL FUNCTION sets a session variable * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc. * All Rights Reserved. * Contributor(s): ______________________________________. */ function setSessionVariable($localVarName,$varName, $value) { $_SESSION[$this->local_current_module."_".$localVarName."_".$varName] = $value; } function setUserVariable($localVarName,$varName, $value) { if($this->is_dynamic || $localVarName == 'CELL')return; global $current_user; $current_user->setPreference($this->local_current_module."_".$localVarName."_".$varName, $value); } /**INTERNAL FUNCTION returns a session variable first checking the querey for it then checking the session * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc. * All Rights Reserved. * Contributor(s): ______________________________________. */ function getSessionVariable($localVarName,$varName) { //Set any variables pass in through request first if(isset($_REQUEST[$this->getSessionVariableName($localVarName, $varName)])) { $this->setSessionVariable($localVarName,$varName,$_REQUEST[$this->getSessionVariableName($localVarName, $varName)]); } if(isset($_SESSION[$this->getSessionVariableName($localVarName, $varName)])) { return $_SESSION[$this->getSessionVariableName($localVarName, $varName)]; } return ""; } function getUserVariable($localVarName, $varName) { global $current_user; if($this->is_dynamic || $localVarName == 'CELL')return; if(isset($_REQUEST[$this->getSessionVariableName($localVarName, $varName)])) { $this->setUserVariable($localVarName,$varName,$_REQUEST[$this->getSessionVariableName($localVarName, $varName)]); } return $current_user->getPreference($this->getSessionVariableName($localVarName, $varName)); } /** * @return void * @param unknown $localVarName * @param unknown $varName * @desc INTERNAL FUNCTION returns the session/query variable name * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc. * All Rights Reserved. * Contributor(s): ______________________________________.. */ function getSessionVariableName($localVarName,$varName) { return $this->local_current_module."_".$localVarName."_".$varName; } /** * @return void * @param unknown $seed * @param unknown $xTemplateSection * @param unknown $html_varName * @desc INTERNAL FUNCTION Handles List Views using seeds that extend SugarBean $XTemplateSection is the section in the XTemplate file that should be parsed usually main $html_VarName is the variable name used in the XTemplateFile e.g. TASK $seed is a seed that extends SugarBean * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc.. * All Rights Reserved.. * Contributor(s): ______________________________________.. */ function processSugarBean($xtemplateSection, $html_varName, $seed) { global $list_view_row_count; $current_offset = $this->getOffset($html_varName); $response = array(); //ADDING VCR CONTROL SugarVCR::erase($seed->module_dir); $params = array(); //$filter = array('id', 'full_name'); $filter=array(); $ret_array = $seed->create_new_list_query($this->query_orderby, $this->query_where, $filter, $params, 0, '', true, $seed, true); if(!is_array($params)) $params = array(); if(!isset($params['custom_select'])) $params['custom_select'] = ''; if(!isset($params['custom_from'])) $params['custom_from'] = ''; if(!isset($params['custom_where'])) $params['custom_where'] = ''; if(!isset($params['custom_order_by'])) $params['custom_order_by'] = ''; $main_query = $ret_array['select'] . $params['custom_select'] . $ret_array['from'] . $params['custom_from'] . $ret_array['where'] . $params['custom_where'] . $ret_array['order_by'] . $params['custom_order_by']; SugarVCR::store($seed->module_dir, $main_query); //ADDING VCR CONTROL if(empty($this->related_field_name)) { $response = $seed->get_list($this->query_orderby, $this->query_where, $current_offset, $this->query_limit); } else { $related_field_name = $this->related_field_name; $response = $seed->get_related_list($this->child_focus,$related_field_name, $this->query_orderby, $this->query_where, $current_offset, $this->query_limit); } $list = $response['list']; $row_count = $response['row_count']; $next_offset = $response['next_offset']; $previous_offset = $response['previous_offset']; if(!empty($response['current_offset'])) { $current_offset = $response['current_offset']; } $list_view_row_count = $row_count; $this->processListNavigation($xtemplateSection,$html_varName, $current_offset, $next_offset, $previous_offset, $row_count, null, null, empty($seed->column_fields) ? null : count($seed->column_fields)); return $list; } function processUnionBeans($sugarbean, $subpanel_def, $html_var = 'CELL') { $last_detailview_record = $this->getSessionVariable("detailview", "record"); if(!empty($last_detailview_record) && $last_detailview_record != $sugarbean->id){ $GLOBALS['record_has_changed'] = true; } $this->setSessionVariable("detailview", "record", $sugarbean->id); $current_offset = $this->getOffset($html_var); $module = isset($_REQUEST['module']) ? $_REQUEST['module'] : ''; $response = array(); $this->sort_order = 'asc'; if(isset($_REQUEST['sort_order'])) { $this->sort_order = $_REQUEST['sort_order']; } else { if(isset($subpanel_def->_instance_properties['sort_order'])) { $sort_order = $subpanel_def->_instance_properties['sort_order']; } if(isset($_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'])) { $this->sort_order = $_SESSION['last_sub' .$this->subpanel_module. '_order'] == 'asc' ? 'desc' : 'asc'; } else { $this->sort_order = $_SESSION['last_sub' .$this->subpanel_module. '_order']; } } elseif(isset($sort_order)) { $this->sort_order = $sort_order; } } if (isset($subpanel_def->_instance_properties['sort_by'])) { $this->query_orderby = $subpanel_def->_instance_properties['sort_by']; } else { $this->query_orderby = 'id'; } $this->getOrderBy($html_var,$this->query_orderby, $this->sort_order); $_SESSION['last_sub' .$this->subpanel_module. '_order'] = $this->sort_order; $_SESSION['last_sub' .$this->subpanel_module. '_url'] = $this->getBaseURL($html_var); // Bug 8139 - Correct Subpanel sorting on 'name', when subpanel sorting default is 'last_name, first_name' if (($this->sortby == 'name' || $this->sortby == 'last_name') && str_replace(' ', '', trim($subpanel_def->_instance_properties['sort_by'])) == 'last_name,first_name') { $this->sortby = 'last_name '.$this->sort_order.', first_name '; } if(!empty($this->response)){ $response =& $this->response; echo 'cached'; }else{ $response = SugarBean::get_union_related_list($sugarbean,$this->sortby, $this->sort_order, $this->query_where, $current_offset, -1,-1,$this->query_limit,$subpanel_def); $this->response =& $response; } $list = $response['list']; $row_count = $response['row_count']; $next_offset = $response['next_offset']; $previous_offset = $response['previous_offset']; if(!empty($response['current_offset']))$current_offset = $response['current_offset']; global $list_view_row_count; $list_view_row_count = $row_count; $this->processListNavigation('dyn_list_view', $html_var, $current_offset, $next_offset, $previous_offset, $row_count, $sugarbean,$subpanel_def); return array('list'=>$list, 'parent_data'=>$response['parent_data'], 'query'=>$response['query']); } function getBaseURL($html_varName) { static $cache = array(); if(!empty($cache[$html_varName]))return $cache[$html_varName]; $blockVariables = array('mass', 'uid', 'massupdate', 'delete', 'merge', 'selectCount','current_query_by_page'); if(!empty($this->base_URL)) { return $this->base_URL; } $baseurl = $_SERVER['PHP_SELF']; if(empty($baseurl)) { $baseurl = 'index.php'; } /*fixes an issue with deletes when doing a search*/ foreach(array_merge($_GET, $_POST) as $name=>$value) { //echo ("$name = $value
"); if(!empty($value) && $name != 'sort_order' //&& $name != ListView::getSessionVariableName($html_varName,"ORDER_BY") && $name != ListView::getSessionVariableName($html_varName,"offset") /*&& substr_count($name, "ORDER_BY")==0*/ && !in_array($name, $blockVariables)) { if(is_array($value)) { foreach($value as $valuename=>$valuevalue) { if(substr_count($baseurl, '?') > 0) $baseurl .= "&{$name}[]=".$valuevalue; else $baseurl .= "?{$name}[]=".$valuevalue; } } else { $value = urlencode($value); if(substr_count($baseurl, '?') > 0) { $baseurl .= "&$name=$value"; } else { $baseurl .= "?$name=$value"; } } } } if($_SERVER['REQUEST_METHOD'] == 'POST') { // at this point it is possible that the above foreach already executed resulting in double ?'s in the url if(substr_count($baseurl, '?') == 0) { $baseurl .= '?'; } if(isset($_REQUEST['action'])) $baseurl.= '&action='.$_REQUEST['action']; if(isset($_REQUEST['record'])) $baseurl .= '&record='.$_REQUEST['record']; if(isset($_REQUEST['module'])) $baseurl .= '&module='.$_REQUEST['module']; } $baseurl .= "&".ListView::getSessionVariableName($html_varName,"offset")."="; $cache[$html_varName] = $baseurl; return $baseurl; } /** * @return void * @param unknown $data * @param unknown $xTemplateSection * @param unknown $html_varName * @desc INTERNAL FUNCTION process the List Navigation * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc. * All Rights Reserved. * Contributor(s): ______________________________________.. */ function processListNavigation($xtemplateSection, $html_varName, $current_offset, $next_offset, $previous_offset, $row_count, $sugarbean=null, $subpanel_def=null, $col_count = 20) { global $export_module; global $sugar_config; global $current_user; global $currentModule; global $app_strings; $start_record = $current_offset + 1; if(!is_numeric($col_count)) $col_count = 20; if($row_count == 0) $start_record = 0; $end_record = $start_record + $this->records_per_page; // back up the the last page. if($end_record > $row_count+1) { $end_record = $row_count+1; } // Deterime 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 = $this->base_URL.$current_offset.$dynamic_url; $start_URL = $this->base_URL."0".$dynamic_url; $previous_URL = $this->base_URL.$previous_offset.$dynamic_url; $next_URL = $this->base_URL.$next_offset.$dynamic_url; $end_URL = $this->base_URL.'end'.$dynamic_url; if(!empty($this->start_link_wrapper)) { $current_URL = $this->start_link_wrapper.$current_URL.$this->end_link_wrapper; $start_URL = $this->start_link_wrapper.$start_URL.$this->end_link_wrapper; $previous_URL = $this->start_link_wrapper.$previous_URL.$this->end_link_wrapper; $next_URL = $this->start_link_wrapper.$next_URL.$this->end_link_wrapper; $end_URL = $this->start_link_wrapper.$end_URL.$this->end_link_wrapper; } $moduleString = "{$currentModule}_{$html_varName}_offset"; $moduleStringOrder = "{$currentModule}_{$html_varName}_ORDER_BY"; if($this->shouldProcess && !$this->multi_select_popup) { // check the checkboxes onload echo "\n"; $massUpdateRun = isset($_REQUEST['massupdate']) && $_REQUEST['massupdate'] == 'true'; $uids = empty($_REQUEST['uid']) || $massUpdateRun ? '' : $_REQUEST['uid']; $select_entire_list = isset($_REQUEST['select_entire_list']) && !$massUpdateRun ? $_REQUEST['select_entire_list'] : 0; echo "{$uids}\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 = "".SugarThemeRegistry::current()->getImage("start_off","aborder='0' align='absmiddle'",null,null,'.gif',$this->local_app_strings['LNK_LIST_START']).""; $previous_link = "".SugarThemeRegistry::current()->getImage("previous_off","border='0' align='absmiddle'",null,null,'.gif',$this->local_app_strings['LNK_LIST_PREVIOUS']).""; } else { if($this->multi_select_popup) {// nav links for multiselect popup, submit form to save checks. $start_link = "".SugarThemeRegistry::current()->getImage("start","border='0' align='absmiddle'",null,null,'.gif',$this->local_app_strings['LNK_LIST_START']).""; $previous_link = "".SugarThemeRegistry::current()->getImage("previous","border='0' align='absmiddle'",null,null,'.gif',$this->local_app_strings['LNK_LIST_PREVIOUS']).""; } elseif($this->shouldProcess) { $start_link = "".SugarThemeRegistry::current()->getImage("start","border='0' align='absmiddle'",null,null,'.gif',$this->local_app_strings['LNK_LIST_START']).""; $previous_link = "".SugarThemeRegistry::current()->getImage("previous","border='0' align='absmiddle'",null,null,'.gif',$this->local_app_strings['LNK_LIST_PREVIOUS']).""; } else { $onClick = ''; if(0 != preg_match('/javascript.*/', $start_URL)){ $onClick = "\"$start_URL;\""; }else{ $onClick ="'location.href=\"$start_URL\";'"; } $start_link = "".SugarThemeRegistry::current()->getImage("start","border='0' align='absmiddle'",null,null,'.gif',$this->local_app_strings['LNK_LIST_START']).""; $onClick = ''; if(0 != preg_match('/javascript.*/', $previous_URL)){ $onClick = "\"$previous_URL;\""; }else{ $onClick = "'location.href=\"$previous_URL\";'"; } $previous_link = "".SugarThemeRegistry::current()->getImage("previous","border='0' align='absmiddle'",null,null,'.gif',$this->local_app_strings['LNK_LIST_PREVIOUS']).""; } } if($last_offset <= $current_offset) { $end_link = "".SugarThemeRegistry::current()->getImage("end_off","border='0' align='absmiddle'",null,null,'.gif',$this->local_app_strings['LNK_LIST_END']).""; $next_link = "".SugarThemeRegistry::current()->getImage("next_off","aborder='0' align='absmiddle'",null,null,'.gif',$this->local_app_strings['LNK_LIST_NEXT']).""; } else { if($this->multi_select_popup) { // nav links for multiselect popup, submit form to save checks. $end_link = "".SugarThemeRegistry::current()->getImage("end","border='0' align='absmiddle'",null,null,'.gif',$this->local_app_strings['LNK_LIST_END']).""; if(!empty($sugar_config['disable_count_query'])) { $end_link = ''; } $next_link = "".SugarThemeRegistry::current()->getImage("next","border='0' align='absmiddle'",null,null,'.gif',$this->local_app_strings['LNK_LIST_NEXT']).""; } elseif($this->shouldProcess) { $end_link = "".SugarThemeRegistry::current()->getImage("end","border='0' align='absmiddle'",null,null,'.gif',$this->local_app_strings['LNK_LIST_END']).""; $next_link = "".SugarThemeRegistry::current()->getImage("next","border='0' align='absmiddle'",null,null,'.gif',$this->local_app_strings['LNK_LIST_NEXT']).""; } else { $onClick = ''; if(0 != preg_match('/javascript.*/', $next_URL)){ $onClick = "\"$next_URL;\""; }else{ $onClick ="'location.href=\"$next_URL\";'"; } $next_link = "".SugarThemeRegistry::current()->getImage("next","border='0' align='absmiddle'",null,null,'.gif',$this->local_app_strings['LNK_LIST_NEXT']).""; $onClick = ''; if(0 != preg_match('/javascript.*/', $end_URL)){ $onClick = "\"$end_URL;\""; }else{ $onClick = "'location.href=\"$end_URL\";'"; } $end_link = "".SugarThemeRegistry::current()->getImage("end","border='0' align='absmiddle'",null,null,'.gif',$this->local_app_strings['LNK_LIST_END']).""; } } $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) { $select_link = "".$this->local_app_strings['LBL_LINK_SELECT']." ".SugarThemeRegistry::current()->getImage('MoreDetail', 'border=0', 11, 7, '.png', $app_strings['LBL_MOREDETAIL']).""; } else { $select_link = " "; } // put overlib strings into functions to avoid backslash plague! $export_link = ''; if($this->show_delete_button) { $delete_link = ''; } else { $delete_link = ' '; } $admin = new Administration(); $admin->retrieveSettings('system'); $user_merge = $current_user->getPreference('mailmerge_on'); if($user_merge == 'on' && isset($admin->settings['system_mailmerge_on']) && $admin->settings['system_mailmerge_on']) { echo ""; $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 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; } $sort_URL_base = $this->base_URL. "&".$this->getSessionVariableName($html_varName,"ORDER_BY")."="; if($sort_URL_base !== "") { $this->xTemplate->assign("ORDER_BY", $sort_URL_base); return $sort_URL_base; } else { return ''; } } function getAdditionalHeader() { } /** * @return void * @param unknown $data * @param unknown $xTemplateSection * @param unknown $html_varName * @desc INTERNAL FUNCTION handles the rows * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc. * All Rights Reserved. * Contributor(s): ______________________________________.. */ function processListRows($data, $xtemplateSection, $html_varName) { global $odd_bg; global $even_bg; global $hilite_bg; global $app_strings, $sugar_version, $sugar_config; global $currentModule; static $overlib_included; if(!$overlib_included) { echo getVersionedScript('cache/include/javascript/sugar_grp_overlib.js'). ' '; $overlib_included = true; } $this->xTemplate->assign('BG_HILITE', $hilite_bg); $this->xTemplate->assign('CHECKALL', SugarThemeRegistry::current()->getImage('blank', '', 1, 1, ".gif", '')); //$this->xTemplate->assign("BG_CLICK", $click_bg); $oddRow = true; $count = 0; reset($data); //GETTING OFFSET $offset = $this->getOffset($html_varName); $timeStamp = $this->unique_id(); $_SESSION[$html_varName."_FROM_LIST_VIEW"] = $timeStamp; $associated_row_data = array(); //mail merge list $mergeList = array(); $module = ''; //todo what is this? It is using an array as a boolean while(list($aVal, $aItem) = each($data)) { if(isset($this->data_array)) { $fields = $this->data_array; } else { $aItem->check_date_relationships_load(); $fields = $aItem->get_list_view_data(); } if(is_object($aItem)) { // cn: bug 5349 //add item id to merge list, if the button is clicked $mergeList[] = $aItem->id; if(empty($module)) { $module = $aItem->module_dir; } } //ADD OFFSET TO ARRAY $fields['OFFSET'] = ($offset + $count + 1); $fields['STAMP'] = $timeStamp; if($this->shouldProcess) { $prerow = ''; if(!isset($this->data_array)) { $prerow .= ""; } $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']].''; } //fixes bug for IE where empty list view rows causes IE to not display bottom border if(isset($fields['DESCRIPTION']) && empty($fields['DESCRIPTION'])) $fields['DESCRIPTION'] = " "; if(isset($fields['LIST_ORDER']) && empty($fields['LIST_ORDER'])) $fields['LIST_ORDER'] = " "; $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); } function getLayoutManager() { require_once('include/generic/LayoutManager.php'); if($this->layout_manager == null) { $this->layout_manager = new LayoutManager(); } return $this->layout_manager; } function process_dynamic_listview_header($source_module, $subpanel_def, $html_var = 'CELL') { $layout_manager = $this->getLayoutManager(); $layout_manager->setAttribute('order_by_link',$this->processOrderBy($html_var)); $layout_manager->setAttribute('context','HeaderCell'); $layout_manager->setAttribute('image_path',$this->local_image_path); $layout_manager->setAttribute('html_varName',$html_var); $layout_manager->setAttribute('module_name', $source_module); list($orderBy,$desc) = $this->getOrderByInfo($html_var); if($orderBy == 'amount*1') { $orderBy= 'amount'; } 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"; } } $widget_args['name']=$column_name; $widget_args['sort'] = $imgArrow; $widget_args['start_link_wrapper'] = $this->start_link_wrapper; $widget_args['end_link_wrapper'] = $this->end_link_wrapper; $widget_args['subpanel_module'] = $this->subpanel_module; $widget_contents = $layout_manager->widgetDisplay($widget_args); $cell_width = empty($widget_args['width']) ? '' : $widget_args['width']; $this->xTemplate->assign('HEADER_CELL', $widget_contents); static $count; if(!isset($count))$count = 0; else $count++; $this->xTemplate->assign('CELL_COUNT', $count); $this->xTemplate->assign('CELL_WIDTH', $cell_width); $this->xTemplate->parse('dyn_list_view.header_cell'); } } } /** * @return void * @param unknown $seed * @param unknown $xTemplateSection * @param unknown $html_varName * @desc PUBLIC FUNCTION Handles List Views using seeds that extend SugarBean $XTemplateSection is the section in the XTemplate file that should be parsed usually main $html_VarName is the variable name used in the XTemplateFile e.g. TASK $seed is a seed there are two types of seeds one is a subclass of SugarBean, the other is a list usually created from a sugar bean using get_list if no XTemplate is set it will create a new XTemplate * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc.. * All Rights Reserved.. * Contributor(s): ______________________________________.. */ function processListViewTwo($seed, $xTemplateSection, $html_varName) { global $current_user; if(!isset($this->xTemplate)) { $this->createXTemplate(); } $isSugarBean = is_subclass_of($seed, "SugarBean"); $list = null; if($isSugarBean) { $list = $this->processSugarBean($xTemplateSection, $html_varName, $seed); } else { $list = $seed; } if (is_object($seed) && isset($seed->object_name) && $seed->object_name == 'WorkFlow') { $tab=array(); $access = get_workflow_admin_modules_for_user($current_user); for ($i = 0; $i < count($list); $i++) { if(!empty($access[$list[$i]->base_module])){ $tab[]=$list[$i]; } } $list = $tab; } if($this->is_dynamic) { $this->processHeaderDynamic($xTemplateSection,$html_varName); $this->processListRows($list,$xTemplateSection, $html_varName); } else { $this->processSortArrows($html_varName); if($isSugarBean) { $seed->parse_additional_headers($this->xTemplate, $xTemplateSection); } $this->xTemplateAssign('CHECKALL', SugarThemeRegistry::current()->getImage('blank', '', 1, 1, ".gif", '')); // Process the order by before processing the pro_nav. The pro_nav requires the order by values to be set $this->processOrderBy($html_varName); $this->processListRows($list,$xTemplateSection, $html_varName); } if($this->display_header_and_footer) { $this->getAdditionalHeader(); if(!empty($this->header_title)) { echo get_form_header($this->header_title, $this->header_text, false); } } $this->xTemplate->out($xTemplateSection); if(isset($_SESSION['validation'])) { print base64_decode('PGEgaHJlZj0naHR0cDovL3d3dy5zdWdhcmNybS5jb20nPlBPV0VSRUQmbmJzcDtCWSZuYnNwO1NVR0FSQ1JNPC9hPg=='); } } function getArrowStart() { $imgFileParts = pathinfo(SugarThemeRegistry::current()->getImageURL("arrow.gif")); return " pngSupport ? "png" : "gif" ); if (!isset($upDown) || empty($upDown)) { $upDown = ""; } return " getImageURL("arrow.gif")); list($width,$height) = ListView::getArrowImageSize(); return '.'.$imgFileParts['extension']."' width='$width' height='$height' align='absmiddle' alt=".translate('LBL_SORT').">"; } function getArrowUpDownEnd($upDown) { if (!isset($upDown) || empty($upDown)) { $upDown = ""; } $imgFileParts = pathinfo(SugarThemeRegistry::current()->getImageURL("arrow{$upDown}.gif")); list($width,$height) = ListView::getArrowUpDownImageSize($upDown); //get the right alt tag for the sort $sortStr = translate('LBL_ALT_SORT'); if($upDown == '_down'){ $sortStr = translate('LBL_ALT_SORT_DESC'); }elseif($upDown == '_up'){ $sortStr = translate('LBL_ALT_SORT_ASC'); } return " width='$width' height='$height' align='absmiddle' alt='$sortStr'>"; } function getArrowImageSize() { // jbasicChartDashletsExpColust get the non-sort image's size.. the up and down have be the same. $image = SugarThemeRegistry::current()->getImageURL("arrow.gif",false); $cache_key = 'arrow_size.'.$image; // Check the cache $result = sugar_cache_retrieve($cache_key); if(!empty($result)) return $result; // No cache hit. Calculate the value and return. $result = getimagesize($image); sugar_cache_put($cache_key, $result); return $result; } function getArrowUpDownImageSize($upDown) { // just get the non-sort image's size.. the up and down have be the same. $image = SugarThemeRegistry::current()->getImageURL("arrow{$upDown}.gif",false); $cache_key = 'arrowupdown_size.'.$image; // Check the cache $result = sugar_cache_retrieve($cache_key); if(!empty($result)) return $result; // No cache hit. Calculate the value and return. $result = getimagesize($image); sugar_cache_put($cache_key, $result); return $result; } function getOrderByInfo($html_varName) { $orderBy = $this->getSessionVariable($html_varName, "OBL"); $desc = $this->getSessionVariable($html_varName, $orderBy.'S'); $orderBy = str_replace('.', '_', $orderBy); return array($orderBy,$desc); } function processSortArrows($html_varName) { $this->xTemplateAssign("arrow_start", $this->getArrowStart()); list($orderBy,$desc) = $this->getOrderByInfo($html_varName); $imgArrow = "_down"; if($desc) { $imgArrow = "_up"; } /** * @deprecated only used by legacy opportunites listview, nothing current. Leaving for BC */ if($orderBy == 'amount*1') { $this->xTemplateAssign('amount_arrow', $imgArrow); } else if($orderBy == 'amount_usdollar*1') { $this->xTemplateAssign('amount_usdollar_arrow', $imgArrow); } else { $this->xTemplateAssign($orderBy.'_arrow', $imgArrow); } $this->xTemplateAssign('arrow_end', $this->getArrowEnd()); } // this is where translation happens for dynamic list views function loadListFieldDefs(&$subpanel_fields,&$child_focus) { $this->list_field_defs = $subpanel_fields; for($i=0;$i < count($this->list_field_defs);$i++) { $list_field = $this->list_field_defs[$i]; $field_def = null; $key = ''; if(!empty($list_field['vname'])) { $key = $list_field['vname']; } else if(isset($list_field['name']) && isset($child_focus->field_defs[$list_field['name']])) { $field_def = $child_focus->field_defs[$list_field['name']]; $key = $field_def['vname']; } if(!empty($key)) { $list_field['label'] = translate($key,$child_focus->module_dir); $this->list_field_defs[$i]['label'] = preg_replace('/:$/','',$list_field['label']); } else { $this->list_field_defs[$i]['label'] =' '; } } } function unique_id() { return sugar_microtime(); } /**INTERNAL FUNCTION sets a session variable keeping it local to the listview not the current_module * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc. * All Rights Reserved. * Contributor(s): ______________________________________. */ function setLocalSessionVariable($localVarName,$varName, $value) { $_SESSION[$localVarName."_".$varName] = $value; } /**INTERNAL FUNCTION returns a session variable that is local to the listview, not the current_module * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc. * All Rights Reserved. * Contributor(s): ______________________________________. */ function getLocalSessionVariable($localVarName,$varName) { if(isset($_SESSION[$localVarName."_".$varName])) { return $_SESSION[$localVarName."_".$varName]; } else{ return ""; } } /* Set to true if you want Additional Details to appear in the listview */ function setAdditionalDetails($value = true, $function = '') { if(!empty($function)) $this->additionalDetailsFunction = $function; $this->_additionalDetails = $value; } } ?> "; //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 .= "\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 .= "