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 /** * Class and Function List: * Function list: * - create() * - update() * - ..
Decoded Output download
<?php
/**
* Class and Function List:
* Function list:
* - create()
* - update()
* - delete()
* - delete_not()
* - getDataKelas()
* - getKelasById()
* - getDataJurusan()
* - getDataJurusanMapel()
* - getDataTableJurusan()
* - getJurusanById()
* - updateJurusan()
* - inputJurusan()
* - getAllDataSiswa()
* - getSiswaByKelas()
* - getDataSiswa()
* - getAllSiswa()
* - getSiswaPage()
* - getSiswaTotalPage()
* - getDataSiswaByKelas()
* - getDataSiswaByKelasPage()
* - getSiswaById()
* - getSiswaByArrNisn()
* - getSiswaKelasBaru()
* - getDataSiswaById()
* - getAgamaSiswa()
* - getJurusan()
* - getAllJurusan()
* - getKelasByJurusan()
* - getDataGuru()
* - getAllDataGuru()
* - getGuruById()
* - getGuruByArrId()
* - getUserIdGuruByUsername()
* - getDetailJabatanGuru()
* - getJabatanGuru()
* - getGuruMapel()
* - getKodeKelompokMapel()
* - getDataKelompokMapel()
* - getKategoriKelompokMapel()
* - getDataSubKelompokMapel()
* - getDataMapel()
* - getAllMapel()
* - getAllStatusMapel()
* - getAllMapelByKelompok()
* - getAllMapelNonAktif()
* - getMapelById()
* - updateMapel()
* - getAllEkstra()
* - getEkstraById()
* - updateEkstra()
* - getKelasGuru()
* - getKelasByGuru()
* - getAllJabatanGuru()
* - getJurusanMapel()
* - getMapel()
* - getJurusanByIdMapel()
* - getTahunActive()
* - getSemesterActive()
* - getJmlHariEfektif()
* - getDistinctTahunLulus()
* - getDistinctKelasAkhir()
* - getAlumniByTahun()
* - getAlumniById()
* - getAllWaliKelas()
* - getAllGuru()
* - getAllKelas()
* - getAllKelasSiswa()
* - getDataInduk()
* Classes list:
* - Master_model extends CI_Model
*/
/* ________________________________________
| 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)
{
gotoUcvEh;
k9x_s:
hDau3:
gotoAPNiW;
H4i8F:
yG27h:
gotoKh4mZ;
UcvEh:
if ($batch === false)
{
gotohDau3;
}
gotoFsqcH;
Kh4mZ:
return $insert;
gotoOTYcf;
FsqcH:
$insert = $this
->db
->insert_batch($table, $data);
gotoKjVwm;
APNiW:
$insert = $this
->db
->insert($table, $data);
gotoH4i8F;
KjVwm:
gotoyG27h;
gotok9x_s;
OTYcf:
}
public function update($table, $data, $pk, $id = null, $batch = false)
{
gotoSBGj0;
HiHC4:
$insert = $this
->db
->update($table, $data, array(
$pk => $id
));
gotoa8sEv;
n13_8:
$insert = $this
->db
->update_batch($table, $data, $pk);
gotoul1ll;
ul1ll:
gotoXdoGJ;
gotofd8JM;
pTk3d:
return $insert;
gotodVayL;
a8sEv:
XdoGJ:
gotopTk3d;
SBGj0:
if ($batch === false)
{
gotoGR8Dx;
}
goton13_8;
fd8JM:
GR8Dx:
gotoHiHC4;
dVayL:
}
public function delete($table, $data, $pk)
{
gotoK2Gpl;
K2Gpl:
$this
->db
->query("SET FOREIGN_KEY_CHECKS=0");
gotoTXAWE;
c36FV:
$deleted = $this
->db
->delete($table);
gotomIAgx;
mIAgx:
$this
->db
->query("SET FOREIGN_KEY_CHECKS=1");
gotoA8Wui;
A8Wui:
return $deleted;
gotox69Zd;
TXAWE:
$this
->db
->where_in($pk, $data);
gotoc36FV;
x69Zd:
}
public function delete_not($table, $data, $pk, $col, $not)
{
gotoKHelY;
c57cV:
$this
->db
->where($col . "!=" . $not);
gotombfDo;
KHelY:
$this
->db
->where_in($pk, $data);
gotoc57cV;
mbfDo:
return $this
->db
->delete($table);
gotoaD_g8;
aD_g8:
}
public function getDataKelas()
{
gotoSXkBj;
SXkBj:
$this
->datatables
->select("id_kelas, nama_kelas, id_jurusan, nama_jurusan");
gotowWfGL;
wWfGL:
$this
->datatables
->from("master_kelas");
gotoOZGyX;
kITqC:
return $this
->datatables
->generate();
gotohught;
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");
gotokITqC;
OZGyX:
$this
->datatables
->join("master_jurusan", "jurusan_id=id_jurusan");
gotozMYTU;
hught:
}
public function getKelasById($id)
{
gotoI0EJP;
sq3yk:
$this
->db
->where("id_kelas", $id);
gotocYOCQ;
Wgyfx:
$this
->db
->from("master_kelas");
gotosq3yk;
cYOCQ:
$this
->db
->order_by("nama_kelas");
gotoQV4VL;
QV4VL:
return $this
->db
->get()
->row();
gotol0MIM;
I0EJP:
$this
->db
->select("id_kelas, nama_kelas, level_id");
gotoWgyfx;
l0MIM:
}
public function getDataJurusan()
{
gotoU93gS;
BU0Ly:
return $this
->db
->get()
->result();
gototC3E_;
B1q15:
$this
->db
->from("master_jurusan");
gotoBU0Ly;
U93gS:
$this
->db
->select("*");
gotoB1q15;
tC3E_:
}
public function getDataJurusanMapel($arrIds)
{
gotorI_Ad;
q4mfp:
if (!$result)
{
gotowpOHj;
}
gotoMKlwH;
dX4ZV:
$this
->db
->from("master_mapel");
gotoyR5AB;
UVg1M:
$result = $this
->db
->get()
->result();
gotomKAg7;
bMk6d:
wpOHj:
gotoQeILI;
QeILI:
return $ret;
gotoPx5_7;
mKAg7:
$ret = [];
gotoq4mfp;
xDCxg:
Njxce:
gotobMk6d;
rI_Ad:
$this
->db
->select("id_mapel, nama_mapel");
gotodX4ZV;
yR5AB:
$this
->db
->where_in("id_mapel", $arrIds);
gotoUVg1M;
MKlwH:
foreach ($result as $key => $row)
{
$ret[$row
->id_mapel] = $row->nama_mapel;
gzZJc:
}
gotoxDCxg;
Px5_7:
}
public function getDataTableJurusan()
{
gotobOug9;
JHHNg:
$this
->datatables
->from("master_jurusan");
gotooEAd5;
Odsqk:
return $this
->datatables
->generate();
gotox0xEI;
bOug9:
$this
->datatables
->select("*");
gotoJHHNg;
oEAd5:
$this
->db
->order_by("id_jurusan");
gotoOdsqk;
x0xEI:
}
public function getJurusanById($id)
{
gotorNRka;
IX1R6:
return $this
->db
->get("master_jurusan")
->result();
gotoGvSo8;
dsqHn:
$this
->db
->order_by("nama_jurusan");
gotoIX1R6;
rNRka:
$this
->db
->where_in("id_jurusan", $id);
gotodsqHn;
GvSo8:
}
function updateJurusan()
{
gotogKsWq;
YDHD6:
EKWCr:
gotozRXrb;
h_5qy:
$this
->db
->set("nama_jurusan", $name);
gotokJNjk;
IR9Ge:
$this
->db
->set("status", "1");
gotohIM7J;
iz2kA:
if (!($i <= $row_mapels))
{
gotoUXHRd;
}
gotoXaIOf;
kJNjk:
$this
->db
->set("kode_jurusan", $kode);
gotogZX0A;
age7C:
UXHRd:
gotoXdafv;
hIM7J:
$this
->db
->where("id_jurusan", $id);
gotoDIoXZ;
DIoXZ:
return $this
->db
->update("master_jurusan");
gotobOZRF;
D2_eo:
$row_mapels = count($this
->input
->post("mapel", true));
gotos1Yr1;
Xdafv:
EtAsG:
gotoh_5qy;
FjwSX:
$kode = $this
->input
->post("kode_jurusan", true);
gotoj4z9Y;
s1Yr1:
$i = 0;
gotoqIQP0;
j4z9Y:
$mapels = [];
gotoFdXaj;
GKU2H:
gotoEphIn;
gotoage7C;
qIQP0:
EphIn:
gotoiz2kA;
zRXrb:
$i++;
gotoGKU2H;
VZqQa:
if (!$check_mapel)
{
gotoEtAsG;
}
gotoD2_eo;
FdXaj:
$check_mapel = $this
->input
->post("mapel", true);
gotoVZqQa;
gKsWq:
$id = $this
->input
->post("id_jurusan");
gotoBN0NQ;
XaIOf:
array_push($mapels, $this
->input
->post("mapel[" . $i . "]", true));
gotoYDHD6;
gZX0A:
$this
->db
->set("mapel_peminatan", implode(",", $mapels));
gotoIR9Ge;
BN0NQ:
$name = $this
->input
->post("nama_jurusan", true);
gotoFjwSX;
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)
{
gotoU53G1;
P7rC7:
return $query->result();
gotoieBVl;
ynRaO:
$this
->db
->from("master_siswa a");
gotot7LXn;
fLqSy:
$query = $this
->db
->get();
gotoP7rC7;
dJXTd:
$this
->db
->order_by("a.nama");
gotofLqSy;
U53G1:
$this
->db
->query("SET SQL_BIG_SELECTS=1");
gotojQmaD;
N_jof:
$this
->db
->join("master_kelas c", "c.id_kelas=b.id_kelas", "left");
gotowr7rj;
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");
gotoN_jof;
jQmaD:
$this
->db
->select("a.*, c.nama_kelas");
gotoynRaO;
wr7rj:
$this
->db
->order_by("b.id_kelas");
gotodJXTd;
ieBVl:
}
public function getSiswaByKelas($id_tp, $id_smt, $id_kelas)
{
gotoGCb1a;
hndCi:
$this
->db
->where("a.id_tp", $id_tp);
gotoLfY1R;
xFHZJ:
$this
->db
->from("kelas_siswa a");
gotoZkyYU;
LfY1R:
$this
->db
->where("a.id_smt", $id_smt);
gotoNHZel;
GCb1a:
$this
->db
->select("b.*");
gotoxFHZJ;
NHZel:
$this
->db
->where("a.id_siswa is NOT NULL", NULL, false);
gotobeJCG;
ZkyYU:
$this
->db
->join("master_siswa b", "b.id_siswa=a.id_siswa");
gotohndCi;
K_FU2:
return $this
->db
->get()
->result();
gotoeFYTI;
UM_Ab:
$this
->db
->where("a.id_kelas", $id_kelas);
gotoTPzne;
beJCG:
$this
->db
->where("b.id_siswa is NOT NULL", NULL, false);
gotoUM_Ab;
TPzne:
$this
->db
->order_by("b.nama", "ASC");
gotoK_FU2;
eFYTI:
}
public function getDataSiswa($id_tp, $id_smt)
{
goton8WBm;
HQR67:
return $this
->datatables
->generate();
gotoCObiX;
OsDZw:
$this
->datatables
->join("master_kelas f", "f.id_kelas=d.id_kelas", "left");
gotoptAqt;
n8WBm:
$this
->db
->query("SET SQL_BIG_SELECTS=1");
gotoPsdsR;
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");
gotocmzZK;
nefdv:
$this
->db
->order_by("f.nama_kelas", "ASC");
gotoWVLjs;
webcY:
$this
->datatables
->join("users c", "a.username=c.username");
gototWX5W;
WVLjs:
$this
->db
->order_by("b.status", "ASC");
gotoHQR67;
cCkB6:
$this
->datatables
->join("buku_induk b", "a.id_siswa=b.id_siswa", "left");
gotowebcY;
cmzZK:
$this
->datatables
->from("master_siswa a");
gotocCkB6;
ptAqt:
$this
->db
->order_by("ISNULL(f.level_id), f.level_id ASC");
gotonefdv;
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");
gotoOsDZw;
CObiX:
}
public function getAllSiswa($id_tp, $id_smt, $offset, $limit, $search = null, $sort = null, $order = null)
{
gotoDITkC;
J4GSX:
HGoxL:
gotoTHiAj;
QTmDg:
$this
->db
->or_like("a.nisn", $search);
gotoJ4GSX;
Una0k:
$this
->db
->from("master_siswa a");
gotoh2d2d;
eyytq:
$this
->db
->join("master_kelas f", "f.id_kelas=d.id_kelas", "left");
gotohxSyW;
THiAj:
return $this
->db
->get()
->result();
gotot2zdg;
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");
gotoUna0k;
hVDhg:
$this
->db
->or_like("a.nis", $search);
gotoQTmDg;
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");
gotoeyytq;
hxSyW:
if (!($search != null))
{
gotoHGoxL;
}
gotowxGyF;
zQZVx:
$this
->db
->order_by("a.nama", "ASC");
gotoXU3Z0;
wxGyF:
$this
->db
->like("a.nama", $search);
gotohVDhg;
h2d2d:
$this
->db
->limit($limit, $offset);
gotozQZVx;
t2zdg:
}
public function getSiswaPage($id_tp, $id_smt, $offset, $limit, $filter, $search = null, $sort = null, $order = null)
{
gotonHyif;
Prchh:
$this
->db
->from("master_siswa a");
gotomP2Kl;
Lz8hy:
if (!($filter == "1"))
{
gotoSXr9w;
}
gotoATkPo;
yQdp7:
BSfrp:
gotoOq2Z6;
ptwUC:
SXr9w:
gotoxO855;
mP2Kl:
$this
->db
->limit($limit, $offset);
gotoq0Fdj;
fGMju:
iW82O:
gotoAQ4QZ;
Oq2Z6:
return $this
->db
->get()
->result();
gotoSZ44m;
j4Kyq:
$this
->db
->where("f.id_kelas IS NULL");
gotoZNPoi;
sAfio:
$this
->db
->or_like("a.nisn", $search);
gotoyQdp7;
gvR5D:
$this
->db
->order_by("a.nama", "ASC");
gotoJ3Oz_;
J3Oz_:
if (!($search != null))
{
gotoBSfrp;
}
gotoqGSxc;
GGuXT:
$this
->db
->join("master_kelas f", "f.id_kelas=d.id_kelas", "left");
gotoj4Kyq;
hNIrr:
$this
->db
->or_like("a.nis", $search);
gotosAfio;
xO855:
gotoSGJFF;
gotofGMju;
qGSxc:
$this
->db
->like("a.nama", $search);
gotohNIrr;
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");
gotoPrchh;
bMB5N:
$this
->db
->join("master_kelas f", "f.id_kelas=d.id_kelas", "left");
gotoLz8hy;
ATkPo:
$this
->db
->where("f.id_kelas IS NOT NULL");
gotoptwUC;
zlHfo:
$this
->db
->join("buku_induk u", "u.id_siswa=a.id_siswa AND u.status = " . $filter);
gotobMB5N;
ZNPoi:
SGJFF:
gotoLwqiF;
LwqiF:
$this
->db
->order_by("f.nama_kelas", "ASC");
gotoIDwEZ;
bwZ6C:
if ($filter == "5")
{
gotoiW82O;
}
gotozlHfo;
IDwEZ:
$this
->db
->order_by("ISNULL(f.level_id), f.level_id ASC");
gotogvR5D;
AQ4QZ:
$this
->db
->join("buku_induk u", "u.id_siswa=a.id_siswa AND u.status = "1"");
gotoGGuXT;
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");
gotobwZ6C;
SZ44m:
}
public function getSiswaTotalPage($id_tp, $id_smt, $filter, $search = null)
{
gotoIfsEB;
IfsEB:
$this
->db
->select("a.id_siswa");
gotojC1NZ;
XwejJ:
$this
->db
->join("master_kelas f", "f.id_kelas=d.id_kelas", "left");
gotoQLMRM;
GmDsn:
PPAML:
gotohb1mw;
mXzTm:
$this
->db
->where("f.id_kelas IS NOT NULL");
gotoGmDsn;
CRJbr:
$this
->db
->join("buku_induk u", "u.id_siswa=a.id_siswa AND u.status = " . $filter);
gotoXwejJ;
ZXdkd:
if ($filter == "5")
{
gotofv0rc;
}
gotoCRJbr;
F9H1Y:
$this
->db
->or_like("a.nis", $search);
gotoOIlr2;
jp1tb:
MVf8Z:
gotog5EY6;
O757c:
fv0rc:
gotokXewR;
mIWR2:
N0pBC:
gotooBJRb;
ITCQ0:
$this
->db
->like("a.nama", $search);
gotoF9H1Y;
X9oF3:
$this
->db
->where("f.id_kelas IS NULL");
gotojp1tb;
hb1mw:
gotoMVf8Z;
gotoO757c;
kXewR:
$this
->db
->join("buku_induk u", "u.id_siswa=a.id_siswa AND u.status = "1"");
gotonA5ei;
OIlr2:
$this
->db
->or_like("a.nisn", $search);
gotomIWR2;
nA5ei:
$this
->db
->join("master_kelas f", "f.id_kelas=d.id_kelas", "left");
gotoX9oF3;
QLMRM:
if (!($filter == "1"))
{
gotoPPAML;
}
gotomXzTm;
jC1NZ:
$this
->db
->from("master_siswa a");
gotoyHOVu;
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");
gotoZXdkd;
oBJRb:
return $this
->db
->get()
->num_rows();
gotouze3l;
g5EY6:
if (!($search != null))
{
gotoN0pBC;
}
gotoITCQ0;
uze3l:
}
public function getDataSiswaByKelas($id_tp, $id_smt, $id_kelas, $offset, $limit, $search = null, $sort = null, $order = null)
{
gotop3N4X;
Zvs17:
return $this
->db
->get()
->result();
gotolfR1n;
z85FI:
$this
->db
->like("b.nama", $search);
gotoTs8Op;
FiWu6:
WSVeE:
gotoE2Hm0;
PDWGm:
$this
->db
->join("master_kelas f", "f.id_kelas=a.id_kelas");
gotos_Dsr;
I03G4:
if (!($search != null))
{
gotoa2X1v;
}
gotoz85FI;
jaSOi:
$this
->db
->where("a.id_kelas", $id_kelas);
gotoZvs17;
Ts8Op:
$this
->db
->or_like("b.nis", $search);
gotoixBkW;
Bi1Sv:
a2X1v:
gotoPDWGm;
scWTP:
$this
->db
->limit($limit, $offset);
gotoFiWu6;
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");
gotoSfJO9;
o3o6p:
$this
->db
->where("a.id_smt", $id_smt);
gotojaSOi;
SfJO9:
$this
->db
->from("kelas_siswa a");
gotoFsVhB;
ixBkW:
$this
->db
->or_like("b.nisn", $search);
gotoBi1Sv;
s_Dsr:
$this
->db
->where("a.id_tp", $id_tp);
gotoo3o6p;
FsVhB:
if (!($limit > 0))
{
gotoWSVeE;
}
gotoscWTP;
E2Hm0:
$this
->db
->join("master_siswa b", "b.id_siswa=a.id_siswa", "right");
gotoI03G4;
lfR1n:
}
public function getDataSiswaByKelasPage($id_tp, $id_smt, $id_kelas, $search = null)
{
gotoYEMQA;
sMNTn:
$this
->db
->where("a.id_tp", $id_tp);
gotoISX8d;
o1myt:
$this
->db
->from("kelas_siswa a");
gotosMNTn;
Mx3_u:
$this
->db
->where("a.id_kelas", $id_kelas);
gotojI8O5;
HnqKK:
return $this
->db
->get()
->num_rows();
gotoQ4ndz;
tpnNz:
$this
->db
->or_like("b.nis", $search);
gototFBCG;
jSnDS:
J5ZEb:
gotoHnqKK;
ISX8d:
$this
->db
->where("a.id_smt", $id_smt);
gotoMx3_u;
Jn4Pu:
$this
->db
->like("b.nama", $search);
gototpnNz;
yMFu0:
if (!($search != null))
{
gotoJ5ZEb;
}
gotoJn4Pu;
jI8O5:
$this
->db
->join("master_siswa b", "b.id_siswa=a.id_siswa");
gotoyMFu0;
YEMQA:
$this
->db
->select("a.id_siswa");
gotoo1myt;
tFBCG:
$this
->db
->or_like("b.nisn", $search);
gotojSnDS;
Q4ndz:
}
public function getSiswaById($id)
{
gotoqP1sK;
j0A_k:
return $this
->db
->get()
->row();
gotoWRJyO;
LsI7e:
$this
->db
->join("buku_induk b", "a.id_siswa=b.id_siswa", "left");
gotogfFNw;
gfFNw:
$this
->db
->where("a.id_siswa", $id);
gotoj0A_k;
z8Usg:
$this
->db
->from("master_siswa a");
gotoLsI7e;
qP1sK:
$this
->db
->select("a.*, b.status");
gotoz8Usg;
WRJyO:
}
public function getSiswaByArrNisn($arr_nisn, $arr_nis, $arr_username)
{
gotocIWsv;
FX745:
$this
->db
->or_where_in("username", $arr_username);
gotoj6OwK;
fq1wG:
$this
->db
->from("master_siswa");
gotoKoyjS;
KoyjS:
$this
->db
->where_in("nisn", $arr_nisn);
gotoBbby8;
Bbby8:
$this
->db
->or_where_in("nis", $arr_nis);
gotoFX745;
j6OwK:
return $this
->db
->get()
->result();
gotoWsXqK;
cIWsv:
$this
->db
->select("id_siswa, nama, nisn, nis, username");
gotofq1wG;
WsXqK:
}
public function getSiswaKelasBaru($id_tp, $id_smt)
{
gotonKFBO;
h9sUv:
u71xz:
gotoAyGKi;
n_9Wu:
if (!$result)
{
gotou7iDF;
}
gotowVTSo;
gKRJK:
$ret = [];
goton_9Wu;
nKFBO:
$this
->db
->query("SET SQL_BIG_SELECTS=1");
gotoAIycu;
gJv1s:
$this
->db
->join("master_kelas f", "f.id_kelas=a.id_kelas");
gotoe9X5B;
AyGKi:
u7iDF:
gotoyOgAa;
Q1HV_:
$this
->db
->where("a.id_smt", $id_smt);
gotoKPseG;
wVTSo:
foreach ($result as $key => $row)
{
$ret[$row->id_siswa] = $row;
k5T0o:
}
gotoh9sUv;
AIycu:
$this
->db
->select("b.id_siswa, b.nama, f.id_kelas, f.nama_kelas, f.kode_kelas");
gotozx_tZ;
LEqhL:
$this
->db
->join("master_siswa b", "b.id_siswa=a.id_siswa");
gotogJv1s;
zx_tZ:
$this
->db
->from("kelas_siswa a");
gotoLEqhL;
yOgAa:
return $ret;
gotoKMGPU;
KPseG:
$result = $this
->db
->get()
->result();
gotogKRJK;
e9X5B:
$this
->db
->where("a.id_tp", $id_tp);
gotoQ1HV_;
KMGPU:
}
public function getDataSiswaById($id_tp, $id_smt, $idSiswa)
{
gotovhNNi;
r1JKl:
$this
->db
->join("cbt_ruang i", "i.id_ruang=h.id_ruang", "left");
gotoCdW3t;
lpRjA:
$this
->db
->where("a.id_siswa", $idSiswa);
gotoCw0x1;
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");
gotodLdDi;
cRe37:
$this
->db
->join("cbt_ruang d", "d.id_ruang=c.ruang_id", "left");
gotoU3j81;
D3YAv:
$this
->db
->join("cbt_sesi_siswa c", "c.siswa_id=a.id_siswa", "left");
gotocRe37;
ZHfEP:
$this
->db
->join("master_kelas f", "f.id_kelas=a.id_kelas", "left");
gotoEDDhc;
dLdDi:
$this
->db
->from("kelas_siswa a");
gotosj1yt;
uEft2:
$this
->db
->where("a.id_tp", $id_tp);
gotoPYKtn;
CdW3t:
$this
->db
->join("cbt_sesi j", "j.id_sesi=h.id_sesi", "left");
gotouEft2;
PYKtn:
$this
->db
->where("a.id_smt", $id_smt);
gotolpRjA;
gS9KF:
$this
->db
->join("cbt_kelas_ruang h", "h.id_kelas=a.id_kelas", "left");
gotor1JKl;
Cw0x1:
return $this
->db
->get()
->row();
gotolBzl0;
sj1yt:
$this
->db
->join("master_siswa b", "b.id_siswa=a.id_siswa", "left");
gotoD3YAv;
U3j81:
$this
->db
->join("cbt_sesi e", "e.id_sesi=c.sesi_id", "left");
gotoZHfEP;
EDDhc:
$this
->db
->join("cbt_nomor_peserta g", "g.id_siswa=a.id_siswa AND g.id_tp=" . $id_tp, "left");
gotogS9KF;
vhNNi:
$this
->db
->query("SET SQL_BIG_SELECTS=1");
gotoAbG1x;
lBzl0:
}
public function getAgamaSiswa()
{
gotoByABJ;
tzzKz:
foreach ($result as $row)
{
$ret[$row
->agama] = $row->agama;
llxr1:
}
gotoC8qUp;
G8md6:
$this
->db
->not_like("a.agama", "Pilih");
gotowhTOF;
whTOF:
$result = $this
->db
->get()
->result();
gotoR7xf7;
nCi0f:
$this
->db
->where("a.agama != "0"", NULL, false);
gotoG8md6;
jaVCA:
$this
->db
->where("a.agama is NOT NULL", NULL, false);
gotonCi0f;
kuCVg:
$this
->db
->distinct();
gotoL5HfU;
C8qUp:
dSO1i:
gotoT2qZy;
ByABJ:
$this
->db
->select("agama");
gotokuCVg;
R7xf7:
$ret["-"] = "Bukan Mapel Agama";
gototzzKz;
T2qZy:
return $ret;
gotoeVw7W;
L5HfU:
$this
->db
->from("master_siswa a");
gotojaVCA;
eVw7W:
}
public function getJurusan()
{
gotozX75G;
vk2iH:
$this
->db
->join("master_jurusan", "jurusan_id=id_jurusan");
gotoblhEk;
cKPOs:
$this
->db
->group_by("id_jurusan");
gotohpJKn;
GC8Ls:
return $query->result();
gotobc3kW;
blhEk:
$this
->db
->order_by("nama_jurusan", "ASC");
gotocKPOs;
kABjL:
$this
->db
->from("master_kelas");
gotovk2iH;
zX75G:
$this
->db
->select("id_jurusan, nama_jurusan");
gotokABjL;
hpJKn:
$query = $this
->db
->get();
gotoGC8Ls;
bc3kW:
}
public function getAllJurusan($id = null)
{
gotofz0vQ;
kWylP:
eKqJB:
gotorgw8j;
Av4dg:
$this
->db
->from("jurusan_mapel");
gotojdf4Y;
bZn_2:
kBp3u:
gotoh5vqV;
Mr6On:
$this
->db
->from("master_jurusan");
gotoEzo4a;
RRtoF:
$this
->db
->order_by("nama_jurusan", "ASC");
gotoHlVoD;
mjBWK:
es3LY:
gotoRRtoF;
RA1NB:
$jurusan = $this
->db
->get()
->result();
gotoc809O;
fz0vQ:
if ($id === null)
{
gotoes3LY;
}
gotolXQLp;
VEuk3:
return $this
->db
->get()
->result();
gotomWx2q;
c809O:
$id_jurusan = [];
gotouH2qi;
Ezo4a:
$this
->db
->where_not_in("id_jurusan", $id_jurusan);
gotoVEuk3;
uH2qi:
foreach ($jurusan as $j)
{
$id_jurusan[] = $j->jurusan_id;
Sl6Vt:
}
gotoDfO4f;
DfO4f:
dl01N:
gotoJINQV;
P3KfC:
$id_jurusan = null;
gotobZn_2;
mWx2q:
gotoeKqJB;
gotomjBWK;
jdf4Y:
$this
->db
->where("mapel_id", $id);
gotoRA1NB;
lXQLp:
$this
->db
->select("jurusan_id");
gotoAv4dg;
HlVoD:
return $this
->db
->get("jurusan")
->result();
gotokWylP;
JINQV:
if (!($id_jurusan === []))
{
gotokBp3u;
}
gotoP3KfC;
h5vqV:
$this
->db
->select("*");
gotoMr6On;
rgw8j:
}
public function getKelasByJurusan($id)
{
$query = $this
->db
->get_where("master_kelas", array(
"jurusan_id" => $id
));
return $query->result();
}
public function getDataGuru($tp, $smt)
{
gotoNapVU;
n3Udd:
$this
->datatables
->join("master_smt f", "b.id_smt=f.id_smt", "left");
gotoQKw0O;
fP0J_:
$this
->datatables
->join("master_kelas d", "b.id_kelas=d.id_kelas AND d.id_tp=" . $tp . " AND d.id_smt=" . $smt . '', "left");
gotoG0w6s;
QKw0O:
return $this
->datatables
->generate();
gotontqau;
Vilm7:
$this
->datatables
->from("master_guru a");
gotoz50f3;
G0w6s:
$this
->datatables
->join("master_tp e", "b.id_tp=e.id_tp", "left");
goton3Udd;
wwF3H:
$this
->datatables
->join("level_guru c", "b.id_jabatan=c.id_level", "left");
gotofP0J_;
NapVU:
$this
->db
->query("SET SQL_BIG_SELECTS=1");
gotoBO1X7;
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");
gotoVilm7;
z50f3:
$this
->datatables
->join("jabatan_guru b", "a.id_guru=b.id_guru AND b.id_tp=" . $tp . " AND b.id_smt=" . $smt . '', "left");
gotowwF3H;
ntqau:
}
public function getAllDataGuru($tp, $smt)
{
gotofs3gD;
u4k5E:
$this
->db
->join("jabatan_guru b", "a.id_guru=b.id_guru AND b.id_tp=" . $tp . " AND b.id_smt=" . $smt . '', "left");
gotoRSwGi;
rFG9n:
$this
->db
->from("master_guru a");
gotou4k5E;
nrtH9:
$this
->db
->join("master_tp e", "b.id_tp=e.id_tp", "left");
gotoo0aEF;
RSwGi:
$this
->db
->join("level_guru c", "b.id_jabatan=c.id_level", "left");
gotowhMUr;
kbB1E:
$this
->db
->order_by("c.id_level", "desc");
gotop25H5;
fs3gD:
$this
->db
->query("SET SQL_BIG_SELECTS=1");
gotoWT30m;
Cyncj:
return $this
->db
->get()
->result();
gotoBMhFw;
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");
gotorFG9n;
o0aEF:
$this
->db
->join("master_smt f", "b.id_smt=f.id_smt", "left");
gotokbB1E;
p25H5:
$this
->db
->order_by("a.id_guru", "asc");
gotoCyncj;
whMUr:
$this
->db
->join("master_kelas d", "b.id_kelas=d.id_kelas AND d.id_tp=" . $tp . " AND d.id_smt=" . $smt . '', "left");
gotonrtH9;
BMhFw:
}
public function getGuruById($id, $id_tp = null, $id_smt = null)
{
gotofwK1U;
G8uDN:
D8Y_P:
gotovwaGA;
FoFjU:
$this
->db
->join("jabatan_guru b", "a.id_guru=b.id_guru", "left");
gotoBH2xo;
BH2xo:
$this
->db
->join("level_guru c", "b.id_jabatan=c.id_level", "left");
gotof2ELT;
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");
gotoG8uDN;
p_0sE:
return $this
->db
->get()
->row();
gotoWGIBa;
f2ELT:
if (!($id_tp != null && $id_smt != null))
{
gotoD8Y_P;
}
gotocjx6x;
cPqMz:
$this
->db
->select("*");
gotoDrHLj;
fwK1U:
$this
->db
->query("SET SQL_BIG_SELECTS=1");
gotocPqMz;
DrHLj:
$this
->db
->from("master_guru a");
gotoFoFjU;
vwaGA:
$this
->db
->where("a.id_guru", $id);
gotop_0sE;
WGIBa:
}
public function getGuruByArrId($arr_id)
{
gotou09HV;
YO2QQ:
if (!(count($arr_id) > 0))
{
gotoqaezi;
}
gotohX9PJ;
hX9PJ:
$this
->db
->where_in("id_guru", $arr_id);
gotolzfBV;
Vhhbi:
$this
->db
->from("master_guru");
gotoYO2QQ;
Nv3W3:
return $this
->db
->get()
->result();
gotovaVyc;
lzfBV:
qaezi:
gotoNv3W3;
u09HV:
$this
->db
->select("nama_guru, nip");
gotoVhhbi;
vaVyc:
}
public function getUserIdGuruByUsername($username)
{
gotoLGhdU;
KpFGb:
$this
->db
->join("level_guru c", "b.id_jabatan=c.id_level", "left");
gototwovJ;
LGhdU:
$this
->db
->query("SET SQL_BIG_SELECTS=1");
gotoQ1Ci4;
Q1Ci4:
$this
->db
->select("*");
gotouor3w;
uor3w:
$this
->db
->from("master_guru a");
gotof3snX;
PyXcU:
return $this
->db
->get()
->row();
gotoJAtk0;
twovJ:
$this
->db
->where("a.username", $username);
gotoPyXcU;
f3snX:
$this
->db
->join("jabatan_guru b", "a.id_guru=b.id_guru", "left");
gotoKpFGb;
JAtk0:
}
public function getDetailJabatanGuru($id_guru)
{
gotovFg_8;
GWERP:
ZJ455:
gotoXCAza;
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");
gotow2j0N;
SxRM7:
$ret = [];
gotou45m2;
p_WZy:
$this
->db
->where("a.id_guru", $id_guru);
gotoftShE;
w2j0N:
$this
->db
->from("master_guru a");
gotoz7Pm3;
XCAza:
return $ret;
gotofoGYx;
vFg_8:
$this
->db
->query("SET SQL_BIG_SELECTS=1");
gotot2gvG;
z7Pm3:
$this
->db
->join("jabatan_guru b", "a.id_guru=b.id_guru", "left");
gotoIOWYO;
IOWYO:
$this
->db
->join("level_guru c", "b.id_jabatan=c.id_level", "left");
gotoM8Xmt;
M8Xmt:
$this
->db
->join("master_kelas d", "b.id_kelas=d.id_kelas", "left");
gotop_WZy;
u45m2:
foreach ($result as $row)
{
$ret[$row->id_tp][$row->id_smt] = $row;
El7Jn:
}
gotoGWERP;
ftShE:
$result = $this
->db
->get()
->result();
gotoSxRM7;
foGYx:
}
public function getJabatanGuru($id_guru, $tp, $smt)
{
gotoFFZoA;
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");
gotoL1AQl;
EB35n:
$this
->db
->join("master_kelas d", "b.id_kelas=d.id_kelas AND d.id_tp=" . $tp . " AND d.id_smt=" . $smt . '', "left");
gotoSx9cL;
FFZoA:
$this
->db
->query("SET SQL_BIG_SELECTS=1");
gotoEidmE;
Sx9cL:
$this
->db
->where("a.id_guru", $id_guru);
gotomIAod;
L1AQl:
$this
->db
->from("master_guru a");
gotoKRcIU;
c4eVJ:
$this
->db
->join("level_guru c", "b.id_jabatan=c.id_level", "left");
gotoEB35n;
mIAod:
return $this
->db
->get()
->row();
gotoRIkkT;
KRcIU:
$this
->db
->join("jabatan_guru b", "a.id_guru=b.id_guru AND b.id_tp=" . $tp . " AND b.id_smt=" . $smt . '', "left");
gotoc4eVJ;
RIkkT:
}
public function getGuruMapel($tp, $smt)
{
gotoannYi;
annYi:
$this
->db
->select("a.mapel_kelas, a.ekstra_kelas, a.id_jabatan, a.id_kelas, b.id_guru, b.nama_guru");
gotox5ZbT;
ba9eZ:
return $this
->db
->get()
->result();
gotoBdmPq;
x5ZbT:
$this
->db
->from("jabatan_guru a");
gotoNOXUb;
NOXUb:
$this
->db
->join("master_guru b", "a.id_guru=b.id_guru");
gotoJSbFW;
JSbFW:
$this
->db
->where("a.id_tp", $tp);
gotofvXDf;
fvXDf:
$this
->db
->where("a.id_smt", $smt);
gotoba9eZ;
BdmPq:
}
public function getKodeKelompokMapel()
{
gotoEfey2;
WirIA:
$ret = [];
gotonYngZ;
Mx6Xy:
ka7qB:
gotosO13X;
mDKJx:
$result = $this
->db
->get()
->result();
gotoWirIA;
Efey2:
$this
->db
->select("*");
gotoN_CV8;
nYngZ:
foreach ($result as $row)
{
$ret[$row->kode_kel_mapel] = $row;
ASbqA:
}
gotoMx6Xy;
N_CV8:
$this
->db
->from("master_kelompok_mapel");
gotokKAld;
sO13X:
return $ret;
gotoCmxRL;
kKAld:
$this
->db
->order_by("kode_kel_mapel");
gotomDKJx;
CmxRL:
}
public function getDataKelompokMapel()
{
gotoN0aRP;
nFjcY:
$this
->db
->where("id_parent", "0");
gotox3kIL;
x3kIL:
$this
->db
->order_by("kode_kel_mapel");
gototGYC2;
X5yMe:
fweyk:
gotoBSGdv;
tGYC2:
$result = $this
->db
->get()
->result();
gotovVkK3;
ljWMV:
foreach ($result as $row)
{
$ret[$row->id_kel_mapel] = $row;
SkABx:
}
gotoX5yMe;
N0aRP:
$this
->db
->select("*");
gotoptHhV;
BSGdv:
return $ret;
gotoNGjnh;
ptHhV:
$this
->db
->from("master_kelompok_mapel");
gotonFjcY;
vVkK3:
$ret = [];
gotoljWMV;
NGjnh:
}
public function getKategoriKelompokMapel()
{
gotoYH177;
LrZBu:
$this
->db
->from("master_kelompok_mapel");
gototvvAw;
AKpGJ:
$this
->db
->where("kategori", "WAJIB")
->or_where("kategori", "PAI (Kemenag)");
gotoLrZBu;
YH177:
$this
->db
->select("kode_kel_mapel, kategori");
gotoAKpGJ;
tvvAw:
return $this
->db
->get()
->result();
gotoAurdY;
AurdY:
}
public function getDataSubKelompokMapel()
{
gotoSYpTH;
d37ej:
$this
->db
->where("id_parent <> 0");
gotoN72qO;
xt9sX:
UlHWo:
gotouYJG4;
SYpTH:
$this
->db
->select("*");
gotocRiwx;
oCMhF:
$result = $this
->db
->get()
->result();
gotofzeBT;
fzeBT:
$ret = [];
gotogVSim;
gVSim:
foreach ($result as $row)
{
$ret[$row->id_kel_mapel] = $row;
pwb9T:
}
gotoxt9sX;
N72qO:
$this
->db
->order_by("kode_kel_mapel");
gotooCMhF;
uYJG4:
return $ret;
gotoA_szD;
cRiwx:
$this
->db
->from("master_kelompok_mapel");
gotod37ej;
A_szD:
}
public function getDataMapel()
{
gotobCDLz;
bCDLz:
$this
->datatables
->select("id_mapel, nama_mapel, kode");
gotomwF4n;
mwF4n:
$this
->datatables
->from("master_mapel");
gotoQH1Nc;
QH1Nc:
return $this
->datatables
->generate();
gotoOkzmG;
OkzmG:
}
public function getAllMapel($arrKelompok = null, $arrMapel = null)
{
gotoC0pJX;
C4RO8:
$this
->db
->where_in("kelompok", $arrKelompok);
gotobWemv;
zwCZT:
$this
->db
->where("status", "1");
gotocKX3a;
C0pJX:
if (!($arrMapel != null))
{
gotod0hxp;
}
gotoC4RO8;
wBCGu:
et1ji:
gotozwCZT;
cKX3a:
$this
->db
->order_by("urutan_tampil");
gotoiRMp7;
Ah21T:
if (!($arrMapel != null))
{
gotoet1ji;
}
gotot68l4;
iRMp7:
return $this
->db
->get("master_mapel")
->result();
gotoic1QJ;
t68l4:
$this
->db
->or_where_in("id_mapel", explode(",", $arrMapel));
gotowBCGu;
bWemv:
d0hxp:
gotoAh21T;
ic1QJ:
}
public function getAllStatusMapel($arrKelompok = null, $arrMapel = null)
{
gotoH07iA;
Wimdl:
if (!($arrMapel != null))
{
gotofJO27;
}
gotoSK9W7;
P8_wR:
fJO27:
gotoN8vZQ;
SgMQM:
return $this
->db
->get("master_mapel")
->result();
gotoX4J67;
H07iA:
if (!($arrMapel != null))
{
gotoPGgbf;
}
gotohWNhh;
N8vZQ:
$this
->db
->order_by("urutan_tampil");
gotoSgMQM;
hWNhh:
$this
->db
->where_in("kelompok", $arrKelompok);
gotoIeBOL;
SK9W7:
$this
->db
->or_where_in("id_mapel", explode(",", $arrMapel));
gotoP8_wR;
IeBOL:
PGgbf:
gotoWimdl;
X4J67:
}
public function getAllMapelByKelompok($jenjang)
{
gotoxciRO;
a_XX4:
$ret = [];
gotoGsMKs;
mq09_:
return $ret;
gotoPNlCB;
xciRO:
$this
->db
->where("status", "1");
gotorDZLU;
KtkRR:
$this
->db
->order_by("urutan_tampil");
gotoZKHUC;
ZKHUC:
$result = $this
->db
->get("master_mapel")
->result();
gotoa_XX4;
g0gdn:
kzn6C:
gotomq09_;
rDZLU:
$this
->db
->order_by("urutan");
gotoKtkRR;
GsMKs:
foreach ($result as $row)
{
$ret[$row->kelompok][] = $row;
ouHsY:
}
gotog0gdn;
PNlCB:
}
public function getAllMapelNonAktif($jenjang)
{
$this
->db
->where("status", "0");
return $this
->db
->get("master_mapel")
->result();
}
public function getMapelById($id, $single = false)
{
gotoB18of;
VG7_0:
$this
->db
->order_by("nama_mapel");
gotoARhIG;
k8lIm:
return $query;
gotonQfNJ;
aZKwh:
gotol6wF8;
gotoDWylE;
AZFsG:
$query = $this
->db
->get_where("master_mapel", array(
"id_mapel" => $id
))->row();
gotoaZKwh;
DWylE:
qOtQi:
gotoB_AHy;
B_AHy:
$this
->db
->where_in("id_mapel", $id);
gotoVG7_0;
ARhIG:
$query = $this
->db
->get("master_mapel")
->result();
gotoeHymO;
B18of:
if ($single === false)
{
gotoqOtQi;
}
gotoAZFsG;
eHymO:
l6wF8:
gotok8lIm;
nQfNJ:
}
function updateMapel()
{
gotoa4hVm;
eDD1v:
$kelompok = $this
->input
->post("kelompok", true);
gotor3QSC;
hqk_O:
$kode = $this
->input
->post("kode_mapel", true);
gotoeDD1v;
r3QSC:
$status = $this
->input
->post("status", true);
gotoklM44;
EqHCk:
$name = $this
->input
->post("nama_mapel", true);
gotohqk_O;
ItOPl:
$this
->db
->where("id_mapel", $id);
gotoDWDqu;
DWDqu:
return $this
->db
->update("master_mapel");
gotobS6om;
klM44:
$urut = $this
->input
->post("urutan_tampil", true);
gotojPGBp;
P9H32:
$this
->db
->set("status", $status);
gotowKLQT;
kgXHk:
amtN0:
gotoP9H32;
a4hVm:
$id = $this
->input
->post("id_mapel");
gotoEqHCk;
wKLQT:
$this
->db
->set("urutan_tampil", $urut);
gotoItOPl;
vo0BK:
$this
->db
->set("kode", $kode);
gotojVz5o;
jVz5o:
if (!($kelompok != null))
{
gotoamtN0;
}
gotoYVaKb;
YVaKb:
$this
->db
->set("kelompok", $kelompok);
gotokgXHk;
jPGBp:
$this
->db
->set("nama_mapel", $name);
gotovo0BK;
bS6om:
}
public function getAllEkstra()
{
return $this
->db
->get("master_ekstra")
->result();
}
public function getEkstraById($id, $single = false)
{
gotoc9k_I;
Ll5n9:
return $query;
gotoM0uA3;
EVfCI:
op6Qh:
gotoUdZ1e;
y8SdQ:
$query = $this
->db
->get("master_ekstra")
->result();
gotovxF_0;
ur9RA:
gotok0E3Q;
gotoEVfCI;
G8kIr:
$query = $this
->db
->get_where("master_ekstra", array(
"id_ekstra" => $id
))->row();
gotour9RA;
c9k_I:
if ($single === false)
{
gotoop6Qh;
}
gotoG8kIr;
vxF_0:
k0E3Q:
gotoLl5n9;
UdZ1e:
$this
->db
->where_in("id_ekstra", $id);
gotoFsdFq;
FsdFq:
$this
->db
->order_by("nama_ekstra");
gotoy8SdQ;
M0uA3:
}
function updateEkstra()
{
gotoGVSQ7;
vYWtA:
return $this
->db
->update("master_ekstra");
gotoit9zG;
GVSQ7:
$id = $this
->input
->post("id_ekstra");
gotoH8m30;
cJN5Z:
$this
->db
->set("nama_ekstra", $name);
gotoAxQDw;
Fta8l:
$this
->db
->where("id_ekstra", $id);
gotovYWtA;
H8m30:
$name = $this
->input
->post("nama_ekstra", true);
gotoqjUy0;
AxQDw:
$this
->db
->set("kode_ekstra", $kode);
gotoFta8l;
qjUy0:
$kode = $this
->input
->post("kode_ekstra", true);
gotocJN5Z;
it9zG:
}
public function getKelasGuru()
{
gotoZ75dM;
LrBZe:
return $this
->datatables
->generate();
gotoWKABX;
M4WTK:
$this
->datatables
->select("kelas_guru.id, guru.id_guru, guru.nip, guru.nama_guru, GROUP_CONCAT(master_kelas.nama_kelas) as kelas");
gototg3xh;
fdP81:
$this
->datatables
->group_by("guru.nama_guru");
gotoLrBZe;
Q6clt:
$this
->datatables
->join("master_kelas", "kelas_id=id_kelas");
gotox6dzj;
tg3xh:
$this
->datatables
->from("kelas_guru");
gotoQ6clt;
x6dzj:
$this
->datatables
->join("master_guru", "guru_id=id_guru");
gotofdP81;
Z75dM:
$this
->db
->query("SET SQL_BIG_SELECTS=1");
gotoM4WTK;
WKABX:
}
public function getKelasByGuru($id)
{
gotoX5Udd;
f3uTD:
$this
->db
->where("guru_id", $id);
gotokAxkL;
Ss9vB:
$this
->db
->join("master_kelas", "kelas_guru.kelas_id=kelas.id_kelas");
gotof3uTD;
X5Udd:
$this
->db
->select("kelas.id_kelas");
gotoQk3KF;
Qk3KF:
$this
->db
->from("kelas_guru");
gotoSs9vB;
kAxkL:
return $this
->db
->get()
->result();
gotok7cos;
k7cos:
}
public function getAllJabatanGuru($id)
{
gotocaClc;
yNmUz:
up_oR:
gotosHkhZ;
mpS8r:
return $ret;
gotoLsvw_;
caClc:
$result = $this
->db
->get_where("jabatan_guru", "id_guru=" . $id)->result();
gotoadWNF;
e_Dw2:
foreach ($result as $key => $row)
{
$ret[$row->id_tp][$row
->id_smt] = $row->id_kelas;
Y2uec:
}
gotoyNmUz;
adWNF:
$ret = [];
gotog_GNx;
sHkhZ:
AzQOK:
gotompS8r;
g_GNx:
if (!$result)
{
gotoAzQOK;
}
gotoe_Dw2;
Lsvw_:
}
public function getJurusanMapel()
{
gotoTJycE;
p5p_I:
$this
->datatables
->from("jurusan_mapel");
gotos3TLa;
C6B5M:
$this
->datatables
->join("master_jurusan", "jurusan_id=id_jurusan");
gotogMnxn;
Ng5xO:
return $this
->datatables
->generate();
gotoLYpdq;
gMnxn:
$this
->datatables
->group_by("master_mapel.nama_mapel");
gotoNg5xO;
TJycE:
$this
->db
->query("SET SQL_BIG_SELECTS=1");
gotohJhXu;
s3TLa:
$this
->datatables
->join("master_mapel", "mapel_id=id_mapel");
gotoC6B5M;
hJhXu:
$this
->datatables
->select("jurusan_mapel.id, mapel.id_mapel, mapel.nama_mapel, jurusan.id_jurusan, GROUP_CONCAT(jurusan.nama_jurusan) as nama_jurusan");
gotop5p_I;
LYpdq:
}
public function getMapel($id = null)
{
gototLI_x;
Ei2EO:
JM9Gj:
gotopp27E;
tLI_x:
$this
->db
->select("mapel_id");
gotor5PhN;
TIrhG:
foreach ($mapel as $d)
{
$id_mapel[] = $d->mapel_id;
Z6fHJ:
}
gotozienz;
MXc2C:
$id_mapel = null;
gotoEi2EO;
gbpXV:
$this
->db
->where_not_in("mapel_id", [$id]);
gotoCN_Uu;
r5PhN:
$this
->db
->from("jurusan_mapel");
gotoG0Mbp;
yXfS3:
if (!($id_mapel === []))
{
gotoJM9Gj;
}
gotoMXc2C;
G0Mbp:
if (!($id !== null))
{
gotoAilWi;
}
gotogbpXV;
CKr1c:
$id_mapel = [];
gotoTIrhG;
zienz:
AyD2D:
gotoyXfS3;
CN_Uu:
AilWi:
gotoMa0pX;
DrTQF:
$this
->db
->from("master_mapel");
gotoGvCou;
Ma0pX:
$mapel = $this
->db
->get()
->result();
gotoCKr1c;
GvCou:
$this
->db
->where_not_in("id_mapel", $id_mapel);
gotoASsj1;
pp27E:
$this
->db
->select("id_mapel, nama_mapel");
gotoDrTQF;
ASsj1:
return $this
->db
->get()
->result();
gotosLsuB;
sLsuB:
}
public function getJurusanByIdMapel($id)
{
gotoFytXb;
g_etC:
return $this
->db
->get()
->result();
gototnpdQ;
atmPT:
$this
->db
->join("master_jurusan", "jurusan_mapel.jurusan_id=jurusan.id_jurusan");
gotokdL97;
LPTXl:
$this
->db
->from("jurusan_mapel");
gotoatmPT;
FytXb:
$this
->db
->select("jurusan.id_jurusan");
gotoLPTXl;
kdL97:
$this
->db
->where("mapel_id", $id);
gotog_etC;
tnpdQ:
}
public function getTahunActive()
{
gotoKQtV4;
KQtV4:
$this
->db
->select("id_tp, tahun");
gototof4P;
tof4P:
$this
->db
->from("master_tp");
gotoz4Sin;
ZamrK:
return $this
->db
->get()
->row();
gotovzBcU;
z4Sin:
$this
->db
->where("active", 1);
gotoZamrK;
vzBcU:
}
public function getSemesterActive()
{
gotomYeMd;
mtiBd:
$this
->db
->where("active", 1);
gotouu8tG;
uu8tG:
return $this
->db
->get()
->row();
gotolHstp;
mYeMd:
$this
->db
->select("id_smt, nama_smt, smt");
gotolYU0Z;
lYU0Z:
$this
->db
->from("master_smt");
gotomtiBd;
lHstp:
}
public function getJmlHariEfektif($id)
{
gototn4gz;
tn4gz:
$this
->db
->select("*");
gotoee1_R;
ee1_R:
$this
->db
->from("master_hari_efektif");
gotocQdzU;
cQdzU:
$this
->db
->where("id_hari_efektif", $id);
gotom7y6l;
m7y6l:
return $this
->db
->get()
->row();
gotoyHIjA;
yHIjA:
}
public function getDistinctTahunLulus()
{
gotozNZGs;
Hw_8Y:
$ret = [];
gotoTv22h;
jhbIq:
JnyZZ:
gotosf24b;
Tv22h:
foreach ($result as $row)
{
gotodMNC7;
O5A0x:
yBS2q:
gotoIHlx8;
Br8i3:
$ret[$row
->tahun_lulus] = $row->tahun_lulus;
gotoj4R7V;
dMNC7:
if (!($row->tahun_lulus != ''))
{
gotoeFSMO;
}
gotoBr8i3;
j4R7V:
eFSMO:
gotoO5A0x;
IHlx8:
}
gotojhbIq;
sf24b:
return $ret;
gotoOedtw;
DSAYu:
$this
->db
->distinct();
gotoKTha4;
zNZGs:
$this
->db
->select("tahun_lulus");
gotoDSAYu;
KTha4:
$result = $this
->db
->get("buku_induk")
->result();
gotoHw_8Y;
Oedtw:
}
public function getDistinctKelasAkhir()
{
gotovLD_I;
ciU24:
foreach ($result as $row)
{
gotozGrDl;
dBY3P:
zndPS:
gotoAt4Uj;
EvWB1:
kD5hw:
gotodBY3P;
fHppt:
$ret[$row
->kelas_akhir] = $row->kelas_akhir;
gotoEvWB1;
zGrDl:
if (!($row->kelas_akhir != ''))
{
gotokD5hw;
}
gotofHppt;
At4Uj:
}
gotoP41iT;
hMyEA:
$ret = [];
gotociU24;
b5YVR:
$result = $this
->db
->get("buku_induk")
->result();
gotohMyEA;
vLD_I:
$this
->db
->select("kelas_akhir");
gotoy1Akt;
P41iT:
cPWJO:
gotoR2U4D;
R2U4D:
return $ret;
gotoLnQ0t;
y1Akt:
$this
->db
->distinct();
gotob5YVR;
LnQ0t:
}
public function getAlumniByTahun($tahun, $kelas = null)
{
gotoOTL5W;
O7Wqw:
return $this
->db
->get()
->result();
gototgFQg;
hByem:
if (!($kelas != null))
{
gotodF_QY;
}
gotoxSu8v;
xSu8v:
$this
->db
->where("a.kelas_akhir", $kelas);
gotopYRRG;
eF6T4:
$this
->db
->join("master_siswa b", "a.id_siswa=b.id_siswa");
gotoMTacN;
MTacN:
$this
->db
->where("a.tahun_lulus", $tahun);
gotohByem;
fMl3h:
$this
->db
->from("buku_induk a");
gotoeF6T4;
OTL5W:
$this
->db
->select("*");
gotofMl3h;
pYRRG:
dF_QY:
gotoO7Wqw;
tgFQg:
}
public function getAlumniById($id)
{
gotomOcs0;
z4oDc:
$this
->db
->where("a.id_siswa", $id);
gotoqkl_h;
pRupb:
$this
->db
->join("buku_induk b", "a.id_siswa=b.id_siswa");
gotoz4oDc;
mOcs0:
$this
->db
->select("*");
gotoRRifm;
qkl_h:
return $this
->db
->get()
->row();
gotocCKwu;
RRifm:
$this
->db
->from("master_siswa a");
gotopRupb;
cCKwu:
}
public function getAllWaliKelas()
{
gotopnh4h;
gyf7F:
$this
->db
->from("jabatan_guru a");
gotoj2DWr;
gSN3N:
$this
->db
->join("master_kelas d", "a.id_kelas=d.id_kelas", "left");
gotoK0VOR;
j2DWr:
$this
->db
->join("master_guru b", "a.id_guru=b.id_guru", "left");
gotouN2Ba;
kWinZ:
if (!$result)
{
gotohHHP8;
}
gotouc3yV;
uc3yV:
foreach ($result as $key => $row)
{
gotohbsly;
J91w5:
mJpKM:
gotoyJUoj;
FxBer:
fJJWg:
gotoJ91w5;
hbsly:
if (!($row->id_level == "4"))
{
gotofJJWg;
}
gotoIsnyN;
IsnyN:
$ret[$row->id_tp][$row->id_smt][$row->id_kelas] = $row;
gotoFxBer;
yJUoj:
}
gotoZF_ow;
xj27b:
$ret = [];
gotokWinZ;
ZF_ow:
Q9s3J:
gotosmyRH;
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");
gotogyf7F;
DIVnD:
return $ret;
gotoZzoI_;
pnh4h:
$this
->db
->query("SET SQL_BIG_SELECTS=1");
gotocyMPg;
smyRH:
hHHP8:
gotoDIVnD;
uN2Ba:
$this
->db
->join("level_guru c", "a.id_jabatan=c.id_level", "left");
gotogSN3N;
K0VOR:
$result = $this
->db
->get()
->result();
gotoxj27b;
ZzoI_:
}
public function getAllGuru()
{
gotoQY7zN;
lBS0G:
return $this
->db
->get()
->result();
gotok86ut;
zQXCG:
$guru = $this
->db
->get()
->result();
gotoOE_Jt;
QY7zN:
$this
->db
->select("id_guru");
gotoqTcJW;
qTcJW:
$this
->db
->from("jabatan_guru");
gotozQXCG;
JLuev:
$this
->db
->from("master_guru");
gotoxAG6p;
OE_Jt:
$id_guru = [];
gotoiejva;
zxdzi:
Z9RvR:
gotoZq84v;
Zq84v:
$this
->db
->select("id_guru, nip, nama_guru");
gotoJLuev;
xAG6p:
$this
->db
->where_in("id_guru", $id_guru);
gotolBS0G;
iejva:
foreach ($guru as $d)
{
$id_guru[] = $d->id_guru;
Xpzxl:
}
gotozxdzi;
k86ut:
}
public function getAllKelas($tp = null, $smt = null)
{
gotoRoSt6;
xGd4L:
return $ret;
gotozf8ff;
xnQcH:
NOaFO:
gotoxlRKN;
GDIV0:
foreach ($result as $key => $row)
{
$ret[$row->id_kelas] = $row;
HXDo_:
}
gotofQX5z;
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");
gotoSV4b5;
uuGiV:
gotoaIAIG;
gotogU7cb;
zsKJ3:
if ($tp != null && $smt != null)
{
gotolZgZi;
}
gotoS29tH;
SV4b5:
$this
->db
->from("master_kelas a");
gotoVpwSu;
S29tH:
if (!$result)
{
gotoOO9Lw;
}
gotoBy32H;
fQX5z:
lhUty:
gotoxnQcH;
yPCzY:
$this
->db
->order_by("a.nama_kelas");
gotoLUPZt;
RMHT_:
lCaNz:
gotoKAcCG;
vFuEb:
if (!$result)
{
gotoNOaFO;
}
gotoGDIV0;
RoSt6:
$this
->db
->query("SET SQL_BIG_SELECTS=1");
gotoAVf71;
VpwSu:
if (!($tp != null && $smt != null))
{
gotolCaNz;
}
gotoX8fsD;
X8fsD:
$this
->db
->where("a.id_tp", $tp)->where("a.id_smt", $smt);
gotoRMHT_;
wQUVf:
$ret = [];
gotozsKJ3;
gU7cb:
lZgZi:
gotovFuEb;
pEf3n:
vw382:
gotoPV0xY;
CWX5D:
$this
->db
->join("master_guru c", "f.id_guru=c.id_guru", "left");
gotoyPCzY;
K1j8E:
$this
->db
->join("master_jurusan b", "a.jurusan_id=b.id_jurusan", "left");
gotoCWX5D;
PV0xY:
OO9Lw:
gotouuGiV;
xlRKN:
aIAIG:
gotoxGd4L;
By32H:
foreach ($result as $key => $row)
{
$ret[$row->id_tp][$row->id_smt][$row->id_kelas] = $row;
brjak:
}
gotopEf3n;
KAcCG:
$this
->db
->join("jabatan_guru f", "f.id_kelas=a.id_kelas", "left");
gotoK1j8E;
LUPZt:
$result = $this
->db
->get()
->result();
gotowQUVf;
zf8ff:
}
public function getAllKelasSiswa()
{
gotoD3L17;
yunXP:
f0tuG:
gotobRxvZ;
D3L17:
$this
->db
->select("*");
gotooz2qe;
uTpLU:
$ret = [];
gotoawgBq;
KlVwB:
U3Hi1:
gotoyunXP;
bRxvZ:
return $ret;
gotoguHVv;
oz2qe:
$this
->db
->from("kelas_siswa");
gotooHuV8;
awgBq:
if (!$result)
{
gotof0tuG;
}
gotoq3Gag;
q3Gag:
foreach ($result as $key => $row)
{
$ret[$row->id_kelas][$row->id_siswa] = $row;
UXlfX:
}
gotoKlVwB;
oHuV8:
$result = $this
->db
->get()
->result();
gotouTpLU;
guHVv:
}
public function getDataInduk()
{
gotohdoE3;
pw1jT:
$result = $this
->db
->get()
->result();
gotoVsPTb;
d2k7B:
return $ret;
gotoBOBmw;
VsPTb:
$ret = [];
gotoawQLR;
OV_CA:
$this
->db
->join("buku_induk b", "a.id_siswa=b.id_siswa", "left");
gotodh83w;
hdoE3:
$this
->db
->select("a.*, b.*,");
gotoGkmDX;
awQLR:
if (!$result)
{
gotoiiWCt;
}
gotorQb0n;
dh83w:
$this
->db
->order_by("a.nama", "ASC");
gotopw1jT;
QxDNP:
zkM85:
gotodz_s3;
GkmDX:
$this
->db
->from("master_siswa a");
gotoOV_CA;
dz_s3:
iiWCt:
gotod2k7B;
rQb0n:
foreach ($result as $key => $row)
{
$ret[$row->id_siswa] = $row;
MBANm:
}
gotoQxDNP;
BOBmw:
}
}
?>Did this file decode correctly?
Original Code
<?php
/**
* Class and Function List:
* Function list:
* - create()
* - update()
* - delete()
* - delete_not()
* - getDataKelas()
* - getKelasById()
* - getDataJurusan()
* - getDataJurusanMapel()
* - getDataTableJurusan()
* - getJurusanById()
* - updateJurusan()
* - inputJurusan()
* - getAllDataSiswa()
* - getSiswaByKelas()
* - getDataSiswa()
* - getAllSiswa()
* - getSiswaPage()
* - getSiswaTotalPage()
* - getDataSiswaByKelas()
* - getDataSiswaByKelasPage()
* - getSiswaById()
* - getSiswaByArrNisn()
* - getSiswaKelasBaru()
* - getDataSiswaById()
* - getAgamaSiswa()
* - getJurusan()
* - getAllJurusan()
* - getKelasByJurusan()
* - getDataGuru()
* - getAllDataGuru()
* - getGuruById()
* - getGuruByArrId()
* - getUserIdGuruByUsername()
* - getDetailJabatanGuru()
* - getJabatanGuru()
* - getGuruMapel()
* - getKodeKelompokMapel()
* - getDataKelompokMapel()
* - getKategoriKelompokMapel()
* - getDataSubKelompokMapel()
* - getDataMapel()
* - getAllMapel()
* - getAllStatusMapel()
* - getAllMapelByKelompok()
* - getAllMapelNonAktif()
* - getMapelById()
* - updateMapel()
* - getAllEkstra()
* - getEkstraById()
* - updateEkstra()
* - getKelasGuru()
* - getKelasByGuru()
* - getAllJabatanGuru()
* - getJurusanMapel()
* - getMapel()
* - getJurusanByIdMapel()
* - getTahunActive()
* - getSemesterActive()
* - getJmlHariEfektif()
* - getDistinctTahunLulus()
* - getDistinctKelasAkhir()
* - getAlumniByTahun()
* - getAlumniById()
* - getAllWaliKelas()
* - getAllGuru()
* - getAllKelas()
* - getAllKelasSiswa()
* - getDataInduk()
* Classes list:
* - Master_model extends CI_Model
*/
/* ________________________________________
| 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)
{
gotoUcvEh;
k9x_s:
hDau3:
gotoAPNiW;
H4i8F:
yG27h:
gotoKh4mZ;
UcvEh:
if ($batch === false)
{
gotohDau3;
}
gotoFsqcH;
Kh4mZ:
return $insert;
gotoOTYcf;
FsqcH:
$insert = $this
->db
->insert_batch($table, $data);
gotoKjVwm;
APNiW:
$insert = $this
->db
->insert($table, $data);
gotoH4i8F;
KjVwm:
gotoyG27h;
gotok9x_s;
OTYcf:
}
public function update($table, $data, $pk, $id = null, $batch = false)
{
gotoSBGj0;
HiHC4:
$insert = $this
->db
->update($table, $data, array(
$pk => $id
));
gotoa8sEv;
n13_8:
$insert = $this
->db
->update_batch($table, $data, $pk);
gotoul1ll;
ul1ll:
gotoXdoGJ;
gotofd8JM;
pTk3d:
return $insert;
gotodVayL;
a8sEv:
XdoGJ:
gotopTk3d;
SBGj0:
if ($batch === false)
{
gotoGR8Dx;
}
goton13_8;
fd8JM:
GR8Dx:
gotoHiHC4;
dVayL:
}
public function delete($table, $data, $pk)
{
gotoK2Gpl;
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");
gotoTXAWE;
c36FV:
$deleted = $this
->db
->delete($table);
gotomIAgx;
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");
gotoA8Wui;
A8Wui:
return $deleted;
gotox69Zd;
TXAWE:
$this
->db
->where_in($pk, $data);
gotoc36FV;
x69Zd:
}
public function delete_not($table, $data, $pk, $col, $not)
{
gotoKHelY;
c57cV:
$this
->db
->where($col . "\41\x3d" . $not);
gotombfDo;
KHelY:
$this
->db
->where_in($pk, $data);
gotoc57cV;
mbfDo:
return $this
->db
->delete($table);
gotoaD_g8;
aD_g8:
}
public function getDataKelas()
{
gotoSXkBj;
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");
gotowWfGL;
wWfGL:
$this
->datatables
->from("\155\141\163\164\x65\x72\137\x6b\x65\x6c\141\x73");
gotoOZGyX;
kITqC:
return $this
->datatables
->generate();
gotohught;
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");
gotokITqC;
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");
gotozMYTU;
hught:
}
public function getKelasById($id)
{
gotoI0EJP;
sq3yk:
$this
->db
->where("\x69\144\137\x6b\145\x6c\141\163", $id);
gotocYOCQ;
Wgyfx:
$this
->db
->from("\x6d\141\163\x74\x65\x72\x5f\x6b\145\x6c\x61\x73");
gotosq3yk;
cYOCQ:
$this
->db
->order_by("\156\141\155\x61\137\x6b\145\154\x61\x73");
gotoQV4VL;
QV4VL:
return $this
->db
->get()
->row();
gotol0MIM;
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");
gotoWgyfx;
l0MIM:
}
public function getDataJurusan()
{
gotoU93gS;
BU0Ly:
return $this
->db
->get()
->result();
gototC3E_;
B1q15:
$this
->db
->from("\155\x61\x73\164\145\162\x5f\x6a\165\162\165\x73\141\x6e");
gotoBU0Ly;
U93gS:
$this
->db
->select("\52");
gotoB1q15;
tC3E_:
}
public function getDataJurusanMapel($arrIds)
{
gotorI_Ad;
q4mfp:
if (!$result)
{
gotowpOHj;
}
gotoMKlwH;
dX4ZV:
$this
->db
->from("\x6d\141\x73\164\145\162\137\x6d\141\x70\x65\x6c");
gotoyR5AB;
UVg1M:
$result = $this
->db
->get()
->result();
gotomKAg7;
bMk6d:
wpOHj:
gotoQeILI;
QeILI:
return $ret;
gotoPx5_7;
mKAg7:
$ret = [];
gotoq4mfp;
xDCxg:
Njxce:
gotobMk6d;
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");
gotodX4ZV;
yR5AB:
$this
->db
->where_in("\x69\144\x5f\155\141\x70\145\x6c", $arrIds);
gotoUVg1M;
MKlwH:
foreach ($result as $key => $row)
{
$ret[$row
->id_mapel] = $row->nama_mapel;
gzZJc:
}
gotoxDCxg;
Px5_7:
}
public function getDataTableJurusan()
{
gotobOug9;
JHHNg:
$this
->datatables
->from("\155\x61\x73\164\145\162\137\152\165\162\x75\163\141\156");
gotooEAd5;
Odsqk:
return $this
->datatables
->generate();
gotox0xEI;
bOug9:
$this
->datatables
->select("\x2a");
gotoJHHNg;
oEAd5:
$this
->db
->order_by("\151\144\x5f\x6a\165\x72\165\x73\x61\156");
gotoOdsqk;
x0xEI:
}
public function getJurusanById($id)
{
gotorNRka;
IX1R6:
return $this
->db
->get("\155\x61\163\164\x65\162\x5f\x6a\x75\x72\165\x73\141\156")
->result();
gotoGvSo8;
dsqHn:
$this
->db
->order_by("\156\141\155\141\137\152\165\162\x75\x73\141\x6e");
gotoIX1R6;
rNRka:
$this
->db
->where_in("\x69\x64\137\152\x75\x72\x75\x73\x61\156", $id);
gotodsqHn;
GvSo8:
}
function updateJurusan()
{
gotogKsWq;
YDHD6:
EKWCr:
gotozRXrb;
h_5qy:
$this
->db
->set("\156\x61\155\141\x5f\x6a\165\x72\x75\163\x61\156", $name);
gotokJNjk;
IR9Ge:
$this
->db
->set("\163\x74\141\x74\x75\x73", "\61");
gotohIM7J;
iz2kA:
if (!($i <= $row_mapels))
{
gotoUXHRd;
}
gotoXaIOf;
kJNjk:
$this
->db
->set("\x6b\x6f\x64\x65\137\x6a\165\162\x75\163\x61\156", $kode);
gotogZX0A;
age7C:
UXHRd:
gotoXdafv;
hIM7J:
$this
->db
->where("\x69\x64\x5f\x6a\x75\162\165\x73\141\156", $id);
gotoDIoXZ;
DIoXZ:
return $this
->db
->update("\155\141\163\x74\x65\162\137\152\165\162\165\x73\141\156");
gotobOZRF;
D2_eo:
$row_mapels = count($this
->input
->post("\x6d\x61\x70\x65\x6c", true));
gotos1Yr1;
Xdafv:
EtAsG:
gotoh_5qy;
FjwSX:
$kode = $this
->input
->post("\153\x6f\x64\145\137\x6a\x75\x72\x75\163\141\x6e", true);
gotoj4z9Y;
s1Yr1:
$i = 0;
gotoqIQP0;
j4z9Y:
$mapels = [];
gotoFdXaj;
GKU2H:
gotoEphIn;
gotoage7C;
qIQP0:
EphIn:
gotoiz2kA;
zRXrb:
$i++;
gotoGKU2H;
VZqQa:
if (!$check_mapel)
{
gotoEtAsG;
}
gotoD2_eo;
FdXaj:
$check_mapel = $this
->input
->post("\x6d\x61\160\145\154", true);
gotoVZqQa;
gKsWq:
$id = $this
->input
->post("\x69\x64\x5f\152\x75\x72\x75\x73\x61\156");
gotoBN0NQ;
XaIOf:
array_push($mapels, $this
->input
->post("\x6d\141\160\145\x6c\x5b" . $i . "\x5d", true));
gotoYDHD6;
gZX0A:
$this
->db
->set("\x6d\x61\160\145\x6c\x5f\160\x65\155\151\x6e\x61\164\141\x6e", implode("\x2c", $mapels));
gotoIR9Ge;
BN0NQ:
$name = $this
->input
->post("\x6e\x61\x6d\x61\137\152\165\x72\x75\163\x61\x6e", true);
gotoFjwSX;
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)
{
gotoU53G1;
P7rC7:
return $query->result();
gotoieBVl;
ynRaO:
$this
->db
->from("\155\x61\x73\164\x65\x72\x5f\x73\151\x73\167\x61\x20\141");
gotot7LXn;
fLqSy:
$query = $this
->db
->get();
gotoP7rC7;
dJXTd:
$this
->db
->order_by("\x61\56\156\x61\155\141");
gotofLqSy;
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");
gotojQmaD;
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");
gotowr7rj;
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");
gotoN_jof;
jQmaD:
$this
->db
->select("\141\x2e\x2a\x2c\40\143\56\x6e\x61\155\x61\x5f\x6b\x65\154\141\163");
gotoynRaO;
wr7rj:
$this
->db
->order_by("\142\x2e\x69\144\x5f\153\x65\154\141\x73");
gotodJXTd;
ieBVl:
}
public function getSiswaByKelas($id_tp, $id_smt, $id_kelas)
{
gotoGCb1a;
hndCi:
$this
->db
->where("\141\x2e\151\x64\x5f\x74\x70", $id_tp);
gotoLfY1R;
xFHZJ:
$this
->db
->from("\x6b\145\154\x61\163\x5f\x73\151\x73\167\141\x20\141");
gotoZkyYU;
LfY1R:
$this
->db
->where("\141\x2e\151\x64\137\x73\x6d\x74", $id_smt);
gotoNHZel;
GCb1a:
$this
->db
->select("\x62\56\52");
gotoxFHZJ;
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);
gotobeJCG;
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");
gotohndCi;
K_FU2:
return $this
->db
->get()
->result();
gotoeFYTI;
UM_Ab:
$this
->db
->where("\141\56\151\x64\137\153\x65\154\x61\163", $id_kelas);
gotoTPzne;
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);
gotoUM_Ab;
TPzne:
$this
->db
->order_by("\x62\56\156\x61\155\x61", "\x41\123\x43");
gotoK_FU2;
eFYTI:
}
public function getDataSiswa($id_tp, $id_smt)
{
goton8WBm;
HQR67:
return $this
->datatables
->generate();
gotoCObiX;
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");
gotoptAqt;
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");
gotoPsdsR;
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");
gotocmzZK;
nefdv:
$this
->db
->order_by("\146\x2e\x6e\141\155\141\x5f\153\145\x6c\x61\163", "\x41\x53\103");
gotoWVLjs;
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");
gototWX5W;
WVLjs:
$this
->db
->order_by("\142\x2e\163\x74\x61\164\165\163", "\x41\x53\x43");
gotoHQR67;
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");
gotowebcY;
cmzZK:
$this
->datatables
->from("\155\141\163\x74\x65\x72\137\163\151\x73\167\141\40\x61");
gotocCkB6;
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");
gotonefdv;
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");
gotoOsDZw;
CObiX:
}
public function getAllSiswa($id_tp, $id_smt, $offset, $limit, $search = null, $sort = null, $order = null)
{
gotoDITkC;
J4GSX:
HGoxL:
gotoTHiAj;
QTmDg:
$this
->db
->or_like("\141\x2e\156\x69\163\156", $search);
gotoJ4GSX;
Una0k:
$this
->db
->from("\155\141\x73\164\x65\162\x5f\x73\x69\x73\167\x61\40\x61");
gotoh2d2d;
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");
gotohxSyW;
THiAj:
return $this
->db
->get()
->result();
gotot2zdg;
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");
gotoUna0k;
hVDhg:
$this
->db
->or_like("\141\x2e\x6e\151\163", $search);
gotoQTmDg;
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");
gotoeyytq;
hxSyW:
if (!($search != null))
{
gotoHGoxL;
}
gotowxGyF;
zQZVx:
$this
->db
->order_by("\x61\x2e\x6e\141\x6d\x61", "\x41\x53\x43");
gotoXU3Z0;
wxGyF:
$this
->db
->like("\x61\56\x6e\x61\155\x61", $search);
gotohVDhg;
h2d2d:
$this
->db
->limit($limit, $offset);
gotozQZVx;
t2zdg:
}
public function getSiswaPage($id_tp, $id_smt, $offset, $limit, $filter, $search = null, $sort = null, $order = null)
{
gotonHyif;
Prchh:
$this
->db
->from("\155\x61\x73\x74\x65\162\137\163\151\x73\x77\x61\40\x61");
gotomP2Kl;
Lz8hy:
if (!($filter == "\61"))
{
gotoSXr9w;
}
gotoATkPo;
yQdp7:
BSfrp:
gotoOq2Z6;
ptwUC:
SXr9w:
gotoxO855;
mP2Kl:
$this
->db
->limit($limit, $offset);
gotoq0Fdj;
fGMju:
iW82O:
gotoAQ4QZ;
Oq2Z6:
return $this
->db
->get()
->result();
gotoSZ44m;
j4Kyq:
$this
->db
->where("\x66\56\x69\x64\137\x6b\145\x6c\141\x73\x20\111\x53\x20\116\125\114\114");
gotoZNPoi;
sAfio:
$this
->db
->or_like("\141\56\156\x69\x73\156", $search);
gotoyQdp7;
gvR5D:
$this
->db
->order_by("\141\x2e\x6e\141\x6d\141", "\x41\x53\103");
gotoJ3Oz_;
J3Oz_:
if (!($search != null))
{
gotoBSfrp;
}
gotoqGSxc;
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");
gotoj4Kyq;
hNIrr:
$this
->db
->or_like("\141\x2e\x6e\151\163", $search);
gotosAfio;
xO855:
gotoSGJFF;
gotofGMju;
qGSxc:
$this
->db
->like("\141\x2e\x6e\x61\x6d\x61", $search);
gotohNIrr;
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");
gotoPrchh;
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");
gotoLz8hy;
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");
gotoptwUC;
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);
gotobMB5N;
ZNPoi:
SGJFF:
gotoLwqiF;
LwqiF:
$this
->db
->order_by("\146\x2e\x6e\141\155\141\137\153\145\x6c\141\163", "\x41\123\x43");
gotoIDwEZ;
bwZ6C:
if ($filter == "\x35")
{
gotoiW82O;
}
gotozlHfo;
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");
gotogvR5D;
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");
gotoGGuXT;
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");
gotobwZ6C;
SZ44m:
}
public function getSiswaTotalPage($id_tp, $id_smt, $filter, $search = null)
{
gotoIfsEB;
IfsEB:
$this
->db
->select("\x61\x2e\x69\144\x5f\x73\x69\163\x77\x61");
gotojC1NZ;
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");
gotoQLMRM;
GmDsn:
PPAML:
gotohb1mw;
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");
gotoGmDsn;
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);
gotoXwejJ;
ZXdkd:
if ($filter == "\65")
{
gotofv0rc;
}
gotoCRJbr;
F9H1Y:
$this
->db
->or_like("\x61\56\x6e\x69\x73", $search);
gotoOIlr2;
jp1tb:
MVf8Z:
gotog5EY6;
O757c:
fv0rc:
gotokXewR;
mIWR2:
N0pBC:
gotooBJRb;
ITCQ0:
$this
->db
->like("\141\56\x6e\141\x6d\141", $search);
gotoF9H1Y;
X9oF3:
$this
->db
->where("\x66\x2e\151\144\137\153\x65\x6c\x61\x73\x20\111\123\x20\116\125\114\114");
gotojp1tb;
hb1mw:
gotoMVf8Z;
gotoO757c;
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");
gotonA5ei;
OIlr2:
$this
->db
->or_like("\x61\x2e\x6e\151\163\156", $search);
gotomIWR2;
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");
gotoX9oF3;
QLMRM:
if (!($filter == "\61"))
{
gotoPPAML;
}
gotomXzTm;
jC1NZ:
$this
->db
->from("\x6d\x61\x73\x74\145\x72\137\x73\151\x73\167\141\40\141");
gotoyHOVu;
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");
gotoZXdkd;
oBJRb:
return $this
->db
->get()
->num_rows();
gotouze3l;
g5EY6:
if (!($search != null))
{
gotoN0pBC;
}
gotoITCQ0;
uze3l:
}
public function getDataSiswaByKelas($id_tp, $id_smt, $id_kelas, $offset, $limit, $search = null, $sort = null, $order = null)
{
gotop3N4X;
Zvs17:
return $this
->db
->get()
->result();
gotolfR1n;
z85FI:
$this
->db
->like("\142\x2e\x6e\141\155\141", $search);
gotoTs8Op;
FiWu6:
WSVeE:
gotoE2Hm0;
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");
gotos_Dsr;
I03G4:
if (!($search != null))
{
gotoa2X1v;
}
gotoz85FI;
jaSOi:
$this
->db
->where("\x61\56\x69\x64\137\x6b\145\x6c\141\x73", $id_kelas);
gotoZvs17;
Ts8Op:
$this
->db
->or_like("\x62\56\x6e\151\163", $search);
gotoixBkW;
Bi1Sv:
a2X1v:
gotoPDWGm;
scWTP:
$this
->db
->limit($limit, $offset);
gotoFiWu6;
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");
gotoSfJO9;
o3o6p:
$this
->db
->where("\141\56\x69\144\x5f\163\155\164", $id_smt);
gotojaSOi;
SfJO9:
$this
->db
->from("\153\145\154\141\163\137\x73\x69\163\167\141\40\141");
gotoFsVhB;
ixBkW:
$this
->db
->or_like("\142\x2e\156\151\x73\x6e", $search);
gotoBi1Sv;
s_Dsr:
$this
->db
->where("\x61\56\151\x64\x5f\164\160", $id_tp);
gotoo3o6p;
FsVhB:
if (!($limit > 0))
{
gotoWSVeE;
}
gotoscWTP;
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");
gotoI03G4;
lfR1n:
}
public function getDataSiswaByKelasPage($id_tp, $id_smt, $id_kelas, $search = null)
{
gotoYEMQA;
sMNTn:
$this
->db
->where("\x61\56\151\144\x5f\164\x70", $id_tp);
gotoISX8d;
o1myt:
$this
->db
->from("\x6b\x65\154\x61\x73\x5f\163\151\x73\167\x61\x20\141");
gotosMNTn;
Mx3_u:
$this
->db
->where("\x61\56\x69\x64\x5f\153\145\154\x61\x73", $id_kelas);
gotojI8O5;
HnqKK:
return $this
->db
->get()
->num_rows();
gotoQ4ndz;
tpnNz:
$this
->db
->or_like("\x62\56\x6e\151\x73", $search);
gototFBCG;
jSnDS:
J5ZEb:
gotoHnqKK;
ISX8d:
$this
->db
->where("\x61\56\x69\x64\137\x73\155\164", $id_smt);
gotoMx3_u;
Jn4Pu:
$this
->db
->like("\142\56\x6e\141\x6d\141", $search);
gototpnNz;
yMFu0:
if (!($search != null))
{
gotoJ5ZEb;
}
gotoJn4Pu;
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");
gotoyMFu0;
YEMQA:
$this
->db
->select("\x61\x2e\x69\x64\137\163\151\163\x77\141");
gotoo1myt;
tFBCG:
$this
->db
->or_like("\x62\x2e\156\x69\x73\156", $search);
gotojSnDS;
Q4ndz:
}
public function getSiswaById($id)
{
gotoqP1sK;
j0A_k:
return $this
->db
->get()
->row();
gotoWRJyO;
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");
gotogfFNw;
gfFNw:
$this
->db
->where("\x61\56\x69\x64\x5f\x73\151\163\167\x61", $id);
gotoj0A_k;
z8Usg:
$this
->db
->from("\155\141\x73\164\145\x72\137\x73\x69\163\167\141\40\141");
gotoLsI7e;
qP1sK:
$this
->db
->select("\141\x2e\x2a\54\40\x62\x2e\x73\164\141\x74\165\163");
gotoz8Usg;
WRJyO:
}
public function getSiswaByArrNisn($arr_nisn, $arr_nis, $arr_username)
{
gotocIWsv;
FX745:
$this
->db
->or_where_in("\x75\163\x65\162\x6e\141\x6d\x65", $arr_username);
gotoj6OwK;
fq1wG:
$this
->db
->from("\155\x61\163\x74\x65\162\137\x73\x69\x73\167\141");
gotoKoyjS;
KoyjS:
$this
->db
->where_in("\156\151\163\156", $arr_nisn);
gotoBbby8;
Bbby8:
$this
->db
->or_where_in("\156\x69\163", $arr_nis);
gotoFX745;
j6OwK:
return $this
->db
->get()
->result();
gotoWsXqK;
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");
gotofq1wG;
WsXqK:
}
public function getSiswaKelasBaru($id_tp, $id_smt)
{
gotonKFBO;
h9sUv:
u71xz:
gotoAyGKi;
n_9Wu:
if (!$result)
{
gotou7iDF;
}
gotowVTSo;
gKRJK:
$ret = [];
goton_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");
gotoAIycu;
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");
gotoe9X5B;
AyGKi:
u7iDF:
gotoyOgAa;
Q1HV_:
$this
->db
->where("\141\x2e\x69\144\137\163\155\x74", $id_smt);
gotoKPseG;
wVTSo:
foreach ($result as $key => $row)
{
$ret[$row->id_siswa] = $row;
k5T0o:
}
gotoh9sUv;
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");
gotozx_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");
gotogJv1s;
zx_tZ:
$this
->db
->from("\153\145\x6c\x61\163\x5f\x73\151\x73\167\x61\40\x61");
gotoLEqhL;
yOgAa:
return $ret;
gotoKMGPU;
KPseG:
$result = $this
->db
->get()
->result();
gotogKRJK;
e9X5B:
$this
->db
->where("\141\x2e\x69\144\137\x74\160", $id_tp);
gotoQ1HV_;
KMGPU:
}
public function getDataSiswaById($id_tp, $id_smt, $idSiswa)
{
gotovhNNi;
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");
gotoCdW3t;
lpRjA:
$this
->db
->where("\141\56\x69\144\137\163\151\163\167\x61", $idSiswa);
gotoCw0x1;
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");
gotodLdDi;
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");
gotoU3j81;
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");
gotocRe37;
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");
gotoEDDhc;
dLdDi:
$this
->db
->from("\153\x65\154\x61\163\x5f\163\151\x73\167\x61\40\141");
gotosj1yt;
uEft2:
$this
->db
->where("\x61\x2e\151\x64\137\x74\x70", $id_tp);
gotoPYKtn;
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");
gotouEft2;
PYKtn:
$this
->db
->where("\141\56\151\144\x5f\163\155\x74", $id_smt);
gotolpRjA;
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");
gotor1JKl;
Cw0x1:
return $this
->db
->get()
->row();
gotolBzl0;
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");
gotoD3YAv;
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");
gotoZHfEP;
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");
gotogS9KF;
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");
gotoAbG1x;
lBzl0:
}
public function getAgamaSiswa()
{
gotoByABJ;
tzzKz:
foreach ($result as $row)
{
$ret[$row
->agama] = $row->agama;
llxr1:
}
gotoC8qUp;
G8md6:
$this
->db
->not_like("\141\x2e\141\x67\x61\155\141", "\x50\151\154\151\150");
gotowhTOF;
whTOF:
$result = $this
->db
->get()
->result();
gotoR7xf7;
nCi0f:
$this
->db
->where("\141\x2e\x61\x67\141\x6d\x61\x20\41\75\40\x22\60\42", NULL, false);
gotoG8md6;
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);
gotonCi0f;
kuCVg:
$this
->db
->distinct();
gotoL5HfU;
C8qUp:
dSO1i:
gotoT2qZy;
ByABJ:
$this
->db
->select("\x61\147\x61\155\x61");
gotokuCVg;
R7xf7:
$ret["\x2d"] = "\102\x75\x6b\x61\156\40\x4d\x61\x70\145\x6c\x20\x41\147\141\x6d\141";
gototzzKz;
T2qZy:
return $ret;
gotoeVw7W;
L5HfU:
$this
->db
->from("\155\141\x73\x74\145\162\x5f\163\151\x73\167\141\x20\x61");
gotojaVCA;
eVw7W:
}
public function getJurusan()
{
gotozX75G;
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");
gotoblhEk;
cKPOs:
$this
->db
->group_by("\151\x64\x5f\152\x75\162\165\163\141\x6e");
gotohpJKn;
GC8Ls:
return $query->result();
gotobc3kW;
blhEk:
$this
->db
->order_by("\x6e\141\155\x61\x5f\152\x75\162\x75\163\x61\156", "\101\x53\103");
gotocKPOs;
kABjL:
$this
->db
->from("\155\141\163\x74\145\162\137\x6b\145\154\141\x73");
gotovk2iH;
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");
gotokABjL;
hpJKn:
$query = $this
->db
->get();
gotoGC8Ls;
bc3kW:
}
public function getAllJurusan($id = null)
{
gotofz0vQ;
kWylP:
eKqJB:
gotorgw8j;
Av4dg:
$this
->db
->from("\152\165\162\165\x73\x61\x6e\137\x6d\141\160\x65\154");
gotojdf4Y;
bZn_2:
kBp3u:
gotoh5vqV;
Mr6On:
$this
->db
->from("\155\x61\x73\x74\145\162\x5f\152\165\x72\x75\163\x61\156");
gotoEzo4a;
RRtoF:
$this
->db
->order_by("\x6e\141\x6d\x61\x5f\152\x75\162\165\x73\x61\156", "\x41\x53\103");
gotoHlVoD;
mjBWK:
es3LY:
gotoRRtoF;
RA1NB:
$jurusan = $this
->db
->get()
->result();
gotoc809O;
fz0vQ:
if ($id === null)
{
gotoes3LY;
}
gotolXQLp;
VEuk3:
return $this
->db
->get()
->result();
gotomWx2q;
c809O:
$id_jurusan = [];
gotouH2qi;
Ezo4a:
$this
->db
->where_not_in("\151\x64\137\152\165\x72\165\163\141\156", $id_jurusan);
gotoVEuk3;
uH2qi:
foreach ($jurusan as $j)
{
$id_jurusan[] = $j->jurusan_id;
Sl6Vt:
}
gotoDfO4f;
DfO4f:
dl01N:
gotoJINQV;
P3KfC:
$id_jurusan = null;
gotobZn_2;
mWx2q:
gotoeKqJB;
gotomjBWK;
jdf4Y:
$this
->db
->where("\x6d\x61\160\x65\x6c\137\151\x64", $id);
gotoRA1NB;
lXQLp:
$this
->db
->select("\152\x75\162\x75\x73\141\156\137\151\x64");
gotoAv4dg;
HlVoD:
return $this
->db
->get("\x6a\x75\162\165\x73\x61\x6e")
->result();
gotokWylP;
JINQV:
if (!($id_jurusan === []))
{
gotokBp3u;
}
gotoP3KfC;
h5vqV:
$this
->db
->select("\52");
gotoMr6On;
rgw8j:
}
public function getKelasByJurusan($id)
{
$query = $this
->db
->get_where("\x6d\141\163\164\x65\x72\137\153\x65\154\x61\x73", array(
"\x6a\165\162\165\163\141\156\x5f\151\x64" => $id
));
return $query->result();
}
public function getDataGuru($tp, $smt)
{
gotoNapVU;
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");
gotoQKw0O;
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");
gotoG0w6s;
QKw0O:
return $this
->datatables
->generate();
gotontqau;
Vilm7:
$this
->datatables
->from("\155\x61\x73\164\x65\x72\x5f\147\165\162\165\x20\x61");
gotoz50f3;
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");
goton3Udd;
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");
gotofP0J_;
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");
gotoBO1X7;
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");
gotoVilm7;
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");
gotowwF3H;
ntqau:
}
public function getAllDataGuru($tp, $smt)
{
gotofs3gD;
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");
gotoRSwGi;
rFG9n:
$this
->db
->from("\155\141\163\164\x65\x72\137\x67\165\162\x75\40\x61");
gotou4k5E;
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");
gotoo0aEF;
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");
gotowhMUr;
kbB1E:
$this
->db
->order_by("\x63\56\151\x64\x5f\x6c\x65\x76\145\x6c", "\x64\x65\x73\x63");
gotop25H5;
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");
gotoWT30m;
Cyncj:
return $this
->db
->get()
->result();
gotoBMhFw;
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");
gotorFG9n;
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");
gotokbB1E;
p25H5:
$this
->db
->order_by("\x61\x2e\x69\x64\137\147\165\162\165", "\x61\163\x63");
gotoCyncj;
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");
gotonrtH9;
BMhFw:
}
public function getGuruById($id, $id_tp = null, $id_smt = null)
{
gotofwK1U;
G8uDN:
D8Y_P:
gotovwaGA;
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");
gotoBH2xo;
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");
gotof2ELT;
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");
gotoG8uDN;
p_0sE:
return $this
->db
->get()
->row();
gotoWGIBa;
f2ELT:
if (!($id_tp != null && $id_smt != null))
{
gotoD8Y_P;
}
gotocjx6x;
cPqMz:
$this
->db
->select("\x2a");
gotoDrHLj;
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");
gotocPqMz;
DrHLj:
$this
->db
->from("\155\141\x73\164\x65\x72\137\147\x75\162\x75\x20\141");
gotoFoFjU;
vwaGA:
$this
->db
->where("\x61\56\x69\144\137\x67\165\162\165", $id);
gotop_0sE;
WGIBa:
}
public function getGuruByArrId($arr_id)
{
gotou09HV;
YO2QQ:
if (!(count($arr_id) > 0))
{
gotoqaezi;
}
gotohX9PJ;
hX9PJ:
$this
->db
->where_in("\151\x64\x5f\x67\x75\x72\x75", $arr_id);
gotolzfBV;
Vhhbi:
$this
->db
->from("\x6d\141\163\x74\145\162\x5f\x67\x75\162\x75");
gotoYO2QQ;
Nv3W3:
return $this
->db
->get()
->result();
gotovaVyc;
lzfBV:
qaezi:
gotoNv3W3;
u09HV:
$this
->db
->select("\x6e\x61\x6d\141\137\x67\165\x72\165\54\40\x6e\x69\x70");
gotoVhhbi;
vaVyc:
}
public function getUserIdGuruByUsername($username)
{
gotoLGhdU;
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");
gototwovJ;
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");
gotoQ1Ci4;
Q1Ci4:
$this
->db
->select("\52");
gotouor3w;
uor3w:
$this
->db
->from("\x6d\141\x73\164\145\162\137\x67\165\162\x75\x20\x61");
gotof3snX;
PyXcU:
return $this
->db
->get()
->row();
gotoJAtk0;
twovJ:
$this
->db
->where("\x61\x2e\165\x73\145\x72\156\x61\x6d\145", $username);
gotoPyXcU;
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");
gotoKpFGb;
JAtk0:
}
public function getDetailJabatanGuru($id_guru)
{
gotovFg_8;
GWERP:
ZJ455:
gotoXCAza;
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");
gotow2j0N;
SxRM7:
$ret = [];
gotou45m2;
p_WZy:
$this
->db
->where("\141\56\151\x64\x5f\x67\165\x72\x75", $id_guru);
gotoftShE;
w2j0N:
$this
->db
->from("\x6d\141\163\164\x65\x72\x5f\147\x75\162\165\40\x61");
gotoz7Pm3;
XCAza:
return $ret;
gotofoGYx;
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");
gotot2gvG;
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");
gotoIOWYO;
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");
gotoM8Xmt;
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");
gotop_WZy;
u45m2:
foreach ($result as $row)
{
$ret[$row->id_tp][$row->id_smt] = $row;
El7Jn:
}
gotoGWERP;
ftShE:
$result = $this
->db
->get()
->result();
gotoSxRM7;
foGYx:
}
public function getJabatanGuru($id_guru, $tp, $smt)
{
gotoFFZoA;
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");
gotoL1AQl;
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");
gotoSx9cL;
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");
gotoEidmE;
Sx9cL:
$this
->db
->where("\141\x2e\x69\x64\137\147\165\162\165", $id_guru);
gotomIAod;
L1AQl:
$this
->db
->from("\155\141\x73\164\145\162\x5f\147\x75\x72\x75\40\x61");
gotoKRcIU;
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");
gotoEB35n;
mIAod:
return $this
->db
->get()
->row();
gotoRIkkT;
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");
gotoc4eVJ;
RIkkT:
}
public function getGuruMapel($tp, $smt)
{
gotoannYi;
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");
gotox5ZbT;
ba9eZ:
return $this
->db
->get()
->result();
gotoBdmPq;
x5ZbT:
$this
->db
->from("\152\141\142\x61\x74\141\x6e\137\x67\x75\x72\165\x20\x61");
gotoNOXUb;
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");
gotoJSbFW;
JSbFW:
$this
->db
->where("\141\x2e\x69\144\137\164\160", $tp);
gotofvXDf;
fvXDf:
$this
->db
->where("\x61\56\151\x64\137\163\x6d\x74", $smt);
gotoba9eZ;
BdmPq:
}
public function getKodeKelompokMapel()
{
gotoEfey2;
WirIA:
$ret = [];
gotonYngZ;
Mx6Xy:
ka7qB:
gotosO13X;
mDKJx:
$result = $this
->db
->get()
->result();
gotoWirIA;
Efey2:
$this
->db
->select("\x2a");
gotoN_CV8;
nYngZ:
foreach ($result as $row)
{
$ret[$row->kode_kel_mapel] = $row;
ASbqA:
}
gotoMx6Xy;
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");
gotokKAld;
sO13X:
return $ret;
gotoCmxRL;
kKAld:
$this
->db
->order_by("\153\157\x64\145\x5f\x6b\x65\x6c\137\155\141\x70\145\154");
gotomDKJx;
CmxRL:
}
public function getDataKelompokMapel()
{
gotoN0aRP;
nFjcY:
$this
->db
->where("\x69\x64\137\x70\141\x72\145\x6e\164", "\x30");
gotox3kIL;
x3kIL:
$this
->db
->order_by("\153\157\144\145\x5f\153\145\x6c\x5f\x6d\x61\x70\145\x6c");
gototGYC2;
X5yMe:
fweyk:
gotoBSGdv;
tGYC2:
$result = $this
->db
->get()
->result();
gotovVkK3;
ljWMV:
foreach ($result as $row)
{
$ret[$row->id_kel_mapel] = $row;
SkABx:
}
gotoX5yMe;
N0aRP:
$this
->db
->select("\52");
gotoptHhV;
BSGdv:
return $ret;
gotoNGjnh;
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");
gotonFjcY;
vVkK3:
$ret = [];
gotoljWMV;
NGjnh:
}
public function getKategoriKelompokMapel()
{
gotoYH177;
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");
gototvvAw;
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");
gotoLrZBu;
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");
gotoAKpGJ;
tvvAw:
return $this
->db
->get()
->result();
gotoAurdY;
AurdY:
}
public function getDataSubKelompokMapel()
{
gotoSYpTH;
d37ej:
$this
->db
->where("\151\144\x5f\x70\x61\x72\x65\x6e\164\40\x3c\76\40\x30");
gotoN72qO;
xt9sX:
UlHWo:
gotouYJG4;
SYpTH:
$this
->db
->select("\52");
gotocRiwx;
oCMhF:
$result = $this
->db
->get()
->result();
gotofzeBT;
fzeBT:
$ret = [];
gotogVSim;
gVSim:
foreach ($result as $row)
{
$ret[$row->id_kel_mapel] = $row;
pwb9T:
}
gotoxt9sX;
N72qO:
$this
->db
->order_by("\153\x6f\144\x65\x5f\x6b\145\x6c\137\x6d\x61\160\x65\154");
gotooCMhF;
uYJG4:
return $ret;
gotoA_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");
gotod37ej;
A_szD:
}
public function getDataMapel()
{
gotobCDLz;
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");
gotomwF4n;
mwF4n:
$this
->datatables
->from("\155\141\163\x74\x65\162\x5f\155\141\x70\x65\154");
gotoQH1Nc;
QH1Nc:
return $this
->datatables
->generate();
gotoOkzmG;
OkzmG:
}
public function getAllMapel($arrKelompok = null, $arrMapel = null)
{
gotoC0pJX;
C4RO8:
$this
->db
->where_in("\153\x65\154\157\x6d\x70\157\x6b", $arrKelompok);
gotobWemv;
zwCZT:
$this
->db
->where("\163\x74\141\x74\x75\163", "\61");
gotocKX3a;
C0pJX:
if (!($arrMapel != null))
{
gotod0hxp;
}
gotoC4RO8;
wBCGu:
et1ji:
gotozwCZT;
cKX3a:
$this
->db
->order_by("\165\162\x75\x74\141\156\x5f\x74\141\155\160\151\154");
gotoiRMp7;
Ah21T:
if (!($arrMapel != null))
{
gotoet1ji;
}
gotot68l4;
iRMp7:
return $this
->db
->get("\155\x61\x73\164\145\x72\x5f\x6d\x61\160\145\154")
->result();
gotoic1QJ;
t68l4:
$this
->db
->or_where_in("\x69\144\137\x6d\x61\160\x65\154", explode("\x2c", $arrMapel));
gotowBCGu;
bWemv:
d0hxp:
gotoAh21T;
ic1QJ:
}
public function getAllStatusMapel($arrKelompok = null, $arrMapel = null)
{
gotoH07iA;
Wimdl:
if (!($arrMapel != null))
{
gotofJO27;
}
gotoSK9W7;
P8_wR:
fJO27:
gotoN8vZQ;
SgMQM:
return $this
->db
->get("\155\x61\x73\x74\x65\x72\137\x6d\141\160\145\x6c")
->result();
gotoX4J67;
H07iA:
if (!($arrMapel != null))
{
gotoPGgbf;
}
gotohWNhh;
N8vZQ:
$this
->db
->order_by("\x75\162\165\x74\x61\156\x5f\x74\x61\x6d\x70\x69\154");
gotoSgMQM;
hWNhh:
$this
->db
->where_in("\153\145\x6c\157\x6d\x70\157\x6b", $arrKelompok);
gotoIeBOL;
SK9W7:
$this
->db
->or_where_in("\151\x64\137\x6d\141\x70\x65\154", explode("\x2c", $arrMapel));
gotoP8_wR;
IeBOL:
PGgbf:
gotoWimdl;
X4J67:
}
public function getAllMapelByKelompok($jenjang)
{
gotoxciRO;
a_XX4:
$ret = [];
gotoGsMKs;
mq09_:
return $ret;
gotoPNlCB;
xciRO:
$this
->db
->where("\163\x74\x61\164\165\x73", "\61");
gotorDZLU;
KtkRR:
$this
->db
->order_by("\165\x72\x75\x74\x61\x6e\x5f\x74\141\x6d\x70\x69\x6c");
gotoZKHUC;
ZKHUC:
$result = $this
->db
->get("\x6d\141\x73\x74\145\x72\x5f\155\141\x70\145\x6c")
->result();
gotoa_XX4;
g0gdn:
kzn6C:
gotomq09_;
rDZLU:
$this
->db
->order_by("\x75\x72\x75\x74\141\x6e");
gotoKtkRR;
GsMKs:
foreach ($result as $row)
{
$ret[$row->kelompok][] = $row;
ouHsY:
}
gotog0gdn;
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)
{
gotoB18of;
VG7_0:
$this
->db
->order_by("\156\x61\155\141\x5f\155\x61\160\x65\x6c");
gotoARhIG;
k8lIm:
return $query;
gotonQfNJ;
aZKwh:
gotol6wF8;
gotoDWylE;
AZFsG:
$query = $this
->db
->get_where("\x6d\x61\x73\x74\145\162\x5f\x6d\x61\x70\x65\x6c", array(
"\x69\144\x5f\155\141\160\x65\x6c" => $id
))->row();
gotoaZKwh;
DWylE:
qOtQi:
gotoB_AHy;
B_AHy:
$this
->db
->where_in("\x69\144\x5f\155\x61\160\145\x6c", $id);
gotoVG7_0;
ARhIG:
$query = $this
->db
->get("\155\141\x73\164\x65\x72\137\155\141\160\145\154")
->result();
gotoeHymO;
B18of:
if ($single === false)
{
gotoqOtQi;
}
gotoAZFsG;
eHymO:
l6wF8:
gotok8lIm;
nQfNJ:
}
function updateMapel()
{
gotoa4hVm;
eDD1v:
$kelompok = $this
->input
->post("\x6b\145\x6c\157\155\x70\x6f\153", true);
gotor3QSC;
hqk_O:
$kode = $this
->input
->post("\153\157\144\145\x5f\x6d\141\x70\x65\154", true);
gotoeDD1v;
r3QSC:
$status = $this
->input
->post("\x73\x74\141\164\165\163", true);
gotoklM44;
EqHCk:
$name = $this
->input
->post("\156\x61\155\x61\137\x6d\141\160\x65\x6c", true);
gotohqk_O;
ItOPl:
$this
->db
->where("\x69\x64\x5f\x6d\141\x70\x65\154", $id);
gotoDWDqu;
DWDqu:
return $this
->db
->update("\x6d\x61\x73\164\x65\162\x5f\155\141\x70\145\x6c");
gotobS6om;
klM44:
$urut = $this
->input
->post("\165\162\165\164\141\x6e\x5f\x74\x61\x6d\160\x69\154", true);
gotojPGBp;
P9H32:
$this
->db
->set("\x73\164\x61\x74\x75\x73", $status);
gotowKLQT;
kgXHk:
amtN0:
gotoP9H32;
a4hVm:
$id = $this
->input
->post("\x69\144\137\155\141\160\145\x6c");
gotoEqHCk;
wKLQT:
$this
->db
->set("\165\x72\165\164\x61\x6e\x5f\x74\141\155\x70\151\x6c", $urut);
gotoItOPl;
vo0BK:
$this
->db
->set("\153\x6f\144\145", $kode);
gotojVz5o;
jVz5o:
if (!($kelompok != null))
{
gotoamtN0;
}
gotoYVaKb;
YVaKb:
$this
->db
->set("\153\145\x6c\157\155\x70\157\153", $kelompok);
gotokgXHk;
jPGBp:
$this
->db
->set("\x6e\141\x6d\x61\x5f\155\141\160\x65\154", $name);
gotovo0BK;
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)
{
gotoc9k_I;
Ll5n9:
return $query;
gotoM0uA3;
EVfCI:
op6Qh:
gotoUdZ1e;
y8SdQ:
$query = $this
->db
->get("\x6d\141\163\164\145\x72\137\x65\x6b\163\164\x72\x61")
->result();
gotovxF_0;
ur9RA:
gotok0E3Q;
gotoEVfCI;
G8kIr:
$query = $this
->db
->get_where("\x6d\141\163\164\145\x72\137\145\153\163\164\162\x61", array(
"\151\x64\x5f\x65\153\163\164\x72\x61" => $id
))->row();
gotour9RA;
c9k_I:
if ($single === false)
{
gotoop6Qh;
}
gotoG8kIr;
vxF_0:
k0E3Q:
gotoLl5n9;
UdZ1e:
$this
->db
->where_in("\151\144\137\145\x6b\x73\x74\x72\141", $id);
gotoFsdFq;
FsdFq:
$this
->db
->order_by("\x6e\x61\155\141\137\145\153\163\164\162\x61");
gotoy8SdQ;
M0uA3:
}
function updateEkstra()
{
gotoGVSQ7;
vYWtA:
return $this
->db
->update("\155\141\163\164\145\162\x5f\x65\153\163\x74\162\141");
gotoit9zG;
GVSQ7:
$id = $this
->input
->post("\151\144\x5f\x65\x6b\x73\164\162\141");
gotoH8m30;
cJN5Z:
$this
->db
->set("\156\141\155\141\x5f\x65\153\163\164\162\x61", $name);
gotoAxQDw;
Fta8l:
$this
->db
->where("\x69\144\x5f\145\x6b\163\164\x72\x61", $id);
gotovYWtA;
H8m30:
$name = $this
->input
->post("\156\x61\x6d\x61\137\145\153\x73\164\162\141", true);
gotoqjUy0;
AxQDw:
$this
->db
->set("\153\x6f\x64\145\x5f\145\153\163\164\162\141", $kode);
gotoFta8l;
qjUy0:
$kode = $this
->input
->post("\x6b\157\144\145\137\145\153\x73\x74\162\x61", true);
gotocJN5Z;
it9zG:
}
public function getKelasGuru()
{
gotoZ75dM;
LrBZe:
return $this
->datatables
->generate();
gotoWKABX;
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");
gototg3xh;
fdP81:
$this
->datatables
->group_by("\147\165\x72\x75\x2e\x6e\x61\x6d\141\137\147\x75\162\165");
gotoLrBZe;
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");
gotox6dzj;
tg3xh:
$this
->datatables
->from("\x6b\145\x6c\x61\163\137\x67\165\x72\165");
gotoQ6clt;
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");
gotofdP81;
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");
gotoM4WTK;
WKABX:
}
public function getKelasByGuru($id)
{
gotoX5Udd;
f3uTD:
$this
->db
->where("\147\x75\162\165\x5f\x69\x64", $id);
gotokAxkL;
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");
gotof3uTD;
X5Udd:
$this
->db
->select("\x6b\x65\x6c\141\x73\x2e\x69\144\137\x6b\145\x6c\141\163");
gotoQk3KF;
Qk3KF:
$this
->db
->from("\153\145\154\141\163\x5f\x67\x75\x72\165");
gotoSs9vB;
kAxkL:
return $this
->db
->get()
->result();
gotok7cos;
k7cos:
}
public function getAllJabatanGuru($id)
{
gotocaClc;
yNmUz:
up_oR:
gotosHkhZ;
mpS8r:
return $ret;
gotoLsvw_;
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();
gotoadWNF;
e_Dw2:
foreach ($result as $key => $row)
{
$ret[$row->id_tp][$row
->id_smt] = $row->id_kelas;
Y2uec:
}
gotoyNmUz;
adWNF:
$ret = [];
gotog_GNx;
sHkhZ:
AzQOK:
gotompS8r;
g_GNx:
if (!$result)
{
gotoAzQOK;
}
gotoe_Dw2;
Lsvw_:
}
public function getJurusanMapel()
{
gotoTJycE;
p5p_I:
$this
->datatables
->from("\152\165\162\165\x73\x61\x6e\x5f\155\x61\x70\x65\x6c");
gotos3TLa;
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");
gotogMnxn;
Ng5xO:
return $this
->datatables
->generate();
gotoLYpdq;
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");
gotoNg5xO;
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");
gotohJhXu;
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");
gotoC6B5M;
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");
gotop5p_I;
LYpdq:
}
public function getMapel($id = null)
{
gototLI_x;
Ei2EO:
JM9Gj:
gotopp27E;
tLI_x:
$this
->db
->select("\155\x61\160\145\x6c\x5f\151\x64");
gotor5PhN;
TIrhG:
foreach ($mapel as $d)
{
$id_mapel[] = $d->mapel_id;
Z6fHJ:
}
gotozienz;
MXc2C:
$id_mapel = null;
gotoEi2EO;
gbpXV:
$this
->db
->where_not_in("\155\x61\x70\x65\x6c\x5f\x69\x64", [$id]);
gotoCN_Uu;
r5PhN:
$this
->db
->from("\152\165\162\x75\x73\141\x6e\x5f\155\141\160\145\x6c");
gotoG0Mbp;
yXfS3:
if (!($id_mapel === []))
{
gotoJM9Gj;
}
gotoMXc2C;
G0Mbp:
if (!($id !== null))
{
gotoAilWi;
}
gotogbpXV;
CKr1c:
$id_mapel = [];
gotoTIrhG;
zienz:
AyD2D:
gotoyXfS3;
CN_Uu:
AilWi:
gotoMa0pX;
DrTQF:
$this
->db
->from("\x6d\x61\x73\164\145\162\x5f\x6d\x61\160\x65\x6c");
gotoGvCou;
Ma0pX:
$mapel = $this
->db
->get()
->result();
gotoCKr1c;
GvCou:
$this
->db
->where_not_in("\151\144\137\x6d\x61\160\145\154", $id_mapel);
gotoASsj1;
pp27E:
$this
->db
->select("\151\x64\137\x6d\x61\160\x65\154\x2c\40\156\141\155\141\x5f\x6d\x61\x70\x65\x6c");
gotoDrTQF;
ASsj1:
return $this
->db
->get()
->result();
gotosLsuB;
sLsuB:
}
public function getJurusanByIdMapel($id)
{
gotoFytXb;
g_etC:
return $this
->db
->get()
->result();
gototnpdQ;
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");
gotokdL97;
LPTXl:
$this
->db
->from("\152\x75\162\165\x73\x61\x6e\x5f\155\x61\160\145\x6c");
gotoatmPT;
FytXb:
$this
->db
->select("\x6a\165\x72\x75\163\141\156\56\x69\144\137\152\x75\162\x75\x73\141\x6e");
gotoLPTXl;
kdL97:
$this
->db
->where("\x6d\141\160\x65\154\x5f\x69\x64", $id);
gotog_etC;
tnpdQ:
}
public function getTahunActive()
{
gotoKQtV4;
KQtV4:
$this
->db
->select("\151\144\x5f\164\160\54\x20\164\x61\150\165\x6e");
gototof4P;
tof4P:
$this
->db
->from("\155\x61\x73\x74\145\x72\x5f\x74\x70");
gotoz4Sin;
ZamrK:
return $this
->db
->get()
->row();
gotovzBcU;
z4Sin:
$this
->db
->where("\x61\x63\x74\x69\x76\145", 1);
gotoZamrK;
vzBcU:
}
public function getSemesterActive()
{
gotomYeMd;
mtiBd:
$this
->db
->where("\141\143\164\151\166\145", 1);
gotouu8tG;
uu8tG:
return $this
->db
->get()
->row();
gotolHstp;
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");
gotolYU0Z;
lYU0Z:
$this
->db
->from("\155\x61\163\x74\x65\x72\137\163\155\x74");
gotomtiBd;
lHstp:
}
public function getJmlHariEfektif($id)
{
gototn4gz;
tn4gz:
$this
->db
->select("\x2a");
gotoee1_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");
gotocQdzU;
cQdzU:
$this
->db
->where("\x69\144\x5f\x68\141\162\151\x5f\x65\146\x65\x6b\x74\x69\146", $id);
gotom7y6l;
m7y6l:
return $this
->db
->get()
->row();
gotoyHIjA;
yHIjA:
}
public function getDistinctTahunLulus()
{
gotozNZGs;
Hw_8Y:
$ret = [];
gotoTv22h;
jhbIq:
JnyZZ:
gotosf24b;
Tv22h:
foreach ($result as $row)
{
gotodMNC7;
O5A0x:
yBS2q:
gotoIHlx8;
Br8i3:
$ret[$row
->tahun_lulus] = $row->tahun_lulus;
gotoj4R7V;
dMNC7:
if (!($row->tahun_lulus != ''))
{
gotoeFSMO;
}
gotoBr8i3;
j4R7V:
eFSMO:
gotoO5A0x;
IHlx8:
}
gotojhbIq;
sf24b:
return $ret;
gotoOedtw;
DSAYu:
$this
->db
->distinct();
gotoKTha4;
zNZGs:
$this
->db
->select("\164\141\150\165\156\x5f\154\165\x6c\x75\x73");
gotoDSAYu;
KTha4:
$result = $this
->db
->get("\142\165\153\x75\x5f\151\x6e\144\x75\x6b")
->result();
gotoHw_8Y;
Oedtw:
}
public function getDistinctKelasAkhir()
{
gotovLD_I;
ciU24:
foreach ($result as $row)
{
gotozGrDl;
dBY3P:
zndPS:
gotoAt4Uj;
EvWB1:
kD5hw:
gotodBY3P;
fHppt:
$ret[$row
->kelas_akhir] = $row->kelas_akhir;
gotoEvWB1;
zGrDl:
if (!($row->kelas_akhir != ''))
{
gotokD5hw;
}
gotofHppt;
At4Uj:
}
gotoP41iT;
hMyEA:
$ret = [];
gotociU24;
b5YVR:
$result = $this
->db
->get("\x62\165\x6b\165\x5f\151\x6e\x64\x75\153")
->result();
gotohMyEA;
vLD_I:
$this
->db
->select("\153\145\x6c\141\163\x5f\141\153\150\x69\x72");
gotoy1Akt;
P41iT:
cPWJO:
gotoR2U4D;
R2U4D:
return $ret;
gotoLnQ0t;
y1Akt:
$this
->db
->distinct();
gotob5YVR;
LnQ0t:
}
public function getAlumniByTahun($tahun, $kelas = null)
{
gotoOTL5W;
O7Wqw:
return $this
->db
->get()
->result();
gototgFQg;
hByem:
if (!($kelas != null))
{
gotodF_QY;
}
gotoxSu8v;
xSu8v:
$this
->db
->where("\141\56\x6b\145\x6c\x61\x73\137\x61\153\150\151\162", $kelas);
gotopYRRG;
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");
gotoMTacN;
MTacN:
$this
->db
->where("\x61\x2e\x74\x61\x68\x75\x6e\x5f\154\165\154\x75\x73", $tahun);
gotohByem;
fMl3h:
$this
->db
->from("\142\x75\153\165\x5f\151\156\x64\x75\153\x20\x61");
gotoeF6T4;
OTL5W:
$this
->db
->select("\52");
gotofMl3h;
pYRRG:
dF_QY:
gotoO7Wqw;
tgFQg:
}
public function getAlumniById($id)
{
gotomOcs0;
z4oDc:
$this
->db
->where("\x61\x2e\x69\144\137\163\151\163\167\x61", $id);
gotoqkl_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");
gotoz4oDc;
mOcs0:
$this
->db
->select("\x2a");
gotoRRifm;
qkl_h:
return $this
->db
->get()
->row();
gotocCKwu;
RRifm:
$this
->db
->from("\x6d\141\163\x74\x65\x72\x5f\x73\151\163\167\141\40\x61");
gotopRupb;
cCKwu:
}
public function getAllWaliKelas()
{
gotopnh4h;
gyf7F:
$this
->db
->from("\152\x61\x62\141\164\141\156\137\147\165\x72\165\40\141");
gotoj2DWr;
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");
gotoK0VOR;
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");
gotouN2Ba;
kWinZ:
if (!$result)
{
gotohHHP8;
}
gotouc3yV;
uc3yV:
foreach ($result as $key => $row)
{
gotohbsly;
J91w5:
mJpKM:
gotoyJUoj;
FxBer:
fJJWg:
gotoJ91w5;
hbsly:
if (!($row->id_level == "\x34"))
{
gotofJJWg;
}
gotoIsnyN;
IsnyN:
$ret[$row->id_tp][$row->id_smt][$row->id_kelas] = $row;
gotoFxBer;
yJUoj:
}
gotoZF_ow;
xj27b:
$ret = [];
gotokWinZ;
ZF_ow:
Q9s3J:
gotosmyRH;
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");
gotogyf7F;
DIVnD:
return $ret;
gotoZzoI_;
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");
gotocyMPg;
smyRH:
hHHP8:
gotoDIVnD;
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");
gotogSN3N;
K0VOR:
$result = $this
->db
->get()
->result();
gotoxj27b;
ZzoI_:
}
public function getAllGuru()
{
gotoQY7zN;
lBS0G:
return $this
->db
->get()
->result();
gotok86ut;
zQXCG:
$guru = $this
->db
->get()
->result();
gotoOE_Jt;
QY7zN:
$this
->db
->select("\151\144\x5f\147\165\162\165");
gotoqTcJW;
qTcJW:
$this
->db
->from("\x6a\x61\142\x61\164\141\156\137\x67\x75\162\x75");
gotozQXCG;
JLuev:
$this
->db
->from("\x6d\x61\163\x74\x65\162\x5f\147\165\x72\x75");
gotoxAG6p;
OE_Jt:
$id_guru = [];
gotoiejva;
zxdzi:
Z9RvR:
gotoZq84v;
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");
gotoJLuev;
xAG6p:
$this
->db
->where_in("\x69\144\x5f\x67\165\x72\x75", $id_guru);
gotolBS0G;
iejva:
foreach ($guru as $d)
{
$id_guru[] = $d->id_guru;
Xpzxl:
}
gotozxdzi;
k86ut:
}
public function getAllKelas($tp = null, $smt = null)
{
gotoRoSt6;
xGd4L:
return $ret;
gotozf8ff;
xnQcH:
NOaFO:
gotoxlRKN;
GDIV0:
foreach ($result as $key => $row)
{
$ret[$row->id_kelas] = $row;
HXDo_:
}
gotofQX5z;
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");
gotoSV4b5;
uuGiV:
gotoaIAIG;
gotogU7cb;
zsKJ3:
if ($tp != null && $smt != null)
{
gotolZgZi;
}
gotoS29tH;
SV4b5:
$this
->db
->from("\155\x61\163\x74\x65\x72\137\x6b\145\x6c\x61\163\x20\141");
gotoVpwSu;
S29tH:
if (!$result)
{
gotoOO9Lw;
}
gotoBy32H;
fQX5z:
lhUty:
gotoxnQcH;
yPCzY:
$this
->db
->order_by("\141\x2e\156\x61\155\141\x5f\153\145\x6c\141\x73");
gotoLUPZt;
RMHT_:
lCaNz:
gotoKAcCG;
vFuEb:
if (!$result)
{
gotoNOaFO;
}
gotoGDIV0;
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");
gotoAVf71;
VpwSu:
if (!($tp != null && $smt != null))
{
gotolCaNz;
}
gotoX8fsD;
X8fsD:
$this
->db
->where("\x61\56\151\144\x5f\164\160", $tp)->where("\141\56\151\x64\137\x73\x6d\164", $smt);
gotoRMHT_;
wQUVf:
$ret = [];
gotozsKJ3;
gU7cb:
lZgZi:
gotovFuEb;
pEf3n:
vw382:
gotoPV0xY;
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");
gotoyPCzY;
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");
gotoCWX5D;
PV0xY:
OO9Lw:
gotouuGiV;
xlRKN:
aIAIG:
gotoxGd4L;
By32H:
foreach ($result as $key => $row)
{
$ret[$row->id_tp][$row->id_smt][$row->id_kelas] = $row;
brjak:
}
gotopEf3n;
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");
gotoK1j8E;
LUPZt:
$result = $this
->db
->get()
->result();
gotowQUVf;
zf8ff:
}
public function getAllKelasSiswa()
{
gotoD3L17;
yunXP:
f0tuG:
gotobRxvZ;
D3L17:
$this
->db
->select("\52");
gotooz2qe;
uTpLU:
$ret = [];
gotoawgBq;
KlVwB:
U3Hi1:
gotoyunXP;
bRxvZ:
return $ret;
gotoguHVv;
oz2qe:
$this
->db
->from("\x6b\145\x6c\141\x73\137\x73\151\163\167\x61");
gotooHuV8;
awgBq:
if (!$result)
{
gotof0tuG;
}
gotoq3Gag;
q3Gag:
foreach ($result as $key => $row)
{
$ret[$row->id_kelas][$row->id_siswa] = $row;
UXlfX:
}
gotoKlVwB;
oHuV8:
$result = $this
->db
->get()
->result();
gotouTpLU;
guHVv:
}
public function getDataInduk()
{
gotohdoE3;
pw1jT:
$result = $this
->db
->get()
->result();
gotoVsPTb;
d2k7B:
return $ret;
gotoBOBmw;
VsPTb:
$ret = [];
gotoawQLR;
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");
gotodh83w;
hdoE3:
$this
->db
->select("\x61\56\x2a\54\x20\142\x2e\x2a\x2c");
gotoGkmDX;
awQLR:
if (!$result)
{
gotoiiWCt;
}
gotorQb0n;
dh83w:
$this
->db
->order_by("\x61\56\x6e\x61\155\141", "\x41\x53\x43");
gotopw1jT;
QxDNP:
zkM85:
gotodz_s3;
GkmDX:
$this
->db
->from("\155\x61\163\x74\145\162\x5f\x73\151\163\167\141\x20\x61");
gotoOV_CA;
dz_s3:
iiWCt:
gotod2k7B;
rQb0n:
foreach ($result as $key => $row)
{
$ret[$row->id_siswa] = $row;
MBANm:
}
gotoQxDNP;
BOBmw:
}
}
Function Calls
| None |
Stats
| MD5 | 041cdd70259be5cec32df2facae238ce |
| Eval Count | 0 |
| Decode Time | 752 ms |