Esempio n. 1
0
<?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();
Esempio n. 2
0
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();
Esempio n. 3
0
define('IMGDIR', ROTDIR . 'images/');
$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='')
$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);
Esempio n. 4
0
$db = siswa_db_byID($cid);
$siswa = $db->gofetch();
$kls = $siswa['idkelas'];
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');
Esempio n. 5
0
        $a = $s == 1 ? 0 : $d;
    }
    return $res;
}
$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');
<?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();
Esempio n. 7
0
$proses = proses_r($pros, $dept);
// 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_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);
Esempio n. 8
0
<?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();