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 ********************************************************************************/
39 require_once('include/EditView/SugarVCR.php');
41 * Data set for ListView
46 var $additionalDetails = true;
47 var $listviewName = null;
48 var $additionalDetailsAllow = null;
49 var $additionalDetailsAjax = true; // leave this true when using filter fields
50 var $additionalDetailsFieldToAdd = 'NAME'; // where the span will be attached to
53 * If you want overwrite the query for the count of the listview set this to your query
54 * otherwise leave it empty and it will use SugarBean::create_list_count_query
56 var $count_query = '';
59 * Constructor sets the limitName to look up the limit in $sugar_config
61 * @return ListViewData
63 function ListViewData() {
64 $this->limitName = 'list_max_entries_per_page';
65 $this->db = &DBManagerFactory::getInstance('listviews');
69 * checks the request for the order by and if that is not set then it checks the session for it
71 * @return array containing the keys orderBy => field being ordered off of and sortOrder => the sort order of that field
73 function getOrderBy($orderBy = '', $direction = '') {
74 if (!empty($orderBy) || !empty($_REQUEST[$this->var_order_by])) {
75 if(!empty($_REQUEST[$this->var_order_by])) {
77 $orderBy = $_REQUEST[$this->var_order_by];
78 if(!empty($_REQUEST['lvso']) && (empty($_SESSION['lvd']['last_ob']) || strcmp($orderBy, $_SESSION['lvd']['last_ob']) == 0) ){
79 $direction = $_REQUEST['lvso'];
82 $_SESSION[$this->var_order_by] = array('orderBy'=>$orderBy, 'direction'=> $direction);
83 $_SESSION['lvd']['last_ob'] = $orderBy;
86 if(!empty($_SESSION[$this->var_order_by])) {
87 $orderBy = $_SESSION[$this->var_order_by]['orderBy'];
88 $direction = $_SESSION[$this->var_order_by]['direction'];
91 $orderBy = 'date_entered';
95 return array('orderBy' => $orderBy, 'sortOrder' => $direction);
99 * gets the reverse of the sort order for use on links to reverse a sort order from what is currently used
101 * @param STRING (ASC or DESC) $current_order
102 * @return STRING (ASC or DESC)
104 function getReverseSortOrder($current_order){
105 return (strcmp(strtolower($current_order), 'asc') == 0)?'DESC':'ASC';
108 * gets the limit of how many rows to show per page
110 * @return INT (the limit)
112 function getLimit() {
113 return $GLOBALS['sugar_config'][$this->limitName];
117 * returns the current offset
119 * @return INT (current offset)
121 function getOffset() {
122 return (!empty($_REQUEST[$this->var_offset])) ? $_REQUEST[$this->var_offset] : 0;
126 * generates the base url without
127 * any files in the block variables will not be part of the url
130 * @return STRING (the base url)
132 function getBaseURL() {
134 if(empty($this->base_url)) {
135 $blockVariables = array('mass', 'uid', 'massupdate', 'delete', 'merge', 'selectCount',$this->var_order_by, $this->var_offset, 'lvso', 'sortOrder', 'orderBy', 'request_data', 'current_query_by_page');
136 $base_url = 'index.php?';
137 foreach($beanList as $bean) {
138 $blockVariables[] = 'Home2_'.strtoupper($bean).'_ORDER_BY';
140 $blockVariables[] = 'Home2_CASE_ORDER_BY';
141 // Added mostly for the unit test runners, which may not have these superglobals defined
143 if ( isset($_POST) && is_array($_POST) ) {
144 $params = array_merge($params,$_POST);
146 if ( isset($_GET) && is_array($_GET) ) {
147 $params = array_merge($params,$_GET);
149 foreach($params as $name=>$value) {
150 if(!in_array($name, $blockVariables)){
151 if(is_array($value)) {
152 foreach($value as $v) {
153 $base_url .= $name.urlencode('[]').'='.urlencode($v) . '&';
157 $base_url .= $name.'='.urlencode($value) . '&';
161 $this->base_url = $base_url;
163 return $this->base_url;
166 * based off of a base name it sets base, offset, and order by variable names to retrieve them from requests and sessions
168 * @param unknown_type $baseName
170 function setVariableName($baseName, $where, $listviewName = null){
172 $module = (!empty($listviewName)) ? $listviewName: $_REQUEST['module'];
173 $this->var_name = $module .'2_'. strtoupper($baseName);
175 $this->var_order_by = $this->var_name .'_ORDER_BY';
176 $this->var_offset = $this->var_name . '_offset';
177 $timestamp = sugar_microtime();
178 $this->stamp = $timestamp;
180 $_SESSION[$module .'2_QUERY_QUERY'] = $where;
182 $_SESSION[strtoupper($baseName) . "_FROM_LIST_VIEW"] = $timestamp;
183 $_SESSION[strtoupper($baseName) . "_DETAIL_NAV_HISTORY"] = false;
186 function getTotalCount($main_query){
187 if(!empty($this->count_query)){
188 $count_query = $this->count_query;
190 $count_query = SugarBean::create_list_count_query($main_query);
192 $result = $this->db->query($count_query);
193 if($row = $this->db->fetchByAssoc($result)){
200 * takes in a seed and creates the list view query based off of that seed
201 * if the $limit value is set to -1 then it will use the default limit and offset values
203 * it will return an array with two key values
204 * 1. 'data'=> this is an array of row data
205 * 2. 'pageData'=> this is an array containg three values
206 * a.'ordering'=> array('orderBy'=> the field being ordered by , 'sortOrder'=> 'ASC' or 'DESC')
207 * b.'urls'=>array('baseURL'=>url used to generate other urls ,
208 * 'orderBy'=> the base url for order by
209 * //the following may not be set (so check empty to see if they are set)
210 * 'nextPage'=> the url for the next group of results,
211 * 'prevPage'=> the url for the prev group of results,
212 * 'startPage'=> the url for the start of the group,
213 * 'endPage'=> the url for the last set of results in the group
214 * c.'offsets'=>array(
215 * 'current'=>current offset
216 * 'next'=> next group offset
217 * 'prev'=> prev group offset
218 * 'end'=> the offset of the last group
219 * 'total'=> the total count (only accurate if totalCounted = true otherwise it is either the total count if less than the limit or the total count + 1 )
220 * 'totalCounted'=> if a count query was used to get the total count
222 * @param SugarBean $seed
223 * @param string $where
224 * @param int:0 $offset
225 * @param int:-1 $limit
226 * @param string[]:array() $filter_fields
227 * @param array:array() $params
228 * Potential $params are
229 $params['distinct'] = use distinct key word
230 $params['include_custom_fields'] = (on by default)
231 $params['custom_XXXX'] = append custom statements to query
232 * @param string:'id' $id_field
233 * @return array('data'=> row data 'pageData' => page data information
235 function getListViewData($seed, $where, $offset=-1, $limit = -1, $filter_fields=array(),$params=array(),$id_field = 'id',$singleSelect=true) {
236 global $current_user;
237 SugarVCR::erase($seed->module_dir);
238 $this->seed =& $seed;
239 $totalCounted = empty($GLOBALS['sugar_config']['disable_count_query']);
240 $_SESSION['MAILMERGE_MODULE_FROM_LISTVIEW'] = $seed->module_dir;
241 if(empty($_REQUEST['action']) || $_REQUEST['action'] != 'Popup'){
242 $_SESSION['MAILMERGE_MODULE'] = $seed->module_dir;
245 $this->setVariableName($seed->object_name, $where, $this->listviewName);
247 $this->seed->id = '[SELECT_ID_LIST]';
249 // if $params tell us to override all ordering
250 if(!empty($params['overrideOrder']) && !empty($params['orderBy'])) {
251 $order = $this->getOrderBy(strtolower($params['orderBy']), (empty($params['sortOrder']) ? '' : $params['sortOrder'])); // retreive from $_REQUEST
254 $order = $this->getOrderBy(); // retreive from $_REQUEST
257 // else use stored preference
258 $userPreferenceOrder = $current_user->getPreference('listviewOrder', $this->var_name);
260 if(empty($order['orderBy']) && !empty($userPreferenceOrder)) {
261 $order = $userPreferenceOrder;
263 // still empty? try to use settings passed in $param
264 if(empty($order['orderBy']) && !empty($params['orderBy'])) {
265 $order['orderBy'] = $params['orderBy'];
266 $order['sortOrder'] = (empty($params['sortOrder']) ? '' : $params['sortOrder']);
269 //rrs - bug: 21788. Do not use Order by stmts with fields that are not in the query.
270 // Bug 22740 - Tweak this check to strip off the table name off the order by parameter.
271 // Samir Gandhi : Do not remove the report_cache.date_modified condition as the report list view is broken
272 $orderby = $order['orderBy'];
273 if (strpos($order['orderBy'],'.') && ($order['orderBy'] != "report_cache.date_modified")) {
274 $orderby = substr($order['orderBy'],strpos($order['orderBy'],'.')+1);
276 if ($orderby != 'date_entered' && !in_array($orderby, array_keys($filter_fields))) {
277 $order['orderBy'] = '';
278 $order['sortOrder'] = '';
281 if (empty($order['orderBy'])) {
284 $orderBy = $order['orderBy'] . ' ' . $order['sortOrder'];
285 //wdong, Bug 25476, fix the sorting problem of Oracle.
286 if (isset($params['custom_order_by_override']['ori_code']) && $order['orderBy'] == $params['custom_order_by_override']['ori_code'])
287 $orderBy = $params['custom_order_by_override']['custom_code'] . ' ' . $order['sortOrder'];
290 if (empty($params['skipOrderSave'])) { // don't save preferences if told so
291 $current_user->setPreference('listviewOrder', $order, 0, $this->var_name); // save preference
294 // If $params tells us to override for the special last_name, first_name sorting
295 if (!empty($params['overrideLastNameOrder']) && $order['orderBy'] == 'last_name') {
296 $orderBy = 'last_name '.$order['sortOrder'].', first_name '.$order['sortOrder'];
299 $ret_array = $seed->create_new_list_query($orderBy, $where, $filter_fields, $params, 0, '', true, $seed, $singleSelect);
300 $ret_array['inner_join'] = '';
301 if (!empty($this->seed->listview_inner_join)) {
302 $ret_array['inner_join'] = ' ' . implode(' ', $this->seed->listview_inner_join) . ' ';
305 if(!is_array($params)) $params = array();
306 if(!isset($params['custom_select'])) $params['custom_select'] = '';
307 if(!isset($params['custom_from'])) $params['custom_from'] = '';
308 if(!isset($params['custom_where'])) $params['custom_where'] = '';
309 if(!isset($params['custom_order_by'])) $params['custom_order_by'] = '';
310 $main_query = $ret_array['select'] . $params['custom_select'] . $ret_array['from'] . $params['custom_from'] . $ret_array['inner_join']. $ret_array['where'] . $params['custom_where'] . $ret_array['order_by'] . $params['custom_order_by'];
311 //C.L. - Fix for 23461
312 if(empty($_REQUEST['action']) || $_REQUEST['action'] != 'Popup') {
313 $_SESSION['export_where'] = $ret_array['where'];
316 $result = $this->db->query($main_query);
320 $limit = $this->getLimit();
322 $dyn_offset = $this->getOffset();
323 if($dyn_offset > 0 || !is_int($dyn_offset))$offset = $dyn_offset;
325 if(strcmp($offset, 'end') == 0){
326 $totalCount = $this->getTotalCount($main_query);
327 $offset = (floor(($totalCount -1) / $limit)) * $limit;
329 if($this->seed->ACLAccess('ListView')) {
330 $result = $this->db->limitQuery($main_query, $offset, $limit + 1);
347 while(($row = $this->db->fetchByAssoc($result)) != null)
351 $id_list .= ',\''.$row[$id_field].'\'';
352 $idIndex[$row[$id_field]][] = count($rows);
353 $rows[] = $seed->convertRow($row);
358 if (!empty($id_list))
360 $id_list = '('.substr($id_list, 1).')';
363 SugarVCR::store($this->seed->module_dir, $main_query);
365 //NOW HANDLE SECONDARY QUERIES
366 if(!empty($ret_array['secondary_select'])) {
367 $secondary_query = $ret_array['secondary_select'] . $ret_array['secondary_from'] . ' WHERE '.$this->seed->table_name.'.id IN ' .$id_list;
368 if(isset($ret_array['order_by']))
370 $secondary_query .= ' ' . $ret_array['order_by'];
373 $secondary_result = $this->db->query($secondary_query);
375 $ref_id_count = array();
376 while($row = $this->db->fetchByAssoc($secondary_result)) {
378 $ref_id_count[$row['ref_id']][] = true;
379 foreach($row as $name=>$value) {
380 //add it to every row with the given id
381 foreach($idIndex[$row['ref_id']] as $index){
382 $rows[$index][$name]=$value;
387 $rows_keys = array_keys($rows);
388 foreach($rows_keys as $key)
390 $rows[$key]['secondary_select_count'] = count($ref_id_count[$rows[$key]['ref_id']]);
394 // retrieve parent names
395 if(!empty($filter_fields['parent_name']) && !empty($filter_fields['parent_id']) && !empty($filter_fields['parent_type'])) {
396 foreach($idIndex as $id => $rowIndex) {
397 if(!isset($post_retrieve[$rows[$rowIndex[0]]['parent_type']])) {
398 $post_retrieve[$rows[$rowIndex[0]]['parent_type']] = array();
400 if(!empty($rows[$rowIndex[0]]['parent_id'])) $post_retrieve[$rows[$rowIndex[0]]['parent_type']][] = array('child_id' => $id , 'parent_id'=> $rows[$rowIndex[0]]['parent_id'], 'parent_type' => $rows[$rowIndex[0]]['parent_type'], 'type' => 'parent');
402 if(isset($post_retrieve)) {
403 $parent_fields = $seed->retrieve_parent_fields($post_retrieve);
404 foreach($parent_fields as $child_id => $parent_data) {
405 //add it to every row with the given id
406 foreach($idIndex[$child_id] as $index){
407 $rows[$index]['parent_name']= $parent_data['parent_name'];
416 while($row = current($rows)){
419 $dataIndex = count($data);
421 $temp->setupCustomFields($temp->module_dir);
422 $temp->loadFromRow($row);
423 if($idIndex[$row[$id_field]][0] == $dataIndex){
424 $pageData['tag'][$dataIndex] = $temp->listviewACLHelper();
426 $pageData['tag'][$dataIndex] = $pageData['tag'][$idIndex[$row[$id_field]][0]];
428 $data[$dataIndex] = $temp->get_list_view_data($filter_fields);
429 $pageData['rowAccess'][$dataIndex] = array('view' => $temp->ACLAccess('DetailView'), 'edit' => $temp->ACLAccess('EditView'));
430 $additionalDetailsAllow = $this->additionalDetails && $temp->ACLAccess('DetailView') && (file_exists('modules/' . $temp->module_dir . '/metadata/additionalDetails.php') || file_exists('custom/modules/' . $temp->module_dir . '/metadata/additionalDetails.php'));
431 //if($additionalDetailsAllow) $pageData['additionalDetails'] = array();
432 $additionalDetailsEdit = $temp->ACLAccess('EditView');
433 if($additionalDetailsAllow) {
434 if($this->additionalDetailsAjax) {
435 $ar = $this->getAdditionalDetailsAjax($data[$dataIndex]['ID']);
438 $additionalDetailsFile = 'modules/' . $this->seed->module_dir . '/metadata/additionalDetails.php';
439 if(file_exists('custom/modules/' . $this->seed->module_dir . '/metadata/additionalDetails.php')){
440 $additionalDetailsFile = 'custom/modules/' . $this->seed->module_dir . '/metadata/additionalDetails.php';
442 require_once($additionalDetailsFile);
443 $ar = $this->getAdditionalDetails($data[$dataIndex],
444 (empty($this->additionalDetailsFunction) ? 'additionalDetails' : $this->additionalDetailsFunction) . $this->seed->object_name,
445 $additionalDetailsEdit);
447 $pageData['additionalDetails'][$dataIndex] = $ar['string'];
448 $pageData['additionalDetails']['fieldToAddTo'] = $ar['fieldToAddTo'];
456 if($count > $limit) {
457 $nextOffset = $offset + $limit;
461 $prevOffset = $offset - $limit;
462 if($prevOffset < 0)$prevOffset = 0;
464 $totalCount = $count + $offset;
466 if( $count >= $limit && $totalCounted){
467 $totalCount = $this->getTotalCount($main_query);
469 SugarVCR::recordIDs($this->seed->module_dir, array_keys($idIndex), $offset, $totalCount);
470 $endOffset = (floor(($totalCount - 1) / $limit)) * $limit;
471 $pageData['ordering'] = $order;
472 $pageData['ordering']['sortOrder'] = $this->getReverseSortOrder($pageData['ordering']['sortOrder']);
473 $pageData['urls'] = $this->generateURLS($pageData['ordering']['sortOrder'], $offset, $prevOffset, $nextOffset, $endOffset, $totalCounted);
474 $pageData['offsets'] = array( 'current'=>$offset, 'next'=>$nextOffset, 'prev'=>$prevOffset, 'end'=>$endOffset, 'total'=>$totalCount, 'totalCounted'=>$totalCounted);
475 $pageData['bean'] = array('objectName' => $seed->object_name, 'moduleDir' => $seed->module_dir);
476 $pageData['stamp'] = $this->stamp;
477 $pageData['access'] = array('view' => $this->seed->ACLAccess('DetailView'), 'edit' => $this->seed->ACLAccess('EditView'));
478 $pageData['idIndex'] = $idIndex;
479 if(!$this->seed->ACLAccess('ListView')) {
480 $pageData['error'] = 'ACL restricted access';
483 return array('data'=>$data , 'pageData'=>$pageData);
488 * generates urls for use by the display layer
490 * @param int $sortOrder
492 * @param int $prevOffset
493 * @param int $nextOffset
494 * @param int $endOffset
495 * @param int $totalCounted
496 * @return array of urls orderBy and baseURL are always returned the others are only returned according to values passed in.
498 function generateURLS($sortOrder, $offset, $prevOffset, $nextOffset, $endOffset, $totalCounted) {
500 $urls['baseURL'] = $this->getBaseURL(). 'lvso=' . $sortOrder. '&';
501 $urls['orderBy'] = $urls['baseURL'] .$this->var_order_by.'=';
504 if($nextOffset > -1) {
505 $urls['nextPage'] = $urls['baseURL'] . $this->var_offset . '=' . $nextOffset . $dynamicUrl;
508 $urls['startPage'] = $urls['baseURL'] . $this->var_offset . '=0' . $dynamicUrl;
510 if($prevOffset > -1) {
511 $urls['prevPage'] = $urls['baseURL'] . $this->var_offset . '=' . $prevOffset . $dynamicUrl;
514 $urls['endPage'] = $urls['baseURL'] . $this->var_offset . '=' . $endOffset . $dynamicUrl;
516 $urls['endPage'] = $urls['baseURL'] . $this->var_offset . '=end' . $dynamicUrl;
523 * generates the additional details span to be retrieved via ajax
525 * @param GUID id id of the record
526 * @return array string to attach to field
528 function getAdditionalDetailsAjax($id)
532 $jscalendarImage = SugarThemeRegistry::current()->getImageURL('info_inline.gif');
534 $extra = "<span id='adspan_" . $id . "' onmouseout=\"return SUGAR.util.clearAdditionalDetailsCall()\" "
535 . "onmouseover=\"lvg_dtails('$id')\" "
536 . "onmouseout=\"return nd(1000);\" style='position: relative;'><!--not_in_theme!--><img vertical-align='middle' class='info' border='0' alt='".$app_strings['LBL_ADDITIONAL_DETAILS']."' src='$jscalendarImage'></span>";
538 return array('fieldToAddTo' => $this->additionalDetailsFieldToAdd, 'string' => $extra);
542 * generates the additional details values
544 * @param unknown_type $fields
545 * @param unknown_type $adFunction
546 * @param unknown_type $editAccess
547 * @return array string to attach to field
549 function getAdditionalDetails($fields, $adFunction, $editAccess)
554 $results = $adFunction($fields);
556 $results['string'] = str_replace(array("'", "'"), '\'', $results['string']); // no xss!
558 if(trim($results['string']) == '')
560 $results['string'] = $app_strings['LBL_NONE'];
563 $extra = "<span onmouseover=\"return overlib('" .
564 str_replace(array("\rn", "\r", "\n"), array('','','<br />'), $results['string'])
565 . "', CAPTION, '<div style=\'float:left\'>{$app_strings['LBL_ADDITIONAL_DETAILS']}</div><div style=\'float: right\'>";
567 if($editAccess && !empty($results['editLink']))
569 $extra .= "<a title=\'{$app_strings['LBL_EDIT_BUTTON']}\' href={$results['editLink']}><img style=\'margin-left: 2px;\' border=\'0\' src=\'".SugarThemeRegistry::current()->getImageURL('edit_inline.gif')."\'></a>";
572 $extra .= (!empty($results['viewLink']) ? "<a title=\'{$app_strings['LBL_VIEW_BUTTON']}\' href={$results['viewLink']}><img style=\'margin-left: 2px;\' border=\'0\' src=".SugarThemeRegistry::current()->getImageURL('view_inline.gif')."></a>" : '')
573 . "', DELAY, 200, STICKY, MOUSEOFF, 1000, WIDTH, "
574 . (empty($results['width']) ? '300' : $results['width'])
575 . ", CLOSETEXT, '<img alt=\'{$app_strings['LBL_CLOSEINLINE']}\' style=\'margin-left:2px; margin-right: 2px; border=0;\' src=".SugarThemeRegistry::current()->getImageURL('close.gif')."></div>', "
576 . "CLOSETITLE, '{$app_strings['LBL_ADDITIONAL_DETAILS_CLOSE_TITLE']}', CLOSECLICK, FGCLASS, 'olFgClass', "
577 . "CGCLASS, 'olCgClass', BGCLASS, 'olBgClass', TEXTFONTCLASS, 'olFontClass', CAPTIONFONTCLASS, 'olCapFontClass', CLOSEFONTCLASS, 'olCloseFontClass');\" "
578 . "onmouseout=\"return nd(1000);\"><img alt=\'{$app_strings['LBL_INFOINLINE']}\' style=\'padding: 0px 5px 0px 2px\' border=\'0\' src='".SugarThemeRegistry::current()->getImageURL('info_inline.png')."' ></span>";
581 $results = $adFunction($fields);
583 $results['string'] = str_replace(array("'", "'"), '\'', $results['string']); // no xss!
585 if(trim($results['string']) == '')
587 $results['string'] = $app_strings['LBL_NONE'];
590 $extra = "<span onmouseover=\"return overlib('" .
591 str_replace(array("\rn", "\r", "\n"), array('','','<br />'), $results['string'])
592 . "', CAPTION, '<div style=\'float:left\'>{$app_strings['LBL_ADDITIONAL_DETAILS']}</div><div style=\'float: right\'>";
594 if($editAccess && !empty($results['editLink']))
596 $extra .= "<a title=\'{$app_strings['LBL_EDIT_BUTTON']}\' href={$results['editLink']}><img style=\'margin-left: 2px;\' border=\'0\' src=\'".SugarThemeRegistry::current()->getImageURL('edit_inline.gif')."\'></a>";
599 $extra .= (!empty($results['viewLink']) ? "<a title=\'{$app_strings['LBL_VIEW_BUTTON']}\' href={$results['viewLink']}><img style=\'margin-left: 2px;\' border=\'0\' src=".SugarThemeRegistry::current()->getImageURL('view_inline.gif')."></a>" : '')
600 . "', DELAY, 200, STICKY, MOUSEOFF, 1000, WIDTH, "
601 . (empty($results['width']) ? '300' : $results['width'])
602 . ", CLOSETEXT, '<img alt=\'{$app_strings['LBL_CLOSEINLINE']}\' style=\'margin-left:2px; margin-right: 2px; border=0;\' src=".SugarThemeRegistry::current()->getImageURL('close.gif')."></div>', "
603 . "CLOSETITLE, '{$app_strings['LBL_ADDITIONAL_DETAILS_CLOSE_TITLE']}', CLOSECLICK, FGCLASS, 'olFgClass', "
604 . "CGCLASS, 'olCgClass', BGCLASS, 'olBgClass', TEXTFONTCLASS, 'olFontClass', CAPTIONFONTCLASS, 'olCapFontClass', CLOSEFONTCLASS, 'olCloseFontClass');\" "
605 . "onmouseout=\"return nd(1000);\"><img alt='{$app_strings['LBL_INFOINLINE']}' style='padding: 0px 5px 0px 2px' border='0' src='".SugarThemeRegistry::current()->getImageURL('info_inline.png')."' ></span>";
607 return array('fieldToAddTo' => $results['fieldToAddTo'], 'string' => $extra);