How to make PHP Programs run fast

[otixz]

Hello,

I made a PHP Program that generates report.
my only problem is it generates report for more than 30 mins when I try to access 150 employees and calculate its DTR.
Can anyone of you recommend me how too make my program run fast? Is there any code / program that I must use?

I hope someone can help me on this.
Thank you very much and have a nice day!

[NogDog]

There is no "magic wand" or "silver bullet" that will somehow miraculously make any code run faster. Without any idea of what your application is doing and how it is doing it, I doubt anyone could make a specific suggestion. My best guess is that you are doing an inordinate amount of database queries and/or very inefficient queries, possibly of a poorly designed/configured database. But again, that's purely speculation on my part without more information to go on.

[otixz]

Thanks Sir... maybe your advice is right. I'll check my codes again.

[Piranha]

Another possible cause is to let PHP do work that the database does better. But post the code and people can look at it and come with suggestions about how to do it faster.

[otixz]

Thank you very much Sir.

Any way, here is my code...

<?
set_time_limit(0);
include('globals/functions.php');
include('include/dbConnect.php');
//page title
$pageTitle = "Employee Breaks Report";
//get GET variables :
if (isset($_GET['dept']) || isset($_GET['emp']) ||
	isset($_GET['frmDate']) || isset($_GET['toDate'])){
	$FromDate 	= $_GET['frmDate'] . " 00:00:00 ";
	$ToDate 	= $_GET['toDate'] . " 23:59:59 ";
	$Department = $_GET['dept'];
	$Employee	= $_GET['emp'];
}
else{
	$Deparment = $_SESSION['DeptID'];
	$Employee = $_SESSION['UserID'];	
}
//get substring of date range then print
$FromMonthNumber = substr($FromDate,5,2);
$FromDayNumber = substr($FromDate,8,2);
$ToMonthNumber = substr($ToDate,5,2);
$ToDayNumber = substr($ToDate,8,2);
$ToYearNumber = substr($ToDate,0,4);
$DateRange = date("F",mktime(0,0,0,$FromMonthNumber+1,0,0)) . " " . 
$FromDayNumber . " to " . date("F", mktime(0,0,0,$ToMonthNumber+1,0,0)) ." " . 
$ToDayNumber ." ". $ToYearNumber; 

$Start = $_GET['frmDate'];
$End = $_GET['toDate'];

//GET DIFFERENCE OF Start and End Date
$days = (strtotime($End) - strtotime($Start)) / (60 * 60 * 24) ;
$conn = connect();

//get All employees of all department
if (($Department == "--") && ($Employee == "--")){
	$rsAllDeptEE = array();
	$rsAllDeptEE = getDeptEmployees();
}elseif (($Department <> "--") && ($Employee == "--")){
	$rsAllDeptEE = array();
	$rsAllDeptEE = getEmployeesPerDept($Department);
}elseif (($Department == "") && ($Employee == "")){
$rsAllDeptEE = array();
$rsAllDeptEE = getEmployeesPerDept($Department);

}elseif (($Department <> "--") && ($Employee <> "--")) {
	$rsAllDeptEE = array();
	$rsAllDeptEE = getSpecificEE($Department, $Employee);
}
/*
function to get all employees 
Fri Nov 03 10:19:13 CST 200610:19:13
Comment by : KarenF
*/

function getDeptEmployees(){
	$qry = "SELECT		d.objectID,
						d.objectDesc,
						u.fldUserID,
						u.fldlastName,
						u.fldfirstName,
						CONCAT(fldlastName, ' ', fldfirstName) as Name
			FROM 		actatek_objects d
			INNER JOIN  actatek_usermaintenance u
			ON 			d.objectID = u.flddepartmentID
			WHERE 		u.fldStatus = 'A'
			AND			u.fldadminLevel = 'PERSONALUSER'
			AND			d.objectType='Department'
			ORDER BY 	Name";
	$qryRes = mysql_query($qry);
	if ($qryRes){
		for ($i=0;$i<mysql_num_rows($qryRes);$i++){
			$rs[] = mysql_fetch_assoc($qryRes);
		}
		return $rs;
	}	
}


/*
function to get F1 and F2 timeentries
Fri Nov 03 10:19:13 CST 200610:19:13
Comment by : KarenF
input : $from, $to, $employee
return : $from, $to, $employee
*/
function getF1andF2($TimeFrom,$TimeTo,$ee){
	mysql_connect('localhost', 'root', '') or die(mysql_error());
	mysql_select_db('actatek_agent') or die(mysql_error());

 $qry = "SELECT	timeentry as logs,
	 			eventID as event
	 	FROM 	actatek_logs 
		WHERE 	(eventID='F1' OR eventID='F2') 
		AND 	timeentry 
		BETWEEN '$TimeFrom'  AND '$TimeTo' 
		AND userID='$ee' 
		ORDER BY timeentry ASC";
$result = mysql_query($qry);
$GLOBALS['count'] = mysql_num_rows($result);

if($result){

	for($i=0;$i<mysql_num_rows($result);$i++){

		$rs[$i] = mysql_fetch_array($result);			
	}
	return $rs;


}
}

function gets($TimeFrom,$TimeTo,$ee){
			mysql_connect('localhost', 'root', '') or die(mysql_error());
				mysql_select_db('actatek_agent') or die(mysql_error());



			$qry3="SELECT	timeentry as logs,
	 			eventID as event, count(left(timeentry,10))
			 as numberofbreaks 
			 	FROM 	actatek_logs 
				WHERE 	eventID='F2' 
				AND 	timeentry 
				BETWEEN '$TimeFrom'  AND '$TimeTo' 
				AND userID=$ee group by left(timeentry,10)  having (eventID='F1' 
			 	or eventID='F2') 
				ORDER BY timeentry ASC";

			$qryresult=mysql_query($qry3);
		$GLOBALS['count2']=mysql_num_rows($qryresult);				
		if($qryresult){
		for($i=0;$i<mysql_num_rows($qryresult);$i++){
		$rs2[$i] = mysql_fetch_array($qryresult);
		}
		return $rs2;
		}

}


?>

<html>
<head>
	<title><?=$pageTitle;?></title>
	<link href="css/actatek.css" rel="stylesheet" type="text/css">
</head>
<body bgcolor="#FFFFFF" leftmargin="5" topmargin="15" marginwidth="0" marginheight="0">
<form id="BreaksFrm">
<table align="center" border="1" cellpadding="0" cellspacing="0" width="700">
	<tr><td align="center" class="Reporttitle"><b><?=$pageTitle;?></b></td></tr>
	<tr><td align="center" class="Reporttitle"><b><?=$DateRange;?></b></td></tr>
</table><br>
<table align="center" width="700" cellpadding="0" cellspacing="0" border="1" bordercolor="#C9C8C9" style="border-collapse: collapse;">
	<tr>
		<td>
			<table align="center" width="700" cellpadding="0" cellspacing="0" border="1" bordercolor="#C9C8C9" style="border-collapse: collapse;">
				<tr bgcolor="#CCCCCC">
					<td width="100" class="sideTitle" align="center">Last Name</td>
					<td width="100" class="sideTitle" align="center">First Name</td>
					<td width="100" class="sideTitle" align="center">Date</b></td>
					<td width="100" class="sideTitle" align="center">Door Exit</td>
					<td width="100" class="sideTitle" align="center">Door Entry</td>
					<td width="100" class="sideTitle" align="center">Duration</td>
					<!--<td width="100" class="sideTitle" align="center">No. of Breaks</td>-->
				</tr>
				<?





//get F1s and F2s
foreach ($rsAllDeptEE as $id=>$deptEE) {

$rsBreaks = array();
$rsBreaks = getF1andF2($FromDate, $ToDate, $deptEE['fldUserID']);
$rs2getArr = array();
$rs2getArr = gets($FromDate, $ToDate, $deptEE['fldUserID']);



//Initialize Variables//
$brkCount = 0;
$hours	= 0; $mins = 0; $secs = 0;
/********************/
for ($i=0;$i<$GLOBALS['count'];$i++){
	$breaks = $rsBreaks[$i];
	$gs = $rs2getArr[$i];
	//print_r($gs);
	//echo substr($rs2getArr[1],11);	



	echo "<tr>";
	//print lastName
	echo "<td class=\"report\">".$deptEE['fldlastName']."</td>";

	//print firstName
	echo "<td class=\"report\">".$deptEE['fldfirstName']."</td>";
	//print date
	echo "<td class=\"report\">".substr($breaks[0],0,11)."</td>";

	if ($breaks[1] == 'F1')
	{

		//print door exit
		echo "<td class=\"report\">".substr($breaks[0],11,18)."</td>";
		$F1 = substr($breaks['logs'],11,18);

		//print door entry

		$i++;
		$breaks = $rsBreaks[$i];
		$gs = $rs2getArr[$i];



		if ($breaks[1] == 'F2')
		{


			echo "<td class=\"report\">".substr($breaks[0],11,18)."</td>";
			$F2 = substr($breaks[0],11,18);
			$duration = getDifference($F2, $F1);
			$brkCount = $brkCount + count($duration);
			$expDuration = explode(":", $duration['difference']);

			$hours = $hours + $expDuration[0];
			$mins = $mins + $expDuration[1];
			$secs = $secs + $expDuration[2];



			$gs = $rs2getArr[$i];

			echo "<td class=\"report\">".$duration['difference']."</td>";							

		}
		else
		{ 
			$i--;
			echo  "<td>&nbsp;</td>";
			echo  "<td>&nbsp;</td>";
		}	
	}
	else 
	{
		//if F1 is blank, print blank
		echo  "<td>&nbsp;</td>";
		//print F2
		echo "<td class=\"report\">".substr($breaks[0],11,18)."</td>";
		$F2 = substr($breaks[0],11,18);
		$brkCount = $brkCount + count($duration);
		echo "<td>&nbsp;</td>";
	}

	echo "</tr>";	

			//total count of breaks
			$totalBrkCnt = $GLOBALS['count'] - $brkCount;
			//total duration of breaks
			$totDuration = getDuration($hours, $mins, $secs);		

}


}	
echo "</table>";	
echo "<tr>";	
	echo "<td><b>Total Number of breaks:&nbsp;&nbsp;&nbsp;$totalBrkCnt</td>";
	echo "</tr>";	
	echo "</table>";				
?>			
</body>
</form>

As for what Sir NogDog said, maybe my queries are not good...(for situation if (($Department == "--") && ($Employee == "--")), I still go to the getDeptEmployees() function to get all of the employees and get the array of it then go to another query getF1andF2() and gets() before it calculates its data.

Do you think there's some other way to improve this code?
And one more question!

How can I calculate for the total number of breaks? I tried using the $totalBrkCnt but it is only applicable for one record only...

Please help...
Thank you very much

[Piranha]

I have gone through the code pretty fast, and here is the strange things that I can find:

// row 8
if (isset($_GET['dept']) || isset($_GET['emp']) ||
    isset($_GET['frmDate']) || isset($_GET['toDate'])){
// I think it should be the following:
if (isset($_GET['dept']) && isset($_GET['emp']) &&
    isset($_GET['frmDate']) && isset($_GET['toDate'])){

And then you can check that the values are not empty. If any of the dates is empty you will probably get to much information back.

Look at [man]mysql_real_escape_string[/man] to aviod problems.

// row 89 and 116
    mysql_connect('localhost', 'xxxx', 'xxxx') or die(mysql_error());
    mysql_select_db('actatek_agent') or die(mysql_error());
// but on row 4 you already have opened a database connection
include('include/dbConnect.php');

If it is the same database and the same user there is no need to open another connection. In fact, if all the database connections are already taken then it will probably normally time out, but in your case it will just wait. Another thing is that you never close that DB connection (and not the first one either).

But the real problem with your code is probably that it tries to do to much. I would (if the customer would agree) do one code to get the total time for each employee within a timeframe, that could easily be done with one query. And another page that gets all times for one employee. As it is now you can have 1000 employees, one year and 3 breaks per employee per day. That would equal more than half a million rows and 2000 queries. Not that strange that it is slow.

[otixz]

Thank you very much Sir,
Indeed, your advice made me improve myself.
The Breaks report is now ok...
I also tried changing the codes of row 8 in my other reports like in our lates and undertime report. IF you have time, can you browse through my codes? I would really want to know if you can give me some of your pointers for me to improve my codes.

Also, the generation of this report is very slow... I think our customers really wants to have the 1 month timeline for their report.

I will wait for your reply Sir. Thank you very much

<?
set_time_limit(0);
include('globals/functions.php');
include('include/dbConnect.php');
//page title
$pageTitle = "Employee Lates and Undertime Report";
//get GET variables :
//if (isset($_GET['dept']) || isset($_GET['emp']) ||
//	isset($_GET['frmDate']) || isset($_GET['toDate'])){

if (isset($_GET['dept']) && isset($_GET['emp']) &&
    isset($_GET['frmDate']) && isset($_GET['toDate'])){

$FromDate 	= $_GET['frmDate'] . " 00:00:00 ";
$ToDate 	= $_GET['toDate'] . " 23:59:59 ";
$Department = $_GET['dept'];
$Employee	= $_GET['emp'];
}
else{
	$Deparment = $_SESSION['DeptID'];
	$Employee = $_SESSION['UserID'];	
}
//get substring of date range then print
$FromMonthNumber = substr($FromDate,5,2);
$FromDayNumber = substr($FromDate,8,2);
$ToMonthNumber = substr($ToDate,5,2);
$ToDayNumber = substr($ToDate,8,2);
$ToYearNumber = substr($ToDate,0,4);
$DateRange = date("F",mktime(0,0,0,$FromMonthNumber+1,0,0)) . " " . 
$FromDayNumber . " to " . date("F", mktime(0,0,0,$ToMonthNumber+1,0,0)) ." " . 
$ToDayNumber ." ". $ToYearNumber; 

$Start = $_GET['frmDate'];
$End = $_GET['toDate'];

//GET DIFFERENCE OF Start and End Date
$days = (strtotime($End) - strtotime($Start)) / (60 * 60 * 24) ;
$conn = connect();

//get All employees of all department
if (($Department == "--") && ($Employee == "--")){
	$rsAllDeptEE = array();
	$rsAllDeptEE = getDeptEmployees();
}elseif (($Department <> "--") && ($Employee == "--")){
	$rsAllDeptEE = array();
	$rsAllDeptEE = getEmployeesPerDept($Department);
}elseif (($Department <> "--") && ($Employee <> "--")) {
	$rsAllDeptEE = array();
	$rsAllDeptEE = getSpecificEE($Department, $Employee);
}
?>

<html>
<head>
	<title><?=$pageTitle;?></title>
	<link href="css/actatek.css" rel="stylesheet" type="text/css">
</head>
<body bgcolor="#FFFFFF" leftmargin="5" topmargin="15" marginwidth="0" marginheight="0">
<table align="center" border="1" cellpadding="0" cellspacing="0" width="890" >
	<tr><td align="center" class="Reporttitle"><?=$pageTitle;?></td></tr>
	<tr><td align="center" class="Reporttitle"><?=$DateRange;?></td></tr>
</table><br>
<table align="center" width="890" cellpadding="0" cellspacing="0" border="1" bordercolor="#C9C8C9" style="border-collapse: collapse;">
	<tr>
		<td>
			<table align="center" width="890" cellpadding="0" cellspacing="0" border="1" bordercolor="#C9C8C9" style="border-collapse: collapse;">
				<tr>
					<td width="100" class="sideTitle" align="center">Last Name</td>
					<td width="100" class="sideTitle" align="center">First Name</td>
					<td width="111" class="sideTitle" align="center">Shift</td>
					<td width="111" class="sideTitle" align="center">Date</td>
					<td width="100" class="sideTitle" align="center">Time-In</td>
					<td width="100" class="sideTitle" align="center">Time-Out</td>
					<td width="111" class="sideTitle" align="center">Late</td>
					<td width="100" class="sideTitle" align="center">Undertime</td>
				</tr>
				<?
				foreach ($rsAllDeptEE as $id=>$deptEE){
					//initialize variables
					$cntrLate = 0; $cntrUndertime = 0;
					//for late
					$hours = 0; $mins = 0; $secs = 0;
					//for undertime
					$hour = 0; $min = 0; $sec = 0;
					for($i=0;$i<=$days;$i++){
						$rowspan = $days + 1;
						$today = $i * (60*60*24) + strtotime($Start);
						$todayPlusOneDay = $i * (60*60*24) + strtotime($Start) + (60*60*24);
						$strTodayPlusOneDay = strftime("%Y-%m-%d",$todayPlusOneDay);
						$todayTime = strftime("%Y-%m-%d",$today);
						$todayTimeFrom = date("Y-m-d H:i:s D",mktime(0,0,0,substr($todayTime,5,2),substr($todayTime,8,2),substr($todayTime,0,4)));
						$todayTimeTo = date("Y-m-d H:i:s D",mktime(23,59,59,substr($todayTime,5,2),substr($todayTime,8,2),substr($todayTime,0,4)));	
						echo "<tr>";
						//print lastName
						echo "<td class=\"report\">".$deptEE['fldlastName']."</td>";
						//print firstName
						echo "<td class=\"report\">".$deptEE['fldfirstName']."</td>";
						//print shift
						$getshift = getShift($deptEE['fldUserID'], $todayTime);
						if ($getshift != ""){
							$shift_desc = $getshift['shift_description'];
						}else {
							$shift_desc = "--";
						}
						echo "<td class=\"report\">" .$shift_desc. "</td>";
						//get Shift Start
						$shift_start = $getshift['shift_start'];
						$GLOBALS['shift_start'] = $shift_start;
						//shift start with date
						$GLOBALS['shift_start_date'] = $todayTime . " " . $shift_start; 
						//get Shift End
						$shift_end = $getshift['shift_end'];
						$GLOBALS['shift_end'] = $shift_end;
						//shift end with date
						//get mktime of 3 pm for shifts more than 3 pm
						$mkShiftEnd3pm = mktime(15,0,0,0,0,$ToYearNumber);
						$strShiftEnd3pm = strftime("%H:%M:%S",$mkShiftEnd3pm);
						if ($GLOBALS['shift_start'] < $strShiftEnd3pm){
							$GLOBALS['shift_end_date'] = $todayTime . " " . $shift_end;	
						}
						elseif ($GLOBALS['shift_start'] >= $strShiftEnd3pm){
							$mkTimeToPlusOne = mktime(substr($shift_end,0,2),substr($shift_end,6,2),substr($shift_end,4,2),substr($todayTime,5,2),substr($todayTime,8,2),substr($todayTime,0,4)) + (60*60*24);	
							$strTimeToPlusOne = strftime("%Y-%m-%d %H:%M:%S", $mkTimeToPlusOne);
							$GLOBALS['shift_end_date'] = $strTimeToPlusOne;	
						}
						//print date
						echo "<td class=\"report\">" .date("Y-m-d D", $today). "</td>";
						//get weekend
						$weekend = mktime(0,0,0,substr($todayTime,5,2),substr($todayTime,8,2),substr($todayTime,0,4));		
						$SatSun = getdate($weekend);

					//get EE Time-In
					$timeIN = gettimein($todayTimeFrom,$todayTimeTo,$deptEE['fldUserID']);
					if(($SatSun["wday"]==0 || $SatSun["wday"]==6) && ($timeIN['timeIN'] == null)){
						$shift_in = " ";
				     	echo "<td>$shift_in</td>";	
				    }
					elseif (($SatSun["wday"]<>0 || $SatSun["wday"]<>6) && (substr($timeIN['timeIN'],11,18) == null)){
						$shift_in = "--";
						echo "<td>$shift_in</td>";
					}elseif (($SatSun["wday"]<>0 || $SatSun["wday"]<>6) && (substr($timeIN['timeIN'],11,18) <> null)){
						$shift_in = substr($timeIN['timeIN'], 11,18);
						echo "<td>$shift_in</td>";
					}
					$GLOBALS['shift_in'] = $shift_in;

					//PRINT TIME-OUT
					//get EE Time-Out
					$timeOUT = gettimeout($todayTimeFrom,$todayTimeTo,$deptEE['fldUserID'],$shift_start);
					$timeOUTplus = gettimeoutPLUS($todayTimeFrom,$todayTimeTo,$deptEE['fldUserID'],$shift_start);

					//print BLANK if SAT or SUN and timeIN is NULL 
					if((($SatSun["wday"]==0 || $SatSun["wday"]==6)) && ($timeIN['timeIN'] == null)){
						$shift_out = " ";
						$shift_out_full = $shift_out;
						echo "<td>$shift_out</td>";	
					}
					//if not SAT or SUN
					elseif ($SatSun["wday"] <> 0 || $SatSun["wday"] <> 6){
						//normal time-out
						if ($timeOUT['timeOut'] <> null){
							if ($timeOUT['timeOut'] > $GLOBALS['shift_end_date']){
								$shift_out = substr($timeOUT['timeOut'], 11, 18);
								$shift_out_full = $timeOUT['timeOut'];
								echo "<td>$shift_out</td>";	
							}elseif ($timeOUT['timeOut'] < $GLOBALS['shift_end_date']){
								if ($timeOUTplus['timeOutPlus'] <> null){
									$shift_out = substr($timeOUTplus['timeOutPlus'], 11, 18);
									$shift_out_full = $timeOUTplus['timeOutPlus'];
									echo "<td>$shift_out</td>";
								}else{
									$shift_out = "--";
									$shift_out_full = " ";	
									echo "<td>$shift_out</td>";	
								}	
							}
						}elseif ($timeOUT['timeOut'] == null){

More codes to follow...

[otixz]

Here is the continuation...

/***if timeOUT is null and timeIn is not null
								    check if timeout is the next day
								    count # of timeout nextday****/

							$timeOutCnt = getTimeOutCnt($todayTimeFrom,$todayTimeTo,$deptEE['fldUserID'],$shift_start);
							if ($timeOutCnt['cnt'] == 0){
								$shift_out = "--";
								$shift_out_full = " ";
								echo "<td>$shift_out</td>";	
							}
							elseif ($timeOutCnt['cnt'] == 1){
								$testdate = $strTodayPlusOneDay . " " . $GLOBALS['shift_end']. "<br>";

								if (($timeOUTplus['timeOutPlus'] > $testdate)) {
									$shift_out = "--";
									$shift_out_full = " ";
									echo "<td>$shift_out</td>";	

								}elseif (($timeOUTplus['timeOutPlus'] > $GLOBALS['shift_end_date'])){
									$shift_start_plusOne = $strTodayPlusOneDay . " " . $GLOBALS['shift_start'];
									if ($timeOUTplus['timeOutPlus'] < $shift_start_plusOne){
										$shift_out = substr($timeOUTplus['timeOutPlus'], 11, 18);
										$shift_out_full = $timeOUTplus['timeOutPlus'];
										echo "<td>$shift_out</td>";	
									}else{
										$shift_out = "--";
										$shift_out_full = $shift_out;
										echo "<td>$shift_out</td>";
									}
								}
							}
							elseif($timeOutCnt['cnt'] >= 2){
								if (($timeOUTplus['timeOutPlus']==null) && ($timeIN['timeIN'] <> null)){
									$shift_out = "--";
									$shift_out_full = " ";
									echo "<td>$shift_out</td>";	
								}
								elseif (($timeOUTplus['timeOutPlus'] <> null) && ($timeIN['timeIN'] <> null)){
									if ((substr($timeOUTplus['timeOutPlus'],11,18)) > $GLOBALS['shift_end']){
										$shift_out = "--";
										$shift_out_full = " ";
										echo "<td>$shift_out</td>";		
									}else{
										$shift_out = substr($timeOUTplus['timeOutPlus'],11,18);
										$shift_out_full = $timeOUTplus['timeOutPlus'];
										echo "<td>$shift_out</td>";	
									}
								}	
							}
						}
					}

					$GLOBALS['shift_out'] = $shift_out;
					$GLOBALS['shift_out_full'] = $shift_out_full;
					//LATE COMPUTATION
					//mktime of $gracePeriod
					$mkGracePeriod = mktime($hh,6,$ss,0,0,$year);
					//string format of $gracePeriod
					$strGracePeriod = strftime("%H:%M:%S",$mkGracePeriod);						
					if($SatSun["wday"]==0 || $SatSun["wday"]==6){
						$late = " ";
					}elseif ($SatSun["wday"] <> 0 || $SatSun["wday"] <> 6){
						//result of ComputeLate function is to duration of Late_lateCount
						$diff_computation = ComputeLate($todayTimeFrom,$todayTimeTo,$GLOBALS['shift_in'],$shift_start);
						$exp = explode("_", $diff_computation);
						//print duration of late foreach user/per day
						$late = $exp[0];
						//print late count foreach user / per day
						$cntrLate = $cntrLate + $exp[1];
						//get total duration of late
						$expLate = explode(":", $late);

						$hours = $hours + $expLate[0];
						$mins = $mins + $expLate[1];
						$secs = $secs + $expLate[2];
						//if $timeIN < $gracePeriod --> print difference (Gray font color)
						if ($GLOBALS['shift_in'] < $strGracePeriod){
							echo "<td><font color=\"Gray\">$late</font></td>";
						}elseif ($GLOBALS['shift_in'] >= $strGracePeriod){
							echo "<td><font color=\"Red\"><b>$late</b></font></td>";	
						} 
						else {
							echo "<td>$late</td>";
						}
					}


//	UNDERTIME COMPUTATION
						$mkTimeINfour 	= mktime(4,0,0,0,0,$ToYearNumber);
						$strTimeINfour 	= strftime("%H:%M:%S", $mkTimeINfour);

					if($SatSun["wday"]==0 || $SatSun["wday"]==6){
						$undertime = " ";
					}elseif ($SatSun["wday"] <> 0 || $SatSun["wday"] <> 6){
						if (($GLOBALS['shift_out'] == "--") && ($GLOBALS['shift_in'] == "--")){
							$undertime = $strTimeINfour;
							echo "<td></td>";
							$cntrUndertime = $cntrUndertime + count($undertime);
							//get total duration of late
							$expUndertime = explode(":", $undertime);

							$hour = $hour + $expUndertime[0];
							$min = $min + $expUndertime[1];
							$sec = $sec + $expUndertime[2];
						}elseif (($GLOBALS['shift_out'] == "--") && ($GLOBALS['shift_in'] <> "--")){
							$undertime = $strTimeINfour;
							echo "<td>$undertime</td>";
							$cntrUndertime = $cntrUndertime + count($undertime);
							//get total duration of late
							$expUndertime = explode(":", $undertime);

							$hour = $hour + $expUndertime[0];
							$min = $min + $expUndertime[1];
							$sec = $sec + $expUndertime[2];
						}elseif (($GLOBALS['shift_out'] <> "--") && ($GLOBALS['shift_in'] == "--")){
							$undertime = $strTimeINfour;
							echo "<td>$undertime</td>";
							$cntrUndertime = $cntrUndertime + count($undertime);
							//get total duration of late
							$expUndertime = explode(":", $undertime);

							$hour = $hour + $expUndertime[0];
							$min = $min + $expUndertime[1];
							$sec = $sec + $expUndertime[2];
						}elseif (($GLOBALS['shift_out'] <> "--") && ($GLOBALS['shift_out_full'] < $GLOBALS['shift_end_date'])){
							$diff_undertime = getDifference($GLOBALS['shift_end_date'], $GLOBALS['shift_out_full']);
							$undertime = $diff_undertime['difference'];
							echo "<td>$undertime</td>";
							$cntrUndertime = $cntrUndertime + count($undertime);
							//get total duration of late
							$expUndertime = explode(":", $undertime);

							$hour = $hour + $expUndertime[0];
							$min = $min + $expUndertime[1];
							$sec = $sec + $expUndertime[2];	
						}
					}


					echo "</tr>";
				}
				//total late count
				$cntrLate . "<br>";
				//total undertime count
				$cntrUndertime . "<br>";
				//total duration & average of late
				$total_late = getDuration($hours, $mins, $secs, $cntrLate);
				$expTotal_late = explode("_", $total_late);
				$totDuration_late = $expTotal_late[0] . "<br>";
				//total duration & average of undertime
				$total_undertime = getDuration($hour, $min, $sec, $cntrUndertime);
				$expTotal_undertime = explode("_", $total_undertime);
				$totDuration_undertime = $expTotal_undertime[0] . "<br>";
				//average late
				$average_late = $expTotal_late[1];
				//average late
				$average_undertime = $expTotal_undertime[1];
			}

Thank you very much Sir.