2 if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
3 /*********************************************************************************
4 * SugarCRM Community Edition is a customer relationship management program developed by
5 * SugarCRM, Inc. Copyright (C) 2004-2012 SugarCRM Inc.
7 * This program is free software; you can redistribute it and/or modify it under
8 * the terms of the GNU Affero General Public License version 3 as published by the
9 * Free Software Foundation with the addition of the following permission added
10 * to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
11 * IN WHICH THE COPYRIGHT IS OWNED BY SUGARCRM, SUGARCRM DISCLAIMS THE WARRANTY
12 * OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
14 * This program is distributed in the hope that it will be useful, but WITHOUT
15 * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
16 * FOR A PARTICULAR PURPOSE. See the GNU Affero General Public License for more
19 * You should have received a copy of the GNU Affero General Public License along with
20 * this program; if not, see http://www.gnu.org/licenses or write to the Free
21 * Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
24 * You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
25 * SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
27 * The interactive user interfaces in modified source and object code versions
28 * of this program must display Appropriate Legal Notices, as required under
29 * Section 5 of the GNU Affero General Public License version 3.
31 * In accordance with Section 7(b) of the GNU Affero General Public License version 3,
32 * these Appropriate Legal Notices must retain the display of the "Powered by
33 * SugarCRM" logo. If the display of the logo is not reasonably feasible for
34 * technical reasons, the Appropriate Legal Notices must display the words
35 * "Powered by SugarCRM".
36 ********************************************************************************/
41 require_once('include/ListView/ListViewData.php');
42 require_once('include/MassUpdate.php');
44 class ListViewDisplay {
45 static $listViewCounter = 0;
47 var $show_mass_update_form = false;
48 var $show_action_dropdown = true;
52 var $multi_select_popup;
56 var $multiSelect = true;
57 var $mailMerge = true;
58 var $should_process = true;
59 var $show_plus = false;
61 * Used in view.popup.php. Sometimes there are fields on the search form that are not referenced in the listviewdefs. If this
62 * is the case, then the filterFields will be set and the related fields will not be referenced when calling create_new_list_query.
64 var $mergeDisplayColumns = false;
65 public $actionsMenuExtraItems = array();
71 function ListViewDisplay() {
72 $this->lvd = new ListViewData();
73 $this->searchColumns = array () ;
75 function shouldProcess($moduleDir){
77 $sessionSearchQuery = "{$moduleDir}2_QUERY_QUERY";
78 if (!empty($_SESSION[$sessionSearchQuery])) {
81 if(!empty($GLOBALS['sugar_config']['save_query']) && $GLOBALS['sugar_config']['save_query'] == 'populate_only'){
82 if(empty($GLOBALS['displayListView'])
83 && (!empty($_REQUEST['clear_query'])
84 || $_REQUEST['module'] == $moduleDir
85 && ((empty($_REQUEST['query']) || $_REQUEST['query'] == 'MSI' )
87 $_SESSION['last_search_mod'] = $_REQUEST['module'] ;
88 $this->should_process = false;
92 $this->should_process = true;
98 * @param seed SugarBean Seed SugarBean to use
99 * @param file File Template file to use
100 * @param string $where
101 * @param offset:0 int offset to start at
102 * @param int:-1 $limit
103 * @param string[]:array() $filter_fields
104 * @param array:array() $params
105 * Potential $params are
106 $params['distinct'] = use distinct key word
107 $params['include_custom_fields'] = (on by default)
108 $params['massupdate'] = true by default;
109 $params['handleMassupdate'] = true by default, have massupdate.php handle massupdates?
110 * @param string:'id' $id_field
112 function setup($seed, $file, $where, $params = array(), $offset = 0, $limit = -1, $filter_fields = array(), $id_field = 'id') {
113 $this->should_process = true;
114 if(isset($seed->module_dir) && !$this->shouldProcess($seed->module_dir)){
117 if(isset($params['export'])) {
118 $this->export = $params['export'];
120 if(!empty($params['multiSelectPopup'])) {
121 $this->multi_select_popup = $params['multiSelectPopup'];
123 if(!empty($params['massupdate']) && $params['massupdate'] != false) {
124 $this->show_mass_update_form = true;
125 $this->mass = $this->getMassUpdate();
126 $this->mass->setSugarBean($seed);
127 if(!empty($params['handleMassupdate']) || !isset($params['handleMassupdate'])) {
128 $this->mass->handleMassUpdate();
133 $filter_fields = $this->setupFilterFields($filter_fields);
135 $data = $this->lvd->getListViewData($seed, $where, $offset, $limit, $filter_fields, $params, $id_field);
137 foreach($this->displayColumns as $columnName => $def)
139 $seedName = strtolower($columnName);
140 if(!empty($this->lvd->seed->field_defs[$seedName])){
141 $seedDef = $this->lvd->seed->field_defs[$seedName];
144 if(empty($this->displayColumns[$columnName]['type'])){
145 if(!empty($seedDef['type'])){
146 $this->displayColumns[$columnName]['type'] = (!empty($seedDef['custom_type']))?$seedDef['custom_type']:$seedDef['type'];
148 $this->displayColumns[$columnName]['type'] = '';
152 if(!empty($seedDef['options'])){
153 $this->displayColumns[$columnName]['options'] = $seedDef['options'];
157 if($this->displayColumns[$columnName]['type'] == 'html') {
158 $cField = $this->seed->custom_fields;
159 if(isset($cField) && isset($cField->bean->$seedName)) {
160 $seedName2 = strtoupper($columnName);
161 $htmlDisplay = html_entity_decode($cField->bean->$seedName);
163 while($count < count($data['data'])) {
164 $data['data'][$count][$seedName2] = &$htmlDisplay;
170 //Bug 40511, make sure relate fields have the correct module defined
171 if ($this->displayColumns[$columnName]['type'] == "relate" && !empty($seedDef['link']) && empty( $this->displayColumns[$columnName]['module']))
173 $link = $seedDef['link'];
174 if (!empty($this->lvd->seed->field_defs[$link]) && !empty($this->lvd->seed->field_defs[$seedDef['link']]['module']))
176 $this->displayColumns[$columnName]['module'] = $this->lvd->seed->field_defs[$seedDef['link']]['module'];
180 if (!empty($seedDef['sort_on'])) {
181 $this->displayColumns[$columnName]['orderBy'] = $seedDef['sort_on'];
185 // Merge the two arrays together, making sure the seedDef doesn't override anything explicitly set in the displayColumns array.
186 $this->displayColumns[$columnName] = $this->displayColumns[$columnName] + $seedDef;
189 //C.L. Bug 38388 - ensure that ['id'] is set for related fields
190 if(!isset($this->displayColumns[$columnName]['id']) && isset($this->displayColumns[$columnName]['id_name'])) {
191 $this->displayColumns[$columnName]['id'] = strtoupper($this->displayColumns[$columnName]['id_name']);
195 $this->process($file, $data, $seed->object_name);
199 function setupFilterFields($filter_fields = array())
201 // create filter fields based off of display columns
202 if(empty($filter_fields) || $this->mergeDisplayColumns) {
203 foreach($this->displayColumns as $columnName => $def) {
205 $filter_fields[strtolower($columnName)] = true;
207 if(isset($this->seed->field_defs[strtolower($columnName)]['type']) &&
208 strtolower($this->seed->field_defs[strtolower($columnName)]['type']) == 'currency' &&
209 isset($this->seed->field_defs['currency_id'])) {
210 $filter_fields['currency_id'] = true;
213 if(!empty($def['related_fields'])) {
214 foreach($def['related_fields'] as $field) {
215 //id column is added by query construction function. This addition creates duplicates
216 //and causes issues in oracle. #10165
217 if ($field != 'id') {
218 $filter_fields[$field] = true;
222 if (!empty($this->seed->field_defs[strtolower($columnName)]['db_concat_fields'])) {
223 foreach($this->seed->field_defs[strtolower($columnName)]['db_concat_fields'] as $index=>$field){
224 if(!isset($filter_fields[strtolower($field)]) || !$filter_fields[strtolower($field)])
226 $filter_fields[strtolower($field)] = true;
231 foreach ($this->searchColumns as $columnName => $def )
233 $filter_fields[strtolower($columnName)] = true;
238 return $filter_fields;
243 * Any additional processing
244 * @param file File template file to use
245 * @param data array row data
246 * @param html_var string html string to be passed back and forth
248 function process($file, $data, $htmlVar) {
249 $this->rowCount = count($data['data']);
250 $this->moduleString = $data['pageData']['bean']['moduleDir'] . '2_' . strtoupper($htmlVar) . '_offset';
254 * Display the listview
255 * @return string ListView contents
257 public function display()
259 if (!$this->should_process) {
264 if ($this->show_mass_update_form) {
265 $str = $this->mass->getDisplayMassUpdateForm(true, $this->multi_select_popup).$this->mass->getMassUpdateFormHeader($this->multi_select_popup);
271 * Display the select link
272 * @return string select link html
273 * @param echo Bool set true if you want it echo'd, set false to have contents returned
275 function buildSelectLink($id = 'select_link', $total=0, $pageTotal=0, $location="top") {
282 if (!empty($GLOBALS['sugar_config']['disable_count_query']) && $GLOBALS['sugar_config']['disable_count_query'] === true && $total > $pageTotal) {
283 $this->show_plus = true;
284 $total_label = $pageTotal.'+';
287 $total_label = $total;
290 $close_inline_img = SugarThemeRegistry::current()->getImage('close_inline', 'border=0', null, null, ".gif", $app_strings['LBL_CLOSEINLINE']);
292 "<input title=\"".$app_strings['LBL_SELECT_ALL_TITLE']."\" type='checkbox' class='checkbox massall' name='massall' id='massall_".$location."' value='' onclick='sListView.check_all(document.MassUpdate, \"mass[]\", this.checked);' /><a id='$id' href='javascript: void(0);'></a>",
293 "<a name='thispage' id='button_select_this_page_".$location."' class='menuItem' onmouseover='hiliteItem(this,\"yes\");' onmouseout='unhiliteItem(this);' onclick='if (document.MassUpdate.select_entire_list.value==1){document.MassUpdate.select_entire_list.value=0;sListView.check_all(document.MassUpdate, \"mass[]\", true, $pageTotal)}else {sListView.check_all(document.MassUpdate, \"mass[]\", true)};' href='#'>{$app_strings['LBL_LISTVIEW_OPTION_CURRENT']} ({$pageTotal})‎</a>",
294 "<a name='selectall' id='button_select_all_".$location."' class='menuItem' onmouseover='hiliteItem(this,\"yes\");' onmouseout='unhiliteItem(this);' onclick='sListView.check_entire_list(document.MassUpdate, \"mass[]\",true,{$total});' href='#'>{$app_strings['LBL_LISTVIEW_OPTION_ENTIRE']} ({$total_label})‎</a>",
295 "<a name='deselect' id='button_deselect_".$location."' class='menuItem' onmouseover='hiliteItem(this,\"yes\");' onmouseout='unhiliteItem(this);' onclick='sListView.clear_all(document.MassUpdate, \"mass[]\", false);' href='#'>{$app_strings['LBL_LISTVIEW_NONE']}</a>",
299 'class' => 'clickMenu selectmenu',
300 'id' => 'selectLink',
301 'buttons' => $menuItems
307 * Display the actions link
309 * @param string $id link id attribute, defaults to 'actions_link'
310 * @return string HTML source
312 protected function buildActionsLink($id = 'actions_link', $location = 'top')
315 $closeText = SugarThemeRegistry::current()->getImage('close_inline', 'border=0', null, null, ".gif", $app_strings['LBL_CLOSEINLINE']);
316 $moreDetailImage = SugarThemeRegistry::current()->getImageURL('MoreDetail.png');
317 $menuItems = array();
320 if ( ACLController::checkAccess($this->seed->module_dir,'delete',true) && $this->delete )
321 $menuItems[] = $this->buildDeleteLink($location);
324 $menuItems[] = $this->buildComposeEmailLink($this->data['pageData']['offsets']['total'], $location);
326 $mass = $this->getMassUpdate();
327 $mass->setSugarBean($this->seed);
328 if ( ( ACLController::checkAccess($this->seed->module_dir,'edit',true) && ACLController::checkAccess($this->seed->module_dir,'massupdate',true) ) && $this->showMassupdateFields && $mass->doMassUpdateFieldsExistForFocus() )
329 $menuItems[] = $this->buildMassUpdateLink($location);
331 if ( $this->mailMerge )
332 $menuItems[] = $this->buildMergeLink(null, $location);
333 if ( $this->mergeduplicates )
334 $menuItems[] = $this->buildMergeDuplicatesLink($location);
335 // add to target list
336 if ( $this->targetList && ACLController::checkAccess('ProspectLists','edit',true) )
337 $menuItems[] = $this->buildTargetList($location);
339 if ( ACLController::checkAccess($this->seed->module_dir,'export',true) && $this->export )
340 $menuItems[] = $this->buildExportLink($location);
342 foreach ( $this->actionsMenuExtraItems as $item )
343 $menuItems[] = $item;
346 'class' => 'clickMenu selectActions fancymenu',
347 'id' => 'selectActions',
348 'name' => 'selectActions',
349 'buttons' => $menuItems
355 * Builds the export link
357 * @return string HTML
359 protected function buildExportLink($loc = 'top')
362 return "<a href='javascript:void(0)' id=\"export_listview_". $loc ." \" onclick=\"return sListView.send_form(true, '{$this->seed->module_dir}', 'index.php?entryPoint=export','{$app_strings['LBL_LISTVIEW_NO_SELECTED']}')\">{$app_strings['LBL_EXPORT']}</a>";
366 * Builds the massupdate link
368 * @return string HTML
370 protected function buildMassUpdateLink($loc = 'top')
374 $onClick = "document.getElementById('massupdate_form').style.display = ''; var yLoc = YAHOO.util.Dom.getY('massupdate_form'); scroll(0,yLoc);";
375 return "<a href='javascript:void(0)' id=\"massupdate_listview_". $loc ."\" onclick=\"$onClick\">{$app_strings['LBL_MASS_UPDATE']}</a>";
380 * Builds the compose email link
382 * @return string HTML
384 protected function buildComposeEmailLink($totalCount, $loc = 'top')
386 global $app_strings,$dictionary;
388 if (!is_array($this->seed->field_defs)) {
391 $foundEmailField = false;
392 // Search for fields that look like an email address
393 foreach ($this->seed->field_defs as $field) {
394 if(isset($field['type'])&&$field['type']=='link'
395 &&isset($field['relationship'])&&isset($dictionary[$this->seed->object_name]['relationships'][$field['relationship']])
396 &&$dictionary[$this->seed->object_name]['relationships'][$field['relationship']]['rhs_module']=='EmailAddresses') {
397 $foundEmailField = true;
401 if (!$foundEmailField) {
406 $userPref = $GLOBALS['current_user']->getPreference('email_link_type');
407 $defaultPref = $GLOBALS['sugar_config']['email_default_client'];
411 $client = $defaultPref;
413 if($client == 'sugar')
414 $script = "<a href='javascript:void(0)' " .
415 "id=\"composeemail_listview_". $loc ."\"".
416 'onclick="return sListView.send_form_for_emails(true, \''."Emails".'\', \'index.php?module=Emails&action=Compose&ListView=true\',\''.$app_strings['LBL_LISTVIEW_NO_SELECTED'].'\', \''.$this->seed->module_dir.'\', \''.$totalCount.'\', \''.$app_strings['LBL_LISTVIEW_LESS_THAN_TEN_SELECT'].'\')">' .
417 $app_strings['LBL_EMAIL_COMPOSE'] . '</a>';
419 $script = "<a href='javascript:void(0)' " .
420 "id=\"composeemail_listview_". $loc ."\"".
421 "onclick=\"return sListView.use_external_mail_client('{$app_strings['LBL_LISTVIEW_NO_SELECTED']}', '{$_REQUEST['module']}');\">" .
422 $app_strings['LBL_EMAIL_COMPOSE'] . '</a>';
427 * Builds the delete link
429 * @return string HTML
431 protected function buildDeleteLink($loc = 'top')
434 return "<a href='javascript:void(0)' id=\"delete_listview_". $loc ."\" onclick=\"return sListView.send_mass_update('selected', '{$app_strings['LBL_LISTVIEW_NO_SELECTED']}', 1)\">{$app_strings['LBL_DELETE_BUTTON_LABEL']}</a>";
437 * Display the selected object span object
439 * @return string select object span
441 function buildSelectedObjectsSpan($echo = true, $total=0) {
444 $displayStyle = $total > 0 ? "" : "display: none;";
445 $selectedObjectSpan = "<span style='$displayStyle' id='selectedRecordsTop'>{$app_strings['LBL_LISTVIEW_SELECTED_OBJECTS']}<input style='border: 0px; background: transparent; font-size: inherit; color: inherit' type='text' id='selectCountTop' readonly name='selectCount[]' value='{$total}' /></span>";
447 return $selectedObjectSpan;
450 * Builds the mail merge link
451 * The link can be disabled by setting module level duplicate_merge property to false
452 * in the moudle's vardef file.
454 * @return string HTML
456 protected function buildMergeDuplicatesLink($loc = 'top')
458 global $app_strings, $dictionary;
461 $return_string.= isset($_REQUEST['module']) ? "&return_module={$_REQUEST['module']}" : "";
462 $return_string.= isset($_REQUEST['action']) ? "&return_action={$_REQUEST['action']}" : "";
463 $return_string.= isset($_REQUEST['record']) ? "&return_id={$_REQUEST['record']}" : "";
464 //need delete and edit access.
465 if (!(ACLController::checkAccess($this->seed->module_dir, 'edit', true)) or !(ACLController::checkAccess($this->seed->module_dir, 'delete', true))) {
469 if (isset($dictionary[$this->seed->object_name]['duplicate_merge']) && $dictionary[$this->seed->object_name]['duplicate_merge']==true ) {
470 return "<a href='javascript:void(0)' ".
471 "id='mergeduplicates_listview_". $loc ."'".
472 "onclick='if (sugarListView.get_checks_count()> 1) {sListView.send_form(true, \"MergeRecords\", \"index.php\", \"{$app_strings['LBL_LISTVIEW_NO_SELECTED']}\", \"{$this->seed->module_dir}\",\"$return_string\");} else {alert(\"{$app_strings['LBL_LISTVIEW_TWO_REQUIRED']}\");return false;}'>".
473 $app_strings['LBL_MERGE_DUPLICATES'].'</a>';
479 * Builds the mail merge link
481 * @return string HTML
483 protected function buildMergeLink(array $modules_array = null, $loc = 'top')
485 if ( empty($modules_array) ) {
486 require('modules/MailMerge/modules_array.php');
488 global $current_user, $app_strings;
490 $admin = new Administration();
491 $admin->retrieveSettings('system');
492 $user_merge = $current_user->getPreference('mailmerge_on');
493 $module_dir = (!empty($this->seed->module_dir) ? $this->seed->module_dir : '');
496 if ($user_merge == 'on' && isset($admin->settings['system_mailmerge_on']) && $admin->settings['system_mailmerge_on'] && !empty($modules_array[$module_dir])) {
497 return "<a href='javascript:void(0)' " .
498 "id='merge_listview_". $loc ."'" .
499 'onclick="if (document.MassUpdate.select_entire_list.value==1){document.location.href=\'index.php?action=index&module=MailMerge&entire=true\'} else {return sListView.send_form(true, \'MailMerge\',\'index.php\',\''.$app_strings['LBL_LISTVIEW_NO_SELECTED'].'\');}">' .
500 $app_strings['LBL_MAILMERGE'].'</a>';
506 * Builds the add to target list link
508 * @return string HTML
510 protected function buildTargetList($loc = 'top')
513 unset($_REQUEST[session_name()]);
514 unset($_REQUEST['PHPSESSID']);
515 $current_query_by_page = base64_encode(serialize($_REQUEST));
518 if(sugarListView.get_checks_count() < 1) {
519 alert('{$app_strings['LBL_LISTVIEW_NO_SELECTED']}');
522 if ( document.forms['targetlist_form'] ) {
523 var form = document.forms['targetlist_form'];
526 var form = document.createElement ( 'form' ) ;
527 form.setAttribute ( 'name' , 'targetlist_form' );
528 form.setAttribute ( 'method' , 'post' ) ;
529 form.setAttribute ( 'action' , 'index.php' );
530 document.body.appendChild ( form ) ;
531 if ( !form.module ) {
532 var input = document.createElement('input');
533 input.setAttribute ( 'name' , 'module' );
534 input.setAttribute ( 'value' , '{$this->seed->module_dir}' );
535 input.setAttribute ( 'type' , 'hidden' );
536 form.appendChild ( input ) ;
537 var input = document.createElement('input');
538 input.setAttribute ( 'name' , 'action' );
539 input.setAttribute ( 'value' , 'TargetListUpdate' );
540 input.setAttribute ( 'type' , 'hidden' );
541 form.appendChild ( input ) ;
544 var input = document.createElement('input');
545 input.setAttribute ( 'name' , 'uids' );
546 input.setAttribute ( 'type' , 'hidden' );
547 form.appendChild ( input ) ;
549 if ( !form.prospect_list ) {
550 var input = document.createElement('input');
551 input.setAttribute ( 'name' , 'prospect_list' );
552 input.setAttribute ( 'type' , 'hidden' );
553 form.appendChild ( input ) ;
555 if ( !form.return_module ) {
556 var input = document.createElement('input');
557 input.setAttribute ( 'name' , 'return_module' );
558 input.setAttribute ( 'type' , 'hidden' );
559 form.appendChild ( input ) ;
561 if ( !form.return_action ) {
562 var input = document.createElement('input');
563 input.setAttribute ( 'name' , 'return_action' );
564 input.setAttribute ( 'type' , 'hidden' );
565 form.appendChild ( input ) ;
567 if ( !form.select_entire_list ) {
568 var input = document.createElement('input');
569 input.setAttribute ( 'name' , 'select_entire_list' );
570 input.setAttribute ( 'value', document.MassUpdate.select_entire_list.value);
571 input.setAttribute ( 'type' , 'hidden' );
572 form.appendChild ( input ) ;
574 if ( !form.current_query_by_page ) {
575 var input = document.createElement('input');
576 input.setAttribute ( 'name' , 'current_query_by_page' );
577 input.setAttribute ( 'value', '{$current_query_by_page}' );
578 input.setAttribute ( 'type' , 'hidden' );
579 form.appendChild ( input ) ;
581 open_popup('ProspectLists','600','400','',true,false,{ 'call_back_function':'set_return_and_save_targetlist','form_name':'targetlist_form','field_to_name_array':{'id':'prospect_list'} } );
583 $js = str_replace(array("\r","\n"),'',$js);
584 return "<a href='javascript:void(0)' id=\"targetlist_listview_". $loc ." \" onclick=\"$js\">{$app_strings['LBL_ADD_TO_PROSPECT_LIST_BUTTON_LABEL']}</a>";
587 * Display the bottom of the ListView (ie MassUpdate
588 * @return string contents
590 public function displayEnd()
593 if($this->show_mass_update_form) {
594 $str .= $this->mass->getMassUpdateForm(true);
595 $str .= $this->mass->endMassUpdateForm();
602 * Display the multi select data box etc.
603 * @return string contents
605 public function getMultiSelectData()
607 $str = "<script>YAHOO.util.Event.addListener(window, \"load\", sListView.check_boxes);</script>\n";
609 $massUpdateRun = isset($_REQUEST['massupdate']) && $_REQUEST['massupdate'] == 'true';
610 $uids = empty($_REQUEST['uid']) || $massUpdateRun ? '' : $_REQUEST['uid'];
611 $select_entire_list = ($massUpdateRun) ? 0 : (isset($_POST['select_entire_list']) ? $_POST['select_entire_list'] : (isset($_REQUEST['select_entire_list']) ? $_REQUEST['select_entire_list'] : 0));
613 $str .= "<textarea style='display: none' name='uid'>{$uids}</textarea>\n" .
614 "<input type='hidden' name='select_entire_list' value='{$select_entire_list}'>\n".
615 "<input type='hidden' name='{$this->moduleString}' value='0'>\n".
616 "<input type='hidden' name='show_plus' value='{$this->show_plus}'>\n";
621 * @return MassUpdate instance
623 protected function getMassUpdate()
625 return new MassUpdate();