weekstart dates of a year

[omerbutt]

hi,
i am working on a reservations component in joomla 1.6, i have to provide the client with a form where he can enter the door codes for the Lodges , the door code changes on every monday and remains the same for the whole week , the table that holds the door codes,is as follows.

id
code
date_start
date_end
 

the date_start holds the starting day's date for the week i.e Monday obviously and the date_end holds the last day's date of the week i.e Sunday.

Now in the add new door code i have to provide the client with a drop-down that contains the list of the dates of every weeks Starting date up to 3 year in the future.
Any idea how to calculate the total mondays in a year as i need to loop and the loop needs to run up to Total mondays in the selected year,
Regards,
Omer Aslam

[zorgi]

I would use time stamp for start date to make all calculations. Something like this:

$last_monday = strtotime("last Monday");
//7 days * 24 hours * 60 minutes * 60 seconds = 604800 seconds
$next_monday = $last_monday + 604800;

[omerbutt]

i changed it i provided the client with the drop down to select the year and then the month and after that i populated the drop down of all the dates for mondays in that particular month and year through ajax.
here is the core code for the weeks selection (Note: Joomla 1.6 component development)

public function getWeeks(){
        $month    =    JRequest::getVar('month');
        $year    =    JRequest::getVar('year');
        $total_weeks    =    6;
 
        $start_date    =    new DateTime(date('Y-m-d',strtotime('first monday of '.$year.'-'.$month.'-01'))) ;
        $end_date    =    new DateTime(date_format($start_date,'Y-m-d'));
 
        echo '<select name="weeks" id="weeks" onchange="putVal(this.value,\'date_start\');" class="required">';
        echo '<option value="none">Select a Monday</option>';    
        for($w=1; $w<=$total_weeks; $w++){
            echo '<option value="'.date_format($end_date,'Y-m-d').'">'.date_format($end_date,'Y-m-d').'</option>';    
            date_add($end_date, date_interval_create_from_date_string('7 days'));
            if(date_format($end_date,'m')!=date_format($start_date,'m')){
                break;
            }
        }
        echo '</select>';
    }
 

regards,
Omer Aslam