<div class="report-approval">
<div id="header-approval">
Range date   <label for="from">From</label>
<input type="text" id="from" name="from" />
<label for="to">to</label>
<input type="text" id="to" name="to" />
<br/>
<script type="text/javascript">
function redirectMe (sel) {
var url = sel[sel.selectedIndex].value;
var date1= $('#from').val();
var date2= $('#to').val();
var first= '&from=';
var last= '&to=';
window.location = url + first + date1 + last + date2;
}
function redirectMe (sel) {
var url = sel[sel.selectedIndex].value;
var date1= $('#from').val();
var date2= $('#to').val();
var first= '&from=';
var last= '&to=';
window.location = url + first + date1 + last + date2;
}
</script>
</div>
<table class="CSSTableGenerator"cellpadding="0" cellspacing="0">
<tr>
<td style="text-align:left;"><input type="checkbox">  Check All
</td>
<td>User ID<br/>
<select name="myselectid" onchange="redirectMe(this);">
<?php
include("konek.php");
$sqlshowK="select * from employe";
$hasilshowK=mysql_query($sqlshowK);
while ($rsshowK=mysql_fetch_array($hasilshowK)){
echo "<option value=approval-lembur.php?id='".$user=$rsshowK["userid"]."'>".$user=$rsshowK["userid"]."</options>";
}
?>
</select>
</td>
<td>Tanggal</td>
<td>Waktu Lembur On</td>
<td>Waktu Lembur Off</td>
<td style="text-align:left;">Note<br/>
<select name="myselect" onchange="redirectMe(this);">
<option value="approval-lembur.php?cek_status=4">Choose One</options>
<option value="approval-lembur.php?cek_status=0">Show All</options>
<option value="approval-lembur.php?cek_status=2">Approve</options>
<option value="approval-lembur.php?cek_status=3">Unapprove</options>
<option value="approval-lembur.php?cek_status=1">Not Yet Check</options>
</select></td>
</tr>
<?php
include("konek.php");
$sqlshowK="select * from employe";
$hasilshowK=mysql_query($sqlshowK);
while ($rsshowK=mysql_fetch_array($hasilshowK)){
$user=$rsshowK["userid"];
include("konek.php");
if($from <> "" or $ $to <> ""){
$sqldate="select * from record_date where userid='1' and tanggal >= '$from' and tanggal <= '$to'";
}
else {
$sqldate="select * from record_date where userid='1'";
}
$hasildate=mysql_query($sqldate);
while($rsdate=mysql_fetch_array($hasildate)){
$date=$rsdate['tanggal'];
include("konek.php");
if ($cek_status=="3"){
$sqlon="select * from record_absen where userid='$user' and tgl_absen='$date' and var_mode='5' and cek='3'";
}
Tidak ada komentar:
Posting Komentar