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-2011 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 ********************************************************************************/
38 /*********************************************************************************
40 * Description: TODO: To be written.
41 * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc.
42 * All Rights Reserved.
43 * Contributor(s): ______________________________________..
44 ********************************************************************************/
48 $_REQUEST['method']; : options: 'SaveRelationship','Save','DeleteRelationship','Delete'
49 $_REQUEST['module']; : the module associated with this Bean instance (will be used to get the class name)
50 $_REQUEST['record']; : the id of the Bean instance
51 // $_REQUEST['related_field']; : the field name on the Bean instance that contains the relationship
52 // $_REQUEST['related_record']; : the id of the related record
53 // $_REQUEST['related_']; : the
54 // $_REQUEST['return_url']; : the URL to redirect to
55 //$_REQUEST['return_type']; : when set the results of a report will be linked with the parent.
59 require_once('include/formbase.php');
61 function add_prospects_to_prospect_list($query,$parent_module,$parent_type,$parent_id,$child_id,$link_attribute,$link_type) {
63 $GLOBALS['log']->debug('add_prospects_to_prospect_list:parameters:'.$query);
64 $GLOBALS['log']->debug('add_prospects_to_prospect_list:parameters:'.$parent_module);
65 $GLOBALS['log']->debug('add_prospects_to_prospect_list:parameters:'.$parent_type);
66 $GLOBALS['log']->debug('add_prospects_to_prospect_list:parameters:'.$parent_id);
67 $GLOBALS['log']->debug('add_prospects_to_prospect_list:parameters:'.$child_id);
68 $GLOBALS['log']->debug('add_prospects_to_prospect_list:parameters:'.$link_attribute);
69 $GLOBALS['log']->debug('add_prospects_to_prospect_list:parameters:'.$link_type);
72 if (!class_exists($parent_type)) {
73 require_once('modules/'.$parent_module.'/'.$parent_type.'.php');
75 $focus = new $parent_type();
76 $focus->retrieve($parent_id);
78 //if link_type is default then load relationship once and add all the child ids.
79 $relationship_attribute=$link_attribute;
81 //find all prospects based on the query
82 $db = DBManagerFactory::getInstance();
83 $result=$db->query($query);
84 while(($row=$db->fetchByAssoc($result)) != null) {
86 $GLOBALS['log']->debug('target_id'.$row[$child_id]);
88 if ($link_type != 'default') {
89 $relationship_attribute=strtolower($row[$link_attribute]);
92 $GLOBALS['log']->debug('add_prospects_to_prospect_list:relationship_attribute:'.$relationship_attribute);
94 //load relationship for the first time or on change of relationship atribute.
95 if (empty($focus->$relationship_attribute)) {
96 $focus->load_relationship($relationship_attribute);
99 $focus->$relationship_attribute->add($row[$child_id]);
103 //Link rows returned by a report to parent record.
104 function save_from_report($report_id,$parent_id, $module_name, $relationship_attr_name) {
108 $GLOBALS['log']->debug("Save2: Linking with report output");
109 $GLOBALS['log']->debug("Save2:Report ID=".$report_id);
110 $GLOBALS['log']->debug("Save2:Parent ID=".$parent_id);
111 $GLOBALS['log']->debug("Save2:Module Name=".$module_name);
112 $GLOBALS['log']->debug("Save2:Relationship Attribute Name=".$relationship_attr_name);
114 $bean_name = $beanList[$module_name];
115 $GLOBALS['log']->debug("Save2:Bean Name=".$bean_name);
116 require_once($beanFiles[$bean_name]);
117 $focus = new $bean_name();
119 $focus->retrieve($parent_id);
120 $focus->load_relationship($relationship_attr_name);
122 //fetch report definition.
123 global $current_language, $report_modules, $modules_report;
125 $mod_strings = return_module_language($current_language,"Reports");
128 $saved = new SavedReport();
129 $saved->disable_row_level_security = true;
130 $saved->retrieve($report_id, false);
132 //initiailize reports engine with the report definition.
133 require_once('modules/Reports/SubpanelFromReports.php');
134 $report = new SubpanelFromReports($saved);
135 $report->run_query();
137 $sql = $report->query_list[0];
138 $GLOBALS['log']->debug("Save2:Report Query=".$sql);
139 $result = $report->db->query($sql);
140 while($row = $report->db->fetchByAssoc($result))
142 $focus->$relationship_attr_name->add($row['primaryid']);
146 $refreshsubpanel=true;
147 if (isset($_REQUEST['return_type']) && $_REQUEST['return_type'] == 'report') {
148 save_from_report($_REQUEST['subpanel_id'] //report_id
149 ,$_REQUEST['record'] //parent_id
150 ,$_REQUEST['module'] //module_name
151 ,$_REQUEST['subpanel_field_name'] //link attribute name
153 } else if (isset($_REQUEST['return_type']) && $_REQUEST['return_type'] == 'addtoprospectlist') {
155 $GLOBALS['log']->debug(print_r($_REQUEST,true));
156 add_prospects_to_prospect_list(urldecode($_REQUEST['query']),$_REQUEST['parent_module'],$_REQUEST['parent_type'],$_REQUEST['subpanel_id'],
157 $_REQUEST['child_id'],$_REQUEST['link_attribute'],$_REQUEST['link_type']);
159 $refreshsubpanel=false;
160 }else if (isset($_REQUEST['return_type']) && $_REQUEST['return_type'] == 'addcampaignlog') {
161 //if param is set to "addcampaignlog", then we need to create a campaign log entry
162 //for each campaign id passed in.
164 //get list of campaign's selected'
165 if (isset($_REQUEST['subpanel_id']) && !empty($_REQUEST['subpanel_id'])) {
166 $campaign_ids = $_REQUEST['subpanel_id'];
169 //retrieve current bean
170 $bean_name = $beanList[$_REQUEST['module']];
171 require_once($beanFiles[$bean_name]);
172 $focus = new $bean_name();
173 $focus->retrieve($_REQUEST['record']);
175 require_once('modules/Campaigns/utils.php');
176 //call util function to create the campaign log entry
177 foreach($campaign_ids as $id){
178 create_campaign_log_entry($id, $focus, $focus->module_dir,$focus, $focus->id);
180 $refreshsubpanel=true;
185 global $beanFiles,$beanList;
186 $bean_name = $beanList[$_REQUEST['module']];
187 require_once($beanFiles[$bean_name]);
188 $focus = new $bean_name();
190 $focus->retrieve($_REQUEST['record']);
192 // If the user selected "All records" from the selection menu, we pull up the list
193 // based on the query they used on that popup to relate them to the parent record
194 if(!empty($_REQUEST['select_entire_list']) && $_REQUEST['select_entire_list'] != 'undefined' && isset($_REQUEST['current_query_by_page'])){
196 $current_query_by_page = $_REQUEST['current_query_by_page'];
197 $current_query_by_page_array = unserialize(base64_decode($current_query_by_page));
199 $module = $current_query_by_page_array['module'];
200 $seed = loadBean($module);
202 require_once('include/SearchForm/SearchForm2.php');
204 if(file_exists('custom/modules/'.$module.'/metadata/metafiles.php')){
205 require('custom/modules/'.$module.'/metadata/metafiles.php');
206 }elseif(file_exists('modules/'.$module.'/metadata/metafiles.php')){
207 require('modules/'.$module.'/metadata/metafiles.php');
210 if (file_exists('custom/modules/'.$module.'/metadata/searchdefs.php'))
212 require_once('custom/modules/'.$module.'/metadata/searchdefs.php');
214 elseif (!empty($metafiles[$module]['searchdefs']))
216 require_once($metafiles[$module]['searchdefs']);
218 elseif (file_exists('modules/'.$module.'/metadata/searchdefs.php'))
220 require_once('modules/'.$module.'/metadata/searchdefs.php');
223 if(!empty($metafiles[$module]['searchfields'])){
224 require_once($metafiles[$module]['searchfields']);
226 elseif(file_exists('modules/'.$module.'/metadata/SearchFields.php')){
227 require_once('modules/'.$module.'/metadata/SearchFields.php');
229 if(!empty($searchdefs) && !empty($searchFields)) {
230 $searchForm = new SearchForm($seed, $module);
231 $searchForm->setup($searchdefs, $searchFields, 'include/SearchForm/tpls/SearchFormGeneric.tpl');
232 $searchForm->populateFromArray($current_query_by_page_array, 'advanced');
233 $where_clauses_arr = $searchForm->generateSearchWhere(true, $module);
234 if (count($where_clauses_arr) > 0 ) {
235 $where_clauses = '('. implode(' ) AND ( ', $where_clauses_arr) . ')';
239 $ret_array = create_export_query_relate_link_patch($module, $searchFields, $where_clauses);
240 $query = $seed->create_export_query($order_by, $ret_array['where'], $ret_array['join']);
241 $result = $GLOBALS['db']->query($query,true);
243 while($val = $GLOBALS['db']->fetchByAssoc($result,false))
245 array_push($uids, $val['id']);
247 $_REQUEST['subpanel_id'] = $uids;
250 if($bean_name == 'Team'){
251 $subpanel_id = $_REQUEST['subpanel_id'];
252 if(is_array($subpanel_id)){
253 foreach($subpanel_id as $id){
254 $focus->add_user_to_team($id);
258 $focus->add_user_to_team($subpanel_id);
261 //find request paramters with with prefix of REL_ATTRIBUTE_
262 //convert them into an array of name value pairs add pass them as
263 //parameters to the add metod.
264 $add_values =array();
265 foreach ($_REQUEST as $key=>$value) {
266 if (strpos($key,"REL_ATTRIBUTE_") !== false) {
267 $add_values[substr($key,14)]=$value;
270 $focus->load_relationship($_REQUEST['subpanel_field_name']);
271 $focus->$_REQUEST['subpanel_field_name']->add($_REQUEST['subpanel_id'],$add_values);
276 if ($refreshsubpanel) {
277 //refresh contents of the sub-panel.
278 $GLOBALS['log']->debug("Location: index.php?sugar_body_only=1&module=".$_REQUEST['module']."&subpanel=".$_REQUEST['subpanel_module_name']."&action=SubPanelViewer&inline=1&record=".$_REQUEST['record']);
279 if( empty($_REQUEST['refresh_page']) || $_REQUEST['refresh_page'] != 1){
280 $inline = isset($_REQUEST['inline'])?$_REQUEST['inline']: $inline;
281 header("Location: index.php?sugar_body_only=1&module=".$_REQUEST['module']."&subpanel=".$_REQUEST['subpanel_module_name']."&action=SubPanelViewer&inline=$inline&record=".$_REQUEST['record']);