| <table align="center" border="1" cellpadding="5" cellspacing="0"> |
| <tr> |
| <th rowspan=2><font size="2" face="Arial">NIK</font></th> |
| <th rowspan=2><font size="2" face="Arial">Name</font></th> |
| |
| <?php |
| date_default_timezone_set('Asia/Jakarta'); |
| $begindate = '2013-03-25'; |
| $enddate = '2013-03-29'; |
| |
| $q= "SELECT DISTINCT tanggal FROM absen WHERE tanggal BETWEEN '$begindate' AND'$enddate' AND DAYOFWEEK(tanggal)NOT IN(1,7)"; |
| $query1 = mysql_query($q) or die(mysql_error()); |
| $count = mysql_num_rows($query1); |
| while ($fetch = mysql_fetch_row($query1)){ |
| $tanggal = $fetch['0']; |
| ?><th colspan=2><font size="2" face="Arial"><?php echo $tanggal;?></font></th><?php |
| }?> |
| <th rowspan=2><font size="2" face="Arial">Total telat</font></th> |
| </tr> |
| <tr> |
| <?php |
| while ($count>0){ |
| echo '<th><font size="2" face="Arial">Masuk</font></th>'; |
| echo '<th><font size="2" face="Arial">Telat</font></th>'; |
| $count--; |
| }?> |
| </tr> |
| <?php |
| |
| $cquery = "SELECT nik,fname,lname FROM staff ORDER BY fname ASC"; |
| $result = mysql_query($cquery) or die(mysql_error()); |
| |
| while($row1= mysql_fetch_array($result)) |
| { |
| $nik = $row1['nik']; |
| |
| echo "<tr>"; |
| echo "<td><font size='2' face='Arial'>" . $row1['nik'] . "</font></td>"; |
| echo "<td><font size='2' face='Arial'>" . $row1['fname']." ".$row1['lname']. "</font></td>"; |
| |
| $q2 = "SELECT checkin, telat2, checkout,ket,rank FROM absen WHERE nik = '$nik' AND tanggal BETWEEN '$begindate' AND '$enddate' AND DAYOFWEEK(tanggal)NOT IN(1,7) "; |
| $result1 = mysql_query($q2) or die(mysql_error()); |
| |
| while($row2 = mysql_fetch_row($result1)){ |
| $checkin = $row2['0']; |
| $telat2 = $row2['1']; |
| $checkout = $row2['2']; |
| $ket = $row2['3']; |
| $rank = $row2['4']; |
| |
| if (empty($rank) && isset($ket) ){ |
| echo "<td><font size='2' face='Arial'> </font></td>"; |
| echo "<td><font size='2' face='Arial'> </font></td>";} |
| elseif(($checkout=='00:00:00'&&$checkin=='00:00:00')){ |
| echo "<td><font size='2' face='Arial'> </font></td>"; |
| echo "<td><font size='2' face='Arial'> </font></td>";} |
| elseif(empty($rank)){} |
| elseif(empty($ket)&&$rank !== ''){ |
| echo "<td><font size='2' face='Arial'>" . date('H:i', strtotime($row2['0'])) . "</font></td>"; |
| echo "<td><font size='2' face='Arial'>" . $row2['1'] . "</font></td>";} |
| }}?> |
| </tr> |
| </table> |