CiviCRM Community Forums (archive)

What I am trying to do is create a report which shows overdue scheduled Activities in red, like the Activities dashlet does or the Case Activities display in the Manage Case screen.
In these displays the table row in which such Activities are displayed has a class of "status-overdue" which causes the row to display in red (by virtue of the civicrm.css which makes them appear in color:#E43D2B which is a bright orange/red).
None of the report templates that come with CiviCRM seem to do this, so I tried to create my own report template to do this, but I am struggling.   

Looking at the code for these existing displays it seems that the row object has a property 'class' which if set to the value 'status-overdue' will cause the table row in the generated HTML to have that class.  I have tried (in the alterDisplay function of the report template) ...
$rows[$rowNum]['class'] = 'status-overdue'in the appropriate place, but that seems to have no effect.

I am obviously a little out of my depth here, so can anyone help please? 

Thanks
Mark

Thanks Kurund, that worked.   

Mark

This improvement will be included in the 4.2 release cycle: http://issues.civicrm.org/jira/browse/CRM-9515

Stuart - I tested this on my local 4.2 and only past due activities where status is NOT completed are being assigned the status-overdue class. Also checked the code change for CRM-9515 (below) which checks status before assigning that css class. Hopefully you can dig in a bit more on your side to see what's happening. Are your "completed" activities marked differently somehow ??

+            if ( array_key_exists('civicrm_activity_activity_date_time', $row ) ) {
+                if ( CRM_Utils_Date::overdue( $rows[$rowNum]['civicrm_activity_activity_date_time'] ) &&
+                     $activityStatus[$row['civicrm_activity_status_id']] != 'Completed' ) {
+                    $rows[$rowNum]['class'] = "status-overdue";
+                    $entryFound = true;
+                }
+            }
+


Let's see what values are being returned in $activityStatus[$row['civicrm_activity_status_id']] variable (should be the status labels - e.g. Scheduled, Completed, etc.)

Change this line in the code section shown in my previous post:

          $rows[$rowNum]['class'] = "status-overdue";

to this:

          $rows[$rowNum]['class'] = "status-overdue " . $activityStatus[$row['civicrm_activity_status_id']];

and then use Firebug or view source to look at the class being assigned to your past activity rows.

Seems like this section of the function is not working as expected:
      if (array_key_exists('civicrm_activity_status_id', $row)) {
        if ($value = $row['civicrm_activity_status_id']) {
          $rows[$rowNum]['civicrm_activity_status_id'] = $activityStatus[$value];
          $entryFound = TRUE;
        }
      }

But then I would expect that the Activity Status column on the report would be empty or possibly have a numeric value instead of the labels. What do you see in the status column?

Maybe jump on IRC and we can add some debug statements ??