[RESOLVED] 12 month sliding scale

[scrupul0us]

Not sure if the title makes any sense so heres what I'm after

Given a set of links: Jan -> Dec

what I'm looking to do is this (based on today being in Jan)

Jan: ?m=1&y=2010
Feb: ?m=2&y=2009
Mar: ?m=3&y=2009
Apr: ?m=4&y=2009
May: ?m=5&y=2009
Jun: ?m=6&y=2009
Jul: ?m=7&y=2009
Aug: ?m=8&y=2009
Sep: ?m=9&y=2009
Aug: ?m=10&y=2009
Nov: ?m=11&y=2009
Dec: ?m=12&y=2009

As the year progresses you'll get to

Jan: ?m=1&y=2010
Feb: ?m=2&y=2010
Mar: ?m=3&y=2010
Apr: ?m=4&y=2010
May: ?m=5&y=2010
Jun: ?m=6&y=2010
Jul: ?m=7&y=2010
Aug: ?m=8&y=2010
Sep: ?m=9&y=2010
Aug: ?m=10&y=2010
Nov: ?m=11&y=2010
Dec: ?m=12&y=2009

once december is reached you'll have links for all 2010 and no 2009... once january comes youll have jan 2011 and all other will be 2010

what I'm currently working with is static and every link will always have the same year

			$months = array('Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec');
			//$nowMonth = date('j');
			//$nowYear = date('Y');
			echo '<ul id="ribbon">';
			echo '<li class="root">Overages</li>'."\n";
			$i=1;
			foreach ($months as $month)
			{
				echo '<li><a 
				href="javascript:void(0);" 
				onClick="javascript:doAction(\''.urlencode($getAction).'&amp;Month='.$i.'&amp;Year='.date('Y').'\')">'.$month.'</a></li>'."\n";
				$i++;				
			}
			echo '</ul>';

soo I'm trying to make it dynamic as I can't have (in Januarys instance) data for Feb 2010 but I have data for Feb 2009 through Dec 2009

Hope I explained it well enough

[johanafm]

	$format = "?\m=m&\a\m\p;\y=Y";
	$m = date('m');
	$y = date('Y');
	for ($i = 1; $i < 12; ++$i) {
		$d[] = date($format, mktime(12, 12, 12, $m-$i, 1, $y));
	}
	$d = array_reverse($d);
	array_unshift($d, date($format));

Should be able to do away with the array_reverse and unshift, but I'm too tired to come up with the fornula to get the correct indexing up front.

[scrupul0us]

I've adjusted to format as such:

<?php
$format = "?\m=n&\a\m\p;\y\e\a\\r=Y";
$m = date('m');
$y = date('Y');
for ($i = 1; $i < 12; ++$i) {
	$d[] = date($format, mktime(12, 12, 12, $m-$i, 1, $y));
}
$d = array_reverse($d);
array_unshift($d, date($format));

echo '<pre>';
print_r($d);
echo '</pre>';
?>

thanks a ton first off!

I'm rather impressed... Can you explain to me how the heck that works so it knows what month it's in and where to negate the years and so on... I'm confuzzled!

[johanafm]

Thanks, but the cred should go to the php developpers since I let mktime do all the year subtraction for me 🙂

// the backslashing is just to get actual letters instead of number of month or year...
$format = "?\m=n&\a\m\p;\y\e\a\\r=Y";

// todays month and year
$m = date('m');
$y = date('Y');
for ($i = 1; $i < 12; ++$i) {
   /* mktime does all the magic since it deals with out of range values for
     month and day. As such, just subtract from current month, and once it hits 0
     -1, -2 etc, mktime converts that to 12, 11, 10 with year being one less.
      Same way it turns mktime(12, 12, 12, 1, 32, 2010) into 1 Feb, 2010 */
   $d[] = date($format, mktime(12, 12, 12, $m-$i, 1, $y));
}
// But since we start by inputting last month, then two months ago...  and you wanted the list ordered by month, reverse it
$d = array_reverse($d);
// ...and then put todays month in fron
array_unshift($d, date($format));

[Weedpacket]

I say all the following without knowing the context where this will be used, but I'm just wondering if it would be better UI to have the dates in chronological order; and perhaps either emphasise the current month in some way or visually distinguish this year's months from last year's.

[scrupul0us]

@: excellent explanation

@weed: when you click on each link, the header of the content area will specify the month year currently in view as well as fwd, rev links

I'm sure there's a more intuitive method but this is how the client spec'd the functionality so at this point it's what they are getting =)

[scrupul0us]

Well I'm having an issue where by now that we are in February, the output is:

Array
(
    [0] => Month=2&Year=2010
    [1] => Month=3&Year=2009
    [2] => Month=4&Year=2009
    [3] => Month=5&Year=2009
    [4] => Month=6&Year=2009
    [5] => Month=7&Year=2009
    [6] => Month=8&Year=2009
    [7] => Month=9&Year=2009
    [8] => Month=10&Year=2009
    [9] => Month=11&Year=2009
    [10] => Month=12&Year=2009
    [11] => Month=1&Year=2010
)

see how month 1 has moved to the end of the array? I need the monthly order to be 1-12

[scrupul0us]

well I guess you could say this works, but it seems awefully 'dirty'

<?php 
$format = "\M\o\\n\\t\h=n&\a\m\p;\Y\e\a\\r=Y"; //OUTPUT FORMAT  

$m = date('m');  

$y = date('Y');  

for ($i = 1; $i < 12; ++$i) {  

 $d[] = date($format, mktime(12, 12, 12, $m-$i, 1, $y));  

}  

$d = array_reverse($d);
array_unshift($d, date($format));

for ($j=1; $j<$m; $j++)
{
 $pop = array_pop($d);
 array_unshift($d,$pop);
}


echo '<pre>';
print_r($d);
echo '</pre>';
?>

[johanafm]

Just another thought. Perhaps a bit more straightforward.

$format = "\M\o\\n\\t\h=n&\a\m\p;\Y\e\a\\r=Y"; //OUTPUT FORMAT  

$m = date('m');
$y = date('Y');
$dates = array();
for ($i = 1; $i < 13; ++$i) {
	if ($i == $m + 1)
		--$y;
	$dates[] = date($format, mktime(12, 0, 0, $i, 1, $y));
}