public function getMuridWithoutKelas($tingkatan)
{
if ($tingkatan > 0) {
$acc = new Account();
$kls = new Kelas();
global $db;
/*$q = "SELECT admin_nama_depan,admin_id,murid_id,admin_foto FROM {$this->table_murid_kelas},{$this->table_name},{$acc->table_name} WHERE mk_ta_id = '$ta' AND mk_kelas_id = '$klsid' AND account_id = admin_id AND mk_murid_id = murid_id AND murid_aktiv = '1' ORDER BY mk_no_urut ASC";
$q = "SELECT t1.nama_depan,t1.murid_id,t1.foto
FROM {$this->table_name} t1,{$kls->table_name} t3
LEFT JOIN {$this->table_murid_kelas} t2 ON t2.mk_murid_id = t1.murid_id
WHERE t2.mk_kelas_id = t3.kelas_id AND t t2.mk_murid_id IS NULL AND t";
*/
$q = "SELECT admin_nama_depan,admin_id,murid_id,admin_foto,murid_tingkatan\n FROM {$this->table_name},{$acc->table_name}\n WHERE account_id = admin_id AND murid_tingkatan = '{$tingkatan}' AND murid_aktiv = '1' AND murid_id NOT IN (SELECT mk_murid_id FROM {$this->table_murid_kelas}) ORDER BY admin_nama_depan ASC";
$muridkelas = $db->query($q, 2);
$newMurid = array();
foreach ($muridkelas as $databasemurid) {
$m = new Murid();
$m->fill(toRow($databasemurid));
$newMurid[] = $m;
}
return $newMurid;
} else {
die('getMuridWithoutKelas butuh tingkatan');
}
}
