Location: PHPKode > projects > Attendance Management System > Attendance Management System/attendance/userdetail.php
<?php
   include_once("include/checksession.php");
   $uid = $_SESSION["uid"];
   $uid = 2;
?>
<?php		
	include_once("include/config.php");
?>
<html>
<head>
<title>Home - User Management</title>
<style>
body,td,th {
	font-family: Verdana;
	font-size: 13px;		
}
</style>
<body bgcolor="#f2f2f2">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<!--Fireworks MX 2004 Dreamweaver MX 2004 target.  Created Mon Aug 22 13:50:08 GMT+0500 (West Asia Standard Time) 2005-->
<style type="text/css">
<!--
body,td,th {
	font-size: 11px;
	font-family: Verdana, Arial, Helvetica, sans-serif;
	color: #333333;
}
-->
</style></head>
<body bgcolor="#f2f2f2">
<form name="form1" method="post" action="aureports.php?show=1&uid=<?php echo $uid?>">
<table width="760" border="1" 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><img name="user_r2_c8" src="images/user_r2_c8.jpg" width="29" height="45" border="0" alt=""></td>
   <td><img name="user_r2_c9" src="images/user_r2_c9.jpg" width="18" height="45" border="0" alt=""></td>
   <td><img name="user_r2_c10" src="images/user_r2_c10.jpg" width="34" height="45" border="0" alt=""></td>
   <td><img name="user_r2_c11" src="images/user_r2_c11.jpg" width="18" height="45" border="0" alt=""></td>
   <td><img name="user_r2_c12" src="images/user_r2_c12.jpg" width="28" height="45" border="0" alt=""></td>
   <td><img name="user_r2_c13" src="images/user_r2_c13.jpg" width="15" height="45" border="0" alt=""></td>
   <td><img name="user_r2_c14" src="images/user_r2_c14.jpg" width="41" height="45" border="0" alt=""></td>
   <td><img name="user_r2_c15" src="images/user_r2_c15.jpg" width="8" height="45" border="0" alt=""></td>
   <td><img name="user_r2_c16" src="images/user_r2_c16.jpg" width="41" height="45" border="0" alt=""></td>
   <td><img name="user_r2_c17" src="images/user_r2_c17.jpg" width="11" height="45" border="0" alt=""></td>
   <td><img name="user_r2_c18" src="images/user_r2_c18.jpg" width="30" height="45" border="0" alt=""></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>
  <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 rowspan="5" valign="top"><img name="user_r5_c1" src="images/user_r5_c1.jpg" width="17" height="149" border="0" alt=""></td>
   <td colspan="3"><img name="user_r5_c2" src="images/user_r5_c2.jpg" width="114" height="27" border="0" alt=""></td>
   <td colspan="10">
   
   <table border="0">
          <tr><td width="250"> </td><td align="left">Select User</td>
              <td align="left" ><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 width="250"> </td><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 width="250"> </td><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 width="250"></td><td colspan="2" align="center">
  <input type="submit" value="Show" name="button">
  </td></tr>
  </table>
   
   
   
   
   </td>
   <td valign="top"><img src="images/spacer.gif" width="1" height="27" border="0" alt=""></td>
  </tr>
  <tr>
   <td colspan="5" valign="top"><img name="user_r6_c2" src="images/user_r6_c2.jpg" width="160" height="31" border="0" alt="">
   </td>

   <td valign="t"><img src="images/spacer.gif" width="1" height="31" border="0" alt=""></td>   
   
  </tr>
  <tr>
   <td colspan="4" valign="top"><img name="user_r7_c2" src="images/user_r7_c2.jpg" width="139" height="30" border="0" alt=""></td>
   <td rowspan="3">&nbsp;</td>
   <td><img src="images/spacer.gif" width="1" height="30" border="0" alt=""></td>
  </tr>
  <tr>
   <td valign="top"><img name="user_r8_c2" src="images/user_r8_c2.jpg" width="74" height="30" border="0" alt=""></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"><img name="user_r9_c2" src="images/user_r9_c2.jpg" width="102" height="31" border="0" alt=""></td>
   <td colspan="10" valign="top">
   
   
  
   <table border="1" cellpadding="2" cellspacing="6" align="right" >
<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 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>",$record1["date"],"</td><td>",$record1["pday"],"</td>
	<td>",$timein,"</td><td>",$timeout,"</td><td>",$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;	
	
?>	
</td></tr>
<tr><td  colspan="5"></td><td>

      <?php
       if($totaltime < $whours) {
	echo"<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"<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>";
		}
?>
 

</form>
   
   
   </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>
</body>
</html>
Return current item: Attendance Management System