function budget_opt($s=1,$i=0){ $tbuku=tahunbuku_getaktifid(); $res=Array(); if($s==1)$res[0]=''; $sql="SELECT * FROM keu_budget WHERE tahunbuku='$tbuku' ORDER BY nama"; $t=mysql_query($sql); while($r=mysql_fetch_array($t)){ $sisa=budget_getnominal($r['replid'])-budget_getuses($r['replid']); $res[$r['replid']]=$r['nama'].($i!=1?'':' (sisa anggaran: '.fRp($sisa).')'); } return $res; }
function iTextC($d='',$v='',$s='',$p='',$cb='',$at=''){ $bc=""; $bc2=""; if($cb!=""){$n=preg_match("/onblur=\".+\"/", $cb,$m); if($n>0){ $bc=str_replace("\"","",$m[0]); $bc=";".str_replace("onblur=","",$bc); $cb=str_replace($m[0],"",$cb); }} if($cb!=""){$n=preg_match("/onfocus=\".+\"/", $cb,$m); if($n>0){ $bc2=str_replace("\"","",$m[0]); $bc2=";".str_replace("onfocus=","",$bc2); $cb=str_replace($m[0],"",$cb); }} if(is_array($v)) $v=$v[$d]; if(!is_numeric($v)) $v=0; if($p==''){ if(defined('ITEXTC_SHOW_NUL')){ if(ITEXTC_SHOW_NUL==0) $p='Rp'; } } return "<input type=\"text\" class=\"iText\"".(($d=="")?"":" id=\"".$d."\" name=\"".$d."\" ").(($s=="")?"style=\"width:150px\"":" style=\"".$s."\" ")." value=\"".fRp($v)."\" ".(($p=="")?"":" placeholder=\"".$p."\" ").($cb==""?"":" ".$cb." ").($at==""?"":" ".$at." ")."onfocus=\"this.className='iTextx';ufRpt(this);".$bc2."\" onblur=\"this.className='iText';fRpt(this)".$bc."\"/>"; }
$xtable->btnbar_add(); } else { echo '<div class="infobox" style="float:left;margin-left:40px">Kuota periode pendaftaran ini telah penuh.</div>'; } $xtable->btnbar_print(); $xtable->search_box(); $xtable->btnbar_end(); if ($xtable->ndata > 0) { $xtable->head_addrow('@Nomor pendaftaran{2,100px}', '@Nama{2}', 'Uang pangkal{R,2}', 'Discount{C,1,3}', 'Denda{R,2}', 'Uang pangkal net{R,2,90px}', 'Angsuran{R}'); $xtable->head_addrow('Subsidi{R}', 'Saudara{R}', 'Tunai{R}', '!x bulan{R}'); $xtable->head_multi(); while ($r = mysql_fetch_array($t)) { $xtable->row_begin(); $xtable->td($r['nopendaftaran'], 100); $xtable->td($r['nama']); $xtable->td(fRp($r['sumpokok']), 90, 'r'); $xtable->td(fRp($r['disctb']), 90, 'r'); $xtable->td(fRp($r['discsaudara']), 90, 'r'); $xtable->td(fRp($r['disctunai']), 90, 'r'); $xtable->td(fRp($r['denda']), 90, 'r'); $xtable->td(fRp($r['sumnet']), 90, 'r'); $xtable->td(fRp($r['angsuran']) . '<br/>x ' . $r['jmlangsur'] . ' bulan', 90, 'r'); $xtable->opt($r['replid'], 'v', 'u', 'd'); $xtable->row_end(); } $xtable->foot(); } } } else { departemen_warn(1); }
$tglSearch .= '<button style="float:left;margin-left:30px;margin-right:4px" class="btnz" onclick="transaksi_get()">'; $tglSearch .= '<div class="">Tampilkan »</div>'; $tglSearch .= '</button>'; $t .= $tglSearch; $t .= '</div>'; $xtable->btnbar_f('print', 'srcbox', $t . '<br>', $s); hiddenval('modul', $modid); hiddenval('pembayaran', 0); if ($xtable->ndata > 0) { $xtable->head('@No pendaftaran', '@Nama', 'Biaya pendaftaran{R}', 'Jumlah dibayar{R}', '@Tanggal pembayaran', '@Status'); while ($r = mysql_fetch_array($t)) { $xtable->row_begin(); $xtable->td($r['nopendaftaran'], 120); $xtable->td($r['nama']); $xtable->td(fRp($r['nominal']), 110, 'r'); $xtable->td(fRp($r['jmlbayar']), 110, 'r'); if ($r['lunas'] == '1') { $s = '<div style="padding:2px;border-radius:2px;background:#00d000;color:#fff;width:96px;margin:auto"><b>Sudah bayar</b></div>'; } else { $s = '<button class="btn" title="Klik untuk transaksi pembayaran." onclick="E(\'pembayaran\').value=' . $r['replid'] . ';pembayaran_form(\'af\')" style="width:100px">Belum bayar</button>'; } $xtable->td(fftgl($r['tglbayar']), 140); $xtable->td($s, 110, 'c'); $xtable->row_end(); } $xtable->foot(); } else { $xtable->nodata_cust('Tidak ditemukan data pembayaran.'); } // End of Tabel transaksi } else {
?> </div> <?php notifbox(); if ($xtable->ndata > 0) { // Table head $xtable->head(' ', 'Kelompok', 'tanggal pendaftaran~C', 'Biaya pendaftaran{R}', 'Calon Siswa~C', 'Siswa Diterima~C', 'Keterangan'); $k = 0; while ($r = mysql_fetch_array($t)) { $xtable->row_begin(); $q = mysql_query("SELECT replid FROM psb_calonsiswa WHERE kelompok='" . $r['replid'] . "'"); $n = mysql_num_rows($q); $q = mysql_query("SELECT replid FROM psb_calonsiswa WHERE kelompok='" . $r['replid'] . "' AND status<>0"); $n1 = mysql_num_rows($q); $xtable->td('<div style="margin:auto;width:14px;height:14px;background:' . $bcolor[$k++] . '"></div>', 20, 'c'); $xtable->td($r['kelompok'], 300); $xtable->td(fftgl($r['tglmulai']) . (fftgl($r['tglselesai']) != '-' ? '<br/>s/d ' . fftgl($r['tglselesai']) : ''), 180, 'c'); $xtable->td(fRp($r['biaya']), 120, 'r'); $xtable->td($n, 100, 'c'); $xtable->td($n1, 100, 'c'); $xtable->td(nl2br($r['keterangan'])); $xtable->opt_ud($r['replid']); $xtable->row_end(); } $xtable->foot(); } else { $xtable->nodata(); } } else { departemen_warn(1); }
$aktiva = 0; $pasiva = 0; // Aktiva echo '<tr height="20px">', '<td style="font-size:11px" ><b>Aktiva :</b></td>', '<td></td>', '<td></td>', '</tr>'; foreach ($rekaktiva as $rek => $r) { echo '<tr height="20px">', '<td style="font-size:11px" >' . $rekaktiva[$rek]['nama'] . '</td>', '<td style="font-size:11px" width="120px" align="right">' . fRp($rekaktiva[$rek]['nominal'], 1, 1, 1) . '</td>', '<td></td>', '</tr>'; $aktiva += $rekaktiva[$rek]['nominal']; } echo '<tr height="20px" style="background:#eaeaea">', '<td style="font-size:11px" ><i>Total Aktiva:</i></b></td>', '<td></td>', '<td style="font-size:11px" width="120px" align="right"><b>' . fRp($aktiva, 1, 1, 1) . '</b></td>', '</tr>'; echo '<tr height="10px">', '<td></td>', '<td></td>', '<td></td>', '</tr>'; // pasiva echo '<tr height="20px">', '<td style="font-size:11px" ><b>Pasiva :</b></td>', '<td></td>', '<td></td>', '</tr>'; foreach ($rekpasiva as $rek => $r) { echo '<tr height="20px">', '<td style="font-size:11px" >' . $rekpasiva[$rek]['nama'] . '</td>', '<td style="font-size:11px" width="120px" align="right">' . fRp($rekpasiva[$rek]['nominal'], 1, 1, 1) . '</td>', '<td></td>', '</tr>'; $pasiva += $rekpasiva[$rek]['nominal']; } echo '<tr height="20px">', '<td style="font-size:11px" >Laba bersih</td>', '<td style="font-size:11px" width="120px" align="right">' . fRp($lababersih, 1, 1, 1) . '</td>', '<td></td>', '</tr>'; $pasiva += $lababersih; echo '<tr height="20px" style="background:#eaeaea">', '<td style="font-size:11px" ><i>Total pasiva:</i></b></td>', '<td></td>', '<td style="font-size:11px" width="120px" align="right"><b>' . fRp($pasiva, 1, 1, 1) . '</b></td>', '</tr>'; echo '</table>'; } else { $xtable->nodata_cust('Tidak ada data transaksi.'); } } else { $xtable = new xtable($fmod); $xtable->nodata_cust('Tidak ada data transaksi.'); } } else { $xtable = new xtable($fmod); $xtable->nodata_cust('Silahkan pilih laporan transaksi.'); }
$xtable->td(fRp($kredit, 0), 100, 'r', $s); $xtable->row_end(); $saldo = $saldo_awal + $debet - $kredit; //$saldo=$saldo<0?-$saldo:$saldo; $xtable->row_begin(); $s = ''; $xtable->td('', '', '', $s); $xtable->td('', '', '', $s); $xtable->td('', '', '', $s); $xtable->td('', '', '', $s); $xtable->td('SALDO AWAL', '', '', $s); $xtable->td(fRp($saldo_awal, 0), 100, 'r', $s); $xtable->td('', 100, 'r', $s); $xtable->row_end(); $xtable->row_begin(); $s = ''; $xtable->td('', '', '', $s); $xtable->td('', '', '', $s); $xtable->td('', '', '', $s); $xtable->td('', '', '', $s); $xtable->td('SALDO AKHIR', '', '', $s); if ($saldo < 0) { $xtable->td('<span style="color:#ff0000">(' . fRp(-$saldo, 0) . ')</span>', 100, 'r', $s); } else { $xtable->td(fRp($saldo, 0), 100, 'r', $s); } $xtable->td('', 100, 'r', $s); $xtable->row_end(); $xtable->foot(); } echo '</div>';
$beban = 0; // Pendapatan echo '<tr height="20px">', '<td style="font-size:11px" ><b>Pendapatan :</b></td>', '<td></td>', '<td></td>', '</tr>'; foreach ($rekpendapatan as $rek => $r) { echo '<tr height="20px">', '<td style="font-size:11px" >' . $rekpendapatan[$rek]['nama'] . '</td>', '<td style="font-size:11px" width="120px" align="right">' . fRp($rekpendapatan[$rek]['nominal'], 1, 1, 1) . '</td>', '<td></td>', '</tr>'; $pendapatan += $rekpendapatan[$rek]['nominal']; } echo '<tr height="20px" style="background:#eaeaea">', '<td style="font-size:11px" ><i>Total Pendapatan:</i></b></td>', '<td></td>', '<td style="font-size:11px" width="120px" align="right">' . fRp($pendapatan, 1, 1, 1) . '</td>', '</tr>'; echo '<tr height="10px">', '<td></td>', '<td></td>', '<td></td>', '</tr>'; // Beban echo '<tr height="20px">', '<td style="font-size:11px" ><b>Beban :</b></td>', '<td></td>', '<td></td>', '</tr>'; foreach ($rekbeban as $rek => $r) { echo '<tr height="20px">', '<td style="font-size:11px" >' . $rekbeban[$rek]['nama'] . '</td>', '<td style="font-size:11px" width="120px" align="right">' . fRp($rekbeban[$rek]['nominal'], 1, 1, 1) . '</td>', '<td></td>', '</tr>'; $beban += $rekbeban[$rek]['nominal']; } echo '<tr height="20px" style="background:#eaeaea">', '<td style="font-size:11px" ><i>Total Beban:</i></b></td>', '<td></td>', '<td style="font-size:11px" width="120px" align="right">' . fRp($beban, 1, 1, 1) . '</td>', '</tr>'; echo '<tr height="10px">', '<td></td>', '<td></td>', '<td><div style="margin-top:4px;padding-top:4px;margin-left:10px;width:110px;border-top:1px solid #666"></div></td>', '</tr>'; $lababersih = $pendapatan - $beban; echo '<tr height="20px" style="background:#eaeaea">', '<td style="font-size:11px" ><i><b>Laba Bersih:</b></i></td>', '<td></td>', '<td style="font-size:11px" width="120px" align="right"><b>' . fRp($lababersih, 1, 1, 1) . '</b></td>', '</tr>'; echo '</table>'; } else { $xtable->nodata_cust('Tidak ada data transaksi.'); } } else { $xtable = new xtable($fmod); $xtable->nodata_cust('Tidak ada data transaksi.'); } } else { $xtable = new xtable($fmod); $xtable->nodata_cust('Silahkan pilih laporan transaksi.'); }
// $xtable->row_begin(); $xtable->row_begin($r['replid']); $t2 = dbQSql("SELECT * FROM keu_pembayaran WHERE modul='{$modid}' AND siswa='" . $r['replid'] . "'"); $r2 = dbFA($t2); $dibayar = 0; $t3 = dbQSql("SELECT * FROM keu_transaksi WHERE pembayaran='" . $r2['replid'] . "'"); while ($r3 = dbFA($t3)) { $dibayar += $r3['nominal']; // print_r($r3);exit(); } if ($fid == 0) { $fid = $r['replid']; } $xtable->td($r['nis'], 40); $xtable->td($r['nama']); $xtable->td(fRp($r2['nominal'] - $dibayar), 80, 'r'); if (admin_isoperator()) { $s = '<button class="btn" title="Proses" onclick="E(\'siswa\').value=' . $r['replid'] . ';pembayaran_proses_get()"><div class="bi_arrow2b"> </div></button>~36px'; } else { $s = '<div style="height:23px;width:36px"></div>'; } $xtable->opt($r['replid'], $s); $xtable->row_end(); } $xtable->foot(); } else { $xtable->nodata_cust('Tidak ada data siswa.'); } $xform->table_end(0); hiddenval('siswa_list_num', $xtable->ndata); hiddenval('siswa_list_firstid', $fid);
?> </td></tr> <tr height="24px"><td width="100px">Total aset:</td><td><?php echo fRp(grup_aset($grup)); ?> </td></tr> </table> </div> <?php if ($xtable->ndata > 0) { // Table head $xtable->head('@kode', '@nama barang', 'jenis', 'Jumlah unit~R', 'Aset~R', 'penyusutan<br/>per tahun~R', 'keterangan', '{40px}'); while ($r = mysql_fetch_array($t)) { $xtable->row_begin(); $n = mysql_num_rows(mysql_query("SELECT replid FROM sar_barang WHERE katalog='" . $r['replid'] . "'")); $xtable->td($r['kode'], 80); $xtable->td($r['nama'], 200); $xtable->td(jenis_name($r['jenis']), 200); $xtable->td($n, 80, 'r'); $xtable->td(fRp(katalog_aset($r['replid'])), 100, 'r'); $xtable->td($r['susut'] . ' %', 120, 'r'); $xtable->td(nl2br($r['keterangan'])); $xtable->opt($r['replid'], 'v'); //'<button class="btn" title="Tambah unit barang baru." onclick="katalog_unit_add(\'<id>\')"><div class="bi_add">Unit</div></button>~50'); $xtable->row_end(); } $xtable->foot(); } else { $xtable->nodata(); } }
from keu_jurnal kj, keu_rekening kr where kj.rek=kr.replid and kj.transaksi=' . $res['replid'] . ' order by kj.kredit asc'; $exe2 = mysql_query($sql2); $out .= '<table class="isi" >'; while ($res2 = mysql_fetch_assoc($exe2)) { $out .= '<tr> <td width="200px">' . $res2['nama'] . '</td> <td width="60px">' . $res2['kode'] . '</td> <td width="80px">' . fRp($res2['debet']) . '</td> <td width="80px">' . fRp($res2['kredit']) . '</td> </tr>'; } $out .= '</table>'; // end of detil jurnal -------- $out .= '</td>'; $out .= '</tr>'; $nox++; } } $out .= '</table><br>'; echo $out; #generate html -> PDF ------------ $out2 = ob_get_contents(); ob_end_clean(); $mpdf = new mPDF('c', 'A4', '');
} ?> <input type="hidden" id="<?php echo 'tbiaya' . $r['replid'] . '_' . $h['replid']; ?> " value="<?php echo $biaya; ?> " /> </td> <td width="150px" align="right"> <?php if (admin_isoperator()) { echo iTextC('spp' . $r['replid'] . '_' . $h['replid'], $spp, 'float:right;width:150px;text-align:right'); } else { echo fRp($spp); } ?> <input type="hidden" id="<?php echo 'tspp' . $r['replid'] . '_' . $h['replid']; ?> " value="<?php echo $spp; ?> " /> </td> </tr> <?php $tfield .= '~biaya' . $r['replid'] . '_' . $h['replid']; $tfield2 .= '~spp' . $r['replid'] . '_' . $h['replid']; $tfield3 .= '~daftar' . $r['replid'] . '_' . $h['replid'];
$xtable->td('<b>' . fRp($debet, 0) . '</b>', 100, 'r', $s); $xtable->td('<b>' . fRp($kredit, 0) . '</b>', 100, 'r', $s); $xtable->row_end(); $saldo = $debet - $kredit; $saldo = $saldo < 0 ? -$saldo : $saldo; $xtable->row_begin(); $xtable->td(); $xtable->td(); $xtable->td(); $xtable->td(); if ($debet >= $kredit) { $xtable->td('<b>' . fRp($saldo, 0) . '</b>', 100, 'r'); $xtable->td(); } else { $xtable->td(); $xtable->td('<b>' . fRp($saldo, 0) . '</b>', 100, 'r'); } $xtable->row_end(); $xtable->foot(); } echo '</div>'; } } else { $xtable = new xtable($fmod); $xtable->btnbar_begin(); echo '<div style="visibility:hidden">'; $xtable->search_box(); echo '</div>'; $xtable->btnbar_end(); $xtable->nodata_cust('Tidak data transaksi.'); }
<?php require_once MODDIR . 'xform/xform.php'; require_once MODDIR . 'control.php'; appmod_use('aka/tahunajaran', 'aka/tingkat', 'aka/kelas', 'aka/siswa'); $modul = gpost('modul'); $reftipe = gpost('reftipe'); $refid = gpost('refid'); $siswaid = gpost('siswa', 0); $pemb = pembayaran_getdatabysubj($modul, $siswaid); hiddenval('pembayaran', $pemb['replid']); $db = siswa_db_byID($siswa); $t = $db->query(); $siswa = mysql_fetch_array($t); $fmod = 'pembayaran_data'; $xform = new xform($fmod); $xform->table_begin(); $xform->col_begin(); $s = '<button title="Edit data pembayaran" onclick="pembayaran_data_form(\'uf\',' . $pemb['replid'] . ')" style="float:left;margin-left:100px" class="btn"><div class="bi_edit">Edit</div></button>'; $xform->group_begin('Pembayaran yang harus dilunasi ', 100, 150); echo '<div class="xrowl"><div class="xlabel" style="width:100px">Pembayaran:</div><div class="xlabel" style="position:relative;height:20px;width:px">' . $pemb['modul']['nama'] . '<div style="position:absolute;top:-32px;right:-80px">' . $s . '</div></div></div>'; $xform->fl('Jml pembayaran', fRp($pemb['nominal'])); $xform->fl('Besar cicilan', fRp($pemb['cicilan'])); $xform->fl('Status', $pemb['lunas'] == 1 ? '<span style="color:#00a000"><b>Lunas</b></span>' : '<span style="color:#ff8000"><b>Belum lunas</b></span>'); if ($pemb['keterangan'] != '') { echo '<div class="xrowl" style="margin-top:4px"><div class="infobox" style="float:left;width:100%">Perubahan terakhir pada ' . fftgl($pemb['tanggal']) . '. Keterangan: <i style="float:none !important">' . $pemb['keterangan'] . '.</i></div></div>'; } $xform->table_end(0);
<?php $fmod = 'discount'; $xtable = new xtable($fmod); $xtable->btnbar_f('add'); // Query $t = mysql_query("SELECT * FROM psb_disctunai ORDER BY nilai"); $xtable->ndata = mysql_num_rows($t); if ($xtable->ndata > 0) { // Table head $xtable->head('Diskon (%)~C', 'Diskon (Tunai)~C', 'Keterangan~C'); while ($r = mysql_fetch_array($t)) { $xtable->row_begin(); $xtable->td($r['nilai'], 100, 'c'); $xtable->td(fRp($r['nilai2']), 100); // $xtable->td($r['nilai2']); $xtable->td($r['keterangan']); $xtable->opt_ud($r['replid']); $xtable->row_end(); } $xtable->foot(); } else { $xtable->nodata(); }
$xtable->row_begin(); $xtable->td('<i>Tidak ada data.</i>', 80, '', 'colspan="4"'); $xtable->row_end(); } $xtable->row_begin(); $s = 'style="border-top:2px solid #88d9ff"'; $xtable->td('Jumlah Pengeluaran</b>', '', '', $s); $xtable->td('', '', '', $s); $xtable->td('', '', '', $s); $xtable->td('' . ($kredit > 0 ? fRp($kredit, 0) : 0) . '', 100, 'r', $s); $xtable->row_end(); $xtable->foot(); $saldo_awal = $saldo_awal + $debet - $kredit; echo '<div class="sfont" style="background:#f0f0f0;font-size:13px;float:left;width:800px;text-align:left;margin-bottom:10px">'; //echo '<div style="float:left">['.$jd['koderek'].'] '.$jd['nrek'].'</div>'; echo '<div style="float:right;margin:2px;">Saldo Akhir: ' . ($saldo_awal > 0 ? fRp($saldo_awal) : 'Rp 0') . '</div>'; echo '</div>'; echo '</div>'; } } else { $xtable = new xtable($fmod); $xtable->btnbar_begin(); echo '<div style="visibility:hidden">'; $xtable->search_box(); echo '</div>'; $xtable->btnbar_end(); $xtable->nodata_cust('Tidak data transaksi.'); } } else { $xtable = new xtable($fmod); $xtable->nodata_cust('Silahkan pilih laporan transaksi.');
$fmod = 'tahunbuku'; $xtable = new xtable($fmod, 'tahun buku'); $xtable->btnbar_f('add'); // Query data $sql = "SELECT * FROM keu_tahunbuku"; $t = mysql_query($sql); $xtable->ndata = mysql_num_rows($t); if ($xtable->ndata > 0) { // Table head $xtable->head('Nama Tahun Buku', 'tanggal mulai', 'Saldo awal{R}', 'Keterangan', 'Status{C}'); while ($r = mysql_fetch_array($t)) { $xtable->row_begin(); $xtable->td($r['nama'], 200); //$xtable->td($r['kode'],140); $xtable->td(fftgl($r['tanggal1']), 120); $xtable->td(fRp($r['saldoawal']), 140, 'r'); $xtable->td(nl2br($r['keterangan'])); if ($r['aktif'] == '1') { //$s='<button class="btns" title="Klik untuk me-non aktifkan." style="width:85px" onclick="tahunbuku_status_form(\'uf\','.$r['replid'].')">Aktif</button>'; $s = '<div style="padding:2px;border-radius:2px;background:#00d000;color:#fff;width:83px;margin:auto"><b>Aktif</b></div>'; } else { $s = '<button class="btn" title="Klik untuk mengaktifkan." style="width:85px" onclick="tahunbuku_status_form(\'uf\',' . $r['replid'] . ')">Tidak Aktif</button>'; } $xtable->td($s, 100, 'c'); $xtable->opt_ud($r['replid']); $xtable->row_end(); } $xtable->foot(); } else { $xtable->nodata(); }
$debet = 0; $kredit = 0; foreach ($saldo_rek as $rek => $r) { $xtable->row_begin(); $xtable->td($r['kode'], 70, 'c'); $xtable->td($r['nama']); $xtable->td(fRp($r['debet'], 0), 100, 'r'); $xtable->td(fRp($r['kredit'], 0), 100, 'r'); $debet += $r['debet']; $kredit += $r['kredit']; $xtable->row_end(); } $xtable->row_begin(); $s = 'style="border-top:2px solid #88d9ff"'; $xtable->td('<b>Jumlah</b>', '', 'c', $s); $xtable->td('', '', '', $s); $xtable->td('<b>' . fRp($debet, 0) . '</b>', 100, 'r', $s); $xtable->td('<b>' . fRp($kredit, 0) . '</b>', 100, 'r', $s); $xtable->row_end(); $xtable->foot(); } else { $xtable->nodata_cust('Tidak ada data transaksi.'); } } else { $xtable = new xtable($fmod); $xtable->nodata_cust('Tidak ada data transaksi.'); } } else { $xtable = new xtable($fmod); $xtable->nodata_cust('Silahkan pilih laporan transaksi.'); }
$pdf->MultiCell($twx[$i], 0, $r['disctunai'] . ' %', 0, 'R', 0, 0, '', '', true); if ($pdf->getLastH() > $my) { $my = $pdf->getLastH(); } $i++; $pdf->MultiCell($twx[$i], 0, fRp($r['denda']), 0, 'R', 0, 0, '', '', true); if ($pdf->getLastH() > $my) { $my = $pdf->getLastH(); } $i++; $pdf->MultiCell($twx[$i], 0, fRp($r['sumnet']), 0, 'R', 0, 0, '', '', true); if ($pdf->getLastH() > $my) { $my = $pdf->getLastH(); } $i++; $pdf->MultiCell($twx[$i], 0, fRp($r['angsuran']) . $lnbr . 'x ' . $r['jmlangsur'] . ' bulan', 0, 'R', 0, 0, '', '', true); if ($pdf->getLastH() > $my) { $my = $pdf->getLastH(); } $i++; $pdf->MultiCell($twx[$i], 0, $r['ujian1'], 0, $tax[$i++], 0, 0, '', '', true); if ($pdf->getLastH() > $my) { $my = $pdf->getLastH(); } $pdf->MultiCell($twx[$i], 0, $r['ujian2'], 0, $tax[$i++], 0, 0, '', '', true); if ($pdf->getLastH() > $my) { $my = $pdf->getLastH(); } $pdf->MultiCell($twx[$i], 0, $r['ujian3'], 0, $tax[$i++], 0, 0, '', '', true); if ($pdf->getLastH() > $my) { $my = $pdf->getLastH();
// Table head $xtable->head('Nama Anggarang', 'Anggaran', 'Status anggaran', 'Keterangan'); while ($r = mysql_fetch_array($t)) { $xtable->row_begin(); $xtable->td($r['nama'], 200); $xtable->td(fRp($r['nominal']), 110); $uses = budget_getuses($r['replid']); $sisa = $r['nominal'] - $uses; $clr = color_level($r['nominal'], $sisa < 0 ? $r['nominal'] : $uses); $bar = $sisa < 0 ? 480 : intval($uses * 480 / $r['nominal']); $s = '<div class="sfont" style="width:480px;height:20px;padding:1px;text-align:left"><span style="float:left">Total anggaran: <b>' . fRp($r['nominal']) . '</b></span></div>'; $s .= '<div style="width:480px;height:6px;border:1px solid #01a8f7;border-radius:3px">'; $s .= '<div style="width:' . $bar . 'px;height:6px;background:' . $clr . '"></div>'; $s .= '</div>'; $s .= '<div class="sfont" style="width:480px;height:18px;padding:1px;padding-top:6px;text-align:left' . ($sisa < 0 ? ';color:#ff0000' : '') . '">'; $s .= '<span style="float:left">terpakai: <b>' . fRp($uses) . '</b> ( ' . number_format($uses * 100 / $r['nominal'], 2) . '% )</span>'; $s .= '<span style="float:right">sisa anggaran: <b>' . fRp($sisa, 1, 1) . '</b> ( ' . number_format($sisa * 100 / $r['nominal'], 2) . '% )</span>'; $s .= '</div>'; $xtable->td($s, 484, 'r'); $xtable->td(nl2br($r['keterangan'])); $s = '<button title="Daftar transaksi" class="btn"><div class="bi_lisb"> </div></button>'; $xtable->opt($r['replid'], 'u', 'd'); $xtable->row_end(); } $xtable->foot(); } else { $xtable->nodata(); } } else { echo '<div class="infobox">Tidak ada tahun buku yang aktif.</div>'; }
// Laba/Rugi // $laba=$labarugi_kredit-$labarugi_debet; if ($laba < 0) { $xtable->td(); $xtable->td('<b>' . fRp($labarugi_debet - $laba, 0) . '</b>', 100, 'r'); } else { $xtable->td('<b>' . fRp($labarugi_debet + $laba, 0) . '</b>', 100, 'r'); $xtable->td(); } // Neraca // $selisih=$neraca_debet-$neraca_kredit; if ($selisih < 0) { $xtable->td('<b>' . fRp($neraca_kredit - $selisih, 0) . '</b>', 100, 'r'); $xtable->td(); } else { $xtable->td(); $xtable->td('<b>' . fRp($neraca_kredit + $selisih, 0) . '</b>', 100, 'r'); } $xtable->row_end(); $xtable->foot(); } else { $xtable->nodata_cust('Tidak ada data transaksi.'); } } else { $xtable = new xtable($fmod); $xtable->nodata_cust('Tidak ada data transaksi.'); } } else { $xtable = new xtable($fmod); $xtable->nodata_cust('Silahkan pilih laporan transaksi.'); }
px;margin-right:4px;margin-top:10px;margin-bottom:4px"> <?php $t1 = mysql_query("SELECT * FROM psb_kelompok WHERE proses='{$pros}'"); $k = 0; while ($r1 = mysql_fetch_array($t1)) { $n = mysql_num_rows(mysql_query("SELECT * FROM psb_calonsiswa WHERE kelompok='" . $r1['replid'] . "' AND status<>0")); $w = intval($n * $barw / $kapasitas); echo '<div style="float:left;background:' . $bcolor[$k++] . ';height:4px;width:' . $w . 'px"></div>'; } ?> </div> <?php //$t=dbQSql($token); $no = 1; $doc->head('No{C}', '@Kelompok', '@Tanggal Pendaftaran', '@Biaya Pendaftaran', '@calon Siswa', '@Siswa diterima', 'Keterangan'); while ($r = dbFA($query)) { $q = mysql_query("SELECT replid FROM psb_calonsiswa WHERE kelompok='" . $r['replid'] . "'"); $n1 = mysql_num_rows($q); $q = mysql_query("SELECT replid FROM psb_calonsiswa WHERE kelompok='" . $r['replid'] . "' AND status<>0"); $n2 = mysql_num_rows($q); $doc->nl(); $doc->cell($no++, 20, 'c'); $doc->cell($r['kelompok'], 80); $doc->cell(fftgl($r['tglmulai']) . (fftgl($r['tglselesai']) != '-' ? '<br/>s/d ' . fftgl($r['tglselesai']) : ''), 50); $doc->cell(fRp($r['biaya']), 50); //$doc->cell($r['biaya'],50); $doc->cell($n1, 50); $doc->cell($n2, 50); } $doc->cell($r['keterangan'], 50); $doc->end();
$dept = gpost('departemen'); $departemen = departemen_r($dept); $pros = gpost('proses'); $proses = proses_r($pros, $dept); $kel = gpost('kelompok'); $kelompok = kelompok_r($kel, $pros); $cid = gets('token'); $query = mysql_query("SELECT * FROM psb_calonsiswa WHERE replid='{$cid}' LIMIT 0,1"); //$query = mysql_query("SELECT * FROM psb_calonsiswa WHERE proses='$pros' AND kelompok='$kel' ORDER BY nopendaftaran"); $token = doc_decrypt($token); $doc = new doc(); $doc->dochead('Pendataan Calon Siswa', 100); //$doc->nl(); //$doc->row_blank(5); //$t=dbQSql($token); $no = 1; $doc->head('@Nomor Pendaftaran{2}', '@Nama{2}', '@Uang Pangkal{R,2}', 'Discount{C,1,3}', 'Denda{R,2}', 'Uang pangkal net{R,2,90px}', 'Angsuran{R}'); $doc->head('Subsidi{R}', 'Saudara{R}', 'Tunai{R}', '!x bulan{R}'); while ($r = dbFA($query)) { $doc->nl(); //$doc->cell($no++,20,'c'); $doc->cell($r['nopendaftaran'], 90, 'r'); $doc->cell($r['nama']); $doc->cell(fRp($r['sumpokok']), 90, 'r'); $doc->cell(fRp($r['disctb']), 90, 'r'); $doc->cell(fRp($r['discsaudara']), 90, 'r'); $doc->cell(fRp($r['disctunai']), 90, 'r'); $doc->cell(fRp($r['denda']), 90, 'r'); $doc->cell(fRp($r['angsuran']) . '<br/>x ' . $r['jmlangsur'] . ' bulan', 90, 'r'); } $doc->end();
} } } } } } } $xtable->td(fhtgl($r['tanggal']), 80); $xtable->td('<b><span style="color:' . $cl . '">' . $r['nomer'] . '<br/><span style="color:#444">' . jt_jenisbukti($r['jenis']) . '</span>' . ($r['nobukti'] == '' ? '' : '<br/><span style="color:#444">' . $r['nobukti'] . '</span>') . '</span></b>', 120); $xtable->td(nl2br($r['uraian']), $ct_jurnaldetil == 1 ? 300 : '', '', 'id="xtd_urai' . $row . '"'); $xtable->td(fRp($r['nominal']), 100, 'r', 'id="xtd_nom' . $row . '" style="display:' . ($ct_jurnaldetil == 1 ? 'none' : '') . '"'); $t1 = mysql_query("SELECT keu_jurnal.debet,keu_jurnal.kredit,keu_rekening.kode as koderek,keu_rekening.nama as nrek FROM keu_jurnal LEFT JOIN keu_rekening ON keu_rekening.replid=keu_jurnal.rek WHERE keu_jurnal.transaksi='" . $r['replid'] . "' ORDER BY keu_jurnal.replid"); if (mysql_num_rows($t1) > 0) { $s = '<div style="background:#fff"><table class="xtable_norm" cellspacing="0" cellpadding="4px" width="100%">'; while ($r1 = mysql_fetch_array($t1)) { $s .= '<tr><td>' . $r1['nrek'] . '</td><td width="40px" align="center">' . $r1['koderek'] . '</td><td width="100px" align="right">' . fRp($r1['debet']) . '</td><td width="100px" align="right">' . fRp($r1['kredit']) . '</td></tr>'; } $s .= '</table></div>'; } else { $s = ''; } $xtable->td($s, '', '', 'id="xtd_jd' . $row . '" style="display:' . ($ct_jurnaldetil == 1 ? '' : 'none') . '"'); $s = '<button class="btn" title="Cetak bukti transaksi" onclick="transaksi_print(\'' . $r['nomer'] . '\')"><div class="bi_prib"> </div></button>'; $xtable->opt($r['replid'], 'u', 'd'); $row++; } $xtable->foot(); hiddenval('xtd_jd_num', $row); echo '<form id="pageprinter" style="display:none" target="_blank" action="' . RLNK . 'print2.php?doc=jurnalumum&docname=Jurnal Umum&doprint=0" method="post"><input name="pagesql" type="hidden" value="' . $db->getsql() . '" /></form>'; } else { $xtable->nodata_cust('Tidak ada data transaksi.');
exit; } $PSBar->end(); // Query $db = new xdb("sar_grup", "", "lokasi='{$lok}'"); $t = $xtable->use_db($db, $xtable->pageorder_sql('kode', 'nama')); $xtable->btnbar_begin(); $xtable->btnbar_add(); echo '<div class="sfont" style="float:right;margin-top:4px">Total aset: ' . fRp(lokasi_aset($lok)) . '</div>'; $xtable->btnbar_end(); if ($xtable->ndata > 0) { // Table head $xtable->head('@kode', '@nama Grup barang', 'Jumlah unit~C', 'Unit tersedia~C', 'Unit dipinjam~C', 'Total aset~R', 'Keterangan'); $nom = 1; while ($r = mysql_fetch_array($t)) { $xtable->row_begin($r['replid']); $n = mysql_num_rows(mysql_query("SELECT replid FROM sar_barang WHERE grup='" . $r['replid'] . "'")); $xtable->td($r['kode'], 100); $xtable->td($r['nama'], 200); $xtable->td($n, 100, 'c'); $xtable->td(0, 100, 'c'); $xtable->td(0, 100, 'c'); $xtable->td(fRp(grup_aset($r['replid'])), 120, 'r'); $xtable->td(nl2br($r['keterangan'])); $xtable->opt($r['replid'], 'v', 'u', 'd'); $xtable->row_end(); } $xtable->foot(); } else { $xtable->nodata(); }
$pdf->MultiCell(100, 0, ': ' . fftgl($transaksi['tanggal']), 0, 'L', 0, 1, '', '', true); $pdf->MultiCell(30, 0, 'Diterima dari', 0, 'L', 0, 0, '', '', true); $pdf->MultiCell(100, 0, ': ', 0, 'L', 0, 1, '', '', true); dc_YDown(2); // Cell($w, $h=0, $txt='', $border=0, $ln=0, $align='', $fill=0, $link='', $stretch=0, $ignore_min_height=false, $calign='T', $valign='M') $pdf->setCellPaddings(1, 1, 1, 1); $pdf->Cell(20, 0, 'Perkiraan', 1, 0, 'C'); $pdf->Cell(100, 0, 'Uraian', 1, 0, 'C'); $pdf->Cell(30, 0, 'Jumlah', 1, 1, 'C'); $t = mysql_query("SELECT * FROM keu_transaksi WHERE keu_transaksi.ct='" . $transaksi['ct'] . "'"); $total = 0; while ($r = mysql_fetch_array($t)) { $t1 = mysql_query("SELECT keu_jurnal.rek,keu_jurnal.debet,keu_jurnal.kredit,keu_rekening.kode as koderek,keu_rekening.nama as nrek FROM keu_jurnal LEFT JOIN keu_rekening ON keu_rekening.replid=keu_jurnal.rek WHERE keu_jurnal.transaksi='" . $r['replid'] . "' ORDER BY keu_jurnal.replid"); while ($r1 = mysql_fetch_array($t1)) { if ($r1['rek'] != 1) { $pdf->Cell(20, 0, $r1['koderek'], 1, 0, 'C'); $pdf->Cell(100, 0, $r['uraian'], 1, 0, 'L'); $pdf->Cell(30, 0, fRp($r['nominal']), 1, 1, 'R'); $total += $r['nominal']; } } } $pdf->Cell(20, 0, '', 1, 0, 'C'); $pdf->Cell(100, 0, 'Jumlah', 1, 0, 'R'); $pdf->Cell(30, 0, fRp($total), 1, 1, 'R'); $pdf->lastPage(); // --------------------------------------------------------- $pdf->Output('SIADU - Bukti Transaksi.pdf', 'I'); } else { echo "okoko Dokumen tidak tersedia!"; }
</td> <td align=""> <table class="stable" cellspacing="0" cellpadding="0"> <tr height="24px"><td colspan="2"><b>Kondisi Barang:</b></td></tr> <tr><td><div id="placeholder" style="background:#fff;width:300px;height:120px"></div></td></tr> </table> </td> </tr></table> </div> <?php if ($xtable->ndata > 0) { // Table head $xtable->head('@kode', '@barkode', 'sumber', 'harga~R', '@kondisi', 'status', 'keterangan'); $nom = 1; while ($r = mysql_fetch_array($t)) { $xtable->row_begin(); $xtable->td($r['kode'], 200); $xtable->td($r['barkode'], 100); $xtable->td(sumber_name($r['sumber']), 100); $xtable->td(fRp($r['harga']), 120, 'r'); $xtable->td(kondisi_name($r['kondisi']), 100); $xtable->td($r['status'] == 1 ? 'Tersedia' : 'Dipinjam', 100); $xtable->td(nl2br($r['keterangan'])); $xtable->opt_ud($r['replid']); $xtable->row_end(); } $xtable->foot(); } else { $xtable->nodata(); } }
<td class="cell" align="center" width="300px">Uraian</td> <td class="cell" align="center" width="100px">Nominal</td> </tr> <?php $t = mysql_query("SELECT * FROM keu_transaksi WHERE keu_transaksi.nomer='{$token}'"); $total = 0; while ($r = mysql_fetch_array($t)) { $t1 = mysql_query("SELECT keu_jurnal.rek,keu_jurnal.debet,keu_jurnal.kredit,keu_rekening.kode as koderek,keu_rekening.nama as nrek FROM keu_jurnal LEFT JOIN keu_rekening ON keu_rekening.replid=keu_jurnal.rek WHERE keu_jurnal.transaksi='" . $r['replid'] . "' AND keu_rekening.kategorirek<>'1' AND keu_rekening.kategorirek<>'2' ORDER BY keu_jurnal.replid"); while ($r1 = mysql_fetch_array($t1)) { if ($r1['rek'] != 1) { echo '<tr>'; echo '<td class="cell" width="100px" align="center" x:str>' . $r1['koderek'] . '</td>'; echo '<td class="cell">' . $r['uraian'] . '</td>'; echo '<td class="cell" width="100px" align="right">' . fRp($r['nominal']) . '</td>'; echo '</tr>'; $total += $r['nominal']; } } } echo '<tr>'; echo '<td class="cell" width="100px"></td>'; echo '<td class="cell" align="right">Jumlah</td>'; echo '<td class="cell" width="100px" align="right" x:fmla="=SUM(C8:C9)">' . fRp($total) . '</td>'; echo '</tr>'; ?> </table> <?php } else { doc_nofile(); }
$xtable->td(fhtgl($r['tanggal']), 80); $xtable->td('<b><span style="color:' . $cl . '">' . $r['nomer'] . '<br/> <span style="color:#444">' . jt_jenisbukti($r['jenis']) . '</span> ' . ($r['nobukti'] == '' ? '' : '<br/><span style="color:#444">' . $r['nobukti'] . '</span>') . '</span></b>', 120); $xtable->td(nl2br($r['uraian']), $ct_jurnaldetil == 1 ? 300 : '', '', 'id="xtd_urai' . $row . '"'); $xtable->td(fRp($r['nominal']), 100, 'r', 'id="xtd_nom' . $row . '" style="display:' . ($ct_jurnaldetil == 1 ? 'none' : '') . '"'); $t1 = mysql_query("SELECT keu_jurnal.debet,keu_jurnal.kredit,keu_rekening.kode as koderek,keu_rekening.nama as nrek FROM keu_jurnal LEFT JOIN keu_rekening ON keu_rekening.replid=keu_jurnal.rek WHERE keu_jurnal.transaksi='" . $r['replid'] . "' ORDER BY keu_jurnal.replid"); if (mysql_num_rows($t1) > 0) { $s = '<div style="background:#fff"> <table class="xtable_norm" cellspacing="0" cellpadding="4px" width="100%">'; while ($r1 = mysql_fetch_array($t1)) { $s .= '<tr> <td>' . $r1['nrek'] . '</td> <td width="40px" align="center">' . $r1['koderek'] . '</td> <td width="100px" align="right">' . fRp($r1['debet']) . '</td> <td width="100px" align="right">' . fRp($r1['kredit']) . '</td> </tr>'; } $s .= '</table></div>'; } else { $s = ''; } $xtable->td($s, '', '', 'id="xtd_jd' . $row . '" style="display:' . ($ct_jurnaldetil == 1 ? '' : 'none') . '"'); $s = '<button class="btn" title="Cetak bukti transaksi" onclick="transaksi_print(\'' . $r['nomer'] . '\')"><div class="bi_prib"> </div></button>'; $xtable->opt($r['replid'], 'u', 'd'); $row++; } $xtable->foot(); hiddenval('xtd_jd_num', $row); echo '<form id="pageprinter" style="display:none" target="_blank" action="' . RLNK . 'print2.php?doc=jurnalumum&docname=Jurnal Umum&doprint=0" method="post"><input name="pagesql" type="hidden" value="' . $db->getsql() . '" /></form>'; } else {