Japanese English

PHP 難読化コードの復元・デコード

Wordpress　等でのPHPのマルウェア・ウィルス・改ざんコードをデコードして難読化をオンラインで解除し、
元の読みやすいコードに戻し解読できます。

※すべての難読化コードを解除できるわけではございませんのでご理解とご了承をお願いいたします。

下記のコードを難読化解除しました

<?php /* ________________________________________ | GarudaCBT | | https://github.com/garudacbt/cbt | |________________________________________| */ class Rapor_model extends CI_Model { public function getKikdMapel($id, $id_tp, $id_smt) { $this->db->where("\151\x64\137\x6b\x69\153\144", $id)-...



難読化されたPHPコード

<?php
/*   ________________________________________
    |                 GarudaCBT              |
    |    https://github.com/garudacbt/cbt    |
    |________________________________________|
*/
 class Rapor_model extends CI_Model { public function getKikdMapel($id, $id_tp, $id_smt) { $this->db->where("\151\x64\137\x6b\x69\153\144", $id)->where("\x69\144\x5f\164\160", $id_tp)->where("\151\x64\137\163\x6d\164", $id_smt); return $this->db->get("\x72\141\160\x6f\162\137\153\151\x6b\144")->row(); } public function getKikdMapelKelas($id_mapel, $id_kelas, $id_tp, $id_smt) { $this->db->where("\x69\x64\x5f\x6d\141\160\x65\x6c\x5f\153\145\154\x61\163", $id_mapel . $id_kelas)->where("\151\x64\x5f\164\160", $id_tp)->where("\x69\144\137\163\155\164", $id_smt); return $this->db->get("\x72\141\x70\x6f\162\137\153\x69\153\x64")->result(); } public function getKkm($id) { $this->db->where("\151\x64\x5f\153\153\x6d", $id); return $this->db->get("\162\x61\x70\x6f\162\137\153\x6b\155")->row(); } public function getArrKkm($ids) { goto RweN6; OQn_h: return $ret; goto enUZT; RweN6: $this->db->where_in("\151\x64\137\153\153\x6d", $ids); goto l6kg_; EUo00: JjRfb: goto OQn_h; YLVpW: foreach ($result as $key => $row) { $ret[$row->id_mapel] = $row; w1vS4: } goto sp1Ik; sp1Ik: w2lgm: goto EUo00; JTS6i: if (!$result) { goto JjRfb; } goto YLVpW; l6kg_: $result = $this->db->get("\x72\x61\160\157\162\137\x6b\x6b\x6d")->result(); goto QycLw; QycLw: $ret = []; goto JTS6i; enUZT: } public function getRaporSetting($id_tp, $id_smt) { $this->db->where("\151\144\x5f\x74\160", $id_tp)->where("\151\144\137\x73\x6d\x74", $id_smt); return $this->db->get("\162\x61\x70\x6f\162\x5f\141\x64\x6d\151\156\137\x73\x65\x74\164\151\156\x67")->row(); } public function getDetailSiswa($id_kelas, $id_tp, $id_smt) { goto mN4Bb; aRF6c: return $this->db->get()->result(); goto Dj1EA; nlL1q: $this->db->order_by("\x62\56\156\x61\x6d\141", "\101\x53\x43"); goto aRF6c; pt2KU: $this->db->where("\141\56\x69\144\x5f\153\x65\154\141\x73", $id_kelas); goto K_L4u; K_L4u: $this->db->where("\x61\56\x69\144\137\x74\x70", $id_tp); goto ddv0d; ddv0d: $this->db->where("\141\56\x69\144\x5f\163\155\164", $id_smt); goto nlL1q; wPJ27: $this->db->select("\x61\56\52\x2c\40\142\56\x2a\x2c\x20\x63\56\52"); goto uK7U0; mZvyF: $this->db->join("\x6d\141\163\164\145\x72\137\x6b\145\x6c\x61\x73\40\x63", "\141\56\x69\x64\137\x6b\145\x6c\141\163\75\x63\56\x69\144\x5f\153\x65\154\141\x73"); goto pt2KU; mN4Bb: $this->db->query("\123\x45\x54\x20\123\x51\x4c\137\x42\x49\107\137\123\105\x4c\x45\x43\x54\123\x3d\x31"); goto wPJ27; RbjSq: $this->db->join("\155\x61\163\164\x65\162\137\x73\151\163\167\x61\40\x62", "\141\x2e\x69\x64\x5f\x73\151\163\x77\141\x3d\142\x2e\151\x64\137\x73\151\x73\x77\141"); goto mZvyF; uK7U0: $this->db->from("\x6b\x65\x6c\141\163\x5f\163\x69\163\x77\141\x20\141"); goto RbjSq; Dj1EA: } public function getDetailSiswaById($id_siswa, $id_tp, $id_smt) { goto OuGC8; lcONe: $this->db->where("\x61\56\151\x64\137\163\x69\163\167\141", $id_siswa); goto K0HnJ; IoFa3: $this->db->order_by("\x61\x2e\x6e\x61\155\141", "\x41\x53\103"); goto cfGOu; cfGOu: return $this->db->get()->row(); goto PaVHx; Z0HQD: $this->db->where("\x62\56\151\144\137\x73\x6d\x74", $id_smt); goto IoFa3; K0HnJ: $this->db->where("\142\56\x69\x64\x5f\x74\160", $id_tp); goto Z0HQD; p3rFi: $this->db->from("\155\141\163\x74\145\x72\137\x73\x69\x73\x77\141\40\x61"); goto FuL0T; HB5_1: $this->db->select("\141\56\x6e\141\x6d\x61\x2c\40\141\x2e\156\x69\x73\54\40\141\x2e\x6e\151\163\x6e\54\x20\143\x2e\x6e\141\155\141\x5f\153\x65\x6c\141\x73"); goto p3rFi; FuL0T: $this->db->join("\x6b\145\154\141\x73\137\x73\x69\x73\x77\x61\40\142", "\x61\x2e\151\144\x5f\x73\x69\163\167\x61\75\142\x2e\x69\x64\x5f\163\x69\x73\x77\x61"); goto oTdr3; OuGC8: $this->db->query("\x53\x45\x54\40\123\121\114\x5f\x42\111\107\x5f\123\105\114\x45\x43\124\x53\x3d\x31"); goto HB5_1; oTdr3: $this->db->join("\x6d\x61\163\164\145\162\137\x6b\145\x6c\141\163\40\x63", "\x62\56\151\x64\x5f\153\145\154\141\x73\x3d\143\56\x69\x64\137\153\x65\x6c\141\163"); goto lcONe; PaVHx: } public function cekNilaiHarianKelas($id_mapel, $id_kelas, $id_tp, $id_smt) { goto P3AUf; YEXih: return $this->db->get()->num_rows(); goto GLEqp; mIhjI: $this->db->where("\x69\144\137\x6b\x65\x6c\141\163", $id_kelas); goto HN5sc; UXnon: $this->db->where("\x70\x5f\x72\x61\x74\141\x5f\x72\x61\x74\x61\40\x21\75", "\x4e\x55\114\114"); goto YEXih; P3AUf: $this->db->select("\x70\x5f\162\x61\164\x61\137\x72\x61\x74\141"); goto zU4eZ; HN5sc: $this->db->where("\151\144\137\x74\x70", $id_tp); goto rKgcP; rKgcP: $this->db->where("\151\x64\x5f\x73\x6d\x74", $id_smt); goto UXnon; zU4eZ: $this->db->from("\x72\x61\x70\157\162\x5f\x6e\x69\x6c\x61\151\x5f\x68\x61\x72\x69\141\x6e"); goto sNHS3; sNHS3: $this->db->where("\x69\144\137\155\x61\160\x65\x6c", $id_mapel); goto mIhjI; GLEqp: } public function getNilaiHarianKelas($id_mapel, $id_kelas, $id_siswa, $id_tp, $id_smt) { goto X_ae2; jLK3F: $this->db->from("\x72\141\160\157\x72\x5f\156\151\154\x61\151\x5f\x68\x61\162\151\141\x6e"); goto tCmbY; X_ae2: $this->db->select("\x2a"); goto jLK3F; tCmbY: $this->db->where("\x69\144\x5f\156\x69\154\x61\x69\137\x68\x61\x72\x69\141\x6e", $id_mapel . $id_kelas . $id_siswa . $id_tp . $id_smt); goto j0ud6; j0ud6: return $this->db->get()->row(); goto RuJpL; RuJpL: } public function getAllNilaiHarianKelas($id_kelas) { goto cL7hD; EAzOv: $this->db->where("\x69\x64\137\x6b\x65\154\x61\x73", $id_kelas); goto SGOZM; SGOZM: return $this->db->get()->result(); goto vkAa_; cL7hD: $this->db->select("\52"); goto nwqIQ; nwqIQ: $this->db->from("\x72\x61\x70\x6f\162\137\156\x69\154\x61\x69\137\x68\141\x72\x69\x61\156"); goto EAzOv; vkAa_: } public function cekNilaiPtsKelas($id_mapel, $id_kelas, $id_tp, $id_smt) { goto uHtBJ; Tne3L: $this->db->where("\x69\x64\137\164\160", $id_tp); goto R1kIB; QftEb: $this->db->where("\x70\x72\145\x64\151\x6b\x61\x74\x20\41\75", "\116\125\x4c\114"); goto z3By6; d3cEJ: $this->db->from("\162\x61\x70\157\162\x5f\156\151\154\141\x69\137\160\164\x73"); goto Bgima; z3By6: return $this->db->get()->num_rows(); goto KhB_f; uHtBJ: $this->db->select("\x70\162\145\144\151\153\x61\164"); goto d3cEJ; QuJ3r: $this->db->where("\x69\x64\x5f\153\145\x6c\x61\163", $id_kelas); goto Tne3L; Bgima: $this->db->where("\x69\x64\137\155\x61\x70\x65\154", $id_mapel); goto QuJ3r; R1kIB: $this->db->where("\x69\144\x5f\163\155\164", $id_smt); goto QftEb; KhB_f: } public function getIdNilaiPts($arr_id) { goto qTCsT; qTCsT: $this->db->select("\x69\x64\137\156\151\154\141\x69\x5f\160\164\163"); goto lHVqu; sedot: return $ret; goto Fcjp7; RGTsx: $result = $this->db->get()->result(); goto XYZ4X; Ma2wR: $this->db->where_in("\151\x64\x5f\x6e\151\154\141\151\137\160\164\163", $arr_id); goto RGTsx; SOCOr: eGHkx: goto sedot; PW1yU: if (!$result) { goto eGHkx; } goto TuSYZ; XYZ4X: $ret = []; goto PW1yU; lHVqu: $this->db->from("\x72\141\160\157\x72\x5f\156\151\154\141\151\x5f\x70\164\163"); goto Ma2wR; MN8lk: wz_z1: goto SOCOr; TuSYZ: foreach ($result as $key => $row) { $ret[$row->id_nilai_pts] = $row; govUB: } goto MN8lk; Fcjp7: } public function getNilaiPtsKelas($id_mapel, $id_kelas, $id_siswa, $id_tp, $id_smt) { goto kW170; NARqt: $this->db->where("\x69\144\x5f\156\151\x6c\x61\151\x5f\160\164\x73", $id_mapel . $id_kelas . $id_siswa . $id_tp . $id_smt); goto ksfwz; ksfwz: return $this->db->get()->row(); goto xEuXV; kW170: $this->db->select("\x2a"); goto fK0st; fK0st: $this->db->from("\x72\x61\160\157\162\137\156\151\x6c\x61\x69\137\x70\164\x73"); goto NARqt; xEuXV: } public function getAllNilaiPtsKelas($id_kelas) { goto LigBJ; x4ARo: $this->db->from("\162\x61\160\157\162\137\156\x69\x6c\141\x69\x5f\x70\164\163"); goto zgYOT; LigBJ: $this->db->select("\x2a"); goto x4ARo; zgYOT: $this->db->where("\151\144\x5f\153\145\x6c\x61\x73", $id_kelas); goto Z3iX5; Z3iX5: return $this->db->get()->result(); goto Pw51M; Pw51M: } public function getEkstraKelas($id_mapel, $id_siswa, $id_tp, $id_smt) { goto aqT3Y; Epf4B: return $this->db->get()->row(); goto E2VQe; URetH: $this->db->where("\151\x64\137\x73\155\x74", $id_smt); goto Epf4B; f0nv8: $this->db->from("\162\141\x70\157\162\x5f\156\x69\x6c\141\151\137\145\x6b\x73\164\162\x61"); goto AjYZa; aqT3Y: $this->db->select("\156\x69\x6c\x61\151\54\40\x70\162\x65\144\151\x6b\x61\164\x2c\40\x64\x65\163\153\162\x69\160\x73\151"); goto f0nv8; AjYZa: $this->db->where("\x69\144\x5f\x65\x6b\x73\164\x72\141", $id_mapel); goto uMu2a; k19DW: $this->db->where("\151\x64\137\164\x70", $id_tp); goto URetH; uMu2a: $this->db->where("\151\144\x5f\163\151\x73\167\x61", $id_siswa); goto k19DW; E2VQe: } public function cekNilaiEkstraKelas($id_mapel, $id_kelas, $id_tp, $id_smt) { goto MYFIO; oLqQk: return $this->db->get()->num_rows(); goto m59C1; Ki1NR: $this->db->where("\x69\x64\x5f\145\153\163\x74\162\141", $id_mapel); goto Tm_3G; FyUiY: $this->db->where("\x69\144\137\x73\155\164", $id_smt); goto oLqQk; MYFIO: $this->db->select("\x69\144\x5f\x6e\151\x6c\x61\x69\137\x65\153\163\x74\x72\x61"); goto n9ldU; Tm_3G: $this->db->where("\151\144\137\153\x65\154\141\x73", $id_kelas); goto DBfJz; DBfJz: $this->db->where("\151\144\137\164\160", $id_tp); goto FyUiY; n9ldU: $this->db->from("\x72\141\160\x6f\162\x5f\x6e\151\154\141\x69\137\x65\x6b\x73\164\162\x61"); goto Ki1NR; m59C1: } public function getNilaiEkstraKelas($id_ekstra, $id_kelas, $id_siswa, $id_tp, $id_smt) { goto c63gY; Atmiz: $this->db->from("\162\x61\160\x6f\162\137\156\151\154\x61\x69\x5f\145\153\163\x74\x72\141"); goto x9Wbj; x9Wbj: $this->db->where("\x69\x64\x5f\156\151\x6c\141\x69\x5f\x65\153\163\x74\x72\x61", $id_ekstra . $id_kelas . $id_siswa . $id_tp . $id_smt); goto Ycvzm; c63gY: $this->db->select("\x2a"); goto Atmiz; Ycvzm: return $this->db->get()->row(); goto hnVtC; hnVtC: } public function getAllNilaiEkstraKelas($id_kelas) { goto K0D1e; acfTR: return $this->db->get()->result(); goto fSGCO; dzP04: $this->db->where("\151\144\x5f\x6b\145\154\141\163", $id_kelas); goto acfTR; i2PWA: $this->db->from("\162\141\x70\157\x72\x5f\156\151\x6c\x61\151\137\145\x6b\x73\x74\162\x61"); goto dzP04; K0D1e: $this->db->select("\x2a"); goto i2PWA; fSGCO: } public function cekNilaiAkhirKelas($id_mapel, $id_kelas, $id_tp, $id_smt) { goto Py1VN; xBsrg: $this->db->where("\151\144\x5f\x6d\141\x70\145\x6c", $id_mapel); goto N5c81; iZBva: $this->db->where("\x69\144\x5f\x73\155\164", $id_smt); goto GV4Kk; Py1VN: $this->db->select("\151\144\137\156\151\154\141\x69\137\x61\153\x68\x69\162"); goto Ew41B; Ew41B: $this->db->from("\x72\141\160\x6f\x72\x5f\x6e\151\154\141\151\x5f\141\153\x68\151\162"); goto xBsrg; GV4Kk: return $this->db->get()->num_rows(); goto NptUX; c2fFg: $this->db->where("\x69\144\x5f\x74\160", $id_tp); goto iZBva; N5c81: $this->db->where("\x69\144\x5f\153\x65\x6c\141\x73", $id_kelas); goto c2fFg; NptUX: } public function getNilaiAkhirKelas($id_mapel, $id_kelas, $id_siswa, $id_tp, $id_smt) { goto OaXWX; kcnkW: $this->db->join("\x72\x61\160\157\x72\137\156\151\154\x61\x69\x5f\160\x74\x73\40\x62", "\x62\56\151\x64\x5f\156\151\x6c\x61\151\x5f\x70\x74\x73\75\x61\56\x69\144\137\x6e\x69\x6c\141\151\137\x68\141\162\151\x61\x6e", "\x6c\x65\x66\x74"); goto Qsn71; naaHd: $this->db->select("\x61\x2e\160\x5f\162\141\164\141\x5f\x72\141\164\x61\40\141\x73\40\x6e\x68\x61\x72\54\x20\141\56\160\x5f\144\145\163\153\x72\151\x70\163\x69\x2c\x20\x61\x2e\153\137\162\x61\164\141\137\x72\x61\164\x61\x2c\x20\x61\56\153\x5f\x70\162\145\x64\x69\x6b\141\164\x2c\40\x61\x2e\153\x5f\x64\145\x73\x6b\162\x69\160\163\x69\x2c\40\142\56\156\x69\x6c\x61\151\x20\x61\163\40\x6e\x70\x74\x73\54\x20\x63\x2e\x6e\151\154\x61\151\40\141\x73\x20\156\x70\x61\x73\x2c\40\x63\56\160\x72\x65\x64\x69\x6b\141\x74"); goto wgHgD; Qsn71: $this->db->join("\162\x61\x70\x6f\x72\137\156\x69\154\141\x69\x5f\141\153\150\x69\162\40\143", "\143\56\151\x64\x5f\x6e\x69\x6c\141\151\x5f\x61\x6b\x68\151\162\75\141\x2e\x69\x64\137\156\x69\x6c\x61\151\137\x68\x61\x72\151\x61\156", "\154\x65\x66\x74"); goto i_UIA; wgHgD: $this->db->from("\162\141\x70\x6f\x72\137\x6e\151\x6c\141\x69\137\150\141\x72\x69\141\x6e\40\x61"); goto kcnkW; OaXWX: $this->db->query("\x53\x45\124\40\123\x51\x4c\x5f\x42\x49\107\137\123\x45\114\x45\103\x54\123\75\x31"); goto naaHd; i_UIA: $this->db->where("\x69\144\x5f\x6e\151\154\141\151\137\x68\141\x72\x69\x61\156", $id_mapel . $id_kelas . $id_siswa . $id_tp . $id_smt); goto Wkjk1; Wkjk1: return $this->db->get()->row(); goto SEyJ0; SEyJ0: } public function getAllNilaiAkhirKelas($id_kelas) { goto ShTCt; TbSzH: return $this->db->get()->result(); goto PF54C; o7WYR: $this->db->from("\162\x61\160\157\x72\x5f\x6e\151\x6c\x61\151\x5f\141\x6b\x68\x69\x72"); goto GadF6; GadF6: $this->db->where("\151\x64\x5f\x6b\x65\x6c\x61\163", $id_kelas); goto TbSzH; ShTCt: $this->db->select("\52"); goto o7WYR; PF54C: } public function getNilaiAkhirByMapel($id_mapel, $id_kelas, $id_tp, $id_smt) { goto zdq6X; nK7gV: $this->db->join("\x72\x61\x70\157\x72\137\x6e\151\x6c\141\x69\x5f\141\x6b\150\151\x72\x20\x63", "\143\56\151\144\137\156\151\x6c\141\151\137\141\x6b\150\151\162\75\141\x2e\151\144\x5f\x6e\x69\x6c\x61\x69\137\150\x61\162\151\x61\156", "\154\145\x66\164"); goto Ypf4Y; L9H16: return $this->db->get()->result(); goto gv9kd; Gauei: $this->db->join("\x72\x61\x70\x6f\162\x5f\156\x69\154\x61\151\137\x70\164\x73\40\142", "\x62\56\x69\144\137\156\x69\x6c\141\x69\x5f\160\x74\163\x3d\141\56\151\x64\137\156\151\x6c\141\151\x5f\x68\141\x72\x69\x61\156", "\154\x65\146\164"); goto nK7gV; F8HnR: $this->db->where("\x61\x2e\151\144\137\x73\x6d\x74", $id_smt); goto L9H16; Ypf4Y: $this->db->where("\x61\x2e\x69\x64\137\x6d\x61\x70\x65\x6c", $id_mapel); goto Kg54V; SPchU: $this->db->select("\x61\56\151\144\x5f\x73\x69\163\167\x61\54\x20\141\x2e\160\x5f\x72\141\x74\141\137\x72\141\164\141\40\x61\163\40\x6e\x68\x61\162\54\x20\141\56\x70\137\144\145\x73\x6b\x72\151\160\163\151\54\40\141\x2e\x6b\137\x72\x61\164\x61\137\x72\141\164\141\54\x20\141\x2e\153\x5f\x70\162\x65\144\x69\153\141\164\x2c\40\x61\56\x6b\137\x64\x65\x73\x6b\162\x69\160\163\151\x2c\x20\x62\x2e\156\x69\154\141\x69\x20\x61\163\40\156\160\164\163\x2c\40\143\56\156\151\x6c\141\x69\x20\x61\163\x20\x6e\160\141\x73\x2c\x20\x63\x2e\x70\162\145\144\151\153\141\164"); goto FZc0s; zdq6X: $this->db->query("\x53\105\124\40\x53\x51\x4c\x5f\x42\111\107\137\x53\105\x4c\x45\103\x54\x53\x3d\61"); goto SPchU; FZc0s: $this->db->from("\162\141\x70\157\x72\137\x6e\x69\x6c\x61\151\x5f\x68\141\162\x69\141\x6e\40\141"); goto Gauei; Kg54V: $this->db->where("\x61\56\151\x64\137\153\x65\154\x61\x73", $id_kelas); goto sgH1s; sgH1s: $this->db->where("\x61\56\x69\x64\x5f\x74\160", $id_tp); goto F8HnR; gv9kd: } public function getDeskripsiSikap($kelas, $id_tp, $id_smt) { $this->db->where("\x69\144\137\153\145\154\x61\x73", $kelas)->where("\x69\x64\137\x74\x70", $id_tp)->where("\151\144\137\163\155\164", $id_smt); return $this->db->get("\162\141\x70\157\x72\x5f\144\141\164\x61\x5f\163\151\153\x61\160")->result(); } public function getAllDeskripsiSikap($kelas) { $this->db->where("\x69\144\x5f\x6b\x65\x6c\141\163", $kelas); return $this->db->get("\x72\x61\x70\157\162\137\144\141\x74\x61\x5f\163\151\153\141\x70")->result(); } public function getDeskripsiSikapByJenis($kelas, $jenis, $id_tp, $id_smt) { goto pdwtl; VtlgV: return $this->db->get()->result(); goto bGKaf; pdwtl: $this->db->select("\x2a"); goto RbIJi; R60PG: $this->db->where("\x69\144\x5f\164\160", $id_tp); goto CxRft; RbIJi: $this->db->from("\162\x61\x70\x6f\162\137\x64\x61\x74\141\137\x73\151\153\141\x70"); goto nBeMY; CxRft: $this->db->where("\x69\x64\137\x73\x6d\164", $id_smt); goto VtlgV; uEKcP: $this->db->where("\152\x65\x6e\x69\163", $jenis); goto R60PG; nBeMY: $this->db->where("\151\144\x5f\153\145\x6c\141\163", $kelas); goto uEKcP; bGKaf: } public function getNilaiSikapKelas($id_kelas, $id_siswa, $id_tp, $id_smt, $jenis) { goto IDhxf; QmM2F: return $this->db->get()->row(); goto f41Wj; Sv5Un: $this->db->where("\151\x64\x5f\x6e\151\154\x61\151\137\163\151\x6b\141\x70", $id_kelas . $id_siswa . $id_tp . $id_smt . $jenis); goto QmM2F; fKwko: $this->db->from("\x72\x61\x70\157\x72\137\156\151\x6c\x61\x69\137\163\151\x6b\141\x70"); goto Sv5Un; IDhxf: $this->db->select("\52"); goto fKwko; f41Wj: } public function getAllNilaiSikapKelas($id_kelas) { goto mmjDw; UdbA0: $this->db->where("\x69\x64\137\153\145\154\141\x73", $id_kelas); goto drSIf; drSIf: return $this->db->get()->result(); goto EFwIk; ZQm9X: $this->db->from("\162\x61\x70\x6f\x72\x5f\156\151\x6c\141\151\137\163\151\153\141\x70"); goto UdbA0; mmjDw: $this->db->select("\52"); goto ZQm9X; EFwIk: } public function getNilaiSikapByJenis($id_kelas, $jenis, $id_tp, $id_smt) { goto Bhs3u; yEpXT: $this->db->where("\x69\144\x5f\153\x65\154\141\163", $id_kelas); goto YeNKs; Bhs3u: $this->db->select("\x2a"); goto KQyat; qQ1_P: return $this->db->get()->result(); goto B1P_7; v5PKh: $this->db->where("\151\144\x5f\163\x6d\x74", $id_smt); goto qQ1_P; KQyat: $this->db->from("\162\141\x70\x6f\x72\x5f\x6e\151\154\x61\151\137\163\x69\x6b\x61\160"); goto yEpXT; YeNKs: $this->db->where("\x6a\145\x6e\x69\163", $jenis); goto L7mm3; L7mm3: $this->db->where("\151\x64\137\x74\160", $id_tp); goto v5PKh; B1P_7: } public function getNilaiSikapByKelas($id_kelas, $id_tp, $id_smt) { goto DDJBu; d5XRu: return $this->db->get()->result(); goto L_XGd; YAtf7: $this->db->from("\x72\x61\160\157\x72\137\x6e\151\x6c\x61\151\x5f\163\x69\153\x61\160"); goto x2hs0; HumHX: $this->db->where("\x69\144\137\164\x70", $id_tp); goto I35TI; DDJBu: $this->db->select("\x2a"); goto YAtf7; x2hs0: $this->db->where("\151\x64\x5f\x6b\145\x6c\x61\163", $id_kelas); goto HumHX; I35TI: $this->db->where("\151\x64\x5f\163\155\x74", $id_smt); goto d5XRu; L_XGd: } public function getNilaiSikapBySiswa($id_siswa, $id_tp, $id_smt) { goto JaiTJ; OqOOs: $this->db->where("\151\144\x5f\163\155\x74", $id_smt); goto I6qxY; I6qxY: return $this->db->get()->result(); goto XwoP2; a0UC2: $this->db->where("\151\x64\137\x73\x69\163\x77\x61", $id_siswa); goto H6I7v; H6I7v: $this->db->where("\151\144\137\x74\x70", $id_tp); goto OqOOs; JaiTJ: $this->db->select("\52"); goto Wr8QF; Wr8QF: $this->db->from("\162\141\x70\157\162\137\156\151\154\141\x69\137\x73\151\153\141\x70"); goto a0UC2; XwoP2: } public function getDeskripsiCatatanByJenis($kelas, $jenis, $id_tp, $id_smt) { $this->db->where("\x6a\145\x6e\x69\x73", $jenis)->where("\x69\144\x5f\153\145\154\x61\x73", $kelas)->where("\x69\144\137\x74\x70", $id_tp)->where("\x69\x64\137\163\x6d\x74", $id_smt); return $this->db->get("\162\x61\x70\x6f\162\137\x64\141\x74\141\137\143\x61\x74\141\164\x61\156")->result(); } public function getCatatanKelas($id_kelas, $id_siswa, $id_tp, $id_smt) { goto mme1R; mme1R: $this->db->select("\52"); goto LfQxT; B8oya: $this->db->where("\151\x64\137\x63\x61\164\141\x74\141\x6e\137\167\x61\x6c\151", $id_kelas . $id_siswa . $id_tp . $id_smt); goto i9X39; LfQxT: $this->db->from("\162\141\160\x6f\162\x5f\x63\x61\164\141\x74\x61\156\x5f\x77\141\x6c\x69"); goto B8oya; i9X39: return $this->db->get()->row(); goto h4tYP; h4tYP: } public function getAllCatatanKelas($id_kelas) { goto po117; po117: $this->db->select("\x2a"); goto Gg5NQ; d1GzZ: $this->db->where("\151\x64\x5f\x6b\x65\x6c\141\163", $id_kelas); goto jNpDV; jNpDV: return $this->db->get()->result(); goto lBzL1; Gg5NQ: $this->db->from("\x72\x61\x70\x6f\162\x5f\x63\x61\164\141\x74\141\x6e\137\x77\141\154\x69"); goto d1GzZ; lBzL1: } public function getRankingKelas($id_kelas, $id_siswa, $id_tp, $id_smt) { goto JQgc7; JQgc7: $this->db->select("\x2a"); goto Y2D99; yIHok: $this->db->where("\x69\144\137\x72\141\156\153\x69\x6e\147", $id_kelas . $id_siswa . $id_tp . $id_smt); goto aozAv; aozAv: return $this->db->get()->row(); goto kFUfT; Y2D99: $this->db->from("\162\141\160\x6f\162\137\160\162\x65\x73\x74\141\x73\151"); goto yIHok; kFUfT: } public function getAllRankingKelas($id_kelas) { goto jWmfy; jWmfy: $this->db->select("\x2a"); goto ZfE8t; DHq51: return $this->db->get()->result(); goto fvclE; LYOON: $this->db->where("\151\x64\x5f\x6b\145\154\x61\x73", $id_kelas); goto DHq51; ZfE8t: $this->db->from("\x72\141\160\x6f\x72\137\x70\x72\x65\x73\164\141\163\151"); goto LYOON; fvclE: } public function getAllDeskripsiFisikKelas() { goto cfpBG; X9Ppi: if (!$result) { goto P0s0N; } goto UmLU6; cfpBG: $result = $this->db->get("\162\141\x70\157\162\137\x64\x61\164\x61\x5f\146\151\x73\x69\153")->result(); goto WX72o; WJvPT: kzZPI: goto ADJ3f; ADJ3f: P0s0N: goto fs0i9; WX72o: $ret = []; goto X9Ppi; UmLU6: foreach ($result as $key => $row) { $ret[$row->id_kelas][$row->id_tp][$row->id_smt] = $row; E2qI6: } goto WJvPT; fs0i9: return $ret; goto MB7Tl; MB7Tl: } public function getAllRaporFisik() { goto sT3Qk; PV0bY: return $ret; goto AL7Nk; sT3Qk: $result = $this->db->get("\x72\x61\x70\157\x72\x5f\146\x69\163\151\x6b")->result(); goto e2FB1; e2FB1: $ret = []; goto DrwLv; q5gCC: sMbGZ: goto jB79S; DrwLv: if (!$result) { goto X9est; } goto woRWe; woRWe: foreach ($result as $key => $row) { $ret[$row->id_siswa][$row->id_tp][$row->id_smt] = $row; SSavK: } goto q5gCC; jB79S: X9est: goto PV0bY; AL7Nk: } public function getDeskripsiFisikKelas($kelas, $id_tp, $id_smt) { $this->db->where("\x69\x64\x5f\146\151\x73\151\x6b", $kelas)->where("\151\x64\137\x74\x70", $id_tp)->where("\x69\144\137\163\155\x74", $id_smt); return $this->db->get("\x72\141\160\x6f\162\x5f\x64\x61\x74\141\x5f\146\151\x73\151\153")->row(); } public function getFisikKelas($id_kelas, $id_siswa, $id_tp, $id_smt) { goto Etvm3; Etvm3: $this->db->select("\52"); goto wA8Lv; mo1cB: return $this->db->get()->row(); goto lCGws; l5GIn: $this->db->where("\151\x64\137\146\x69\x73\151\x6b", $id_kelas . $id_siswa . $id_tp . $id_smt); goto mo1cB; wA8Lv: $this->db->from("\x72\141\x70\x6f\x72\137\x66\x69\x73\151\x6b"); goto l5GIn; lCGws: } public function getAllFisikKelas($id_kelas) { goto rd6P4; rd6P4: $this->db->select("\x2a"); goto JSsQM; nRWTT: $this->db->where("\x69\144\137\x6b\x65\154\141\163", $id_kelas); goto TvsuA; JSsQM: $this->db->from("\162\x61\160\157\162\137\146\151\x73\x69\153"); goto nRWTT; TvsuA: return $this->db->get()->result(); goto yiqw3; yiqw3: } public function getJmlNilaiMapelHarianSiswa($id_mapel, $id_siswa, $id_tp, $id_smt) { goto unDnb; JiyTb: $this->db->where("\151\x64\x5f\x6d\x61\x70\x65\x6c", $id_mapel); goto B0UGb; d_VtY: $this->db->from("\162\x61\x70\157\x72\x5f\x6e\151\154\x61\x69\x5f\150\141\162\x69\x61\156"); goto JiyTb; B0UGb: $this->db->where("\151\x64\x5f\x73\151\163\167\x61", $id_siswa); goto mfXg2; q8s3j: return $this->db->get()->row(); goto gROfP; bcHR2: $this->db->where("\151\x64\137\163\x6d\164", $id_smt); goto q8s3j; unDnb: $this->db->select("\160\137\162\141\164\x61\137\x72\x61\x74\x61\54\x20\x6b\137\162\141\x74\x61\x5f\x72\141\164\141\54\x20\x6a\155\154"); goto d_VtY; mfXg2: $this->db->where("\x69\144\x5f\x74\x70", $id_tp); goto bcHR2; gROfP: } public function getNilaiMapelHarianSiswa($id_mapel, $id_siswa, $id_tp, $id_smt) { goto p9J96; t2ept: return $this->db->get()->row(); goto Pe0Mz; guHcC: $this->db->where("\x69\x64\137\164\x70", $id_tp); goto QvM_0; p9J96: $this->db->select("\x70\x31\54\160\x32\54\x70\x33\x2c\x70\64\x2c\160\x35\54\153\x31\54\153\62\54\x6b\x33\54\x6b\x34\x2c\153\x35"); goto pSQqQ; pSQqQ: $this->db->from("\162\141\x70\157\162\x5f\156\x69\154\141\x69\x5f\x68\141\x72\x69\x61\156"); goto DW0Pr; DW0Pr: $this->db->where("\151\x64\x5f\x6d\141\160\x65\154", $id_mapel); goto iJcVD; iJcVD: $this->db->where("\x69\x64\137\163\151\x73\x77\x61", $id_siswa); goto guHcC; QvM_0: $this->db->where("\x69\144\137\x73\x6d\164", $id_smt); goto t2ept; Pe0Mz: } public function getArrNilaiMapelHarianSiswa($ids_mapel, $ids_siswa, $id_tp, $id_smt) { goto n41A1; TvqaF: $this->db->where("\x69\x64\x5f\164\x70", $id_tp); goto KqAKG; KqAKG: $this->db->where("\151\144\x5f\x73\x6d\x74", $id_smt); goto VjuDK; KPZhx: $this->db->from("\x72\x61\x70\x6f\x72\x5f\x6e\151\154\x61\151\x5f\x68\x61\x72\x69\x61\x6e"); goto CRdbm; n41A1: $this->db->select("\160\61\x2c\160\x32\54\x70\63\54\160\x34\x2c\160\65\x2c\153\x31\x2c\x6b\62\x2c\x6b\63\54\x6b\x34\x2c\153\x35\x2c\151\x64\137\155\141\160\145\154\x2c\x69\x64\x5f\x73\x69\163\x77\141"); goto KPZhx; wBGKR: $this->db->where_in("\x69\144\137\x73\x69\x73\167\141", $ids_siswa); goto TvqaF; qib2p: return $rest; goto wxRmg; SGbP5: $rest = []; goto j7fH1; CRdbm: $this->db->where_in("\151\x64\137\155\x61\160\145\154", $ids_mapel); goto wBGKR; j7fH1: foreach ($nilais as $nilai) { $rest[$nilai->id_siswa][$nilai->id_mapel] = $nilai; g_J8y: } goto e_HgS; VjuDK: $nilais = $this->db->get()->result(); goto SGbP5; e_HgS: ZKZiP: goto qib2p; wxRmg: } public function getNilaiMapelPtsSiswa($id_mapel, $id_siswa, $id_tp, $id_smt) { goto KQIRn; r9b8E: $this->db->where("\151\x64\x5f\163\151\x73\167\x61", $id_siswa); goto CM8R9; sM8pU: return $this->db->get()->row(); goto RjaJ8; bLvxf: $this->db->where("\x69\144\137\155\141\160\x65\x6c", $id_mapel); goto r9b8E; t2A9u: $this->db->from("\162\x61\x70\x6f\x72\137\x6e\x69\154\x61\x69\137\x70\x74\x73"); goto bLvxf; CM8R9: $this->db->where("\x69\144\137\164\160", $id_tp); goto KJyUH; KQIRn: $this->db->select("\x6e\151\x6c\x61\x69"); goto t2A9u; KJyUH: $this->db->where("\151\144\137\x73\155\x74", $id_smt); goto sM8pU; RjaJ8: } public function getArrNilaiMapelPtsSiswa($ids_mapel, $ids_siswa, $id_tp, $id_smt) { goto OBp59; K8okT: $this->db->where_in("\x69\x64\x5f\155\141\x70\145\154", $ids_mapel); goto Ut610; J833h: vWWE3: goto d6jx2; Ut610: $this->db->where_in("\x69\144\x5f\163\151\163\x77\141", $ids_siswa); goto vul62; ZfPRV: $nilais = $this->db->get()->result(); goto MC04b; U1V9w: $this->db->from("\x72\x61\160\157\x72\x5f\156\x69\x6c\x61\151\x5f\160\164\163"); goto K8okT; MC04b: $rest = []; goto KsuF9; OBp59: $this->db->select("\156\x69\154\x61\x69\x2c\40\151\x64\137\155\x61\x70\145\154\x2c\40\151\x64\137\x73\151\x73\x77\141"); goto U1V9w; d6jx2: return $rest; goto IjGiu; vul62: $this->db->where("\151\144\x5f\164\x70", $id_tp); goto G3avR; KsuF9: foreach ($nilais as $nilai) { $rest[$nilai->id_siswa][$nilai->id_mapel] = $nilai; huMtP: } goto J833h; G3avR: $this->db->where("\151\144\137\163\x6d\x74", $id_smt); goto ZfPRV; IjGiu: } public function getNilaiMapelPasSiswa($id_mapel, $id_siswa, $id_tp, $id_smt) { goto TU30s; xY2Va: $this->db->where("\x69\144\x5f\x74\x70", $id_tp); goto DdDQy; TU30s: $this->db->select("\x6e\151\x6c\x61\x69\x2c\141\x6b\150\151\x72"); goto W2uga; YrmRi: return $this->db->get()->row(); goto wsXKq; DdDQy: $this->db->where("\x69\144\x5f\163\155\164", $id_smt); goto YrmRi; H0l0e: $this->db->where("\151\x64\137\x73\151\x73\167\x61", $id_siswa); goto xY2Va; W2uga: $this->db->from("\162\x61\160\x6f\x72\x5f\x6e\151\154\141\151\x5f\x61\x6b\x68\151\162"); goto sNU8J; sNU8J: $this->db->where("\151\x64\137\x6d\x61\x70\145\x6c", $id_mapel); goto H0l0e; wsXKq: } public function getNilaiRapor($id_mapel, $id_kelas, $id_siswa, $id_tp, $id_smt) { goto Ix4tU; V5O3E: $this->db->from("\x72\x61\160\157\162\137\x6e\151\x6c\x61\x69\x5f\150\141\162\151\141\156\x20\x61"); goto stwCh; ydVbq: $this->db->where("\141\x2e\x69\144\137\156\x69\x6c\x61\x69\137\150\141\162\x69\x61\x6e", $id_mapel . $id_kelas . $id_siswa . $id_tp . $id_smt); goto cd4JV; Ix4tU: $this->db->select("\x61\x2e\x70\137\162\x61\164\x61\137\162\x61\x74\141\54\40\141\56\160\x5f\144\145\163\x6b\162\151\x70\163\151\x2c\40\141\x2e\153\x5f\162\x61\164\141\137\162\x61\x74\x61\54\40\x61\56\153\x5f\x70\x72\145\144\151\x6b\141\164\54\x20\141\x2e\153\x5f\x64\145\x73\x6b\x72\151\x70\163\x69\x2c\40\142\x2e\x6e\151\154\x61\x69\x20\x61\x73\x20\156\151\x6c\141\151\137\x70\141\163\x2c\x20\142\56\x61\153\150\151\x72\x20\x61\x73\40\156\151\154\141\151\x2c\40\142\x2e\160\162\145\144\151\x6b\x61\164"); goto V5O3E; stwCh: $this->db->join("\162\x61\x70\x6f\x72\137\x6e\x69\154\141\151\137\141\x6b\x68\151\x72\40\x62", "\x62\56\151\144\x5f\x6e\151\x6c\x61\151\x5f\x61\x6b\x68\x69\162\x3d\141\56\151\x64\137\x6e\151\x6c\141\x69\x5f\150\x61\162\x69\x61\x6e", "\x6c\x65\x66\164"); goto ydVbq; cd4JV: return $this->db->get()->row_array(); goto r2m_y; r2m_y: } public function getNilaiMapelByKelas($id_mapel, $id_kelas, $id_tp, $id_smt) { goto WydeI; dRIcu: $this->db->where("\x61\x2e\151\144\x5f\153\145\x6c\141\x73", $id_kelas); goto MbhHG; x1Iab: $this->db->where("\141\56\x69\x64\137\155\141\x70\145\x6c", $id_mapel); goto dRIcu; WydeI: $this->db->select("\141\x2e\x70\x5f\x72\141\x74\141\137\x72\x61\x74\141\x2c\40\141\56\x70\x5f\x64\145\163\153\x72\151\x70\x73\151\54\40\141\x2e\153\x5f\162\141\x74\x61\137\x72\141\x74\141\x2c\40\x61\x2e\x6b\x5f\x70\162\x65\144\151\153\x61\x74\54\40\x61\x2e\153\x5f\144\x65\x73\x6b\162\151\x70\x73\x69\54\x20\142\56\x6e\151\x6c\x61\151\40\141\x73\x20\x6e\151\x6c\x61\151\137\x70\141\x73\x2c\x20\x62\x2e\x61\153\x68\x69\162\40\141\x73\40\156\x69\x6c\141\x69\x2c\40\142\x2e\160\162\145\x64\151\153\x61\x74"); goto LrGql; MbhHG: $this->db->where("\141\56\151\x64\x5f\x74\x70", $id_tp); goto xdx8l; xdx8l: $this->db->where("\141\56\151\x64\x5f\163\x6d\164", $id_smt); goto Z2O9c; Z2O9c: return $this->db->get()->result(); goto QPxtr; LrGql: $this->db->from("\162\x61\x70\x6f\162\x5f\x6e\151\154\x61\x69\137\150\x61\162\x69\141\156\x20\x61"); goto uCz56; uCz56: $this->db->join("\162\141\160\x6f\162\137\156\x69\x6c\x61\x69\x5f\x61\x6b\150\x69\x72\40\142", "\142\x2e\x69\x64\137\x6e\151\154\x61\151\x5f\x61\x6b\150\x69\162\x3d\141\x2e\151\144\137\156\151\x6c\x61\151\137\x68\141\162\x69\x61\x6e", "\154\145\x66\164"); goto x1Iab; QPxtr: } public function getNilaiRaporByKelas($id_kelas, $id_tp, $id_smt) { goto oSQ2u; p6jMB: $this->db->where("\141\x2e\151\x64\137\x73\x6d\164", $id_smt); goto xAcmK; hXu_y: $this->db->from("\162\141\x70\x6f\x72\x5f\x6e\x69\x6c\141\x69\x5f\x68\x61\x72\151\141\x6e\40\x61"); goto R6LbJ; xAcmK: return $this->db->get()->result(); goto iPRBS; Xm7dV: $this->db->where("\141\x2e\151\x64\137\x74\160", $id_tp); goto p6jMB; oSQ2u: $this->db->select("\141\x2e\151\144\x5f\156\151\154\141\x69\137\150\141\162\151\141\x6e\54\40\x61\x2e\x69\x64\x5f\x73\x69\x73\167\141\54\x20\x61\56\x69\144\137\x6d\141\160\145\154\54\40\x61\56\x70\137\x72\141\164\x61\137\x72\x61\164\141\x2c\40\x61\x2e\x70\137\x64\x65\x73\x6b\x72\x69\160\x73\151\54\40\141\56\153\x5f\162\141\x74\141\137\x72\141\164\x61\x2c\x20\141\x2e\x6b\x5f\160\162\x65\x64\x69\x6b\x61\164\54\x20\141\x2e\x6b\x5f\x64\145\163\153\x72\151\160\163\151\x2c\x20\142\x2e\156\x69\154\141\x69\40\141\163\x20\156\151\x6c\x61\151\137\x70\x61\x73\54\40\x62\56\141\153\x68\151\x72\40\x61\x73\x20\x6e\151\154\x61\x69\x2c\40\142\56\160\x72\145\x64\x69\153\141\x74"); goto hXu_y; V7ii0: $this->db->where("\141\x2e\x69\144\x5f\153\x65\x6c\x61\163", $id_kelas); goto Xm7dV; R6LbJ: $this->db->join("\162\x61\x70\x6f\x72\x5f\x6e\x69\x6c\x61\x69\x5f\141\153\150\x69\162\x20\x62", "\x62\x2e\x69\x64\137\x6e\x69\x6c\141\x69\x5f\x61\153\150\151\x72\75\x61\x2e\x69\144\137\x6e\151\x6c\x61\x69\137\150\141\x72\x69\141\x6e", "\154\x65\x66\x74"); goto V7ii0; iPRBS: } public function getPrestasiByKelas($id_kelas, $id_tp, $id_smt) { goto OOHzA; h3U6V: foreach ($ranks as $rank) { $rest[$rank->id_siswa] = $rank; IkBjn: } goto GFW0S; d7ttb: $ranks = $this->db->get()->result(); goto ya7ZM; CfZZR: $this->db->where("\151\x64\137\x73\x6d\x74", $id_smt); goto d7ttb; nnU04: return $rest; goto XYmJJ; GFW0S: yK057: goto nnU04; ZVVNk: $this->db->where("\151\144\137\153\145\154\x61\x73", $id_kelas); goto kxCSn; ya7ZM: $rest = []; goto h3U6V; DQKzF: $this->db->from("\162\141\x70\x6f\162\x5f\160\162\145\163\164\141\x73\151"); goto ZVVNk; kxCSn: $this->db->where("\x69\144\x5f\164\x70", $id_tp); goto CfZZR; OOHzA: $this->db->select("\x69\x64\137\163\x69\163\167\x61\54\x20\162\141\x6e\153\x69\x6e\147\54\40\x64\x65\163\153\x72\x69\160\x73\151\40\x61\163\x20\x72\x61\156\153\x5f\x64\x65\x73\153\162\151\x70\163\151\54\x20\x70\61\x2c\x20\160\61\137\144\x65\x73\153\x2c\x20\160\62\x2c\40\x70\62\137\144\145\163\x6b\54\40\x70\x33\x2c\40\160\63\137\144\145\x73\x6b"); goto DQKzF; XYmJJ: } public function getCatatanWaliByKelas($id_kelas, $id_tp, $id_smt) { goto g1dDC; wghZb: $desks = $this->db->get()->result(); goto lhehn; lhehn: $rest = []; goto p_dIl; eKv2r: $this->db->where("\151\x64\x5f\163\x6d\x74", $id_smt); goto wghZb; vGP06: bsftx: goto mYWcz; pNXID: $this->db->where("\151\144\x5f\164\x70", $id_tp); goto eKv2r; gA7bK: $this->db->from("\162\141\160\157\x72\x5f\x63\141\x74\141\164\x61\156\x5f\167\x61\x6c\x69"); goto kWZKx; g1dDC: $this->db->select("\151\144\137\x73\151\163\x77\x61\54\x20\156\151\154\x61\151\x2c\40\144\145\163\153\x72\x69\x70\x73\151\40\141\163\x20\163\x61\162\x61\156"); goto gA7bK; mYWcz: return $rest; goto qyXvI; p_dIl: foreach ($desks as $desk) { $rest[$desk->id_siswa] = $desk; jwTKa: } goto vGP06; kWZKx: $this->db->where("\x69\x64\137\x6b\145\x6c\141\x73", $id_kelas); goto pNXID; qyXvI: } public function getRaporDeskripsi($id_kelas, $id_siswa, $id_tp, $id_smt) { goto wqtmt; wqtmt: $this->db->select("\142\x2e\x72\x61\156\153\151\x6e\x67\54\40\x62\56\x64\145\x73\x6b\162\x69\160\163\151\40\x61\163\40\x72\141\x6e\x6b\x5f\x64\x65\x73\153\162\x69\x70\x73\x69\54\x20\x62\56\x70\x31\x2c\x20\142\56\160\61\x5f\144\145\163\x6b\54\x20\142\56\160\x32\x2c\x20\142\x2e\x70\x32\137\144\145\163\153\x2c\40\x62\56\160\x33\54\40\142\56\x70\63\137\x64\145\163\153\54" . "\40\143\56\156\x69\x6c\x61\x69\x2c\40\143\56\x64\145\x73\x6b\x72\151\160\163\151\40\141\x73\x20\x73\x61\x72\141\x6e"); goto F4tAp; F4tAp: $this->db->from("\x72\x61\160\157\x72\137\160\x72\145\163\x74\141\163\x69\x20\x62"); goto rl1VR; Z90uj: return $this->db->get()->row(); goto Q4IFV; lJVV4: $this->db->where("\142\x2e\151\x64\x5f\162\141\x6e\153\151\x6e\x67", $id_kelas . $id_siswa . $id_tp . $id_smt); goto Z90uj; rl1VR: $this->db->join("\x72\141\160\157\x72\137\143\x61\x74\x61\x74\141\156\x5f\x77\141\x6c\x69\40\143", "\143\56\x69\144\x5f\143\141\x74\141\164\141\156\x5f\x77\141\x6c\x69\x3d\x62\x2e\151\x64\x5f\162\x61\156\153\151\x6e\147", "\x6c\x65\146\164"); goto lJVV4; Q4IFV: } public function getDummyDeskripsiSpiritual() { return ["\142\x65\x72\x64\x6f\141\x20\163\x65\142\x65\154\165\x6d\x20\x64\x61\x6e\x20\x73\145\x73\x75\x64\x61\x68\x20\x6d\x65\154\x61\153\x75\153\x61\x6e\40\153\145\147\x69\141\164\141\x6e", "\155\x65\x6e\152\x61\x6c\x61\156\153\x61\156\40\x69\x62\141\144\x61\150\x20\x73\145\163\165\x61\x69\x20\x64\145\156\147\141\x6e\x20\x61\147\x61\x6d\x61\x6e\x79\x61", "\x6d\145\x6d\x62\x65\x72\151\40\163\x61\154\x61\x6d\x20\160\141\144\141\40\163\x61\x61\x74\x20\141\x77\x61\x6c\x20\x64\141\156\40\141\153\x68\151\162\40\153\145\147\151\x61\x74\x61\x6e", "\142\145\162\163\171\165\153\165\x72\40\x61\164\x61\163\40\156\151\153\155\141\x74\40\x64\141\156\x20\x6b\141\162\x75\156\x69\141\x20\124\x75\150\x61\156\40\131\x61\156\x67\40\115\141\150\141\x20\105\x73\x61", "\155\145\x6e\163\x79\x75\x6b\x75\x72\151\40\153\145\155\141\x6d\x70\x75\x61\156\40\155\x61\156\165\x73\151\x61\40\144\141\154\141\155\40\x6d\145\156\x67\145\x6e\144\141\x6c\151\x6b\141\x6e\40\x64\x69\162\151", "\x62\x65\x72\x73\x79\165\153\165\162\40\x6b\145\x74\151\153\141\40\x62\145\x72\x68\x61\163\151\x6c\40\155\145\156\x67\x65\x72\x6a\x61\x6b\x61\156\40\x73\x65\x73\x75\141\x74\x75", "\142\x65\162\163\145\x72\x61\x68\40\144\151\x72\151\x20\x28\x74\141\x77\x61\x6b\x61\x6c\x29\x20\153\145\x70\x61\x64\141\40\x54\165\150\x61\x6e\x20\x73\145\164\x65\x6c\141\x68\40\x62\145\x72\x69\x6b\150\164\151\x61\162\x20\x61\164\x61\x75\40\x6d\x65\x6c\x61\153\x75\153\x61\x6e\40\x75\x73\x61\150\x61", "\155\145\155\145\x6c\151\x68\141\162\141\40\x68\x75\x62\x75\156\147\141\x6e\40\x62\x61\x69\153\40\144\x65\x6e\147\x61\x6e\x20\x73\145\163\141\x6d\141\40\x75\x6d\141\164", "\x62\x65\162\x73\x79\165\x6b\x75\x72\40\x73\145\142\141\147\141\x69\x20\142\x61\x6e\x67\163\141\40\x49\x6e\x64\157\156\145\163\151\x61", "\x6d\145\156\147\150\x6f\x72\x6d\x61\164\x69\x20\x6f\x72\x61\156\x67\40\x6c\141\x69\x6e\x20\x79\141\x6e\x67\40\x6d\145\156\152\x61\154\x61\x6e\153\141\x6e\40\x69\x62\141\x64\141\150\40\x73\x65\163\165\x61\151\x20\x64\x65\156\147\141\x6e\40\141\x67\x61\x6d\x61\x6e\171\x61"]; } public function getDummyDeskripsiSosial() { return ["\152\165\x6a\165\x72", "\x64\x69\163\151\160\154\x69\x6e", "\x74\141\156\147\x67\x75\156\x67\40\152\x61\167\141\x62", "\x73\141\156\164\165\x6e", "\x70\145\162\143\x61\x79\x61\x20\144\x69\x72\x69", "\160\x65\x64\165\x6c\151", "\164\x6f\x6c\145\x72\141\x6e\163\151", "\147\x6f\x74\157\x6e\147\x20\162\157\171\x6f\x6e\x67", "\x72\x61\x6a\151\x6e", "\164\x69\x64\x61\153\x20\155\x75\144\x61\150\40\155\145\156\x79\145\162\141\150"]; } public function getDummyDeskripsiAbsensi() { return ["\x4b\x65\150\141\x64\151\162\141\156\x20\143\165\153\x75\160\40\142\x61\x69\x6b\40\156\x61\155\x75\156\x20\160\145\162\x6c\165\40\144\151\164\x69\156\x67\153\141\164\153\141\156\56", "\125\x73\141\150\141\153\141\156\40\x68\141\144\151\162\40\163\x65\x74\151\141\x70\40\x68\141\x72\151\56", "\112\141\x6e\147\x61\x6e\x20\x74\145\x72\x6c\x61\154\x75\x20\142\141\156\171\141\153\x20\141\154\160\141\54\x20\144\x69\x68\x61\x72\141\x70\x6b\141\156\40\x73\x65\154\x61\x6c\165\x20\150\x61\144\x69\162\x20\x6b\x65\40\163\145\x6b\x6f\154\141\x68", "\113\x65\x68\141\x64\151\x72\141\156\155\x75\40\x73\x61\x6e\147\141\164\x20\152\x61\x72\x61\x6e\x67\40\x73\x65\153\141\154\151"]; } public function getDummyDeskripsiCatatan() { return ["\x53\x65\x6c\x61\154\165\x20\142\x65\162\165\163\141\150\x61\x20\x75\156\164\165\x6b\x20\155\x65\155\x61\164\x75\x68\151\40\164\141\x74\141\x20\164\x65\162\164\x69\142\x20\163\145\153\157\x6c\x61\x68\x20\x64\x61\x6e\40\x70\141\164\165\x68\x20\x74\x65\162\150\x61\144\x61\x70\40\x47\165\x72\165\56", "\123\x65\x6c\141\x6c\165\40\142\145\x72\x75\163\x61\150\141\x20\x75\x6e\164\165\153\x20\x6d\x61\x6e\144\151\x72\x69\x20\x64\141\156\40\x74\145\x70\141\164\40\167\141\153\x74\165\x20\x64\141\x6c\141\155\40\155\x65\x6e\x67\145\162\x6a\141\x6b\x61\156\40\164\x75\147\141\x73\56", "\115\145\155\x70\165\156\171\141\151\40\153\145\x6d\x61\x6d\x70\165\x61\x6e\40\x64\141\156\x20\155\x6f\x74\151\166\x61\x73\x69\x20\171\141\x6e\x67\40\x74\151\x6e\147\147\151\x20\x75\x6e\164\165\x6b\x20\x6d\145\156\x67\x67\x75\x6e\x61\153\141\156\40\x77\141\x6b\x74\x75\40\x73\145\x63\x61\162\141\x20\x65\146\x69\163\x69\145\x6e\x2e", "\x44\x69\150\141\x72\141\160\153\141\156\40\155\x65\x72\165\142\x61\150\40\160\145\156\x61\155\x70\x69\x6c\141\156\156\x79\x61\x20\155\145\x6e\152\141\144\151\x20\154\x65\x62\151\x68\x20\x72\141\160\x69\54\x20\163\x65\x70\145\x72\x74\x69\x20\x74\x65\x6e\x74\141\156\x67\x20\x70\157\164\x6f\x6e\x67\40\x72\x61\x6d\x62\165\x74\x20\x64\141\156\x20\143\x61\162\x61\40\142\x65\162\160\x61\x6b\x61\x69\x61\x6e\56", "\x4d\141\x73\x69\x68\40\160\145\x72\x6c\165\40\155\x65\x6d\160\x65\162\x62\x61\156\171\141\153\x20\164\x65\x6d\141\x6e\40\142\x65\x72\147\x61\x75\154\40\x64\141\x6e\x20\164\145\x6d\x61\156\40\x64\x69\163\153\x75\x73\151\54\40\153\165\x72\141\156\147\x69\40\x61\153\164\151\x66\x69\164\x61\163\40\155\145\156\x79\x65\x6e\x64\x69\162\151\56", "\x44\151\150\x61\x72\141\160\x6b\141\156\40\x64\x61\160\x61\x74\40\x6d\145\x6e\x69\156\x67\x6b\141\x74\153\141\x6e\40\153\157\x6d\151\164\x6d\x65\156\156\x79\x61\x20\165\156\x74\x75\153\40\x6c\x65\142\151\150\x20\x73\x65\x72\x69\x75\163\40\x73\x61\x61\x74\x20\x6d\x65\x6e\147\145\x72\x6a\x61\x6b\141\156\40\164\x75\147\141\x73\40\144\141\x6e\x20\x74\151\x64\x61\153\40\x6d\x75\144\x61\150\x20\x6d\145\156\171\145\x72\141\x68\x2e"]; } public function getDummyDeskripsiRanking() { return ["\x50\162\145\163\164\141\163\151\x6e\171\x61\40\x73\x61\x6e\147\141\164\x20\142\141\151\153\x2c\x20\160\x65\x72\154\x75\40\x64\151\x70\145\x72\164\141\150\141\x6e\153\141\156\x2e", "\120\162\x65\x73\164\141\163\x69\40\142\x61\x69\153\54\40\160\x65\162\x6c\x75\40\144\x69\160\145\x72\164\141\150\141\156\153\141\x6e\40\x64\141\x6e\x20\144\x74\151\x6e\x67\153\x61\164\x6b\x61\x6e\x2e", "\x50\x72\145\163\164\141\x73\x69\x20\x63\165\x6b\x75\160\x2c\x20\160\145\162\154\x75\x20\x64\x69\164\x69\156\147\153\141\164\153\141\156\x20\x62\145\154\x61\152\x61\162\x20\x64\141\156\x20\x62\145\x72\144\x6f\x61\56", "\x50\x65\162\154\x75\x20\x64\x69\164\x69\x6e\147\153\x61\164\153\141\156\x20\142\x65\x6c\141\x6a\141\162\156\x79\141\54\40\x6a\x61\156\x67\141\156\x20\x6c\x75\160\141\x20\142\x65\162\144\x6f\141\56", "\120\145\162\154\165\40\x64\151\x6d\141\x6b\x73\151\155\141\x6c\x6b\141\156\40\142\x65\x6c\141\x6a\x61\162\156\x79\x61\54\x20\165\163\x61\150\x61\x20\x6b\x65\x72\x61\x73\40\x64\141\x6e\40\142\145\162\144\157\141\x2e", "\120\x65\x72\x6c\x75\40\165\163\x61\x68\141\x20\x6b\145\x72\141\163\54\x20\155\x61\x6b\x73\151\x6d\x61\154\153\141\x6e\x20\142\145\154\x61\x6a\141\162\156\x79\141\x2c\x20\x6c\x65\x62\x69\150\40\x67\x69\141\164\40\x62\145\x72\x64\157\x61\40\x64\141\x6e\40\x62\x65\162\x69\142\141\144\x61\150\56"]; } public function getDummyDeskripsiFisik($jenis) { goto eo1rX; DamU5: ZYsRI: goto TnDJl; rxV9Y: jkRqj: goto b_dUN; MwUtE: return ["\x42\x61\x69\x6b\x2c\x20\156\141\155\160\x61\153\40\160\x75\164\151\150\40\x64\141\x6e\x20\x62\145\x72\163\151\x68", "\x54\145\x72\144\141\x70\141\x74\x20\147\151\x67\151\x20\171\x61\x6e\x67\40\147\x69\x67\x69\x73", "\113\x65\x62\145\162\x73\x69\x68\141\x6e\x20\147\x69\147\x69\40\x6b\165\162\x61\156\x67\40\164\145\x72\152\141\147\x61", "\101\x64\141\40\147\x69\147\x69\x20\x79\x61\156\x67\40\x6d\141\165\40\x74\x61\x6e\x67\147\141\x6c"]; goto rxV9Y; KaWx4: goto jkRqj; goto ttkfx; kQ0tr: return ["\x42\x61\x69\153", "\123\x65\162\x69\156\147\40\142\x65\x72\x61\x69\162", "\113\x75\x72\x61\156\x67\40\x6a\145\154\x61\x73\x20\152\x69\153\x61\40\x6d\x65\x6c\x69\150\x61\x74\40\x6a\141\162\141\153\40\x6a\141\x75\150", '']; goto MsEcq; VnUmx: return ["\124\x75\142\x75\150\x20\x73\x65\150\x61\x74\40\144\x61\156\x20\153\165\141\x74", "\x4d\x75\144\141\x68\x20\153\x65\143\x61\160\x65\153\141\156", "\113\145\x62\145\x72\163\x69\x68\141\156\40\x62\141\144\x61\156\x20\x6b\x75\x72\x61\x6e\147\40\x74\x65\162\x6a\x61\x67\x61", '']; goto JM9bh; ttkfx: zNv_U: goto kQ0tr; DKBu2: eBIkQ: goto MwUtE; eo1rX: if ($jenis == "\x31") { goto ZYsRI; } goto oVxb4; MsEcq: goto jkRqj; goto DKBu2; TnDJl: return ["\x42\x61\x69\x6b", "\x4b\x75\162\x61\x6e\147\x20\x70\x65\153\141", "\124\145\154\151\x6e\x67\141\40\160\x65\x72\154\165\40\144\x69\142\145\x72\163\151\x68\153\141\156", '']; goto KaWx4; JM9bh: goto jkRqj; goto DamU5; oVxb4: if ($jenis == "\62") { goto zNv_U; } goto iCJb7; iCJb7: if ($jenis == "\x33") { goto eBIkQ; } goto VnUmx; b_dUN: } public function getKenaikanSiswa($id_kelas, $id_tp, $id_smt, $level = null) { goto cu0fK; AfbXH: $this->db->where("\143\x2e\154\145\x76\x65\x6c\137\151\144", $level); goto GQGu0; cu0fK: $this->db->query("\123\105\124\40\123\121\114\x5f\102\x49\107\x5f\123\105\114\x45\x43\124\x53\75\x31"); goto I3jin; mGM0V: $this->db->where("\141\56\151\144\137\x73\x6d\164", $id_smt); goto m4msC; tW6kr: $this->db->join("\155\x61\x73\x74\145\x72\137\x73\151\163\167\x61\x20\142", "\141\56\151\144\x5f\x73\x69\163\x77\x61\75\142\56\151\x64\137\163\151\x73\167\141", "\x6c\x65\x66\164"); goto F9SrP; J3o62: if (!($level != null)) { goto mMg9u; } goto AfbXH; m4msC: return $this->db->get()->result(); goto UGb8t; hc8jg: if (!($id_kelas != null)) { goto lqJ4k; } goto hpjOO; GQGu0: mMg9u: goto hc8jg; F9SrP: $this->db->join("\155\x61\163\164\x65\162\137\153\x65\x6c\x61\163\40\143", "\x61\56\x69\x64\x5f\153\145\154\x61\163\75\x63\x2e\151\144\x5f\153\x65\x6c\x61\163", "\x6c\145\x66\x74"); goto Lads8; rJUIn: $this->db->from("\153\x65\x6c\x61\x73\x5f\x73\x69\x73\x77\141\40\x61"); goto tW6kr; I3jin: $this->db->select("\x61\56\x2a\54\x20\x62\56\156\141\x6d\141\54\40\142\x2e\156\x69\x73\54\x20\x62\x2e\x6e\151\x73\x6e\54\x20\142\56\x75\x73\145\162\156\141\x6d\x65\54\40\143\x2e\x69\144\137\x6b\x65\154\141\x73\x2c\x20\143\56\156\x61\155\141\137\x6b\145\x6c\141\163\54\40\143\x2e\154\145\x76\145\154\137\151\144\x2c\40\144\x2e\156\141\x69\153"); goto rJUIn; hpjOO: $this->db->where("\x61\56\x69\x64\137\153\x65\x6c\141\163", $id_kelas); goto oSB2d; oSB2d: lqJ4k: goto Vd8QA; Lads8: $this->db->join("\x72\x61\160\157\162\x5f\156\x61\151\153\x20\x64", "\141\56\151\x64\x5f\163\151\x73\x77\141\75\x64\56\x69\x64\x5f\163\151\163\x77\141\x20\x41\x4e\104\40\141\56\151\144\137\x74\x70\75\144\56\x69\x64\x5f\164\x70\x20\x41\116\104\40\141\56\x69\144\x5f\x73\x6d\164\75\144\x2e\x69\144\x5f\x73\155\164", "\154\145\146\x74"); goto J3o62; Vd8QA: $this->db->where("\141\x2e\x69\144\x5f\x74\160", $id_tp); goto mGM0V; UGb8t: } public function getSiswaLulus($id_tp, $id_smt, $level) { goto IruoW; kP3y3: $this->db->where("\141\56\151\144\x5f\163\x6d\164", $id_smt); goto klR2u; KZcsN: $this->db->join("\x6d\141\x73\164\x65\162\x5f\163\151\163\x77\141\x20\x62", "\x61\x2e\x69\144\x5f\163\x69\163\x77\141\75\142\x2e\151\x64\x5f\163\x69\x73\167\x61", "\x6c\x65\146\x74"); goto YKb_Q; klR2u: return $this->db->get()->result(); goto OtVq0; eQWvF: $this->db->where("\141\56\151\x64\x5f\x74\160", $id_tp); goto kP3y3; mqle4: $this->db->from("\x6b\x65\x6c\141\163\137\x73\x69\x73\167\x61\40\x61"); goto KZcsN; LwwNF: $this->db->join("\x72\x61\x70\157\x72\137\x6e\141\151\x6b\40\x64", "\141\56\x69\x64\137\163\x69\163\167\x61\75\x64\56\x69\x64\137\x73\151\x73\x77\x61\x20\101\116\104\x20\141\x2e\151\144\137\x74\160\75\144\56\x69\x64\x5f\164\160\x20\x41\116\x44\x20\x61\x2e\151\x64\x5f\163\x6d\164\75\144\x2e\151\x64\x5f\163\x6d\164", "\x6c\x65\x66\x74"); goto C6vxb; C6vxb: $this->db->where("\x63\x2e\154\x65\166\x65\x6c\x5f\x69\144", $level); goto eQWvF; IruoW: $this->db->query("\x53\105\124\x20\x53\x51\114\x5f\102\x49\x47\x5f\123\x45\114\105\103\x54\x53\x3d\61"); goto VTIBk; YKb_Q: $this->db->join("\155\141\x73\164\x65\x72\137\153\145\x6c\141\x73\x20\143", "\x61\x2e\151\x64\x5f\153\x65\154\x61\x73\75\143\x2e\x69\144\137\153\x65\x6c\141\163", "\154\145\146\164"); goto LwwNF; VTIBk: $this->db->select("\x62\x2e\52\x2c\x20\x63\x2e\156\x61\x6d\x61\137\x6b\145\154\x61\x73\40\x61\x73\x20\x6b\145\154\x61\x73\137\141\153\x68\151\162\x2c\40\144\x2e\156\141\151\x6b"); goto mqle4; OtVq0: } public function getJumlahLulus($id_tp, $id_smt, $level) { goto o8C78; o8C78: $this->db->query("\123\105\124\x20\x53\x51\x4c\x5f\x42\x49\107\137\123\105\114\105\x43\x54\x53\75\x31"); goto z54u2; z54u2: $this->db->select("\x61\x2e\52\54\x20\x62\x2e\156\141\x6d\x61\x2c\40\x62\x2e\156\x69\163\54\40\x62\56\156\151\163\156\x2c\x20\142\56\x75\163\x65\x72\x6e\141\x6d\145\54\40\x63\x2e\151\144\137\153\145\x6c\x61\x73\x2c\40\x63\x2e\x6e\141\x6d\141\137\153\x65\154\141\x73\x2c\x20\x63\56\154\x65\166\x65\154\137\151\144\54\40\x64\56\x6e\141\x69\153"); goto iyidO; fKcVN: return $this->db->count_all_results(); goto AANQn; vX16V: $this->db->join("\155\141\x73\164\145\x72\137\x6b\x65\x6c\x61\x73\40\x63", "\141\56\151\x64\137\x6b\145\154\141\163\75\143\x2e\x69\x64\x5f\153\x65\154\x61\163", "\x6c\x65\146\164"); goto uOv3O; uOv3O: $this->db->join("\162\x61\160\157\162\x5f\156\x61\x69\x6b\40\144", "\x61\56\x69\x64\137\x73\151\x73\167\x61\x3d\144\56\x69\x64\x5f\163\151\x73\167\x61\x20\x41\x4e\104\40\141\56\x69\x64\x5f\164\160\x3d\144\x2e\x69\144\137\164\x70\x20\101\116\104\40\x61\56\151\144\137\x73\155\164\75\x64\56\151\144\x5f\x73\x6d\x74", "\154\145\x66\x74"); goto Uy8Nh; GhdGJ: $this->db->where("\x61\x2e\151\x64\x5f\164\160", $id_tp); goto seMSX; seMSX: $this->db->where("\141\56\151\144\137\163\155\164", $id_smt); goto fKcVN; iyidO: $this->db->from("\153\145\154\x61\x73\x5f\163\x69\163\167\141\40\x61"); goto vX16V; Uy8Nh: $this->db->where("\x63\56\154\x65\x76\145\x6c\x5f\151\144", $level); goto GhdGJ; AANQn: } public function getKenaikanRapor($id_kelas, $id_tp, $id_smt) { goto LtnqF; U582Q: $this->db->from("\x6b\x65\x6c\141\x73\137\x73\x69\163\x77\141\40\x61"); goto kHIvT; ZPxqN: foreach ($ress as $res) { $ret[$res->id_siswa] = $res->naik; c5Uq8: } goto zFVha; zFVha: iv7tt: goto Q5D0Y; F48Og: $this->db->where("\141\56\x69\x64\137\163\x6d\x74", $id_smt); goto j2_Au; yG1tU: $ret = []; goto ZPxqN; Yg1_T: $this->db->where("\x61\56\151\x64\137\153\x65\x6c\141\x73", $id_kelas); goto E2dK3; Q5D0Y: return $ret; goto h0PMz; kHIvT: $this->db->join("\x72\x61\160\x6f\162\x5f\x6e\141\151\x6b\x20\144", "\141\56\151\144\137\x73\151\x73\x77\x61\x3d\144\56\151\x64\x5f\163\x69\163\167\141\x20\x41\116\104\x20\x61\x2e\151\x64\x5f\164\x70\75\x64\x2e\x69\144\x5f\x74\160\40\x41\x4e\x44\40\x61\x2e\x69\x64\137\x73\x6d\x74\75\144\x2e\151\x64\137\x73\x6d\x74", "\154\x65\146\164"); goto Yg1_T; LtnqF: $this->db->select("\x61\x2e\x69\144\137\x6b\145\154\x61\x73\x2c\40\141\56\x69\x64\137\x73\151\x73\167\x61\54\x20\x64\56\x6e\141\151\153"); goto U582Q; E2dK3: $this->db->where("\141\x2e\151\x64\137\164\x70", $id_tp); goto F48Og; j2_Au: $ress = $this->db->get()->result(); goto yG1tU; h0PMz: } public function getAllRaporSetting() { goto ARZJH; ARZJH: $result = $this->db->get("\162\141\x70\x6f\x72\x5f\x61\x64\155\151\156\137\x73\x65\x74\164\x69\x6e\147")->result(); goto foBsI; v3E7j: foreach ($result as $key => $row) { $ret[$row->id_tp][$row->id_smt] = $row; oQeRX: } goto jfYPR; jfYPR: Dr4Ib: goto nishW; foBsI: $ret = []; goto gOc1l; gOc1l: if (!$result) { goto uudew; } goto v3E7j; CL4XG: return $ret; goto ck_NZ; nishW: uudew: goto CL4XG; ck_NZ: } public function getAllKkm() { goto m5V5P; FOdqx: return $ret; goto hju7A; m5V5P: $result = $this->db->get("\x72\141\160\x6f\162\137\153\x6b\x6d")->result(); goto jq1PQ; R18ed: oRC5Q: goto FOdqx; Q9aM2: foreach ($result as $res) { $ret[$res->id_tp][$res->id_smt][$res->id_kelas][$res->jenis][$res->id_mapel] = $res; HvK2i: } goto R18ed; jq1PQ: $ret = []; goto Q9aM2; hju7A: } public function getAllKkmRaporAkhir($kelas, $id_tp, $id_smt) { goto T5336; mLHYQ: $result = $this->db->get("\162\141\x70\x6f\x72\137\153\x6b\x6d")->result(); goto uTB24; ahqX1: foreach ($result as $res) { $ret[$res->jenis][$res->id_mapel] = $res; UVIbY: } goto sflIa; T5336: $this->db->where("\x69\x64\x5f\153\x65\154\141\163", $kelas)->where("\x69\x64\137\164\x70", $id_tp)->where("\x69\x64\137\163\155\x74", $id_smt); goto mLHYQ; uTB24: $ret = []; goto ahqX1; sflIa: DmoJd: goto Ur2mR; Ur2mR: return $ret; goto ZanT9; ZanT9: } public function getAllNilaiAkhir() { goto J7IWY; Jb8EF: return $ret; goto p71dk; H8w71: $ret = []; goto vsO5B; gTbkP: $this->db->select("\141\56\151\144\x5f\164\x70\54\40\x61\x2e\151\x64\x5f\x73\155\x74\54\x20\141\x2e\x69\144\137\x73\x69\163\x77\141\54\x20\x61\x2e\160\x5f\x72\x61\164\x61\137\x72\x61\164\x61\40\x61\x73\40\156\x68\x61\x72\x2c\40\141\x2e\x70\137\144\145\x73\x6b\162\151\160\163\x69\54\40\x61\56\153\x5f\162\x61\x74\141\137\x72\x61\x74\141\x2c" . "\40\141\x2e\x6b\x5f\160\162\x65\144\151\x6b\x61\164\54\x20\141\56\x6b\x5f\144\x65\x73\x6b\162\x69\x70\163\x69\54\40\x62\x2e\156\x69\x6c\141\151\40\141\x73\40\x6e\x70\x74\x73\x2c\40\143\x2e\x6e\151\x6c\141\151\x20\141\163\40\x6e\x70\141\x73\x2c\x20\143\56\160\162\145\x64\151\153\x61\164"); goto S8Bjq; S8Bjq: $this->db->from("\x72\x61\160\157\162\x5f\156\151\x6c\141\151\137\x68\141\x72\x69\x61\156\40\x61"); goto eAMTH; E3UJZ: tlAZk: goto Jb8EF; eAMTH: $this->db->join("\162\141\160\157\x72\137\x6e\151\x6c\141\151\137\160\x74\163\x20\x62", "\142\56\151\144\137\156\x69\x6c\141\x69\137\160\x74\x73\75\x61\x2e\151\144\x5f\x6e\x69\x6c\x61\151\137\150\141\x72\x69\x61\x6e", "\x6c\x65\x66\164"); goto Bu6Ur; Bu6Ur: $this->db->join("\x72\141\x70\x6f\x72\137\156\151\x6c\141\151\137\141\x6b\150\151\x72\x20\x63", "\143\56\x69\x64\137\156\151\x6c\141\151\137\141\x6b\x68\151\x72\x3d\141\56\x69\x64\137\x6e\151\154\141\x69\137\x68\141\x72\x69\x61\156", "\154\145\146\x74"); goto bp6JB; vsO5B: foreach ($result as $res) { $ret[$res->id_tp][$res->id_smt][$res->id_siswa] = $res; URIIA: } goto E3UJZ; J7IWY: $this->db->query("\123\x45\x54\x20\123\121\x4c\137\x42\111\x47\x5f\x53\x45\114\105\103\124\x53\75\61"); goto gTbkP; bp6JB: $result = $this->db->get()->result(); goto H8w71; p71dk: } public function getDistinctTahunBukuNilai() { goto Polwk; wq_3U: foreach ($result as $row) { $ret[$row->tp] = $row->tp; bl_Jo: } goto lMnGc; OMcBv: $result = $this->db->get("\x62\x75\153\165\x5f\156\x69\x6c\141\151")->result(); goto l5BST; Polwk: $this->db->select("\164\x70"); goto vsXzU; l5BST: $ret = []; goto wq_3U; lMnGc: noUbV: goto SStrw; vsXzU: $this->db->distinct(); goto OMcBv; SStrw: return $ret; goto mo7xz; mo7xz: } public function getDistinctSmtBukuNilai() { goto WDG_l; NcwfA: return $ret; goto jTrBv; ORYmH: $this->db->distinct(); goto YEZNR; m12Mz: ELuZB: goto NcwfA; YEZNR: $result = $this->db->get("\142\165\153\x75\137\156\x69\154\141\x69")->result(); goto wRspo; whqrJ: foreach ($result as $row) { $ret[$row->smt] = $row->smt; RWnYv: } goto m12Mz; WDG_l: $this->db->select("\163\x6d\x74"); goto ORYmH; wRspo: $ret = []; goto whqrJ; jTrBv: } public function getDistinctKelasBukuNilai() { goto YF4sK; dzdkw: $result = $this->db->get("\142\165\153\x75\x5f\x6e\151\x6c\141\x69")->result(); goto dJ4Jj; K08qQ: foreach ($result as $row) { $ret[$row->kelas] = $row->kelas; CRtE_: } goto nnKpf; ftvtg: return $ret; goto Izepx; nnKpf: kcR_K: goto ftvtg; YF4sK: $this->db->select("\x6b\145\154\x61\x73"); goto b3Lkq; b3Lkq: $this->db->distinct(); goto dzdkw; dJ4Jj: $ret = []; goto K08qQ; Izepx: } public function getFisikBySiswa($id_siswa) { goto xknVn; kMlkK: z9dTD: goto NjZBm; xknVn: $this->db->select("\164\x70\x2c\40\x66\151\x73\151\x6b"); goto rAd7s; GbHEj: $ret = []; goto OxUZB; p8d34: KXjEn: goto kMlkK; NjZBm: return $ret; goto myzJK; rAd7s: $this->db->from("\142\165\x6b\x75\x5f\156\151\154\x61\151"); goto Ueiij; OxUZB: if (!$result) { goto z9dTD; } goto Qp2c1; Ueiij: $this->db->where("\151\x64\x5f\163\x69\163\167\x61", $id_siswa); goto Fn9TM; Fn9TM: $result = $this->db->get()->result(); goto GbHEj; Qp2c1: foreach ($result as $key => $row) { $ret[$row->tp] = $row; wXS9G: } goto p8d34; myzJK: } public function getDataKumpulanRapor($kelas = null, $tp = null, $smt = null) { goto I2SlF; Ujl3d: $this->db->where("\141\x2e\153\x65\x6c\141\163", $kelas); goto SzSfE; Mqf6r: if (!($kelas != null)) { goto U3N53; } goto Ujl3d; ilJGb: foreach ($result as $key => $row) { $ret[$row->id_siswa] = $row; EWxcx: } goto oihEI; aUGO7: ghRvl: goto OyBVk; R7a28: Xn_QY: goto K3uOZ; RwGQ5: $ret = []; goto UA6eR; E0NGS: if (!($tp != null)) { goto ghRvl; } goto P3BLc; d9pA4: $this->db->join("\155\x61\163\164\145\162\x5f\163\x69\163\167\141\x20\142", "\x61\56\151\x64\137\163\151\163\x77\141\75\x62\56\151\x64\x5f\x73\x69\x73\167\x61"); goto E0NGS; UA6eR: if (!$result) { goto Xn_QY; } goto ilJGb; Fck1i: T7CMA: goto Mqf6r; I2SlF: $this->db->select("\52"); goto b3ZR0; vh2WF: $result = $this->db->get()->result(); goto RwGQ5; MFwJG: $this->db->where("\141\56\163\x6d\164", $smt); goto Fck1i; b3ZR0: $this->db->from("\142\165\x6b\x75\x5f\x6e\x69\x6c\x61\x69\40\141"); goto d9pA4; K3uOZ: return $ret; goto usrGB; oihEI: gFPX0: goto R7a28; SzSfE: U3N53: goto vh2WF; P3BLc: $this->db->where("\x61\56\164\160", $tp); goto aUGO7; OyBVk: if (!($smt != null)) { goto T7CMA; } goto MFwJG; usrGB: } public function deleteNilaiRapor() { goto C4kss; o7p1Y: $this->db->empty_table("\162\x61\160\x6f\x72\137\x66\151\163\x69\x6b"); goto WKAgG; WNI2Y: $this->db->empty_table("\x72\141\160\x6f\x72\137\143\x61\x74\x61\x74\x61\156\137\167\141\154\x69"); goto o7p1Y; hIoEy: $this->db->empty_table("\162\141\x70\157\x72\137\x6e\x69\x6c\141\x69\137\x61\x6b\150\x69\162"); goto VEtc0; X8htk: $this->db->empty_table("\162\141\x70\157\x72\137\x6e\x69\x6c\x61\x69\137\x73\151\153\141\x70"); goto OjG4e; p9_dq: $this->db->empty_table("\x72\141\160\157\162\x5f\160\162\145\163\x74\141\163\x69"); goto WNI2Y; z399Y: $this->db->empty_table("\162\141\x70\157\x72\x5f\156\151\x6c\x61\151\x5f\160\x74\x73"); goto p9_dq; C4kss: $this->db->empty_table("\162\141\160\157\x72\x5f\156\x69\x6c\x61\x69\x5f\x68\141\x72\151\141\156"); goto hIoEy; WKAgG: $this->db->empty_table("\x72\141\160\x6f\x72\x5f\x6e\151\154\x61\x69\x5f\x65\153\163\x74\162\x61"); goto X8htk; VEtc0: $this->db->empty_table("\162\x61\x70\x6f\162\x5f\156\141\151\153"); goto z399Y; OjG4e: } public function getAllNilaiRapor($ids_siswa = null) { goto cU4_M; S2SIz: return $result; goto STPlD; uoSK3: $this->db->join("\155\141\x73\x74\145\162\x5f\164\x70\x20\x63", "\143\x2e\x69\x64\x5f\x74\160\x3d\141\56\151\144\x5f\164\160", "\x6c\x65\146\164"); goto QIqAk; QIqAk: $this->db->join("\155\141\163\164\145\162\x5f\163\155\164\40\x64", "\144\56\151\144\137\x73\x6d\164\x3d\x61\56\151\x64\x5f\163\155\164", "\x6c\145\x66\x74"); goto LEPk6; N5nvw: $this->db->join("\152\141\x62\x61\x74\141\x6e\x5f\x67\x75\162\x75\x20\x6a", "\141\x2e\x69\x64\137\x6b\x65\154\141\163\75\152\56\x69\144\x5f\153\x65\x6c\x61\163\40\x41\116\x44\40\x61\x2e\x69\x64\137\x74\160\75\152\56\151\144\x5f\x74\x70\x20\101\116\x44\x20\x61\x2e\x69\144\x5f\x73\155\164\75\x6a\x2e\x69\x64\x5f\x73\x6d\x74", "\154\x65\146\164"); goto FziLD; cU4_M: $this->db->query("\x53\105\124\40\123\x51\x4c\x5f\102\x49\107\x5f\123\105\114\105\x43\124\x53\75\x31"); goto Ak67I; LEPk6: $this->db->join("\155\x61\x73\164\145\x72\x5f\x73\x69\163\x77\141\x20\x65", "\145\56\x69\x64\x5f\x73\151\163\167\x61\x3d\141\56\151\x64\137\163\151\x73\167\x61", "\154\x65\146\164"); goto IF5UY; IF5UY: $this->db->join("\x72\141\x70\157\162\137\156\x61\151\x6b\40\146", "\x61\56\151\144\x5f\163\151\163\x77\x61\75\146\56\x69\x64\137\163\151\x73\167\x61\x20\x41\116\x44\x20\141\56\x69\144\x5f\x74\x70\75\x66\x2e\151\x64\137\x74\x70\40\x41\x4e\104\x20\x61\56\151\144\137\163\155\164\75\146\56\151\144\x5f\163\x6d\164", "\154\x65\x66\164"); goto ACppY; z27W0: $this->db->join("\162\141\160\157\162\137\156\151\154\141\151\x5f\x61\153\150\151\162\40\x62", "\x62\x2e\151\144\x5f\x6e\x69\154\x61\151\x5f\141\x6b\150\x69\162\75\141\x2e\151\x64\x5f\x6e\x69\x6c\141\151\x5f\x68\x61\162\x69\x61\156", "\154\x65\146\x74"); goto uoSK3; j2Wdj: $result = $this->db->get()->result(); goto S2SIz; H0P8y: $this->db->join("\155\141\163\x74\145\x72\x5f\x6d\x61\x70\145\154\40\x70", "\x61\x2e\x69\144\137\x6d\x61\160\x65\x6c\75\x70\56\151\x64\x5f\x6d\x61\160\x65\154", "\154\145\146\x74"); goto mlRWF; iSDXX: $this->db->from("\x72\x61\x70\x6f\162\137\156\151\154\141\151\137\x68\x61\x72\x69\x61\156\x20\141"); goto z27W0; FziLD: $this->db->join("\155\141\x73\x74\145\162\x5f\147\x75\162\165\40\x6b", "\x6a\x2e\151\144\x5f\x67\x75\x72\x75\75\x6b\56\x69\144\x5f\147\165\162\165", "\154\145\x66\x74"); goto HGm7F; pa43h: $this->db->join("\155\141\x73\x74\145\x72\x5f\153\145\x6c\141\x73\x20\150", "\x61\x2e\x69\144\137\x6b\145\154\x61\163\x3d\150\56\x69\x64\x5f\153\145\154\141\163\x20\101\x4e\104\40\141\56\151\144\x5f\164\x70\x3d\x68\56\151\x64\x5f\164\x70\40\x41\116\x44\40\x61\56\151\144\137\163\155\x74\75\150\x2e\151\144\137\x73\155\164", "\x6c\x65\146\x74"); goto SyckZ; SyckZ: $this->db->join("\155\141\163\x74\145\162\137\152\x75\162\165\163\x61\156\40\151", "\x68\56\x6a\x75\162\x75\163\141\156\x5f\x69\144\75\151\x2e\151\x64\x5f\x6a\165\x72\x75\x73\x61\x6e", "\x6c\x65\146\x74"); goto N5nvw; HGm7F: $this->db->join("\x72\x61\x70\157\162\137\x70\x72\x65\163\164\x61\x73\x69\40\154", "\x61\x2e\x69\144\137\x73\151\163\167\x61\x3d\154\56\x69\x64\137\163\x69\163\167\x61\x20\101\x4e\x44\40\141\x2e\151\144\137\164\x70\75\x6c\56\x69\144\137\x74\x70\40\101\116\x44\40\x61\56\151\144\137\163\x6d\164\x3d\154\56\151\x64\137\163\155\x74", "\x6c\145\146\x74"); goto OYQsn; kt8wY: $this->db->join("\162\141\x70\x6f\x72\137\146\x69\x73\151\x6b\x20\156", "\x61\56\x69\x64\137\x73\x69\163\x77\141\x3d\x6e\x2e\x69\144\137\x73\151\163\x77\141\x20\x41\x4e\x44\x20\x61\56\x69\x64\x5f\x74\160\75\156\56\151\x64\137\164\x70\x20\x41\x4e\x44\x20\x61\x2e\x69\144\x5f\163\x6d\x74\75\156\56\151\x64\137\x73\155\x74", "\154\145\x66\x74"); goto H0P8y; liIee: qVaLO: goto j2Wdj; D4d5v: $this->db->where_in("\x61\x2e\x69\x64\137\163\151\x73\167\141", $ids_siswa); goto liIee; ACppY: $this->db->join("\162\x61\160\x6f\x72\137\156\151\x6c\141\x69\137\x70\x74\163\x20\147", "\x67\x2e\151\144\x5f\x6e\151\154\141\x69\137\160\x74\163\x3d\x61\56\151\144\137\156\x69\x6c\x61\151\x5f\x68\x61\x72\151\141\x6e", "\154\x65\x66\164"); goto pa43h; mlRWF: if (!($ids_siswa != null)) { goto qVaLO; } goto D4d5v; Ak67I: $this->db->select("\141\56\151\x64\137\x74\x70\54\40\x61\x2e\151\x64\137\x73\x6d\164\x2c\x20\141\56\x69\x64\x5f\x6d\141\160\x65\154\54\40\x61\56\151\x64\137\x73\x69\x73\167\x61\x2c\x20\x61\x2e\160\x5f\162\141\164\x61\x5f\162\141\x74\141\x2c\40\x61\x2e\x70\x5f\x70\x72\x65\144\151\153\141\164\54\40\141\56\160\x5f\144\145\x73\153\162\x69\160\x73\151\54" . "\40\141\x2e\153\137\x72\141\164\141\x5f\x72\x61\x74\x61\54\40\x61\x2e\x6b\x5f\x70\x72\x65\x64\x69\153\x61\164\54\x20\141\x2e\x6b\137\x64\145\163\153\162\x69\x70\163\x69\x2c" . "\40\x62\x2e\156\151\x6c\141\x69\40\141\163\40\x6e\x69\x6c\141\151\137\160\x61\x73\54\40\142\56\x61\153\x68\x69\x72\x20\141\x73\x20\156\151\x6c\141\151\137\162\141\160\x6f\162\x2c\x20\142\x2e\x70\x72\145\144\151\x6b\141\x74\40\x61\x73\40\x72\x61\160\x6f\x72\x5f\160\162\x65\x64\151\x6b\141\164\54" . "\40\143\56\x2a\x2c\40\144\x2e\x2a\54\40\x65\56\40\156\x61\x6d\x61\x2c\40\145\x2e\165\x69\144\x2c\x20\x66\x2e\156\141\x69\x6b\54" . "\x20\x67\x2e\156\x69\x6c\x61\x69\x20\x61\x73\40\156\151\154\x61\151\x5f\x70\x74\x73\54\x20\147\56\160\162\145\x64\151\153\141\164\x20\x61\163\40\160\x74\163\137\x70\x72\145\144\151\x6b\141\x74\x2c" . "\x20\x68\56\40\151\x64\x5f\153\x65\x6c\141\163\x2c\x20\x68\x2e\x6e\141\155\x61\137\x6b\x65\x6c\x61\x73\x2c\x20\150\56\154\145\166\x65\154\x5f\x69\144\54\40\151\x2e\156\141\155\x61\137\152\165\162\165\x73\141\156\x2c\40\x6b\56\156\x61\x6d\141\x5f\147\x75\162\x75\x2c" . "\x20\x6c\x2e\x72\141\x6e\153\x69\x6e\147\x2c\x20\x6c\56\x64\x65\x73\153\x72\x69\x70\163\151\40\x61\163\x20\x72\x61\x6e\153\137\144\x65\163\x6b\162\x69\160\x73\151\54\40\x6c\x2e\x70\61\x2c\x20\x6c\56\x70\61\x5f\144\x65\x73\153\x2c\40\154\56\160\x32\54\40\154\x2e\160\x32\x5f\x64\145\163\153\54\x20\154\56\x70\63\54\x20\154\x2e\160\63\137\144\145\163\x6b\54" . "\x20\155\56\x6e\151\154\x61\x69\40\141\163\40\141\142\163\145\156\54\x20\155\56\144\145\163\x6b\x72\151\x70\163\x69\40\x61\163\x20\x73\x61\162\141\156\54\x20\156\x2e\153\x6f\156\144\151\x73\x69\54\40\156\56\x74\x69\x6e\147\147\x69\x2c\x20\x6e\x2e\x62\x65\162\x61\x74\54\40\x70\56\153\157\x64\145\40\x61\163\x20\x6d\141\160\145\154"); goto iSDXX; OYQsn: $this->db->join("\162\141\x70\157\x72\137\x63\141\x74\141\164\x61\x6e\x5f\167\x61\154\x69\x20\x6d", "\x61\56\151\144\x5f\x73\x69\x73\167\x61\x3d\x6d\56\151\x64\137\x73\151\163\x77\x61\x20\101\116\x44\x20\141\x2e\x69\x64\x5f\x74\x70\x3d\x6d\x2e\151\x64\137\164\160\x20\x41\x4e\x44\x20\141\56\x69\x64\x5f\x73\155\164\75\155\56\x69\x64\x5f\163\155\164", "\154\x65\146\164"); goto kt8wY; STPlD: } public function getAllEkstra() { goto P0XXp; xi379: $this->db->from("\x6b\145\x6c\x61\163\137\x65\x6b\163\x74\x72\141"); goto mY4Q6; KZX6E: foreach ($result as $key => $row) { $ret[$row->id_tp][$row->id_smt][$row->id_kelas] = unserialize($row->ekstra); nwhEf: } goto ybvL9; HzrnG: $ret = []; goto S2eQl; S2eQl: if (!$result) { goto GWE5A; } goto KZX6E; YYyMU: return $ret; goto q05bH; ybvL9: L9MWy: goto iBVu8; iBVu8: GWE5A: goto YYyMU; P0XXp: $this->db->select("\x2a"); goto xi379; mY4Q6: $result = $this->db->get()->result(); goto HzrnG; q05bH: } public function getAllNilaiEkstra($ids_siswa = null) { goto RxkhW; DA65u: $this->db->where_in("\x61\56\x69\144\137\x73\x69\163\167\x61", $ids_siswa); goto NRa9M; RxkhW: $this->db->select("\141\56\x2a\x2c\x20\x62\x2e\156\x61\155\141\137\145\x6b\163\x74\x72\x61\54\x20\x62\x2e\x6b\157\144\x65\137\145\x6b\163\164\162\x61"); goto QDOqT; K39Qw: foreach ($result as $res) { $ret[$res->id_tp][$res->id_smt][$res->id_siswa][] = $res; vhlkw: } goto fQ15a; KJd5r: if (!($ids_siswa != null)) { goto ZnJFP; } goto DA65u; QDOqT: $this->db->from("\162\x61\160\157\162\137\x6e\x69\x6c\141\x69\137\145\153\163\164\162\x61\x20\141"); goto v3NyD; jHIzA: return $ret; goto aUqG2; v3NyD: $this->db->join("\155\141\163\164\145\x72\137\x65\x6b\x73\x74\x72\x61\x20\x62", "\141\56\151\144\137\145\x6b\x73\164\162\x61\75\x62\56\151\x64\137\x65\x6b\163\164\x72\141", "\154\145\146\164"); goto KJd5r; fQ15a: KYCim: goto jHIzA; NRa9M: ZnJFP: goto omd8l; s3SQb: $ret = []; goto K39Qw; omd8l: $result = $this->db->get()->result(); goto s3SQb; aUqG2: } public function getAllNilaiSikap($ids_siswa = null) { goto s1Qhm; kTZt1: wcn5N: goto FrQk_; eBUmS: if (!($ids_siswa != null)) { goto wSi1J; } goto AQud5; s1Qhm: $this->db->select("\x2a"); goto SKJs8; FrQk_: return $ret; goto lFjBZ; SKJs8: $this->db->from("\162\x61\x70\157\162\137\156\151\x6c\141\x69\x5f\x73\151\x6b\x61\160"); goto eBUmS; FnD4x: wSi1J: goto kFojC; AQud5: $this->db->where_in("\x69\x64\137\x73\x69\x73\x77\x61", $ids_siswa); goto FnD4x; hqpVS: $ret = []; goto q8HHF; kFojC: $result = $this->db->get()->result(); goto hqpVS; q8HHF: foreach ($result as $res) { $ret[$res->id_tp][$res->id_smt][$res->id_siswa][$res->jenis] = $res; Wv6HY: } goto kTZt1; lFjBZ: } public function getAllFisik($ids_siswa = null) { goto LF8o9; Ex5V0: jTNgk: goto vJdmP; D3xzi: foreach ($result as $res) { $ret[$res->id_siswa][$res->id_tp][$res->id_smt] = $res; neBOP: } goto Ex5V0; oaIXg: $this->db->from("\x72\x61\160\157\162\137\x66\x69\163\x69\x6b"); goto KFBW3; tYDFm: $ret = []; goto D3xzi; ZwuqD: $this->db->where_in("\x69\144\x5f\x73\x69\163\167\x61", $ids_siswa); goto y1FZ9; KFBW3: if (!($ids_siswa != null)) { goto M5tui; } goto ZwuqD; vJdmP: return $ret; goto vtlf3; y1FZ9: M5tui: goto xOW26; xOW26: $result = $this->db->get()->result(); goto tYDFm; LF8o9: $this->db->select("\x69\144\x5f\x74\x70\54\40\x69\x64\137\x73\x6d\x74\x2c\x20\x69\x64\137\163\x69\163\167\141\54\40\x6b\x6f\156\1

デコード(難読化解除)されたコード

<?php

/*   ________________________________________
    |                 GarudaCBT              |
    |    https://github.com/garudacbt/cbt    |
    |________________________________________|
*/
class Rapor_model extends CI_Model
{
    public function getKikdMapel($id, $id_tp, $id_smt)
    {
        $this->db->where("id_kikd", $id)->where("id_tp", $id_tp)->where("id_smt", $id_smt);
        return $this->db->get("rapor_kikd")->row();
    }
    public function getKikdMapelKelas($id_mapel, $id_kelas, $id_tp, $id_smt)
    {
        $this->db->where("id_mapel_kelas", $id_mapel . $id_kelas)->where("id_tp", $id_tp)->where("id_smt", $id_smt);
        return $this->db->get("rapor_kikd")->result();
    }
    public function getKkm($id)
    {
        $this->db->where("id_kkm", $id);
        return $this->db->get("rapor_kkm")->row();
    }
    public function getArrKkm($ids)
    {
        $this->db->where_in("id_kkm", $ids);
        $result = $this->db->get("rapor_kkm")->result();
        $ret = [];
        if (!$result) {
            goto JjRfb;
        }
        foreach ($result as $key => $row) {
            $ret[$row->id_mapel] = $row;
        }
        JjRfb:
        return $ret;
    }
    public function getRaporSetting($id_tp, $id_smt)
    {
        $this->db->where("id_tp", $id_tp)->where("id_smt", $id_smt);
        return $this->db->get("rapor_admin_setting")->row();
    }
    public function getDetailSiswa($id_kelas, $id_tp, $id_smt)
    {
        $this->db->query("SET SQL_BIG_SELECTS=1");
        $this->db->select("a.*, b.*, c.*");
        $this->db->from("kelas_siswa a");
        $this->db->join("master_siswa b", "a.id_siswa=b.id_siswa");
        $this->db->join("master_kelas c", "a.id_kelas=c.id_kelas");
        $this->db->where("a.id_kelas", $id_kelas);
        $this->db->where("a.id_tp", $id_tp);
        $this->db->where("a.id_smt", $id_smt);
        $this->db->order_by("b.nama", "ASC");
        return $this->db->get()->result();
    }
    public function getDetailSiswaById($id_siswa, $id_tp, $id_smt)
    {
        $this->db->query("SET SQL_BIG_SELECTS=1");
        $this->db->select("a.nama, a.nis, a.nisn, c.nama_kelas");
        $this->db->from("master_siswa a");
        $this->db->join("kelas_siswa b", "a.id_siswa=b.id_siswa");
        $this->db->join("master_kelas c", "b.id_kelas=c.id_kelas");
        $this->db->where("a.id_siswa", $id_siswa);
        $this->db->where("b.id_tp", $id_tp);
        $this->db->where("b.id_smt", $id_smt);
        $this->db->order_by("a.nama", "ASC");
        return $this->db->get()->row();
    }
    public function cekNilaiHarianKelas($id_mapel, $id_kelas, $id_tp, $id_smt)
    {
        $this->db->select("p_rata_rata");
        $this->db->from("rapor_nilai_harian");
        $this->db->where("id_mapel", $id_mapel);
        $this->db->where("id_kelas", $id_kelas);
        $this->db->where("id_tp", $id_tp);
        $this->db->where("id_smt", $id_smt);
        $this->db->where("p_rata_rata !=", "NULL");
        return $this->db->get()->num_rows();
    }
    public function getNilaiHarianKelas($id_mapel, $id_kelas, $id_siswa, $id_tp, $id_smt)
    {
        $this->db->select("*");
        $this->db->from("rapor_nilai_harian");
        $this->db->where("id_nilai_harian", $id_mapel . $id_kelas . $id_siswa . $id_tp . $id_smt);
        return $this->db->get()->row();
    }
    public function getAllNilaiHarianKelas($id_kelas)
    {
        $this->db->select("*");
        $this->db->from("rapor_nilai_harian");
        $this->db->where("id_kelas", $id_kelas);
        return $this->db->get()->result();
    }
    public function cekNilaiPtsKelas($id_mapel, $id_kelas, $id_tp, $id_smt)
    {
        $this->db->select("predikat");
        $this->db->from("rapor_nilai_pts");
        $this->db->where("id_mapel", $id_mapel);
        $this->db->where("id_kelas", $id_kelas);
        $this->db->where("id_tp", $id_tp);
        $this->db->where("id_smt", $id_smt);
        $this->db->where("predikat !=", "NULL");
        return $this->db->get()->num_rows();
    }
    public function getIdNilaiPts($arr_id)
    {
        $this->db->select("id_nilai_pts");
        $this->db->from("rapor_nilai_pts");
        $this->db->where_in("id_nilai_pts", $arr_id);
        $result = $this->db->get()->result();
        $ret = [];
        if (!$result) {
            goto eGHkx;
        }
        foreach ($result as $key => $row) {
            $ret[$row->id_nilai_pts] = $row;
        }
        eGHkx:
        return $ret;
    }
    public function getNilaiPtsKelas($id_mapel, $id_kelas, $id_siswa, $id_tp, $id_smt)
    {
        $this->db->select("*");
        $this->db->from("rapor_nilai_pts");
        $this->db->where("id_nilai_pts", $id_mapel . $id_kelas . $id_siswa . $id_tp . $id_smt);
        return $this->db->get()->row();
    }
    public function getAllNilaiPtsKelas($id_kelas)
    {
        $this->db->select("*");
        $this->db->from("rapor_nilai_pts");
        $this->db->where("id_kelas", $id_kelas);
        return $this->db->get()->result();
    }
    public function getEkstraKelas($id_mapel, $id_siswa, $id_tp, $id_smt)
    {
        $this->db->select("nilai, predikat, deskripsi");
        $this->db->from("rapor_nilai_ekstra");
        $this->db->where("id_ekstra", $id_mapel);
        $this->db->where("id_siswa", $id_siswa);
        $this->db->where("id_tp", $id_tp);
        $this->db->where("id_smt", $id_smt);
        return $this->db->get()->row();
    }
    public function cekNilaiEkstraKelas($id_mapel, $id_kelas, $id_tp, $id_smt)
    {
        $this->db->select("id_nilai_ekstra");
        $this->db->from("rapor_nilai_ekstra");
        $this->db->where("id_ekstra", $id_mapel);
        $this->db->where("id_kelas", $id_kelas);
        $this->db->where("id_tp", $id_tp);
        $this->db->where("id_smt", $id_smt);
        return $this->db->get()->num_rows();
    }
    public function getNilaiEkstraKelas($id_ekstra, $id_kelas, $id_siswa, $id_tp, $id_smt)
    {
        $this->db->select("*");
        $this->db->from("rapor_nilai_ekstra");
        $this->db->where("id_nilai_ekstra", $id_ekstra . $id_kelas . $id_siswa . $id_tp . $id_smt);
        return $this->db->get()->row();
    }
    public function getAllNilaiEkstraKelas($id_kelas)
    {
        $this->db->select("*");
        $this->db->from("rapor_nilai_ekstra");
        $this->db->where("id_kelas", $id_kelas);
        return $this->db->get()->result();
    }
    public function cekNilaiAkhirKelas($id_mapel, $id_kelas, $id_tp, $id_smt)
    {
        $this->db->select("id_nilai_akhir");
        $this->db->from("rapor_nilai_akhir");
        $this->db->where("id_mapel", $id_mapel);
        $this->db->where("id_kelas", $id_kelas);
        $this->db->where("id_tp", $id_tp);
        $this->db->where("id_smt", $id_smt);
        return $this->db->get()->num_rows();
    }
    public function getNilaiAkhirKelas($id_mapel, $id_kelas, $id_siswa, $id_tp, $id_smt)
    {
        $this->db->query("SET SQL_BIG_SELECTS=1");
        $this->db->select("a.p_rata_rata as nhar, a.p_deskripsi, a.k_rata_rata, a.k_predikat, a.k_deskripsi, b.nilai as npts, c.nilai as npas, c.predikat");
        $this->db->from("rapor_nilai_harian a");
        $this->db->join("rapor_nilai_pts b", "b.id_nilai_pts=a.id_nilai_harian", "left");
        $this->db->join("rapor_nilai_akhir c", "c.id_nilai_akhir=a.id_nilai_harian", "left");
        $this->db->where("id_nilai_harian", $id_mapel . $id_kelas . $id_siswa . $id_tp . $id_smt);
        return $this->db->get()->row();
    }
    public function getAllNilaiAkhirKelas($id_kelas)
    {
        $this->db->select("*");
        $this->db->from("rapor_nilai_akhir");
        $this->db->where("id_kelas", $id_kelas);
        return $this->db->get()->result();
    }
    public function getNilaiAkhirByMapel($id_mapel, $id_kelas, $id_tp, $id_smt)
    {
        $this->db->query("SET SQL_BIG_SELECTS=1");
        $this->db->select("a.id_siswa, a.p_rata_rata as nhar, a.p_deskripsi, a.k_rata_rata, a.k_predikat, a.k_deskripsi, b.nilai as npts, c.nilai as npas, c.predikat");
        $this->db->from("rapor_nilai_harian a");
        $this->db->join("rapor_nilai_pts b", "b.id_nilai_pts=a.id_nilai_harian", "left");
        $this->db->join("rapor_nilai_akhir c", "c.id_nilai_akhir=a.id_nilai_harian", "left");
        $this->db->where("a.id_mapel", $id_mapel);
        $this->db->where("a.id_kelas", $id_kelas);
        $this->db->where("a.id_tp", $id_tp);
        $this->db->where("a.id_smt", $id_smt);
        return $this->db->get()->result();
    }
    public function getDeskripsiSikap($kelas, $id_tp, $id_smt)
    {
        $this->db->where("id_kelas", $kelas)->where("id_tp", $id_tp)->where("id_smt", $id_smt);
        return $this->db->get("rapor_data_sikap")->result();
    }
    public function getAllDeskripsiSikap($kelas)
    {
        $this->db->where("id_kelas", $kelas);
        return $this->db->get("rapor_data_sikap")->result();
    }
    public function getDeskripsiSikapByJenis($kelas, $jenis, $id_tp, $id_smt)
    {
        $this->db->select("*");
        $this->db->from("rapor_data_sikap");
        $this->db->where("id_kelas", $kelas);
        $this->db->where("jenis", $jenis);
        $this->db->where("id_tp", $id_tp);
        $this->db->where("id_smt", $id_smt);
        return $this->db->get()->result();
    }
    public function getNilaiSikapKelas($id_kelas, $id_siswa, $id_tp, $id_smt, $jenis)
    {
        $this->db->select("*");
        $this->db->from("rapor_nilai_sikap");
        $this->db->where("id_nilai_sikap", $id_kelas . $id_siswa . $id_tp . $id_smt . $jenis);
        return $this->db->get()->row();
    }
    public function getAllNilaiSikapKelas($id_kelas)
    {
        $this->db->select("*");
        $this->db->from("rapor_nilai_sikap");
        $this->db->where("id_kelas", $id_kelas);
        return $this->db->get()->result();
    }
    public function getNilaiSikapByJenis($id_kelas, $jenis, $id_tp, $id_smt)
    {
        $this->db->select("*");
        $this->db->from("rapor_nilai_sikap");
        $this->db->where("id_kelas", $id_kelas);
        $this->db->where("jenis", $jenis);
        $this->db->where("id_tp", $id_tp);
        $this->db->where("id_smt", $id_smt);
        return $this->db->get()->result();
    }
    public function getNilaiSikapByKelas($id_kelas, $id_tp, $id_smt)
    {
        $this->db->select("*");
        $this->db->from("rapor_nilai_sikap");
        $this->db->where("id_kelas", $id_kelas);
        $this->db->where("id_tp", $id_tp);
        $this->db->where("id_smt", $id_smt);
        return $this->db->get()->result();
    }
    public function getNilaiSikapBySiswa($id_siswa, $id_tp, $id_smt)
    {
        $this->db->select("*");
        $this->db->from("rapor_nilai_sikap");
        $this->db->where("id_siswa", $id_siswa);
        $this->db->where("id_tp", $id_tp);
        $this->db->where("id_smt", $id_smt);
        return $this->db->get()->result();
    }
    public function getDeskripsiCatatanByJenis($kelas, $jenis, $id_tp, $id_smt)
    {
        $this->db->where("jenis", $jenis)->where("id_kelas", $kelas)->where("id_tp", $id_tp)->where("id_smt", $id_smt);
        return $this->db->get("rapor_data_catatan")->result();
    }
    public function getCatatanKelas($id_kelas, $id_siswa, $id_tp, $id_smt)
    {
        $this->db->select("*");
        $this->db->from("rapor_catatan_wali");
        $this->db->where("id_catatan_wali", $id_kelas . $id_siswa . $id_tp . $id_smt);
        return $this->db->get()->row();
    }
    public function getAllCatatanKelas($id_kelas)
    {
        $this->db->select("*");
        $this->db->from("rapor_catatan_wali");
        $this->db->where("id_kelas", $id_kelas);
        return $this->db->get()->result();
    }
    public function getRankingKelas($id_kelas, $id_siswa, $id_tp, $id_smt)
    {
        $this->db->select("*");
        $this->db->from("rapor_prestasi");
        $this->db->where("id_ranking", $id_kelas . $id_siswa . $id_tp . $id_smt);
        return $this->db->get()->row();
    }
    public function getAllRankingKelas($id_kelas)
    {
        $this->db->select("*");
        $this->db->from("rapor_prestasi");
        $this->db->where("id_kelas", $id_kelas);
        return $this->db->get()->result();
    }
    public function getAllDeskripsiFisikKelas()
    {
        $result = $this->db->get("rapor_data_fisik")->result();
        $ret = [];
        if (!$result) {
            goto P0s0N;
        }
        foreach ($result as $key => $row) {
            $ret[$row->id_kelas][$row->id_tp][$row->id_smt] = $row;
        }
        P0s0N:
        return $ret;
    }
    public function getAllRaporFisik()
    {
        $result = $this->db->get("rapor_fisik")->result();
        $ret = [];
        if (!$result) {
            goto X9est;
        }
        foreach ($result as $key => $row) {
            $ret[$row->id_siswa][$row->id_tp][$row->id_smt] = $row;
        }
        X9est:
        return $ret;
    }
    public function getDeskripsiFisikKelas($kelas, $id_tp, $id_smt)
    {
        $this->db->where("id_fisik", $kelas)->where("id_tp", $id_tp)->where("id_smt", $id_smt);
        return $this->db->get("rapor_data_fisik")->row();
    }
    public function getFisikKelas($id_kelas, $id_siswa, $id_tp, $id_smt)
    {
        $this->db->select("*");
        $this->db->from("rapor_fisik");
        $this->db->where("id_fisik", $id_kelas . $id_siswa . $id_tp . $id_smt);
        return $this->db->get()->row();
    }
    public function getAllFisikKelas($id_kelas)
    {
        $this->db->select("*");
        $this->db->from("rapor_fisik");
        $this->db->where("id_kelas", $id_kelas);
        return $this->db->get()->result();
    }
    public function getJmlNilaiMapelHarianSiswa($id_mapel, $id_siswa, $id_tp, $id_smt)
    {
        $this->db->select("p_rata_rata, k_rata_rata, jml");
        $this->db->from("rapor_nilai_harian");
        $this->db->where("id_mapel", $id_mapel);
        $this->db->where("id_siswa", $id_siswa);
        $this->db->where("id_tp", $id_tp);
        $this->db->where("id_smt", $id_smt);
        return $this->db->get()->row();
    }
    public function getNilaiMapelHarianSiswa($id_mapel, $id_siswa, $id_tp, $id_smt)
    {
        $this->db->select("p1,p2,p3,p4,p5,k1,k2,k3,k4,k5");
        $this->db->from("rapor_nilai_harian");
        $this->db->where("id_mapel", $id_mapel);
        $this->db->where("id_siswa", $id_siswa);
        $this->db->where("id_tp", $id_tp);
        $this->db->where("id_smt", $id_smt);
        return $this->db->get()->row();
    }
    public function getArrNilaiMapelHarianSiswa($ids_mapel, $ids_siswa, $id_tp, $id_smt)
    {
        $this->db->select("p1,p2,p3,p4,p5,k1,k2,k3,k4,k5,id_mapel,id_siswa");
        $this->db->from("rapor_nilai_harian");
        $this->db->where_in("id_mapel", $ids_mapel);
        $this->db->where_in("id_siswa", $ids_siswa);
        $this->db->where("id_tp", $id_tp);
        $this->db->where("id_smt", $id_smt);
        $nilais = $this->db->get()->result();
        $rest = [];
        foreach ($nilais as $nilai) {
            $rest[$nilai->id_siswa][$nilai->id_mapel] = $nilai;
        }
        return $rest;
    }
    public function getNilaiMapelPtsSiswa($id_mapel, $id_siswa, $id_tp, $id_smt)
    {
        $this->db->select("nilai");
        $this->db->from("rapor_nilai_pts");
        $this->db->where("id_mapel", $id_mapel);
        $this->db->where("id_siswa", $id_siswa);
        $this->db->where("id_tp", $id_tp);
        $this->db->where("id_smt", $id_smt);
        return $this->db->get()->row();
    }
    public function getArrNilaiMapelPtsSiswa($ids_mapel, $ids_siswa, $id_tp, $id_smt)
    {
        $this->db->select("nilai, id_mapel, id_siswa");
        $this->db->from("rapor_nilai_pts");
        $this->db->where_in("id_mapel", $ids_mapel);
        $this->db->where_in("id_siswa", $ids_siswa);
        $this->db->where("id_tp", $id_tp);
        $this->db->where("id_smt", $id_smt);
        $nilais = $this->db->get()->result();
        $rest = [];
        foreach ($nilais as $nilai) {
            $rest[$nilai->id_siswa][$nilai->id_mapel] = $nilai;
        }
        return $rest;
    }
    public function getNilaiMapelPasSiswa($id_mapel, $id_siswa, $id_tp, $id_smt)
    {
        $this->db->select("nilai,akhir");
        $this->db->from("rapor_nilai_akhir");
        $this->db->where("id_mapel", $id_mapel);
        $this->db->where("id_siswa", $id_siswa);
        $this->db->where("id_tp", $id_tp);
        $this->db->where("id_smt", $id_smt);
        return $this->db->get()->row();
    }
    public function getNilaiRapor($id_mapel, $id_kelas, $id_siswa, $id_tp, $id_smt)
    {
        $this->db->select("a.p_rata_rata, a.p_deskripsi, a.k_rata_rata, a.k_predikat, a.k_deskripsi, b.nilai as nilai_pas, b.akhir as nilai, b.predikat");
        $this->db->from("rapor_nilai_harian a");
        $this->db->join("rapor_nilai_akhir b", "b.id_nilai_akhir=a.id_nilai_harian", "left");
        $this->db->where("a.id_nilai_harian", $id_mapel . $id_kelas . $id_siswa . $id_tp . $id_smt);
        return $this->db->get()->row_array();
    }
    public function getNilaiMapelByKelas($id_mapel, $id_kelas, $id_tp, $id_smt)
    {
        $this->db->select("a.p_rata_rata, a.p_deskripsi, a.k_rata_rata, a.k_predikat, a.k_deskripsi, b.nilai as nilai_pas, b.akhir as nilai, b.predikat");
        $this->db->from("rapor_nilai_harian a");
        $this->db->join("rapor_nilai_akhir b", "b.id_nilai_akhir=a.id_nilai_harian", "left");
        $this->db->where("a.id_mapel", $id_mapel);
        $this->db->where("a.id_kelas", $id_kelas);
        $this->db->where("a.id_tp", $id_tp);
        $this->db->where("a.id_smt", $id_smt);
        return $this->db->get()->result();
    }
    public function getNilaiRaporByKelas($id_kelas, $id_tp, $id_smt)
    {
        $this->db->select("a.id_nilai_harian, a.id_siswa, a.id_mapel, a.p_rata_rata, a.p_deskripsi, a.k_rata_rata, a.k_predikat, a.k_deskripsi, b.nilai as nilai_pas, b.akhir as nilai, b.predikat");
        $this->db->from("rapor_nilai_harian a");
        $this->db->join("rapor_nilai_akhir b", "b.id_nilai_akhir=a.id_nilai_harian", "left");
        $this->db->where("a.id_kelas", $id_kelas);
        $this->db->where("a.id_tp", $id_tp);
        $this->db->where("a.id_smt", $id_smt);
        return $this->db->get()->result();
    }
    public function getPrestasiByKelas($id_kelas, $id_tp, $id_smt)
    {
        $this->db->select("id_siswa, ranking, deskripsi as rank_deskripsi, p1, p1_desk, p2, p2_desk, p3, p3_desk");
        $this->db->from("rapor_prestasi");
        $this->db->where("id_kelas", $id_kelas);
        $this->db->where("id_tp", $id_tp);
        $this->db->where("id_smt", $id_smt);
        $ranks = $this->db->get()->result();
        $rest = [];
        foreach ($ranks as $rank) {
            $rest[$rank->id_siswa] = $rank;
        }
        return $rest;
    }
    public function getCatatanWaliByKelas($id_kelas, $id_tp, $id_smt)
    {
        $this->db->select("id_siswa, nilai, deskripsi as saran");
        $this->db->from("rapor_catatan_wali");
        $this->db->where("id_kelas", $id_kelas);
        $this->db->where("id_tp", $id_tp);
        $this->db->where("id_smt", $id_smt);
        $desks = $this->db->get()->result();
        $rest = [];
        foreach ($desks as $desk) {
            $rest[$desk->id_siswa] = $desk;
        }
        return $rest;
    }
    public function getRaporDeskripsi($id_kelas, $id_siswa, $id_tp, $id_smt)
    {
        $this->db->select("b.ranking, b.deskripsi as rank_deskripsi, b.p1, b.p1_desk, b.p2, b.p2_desk, b.p3, b.p3_desk, c.nilai, c.deskripsi as saran");
        $this->db->from("rapor_prestasi b");
        $this->db->join("rapor_catatan_wali c", "c.id_catatan_wali=b.id_ranking", "left");
        $this->db->where("b.id_ranking", $id_kelas . $id_siswa . $id_tp . $id_smt);
        return $this->db->get()->row();
    }
    public function getDummyDeskripsiSpiritual()
    {
        return ["berdoa sebelum dan sesudah melakukan kegiatan", "menjalankan ibadah sesuai dengan agamanya", "memberi salam pada saat awal dan akhir kegiatan", "bersyukur atas nikmat dan karunia Tuhan Yang Maha Esa", "mensyukuri kemampuan manusia dalam mengendalikan diri", "bersyukur ketika berhasil mengerjakan sesuatu", "berserah diri (tawakal) kepada Tuhan setelah berikhtiar atau melakukan usaha", "memelihara hubungan baik dengan sesama umat", "bersyukur sebagai bangsa Indonesia", "menghormati orang lain yang menjalankan ibadah sesuai dengan agamanya"];
    }
    public function getDummyDeskripsiSosial()
    {
        return ["jujur", "disiplin", "tanggung jawab", "santun", "percaya diri", "peduli", "toleransi", "gotong royong", "rajin", "tidak mudah menyerah"];
    }
    public function getDummyDeskripsiAbsensi()
    {
        return ["Kehadiran cukup baik namun perlu ditingkatkan.", "Usahakan hadir setiap hari.", "Jangan terlalu banyak alpa, diharapkan selalu hadir ke sekolah", "Kehadiranmu sangat jarang sekali"];
    }
    public function getDummyDeskripsiCatatan()
    {
        return ["Selalu berusaha untuk mematuhi tata tertib sekolah dan patuh terhadap Guru.", "Selalu berusaha untuk mandiri dan tepat waktu dalam mengerjakan tugas.", "Mempunyai kemampuan dan motivasi yang tinggi untuk menggunakan waktu secara efisien.", "Diharapkan merubah penampilannya menjadi lebih rapi, seperti tentang potong rambut dan cara berpakaian.", "Masih perlu memperbanyak teman bergaul dan teman diskusi, kurangi aktifitas menyendiri.", "Diharapkan dapat meningkatkan komitmennya untuk lebih serius saat mengerjakan tugas dan tidak mudah menyerah."];
    }
    public function getDummyDeskripsiRanking()
    {
        return ["Prestasinya sangat baik, perlu dipertahankan.", "Prestasi baik, perlu dipertahankan dan dtingkatkan.", "Prestasi cukup, perlu ditingkatkan belajar dan berdoa.", "Perlu ditingkatkan belajarnya, jangan lupa berdoa.", "Perlu dimaksimalkan belajarnya, usaha keras dan berdoa.", "Perlu usaha keras, maksimalkan belajarnya, lebih giat berdoa dan beribadah."];
    }
    public function getDummyDeskripsiFisik($jenis)
    {
        if ($jenis == "1") {
            return ["Baik", "Kurang peka", "Telinga perlu dibersihkan", ''];
        }
        if ($jenis == "2") {
            return ["Baik", "Sering berair", "Kurang jelas jika melihat jarak jauh", ''];
        }
        if ($jenis == "3") {
            return ["Baik, nampak putih dan bersih", "Terdapat gigi yang gigis", "Kebersihan gigi kurang terjaga", "Ada gigi yang mau tanggal"];
        }
        return ["Tubuh sehat dan kuat", "Mudah kecapekan", "Kebersihan badan kurang terjaga", ''];
    }
    public function getKenaikanSiswa($id_kelas, $id_tp, $id_smt, $level = null)
    {
        $this->db->query("SET SQL_BIG_SELECTS=1");
        $this->db->select("a.*, b.nama, b.nis, b.nisn, b.username, c.id_kelas, c.nama_kelas, c.level_id, d.naik");
        $this->db->from("kelas_siswa a");
        $this->db->join("master_siswa b", "a.id_siswa=b.id_siswa", "left");
        $this->db->join("master_kelas c", "a.id_kelas=c.id_kelas", "left");
        $this->db->join("rapor_naik d", "a.id_siswa=d.id_siswa AND a.id_tp=d.id_tp AND a.id_smt=d.id_smt", "left");
        if (!($level != null)) {
            goto mMg9u;
        }
        $this->db->where("c.level_id", $level);
        mMg9u:
        if (!($id_kelas != null)) {
            goto lqJ4k;
        }
        $this->db->where("a.id_kelas", $id_kelas);
        lqJ4k:
        $this->db->where("a.id_tp", $id_tp);
        $this->db->where("a.id_smt", $id_smt);
        return $this->db->get()->result();
    }
    public function getSiswaLulus($id_tp, $id_smt, $level)
    {
        $this->db->query("SET SQL_BIG_SELECTS=1");
        $this->db->select("b.*, c.nama_kelas as kelas_akhir, d.naik");
        $this->db->from("kelas_siswa a");
        $this->db->join("master_siswa b", "a.id_siswa=b.id_siswa", "left");
        $this->db->join("master_kelas c", "a.id_kelas=c.id_kelas", "left");
        $this->db->join("rapor_naik d", "a.id_siswa=d.id_siswa AND a.id_tp=d.id_tp AND a.id_smt=d.id_smt", "left");
        $this->db->where("c.level_id", $level);
        $this->db->where("a.id_tp", $id_tp);
        $this->db->where("a.id_smt", $id_smt);
        return $this->db->get()->result();
    }
    public function getJumlahLulus($id_tp, $id_smt, $level)
    {
        $this->db->query("SET SQL_BIG_SELECTS=1");
        $this->db->select("a.*, b.nama, b.nis, b.nisn, b.username, c.id_kelas, c.nama_kelas, c.level_id, d.naik");
        $this->db->from("kelas_siswa a");
        $this->db->join("master_kelas c", "a.id_kelas=c.id_kelas", "left");
        $this->db->join("rapor_naik d", "a.id_siswa=d.id_siswa AND a.id_tp=d.id_tp AND a.id_smt=d.id_smt", "left");
        $this->db->where("c.level_id", $level);
        $this->db->where("a.id_tp", $id_tp);
        $this->db->where("a.id_smt", $id_smt);
        return $this->db->count_all_results();
    }
    public function getKenaikanRapor($id_kelas, $id_tp, $id_smt)
    {
        $this->db->select("a.id_kelas, a.id_siswa, d.naik");
        $this->db->from("kelas_siswa a");
        $this->db->join("rapor_naik d", "a.id_siswa=d.id_siswa AND a.id_tp=d.id_tp AND a.id_smt=d.id_smt", "left");
        $this->db->where("a.id_kelas", $id_kelas);
        $this->db->where("a.id_tp", $id_tp);
        $this->db->where("a.id_smt", $id_smt);
        $ress = $this->db->get()->result();
        $ret = [];
        foreach ($ress as $res) {
            $ret[$res->id_siswa] = $res->naik;
        }
        return $ret;
    }
    public function getAllRaporSetting()
    {
        $result = $this->db->get("rapor_admin_setting")->result();
        $ret = [];
        if (!$result) {
            goto uudew;
        }
        foreach ($result as $key => $row) {
            $ret[$row->id_tp][$row->id_smt] = $row;
        }
        uudew:
        return $ret;
    }
    public function getAllKkm()
    {
        $result = $this->db->get("rapor_kkm")->result();
        $ret = [];
        foreach ($result as $res) {
            $ret[$res->id_tp][$res->id_smt][$res->id_kelas][$res->jenis][$res->id_mapel] = $res;
        }
        return $ret;
    }
    public function getAllKkmRaporAkhir($kelas, $id_tp, $id_smt)
    {
        $this->db->where("id_kelas", $kelas)->where("id_tp", $id_tp)->where("id_smt", $id_smt);
        $result = $this->db->get("rapor_kkm")->result();
        $ret = [];
        foreach ($result as $res) {
            $ret[$res->jenis][$res->id_mapel] = $res;
        }
        return $ret;
    }
    public function getAllNilaiAkhir()
    {
        $this->db->query("SET SQL_BIG_SELECTS=1");
        $this->db->select("a.id_tp, a.id_smt, a.id_siswa, a.p_rata_rata as nhar, a.p_deskripsi, a.k_rata_rata, a.k_predikat, a.k_deskripsi, b.nilai as npts, c.nilai as npas, c.predikat");
        $this->db->from("rapor_nilai_harian a");
        $this->db->join("rapor_nilai_pts b", "b.id_nilai_pts=a.id_nilai_harian", "left");
        $this->db->join("rapor_nilai_akhir c", "c.id_nilai_akhir=a.id_nilai_harian", "left");
        $result = $this->db->get()->result();
        $ret = [];
        foreach ($result as $res) {
            $ret[$res->id_tp][$res->id_smt][$res->id_siswa] = $res;
        }
        return $ret;
    }
    public function getDistinctTahunBukuNilai()
    {
        $this->db->select("tp");
        $this->db->distinct();
        $result = $this->db->get("buku_nilai")->result();
        $ret = [];
        foreach ($result as $row) {
            $ret[$row->tp] = $row->tp;
        }
        return $ret;
    }
    public function getDistinctSmtBukuNilai()
    {
        $this->db->select("smt");
        $this->db->distinct();
        $result = $this->db->get("buku_nilai")->result();
        $ret = [];
        foreach ($result as $row) {
            $ret[$row->smt] = $row->smt;
        }
        return $ret;
    }
    public function getDistinctKelasBukuNilai()
    {
        $this->db->select("kelas");
        $this->db->distinct();
        $result = $this->db->get("buku_nilai")->result();
        $ret = [];
        foreach ($result as $row) {
            $ret[$row->kelas] = $row->kelas;
        }
        return $ret;
    }
    public function getFisikBySiswa($id_siswa)
    {
        $this->db->select("tp, fisik");
        $this->db->from("buku_nilai");
        $this->db->where("id_siswa", $id_siswa);
        $result = $this->db->get()->result();
        $ret = [];
        if (!$result) {
            goto z9dTD;
        }
        foreach ($result as $key => $row) {
            $ret[$row->tp] = $row;
        }
        z9dTD:
        return $ret;
    }
    public function getDataKumpulanRapor($kelas = null, $tp = null, $smt = null)
    {
        $this->db->select("*");
        $this->db->from("buku_nilai a");
        $this->db->join("master_siswa b", "a.id_siswa=b.id_siswa");
        if (!($tp != null)) {
            goto ghRvl;
        }
        $this->db->where("a.tp", $tp);
        ghRvl:
        if (!($smt != null)) {
            goto T7CMA;
        }
        $this->db->where("a.smt", $smt);
        T7CMA:
        if (!($kelas != null)) {
            goto U3N53;
        }
        $this->db->where("a.kelas", $kelas);
        U3N53:
        $result = $this->db->get()->result();
        $ret = [];
        if (!$result) {
            goto Xn_QY;
        }
        foreach ($result as $key => $row) {
            $ret[$row->id_siswa] = $row;
        }
        Xn_QY:
        return $ret;
    }
    public function deleteNilaiRapor()
    {
        $this->db->empty_table("rapor_nilai_harian");
        $this->db->empty_table("rapor_nilai_akhir");
        $this->db->empty_table("rapor_naik");
        $this->db->empty_table("rapor_nilai_pts");
        $this->db->empty_table("rapor_prestasi");
        $this->db->empty_table("rapor_catatan_wali");
        $this->db->empty_table("rapor_fisik");
        $this->db->empty_table("rapor_nilai_ekstra");
        $this->db->empty_table("rapor_nilai_sikap");
    }
    public function getAllNilaiRapor($ids_siswa = null)
    {
        $this->db->query("SET SQL_BIG_SELECTS=1");
        $this->db->select("a.id_tp, a.id_smt, a.id_mapel, a.id_siswa, a.p_rata_rata, a.p_predikat, a.p_deskripsi, a.k_rata_rata, a.k_predikat, a.k_deskripsi, b.nilai as nilai_pas, b.akhir as nilai_rapor, b.predikat as rapor_predikat, c.*, d.*, e. nama, e.uid, f.naik, g.nilai as nilai_pts, g.predikat as pts_predikat, h. id_kelas, h.nama_kelas, h.level_id, i.nama_jurusan, k.nama_guru, l.ranking, l.deskripsi as rank_deskripsi, l.p1, l.p1_desk, l.p2, l.p2_desk, l.p3, l.p3_desk, m.nilai as absen, m.deskripsi as saran, n.kondisi, n.tinggi, n.berat, p.kode as mapel");
        $this->db->from("rapor_nilai_harian a");
        $this->db->join("rapor_nilai_akhir b", "b.id_nilai_akhir=a.id_nilai_harian", "left");
        $this->db->join("master_tp c", "c.id_tp=a.id_tp", "left");
        $this->db->join("master_smt d", "d.id_smt=a.id_smt", "left");
        $this->db->join("master_siswa e", "e.id_siswa=a.id_siswa", "left");
        $this->db->join("rapor_naik f", "a.id_siswa=f.id_siswa AND a.id_tp=f.id_tp AND a.id_smt=f.id_smt", "left");
        $this->db->join("rapor_nilai_pts g", "g.id_nilai_pts=a.id_nilai_harian", "left");
        $this->db->join("master_kelas h", "a.id_kelas=h.id_kelas AND a.id_tp=h.id_tp AND a.id_smt=h.id_smt", "left");
        $this->db->join("master_jurusan i", "h.jurusan_id=i.id_jurusan", "left");
        $this->db->join("jabatan_guru j", "a.id_kelas=j.id_kelas AND a.id_tp=j.id_tp AND a.id_smt=j.id_smt", "left");
        $this->db->join("master_guru k", "j.id_guru=k.id_guru", "left");
        $this->db->join("rapor_prestasi l", "a.id_siswa=l.id_siswa AND a.id_tp=l.id_tp AND a.id_smt=l.id_smt", "left");
        $this->db->join("rapor_catatan_wali m", "a.id_siswa=m.id_siswa AND a.id_tp=m.id_tp AND a.id_smt=m.id_smt", "left");
        $this->db->join("rapor_fisik n", "a.id_siswa=n.id_siswa AND a.id_tp=n.id_tp AND a.id_smt=n.id_smt", "left");
        $this->db->join("master_mapel p", "a.id_mapel=p.id_mapel", "left");
        if (!($ids_siswa != null)) {
            goto qVaLO;
        }
        $this->db->where_in("a.id_siswa", $ids_siswa);
        qVaLO:
        $result = $this->db->get()->result();
        return $result;
    }
    public function getAllEkstra()
    {
        $this->db->select("*");
        $this->db->from("kelas_ekstra");
        $result = $this->db->get()->result();
        $ret = [];
        if (!$result) {
            goto GWE5A;
        }
        foreach ($result as $key => $row) {
            $ret[$row->id_tp][$row->id_smt][$row->id_kelas] = unserialize($row->ekstra);
        }
        GWE5A:
        return $ret;
    }
    public function getAllNilaiEkstra($ids_siswa = null)
    {
        $this->db->select("a.*, b.nama_ekstra, b.kode_ekstra");
        $this->db->from("rapor_nilai_ekstra a");
        $this->db->join("master_ekstra b", "a.id_ekstra=b.id_ekstra", "left");
        if (!($ids_siswa != null)) {
            goto ZnJFP;
        }
        $this->db->where_in("a.id_siswa", $ids_siswa);
        ZnJFP:
        $result = $this->db->get()->result();
        $ret = [];
        foreach ($result as $res) {
            $ret[$res->id_tp][$res->id_smt][$res->id_siswa][] = $res;
        }
        return $ret;
    }
    public function getAllNilaiSikap($ids_siswa = null)
    {
        $this->db->select("*");
        $this->db->from("rapor_nilai_sikap");
        if (!($ids_siswa != null)) {
            goto wSi1J;
        }
        $this->db->where_in("id_siswa", $ids_siswa);
        wSi1J:
        $result = $this->db->get()->result();
        $ret = [];
        foreach ($result as $res) {
            $ret[$res->id_tp][$res->id_smt][$res->id_siswa][$res->jenis] = $res;
        }
        return $ret;
    }
    public function getAllFisik($ids_siswa = null)
    {
        $this->db->select("id_tp, id_smt, id_siswa, kondisi, tinggi, berat");
        $this->db->from("rapor_fisik");
        if (!($ids_siswa != null)) {
            goto M5tui;
        }
        $this->db->where_in("id_siswa", $ids_siswa);
        M5tui:
        $result = $this->db->get()->result();
        $ret = [];
        foreach ($result as $res) {
            $ret[$res->id_siswa][$res->id_tp][$res->id_smt] = $res;
        }
        return $ret;
    }
    function exists($uid, $tp, $smt, $kelas)
    {
        $this->db->where("uid", $uid)->where("tp", $tp)->where("smt", $smt)->where("kelas", $kelas);
        $query = $this->db->get("buku_nilai");
        if ($query->num_rows() > 0) {
            return true;
        }
        return false;
    }
}

■【無料】ワードプレス:マルウェアスキャン＆セキュリティープラグイン [マルウェア・ウィルス検出と駆除]

■WordPress のマルウェア駆除、セキュリティー対策 カスタマイズや修正、引っ越し・復旧のご依頼承ります

（C）2019 ワードプレス ドクター All rights reserved.