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 POocE; jbD8U: $insert = $this->db->insert_batch($table, $data); goto WF9b8; RYzw1: zwYGK: goto HSpsK; HSpsK: $insert = $this->db->insert($table, $data); goto BKQYz; POocE: if ($batch === false) { goto zwYGK; } goto jbD8U; zXq9C: return $insert; goto v3cPz; WF9b8: goto tFfS6; goto RYzw1; BKQYz: tFfS6: goto zXq9C; v3cPz: } public function update($table, $data, $pk, $id = null, $batch = false) { goto Ar4WW; Ar4WW: if ($batch === false) { goto g3tG3; } goto RVClT; uDGCX: g3tG3: goto DVRiZ; DVRiZ: $insert = $this->db->update($table, $data, array($pk => $id)); goto nB6vq; nB6vq: b9bih: goto vVoRz; Vvc4S: goto b9bih; goto uDGCX; RVClT: $insert = $this->db->update_batch($table, $data, $pk); goto Vvc4S; vVoRz: return $insert; goto oGQSj; oGQSj: } public function delete($table, $data, $pk) { $this->db->where_in($pk, $data); return $this->db->delete($table); } public function delete_not($table, $data, $pk, $col, $not) { goto wMJJB; wMJJB: $this->db->where_in($pk, $data); goto Su1dN; Su1dN: $this->db->where($col . "!=" . $not); goto yEydP; yEydP: return $this->db->delete($table); goto Uw_6S; Uw_6S: } public function getDataKelas() { goto toouj; toouj: $this->datatables->select("id_kelas, nama_kelas, id_jurusan, nama_jurusan"); goto QDLCT; k7TtR: return $this->datatables->generate(); goto rInid; dux2A: $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 k7TtR; rTtn5: $this->datatables->join("master_jurusan", "jurusan_id=id_jurusan"); goto dux2A; QDLCT: $this->datatables->from("master_kelas"); goto rTtn5; rInid: } public function getKelasById($id) { goto cmW5O; w850Q: $this->db->order_by("nama_kelas"); goto z1id8; kWraL: $this->db->from("master_kelas"); goto b2YQN; b2YQN: $this->db->where("id_kelas", $id); goto w850Q; z1id8: $query = $this->db->get()->row(); goto BhUT2; cmW5O: $this->db->select("id_kelas, nama_kelas, level_id"); goto kWraL; BhUT2: return $query; goto nXdP6; nXdP6: } public function getDataJurusan() { goto CZ1z7; owOMO: $this->db->from("master_jurusan"); goto vu7W6; cg_cK: return $result; goto oODQ6; vu7W6: $result = $this->db->get()->result(); goto cg_cK; CZ1z7: $this->db->select("*"); goto owOMO; oODQ6: } public function getDataJurusanMapel($arrIds) { goto r1Mke; d_kpS: $result = $this->db->get()->result(); goto DC6MP; Z5T6y: yG5Zv: goto RpvVH; RpvVH: MU72G: goto iPb_a; DC6MP: $ret = []; goto dBu1y; zk1sF: $this->db->where_in("id_mapel", $arrIds); goto d_kpS; iPb_a: return $ret; goto shYzK; r1Mke: $this->db->select("id_mapel, nama_mapel"); goto gpWKH; gpWKH: $this->db->from("master_mapel"); goto zk1sF; bE_cR: foreach ($result as $key => $row) { $ret[$row->id_mapel] = $row->nama_mapel; lqaFl: } goto Z5T6y; dBu1y: if (!$result) { goto MU72G; } goto bE_cR; shYzK: } public function getDataTableJurusan() { goto zN0BY; Ed2Jf: return $this->datatables->generate(); goto ybcgO; yjjPI: $this->datatables->from("master_jurusan"); goto HZ6Fx; zN0BY: $this->datatables->select("*"); goto yjjPI; HZ6Fx: $this->db->order_by("id_jurusan"); goto Ed2Jf; ybcgO: } public function getJurusanById($id) { goto hTbtA; m45lY: $this->db->order_by("nama_jurusan"); goto eVhu5; eVhu5: $query = $this->db->get("master_jurusan")->result(); goto D5SJv; hTbtA: $this->db->where_in("id_jurusan", $id); goto m45lY; D5SJv: return $query; goto hSwSD; hSwSD: } function updateJurusan() { goto m_nZM; jNY0M: goto QtS_F; goto wzhHx; zO3uy: $kode = $this->input->post("kode_jurusan", true); goto q23bo; q23bo: $mapels = []; goto hpeG0; Nw6j3: $this->db->where("id_jurusan", $id); goto x2W33; L9qfi: $i++; goto jNY0M; m7TCb: $row_mapels = count($this->input->post("mapel", true)); goto mwVam; hpeG0: $check_mapel = $this->input->post("mapel", true); goto uRN5s; rwsXk: $this->db->set("mapel_peminatan", implode(",", $mapels)); goto jJUR4; x2W33: return $this->db->update("master_jurusan"); goto zZwG3; uRN5s: if (!$check_mapel) { goto p7_gA; } goto m7TCb; jJUR4: $this->db->set("status", "1"); goto Nw6j3; wzhHx: JTm0m: goto U3JNc; m_nZM: $id = $this->input->post("id_jurusan"); goto zXgKX; fliIf: QtS_F: goto bSdA8; QU7Pt: upHNX: goto L9qfi; zXgKX: $name = $this->input->post("nama_jurusan", true); goto zO3uy; mwVam: $i = 0; goto fliIf; mWg6K: $this->db->set("nama_jurusan", $name); goto mbnBE; bSdA8: if (!($i <= $row_mapels)) { goto JTm0m; } goto ccd2u; ccd2u: array_push($mapels, $this->input->post("mapel[" . $i . "]", true)); goto QU7Pt; mbnBE: $this->db->set("kode_jurusan", $kode); goto rwsXk; U3JNc: p7_gA: goto mWg6K; zZwG3: } 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 o8UbT; BVPpj: $this->db->select("a.*, c.nama_kelas"); goto VCQ0u; jzi3d: $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 KkP6m; VCQ0u: $this->db->from("master_siswa a"); goto jzi3d; KkP6m: $this->db->join("master_kelas c", "c.id_kelas=b.id_kelas", "left"); goto Z6GHz; yKyIj: $this->db->order_by("a.nama"); goto ST0w_; o8UbT: $this->db->query("SET SQL_BIG_SELECTS=1"); goto BVPpj; VLTIL: return $query->result(); goto C92v1; ST0w_: $query = $this->db->get(); goto VLTIL; Z6GHz: $this->db->order_by("b.id_kelas"); goto yKyIj; C92v1: } public function getSiswaByKelas($id_tp, $id_smt, $id_kelas) { goto WThjB; tP4dT: $this->db->where("a.id_kelas", $id_kelas); goto NIydm; cAaf3: $this->db->from("kelas_siswa a"); goto GOL1P; MFeMH: return $this->db->get()->result(); goto tu12D; I641b: $this->db->where("a.id_tp", $id_tp); goto WyVUu; WyVUu: $this->db->where("a.id_smt", $id_smt); goto BvgiZ; NIydm: $this->db->order_by("b.nama", "ASC"); goto MFeMH; WThjB: $this->db->select("b.*"); goto cAaf3; pkhjP: $this->db->where("b.id_siswa is NOT NULL", NULL, FALSE); goto tP4dT; BvgiZ: $this->db->where("a.id_siswa is NOT NULL", NULL, FALSE); goto pkhjP; GOL1P: $this->db->join("master_siswa b", "b.id_siswa=a.id_siswa"); goto I641b; tu12D: } public function getDataSiswa($id_tp, $id_smt) { goto YkyGB; YkyGB: $this->db->query("SET SQL_BIG_SELECTS=1"); goto dENZC; A64zE: $this->datatables->join("users c", "a.username=c.username"); goto D21VS; cw92j: $this->datatables->from("master_siswa a"); goto dRIqA; dRIqA: $this->datatables->join("buku_induk b", "a.id_siswa=b.id_siswa", "left"); goto A64zE; BGNqq: $this->datatables->join("master_kelas f", "f.id_kelas=d.id_kelas", "left"); goto wl9qa; wl9qa: $this->db->order_by("ISNULL(f.level_id), f.level_id ASC"); goto F3e99; F3e99: $this->db->order_by("f.nama_kelas", "ASC"); goto u6hXN; hBmcF: return $this->datatables->generate(); goto mPShe; u6hXN: $this->db->order_by("b.status", "ASC"); goto hBmcF; D21VS: $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 BGNqq; dENZC: $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 cw92j; mPShe: } public function getAllSiswa($id_tp, $id_smt, $offset, $limit, $search = null, $sort = null, $order = null) { goto Eo2gc; uxQg2: $this->db->join("master_kelas f", "f.id_kelas=d.id_kelas", "left"); goto swzW_; GG72J: $this->db->like("a.nama", $search); goto LW5WC; H3r1z: $this->db->from("master_siswa a"); goto gsrqA; FCnuL: return $this->db->get()->result(); goto EYQIr; gsrqA: $this->db->limit($limit, $offset); goto uj8q7; tJCJM: $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 uxQg2; Eo2gc: $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 H3r1z; uj8q7: $this->db->order_by("a.nama", "ASC"); goto tJCJM; hVpIa: qVCPC: goto FCnuL; ug0i3: $this->db->or_like("a.nisn", $search); goto hVpIa; LW5WC: $this->db->or_like("a.nis", $search); goto ug0i3; swzW_: if (!($search != null)) { goto qVCPC; } goto GG72J; EYQIr: } public function getSiswaPage($id_tp, $id_smt, $offset, $limit, $search = null, $sort = null, $order = null) { goto JYWyr; IMWP7: $this->db->join("master_kelas f", "f.id_kelas=d.id_kelas", "left"); goto DoEad; DkLTY: $this->db->or_like("a.nis", $search); goto FIfhD; lxQ6x: if (!($search != null)) { goto VQXTl; } goto p5sX9; pQpc9: $this->db->order_by("a.nama", "ASC"); goto lxQ6x; JYWyr: $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 begua; hAy2F: $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 IMWP7; begua: $this->db->from("master_siswa a"); goto m0K0Q; oVkvH: $this->db->order_by("f.nama_kelas", "ASC"); goto pQpc9; DDMXS: return $this->db->get()->result(); goto ffU6z; FIfhD: $this->db->or_like("a.nisn", $search); goto tIaeS; tIaeS: VQXTl: goto DDMXS; m0K0Q: $this->db->limit($limit, $offset); goto hAy2F; DoEad: $this->db->order_by("ISNULL(f.level_id), f.level_id ASC"); goto oVkvH; p5sX9: $this->db->like("a.nama", $search); goto DkLTY; ffU6z: } public function getSiswaTotalPage($search = null) { goto t2YvJ; VVYSe: Bqhkb: goto jro_X; d8UAG: $this->db->like("nama", $search); goto wQrHM; t2YvJ: $this->db->select("id_siswa"); goto EesHW; fxSrb: $this->db->or_like("nisn", $search); goto VVYSe; wQrHM: $this->db->or_like("nis", $search); goto fxSrb; EesHW: $this->db->from("master_siswa"); goto mQMt5; jro_X: return $this->db->get()->num_rows(); goto HcvEV; mQMt5: if (!($search != null)) { goto Bqhkb; } goto d8UAG; HcvEV: } public function getDataSiswaByKelas($id_tp, $id_smt, $id_kelas, $offset, $limit, $search = null, $sort = null, $order = null) { goto Xd7Hj; CiSDT: $this->db->where("a.id_kelas", $id_kelas); goto z4fgj; Oh4Fr: $this->db->where("a.id_tp", $id_tp); goto LLZTI; Xd7Hj: $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 YiNfe; ORk8R: $this->db->or_like("b.nis", $search); goto RU_0I; pEL2o: if (!($search != null)) { goto WPw_g; } goto gOxkN; Oz6OK: $this->db->limit($limit, $offset); goto XHZCH; RU_0I: $this->db->or_like("b.nisn", $search); goto tqrrl; tqrrl: WPw_g: goto Oh4Fr; z4fgj: return $this->db->get()->result(); goto DTrV0; XHZCH: $this->db->join("master_siswa b", "b.id_siswa=a.id_siswa"); goto UrViT; UrViT: $this->db->join("master_kelas f", "f.id_kelas=a.id_kelas"); goto pEL2o; YiNfe: $this->db->from("kelas_siswa a"); goto Oz6OK; gOxkN: $this->db->like("b.nama", $search); goto ORk8R; LLZTI: $this->db->where("a.id_smt", $id_smt); goto CiSDT; DTrV0: } public function getDataSiswaByKelasPage($id_tp, $id_smt, $id_kelas, $search = null) { goto xvcQj; HNwUf: vERVX: goto e3KlK; IOkvn: $this->db->like("b.nama", $search); goto A9N6U; VNcQb: $this->db->join("master_siswa b", "b.id_siswa=a.id_siswa"); goto dMN8F; Y8DTU: $this->db->from("kelas_siswa a"); goto hT9O4; dMN8F: if (!($search != null)) { goto vERVX; } goto IOkvn; Mu_Q_: $this->db->or_like("b.nisn", $search); goto HNwUf; hT9O4: $this->db->where("a.id_tp", $id_tp); goto K3sKc; A86E3: $this->db->where("a.id_kelas", $id_kelas); goto VNcQb; xvcQj: $this->db->select("a.id_siswa"); goto Y8DTU; A9N6U: $this->db->or_like("b.nis", $search); goto Mu_Q_; e3KlK: return $this->db->get()->num_rows(); goto tgxdj; K3sKc: $this->db->where("a.id_smt", $id_smt); goto A86E3; tgxdj: } public function getSiswaById($id) { goto PyYbg; Jndbr: $this->db->join("buku_induk b", "a.id_siswa=b.id_siswa", "left"); goto MMk_n; PyYbg: $this->db->select("a.*, b.status"); goto ML13T; MMk_n: $this->db->where("a.id_siswa", $id); goto LxvGg; LxvGg: return $this->db->get()->row(); goto oS3X7; ML13T: $this->db->from("master_siswa a"); goto Jndbr; oS3X7: } public function getSiswaKelasBaru($id_tp, $id_smt) { goto rJlxR; SFI7d: foreach ($result as $key => $row) { $ret[$row->id_siswa] = $row; faUxu: } goto YRweU; HwJuJ: rPCQA: goto pA9IQ; TDbSZ: $this->db->join("master_siswa b", "b.id_siswa=a.id_siswa"); goto GKH7C; Honrj: $this->db->where("a.id_smt", $id_smt); goto NYK08; NYK08: $result = $this->db->get()->result(); goto yMGMC; pA9IQ: return $ret; goto nL4Eq; qwIYl: $this->db->where("a.id_tp", $id_tp); goto Honrj; EGYac: if (!$result) { goto rPCQA; } goto SFI7d; yMGMC: $ret = []; goto EGYac; fHKR3: $this->db->from("kelas_siswa a"); goto TDbSZ; YRweU: hIP3G: goto HwJuJ; rJlxR: $this->db->query("SET SQL_BIG_SELECTS=1"); goto bklVw; bklVw: $this->db->select("b.id_siswa, b.nama, f.id_kelas, f.nama_kelas, f.kode_kelas"); goto fHKR3; GKH7C: $this->db->join("master_kelas f", "f.id_kelas=a.id_kelas"); goto qwIYl; nL4Eq: } public function getDataSiswaById($id_tp, $id_smt, $idSiswa) { goto XxCJ8; C3Um_: $this->db->join("cbt_sesi_siswa c", "c.siswa_id=a.id_siswa", "left"); goto fzN3b; bOYOy: $this->db->join("master_kelas f", "f.id_kelas=a.id_kelas", "left"); goto vFZ_F; fzN3b: $this->db->join("cbt_ruang d", "d.id_ruang=c.ruang_id", "left"); goto sJ_9Y; hxBQi: $this->db->join("cbt_sesi j", "j.id_sesi=h.id_sesi", "left"); goto eqGOb; vFZ_F: $this->db->join("cbt_nomor_peserta g", "g.id_siswa=a.id_siswa AND g.id_tp=" . $id_tp, "left"); goto qTmG4; sJ_9Y: $this->db->join("cbt_sesi e", "e.id_sesi=c.sesi_id", "left"); goto bOYOy; ihYym: return $this->db->get()->row(); goto Evytt; eSfs9: $this->db->join("cbt_ruang i", "i.id_ruang=h.id_ruang", "left"); goto hxBQi; sOWY_: $this->db->where("a.id_siswa", $idSiswa); goto ihYym; GSX2C: $this->db->join("master_siswa b", "b.id_siswa=a.id_siswa", "left"); goto C3Um_; eqGOb: $this->db->where("a.id_tp", $id_tp); goto T6o_2; qTmG4: $this->db->join("cbt_kelas_ruang h", "h.id_kelas=a.id_kelas", "left"); goto eSfs9; yrIM9: $this->db->from("kelas_siswa a"); goto GSX2C; T6o_2: $this->db->where("a.id_smt", $id_smt); goto sOWY_; e_zyA: $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 yrIM9; XxCJ8: $this->db->query("SET SQL_BIG_SELECTS=1"); goto e_zyA; Evytt: } public function getAgamaSiswa() { goto v1i2D; iN285: $result = $this->db->get()->result(); goto dS5jF; pbCiw: M6Prv: goto dXxaZ; v1i2D: $this->db->select("agama"); goto IcAKM; IcAKM: $this->db->distinct(); goto yigEM; dXxaZ: return $ret; goto t3DF4; dS5jF: $ret["-"] = "Bukan Mapel Agama"; goto JONw_; JONw_: foreach ($result as $row) { $ret[$row->agama] = $row->agama; PmDAI: } goto pbCiw; Rg0H_: $this->db->where("a.agama != "0"", NULL, FALSE); goto wMQm6; AJa1O: $this->db->where("a.agama is NOT NULL", NULL, FALSE); goto Rg0H_; wMQm6: $this->db->not_like("a.agama", "Pilih"); goto iN285; yigEM: $this->db->from("master_siswa a"); goto AJa1O; t3DF4: } public function getJurusan() { goto EUBZA; phsAr: $this->db->order_by("nama_jurusan", "ASC"); goto HRkUF; hntCW: return $query->result(); goto yDmMn; W3dXz: $query = $this->db->get(); goto hntCW; fmkcQ: $this->db->from("master_kelas"); goto XUXaW; XUXaW: $this->db->join("master_jurusan", "jurusan_id=id_jurusan"); goto phsAr; EUBZA: $this->db->select("id_jurusan, nama_jurusan"); goto fmkcQ; HRkUF: $this->db->group_by("id_jurusan"); goto W3dXz; yDmMn: } public function getAllJurusan($id = null) { goto REAlq; D5kHl: D8FYp: goto InwBe; kmEmV: $id_jurusan = []; goto lmcRL; lmcRL: foreach ($jurusan as $j) { $id_jurusan[] = $j->jurusan_id; Bfo4x: } goto amGPe; C0ATL: goto EjoPS; goto XnOB_; N738f: EjoPS: goto WNfxy; XnOB_: ei_dA: goto uT_rs; uT_rs: $this->db->order_by("nama_jurusan", "ASC"); goto MvdSi; ZPLWh: $id_jurusan = null; goto D5kHl; mUlwQ: return $mapel; goto C0ATL; sKRs6: $this->db->select("jurusan_id"); goto KrVHj; sYCfh: if (!($id_jurusan === [])) { goto D8FYp; } goto ZPLWh; HxKEY: $this->db->where_not_in("id_jurusan", $id_jurusan); goto KUjmx; REAlq: if ($id === null) { goto ei_dA; } goto sKRs6; LjnIU: $jurusan = $this->db->get()->result(); goto kmEmV; KUjmx: $mapel = $this->db->get()->result(); goto mUlwQ; l_72r: $this->db->where("mapel_id", $id); goto LjnIU; InwBe: $this->db->select("*"); goto BuZXZ; amGPe: ctS2t: goto sYCfh; KrVHj: $this->db->from("jurusan_mapel"); goto l_72r; BuZXZ: $this->db->from("master_jurusan"); goto HxKEY; MvdSi: return $this->db->get("jurusan")->result(); goto N738f; WNfxy: } public function getKelasByJurusan($id) { $query = $this->db->get_where("master_kelas", array("jurusan_id" => $id)); return $query->result(); } public function getDataGuru($tp, $smt) { goto F8VfW; F8VfW: $this->db->query("SET SQL_BIG_SELECTS=1"); goto FEGcm; Em16C: $this->datatables->join("master_smt f", "b.id_smt=f.id_smt", "left"); goto iO4f1; GKMn6: $this->datatables->join("master_tp e", "b.id_tp=e.id_tp", "left"); goto Em16C; FEGcm: $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 Ewwqi; Ewwqi: $this->datatables->from("master_guru a"); goto x6e0e; x6e0e: $this->datatables->join("jabatan_guru b", "a.id_guru=b.id_guru AND b.id_tp=" . $tp . " AND b.id_smt=" . $smt . '', "left"); goto wOHs1; iO4f1: return $this->datatables->generate(); goto Izn29; wOHs1: $this->datatables->join("level_guru c", "b.id_jabatan=c.id_level", "left"); goto uxgyG; uxgyG: $this->datatables->join("master_kelas d", "b.id_kelas=d.id_kelas AND d.id_tp=" . $tp . " AND d.id_smt=" . $smt . '', "left"); goto GKMn6; Izn29: } public function getAllDataGuru($tp, $smt) { goto Dw1Ke; te2tq: $this->db->order_by("c.id_level", "desc"); goto Gd7eX; N0HUx: $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 dAFyj; NhiNY: $this->db->join("master_kelas d", "b.id_kelas=d.id_kelas AND d.id_tp=" . $tp . " AND d.id_smt=" . $smt . '', "left"); goto kU20u; dAFyj: $this->db->from("master_guru a"); goto ZRsv0; ZRsv0: $this->db->join("jabatan_guru b", "a.id_guru=b.id_guru AND b.id_tp=" . $tp . " AND b.id_smt=" . $smt . '', "left"); goto fQPH8; Gd7eX: $this->db->order_by("a.id_guru", "asc"); goto IsAIb; tAhsx: $this->db->join("master_smt f", "b.id_smt=f.id_smt", "left"); goto te2tq; kU20u: $this->db->join("master_tp e", "b.id_tp=e.id_tp", "left"); goto tAhsx; fQPH8: $this->db->join("level_guru c", "b.id_jabatan=c.id_level", "left"); goto NhiNY; IsAIb: return $this->db->get()->result(); goto hCGqu; Dw1Ke: $this->db->query("SET SQL_BIG_SELECTS=1"); goto N0HUx; hCGqu: } public function getGuruById($id, $id_tp = null, $id_smt = null) { goto CBLBr; l56wL: $this->db->join("level_guru c", "b.id_jabatan=c.id_level", "left"); goto D4N60; D4N60: if (!($id_tp != null && $id_smt != null)) { goto bpTg5; } goto qpj1z; lIXsn: $this->db->from("master_guru a"); goto zuGjA; CBLBr: $this->db->query("SET SQL_BIG_SELECTS=1"); goto e4Z_l; oQaLO: return $this->db->get()->row(); goto QBxFk; qpj1z: $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 pyH9O; pyH9O: bpTg5: goto IWjQ4; IWjQ4: $this->db->where("a.id_guru", $id); goto oQaLO; e4Z_l: $this->db->select("*"); goto lIXsn; zuGjA: $this->db->join("jabatan_guru b", "a.id_guru=b.id_guru", "left"); goto l56wL; QBxFk: } public function getGuruByArrId($arr_id) { goto ZrdV1; VOqD8: return $this->db->get()->result(); goto f0era; A8kMZ: if (!(count($arr_id) > 0)) { goto fJ4OA; } goto U9MOH; ZrdV1: $this->db->select("nama_guru"); goto NEiRs; IrHOK: fJ4OA: goto VOqD8; NEiRs: $this->db->from("master_guru"); goto A8kMZ; U9MOH: $this->db->where_in("id_guru", $arr_id); goto IrHOK; f0era: } public function getUserIdGuruByUsername($username) { goto J8op0; J8op0: $this->db->query("SET SQL_BIG_SELECTS=1"); goto SZL4R; FA3VN: $this->db->join("level_guru c", "b.id_jabatan=c.id_level", "left"); goto AEWAz; AEWAz: $this->db->where("a.username", $username); goto eSdtY; Dv1M2: $this->db->from("master_guru a"); goto JT6tW; eSdtY: return $this->db->get()->row(); goto AlXN4; JT6tW: $this->db->join("jabatan_guru b", "a.id_guru=b.id_guru", "left"); goto FA3VN; SZL4R: $this->db->select("*"); goto Dv1M2; AlXN4: } public function getDetailJabatanGuru($id_guru) { goto K0DgN; KB3oD: lemC2: goto cQxke; cQxke: return $ret; goto KidHA; hoE_w: $ret = []; goto lQdai; lQdai: foreach ($result as $row) { $ret[$row->id_tp][$row->id_smt] = $row; MpIWw: } goto KB3oD; KEsku: $result = $this->db->get()->result(); goto hoE_w; K0DgN: $this->db->query("SET SQL_BIG_SELECTS=1"); goto RAlTe; fDWKF: $this->db->from("master_guru a"); goto pqeHC; Ajoup: $this->db->join("master_kelas d", "b.id_kelas=d.id_kelas", "left"); goto Q_gO4; W9bg3: $this->db->join("level_guru c", "b.id_jabatan=c.id_level", "left"); goto Ajoup; RAlTe: $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 fDWKF; pqeHC: $this->db->join("jabatan_guru b", "a.id_guru=b.id_guru", "left"); goto W9bg3; Q_gO4: $this->db->where("a.id_guru", $id_guru); goto KEsku; KidHA: } public function getJabatanGuru($id_guru, $tp, $smt) { goto COO1s; aHR0e: $this->db->join("master_kelas d", "b.id_kelas=d.id_kelas AND d.id_tp=" . $tp . " AND d.id_smt=" . $smt . '', "left"); goto HZB2G; HZB2G: $this->db->where("a.id_guru", $id_guru); goto CIlcP; COO1s: $this->db->query("SET SQL_BIG_SELECTS=1"); goto WVIPa; b095T: $this->db->join("jabatan_guru b", "a.id_guru=b.id_guru AND b.id_tp=" . $tp . " AND b.id_smt=" . $smt . '', "left"); goto ojSMa; btZe1: return $query; goto wMyRZ; ojSMa: $this->db->join("level_guru c", "b.id_jabatan=c.id_level", "left"); goto aHR0e; WVIPa: $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 PibLK; PibLK: $this->db->from("master_guru a"); goto b095T; CIlcP: $query = $this->db->get()->row(); goto btZe1; wMyRZ: } public function getGuruMapel($tp, $smt) { goto fk4dX; waUML: $this->db->from("jabatan_guru a"); goto Sc1X0; ytVEj: $this->db->where("a.id_tp", $tp); goto gwVeo; kTy8N: return $query; goto LJN2l; fk4dX: $this->db->select("a.mapel_kelas, a.ekstra_kelas, a.id_jabatan, a.id_kelas, b.id_guru, b.nama_guru"); goto waUML; gAMhd: $query = $this->db->get()->result(); goto kTy8N; Sc1X0: $this->db->join("master_guru b", "a.id_guru=b.id_guru"); goto ytVEj; gwVeo: $this->db->where("a.id_smt", $smt); goto gAMhd; LJN2l: } public function getKodeKelompokMapel() { goto dxZ9t; dxZ9t: $this->db->select("*"); goto Zb8vq; jeYp6: $ret = []; goto uldjV; kLTsj: return $ret; goto uBAFj; Zb8vq: $this->db->from("master_kelompok_mapel"); goto UUGOA; uldjV: foreach ($result as $row) { $ret[$row->kode_kel_mapel] = $row; HpZ71: } goto Ipk4u; q3ibn: $result = $this->db->get()->result(); goto jeYp6; Ipk4u: UGh4r: goto kLTsj; UUGOA: $this->db->order_by("kode_kel_mapel"); goto q3ibn; uBAFj: } public function getDataKelompokMapel() { goto UMuFw; inHnJ: $ret = []; goto n40bZ; V_pSv: return $ret; goto ZIKQ0; bFR_R: $this->db->where("id_parent", "0"); goto aQLvQ; UMuFw: $this->db->select("*"); goto zfZq_; RHeql: $result = $this->db->get()->result(); goto inHnJ; zfZq_: $this->db->from("master_kelompok_mapel"); goto bFR_R; n40bZ: foreach ($result as $row) { $ret[$row->id_kel_mapel] = $row; nJJm2: } goto uKj_1; uKj_1: qXoiC: goto V_pSv; aQLvQ: $this->db->order_by("kode_kel_mapel"); goto RHeql; ZIKQ0: } public function getKategoriKelompokMapel() { goto NgSzn; ULAvs: $result = $this->db->get()->result(); goto tBOXM; zuCpo: $this->db->from("master_kelompok_mapel"); goto ULAvs; NgSzn: $this->db->select("kode_kel_mapel, kategori"); goto SnIEf; SnIEf: $this->db->where("kategori", "WAJIB")->or_where("kategori", "PAI (Kemenag)"); goto zuCpo; tBOXM: return $result; goto bo7qL; bo7qL: } public function getDataSubKelompokMapel() { goto CFJ2Z; QYM3M: $this->db->where("id_parent <> 0"); goto vGHeY; kp5lL: $this->db->from("master_kelompok_mapel"); goto QYM3M; vGHeY: $this->db->order_by("kode_kel_mapel"); goto YjBlK; CFJ2Z: $this->db->select("*"); goto kp5lL; YjBlK: $result = $this->db->get()->result(); goto VeJWH; gYCvj: h1853: goto TiRP_; VeJWH: $ret = []; goto yAU04; TiRP_: return $ret; goto SqY2M; yAU04: foreach ($result as $row) { $ret[$row->id_kel_mapel] = $row; nTg_L: } goto gYCvj; SqY2M: } public function getDataMapel() { goto On0mw; YHYAX: $this->datatables->from("master_mapel"); goto ZJDf4; ZJDf4: return $this->datatables->generate(); goto gj9a3; On0mw: $this->datatables->select("id_mapel, nama_mapel, kode"); goto YHYAX; gj9a3: } public function getAllMapel($arrKelompok = null, $arrMapel = null) { goto Y3V_V; ImsGA: $this->db->where("status", "1"); goto HNh_x; NG2iR: return $this->db->get("master_mapel")->result(); goto oedyf; Y3V_V: if (!($arrMapel != null)) { goto B1NTQ; } goto tqWFY; tqWFY: $this->db->where_in("kelompok", $arrKelompok); goto Wcs2k; Y3xCh: CM5gD: goto ImsGA; HNh_x: $this->db->order_by("urutan_tampil"); goto NG2iR; kjrXP: if (!($arrMapel != null)) { goto CM5gD; } goto scIdd; scIdd: $this->db->or_where_in("id_mapel", explode(",", $arrMapel)); goto Y3xCh; Wcs2k: B1NTQ: goto kjrXP; oedyf: } public function getAllStatusMapel($arrKelompok = null, $arrMapel = null) { goto jyfaP; jyfaP: if (!($arrMapel != null)) { goto WLZCN; } goto wOsNL; wOsNL: $this->db->where_in("kelompok", $arrKelompok); goto GbdZu; VEYJ8: $this->db->or_where_in("id_mapel", explode(",", $arrMapel)); goto p9pEe; msOlj: $this->db->order_by("urutan_tampil"); goto JKgCI; zloi1: if (!($arrMapel != null)) { goto EHyGI; } goto VEYJ8; GbdZu: WLZCN: goto zloi1; p9pEe: EHyGI: goto msOlj; JKgCI: return $this->db->get("master_mapel")->result(); goto E65mZ; E65mZ: } public function getAllMapelByKelompok($jenjang) { goto qVrbF; qVrbF: $this->db->where("status", "1"); goto ZgMRy; Xu3NC: uU39g: goto ZFF1m; KtcLY: $this->db->order_by("urutan_tampil"); goto BYWmn; RTFgt: $ret = []; goto cavgb; ZgMRy: $this->db->order_by("urutan"); goto KtcLY; BYWmn: $result = $this->db->get("master_mapel")->result(); goto RTFgt; cavgb: foreach ($result as $row) { $ret[$row->kelompok][] = $row; X1VGN: } goto Xu3NC; ZFF1m: return $ret; goto srzNL; srzNL: } public function getAllMapelNonAktif($jenjang) { $this->db->where("status", "0"); return $this->db->get("master_mapel")->result(); } public function getMapelById($id, $single = false) { goto ZqrVh; Nyx90: $query = $this->db->get_where("master_mapel", array("id_mapel" => $id))->row(); goto Ox8Mz; TNHb0: gzo10: goto rDX3S; jPqHv: $this->db->order_by("nama_mapel"); goto t3pZ6; EDtu6: return $query; goto eQeeZ; rDX3S: $this->db->where_in("id_mapel", $id); goto jPqHv; YqIWG: BadiP: goto EDtu6; ZqrVh: if ($single === false) { goto gzo10; } goto Nyx90; Ox8Mz: goto BadiP; goto TNHb0; t3pZ6: $query = $this->db->get("master_mapel")->result(); goto YqIWG; eQeeZ: } function updateMapel() { goto A3Y8k; lv85n: if (!($kelompok != null)) { goto w_tdK; } goto RGZGZ; TJEFq: $this->db->set("nama_mapel", $name); goto mIKBZ; U9zyd: $this->db->where("id_mapel", $id); goto PSbjE; eJYNT: w_tdK: goto JCXH7; JCXH7: $this->db->set("status", $status); goto Yrw8u; Yrw8u: $this->db->set("urutan_tampil", $urut); goto U9zyd; s6sis: $urut = $this->input->post("urutan_tampil", true); goto TJEFq; RGZGZ: $this->db->set("kelompok", $kelompok); goto eJYNT; j7EpT: $status = $this->input->post("status", true); goto s6sis; PSbjE: return $this->db->update("master_mapel"); goto k7hGy; xM3nP: $kode = $this->input->post("kode_mapel", true); goto Nl3xe; A3Y8k: $id = $this->input->post("id_mapel"); goto ssP2Y; Nl3xe: $kelompok = $this->input->post("kelompok", true); goto j7EpT; mIKBZ: $this->db->set("kode", $kode); goto lv85n; ssP2Y: $name = $this->input->post("nama_mapel", true); goto xM3nP; k7hGy: } public function getAllEkstra() { return $this->db->get("master_ekstra")->result(); } public function getEkstraById($id, $single = false) { goto riXUf; KfJex: return $query; goto R1U8g; ii0yp: goto i_v8P; goto gb3Bj; vBTb0: $this->db->where_in("id_ekstra", $id); goto pjb9s; t3Tqi: i_v8P: goto KfJex; ORe9D: $query = $this->db->get("master_ekstra")->result(); goto t3Tqi; gd_6P: $query = $this->db->get_where("master_ekstra", array("id_ekstra" => $id))->row(); goto ii0yp; riXUf: if ($single === false) { goto YZTu1; } goto gd_6P; gb3Bj: YZTu1: goto vBTb0; pjb9s: $this->db->order_by("nama_ekstra"); goto ORe9D; R1U8g: } function updateEkstra() { goto q03Wz; q03Wz: $id = $this->input->post("id_ekstra"); goto mZNQL; iapEo: $kode = $this->input->post("kode_ekstra", true); goto uF9s1; FacoJ: $this->db->set("kode_ekstra", $kode); goto Gmg3n; Gmg3n: $this->db->where("id_ekstra", $id); goto iTAAa; iTAAa: return $this->db->update("master_ekstra"); goto VJF21; mZNQL: $name = $this->input->post("nama_ekstra", true); goto iapEo; uF9s1: $this->db->set("nama_ekstra", $name); goto FacoJ; VJF21: } public function getKelasGuru() { goto n5RFz; n5RFz: $this->db->query("SET SQL_BIG_SELECTS=1"); goto CGFC_; AhJLa: $this->datatables->group_by("guru.nama_guru"); goto cw0Vs; cw0Vs: return $this->datatables->generate(); goto DrjmI; QnGbc: $this->datatables->join("master_kelas", "kelas_id=id_kelas"); goto OpPUV; PZ9CJ: $this->datatables->from("kelas_guru"); goto QnGbc; CGFC_: $this->datatables->select("kelas_guru.id, guru.id_guru, guru.nip, guru.nama_guru, GROUP_CONCAT(master_kelas.nama_kelas) as kelas"); goto PZ9CJ; OpPUV: $this->datatables->join("master_guru", "guru_id=id_guru"); goto AhJLa; DrjmI: } public function getKelasByGuru($id) { goto fDShN; JUbu0: $query = $this->db->get()->result(); goto b292R; b292R: return $query; goto g5wka; fDShN: $this->db->select("kelas.id_kelas"); goto thiEI; HrTpO: $this->db->where("guru_id", $id); goto JUbu0; kZ6Ek: $this->db->join("master_kelas", "kelas_guru.kelas_id=kelas.id_kelas"); goto HrTpO; thiEI: $this->db->from("kelas_guru"); goto kZ6Ek; g5wka: } public function getAllJabatanGuru($id) { goto gCuBB; gCuBB: $result = $this->db->get_where("jabatan_guru", "id_guru=" . $id)->result(); goto urTRn; urTRn: if (!$result) { goto rntGl; } goto cjIpA; E3sgc: rntGl: goto T2NIV; c5XTa: oSl2_: goto E3sgc; cjIpA: foreach ($result as $key => $row) { $ret[$row->id_tp][$row->id_smt] = $row->id_kelas; GjjLf: } goto c5XTa; T2NIV: return $ret; goto CgH8U; CgH8U: } public function getJurusanMapel() { goto xckvv; r0jXK: $this->datatables->from("jurusan_mapel"); goto kaXvU; hliis: $this->datatables->select("jurusan_mapel.id, mapel.id_mapel, mapel.nama_mapel, jurusan.id_jurusan, GROUP_CONCAT(jurusan.nama_jurusan) as nama_jurusan"); goto r0jXK; JaajG: $this->datatables->join("master_jurusan", "jurusan_id=id_jurusan"); goto YJ0dm; rEXLA: return $this->datatables->generate(); goto NAo0g; xckvv: $this->db->query("SET SQL_BIG_SELECTS=1"); goto hliis; YJ0dm: $this->datatables->group_by("master_mapel.nama_mapel"); goto rEXLA; kaXvU: $this->datatables->join("master_mapel", "mapel_id=id_mapel"); goto JaajG; NAo0g: } public function getMapel($id = null) { goto hlGmX; wL1E8: $this->db->where_not_in("mapel_id", [$id]); goto iXMn5; TnAct: foreach ($mapel as $d) { $id_mapel[] = $d->mapel_id; uor4d: } goto X8HgG; kD40H: $id_mapel = []; goto TnAct; nYRpP: $id_mapel = null; goto o5LSI; o5LSI: hPHk4: goto YxOOQ; RJx24: $mapel = $this->db->get()->result(); goto kD40H; F6L7o: if (!($id !== null)) { goto LOqdg; } goto wL1E8; xHgsy: $this->db->from("master_mapel"); goto GfHty; hlGmX: $this->db->select("mapel_id"); goto kkCbk; iXMn5: LOqdg: goto RJx24; Hte9m: return $this->db->get()->result(); goto fWFEh; kkCbk: $this->db->from("jurusan_mapel"); goto F6L7o; X8HgG: JJlWX: goto TtPxQ; YxOOQ: $this->db->select("id_mapel, nama_mapel"); goto xHgsy; GfHty: $this->db->where_not_in("id_mapel", $id_mapel); goto Hte9m; TtPxQ: if (!($id_mapel === [])) { goto hPHk4; } goto nYRpP; fWFEh: } public function getJurusanByIdMapel($id) { goto aLwzL; aLwzL: $this->db->select("jurusan.id_jurusan"); goto OJKnl; aC0oT: $query = $this->db->get()->result(); goto QX2KC; QX2KC: return $query; goto B1BDp; OJKnl: $this->db->from("jurusan_mapel"); goto B3UcY; vkymf: $this->db->where("mapel_id", $id); goto aC0oT; B3UcY: $this->db->join("master_jurusan", "jurusan_mapel.jurusan_id=jurusan.id_jurusan"); goto vkymf; B1BDp: } public function getTahunActive() { goto Nf5av; hlJA8: return $result; goto GuGBD; qcVfM: $this->db->from("master_tp"); goto KDZRk; KDZRk: $this->db->where("active", 1); goto HaQZ0; Nf5av: $this->db->select("id_tp, tahun"); goto qcVfM; HaQZ0: $result = $this->db->get()->row(); goto hlJA8; GuGBD: } public function getSemesterActive() { goto mV4JX; mV4JX: $this->db->select("id_smt, nama_smt, smt"); goto se9Ik; se9Ik: $this->db->from("master_smt"); goto L6X6M; vZWmT: $result = $this->db->get()->row(); goto VXgIC; L6X6M: $this->db->where("active", 1); goto vZWmT; VXgIC: return $result; goto vZCfm; vZCfm: } public function getJmlHariEfektif($id) { goto WM6Ar; md43F: return $result; goto Eh8q6; WM6Ar: $this->db->select("*"); goto IeVlx; IeVlx: $this->db->from("master_hari_efektif"); goto qulxy; qulxy: $this->db->where("id_hari_efektif", $id); goto xzNeC; xzNeC: $result = $this->db->get()->row(); goto md43F; Eh8q6: } public function getDistinctTahunLulus() { goto bYfxU; aZ3fS: lOYpo: goto DqJVq; bYfxU: $this->db->select("tahun_lulus"); goto cnBRJ; rubxW: foreach ($result as $row) { goto W1D7Z; M9c1K: s9x7T: goto R03wo; ulkjo: $ret[$row->tahun_lulus] = $row->tahun_lulus; goto BssY9; W1D7Z: if (!($row->tahun_lulus != '')) { goto dELZ3; } goto ulkjo; BssY9: dELZ3: goto M9c1K; R03wo: } goto aZ3fS; cnBRJ: $this->db->distinct(); goto iqSlt; hfDTw: $ret = []; goto rubxW; DqJVq: return $ret; goto h7lCT; iqSlt: $result = $this->db->get("buku_induk")->result(); goto hfDTw; h7lCT: } public function getDistinctKelasAkhir() { goto WhK3s; WhK3s: $this->db->select("kelas_akhir"); goto zsIja; zsIja: $this->db->distinct(); goto rEoDX; rEoDX: $result = $this->db->get("buku_induk")->result(); goto e99Au; e99Au: $ret = []; goto G7mF2; Hiw5k: XijAC: goto I1gzf; I1gzf: return $ret; goto Jy_JS; G7mF2: foreach ($result as $row) { goto zXPtt; XhN1W: f_WKm: goto l9iTJ; f0xNq: $ret[$row->kelas_akhir] = $row->kelas_akhir; goto XhN1W; l9iTJ: lcY5g: goto YehVM; zXPtt: if (!($row->kelas_akhir != '')) { goto f_WKm; } goto f0xNq; YehVM: } goto Hiw5k; Jy_JS: } public function getAlumniByTahun($tahun, $kelas = null) { goto DKtdh; HkTVf: return $this->db->get()->result(); goto gbmR6; D2Fw9: $this->db->where("a.tahun_lulus", $tahun); goto Mgq3c; IOpHa: $this->db->from("buku_induk a"); goto nj4Wb; NO_Lo: $this->db->where("a.kelas_akhir", $kelas); goto kmyTL; DKtdh: $this->db->select("*"); goto IOpHa; Mgq3c: if (!($kelas != null)) { goto TyRrj; } goto NO_Lo; nj4Wb: $this->db->join("master_siswa b", "a.id_siswa=b.id_siswa"); goto D2Fw9; kmyTL: TyRrj: goto HkTVf; gbmR6: } public function getAlumniById($id) { goto igorK; igorK: $this->db->select("*"); goto ZzxDz; ZzxDz: $this->db->from("master_siswa a"); goto QDomy; cx57h: return $this->db->get()->row(); goto WGc4u; QDomy: $this->db->join("buku_induk b", "a.id_siswa=b.id_siswa"); goto RYMNy; RYMNy: $this->db->where("a.id_siswa", $id); goto cx57h; WGc4u: } public function getAllWaliKelas() { goto D5Ody; URCO0: $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 YOmau; cdhgL: $ret = []; goto zZOO0; zZOO0: if (!$result) { goto vtoCY; } goto cJqw3; D5Ody: $this->db->query("SET SQL_BIG_SELECTS=1"); goto URCO0; qlNeM: $result = $this->db->get()->result(); goto cdhgL; F1DHO: $this->db->join("master_guru b", "a.id_guru=b.id_guru", "left"); goto crbLw; KCJg9: $this->db->join("master_kelas d", "a.id_kelas=d.id_kelas", "left"); goto qlNeM; uMNm6: ydddU: goto RH73x; crbLw: $this->db->join("level_guru c", "a.id_jabatan=c.id_level", "left"); goto KCJg9; YOmau: $this->db->from("jabatan_guru a"); goto F1DHO; RH73x: vtoCY: goto o2mi3; o2mi3: return $ret; goto aHjyj; cJqw3: foreach ($result as $key => $row) { goto mcKrN; mcKrN: if (!($row->id_level == "4")) { goto UFcEs; } goto hN_5y; hN_5y: $ret[$row->id_tp][$row->id_smt][$row->id_kelas] = $row; goto YKb90; YKb90: UFcEs: goto dQaVk; dQaVk: y2sO1: goto aakTr; aakTr: } goto uMNm6; aHjyj: } public function getAllGuru() { goto SVd8K; oPOgb: $id_guru = []; goto mzs10; mzs10: foreach ($guru as $d) { $id_guru[] = $d->id_guru; SWHXE: } goto Fou4G; Fou4G: MZlgg: goto YwN0t; J4_1G: return $this->db->get()->result(); goto LIUzX; SVd8K: $this->db->select("id_guru"); goto TJ5II; RJyzd: $guru = $this->db->get()->result(); goto oPOgb; YwN0t: $this->db->select("id_guru, nip, nama_guru"); goto xKreu; TJ5II: $this->db->from("jabatan_guru"); goto RJyzd; Mnqzo: $this->db->where_in("id_guru", $id_guru); goto J4_1G; xKreu: $this->db->from("master_guru"); goto Mnqzo; LIUzX: } public function getAllKelas($tp = null, $smt = null) { goto c52qt; acl12: foreach ($result as $key => $row) { $ret[$row->id_kelas] = $row; O6HTm: } goto lpsc9; Rocw3: foreach ($result as $key => $row) { $ret[$row->id_tp][$row->id_smt][$row->id_kelas] = $row; uMEBs: } goto V0PtN; pupeh: $this->db->join("master_jurusan b", "a.jurusan_id=b.id_jurusan", "left"); goto e1WBO; Nc1xm: if ($tp != null && $smt != null) { goto jHU07; } goto fta5K; ZuIif: return $ret; goto yvwBW; c52qt: $this->db->query("SET SQL_BIG_SELECTS=1"); goto xUq1X; W4jqv: $this->db->order_by("a.nama_kelas"); goto rsOYS; puSat: if (!($tp != null && $smt != null)) { goto bWFkE; } goto GUfjM; STJ60: $ret = []; goto Nc1xm; V0PtN: oJa1U: goto JfM5h; Frqug: $this->db->from("master_kelas a"); goto puSat; R13h9: if (!$result) { goto vziHt; } goto acl12; JfM5h: FWDCO: goto PL2dm; GUfjM: $this->db->where("a.id_tp", $tp)->where("a.id_smt", $smt); goto NKuxq; rb0aS: pV0C9: goto ZuIif; NKuxq: bWFkE: goto gHhcT; LJzKo: jHU07: goto R13h9; PL2dm: goto pV0C9; goto LJzKo; e1WBO: $this->db->join("master_guru c", "f.id_guru=c.id_guru", "left"); goto W4jqv; rsOYS: $result = $this->db->get()->result(); goto STJ60; fta5K: if (!$result) { goto FWDCO; } goto Rocw3; ae3hJ: vziHt: goto rb0aS; gHhcT: $this->db->join("jabatan_guru f", "f.id_kelas=a.id_kelas", "left"); goto pupeh; lpsc9: TLsbi: goto ae3hJ; xUq1X: $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 Frqug; yvwBW: } public function getAllKelasSiswa() { goto DXgF0; R66Z8: $this->db->from("kelas_siswa"); goto opwKb; DXgF0: $this->db->select("*"); goto R66Z8; LjYcf: $ret = []; goto IJR3s; j8o7b: foreach ($result as $key => $row) { $ret[$row->id_kelas][$row->id_siswa] = $row; u6kJp: } goto ywa2o; x9BDe: Rd2hW: goto zlYs1; IJR3s: if (!$result) { goto Rd2hW; } goto j8o7b; opwKb: $result = $this->db->get()->result(); goto LjYcf; ywa2o: pomTW: goto x9BDe; zlYs1: return $ret; goto m7F9x; m7F9x: } public function getDataInduk() { goto pAxdr; pAxdr: $this->db->select("a.*, b.*,"); goto aocbw; aocbw: $this->db->from("master_siswa a"); goto LZ5Kq; bfggH: xO5wz: goto aVSZb; AtCI2: return $ret; goto BtJIX; nY7y1: $ret = []; goto uC2SE; LZ5Kq: $this->db->join("buku_induk b", "a.id_siswa=b.id_siswa", "left"); goto Xz_TB; ySPdh: foreach ($result as $key => $row) { $ret[$row->id_siswa] = $row; Yi_RA: } goto bfggH; aVSZb: XmCSN: goto AtCI2; Xz_TB: $this->db->order_by("a.nama", "ASC"); goto eimrF; uC2SE: if (!$result) { goto XmCSN; } goto ySPdh; eimrF: $result = $this->db->get()->result(); goto nY7y1; BtJIX: } }
?>Did this file decode correctly?
Original Code
<?php
/* ________________________________________
| GarudaCBT |
| https://github.com/garudacbt/cbt |
|________________________________________|
*/
defined("\x42\x41\x53\105\120\101\124\110") or exit("\116\157\40\144\x69\162\x65\x63\164\x20\163\143\x72\151\x70\x74\40\x61\143\143\145\x73\x73\40\x61\x6c\x6c\x6f\x77\x65\x64"); class Master_model extends CI_Model { public function create($table, $data, $batch = false) { goto POocE; jbD8U: $insert = $this->db->insert_batch($table, $data); goto WF9b8; RYzw1: zwYGK: goto HSpsK; HSpsK: $insert = $this->db->insert($table, $data); goto BKQYz; POocE: if ($batch === false) { goto zwYGK; } goto jbD8U; zXq9C: return $insert; goto v3cPz; WF9b8: goto tFfS6; goto RYzw1; BKQYz: tFfS6: goto zXq9C; v3cPz: } public function update($table, $data, $pk, $id = null, $batch = false) { goto Ar4WW; Ar4WW: if ($batch === false) { goto g3tG3; } goto RVClT; uDGCX: g3tG3: goto DVRiZ; DVRiZ: $insert = $this->db->update($table, $data, array($pk => $id)); goto nB6vq; nB6vq: b9bih: goto vVoRz; Vvc4S: goto b9bih; goto uDGCX; RVClT: $insert = $this->db->update_batch($table, $data, $pk); goto Vvc4S; vVoRz: return $insert; goto oGQSj; oGQSj: } public function delete($table, $data, $pk) { $this->db->where_in($pk, $data); return $this->db->delete($table); } public function delete_not($table, $data, $pk, $col, $not) { goto wMJJB; wMJJB: $this->db->where_in($pk, $data); goto Su1dN; Su1dN: $this->db->where($col . "\41\x3d" . $not); goto yEydP; yEydP: return $this->db->delete($table); goto Uw_6S; Uw_6S: } public function getDataKelas() { goto toouj; toouj: $this->datatables->select("\x69\144\137\153\x65\154\x61\x73\x2c\40\156\x61\x6d\x61\137\x6b\145\x6c\x61\163\x2c\x20\x69\x64\x5f\x6a\165\x72\x75\163\141\x6e\54\x20\156\141\x6d\x61\137\152\x75\162\165\x73\x61\x6e"); goto QDLCT; k7TtR: return $this->datatables->generate(); goto rInid; dux2A: $this->datatables->add_column("\x62\x75\154\x6b\x5f\x73\145\154\145\x63\x74", "\74\144\x69\x76\40\143\x6c\141\x73\163\75\x22\164\145\x78\x74\x2d\143\145\156\164\x65\x72\42\x3e\x3c\x69\x6e\160\165\x74\40\164\x79\160\x65\75\x22\x63\150\145\x63\x6b\142\157\x78\x22\40\x63\x6c\x61\x73\163\75\x22\143\150\x65\143\153\x22\40\x6e\x61\155\x65\x3d\42\143\x68\x65\143\x6b\145\144\x5b\x5d\42\x20\166\x61\x6c\x75\145\x3d\x22\x24\61\x22\57\x3e\x3c\57\x64\x69\x76\x3e", "\x69\x64\137\153\145\x6c\x61\x73\x2c\40\x6e\x61\x6d\141\x5f\x6b\x65\154\141\163\x2c\x20\151\x64\137\x6a\x75\162\165\x73\141\156\x2c\x20\156\x61\155\141\x5f\x6a\x75\x72\165\x73\141\156"); goto k7TtR; rTtn5: $this->datatables->join("\155\141\163\x74\x65\162\x5f\x6a\165\162\165\x73\x61\156", "\x6a\165\x72\x75\163\141\156\137\151\144\75\151\x64\x5f\152\x75\x72\x75\163\141\x6e"); goto dux2A; QDLCT: $this->datatables->from("\x6d\141\x73\164\145\162\x5f\153\145\154\x61\163"); goto rTtn5; rInid: } public function getKelasById($id) { goto cmW5O; w850Q: $this->db->order_by("\156\x61\x6d\x61\x5f\153\145\154\x61\x73"); goto z1id8; kWraL: $this->db->from("\155\141\163\164\145\162\x5f\153\145\x6c\x61\x73"); goto b2YQN; b2YQN: $this->db->where("\x69\x64\137\153\145\154\141\163", $id); goto w850Q; z1id8: $query = $this->db->get()->row(); goto BhUT2; cmW5O: $this->db->select("\151\x64\137\x6b\x65\154\141\163\54\x20\x6e\141\155\141\x5f\x6b\145\x6c\x61\163\54\40\154\145\x76\x65\154\137\151\x64"); goto kWraL; BhUT2: return $query; goto nXdP6; nXdP6: } public function getDataJurusan() { goto CZ1z7; owOMO: $this->db->from("\x6d\x61\x73\x74\x65\x72\x5f\x6a\165\162\165\x73\141\x6e"); goto vu7W6; cg_cK: return $result; goto oODQ6; vu7W6: $result = $this->db->get()->result(); goto cg_cK; CZ1z7: $this->db->select("\x2a"); goto owOMO; oODQ6: } public function getDataJurusanMapel($arrIds) { goto r1Mke; d_kpS: $result = $this->db->get()->result(); goto DC6MP; Z5T6y: yG5Zv: goto RpvVH; RpvVH: MU72G: goto iPb_a; DC6MP: $ret = []; goto dBu1y; zk1sF: $this->db->where_in("\x69\x64\x5f\x6d\141\160\145\x6c", $arrIds); goto d_kpS; iPb_a: return $ret; goto shYzK; r1Mke: $this->db->select("\x69\144\x5f\x6d\141\x70\145\x6c\x2c\x20\156\141\x6d\x61\137\x6d\x61\x70\145\x6c"); goto gpWKH; gpWKH: $this->db->from("\x6d\x61\163\x74\x65\162\137\155\141\x70\145\x6c"); goto zk1sF; bE_cR: foreach ($result as $key => $row) { $ret[$row->id_mapel] = $row->nama_mapel; lqaFl: } goto Z5T6y; dBu1y: if (!$result) { goto MU72G; } goto bE_cR; shYzK: } public function getDataTableJurusan() { goto zN0BY; Ed2Jf: return $this->datatables->generate(); goto ybcgO; yjjPI: $this->datatables->from("\155\x61\x73\x74\145\162\x5f\152\x75\162\x75\x73\x61\156"); goto HZ6Fx; zN0BY: $this->datatables->select("\x2a"); goto yjjPI; HZ6Fx: $this->db->order_by("\x69\x64\137\152\165\162\x75\x73\x61\x6e"); goto Ed2Jf; ybcgO: } public function getJurusanById($id) { goto hTbtA; m45lY: $this->db->order_by("\x6e\141\155\x61\x5f\152\x75\x72\165\x73\141\156"); goto eVhu5; eVhu5: $query = $this->db->get("\x6d\141\163\x74\x65\162\x5f\x6a\x75\x72\165\163\141\156")->result(); goto D5SJv; hTbtA: $this->db->where_in("\151\x64\x5f\152\x75\x72\165\163\141\156", $id); goto m45lY; D5SJv: return $query; goto hSwSD; hSwSD: } function updateJurusan() { goto m_nZM; jNY0M: goto QtS_F; goto wzhHx; zO3uy: $kode = $this->input->post("\153\x6f\144\145\137\152\x75\x72\x75\x73\141\156", true); goto q23bo; q23bo: $mapels = []; goto hpeG0; Nw6j3: $this->db->where("\x69\x64\137\152\165\162\x75\x73\x61\156", $id); goto x2W33; L9qfi: $i++; goto jNY0M; m7TCb: $row_mapels = count($this->input->post("\155\x61\160\145\x6c", true)); goto mwVam; hpeG0: $check_mapel = $this->input->post("\155\141\x70\x65\x6c", true); goto uRN5s; rwsXk: $this->db->set("\155\x61\x70\145\x6c\137\x70\145\155\x69\156\x61\x74\x61\156", implode("\x2c", $mapels)); goto jJUR4; x2W33: return $this->db->update("\155\141\163\164\145\162\x5f\152\165\162\x75\163\x61\x6e"); goto zZwG3; uRN5s: if (!$check_mapel) { goto p7_gA; } goto m7TCb; jJUR4: $this->db->set("\163\x74\141\x74\x75\x73", "\x31"); goto Nw6j3; wzhHx: JTm0m: goto U3JNc; m_nZM: $id = $this->input->post("\x69\x64\x5f\x6a\x75\162\x75\163\x61\156"); goto zXgKX; fliIf: QtS_F: goto bSdA8; QU7Pt: upHNX: goto L9qfi; zXgKX: $name = $this->input->post("\156\x61\x6d\x61\x5f\152\x75\x72\165\163\x61\x6e", true); goto zO3uy; mwVam: $i = 0; goto fliIf; mWg6K: $this->db->set("\x6e\x61\155\141\137\152\x75\162\165\x73\141\156", $name); goto mbnBE; bSdA8: if (!($i <= $row_mapels)) { goto JTm0m; } goto ccd2u; ccd2u: array_push($mapels, $this->input->post("\x6d\x61\x70\145\x6c\x5b" . $i . "\x5d", true)); goto QU7Pt; mbnBE: $this->db->set("\x6b\157\x64\x65\x5f\152\165\x72\x75\163\141\x6e", $kode); goto rwsXk; U3JNc: p7_gA: goto mWg6K; zZwG3: } public function inputJurusan() { $data = ["\x6e\x61\x6d\141\x5f\x6a\165\162\x75\x73\x61\x6e" => $this->input->post("\x6e\x61\155\141\137\152\x75\162\x75\x73\x61\156", true), "\x6b\x6f\x64\145\137\152\165\162\165\x73\x61\x6e" => $this->input->post("\x6b\157\x64\145\x5f\x6a\165\x72\165\x73\x61\156", true)]; return $this->db->insert("\x6d\x61\x73\x74\x65\x72\137\152\165\x72\x75\x73\x61\x6e", $data); } public function getAllDataSiswa($id_tp, $id_smt) { goto o8UbT; BVPpj: $this->db->select("\141\x2e\52\54\40\143\x2e\x6e\x61\155\x61\137\x6b\x65\x6c\141\x73"); goto VCQ0u; jzi3d: $this->db->join("\153\x65\x6c\x61\x73\x5f\x73\151\x73\167\141\40\x62", "\142\x2e\151\x64\137\163\151\163\x77\x61\75\x61\x2e\x69\144\x5f\163\x69\x73\167\141\40\101\x4e\x44\x20\x62\x2e\151\144\x5f\164\x70\x3d" . $id_tp . "\x20\101\116\104\x20\142\56\x69\144\x5f\x73\x6d\164\x3d" . $id_smt . '', "\x6c\x65\146\x74"); goto KkP6m; VCQ0u: $this->db->from("\155\x61\163\164\x65\162\x5f\x73\151\163\x77\x61\40\141"); goto jzi3d; KkP6m: $this->db->join("\155\141\163\x74\x65\162\x5f\153\x65\x6c\141\x73\40\x63", "\143\56\x69\x64\x5f\153\x65\154\x61\x73\x3d\x62\56\151\x64\137\153\x65\154\x61\x73", "\154\145\146\x74"); goto Z6GHz; yKyIj: $this->db->order_by("\141\x2e\x6e\x61\155\141"); goto ST0w_; o8UbT: $this->db->query("\x53\105\x54\40\x53\121\x4c\137\102\111\x47\137\123\x45\114\x45\x43\x54\x53\x3d\61"); goto BVPpj; VLTIL: return $query->result(); goto C92v1; ST0w_: $query = $this->db->get(); goto VLTIL; Z6GHz: $this->db->order_by("\x62\x2e\x69\144\137\153\x65\154\141\163"); goto yKyIj; C92v1: } public function getSiswaByKelas($id_tp, $id_smt, $id_kelas) { goto WThjB; tP4dT: $this->db->where("\x61\56\151\144\137\x6b\145\154\141\163", $id_kelas); goto NIydm; cAaf3: $this->db->from("\x6b\x65\x6c\x61\x73\x5f\x73\151\x73\167\141\x20\x61"); goto GOL1P; MFeMH: return $this->db->get()->result(); goto tu12D; I641b: $this->db->where("\x61\x2e\x69\x64\x5f\x74\x70", $id_tp); goto WyVUu; WyVUu: $this->db->where("\141\x2e\151\x64\137\x73\155\164", $id_smt); goto BvgiZ; NIydm: $this->db->order_by("\142\x2e\156\141\x6d\x61", "\x41\123\103"); goto MFeMH; WThjB: $this->db->select("\x62\x2e\52"); goto cAaf3; pkhjP: $this->db->where("\142\56\151\x64\137\163\151\x73\x77\x61\x20\x69\x73\40\116\117\x54\40\x4e\x55\114\114", NULL, FALSE); goto tP4dT; BvgiZ: $this->db->where("\141\x2e\x69\144\137\x73\x69\163\167\x61\40\x69\x73\x20\x4e\117\x54\x20\116\125\x4c\x4c", NULL, FALSE); goto pkhjP; GOL1P: $this->db->join("\x6d\141\163\x74\x65\x72\137\x73\151\x73\167\x61\x20\x62", "\x62\56\151\144\x5f\x73\151\163\x77\x61\75\141\x2e\151\x64\137\163\x69\163\x77\x61"); goto I641b; tu12D: } public function getDataSiswa($id_tp, $id_smt) { goto YkyGB; YkyGB: $this->db->query("\123\105\x54\x20\123\x51\114\137\x42\111\107\137\123\105\x4c\x45\103\124\x53\75\61"); goto dENZC; A64zE: $this->datatables->join("\165\x73\145\x72\x73\x20\x63", "\141\56\165\x73\x65\162\156\x61\x6d\145\75\143\56\165\x73\145\x72\x6e\x61\x6d\145"); goto D21VS; cw92j: $this->datatables->from("\155\x61\x73\164\x65\x72\x5f\163\151\x73\167\x61\x20\141"); goto dRIqA; dRIqA: $this->datatables->join("\x62\x75\153\165\137\151\156\144\x75\x6b\x20\142", "\141\56\x69\144\137\x73\x69\163\x77\x61\75\x62\x2e\151\x64\137\163\x69\x73\167\x61", "\154\145\x66\164"); goto A64zE; BGNqq: $this->datatables->join("\155\x61\163\164\145\x72\x5f\153\x65\154\141\x73\x20\146", "\146\56\x69\144\137\153\x65\154\141\163\75\144\x2e\x69\144\x5f\x6b\145\154\x61\163", "\x6c\x65\146\x74"); goto wl9qa; wl9qa: $this->db->order_by("\111\123\x4e\x55\114\x4c\50\x66\x2e\x6c\145\166\x65\x6c\x5f\x69\144\x29\x2c\x20\x66\x2e\x6c\145\x76\145\x6c\x5f\151\x64\40\x41\x53\103"); goto F3e99; F3e99: $this->db->order_by("\146\x2e\156\x61\x6d\x61\137\153\x65\154\x61\x73", "\x41\123\103"); goto u6hXN; hBmcF: return $this->datatables->generate(); goto mPShe; u6hXN: $this->db->order_by("\x62\56\163\x74\141\x74\165\163", "\101\x53\103"); goto hBmcF; D21VS: $this->datatables->join("\153\x65\x6c\141\163\137\x73\x69\x73\x77\141\40\144", "\144\56\x69\x64\137\163\151\x73\x77\x61\40\75\40\141\x2e\151\144\137\163\x69\163\x77\141\x20\101\x4e\104\40\x64\x2e\151\144\x5f\164\x70\x20\75\40" . $id_tp . "\40\101\116\x44\40\144\x2e\x69\144\137\x73\155\x74\x20\x3d\40" . $id_smt . '', "\x6c\145\146\164"); goto BGNqq; dENZC: $this->datatables->select("\141\x2e\151\144\x5f\x73\x69\x73\167\141\54\x20\141\56\146\x6f\x74\x6f\54\x20\x61\56\156\141\155\141\54\40\141\56\156\151\163\x2c\x20\141\x2e\x6e\x69\163\x6e\54\x20\x61\56\152\145\x6e\151\163\x5f\x6b\145\x6c\x61\x6d\x69\x6e\54\x20\x66\56\154\x65\166\145\154\x5f\151\144\54\x20\146\x2e\x6e\x61\155\x61\x5f\x6b\x65\154\x61\x73\x2c\x20\142\x2e\x73\x74\141\164\x75\x73"); goto cw92j; mPShe: } public function getAllSiswa($id_tp, $id_smt, $offset, $limit, $search = null, $sort = null, $order = null) { goto Eo2gc; uxQg2: $this->db->join("\x6d\141\163\164\145\x72\137\x6b\x65\x6c\141\163\x20\x66", "\146\x2e\x69\144\137\x6b\145\x6c\141\x73\x3d\x64\x2e\151\144\137\153\x65\x6c\x61\x73", "\154\145\x66\x74"); goto swzW_; GG72J: $this->db->like("\141\56\x6e\x61\155\x61", $search); goto LW5WC; H3r1z: $this->db->from("\x6d\141\163\164\x65\162\137\163\151\163\167\141\40\141"); goto gsrqA; FCnuL: return $this->db->get()->result(); goto EYQIr; gsrqA: $this->db->limit($limit, $offset); goto uj8q7; tJCJM: $this->db->join("\x6b\145\154\141\163\137\x73\x69\x73\167\x61\x20\x64", "\144\x2e\x69\144\x5f\x73\151\163\167\141\x20\x3d\x20\141\56\x69\144\x5f\163\151\163\x77\x61\x20\101\x4e\x44\40\x64\x2e\x69\144\137\164\160\x20\x3d\40" . $id_tp . "\x20\101\x4e\x44\x20\144\x2e\x69\x64\x5f\x73\x6d\x74\x20\x3d\x20" . $id_smt . '', "\154\x65\x66\x74"); goto uxQg2; Eo2gc: $this->db->select("\141\x2e\151\x64\x5f\163\151\x73\x77\x61\54\40\x61\56\146\157\x74\157\54\x20\141\x2e\156\141\x6d\141\54\40\x61\x2e\x6e\x69\x73\54\40\x61\56\x6e\151\x73\x6e\x2c\x20\141\56\152\145\x6e\x69\x73\x5f\x6b\145\x6c\x61\155\151\x6e\x2c\40\146\x2e\x6c\x65\166\145\x6c\137\x69\x64\54\40\x66\x2e\x6e\141\155\x61\x5f\x6b\x65\154\x61\x73\x2c" . "\40\x28\123\x45\x4c\x45\x43\124\x20\x43\117\x55\116\124\50\x69\144\51\40\106\122\117\115\x20\x75\x73\x65\x72\x73\x20\127\110\x45\122\105\40\165\x73\145\162\x73\56\165\x73\145\x72\x6e\141\x6d\145\40\x3d\40\141\56\x75\163\x65\x72\156\141\155\x65\x29\40\x41\123\x20\x73\164\141\164\165\163"); goto H3r1z; uj8q7: $this->db->order_by("\x61\x2e\x6e\141\155\141", "\101\x53\x43"); goto tJCJM; hVpIa: qVCPC: goto FCnuL; ug0i3: $this->db->or_like("\141\56\156\151\x73\x6e", $search); goto hVpIa; LW5WC: $this->db->or_like("\x61\56\156\151\163", $search); goto ug0i3; swzW_: if (!($search != null)) { goto qVCPC; } goto GG72J; EYQIr: } public function getSiswaPage($id_tp, $id_smt, $offset, $limit, $search = null, $sort = null, $order = null) { goto JYWyr; IMWP7: $this->db->join("\x6d\141\x73\164\x65\162\x5f\x6b\x65\x6c\141\x73\40\x66", "\146\56\x69\144\137\x6b\145\154\141\163\75\144\x2e\151\144\x5f\x6b\x65\154\x61\x73", "\x6c\x65\x66\164"); goto DoEad; DkLTY: $this->db->or_like("\141\56\x6e\x69\x73", $search); goto FIfhD; lxQ6x: if (!($search != null)) { goto VQXTl; } goto p5sX9; pQpc9: $this->db->order_by("\x61\56\156\x61\155\x61", "\x41\123\103"); goto lxQ6x; JYWyr: $this->db->select("\x61\56\151\x64\x5f\163\151\163\167\141\x2c\40\x61\x2e\x66\157\x74\x6f\x2c\x20\141\x2e\x6e\x61\x6d\x61\x2c\40\141\56\x6e\151\163\54\x20\x61\56\156\151\x73\156\x2c\x20\x61\56\152\x65\156\151\163\x5f\x6b\x65\154\x61\155\x69\156\54\x20\x64\x2e\151\x64\137\153\145\154\141\x73\54\x20" . "\146\x2e\x6e\x61\x6d\x61\137\153\x65\154\141\163\54\x20\50\x53\105\x4c\x45\103\x54\x20\103\117\x55\x4e\x54\x28\151\144\x29\x20\106\122\117\x4d\40\165\x73\x65\162\x73\x20\127\x48\x45\122\105\x20\165\x73\145\x72\x73\56\x75\163\145\x72\x6e\x61\155\x65\x20\75\x20\141\56\x75\x73\145\162\156\141\155\145\51\x20\x41\x53\40\141\153\164\151\146"); goto begua; hAy2F: $this->db->join("\x6b\145\154\141\163\137\x73\x69\163\167\141\40\144", "\144\56\151\144\x5f\x73\151\x73\x77\x61\x3d\141\x2e\151\144\x5f\163\151\x73\x77\141\x20\101\x4e\x44\x20\x64\x2e\151\x64\x5f\x74\x70\x20\75\x20" . $id_tp . "\40\101\116\104\x20\x64\x2e\151\x64\137\163\x6d\164\x20\75\40" . $id_smt . '', "\154\x65\146\x74"); goto IMWP7; begua: $this->db->from("\x6d\141\x73\x74\x65\x72\137\163\151\x73\167\141\40\x61"); goto m0K0Q; oVkvH: $this->db->order_by("\x66\x2e\x6e\x61\155\141\137\153\x65\x6c\141\163", "\101\123\103"); goto pQpc9; DDMXS: return $this->db->get()->result(); goto ffU6z; FIfhD: $this->db->or_like("\141\x2e\x6e\x69\x73\156", $search); goto tIaeS; tIaeS: VQXTl: goto DDMXS; m0K0Q: $this->db->limit($limit, $offset); goto hAy2F; DoEad: $this->db->order_by("\111\123\116\x55\114\114\x28\146\x2e\x6c\x65\166\x65\x6c\137\151\144\x29\x2c\40\x66\x2e\154\x65\166\145\x6c\x5f\151\144\40\101\123\x43"); goto oVkvH; p5sX9: $this->db->like("\141\56\156\141\155\x61", $search); goto DkLTY; ffU6z: } public function getSiswaTotalPage($search = null) { goto t2YvJ; VVYSe: Bqhkb: goto jro_X; d8UAG: $this->db->like("\x6e\141\x6d\141", $search); goto wQrHM; t2YvJ: $this->db->select("\151\x64\137\163\151\x73\x77\141"); goto EesHW; fxSrb: $this->db->or_like("\156\151\x73\x6e", $search); goto VVYSe; wQrHM: $this->db->or_like("\x6e\151\163", $search); goto fxSrb; EesHW: $this->db->from("\155\141\x73\164\x65\162\137\163\x69\163\x77\x61"); goto mQMt5; jro_X: return $this->db->get()->num_rows(); goto HcvEV; mQMt5: if (!($search != null)) { goto Bqhkb; } goto d8UAG; HcvEV: } public function getDataSiswaByKelas($id_tp, $id_smt, $id_kelas, $offset, $limit, $search = null, $sort = null, $order = null) { goto Xd7Hj; CiSDT: $this->db->where("\141\x2e\x69\x64\137\x6b\x65\154\141\x73", $id_kelas); goto z4fgj; Oh4Fr: $this->db->where("\141\x2e\x69\x64\137\164\x70", $id_tp); goto LLZTI; Xd7Hj: $this->db->select("\x62\x2e\x69\x64\x5f\x73\151\x73\x77\x61\54\x20\x62\x2e\156\x61\155\141\54\40\x62\56\156\151\x73\54\x20\142\x2e\156\151\x73\156\54\40\142\56\152\x65\x6e\x69\163\x5f\x6b\x65\x6c\x61\x6d\151\x6e\54\x20\142\56\x75\163\x65\x72\156\141\x6d\145\x2c\x20\142\x2e\160\141\x73\x73\x77\157\162\144\54\40\142\56\x66\157\164\157\54" . "\x20\x66\x2e\156\x61\155\x61\137\x6b\145\154\141\x73\x2c\40\50\x53\x45\114\105\103\124\x20\103\x4f\x55\116\x54\50\151\144\x29\40\x46\x52\117\115\x20\165\163\x65\x72\x73\x20\x57\x48\x45\x52\105\40\x75\163\x65\162\x73\56\x75\163\x65\x72\x6e\141\x6d\x65\40\x3d\x20\142\x2e\165\x73\x65\162\x6e\141\155\145\x29\40\x41\123\40\x61\x6b\x74\151\x66"); goto YiNfe; ORk8R: $this->db->or_like("\x62\x2e\156\151\x73", $search); goto RU_0I; pEL2o: if (!($search != null)) { goto WPw_g; } goto gOxkN; Oz6OK: $this->db->limit($limit, $offset); goto XHZCH; RU_0I: $this->db->or_like("\x62\x2e\x6e\151\x73\x6e", $search); goto tqrrl; tqrrl: WPw_g: goto Oh4Fr; z4fgj: return $this->db->get()->result(); goto DTrV0; XHZCH: $this->db->join("\x6d\x61\x73\x74\145\x72\137\163\x69\163\x77\141\40\142", "\142\56\x69\x64\137\x73\151\x73\x77\141\x3d\x61\56\151\144\137\163\151\x73\x77\141"); goto UrViT; UrViT: $this->db->join("\155\141\163\164\x65\162\137\153\x65\x6c\141\163\x20\146", "\146\x2e\151\x64\x5f\x6b\145\154\x61\x73\x3d\x61\56\151\144\137\153\145\x6c\141\163"); goto pEL2o; YiNfe: $this->db->from("\x6b\x65\x6c\x61\163\x5f\x73\x69\163\x77\x61\x20\141"); goto Oz6OK; gOxkN: $this->db->like("\142\x2e\156\141\155\141", $search); goto ORk8R; LLZTI: $this->db->where("\x61\56\151\x64\x5f\163\155\x74", $id_smt); goto CiSDT; DTrV0: } public function getDataSiswaByKelasPage($id_tp, $id_smt, $id_kelas, $search = null) { goto xvcQj; HNwUf: vERVX: goto e3KlK; IOkvn: $this->db->like("\x62\x2e\x6e\x61\x6d\x61", $search); goto A9N6U; VNcQb: $this->db->join("\155\141\163\x74\145\x72\137\x73\151\163\167\x61\x20\x62", "\x62\56\151\x64\x5f\x73\x69\x73\x77\x61\75\x61\56\151\144\137\x73\151\163\167\141"); goto dMN8F; Y8DTU: $this->db->from("\x6b\145\154\x61\163\137\x73\x69\x73\x77\141\40\141"); goto hT9O4; dMN8F: if (!($search != null)) { goto vERVX; } goto IOkvn; Mu_Q_: $this->db->or_like("\142\x2e\156\151\x73\x6e", $search); goto HNwUf; hT9O4: $this->db->where("\x61\x2e\x69\144\x5f\164\160", $id_tp); goto K3sKc; A86E3: $this->db->where("\141\x2e\151\x64\x5f\x6b\145\154\x61\x73", $id_kelas); goto VNcQb; xvcQj: $this->db->select("\x61\56\151\144\x5f\x73\151\x73\x77\x61"); goto Y8DTU; A9N6U: $this->db->or_like("\142\x2e\x6e\151\163", $search); goto Mu_Q_; e3KlK: return $this->db->get()->num_rows(); goto tgxdj; K3sKc: $this->db->where("\141\56\x69\144\x5f\163\x6d\x74", $id_smt); goto A86E3; tgxdj: } public function getSiswaById($id) { goto PyYbg; Jndbr: $this->db->join("\142\x75\x6b\x75\x5f\151\156\x64\x75\153\x20\x62", "\x61\56\x69\144\137\x73\151\163\x77\x61\x3d\x62\x2e\x69\x64\x5f\x73\x69\163\x77\x61", "\x6c\x65\146\x74"); goto MMk_n; PyYbg: $this->db->select("\x61\x2e\x2a\54\40\x62\56\x73\x74\x61\x74\165\163"); goto ML13T; MMk_n: $this->db->where("\x61\x2e\151\x64\x5f\x73\x69\x73\167\x61", $id); goto LxvGg; LxvGg: return $this->db->get()->row(); goto oS3X7; ML13T: $this->db->from("\x6d\x61\163\x74\145\162\137\163\151\x73\167\x61\x20\141"); goto Jndbr; oS3X7: } public function getSiswaKelasBaru($id_tp, $id_smt) { goto rJlxR; SFI7d: foreach ($result as $key => $row) { $ret[$row->id_siswa] = $row; faUxu: } goto YRweU; HwJuJ: rPCQA: goto pA9IQ; TDbSZ: $this->db->join("\155\x61\x73\x74\x65\162\137\x73\151\x73\167\141\x20\142", "\142\x2e\151\144\x5f\x73\151\x73\167\141\x3d\x61\x2e\151\x64\x5f\163\151\163\167\x61"); goto GKH7C; Honrj: $this->db->where("\x61\x2e\x69\x64\x5f\x73\155\164", $id_smt); goto NYK08; NYK08: $result = $this->db->get()->result(); goto yMGMC; pA9IQ: return $ret; goto nL4Eq; qwIYl: $this->db->where("\141\x2e\x69\144\137\x74\x70", $id_tp); goto Honrj; EGYac: if (!$result) { goto rPCQA; } goto SFI7d; yMGMC: $ret = []; goto EGYac; fHKR3: $this->db->from("\x6b\145\154\141\163\x5f\163\x69\x73\167\141\40\x61"); goto TDbSZ; YRweU: hIP3G: goto HwJuJ; rJlxR: $this->db->query("\123\x45\x54\40\x53\121\x4c\x5f\102\x49\107\137\123\x45\x4c\105\x43\x54\123\75\61"); goto bklVw; bklVw: $this->db->select("\142\56\151\x64\137\x73\151\x73\x77\141\54\40\x62\56\x6e\x61\155\x61\x2c\x20\x66\56\x69\x64\x5f\x6b\x65\154\x61\163\54\x20\146\56\156\x61\155\141\x5f\x6b\145\154\141\x73\54\40\146\56\x6b\157\144\145\137\153\145\154\141\163"); goto fHKR3; GKH7C: $this->db->join("\x6d\141\x73\164\145\162\137\x6b\x65\154\x61\163\40\146", "\x66\56\151\144\x5f\x6b\145\154\x61\163\75\141\56\x69\x64\137\153\145\x6c\x61\163"); goto qwIYl; nL4Eq: } public function getDataSiswaById($id_tp, $id_smt, $idSiswa) { goto XxCJ8; C3Um_: $this->db->join("\x63\142\x74\x5f\x73\145\x73\x69\137\x73\x69\163\x77\x61\x20\143", "\x63\x2e\163\x69\x73\x77\141\137\151\144\75\x61\56\x69\x64\137\163\151\163\167\x61", "\154\x65\x66\164"); goto fzN3b; bOYOy: $this->db->join("\x6d\x61\163\x74\145\162\137\x6b\x65\x6c\x61\x73\x20\146", "\x66\x2e\151\x64\x5f\153\x65\x6c\x61\x73\75\x61\56\x69\144\137\153\145\154\141\x73", "\154\145\x66\x74"); goto vFZ_F; fzN3b: $this->db->join("\x63\x62\164\x5f\162\165\141\156\x67\40\x64", "\x64\x2e\x69\x64\x5f\x72\165\x61\x6e\147\x3d\x63\x2e\162\165\x61\x6e\147\x5f\x69\x64", "\154\x65\146\164"); goto sJ_9Y; hxBQi: $this->db->join("\x63\142\164\137\x73\x65\x73\x69\40\152", "\152\x2e\151\x64\137\163\145\163\x69\75\x68\x2e\151\x64\x5f\163\x65\163\x69", "\154\x65\146\x74"); goto eqGOb; vFZ_F: $this->db->join("\143\x62\x74\x5f\x6e\157\155\157\162\137\160\145\x73\x65\x72\164\x61\40\147", "\147\56\x69\x64\x5f\x73\x69\163\x77\x61\75\x61\x2e\x69\144\137\x73\151\x73\167\x61\x20\101\116\104\x20\147\x2e\151\144\x5f\164\x70\x3d" . $id_tp, "\x6c\145\146\164"); goto qTmG4; sJ_9Y: $this->db->join("\x63\x62\164\137\x73\145\163\151\x20\145", "\145\56\151\144\137\x73\x65\x73\151\x3d\x63\x2e\x73\145\163\x69\x5f\x69\x64", "\x6c\x65\x66\164"); goto bOYOy; ihYym: return $this->db->get()->row(); goto Evytt; eSfs9: $this->db->join("\x63\142\x74\x5f\x72\x75\141\156\x67\x20\x69", "\x69\x2e\151\x64\137\x72\x75\141\x6e\147\x3d\150\x2e\x69\x64\137\162\x75\141\x6e\147", "\x6c\145\146\x74"); goto hxBQi; sOWY_: $this->db->where("\141\56\151\x64\x5f\163\151\163\167\141", $idSiswa); goto ihYym; GSX2C: $this->db->join("\155\141\163\164\x65\x72\x5f\163\151\163\167\141\x20\x62", "\x62\x2e\x69\x64\137\163\x69\x73\167\x61\75\x61\56\x69\x64\137\163\x69\x73\x77\141", "\154\145\146\x74"); goto C3Um_; eqGOb: $this->db->where("\141\56\151\144\x5f\164\160", $id_tp); goto T6o_2; qTmG4: $this->db->join("\143\x62\164\137\x6b\145\154\141\x73\x5f\162\165\x61\156\147\x20\x68", "\150\56\x69\144\x5f\x6b\x65\154\x61\x73\x3d\141\x2e\151\x64\x5f\153\145\154\x61\x73", "\x6c\145\x66\x74"); goto eSfs9; yrIM9: $this->db->from("\153\x65\x6c\141\x73\x5f\x73\151\x73\167\x61\x20\141"); goto GSX2C; T6o_2: $this->db->where("\141\56\x69\x64\x5f\163\155\x74", $id_smt); goto sOWY_; e_zyA: $this->db->select("\142\56\151\144\x5f\x73\x69\x73\167\141\54\x20\142\x2e\156\x61\x6d\x61\54\40\142\56\152\x65\x6e\x69\163\x5f\153\x65\154\141\155\x69\x6e\x2c\x20\142\56\156\x69\x73\54\x20\142\x2e\x6e\151\163\156\54\x20\x62\56\165\163\x65\x72\156\141\155\145\x2c\x20\142\x2e\x70\x61\x73\x73\167\157\x72\x64\54" . "\x20\x62\x2e\146\x6f\164\157\x2c\x20\143\x2e\163\145\163\x69\137\x69\144\x2c\x20\144\x2e\153\x6f\144\145\137\x72\x75\x61\x6e\x67\x2c\40\145\56\153\x6f\144\x65\137\163\145\163\x69\x2c\x20\146\x2e\156\141\155\x61\x5f\153\145\x6c\141\x73\54\40\147\x2e\x6e\157\155\157\162\137\160\x65\x73\x65\x72\164\141\54" . "\x20\x68\x2e\163\145\x74\137\163\x69\163\167\141\x2c\x20\x69\56\x6b\x6f\x64\x65\137\x72\165\141\156\x67\40\141\163\40\x72\165\x61\156\x67\137\x6b\145\154\x61\163\54\x20\x6a\x2e\153\157\x64\x65\x5f\163\145\x73\151\40\x61\163\x20\163\x65\163\151\x5f\153\145\x6c\141\163"); goto yrIM9; XxCJ8: $this->db->query("\x53\105\124\40\123\121\114\137\102\111\107\x5f\123\105\114\105\x43\x54\x53\75\x31"); goto e_zyA; Evytt: } public function getAgamaSiswa() { goto v1i2D; iN285: $result = $this->db->get()->result(); goto dS5jF; pbCiw: M6Prv: goto dXxaZ; v1i2D: $this->db->select("\x61\147\141\x6d\141"); goto IcAKM; IcAKM: $this->db->distinct(); goto yigEM; dXxaZ: return $ret; goto t3DF4; dS5jF: $ret["\55"] = "\102\x75\153\x61\156\x20\x4d\x61\160\145\x6c\40\x41\147\x61\155\x61"; goto JONw_; JONw_: foreach ($result as $row) { $ret[$row->agama] = $row->agama; PmDAI: } goto pbCiw; Rg0H_: $this->db->where("\x61\56\141\147\x61\155\141\40\41\x3d\x20\42\x30\x22", NULL, FALSE); goto wMQm6; AJa1O: $this->db->where("\141\x2e\141\x67\x61\155\141\40\x69\163\x20\116\x4f\124\40\116\x55\114\114", NULL, FALSE); goto Rg0H_; wMQm6: $this->db->not_like("\x61\56\141\x67\141\155\141", "\120\151\x6c\x69\x68"); goto iN285; yigEM: $this->db->from("\x6d\x61\163\x74\x65\x72\x5f\x73\151\x73\167\141\40\x61"); goto AJa1O; t3DF4: } public function getJurusan() { goto EUBZA; phsAr: $this->db->order_by("\156\141\x6d\141\137\152\x75\162\x75\163\x61\156", "\101\x53\103"); goto HRkUF; hntCW: return $query->result(); goto yDmMn; W3dXz: $query = $this->db->get(); goto hntCW; fmkcQ: $this->db->from("\x6d\x61\163\164\x65\x72\x5f\153\145\154\x61\163"); goto XUXaW; XUXaW: $this->db->join("\155\x61\x73\164\x65\162\x5f\x6a\165\162\x75\163\141\156", "\152\x75\x72\x75\x73\141\156\137\151\144\x3d\151\x64\137\x6a\165\162\165\163\141\x6e"); goto phsAr; EUBZA: $this->db->select("\151\144\x5f\x6a\165\x72\165\x73\141\x6e\54\40\x6e\x61\155\x61\x5f\152\x75\162\x75\163\141\156"); goto fmkcQ; HRkUF: $this->db->group_by("\x69\144\137\152\x75\162\165\163\x61\156"); goto W3dXz; yDmMn: } public function getAllJurusan($id = null) { goto REAlq; D5kHl: D8FYp: goto InwBe; kmEmV: $id_jurusan = []; goto lmcRL; lmcRL: foreach ($jurusan as $j) { $id_jurusan[] = $j->jurusan_id; Bfo4x: } goto amGPe; C0ATL: goto EjoPS; goto XnOB_; N738f: EjoPS: goto WNfxy; XnOB_: ei_dA: goto uT_rs; uT_rs: $this->db->order_by("\156\141\x6d\141\x5f\x6a\x75\x72\165\x73\141\x6e", "\101\123\103"); goto MvdSi; ZPLWh: $id_jurusan = null; goto D5kHl; mUlwQ: return $mapel; goto C0ATL; sKRs6: $this->db->select("\152\x75\x72\165\x73\141\x6e\x5f\151\x64"); goto KrVHj; sYCfh: if (!($id_jurusan === [])) { goto D8FYp; } goto ZPLWh; HxKEY: $this->db->where_not_in("\151\x64\137\x6a\165\x72\x75\163\141\x6e", $id_jurusan); goto KUjmx; REAlq: if ($id === null) { goto ei_dA; } goto sKRs6; LjnIU: $jurusan = $this->db->get()->result(); goto kmEmV; KUjmx: $mapel = $this->db->get()->result(); goto mUlwQ; l_72r: $this->db->where("\x6d\141\160\145\154\x5f\151\x64", $id); goto LjnIU; InwBe: $this->db->select("\52"); goto BuZXZ; amGPe: ctS2t: goto sYCfh; KrVHj: $this->db->from("\152\165\162\x75\163\141\x6e\x5f\x6d\141\x70\x65\154"); goto l_72r; BuZXZ: $this->db->from("\155\141\163\x74\x65\x72\x5f\152\x75\162\x75\x73\141\x6e"); goto HxKEY; MvdSi: return $this->db->get("\152\x75\x72\x75\x73\x61\156")->result(); goto N738f; WNfxy: } public function getKelasByJurusan($id) { $query = $this->db->get_where("\155\141\163\x74\x65\x72\137\153\x65\154\x61\x73", array("\152\165\x72\x75\x73\x61\156\x5f\x69\x64" => $id)); return $query->result(); } public function getDataGuru($tp, $smt) { goto F8VfW; F8VfW: $this->db->query("\123\x45\124\40\123\x51\x4c\137\x42\111\x47\137\x53\x45\x4c\x45\103\124\x53\75\61"); goto FEGcm; Em16C: $this->datatables->join("\155\141\163\x74\x65\162\137\163\155\164\x20\146", "\x62\x2e\x69\x64\x5f\163\155\x74\75\146\x2e\151\x64\137\163\x6d\164", "\x6c\x65\x66\164"); goto iO4f1; GKMn6: $this->datatables->join("\x6d\x61\x73\164\145\x72\137\x74\160\x20\x65", "\142\56\x69\x64\x5f\164\x70\x3d\x65\x2e\151\x64\137\164\160", "\x6c\x65\x66\164"); goto Em16C; FEGcm: $this->datatables->select("\141\x2e\x69\x64\137\147\165\162\x75\x2c\40\x61\x2e\156\141\155\x61\137\147\165\x72\165\x2c\40\x61\56\x6e\151\160\54\x20\x61\x2e\153\x6f\144\x65\137\x67\x75\162\x75\x2c\40\x61\56\152\145\156\151\163\137\153\145\154\141\155\151\x6e\54\x20\x61\x2e\146\x6f\x74\x6f\54\40\142\56\x69\x64\137\152\x61\142\141\x74\141\x6e\x2c\40\x62\x2e\151\144\x5f\153\145\154\x61\x73\54\40\142\x2e\155\x61\x70\145\154\x5f\x6b\145\154\x61\163\54\x20\143\56\x69\144\137\154\x65\x76\x65\154\54\x20\x63\x2e\154\x65\166\x65\x6c\54\40\144\56\156\141\x6d\x61\137\153\x65\154\x61\x73\54\40\145\56\x74\141\x68\x75\x6e\x2c\x20\146\56\156\141\155\141\x5f\163\x6d\x74"); goto Ewwqi; Ewwqi: $this->datatables->from("\x6d\141\x73\164\145\162\x5f\x67\x75\x72\165\x20\x61"); goto x6e0e; x6e0e: $this->datatables->join("\152\141\x62\141\164\x61\156\137\147\165\x72\x75\40\x62", "\x61\56\x69\144\x5f\147\x75\x72\165\75\142\x2e\151\144\x5f\147\165\162\x75\x20\101\x4e\104\40\x62\x2e\x69\144\x5f\x74\x70\75" . $tp . "\x20\x41\x4e\x44\x20\x62\56\x69\144\137\163\x6d\164\75" . $smt . '', "\154\x65\x66\164"); goto wOHs1; iO4f1: return $this->datatables->generate(); goto Izn29; wOHs1: $this->datatables->join("\154\145\166\x65\x6c\x5f\147\x75\x72\165\x20\143", "\142\x2e\x69\x64\137\152\x61\142\x61\x74\x61\x6e\x3d\x63\56\151\144\x5f\x6c\x65\166\x65\x6c", "\154\145\146\164"); goto uxgyG; uxgyG: $this->datatables->join("\155\141\x73\x74\x65\x72\137\153\145\x6c\141\163\40\x64", "\x62\x2e\151\x64\137\x6b\x65\x6c\x61\163\x3d\x64\56\151\144\x5f\153\x65\154\x61\163\x20\x41\116\104\x20\144\x2e\x69\144\x5f\x74\x70\x3d" . $tp . "\x20\x41\x4e\104\40\x64\56\x69\144\x5f\x73\x6d\164\x3d" . $smt . '', "\154\x65\146\164"); goto GKMn6; Izn29: } public function getAllDataGuru($tp, $smt) { goto Dw1Ke; te2tq: $this->db->order_by("\x63\x2e\x69\x64\x5f\154\x65\x76\145\154", "\x64\x65\163\143"); goto Gd7eX; N0HUx: $this->db->select("\x61\56\151\144\x5f\147\165\x72\x75\54\40\x61\56\156\x61\x6d\141\x5f\147\165\162\165\54\x20\x61\x2e\156\151\x70\x2c\x20\141\x2e\x6b\x6f\144\x65\x5f\x67\x75\x72\x75\54\40\141\56\152\x65\x6e\151\163\137\153\145\x6c\141\155\151\x6e\x2c\40\141\x2e\x66\x6f\x74\157\54\40\x62\x2e\x69\x64\x5f\152\x61\142\x61\x74\141\156\54\x20\142\x2e\151\x64\137\x6b\x65\x6c\x61\163\x2c\x20\142\x2e\155\141\x70\x65\154\137\153\x65\154\141\163\x2c\x20\142\56\145\153\163\164\162\141\x5f\x6b\x65\x6c\141\x73\x2c\40\143\x2e\x69\x64\x5f\154\x65\166\x65\154\54\40\143\56\x6c\145\166\x65\x6c\54\40\x64\x2e\156\x61\155\x61\x5f\153\145\x6c\141\163\54\40\145\56\x74\x61\150\165\x6e\54\x20\x66\x2e\156\x61\155\141\137\x73\155\164\54\40\50\123\x45\x4c\105\103\x54\40\x43\x4f\x55\x4e\x54\x28\x69\144\x29\40\x46\122\x4f\x4d\40\165\x73\x65\x72\163\x20\x65\x20\x57\110\x45\x52\105\x20\x65\56\x75\163\x65\162\156\x61\x6d\x65\x20\x3d\40\141\56\x75\163\145\162\156\x61\x6d\145\x29\x20\x41\x53\40\163\x74\141\164\x75\x73"); goto dAFyj; NhiNY: $this->db->join("\155\141\x73\164\x65\162\137\153\x65\154\141\163\x20\144", "\142\x2e\x69\144\137\x6b\x65\154\141\163\75\x64\56\x69\144\137\153\145\154\x61\163\x20\101\x4e\104\x20\144\x2e\x69\x64\137\x74\160\75" . $tp . "\x20\101\116\x44\40\144\56\151\x64\137\x73\155\x74\75" . $smt . '', "\x6c\145\x66\x74"); goto kU20u; dAFyj: $this->db->from("\x6d\141\x73\x74\145\x72\x5f\x67\165\x72\x75\x20\141"); goto ZRsv0; ZRsv0: $this->db->join("\x6a\x61\x62\141\x74\141\x6e\x5f\147\x75\162\x75\40\x62", "\141\x2e\x69\144\x5f\x67\x75\x72\x75\75\x62\56\151\144\137\x67\165\162\x75\x20\101\x4e\104\40\x62\56\x69\144\x5f\x74\160\x3d" . $tp . "\x20\101\116\104\x20\x62\x2e\151\144\137\163\155\x74\75" . $smt . '', "\154\145\146\x74"); goto fQPH8; Gd7eX: $this->db->order_by("\141\56\x69\144\x5f\x67\165\x72\165", "\141\163\143"); goto IsAIb; tAhsx: $this->db->join("\155\141\x73\164\145\x72\x5f\x73\155\x74\x20\x66", "\142\x2e\x69\144\x5f\x73\x6d\164\75\146\56\151\x64\137\x73\155\164", "\x6c\145\146\164"); goto te2tq; kU20u: $this->db->join("\x6d\x61\x73\164\145\x72\137\164\x70\40\145", "\x62\x2e\x69\144\137\164\160\x3d\x65\x2e\x69\x64\137\x74\x70", "\x6c\x65\x66\x74"); goto tAhsx; fQPH8: $this->db->join("\154\145\166\x65\154\137\147\x75\162\165\x20\143", "\x62\x2e\x69\144\137\152\x61\x62\x61\x74\x61\x6e\x3d\143\x2e\151\144\137\154\145\166\x65\154", "\154\x65\146\x74"); goto NhiNY; IsAIb: return $this->db->get()->result(); goto hCGqu; Dw1Ke: $this->db->query("\123\x45\x54\x20\123\x51\114\x5f\102\111\x47\137\x53\105\114\105\103\x54\x53\75\x31"); goto N0HUx; hCGqu: } public function getGuruById($id, $id_tp = null, $id_smt = null) { goto CBLBr; l56wL: $this->db->join("\154\x65\x76\x65\154\x5f\x67\x75\x72\x75\x20\143", "\142\56\x69\144\x5f\152\141\x62\x61\164\x61\156\x3d\x63\x2e\x69\144\137\x6c\x65\x76\x65\154", "\x6c\145\x66\164"); goto D4N60; D4N60: if (!($id_tp != null && $id_smt != null)) { goto bpTg5; } goto qpj1z; lIXsn: $this->db->from("\155\x61\163\164\x65\x72\137\147\165\x72\165\40\x61"); goto zuGjA; CBLBr: $this->db->query("\123\105\124\x20\x53\x51\x4c\x5f\102\x49\x47\x5f\x53\x45\114\105\103\124\123\x3d\x31"); goto e4Z_l; oQaLO: return $this->db->get()->row(); goto QBxFk; qpj1z: $this->db->join("\155\x61\x73\164\145\162\137\153\x65\154\141\163\40\x64", "\141\56\x69\144\x5f\147\165\x72\x75\x3d\x64\56\147\165\162\165\x5f\x69\144\x20\x41\116\104\x20\x64\x2e\151\x64\137\x74\x70\75" . $id_tp . "\40\x41\116\104\x20\x64\56\x69\144\137\163\155\x74\75" . $id_smt, "\154\145\x66\164"); goto pyH9O; pyH9O: bpTg5: goto IWjQ4; IWjQ4: $this->db->where("\x61\56\x69\144\x5f\147\x75\x72\x75", $id); goto oQaLO; e4Z_l: $this->db->select("\52"); goto lIXsn; zuGjA: $this->db->join("\152\141\142\x61\164\x61\x6e\x5f\147\x75\x72\x75\x20\x62", "\x61\56\x69\x64\137\147\165\162\165\x3d\142\56\x69\144\137\x67\x75\162\165", "\x6c\145\x66\x74"); goto l56wL; QBxFk: } public function getGuruByArrId($arr_id) { goto ZrdV1; VOqD8: return $this->db->get()->result(); goto f0era; A8kMZ: if (!(count($arr_id) > 0)) { goto fJ4OA; } goto U9MOH; ZrdV1: $this->db->select("\x6e\x61\x6d\141\x5f\147\x75\x72\x75"); goto NEiRs; IrHOK: fJ4OA: goto VOqD8; NEiRs: $this->db->from("\x6d\x61\x73\x74\145\x72\137\x67\x75\x72\165"); goto A8kMZ; U9MOH: $this->db->where_in("\151\144\x5f\147\165\x72\x75", $arr_id); goto IrHOK; f0era: } public function getUserIdGuruByUsername($username) { goto J8op0; J8op0: $this->db->query("\x53\105\x54\x20\x53\121\x4c\x5f\102\111\x47\137\x53\105\x4c\105\x43\x54\123\x3d\61"); goto SZL4R; FA3VN: $this->db->join("\154\x65\x76\145\x6c\137\147\165\162\165\x20\143", "\142\x2e\x69\144\137\x6a\141\x62\141\164\x61\x6e\75\143\x2e\x69\x64\137\154\x65\x76\145\x6c", "\x6c\x65\146\x74"); goto AEWAz; AEWAz: $this->db->where("\x61\x2e\165\163\x65\x72\x6e\x61\155\x65", $username); goto eSdtY; Dv1M2: $this->db->from("\155\141\x73\164\145\x72\x5f\x67\x75\x72\x75\40\x61"); goto JT6tW; eSdtY: return $this->db->get()->row(); goto AlXN4; JT6tW: $this->db->join("\152\x61\x62\141\164\141\156\137\147\x75\162\165\40\x62", "\x61\56\151\x64\x5f\x67\165\x72\165\x3d\x62\56\151\x64\x5f\147\165\162\165", "\x6c\145\x66\x74"); goto FA3VN; SZL4R: $this->db->select("\52"); goto Dv1M2; AlXN4: } public function getDetailJabatanGuru($id_guru) { goto K0DgN; KB3oD: lemC2: goto cQxke; cQxke: return $ret; goto KidHA; hoE_w: $ret = []; goto lQdai; lQdai: foreach ($result as $row) { $ret[$row->id_tp][$row->id_smt] = $row; MpIWw: } goto KB3oD; KEsku: $result = $this->db->get()->result(); goto hoE_w; K0DgN: $this->db->query("\123\x45\x54\40\x53\121\x4c\x5f\102\x49\107\137\x53\105\114\x45\x43\x54\123\75\x31"); goto RAlTe; fDWKF: $this->db->from("\x6d\x61\163\x74\145\x72\137\147\x75\162\165\x20\141"); goto pqeHC; Ajoup: $this->db->join("\155\x61\163\164\145\162\137\x6b\145\154\x61\163\40\x64", "\x62\x2e\x69\144\137\153\x65\x6c\141\163\x3d\144\x2e\x69\x64\x5f\x6b\145\x6c\x61\x73", "\x6c\x65\x66\x74"); goto Q_gO4; W9bg3: $this->db->join("\x6c\145\166\x65\154\137\147\x75\x72\x75\x20\143", "\142\x2e\151\x64\x5f\x6a\x61\x62\x61\164\x61\156\x3d\x63\x2e\151\144\137\154\145\x76\x65\x6c", "\x6c\x65\146\164"); goto Ajoup; RAlTe: $this->db->select("\x61\x2e\x69\x64\x5f\x67\165\162\165\x2c\40\141\56\x6e\x61\155\141\137\147\165\162\x75\x2c\40\142\x2e\x69\144\137\x74\x70\54\x20\142\x2e\151\144\137\x73\155\164\x2c\x20\142\56\x6d\141\x70\x65\x6c\137\153\x65\x6c\141\x73\54\40\x62\56\x65\x6b\x73\164\162\x61\x5f\x6b\145\154\x61\x73\54\40\x63\56\x69\x64\x5f\154\x65\x76\x65\x6c\54\x20\143\x2e\x6c\x65\x76\145\x6c\x2c\40\x64\56\151\144\137\153\x65\x6c\x61\x73\54\40\x64\56\156\141\155\141\x5f\153\145\x6c\x61\x73"); goto fDWKF; pqeHC: $this->db->join("\x6a\x61\x62\141\164\x61\x6e\137\x67\x75\x72\x75\40\x62", "\x61\56\151\144\x5f\x67\165\x72\165\75\x62\56\x69\144\x5f\x67\x75\162\x75", "\x6c\145\x66\164"); goto W9bg3; Q_gO4: $this->db->where("\x61\x2e\151\x64\x5f\147\165\162\165", $id_guru); goto KEsku; KidHA: } public function getJabatanGuru($id_guru, $tp, $smt) { goto COO1s; aHR0e: $this->db->join("\x6d\x61\x73\x74\x65\x72\137\x6b\145\x6c\141\x73\x20\144", "\x62\x2e\151\x64\137\x6b\145\154\141\x73\75\x64\x2e\151\144\x5f\153\145\x6c\141\163\40\101\x4e\104\x20\144\56\x69\144\137\164\160\x3d" . $tp . "\40\101\116\x44\40\144\x2e\151\144\137\x73\155\164\75" . $smt . '', "\x6c\145\x66\164"); goto HZB2G; HZB2G: $this->db->where("\x61\56\x69\x64\x5f\x67\x75\162\x75", $id_guru); goto CIlcP; COO1s: $this->db->query("\123\x45\124\x20\x53\x51\114\x5f\102\111\x47\x5f\123\105\114\105\103\x54\123\x3d\x31"); goto WVIPa; b095T: $this->db->join("\x6a\141\x62\141\164\x61\x6e\x5f\147\x75\162\165\40\x62", "\x61\56\x69\144\x5f\147\165\162\x75\x3d\142\x2e\151\144\x5f\147\x75\162\x75\x20\x41\x4e\x44\40\x62\56\x69\144\x5f\164\160\x3d" . $tp . "\40\101\116\x44\x20\142\x2e\x69\144\x5f\x73\x6d\164\x3d" . $smt . '', "\x6c\x65\146\x74"); goto ojSMa; btZe1: return $query; goto wMyRZ; ojSMa: $this->db->join("\154\145\166\x65\154\x5f\x67\165\162\165\40\143", "\x62\56\x69\x64\137\x6a\x61\142\x61\164\141\x6e\x3d\143\56\151\x64\137\x6c\x65\x76\x65\154", "\154\x65\x66\x74"); goto aHR0e; WVIPa: $this->db->select("\x61\56\x69\144\x5f\147\x75\162\x75\54\x20\x61\56\x6e\141\x6d\x61\x5f\147\165\x72\x75\54\40\142\56\155\141\x70\145\154\137\x6b\x65\154\x61\163\x2c\x20\142\56\x65\153\163\164\162\x61\x5f\x6b\x65\x6c\141\x73\54\40\x63\x2e\x69\144\137\x6c\x65\166\145\154\54\40\143\x2e\x6c\x65\x76\x65\x6c\x2c\x20\x64\56\x69\144\x5f\x6b\x65\x6c\x61\x73\x2c\x20\144\56\156\x61\155\141\137\153\x65\x6c\x61\163"); goto PibLK; PibLK: $this->db->from("\x6d\141\x73\164\145\x72\x5f\x67\165\162\x75\40\141"); goto b095T; CIlcP: $query = $this->db->get()->row(); goto btZe1; wMyRZ: } public function getGuruMapel($tp, $smt) { goto fk4dX; waUML: $this->db->from("\x6a\x61\142\x61\164\141\x6e\x5f\x67\x75\162\165\x20\x61"); goto Sc1X0; ytVEj: $this->db->where("\x61\x2e\151\144\137\164\160", $tp); goto gwVeo; kTy8N: return $query; goto LJN2l; fk4dX: $this->db->select("\141\x2e\155\141\x70\x65\154\137\x6b\x65\154\x61\x73\x2c\x20\141\x2e\x65\x6b\163\x74\x72\141\137\x6b\x65\x6c\x61\x73\54\40\141\56\x69\144\137\152\x61\x62\x61\164\141\x6e\54\40\141\x2e\x69\144\x5f\153\x65\x6c\141\163\54\40\x62\56\x69\144\137\x67\x75\162\x75\54\40\142\x2e\x6e\141\x6d\x61\137\x67\x75\162\165"); goto waUML; gAMhd: $query = $this->db->get()->result(); goto kTy8N; Sc1X0: $this->db->join("\155\x61\x73\164\145\162\137\x67\x75\x72\x75\x20\142", "\141\56\151\144\137\x67\165\162\165\x3d\142\x2e\151\x64\x5f\147\165\x72\x75"); goto ytVEj; gwVeo: $this->db->where("\x61\56\151\144\137\163\155\164", $smt); goto gAMhd; LJN2l: } public function getKodeKelompokMapel() { goto dxZ9t; dxZ9t: $this->db->select("\52"); goto Zb8vq; jeYp6: $ret = []; goto uldjV; kLTsj: return $ret; goto uBAFj; Zb8vq: $this->db->from("\155\x61\x73\164\x65\x72\137\153\145\154\157\155\x70\157\153\x5f\155\141\160\x65\x6c"); goto UUGOA; uldjV: foreach ($result as $row) { $ret[$row->kode_kel_mapel] = $row; HpZ71: } goto Ipk4u; q3ibn: $result = $this->db->get()->result(); goto jeYp6; Ipk4u: UGh4r: goto kLTsj; UUGOA: $this->db->order_by("\x6b\x6f\x64\x65\137\153\145\154\x5f\155\141\x70\145\154"); goto q3ibn; uBAFj: } public function getDataKelompokMapel() { goto UMuFw; inHnJ: $ret = []; goto n40bZ; V_pSv: return $ret; goto ZIKQ0; bFR_R: $this->db->where("\x69\x64\x5f\x70\x61\162\145\156\x74", "\60"); goto aQLvQ; UMuFw: $this->db->select("\52"); goto zfZq_; RHeql: $result = $this->db->get()->result(); goto inHnJ; zfZq_: $this->db->from("\155\141\163\164\x65\x72\x5f\x6b\x65\154\157\x6d\160\157\x6b\137\x6d\141\160\145\x6c"); goto bFR_R; n40bZ: foreach ($result as $row) { $ret[$row->id_kel_mapel] = $row; nJJm2: } goto uKj_1; uKj_1: qXoiC: goto V_pSv; aQLvQ: $this->db->order_by("\x6b\157\144\x65\137\x6b\145\x6c\137\155\141\160\145\x6c"); goto RHeql; ZIKQ0: } public function getKategoriKelompokMapel() { goto NgSzn; ULAvs: $result = $this->db->get()->result(); goto tBOXM; zuCpo: $this->db->from("\x6d\141\163\x74\145\x72\137\x6b\145\154\x6f\x6d\x70\x6f\x6b\x5f\x6d\141\160\x65\x6c"); goto ULAvs; NgSzn: $this->db->select("\x6b\x6f\144\145\x5f\153\145\x6c\137\x6d\x61\x70\145\x6c\54\40\153\x61\164\x65\147\x6f\162\151"); goto SnIEf; SnIEf: $this->db->where("\x6b\141\164\145\x67\157\162\151", "\127\101\112\x49\102")->or_where("\x6b\141\164\x65\x67\x6f\162\151", "\120\101\x49\x20\50\113\145\155\x65\156\141\147\51"); goto zuCpo; tBOXM: return $result; goto bo7qL; bo7qL: } public function getDataSubKelompokMapel() { goto CFJ2Z; QYM3M: $this->db->where("\151\x64\x5f\160\141\x72\145\x6e\x74\40\x3c\x3e\40\60"); goto vGHeY; kp5lL: $this->db->from("\x6d\141\x73\x74\145\162\x5f\x6b\x65\154\x6f\x6d\160\x6f\x6b\x5f\x6d\141\x70\x65\154"); goto QYM3M; vGHeY: $this->db->order_by("\x6b\x6f\x64\x65\137\153\x65\154\137\x6d\x61\x70\x65\x6c"); goto YjBlK; CFJ2Z: $this->db->select("\52"); goto kp5lL; YjBlK: $result = $this->db->get()->result(); goto VeJWH; gYCvj: h1853: goto TiRP_; VeJWH: $ret = []; goto yAU04; TiRP_: return $ret; goto SqY2M; yAU04: foreach ($result as $row) { $ret[$row->id_kel_mapel] = $row; nTg_L: } goto gYCvj; SqY2M: } public function getDataMapel() { goto On0mw; YHYAX: $this->datatables->from("\155\141\163\x74\x65\x72\137\155\x61\160\145\154"); goto ZJDf4; ZJDf4: return $this->datatables->generate(); goto gj9a3; On0mw: $this->datatables->select("\151\144\x5f\x6d\x61\160\x65\x6c\54\40\156\x61\155\x61\137\155\141\160\145\154\54\x20\153\157\144\x65"); goto YHYAX; gj9a3: } public function getAllMapel($arrKelompok = null, $arrMapel = null) { goto Y3V_V; ImsGA: $this->db->where("\x73\164\141\164\x75\x73", "\61"); goto HNh_x; NG2iR: return $this->db->get("\x6d\141\163\164\145\x72\137\155\141\160\145\154")->result(); goto oedyf; Y3V_V: if (!($arrMapel != null)) { goto B1NTQ; } goto tqWFY; tqWFY: $this->db->where_in("\x6b\x65\x6c\157\155\x70\157\153", $arrKelompok); goto Wcs2k; Y3xCh: CM5gD: goto ImsGA; HNh_x: $this->db->order_by("\x75\x72\x75\x74\141\x6e\137\164\x61\x6d\x70\151\x6c"); goto NG2iR; kjrXP: if (!($arrMapel != null)) { goto CM5gD; } goto scIdd; scIdd: $this->db->or_where_in("\151\144\137\x6d\141\x70\145\154", explode("\x2c", $arrMapel)); goto Y3xCh; Wcs2k: B1NTQ: goto kjrXP; oedyf: } public function getAllStatusMapel($arrKelompok = null, $arrMapel = null) { goto jyfaP; jyfaP: if (!($arrMapel != null)) { goto WLZCN; } goto wOsNL; wOsNL: $this->db->where_in("\x6b\145\154\157\x6d\x70\x6f\153", $arrKelompok); goto GbdZu; VEYJ8: $this->db->or_where_in("\151\x64\137\155\x61\160\x65\x6c", explode("\54", $arrMapel)); goto p9pEe; msOlj: $this->db->order_by("\165\162\165\x74\141\x6e\137\164\141\x6d\160\151\154"); goto JKgCI; zloi1: if (!($arrMapel != null)) { goto EHyGI; } goto VEYJ8; GbdZu: WLZCN: goto zloi1; p9pEe: EHyGI: goto msOlj; JKgCI: return $this->db->get("\x6d\141\163\164\x65\162\x5f\x6d\141\160\145\x6c")->result(); goto E65mZ; E65mZ: } public function getAllMapelByKelompok($jenjang) { goto qVrbF; qVrbF: $this->db->where("\163\164\x61\x74\x75\x73", "\61"); goto ZgMRy; Xu3NC: uU39g: goto ZFF1m; KtcLY: $this->db->order_by("\x75\162\165\x74\141\156\x5f\164\141\x6d\160\x69\x6c"); goto BYWmn; RTFgt: $ret = []; goto cavgb; ZgMRy: $this->db->order_by("\x75\x72\x75\x74\x61\156"); goto KtcLY; BYWmn: $result = $this->db->get("\x6d\141\163\164\145\x72\x5f\x6d\x61\160\x65\x6c")->result(); goto RTFgt; cavgb: foreach ($result as $row) { $ret[$row->kelompok][] = $row; X1VGN: } goto Xu3NC; ZFF1m: return $ret; goto srzNL; srzNL: } public function getAllMapelNonAktif($jenjang) { $this->db->where("\163\164\x61\x74\x75\x73", "\x30"); return $this->db->get("\155\141\163\164\145\162\137\155\x61\160\145\154")->result(); } public function getMapelById($id, $single = false) { goto ZqrVh; Nyx90: $query = $this->db->get_where("\155\x61\x73\x74\145\x72\x5f\155\x61\x70\x65\x6c", array("\x69\144\x5f\x6d\141\x70\x65\154" => $id))->row(); goto Ox8Mz; TNHb0: gzo10: goto rDX3S; jPqHv: $this->db->order_by("\x6e\141\x6d\141\137\x6d\x61\x70\x65\x6c"); goto t3pZ6; EDtu6: return $query; goto eQeeZ; rDX3S: $this->db->where_in("\151\144\137\155\141\160\x65\154", $id); goto jPqHv; YqIWG: BadiP: goto EDtu6; ZqrVh: if ($single === false) { goto gzo10; } goto Nyx90; Ox8Mz: goto BadiP; goto TNHb0; t3pZ6: $query = $this->db->get("\155\141\163\164\145\162\x5f\x6d\141\160\x65\154")->result(); goto YqIWG; eQeeZ: } function updateMapel() { goto A3Y8k; lv85n: if (!($kelompok != null)) { goto w_tdK; } goto RGZGZ; TJEFq: $this->db->set("\x6e\141\x6d\141\x5f\155\x61\x70\x65\x6c", $name); goto mIKBZ; U9zyd: $this->db->where("\151\144\137\155\141\160\145\x6c", $id); goto PSbjE; eJYNT: w_tdK: goto JCXH7; JCXH7: $this->db->set("\x73\x74\141\164\165\x73", $status); goto Yrw8u; Yrw8u: $this->db->set("\x75\x72\165\x74\x61\x6e\x5f\x74\x61\155\160\151\x6c", $urut); goto U9zyd; s6sis: $urut = $this->input->post("\x75\x72\x75\164\141\x6e\x5f\x74\141\x6d\160\151\x6c", true); goto TJEFq; RGZGZ: $this->db->set("\x6b\145\154\x6f\x6d\160\157\153", $kelompok); goto eJYNT; j7EpT: $status = $this->input->post("\163\x74\x61\164\165\x73", true); goto s6sis; PSbjE: return $this->db->update("\x6d\x61\163\164\145\x72\x5f\155\x61\160\145\x6c"); goto k7hGy; xM3nP: $kode = $this->input->post("\153\x6f\x64\145\137\x6d\x61\x70\145\154", true); goto Nl3xe; A3Y8k: $id = $this->input->post("\151\144\x5f\x6d\141\x70\x65\154"); goto ssP2Y; Nl3xe: $kelompok = $this->input->post("\153\145\154\157\x6d\160\157\153", true); goto j7EpT; mIKBZ: $this->db->set("\153\x6f\x64\145", $kode); goto lv85n; ssP2Y: $name = $this->input->post("\156\141\155\141\x5f\x6d\x61\x70\145\154", true); goto xM3nP; k7hGy: } public function getAllEkstra() { return $this->db->get("\155\141\163\x74\x65\x72\x5f\145\153\x73\x74\162\141")->result(); } public function getEkstraById($id, $single = false) { goto riXUf; KfJex: return $query; goto R1U8g; ii0yp: goto i_v8P; goto gb3Bj; vBTb0: $this->db->where_in("\151\x64\x5f\145\x6b\163\164\162\x61", $id); goto pjb9s; t3Tqi: i_v8P: goto KfJex; ORe9D: $query = $this->db->get("\155\x61\x73\164\x65\162\x5f\145\x6b\x73\x74\162\141")->result(); goto t3Tqi; gd_6P: $query = $this->db->get_where("\x6d\141\x73\164\x65\x72\137\145\x6b\x73\x74\162\x61", array("\x69\144\x5f\x65\x6b\163\x74\x72\x61" => $id))->row(); goto ii0yp; riXUf: if ($single === false) { goto YZTu1; } goto gd_6P; gb3Bj: YZTu1: goto vBTb0; pjb9s: $this->db->order_by("\156\x61\x6d\141\137\x65\x6b\163\164\162\x61"); goto ORe9D; R1U8g: } function updateEkstra() { goto q03Wz; q03Wz: $id = $this->input->post("\x69\x64\137\x65\153\x73\x74\x72\x61"); goto mZNQL; iapEo: $kode = $this->input->post("\x6b\x6f\x64\145\137\145\153\163\164\162\x61", true); goto uF9s1; FacoJ: $this->db->set("\x6b\157\144\145\137\145\x6b\163\164\162\x61", $kode); goto Gmg3n; Gmg3n: $this->db->where("\151\x64\x5f\145\153\x73\164\162\141", $id); goto iTAAa; iTAAa: return $this->db->update("\155\141\x73\164\145\x72\x5f\x65\153\x73\164\162\141"); goto VJF21; mZNQL: $name = $this->input->post("\156\x61\155\x61\137\145\x6b\163\x74\162\141", true); goto iapEo; uF9s1: $this->db->set("\156\x61\155\x61\137\x65\x6b\163\164\162\141", $name); goto FacoJ; VJF21: } public function getKelasGuru() { goto n5RFz; n5RFz: $this->db->query("\123\x45\x54\x20\x53\x51\x4c\137\102\111\x47\x5f\x53\105\x4c\105\103\124\123\x3d\61"); goto CGFC_; AhJLa: $this->datatables->group_by("\147\x75\162\x75\56\x6e\x61\155\x61\x5f\x67\x75\162\x75"); goto cw0Vs; cw0Vs: return $this->datatables->generate(); goto DrjmI; QnGbc: $this->datatables->join("\155\x61\x73\164\145\x72\137\x6b\x65\154\x61\x73", "\x6b\145\154\141\163\x5f\151\x64\75\x69\144\137\153\145\154\x61\163"); goto OpPUV; PZ9CJ: $this->datatables->from("\153\x65\154\141\x73\137\147\x75\162\x75"); goto QnGbc; CGFC_: $this->datatables->select("\x6b\x65\x6c\x61\x73\x5f\147\x75\162\165\56\151\x64\x2c\40\x67\165\x72\165\56\x69\144\x5f\147\x75\162\165\54\40\147\165\x72\165\x2e\156\151\x70\x2c\40\x67\x75\162\x75\56\x6e\141\x6d\141\x5f\x67\x75\162\165\54\x20\107\x52\x4f\x55\x50\x5f\x43\x4f\116\x43\101\x54\50\x6d\x61\x73\164\145\162\x5f\153\x65\154\x61\163\x2e\x6e\x61\155\x61\137\153\145\154\141\x73\x29\x20\141\163\x20\153\x65\x6c\141\163"); goto PZ9CJ; OpPUV: $this->datatables->join("\155\141\163\x74\x65\162\137\x67\165\162\x75", "\147\165\162\x75\137\x69\144\75\151\x64\137\x67\165\x72\x75"); goto AhJLa; DrjmI: } public function getKelasByGuru($id) { goto fDShN; JUbu0: $query = $this->db->get()->result(); goto b292R; b292R: return $query; goto g5wka; fDShN: $this->db->select("\x6b\145\154\x61\x73\56\x69\x64\137\153\145\x6c\141\163"); goto thiEI; HrTpO: $this->db->where("\147\x75\162\165\137\151\144", $id); goto JUbu0; kZ6Ek: $this->db->join("\155\x61\x73\164\145\x72\137\x6b\145\x6c\x61\x73", "\x6b\145\154\141\163\x5f\147\165\x72\x75\x2e\153\145\x6c\141\x73\137\151\144\75\153\x65\154\x61\x73\56\151\144\x5f\x6b\145\x6c\141\x73"); goto HrTpO; thiEI: $this->db->from("\153\x65\154\x61\163\137\x67\165\x72\x75"); goto kZ6Ek; g5wka: } public function getAllJabatanGuru($id) { goto gCuBB; gCuBB: $result = $this->db->get_where("\152\x61\142\141\x74\141\156\137\147\165\162\165", "\151\144\x5f\147\165\162\x75\x3d" . $id)->result(); goto urTRn; urTRn: if (!$result) { goto rntGl; } goto cjIpA; E3sgc: rntGl: goto T2NIV; c5XTa: oSl2_: goto E3sgc; cjIpA: foreach ($result as $key => $row) { $ret[$row->id_tp][$row->id_smt] = $row->id_kelas; GjjLf: } goto c5XTa; T2NIV: return $ret; goto CgH8U; CgH8U: } public function getJurusanMapel() { goto xckvv; r0jXK: $this->datatables->from("\x6a\165\162\x75\x73\141\156\137\x6d\141\x70\145\x6c"); goto kaXvU; hliis: $this->datatables->select("\152\165\162\165\163\x61\x6e\x5f\x6d\x61\160\145\154\x2e\x69\144\54\x20\x6d\x61\x70\145\x6c\56\x69\x64\137\x6d\x61\160\145\x6c\x2c\40\x6d\141\160\x65\154\56\x6e\x61\155\x61\x5f\x6d\x61\x70\x65\x6c\x2c\x20\x6a\165\162\x75\163\141\156\56\151\x64\137\152\165\162\x75\x73\x61\156\x2c\x20\107\x52\117\125\x50\x5f\103\x4f\116\x43\x41\x54\50\x6a\165\x72\165\x73\141\x6e\56\156\141\155\141\137\x6a\x75\162\165\x73\141\x6e\51\40\x61\x73\x20\156\x61\x6d\141\x5f\152\165\162\x75\163\141\x6e"); goto r0jXK; JaajG: $this->datatables->join("\155\x61\x73\164\145\x72\137\152\x75\x72\x75\x73\x61\156", "\152\x75\162\165\163\x61\156\x5f\x69\144\x3d\151\x64\x5f\x6a\165\x72\165\163\141\156"); goto YJ0dm; rEXLA: return $this->datatables->generate(); goto NAo0g; xckvv: $this->db->query("\123\x45\124\x20\x53\x51\x4c\x5f\x42\111\107\x5f\x53\x45\114\x45\x43\x54\x53\75\x31"); goto hliis; YJ0dm: $this->datatables->group_by("\x6d\141\x73\164\x65\x72\x5f\155\141\160\x65\x6c\56\156\x61\x6d\141\137\155\x61\x70\x65\154"); goto rEXLA; kaXvU: $this->datatables->join("\155\x61\163\164\145\x72\x5f\x6d\141\x70\x65\x6c", "\x6d\x61\160\x65\154\137\151\x64\75\x69\144\137\x6d\141\x70\x65\154"); goto JaajG; NAo0g: } public function getMapel($id = null) { goto hlGmX; wL1E8: $this->db->where_not_in("\155\x61\160\x65\x6c\x5f\151\144", [$id]); goto iXMn5; TnAct: foreach ($mapel as $d) { $id_mapel[] = $d->mapel_id; uor4d: } goto X8HgG; kD40H: $id_mapel = []; goto TnAct; nYRpP: $id_mapel = null; goto o5LSI; o5LSI: hPHk4: goto YxOOQ; RJx24: $mapel = $this->db->get()->result(); goto kD40H; F6L7o: if (!($id !== null)) { goto LOqdg; } goto wL1E8; xHgsy: $this->db->from("\155\141\163\x74\x65\162\137\x6d\141\x70\145\154"); goto GfHty; hlGmX: $this->db->select("\155\x61\160\145\x6c\137\x69\144"); goto kkCbk; iXMn5: LOqdg: goto RJx24; Hte9m: return $this->db->get()->result(); goto fWFEh; kkCbk: $this->db->from("\152\x75\162\165\x73\141\x6e\137\x6d\141\x70\145\x6c"); goto F6L7o; X8HgG: JJlWX: goto TtPxQ; YxOOQ: $this->db->select("\151\x64\x5f\155\x61\x70\145\x6c\54\x20\x6e\141\x6d\141\x5f\155\x61\x70\x65\154"); goto xHgsy; GfHty: $this->db->where_not_in("\151\144\x5f\155\x61\x70\145\x6c", $id_mapel); goto Hte9m; TtPxQ: if (!($id_mapel === [])) { goto hPHk4; } goto nYRpP; fWFEh: } public function getJurusanByIdMapel($id) { goto aLwzL; aLwzL: $this->db->select("\152\x75\x72\x75\163\141\x6e\x2e\151\x64\137\x6a\165\x72\x75\163\x61\x6e"); goto OJKnl; aC0oT: $query = $this->db->get()->result(); goto QX2KC; QX2KC: return $query; goto B1BDp; OJKnl: $this->db->from("\x6a\x75\x72\165\163\141\156\137\x6d\x61\160\x65\154"); goto B3UcY; vkymf: $this->db->where("\x6d\x61\x70\x65\154\x5f\x69\x64", $id); goto aC0oT; B3UcY: $this->db->join("\155\141\163\164\145\162\137\152\x75\162\165\163\x61\156", "\152\x75\x72\x75\163\x61\x6e\137\155\x61\160\x65\154\x2e\x6a\x75\x72\x75\163\141\156\x5f\x69\x64\x3d\x6a\165\x72\x75\163\141\156\56\151\144\x5f\152\165\x72\165\x73\141\x6e"); goto vkymf; B1BDp: } public function getTahunActive() { goto Nf5av; hlJA8: return $result; goto GuGBD; qcVfM: $this->db->from("\x6d\141\x73\164\x65\x72\x5f\x74\x70"); goto KDZRk; KDZRk: $this->db->where("\141\x63\164\151\166\x65", 1); goto HaQZ0; Nf5av: $this->db->select("\x69\144\x5f\x74\x70\54\40\x74\141\x68\165\156"); goto qcVfM; HaQZ0: $result = $this->db->get()->row(); goto hlJA8; GuGBD: } public function getSemesterActive() { goto mV4JX; mV4JX: $this->db->select("\151\x64\137\x73\155\164\x2c\x20\156\x61\x6d\141\x5f\163\x6d\x74\54\40\x73\x6d\x74"); goto se9Ik; se9Ik: $this->db->from("\155\x61\x73\164\x65\162\137\x73\x6d\x74"); goto L6X6M; vZWmT: $result = $this->db->get()->row(); goto VXgIC; L6X6M: $this->db->where("\141\x63\x74\x69\166\x65", 1); goto vZWmT; VXgIC: return $result; goto vZCfm; vZCfm: } public function getJmlHariEfektif($id) { goto WM6Ar; md43F: return $result; goto Eh8q6; WM6Ar: $this->db->select("\x2a"); goto IeVlx; IeVlx: $this->db->from("\155\141\x73\x74\x65\x72\137\x68\x61\162\151\x5f\x65\146\x65\x6b\x74\x69\x66"); goto qulxy; qulxy: $this->db->where("\x69\144\x5f\x68\141\162\151\137\x65\146\145\x6b\x74\x69\x66", $id); goto xzNeC; xzNeC: $result = $this->db->get()->row(); goto md43F; Eh8q6: } public function getDistinctTahunLulus() { goto bYfxU; aZ3fS: lOYpo: goto DqJVq; bYfxU: $this->db->select("\x74\x61\x68\x75\156\x5f\154\165\x6c\165\x73"); goto cnBRJ; rubxW: foreach ($result as $row) { goto W1D7Z; M9c1K: s9x7T: goto R03wo; ulkjo: $ret[$row->tahun_lulus] = $row->tahun_lulus; goto BssY9; W1D7Z: if (!($row->tahun_lulus != '')) { goto dELZ3; } goto ulkjo; BssY9: dELZ3: goto M9c1K; R03wo: } goto aZ3fS; cnBRJ: $this->db->distinct(); goto iqSlt; hfDTw: $ret = []; goto rubxW; DqJVq: return $ret; goto h7lCT; iqSlt: $result = $this->db->get("\x62\165\x6b\165\137\151\156\x64\x75\x6b")->result(); goto hfDTw; h7lCT: } public function getDistinctKelasAkhir() { goto WhK3s; WhK3s: $this->db->select("\153\145\154\141\163\137\141\x6b\150\x69\162"); goto zsIja; zsIja: $this->db->distinct(); goto rEoDX; rEoDX: $result = $this->db->get("\x62\165\x6b\x75\x5f\x69\156\x64\x75\x6b")->result(); goto e99Au; e99Au: $ret = []; goto G7mF2; Hiw5k: XijAC: goto I1gzf; I1gzf: return $ret; goto Jy_JS; G7mF2: foreach ($result as $row) { goto zXPtt; XhN1W: f_WKm: goto l9iTJ; f0xNq: $ret[$row->kelas_akhir] = $row->kelas_akhir; goto XhN1W; l9iTJ: lcY5g: goto YehVM; zXPtt: if (!($row->kelas_akhir != '')) { goto f_WKm; } goto f0xNq; YehVM: } goto Hiw5k; Jy_JS: } public function getAlumniByTahun($tahun, $kelas = null) { goto DKtdh; HkTVf: return $this->db->get()->result(); goto gbmR6; D2Fw9: $this->db->where("\141\x2e\x74\141\150\165\156\x5f\154\165\x6c\165\163", $tahun); goto Mgq3c; IOpHa: $this->db->from("\x62\x75\153\165\x5f\151\x6e\x64\x75\x6b\40\141"); goto nj4Wb; NO_Lo: $this->db->where("\141\56\x6b\145\154\141\x73\137\141\x6b\150\151\x72", $kelas); goto kmyTL; DKtdh: $this->db->select("\x2a"); goto IOpHa; Mgq3c: if (!($kelas != null)) { goto TyRrj; } goto NO_Lo; nj4Wb: $this->db->join("\155\x61\x73\x74\145\x72\137\x73\151\163\x77\141\40\142", "\141\x2e\151\x64\x5f\163\151\x73\167\141\x3d\x62\x2e\151\144\137\x73\x69\x73\167\141"); goto D2Fw9; kmyTL: TyRrj: goto HkTVf; gbmR6: } public function getAlumniById($id) { goto igorK; igorK: $this->db->select("\x2a"); goto ZzxDz; ZzxDz: $this->db->from("\x6d\141\163\x74\x65\162\x5f\x73\151\163\167\x61\x20\141"); goto QDomy; cx57h: return $this->db->get()->row(); goto WGc4u; QDomy: $this->db->join("\142\x75\x6b\x75\137\x69\x6e\x64\x75\153\x20\142", "\x61\56\x69\144\x5f\x73\x69\163\167\x61\x3d\x62\56\151\x64\x5f\163\x69\163\167\141"); goto RYMNy; RYMNy: $this->db->where("\x61\x2e\x69\x64\x5f\x73\x69\163\167\141", $id); goto cx57h; WGc4u: } public function getAllWaliKelas() { goto D5Ody; URCO0: $this->db->select("\141\x2e\151\144\137\164\160\x2c\40\x61\56\x69\x64\137\163\x6d\x74\54\40\141\x2e\151\144\x5f\x67\x75\162\x75\x2c\40\x62\56\156\141\x6d\x61\137\147\165\x72\165\x2c\40\x63\56\151\x64\137\154\145\x76\x65\154\x2c\40\143\56\154\145\x76\145\x6c\x2c\x20\x64\x2e\x69\144\x5f\x6b\x65\154\141\163\54\40\144\x2e\x6e\141\155\x61\x5f\x6b\x65\154\x61\163"); goto YOmau; cdhgL: $ret = []; goto zZOO0; zZOO0: if (!$result) { goto vtoCY; } goto cJqw3; D5Ody: $this->db->query("\x53\105\x54\x20\123\x51\114\137\102\x49\x47\137\123\105\114\105\x43\x54\123\75\x31"); goto URCO0; qlNeM: $result = $this->db->get()->result(); goto cdhgL; F1DHO: $this->db->join("\x6d\x61\163\x74\145\x72\x5f\147\x75\x72\x75\40\x62", "\141\56\151\144\x5f\x67\165\x72\165\75\x62\x2e\x69\144\x5f\147\x75\162\x75", "\x6c\145\146\x74"); goto crbLw; KCJg9: $this->db->join("\155\141\x73\164\145\162\137\x6b\145\x6c\x61\x73\40\144", "\x61\x2e\x69\144\x5f\x6b\x65\x6c\x61\x73\75\x64\56\x69\x64\137\153\x65\154\x61\x73", "\154\x65\x66\x74"); goto qlNeM; uMNm6: ydddU: goto RH73x; crbLw: $this->db->join("\x6c\145\x76\x65\x6c\x5f\147\x75\162\x75\40\143", "\x61\x2e\151\x64\137\x6a\x61\x62\141\x74\141\x6e\75\143\56\151\x64\137\154\145\x76\145\154", "\x6c\x65\x66\x74"); goto KCJg9; YOmau: $this->db->from("\x6a\141\142\x61\164\141\x6e\137\147\165\x72\x75\40\x61"); goto F1DHO; RH73x: vtoCY: goto o2mi3; o2mi3: return $ret; goto aHjyj; cJqw3: foreach ($result as $key => $row) { goto mcKrN; mcKrN: if (!($row->id_level == "\64")) { goto UFcEs; } goto hN_5y; hN_5y: $ret[$row->id_tp][$row->id_smt][$row->id_kelas] = $row; goto YKb90; YKb90: UFcEs: goto dQaVk; dQaVk: y2sO1: goto aakTr; aakTr: } goto uMNm6; aHjyj: } public function getAllGuru() { goto SVd8K; oPOgb: $id_guru = []; goto mzs10; mzs10: foreach ($guru as $d) { $id_guru[] = $d->id_guru; SWHXE: } goto Fou4G; Fou4G: MZlgg: goto YwN0t; J4_1G: return $this->db->get()->result(); goto LIUzX; SVd8K: $this->db->select("\151\x64\137\x67\165\162\165"); goto TJ5II; RJyzd: $guru = $this->db->get()->result(); goto oPOgb; YwN0t: $this->db->select("\x69\x64\x5f\147\165\162\x75\54\40\x6e\151\x70\x2c\x20\156\x61\155\141\x5f\x67\165\x72\x75"); goto xKreu; TJ5II: $this->db->from("\152\x61\142\x61\x74\141\156\137\x67\x75\x72\x75"); goto RJyzd; Mnqzo: $this->db->where_in("\151\x64\x5f\147\x75\x72\x75", $id_guru); goto J4_1G; xKreu: $this->db->from("\x6d\141\x73\x74\x65\162\137\x67\x75\x72\x75"); goto Mnqzo; LIUzX: } public function getAllKelas($tp = null, $smt = null) { goto c52qt; acl12: foreach ($result as $key => $row) { $ret[$row->id_kelas] = $row; O6HTm: } goto lpsc9; Rocw3: foreach ($result as $key => $row) { $ret[$row->id_tp][$row->id_smt][$row->id_kelas] = $row; uMEBs: } goto V0PtN; pupeh: $this->db->join("\x6d\141\163\164\145\x72\137\x6a\x75\x72\x75\x73\141\x6e\40\x62", "\x61\x2e\x6a\x75\162\x75\x73\x61\x6e\137\151\144\x3d\142\56\151\x64\x5f\152\x75\x72\x75\163\x61\x6e", "\154\145\x66\x74"); goto e1WBO; Nc1xm: if ($tp != null && $smt != null) { goto jHU07; } goto fta5K; ZuIif: return $ret; goto yvwBW; c52qt: $this->db->query("\123\105\124\x20\x53\x51\114\x5f\102\111\107\x5f\x53\x45\x4c\105\103\124\x53\x3d\61"); goto xUq1X; W4jqv: $this->db->order_by("\141\56\x6e\x61\x6d\141\x5f\x6b\x65\154\x61\163"); goto rsOYS; puSat: if (!($tp != null && $smt != null)) { goto bWFkE; } goto GUfjM; STJ60: $ret = []; goto Nc1xm; V0PtN: oJa1U: goto JfM5h; Frqug: $this->db->from("\155\x61\163\x74\x65\162\x5f\153\145\x6c\x61\163\40\x61"); goto puSat; R13h9: if (!$result) { goto vziHt; } goto acl12; JfM5h: FWDCO: goto PL2dm; GUfjM: $this->db->where("\x61\56\x69\144\137\x74\160", $tp)->where("\141\x2e\x69\144\x5f\163\x6d\164", $smt); goto NKuxq; rb0aS: pV0C9: goto ZuIif; NKuxq: bWFkE: goto gHhcT; LJzKo: jHU07: goto R13h9; PL2dm: goto pV0C9; goto LJzKo; e1WBO: $this->db->join("\155\x61\x73\164\x65\162\137\147\165\162\165\x20\x63", "\x66\x2e\x69\x64\x5f\x67\x75\x72\165\75\143\x2e\151\144\137\x67\x75\162\x75", "\154\145\x66\164"); goto W4jqv; rsOYS: $result = $this->db->get()->result(); goto STJ60; fta5K: if (!$result) { goto FWDCO; } goto Rocw3; ae3hJ: vziHt: goto rb0aS; gHhcT: $this->db->join("\152\x61\142\x61\x74\141\x6e\137\x67\165\x72\165\40\x66", "\x66\x2e\x69\144\x5f\x6b\x65\x6c\x61\x73\75\141\x2e\x69\144\137\153\x65\x6c\141\163", "\154\145\x66\164"); goto pupeh; lpsc9: TLsbi: goto ae3hJ; xUq1X: $this->db->select("\x61\56\x69\x64\137\x6b\x65\154\141\163\x2c\x20\141\56\x69\x64\137\x74\x70\x2c\x20\141\56\151\x64\x5f\163\x6d\x74\54\x20\141\56\x6e\141\x6d\x61\x5f\x6b\145\154\141\x73\54\x20\x61\56\153\x6f\x64\x65\x5f\153\x65\x6c\141\163\x2c\40\x61\56\x6c\145\x76\x65\x6c\x5f\x69\x64\x2c\x20\x62\x2e\156\x61\155\141\x5f\152\165\162\165\163\141\x6e\54\40\142\x2e\x6b\x6f\144\145\137\x6a\x75\x72\x75\x73\x61\x6e\54\40\143\x2e\x6e\x61\155\x61\137\x67\165\x72\x75"); goto Frqug; yvwBW: } public function getAllKelasSiswa() { goto DXgF0; R66Z8: $this->db->from("\153\x65\x6c\x61\x73\137\163\x69\163\x77\x61"); goto opwKb; DXgF0: $this->db->select("\52"); goto R66Z8; LjYcf: $ret = []; goto IJR3s; j8o7b: foreach ($result as $key => $row) { $ret[$row->id_kelas][$row->id_siswa] = $row; u6kJp: } goto ywa2o; x9BDe: Rd2hW: goto zlYs1; IJR3s: if (!$result) { goto Rd2hW; } goto j8o7b; opwKb: $result = $this->db->get()->result(); goto LjYcf; ywa2o: pomTW: goto x9BDe; zlYs1: return $ret; goto m7F9x; m7F9x: } public function getDataInduk() { goto pAxdr; pAxdr: $this->db->select("\x61\56\x2a\x2c\40\142\x2e\52\x2c"); goto aocbw; aocbw: $this->db->from("\155\x61\163\x74\x65\162\137\163\151\163\167\141\x20\x61"); goto LZ5Kq; bfggH: xO5wz: goto aVSZb; AtCI2: return $ret; goto BtJIX; nY7y1: $ret = []; goto uC2SE; LZ5Kq: $this->db->join("\x62\165\153\165\137\x69\156\x64\x75\x6b\40\142", "\141\x2e\x69\x64\137\x73\x69\163\167\x61\x3d\x62\56\151\x64\137\163\x69\163\167\141", "\x6c\x65\146\164"); goto Xz_TB; ySPdh: foreach ($result as $key => $row) { $ret[$row->id_siswa] = $row; Yi_RA: } goto bfggH; aVSZb: XmCSN: goto AtCI2; Xz_TB: $this->db->order_by("\141\x2e\156\x61\155\141", "\x41\123\103"); goto eimrF; uC2SE: if (!$result) { goto XmCSN; } goto ySPdh; eimrF: $result = $this->db->get()->result(); goto nY7y1; BtJIX: } }
Function Calls
| None |
Stats
| MD5 | ad5f62329e6d1d01a112a19211a8fec2 |
| Eval Count | 0 |
| Decode Time | 73 ms |