Find this useful? Enter your email to receive occasional updates for securing PHP code.
Signing you up...
Thank you for signing up!
PHP Decode
<?php /* ________________________________________ | GarudaCBT ..
Decoded Output download
<?php
/* ________________________________________
| GarudaCBT |
| https://github.com/garudacbt/cbt |
|________________________________________|
*/
defined("BASEPATH") or exit("No direct script access allowed"); class Master_model extends CI_Model { public function create($table, $data, $batch = false) { goto UcvEh; k9x_s: hDau3: goto APNiW; H4i8F: yG27h: goto Kh4mZ; UcvEh: if ($batch === false) { goto hDau3; } goto FsqcH; Kh4mZ: return $insert; goto OTYcf; FsqcH: $insert = $this->db->insert_batch($table, $data); goto KjVwm; APNiW: $insert = $this->db->insert($table, $data); goto H4i8F; KjVwm: goto yG27h; goto k9x_s; OTYcf: } public function update($table, $data, $pk, $id = null, $batch = false) { goto SBGj0; HiHC4: $insert = $this->db->update($table, $data, array($pk => $id)); goto a8sEv; n13_8: $insert = $this->db->update_batch($table, $data, $pk); goto ul1ll; ul1ll: goto XdoGJ; goto fd8JM; pTk3d: return $insert; goto dVayL; a8sEv: XdoGJ: goto pTk3d; SBGj0: if ($batch === false) { goto GR8Dx; } goto n13_8; fd8JM: GR8Dx: goto HiHC4; dVayL: } public function delete($table, $data, $pk) { goto K2Gpl; K2Gpl: $this->db->query("SET FOREIGN_KEY_CHECKS=0"); goto TXAWE; c36FV: $deleted = $this->db->delete($table); goto mIAgx; mIAgx: $this->db->query("SET FOREIGN_KEY_CHECKS=1"); goto A8Wui; A8Wui: return $deleted; goto x69Zd; TXAWE: $this->db->where_in($pk, $data); goto c36FV; x69Zd: } public function delete_not($table, $data, $pk, $col, $not) { goto KHelY; c57cV: $this->db->where($col . "!=" . $not); goto mbfDo; KHelY: $this->db->where_in($pk, $data); goto c57cV; mbfDo: return $this->db->delete($table); goto aD_g8; aD_g8: } public function getDataKelas() { goto SXkBj; SXkBj: $this->datatables->select("id_kelas, nama_kelas, id_jurusan, nama_jurusan"); goto wWfGL; wWfGL: $this->datatables->from("master_kelas"); goto OZGyX; kITqC: return $this->datatables->generate(); goto hught; zMYTU: $this->datatables->add_column("bulk_select", "<div class="text-center"><input type="checkbox" class="check" name="checked[]" value="$1"/></div>", "id_kelas, nama_kelas, id_jurusan, nama_jurusan"); goto kITqC; OZGyX: $this->datatables->join("master_jurusan", "jurusan_id=id_jurusan"); goto zMYTU; hught: } public function getKelasById($id) { goto I0EJP; sq3yk: $this->db->where("id_kelas", $id); goto cYOCQ; Wgyfx: $this->db->from("master_kelas"); goto sq3yk; cYOCQ: $this->db->order_by("nama_kelas"); goto QV4VL; QV4VL: return $this->db->get()->row(); goto l0MIM; I0EJP: $this->db->select("id_kelas, nama_kelas, level_id"); goto Wgyfx; l0MIM: } public function getDataJurusan() { goto U93gS; BU0Ly: return $this->db->get()->result(); goto tC3E_; B1q15: $this->db->from("master_jurusan"); goto BU0Ly; U93gS: $this->db->select("*"); goto B1q15; tC3E_: } public function getDataJurusanMapel($arrIds) { goto rI_Ad; q4mfp: if (!$result) { goto wpOHj; } goto MKlwH; dX4ZV: $this->db->from("master_mapel"); goto yR5AB; UVg1M: $result = $this->db->get()->result(); goto mKAg7; bMk6d: wpOHj: goto QeILI; QeILI: return $ret; goto Px5_7; mKAg7: $ret = []; goto q4mfp; xDCxg: Njxce: goto bMk6d; rI_Ad: $this->db->select("id_mapel, nama_mapel"); goto dX4ZV; yR5AB: $this->db->where_in("id_mapel", $arrIds); goto UVg1M; MKlwH: foreach ($result as $key => $row) { $ret[$row->id_mapel] = $row->nama_mapel; gzZJc: } goto xDCxg; Px5_7: } public function getDataTableJurusan() { goto bOug9; JHHNg: $this->datatables->from("master_jurusan"); goto oEAd5; Odsqk: return $this->datatables->generate(); goto x0xEI; bOug9: $this->datatables->select("*"); goto JHHNg; oEAd5: $this->db->order_by("id_jurusan"); goto Odsqk; x0xEI: } public function getJurusanById($id) { goto rNRka; IX1R6: return $this->db->get("master_jurusan")->result(); goto GvSo8; dsqHn: $this->db->order_by("nama_jurusan"); goto IX1R6; rNRka: $this->db->where_in("id_jurusan", $id); goto dsqHn; GvSo8: } function updateJurusan() { goto gKsWq; YDHD6: EKWCr: goto zRXrb; h_5qy: $this->db->set("nama_jurusan", $name); goto kJNjk; IR9Ge: $this->db->set("status", "1"); goto hIM7J; iz2kA: if (!($i <= $row_mapels)) { goto UXHRd; } goto XaIOf; kJNjk: $this->db->set("kode_jurusan", $kode); goto gZX0A; age7C: UXHRd: goto Xdafv; hIM7J: $this->db->where("id_jurusan", $id); goto DIoXZ; DIoXZ: return $this->db->update("master_jurusan"); goto bOZRF; D2_eo: $row_mapels = count($this->input->post("mapel", true)); goto s1Yr1; Xdafv: EtAsG: goto h_5qy; FjwSX: $kode = $this->input->post("kode_jurusan", true); goto j4z9Y; s1Yr1: $i = 0; goto qIQP0; j4z9Y: $mapels = []; goto FdXaj; GKU2H: goto EphIn; goto age7C; qIQP0: EphIn: goto iz2kA; zRXrb: $i++; goto GKU2H; VZqQa: if (!$check_mapel) { goto EtAsG; } goto D2_eo; FdXaj: $check_mapel = $this->input->post("mapel", true); goto VZqQa; gKsWq: $id = $this->input->post("id_jurusan"); goto BN0NQ; XaIOf: array_push($mapels, $this->input->post("mapel[" . $i . "]", true)); goto YDHD6; gZX0A: $this->db->set("mapel_peminatan", implode(",", $mapels)); goto IR9Ge; BN0NQ: $name = $this->input->post("nama_jurusan", true); goto FjwSX; bOZRF: } public function inputJurusan() { $data = ["nama_jurusan" => $this->input->post("nama_jurusan", true), "kode_jurusan" => $this->input->post("kode_jurusan", true)]; return $this->db->insert("master_jurusan", $data); } public function getAllDataSiswa($id_tp, $id_smt) { goto U53G1; P7rC7: return $query->result(); goto ieBVl; ynRaO: $this->db->from("master_siswa a"); goto t7LXn; fLqSy: $query = $this->db->get(); goto P7rC7; dJXTd: $this->db->order_by("a.nama"); goto fLqSy; U53G1: $this->db->query("SET SQL_BIG_SELECTS=1"); goto jQmaD; N_jof: $this->db->join("master_kelas c", "c.id_kelas=b.id_kelas", "left"); goto wr7rj; t7LXn: $this->db->join("kelas_siswa b", "b.id_siswa=a.id_siswa AND b.id_tp=" . $id_tp . " AND b.id_smt=" . $id_smt . '', "left"); goto N_jof; jQmaD: $this->db->select("a.*, c.nama_kelas"); goto ynRaO; wr7rj: $this->db->order_by("b.id_kelas"); goto dJXTd; ieBVl: } public function getSiswaByKelas($id_tp, $id_smt, $id_kelas) { goto GCb1a; hndCi: $this->db->where("a.id_tp", $id_tp); goto LfY1R; xFHZJ: $this->db->from("kelas_siswa a"); goto ZkyYU; LfY1R: $this->db->where("a.id_smt", $id_smt); goto NHZel; GCb1a: $this->db->select("b.*"); goto xFHZJ; NHZel: $this->db->where("a.id_siswa is NOT NULL", NULL, FALSE); goto beJCG; ZkyYU: $this->db->join("master_siswa b", "b.id_siswa=a.id_siswa"); goto hndCi; K_FU2: return $this->db->get()->result(); goto eFYTI; UM_Ab: $this->db->where("a.id_kelas", $id_kelas); goto TPzne; beJCG: $this->db->where("b.id_siswa is NOT NULL", NULL, FALSE); goto UM_Ab; TPzne: $this->db->order_by("b.nama", "ASC"); goto K_FU2; eFYTI: } public function getDataSiswa($id_tp, $id_smt) { goto n8WBm; HQR67: return $this->datatables->generate(); goto CObiX; OsDZw: $this->datatables->join("master_kelas f", "f.id_kelas=d.id_kelas", "left"); goto ptAqt; n8WBm: $this->db->query("SET SQL_BIG_SELECTS=1"); goto PsdsR; PsdsR: $this->datatables->select("a.id_siswa, a.foto, a.nama, a.nis, a.nisn, a.jenis_kelamin, f.level_id, f.nama_kelas, b.status"); goto cmzZK; nefdv: $this->db->order_by("f.nama_kelas", "ASC"); goto WVLjs; webcY: $this->datatables->join("users c", "a.username=c.username"); goto tWX5W; WVLjs: $this->db->order_by("b.status", "ASC"); goto HQR67; cCkB6: $this->datatables->join("buku_induk b", "a.id_siswa=b.id_siswa", "left"); goto webcY; cmzZK: $this->datatables->from("master_siswa a"); goto cCkB6; ptAqt: $this->db->order_by("ISNULL(f.level_id), f.level_id ASC"); goto nefdv; tWX5W: $this->datatables->join("kelas_siswa d", "d.id_siswa = a.id_siswa AND d.id_tp = " . $id_tp . " AND d.id_smt = " . $id_smt . '', "left"); goto OsDZw; CObiX: } public function getAllSiswa($id_tp, $id_smt, $offset, $limit, $search = null, $sort = null, $order = null) { goto DITkC; J4GSX: HGoxL: goto THiAj; QTmDg: $this->db->or_like("a.nisn", $search); goto J4GSX; Una0k: $this->db->from("master_siswa a"); goto h2d2d; eyytq: $this->db->join("master_kelas f", "f.id_kelas=d.id_kelas", "left"); goto hxSyW; THiAj: return $this->db->get()->result(); goto t2zdg; DITkC: $this->db->select("a.id_siswa, a.foto, a.nama, a.nis, a.nisn, a.jenis_kelamin, f.level_id, f.nama_kelas," . " (SELECT COUNT(id) FROM users WHERE users.username = a.username) AS status"); goto Una0k; hVDhg: $this->db->or_like("a.nis", $search); goto QTmDg; XU3Z0: $this->db->join("kelas_siswa d", "d.id_siswa = a.id_siswa AND d.id_tp = " . $id_tp . " AND d.id_smt = " . $id_smt . '', "left"); goto eyytq; hxSyW: if (!($search != null)) { goto HGoxL; } goto wxGyF; zQZVx: $this->db->order_by("a.nama", "ASC"); goto XU3Z0; wxGyF: $this->db->like("a.nama", $search); goto hVDhg; h2d2d: $this->db->limit($limit, $offset); goto zQZVx; t2zdg: } public function getSiswaPage($id_tp, $id_smt, $offset, $limit, $filter, $search = null, $sort = null, $order = null) { goto nHyif; Prchh: $this->db->from("master_siswa a"); goto mP2Kl; Lz8hy: if (!($filter == "1")) { goto SXr9w; } goto ATkPo; yQdp7: BSfrp: goto Oq2Z6; ptwUC: SXr9w: goto xO855; mP2Kl: $this->db->limit($limit, $offset); goto q0Fdj; fGMju: iW82O: goto AQ4QZ; Oq2Z6: return $this->db->get()->result(); goto SZ44m; j4Kyq: $this->db->where("f.id_kelas IS NULL"); goto ZNPoi; sAfio: $this->db->or_like("a.nisn", $search); goto yQdp7; gvR5D: $this->db->order_by("a.nama", "ASC"); goto J3Oz_; J3Oz_: if (!($search != null)) { goto BSfrp; } goto qGSxc; GGuXT: $this->db->join("master_kelas f", "f.id_kelas=d.id_kelas", "left"); goto j4Kyq; hNIrr: $this->db->or_like("a.nis", $search); goto sAfio; xO855: goto SGJFF; goto fGMju; qGSxc: $this->db->like("a.nama", $search); goto hNIrr; nHyif: $this->db->select("a.id_siswa, a.foto, a.nama, a.nis, a.nisn, a.jenis_kelamin, d.id_kelas, " . "f.nama_kelas, (SELECT COUNT(id) FROM users WHERE users.username = a.username) AS aktif"); goto Prchh; bMB5N: $this->db->join("master_kelas f", "f.id_kelas=d.id_kelas", "left"); goto Lz8hy; ATkPo: $this->db->where("f.id_kelas IS NOT NULL"); goto ptwUC; zlHfo: $this->db->join("buku_induk u", "u.id_siswa=a.id_siswa AND u.status = " . $filter); goto bMB5N; ZNPoi: SGJFF: goto LwqiF; LwqiF: $this->db->order_by("f.nama_kelas", "ASC"); goto IDwEZ; bwZ6C: if ($filter == "5") { goto iW82O; } goto zlHfo; IDwEZ: $this->db->order_by("ISNULL(f.level_id), f.level_id ASC"); goto gvR5D; AQ4QZ: $this->db->join("buku_induk u", "u.id_siswa=a.id_siswa AND u.status = "1""); goto GGuXT; q0Fdj: $this->db->join("kelas_siswa d", "d.id_siswa=a.id_siswa AND d.id_tp = " . $id_tp . " AND d.id_smt = " . $id_smt . '', "left"); goto bwZ6C; SZ44m: } public function getSiswaTotalPage($id_tp, $id_smt, $filter, $search = null) { goto IfsEB; IfsEB: $this->db->select("a.id_siswa"); goto jC1NZ; XwejJ: $this->db->join("master_kelas f", "f.id_kelas=d.id_kelas", "left"); goto QLMRM; GmDsn: PPAML: goto hb1mw; mXzTm: $this->db->where("f.id_kelas IS NOT NULL"); goto GmDsn; CRJbr: $this->db->join("buku_induk u", "u.id_siswa=a.id_siswa AND u.status = " . $filter); goto XwejJ; ZXdkd: if ($filter == "5") { goto fv0rc; } goto CRJbr; F9H1Y: $this->db->or_like("a.nis", $search); goto OIlr2; jp1tb: MVf8Z: goto g5EY6; O757c: fv0rc: goto kXewR; mIWR2: N0pBC: goto oBJRb; ITCQ0: $this->db->like("a.nama", $search); goto F9H1Y; X9oF3: $this->db->where("f.id_kelas IS NULL"); goto jp1tb; hb1mw: goto MVf8Z; goto O757c; kXewR: $this->db->join("buku_induk u", "u.id_siswa=a.id_siswa AND u.status = "1""); goto nA5ei; OIlr2: $this->db->or_like("a.nisn", $search); goto mIWR2; nA5ei: $this->db->join("master_kelas f", "f.id_kelas=d.id_kelas", "left"); goto X9oF3; QLMRM: if (!($filter == "1")) { goto PPAML; } goto mXzTm; jC1NZ: $this->db->from("master_siswa a"); goto yHOVu; yHOVu: $this->db->join("kelas_siswa d", "d.id_siswa=a.id_siswa AND d.id_tp = " . $id_tp . " AND d.id_smt = " . $id_smt . '', "left"); goto ZXdkd; oBJRb: return $this->db->get()->num_rows(); goto uze3l; g5EY6: if (!($search != null)) { goto N0pBC; } goto ITCQ0; uze3l: } public function getDataSiswaByKelas($id_tp, $id_smt, $id_kelas, $offset, $limit, $search = null, $sort = null, $order = null) { goto p3N4X; Zvs17: return $this->db->get()->result(); goto lfR1n; z85FI: $this->db->like("b.nama", $search); goto Ts8Op; FiWu6: WSVeE: goto E2Hm0; PDWGm: $this->db->join("master_kelas f", "f.id_kelas=a.id_kelas"); goto s_Dsr; I03G4: if (!($search != null)) { goto a2X1v; } goto z85FI; jaSOi: $this->db->where("a.id_kelas", $id_kelas); goto Zvs17; Ts8Op: $this->db->or_like("b.nis", $search); goto ixBkW; Bi1Sv: a2X1v: goto PDWGm; scWTP: $this->db->limit($limit, $offset); goto FiWu6; p3N4X: $this->db->select("b.id_siswa, b.nama, b.nis, b.nisn, b.jenis_kelamin, b.username, b.password, b.foto," . " f.nama_kelas, (SELECT COUNT(id) FROM users WHERE users.username = b.username) AS aktif"); goto SfJO9; o3o6p: $this->db->where("a.id_smt", $id_smt); goto jaSOi; SfJO9: $this->db->from("kelas_siswa a"); goto FsVhB; ixBkW: $this->db->or_like("b.nisn", $search); goto Bi1Sv; s_Dsr: $this->db->where("a.id_tp", $id_tp); goto o3o6p; FsVhB: if (!($limit > 0)) { goto WSVeE; } goto scWTP; E2Hm0: $this->db->join("master_siswa b", "b.id_siswa=a.id_siswa", "right"); goto I03G4; lfR1n: } public function getDataSiswaByKelasPage($id_tp, $id_smt, $id_kelas, $search = null) { goto YEMQA; sMNTn: $this->db->where("a.id_tp", $id_tp); goto ISX8d; o1myt: $this->db->from("kelas_siswa a"); goto sMNTn; Mx3_u: $this->db->where("a.id_kelas", $id_kelas); goto jI8O5; HnqKK: return $this->db->get()->num_rows(); goto Q4ndz; tpnNz: $this->db->or_like("b.nis", $search); goto tFBCG; jSnDS: J5ZEb: goto HnqKK; ISX8d: $this->db->where("a.id_smt", $id_smt); goto Mx3_u; Jn4Pu: $this->db->like("b.nama", $search); goto tpnNz; yMFu0: if (!($search != null)) { goto J5ZEb; } goto Jn4Pu; jI8O5: $this->db->join("master_siswa b", "b.id_siswa=a.id_siswa"); goto yMFu0; YEMQA: $this->db->select("a.id_siswa"); goto o1myt; tFBCG: $this->db->or_like("b.nisn", $search); goto jSnDS; Q4ndz: } public function getSiswaById($id) { goto qP1sK; j0A_k: return $this->db->get()->row(); goto WRJyO; LsI7e: $this->db->join("buku_induk b", "a.id_siswa=b.id_siswa", "left"); goto gfFNw; gfFNw: $this->db->where("a.id_siswa", $id); goto j0A_k; z8Usg: $this->db->from("master_siswa a"); goto LsI7e; qP1sK: $this->db->select("a.*, b.status"); goto z8Usg; WRJyO: } public function getSiswaByArrNisn($arr_nisn, $arr_nis, $arr_username) { goto cIWsv; FX745: $this->db->or_where_in("username", $arr_username); goto j6OwK; fq1wG: $this->db->from("master_siswa"); goto KoyjS; KoyjS: $this->db->where_in("nisn", $arr_nisn); goto Bbby8; Bbby8: $this->db->or_where_in("nis", $arr_nis); goto FX745; j6OwK: return $this->db->get()->result(); goto WsXqK; cIWsv: $this->db->select("id_siswa, nama, nisn, nis, username"); goto fq1wG; WsXqK: } public function getSiswaKelasBaru($id_tp, $id_smt) { goto nKFBO; h9sUv: u71xz: goto AyGKi; n_9Wu: if (!$result) { goto u7iDF; } goto wVTSo; gKRJK: $ret = []; goto n_9Wu; nKFBO: $this->db->query("SET SQL_BIG_SELECTS=1"); goto AIycu; gJv1s: $this->db->join("master_kelas f", "f.id_kelas=a.id_kelas"); goto e9X5B; AyGKi: u7iDF: goto yOgAa; Q1HV_: $this->db->where("a.id_smt", $id_smt); goto KPseG; wVTSo: foreach ($result as $key => $row) { $ret[$row->id_siswa] = $row; k5T0o: } goto h9sUv; AIycu: $this->db->select("b.id_siswa, b.nama, f.id_kelas, f.nama_kelas, f.kode_kelas"); goto zx_tZ; LEqhL: $this->db->join("master_siswa b", "b.id_siswa=a.id_siswa"); goto gJv1s; zx_tZ: $this->db->from("kelas_siswa a"); goto LEqhL; yOgAa: return $ret; goto KMGPU; KPseG: $result = $this->db->get()->result(); goto gKRJK; e9X5B: $this->db->where("a.id_tp", $id_tp); goto Q1HV_; KMGPU: } public function getDataSiswaById($id_tp, $id_smt, $idSiswa) { goto vhNNi; r1JKl: $this->db->join("cbt_ruang i", "i.id_ruang=h.id_ruang", "left"); goto CdW3t; lpRjA: $this->db->where("a.id_siswa", $idSiswa); goto Cw0x1; AbG1x: $this->db->select("b.id_siswa, b.nama, b.jenis_kelamin, b.nis, b.nisn, b.username, b.password," . " b.foto, c.sesi_id, d.kode_ruang, e.kode_sesi, f.nama_kelas, g.nomor_peserta," . " h.set_siswa, i.kode_ruang as ruang_kelas, j.kode_sesi as sesi_kelas"); goto dLdDi; cRe37: $this->db->join("cbt_ruang d", "d.id_ruang=c.ruang_id", "left"); goto U3j81; D3YAv: $this->db->join("cbt_sesi_siswa c", "c.siswa_id=a.id_siswa", "left"); goto cRe37; ZHfEP: $this->db->join("master_kelas f", "f.id_kelas=a.id_kelas", "left"); goto EDDhc; dLdDi: $this->db->from("kelas_siswa a"); goto sj1yt; uEft2: $this->db->where("a.id_tp", $id_tp); goto PYKtn; CdW3t: $this->db->join("cbt_sesi j", "j.id_sesi=h.id_sesi", "left"); goto uEft2; PYKtn: $this->db->where("a.id_smt", $id_smt); goto lpRjA; gS9KF: $this->db->join("cbt_kelas_ruang h", "h.id_kelas=a.id_kelas", "left"); goto r1JKl; Cw0x1: return $this->db->get()->row(); goto lBzl0; sj1yt: $this->db->join("master_siswa b", "b.id_siswa=a.id_siswa", "left"); goto D3YAv; U3j81: $this->db->join("cbt_sesi e", "e.id_sesi=c.sesi_id", "left"); goto ZHfEP; EDDhc: $this->db->join("cbt_nomor_peserta g", "g.id_siswa=a.id_siswa AND g.id_tp=" . $id_tp, "left"); goto gS9KF; vhNNi: $this->db->query("SET SQL_BIG_SELECTS=1"); goto AbG1x; lBzl0: } public function getAgamaSiswa() { goto ByABJ; tzzKz: foreach ($result as $row) { $ret[$row->agama] = $row->agama; llxr1: } goto C8qUp; G8md6: $this->db->not_like("a.agama", "Pilih"); goto whTOF; whTOF: $result = $this->db->get()->result(); goto R7xf7; nCi0f: $this->db->where("a.agama != "0"", NULL, FALSE); goto G8md6; jaVCA: $this->db->where("a.agama is NOT NULL", NULL, FALSE); goto nCi0f; kuCVg: $this->db->distinct(); goto L5HfU; C8qUp: dSO1i: goto T2qZy; ByABJ: $this->db->select("agama"); goto kuCVg; R7xf7: $ret["-"] = "Bukan Mapel Agama"; goto tzzKz; T2qZy: return $ret; goto eVw7W; L5HfU: $this->db->from("master_siswa a"); goto jaVCA; eVw7W: } public function getJurusan() { goto zX75G; vk2iH: $this->db->join("master_jurusan", "jurusan_id=id_jurusan"); goto blhEk; cKPOs: $this->db->group_by("id_jurusan"); goto hpJKn; GC8Ls: return $query->result(); goto bc3kW; blhEk: $this->db->order_by("nama_jurusan", "ASC"); goto cKPOs; kABjL: $this->db->from("master_kelas"); goto vk2iH; zX75G: $this->db->select("id_jurusan, nama_jurusan"); goto kABjL; hpJKn: $query = $this->db->get(); goto GC8Ls; bc3kW: } public function getAllJurusan($id = null) { goto fz0vQ; kWylP: eKqJB: goto rgw8j; Av4dg: $this->db->from("jurusan_mapel"); goto jdf4Y; bZn_2: kBp3u: goto h5vqV; Mr6On: $this->db->from("master_jurusan"); goto Ezo4a; RRtoF: $this->db->order_by("nama_jurusan", "ASC"); goto HlVoD; mjBWK: es3LY: goto RRtoF; RA1NB: $jurusan = $this->db->get()->result(); goto c809O; fz0vQ: if ($id === null) { goto es3LY; } goto lXQLp; VEuk3: return $this->db->get()->result(); goto mWx2q; c809O: $id_jurusan = []; goto uH2qi; Ezo4a: $this->db->where_not_in("id_jurusan", $id_jurusan); goto VEuk3; uH2qi: foreach ($jurusan as $j) { $id_jurusan[] = $j->jurusan_id; Sl6Vt: } goto DfO4f; DfO4f: dl01N: goto JINQV; P3KfC: $id_jurusan = null; goto bZn_2; mWx2q: goto eKqJB; goto mjBWK; jdf4Y: $this->db->where("mapel_id", $id); goto RA1NB; lXQLp: $this->db->select("jurusan_id"); goto Av4dg; HlVoD: return $this->db->get("jurusan")->result(); goto kWylP; JINQV: if (!($id_jurusan === [])) { goto kBp3u; } goto P3KfC; h5vqV: $this->db->select("*"); goto Mr6On; rgw8j: } public function getKelasByJurusan($id) { $query = $this->db->get_where("master_kelas", array("jurusan_id" => $id)); return $query->result(); } public function getDataGuru($tp, $smt) { goto NapVU; n3Udd: $this->datatables->join("master_smt f", "b.id_smt=f.id_smt", "left"); goto QKw0O; fP0J_: $this->datatables->join("master_kelas d", "b.id_kelas=d.id_kelas AND d.id_tp=" . $tp . " AND d.id_smt=" . $smt . '', "left"); goto G0w6s; QKw0O: return $this->datatables->generate(); goto ntqau; Vilm7: $this->datatables->from("master_guru a"); goto z50f3; G0w6s: $this->datatables->join("master_tp e", "b.id_tp=e.id_tp", "left"); goto n3Udd; wwF3H: $this->datatables->join("level_guru c", "b.id_jabatan=c.id_level", "left"); goto fP0J_; NapVU: $this->db->query("SET SQL_BIG_SELECTS=1"); goto BO1X7; BO1X7: $this->datatables->select("a.id_guru, a.nama_guru, a.nip, a.kode_guru, a.jenis_kelamin, a.foto, b.id_jabatan, b.id_kelas, b.mapel_kelas, c.id_level, c.level, d.nama_kelas, e.tahun, f.nama_smt"); goto Vilm7; z50f3: $this->datatables->join("jabatan_guru b", "a.id_guru=b.id_guru AND b.id_tp=" . $tp . " AND b.id_smt=" . $smt . '', "left"); goto wwF3H; ntqau: } public function getAllDataGuru($tp, $smt) { goto fs3gD; u4k5E: $this->db->join("jabatan_guru b", "a.id_guru=b.id_guru AND b.id_tp=" . $tp . " AND b.id_smt=" . $smt . '', "left"); goto RSwGi; rFG9n: $this->db->from("master_guru a"); goto u4k5E; nrtH9: $this->db->join("master_tp e", "b.id_tp=e.id_tp", "left"); goto o0aEF; RSwGi: $this->db->join("level_guru c", "b.id_jabatan=c.id_level", "left"); goto whMUr; kbB1E: $this->db->order_by("c.id_level", "desc"); goto p25H5; fs3gD: $this->db->query("SET SQL_BIG_SELECTS=1"); goto WT30m; Cyncj: return $this->db->get()->result(); goto BMhFw; WT30m: $this->db->select("a.id_guru, a.nama_guru, a.nip, a.kode_guru, a.jenis_kelamin, a.foto, b.id_jabatan, b.id_kelas, b.mapel_kelas, b.ekstra_kelas, c.id_level, c.level, d.nama_kelas, e.tahun, f.nama_smt, (SELECT COUNT(id) FROM users e WHERE e.username = a.username) AS status"); goto rFG9n; o0aEF: $this->db->join("master_smt f", "b.id_smt=f.id_smt", "left"); goto kbB1E; p25H5: $this->db->order_by("a.id_guru", "asc"); goto Cyncj; whMUr: $this->db->join("master_kelas d", "b.id_kelas=d.id_kelas AND d.id_tp=" . $tp . " AND d.id_smt=" . $smt . '', "left"); goto nrtH9; BMhFw: } public function getGuruById($id, $id_tp = null, $id_smt = null) { goto fwK1U; G8uDN: D8Y_P: goto vwaGA; FoFjU: $this->db->join("jabatan_guru b", "a.id_guru=b.id_guru", "left"); goto BH2xo; BH2xo: $this->db->join("level_guru c", "b.id_jabatan=c.id_level", "left"); goto f2ELT; cjx6x: $this->db->join("master_kelas d", "a.id_guru=d.guru_id AND d.id_tp=" . $id_tp . " AND d.id_smt=" . $id_smt, "left"); goto G8uDN; p_0sE: return $this->db->get()->row(); goto WGIBa; f2ELT: if (!($id_tp != null && $id_smt != null)) { goto D8Y_P; } goto cjx6x; cPqMz: $this->db->select("*"); goto DrHLj; fwK1U: $this->db->query("SET SQL_BIG_SELECTS=1"); goto cPqMz; DrHLj: $this->db->from("master_guru a"); goto FoFjU; vwaGA: $this->db->where("a.id_guru", $id); goto p_0sE; WGIBa: } public function getGuruByArrId($arr_id) { goto u09HV; YO2QQ: if (!(count($arr_id) > 0)) { goto qaezi; } goto hX9PJ; hX9PJ: $this->db->where_in("id_guru", $arr_id); goto lzfBV; Vhhbi: $this->db->from("master_guru"); goto YO2QQ; Nv3W3: return $this->db->get()->result(); goto vaVyc; lzfBV: qaezi: goto Nv3W3; u09HV: $this->db->select("nama_guru, nip"); goto Vhhbi; vaVyc: } public function getUserIdGuruByUsername($username) { goto LGhdU; KpFGb: $this->db->join("level_guru c", "b.id_jabatan=c.id_level", "left"); goto twovJ; LGhdU: $this->db->query("SET SQL_BIG_SELECTS=1"); goto Q1Ci4; Q1Ci4: $this->db->select("*"); goto uor3w; uor3w: $this->db->from("master_guru a"); goto f3snX; PyXcU: return $this->db->get()->row(); goto JAtk0; twovJ: $this->db->where("a.username", $username); goto PyXcU; f3snX: $this->db->join("jabatan_guru b", "a.id_guru=b.id_guru", "left"); goto KpFGb; JAtk0: } public function getDetailJabatanGuru($id_guru) { goto vFg_8; GWERP: ZJ455: goto XCAza; t2gvG: $this->db->select("a.id_guru, a.nama_guru, b.id_tp, b.id_smt, b.mapel_kelas, b.ekstra_kelas, c.id_level, c.level, d.id_kelas, d.nama_kelas"); goto w2j0N; SxRM7: $ret = []; goto u45m2; p_WZy: $this->db->where("a.id_guru", $id_guru); goto ftShE; w2j0N: $this->db->from("master_guru a"); goto z7Pm3; XCAza: return $ret; goto foGYx; vFg_8: $this->db->query("SET SQL_BIG_SELECTS=1"); goto t2gvG; z7Pm3: $this->db->join("jabatan_guru b", "a.id_guru=b.id_guru", "left"); goto IOWYO; IOWYO: $this->db->join("level_guru c", "b.id_jabatan=c.id_level", "left"); goto M8Xmt; M8Xmt: $this->db->join("master_kelas d", "b.id_kelas=d.id_kelas", "left"); goto p_WZy; u45m2: foreach ($result as $row) { $ret[$row->id_tp][$row->id_smt] = $row; El7Jn: } goto GWERP; ftShE: $result = $this->db->get()->result(); goto SxRM7; foGYx: } public function getJabatanGuru($id_guru, $tp, $smt) { goto FFZoA; EidmE: $this->db->select("a.id_guru, a.nama_guru, b.mapel_kelas, b.ekstra_kelas, c.id_level, c.level, d.id_kelas, d.nama_kelas"); goto L1AQl; EB35n: $this->db->join("master_kelas d", "b.id_kelas=d.id_kelas AND d.id_tp=" . $tp . " AND d.id_smt=" . $smt . '', "left"); goto Sx9cL; FFZoA: $this->db->query("SET SQL_BIG_SELECTS=1"); goto EidmE; Sx9cL: $this->db->where("a.id_guru", $id_guru); goto mIAod; L1AQl: $this->db->from("master_guru a"); goto KRcIU; c4eVJ: $this->db->join("level_guru c", "b.id_jabatan=c.id_level", "left"); goto EB35n; mIAod: return $this->db->get()->row(); goto RIkkT; KRcIU: $this->db->join("jabatan_guru b", "a.id_guru=b.id_guru AND b.id_tp=" . $tp . " AND b.id_smt=" . $smt . '', "left"); goto c4eVJ; RIkkT: } public function getGuruMapel($tp, $smt) { goto annYi; annYi: $this->db->select("a.mapel_kelas, a.ekstra_kelas, a.id_jabatan, a.id_kelas, b.id_guru, b.nama_guru"); goto x5ZbT; ba9eZ: return $this->db->get()->result(); goto BdmPq; x5ZbT: $this->db->from("jabatan_guru a"); goto NOXUb; NOXUb: $this->db->join("master_guru b", "a.id_guru=b.id_guru"); goto JSbFW; JSbFW: $this->db->where("a.id_tp", $tp); goto fvXDf; fvXDf: $this->db->where("a.id_smt", $smt); goto ba9eZ; BdmPq: } public function getKodeKelompokMapel() { goto Efey2; WirIA: $ret = []; goto nYngZ; Mx6Xy: ka7qB: goto sO13X; mDKJx: $result = $this->db->get()->result(); goto WirIA; Efey2: $this->db->select("*"); goto N_CV8; nYngZ: foreach ($result as $row) { $ret[$row->kode_kel_mapel] = $row; ASbqA: } goto Mx6Xy; N_CV8: $this->db->from("master_kelompok_mapel"); goto kKAld; sO13X: return $ret; goto CmxRL; kKAld: $this->db->order_by("kode_kel_mapel"); goto mDKJx; CmxRL: } public function getDataKelompokMapel() { goto N0aRP; nFjcY: $this->db->where("id_parent", "0"); goto x3kIL; x3kIL: $this->db->order_by("kode_kel_mapel"); goto tGYC2; X5yMe: fweyk: goto BSGdv; tGYC2: $result = $this->db->get()->result(); goto vVkK3; ljWMV: foreach ($result as $row) { $ret[$row->id_kel_mapel] = $row; SkABx: } goto X5yMe; N0aRP: $this->db->select("*"); goto ptHhV; BSGdv: return $ret; goto NGjnh; ptHhV: $this->db->from("master_kelompok_mapel"); goto nFjcY; vVkK3: $ret = []; goto ljWMV; NGjnh: } public function getKategoriKelompokMapel() { goto YH177; LrZBu: $this->db->from("master_kelompok_mapel"); goto tvvAw; AKpGJ: $this->db->where("kategori", "WAJIB")->or_where("kategori", "PAI (Kemenag)"); goto LrZBu; YH177: $this->db->select("kode_kel_mapel, kategori"); goto AKpGJ; tvvAw: return $this->db->get()->result(); goto AurdY; AurdY: } public function getDataSubKelompokMapel() { goto SYpTH; d37ej: $this->db->where("id_parent <> 0"); goto N72qO; xt9sX: UlHWo: goto uYJG4; SYpTH: $this->db->select("*"); goto cRiwx; oCMhF: $result = $this->db->get()->result(); goto fzeBT; fzeBT: $ret = []; goto gVSim; gVSim: foreach ($result as $row) { $ret[$row->id_kel_mapel] = $row; pwb9T: } goto xt9sX; N72qO: $this->db->order_by("kode_kel_mapel"); goto oCMhF; uYJG4: return $ret; goto A_szD; cRiwx: $this->db->from("master_kelompok_mapel"); goto d37ej; A_szD: } public function getDataMapel() { goto bCDLz; bCDLz: $this->datatables->select("id_mapel, nama_mapel, kode"); goto mwF4n; mwF4n: $this->datatables->from("master_mapel"); goto QH1Nc; QH1Nc: return $this->datatables->generate(); goto OkzmG; OkzmG: } public function getAllMapel($arrKelompok = null, $arrMapel = null) { goto C0pJX; C4RO8: $this->db->where_in("kelompok", $arrKelompok); goto bWemv; zwCZT: $this->db->where("status", "1"); goto cKX3a; C0pJX: if (!($arrMapel != null)) { goto d0hxp; } goto C4RO8; wBCGu: et1ji: goto zwCZT; cKX3a: $this->db->order_by("urutan_tampil"); goto iRMp7; Ah21T: if (!($arrMapel != null)) { goto et1ji; } goto t68l4; iRMp7: return $this->db->get("master_mapel")->result(); goto ic1QJ; t68l4: $this->db->or_where_in("id_mapel", explode(",", $arrMapel)); goto wBCGu; bWemv: d0hxp: goto Ah21T; ic1QJ: } public function getAllStatusMapel($arrKelompok = null, $arrMapel = null) { goto H07iA; Wimdl: if (!($arrMapel != null)) { goto fJO27; } goto SK9W7; P8_wR: fJO27: goto N8vZQ; SgMQM: return $this->db->get("master_mapel")->result(); goto X4J67; H07iA: if (!($arrMapel != null)) { goto PGgbf; } goto hWNhh; N8vZQ: $this->db->order_by("urutan_tampil"); goto SgMQM; hWNhh: $this->db->where_in("kelompok", $arrKelompok); goto IeBOL; SK9W7: $this->db->or_where_in("id_mapel", explode(",", $arrMapel)); goto P8_wR; IeBOL: PGgbf: goto Wimdl; X4J67: } public function getAllMapelByKelompok($jenjang) { goto xciRO; a_XX4: $ret = []; goto GsMKs; mq09_: return $ret; goto PNlCB; xciRO: $this->db->where("status", "1"); goto rDZLU; KtkRR: $this->db->order_by("urutan_tampil"); goto ZKHUC; ZKHUC: $result = $this->db->get("master_mapel")->result(); goto a_XX4; g0gdn: kzn6C: goto mq09_; rDZLU: $this->db->order_by("urutan"); goto KtkRR; GsMKs: foreach ($result as $row) { $ret[$row->kelompok][] = $row; ouHsY: } goto g0gdn; PNlCB: } public function getAllMapelNonAktif($jenjang) { $this->db->where("status", "0"); return $this->db->get("master_mapel")->result(); } public function getMapelById($id, $single = false) { goto B18of; VG7_0: $this->db->order_by("nama_mapel"); goto ARhIG; k8lIm: return $query; goto nQfNJ; aZKwh: goto l6wF8; goto DWylE; AZFsG: $query = $this->db->get_where("master_mapel", array("id_mapel" => $id))->row(); goto aZKwh; DWylE: qOtQi: goto B_AHy; B_AHy: $this->db->where_in("id_mapel", $id); goto VG7_0; ARhIG: $query = $this->db->get("master_mapel")->result(); goto eHymO; B18of: if ($single === false) { goto qOtQi; } goto AZFsG; eHymO: l6wF8: goto k8lIm; nQfNJ: } function updateMapel() { goto a4hVm; eDD1v: $kelompok = $this->input->post("kelompok", true); goto r3QSC; hqk_O: $kode = $this->input->post("kode_mapel", true); goto eDD1v; r3QSC: $status = $this->input->post("status", true); goto klM44; EqHCk: $name = $this->input->post("nama_mapel", true); goto hqk_O; ItOPl: $this->db->where("id_mapel", $id); goto DWDqu; DWDqu: return $this->db->update("master_mapel"); goto bS6om; klM44: $urut = $this->input->post("urutan_tampil", true); goto jPGBp; P9H32: $this->db->set("status", $status); goto wKLQT; kgXHk: amtN0: goto P9H32; a4hVm: $id = $this->input->post("id_mapel"); goto EqHCk; wKLQT: $this->db->set("urutan_tampil", $urut); goto ItOPl; vo0BK: $this->db->set("kode", $kode); goto jVz5o; jVz5o: if (!($kelompok != null)) { goto amtN0; } goto YVaKb; YVaKb: $this->db->set("kelompok", $kelompok); goto kgXHk; jPGBp: $this->db->set("nama_mapel", $name); goto vo0BK; bS6om: } public function getAllEkstra() { return $this->db->get("master_ekstra")->result(); } public function getEkstraById($id, $single = false) { goto c9k_I; Ll5n9: return $query; goto M0uA3; EVfCI: op6Qh: goto UdZ1e; y8SdQ: $query = $this->db->get("master_ekstra")->result(); goto vxF_0; ur9RA: goto k0E3Q; goto EVfCI; G8kIr: $query = $this->db->get_where("master_ekstra", array("id_ekstra" => $id))->row(); goto ur9RA; c9k_I: if ($single === false) { goto op6Qh; } goto G8kIr; vxF_0: k0E3Q: goto Ll5n9; UdZ1e: $this->db->where_in("id_ekstra", $id); goto FsdFq; FsdFq: $this->db->order_by("nama_ekstra"); goto y8SdQ; M0uA3: } function updateEkstra() { goto GVSQ7; vYWtA: return $this->db->update("master_ekstra"); goto it9zG; GVSQ7: $id = $this->input->post("id_ekstra"); goto H8m30; cJN5Z: $this->db->set("nama_ekstra", $name); goto AxQDw; Fta8l: $this->db->where("id_ekstra", $id); goto vYWtA; H8m30: $name = $this->input->post("nama_ekstra", true); goto qjUy0; AxQDw: $this->db->set("kode_ekstra", $kode); goto Fta8l; qjUy0: $kode = $this->input->post("kode_ekstra", true); goto cJN5Z; it9zG: } public function getKelasGuru() { goto Z75dM; LrBZe: return $this->datatables->generate(); goto WKABX; M4WTK: $this->datatables->select("kelas_guru.id, guru.id_guru, guru.nip, guru.nama_guru, GROUP_CONCAT(master_kelas.nama_kelas) as kelas"); goto tg3xh; fdP81: $this->datatables->group_by("guru.nama_guru"); goto LrBZe; Q6clt: $this->datatables->join("master_kelas", "kelas_id=id_kelas"); goto x6dzj; tg3xh: $this->datatables->from("kelas_guru"); goto Q6clt; x6dzj: $this->datatables->join("master_guru", "guru_id=id_guru"); goto fdP81; Z75dM: $this->db->query("SET SQL_BIG_SELECTS=1"); goto M4WTK; WKABX: } public function getKelasByGuru($id) { goto X5Udd; f3uTD: $this->db->where("guru_id", $id); goto kAxkL; Ss9vB: $this->db->join("master_kelas", "kelas_guru.kelas_id=kelas.id_kelas"); goto f3uTD; X5Udd: $this->db->select("kelas.id_kelas"); goto Qk3KF; Qk3KF: $this->db->from("kelas_guru"); goto Ss9vB; kAxkL: return $this->db->get()->result(); goto k7cos; k7cos: } public function getAllJabatanGuru($id) { goto caClc; yNmUz: up_oR: goto sHkhZ; mpS8r: return $ret; goto Lsvw_; caClc: $result = $this->db->get_where("jabatan_guru", "id_guru=" . $id)->result(); goto adWNF; e_Dw2: foreach ($result as $key => $row) { $ret[$row->id_tp][$row->id_smt] = $row->id_kelas; Y2uec: } goto yNmUz; adWNF: $ret = []; goto g_GNx; sHkhZ: AzQOK: goto mpS8r; g_GNx: if (!$result) { goto AzQOK; } goto e_Dw2; Lsvw_: } public function getJurusanMapel() { goto TJycE; p5p_I: $this->datatables->from("jurusan_mapel"); goto s3TLa; C6B5M: $this->datatables->join("master_jurusan", "jurusan_id=id_jurusan"); goto gMnxn; Ng5xO: return $this->datatables->generate(); goto LYpdq; gMnxn: $this->datatables->group_by("master_mapel.nama_mapel"); goto Ng5xO; TJycE: $this->db->query("SET SQL_BIG_SELECTS=1"); goto hJhXu; s3TLa: $this->datatables->join("master_mapel", "mapel_id=id_mapel"); goto C6B5M; hJhXu: $this->datatables->select("jurusan_mapel.id, mapel.id_mapel, mapel.nama_mapel, jurusan.id_jurusan, GROUP_CONCAT(jurusan.nama_jurusan) as nama_jurusan"); goto p5p_I; LYpdq: } public function getMapel($id = null) { goto tLI_x; Ei2EO: JM9Gj: goto pp27E; tLI_x: $this->db->select("mapel_id"); goto r5PhN; TIrhG: foreach ($mapel as $d) { $id_mapel[] = $d->mapel_id; Z6fHJ: } goto zienz; MXc2C: $id_mapel = null; goto Ei2EO; gbpXV: $this->db->where_not_in("mapel_id", [$id]); goto CN_Uu; r5PhN: $this->db->from("jurusan_mapel"); goto G0Mbp; yXfS3: if (!($id_mapel === [])) { goto JM9Gj; } goto MXc2C; G0Mbp: if (!($id !== null)) { goto AilWi; } goto gbpXV; CKr1c: $id_mapel = []; goto TIrhG; zienz: AyD2D: goto yXfS3; CN_Uu: AilWi: goto Ma0pX; DrTQF: $this->db->from("master_mapel"); goto GvCou; Ma0pX: $mapel = $this->db->get()->result(); goto CKr1c; GvCou: $this->db->where_not_in("id_mapel", $id_mapel); goto ASsj1; pp27E: $this->db->select("id_mapel, nama_mapel"); goto DrTQF; ASsj1: return $this->db->get()->result(); goto sLsuB; sLsuB: } public function getJurusanByIdMapel($id) { goto FytXb; g_etC: return $this->db->get()->result(); goto tnpdQ; atmPT: $this->db->join("master_jurusan", "jurusan_mapel.jurusan_id=jurusan.id_jurusan"); goto kdL97; LPTXl: $this->db->from("jurusan_mapel"); goto atmPT; FytXb: $this->db->select("jurusan.id_jurusan"); goto LPTXl; kdL97: $this->db->where("mapel_id", $id); goto g_etC; tnpdQ: } public function getTahunActive() { goto KQtV4; KQtV4: $this->db->select("id_tp, tahun"); goto tof4P; tof4P: $this->db->from("master_tp"); goto z4Sin; ZamrK: return $this->db->get()->row(); goto vzBcU; z4Sin: $this->db->where("active", 1); goto ZamrK; vzBcU: } public function getSemesterActive() { goto mYeMd; mtiBd: $this->db->where("active", 1); goto uu8tG; uu8tG: return $this->db->get()->row(); goto lHstp; mYeMd: $this->db->select("id_smt, nama_smt, smt"); goto lYU0Z; lYU0Z: $this->db->from("master_smt"); goto mtiBd; lHstp: } public function getJmlHariEfektif($id) { goto tn4gz; tn4gz: $this->db->select("*"); goto ee1_R; ee1_R: $this->db->from("master_hari_efektif"); goto cQdzU; cQdzU: $this->db->where("id_hari_efektif", $id); goto m7y6l; m7y6l: return $this->db->get()->row(); goto yHIjA; yHIjA: } public function getDistinctTahunLulus() { goto zNZGs; Hw_8Y: $ret = []; goto Tv22h; jhbIq: JnyZZ: goto sf24b; Tv22h: foreach ($result as $row) { goto dMNC7; O5A0x: yBS2q: goto IHlx8; Br8i3: $ret[$row->tahun_lulus] = $row->tahun_lulus; goto j4R7V; dMNC7: if (!($row->tahun_lulus != '')) { goto eFSMO; } goto Br8i3; j4R7V: eFSMO: goto O5A0x; IHlx8: } goto jhbIq; sf24b: return $ret; goto Oedtw; DSAYu: $this->db->distinct(); goto KTha4; zNZGs: $this->db->select("tahun_lulus"); goto DSAYu; KTha4: $result = $this->db->get("buku_induk")->result(); goto Hw_8Y; Oedtw: } public function getDistinctKelasAkhir() { goto vLD_I; ciU24: foreach ($result as $row) { goto zGrDl; dBY3P: zndPS: goto At4Uj; EvWB1: kD5hw: goto dBY3P; fHppt: $ret[$row->kelas_akhir] = $row->kelas_akhir; goto EvWB1; zGrDl: if (!($row->kelas_akhir != '')) { goto kD5hw; } goto fHppt; At4Uj: } goto P41iT; hMyEA: $ret = []; goto ciU24; b5YVR: $result = $this->db->get("buku_induk")->result(); goto hMyEA; vLD_I: $this->db->select("kelas_akhir"); goto y1Akt; P41iT: cPWJO: goto R2U4D; R2U4D: return $ret; goto LnQ0t; y1Akt: $this->db->distinct(); goto b5YVR; LnQ0t: } public function getAlumniByTahun($tahun, $kelas = null) { goto OTL5W; O7Wqw: return $this->db->get()->result(); goto tgFQg; hByem: if (!($kelas != null)) { goto dF_QY; } goto xSu8v; xSu8v: $this->db->where("a.kelas_akhir", $kelas); goto pYRRG; eF6T4: $this->db->join("master_siswa b", "a.id_siswa=b.id_siswa"); goto MTacN; MTacN: $this->db->where("a.tahun_lulus", $tahun); goto hByem; fMl3h: $this->db->from("buku_induk a"); goto eF6T4; OTL5W: $this->db->select("*"); goto fMl3h; pYRRG: dF_QY: goto O7Wqw; tgFQg: } public function getAlumniById($id) { goto mOcs0; z4oDc: $this->db->where("a.id_siswa", $id); goto qkl_h; pRupb: $this->db->join("buku_induk b", "a.id_siswa=b.id_siswa"); goto z4oDc; mOcs0: $this->db->select("*"); goto RRifm; qkl_h: return $this->db->get()->row(); goto cCKwu; RRifm: $this->db->from("master_siswa a"); goto pRupb; cCKwu: } public function getAllWaliKelas() { goto pnh4h; gyf7F: $this->db->from("jabatan_guru a"); goto j2DWr; gSN3N: $this->db->join("master_kelas d", "a.id_kelas=d.id_kelas", "left"); goto K0VOR; j2DWr: $this->db->join("master_guru b", "a.id_guru=b.id_guru", "left"); goto uN2Ba; kWinZ: if (!$result) { goto hHHP8; } goto uc3yV; uc3yV: foreach ($result as $key => $row) { goto hbsly; J91w5: mJpKM: goto yJUoj; FxBer: fJJWg: goto J91w5; hbsly: if (!($row->id_level == "4")) { goto fJJWg; } goto IsnyN; IsnyN: $ret[$row->id_tp][$row->id_smt][$row->id_kelas] = $row; goto FxBer; yJUoj: } goto ZF_ow; xj27b: $ret = []; goto kWinZ; ZF_ow: Q9s3J: goto smyRH; cyMPg: $this->db->select("a.id_tp, a.id_smt, a.id_guru, b.nama_guru, c.id_level, c.level, d.id_kelas, d.nama_kelas"); goto gyf7F; DIVnD: return $ret; goto ZzoI_; pnh4h: $this->db->query("SET SQL_BIG_SELECTS=1"); goto cyMPg; smyRH: hHHP8: goto DIVnD; uN2Ba: $this->db->join("level_guru c", "a.id_jabatan=c.id_level", "left"); goto gSN3N; K0VOR: $result = $this->db->get()->result(); goto xj27b; ZzoI_: } public function getAllGuru() { goto QY7zN; lBS0G: return $this->db->get()->result(); goto k86ut; zQXCG: $guru = $this->db->get()->result(); goto OE_Jt; QY7zN: $this->db->select("id_guru"); goto qTcJW; qTcJW: $this->db->from("jabatan_guru"); goto zQXCG; JLuev: $this->db->from("master_guru"); goto xAG6p; OE_Jt: $id_guru = []; goto iejva; zxdzi: Z9RvR: goto Zq84v; Zq84v: $this->db->select("id_guru, nip, nama_guru"); goto JLuev; xAG6p: $this->db->where_in("id_guru", $id_guru); goto lBS0G; iejva: foreach ($guru as $d) { $id_guru[] = $d->id_guru; Xpzxl: } goto zxdzi; k86ut: } public function getAllKelas($tp = null, $smt = null) { goto RoSt6; xGd4L: return $ret; goto zf8ff; xnQcH: NOaFO: goto xlRKN; GDIV0: foreach ($result as $key => $row) { $ret[$row->id_kelas] = $row; HXDo_: } goto fQX5z; AVf71: $this->db->select("a.id_kelas, a.id_tp, a.id_smt, a.nama_kelas, a.kode_kelas, a.level_id, b.nama_jurusan, b.kode_jurusan, c.nama_guru"); goto SV4b5; uuGiV: goto aIAIG; goto gU7cb; zsKJ3: if ($tp != null && $smt != null) { goto lZgZi; } goto S29tH; SV4b5: $this->db->from("master_kelas a"); goto VpwSu; S29tH: if (!$result) { goto OO9Lw; } goto By32H; fQX5z: lhUty: goto xnQcH; yPCzY: $this->db->order_by("a.nama_kelas"); goto LUPZt; RMHT_: lCaNz: goto KAcCG; vFuEb: if (!$result) { goto NOaFO; } goto GDIV0; RoSt6: $this->db->query("SET SQL_BIG_SELECTS=1"); goto AVf71; VpwSu: if (!($tp != null && $smt != null)) { goto lCaNz; } goto X8fsD; X8fsD: $this->db->where("a.id_tp", $tp)->where("a.id_smt", $smt); goto RMHT_; wQUVf: $ret = []; goto zsKJ3; gU7cb: lZgZi: goto vFuEb; pEf3n: vw382: goto PV0xY; CWX5D: $this->db->join("master_guru c", "f.id_guru=c.id_guru", "left"); goto yPCzY; K1j8E: $this->db->join("master_jurusan b", "a.jurusan_id=b.id_jurusan", "left"); goto CWX5D; PV0xY: OO9Lw: goto uuGiV; xlRKN: aIAIG: goto xGd4L; By32H: foreach ($result as $key => $row) { $ret[$row->id_tp][$row->id_smt][$row->id_kelas] = $row; brjak: } goto pEf3n; KAcCG: $this->db->join("jabatan_guru f", "f.id_kelas=a.id_kelas", "left"); goto K1j8E; LUPZt: $result = $this->db->get()->result(); goto wQUVf; zf8ff: } public function getAllKelasSiswa() { goto D3L17; yunXP: f0tuG: goto bRxvZ; D3L17: $this->db->select("*"); goto oz2qe; uTpLU: $ret = []; goto awgBq; KlVwB: U3Hi1: goto yunXP; bRxvZ: return $ret; goto guHVv; oz2qe: $this->db->from("kelas_siswa"); goto oHuV8; awgBq: if (!$result) { goto f0tuG; } goto q3Gag; q3Gag: foreach ($result as $key => $row) { $ret[$row->id_kelas][$row->id_siswa] = $row; UXlfX: } goto KlVwB; oHuV8: $result = $this->db->get()->result(); goto uTpLU; guHVv: } public function getDataInduk() { goto hdoE3; pw1jT: $result = $this->db->get()->result(); goto VsPTb; d2k7B: return $ret; goto BOBmw; VsPTb: $ret = []; goto awQLR; OV_CA: $this->db->join("buku_induk b", "a.id_siswa=b.id_siswa", "left"); goto dh83w; hdoE3: $this->db->select("a.*, b.*,"); goto GkmDX; awQLR: if (!$result) { goto iiWCt; } goto rQb0n; dh83w: $this->db->order_by("a.nama", "ASC"); goto pw1jT; QxDNP: zkM85: goto dz_s3; GkmDX: $this->db->from("master_siswa a"); goto OV_CA; dz_s3: iiWCt: goto d2k7B; rQb0n: foreach ($result as $key => $row) { $ret[$row->id_siswa] = $row; MBANm: } goto QxDNP; BOBmw: } }
?>
Did this file decode correctly?
Original Code
<?php
/* ________________________________________
| GarudaCBT |
| https://github.com/garudacbt/cbt |
|________________________________________|
*/
defined("\102\101\x53\x45\120\x41\124\110") or exit("\116\x6f\40\144\151\x72\145\143\x74\40\x73\x63\x72\x69\160\164\40\x61\143\143\x65\x73\x73\x20\x61\154\154\x6f\x77\x65\x64"); class Master_model extends CI_Model { public function create($table, $data, $batch = false) { goto UcvEh; k9x_s: hDau3: goto APNiW; H4i8F: yG27h: goto Kh4mZ; UcvEh: if ($batch === false) { goto hDau3; } goto FsqcH; Kh4mZ: return $insert; goto OTYcf; FsqcH: $insert = $this->db->insert_batch($table, $data); goto KjVwm; APNiW: $insert = $this->db->insert($table, $data); goto H4i8F; KjVwm: goto yG27h; goto k9x_s; OTYcf: } public function update($table, $data, $pk, $id = null, $batch = false) { goto SBGj0; HiHC4: $insert = $this->db->update($table, $data, array($pk => $id)); goto a8sEv; n13_8: $insert = $this->db->update_batch($table, $data, $pk); goto ul1ll; ul1ll: goto XdoGJ; goto fd8JM; pTk3d: return $insert; goto dVayL; a8sEv: XdoGJ: goto pTk3d; SBGj0: if ($batch === false) { goto GR8Dx; } goto n13_8; fd8JM: GR8Dx: goto HiHC4; dVayL: } public function delete($table, $data, $pk) { goto K2Gpl; K2Gpl: $this->db->query("\x53\105\124\40\106\117\x52\x45\x49\x47\116\x5f\113\x45\x59\x5f\x43\x48\x45\103\x4b\x53\x3d\x30"); goto TXAWE; c36FV: $deleted = $this->db->delete($table); goto mIAgx; mIAgx: $this->db->query("\x53\105\x54\x20\x46\117\122\x45\111\x47\116\137\113\105\131\137\103\x48\105\x43\x4b\123\75\x31"); goto A8Wui; A8Wui: return $deleted; goto x69Zd; TXAWE: $this->db->where_in($pk, $data); goto c36FV; x69Zd: } public function delete_not($table, $data, $pk, $col, $not) { goto KHelY; c57cV: $this->db->where($col . "\41\x3d" . $not); goto mbfDo; KHelY: $this->db->where_in($pk, $data); goto c57cV; mbfDo: return $this->db->delete($table); goto aD_g8; aD_g8: } public function getDataKelas() { goto SXkBj; SXkBj: $this->datatables->select("\x69\144\x5f\153\x65\x6c\x61\163\54\x20\156\x61\x6d\x61\137\x6b\x65\x6c\141\163\54\x20\x69\144\x5f\152\165\x72\x75\163\x61\156\x2c\40\x6e\x61\x6d\x61\137\152\165\x72\x75\x73\x61\156"); goto wWfGL; wWfGL: $this->datatables->from("\155\141\163\164\x65\x72\137\x6b\x65\x6c\141\x73"); goto OZGyX; kITqC: return $this->datatables->generate(); goto hught; zMYTU: $this->datatables->add_column("\142\165\154\153\x5f\x73\145\x6c\145\x63\x74", "\74\x64\x69\166\40\x63\154\141\163\x73\x3d\x22\x74\145\170\x74\x2d\x63\145\x6e\x74\x65\x72\x22\76\x3c\x69\x6e\x70\165\x74\40\164\x79\x70\x65\75\42\143\x68\x65\x63\153\142\157\x78\42\x20\x63\x6c\x61\x73\x73\75\42\143\x68\x65\x63\x6b\42\40\x6e\141\x6d\x65\x3d\42\x63\x68\145\143\x6b\x65\x64\x5b\135\x22\x20\166\141\x6c\165\145\75\x22\44\x31\x22\x2f\76\x3c\x2f\x64\x69\x76\76", "\151\144\137\153\x65\154\x61\163\54\x20\x6e\141\x6d\141\x5f\x6b\145\154\141\163\x2c\x20\x69\144\137\x6a\165\x72\165\x73\141\156\x2c\40\x6e\x61\155\x61\137\152\165\162\165\163\x61\156"); goto kITqC; OZGyX: $this->datatables->join("\x6d\141\x73\164\145\162\x5f\152\165\162\165\163\141\156", "\152\165\162\165\x73\141\156\x5f\x69\x64\x3d\x69\144\137\x6a\x75\162\x75\x73\141\156"); goto zMYTU; hught: } public function getKelasById($id) { goto I0EJP; sq3yk: $this->db->where("\x69\144\137\x6b\145\x6c\141\163", $id); goto cYOCQ; Wgyfx: $this->db->from("\x6d\141\163\x74\x65\x72\x5f\x6b\145\x6c\x61\x73"); goto sq3yk; cYOCQ: $this->db->order_by("\156\141\155\x61\137\x6b\145\154\x61\x73"); goto QV4VL; QV4VL: return $this->db->get()->row(); goto l0MIM; I0EJP: $this->db->select("\151\x64\137\153\x65\x6c\141\163\x2c\40\156\x61\155\141\x5f\153\x65\154\x61\163\54\40\154\145\x76\x65\x6c\137\151\x64"); goto Wgyfx; l0MIM: } public function getDataJurusan() { goto U93gS; BU0Ly: return $this->db->get()->result(); goto tC3E_; B1q15: $this->db->from("\155\x61\x73\164\145\162\x5f\x6a\165\162\165\x73\141\x6e"); goto BU0Ly; U93gS: $this->db->select("\52"); goto B1q15; tC3E_: } public function getDataJurusanMapel($arrIds) { goto rI_Ad; q4mfp: if (!$result) { goto wpOHj; } goto MKlwH; dX4ZV: $this->db->from("\x6d\141\x73\164\145\162\137\x6d\141\x70\x65\x6c"); goto yR5AB; UVg1M: $result = $this->db->get()->result(); goto mKAg7; bMk6d: wpOHj: goto QeILI; QeILI: return $ret; goto Px5_7; mKAg7: $ret = []; goto q4mfp; xDCxg: Njxce: goto bMk6d; rI_Ad: $this->db->select("\x69\144\x5f\x6d\141\x70\x65\154\x2c\40\156\x61\x6d\141\x5f\x6d\x61\160\x65\x6c"); goto dX4ZV; yR5AB: $this->db->where_in("\x69\144\x5f\155\141\x70\145\x6c", $arrIds); goto UVg1M; MKlwH: foreach ($result as $key => $row) { $ret[$row->id_mapel] = $row->nama_mapel; gzZJc: } goto xDCxg; Px5_7: } public function getDataTableJurusan() { goto bOug9; JHHNg: $this->datatables->from("\155\x61\x73\164\145\162\137\152\165\162\x75\163\141\156"); goto oEAd5; Odsqk: return $this->datatables->generate(); goto x0xEI; bOug9: $this->datatables->select("\x2a"); goto JHHNg; oEAd5: $this->db->order_by("\151\144\x5f\x6a\165\x72\165\x73\x61\156"); goto Odsqk; x0xEI: } public function getJurusanById($id) { goto rNRka; IX1R6: return $this->db->get("\155\x61\163\164\x65\162\x5f\x6a\x75\x72\165\x73\141\156")->result(); goto GvSo8; dsqHn: $this->db->order_by("\156\141\155\141\137\152\165\162\x75\x73\141\x6e"); goto IX1R6; rNRka: $this->db->where_in("\x69\x64\137\152\x75\x72\x75\x73\x61\156", $id); goto dsqHn; GvSo8: } function updateJurusan() { goto gKsWq; YDHD6: EKWCr: goto zRXrb; h_5qy: $this->db->set("\156\x61\155\141\x5f\x6a\165\x72\x75\163\x61\156", $name); goto kJNjk; IR9Ge: $this->db->set("\163\x74\141\x74\x75\x73", "\61"); goto hIM7J; iz2kA: if (!($i <= $row_mapels)) { goto UXHRd; } goto XaIOf; kJNjk: $this->db->set("\x6b\x6f\x64\x65\137\x6a\165\162\x75\163\x61\156", $kode); goto gZX0A; age7C: UXHRd: goto Xdafv; hIM7J: $this->db->where("\x69\x64\x5f\x6a\x75\162\165\x73\141\156", $id); goto DIoXZ; DIoXZ: return $this->db->update("\155\141\163\x74\x65\162\137\152\165\162\165\x73\141\156"); goto bOZRF; D2_eo: $row_mapels = count($this->input->post("\x6d\x61\x70\x65\x6c", true)); goto s1Yr1; Xdafv: EtAsG: goto h_5qy; FjwSX: $kode = $this->input->post("\153\x6f\x64\145\137\x6a\x75\x72\x75\163\141\x6e", true); goto j4z9Y; s1Yr1: $i = 0; goto qIQP0; j4z9Y: $mapels = []; goto FdXaj; GKU2H: goto EphIn; goto age7C; qIQP0: EphIn: goto iz2kA; zRXrb: $i++; goto GKU2H; VZqQa: if (!$check_mapel) { goto EtAsG; } goto D2_eo; FdXaj: $check_mapel = $this->input->post("\x6d\x61\160\145\154", true); goto VZqQa; gKsWq: $id = $this->input->post("\x69\x64\x5f\152\x75\x72\x75\x73\x61\156"); goto BN0NQ; XaIOf: array_push($mapels, $this->input->post("\x6d\141\160\145\x6c\x5b" . $i . "\x5d", true)); goto YDHD6; gZX0A: $this->db->set("\x6d\x61\160\145\x6c\x5f\160\x65\155\151\x6e\x61\164\141\x6e", implode("\x2c", $mapels)); goto IR9Ge; BN0NQ: $name = $this->input->post("\x6e\x61\x6d\x61\137\152\165\x72\x75\163\x61\x6e", true); goto FjwSX; bOZRF: } public function inputJurusan() { $data = ["\156\x61\x6d\x61\x5f\x6a\x75\162\165\x73\141\156" => $this->input->post("\x6e\141\x6d\x61\x5f\x6a\165\162\x75\163\x61\156", true), "\x6b\x6f\x64\x65\137\152\x75\162\x75\163\141\156" => $this->input->post("\x6b\x6f\x64\x65\137\152\165\x72\165\x73\x61\x6e", true)]; return $this->db->insert("\155\141\163\x74\145\162\137\x6a\x75\162\x75\163\x61\156", $data); } public function getAllDataSiswa($id_tp, $id_smt) { goto U53G1; P7rC7: return $query->result(); goto ieBVl; ynRaO: $this->db->from("\155\x61\x73\164\x65\x72\x5f\x73\151\x73\167\x61\x20\141"); goto t7LXn; fLqSy: $query = $this->db->get(); goto P7rC7; dJXTd: $this->db->order_by("\x61\56\156\x61\155\141"); goto fLqSy; U53G1: $this->db->query("\x53\x45\124\x20\123\121\114\137\102\111\107\x5f\x53\105\x4c\105\x43\x54\x53\x3d\x31"); goto jQmaD; N_jof: $this->db->join("\x6d\x61\x73\x74\145\x72\x5f\x6b\145\154\141\x73\40\143", "\143\x2e\151\144\x5f\x6b\x65\x6c\141\163\75\x62\56\151\144\137\153\145\154\141\x73", "\x6c\x65\x66\x74"); goto wr7rj; t7LXn: $this->db->join("\153\145\154\141\163\137\x73\151\163\167\x61\x20\142", "\142\56\151\x64\x5f\163\151\x73\x77\141\x3d\141\56\151\144\137\163\151\163\x77\x61\x20\x41\x4e\x44\x20\142\x2e\151\144\x5f\164\160\x3d" . $id_tp . "\40\101\116\x44\x20\x62\56\x69\x64\x5f\x73\155\x74\x3d" . $id_smt . '', "\x6c\x65\146\x74"); goto N_jof; jQmaD: $this->db->select("\141\x2e\x2a\x2c\40\143\56\x6e\x61\155\x61\x5f\x6b\x65\154\141\163"); goto ynRaO; wr7rj: $this->db->order_by("\142\x2e\x69\144\x5f\153\x65\154\141\x73"); goto dJXTd; ieBVl: } public function getSiswaByKelas($id_tp, $id_smt, $id_kelas) { goto GCb1a; hndCi: $this->db->where("\141\x2e\151\x64\x5f\x74\x70", $id_tp); goto LfY1R; xFHZJ: $this->db->from("\x6b\145\154\x61\163\x5f\x73\151\x73\167\141\x20\141"); goto ZkyYU; LfY1R: $this->db->where("\141\x2e\151\x64\137\x73\x6d\x74", $id_smt); goto NHZel; GCb1a: $this->db->select("\x62\56\52"); goto xFHZJ; NHZel: $this->db->where("\x61\x2e\x69\144\x5f\x73\151\x73\167\141\40\151\163\x20\116\x4f\124\40\116\x55\x4c\114", NULL, FALSE); goto beJCG; ZkyYU: $this->db->join("\155\141\x73\x74\145\162\137\163\151\x73\x77\x61\x20\142", "\142\56\x69\x64\x5f\x73\151\x73\167\x61\75\141\56\151\x64\x5f\x73\151\x73\x77\141"); goto hndCi; K_FU2: return $this->db->get()->result(); goto eFYTI; UM_Ab: $this->db->where("\141\56\151\x64\137\153\x65\154\x61\163", $id_kelas); goto TPzne; beJCG: $this->db->where("\142\x2e\151\x64\x5f\x73\x69\x73\x77\141\x20\x69\x73\40\x4e\x4f\x54\40\x4e\x55\x4c\114", NULL, FALSE); goto UM_Ab; TPzne: $this->db->order_by("\x62\56\156\x61\155\x61", "\x41\123\x43"); goto K_FU2; eFYTI: } public function getDataSiswa($id_tp, $id_smt) { goto n8WBm; HQR67: return $this->datatables->generate(); goto CObiX; OsDZw: $this->datatables->join("\155\141\163\164\x65\162\x5f\x6b\x65\154\x61\x73\x20\146", "\x66\56\x69\x64\x5f\153\x65\x6c\141\x73\75\144\x2e\x69\x64\137\153\x65\x6c\141\x73", "\154\x65\146\x74"); goto ptAqt; n8WBm: $this->db->query("\123\105\x54\40\123\x51\114\137\x42\111\x47\x5f\123\x45\114\x45\103\x54\123\75\x31"); goto PsdsR; PsdsR: $this->datatables->select("\141\x2e\151\x64\x5f\x73\x69\163\x77\141\54\x20\141\x2e\146\157\x74\157\54\x20\141\x2e\x6e\141\155\141\54\40\141\x2e\156\151\163\x2c\40\x61\x2e\x6e\x69\x73\x6e\54\x20\141\x2e\x6a\145\x6e\x69\163\x5f\153\145\x6c\x61\155\x69\x6e\x2c\40\x66\56\154\145\166\145\x6c\137\x69\144\54\40\x66\x2e\x6e\x61\155\141\137\153\145\x6c\141\x73\x2c\x20\x62\x2e\163\164\x61\x74\x75\x73"); goto cmzZK; nefdv: $this->db->order_by("\146\x2e\x6e\141\155\141\x5f\153\145\x6c\x61\163", "\x41\x53\103"); goto WVLjs; webcY: $this->datatables->join("\x75\163\145\162\x73\40\143", "\x61\56\165\x73\x65\x72\x6e\141\x6d\x65\x3d\x63\56\x75\163\145\162\x6e\141\x6d\x65"); goto tWX5W; WVLjs: $this->db->order_by("\142\x2e\163\x74\x61\164\165\163", "\x41\x53\x43"); goto HQR67; cCkB6: $this->datatables->join("\x62\x75\153\x75\x5f\151\x6e\144\x75\x6b\40\142", "\141\56\x69\144\137\x73\151\163\167\141\x3d\142\x2e\x69\x64\x5f\163\x69\163\167\141", "\154\145\x66\164"); goto webcY; cmzZK: $this->datatables->from("\155\141\163\x74\x65\x72\137\163\151\x73\167\141\40\x61"); goto cCkB6; ptAqt: $this->db->order_by("\x49\x53\116\x55\x4c\x4c\50\x66\x2e\x6c\x65\x76\x65\x6c\137\151\144\51\54\x20\x66\x2e\154\x65\166\x65\154\137\151\144\40\101\123\x43"); goto nefdv; tWX5W: $this->datatables->join("\x6b\145\x6c\141\163\x5f\x73\x69\x73\167\x61\40\144", "\144\x2e\151\144\137\163\x69\x73\x77\x61\x20\x3d\40\x61\56\x69\144\x5f\163\x69\x73\167\x61\x20\x41\116\104\40\144\x2e\x69\144\x5f\x74\160\40\x3d\x20" . $id_tp . "\40\x41\116\104\40\144\x2e\151\x64\x5f\x73\x6d\x74\40\75\x20" . $id_smt . '', "\x6c\x65\x66\164"); goto OsDZw; CObiX: } public function getAllSiswa($id_tp, $id_smt, $offset, $limit, $search = null, $sort = null, $order = null) { goto DITkC; J4GSX: HGoxL: goto THiAj; QTmDg: $this->db->or_like("\141\x2e\156\x69\163\156", $search); goto J4GSX; Una0k: $this->db->from("\155\141\x73\164\x65\162\x5f\x73\x69\x73\167\x61\40\x61"); goto h2d2d; eyytq: $this->db->join("\155\x61\x73\x74\x65\162\x5f\x6b\145\154\141\163\40\x66", "\146\x2e\x69\x64\137\x6b\145\x6c\x61\163\x3d\x64\56\151\144\137\x6b\145\x6c\x61\x73", "\154\145\146\x74"); goto hxSyW; THiAj: return $this->db->get()->result(); goto t2zdg; DITkC: $this->db->select("\x61\56\151\144\137\x73\x69\x73\167\141\x2c\40\x61\56\x66\157\x74\157\54\x20\x61\x2e\156\141\x6d\141\x2c\x20\141\x2e\156\x69\x73\54\40\141\x2e\x6e\x69\163\156\x2c\x20\x61\56\152\x65\x6e\151\x73\137\x6b\145\x6c\x61\155\151\156\x2c\40\x66\x2e\x6c\145\x76\145\154\x5f\151\144\x2c\40\146\56\156\141\155\x61\x5f\153\x65\x6c\x61\163\54" . "\x20\50\123\x45\x4c\105\103\x54\40\x43\117\125\116\x54\x28\151\144\x29\x20\106\x52\117\x4d\x20\165\x73\145\162\x73\40\x57\x48\x45\122\105\40\165\163\x65\162\163\56\x75\163\145\162\156\x61\155\145\40\75\x20\141\56\x75\163\x65\162\156\141\x6d\x65\x29\40\101\x53\x20\x73\164\141\x74\x75\163"); goto Una0k; hVDhg: $this->db->or_like("\141\x2e\x6e\151\163", $search); goto QTmDg; XU3Z0: $this->db->join("\153\145\154\141\x73\137\x73\151\x73\x77\141\x20\x64", "\x64\x2e\151\x64\x5f\x73\x69\x73\x77\141\40\75\x20\141\x2e\x69\144\137\x73\x69\x73\x77\x61\x20\x41\x4e\x44\40\x64\56\151\x64\x5f\164\160\40\x3d\x20" . $id_tp . "\40\x41\x4e\104\40\144\56\x69\144\x5f\x73\x6d\164\x20\x3d\x20" . $id_smt . '', "\x6c\x65\x66\x74"); goto eyytq; hxSyW: if (!($search != null)) { goto HGoxL; } goto wxGyF; zQZVx: $this->db->order_by("\x61\x2e\x6e\141\x6d\x61", "\x41\x53\x43"); goto XU3Z0; wxGyF: $this->db->like("\x61\56\x6e\x61\155\x61", $search); goto hVDhg; h2d2d: $this->db->limit($limit, $offset); goto zQZVx; t2zdg: } public function getSiswaPage($id_tp, $id_smt, $offset, $limit, $filter, $search = null, $sort = null, $order = null) { goto nHyif; Prchh: $this->db->from("\155\x61\x73\x74\x65\162\137\163\151\x73\x77\x61\40\x61"); goto mP2Kl; Lz8hy: if (!($filter == "\61")) { goto SXr9w; } goto ATkPo; yQdp7: BSfrp: goto Oq2Z6; ptwUC: SXr9w: goto xO855; mP2Kl: $this->db->limit($limit, $offset); goto q0Fdj; fGMju: iW82O: goto AQ4QZ; Oq2Z6: return $this->db->get()->result(); goto SZ44m; j4Kyq: $this->db->where("\x66\56\x69\x64\137\x6b\145\x6c\141\x73\x20\111\x53\x20\116\125\114\114"); goto ZNPoi; sAfio: $this->db->or_like("\141\56\156\x69\x73\156", $search); goto yQdp7; gvR5D: $this->db->order_by("\141\x2e\x6e\141\x6d\141", "\x41\x53\103"); goto J3Oz_; J3Oz_: if (!($search != null)) { goto BSfrp; } goto qGSxc; GGuXT: $this->db->join("\x6d\141\x73\x74\x65\162\137\153\x65\x6c\141\x73\40\x66", "\146\x2e\x69\x64\137\x6b\x65\154\x61\x73\75\x64\56\x69\x64\x5f\x6b\145\154\x61\163", "\154\x65\146\x74"); goto j4Kyq; hNIrr: $this->db->or_like("\141\x2e\x6e\151\163", $search); goto sAfio; xO855: goto SGJFF; goto fGMju; qGSxc: $this->db->like("\141\x2e\x6e\x61\x6d\x61", $search); goto hNIrr; nHyif: $this->db->select("\141\x2e\151\x64\137\x73\151\x73\x77\141\x2c\40\x61\56\x66\157\164\157\x2c\x20\141\x2e\x6e\x61\x6d\141\x2c\x20\x61\x2e\156\151\163\54\x20\x61\x2e\156\151\x73\156\x2c\x20\x61\56\x6a\x65\x6e\151\163\137\153\145\x6c\141\x6d\151\x6e\x2c\40\144\x2e\x69\144\137\153\x65\154\x61\x73\x2c\x20" . "\x66\x2e\x6e\x61\155\x61\x5f\153\145\154\x61\163\x2c\40\x28\x53\105\114\105\x43\124\40\103\117\125\116\x54\50\x69\x64\x29\40\106\x52\117\115\40\x75\x73\145\162\163\x20\127\x48\105\x52\105\40\165\x73\x65\x72\x73\x2e\165\163\x65\x72\156\x61\x6d\x65\40\x3d\40\141\56\x75\163\145\162\x6e\x61\155\145\51\x20\101\x53\40\141\x6b\x74\x69\146"); goto Prchh; bMB5N: $this->db->join("\x6d\x61\x73\x74\x65\162\x5f\x6b\145\154\141\163\x20\x66", "\x66\56\151\x64\137\x6b\x65\x6c\141\163\x3d\x64\56\151\144\137\x6b\145\x6c\x61\x73", "\x6c\145\146\164"); goto Lz8hy; ATkPo: $this->db->where("\146\x2e\x69\144\137\x6b\x65\154\x61\x73\40\x49\x53\x20\x4e\x4f\x54\40\x4e\125\114\114"); goto ptwUC; zlHfo: $this->db->join("\x62\x75\153\165\137\151\156\x64\x75\x6b\40\x75", "\165\56\x69\144\x5f\x73\x69\x73\167\141\75\141\56\x69\x64\137\163\151\163\x77\141\40\x41\116\x44\40\x75\x2e\163\164\x61\164\165\x73\40\75\40" . $filter); goto bMB5N; ZNPoi: SGJFF: goto LwqiF; LwqiF: $this->db->order_by("\146\x2e\x6e\141\155\141\137\153\145\x6c\141\163", "\x41\123\x43"); goto IDwEZ; bwZ6C: if ($filter == "\x35") { goto iW82O; } goto zlHfo; IDwEZ: $this->db->order_by("\111\x53\116\125\x4c\x4c\x28\x66\x2e\x6c\x65\166\145\x6c\137\151\144\x29\x2c\x20\x66\x2e\154\145\166\145\x6c\137\x69\144\40\x41\x53\x43"); goto gvR5D; AQ4QZ: $this->db->join("\142\x75\x6b\x75\137\151\156\x64\x75\x6b\40\165", "\165\x2e\151\144\137\x73\151\x73\167\x61\x3d\141\56\151\144\137\163\x69\x73\x77\141\x20\x41\116\x44\x20\x75\x2e\163\164\141\164\165\x73\40\75\x20\42\61\42"); goto GGuXT; q0Fdj: $this->db->join("\x6b\x65\x6c\x61\x73\137\163\151\x73\167\x61\x20\x64", "\x64\56\x69\144\x5f\x73\151\x73\167\141\x3d\141\56\151\x64\x5f\x73\x69\163\167\x61\40\x41\116\104\x20\144\x2e\x69\x64\x5f\164\160\x20\x3d\x20" . $id_tp . "\40\101\116\104\x20\144\56\151\x64\x5f\x73\x6d\164\x20\x3d\40" . $id_smt . '', "\154\x65\146\x74"); goto bwZ6C; SZ44m: } public function getSiswaTotalPage($id_tp, $id_smt, $filter, $search = null) { goto IfsEB; IfsEB: $this->db->select("\x61\x2e\x69\144\x5f\x73\x69\163\x77\x61"); goto jC1NZ; XwejJ: $this->db->join("\155\141\x73\x74\x65\162\137\153\145\x6c\x61\x73\40\x66", "\x66\x2e\151\144\x5f\x6b\x65\154\141\163\x3d\144\56\x69\x64\137\153\x65\154\141\163", "\x6c\x65\x66\x74"); goto QLMRM; GmDsn: PPAML: goto hb1mw; mXzTm: $this->db->where("\x66\56\151\144\137\153\x65\x6c\141\x73\40\x49\123\x20\116\117\x54\x20\116\125\114\114"); goto GmDsn; CRJbr: $this->db->join("\x62\165\x6b\x75\x5f\x69\x6e\x64\x75\153\40\x75", "\165\56\x69\144\x5f\163\x69\x73\x77\141\75\x61\x2e\151\x64\x5f\163\151\163\167\x61\40\101\116\x44\40\165\x2e\x73\x74\141\x74\165\x73\x20\75\40" . $filter); goto XwejJ; ZXdkd: if ($filter == "\65") { goto fv0rc; } goto CRJbr; F9H1Y: $this->db->or_like("\x61\56\x6e\x69\x73", $search); goto OIlr2; jp1tb: MVf8Z: goto g5EY6; O757c: fv0rc: goto kXewR; mIWR2: N0pBC: goto oBJRb; ITCQ0: $this->db->like("\141\56\x6e\141\x6d\141", $search); goto F9H1Y; X9oF3: $this->db->where("\x66\x2e\151\144\137\153\x65\x6c\x61\x73\x20\111\123\x20\116\125\114\114"); goto jp1tb; hb1mw: goto MVf8Z; goto O757c; kXewR: $this->db->join("\142\x75\153\165\137\151\156\144\165\x6b\x20\165", "\165\56\x69\x64\x5f\163\x69\163\167\141\75\x61\56\151\144\137\x73\151\163\167\x61\x20\101\x4e\x44\40\165\56\163\x74\141\x74\x75\163\40\75\40\42\x31\42"); goto nA5ei; OIlr2: $this->db->or_like("\x61\x2e\x6e\151\163\156", $search); goto mIWR2; nA5ei: $this->db->join("\155\x61\x73\164\145\x72\137\x6b\145\154\141\x73\40\146", "\146\56\151\x64\x5f\x6b\145\154\141\163\75\x64\x2e\x69\x64\137\153\x65\154\141\163", "\x6c\145\146\164"); goto X9oF3; QLMRM: if (!($filter == "\61")) { goto PPAML; } goto mXzTm; jC1NZ: $this->db->from("\x6d\x61\x73\x74\145\x72\137\x73\151\x73\167\141\40\141"); goto yHOVu; yHOVu: $this->db->join("\x6b\145\x6c\x61\163\x5f\163\x69\x73\x77\141\40\144", "\x64\x2e\x69\x64\x5f\x73\151\163\167\141\75\141\x2e\x69\x64\x5f\163\151\163\x77\x61\40\101\116\x44\x20\144\56\151\144\x5f\164\160\40\75\40" . $id_tp . "\x20\101\116\x44\x20\x64\56\x69\x64\137\163\155\164\x20\75\x20" . $id_smt . '', "\154\x65\x66\x74"); goto ZXdkd; oBJRb: return $this->db->get()->num_rows(); goto uze3l; g5EY6: if (!($search != null)) { goto N0pBC; } goto ITCQ0; uze3l: } public function getDataSiswaByKelas($id_tp, $id_smt, $id_kelas, $offset, $limit, $search = null, $sort = null, $order = null) { goto p3N4X; Zvs17: return $this->db->get()->result(); goto lfR1n; z85FI: $this->db->like("\142\x2e\x6e\141\155\141", $search); goto Ts8Op; FiWu6: WSVeE: goto E2Hm0; PDWGm: $this->db->join("\x6d\141\x73\x74\145\162\137\x6b\145\x6c\x61\x73\40\x66", "\146\56\151\x64\x5f\153\x65\154\x61\x73\75\x61\56\151\144\137\153\145\x6c\x61\x73"); goto s_Dsr; I03G4: if (!($search != null)) { goto a2X1v; } goto z85FI; jaSOi: $this->db->where("\x61\56\x69\x64\137\x6b\145\x6c\141\x73", $id_kelas); goto Zvs17; Ts8Op: $this->db->or_like("\x62\56\x6e\151\163", $search); goto ixBkW; Bi1Sv: a2X1v: goto PDWGm; scWTP: $this->db->limit($limit, $offset); goto FiWu6; p3N4X: $this->db->select("\142\56\x69\x64\137\x73\151\163\167\x61\x2c\40\142\x2e\x6e\141\155\141\x2c\x20\x62\56\156\151\163\54\x20\142\56\156\x69\x73\156\54\40\142\x2e\152\x65\x6e\x69\x73\x5f\x6b\145\x6c\x61\x6d\x69\156\x2c\40\142\56\x75\x73\145\x72\x6e\x61\x6d\x65\x2c\x20\142\56\x70\x61\x73\x73\167\x6f\162\x64\54\x20\142\x2e\x66\157\164\157\54" . "\40\x66\x2e\156\x61\155\141\137\x6b\x65\x6c\x61\x73\x2c\x20\50\123\x45\114\x45\103\x54\x20\103\117\125\116\x54\x28\x69\x64\x29\40\106\122\117\115\x20\x75\x73\145\x72\x73\40\127\110\x45\122\x45\40\x75\x73\145\162\x73\x2e\x75\163\145\x72\x6e\x61\155\x65\40\75\x20\142\56\x75\x73\145\162\x6e\x61\155\145\51\40\101\123\x20\x61\153\164\151\x66"); goto SfJO9; o3o6p: $this->db->where("\141\56\x69\144\x5f\163\155\164", $id_smt); goto jaSOi; SfJO9: $this->db->from("\153\145\154\141\163\137\x73\x69\163\167\141\40\141"); goto FsVhB; ixBkW: $this->db->or_like("\142\x2e\156\151\x73\x6e", $search); goto Bi1Sv; s_Dsr: $this->db->where("\x61\56\151\x64\x5f\164\160", $id_tp); goto o3o6p; FsVhB: if (!($limit > 0)) { goto WSVeE; } goto scWTP; E2Hm0: $this->db->join("\155\141\163\x74\145\162\x5f\163\151\x73\167\141\40\x62", "\142\x2e\x69\x64\x5f\163\x69\163\x77\x61\x3d\x61\56\151\144\x5f\163\x69\x73\167\x61", "\x72\x69\x67\150\x74"); goto I03G4; lfR1n: } public function getDataSiswaByKelasPage($id_tp, $id_smt, $id_kelas, $search = null) { goto YEMQA; sMNTn: $this->db->where("\x61\56\151\144\x5f\164\x70", $id_tp); goto ISX8d; o1myt: $this->db->from("\x6b\x65\154\x61\x73\x5f\163\151\x73\167\x61\x20\141"); goto sMNTn; Mx3_u: $this->db->where("\x61\56\x69\x64\x5f\153\145\154\x61\x73", $id_kelas); goto jI8O5; HnqKK: return $this->db->get()->num_rows(); goto Q4ndz; tpnNz: $this->db->or_like("\x62\56\x6e\151\x73", $search); goto tFBCG; jSnDS: J5ZEb: goto HnqKK; ISX8d: $this->db->where("\x61\56\x69\x64\137\x73\155\164", $id_smt); goto Mx3_u; Jn4Pu: $this->db->like("\142\56\x6e\141\x6d\141", $search); goto tpnNz; yMFu0: if (!($search != null)) { goto J5ZEb; } goto Jn4Pu; jI8O5: $this->db->join("\155\x61\163\x74\145\x72\137\x73\151\x73\167\141\40\x62", "\142\x2e\151\144\x5f\x73\151\x73\167\141\75\x61\56\x69\x64\x5f\163\151\x73\167\x61"); goto yMFu0; YEMQA: $this->db->select("\x61\x2e\x69\x64\137\163\151\163\x77\141"); goto o1myt; tFBCG: $this->db->or_like("\x62\x2e\156\x69\x73\156", $search); goto jSnDS; Q4ndz: } public function getSiswaById($id) { goto qP1sK; j0A_k: return $this->db->get()->row(); goto WRJyO; LsI7e: $this->db->join("\x62\x75\x6b\165\137\151\x6e\144\x75\153\40\x62", "\x61\56\x69\x64\137\163\x69\163\167\141\x3d\142\x2e\151\x64\137\163\151\x73\x77\141", "\154\x65\146\x74"); goto gfFNw; gfFNw: $this->db->where("\x61\56\x69\x64\x5f\x73\151\163\167\x61", $id); goto j0A_k; z8Usg: $this->db->from("\155\141\x73\164\145\x72\137\x73\x69\163\167\141\40\141"); goto LsI7e; qP1sK: $this->db->select("\141\x2e\x2a\54\40\x62\x2e\x73\164\141\x74\165\163"); goto z8Usg; WRJyO: } public function getSiswaByArrNisn($arr_nisn, $arr_nis, $arr_username) { goto cIWsv; FX745: $this->db->or_where_in("\x75\163\x65\162\x6e\141\x6d\x65", $arr_username); goto j6OwK; fq1wG: $this->db->from("\155\x61\163\x74\x65\162\137\x73\x69\x73\167\141"); goto KoyjS; KoyjS: $this->db->where_in("\156\151\163\156", $arr_nisn); goto Bbby8; Bbby8: $this->db->or_where_in("\156\x69\163", $arr_nis); goto FX745; j6OwK: return $this->db->get()->result(); goto WsXqK; cIWsv: $this->db->select("\151\x64\x5f\163\x69\x73\167\x61\54\x20\156\x61\155\141\x2c\40\x6e\151\163\x6e\x2c\x20\156\151\163\54\x20\x75\x73\145\x72\156\141\155\x65"); goto fq1wG; WsXqK: } public function getSiswaKelasBaru($id_tp, $id_smt) { goto nKFBO; h9sUv: u71xz: goto AyGKi; n_9Wu: if (!$result) { goto u7iDF; } goto wVTSo; gKRJK: $ret = []; goto n_9Wu; nKFBO: $this->db->query("\123\105\x54\40\123\121\x4c\137\102\111\107\x5f\123\x45\x4c\x45\103\x54\123\x3d\61"); goto AIycu; gJv1s: $this->db->join("\155\x61\163\164\145\162\x5f\153\145\154\x61\x73\x20\x66", "\x66\56\x69\x64\x5f\153\145\154\141\x73\75\141\56\x69\144\x5f\153\x65\x6c\141\163"); goto e9X5B; AyGKi: u7iDF: goto yOgAa; Q1HV_: $this->db->where("\141\x2e\x69\144\137\163\155\x74", $id_smt); goto KPseG; wVTSo: foreach ($result as $key => $row) { $ret[$row->id_siswa] = $row; k5T0o: } goto h9sUv; AIycu: $this->db->select("\x62\x2e\151\144\x5f\163\151\163\167\x61\54\x20\x62\56\x6e\x61\x6d\141\54\x20\x66\56\x69\x64\137\153\x65\x6c\141\x73\x2c\40\146\x2e\x6e\x61\x6d\x61\x5f\153\x65\154\x61\163\54\x20\x66\x2e\x6b\157\x64\145\x5f\153\x65\154\x61\163"); goto zx_tZ; LEqhL: $this->db->join("\x6d\141\x73\164\x65\162\x5f\x73\151\x73\167\x61\x20\x62", "\142\x2e\x69\144\x5f\x73\151\163\167\x61\75\141\56\151\x64\137\163\x69\x73\167\x61"); goto gJv1s; zx_tZ: $this->db->from("\153\145\x6c\x61\163\x5f\x73\151\x73\167\x61\40\x61"); goto LEqhL; yOgAa: return $ret; goto KMGPU; KPseG: $result = $this->db->get()->result(); goto gKRJK; e9X5B: $this->db->where("\141\x2e\x69\144\137\x74\160", $id_tp); goto Q1HV_; KMGPU: } public function getDataSiswaById($id_tp, $id_smt, $idSiswa) { goto vhNNi; r1JKl: $this->db->join("\x63\142\x74\137\162\165\141\x6e\x67\x20\x69", "\x69\56\151\144\137\x72\x75\x61\x6e\147\x3d\x68\56\151\144\x5f\x72\x75\141\156\147", "\154\145\146\x74"); goto CdW3t; lpRjA: $this->db->where("\141\56\x69\144\137\163\151\163\167\x61", $idSiswa); goto Cw0x1; AbG1x: $this->db->select("\x62\56\151\x64\137\x73\x69\x73\x77\141\x2c\x20\142\x2e\156\x61\x6d\141\x2c\40\x62\56\152\x65\x6e\x69\163\x5f\x6b\145\x6c\x61\155\151\156\x2c\40\142\56\156\x69\163\x2c\40\x62\56\156\151\x73\156\54\40\142\56\165\163\145\162\x6e\141\x6d\x65\x2c\40\142\x2e\160\x61\x73\163\x77\157\x72\x64\x2c" . "\x20\142\56\146\157\x74\x6f\54\x20\x63\x2e\163\145\163\x69\x5f\x69\x64\x2c\x20\x64\x2e\x6b\x6f\x64\145\x5f\162\x75\x61\x6e\147\x2c\x20\x65\x2e\153\x6f\144\x65\137\163\145\x73\151\x2c\40\x66\x2e\156\141\155\x61\137\x6b\145\x6c\x61\x73\54\x20\147\x2e\x6e\x6f\x6d\x6f\x72\x5f\x70\145\x73\x65\x72\x74\x61\54" . "\x20\x68\56\x73\145\164\x5f\163\x69\x73\x77\141\54\40\x69\x2e\x6b\157\x64\145\x5f\x72\x75\x61\156\x67\x20\x61\x73\x20\x72\x75\141\x6e\x67\x5f\x6b\x65\154\x61\163\54\x20\x6a\x2e\x6b\157\x64\x65\x5f\x73\145\163\x69\x20\141\x73\40\x73\x65\163\x69\x5f\153\145\154\141\163"); goto dLdDi; cRe37: $this->db->join("\x63\x62\x74\x5f\162\165\141\156\147\40\144", "\x64\x2e\x69\144\x5f\162\x75\x61\x6e\x67\x3d\x63\x2e\x72\x75\x61\x6e\147\137\x69\144", "\154\x65\146\164"); goto U3j81; D3YAv: $this->db->join("\143\142\164\137\163\x65\x73\x69\137\163\151\163\167\141\40\143", "\x63\x2e\163\151\x73\167\141\x5f\x69\144\x3d\x61\56\x69\144\137\163\151\163\167\141", "\x6c\145\x66\x74"); goto cRe37; ZHfEP: $this->db->join("\x6d\x61\x73\x74\x65\x72\x5f\x6b\145\154\x61\x73\x20\146", "\146\x2e\151\x64\x5f\153\x65\154\x61\163\75\x61\56\x69\x64\137\x6b\145\154\x61\x73", "\154\145\x66\164"); goto EDDhc; dLdDi: $this->db->from("\153\x65\154\x61\163\x5f\163\151\x73\167\x61\40\141"); goto sj1yt; uEft2: $this->db->where("\x61\x2e\151\x64\137\x74\x70", $id_tp); goto PYKtn; CdW3t: $this->db->join("\x63\142\x74\x5f\163\x65\x73\151\x20\152", "\152\56\x69\x64\137\163\145\163\x69\75\x68\x2e\x69\x64\137\163\145\x73\151", "\x6c\x65\146\164"); goto uEft2; PYKtn: $this->db->where("\141\56\151\144\x5f\163\155\x74", $id_smt); goto lpRjA; gS9KF: $this->db->join("\143\142\x74\x5f\153\145\154\x61\163\137\162\x75\141\x6e\147\40\150", "\150\x2e\x69\144\137\x6b\145\154\x61\163\x3d\x61\x2e\151\x64\x5f\x6b\145\154\141\x73", "\154\x65\x66\x74"); goto r1JKl; Cw0x1: return $this->db->get()->row(); goto lBzl0; sj1yt: $this->db->join("\x6d\x61\163\164\145\x72\x5f\x73\151\163\167\x61\x20\x62", "\142\x2e\151\144\x5f\x73\x69\163\x77\141\x3d\x61\56\151\x64\x5f\x73\x69\x73\x77\141", "\154\x65\146\x74"); goto D3YAv; U3j81: $this->db->join("\143\x62\164\137\x73\x65\163\x69\x20\x65", "\x65\56\151\144\137\x73\145\163\x69\x3d\143\56\163\145\163\x69\x5f\x69\x64", "\154\145\146\164"); goto ZHfEP; EDDhc: $this->db->join("\143\x62\164\x5f\x6e\157\x6d\157\162\x5f\160\x65\163\x65\x72\164\x61\40\x67", "\x67\56\151\x64\x5f\163\x69\x73\167\x61\x3d\141\x2e\x69\x64\x5f\163\x69\x73\167\141\40\x41\116\x44\x20\147\x2e\x69\x64\137\164\160\x3d" . $id_tp, "\x6c\145\x66\164"); goto gS9KF; vhNNi: $this->db->query("\123\x45\124\x20\123\x51\x4c\137\102\111\x47\137\x53\105\x4c\105\x43\124\x53\x3d\61"); goto AbG1x; lBzl0: } public function getAgamaSiswa() { goto ByABJ; tzzKz: foreach ($result as $row) { $ret[$row->agama] = $row->agama; llxr1: } goto C8qUp; G8md6: $this->db->not_like("\141\x2e\141\x67\x61\155\141", "\x50\151\154\151\150"); goto whTOF; whTOF: $result = $this->db->get()->result(); goto R7xf7; nCi0f: $this->db->where("\141\x2e\x61\x67\141\x6d\x61\x20\41\75\40\x22\60\42", NULL, FALSE); goto G8md6; jaVCA: $this->db->where("\141\x2e\x61\147\x61\155\x61\40\151\163\40\x4e\117\x54\x20\116\x55\114\114", NULL, FALSE); goto nCi0f; kuCVg: $this->db->distinct(); goto L5HfU; C8qUp: dSO1i: goto T2qZy; ByABJ: $this->db->select("\x61\147\x61\155\x61"); goto kuCVg; R7xf7: $ret["\x2d"] = "\102\x75\x6b\x61\156\40\x4d\x61\x70\145\x6c\x20\x41\147\141\x6d\141"; goto tzzKz; T2qZy: return $ret; goto eVw7W; L5HfU: $this->db->from("\155\141\x73\x74\145\162\x5f\163\151\x73\167\141\x20\x61"); goto jaVCA; eVw7W: } public function getJurusan() { goto zX75G; vk2iH: $this->db->join("\x6d\141\x73\164\145\162\x5f\x6a\165\162\165\x73\141\x6e", "\152\x75\162\165\x73\x61\156\x5f\151\x64\75\x69\144\x5f\x6a\x75\x72\x75\x73\x61\x6e"); goto blhEk; cKPOs: $this->db->group_by("\151\x64\x5f\152\x75\162\165\163\141\x6e"); goto hpJKn; GC8Ls: return $query->result(); goto bc3kW; blhEk: $this->db->order_by("\x6e\141\155\x61\x5f\152\x75\162\x75\163\x61\156", "\101\x53\103"); goto cKPOs; kABjL: $this->db->from("\155\141\163\x74\145\162\137\x6b\145\154\141\x73"); goto vk2iH; zX75G: $this->db->select("\151\144\x5f\152\165\162\x75\163\x61\x6e\54\x20\156\141\155\141\137\152\165\162\x75\x73\x61\156"); goto kABjL; hpJKn: $query = $this->db->get(); goto GC8Ls; bc3kW: } public function getAllJurusan($id = null) { goto fz0vQ; kWylP: eKqJB: goto rgw8j; Av4dg: $this->db->from("\152\165\162\165\x73\x61\x6e\137\x6d\141\160\x65\154"); goto jdf4Y; bZn_2: kBp3u: goto h5vqV; Mr6On: $this->db->from("\155\x61\x73\x74\145\162\x5f\152\165\x72\x75\163\x61\156"); goto Ezo4a; RRtoF: $this->db->order_by("\x6e\141\x6d\x61\x5f\152\x75\162\165\x73\x61\156", "\x41\x53\103"); goto HlVoD; mjBWK: es3LY: goto RRtoF; RA1NB: $jurusan = $this->db->get()->result(); goto c809O; fz0vQ: if ($id === null) { goto es3LY; } goto lXQLp; VEuk3: return $this->db->get()->result(); goto mWx2q; c809O: $id_jurusan = []; goto uH2qi; Ezo4a: $this->db->where_not_in("\151\x64\137\152\165\x72\165\163\141\156", $id_jurusan); goto VEuk3; uH2qi: foreach ($jurusan as $j) { $id_jurusan[] = $j->jurusan_id; Sl6Vt: } goto DfO4f; DfO4f: dl01N: goto JINQV; P3KfC: $id_jurusan = null; goto bZn_2; mWx2q: goto eKqJB; goto mjBWK; jdf4Y: $this->db->where("\x6d\x61\160\x65\x6c\137\151\x64", $id); goto RA1NB; lXQLp: $this->db->select("\152\x75\162\x75\x73\141\156\137\151\x64"); goto Av4dg; HlVoD: return $this->db->get("\x6a\x75\162\165\x73\x61\x6e")->result(); goto kWylP; JINQV: if (!($id_jurusan === [])) { goto kBp3u; } goto P3KfC; h5vqV: $this->db->select("\52"); goto Mr6On; rgw8j: } public function getKelasByJurusan($id) { $query = $this->db->get_where("\x6d\141\163\164\x65\x72\137\153\x65\154\x61\x73", array("\x6a\165\162\165\163\141\156\x5f\151\x64" => $id)); return $query->result(); } public function getDataGuru($tp, $smt) { goto NapVU; n3Udd: $this->datatables->join("\155\141\163\x74\x65\162\x5f\163\155\x74\40\146", "\x62\56\x69\x64\137\163\x6d\164\75\146\56\x69\144\x5f\163\155\x74", "\154\145\x66\164"); goto QKw0O; fP0J_: $this->datatables->join("\x6d\141\x73\164\145\x72\x5f\x6b\x65\154\x61\x73\40\x64", "\142\56\x69\144\x5f\153\x65\x6c\141\x73\x3d\x64\x2e\151\x64\x5f\153\145\x6c\141\163\x20\x41\x4e\x44\40\144\x2e\151\x64\137\x74\x70\x3d" . $tp . "\x20\101\116\104\40\x64\56\151\144\x5f\x73\155\164\x3d" . $smt . '', "\154\x65\146\164"); goto G0w6s; QKw0O: return $this->datatables->generate(); goto ntqau; Vilm7: $this->datatables->from("\155\x61\x73\164\x65\x72\x5f\147\165\162\165\x20\x61"); goto z50f3; G0w6s: $this->datatables->join("\155\141\163\x74\145\x72\x5f\x74\x70\x20\x65", "\x62\x2e\x69\x64\137\x74\x70\x3d\x65\x2e\151\144\137\164\160", "\154\x65\146\164"); goto n3Udd; wwF3H: $this->datatables->join("\x6c\x65\166\x65\x6c\137\x67\165\162\165\x20\143", "\142\56\151\x64\x5f\152\141\142\141\x74\141\x6e\x3d\x63\x2e\x69\x64\x5f\154\145\x76\x65\x6c", "\x6c\145\146\x74"); goto fP0J_; NapVU: $this->db->query("\123\105\124\x20\123\121\x4c\137\102\x49\107\x5f\x53\x45\114\105\x43\x54\123\75\x31"); goto BO1X7; BO1X7: $this->datatables->select("\x61\x2e\151\144\x5f\147\165\162\165\x2c\40\x61\x2e\x6e\x61\x6d\x61\137\x67\x75\x72\x75\54\x20\141\x2e\156\151\x70\x2c\40\141\x2e\153\x6f\144\x65\137\x67\165\x72\x75\54\x20\x61\x2e\x6a\x65\x6e\x69\163\x5f\x6b\x65\x6c\x61\x6d\151\156\x2c\40\141\x2e\x66\157\x74\x6f\54\40\142\x2e\151\144\137\152\x61\142\x61\x74\141\156\x2c\x20\x62\56\x69\x64\137\x6b\145\154\141\163\x2c\x20\x62\x2e\x6d\x61\160\145\154\137\x6b\145\154\x61\163\x2c\40\143\x2e\151\x64\137\154\145\166\x65\154\x2c\40\x63\56\154\145\166\x65\154\54\40\144\x2e\156\141\x6d\x61\137\x6b\x65\x6c\x61\x73\54\40\x65\x2e\164\141\x68\x75\156\x2c\40\146\56\156\x61\155\x61\x5f\x73\x6d\164"); goto Vilm7; z50f3: $this->datatables->join("\152\141\x62\x61\164\x61\156\137\x67\x75\x72\165\40\x62", "\x61\x2e\x69\x64\x5f\x67\x75\x72\x75\75\x62\x2e\x69\144\x5f\x67\x75\x72\165\40\101\116\104\x20\x62\x2e\x69\x64\137\164\160\75" . $tp . "\x20\x41\116\x44\40\142\56\151\144\x5f\x73\x6d\164\x3d" . $smt . '', "\154\145\146\x74"); goto wwF3H; ntqau: } public function getAllDataGuru($tp, $smt) { goto fs3gD; u4k5E: $this->db->join("\152\141\142\x61\164\141\156\x5f\x67\x75\x72\x75\40\x62", "\141\56\x69\144\137\x67\165\x72\165\x3d\x62\x2e\151\x64\137\x67\165\x72\165\x20\x41\x4e\x44\40\x62\56\x69\144\137\164\160\x3d" . $tp . "\x20\x41\116\x44\x20\x62\x2e\151\x64\137\163\155\164\x3d" . $smt . '', "\154\x65\x66\164"); goto RSwGi; rFG9n: $this->db->from("\155\141\163\164\x65\x72\137\x67\165\162\x75\40\x61"); goto u4k5E; nrtH9: $this->db->join("\x6d\x61\163\x74\x65\x72\137\164\x70\x20\145", "\x62\56\151\144\137\164\160\x3d\145\56\151\x64\x5f\x74\x70", "\x6c\x65\x66\164"); goto o0aEF; RSwGi: $this->db->join("\x6c\145\166\145\154\137\x67\165\x72\165\x20\143", "\142\56\x69\144\x5f\x6a\141\x62\141\164\x61\156\75\143\56\151\144\137\x6c\145\166\x65\x6c", "\x6c\x65\146\164"); goto whMUr; kbB1E: $this->db->order_by("\x63\56\151\x64\x5f\x6c\x65\x76\145\x6c", "\x64\x65\x73\x63"); goto p25H5; fs3gD: $this->db->query("\x53\105\124\40\123\x51\114\137\102\x49\x47\x5f\123\105\114\105\x43\124\123\75\x31"); goto WT30m; Cyncj: return $this->db->get()->result(); goto BMhFw; WT30m: $this->db->select("\141\56\x69\144\x5f\x67\165\162\165\54\x20\x61\x2e\x6e\141\x6d\141\137\x67\165\162\165\54\x20\x61\56\x6e\151\160\x2c\x20\x61\56\153\157\144\145\137\x67\x75\x72\165\54\40\141\56\x6a\145\156\x69\x73\137\x6b\145\154\x61\x6d\151\x6e\54\x20\x61\56\x66\157\164\x6f\x2c\x20\x62\x2e\x69\x64\x5f\x6a\x61\x62\x61\x74\141\156\54\40\x62\56\x69\x64\137\153\145\154\x61\x73\x2c\40\142\x2e\155\x61\160\145\x6c\137\153\x65\154\x61\163\54\x20\142\56\145\x6b\x73\x74\x72\141\x5f\153\x65\154\x61\x73\x2c\40\x63\x2e\151\144\x5f\154\145\x76\145\x6c\54\x20\x63\x2e\x6c\145\166\145\x6c\x2c\x20\x64\56\x6e\141\155\141\137\x6b\145\154\x61\163\x2c\40\x65\x2e\164\141\150\165\x6e\54\x20\x66\x2e\156\x61\x6d\141\x5f\163\x6d\x74\54\x20\50\123\x45\x4c\x45\103\124\x20\103\117\x55\x4e\124\x28\x69\144\x29\40\106\122\x4f\115\40\165\163\x65\x72\x73\x20\x65\40\x57\x48\x45\122\105\40\145\x2e\165\x73\145\x72\x6e\141\x6d\145\x20\75\40\141\56\165\x73\x65\x72\x6e\141\x6d\145\x29\x20\x41\123\x20\x73\x74\141\164\x75\163"); goto rFG9n; o0aEF: $this->db->join("\155\141\163\164\x65\162\137\x73\x6d\x74\x20\x66", "\142\x2e\151\144\x5f\x73\x6d\164\75\146\56\151\x64\x5f\163\155\x74", "\x6c\145\146\164"); goto kbB1E; p25H5: $this->db->order_by("\x61\x2e\x69\x64\137\147\165\162\165", "\x61\163\x63"); goto Cyncj; whMUr: $this->db->join("\155\141\163\x74\x65\x72\x5f\153\x65\x6c\141\x73\40\x64", "\142\56\151\x64\137\x6b\145\x6c\x61\163\75\x64\56\x69\x64\x5f\153\145\x6c\141\x73\x20\101\116\x44\40\144\x2e\x69\144\137\164\x70\x3d" . $tp . "\x20\101\x4e\104\x20\x64\56\151\x64\x5f\163\x6d\x74\x3d" . $smt . '', "\x6c\x65\x66\x74"); goto nrtH9; BMhFw: } public function getGuruById($id, $id_tp = null, $id_smt = null) { goto fwK1U; G8uDN: D8Y_P: goto vwaGA; FoFjU: $this->db->join("\x6a\x61\x62\x61\164\141\x6e\x5f\147\165\162\165\40\142", "\x61\56\x69\144\x5f\x67\165\x72\165\75\x62\56\151\144\137\x67\165\x72\x75", "\154\145\x66\164"); goto BH2xo; BH2xo: $this->db->join("\x6c\x65\166\x65\x6c\137\x67\x75\x72\x75\x20\143", "\142\56\151\x64\x5f\152\x61\x62\141\164\141\156\x3d\x63\x2e\151\x64\x5f\154\x65\166\x65\154", "\x6c\x65\x66\164"); goto f2ELT; cjx6x: $this->db->join("\x6d\141\x73\164\145\x72\x5f\x6b\x65\x6c\x61\163\x20\144", "\x61\x2e\151\144\x5f\147\165\x72\165\75\x64\x2e\147\165\x72\x75\x5f\151\x64\40\x41\x4e\x44\x20\x64\x2e\x69\x64\137\x74\160\x3d" . $id_tp . "\40\x41\x4e\104\x20\144\x2e\151\144\137\163\155\164\x3d" . $id_smt, "\x6c\145\x66\164"); goto G8uDN; p_0sE: return $this->db->get()->row(); goto WGIBa; f2ELT: if (!($id_tp != null && $id_smt != null)) { goto D8Y_P; } goto cjx6x; cPqMz: $this->db->select("\x2a"); goto DrHLj; fwK1U: $this->db->query("\x53\105\124\40\123\x51\114\137\102\111\x47\137\x53\105\114\x45\103\x54\123\75\x31"); goto cPqMz; DrHLj: $this->db->from("\155\141\x73\164\x65\x72\137\147\x75\162\x75\x20\141"); goto FoFjU; vwaGA: $this->db->where("\x61\56\x69\144\137\x67\165\162\165", $id); goto p_0sE; WGIBa: } public function getGuruByArrId($arr_id) { goto u09HV; YO2QQ: if (!(count($arr_id) > 0)) { goto qaezi; } goto hX9PJ; hX9PJ: $this->db->where_in("\151\x64\x5f\x67\x75\x72\x75", $arr_id); goto lzfBV; Vhhbi: $this->db->from("\x6d\141\163\x74\145\162\x5f\x67\x75\162\x75"); goto YO2QQ; Nv3W3: return $this->db->get()->result(); goto vaVyc; lzfBV: qaezi: goto Nv3W3; u09HV: $this->db->select("\x6e\x61\x6d\141\137\x67\165\x72\165\54\40\x6e\x69\x70"); goto Vhhbi; vaVyc: } public function getUserIdGuruByUsername($username) { goto LGhdU; KpFGb: $this->db->join("\x6c\x65\166\x65\x6c\137\147\165\x72\x75\40\x63", "\142\x2e\151\x64\137\152\x61\142\x61\164\141\156\75\143\56\151\x64\x5f\154\x65\166\145\x6c", "\x6c\x65\x66\x74"); goto twovJ; LGhdU: $this->db->query("\x53\x45\x54\x20\123\x51\114\x5f\x42\111\x47\137\123\105\114\105\x43\x54\123\x3d\x31"); goto Q1Ci4; Q1Ci4: $this->db->select("\52"); goto uor3w; uor3w: $this->db->from("\x6d\141\x73\164\145\162\137\x67\165\162\x75\x20\x61"); goto f3snX; PyXcU: return $this->db->get()->row(); goto JAtk0; twovJ: $this->db->where("\x61\x2e\165\x73\145\x72\156\x61\x6d\145", $username); goto PyXcU; f3snX: $this->db->join("\x6a\141\142\141\x74\x61\x6e\137\147\x75\162\165\x20\x62", "\x61\56\x69\144\137\147\x75\x72\165\x3d\x62\x2e\151\144\x5f\147\x75\x72\165", "\x6c\x65\x66\x74"); goto KpFGb; JAtk0: } public function getDetailJabatanGuru($id_guru) { goto vFg_8; GWERP: ZJ455: goto XCAza; t2gvG: $this->db->select("\x61\x2e\151\x64\x5f\147\165\162\165\x2c\40\x61\56\156\141\155\x61\x5f\147\165\x72\x75\54\40\142\x2e\x69\x64\137\x74\160\54\40\142\56\x69\144\x5f\x73\x6d\164\54\40\x62\56\155\141\x70\x65\x6c\x5f\x6b\145\x6c\141\x73\x2c\40\x62\56\x65\153\163\164\x72\x61\137\153\145\x6c\141\163\x2c\x20\x63\56\x69\144\x5f\154\x65\x76\x65\x6c\x2c\40\x63\56\x6c\x65\x76\145\154\x2c\x20\x64\56\x69\144\137\x6b\x65\154\x61\163\x2c\x20\x64\56\x6e\141\155\141\137\153\x65\154\141\x73"); goto w2j0N; SxRM7: $ret = []; goto u45m2; p_WZy: $this->db->where("\141\56\151\x64\x5f\x67\165\x72\x75", $id_guru); goto ftShE; w2j0N: $this->db->from("\x6d\141\163\164\x65\x72\x5f\147\x75\162\165\40\x61"); goto z7Pm3; XCAza: return $ret; goto foGYx; vFg_8: $this->db->query("\x53\x45\x54\40\x53\121\x4c\137\x42\x49\x47\137\123\105\x4c\105\x43\124\123\75\61"); goto t2gvG; z7Pm3: $this->db->join("\152\x61\x62\x61\164\x61\x6e\x5f\147\165\x72\165\40\142", "\x61\x2e\x69\144\137\147\165\162\x75\x3d\142\x2e\x69\144\x5f\x67\165\162\165", "\x6c\x65\x66\164"); goto IOWYO; IOWYO: $this->db->join("\154\145\166\x65\154\x5f\x67\165\162\165\x20\143", "\142\x2e\x69\144\137\152\141\142\141\164\141\156\75\x63\56\151\144\137\x6c\x65\166\145\x6c", "\154\145\x66\x74"); goto M8Xmt; M8Xmt: $this->db->join("\155\x61\x73\164\145\x72\137\153\x65\x6c\141\163\x20\x64", "\x62\x2e\x69\x64\137\153\145\154\141\163\75\144\x2e\x69\144\137\x6b\145\x6c\141\163", "\154\x65\x66\164"); goto p_WZy; u45m2: foreach ($result as $row) { $ret[$row->id_tp][$row->id_smt] = $row; El7Jn: } goto GWERP; ftShE: $result = $this->db->get()->result(); goto SxRM7; foGYx: } public function getJabatanGuru($id_guru, $tp, $smt) { goto FFZoA; EidmE: $this->db->select("\141\56\151\144\x5f\x67\165\x72\165\x2c\x20\x61\56\x6e\x61\155\x61\137\147\x75\162\x75\54\40\x62\x2e\x6d\x61\x70\x65\x6c\x5f\153\145\x6c\x61\163\54\x20\x62\x2e\145\x6b\163\x74\x72\141\137\153\x65\154\141\163\x2c\x20\143\x2e\x69\144\x5f\154\145\166\x65\x6c\x2c\x20\143\x2e\x6c\x65\x76\x65\154\x2c\x20\x64\56\x69\x64\x5f\x6b\x65\x6c\x61\163\54\40\144\x2e\156\141\155\141\x5f\x6b\x65\x6c\141\x73"); goto L1AQl; EB35n: $this->db->join("\155\x61\163\x74\x65\x72\x5f\153\x65\x6c\x61\x73\40\x64", "\142\x2e\151\144\x5f\x6b\x65\154\141\163\x3d\x64\x2e\151\144\137\x6b\145\154\141\x73\x20\x41\116\x44\x20\x64\56\x69\144\x5f\x74\x70\x3d" . $tp . "\40\101\116\104\x20\144\56\151\x64\137\x73\x6d\164\x3d" . $smt . '', "\154\145\146\164"); goto Sx9cL; FFZoA: $this->db->query("\x53\105\124\40\x53\121\114\x5f\102\111\107\137\x53\105\114\x45\103\x54\x53\x3d\x31"); goto EidmE; Sx9cL: $this->db->where("\141\x2e\x69\x64\137\147\165\162\165", $id_guru); goto mIAod; L1AQl: $this->db->from("\155\141\x73\164\145\162\x5f\147\x75\x72\x75\40\x61"); goto KRcIU; c4eVJ: $this->db->join("\x6c\145\x76\x65\154\137\147\x75\x72\165\x20\x63", "\x62\56\x69\144\137\152\x61\x62\141\164\x61\156\x3d\x63\x2e\151\x64\137\154\145\166\145\x6c", "\154\145\x66\x74"); goto EB35n; mIAod: return $this->db->get()->row(); goto RIkkT; KRcIU: $this->db->join("\x6a\141\x62\141\164\141\x6e\x5f\x67\165\x72\165\x20\142", "\141\x2e\x69\144\x5f\x67\x75\x72\x75\75\x62\x2e\151\x64\x5f\147\165\162\165\x20\x41\x4e\104\x20\x62\56\x69\x64\137\x74\160\75" . $tp . "\x20\101\x4e\104\40\x62\56\x69\x64\x5f\163\x6d\x74\x3d" . $smt . '', "\154\x65\x66\164"); goto c4eVJ; RIkkT: } public function getGuruMapel($tp, $smt) { goto annYi; annYi: $this->db->select("\x61\x2e\x6d\x61\x70\145\x6c\137\153\x65\x6c\141\x73\x2c\x20\x61\56\x65\x6b\163\164\x72\x61\x5f\x6b\145\x6c\141\163\x2c\x20\141\x2e\151\x64\137\152\141\142\141\x74\141\156\x2c\40\141\56\151\144\x5f\153\x65\154\141\163\54\40\142\x2e\151\x64\137\x67\165\x72\165\x2c\40\142\56\x6e\x61\155\141\137\x67\x75\162\x75"); goto x5ZbT; ba9eZ: return $this->db->get()->result(); goto BdmPq; x5ZbT: $this->db->from("\152\141\142\x61\x74\141\x6e\137\x67\x75\x72\165\x20\x61"); goto NOXUb; NOXUb: $this->db->join("\x6d\x61\x73\x74\x65\x72\x5f\x67\x75\x72\x75\40\142", "\141\56\151\x64\137\x67\x75\162\165\x3d\142\x2e\x69\x64\x5f\x67\x75\162\165"); goto JSbFW; JSbFW: $this->db->where("\141\x2e\x69\144\137\164\160", $tp); goto fvXDf; fvXDf: $this->db->where("\x61\56\151\x64\137\163\x6d\x74", $smt); goto ba9eZ; BdmPq: } public function getKodeKelompokMapel() { goto Efey2; WirIA: $ret = []; goto nYngZ; Mx6Xy: ka7qB: goto sO13X; mDKJx: $result = $this->db->get()->result(); goto WirIA; Efey2: $this->db->select("\x2a"); goto N_CV8; nYngZ: foreach ($result as $row) { $ret[$row->kode_kel_mapel] = $row; ASbqA: } goto Mx6Xy; N_CV8: $this->db->from("\x6d\141\x73\164\x65\x72\x5f\153\145\154\157\155\x70\x6f\153\x5f\x6d\141\x70\x65\154"); goto kKAld; sO13X: return $ret; goto CmxRL; kKAld: $this->db->order_by("\153\157\x64\145\x5f\x6b\x65\x6c\137\155\141\x70\145\154"); goto mDKJx; CmxRL: } public function getDataKelompokMapel() { goto N0aRP; nFjcY: $this->db->where("\x69\x64\137\x70\141\x72\145\x6e\164", "\x30"); goto x3kIL; x3kIL: $this->db->order_by("\153\157\144\145\x5f\153\145\x6c\x5f\x6d\x61\x70\145\x6c"); goto tGYC2; X5yMe: fweyk: goto BSGdv; tGYC2: $result = $this->db->get()->result(); goto vVkK3; ljWMV: foreach ($result as $row) { $ret[$row->id_kel_mapel] = $row; SkABx: } goto X5yMe; N0aRP: $this->db->select("\52"); goto ptHhV; BSGdv: return $ret; goto NGjnh; ptHhV: $this->db->from("\155\141\163\x74\x65\x72\137\153\145\x6c\157\155\160\x6f\x6b\137\x6d\141\x70\145\x6c"); goto nFjcY; vVkK3: $ret = []; goto ljWMV; NGjnh: } public function getKategoriKelompokMapel() { goto YH177; LrZBu: $this->db->from("\x6d\x61\x73\164\x65\x72\137\153\145\154\157\155\160\157\153\x5f\x6d\141\160\145\x6c"); goto tvvAw; AKpGJ: $this->db->where("\153\141\164\x65\147\x6f\x72\151", "\x57\x41\x4a\x49\x42")->or_where("\x6b\141\x74\x65\x67\x6f\162\x69", "\x50\x41\111\x20\x28\113\x65\155\x65\x6e\x61\x67\51"); goto LrZBu; YH177: $this->db->select("\x6b\x6f\144\x65\x5f\x6b\145\154\137\155\141\160\x65\x6c\x2c\x20\153\x61\164\145\147\x6f\162\151"); goto AKpGJ; tvvAw: return $this->db->get()->result(); goto AurdY; AurdY: } public function getDataSubKelompokMapel() { goto SYpTH; d37ej: $this->db->where("\151\144\x5f\x70\x61\x72\x65\x6e\164\40\x3c\76\40\x30"); goto N72qO; xt9sX: UlHWo: goto uYJG4; SYpTH: $this->db->select("\52"); goto cRiwx; oCMhF: $result = $this->db->get()->result(); goto fzeBT; fzeBT: $ret = []; goto gVSim; gVSim: foreach ($result as $row) { $ret[$row->id_kel_mapel] = $row; pwb9T: } goto xt9sX; N72qO: $this->db->order_by("\153\x6f\144\x65\x5f\x6b\145\x6c\137\x6d\x61\160\x65\154"); goto oCMhF; uYJG4: return $ret; goto A_szD; cRiwx: $this->db->from("\x6d\141\x73\x74\x65\x72\x5f\x6b\145\154\157\155\160\x6f\x6b\x5f\155\x61\160\145\x6c"); goto d37ej; A_szD: } public function getDataMapel() { goto bCDLz; bCDLz: $this->datatables->select("\x69\144\137\x6d\141\160\x65\154\54\x20\156\x61\155\x61\x5f\155\141\160\145\x6c\x2c\40\x6b\157\144\145"); goto mwF4n; mwF4n: $this->datatables->from("\155\141\163\x74\x65\162\x5f\155\141\x70\x65\154"); goto QH1Nc; QH1Nc: return $this->datatables->generate(); goto OkzmG; OkzmG: } public function getAllMapel($arrKelompok = null, $arrMapel = null) { goto C0pJX; C4RO8: $this->db->where_in("\153\x65\154\157\x6d\x70\157\x6b", $arrKelompok); goto bWemv; zwCZT: $this->db->where("\163\x74\141\x74\x75\163", "\61"); goto cKX3a; C0pJX: if (!($arrMapel != null)) { goto d0hxp; } goto C4RO8; wBCGu: et1ji: goto zwCZT; cKX3a: $this->db->order_by("\165\162\x75\x74\141\156\x5f\x74\141\155\160\151\154"); goto iRMp7; Ah21T: if (!($arrMapel != null)) { goto et1ji; } goto t68l4; iRMp7: return $this->db->get("\155\x61\x73\164\145\x72\x5f\x6d\x61\160\145\154")->result(); goto ic1QJ; t68l4: $this->db->or_where_in("\x69\144\137\x6d\x61\160\x65\154", explode("\x2c", $arrMapel)); goto wBCGu; bWemv: d0hxp: goto Ah21T; ic1QJ: } public function getAllStatusMapel($arrKelompok = null, $arrMapel = null) { goto H07iA; Wimdl: if (!($arrMapel != null)) { goto fJO27; } goto SK9W7; P8_wR: fJO27: goto N8vZQ; SgMQM: return $this->db->get("\155\x61\x73\x74\x65\x72\137\x6d\141\160\145\x6c")->result(); goto X4J67; H07iA: if (!($arrMapel != null)) { goto PGgbf; } goto hWNhh; N8vZQ: $this->db->order_by("\x75\162\165\x74\x61\156\x5f\x74\x61\x6d\x70\x69\154"); goto SgMQM; hWNhh: $this->db->where_in("\153\145\x6c\157\x6d\x70\157\x6b", $arrKelompok); goto IeBOL; SK9W7: $this->db->or_where_in("\151\x64\137\x6d\141\x70\x65\154", explode("\x2c", $arrMapel)); goto P8_wR; IeBOL: PGgbf: goto Wimdl; X4J67: } public function getAllMapelByKelompok($jenjang) { goto xciRO; a_XX4: $ret = []; goto GsMKs; mq09_: return $ret; goto PNlCB; xciRO: $this->db->where("\163\x74\x61\164\165\x73", "\61"); goto rDZLU; KtkRR: $this->db->order_by("\165\x72\x75\x74\x61\x6e\x5f\x74\141\x6d\x70\x69\x6c"); goto ZKHUC; ZKHUC: $result = $this->db->get("\x6d\141\x73\x74\145\x72\x5f\155\141\x70\145\x6c")->result(); goto a_XX4; g0gdn: kzn6C: goto mq09_; rDZLU: $this->db->order_by("\x75\x72\x75\x74\141\x6e"); goto KtkRR; GsMKs: foreach ($result as $row) { $ret[$row->kelompok][] = $row; ouHsY: } goto g0gdn; PNlCB: } public function getAllMapelNonAktif($jenjang) { $this->db->where("\x73\164\141\164\x75\x73", "\x30"); return $this->db->get("\155\x61\163\164\x65\x72\137\155\x61\160\x65\x6c")->result(); } public function getMapelById($id, $single = false) { goto B18of; VG7_0: $this->db->order_by("\156\x61\155\141\x5f\155\x61\160\x65\x6c"); goto ARhIG; k8lIm: return $query; goto nQfNJ; aZKwh: goto l6wF8; goto DWylE; AZFsG: $query = $this->db->get_where("\x6d\x61\x73\x74\145\162\x5f\x6d\x61\x70\x65\x6c", array("\x69\144\x5f\155\141\160\x65\x6c" => $id))->row(); goto aZKwh; DWylE: qOtQi: goto B_AHy; B_AHy: $this->db->where_in("\x69\144\x5f\155\x61\160\145\x6c", $id); goto VG7_0; ARhIG: $query = $this->db->get("\155\141\x73\164\x65\x72\137\155\141\160\145\154")->result(); goto eHymO; B18of: if ($single === false) { goto qOtQi; } goto AZFsG; eHymO: l6wF8: goto k8lIm; nQfNJ: } function updateMapel() { goto a4hVm; eDD1v: $kelompok = $this->input->post("\x6b\145\x6c\157\155\x70\x6f\153", true); goto r3QSC; hqk_O: $kode = $this->input->post("\153\157\144\145\x5f\x6d\141\x70\x65\154", true); goto eDD1v; r3QSC: $status = $this->input->post("\x73\x74\141\164\165\163", true); goto klM44; EqHCk: $name = $this->input->post("\156\x61\155\x61\137\x6d\141\160\x65\x6c", true); goto hqk_O; ItOPl: $this->db->where("\x69\x64\x5f\x6d\141\x70\x65\154", $id); goto DWDqu; DWDqu: return $this->db->update("\x6d\x61\x73\164\x65\162\x5f\155\141\x70\145\x6c"); goto bS6om; klM44: $urut = $this->input->post("\165\162\165\164\141\x6e\x5f\x74\x61\x6d\160\x69\154", true); goto jPGBp; P9H32: $this->db->set("\x73\164\x61\x74\x75\x73", $status); goto wKLQT; kgXHk: amtN0: goto P9H32; a4hVm: $id = $this->input->post("\x69\144\137\155\141\160\145\x6c"); goto EqHCk; wKLQT: $this->db->set("\165\x72\165\164\x61\x6e\x5f\x74\141\155\x70\151\x6c", $urut); goto ItOPl; vo0BK: $this->db->set("\153\x6f\144\145", $kode); goto jVz5o; jVz5o: if (!($kelompok != null)) { goto amtN0; } goto YVaKb; YVaKb: $this->db->set("\153\145\x6c\157\155\x70\157\153", $kelompok); goto kgXHk; jPGBp: $this->db->set("\x6e\141\x6d\x61\x5f\155\141\160\x65\154", $name); goto vo0BK; bS6om: } public function getAllEkstra() { return $this->db->get("\155\141\x73\x74\x65\x72\x5f\145\153\x73\x74\x72\141")->result(); } public function getEkstraById($id, $single = false) { goto c9k_I; Ll5n9: return $query; goto M0uA3; EVfCI: op6Qh: goto UdZ1e; y8SdQ: $query = $this->db->get("\x6d\141\163\164\145\x72\137\x65\x6b\163\164\x72\x61")->result(); goto vxF_0; ur9RA: goto k0E3Q; goto EVfCI; G8kIr: $query = $this->db->get_where("\x6d\141\163\164\145\x72\137\145\153\163\164\162\x61", array("\151\x64\x5f\x65\153\163\164\x72\x61" => $id))->row(); goto ur9RA; c9k_I: if ($single === false) { goto op6Qh; } goto G8kIr; vxF_0: k0E3Q: goto Ll5n9; UdZ1e: $this->db->where_in("\151\144\137\145\x6b\x73\x74\x72\141", $id); goto FsdFq; FsdFq: $this->db->order_by("\x6e\x61\155\141\137\145\153\163\164\162\x61"); goto y8SdQ; M0uA3: } function updateEkstra() { goto GVSQ7; vYWtA: return $this->db->update("\155\141\163\164\145\162\x5f\x65\153\163\x74\162\141"); goto it9zG; GVSQ7: $id = $this->input->post("\151\144\x5f\x65\x6b\x73\164\162\141"); goto H8m30; cJN5Z: $this->db->set("\156\141\155\141\x5f\x65\153\163\164\162\x61", $name); goto AxQDw; Fta8l: $this->db->where("\x69\144\x5f\145\x6b\163\164\x72\x61", $id); goto vYWtA; H8m30: $name = $this->input->post("\156\x61\x6d\x61\137\145\153\x73\164\162\141", true); goto qjUy0; AxQDw: $this->db->set("\153\x6f\x64\145\x5f\145\153\163\164\162\141", $kode); goto Fta8l; qjUy0: $kode = $this->input->post("\x6b\157\144\145\137\145\153\x73\x74\162\x61", true); goto cJN5Z; it9zG: } public function getKelasGuru() { goto Z75dM; LrBZe: return $this->datatables->generate(); goto WKABX; M4WTK: $this->datatables->select("\153\x65\154\x61\x73\137\x67\165\x72\165\x2e\151\144\54\x20\x67\x75\x72\x75\56\151\144\137\147\165\162\165\x2c\40\147\x75\x72\165\x2e\156\151\160\54\x20\x67\165\162\165\56\x6e\x61\155\x61\x5f\x67\x75\x72\165\x2c\x20\107\x52\117\125\x50\137\103\x4f\x4e\x43\101\124\50\x6d\x61\x73\x74\145\x72\x5f\x6b\145\154\141\163\56\x6e\x61\155\141\x5f\153\x65\154\141\163\51\x20\141\x73\x20\x6b\x65\x6c\141\163"); goto tg3xh; fdP81: $this->datatables->group_by("\147\165\x72\x75\x2e\x6e\x61\x6d\141\137\147\x75\162\165"); goto LrBZe; Q6clt: $this->datatables->join("\x6d\141\x73\164\x65\x72\137\153\145\154\x61\x73", "\153\x65\154\141\163\137\x69\x64\x3d\x69\x64\x5f\x6b\x65\154\141\163"); goto x6dzj; tg3xh: $this->datatables->from("\x6b\145\x6c\x61\163\137\x67\165\x72\165"); goto Q6clt; x6dzj: $this->datatables->join("\155\141\163\164\x65\x72\137\147\x75\x72\165", "\x67\165\x72\165\137\x69\x64\75\151\144\137\x67\x75\x72\x75"); goto fdP81; Z75dM: $this->db->query("\x53\105\124\40\x53\121\114\137\102\x49\107\137\x53\x45\114\x45\103\124\x53\75\x31"); goto M4WTK; WKABX: } public function getKelasByGuru($id) { goto X5Udd; f3uTD: $this->db->where("\147\x75\162\165\x5f\x69\x64", $id); goto kAxkL; Ss9vB: $this->db->join("\x6d\x61\163\x74\x65\162\137\153\145\x6c\141\163", "\153\145\x6c\141\x73\137\147\165\x72\x75\x2e\x6b\x65\x6c\x61\163\x5f\x69\x64\x3d\x6b\145\x6c\x61\x73\56\151\144\x5f\x6b\x65\154\141\x73"); goto f3uTD; X5Udd: $this->db->select("\x6b\x65\x6c\141\x73\x2e\x69\144\137\x6b\145\x6c\141\163"); goto Qk3KF; Qk3KF: $this->db->from("\153\145\154\141\163\x5f\x67\x75\x72\165"); goto Ss9vB; kAxkL: return $this->db->get()->result(); goto k7cos; k7cos: } public function getAllJabatanGuru($id) { goto caClc; yNmUz: up_oR: goto sHkhZ; mpS8r: return $ret; goto Lsvw_; caClc: $result = $this->db->get_where("\x6a\141\142\x61\x74\141\x6e\137\x67\x75\162\x75", "\x69\144\137\x67\x75\x72\x75\x3d" . $id)->result(); goto adWNF; e_Dw2: foreach ($result as $key => $row) { $ret[$row->id_tp][$row->id_smt] = $row->id_kelas; Y2uec: } goto yNmUz; adWNF: $ret = []; goto g_GNx; sHkhZ: AzQOK: goto mpS8r; g_GNx: if (!$result) { goto AzQOK; } goto e_Dw2; Lsvw_: } public function getJurusanMapel() { goto TJycE; p5p_I: $this->datatables->from("\152\165\162\165\x73\x61\x6e\x5f\155\x61\x70\x65\x6c"); goto s3TLa; C6B5M: $this->datatables->join("\x6d\x61\163\x74\145\162\137\152\165\x72\x75\x73\141\156", "\152\x75\x72\165\x73\141\x6e\137\151\144\x3d\151\144\x5f\152\165\162\165\x73\x61\156"); goto gMnxn; Ng5xO: return $this->datatables->generate(); goto LYpdq; gMnxn: $this->datatables->group_by("\155\x61\163\164\x65\162\x5f\x6d\141\x70\145\154\x2e\156\x61\x6d\141\137\x6d\141\x70\145\x6c"); goto Ng5xO; TJycE: $this->db->query("\x53\105\124\x20\123\x51\114\x5f\x42\111\x47\x5f\123\105\x4c\105\103\x54\x53\75\61"); goto hJhXu; s3TLa: $this->datatables->join("\155\x61\163\164\x65\x72\x5f\155\x61\160\x65\154", "\155\141\160\x65\x6c\x5f\x69\144\75\x69\144\137\155\141\x70\x65\154"); goto C6B5M; hJhXu: $this->datatables->select("\152\x75\x72\x75\x73\x61\156\x5f\155\141\160\145\154\x2e\151\144\x2c\40\155\x61\160\x65\x6c\56\151\x64\x5f\155\x61\160\145\x6c\54\40\x6d\x61\x70\x65\154\56\x6e\141\x6d\x61\x5f\x6d\141\160\145\x6c\x2c\40\x6a\x75\162\165\163\141\156\56\x69\x64\137\x6a\x75\162\165\163\141\156\x2c\x20\x47\122\117\125\x50\137\103\117\x4e\103\101\x54\x28\152\x75\x72\x75\x73\141\156\56\156\x61\155\x61\137\152\165\162\x75\163\141\156\x29\x20\141\163\x20\156\x61\155\141\x5f\x6a\165\162\165\x73\141\x6e"); goto p5p_I; LYpdq: } public function getMapel($id = null) { goto tLI_x; Ei2EO: JM9Gj: goto pp27E; tLI_x: $this->db->select("\155\x61\160\145\x6c\x5f\151\x64"); goto r5PhN; TIrhG: foreach ($mapel as $d) { $id_mapel[] = $d->mapel_id; Z6fHJ: } goto zienz; MXc2C: $id_mapel = null; goto Ei2EO; gbpXV: $this->db->where_not_in("\155\x61\x70\x65\x6c\x5f\x69\x64", [$id]); goto CN_Uu; r5PhN: $this->db->from("\152\165\162\x75\x73\141\x6e\x5f\155\141\160\145\x6c"); goto G0Mbp; yXfS3: if (!($id_mapel === [])) { goto JM9Gj; } goto MXc2C; G0Mbp: if (!($id !== null)) { goto AilWi; } goto gbpXV; CKr1c: $id_mapel = []; goto TIrhG; zienz: AyD2D: goto yXfS3; CN_Uu: AilWi: goto Ma0pX; DrTQF: $this->db->from("\x6d\x61\x73\164\145\162\x5f\x6d\x61\160\x65\x6c"); goto GvCou; Ma0pX: $mapel = $this->db->get()->result(); goto CKr1c; GvCou: $this->db->where_not_in("\151\144\137\x6d\x61\160\145\154", $id_mapel); goto ASsj1; pp27E: $this->db->select("\151\x64\137\x6d\x61\160\x65\154\x2c\40\156\141\155\141\x5f\x6d\x61\x70\x65\x6c"); goto DrTQF; ASsj1: return $this->db->get()->result(); goto sLsuB; sLsuB: } public function getJurusanByIdMapel($id) { goto FytXb; g_etC: return $this->db->get()->result(); goto tnpdQ; atmPT: $this->db->join("\x6d\x61\x73\x74\x65\162\137\152\x75\x72\x75\x73\141\x6e", "\152\x75\162\x75\x73\141\x6e\137\x6d\x61\x70\145\154\56\x6a\x75\x72\165\x73\141\x6e\137\x69\x64\x3d\152\165\x72\x75\163\x61\x6e\x2e\151\x64\137\x6a\165\x72\x75\x73\x61\x6e"); goto kdL97; LPTXl: $this->db->from("\152\x75\162\165\x73\x61\x6e\x5f\155\x61\160\145\x6c"); goto atmPT; FytXb: $this->db->select("\x6a\165\x72\x75\163\141\156\56\x69\144\137\152\x75\162\x75\x73\141\x6e"); goto LPTXl; kdL97: $this->db->where("\x6d\141\160\x65\154\x5f\x69\x64", $id); goto g_etC; tnpdQ: } public function getTahunActive() { goto KQtV4; KQtV4: $this->db->select("\151\144\x5f\164\160\54\x20\164\x61\150\165\x6e"); goto tof4P; tof4P: $this->db->from("\155\x61\x73\x74\145\x72\x5f\x74\x70"); goto z4Sin; ZamrK: return $this->db->get()->row(); goto vzBcU; z4Sin: $this->db->where("\x61\x63\x74\x69\x76\145", 1); goto ZamrK; vzBcU: } public function getSemesterActive() { goto mYeMd; mtiBd: $this->db->where("\141\143\164\151\166\145", 1); goto uu8tG; uu8tG: return $this->db->get()->row(); goto lHstp; mYeMd: $this->db->select("\x69\144\137\163\155\x74\54\x20\x6e\141\155\x61\137\163\x6d\164\x2c\x20\163\155\164"); goto lYU0Z; lYU0Z: $this->db->from("\155\x61\163\x74\x65\x72\137\163\155\x74"); goto mtiBd; lHstp: } public function getJmlHariEfektif($id) { goto tn4gz; tn4gz: $this->db->select("\x2a"); goto ee1_R; ee1_R: $this->db->from("\x6d\141\163\x74\145\162\137\150\141\x72\151\137\145\146\145\x6b\164\151\146"); goto cQdzU; cQdzU: $this->db->where("\x69\144\x5f\x68\141\162\151\x5f\x65\146\x65\x6b\x74\x69\146", $id); goto m7y6l; m7y6l: return $this->db->get()->row(); goto yHIjA; yHIjA: } public function getDistinctTahunLulus() { goto zNZGs; Hw_8Y: $ret = []; goto Tv22h; jhbIq: JnyZZ: goto sf24b; Tv22h: foreach ($result as $row) { goto dMNC7; O5A0x: yBS2q: goto IHlx8; Br8i3: $ret[$row->tahun_lulus] = $row->tahun_lulus; goto j4R7V; dMNC7: if (!($row->tahun_lulus != '')) { goto eFSMO; } goto Br8i3; j4R7V: eFSMO: goto O5A0x; IHlx8: } goto jhbIq; sf24b: return $ret; goto Oedtw; DSAYu: $this->db->distinct(); goto KTha4; zNZGs: $this->db->select("\164\141\150\165\156\x5f\154\165\x6c\x75\x73"); goto DSAYu; KTha4: $result = $this->db->get("\142\165\153\x75\x5f\151\x6e\144\x75\x6b")->result(); goto Hw_8Y; Oedtw: } public function getDistinctKelasAkhir() { goto vLD_I; ciU24: foreach ($result as $row) { goto zGrDl; dBY3P: zndPS: goto At4Uj; EvWB1: kD5hw: goto dBY3P; fHppt: $ret[$row->kelas_akhir] = $row->kelas_akhir; goto EvWB1; zGrDl: if (!($row->kelas_akhir != '')) { goto kD5hw; } goto fHppt; At4Uj: } goto P41iT; hMyEA: $ret = []; goto ciU24; b5YVR: $result = $this->db->get("\x62\165\x6b\165\x5f\151\x6e\x64\x75\153")->result(); goto hMyEA; vLD_I: $this->db->select("\153\145\x6c\141\163\x5f\141\153\150\x69\x72"); goto y1Akt; P41iT: cPWJO: goto R2U4D; R2U4D: return $ret; goto LnQ0t; y1Akt: $this->db->distinct(); goto b5YVR; LnQ0t: } public function getAlumniByTahun($tahun, $kelas = null) { goto OTL5W; O7Wqw: return $this->db->get()->result(); goto tgFQg; hByem: if (!($kelas != null)) { goto dF_QY; } goto xSu8v; xSu8v: $this->db->where("\141\56\x6b\145\x6c\x61\x73\137\x61\153\150\151\162", $kelas); goto pYRRG; eF6T4: $this->db->join("\x6d\141\x73\164\x65\x72\137\x73\151\163\167\x61\40\x62", "\x61\56\x69\144\x5f\x73\151\x73\x77\x61\75\x62\56\x69\144\x5f\x73\x69\163\167\x61"); goto MTacN; MTacN: $this->db->where("\x61\x2e\x74\x61\x68\x75\x6e\x5f\154\165\154\x75\x73", $tahun); goto hByem; fMl3h: $this->db->from("\142\x75\153\165\x5f\151\156\x64\x75\153\x20\x61"); goto eF6T4; OTL5W: $this->db->select("\52"); goto fMl3h; pYRRG: dF_QY: goto O7Wqw; tgFQg: } public function getAlumniById($id) { goto mOcs0; z4oDc: $this->db->where("\x61\x2e\x69\144\137\163\151\163\167\x61", $id); goto qkl_h; pRupb: $this->db->join("\142\x75\x6b\165\137\x69\x6e\144\165\153\x20\142", "\141\56\151\x64\x5f\163\151\x73\167\141\x3d\142\x2e\x69\144\x5f\163\x69\x73\167\141"); goto z4oDc; mOcs0: $this->db->select("\x2a"); goto RRifm; qkl_h: return $this->db->get()->row(); goto cCKwu; RRifm: $this->db->from("\x6d\141\163\x74\x65\x72\x5f\x73\151\163\167\141\40\x61"); goto pRupb; cCKwu: } public function getAllWaliKelas() { goto pnh4h; gyf7F: $this->db->from("\152\x61\x62\141\164\141\156\137\147\165\x72\165\40\141"); goto j2DWr; gSN3N: $this->db->join("\155\x61\x73\x74\x65\x72\x5f\x6b\145\154\x61\163\40\x64", "\141\56\x69\144\x5f\x6b\145\x6c\141\x73\x3d\x64\x2e\x69\144\137\153\x65\x6c\141\163", "\154\x65\146\x74"); goto K0VOR; j2DWr: $this->db->join("\155\x61\163\x74\145\162\x5f\x67\x75\x72\x75\x20\x62", "\x61\56\151\144\137\147\x75\162\165\75\x62\56\151\x64\137\x67\x75\162\165", "\154\145\x66\x74"); goto uN2Ba; kWinZ: if (!$result) { goto hHHP8; } goto uc3yV; uc3yV: foreach ($result as $key => $row) { goto hbsly; J91w5: mJpKM: goto yJUoj; FxBer: fJJWg: goto J91w5; hbsly: if (!($row->id_level == "\x34")) { goto fJJWg; } goto IsnyN; IsnyN: $ret[$row->id_tp][$row->id_smt][$row->id_kelas] = $row; goto FxBer; yJUoj: } goto ZF_ow; xj27b: $ret = []; goto kWinZ; ZF_ow: Q9s3J: goto smyRH; cyMPg: $this->db->select("\x61\x2e\x69\144\x5f\x74\x70\54\40\141\x2e\151\144\x5f\x73\155\x74\x2c\40\x61\56\151\x64\x5f\147\165\162\x75\54\x20\x62\56\x6e\141\155\141\137\147\165\162\x75\x2c\x20\x63\56\x69\x64\137\154\x65\166\x65\154\x2c\40\x63\x2e\x6c\145\166\145\x6c\x2c\40\x64\56\151\144\137\x6b\x65\x6c\141\x73\54\x20\x64\x2e\156\x61\155\x61\137\153\145\x6c\141\x73"); goto gyf7F; DIVnD: return $ret; goto ZzoI_; pnh4h: $this->db->query("\x53\105\124\x20\x53\x51\114\x5f\x42\111\x47\137\x53\105\114\105\103\x54\x53\75\61"); goto cyMPg; smyRH: hHHP8: goto DIVnD; uN2Ba: $this->db->join("\x6c\x65\166\x65\x6c\137\147\165\x72\165\x20\143", "\141\x2e\151\144\x5f\152\141\x62\x61\164\x61\x6e\x3d\143\56\151\144\137\154\x65\166\145\x6c", "\x6c\145\x66\164"); goto gSN3N; K0VOR: $result = $this->db->get()->result(); goto xj27b; ZzoI_: } public function getAllGuru() { goto QY7zN; lBS0G: return $this->db->get()->result(); goto k86ut; zQXCG: $guru = $this->db->get()->result(); goto OE_Jt; QY7zN: $this->db->select("\151\144\x5f\147\165\162\165"); goto qTcJW; qTcJW: $this->db->from("\x6a\x61\142\x61\164\141\156\137\x67\x75\162\x75"); goto zQXCG; JLuev: $this->db->from("\x6d\x61\163\x74\x65\162\x5f\147\165\x72\x75"); goto xAG6p; OE_Jt: $id_guru = []; goto iejva; zxdzi: Z9RvR: goto Zq84v; Zq84v: $this->db->select("\151\x64\x5f\147\x75\x72\165\x2c\40\x6e\x69\160\x2c\x20\x6e\x61\155\x61\x5f\147\x75\162\x75"); goto JLuev; xAG6p: $this->db->where_in("\x69\144\x5f\x67\165\x72\x75", $id_guru); goto lBS0G; iejva: foreach ($guru as $d) { $id_guru[] = $d->id_guru; Xpzxl: } goto zxdzi; k86ut: } public function getAllKelas($tp = null, $smt = null) { goto RoSt6; xGd4L: return $ret; goto zf8ff; xnQcH: NOaFO: goto xlRKN; GDIV0: foreach ($result as $key => $row) { $ret[$row->id_kelas] = $row; HXDo_: } goto fQX5z; AVf71: $this->db->select("\x61\x2e\x69\x64\137\x6b\145\x6c\x61\x73\x2c\x20\141\x2e\151\x64\137\164\160\54\40\141\56\x69\x64\x5f\163\155\164\54\x20\141\x2e\x6e\x61\155\141\x5f\x6b\145\x6c\141\x73\x2c\40\141\56\153\x6f\144\145\137\153\145\x6c\141\163\54\40\141\x2e\x6c\145\166\145\x6c\137\x69\x64\x2c\x20\x62\x2e\156\x61\155\x61\137\x6a\165\162\x75\x73\141\156\x2c\40\x62\56\x6b\157\x64\x65\x5f\x6a\x75\162\165\x73\141\x6e\x2c\40\143\56\x6e\x61\x6d\x61\137\147\165\x72\165"); goto SV4b5; uuGiV: goto aIAIG; goto gU7cb; zsKJ3: if ($tp != null && $smt != null) { goto lZgZi; } goto S29tH; SV4b5: $this->db->from("\155\x61\163\x74\x65\x72\137\x6b\145\x6c\x61\163\x20\141"); goto VpwSu; S29tH: if (!$result) { goto OO9Lw; } goto By32H; fQX5z: lhUty: goto xnQcH; yPCzY: $this->db->order_by("\141\x2e\156\x61\155\141\x5f\153\145\x6c\141\x73"); goto LUPZt; RMHT_: lCaNz: goto KAcCG; vFuEb: if (!$result) { goto NOaFO; } goto GDIV0; RoSt6: $this->db->query("\123\105\x54\x20\123\x51\114\x5f\102\111\x47\137\123\105\114\105\103\x54\123\x3d\x31"); goto AVf71; VpwSu: if (!($tp != null && $smt != null)) { goto lCaNz; } goto X8fsD; X8fsD: $this->db->where("\x61\56\151\144\x5f\164\160", $tp)->where("\141\56\151\x64\137\x73\x6d\164", $smt); goto RMHT_; wQUVf: $ret = []; goto zsKJ3; gU7cb: lZgZi: goto vFuEb; pEf3n: vw382: goto PV0xY; CWX5D: $this->db->join("\155\x61\163\164\145\x72\x5f\147\x75\x72\165\x20\143", "\x66\x2e\151\144\137\147\165\162\165\75\143\x2e\151\144\137\147\165\x72\165", "\154\x65\146\164"); goto yPCzY; K1j8E: $this->db->join("\155\141\x73\164\145\x72\x5f\152\x75\162\x75\x73\x61\x6e\40\142", "\141\56\152\165\x72\165\x73\x61\x6e\137\x69\144\75\142\x2e\x69\144\x5f\152\165\162\x75\163\141\156", "\154\x65\x66\164"); goto CWX5D; PV0xY: OO9Lw: goto uuGiV; xlRKN: aIAIG: goto xGd4L; By32H: foreach ($result as $key => $row) { $ret[$row->id_tp][$row->id_smt][$row->id_kelas] = $row; brjak: } goto pEf3n; KAcCG: $this->db->join("\x6a\x61\142\x61\x74\141\x6e\137\147\165\x72\165\x20\146", "\x66\56\151\x64\x5f\x6b\x65\x6c\x61\163\75\141\56\x69\x64\x5f\x6b\145\x6c\x61\163", "\154\x65\146\x74"); goto K1j8E; LUPZt: $result = $this->db->get()->result(); goto wQUVf; zf8ff: } public function getAllKelasSiswa() { goto D3L17; yunXP: f0tuG: goto bRxvZ; D3L17: $this->db->select("\52"); goto oz2qe; uTpLU: $ret = []; goto awgBq; KlVwB: U3Hi1: goto yunXP; bRxvZ: return $ret; goto guHVv; oz2qe: $this->db->from("\x6b\145\x6c\141\x73\137\x73\151\163\167\x61"); goto oHuV8; awgBq: if (!$result) { goto f0tuG; } goto q3Gag; q3Gag: foreach ($result as $key => $row) { $ret[$row->id_kelas][$row->id_siswa] = $row; UXlfX: } goto KlVwB; oHuV8: $result = $this->db->get()->result(); goto uTpLU; guHVv: } public function getDataInduk() { goto hdoE3; pw1jT: $result = $this->db->get()->result(); goto VsPTb; d2k7B: return $ret; goto BOBmw; VsPTb: $ret = []; goto awQLR; OV_CA: $this->db->join("\142\x75\x6b\x75\x5f\x69\156\x64\165\x6b\40\x62", "\141\x2e\x69\x64\137\x73\x69\163\x77\x61\x3d\x62\x2e\x69\144\137\x73\151\163\x77\x61", "\154\x65\146\164"); goto dh83w; hdoE3: $this->db->select("\x61\56\x2a\54\x20\142\x2e\x2a\x2c"); goto GkmDX; awQLR: if (!$result) { goto iiWCt; } goto rQb0n; dh83w: $this->db->order_by("\x61\56\x6e\x61\155\141", "\x41\x53\x43"); goto pw1jT; QxDNP: zkM85: goto dz_s3; GkmDX: $this->db->from("\155\x61\163\x74\145\162\x5f\x73\151\163\167\141\x20\x61"); goto OV_CA; dz_s3: iiWCt: goto d2k7B; rQb0n: foreach ($result as $key => $row) { $ret[$row->id_siswa] = $row; MBANm: } goto QxDNP; BOBmw: } }
Function Calls
| None |
Stats
| MD5 | f9f59ccff435fad6ed6c7d1308c9b192 |
| Eval Count | 0 |
| Decode Time | 108 ms |