include/generic/SugarWidgets/SugarWidgetFieldrelate.php

   1 <?php
   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.
   6  *
   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.
  13  *
  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
  17  * details.
  18  *
  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
  22  * 02110-1301 USA.
  23  *
  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.
  26  *
  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.
  30  *
  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  ********************************************************************************/
  37
  38
  39 class SugarWidgetFieldRelate extends SugarWidgetReportField
  40 {
  41     /**
  42      * Method returns HTML of input on configure dashlet page
  43      *
  44      * @param array $layout_def definition of a field
  45      * @return string HTML of select for edit page
  46      */
  47     public function displayInput($layout_def)
  48     {
  49         $values = array();
  50         if (is_array($layout_def['input_name0']))
  51         {
  52             $values = $layout_def['input_name0'];
  53         }
  54         else
  55         {
  56             $values[] = $layout_def['input_name0'];
  57         }
  58         $html = '<select name="' . $layout_def['name'] . '[]" multiple="true">';
  59
  60         $query = $this->displayInputQuery($layout_def);
  61         $result = $this->reporter->db->query($query);
  62         while ($row = $this->reporter->db->fetchByAssoc($result))
  63         {
  64             $html .= '<option value="' . $row['id'] . '"';
  65             if (in_array($row['id'], $values))
  66             {
  67                 $html .= ' selected="selected"';
  68             }
  69             $html .= '>' . htmlspecialchars($row['title']) . '</option>';
  70         }
  71
  72         $html .= '</select>';
  73         return $html;
  74     }
  75
  76     /**
  77      * Method returns database query for generation HTML of input on configure dashlet page
  78      *
  79      * @param array $layout_def definition of a field
  80      * @return string database query HTML of select for edit page
  81      */
  82     private function displayInputQuery($layout_def)
  83     {
  84         $title = $layout_def['rname'];
  85         $bean = isset($layout_def['module']) ? BeanFactory::getBean($layout_def['module']) : NULL;
  86         $table = empty($bean) ? $layout_def['table'] : $bean->table_name;
  87         $concat_fields = isset($layout_def['db_concat_fields']) ? $layout_def['db_concat_fields'] : '';
  88
  89         if (empty($concat_fields) && !empty($bean) && isset($bean->field_defs[$title]['db_concat_fields']))
  90         {
  91             $concat_fields = $bean->field_defs[$title]['db_concat_fields'];
  92         }
  93         if (!empty($concat_fields))
  94         {
  95             $title = $this->reporter->db->concat($table, $concat_fields);
  96         }
  97
  98         $query = "SELECT
  99                 id,
 100                 $title title
 101             FROM $table
 102             WHERE deleted = 0
 103             ORDER BY title ASC";
 104         return $query;
 105     }
 106
 107     /**
 108      * Method returns part of where in style table_alias.id IN (...) because we can't join of relation
 109      *
 110      * @param array $layout_def definition of a field
 111      * @param bool $rename_columns unused
 112      * @return string SQL where part
 113      */
 114     public function queryFilterStarts_With($layout_def, $rename_columns = true)
 115     {
 116         $ids = array();
 117
 118         $relation = new Relationship();
 119         $relation->retrieve_by_name($layout_def['link']);
 120
 121         global $beanList;
 122         $beanClass = $beanList[$relation->lhs_module];
 123         $seed = new $beanClass();
 124         $seed->retrieve($layout_def['input_name0']);
 125
 126         $link = new Link2($layout_def['link'], $seed);
 127         $sql = $link->getQuery();
 128         $result = $this->reporter->db->query($sql);
 129         while ($row = $this->reporter->db->fetchByAssoc($result))
 130         {
 131             $ids[] = $row['id'];
 132         }
 133         $layout_def['name'] = 'id';
 134         return $this->_get_column_select($layout_def) . " IN ('" . implode("', '", $ids) . "')";
 135     }
 136
 137     /**
 138      * Method returns part of where in style table_alias.id IN (...) because we can't join of relation
 139      *
 140      * @param array $layout_def definition of a field
 141      * @param bool $rename_columns unused
 142      * @return string SQL where part
 143      */
 144     public function queryFilterone_of($layout_def, $rename_columns = true)
 145     {
 146         $ids = array();
 147         if (isset($layout_def['link'])) {
 148             $relation = new Relationship();
 149             $relation->retrieve_by_name($layout_def['link']);
 150         }
 151         $module = isset($layout_def['custom_module']) ? $layout_def['custom_module'] : $layout_def['module'];
 152         $seed = BeanFactory::getBean($module);
 153
 154         foreach($layout_def['input_name0'] as $beanId)
 155         {
 156             if (!empty($relation->lhs_module) && !empty($relation->rhs_module)
 157                 && $relation->lhs_module == $relation->rhs_module) {
 158                     $filter = array('id');
 159             } else {
 160                 $filter = array('id', $layout_def['name']);
 161             }
 162             $where = $layout_def['id_name']."='$beanId' ";
 163             $sql = $seed->create_new_list_query('', $where, $filter, array(), 0, '', false, $seed, true);
 164             $result = $this->reporter->db->query($sql);
 165             while ($row = $this->reporter->db->fetchByAssoc($result)) {
 166                 $ids[] = $row['id'];
 167             }
 168         }
 169         $ids = array_unique($ids);
 170         $layout_def['name'] = 'id';
 171         return $this->_get_column_select($layout_def) . " IN ('" . implode("', '", $ids) . "')";
 172     }
 173
 174         //for to_pdf/to_csv
 175         function displayListPlain($layout_def) {
 176             $reporter = $this->layout_manager->getAttribute("reporter");
 177                 $field_def = $reporter->all_fields[$layout_def['column_key']];
 178                 $display = strtoupper($field_def['secondary_table'].'_name');
 179                 //#31797  , we should get the table alias in a global registered array:selected_loaded_custom_links
 180                 if(!empty($reporter->selected_loaded_custom_links) && !empty($reporter->selected_loaded_custom_links[$field_def['secondary_table']])){
 181                         $display = strtoupper($reporter->selected_loaded_custom_links[$field_def['secondary_table']]['join_table_alias'].'_name');
 182                 }
 183         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']]))
 184         {
 185             $display = strtoupper($reporter->selected_loaded_custom_links[$field_def['secondary_table'].'_'.$field_def['rep_rel_name']]['join_table_alias'].'_name');
 186         }
 187                 elseif(!empty($reporter->selected_loaded_custom_links) && !empty($reporter->selected_loaded_custom_links[$field_def['secondary_table'].'_'.$field_def['name']])){
 188                         $display = strtoupper($reporter->selected_loaded_custom_links[$field_def['secondary_table'].'_'.$field_def['name']]['join_table_alias'].'_name');
 189                 }
 190                 $cell = $layout_def['fields'][$display];
 191                 return $cell;
 192         }
 193
 194     function displayList($layout_def) {
 195         $reporter = $this->layout_manager->getAttribute("reporter");
 196         $field_def = $reporter->all_fields[$layout_def['column_key']];
 197         $display = strtoupper($field_def['secondary_table'].'_name');
 198
 199         //#31797  , we should get the table alias in a global registered array:selected_loaded_custom_links
 200         if(!empty($reporter->selected_loaded_custom_links) && !empty($reporter->selected_loaded_custom_links[$field_def['secondary_table']])){
 201              $display = strtoupper($reporter->selected_loaded_custom_links[$field_def['secondary_table']]['join_table_alias'].'_name');
 202         }
 203         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']]))
 204         {
 205             $display = strtoupper($reporter->selected_loaded_custom_links[$field_def['secondary_table'].'_'.$field_def['rep_rel_name']]['join_table_alias'].'_name');
 206         }
 207         elseif(!empty($reporter->selected_loaded_custom_links) && !empty($reporter->selected_loaded_custom_links[$field_def['secondary_table'].'_'.$field_def['name']])){
 208             $display = strtoupper($reporter->selected_loaded_custom_links[$field_def['secondary_table'].'_'.$field_def['name']]['join_table_alias'].'_name');
 209         }
 210         $recordField = $this->getTruncatedColumnAlias(strtoupper($layout_def['table_alias']).'_'.strtoupper($layout_def['name']));
 211
 212         $record = $layout_def['fields'][$recordField];
 213         $cell = "<a target='_blank' class=\"listViewTdLinkS1\" href=\"index.php?action=DetailView&module=".$field_def['ext2']."&record=$record\">";
 214         $cell .= $layout_def['fields'][$display];
 215         $cell .= "</a>";
 216         return $cell;
 217     }
 218 }
 219
 220 ?>