Combining array entries with same date

[sctajc]

I have an array (simplified) loaded as such:

 

Date            budget    Actual

2008-01-01  120.00

2008-01-01                  80.00

2008-02-09                  120.00

2008-02-12      90.00 

2008-03-01    120.00

2008-03-01                  120.00

2008-03-05                    10.00

 

When there is both a 'budget' and 'actual' amount on the same date (eg 2008-01-01 & 2008-03-01), I am wanting to combine to one line (currently there will never be both 'actual' and 'budget' on same date). Had a look through available PHP array functions and felt there must be one that could do this but could not understand them well enough. Tried doing searches but not to sure what to search using.

 

I could try writing code in PHP to combine but a function would do a better job.

 

[RussellReal]

so you would like it to.. A) Add up all the budgets from same day.. and B) add up all the actuals from the same day.. than C) make it show the totals in each slot?

[sctajc]

Correct Russell. 'each slot' being each date.

[RussellReal]

okay...

 

<?php
$list = array();
$list[] = array('2008-01-01','120.00','');
$list[] = array('2008-02-09','','120.00');
$list[] = array('2008-01-01','','80.00');
// initial sorting loop..
$dates = array();
foreach ($list as $v) {
	if (!isset($dates[$v[0]])) {
		// if $dates['2008-01-01'] isn't set..
		$dates[$v[0]] = array();
	}
	$dates[$v[0]][] = array($v[1],$v[2]);
}
// once its all sorted BY DATE
$oneLines = array();
foreach ($dates as $date => $array) {
	$actual = 0;
	$budget = 0;
	foreach ($array as $v) {
		$budget += $v[0];
		$actual += $v[1];
	}
	$oneLines[] = array($date,$budget,$actual);
}
print_r($oneLines);
?>

[sctajc]

Thanks. Looks like I should be able to make it work. Will try to get back to it tomorrow

[sctajc]

Great stuff Russell. Once I got the brain in gear had it working in 10 minutes. I learnt something. Thanks.

[RussellReal]

no problemo click 'solved' tho