<?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> </p>
<p> </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"> </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"> </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"> </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>