CiviCRM Community Forums (archive)

Hi all,

Trying to achieve something that maybe better served in the too hard basket and probably something no one has done before.  To cut a long story short, I'm attempting to make a report (pretty much just the activity report with a few mods) which outlines the total duration of all activities of a certain activity type for a 'source contact'. 

Many, many months ago I quite easily created a similar report heavily made off the activity report.  This report's purpose was to calculate the total duration of a certain activity type for a 'target contact'.  This worked great - all was needed was a few extra lines in the select() function and adding the duration field to the construct function along with a bit of grouping - pretty standard stuff.

Unfortunately it's not quite as easy to switch from the 'target contact' to the 'source contact' with this approach in regards to the duration calculation when it comes to activities which are shared with multiple contacts.  What happens is if you have a 3 hour activity shared between 3 different contacts.  It picks up 3 lots of 3 hours ... rather than just 3 hours so I end up with 6 extra hours which isn't ideal and makes the report irrelevant. 

Does anybody have any thoughts, suggestions or ideas on how to work around the above problem before I try and tackle this again tomorrow?

Cheers Hayden

Are you doing this in CiviReport? Or are you writing custom code ?

Okay - I updated the ActivitySummary.php and Activity.php so that Duration is an option.  I'll attach the two here but change the file type to .php from .txt

First off, make a directory for the custom code - I used my-CiviCRMhome-directory/sites/all/civicrm_custom

You're also going to have to create some subdirectories as well - You'll need to create

my-CiviCRMhome-directory/sites/all/civicrm_custom/CRM/Report/Form and you'll copy these two file into that directory.

Then, I went into Administer | Configure | Global Settings | Directories and changed the Custom PHP Path Directory    to my-CiviCRMhome-directory/sites/all/civicrm_custom

However, I wanted to figure out how to get the field to align right instead of the default align left behavior.  I found where there's a test for the $header.type - but for the life of me, couldn't find out where or how it was set.  Instead I did the sledgehammer version and added the class to my-CiviCRMhome-directory/sites/all/modules/civicrm/css/civicrm.css like this
#crm-container td.crm-report-civicrm_activity_duration_sum {
    text-align: right;
}
If anyone can clue me in on how the alignment is set - would appreciate it.