Find this useful? Enter your email to receive occasional updates for securing PHP code.

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 N_RkL; FrJgk: goto h1C6K; goto UXoxE; J49f5: h1C6K: goto UQSGy; N_RkL: if ($batch === false) { goto Lh_vO; } goto sDk0b; ZNjXZ: $insert = $this->db->insert($table, $data); goto J49f5; UXoxE: Lh_vO: goto ZNjXZ; UQSGy: return $insert; goto A4Gum; sDk0b: $insert = $this->db->insert_batch($table, $data); goto FrJgk; A4Gum: } public function update($table, $data, $pk, $id = null, $batch = false) { goto MIiKy; YhPwO: goto QxQqA; goto X7gVo; Mjy6u: QxQqA: goto fSwoF; fSwoF: return $insert; goto vCwtv; X7gVo: sP1pC: goto Mn9SS; MIiKy: if ($batch === false) { goto sP1pC; } goto mz9_3; Mn9SS: $insert = $this->db->update($table, $data, array($pk => $id)); goto Mjy6u; mz9_3: $insert = $this->db->update_batch($table, $data, $pk); goto YhPwO; vCwtv: } 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 hB5Sm; xFiJ0: return $this->db->delete($table); goto rosWt; hB5Sm: $this->db->where_in($pk, $data); goto u7oFN; u7oFN: $this->db->where($col . "!=" . $not); goto xFiJ0; rosWt: } public function getDataKelas() { goto OQhGT; OQhGT: $this->datatables->select("id_kelas, nama_kelas, id_jurusan, nama_jurusan"); goto gsT46; PsfZM: $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 NCcpH; gsT46: $this->datatables->from("master_kelas"); goto xSU3s; NCcpH: return $this->datatables->generate(); goto X9xxH; xSU3s: $this->datatables->join("master_jurusan", "jurusan_id=id_jurusan"); goto PsfZM; X9xxH: } public function getKelasById($id) { goto qfevV; Sd_Dh: return $query; goto zZhj0; dPk12: $this->db->order_by("nama_kelas"); goto mev6V; qfevV: $this->db->select("id_kelas, nama_kelas, level_id"); goto rPddv; rPddv: $this->db->from("master_kelas"); goto G1FJO; G1FJO: $this->db->where("id_kelas", $id); goto dPk12; mev6V: $query = $this->db->get()->row(); goto Sd_Dh; zZhj0: } public function getDataJurusan() { goto W0GHV; GgBTx: $result = $this->db->get()->result(); goto umnHU; W0GHV: $this->db->select("*"); goto no3ph; umnHU: return $result; goto WfeUG; no3ph: $this->db->from("master_jurusan"); goto GgBTx; WfeUG: } public function getDataJurusanMapel($arrIds) { goto X8iYG; QXdZy: $ret = []; goto NqQo2; nQc83: Dyyqo: goto BnewP; WLT5k: $this->db->where_in("id_mapel", $arrIds); goto ln11q; ln11q: $result = $this->db->get()->result(); goto QXdZy; X8iYG: $this->db->select("id_mapel, nama_mapel"); goto IGpGY; BnewP: return $ret; goto qPyEY; IGpGY: $this->db->from("master_mapel"); goto WLT5k; NqQo2: if (!$result) { goto Dyyqo; } goto Bva6b; Bva6b: foreach ($result as $key => $row) { $ret[$row->id_mapel] = $row->nama_mapel; Uh0Rn: } goto eeEzu; eeEzu: FfJKT: goto nQc83; qPyEY: } public function getDataTableJurusan() { goto dVgD1; Ennk0: $this->db->order_by("id_jurusan"); goto dOs4S; dVgD1: $this->datatables->select("*"); goto bUQ_M; dOs4S: return $this->datatables->generate(); goto S1m6_; bUQ_M: $this->datatables->from("master_jurusan"); goto Ennk0; S1m6_: } public function getJurusanById($id) { goto PrxnW; Psug6: $this->db->order_by("nama_jurusan"); goto vqb1p; PrxnW: $this->db->where_in("id_jurusan", $id); goto Psug6; juSXP: return $query; goto ov0kC; vqb1p: $query = $this->db->get("master_jurusan")->result(); goto juSXP; ov0kC: } function updateJurusan() { goto MzOla; E3x23: $check_mapel = $this->input->post("mapel", true); goto dLC8O; XVo_S: $kode = $this->input->post("kode_jurusan", true); goto qug9L; eRcDe: QCP2B: goto MCyx8; dLC8O: if (!$check_mapel) { goto QCP2B; } goto tpdKi; qug9L: $mapels = []; goto E3x23; A_kVV: $i++; goto K2mBY; MzOla: $id = $this->input->post("id_jurusan"); goto qLqd7; lT9J_: $i = 0; goto V5VWg; V5VWg: m0RWu: goto xYJfA; xYJfA: if (!($i <= $row_mapels)) { goto FlaJU; } goto bWyjU; lS0zR: $this->db->set("mapel_peminatan", implode(",", $mapels)); goto ovByL; vP9dM: FlaJU: goto eRcDe; p6CYT: $this->db->set("kode_jurusan", $kode); goto lS0zR; tpdKi: $row_mapels = count($this->input->post("mapel", true)); goto lT9J_; OkCGI: return $this->db->update("master_jurusan"); goto lZIJd; MCyx8: $this->db->set("nama_jurusan", $name); goto p6CYT; qLqd7: $name = $this->input->post("nama_jurusan", true); goto XVo_S; EWe3k: $this->db->where("id_jurusan", $id); goto OkCGI; K2mBY: goto m0RWu; goto vP9dM; oZ3IS: m5oNX: goto A_kVV; ovByL: $this->db->set("status", "1"); goto EWe3k; bWyjU: array_push($mapels, $this->input->post("mapel[" . $i . "]", true)); goto oZ3IS; lZIJd: } 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 WcJ8L; HX2hb: $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 syRe6; cckOh: $this->db->from("master_siswa a"); goto HX2hb; fS_G6: $this->db->select("a.*, c.nama_kelas"); goto cckOh; WcJ8L: $this->db->query("SET SQL_BIG_SELECTS=1"); goto fS_G6; KKjJr: return $query->result(); goto xPLhe; XWmuB: $query = $this->db->get(); goto KKjJr; Xm_xe: $this->db->order_by("a.nama"); goto XWmuB; syRe6: $this->db->join("master_kelas c", "c.id_kelas=b.id_kelas", "left"); goto hD28I; hD28I: $this->db->order_by("b.id_kelas"); goto Xm_xe; xPLhe: } public function getSiswaByKelas($id_tp, $id_smt, $id_kelas) { goto B5QtA; OITO6: $this->db->order_by("b.nama", "ASC"); goto S2OTP; S2OTP: return $this->db->get()->result(); goto jbeD1; N9ulY: $this->db->join("master_siswa b", "b.id_siswa=a.id_siswa"); goto kJyfN; B5QtA: $this->db->select("b.*"); goto hoMQy; fMvcl: $this->db->where("a.id_kelas", $id_kelas); goto OITO6; Qlw_a: $this->db->where("a.id_smt", $id_smt); goto XYFGy; XYFGy: $this->db->where("a.id_siswa is NOT NULL", NULL, FALSE); goto lqxb1; kJyfN: $this->db->where("a.id_tp", $id_tp); goto Qlw_a; hoMQy: $this->db->from("kelas_siswa a"); goto N9ulY; lqxb1: $this->db->where("b.id_siswa is NOT NULL", NULL, FALSE); goto fMvcl; jbeD1: } public function getDataSiswa($id_tp, $id_smt) { goto FfljU; nWaob: $this->datatables->join("master_kelas f", "f.id_kelas=d.id_kelas", "left"); goto deHE4; RuWua: $this->db->order_by("b.status", "ASC"); goto Ep0yO; FfljU: $this->db->query("SET SQL_BIG_SELECTS=1"); goto CazEg; CazEg: $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 x5kWt; dfAFl: $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 nWaob; x5kWt: $this->datatables->from("master_siswa a"); goto d9X4j; d9X4j: $this->datatables->join("buku_induk b", "a.id_siswa=b.id_siswa", "left"); goto mb1Ed; qKS35: $this->db->order_by("f.nama_kelas", "ASC"); goto RuWua; mb1Ed: $this->datatables->join("users c", "a.username=c.username"); goto dfAFl; deHE4: $this->db->order_by("ISNULL(f.level_id), f.level_id ASC"); goto qKS35; Ep0yO: return $this->datatables->generate(); goto Fe4Ks; Fe4Ks: } public function getAllSiswa($id_tp, $id_smt, $offset, $limit, $search = null, $sort = null, $order = null) { goto W1yIB; dAxtx: $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 WPb4U; vSa4p: $this->db->order_by("a.nama", "ASC"); goto dAxtx; WPb4U: $this->db->join("master_kelas f", "f.id_kelas=d.id_kelas", "left"); goto opggK; W1yIB: $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 fcTBO; fcTBO: $this->db->from("master_siswa a"); goto QDrZB; opggK: if (!($search != null)) { goto PwBOD; } goto fCJP2; du1BW: $this->db->or_like("a.nis", $search); goto m3j3f; tMaxd: return $this->db->get()->result(); goto hidU3; fCJP2: $this->db->like("a.nama", $search); goto du1BW; QDrZB: $this->db->limit($limit, $offset); goto vSa4p; dQgqe: PwBOD: goto tMaxd; m3j3f: $this->db->or_like("a.nisn", $search); goto dQgqe; hidU3: } public function getSiswaPage($id_tp, $id_smt, $offset, $limit, $search = null, $sort = null, $order = null) { goto dWcig; dWcig: $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 ug6ty; JkHz1: ontWX: goto ougK2; o5Lvu: $this->db->or_like("a.nisn", $search); goto JkHz1; Ul3yx: $this->db->order_by("ISNULL(f.level_id), f.level_id ASC"); goto YN_Pk; xOIzz: $this->db->order_by("a.nama", "ASC"); goto jnHg9; jnHg9: if (!($search != null)) { goto ontWX; } goto Iybgy; Iybgy: $this->db->like("a.nama", $search); goto Vh3c0; ougK2: return $this->db->get()->result(); goto fsl1M; YN_Pk: $this->db->order_by("f.nama_kelas", "ASC"); goto xOIzz; bzlZ5: $this->db->join("master_kelas f", "f.id_kelas=d.id_kelas", "left"); goto Ul3yx; TOuou: $this->db->limit($limit, $offset); goto s40iU; s40iU: $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 bzlZ5; Vh3c0: $this->db->or_like("a.nis", $search); goto o5Lvu; ug6ty: $this->db->from("master_siswa a"); goto TOuou; fsl1M: } public function getSiswaTotalPage($search = null) { goto WEFJH; GBwIB: $this->db->or_like("nisn", $search); goto KfCcl; gcfDX: return $this->db->get()->num_rows(); goto zTlli; Jc8Jh: $this->db->from("master_siswa"); goto o8Q5A; TZx63: $this->db->like("nama", $search); goto oe4T2; KfCcl: exbKh: goto gcfDX; oe4T2: $this->db->or_like("nis", $search); goto GBwIB; o8Q5A: if (!($search != null)) { goto exbKh; } goto TZx63; WEFJH: $this->db->select("id_siswa"); goto Jc8Jh; zTlli: } public function getDataSiswaByKelas($id_tp, $id_smt, $id_kelas, $offset, $limit, $search = null, $sort = null, $order = null) { goto avfAM; cjdBg: bJTYv: goto FpLAZ; kf6g9: if (!($search != null)) { goto bJTYv; } goto Fz7lc; b3Jts: $this->db->join("master_kelas f", "f.id_kelas=a.id_kelas"); goto kf6g9; Fz7lc: $this->db->like("b.nama", $search); goto XKCQJ; btMkk: $this->db->where("a.id_kelas", $id_kelas); goto jpwg7; qw6Me: $this->db->or_like("b.nisn", $search); goto cjdBg; avfAM: $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 yYb3G; yYb3G: $this->db->from("kelas_siswa a"); goto zVTqv; hQxOx: $this->db->join("master_siswa b", "b.id_siswa=a.id_siswa"); goto b3Jts; K0l3h: $this->db->where("a.id_smt", $id_smt); goto btMkk; FpLAZ: $this->db->where("a.id_tp", $id_tp); goto K0l3h; jpwg7: return $this->db->get()->result(); goto Ku1Al; XKCQJ: $this->db->or_like("b.nis", $search); goto qw6Me; zVTqv: $this->db->limit($limit, $offset); goto hQxOx; Ku1Al: } public function getDataSiswaByKelasPage($id_tp, $id_smt, $id_kelas, $search = null) { goto OevcT; T25mV: $this->db->like("b.nama", $search); goto jPUh5; uVAjB: return $this->db->get()->num_rows(); goto s3jF6; lcGee: fq4ug: goto uVAjB; OevcT: $this->db->select("a.id_siswa"); goto IGTys; HPwsR: $this->db->where("a.id_kelas", $id_kelas); goto XEAKc; jPUh5: $this->db->or_like("b.nis", $search); goto QqlVa; D7kgX: if (!($search != null)) { goto fq4ug; } goto T25mV; XEAKc: $this->db->join("master_siswa b", "b.id_siswa=a.id_siswa"); goto D7kgX; WSI_V: $this->db->where("a.id_smt", $id_smt); goto HPwsR; d6JlA: $this->db->where("a.id_tp", $id_tp); goto WSI_V; QqlVa: $this->db->or_like("b.nisn", $search); goto lcGee; IGTys: $this->db->from("kelas_siswa a"); goto d6JlA; s3jF6: } public function getSiswaById($id) { goto CNQlx; QBHcM: $this->db->where("a.id_siswa", $id); goto Ike2F; r9E6M: $this->db->from("master_siswa a"); goto wO1oo; Ike2F: return $this->db->get()->row(); goto LpWP2; wO1oo: $this->db->join("buku_induk b", "a.id_siswa=b.id_siswa", "left"); goto QBHcM; CNQlx: $this->db->select("a.*, b.status"); goto r9E6M; LpWP2: } public function getSiswaKelasBaru($id_tp, $id_smt) { goto Xan0R; J94q2: $result = $this->db->get()->result(); goto ZH4hJ; FeBcJ: $this->db->where("a.id_tp", $id_tp); goto u5F74; zVTVn: C6Slk: goto Wo1aA; s_ar4: $this->db->select("b.id_siswa, b.nama, f.id_kelas, f.nama_kelas, f.kode_kelas"); goto EyXTO; ZH4hJ: $ret = []; goto Nf1si; stwjQ: return $ret; goto fnsUt; dmngo: foreach ($result as $key => $row) { $ret[$row->id_siswa] = $row; m5Bgd: } goto zVTVn; u5F74: $this->db->where("a.id_smt", $id_smt); goto J94q2; V5pFW: $this->db->join("master_kelas f", "f.id_kelas=a.id_kelas"); goto FeBcJ; Xan0R: $this->db->query("SET SQL_BIG_SELECTS=1"); goto s_ar4; EyXTO: $this->db->from("kelas_siswa a"); goto Oe8lk; Wo1aA: ze9Sc: goto stwjQ; Oe8lk: $this->db->join("master_siswa b", "b.id_siswa=a.id_siswa"); goto V5pFW; Nf1si: if (!$result) { goto ze9Sc; } goto dmngo; fnsUt: } public function getDataSiswaById($id_tp, $id_smt, $idSiswa) { goto TShnT; LWxTA: $this->db->join("master_siswa b", "b.id_siswa=a.id_siswa", "left"); goto u4zZx; TShnT: $this->db->query("SET SQL_BIG_SELECTS=1"); goto x2her; ksWsZ: $this->db->from("kelas_siswa a"); goto LWxTA; x2her: $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 ksWsZ; fMFAg: $this->db->where("a.id_siswa", $idSiswa); goto KtOJ8; wNKLu: $this->db->where("a.id_smt", $id_smt); goto fMFAg; KtOJ8: return $this->db->get()->row(); goto M_Mvc; NSMCI: $this->db->where("a.id_tp", $id_tp); goto wNKLu; u4zZx: $this->db->join("cbt_sesi_siswa c", "c.siswa_id=a.id_siswa", "left"); goto aKmUH; VYqvz: $this->db->join("cbt_ruang i", "i.id_ruang=h.id_ruang", "left"); goto E7W4O; aKmUH: $this->db->join("cbt_ruang d", "d.id_ruang=c.ruang_id", "left"); goto nNIgS; E7W4O: $this->db->join("cbt_sesi j", "j.id_sesi=h.id_sesi", "left"); goto NSMCI; e1oLH: $this->db->join("cbt_nomor_peserta g", "g.id_siswa=a.id_siswa AND g.id_tp=" . $id_tp, "left"); goto wnhW0; nNIgS: $this->db->join("cbt_sesi e", "e.id_sesi=c.sesi_id", "left"); goto BlY1k; wnhW0: $this->db->join("cbt_kelas_ruang h", "h.id_kelas=a.id_kelas", "left"); goto VYqvz; BlY1k: $this->db->join("master_kelas f", "f.id_kelas=a.id_kelas", "left"); goto e1oLH; M_Mvc: } public function getAgamaSiswa() { goto ypQ1U; pr9wN: $ret["-"] = "Bukan Mapel Agama"; goto BrIk5; gnOVx: $this->db->distinct(); goto SjVmW; vgWvv: $this->db->where("a.agama is NOT NULL", NULL, FALSE); goto i38dO; ypQ1U: $this->db->select("agama"); goto gnOVx; BrIk5: foreach ($result as $row) { $ret[$row->agama] = $row->agama; qQ6I8: } goto J9zOQ; HqcZg: $result = $this->db->get()->result(); goto pr9wN; YW6j7: $this->db->not_like("a.agama", "Pilih"); goto HqcZg; SjVmW: $this->db->from("master_siswa a"); goto vgWvv; vqK6p: return $ret; goto cwZEq; i38dO: $this->db->where("a.agama != "0"", NULL, FALSE); goto YW6j7; J9zOQ: ha5Mi: goto vqK6p; cwZEq: } public function getJurusan() { goto pA5Q_; leoIf: $query = $this->db->get(); goto Si4kN; wn1U8: $this->db->join("master_jurusan", "jurusan_id=id_jurusan"); goto p38hV; iRloj: $this->db->from("master_kelas"); goto wn1U8; pA5Q_: $this->db->select("id_jurusan, nama_jurusan"); goto iRloj; Si4kN: return $query->result(); goto wtznS; MzJ9D: $this->db->group_by("id_jurusan"); goto leoIf; p38hV: $this->db->order_by("nama_jurusan", "ASC"); goto MzJ9D; wtznS: } public function getAllJurusan($id = null) { goto SEAke; BMlhf: $this->db->from("master_jurusan"); goto ON_LE; QD9T8: goto WhOwT; goto nJh7c; aU20i: foreach ($jurusan as $j) { $id_jurusan[] = $j->jurusan_id; xXP_1: } goto zjscP; QKATt: $id_jurusan = []; goto aU20i; gdpFj: $this->db->order_by("nama_jurusan", "ASC"); goto aKght; zGd5O: $this->db->from("jurusan_mapel"); goto YpkMx; jeFUT: WhOwT: goto edrye; nJh7c: lBnHi: goto gdpFj; qGCEw: $id_jurusan = null; goto CvS5u; aKght: return $this->db->get("jurusan")->result(); goto jeFUT; k6TCA: if (!($id_jurusan === [])) { goto oa0vc; } goto qGCEw; betzq: $jurusan = $this->db->get()->result(); goto QKATt; CvS5u: oa0vc: goto c5i5l; wmAzq: $mapel = $this->db->get()->result(); goto las1g; YpkMx: $this->db->where("mapel_id", $id); goto betzq; las1g: return $mapel; goto QD9T8; ON_LE: $this->db->where_not_in("id_jurusan", $id_jurusan); goto wmAzq; SEAke: if ($id === null) { goto lBnHi; } goto mhaJ9; mhaJ9: $this->db->select("jurusan_id"); goto zGd5O; zjscP: hgvfp: goto k6TCA; c5i5l: $this->db->select("*"); goto BMlhf; edrye: } public function getKelasByJurusan($id) { $query = $this->db->get_where("master_kelas", array("jurusan_id" => $id)); return $query->result(); } public function getDataGuru($tp, $smt) { goto fTwGZ; fTwGZ: $this->db->query("SET SQL_BIG_SELECTS=1"); goto QBy_D; HZiqb: $this->datatables->join("level_guru c", "b.id_jabatan=c.id_level", "left"); goto COc0M; zh392: return $this->datatables->generate(); goto jRMCW; COc0M: $this->datatables->join("master_kelas d", "b.id_kelas=d.id_kelas AND d.id_tp=" . $tp . " AND d.id_smt=" . $smt . '', "left"); goto V_v2h; q6zly: $this->datatables->from("master_guru a"); goto Ya7Io; Mdemj: $this->datatables->join("master_smt f", "b.id_smt=f.id_smt", "left"); goto zh392; V_v2h: $this->datatables->join("master_tp e", "b.id_tp=e.id_tp", "left"); goto Mdemj; Ya7Io: $this->datatables->join("jabatan_guru b", "a.id_guru=b.id_guru AND b.id_tp=" . $tp . " AND b.id_smt=" . $smt . '', "left"); goto HZiqb; QBy_D: $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 q6zly; jRMCW: } public function getAllDataGuru($tp, $smt) { goto djxdh; l7O7W: $this->db->join("master_smt f", "b.id_smt=f.id_smt", "left"); goto xWHfC; djxdh: $this->db->query("SET SQL_BIG_SELECTS=1"); goto Ap6mp; JDb1e: $this->db->from("master_guru a"); goto tSjeD; Ap6mp: $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 JDb1e; tSjeD: $this->db->join("jabatan_guru b", "a.id_guru=b.id_guru AND b.id_tp=" . $tp . " AND b.id_smt=" . $smt . '', "left"); goto OQ9Vo; xWHfC: $this->db->order_by("c.id_level", "desc"); goto cvc8r; NfZ33: $this->db->join("master_kelas d", "b.id_kelas=d.id_kelas AND d.id_tp=" . $tp . " AND d.id_smt=" . $smt . '', "left"); goto i0xgO; OQ9Vo: $this->db->join("level_guru c", "b.id_jabatan=c.id_level", "left"); goto NfZ33; i0xgO: $this->db->join("master_tp e", "b.id_tp=e.id_tp", "left"); goto l7O7W; Req0r: return $this->db->get()->result(); goto hYs8V; cvc8r: $this->db->order_by("a.id_guru", "asc"); goto Req0r; hYs8V: } public function getGuruById($id, $id_tp = null, $id_smt = null) { goto VMLMr; zYGmM: $this->db->join("level_guru c", "b.id_jabatan=c.id_level", "left"); goto hX9xq; VMLMr: $this->db->query("SET SQL_BIG_SELECTS=1"); goto onhWU; f5b1v: DngiQ: goto SJM65; ek_rH: return $this->db->get()->row(); goto XerEI; onhWU: $this->db->select("*"); goto rY7w3; TDxAb: $this->db->join("jabatan_guru b", "a.id_guru=b.id_guru", "left"); goto zYGmM; e2keQ: $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 f5b1v; hX9xq: if (!($id_tp != null && $id_smt != null)) { goto DngiQ; } goto e2keQ; rY7w3: $this->db->from("master_guru a"); goto TDxAb; SJM65: $this->db->where("a.id_guru", $id); goto ek_rH; XerEI: } public function getGuruByArrId($arr_id) { goto fc7BW; GdfLL: $this->db->where_in("id_guru", $arr_id); goto POk9E; YIhOV: if (!(count($arr_id) > 0)) { goto QYdkS; } goto GdfLL; nnYUz: $this->db->from("master_guru"); goto YIhOV; POk9E: QYdkS: goto Qefm1; Qefm1: return $this->db->get()->result(); goto jVhDv; fc7BW: $this->db->select("nama_guru"); goto nnYUz; jVhDv: } public function getUserIdGuruByUsername($username) { goto bH8Bd; XSxbA: $this->db->join("jabatan_guru b", "a.id_guru=b.id_guru", "left"); goto gpySH; bH8Bd: $this->db->query("SET SQL_BIG_SELECTS=1"); goto rezT7; gpySH: $this->db->join("level_guru c", "b.id_jabatan=c.id_level", "left"); goto i2PY5; i2PY5: $this->db->where("a.username", $username); goto rw5T8; rw5T8: return $this->db->get()->row(); goto Am_Jj; rezT7: $this->db->select("*"); goto RIxYh; RIxYh: $this->db->from("master_guru a"); goto XSxbA; Am_Jj: } public function getDetailJabatanGuru($id_guru) { goto KO_Rc; ektF6: $this->db->from("master_guru a"); goto aytAN; UWJBN: foreach ($result as $row) { $ret[$row->id_tp][$row->id_smt] = $row; yiGyF: } goto KU2AP; KO_Rc: $this->db->query("SET SQL_BIG_SELECTS=1"); goto CmYXg; RpswS: $this->db->join("master_kelas d", "b.id_kelas=d.id_kelas", "left"); goto ieyeg; aytAN: $this->db->join("jabatan_guru b", "a.id_guru=b.id_guru", "left"); goto l0e5P; ieyeg: $this->db->where("a.id_guru", $id_guru); goto sMve0; sXuQ2: $ret = []; goto UWJBN; CmYXg: $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 ektF6; B0Qkc: return $ret; goto m2Pra; l0e5P: $this->db->join("level_guru c", "b.id_jabatan=c.id_level", "left"); goto RpswS; sMve0: $result = $this->db->get()->result(); goto sXuQ2; KU2AP: gxCeZ: goto B0Qkc; m2Pra: } public function getJabatanGuru($id_guru, $tp, $smt) { goto SCtSX; xWieL: return $query; goto LLDGA; xqjVA: $this->db->join("level_guru c", "b.id_jabatan=c.id_level", "left"); goto zUfvh; PgrJR: $this->db->from("master_guru a"); goto ZHCAE; PmqzU: $this->db->where("a.id_guru", $id_guru); goto Ih7MU; gVH3h: $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 PgrJR; Ih7MU: $query = $this->db->get()->row(); goto xWieL; ZHCAE: $this->db->join("jabatan_guru b", "a.id_guru=b.id_guru AND b.id_tp=" . $tp . " AND b.id_smt=" . $smt . '', "left"); goto xqjVA; zUfvh: $this->db->join("master_kelas d", "b.id_kelas=d.id_kelas AND d.id_tp=" . $tp . " AND d.id_smt=" . $smt . '', "left"); goto PmqzU; SCtSX: $this->db->query("SET SQL_BIG_SELECTS=1"); goto gVH3h; LLDGA: } public function getGuruMapel($tp, $smt) { goto tsN_N; NYE39: $this->db->where("a.id_smt", $smt); goto xh12P; OL8XE: $this->db->join("master_guru b", "a.id_guru=b.id_guru"); goto WLUoe; xh12P: $query = $this->db->get()->result(); goto C2rks; WLUoe: $this->db->where("a.id_tp", $tp); goto NYE39; n3F0d: $this->db->from("jabatan_guru a"); goto OL8XE; tsN_N: $this->db->select("a.mapel_kelas, a.ekstra_kelas, a.id_jabatan, a.id_kelas, b.id_guru, b.nama_guru"); goto n3F0d; C2rks: return $query; goto ncdT6; ncdT6: } public function getKodeKelompokMapel() { goto Fgk2p; Fgk2p: $this->db->select("*"); goto phA0h; H8KCi: foreach ($result as $row) { $ret[$row->kode_kel_mapel] = $row; FHcga: } goto DNP2W; phA0h: $this->db->from("master_kelompok_mapel"); goto tzIr1; lKcuf: return $ret; goto EbqK1; aHPae: $ret = []; goto H8KCi; DNP2W: p6lR5: goto lKcuf; sBxce: $result = $this->db->get()->result(); goto aHPae; tzIr1: $this->db->order_by("kode_kel_mapel"); goto sBxce; EbqK1: } public function getDataKelompokMapel() { goto Df4uT; uGLmg: $this->db->where("id_parent", "0"); goto VRm_a; Df4uT: $this->db->select("*"); goto aqjdU; VJ2dl: foreach ($result as $row) { $ret[$row->id_kel_mapel] = $row; wr4ur: } goto OX3Kw; kwQBf: $ret = []; goto VJ2dl; VRm_a: $this->db->order_by("kode_kel_mapel"); goto JqNeU; uJ3Qm: return $ret; goto DJCxw; OX3Kw: Be0ej: goto uJ3Qm; JqNeU: $result = $this->db->get()->result(); goto kwQBf; aqjdU: $this->db->from("master_kelompok_mapel"); goto uGLmg; DJCxw: } public function getKategoriKelompokMapel() { goto Qmm_X; q5ykZ: $this->db->where("kategori", "WAJIB")->or_where("kategori", "PAI (Kemenag)"); goto XX9Vq; XX9Vq: $this->db->from("master_kelompok_mapel"); goto YKO3z; YKO3z: $result = $this->db->get()->result(); goto w78ey; w78ey: return $result; goto X1NgK; Qmm_X: $this->db->select("kode_kel_mapel, kategori"); goto q5ykZ; X1NgK: } public function getDataSubKelompokMapel() { goto RcoSx; XAJ15: $this->db->order_by("kode_kel_mapel"); goto bo4Le; pQ29y: $this->db->where("id_parent <> 0"); goto XAJ15; gd8mk: return $ret; goto tp70Q; RcoSx: $this->db->select("*"); goto D7O5V; bCmwi: $ret = []; goto ZkI_q; bo4Le: $result = $this->db->get()->result(); goto bCmwi; ZkI_q: foreach ($result as $row) { $ret[$row->id_kel_mapel] = $row; sfKG3: } goto oip6R; oip6R: VMNqV: goto gd8mk; D7O5V: $this->db->from("master_kelompok_mapel"); goto pQ29y; tp70Q: } public function getDataMapel() { goto JrQjR; JrQjR: $this->datatables->select("id_mapel, nama_mapel, kode"); goto fKJYE; fKJYE: $this->datatables->from("master_mapel"); goto L0xLi; L0xLi: return $this->datatables->generate(); goto vPBOQ; vPBOQ: } public function getAllMapel($arrKelompok = null, $arrMapel = null) { goto LvoU6; CCOES: $this->db->or_where_in("id_mapel", explode(",", $arrMapel)); goto Hi0jI; ua0SL: if (!($arrMapel != null)) { goto maJ9d; } goto CCOES; FyRNc: $this->db->order_by("urutan_tampil"); goto JUVkD; Hi0jI: maJ9d: goto yNjjf; cyo86: $this->db->where_in("kelompok", $arrKelompok); goto x8U7E; JUVkD: return $this->db->get("master_mapel")->result(); goto Zilm0; LvoU6: if (!($arrMapel != null)) { goto l3VqR; } goto cyo86; yNjjf: $this->db->where("status", "1"); goto FyRNc; x8U7E: l3VqR: goto ua0SL; Zilm0: } public function getAllStatusMapel($arrKelompok = null, $arrMapel = null) { goto iFC8d; KWugf: $this->db->or_where_in("id_mapel", explode(",", $arrMapel)); goto T2lXC; LuWeX: k9RTH: goto nXtnI; T2lXC: h9hAa: goto pJQzG; iFC8d: if (!($arrMapel != null)) { goto k9RTH; } goto dV7Ub; nXtnI: if (!($arrMapel != null)) { goto h9hAa; } goto KWugf; dV7Ub: $this->db->where_in("kelompok", $arrKelompok); goto LuWeX; XEE3v: return $this->db->get("master_mapel")->result(); goto rTSTr; pJQzG: $this->db->order_by("urutan_tampil"); goto XEE3v; rTSTr: } public function getAllMapelByKelompok($jenjang) { goto hdwyI; UJv87: $result = $this->db->get("master_mapel")->result(); goto hCDc1; hdwyI: $this->db->where("status", "1"); goto V3sfe; vuqye: foreach ($result as $row) { $ret[$row->kelompok][] = $row; UZ0nx: } goto BOcRh; hCDc1: $ret = []; goto vuqye; BOcRh: B2RCX: goto NOtxE; V3sfe: $this->db->order_by("urutan"); goto jEN5n; jEN5n: $this->db->order_by("urutan_tampil"); goto UJv87; NOtxE: return $ret; goto ZWlw4; ZWlw4: } public function getAllMapelNonAktif($jenjang) { $this->db->where("status", "0"); return $this->db->get("master_mapel")->result(); } public function getMapelById($id, $single = false) { goto KktCK; ABRlU: return $query; goto JlFZo; os7Ib: goto c29t1; goto m5vuW; ld8wr: $this->db->where_in("id_mapel", $id); goto IghKM; IghKM: $this->db->order_by("nama_mapel"); goto i8ZGU; i8ZGU: $query = $this->db->get("master_mapel")->result(); goto Wwq6z; KktCK: if ($single === false) { goto sex2M; } goto TGWC1; TGWC1: $query = $this->db->get_where("master_mapel", array("id_mapel" => $id))->row(); goto os7Ib; m5vuW: sex2M: goto ld8wr; Wwq6z: c29t1: goto ABRlU; JlFZo: } function updateMapel() { goto GDrTs; m7F13: $status = $this->input->post("status", true); goto idfys; idfys: $urut = $this->input->post("urutan_tampil", true); goto obCxv; NqGgY: $this->db->set("urutan_tampil", $urut); goto j229C; j229C: $this->db->where("id_mapel", $id); goto dR21Q; OXSOH: $this->db->set("kode", $kode); goto aVShB; GDrTs: $id = $this->input->post("id_mapel"); goto R2xxV; obCxv: $this->db->set("nama_mapel", $name); goto OXSOH; R2xxV: $name = $this->input->post("nama_mapel", true); goto M8Btu; M8Btu: $kode = $this->input->post("kode_mapel", true); goto AgYBy; dR21Q: return $this->db->update("master_mapel"); goto A1izP; DLFdN: ZHObF: goto WYCql; WYCql: $this->db->set("status", $status); goto NqGgY; Sl2IN: $this->db->set("kelompok", $kelompok); goto DLFdN; AgYBy: $kelompok = $this->input->post("kelompok", true); goto m7F13; aVShB: if (!($kelompok != null)) { goto ZHObF; } goto Sl2IN; A1izP: } public function getAllEkstra() { return $this->db->get("master_ekstra")->result(); } public function getEkstraById($id, $single = false) { goto lA3pt; YD1n8: xzDgG: goto HXnSb; SpqDJ: goto Itqrb; goto YD1n8; PTGqO: $query = $this->db->get("master_ekstra")->result(); goto xJxnG; HXnSb: $this->db->where_in("id_ekstra", $id); goto aLLR2; gdt9H: return $query; goto lfTX1; aLLR2: $this->db->order_by("nama_ekstra"); goto PTGqO; xJxnG: Itqrb: goto gdt9H; YUV44: $query = $this->db->get_where("master_ekstra", array("id_ekstra" => $id))->row(); goto SpqDJ; lA3pt: if ($single === false) { goto xzDgG; } goto YUV44; lfTX1: } function updateEkstra() { goto GQSs8; kuFqh: $kode = $this->input->post("kode_ekstra", true); goto Z3iaU; thT9A: $this->db->where("id_ekstra", $id); goto HxApf; CCno6: $this->db->set("kode_ekstra", $kode); goto thT9A; HxApf: return $this->db->update("master_ekstra"); goto Sg4Gn; Z3iaU: $this->db->set("nama_ekstra", $name); goto CCno6; GQSs8: $id = $this->input->post("id_ekstra"); goto fXp_o; fXp_o: $name = $this->input->post("nama_ekstra", true); goto kuFqh; Sg4Gn: } public function getKelasGuru() { goto xgFSY; BgnO3: $this->datatables->select("kelas_guru.id, guru.id_guru, guru.nip, guru.nama_guru, GROUP_CONCAT(master_kelas.nama_kelas) as kelas"); goto AQKDa; LK76z: return $this->datatables->generate(); goto TJ9VH; uzi16: $this->datatables->join("master_kelas", "kelas_id=id_kelas"); goto Ho_20; Ho_20: $this->datatables->join("master_guru", "guru_id=id_guru"); goto ah0WI; xgFSY: $this->db->query("SET SQL_BIG_SELECTS=1"); goto BgnO3; AQKDa: $this->datatables->from("kelas_guru"); goto uzi16; ah0WI: $this->datatables->group_by("guru.nama_guru"); goto LK76z; TJ9VH: } public function getKelasByGuru($id) { goto leedT; GupgP: return $query; goto GFnPi; viNGn: $query = $this->db->get()->result(); goto GupgP; OOfns: $this->db->from("kelas_guru"); goto E2IzY; E2IzY: $this->db->join("master_kelas", "kelas_guru.kelas_id=kelas.id_kelas"); goto kByXR; kByXR: $this->db->where("guru_id", $id); goto viNGn; leedT: $this->db->select("kelas.id_kelas"); goto OOfns; GFnPi: } public function getAllJabatanGuru($id) { goto TVyg0; ldIWG: if (!$result) { goto HFYji; } goto AVJCE; TL94P: return $ret; goto jrqz2; T1I9q: HFYji: goto TL94P; AVJCE: foreach ($result as $key => $row) { $ret[$row->id_tp][$row->id_smt] = $row->id_kelas; m1p_O: } goto iXGOQ; TVyg0: $result = $this->db->get_where("jabatan_guru", "id_guru=" . $id)->result(); goto ldIWG; iXGOQ: f0Sry: goto T1I9q; jrqz2: } public function getJurusanMapel() { goto LTunJ; IoUC0: $this->datatables->select("jurusan_mapel.id, mapel.id_mapel, mapel.nama_mapel, jurusan.id_jurusan, GROUP_CONCAT(jurusan.nama_jurusan) as nama_jurusan"); goto IeOJs; IeOJs: $this->datatables->from("jurusan_mapel"); goto U9Oaa; fq4OR: $this->datatables->group_by("master_mapel.nama_mapel"); goto Mxpko; Mxpko: return $this->datatables->generate(); goto KY9hJ; JQljR: $this->datatables->join("master_jurusan", "jurusan_id=id_jurusan"); goto fq4OR; U9Oaa: $this->datatables->join("master_mapel", "mapel_id=id_mapel"); goto JQljR; LTunJ: $this->db->query("SET SQL_BIG_SELECTS=1"); goto IoUC0; KY9hJ: } public function getMapel($id = null) { goto FRVA3; MV4nU: if (!($id !== null)) { goto o23rr; } goto mZ_Hj; ZUK_q: $id_mapel = []; goto rud1E; uHSUS: $id_mapel = null; goto IRLx0; uC7e9: QegnJ: goto n1uNM; n1uNM: if (!($id_mapel === [])) { goto pwgzP; } goto uHSUS; k73wX: $mapel = $this->db->get()->result(); goto ZUK_q; dQZjZ: $this->db->where_not_in("id_mapel", $id_mapel); goto M1vKk; M1vKk: return $this->db->get()->result(); goto cSU1Q; mZ_Hj: $this->db->where_not_in("mapel_id", [$id]); goto wl10K; rud1E: foreach ($mapel as $d) { $id_mapel[] = $d->mapel_id; aR0rx: } goto uC7e9; Fsj5H: $this->db->from("master_mapel"); goto dQZjZ; IRLx0: pwgzP: goto AQwva; wl10K: o23rr: goto k73wX; AQwva: $this->db->select("id_mapel, nama_mapel"); goto Fsj5H; MLjB6: $this->db->from("jurusan_mapel"); goto MV4nU; FRVA3: $this->db->select("mapel_id"); goto MLjB6; cSU1Q: } public function getJurusanByIdMapel($id) { goto Rny1t; ZVWim: $this->db->where("mapel_id", $id); goto xfTpg; Rny1t: $this->db->select("jurusan.id_jurusan"); goto L50kk; IA7Z3: $this->db->join("master_jurusan", "jurusan_mapel.jurusan_id=jurusan.id_jurusan"); goto ZVWim; xfTpg: $query = $this->db->get()->result(); goto lvjSF; lvjSF: return $query; goto B9yIF; L50kk: $this->db->from("jurusan_mapel"); goto IA7Z3; B9yIF: } public function getTahunActive() { goto uGqG2; nGcHN: $this->db->where("active", 1); goto H3Pc6; H3Pc6: $result = $this->db->get()->row(); goto PxyTP; I2sXF: $this->db->from("master_tp"); goto nGcHN; PxyTP: return $result; goto jxH0I; uGqG2: $this->db->select("id_tp, tahun"); goto I2sXF; jxH0I: } public function getSemesterActive() { goto RwqTd; ZWztR: $result = $this->db->get()->row(); goto Qte0D; VXR6b: $this->db->from("master_smt"); goto R64nE; RwqTd: $this->db->select("id_smt, nama_smt, smt"); goto VXR6b; Qte0D: return $result; goto LIup0; R64nE: $this->db->where("active", 1); goto ZWztR; LIup0: } public function getJmlHariEfektif($id) { goto U7O8y; U7O8y: $this->db->select("*"); goto gCIM2; Rdq1B: $result = $this->db->get()->row(); goto nhByt; wl6l9: $this->db->where("id_hari_efektif", $id); goto Rdq1B; gCIM2: $this->db->from("master_hari_efektif"); goto wl6l9; nhByt: return $result; goto Iql3k; Iql3k: } public function getDistinctTahunLulus() { goto WMqUZ; doXf1: $result = $this->db->get("buku_induk")->result(); goto CvxkW; sTLPu: foreach ($result as $row) { goto Og5bb; Og5bb: if (!($row->tahun_lulus != '')) { goto b9Nke; } goto Kl7px; Kl7px: $ret[$row->tahun_lulus] = $row->tahun_lulus; goto gIhIp; jcR8y: SpAGR: goto Z6HfI; gIhIp: b9Nke: goto jcR8y; Z6HfI: } goto ejwyi; Gzes4: return $ret; goto N4FGT; WMqUZ: $this->db->select("tahun_lulus"); goto u5y9J; CvxkW: $ret = []; goto sTLPu; ejwyi: hgA9_: goto Gzes4; u5y9J: $this->db->distinct(); goto doXf1; N4FGT: } public function getDistinctKelasAkhir() { goto UxQLI; XwLHy: $this->db->distinct(); goto pqnaR; ltCgB: foreach ($result as $row) { goto cXcIy; RNdQl: $ret[$row->kelas_akhir] = $row->kelas_akhir; goto nOgVR; BCEAC: w3hpX: goto Ob3H5; cXcIy: if (!($row->kelas_akhir != '')) { goto MaQ7V; } goto RNdQl; nOgVR: MaQ7V: goto BCEAC; Ob3H5: } goto PY6mi; PY6mi: eaSjc: goto OJlyu; OJlyu: return $ret; goto MaYV4; J0enK: $ret = []; goto ltCgB; UxQLI: $this->db->select("kelas_akhir"); goto XwLHy; pqnaR: $result = $this->db->get("buku_induk")->result(); goto J0enK; MaYV4: } public function getAlumniByTahun($tahun, $kelas = null) { goto HDmll; HDmll: $this->db->select("*"); goto r1S60; OTEA6: return $this->db->get()->result(); goto PuxPJ; r1S60: $this->db->from("buku_induk a"); goto EsHks; YHxF5: $this->db->where("a.kelas_akhir", $kelas); goto VHrDo; Odyiw: if (!($kelas != null)) { goto zdDjO; } goto YHxF5; YORRm: $this->db->where("a.tahun_lulus", $tahun); goto Odyiw; VHrDo: zdDjO: goto OTEA6; EsHks: $this->db->join("master_siswa b", "a.id_siswa=b.id_siswa"); goto YORRm; PuxPJ: } public function getAlumniById($id) { goto nNQyQ; zLDo0: $this->db->join("buku_induk b", "a.id_siswa=b.id_siswa"); goto eFuu2; ft0kt: return $this->db->get()->row(); goto WluqZ; eFuu2: $this->db->where("a.id_siswa", $id); goto ft0kt; nNQyQ: $this->db->select("*"); goto xvq6r; xvq6r: $this->db->from("master_siswa a"); goto zLDo0; WluqZ: } public function getAllWaliKelas() { goto aYErM; WANB2: $this->db->from("jabatan_guru a"); goto UGilb; pizv0: $ret = []; goto dfF5m; aYErM: $this->db->query("SET SQL_BIG_SELECTS=1"); goto W7jU9; sQGhn: $result = $this->db->get()->result(); goto pizv0; zxsCa: foreach ($result as $key => $row) { goto uUXxw; uKTcA: $ret[$row->id_tp][$row->id_smt][$row->id_kelas] = $row; goto ymSAd; ENYGU: ORF7u: goto YTE3n; ymSAd: vzbZY: goto ENYGU; uUXxw: if (!($row->id_level == "4")) { goto vzbZY; } goto uKTcA; YTE3n: } goto VtE2S; t092S: Mx1dX: goto EVdi4; t9O7R: $this->db->join("level_guru c", "a.id_jabatan=c.id_level", "left"); goto zxMHe; zxMHe: $this->db->join("master_kelas d", "a.id_kelas=d.id_kelas", "left"); goto sQGhn; UGilb: $this->db->join("master_guru b", "a.id_guru=b.id_guru", "left"); goto t9O7R; dfF5m: if (!$result) { goto Mx1dX; } goto zxsCa; W7jU9: $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 WANB2; VtE2S: OQVBn: goto t092S; EVdi4: return $ret; goto qZeGI; qZeGI: } public function getAllGuru() { goto IT5J0; GHJQv: return $this->db->get()->result(); goto RF2u6; Eo3C2: $id_guru = []; goto eDWCm; eDWCm: foreach ($guru as $d) { $id_guru[] = $d->id_guru; nX1W1: } goto aE9yp; IT5J0: $this->db->select("id_guru"); goto ePMQd; YE5Vz: $this->db->where_in("id_guru", $id_guru); goto GHJQv; TTq1C: $this->db->from("master_guru"); goto YE5Vz; NBOPj: $guru = $this->db->get()->result(); goto Eo3C2; ePMQd: $this->db->from("jabatan_guru"); goto NBOPj; aE9yp: Yyku1: goto H5jlM; H5jlM: $this->db->select("id_guru, nip, nama_guru"); goto TTq1C; RF2u6: } public function getAllKelas($tp = null, $smt = null) { goto A_AeP; Ym_7K: $this->db->join("jabatan_guru f", "f.id_kelas=a.id_kelas", "left"); goto QFt1J; mhQpj: JN3ue: goto ehVU3; dJQiu: if (!$result) { goto JN3ue; } goto XUJUT; fPgrD: if (!$result) { goto Qu7au; } goto glVMT; Nc83o: $this->db->join("master_guru c", "f.id_guru=c.id_guru", "left"); goto wY7mk; BaSvA: Qu7au: goto vsAOd; vsAOd: goto YPCiR; goto P8Vs7; qFPHs: if ($tp != null && $smt != null) { goto Wg3qd; } goto fPgrD; wY7mk: $this->db->order_by("a.nama_kelas"); goto tkUsM; XUJUT: foreach ($result as $key => $row) { $ret[$row->id_kelas] = $row; qTBLE: } goto Nm5a9; A_AeP: $this->db->query("SET SQL_BIG_SELECTS=1"); goto PyQSN; SZRjR: $ret = []; goto qFPHs; WBTkP: $this->db->from("master_kelas a"); goto EXNI0; EXNI0: if (!($tp != null && $smt != null)) { goto sDN8S; } goto f9Oxm; tkUsM: $result = $this->db->get()->result(); goto SZRjR; Nm5a9: KyLMS: goto mhQpj; f9Oxm: $this->db->where("a.id_tp", $tp)->where("a.id_smt", $smt); goto Hhw4c; Hhw4c: sDN8S: goto Ym_7K; glVMT: foreach ($result as $key => $row) { $ret[$row->id_tp][$row->id_smt][$row->id_kelas] = $row; qA6dj: } goto C1akH; QFt1J: $this->db->join("master_jurusan b", "a.jurusan_id=b.id_jurusan", "left"); goto Nc83o; ehVU3: YPCiR: goto ehtJK; P8Vs7: Wg3qd: goto dJQiu; PyQSN: $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 WBTkP; C1akH: iZ7rM: goto BaSvA; ehtJK: return $ret; goto DixW7; DixW7: } public function getAllKelasSiswa() { goto F8QRi; F8QRi: $this->db->select("*"); goto aq4ms; aq4ms: $this->db->from("kelas_siswa"); goto kbWUo; SMXUX: return $ret; goto vuxQk; kbWUo: $result = $this->db->get()->result(); goto da92W; v0Vv9: LUh_8: goto wpWNY; S1Dm9: if (!$result) { goto BbbqK; } goto aPdFP; da92W: $ret = []; goto S1Dm9; aPdFP: foreach ($result as $key => $row) { $ret[$row->id_kelas][$row->id_siswa] = $row; bNu65: } goto v0Vv9; wpWNY: BbbqK: goto SMXUX; vuxQk: } public function getDataInduk() { goto Rluvv; g3dJE: MGO1B: goto lpnDR; ZqEn9: $result = $this->db->get()->result(); goto EQeXs; bU2o3: $this->db->order_by("a.nama", "ASC"); goto ZqEn9; bc70r: wTLy9: goto g3dJE; mUQPA: if (!$result) { goto MGO1B; } goto J1sPX; QBLOX: $this->db->join("buku_induk b", "a.id_siswa=b.id_siswa", "left"); goto bU2o3; J1sPX: foreach ($result as $key => $row) { $ret[$row->id_siswa] = $row; d4NIx: } goto bc70r; EQeXs: $ret = []; goto mUQPA; Rluvv: $this->db->select("a.*, b.*,"); goto HhbbI; lpnDR: return $ret; goto tIxTC; HhbbI: $this->db->from("master_siswa a"); goto QBLOX; tIxTC: } } 
 ?>

Did this file decode correctly?

Original Code

<?php
/*   ________________________________________
    |                 GarudaCBT              |
    |    https://github.com/garudacbt/cbt    |
    |________________________________________|
*/
 defined("\x42\101\123\105\120\x41\x54\110") or exit("\x4e\x6f\x20\x64\x69\x72\x65\143\164\x20\x73\143\x72\151\160\164\40\141\143\143\145\x73\163\x20\141\x6c\x6c\x6f\x77\145\x64"); class Master_model extends CI_Model { public function create($table, $data, $batch = false) { goto N_RkL; FrJgk: goto h1C6K; goto UXoxE; J49f5: h1C6K: goto UQSGy; N_RkL: if ($batch === false) { goto Lh_vO; } goto sDk0b; ZNjXZ: $insert = $this->db->insert($table, $data); goto J49f5; UXoxE: Lh_vO: goto ZNjXZ; UQSGy: return $insert; goto A4Gum; sDk0b: $insert = $this->db->insert_batch($table, $data); goto FrJgk; A4Gum: } public function update($table, $data, $pk, $id = null, $batch = false) { goto MIiKy; YhPwO: goto QxQqA; goto X7gVo; Mjy6u: QxQqA: goto fSwoF; fSwoF: return $insert; goto vCwtv; X7gVo: sP1pC: goto Mn9SS; MIiKy: if ($batch === false) { goto sP1pC; } goto mz9_3; Mn9SS: $insert = $this->db->update($table, $data, array($pk => $id)); goto Mjy6u; mz9_3: $insert = $this->db->update_batch($table, $data, $pk); goto YhPwO; vCwtv: } 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 hB5Sm; xFiJ0: return $this->db->delete($table); goto rosWt; hB5Sm: $this->db->where_in($pk, $data); goto u7oFN; u7oFN: $this->db->where($col . "\41\x3d" . $not); goto xFiJ0; rosWt: } public function getDataKelas() { goto OQhGT; OQhGT: $this->datatables->select("\x69\144\x5f\x6b\x65\154\x61\x73\54\40\x6e\141\155\141\137\x6b\145\154\x61\x73\54\40\x69\x64\137\x6a\x75\x72\165\163\141\156\54\40\156\x61\x6d\x61\x5f\x6a\165\x72\x75\163\x61\x6e"); goto gsT46; PsfZM: $this->datatables->add_column("\x62\x75\154\153\137\163\145\x6c\145\x63\x74", "\74\144\151\166\40\x63\154\141\x73\163\75\42\164\145\170\x74\x2d\x63\x65\x6e\x74\x65\x72\x22\x3e\x3c\151\156\160\165\164\40\x74\171\x70\x65\x3d\x22\143\150\145\x63\x6b\142\x6f\170\x22\40\143\154\141\163\x73\x3d\42\143\150\145\x63\153\42\x20\x6e\x61\x6d\x65\75\42\143\x68\x65\143\x6b\145\144\x5b\x5d\42\x20\166\141\154\x75\145\75\x22\x24\61\x22\x2f\76\x3c\x2f\144\151\166\x3e", "\x69\x64\137\x6b\145\154\141\x73\54\x20\156\141\155\x61\137\153\145\154\x61\163\54\x20\151\x64\137\x6a\x75\x72\165\x73\x61\156\x2c\40\156\141\155\x61\x5f\x6a\165\162\165\163\x61\156"); goto NCcpH; gsT46: $this->datatables->from("\155\x61\x73\164\x65\162\137\x6b\145\x6c\x61\x73"); goto xSU3s; NCcpH: return $this->datatables->generate(); goto X9xxH; xSU3s: $this->datatables->join("\155\x61\x73\x74\x65\162\137\152\165\x72\x75\x73\x61\156", "\x6a\x75\x72\x75\163\141\156\x5f\151\144\75\x69\x64\137\x6a\x75\x72\x75\x73\x61\x6e"); goto PsfZM; X9xxH: } public function getKelasById($id) { goto qfevV; Sd_Dh: return $query; goto zZhj0; dPk12: $this->db->order_by("\156\141\155\x61\137\x6b\x65\154\141\x73"); goto mev6V; qfevV: $this->db->select("\x69\144\137\153\145\x6c\141\163\x2c\x20\x6e\x61\x6d\141\x5f\x6b\x65\x6c\x61\x73\54\x20\154\145\166\145\x6c\x5f\151\x64"); goto rPddv; rPddv: $this->db->from("\x6d\x61\x73\164\x65\x72\x5f\x6b\145\x6c\x61\163"); goto G1FJO; G1FJO: $this->db->where("\x69\x64\137\153\x65\x6c\x61\x73", $id); goto dPk12; mev6V: $query = $this->db->get()->row(); goto Sd_Dh; zZhj0: } public function getDataJurusan() { goto W0GHV; GgBTx: $result = $this->db->get()->result(); goto umnHU; W0GHV: $this->db->select("\x2a"); goto no3ph; umnHU: return $result; goto WfeUG; no3ph: $this->db->from("\x6d\141\163\164\x65\162\137\152\x75\162\165\163\x61\156"); goto GgBTx; WfeUG: } public function getDataJurusanMapel($arrIds) { goto X8iYG; QXdZy: $ret = []; goto NqQo2; nQc83: Dyyqo: goto BnewP; WLT5k: $this->db->where_in("\151\144\x5f\155\141\x70\145\x6c", $arrIds); goto ln11q; ln11q: $result = $this->db->get()->result(); goto QXdZy; X8iYG: $this->db->select("\x69\144\137\x6d\141\160\x65\x6c\54\40\x6e\x61\x6d\141\137\x6d\141\160\145\154"); goto IGpGY; BnewP: return $ret; goto qPyEY; IGpGY: $this->db->from("\155\x61\163\x74\x65\x72\x5f\x6d\x61\x70\x65\x6c"); goto WLT5k; NqQo2: if (!$result) { goto Dyyqo; } goto Bva6b; Bva6b: foreach ($result as $key => $row) { $ret[$row->id_mapel] = $row->nama_mapel; Uh0Rn: } goto eeEzu; eeEzu: FfJKT: goto nQc83; qPyEY: } public function getDataTableJurusan() { goto dVgD1; Ennk0: $this->db->order_by("\151\x64\x5f\152\165\x72\x75\x73\x61\156"); goto dOs4S; dVgD1: $this->datatables->select("\x2a"); goto bUQ_M; dOs4S: return $this->datatables->generate(); goto S1m6_; bUQ_M: $this->datatables->from("\155\141\163\164\x65\162\137\152\x75\162\165\163\x61\x6e"); goto Ennk0; S1m6_: } public function getJurusanById($id) { goto PrxnW; Psug6: $this->db->order_by("\x6e\141\x6d\x61\137\152\165\162\165\x73\141\x6e"); goto vqb1p; PrxnW: $this->db->where_in("\x69\144\x5f\x6a\165\162\165\x73\x61\156", $id); goto Psug6; juSXP: return $query; goto ov0kC; vqb1p: $query = $this->db->get("\155\141\x73\164\145\x72\137\152\165\x72\165\x73\141\x6e")->result(); goto juSXP; ov0kC: } function updateJurusan() { goto MzOla; E3x23: $check_mapel = $this->input->post("\155\x61\x70\145\x6c", true); goto dLC8O; XVo_S: $kode = $this->input->post("\x6b\x6f\x64\x65\x5f\x6a\x75\162\165\163\141\x6e", true); goto qug9L; eRcDe: QCP2B: goto MCyx8; dLC8O: if (!$check_mapel) { goto QCP2B; } goto tpdKi; qug9L: $mapels = []; goto E3x23; A_kVV: $i++; goto K2mBY; MzOla: $id = $this->input->post("\x69\144\x5f\152\x75\x72\x75\x73\141\156"); goto qLqd7; lT9J_: $i = 0; goto V5VWg; V5VWg: m0RWu: goto xYJfA; xYJfA: if (!($i <= $row_mapels)) { goto FlaJU; } goto bWyjU; lS0zR: $this->db->set("\x6d\141\x70\145\154\x5f\160\145\155\x69\156\x61\x74\141\156", implode("\x2c", $mapels)); goto ovByL; vP9dM: FlaJU: goto eRcDe; p6CYT: $this->db->set("\153\x6f\144\145\x5f\152\x75\162\165\163\141\156", $kode); goto lS0zR; tpdKi: $row_mapels = count($this->input->post("\155\x61\160\x65\154", true)); goto lT9J_; OkCGI: return $this->db->update("\155\141\163\164\x65\x72\137\152\x75\162\165\x73\x61\x6e"); goto lZIJd; MCyx8: $this->db->set("\x6e\x61\x6d\x61\137\152\x75\x72\x75\163\x61\x6e", $name); goto p6CYT; qLqd7: $name = $this->input->post("\x6e\x61\x6d\x61\x5f\152\x75\x72\165\x73\x61\156", true); goto XVo_S; EWe3k: $this->db->where("\151\144\x5f\x6a\x75\162\165\163\141\x6e", $id); goto OkCGI; K2mBY: goto m0RWu; goto vP9dM; oZ3IS: m5oNX: goto A_kVV; ovByL: $this->db->set("\163\164\141\x74\165\x73", "\x31"); goto EWe3k; bWyjU: array_push($mapels, $this->input->post("\x6d\141\x70\145\154\133" . $i . "\135", true)); goto oZ3IS; lZIJd: } public function inputJurusan() { $data = ["\156\x61\x6d\x61\x5f\x6a\165\x72\165\x73\141\156" => $this->input->post("\x6e\141\x6d\141\x5f\152\165\x72\x75\163\x61\x6e", true), "\153\157\144\145\x5f\x6a\x75\x72\x75\x73\141\156" => $this->input->post("\x6b\x6f\x64\145\x5f\x6a\x75\x72\165\163\x61\156", true)]; return $this->db->insert("\x6d\x61\163\164\x65\162\137\152\165\x72\x75\163\x61\156", $data); } public function getAllDataSiswa($id_tp, $id_smt) { goto WcJ8L; HX2hb: $this->db->join("\x6b\145\154\141\163\x5f\163\x69\x73\167\x61\x20\142", "\x62\x2e\x69\x64\x5f\x73\151\163\x77\x61\x3d\141\56\151\144\x5f\163\151\163\167\141\40\101\116\x44\x20\142\x2e\x69\x64\137\164\160\75" . $id_tp . "\40\101\x4e\104\x20\x62\56\151\x64\x5f\163\155\164\x3d" . $id_smt . '', "\x6c\x65\146\x74"); goto syRe6; cckOh: $this->db->from("\x6d\x61\x73\x74\145\x72\x5f\163\151\x73\x77\x61\40\x61"); goto HX2hb; fS_G6: $this->db->select("\x61\56\x2a\54\40\x63\56\156\141\x6d\141\x5f\x6b\145\154\x61\163"); goto cckOh; WcJ8L: $this->db->query("\x53\x45\x54\x20\x53\x51\114\137\102\111\107\x5f\123\x45\x4c\x45\103\x54\x53\x3d\x31"); goto fS_G6; KKjJr: return $query->result(); goto xPLhe; XWmuB: $query = $this->db->get(); goto KKjJr; Xm_xe: $this->db->order_by("\x61\x2e\x6e\x61\x6d\141"); goto XWmuB; syRe6: $this->db->join("\x6d\x61\163\x74\x65\x72\x5f\153\x65\154\x61\163\x20\x63", "\143\56\151\x64\137\153\145\154\141\163\75\x62\56\x69\x64\x5f\153\145\154\x61\x73", "\x6c\145\146\164"); goto hD28I; hD28I: $this->db->order_by("\x62\x2e\151\x64\137\x6b\145\x6c\x61\x73"); goto Xm_xe; xPLhe: } public function getSiswaByKelas($id_tp, $id_smt, $id_kelas) { goto B5QtA; OITO6: $this->db->order_by("\142\x2e\156\x61\x6d\141", "\101\123\x43"); goto S2OTP; S2OTP: return $this->db->get()->result(); goto jbeD1; N9ulY: $this->db->join("\155\x61\x73\x74\145\x72\137\163\x69\163\167\x61\x20\x62", "\142\56\151\x64\137\163\151\163\x77\x61\x3d\141\56\x69\x64\137\x73\x69\x73\x77\141"); goto kJyfN; B5QtA: $this->db->select("\x62\56\52"); goto hoMQy; fMvcl: $this->db->where("\141\x2e\151\x64\x5f\x6b\145\154\x61\163", $id_kelas); goto OITO6; Qlw_a: $this->db->where("\x61\56\151\144\137\x73\x6d\164", $id_smt); goto XYFGy; XYFGy: $this->db->where("\141\56\151\144\x5f\x73\x69\x73\167\x61\40\151\163\40\x4e\117\x54\40\116\x55\x4c\114", NULL, FALSE); goto lqxb1; kJyfN: $this->db->where("\141\56\151\144\x5f\164\160", $id_tp); goto Qlw_a; hoMQy: $this->db->from("\x6b\145\154\x61\x73\x5f\163\x69\163\167\x61\40\x61"); goto N9ulY; lqxb1: $this->db->where("\x62\56\x69\144\x5f\163\x69\x73\167\x61\x20\x69\163\40\x4e\117\124\40\x4e\x55\x4c\x4c", NULL, FALSE); goto fMvcl; jbeD1: } public function getDataSiswa($id_tp, $id_smt) { goto FfljU; nWaob: $this->datatables->join("\x6d\x61\x73\164\x65\x72\x5f\153\145\x6c\x61\x73\x20\146", "\146\x2e\151\144\x5f\153\x65\x6c\x61\x73\75\144\x2e\x69\144\137\x6b\145\154\141\163", "\154\x65\146\x74"); goto deHE4; RuWua: $this->db->order_by("\x62\x2e\163\x74\141\164\165\163", "\101\x53\x43"); goto Ep0yO; FfljU: $this->db->query("\x53\105\x54\40\x53\x51\x4c\x5f\x42\x49\x47\137\123\105\114\x45\103\124\123\75\61"); goto CazEg; CazEg: $this->datatables->select("\x61\56\151\144\x5f\163\x69\x73\167\x61\x2c\x20\141\x2e\x66\157\x74\157\54\x20\141\x2e\156\x61\x6d\x61\54\x20\x61\x2e\156\151\x73\54\40\141\56\156\151\163\x6e\x2c\x20\141\56\152\145\x6e\151\x73\x5f\153\x65\x6c\x61\x6d\x69\156\x2c\x20\x66\56\x6c\x65\x76\x65\x6c\137\151\x64\54\40\x66\56\156\141\x6d\x61\137\x6b\x65\x6c\141\x73\54\40\x62\x2e\163\x74\141\164\165\163"); goto x5kWt; dfAFl: $this->datatables->join("\153\145\154\141\163\137\x73\151\163\x77\141\x20\144", "\144\56\151\x64\x5f\163\x69\163\x77\141\x20\75\40\141\56\x69\144\137\163\x69\163\x77\141\40\x41\x4e\x44\x20\x64\x2e\x69\144\137\164\x70\40\75\x20" . $id_tp . "\x20\x41\116\104\x20\144\56\151\x64\137\163\155\164\40\x3d\40" . $id_smt . '', "\x6c\x65\x66\x74"); goto nWaob; x5kWt: $this->datatables->from("\155\x61\x73\164\145\x72\137\x73\x69\163\x77\x61\40\x61"); goto d9X4j; d9X4j: $this->datatables->join("\142\x75\x6b\165\137\151\x6e\144\x75\153\x20\x62", "\x61\56\x69\x64\137\163\x69\x73\x77\x61\x3d\x62\56\x69\144\137\163\x69\x73\x77\x61", "\x6c\145\146\x74"); goto mb1Ed; qKS35: $this->db->order_by("\x66\x2e\156\x61\155\141\x5f\153\145\x6c\141\163", "\101\x53\x43"); goto RuWua; mb1Ed: $this->datatables->join("\x75\x73\145\162\163\40\143", "\x61\x2e\x75\163\145\x72\156\141\x6d\145\75\x63\x2e\165\x73\x65\162\x6e\x61\x6d\145"); goto dfAFl; deHE4: $this->db->order_by("\111\123\116\125\x4c\114\50\x66\x2e\x6c\x65\166\145\x6c\x5f\151\x64\x29\x2c\x20\146\56\154\x65\x76\145\x6c\x5f\151\x64\40\101\123\103"); goto qKS35; Ep0yO: return $this->datatables->generate(); goto Fe4Ks; Fe4Ks: } public function getAllSiswa($id_tp, $id_smt, $offset, $limit, $search = null, $sort = null, $order = null) { goto W1yIB; dAxtx: $this->db->join("\153\145\154\x61\163\x5f\x73\x69\163\x77\x61\40\144", "\x64\56\x69\144\137\x73\x69\x73\x77\141\40\75\40\141\56\151\144\137\163\x69\x73\x77\141\x20\x41\116\x44\x20\x64\56\151\x64\137\164\160\40\75\40" . $id_tp . "\40\101\x4e\x44\x20\144\x2e\151\144\137\163\155\x74\40\75\x20" . $id_smt . '', "\x6c\145\146\x74"); goto WPb4U; vSa4p: $this->db->order_by("\x61\x2e\x6e\x61\155\141", "\101\x53\103"); goto dAxtx; WPb4U: $this->db->join("\x6d\x61\x73\x74\145\162\x5f\153\145\x6c\x61\163\40\x66", "\x66\x2e\151\144\x5f\x6b\x65\154\x61\x73\x3d\x64\x2e\151\144\x5f\153\x65\x6c\x61\163", "\154\145\x66\x74"); goto opggK; W1yIB: $this->db->select("\x61\x2e\151\x64\x5f\x73\151\x73\x77\141\54\x20\141\x2e\146\x6f\164\x6f\x2c\x20\141\56\156\x61\155\x61\x2c\40\x61\56\156\x69\163\54\40\141\x2e\x6e\x69\163\x6e\x2c\x20\141\x2e\152\145\x6e\151\163\x5f\153\x65\154\141\x6d\x69\156\54\x20\146\x2e\154\145\166\145\x6c\x5f\x69\x64\x2c\40\146\x2e\156\x61\x6d\x61\137\153\145\154\141\163\54" . "\x20\50\123\x45\x4c\105\103\x54\x20\x43\117\x55\116\x54\x28\151\x64\51\x20\106\122\x4f\x4d\40\x75\x73\145\x72\x73\x20\127\110\x45\x52\105\x20\165\163\145\162\163\x2e\165\x73\145\x72\x6e\141\155\145\40\x3d\40\141\x2e\165\x73\145\x72\156\141\x6d\x65\x29\x20\101\x53\40\x73\164\x61\164\x75\x73"); goto fcTBO; fcTBO: $this->db->from("\155\x61\x73\x74\x65\x72\137\x73\151\x73\167\141\40\141"); goto QDrZB; opggK: if (!($search != null)) { goto PwBOD; } goto fCJP2; du1BW: $this->db->or_like("\x61\56\x6e\x69\163", $search); goto m3j3f; tMaxd: return $this->db->get()->result(); goto hidU3; fCJP2: $this->db->like("\141\x2e\x6e\141\155\141", $search); goto du1BW; QDrZB: $this->db->limit($limit, $offset); goto vSa4p; dQgqe: PwBOD: goto tMaxd; m3j3f: $this->db->or_like("\x61\56\x6e\x69\x73\x6e", $search); goto dQgqe; hidU3: } public function getSiswaPage($id_tp, $id_smt, $offset, $limit, $search = null, $sort = null, $order = null) { goto dWcig; dWcig: $this->db->select("\x61\x2e\151\144\137\163\151\x73\x77\x61\x2c\x20\141\x2e\x66\157\x74\157\54\x20\141\x2e\x6e\x61\155\141\54\x20\141\x2e\x6e\x69\163\54\40\141\56\x6e\x69\x73\156\x2c\40\x61\56\152\145\156\151\x73\137\x6b\x65\x6c\141\x6d\151\x6e\x2c\x20\144\56\151\x64\x5f\153\x65\154\x61\163\54\x20" . "\146\x2e\x6e\141\x6d\x61\x5f\153\x65\x6c\141\163\54\40\50\x53\x45\x4c\x45\103\124\40\x43\x4f\x55\116\124\50\151\x64\51\40\106\122\117\x4d\x20\165\163\145\x72\163\40\127\x48\x45\x52\x45\40\165\163\x65\x72\x73\x2e\165\163\x65\x72\156\x61\155\145\x20\x3d\40\141\56\165\x73\x65\x72\x6e\x61\x6d\x65\51\40\101\123\x20\141\153\164\x69\x66"); goto ug6ty; JkHz1: ontWX: goto ougK2; o5Lvu: $this->db->or_like("\141\x2e\156\151\x73\156", $search); goto JkHz1; Ul3yx: $this->db->order_by("\x49\x53\116\125\114\114\50\146\56\x6c\145\166\145\x6c\x5f\x69\x64\51\x2c\40\146\56\x6c\x65\166\x65\154\137\x69\x64\x20\x41\123\x43"); goto YN_Pk; xOIzz: $this->db->order_by("\x61\56\156\141\x6d\x61", "\x41\123\x43"); goto jnHg9; jnHg9: if (!($search != null)) { goto ontWX; } goto Iybgy; Iybgy: $this->db->like("\141\x2e\156\141\x6d\x61", $search); goto Vh3c0; ougK2: return $this->db->get()->result(); goto fsl1M; YN_Pk: $this->db->order_by("\x66\56\156\141\x6d\x61\137\x6b\145\x6c\x61\x73", "\x41\123\x43"); goto xOIzz; bzlZ5: $this->db->join("\155\141\163\x74\x65\x72\x5f\153\x65\154\141\163\x20\146", "\146\56\151\144\x5f\153\x65\154\x61\163\x3d\144\x2e\x69\x64\137\x6b\145\154\x61\x73", "\154\x65\x66\x74"); goto Ul3yx; TOuou: $this->db->limit($limit, $offset); goto s40iU; s40iU: $this->db->join("\153\x65\154\141\x73\137\163\151\x73\167\x61\x20\144", "\144\x2e\x69\x64\137\163\x69\x73\x77\x61\75\x61\x2e\151\144\137\x73\151\163\167\x61\40\101\116\104\x20\144\x2e\x69\x64\137\164\160\x20\75\40" . $id_tp . "\40\x41\x4e\104\x20\144\56\x69\144\x5f\x73\x6d\x74\40\75\40" . $id_smt . '', "\x6c\x65\x66\x74"); goto bzlZ5; Vh3c0: $this->db->or_like("\x61\x2e\x6e\151\x73", $search); goto o5Lvu; ug6ty: $this->db->from("\155\141\163\164\145\162\137\x73\x69\x73\x77\141\40\x61"); goto TOuou; fsl1M: } public function getSiswaTotalPage($search = null) { goto WEFJH; GBwIB: $this->db->or_like("\x6e\x69\x73\x6e", $search); goto KfCcl; gcfDX: return $this->db->get()->num_rows(); goto zTlli; Jc8Jh: $this->db->from("\x6d\141\x73\164\145\162\137\x73\151\163\167\141"); goto o8Q5A; TZx63: $this->db->like("\156\x61\x6d\x61", $search); goto oe4T2; KfCcl: exbKh: goto gcfDX; oe4T2: $this->db->or_like("\x6e\x69\x73", $search); goto GBwIB; o8Q5A: if (!($search != null)) { goto exbKh; } goto TZx63; WEFJH: $this->db->select("\x69\144\x5f\x73\x69\163\x77\x61"); goto Jc8Jh; zTlli: } public function getDataSiswaByKelas($id_tp, $id_smt, $id_kelas, $offset, $limit, $search = null, $sort = null, $order = null) { goto avfAM; cjdBg: bJTYv: goto FpLAZ; kf6g9: if (!($search != null)) { goto bJTYv; } goto Fz7lc; b3Jts: $this->db->join("\x6d\x61\163\x74\x65\162\x5f\x6b\x65\154\141\x73\40\146", "\x66\x2e\x69\144\137\153\x65\154\x61\x73\75\x61\56\x69\x64\137\x6b\x65\154\x61\163"); goto kf6g9; Fz7lc: $this->db->like("\142\56\x6e\x61\x6d\141", $search); goto XKCQJ; btMkk: $this->db->where("\x61\x2e\x69\x64\137\x6b\x65\154\141\x73", $id_kelas); goto jpwg7; qw6Me: $this->db->or_like("\x62\56\x6e\x69\163\x6e", $search); goto cjdBg; avfAM: $this->db->select("\x62\56\151\144\x5f\x73\151\163\167\x61\x2c\x20\142\56\x6e\x61\155\141\54\x20\x62\x2e\156\151\163\54\x20\x62\56\156\151\163\x6e\x2c\40\x62\56\x6a\145\156\x69\163\x5f\153\x65\x6c\141\155\151\156\54\x20\142\56\165\163\x65\x72\156\141\155\x65\x2c\40\x62\x2e\x70\141\x73\x73\x77\157\x72\x64\x2c\40\142\x2e\146\x6f\x74\x6f\x2c" . "\40\146\56\x6e\141\x6d\141\137\153\x65\154\141\163\54\40\x28\123\x45\x4c\x45\103\124\40\x43\117\125\116\124\x28\x69\x64\x29\x20\106\x52\117\x4d\40\x75\163\x65\162\x73\40\127\x48\x45\x52\x45\x20\x75\163\x65\162\163\x2e\165\x73\x65\x72\156\141\x6d\145\40\x3d\x20\x62\56\165\x73\145\x72\x6e\141\x6d\x65\x29\40\x41\123\x20\141\x6b\164\x69\146"); goto yYb3G; yYb3G: $this->db->from("\153\145\154\141\163\x5f\x73\x69\163\167\x61\x20\x61"); goto zVTqv; hQxOx: $this->db->join("\x6d\141\163\x74\x65\162\x5f\x73\151\163\x77\x61\x20\142", "\x62\x2e\151\144\x5f\x73\x69\x73\167\141\75\x61\56\151\x64\x5f\x73\151\163\x77\x61"); goto b3Jts; K0l3h: $this->db->where("\x61\56\151\144\x5f\x73\x6d\164", $id_smt); goto btMkk; FpLAZ: $this->db->where("\x61\x2e\151\144\137\x74\160", $id_tp); goto K0l3h; jpwg7: return $this->db->get()->result(); goto Ku1Al; XKCQJ: $this->db->or_like("\x62\56\156\x69\163", $search); goto qw6Me; zVTqv: $this->db->limit($limit, $offset); goto hQxOx; Ku1Al: } public function getDataSiswaByKelasPage($id_tp, $id_smt, $id_kelas, $search = null) { goto OevcT; T25mV: $this->db->like("\x62\x2e\x6e\x61\x6d\x61", $search); goto jPUh5; uVAjB: return $this->db->get()->num_rows(); goto s3jF6; lcGee: fq4ug: goto uVAjB; OevcT: $this->db->select("\141\x2e\151\x64\x5f\x73\151\x73\x77\x61"); goto IGTys; HPwsR: $this->db->where("\x61\56\151\x64\137\x6b\145\154\141\x73", $id_kelas); goto XEAKc; jPUh5: $this->db->or_like("\x62\x2e\156\151\163", $search); goto QqlVa; D7kgX: if (!($search != null)) { goto fq4ug; } goto T25mV; XEAKc: $this->db->join("\155\x61\x73\164\x65\162\x5f\x73\x69\x73\167\141\x20\x62", "\x62\x2e\151\x64\x5f\x73\151\x73\167\x61\75\141\x2e\151\144\137\x73\x69\163\167\x61"); goto D7kgX; WSI_V: $this->db->where("\x61\56\x69\144\137\x73\x6d\x74", $id_smt); goto HPwsR; d6JlA: $this->db->where("\x61\x2e\151\144\137\164\160", $id_tp); goto WSI_V; QqlVa: $this->db->or_like("\x62\x2e\156\151\x73\x6e", $search); goto lcGee; IGTys: $this->db->from("\x6b\x65\154\x61\x73\137\x73\x69\163\167\x61\40\x61"); goto d6JlA; s3jF6: } public function getSiswaById($id) { goto CNQlx; QBHcM: $this->db->where("\x61\x2e\x69\x64\x5f\x73\x69\163\167\x61", $id); goto Ike2F; r9E6M: $this->db->from("\x6d\x61\163\164\x65\x72\137\x73\x69\163\x77\x61\x20\x61"); goto wO1oo; Ike2F: return $this->db->get()->row(); goto LpWP2; wO1oo: $this->db->join("\x62\x75\153\165\x5f\x69\156\x64\x75\153\x20\142", "\141\56\x69\144\137\163\x69\163\x77\x61\75\x62\x2e\151\144\137\163\x69\163\x77\x61", "\x6c\x65\x66\x74"); goto QBHcM; CNQlx: $this->db->select("\141\56\52\x2c\40\142\x2e\163\x74\141\164\165\163"); goto r9E6M; LpWP2: } public function getSiswaKelasBaru($id_tp, $id_smt) { goto Xan0R; J94q2: $result = $this->db->get()->result(); goto ZH4hJ; FeBcJ: $this->db->where("\141\56\x69\x64\137\x74\160", $id_tp); goto u5F74; zVTVn: C6Slk: goto Wo1aA; s_ar4: $this->db->select("\x62\56\x69\x64\x5f\x73\151\163\x77\141\54\x20\x62\x2e\156\141\x6d\141\x2c\40\146\56\151\x64\x5f\x6b\145\x6c\141\163\54\40\146\x2e\156\141\155\x61\x5f\153\x65\154\141\x73\54\x20\x66\x2e\x6b\157\144\x65\137\x6b\145\154\x61\x73"); goto EyXTO; ZH4hJ: $ret = []; goto Nf1si; stwjQ: return $ret; goto fnsUt; dmngo: foreach ($result as $key => $row) { $ret[$row->id_siswa] = $row; m5Bgd: } goto zVTVn; u5F74: $this->db->where("\141\56\x69\x64\x5f\163\155\164", $id_smt); goto J94q2; V5pFW: $this->db->join("\x6d\x61\163\x74\x65\162\x5f\x6b\x65\x6c\x61\x73\40\146", "\x66\x2e\x69\x64\137\x6b\145\x6c\141\163\75\141\56\x69\144\x5f\x6b\145\154\141\x73"); goto FeBcJ; Xan0R: $this->db->query("\123\105\124\40\123\121\114\137\102\111\107\x5f\123\105\x4c\x45\x43\124\123\75\61"); goto s_ar4; EyXTO: $this->db->from("\153\145\x6c\141\163\x5f\163\151\163\167\x61\x20\141"); goto Oe8lk; Wo1aA: ze9Sc: goto stwjQ; Oe8lk: $this->db->join("\x6d\141\163\x74\x65\162\x5f\x73\x69\163\x77\141\40\142", "\x62\56\x69\x64\x5f\x73\151\163\x77\x61\75\x61\56\x69\x64\137\163\151\163\x77\141"); goto V5pFW; Nf1si: if (!$result) { goto ze9Sc; } goto dmngo; fnsUt: } public function getDataSiswaById($id_tp, $id_smt, $idSiswa) { goto TShnT; LWxTA: $this->db->join("\155\x61\x73\x74\x65\162\137\x73\x69\163\x77\141\40\x62", "\x62\56\x69\144\x5f\163\x69\163\x77\141\75\x61\56\x69\x64\x5f\x73\151\x73\167\x61", "\x6c\145\x66\164"); goto u4zZx; TShnT: $this->db->query("\123\105\x54\40\x53\x51\x4c\x5f\102\111\107\137\123\105\114\x45\103\x54\x53\75\61"); goto x2her; ksWsZ: $this->db->from("\x6b\x65\154\x61\163\137\x73\x69\163\x77\x61\40\x61"); goto LWxTA; x2her: $this->db->select("\x62\56\151\x64\x5f\163\x69\163\167\x61\x2c\x20\x62\x2e\156\141\155\141\x2c\40\142\x2e\x6a\145\156\x69\163\x5f\153\x65\x6c\x61\x6d\x69\156\x2c\40\142\56\156\151\163\x2c\x20\142\56\x6e\x69\163\x6e\54\40\142\x2e\165\x73\x65\x72\156\141\155\x65\54\40\x62\56\x70\141\163\163\167\x6f\162\x64\x2c" . "\40\x62\56\x66\157\x74\x6f\x2c\x20\143\56\163\145\163\151\137\151\x64\54\x20\144\56\x6b\x6f\x64\x65\x5f\162\x75\x61\156\147\x2c\x20\145\56\x6b\x6f\144\x65\x5f\x73\145\163\151\x2c\x20\x66\56\156\141\155\141\x5f\x6b\x65\154\x61\x73\x2c\40\147\x2e\156\157\x6d\157\x72\137\x70\145\x73\145\x72\x74\141\54" . "\x20\150\56\x73\x65\x74\x5f\x73\151\x73\x77\141\54\x20\151\56\x6b\x6f\144\145\x5f\162\165\x61\156\147\40\141\x73\40\162\165\x61\x6e\x67\137\153\x65\154\x61\163\54\40\x6a\x2e\x6b\157\144\145\x5f\x73\145\x73\x69\40\141\x73\40\x73\x65\163\151\x5f\153\145\154\x61\163"); goto ksWsZ; fMFAg: $this->db->where("\141\x2e\x69\144\137\x73\151\163\167\141", $idSiswa); goto KtOJ8; wNKLu: $this->db->where("\x61\56\x69\144\137\x73\155\x74", $id_smt); goto fMFAg; KtOJ8: return $this->db->get()->row(); goto M_Mvc; NSMCI: $this->db->where("\141\56\x69\x64\x5f\164\x70", $id_tp); goto wNKLu; u4zZx: $this->db->join("\143\x62\x74\137\163\x65\x73\151\137\x73\x69\163\167\141\x20\143", "\x63\x2e\163\x69\163\x77\141\x5f\151\144\x3d\141\56\x69\144\x5f\x73\x69\x73\167\141", "\x6c\x65\x66\x74"); goto aKmUH; VYqvz: $this->db->join("\x63\x62\164\x5f\162\165\141\156\x67\x20\x69", "\x69\56\x69\x64\x5f\x72\x75\x61\156\x67\x3d\150\x2e\151\144\x5f\162\165\141\156\x67", "\154\145\146\164"); goto E7W4O; aKmUH: $this->db->join("\x63\x62\x74\x5f\x72\x75\141\156\147\40\x64", "\144\x2e\151\x64\137\x72\165\141\156\147\75\143\56\x72\165\141\x6e\x67\137\x69\144", "\x6c\145\x66\x74"); goto nNIgS; E7W4O: $this->db->join("\x63\142\164\137\163\x65\x73\x69\40\x6a", "\152\56\x69\144\x5f\x73\x65\x73\151\75\150\56\151\x64\137\x73\145\163\151", "\154\145\x66\164"); goto NSMCI; e1oLH: $this->db->join("\x63\x62\164\137\x6e\157\x6d\157\x72\x5f\160\145\163\x65\162\164\x61\40\x67", "\x67\x2e\151\144\x5f\163\151\x73\167\x61\x3d\141\x2e\151\x64\137\x73\151\163\x77\141\x20\x41\x4e\x44\40\147\x2e\151\x64\137\164\160\75" . $id_tp, "\154\145\146\164"); goto wnhW0; nNIgS: $this->db->join("\143\142\164\x5f\x73\145\163\151\x20\145", "\x65\x2e\x69\144\137\x73\x65\163\x69\75\143\x2e\x73\x65\x73\x69\x5f\151\x64", "\x6c\x65\x66\164"); goto BlY1k; wnhW0: $this->db->join("\143\x62\164\137\x6b\x65\x6c\141\163\137\162\x75\141\x6e\147\x20\x68", "\150\x2e\x69\144\x5f\153\145\x6c\141\x73\x3d\141\x2e\x69\144\x5f\x6b\x65\154\x61\x73", "\x6c\145\146\x74"); goto VYqvz; BlY1k: $this->db->join("\x6d\141\163\164\x65\162\x5f\153\x65\154\x61\x73\40\x66", "\146\x2e\x69\x64\137\x6b\x65\154\x61\163\x3d\x61\56\151\144\137\x6b\x65\154\x61\x73", "\x6c\145\146\164"); goto e1oLH; M_Mvc: } public function getAgamaSiswa() { goto ypQ1U; pr9wN: $ret["\x2d"] = "\x42\x75\153\x61\x6e\40\115\141\x70\x65\x6c\x20\101\x67\x61\155\x61"; goto BrIk5; gnOVx: $this->db->distinct(); goto SjVmW; vgWvv: $this->db->where("\141\x2e\141\x67\141\x6d\x61\40\x69\163\40\116\117\124\x20\116\125\x4c\x4c", NULL, FALSE); goto i38dO; ypQ1U: $this->db->select("\141\x67\141\155\141"); goto gnOVx; BrIk5: foreach ($result as $row) { $ret[$row->agama] = $row->agama; qQ6I8: } goto J9zOQ; HqcZg: $result = $this->db->get()->result(); goto pr9wN; YW6j7: $this->db->not_like("\x61\x2e\141\147\141\x6d\x61", "\x50\151\154\151\x68"); goto HqcZg; SjVmW: $this->db->from("\x6d\141\x73\x74\x65\162\x5f\x73\151\163\x77\x61\x20\x61"); goto vgWvv; vqK6p: return $ret; goto cwZEq; i38dO: $this->db->where("\x61\x2e\x61\x67\x61\155\141\x20\41\x3d\40\x22\x30\42", NULL, FALSE); goto YW6j7; J9zOQ: ha5Mi: goto vqK6p; cwZEq: } public function getJurusan() { goto pA5Q_; leoIf: $query = $this->db->get(); goto Si4kN; wn1U8: $this->db->join("\155\x61\x73\x74\145\162\x5f\152\x75\162\x75\x73\141\156", "\152\165\162\x75\x73\141\x6e\137\151\144\x3d\151\144\x5f\x6a\x75\162\x75\x73\141\156"); goto p38hV; iRloj: $this->db->from("\x6d\141\x73\164\x65\x72\x5f\x6b\145\154\x61\x73"); goto wn1U8; pA5Q_: $this->db->select("\x69\x64\x5f\x6a\165\x72\x75\x73\141\x6e\x2c\40\156\141\x6d\x61\137\152\165\x72\165\163\x61\x6e"); goto iRloj; Si4kN: return $query->result(); goto wtznS; MzJ9D: $this->db->group_by("\x69\144\137\152\x75\162\165\163\141\156"); goto leoIf; p38hV: $this->db->order_by("\156\x61\155\x61\137\152\x75\162\x75\x73\141\x6e", "\x41\x53\x43"); goto MzJ9D; wtznS: } public function getAllJurusan($id = null) { goto SEAke; BMlhf: $this->db->from("\x6d\141\x73\x74\x65\162\137\x6a\165\162\x75\163\x61\156"); goto ON_LE; QD9T8: goto WhOwT; goto nJh7c; aU20i: foreach ($jurusan as $j) { $id_jurusan[] = $j->jurusan_id; xXP_1: } goto zjscP; QKATt: $id_jurusan = []; goto aU20i; gdpFj: $this->db->order_by("\156\141\155\141\x5f\x6a\165\162\x75\x73\141\156", "\x41\x53\103"); goto aKght; zGd5O: $this->db->from("\x6a\x75\162\x75\x73\x61\156\137\x6d\141\160\x65\x6c"); goto YpkMx; jeFUT: WhOwT: goto edrye; nJh7c: lBnHi: goto gdpFj; qGCEw: $id_jurusan = null; goto CvS5u; aKght: return $this->db->get("\x6a\x75\162\165\163\141\x6e")->result(); goto jeFUT; k6TCA: if (!($id_jurusan === [])) { goto oa0vc; } goto qGCEw; betzq: $jurusan = $this->db->get()->result(); goto QKATt; CvS5u: oa0vc: goto c5i5l; wmAzq: $mapel = $this->db->get()->result(); goto las1g; YpkMx: $this->db->where("\155\141\160\145\154\x5f\151\144", $id); goto betzq; las1g: return $mapel; goto QD9T8; ON_LE: $this->db->where_not_in("\151\144\137\x6a\x75\x72\165\x73\141\156", $id_jurusan); goto wmAzq; SEAke: if ($id === null) { goto lBnHi; } goto mhaJ9; mhaJ9: $this->db->select("\x6a\x75\x72\165\x73\141\x6e\137\x69\x64"); goto zGd5O; zjscP: hgvfp: goto k6TCA; c5i5l: $this->db->select("\52"); goto BMlhf; edrye: } public function getKelasByJurusan($id) { $query = $this->db->get_where("\x6d\x61\x73\164\145\162\x5f\x6b\x65\x6c\x61\x73", array("\152\x75\x72\x75\x73\x61\x6e\137\151\x64" => $id)); return $query->result(); } public function getDataGuru($tp, $smt) { goto fTwGZ; fTwGZ: $this->db->query("\123\x45\124\x20\123\x51\x4c\x5f\x42\x49\x47\x5f\x53\105\114\105\103\124\123\x3d\x31"); goto QBy_D; HZiqb: $this->datatables->join("\154\x65\166\145\x6c\137\147\x75\162\x75\x20\x63", "\x62\56\x69\x64\x5f\152\141\x62\141\x74\141\156\x3d\143\x2e\151\144\137\x6c\145\x76\145\154", "\154\145\x66\x74"); goto COc0M; zh392: return $this->datatables->generate(); goto jRMCW; COc0M: $this->datatables->join("\x6d\141\x73\164\x65\162\137\x6b\x65\x6c\141\163\40\x64", "\x62\56\x69\144\x5f\x6b\x65\154\x61\163\x3d\x64\56\x69\144\137\x6b\145\154\x61\163\40\x41\116\x44\40\x64\56\x69\144\137\x74\x70\x3d" . $tp . "\40\101\116\x44\40\144\56\151\144\137\163\155\164\x3d" . $smt . '', "\x6c\145\x66\x74"); goto V_v2h; q6zly: $this->datatables->from("\x6d\141\163\164\145\162\x5f\x67\x75\x72\x75\40\x61"); goto Ya7Io; Mdemj: $this->datatables->join("\x6d\141\163\164\145\162\137\x73\155\164\x20\146", "\142\56\x69\x64\x5f\163\155\164\x3d\x66\56\x69\144\137\163\155\x74", "\x6c\x65\x66\164"); goto zh392; V_v2h: $this->datatables->join("\155\x61\x73\x74\x65\162\x5f\x74\160\x20\x65", "\142\56\x69\144\137\x74\160\75\145\56\151\x64\x5f\164\160", "\154\145\x66\164"); goto Mdemj; Ya7Io: $this->datatables->join("\x6a\x61\x62\141\164\141\x6e\x5f\x67\165\162\165\40\142", "\x61\56\151\144\x5f\147\x75\x72\x75\x3d\x62\x2e\x69\144\137\147\x75\162\165\x20\x41\x4e\x44\40\142\56\x69\x64\137\164\x70\75" . $tp . "\40\101\x4e\x44\x20\142\56\x69\144\137\163\x6d\164\75" . $smt . '', "\154\145\146\x74"); goto HZiqb; QBy_D: $this->datatables->select("\x61\56\x69\144\x5f\x67\165\162\165\54\x20\141\56\156\x61\x6d\x61\x5f\147\x75\x72\165\54\40\141\56\156\x69\x70\x2c\x20\141\x2e\x6b\157\x64\x65\137\147\165\x72\165\x2c\x20\141\56\152\145\x6e\x69\x73\137\153\145\154\141\x6d\x69\156\x2c\40\x61\56\x66\x6f\x74\157\54\40\x62\56\151\x64\137\x6a\141\142\x61\164\141\x6e\54\40\142\x2e\151\144\x5f\153\x65\x6c\141\163\x2c\x20\142\x2e\x6d\x61\160\145\x6c\137\x6b\x65\x6c\x61\x73\x2c\x20\x63\x2e\x69\x64\137\154\x65\166\x65\154\54\40\x63\x2e\154\145\x76\145\x6c\54\x20\144\56\x6e\x61\x6d\x61\x5f\153\145\154\141\x73\54\40\145\56\x74\141\150\x75\x6e\54\40\x66\56\x6e\141\x6d\x61\137\163\155\x74"); goto q6zly; jRMCW: } public function getAllDataGuru($tp, $smt) { goto djxdh; l7O7W: $this->db->join("\x6d\x61\x73\164\145\x72\137\163\155\164\x20\146", "\142\56\151\144\x5f\163\x6d\164\x3d\x66\x2e\x69\144\137\x73\155\164", "\x6c\145\x66\x74"); goto xWHfC; djxdh: $this->db->query("\x53\105\124\40\123\121\114\x5f\102\x49\107\137\123\105\114\105\103\x54\123\x3d\x31"); goto Ap6mp; JDb1e: $this->db->from("\x6d\x61\163\x74\145\162\x5f\147\165\x72\165\x20\x61"); goto tSjeD; Ap6mp: $this->db->select("\141\x2e\151\144\x5f\x67\165\x72\165\x2c\x20\x61\x2e\156\141\x6d\x61\x5f\x67\165\x72\165\x2c\x20\141\56\156\151\160\x2c\x20\x61\x2e\x6b\x6f\144\x65\137\x67\165\x72\165\54\x20\x61\x2e\152\x65\156\x69\163\x5f\x6b\145\154\141\x6d\151\x6e\x2c\x20\141\x2e\x66\157\x74\x6f\54\x20\142\56\x69\x64\x5f\x6a\141\142\141\164\x61\x6e\54\40\x62\56\151\144\137\x6b\x65\154\141\x73\54\40\142\x2e\155\x61\x70\145\x6c\x5f\153\x65\154\141\x73\54\40\142\56\x65\153\163\x74\x72\141\137\x6b\145\154\x61\163\x2c\40\x63\x2e\x69\144\137\x6c\x65\166\x65\x6c\x2c\40\143\56\x6c\x65\166\145\154\54\40\x64\56\156\x61\155\x61\137\153\145\154\141\x73\x2c\x20\145\x2e\x74\141\x68\165\x6e\x2c\x20\146\56\x6e\141\155\x61\x5f\163\155\x74\54\40\50\x53\x45\x4c\105\103\x54\x20\103\117\x55\x4e\124\x28\151\144\x29\x20\x46\x52\x4f\x4d\40\x75\163\145\x72\163\40\x65\x20\x57\110\x45\x52\105\40\145\56\165\x73\145\x72\156\x61\155\145\x20\75\40\141\56\x75\x73\x65\x72\x6e\x61\x6d\x65\x29\x20\x41\x53\40\163\164\x61\164\x75\163"); goto JDb1e; tSjeD: $this->db->join("\x6a\141\142\141\x74\x61\156\x5f\x67\x75\162\165\40\142", "\141\x2e\151\x64\137\x67\x75\x72\x75\x3d\142\x2e\x69\x64\x5f\x67\x75\162\x75\40\101\x4e\x44\x20\x62\x2e\151\144\137\164\160\75" . $tp . "\x20\x41\x4e\x44\40\x62\x2e\151\x64\137\163\155\164\75" . $smt . '', "\x6c\145\146\164"); goto OQ9Vo; xWHfC: $this->db->order_by("\x63\56\x69\x64\137\154\x65\x76\145\x6c", "\x64\x65\x73\143"); goto cvc8r; NfZ33: $this->db->join("\x6d\x61\163\x74\x65\162\137\x6b\x65\154\x61\x73\x20\x64", "\142\56\x69\x64\x5f\x6b\145\154\141\163\75\144\x2e\151\x64\x5f\x6b\x65\154\x61\163\x20\x41\x4e\104\40\x64\56\x69\x64\137\164\x70\75" . $tp . "\x20\101\x4e\x44\x20\144\56\x69\144\x5f\x73\155\164\75" . $smt . '', "\154\145\x66\x74"); goto i0xgO; OQ9Vo: $this->db->join("\154\x65\166\x65\x6c\137\x67\x75\x72\165\x20\x63", "\142\56\x69\144\x5f\152\141\142\141\x74\x61\156\75\143\x2e\151\x64\x5f\154\145\x76\x65\154", "\154\x65\x66\x74"); goto NfZ33; i0xgO: $this->db->join("\155\x61\x73\164\x65\x72\137\164\x70\x20\x65", "\142\x2e\151\144\x5f\164\160\x3d\145\x2e\151\144\137\x74\x70", "\x6c\x65\x66\x74"); goto l7O7W; Req0r: return $this->db->get()->result(); goto hYs8V; cvc8r: $this->db->order_by("\x61\x2e\151\x64\x5f\147\x75\162\x75", "\141\x73\x63"); goto Req0r; hYs8V: } public function getGuruById($id, $id_tp = null, $id_smt = null) { goto VMLMr; zYGmM: $this->db->join("\x6c\x65\x76\145\x6c\137\147\x75\162\165\x20\x63", "\142\x2e\x69\x64\137\152\141\x62\141\164\141\156\75\x63\x2e\151\x64\137\154\x65\x76\x65\x6c", "\154\x65\x66\164"); goto hX9xq; VMLMr: $this->db->query("\x53\x45\x54\40\x53\121\x4c\x5f\102\111\107\x5f\x53\105\x4c\105\x43\x54\x53\75\x31"); goto onhWU; f5b1v: DngiQ: goto SJM65; ek_rH: return $this->db->get()->row(); goto XerEI; onhWU: $this->db->select("\x2a"); goto rY7w3; TDxAb: $this->db->join("\x6a\x61\x62\x61\x74\x61\x6e\x5f\147\165\162\x75\40\x62", "\x61\56\x69\x64\x5f\x67\x75\x72\165\75\142\x2e\x69\144\137\147\x75\162\165", "\154\145\x66\x74"); goto zYGmM; e2keQ: $this->db->join("\x6d\x61\x73\164\145\162\137\153\x65\154\x61\163\x20\144", "\x61\56\151\144\137\147\x75\162\x75\x3d\x64\x2e\147\x75\x72\x75\137\x69\x64\40\x41\x4e\x44\40\144\56\x69\x64\137\164\x70\75" . $id_tp . "\40\101\116\x44\40\x64\56\151\x64\137\163\155\x74\75" . $id_smt, "\154\x65\146\x74"); goto f5b1v; hX9xq: if (!($id_tp != null && $id_smt != null)) { goto DngiQ; } goto e2keQ; rY7w3: $this->db->from("\155\x61\163\164\x65\162\x5f\147\165\x72\x75\x20\141"); goto TDxAb; SJM65: $this->db->where("\141\x2e\151\144\137\147\x75\x72\x75", $id); goto ek_rH; XerEI: } public function getGuruByArrId($arr_id) { goto fc7BW; GdfLL: $this->db->where_in("\x69\144\137\147\x75\162\165", $arr_id); goto POk9E; YIhOV: if (!(count($arr_id) > 0)) { goto QYdkS; } goto GdfLL; nnYUz: $this->db->from("\x6d\x61\163\164\145\x72\x5f\x67\x75\x72\165"); goto YIhOV; POk9E: QYdkS: goto Qefm1; Qefm1: return $this->db->get()->result(); goto jVhDv; fc7BW: $this->db->select("\x6e\x61\x6d\141\137\147\165\x72\x75"); goto nnYUz; jVhDv: } public function getUserIdGuruByUsername($username) { goto bH8Bd; XSxbA: $this->db->join("\152\141\x62\x61\x74\x61\156\137\147\x75\x72\165\x20\x62", "\x61\x2e\151\x64\137\147\x75\x72\x75\x3d\142\56\x69\144\137\x67\165\x72\165", "\x6c\145\x66\x74"); goto gpySH; bH8Bd: $this->db->query("\123\x45\124\40\123\x51\114\x5f\102\111\107\137\123\105\114\x45\x43\x54\x53\x3d\61"); goto rezT7; gpySH: $this->db->join("\x6c\x65\x76\145\x6c\x5f\147\x75\x72\165\40\x63", "\142\x2e\151\144\x5f\x6a\141\142\141\164\141\x6e\x3d\143\x2e\x69\144\x5f\x6c\x65\166\145\x6c", "\x6c\x65\x66\164"); goto i2PY5; i2PY5: $this->db->where("\x61\56\165\x73\145\x72\x6e\x61\155\x65", $username); goto rw5T8; rw5T8: return $this->db->get()->row(); goto Am_Jj; rezT7: $this->db->select("\52"); goto RIxYh; RIxYh: $this->db->from("\x6d\x61\x73\164\145\162\137\x67\x75\162\x75\40\x61"); goto XSxbA; Am_Jj: } public function getDetailJabatanGuru($id_guru) { goto KO_Rc; ektF6: $this->db->from("\155\x61\163\x74\145\162\x5f\147\165\x72\x75\x20\x61"); goto aytAN; UWJBN: foreach ($result as $row) { $ret[$row->id_tp][$row->id_smt] = $row; yiGyF: } goto KU2AP; KO_Rc: $this->db->query("\123\105\124\40\123\121\x4c\x5f\x42\x49\x47\x5f\123\105\x4c\105\103\x54\x53\x3d\x31"); goto CmYXg; RpswS: $this->db->join("\x6d\141\x73\x74\145\x72\x5f\153\x65\154\141\163\x20\144", "\142\56\x69\144\137\153\145\x6c\x61\163\x3d\144\56\151\x64\137\x6b\145\x6c\x61\x73", "\154\x65\x66\164"); goto ieyeg; aytAN: $this->db->join("\152\x61\x62\x61\164\x61\156\137\x67\165\162\x75\x20\142", "\141\56\x69\144\x5f\147\165\162\165\75\x62\x2e\151\x64\x5f\147\165\162\x75", "\x6c\x65\x66\164"); goto l0e5P; ieyeg: $this->db->where("\x61\x2e\151\144\x5f\x67\165\162\x75", $id_guru); goto sMve0; sXuQ2: $ret = []; goto UWJBN; CmYXg: $this->db->select("\x61\x2e\151\x64\137\147\165\162\x75\54\40\x61\56\x6e\141\155\x61\x5f\x67\165\x72\x75\54\40\x62\56\x69\144\137\164\160\x2c\40\x62\56\x69\x64\x5f\163\155\x74\54\x20\x62\56\155\141\160\x65\x6c\137\153\145\154\x61\x73\x2c\x20\142\56\145\153\163\164\x72\141\x5f\x6b\x65\154\x61\x73\54\40\143\x2e\151\144\x5f\x6c\x65\x76\x65\154\54\x20\143\x2e\x6c\x65\x76\x65\x6c\54\x20\144\x2e\x69\x64\137\x6b\145\154\x61\x73\x2c\40\x64\x2e\x6e\x61\155\x61\x5f\x6b\x65\x6c\141\163"); goto ektF6; B0Qkc: return $ret; goto m2Pra; l0e5P: $this->db->join("\x6c\145\166\145\154\137\x67\165\x72\x75\x20\x63", "\x62\x2e\x69\144\x5f\x6a\141\x62\141\x74\x61\x6e\x3d\x63\x2e\x69\144\x5f\x6c\145\x76\145\154", "\x6c\x65\146\164"); goto RpswS; sMve0: $result = $this->db->get()->result(); goto sXuQ2; KU2AP: gxCeZ: goto B0Qkc; m2Pra: } public function getJabatanGuru($id_guru, $tp, $smt) { goto SCtSX; xWieL: return $query; goto LLDGA; xqjVA: $this->db->join("\x6c\x65\x76\x65\x6c\x5f\x67\165\162\x75\40\143", "\142\56\151\x64\137\152\x61\142\x61\164\x61\156\75\x63\56\151\x64\x5f\154\145\166\x65\154", "\154\145\x66\164"); goto zUfvh; PgrJR: $this->db->from("\x6d\x61\163\164\x65\x72\137\x67\x75\162\165\40\x61"); goto ZHCAE; PmqzU: $this->db->where("\141\56\151\x64\137\147\x75\x72\x75", $id_guru); goto Ih7MU; gVH3h: $this->db->select("\141\x2e\151\144\137\x67\165\162\165\x2c\40\x61\x2e\156\141\155\141\137\147\x75\162\x75\x2c\x20\142\x2e\x6d\x61\x70\145\x6c\x5f\x6b\145\154\141\x73\54\40\142\56\145\x6b\x73\x74\x72\141\137\x6b\145\x6c\141\163\x2c\40\143\56\151\144\137\154\145\166\145\x6c\x2c\x20\x63\x2e\154\145\x76\145\154\54\40\x64\56\151\x64\137\153\x65\154\x61\163\54\40\x64\x2e\156\141\x6d\141\137\153\145\x6c\x61\x73"); goto PgrJR; Ih7MU: $query = $this->db->get()->row(); goto xWieL; ZHCAE: $this->db->join("\x6a\141\142\141\x74\x61\x6e\x5f\147\x75\162\165\x20\x62", "\x61\x2e\151\144\x5f\147\x75\162\x75\75\x62\x2e\x69\144\x5f\x67\x75\x72\x75\40\x41\x4e\x44\x20\142\56\x69\144\137\x74\160\x3d" . $tp . "\40\101\116\x44\x20\142\56\x69\144\137\x73\x6d\164\75" . $smt . '', "\154\x65\x66\x74"); goto xqjVA; zUfvh: $this->db->join("\155\141\163\164\145\x72\x5f\153\145\154\x61\x73\x20\144", "\x62\56\x69\144\x5f\x6b\145\x6c\x61\x73\x3d\144\56\x69\144\137\x6b\145\154\141\x73\x20\101\x4e\x44\40\144\56\151\x64\137\164\x70\x3d" . $tp . "\40\101\x4e\x44\x20\144\x2e\x69\x64\x5f\163\155\164\x3d" . $smt . '', "\x6c\145\146\164"); goto PmqzU; SCtSX: $this->db->query("\123\x45\x54\x20\123\x51\x4c\137\102\x49\107\x5f\x53\x45\x4c\105\103\x54\123\x3d\61"); goto gVH3h; LLDGA: } public function getGuruMapel($tp, $smt) { goto tsN_N; NYE39: $this->db->where("\x61\56\x69\144\137\163\x6d\164", $smt); goto xh12P; OL8XE: $this->db->join("\x6d\141\x73\164\145\x72\x5f\147\x75\x72\x75\40\142", "\141\56\151\x64\x5f\147\165\162\x75\x3d\x62\56\151\x64\x5f\x67\x75\x72\165"); goto WLUoe; xh12P: $query = $this->db->get()->result(); goto C2rks; WLUoe: $this->db->where("\141\x2e\151\x64\x5f\x74\160", $tp); goto NYE39; n3F0d: $this->db->from("\152\x61\x62\x61\164\x61\156\x5f\x67\165\162\165\40\x61"); goto OL8XE; tsN_N: $this->db->select("\x61\56\x6d\x61\160\x65\x6c\137\x6b\x65\154\x61\x73\54\40\x61\x2e\x65\x6b\x73\164\x72\x61\x5f\x6b\145\x6c\x61\x73\x2c\x20\141\x2e\x69\144\x5f\x6a\x61\x62\x61\164\x61\x6e\54\x20\x61\56\151\144\137\153\145\x6c\141\163\54\40\x62\56\x69\x64\137\x67\x75\x72\165\54\40\142\56\156\x61\155\x61\x5f\147\x75\162\165"); goto n3F0d; C2rks: return $query; goto ncdT6; ncdT6: } public function getKodeKelompokMapel() { goto Fgk2p; Fgk2p: $this->db->select("\x2a"); goto phA0h; H8KCi: foreach ($result as $row) { $ret[$row->kode_kel_mapel] = $row; FHcga: } goto DNP2W; phA0h: $this->db->from("\x6d\x61\163\x74\145\162\137\153\145\x6c\157\x6d\x70\157\x6b\x5f\155\141\x70\145\x6c"); goto tzIr1; lKcuf: return $ret; goto EbqK1; aHPae: $ret = []; goto H8KCi; DNP2W: p6lR5: goto lKcuf; sBxce: $result = $this->db->get()->result(); goto aHPae; tzIr1: $this->db->order_by("\x6b\x6f\x64\x65\x5f\153\145\154\137\155\141\160\x65\154"); goto sBxce; EbqK1: } public function getDataKelompokMapel() { goto Df4uT; uGLmg: $this->db->where("\x69\144\137\x70\x61\x72\x65\156\x74", "\60"); goto VRm_a; Df4uT: $this->db->select("\52"); goto aqjdU; VJ2dl: foreach ($result as $row) { $ret[$row->id_kel_mapel] = $row; wr4ur: } goto OX3Kw; kwQBf: $ret = []; goto VJ2dl; VRm_a: $this->db->order_by("\x6b\x6f\x64\x65\137\153\x65\x6c\x5f\x6d\141\x70\x65\x6c"); goto JqNeU; uJ3Qm: return $ret; goto DJCxw; OX3Kw: Be0ej: goto uJ3Qm; JqNeU: $result = $this->db->get()->result(); goto kwQBf; aqjdU: $this->db->from("\155\141\x73\164\145\162\137\153\x65\154\x6f\x6d\x70\x6f\x6b\x5f\155\141\x70\145\x6c"); goto uGLmg; DJCxw: } public function getKategoriKelompokMapel() { goto Qmm_X; q5ykZ: $this->db->where("\x6b\141\164\x65\x67\157\162\x69", "\127\101\112\111\102")->or_where("\x6b\141\164\145\147\x6f\x72\151", "\120\101\x49\40\50\x4b\145\155\x65\156\x61\147\x29"); goto XX9Vq; XX9Vq: $this->db->from("\x6d\141\x73\164\x65\x72\x5f\153\x65\154\157\x6d\160\157\153\137\x6d\x61\x70\145\154"); goto YKO3z; YKO3z: $result = $this->db->get()->result(); goto w78ey; w78ey: return $result; goto X1NgK; Qmm_X: $this->db->select("\x6b\157\x64\145\x5f\x6b\x65\x6c\x5f\x6d\141\x70\x65\x6c\x2c\x20\x6b\x61\x74\x65\x67\x6f\x72\x69"); goto q5ykZ; X1NgK: } public function getDataSubKelompokMapel() { goto RcoSx; XAJ15: $this->db->order_by("\x6b\157\144\145\x5f\x6b\145\x6c\137\x6d\141\x70\x65\154"); goto bo4Le; pQ29y: $this->db->where("\151\x64\137\x70\x61\162\145\x6e\164\40\x3c\76\40\60"); goto XAJ15; gd8mk: return $ret; goto tp70Q; RcoSx: $this->db->select("\52"); goto D7O5V; bCmwi: $ret = []; goto ZkI_q; bo4Le: $result = $this->db->get()->result(); goto bCmwi; ZkI_q: foreach ($result as $row) { $ret[$row->id_kel_mapel] = $row; sfKG3: } goto oip6R; oip6R: VMNqV: goto gd8mk; D7O5V: $this->db->from("\x6d\x61\x73\164\x65\162\x5f\x6b\145\154\x6f\x6d\x70\x6f\153\x5f\155\x61\x70\145\x6c"); goto pQ29y; tp70Q: } public function getDataMapel() { goto JrQjR; JrQjR: $this->datatables->select("\x69\x64\137\155\141\x70\x65\x6c\x2c\x20\156\141\x6d\x61\x5f\x6d\x61\x70\x65\154\x2c\40\x6b\157\x64\145"); goto fKJYE; fKJYE: $this->datatables->from("\x6d\x61\163\x74\145\162\137\x6d\x61\x70\145\154"); goto L0xLi; L0xLi: return $this->datatables->generate(); goto vPBOQ; vPBOQ: } public function getAllMapel($arrKelompok = null, $arrMapel = null) { goto LvoU6; CCOES: $this->db->or_where_in("\151\x64\137\x6d\141\x70\145\x6c", explode("\54", $arrMapel)); goto Hi0jI; ua0SL: if (!($arrMapel != null)) { goto maJ9d; } goto CCOES; FyRNc: $this->db->order_by("\x75\x72\x75\x74\141\x6e\137\x74\141\155\160\x69\154"); goto JUVkD; Hi0jI: maJ9d: goto yNjjf; cyo86: $this->db->where_in("\x6b\145\154\157\155\x70\x6f\x6b", $arrKelompok); goto x8U7E; JUVkD: return $this->db->get("\155\141\163\x74\x65\162\x5f\x6d\141\x70\x65\x6c")->result(); goto Zilm0; LvoU6: if (!($arrMapel != null)) { goto l3VqR; } goto cyo86; yNjjf: $this->db->where("\163\164\141\164\165\x73", "\61"); goto FyRNc; x8U7E: l3VqR: goto ua0SL; Zilm0: } public function getAllStatusMapel($arrKelompok = null, $arrMapel = null) { goto iFC8d; KWugf: $this->db->or_where_in("\151\x64\137\x6d\x61\x70\x65\154", explode("\54", $arrMapel)); goto T2lXC; LuWeX: k9RTH: goto nXtnI; T2lXC: h9hAa: goto pJQzG; iFC8d: if (!($arrMapel != null)) { goto k9RTH; } goto dV7Ub; nXtnI: if (!($arrMapel != null)) { goto h9hAa; } goto KWugf; dV7Ub: $this->db->where_in("\x6b\x65\x6c\157\x6d\160\157\153", $arrKelompok); goto LuWeX; XEE3v: return $this->db->get("\155\x61\163\x74\145\x72\137\x6d\141\160\145\154")->result(); goto rTSTr; pJQzG: $this->db->order_by("\x75\x72\x75\x74\141\156\137\164\x61\155\160\151\154"); goto XEE3v; rTSTr: } public function getAllMapelByKelompok($jenjang) { goto hdwyI; UJv87: $result = $this->db->get("\155\141\163\164\145\162\137\x6d\x61\x70\145\154")->result(); goto hCDc1; hdwyI: $this->db->where("\163\x74\141\164\165\x73", "\x31"); goto V3sfe; vuqye: foreach ($result as $row) { $ret[$row->kelompok][] = $row; UZ0nx: } goto BOcRh; hCDc1: $ret = []; goto vuqye; BOcRh: B2RCX: goto NOtxE; V3sfe: $this->db->order_by("\x75\162\x75\x74\141\x6e"); goto jEN5n; jEN5n: $this->db->order_by("\165\162\x75\164\x61\156\137\x74\x61\x6d\160\x69\x6c"); goto UJv87; NOtxE: return $ret; goto ZWlw4; ZWlw4: } public function getAllMapelNonAktif($jenjang) { $this->db->where("\x73\164\141\164\x75\163", "\60"); return $this->db->get("\155\141\x73\164\x65\162\137\155\x61\x70\x65\x6c")->result(); } public function getMapelById($id, $single = false) { goto KktCK; ABRlU: return $query; goto JlFZo; os7Ib: goto c29t1; goto m5vuW; ld8wr: $this->db->where_in("\x69\x64\137\155\x61\160\x65\154", $id); goto IghKM; IghKM: $this->db->order_by("\x6e\141\x6d\x61\x5f\x6d\141\160\x65\x6c"); goto i8ZGU; i8ZGU: $query = $this->db->get("\x6d\x61\163\x74\x65\x72\x5f\155\x61\160\x65\x6c")->result(); goto Wwq6z; KktCK: if ($single === false) { goto sex2M; } goto TGWC1; TGWC1: $query = $this->db->get_where("\155\141\x73\x74\145\162\x5f\155\141\x70\x65\154", array("\151\x64\x5f\x6d\141\x70\x65\154" => $id))->row(); goto os7Ib; m5vuW: sex2M: goto ld8wr; Wwq6z: c29t1: goto ABRlU; JlFZo: } function updateMapel() { goto GDrTs; m7F13: $status = $this->input->post("\x73\x74\141\x74\x75\163", true); goto idfys; idfys: $urut = $this->input->post("\165\162\165\164\x61\x6e\137\x74\x61\155\160\x69\x6c", true); goto obCxv; NqGgY: $this->db->set("\x75\x72\165\x74\x61\x6e\137\x74\141\x6d\160\x69\x6c", $urut); goto j229C; j229C: $this->db->where("\x69\x64\x5f\155\x61\x70\x65\154", $id); goto dR21Q; OXSOH: $this->db->set("\153\x6f\x64\x65", $kode); goto aVShB; GDrTs: $id = $this->input->post("\151\x64\137\155\x61\x70\x65\x6c"); goto R2xxV; obCxv: $this->db->set("\156\141\x6d\141\x5f\155\141\x70\x65\154", $name); goto OXSOH; R2xxV: $name = $this->input->post("\156\x61\155\x61\137\155\141\160\145\x6c", true); goto M8Btu; M8Btu: $kode = $this->input->post("\153\157\144\145\137\155\x61\x70\145\154", true); goto AgYBy; dR21Q: return $this->db->update("\x6d\141\x73\x74\x65\x72\137\x6d\x61\x70\145\x6c"); goto A1izP; DLFdN: ZHObF: goto WYCql; WYCql: $this->db->set("\163\164\x61\x74\165\x73", $status); goto NqGgY; Sl2IN: $this->db->set("\153\145\x6c\x6f\x6d\x70\157\153", $kelompok); goto DLFdN; AgYBy: $kelompok = $this->input->post("\153\145\x6c\157\x6d\160\157\153", true); goto m7F13; aVShB: if (!($kelompok != null)) { goto ZHObF; } goto Sl2IN; A1izP: } public function getAllEkstra() { return $this->db->get("\x6d\141\x73\164\x65\x72\137\145\153\163\164\162\x61")->result(); } public function getEkstraById($id, $single = false) { goto lA3pt; YD1n8: xzDgG: goto HXnSb; SpqDJ: goto Itqrb; goto YD1n8; PTGqO: $query = $this->db->get("\155\x61\163\164\x65\162\137\145\153\x73\x74\162\141")->result(); goto xJxnG; HXnSb: $this->db->where_in("\x69\144\137\145\x6b\163\x74\x72\x61", $id); goto aLLR2; gdt9H: return $query; goto lfTX1; aLLR2: $this->db->order_by("\156\x61\x6d\x61\137\145\153\x73\164\x72\x61"); goto PTGqO; xJxnG: Itqrb: goto gdt9H; YUV44: $query = $this->db->get_where("\155\x61\x73\164\x65\x72\137\x65\x6b\x73\164\x72\x61", array("\151\144\137\145\x6b\x73\x74\x72\141" => $id))->row(); goto SpqDJ; lA3pt: if ($single === false) { goto xzDgG; } goto YUV44; lfTX1: } function updateEkstra() { goto GQSs8; kuFqh: $kode = $this->input->post("\153\x6f\144\x65\x5f\145\x6b\163\x74\162\141", true); goto Z3iaU; thT9A: $this->db->where("\151\144\x5f\145\x6b\163\164\x72\x61", $id); goto HxApf; CCno6: $this->db->set("\x6b\157\x64\145\137\x65\153\x73\x74\x72\141", $kode); goto thT9A; HxApf: return $this->db->update("\x6d\141\x73\x74\145\162\137\x65\153\x73\164\162\x61"); goto Sg4Gn; Z3iaU: $this->db->set("\x6e\x61\155\x61\137\x65\x6b\x73\x74\162\141", $name); goto CCno6; GQSs8: $id = $this->input->post("\151\144\137\145\153\x73\x74\162\141"); goto fXp_o; fXp_o: $name = $this->input->post("\156\x61\155\x61\x5f\145\x6b\x73\164\162\141", true); goto kuFqh; Sg4Gn: } public function getKelasGuru() { goto xgFSY; BgnO3: $this->datatables->select("\153\x65\154\141\x73\x5f\147\x75\162\165\56\151\144\x2c\40\147\x75\x72\165\x2e\151\144\x5f\147\x75\162\x75\x2c\40\147\165\162\x75\x2e\156\151\x70\x2c\40\147\165\x72\x75\x2e\156\x61\155\141\x5f\147\165\162\165\x2c\40\107\122\117\x55\120\137\x43\x4f\x4e\103\101\124\50\x6d\141\163\164\145\162\x5f\153\x65\x6c\x61\163\x2e\x6e\x61\x6d\x61\x5f\153\x65\154\141\x73\51\40\x61\163\40\153\145\x6c\141\163"); goto AQKDa; LK76z: return $this->datatables->generate(); goto TJ9VH; uzi16: $this->datatables->join("\155\141\163\x74\x65\x72\137\x6b\145\154\141\163", "\153\x65\x6c\x61\163\x5f\151\x64\75\151\144\137\153\145\x6c\x61\163"); goto Ho_20; Ho_20: $this->datatables->join("\x6d\x61\163\164\145\x72\137\147\165\x72\x75", "\x67\165\162\x75\x5f\151\x64\x3d\151\x64\x5f\x67\x75\162\x75"); goto ah0WI; xgFSY: $this->db->query("\x53\105\x54\40\123\121\x4c\137\102\111\x47\x5f\x53\x45\114\105\x43\x54\123\x3d\x31"); goto BgnO3; AQKDa: $this->datatables->from("\153\145\x6c\141\x73\137\147\165\162\x75"); goto uzi16; ah0WI: $this->datatables->group_by("\x67\x75\162\x75\56\x6e\141\155\141\137\x67\x75\162\165"); goto LK76z; TJ9VH: } public function getKelasByGuru($id) { goto leedT; GupgP: return $query; goto GFnPi; viNGn: $query = $this->db->get()->result(); goto GupgP; OOfns: $this->db->from("\153\145\154\141\163\137\147\x75\162\165"); goto E2IzY; E2IzY: $this->db->join("\155\141\x73\x74\x65\162\x5f\x6b\145\154\x61\x73", "\153\145\154\141\x73\137\x67\x75\x72\x75\x2e\x6b\145\x6c\141\163\x5f\151\144\75\x6b\x65\154\141\163\x2e\x69\144\x5f\153\x65\154\141\x73"); goto kByXR; kByXR: $this->db->where("\147\x75\162\x75\x5f\x69\144", $id); goto viNGn; leedT: $this->db->select("\153\x65\x6c\x61\x73\x2e\151\x64\x5f\153\x65\154\x61\163"); goto OOfns; GFnPi: } public function getAllJabatanGuru($id) { goto TVyg0; ldIWG: if (!$result) { goto HFYji; } goto AVJCE; TL94P: return $ret; goto jrqz2; T1I9q: HFYji: goto TL94P; AVJCE: foreach ($result as $key => $row) { $ret[$row->id_tp][$row->id_smt] = $row->id_kelas; m1p_O: } goto iXGOQ; TVyg0: $result = $this->db->get_where("\152\x61\142\141\x74\x61\x6e\137\x67\165\x72\165", "\x69\x64\x5f\147\165\x72\165\x3d" . $id)->result(); goto ldIWG; iXGOQ: f0Sry: goto T1I9q; jrqz2: } public function getJurusanMapel() { goto LTunJ; IoUC0: $this->datatables->select("\152\x75\162\165\163\141\x6e\137\x6d\141\x70\145\154\x2e\151\x64\x2c\x20\155\x61\160\x65\154\56\151\x64\137\x6d\141\x70\145\154\x2c\40\x6d\x61\x70\145\154\56\156\x61\x6d\x61\x5f\x6d\x61\160\x65\x6c\x2c\40\x6a\165\x72\165\163\141\156\x2e\x69\x64\137\152\165\162\165\163\x61\156\x2c\40\107\122\x4f\x55\120\x5f\x43\x4f\x4e\103\x41\124\50\152\x75\x72\165\x73\x61\156\x2e\156\141\x6d\141\x5f\x6a\x75\162\165\163\x61\x6e\x29\40\141\163\x20\156\x61\155\x61\x5f\152\x75\x72\165\x73\141\156"); goto IeOJs; IeOJs: $this->datatables->from("\152\165\x72\x75\x73\x61\x6e\137\155\x61\x70\x65\154"); goto U9Oaa; fq4OR: $this->datatables->group_by("\155\x61\163\164\x65\x72\x5f\x6d\x61\160\145\154\x2e\x6e\x61\x6d\141\137\155\141\x70\145\x6c"); goto Mxpko; Mxpko: return $this->datatables->generate(); goto KY9hJ; JQljR: $this->datatables->join("\x6d\141\163\164\x65\x72\137\152\165\162\x75\x73\141\x6e", "\152\165\162\165\163\x61\156\137\x69\144\75\x69\x64\x5f\152\x75\x72\165\163\141\x6e"); goto fq4OR; U9Oaa: $this->datatables->join("\155\141\163\x74\145\162\137\155\141\160\x65\154", "\x6d\x61\x70\x65\154\137\x69\144\x3d\151\x64\x5f\x6d\141\x70\145\x6c"); goto JQljR; LTunJ: $this->db->query("\x53\105\124\40\123\121\x4c\x5f\x42\x49\107\x5f\x53\105\x4c\x45\103\124\123\75\x31"); goto IoUC0; KY9hJ: } public function getMapel($id = null) { goto FRVA3; MV4nU: if (!($id !== null)) { goto o23rr; } goto mZ_Hj; ZUK_q: $id_mapel = []; goto rud1E; uHSUS: $id_mapel = null; goto IRLx0; uC7e9: QegnJ: goto n1uNM; n1uNM: if (!($id_mapel === [])) { goto pwgzP; } goto uHSUS; k73wX: $mapel = $this->db->get()->result(); goto ZUK_q; dQZjZ: $this->db->where_not_in("\x69\144\x5f\x6d\x61\x70\145\154", $id_mapel); goto M1vKk; M1vKk: return $this->db->get()->result(); goto cSU1Q; mZ_Hj: $this->db->where_not_in("\x6d\x61\x70\x65\x6c\x5f\151\144", [$id]); goto wl10K; rud1E: foreach ($mapel as $d) { $id_mapel[] = $d->mapel_id; aR0rx: } goto uC7e9; Fsj5H: $this->db->from("\155\x61\x73\x74\145\x72\137\155\141\x70\x65\x6c"); goto dQZjZ; IRLx0: pwgzP: goto AQwva; wl10K: o23rr: goto k73wX; AQwva: $this->db->select("\151\144\137\155\x61\x70\145\154\54\x20\156\141\155\141\137\x6d\141\160\145\x6c"); goto Fsj5H; MLjB6: $this->db->from("\152\x75\x72\x75\163\141\156\x5f\155\141\160\145\154"); goto MV4nU; FRVA3: $this->db->select("\155\141\160\145\154\137\x69\144"); goto MLjB6; cSU1Q: } public function getJurusanByIdMapel($id) { goto Rny1t; ZVWim: $this->db->where("\155\x61\160\145\154\137\x69\x64", $id); goto xfTpg; Rny1t: $this->db->select("\152\165\x72\x75\163\x61\156\x2e\x69\144\137\x6a\165\162\x75\163\x61\x6e"); goto L50kk; IA7Z3: $this->db->join("\x6d\141\x73\x74\145\x72\x5f\152\165\162\x75\x73\x61\156", "\152\x75\162\x75\163\141\x6e\137\155\141\160\145\x6c\x2e\x6a\x75\162\165\163\141\156\x5f\151\x64\75\x6a\x75\162\165\x73\x61\x6e\x2e\x69\x64\x5f\x6a\x75\x72\x75\163\x61\x6e"); goto ZVWim; xfTpg: $query = $this->db->get()->result(); goto lvjSF; lvjSF: return $query; goto B9yIF; L50kk: $this->db->from("\152\165\x72\165\163\x61\156\x5f\x6d\x61\x70\145\154"); goto IA7Z3; B9yIF: } public function getTahunActive() { goto uGqG2; nGcHN: $this->db->where("\x61\x63\164\x69\x76\145", 1); goto H3Pc6; H3Pc6: $result = $this->db->get()->row(); goto PxyTP; I2sXF: $this->db->from("\x6d\141\x73\x74\145\x72\x5f\x74\160"); goto nGcHN; PxyTP: return $result; goto jxH0I; uGqG2: $this->db->select("\151\x64\x5f\164\x70\54\40\x74\141\150\165\x6e"); goto I2sXF; jxH0I: } public function getSemesterActive() { goto RwqTd; ZWztR: $result = $this->db->get()->row(); goto Qte0D; VXR6b: $this->db->from("\x6d\141\163\x74\145\x72\137\x73\x6d\x74"); goto R64nE; RwqTd: $this->db->select("\151\144\137\x73\x6d\164\54\40\x6e\x61\155\x61\x5f\x73\155\x74\54\x20\163\155\164"); goto VXR6b; Qte0D: return $result; goto LIup0; R64nE: $this->db->where("\x61\143\x74\x69\166\145", 1); goto ZWztR; LIup0: } public function getJmlHariEfektif($id) { goto U7O8y; U7O8y: $this->db->select("\x2a"); goto gCIM2; Rdq1B: $result = $this->db->get()->row(); goto nhByt; wl6l9: $this->db->where("\x69\144\x5f\150\x61\x72\151\x5f\x65\146\145\x6b\x74\x69\x66", $id); goto Rdq1B; gCIM2: $this->db->from("\x6d\141\163\x74\x65\x72\137\x68\x61\162\x69\137\145\146\x65\153\x74\151\x66"); goto wl6l9; nhByt: return $result; goto Iql3k; Iql3k: } public function getDistinctTahunLulus() { goto WMqUZ; doXf1: $result = $this->db->get("\x62\x75\153\x75\x5f\x69\x6e\144\x75\x6b")->result(); goto CvxkW; sTLPu: foreach ($result as $row) { goto Og5bb; Og5bb: if (!($row->tahun_lulus != '')) { goto b9Nke; } goto Kl7px; Kl7px: $ret[$row->tahun_lulus] = $row->tahun_lulus; goto gIhIp; jcR8y: SpAGR: goto Z6HfI; gIhIp: b9Nke: goto jcR8y; Z6HfI: } goto ejwyi; Gzes4: return $ret; goto N4FGT; WMqUZ: $this->db->select("\164\x61\x68\x75\x6e\x5f\154\165\154\x75\x73"); goto u5y9J; CvxkW: $ret = []; goto sTLPu; ejwyi: hgA9_: goto Gzes4; u5y9J: $this->db->distinct(); goto doXf1; N4FGT: } public function getDistinctKelasAkhir() { goto UxQLI; XwLHy: $this->db->distinct(); goto pqnaR; ltCgB: foreach ($result as $row) { goto cXcIy; RNdQl: $ret[$row->kelas_akhir] = $row->kelas_akhir; goto nOgVR; BCEAC: w3hpX: goto Ob3H5; cXcIy: if (!($row->kelas_akhir != '')) { goto MaQ7V; } goto RNdQl; nOgVR: MaQ7V: goto BCEAC; Ob3H5: } goto PY6mi; PY6mi: eaSjc: goto OJlyu; OJlyu: return $ret; goto MaYV4; J0enK: $ret = []; goto ltCgB; UxQLI: $this->db->select("\x6b\x65\x6c\141\163\x5f\x61\x6b\x68\x69\162"); goto XwLHy; pqnaR: $result = $this->db->get("\x62\x75\x6b\165\x5f\x69\x6e\x64\x75\x6b")->result(); goto J0enK; MaYV4: } public function getAlumniByTahun($tahun, $kelas = null) { goto HDmll; HDmll: $this->db->select("\52"); goto r1S60; OTEA6: return $this->db->get()->result(); goto PuxPJ; r1S60: $this->db->from("\x62\x75\x6b\165\137\151\156\x64\x75\x6b\x20\141"); goto EsHks; YHxF5: $this->db->where("\141\56\x6b\x65\154\141\x73\137\x61\x6b\x68\151\x72", $kelas); goto VHrDo; Odyiw: if (!($kelas != null)) { goto zdDjO; } goto YHxF5; YORRm: $this->db->where("\x61\56\x74\141\150\165\156\137\x6c\165\154\165\x73", $tahun); goto Odyiw; VHrDo: zdDjO: goto OTEA6; EsHks: $this->db->join("\x6d\x61\x73\164\145\162\137\163\151\163\167\x61\x20\x62", "\141\x2e\151\144\x5f\163\151\x73\x77\x61\x3d\x62\x2e\x69\144\137\163\151\163\x77\x61"); goto YORRm; PuxPJ: } public function getAlumniById($id) { goto nNQyQ; zLDo0: $this->db->join("\x62\x75\x6b\165\x5f\x69\x6e\x64\165\153\40\142", "\141\56\x69\x64\137\x73\x69\x73\x77\141\x3d\x62\x2e\x69\144\x5f\163\x69\x73\x77\x61"); goto eFuu2; ft0kt: return $this->db->get()->row(); goto WluqZ; eFuu2: $this->db->where("\141\56\151\x64\x5f\163\x69\163\167\141", $id); goto ft0kt; nNQyQ: $this->db->select("\52"); goto xvq6r; xvq6r: $this->db->from("\155\141\x73\164\x65\x72\137\163\x69\163\167\141\x20\x61"); goto zLDo0; WluqZ: } public function getAllWaliKelas() { goto aYErM; WANB2: $this->db->from("\152\141\x62\x61\x74\x61\156\137\147\x75\162\x75\40\141"); goto UGilb; pizv0: $ret = []; goto dfF5m; aYErM: $this->db->query("\x53\x45\124\x20\x53\121\x4c\x5f\102\x49\x47\x5f\x53\105\x4c\105\103\x54\x53\75\x31"); goto W7jU9; sQGhn: $result = $this->db->get()->result(); goto pizv0; zxsCa: foreach ($result as $key => $row) { goto uUXxw; uKTcA: $ret[$row->id_tp][$row->id_smt][$row->id_kelas] = $row; goto ymSAd; ENYGU: ORF7u: goto YTE3n; ymSAd: vzbZY: goto ENYGU; uUXxw: if (!($row->id_level == "\x34")) { goto vzbZY; } goto uKTcA; YTE3n: } goto VtE2S; t092S: Mx1dX: goto EVdi4; t9O7R: $this->db->join("\154\145\166\145\154\137\x67\x75\x72\165\x20\143", "\x61\56\x69\144\137\152\141\142\141\164\141\156\75\143\x2e\151\144\137\x6c\x65\166\x65\154", "\154\x65\146\x74"); goto zxMHe; zxMHe: $this->db->join("\x6d\141\x73\x74\x65\162\137\x6b\145\154\x61\163\40\144", "\141\x2e\151\x64\137\x6b\145\x6c\141\163\x3d\144\x2e\151\x64\x5f\x6b\x65\154\x61\163", "\x6c\145\x66\164"); goto sQGhn; UGilb: $this->db->join("\x6d\141\x73\164\145\162\x5f\147\x75\162\x75\x20\x62", "\141\56\151\144\137\x67\x75\162\165\75\x62\x2e\x69\144\137\147\165\162\x75", "\154\x65\x66\x74"); goto t9O7R; dfF5m: if (!$result) { goto Mx1dX; } goto zxsCa; W7jU9: $this->db->select("\141\56\x69\x64\x5f\164\160\x2c\40\x61\56\x69\x64\137\163\x6d\x74\54\40\x61\x2e\151\x64\137\x67\165\x72\165\54\x20\x62\56\156\141\x6d\141\x5f\147\x75\162\x75\x2c\x20\143\56\151\x64\x5f\x6c\x65\166\145\x6c\x2c\x20\143\x2e\154\145\166\145\x6c\54\40\144\56\151\144\137\153\x65\x6c\x61\x73\54\x20\x64\x2e\x6e\x61\155\141\x5f\153\x65\154\x61\163"); goto WANB2; VtE2S: OQVBn: goto t092S; EVdi4: return $ret; goto qZeGI; qZeGI: } public function getAllGuru() { goto IT5J0; GHJQv: return $this->db->get()->result(); goto RF2u6; Eo3C2: $id_guru = []; goto eDWCm; eDWCm: foreach ($guru as $d) { $id_guru[] = $d->id_guru; nX1W1: } goto aE9yp; IT5J0: $this->db->select("\x69\144\137\x67\x75\162\165"); goto ePMQd; YE5Vz: $this->db->where_in("\151\x64\137\147\x75\x72\x75", $id_guru); goto GHJQv; TTq1C: $this->db->from("\155\141\163\x74\x65\162\137\x67\x75\162\165"); goto YE5Vz; NBOPj: $guru = $this->db->get()->result(); goto Eo3C2; ePMQd: $this->db->from("\x6a\141\x62\141\164\x61\156\x5f\147\165\x72\x75"); goto NBOPj; aE9yp: Yyku1: goto H5jlM; H5jlM: $this->db->select("\151\144\137\x67\x75\x72\x75\x2c\x20\156\x69\160\54\x20\x6e\x61\x6d\141\x5f\147\165\x72\165"); goto TTq1C; RF2u6: } public function getAllKelas($tp = null, $smt = null) { goto A_AeP; Ym_7K: $this->db->join("\152\141\142\141\164\x61\x6e\x5f\147\x75\x72\x75\40\x66", "\146\x2e\151\x64\137\x6b\x65\x6c\141\163\x3d\x61\56\x69\x64\x5f\153\x65\154\141\163", "\154\145\x66\x74"); goto QFt1J; mhQpj: JN3ue: goto ehVU3; dJQiu: if (!$result) { goto JN3ue; } goto XUJUT; fPgrD: if (!$result) { goto Qu7au; } goto glVMT; Nc83o: $this->db->join("\155\141\x73\x74\x65\x72\137\x67\x75\x72\165\40\143", "\x66\x2e\x69\144\x5f\147\x75\162\x75\75\143\56\151\x64\137\x67\165\162\165", "\154\145\146\x74"); goto wY7mk; BaSvA: Qu7au: goto vsAOd; vsAOd: goto YPCiR; goto P8Vs7; qFPHs: if ($tp != null && $smt != null) { goto Wg3qd; } goto fPgrD; wY7mk: $this->db->order_by("\141\56\156\141\155\x61\x5f\153\145\x6c\141\x73"); goto tkUsM; XUJUT: foreach ($result as $key => $row) { $ret[$row->id_kelas] = $row; qTBLE: } goto Nm5a9; A_AeP: $this->db->query("\x53\x45\x54\40\x53\x51\114\x5f\102\111\107\x5f\123\105\x4c\x45\x43\x54\123\75\61"); goto PyQSN; SZRjR: $ret = []; goto qFPHs; WBTkP: $this->db->from("\x6d\141\163\164\x65\162\x5f\x6b\x65\x6c\141\163\40\141"); goto EXNI0; EXNI0: if (!($tp != null && $smt != null)) { goto sDN8S; } goto f9Oxm; tkUsM: $result = $this->db->get()->result(); goto SZRjR; Nm5a9: KyLMS: goto mhQpj; f9Oxm: $this->db->where("\x61\x2e\x69\144\x5f\x74\x70", $tp)->where("\x61\x2e\151\x64\137\x73\155\164", $smt); goto Hhw4c; Hhw4c: sDN8S: goto Ym_7K; glVMT: foreach ($result as $key => $row) { $ret[$row->id_tp][$row->id_smt][$row->id_kelas] = $row; qA6dj: } goto C1akH; QFt1J: $this->db->join("\x6d\x61\163\164\145\162\x5f\152\x75\x72\165\163\x61\x6e\x20\142", "\x61\x2e\152\x75\x72\x75\163\141\x6e\x5f\x69\x64\x3d\x62\56\x69\144\137\152\165\162\x75\163\141\x6e", "\154\145\x66\164"); goto Nc83o; ehVU3: YPCiR: goto ehtJK; P8Vs7: Wg3qd: goto dJQiu; PyQSN: $this->db->select("\x61\x2e\x69\144\137\x6b\145\154\x61\x73\x2c\40\x61\56\x69\144\x5f\x74\x70\54\40\x61\56\x69\144\137\x73\x6d\164\54\40\141\x2e\156\x61\x6d\x61\137\x6b\x65\154\141\x73\54\40\x61\x2e\x6b\157\x64\145\x5f\153\145\x6c\x61\x73\54\x20\141\x2e\x6c\145\x76\x65\154\x5f\x69\144\54\x20\x62\56\x6e\141\155\x61\137\x6a\165\162\165\x73\x61\x6e\x2c\40\x62\x2e\153\x6f\144\x65\x5f\152\165\162\x75\163\x61\156\54\x20\143\x2e\156\141\x6d\x61\x5f\x67\x75\162\x75"); goto WBTkP; C1akH: iZ7rM: goto BaSvA; ehtJK: return $ret; goto DixW7; DixW7: } public function getAllKelasSiswa() { goto F8QRi; F8QRi: $this->db->select("\x2a"); goto aq4ms; aq4ms: $this->db->from("\x6b\x65\x6c\141\x73\x5f\163\151\x73\x77\141"); goto kbWUo; SMXUX: return $ret; goto vuxQk; kbWUo: $result = $this->db->get()->result(); goto da92W; v0Vv9: LUh_8: goto wpWNY; S1Dm9: if (!$result) { goto BbbqK; } goto aPdFP; da92W: $ret = []; goto S1Dm9; aPdFP: foreach ($result as $key => $row) { $ret[$row->id_kelas][$row->id_siswa] = $row; bNu65: } goto v0Vv9; wpWNY: BbbqK: goto SMXUX; vuxQk: } public function getDataInduk() { goto Rluvv; g3dJE: MGO1B: goto lpnDR; ZqEn9: $result = $this->db->get()->result(); goto EQeXs; bU2o3: $this->db->order_by("\x61\x2e\156\x61\155\141", "\x41\123\103"); goto ZqEn9; bc70r: wTLy9: goto g3dJE; mUQPA: if (!$result) { goto MGO1B; } goto J1sPX; QBLOX: $this->db->join("\x62\165\x6b\x75\x5f\151\156\144\165\153\40\142", "\141\x2e\x69\144\137\x73\x69\163\167\x61\x3d\142\x2e\151\x64\x5f\x73\x69\x73\x77\x61", "\x6c\x65\146\x74"); goto bU2o3; J1sPX: foreach ($result as $key => $row) { $ret[$row->id_siswa] = $row; d4NIx: } goto bc70r; EQeXs: $ret = []; goto mUQPA; Rluvv: $this->db->select("\141\x2e\x2a\x2c\x20\x62\x2e\52\x2c"); goto HhbbI; lpnDR: return $ret; goto tIxTC; HhbbI: $this->db->from("\x6d\141\163\164\x65\162\x5f\163\151\x73\x77\141\40\141"); goto QBLOX; tIxTC: } }

Function Calls

None

Variables

None

Stats

MD5	1944c737a9bf0915ce73fa6acbec809a
Eval Count	0
Decode Time	74 ms

Find this useful? Enter your email to receive occasional updates for securing PHP code.

PHP Decode

Decoded Output download

Did this file decode correctly?

How would you describe this file?

Original Code

Function Calls

Variables

Stats