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