total amount on subpanel

[anjireddy987]

hi,
i have a module opportunities,and this is related to accounts.
when new account is assigned for a particular opportunities module,it's should be displayed on subpanel
on top menu of the sub panel i have to display the total amount related to particular accounts.
here i am attaching the screen shot regarding this,
any one help me regarding this how to proceed to solve this problem

Thanks&Regards
Anji(gramanjul@gmail.com)

[kuske]

The very simpliest way would be to define a custom field in accounts and calculate this field in a logic hook after retreive of the account data.

[anjireddy987]

Thank u kuske,

can u explain the way how can we achieve this

[AlexAv]

Thank u kuske,

can u explain the way how can we achieve this

What do you want to know about the logic hooks?

[AlexAv]

The very simpliest way would be to define a custom field in accounts and calculate this field in a logic hook after retreive of the account data.

Can I create Logic Hooks for a Subpanel?

[andopes]

Yes, the logic_hook process_record is triggered by either ListView and Subpanel.

Cheers

[christianknoll]

What you want to do requires some deep level modification int the Subpanel (resp. the ListView). We did similar things for a customer with a Filter function for the Subpanel to find records (see image attached).

Yet I recommend you only do it if you know your way around in Sugar and are well versed in PHP. If it is important and you are not that fit get some help and somebody to do it. If required we are happy to help.


christian.

hi,
i have a module opportunities,and this is related to accounts.
when new account is assigned for a particular opportunities module,it's should be displayed on subpanel
on top menu of the sub panel i have to display the total amount related to particular accounts.
here i am attaching the screen shot regarding this,
any one help me regarding this how to proceed to solve this problem

Thanks&Regards
Anji(gramanjul@gmail.com)

[AlexAv]

Yes, the logic_hook process_record is triggered by either ListView and Subpanel.

Cheers

Thanks for reply,
I have solved my problem with SugarCRM widgets.

[hoangbao]

hi christian,

please help me the logic hook to update total field in detail view when a record create in the Subpanel

my code

 <?php
$hook_version = 1;
$hook_array = Array();
$hook_array['process_record'] = Array();
$hook_array['process_record'][] = Array(1, 'process_record', 'custom/modules/oms_Contracts/contract_value.php','contract_value', 'add_contract_value');
?>  

 <?php
if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
 
require_once('data/SugarBean.php');
require_once('include/utils.php');
require_once('modules/oms_Contracts/oms_Contracts.php');
 
class contract_value {
 
function add_contract_value(&$focus,$event,$arguments){
 
        require_once('modules/oms_Products/oms_Products_sugar.php');
        $product = new oms_Products();
        $contract_value = $focus->contract_value + $product->list_price;
        $focus->contract_value = $contract_value;
}
}
?>  

but nothing to do.

thanks,
hoangbao

What you want to do requires some deep level modification int the Subpanel (resp. the ListView). We did similar things for a customer with a Filter function for the Subpanel to find records (see image attached).

Yet I recommend you only do it if you know your way around in Sugar and are well versed in PHP. If it is important and you are not that fit get some help and somebody to do it. If required we are happy to help.


christian.

[erop]

Yes, the logic_hook process_record is triggered by either ListView and Subpanel.

Indeed this should work as written in DevGuide, etc. But I couldn't manage to fire process_record hook. In my case I need to display releted module field value in ListView mainly and DetailView. I added custom varchar field to Contacts module named 'speciality_c'. In my scenario if Meeting is related to Contact through existing Flex Relate field that I want to display that 'speciality_c' value in Meetings ListView and DetailView.

So, I created custom/Extension/modules/Meetings/Ext/Vardefs/contact_speciality.php to add 'non-db' field:

 <?php

$dictionary['Meeting']['fields'][] = 'contact_speciality';
$dictionary['Meeting']['fields']['contact_speciality'] = array(
    'name' => 'contact_speciality',
    'source' => 'non-db',
    'type' => 'varchar',
    'len' => 255,
    'vname' => 'LBL_CONTACT_SPECIALITY',
);

?>  

Then in custom/modules/Meetings/logic_hooks.php define the hook:

 <?php

$hook_version = 1;
$hook_array['process_record'] = array();
$hook_array['process_record'][] = array(10, 'Get Contact speciality', 'custom/modules/Meetings/logic_hooks/get_contact_speciality.php', 'getContactSpeciality', 'getContactSpeciality');
?>  

And at last the hook itself in custom/modules/Meetings/logic_hooks/get_contact_speciality.php :

 <?php
if(!defined('sugarEntry')) define('sugarEntry', true);
require_once 'modules/Contacts/Contact.php';
class getContactSpeciality {
    function getContactSpeciality(&$bean, $event, $arguments) {
        if ($bean->parent_type == 'Contacts') {
            $contact = new Contact();
            $contact->retrieve($bean->parent_id);
            $bean->contact_speciality = $contact->speciality_c;
        } else {
            return;
        }
    }
}
?>  

Of course, detailviewdefs.php and listviewdefs.php were modified as well to display 'contact_speciality' value. But nothing happens to make me happy.

I tried to debug using $GLOBALS['log']->debug() but it seems that hook doesn't fire at all. (BTW, where in code tree should I place breakpoint to debug logic hook in IDE like Eclipse or NetBeans? I set breakpoint in file above, start debug session, but it seems that Sugar bypasses breakpoint. Developer mode enabled, xdebug setup properly.)

Are there any obvious mistakes in my code that don't let process_record fires? My before_save hooks works exactly as needed.

P.S. I'm on SugarCE 6.0.0