function page_header() { global $pdf, $dcMarginL, $dcMarginT; $pdf->SetXY(5, 5); $pdf->SetFont('dejavusans', '', 7, '', true); $pdf->MultiCell(0, 0, fftgl(date("Y-m-d")) . " " . date("H:i:s"), 0, 'L', 0, 0, '', '', true); $pdf->SetXY($dcMarginL, $dcMarginT); }
} else { if ($opt == 'af' || $opt == 'uf') { $fform = new fform($fmod, $opt, $cid, 'Data presensi guru'); $fform->reg['btnlabel_a_n'] = 'Batal'; $fform->dimension(600); $fform->ptop = 5; $fform->globalkey = '0'; $fform->reg['title_af'] = 'Edit <idata>'; $fform->head(); //$fform->fl('Departemen',departemen_name(gpost('departemen'))); //$fform->fl('Tingkat',tingkat_name(gpost('tingkat'))); //$fform->fl('Tahun ajaran',tahunajaran_name(gpost('tahunajaran'))); $fform->rheight = ''; if ($opt == 'af') { //$fform->fl('Kelas',kelas_name(gpost('kelas'))); $fform->fl('Tanggal', fftgl(gpost('tanggal'))); } else { $tanggal = gpost('tanggal'); $db = guru_db_byID($cid); $r = $db->gofetch(); $fform->fl('Nama', $r['npegawai']); //$fform->fl('Kelas',$r['nkelas']); $fform->fl('Bulan', ftgl_namabulan(intval(date("m", $tanggal)))); } $fform->rheight = '30px'; echo '<tr><td colspan="2"><div id="box_presensiguru_list">'; require_once APPDIR . 'presensiguru_list_get.php'; echo '</div></td></tr>'; $fform->foot(); } }
<?php $t = mysql_query("SELECT * FROM psb_calonsiswa_saudara WHERE calonsiswa='{$cid}' ORDER BY replid"); while ($saudara = mysql_fetch_array($t)) { ?> <div class="xrowl"><div class="xlbl" style="width:200px">Nama saudara <?php echo $i; ?> </div><div class="xlbl">: <?php echo $saudara['nama']; ?> </div></div> <div class="xrowl"><div class="xlbl" style="width:200px">Tanggal lahir saudara <?php echo $i; ?> </div><div class="xlbl">: <?php echo fftgl($saudara['tgllahir']); ?> </div></div> <div class="xrowl"><div class="xlbl" style="width:200px">Sekolah saudara <?php echo $i; ?> </div><div class="xlbl">: <?php echo $saudara['sekolah']; ?> </div></div> <?php } ?> </div> <div style="float:left;width:100%;margin-bottom:20px"> <div class="xrowl" style="margin-bottom:10px"><div class="xlbl"><b>Dalam Kondisi Mendesak, orang yang dapat dihubungi (selain orang tua):</b></div></div>
echo $ttl; ?> </td> </tr> <tr height="10px"> <td colspan="3"></td> </tr> <tr> <td>No. Transaksi</td><td colspan="2">: <?php echo $trans['nomer']; ?> </td> </tr> <tr> <td>Tanggal</td><td colspan="2">: <?php echo fftgl($trans['tanggal']); ?> </td> </tr> <tr> <td>Diterima dari</td><td colspan="2">: </td> </tr> <tr height="10px"> <td colspan="3"></td> </tr> <tr> <td class="cell" align="center" width="100px">Perkiraan</td> <td class="cell" align="center" width="300px">Uraian</td> <td class="cell" align="center" width="100px">Nominal</td> </tr> <?php
appmod_use('aka/siswa', 'aka/kelas', 'aka/pelajaran', 'aka/rapor'); $opt = gpost('opt'); $cid = gpost('cid', 0); /* Load App libraries */ require_once DBFILE; require_once LIBDIR . 'common.php'; require_once MODDIR . 'date.php'; $dept = gpost('departemen'); $departemen = departemen_r($dept); $proses = proses_r($pros, $dept); // cell($a,$w=0,$c=1,$r=1,$al='',$b=-1,$bg='',$s='',$atr='') $pros = gpost('proses'); $query = mysql_query("SELECT aka_mutasi.tanggal,aka_mutasi.departemen, aka_mutasi.keterangan, aka_siswa.nisn,aka_siswa.nama, aka_jenismutasi.nama as njenis \n\t\t\t\t\t\t\tFROM aka_mutasi\n\t\t\t\t\t\t\tJOIN aka_siswa ON aka_siswa.replid=aka_mutasi.replid\n JOIN aka_jenismutasi ON aka_jenismutasi.replid=aka_mutasi.replid\n WHERE aka_mutasi.departemen='{$dept}'"); $token = doc_decrypt($token); $doc = new doc(); $doc->dochead("Laporan Mutasi Siswa " . gets('kelompok'), 7); $doc->nl(); $doc->row_blank(7); //$t=dbQSql($token); $no = 1; $doc->head('No{C}', '@Tanggal', '@NISN', '@Angkatan', '@Nama', '@Jenis Mutasi', '@Keterangan'); while ($r = mysql_fetch_array($query)) { $doc->nl(); $doc->cell($no++, 20, 'c'); $doc->cell(fftgl($r['tanggal']), 80); $doc->cell($r['nisn'], 30); $doc->cell($r['siswa'], 80); $doc->cell($r['njenis'], 50); $doc->cell($r['keterangan'], 50); } $doc->end();
require_once 'header.php'; $JUDUL = ""; if ($transaksi['jenis'] == JT_INCOME) { $JUDUL = "BUKTI PENERIMAAN KAS"; } if ($transaksi['jenis'] == JT_OUTCOME) { $JUDUL = "BUKTI PENGELUARAN KAS"; } $pdf->SetFont(mydeffont, '', 12, '', true); $pdf->MultiCell(150, 0, $JUDUL, 0, 'C', 0, 1, '', '', true); dc_YDown(5); $pdf->SetFont(mydeffont, '', 8, '', true); $pdf->MultiCell(30, 0, 'No. Transaksi', 0, 'L', 0, 0, '', '', true); $pdf->MultiCell(100, 0, ': ' . $transaksi['nomer'], 0, 'L', 0, 1, '', '', true); $pdf->MultiCell(30, 0, 'Tanggal', 0, 'L', 0, 0, '', '', true); $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');
</td> <?php } else { ?> <td width="100px" <?php echo $cl; ?> ><?php echo fftgl($h['date2']); ?> </td> <td width="100px" <?php echo $cl; ?> ><?php echo fftgl($h['dater']); ?> </td> <td width="80px" <?php echo $cl; ?> ><?php echo $status[$h['status']]; ?> </td> <?php } ?> </tr> <?php $k++;
echo '<div class="infobox">Item yang sudah di cek : <b>'.$ncek_y.'</b> dari <b>'.$ncek.'</b> item.</div>'; } else { echo '<div class="infobox">Semua item sebanyak <b>'.$ncek.'</b> item sudah dicek.</div>'; } $xtable->search_box('cari barkode'); if($xtable->ndata>0){ // Table head $xtable->head('@barkode','@judul','@Cek~C','@Waktu cek'); while($r=mysql_fetch_array($t)){$xtable->row_begin(); $t1=mysql_query("SELECT pus_buku.barkode,pus_katalog.judul FROM pus_buku LEFT JOIN pus_katalog ON pus_katalog.replid=pus_buku.katalog WHERE pus_buku.replid='".$r['buku']."'"); //echo $r1=mysql_fetch_array($t1); $xtable->td($r['barkode'],120); $xtable->td(buku_judul($r['judul'])); $s='<span style="color:'.($r['cek']=='Y'?'':'#ff0000').'"><b>'.$r['cek'].'</b></span>'; $xtable->td($s,40,'c'); $d=explode(" ",$r['ts']); if($r['cek']=='Y') $xtable->td(fftgl($d[0])." - ".$d[1],160); else $xtable->td('-',160); $xtable->row_end();}$xtable->foot(); }else{$xtable->nodata();} echo '</div></td></tr>'; $fform->foot(1,0); ?>
$pdf->MultiCell(100, 0, ': '.$info, 0, 'L', 0, 0, '', '', true); $pdf->Ln(); } function cetak_infohalaman2($label,$info){ global $pdf,$dcPageW; $pdf->MultiCell(30, 0, $label, 0, 'L', 0, 0, $dcPageW-50, '', true); $pdf->MultiCell(100, 0, ': '.$info, 0, 'L', 0, 0, '', '', true); $pdf->Ln(); } // 4. Cetak info halaman: Sesuaikan Page Selection Bar >> Edit $ty=$pdf->GetY(); cetak_infohalaman('Nama stock opname',$data_so['nama']); cetak_infohalaman('Tanggal mulai',fftgl($data_so['tanggal1'])); cetak_infohalaman('Tanggal selesai',fftgl($data_so['tanggal2'])); if($lap_sum==1){ $pdf->SetY($ty); cetak_infohalaman2('Total item',$data_so['nitem'].' item'); cetak_infohalaman2('Item dicek',$data_so['nceky'].' item'); cetak_infohalaman2('Item hilang',($data_so['nitem']-$data_so['nceky']).' item'); } dc_YDown(2); // 5. Header tabel: samakan di $xtable->head() >> Edit $phead=array( array('No.','C',11), array('Barkode','L',32), array('Judul','L',60), array('Callnumber','L',25),
</td> <td> <div class="ptrackbox"> <table cellspacing="0" cellpadding="0"><tr> <td id="ps2a" class="ptracknumber0" align="center">4</td> <td id="ps2b" class="ptracktext0">Generate<br/>report</td> </tr></table> </div> </td> </tr></table> </div> <div class="hl2" style="margin-top:10px;margin-bottom:10px">Stock take informations</div> <form action="soinit.php" method="post"> <table class="stable" cellspacing="0" cellpadding="4px" border="0"> <tr><td width="120px" align="left">Initalization date:</td><td><?php echo fftgl(date("Y-m-d")); ?> <input type="hidden" name="date" id="date" value="<?php echo date("Y-m-d"); ?> "/></td></tr> <tr><td align="left">Stock take name:</td><td><?php echo iText('name', '', $txtWidth); ?> </td></tr> <tr><td align="left" valign="top">Description:</td><td><?php echo iTextArea('description', '', $txtWidth, 4); ?> </td></tr> <tr><td align="left"> </td><td align="right"> <input type="button" class="btn" value="Cancel" onclick="jumpTo('<?php
$PSBar = new PSBar_2(); $PSBar->begin(); $PSBar->selection_departemen($fmod, $dept); if (count($tahunajaran) > 0) { $PSBar->selection('Tahun ajaran', iSelect('tahunajaran', $tahunajaran, $tajar, "width:" . $PSBar->selw, $fmod . "_get()")); } else { $PSBar->end(); hiddenval('tahunajaran', $tajar); tahunajaran_warn(); exit; } $PSBar->end(); $xtable->btnbar_f('add'); if ($xtable->ndata > 0) { // Table head $xtable->head('tanggal', 'Kegiatan'); $nom = 1; while ($r = mysql_fetch_array($t)) { $xtable->row_begin(); $xtable->td(fftgl($r['tanggal1']) . ($r['tanggal2'] != $r['tanggal1'] && $r['tanggal2'] != '0000-00-00' ? ' - ' . fftgl($r['tanggal2']) : ''), 200); $xtable->td(nl2br($r['keterangan'])); $xtable->opt_ud($r['replid']); $xtable->row_end(); } $xtable->foot(); } else { $xtable->nodata(); } } else { departemen_warn(); }
$xtable->docname = "Data Siswa Angkatan " . angkatan_name($angk); $xtable->printparams = array('angkatan' => angkatan_name($angk)); // Query $db = new xdb("aka_siswa"); $db->field("aka_siswa:replid,nis,nisn,nama,tmplahir,tgllahir"); $db->where_and("aka_siswa.angkatan='{$angk}'"); $db->where_and($xtable->search_sql_get()); $t = $xtable->use_db($db, $xtable->pageorder_sql('nis', 'nisn', 'nama')); $xtable->btnbar_f('print', 'srcbox'); if ($xtable->ndata > 0) { // Table head $xtable->head('@!NIS', '@!NISN', '@nama', 'Tempat Tanggal lahir', '{50px}'); while ($r = mysql_fetch_array($t)) { $xtable->row_begin(); $xtable->td($r['nis'], 80); $xtable->td($r['nisn'], 120); $xtable->td($r['nama']); $xtable->td($r['tmplahir'] . ', ' . fftgl($r['tgllahir']), 100); //$s='<button class="btn" title="Keluarkan siswa dari kelas ini." onclick="siswa_form(\'df\',\''.$r['replid'].'\')"><div class="bi_canb"> </div></button>'; $xtable->opt($r['replid'], 'v'); $xtable->row_end(); } $xtable->foot(); } else { $xtable->nodata_cust('Tidak ada data siswa pada angkatan ini.'); } } } } else { departemen_warn(); }
echo '</div>'; $xform->table_end(0); } else { $xform->table_begin(); $sql = "SELECT sar_peminjaman.*,sar_barang.kode,sar_katalog.nama FROM sar_peminjaman LEFT JOIN sar_barang ON sar_barang.replid=sar_peminjaman.barang LEFT JOIN sar_katalog ON sar_katalog.replid=sar_barang.katalog WHERE sar_peminjaman.replid='{$peminjaman}'"; $t = mysql_query($sql); $data = mysql_fetch_array($t); $xform->col_begin('50%'); $xform->group_begin('Informasi Barang', 160); // Grup field $xform->fi('Kode barang', $data['kode']); $xform->fi('Nama barang', $data['nama']); $xform->group_begin('Informasi Peminjam', 160); $xform->fi('Peminjam', $data['peminjam']); $xform->fi('Tempat', $data['tempat']); if ($data['keterangan'] != '') { $xform->group_begin('Catatan Peminjaman', 160); $xform->fi('Keterangan', nl2br($data['keterangan'])); } $xform->col_begin('50%'); $xform->group_begin('Jangka Waktu Peminjaman', 160); $xform->fi('Tanggal Peminjaman', fftgl($data['tanggal1'])); $xform->fi('Tanggal Pengembalian', fftgl($data['tanggal2'])); $xform->group_begin('Catatan Pengembalian', 160); $xform->fi('Keterangan', iTextarea('keterangan', '', 'width:250px', 5)); $xform->table_end(0); echo '<div style="float:left;width:100%;text-align:center;margin-bottom:10px;margin-top:20px">'; echo '<button class="btn" style="margin-right:4px" onclick="' . $xform->back_act . '">Batal</button>'; echo '<button class="btnz" onclick="' . $xform->fmod . '_form(\'' . substr($xform->opt, 0, 1) . '\',' . $xform->cid . ')">Kembalikan</button>'; echo '</div>'; }
$pdf->Ln(); $t = mysql_query("SELECT * FROM psb_calonsiswa_keluarga WHERE calonsiswa='{$cid}'"); $keluarga = mysql_fetch_array($t); group_label('Data Keluarga Siswa'); head_label('Tanggal perkawinan orang tua', fftgl($keluarga['tglnikah'])); head_label('Nama Kakek', $keluarga['kakek-nama']); head_label('Tanggal lahir Kakek', fftgl($keluarga['kakek-tgllahir'])); head_label('Nama Nenek', $keluarga['nenek-nama']); head_label('Tanggal lahir Nenek', fftgl($keluarga['nenek-tgllahir'])); $pdf->Ln(); group_label('Data Saudara Siswa'); for ($i = 1; $i <= 3; $i++) { $t = mysql_query("SELECT * FROM psb_calonsiswa_saudara WHERE calonsiswa='{$cid}' AND ord='{$i}'"); $saudara = mysql_fetch_array($t); head_label('Nama saudara ' . $i, $saudara['nama']); head_label('Tanggal lahir ' . $i, fftgl($saudara['tgllahir'])); head_label('Sekolah saudara ' . $i, $saudara['sekolah']); } $pdf->Ln(); $t = mysql_query("SELECT * FROM psb_calonsiswa_kontakdarurat WHERE calonsiswa='{$cid}'"); $kontakdarurat = mysql_fetch_array($t); group_label('Dalam Kondisi Mendesak, orang yang dapat dihubungi (selain orang tua)'); head_label('Nama', $kontakdarurat['nama']); head_label('Hubungan', $kontakdarurat['hubungan']); head_label('Nomor yang dapat dihubungi', $kontakdarurat['telpon']); $pdf->Ln(); } else { $pdf->SetFont(mydeffont, '', 8, '', true); $pdf->Ln(); $pdf->Ln(); $pdf->Ln();
$xtable->head('@Barkode Item','@Judul Item','@Peminjam','@Tgl peminjaman','@Tgl pengembalian','@Status','Keterangan'); while($r=mysql_fetch_array($t)){$xtable->row_begin(); if($r['mtipe']==1){ $member=$r['nsiswa'].'<br/>NIS: '.$r['nis']; } else if($r['mtipe']==2){ $member=$r['npegawai'].'<br/>NIP: '.$r['nip']; } else { $member="N/a"; } $xtable->td($r['barkode'],120,'','item'); $xtable->td(buku_judul($r['judul']),250,'','item'); $xtable->td($member,200,'','member'); $xtable->td(fftgl($r['tanggal1']),120); $s=fftgl($r['tanggal2']); $telat=""; if($r['status']!=0){ $lewat=diffDay($r['tanggal2']); if($lewat<0 && $r['status']!=0){ $s='<span style="color:red">'.$s.'</span>'; } } else { $telat=diffDay($r['tanggal3'],$r['tanggal2']); if($telat>0)$telat='<br/><span style="color:#ff9000">Terlambat: '.$telat.' hari</span>'; else $telat=""; } $xtable->td($s,120); $xtable->td($r['status']==1?'Dipinjam':'Dikembalikan'.$telat,120);
// Query $sql = "SELECT sar_pengembalian.*,sar_peminjaman.peminjam,sar_peminjaman.tempat,sar_peminjaman.tanggal1,sar_peminjaman.tanggal2,sar_peminjaman.barang,sar_barang.kode,sar_barang.katalog,sar_katalog.nama FROM sar_pengembalian LEFT JOIN sar_peminjaman ON sar_peminjaman.replid=sar_pengembalian.peminjaman LEFT JOIN sar_barang ON sar_barang.replid=sar_peminjaman.barang LEFT JOIN sar_katalog ON sar_katalog.replid=sar_barang.katalog WHERE sar_peminjaman.lokasi='{$lok}'"; //echo $sql; $t = mysql_query($sql); $xtable->ndata = mysql_num_rows($t); $xtable->btnbar_f('add'); $xtable->noopt = true; if ($xtable->ndata > 0) { // Table head $xtable->optw = '50px'; $xtable->head('Peminjam', 'Barang', 'Tanggal Peminjaman', 'Jadwal pengembalian', 'Tanggal dikembalikan', 'Tempat Peminjaman', 'Keterangan'); while ($r = mysql_fetch_array($t)) { $xtable->row_begin(); $xtable->td($r['peminjam'], 120); $xtable->td('Kode: <b>' . $r['kode'] . '</b><br/ >Nama barang: ' . $r['nama'], 250); $xtable->td(fftgl($r['tanggal1']), 140); $xtable->td(fftgl($r['tanggal2']), 140); $xtable->td(fftgl($r['tanggal']), 140); $xtable->td($r['tempat'], 200); $xtable->td(nl2br($r['keterangan'])); //$xtable->opt($r['replid'],'<button class="btn" title="Kembalikan barang ini." onclick="peminjaman_kembalikan(<id>)"><div class="bi_inb"> </div></button>~30'); $xtable->row_end(); } $xtable->foot(); } else { $xtable->nodata(); } } } else { lokasi_warn(); }
if($res['status']!=0){ $lewat=diffDay($res['pengembalian']); if($lewat<0 && $res['status']!=0){ $tgl_pengembalian='<span style="color:red">'.$tgl_pengembalian.'</span>'; } } else { $telat=diffDay($tgl3,$tgl2); // if($telat>0)$telat='<br/><span style="color:#ff9000">Terlambat: '.$telat.' hari</span>'; // else $telat=""; } // //tgl dikembalikan if(isset($res['telat'])>0){ $tgl_dikembalikan='<span style="color:red">'.fftgl($tgl3).'</span>'; } else { $tgl_dikembalikan=fftgl($tgl3); } // if ($res['status']==1) { $btn = '<td> <button data-hint="ubah" class="button" onclick="kembalikan('.isset($res['replid']).');"> <i class="icon-enter on-left"></i> </button> </td>'; // }else{ // $btn ='<td> </td>'; // } $terlambat = isset($res['telat']); $out.= '<tr> <td>'.tgl_indo($res['tgl_pinjam']).'</td> <td>'.$anggota.'</td>
$doc->nl(); $doc->cell('', 0, '', 3); $doc->nl(); $doc->cell('<b>Data Pribadi Siswa:</b>', 0, '', 3); $doc->nl(); $doc->cell('Nama lengkap', $lw); $doc->cell(': ' . $siswa['nama'], 0, '', 2); $doc->nl(); $doc->cell('Jenis kelamin', $lw); $doc->cell(': ' . $siswa['kelamin'], 0, '', 2); $doc->nl(); $doc->cell('Tempat lahir', $lw); $doc->cell(': ' . $siswa['tmplahir'], 0, '', 2); $doc->nl(); $doc->cell('Tanggal lahir', $lw); $doc->cell(': ' . fftgl($siswa['tgllahir']), 0, '', 2); $doc->nl(); $doc->cell('Agama', $lw); $doc->cell(': ' . $siswa['nagama'], 0, '', 2); $doc->nl(); $doc->cell('Alamat rumah', $lw); $doc->cell(': ' . $siswa['alamat'], 0, '', 3); $doc->nl(); $doc->cell('Telepon rumah', $lw); $doc->cell(': ' . $siswa['telpon'], 0, '', 3); $doc->nl(); $doc->cell('', 0, '', 2); $doc->cell('', 80, '', 1); $doc->cell('', 0, '', 1); $doc->nl(); $doc->cell('<b>Kesehatan Siswa:</b>', 0, '', 4);
?> </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); }
width="200px"><?php echo src_replace($r['nip']); ?> </td> <td <?php echo rLink($r['dcid']); ?> width="200px" ><?php echo $mstr_status[$r['status']]; ?> </td> <td <?php echo rLink($r['dcid']); ?> width="250px" ><?php echo fftgl($tglhabis) . " (" . $sisa . " day" . ($sisa > 1 ? "s" : "") . " remaining)"; ?> </td> </tr> <?php } } } $n++; } ?> </table> </div> </div> <?php }
function fftgljam($d){ $c=explode(" ",$d); $a=fftgl($c[0]); return $a.($a=='-'?'':', '.$c[1]); }
// Query $db=new xdb("pus_tpjm"); $db->field('pus_tpjm:replid','pus_peminjaman:tanggal1,tanggal2','pus_buku:barkode,idbuku','pus_katalog:judul'); $db->join('peminjaman','pus_peminjaman'); $db->joinother('pus_peminjaman','buku','pus_buku'); $db->joinother('pus_buku','katalog','pus_katalog','replid'); $db->where("ssid='$ssid'"); $t=$db->query(); $xtable->ndata=mysql_num_rows($t); echo '<div style="float:none !important">'; if($xtable->ndata>0){ // Table head $xtable->head('Barkode','Judul','Tgl pengembalian','Terlambat','{44px}'); while($r=mysql_fetch_array($t)){$xtable->row_begin(); //$xtable->td('<button class="btn" onclick="pengembalian_baliktabelpinjam('.$r['barang'].')" title="Hapus dari daftar barang yang dipinjam."><div class="bi_canb"> </div></button>',30,'c'); $xtable->td($r['barkode'],100); $xtable->td(buku_judul($r['judul'])); $xtable->td(fftgl($r['tanggal2']),110); $telat=diffDay($r['tanggal2']); $xtable->td(($telat<0?(-$telat).' hari':'-'),80); $s='<button class="btn" onclick="'.$fmod.'_form(\'d\','.$r['replid'].')" title="Keluarkan dari daftar"><div class="bi_canb"> </div></button>~40'; $xtable->opt($r['replid'],$s); $xtable->row_end();}$xtable->foot(); }else{ $xtable->nodata_cust('<span style="color:'.CLGREY.'"><i>Belum ada item yang dipilih.</i></span>'); } echo '</div>'; ?>
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 { hiddenval('tampil', 'all'); echo '<div style="float:left;width:100%;margin-bottom:6px"><div class="warnbox" style="margin-right:4px">Belum ada modul pembayaran pendaftaran periode ini. Silahkan menambah modul pembayaran.</div></div><button onclick="modul_form(\'af\')" class="btnz" style="float:left" title="Tambah modul pembayaran."><div class="bi_add2">Modul pembayaran</div></button>'; } hiddenval('kategori', 3); hiddenval('reftipe', RT_PSB); hiddenval('refid', $pros);
$fform->head(); if ($opt == 'af' || $opt == 'uf') { require_once MODDIR . 'control.php'; // Add or Edit form hiddenval('trans_pembayaran', $pid); hiddenval('trans_jenis', $jtrans); hiddenval('trans_nomer', $r['nomer']); hiddenval('trans_ct', $r['ct']); $fform->fl('<b>Nomor</b>', '<b><span id="box_trans_nomer">' . $no['nomer'] . '</span></b>'); $fform->fi('Tanggal', inputTanggal('trans_tanggal', $r['tanggal'], 'transaksi_getnomer()')); $fform->fi('Rek. Kas/Bank', iSelect('rekkas', $rekasbank, $r['rekkas'], $fform->rwidths, 'transaksi_getnomer()')); $fform->fg('pada'); $fform->fi('Rek. perkiraan', iSelect('rekitem', $rekening, $r['rekitem'], $fform->rwidths)); $fform->fa('Uraian', iTextArea('uraian', $r['uraian'], $fform->rwidths, 3)); $fform->fi('Nominal', iTextC('nominal', $r['nominal'], 'width:120px')); } else { if ($opt == 'df') { // Delete form $fform->rheight = ''; $fform->fc('Apakah anda yakin untuk menghapus data transaksi ini?'); $fform->fl('Nomor', '<b>' . $r['nomer'] . '</b>'); $fform->fl('Tanggal', fftgl($r['tanggal'])); $fform->fl('Uraian', $r['uraian']); } } if ($opt == 'af') { $s = '<div style="float:right;margin-right:-20px">' . iCheckx('trans_print', 'Cetak bukti pembayaran', 0, 'float:right') . '</div>'; //$fform->optional_button=$s; } $fform->foot(); }
<?php require_once MODDIR . 'xtable/xtable.php'; $fmod = 'pendataan_saudara'; $xtable = new xtable($fmod); $xtable->row_strip = false; // Query $sql = "SELECT * FROM psb_tmp_saudara WHERE sesid='" . session_id() . "' ORDER BY replid"; $t = mysql_query($sql); $xtable->ndata = mysql_num_rows($t); if ($xtable->ndata > 0) { $xtable->begin(); while ($r = mysql_fetch_array($t)) { $xtable->row_begin(); $s = '<div class="psf12200">Nama: <b>' . $r['nama'] . '</b></div>'; if ($r['tgllahir'] != '0000-00-00') { $s .= '<div class="psf12200">Tanggal lahir: ' . fftgl($r['tgllahir']) . '</div>'; } if ($r['sekolah'] != '') { $s .= '<div class="psf12200">Sekolah: ' . $r['sekolah'] . '</div>'; } $xtable->td($s); $xtable->opt_ud($r['replid']); $xtable->row_end(); } $xtable->foot(); } else { }
if ($r['jenis'] == JT_CALONSISWA) { $cl = '#00c804'; } else { if ($r['jenis'] == JT_OUTCOME) { $cl = '#ff1b1b'; } else { if ($r['jenis'] == JT_UMUM) { $cl = '#008aff'; } else { $cl = ''; } } } } } $xtable->td(fftgl($r['tanggal']) . '<br/><b><span style="color:' . $cl . '">' . $r['nomer'] . '</span></b>', 110); $xtable->td(nl2br($r['uraian']), 250); $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); $xtable->opt_ud($r['replid']); } $xtable->foot();
//echo $db->getsql(); $t = $db->query(); $xtable->ndata = mysql_num_rows($t); //$xtable->btnbar_begin(); // echo '<button class="btn" title="Tambah item" onclick="'.$fmod.'_form(\'af\')"><div class="bi_add">Item</div></button>'; //$xtable->btnbar_end(); echo '<div style="float:none !important">'; if ($xtable->ndata > 0) { // Table head $xtable->head('barkode', 'Callnumber', 'Judul', 'status', 'Dikembalikan Tgl'); while ($r = mysql_fetch_array($t)) { $xtable->row_begin(); //$xtable->td('<button class="btn" onclick="peminjaman_baliktabelpinjam('.$r['barang'].')" title="Hapus dari daftar barang yang dipinjam."><div class="bi_canb"> </div></button>',30,'c'); $xtable->td($r['barkode'], 100); $xtable->td($r['callnumber'], 120); $xtable->td(buku_judul($r['judul'])); $xtable->td($r['status'] == 1 ? 'Belum dikembalikan' : 'Dikembalikan', 120); $xtable->td(fftgl($r['tanggal3']), 120); if ($r['status'] == 1) { $s = '<button class="btn" onclick="pengembalian_buku_form(\'uf\',' . $r['replid'] . ')" title="Kembaliakan item ini."><div class="bi_inb"> </div></button>~30'; } else { $s = ' '; } $xtable->opt($r['replid'], $s); $xtable->row_end(); } $xtable->foot(); } else { $xtable->nodata_cust('<span style="color:' . CLGREY . '"><i>Tidak ada data peminjaman.</i></span>'); } echo '</div>';
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();
<b>Delete day off</b> </div> <div style="text-align:left;padding:10px"> <table class="stable" cellspacing="0" cellpadding="3px" width="<?php $fwidth - 20; ?> px"> <tr><td>Delete <?php echo $fname; ?> 's day off on: <b><?php echo fftgl($r['date1']); ?> <?php if ($r['count'] > 1) { echo "to " . fftgl($r['date1']); } ?> </b> (<span id="htnghari"><?php echo $r['count']; ?> </span> day<?php echo $r['count'] > 1 ? "s" : ""; ?> )?</td></tr> <tr><td><i>Sisa cuti setelah menghapus cuti ini: <span id="htnghari2" style="color:<?php echo $scuti <= 0 ? "#ff0000" : "inherit"; ?> "><?php echo $scuti; ?>
$xtable->ndata = mysql_num_rows($t); // Page Selection Bar $PSBar = new PSBar_2(); $PSBar->begin(); $PSBar->selection_departemen($fmod, $dept); $PSBar->end(); $xtable->btnbar_f('add'); if ($xtable->ndata > 0) { // Table head $xtable->head('Tahun Ajaran', 'Tanggal Mulai', 'Tanggal Akhir', 'Keterangan', 'Status~C'); $nom = 1; while ($r = mysql_fetch_array($t)) { $xtable->row_begin(); $xtable->td($r['tahunajaran'], 200); $xtable->td(fftgl($r['tglmulai']), 120); $xtable->td(fftgl($r['tglakhir']), 120); $xtable->td($r['keterangan']); if ($r['aktif'] == '1') { $s = '<button class="btns" title="Klik untuk me-non aktifkan." style="width:85px" onclick="tahunajaran_status_form(\'uf\',' . $r['replid'] . ')">Aktif</button>'; } else { $s = '<button class="btn" title="Klik untuk mengaktifkan." style="width:85px" onclick="tahunajaran_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(); } } else {