Improve AOR_Reports Conditions

SuiteCRM Forum - English Language Suggestion Box
1

It would be nice if the Conditions in AOR_Reports where improved.

  1. Add Contains and Does_Not_Contain
    for this I have hacked the code in modules/AOR_Reports.php and modified the line:
                    if(!$where_set) $query['where'][] = $field.' '.$app_list_strings['aor_sql_operator_list'][$condition->operator].' '.$value;

to:

if(strpos($value, "%") !== FALSE)
  $MyOperator = "LIKE";
else 
  $MyOperator = $app_list_strings['aor_sql_operator_list'][$condition->operator];
if(!$where_set) $query['where'][] = $field.' '.$MyOperator.' '.$value;

  1. AND and OR
    Add as the first option starting from the second contion the possibility to choose AND or OR

  2. Parentheses
    It would be also nice to being able to group conditions in parentheses (eg.: ((A AND (B OR C) AND (D OR E))

2

Here is a small improvement to my hack for 1. Contains and Does Not Contain:

if(strpos($value, "%") !== FALSE)
  if($app_list_strings['aor_sql_operator_list'][$condition->operator] == '=')
    $MyOperator = "LIKE";
  else
    $MyOperator = "NOT LIKE";
else 
  $MyOperator = $app_list_strings['aor_sql_operator_list'][$condition->operator];

if(!$where_set) $query['where'][] = $field.' '.$MyOperator.' '.$value;
3

Tried this in modules/AOR_Reports/AOR-Report.php but i cant see a change in the conditions field when i try to run a report…?!
Am i missing something?

4

This hack only changes the behaviour, while the interface remains unchanged.