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>