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 require_once 'modules/ModuleBuilder/parsers/relationships/OneToManyRelationship.php' ;
42 * Class to manage the metadata for a One-To-Many Relationship
43 * The One-To-Many relationships created by this class are a combination of a subpanel and a custom relate field
44 * The LHS (One) module will receive a new subpanel for the RHS module. The subpanel gets its data ('get_subpanel_data') from a link field that references a new Relationship
45 * The RHS (Many) module will receive a new relate field to point back to the LHS
47 * OOB modules implement One-To-Many relationships as:
49 * On the LHS (One) side:
50 * A Relationship of type one-to-many in the rhs modules vardefs.php
51 * A link field in the same vardefs.php with 'relationship'= the relationship name and 'source'='non-db'
52 * A subpanel which gets its data (get_subpanel_data) from the link field
54 * On the RHS (Many) side:
55 * A Relate field in the vardefs, formatted as in this example, which references a link field:
56 * 'name' => 'account_name',
58 * 'id_name' => 'account_id',
59 * 'vname' => 'LBL_ACCOUNT_NAME',
60 * 'join_name'=>'accounts',
62 * 'link' => 'accounts',
63 * 'table' => 'accounts',
64 * 'module' => 'Accounts',
65 * 'source' => 'non-db'
66 * A link field which references the shared Relationship
69 class ActivitiesRelationship extends OneToManyRelationship
72 protected static $subpanelsAdded = array();
73 protected static $labelsAdded = array();
77 * @param array $definition Parameters passed in as array defined in parent::$definitionKeys
78 * The lhs_module value is for the One side; the rhs_module value is for the Many
80 function __construct ($definition)
82 parent::__construct ( $definition ) ;
86 * BUILD methods called during the build
90 * Define the labels to be added to the module for the new relationships
91 * @return array An array of system value => display value
93 function buildLabels ()
95 $labelDefinitions = array ( ) ;
96 if (!$this->relationship_only )
98 if (!isset(ActivitiesRelationship::$labelsAdded[$this->lhs_module])) {
99 foreach(getTypeDisplayList() as $typeDisplay)
101 $labelDefinitions [] = array (
102 'module' => 'application',
103 'system_label' => $typeDisplay,
104 'display_label' => array(
105 $this->lhs_module => $this->lhs_label ? $this->lhs_label : ucfirst($this->lhs_module)
111 $labelDefinitions [] = array (
112 'module' => $this->lhs_module ,
113 'system_label' => 'LBL_' . strtoupper ( $this->relationship_name . '_FROM_' . $this->getRightModuleSystemLabel() ) . '_TITLE' ,
114 'display_label' => $this->lhs_label ? $this->lhs_label : ucfirst($this->lhs_module)
116 ActivitiesRelationship::$labelsAdded[$this->lhs_module] = true;
118 return $labelDefinitions ;
123 * @return array An array of field definitions, ready for the vardefs, keyed by module
125 function buildVardefs ( )
127 $vardefs = array ( ) ;
129 $vardefs [ $this->rhs_module ] [] = $this->getLinkFieldDefinition ( $this->lhs_module, $this->relationship_name ) ;
130 $vardefs [ $this->lhs_module ] [] = $this->getLinkFieldDefinition ( $this->rhs_module, $this->relationship_name ) ;
136 protected function getLinkFieldDefinition ($sourceModule , $relationshipName)
138 $vardef = array ( ) ;
139 $vardef [ 'name' ] = $relationshipName;
140 $vardef [ 'type' ] = 'link' ;
141 $vardef [ 'relationship' ] = $relationshipName ;
142 $vardef [ 'source' ] = 'non-db' ;
143 $vardef [ 'vname' ] = strtoupper("LBL_{$relationshipName}_FROM_{$sourceModule}_TITLE");
148 * Define what fields to add to which modules layouts
149 * @return array An array of module => fieldname
151 function buildFieldsToLayouts ()
153 if ($this->relationship_only)
156 return array( $this->rhs_module => $this->relationship_name . "_name" ) ; // this must match the name of the relate field from buildVardefs
159 function buildSubpanelDefinitions ()
161 if ($this->relationship_only || isset(ActivitiesRelationship::$subpanelsAdded[$this->lhs_module]))
164 ActivitiesRelationship::$subpanelsAdded[$this->lhs_module] = true;
165 $relationshipName = substr($this->relationship_name, 0, strrpos($this->relationship_name, '_'));
166 return array( $this->lhs_module => array (
167 'activities' => $this->buildActivitiesSubpanelDefinition ( $relationshipName ),
168 'history' => $this->buildHistorySubpanelDefinition ( $relationshipName ) ,
173 * @return array An array of relationship metadata definitions
175 function buildRelationshipMetaData ()
177 $relationshipName = $this->definition [ 'relationship_name' ];
178 $relMetadata = array ( ) ;
179 $relMetadata [ 'lhs_module' ] = $this->definition [ 'lhs_module' ] ;
180 $relMetadata [ 'lhs_table' ] = $this->getTablename($this->definition [ 'lhs_module' ]) ;
181 $relMetadata [ 'lhs_key' ] = 'id' ;
182 $relMetadata [ 'rhs_module' ] = $this->definition [ 'rhs_module' ] ;
183 $relMetadata [ 'rhs_table' ] = $this->getTablename($this->definition [ 'rhs_module' ]) ;
184 $relMetadata ['rhs_key'] = 'parent_id';
185 $relMetadata ['relationship_type'] = 'one-to-many';
186 $relMetadata ['relationship_role_column'] = 'parent_type';
187 $relMetadata ['relationship_role_column_value'] = $this->definition [ 'lhs_module' ] ;
189 return array( $this->lhs_module => array(
190 'relationships' => array ($relationshipName => $relMetadata),
191 'fields' => '', 'indices' => '', 'table' => '')
196 * Shortcut to construct an Activities collection subpanel
197 * @param AbstractRelationship $relationship Source relationship to Activities module
199 protected function buildActivitiesSubpanelDefinition ( $relationshipName )
203 'sort_order' => 'desc' ,
204 'sort_by' => 'date_start' ,
205 'title_key' => 'LBL_ACTIVITIES_SUBPANEL_TITLE' ,
206 'type' => 'collection' ,
207 'subpanel_name' => 'activities' , //this value is not associated with a physical file
208 'module' => 'Activities' ,
209 'top_buttons' => array (
210 array ( 'widget_class' => 'SubPanelTopCreateTaskButton' ) ,
211 array ( 'widget_class' => 'SubPanelTopScheduleMeetingButton' ) ,
212 array ( 'widget_class' => 'SubPanelTopScheduleCallButton' ) ,
213 array ( 'widget_class' => 'SubPanelTopComposeEmailButton' ) ) ,
214 'collection_list' => array (
215 'meetings' => array (
216 'module' => 'Meetings' ,
217 'subpanel_name' => 'ForActivities' ,
218 'get_subpanel_data' => $relationshipName. '_meetings' ) ,
220 'module' => 'Tasks' ,
221 'subpanel_name' => 'ForActivities' ,
222 'get_subpanel_data' => $relationshipName. '_tasks' ) ,
224 'module' => 'Calls' ,
225 'subpanel_name' => 'ForActivities' ,
226 'get_subpanel_data' => $relationshipName. '_calls' ) ) ) ;
230 * Shortcut to construct a History collection subpanel
231 * @param AbstractRelationship $relationship Source relationship to Activities module
233 protected function buildHistorySubpanelDefinition ( $relationshipName )
237 'sort_order' => 'desc' ,
238 'sort_by' => 'date_modified' ,
239 'title_key' => 'LBL_HISTORY' ,
240 'type' => 'collection' ,
241 'subpanel_name' => 'history' , //this values is not associated with a physical file.
242 'module' => 'History' ,
243 'top_buttons' => array (
244 array ( 'widget_class' => 'SubPanelTopCreateNoteButton' ) ,
245 array ( 'widget_class' => 'SubPanelTopArchiveEmailButton'),
246 array ( 'widget_class' => 'SubPanelTopSummaryButton' ) ) ,
247 'collection_list' => array (
248 'meetings' => array (
249 'module' => 'Meetings' ,
250 'subpanel_name' => 'ForHistory' ,
251 'get_subpanel_data' => $relationshipName. '_meetings' ) ,
253 'module' => 'Tasks' ,
254 'subpanel_name' => 'ForHistory' ,
255 'get_subpanel_data' => $relationshipName. '_tasks' ) ,
257 'module' => 'Calls' ,
258 'subpanel_name' => 'ForHistory' ,
259 'get_subpanel_data' => $relationshipName. '_calls' ) ,
261 'module' => 'Notes' ,
262 'subpanel_name' => 'ForHistory' ,
263 'get_subpanel_data' => $relationshipName. '_notes' ) ,
265 'module' => 'Emails' ,
266 'subpanel_name' => 'ForHistory' ,
267 'get_subpanel_data' => $relationshipName. '_emails' ) ) ) ;