CRON jobs...

[cono1717]

I assume this is going to be CRON jobs unless you gurus can think of another way of doing this.

Basically I am making a sales tracking system that when a colleague submits a sale it cascades into daily and weekly, now the week numbers change every week (oddly enough) and I need a way of making the system know that the week number has changed.

I was thinking having a file called week.php with a variable in say $week which would equal "1" then in a weeks time the CRON job can add it by going to week.php?add=1 the problem is I don't know how to tell the CRON job to do that.

So basically how to I make cPanel visit week.php?add=1 every week automatically.

Thanks!

[chigley]

Huh? Seems like a silly way of doing things if you ask me.

Why not calculate what week it is using the time() function?

[cono1717]

Because that would mean me knowing what all our dates are and I don't need the start date just a number that the week is on i.e 1/1/2001 is week one 8/1/2001 is week 2.

All I need is the week number, I suppose the time and date thing would work as well but I had a nightmare trying to figure that one out last time.

[chigley]

What about something like this?

<?php

define('START_DATE', '1st January 2001');

function week_query($date)
{
	$diff = strtotime($date) - strtotime(START_DATE);
	$weeks = ($diff > 0) ? floor($diff / 604800) + 1 : 0;
	return $weeks;
}


echo week_query('8th January 2001'); // 2
echo week_query('1st February 2003'); // 109
echo week_query('8th January 2000'); // 0 (negative time difference always returns 0)

Something for you to play with at least

[cono1717]

You sir are simply amazing - the old thing I had got off a coding website was at least 15times as long as that. Just goes to show how good eXceemers are!

[chigley]

Originally Posted by cono1717

You sir are simply amazing - the old thing I had got off a coding website was at least 15times as long as that. Just goes to show how good eXceemers are!

Haha, no worries I'm not sure what exact format your dates are in, but you'll want to pay attention to this:

Originally Posted by PHP Manual strtotime()

Dates in the m/d/y or d-m-y formats are disambiguated by looking at the separator between the various components: if the separator is a slash (/), then the American m/d/y is assumed; whereas if the separator is a dash (-) or a dot (.), then the European d-m-y format is assumed.

To avoid potential ambiguity, it's best to use ISO 8601 (YYYY-MM-DD) dates or DateTime::createFromFormat() when possible.