public function totalsession() { //load ta $ta = TahunAjaran::ta(); //load all mp aktiv $guru = new Guru(); $arrGuru = $guru->getWhere("guru_aktiv = 1 ORDER BY nama_depan ASC", "nama_depan,guru_id,account_id,foto,guru_color"); //load mj $arrMj = $guru->getTableMengajarFull($ta); //getHomeroom $arrHr = $guru->getHomeroomFromTa($ta); $totalGuru = array(); $detailMJ = array(); $hrPerGuru = array(); foreach ($arrGuru as $gr) { if (!isset($totalGuru[$gr->guru_id])) { $totalGuru[$gr->guru_id] = 0; } foreach ($arrMj as $mj) { if ($gr->guru_id == $mj->guru_id) { $totalGuru[$gr->guru_id] += $mj->mj_jam; $detailMJ[$gr->guru_id][] = $mj; } } foreach ($arrHr as $hr) { if ($gr->guru_id == $hr->guru_id) { $hrPerGuru[$gr->guru_id] = $hr; } } } //pr($arrHr); //pr($arrMj); //pr($arrGuru); $return['ta'] = $ta; $return['webClass'] = __CLASS__; $return['method'] = __FUNCTION__; $return['totalGuru'] = $totalGuru; $return['detailMJ'] = $detailMJ; $return['hrPerGuru'] = $hrPerGuru; $return['arrHr'] = $arrHr; $return['arrGuru'] = $arrGuru; $return['arrMj'] = $arrMj; Mold::both("schoolsetup/totalsession", $return); }