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