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