$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