<td align="right" width="20%">' . setuang($r3['nominal']) . '</td> </tr>'; } } $out .= '</tbody> <tfoot> <tr class="info fg-white"> <th colspan="3" align="right">Jumlah : </th> <th align="right">' . setuang($keluarTot) . '</th> </tr> </tfoot> </table>'; $saldoAkhir = $r['nominal'] + $masukTot - $keluarTot; $out .= '<table width="100%"> <tr> <td align="right"> Saldo Akhir : ' . setuang($saldoAkhir) . '</td> </tr> </table>'; $out .= '<hr>'; } } else { #kosong $out .= '<tr align="center"> <td colspan=9 ><span style="color:red;text-align:center;"> ... data tidak ditemukan...</span></td></tr>'; } echo $out; #generate html -> PDF ------------ $out2 = ob_get_contents(); ob_end_clean(); $mpdf = new mPDF('c', 'A4', '');
//9.600 - 2.800 $cc=''; foreach ($r7 as $i => $v) { $biayaAwal = $v['nominal']; $diskRegArr = getFieldArr3('detaildiskon','psb_siswadiskon','','siswabiaya',$v['replid']); $biayaAfterdiskReg = getBiayaDiskReg($v['detailbiaya'],$diskRegArr); $diskReg = $biayaAwal - $biayaAfterdiskReg; $diskKhusus = $v['diskonkhusus']; $biayaNett = $biayaAwal - ($diskReg+$diskKhusus); $cc.=$diskReg.'<br />'; $out.='<tr> <td style="background-color:grey;color:white;">'.(empty($v['biaya'])?'-':$v['biaya']).'</td> <td align="right">'.(empty($biayaAwal)?'Rp. 0':setuang($biayaAwal)).'</td> <td align="right">'.(empty($diskReg)?'Rp. 0':setuang($diskReg)).'</td> <td align="right">'.(empty($diskKhusus)?'Rp. 0':setuang($diskKhusus)).'</td> <td align="right">'.(empty($biayaNett)?'Rp. 0':setuang($biayaNett)).'</td> <td align="center">'.(empty($v['angsuran'])?'-':$v['angsuran'].' x').'</td> </tr>'; } // 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>'.$nox.'. '.$r1['golongan'].'<br> <sup class="fg-orange">('.$r1['keterangan'].')</sup></td>'; $s2 = 'SELECT db.replid, db.nominal, b.biaya FROM '.$tb.' db JOIN psb_biaya b on b.replid = db.biaya WHERE db.golongan = '.$r1['replid'].' AND db.subtingkat = '.$subtingkat.' AND db.detailgelombang = '.$detailgelombang.' ORDER BY b.biaya asc'; $e2= mysql_query($s2); while ($r2=mysql_fetch_assoc($e2)) { $out.='<td align="right">'.(!isAksi('detailbiaya','u')?setuang($r2['nominal']):'<div class="input-control text" ><input data-hint="'.$r2['biaya'].'" class="text-right" value="Rp. '.number_format($r2['nominal']).'" onclick="inputuang(this);" onfocus="inputuang(this);" type="text" name="nominalTB['.$r2['replid'].']"></div>').'</td>'; } $out.='</tr>'; $nox++; } } // vd($sss); break; // view ----------------------------------------------------------------- // add / edit ----------------------------------------------------------------- case 'simpan': $stat2= true;
<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', ''); $mpdf->SetDisplayMode('fullpage'); $stylesheet = file_get_contents('../../lib/mpdf/r_cetak.css'); $mpdf->WriteHTML($stylesheet, 1); $mpdf->WriteHTML($out); $mpdf->Output();
<td colspan="2">: '.(empty($r3['faxrumahibu'])?'-':$r3['faxrumahibu']).'</td> </tr><tr> <td >Pendidikan</td> <td colspan="2">: '.(empty($r3['pendidikanibu'])?'-':$r3['pendidikanibu']).'</td> </tr><tr> <td >Bidang Pekerjaan</td> <td colspan="2">: '.(empty($r3['bidangpekerjaanibu'])?'-':$r3['bidangpekerjaanibu']).'</td> </tr><tr> <td >Pekerjaan</td> <td colspan="2">: '.(empty($r3['pekerjaanibu'])?'-':$r3['pekerjaanibu']).'</td> </tr><tr> <td >Posisi</td> <td colspan="2">: '.(empty($r3['posisiibu'])?'-':$r3['posisiibu']).'</td> </tr><tr> <td >Penghasilan</td> <td colspan="2">: '.(empty($r3['penghasilanibu'])?'-':setuang($r3['penghasilanibu'])).'</td> </tr><tr> <td >Telpon Kantor</td> <td colspan="2">: '.(empty($r3['telponkantoribuibu'])?'-':$r3['telponkantoribuibu']).'</td> </tr><tr> <td >Fax Kantor</td> <td colspan="2">: '.(empty($r3['faxkantoribu'])?'-':$r3['faxkantoribu']).'</td> </tr><tr> <td >Alamat Kantor</td> <td colspan="2">: '.(empty($r3['alamatkantoribu'])?'-':$r3['alamatkantoribu']).'</td> </tr><tr> <td >Kode Pos </td> <td colspan="2">: '.(empty($r3['kodeposibu'])?'-':$r3['kodeposibu']).'</td> </tr><tr> <td colspan="3"> </td> </tr>';
$out .= '<tr > <td width="10%">' . tgl_indo5($r2['tanggal']) . '</td> <td width="20%">' . getNoKwitansi($r2['replid']) . '</td> <td width="30%">' . $r2['uraian'] . '</td> <td align="right" width="20%">' . $debit . '</td> <td align="right" width="20%">' . $kredit . '</td> </tr>'; } $selisihDebit = $debitTot - $kreditTot >= 0 ? setuang($debitTot - $kreditTot) : ''; $selisihKredit = $debitTot - $kreditTot < 0 ? setuang(abs($debitTot - $kreditTot)) : ''; $out .= '</tbody> <tfoot> <tr class="head"> <th colspan="3" align="right">Total</th> <th align="right">' . ($debitTot != 0 ? setuang($debitTot) : '') . '</th> <th align="right">' . ($kreditTot != 0 ? setuang($kreditTot) : '') . '</th> </tr> <tr class="head"> <th colspan="3" align="right">Grand Total</th> <th align="right">' . $selisihDebit . '</th> <th align="right">' . $selisihKredit . '</th> </tr> </tfoot> </table><br />'; } // $out.='</ul>'; } echo $out; #generate html -> PDF ------------ $out2 = ob_get_contents(); ob_end_clean();
$biayaArr=array(); //end of : biaya --------------- if($n==0) $stat='kosong'; else{ $stat='sukses'; while ($r=mysql_fetch_assoc($e)) { // diskon reguler ----------- $biayaArr[]=array( 'replid' =>$r['replid'], 'kode' =>$r['kode'], 'biaya' =>$r['biaya'], 'ditagih' =>$r['ditagih'], 'idsiswabiaya' =>(isset($_POST['siswa']) && $_POST['siswa']!=''?$r['idsiswabiaya']:''), 'angsuran' =>(isset($_POST['siswa']) && $_POST['siswa']!=''?$r['angsuran']:''), 'diskonkhusus' =>(isset($_POST['siswa']) && $_POST['siswa']!=''?setuang($r['diskonkhusus']):''), 'ketdiskonkhusus' =>(isset($_POST['siswa']) && $_POST['siswa']!=''?$r['ketdiskonkhusus']:''), 'isAngsur' =>$r['isAngsur'], 'isAngsur2' =>(isset($r['isAngsur2'])?$r['isAngsur2']:''), 'viabayar' =>(isset($r['viabayar'])?$r['viabayar']:''), 'isDiskon' =>$r['isDiskon'], ); } }$out=json_encode(array('status'=>$stat,'levelurutan'=>$_SESSION['levelurutanS'],'biayaArr'=>$biayaArr)); break; } break; // view ----------------------------------------------------------------- case 'getBiaya': if(!isset($_POST['detailgelombang']) || !isset($_POST['subtingkat']) || !isset($_POST['golongan']))
if ($page > $total_pages) { $page = $total_pages; } $start = $limit * $page - $limit; // do not put $limit*($page - 1) $ss .= ' GROUP BY dr.replid'; if ($total_pages != 0) { $ss .= ' ORDER BY ' . $sidx . ' ' . $sord . ' LIMIT ' . $start . ',' . $limit; } else { $ss .= ' ORDER BY ' . $sidx . ' ' . $sord; } // print_r($ss);exit(); $result = mysql_query($ss) or die("Couldn t execute query." . mysql_error()); $rows = array(); while ($row = mysql_fetch_assoc($result)) { $rows[] = array('replid' => $row['replid'], 'kode' => $row['kode'], 'detilRekening' => $row['detilRekening'], 'kategoriRekening' => $row['kategoriRekening'], 'saldoRekening' => setuang($row['saldoRekening'])); } $response = array('page' => $page, 'total' => $total_pages, 'records' => $count, 'rows' => $rows); $out = json_encode($response); } else { $out = json_encode(array('status' => 'invalid_no_post')); } } else { switch ($_POST['aksi']) { // ----------------------------------------------------------------- case 'tampil': $departemen = isset($_POST['departemenS']) ? $_POST['departemenS'] : ''; $tahunajaran = isset($_POST['tahunajaranS']) ? $_POST['tahunajaranS'] : ''; $biaya = isset($_POST['biayaS']) ? $_POST['biayaS'] : ''; $detilrekening = isset($_POST['detilrekeningS']) ? $_POST['detilrekeningS'] : ''; $sql = 'SELECT
$out = json_encode(array( 'status' =>$stat, // pembayaran 'setbiaya' =>$r['setbiaya'], 'dpp' =>$regNum, 'angsuran' =>$r['angsuran'], 'discangsuran' =>$discangsuran, 'discsubsidi' =>setuang($r['discsubsidi']), 'discsaudara' =>setuang($r['discsaudara']), 'iddisctunai' =>$r['disctunai'], 'disctunai' =>$disctunai, 'disctotal' =>setuang(getDiscTotal($_POST['replid'])), 'dppnet' =>$regNumNet, 'joiningf' =>setuang($r['joiningf']), 'spp' =>setuang($r['spp']), 'daftar' =>setuang($r['daftar']), // data siswa 'nopendaftaranH' =>$r['nopendaftaran'], 'nopendaftaran' =>$nopendaftaran, 'namaSiswa' =>$r['namaSiswa'], 'proses' =>$proses, 'kelompok' =>$r['kelompok'], 'kriteria' =>$r['kriteria'], 'golongan' =>$r['golongan'], 'kelamin' =>$r['kelamin'], 'tmplahir' =>$r['tmplahir'], 'tgllahir' =>tgl_indo5($r['tgllahir']), 'agama' =>$r['agama'], 'alamat' =>$r['alamat'], 'telpon' =>$r['telpon'],
// <i class="icon-pencil"></i> // </button> $btn = ' <td align="center"> <button ' . (isAksi($mnu, 'd') ? 'onclick="del(' . $res['replid'] . ');"' : 'disabled') . ' data-hint="hapus" > <i class="icon-remove"></i> </button> </td>'; $out .= '<tr> <td>' . tgl_indo5($res['tgl']) . '</td> <td>' . $res['nis'] . '</td> <td>' . $res['namasiswa'] . '</td> <td>-</td> <td>' . $res['nomom'] . '</td> <td>' . tgl_indo5($res['tglmom']) . '</td> <td align="right">' . setuang($res['biayaKurangTot']) . '</td> ' . $btn . ' </tr>'; // <td>'.getTotalPemutihan($res['replid']).'</td> $nox++; } } 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;
$biayaNett = getBiayaNett2($_POST['replid'], $_POST['biaya']); $angsuranNominal = getAngsuranNominal($_POST['replid'], $_POST['biaya']); // terbayar $terbayarAngsurankeReal = getTerbayarAngsuranke($_POST['replid'], $_POST['biaya']); $terbayarBaru = getTerbayarBaru($_POST['replid'], $_POST['biaya']); $terbayarTotal = getTerbayarTotal($_POST['replid'], $_POST['biaya']); $terbayarAngsurankeRule = ceil($terbayarTotal / $angsuranNominal); // akan bayar $akanBayarke = $terbayarTotal % $angsuranNominal == 0 ? $terbayarAngsurankeRule + 1 : $terbayarAngsurankeRule; $lunasPerAngsuran = $terbayarTotal % $angsuranNominal == 0 ? true : false; $lunasTotalAngsuran = $terbayarTotal == $biayaNett ? true : false; $kuranganAngsuran = $terbayarAngsurankeRule == $akanBayarke ? $angsuranNominal - $terbayarBaru : 0; //belum bayar $belumBayarAngsuranke = intval($r['angsuran']) - intval($akanBayarke); $semester = getField('semester', 'aka_semester', 'replid', $r['idsemester']); $out = json_encode(array('status' => $stat, 'datax' => array('idsiswabiaya' => $r['idsiswabiaya'], 'ditagih' => $r['ditagih'], 'idsemester' => $r['idsemester'], 'idsemester' => $r['idsemester'], 'semester' => $semester == '1' ? 'Ganjil' : 'Genap', 'namasiswa' => $r['namasiswa'], 'kelas' => $r['kelas'], 'biaya' => $r['biaya'], 'nis' => $r['nis'], 'biayaAwal' => setuang($r['biayaAwal']), 'biayaNett' => setuang($biayaNett), 'totalDiskon' => setuang($r['biayaAwal'] - $biayaNett), 'kuranganAngsuran' => $kuranganAngsuran, 'viabayar' => $r['viabayar'], 'isAngsur2' => $r['isAngsur2'], 'angsuran' => $r['angsuran'], 'angsuranNominal' => setuang($angsuranNominal), 'lunasPerAngsuran' => $lunasPerAngsuran, 'lunasTotalAngsuran' => $lunasTotalAngsuran, 'terbayarAngsurankeReal' => $terbayarAngsurankeReal, 'terbayarAngsurankeRule' => $terbayarAngsurankeRule, 'terbayarBaru' => setuang($terbayarBaru), 'terbayarTotal' => setuang($terbayarTotal), 'akanBayarke' => $akanBayarke, 'belumBayarAngsuranke' => $belumBayarAngsuranke))); break; case 'kodegenerate': $s = 'SELECT tb1.lokasi, tb1.grup, tb1.tempat, tb1.katalog, tb2.barang, LPAD(tb2.barang,5,0)barkode FROM ( SELECT l.kode lokasi, g.kode grup, t.kode tempat, k.kode katalog
'telponkantorayah' =>$r['telponkantorayah'], 'faxkantorayah' =>$r['faxkantorayah'], 'gerejaayah' =>$r['gerejaayah'], //ibu 'namaibu' =>$r['namaibu'], 'tempatlahiribu' =>$r['tempatlahiribu'], 'tanggallahiribu' =>$r['tanggallahiribu']=='0000-00-00'?'':tgl_indo5($r['tanggallahiribu']), 'agamaibu' =>$r['agamaibu'], 'warganegaraibu' =>$r['warganegaraibu'], 'kodeposibu' =>$r['kodeposibu'], 'kotaibu' =>$r['kotaibu'], 'pendidikanibu' =>$r['pendidikanibu'], 'bidangpekerjaanibu' =>$r['bidangpekerjaanibu'], 'pekerjaanibu' =>$r['pekerjaanibu'], 'posisiibu' =>$r['posisiibu'], 'penghasilanibu' =>setuang($r['penghasilanibu']), 'telponibu' =>$r['telponibu'], 'emailibu' =>$r['emailibu'], 'pinbbibu' =>$r['pinbbibu'], 'alamatibu' =>$r['alamatibu'], 'hpibu' =>$r['hpibu'], 'faxrumahibu' =>$r['faxrumahibu'], 'alamatkantoribu' =>$r['alamatkantoribu'], 'telponkantoribu' =>$r['telponkantoribu'], 'faxkantoribu' =>$r['faxkantoribu'], 'gerejaibu' =>$r['gerejaibu'], // biodata wali 'idsiswawali' =>$r['idsiswawali'], 'namawali' =>$r['namawali'], 'jkelaminwali' =>$r['jkelaminwali'], 'alamatwali' =>$r['alamatwali'],
db.replid, db.nominal, b.biaya FROM ' . $tb . ' db JOIN psb_biaya b on b.replid = db.biaya WHERE db.golongan = ' . $r1['replid'] . ' AND db.subtingkat = ' . $subtingkat . ' AND db.detailgelombang = ' . $detailgelombang . ' ORDER BY b.biaya asc'; // pr($s2); $e2 = mysql_query($s2); while ($r2 = mysql_fetch_assoc($e2)) { if (!isAksi('detailbiaya', 'u')) { $field = setuang($r2['nominal']); } else { $field = '<div class="input-control text" > <input data-hint="' . $r2['biaya'] . '" class="text-right" value="Rp. ' . number_format($r2['nominal']) . '" onclick="inputuang(this);" onfocus="inputuang(this);" type="text" name="nominalTB[' . $r2['replid'] . ']"> </div>'; // <a onclick="viewFR('.$r2['replid'].');" class="button fg-white bg-blue" href="#" data-hint="rekening"> // <i class=" icon-cc-nc"></i> // </a> } $out .= '<td align="right">' . $field . '</td>'; } $out .= '</tr>'; $nox++; } }
function getDetAnggaranFull($id) { $s = 'SELECT da.detilanggaran, ka.kategorianggaran, getAnggaranPerItem(' . $id . ')kuota FROM keu_anggarantahunan ath JOIN keu_detilanggaran da on da.replid = ath.detilanggaran JOIN keu_kategorianggaran ka on ka.replid = da.kategorianggaran WHERE ath.replid=' . $id; // pr($s); $e = mysql_query($s); $r = mysql_fetch_assoc($e); return $r['detilanggaran'] . ' (' . $r['kategorianggaran'] . ') | kuota : ' . setuang($r['kuota']); }
if (!$e) { $stat = 'gagal_ambiledit_anggaran_tahunan'; } else { $s2 = 'SELECT replid, jml, bulan FROM keu_nominalanggaran WHERE anggarantahunan =' . $_POST['replid']; $e2 = mysql_query($s2); $stat = !$e2 ? 'gagal_nominalanggaran' : 'sukses'; $nominalArr = array(); $totJml = $totJmlHrg = 0; while ($r2 = mysql_fetch_assoc($e2)) { $jmlHrg = intval($r2['jml']) * intval($r['hargasatuan']); $totJml += $r2['jml']; $totJmlHrg += $jmlHrg; $nominalArr[] = array('replid' => $r2['replid'], 'jml' => $r2['jml'], 'bulan' => $r2['bulan'], 'jmlHrg' => setuang($jmlHrg)); } } $out = json_encode(array('status' => $stat, 'departemen' => $r['departemen'], 'tahunajaran' => $r['tahunajaran'], 'tingkat' => $r['tingkat'], 'kategorianggaran' => $r['kategorianggaran'], 'detilanggaran' => $r['detilanggaran'], 'hargasatuan' => setuang($r['hargasatuan']), 'keterangan' => $r['keterangan'], 'nominalArr' => $nominalArr, 'totJml' => $totJml, 'totJmlHrg' => setuang($totJmlHrg))); break; // ambiledit ------------------------------------------------------------------ // generate barcode ----------------------------------------------------------- // ambiledit ------------------------------------------------------------------ // generate barcode ----------------------------------------------------------- case 'kodegenerate': $s = 'SELECT tb1.lokasi, tb1.grup, tb1.tempat, tb1.katalog, tb2.barang, LPAD(tb2.barang,5,0)barkode FROM ( SELECT
$totNominal += $r2['nominal']; } } $out .= '<tr class="head"> <td colspan="2" align="center">Total Terbayar </td> <td style="background-color:lightBlue;" align="right">' . setuang($totNominal) . '</td> </tr><tr> <td>* Total Kurangan </td> <td>: </td> <td style="background-color:lightBlue;" align="right">' . setuang(intval($r['biayaNett']) - $totNominal) . '</td> </tr>'; } $out .= '<tr> <td >* Tagihan ' . ($r['isAngsur2'] == 1 ? ' Angsuran ke-' . ($angsuranKe == 0 ? 1 : $angsuranKe + 1) : '') . '</td> <td ' . ($r['isAngsur2'] != 1 ? 'style="background-color:pink;"' : '') . '>: ' . ($r['isAngsur2'] != 1 ? setuang($r['biayaNett']) : '') . '</td> <td ' . ($r['isAngsur2'] == 1 ? 'align="right" style="background-color:pink;"' : '') . ' >' . ($r['isAngsur2'] == 1 ? setuang($r['angsurNom']) : '') . '</td> </tr><tr> <td>* Terbilang</td> <td colspan="2">: ' . Terbilang($r['isAngsur2'] == 1 ? $r['angsurNom'] : $r['biayaNett']) . ' Rupiah</td> </tr> </table>'; // pr(intval($r['biayaNett'])); $out .= '</body>'; echo $out; #generate html -> PDF ------------ $out2 = ob_get_contents(); ob_end_clean(); $mpdf = new mPDF('c', 'A4', ''); $mpdf->SetDisplayMode('fullpage'); $stylesheet = file_get_contents('../../lib/mpdf/r_cetak.css'); $mpdf->WriteHTML($stylesheet, 1);
break; case 'ju': $s = 'SELECT * FROM ' . $tb . ' WHERE replid=' . $_POST['replid']; // var_dump($s);exit(); $e = mysql_query($s); $r = mysql_fetch_assoc($e); $stat = $e ? 'sukses' : 'gagal'; if (!$e) { $stat = 'gagal'; } else { //sukses $s2 = 'SELECT * FROM keu_jurnal WHERE transaksi =' . $_POST['replid'] . ' ORDER BY jenis ASC'; $e2 = mysql_query($s2); $jurnalArr = array(); while ($r2 = mysql_fetch_assoc($e2)) { $jurnalArr[] = array('idjurnal' => $r2['replid'], 'idrek' => $r2['rek'], 'rek' => getRekBy('nama', $r2['rek']), 'nominal' => setuang($r2['nominal']), 'jenis' => $r2['jenis']); } $transaksiArr = array('nomer' => $r['nomer'], 'nobukti' => $r['nobukti'], 'tanggal' => tgl_indo7($r['tanggal']), 'uraian' => $r['uraian'], 'jurnalArr' => $jurnalArr); $stat = 'sukses'; } $out = json_encode(array('status' => $stat, 'transaksiArr' => $transaksiArr)); break; } break; // ambiledit ------------------------------------------------------------------ // generate barcode ----------------------------------------------------------- // ambiledit ------------------------------------------------------------------ // generate barcode ----------------------------------------------------------- case 'kodegenerate': $s = 'SELECT tb1.lokasi,
$e2 = mysql_query($s2); while($r2 = mysql_fetch_assoc($e2)){ $itemArr[]=array( 'iditem' =>$r2['replid'], 'item' =>$r2['item'], 'jumlah' =>$r2['jumlah'], 'biayaSat' =>intval($r2['biaya']), 'biayaTot' =>(intval($r2['biaya']) * intval($r2['jumlah'])), ); $biayaSatSum+=intval($r2['biaya']); $biayaTotSum+=(intval($r2['biaya']) * intval($r2['jumlah'])); } $stat = ($e2)?'sukses':'gagal_ambil_detail_aktivitas'; }$out = json_encode(array( 'status' =>$stat, 'lokasi' =>$r['lokasi'], 'tanggal1' =>tgl_indo5($r['tanggal1']), 'tanggal2' =>tgl_indo5($r['tanggal2']), 'tgltagihan' =>tgl_indo5($r['tgltagihan']), 'aktivitas' =>$r['aktivitas'], 'keterangan' =>$r['keterangan'], 'iddetilanggaran' =>$r['iddetilanggaran'], 'detilanggaran' =>$r['detilanggaran'].' [sisa : '.setuang($r['anggaranSisa']).', kuota : '.setuang($r['anggaranKuota']).']', 'sisaNum' =>setuang($r['anggaranSisa']), 'itemArr' =>$itemArr )); break; // ambiledit ----------------------------------------------------------------- } }echo $out; ?>
if ($res['idkategorirekening'] != $curKat) { // kategori rek $ss = 'SELECT replid,nama,RPAD(kode,6,0)kode from keu_kategorirekening where replid=' . $res['idkategorirekening']; $ee = mysql_query($ss); $rr = mysql_fetch_assoc($ee); $out .= '<tr class="bg-lightTeal"> <td align="right"><b>' . $rr['kode'] . '</b></td> <td colspan="6"><b>' . $rr['nama'] . '</b></td> </tr>'; } $btn = '<td align="center"> <button data-hint="ubah" class="button" onclick="viewFR(' . $res['replid'] . ');"> <i class="icon-pencil on-left"></i> </button> </td>'; $saldoAwal = setuang($res['saldo']); $out .= '<tr> <td class="text-right">' . $res['kode'] . '</td> <td>' . $res['nama'] . '</td> <td class="text-right">' . ($res['jenis'] == 'd' ? 'debit' : 'kredit') . '</td> <td class="text-right">' . $saldoAwal . ',-</td> ' . $btn . ' </tr>'; $curKat = $res['idkategorirekening']; $nox++; } } else { #kosong $out .= '<tr align="center"> <td colspan=9><span style="color:red;text-align:center;"> ... data tidak ditemukan...</span></td></tr>';
<td align="right" class="fg-white bg-red">: ' . setuang($subtotal) . '</td> </tr><tr> <td colspan="3"> </td> </tr>'; } // laba tahun berjalan $out .= '<tr> <td>Laba Tahun berjalan </td> <td align="right">Rp. 500.000</td> <td></td> </tr>'; $out .= ' <tr><td colspan="3"> </td></tr> <tr> <td align="right" colspan="2">Grand Total</td> <td class="bg-red fg-white" align="right">' . setuang($grandtotalr) . '</td> </tr> </table> </td> </tr> </tbody>'; $out .= '<tbody>'; $grandTot = 0; $out .= '</table> </body>'; echo $out; #generate html -> PDF ------------ $out2 = ob_get_contents(); ob_end_clean(); $mpdf = new mPDF('c', 'A4', ''); $mpdf->SetDisplayMode('fullpage');
<td align="center">Nominal</td> <td align="center">Nama Akun</td> </tr>'; $tot = 0; while ($rc = mysql_fetch_assoc($ec)) { $out .= '<tr> <td align="center">' . $rc['rekKode'] . '</td> <td align="right">' . $rc['subtotal'] . '</td> <td>' . $rc['rekNama'] . '</td> </tr>'; // <td align="right">'.setuang($rc['subtotal']).'</td> $tot += $rc['subtotal']; } $out .= '<tr class="head"> <td align="right">Total : </td> <td align="right">' . setuang($tot) . '</td> <td></td> </tr>'; $out .= '</table><br />'; $out .= '<jpgraph title="Grafik ' . $mnu . '" table="grafikTBL" type="pie3d" percent="1" data-col-begin="2" data-row-begin="2" data-col-end="2" data-row-end="-1" show-values="1" width="700" height="300"
<td width="20%">Golongan</td> <td>: ' . $golongan . '</td> </tr>'; // Pembayaran $out .= ' <tr class="head"> <td colspan="3">Pembayaran</td> </tr><tr> <td width="20%">Registration Fee</td> <td>: ' . setuang(getBiayaNet('registration', $r['replid'])) . ' (' . ($r['angsuran'] == 1 ? 'cash' : $r['angsuran'] . 'x angsuran') . ')</td> </tr><tr> <td width="20%">Material Fee</td> <td>: ' . setuang(getBiaya('material', $r['replid'])) . '</td> </tr><tr> <td width="20%">Tuition Fee</td> <td>: ' . setuang(getBiaya('tuition', $r['replid'])) . '</td> </tr>'; // bio data calon siswa $out .= ' <tr class="head"> <td colspan="3">Biodata Siswa</td> </tr><tr> <td width="20%">No. Pendaftaran</td> <td>: ' . getNoPendaftaran($replid, $r['kelompok'])['akhir'] . '</td> <td align="right" rowspan="5"><img height="120" src="../img/upload/' . $r['photo'] . '" alt="" /></td> </tr><tr> <td width="20%">Nama Lengkap</td> <td>: ' . $r['nama'] . '</td> </tr><tr> <td width="20%">Jenis Kelamin</td> <td>: ' . $r['kelamin'] . '</td>
<td></td> </tr>'; $subtot += $r2['nominal']; $grandTot = $r1['posisi'] == 'r' ? $grandTot - $r2['nominal'] : $grandTot + $r2['nominal']; } $out .= '<tr> <td colspan="2"></td> <td style="background-color:lightGrey;" align="right">' . setuang($subtot) . '</td> </tr>'; $out .= '</tr>'; } $out .= '</tbody> <tfoot> <tr> <th colspan="2" align="right" >' . ($grandTot < 0 ? ' Rugi' : 'Laba') . '</th> <th align="right">' . setuang($grandTot) . '</th> </tr> </tfoot>'; $out .= '</table>'; echo $out; #generate html -> PDF ------------ $out2 = ob_get_contents(); ob_end_clean(); $mpdf = new mPDF('c', 'A4', ''); $mpdf->SetDisplayMode('fullpage'); $stylesheet = file_get_contents('../../lib/mpdf/r_cetak.css'); $mpdf->WriteHTML($stylesheet, 1); $mpdf->WriteHTML($out); $mpdf->Output(); } }
</tr>'; } else { while ($r = mysql_fetch_assoc($e)) { $debitTot += $r['saldoRekening'] < 0 ? 0 : $r['saldoRekening']; $kreditTot += $r['saldoRekening'] > 0 ? 0 : abs($r['saldoRekening']); $out .= '<tr> <td align="center">' . $r['kode'] . '</td> <td>' . $r['nama'] . '</td> <td align="right">' . ($r['saldoRekening'] < 0 ? '' : setuang($r['saldoRekening'])) . '</td> <td align="right">' . ($r['saldoRekening'] > 0 ? '' : setuang(abs($r['saldoRekening']))) . '</td> </tr>'; } } $out .= '<tr class="head"><td colspan="2" align="right">Jumlah :</td> <td align="right"><b>' . setuang($debitTot) . '</b></td> <td align="right"><b>' . setuang($kreditTot) . '</b></td> </tr>'; $out .= '</table>'; echo $out; #generate html -> PDF ------------ $out2 = ob_get_contents(); ob_end_clean(); $mpdf = new mPDF('c', 'A4', ''); $mpdf->SetDisplayMode('fullpage'); $stylesheet = file_get_contents('../../lib/mpdf/r_cetak.css'); $mpdf->WriteHTML($stylesheet, 1); $mpdf->WriteHTML($out); $mpdf->Output(); } } // ---------------------- //
j.jenisrekening, dr.replid iddetilrekening, concat(dr.nama," - ",dr.nama)detilrekening, j.nominal, sr.nominal saldorekening FROM keu_jurnal j JOIN keu_detilrekening dr on dr.replid = j.detilrekening JOIN keu_saldorekening sr on sr.detilrekening = dr.replid WHERE j.transaksi =' . $_POST['replid'] . ' GROUP BY dr.replid ORDER BY j.jenisrekening ASC'; // pr($s2); $e2 = mysql_query($s2); $jurnalArr = array(); while ($r2 = mysql_fetch_assoc($e2)) { $jurnalArr[] = array('idjurnal' => $r2['replid'], 'jenisrekening' => $r2['jenisrekening'], 'iddetilrekening' => $r2['iddetilrekening'], 'detilrekening' => $r2['detilrekening'], 'nominal' => setuang($r2['nominal']), 'saldorekening' => setuang($r2['saldorekening'])); } $transaksiArr = array('idkwitansi' => $r['idkwitansi'], 'detjenistransaksi' => $r['detjenistransaksi'], 'nobukti' => $r['nobukti'], 'tanggal' => tgl_indo7($r['tanggal']), 'uraian' => $r['uraian'], 'jurnalArr' => $jurnalArr); $stat = 'sukses'; } $out = json_encode(array('status' => $stat, 'transaksiArr' => $transaksiArr)); break; } break; // ambiledit ------------------------------------------------------------------ // generate barcode ----------------------------------------------------------- // ambiledit ------------------------------------------------------------------ // generate barcode ----------------------------------------------------------- case 'kodegenerate': $s = 'SELECT tb1.lokasi,
$s2 = ' SELECT * FROM keu_jurnal WHERE transaksi =' . $r['replid'] . ' ORDER BY jenisrekening ASC '; $e2 = mysql_query($s2); $tb2 = ''; if (mysql_num_rows($e2) != 0) { $tb2 .= '<table class="isi" width="100%"> <tr class="head"> <td width="60%">Rekening</td> <td width="20%">Debit</td> <td width="20%">Kredit</td> </tr>'; while ($r2 = mysql_fetch_assoc($e2)) { $debit = $r2['jenisrekening'] == 'd' ? setuang($r2['nominal']) : '-'; $kredit = $r2['jenisrekening'] == 'k' ? setuang($r2['nominal']) : '-'; $tb2 .= '<tr> <td width="60%">' . getRekening($r2['detilrekening']) . '</td> <td width="20%" align="right">' . $debit . '</td> <td width="20%" align="right">' . $kredit . '</td> </tr>'; } $tb2 .= '</table>'; } $out .= '<tr> <td width="12%" valign="top">' . tgl_indo5($r['tanggal']) . '</td> <td width="18%" valign="top" style="font-weight:bold;">' . getNoKwitansi($r['replid']) . '<br>' . $r['nobukti'] . '</td> <td width="15%" valign="top">' . $r['uraian'] . '</td> <td width="55%">' . $tb2 . '</td> </tr>'; }
$biayaTerbayar += $v['biayaTerbayar']; $biayaKurang += $v['biayaKurang']; $biayaTotal += $v['biayaTerbayar'] + $v['biayaKurang']; $out .= '<tr> <td>' . $no . '. ' . $v['tingkat'] . '</td> <td align="right">' . setuang($v['biayaTerbayar']) . '</td> <td align="right">' . setuang($v['biayaKurang']) . '</td> <td align="right">' . setuang($v['biayaKurang'] + $v['biayaTerbayar']) . '</td> </tr>'; $no++; } $out .= '<tr class="head"> <td align="right">biayaTotal:</td> <td align="right">' . setuang($biayaTerbayar) . '</td> <td align="right">' . setuang($biayaKurang) . '</td> <td align="right">' . setuang($biayaTotal) . '</td> </tr>'; } // pr($cc); $out .= '</table> </td> </tr> <tr><td colspan="3"> </td></tr>'; $out .= '</table>'; $out .= '</body>'; echo $out; #generate html -> PDF ------------ $out2 = ob_get_contents(); ob_end_clean(); $mpdf = new mPDF('c', 'A4', ''); $mpdf->SetDisplayMode('fullpage');
<td>Sebanyak </td> <td>: ' . Terbilang($r['nominal']) . ' Rupiah </td> </tr> <tr> <td>Untuk </td> <td>: Pembayaran ' . $r['biaya'] . ' </td> </tr> <tr> <td colspan="2" align="right">Surabaya, ' . tgl_indo8($r['tanggal']) . ' </td> </tr> <tr> <td colspan="2" align="right">ttd </td> </tr> <tr> <td>Terbilang </td> <td>: ' . setuang($r['nominal']) . ' </td> </tr> </table>'; $out .= '</body>'; echo $out; #generate html -> PDF ------------ $out2 = ob_get_contents(); ob_end_clean(); $mpdf = new mPDF('c', 'A4', ''); $mpdf->SetDisplayMode('fullpage'); $stylesheet = file_get_contents('../../lib/mpdf/r_cetak.css'); $mpdf->WriteHTML($stylesheet, 1); $mpdf->WriteHTML($out); $mpdf->Output(); } }
-- LEFT JOIN aka_tingkat t ON t.replid = c.tingkat WHERE c.replid=' . $_POST['replid']; $e = mysql_query($s) or die(mysql_error()); $r = mysql_fetch_assoc($e); // print_r($r);exit(); $stat = $e ? 'sukses' : 'gagal'; $regNum = setuang(getBiaya('registration', $_POST['replid'])); $regNumNet = setuang(getBiayaNet('registration', $_POST['replid'])); $nopendaftaran = getNoPendaftaran($_POST['replid'], $r['kelompok'])['akhir']; // $tingkat = getField('tingkat','psb_calonsiswa','replid',$r['tingkat']); $tahunajaran = getField('tahunajaran', 'psb_kelompok', 'replid', $r['kelompok']); $discangsuran = setuang(getDiscAngsuran($regNum, $r['angsuran'])); $disctunai = setuang(getDisc('disctunai', $_POST['replid'])); // var_dump($tingkat);exit(); $out = json_encode(array('status' => $stat, 'setbiaya' => $r['setbiaya'], 'registration' => $regNum, 'angsuran' => $r['angsuran'], 'discangsuran' => $discangsuran, 'discsubsidi' => setuang($r['discsubsidi']), 'discsaudara' => setuang($r['discsaudara']), 'iddisctunai' => $r['disctunai'], 'disctunai' => $disctunai, 'disctotal' => setuang(getDiscTotal($_POST['replid'])), 'registrationnet' => $regNumNet, 'material' => setuang($r['material']), 'tuition' => setuang($r['tuition']), 'nopendaftaranH' => $r['nopendaftaran'], 'nopendaftaran' => $nopendaftaran, 'namaSiswa' => $r['namaSiswa'], 'tahunajaran' => $tahunajaran, 'kelompok' => $r['kelompok'], 'tingkat' => $r['tingkat'], 'golongan' => $r['golongan'], 'kelamin' => $r['kelamin'], 'tmplahir' => $r['tmplahir'], 'tgllahir' => tgl_indo5($r['tgllahir']), 'agama' => $r['agama'], 'alamat' => $r['alamat'], 'telpon' => $r['telpon'], 'sekolahasal' => $r['sekolahasal'], 'photo' => $r['photo'], 'darah' => $r['darah'], 'kesehatan' => $r['kesehatan'], 'ketkesehatan' => $r['ketkesehatan'], 'namaAyah' => $r['namaAyah'], 'kebangsaanAyah' => $r['kebangsaanAyah'], 'tmplahirAyah' => $r['tmplahirAyah'], 'tgllahirAyah' => tgl_indo5($r['tgllahirAyah']), 'pekerjaanAyah' => $r['pekerjaanAyah'], 'telponAyah' => $r['telponAyah'], 'pinbbAyah' => $r['pinbbAyah'], 'emailAyah' => $r['emailAyah'], 'namaIbu' => $r['namaIbu'], 'kebangsaanIbu' => $r['kebangsaanIbu'], 'tmplahirIbu' => $r['tmplahirIbu'], 'tgllahirIbu' => tgl_indo5($r['tgllahirIbu']), 'pekerjaanIbu' => $r['pekerjaanIbu'], 'telponIbu' => $r['telponIbu'], 'pinbbIbu' => $r['pinbbIbu'], 'emailIbu' => $r['emailIbu'], 'namaKakek' => $r['namaKakek'], 'namaNenek' => $r['namaNenek'], 'namaDarurat' => $r['namaDarurat'], 'hubungan' => $r['hubungan'], 'telponDarurat' => $r['telponDarurat'])); break; // ambiledit ----------------------------------------------------------------- //detail siswa // ambiledit ----------------------------------------------------------------- //detail siswa case 'detail': $s = ' SELECT t.replid, d.nama departemen, akt.tahunajaran tahunajaran, k.kelompok kelompok, t.nopendaftaran nopendaftaran, t.status statusx, t.nama as nama_siswa, if(t.kelamin="L","Laki-Laki","Perempuan") jk,