public function loadMJGuruSelection($ta) { $guru_id = addslashes($_GET["guru_id"]); $mp_id = addslashes($_GET["mp_id"]); $kelas_id = addslashes($_GET["kelas_id"]); $load = addslashes($_GET["load"]); //load guru aktiv $guru = new Guru(); $arrGuru = $guru->getWhere("guru_aktiv = 1 ORDER BY nama_depan ASC", "guru_id,nama_depan"); //define the ID's' $id = Guru::createMjId($mp_id, $kelas_id, $ta); $loadid = time() . "__" . $mp_id . "_" . $kelas_id; if ($load) { global $db; $q = "SELECT * FROM {$this->table_mengajar} WHERE mengajar_id = '{$id}'"; $mj = $db->query($q, 1); $return['mj'] = $mj; } //create returns $return['mj_id'] = $id; $return['loadid'] = $loadid; $return['arrGuru'] = $arrGuru; $return['posts'] = $_GET; return $return; }
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 function browseStaff() { $guru = new Guru(); $arrGuru = $guru->getWhere("guru_aktiv = 1 ORDER BY nama_depan ASC", "guru_id,account_id,nama_depan,foto"); $supervisor = new Supervisor(); $arrSupervisor = $supervisor->getWhere("supervisor_aktiv = 1 ORDER BY nama_depan ASC", "supervisor_id,account_id,nama_depan,foto"); $tatausaha = new Tatausaha(); $arrTU = $tatausaha->getWhere("tu_aktiv = 1 ORDER BY nama_depan ASC", "tu_aktiv,account_id,nama_depan,foto"); $admin = new Admin(); $arrAdmin = $admin->getWhere("sys_aktiv = 1 ORDER BY nama_depan ASC", "sys_id,account_id,nama_depan,foto"); $t = time(); $return['arrTU'] = $arrTU; $return['arrSupervisor'] = $arrSupervisor; $return['arrAdmin'] = $arrAdmin; $return['arrGuru'] = $arrGuru; $return['method'] = __FUNCTION__; $return['webClass'] = __CLASS__; Mold::both("leap/browseStaff", $return); }