Opportunitiy List Changes

[bryansmithiu]

Hello, I am new to Sugar and PHP(I do have development experience). I have added a check box to the opportunity basic search, when checked I need to show the list in a very specific way(By date-modified within 10 days, then sales status). I am unsure where the query is for that list. I have looked at the Modules/Opportunities/Opportunity.php file however changes that I make do not appear on the list. Am I looking at the wrong place? How do I add the value of the checkbox to a parameter and get to the query?

Thank you in advance.

[andopes]

Hi Brian

You have to do the following:

Create a custom controller for Opportunities;
Inside this custom controller implement the method action_listview() containing something like that:

 function action_listview() {
  require_once('custo/modules/Opportunities/OpportunityListView.php');
 
  $this->view = 'list';
  $this->bean = new OpportunityListView();
} 
  

Create the script custo/modules/Opportunities/OpportunityListView.php containing the class OpportunityListView which should extends the default Opportunity class.
Inside this custom class implement the method create_new_list_query. Take a look at this function into data/SugarBean.php, you will see the parameters and return of function.
Actually you need to modify the $ret_array['where'] in order to apply your specific query according to status of checkbox.

Kind regards

[bryansmithiu]

Ok.. I get that and it appears to be working, however my create_new_list_query has taken the place of the original, is there a way to look at the check box and determine whether to use the new method or the old one? Or do i need to bring the old method over to this class and make the necessary changes there?

Thank you so much for your help!