Forums - Thread Details
  • State Verified Answer
  • Replies 17 replies
  • Subscribers 319 subscribers
  • Views 2742 views
  • Users 0 members are here
Forum Actions
Related

How to create a subpanel in sugarcrm 7.6 in Accounts module.

Anand Chitikela

Hi

   I want to create a subpanel,I have created an custom field-relatedaccount_c(related to accounts module)field in the Calls/Meetings/Tasks modules.This field appears only when the Parent Type="Projects" for the calls/Meetings/Tasks.So in the accounts module i want a Project Activities subpanel in which we can see all the list of calls/meetings/tasks whose parent type is Projects and  relatedaccount_c.Shijin Krishna Gustav Lindström Ajay Kumar

Parents
  • 0 in reply to Gustav Lindström

    Hi Gustav

         Currently i am working on sugarcrm 7.6

         I have tried

    /<>/custom/Extension/modules/Accounts/Ext/Layoutdefs/test_subpanel.php

    <?php

    $layout_defs['Accounts']['subpanel_setup']['relatedaccount_c'] =

            array(order => 49,

                'module' => 'Calls',

                'subpanel_name' => 'Project Activities',

                'get_subpanel_data' => 'function:get_related_accounts',

                'generate_select' => true,

                'title_key' => 'LBL_RELATEDACCOUNT',

                'top_buttons' => array(),

                'function_parameters' => array(

                    'import_function_file' => 'custom/modules/Accounts/customRelatedAccountsSubpanel.php',

                    'account_id' => $this->_focus->id,

                    'return_as_array' => true

                ),

    );

    /<>/custom/modules/Accounts/customRelatedAccountsSubpanel.php

    <?php

    function get_related_accounts($params) {

        $args = func_get_args();

        $accountId = $args[0]['account_id'];

        $return_array['select'] = "SELECT c.name";

        $return_array['from'] =   "FROM calls c";

        $return_array['where'] =  "WHERE a.id ='".$accountId."'";

        $return_array['join'] =   "LEFT JOIN calls_cstm cc ON c.id=cc.id_c LEFT JOIN accounts a on a.id=cc.account_id_c";

        $return_array['join_tables'] = ”;

        return $return_array;

    }

    /<>/custom/Extension/modules/Accounts/Ext/Language/en_us.lang.php

    $mod_strings['LBL_RELATEDACCOUNT'] = 'Project Activities';

    But i was unable to get a subpanel

Reply
  • 0 in reply to Gustav Lindström

    Hi Gustav

         Currently i am working on sugarcrm 7.6

         I have tried

    /<>/custom/Extension/modules/Accounts/Ext/Layoutdefs/test_subpanel.php

    <?php

    $layout_defs['Accounts']['subpanel_setup']['relatedaccount_c'] =

            array(order => 49,

                'module' => 'Calls',

                'subpanel_name' => 'Project Activities',

                'get_subpanel_data' => 'function:get_related_accounts',

                'generate_select' => true,

                'title_key' => 'LBL_RELATEDACCOUNT',

                'top_buttons' => array(),

                'function_parameters' => array(

                    'import_function_file' => 'custom/modules/Accounts/customRelatedAccountsSubpanel.php',

                    'account_id' => $this->_focus->id,

                    'return_as_array' => true

                ),

    );

    /<>/custom/modules/Accounts/customRelatedAccountsSubpanel.php

    <?php

    function get_related_accounts($params) {

        $args = func_get_args();

        $accountId = $args[0]['account_id'];

        $return_array['select'] = "SELECT c.name";

        $return_array['from'] =   "FROM calls c";

        $return_array['where'] =  "WHERE a.id ='".$accountId."'";

        $return_array['join'] =   "LEFT JOIN calls_cstm cc ON c.id=cc.id_c LEFT JOIN accounts a on a.id=cc.account_id_c";

        $return_array['join_tables'] = ”;

        return $return_array;

    }

    /<>/custom/Extension/modules/Accounts/Ext/Language/en_us.lang.php

    $mod_strings['LBL_RELATEDACCOUNT'] = 'Project Activities';

    But i was unable to get a subpanel

Children