<td align="center">
<input type="button" class="btn" onclick="close_fform()" value="Cancel"/>
<input type="button" class="btnx" value="Save" onclick="m_user('u',true,<?php
echo $cid;
?>
)"/>
</td>
</tr></table>
</div>
</div>
</td></tr></table>
<?php
} else {
if ($opt == 'df') {
// Delete Form
$r = dbSFA("*", "mstr_user", "W/dcid='{$cid}'");
?>
<table cellspacing="0" cellpadding="0" width="100%"><tr><td align="center" style="padding-top:120px">
<div class="fformbox" style="width:500px">
<div class="sfont" style="color:#ffffff;border-radius:5px 5px 0 0;background:#6a92e5;padding:6px 0 6px 0;">
<b>Delete <?php
echo $mtitle;
?>
</b>
</div>
<div style="text-align:left;padding:10px">
<table class="stable" cellspacing="0" cellpadding="4px" width="480px">
<tr><td><p class="line150">Are you sure you want to delete "<b><?php
echo $r['alias'];
?>
</b>"?</p></td></tr>
<tr><td> </td><?php
echo tdLabel("Family");
?>
<td><?php
echo iText('sd_info4', $emps['info4'], "width:680px");
?>
</td></tr>
<tr><td> </td><td colspan="2"></td></tr> <!-- Separator -->
<tr><td> </td><td colspan="2"></td></tr> <!-- Separator -->
<tr><td> </td><td colspan="2"></td></tr> <!-- Separator -->
<tr><td colspan="3" style="border-bottom:1px solid #aeaeae;padding-bottom:10px"><b>EMPLOYMENT APPLICATION</b></td></tr>
<tr><td> </td><td colspan="2"></td></tr> <!-- Separator -->
<tr height="20px" valign="top"><td width="20px"><b>A.</b></td><td colspan="2"><b>Check Desired Employment (check all that applies):</b></td></tr>
<tr><td> </td><td colspan="3">
<?php
$empap = dbSFA("*", "emp_apos", "W/empid='{$dcid}'");
$apos = explode("~", $empap['option']);
$aposi = array('Playschool Principal/Teacher', 'Senior High Principal/Teacher', 'Kindergarten Principal/Teacher', 'Secretary/Administration', 'Elementary Principal/Teacher', 'Part Time Teacher', 'Junior High Principal/Teacher', 'Other:');
?>
<table id="apospt" cellspacing="0px" cellpadding="0" border="0">
<?php
for ($i = 0; $i < 8; $i += 2) {
?>
<tr height="24px">
<td width="20px"><input id="apos<?php
echo $i + 1;
?>
" type="checkbox" name="apos<?php
echo $i + 1;
?>
" <?php
while ($r = mysql_fetch_array($t)) {
$stat = gpost('syarat' . $r['syarat']);
$q = mysql_query("UPDATE psb_calonsiswa_syarat SET status='{$stat}' WHERE calonsiswa='{$cid}' AND syarat='" . $r['syarat'] . "'");
}
} else {
if ($opt == 'd') {
// delete
$q = dbDel($dbtable, "replid='{$cid}'");
}
}
}
$fform->notif($q);
} else {
if ($opt == 'uf' || $opt == 'df') {
// Prepocessing form
$r = dbSFA("nama,nopendaftaran", $dbtable, "W/replid='{$cid}'");
} else {
}
//$fform->dimension(350);
$fform->lwidth = 150;
$fform->head();
if ($opt == 'af' || $opt == 'uf') {
require_once MODDIR . 'control.php';
// Add or Edit form
$fform->fl('Nama calon siswa', $r['nama']);
$fform->fl('Nomor pendaftaran', $r['nopendaftaran']);
$s = '';
//qarea();
$t = mysql_query("SELECT psb_calonsiswa_syarat.*,psb_syarat.wajib,psb_syarat.syarat as nama FROM psb_calonsiswa_syarat LEFT JOIN psb_syarat ON psb_syarat.replid=psb_calonsiswa_syarat.syarat WHERE psb_calonsiswa_syarat.calonsiswa='{$cid}' AND psb_syarat.wajib='1'");
if (mysql_num_rows($t) > 0) {
$si = '<table cellspacing="0" cellpaddin="0">';
$doc->nl();
// cell($a,$w=0,$al='',$c=1,$r=1,$b=-1,$bg='',$s='',$atr='')
$nilai = rapor_pelajaran_nilai($rpel['replid'], $kls, $siswa['replid']);
$skm = pelajaran_skm($rpel['replid']);
$doc->cell($no++, 40);
$doc->cell($rpel['nama'], '244#', 'l', 2, 1);
$doc->cell(number_format($nilai, 2), 80);
$doc->cell(number_format($skm, 2), 80);
$doc->cell($nilai < $skm ? 'Tidak tuntas' : 'Tuntas', 120);
$jmlnilai += $nilai;
}
$rata = $jmlnilai / ($no - 1);
$doc->nl();
$doc->cell('<b>Jumlah Nilai</b>', 0, '', 3);
$doc->cell('<b>' . $jmlnilai . '</b>' . '[x:fmla="=SUM(D8:D10)" x:num]', 'c');
$doc->cell('', 0, '', 2);
$doc->nl();
$doc->cell('<b>Rata-Rata Nilai</b>', 0, '', 3);
$doc->cell('<b>' . number_format($rata, 2) . '</b>' . '[x:fmla="=AVERAGE(D8:D10)" x:num="' . number_format($rata, 2) . '"]', 0, 'c', 1, 1, -1, '', 'mso-number-format:\'0\\.00_ \'');
$doc->cell('', 0, '', 2);
$doc->nl();
$doc->cell('<b>Peringkat</b>', 0, '', 3);
$doc->cell(rapor_peringkatkelas_siswa($kls, $siswa['replid']) . ' dari ' . kelas_jumlahsiswa($kls) . ' siswa', 0, '', 3);
$doc->row_blank(6);
$komen = dbSFA("*", "aka_komenrapor", "W/ siswa='" . $siswa['replid'] . "' AND tahunajaran='{$tajar}'");
$doc->cell_format_reset();
$doc->nl();
$doc->cell('Keterangan hasil belajar:', 0, '', 6);
$doc->nl(100, 'top');
$doc->cell($komen['komen'], 0, '', 6, 1, 1);
$doc->end();
$lheight = 1;
/*
if($plhead=='Y') $lheight+=9;
if($plcnum=='Y') $lheight+=14;
if($plbcode=='Y') $lheight+=10;
*/
$q = mysql_query("SELECT * FROM `p_label`");
$k = 0;
$kol = 0;
$row = 0;
$i = 0;
$nkol = floor($dcPageW / ($lwidth + 1));
$nrow = 99;
//$nrow=floor($dcPageH/$lheight);
while ($r = mysql_fetch_array($q)) {
$b = dbSFA("*", "book", "W/dcid='" . $r['book'] . "'");
// Print Label >>
$x = ($lwidth + 1) * $kol + $dcMarginL;
$y = $lheight * $row + $dcMarginT;
$pdf->SetXY($x, $y);
$pl = false;
if ($plhead == 'Y') {
$pl = true;
$pdf->setCellPaddings(0, 0.5, 0, 0);
$pdf->SetFont('dejavusans', '', 10, '', true);
$pdf->MultiCell($lwidth, 0, $title, 'LTR', 'C', 0, 1, '', '', true);
if ($k == 0) {
$lheight += $pdf->getLastH();
}
$pdf->SetX($x);
$pdf->setCellPaddings(0, 0, 0, 0.5);
}
}
}
}
}
require_once VWDIR . $fmod . '.php';
} else {
$sx = str_replace('f', '', $opt);
$nobtn = "Cancel";
// Form dimension
$fwidth = 400;
$lwidth = 100;
$iTextFw = "width:" . ($fwidth - $lwidth - 16) . "px";
// Preprocessing form
if ($opt == 'uf' || $opt == 'df') {
$r = dbSFA("*", $dbtable, "W/dcid='{$cid}'");
}
?>
<table cellspacing="0" cellpadding="0" width="100%"><tr><td align="center" style="padding-top:120px">
<div class="fformbox" style="width:<?php
echo $fwidth + 20;
?>
px">
<div class="sfont" style="color:#ffffff;border-radius:5px 5px 0 0;background:#6a92e5;padding:6px 0 6px 0;">
<b><?php
echo $mdialog[$opt] . " " . $mtitle;
?>
<br/></b>
</div>
<div style="text-align:left;padding:15px 10px;width:<?php
echo $fwidth;
<?php
$opt = gpost('opt');
$cid = gpost('cid');
$ntable = gpost('lst');
if ($opt == 'nf') {
require_once MODDIR . 'control.php';
// Query
$r = dbSFA("*", $ntable, "W/dcid='{$cid}' LIMIT 0,1");
$y = mysql_query("SELECT * FROM catalog WHERE dcid='" . $r['catalog'] . "' LIMIT 0,1");
$f = mysql_fetch_array($y);
$y1 = mysql_query("SELECT * FROM book WHERE barcode='" . $r['barcode'] . "' LIMIT 0,1");
$f1 = mysql_fetch_array($y1);
// Form dimension
$fwidth = 400;
$lwidth = 120;
$iTextFw = "width:" . ($fwidth - $lwidth - 16) . "px";
?>
<table cellspacing="0" cellpadding="0" width="100%"><tr><td id="fformt" align="center" style="padding-top:220px">
<div id="fformbox" class="fformbox" style="margin-top:-100px;width:<?php
echo $fwidth + 20;
?>
px;overflow:hidden">
<div class="sfont" style="padding:12px;text-align:left;color:#646464;font-size:15px">
Finish Stock Take
</div>
<div style="text-align:left;padding:5px 10px;width:<?php
echo $fwidth;
?>
px">
<table class="stable" cellspacing="0" cellpadding="4px" width="<?php
<?php
$opt = gpost('opt');
$cid = gpost('cid');
if ($opt == 'df') {
require_once MODDIR . 'control.php';
// Query
$r = dbSFA("title", "catalog", "W/dcid='{$cid}'");
// Form dimension
$fwidth = 400;
$lwidth = 120;
$iTextFw = "width:" . ($fwidth - $lwidth - 16) . "px";
?>
<table cellspacing="0" cellpadding="0" width="100%"><tr><td id="fformt" align="center" style="padding-top:220px">
<div id="fformbox" class="fformbox" style="width:<?php
echo $fwidth + 20;
?>
px;overflow:hidden">
<div class="sfont" style="padding:12px;text-align:left;color:#646464;font-size:15px">
Delete catalog
</div>
<div style="text-align:left;padding:5px 10px;width:<?php
echo $fwidth;
?>
px">
<table class="stable" cellspacing="0" cellpadding="4px" width="<?php
echo $fwidth;
?>
px">
<tr><td>Are you sure want to delete "<b><?php
echo $r['title'];
<?php
$opt = gpost('opt');
$cid = gpost('cid');
if ($opt == 'df') {
require_once MODDIR . 'control.php';
// Query
$r = dbSFA("nid", "book", "W/dcid='{$cid}'");
// Form dimension
$fwidth = 400;
$lwidth = 120;
$iTextFw = "width:" . ($fwidth - $lwidth - 16) . "px";
?>
<table cellspacing="0" cellpadding="0" width="100%"><tr><td id="fformt" align="center" style="padding-top:220px">
<div id="fformbox" class="fformbox" style="width:<?php
echo $fwidth + 20;
?>
px;overflow:hidden">
<div class="sfont" style="padding:12px;text-align:left;color:#646464;font-size:15px">
Delete book
</div>
<div style="text-align:left;padding:5px 10px;width:<?php
echo $fwidth;
?>
px">
<table class="stable" cellspacing="0" cellpadding="4px" width="<?php
echo $fwidth;
?>
px">
<tr><td>Are you sure want to delete book number "<b><?php
echo $r['nid'];
$fform->foot();
} else {
if ($opt == 'uf') {
$r = dbSFA("*", "aka_alumni", "W/replid='{$cid}'");
$r1 = dbSFA("nama,nisn", "aka_siswa", "W/replid='" . $r['siswa'] . "'");
//$fform->reg['title_af']='<idata>';
//$fform->reg['btnlabel_a_y']='Pilih yg ditandai';
//$fform->reg['btnlabel_a_n']='Batal';
//$fform->dimension(500);
//$fform->ptop=20;
//$fform->globalkey='0';
$fform->head();
$fform->fl('Nama alumni', $r1['nama']);
$fform->fl('NISD', $r1['nisn']);
$fform->fa('Keterangan', iTextarea('keterangan', $r['keterangan'], $fform->rwidths, 3));
$fform->foot();
} else {
if ($opt == 'df') {
//$fform->reg['title_df']='Keluarkan Siswa Dari Rombongan Belajar';
//$fform->reg['btnlabel_u_n']='Tidak';
//$fform->reg['btnlabel_d_y']=' Ya ';
$fform->head();
$r1 = dbSFA("nama,nis", "aka_siswa", "W/replid='{$cid}'");
$fform->dlg_del($r1['nama']);
$fform->foot();
}
}
}
}
}
}
$mstr_author = array();
$t = dbSel("*", "mstr_author", "O/ prefix LIMIT 0,20");
while ($r = dbFA($t)) {
$mstr_author[$r['dcid']] = $r['name'] . " (" . $r['prefix'] . ")";
}
$mstr_publisher = array();
$t = dbSel("*", "mstr_publisher", "O/ name LIMIT 0,20");
while ($r = dbFA($t)) {
$mstr_publisher[$r['dcid']] = $r['name'];
}
$mstr_class = MstrGetx("mstr_class", "code");
$mstr_language = MstrGet("mstr_language");
$txtWidth = "width:344px";
$dcid = gets('nid');
$r = dbSFA("*", "book", "W/`dcid`='{$dcid}' LIMIT 0,1");
?>
<script type="text/javascript" language="javascript">
function getBarcode(a){
var b=a.split("/");
E('barcode').value=b[0];
}
function getCallNumber(){
var classcode=E('class').value;
var author=getSelectedText('author');
var sa=author.indexOf("(")+1;
var sb=author.indexOf(")",sa);
auth=author.substring(sa,sb);
var title=E('title').value.substr(0,1);
title=title.toUpperCase();
var callnum=classcode+" "+auth+" "+title;
if ($opt == 'd') {
// delete
$q = dbDel($dbtable, "replid='{$cid}'");
}
}
}
// echo $q;
$fform->notif($q);
// var_dump($q);exit();
} else {
// view form : update , delete , add
$a = 0;
if ($opt == 'uf' || $opt == 'df') {
// update / delete form
$sel = $dbtable . '.*';
$r = dbSFA($sel, $dbtable . ',departemen', "W/keu_budget.replid='{$cid}' and keu_budget.id_department=departemen.replid");
// shared/db.php
// $r=dbSFA("*",$dbtable.','.'departemen',"W/keu_budget.replid='$cid' and keu_budget.id_department=departemen.replid"); // shared/db.php
// $r=dbSFA("*",$dbtable,"W/replid='$cid'"); // shared/db.php
// $r=dbLJoin($dbtable,'replid','departemen','replid'); // shared/db.php
// var_dump($r);
$a = 0;
// $kategorirek=kategorirek_r($a);
$departemen = departemen_r($a);
// print_r($departemen);
} else {
// opt == 'af' // add form
// $r = farray('kategorirek','kode','nama','keterangan'); //shared/libraries/common.php
$r = farray('tahunbuku', 'nama', 'nominal', 'keterangan', 'id_department');
//shared/libraries/common.php
// $r['kategorirek'] = gpost('skategorirek'); // shared/libraries/common.php
// Photo **
$rimg = dbFetch("photo", "emp_photo", "W/`empid`='{$dcid}'");
if (!empty($rimg)) {
$imgdata = base64_decode($rimg);
$pdf->Image('@' . $imgdata);
} else {
$pdf->Image('images/nophoto.png');
}
// Employee Data **
$pdf->SetFont('dejavusans', '', 9, '', true);
dc_EmployeeData('NIP', $r['nip']);
dc_EmployeeData('Level', $mstr_level[$r['level']]);
dc_EmployeeData('Division', $mstr_division[$r['division']]);
dc_EmployeeData('Group', $mstr_group[$r['group']]);
dc_EmployeeData('Position', $mstr_position[$r['position']]);
$a = dbSFA("date1,date2", "emp_status", "W/empid='{$dcid}'");
dc_EmployeeData('Status', $mstr_status[$r['status']]);
if ($r['status'] != 0) {
dc_EmployeeData('Status period', ftgl($a['date1']) . ($r['status'] == 1 ? '' : ' - ' . ftgl($a['date2'])));
}
$cy = dc_YDown(2);
$pdf->Line(65, $cy, $dcPaperW - $dcMarginR, $cy);
$cy = dc_YDown(2);
}
if ($dps[dp_Personalinformation] == '1') {
$dlbl = array();
$dlbl['Gender'] = $r['gender'];
$dlbl['Address'] = $r['address'];
$dlbl['Telepon/fax'] = $r['phonefax'];
$dlbl['Email'] = $r['email'];
$dlbl['Birth'] = $r['birthplace'] . ", " . fftgl($r['birthdate']);
<?php
$empstatus = getStatus();
$dcid = gpost('id');
$fname = gpost('name');
$r = dbSFA("*", "jbssdm.employment_app", "W/dcid='{$dcid}'");
?>
<script type="text/javascript" language="javascript">
</script>
<table cellspacing="0" cellpadding="0" width="100%"><tr><td align="center" style="padding-top:120px">
<div class="fformbox" style="width:400px">
<div class="sfont" style="color:#ffffff;border-radius:5px 5px 0 0;background:#6a92e5;padding:6px 0 6px 0;">
<b>Edit Data <?php
echo $fname;
?>
</b>
</div>
<div style="text-align:left;padding:10px">
<table class="stable" cellspacing="0" cellpadding="3px" width="380px">
<tr><td width="100px">NIP:</td><td><input type="text" class="ifield" id="nip" value="<?php
echo $r['nip'];
?>
" style="width:250px"/></td></tr>
<tr><td>Bagian:</td><td>
<select class="ifield" id="empbagian" style="width:140px">
<option value="Akademik"<?php
echo isSelect("Non Akademik", $r['empbagian']);
?>
>Akademik</option>
<option value="Non Akademik"<?php
<?php
$t = mysql_query("SELECT * FROM so_history WHERE status='1'");
if (mysql_num_rows($t) > 0) {
$stocktaking = true;
} else {
$stocktaking = false;
}
$r = dbSFA("*", "catalog", "W/`dcid`='{$dcid}' LIMIT 0,1");
if (!empty($r)) {
$publisher = dbFetch("name", "mstr_publisher", "W/`dcid`='" . $r['publisher'] . "'");
$lang = dbFetch("name", "mstr_language", "W/`dcid`='" . $r['language'] . "'");
$author = dbFetch("name", "mstr_author", "W/`dcid`='" . $r['author'] . "'");
?>
<table class="stable2" cellspacing="0" cellpadding="5px" width="240px" style="margin:auto;margin-top:10px">
<tr valign="top" style="height:110px">
<td width="60px">
<img src="<?php
echo IMGC . ($r['cover'] == '' ? "nocover.jpg" : $r['cover']);
?>
" width="60px"/>
</td>
<td style="padding-left:10px">
<div style="font-size:16px"><b><?php
echo str_replace("\\'", "'", $r['title']);
?>
</b></div>
<div>by <a class="linkl11" style="font:12px 'Segoe UI',Verdana,Arial" href="<?php
echo RLNK;
?>
book.php?get=author&getid=<?php
<?php
$bcode = gpost('barcode');
$cid = gpost('bookid');
$info = gpost('info');
//$r=dbSFA("*","book","W/`dcid`='$cid' OR barcode='$bcode' LIMIT 0,1");
$b = dbSFA("*", "book", "W/`dcid`='{$cid}' OR barcode='{$bcode}' LIMIT 0,1");
$c = dbSFA("*", "catalog", "W/`dcid`='" . $b['catalog'] . "' LIMIT 0,1");
$m = mysql_fetch_array(mysql_query("SELECT * FROM " . DB_HRD . " WHERE `nip`='" . $r['member'] . "' LIMIT 0,1"));
$author = stripslashes(dbFetch("name", "mstr_author", "W/`dcid`='" . $c['author'] . "'"));
$publisher = dbFetch("name", "mstr_publisher", "W/`dcid`='" . $c['publisher'] . "'");
$cla = dbSFA("name,code", "mstr_class", "W/`dcid`='" . $c['class'] . "' LIMIT 0,1");
// Form dimension
$fwidth = 400;
$lwidth = 100;
$iTextFw = "width:" . ($fwidth - $lwidth - 16) . "px";
?>
<table cellspacing="0" cellpadding="0" width="100%"><tr><td id="fformt" align="center" style="padding-top:115px">
<div id="fformbox" class="fformbox" style="width:<?php
echo $fwidth + 20;
?>
px;overflow:hidden">
<div class="sfont" style="padding:12px;text-align:left;color:#646464;font-size:15px">
<?php
echo $info != '' ? $info : "Book Information";
?>
<!--span style="font-size:11px;color:<?php
echo CLGREY;
?>
"> : <?php
echo $info;
<?php
$opt = gpost('opt');
if ($opt == 'avlist') {
require_once VWDIR . 'b_loan_book.php';
} else {
if ($opt == 'getbook') {
$barcode = gpost('code');
$t = mysql_query("SELECT * FROM book WHERE barcode='{$barcode}'");
if (mysql_num_rows($t) > 0) {
$r = dbFAx($t);
$ct = dbSFA("*", "catalog", "W/dcid='" . $r['catalog'] . "'");
$ttile = '<b>"' . str_replace("\\", "", $ct['title']) . '"</b>';
?>
<td width="400px">
<div style="float:left">
<img src="<?php
echo IMGC . ($ct['cover'] == '' ? "nocover.jpg" : $ct['cover']);
?>
" width="50px"/>
</div>
<div style="float:left;margin-left:10px">
<div style="margin-bottom:4px;line-height:150%"><?php
echo $ttile;
?>
<br/> by <?php
echo dbFetch("name", "mstr_author", "W/dcid='" . $ct['author'] . "'");
?>
</div>
<div> ID number: <strong><?php
echo $r['nid'];
} else {
if ($opt == 'af') {
$fform = new fform($fmod, 'af', $cid, 'Cari item');
$fform->reg['title_af'] = '<idata>';
$fform->reg['btnlabel_a_y'] = 'Pilih yg ditandai';
$fform->reg['btnlabel_a_n'] = 'Batal';
$fform->dimension(500);
$fform->ptop = 20;
$fform->globalkey = '0';
$fform->head('Pilih Siswa');
echo '<tr><td><div id="box_siswa_pendataan_kelas_list">';
require_once APPDIR . 'siswa_pendataan_kelas_list_get.php';
echo '</div></td></tr>';
$fform->foot();
} else {
if ($opt == 'df') {
$fform = new fform($fmod, 'df', $cid);
$fform->reg['title_df'] = 'Keluarkan Siswa Dari Rombongan Belajar';
$fform->reg['btnlabel_u_n'] = 'Tidak';
$fform->reg['btnlabel_d_y'] = ' Ya ';
$fform->head();
$r = dbSFA("*", "aka_siswa_kelas", "W/replid='{$cid}'");
$r1 = dbSFA("nama,nis", "aka_siswa", "W/replid='" . $r['siswa'] . "'");
$fform->fc('Apakah anda yakin untuk mengeluarkan siswa ini dari kelas ' . kelas_name($r['kelas']) . '?');
$fform->fr('Nama', '<b>' . $r1['nama'] . '</b>');
$fform->fr('NIS', '<b>' . $r1['nis'] . '</b>');
$fform->foot();
}
}
}
}
function EmpGetCStatus($a)
{
$r = dbSFA("*", "emp_status", "W/empid='{$a}' AND active='Y'");
return $r;
}
$inp['urut']=buku_getlasturut()+1;
$q=dbInsert($dbtable,$inp);
}
//log_print($_SESSION['libdb_dbIsert']);
}
else if($opt=='u') { // edit
$q=dbUpdate($dbtable,$inp,"replid='$cid'");
}
else if($opt=='d'){ // delete
$q=dbDel($dbtable,"replid='$cid'");
$q=dbDel("pus_peminjaman","buku='$cid'");
}
$fform->notif($q);
} else {
if($opt=='uf'||$opt=='df'){ // Prepocessing form
$r=dbSFA("*",$dbtable,"W/replid='$cid'");
$tk=mysql_query("SELECT judul,klasifikasi,pengarang FROM pus_katalog WHERE replid='".$r['katalog']."'");
$rk=mysql_fetch_array($tk);
$lok=$r['lokasi'];
$sat=$r['satuan'];
$tingb=$r['tingkatbuku'];
$lokasi=lokasi_r($lok);
$satuan=satuan_r($sat);
$tingkatbuku=tingkatbuku_r($tingb);
} else {
$lok=gpost('lokasi');
$sat='IDR';
$tingb=0;
<?php
require_once MODDIR . 'masterdb.php';
require_once MODDIR . 'control.php';
$lbc = dbFetch("barcode", "book", "O/barcode DESC");
if ($lbc == '') {
$lbc = 1;
} else {
$lbc = intval($lbc) + 1;
}
$mstr_shelf = array();
$ts = dbSel("dcid,name", "mstr_shelf", "O/ dcid");
while ($l = dbFA($ts)) {
$mstr_shelf[$l['dcid']] = $l['name'];
}
$cla = dbSFA("name,code", "mstr_class", "W/dcid='" . $r['class'] . "'");
$txtWidth = "width:200px";
if (!empty($f['callnumber'])) {
$callnum = $f['callnumber'];
} else {
$callnum = $r['classcode'] . " " . dbFetch("prefix", "mstr_author", "W/dcid='" . $r['author'] . "'") . " " . strtolower(substr(preg_replace("/(\"|\\')/", "", $r['title']), 0, 1));
}
$f['nid'] = "0/" . dbFetch("val", "mstr_setting", "W/dcid='4'");
?>
<div class="hl1" style="margin-top:20px">Add book to new catalog:</div>
<input type="hidden" id="dcid" name="dcid" value="<?php
echo $f['dcid'];
?>
" />
<input type="hidden" id="catalog" name="catalog" value="<?php
echo $r['dcid'];
} else {
if ($opt == 'd') {
// delete
$t = mysql_query("SELECT pegawai FROM aka_guru WHERE replid='{$cid}'");
$r = mysql_fetch_array($t);
$q = dbDel($dbtable, "replid='{$cid}'");
$q &= dbDel("admin", "pegawai='" . $r['pegawai'] . "'");
}
}
}
$fform->notif($q);
} else {
// form process
if ($opt == 'uf' || $opt == 'df') {
// db operation for form : update , delete
$r = dbSFA("*", $dbtable, "W/replid='{$cid}'");
$r['departemen'] = gpost('departemen');
$s = 'SELECT * FROM hrd_karyawan WHERE id=' . $r['pegawai'] . ' LIMIT 0,1';
// var_dump($s);exit();
$q = mysql_query($s);
// $q=mysql_query("SELECT * FROM hrd_pegawai WHERE replid='".$r['pegawai']."' LIMIT 0,1");
if (mysql_num_rows($q) > 0) {
$h = mysql_fetch_array($q);
$r['nama'] = $h['nama'];
}
} else {
// db operation for form : add
$r = app_form_gpost('departemen', 'tahunajaran', 'pegawai', 'pelajaran', 'aktif', 'keterangan');
$r['pelajaran'] = gpost('spelajaran');
$r['aktif'] = '1';
}
$dbtable = "aka_siswa";
$q = dbDel($dbtable, "replid='{$idsiswa}'");
if ($q) {
dbUpdate("psb_calonsiswa", array('idsiswa' => 0, 'kelas' => 0), "replid='{$cid}'");
dbDel($dbtable . '_ayah', "siswa='{$idsiswa}'");
dbDel($dbtable . '_ibu', "siswa='{$idsiswa}'");
dbDel($dbtable . '_keluarga', "siswa='{$idsiswa}'");
dbDel($dbtable . '_kontakdarurat', "siswa='{$idsiswa}'");
dbDel($dbtable . '_saudara', "siswa='{$idsiswa}'");
}
}
}
}
$fform->notif($q);
} else {
$r = dbSFA("replid,nama,status,nopendaftaran,noformulir", $dbtable, "W/replid='{$cid}'");
//$fform->dimension(350,100);
if ($r['status'] == '1') {
$fform->reg['title_uf'] = 'Batalkan Penerimaan Siswa';
$fform->reg['btnlabel_u_y'] = ' Ya ';
$fform->reg['btnlabel_u_n'] = 'Tidak';
} else {
$fform->reg['title_uf'] = 'Penerimaan Calon Siswa';
//$this->reg['btnlabel_u_y']='Simpan';
}
if ($r['status'] != '0') {
$fform->dimension(400);
}
if ($r['status'] == '0') {
$fform->ptop = 50;
}
