annual leave calculation

fuii_koh

is it possible to write a php code about the leave for a staff?
like the usaul ompany, after two years work a staff will get the bonus leave 1 day in third year........and fourth years have 2 days bonus leave........

thank you.......

Frederick

the code will be something like:
Lets say you are storing the employees hire date as 6 (072401) digit number, no forward slashes.

$sql = mysql_query("SELECT * FROM employees WHERE id=$id")
or die(mysql_error());
$row = mysql_fetch_array($sql);

$hireDate = $row["hireDate"];
$bonusDays = $row["bonusDays"];

$currentDate = date("mdy");

$temp1 = $hireDate + 2;
$temp2 = $hireDate + 4;

$overTwo = $bonusDays + 1;
$overFour = $bonusDays + 2;

if ($currentDate >= $temp1 && $currentDate < $temp2) {
    $sql = mysql_query("UPDATE employees SET bonusDays='$overTwo' WHERE id=$id")
    or die(mysql_error());
} else
if ($currentDate >= $temp2) {
    $sql = mysql_query("UPDATE employees SET bonusDays='$overFour' WHERE id=$id")
    or die(mysql_error());
}

fuii_koh

thanks first here,

can u show the code in this way....

lets say a staff worked at xx company 10 already and he basic leave is 18, after 2 years work will started add the leave 1 day per year. and the total leave he has now is 26 days.(18+(10years-2years==26)

how to count it continuously?

fuii_koh

this is my code without counting the years.....
if i add a empty fields to give the staff fill in when they r join this company in a year format.e.g 1999.
then how can i add this function into this coding and also this is where im very clear about it.
can u do a correction to me pls?

<?php
function count_workdays($date1,$date2){
$firstdate = strtotime($date1);
$lastdate = strtotime($date2);
$firstday = date(w,$firstdate);
$lastday = date(w,$lastdate);
$totaldays = intval(($lastdate-$firstdate)/86400)+1;

//check for one week only
if ($totaldays<=7 && $firstday<=$lastday){
$workdays = $lastday-$firstday+1;
//check for weekend
if ($firstday==0){
$workdays = $workdays-1;
}
if ($lastday==6){
$workdays = $workdays-1;
}

}else { //more than one week

//workdays of first week
if ($firstday==0){
//so we don't count weekend
$firstweek = 5;
}else {
$firstweek = 6-$firstday;
}
$totalfw = 7-$firstday;

//workdays of last week
if ($lastday==6){
//so we don't count sat, sun=0 so it won't be counted anyway
$lastweek = 5;
}else {
$lastweek = $lastday;
}
$totallw = $lastday+1;

//check for any mid-weeks
if (($totalfw+$totallw)>=$totaldays){
$midweeks = 0;
} else { //count midweeks
$midweeks = (($totaldays-$totalfw-$totallw)/7)*5;
}

//total num of workdays
$workdays = $firstweek+$midweeks+$lastweek;

}

/
check for and subtract and holidays etc. here
...
/

return ($workdays);
} //end funtion count_workdays()

$date1 = "$FromDate";
$date2 = "$ToDate";
$entitlement = 18;
$leave_to_date = 0;

* is it here am i going to start?********

$balance = $entitlement - $leave_to_date - $Duration;

echo $Duration ;