<?php
appmod_use('keu/kategori', 'keu/rekening', 'psb/proses', 'psb/kelompok', 'aka/angkatan', 'aka/tahunajaran');
$fmod = 'modul';
$xtable = new xtable($fmod, 'modul pembayaran');
$kmod = gpost('kategori', 1);
$kategori = kategori_r();
// Page Selection Bar
$PSBar = new PSBar_2(140);
$PSBar->begin();
$PSBar->selection('Kategori pembayaran', iSelect('kategori', $kategori, $kmod, $PSBar->selws, $fmod . "_get()"));
$PSBar->end();
$s = '<button class="btn" title="Tambah data modul pembayaran" style="float:left;margin-right:4px" onclick="E(\'reftipe\').value=0;modul_form(\'af\')"><div class="bi_add">Modul pembayaran</div></button>';
$xtable->btnbar_f($s);
// Query
$db = new xdb("keu_modul", "*", "kategori='{$kmod}'", "nama");
$t = $db->query();
$xtable->ndata = mysql_num_rows($t);
if ($xtable->ndata > 0) {
// Table head
$xtable->head('Nama Pembayaran', 'Kode Rekening', 'Keterangan');
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin();
$xtable->td($r['nama'], 300);
$s = '<b>Kas:</b> ' . rekening_name($r['rek1']);
if ($r['rek2'] != 0) {
$s .= '<br/><b>Pendapatan:</b> ' . rekening_name($r['rek2']);
}
if ($r['rek3'] != 0) {
$s .= '<br/><b>Piutang:</b> ' . rekening_name($r['rek3']);
}
<?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);
<?php
require_once MODDIR . 'fform/fform.php';
$opt = gpost('opt');
$cid = gpost('cid');
if ($cid == '') {
$cid = 0;
}
appmod_use('aka/tahunajaran', 'aka/pelajaran');
// form Module
$fmod = 'guru';
$dbtable = 'aka_guru';
$fform = new fform($fmod, $opt, $cid);
$inp = app_form_gpost('tahunajaran', 'pegawai', 'pelajaran', 'aktif', 'keterangan');
if ($opt == 'a' || $opt == 'u' || $opt == 'd') {
//db operation : add , update, delete
$q = false;
if ($opt == 'a') {
// add
$q = dbInsert($dbtable, $inp);
$y = mysql_query("SELECT * FROM admin WHERE pegawai='" . $inp['pegawai'] . "'");
// $y=mysql_query("SELECT * FROM admin WHERE pegawai='".$inp['pegawai']."'");
if (mysql_num_rows($y) == 0) {
$y = mysql_query("SELECT hrd_pegawai.nip,hrd_pegawai.nama FROM hrd_pegawai WHERE hrd_pegawai.replid='" . $inp['pegawai'] . "'");
$u = mysql_fetch_array($y);
$q = mysql_query("INSERT INTO admin SET app='gur', nama='" . $u['nama'] . "', uname='" . $u['nip'] . "', passwd='" . md5('admin') . "', pegawai='" . $inp['pegawai'] . "', level='2'");
}
} else {
if ($opt == 'u') {
// edit
$q = dbUpdate($dbtable, $inp, "replid='{$cid}'");
<?php
require_once MODDIR . 'fform/fform.php';
$opt = gpost('opt');
$cid = gpost('cid');
if ($cid == '') {
$cid = 0;
}
appmod_use('keu/inventory');
// form Module
$fmod = "inventory_brg";
$dbtable = "keu_brg";
$fform = new fform($fmod, $opt, $cid, 'barang');
$inp = app_form_gpost('kelompokbrg', 'kode', 'nama', 'tanggal', 'unit', 'satuan', 'keterangan');
if ($opt == 'a' || $opt == 'u' || $opt == 'd') {
$q = false;
if ($opt == 'a') {
// add
$q = dbInsert($dbtable, $inp);
} else {
if ($opt == 'u') {
// edit
$q = dbUpdate($dbtable, $inp, "replid='{$cid}'");
} else {
if ($opt == 'd') {
// delete
$q = dbDel($dbtable, "replid='{$cid}'");
}
}
}
$fform->notif($q);
<?php
require_once MODDIR . 'fform/fform.php';
$opt = gpost('opt');
$cid = gpost('cid');
if ($cid == '') {
$cid = 0;
}
appmod_use('aka/jenismutasi');
// form Module
$fmod = 'mutasi';
$dbtable = 'aka_mutasi';
$fform = new fform($fmod, $opt, $cid);
$inp = app_form_gpost('jenismutasi', 'siswa', 'tanggal', 'keterangan');
if ($opt == 'a' || $opt == 'u' || $opt == 'd') {
$q = false;
if ($opt == 'a') {
// add
$q = dbInsert($dbtable, $inp);
$q = dbQSql("UPDATE aka_siswa SET aktif='3' WHERE replid='" . $inp['siswa'] . "'");
} else {
if ($opt == 'u') {
// edit
$q = dbUpdate($dbtable, $inp, "siswa='{$cid}'");
} else {
if ($opt == 'd') {
// delete
$q = dbDel($dbtable, "siswa='{$cid}'");
$q = dbQSql("UPDATE aka_siswa SET aktif='1' WHERE replid='{$cid}'");
}
}
<?php
appmod_use('aka/tahunajaran', 'aka/guru', 'aka/presensi');
$opt = gpost('opt');
$cid = gpost('cid', 0);
$fmod = 'presensiguru';
$xtable = new xtable($fmod, 'presensi');
$xtable->noopt = true;
$xtable->search_keyon('nama=>hrd_pegawai.nama:LIKE-0');
$dept = gpost('departemen');
$departemen = departemen_r($dept);
if (count($departemen) > 0) {
$tajar = gpost('tahunajaran');
$tahunajaran = tahunajaran_r($tajar, $dept);
$tanggal = gpost('tanggal');
if ($tanggal == '') {
$tanggal = date("Y-m-d");
}
$tgl = explode("-", $tanggal);
$dim = cal_days_in_month(CAL_GREGORIAN, intval($tgl[1]), intval($tgl[0]));
$tgl_f = $tgl[0] . "-" . $tgl[1] . "-1";
$tgl_c = date("Y-m-d");
$tgl_l = $tgl[0] . "-" . $tgl[1] . "-" . $dim;
$tgl_cm = $tgl[0] . "-" . $tgl[1] . "-";
$t0 = date('Y-m-d', strtotime('- 1 day', strtotime($tanggal)));
$t1 = date('Y-m-d', strtotime('+ 1 day', strtotime($tanggal)));
// Page Selection Bar
$PSBar = new PSBar_2();
$PSBar->begin();
$PSBar->selection_departemen($fmod, $dept);
if (count($tahunajaran) > 0) {
<?php
appmod_use('keu/rekening');
$tahunbuku = tahunbuku_getaktifid();
$fmod = 'transaksi';
$xtable = new xtable($fmod);
$xtable->row_strip = false;
//$xtable->search_keyon('nama=>aka_siswa.nama:LIKE|aka_siswa.nis:EQ-0,1');
$xtable->search_keyon('cari=>keu_transaksi.nomer:EQ|keu_transaksi.uraian:LIKE-1,2');
$xtable->pageorder = "keu_transaksi.tanggal,keu_transaksi.ct";
$tanggal1 = gpost('tanggal1', date("Y-m") . "-1");
$tgl = explode("-", date("Y-m-d"));
$dim = cal_days_in_month(CAL_GREGORIAN, intval($tgl[1]), intval($tgl[0]));
$tanggal2 = gpost('tanggal2', date("Y-m") . "-" . $dim);
$ct_jurnaldetil = gpost('ct_jurnaldetil', 1);
$ct_umum = gpost('ct_umum', 1);
$ct_pemasukan = gpost('ct_pemasukan', 1);
$ct_pengeluaran = gpost('ct_pengeluaran', 1);
$ct_siswa = gpost('ct_siswa', 1);
$ct_calonsiswa = gpost('ct_calonsiswa', 1);
$ct_barang = gpost('ct_barang', 1);
$w = "";
$sel = 0;
if ($ct_umum != 0) {
if ($w != "") {
$w .= " OR ";
}
$w .= "keu_transaksi.jenis='" . JT_UMUM . "'";
$sel++;
}
if ($ct_pemasukan != 0) {
<?php
appmod_use('aka/guru', 'aka/tingkat', 'aka/siswa');
$gid = guru_SID();
$opt = gpost('opt');
$fmod = 'daftarnilai';
$xtable = new xtable($fmod, 'penilaian');
//$xtable->pageorder="aka_penilaian.replid";
$xtable->tbl_width = '800px';
$xtable->noopt = true;
$xtable->disabletextselection();
$pel = gpost('pelajaran');
$pelajaran = guru_pelajaran_r($pel);
$kls = gpost('kelas');
$kelas = guru_kelas_r($kls);
$peni = gpost('penilaian');
$penilaian = guru_penilaian_r($peni, $pel, $kls);
$t = mysql_query("SELECT * FROM aka_penilaian WHERE replid='{$peni}' LIMIT 0,1");
$dpeni = mysql_fetch_array($t);
// Page Selection Bar
$PSBar = new PSBar_2();
$PSBar->begin();
if (count($pelajaran) > 0) {
$PSBar->selection('Pelajaran', iSelect('pelajaran', $pelajaran, $pel, $PSBar->selws, $fmod . "_get()"));
} else {
$PSBar->end();
hiddenval('pelajaran', $pel);
hiddenval('kelas', $kel);
hiddenval('penilaian', $peni);
echo '<div class="warnbox" style="float:left">Tidak ada pelajaran yang diajar.</div>';
$PSBar->pass = false;
<?php
require_once MODDIR . 'fform/fform.php';
$opt = gpost('opt');
$cid = gpost('cid');
if ($cid == '') {
$cid = 0;
}
appmod_use('keu/kategori', 'keu/rekening', 'aka/angkatan', 'aka/tahunajaran', 'aka/siswa');
// form Module
$fmod = 'modul';
$dbtable = 'keu_modul';
$fform = new fform($fmod, $opt, $cid, 'Modul pembayaran');
$inp = app_form_gpost('kategori', 'reftipe', 'refid', 'nama', 'rek1', 'rek2', 'rek3', 'keterangan', 'nominal', 'cicilan');
if ($opt == 'a' || $opt == 'u' || $opt == 'd') {
$q = false;
if ($opt == 'a') {
// add
$q = dbInsert($dbtable, $inp);
if ($q) {
$modid = mysql_insert_id();
$refid = $inp['refid'];
$pemb = array('modul' => $modid, 'siswa' => 0, 'nominal' => 0, 'cicilan' => 0);
if ($inp['reftipe'] == RT_USP) {
$piut = 0;
// Set pembayaran uang pangkal
$t = mysql_query("SELECT aka_siswa.replid,aka_siswa.sumnet,aka_siswa.angsuran FROM aka_siswa WHERE aka_siswa.angkatan='{$refid}'");
while ($r = mysql_fetch_array($t)) {
$pemb['siswa'] = $r['replid'];
$pemb['nominal'] = $r['sumnet'];
$pemb['cicilan'] = $r['angsuran'];
<?php require_once(MODDIR.'xform/xform.php'); require_once(MODDIR.'control.php');
appmod_use('aka/siswa');
$opt=gpost('opt'); $cid=gpost('cid',0); $mtipe=gpost('mtipe',0);
hiddenval('member_id',$cid);
hiddenval('member_tipe',$mtipe);
$fmod='sirkulasi_peminjaman_form_member_get';
$xform=new xform($fmod);
if($mtipe!=0){
$lbls='float:left;width:80px;margin-right:4px';
$fs='float:left;width:150px;margin-right:4px';
echo '<div style="float:left;margin-right:6px;width:62px;height:92px;margin-top:2px">';
$xform->photof($cid.'-'.$mtipe,'member',60,90,'h');
echo '</div>';
echo '<div style="float:left;width:280px">';
if($mtipe==1){
$db=siswa_db_byID($cid);
$t=$db->go();
$r=mysql_fetch_array($t);
echo '<div class="xrowl">';
echo '<div class="sfont" style="font-size:14px;float:left:margin-right:4px;width:324px"><b>'.$r['nama'].'</b></div>';
echo '</div>';
echo '<div class="xrowl">';
echo '<div class="sfont" style="'.$lbls.'">ID member:</div>';
echo '<div class="sfont" style="'.$fs.'">'.$r['nis'].'</div>';
echo '</div>';
echo '<div class="xrowl">';
<?php
appmod_use('aka/pelajaran', 'aka/tahunajaran', 'aka/tingkat', 'aka/kelas', 'aka/siswa');
$gid = guru_pegawaiId();
$fmod = 'penilaian';
$xtable = new xtable($fmod);
$dept = gpost('departemen');
$departemen = departemen_r($dept);
if (count($departemen) > 0) {
$tajar = gpost('tahunajaran');
$tahunajaran = tahunajaran_r($tajar, $dept);
$ting = gpost('tingkat');
$tingkat = tingkat_r($ting, $dept);
$kel = gpost('kelas');
$kelas = kelas_r($kel, $ting);
$pel = gpost('pelajaran');
$pelajaran = pelajaran_r_pegawai($pel, $gid);
// Query
$db = siswa_db_bykelas($kel);
$t = $db->query();
// echo "SELECT aka_guru.*,hrd_pegawai.nip,hrd_pegawai.nama FROM aka_guru LEFT JOIN hrd_pegawai ON aka_guru.pegawai=hrd_pegawai.replid WHERE aka_guru.pelajaran='$pel' ORDER BY hrd_pegawai.nama";
$xtable->ndata = mysql_num_rows($t);
// Page Selection Bar
$PSBar = new PSBar_2();
$PSBar->begin();
$PSBar->selection_departemen($fmod, $dept);
if (count($tahunajaran) > 0) {
$PSBar->selection('Tahun ajaran', iSelect('tahunajaran', $tahunajaran, $tajar, $PSBar->selws, $fmod . "_get()"));
} else {
$PSBar->end();
hiddenval('tahunajaran', $tajar);
<?php
require_once MODDIR . 'fform/fform.php';
$opt = gpost('opt');
$cid = gpost('cid');
if ($cid == '') {
$cid = 0;
}
appmod_use('aka/semester', 'aka/tingkat', 'aka/tahunajaran', 'aka/pelajaran');
// form Module
$fmod = 'rpp';
$dbtable = 'aka_rpp';
$fform = new fform($fmod, $opt, $cid, '!RPP');
$guru = guru_SID();
$pel = gpost('pelajaran');
$ting = gpost('tingkat');
$unit = gpost('unit');
$deskripsi = gpost('deskripsi');
if ($opt == 'a' || $opt == 'u' || $opt == 'd' || $opt == 'm') {
$q = false;
if ($opt == 'a') {
// add
$q = dbInsert($dbtable, $inp);
$q = mysql_query("INSERT INTO aka_rpp SET guru='{$guru}',pelajaran='{$pel}',tingkat='{$ting}',unit='{$unit}',deskripsi='{$deskripsi}'");
} else {
if ($opt == 'u') {
// edit
$q = mysql_query("UPDATE aka_rpp SET unit='{$unit}',deskripsi='{$deskripsi}' WHERE replid='{$cid}'");
} else {
if ($opt == 'd') {
// delete
<?php
appmod_use('sar');
$spage = gpost('spage');
if ($spage == 'katalog') {
require_once VWDIR . 'inventory_katalog.php';
} else {
if ($spage == 'katalog_unit') {
require_once VWDIR . 'inventory_katalog_unit.php';
} else {
$fmod = 'inventaris';
$lok = gpost('lokasi');
$lokasi = lokasi_r($lok);
$PSBar = new PSBar_2();
// Page selection bar
$PSBar->begin();
if (count($lokasi) > 0) {
$PSBar->selection('lokasi', iSelect('lokasi', $lokasi, $lok, $PSBar->selws, $fmod . "_get()"));
} else {
$PSBar->end();
hiddenval('lokasi', $lok);
lokasi_warn();
exit;
}
$PSBar->end();
// xtable Query
$xtable = new xtable($fmod, 'Grup barang');
$db = new xdb("sar_grup", "", "lokasi='{$lok}'");
$t = $xtable->use_db($db, $xtable->pageorder_sql('kode', 'nama'));
$xtable->btnbar_begin();
//$xtable->btnbar_add();
<?php
require_once MODDIR . 'xform/xform.php';
require_once MODDIR . 'control.php';
appmod_use('hrd/status');
$opt = gpost('opt');
$cid = gpost('cid', 0);
$fmod = 'pegawai';
$xform = new xform($fmod, $opt, $cid);
$status = status_opt();
if ($opt == 'uf') {
// Nilai field editan
$t = mysql_query("SELECT * FROM hrd_pegawai WHERE replid='{$cid}' LIMIT 0,1");
$data = mysql_fetch_array($t);
$ttl = 'Edit';
} else {
// Nilai field default
$data = array();
//$data['halaman']=1;
//$data['pengarang']='-';
//$data['tahunterbit']=date("Y");
$ttl = 'Tambah';
}
$xform->title($ttl . ' Data Pagawai');
$xform->table_begin();
$xform->col_begin();
//$xform->set_fieldw(280);
$xform->group_begin('Data Pribadi');
$xform->fi('NIP', iText('nip', $data['nip'], $xform->fieldws));
$xform->fi('Nama', iText('nama', $data['nama'], $xform->fieldws));
$xform->fi('Tempat lahir', iText('tmplahir', $data['tmplahir'], $xform->fieldws));
<?php
session_start();
require_once MODDIR . 'fform/fform.php';
require_once MODDIR . 'xtable/xtable.php';
$opt = gpost('opt');
$cid = gpost('cid');
if ($cid == '') {
$cid = 0;
}
appmod_use('keu/rekening', 'keu/budget');
require_once MODDIR . 'control.php';
$sesid = session_id();
// form Module
$fmod = "transaksi";
$dbtable = "keu_transaksi";
$fform = new fform($fmod, $opt, $cid);
if ($opt == 'a' || $opt == 'u' || $opt == 'd') {
//add, update, delete
$q = false;
if ($opt == 'a') {
// add
$jt = gpost('trans_jenis');
$no = gpost('trans_nomer');
$nobukti = gpost('trans_nobukti');
$ct = gpost('trans_ct');
$tgl = gpost('trans_tanggal');
$bud = gpost('budget');
if ($jt == JT_UMUM) {
$urai = gpost('uraian');
$jur = array();
<?php
appmod_use('pus/statistik');
$stat = gpost('statistik');
$statistik = statistik_r($stat);
require_once VWDIR . 'statistik' . $stat . '.php';
<?php
appmod_use('keu/budget');
$fmod = 'budget';
$xtable = new xtable($fmod, 'anggaran');
$tahunbuku = tahunbuku_getaktif();
$tbuku = $tahunbuku['replid'];
if ($tbuku != 0) {
// Page Selection Bar
$PSBar = new PSBar_2(140);
$PSBar->begin();
$PSBar->selection('Tahun buku', '<b>' . $tahunbuku['nama'] . '</b>');
hiddenval('tahunbuku', $tahunbuku['replid']);
$PSBar->end();
$xtable->btnbar_f('add');
// Query
$db = new xdb("keu_budget", "*", "tahunbuku='{$tbuku}'", "nama");
$t = $db->query();
$xtable->ndata = mysql_num_rows($t);
if ($xtable->ndata > 0) {
// 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>';
<?php
appmod_use('aka/guru', 'aka/tingkat');
$gid = guru_SID();
$fmod = 'jurnal';
$xtable = new xtable($fmod, 'jurnal');
$pel = gpost('jurnal');
$pelajaran = guru_pelajaran_r($pel);
$kls = gpost('kelas');
$kelas = guru_kelas_r($kls);
// Page Selection Bar
$PSBar = new PSBar_2();
$PSBar->begin();
if (count($pelajaran) > 0) {
$PSBar->selection('Pelajaran', iSelect('pelajaran', $pelajaran, $pel, $PSBar->selws, $fmod . "_get()"));
} else {
$PSBar->end();
hiddenval('pelajaran', $pel);
hiddenval('kelas', $kel);
echo '<div class="warnbox" style="float:left">Tidak ada pelajaran yang diajar.</div>';
$PSBar->pass = false;
}
if ($PSBar->pass) {
if (count($kelas) > 0) {
$PSBar->selection('Kelas', iSelect('kelas', $kelas, $kls, $PSBar->selws, $fmod . "_get()"));
} else {
$PSBar->end();
hiddenval('kelas', $kls);
echo '<div class="warnbox" style="float:left">Tidak ada kelas yang diajar.</div>';
$PSBar->pass = false;
}
<?php
require_once MODDIR . 'fform/fform.php';
require_once MODDIR . 'control.php';
$opt = gpost('opt');
$cid = gpost('cid');
if ($cid == '') {
$cid = 0;
}
appmod_use('aka/siswa', 'aka/kelas');
$ssid = session_id();
// form Module
$fmod = "siswa_pendataan_kelas";
$dbtable = 'aka_siswa_kelas';
if ($opt == 'a') {
$kls = gpost('kelas');
$data = gpost('data');
if ($data != "") {
$q = true;
$did = explode(",", $data);
$n = count($did);
for ($i = 0; $i < $n; $i++) {
$cid = $did[$i];
$q &= dbQSql("INSERT INTO aka_siswa_kelas SET kelas='{$kls}',siswa='{$cid}'");
//log_print("INSERT INTO aka_siswa_kelas SET kelas='$kls',siswa='$cid'");
}
}
} else {
if ($opt == 'd') {
// delete
$kls = gpost('kelas');
<?php
require_once MODDIR . 'fform/fform.php';
require_once MODDIR . 'control.php';
$opt = gpost('opt');
$cid = gpost('cid');
if ($cid == '') {
$cid = 0;
}
appmod_use('aka/guru', 'aka/tahunajaran');
$ssid = session_id();
// form Module
$fmod = "presensiguru";
$dbtable = 'aka_absen_guru';
if ($opt == 'a') {
$q = false;
$tanggal = gpost('tanggal');
$data = gpost('data');
//log_print("DATA: ".$data);
if ($data != "") {
$did = explode(",", $data);
$n = count($did);
for ($i = 0; $i < $n; $i++) {
$cid = $did[$i];
$absen = gpost('absen_' . $cid);
$keterangan = gpost('keterangan_' . $cid);
dbDel("aka_absen_guru", "guru='{$cid}' AND tanggal='{$tanggal}'");
$q = dbQSql("INSERT INTO aka_absen_guru SET absen='{$absen}',keterangan='{$keterangan}',guru='{$cid}',tanggal='{$tanggal}'");
//log_print("INSERT INTO aka_siswa_kelas SET kelas='$kls',siswa='$cid'");
}
}
<?php
require_once MODDIR . 'control.php';
require_once MODDIR . 'xtable/xtable.php';
appmod_use('aka/guru');
$pel = gpost('pelajaran');
$tajar = gpost('tahunajaran');
$fmod = 'sks_guru_list';
$xtable = new xtable($fmod, 'item', '', 3);
$xtable->search_box_pos('l');
$xtable->search_keyon('kunci=>hrd_pegawai.nip:EQ|hrd_pegawai.nama:LIKE-0,1');
$xtable->pageorder = "hrd_pegawai.nama";
// Query
$db = guru_db();
$db->where_and("aka_guru.pelajaran='{$pel}'");
$db->where_and("aka_guru.tahunajaran='{$tajar}'");
$db->where_and($xtable->search_sql_get());
$t = $db->query();
$xtable->ndata = mysql_num_rows($t);
$t = $db->query($xtable->pageorder_sql('hrd_pegawai.nama', 'hrd_pegawai.nip'));
//$xtable->search_box('NIP atau nama guru');
if ($xtable->ndata > 0) {
echo '<div style="width:100%;height:300px;max-height:300px;overflow:auto">';
$xtable->head('@Nama', '@!NIP', '{44px}');
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin();
$xtable->td($r['npegawai']);
$xtable->td($r['nip'], 80);
$s = '<button class="btn" onclick="sks_guru_set(' . $r['replid'] . ',\'' . $r['npegawai'] . '\')">Pilih</button>';
$xtable->td($s, 40, 'c');
$xtable->row_end();
<?php
appmod_use('aka/guru', 'aka/siswa', 'aka/pelajaran');
$gid = guru_SID();
$opt = gpost('opt');
$fmod = 'nilairapor';
$xtable = new xtable($fmod, 'Nilai rapor');
//$xtable->pageorder="aka_penilaian.replid";
//$xtable->tbl_width='800px';
//$xtable->noopt=true;
//$xtable->disabletextselection();
$pel = gpost('pelajaran');
$pelajaran = guru_pelajaran_r($pel);
$kls = gpost('kelas');
$kelas = guru_kelas_r($kls);
$t = mysql_query("SELECT * FROM aka_penilaian WHERE replid='{$peni}' LIMIT 0,1");
$dpeni = mysql_fetch_array($t);
// Page Selection Bar
$PSBar = new PSBar_2();
$PSBar->begin();
if (count($pelajaran) > 0) {
$PSBar->selection('Pelajaran', iSelect('pelajaran', $pelajaran, $pel, $PSBar->selws, $fmod . "_get()"));
} else {
$PSBar->end();
hiddenval('pelajaran', $pel);
hiddenval('kelas', $kel);
hiddenval('penilaian', $peni);
echo '<div class="warnbox" style="float:left">Tidak ada pelajaran yang diajar.</div>';
$PSBar->pass = false;
}
if ($PSBar->pass) {
<?php
require_once MODDIR . 'control.php';
require_once MODDIR . 'xtable/xtable.php';
appmod_use('aka/angkatan', 'aka/siswa');
$fmod = 'siswa_pendataan_kelas_list';
$xtable = new xtable($fmod, 'siswa', '', 2);
$xtable->search_keyon('kunci=>aka_siswa.nis:EQ|aka_siswa.nama:LIKE-0,1');
$xtable->search_box_pos('l');
$xtable->pageorder = "aka_siswa.nis";
$xtable->use_select();
$xtable->select_noopt = true;
$xtable->select_cekfunc = "siswa_pendataan_kelas_list_cek(param)";
$dept = gpost('ff_departemen');
$departemen = departemen_r($dept);
$angk = gpost('ff_angkatan');
$angkatan = angkatan_r($angk, $dept);
$kls = gpost('kelas');
$PSBar = new PSBar_2(100);
$PSBar->begin();
if (count($departemen) > 0) {
$PSBar->selection('Departemen', iSelect('ff_departemen', $departemen, $depat, $PSBar->selws, $fmod . "_get(1)"));
} else {
$PSBar->end();
hiddenval('ff_departemen', $dept);
hiddenval('ff_angkatan', $angk);
departemen_warn(0);
$PSBar->pass = false;
}
if (count($angkatan) > 0) {
$PSBar->selection('Angkatan', iSelect('ff_angkatan', $angkatan, $angk, $PSBar->selws, $fmod . "_get(1)"));
<?php
require_once MODDIR . 'xform/xform.php';
require_once MODDIR . 'control.php';
require_once MODDIR . 'xtable/xtable.php';
appmod_use('aka/tingkat', 'aka/kelas', 'aka/siswa');
$tajar = gpost('tahunajaran', $tajar);
$tingk = gpost('tingkat');
$tingkat = tingkat_r($tingk, $tajar);
$kls = gpost('kelas');
$kelas = kelas_r($kls, $tingk);
$fmod = 'siswa_list_kelas';
$xform = new xform($fmod);
$xform->table_begin();
$xform->col_begin();
$xform->grupclass = '';
$xform->grupstyle = 'float:left';
$xform->group_begin('Pilih Siswa');
$PSBar = new PSBar_2(100, 220);
$PSBar->begin();
if (count($tingkat) > 0) {
$PSBar->selection('Tingkat', iSelect('tingkat', $tingkat, $tingk, $PSBar->selws, $fmod . "_get()"));
} else {
$PSBar->end();
hiddenval('tingkat', $tingk);
tingkat_warn(1);
exit;
}
if (count($kelas) > 0) {
$PSBar->selection('Kelas', iSelect('kelas', $kelas, $kls, $PSBar->selws, $fmod . "_get()"));
} else {
<?php
appmod_use('psb', 'psb/proses', 'psb/kelompok');
$dept = gpost('departemen');
$departemen = departemen_r($dept);
$pros = gpost('proses');
$proses = proses_r($pros, $dept);
$kel = gpost('kelompok');
// $kelompok =kelompok_r($kel,$pros);
$kelompok = kelompok_r($kel, $pros, 1);
$modeview = gpost('modeview', 'data');
hiddenval('modeview', $modeview);
$fmod = 'modul_psb';
//epi ------------------
$tgl = explode("-", date("Y-m-d"));
$dim = cal_days_in_month(CAL_GREGORIAN, intval($tgl[1]), intval($tgl[0]));
$tgl_f = date("Y-m") . "-1";
$tgl_c = date("Y-m-d");
$tgl_l = date("Y-m") . "-" . $dim;
$tanggal1 = gpost('tanggal1', $tgl_f);
// print_r($tanggal1);
$tanggal2 = gpost('tanggal2', $tgl_l);
hiddenval('tanggal_f', $tgl_f);
hiddenval('tanggal_c', $tgl_c);
hiddenval('tanggal_l', $tgl_l);
//endn of epi ---------
if (count($departemen) > 0) {
// Page Selection Bar
$PSBar = new PSBar_2();
$PSBar->begin();
$PSBar->selection_departemen($fmod, $dept);
<?php
appmod_use('aka/angkatan');
$opt = gpost('opt');
$cid = gpost('cid');
if ($cid == '') {
$cid = 0;
}
dbDel("aka_tmp_saudara", "sesid='" . session_id() . "'");
$fmod = 'siswa_pendataan_angkatan';
$dept = gpost('departemen');
$departemen = departemen_r($dept);
if (count($departemen) > 0) {
$angk = gpost('angkatan');
$angkatan = angkatan_r($angk, $dept);
// Page Selection Bar
$PSBar = new PSBar_2();
$PSBar->begin();
$PSBar->selection_departemen($fmod, $dept);
if (count($angkatan) > 0) {
$PSBar->selection('Angkatan', iSelect('angkatan', $angkatan, $angk, $PSBar->selws, $fmod . "_get()"));
} else {
$PSBar->end();
hiddenval('angkatan', $angk);
angkatan_warn(0, 'float:left');
$PSBar->pass = false;
}
$PSBar->end();
if ($PSBar->pass) {
if ($opt == 'af' || $opt == 'uf') {
require_once VWDIR . 'siswa_form.php';
<?php
require_once MODDIR . 'fform/fform.php';
$opt = gpost('opt');
$cid = gpost('cid');
if ($cid == '') {
$cid = 0;
}
appmod_use('aka/tahunajaran');
// form Module
$fmod = 'semester';
$dbtable = 'aka_semester';
$fform = new fform($fmod, $opt, $cid);
$inp = app_form_gpost('tahunajaran', 'nama', 'keterangan');
$tajar = $inp['tahunajaran'];
if ($opt == 'a' || $opt == 'u' || $opt == 'd') {
$q = false;
if ($opt == 'a') {
// add
$q = mysql_query("UPDATE aka_semester SET aktif='0' WHERE tahunajaran='{$tajar}'");
$inp['urut'] = urut_getlast($dbtable) + 1;
$q = dbInsert($dbtable, $inp);
} else {
if ($opt == 'u') {
// edit
$q = dbUpdate($dbtable, $inp, "replid='{$cid}'");
} else {
if ($opt == 'd') {
// delete
$q = dbDel($dbtable, "replid='{$cid}'");
$q &= dbDel("aka_kelas", "tingkat='{$cid}'");
<?php
require_once MODDIR . 'fform/fform.php';
require_once MODDIR . 'control.php';
$opt = gpost('opt');
$cid = gpost('cid');
if ($cid == '') {
$cid = 0;
}
appmod_use('aka/pelajaran');
// form Module
$fmod = "mutasi_siswa";
$fform = new fform($fmod, 'af', $cid, 'Cari item');
$fform->fformid = 2;
$fform->reg['title_af'] = '<idata>';
$fform->reg['btnlabel_a_y'] = 'Pilih yg ditandai';
$fform->reg['btnlabel_a_n'] = 'Tutup';
$fform->dimension(500);
$fform->ptop = 20;
$fform->globalkey = '0';
$fform->head('Pilih Siswa');
echo '<tr><td><div id="box_mutasi_siswa_list">';
require_once APPDIR . 'mutasi_siswa_list_get.php';
echo '</div></td></tr>';
$fform->foot(0);
<?php
require_once MODDIR . 'fform/fform.php';
require_once MODDIR . 'control.php';
$opt = gpost('opt');
$cid = gpost('cid');
if ($cid == '') {
$cid = 0;
}
appmod_use('aka/tahunajaran', 'aka/tingkat', 'aka/kelas');
$mtipe = gpost('mtipe');
if ($mtipe == '') {
$mtipe = "1";
}
// form Module
$fmod = "siswakelas";
$fform = new fform($fmod, 'af', $cid, 'Cari siswa');
$fform->reg['title_af'] = '<idata>';
//$fform->reg['btnlabel_a_y']='Pilih yg ditandai';
$fform->reg['btnlabel_a_n'] = 'Tutup';
$fform->dimension(500);
$fform->ptop = 50;
$fform->head('Pilih Siswa', 0);
echo '<tr><td><div id="data_member" style="height:350px;overflow:auto">';
if ($mtipe == "0" || $mtipe == "1") {
require_once APPDIR . 'sirkulasi_member_get_siswa.php';
}
echo '</div></td></tr>';
$fform->foot(0);
<?php
require_once MODDIR . 'fform/fform.php';
$opt = gpost('opt');
$cid = gpost('cid');
if ($cid == '') {
$cid = 0;
}
appmod_use('psb', 'aka/angkatan');
// form Module
$fmod = "pendataan_status";
$dbtable = "psb_calonsiswa";
$fform = new fform($fmod, $opt, $cid, 'status calon siswa');
$inp = app_form_gpost('status');
$departemen = gpost('departemen');
$tahunajaran = gpost('tahunajaran');
$angkatan = gpost('angkatan');
$tingkat = gpost('tingkat');
$kelas = gpost('kelas');
$nisn = gpost('nisn');
$nis = gpost('nis');
if ($opt == 'a' || $opt == 'u' || $opt == 'd') {
$q = false;
if ($opt == 'u') {
// edit
$ec = 0;
$q = dbUpdate($dbtable, $inp, "replid='{$cid}'");
if (!$q) {
$ec = 1;
}
if ($inp['status'] == '1') {
