Location: PHPKode > projects > Attendance Management System > Attendance Management System/attendance/aureports.php
<?php
   include_once("include/checksession.php");
   $uid = $_SESSION["uid"]; 
?>
<?php	
	
	include_once("include/config.php");
?>
<html>
<head>
<title>Attendance System</title>
<style>
body,td,th {
	font-family: Verdana;
	font-size: 13px;		
}
</style>
<body bgcolor="#f2f2f2">
<form name="form1" method="post" action="aureports.php?show=1&uid=<?php echo $uid?>">

<table width="760" border="0" align="center" cellpadding="0" cellspacing="0">
	<tr>
		<td>
			<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
			<tr>
				<td colspan="2">
				
					<table width="760" border="0" align="center" cellpadding="0" cellspacing="0">
					<!-- fwtable fwsrc="sub.png" fwbase="user.jpg" fwstyle="Dreamweaver" fwdocid = "255186328" fwnested="0" -->
					  <tr>
					   <td><img src="images/spacer.gif" width="17" height="1" border="0" alt=""></td>
					   <td><img src="images/spacer.gif" width="74" height="1" border="0" alt=""></td>
					   <td><img src="images/spacer.gif" width="28" height="1" border="0" alt=""></td>
					   <td><img src="images/spacer.gif" width="12" height="1" border="0" alt=""></td>
					   <td><img src="images/spacer.gif" width="25" 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="299" 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="28" 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="19"><img name="user_r1_c1" src="images/user_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 colspan="7"><img name="user_r2_c1" src="images/user_r2_c1.jpg" width="476" height="45" border="0" alt=""></td>
					   <td><a href="admin.php?uid=<?php echo $uid?>"><img name="user_r2_c8" src="images/user_r2_c8.jpg" width="29" height="45" border="0" alt=""></a></td>
					   <td><img name="user_r2_c9" src="images/user_r2_c9.jpg" width="18" height="45" border="0" alt=""></td>
					   <td><a href="pass.php?uid=<?php echo $uid?>"><img name="pass_r2_c7" src="images/pass_r2_c7.jpg" width="39" height="45" border="0" alt=""></a></td>
					   <td><img name="user_r2_c11" src="images/user_r2_c11.jpg" width="18" height="45" border="0" alt=""></td>
					   <td><a href="aureports.php?uid=<?php echo $uid?>"><img name="attendance_r2_c12" src="images/attendance_r2_c12.jpg" width="28" height="45" border="0" alt=""></a></td>
					   <td><img name="user_r2_c13" src="images/user_r2_c13.jpg" width="15" height="45" border="0" alt=""></td>
					   <td><a href="nwdays.php?show=1&uid=<?php echo $uid?>"><img name="user_r2_c14" src="images/user_r2_c14.jpg" width="41" height="45" border="0" alt=""></a></td>
					   <td><img name="user_r2_c15" src="images/user_r2_c15.jpg" width="8" height="45" border="0" alt=""></td>
					   <td><a href="news.php?uid=<?php echo $uid?>"><img name="user_r2_c16" src="images/user_r2_c16.jpg" width="41" height="45" border="0" alt=""></a></td>
					   <td><img name="user_r2_c17" src="images/user_r2_c17.jpg" width="11" height="45" border="0" alt=""></td>
					   <td><a href="logout.php"><img name="user_r2_c18" src="images/user_r2_c18.jpg" width="30" height="45" border="0" alt=""></a></td>
					   <td><img name="user_r2_c19" src="images/user_r2_c19.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="19"><img name="user_r3_c1" src="images/user_r3_c1.jpg" width="760" height="34" border="0" alt=""></td>
					   <td><img src="images/spacer.gif" width="1" height="34" border="0" alt=""></td>
					  </tr>
					</table>
				</td>
			</tr>
			<tr>
				<td align="left" valign="top">
					<table width="160" cellpadding="0" cellspacing="0">
						<tr>
						   <td colspan="6" valign="top"><img name="user_r4_c1" src="images/user_r4_c1.jpg" width="177" height="24" border="0" alt=""></td>
						   <td rowspan="7" colspan="13"><p>&nbsp;</p>
							<p>&nbsp;</p>    </td>
						   <td><img src="images/spacer.gif" width="1" height="24" border="0" alt=""></td>
						  </tr>
						  
						  
						  <tr>
						   <td colspan="4" valign="top"><a href="aureports.php?uid=<?php echo $uid?>"><img name="sub_r7_c2" src="images/sub_r7_c2.jpg" width="139" height="30" border="0" alt=""></a></td>
						   <td rowspan="3">&nbsp;</td>
						   <td><img src="images/spacer.gif" width="1" height="30" border="0" alt=""></td>
						  </tr>
						  <tr>
						   <td colspan="5" valign="top"><a href="user.php?uid=<?php echo $uid?>"><img name="user_r6_c2" src="images/user_r6_c2.jpg" width="160" height="31" border="0" alt=""></a></td>
						   <td><img src="images/spacer.gif" width="1" height="31" border="0" alt=""></td>
						  </tr>
						  
						  <tr>
						   <td valign="top"><a href="fine.php?uid=<?php echo $uid?>"><img name="user_r8_c2" src="images/user_r8_c2.jpg" width="74" height="30" border="0" alt=""></a></td>
						   <td colspan="3">&nbsp;</td>
						   <td><img src="images/spacer.gif" width="1" height="30" border="0" alt=""></td>
						  </tr>
						  <tr>
						   <td colspan="2" valign="top"><a href="groups.php?uid=<?php echo $uid?>"><img name="user_r9_c2" src="images/user_r9_c2.jpg" width="102" height="31" border="0" alt=""></a></td>
						   <td colspan="2">&nbsp;</td>
						   <td><img src="images/spacer.gif" width="1" height="31" border="0" alt=""></td>
						  </tr>
						  <tr>
						   <td colspan="6" valign="bottom"><img name="user_r10_c1" src="images/user_r10_c1.jpg" width="177" height="293" border="0" alt=""></td>
						   <td><img src="images/spacer.gif" width="1" height="293" border="0" alt=""></td>
						  </tr>
					</table>

				</td>
				<td valign="top"><br>
					<table width="100%" cellpadding="0" cellspacing="0">
							<tr>
								<td valign="top">
									<center><table border="0" width="100%">
											<tr><td align="center" width="250">Select User</td>
											<td><select name="select3">
											<?php 
												$recordset6 = mysql_query("select * from users");
												while($record6 = mysql_fetch_array($recordset6)) {
												echo"<option value=",$record6["uid"],">",$record6["ulogin"],"</option>";
												}
											?>      
												</select></td>
											  </tr>
											
											  <tr><td align="center" width="250">Select Month</td>
											  <td><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="center" width="250">Select Year</td>
											  <td width="350" ><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 align="center" ></td>
											  <td><input type="submit" value="Show" name="button">
											  </td></tr>
											  </table></center>
											  
											  
										<br>	  
											  
									  <center><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><th>Edit</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"];
														$user = $_POST["select3"];
													}else {
														$month = date("m");
														$year = date("Y");
														$user = $uid;
													 }
													 
													 if($_GET["can"]==1) { $user = $_GET["cuser"]; }
													 
													 $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>";
														if($month == date("m")) { $endday = date("d"); }
														$date1 = $year."-".$month."-".$startday;
														$date2 = $year."-".$month."-".$endday;
														
														$recordset5 = mysql_query("select * from nwdays where nwdate between '".$date1."' and '".$date2."' and uid=0 and holidaytype=2 order by nwdate");
														$days = 0;
														while($record5 = mysql_fetch_array($recordset5)) {
															$days = $days + 1;
														}
														$wdays1 = $endday - $days;
														
														$recordset15 = mysql_query("select * from nwdays where nwdate between '".$date1."' and '".$date2."' and uid=".$user." and holidaytype=0 order by nwdate");
														$udays = 0;
														while($record15 = mysql_fetch_array($recordset15)) {
															$udays = $udays + 1;
														}
														
														$recordset115 = mysql_query("select * from nwdays where nwdate between '".$date1."' and '".$date2."' and uid=".$user." and holidaytype=1 order by nwdate");
														$halfleaves = 0;
														while($record115 = mysql_fetch_array($recordset115)) {
															$halfleaves = $halfleaves + 1;
														}
														
														$wdays = $wdays1 - $udays;
														//$whours = $wdays *8;
													$query = "select * from users where uid =".$user;
													$recordset = mysql_query($query);
													while($record = mysql_fetch_array($recordset)) {
													$whours1 = $record["uwhours"];
													$whours = $wdays * $whours1;
													$totaltime = 0;
													$presents = 0;
													$query1 = "select * from presence where uid =".$user." 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];
													//echo $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>
													<td><a href='edittime.php?pid=".$record1["pid"]."&uid=".$uid."&user=".$user."'>Edit</a></td></tr>";
													
													//$timespent = split(":",$timein,2);
													//print_r($timespent);
													$presents = $presents + 1;
													}
													echo"</table>";
													$holidays = $wdays1 - $presents - $halfleaves;
													if($holidays < 0) { $holidays = 0; }
													
													$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;	
													
													if($totaltime < $whours) {
													echo"<center><table><tr><th align='left'>Total Time Spent </th><th >
													<font color='red'>",$totaltime,"</font></th></tr>
													<tr><th align='left'>Total Time Required </th><th >",$whours,"</th></tr>
													</table>";
													} else {
													echo"<center><table><tr><th align='left'>Total Time Spent </th><th >",$totaltime,"</th></tr>
													<tr><th align='left'>Total Time Required </th><th >",$whours,"</th></tr>
													</table>";
													  }
													}
													
													$recordset3 = mysql_query("select * from users where uid=".$user);
														while($record3 = mysql_fetch_array($recordset3)){
														echo"<script>
														for(k=0; k< form1.select3.length; k++) {
															if(form1.select3.options[k].text =='".$record3["ulogin"]."') {
															form1.select3.options[k].selected = true;
															}
														}
														</script>";
														}
													?>		  
																						  
	
								     </td>
								</tr>
						  </table>
													
							
			
			</td></tr>
			
			
			
			</table>
		</td>
	</tr>
</table>
</form>
</body>
</html>
Return current item: Attendance Management System