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;
}
<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;
}
?>
<!--<div id="title" align="center">Kraeplin</div>
<div id="btstart" align="center"><input type=button id="btnstart" tabindex="-1" value="Start"></div>
