AnsweredAssumed Answered

How can i refresh a specific subpanel in the Detailview

Question asked by Asaf Army on Jan 29, 2018
Latest reply on Dec 5, 2018 by Robert Sinclair

Like • Show 1 Like1
Comment • 7

Hello Developers,

I'm using SugarCRM Community edition 6.5.13 version.

When i use the quickcreate of a certain subpanel, i want other subpanel to be refreshed. how can i do that?

For example: in the Accounts Detailview, when creating a new Opportunity, using the Opportunity QuickCreate view, inside the Opportunity subpanel and pushing "Save" i want the Contacts Subpanel (that also under the Account detailview) to be refreshed (never mind the reason).

i know how to refresh the entire sceen after creating a record in a subpanel, but need to refresh a specific subpanel instead because the refresh of the whole screen, takes a lot of time.

i refresh the whole screen by putting a controller.php file in the Accounts module and calls the refresh like this:

<?php
class AccountsController extends SugarController {

function action_SubPanelViewer() {

require_once 'include/SubPanel/SubPanelViewer.php';
$GLOBALS['log']->fatal(print_r($_REQUEST,TRUE));

// only if this is creation of new sale under accounts, refresh the screen so the salerow subpanel will be refreshed too
if ( array_key_exists('module', $_REQUEST) && array_key_exists('subpanel', $_REQUEST) && array_key_exists('action', $_REQUEST) &&
$_REQUEST['module'] == 'Accounts' && $_REQUEST['subpanel'] == "accounts_opportunities_1" && $_REQUEST['action'] == "SubPanelViewer")
{

$js=<<<EOQ
<script>
window.location.reload();
</script>
EOQ;
echo $js;

}
}
}

How can i refresh a specific subpanel after creating record in other subpanel?

Thank you

1 person has this question

Outcomes

Kenneth Brill Jan 29, 2018 6:12 AM

You would have to do that in Javascript. You woud override the save() function on the one subpanel and then add code to refresh the subpanel you want. I learned out to do the refresh from here

http://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_7.8/User_Interface/Views/Refreshing_Subp…

So, without actually doing it, I would look into over riding the _save() function in clients/base/fields/editablelistbutton/editablelistbutton.js on Opportunities and refresh your subpanel from there. Just a quick pre-breakfast guess. Not sure if thats enough to get you started or not, let me know.

Actions

Asaf Army @ Kenneth Brill on Jan 30, 2018 7:25 AM

Sorry Kenneth, i forgot to mention i use sugarcrm community edition 6.5.13.

i dont have the Recordview

Actions

Rolustech Support Feb 2, 2018 4:22 AM

Hi Asaf Army,

Please call showSubPanel function with appropriate parameters e.g.
showSubPanel('activities','/index.php?action=DetailView&module=Accounts&record=ac3a920d-4eb5-872e-2df7-5a744f775e4f&return_module=Accounts&return_action=DetailView&offset=1&Accounts_activities_CELL_offset=&inline=true&to_pdf=true&action=SubPanelViewer&subpanel=activities&Accounts_activities_CELL_ORDER_BY=name&layout_def_key=Accounts',true);

It refreshes the activities subpanel on the accounts module.
Hope this helps.

Kind Regards,
Rolustech Support
Email: support@rolustech.com
Website: www.rolustech.com

1 person found this helpful

Actions

Asaf Army @ Rolustech Support on Feb 4, 2018 12:20 AM

Hi, thank you for the response.

i read your post and tried it.

i'm struggling with the URL parameter.

how did you know that this is the right url? did you copy pasted it from somewhere?

because i'm trying to refresh another subpanel, not activities, so where can i find the right URL?

my subpanel is called "accounts_op_salerows_1" which is a relationship between Accounts module and "op_Salerows" custom module i made.

i tried this url (i guessed the part in bold... didn't know what to write....):

showSubPanel('accounts_op_salerows_1','/index.php?module=Accounts&offset=6&stamp=1517728790010162600&return_module=Accounts&action=DetailView&record=390a23f8-8342-75d4-18c2-5a688e5882b1&Accounts_op_salerows_1_CELL_offset=&inline=true&to_pdf=true&action=SubPanelViewer&subpanel=accounts_op_salerows_1&Accounts_op_salerows_1_CELL_ORDER_BY=name&layout_def_key=Accounts',true);

but i get "URL not found" error in the subpanel:

it means the url is not right.

Where can i get the URL of the subpanel? do i use the chrome console?

Thank you so much

Actions

Asaf Army @ Rolustech Support on Feb 4, 2018 12:35 AM

ok, nevermind, the solution was much simpler:

just:

showSubPanel('accounts_op_salerows_1',null,true);

Thank you!!

1 person found this helpful

Actions

Robert Sinclair @ Asaf Army on Dec 4, 2018 5:07 PM

Thank you!

To summarize for those reading, you need to create a custom controller in

custom/modules/PARENT_MODULE/controller.php

When you change something in your sub-panel it will generate a new $_REQUEST (in real-time) so when you're satisfied that the right sub-panel is being manipulated you can fire the showSubpanel('FIELD_NAME',null,true); action. Here's working code which you need to customize (most probably just replace the 'un_inventory_users_1' with your field)

<?php
class un_inventoryController extends SugarController {
/**
 *
 */
 function action_SubPanelViewer() {

require_once 'include/SubPanel/SubPanelViewer.php';


// only if this is creation of new sale under accounts, refresh the screen so the salerow subpanel will be refreshed too
if ( array_key_exists('module', $_REQUEST) && array_key_exists('subpanel', $_REQUEST) && array_key_exists('action', $_REQUEST) &&
$_REQUEST['module'] == 'un_inventory' && $_REQUEST['subpanel'] == "un_inventory_leads_1" && $_REQUEST['action'] == "SubPanelViewer") {

 write_to_log(array("request" => $_REQUEST), "all conditions filled, custom controller called", true);

 $js=<<<EOQ
<script>
showSubPanel('un_inventory_users_1',null,true);
</script>
EOQ;
 echo $js;

 }
}
}
?>

Actions

Robert Sinclair @ Rolustech Support on Dec 5, 2018 7:02 AM

Thank you very much Rolustech, do you know what the command is to refresh a specific field and not the whole subpanel? Thank you

Actions

7 Replies

Kenneth Brill Jan 29, 2018 6:12 AM
Mark Correct
Correct Answer
You would have to do that in Javascript. You woud override the save() function on the one subpanel and then add code to refresh the subpanel you want. I learned out to do the refresh from here
http://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_7.8/User_Interface/Views/Refreshing_Subp…

So, without actually doing it, I would look into over riding the _save() function in clients/base/fields/editablelistbutton/editablelistbutton.js on Opportunities and refresh your subpanel from there. Just a quick pre-breakfast guess. Not sure if thats enough to get you started or not, let me know.
Like • Show 0 Likes0
Actions
- Asaf Army @ Kenneth Brill on Jan 30, 2018 7:25 AM
  Mark Correct
  Correct Answer
  Sorry Kenneth, i forgot to mention i use sugarcrm community edition 6.5.13.
  i dont have the Recordview
  Like • Show 0 Likes0
  Actions
Rolustech Support Feb 2, 2018 4:22 AM
Mark Correct
Correct Answer
Hi Asaf Army,

Please call showSubPanel function with appropriate parameters e.g.
showSubPanel('activities','/index.php?action=DetailView&module=Accounts&record=ac3a920d-4eb5-872e-2df7-5a744f775e4f&return_module=Accounts&return_action=DetailView&offset=1&Accounts_activities_CELL_offset=&inline=true&to_pdf=true&action=SubPanelViewer&subpanel=activities&Accounts_activities_CELL_ORDER_BY=name&layout_def_key=Accounts',true);

It refreshes the activities subpanel on the accounts module.
Hope this helps.

Kind Regards,
Rolustech Support
Email: support@rolustech.com
Website: www.rolustech.com
1 person found this helpful
Like • Show 1 Like1
Actions
- Asaf Army @ Rolustech Support on Feb 4, 2018 12:20 AM
  Mark Correct
  Correct Answer
  Hi, thank you for the response.
  
  i read your post and tried it.
  i'm struggling with the URL parameter.
  how did you know that this is the right url? did you copy pasted it from somewhere?
  because i'm trying to refresh another subpanel, not activities, so where can i find the right URL?
  
  my subpanel is called "accounts_op_salerows_1" which is a relationship between Accounts module and "op_Salerows" custom module i made.
  
  i tried this url (i guessed the part in bold... didn't know what to write....):
  showSubPanel('accounts_op_salerows_1','/index.php?module=Accounts&offset=6&stamp=1517728790010162600&return_module=Accounts&action=DetailView&record=390a23f8-8342-75d4-18c2-5a688e5882b1&Accounts_op_salerows_1_CELL_offset=&inline=true&to_pdf=true&action=SubPanelViewer&subpanel=accounts_op_salerows_1&Accounts_op_salerows_1_CELL_ORDER_BY=name&layout_def_key=Accounts',true);
  
  but i get "URL not found" error in the subpanel:
  
  it means the url is not right.
  Where can i get the URL of the subpanel? do i use the chrome console?
  
  Thank you so much
  Like • Show 0 Likes0
  Actions
- Asaf Army @ Rolustech Support on Feb 4, 2018 12:35 AM
  Mark Correct
  Correct Answer
  ok, nevermind, the solution was much simpler:
  
  just:
  showSubPanel('accounts_op_salerows_1',null,true);
  
  Thank you!!
  1 person found this helpful
  Like • Show 1 Like1
  Actions
  - Robert Sinclair @ Asaf Army on Dec 4, 2018 5:07 PM
    Mark Correct
    Correct Answer
    Thank you!
    
    To summarize for those reading, you need to create a custom controller in
    
    custom/modules/PARENT_MODULE/controller.php
    
    When you change something in your sub-panel it will generate a new $_REQUEST (in real-time) so when you're satisfied that the right sub-panel is being manipulated you can fire the showSubpanel('FIELD_NAME',null,true); action. Here's working code which you need to customize (most probably just replace the 'un_inventory_users_1' with your field)
    
    <?php class un_inventoryController extends SugarController { /** * */ function action_SubPanelViewer() { require_once 'include/SubPanel/SubPanelViewer.php'; // only if this is creation of new sale under accounts, refresh the screen so the salerow subpanel will be refreshed too if ( array_key_exists('module', $_REQUEST) && array_key_exists('subpanel', $_REQUEST) && array_key_exists('action', $_REQUEST) && $_REQUEST['module'] == 'un_inventory' && $_REQUEST['subpanel'] == "un_inventory_leads_1" && $_REQUEST['action'] == "SubPanelViewer") { write_to_log(array("request" => $_REQUEST), "all conditions filled, custom controller called", true); $js=<<<EOQ <script> showSubPanel('un_inventory_users_1',null,true); </script> EOQ; echo $js; } } } ?>
    Like • Show 0 Likes0
    Actions
- Robert Sinclair @ Rolustech Support on Dec 5, 2018 7:02 AM
  Mark Correct
  Correct Answer
  Thank you very much Rolustech, do you know what the command is to refresh a specific field and not the whole subpanel? Thank you
  Like • Show 0 Likes0
  Actions

How can i refresh a specific subpanel in the Detailview

Outcomes

Related Content

Recommended Content

Incoming Links