} } $btn = '<td align="center"> <button data-hint="' . $hint . '" class="fg-white bg-' . $clr . '" ' . $func . '> <i class="icon-battery-' . $icon . '"></i> </button> </td>'; $dpp = getBiaya('registration', $res['replid']) - getDiscTotal('registration', $res['replid']); $kurangan = $dpp - getTerbayar('registration', $res['replid']); // var_dump($kurangan);exit(); $out .= '<tr> <td>' . $res['nis'] . '</td> <td>' . $res['nama'] . '</td> <td align="right">Rp. ' . number_format($dpp) . '</td> <td align="right">Rp. ' . number_format($kurangan) . '</td> <td align="center">' . getTglTrans($res['replid'], 'registration') . '</td> ' . $btn . ' </tr>'; } } else { #kosong $out .= '<tr align="center"> <td colspan=9 ><span style="color:red;text-align:center;"> ... data tidak ditemukan...</span> </td> </tr>'; } #link paging $out .= '<tr class="info"><td colspan=9>' . $obj->anchors . '</td></tr>'; $out .= '<tr class="info"><td colspan=9>' . $obj->total . '</td></tr>'; break;
$terbayar = getTerbayar($pre, $r2['replid']); $status = getStatusBayar($pre, $r2['replid']); // var_dump($status);exit(); if ($status == 'lunas') { $clr = 'lightGreen'; } else { // belum $clr = 'pink'; } $out .= '<tr> <td align="right">' . $nox . '.</td> <td align="center">' . $r2['nis'] . '</td> <td>' . $r2['nama'] . '</td> <td align="right">Rp. ' . number_format($biaya) . '</td> <td style="background-color:' . $clr . '" align="center">' . $status . '</td> <td align="center">' . getTglTrans($r2['replid'], $pre) . '</td> </tr>'; $nox++; $totbayar += $biaya; } } $out .= '<tr class="head"> <td colspan="3" align="right"><b>Total : </b></td> <td align="right">Rp. ' . number_format($totbayar) . '</td> <td colspan="2"></td> </tr>'; $out .= '</table>'; $out .= '</body>'; echo $out; #generate html -> PDF ------------ $out2 = ob_get_contents();
if ($status == 'lunas') { $clr = 'lightGreen'; } elseif ($status == 'kurang') { $clr = 'yellow'; } else { // belum $clr = 'pink'; } $out .= '<tr> <td align="right">' . $nox . '.</td> <td>' . $r2['nopendaftaran'] . '</td> <td>' . $r2['nama'] . '</td> <td align="right">Rp. ' . number_format($biaya) . '</td> <td align="right">Rp. ' . number_format($kurangan) . '</td> <td style="background-color:' . $clr . ';" align="center">' . $status . '</td> <td align="center">' . getTglTrans($r2['replid'], 'joining fee') . '</td> </tr>'; $nox++; $totbayar += $biaya; $totkurang += $kurangan; } } $out .= '<tr class="head"> <td colspan="3" align="right"><b>Total : </b></td> <td align="right">Rp. ' . number_format($totbayar) . '</td> <td align="right">Rp. ' . number_format($totkurang) . '</td> <td colspan="2"></td> </tr>'; $out .= '</table>'; $out .= '</body>'; echo $out;
$func = 'onclick="pembayaranFR(\'dpp\',' . $res['replid'] . ');"'; } } $btn = '<td align="center"> <button data-hint="' . $hint . '" class="fg-white bg-' . $clr . '" ' . $func . '> <i class="icon-battery-' . $icon . '"></i> </button> </td>'; $dpp = getBiaya('dpp', $res['replid']) - getDiscTotal('dpp', $res['replid']); $kurangan = $dpp - getTerbayar('dpp', $res['replid']); $out .= '<tr> <td>' . $res['nis'] . '</td> <td>' . $res['nama'] . '</td> <td align="right">Rp. ' . number_format($dpp) . '</td> <td align="right">Rp. ' . number_format($kurangan) . '</td> <td align="center">' . getTglTrans($res['replid'], 'dpp') . '</td> ' . $btn . ' </tr>'; } } else { #kosong $out .= '<tr align="center"> <td colspan=9 ><span style="color:red;text-align:center;"> ... data tidak ditemukan...</span> </td> </tr>'; } #link paging $out .= '<tr class="info"><td colspan=9>' . $obj->anchors . '</td></tr>'; $out .= '<tr class="info"><td colspan=9>' . $obj->total . '</td></tr>'; break;
if ($status == 'lunas') { $clr = 'lightGreen'; } elseif ($status == 'kurang') { $clr = 'yellow'; } else { // belum $clr = 'pink'; } $out .= '<tr> <td align="right">' . $nox . '.</td> <td>' . $r2['nopendaftaran'] . '</td> <td>' . $r2['nama'] . '</td> <td align="right">Rp. ' . number_format($biaya) . '</td> <td align="right">Rp. ' . number_format($kurangan) . '</td> <td style="background-color:' . $clr . '" align="center">' . $status . '</td> <td align="center">' . getTglTrans($r2['replid'], 'formulir') . '</td> </tr>'; $nox++; $totbayar += $biaya; $totkurang += $kurangan; } } $out .= '<tr class="head"> <td colspan="3" align="right"><b>Total : </b></td> <td align="right">Rp. ' . number_format($totbayar) . '</td> <td align="right">Rp. ' . number_format($totkurang) . '</td> <td colspan="2"></td> </tr>'; $out .= '</table>'; $out .= '</body>'; echo $out;