Location: PHPKode > projects > Attendance Management System > Attendance Management System/attendance/ureports.php
<?php
   include_once("include/uchecksession.php");
   $uid = $_SESSION["uid"];
   include_once("include/config.php");
?>
<html>
<head>
<title>Attendance System</title>
<style>
body,td,th {
	font-family: Verdana;
	font-size: 13px;		
}
</style>
<meta http-equiv="Content-Type" content="text/html;">
<!--Fireworks MX 2004 Dreamweaver MX 2004 target.  Created Mon Aug 22 13:42:02 GMT+0500 (West Asia Standard Time) 2005-->
</head>
<body bgcolor="#f2f2f2">
<form name="form1" method="post" action="ureports.php?show=1&uid=<?php echo $uid?>">
<table width="760" border="0" align="center" cellpadding="0" cellspacing="0">
<!-- fwtable fwsrc="sub2.png" fwbase="management.jpg" fwstyle="Dreamweaver" fwdocid = "255186328" fwnested="0" -->
  <tr>
   <td><img src="images/spacer.gif" width="476" height="1" border="0" alt=""></td>
   <td><img src="images/spacer.gif" width="29" height="1" border="0" alt=""></td>
   <td><img src="images/spacer.gif" width="18" height="1" border="0" alt=""></td>
   <td><img src="images/spacer.gif" width="34" height="1" border="0" alt=""></td>
   <td><img src="images/spacer.gif" width="18" height="1" border="0" alt=""></td>
   <td><img src="images/spacer.gif" width="21" height="1" border="0" alt=""></td>
   <td><img src="images/spacer.gif" width="7" height="1" border="0" alt=""></td>
   <td><img src="images/spacer.gif" width="15" height="1" border="0" alt=""></td>
   <td><img src="images/spacer.gif" width="41" height="1" border="0" alt=""></td>
   <td><img src="images/spacer.gif" width="8" height="1" border="0" alt=""></td>
   <td><img src="images/spacer.gif" width="41" height="1" border="0" alt=""></td>
   <td><img src="images/spacer.gif" width="11" height="1" border="0" alt=""></td>
   <td><img src="images/spacer.gif" width="30" height="1" border="0" alt=""></td>
   <td><img src="images/spacer.gif" width="11" height="1" border="0" alt=""></td>
   <td><img src="images/spacer.gif" width="1" height="1" border="0" alt=""></td>
  </tr>

  <tr>
   <td colspan="14"><img name="management_r1_c1" src="images/management_r1_c1.jpg" width="760" height="5" border="0" alt=""></td>
   <td><img src="images/spacer.gif" width="1" height="5" border="0" alt=""></td>
  </tr>
  <tr>
   <td><img name="management_r2_c1" src="images/management_r2_c1.jpg" width="476" height="45" border="0" alt=""></td>
   <td colspan="3">&nbsp;</td>
   <td><img name="management_r2_c5" src="images/management_r2_c5.jpg" width="18" height="45" border="0" alt=""></td>
   <td colspan="2"><a href="home.php"><img name="management_r2_c2" src="images/management_r2_c2.jpg" width="29" height="45" border="0" alt=""></a></td>
   <td>&nbsp;</td>
   <td><a href="pass.php"><img src="images/attendance_r2_c7.jpg" width="39" height="45" border="0"></a></td>
   <td><img name="management_r2_c12" src="images/management_r2_c12.jpg" width="11" height="45" border="0" alt=""></td>
   <td><a href="ureports.php"><img name="attendance_r2_c9" src="images/attendance_r2_c9.jpg" width="34" height="45" border="0" alt=""></a></td>
   <td><img name="management_r2_c10" src="images/management_r2_c10.jpg" width="8" height="45" border="0" alt=""></td>
   
   <td><a href="logout.php"><img name="management_r2_c13" src="images/management_r2_c13.jpg" width="30" height="45" border="0" alt=""></a></td>
   <td><img name="management_r2_c14" src="images/management_r2_c14.jpg" width="11" height="45" border="0" alt=""></td>
   <td><img src="images/spacer.gif" width="1" height="45" border="0" alt=""></td>
  </tr>
  <tr>
   <td colspan="14"><img name="management_r3_c1" src="images/management_r3_c1.jpg" width="760" height="36" border="0" alt=""></td>
   <td><img src="images/spacer.gif" width="1" height="36" border="0" alt=""></td>
  </tr>
  <tr>
   <td colspan="14" rowspan="2">
   
   <table width="100%" height="100%" border="0">
     <tr><br><br>
       <th width="26%" valign="middle" scope="col"><img name="management_r5_c7" src="images/management_r5_c7.jpg" width="164" height="143" border="0" alt=""></th>
       <td width="74%" scope="col" valign="top">
			<center><table border="0" >
					  <tr><td align="left">Select Month</td>
						<td align="left"><select name="select1">
						  <option value="1">January</option>
						  <option value="2">February</option>
						  <option value="3">March</option>
						  <option value="4">April</option>
						  <option value="5">May</option>
						  <option value="6">June</option>
						  <option value="7">July</option>
						  <option value="8">August</option>
						  <option value="9">September</option>
						  <option value="10">October</option>
						  <option value="11">November</option>
						  <option value="12">December</option>
						</select></td>
					  </tr>
					  <tr><td align="left">Select Year</td>
					  <td align="left"><select name="select2">
					  <option value="2004">2004</option><option value="2005">2005</option>
					  <option value="2006">2006</option><option value="2007">2007</option>
					  <option value="2008">2008</option><option value="2009">2009</option>
					  <option value="2010">2010</option><option value="2011">2011</option>
					  <option value="2012">2012</option><option value="2013">2013</option>
					  <option value="2014">2014</option><option value="2015">2015</option>
					  <option value="2016">2016</option><option value="2017">2017</option>
					  <option value="2018">2018</option><option value="2019">2019</option>
					  <option value="2020">2020</option><option value="2021">2021</option>
					  <option value="2022">2022</option><option value="2023">2023</option>
					  <option value="2024">2024</option><option value="2025">2025</option>
					  <option value="2026">2026</option><option value="2027">2027</option>
					  <option value="2028">2028</option><option value="2029">2029</option>
					  <option value="2030">2030</option><option value="2031">2031</option>
					  </select></td></tr>
					  <tr></tr>
					  <tr><td colspan="2" align="center">
					  <input type="submit" value="Show" name="button">
					  </td></tr>
					  </table>
					<br>
					<table border="1" cellpadding="2" cellspacing="2">
					<tr><th>Date</th><th>Day</th><th>Time In</th><th>Time Out</th><th>Time Spent</th></tr>
					<?php 
						function calculate($timein, $timeout) {
						$timespentin = split(":",$timein,3);
						$timespentout = split(":",$timeout,3);
						//print_r($timespentin);
						//print_r($timespentout);
						$t1 = $timespentin[0]*60 + $timespentin[1];
						$t2 = $timespentout[0]*60 + $timespentout[1];
						$timespent = round(($t2 - $t1)/60,2);
						//echo $timespent;
						return $timespent;
						}
						if($_GET["show"]==1) {
							$month = $_POST["select1"];
							$year = $_POST["select2"];
						}else {
							$month = date("m");
							$year = date("Y");
						 }
						 $startday = 1;
						 if($month==1||$month==3||$month==5||$month==7||$month==8||$month==10||$month==12) {
							$endday = 31; 
						 }
						 if($month==4||$month==6||$month==9||$month==11) {
							$endday = 30;
						 }
						 if($month==2){
							if($year%4==0){
								$endday = 29;
							}else {
								$endday = 28;
							 }
						 }
						 echo "<script language = 'javascript'>
						form1.select1.options[",$month-1,"].selected = true;
						form1.select2.options[",$year-2004,"].selected = true;
						</script>";
							
							$date1 = $year."-".$month."-".$startday;
							$date2 = $year."-".$month."-".$endday;
														
							$recordset5 = mysql_query("select * from nwdays where nwdate between '".$date1."' and '".$date2."' and 
							(uid=0 or (uid=".$uid." and holidaytype=0)) order by nwdate");
							$days = 0;
							while($record5 = mysql_fetch_array($recordset5)) {
								$days = $days + 1;
							}
							$wdays = $endday - $days;
							//$whours = $wdays *8;
						$query = "select * from users where uid =".$uid;
						$recordset = mysql_query($query);
						while($record = mysql_fetch_array($recordset)) {
						$whours1 = $record["uwhours"];
						$whours = $wdays * $whours1;
						$totaltime = 0;
						$query1 = "select * from presence where uid =".$uid." and date between '".$date1."' and '".$date2."' order by date";
						$recordset1 = mysql_query($query1);
						while($record1 = mysql_fetch_array($recordset1)) {
						$timein = $record1["timein"];
						$timeout = $record1["timeout"];
						$daytime = calculate($timein, $timeout);
						$totaltime = $totaltime + $daytime;
						
						$dtimehm = explode(".",$daytime,2);
						$hours = $dtimehm[0];
						$dtimehm = split(".",$daytime,2);
						$minutes = round ($dtimehm[1]*60,0);
						if ($minutes >59) {$minutes = $minutes%60;}
						$div = $minutes/10;
						if($div<1) {$minutes = "0".$minutes;}
						$daytime = $hours.":".$minutes;
						
						echo"<tr><td align='center'>",$record1["date"],"</td><td align='center'>",$record1["pday"],"</td>
						<td align='center'>",$timein,"</td><td align='center'>",$timeout,"</td><td align='center'>",$daytime,"</td></tr>";
						
						//$timespent = split(":",$timein,2);
						//print_r($timespent);
						}
						$ttimehm = explode(".",$totaltime,2);
						$hours = $ttimehm[0];
						$ttimehm = split(".",$totaltime,2);
						$minutes = round ($ttimehm[1]*60,0);
						if ($minutes >59) {$minutes = $minutes%60;}
						$div = $minutes/10;
						if($div<1) {$minutes = "0".$minutes;}
						$totaltime = $hours.":".$minutes;
						
						echo"</table>";
						echo"<table><tr><th align='left'>Total Time Spent in this Month</th><th>",$totaltime,"</th></tr>
						<tr><th align='left'>Total Time Required for this Month </th><th>",$whours,"</th></tr></table>";
						}
					?>
					
					</table>
					</center>
					</form>

           </td>
     </tr>
	 
	 </table></td>
   <td><img src="images/spacer.gif" width="1" height="321" border="0" alt=""></td>
  </tr>
  
  <tr>
   <td><img src="images/spacer.gif" width="1" height="143" border="0" alt=""> </td>
  </tr>
</table>
</body>
</html>
Return current item: Attendance Management System