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();
<?php appmod_use('aka/siswa', 'aka/kelas', 'aka/pelajaran', 'aka/rapor'); // cell($a,$w=0,$al='',$c=1,$r=1,$b=-1,$bg='',$s='',$atr='') $token = gets('token'); $db = siswa_db_byID($token, 'nisn,kelamin,tmplahir,tgllahir,alamat,telpon'); $db->field("mst_agama.agama as nagama"); $db->joinother("aka_siswa", "agama", "mst_agama"); $t = $db->query(); $siswa = dbFA($t); $doc = new doc(1); $doc->dochead("DATA SISWA", 4); $doc->nl(); $doc->cell('<b>' . strtoupper($siswa['nama']) . '</b>', 0, '', 4, 1, 'b'); $doc->nl(5); $doc->cell('', 0, '', 3); $lw = 120; $doc->nl(); $doc->cell('Departemen', $lw, ''); $doc->cell(': ' . $siswa['ndepartemen'], 0, '', 2); $img = '<img src="photo/siswa.php?id=' . $siswa['replid'] . '" width="120px" />'; $doc->cell($img, 200, 'r', 1, 10); $doc->nl(); $doc->cell('NIS', $lw, ''); $doc->cell(': ' . $siswa['nis'], 0, '', 2); $doc->nl(); $doc->cell('NISN', $lw, ''); $doc->cell(': ' . $siswa['nisn'], 0, '', 2); $doc->nl(); $doc->cell('', 0, '', 3); $doc->nl();
/* Load App libraries */ require_once DBFILE; require_once LIBDIR . 'common.php'; require_once MODDIR . 'date.php'; $dept = gpost('departemen'); $departemen = departemen_r($dept); $pros = gpost('proses'); $proses = proses_r($pros, $dept); // cell($a,$w=0,$c=1,$r=1,$al='',$b=-1,$bg='',$s='',$atr='') $cid = gets('token'); $query = mysql_query("SELECT * FROM psb_kelompok WHERE proses='{$pros}'"); $token = doc_decrypt($token); $doc = new doc(); $doc->cell_format('border:1,align:c'); $doc->nl(); $doc->cell('<img src="logo.png">', 100, '', 2); $doc->cell('<b>: ' . strtoupper($siswa['nama']) . '</b>', 0, '', 4); /* $doc->dochead("Data Kelompok Pendaftaran ".gets('kelompok'),7); $doc->nl(); */ $doc->row_blank(7); $bcolor = array("#86c2ff", "#ffb129", "#00fa29", "#ffcf0d", "#00eb27", "#89bc02", "#ff8001"); $kapasitas = dbFetch("kapasitas", "psb_proses", "W/replid='{$pros}'"); $nsiswa = dbSRow("psb_calonsiswa", "W/proses='{$pros}' AND status<>0"); $barw = 300; ?> <div style="float:right;margin-left:10px;border:1px solid #01a8f7;height:4px;width:<?php echo $barw; ?>
// cell($a,$w =0,$c=1,$r=1,$al='',$b=-1,$bg='',$s='',$atr='') $cid = gets('token'); $pros = gpost('proses'); $query = mysql_query("SELECT * FROM psb_proses WHERE departemen='{$dept}'"); $token = doc_decrypt($token); /* $gb = mysql_query("SELECT nama,fname FROM rep_file WHERE replid=13") $data = mysql_fetch_assoc($gb) $gambar = $data[fname]; */ $doc = new doc(); $doc->dochead("Data Periode Penerimaan " . gets('kelompok'), 9); $doc->nl(); $doc->row_blank(9); $doc->nl(); $doc->cell('<b>NAMA</b>', 100, '', 9); //$t=dbQSql($token); $no = 1; $doc->head('No{C}', '@Periode Penerimaan', '@Kode Awalan', '@Angkatan', '@Kapasitas', '@Calon Siswa', '@Siswa diterima', '@Status', 'Keterangan'); while ($r = dbFA($query)) { $q = mysql_query("SELECT replid FROM psb_calonsiswa WHERE proses = '" . $r['replid'] . "'"); $n = mysql_num_rows($q); $q = mysql_query("SELECT replid FROM psb_calonsiswa WHERE proses = '" . $r['replid'] . "' AND status<>0"); $n1 = mysql_num_rows($q); $doc->nl(); $doc->cell($no++, 20, 'c'); $doc->cell($r['proses'], 80); $doc->cell($r['kodeawalan'], 30); $doc->cell($r['angkatan'], 30); $doc->cell($r['kapasitas'], 50); $doc->cell($n, 50);
if ($sna != "") { $db->field("(" . $sna . ") as TNRAPOR"); } else { $db->field("0 as TNRAPOR"); } if ($npeni > 0) { $db->field("((" . $sna . ")/" . $npeni . ") as AVGRAPOR"); } else { $db->field("0 as AVGRAPOR"); } $t = $db->query(); $doc = new doc(); $doc->dochead("LAPORAN HASIL BELAJAR SISWA", 6); $doc->row_blank(6); $doc->nl(); $doc->cell('<b>NAMA</b>', 100, '', 2); $doc->cell('<b>: ' . strtoupper($siswa['nama']) . '</b>', 0, '', 4); $doc->nl(); $doc->cell('<b>NIS</b>', 100, '', 2); $doc->cell('<b>: ' . $siswa['nis'] . '</b>', 0, '', 4); $doc->nl(); $doc->cell('<b>KELAS</b>', 100, '', 2); $doc->cell('<b>: ' . $siswa['nkelas'] . '</b>', 0, '', 4); $doc->nl(); $doc->cell('', 40); $doc->cell('', 60); $doc->cell('', 0, '', 4); $doc->cell_format('border:1,align:c'); $doc->nl(30); $doc->cell('<b>NO</b>', 40); $doc->cell('<b>MATA PELAJARAN</b>', 0, '', 2);
$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();
<?php appmod_use('aka/siswa', 'aka/kelas', 'aka/pelajaran', 'aka/rapor'); // cell($a,$w=0,$c=1,$r=1,$al='',$b=-1,$bg='',$s='',$atr='') $token = gets('token'); $token = doc_decrypt($token); $doc = new doc(); $doc->dochead("Data Siswa Angkatan " . gets('angkatan'), 5); $doc->row_blank(5); $t = dbQSql($token); $no = 1; $doc->head('No{C}', '@!NIS', '@!NISN', '@nama', 'Tempat Tanggal lahir'); while ($r = dbFA($t)) { $doc->nl(); $doc->cell($no++, 40, 'c'); $doc->cell($r['nis'], 50); $doc->cell($r['nisn'], 80); $doc->cell($r['nama'], 0); $doc->cell($r['tmplahir'] . ', ' . fftgl($r['tgllahir']), 170); } $doc->end();
$cid = gets('token'); $pros = gpost('proses'); $query = mysql_query("SELECT * FROM psb_calonsiswa WHERE replid='{$cid}' LIMIT 0,1"); $token = doc_decrypt($token); /* $gb = mysql_query("SELECT nama,fname FROM rep_file WHERE replid=13") $data = mysql_fetch_assoc($gb) $gambar = $data[fname]; */ $proses = mysql_fetch_array(mysql_query("SELECT * FROM psb_proses WHERE replid='" . $r['proses'] . "' LIMIT 0,1")); $kelompok = mysql_fetch_array(mysql_query("SELECT * FROM psb_kelompok WHERE replid='" . $r['kelompok'] . "' LIMIT 0,1")); $departemen = mysql_fetch_array(mysql_query("SELECT * FROM departemen WHERE replid='" . $proses['departemen'] . "' LIMIT 0,1")); $doc = new doc(); $doc->dochead("Data Calon Siswa " . gets('kelompok'), 9); $doc->n1(); $doc->cell('<b>Proses Penerimaan</b>', 100, '', 2); $doc->cell('<b>: ' . $proses['proses'] . '</b>', 0, '', 4); //$t=dbQSql($token); $no = 1; $doc->head('No{C}', '@Periode Penerimaan', '@Kode Awalan', '@Angkatan', '@Kapasitas', '@Calon Siswa', '@Siswa diterima', '@Status', 'Keterangan'); while ($r = dbFA($query)) { $q = mysql_query("SELECT replid FROM psb_calonsiswa WHERE proses = '" . $r['replid'] . "'"); $n = mysql_num_rows($q); $q = mysql_query("SELECT replid FROM psb_calonsiswa WHERE proses = '" . $r['replid'] . "' AND status<>0"); $n1 = mysql_num_rows($q); $doc->nl(); $doc->cell($no++, 20, 'c'); $doc->cell($r['proses'], 80); $doc->cell($r['kodeawalan'], 30); $doc->cell($r['angkatan'], 30); $doc->cell($r['kapasitas'], 50);
<?php appmod_use('aka/siswa', 'aka/kelas', 'aka/pelajaran', 'aka/rapor'); // Query $sql = gpost('pagesql'); $t = mysql_query($sql); $doc = new doc(1); $doc->colnum = 1; $doc->dochead("JURNAL UMUM", $doc->colnum); $doc->row_blank($doc->colnum); $doc->nl(); $doc->cell('<b>NAMA</b>', 100, '', 2); $doc->cell('<b>: ' . strtoupper($siswa['nama']) . '</b>', 0, '', 4); /* $doc->nl(); $doc->cell('<b>NIS</b>',100,'',2); $doc->cell('<b>: '.$siswa['nis'].'</b>',0,'',4); $doc->nl(); $doc->cell('<b>KELAS</b>',100,'',2); $doc->cell('<b>: '.$siswa['nkelas'].'</b>',0,'',4); $doc->nl(); $doc->cell('',40); $doc->cell('',60); $doc->cell('',0,'',4); $doc->cell_format('border:1,align:c'); $doc->nl(30); $doc->cell('<b>NO</b>',40); $doc->cell('<b>MATA PELAJARAN</b>',0,'',2);
<?php //appmod_use('aka/siswa','aka/kelas','aka/pelajaran','aka/rapor'); // cell($a,$w=0,$c=1,$r=1,$al='',$b=-1,$bg='',$s='',$atr='') $token = gets('token'); $token = doc_decrypt($token); $doc = new doc(); $doc->dochead("Data Siswa Kelas " . gets('kelas'), 5); $doc->nl(); $doc->cell("Tahun Ajaran " . gets('tahunajaran'), 0, 'c', 5, 1); $doc->row_blank(5); $t = dbQSql($token); $no = 1; $doc->head('No{C}', '@!NIS', '@!NISN', '@nama', 'Tempat Tanggal lahir'); while ($r = dbFA($t)) { $doc->nl(); $doc->cell($no++, 40, 'c'); $doc->cell($r['nis'], 50); $doc->cell($r['nisn'], 80); $doc->cell($r['nama'], 0); $doc->cell($r['tmplahir'] . ', ' . fftgl($r['tgllahir']), 170); } $doc->end();