public static function subjectSelector($subjectActual, $urlOnChange)
{
$t = time();
$matapelajaran = new Matapelajaran();
$sujectValue = $matapelajaran->getWhere("mp_aktiv=1 ORDER BY mp_name ASC", "mp_id, mp_name, mp_singkatan");
?>
<select id="selectSubject_<?php
echo t;
?>
" class="form-control">
<?php
foreach ($sujectValue as $n => $mp) {
if ($subjectActual->mp_id == $mp->mp_id) {
$selected = "selected";
} else {
$selected = "";
}
?>
<option value="<?php
echo $mp->mp_id;
?>
"<?php
echo $selected;
?>
><?php
echo $mp->mp_name;
?>
</option>
<?php
}
?>
</select>
<script>
$("#selectSubject_<?php
echo t;
?>
").change(function () {
var slc = $("#selectSubject_<?php
echo t;
?>
").val();
openLw(window.selected_page, "<?php
echo $urlOnChange;
?>
&mp_id=" + slc, "fade");
});
</script>
<?php
}
public function getJadwalMPSelector()
{
$mp_id = isset($_GET['mp_id']) ? addslashes($_GET['mp_id']) : die('mp_id empty');
$mp_type = isset($_GET['mp_type']) ? addslashes($_GET['mp_type']) : die('mp_type empty');
$mp = new Matapelajaran();
$arrMP = $mp->getWhere("mp_id>0");
$mptr = new MatapelajaranTidakResmi();
$arrMPTR = $mptr->getWhere("mptr_id>0");
//pr($_GET);
$t = time();
// untuk query langsung
$kls_id = isset($_GET['kls_id']) ? addslashes($_GET['kls_id']) : die('kls_id empty');
$slotID = isset($_GET['slotID']) ? addslashes($_GET['slotID']) : die('slotID empty');
$day = isset($_GET['day']) ? addslashes($_GET['day']) : die('day empty');
$ta = TahunAjaran::ta();
//elroy : ini di query langsung...
$id = $day . "_" . $slotID . "_" . $kls_id . "_" . $ta;
//elroy : ini di query langsung...
$id = $day . "_" . $slotID . "_" . $kls_id . "_" . $ta;
global $db;
$q = "SELECT * FROM ry_sekolah__jadwalmp WHERE jw_id = '{$id}'";
$jd = $db->query($q, 1);
?>
<span id="spanselectmp<?php
echo $t;
?>
">
<select id="selectmp<?php
echo $t;
?>
">
<?php
foreach ($arrMP as $mp) {
$selected = "";
if ($jd->jw_type == "mp") {
if ($mp->mp_id == $jd->jw_mp_id) {
$selected = "selected";
}
}
?>
<option value="mp_<?php
echo $mp->mp_id;
?>
" <?php
echo $selected;
?>
><?php
echo $mp->mp_name;
?>
</option>
<?php
}
?>
<?php
foreach ($arrMPTR as $mptr) {
$selected = "";
if ($jd->jw_type == "mptr") {
if ($mptr->mptr_id == $jd->jw_mp_id) {
$selected = "selected";
}
}
?>
<option value="mptr_<?php
echo $mptr->mptr_id;
?>
" <?php
echo $selected;
?>
><?php
echo $mptr->mptr_desr;
?>
</option>
<?php
}
?>
</select>
</span>
<script>
$("#selectmp<?php
echo $t;
?>
").change(function () {
var ctr = $("#selectmp<?php
echo $t;
?>
").val();
$.get('<?php
echo _SPPATH;
?>
StudentSetup/setJadwalMP?mp=' + ctr + '&kls_id=<?php
echo $_GET['kls_id'];
?>
&slotID=<?php
echo $_GET['slotID'];
?>
&day=<?php
echo $_GET['day'];
?>
',
function (data) {
//alert( data );
});
$("#spanselectmp<?php
echo $t;
?>
").html($("#selectmp<?php
echo $t;
?>
option:selected").text());
});
</script>
<?php
//exit();
}
public function tablemengajar()
{
//load ta
$ta = TahunAjaran::ta();
//command switch
$cmd = isset($_GET['cmd']) ? $_GET['cmd'] : "read";
//edit mj
if ($cmd == "edit") {
$guru = new Guru();
$return = $guru->loadMJGuruSelection($ta);
$return['method'] = __FUNCTION__;
$return['webClass'] = __CLASS__;
//pr($return);
//die();
Mold::both("schoolsetup/tablemengajar_selection", $return);
exit;
}
//submit mj
if ($cmd == "editSubmit") {
$guru = new Guru();
$json = $guru->setMengajar();
die(json_encode($json));
}
// edit homeroom
if ($cmd == "editHr") {
$guru = new Guru();
$kelas_id = isset($_GET['kelas_id']) ? $_GET['kelas_id'] : 0;
if ($kelas_id == 0) {
die('kelas id must exists');
}
$return['hr'] = $guru->getHomeroomFromKelas($ta, $kelas_id);
//load guru aktiv
$guru = new Guru();
$arrGuru = $guru->getWhere("guru_aktiv = 1 ORDER BY nama_depan ASC", "guru_id,nama_depan");
$return['hrid'] = $ta . "_" . $kelas_id;
$return['arrGuru'] = $arrGuru;
$return['method'] = __FUNCTION__;
$return['webClass'] = __CLASS__;
$return['loadid'] = time();
Mold::both("schoolsetup/tablemengajar_homeroomselect", $return);
exit;
}
//submit hr
if ($cmd == "editSubmitHr") {
$guru = new Guru();
$json = $guru->setHomeroom();
die(json_encode($json));
}
//load all mp aktiv
$mp = new Matapelajaran();
$arrMp = $mp->getWhere("mp_aktiv = 1 ORDER BY mp_group ASC,mp_singkatan ASC", "mp_id,mp_name,mp_singkatan,mp_group");
//load all kelas aktiv
$kls = new Kelas();
$arrKelas = $kls->getWhere("kelas_aktiv = 1 ORDER BY kelas_name ASC,kelas_tingkatan ASC", "kelas_id,kelas_name,kelas_tingkatan");
//pr($arrMp);pr($arrKelas);
//load guru mengajar
$guru = new Guru();
$arrMj = $guru->getTableMengajar($ta);
//bikin array yang pas
$group = "";
$newArr = array();
$newArrID = array();
$newArrObject = array();
$totalPerBag = array();
$totalPerKelas = array();
$hrPerKelas = array();
foreach ($arrMp as $mps) {
if ($group != $mps->mp_group) {
$group = $mps->mp_group;
}
foreach ($arrKelas as $kl) {
//get homeroom
if (!isset($hrPerKelas[$kl->kelas_name])) {
$hrPerKelas[$kl->kelas_name] = $guru->getHomeroomFromKelas($ta, $kl->kelas_id);
}
if (!isset($totalPerBag[$group][$kl->kelas_name])) {
$totalPerBag[$group][$kl->kelas_name] = 0;
}
if (!isset($totalPerKelas[$kl->kelas_name])) {
$totalPerKelas[$kl->kelas_name] = 0;
}
//masukan ke array
$newArr[$group][$mps->mp_name][$kl->kelas_name] = null;
//masukan id nya
$newArrID[$mps->mp_name] = $mps->mp_id;
$newArrID[$kl->kelas_name] = $kl->kelas_id;
//save objectnya di array
$newArrObject[$mps->mp_name] = $mps;
$newArrObject[$kl->kelas_name] = $kl;
foreach ($arrMj as $mj) {
if ($mps->mp_id == $mj->mj_mp_id && $kl->kelas_id == $mj->mj_kelas_id) {
$mj->mp_obj = $mps;
$mj->kelas_obj = $kl;
$newArr[$group][$mps->mp_name][$kl->kelas_name] = $mj;
$totalPerBag[$group][$kl->kelas_name] += $mj->mj_jam;
$totalPerKelas[$kl->kelas_name] += $mj->mj_jam;
}
}
}
//$newArr[$group][$mps->mp_name]
}
//ksort($newArr);
//pr($newArr);
//pr($arrMj);
//pasang ke table
$return['ta'] = $ta;
$return['webClass'] = __CLASS__;
$return['method'] = __FUNCTION__;
//yang array taruh bawah
$return['mp'] = $arrMp;
$return['kelas'] = $arrKelas;
$return['arrMj'] = $arrMj;
$return['sortArrMj'] = $newArr;
$return['totalPerGroup'] = $totalPerBag;
$return['totalPerKelas'] = $totalPerKelas;
$return['hrPerKelas'] = $hrPerKelas;
$return['arrIDs'] = $newArrID;
$return['arrObjs'] = $newArrObject;
Mold::both("schoolsetup/tablemengajar", $return);
}
