}
}
$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;
