<?php
$mtitle = "User";
$opt = gpost('opt');
$cid = gpost('cid');
$name = gpost('name');
$alias = gpost('alias');
$password0 = gpost('password0');
$password1 = gpost('password1');
$password2 = gpost('password2');
if ($opt == 'a') {
if ($password1 == $password2) {
$password = md5($password1);
$n = dbSRow("mstr_user", "W/name='{$name}'");
if ($n == 0) {
dbInsert("mstr_user", array('name' => $name, 'alias' => $alias, 'password' => $password));
}
}
require_once APPDIR . 'm_user_table.php';
} else {
if ($opt == 'u') {
$r = dbSFA("*", "mstr_user", "W/dcid='{$cid}'");
if ($password0 != '') {
$password = md5($password0);
if ($r['password'] = $password && $password1 == $password2) {
$password = md5($password1);
dbUpdate("mstr_user", array('alias' => $alias, 'password' => $password), "dcid='{$cid}'");
}
} else {
dbUpdate("mstr_user", array('alias' => $alias), "dcid='{$cid}'");
}
function dbRow($tbl)
{
return dbSRow($tbl, "");
}
<div style="padding-left:5px;margin-top:15px">
<a id="pf_smore" class="linkl11" href="javascript:void(0)" onclick="showmore()">Tampilkan data lainnya...</a>
</div>
<?php
?>
</td>
<td align="right" width="180px">
<div id="pf_summary" style="padding-top:10px">
<?php
require_once 'apps/pf_summary.php';
?>
</div>
</td>
<td width="165px" align="center" style="padding-top:10px">
<?php
$np = dbSRow("jbssdm.empapp_photo", "W/empappid='" . $r['dcid'] . "'");
if ($np > 0) {
?>
<div id="pf_photo"><img src="<?php
echo RLNK;
?>
apps/pf_photo.php?id=<?php
echo $r['dcid'];
?>
"/></div><br/>
<button id="pfp_btn" class="btn" title="Ganti foto karyawan" onclick="open_uform()">
<div id="pfp_lbl" style="background:url('<?php
echo IMGR;
?>
bi_photo.png') no-repeat;padding-left:16px">Ganti Foto</div>
</button><br/>
} else {
$PSBar->end();
hiddenval('tingkat', $ting);
tingkat_warn(0, 'float:left');
$PSBar->pass = false;
}
}
$PSBar->end();
if ($PSBar->pass) {
$xtable->btnbar_f('add');
if ($xtable->ndata > 0) {
// Table head
$xtable->head('Nama Kelas', 'Wali', 'Kapasitas', 'Terisi', 'Keterangan');
while ($r = mysql_fetch_array($t)) {
$xtable->row_begin();
$xtable->td($r['kelas'], 200);
$xtable->td(dbFetch("nama", "hrd_pegawai", "W/replid='" . dbFetch("pegawai", "aka_guru", "W/replid='" . $r['wali'] . "'") . "'"), 200);
$xtable->td($r['kapasitas'], 150);
$xtable->td(dbSRow("aka_siswa_kelas", "W/kelas='" . $r['replid'] . "'"), 150);
$xtable->td(nl2br($r['keterangan']));
$xtable->opt_ud($r['replid']);
$xtable->row_end();
}
$xtable->foot();
} else {
$xtable->nodata();
}
}
} else {
departemen_warn();
}
employee_edit.php?nid=<?php
echo $r['dcid'];
?>
&opt=show')">Show advanced information...</a>
</div>
</td>
<td align="right" width="180px">
<div id="tpf_summary" style="padding-top:10px">
<?php
require_once VWDIR . 'pf_summary.php';
?>
</div>
</td>
<td width="165px" align="center" style="padding-top:10px">
<?php
$np = dbSRow("emp_photo", "W/empid='" . $r['dcid'] . "'");
if ($np > 0) {
?>
<div id="pf_photo"><img src="<?php
echo RLNK;
?>
photo.php?id=<?php
echo $r['dcid'];
?>
"/></div><br/>
<button id="pfp_btn" class="btn" onclick="open_uform()">
<div id="pfp_lbl" style="background:url('<?php
echo IMGR;
?>
bi_photo.png') no-repeat;padding-left:16px">Change profile picture</div>
</button><br/>
<?php
function isAct($a, $l)
{
global $cview;
if ($a == $cview) {
return 'class="active" href="' . RLNK . $l . '"';
} else {
return 'href="' . RLNK . $l . '"';
}
}
$nbook = dbSRow("catalog");
?>
<style type="text/css">
#leftcolumn{
width: 200px; /*Width of left column*/
}
.innertube{
margin: 10px; /*Margins for inner DIV inside each column (to provide padding)*/
margin-top: 0;
}
.blueblock{
width: 180px;
padding: 0 0 1em 0;
font:12 px'Segoe UI','Trebuchet MS', 'Lucida Grande', Arial, sans-serif;
color: #303942;
}
* html .blueblock{ /*IE 6 only */
width: 147px; /*Box model bug: 180px minus all left and right paddings for .blueblock */
}
.blueblock ul{
appmod_use('aka/pelajaran');
// form Module
$fmod = 'nilairapor_komen';
$dbtable = 'aka_komennilai';
$fform = new fform($fmod, $opt, $cid, 'Keterangan penilaian');
$inp = app_form_gpost('komen');
$pel = gpost('pelajaran');
if ($opt == 'a' || $opt == 'u' || $opt == 'd') {
$q = false;
if ($opt == 'a') {
// add
//if($q) echo nl2br($inp['komen']);
} else {
if ($opt == 'u') {
// edit
$n = dbSRow($dbtable, "W/siswa='{$cid}' AND pelajaran='{$pel}'");
if ($n == 0) {
$inp['siswa'] = $cid;
$inp['pelajaran'] = $pel;
$q = dbInsert($dbtable, $inp);
} else {
$q = dbUpdate($dbtable, $inp, "siswa='{$cid}' AND pelajaran='{$pel}'");
}
if ($q) {
echo nl2br($inp['komen']);
}
} else {
if ($opt == 'd') {
// delete
$q = dbDel($dbtable, "replid='{$cid}'");
}
}
}
}
$fform->notif($q);
} else {
if ($opt == 'uf' || $opt == 'df') {
// Prepocessing form
$r = dbSFA("*", $dbtable, "W/replid='{$cid}'");
} else {
$r['departemen'] = $inp['departemen'];
}
$fform->head();
if ($opt == 'af' || $opt == 'uf') {
require_once MODDIR . 'control.php';
// Add or Edit form
$fform->fl('Departemen', departemen_name($r['departemen']));
$fform->fi('Angkatan', iText('angkatan', $r['angkatan'], 'width:60px'));
$fform->fa('Keterangan', iTextarea('keterangan', $r['keterangan'], $fform->rwidths, 3));
} else {
if ($opt == 'df') {
// Delete form
if (dbSRow("aka_siswa", "W/angkatan='{$cid}'") > 0) {
$fform->reg['dlg_del'] = '<idata> masih digunakan. Apakah anda yakin untuk menghapus <idata> <data>?';
$fform->dlg_delw($r[$fmod], 'Data-data kelas dan siswa yang termasuk dalam tingkat ini juga akan dihapus. Data yang sudah dihapus tidak dapat dikembalikan.');
} else {
$fform->dlg_del($r[$fmod]);
}
}
}
$fform->foot();
}
} else {
$r = farray('kelas', 'tingkat', 'kapasitas', 'wali', 'keterangan');
$r['tahunajaran'] = gpost('tahunajaran');
$r['tingkat'] = gpost('tingkat');
$r['kapasitas'] = 1;
}
$fform->dimension(450, 100);
$fform->head();
if ($opt == 'af' || $opt == 'uf') {
require_once MODDIR . 'control.php';
// Add or Edit form
$fform->fl('Departemen', departemen_name(gpost('departemen')));
$fform->fl('Tahun ajaran', tahunajaran_name($r['tahunajaran']));
$fform->fl('Tingkat', tingkat_name($r['tingkat']));
$fform->fi('Nama kelas', iText($fmod, $r['kelas'], $fform->rwidths));
$fform->fi('Kapasitas', iText('kapasitas', $r['kapasitas'], 'width:40px;text-align:center') . ' siswa');
$fform->fi('Wali', app_form_getguru('wali', $r, 'kelas_setwali'));
$fform->fa('Keterangan', iTextarea('keterangan', $r['keterangan'], $fform->rwidths, 3));
} else {
if ($opt == 'df') {
// Delete form
if (dbSRow("aka_siswa", "W/kelas='{$cid}'") > 0) {
$fform->reg['dlg_del'] = '<idata> masih digunakan. Apakah anda yakin untuk menghapus <idata> <data>?';
$fform->dlg_delw($r[$fmod], 'Data-data siswa yang termasuk dalam kelas ini juga akan dihapus. Data yang sudah dihapus tidak dapat dikembalikan.');
} else {
$fform->dlg_del($r[$fmod]);
}
}
}
$fform->foot();
}
if ($PSBar->pass) {
if (count($penilaian) > 0) {
$PSBar->selection('Penilaian', iSelect('penilaian', $penilaian, $peni, $PSBar->selws, $fmod . "_get()"));
} else {
$PSBar->end();
hiddenval('penilaian', $peni);
echo '<div class="warnbox" style="float:left">Tidak ada data penilaian.</div>';
$PSBar->pass = false;
}
}
$PSBar->end();
if ($PSBar->pass) {
// Query
$t = siswa_db_bykelas($kls)->go();
while ($r = dbFA($t)) {
if (dbSRow("aka_daftarnilai", "W/penilaian='{$peni}' AND siswa='" . $r['replid'] . "'") == 0) {
dbInsert("aka_daftarnilai", array('penilaian' => $peni, 'siswa' => $r['replid']));
}
}
$db = new xdb("aka_daftarnilai", "*", "penilaian='{$peni}'");
$nlulus = 0;
$t = $db->go();
while ($r = dbFA($t)) {
if ($r['nilai'] >= $dpeni['kkm']) {
$nlulus++;
}
}
$db = siswa_db_bykelas($kls);
$db->field("aka_daftarnilai:nilai,keterangan as ketnilai", "IF(aka_daftarnilai.nilai < " . $dpeni['kkm'] . ", 1, 0) as tuntas");
$db->join("siswa", "aka_daftarnilai", "siswa");
$db->where_and("aka_daftarnilai.penilaian='{$peni}'");
}
$fform->notif($q);
} else {
if ($opt == 'uf' || $opt == 'df') {
// Prepocessing form
$r = dbSFA("*", $dbtable, "W/replid='{$cid}'");
} else {
$r = app_form_gpost('departemen', 'ruang', 'keterangan');
}
$fform->head();
if ($opt == 'af' || $opt == 'uf') {
require_once MODDIR . 'control.php';
// Add or Edit form
$fform->fl('Departemen', departemen_name($r['departemen']));
$fform->fi('Kode ruang', iText('kode', $r['nama'], 'width:60px'));
$fform->fi('Nama ruang', iText('nama', $r['nama'], $fform->rwidths));
$fform->fa('Keterangan', iTextarea('keterangan', $r['keterangan'], $fform->rwidths, 3));
} else {
if ($opt == 'df') {
// Delete form
if (dbSRow("aka_siswa", "W/ruang='{$cid}'") > 0) {
$fform->reg['dlg_del'] = '<idata> masih digunakan. Apakah anda yakin untuk menghapus <idata> <data>?';
$fform->dlg_delw($r[$fmod], 'Data-data kelas dan siswa yang termasuk dalam tingkat ini juga akan dihapus. Data yang sudah dihapus tidak dapat dikembalikan.');
} else {
$fform->dlg_del($r[$fmod]);
}
//$fform->dlg_del($r['nilai']);
}
}
$fform->foot();
}
<?php
$dcid = gpost('id');
$tmpimg = PHODIR . "ptmp.jpg";
$src = imagecreatefromjpeg($tmpimg);
list($width, $height) = getimagesize($tmpimg);
$tmp = imagecreatetruecolor($width, $height);
imagecopyresampled($tmp, $src, 0, 0, 0, 0, $width, $height, $width, $height);
$filename = PHODIR . "pp_" . $dcid . "_" . date("YmdHis") . ".jpg";
imagejpeg($tmp, $filename, 100);
imagedestroy($src);
imagedestroy($tmp);
$image = chunk_split(base64_encode(file_get_contents($tmpimg)));
$n = dbSRow("emp_photo", "W/empid='{$dcid}'");
if ($n > 0) {
$res = dbUpdate("emp_photo", array('photo' => $image), "empid='{$dcid}'");
$res = dbUpdate("employee", array('photo' => $filename), "empid='{$dcid}'");
} else {
$res = dbInsert("emp_photo", array('empid' => $dcid, 'photo' => $image));
}
?>
<img id="pp<?php
echo date("YmdHis");
?>
" src="<?php
echo RLNK;
?>
photo.php?id=<?php
echo $dcid;
?>
&arg=<?php
function kelas_jumlahsiswa($kls){
return dbSRow("aka_siswa_kelas","W/kelas='$kls'");
}
?>
</td>
<td width="130px"><?php
echo $mstr_author[$r['author']];
?>
</td>
<td width="120px"><?php
echo $mstr_publisher[$r['publisher']];
?>
</td>
<td width="80px" align="center">
<?php
$nbook = dbSRow("book", "W/`catalog`='" . $r['dcid'] . "'");
$abook = 0;
if ($nbook > 0) {
$abook = dbSRow("book", "W/`catalog`='" . $r['dcid'] . "' AND `available`='Y'");
echo $abook . " of " . $nbook;
} else {
echo "N/A";
}
?>
</td>
<td width="140px" align="center">
<button style="visibility:<?php
echo $abook > 0 ? "visible" : "hidden";
?>
" title="View books" class="find16" onclick="jumpTo('<?php
echo RLNK;
?>
bibliographic.php?tab=catalog&act=view&nid=<?php
echo $r['dcid'];
</tr></table>
</td></tr></table>
<center>
<table cellspacing="0" cellpadding="0"><tr height="45px">
<td><img src="<?php
echo IMGR;
?>
sumplus.png"/></td><td> <span style="color:#00c000;font:bold 11px Verdana,Tahoma">Add Training</span></td>
</tr></table>
</center>
</div>
</button>
</td></tr>
<tr><td>
<?php
$nrwrd = dbSRow("emp_reward", "W/empid='" . $r['dcid'] . "'");
?>
<button id="xsumfbtn4" class="pfnice" style="position:relative;overflow:hidden" onclick="switch_tab(4);E('pfb_4').scrollIntoView(true);pf_reward('af')">
<div id="sumfbtn4" style="width:170px;height:45px;position:absolute;top:0px">
<table cellspacing="0" cellpadding="0"><tr height="45px"><td style="padding-left:6px">
<table class="stable" cellspacing="0" cellpadding="0"><tr>
<td width="24px"><img src="<?php
echo IMGR;
?>
star.png"/></td>
<td id="sumf3"><b><?php
echo $nrwrd;
?>
Reward<?php
echo $nrwrd > 1 ? "s" : "";
?>
// Page Selection Bar
$PSBar = new PSBar_2();
$PSBar->begin();
$PSBar->selection_departemen($fmod, $dept);
if (count($proses) > 0) {
$PSBar->selection('Periode', iSelect('proses', $proses, $pros, "width:" . $PSBar->selw, $fmod . "_get()"));
} else {
$PSBar->end();
hiddenval('proses', $pros);
proses_warn();
exit;
}
$PSBar->end();
$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 class="tbltopbar" style="width:100%">
<div style="float:right;margin-left:10px;border:1px solid #01a8f7;height:4px;width:<?php
echo $barw;
?>
px;margin-right:4px;margin-top:10px;margin-bottom:4px">
<?php
$t1 = mysql_query("SELECT * FROM psb_kelompok WHERE proses='{$pros}'");
$k = 0;
while ($r1 = mysql_fetch_array($t1)) {
$n = mysql_num_rows(mysql_query("SELECT * FROM psb_calonsiswa WHERE kelompok='" . $r1['replid'] . "' AND status<>0"));
$w = intval($n * $barw / $kapasitas);
echo '<div style="float:left;background:' . $bcolor[$k++] . ';height:4px;width:' . $w . 'px"></div>';
}
?>
" <?php
echo $rh;
?>
>
<td width="*"><?php
echo src_replace($r['name']);
?>
</td>
<td width="120px"><?php
echo src_replace($r['nip']);
?>
</td>
<td width="120px" align="center">
<?php
echo dbSRow("loan", "W/member='" . $r['nip'] . "' AND status='1'");
?>
</td>
<td width="55px" align="left">
<?php
echo optionbtn_view("jumpTo('" . RLNK . "members.php?tab=staff&act=view&nid=" . $r['nip'] . "')", 1);
?>
</td>
</tr>
<?php
$k++;
}
$n++;
}
?>
</table>
?>
">
<td width="30px" align="center"><?php
echo ++$n;
?>
</td>
<td width="50px"><?php
echo src_replace($r['code']);
?>
</td>
<td width="*"><?php
echo src_replace($r['name']);
?>
</td>
<td width="100" align="center"><?php
echo dbSRow("book", "W/`shelf`='" . $r['dcid'] . "'");
?>
</td>
<td width="200"><?php
echo $r['description'];
?>
</td>
<td width="60px" align="center">
<button class="btnedit" title="Edit" onclick="b_shelf('df',<?php
echo $r['dcid'];
?>
)"></button>
<?php
if ($r['dcid'] != 1) {
?>
<button class="btndel" title="Delete" onclick="b_shelf('df',<?php
} else {
if ($opt == 'uf' || $opt == 'df') {
// Prepocessing form
$r = dbSFA("*", $dbtable, "W/replid='{$cid}'");
} else {
$r = farray('tingkat', 'tahunajaran', 'keterangan');
$r['departemen'] = gpost('departemen');
$r['tahunajaran'] = gpost('tahunajaran');
}
$fform->head();
if ($opt == 'af' || $opt == 'uf') {
require_once MODDIR . 'control.php';
// Add or Edit form
$fform->fl('Departemen', departemen_name($r['departemen']));
$fform->fl('Tahun ajaran', tahunajaran_name($r['tahunajaran']));
$fform->fi('Tingkat', iText('tingkat', $r['tingkat'], 'width:60px'));
$fform->fa('Keterangan', iTextarea('keterangan', $r['keterangan'], $fform->rwidths, 3));
} else {
if ($opt == 'df') {
// Delete form
if (dbSRow("aka_siswa", "W/tingkat='{$cid}'") > 0) {
$fform->reg['dlg_del'] = 'Tingkat masih digunakan. Apakah anda yakin untuk menghapus <idata> <data>?';
$fform->dlg_delw($r[$fmod], 'Data-data kelas dan siswa yang termasuk dalam tingkat ini juga akan dihapus. Data yang sudah dihapus tidak dapat dikembalikan.');
} else {
$fform->dlg_del($r[$fmod]);
}
//$fform->dlg_del($r['nilai']);
}
}
$fform->foot();
}
