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

Signing you up...

Thank you for signing up!

PHP Decode

<?php /* ________________________________________ | GarudaCBT ..

Decoded Output download

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

Did this file decode correctly?

Original Code

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

Function Calls

None

Variables

None

Stats

MD5 712980aef6e39ff00ca437d7190f876a
Eval Count 0
Decode Time 118 ms