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 {
