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-2013 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 class SugarWidgetFieldRelate extends SugarWidgetReportField
42 * Method returns HTML of input on configure dashlet page
44 * @param array $layout_def definition of a field
45 * @return string HTML of select for edit page
47 public function displayInput($layout_def)
50 if (is_array($layout_def['input_name0']))
52 $values = $layout_def['input_name0'];
56 $values[] = $layout_def['input_name0'];
58 $html = '<select name="' . $layout_def['name'] . '[]" multiple="true">';
60 $query = $this->displayInputQuery($layout_def);
61 $result = $this->reporter->db->query($query);
62 while ($row = $this->reporter->db->fetchByAssoc($result))
64 $html .= '<option value="' . $row['id'] . '"';
65 if (in_array($row['id'], $values))
67 $html .= ' selected="selected"';
69 $html .= '>' . htmlspecialchars($row['title']) . '</option>';
77 * Method returns database query for generation HTML of input on configure dashlet page
79 * @param array $layout_def definition of a field
80 * @return string database query HTML of select for edit page
82 private function displayInputQuery($layout_def)
84 $title = $layout_def['rname'];
85 if (isset($layout_def['db_concat_fields'])) {
86 $title = $this->reporter->db->concat($layout_def['table'], $layout_def['db_concat_fields']);
92 FROM {$layout_def['table']}
99 * Method returns part of where in style table_alias.id IN (...) because we can't join of relation
101 * @param array $layout_def definition of a field
102 * @param bool $rename_columns unused
103 * @return string SQL where part
105 public function queryFilterStarts_With($layout_def, $rename_columns = true)
109 $relation = new Relationship();
110 $relation->retrieve_by_name($layout_def['link']);
113 $beanClass = $beanList[$relation->lhs_module];
114 $seed = new $beanClass();
115 $seed->retrieve($layout_def['input_name0']);
117 $link = new Link2($layout_def['link'], $seed);
118 $sql = $link->getQuery();
119 $result = $this->reporter->db->query($sql);
120 while ($row = $this->reporter->db->fetchByAssoc($result))
124 $layout_def['name'] = 'id';
125 return $this->_get_column_select($layout_def) . " IN ('" . implode("', '", $ids) . "')";
129 * Method returns part of where in style table_alias.id IN (...) because we can't join of relation
131 * @param array $layout_def definition of a field
132 * @param bool $rename_columns unused
133 * @return string SQL where part
135 public function queryFilterone_of($layout_def, $rename_columns = true)
139 $relation = new Relationship();
140 $relation->retrieve_by_name($layout_def['link']);
143 $beanClass = $beanList[$relation->lhs_module];
144 $seed = new $beanClass();
146 foreach($layout_def['input_name0'] as $beanId)
148 $seed->retrieve($beanId);
150 $link = new Link2($layout_def['link'], $seed);
151 $sql = $link->getQuery();
152 $result = $this->reporter->db->query($sql);
153 while ($row = $this->reporter->db->fetchByAssoc($result))
158 $ids = array_unique($ids);
159 $layout_def['name'] = 'id';
160 return $this->_get_column_select($layout_def) . " IN ('" . implode("', '", $ids) . "')";
164 function displayListPlain($layout_def) {
165 $reporter = $this->layout_manager->getAttribute("reporter");
166 $field_def = $reporter->all_fields[$layout_def['column_key']];
167 $display = strtoupper($field_def['secondary_table'].'_name');
168 //#31797 , we should get the table alias in a global registered array:selected_loaded_custom_links
169 if(!empty($reporter->selected_loaded_custom_links) && !empty($reporter->selected_loaded_custom_links[$field_def['secondary_table']])){
170 $display = strtoupper($reporter->selected_loaded_custom_links[$field_def['secondary_table']]['join_table_alias'].'_name');
172 elseif(isset($field_def['rep_rel_name']) && isset($reporter->selected_loaded_custom_links) && !empty($reporter->selected_loaded_custom_links[$field_def['secondary_table'].'_'.$field_def['rep_rel_name']]))
174 $display = strtoupper($reporter->selected_loaded_custom_links[$field_def['secondary_table'].'_'.$field_def['rep_rel_name']]['join_table_alias'].'_name');
176 elseif(!empty($reporter->selected_loaded_custom_links) && !empty($reporter->selected_loaded_custom_links[$field_def['secondary_table'].'_'.$field_def['name']])){
177 $display = strtoupper($reporter->selected_loaded_custom_links[$field_def['secondary_table'].'_'.$field_def['name']]['join_table_alias'].'_name');
179 $cell = $layout_def['fields'][$display];
183 function displayList($layout_def) {
184 $reporter = $this->layout_manager->getAttribute("reporter");
185 $field_def = $reporter->all_fields[$layout_def['column_key']];
186 $display = strtoupper($field_def['secondary_table'].'_name');
188 //#31797 , we should get the table alias in a global registered array:selected_loaded_custom_links
189 if(!empty($reporter->selected_loaded_custom_links) && !empty($reporter->selected_loaded_custom_links[$field_def['secondary_table']])){
190 $display = strtoupper($reporter->selected_loaded_custom_links[$field_def['secondary_table']]['join_table_alias'].'_name');
192 elseif(isset($field_def['rep_rel_name']) && isset($reporter->selected_loaded_custom_links) && !empty($reporter->selected_loaded_custom_links[$field_def['secondary_table'].'_'.$field_def['rep_rel_name']]))
194 $display = strtoupper($reporter->selected_loaded_custom_links[$field_def['secondary_table'].'_'.$field_def['rep_rel_name']]['join_table_alias'].'_name');
196 elseif(!empty($reporter->selected_loaded_custom_links) && !empty($reporter->selected_loaded_custom_links[$field_def['secondary_table'].'_'.$field_def['name']])){
197 $display = strtoupper($reporter->selected_loaded_custom_links[$field_def['secondary_table'].'_'.$field_def['name']]['join_table_alias'].'_name');
199 $recordField = $this->getTruncatedColumnAlias(strtoupper($layout_def['table_alias']).'_'.strtoupper($layout_def['name']));
201 $record = $layout_def['fields'][$recordField];
202 $cell = "<a target='_blank' class=\"listViewTdLinkS1\" href=\"index.php?action=DetailView&module=".$field_def['ext2']."&record=$record\">";
203 $cell .= $layout_def['fields'][$display];