$n = mysql_num_rows($e);
$out .= '<b>Total : ' . $n . '</b>';
$out .= '<table class="isi" width="100%">
<tr class="head">
<td align="center">No. pendaftaran</td>
<td align="center">NISN</td>
<td align="center">NIS</td>
<td align="center">Nama</td>
<td align="center">Tagihan</td>
<td align="center">Terbayar</td>
<td align="center">Status</td>
</tr>';
while ($r = mysql_fetch_assoc($e)) {
$color = $r['statusBayar'] == 'lunas' ? 'green' : ($r['statusBayar'] == 'belum' ? 'red' : 'orange');
$out .= '<tr>
<td align="center">' . getNoPendaftaran2($r['idsiswa']) . '</td>
<td>' . $r['nisn'] . '</td>
<td>' . $r['nis'] . '</td>
<td>' . $r['namasiswa'] . '</td>
<td align="right">' . setuang($biayaNett) . '</td>
<td align="right">' . setuang($terbayarTotal) . '</td>
<td style="background-color:' . $color . ';color:white;" align="center">' . $r['statusBayar'] . '</td>
</tr>';
}
$out .= '</table>';
$out .= '</body>';
echo $out;
#generate html -> PDF ------------
$out2 = ob_get_contents();
ob_end_clean();
$mpdf = new mPDF('c', 'A4', '');
// pr($s);
$e = mysql_query($s) or die(mysql_error());
$r = mysql_fetch_assoc($e);
$stat = !$e?'gagal':'sukses';
$kontakdaruratArr = getFieldArr2('*',$tb5,'siswa',$_POST['replid']);
$saudaraArr = getFieldArr2('*',$tb6,'siswa',$_POST['replid']);
$biayaArr = getFieldArr2('*',$tb7,'siswa',$_POST['replid']);
// TODO : fetch psb_siswabiaya (tingkat & subtingkat terakhir/paling tinggi )
// pr($biayaArr);
$out = json_encode(array(
'status' =>$stat,
/*bio siswa*/
'statussiswa' =>$r['status'],
'replid' =>$r['replid'],
'nopendaftaran' =>getNoPendaftaran2($_POST['replid']),
// $r['nopendaftaran'],
'namasiswa' =>$r['namasiswa'],
'nis' =>$r['nis'],
'nisn' =>$r['nisn'],
'panggilansiswa' =>$r['panggilansiswa'],
'jkelaminsiswa' =>$r['jkelaminsiswa'],
'tempatlahirsiswa' =>$r['tempatlahirsiswa'],
'tanggallahirsiswa' =>tgl_indo5($r['tanggallahirsiswa']),
'sukusiswa' =>$r['sukusiswa'],
'warganegarasiswa' =>$r['warganegarasiswa'],
'agamasiswa' =>$r['agamasiswa'],
'photosiswa' =>$r['photosiswa'],
'hpsiswa' =>$r['hpsiswa'],
'telponsiswa' =>$r['telponsiswa'],
'bahasasiswa1' =>$r['bahasasiswa1'],
// pr($cc);
$out.='</table>
</td>
</tr>
<tr><td colspan="3"> </td></tr>';
// bioadata siswa
$r=getField('*',$tb,'replid',$replid);
$photosiswa = $imageDir.$r['photosiswa'];
$out.='
<tr class="head">
<td colspan="3">Biodata Siswa</td>
</tr><tr>
<td width="25%">No. Pendaftaran</td>
<td>: '.(empty($r['nopendaftaran'])?'-':getNoPendaftaran2($_GET['replid'])).'</td>
<td rowspan="7" align="right"><img height="150" src="'.$photosiswa.'" alt="" /></td>
</tr><tr>
<td >Nama</td>
<td>: '.(empty($r['namasiswa'])?'-':$r['namasiswa']).' ('.(empty($r['panggilansiswa'])?'-':$r['panggilansiswa']).')</td>
</tr><tr>
<td>NIS</td>
<td>: '.(empty($r['nis'])?'-':$r['nis']).'</td>
</tr><tr>
<td>NISN</td>
<td>: '.(empty($r['nisn'])?'-':$r['nisn']).'</td>
</tr><tr>
<td>Jenis Kelamin</td>
<td>: '.(empty($r['jkelaminsiswa'])?'-':$r['jkelaminsiswa']=='L'?'Laki - laki':'Perempuan').'</td>
</tr><tr>
<td>Tempat / Tanggal Lahir</td>
$result = $obj->result;
#ada data
$jum = mysql_num_rows($result);
$out = '';
$totaset = 0;
if ($jum != 0) {
$nox = $starting + 1;
while ($res = mysql_fetch_assoc($result)) {
$color = $res['statusBayar'] == 'lunas' ? 'green' : ($res['statusBayar'] == 'belum' ? 'red' : 'yellow');
$btn = '<td align="center">
<button style="font-weight:bold;" onclick="viewFR(' . $res['idsiswa'] . ')"; class="fg-white bg-' . $color . '">
' . $res['statusBayar'] . '
</button>
</td>';
$out .= '<tr>
<td>' . getNoPendaftaran2($res['idsiswa']) . '</td>
<td>' . $res['namasiswa'] . '</td>
<td>' . $res['nisn'] . '</td>
<td>' . $res['nis'] . '</td>
<td>' . setuang($res['tagihan']) . '</td>
<td>' . setuang($res['terbayar']) . '</td>
' . $btn . '
<td align="center">
<button style="font-weight:bold;" onclick="viewFR2(' . $res['idsiswa'] . ')"; class="fg-white bg-blue">
<i class="icon-copy"></i>
</button>
</td>
</tr>';
}
} else {
#kosong
