Grouping dates in array - output

[ging8]

Hello everyone, I am relatively new to PHP and looking for some guidance.

I have an array $events[] and trying to do the following:

array contains event_name, event_start_date and event_hours

I would like the output to be grouped into years and a total of event hours at the end of each year

Something like this

2009
Event1 - 8 hours
Event2 - 3 hours
Total: 11 hours

2009
Event3 - 4 hours
Event4 - 5 hours
Total: 11 hours

So far I am taking the time and converting it to a year and looping through the array but that is it

$event_year = date('Y', strtotime($event->start_date));

foreach ($events as $event) {

}

[NogDog]

Is this coming from a database query? If so, it might be easier and more efficient to do the grouping in your query. But to do it within PHP, you could build a new array organized by year, something like:

<?php
// test data:
$events = array(
   array('event_name' => 'foo', 'event_start_date' => '2009/02/01', 'event_hours' => 2),
   array('event_name' => 'bar', 'event_start_date' => '2009/03/01', 'event_hours' => 3),
   array('event_name' => 'manny', 'event_start_date' => '2010/02/01', 'event_hours' => 4),
   array('event_name' => 'moe', 'event_start_date' => '2010/03/01', 'event_hours' => 5),
   array('event_name' => 'jack', 'event_start_date' => '2010/04/01', 'event_hours' => 6)
);

// build summary array:
$sorted = array();
foreach($events as $event)
{
   $year = date('Y', strtotime($event['event_start_date']));
   if(empty($sorted[$year]['total_hours']))
   {
      $sorted[$year]['total_hours'] = 0;
   }
   $sorted[$year]['events'][] = $event;
   $sorted[$year]['total_hours'] += $event['event_hours'];
}

// show results:
echo "<pre>".print_r($sorted, 1)."</pre>";

Output:

Array
(
    [2009] => Array
        (
            [total_hours] => 5
            [events] => Array
                (
                    [0] => Array
                        (
                            [event_name] => foo
                            [event_start_date] => 2009/02/01
                            [event_hours] => 2
                        )

                [1] => Array
                    (
                        [event_name] => bar
                        [event_start_date] => 2009/03/01
                        [event_hours] => 3
                    )

            )

    )

[2010] => Array
    (
        [total_hours] => 15
        [events] => Array
            (
                [0] => Array
                    (
                        [event_name] => manny
                        [event_start_date] => 2010/02/01
                        [event_hours] => 4
                    )

                [1] => Array
                    (
                        [event_name] => moe
                        [event_start_date] => 2010/03/01
                        [event_hours] => 5
                    )

                [2] => Array
                    (
                        [event_name] => jack
                        [event_start_date] => 2010/04/01
                        [event_hours] => 6
                    )

            )

    )

)

It should then be a fairly simple matter to use a foreach loop or two to output the data as desired.

[ging8]

I am pulling information from a query. here it is:

$sql = db_query('SELECT
civicrm_contact.first_name,
civicrm_contact.last_name,
civicrm_event.title,
civicrm_event.start_date,
civicrm_event.end_date,
civicrm_uf_match.uf_name,
civicrm_uf_match.uf_id,
civicrm_participant.status_id,
civicrm_value_total_hours_2.workshop_hours_4
FROM
{swiftrad_civicrm.civicrm_contact}
Inner Join {swiftrad_civicrm.civicrm_participant} ON civicrm_contact.id = civicrm_participant.contact_id
Inner Join {swiftrad_civicrm.civicrm_event} ON civicrm_participant.event_id = civicrm_event.id
Inner Join {swiftrad_civicrm.civicrm_uf_match} ON civicrm_uf_match.contact_id = civicrm_contact.id
Inner Join {swiftrad_civicrm.civicrm_value_total_hours_2} ON civicrm_value_total_hours_2.entity_id = civicrm_event.id
WHERE
civicrm_participant.status_id = 2
');

[ging8]

based on the array created, how do you now display the output in a formatted fashion?

[ging8]

I have the following multidimensional array

$sorted = array();
foreach($events as $event)
{
$year = date('Y', strtotime($event->start_date));
if(empty($sorted[$year]['total_hours']))
{
$sorted[$year]['total_hours'] = 0;
}
$sorted[$year]['event'][] = $event->title;
$sorted[$year]['event_start_date'][] = $event->start_date;
$sorted[$year]['event_hours'][] = $event->workshop_hours_4;
$sorted[$year]['total_hours'] += $event->workshop_hours_4;
}

With the year being dynamic, how would I output it to look something like the following

2007
EventID1 - 4 hours
EventID2 - 5 hours
TOTAL HOURS - 9 hours

2008
EventID3 - 5 hours
EventID4 - 2 hours
EventID5 - 3 hours
TOTAL HOURS - 10 hours

and so on.

Any suggestions would be great Thanks

[NogDog]

I'm a bit confused with your sort routine: is the $events array truly an array of objects? (Possible if you used something like mysql_fetch_object() to produce the data.) If so, I would modify it to:

$sorted = array();
foreach ($events as $event)
{
   $year = date('Y', strtotime($event->start_date));
   if (empty($sorted[$year]['total_hours']))
   {
      $sorted[$year]['total_hours'] = 0;
   }
   $sorted[$year]['event'][] = array(
      'title'      => $event->title,
      'start_date' => $event->start_date,
      'hours'      => $event->workshop_hours_4
   );
   $sorted[$year]['total_hours'] += $event->workshop_hours_4;
}

Then you could output it with the following, using your CSS stylesheet and the "event" class selector to adjust the visual presentation as desired:

foreach($sorted as $year => $data)
{
   echo "<div class='event'>\n<h3>$year</h3>\n";
   echo "<ul>\n";
   foreach($data['event'] as $fields)
   {
      printf("<li>&#37;s - %s</li>\n", $event['title'], $event['hours']);
   }
   echo "</ul>\n";
   echo "<h3>Total Hours: ".$data['total_hours']."</h3>\n</div>";  

}