Hello. I have some legacy code from SugarCRM 7 that is not working with our upgraded SugarCRM 11. The end result is to populate a drop-down field based on the Opportunity record being viewed. I am having difficulty figuring out how to get the ID for the record currently being viewed.
custom/Extension/modules/Opportunities/Ext/Vardefs/my_custom_vars.php:
$dictionary['Opportunity']['fields']['referral_c']['function'] = 'get_opportunities_contacts_dropdown' ;
custom/include/custom_utils.php:
Fullscreen
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
function get_opportunities_contacts_dropdown() {
$list = array();
if( isset($_GET['bean_id']) ){
$bean_id = $_GET['bean_id'];
$dropdown_query = "select contacts.id, contacts.first_name, contacts.last_name from contacts inner join opportunities_contacts on contacts.id = opportunities_contacts.contact_id inner join opportunities on opportunities.id = opportunities_contacts.opportunity_id where contacts.deleted = 0 and opportunities.deleted = 0 and opportunities_contacts.deleted = 0 and opportunities.id ='".$bean_id."';";
$result = $GLOBALS['db']->query($dropdown_query,true," Error getting contact data fields: ");
if (!$result) {
$message = 'Invalid query or could not connect: ' . mysql_error() . "\n";
$message .= 'Whole query: ' . $query;
sugar_upgrade_die($message);
}
while ($temp_row = $GLOBALS['db']->fetchByAssoc($result)) {
$list[$temp_row['id']] = $temp_row['first_name'] . " " . $temp_row['last_name'];
}
}
The $_GET['bean_id'] is no longer set in SugarCRM 11. How can I get the ID for the currently viewed record? Thanks.