public function compose() { $kelas = new Kelas(); $arrKelas = $kelas->getWhere("kelas_aktiv = 1 ORDER BY kelas_id ASC", "kelas_id,kelas_name"); $guru = new Guru(); $arrGuru = $guru->getWhere("guru_aktiv = 1 ORDER BY nama_depan ASC", "guru_id,account_id,nama_depan"); $supervisor = new Supervisor(); $arrSupervisor = $supervisor->getWhere("supervisor_aktiv = 1 ORDER BY nama_depan ASC", "supervisor_id,account_id,nama_depan"); $tatausaha = new Tatausaha(); $arrTU = $tatausaha->getWhere("tu_aktiv = 1 ORDER BY nama_depan ASC", "tu_aktiv,account_id,nama_depan"); $admin = new Admin(); $arrAdmin = $admin->getWhere("sys_aktiv = 1 ORDER BY nama_depan ASC", "sys_id,account_id,nama_depan"); $t = time(); $return['arrTU'] = $arrTU; $return['arrSupervisor'] = $arrSupervisor; $return['arrAdmin'] = $arrAdmin; $return['arrGuru'] = $arrGuru; $return['arrKelas'] = $arrKelas; $return['method'] = __FUNCTION__; $return['webClass'] = __CLASS__; $return['byID'] = 0; Mold::both("inbox/compose", $return); }
public static function kelasSelector($kelasActual, $urlOnChange) { $t = time(); $kelas = new Kelas(); $arr = $kelas->getWhere("kelas_aktiv=1 ORDER BY kelas_tingkatan ASC, kelas_name ASC", "kelas_id,kelas_name"); //pr($arr); ?> <select id="selectkelas_<?php echo $t; ?> " class="form-control"> <?php foreach ($arr as $n => $kls) { if ($kelasActual->kelas_id == $kls->kelas_id) { $selected = "selected"; } else { $selected = ""; } ?> <option value="<?php echo $kls->kelas_id; ?> " <?php echo $selected; ?> ><?php echo $kls->kelas_name; ?> </option> <?php } ?> </select> <script type="text/javascript"> $("#selectkelas_<?php echo $t; ?> ").change(function () { var slc = $("#selectkelas_<?php echo $t; ?> ").val(); openLw(window.selected_page, "<?php echo $urlOnChange; ?> &klsid=" + 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); }