[RESOLVED] Anyone good with arrays and reordering?

kbc1

Below is a typical example of an array of data that my system stores. The array contains two arrays of flight data for a single passenger (passenger id 9317 in this example)

Array
(
    [16282] => Array
        (
            [id] => 16282
            [bookingpassengerid] => 9317
            [outflightnumber] => LY403
            [outdepartdate] => 2012-04-18
            [outdeparttime] => 12:15:00
            [outarrivaltime] => 13:15:00
            [outdepartfrom] => TLV
            [outarriveto] => ETH
            [indeparturedate] => 2012-04-22
            [indeparturetime] => 09:30:00
            [inarrivaltime] => 10:30:00
            [indepartfrom] => ETH
            [inarriveto] => TLV
            [inflightnumber] => LY402
        )

[16280] => Array
    (
        [id] => 16280
        [bookingpassengerid] => 9317
        [outflightnumber] => LY 318
        [outdepartdate] => 2012-04-17
        [outdeparttime] => 22:30:00
        [outarrivaltime] => 05:20:00
        [outdepartfrom] => LHR
        [outarriveto] => TLV
        [indeparturedate] => 2012-04-25
        [indeparturetime] => 17:25:00
        [inarrivaltime] => 20:50:00
        [indepartfrom] => TLV
        [inarriveto] => LHR
        [inflightnumber] => LY317
    )

)

I need to be able to order the output of the array so the [outdepartdate] value (and its other related key/value pairs) are displayed in date order.

So the outcome of re-ordering the data above would be that the:

[16280] [outdepartdate] => 2012-04-17

Would be displayed first along with all of the other key/value pairs from [16280] that begin with [out...

The plan is then to do the same but with the keys that begin with [in...

Is this possible?

Thanks for reading.

niroshan

Hi kbc1,

Is this what you want?

<?php
$aa[16282]['id'] = 16282;
$aa[16282]['bookingpassengerid'] = 9317;
$aa[16282]['outflightnumber'] = 'LY403';
$aa[16282]['outdepartdate'] = '2012-04-18';
$aa[16282]['outdeparttime'] = '12:15:00';
$aa[16282]['outarrivaltime'] = '13:15:00';
$aa[16282]['outdepartfrom'] = 'TLV';
$aa[16282]['outarriveto'] = 'ETH';
$aa[16282]['indeparturedate'] = '2012-04-22';
$aa[16282]['indeparturetime'] = '09:30:00';
$aa[16282]['inarrivaltime'] = '10:30:00';
$aa[16282]['indepartfrom'] = 'ETH';
$aa[16282]['inarriveto'] = 'TLV';
$aa[16282]['inflightnumber'] = 'LY402';
$aa[16280]['id'] = 16280;
$aa[16280]['bookingpassengerid'] = 9317;
$aa[16280]['outflightnumber'] = 'LY 318';
$aa[16280]['outdepartdate'] = '2012-04-17';
$aa[16280]['outdeparttime'] = '22:30:00';
$aa[16280]['outarrivaltime'] = '05:20:00';
$aa[16280]['outdepartfrom'] = 'LHR';
$aa[16280]['outarriveto'] = 'TLV';
$aa[16280]['indeparturedate'] = '2012-04-25';
$aa[16280]['indeparturetime'] = '17:25:00';
$aa[16280]['inarrivaltime'] = '20:50:00';
$aa[16280]['indepartfrom'] = 'TLV';
$aa[16280]['inarriveto'] = 'LHR';
$aa[16280]['inflightnumber'] = 'LY317';


while(list($key, $val) = each($aa))
{
	$date = $val['outdepartdate'];
	$dateArr = explode('-', $date);
	$sortKey = mktime(0,0,0, $dateArr[1], $dateArr[2], $dateArr[0]);

$sort[$sortKey] = $key;	
}

ksort($sort);
$sortedArr = array();
while(list($key, $val) = each($sort))
{
	$sortedArr[$val]['outdepartdate'] = $aa[$val]['outdepartdate'];
	$sortedArr[$val]['outdeparttime'] = $aa[$val]['outdeparttime'];
	$sortedArr[$val]['outarrivaltime'] = $aa[$val]['outarrivaltime'];
	$sortedArr[$val]['outdepartfrom'] = $aa[$val]['outdepartfrom'];
	$sortedArr[$val]['outarriveto'] = $aa[$val]['outarriveto'];

}

echo '<pre>';
print_r($sortedArr);
?>

Best regards,
Niroshan

bradgrafelman

Seems like it would be much simpler/cleaner to use [man]array_multisort/man (this type of sorting is, after all, exactly what that function was designed to do):

// continuing from niroshan's code above after he defines the $aa array:
foreach($aa as $id => $subarray)
    $dates[$id] = $subarray['outdepartdate'];

array_multisort($dates, SORT_DESC, $aa);

// $aa is now sorted by the 'outdepartdates' values; simply loop through it
//   (e.g. with a foreach() loop) and output the items in order

leatherback

An even neater solution woudl be to store the data in a database, and retreive the data sorted the way you need them..

Derokorian

You could also use usort() to use a user defined sorting function:

function sortByDepartdate($a,$b) {
   $a = strtotime($a['outdepartdate']);
   $b = strtotime($b['outdepartdate']);
   return ($a > $b ? 1 : $a < $b ? -1 : 0;
}

usort($aa,'sortByDepartdate');

Even better you could easily adapt it to handle ordering by departtime in the event its the same date:

function sortByDepartdate($a,$b) {
   $a = strtotime($a['outdepartdate'] .' '. $a['outdeparttime']);
   $b = strtotime($b['outdepartdate'] .' '. $b['outdeparttime']);
   return ($a > $b ? 1 : $a < $b ? -1 : 0;
}

usort($aa,'sortByDepartdate');

kbc1

Hi guys

Thank you so much for all your advice, its greatly appreciated and another reason why this is the best forum for PHP help!

niroshan, I implemented your soluiton first and its seemed to do the trick hence my thanks on here. I will apply the other techniques as well just to see how each one works.

Thanks again.