public function matapelajaran()
{
$klslevel = isset($_GET['klslevel']) ? addslashes($_GET['klslevel']) : 1;
//$kls = new Kelas();
//$kls->getByID($id);
$mp = new Matapelajaran();
$mp_id = isset($_GET['mp_id']) ? addslashes($_GET['mp_id']) : die('MP ID empty');
$mp->getByID($mp_id);
//get quizes
$quiz = new Quiz();
$whereClause = "quiz_guru_id = guru_id AND quiz_mp_id = '{$mp_id}' AND quiz_tingkatan = '{$klslevel}' ORDER BY quiz_create_date DESC";
$arrTables = array("Guru");
$arrQuiz = $quiz->getWhereFromMultipleTable($whereClause, $arrTables);
//pr($arrQuiz);
//get topicmaps
$tm = new Topicmap();
$whereClause = "tm_guru_id = guru_id AND tm_mp_id = '{$mp_id}' AND tm_kelas_tingkatan = '{$klslevel}' ORDER BY tm_updatedate DESC";
$arrTables = array("Guru");
$arrTM = $tm->getWhereFromMultipleTable($whereClause, $arrTables);
//pr($arrTM);
$return["mp"] = $mp;
$return['kelas'] = $kls;
$return['webClass'] = __CLASS__;
$return['method'] = __FUNCTION__;
$return['klslevel'] = $klslevel;
$return['arrQuiz'] = $arrQuiz;
$return['arrTM'] = $arrTM;
Mold::both("elearning/mp_profile", $return);
//pr($mp);
}
public function insertNilai()
{
//ambil tahun ajaran utk absensinya
$ta = TahunAjaran::ta();
$id = isset($_GET['klsid']) ? addslashes($_GET['klsid']) : Kelas::getFirstKelasID();
$kls = new Kelas();
$kls->getByID($id);
$mp_id = isset($_GET['mp_id']) ? addslashes($_GET['mp_id']) : Matapelajaran::getFirstMPID();
$mp = new Matapelajaran();
$mp->getByID($mp_id);
// utk insert ke db
$cmd = $_GET['cmd'];
$murid_id = $_GET['murid_id'];
$matapelajaranID = $_GET['matapelajaranID'];
$kelas_id = $_GET['kelas_id'];
$nilaiUjian = $_GET['nilaiUjian'];
$tglUjian = $_GET['tglUjian'];
$jenisUjian = $_GET['jenisUjian'];
//amnbil murid dikelas
$murid = new Murid();
$arrOfMurid = $murid->getMuridDiKelas($kls, $ta);
$nilai = new Nilai($ta, $arrOfMurid, $mp_id, $id);
if ($cmd == "insert") {
$nilai->insertTanggalUjian($murid_id, $matapelajaranID, $nilaiUjian, $tglUjian, "Daily", $ta, $kelas_id);
$_GET['cmd'] = "";
Mold::both("studentsetup/insertnilai", $return);
} else {
$return = $nilai->getNilaiKelasSortNachDatum();
$return['webClass'] = __CLASS__;
$return['method'] = __FUNCTION__;
$return['ta'] = $ta;
$return['kls'] = $kls;
$return['mp'] = $mp;
$return['murid'] = $arrOfMurid;
$return['nilai'] = $nilai;
Mold::both("studentsetup/insertnilai", $return);
}
}
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 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);
}
public function getMatapelajaran($arrOfJadwalMP)
{
foreach ($arrOfJadwalMP as $obj) {
if (Matapelajaran::istMPResmi($obj->jw_type)) {
$mp_singkatan = MatapelajaranResmi::getMatapelajaranSingkatan($obj->jw_mp_id);
} else {
$mp_singkatan = MatapelajaranTidakResmi::getMatapelajaranname($obj->jw_mp_id);
}
//echo $mp_singkatan . "<br>";
}
return $arrOfJadwalMP;
}
public function MyGrad()
{
$ta = TahunAjaran::ta();
$murid = new Murid();
$murid->default_read_coloms = "*";
$murid->getByAccountID(Account::getMyID());
$mp_id = isset($_GET['mp_id']) ? addslashes($_GET['mp_id']) : Matapelajaran::getFirstMPID();
$mp = new Matapelajaran();
$mp->getByID($mp_id);
$myNilai = new Nilai($ta, $murid, $mp_id, $murid->murid_tingkatan);
$return = $myNilai->getMyNilai();
$return['webClass'] = __CLASS__;
$return['method'] = __FUNCTION__;
$return['ta'] = $ta;
$return['mp'] = $mp;
$return['murid'] = $arrOfMurid;
$return['nilai'] = $myNilai;
// pr($return);
Mold::both("murid/mygrad", $return);
}
