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