function UserList()
{
//IF(tahapan_tes='1', 'Kraeplin', IF(tahapan_tes='2', 'PAPI', IF(tahapan_tes='3', 'DISC', IF(tahapan_tes='4', 'WPT', 'Completed')))) AS tahapan
$UserQuery = "SELECT tanggal_tes, no_ktp, nama_peserta, CONCAT(usia ,' Tahun') AS usia, posisi, tahapan_tes,\n\t\t\t\t\t\tIF(tahapan_tes='1', 'WPT', IF(tahapan_tes='2', 'PAPI', IF(tahapan_tes='3', 'DISC', IF(tahapan_tes='4', 'Kraeplin', 'Completed')))) AS tahapan\n\t\t\t\t\t\tFROM USER ";
$UserQuery .= " ORDER BY tanggal_tes DESC ";
$stmt = sql_query($UserQuery);
$content = '<div id="title" align="center" style="font-weight:bold; font-size:23px;">Data Peserta</div><br /><br /><br />
<div id="body" align="center" style="width: 900px; margin: auto;">
<table width="900px" class="display" id="tableatendee" >
<thead>
<tr align="center">
<th style="text-align:center;">Tanggal Tes</th>
<th style="text-align:center;">No. KTP</th>
<th style="text-align:center;">Nama Peserta</th>
<th style="text-align:center;">Usia</th>
<th style="text-align:center;">Posisi yang<br />Dilamar</th>
<th style="text-align:center;">Tahapan<br />Tes</th>
<th style="text-align:center;">Tindakan</th>
</tr></thead>';
$content .= '<tbody>';
$i = 0;
while ($row = sql_fetchrow($stmt)) {
$i++;
$content .= "<tr><td align=\"center\">" . getDMYFormatDate($row['tanggal_tes']) . "</td>\n\t\t\t\t\t\t<td align=\"center\">" . $row['no_ktp'] . "</td>\n\t\t\t\t\t\t<td align=\"center\">" . $row['nama_peserta'] . "</td>\n\t\t\t\t\t\t<td align=\"center\">" . $row['usia'] . "</td>\n\t\t\t\t\t\t<td align=\"center\">" . $row['posisi'] . "</td>\n\t\t\t\t\t\t<td align=\"center\">" . $row['tahapan'] . "</td>";
$content .= "<td style='text-align:center'>";
$content .= UserAction($row['no_ktp'], $row['tahapan_tes']);
$content .= "</td>";
$content .= "</tr>";
}
// if($i=='0') $content .= '<tr><td colspan="9" class="fb12" align="center" bgcolor="#d4e8f6">Data tidak ditemukan</td></tr>';
$content .= '</tbody>';
$content .= '</table><br><br></div>';
echo $content;
}
function LoginForm()
{
// $content = '<div id="title" align="center">Login</div>';
$formName = 'formRegister';
$content = '<form action="" method="post" enctype="multipart/form-data" name="' . $formName . '" id="' . $formName . '">';
$content .= "<table id=tbLogin align='center' border='0' width='450px'>";
$content .= "<tr>";
$content .= "<td width='35%'>Tanggal Tes</td><td width='5%' style='text-align:center;'>:</td>";
$content .= "<td width='60%'>" . getDMYFormatDate(date("Y-m-d H:i:s")) . "<input type='hidden' id='hdTanggal' name='hdTanggal' value='" . date("Y-m-d H:i:s") . "' ></td>";
$content .= "</tr>";
$content .= "<tr>";
$content .= "<tr>";
$content .= "<td width='35%'>NIK / Nomor KTP</td><td width='5%' style='text-align:center;'>:</td>";
$content .= "<td width='60%'><input type='text' id='txtNoKTP' name='txtNoKTP' size='30' maxlength='16' onkeypress='return isNumberNoAlert(event);'></td>";
$content .= "</tr>";
$content .= "<tr>";
$content .= "<td width='35%'>Nama Lengkap</td><td width='5%' style='text-align:center;'>:</td>";
$content .= "<td width='60%'><input type='text' id='txtNama' name='txtNama' size='30'></td>";
$content .= "</tr>";
$content .= "<tr>";
$content .= "<td width='35%'>Posisi yang Dituju</td><td width='5%' style='text-align:center;'>:</td>";
$content .= "<td width='60%'><input type='text' id='txtPosisi' name='txtPosisi' size='30'></td>";
$content .= "</tr>";
$content .= "<tr>";
$content .= "<td width='35%'>Usia</td><td width='5%' style='text-align:center;'>:</td>";
$content .= "<td width='60%'><input type='text' id='txtUsia' name='txtUsia' size='23' maxlength='16' onkeypress='return isNumberNoAlert(event);'> Tahun</td>";
$content .= "</tr>";
$content .= "<tr>";
$content .= "<td width='35%'>Alamat</td><td width='5%' style='text-align:center;'>:</td>";
$content .= "<td width='60%'><textarea rows=3 cols=31 name='txtAlamat' id='txtAlamat' ></textarea></td>";
$content .= "</tr>";
$content .= "<tr>";
$content .= "<td width='35%'>Nomor HP</td><td width='5%' style='text-align:center;'>:</td>";
$content .= "<td width='60%'><input type='text' id='txtNoHP' name='txtNoHP' size='30' maxlength='12' onkeypress='return isNumberNoAlert(event);'></td>";
$content .= "</tr>";
$content .= "<tr>";
$content .= "<td colspan=3 style='text-align:center;'>";
$content .= '<input type="button" id="btnSaveDetail" value="Simpan" class="btn btnSave" onclick=\'localJsSaveDetail("' . $formName . '");\'>';
$content .= "</td>";
$content .= "</tr>";
$content .= "</table>";
$content .= "</form>";
echo $content;
}
<div class="x_content">
<table width="1000px" class="table table-striped responsive-utilities jambo_table" id="tableatendee" >
<thead>
<tr align="center">
<th>Tanggal Tes</th>
<th>Kondisi</th>
<th>No. KTP</th>
<th>Posisi yang<br />Dilamar</th>
<th>Tahapan<br />Tes</th>
<th>Tindakan</th>
</tr></thead>';
$content .= '<tbody>';
$i = 0;
while ($row = sql_fetchrow($stmt)) {
$i++;
$content .= "<tr><td align=\"center\">" . getDMYFormatDate($row['tanggal_tes']) . "</td>\n\t\t\t\t\t\t<td align=\"center\">" . $row['no_ktp'] . "</td>\n\t\t\t\t\t\t<td align=\"center\">" . $row['nama_peserta'] . "</td>\n\t\t\t\t\t\t<td align=\"center\">" . $row['posisi'] . "</td>\n\t\t\t\t\t\t<td align=\"center\">" . $row['tahapan'] . "</td>";
$content .= "<td style='text-align:center'>";
$content .= UserAction($row['no_ktp']);
$content .= "</td>";
$content .= "</tr>";
}
// if($i=='0') $content .= '<tr><td colspan="9" class="fb12" align="center" bgcolor="#d4e8f6">Data tidak ditemukan</td></tr>';
$content .= '</tbody>';
$content .= '</table><br><br></div>';
echo $content;
function UserAction($id)
{
$content .= "\n\t\t\t\t<img src='../images/print.gif' style='cursor:pointer' onmouseout=\"exit();\" \n\t\t\t\t\tonmouseover=\"tooltip2('" . getTooltipMenuRight('Klik untuk print data peserta ini.') . "');\" \n\t\t\t\t\tonclick=\"localJsPrintSuratBalik('" . $id . "');\">\n\t\t\t\t";
return $content;
}
?>
