{"id":6007,"date":"2021-07-19T03:53:58","date_gmt":"2021-07-19T03:53:58","guid":{"rendered":"https:\/\/tst-blog.myenterprise.in\/?p=6007"},"modified":"2025-01-13T09:44:43","modified_gmt":"2025-01-13T09:44:43","slug":"sugarcrm-tutorial-on-categorizing-records-in-two-subpanels-for-a-single-one-to-many-relationship","status":"publish","type":"post","link":"https:\/\/www.bhea.com\/blog\/sugarcrm-tutorial-on-categorizing-records-in-two-subpanels-for-a-single-one-to-many-relationship\/","title":{"rendered":"SugarCRM Tutorial on categorizing records in two Subpanels for a single \u201cOne to Many\u201d relationship"},"content":{"rendered":"

We all know that when a one-to-many relationship exists between two modules, Sugar will create a subpanel in the Parent Module and a relationship table in the database to store the related records ids to load that records in the subpanel. This is pretty powerful but in some situations, there are requirements to create two subpanels with only one relationship and categorize the related records into those two subpanels. This blog will explain how to create two subpanels with one relationship and categorize related records into those subpanels.<\/p>\n\n\n

\n\n\n\n

An Example Scenario:<\/h3>\n\n\n\n

Let\u2019s take an example where your customer has a requirement to show Opportunities related to Accounts in two subpanels in one subpanel with all the open Opportunities and the other with all closed Opportunities.<\/p>\n\n\n\n

Now let us see how to build two subpanels for Opportunities in Accounts modules by using standard relationship in the studio.<\/p>\n\n\n\n

Step 1: Create Metadata for Custom subpanel.<\/h4>\n\n\n\n

We know that there is already a one-to-many SugarCRM standard relationship between Accounts and Opportunities in SugarCRM and the relationship metadata is defined in modules\/Accounts\/vardefs.php<\/p>\n\n\n\n

Now to create a new subpanel and to categorise Closed opportunities and Open Opportunities let us create a file in following path and add the below code.<\/p>\n\n\n\n

custom\/Extension\/modules\/Accounts\/Ext\/Vardefs\/.php<\/strong><\/p>\n\n\n\n

PHP<\/span><\/path><\/path><\/svg><\/span>
<?php<\/span><\/span>\n$<\/span>dictionary<\/span>[<\/span>'Account'<\/span>][<\/span>'fields'<\/span>][<\/span>'accounts_closed_opportunities'<\/span>]<\/span> <\/span>=<\/span> <\/span>array<\/span>(<\/span><\/span>\n    <\/span>'name'<\/span> <\/span>=><\/span> <\/span>'accounts_closed_opportunities'<\/span>,<\/span><\/span>\n    <\/span>'type'<\/span> <\/span>=><\/span> <\/span>'link'<\/span>,<\/span><\/span>\n    <\/span>'relationship'<\/span> <\/span>=><\/span> <\/span>'accounts_opportunities'<\/span>,<\/span><\/span>\n    <\/span>'source'<\/span> <\/span>=><\/span> <\/span>'non-db'<\/span>,<\/span><\/span>\n    <\/span>'module'<\/span> <\/span>=><\/span> <\/span>'Opportunities'<\/span>,<\/span><\/span>\n    <\/span>'bean_name'<\/span> <\/span>=><\/span> <\/span>'Opportunity'<\/span>,<\/span><\/span>\n    <\/span>'vname'<\/span> <\/span>=><\/span> <\/span>'LBL_ACCOUNTS_CLOSED_OPPORTUNITIES_TITLE'<\/span>,<\/span><\/span>\n    <\/span>'link-type'<\/span> <\/span>=><\/span> <\/span>'many'<\/span>,<\/span><\/span>\n    <\/span>'side'<\/span> <\/span>=><\/span> <\/span>'left'<\/span>,<\/span><\/span>\n);<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
The above code defines a custom relationship metadata with a name and tells the system to use the relationship which is used by the one-to-many relationship between accounts and opportunities. So that the related records are loaded into this custom subpanel form accounts_opportunities table.<\/p>\n\n\n\n
Step 2: Custom Subpanel Title<\/h3>\n\n\n\n
As we want to differentiate Open Opportunities and Closed Opportunities, Let us rename the new subpanel as Closed Opportunities. To do this create a file in following path and add the below code.<\/p>\n\n\n\n
custom\/Extension\/modules\/Accounts\/Ext\/Language\/en_us..php<\/p>\n\n\n\n
PHP<\/span><\/path><\/path><\/svg><\/span>
<?php<\/span><\/span>\n   <\/span>$<\/span>mod_strings<\/span>[<\/span>'LBL_ACCOUNTS_CLOSED_OPPORTUNITIES_TITLE'<\/span>]<\/span> <\/span>=<\/span> <\/span>'Closed Opportunities'<\/span>;<\/span><\/span>\n?><\/span><\/span><\/code><\/pre><\/div>\n\n\n\n

The above code will set the label to the custom subpanel.<\/p>\n\n\n\n
Step 3: Create Viewdefs for Custom Subpanel<\/h3>\n\n\n\n
To render the custom subpanel in Accounts record view, create a new file in following path and add the below code. <\/p>\n\n\n\n
custom\\Extension\\modules\\Accounts\\Ext\\clients\\base\\layouts\\subpanels\\.php<\/strong><\/p>\n\n\n\n
PHP<\/span><\/path><\/path><\/svg><\/span>
<?php<\/span><\/span>\n$<\/span>viewdefs<\/span>[<\/span>'Accounts'<\/span>][<\/span>'base'<\/span>][<\/span>'layout'<\/span>][<\/span>'subpanels'<\/span>][<\/span>'components'<\/span>][]<\/span> <\/span>=<\/span> <\/span>array<\/span> <\/span>(<\/span><\/span>\n  <\/span>'layout'<\/span> <\/span>=><\/span> <\/span>'subpanel'<\/span>,<\/span><\/span>\n  <\/span>'label'<\/span> <\/span>=><\/span> <\/span>'LBL_ACCOUNTS_CLOSED_OPPORTUNITIES_TITLE'<\/span>,<\/span><\/span>\n  <\/span>'context'<\/span> <\/span>=><\/span> <\/span><\/span>\n  <\/span>array<\/span> <\/span>(<\/span><\/span>\n    <\/span>'link'<\/span> <\/span>=><\/span> <\/span>'accounts_closed_opportunities'<\/span>,<\/span><\/span>\n  <\/span>),<\/span><\/span>\n);<\/span><\/span>\n?><\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
This code will give metadata for the subpanel layout.<\/p>\n\n\n\n
Step 4: Rename Default Subpanel<\/h3>\n\n\n\n
Now it\u2019s time  to rename our default subpanel to the Open Opportunities in Accounts module. To do this open the Sugar Instance as an admin user and go to Admin> Studio> Accounts> Subpanels> Opportunities and rename the stock subpanel from Opportunities to Open Opportunities because we are going to load open Opportunities into it.<\/p>\n\n\n\n
\"Categorizing<\/figure>\n\n\n\n
After this do Quick Repair and Rebuild now you will see a new custom subpanel in Accounts Record View.<\/p>\n\n\n\n
Now you will see both the subpanels will load the same data, this is because we didn\u2019t add the code to filter the Opportunities based on the sales stage.<\/p>\n\n\n\n
To achieve this we need to add two more attributes namely link_class<\/strong> and link_file<\/strong> in the metadata files of both stock and custom subpanels. Here, link_class is the Class Name we are using for handling relationships and link_file<\/strong> is the path for the PHP file in which the class is defined.<\/p>\n\n\n\n