[RESOLVED] sorting multidimensional array

hiflyerx

Just working on a iCal displayer, but I need to be able to output the events chronologically.

Right now, they output based on their event number, which is based on when the event was created...

This is the beginning of $iCaltoArray:

I would like to sort the data based on $iCaltoArray[$key][$event]['DTSTART']

Right now I only have 2 foreach loops generating the data:

		foreach ($iCaltoArray as $key => $inner_array){

and then
			foreach ($iCaltoArray[$key] as $event => $innerarray2){

MUCH MUCH thanks!

Weedpacket

There's [man]array_multisort[/man], but I find that [man]usort[/man] tends to be clearer.

hiflyerx

sigh looked at all the examples, but I'm lost

date("D M d, Y", strtotime($iCaltoArray[$key][$event]['DTSTART']));

yeah, lost

it would almost have to change the $event number (which doesn't matter)
to reflect which one comes first, second, third, etc...

Weedpacket

One thing that's not entirely clear: you have a three-dimensional array and you're trying to sort on something in the third dimension.

If $iCaltoArray['person.ics'][3]['DTSTART'] = "20090221T193000Z" and $iCaltoArray['somethingelse.ics'][4]['DTSTART'] = "20090221T163000Z" (which is earlier) and $iCaltoArray['person.ics'][6]['DTSTART'] = "20090221T063000Z" (which is earlier still), do you want:

['person.ics'][6]['DTSTART']
['person.ics'][3]['DTSTART']

....
['somethingelse.ics'][4]['DTSTART']

(i.e., person.ics sorted separately from somethingelse.ics), or

['person.ics'][6]['DTSTART']
['somethingelse.ics'][4]['DTSTART']
['person.ics'][3]['DTSTART']

(mixing them all together, which would mean trashing some of the structure that this data has, perhaps by making 'person.ics' etc., an additional element in the third dimension)? Either could be done, but how depends on the requirements.

Is it possible to sort this data before/when building this array?

But: assuming the first case, where each array in $iCaltoArray[$key] is to keep to itself and not go mixing with the others....

function sort_by_dtstart($a, $b)
{
    // One of the design features of ISO-formatted dates is
    // that they sort correctly when treated as strings.
    return strcmp($a['DTSTART'], $b['DTSTART']);
}


foreach($iCaltoArray as &$event)
{
    usort($event, 'sort_by_dtstart');
}

hiflyerx

they would be sorted by each person 🙂

So sorted by [person1.ics][event][DTSTART]

And this function totally rocks it!

I just put it right at the beginning of the function, after the data's been pulled and voila!

Much, Much Much Thanks!

One issue - now whoever is last in the list gets no data displayed!

As well, if there is only one person, no data is displayed!

I tried commenting out the sorting code - and they come back....!

wierd!

hiflyerx

hello again
can't edit my older post 🙁


foreach($iCaltoArray as &$event)
{
    usort($event, 'sort_by_dtstart');
}

I can't find anything on why you used & before $event?

Thanks again for you help!

Muchly appreciated!

hiflyerx

PS, I started with this script which I am modifying 😉

http://www.phpclasses.org.icontem.com/browse/package/4197.html

Weedpacket

Oh; otherwise $event would only be a copy of the element in $iCaltoArray; the original wouldn't be touched. Which would be kind of pointless 🙂 (see [man]foreach[/man]).
The loop could also be written

foreach($iCaltoArray as $key=>$event)
{
    usort($event, 'sort_by_dtstart');
    $iCaltoArray[$key] = $event;
}

hiflyerx

Thanks, I'm trying to learn 🙂

Any hints on why the last (or only) dataset is missing?

Just did a print_r of the array before & after sorting...

both had 17 events, but after sorting I get no data output!

		//start with the people
		foreach ($iCaltoArray as $key => $inner_array){

		foreach ($iCaltoArray[$key] as $event => $innerarray2){

Am I 'calling' the second foreach properly then?
Something tells me no...

Thanks weedpacket for all your help!

Weedpacket

Looks reasonable from what I can see. I presume the loop in full reads:

foreach ($iCaltoArray as $key => $inner_array){
	foreach ($iCaltoArray[$key] as $event => $innerarray2){
		usort('sort_by_dtstart', $innerarray2);
		$iCaltoArray[$key][$event'] = $innerarray2;
	}
}

hiflyerx

I had it setup like this:

	function BigDaddy($startdate, $enddate) {

	//was adapted from iCalReader
	$array = $this->iCalList();
	foreach ($array as $icalfile) {
		$iCaltoArray[$icalfile] = $this->iCalDecoder($icalfile);
	}

	// now sort the data by the date
	// from weedpacket


	foreach($iCaltoArray as &$event){
    	        usort($event, 'sort_by_dtstart');
	} 

	//start with the people
	foreach ($iCaltoArray as $key => $inner_array){

		// person.ics -> person
		$person=substr($key, 0, -4);

		// start to draw the table			
		echo '<table width="100%" border ="0" cellspacing="0" cellpadding="2">';

		// First Row is their Name			
		echo '<tr><td colspan="10" class="name">'.$person.'</td></tr>';

		// Now start populating the data with each person's data
		//$countme used to only show headings
		$countme = 0;

			foreach ($iCaltoArray[$key] as $event => $innerarray2){

			// populate table

			// whole wack of code goes here...

...

Thanks!

hiflyerx

aand it's fixed - totally my bad!

somehow missed the one line in the foreach you originally supplied!

foreach($iCaltoArray as $key=>$event)
{
    usort($event, 'sort_by_dtstart');
    $iCaltoArray[$key] = $event;
}