<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; }