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 |
|________________________________________|
*/
class Kelas_model extends CI_Model
{
public function __construct()
{
parent::__construct();
}
public function saveLog($table, $id_siswa, $id_kjm, $jamke, $mapel, $desc)
{
goto Gt5iP;
VPp45:
jB18O:
goto yy3cJ;
Krny4:
Q7ywn:
goto rhJPk;
V3sEa:
goto mNZIT;
goto Krny4;
Gtm86:
$ip = $this->input->ip_address();
goto Mkn7u;
Dkrc4:
HVnVV:
goto CGhre;
CGhre:
if ($agent == "unknown") {
goto Q7ywn;
}
goto rGLdn;
dqrTe:
$agent = "unknown";
goto gYU5l;
gYU5l:
goto HVnVV;
goto VPp45;
Wj4nG:
goto HVnVV;
goto fynaJ;
Mkn7u:
return $this->insertLog($table, $id_siswa, $id_kjm, $jamke, $mapel, $desc, $agent, $os, $ip);
goto V3sEa;
yy3cJ:
$agent = $this->agent->browser() . " " . $this->agent->version();
goto Wj4nG;
pSOyU:
if ($this->agent->is_mobile()) {
goto fC5ri;
}
goto dqrTe;
rGLdn:
$os = $this->agent->platform();
goto Gtm86;
fynaJ:
fC5ri:
goto qaQwP;
Gt5iP:
if ($this->agent->is_browser()) {
goto jB18O;
}
goto pSOyU;
qaQwP:
$agent = $this->agent->mobile();
goto Dkrc4;
EiAWS:
mNZIT:
goto dSKtJ;
rhJPk:
return "error";
goto EiAWS;
dSKtJ:
}
private function insertLog($table, $id_siswa, $id_kjm, $jamke, $mapel, $desc, $agent, $os, $ip)
{
goto Uuqwq;
ebT31:
return $insert;
goto kU22Y;
NKgTu:
$insert = $this->db->insert($table, $data);
goto ebT31;
Uuqwq:
$data = array("id_log" => $id_siswa . $id_kjm, "log_time" => date("Y-m-d H:i:s"), "id_siswa" => $id_siswa, "id_materi" => $id_kjm, "id_mapel" => $mapel, "jam_ke" => $jamke, "log_desc" => $desc, "address" => $ip, "agent" => $agent, "device" => $os);
goto NKgTu;
kU22Y:
}
public function getKelasList($tp, $smt)
{
goto BHnq8;
KtxrH:
$this->db->join("master_jurusan b", "b.id_jurusan=a.jurusan_id", "left");
goto ROQng;
ROQng:
$this->db->join("level_kelas c", "c.id_level=a.level_id", "left");
goto hB6xB;
KjvvX:
$this->db->order_by("a.nama_kelas", "ASC");
goto W9IH3;
OA5Ng:
$this->db->where("a.id_smt", $smt);
goto XY6l2;
bL_mD:
$this->db->join("master_siswa e", "e.id_siswa=a.siswa_id", "left");
goto mgHk5;
BHnq8:
$this->db->select("a.*, b.nama_jurusan, d.nama_guru, e.nama, (SELECT COUNT(id_kelas_siswa) FROM kelas_siswa k WHERE a.id_kelas=k.id_kelas) AS jml_siswa");
goto rD4Yi;
XY6l2:
$this->db->order_by("a.level_id", "ASC");
goto KjvvX;
nR33I:
return $query->result();
goto dOzG3;
W9IH3:
$query = $this->db->get();
goto nR33I;
rD4Yi:
$this->db->from("master_kelas a");
goto KtxrH;
Rz6nr:
$this->db->join("master_guru d", "d.id_guru=f.id_guru", "left");
goto bL_mD;
hB6xB:
$this->db->join("jabatan_guru f", "f.id_kelas=a.id_kelas", "left");
goto Rz6nr;
mgHk5:
$this->db->where("a.id_tp", $tp);
goto OA5Ng;
dOzG3:
}
public function getJmlSiswaKelas($id_kelas)
{
goto f6Ap9;
Ifrf2:
return $this->db->count_all_results();
goto cOaTp;
f6Ap9:
$this->db->from("kelas_siswa");
goto GqXX1;
GqXX1:
$this->db->where("id_kelas", $id_kelas);
goto Ifrf2;
cOaTp:
}
public function get_all($limit, $offset)
{
goto i_9wv;
DcnCz:
goto gQfhQ;
goto Gqj4I;
Gqj4I:
gSKaf:
goto TJWhe;
TJWhe:
return $result->result_array();
goto JrfrQ;
Hl7Jg:
return array();
goto DcnCz;
NOJ_h:
if ($result->num_rows() > 0) {
goto gSKaf;
}
goto Hl7Jg;
i_9wv:
$result = $this->db->get("master_kelas", $limit, $offset);
goto NOJ_h;
JrfrQ:
gQfhQ:
goto xnWqc;
xnWqc:
}
public function getAllKelas()
{
goto k7sZo;
Dpyhm:
$this->db->join("jabatan_guru f", "f.id_kelas=a.id_kelas", "left");
goto jLK09;
a1dVl:
$this->db->from("master_kelas a");
goto Dpyhm;
YAuYM:
return $result;
goto cpf_p;
KXdy5:
$result = $this->db->get()->result();
goto YAuYM;
ztpkH:
$this->db->order_by("a.nama_kelas");
goto KXdy5;
jLK09:
$this->db->join("master_jurusan b", "a.jurusan_id=b.id_jurusan", "left");
goto UHVDi;
k7sZo:
$this->db->select("a.id_kelas, a.id_tp, a.id_smt, a.nama_kelas, a.kode_kelas, a.level_id, b.id_jurusan, b.nama_jurusan, b.kode_jurusan, c.id_guru, c.nama_guru");
goto a1dVl;
UHVDi:
$this->db->join("master_guru c", "f.id_guru=c.id_guru", "left");
goto ztpkH;
cpf_p:
}
public function count_all()
{
$this->db->from("master_kelas");
return $this->db->count_all_results();
}
public function get_search($limit, $offset)
{
goto ksMpW;
uKQal:
if ($result->num_rows() > 0) {
goto mJm6H;
}
goto wKj3L;
WDeiN:
mJm6H:
goto FJP1R;
wKj3L:
return array();
goto yhBw5;
iImU5:
$this->db->like("nama_kelas", $keyword);
goto QmVIg;
mcfku:
$this->db->limit($limit, $offset);
goto JRdLa;
FJP1R:
return $result->result_array();
goto dqSbW;
QmVIg:
$this->db->like("jumlah_siswa", $keyword);
goto mcfku;
JRdLa:
$result = $this->db->get("master_kelas");
goto uKQal;
dqSbW:
c15c2:
goto X6UOt;
yhBw5:
goto c15c2;
goto WDeiN;
ksMpW:
$keyword = $this->session->userdata("keyword");
goto iImU5;
X6UOt:
}
public function count_all_search()
{
goto G1nPo;
G1nPo:
$keyword = $this->session->userdata("keyword");
goto Yu0p3;
sx7TB:
return $this->db->count_all_results();
goto ohh9V;
Yu0p3:
$this->db->from("master_kelas");
goto oHiG8;
XEQeW:
$this->db->like("jumlah_siswa", $keyword);
goto sx7TB;
oHiG8:
$this->db->like("nama_kelas", $keyword);
goto XEQeW;
ohh9V:
}
public function get_one($id, $id_tp = null, $id_smt = null)
{
goto dTTHi;
z1cuz:
if (!($id_tp != null)) {
goto p8Vsu;
}
goto a84vo;
cqZ_c:
$this->db->where("k.id_kelas", $id);
goto z1cuz;
qlmXJ:
$this->db->join("level_kelas l", "l.id_level=k.level_id", "left");
goto k0Xgf;
dTTHi:
$this->db->select("*");
goto wFtbi;
ChJ1U:
$this->db->join("master_siswa si", "si.id_siswa=k.siswa_id", "left");
goto HmXO2;
wFtbi:
$this->db->from("master_kelas k");
goto DhUww;
k0Xgf:
$this->db->join("jabatan_guru f", "f.id_kelas=k.id_kelas", "left");
goto W2dqR;
HmXO2:
$this->db->order_by("nama_kelas", "ASC");
goto cqZ_c;
DhUww:
$this->db->join("master_jurusan j", "j.id_jurusan=k.jurusan_id", "left");
goto qlmXJ;
R6aNC:
return $this->db->get()->row();
goto dtOFu;
a84vo:
$this->db->where("k.id_tp", $id_tp);
goto nXOxq;
DxQOx:
$this->db->where("k.id_smt", $id_smt);
goto i2lW0;
i2lW0:
XS4zI:
goto R6aNC;
W2dqR:
$this->db->join("master_guru g", "g.id_guru=f.id_guru", "left");
goto ChJ1U;
nXOxq:
p8Vsu:
goto ZcP17;
ZcP17:
if (!($id_smt != null)) {
goto XS4zI;
}
goto DxQOx;
dtOFu:
}
public function getKelasByNama($nama_kelas, $id_tp = null, $id_smt = null)
{
goto LRnS3;
LRnS3:
$this->db->select("*");
goto IjxSm;
IjxSm:
$this->db->from("master_kelas k");
goto bD_LH;
QaBf2:
return $this->db->get()->row();
goto i5VeV;
aNvIK:
QGykp:
goto Ov0hZ;
jPjSM:
ga1sj:
goto QaBf2;
eV1_p:
$this->db->join("level_kelas l", "l.id_level=k.level_id", "left");
goto B4vOQ;
Ov0hZ:
if (!($id_smt != null)) {
goto ga1sj;
}
goto tBu1b;
bD_LH:
$this->db->join("master_jurusan j", "j.id_jurusan=k.jurusan_id", "left");
goto eV1_p;
fBe9I:
$this->db->order_by("nama_kelas", "ASC");
goto VYN2L;
VYN2L:
$this->db->where("k.nama_kelas", $nama_kelas);
goto AjgZv;
U9n1i:
$this->db->where("k.id_tp", $id_tp);
goto aNvIK;
AjgZv:
if (!($id_tp != null)) {
goto QGykp;
}
goto U9n1i;
XvCgU:
$this->db->join("master_guru g", "g.id_guru=f.id_guru", "left");
goto nPPJ_;
tBu1b:
$this->db->where("k.id_smt", $id_smt);
goto jPjSM;
B4vOQ:
$this->db->join("jabatan_guru f", "f.id_kelas=k.id_kelas", "left");
goto XvCgU;
nPPJ_:
$this->db->join("master_siswa si", "si.id_siswa=k.siswa_id", "left");
goto fBe9I;
i5VeV:
}
public function getNamaKelasByNama($id_tp, $id_smt)
{
goto AHGw0;
Lzs_A:
$ret = [];
goto sWj4a;
sWj4a:
if (!$result) {
goto RvccN;
}
goto OHiyj;
otu2S:
$this->db->from("master_kelas");
goto Dgvrk;
BUivL:
return $ret;
goto wzPhs;
FNqoi:
$result = $this->db->get()->result();
goto Lzs_A;
Dgvrk:
$this->db->where("id_tp", $id_tp);
goto DLdLU;
OHiyj:
foreach ($result as $row) {
$ret[$row->nama_kelas] = $row->id_kelas;
Zx_iU:
}
goto cY2eG;
cY2eG:
hdaZF:
goto Lqieb;
AHGw0:
$this->db->select("id_kelas, nama_kelas");
goto otu2S;
Lqieb:
RvccN:
goto BUivL;
DLdLU:
$this->db->where("id_smt", $id_smt);
goto FNqoi;
wzPhs:
}
public function dummy()
{
$data = ["id_kelas" => '', "nama_kelas" => '', "kode_kelas" => '', "jurusan_id" => '', "level_id" => '', "guru_id" => '', "siswa_id" => '', "jumlah_siswa" => serialize([])];
return $data;
}
public function dummyStruktur()
{
$data = array("id_kelas" => '', "kepsek" => '', "waka" => '', "wali" => '', "ketua" => '', "wakil_ketua" => '', "sekretaris_1" => '', "sekretaris_2" => '', "bendahara_1" => '', "bendahara_2" => '', "sie_ekstrakurikuler" => '', "sie_upacara" => '', "sie_olahraga" => '', "sie_keagamaan" => '', "sie_keamanan" => '', "sie_ketertiban" => '', "sie_kebersihan" => '', "sie_keindahan" => '', "sie_kesehatan" => '', "sie_kekeluargaan" => '', "sie_humas" => '');
return $data;
}
public function destroy($id)
{
$this->db->where("id_kelas", $id);
$this->db->delete("master_kelas");
}
public function get_jurusan()
{
goto OpFrn;
z6wpF:
YoEYJ:
goto I609l;
N2rLL:
$ret[''] = "Pilih Jurusan :";
goto s4UAc;
I609l:
return $ret;
goto ttWYt;
s4UAc:
if (!$result) {
goto YoEYJ;
}
goto TBjwz;
OpFrn:
$result = $this->db->get("master_jurusan")->result();
goto N2rLL;
T_NVv:
AnTA5:
goto z6wpF;
TBjwz:
foreach ($result as $key => $row) {
$ret[$row->id_jurusan] = $row->nama_jurusan;
w3S1n:
}
goto T_NVv;
ttWYt:
}
public function getJurusanById($id)
{
goto NxvpX;
QLMPd:
return $result;
goto uu2CJ;
vmqlt:
$result = $this->db->get("master_jurusan")->row();
goto QLMPd;
NxvpX:
$this->db->where("id_jurusan", $id);
goto vmqlt;
uu2CJ:
}
public function get_level()
{
goto VRQqE;
Cbn2M:
$ret[''] = "Pilih Level :";
goto oQIGt;
w0CMP:
bVgVC:
goto SXTN_;
nll8d:
foreach ($result as $key => $row) {
$ret[$row->id_level] = $row->level;
oM8pa:
}
goto iFe5H;
VRQqE:
$result = $this->db->get("level_kelas")->result();
goto Cbn2M;
SXTN_:
return $ret;
goto UooWX;
oQIGt:
if (!$result) {
goto bVgVC;
}
goto nll8d;
iFe5H:
AWvPw:
goto w0CMP;
UooWX:
}
public function getLevel($jenjang)
{
goto mn6EZ;
xRJTn:
jkrMx:
goto eE9_J;
qstm9:
NdGe1:
goto dke3H;
ckNfC:
if ($jenjang == "3") {
goto jkrMx;
}
goto q44__;
OJmaL:
bOqD1:
goto hMeWB;
dke3H:
return $levels;
goto QMQJk;
hMeWB:
$levels = ['' => "Pilih Level", "1" => "1", "2" => "2", "3" => "3", "4" => "4", "5" => "5", "6" => "6"];
goto D895P;
eE9_J:
$levels = ['' => "Pilih Level", "10" => "10", "11" => "11", "12" => "12"];
goto qstm9;
mn6EZ:
$levels = [];
goto euj2B;
NebNM:
zCUKn:
goto KxVNO;
KxVNO:
$levels = ['' => "Pilih Level", "7" => "7", "8" => "8", "9" => "9"];
goto RrrOy;
D895P:
goto NdGe1;
goto NebNM;
euj2B:
if ($jenjang == "1") {
goto bOqD1;
}
goto KQ5Ka;
KQ5Ka:
if ($jenjang == "2") {
goto zCUKn;
}
goto ckNfC;
q44__:
goto NdGe1;
goto OJmaL;
RrrOy:
goto NdGe1;
goto xRJTn;
QMQJk:
}
public function get_guru()
{
goto lup2b;
vLIJz:
X4Vyw:
goto Hh4x0;
Hh4x0:
return $ret;
goto K2moJ;
cXm5w:
foreach ($result as $key => $row) {
$ret[$row->id_guru] = $row->nama_guru;
yp02L:
}
goto MA09A;
YLtrq:
$ret[''] = "Pilih Guru :";
goto QhLlg;
lup2b:
$result = $this->db->get("master_guru")->result();
goto YLtrq;
QhLlg:
if (!$result) {
goto X4Vyw;
}
goto cXm5w;
MA09A:
T5EJo:
goto vLIJz;
K2moJ:
}
public function getWaliKelas($tp, $smt)
{
goto Sb84H;
gteJe:
$this->db->join("master_guru b", "b.id_guru=a.id_guru", "left");
goto JllJw;
LyQK9:
if (!$result) {
goto k1qSc;
}
goto Ivqxg;
J30iQ:
$this->db->from("jabatan_guru a");
goto gteJe;
Ivqxg:
foreach ($result as $key => $row) {
$ret[$row->id_guru] = $row->nama_guru;
VK8AL:
}
goto Das6s;
wvkLo:
$ret[''] = "Pilih Guru :";
goto LyQK9;
H7GKS:
$result = $this->db->get()->result();
goto wvkLo;
Hb826:
k1qSc:
goto w65yv;
w65yv:
return $ret;
goto ELBYO;
Sb84H:
$this->db->select("a.id_guru, b.nama_guru");
goto J30iQ;
JllJw:
$this->db->where("id_jabatan", "4")->where("id_tp", $tp)->where("id_smt", $smt);
goto H7GKS;
Das6s:
i_UnY:
goto Hb826;
ELBYO:
}
public function getKelasEkskul($kelas, $tp, $smt)
{
goto VKwGW;
Mx_iO:
$this->db->from("kelas_ekstra");
goto qMy05;
qMy05:
$this->db->where("id_kelas", $kelas);
goto rv_hE;
wWQVX:
$this->db->where("id_smt", $smt);
goto j3VNa;
j3VNa:
$result = $this->db->get()->result();
goto EZNog;
rv_hE:
$this->db->where("id_tp", $tp);
goto wWQVX;
EZNog:
return $result;
goto RIBFO;
VKwGW:
$this->db->select("*");
goto Mx_iO;
RIBFO:
}
public function getEkskulById($id)
{
goto R8Nj2;
kDmAf:
$this->db->where("id_ekstra", $id);
goto iUkSy;
R8Nj2:
$this->db->select("*");
goto kUF50;
iUkSy:
$result = $this->db->get()->row();
goto nMkva;
nMkva:
return $result;
goto X5zNA;
kUF50:
$this->db->from("master_ekstra");
goto kDmAf;
X5zNA:
}
public function getAllSiswa($tp, $smt)
{
goto fqFRw;
lKuat:
$this->db->from("master_siswa a");
goto BzWak;
fqFRw:
$this->db->select("a.id_siswa, a.nama, b.id_kelas");
goto lKuat;
IcgqV:
$this->db->join("buku_induk c", "c.id_siswa=a.id_siswa AND c.status=1");
goto QtQap;
ap_xv:
return $result;
goto tjhvG;
QtQap:
$this->db->order_by("a.nama", "ASC");
goto T_69Q;
T_69Q:
$result = $this->db->get()->result();
goto ap_xv;
BzWak:
$this->db->join("kelas_siswa b", "b.id_siswa=a.id_siswa AND b.id_tp=" . $tp . " AND b.id_smt=" . $smt, "left");
goto IcgqV;
tjhvG:
}
public function get_siswa_kelas($id, $tp, $smt)
{
goto rY6oQ;
rY6oQ:
$this->db->select("a.id_siswa, a.id_kelas, b.nis, b.nama");
goto U9WNB;
KvBrA:
$this->db->where("a.id_tp", $tp);
goto xQRLr;
xQRLr:
$this->db->where("a.id_smt", $smt);
goto YnI0O;
YT_t1:
$this->db->join("buku_induk i", "i.id_siswa=a.id_siswa AND i.status=1");
goto ikb0c;
XND2h:
return $result;
goto H6X81;
U9WNB:
$this->db->from("kelas_siswa a");
goto WD0Nd;
YnI0O:
$this->db->order_by("b.nama", "ASC");
goto PfRx5;
ikb0c:
$this->db->where_in("a.id_kelas", $id);
goto KvBrA;
PfRx5:
$result = $this->db->get()->result();
goto XND2h;
WD0Nd:
$this->db->join("master_siswa b", "b.id_siswa=a.id_siswa");
goto YT_t1;
H6X81:
}
public function get_status_siswa_kelas($id, $tp, $smt)
{
goto DTMKO;
KfGL2:
$this->db->where("a.id_tp", $tp);
goto dXPuk;
JLkkr:
$ret = [];
goto fnNEv;
l37MJ:
K8Psy:
goto sR1dG;
oEnvP:
$result = $this->db->get()->result();
goto JLkkr;
DRNIJ:
$this->db->from("kelas_siswa a");
goto kLujL;
dXPuk:
$this->db->where("a.id_smt", $smt);
goto oEnvP;
H1_yL:
foreach ($result as $key => $row) {
$ret[$row->id_siswa] = $row;
r3Cdk:
}
goto B4DF6;
DTMKO:
$this->db->select("a.id_siswa, a.id_kelas");
goto DRNIJ;
fnNEv:
if (!$result) {
goto K8Psy;
}
goto H1_yL;
kLujL:
$this->db->where_in("a.id_kelas", $id);
goto KfGL2;
B4DF6:
Xnm11:
goto l37MJ;
sR1dG:
return $ret;
goto BAIdL;
BAIdL:
}
public function getJadwalKbm($tp, $smt, $kelas)
{
goto W0XqN;
MVqos:
$this->db->where("id_tp", $tp);
goto bl1Ny;
WX1WR:
$result = $this->db->get()->row();
goto vFPV9;
vFPV9:
return $result;
goto xPy04;
bBGTH:
$this->db->where("id_kelas", $kelas);
goto WX1WR;
bl1Ny:
$this->db->where("id_smt", $smt);
goto bBGTH;
y5KTv:
$this->db->from("kelas_jadwal_kbm");
goto MVqos;
W0XqN:
$this->db->select("*");
goto y5KTv;
xPy04:
}
public function getJadwalKbmByArrKelas($tp, $smt, $arr_kelas)
{
goto V1x6j;
t0xFy:
return $ret;
goto FKB5Y;
zw7R4:
$this->db->where_in("id_kelas", $arr_kelas);
goto C9GQG;
PAqWC:
foreach ($result as $key => $row) {
goto LBBeh;
W72by:
edC1W:
goto gwDRY;
uCVuj:
KtmJb:
goto sf5eb;
bylfD:
$ret[$row->id_kelas] = [];
goto XmaMU;
sf5eb:
VPnOC:
goto WauBq;
XmaMU:
array_push($ret[$row->id_kelas], $row);
goto ZluA8;
LBBeh:
if (isset($ret[$row->id_kelas])) {
goto edC1W;
}
goto bylfD;
gwDRY:
array_push($ret[$row->id_kelas], $row);
goto uCVuj;
ZluA8:
goto KtmJb;
goto W72by;
WauBq:
}
goto XW5kx;
XW5kx:
pxqNk:
goto jVofE;
C9GQG:
$result = $this->db->get()->result();
goto y6Shs;
V1x6j:
$this->db->select("*");
goto zMufz;
AP92S:
if (!$result) {
goto wTqsx;
}
goto PAqWC;
zMufz:
$this->db->from("kelas_jadwal_kbm");
goto y1u0A;
M1PQ6:
$this->db->where("id_smt", $smt);
goto zw7R4;
jVofE:
wTqsx:
goto t0xFy;
y6Shs:
$ret = [];
goto AP92S;
y1u0A:
$this->db->where("id_tp", $tp);
goto M1PQ6;
FKB5Y:
}
public function getJadwalMapel($tp, $smt)
{
goto CnsCW;
CnsCW:
$this->db->select("*");
goto ppP9N;
ppP9N:
$this->db->from("kelas_jadwal_mapel a");
goto woNnz;
jMb4A:
$ret = [];
goto ZkJjC;
mVVH5:
e8CYY:
goto CVCXw;
c24n8:
vhEIg:
goto mVVH5;
vSGmf:
foreach ($result as $key => $row) {
goto LixlC;
MpeZ7:
taf3Z:
goto fDvX3;
yoKuv:
if (isset($ret[$row->id_mapel][$row->id_kelas])) {
goto taf3Z;
}
goto XmMMh;
A97yK:
gI9k1:
goto szbFU;
fDvX3:
array_push($ret[$row->id_mapel][$row->id_kelas], $row);
goto nzh00;
szbFU:
EY7dP:
goto f3vX_;
ek0A2:
array_push($ret[$row->id_mapel][$row->id_kelas], $row);
goto dEnWQ;
LixlC:
if (!($row->id_mapel != '')) {
goto gI9k1;
}
goto yoKuv;
XmMMh:
$ret[$row->id_mapel][$row->id_kelas] = [];
goto ek0A2;
nzh00:
U_EKk:
goto A97yK;
dEnWQ:
goto U_EKk;
goto MpeZ7;
f3vX_:
}
goto c24n8;
BGMJU:
$result = $this->db->get()->result();
goto jMb4A;
qe1oO:
$this->db->where("id_smt", $smt);
goto BGMJU;
ZkJjC:
if (!$result) {
goto e8CYY;
}
goto vSGmf;
CVCXw:
return $ret;
goto liX0u;
RU4RE:
$this->db->where("id_tp", $tp);
goto qe1oO;
woNnz:
$this->db->join("master_mapel b", "a.id_mapel=b.id_mapel", "left");
goto RU4RE;
liX0u:
}
public function getJadwalMapelGroupHari($tp, $smt)
{
goto mCfl3;
HfUnw:
$this->db->group_by("id_hari");
goto A11Rj;
mCfl3:
$this->db->select("id_tp, id_smt, MAX(id_hari) as id_hari, MAX(jam_ke) as jam_ke");
goto G2AFw;
A11Rj:
$result = $this->db->get()->result();
goto f9UOv;
oo05M:
$this->db->where("id_smt", $smt, FALSE);
goto HfUnw;
f9UOv:
return $result;
goto d0XTg;
BNoRL:
$this->db->where("id_tp", $tp, FALSE);
goto oo05M;
G2AFw:
$this->db->from("kelas_jadwal_mapel");
goto BNoRL;
d0XTg:
}
public function getJadwalMapelGroupJam($tp, $smt, $kelas)
{
goto znrP5;
znrP5:
$this->db->select("id_tp, id_smt, MAX(id_hari) as id_hari, id_kelas, MAX(jam_ke) as jam_ke");
goto KaS_d;
biwyD:
$result = $this->db->get()->result();
goto N4NNL;
KaS_d:
$this->db->from("kelas_jadwal_mapel");
goto mIrUH;
mIrUH:
$this->db->where("id_tp", $tp, FALSE);
goto TD2Nl;
N4NNL:
return $result;
goto yrDGm;
wLjcw:
$this->db->group_by("jam_ke");
goto biwyD;
FRvr1:
$this->db->where("id_kelas", $kelas, FALSE);
goto wLjcw;
TD2Nl:
$this->db->where("id_smt", $smt, FALSE);
goto FRvr1;
yrDGm:
}
public function getJadwalMapelByJam($hari)
{
goto z4LmP;
xN2Ju:
$this->db->from("kelas_jadwal_mapel a");
goto dGweB;
lBLb_:
$result = $this->db->get()->result();
goto tMPm_;
nVc8v:
$this->db->where("id_hari", $hari, FALSE);
goto lBLb_;
dGweB:
$this->db->join("master_mapel b", "a.id_mapel=b.id_mapel", "left");
goto nVc8v;
tMPm_:
return $result;
goto JC2c7;
z4LmP:
$this->db->select("*");
goto xN2Ju;
JC2c7:
}
public function getJadwalMapelByMapel($kelas, $mapel = null, $tp, $smt)
{
goto jvrXX;
yy2O1:
$this->db->from("kelas_jadwal_mapel a");
goto I1hBw;
I_7g_:
if (!($mapel != null)) {
goto NbpLA;
}
goto cOxKV;
I1hBw:
$this->db->join("master_mapel b", "a.id_mapel=b.id_mapel", "left");
goto lJfFS;
WU_46:
$this->db->where_in("a.id_kelas", $kelas);
goto llulA;
lKNMy:
$this->db->where("a.id_smt", $smt, FALSE);
goto I_7g_;
jvrXX:
$this->db->select("*");
goto yy2O1;
lJfFS:
$this->db->where("a.id_tp", $tp, FALSE);
goto lKNMy;
VIaWq:
NbpLA:
goto WU_46;
llulA:
$result = $this->db->get()->result();
goto n4R9n;
cOxKV:
$this->db->where("a.id_mapel", $mapel, FALSE);
goto VIaWq;
n4R9n:
return $result;
goto tm1_k;
tm1_k:
}
public function getJadwalTerisi($table, $kelas, $mapel, $tp, $smt)
{
goto Weo17;
YmlmS:
return $result;
goto wFMHh;
mI13b:
$this->db->from($table);
goto G9UxK;
xWr6k:
$this->db->where_in("id_kelas", $kelas);
goto T3aGB;
gtF63:
$this->db->where("id_mapel", $mapel, FALSE);
goto xWr6k;
Rlkhu:
$this->db->where("id_smt", $smt, FALSE);
goto gtF63;
Weo17:
$this->db->select("*");
goto mI13b;
T3aGB:
$result = $this->db->get()->result();
goto YmlmS;
G9UxK:
$this->db->where("id_tp", $tp, FALSE);
goto Rlkhu;
wFMHh:
}
public function getJadwalMapelByHari($tp, $smt, $jam, $kelas)
{
goto XVZdv;
TpuH5:
$this->db->where("id_smt", $smt, FALSE);
goto J4O__;
URM1S:
$this->db->where("id_tp", $tp, FALSE);
goto TpuH5;
Vmvms:
$this->db->join("master_mapel b", "a.id_mapel=b.id_mapel", "left");
goto OAuyJ;
J4O__:
$this->db->where("id_kelas", $kelas, FALSE);
goto qwUMH;
qwUMH:
$result = $this->db->get()->result();
goto iEfFL;
XVZdv:
$this->db->select("*");
goto JFFoR;
JFFoR:
$this->db->from("kelas_jadwal_mapel a");
goto Vmvms;
OAuyJ:
$this->db->where("jam_ke", $jam, FALSE);
goto URM1S;
iEfFL:
return $result;
goto xCRY_;
xCRY_:
}
public function getDummyJadwalMapel($tp, $smt, $jam, $kelas)
{
goto Xhyl8;
Xhyl8:
$inputData = [];
goto AMcb2;
UKvrR:
$i++;
goto CpirT;
CzuQ8:
CMDIj:
goto LM5_Z;
Oonx7:
array_push($inputData, $data);
goto CQjUp;
pnz1h:
if (!($i < 7)) {
goto CMDIj;
}
goto elA_J;
gc6rR:
GKKPp:
goto pnz1h;
CQjUp:
pJy1v:
goto UKvrR;
CpirT:
goto GKKPp;
goto CzuQ8;
LM5_Z:
return $inputData;
goto EOLQg;
elA_J:
$data = json_decode(json_encode(["id_tp" => $tp, "id_smt" => $smt, "id_hari" => $i, "jam_ke" => $jam, "id_kelas" => $kelas, "id_mapel" => "0", "nama_mapel" => '', "kode" => '']));
goto Oonx7;
AMcb2:
$i = 1;
goto gc6rR;
EOLQg:
}
public function getDummyMateri()
{
$data = array("id_materi" => '', "kode_materi" => '', "id_guru" => '', "id_mapel" => '', "id_jadwal" => '', "materi_kelas" => serialize([]), "kelas_guru" => serialize([]), "judul_materi" => '', "isi_materi" => '', "file" => '', "link_file" => '', "tgl_mulai" => '', "created_on" => '', "updated_on" => '');
return $data;
}
public function getTableMateriKelas($id_guru = null)
{
goto d2VTi;
Nx0M9:
$this->datatables->from("kelas_materi a");
goto TB6OU;
TB6OU:
$this->datatables->join("master_guru b", "a.id_guru=b.id_guru");
goto LUS4o;
LUS4o:
$this->datatables->join("jabatan_guru c", "a.id_guru=c.id_guru");
goto yVZmU;
yVZmU:
$this->datatables->join("kelas_jadwal_mapel d", "a.id_mapel=d.id_mapel");
goto ZigRt;
ZigRt:
return $this->datatables->generate();
goto KQYTq;
d2VTi:
$this->datatables->select("*");
goto Nx0M9;
KQYTq:
}
public function getMateriKelas($id_guru, $tp, $smt)
{
goto ithtX;
BHtE0:
$this->db->join("master_guru b", "a.id_guru=b.id_guru");
goto WHmha;
ithtX:
$this->db->select("a.id_materi, a.kode_materi, a.kode_mapel, a.judul_materi, a.materi_kelas, f.nama_smt, e.tahun," . " a.id_mapel, a.created_on, a.updated_on, a.file, a.status, a.id_tp, a.id_smt, b.nama_guru, d.nama_mapel, d.kode");
goto KIzIj;
ayeXR:
$result = $this->db->get()->result();
goto HZnHv;
TyRRb:
$this->db->where("a.id_tp", $tp);
goto Wbd2e;
UcUhZ:
$this->db->order_by("a.created_on", "DESC");
goto ayeXR;
KIzIj:
$this->db->from("kelas_materi a");
goto BHtE0;
HZnHv:
return $result;
goto n9ymq;
OLxHi:
$this->db->where("a.id_guru", $id_guru);
goto TyRRb;
FyG3j:
$this->db->join("master_smt f", "a.id_smt=f.id_smt");
goto OLxHi;
WHmha:
$this->db->join("master_mapel d", "a.id_mapel=d.id_mapel", "left");
goto jkLTr;
Wbd2e:
$this->db->where("a.id_smt", $smt);
goto UcUhZ;
jkLTr:
$this->db->join("master_tp e", "a.id_tp=e.id_tp");
goto FyG3j;
n9ymq:
}
public function getAllMateriByKelas($tp, $smt)
{
goto d0hhV;
SUXXu:
$this->db->order_by("a.created_on", "DESC");
goto rm7v4;
rm7v4:
$result = $this->db->get()->result();
goto sgUzK;
xEuKn:
return $ret;
goto PdERn;
Nkjyy:
R37ax:
goto n0DDv;
YLKPq:
$this->db->where("a.id_smt", $smt);
goto SUXXu;
n0DDv:
Azx7C:
goto xEuKn;
voFYR:
$this->db->where("a.id_tp", $tp);
goto YLKPq;
IJsOA:
$this->db->join("master_guru b", "a.id_guru=b.id_guru");
goto rVH4t;
uQfyt:
$this->db->from("kelas_materi a");
goto IJsOA;
d0hhV:
$this->db->select("a.jenis, a.id_mapel, a.id_materi, a.kode_materi");
goto uQfyt;
o0k7r:
foreach ($result as $key => $row) {
$ret[$row->id_mapel][$row->jenis][$row->id_materi] = $row->kode_materi;
gS1Af:
}
goto Nkjyy;
SuGqC:
$this->db->where("a.status", "1");
goto voFYR;
fIRuJ:
if (!$result) {
goto Azx7C;
}
goto o0k7r;
rVH4t:
$this->db->join("master_mapel c", "a.id_mapel=c.id_mapel", "left");
goto SuGqC;
sgUzK:
$ret = [];
goto fIRuJ;
PdERn:
}
public function getAllJadwalMateriByKelas($tp, $smt)
{
goto e1gqN;
b4zJc:
$this->db->order_by("c.created_on", "DESC");
goto IgeES;
wrt4W:
foreach ($result as $key => $row) {
$ret[$row->jenis][$row->id_kjm] = $row;
xGnQI:
}
goto DEiJS;
e1gqN:
$this->db->select("a.jenis, a.id_materi, a.id_tp, a.id_smt, a.id_mapel, a.id_kjm, a.id_kelas, a.jadwal_materi," . " c.kode_materi, c.judul_materi, c.created_on, c.updated_on, c.file, c.status," . " b.nama_guru, d.nama_mapel, d.kode");
goto Q5JF1;
CPxSn:
$ret = [];
goto KQqBT;
KQqBT:
if (!$result) {
goto BLgpR;
}
goto wrt4W;
PY6HO:
return $ret;
goto ca_Hv;
gpGMs:
$this->db->where("a.id_tp", $tp);
goto mbSbH;
mbSbH:
$this->db->where("a.id_smt", $smt);
goto b4zJc;
IgeES:
$result = $this->db->get()->result();
goto CPxSn;
LHp0x:
$this->db->join("kelas_materi c", "a.id_materi=c.id_materi", "left");
goto ln7EF;
dVNfR:
BLgpR:
goto PY6HO;
fdZYT:
$this->db->join("master_mapel d", "a.id_mapel=d.id_mapel", "left");
goto gpGMs;
ln7EF:
$this->db->join("master_guru b", "c.id_guru=b.id_guru");
goto fdZYT;
Q5JF1:
$this->db->from("kelas_jadwal_materi a");
goto LHp0x;
DEiJS:
G0uTG:
goto dVNfR;
ca_Hv:
}
public function getAllMateriKelas($id_guru, $jenis)
{
goto vzXTx;
Esq2G:
$result = $this->db->get()->result();
goto So6bQ;
So6bQ:
return $result;
goto GmdUu;
wrTcH:
$this->db->join("master_mapel d", "a.id_mapel=d.id_mapel OR a.kode_mapel=d.kode", "left");
goto QcyWw;
F3O2U:
$this->db->where("a.id_guru", $id_guru);
goto znSwf;
q1rlk:
$this->db->order_by("a.created_on", "DESC");
goto Esq2G;
znSwf:
ne4jz:
goto q1rlk;
kbrNV:
$this->db->where("a.jenis", $jenis);
goto A3Sp1;
QcyWw:
$this->db->join("master_tp e", "a.id_tp=e.id_tp", "left");
goto I4sji;
C8LW_:
$this->db->from("kelas_materi a");
goto Quops;
vzXTx:
$this->db->select("a.id_materi, a.kode_materi, a.kode_mapel, a.judul_materi, a.materi_kelas, f.nama_smt, e.tahun, f.smt," . " a.id_mapel, a.created_on, a.updated_on, a.file, a.status, a.id_tp, a.id_smt, b.nama_guru, d.nama_mapel, d.kode");
goto C8LW_;
Quops:
$this->db->join("master_guru b", "a.id_guru=b.id_guru", "left");
goto wrTcH;
A3Sp1:
if (!($id_guru != "0")) {
goto ne4jz;
}
goto F3O2U;
I4sji:
$this->db->join("master_smt f", "a.id_smt=f.id_smt", "left");
goto kbrNV;
GmdUu:
}
public function getMateriKelasById($id_materi, $jenis)
{
goto YYxlL;
cVURA:
$result = $this->db->get()->row();
goto PPX7e;
a_Vn6:
$this->db->where("a.id_materi", $id_materi);
goto CtXX4;
g5I6E:
$this->db->from("kelas_materi a");
goto P5KHF;
YYxlL:
$this->db->select("a.*, b.nama_guru, b.foto, d.id_mapel, d.nama_mapel, c.mapel_kelas as kelas_guru");
goto g5I6E;
pnZJ5:
$this->db->join("jabatan_guru c", "a.id_guru=c.id_guru", "left");
goto HlZMk;
PPX7e:
return $result;
goto z0RIE;
P5KHF:
$this->db->join("master_guru b", "a.id_guru=b.id_guru", "left");
goto pnZJ5;
CtXX4:
$this->db->where("a.jenis", $jenis);
goto cVURA;
HlZMk:
$this->db->join("master_mapel d", "a.id_mapel=d.id_mapel", "left");
goto a_Vn6;
z0RIE:
}
public function getMateriKelasSiswa($id_kjm, $jenis)
{
goto bPB4y;
WHu6V:
$this->db->join("jabatan_guru d", "b.id_guru=d.id_guru");
goto IoRYN;
IoRYN:
$this->db->join("master_mapel e", "b.id_mapel=e.id_mapel");
goto cr1ac;
cr1ac:
$this->db->where("a.jenis", $jenis);
goto phHbn;
Y2Olr:
$this->db->from("kelas_jadwal_materi a");
goto nyIUN;
nyIUN:
$this->db->join("kelas_materi b", "a.id_materi=b.id_materi");
goto cyqmI;
ClD8f:
return $result;
goto tDhm4;
Z7GvG:
$result = $this->db->get()->row();
goto ClD8f;
cyqmI:
$this->db->join("master_guru c", "b.id_guru=c.id_guru");
goto WHu6V;
phHbn:
$this->db->where("a.id_kjm", $id_kjm);
goto Z7GvG;
bPB4y:
$this->db->select("a.id_kjm, a.id_materi, a.jadwal_materi, b.*, c.nama_guru, c.foto, e.id_mapel, e.nama_mapel, d.mapel_kelas as kelas_guru");
goto Y2Olr;
tDhm4:
}
public function getGuruMapelKelas($id_guru, $tp, $smt)
{
goto Igo32;
NwhLc:
$result = $this->db->get()->row();
goto oUJZD;
oUJZD:
return $result;
goto TBJoe;
RBufj:
$this->db->where("a.id_guru", $id_guru);
goto NwhLc;
hifuK:
$this->db->from("master_guru a");
goto MmuhB;
Igo32:
$this->db->select("a.id_guru, a.nama_guru, a.kode_guru, b.mapel_kelas, b.ekstra_kelas, d.nama_kelas");
goto hifuK;
MmuhB:
$this->db->join("jabatan_guru b", "a.id_guru=b.id_guru AND b.id_tp=" . $tp . " AND b.id_smt=" . $smt . '', "left");
goto LYKmj;
qx35a:
$this->db->join("master_kelas d", "b.id_kelas=d.id_kelas AND d.id_tp=" . $tp . " AND d.id_smt=" . $smt . '', "left");
goto RBufj;
LYKmj:
$this->db->join("level_guru c", "b.id_jabatan=c.id_level", "left");
goto qx35a;
TBJoe:
}
public function getMapelGuruKelas($tp, $smt)
{
goto hwpL1;
DTNOB:
$result = $this->db->get()->result();
goto uhEHW;
wlTAk:
$this->db->from("master_guru a");
goto EStCu;
uhEHW:
return $result;
goto hlA0T;
GugUY:
$this->db->join("level_guru c", "b.id_jabatan=c.id_level", "left");
goto rWKf3;
rWKf3:
$this->db->join("master_kelas d", "b.id_kelas=d.id_kelas AND d.id_tp=" . $tp . " AND d.id_smt=" . $smt . '', "left");
goto DTNOB;
EStCu:
$this->db->join("jabatan_guru b", "a.id_guru=b.id_guru AND b.id_tp=" . $tp . " AND b.id_smt=" . $smt . '', "left");
goto GugUY;
hwpL1:
$this->db->select("a.id_guru, a.nama_guru, a.kode_guru, b.mapel_kelas, b.ekstra_kelas, d.nama_kelas");
goto wlTAk;
hlA0T:
}
public function getListGuruMapelKelas($tp, $smt)
{
goto ULpq4;
ULpq4:
$this->db->select("a.id_guru, a.nama_guru, a.kode_guru, b.mapel_kelas, b.ekstra_kelas, d.nama_kelas");
goto fm5bm;
FO0M4:
return $rest;
goto zPJz5;
DY2tX:
$rest = [];
goto q1RY6;
fm5bm:
$this->db->from("master_guru a");
goto SKfKq;
q1RY6:
foreach ($result as $guru) {
$rest[$guru->id_guru] = $guru;
i2FDo:
}
goto L4INH;
L4INH:
S201D:
goto FO0M4;
SKfKq:
$this->db->join("jabatan_guru b", "a.id_guru=b.id_guru AND b.id_tp=" . $tp . " AND b.id_smt=" . $smt . '', "left");
goto UXWQU;
PeGsb:
$result = $this->db->get()->result();
goto DY2tX;
ko4sV:
$this->db->join("master_kelas d", "b.id_kelas=d.id_kelas AND d.id_tp=" . $tp . " AND d.id_smt=" . $smt . '', "left");
goto PeGsb;
UXWQU:
$this->db->join("level_guru c", "b.id_jabatan=c.id_level", "left");
goto ko4sV;
zPJz5:
}
public function getIdKelas($tp, $smt)
{
goto KH_Rq;
drm8L:
$ret = [];
goto zocRg;
KH_Rq:
$this->db->select("id_kelas");
goto Duxbh;
L6LsC:
foreach ($result as $key => $row) {
array_push($ret, $row->id_kelas);
H3r9x:
}
goto Wn_BU;
Wn_BU:
SHxRI:
goto SjjeW;
zPI53:
$result = $this->db->get("master_kelas")->result();
goto drm8L;
vSmZD:
return $ret;
goto XWtCS;
Duxbh:
$this->db->where("id_tp", $tp);
goto FXixl;
FXixl:
$this->db->where("id_smt", $smt);
goto zPI53;
SjjeW:
oYQhH:
goto vSmZD;
zocRg:
if (!$result) {
goto oYQhH;
}
goto L6LsC;
XWtCS:
}
public function getNamaKelasById($arr_id)
{
goto CIaYh;
rt1fM:
$result = $this->db->get("master_kelas")->result();
goto tPJFD;
qU0xm:
return $ret;
goto ZcgRv;
tIF6e:
foreach ($result as $key => $row) {
$ret[$row->id_kelas] = $row->nama_kelas;
DilYC:
}
goto vC_SM;
vC_SM:
AnmPc:
goto eCT2T;
P9T4Y:
$this->db->where_in("id_kelas", $arr_id);
goto rt1fM;
eCT2T:
zr3aF:
goto qU0xm;
tPJFD:
$ret = null;
goto VSXxC;
VSXxC:
if (!$result) {
goto zr3aF;
}
goto tIF6e;
CIaYh:
$this->db->select("id_kelas, nama_kelas");
goto P9T4Y;
ZcgRv:
}
public function getNamaKelasByKode($arr_kode)
{
goto IEgxQ;
tKAP7:
UHJfa:
goto qaQDi;
CXKJd:
if (!$result) {
goto UHJfa;
}
goto XTmqA;
BIlr_:
$ret = null;
goto CXKJd;
OyKPW:
$this->db->where_in("kode_kelas", $arr_kode);
goto mkUTp;
qaQDi:
return $ret;
goto sKX1C;
mkUTp:
$result = $this->db->get("master_kelas")->result();
goto BIlr_;
XTmqA:
foreach ($result as $key => $row) {
$ret[$row->id_kelas] = $row->nama_kelas;
qKSno:
}
goto KMrwu;
IEgxQ:
$this->db->select("id_kelas, nama_kelas");
goto OyKPW;
KMrwu:
mo924:
goto tKAP7;
sKX1C:
}
public function getJadwalByMateri($id, $jenis, $tp, $smt)
{
goto sUigi;
VOflf:
if (!$result) {
goto STe86;
}
goto MAcKx;
uqUWr:
$this->db->where("id_materi", $id);
goto Mrlag;
aHEYu:
$result = $this->db->get("kelas_jadwal_materi")->result();
goto Sza2a;
sUigi:
$this->db->select("id_kjm, id_kelas, jadwal_materi, (SELECT COUNT(id_materi) FROM log_materi WHERE kelas_jadwal_materi.id_kjm=log_materi.id_materi) AS jml_siswa");
goto uqUWr;
Mrlag:
$this->db->where("jenis", $jenis);
goto w1QLu;
MAcKx:
foreach ($result as $key => $row) {
goto KGzDM;
bX37P:
array_push($ret[$row->id_kelas], $row);
goto ukrwQ;
krwCo:
WiS63:
goto SYI14;
HIfBH:
ttdKB:
goto bqG0T;
ukrwQ:
goto Wj6iV;
goto HIfBH;
KGzDM:
if (isset($ret[$row->id_kelas])) {
goto ttdKB;
}
goto RIDIb;
bqG0T:
array_push($ret[$row->id_kelas], $row);
goto zwhOI;
RIDIb:
$ret[$row->id_kelas] = [];
goto bX37P;
zwhOI:
Wj6iV:
goto krwCo;
SYI14:
}
goto YkKwy;
RLbnY:
return $ret;
goto ShygK;
hv_g0:
STe86:
goto RLbnY;
Sza2a:
$ret = [];
goto VOflf;
YkKwy:
Vz4DS:
goto hv_g0;
OZKkz:
$this->db->where("id_smt", $smt);
goto aHEYu;
w1QLu:
$this->db->where("id_tp", $tp);
goto OZKkz;
ShygK:
}
public function getKodeMateriMapel($id_tp, $id_smt, $id_mapel)
{
goto Wos2A;
i7dkK:
$this->db->join("kelas_jadwal_materi c", "a.id_materi=c.id_materi");
goto lDxKT;
lDxKT:
$this->db->join("master_guru d", "a.id_guru=d.id_guru");
goto tOJ6z;
EJK3M:
$this->db->where("a.id_smt", $id_smt);
goto z5W6o;
mthhu:
return $result;
goto BA3EZ;
e9pdZ:
$this->db->from("kelas_materi a");
goto y2fsb;
y2fsb:
$this->db->join("master_mapel b", "b.id_mapel=a.id_mapel", "left");
goto i7dkK;
A6NKD:
$this->db->where("a.id_tp", $id_tp);
goto EJK3M;
tOJ6z:
$this->db->where("a.id_mapel", $id_mapel);
goto A6NKD;
z5W6o:
$result = $this->db->get()->result();
goto mthhu;
Wos2A:
$this->db->select("a.id_mapel, a.id_materi, a.jenis, a.kode_materi, a.materi_kelas, a.id_guru, b.kode as kode_mapel, c.id_kjm, c.jadwal_materi, c.id_kelas, d.nama_guru");
goto e9pdZ;
BA3EZ:
}
public function getAllKodeMateri($id_tp, $id_smt, $id_guru = null)
{
goto nghUs;
zsYEV:
return $result;
goto j7U86;
yZSnE:
if (!($id_guru != null)) {
goto PA05K;
}
goto Hqne6;
vd8tM:
$result = $this->db->get()->result();
goto zsYEV;
EZHdF:
$this->db->join("kelas_jadwal_materi c", "a.id_materi=c.id_materi");
goto yZSnE;
EB_Y9:
PA05K:
goto Vd_SX;
txa1y:
$this->db->join("master_mapel b", "b.id_mapel=a.id_mapel", "left");
goto EZHdF;
PQUe1:
$this->db->from("kelas_materi a");
goto txa1y;
nghUs:
$this->db->select("a.id_mapel, a.id_materi, a.jenis, a.kode_materi, a.materi_kelas, a.id_guru, b.kode as kode_mapel, c.id_kjm, c.jadwal_materi");
goto PQUe1;
Vd_SX:
$this->db->where("a.id_tp", $id_tp);
goto iwa7x;
iwa7x:
$this->db->where("a.id_smt", $id_smt);
goto vd8tM;
Hqne6:
$this->db->where("a.id_guru", $id_guru);
goto EB_Y9;
j7U86:
}
public function getKelasSiswa($id_kelas, $id_tp, $id_smt)
{
goto zmCLA;
ca8uc:
return $this->db->get()->result();
goto MNqtc;
nap2r:
$this->db->where("a.id_tp", $id_tp);
goto Whvyz;
Whvyz:
$this->db->where("a.id_smt", $id_smt);
goto mczKM;
A5tUN:
$this->db->where("a.id_kelas", $id_kelas);
goto nap2r;
zmCLA:
$this->db->select("a.*, b.nama, b.nis, b.nisn, b.username, b.jenis_kelamin, c.nama_kelas, c.level_id");
goto Ojsuf;
Ojsuf:
$this->db->from("kelas_siswa a");
goto v5Lr4;
xVunV:
$this->db->join("master_kelas c", "a.id_kelas=c.id_kelas");
goto A5tUN;
v5Lr4:
$this->db->join("master_siswa b", "a.id_siswa=b.id_siswa");
goto xVunV;
mczKM:
$this->db->order_by("b.nama", "ASC");
goto ca8uc;
MNqtc:
}
public function getKelasSiswaDuaSmt($id_kelas, $id_tp, $id_smt)
{
goto AiEAV;
C29U6:
$this->db->where("a.id_tp", $id_tp);
goto AHHhk;
AHHhk:
$this->db->where("a.id_smt", $id_smt);
goto ChpEF;
ChpEF:
return $this->db->get()->result();
goto kgpTb;
XykFE:
$this->db->join("master_kelas c", "a.id_kelas=c.id_kelas", "left");
goto r8LB1;
AiEAV:
$this->db->select("a.*, b.nama, b.nis, b.nisn, b.username, c.nama_kelas, c.level_id");
goto EZbHf;
DHUhj:
$this->db->join("master_siswa b", "a.id_siswa=b.id_siswa", "left");
goto XykFE;
r8LB1:
$this->db->where("a.id_kelas", $id_kelas);
goto C29U6;
EZbHf:
$this->db->from("kelas_siswa a");
goto DHUhj;
kgpTb:
}
public function getStatusMateriSiswaByJadwal($id_siswa, $arr_id_kjm)
{
goto X_SVF;
xHoxG:
$this->db->from("log_materi");
goto Hb79m;
eO8ud:
return $ret;
goto hN0MZ;
Hb79m:
$this->db->where_in("id_materi", $arr_id_kjm);
goto NSqHI;
z7aJL:
$result = $this->db->get()->result();
goto gg9p0;
NSqHI:
$this->db->where("id_siswa", $id_siswa);
goto z7aJL;
Fdcwr:
Qj31N:
goto eO8ud;
gg9p0:
$ret = [];
goto ow9TW;
Y1vcM:
foreach ($result as $key => $row) {
$ret[$row->id_materi] = $row;
N1H5S:
}
goto j32iT;
X_SVF:
$this->db->select("*");
goto xHoxG;
j32iT:
SthuR:
goto Fdcwr;
ow9TW:
if (!$result) {
goto Qj31N;
}
goto Y1vcM;
hN0MZ:
}
public function getStatusMateriSiswa($id_kjm = null)
{
goto VOlRm;
HE_rz:
$ret = [];
goto fvVPp;
EokQA:
return $ret;
goto DaamC;
SYlbe:
$this->db->where("a.id_materi", $id_kjm);
goto f_8nG;
f_8nG:
NB1af:
goto LVLq1;
CkyVp:
if (!($id_kjm != null)) {
goto NB1af;
}
goto SYlbe;
VOlRm:
$this->db->select("a.*, b.jadwal_materi");
goto GZ3gV;
wFExg:
kdVbJ:
goto J8bX7;
TY974:
$this->db->join("kelas_jadwal_materi b", "b.id_kjm=a.id_materi");
goto CkyVp;
GZ3gV:
$this->db->from("log_materi a");
goto TY974;
J8bX7:
JkDqk:
goto EokQA;
i426Q:
foreach ($result as $key => $row) {
$ret[$row->id_siswa] = $row;
CfU0A:
}
goto wFExg;
LVLq1:
$result = $this->db->get()->result();
goto HE_rz;
fvVPp:
if (!$result) {
goto JkDqk;
}
goto i426Q;
DaamC:
}
public function getNilaiMateriSiswa($id_siswa)
{
goto hAOCe;
BKsIW:
$this->db->where("a.id_siswa", $id_siswa);
goto K4zcZ;
MksKe:
wc_qA:
goto h3tA7;
h3tA7:
J8UU8:
goto m92IM;
QdjPu:
$ret = [];
goto IT1XD;
K4zcZ:
$result = $this->db->get()->result();
goto QdjPu;
sGcZO:
$this->db->join("kelas_materi c", "b.id_materi=c.id_materi");
goto Dmf6V;
IT1XD:
if (!$result) {
goto J8UU8;
}
goto pe5WC;
Dmf6V:
$this->db->join("master_mapel d", "c.id_mapel=d.id_mapel");
goto BKsIW;
J2dJg:
$this->db->join("kelas_jadwal_materi b", "a.id_materi=b.id_kjm");
goto sGcZO;
hAOCe:
$this->db->select("a.nilai, a.catatan, b.jadwal_materi, c.kode_materi, c.judul_materi, c.jenis, d.nama_mapel, d.kode");
goto gqGhk;
gqGhk:
$this->db->from("log_materi a");
goto J2dJg;
m92IM:
return $ret;
goto xdA0C;
pe5WC:
foreach ($result as $key => $row) {
$ret[$row->jenis][] = $row;
B3396:
}
goto MksKe;
xdA0C:
}
public function getStatusSiswaByMapel($table, $id_mapel)
{
goto xuyuQ;
CVNCb:
$this->db->where("id_mapel", $id_mapel);
goto HymxV;
wnAlx:
$this->db->from($table);
goto CVNCb;
xuyuQ:
$this->db->select("*");
goto wnAlx;
HymxV:
return $this->db->get()->result();
goto TO_eY;
TO_eY:
}
public function getLogFileSiswa($table, $id_log)
{
goto sPJG1;
jXuYH:
return $query->row();
goto yA2yD;
sPJG1:
$this->db->select("*");
goto sONt6;
sONt6:
$this->db->from($table);
goto dZX7q;
EVQHC:
$query = $this->db->get();
goto jXuYH;
dZX7q:
$this->db->where("id_log", $id_log);
goto EVQHC;
yA2yD:
}
public function getLoginSiswa($username)
{
goto U5O9a;
HGuyK:
return $query->row()->log_time;
goto Wzr8I;
rug2M:
if ($query->num_rows() > 0) {
goto Cl_ne;
}
goto qcJiY;
kijBl:
$this->db->from("users a");
goto Wvy5y;
ZQr2g:
Cl_ne:
goto HGuyK;
s78l6:
goto TW4zl;
goto ZQr2g;
qcJiY:
return null;
goto s78l6;
Wvy5y:
$this->db->join("log b", "a.id=b.id_user", "left");
goto boId0;
Wzr8I:
TW4zl:
goto XAJ9X;
boId0:
$this->db->where("a.username", $username);
goto vZbXY;
vZbXY:
$this->db->order_by("b.log_time", "DESC");
goto x5z2R;
U5O9a:
$this->db->select("a.id, b.*");
goto kijBl;
x5z2R:
$query = $this->db->get();
goto rug2M;
XAJ9X:
}
public function loadJadwalSiswaHariIni($id_tp, $id_smt, $id_kelas, $id_hari, $with_key = true)
{
goto QvjEn;
caagS:
PNQjc:
goto WzQp2;
JkxpS:
if ($with_key) {
goto axz_7;
}
goto CL7d2;
CL7d2:
return $result;
goto VgyYM;
WzQp2:
return $ret;
goto KVhI5;
KVhI5:
rKNNg:
goto VBj0i;
qXQUZ:
$this->db->where("a.id_hari", $id_hari);
goto dIIeh;
n28j8:
$this->db->where("a.id_kelas", $id_kelas);
goto qXQUZ;
RHkhy:
$this->db->where("a.id_smt", $id_smt);
goto n28j8;
Za44w:
$this->db->join("master_mapel b", "b.id_mapel=a.id_mapel", "left");
goto vU1KE;
s_NO7:
foreach ($result as $key => $row) {
$ret[$row->jam_ke] = $row;
Kk5qc:
}
goto Z3YHN;
ENmep:
$ret = [];
goto Beyvs;
Z3YHN:
Weat7:
goto caagS;
Dc21_:
axz_7:
goto ENmep;
vU1KE:
$this->db->where("a.id_tp", $id_tp);
goto RHkhy;
VgyYM:
goto rKNNg;
goto Dc21_;
QvjEn:
$this->db->select("*");
goto RH_hm;
Beyvs:
if (!$result) {
goto PNQjc;
}
goto s_NO7;
dIIeh:
$result = $this->db->get()->result();
goto JkxpS;
RH_hm:
$this->db->from("kelas_jadwal_mapel a");
goto Za44w;
VBj0i:
}
public function loadJadwalSiswaSeminggu($id_tp, $id_smt, $id_kelas)
{
goto XyNhq;
pK4pk:
return $ret;
goto N262b;
FtzoK:
$this->db->where("a.id_tp", $id_tp);
goto YYq1q;
PD5O1:
$ret = [];
goto IPI5Q;
IPI5Q:
if (!$result) {
goto q4x6C;
}
goto m34Ci;
g4JQF:
$this->db->from("kelas_jadwal_mapel a");
goto W__KR;
ri2_L:
$result = $this->db->get()->result();
goto PD5O1;
YYq1q:
$this->db->where("a.id_smt", $id_smt);
goto pw5Lb;
pw5Lb:
$this->db->where("a.id_kelas", $id_kelas);
goto ri2_L;
XyNhq:
$this->db->select("*");
goto g4JQF;
g2Dtd:
q4x6C:
goto pK4pk;
wtdM3:
XGqo5:
goto g2Dtd;
W__KR:
$this->db->join("master_mapel b", "b.id_mapel=a.id_mapel", "left");
goto FtzoK;
m34Ci:
foreach ($result as $key => $row) {
$ret[$row->id_hari][$row->jam_ke] = $row;
VatGT:
}
goto wtdM3;
N262b:
}
public function getMateriSiswa($id_kelas, $tgl, $jenis)
{
goto AP_n_;
AP_n_:
$this->db->select("a.*, b.id_materi, b.kode_materi, b.judul_materi, b.materi_kelas, b.tgl_mulai, c.nama_guru, d.nama_mapel");
goto r3PNp;
r3PNp:
$this->db->from("kelas_jadwal_materi a");
goto oc31Z;
QWX4C:
$this->db->where("a.jenis", $jenis);
goto IbeMX;
hjAp5:
foreach ($result as $key => $row) {
goto h2LHg;
RzRgX:
$sisa = strlen($row->id_kjm) - $subs_jam;
goto BnQQN;
Z_B1_:
UCtQo:
goto TJQFX;
h2LHg:
$len_kls = strlen($row->id_kelas);
goto YqUOx;
vk87e:
$ret[$jam] = $row;
goto Z_B1_;
gKelC:
$jam = substr($row->id_kjm, strlen($row->id_kjm) - $len, 1);
goto vk87e;
BnQQN:
$len = $sisa === 3 ? 2 : 1;
goto gKelC;
YqUOx:
$subs_jam = $len_kls + 10;
goto RzRgX;
TJQFX:
}
goto RuEAW;
oc31Z:
$this->db->join("kelas_materi b", "a.id_materi=b.id_materi AND b.status=1");
goto Dt0_x;
U8Ua2:
$this->db->where("a.id_kelas", $id_kelas);
goto bOFtH;
PDkau:
if (!$result) {
goto bkPFN;
}
goto hjAp5;
z13Ec:
bkPFN:
goto Zkc8K;
Dt0_x:
$this->db->join("master_guru c", "b.id_guru=c.id_guru", "left");
goto RaoaL;
bOFtH:
$result = $this->db->get()->result();
goto NdHs2;
Zkc8K:
return $ret;
goto AKsCp;
IbeMX:
$this->db->where("a.jadwal_materi", $tgl);
goto U8Ua2;
RuEAW:
XlVvv:
goto z13Ec;
RaoaL:
$this->db->join("master_mapel d", "b.id_mapel=d.id_mapel", "left");
goto QWX4C;
NdHs2:
$ret = [];
goto PDkau;
AKsCp:
}
public function getMateriSiswaSeminggu($id_tp, $id_smt, $id_kelas, $jenis)
{
goto umW4V;
asPXC:
$this->db->from("kelas_jadwal_materi a");
goto xDK5V;
umW4V:
$this->db->select("a.*, b.id_materi, b.kode_materi, b.judul_materi, b.materi_kelas, b.tgl_mulai, c.nama_guru, d.nama_mapel");
goto asPXC;
sU4SW:
foreach ($result as $key => $row) {
goto xlvXj;
QS5tP:
$ret[$row->jadwal_materi][$jam] = $row;
goto vw0OV;
xlvXj:
$len_kls = strlen($row->id_kelas);
goto vf47o;
JLKji:
$len = $sisa === 3 ? 2 : 1;
goto i8fCe;
vw0OV:
yiU8d:
goto GVwYc;
vf47o:
$subs_jam = $len_kls + 10;
goto UslVB;
UslVB:
$sisa = strlen($row->id_kjm) - $subs_jam;
goto JLKji;
i8fCe:
$jam = substr($row->id_kjm, strlen($row->id_kjm) - $sisa, $len);
goto QS5tP;
GVwYc:
}
goto m0YbV;
xuVtI:
if (!$result) {
goto nmTyY;
}
goto sU4SW;
MPgKw:
$this->db->where("a.id_tp", $id_tp);
goto rFgrl;
ab7FM:
$this->db->join("master_mapel d", "b.id_mapel=d.id_mapel", "left");
goto MPgKw;
FuvLI:
nmTyY:
goto y4UYN;
mEhFn:
$this->db->join("master_guru c", "b.id_guru=c.id_guru", "left");
goto ab7FM;
F5FG5:
$ret = [];
goto xuVtI;
xDK5V:
$this->db->join("kelas_materi b", "a.id_materi=b.id_materi AND b.status=1");
goto mEhFn;
n8uGK:
$this->db->where("a.id_kelas", $id_kelas);
goto sMGCt;
sMGCt:
$result = $this->db->get()->result();
goto F5FG5;
y4UYN:
return $ret;
goto WqTj4;
m0YbV:
dB_Sk:
goto FuvLI;
rFgrl:
$this->db->where("a.id_smt", $id_smt);
goto ePp9n;
ePp9n:
$this->db->where("a.jenis", $jenis);
goto n8uGK;
WqTj4:
}
public function getAllMateriByTgl($id_kelas, $tgl, $arr_mapel)
{
goto NQa8l;
SNTpU:
iPQdV:
goto KjOyU;
skT3F:
return $ret;
goto vBn4V;
ot4t2:
$this->db->join("master_mapel d", "b.id_mapel=d.id_mapel", "left");
goto DAnIW;
rXITt:
foreach ($result as $key => $row) {
goto kyZ9V;
p7Kkc:
$row->materi_kelas = unserialize($row->materi_kelas);
goto azBQh;
GwN1z:
$jam = substr($row->id_kjm, strlen($row->id_kjm) - $sisa, $len);
goto p7Kkc;
ahW_Z:
FYQZl:
goto Nyt9k;
kyZ9V:
$len_kls = strlen($row->id_kelas);
goto A0n6w;
jnBZ1:
$sisa = strlen($row->id_kjm) - $subs_jam;
goto Tq_JX;
azBQh:
$ret[$row->id_mapel][$jam][$row->jenis] = $row;
goto ahW_Z;
A0n6w:
$subs_jam = $len_kls + 10;
goto jnBZ1;
Tq_JX:
$len = $sisa === 3 ? 2 : 1;
goto GwN1z;
Nyt9k:
}
goto SNTpU;
VRv0A:
$this->db->from("kelas_jadwal_materi a");
goto gL17e;
omR_1:
WbBls:
goto s4xbR;
gL17e:
$this->db->join("kelas_materi b", "a.id_materi=b.id_materi AND b.status=1");
goto pl4Ag;
TMbxv:
$result = $this->db->get()->result();
goto Caa35;
NQa8l:
$this->db->select("a.*, b.id_materi, b.kode_materi, b.materi_kelas, b.tgl_mulai, c.nama_guru, d.kode, d.nama_mapel");
goto VRv0A;
hrHRK:
$this->db->where_in("a.id_mapel", $arr_mapel);
goto omR_1;
W8fkl:
if (!(count($arr_mapel) > 0)) {
goto WbBls;
}
goto hrHRK;
KjOyU:
DNICM:
goto skT3F;
pl4Ag:
$this->db->join("master_guru c", "b.id_guru=c.id_guru", "left");
goto ot4t2;
s4xbR:
$this->db->where("a.id_kelas", $id_kelas);
goto TMbxv;
ddzod:
if (!$result) {
goto DNICM;
}
goto rXITt;
Caa35:
$ret = [];
goto ddzod;
DAnIW:
$this->db->where("a.jadwal_materi", $tgl);
goto W8fkl;
vBn4V:
}
public function getRekapStatusMapel($id_siswa, $date, $id_mapel)
{
goto ICmuJ;
hYrPS:
$this->db->join("master_mapel d", "c.id_mapel=d.id_mapel", "left");
goto iCj7n;
AYgh_:
$this->db->join("kelas_materi c", "b.id_materi=c.id_materi", "left");
goto hYrPS;
iOO8C:
$query = $this->db->get()->result();
goto YNz2o;
iCj7n:
$this->db->where("DATE(a.log_time)", $date);
goto eSikU;
eE5dX:
$this->db->where("a.id_mapel", $id_mapel);
goto iOO8C;
YNz2o:
return $query;
goto rkl4O;
ICmuJ:
$this->db->select("a.jam_ke, a.log_time, c.jenis, DAYOFMONTH(a.log_time) as tanggal, MONTH(a.log_time) as bulan, YEAR(a.log_time) as tahun, TIME_FORMAT(a.log_time, "%H:%i") as jam, d.nama_mapel, d.kode, d.id_mapel");
goto g5z8I;
g5z8I:
$this->db->from("log_materi a");
goto AQmMw;
eSikU:
$this->db->where("a.id_siswa", $id_siswa);
goto eE5dX;
AQmMw:
$this->db->join("kelas_jadwal_materi b", "a.id_materi=b.id_kjm", "left");
goto AYgh_;
rkl4O:
}
public function getRekapStatusMateri($id_siswa, $arr_id_kjm)
{
goto glxh7;
R2NjC:
$this->db->where("a.id_siswa", $id_siswa);
goto usPaH;
XD421:
$this->db->join("master_mapel d", "c.id_mapel=d.id_mapel", "left");
goto R2NjC;
KmQat:
$this->db->join("kelas_jadwal_materi b", "a.id_materi=b.id_kjm", "left");
goto HyLtn;
HyLtn:
$this->db->join("kelas_materi c", "b.id_materi=c.id_materi", "left");
goto XD421;
DSQbk:
$query = $this->db->get()->result();
goto eiQRN;
glxh7:
$this->db->select("a.jam_ke, a.log_time, a.finish_time, c.jenis, DAYOFMONTH(a.log_time) as tanggal, MONTH(a.log_time) as bulan, YEAR(a.log_time) as tahun, TIME_FORMAT(a.log_time, "%H:%i") as jam, d.nama_mapel, d.kode, d.id_mapel");
goto qMTSb;
qMTSb:
$this->db->from("log_materi a");
goto KmQat;
eiQRN:
return $query;
goto BXwHI;
usPaH:
$this->db->where_in("a.id_materi", $arr_id_kjm);
goto DSQbk;
BXwHI:
}
public function getRekapBulananMapel($id_siswa, $bulan)
{
goto HEA4n;
L4NkV:
$query = $this->db->get()->result();
goto gNMl9;
c2bz3:
$this->db->where("a.id_siswa", $id_siswa);
goto L4NkV;
pYKBC:
$this->db->where("MONTH(a.log_time)", $bulan);
goto c2bz3;
gNMl9:
return $query;
goto sJ290;
HEA4n:
$this->db->select("a.log_time as materi, DAYOFMONTH(a.log_time) as tanggal, MONTH(a.log_time) as bulan, YEAR(a.log_time) as tahun, TIME_FORMAT(a.log_time, "%H:%i") as jam_materi");
goto w7c9E;
w7c9E:
$this->db->from("log_materi a");
goto pYKBC;
sJ290:
}
public function getRekapBulananSiswa($id_mapel = null, $id_kelas, $tahun, $bulan)
{
goto fIvCG;
Rk11x:
$this->db->where("a.id_kelas", $id_kelas);
goto jTtPD;
O4UWf:
$this->db->from("kelas_jadwal_materi a");
goto dOF24;
MaPij:
if (!$result) {
goto wQaM8;
}
goto W9qwf;
fIvCG:
$this->db->select("a.*, b.log_time, b.finish_time, b.id_siswa, b.jam_ke, DAYOFMONTH(b.log_time) as tanggal, MONTH(b.log_time) as bulan, YEAR(b.log_time) as tahun, TIME_FORMAT(b.log_time, "%H:%i") as jam");
goto O4UWf;
JzPBA:
$result = $this->db->get()->result();
goto f9Qzd;
p1tJW:
QZKVV:
goto lpsxC;
f9Qzd:
$ret = [];
goto MaPij;
lbx8y:
$this->db->where("a.id_mapel", $id_mapel);
goto SSZAk;
pc77i:
$this->db->where("MONTH(a.jadwal_materi)", $bulan)->where("YEAR(a.jadwal_materi)", $tahun);
goto JzPBA;
BKv_Z:
return $ret;
goto LIjxf;
dOF24:
$this->db->join("log_materi b", "b.id_materi=a.id_kjm");
goto Rk11x;
lpsxC:
wQaM8:
goto BKv_Z;
W9qwf:
foreach ($result as $key => $row) {
$ret[$row->id_siswa][$row->jenis][$row->jadwal_materi][$row->jam_ke] = $row;
l208W:
}
goto p1tJW;
jTtPD:
if (!($id_mapel != null)) {
goto zfBet;
}
goto lbx8y;
SSZAk:
zfBet:
goto pc77i;
LIjxf:
}
public function getRekapBulananMateri($id_siswa, $date, $id_materi)
{
goto mHdWB;
s1Eqh:
$this->db->where("DATE(a.log_time)", $date);
goto Ptv9A;
YNb0W:
return $ret;
goto I3R3F;
v84T4:
$this->db->from("log_materi a");
goto s1Eqh;
Ptv9A:
$this->db->where("a.id_siswa", $id_siswa);
goto Ayd5n;
Ayd5n:
$this->db->where("a.id_materi", $id_materi);
goto eiiRf;
eiiRf:
$result = $this->db->get()->row();
goto loMA3;
loMA3:
$ret = [];
goto jRit1;
oyPEY:
kIo9V:
goto YNb0W;
yFC2c:
Ljciw:
goto oyPEY;
jRit1:
if (!$result) {
goto kIo9V;
}
goto RUgTg;
RUgTg:
foreach ($result as $key => $row) {
$ret[$row->id_siswa] = $row;
xNhTy:
}
goto yFC2c;
mHdWB:
$this->db->select("a.log_time, DAYOFMONTH(a.log_time) as tanggal, MONTH(a.log_time) as bulan, YEAR(a.log_time) as tahun, TIME_FORMAT(a.log_time, "%H:%i") as jam");
goto v84T4;
I3R3F:
}
public function getRekapMateriSemester($id_kelas, $id_materi = null)
{
goto QZMFI;
Y9QNx:
kG4Sh:
goto INMPx;
nleoB:
$ret = [];
goto zctR_;
QZMFI:
$this->db->select("id_siswa, id_log, log_time, finish_time, id_materi," . " DAYOFMONTH(log_time) as tanggal," . " MONTH(log_time) as bulan," . " YEAR(log_time) as tahun," . " TIME_FORMAT(log_time, "%H:%i") as jam," . " nilai");
goto mzL4B;
hh_nJ:
return $ret;
goto IIXEZ;
INMPx:
$result = $this->db->get()->result();
goto nleoB;
tQT6w:
K7QmG:
goto g80wS;
RhhNa:
foreach ($result as $key => $row) {
goto mFOu2;
Bzmx5:
$subs_tgl = $subs_bln + $len_bln;
goto jTJiz;
agdGU:
$len_bln = 2;
goto oUlEV;
ws1ir:
$tgl = substr($row->id_materi, $subs_tgl, 2);
goto c20H_;
oUlEV:
$len_hari = 2;
goto UAVCQ;
UAVCQ:
$subs_bln = $len_kls + $len_tp_smt + $len_tahun;
goto Bzmx5;
c20H_:
$jam = substr($row->id_materi, strlen($row->id_materi) - $sisa, $len);
goto TatjG;
OIo2t:
$ret[$jenis][$row->id_siswa][$bulan][$tgl][$jam] = $row;
goto qcHMB;
si0ft:
$len_tp_smt = 2;
goto ilGJ6;
xyi8p:
$bulan = substr($row->id_materi, $subs_bln, 2);
goto ws1ir;
mFOu2:
$len_kls = strlen($id_kelas);
goto si0ft;
qcHMB:
LyV0O:
goto OpAKi;
jTJiz:
$sisa = strlen($row->id_materi) - ($len_kls + 10);
goto YGddw;
YGddw:
$len = $sisa === 3 ? 2 : 1;
goto xyi8p;
TatjG:
$jenis = substr($row->id_materi, strlen($row->id_materi) - 1, 1);
goto OIo2t;
ilGJ6:
$len_tahun = 4;
goto agdGU;
OpAKi:
}
goto tQT6w;
g80wS:
GhzXv:
goto hh_nJ;
mzL4B:
$this->db->from("log_materi");
goto LYZfI;
LYZfI:
if (!($id_materi != null)) {
goto kG4Sh;
}
goto UWufL;
UWufL:
$this->db->where("id_materi", $id_materi);
goto Y9QNx;
zctR_:
if (!$result) {
goto GhzXv;
}
goto RhhNa;
IIXEZ:
}
public function getStrukturKelas($kelas)
{
$this->db->where("id_kelas", $kelas);
return $this->db->get("kelas_struktur")->row();
}
public function getCatatanKelas($kelas, $id_tp, $id_smt)
{
goto cEbQ2;
zv5jr:
$this->db->where("id_tp", $id_tp);
goto CI8yQ;
yJzYv:
return $this->db->get("kelas_catatan_wali")->result();
goto DPqU9;
CI8yQ:
$this->db->where("id_smt", $id_smt);
goto yJzYv;
cEbQ2:
$this->db->where("id_kelas", $kelas);
goto Hdh_V;
Hdh_V:
$this->db->where("type", "1");
goto zv5jr;
DPqU9:
}
public function getCatatanSiswa($id_tp, $id_smt, $id_kelas)
{
goto IQQ37;
k09A5:
return $this->db->get()->result();
goto QRAA9;
IQQ37:
$this->db->select("b.id_siswa, b.nama, b.nis, b.nisn, b.foto," . " (SELECT COUNT(id_siswa) FROM kelas_catatan_wali c WHERE c.id_siswa = b.id_siswa AND c.type = '2') AS jml_catatan");
goto AGyVH;
eK2O8:
$this->db->where("a.id_tp", $id_tp);
goto hsvmc;
hsvmc:
$this->db->where("a.id_smt", $id_smt);
goto acaUQ;
AGyVH:
$this->db->from("kelas_siswa a");
goto vdKb7;
vdKb7:
$this->db->join("master_siswa b", "b.id_siswa=a.id_siswa");
goto eK2O8;
acaUQ:
$this->db->where("a.id_kelas", $id_kelas);
goto k09A5;
QRAA9:
}
public function getAllCatatanSiswa($id_siswa, $id_tp, $id_smt)
{
goto rGfMH;
WQALI:
$this->db->where("id_siswa", $id_siswa);
goto xN88Z;
rGfMH:
$this->db->select("*");
goto LxKJO;
xN88Z:
$this->db->where("id_tp", $id_tp);
goto QplCG;
QplCG:
$this->db->where("id_smt", $id_smt);
goto SozUX;
SozUX:
return $this->db->get()->result();
goto N9Our;
LxKJO:
$this->db->from("kelas_catatan_wali");
goto WQALI;
N9Our:
}
public function getCatatanMapelKelas($kelas, $mapel, $id_tp, $id_smt)
{
goto mx_k4;
mx_k4:
$this->db->where("id_kelas", $kelas);
goto qyK6e;
IDjca:
$this->db->where("id_smt", $id_smt);
goto JFQjf;
LyEiZ:
$this->db->where("id_tp", $id_tp);
goto IDjca;
JFQjf:
$this->db->order_by("tgl", "DESC");
goto lZw_S;
lZw_S:
return $this->db->get("kelas_catatan_mapel")->result();
goto Yp0rv;
isAi6:
$this->db->where("type", "1");
goto LyEiZ;
qyK6e:
$this->db->where("id_mapel", $mapel);
goto isAi6;
Yp0rv:
}
public function getCatatanMapelSiswa($id_tp, $id_smt, $id_kelas, $id_mapel)
{
goto bJs1m;
GHVZB:
$this->db->from("kelas_siswa a");
goto FnGMw;
vN1W8:
$this->db->where("a.id_kelas", $id_kelas);
goto BFN_B;
bJs1m:
$this->db->select("b.id_siswa, b.nama, b.nis, b.nisn, b.foto," . " (SELECT COUNT(id_siswa) FROM kelas_catatan_mapel c WHERE c.id_siswa = b.id_siswa AND c.id_mapel = " . $id_mapel . " AND c.type = '2') AS jml_catatan");
goto GHVZB;
BFN_B:
return $this->db->get()->result();
goto sILtU;
amHBl:
$this->db->where("a.id_smt", $id_smt);
goto vN1W8;
wB_HD:
$this->db->where("a.id_tp", $id_tp);
goto amHBl;
FnGMw:
$this->db->join("master_siswa b", "b.id_siswa=a.id_siswa", "left");
goto wB_HD;
sILtU:
}
public function getAllCatatanMapelSiswa($id_siswa, $id_mapel, $id_tp, $id_smt)
{
goto dGKrB;
e6hva:
return $this->db->get()->result();
goto Y7Ahb;
IbGuG:
$this->db->where("id_mapel", $id_mapel);
goto Ur1Eq;
Gezan:
$this->db->order_by("tgl", "DESC");
goto e6hva;
fXbW6:
$this->db->where("id_smt", $id_smt);
goto Gezan;
IZ2z2:
$this->db->where("id_siswa", $id_siswa);
goto IbGuG;
x8soH:
$this->db->from("kelas_catatan_mapel");
goto IZ2z2;
dGKrB:
$this->db->select("*");
goto x8soH;
Ur1Eq:
$this->db->where("id_tp", $id_tp);
goto fXbW6;
Y7Ahb:
}
public function getCatatanMapelBySiswa($id_kelas, $id_tp, $id_smt)
{
goto lWMkD;
TgyTT:
return $this->db->get()->result();
goto N72mZ;
sVuDf:
$this->db->from("kelas_catatan_mapel a");
goto py2hE;
lWMkD:
$this->db->select("a.*, b.nama_guru, b.nip, b.foto");
goto sVuDf;
vwt_s:
$this->db->where("a.id_smt", $id_smt);
goto TgyTT;
Nt6sI:
$this->db->where("a.id_tp", $id_tp);
goto vwt_s;
py2hE:
$this->db->join("master_guru b", "b.id_guru=a.id_guru");
goto Nt6sI;
N72mZ:
}
public function getCatatanSiswaBySiswa($id_kelas, $id_tp, $id_smt)
{
goto w5Ppw;
w5Ppw:
$this->db->select("a.*, c.nama_guru, c.nip, c.foto");
goto oMFXt;
UMUMf:
$this->db->where("a.id_tp", $id_tp);
goto Dh6m9;
rMD0H:
$this->db->join("master_guru c", "c.id_guru=b.id_guru");
goto UMUMf;
oMFXt:
$this->db->from("kelas_catatan_wali a");
goto XJrSG;
Dh6m9:
$this->db->where("a.id_smt", $id_smt);
goto vdclO;
XJrSG:
$this->db->join("jabatan_guru b", "b.id_kelas=a.id_kelas");
goto rMD0H;
vdclO:
return $this->db->get()->result();
goto Evdpp;
Evdpp:
}
public function getCatatanMapelSiswaDetail($id_catatan)
{
goto HOPXv;
hpv20:
$this->db->join("jabatan_guru c", "c.id_guru=a.id_guru");
goto Si7N0;
am5My:
return $this->db->get()->row();
goto ZfmCh;
HOPXv:
$this->db->select("a.*, b.nama_guru, b.nip, b.foto, d.level as jabatan, e.nama_mapel, e.kode");
goto AAJ9I;
YDzYd:
$this->db->join("master_mapel e", "e.id_mapel=a.id_mapel");
goto c5dHS;
Si7N0:
$this->db->join("level_guru d", "d.id_level=c.id_jabatan");
goto YDzYd;
m_kom:
$this->db->join("master_guru b", "b.id_guru=a.id_guru");
goto hpv20;
AAJ9I:
$this->db->from("kelas_catatan_mapel a");
goto m_kom;
c5dHS:
$this->db->where("a.id_catatan", $id_catatan);
goto am5My;
ZfmCh:
}
public function getCatatanKelasSiswaDetail($id_catatan)
{
goto rEuwC;
eInCW:
$this->db->join("master_kelas f", "f.id_kelas=a.id_kelas");
goto psSL3;
rEuwC:
$this->db->select("a.*, c.nama_guru, c.nip, c.foto, e.level as jabatan, f.nama_kelas");
goto L2YSA;
L2YSA:
$this->db->from("kelas_catatan_wali a");
goto TWpN7;
piZn3:
$this->db->join("level_guru e", "e.id_level=b.id_jabatan");
goto eInCW;
psSL3:
$this->db->where("a.id_catatan", $id_catatan);
goto uqsaW;
TWpN7:
$this->db->join("jabatan_guru b", "b.id_kelas=a.id_kelas");
goto yMLIO;
uqsaW:
return $this->db->get()->row();
goto Z16rW;
yMLIO:
$this->db->join("master_guru c", "c.id_guru=b.id_guru");
goto piZn3;
Z16rW:
}
public function getReading($table, $id_catatan)
{
goto Datfx;
Datfx:
$this->db->select("reading, type, readed");
goto QkZ6A;
zixo0:
return $this->db->get($table)->row();
goto aiZZK;
QkZ6A:
$this->db->where("id_catatan", $id_catatan);
goto zixo0;
aiZZK:
}
}
?>Did this file decode correctly?
Original Code
<?php
/* ________________________________________
| GarudaCBT |
| https://github.com/garudacbt/cbt |
|________________________________________|
*/
class Kelas_model extends CI_Model
{
public function __construct()
{
parent::__construct();
}
public function saveLog($table, $id_siswa, $id_kjm, $jamke, $mapel, $desc)
{
goto Gt5iP;
VPp45:
jB18O:
goto yy3cJ;
Krny4:
Q7ywn:
goto rhJPk;
V3sEa:
goto mNZIT;
goto Krny4;
Gtm86:
$ip = $this->input->ip_address();
goto Mkn7u;
Dkrc4:
HVnVV:
goto CGhre;
CGhre:
if ($agent == "\x75\x6e\153\156\x6f\167\x6e") {
goto Q7ywn;
}
goto rGLdn;
dqrTe:
$agent = "\165\156\153\156\x6f\x77\156";
goto gYU5l;
gYU5l:
goto HVnVV;
goto VPp45;
Wj4nG:
goto HVnVV;
goto fynaJ;
Mkn7u:
return $this->insertLog($table, $id_siswa, $id_kjm, $jamke, $mapel, $desc, $agent, $os, $ip);
goto V3sEa;
yy3cJ:
$agent = $this->agent->browser() . "\x20" . $this->agent->version();
goto Wj4nG;
pSOyU:
if ($this->agent->is_mobile()) {
goto fC5ri;
}
goto dqrTe;
rGLdn:
$os = $this->agent->platform();
goto Gtm86;
fynaJ:
fC5ri:
goto qaQwP;
Gt5iP:
if ($this->agent->is_browser()) {
goto jB18O;
}
goto pSOyU;
qaQwP:
$agent = $this->agent->mobile();
goto Dkrc4;
EiAWS:
mNZIT:
goto dSKtJ;
rhJPk:
return "\x65\162\x72\157\162";
goto EiAWS;
dSKtJ:
}
private function insertLog($table, $id_siswa, $id_kjm, $jamke, $mapel, $desc, $agent, $os, $ip)
{
goto Uuqwq;
ebT31:
return $insert;
goto kU22Y;
NKgTu:
$insert = $this->db->insert($table, $data);
goto ebT31;
Uuqwq:
$data = array("\x69\x64\137\154\x6f\x67" => $id_siswa . $id_kjm, "\x6c\x6f\x67\x5f\164\151\x6d\x65" => date("\131\x2d\x6d\x2d\x64\40\x48\x3a\151\72\x73"), "\x69\x64\x5f\163\151\163\167\x61" => $id_siswa, "\x69\x64\x5f\x6d\141\164\x65\162\151" => $id_kjm, "\151\144\x5f\x6d\x61\x70\x65\x6c" => $mapel, "\x6a\141\155\137\153\x65" => $jamke, "\x6c\x6f\147\x5f\x64\x65\163\143" => $desc, "\x61\x64\x64\x72\145\x73\163" => $ip, "\141\x67\145\156\164" => $agent, "\144\x65\x76\x69\143\x65" => $os);
goto NKgTu;
kU22Y:
}
public function getKelasList($tp, $smt)
{
goto BHnq8;
KtxrH:
$this->db->join("\x6d\x61\163\164\145\162\x5f\152\x75\162\x75\163\141\x6e\40\x62", "\142\x2e\x69\x64\137\x6a\165\162\165\163\x61\156\x3d\141\x2e\x6a\x75\x72\x75\163\141\156\x5f\x69\x64", "\154\145\x66\x74");
goto ROQng;
ROQng:
$this->db->join("\154\145\x76\x65\154\137\x6b\x65\154\x61\163\x20\143", "\143\56\151\x64\137\x6c\x65\x76\145\x6c\75\141\x2e\154\145\166\x65\154\x5f\151\x64", "\x6c\x65\x66\x74");
goto hB6xB;
KjvvX:
$this->db->order_by("\x61\x2e\156\141\x6d\x61\137\x6b\x65\x6c\141\163", "\x41\x53\103");
goto W9IH3;
OA5Ng:
$this->db->where("\141\56\151\x64\x5f\163\x6d\x74", $smt);
goto XY6l2;
bL_mD:
$this->db->join("\155\141\x73\x74\145\162\137\163\x69\x73\x77\141\x20\145", "\x65\56\x69\144\x5f\x73\151\x73\167\x61\75\141\56\x73\x69\163\x77\x61\x5f\151\x64", "\x6c\x65\146\x74");
goto mgHk5;
BHnq8:
$this->db->select("\141\56\52\x2c\40\142\x2e\156\141\155\x61\137\152\165\x72\x75\x73\141\x6e\x2c\x20\x64\56\x6e\141\x6d\x61\137\x67\165\162\x75\54\x20\x65\x2e\x6e\x61\x6d\141\x2c\x20\50\123\105\x4c\x45\x43\124\40\x43\117\x55\x4e\x54\50\151\144\137\x6b\x65\x6c\x61\x73\137\163\151\x73\x77\x61\x29\x20\106\122\117\115\40\x6b\x65\154\141\x73\137\163\151\163\x77\x61\x20\153\x20\x57\110\105\122\105\40\x61\56\x69\x64\x5f\x6b\145\154\x61\x73\x3d\153\56\151\144\x5f\153\x65\154\141\163\x29\x20\x41\123\x20\152\x6d\154\x5f\163\x69\x73\167\x61");
goto rD4Yi;
XY6l2:
$this->db->order_by("\141\x2e\x6c\145\166\x65\x6c\x5f\x69\144", "\x41\x53\103");
goto KjvvX;
nR33I:
return $query->result();
goto dOzG3;
W9IH3:
$query = $this->db->get();
goto nR33I;
rD4Yi:
$this->db->from("\155\x61\x73\x74\145\x72\137\153\145\x6c\141\163\x20\141");
goto KtxrH;
Rz6nr:
$this->db->join("\155\141\x73\164\x65\162\137\147\x75\x72\165\x20\x64", "\x64\x2e\151\x64\137\x67\165\x72\165\75\146\56\x69\144\137\147\x75\x72\165", "\x6c\145\x66\x74");
goto bL_mD;
hB6xB:
$this->db->join("\x6a\141\x62\x61\164\x61\156\x5f\147\x75\x72\x75\x20\x66", "\146\56\x69\144\x5f\153\145\x6c\141\x73\x3d\141\56\x69\x64\x5f\153\145\x6c\x61\163", "\154\145\x66\x74");
goto Rz6nr;
mgHk5:
$this->db->where("\141\56\151\144\x5f\164\x70", $tp);
goto OA5Ng;
dOzG3:
}
public function getJmlSiswaKelas($id_kelas)
{
goto f6Ap9;
Ifrf2:
return $this->db->count_all_results();
goto cOaTp;
f6Ap9:
$this->db->from("\x6b\x65\154\x61\x73\137\163\151\x73\x77\x61");
goto GqXX1;
GqXX1:
$this->db->where("\x69\x64\x5f\x6b\x65\x6c\141\x73", $id_kelas);
goto Ifrf2;
cOaTp:
}
public function get_all($limit, $offset)
{
goto i_9wv;
DcnCz:
goto gQfhQ;
goto Gqj4I;
Gqj4I:
gSKaf:
goto TJWhe;
TJWhe:
return $result->result_array();
goto JrfrQ;
Hl7Jg:
return array();
goto DcnCz;
NOJ_h:
if ($result->num_rows() > 0) {
goto gSKaf;
}
goto Hl7Jg;
i_9wv:
$result = $this->db->get("\155\141\x73\x74\x65\162\x5f\x6b\145\x6c\141\163", $limit, $offset);
goto NOJ_h;
JrfrQ:
gQfhQ:
goto xnWqc;
xnWqc:
}
public function getAllKelas()
{
goto k7sZo;
Dpyhm:
$this->db->join("\152\x61\142\x61\164\x61\156\x5f\x67\x75\162\165\x20\x66", "\x66\56\151\x64\137\153\145\154\x61\163\x3d\141\x2e\151\x64\137\x6b\x65\x6c\x61\x73", "\154\145\146\x74");
goto jLK09;
a1dVl:
$this->db->from("\x6d\x61\x73\x74\x65\x72\x5f\x6b\145\x6c\x61\163\40\141");
goto Dpyhm;
YAuYM:
return $result;
goto cpf_p;
KXdy5:
$result = $this->db->get()->result();
goto YAuYM;
ztpkH:
$this->db->order_by("\141\56\156\x61\x6d\141\137\x6b\145\x6c\x61\x73");
goto KXdy5;
jLK09:
$this->db->join("\155\x61\163\164\x65\x72\x5f\x6a\165\x72\x75\163\x61\x6e\x20\x62", "\x61\56\x6a\x75\x72\165\x73\141\x6e\137\x69\x64\x3d\142\x2e\x69\x64\137\152\x75\162\165\x73\141\x6e", "\x6c\x65\x66\164");
goto UHVDi;
k7sZo:
$this->db->select("\x61\x2e\151\x64\x5f\x6b\x65\x6c\x61\163\54\40\141\56\151\x64\137\x74\x70\x2c\40\141\56\x69\144\137\x73\x6d\x74\x2c\x20\141\x2e\156\x61\155\141\137\153\145\154\141\163\54\40\x61\x2e\153\x6f\144\145\x5f\x6b\x65\x6c\x61\x73\54\x20\141\x2e\x6c\145\x76\x65\x6c\x5f\x69\144\54\x20\x62\x2e\x69\x64\137\x6a\165\162\x75\163\x61\156\x2c\40\142\x2e\x6e\x61\x6d\x61\137\x6a\x75\x72\x75\163\x61\156\54\40\x62\56\x6b\157\x64\x65\x5f\x6a\165\162\x75\163\141\156\54\x20\143\x2e\151\144\x5f\x67\x75\x72\165\54\40\x63\56\156\141\155\141\x5f\147\165\x72\165");
goto a1dVl;
UHVDi:
$this->db->join("\x6d\x61\163\164\145\162\137\147\x75\x72\x75\40\143", "\x66\56\151\x64\x5f\147\165\162\x75\x3d\x63\56\x69\x64\137\x67\165\x72\165", "\154\145\146\x74");
goto ztpkH;
cpf_p:
}
public function count_all()
{
$this->db->from("\155\x61\163\x74\145\x72\137\x6b\145\154\x61\x73");
return $this->db->count_all_results();
}
public function get_search($limit, $offset)
{
goto ksMpW;
uKQal:
if ($result->num_rows() > 0) {
goto mJm6H;
}
goto wKj3L;
WDeiN:
mJm6H:
goto FJP1R;
wKj3L:
return array();
goto yhBw5;
iImU5:
$this->db->like("\156\141\155\141\137\x6b\x65\154\x61\x73", $keyword);
goto QmVIg;
mcfku:
$this->db->limit($limit, $offset);
goto JRdLa;
FJP1R:
return $result->result_array();
goto dqSbW;
QmVIg:
$this->db->like("\152\x75\x6d\154\141\x68\137\x73\x69\163\x77\x61", $keyword);
goto mcfku;
JRdLa:
$result = $this->db->get("\x6d\x61\163\x74\145\x72\137\153\145\x6c\141\163");
goto uKQal;
dqSbW:
c15c2:
goto X6UOt;
yhBw5:
goto c15c2;
goto WDeiN;
ksMpW:
$keyword = $this->session->userdata("\153\x65\171\167\157\x72\144");
goto iImU5;
X6UOt:
}
public function count_all_search()
{
goto G1nPo;
G1nPo:
$keyword = $this->session->userdata("\153\x65\x79\167\157\162\x64");
goto Yu0p3;
sx7TB:
return $this->db->count_all_results();
goto ohh9V;
Yu0p3:
$this->db->from("\155\141\163\164\145\x72\137\x6b\x65\x6c\x61\x73");
goto oHiG8;
XEQeW:
$this->db->like("\x6a\x75\x6d\x6c\141\150\137\x73\151\163\x77\141", $keyword);
goto sx7TB;
oHiG8:
$this->db->like("\156\x61\155\141\x5f\x6b\x65\154\x61\163", $keyword);
goto XEQeW;
ohh9V:
}
public function get_one($id, $id_tp = null, $id_smt = null)
{
goto dTTHi;
z1cuz:
if (!($id_tp != null)) {
goto p8Vsu;
}
goto a84vo;
cqZ_c:
$this->db->where("\x6b\x2e\x69\144\x5f\153\145\154\x61\x73", $id);
goto z1cuz;
qlmXJ:
$this->db->join("\154\145\x76\145\154\137\153\x65\x6c\141\163\40\x6c", "\x6c\x2e\x69\144\x5f\154\x65\166\145\x6c\x3d\x6b\x2e\x6c\145\166\145\154\x5f\151\144", "\x6c\145\x66\x74");
goto k0Xgf;
dTTHi:
$this->db->select("\x2a");
goto wFtbi;
ChJ1U:
$this->db->join("\x6d\x61\x73\x74\x65\x72\x5f\x73\x69\163\167\x61\x20\163\151", "\x73\151\x2e\x69\144\x5f\163\151\x73\x77\x61\x3d\153\x2e\163\151\x73\x77\141\x5f\151\x64", "\x6c\x65\x66\x74");
goto HmXO2;
wFtbi:
$this->db->from("\155\141\163\164\145\x72\x5f\x6b\145\154\141\x73\40\153");
goto DhUww;
k0Xgf:
$this->db->join("\x6a\141\x62\141\164\141\x6e\x5f\x67\x75\x72\165\40\x66", "\x66\56\x69\x64\x5f\153\145\x6c\x61\163\75\x6b\56\x69\144\x5f\x6b\145\x6c\141\163", "\154\x65\x66\164");
goto W2dqR;
HmXO2:
$this->db->order_by("\x6e\141\155\x61\x5f\153\x65\154\141\163", "\101\x53\103");
goto cqZ_c;
DhUww:
$this->db->join("\x6d\x61\163\x74\x65\x72\137\152\165\162\165\x73\x61\x6e\x20\x6a", "\x6a\56\x69\144\x5f\152\165\162\165\x73\x61\x6e\x3d\x6b\56\152\x75\x72\165\163\141\x6e\x5f\x69\144", "\x6c\145\146\164");
goto qlmXJ;
R6aNC:
return $this->db->get()->row();
goto dtOFu;
a84vo:
$this->db->where("\153\56\x69\x64\137\164\x70", $id_tp);
goto nXOxq;
DxQOx:
$this->db->where("\x6b\x2e\151\144\137\163\155\164", $id_smt);
goto i2lW0;
i2lW0:
XS4zI:
goto R6aNC;
W2dqR:
$this->db->join("\155\x61\x73\x74\x65\x72\x5f\x67\165\x72\x75\x20\x67", "\x67\56\151\144\x5f\147\165\x72\165\x3d\x66\56\151\144\x5f\147\165\162\165", "\x6c\145\x66\164");
goto ChJ1U;
nXOxq:
p8Vsu:
goto ZcP17;
ZcP17:
if (!($id_smt != null)) {
goto XS4zI;
}
goto DxQOx;
dtOFu:
}
public function getKelasByNama($nama_kelas, $id_tp = null, $id_smt = null)
{
goto LRnS3;
LRnS3:
$this->db->select("\x2a");
goto IjxSm;
IjxSm:
$this->db->from("\x6d\x61\x73\164\145\162\x5f\x6b\145\x6c\141\x73\40\x6b");
goto bD_LH;
QaBf2:
return $this->db->get()->row();
goto i5VeV;
aNvIK:
QGykp:
goto Ov0hZ;
jPjSM:
ga1sj:
goto QaBf2;
eV1_p:
$this->db->join("\x6c\145\166\x65\154\137\153\145\154\141\x73\40\x6c", "\x6c\56\151\x64\137\x6c\145\x76\145\154\75\x6b\56\x6c\x65\166\145\154\x5f\x69\x64", "\154\145\x66\164");
goto B4vOQ;
Ov0hZ:
if (!($id_smt != null)) {
goto ga1sj;
}
goto tBu1b;
bD_LH:
$this->db->join("\155\x61\x73\164\145\x72\137\x6a\165\x72\x75\x73\141\x6e\40\152", "\152\56\151\x64\137\x6a\x75\162\x75\x73\x61\156\x3d\153\56\x6a\x75\x72\x75\x73\141\x6e\137\x69\x64", "\x6c\x65\146\164");
goto eV1_p;
fBe9I:
$this->db->order_by("\156\141\155\x61\137\x6b\x65\154\141\163", "\101\123\103");
goto VYN2L;
VYN2L:
$this->db->where("\x6b\56\x6e\141\x6d\x61\137\153\x65\154\x61\163", $nama_kelas);
goto AjgZv;
U9n1i:
$this->db->where("\153\x2e\x69\144\x5f\164\160", $id_tp);
goto aNvIK;
AjgZv:
if (!($id_tp != null)) {
goto QGykp;
}
goto U9n1i;
XvCgU:
$this->db->join("\x6d\x61\x73\x74\x65\162\137\147\165\x72\x75\x20\x67", "\147\56\x69\x64\137\x67\x75\x72\165\x3d\146\56\x69\144\137\x67\x75\x72\165", "\154\x65\x66\164");
goto nPPJ_;
tBu1b:
$this->db->where("\x6b\x2e\x69\144\x5f\x73\x6d\164", $id_smt);
goto jPjSM;
B4vOQ:
$this->db->join("\152\141\x62\141\164\141\156\x5f\x67\x75\162\x75\x20\146", "\146\56\x69\144\137\x6b\x65\x6c\141\x73\75\x6b\56\151\144\x5f\x6b\145\x6c\x61\x73", "\x6c\145\146\164");
goto XvCgU;
nPPJ_:
$this->db->join("\x6d\x61\x73\164\x65\162\x5f\x73\x69\163\167\x61\40\x73\x69", "\x73\x69\56\x69\144\137\x73\x69\163\x77\x61\x3d\153\x2e\163\x69\163\x77\141\137\x69\144", "\x6c\x65\x66\164");
goto fBe9I;
i5VeV:
}
public function getNamaKelasByNama($id_tp, $id_smt)
{
goto AHGw0;
Lzs_A:
$ret = [];
goto sWj4a;
sWj4a:
if (!$result) {
goto RvccN;
}
goto OHiyj;
otu2S:
$this->db->from("\155\141\163\x74\x65\x72\137\x6b\145\x6c\x61\163");
goto Dgvrk;
BUivL:
return $ret;
goto wzPhs;
FNqoi:
$result = $this->db->get()->result();
goto Lzs_A;
Dgvrk:
$this->db->where("\x69\x64\137\x74\160", $id_tp);
goto DLdLU;
OHiyj:
foreach ($result as $row) {
$ret[$row->nama_kelas] = $row->id_kelas;
Zx_iU:
}
goto cY2eG;
cY2eG:
hdaZF:
goto Lqieb;
AHGw0:
$this->db->select("\151\144\x5f\153\x65\154\141\x73\x2c\x20\x6e\x61\155\x61\x5f\153\x65\154\x61\163");
goto otu2S;
Lqieb:
RvccN:
goto BUivL;
DLdLU:
$this->db->where("\x69\x64\x5f\163\x6d\164", $id_smt);
goto FNqoi;
wzPhs:
}
public function dummy()
{
$data = ["\x69\144\137\x6b\145\x6c\141\x73" => '', "\156\x61\155\141\137\153\x65\154\141\163" => '', "\x6b\x6f\x64\x65\x5f\153\145\x6c\141\x73" => '', "\152\x75\162\x75\x73\141\156\x5f\151\x64" => '', "\x6c\x65\x76\145\x6c\x5f\x69\x64" => '', "\147\165\162\x75\137\151\x64" => '', "\x73\x69\x73\x77\x61\137\151\x64" => '', "\x6a\165\x6d\154\141\x68\137\163\x69\163\x77\x61" => serialize([])];
return $data;
}
public function dummyStruktur()
{
$data = array("\x69\144\137\153\x65\x6c\x61\163" => '', "\153\145\160\163\145\x6b" => '', "\167\141\153\x61" => '', "\x77\141\154\x69" => '', "\153\145\x74\x75\x61" => '', "\167\141\153\x69\154\x5f\153\x65\164\165\141" => '', "\x73\145\153\162\x65\x74\141\162\x69\163\137\x31" => '', "\163\145\x6b\x72\x65\164\x61\x72\x69\163\x5f\x32" => '', "\x62\145\x6e\144\141\x68\141\162\141\x5f\x31" => '', "\142\x65\x6e\x64\141\x68\x61\162\x61\x5f\62" => '', "\x73\x69\x65\137\x65\x6b\163\164\x72\x61\x6b\165\162\151\x6b\x75\x6c\145\162" => '', "\x73\x69\x65\137\165\160\141\143\x61\162\141" => '', "\163\x69\x65\x5f\157\x6c\141\150\x72\141\x67\141" => '', "\x73\x69\145\137\x6b\x65\x61\x67\141\x6d\141\141\x6e" => '', "\x73\x69\145\137\x6b\x65\141\x6d\141\156\141\x6e" => '', "\x73\151\x65\137\x6b\x65\164\x65\x72\x74\x69\142\x61\x6e" => '', "\163\x69\x65\x5f\x6b\145\142\x65\x72\163\x69\x68\x61\x6e" => '', "\x73\x69\x65\x5f\x6b\x65\151\156\x64\x61\150\141\156" => '', "\x73\151\145\137\x6b\x65\163\145\x68\141\x74\x61\x6e" => '', "\x73\x69\145\137\x6b\x65\153\x65\x6c\165\x61\162\x67\141\x61\x6e" => '', "\x73\151\x65\x5f\x68\165\155\x61\x73" => '');
return $data;
}
public function destroy($id)
{
$this->db->where("\x69\144\137\153\145\x6c\x61\163", $id);
$this->db->delete("\155\x61\x73\164\145\x72\x5f\x6b\x65\154\x61\163");
}
public function get_jurusan()
{
goto OpFrn;
z6wpF:
YoEYJ:
goto I609l;
N2rLL:
$ret[''] = "\x50\151\154\151\x68\40\112\x75\162\x75\163\x61\x6e\x20\72";
goto s4UAc;
I609l:
return $ret;
goto ttWYt;
s4UAc:
if (!$result) {
goto YoEYJ;
}
goto TBjwz;
OpFrn:
$result = $this->db->get("\155\141\163\164\145\x72\137\x6a\x75\162\x75\x73\x61\156")->result();
goto N2rLL;
T_NVv:
AnTA5:
goto z6wpF;
TBjwz:
foreach ($result as $key => $row) {
$ret[$row->id_jurusan] = $row->nama_jurusan;
w3S1n:
}
goto T_NVv;
ttWYt:
}
public function getJurusanById($id)
{
goto NxvpX;
QLMPd:
return $result;
goto uu2CJ;
vmqlt:
$result = $this->db->get("\155\141\x73\x74\145\162\137\152\165\x72\x75\163\x61\156")->row();
goto QLMPd;
NxvpX:
$this->db->where("\151\x64\137\152\165\162\x75\163\141\x6e", $id);
goto vmqlt;
uu2CJ:
}
public function get_level()
{
goto VRQqE;
Cbn2M:
$ret[''] = "\x50\x69\x6c\151\x68\x20\114\x65\x76\x65\154\40\x3a";
goto oQIGt;
w0CMP:
bVgVC:
goto SXTN_;
nll8d:
foreach ($result as $key => $row) {
$ret[$row->id_level] = $row->level;
oM8pa:
}
goto iFe5H;
VRQqE:
$result = $this->db->get("\154\x65\x76\145\154\x5f\x6b\145\154\x61\163")->result();
goto Cbn2M;
SXTN_:
return $ret;
goto UooWX;
oQIGt:
if (!$result) {
goto bVgVC;
}
goto nll8d;
iFe5H:
AWvPw:
goto w0CMP;
UooWX:
}
public function getLevel($jenjang)
{
goto mn6EZ;
xRJTn:
jkrMx:
goto eE9_J;
qstm9:
NdGe1:
goto dke3H;
ckNfC:
if ($jenjang == "\63") {
goto jkrMx;
}
goto q44__;
OJmaL:
bOqD1:
goto hMeWB;
dke3H:
return $levels;
goto QMQJk;
hMeWB:
$levels = ['' => "\x50\x69\x6c\x69\x68\x20\114\145\166\145\x6c", "\61" => "\61", "\62" => "\x32", "\63" => "\x33", "\x34" => "\x34", "\x35" => "\65", "\66" => "\66"];
goto D895P;
eE9_J:
$levels = ['' => "\x50\151\x6c\x69\150\40\x4c\145\166\x65\x6c", "\61\x30" => "\x31\x30", "\61\x31" => "\61\x31", "\61\x32" => "\61\x32"];
goto qstm9;
mn6EZ:
$levels = [];
goto euj2B;
NebNM:
zCUKn:
goto KxVNO;
KxVNO:
$levels = ['' => "\x50\x69\154\151\x68\40\x4c\x65\166\x65\x6c", "\67" => "\x37", "\70" => "\70", "\71" => "\71"];
goto RrrOy;
D895P:
goto NdGe1;
goto NebNM;
euj2B:
if ($jenjang == "\61") {
goto bOqD1;
}
goto KQ5Ka;
KQ5Ka:
if ($jenjang == "\62") {
goto zCUKn;
}
goto ckNfC;
q44__:
goto NdGe1;
goto OJmaL;
RrrOy:
goto NdGe1;
goto xRJTn;
QMQJk:
}
public function get_guru()
{
goto lup2b;
vLIJz:
X4Vyw:
goto Hh4x0;
Hh4x0:
return $ret;
goto K2moJ;
cXm5w:
foreach ($result as $key => $row) {
$ret[$row->id_guru] = $row->nama_guru;
yp02L:
}
goto MA09A;
YLtrq:
$ret[''] = "\x50\151\x6c\151\150\40\x47\165\x72\165\40\72";
goto QhLlg;
lup2b:
$result = $this->db->get("\155\141\x73\164\x65\162\x5f\147\x75\x72\165")->result();
goto YLtrq;
QhLlg:
if (!$result) {
goto X4Vyw;
}
goto cXm5w;
MA09A:
T5EJo:
goto vLIJz;
K2moJ:
}
public function getWaliKelas($tp, $smt)
{
goto Sb84H;
gteJe:
$this->db->join("\155\141\x73\164\x65\162\137\x67\x75\162\165\x20\x62", "\142\56\151\x64\137\147\165\x72\165\75\141\56\151\x64\137\x67\165\162\165", "\154\x65\146\x74");
goto JllJw;
LyQK9:
if (!$result) {
goto k1qSc;
}
goto Ivqxg;
J30iQ:
$this->db->from("\152\141\x62\141\164\x61\156\137\147\165\x72\165\40\141");
goto gteJe;
Ivqxg:
foreach ($result as $key => $row) {
$ret[$row->id_guru] = $row->nama_guru;
VK8AL:
}
goto Das6s;
wvkLo:
$ret[''] = "\120\151\x6c\151\150\40\107\x75\162\x75\40\72";
goto LyQK9;
H7GKS:
$result = $this->db->get()->result();
goto wvkLo;
Hb826:
k1qSc:
goto w65yv;
w65yv:
return $ret;
goto ELBYO;
Sb84H:
$this->db->select("\x61\x2e\151\144\x5f\x67\165\162\x75\x2c\40\x62\56\156\141\155\141\137\x67\165\x72\x75");
goto J30iQ;
JllJw:
$this->db->where("\x69\144\137\152\141\142\141\164\x61\x6e", "\64")->where("\x69\x64\x5f\x74\x70", $tp)->where("\x69\144\137\163\155\x74", $smt);
goto H7GKS;
Das6s:
i_UnY:
goto Hb826;
ELBYO:
}
public function getKelasEkskul($kelas, $tp, $smt)
{
goto VKwGW;
Mx_iO:
$this->db->from("\x6b\x65\154\141\163\137\x65\x6b\x73\x74\x72\x61");
goto qMy05;
qMy05:
$this->db->where("\151\144\x5f\153\145\x6c\x61\x73", $kelas);
goto rv_hE;
wWQVX:
$this->db->where("\151\x64\x5f\x73\x6d\164", $smt);
goto j3VNa;
j3VNa:
$result = $this->db->get()->result();
goto EZNog;
rv_hE:
$this->db->where("\x69\x64\x5f\x74\x70", $tp);
goto wWQVX;
EZNog:
return $result;
goto RIBFO;
VKwGW:
$this->db->select("\52");
goto Mx_iO;
RIBFO:
}
public function getEkskulById($id)
{
goto R8Nj2;
kDmAf:
$this->db->where("\151\144\x5f\x65\x6b\x73\164\162\x61", $id);
goto iUkSy;
R8Nj2:
$this->db->select("\52");
goto kUF50;
iUkSy:
$result = $this->db->get()->row();
goto nMkva;
nMkva:
return $result;
goto X5zNA;
kUF50:
$this->db->from("\155\x61\163\x74\145\162\137\145\153\163\x74\162\141");
goto kDmAf;
X5zNA:
}
public function getAllSiswa($tp, $smt)
{
goto fqFRw;
lKuat:
$this->db->from("\155\x61\x73\x74\x65\162\137\163\151\x73\x77\141\x20\141");
goto BzWak;
fqFRw:
$this->db->select("\141\x2e\151\x64\137\x73\151\163\x77\141\54\40\x61\x2e\x6e\141\155\141\54\x20\142\56\151\144\137\x6b\x65\154\141\163");
goto lKuat;
IcgqV:
$this->db->join("\142\x75\153\165\x5f\x69\156\x64\165\x6b\x20\x63", "\143\56\151\144\x5f\163\151\163\x77\x61\x3d\141\56\x69\144\x5f\163\151\163\x77\x61\x20\101\x4e\104\40\143\56\x73\x74\x61\x74\165\163\75\61");
goto QtQap;
ap_xv:
return $result;
goto tjhvG;
QtQap:
$this->db->order_by("\x61\56\156\141\155\x61", "\101\123\x43");
goto T_69Q;
T_69Q:
$result = $this->db->get()->result();
goto ap_xv;
BzWak:
$this->db->join("\x6b\145\154\141\x73\x5f\163\151\x73\167\x61\x20\x62", "\142\x2e\x69\144\137\x73\x69\x73\167\141\75\141\56\x69\x64\137\163\151\x73\167\x61\x20\x41\x4e\104\40\142\x2e\x69\144\137\164\160\x3d" . $tp . "\x20\101\116\104\40\x62\56\151\x64\x5f\163\155\x74\75" . $smt, "\x6c\x65\146\x74");
goto IcgqV;
tjhvG:
}
public function get_siswa_kelas($id, $tp, $smt)
{
goto rY6oQ;
rY6oQ:
$this->db->select("\141\x2e\151\144\137\x73\x69\x73\167\x61\x2c\40\x61\x2e\x69\x64\137\x6b\x65\154\141\x73\x2c\x20\x62\56\156\151\x73\54\40\142\x2e\x6e\x61\x6d\141");
goto U9WNB;
KvBrA:
$this->db->where("\x61\x2e\x69\x64\x5f\x74\160", $tp);
goto xQRLr;
xQRLr:
$this->db->where("\x61\x2e\151\144\x5f\163\x6d\x74", $smt);
goto YnI0O;
YT_t1:
$this->db->join("\x62\x75\x6b\x75\137\151\x6e\144\165\153\x20\151", "\151\56\151\144\137\x73\x69\163\x77\x61\x3d\x61\56\151\x64\137\x73\151\163\x77\141\40\x41\116\104\x20\151\x2e\163\x74\141\x74\x75\x73\x3d\x31");
goto ikb0c;
XND2h:
return $result;
goto H6X81;
U9WNB:
$this->db->from("\x6b\145\x6c\x61\163\x5f\x73\151\163\167\141\x20\x61");
goto WD0Nd;
YnI0O:
$this->db->order_by("\142\x2e\x6e\141\155\141", "\101\123\103");
goto PfRx5;
ikb0c:
$this->db->where_in("\x61\56\151\144\137\x6b\145\x6c\141\x73", $id);
goto KvBrA;
PfRx5:
$result = $this->db->get()->result();
goto XND2h;
WD0Nd:
$this->db->join("\x6d\x61\x73\164\145\162\x5f\x73\151\x73\x77\x61\40\x62", "\142\56\151\x64\x5f\x73\151\163\x77\141\x3d\x61\x2e\x69\x64\x5f\163\x69\x73\x77\x61");
goto YT_t1;
H6X81:
}
public function get_status_siswa_kelas($id, $tp, $smt)
{
goto DTMKO;
KfGL2:
$this->db->where("\x61\56\x69\144\137\x74\x70", $tp);
goto dXPuk;
JLkkr:
$ret = [];
goto fnNEv;
l37MJ:
K8Psy:
goto sR1dG;
oEnvP:
$result = $this->db->get()->result();
goto JLkkr;
DRNIJ:
$this->db->from("\x6b\x65\x6c\141\x73\x5f\163\x69\163\167\141\40\141");
goto kLujL;
dXPuk:
$this->db->where("\141\56\151\144\x5f\x73\x6d\164", $smt);
goto oEnvP;
H1_yL:
foreach ($result as $key => $row) {
$ret[$row->id_siswa] = $row;
r3Cdk:
}
goto B4DF6;
DTMKO:
$this->db->select("\x61\x2e\x69\144\x5f\163\x69\163\x77\141\54\x20\141\x2e\x69\144\x5f\153\145\x6c\141\163");
goto DRNIJ;
fnNEv:
if (!$result) {
goto K8Psy;
}
goto H1_yL;
kLujL:
$this->db->where_in("\141\x2e\x69\144\137\153\x65\x6c\x61\x73", $id);
goto KfGL2;
B4DF6:
Xnm11:
goto l37MJ;
sR1dG:
return $ret;
goto BAIdL;
BAIdL:
}
public function getJadwalKbm($tp, $smt, $kelas)
{
goto W0XqN;
MVqos:
$this->db->where("\151\x64\x5f\x74\160", $tp);
goto bl1Ny;
WX1WR:
$result = $this->db->get()->row();
goto vFPV9;
vFPV9:
return $result;
goto xPy04;
bBGTH:
$this->db->where("\x69\x64\x5f\153\145\154\141\x73", $kelas);
goto WX1WR;
bl1Ny:
$this->db->where("\x69\144\137\x73\155\x74", $smt);
goto bBGTH;
y5KTv:
$this->db->from("\153\145\x6c\141\163\137\152\141\144\x77\x61\154\x5f\x6b\142\x6d");
goto MVqos;
W0XqN:
$this->db->select("\52");
goto y5KTv;
xPy04:
}
public function getJadwalKbmByArrKelas($tp, $smt, $arr_kelas)
{
goto V1x6j;
t0xFy:
return $ret;
goto FKB5Y;
zw7R4:
$this->db->where_in("\x69\144\x5f\x6b\x65\x6c\x61\163", $arr_kelas);
goto C9GQG;
PAqWC:
foreach ($result as $key => $row) {
goto LBBeh;
W72by:
edC1W:
goto gwDRY;
uCVuj:
KtmJb:
goto sf5eb;
bylfD:
$ret[$row->id_kelas] = [];
goto XmaMU;
sf5eb:
VPnOC:
goto WauBq;
XmaMU:
array_push($ret[$row->id_kelas], $row);
goto ZluA8;
LBBeh:
if (isset($ret[$row->id_kelas])) {
goto edC1W;
}
goto bylfD;
gwDRY:
array_push($ret[$row->id_kelas], $row);
goto uCVuj;
ZluA8:
goto KtmJb;
goto W72by;
WauBq:
}
goto XW5kx;
XW5kx:
pxqNk:
goto jVofE;
C9GQG:
$result = $this->db->get()->result();
goto y6Shs;
V1x6j:
$this->db->select("\x2a");
goto zMufz;
AP92S:
if (!$result) {
goto wTqsx;
}
goto PAqWC;
zMufz:
$this->db->from("\153\x65\x6c\x61\x73\x5f\x6a\141\144\167\x61\154\x5f\153\x62\155");
goto y1u0A;
M1PQ6:
$this->db->where("\x69\144\x5f\x73\155\164", $smt);
goto zw7R4;
jVofE:
wTqsx:
goto t0xFy;
y6Shs:
$ret = [];
goto AP92S;
y1u0A:
$this->db->where("\151\x64\137\x74\x70", $tp);
goto M1PQ6;
FKB5Y:
}
public function getJadwalMapel($tp, $smt)
{
goto CnsCW;
CnsCW:
$this->db->select("\52");
goto ppP9N;
ppP9N:
$this->db->from("\153\x65\x6c\x61\163\x5f\x6a\141\144\167\x61\154\137\x6d\141\160\145\154\x20\x61");
goto woNnz;
jMb4A:
$ret = [];
goto ZkJjC;
mVVH5:
e8CYY:
goto CVCXw;
c24n8:
vhEIg:
goto mVVH5;
vSGmf:
foreach ($result as $key => $row) {
goto LixlC;
MpeZ7:
taf3Z:
goto fDvX3;
yoKuv:
if (isset($ret[$row->id_mapel][$row->id_kelas])) {
goto taf3Z;
}
goto XmMMh;
A97yK:
gI9k1:
goto szbFU;
fDvX3:
array_push($ret[$row->id_mapel][$row->id_kelas], $row);
goto nzh00;
szbFU:
EY7dP:
goto f3vX_;
ek0A2:
array_push($ret[$row->id_mapel][$row->id_kelas], $row);
goto dEnWQ;
LixlC:
if (!($row->id_mapel != '')) {
goto gI9k1;
}
goto yoKuv;
XmMMh:
$ret[$row->id_mapel][$row->id_kelas] = [];
goto ek0A2;
nzh00:
U_EKk:
goto A97yK;
dEnWQ:
goto U_EKk;
goto MpeZ7;
f3vX_:
}
goto c24n8;
BGMJU:
$result = $this->db->get()->result();
goto jMb4A;
qe1oO:
$this->db->where("\151\x64\137\163\x6d\x74", $smt);
goto BGMJU;
ZkJjC:
if (!$result) {
goto e8CYY;
}
goto vSGmf;
CVCXw:
return $ret;
goto liX0u;
RU4RE:
$this->db->where("\x69\x64\x5f\x74\160", $tp);
goto qe1oO;
woNnz:
$this->db->join("\x6d\141\163\164\145\x72\137\155\141\x70\x65\x6c\x20\x62", "\x61\56\x69\x64\x5f\155\141\x70\x65\x6c\x3d\x62\x2e\x69\x64\137\x6d\141\160\x65\x6c", "\154\145\146\164");
goto RU4RE;
liX0u:
}
public function getJadwalMapelGroupHari($tp, $smt)
{
goto mCfl3;
HfUnw:
$this->db->group_by("\x69\144\x5f\150\141\162\x69");
goto A11Rj;
mCfl3:
$this->db->select("\151\144\x5f\164\x70\54\40\151\x64\x5f\163\x6d\164\x2c\x20\115\101\x58\50\x69\144\x5f\x68\x61\x72\x69\x29\x20\x61\163\40\151\x64\137\x68\x61\x72\x69\54\40\115\x41\130\50\x6a\141\x6d\137\153\145\x29\40\141\163\40\152\141\155\137\x6b\x65");
goto G2AFw;
A11Rj:
$result = $this->db->get()->result();
goto f9UOv;
oo05M:
$this->db->where("\151\x64\137\163\155\164", $smt, FALSE);
goto HfUnw;
f9UOv:
return $result;
goto d0XTg;
BNoRL:
$this->db->where("\x69\x64\x5f\x74\160", $tp, FALSE);
goto oo05M;
G2AFw:
$this->db->from("\153\x65\154\141\163\137\x6a\x61\144\x77\x61\154\137\155\x61\160\145\154");
goto BNoRL;
d0XTg:
}
public function getJadwalMapelGroupJam($tp, $smt, $kelas)
{
goto znrP5;
znrP5:
$this->db->select("\x69\144\137\x74\160\x2c\x20\151\144\137\x73\155\x74\x2c\x20\x4d\101\x58\x28\x69\144\137\x68\x61\x72\x69\51\40\141\x73\x20\x69\x64\x5f\x68\141\x72\151\x2c\40\151\144\137\x6b\x65\x6c\141\163\54\x20\x4d\101\x58\x28\x6a\141\x6d\137\x6b\x65\51\40\x61\163\40\152\141\155\x5f\x6b\x65");
goto KaS_d;
biwyD:
$result = $this->db->get()->result();
goto N4NNL;
KaS_d:
$this->db->from("\153\x65\x6c\x61\x73\137\x6a\141\144\x77\x61\154\137\x6d\x61\160\x65\x6c");
goto mIrUH;
mIrUH:
$this->db->where("\x69\x64\x5f\x74\x70", $tp, FALSE);
goto TD2Nl;
N4NNL:
return $result;
goto yrDGm;
wLjcw:
$this->db->group_by("\x6a\141\x6d\x5f\153\145");
goto biwyD;
FRvr1:
$this->db->where("\151\144\x5f\153\145\154\141\x73", $kelas, FALSE);
goto wLjcw;
TD2Nl:
$this->db->where("\x69\144\137\x73\x6d\x74", $smt, FALSE);
goto FRvr1;
yrDGm:
}
public function getJadwalMapelByJam($hari)
{
goto z4LmP;
xN2Ju:
$this->db->from("\x6b\x65\x6c\141\163\x5f\152\141\x64\x77\x61\154\137\x6d\141\160\x65\x6c\40\141");
goto dGweB;
lBLb_:
$result = $this->db->get()->result();
goto tMPm_;
nVc8v:
$this->db->where("\x69\x64\137\x68\141\x72\x69", $hari, FALSE);
goto lBLb_;
dGweB:
$this->db->join("\155\141\x73\164\145\x72\x5f\155\x61\160\145\x6c\x20\x62", "\x61\56\x69\144\137\x6d\x61\160\x65\x6c\x3d\142\x2e\151\144\137\x6d\141\x70\x65\154", "\x6c\145\x66\x74");
goto nVc8v;
tMPm_:
return $result;
goto JC2c7;
z4LmP:
$this->db->select("\x2a");
goto xN2Ju;
JC2c7:
}
public function getJadwalMapelByMapel($kelas, $mapel = null, $tp, $smt)
{
goto jvrXX;
yy2O1:
$this->db->from("\x6b\145\x6c\141\x73\137\x6a\141\x64\x77\x61\x6c\137\x6d\x61\x70\x65\x6c\x20\141");
goto I1hBw;
I_7g_:
if (!($mapel != null)) {
goto NbpLA;
}
goto cOxKV;
I1hBw:
$this->db->join("\155\x61\163\x74\145\x72\x5f\155\x61\x70\145\154\x20\142", "\141\56\151\144\137\155\141\x70\145\x6c\75\142\56\x69\144\137\x6d\x61\160\145\154", "\x6c\145\x66\x74");
goto lJfFS;
WU_46:
$this->db->where_in("\141\56\x69\x64\137\153\x65\154\x61\x73", $kelas);
goto llulA;
lKNMy:
$this->db->where("\141\x2e\x69\x64\x5f\x73\x6d\x74", $smt, FALSE);
goto I_7g_;
jvrXX:
$this->db->select("\52");
goto yy2O1;
lJfFS:
$this->db->where("\141\x2e\x69\144\137\x74\160", $tp, FALSE);
goto lKNMy;
VIaWq:
NbpLA:
goto WU_46;
llulA:
$result = $this->db->get()->result();
goto n4R9n;
cOxKV:
$this->db->where("\x61\x2e\151\144\x5f\155\141\160\x65\154", $mapel, FALSE);
goto VIaWq;
n4R9n:
return $result;
goto tm1_k;
tm1_k:
}
public function getJadwalTerisi($table, $kelas, $mapel, $tp, $smt)
{
goto Weo17;
YmlmS:
return $result;
goto wFMHh;
mI13b:
$this->db->from($table);
goto G9UxK;
xWr6k:
$this->db->where_in("\151\144\137\x6b\145\154\141\x73", $kelas);
goto T3aGB;
gtF63:
$this->db->where("\151\144\x5f\155\141\x70\x65\x6c", $mapel, FALSE);
goto xWr6k;
Rlkhu:
$this->db->where("\x69\x64\137\163\x6d\164", $smt, FALSE);
goto gtF63;
Weo17:
$this->db->select("\x2a");
goto mI13b;
T3aGB:
$result = $this->db->get()->result();
goto YmlmS;
G9UxK:
$this->db->where("\x69\144\137\x74\160", $tp, FALSE);
goto Rlkhu;
wFMHh:
}
public function getJadwalMapelByHari($tp, $smt, $jam, $kelas)
{
goto XVZdv;
TpuH5:
$this->db->where("\x69\144\137\163\x6d\164", $smt, FALSE);
goto J4O__;
URM1S:
$this->db->where("\151\144\137\164\160", $tp, FALSE);
goto TpuH5;
Vmvms:
$this->db->join("\155\141\x73\164\145\162\137\155\x61\x70\145\154\x20\x62", "\141\56\151\144\137\x6d\141\160\x65\x6c\x3d\x62\56\151\144\x5f\155\141\x70\145\x6c", "\x6c\145\146\164");
goto OAuyJ;
J4O__:
$this->db->where("\151\144\137\153\x65\x6c\141\163", $kelas, FALSE);
goto qwUMH;
qwUMH:
$result = $this->db->get()->result();
goto iEfFL;
XVZdv:
$this->db->select("\52");
goto JFFoR;
JFFoR:
$this->db->from("\153\x65\154\x61\163\x5f\152\141\x64\167\141\154\x5f\x6d\141\x70\145\x6c\x20\141");
goto Vmvms;
OAuyJ:
$this->db->where("\152\141\155\137\x6b\x65", $jam, FALSE);
goto URM1S;
iEfFL:
return $result;
goto xCRY_;
xCRY_:
}
public function getDummyJadwalMapel($tp, $smt, $jam, $kelas)
{
goto Xhyl8;
Xhyl8:
$inputData = [];
goto AMcb2;
UKvrR:
$i++;
goto CpirT;
CzuQ8:
CMDIj:
goto LM5_Z;
Oonx7:
array_push($inputData, $data);
goto CQjUp;
pnz1h:
if (!($i < 7)) {
goto CMDIj;
}
goto elA_J;
gc6rR:
GKKPp:
goto pnz1h;
CQjUp:
pJy1v:
goto UKvrR;
CpirT:
goto GKKPp;
goto CzuQ8;
LM5_Z:
return $inputData;
goto EOLQg;
elA_J:
$data = json_decode(json_encode(["\x69\144\137\x74\x70" => $tp, "\151\144\137\163\155\x74" => $smt, "\x69\x64\x5f\150\141\x72\x69" => $i, "\152\141\x6d\x5f\153\x65" => $jam, "\151\x64\137\x6b\145\154\x61\x73" => $kelas, "\x69\144\x5f\x6d\141\x70\x65\x6c" => "\x30", "\x6e\x61\155\x61\x5f\x6d\x61\160\x65\154" => '', "\153\x6f\x64\145" => '']));
goto Oonx7;
AMcb2:
$i = 1;
goto gc6rR;
EOLQg:
}
public function getDummyMateri()
{
$data = array("\151\x64\x5f\x6d\141\164\145\162\151" => '', "\153\x6f\x64\x65\x5f\x6d\141\x74\x65\162\151" => '', "\x69\144\x5f\147\x75\162\x75" => '', "\x69\x64\x5f\155\x61\160\x65\154" => '', "\151\144\137\x6a\141\x64\167\141\154" => '', "\155\141\x74\145\x72\x69\137\x6b\145\x6c\141\163" => serialize([]), "\x6b\145\x6c\x61\163\137\x67\x75\x72\x75" => serialize([]), "\x6a\x75\144\165\154\x5f\155\x61\164\x65\x72\151" => '', "\151\x73\x69\137\x6d\141\164\145\162\151" => '', "\146\151\x6c\x65" => '', "\x6c\151\x6e\x6b\137\146\x69\154\145" => '', "\x74\x67\154\137\x6d\x75\x6c\x61\x69" => '', "\x63\x72\145\x61\164\145\x64\x5f\157\156" => '', "\165\160\144\x61\x74\x65\x64\x5f\157\156" => '');
return $data;
}
public function getTableMateriKelas($id_guru = null)
{
goto d2VTi;
Nx0M9:
$this->datatables->from("\153\145\154\141\x73\x5f\x6d\141\x74\x65\162\x69\40\x61");
goto TB6OU;
TB6OU:
$this->datatables->join("\155\x61\x73\x74\145\162\x5f\x67\x75\x72\x75\40\142", "\x61\56\x69\x64\137\147\x75\162\165\75\142\x2e\151\x64\x5f\147\165\162\x75");
goto LUS4o;
LUS4o:
$this->datatables->join("\x6a\x61\x62\141\x74\x61\156\x5f\x67\165\x72\165\40\x63", "\141\56\151\x64\x5f\x67\x75\162\165\75\143\x2e\x69\144\x5f\147\x75\162\165");
goto yVZmU;
yVZmU:
$this->datatables->join("\x6b\145\x6c\141\x73\137\x6a\141\x64\167\x61\x6c\137\x6d\x61\x70\x65\154\x20\x64", "\141\x2e\x69\x64\x5f\155\x61\160\x65\x6c\x3d\x64\x2e\151\144\137\x6d\141\x70\x65\x6c");
goto ZigRt;
ZigRt:
return $this->datatables->generate();
goto KQYTq;
d2VTi:
$this->datatables->select("\x2a");
goto Nx0M9;
KQYTq:
}
public function getMateriKelas($id_guru, $tp, $smt)
{
goto ithtX;
BHtE0:
$this->db->join("\x6d\141\163\164\145\162\137\147\x75\162\165\40\x62", "\141\x2e\151\x64\137\147\165\162\x75\x3d\x62\x2e\151\144\x5f\x67\x75\x72\165");
goto WHmha;
ithtX:
$this->db->select("\x61\56\x69\144\137\155\x61\164\x65\x72\151\x2c\x20\141\56\153\157\x64\145\x5f\x6d\141\164\145\x72\x69\x2c\x20\141\x2e\153\x6f\x64\x65\137\x6d\x61\x70\145\x6c\x2c\x20\x61\56\152\165\144\x75\154\137\x6d\141\x74\x65\162\151\x2c\x20\141\56\155\x61\x74\145\x72\x69\x5f\153\145\154\x61\x73\x2c\x20\x66\56\x6e\x61\155\141\137\163\155\x74\54\40\145\56\164\x61\150\x75\156\54" . "\40\x61\x2e\151\144\x5f\155\x61\160\145\154\54\x20\141\x2e\143\x72\145\141\164\145\x64\137\x6f\156\54\x20\141\x2e\x75\x70\144\x61\164\145\x64\x5f\x6f\x6e\54\x20\141\x2e\146\x69\154\x65\x2c\x20\x61\56\x73\x74\141\x74\165\x73\54\40\x61\x2e\151\144\137\x74\160\x2c\40\141\56\x69\144\x5f\x73\155\x74\54\x20\142\x2e\156\141\155\x61\x5f\147\165\x72\x75\x2c\x20\x64\x2e\x6e\x61\155\141\x5f\155\x61\x70\x65\154\x2c\40\x64\x2e\153\157\144\x65");
goto KIzIj;
ayeXR:
$result = $this->db->get()->result();
goto HZnHv;
TyRRb:
$this->db->where("\141\56\x69\144\137\x74\160", $tp);
goto Wbd2e;
UcUhZ:
$this->db->order_by("\141\x2e\143\162\x65\x61\x74\x65\144\137\x6f\x6e", "\104\105\123\103");
goto ayeXR;
KIzIj:
$this->db->from("\153\145\154\141\163\137\x6d\x61\x74\145\162\151\x20\141");
goto BHtE0;
HZnHv:
return $result;
goto n9ymq;
OLxHi:
$this->db->where("\141\56\x69\x64\x5f\147\x75\x72\165", $id_guru);
goto TyRRb;
FyG3j:
$this->db->join("\155\x61\163\x74\145\x72\137\163\x6d\x74\x20\146", "\141\x2e\x69\x64\x5f\163\155\164\x3d\146\56\151\x64\x5f\163\x6d\164");
goto OLxHi;
WHmha:
$this->db->join("\155\x61\163\x74\x65\162\x5f\x6d\x61\x70\145\154\40\x64", "\141\x2e\x69\144\x5f\155\141\x70\145\x6c\x3d\x64\x2e\x69\144\137\155\141\x70\145\154", "\154\x65\x66\x74");
goto jkLTr;
Wbd2e:
$this->db->where("\x61\x2e\x69\144\137\x73\x6d\x74", $smt);
goto UcUhZ;
jkLTr:
$this->db->join("\x6d\141\x73\x74\x65\162\137\164\x70\x20\145", "\x61\x2e\151\x64\x5f\x74\160\x3d\x65\56\151\144\137\164\x70");
goto FyG3j;
n9ymq:
}
public function getAllMateriByKelas($tp, $smt)
{
goto d0hhV;
SUXXu:
$this->db->order_by("\x61\56\143\x72\145\x61\x74\x65\144\137\157\x6e", "\104\x45\x53\103");
goto rm7v4;
rm7v4:
$result = $this->db->get()->result();
goto sgUzK;
xEuKn:
return $ret;
goto PdERn;
Nkjyy:
R37ax:
goto n0DDv;
YLKPq:
$this->db->where("\x61\x2e\x69\144\137\163\x6d\164", $smt);
goto SUXXu;
n0DDv:
Azx7C:
goto xEuKn;
voFYR:
$this->db->where("\x61\56\x69\x64\x5f\164\x70", $tp);
goto YLKPq;
IJsOA:
$this->db->join("\x6d\x61\x73\x74\x65\162\x5f\147\165\x72\x75\40\x62", "\141\56\151\144\x5f\147\x75\162\165\x3d\142\x2e\x69\x64\x5f\x67\165\x72\x75");
goto rVH4t;
uQfyt:
$this->db->from("\x6b\x65\x6c\141\163\x5f\x6d\141\x74\145\x72\x69\40\x61");
goto IJsOA;
d0hhV:
$this->db->select("\x61\x2e\x6a\145\x6e\x69\163\x2c\40\x61\56\151\144\x5f\x6d\x61\160\x65\154\54\40\x61\56\151\144\137\x6d\141\164\145\162\151\x2c\40\141\56\x6b\157\144\x65\137\155\x61\x74\145\162\151");
goto uQfyt;
o0k7r:
foreach ($result as $key => $row) {
$ret[$row->id_mapel][$row->jenis][$row->id_materi] = $row->kode_materi;
gS1Af:
}
goto Nkjyy;
SuGqC:
$this->db->where("\x61\x2e\163\x74\141\164\x75\x73", "\x31");
goto voFYR;
fIRuJ:
if (!$result) {
goto Azx7C;
}
goto o0k7r;
rVH4t:
$this->db->join("\x6d\141\x73\164\x65\162\x5f\x6d\141\x70\x65\154\x20\x63", "\141\56\x69\x64\137\x6d\x61\160\x65\x6c\x3d\x63\56\151\144\137\155\141\x70\145\x6c", "\154\x65\146\x74");
goto SuGqC;
sgUzK:
$ret = [];
goto fIRuJ;
PdERn:
}
public function getAllJadwalMateriByKelas($tp, $smt)
{
goto e1gqN;
b4zJc:
$this->db->order_by("\x63\x2e\x63\162\x65\141\164\x65\144\x5f\x6f\156", "\x44\x45\x53\x43");
goto IgeES;
wrt4W:
foreach ($result as $key => $row) {
$ret[$row->jenis][$row->id_kjm] = $row;
xGnQI:
}
goto DEiJS;
e1gqN:
$this->db->select("\141\x2e\x6a\x65\156\x69\163\x2c\x20\x61\x2e\x69\x64\x5f\155\x61\x74\x65\x72\151\x2c\x20\x61\56\151\144\137\x74\x70\x2c\x20\141\x2e\x69\x64\137\163\155\164\54\40\x61\56\x69\144\137\x6d\141\x70\145\154\x2c\x20\x61\56\151\144\x5f\x6b\x6a\x6d\54\x20\141\56\x69\144\x5f\x6b\x65\x6c\x61\x73\x2c\x20\x61\x2e\x6a\x61\x64\167\141\154\137\155\141\x74\x65\x72\151\54" . "\x20\143\x2e\153\157\144\x65\x5f\x6d\x61\164\145\162\x69\54\40\143\x2e\152\x75\144\165\x6c\137\x6d\141\x74\x65\x72\x69\x2c\x20\143\x2e\143\162\145\x61\x74\x65\144\x5f\157\x6e\x2c\40\x63\56\x75\160\144\x61\164\x65\x64\x5f\x6f\156\x2c\x20\x63\x2e\x66\x69\154\145\x2c\x20\x63\56\x73\164\x61\x74\x75\163\x2c" . "\x20\142\56\156\x61\155\x61\137\x67\x75\162\165\54\x20\x64\56\x6e\x61\155\x61\137\155\x61\160\x65\154\54\x20\x64\56\x6b\x6f\144\145");
goto Q5JF1;
CPxSn:
$ret = [];
goto KQqBT;
KQqBT:
if (!$result) {
goto BLgpR;
}
goto wrt4W;
PY6HO:
return $ret;
goto ca_Hv;
gpGMs:
$this->db->where("\x61\x2e\x69\x64\x5f\x74\x70", $tp);
goto mbSbH;
mbSbH:
$this->db->where("\141\56\151\144\x5f\163\155\x74", $smt);
goto b4zJc;
IgeES:
$result = $this->db->get()->result();
goto CPxSn;
LHp0x:
$this->db->join("\x6b\145\154\x61\x73\137\x6d\141\164\145\x72\151\x20\143", "\x61\56\151\x64\137\x6d\141\164\x65\162\x69\x3d\x63\x2e\151\x64\137\155\141\164\x65\162\151", "\x6c\x65\x66\x74");
goto ln7EF;
dVNfR:
BLgpR:
goto PY6HO;
fdZYT:
$this->db->join("\x6d\141\163\x74\145\x72\x5f\x6d\x61\160\x65\x6c\x20\144", "\141\56\x69\x64\137\x6d\141\x70\145\154\75\144\56\151\x64\137\x6d\x61\x70\x65\154", "\x6c\145\146\x74");
goto gpGMs;
ln7EF:
$this->db->join("\x6d\141\163\x74\x65\x72\x5f\x67\165\x72\x75\x20\x62", "\143\56\151\x64\137\x67\x75\162\x75\x3d\x62\56\x69\x64\137\147\x75\x72\x75");
goto fdZYT;
Q5JF1:
$this->db->from("\153\x65\154\141\163\137\x6a\141\x64\x77\x61\x6c\137\x6d\x61\164\145\162\x69\40\141");
goto LHp0x;
DEiJS:
G0uTG:
goto dVNfR;
ca_Hv:
}
public function getAllMateriKelas($id_guru, $jenis)
{
goto vzXTx;
Esq2G:
$result = $this->db->get()->result();
goto So6bQ;
So6bQ:
return $result;
goto GmdUu;
wrTcH:
$this->db->join("\x6d\141\163\x74\x65\x72\x5f\x6d\141\160\145\x6c\x20\144", "\x61\x2e\x69\144\137\155\x61\x70\x65\154\75\x64\56\151\144\x5f\x6d\141\160\145\x6c\40\x4f\x52\40\141\x2e\153\x6f\x64\x65\x5f\x6d\x61\x70\145\154\x3d\x64\x2e\153\157\x64\x65", "\x6c\x65\146\164");
goto QcyWw;
F3O2U:
$this->db->where("\x61\x2e\151\x64\137\147\165\x72\165", $id_guru);
goto znSwf;
q1rlk:
$this->db->order_by("\141\x2e\143\162\145\x61\164\145\144\137\x6f\x6e", "\104\x45\x53\x43");
goto Esq2G;
znSwf:
ne4jz:
goto q1rlk;
kbrNV:
$this->db->where("\x61\x2e\152\145\x6e\151\163", $jenis);
goto A3Sp1;
QcyWw:
$this->db->join("\x6d\141\163\x74\145\x72\x5f\164\x70\x20\x65", "\x61\56\151\144\x5f\164\160\75\x65\x2e\x69\144\x5f\164\x70", "\x6c\145\146\x74");
goto I4sji;
C8LW_:
$this->db->from("\x6b\145\x6c\141\163\x5f\155\141\164\145\162\151\40\141");
goto Quops;
vzXTx:
$this->db->select("\141\56\x69\144\x5f\155\141\x74\x65\162\151\54\40\x61\56\153\157\144\145\x5f\x6d\x61\x74\145\x72\151\54\40\141\x2e\153\x6f\x64\x65\x5f\x6d\141\160\x65\x6c\x2c\40\x61\56\x6a\x75\144\165\154\x5f\x6d\x61\x74\145\162\151\54\40\x61\56\x6d\x61\164\145\x72\151\137\153\145\154\x61\x73\x2c\40\x66\x2e\156\x61\155\x61\137\x73\155\164\54\x20\x65\x2e\164\141\150\x75\156\x2c\40\146\56\163\x6d\164\54" . "\x20\x61\56\151\144\x5f\155\141\x70\145\x6c\x2c\x20\x61\x2e\143\162\x65\x61\x74\x65\x64\x5f\157\x6e\x2c\40\x61\x2e\165\x70\x64\x61\164\x65\144\137\157\156\54\40\x61\56\x66\x69\154\145\54\x20\x61\56\x73\164\x61\164\x75\x73\x2c\x20\x61\x2e\x69\x64\137\x74\x70\x2c\x20\x61\x2e\151\144\x5f\163\x6d\x74\54\x20\x62\x2e\156\141\155\x61\137\147\165\x72\165\x2c\x20\144\56\x6e\x61\155\141\137\x6d\141\160\x65\x6c\54\40\144\56\153\x6f\x64\x65");
goto C8LW_;
Quops:
$this->db->join("\155\141\163\x74\145\x72\x5f\x67\165\162\165\40\x62", "\141\x2e\x69\x64\x5f\x67\x75\162\165\75\x62\x2e\151\144\137\147\165\x72\x75", "\x6c\145\146\x74");
goto wrTcH;
A3Sp1:
if (!($id_guru != "\x30")) {
goto ne4jz;
}
goto F3O2U;
I4sji:
$this->db->join("\x6d\141\163\164\x65\x72\x5f\x73\x6d\x74\40\x66", "\141\56\151\x64\137\163\155\x74\x3d\x66\56\x69\144\137\163\x6d\164", "\x6c\145\x66\x74");
goto kbrNV;
GmdUu:
}
public function getMateriKelasById($id_materi, $jenis)
{
goto YYxlL;
cVURA:
$result = $this->db->get()->row();
goto PPX7e;
a_Vn6:
$this->db->where("\141\x2e\x69\x64\x5f\x6d\141\164\x65\162\151", $id_materi);
goto CtXX4;
g5I6E:
$this->db->from("\153\145\x6c\x61\x73\x5f\155\x61\164\145\162\x69\40\x61");
goto P5KHF;
YYxlL:
$this->db->select("\141\56\x2a\54\40\x62\x2e\x6e\x61\155\141\x5f\147\165\162\x75\54\40\142\56\x66\x6f\x74\x6f\x2c\x20\144\56\151\144\137\155\141\160\x65\x6c\54\40\x64\56\x6e\x61\155\141\x5f\155\x61\x70\145\154\x2c\x20\x63\56\x6d\x61\x70\x65\154\137\x6b\x65\154\141\x73\40\141\163\40\x6b\x65\x6c\x61\x73\x5f\147\x75\162\165");
goto g5I6E;
pnZJ5:
$this->db->join("\152\141\142\x61\x74\141\x6e\x5f\x67\x75\162\x75\x20\143", "\141\56\x69\x64\137\147\x75\162\165\x3d\143\56\x69\144\x5f\x67\x75\x72\165", "\154\x65\146\x74");
goto HlZMk;
PPX7e:
return $result;
goto z0RIE;
P5KHF:
$this->db->join("\155\141\x73\x74\145\x72\x5f\x67\165\x72\x75\40\142", "\x61\56\151\x64\x5f\x67\x75\x72\165\x3d\x62\56\151\x64\137\x67\165\x72\x75", "\x6c\145\x66\164");
goto pnZJ5;
CtXX4:
$this->db->where("\141\56\x6a\145\x6e\151\x73", $jenis);
goto cVURA;
HlZMk:
$this->db->join("\x6d\x61\163\164\145\x72\137\155\x61\160\x65\x6c\x20\144", "\x61\x2e\151\x64\137\155\141\160\145\154\x3d\x64\x2e\x69\x64\137\155\141\x70\x65\154", "\154\145\x66\x74");
goto a_Vn6;
z0RIE:
}
public function getMateriKelasSiswa($id_kjm, $jenis)
{
goto bPB4y;
WHu6V:
$this->db->join("\x6a\141\142\x61\164\x61\156\x5f\147\x75\162\x75\x20\x64", "\x62\56\151\x64\137\147\x75\162\x75\x3d\x64\56\x69\144\137\x67\x75\x72\x75");
goto IoRYN;
IoRYN:
$this->db->join("\x6d\141\163\164\145\162\x5f\155\141\x70\x65\154\x20\x65", "\x62\x2e\151\144\x5f\155\141\160\145\x6c\x3d\145\56\151\144\x5f\155\x61\x70\x65\154");
goto cr1ac;
cr1ac:
$this->db->where("\141\x2e\152\x65\x6e\x69\x73", $jenis);
goto phHbn;
Y2Olr:
$this->db->from("\153\145\x6c\141\163\137\152\x61\x64\167\x61\x6c\137\x6d\x61\164\x65\162\x69\40\x61");
goto nyIUN;
nyIUN:
$this->db->join("\153\145\x6c\x61\x73\137\155\x61\164\x65\x72\151\40\x62", "\x61\56\x69\x64\x5f\155\141\x74\x65\x72\151\75\142\x2e\151\x64\137\155\141\164\145\x72\x69");
goto cyqmI;
ClD8f:
return $result;
goto tDhm4;
Z7GvG:
$result = $this->db->get()->row();
goto ClD8f;
cyqmI:
$this->db->join("\155\141\163\x74\145\x72\137\x67\x75\162\x75\x20\143", "\x62\x2e\x69\x64\137\147\x75\x72\x75\x3d\143\56\151\x64\x5f\147\x75\x72\165");
goto WHu6V;
phHbn:
$this->db->where("\x61\x2e\151\144\x5f\x6b\152\x6d", $id_kjm);
goto Z7GvG;
bPB4y:
$this->db->select("\x61\56\x69\x64\x5f\x6b\x6a\155\x2c\40\141\x2e\x69\x64\x5f\155\141\x74\145\x72\151\54\40\141\x2e\152\141\144\x77\141\154\x5f\x6d\141\164\145\x72\151\54\40\x62\56\x2a\x2c\x20\143\x2e\156\141\155\141\x5f\147\x75\162\165\x2c\40\x63\x2e\x66\x6f\164\157\54\40\145\x2e\151\144\x5f\x6d\141\x70\x65\154\x2c\x20\x65\56\x6e\141\155\x61\137\155\141\160\145\x6c\54\x20\x64\56\155\x61\160\x65\154\x5f\153\145\154\141\x73\x20\x61\x73\40\x6b\145\x6c\141\x73\137\147\165\x72\x75");
goto Y2Olr;
tDhm4:
}
public function getGuruMapelKelas($id_guru, $tp, $smt)
{
goto Igo32;
NwhLc:
$result = $this->db->get()->row();
goto oUJZD;
oUJZD:
return $result;
goto TBJoe;
RBufj:
$this->db->where("\x61\56\151\x64\137\147\165\162\x75", $id_guru);
goto NwhLc;
hifuK:
$this->db->from("\155\141\x73\x74\x65\162\x5f\x67\165\x72\x75\x20\x61");
goto MmuhB;
Igo32:
$this->db->select("\141\x2e\x69\144\x5f\x67\x75\162\165\54\40\x61\56\x6e\141\x6d\x61\x5f\x67\x75\162\165\x2c\x20\x61\x2e\153\x6f\144\145\137\x67\165\x72\165\54\x20\x62\x2e\155\x61\160\x65\154\137\153\x65\154\141\163\54\x20\x62\56\x65\153\163\x74\x72\x61\x5f\x6b\x65\x6c\x61\x73\x2c\x20\x64\x2e\x6e\x61\x6d\141\137\x6b\145\x6c\141\163");
goto hifuK;
MmuhB:
$this->db->join("\152\141\142\141\164\x61\x6e\137\147\x75\162\165\x20\x62", "\141\x2e\x69\x64\137\x67\165\x72\x75\75\142\x2e\x69\144\137\x67\165\162\165\40\101\x4e\x44\x20\x62\x2e\151\144\137\x74\x70\75" . $tp . "\40\x41\116\104\x20\142\56\151\x64\137\x73\155\x74\x3d" . $smt . '', "\x6c\145\146\164");
goto LYKmj;
qx35a:
$this->db->join("\x6d\141\163\164\x65\162\x5f\x6b\x65\x6c\x61\x73\40\x64", "\x62\x2e\151\x64\137\153\145\x6c\141\163\75\144\56\x69\144\137\153\145\154\141\163\40\x41\116\104\x20\144\x2e\x69\144\x5f\x74\160\75" . $tp . "\x20\x41\116\x44\40\x64\56\151\x64\x5f\x73\155\x74\x3d" . $smt . '', "\x6c\145\146\164");
goto RBufj;
LYKmj:
$this->db->join("\154\145\166\x65\x6c\x5f\x67\x75\x72\x75\x20\143", "\x62\x2e\x69\x64\x5f\152\141\x62\x61\164\141\156\75\143\56\x69\x64\x5f\x6c\145\x76\145\154", "\x6c\x65\x66\x74");
goto qx35a;
TBJoe:
}
public function getMapelGuruKelas($tp, $smt)
{
goto hwpL1;
DTNOB:
$result = $this->db->get()->result();
goto uhEHW;
wlTAk:
$this->db->from("\155\x61\163\x74\145\x72\137\x67\x75\x72\x75\x20\141");
goto EStCu;
uhEHW:
return $result;
goto hlA0T;
GugUY:
$this->db->join("\x6c\x65\166\145\154\x5f\x67\x75\162\165\40\x63", "\x62\56\151\x64\137\152\x61\x62\x61\164\141\x6e\75\x63\x2e\151\144\x5f\154\145\x76\145\154", "\x6c\145\146\x74");
goto rWKf3;
rWKf3:
$this->db->join("\155\x61\x73\x74\x65\162\137\153\145\154\x61\163\x20\144", "\x62\x2e\x69\144\x5f\153\x65\154\x61\x73\x3d\x64\x2e\151\144\x5f\153\145\154\141\163\40\x41\x4e\104\x20\x64\56\151\x64\x5f\164\160\x3d" . $tp . "\x20\101\x4e\104\x20\x64\56\x69\144\x5f\x73\155\164\75" . $smt . '', "\x6c\x65\146\x74");
goto DTNOB;
EStCu:
$this->db->join("\152\x61\x62\141\164\x61\156\x5f\x67\165\x72\165\x20\142", "\x61\x2e\x69\144\x5f\x67\165\x72\165\75\x62\x2e\151\144\137\147\x75\x72\165\x20\x41\x4e\x44\x20\x62\x2e\151\144\x5f\164\160\x3d" . $tp . "\40\x41\116\104\40\x62\56\151\144\x5f\163\x6d\x74\x3d" . $smt . '', "\154\145\146\164");
goto GugUY;
hwpL1:
$this->db->select("\141\56\x69\x64\x5f\x67\x75\162\165\x2c\40\141\x2e\x6e\x61\155\x61\137\x67\165\x72\x75\54\40\141\x2e\153\x6f\x64\x65\137\x67\165\x72\165\x2c\40\142\56\x6d\x61\x70\145\154\x5f\x6b\x65\154\141\x73\x2c\x20\x62\56\145\153\163\164\x72\141\x5f\153\x65\154\141\163\54\40\144\x2e\156\x61\x6d\141\x5f\x6b\x65\x6c\141\x73");
goto wlTAk;
hlA0T:
}
public function getListGuruMapelKelas($tp, $smt)
{
goto ULpq4;
ULpq4:
$this->db->select("\x61\x2e\x69\144\x5f\147\165\x72\x75\54\x20\x61\56\x6e\141\x6d\x61\137\147\x75\162\165\54\40\141\x2e\153\157\144\x65\137\147\165\162\x75\x2c\x20\142\56\155\141\x70\145\x6c\x5f\x6b\145\x6c\141\163\54\40\142\56\145\x6b\163\x74\162\x61\x5f\153\145\154\x61\x73\54\x20\x64\x2e\x6e\141\155\141\x5f\x6b\145\154\x61\163");
goto fm5bm;
FO0M4:
return $rest;
goto zPJz5;
DY2tX:
$rest = [];
goto q1RY6;
fm5bm:
$this->db->from("\155\141\163\x74\145\162\x5f\147\x75\162\165\x20\x61");
goto SKfKq;
q1RY6:
foreach ($result as $guru) {
$rest[$guru->id_guru] = $guru;
i2FDo:
}
goto L4INH;
L4INH:
S201D:
goto FO0M4;
SKfKq:
$this->db->join("\x6a\x61\142\141\x74\141\x6e\137\x67\x75\162\x75\x20\x62", "\x61\56\x69\144\137\x67\x75\162\x75\x3d\x62\x2e\x69\144\x5f\147\165\162\165\40\101\116\104\40\142\x2e\151\144\x5f\164\160\75" . $tp . "\x20\x41\116\x44\40\142\56\x69\x64\137\163\155\x74\x3d" . $smt . '', "\154\145\146\164");
goto UXWQU;
PeGsb:
$result = $this->db->get()->result();
goto DY2tX;
ko4sV:
$this->db->join("\x6d\x61\x73\164\x65\162\137\x6b\145\x6c\141\163\x20\x64", "\x62\x2e\x69\x64\137\x6b\x65\154\x61\163\x3d\x64\56\151\144\137\153\145\x6c\x61\x73\x20\101\116\x44\x20\144\56\151\x64\x5f\x74\x70\75" . $tp . "\x20\x41\x4e\104\x20\x64\56\x69\144\x5f\163\x6d\x74\x3d" . $smt . '', "\x6c\x65\x66\x74");
goto PeGsb;
UXWQU:
$this->db->join("\x6c\x65\x76\x65\x6c\x5f\147\x75\x72\165\40\143", "\142\x2e\151\x64\x5f\x6a\141\x62\x61\164\x61\156\x3d\143\x2e\151\144\137\x6c\x65\166\145\154", "\154\145\146\x74");
goto ko4sV;
zPJz5:
}
public function getIdKelas($tp, $smt)
{
goto KH_Rq;
drm8L:
$ret = [];
goto zocRg;
KH_Rq:
$this->db->select("\151\144\137\153\x65\x6c\x61\163");
goto Duxbh;
L6LsC:
foreach ($result as $key => $row) {
array_push($ret, $row->id_kelas);
H3r9x:
}
goto Wn_BU;
Wn_BU:
SHxRI:
goto SjjeW;
zPI53:
$result = $this->db->get("\x6d\x61\163\x74\145\162\137\x6b\x65\x6c\x61\x73")->result();
goto drm8L;
vSmZD:
return $ret;
goto XWtCS;
Duxbh:
$this->db->where("\151\144\x5f\x74\x70", $tp);
goto FXixl;
FXixl:
$this->db->where("\x69\144\x5f\x73\155\164", $smt);
goto zPI53;
SjjeW:
oYQhH:
goto vSmZD;
zocRg:
if (!$result) {
goto oYQhH;
}
goto L6LsC;
XWtCS:
}
public function getNamaKelasById($arr_id)
{
goto CIaYh;
rt1fM:
$result = $this->db->get("\x6d\141\x73\164\145\x72\x5f\x6b\145\x6c\x61\163")->result();
goto tPJFD;
qU0xm:
return $ret;
goto ZcgRv;
tIF6e:
foreach ($result as $key => $row) {
$ret[$row->id_kelas] = $row->nama_kelas;
DilYC:
}
goto vC_SM;
vC_SM:
AnmPc:
goto eCT2T;
P9T4Y:
$this->db->where_in("\x69\x64\x5f\x6b\145\x6c\x61\163", $arr_id);
goto rt1fM;
eCT2T:
zr3aF:
goto qU0xm;
tPJFD:
$ret = null;
goto VSXxC;
VSXxC:
if (!$result) {
goto zr3aF;
}
goto tIF6e;
CIaYh:
$this->db->select("\151\144\137\153\145\154\141\163\54\40\x6e\x61\x6d\x61\137\x6b\x65\154\141\163");
goto P9T4Y;
ZcgRv:
}
public function getNamaKelasByKode($arr_kode)
{
goto IEgxQ;
tKAP7:
UHJfa:
goto qaQDi;
CXKJd:
if (!$result) {
goto UHJfa;
}
goto XTmqA;
BIlr_:
$ret = null;
goto CXKJd;
OyKPW:
$this->db->where_in("\153\157\144\145\x5f\153\145\x6c\141\x73", $arr_kode);
goto mkUTp;
qaQDi:
return $ret;
goto sKX1C;
mkUTp:
$result = $this->db->get("\x6d\141\x73\164\x65\x72\x5f\153\145\x6c\x61\163")->result();
goto BIlr_;
XTmqA:
foreach ($result as $key => $row) {
$ret[$row->id_kelas] = $row->nama_kelas;
qKSno:
}
goto KMrwu;
IEgxQ:
$this->db->select("\151\x64\x5f\153\145\154\141\163\x2c\40\x6e\x61\x6d\141\137\x6b\145\154\141\x73");
goto OyKPW;
KMrwu:
mo924:
goto tKAP7;
sKX1C:
}
public function getJadwalByMateri($id, $jenis, $tp, $smt)
{
goto sUigi;
VOflf:
if (!$result) {
goto STe86;
}
goto MAcKx;
uqUWr:
$this->db->where("\x69\x64\137\x6d\x61\x74\x65\x72\151", $id);
goto Mrlag;
aHEYu:
$result = $this->db->get("\x6b\145\x6c\x61\163\137\152\x61\x64\167\x61\154\137\155\x61\x74\145\x72\151")->result();
goto Sza2a;
sUigi:
$this->db->select("\151\x64\137\x6b\x6a\x6d\x2c\40\151\x64\137\x6b\145\x6c\141\x73\x2c\x20\x6a\141\144\x77\x61\x6c\137\155\141\164\x65\x72\x69\54\x20\x28\123\x45\x4c\x45\x43\124\x20\103\x4f\125\x4e\124\50\x69\144\x5f\155\x61\x74\145\x72\x69\x29\x20\x46\x52\x4f\115\40\x6c\x6f\x67\x5f\x6d\x61\x74\145\162\x69\40\x57\110\x45\x52\105\x20\153\145\154\x61\x73\x5f\x6a\141\x64\x77\141\154\x5f\x6d\141\x74\x65\x72\151\56\x69\x64\137\153\x6a\155\x3d\x6c\x6f\x67\x5f\x6d\x61\x74\x65\162\151\56\x69\144\x5f\x6d\141\164\x65\162\x69\x29\40\x41\x53\40\152\x6d\154\x5f\163\x69\163\167\141");
goto uqUWr;
Mrlag:
$this->db->where("\152\145\156\151\x73", $jenis);
goto w1QLu;
MAcKx:
foreach ($result as $key => $row) {
goto KGzDM;
bX37P:
array_push($ret[$row->id_kelas], $row);
goto ukrwQ;
krwCo:
WiS63:
goto SYI14;
HIfBH:
ttdKB:
goto bqG0T;
ukrwQ:
goto Wj6iV;
goto HIfBH;
KGzDM:
if (isset($ret[$row->id_kelas])) {
goto ttdKB;
}
goto RIDIb;
bqG0T:
array_push($ret[$row->id_kelas], $row);
goto zwhOI;
RIDIb:
$ret[$row->id_kelas] = [];
goto bX37P;
zwhOI:
Wj6iV:
goto krwCo;
SYI14:
}
goto YkKwy;
RLbnY:
return $ret;
goto ShygK;
hv_g0:
STe86:
goto RLbnY;
Sza2a:
$ret = [];
goto VOflf;
YkKwy:
Vz4DS:
goto hv_g0;
OZKkz:
$this->db->where("\x69\144\137\x73\x6d\164", $smt);
goto aHEYu;
w1QLu:
$this->db->where("\151\144\x5f\164\x70", $tp);
goto OZKkz;
ShygK:
}
public function getKodeMateriMapel($id_tp, $id_smt, $id_mapel)
{
goto Wos2A;
i7dkK:
$this->db->join("\x6b\145\154\x61\163\x5f\152\141\144\x77\141\x6c\x5f\155\141\164\x65\x72\151\x20\143", "\x61\56\151\144\137\x6d\x61\x74\x65\x72\x69\x3d\x63\x2e\x69\144\x5f\x6d\141\164\x65\x72\x69");
goto lDxKT;
lDxKT:
$this->db->join("\x6d\141\x73\164\x65\162\137\147\x75\162\x75\x20\x64", "\x61\x2e\x69\x64\137\x67\165\162\165\75\x64\x2e\151\x64\137\147\165\162\x75");
goto tOJ6z;
EJK3M:
$this->db->where("\141\x2e\x69\144\x5f\x73\x6d\164", $id_smt);
goto z5W6o;
mthhu:
return $result;
goto BA3EZ;
e9pdZ:
$this->db->from("\x6b\145\x6c\x61\163\x5f\155\141\x74\x65\x72\x69\40\141");
goto y2fsb;
y2fsb:
$this->db->join("\155\141\x73\164\x65\162\x5f\155\x61\x70\x65\154\x20\142", "\142\x2e\x69\144\x5f\155\x61\x70\x65\x6c\x3d\141\56\151\144\137\x6d\141\160\145\154", "\154\145\x66\164");
goto i7dkK;
A6NKD:
$this->db->where("\141\x2e\151\144\137\x74\x70", $id_tp);
goto EJK3M;
tOJ6z:
$this->db->where("\141\x2e\151\144\x5f\x6d\141\x70\145\x6c", $id_mapel);
goto A6NKD;
z5W6o:
$result = $this->db->get()->result();
goto mthhu;
Wos2A:
$this->db->select("\x61\56\x69\144\x5f\x6d\x61\160\x65\154\54\40\x61\56\x69\x64\137\155\141\164\145\162\x69\54\x20\x61\x2e\x6a\x65\156\151\x73\x2c\40\141\x2e\x6b\x6f\144\x65\137\155\x61\164\145\x72\x69\x2c\40\x61\x2e\155\x61\164\x65\x72\x69\x5f\x6b\x65\x6c\141\x73\54\40\x61\x2e\x69\x64\x5f\147\x75\x72\x75\54\40\142\56\153\x6f\144\x65\x20\141\163\x20\153\x6f\144\145\x5f\155\x61\x70\x65\154\54\x20\x63\x2e\151\144\137\x6b\x6a\x6d\54\40\143\x2e\x6a\x61\x64\167\x61\154\137\x6d\x61\x74\145\162\x69\54\x20\x63\56\x69\144\x5f\x6b\145\x6c\x61\163\54\40\x64\x2e\156\x61\155\x61\x5f\x67\x75\162\x75");
goto e9pdZ;
BA3EZ:
}
public function getAllKodeMateri($id_tp, $id_smt, $id_guru = null)
{
goto nghUs;
zsYEV:
return $result;
goto j7U86;
yZSnE:
if (!($id_guru != null)) {
goto PA05K;
}
goto Hqne6;
vd8tM:
$result = $this->db->get()->result();
goto zsYEV;
EZHdF:
$this->db->join("\x6b\145\x6c\141\163\x5f\152\141\144\x77\141\154\137\155\141\x74\x65\162\x69\40\143", "\141\x2e\151\144\x5f\x6d\141\164\x65\162\x69\x3d\143\56\x69\x64\x5f\x6d\141\164\x65\x72\151");
goto yZSnE;
EB_Y9:
PA05K:
goto Vd_SX;
txa1y:
$this->db->join("\155\141\x73\164\x65\x72\x5f\155\x61\160\145\154\x20\142", "\142\56\151\144\137\155\141\x70\x65\x6c\75\141\x2e\151\144\137\x6d\141\x70\x65\x6c", "\x6c\x65\x66\x74");
goto EZHdF;
PQUe1:
$this->db->from("\x6b\145\154\141\x73\137\155\141\164\x65\162\151\40\x61");
goto txa1y;
nghUs:
$this->db->select("\141\56\151\x64\137\x6d\x61\x70\x65\154\x2c\40\141\56\151\x64\x5f\x6d\x61\164\145\162\x69\x2c\x20\141\56\152\x65\x6e\151\x73\54\40\141\x2e\x6b\157\144\x65\x5f\155\x61\164\145\x72\151\54\40\x61\56\155\141\164\x65\162\151\137\x6b\145\154\x61\163\54\x20\x61\56\x69\x64\x5f\147\165\162\x75\x2c\x20\142\56\x6b\x6f\x64\x65\40\x61\163\40\x6b\x6f\x64\x65\137\x6d\141\160\145\x6c\54\x20\x63\56\151\144\137\x6b\152\x6d\54\x20\x63\x2e\x6a\141\x64\167\141\154\137\155\141\x74\145\x72\x69");
goto PQUe1;
Vd_SX:
$this->db->where("\x61\56\x69\x64\137\164\160", $id_tp);
goto iwa7x;
iwa7x:
$this->db->where("\141\56\x69\x64\137\163\x6d\164", $id_smt);
goto vd8tM;
Hqne6:
$this->db->where("\x61\x2e\x69\144\137\x67\x75\x72\165", $id_guru);
goto EB_Y9;
j7U86:
}
public function getKelasSiswa($id_kelas, $id_tp, $id_smt)
{
goto zmCLA;
ca8uc:
return $this->db->get()->result();
goto MNqtc;
nap2r:
$this->db->where("\141\x2e\x69\144\137\x74\160", $id_tp);
goto Whvyz;
Whvyz:
$this->db->where("\141\56\151\x64\x5f\163\155\164", $id_smt);
goto mczKM;
A5tUN:
$this->db->where("\x61\x2e\x69\144\x5f\153\x65\x6c\x61\x73", $id_kelas);
goto nap2r;
zmCLA:
$this->db->select("\x61\x2e\52\x2c\x20\142\x2e\156\x61\155\x61\x2c\40\x62\56\156\x69\163\54\x20\142\56\156\151\163\x6e\54\x20\142\56\165\x73\x65\162\156\x61\155\145\54\40\x62\x2e\x6a\145\156\x69\x73\x5f\153\x65\x6c\x61\x6d\151\156\x2c\x20\143\x2e\x6e\x61\x6d\x61\137\x6b\145\154\x61\x73\54\40\143\x2e\x6c\x65\x76\145\x6c\x5f\151\x64");
goto Ojsuf;
Ojsuf:
$this->db->from("\153\x65\x6c\141\x73\x5f\163\151\x73\x77\x61\x20\x61");
goto v5Lr4;
xVunV:
$this->db->join("\x6d\141\163\164\145\162\137\x6b\x65\154\x61\163\x20\143", "\x61\56\151\144\x5f\153\145\154\141\163\x3d\143\x2e\x69\x64\137\153\145\x6c\141\163");
goto A5tUN;
v5Lr4:
$this->db->join("\x6d\141\163\x74\x65\x72\x5f\163\151\x73\x77\141\40\142", "\x61\x2e\x69\x64\x5f\x73\x69\x73\167\141\x3d\142\x2e\151\144\137\x73\151\x73\x77\x61");
goto xVunV;
mczKM:
$this->db->order_by("\x62\x2e\x6e\141\x6d\141", "\101\123\103");
goto ca8uc;
MNqtc:
}
public function getKelasSiswaDuaSmt($id_kelas, $id_tp, $id_smt)
{
goto AiEAV;
C29U6:
$this->db->where("\141\56\x69\x64\137\164\x70", $id_tp);
goto AHHhk;
AHHhk:
$this->db->where("\x61\x2e\151\144\x5f\163\x6d\164", $id_smt);
goto ChpEF;
ChpEF:
return $this->db->get()->result();
goto kgpTb;
XykFE:
$this->db->join("\155\x61\x73\164\x65\162\x5f\x6b\145\154\141\163\40\143", "\141\56\151\144\137\153\145\x6c\141\x73\75\x63\56\x69\144\137\153\x65\154\x61\163", "\154\145\146\x74");
goto r8LB1;
AiEAV:
$this->db->select("\141\56\52\x2c\x20\142\56\156\x61\x6d\141\x2c\40\142\x2e\x6e\x69\x73\x2c\40\x62\56\x6e\151\x73\x6e\x2c\x20\142\56\x75\163\x65\162\156\x61\155\x65\x2c\x20\143\x2e\x6e\141\x6d\x61\x5f\153\145\154\141\163\54\40\x63\56\x6c\x65\x76\145\x6c\x5f\x69\144");
goto EZbHf;
DHUhj:
$this->db->join("\x6d\x61\x73\x74\x65\162\137\x73\x69\x73\x77\x61\x20\x62", "\141\56\151\144\x5f\163\x69\163\167\141\75\x62\x2e\151\x64\x5f\x73\x69\163\x77\x61", "\x6c\x65\x66\x74");
goto XykFE;
r8LB1:
$this->db->where("\141\x2e\x69\144\137\x6b\x65\154\141\163", $id_kelas);
goto C29U6;
EZbHf:
$this->db->from("\x6b\x65\154\x61\163\x5f\x73\x69\x73\167\141\x20\x61");
goto DHUhj;
kgpTb:
}
public function getStatusMateriSiswaByJadwal($id_siswa, $arr_id_kjm)
{
goto X_SVF;
xHoxG:
$this->db->from("\154\x6f\147\137\x6d\141\164\x65\162\x69");
goto Hb79m;
eO8ud:
return $ret;
goto hN0MZ;
Hb79m:
$this->db->where_in("\x69\144\x5f\x6d\141\x74\x65\162\x69", $arr_id_kjm);
goto NSqHI;
z7aJL:
$result = $this->db->get()->result();
goto gg9p0;
NSqHI:
$this->db->where("\151\x64\x5f\x73\151\163\x77\141", $id_siswa);
goto z7aJL;
Fdcwr:
Qj31N:
goto eO8ud;
gg9p0:
$ret = [];
goto ow9TW;
Y1vcM:
foreach ($result as $key => $row) {
$ret[$row->id_materi] = $row;
N1H5S:
}
goto j32iT;
X_SVF:
$this->db->select("\x2a");
goto xHoxG;
j32iT:
SthuR:
goto Fdcwr;
ow9TW:
if (!$result) {
goto Qj31N;
}
goto Y1vcM;
hN0MZ:
}
public function getStatusMateriSiswa($id_kjm = null)
{
goto VOlRm;
HE_rz:
$ret = [];
goto fvVPp;
EokQA:
return $ret;
goto DaamC;
SYlbe:
$this->db->where("\141\x2e\x69\x64\x5f\x6d\x61\164\x65\x72\x69", $id_kjm);
goto f_8nG;
f_8nG:
NB1af:
goto LVLq1;
CkyVp:
if (!($id_kjm != null)) {
goto NB1af;
}
goto SYlbe;
VOlRm:
$this->db->select("\x61\x2e\x2a\54\40\x62\56\152\141\144\x77\x61\x6c\137\x6d\x61\164\145\162\151");
goto GZ3gV;
wFExg:
kdVbJ:
goto J8bX7;
TY974:
$this->db->join("\x6b\x65\154\x61\163\x5f\152\x61\x64\167\141\x6c\137\x6d\x61\164\x65\x72\x69\40\142", "\x62\56\x69\144\137\153\x6a\155\x3d\x61\56\x69\144\x5f\155\141\164\145\x72\151");
goto CkyVp;
GZ3gV:
$this->db->from("\154\157\147\x5f\155\141\x74\x65\162\x69\x20\x61");
goto TY974;
J8bX7:
JkDqk:
goto EokQA;
i426Q:
foreach ($result as $key => $row) {
$ret[$row->id_siswa] = $row;
CfU0A:
}
goto wFExg;
LVLq1:
$result = $this->db->get()->result();
goto HE_rz;
fvVPp:
if (!$result) {
goto JkDqk;
}
goto i426Q;
DaamC:
}
public function getNilaiMateriSiswa($id_siswa)
{
goto hAOCe;
BKsIW:
$this->db->where("\141\x2e\x69\x64\x5f\x73\x69\163\167\141", $id_siswa);
goto K4zcZ;
MksKe:
wc_qA:
goto h3tA7;
h3tA7:
J8UU8:
goto m92IM;
QdjPu:
$ret = [];
goto IT1XD;
K4zcZ:
$result = $this->db->get()->result();
goto QdjPu;
sGcZO:
$this->db->join("\x6b\x65\154\141\x73\137\x6d\x61\x74\145\162\x69\40\x63", "\142\56\x69\144\137\155\x61\164\x65\x72\x69\75\x63\x2e\151\x64\137\155\141\x74\x65\x72\x69");
goto Dmf6V;
IT1XD:
if (!$result) {
goto J8UU8;
}
goto pe5WC;
Dmf6V:
$this->db->join("\155\141\163\164\x65\162\x5f\155\141\160\x65\x6c\x20\144", "\x63\56\x69\x64\137\x6d\x61\x70\x65\x6c\75\144\56\x69\144\x5f\x6d\141\x70\x65\154");
goto BKsIW;
J2dJg:
$this->db->join("\x6b\145\x6c\141\163\x5f\152\x61\144\x77\x61\154\x5f\155\x61\x74\145\x72\x69\40\142", "\141\x2e\151\x64\137\x6d\141\x74\x65\x72\x69\75\x62\56\151\144\x5f\x6b\x6a\155");
goto sGcZO;
hAOCe:
$this->db->select("\141\x2e\x6e\151\x6c\141\151\54\40\x61\56\x63\x61\x74\x61\x74\141\156\54\x20\142\x2e\x6a\141\144\x77\141\x6c\x5f\155\141\x74\x65\x72\x69\54\x20\143\x2e\x6b\157\144\x65\137\x6d\x61\x74\145\162\151\54\x20\x63\56\152\165\x64\x75\x6c\137\155\141\164\x65\162\x69\x2c\x20\x63\56\x6a\145\156\x69\163\x2c\x20\144\56\x6e\141\x6d\x61\137\155\x61\160\145\x6c\54\40\x64\x2e\153\157\x64\x65");
goto gqGhk;
gqGhk:
$this->db->from("\x6c\x6f\x67\137\x6d\141\x74\x65\x72\151\x20\141");
goto J2dJg;
m92IM:
return $ret;
goto xdA0C;
pe5WC:
foreach ($result as $key => $row) {
$ret[$row->jenis][] = $row;
B3396:
}
goto MksKe;
xdA0C:
}
public function getStatusSiswaByMapel($table, $id_mapel)
{
goto xuyuQ;
CVNCb:
$this->db->where("\x69\x64\x5f\x6d\141\160\145\154", $id_mapel);
goto HymxV;
wnAlx:
$this->db->from($table);
goto CVNCb;
xuyuQ:
$this->db->select("\x2a");
goto wnAlx;
HymxV:
return $this->db->get()->result();
goto TO_eY;
TO_eY:
}
public function getLogFileSiswa($table, $id_log)
{
goto sPJG1;
jXuYH:
return $query->row();
goto yA2yD;
sPJG1:
$this->db->select("\x2a");
goto sONt6;
sONt6:
$this->db->from($table);
goto dZX7q;
EVQHC:
$query = $this->db->get();
goto jXuYH;
dZX7q:
$this->db->where("\x69\144\137\x6c\x6f\147", $id_log);
goto EVQHC;
yA2yD:
}
public function getLoginSiswa($username)
{
goto U5O9a;
HGuyK:
return $query->row()->log_time;
goto Wzr8I;
rug2M:
if ($query->num_rows() > 0) {
goto Cl_ne;
}
goto qcJiY;
kijBl:
$this->db->from("\x75\x73\145\162\x73\40\141");
goto Wvy5y;
ZQr2g:
Cl_ne:
goto HGuyK;
s78l6:
goto TW4zl;
goto ZQr2g;
qcJiY:
return null;
goto s78l6;
Wvy5y:
$this->db->join("\x6c\x6f\147\40\x62", "\141\x2e\151\144\x3d\x62\x2e\x69\x64\x5f\x75\x73\x65\x72", "\154\x65\146\164");
goto boId0;
Wzr8I:
TW4zl:
goto XAJ9X;
boId0:
$this->db->where("\x61\x2e\165\x73\x65\x72\x6e\x61\155\145", $username);
goto vZbXY;
vZbXY:
$this->db->order_by("\x62\x2e\154\x6f\x67\x5f\164\151\155\x65", "\x44\105\123\103");
goto x5z2R;
U5O9a:
$this->db->select("\x61\x2e\x69\144\x2c\x20\x62\56\x2a");
goto kijBl;
x5z2R:
$query = $this->db->get();
goto rug2M;
XAJ9X:
}
public function loadJadwalSiswaHariIni($id_tp, $id_smt, $id_kelas, $id_hari, $with_key = true)
{
goto QvjEn;
caagS:
PNQjc:
goto WzQp2;
JkxpS:
if ($with_key) {
goto axz_7;
}
goto CL7d2;
CL7d2:
return $result;
goto VgyYM;
WzQp2:
return $ret;
goto KVhI5;
KVhI5:
rKNNg:
goto VBj0i;
qXQUZ:
$this->db->where("\x61\56\x69\144\x5f\150\x61\162\151", $id_hari);
goto dIIeh;
n28j8:
$this->db->where("\141\56\151\144\137\153\x65\154\141\163", $id_kelas);
goto qXQUZ;
RHkhy:
$this->db->where("\x61\56\151\144\x5f\x73\155\x74", $id_smt);
goto n28j8;
Za44w:
$this->db->join("\x6d\141\163\x74\x65\162\137\x6d\141\160\145\154\x20\x62", "\142\x2e\151\144\x5f\x6d\x61\x70\145\154\x3d\x61\56\x69\144\x5f\155\x61\160\145\154", "\154\145\x66\164");
goto vU1KE;
s_NO7:
foreach ($result as $key => $row) {
$ret[$row->jam_ke] = $row;
Kk5qc:
}
goto Z3YHN;
ENmep:
$ret = [];
goto Beyvs;
Z3YHN:
Weat7:
goto caagS;
Dc21_:
axz_7:
goto ENmep;
vU1KE:
$this->db->where("\x61\x2e\x69\x64\137\x74\x70", $id_tp);
goto RHkhy;
VgyYM:
goto rKNNg;
goto Dc21_;
QvjEn:
$this->db->select("\52");
goto RH_hm;
Beyvs:
if (!$result) {
goto PNQjc;
}
goto s_NO7;
dIIeh:
$result = $this->db->get()->result();
goto JkxpS;
RH_hm:
$this->db->from("\153\x65\154\141\x73\x5f\152\141\x64\x77\x61\154\x5f\155\141\x70\x65\x6c\x20\x61");
goto Za44w;
VBj0i:
}
public function loadJadwalSiswaSeminggu($id_tp, $id_smt, $id_kelas)
{
goto XyNhq;
pK4pk:
return $ret;
goto N262b;
FtzoK:
$this->db->where("\x61\x2e\x69\x64\x5f\164\x70", $id_tp);
goto YYq1q;
PD5O1:
$ret = [];
goto IPI5Q;
IPI5Q:
if (!$result) {
goto q4x6C;
}
goto m34Ci;
g4JQF:
$this->db->from("\153\145\x6c\141\163\x5f\x6a\141\x64\167\x61\154\137\x6d\141\x70\145\x6c\40\141");
goto W__KR;
ri2_L:
$result = $this->db->get()->result();
goto PD5O1;
YYq1q:
$this->db->where("\141\56\151\144\x5f\163\155\x74", $id_smt);
goto pw5Lb;
pw5Lb:
$this->db->where("\x61\x2e\151\144\137\x6b\x65\x6c\141\163", $id_kelas);
goto ri2_L;
XyNhq:
$this->db->select("\52");
goto g4JQF;
g2Dtd:
q4x6C:
goto pK4pk;
wtdM3:
XGqo5:
goto g2Dtd;
W__KR:
$this->db->join("\x6d\141\x73\164\x65\x72\137\x6d\141\160\x65\154\40\x62", "\x62\x2e\151\144\x5f\155\x61\160\x65\154\75\x61\56\151\x64\x5f\155\x61\160\145\x6c", "\x6c\x65\146\164");
goto FtzoK;
m34Ci:
foreach ($result as $key => $row) {
$ret[$row->id_hari][$row->jam_ke] = $row;
VatGT:
}
goto wtdM3;
N262b:
}
public function getMateriSiswa($id_kelas, $tgl, $jenis)
{
goto AP_n_;
AP_n_:
$this->db->select("\x61\56\52\54\40\142\x2e\x69\x64\x5f\x6d\x61\x74\145\162\151\x2c\40\x62\x2e\x6b\157\144\145\137\155\x61\164\145\162\151\54\x20\142\56\152\165\x64\x75\154\137\x6d\141\164\145\x72\151\54\x20\142\56\x6d\141\164\x65\x72\x69\x5f\153\x65\154\141\163\54\40\142\56\164\x67\x6c\x5f\155\x75\154\141\x69\x2c\x20\143\x2e\x6e\x61\155\x61\x5f\147\165\x72\x75\x2c\x20\x64\56\156\x61\155\x61\137\x6d\x61\160\145\154");
goto r3PNp;
r3PNp:
$this->db->from("\x6b\145\154\141\163\137\152\141\144\167\141\x6c\x5f\x6d\141\164\145\162\x69\40\x61");
goto oc31Z;
QWX4C:
$this->db->where("\x61\56\152\x65\156\x69\163", $jenis);
goto IbeMX;
hjAp5:
foreach ($result as $key => $row) {
goto h2LHg;
RzRgX:
$sisa = strlen($row->id_kjm) - $subs_jam;
goto BnQQN;
Z_B1_:
UCtQo:
goto TJQFX;
h2LHg:
$len_kls = strlen($row->id_kelas);
goto YqUOx;
vk87e:
$ret[$jam] = $row;
goto Z_B1_;
gKelC:
$jam = substr($row->id_kjm, strlen($row->id_kjm) - $len, 1);
goto vk87e;
BnQQN:
$len = $sisa === 3 ? 2 : 1;
goto gKelC;
YqUOx:
$subs_jam = $len_kls + 10;
goto RzRgX;
TJQFX:
}
goto RuEAW;
oc31Z:
$this->db->join("\x6b\x65\154\x61\x73\x5f\155\x61\164\145\162\x69\40\x62", "\141\56\x69\x64\137\x6d\141\164\x65\162\x69\75\142\x2e\151\x64\x5f\155\x61\x74\145\x72\x69\40\101\x4e\104\x20\x62\x2e\163\x74\141\164\x75\x73\x3d\x31");
goto Dt0_x;
U8Ua2:
$this->db->where("\141\x2e\151\x64\137\153\145\x6c\141\163", $id_kelas);
goto bOFtH;
PDkau:
if (!$result) {
goto bkPFN;
}
goto hjAp5;
z13Ec:
bkPFN:
goto Zkc8K;
Dt0_x:
$this->db->join("\155\141\x73\x74\145\162\x5f\147\x75\162\x75\40\x63", "\142\56\x69\x64\x5f\x67\165\162\165\x3d\x63\x2e\x69\144\137\147\165\162\x75", "\x6c\x65\146\x74");
goto RaoaL;
bOFtH:
$result = $this->db->get()->result();
goto NdHs2;
Zkc8K:
return $ret;
goto AKsCp;
IbeMX:
$this->db->where("\x61\x2e\x6a\x61\x64\x77\141\154\137\x6d\141\164\x65\162\x69", $tgl);
goto U8Ua2;
RuEAW:
XlVvv:
goto z13Ec;
RaoaL:
$this->db->join("\x6d\x61\x73\164\145\x72\x5f\155\141\x70\145\154\40\144", "\142\x2e\151\144\x5f\x6d\141\x70\x65\x6c\x3d\x64\x2e\x69\144\137\155\x61\160\x65\x6c", "\x6c\x65\x66\x74");
goto QWX4C;
NdHs2:
$ret = [];
goto PDkau;
AKsCp:
}
public function getMateriSiswaSeminggu($id_tp, $id_smt, $id_kelas, $jenis)
{
goto umW4V;
asPXC:
$this->db->from("\x6b\x65\x6c\141\163\137\152\141\144\167\141\x6c\x5f\155\141\x74\145\x72\151\40\x61");
goto xDK5V;
umW4V:
$this->db->select("\141\56\x2a\x2c\40\142\x2e\x69\x64\x5f\155\141\x74\x65\162\151\54\x20\x62\56\x6b\x6f\x64\145\137\x6d\x61\164\x65\x72\151\54\x20\142\x2e\x6a\165\144\165\x6c\137\155\141\164\145\x72\151\54\x20\x62\56\x6d\141\x74\145\162\151\137\153\x65\154\x61\163\54\40\142\56\x74\x67\x6c\x5f\x6d\x75\154\141\151\54\40\143\56\x6e\141\155\x61\137\x67\x75\x72\x75\54\40\144\56\156\x61\155\x61\137\x6d\141\160\x65\154");
goto asPXC;
sU4SW:
foreach ($result as $key => $row) {
goto xlvXj;
QS5tP:
$ret[$row->jadwal_materi][$jam] = $row;
goto vw0OV;
xlvXj:
$len_kls = strlen($row->id_kelas);
goto vf47o;
JLKji:
$len = $sisa === 3 ? 2 : 1;
goto i8fCe;
vw0OV:
yiU8d:
goto GVwYc;
vf47o:
$subs_jam = $len_kls + 10;
goto UslVB;
UslVB:
$sisa = strlen($row->id_kjm) - $subs_jam;
goto JLKji;
i8fCe:
$jam = substr($row->id_kjm, strlen($row->id_kjm) - $sisa, $len);
goto QS5tP;
GVwYc:
}
goto m0YbV;
xuVtI:
if (!$result) {
goto nmTyY;
}
goto sU4SW;
MPgKw:
$this->db->where("\141\56\x69\144\137\x74\x70", $id_tp);
goto rFgrl;
ab7FM:
$this->db->join("\x6d\141\163\164\x65\162\137\x6d\x61\160\145\154\40\x64", "\x62\56\x69\144\137\x6d\141\x70\x65\x6c\x3d\x64\56\151\x64\137\x6d\x61\x70\145\x6c", "\154\x65\146\x74");
goto MPgKw;
FuvLI:
nmTyY:
goto y4UYN;
mEhFn:
$this->db->join("\155\x61\x73\x74\x65\x72\137\147\165\162\x75\x20\x63", "\142\x2e\x69\144\x5f\147\x75\x72\165\x3d\x63\x2e\151\x64\137\x67\x75\162\x75", "\x6c\145\x66\164");
goto ab7FM;
F5FG5:
$ret = [];
goto xuVtI;
xDK5V:
$this->db->join("\153\145\x6c\x61\x73\x5f\x6d\141\x74\145\x72\151\x20\142", "\141\56\151\x64\x5f\155\141\164\x65\x72\151\75\142\x2e\x69\x64\x5f\155\141\x74\145\162\x69\x20\101\116\x44\x20\142\x2e\x73\x74\141\164\x75\163\75\61");
goto mEhFn;
n8uGK:
$this->db->where("\141\56\x69\144\137\x6b\145\x6c\141\x73", $id_kelas);
goto sMGCt;
sMGCt:
$result = $this->db->get()->result();
goto F5FG5;
y4UYN:
return $ret;
goto WqTj4;
m0YbV:
dB_Sk:
goto FuvLI;
rFgrl:
$this->db->where("\x61\x2e\151\144\137\163\155\x74", $id_smt);
goto ePp9n;
ePp9n:
$this->db->where("\x61\x2e\x6a\x65\x6e\151\x73", $jenis);
goto n8uGK;
WqTj4:
}
public function getAllMateriByTgl($id_kelas, $tgl, $arr_mapel)
{
goto NQa8l;
SNTpU:
iPQdV:
goto KjOyU;
skT3F:
return $ret;
goto vBn4V;
ot4t2:
$this->db->join("\x6d\141\x73\x74\145\162\137\155\141\x70\x65\x6c\x20\144", "\142\56\x69\144\137\155\x61\160\145\154\x3d\144\x2e\151\144\x5f\x6d\x61\x70\x65\x6c", "\x6c\x65\146\x74");
goto DAnIW;
rXITt:
foreach ($result as $key => $row) {
goto kyZ9V;
p7Kkc:
$row->materi_kelas = unserialize($row->materi_kelas);
goto azBQh;
GwN1z:
$jam = substr($row->id_kjm, strlen($row->id_kjm) - $sisa, $len);
goto p7Kkc;
ahW_Z:
FYQZl:
goto Nyt9k;
kyZ9V:
$len_kls = strlen($row->id_kelas);
goto A0n6w;
jnBZ1:
$sisa = strlen($row->id_kjm) - $subs_jam;
goto Tq_JX;
azBQh:
$ret[$row->id_mapel][$jam][$row->jenis] = $row;
goto ahW_Z;
A0n6w:
$subs_jam = $len_kls + 10;
goto jnBZ1;
Tq_JX:
$len = $sisa === 3 ? 2 : 1;
goto GwN1z;
Nyt9k:
}
goto SNTpU;
VRv0A:
$this->db->from("\x6b\x65\x6c\x61\x73\137\152\x61\144\167\x61\x6c\x5f\155\x61\164\145\162\x69\x20\141");
goto gL17e;
omR_1:
WbBls:
goto s4xbR;
gL17e:
$this->db->join("\x6b\x65\154\141\163\x5f\155\x61\x74\145\162\151\x20\142", "\141\x2e\x69\144\137\155\x61\164\x65\x72\x69\75\142\x2e\x69\x64\x5f\155\x61\164\145\162\151\40\x41\x4e\104\x20\x62\56\163\x74\141\x74\165\x73\x3d\61");
goto pl4Ag;
TMbxv:
$result = $this->db->get()->result();
goto Caa35;
NQa8l:
$this->db->select("\141\56\52\54\x20\142\56\x69\x64\137\x6d\141\164\145\x72\151\54\40\x62\x2e\153\157\x64\x65\x5f\x6d\x61\x74\145\x72\151\x2c\40\142\56\155\141\164\145\162\151\137\x6b\x65\154\141\x73\x2c\40\x62\x2e\x74\x67\x6c\137\155\165\x6c\x61\x69\x2c\x20\x63\56\x6e\141\x6d\141\137\x67\165\162\x75\54\40\144\x2e\x6b\157\144\x65\54\40\144\56\x6e\141\155\x61\137\x6d\141\x70\145\154");
goto VRv0A;
hrHRK:
$this->db->where_in("\141\56\151\x64\137\155\141\160\x65\154", $arr_mapel);
goto omR_1;
W8fkl:
if (!(count($arr_mapel) > 0)) {
goto WbBls;
}
goto hrHRK;
KjOyU:
DNICM:
goto skT3F;
pl4Ag:
$this->db->join("\x6d\x61\163\x74\x65\x72\x5f\147\x75\x72\x75\x20\x63", "\x62\56\x69\x64\137\147\x75\162\165\75\x63\x2e\151\x64\137\x67\165\162\x75", "\154\145\146\164");
goto ot4t2;
s4xbR:
$this->db->where("\x61\x2e\x69\x64\137\x6b\x65\x6c\x61\163", $id_kelas);
goto TMbxv;
ddzod:
if (!$result) {
goto DNICM;
}
goto rXITt;
Caa35:
$ret = [];
goto ddzod;
DAnIW:
$this->db->where("\x61\x2e\x6a\x61\144\x77\141\x6c\x5f\x6d\x61\164\145\x72\x69", $tgl);
goto W8fkl;
vBn4V:
}
public function getRekapStatusMapel($id_siswa, $date, $id_mapel)
{
goto ICmuJ;
hYrPS:
$this->db->join("\155\x61\163\x74\x65\x72\137\155\x61\x70\x65\154\40\x64", "\x63\x2e\151\x64\137\155\141\160\x65\x6c\75\x64\56\x69\x64\x5f\x6d\x61\160\145\x6c", "\154\145\146\164");
goto iCj7n;
AYgh_:
$this->db->join("\153\145\154\141\163\137\x6d\x61\164\x65\162\151\40\x63", "\142\56\x69\144\137\x6d\x61\x74\x65\162\151\75\143\x2e\x69\144\x5f\155\141\x74\x65\162\x69", "\154\x65\x66\164");
goto hYrPS;
iOO8C:
$query = $this->db->get()->result();
goto YNz2o;
iCj7n:
$this->db->where("\x44\x41\124\x45\x28\x61\56\x6c\x6f\147\x5f\164\x69\x6d\145\x29", $date);
goto eSikU;
eE5dX:
$this->db->where("\141\56\x69\144\137\155\x61\160\145\x6c", $id_mapel);
goto iOO8C;
YNz2o:
return $query;
goto rkl4O;
ICmuJ:
$this->db->select("\141\56\x6a\141\155\137\153\x65\54\40\x61\56\x6c\157\147\x5f\164\x69\x6d\145\54\40\x63\x2e\152\x65\x6e\151\163\x2c\x20\104\x41\131\117\x46\x4d\x4f\x4e\124\x48\x28\x61\56\154\x6f\147\x5f\164\x69\x6d\x65\51\x20\141\x73\40\164\x61\x6e\x67\x67\141\x6c\54\x20\x4d\x4f\116\x54\110\50\x61\x2e\154\157\x67\137\x74\x69\x6d\x65\x29\x20\x61\163\x20\142\165\x6c\x61\156\x2c\x20\131\x45\x41\x52\x28\141\56\154\157\147\x5f\164\151\x6d\145\51\40\141\x73\x20\x74\141\150\x75\156\x2c\x20\x54\111\x4d\x45\x5f\x46\x4f\122\x4d\x41\x54\x28\141\56\x6c\x6f\x67\x5f\x74\151\155\145\x2c\40\42\x25\x48\72\x25\151\42\x29\x20\141\x73\40\x6a\141\155\54\x20\x64\x2e\x6e\x61\155\x61\x5f\155\x61\160\x65\x6c\x2c\40\144\56\153\157\144\145\54\40\144\x2e\151\144\x5f\x6d\x61\160\145\x6c");
goto g5z8I;
g5z8I:
$this->db->from("\154\x6f\x67\137\x6d\x61\164\145\x72\x69\40\141");
goto AQmMw;
eSikU:
$this->db->where("\x61\x2e\x69\144\x5f\163\151\163\167\x61", $id_siswa);
goto eE5dX;
AQmMw:
$this->db->join("\x6b\x65\x6c\x61\163\137\152\x61\x64\167\141\x6c\x5f\x6d\141\164\x65\162\x69\x20\142", "\x61\x2e\x69\144\137\x6d\x61\x74\145\162\x69\x3d\142\x2e\x69\x64\137\153\x6a\x6d", "\154\x65\146\164");
goto AYgh_;
rkl4O:
}
public function getRekapStatusMateri($id_siswa, $arr_id_kjm)
{
goto glxh7;
R2NjC:
$this->db->where("\x61\56\151\144\137\x73\151\x73\167\141", $id_siswa);
goto usPaH;
XD421:
$this->db->join("\155\141\x73\164\x65\x72\137\x6d\x61\160\x65\x6c\x20\x64", "\143\56\x69\144\137\155\141\160\x65\x6c\75\x64\x2e\151\144\137\155\x61\x70\x65\x6c", "\x6c\x65\x66\x74");
goto R2NjC;
KmQat:
$this->db->join("\x6b\145\x6c\x61\163\x5f\x6a\141\144\167\x61\154\137\x6d\141\x74\x65\x72\151\x20\x62", "\x61\56\151\x64\x5f\155\141\x74\145\162\151\x3d\142\x2e\x69\144\x5f\x6b\152\155", "\154\x65\146\164");
goto HyLtn;
HyLtn:
$this->db->join("\x6b\145\154\141\x73\x5f\x6d\x61\164\x65\x72\151\x20\143", "\142\56\151\x64\137\155\x61\164\145\x72\151\x3d\143\x2e\151\144\x5f\x6d\x61\x74\x65\x72\151", "\154\x65\146\164");
goto XD421;
DSQbk:
$query = $this->db->get()->result();
goto eiQRN;
glxh7:
$this->db->select("\141\56\x6a\x61\x6d\137\153\x65\x2c\40\x61\56\x6c\157\147\137\164\x69\155\145\x2c\40\141\x2e\146\x69\156\x69\x73\150\137\x74\151\x6d\145\54\40\x63\x2e\x6a\x65\x6e\x69\x73\x2c\x20\104\x41\131\x4f\x46\115\x4f\x4e\124\110\50\141\56\154\x6f\147\x5f\x74\x69\155\145\x29\x20\141\163\40\x74\x61\156\x67\x67\x61\154\54\x20\115\117\116\x54\x48\50\x61\x2e\154\157\x67\137\x74\x69\x6d\x65\51\40\x61\x73\40\x62\165\154\x61\156\x2c\x20\131\105\x41\x52\50\141\x2e\154\157\x67\x5f\164\x69\155\x65\x29\40\x61\x73\40\x74\141\x68\165\x6e\x2c\x20\124\111\x4d\105\x5f\106\117\122\x4d\x41\124\x28\141\x2e\154\157\147\137\x74\151\155\145\54\x20\42\45\x48\x3a\x25\151\x22\51\x20\141\163\x20\152\x61\x6d\54\40\x64\x2e\x6e\x61\155\141\137\x6d\x61\x70\x65\x6c\54\x20\144\x2e\x6b\157\144\145\x2c\40\x64\56\x69\144\x5f\x6d\141\160\145\154");
goto qMTSb;
qMTSb:
$this->db->from("\x6c\157\147\137\x6d\141\x74\145\x72\x69\40\x61");
goto KmQat;
eiQRN:
return $query;
goto BXwHI;
usPaH:
$this->db->where_in("\141\x2e\151\x64\x5f\155\141\x74\x65\162\x69", $arr_id_kjm);
goto DSQbk;
BXwHI:
}
public function getRekapBulananMapel($id_siswa, $bulan)
{
goto HEA4n;
L4NkV:
$query = $this->db->get()->result();
goto gNMl9;
c2bz3:
$this->db->where("\x61\x2e\x69\144\x5f\x73\151\163\x77\141", $id_siswa);
goto L4NkV;
pYKBC:
$this->db->where("\x4d\x4f\116\x54\x48\x28\x61\x2e\154\x6f\147\137\x74\x69\155\145\51", $bulan);
goto c2bz3;
gNMl9:
return $query;
goto sJ290;
HEA4n:
$this->db->select("\x61\56\x6c\157\147\137\164\x69\x6d\145\40\x61\163\40\155\x61\164\x65\162\151\x2c\x20\104\101\x59\117\106\115\117\x4e\x54\x48\x28\141\56\154\x6f\x67\x5f\x74\x69\x6d\145\x29\x20\x61\x73\40\x74\141\156\x67\147\x61\x6c\54\x20\115\117\x4e\124\x48\x28\x61\x2e\154\157\x67\137\x74\151\155\145\x29\40\141\163\x20\x62\165\x6c\141\156\54\40\131\x45\101\x52\x28\x61\x2e\x6c\157\x67\137\164\151\x6d\145\x29\40\141\x73\x20\164\141\x68\x75\x6e\x2c\x20\124\x49\x4d\105\137\106\x4f\x52\x4d\x41\x54\x28\x61\x2e\x6c\157\x67\137\164\x69\x6d\x65\54\x20\x22\45\x48\x3a\45\x69\x22\51\40\141\x73\40\152\141\155\x5f\155\x61\164\145\162\151");
goto w7c9E;
w7c9E:
$this->db->from("\x6c\157\x67\x5f\155\141\x74\x65\162\151\x20\x61");
goto pYKBC;
sJ290:
}
public function getRekapBulananSiswa($id_mapel = null, $id_kelas, $tahun, $bulan)
{
goto fIvCG;
Rk11x:
$this->db->where("\x61\56\x69\144\137\x6b\145\154\141\163", $id_kelas);
goto jTtPD;
O4UWf:
$this->db->from("\153\145\x6c\141\x73\x5f\x6a\141\x64\167\141\154\137\x6d\x61\x74\x65\162\151\40\x61");
goto dOF24;
MaPij:
if (!$result) {
goto wQaM8;
}
goto W9qwf;
fIvCG:
$this->db->select("\x61\56\52\x2c\x20\142\x2e\x6c\157\147\x5f\164\151\155\x65\54\x20\x62\x2e\x66\x69\156\151\163\x68\x5f\164\x69\x6d\145\x2c\x20\x62\56\151\144\137\163\x69\163\x77\141\x2c\x20\x62\56\152\141\x6d\137\x6b\145\54\40\104\x41\x59\x4f\106\115\117\x4e\x54\x48\x28\x62\56\x6c\x6f\x67\x5f\164\x69\155\x65\51\x20\x61\x73\40\x74\141\x6e\x67\147\141\154\54\40\x4d\117\x4e\124\x48\50\x62\56\154\x6f\147\137\x74\x69\x6d\x65\51\40\141\x73\x20\x62\165\154\141\x6e\x2c\x20\131\x45\x41\x52\50\x62\x2e\x6c\x6f\147\x5f\164\x69\155\x65\51\40\x61\x73\40\164\141\x68\x75\x6e\x2c\x20\x54\x49\x4d\105\x5f\106\x4f\x52\x4d\101\124\50\x62\x2e\x6c\157\147\137\164\151\x6d\145\54\x20\x22\x25\x48\72\x25\x69\42\x29\40\141\x73\40\x6a\141\x6d");
goto O4UWf;
JzPBA:
$result = $this->db->get()->result();
goto f9Qzd;
p1tJW:
QZKVV:
goto lpsxC;
f9Qzd:
$ret = [];
goto MaPij;
lbx8y:
$this->db->where("\x61\x2e\151\144\137\x6d\141\160\x65\154", $id_mapel);
goto SSZAk;
pc77i:
$this->db->where("\115\x4f\x4e\x54\110\50\x61\56\152\x61\x64\167\141\154\137\x6d\x61\164\145\x72\x69\x29", $bulan)->where("\x59\x45\x41\x52\50\141\x2e\x6a\141\x64\167\141\x6c\x5f\x6d\x61\x74\145\x72\151\x29", $tahun);
goto JzPBA;
BKv_Z:
return $ret;
goto LIjxf;
dOF24:
$this->db->join("\154\x6f\147\x5f\x6d\x61\164\145\x72\151\40\x62", "\x62\56\x69\x64\x5f\x6d\x61\164\145\x72\x69\x3d\x61\56\x69\144\137\x6b\x6a\x6d");
goto Rk11x;
lpsxC:
wQaM8:
goto BKv_Z;
W9qwf:
foreach ($result as $key => $row) {
$ret[$row->id_siswa][$row->jenis][$row->jadwal_materi][$row->jam_ke] = $row;
l208W:
}
goto p1tJW;
jTtPD:
if (!($id_mapel != null)) {
goto zfBet;
}
goto lbx8y;
SSZAk:
zfBet:
goto pc77i;
LIjxf:
}
public function getRekapBulananMateri($id_siswa, $date, $id_materi)
{
goto mHdWB;
s1Eqh:
$this->db->where("\x44\101\124\105\50\141\x2e\154\x6f\x67\137\164\x69\155\145\x29", $date);
goto Ptv9A;
YNb0W:
return $ret;
goto I3R3F;
v84T4:
$this->db->from("\154\157\147\137\155\141\x74\145\162\151\40\x61");
goto s1Eqh;
Ptv9A:
$this->db->where("\x61\56\x69\x64\x5f\x73\151\x73\x77\x61", $id_siswa);
goto Ayd5n;
Ayd5n:
$this->db->where("\x61\56\x69\144\x5f\155\x61\x74\x65\x72\151", $id_materi);
goto eiiRf;
eiiRf:
$result = $this->db->get()->row();
goto loMA3;
loMA3:
$ret = [];
goto jRit1;
oyPEY:
kIo9V:
goto YNb0W;
yFC2c:
Ljciw:
goto oyPEY;
jRit1:
if (!$result) {
goto kIo9V;
}
goto RUgTg;
RUgTg:
foreach ($result as $key => $row) {
$ret[$row->id_siswa] = $row;
xNhTy:
}
goto yFC2c;
mHdWB:
$this->db->select("\x61\x2e\154\x6f\147\x5f\x74\x69\155\x65\x2c\x20\104\101\131\117\x46\x4d\x4f\x4e\x54\110\x28\141\56\154\157\x67\137\164\x69\155\x65\51\40\x61\163\x20\164\141\156\x67\x67\x61\x6c\x2c\x20\115\x4f\116\x54\x48\50\141\x2e\x6c\x6f\147\x5f\164\x69\155\x65\x29\40\141\x73\40\x62\x75\x6c\141\x6e\x2c\40\131\105\x41\x52\x28\x61\56\154\x6f\x67\137\164\x69\x6d\145\x29\x20\141\x73\40\164\x61\x68\165\156\54\x20\x54\x49\115\x45\x5f\x46\117\x52\x4d\101\x54\50\141\56\154\x6f\x67\x5f\x74\x69\x6d\145\54\x20\42\45\x48\x3a\45\151\42\51\x20\x61\163\40\x6a\x61\x6d");
goto v84T4;
I3R3F:
}
public function getRekapMateriSemester($id_kelas, $id_materi = null)
{
goto QZMFI;
Y9QNx:
kG4Sh:
goto INMPx;
nleoB:
$ret = [];
goto zctR_;
QZMFI:
$this->db->select("\x69\144\137\163\x69\163\x77\x61\x2c\x20\x69\144\x5f\154\157\147\54\40\154\x6f\x67\x5f\x74\x69\155\145\x2c\x20\x66\x69\156\151\163\150\137\x74\x69\x6d\145\x2c\x20\x69\x64\x5f\155\141\x74\x65\162\x69\54" . "\40\x44\101\131\117\106\115\x4f\116\x54\110\50\154\x6f\147\x5f\x74\151\155\x65\51\40\x61\163\x20\164\141\156\x67\x67\141\154\54" . "\40\115\117\116\124\x48\x28\x6c\x6f\147\x5f\x74\151\x6d\x65\x29\40\141\x73\40\142\x75\x6c\141\x6e\54" . "\x20\x59\x45\101\122\50\x6c\157\147\137\164\x69\x6d\145\x29\x20\x61\x73\x20\164\x61\x68\165\x6e\54" . "\40\124\x49\115\105\x5f\106\x4f\x52\115\x41\x54\50\154\157\147\137\x74\151\x6d\145\54\x20\42\x25\110\x3a\45\151\x22\x29\40\x61\163\40\152\141\x6d\x2c" . "\40\156\151\x6c\x61\x69");
goto mzL4B;
hh_nJ:
return $ret;
goto IIXEZ;
INMPx:
$result = $this->db->get()->result();
goto nleoB;
tQT6w:
K7QmG:
goto g80wS;
RhhNa:
foreach ($result as $key => $row) {
goto mFOu2;
Bzmx5:
$subs_tgl = $subs_bln + $len_bln;
goto jTJiz;
agdGU:
$len_bln = 2;
goto oUlEV;
ws1ir:
$tgl = substr($row->id_materi, $subs_tgl, 2);
goto c20H_;
oUlEV:
$len_hari = 2;
goto UAVCQ;
UAVCQ:
$subs_bln = $len_kls + $len_tp_smt + $len_tahun;
goto Bzmx5;
c20H_:
$jam = substr($row->id_materi, strlen($row->id_materi) - $sisa, $len);
goto TatjG;
OIo2t:
$ret[$jenis][$row->id_siswa][$bulan][$tgl][$jam] = $row;
goto qcHMB;
si0ft:
$len_tp_smt = 2;
goto ilGJ6;
xyi8p:
$bulan = substr($row->id_materi, $subs_bln, 2);
goto ws1ir;
mFOu2:
$len_kls = strlen($id_kelas);
goto si0ft;
qcHMB:
LyV0O:
goto OpAKi;
jTJiz:
$sisa = strlen($row->id_materi) - ($len_kls + 10);
goto YGddw;
YGddw:
$len = $sisa === 3 ? 2 : 1;
goto xyi8p;
TatjG:
$jenis = substr($row->id_materi, strlen($row->id_materi) - 1, 1);
goto OIo2t;
ilGJ6:
$len_tahun = 4;
goto agdGU;
OpAKi:
}
goto tQT6w;
g80wS:
GhzXv:
goto hh_nJ;
mzL4B:
$this->db->from("\154\x6f\147\137\155\141\164\145\162\151");
goto LYZfI;
LYZfI:
if (!($id_materi != null)) {
goto kG4Sh;
}
goto UWufL;
UWufL:
$this->db->where("\x69\x64\137\x6d\x61\164\145\x72\x69", $id_materi);
goto Y9QNx;
zctR_:
if (!$result) {
goto GhzXv;
}
goto RhhNa;
IIXEZ:
}
public function getStrukturKelas($kelas)
{
$this->db->where("\151\x64\137\153\145\154\141\x73", $kelas);
return $this->db->get("\x6b\145\154\141\x73\x5f\x73\164\x72\x75\153\x74\165\x72")->row();
}
public function getCatatanKelas($kelas, $id_tp, $id_smt)
{
goto cEbQ2;
zv5jr:
$this->db->where("\151\144\x5f\164\160", $id_tp);
goto CI8yQ;
yJzYv:
return $this->db->get("\153\145\x6c\141\163\x5f\143\x61\164\141\164\141\x6e\137\x77\x61\154\151")->result();
goto DPqU9;
CI8yQ:
$this->db->where("\x69\x64\137\163\x6d\x74", $id_smt);
goto yJzYv;
cEbQ2:
$this->db->where("\x69\144\137\153\145\154\141\x73", $kelas);
goto Hdh_V;
Hdh_V:
$this->db->where("\x74\x79\x70\145", "\x31");
goto zv5jr;
DPqU9:
}
public function getCatatanSiswa($id_tp, $id_smt, $id_kelas)
{
goto IQQ37;
k09A5:
return $this->db->get()->result();
goto QRAA9;
IQQ37:
$this->db->select("\142\x2e\151\144\x5f\163\x69\x73\167\141\54\40\142\x2e\x6e\x61\x6d\x61\x2c\40\x62\x2e\156\151\163\x2c\x20\142\56\156\151\163\156\x2c\40\x62\x2e\x66\157\164\157\54" . "\x20\x28\x53\105\x4c\105\103\124\x20\x43\117\x55\x4e\124\x28\151\x64\x5f\x73\x69\163\167\x61\51\x20\106\x52\117\115\40\153\x65\x6c\141\x73\137\143\141\x74\x61\x74\141\x6e\x5f\x77\x61\154\151\x20\x63\40\x57\110\x45\x52\105\40\x63\x2e\x69\144\137\163\x69\163\x77\x61\x20\x3d\x20\142\56\151\144\x5f\x73\151\163\x77\x61\40\101\x4e\x44\40\143\56\164\x79\160\145\x20\x3d\x20\x27\62\47\51\x20\101\x53\x20\x6a\x6d\x6c\x5f\x63\x61\164\141\x74\x61\156");
goto AGyVH;
eK2O8:
$this->db->where("\x61\x2e\x69\144\137\x74\160", $id_tp);
goto hsvmc;
hsvmc:
$this->db->where("\141\56\151\x64\x5f\x73\155\164", $id_smt);
goto acaUQ;
AGyVH:
$this->db->from("\x6b\x65\x6c\141\163\x5f\x73\151\163\x77\x61\x20\141");
goto vdKb7;
vdKb7:
$this->db->join("\155\x61\163\164\x65\162\x5f\163\x69\163\x77\x61\x20\142", "\142\56\x69\144\x5f\x73\151\x73\167\141\x3d\x61\x2e\151\144\x5f\163\151\163\167\x61");
goto eK2O8;
acaUQ:
$this->db->where("\141\x2e\x69\144\137\x6b\x65\154\x61\163", $id_kelas);
goto k09A5;
QRAA9:
}
public function getAllCatatanSiswa($id_siswa, $id_tp, $id_smt)
{
goto rGfMH;
WQALI:
$this->db->where("\151\x64\x5f\163\x69\x73\x77\x61", $id_siswa);
goto xN88Z;
rGfMH:
$this->db->select("\52");
goto LxKJO;
xN88Z:
$this->db->where("\x69\x64\x5f\x74\x70", $id_tp);
goto QplCG;
QplCG:
$this->db->where("\151\x64\x5f\163\155\164", $id_smt);
goto SozUX;
SozUX:
return $this->db->get()->result();
goto N9Our;
LxKJO:
$this->db->from("\153\145\x6c\x61\x73\x5f\143\141\164\141\x74\141\156\137\x77\141\154\x69");
goto WQALI;
N9Our:
}
public function getCatatanMapelKelas($kelas, $mapel, $id_tp, $id_smt)
{
goto mx_k4;
mx_k4:
$this->db->where("\x69\144\137\x6b\x65\154\141\x73", $kelas);
goto qyK6e;
IDjca:
$this->db->where("\151\x64\x5f\x73\x6d\x74", $id_smt);
goto JFQjf;
LyEiZ:
$this->db->where("\151\144\137\164\x70", $id_tp);
goto IDjca;
JFQjf:
$this->db->order_by("\164\147\x6c", "\104\x45\123\x43");
goto lZw_S;
lZw_S:
return $this->db->get("\x6b\145\x6c\141\x73\137\x63\141\x74\141\164\x61\156\x5f\155\x61\160\145\x6c")->result();
goto Yp0rv;
isAi6:
$this->db->where("\x74\x79\160\x65", "\61");
goto LyEiZ;
qyK6e:
$this->db->where("\151\144\x5f\155\x61\x70\x65\x6c", $mapel);
goto isAi6;
Yp0rv:
}
public function getCatatanMapelSiswa($id_tp, $id_smt, $id_kelas, $id_mapel)
{
goto bJs1m;
GHVZB:
$this->db->from("\153\145\x6c\141\163\137\163\151\x73\167\x61\x20\x61");
goto FnGMw;
vN1W8:
$this->db->where("\x61\56\151\x64\x5f\153\x65\x6c\x61\x73", $id_kelas);
goto BFN_B;
bJs1m:
$this->db->select("\x62\56\151\x64\x5f\x73\151\163\167\141\54\40\x62\x2e\x6e\x61\x6d\141\x2c\x20\142\x2e\156\x69\x73\54\x20\x62\x2e\x6e\x69\x73\156\x2c\x20\x62\56\x66\157\x74\x6f\54" . "\40\50\123\105\114\105\x43\x54\40\103\117\x55\116\x54\50\x69\x64\x5f\x73\x69\163\167\141\x29\x20\106\x52\x4f\x4d\40\153\145\x6c\x61\163\137\x63\x61\x74\141\x74\141\156\137\x6d\141\x70\145\154\x20\143\x20\127\x48\105\x52\x45\x20\x63\x2e\x69\x64\x5f\x73\151\x73\167\141\40\x3d\40\142\56\151\x64\x5f\x73\x69\x73\167\x61\x20\x41\116\x44\40\x63\56\x69\144\137\155\141\160\145\154\40\75\x20" . $id_mapel . "\40\x41\116\104\40\143\56\x74\171\x70\x65\40\75\x20\x27\62\x27\x29\x20\x41\x53\40\x6a\x6d\x6c\x5f\143\x61\x74\x61\x74\141\156");
goto GHVZB;
BFN_B:
return $this->db->get()->result();
goto sILtU;
amHBl:
$this->db->where("\141\x2e\151\x64\x5f\x73\x6d\164", $id_smt);
goto vN1W8;
wB_HD:
$this->db->where("\x61\x2e\x69\x64\x5f\x74\x70", $id_tp);
goto amHBl;
FnGMw:
$this->db->join("\x6d\141\x73\x74\145\x72\x5f\x73\151\163\x77\x61\40\142", "\142\x2e\x69\144\x5f\x73\151\x73\x77\141\x3d\x61\x2e\x69\144\137\163\x69\x73\167\x61", "\x6c\x65\x66\x74");
goto wB_HD;
sILtU:
}
public function getAllCatatanMapelSiswa($id_siswa, $id_mapel, $id_tp, $id_smt)
{
goto dGKrB;
e6hva:
return $this->db->get()->result();
goto Y7Ahb;
IbGuG:
$this->db->where("\x69\144\137\x6d\141\x70\x65\x6c", $id_mapel);
goto Ur1Eq;
Gezan:
$this->db->order_by("\164\147\154", "\x44\105\123\103");
goto e6hva;
fXbW6:
$this->db->where("\x69\144\137\x73\155\x74", $id_smt);
goto Gezan;
IZ2z2:
$this->db->where("\151\144\137\x73\x69\x73\x77\141", $id_siswa);
goto IbGuG;
x8soH:
$this->db->from("\x6b\145\154\141\163\x5f\143\141\x74\x61\x74\x61\156\x5f\x6d\141\x70\145\154");
goto IZ2z2;
dGKrB:
$this->db->select("\x2a");
goto x8soH;
Ur1Eq:
$this->db->where("\151\x64\x5f\164\x70", $id_tp);
goto fXbW6;
Y7Ahb:
}
public function getCatatanMapelBySiswa($id_kelas, $id_tp, $id_smt)
{
goto lWMkD;
TgyTT:
return $this->db->get()->result();
goto N72mZ;
sVuDf:
$this->db->from("\153\x65\x6c\x61\x73\x5f\x63\141\x74\x61\x74\141\x6e\137\155\x61\160\x65\154\x20\141");
goto py2hE;
lWMkD:
$this->db->select("\x61\56\x2a\54\40\x62\56\156\x61\155\141\137\147\165\x72\165\54\40\x62\56\x6e\151\x70\x2c\40\142\x2e\146\157\x74\157");
goto sVuDf;
vwt_s:
$this->db->where("\141\x2e\x69\144\x5f\163\155\x74", $id_smt);
goto TgyTT;
Nt6sI:
$this->db->where("\x61\x2e\151\x64\137\x74\x70", $id_tp);
goto vwt_s;
py2hE:
$this->db->join("\155\141\163\x74\145\x72\137\147\x75\162\x75\x20\x62", "\142\56\x69\x64\137\x67\165\x72\x75\x3d\x61\56\x69\144\137\147\165\162\165");
goto Nt6sI;
N72mZ:
}
public function getCatatanSiswaBySiswa($id_kelas, $id_tp, $id_smt)
{
goto w5Ppw;
w5Ppw:
$this->db->select("\x61\x2e\52\x2c\x20\x63\56\x6e\141\155\141\137\147\165\162\x75\54\40\x63\56\156\151\x70\54\40\143\x2e\x66\157\x74\x6f");
goto oMFXt;
UMUMf:
$this->db->where("\141\x2e\x69\x64\x5f\164\x70", $id_tp);
goto Dh6m9;
rMD0H:
$this->db->join("\155\141\163\164\145\162\x5f\x67\x75\x72\x75\40\143", "\x63\56\151\144\137\x67\165\162\165\x3d\142\56\x69\x64\137\x67\165\x72\x75");
goto UMUMf;
oMFXt:
$this->db->from("\153\145\x6c\x61\x73\x5f\x63\141\164\141\x74\x61\x6e\137\167\x61\154\x69\x20\x61");
goto XJrSG;
Dh6m9:
$this->db->where("\x61\x2e\x69\144\137\x73\x6d\x74", $id_smt);
goto vdclO;
XJrSG:
$this->db->join("\x6a\x61\x62\x61\x74\x61\x6e\x5f\x67\165\x72\x75\x20\x62", "\x62\x2e\151\x64\137\x6b\x65\154\141\163\x3d\x61\56\x69\x64\137\153\145\154\x61\163");
goto rMD0H;
vdclO:
return $this->db->get()->result();
goto Evdpp;
Evdpp:
}
public function getCatatanMapelSiswaDetail($id_catatan)
{
goto HOPXv;
hpv20:
$this->db->join("\152\141\142\x61\x74\141\x6e\x5f\147\165\162\x75\x20\x63", "\143\56\151\144\137\x67\165\162\x75\75\x61\x2e\x69\x64\137\147\x75\162\165");
goto Si7N0;
am5My:
return $this->db->get()->row();
goto ZfmCh;
HOPXv:
$this->db->select("\141\56\52\x2c\40\x62\56\156\141\x6d\x61\137\147\165\162\165\54\x20\x62\56\x6e\x69\160\54\40\142\x2e\146\x6f\x74\x6f\54\40\x64\56\x6c\145\x76\x65\x6c\40\141\163\40\152\x61\142\141\x74\x61\x6e\54\40\x65\x2e\156\x61\155\141\x5f\155\141\x70\x65\154\54\40\x65\56\x6b\x6f\144\145");
goto AAJ9I;
YDzYd:
$this->db->join("\x6d\x61\x73\164\x65\162\x5f\155\141\x70\145\x6c\40\145", "\x65\56\x69\x64\x5f\155\x61\160\x65\154\x3d\x61\56\151\x64\137\155\x61\x70\x65\x6c");
goto c5dHS;
Si7N0:
$this->db->join("\x6c\x65\x76\x65\x6c\x5f\x67\165\162\x75\x20\144", "\144\x2e\151\x64\x5f\154\145\166\x65\x6c\x3d\143\x2e\x69\144\137\x6a\x61\142\141\164\141\156");
goto YDzYd;
m_kom:
$this->db->join("\155\x61\x73\x74\x65\x72\x5f\x67\x75\162\x75\x20\142", "\x62\56\x69\144\137\147\165\x72\165\x3d\141\56\151\144\137\x67\165\162\165");
goto hpv20;
AAJ9I:
$this->db->from("\153\x65\154\x61\x73\x5f\x63\141\x74\x61\x74\141\156\137\155\x61\160\x65\154\x20\141");
goto m_kom;
c5dHS:
$this->db->where("\141\56\x69\x64\137\x63\x61\x74\x61\164\141\156", $id_catatan);
goto am5My;
ZfmCh:
}
public function getCatatanKelasSiswaDetail($id_catatan)
{
goto rEuwC;
eInCW:
$this->db->join("\155\x61\x73\164\145\162\x5f\x6b\145\x6c\x61\163\x20\x66", "\146\x2e\151\144\137\x6b\145\154\141\163\x3d\141\x2e\x69\144\137\x6b\x65\154\141\163");
goto psSL3;
rEuwC:
$this->db->select("\141\56\52\54\x20\x63\x2e\x6e\x61\155\x61\x5f\147\165\x72\165\x2c\x20\x63\56\156\x69\160\x2c\x20\143\56\x66\x6f\x74\x6f\54\x20\145\x2e\154\x65\x76\145\x6c\x20\x61\x73\40\x6a\141\x62\141\x74\x61\156\x2c\40\146\56\x6e\x61\155\x61\137\153\x65\154\x61\163");
goto L2YSA;
L2YSA:
$this->db->from("\153\145\154\x61\163\137\x63\141\x74\x61\164\141\156\x5f\167\141\x6c\x69\40\x61");
goto TWpN7;
piZn3:
$this->db->join("\x6c\x65\166\145\x6c\137\147\165\x72\165\40\x65", "\145\56\x69\144\137\x6c\x65\x76\145\x6c\x3d\x62\56\151\x64\137\152\x61\x62\141\164\x61\156");
goto eInCW;
psSL3:
$this->db->where("\x61\x2e\x69\x64\x5f\x63\x61\x74\141\x74\141\x6e", $id_catatan);
goto uqsaW;
TWpN7:
$this->db->join("\152\141\x62\x61\x74\x61\x6e\137\147\165\162\x75\x20\x62", "\x62\x2e\x69\144\137\153\x65\x6c\x61\x73\x3d\x61\56\x69\144\x5f\153\145\x6c\141\163");
goto yMLIO;
uqsaW:
return $this->db->get()->row();
goto Z16rW;
yMLIO:
$this->db->join("\155\141\163\x74\x65\162\137\147\x75\x72\x75\40\x63", "\143\x2e\151\144\137\147\165\162\x75\75\142\x2e\x69\144\x5f\x67\165\162\165");
goto piZn3;
Z16rW:
}
public function getReading($table, $id_catatan)
{
goto Datfx;
Datfx:
$this->db->select("\x72\x65\x61\x64\151\156\147\54\x20\164\171\x70\145\54\40\x72\145\x61\x64\x65\x64");
goto QkZ6A;
zixo0:
return $this->db->get($table)->row();
goto aiZZK;
QkZ6A:
$this->db->where("\151\144\x5f\143\141\164\141\164\x61\x6e", $id_catatan);
goto zixo0;
aiZZK:
}
}
Function Calls
| None |
Stats
| MD5 | d5b3dbdd433d5cb51231ebfabad84497 |
| Eval Count | 0 |
| Decode Time | 266 ms |