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