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 Cbt_model extends CI_Model
{
public function get_where($table, $pk, $id, $join = null, $order = null) { goto RV4d1;
YfZjq: KG_Fg: goto SJAMb;
kSZ1k: foreach ($order as $field => $sort) { $this->db->order_by($field, $sort);
BGpqt: } goto YfZjq;
bE9lo: if (!($join !== null)) { goto p_UDq;
} goto VDplZ;
Uzv3i: $this->db->where($pk, $id);
goto bE9lo;
VDplZ: foreach ($join as $table => $field) { $this->db->join($table, $field);
R_mhI: } goto Z6Uhj;
Z6Uhj: J80Bl: goto UV7SR;
RV4d1: $this->db->select("*");
goto QOUhb;
jb_rk: if (!($order !== null)) { goto Ed3k9;
} goto kSZ1k;
GFsZN: return $query;
goto lKvIH;
UV7SR: p_UDq: goto jb_rk;
QOUhb: $this->db->from($table);
goto Uzv3i;
a29wT: $query = $this->db->get();
goto GFsZN;
SJAMb: Ed3k9: goto a29wT;
lKvIH: }
public function saveLog($id_siswa, $id_jadwal, $type, $desc) { goto f6SsT;
JtnFw: $ip = $this->input->ip_address();
goto tMWfK;
tAzN2: if ($agent == "unknown") { goto pYml_;
} goto zstRk;
zstRk: $os = $this->agent->platform();
goto JtnFw;
DB1Y8: pYml_: goto EcInN;
PFaUM: goto sBDo7;
goto DB1Y8;
ovEs6: $agent = $this->agent->mobile();
goto P2J8I;
aCIzX: goto tp8vY;
goto B3sT6;
B3sT6: tJmzJ: goto ovEs6;
ZSJCZ: $agent = "unknown";
goto S6wrG;
S6wrG: goto tp8vY;
goto bGxiI;
bGxiI: HtwID: goto oWQ3d;
P2J8I: tp8vY: goto tAzN2;
f6SsT: if ($this->agent->is_browser()) { goto HtwID;
} goto Is5PR;
oWQ3d: $agent = $this->agent->browser() . " " . $this->agent->version();
goto aCIzX;
Is5PR: if ($this->agent->is_mobile()) { goto tJmzJ;
} goto ZSJCZ;
EcInN: return "error";
goto lzMiz;
lzMiz: sBDo7: goto Bl_jD;
tMWfK: return $this->insertLog($id_siswa, $id_jadwal, $type, $desc, $agent, $os, $ip);
goto PFaUM;
Bl_jD: } private function insertLog($id_siswa, $id_jadwal, $type, $desc, $agent, $os, $ip) { goto FCb2m;
gZCzz: return $insert;
goto VP5Oc;
wzWwg: $insert = $this->db->update("log_ujian");
goto xD65y;
rFm4P: A9hMj: goto ZnJyX;
xD65y: thwTS: goto gZCzz;
TaNAm: $data = array("id_log" => $id_siswa . "0" . $id_jadwal . $type, "id_siswa" => $id_siswa, "id_jadwal" => $id_jadwal, "log_type" => $type, "log_desc" => $desc, "address" => $ip, "agent" => $agent, "device" => $os);
goto uJoKx;
gO_sf: $this->db->where("id_log", $id_siswa . "0" . $id_jadwal . $type);
goto wzWwg;
ZnJyX: $this->db->set("log_type", $type);
goto S3B3q;
uJoKx: $insert = $this->db->insert("log_ujian", $data);
goto qzDSI;
qzDSI: goto thwTS;
goto rFm4P;
FCb2m: $log = $this->db->where("id_log", $id_siswa . "0" . $id_jadwal . $type)->get("log_ujian")->row();
goto Fnwl8;
S3B3q: $this->db->set("log_desc", $desc);
goto gO_sf;
Fnwl8: if ($log != null) { goto A9hMj;
} goto TaNAm;
VP5Oc: }
public function getDataSiswa($username, $id_tp, $id_smt) { goto Z0fuU;
Dtl_i: $this->db->join("master_kelas c", "b.id_kelas=c.id_kelas AND c.id_tp=" . $id_tp . " AND c.id_smt=" . $id_smt, "left");
goto sjVqM;
MB1bE: $query = $this->db->get()->row();
goto aSkwB;
aSkwB: return $query;
goto cLXVy;
ViM3W: $this->db->from("master_siswa a");
goto tp_l1;
tp_l1: $this->db->join("kelas_siswa b", "a.id_siswa=b.id_siswa AND b.id_tp=" . $id_tp . " AND b.id_smt=" . $id_smt, "left");
goto Dtl_i;
sjVqM: $this->db->join("cbt_sesi_siswa d", "a.id_siswa=d.siswa_id", "left");
goto Mfzlj;
Z0fuU: $this->db->select("a.id_siswa, a.nisn, a.nis, a.nama, a.jenis_kelamin, a.username, a.password, a.agama, a.foto," . " b.id_kelas_siswa, b.id_tp, b.id_smt, b.id_siswa, b.id_kelas," . " c.nama_kelas, c.kode_kelas, c.level_id, " . " d.kelas_id, d.ruang_id, d.sesi_id");
goto ViM3W;
Mfzlj: $this->db->where("username", $username);
goto MB1bE;
cLXVy: }
public function getDataSiswaById($id_tp, $id_smt, $idSiswa) { goto Fee3b;
Kvc2A: $this->db->join("cbt_ruang i", "i.id_ruang=h.id_ruang", "left");
goto v2WLN;
q4a0w: $this->db->join("cbt_kelas_ruang h", "h.id_kelas=a.id_kelas", "left");
goto Kvc2A;
cJBIF: $this->db->join("master_siswa b", "b.id_siswa=a.id_siswa", "left");
goto ijFiC;
ijFiC: $this->db->join("cbt_sesi_siswa c", "c.siswa_id=a.id_siswa", "left");
goto P92Jz;
da9aF: $this->db->join("master_kelas f", "f.id_kelas=a.id_kelas", "left");
goto al7SH;
VRZ6f: return $this->db->get()->row();
goto skZkT;
yDVxb: $this->db->join("cbt_sesi e", "e.id_sesi=c.sesi_id", "left");
goto da9aF;
P92Jz: $this->db->join("cbt_ruang d", "d.id_ruang=c.ruang_id", "left");
goto yDVxb;
v2WLN: $this->db->join("cbt_sesi j", "j.id_sesi=h.id_sesi", "left");
goto tJdfY;
m2rD1: $this->db->where("a.id_siswa", $idSiswa);
goto VRZ6f;
al7SH: $this->db->join("cbt_nomor_peserta g", "g.id_siswa=a.id_siswa AND g.id_tp=" . $id_tp, "left");
goto q4a0w;
iGx70: $this->db->where("a.id_smt", $id_smt);
goto m2rD1;
tJdfY: $this->db->where("a.id_tp", $id_tp);
goto iGx70;
q94u6: $this->db->from("kelas_siswa a");
goto cJBIF;
Fee3b: $this->db->select("b.id_siswa, b.nama, b.jenis_kelamin, b.nis, b.nisn, b.username, b.password," . " b.foto, c.sesi_id, d.kode_ruang, e.kode_sesi, f.nama_kelas, g.nomor_peserta," . " h.set_siswa, i.kode_ruang as ruang_kelas, j.kode_sesi as sesi_kelas");
goto q94u6;
skZkT: }
public function getWaktuSesiById($id_sesi) { goto TUNqm;
cjkhZ: $result = $this->db->get("cbt_sesi")->row();
goto Aei3L;
TUNqm: $this->db->select("*");
goto dbEvG;
dbEvG: $this->db->where("id_sesi", $id_sesi);
goto cjkhZ;
Aei3L: return $result;
goto VxUzX;
VxUzX: }
public function getAllRuang() { goto fJnDe;
fJnDe: $result = $this->db->get("cbt_ruang")->result();
goto c4L5o;
BzUTW: foreach ($result as $key => $row) { $ret[$row->id_ruang] = $row->kode_ruang;
koWBb: } goto y7A0b;
wtMih: if (!$result) { goto diSwK;
} goto BzUTW;
y7A0b: vLWe8: goto FmKmy;
SELhl: return $ret;
goto izLCN;
c4L5o: $ret = [];
goto wtMih;
FmKmy: diSwK: goto SELhl;
izLCN: }
public function getKelasByLevel($level, $arrKelas) { goto mayez;
dZwaL: $this->db->where("level_id", $level);
goto CCn0U;
PvHjw: $result = $this->db->get("master_kelas")->result();
goto TMEfh;
TMEfh: return $result;
goto EnU13;
mayez: $this->db->select("id_kelas, kode_kelas");
goto dZwaL;
CCn0U: $this->db->where_in("id_kelas", $arrKelas);
goto PvHjw;
EnU13: }
public function getAllJurusan() { goto y5zT6;
X01i4: EZ470: goto z11BL;
CNdwk: if (!$result) { goto IkR2T;
} goto rEGdG;
rEGdG: foreach ($result as $key => $row) { $ret[$row->id_jurusan] = $row->kode_jurusan;
A1uHJ: } goto X01i4;
vGN7c: return $ret;
goto d0_Od;
y5zT6: $result = $this->db->get("master_jurusan")->result();
goto CNdwk;
z11BL: IkR2T: goto vGN7c;
d0_Od: }
public function getPengawas($id_pengawas) { goto KyT7T;
KyT7T: $this->db->select("id_pengawas, id_jadwal, id_tp, id_smt, id_ruang, id_sesi, id_guru");
goto Qvy6Z;
Qvy6Z: $this->db->from("cbt_pengawas");
goto XAQ9Q;
XAQ9Q: $this->db->where("id_pengawas", $id_pengawas);
goto kwh7t;
kwh7t: return $this->db->get()->row();
goto yU7fp;
yU7fp: }
public function getPengawasByGuru($tp, $smt, $id_guru) { goto Bnmap;
gC8Aq: $this->db->where("a.id_smt", $smt);
goto csrAw;
csrAw: $this->db->like("a.id_guru", $id_guru);
goto WW227;
XLtIA: $this->db->join("cbt_bank_soal c", "b.id_bank=c.id_bank");
goto fvTd5;
fvTd5: return $this->db->get()->result();
goto S19Lf;
kYGL3: $this->db->where("a.id_tp", $tp);
goto gC8Aq;
WW227: $this->db->join("cbt_jadwal b", "b.id_jadwal=a.id_jadwal");
goto XLtIA;
Bnmap: $this->db->select("a.id_pengawas, a.id_jadwal, a.id_tp, a.id_smt, a.id_ruang, a.id_sesi, a.id_guru," . " b.id_jadwal, b.tgl_mulai, b.tgl_selesai, c.bank_kode");
goto OMaMS;
OMaMS: $this->db->from("cbt_pengawas a");
goto kYGL3;
S19Lf: }
public function getPengawasByJadwal($tp, $smt, $id_jadwal, $sesi = null, $ruang = null) { goto g2Brm;
b9tuP: $this->db->from("cbt_pengawas");
goto DrT2v;
DrT2v: $this->db->where("id_tp", $tp);
goto V56pB;
jvQlO: return $result;
goto B4RQG;
V56pB: $this->db->where("id_smt", $smt);
goto ymkVp;
boq4u: $result = $this->db->get()->result();
goto jvQlO;
ymkVp: $this->db->where("id_jadwal", $id_jadwal);
goto fL8ph;
YVPFq: $this->db->where("id_sesi", $sesi);
goto SjuQg;
fL8ph: if (!($sesi != null)) { goto zjZIs;
} goto YVPFq;
PSlus: if (!($ruang != null)) { goto Cankt;
} goto y2X8j;
QHeY4: Cankt: goto boq4u;
y2X8j: $this->db->where("id_ruang", $ruang);
goto QHeY4;
g2Brm: $this->db->select("id_pengawas, id_guru");
goto b9tuP;
SjuQg: zjZIs: goto PSlus;
B4RQG: }
public function getAllPengawas($tp, $smt, $ruang = null, $sesi = null) { goto XF7ZU;
B42Ej: $result = $this->db->get()->result();
goto QtB4W;
ejtz3: foreach ($result as $key => $row) { $ret[$row->id_jadwal][$row->id_ruang][$row->id_sesi] = $row;
snSf8: } goto HP2Yr;
ianzc: mjdUZ: goto MDPwk;
iMTeb: $this->db->from("cbt_pengawas");
goto zgAVQ;
MDPwk: return $ret;
goto Y4Xw4;
xfDj0: qBdVz: goto cVLB3;
wy6su: if (!($ruang != null)) { goto qBdVz;
} goto M7LZW;
iavgo: $this->db->where("id_smt", $smt);
goto wy6su;
XF7ZU: $this->db->select("id_pengawas, id_jadwal, id_ruang, id_sesi, id_guru");
goto iMTeb;
N_UP6: $this->db->where("id_sesi", $sesi);
goto JSsSO;
H7Sw0: if (!$result) { goto mjdUZ;
} goto ejtz3;
M7LZW: $this->db->where("id_ruang", $ruang);
goto xfDj0;
zgAVQ: $this->db->where("id_tp", $tp);
goto iavgo;
HP2Yr: QV9bP: goto ianzc;
cVLB3: if (!($sesi != null)) { goto Iekbf;
} goto N_UP6;
JSsSO: Iekbf: goto B42Ej;
QtB4W: $ret = [];
goto H7Sw0;
Y4Xw4: }
public function getDistinctRuang($tp, $smt, $arrKelas) { goto zvMRn;
mn9Rj: $this->db->select("a.ruang_id, a.sesi_id, b.kode_ruang, b.nama_ruang, c.kode_sesi, c.nama_sesi");
goto H2exr;
guQUw: $this->db->where_in("kelas_id", $arrKelas);
goto ggCoh;
BxhTV: $this->db->join("cbt_sesi c", "c.id_sesi=a.sesi_id");
goto EmHWd;
Piulw: $ret = [];
goto Xb6Mi;
wqSq1: EsSDZ: goto p2Qvc;
LcjeZ: foreach ($result as $key => $row) { $ret[$row->ruang_id][$row->sesi_id] = $row;
BtisS: } goto wqSq1;
DM20D: $this->db->order_by("c.nama_sesi", "ASC");
goto ztzvH;
H2exr: $this->db->from("cbt_sesi_siswa a");
goto xOBwN;
zvMRn: $this->db->distinct("a.ruang_id");
goto mn9Rj;
p2Qvc: I424D: goto Y5g_K;
ggCoh: FpeLt: goto Bh_4l;
ztzvH: $result = $this->db->get()->result();
goto Piulw;
xOBwN: $this->db->join("cbt_ruang b", "b.id_ruang=a.ruang_id");
goto BxhTV;
Bh_4l: $this->db->order_by("b.nama_ruang", "ASC");
goto DM20D;
Y5g_K: return $ret;
goto t3oEF;
Xb6Mi: if (!$result) { goto I424D;
} goto LcjeZ;
EmHWd: if (!(count($arrKelas) > 0)) { goto FpeLt;
} goto guQUw;
t3oEF: }
public function getKelasUjian($kelas_id) { goto itaEx;
Edlse: rRwDS: goto TJeFo;
EUO0y: if (!$result) { goto uOSX5;
} goto PmFot;
itaEx: $this->db->select("kelas_id, ruang_id, sesi_id");
goto Ai8VN;
TXjqY: $ret = [];
goto EUO0y;
Zqwg6: $result = $this->db->get()->result();
goto TXjqY;
Ai8VN: $this->db->from("cbt_sesi_siswa");
goto AzWOU;
PmFot: foreach ($result as $key => $row) { $ret[$row->ruang_id][$row->sesi_id][] = $row->kelas_id;
LseSV: } goto Edlse;
AzWOU: $this->db->where("kelas_id", $kelas_id);
goto Zqwg6;
dIRQH: return $ret;
goto oCMRv;
TJeFo: uOSX5: goto dIRQH;
oCMRv: }
public function getDistinctKelasLevel($tp, $smt, $arrLevel) { goto LxXru;
ezh5H: $this->db->from("master_kelas");
goto QFffS;
QFffS: $this->db->where("id_tp", $tp);
goto rZuTR;
lZkD0: return $result;
goto vHQmP;
nYFSu: $result = $this->db->get()->result();
goto lZkD0;
LxXru: $this->db->select("id_kelas, level_id");
goto tVKyJ;
tVKyJ: $this->db->distinct();
goto ezh5H;
rZuTR: $this->db->where("id_smt", $smt);
goto QcnJA;
QcnJA: $this->db->where_in("level_id", $arrLevel);
goto nYFSu;
vHQmP: }
public function getAllJenisUjian() { goto VduaV;
VduaV: $result = $this->db->get("cbt_jenis")->result();
goto sOFlQ;
lzC11: if (!$result) { goto H2Jl1;
} goto H80Ew;
sOFlQ: $ret[''] = "Jenis Penilaian :";
goto lzC11;
Vhc7R: return $ret;
goto yUjNL;
xNYFr: H2Jl1: goto Vhc7R;
R3RAq: XEEOe: goto xNYFr;
H80Ew: foreach ($result as $key => $row) { $ret[$row->id_jenis] = $row->kode_jenis;
oC7pX: } goto R3RAq;
yUjNL: }
public function getAllJenisUjianByArrJenis($arrJenis) { goto foLa5;
foLa5: $this->db->where_in("id_jenis", $arrJenis);
goto xUe2q;
TVB3b: return $ret;
goto L4h13;
aFKW6: $ret[''] = "Jenis Penilaian :";
goto x3l5A;
xUe2q: $result = $this->db->get("cbt_jenis")->result();
goto aFKW6;
x3l5A: if (!$result) { goto HJNen;
} goto AKkez;
lmoUU: HJNen: goto TVB3b;
Dn2lc: umaWf: goto lmoUU;
AKkez: foreach ($result as $key => $row) { $ret[$row->id_jenis] = $row->kode_jenis;
MXqra: } goto Dn2lc;
L4h13: }
public function getPengawasHariIni($tgl) { goto CsHVA;
stE6v: return $this->db->get()->result();
goto iZN5H;
XdiTN: $this->db->join("cbt_pengawas b", "b.id_jadwal=a.id_jadwal");
goto Nd7o2;
hMIlV: $this->db->where("a.tgl_mulai <= '{$tgl}' AND a.tgl_selesai >= '{$tgl}'");
goto XdiTN;
CsHVA: $this->db->from("cbt_jadwal a");
goto hMIlV;
Nd7o2: $this->db->where("status", "1");
goto stE6v;
iZN5H: }
public function getJadwalGuru($tp, $smt, $guru) { goto ns4ad;
hGXp3: $this->db->where("a.id_smt", $smt);
goto J11WJ;
ns4ad: $this->db->select("a.id_jadwal, a.tgl_mulai, b.bank_kode, b.bank_kelas");
goto KGVH7;
KGVH7: $this->db->from("cbt_jadwal a");
goto nz829;
J11WJ: return $this->db->get()->result();
goto ZYPTa;
iS5m6: $this->db->where("a.id_tp", $tp);
goto hGXp3;
nz829: $this->db->join("cbt_bank_soal b", "b.id_bank=a.id_bank AND b.bank_guru_id=" . $guru);
goto iS5m6;
ZYPTa: }
public function getJadwalKelas($tp, $smt) { goto YjShu;
dpnxs: $this->db->from("cbt_jadwal a");
goto kLxFc;
KzuO8: $this->db->where("a.id_tp", $tp);
goto Rp6Ki;
YjShu: $this->db->select("a.id_jadwal, a.tgl_mulai, b.bank_kode, b.bank_kelas");
goto dpnxs;
dtQgz: return $this->db->get()->result();
goto o16rk;
Rp6Ki: $this->db->where("a.id_smt", $smt);
goto dtQgz;
kLxFc: $this->db->join("cbt_bank_soal b", "b.id_bank=a.id_bank");
goto KzuO8;
o16rk: }
public function getJadwalByJenis($jenis, $level, $dari, $sampai) { goto rRing;
t1PpD: $this->db->order_by("a.jam_ke", "ASC");
goto EBvmU;
rRing: $this->db->select("a.id_jadwal, a.id_bank, a.id_jenis, a.tgl_mulai, a.tgl_selesai, a.jam_ke," . " c.bank_kode, c.bank_level, c.bank_kelas, b.kode_jenis, b.nama_jenis, d.kode, d.nama_mapel");
goto Yvu8r;
U0XXc: $this->db->where("a.tgl_mulai <=", $sampai);
goto eySq8;
eySq8: x9vJE: goto CCcBf;
CLkCc: $this->db->where("a.tgl_mulai >=", $dari);
goto D37TD;
cjLVp: FxcJ6: goto HmEg5;
CCcBf: $this->db->order_by("a.tgl_mulai", "ASC");
goto t1PpD;
oIh_t: return $result;
goto HHC8D;
gt8gN: if (!($sampai != null)) { goto x9vJE;
} goto U0XXc;
Y0wXJ: $this->db->join("master_mapel d", "d.id_mapel=c.bank_mapel_id");
goto DxnKA;
Ktevq: $this->db->join("cbt_jenis b", "b.id_jenis=a.id_jenis");
goto RPyW6;
pptKH: $this->db->where("c.bank_level", $level);
goto cjLVp;
EBvmU: $result = $this->db->get()->result();
goto oIh_t;
HmEg5: if (!($dari != null)) { goto ZMGCA;
} goto CLkCc;
R7Rag: if (!($level != "0")) { goto FxcJ6;
} goto pptKH;
DxnKA: $this->db->where("a.id_jenis", $jenis);
goto R7Rag;
RPyW6: $this->db->join("cbt_bank_soal c", "c.id_bank=a.id_bank");
goto Y0wXJ;
Yvu8r: $this->db->from("cbt_jadwal a");
goto Ktevq;
D37TD: ZMGCA: goto gt8gN;
HHC8D: }
public function getAllJadwalByJenis($jenis, $tp, $smt) { goto cZFor;
SmwyJ: xGqpz: goto CM_Gl;
MpxtV: $this->db->where("a.id_smt", $smt);
goto J0umV;
xAwkz: $this->db->order_by("a.jam_ke", "ASC");
goto qQ2zf;
qQ2zf: $this->db->order_by("c.bank_level", "ASC");
goto pbDOW;
z9GOm: $this->db->from("cbt_jadwal a");
goto WUThf;
WJP9D: $ret = [];
goto P8bO_;
juo2x: foreach ($result as $key => $row) { $ret[$row->tgl_mulai][$row->id_mapel][] = $row;
TkChQ: } goto E8tLl;
UEgnx: s6sLz: goto KLxU_;
pbDOW: $result = $this->db->get()->result();
goto WJP9D;
cZFor: $this->db->select("a.id_jadwal, a.id_jenis, a.tgl_mulai, " . "c.bank_kode, c.bank_level, c.bank_kelas, b.kode_jenis, b.nama_jenis, d.id_mapel, d.kode, d.nama_mapel");
goto z9GOm;
QCXKJ: $this->db->where("a.id_jenis", $jenis);
goto SmwyJ;
WUThf: $this->db->join("cbt_jenis b", "b.id_jenis=a.id_jenis");
goto C43Of;
CM_Gl: $this->db->where("a.id_tp", $tp);
goto MpxtV;
C43Of: $this->db->join("cbt_bank_soal c", "c.id_bank=a.id_bank");
goto oOtpJ;
E8tLl: Jw141: goto UEgnx;
oOtpJ: $this->db->join("master_mapel d", "d.id_mapel=c.bank_mapel_id");
goto oILmf;
oILmf: if (!($jenis != null)) { goto xGqpz;
} goto QCXKJ;
KLxU_: return $ret;
goto Me1Xb;
P8bO_: if (!$result) { goto s6sLz;
} goto juo2x;
J0umV: $this->db->order_by("a.tgl_mulai", "ASC");
goto xAwkz;
Me1Xb: }
public function getAllBankSoal($guru = null) { goto dWmm2;
fb8MQ: if (!$result) { goto DyXAu;
} goto Y21Wo;
Ih7ZG: d7yPE: goto QbANU;
Hgd3N: y7HoG: goto esPJ2;
dWmm2: $this->db->select("id_bank, bank_kode");
goto Yoab5;
Y21Wo: foreach ($result as $key => $row) { $ret[$row->id_bank] = $row->bank_kode;
h32We: } goto Hgd3N;
Yoab5: if (!($guru !== null)) { goto d7yPE;
} goto K5X30;
QbANU: $result = $this->db->get("cbt_bank_soal")->result();
goto GUyFb;
K5X30: $this->db->where("bank_guru_id", $guru);
goto Ih7ZG;
GUyFb: $ret["0"] = "Pilih Bank Soal :";
goto fb8MQ;
esPJ2: DyXAu: goto Ss7Rb;
Ss7Rb: return $ret;
goto SNbB3;
SNbB3: }
public function getAllBankSoalByTp($id_tp, $id_smt, $guru = null) { goto OVAJB;
onqJt: $this->db->where("bank_guru_id", $guru);
goto TxbXv;
RZ8TN: $result = $this->db->get("cbt_bank_soal")->result();
goto q_2jk;
TQhQX: return $ret;
goto fjVZU;
q_2jk: $ret = [];
goto CN0Tx;
OVAJB: $this->db->select("id_bank, bank_kode, bank_mapel_id, tampil_pg, tampil_kompleks, tampil_jodohkan, tampil_isian, tampil_esai");
goto VLJEA;
H2YyY: foreach ($result as $key => $row) { $ret[$row->id_bank] = $row;
sZwLi: } goto XMR_x;
AurCu: $this->db->where("status_soal", "1");
goto E1Z2C;
TxbXv: TXsr3: goto RZ8TN;
VLJEA: $this->db->where("id_tp", $id_tp);
goto U0_iU;
CN0Tx: if (!$result) { goto W2Rl2;
} goto H2YyY;
E1Z2C: if (!($guru !== null)) { goto TXsr3;
} goto onqJt;
Di72a: $this->db->where("status", "1");
goto AurCu;
g3R7b: W2Rl2: goto TQhQX;
XMR_x: HohLb: goto g3R7b;
U0_iU: $this->db->where("id_smt", $id_smt);
goto Di72a;
fjVZU: }
public function getAllBankSoalByMapel($id_tp, $id_smt, $mapel) { goto lVyIC;
WcDSv: $ret = [];
goto d94GT;
VxpML: $this->db->where("status", "1");
goto X1FnO;
vMVAX: $this->db->from("cbt_bank_soal");
goto uDGjT;
ZxV32: foreach ($result as $key => $row) { $ret[$row->id_bank] = $row;
zNEAK: } goto xzpY5;
X1FnO: $result = $this->db->get()->result();
goto WcDSv;
TdggA: return $ret;
goto hKpHC;
zymlI: $this->db->where("bank_mapel_id", $mapel);
goto VxpML;
d94GT: if (!$result) { goto ui_tk;
} goto ZxV32;
PJWrp: $this->db->where("id_smt", $id_smt);
goto zymlI;
disyy: ui_tk: goto TdggA;
uDGjT: $this->db->where("id_tp", $id_tp);
goto PJWrp;
lVyIC: $this->db->select("id_bank, bank_kode, bank_mapel_id, tampil_pg, tampil_kompleks, tampil_jodohkan, tampil_isian, tampil_esai, status");
goto vMVAX;
xzpY5: YPmoW: goto disyy;
hKpHC: }
public function getJumlahJenisSoal($id_bank) { goto CRZdr;
oxZu8: foreach ($result as $row) { $ret[$row->jenis][] = $row;
HAo8r: } goto fb4KG;
b_s3t: $this->db->where("tampilkan", "1");
goto e1MfD;
TXpGv: $this->db->where("bank_id", $id_bank);
goto b_s3t;
PVZwO: if (!$result) { goto Wrufm;
} goto oxZu8;
fb4KG: Fmd1p: goto nmuc_;
zIKF4: return $ret;
goto cXB5U;
nmuc_: Wrufm: goto zIKF4;
BYgVk: $this->db->from("cbt_soal");
goto TXpGv;
BpfEI: $ret = [];
goto PVZwO;
CRZdr: $this->db->select("id_soal, jenis");
goto BYgVk;
e1MfD: $result = $this->db->get()->result();
goto BpfEI;
cXB5U: }
public function getJenis() { goto dduyU;
ftHi8: return $this->datatables->generate();
goto LWfxF;
dduyU: $this->datatables->select("*");
goto HFSW1;
HFSW1: $this->datatables->from("cbt_jenis");
goto ftHi8;
LWfxF: }
public function getJenisById($id) { goto gGrlY;
YZWAA: $this->db->from("cbt_jenis");
goto RzXMt;
gGrlY: $this->db->select("id_jenis, nama_jenis, kode_jenis");
goto YZWAA;
sHz7D: return $this->db->get()->row();
goto Pzggx;
RzXMt: $this->db->where(["id_jenis" => $id]);
goto sHz7D;
Pzggx: } function updateJenis() { goto JCGkU;
NxXxU: $name = $this->input->post("nama_jenis", true);
goto uCtzI;
zDQcS: $this->db->set("nama_jenis", $name);
goto CyOrN;
CyOrN: $this->db->set("kode_jenis", $kode);
goto REOun;
uCtzI: $kode = $this->input->post("kode_jenis", true);
goto zDQcS;
JCGkU: $id = $this->input->post("id_jenis");
goto NxXxU;
pWOm7: return $this->db->update("cbt_jenis");
goto vqciL;
REOun: $this->db->where("id_jenis", $id);
goto pWOm7;
vqciL: }
public function getRuang() { goto D7wr3;
R3wAJ: $this->datatables->from("cbt_ruang");
goto vv02u;
vv02u: return $this->datatables->generate();
goto OllQL;
D7wr3: $this->datatables->select("*, (SELECT COUNT(id_sesi) FROM cbt_sesi) AS jum_sesi");
goto R3wAJ;
OllQL: }
public function getRuangById($id) { goto J8gpR;
EtcCD: $this->db->from("cbt_ruang");
goto DAvpr;
DAvpr: $this->db->where(["id_ruang" => $id]);
goto w9EoC;
w9EoC: return $this->db->get()->row();
goto tT3Ll;
J8gpR: $this->db->select("id_ruang, nama_ruang, kode_ruang");
goto EtcCD;
tT3Ll: }
public function getRuangSesi($tp, $smt) { goto uRhB4;
Lg8ky: L6HlQ: goto P_nzR;
w1lWs: foreach ($result as $row) { $ret[$row->sesi_id][$row->ruang_id][$row->kelas_id] = $row->nama_kelas;
iyuja: } goto QUbCh;
KiAsd: $this->db->join("cbt_ruang b", "b.id_ruang=a.ruang_id");
goto OGOXm;
vAv7Y: if (!$result) { goto L6HlQ;
} goto w1lWs;
OGOXm: $this->db->join("cbt_sesi c", "c.id_sesi=a.sesi_id");
goto VTp9E;
uRhB4: $this->db->select("a.siswa_id, a.sesi_id, a.ruang_id, a.kelas_id, " . "b.nama_ruang, b.kode_ruang, c.nama_sesi, c.kode_sesi, d.nama_kelas");
goto mS2z3;
QUbCh: RJLdV: goto Lg8ky;
P_nzR: return $ret;
goto dVZki;
aP7Hg: $ret = [];
goto vAv7Y;
VTp9E: $this->db->join("master_kelas d", "d.id_kelas=a.kelas_id");
goto GGKD3;
mS2z3: $this->db->from("cbt_sesi_siswa a");
goto KiAsd;
Jff1o: $result = $this->db->get()->result();
goto aP7Hg;
GGKD3: $this->db->order_by("b.nama_ruang", "ASC");
goto siydQ;
siydQ: $this->db->order_by("c.nama_sesi", "ASC");
goto Jff1o;
dVZki: } function updateRuang() { goto Gbgl2;
aiSVX: $name = $this->input->post("nama_ruang", true);
goto M2wG8;
Gbgl2: $id = $this->input->post("id_ruang");
goto aiSVX;
ieOEb: $this->db->where("id_ruang", $id);
goto LA2fl;
LA2fl: return $this->db->update("cbt_ruang");
goto KynpV;
Y3nVj: $this->db->set("nama_ruang", $name);
goto Z_Lt_;
M2wG8: $kode = $this->input->post("kode_ruang", true);
goto Y3nVj;
Z_Lt_: $this->db->set("kode_ruang", $kode);
goto ieOEb;
KynpV: }
public function getSesi() { goto cZjIb;
cZjIb: $this->datatables->select("*");
goto qIt5P;
QD_1n: return $this->datatables->generate();
goto ZK4Zp;
qIt5P: $this->datatables->from("cbt_sesi c");
goto QD_1n;
ZK4Zp: }
public function getAllKodeSesi() { goto V7B0V;
gI6X9: $this->db->from("cbt_sesi");
goto AEJe1;
hOITb: if (!$result) { goto W6Jhn;
} goto Mx6yY;
V7B0V: $this->db->select("id_sesi, nama_sesi, kode_sesi");
goto gI6X9;
kA9av: return $ret;
goto fp1A2;
Mx6yY: foreach ($result as $row) { $ret[$row->kode_sesi] = $row;
AqXso: } goto Zi2Db;
K7E94: $ret = [];
goto hOITb;
Zi2Db: XOZbA: goto kjnJH;
AEJe1: $result = $this->db->get()->result();
goto K7E94;
kjnJH: W6Jhn: goto kA9av;
fp1A2: }
public function getSesiById($id) { goto vcn5L;
fAM_9: $this->db->where(["id_sesi" => $id]);
goto h38sP;
gd8XJ: $this->db->from("cbt_sesi");
goto fAM_9;
h38sP: return $this->db->get()->row();
goto SwLyy;
vcn5L: $this->db->select("id_sesi, nama_sesi, kode_sesi, waktu_mulai, waktu_akhir");
goto gd8XJ;
SwLyy: }
public function getSesiBySiswa($siswa_id) { goto KFEBA;
gZMN9: return $query;
goto vRfHq;
KFEBA: $this->db->where("siswa_id", $siswa_id);
goto bPHkG;
bPHkG: $query = $this->db->get("siswa_sesi")->result();
goto gZMN9;
vRfHq: } function updateSesi() { goto pmG0M;
ZDLEj: $mulai = $this->input->post("waktu_mulai", true);
goto Qbj22;
o9MfN: $this->db->set("waktu_mulai", $mulai);
goto usAHz;
beHDi: $name = $this->input->post("nama_sesi", true);
goto GZPnY;
Ct_g1: $this->db->where("id_sesi", $id);
goto NrSSz;
WXe5K: $this->db->set("nama_sesi", $name);
goto VlRNP;
VlRNP: $this->db->set("kode_sesi", $kode);
goto o9MfN;
NrSSz: return $this->db->update("cbt_sesi");
goto GHyHA;
pmG0M: $id = $this->input->post("id_sesi");
goto beHDi;
Qbj22: $akhir = $this->input->post("waktu_akhir", true);
goto WXe5K;
DDjS4: $this->db->set("aktif", 1);
goto Ct_g1;
usAHz: $this->db->set("waktu_akhir", $akhir);
goto DDjS4;
GZPnY: $kode = $this->input->post("kode_sesi", true);
goto ZDLEj;
GHyHA: }
public function getSiswaCbtInfo($id_siswa, $id_tp, $id_smt) { goto QysmJ;
pkNRT: $this->db->from("kelas_siswa a");
goto sPtwl;
qftQ2: $this->db->where("a.id_tp", $id_tp);
goto eNdN2;
QysmJ: $this->db->select("a.id_kelas_siswa, a.id_tp, a.id_smt, a.id_siswa, a.id_kelas," . " b.siswa_id, b.kelas_id, b.ruang_id, b.sesi_id," . " rk.id_ruang, rk.nama_ruang, rk.kode_ruang," . " sk.id_sesi, sk.nama_sesi, sk.kode_sesi, sk.waktu_mulai, sk.waktu_akhir");
goto pkNRT;
eNdN2: $this->db->where("a.id_smt", $id_smt);
goto qW4T1;
i73T4: $this->db->join("cbt_sesi sk", "b.sesi_id=sk.id_sesi", "left");
goto ACroI;
ACroI: $this->db->where("a.id_siswa", $id_siswa);
goto qftQ2;
sPtwl: $this->db->join("cbt_sesi_siswa b", "a.id_siswa=b.siswa_id", "left");
goto Ema50;
qW4T1: return $this->db->get()->row();
goto JJTE4;
Ema50: $this->db->join("cbt_ruang rk", "b.ruang_id=rk.id_ruang", "left");
goto i73T4;
JJTE4: }
public function getRuangSesiSiswa($id_kelas, $id_tp, $id_smt) { goto e3cGi;
Y3XpH: $this->db->where("a.id_kelas", $id_kelas);
goto DLSo1;
uT27c: $this->db->order_by("b.nama", "ASC");
goto g3St1;
JI8su: $this->db->join("cbt_ruang rk", "e.ruang_id=rk.id_ruang", "left");
goto BS8eC;
DLSo1: $this->db->where("a.id_tp", $id_tp);
goto iV0Dl;
iV0Dl: $this->db->where("a.id_smt", $id_smt);
goto uT27c;
g3St1: return $this->db->get()->result();
goto QAeOh;
qzjdP: $this->db->join("buku_induk i", "i.id_siswa=a.id_siswa AND =i.status=1");
goto Y3XpH;
FYHZo: $this->db->join("master_kelas c", "a.id_kelas=c.id_kelas", "left");
goto ol0AY;
BS8eC: $this->db->join("cbt_sesi sk", "e.sesi_id=sk.id_sesi", "left");
goto qzjdP;
gEoUa: $this->db->join("master_siswa b", "a.id_siswa=b.id_siswa", "left");
goto FYHZo;
e3cGi: $this->db->select("a.id_siswa, a.id_kelas," . " b.nama, b.nis, b.username," . " c.nama_kelas, c.kode_kelas," . " e.sesi_id, e.ruang_id," . " rk.id_ruang, rk.kode_ruang," . " sk.id_sesi, sk.kode_sesi");
goto zOtbF;
zOtbF: $this->db->from("kelas_siswa a");
goto gEoUa;
ol0AY: $this->db->join("cbt_sesi_siswa e", "a.id_siswa=e.siswa_id", "left");
goto JI8su;
QAeOh: }
public function getSiswaByKelas($id_tp, $id_smt, $id_kelas) { goto hKOhP;
tmQP1: Iqlvs: goto XmnUh;
qmQWn: $this->db->order_by("b.nama", "ASC");
goto X3LRF;
UXt8h: $this->db->where("c.siswa_id is NOT NULL", NULL, FALSE);
goto Crbjo;
Tp6ro: $this->db->where("g.id_siswa is NOT NULL", NULL, FALSE);
goto ipOfs;
UWzmO: $this->db->where("a.id_smt", $id_smt);
goto pDGjK;
lUKV6: $this->db->join("cbt_ruang d", "d.id_ruang=c.ruang_id", "left");
goto I8AsZ;
I8AsZ: $this->db->join("cbt_sesi e", "e.id_sesi=c.sesi_id", "left");
goto qANTE;
qANTE: $this->db->join("master_kelas f", "f.id_kelas=a.id_kelas", "left");
goto BYIHX;
BYIHX: $this->db->join("cbt_nomor_peserta g", "g.id_siswa=a.id_siswa AND g.id_tp=" . $id_tp, "left");
goto d5q62;
hKOhP: $this->db->select("b.id_siswa, b.nama, b.nis, b.nisn, b.username, b.password," . " b.foto, d.kode_ruang, e.kode_sesi, f.nama_kelas, f.kode_kelas, g.nomor_peserta");
goto dlHq7;
pAs3K: goto jRPIc;
goto tmQP1;
oTzD5: $this->db->where("a.id_tp", $id_tp);
goto UWzmO;
QzoRs: $this->db->where("b.id_siswa is NOT NULL", NULL, FALSE);
goto UXt8h;
GLBP4: $this->db->join("master_siswa b", "b.id_siswa=a.id_siswa", "left");
goto lnx7F;
Crbjo: $this->db->where("f.siswa_id is NOT NULL", NULL, FALSE);
goto Tp6ro;
lnx7F: $this->db->join("cbt_sesi_siswa c", "c.siswa_id=a.id_siswa", "left");
goto lUKV6;
X3LRF: return $this->db->get()->result();
goto R624z;
dlHq7: $this->db->from("kelas_siswa a");
goto GLBP4;
pDGjK: $this->db->where("a.id_siswa is NOT NULL", NULL, FALSE);
goto QzoRs;
d5q62: $this->db->join("buku_induk i", "i.id_siswa=a.id_siswa AND =i.status=1");
goto oTzD5;
epyWh: $this->db->where("a.id_kelas", $id_kelas);
goto pAs3K;
XmnUh: $this->db->where_in("a.id_kelas", $id_kelas);
goto nCqKH;
ipOfs: if (is_array($id_kelas)) { goto Iqlvs;
} goto epyWh;
nCqKH: jRPIc: goto qmQWn;
R624z: }
public function getSiswaById($id_tp, $id_smt, $idSiswa) { goto KNGtk;
TlZL8: $this->db->join("cbt_sesi j", "j.id_sesi=h.id_sesi", "left");
goto QiavQ;
QiavQ: $this->db->where("a.id_tp", $id_tp);
goto TXzXn;
ixCqI: $this->db->join("cbt_sesi e", "e.id_sesi=c.sesi_id", "left");
goto nz0Xm;
hRt5J: $this->db->from("kelas_siswa a");
goto br4gr;
TXzXn: $this->db->where("a.id_smt", $id_smt);
goto fhNb1;
fhNb1: $this->db->where("a.id_siswa", $idSiswa);
goto mJkix;
RxxB0: $this->db->join("cbt_ruang i", "i.id_ruang=h.id_ruang", "left");
goto TlZL8;
peYU3: $this->db->join("cbt_kelas_ruang h", "h.id_kelas=a.id_kelas", "left");
goto RxxB0;
KNGtk: $this->db->select("b.id_siswa, b.nama, b.nis, b.nisn, b.username, b.password," . " b.foto, d.kode_ruang, e.kode_sesi, f.nama_kelas, f.kode_kelas, g.nomor_peserta," . " h.set_siswa, i.kode_ruang as ruang_kelas, j.kode_sesi as sesi_kelas");
goto hRt5J;
b6Z78: $this->db->join("cbt_nomor_peserta g", "g.id_siswa=a.id_siswa AND g.id_tp=" . $id_tp, "left");
goto peYU3;
lyMPC: $this->db->join("cbt_sesi_siswa c", "c.siswa_id=a.id_siswa", "left");
goto gsML9;
mJkix: return $this->db->get()->row();
goto Vpmyb;
br4gr: $this->db->join("master_siswa b", "b.id_siswa=a.id_siswa", "left");
goto lyMPC;
gsML9: $this->db->join("cbt_ruang d", "d.id_ruang=c.ruang_id", "left");
goto ixCqI;
nz0Xm: $this->db->join("master_kelas f", "f.id_kelas=a.id_kelas", "left");
goto b6Z78;
Vpmyb: }
public function getAllPesertaByRuang($id_tp, $id_smt) { goto nw1Hl;
o18j_: $this->db->join("buku_induk i", "i.id_siswa=b.id_siswa AND =i.status=1");
goto meKfD;
uSWNc: $this->db->join("cbt_nomor_peserta g", "g.id_siswa=a.siswa_id AND g.id_tp=" . $id_tp, "left");
goto laB1Q;
QTl1g: $this->db->join("master_kelas f", "f.id_kelas=c.id_kelas");
goto o18j_;
JPpyj: return $ret;
goto F2_sU;
HSh5T: $this->db->from("cbt_sesi_siswa a");
goto qh6Mg;
JtdWJ: $this->db->order_by("e.kode_sesi");
goto mFXkm;
forik: $this->db->join("kelas_siswa c", "c.id_siswa=b.id_siswa AND c.id_tp=" . $id_tp . " AND c.id_smt=" . $id_smt . '');
goto QTl1g;
D8Be4: foreach ($result as $row) { $ret[$row->kode_ruang][$row->kode_sesi][] = $row;
vqck7: } goto i1WF2;
lR2DX: $this->db->join("cbt_ruang d", "d.id_ruang=a.ruang_id", "left");
goto uSWNc;
toji7: $this->db->order_by("f.kode_kelas");
goto Rlk3O;
L_nT5: $ret = [];
goto D8Be4;
i1WF2: BrKlP: goto JPpyj;
XPxRX: $result = $this->db->get()->result();
goto L_nT5;
meKfD: $this->db->order_by("d.kode_ruang");
goto JtdWJ;
Rlk3O: $this->db->order_by("b.nama");
goto XPxRX;
mFXkm: $this->db->order_by("f.level_id");
goto toji7;
qh6Mg: $this->db->join("master_siswa b", "b.id_siswa=a.siswa_id", "left");
goto lR2DX;
laB1Q: $this->db->join("cbt_sesi e", "e.id_sesi=a.sesi_id", "left");
goto forik;
nw1Hl: $this->db->select("b.id_siswa, b.nama, b.nis, b.nisn, b.username, b.password, b.foto, f.level_id," . " f.nama_kelas, f.kode_kelas," . " d.nama_ruang, d.kode_ruang," . " e.kode_sesi, e.nama_sesi," . " g.nomor_peserta");
goto HSh5T;
F2_sU: }
public function getAllPesertaByKelas($id_tp, $id_smt) { goto bJfQi;
uNDjR: $this->db->join("cbt_ruang d", "d.id_ruang=a.ruang_id", "left");
goto uHFbB;
c5L0g: $this->db->join("master_siswa b", "b.id_siswa=a.siswa_id", "left");
goto uNDjR;
nlgR9: $this->db->join("buku_induk i", "i.id_siswa=b.id_siswa AND =i.status=1");
goto NuljV;
UDVnw: $this->db->join("kelas_siswa c", "c.id_siswa=b.id_siswa AND c.id_tp=" . $id_tp . " AND c.id_smt=" . $id_smt . '');
goto Z7F1G;
bJfQi: $this->db->select("b.id_siswa, b.nama, b.nis, b.nisn, b.username, b.password, b.foto," . " f.nama_kelas, f.kode_kelas," . " d.nama_ruang, d.kode_ruang," . " e.kode_sesi, e.nama_sesi," . " g.nomor_peserta");
goto ABwOn;
UZRkC: $this->db->join("cbt_sesi e", "e.id_sesi=a.sesi_id", "left");
goto UDVnw;
DA9sr: $this->db->order_by("b.nama");
goto J2vcL;
xJYZx: return $ret;
goto E5Xki;
koB_W: p14xN: goto xJYZx;
ABwOn: $this->db->from("cbt_sesi_siswa a");
goto c5L0g;
J2vcL: $result = $this->db->get()->result();
goto sZ0A0;
Z7F1G: $this->db->join("master_kelas f", "f.id_kelas=c.id_kelas");
goto nlgR9;
h_0Jw: $this->db->order_by("f.kode_kelas");
goto DA9sr;
sZ0A0: $ret = [];
goto d9k_m;
d9k_m: foreach ($result as $row) { $ret[$row->kode_kelas][] = $row;
CvFJf: } goto koB_W;
NuljV: $this->db->order_by("f.level_id");
goto h_0Jw;
uHFbB: $this->db->join("cbt_nomor_peserta g", "g.id_siswa=a.siswa_id AND g.id_tp=" . $id_tp, "left");
goto UZRkC;
E5Xki: }
public function getSiswaByRuang($id_tp, $id_smt, $id_ruang, $sesi) { goto xKzzL;
pXDFz: $this->db->order_by("b.nama");
goto Ezoqi;
dNloh: $this->db->join("master_siswa b", "b.id_siswa=a.siswa_id", "left");
goto Tg4yK;
CbKfm: $this->db->where("a.sesi_id", $sesi);
goto pXDFz;
lI5Yx: $this->db->join("kelas_siswa c", "c.id_siswa=b.id_siswa AND c.id_tp=" . $id_tp . " AND c.id_smt=" . $id_smt . '');
goto GTKa2;
l81yl: $this->db->join("cbt_sesi e", "e.id_sesi=a.sesi_id", "left");
goto lI5Yx;
xKzzL: $this->db->select("a.ruang_id, a.sesi_id, b.id_siswa, b.nama, b.nis, b.nisn, b.username, b.password, b.foto," . " f.id_kelas, f.nama_kelas, f.kode_kelas," . " d.nama_ruang, d.kode_ruang," . " e.kode_sesi, e.nama_sesi," . " g.nomor_peserta");
goto kdybN;
Ezoqi: return $this->db->get()->result();
goto MBE3N;
gwRoj: $this->db->join("cbt_nomor_peserta g", "g.id_siswa=a.siswa_id AND g.id_tp=" . $id_tp, "left");
goto l81yl;
Tg4yK: $this->db->join("cbt_ruang d", "d.id_ruang=a.ruang_id", "left");
goto gwRoj;
j4B7S: $this->db->join("buku_induk i", "i.id_siswa=b.id_siswa AND =i.status=1");
goto hIVgq;
kdybN: $this->db->from("cbt_sesi_siswa a");
goto dNloh;
hIVgq: $this->db->where("a.ruang_id", $id_ruang);
goto CbKfm;
GTKa2: $this->db->join("master_kelas f", "f.id_kelas=c.id_kelas");
goto j4B7S;
MBE3N: }
public function getRuangSiswaByKelas($id_tp, $id_smt, $kelas, $sesi) { goto OafJm;
flZpl: $this->db->join("cbt_nomor_peserta g", "g.id_siswa=a.siswa_id AND g.id_tp=" . $id_tp, "left");
goto j9_IW;
RJ6bz: $this->db->from("cbt_sesi_siswa a");
goto h0Sn1;
d4mi_: $this->db->join("kelas_siswa c", "c.id_siswa=b.id_siswa AND c.id_tp=" . $id_tp . " AND c.id_smt=" . $id_smt . '');
goto eG3X7;
j9_IW: $this->db->join("cbt_sesi e", "e.id_sesi=a.sesi_id", "left");
goto d4mi_;
o3qRi: kXt6x: goto KfxzS;
h20TL: return $this->db->get()->result();
goto emQM4;
b7Xq0: $this->db->where_in("a.kelas_id", $kelas);
goto bqj1O;
OafJm: $this->db->select("b.id_siswa, b.nama, b.nis, b.nisn, b.username, b.password, b.foto," . " f.nama_kelas, f.kode_kelas," . " d.nama_ruang, d.kode_ruang," . " e.kode_sesi, e.nama_sesi," . " g.nomor_peserta");
goto RJ6bz;
WrZ3K: $this->db->where("a.sesi_id", $sesi);
goto o3qRi;
eG3X7: $this->db->join("master_kelas f", "f.id_kelas=c.id_kelas");
goto N7jaZ;
KfxzS: $this->db->order_by("b.nama");
goto h20TL;
UFo6e: $this->db->join("cbt_ruang d", "d.id_ruang=a.ruang_id", "left");
goto flZpl;
bqj1O: if (!($sesi != null)) { goto kXt6x;
} goto WrZ3K;
h0Sn1: $this->db->join("master_siswa b", "b.id_siswa=a.siswa_id", "left");
goto UFo6e;
N7jaZ: $this->db->join("buku_induk i", "i.id_siswa=b.id_siswa AND =i.status=1");
goto b7Xq0;
emQM4: }
public function getSiswaByKelasArray($id_tp, $id_smt, $arr_kelas) { goto iycdm;
r3eME: $this->db->join("master_kelas f", "f.id_kelas=a.id_kelas");
goto I_kbx;
XsnZv: $this->db->order_by("l.level", "ASC");
goto d838W;
N5hwO: xamTo: goto ORKGx;
I_kbx: $this->db->join("level_kelas l", "l.id_level=f.level_id");
goto KoDQ1;
ql0S7: $this->db->from("kelas_siswa a");
goto fX4_z;
QAnK_: $this->db->join("buku_induk i", "i.id_siswa=a.id_siswa AND =i.status=1");
goto Ru3bw;
y9h3H: $this->db->where("a.id_smt", $id_smt);
goto XsnZv;
S29rJ: return $this->db->get()->result();
goto hzWmx;
KoDQ1: $this->db->join("cbt_nomor_peserta g", "g.id_siswa=a.id_siswa AND g.id_tp=" . $id_tp, "left");
goto QAnK_;
fX4_z: $this->db->join("master_siswa b", "b.id_siswa=a.id_siswa");
goto r3eME;
ZBRGW: $this->db->where_in("a.id_kelas", $arr_kelas);
goto N5hwO;
d838W: $this->db->order_by("f.kode_kelas", "ASC");
goto HX2O7;
Ru3bw: if (in_array("Semua", $arr_kelas)) { goto xamTo;
} goto ZBRGW;
ORKGx: $this->db->where("a.id_tp", $id_tp);
goto y9h3H;
iycdm: $this->db->select("a.id_siswa," . " b.nama, b.nis, b.nisn, b.username, b.password," . " f.nama_kelas, f.kode_kelas, l.level, g.nomor_peserta");
goto ql0S7;
HX2O7: $this->db->order_by("b.nama", "ASC");
goto S29rJ;
hzWmx: }
public function getKelasList($tp, $smt) { goto ijAg2;
f6fsG: $this->db->join("master_jurusan c", "c.id_jurusan=a.jurusan_id", "left");
goto d0bZd;
EpFJS: $this->db->where("a.id_smt", $smt);
goto Oxj91;
NlTPt: $this->db->order_by("a.nama_kelas", "ASC");
goto EY75n;
st0of: $this->db->from("master_kelas a");
goto oDIpG;
EY75n: $query = $this->db->get();
goto kSC1O;
kSC1O: return $query->result();
goto B88yo;
ijAg2: $this->db->select("a.id_kelas, a.nama_kelas, a.kode_kelas, c.nama_jurusan, b.id_ruang, b.id_sesi, b.set_siswa");
goto st0of;
d0bZd: $this->db->join("level_kelas d", "d.id_level=a.level_id", "left");
goto WziPI;
WziPI: $this->db->where("a.id_tp", $tp);
goto EpFJS;
oDIpG: $this->db->join("cbt_kelas_ruang b", "a.id_kelas=b.id_kelas", "left");
goto f6fsG;
Oxj91: $this->db->order_by("a.level_id", "ASC");
goto NlTPt;
B88yo: }
public function getKelas($tp = null, $smt = null) { goto Bew5N;
Bew5N: $this->db->select("a.id_kelas, a.nama_kelas, a.kode_kelas, b.level");
goto qxAm5;
Ta5t6: $this->db->order_by("a.nama_kelas", "ASC");
goto MEoOl;
JT6wL: $this->db->where("a.id_tp", $tp);
goto MpMIh;
XvxZz: $this->db->join("level_kelas b", "b.id_level=a.level_id", "left");
goto sPWY1;
O_Eal: u0Csk: goto Ta5t6;
sPWY1: if (!($tp != null)) { goto k3lka;
} goto JT6wL;
Sw3c2: if (!($smt != null)) { goto u0Csk;
} goto zoL_X;
zoL_X: $this->db->where("a.id_smt", $smt);
goto O_Eal;
MEoOl: return $this->db->get()->result();
goto eOgLO;
MpMIh: k3lka: goto Sw3c2;
qxAm5: $this->db->from("master_kelas a");
goto XvxZz;
eOgLO: }
public function getDataTableBank($guru = null) { goto oD01t;
ta560: $this->datatables->join("master_jurusan d", "d.id_jurusan=a.bank_jurusan_id", "left");
goto OmSKR;
IDY1A: $this->datatables->from("cbt_bank_soal a");
goto rEMXA;
Wm18c: $this->datatables->join("master_guru c", "c.id_guru=a.bank_guru_id", "left");
goto ta560;
OmSKR: $this->datatables->join("cbt_jenis e", "e.id_jenis=a.bank_jenis_id", "left");
goto kafl_;
rEMXA: $this->datatables->join("master_mapel b", "b.id_mapel=a.bank_mapel_id", "left");
goto Wm18c;
oD01t: $this->datatables->select("a.id_bank, a.bank_kode, a.bank_level, a.tampil_pg, a.tampil_esai, a.status, b.nama_mapel, c.nama_guru");
goto IDY1A;
ePjlE: return $this->datatables->generate();
goto nOVCB;
kafl_: if (!($guru !== null)) { goto tRFo8;
} goto HJ0cC;
MdOCj: tRFo8: goto ePjlE;
HJ0cC: $this->datatables->where("a.bank_guru_id", $guru);
goto MdOCj;
nOVCB: }
public function getDataBank($guru = null, $mapel = null, $level = null) { goto CFVUx;
XEAE0: wyD65: goto ilU4X;
gkauX: $this->db->join("master_mapel b", "b.id_mapel=a.bank_mapel_id", "left");
goto nHgZ2;
ysqjo: if (!($mapel !== null)) { goto ReQkz;
} goto cqEk1;
NA32d: $this->db->where("a.bank_level", $level);
goto S22wu;
UtDp0: $result = $this->db->get()->result();
goto EHSZQ;
PL2jK: mUaw5: goto ysqjo;
wKPvo: $this->db->from("cbt_bank_soal a");
goto gkauX;
dYm1t: if (!($level !== null)) { goto Yw79N;
} goto NA32d;
ilU4X: return $ret;
goto YzhxQ;
CFVUx: $this->db->select("a.id_bank, a.id_tp, a.id_smt, a.bank_kode, a.bank_level, a.bank_kelas," . " a.tampil_pg, a.tampil_kompleks, a.tampil_jodohkan, a.tampil_isian, a.tampil_esai, a.bank_guru_id," . " b.nama_mapel, c.id_guru," . " (SELECT COUNT(id_soal) FROM cbt_soal WHERE cbt_soal.bank_id = a.id_bank) AS total_soal," . " (SELECT COUNT(id_jadwal) FROM cbt_jadwal WHERE cbt_jadwal.id_bank = a.id_bank AND cbt_jadwal.status="1") AS digunakan");
goto wKPvo;
G4Qmz: ReQkz: goto dYm1t;
Gdur7: if (!($guru !== null)) { goto mUaw5;
} goto fxEkw;
EHSZQ: $ret = [];
goto o9Nyd;
JSc8C: $this->db->order_by("a.bank_level", "ASC");
goto UtDp0;
o9Nyd: foreach ($result as $row) { $ret[$row->id_tp][$row->id_smt][] = $row;
ueRQx: } goto XEAE0;
nHgZ2: $this->db->join("master_guru c", "c.id_guru=a.bank_guru_id", "left");
goto Gdur7;
S22wu: Yw79N: goto JSc8C;
cqEk1: $this->db->where("a.bank_mapel_id", $mapel);
goto G4Qmz;
fxEkw: $this->db->where("a.bank_guru_id", $guru);
goto PL2jK;
YzhxQ: }
public function getDataBankById($id) { goto Mhwrl;
h5Fjc: $this->db->where("a.id_bank", $id);
goto jATBc;
jATBc: return $this->db->get()->row();
goto CGCx5;
xG8hR: $this->db->join("master_guru c", "c.id_guru=a.bank_guru_id", "left");
goto lONzf;
lONzf: $this->db->join("master_jurusan d", "d.id_jurusan=a.bank_jurusan_id", "left");
goto h5Fjc;
zQ8FR: $this->db->from("cbt_bank_soal a");
goto eAxEa;
Mhwrl: $this->db->select("a.*, b.nama_mapel, b.kode, c.nama_guru, d.nama_jurusan, d.kode_jurusan," . " (SELECT COUNT(id_jadwal) FROM cbt_jadwal WHERE cbt_jadwal.id_bank = a.id_bank AND cbt_jadwal.status="1") AS digunakan");
goto zQ8FR;
eAxEa: $this->db->join("master_mapel b", "b.id_mapel=a.bank_mapel_id", "left");
goto xG8hR;
CGCx5: }
public function getTotalSoal($id_bank, $jenis = null) { goto HEEKo;
Gs68q: return $this->db->get("cbt_soal")->num_rows();
goto duYqb;
HEEKo: $this->db->where("bank_id", $id_bank);
goto TeT7E;
jXrzN: $this->db->where("jenis", $jenis);
goto SHMhI;
TeT7E: if (!($jenis != null)) { goto oPuY6;
} goto jXrzN;
SHMhI: oPuY6: goto Gs68q;
duYqb: }
public function getNomorSoalById($id_soal) { goto kCEVx;
DjXPW: $this->db->where("id_soal", $id_soal);
goto iCXnk;
iCXnk: return $this->db->get("cbt_soal")->row();
goto kgHwX;
kCEVx: $this->db->select("nomor_soal, jenis, bank_id");
goto DjXPW;
kgHwX: }
public function getFileSoalById($id_soal) { goto qE8Ct;
CA02X: return $this->db->get("cbt_soal")->row();
goto IxVeW;
RVAC3: $this->db->where("id_soal", $id_soal);
goto CA02X;
qE8Ct: $this->db->select("file");
goto RVAC3;
IxVeW: }
public function getSoalByBank($id_bank) { goto tDIKt;
MOHHj: $this->db->order_by("nomor_soal");
goto pDrqt;
mK2Mv: $ret = [];
goto zZX_1;
h8Xvz: firKf: goto BvwEd;
m4rwu: $this->db->from("cbt_soal");
goto hQZU4;
zZX_1: foreach ($result as $row) { $ret[$row->jenis][$row->nomor_soal] = $row;
PPIuI: } goto h8Xvz;
WrNDr: $this->db->order_by("jenis");
goto MOHHj;
tDIKt: $this->db->select("id_soal, bank_id, mapel_id, jenis, nomor_soal, soal, opsi_a, opsi_b, opsi_c, opsi_d, opsi_e, jawaban");
goto m4rwu;
BvwEd: return $ret;
goto xAAp3;
pDrqt: $result = $this->db->get()->result();
goto mK2Mv;
hQZU4: $this->db->where("bank_id", $id_bank);
goto WrNDr;
xAAp3: }
public function getAllSoalByBank($id_bank, $jenis = null) { goto AUuSL;
M679H: return $this->db->get("cbt_soal")->result();
goto M196V;
bfGRj: $this->db->where("jenis", $jenis);
goto P5J5Y;
P5J5Y: Xh1RV: goto M679H;
AUuSL: $this->db->select("id_soal, bank_id, mapel_id, jenis, nomor_soal, soal, opsi_a, opsi_b, opsi_c, opsi_d, opsi_e, jawaban, tampilkan");
goto CPD5A;
Y0mAs: if (!($jenis != null)) { goto Xh1RV;
} goto bfGRj;
CPD5A: $this->db->where("bank_id", $id_bank);
goto Y0mAs;
M196V: }
public function getSoalByNomor($id_bank, $nomor, $jenis) { goto v4xAC;
qx856: $this->db->where("nomor_soal", $nomor);
goto pd1CR;
sz0NU: return $this->db->get("cbt_soal")->row();
goto oV49t;
pd1CR: $this->db->where("jenis", $jenis);
goto sz0NU;
CLxyr: $this->db->where("bank_id", $id_bank);
goto qx856;
v4xAC: $this->db->select("*");
goto CLxyr;
oV49t: }
public function getNomorSoalByBankJenis($id_bank, $jenis) { goto TFW4d;
jb3Fo: Q_wmx: goto Xibng;
ExiMH: foreach ($result as $key => $row) { $ret[$row->nomor_soal] = $row;
wq55G: } goto jb3Fo;
fJM1m: $this->db->where("jenis", $jenis);
goto QDWFK;
nZLS0: $ret = [];
goto ExiMH;
Xibng: return $ret;
goto b6xjV;
TFW4d: $this->db->select("id_soal, jenis, nomor_soal");
goto jQl05;
QDWFK: $result = $this->db->get("cbt_soal")->result();
goto nZLS0;
jQl05: $this->db->where("bank_id", $id_bank);
goto fJM1m;
b6xjV: }
public function getNomorSoalByBank($id_bank, $jenis = null) { goto ugUmv;
mn_6g: foreach ($result as $key => $row) { $ret[$row->id_soal] = $row;
nqc2h: } goto QNkIU;
W8ERD: $this->db->where("tampilkan", "1");
goto ecc7t;
vjopV: $result = $this->db->get("cbt_soal")->result();
goto AD3cs;
ecc7t: if (!($jenis != null)) { goto SVwLr;
} goto DUgkt;
evxJj: SVwLr: goto vjopV;
ugUmv: $this->db->select("id_soal, jenis, nomor_soal, jawaban");
goto qJySk;
VN6k9: return $ret;
goto Sf1Vh;
AD3cs: $ret = [];
goto mn_6g;
DUgkt: $this->db->where("jenis", $jenis);
goto evxJj;
QNkIU: yPhd3: goto VN6k9;
qJySk: $this->db->where("bank_id", $id_bank);
goto W8ERD;
Sf1Vh: }
public function getNomorSoalByArrIdBank($arr_id_bank, $jenis = null) { goto OeKdG;
lm5_R: $this->db->where("jenis", $jenis);
goto pyr4Y;
K1_iS: if (!($jenis != null)) { goto aLca_;
} goto lm5_R;
OeKdG: $this->db->select("id_soal, jenis, nomor_soal, jawaban");
goto MkOB1;
BY8gM: return $this->db->get("cbt_soal")->result();
goto ZPGZ4;
MkOB1: $this->db->where_in("bank_id", $arr_id_bank);
goto K1_iS;
pyr4Y: aLca_: goto BY8gM;
ZPGZ4: }
public function cekSoalAda($id_bank, $jenis) { goto kxhcZ;
kxhcZ: $this->db->select("id_soal, bank_id, jenis, nomor_soal");
goto PoGRT;
PoGRT: $this->db->where("bank_id", $id_bank);
goto FNaiz;
FNaiz: $this->db->where("jenis", $jenis);
goto r2f02;
r2f02: return $this->db->get("cbt_soal")->result();
goto x5WWR;
x5WWR: }
public function cekSoalKomplit($id_bank, $jenjang) { goto q_Sm0;
ih5F6: $this->db->where("bank_id", $id_bank)->where("soal NOT NULL")->or_where("opsi_a NOT NULL")->or_where("opsi_b NOT NULL")->or_where("opsi_c NOT NULL")->or_where("opsi_d NOT NULL")->or_where("jawaban NOT NULL");
goto g6Gov;
q_Sm0: $this->db->select("id_soal, bank_id, jenis, nomor_soal");
goto ih5F6;
Nx7KK: $this->db->or_where("opsi_e NOT NULL");
goto jhPcf;
qvBy2: return $this->db->get("cbt_soal")->result();
goto VmLmb;
g6Gov: if (!($jenjang == "3")) { goto dnUgD;
} goto Nx7KK;
jhPcf: dnUgD: goto qvBy2;
VmLmb: }
public function cekSoalBelumKomplit($jenis, $opsi_ganda) { goto AcFbF;
ohp0B: $this->db->where("jenis", $jenis);
goto xqDBt;
XK6Vp: if (!($jenis == "1")) { goto trzX8;
} goto lKdV4;
wOxLH: $this->db->where("opsi_d IS NULL")->or_where("opsi_d =""");
goto dMoTx;
lKdV4: $this->db->where("opsi_a IS NULL")->or_where("opsi_a =""");
goto qJWpl;
xqDBt: $this->db->where("soal IS NULL")->or_where("soal =""");
goto XK6Vp;
Rscdz: XUaNM: goto kj6gI;
EHDQL: $result = $this->db->get()->result();
goto Nn1we;
prZix: $this->db->where("opsi_c IS NULL")->or_where("opsi_c =""");
goto WCspx;
SnR23: if (!($opsi_ganda == "5")) { goto vQpnu;
} goto cqxdh;
u8iup: $this->db->where("opsi_e IS NULL")->or_where("opsi_e =""");
goto rPVwu;
rPVwu: vQpnu: goto oRd8I;
wOgLR: $this->db->where("opsi_a IS NULL")->or_where("opsi_a =""");
goto Es3ng;
AcFbF: $this->db->select("id_soal, bank_id, jenis, nomor_soal, mapel_id");
goto vQcdT;
o66BA: if (!($jenis == "2")) { goto R5CeH;
} goto wOgLR;
Es3ng: R5CeH: goto nNWvn;
mREE0: $ret = [];
goto EHDQL;
dMoTx: yx8pJ: goto SnR23;
kj6gI: return $ret;
goto F3wWW;
nNWvn: $this->db->where("jawaban IS NULL")->or_where("jawaban =""");
goto mREE0;
Nn1we: foreach ($result as $key => $row) { $ret[$row->bank_id][] = $row;
UCMWI: } goto Rscdz;
cqxdh: $this->db->where("opsi_d IS NULL")->or_where("opsi_d =""");
goto u8iup;
oRd8I: trzX8: goto o66BA;
vQcdT: $this->db->from("cbt_soal");
goto ohp0B;
WCspx: if (!($opsi_ganda == "4")) { goto yx8pJ;
} goto wOxLH;
qJWpl: $this->db->where("opsi_b IS NULL")->or_where("opsi_b =""");
goto prZix;
F3wWW: }
public function getNomorSoalTerbesar($id_bank, $jenis) { goto TcgLA;
Ve1Va: return $this->db->get("cbt_soal")->row();
goto WRrEA;
TcgLA: $this->db->select("nomor_soal");
goto xzlC7;
xzlC7: $this->db->where("bank_id", $id_bank)->where("jenis", $jenis);
goto P2XGT;
P2XGT: $this->db->order_by("nomor_soal", "DESC");
goto Ve1Va;
WRrEA: }
public function dummy($jenjang) { $data = array("id_bank" => '', "bank_jenis_id" => '', "bank_kode" => '', "bank_mapel_id" => '', "bank_level" => '', "bank_kelas" => serialize([]), "bank_guru_id" => '', "jml_soal" => "0", "bobot_pg" => "0", "tampil_pg" => "0", "opsi" => $jenjang == "1" ? "3" : ($jenjang == "2" ? "4" : ($jenjang == "3" ? "5" : '')), "jml_kompleks" => "0", "tampil_kompleks" => "0", "bobot_kompleks" => "0", "jml_jodohkan" => "0", "tampil_jodohkan" => "0", "bobot_jodohkan" => "0", "jml_isian" => "0", "tampil_isian" => "0", "bobot_isian" => "0", "jml_esai" => "0", "bobot_esai" => "0", "tampil_esai" => "0", "kkm" => '', "soal_agama" => "-", "status" => "1");
return $data;
}
public function saveBankSoal($tp, $smt) { goto u6We7;
a8Ho5: $this->db->insert("cbt_bank_soal", $data);
goto LU0Fn;
b1r6S: if (!$id) { goto KZdQO;
} goto s6Qyg;
Hz08H: fOhrI: goto omwa9;
Z4sdz: goto yqdOp;
goto rDUWl;
rPBNW: $kelas = [];
goto VzmWi;
MrwTr: yqdOp: goto AUBsB;
qgqOj: $rows = count($this->input->post("kelas", true));
goto rPBNW;
p0OS5: Fn6hN: goto kD6Au;
Lq2mn: $jumlah = serialize($kelas);
goto xL5QN;
xL5QN: $data = array("id_tp" => $tp, "id_smt" => $smt, "bank_kode" => strip_tags($this->input->post("kode", TRUE)), "bank_jenis_id" => strip_tags($this->input->post("jenis", TRUE)), "bank_mapel_id" => strip_tags($this->input->post("mapel", TRUE)), "bank_kelas" => $jumlah, "bank_level" => $this->input->post("level", TRUE), "bank_guru_id" => strip_tags($this->input->post("guru", TRUE)), "jml_soal" => strip_tags($this->input->post("tampil_pg", TRUE)), "tampil_pg" => strip_tags($this->input->post("tampil_pg", TRUE)), "bobot_pg" => strip_tags($this->input->post("bobot_pg", TRUE)), "opsi" => strip_tags($this->input->post("opsi", TRUE)), "jml_kompleks" => strip_tags($this->input->post("tampil_kompleks", TRUE)), "tampil_kompleks" => strip_tags($this->input->post("tampil_kompleks", TRUE)), "bobot_kompleks" => strip_tags($this->input->post("bobot_kompleks", TRUE)), "jml_jodohkan" => strip_tags($this->input->post("tampil_jodohkan", TRUE)), "tampil_jodohkan" => strip_tags($this->input->post("tampil_jodohkan", TRUE)), "bobot_jodohkan" => strip_tags($this->input->post("bobot_jodohkan", TRUE)), "jml_isian" => strip_tags($this->input->post("tampil_isian", TRUE)), "tampil_isian" => strip_tags($this->input->post("tampil_isian", TRUE)), "bobot_isian" => strip_tags($this->input->post("bobot_isian", TRUE)), "jml_esai" => strip_tags($this->input->post("bobot_esai", TRUE)), "bobot_esai" => strip_tags($this->input->post("bobot_esai", TRUE)), "tampil_esai" => strip_tags($this->input->post("tampil_esai", TRUE)), "status" => strip_tags($this->input->post("status", TRUE)), "soal_agama" => strip_tags($this->input->post("soal_agama", TRUE)));
goto b1r6S;
LU0Fn: $insert_id = $this->db->insert_id();
goto dMcGt;
OxoqK: l8GC4: goto Lq2mn;
UCRrr: return $this->db->update("cbt_bank_soal", $data);
goto Z4sdz;
rDUWl: KZdQO: goto a8Ho5;
Ieyv6: $kelas[] = ["kelas_id" => $this->input->post("kelas[" . $i . "]", true)];
goto p0OS5;
omwa9: if (!($i <= $rows)) { goto l8GC4;
} goto Ieyv6;
kD6Au: $i++;
goto MsNl4;
s6Qyg: $this->db->where("id_bank", $id);
goto UCRrr;
VzmWi: $i = 0;
goto Hz08H;
u6We7: $id = $this->input->post("id_bank", true);
goto qgqOj;
MsNl4: goto fOhrI;
goto OxoqK;
dMcGt: return $insert_id;
goto MrwTr;
AUBsB: }
public function dummyJadwal() { $data = array("id_bank" => '', "id_jadwal" => '', "id_jenis" => '', "tgl_mulai" => '', "tgl_selesai" => '', "durasi_ujian" => '', "bank_kelas" => serialize([]), "acak_soal" => '', "acak_opsi" => '', "hasil_tampil" => '', "token" => '', "status" => '', "ulang" => '', "jarak" => '', "reset_login" => '');
return $data;
}
public function getDistinctJenisJadwal($tp, $smt) { goto sueg4;
GOt_i: $result = $this->db->get()->result();
goto vvcBw;
BSfLm: $this->db->where("id_smt", $smt);
goto GOt_i;
sueg4: $this->db->select("id_jenis");
goto lf9br;
OPukt: $this->db->from("cbt_jadwal");
goto wDzwi;
wDzwi: $this->db->where("id_tp", $tp);
goto BSfLm;
vvcBw: return $result;
goto c7Vfw;
lf9br: $this->db->distinct();
goto OPukt;
c7Vfw: }
public function getDataJadwal($tp, $smt, $guru = null, $rekap = null) { goto UNi5f;
e6V_p: $this->db->where("a.rekap", $rekap);
goto Ff4sS;
N4liL: if (!($rekap !== null)) { goto KNGjW;
} goto e6V_p;
ZjKW1: PesMd: goto N4liL;
hajMO: $this->db->join("master_tp e", "a.id_tp=e.id_tp");
goto PgkkP;
PTd9k: if (!($guru !== null)) { goto PesMd;
} goto xdo7_;
nXHoK: $query = $this->db->get()->result();
goto kEKVi;
tHABe: $this->db->order_by("b.bank_level", "ASC");
goto nXHoK;
w8QcC: $this->db->join("level_kelas g", "b.bank_level=g.id_level");
goto PTd9k;
glNHj: $this->db->join("cbt_jenis c", "c.id_jenis=a.id_jenis", "left");
goto vfjlb;
vfjlb: $this->db->join("master_mapel d", "d.id_mapel=b.bank_mapel_id", "left");
goto hajMO;
xdo7_: $this->db->where("b.bank_guru_id", $guru);
goto ZjKW1;
Ff4sS: KNGjW: goto AWBQI;
PgkkP: $this->db->join("master_smt f", "a.id_smt=f.id_smt");
goto w8QcC;
kEKVi: return $query;
goto sgbXc;
Dd3j7: $this->db->join("cbt_bank_soal b", "b.id_bank=a.id_bank", "left");
goto glNHj;
UNi5f: $this->db->select("a.id_jadwal, a.id_tp, a.id_smt, a.id_bank, a.id_jenis, a.tgl_mulai," . " a.tgl_selesai, a.status, a.ulang, a.reset_login, a.rekap, a.jam_ke," . " e.id_tp, e.tahun, f.id_smt, f.nama_smt, g.level, b.bank_kode, b.bank_level, b.bank_kelas," . " c.kode_jenis, d.kode, d.nama_mapel," . " b.tampil_pg, b.tampil_kompleks, b.tampil_jodohkan, b.tampil_isian, b.tampil_esai, b.bank_guru_id," . " (SELECT COUNT(id_soal) FROM cbt_soal WHERE cbt_soal.bank_id = a.id_bank) AS total_soal");
goto xaPet;
xaPet: $this->db->from("cbt_jadwal a");
goto Dd3j7;
AWBQI: $this->db->order_by("a.tgl_mulai", "DESC");
goto tHABe;
sgbXc: }
public function getAllDataJadwal($guru = null, $mapel = null, $level = null) {
goto x8JvT;
bEGOj: X1H2H: goto MKS4X;
WSnzF: if (!($mapel !== null)) { goto PJ6nW;
} goto Eif_v;
EYbuf: $this->db->join("master_smt f", "a.id_smt=f.id_smt");
goto g6r6r;
g6r6r: $this->db->join("level_kelas g", "b.bank_level=g.id_level");
goto dE1r3;
F3oEj: $this->db->where("b.bank_level", $level);
goto O6PHV;
CZZhN: if (!($level !== null)) {
goto elVHc;
} goto F3oEj;
KB1KR: $this->db->join("cbt_bank_soal b", "b.id_bank=a.id_bank");
goto X1S8l;
bVAHP: $this->db->where("b.bank_guru_id", $guru);
goto e5V_Q;
yXsh3: PJ6nW: goto CZZhN;
O6PHV: elVHc: goto DOW2K;
X1S8l: $this->db->join("cbt_jenis c", "c.id_jenis=a.id_jenis", "left");
goto YRfKU;
qKLdn: $ret = [];
goto INolh;
x8JvT: $this->db->select("a.id_jadwal, a.tgl_mulai, a.tgl_selesai, a.status, a.durasi_ujian, a.acak_soal," . " a.acak_opsi, a.id_bank, a.id_jenis, a.hasil_tampil, a.status, a.ulang, a.reset_login, a.rekap," . " a.jam_ke, a.token, e.tahun, f.nama_smt, g.level, b.bank_kode, b.bank_level, b.bank_kelas, c.kode_jenis, d.kode, d.nama_mapel," . " b.tampil_pg, b.tampil_kompleks, b.tampil_jodohkan, b.tampil_isian, b.tampil_esai, b.bank_guru_id," . " (SELECT COUNT(id_soal) FROM cbt_soal WHERE cbt_soal.bank_id = a.id_bank) AS total_soal");
goto WAZnm;
WAZnm: $this->db->from("cbt_jadwal a");
goto KB1KR;
Eif_v: $this->db->where("b.bank_mapel_id", $mapel);
goto yXsh3;
j70ZI: $this->db->join("master_tp e", "a.id_tp=e.id_tp");
goto EYbuf;
LvFe1: $this->db->order_by("a.id_smt", "DESC");
goto xcUIW;
lyULk: $this->db->order_by("a.id_tp", "DESC");
goto LvFe1;
e5V_Q: RahlK: goto WSnzF;
MKS4X: return $ret;
goto ADO7m;
INolh: foreach ($query as $key => $row) { $ret["<b>" . $row->kode_jenis . "</b> " . $row->tahun . " smt " . $row->nama_smt][$row->level][] = $row;
lKymA: } goto bEGOj;
DOW2K: $this->db->order_by("b.bank_level", "ASC");
goto lyULk;
dE1r3: if (!($guru !== null)) { goto RahlK;
} goto bVAHP;
YRfKU: $this->db->join("master_mapel d", "d.id_mapel=b.bank_mapel_id", "left");
goto j70ZI;
xcUIW: $query = $this->db->get()->result();
goto qKLdn;
ADO7m: }
public function getJadwalTerpakai($id_jadwal = null) { goto XHgy0;
Jgwcm: $result = $this->db->get()->result();
goto DGKd0;
i0RJw: $this->db->where("id_jadwal", $id_jadwal);
goto R1Orw;
DGKd0: $ret = [];
goto LXAU5;
ZChSp: if (!($id_jadwal != null)) { goto alZFH;
} goto i0RJw;
Vttwv: dqiaV: goto rZ94P;
R1Orw: alZFH: goto Jgwcm;
XHgy0: $this->db->from("cbt_soal_siswa");
goto ZChSp;
LXAU5: foreach ($result as $key => $row) { $ret[$row->id_jadwal][$row->id_siswa] = $row;
RUMMi: } goto Vttwv;
rZ94P: return $ret;
goto CKzdF;
CKzdF: }
public function getBankTerpakai($id_bank = null) { goto buUi4;
buUi4: $this->db->from("cbt_soal_siswa");
goto Gnf1O;
yjol3: foreach ($result as $key => $row) { $ret[$row->id_bank][$row->id_siswa] = $row;
kq1GL: } goto mVaH4;
MDzfP: t93Gl: goto tWMYi;
X13As: return $ret;
goto w0n1e;
tWMYi: $result = $this->db->get()->result();
goto zmAKI;
Gnf1O: if (!($id_bank != null)) { goto t93Gl;
} goto t9DEX;
zmAKI: $ret = [];
goto yjol3;
mVaH4: j78rk: goto X13As;
t9DEX: $this->db->where("id_bank", $id_bank);
goto MDzfP;
w0n1e: }
public function getRekapByJadwalKelas($jadwal, $guru = null) { goto oWeyb;
w1E76: $this->db->where("id_jadwal", $jadwal);
goto lctfb;
v9TKK: $this->db->where("id_guru", $guru);
goto Hs8ag;
oWeyb: $this->db->from("cbt_rekap");
goto w1E76;
hLI0J: $result = $this->db->get()->row();
goto oGgJq;
Hs8ag: vquOL: goto hLI0J;
lctfb: if (!($guru !== null)) { goto vquOL;
} goto v9TKK;
oGgJq: return $result;
goto MD2Pq;
MD2Pq: }
public function getRekapJadwal($guru = null) { goto lbVux;
lbVux: $this->db->select("*");
goto oXzlf;
aduJC: ed0OG: goto z5UGj;
g72vx: if (!($guru !== null)) { goto ed0OG;
} goto N0izk;
dZ9Ul: return $query->result();
goto ATq3F;
oXzlf: $this->db->from("cbt_rekap");
goto g72vx;
Vcf_j: $query = $this->db->get();
goto dZ9Ul;
N0izk: $this->db->where("id_guru", $guru);
goto aduJC;
z5UGj: $this->db->order_by("tgl_mulai", "DESC");
goto Vcf_j;
ATq3F: }
public function getAllRekapByJenis($tp, $smt, $jenis, $level, $mapel, $jadwal = null, $guru = null) { goto WG8NS;
mcSMj: $this->db->where("bank_level", $level);
goto jDyDI;
qzWkx: if (!($guru != null)) { goto Ve3Mk;
} goto H6HXS;
kUh6v: if (!($mapel != "0")) { goto dPZxO;
} goto Kvk2b;
Kvk2b: $this->db->where("id_mapel", $mapel);
goto bCCHg;
jDyDI: $this->db->order_by("id_mapel", "ASC");
goto bD2Xp;
qDCvX: $this->db->where("smt", $smt);
goto OQtUK;
VnPHH: if (!($jadwal != null)) { goto g1izn;
} goto i1FiH;
b3VuG: Ve3Mk: goto PPFnt;
AfLtS: g1izn: goto qzWkx;
PPFnt: $this->db->where("tp", $tp);
goto qDCvX;
CQtWq: return $result;
goto UMutu;
bCCHg: dPZxO: goto VnPHH;
bD2Xp: $result = $this->db->get()->result();
goto CQtWq;
WG8NS: $this->db->from("cbt_rekap");
goto kUh6v;
OQtUK: $this->db->where("kode_jenis", $jenis);
goto mcSMj;
H6HXS: $this->db->where("id_guru", $guru);
goto b3VuG;
i1FiH: $this->db->where("id_jadwal", $jadwal);
goto AfLtS;
UMutu: }
public function getAllNilaiRekapByJenis($tp, $smt, $jenis, $kelas, $mapel, $jadwal = null, $guru = null) { goto gUFB1;
w2s6h: $this->db->where("a.tp", $tp);
goto Yy1qc;
x7SEs: $this->db->where("a.kode_jenis", $jenis);
goto SBGM0;
BGM5M: $this->db->join("buku_induk i", "i.id_siswa=a.id_siswa AND =i.status=1");
goto W67_D;
X9Vsv: BCpgd: goto by9A2;
TXHuG: if (!($guru != null)) { goto BCpgd;
} goto aGQAl;
gUFB1: $this->db->select("a.*, b.nomor_peserta, c.nama");
goto as0aw;
zfOFh: return $result;
goto lNmTW;
aGQAl: $this->db->where("a.id_guru", $guru);
goto X9Vsv;
v3HE8: if (!($jadwal != null)) { goto xvc16;
} goto b38AW;
y1ZAs: $result = $this->db->get()->result();
goto zfOFh;
by9A2: $this->db->where("a.id_kelas", $kelas);
goto w2s6h;
Yy1qc: $this->db->where("a.smt", $smt);
goto x7SEs;
as0aw: $this->db->from("cbt_rekap_nilai a");
goto JxNBp;
RY5H7: QBZ0b: goto v3HE8;
S7IWY: $this->db->join("master_siswa c", "c.id_siswa=a.id_siswa", "left");
goto BGM5M;
SBGM0: $this->db->order_by("c.nama", "ASC");
goto y1ZAs;
zcIxs: $this->db->where("a.id_mapel", $mapel);
goto RY5H7;
JxNBp: $this->db->join("cbt_nomor_peserta b", "b.id_siswa=a.id_siswa AND b.id_tp=a.id_tp", "left");
goto S7IWY;
E5HSZ: xvc16: goto TXHuG;
b38AW: $this->db->where("a.id_jadwal", $jadwal);
goto E5HSZ;
W67_D: if (!($mapel != "0")) { goto QBZ0b;
} goto zcIxs;
lNmTW: }
public function getAllRekap($guru = null) { goto YiLzO;
j5wpl: foreach ($result as $key => $row) { $ret[$row->id_jadwal] = $row;
dNIgf: } goto gVLjt;
gVLjt: x0yOq: goto fHBoy;
fOnr3: $ret = [];
goto j5wpl;
AjZJ1: $this->db->where("id_guru", $guru);
goto LfpNF;
D1vwh: $this->db->from("cbt_rekap");
goto H6x19;
LfpNF: PC390: goto dCq2b;
YiLzO: $this->db->select("id_rekap, id_tp, tp, id_smt, smt, id_jadwal, id_jenis, kode_jenis, id_bank, bank_kelas, nama_kelas, bank_kode, bank_level, id_mapel, nama_mapel, kode, tgl_mulai, tgl_selesai, id_guru, nama_guru");
goto D1vwh;
fHBoy: return $ret;
goto rOYjM;
H6x19: if (!($guru != null)) { goto PC390;
} goto AjZJ1;
dCq2b: $result = $this->db->get()->result();
goto fOnr3;
rOYjM: }
public function getJadwalById($id_jadwal, $sesi = null) { goto RuBSA;
VfPIm: $this->db->join("cbt_bank_soal b", "b.id_bank=a.id_bank", "left");
goto PdxRL;
M69IK: if (!($sesi != null)) { goto Py467;
} goto E6Lq_;
edvR5: $this->db->join("master_mapel d", "d.id_mapel=b.bank_mapel_id", "left");
goto M69IK;
sfPlx: $this->db->join("master_guru f", "f.id_guru=b.bank_guru_id", "left");
goto hoO5E;
E6Lq_: $this->db->join("cbt_sesi e", "e.id_sesi=" . $sesi, "left");
goto iDk6Y;
iDk6Y: Py467: goto sfPlx;
PNTc3: return $query;
goto X9YzK;
hoO5E: $this->db->where("a.id_jadwal", $id_jadwal);
goto GAyHe;
PURLK: $this->db->from("cbt_jadwal a");
goto VfPIm;
RuBSA: $this->db->select("a.*, b.opsi, b.bank_kode, b.bank_level, b.bank_kelas," . " b.tampil_pg, b.tampil_kompleks, b.tampil_jodohkan, b.tampil_isian, b.tampil_esai," . " b.bobot_pg, b.bobot_kompleks, b.bobot_jodohkan, b.bobot_isian, b.bobot_esai," . " b.id_bank, b.bank_guru_id, c.kode_jenis, c.nama_jenis," . " d.id_mapel, d.kode, d.nama_mapel, f.id_guru, f.nama_guru");
goto PURLK;
PdxRL: $this->db->join("cbt_jenis c", "c.id_jenis=a.id_jenis", "left");
goto edvR5;
GAyHe: $query = $this->db->get()->row();
goto PNTc3;
X9YzK: }
public function getJadwalByIdBank($id_bank) { goto NDmIk;
qMxlC: $this->db->join("master_mapel d", "d.id_mapel=b.bank_mapel_id", "left");
goto sgwpl;
Yfqca: $this->db->where("a.id_bank", $id_bank);
goto e63gf;
sGRZ0: return $query;
goto y79Cq;
NDmIk: $this->db->select("a.*, b.opsi, b.bank_kode, b.bank_level, b.bank_kelas," . " b.tampil_pg, b.tampil_kompleks, b.tampil_jodohkan, b.tampil_isian, b.tampil_esai," . " b.bobot_pg, b.bobot_kompleks, b.bobot_jodohkan, b.bobot_isian, b.bobot_esai," . " b.id_bank, b.bank_guru_id, c.kode_jenis, c.nama_jenis," . " d.id_mapel, d.kode, d.nama_mapel, f.id_guru, f.nama_guru");
goto JISpM;
HM_43: $this->db->join("cbt_jenis c", "c.id_jenis=a.id_jenis", "left");
goto qMxlC;
sgwpl: $this->db->join("master_guru f", "f.id_guru=b.bank_guru_id", "left");
goto Yfqca;
JISpM: $this->db->from("cbt_jadwal a");
goto hPnWN;
hPnWN: $this->db->join("cbt_bank_soal b", "b.id_bank=a.id_bank", "left");
goto HM_43;
e63gf: $query = $this->db->get()->row();
goto sGRZ0;
y79Cq: }
public function getAllJadwal($tp, $smt, $id_guru = null) { goto QFmkV;
Nsm8k: return $this->db->get()->result();
goto wI7OE;
FJ6ef: $this->db->where("b.id_tp", $tp);
goto ZXENA;
NwZmK: $this->db->where("a.bank_guru_id", $id_guru);
goto efI51;
ZXENA: $this->db->where("b.id_smt", $smt);
goto Nsm8k;
I3OaJ: $this->db->join("cbt_jadwal b", "b.id_bank=a.id_bank");
goto nka63;
efI51: hD_WH: goto FJ6ef;
QFmkV: $this->db->select("a.bank_kode, a.bank_kelas, b.id_jadwal");
goto EgX41;
EgX41: $this->db->from("cbt_bank_soal a");
goto I3OaJ;
nka63: if (!($id_guru != null)) { goto hD_WH;
} goto NwZmK;
wI7OE: }
public function getJadwalByArrId($arr_id_jadwal, $sesi = null) { goto lRktK;
cfZYv: $this->db->where_in("a.id_jadwal", $arr_id_jadwal);
goto Bydza;
FhzH0: $this->db->join("cbt_jenis c", "c.id_jenis=a.id_jenis", "left");
goto oBjdP;
oBjdP: $this->db->join("master_mapel d", "d.id_mapel=b.bank_mapel_id", "left");
goto t83Jh;
qsRsc: $this->db->from("cbt_jadwal a");
goto TD2Q3;
lRktK: $this->db->select("a.*, b.opsi, b.bank_kode, b.bank_level, b.bank_kelas," . " b.tampil_pg, b.tampil_kompleks, b.tampil_jodohkan, b.tampil_isian, b.tampil_esai," . " b.bobot_pg, b.bobot_kompleks, b.bobot_jodohkan, b.bobot_isian, b.bobot_esai," . " b.id_bank, b.bank_guru_id, c.kode_jenis, c.nama_jenis," . " d.id_mapel, d.kode, d.nama_mapel, f.id_guru, f.nama_guru");
goto qsRsc;
up_1a: $this->db->join("cbt_sesi e", "e.id_sesi=" . $sesi, "left");
goto jDezZ;
Bydza: $query = $this->db->get()->result();
goto idXiD;
z9hMW: $this->db->join("master_guru f", "f.id_guru=b.bank_guru_id", "left");
goto cfZYv;
t83Jh: if (!($sesi != null)) { goto YVCbt;
} goto up_1a;
idXiD: return $query;
goto hteTv;
jDezZ: YVCbt: goto z9hMW;
TD2Q3: $this->db->join("cbt_bank_soal b", "b.id_bank=a.id_bank", "left");
goto FhzH0;
hteTv: }
public function cekJadwalBankSoal($id_bank) { goto Nlahl;
VSvfV: $query = $this->db->get()->num_rows();
goto mCN6f;
qTaTg: $this->db->from("cbt_jadwal");
goto p8B8Q;
QV6hl: goto AeIiU;
goto d5Kb5;
Nlahl: $this->db->select("id_bank");
goto qTaTg;
UWt68: $this->db->where("id_bank", $id_bank);
goto QV6hl;
d5Kb5: vNWqx: goto IAVnL;
mCN6f: return $query;
goto j7RAa;
IAVnL: $this->db->where_in("id_bank", $id_bank);
goto xkheJ;
xkheJ: AeIiU: goto VSvfV;
p8B8Q: if (is_array($id_bank)) { goto vNWqx;
} goto UWt68;
j7RAa: }
public function cekJadwalSudahMulai($id_jadwal) { $query = $this->get_where("cbt_durasi_siswa", "id_jadwal", $id_jadwal)->num_rows();
return $query;
}
public function saveJadwalUjian($id_tp, $id_smt) { goto gSVnS;
A48W3: $bank_id = strip_tags($this->input->post("bank_id", TRUE));
goto xCw0t;
Rv3pl: return $this->db->update("cbt_jadwal", $data);
goto cSeo_;
MIm1j: $status = $this->input->post("status", TRUE);
goto Id_5A;
D5Mag: goto X4p7v;
goto Zypj9;
s6JJZ: if ($id == '') { goto wqN9W;
} goto FW3hK;
dPdxq: return false;
goto ImLq0;
Ivoqh: $data = array("id_tp" => $id_tp, "id_smt" => $id_smt, "id_bank" => $bank_id, "id_jenis" => $jenis_id, "tgl_mulai" => $mulai, "tgl_selesai" => $selesai, "durasi_ujian" => $durasi, "jarak" => $jarak, "acak_soal" => !$acak_soal ? "0" : $acak_soal, "acak_opsi" => !$acak_opsi ? "0" : $acak_opsi, "hasil_tampil" => !$hasil_tampil ? "0" : $hasil_tampil, "token" => !$token ? "0" : $token, "status" => !$status ? "0" : $status, "reset_login" => !$reset_login ? "0" : $reset_login);
goto s6JJZ;
Id_5A: $reset_login = $this->input->post("reset_login", TRUE);
goto A48W3;
ImLq0: ppYF8: goto D5Mag;
Zypj9: wqN9W: goto goSZ2;
FW3hK: if ($check != null && $check->id_jadwal != $id) { goto Hoput;
} goto RAqn1;
Vr4lH: $jarak = strip_tags($this->input->post("jarak", TRUE));
goto Qmfxd;
cSeo_: goto ppYF8;
goto h5dDf;
uGGyO: X4p7v: goto Z9cSZ;
syRN_: return false;
goto XUfM0;
XUfM0: TY9Mh: goto uGGyO;
ah5BB: DwIwt: goto syRN_;
e2hsB: return $insert_id;
goto ktrNB;
lU7iZ: $token = $this->input->post("token", TRUE);
goto MIm1j;
ktrNB: goto TY9Mh;
goto ah5BB;
goSZ2: if ($check != null) { goto DwIwt;
} goto HTe9E;
X2Hsu: $durasi = strip_tags($this->input->post("durasi_ujian", TRUE));
goto Vr4lH;
NAurA: $insert_id = $this->db->insert_id();
goto e2hsB;
ixcWw: $acak_opsi = $this->input->post("acak_opsi", TRUE);
goto w6NU1;
FrinE: $selesai = strip_tags($this->input->post("tgl_selesai", TRUE));
goto X2Hsu;
gSVnS: $id = $this->input->post("id_jadwal", true);
goto D3BPr;
w6NU1: $hasil_tampil = $this->input->post("hasil_tampil", TRUE);
goto lU7iZ;
RAqn1: $this->db->where("id_jadwal", $id);
goto Rv3pl;
cKWRE: $mulai = strip_tags($this->input->post("tgl_mulai", TRUE));
goto FrinE;
xCw0t: $jenis_id = strip_tags($this->input->post("jenis_id", TRUE));
goto cKWRE;
Qmfxd: $check = $this->db->where("id_bank", $bank_id)->where("id_jenis", $jenis_id)->get("cbt_jadwal")->row();
goto Ivoqh;
h5dDf: Hoput: goto dPdxq;
D3BPr: $acak_soal = $this->input->post("acak_soal", TRUE);
goto ixcWw;
HTe9E: $this->db->insert("cbt_jadwal", $data);
goto NAurA;
Z9cSZ: }
public function getJadwalTgl($guru = null) { goto L3U_m;
IshHS: return $query->result();
goto wSP6N;
L3U_m: $this->db->distinct();
goto ZLTWa;
MaRe2: $query = $this->db->get();
goto IshHS;
ZLTWa: $this->db->select("tgl_mulai");
goto qil8_;
qil8_: $this->db->from("cbt_jadwal");
goto MaRe2;
wSP6N: }
public function getDataJadwalByTgl($tgl) { goto Zfvlx;
E_lUr: $query = $this->db->get();
goto TIrop;
Zfvlx: $this->db->distinct();
goto B51L7;
B51L7: $this->db->select("tgl_mulai, tgl_selesai");
goto BB3JZ;
tXiPf: $this->db->where("tgl_mulai <= '{$tgl}' AND tgl_selesai >= '{$tgl}'");
goto E_lUr;
BB3JZ: $this->db->from("cbt_jadwal");
goto tXiPf;
TIrop: return $query->result();
goto aHUzZ;
aHUzZ: }
public function getDataGuru() { goto yB7JR;
vVYSl: $query = $this->db->get()->result();
goto pLrEQ;
pLrEQ: return $query;
goto hHWu0;
yB7JR: $this->db->select("a.id_guru, a.nama_guru, b.id_pengawas, b.id_jadwal");
goto U8Wcz;
KBRnN: $this->db->join("cbt_pengawas b", "b.id_guru = a.id_guru", "left");
goto vVYSl;
U8Wcz: $this->db->from("master_guru a");
goto KBRnN;
hHWu0: }
public function saveToken($post_token) { goto Q8aJY;
p3O9K: goto Xw6Ls;
goto xWw3u;
Eg5I4: $this->db->where("id_token", $id);
goto aXaHQ;
lxG2j: $jarak = $post_token->jarak;
goto p6fyx;
p6fyx: $data = array("token" => $tkn, "auto" => $auto, "jarak" => $jarak, "updated" => $post_token->updated);
goto D5xce;
DQivR: Xw6Ls: goto rtx7q;
aXaHQ: return $this->db->update("cbt_token", $data);
goto p3O9K;
D5xce: if (!$id) { goto iYOet;
} goto Eg5I4;
xWw3u: iYOet: goto MeLns;
sqmzV: $auto = $post_token->auto;
goto lxG2j;
Q8aJY: $id = isset($post_token->id_token) ? $post_token->id_token : false;
goto ABICs;
MeLns: $this->db->insert("cbt_token", $data);
goto uKs4b;
uKs4b: $insert_id = $this->db->insert_id();
goto L9pl5;
ABICs: $tkn = $post_token->token;
goto sqmzV;
L9pl5: return $insert_id;
goto DQivR;
rtx7q: }
public function updateToken($token, $auto) { goto lJgwp;
kwSNf: return $result;
goto RJ1P6;
lJgwp: $this->db->set("auto", $auto, FALSE);
goto XZB_d;
XZB_d: $this->db->where("token", $token);
goto R3LFs;
R3LFs: $this->db->update("cbt_token");
goto MUKPb;
MUKPb: $result = $this->db->get("cbt_token")->row();
goto kwSNf;
RJ1P6: }
public function getToken() { $result = $this->db->get("cbt_token")->row();
return $result;
}
public function getJadwalCbtKelas($id_tp, $id_smt) { goto VFM1q;
XPBOE: $this->db->join("cbt_bank_soal b", "b.id_bank=a.id_bank");
goto Mf5gI;
ZzT4Q: $this->db->where("a.id_smt", $id_smt);
goto C6zHb;
VFM1q: $this->db->select("a.id_jadwal, b.bank_kelas");
goto QEHy3;
C6zHb: return $this->db->get()->result();
goto mgw_7;
QEHy3: $this->db->from("cbt_jadwal a");
goto XPBOE;
Mf5gI: $this->db->where("a.id_tp", $id_tp);
goto ZzT4Q;
mgw_7: }
public function getInfoJadwal($id_bank) { goto aYXKp;
aYXKp: $this->db->select("a.id_bank, b.acak_soal, b.acak_opsi, a.opsi," . " a.tampil_pg, a.tampil_kompleks, a.tampil_jodohkan, a.tampil_isian, a.tampil_esai," . " a.bobot_pg, a.bobot_kompleks, a.bobot_jodohkan, a.bobot_isian, a.bobot_esai");
goto esaLQ;
DsF_Z: return $this->db->get()->row();
goto zieNp;
esaLQ: $this->db->from("cbt_bank_soal a");
goto gDS5c;
gDS5c: $this->db->join("cbt_jadwal b", "a.id_bank=b.id_bank");
goto Q8IzT;
Q8IzT: $this->db->where("a.id_bank", $id_bank);
goto DsF_Z;
zieNp: }
public function getAllIdSoal($id_bank) { goto Glni3;
gN1G9: $ret = [];
goto tXN8E;
ywV7Q: $this->db->where("bank_id", $id_bank);
goto q__0K;
OUz7c: foreach ($result as $row) { $ret[$row->jenis][] = $row;
mH6Xp: } goto Q5enY;
Szt7W: $this->db->where("tampilkan", "1");
goto ywV7Q;
Mn0AL: $this->db->from("cbt_soal");
goto Szt7W;
PV73U: DZxS3: goto X9Hq3;
q__0K: $result = $this->db->get()->result();
goto gN1G9;
Glni3: $this->db->select("id_soal, jenis, jawaban");
goto Mn0AL;
X9Hq3: return $ret;
goto D3tZ4;
tXN8E: if (!$result) { goto DZxS3;
} goto OUz7c;
Q5enY: oZNkx: goto PV73U;
D3tZ4: }
public function getJadwalCbt($id_tp, $id_smt, $level) { goto pESGn;
j2Qim: $this->db->where("a.status", "1");
goto NS6oe;
lW65V: $this->db->where("a.id_tp", $id_tp);
goto j2Qim;
rEoRi: $result = $this->db->get()->result();
goto zJK6L;
pESGn: $this->db->select("a.id_jadwal, a.id_tp, a.id_smt, a.id_bank, a.id_jenis, a.tgl_mulai, a.tgl_selesai," . " a.durasi_ujian, a.pengawas, a.acak_soal, a.acak_opsi, a.hasil_tampil, a.token, a.status, a.ulang," . " a.reset_login, a.rekap, a.jam_ke, a.jarak," . " c.bank_kode, c.bank_level, c.bank_kelas, c.tampil_pg, c.tampil_kompleks, c.tampil_jodohkan," . " c.tampil_isian, c.tampil_esai, c.soal_agama, " . " c.bobot_pg, c.bobot_kompleks, c.bobot_jodohkan, c.bobot_isian, c.bobot_esai, b.kode_jenis," . " b.nama_jenis, d.kode, d.nama_mapel");
goto FRsFp;
FRsFp: $this->db->from("cbt_jadwal a");
goto ODwDm;
NS6oe: $this->db->where("a.id_smt", $id_smt);
goto mHoAJ;
yjIWd: foreach ($result as $row) { $retur[$row->id_jadwal] = $row;
C3IGL: } goto xFcxd;
wF7UC: $this->db->where("c.status_soal", "1");
goto n_EsM;
xFcxd: adrnB: goto t5zsV;
n_EsM: $this->db->where("c.bank_level", $level);
goto C3b_C;
Al9rb: $this->db->join("cbt_bank_soal c", "c.id_bank=a.id_bank");
goto uFMFB;
zJK6L: $retur = [];
goto yjIWd;
mHoAJ: $this->db->where("c.status", "1");
goto wF7UC;
ODwDm: $this->db->join("cbt_jenis b", "b.id_jenis=a.id_jenis");
goto Al9rb;
t5zsV: return $retur;
goto p0H6L;
uFMFB: $this->db->join("master_mapel d", "d.id_mapel=c.bank_mapel_id");
goto lW65V;
C3b_C: $this->db->order_by("a.jam_ke");
goto rEoRi;
p0H6L: }
public function getJadwalByKelas($id_tp, $id_smt, $kelas) { goto cdUta;
E_RYA: $this->db->where("a.id_tp", $id_tp);
goto eopGi;
eopGi: $this->db->where("a.status", "1");
goto tB3Ol;
cdUta: $this->db->select("a.id_jadwal, a.id_tp, a.id_smt, a.id_bank, a.id_jenis, a.tgl_mulai, a.tgl_selesai," . " a.durasi_ujian, a.pengawas, a.acak_soal, a.acak_opsi, a.hasil_tampil, a.token, a.status, a.ulang," . " a.reset_login, a.rekap, a.jam_ke, a.jarak," . " c.bank_kode, c.bank_level, c.bank_kelas, c.tampil_pg, c.tampil_kompleks, c.tampil_jodohkan," . " c.tampil_isian, c.tampil_esai, c.soal_agama, " . " c.bobot_pg, c.bobot_kompleks, c.bobot_jodohkan, c.bobot_isian, c.bobot_esai, b.kode_jenis," . " b.nama_jenis, d.kode, d.nama_mapel");
goto eEwEk;
JZHkG: $this->db->where("c.status", "1");
goto HOReX;
cGmL0: $this->db->like("c.bank_kelas", $kelas);
goto DgfKA;
QkcmC: $retur = [];
goto v1ddD;
dAerE: return $retur;
goto DKFSC;
v1ddD: foreach ($result as $row) { $retur[$row->id_jadwal] = $row;
duNxA: } goto fSMSs;
eEwEk: $this->db->from("cbt_jadwal a");
goto So12G;
Di8Fc: $this->db->join("cbt_bank_soal c", "c.id_bank=a.id_bank");
goto Bu_V0;
Bu_V0: $this->db->join("master_mapel d", "d.id_mapel=c.bank_mapel_id");
goto E_RYA;
DgfKA: $this->db->order_by("a.jam_ke");
goto OGOXX;
So12G: $this->db->join("cbt_jenis b", "b.id_jenis=a.id_jenis");
goto Di8Fc;
OGOXX: $result = $this->db->get()->result();
goto QkcmC;
tB3Ol: $this->db->where("a.id_smt", $id_smt);
goto JZHkG;
HOReX: $this->db->where("c.status_soal", "1");
goto cGmL0;
fSMSs: E5iAd: goto dAerE;
DKFSC: }
public function getCbt($id_jadwal) { goto mS8ve;
x4F2D: $this->db->join("master_guru e", "e.id_guru=c.bank_guru_id", "left");
goto BH3JF;
ZC5ie: $this->db->join("cbt_bank_soal c", "c.id_bank=a.id_bank", "left");
goto LBs0K;
vPRrO: $this->db->from("cbt_jadwal a");
goto IgVam;
VOOy7: return $this->db->get()->row();
goto tw_NF;
BH3JF: $this->db->join("master_jurusan f", "f.id_jurusan=c.bank_jurusan_id", "left");
goto rdAKL;
DNmLT: $this->db->join("master_smt h", "h.id_smt=a.id_smt", "left");
goto HnGOS;
mS8ve: $this->db->select("a.id_jadwal, a.id_tp, a.id_smt, a.id_bank, a.id_jenis, a.tgl_mulai, a.tgl_selesai," . " a.durasi_ujian, a.pengawas, a.acak_soal, a.acak_opsi, a.hasil_tampil, a.token, a.status, a.ulang," . " a.reset_login, a.rekap, a.jam_ke, a.jarak," . " b.nama_jenis, b.kode_jenis," . " c.bank_kode, c.bank_level, c.bank_kelas, c.bank_mapel_id, c.bank_jurusan_id," . " c.bank_guru_id, c.bank_nama, c.jml_soal, c.jml_esai, c.tampil_pg, c.tampil_esai, c.bobot_pg," . " c.bobot_esai, c.opsi, c.date, c.status, c.soal_agama, c.id_tp, c.id_smt, c.deskripsi, c.jml_kompleks," . " c.tampil_kompleks, c.bobot_kompleks, c.jml_jodohkan, c.tampil_jodohkan, c.bobot_jodohkan, c.jml_isian," . " c.tampil_isian, c.bobot_isian, c.status_soal," . " d.id_mapel, d.nama_mapel, d.kode," . " e.id_guru, e.nama_guru," . " f.id_jurusan, f.nama_jurusan, f.kode_jurusan," . " g.tahun," . " h.smt, h.nama_smt," . " (SELECT COUNT(id_soal) FROM cbt_soal WHERE cbt_soal.bank_id = a.id_bank) AS total_soal");
goto vPRrO;
IgVam: $this->db->join("cbt_jenis b", "b.id_jenis=a.id_jenis", "left");
goto ZC5ie;
rdAKL: $this->db->join("master_tp g", "g.id_tp=a.id_tp", "left");
goto DNmLT;
HnGOS: $this->db->where("a.id_jadwal", $id_jadwal);
goto VOOy7;
LBs0K: $this->db->join("master_mapel d", "d.id_mapel=c.bank_mapel_id", "left");
goto x4F2D;
tw_NF: }
public function getCbtById($id_jadwal) { goto CV1Xz;
soFOO: $this->db->from("cbt_jadwal");
goto hZU4h;
CV1Xz: $this->db->select("*");
goto soFOO;
XXczg: return $this->db->get()->row();
goto Ztg33;
hZU4h: $this->db->where("id_jadwal", $id_jadwal);
goto XXczg;
Ztg33: }
public function getIdRuangById($array) { goto b5OjU;
TyxM8: if (!$result) { goto mxfD_;
} goto n1ejT;
b5OjU: $this->db->select("nama_ruang");
goto sD06d;
GuDhc: mxfD_: goto nLp5q;
lJzwY: $this->db->where("id_ruang", $array);
goto X9PVN;
wqjJ5: WQM_f: goto GuDhc;
X9PVN: $result = $this->db->get()->result();
goto TyxM8;
n1ejT: foreach ($result as $key => $row) { $ret[$row->id_ruang] = $row->kode_ruang;
v6DgL: } goto wqjJ5;
nLp5q: return $ret;
goto xehID;
sD06d: $this->db->from("cbt_ruang");
goto lJzwY;
xehID: }
public function getNamaRuangById($id) { goto rWceY;
XISVE: goto Ih_kR;
goto opydq;
opydq: GImfH: goto a7LIb;
RybpK: $result = $this->db->get()->row();
goto xID0S;
aCTIA: Ih_kR: goto CD9Qu;
BNqbk: return '';
goto XISVE;
pZ8_M: $this->db->from("cbt_ruang");
goto y2tcc;
rWceY: $this->db->select("nama_ruang");
goto pZ8_M;
y2tcc: $this->db->where("id_ruang", $id);
goto RybpK;
xID0S: if ($result) { goto GImfH;
} goto BNqbk;
a7LIb: return $result->nama_ruang;
goto aCTIA;
CD9Qu: }
public function getNamaSesiById($id) { goto vyN_G;
vyN_G: $this->db->select("nama_sesi");
goto i3lnn;
N4h1h: return $this->db->get()->row()->nama_sesi;
goto GxIkw;
i3lnn: $this->db->from("cbt_sesi");
goto wpzDq;
wpzDq: $this->db->where(["id_sesi" => $id]);
goto N4h1h;
GxIkw: }
public function getNamaKelasById($id) { goto MxcwH;
cKL9G: return $this->db->get()->row()->nama_kelas;
goto or1_b;
MxcwH: $this->db->select("nama_kelas");
goto ebLcY;
ebLcY: $this->db->from("master_kelas");
goto yz2U4;
yz2U4: $this->db->where(["id_kelas" => $id]);
goto cKL9G;
or1_b: }
public function getNamaGuruById($id) { goto x89wr;
U0x0f: $this->db->where("id_guru", $id);
goto juVH0;
RnThr: $this->db->from("master_guru");
goto U0x0f;
juVH0: return $this->db->get()->row()->nama_guru;
goto zwO48;
x89wr: $this->db->select("nama_guru");
goto RnThr;
zwO48: }
public function getElapsed($id) { goto sY9H9;
uZ0X3: $this->db->from("cbt_durasi_siswa");
goto UWy7K;
UWy7K: $this->db->where("id_durasi", $id);
goto Ndky1;
sY9H9: $this->db->select("id_durasi, id_siswa, id_jadwal, status, lama_ujian, mulai, selesai, reset");
goto uZ0X3;
Ndky1: return $this->db->get()->row();
goto FmSw_;
FmSw_: }
public function getSoalSiswa($id_bank, $id_siswa) { goto drTyd;
Pdr3w: $this->db->from("cbt_soal_siswa a");
goto H3_2k;
lGDmf: $this->db->where("a.id_siswa", $id_siswa);
goto pI4Iz;
tZlbU: $this->db->order_by("a.no_soal_alias");
goto AFU1b;
pI4Iz: $this->db->order_by("a.jenis_soal");
goto tZlbU;
drTyd: $this->db->select("a.*, b.jenis, b.nomor_soal, b.jawaban");
goto Pdr3w;
bYSfa: $this->db->where("a.id_bank", $id_bank);
goto lGDmf;
AFU1b: return $this->db->get()->result();
goto DDeny;
H3_2k: $this->db->join("cbt_soal b", "b.id_soal=a.id_soal", "left");
goto bYSfa;
DDeny: }
public function getJumlahSoalSiswa($id_bank, $id_siswa) { goto jpkf5;
uNvgC: $result = $this->db->get()->num_rows();
goto pj6Fj;
jpkf5: $this->db->select("id_soal_siswa");
goto sicOg;
pj6Fj: return $result;
goto WVmE_;
HjkP0: $this->db->where("id_bank", $id_bank);
goto fXqU2;
sicOg: $this->db->from("cbt_soal_siswa");
goto HjkP0;
fXqU2: $this->db->where("id_siswa", $id_siswa);
goto uNvgC;
WVmE_: }
public function getALLSoalSiswa($id_bank, $id_siswa) { goto AG_MF;
mcirB: $this->db->where("a.id_siswa", $id_siswa);
goto OCTLj;
H5eL8: $this->db->where("a.id_bank", $id_bank);
goto mcirB;
AG_MF: $this->db->select("a.id_soal_siswa, a.id_bank, a.id_jadwal, a.id_soal, a.id_siswa, a.jenis_soal," . " a.no_soal_alias, a.opsi_alias_a, a.opsi_alias_b, a.opsi_alias_c, a.opsi_alias_d, a.opsi_alias_e," . " a.jawaban_alias, a.jawaban_siswa, a.jawaban_benar, a.point_essai, a.soal_end, a.point_soal," . " b.id_soal, b.nomor_soal, b.soal, b.jawaban, b.opsi_a, b.opsi_b, b.opsi_c, b.opsi_d," . " b.opsi_e, b.tampilkan");
goto D1wsg;
ccCdw: $result = $this->db->get()->result();
goto KCE3u;
D1wsg: $this->db->from("cbt_soal_siswa a");
goto lFx2k;
OCTLj: $this->db->order_by("a.no_soal_alias");
goto ccCdw;
KCE3u: return $result;
goto yE_43;
lFx2k: $this->db->join("cbt_soal b", "b.id_soal=a.id_soal");
goto H5eL8;
yE_43: }
public function getJumlahJawaban($id_bank, $id_siswa) { goto D3kim;
mqsJE: $result = $this->db->get()->result();
goto QExft;
BSFih: $this->db->where("id_siswa", $id_siswa);
goto mqsJE;
Ot9tT: $this->db->where("id_bank", $id_bank);
goto BSFih;
cZZx4: $this->db->from("cbt_soal_siswa");
goto Ot9tT;
D3kim: $this->db->select("jawaban_siswa, id_siswa, id_bank");
goto cZZx4;
QExft: return $result;
goto HWAW_;
HWAW_: }
public function getSoalSiswaByJadwal($id_jadwal, $id_siswa) { goto WB8_h;
DgSHP: return $this->db->get()->result();
goto oqPC6;
PrCVt: $this->db->from("cbt_soal_siswa a");
goto xjFF8;
BJex1: $this->db->order_by("a.jenis_soal");
goto jhAKS;
xjFF8: $this->db->join("cbt_soal b", "b.id_soal=a.id_soal");
goto xCxQ7;
fI2hV: $this->db->where("a.id_siswa", $id_siswa);
goto XiYZv;
xCxQ7: $this->db->where("a.id_jadwal", $id_jadwal);
goto fI2hV;
WB8_h: $this->db->select("a.*, b.jenis, b.nomor_soal, b.soal, b.jawaban, b.opsi_a, b.opsi_b, b.opsi_c, b.opsi_d, b.opsi_e");
goto PrCVt;
XiYZv: $this->db->where("b.tampilkan", "1");
goto BJex1;
jhAKS: $this->db->order_by("b.nomor_soal");
goto DgSHP;
oqPC6: }
public function getSoalSiswaByNomor($id_soal_siswa) { goto QaVX0;
EHzLl: return $this->db->get()->row();
goto xETFR;
QaVX0: $this->db->select("a.id_soal_siswa, a.id_bank, a.opsi_alias_a, a.opsi_alias_b, a.opsi_alias_c, a.opsi_alias_d," . " a.opsi_alias_e, a.no_soal_alias, a.jawaban_alias, a.soal_end, a.jawaban_siswa," . " b.id_soal, b.jenis, b.nomor_soal, b.soal, b.jawaban, b.opsi_a, b.opsi_b, b.opsi_c, b.opsi_d, b.opsi_e, b.tampilkan," . " c.tampil_pg, c.tampil_kompleks, c.tampil_jodohkan, c.tampil_isian, c.tampil_esai,");
goto XyQvW;
dbsdl: $this->db->join("cbt_bank_soal c", "b.id_bank=a.id_bank");
goto TJr0D;
TJr0D: $this->db->where("a.id_soal_siswa", $id_soal_siswa);
goto E38uM;
XyQvW: $this->db->from("cbt_soal_siswa a");
goto MYpXI;
MYpXI: $this->db->join("cbt_soal b", "b.id_soal=a.id_soal");
goto dbsdl;
E38uM: $this->db->order_by("a.no_soal_alias");
goto EHzLl;
xETFR: }
public function getSettingKartu() { goto OZKE_;
uZmDd: return $this->db->get()->row();
goto gw3dS;
n68z_: $this->db->from("cbt_kop_kartu");
goto uZmDd;
OZKE_: $this->db->select("*");
goto n68z_;
gw3dS: }
public function getSettingKopAbsensi() { goto pHF0R;
s5KiK: $this->db->join("setting b", "b.id_setting=1", "left");
goto x2FyK;
culxd: $this->db->from("cbt_kop_absensi a");
goto s5KiK;
x2FyK: return $this->db->get()->row();
goto qHR0L;
pHF0R: $this->db->select("a.*, b.logo_kanan, b.logo_kiri, b.kepsek, b.tanda_tangan");
goto culxd;
qHR0L: }
public function getSettingKopBeritaAcara() { goto mtydb;
v3DWa: return $this->db->get()->row();
goto n7tGw;
mtydb: $this->db->select("a.*, d.logo_kanan, d.logo_kiri, d.kepsek, d.nip, d.tanda_tangan, d.sekolah");
goto uy4pI;
ocGsi: $this->db->join("setting d", "d.id_setting=1", "left");
goto v3DWa;
uy4pI: $this->db->from("cbt_kop_berita a");
goto ocGsi;
n7tGw: }
public function getDurasiSiswa($id) { return $this->db->get_where("cbt_durasi_siswa", "id_durasi=" . $id)->row();
}
public function getFilterJawabanSiswa($jadwal, $arrIdSiswa) { goto P49vZ;
QMzZD: return $this->db->get("cbt_soal_siswa")->result();
goto S3gQe;
kztt9: $this->db->where_in("id_siswa", $arrIdSiswa);
goto QMzZD;
P49vZ: $this->db->where("id_jadwal", $jadwal);
goto kztt9;
S3gQe: }
public function getFilterDurasiSiswa($jadwal, $arrIdSiswa) { goto TJW_P;
NgE3M: foreach ($result as $key => $row) { $ret[$row->id_durasi] = $row;
EF8Dg: } goto rtIez;
sSVQV: return $ret;
goto qb7lD;
ILv_e: $result = $this->db->get_where("cbt_durasi_siswa")->result();
goto OFmrA;
OFmrA: $ret = [];
goto NgE3M;
TJW_P: $this->db->where("id_jadwal", $jadwal);
goto ILv_e;
rtIez: JR2YK: goto sSVQV;
qb7lD: }
public function getJawabanByBank($id_bank, $id_siswa = null) { goto PoHaR;
mO6gw: $result = $this->db->get()->result();
goto RhLR0;
RhLR0: return $result;
goto EEKaz;
C3O8s: $this->db->join("cbt_soal b", "b.id_soal=a.id_soal");
goto WsrLA;
zH65d: $this->db->where("a.id_bank=", $id_bank);
goto mO6gw;
cYxy1: $this->db->where("a.id_siswa=", $id_siswa);
goto JwXnX;
JwXnX: ei12u: goto zH65d;
BnLQl: $this->db->from("cbt_soal_siswa a");
goto C3O8s;
WsrLA: if (!($id_siswa != null)) { goto ei12u;
} goto cYxy1;
PoHaR: $this->db->select("a.*, b.nomor_soal, b.jawaban");
goto BnLQl;
EEKaz: }
public function getJawabanSiswa($id) { goto dYHuS;
dYHuS: $this->db->select("id_soal_siswa, id_bank, id_jadwal, id_soal, id_siswa, jenis_soal, no_soal_alias, opsi_alias_a, opsi_alias_b, opsi_alias_c, opsi_alias_d, opsi_alias_e, jawaban_alias, jawaban_siswa, jawaban_benar, point_soal");
goto o3LlQ;
o3LlQ: $this->db->from("cbt_soal_siswa");
goto t4oUc;
t4oUc: $this->db->where("id_soal_siswa=", $id);
goto JyAj9;
JyAj9: return $this->db->get()->row();
goto Z1RHg;
Z1RHg: }
public function getJawabanSiswaByJadwal($id_jadwal, $id_siswa = null) { goto pW8SW;
nCFa2: lFc7l: goto DCE75;
nz7dj: $this->db->join("cbt_soal b", "b.id_soal=a.id_soal");
goto r7aPa;
x8Rzn: $this->db->where("b.tampilkan", "1");
goto X1GMr;
T9Y6o: goto NSc96;
goto nCFa2;
z6oK6: $this->db->where("a.id_jadwal=", $id_jadwal);
goto x8Rzn;
Ss1Nk: $this->db->from("cbt_soal_siswa a");
goto nz7dj;
X1GMr: $this->db->order_by("a.jenis_soal");
goto Jx6Ty;
insG2: if (is_array($id_siswa)) { goto lFc7l;
} goto MSWnh;
aoyn_: NSc96: goto Jw_lz;
DCE75: $this->db->where_in("a.id_siswa", $id_siswa);
goto aoyn_;
MSWnh: $this->db->where("a.id_siswa", $id_siswa);
goto T9Y6o;
Jx6Ty: $this->db->order_by("b.nomor_soal");
goto DbF9T;
r7aPa: if (!($id_siswa != null)) { goto UbVGm;
} goto insG2;
pW8SW: $this->db->select("a.*, b.jenis, b.nomor_soal, b.soal, b.jawaban, b.opsi_a, b.opsi_b, b.opsi_c, b.opsi_d, b.opsi_e, b.tampilkan");
goto Ss1Nk;
Jw_lz: UbVGm: goto z6oK6;
DbF9T: return $this->db->get()->result();
goto yQRto;
yQRto: }
public function getIdSiswaFromJawabanByJadwal($id_jadwal) { goto lqLKl;
lqLKl: $result = $this->db->get_where("cbt_soal_siswa", "id_jadwal=" . $id_jadwal)->result();
goto pv4gY;
ZfVJH: return $retur;
goto LxEeL;
Ux19J: qXHoD: goto ZfVJH;
pv4gY: $retur = [];
goto wKOZY;
wKOZY: foreach ($result as $row) { $retur[$row->id_siswa][] = $row;
G0POW: } goto Ux19J;
LxEeL: }
public function getDurasiSiswaByJadwal($id_jadwal, $id_siswa = null) { goto U1D4a;
i14bG: if (!($id_siswa != null)) { goto fwhSH;
} goto zuuUv;
MKR3g: return $this->db->get()->result();
goto uKqtX;
zuuUv: $this->db->where("id_siswa=", $id_siswa);
goto OcGRM;
U1D4a: $this->db->select("id_durasi, id_siswa, id_jadwal, status, lama_ujian, mulai, selesai, reset");
goto RHi_f;
OcGRM: fwhSH: goto MKR3g;
rzOFP: $this->db->where("id_jadwal=", $id_jadwal);
goto i14bG;
RHi_f: $this->db->from("cbt_durasi_siswa");
goto rzOFP;
uKqtX: }
public function getIdSiswaFromDurasiByJadwal($id_jadwal) { goto XCq_d;
ovD4Q: FVNbR: goto mXMgl;
mXMgl: return $retur;
goto rLcXz;
lvSNk: foreach ($result as $row) { $retur[$row->id_siswa] = $row;
T36p6: } goto ovD4Q;
wejGj: $retur = [];
goto lvSNk;
XCq_d: $result = $this->db->get_where("cbt_durasi_siswa", "id_jadwal=" . $id_jadwal)->result();
goto wejGj;
rLcXz: }
public function getLogUjianByJadwal($id_jadwal) { goto vnQnb;
k0cyN: $this->db->where("id_jadwal=", $id_jadwal);
goto Xmj68;
Xmj68: return $this->db->get()->result();
goto m1gI4;
ac7Wj: $this->db->from("log_ujian");
goto k0cyN;
vnQnb: $this->db->select("id_log, log_time, id_siswa, id_jadwal, log_type, log_desc, address, agent, device, reset");
goto ac7Wj;
m1gI4: }
public function getIdSiswaFromLogUjianByJadwal($id_jadwal) { goto XisYv;
xXCr0: $retur = [];
goto qeglD;
zv3Gu: return $retur;
goto YcKlh;
qeglD: foreach ($result as $row) { $retur[$row->id_siswa] = $row;
OFIAg: } goto YgJ5k;
YgJ5k: h8q8u: goto zv3Gu;
XisYv: $result = $this->db->get_where("log_ujian", "id_jadwal=" . $id_jadwal)->result();
goto xXCr0;
YcKlh: }
public function getNilaiSiswa($arr_jadwal, $id_siswa) { goto gKj9z;
ghK0Y: foreach ($result as $row) { $retur[$row->id_jadwal] = $row;
LWnlC: } goto jlSXn;
a1uYK: return $retur;
goto qiaKe;
hJ7YC: $retur = [];
goto ghK0Y;
gKj9z: $this->db->select("*");
goto YdIAm;
RPFcq: $this->db->where_in("id_jadwal", $arr_jadwal);
goto B8H2Q;
YdIAm: $this->db->from("cbt_nilai");
goto RPFcq;
jlSXn: oSxqZ: goto a1uYK;
B8H2Q: $this->db->where("id_siswa", $id_siswa);
goto EiQga;
EiQga: $result = $this->db->get()->result();
goto hJ7YC;
qiaKe: }
public function getNilaiSiswaByJadwal($id_jadwal, $id_siswa) { goto yQ5Vx;
D0UEe: return $result;
goto S96AD;
TrfNU: $this->db->where("id_siswa", $id_siswa);
goto QqSVm;
tMwA_: $this->db->where("id_jadwal", $id_jadwal);
goto TrfNU;
QqSVm: $result = $this->db->get()->row();
goto D0UEe;
eEMzh: $this->db->from("cbt_nilai");
goto tMwA_;
yQ5Vx: $this->db->select("*");
goto eEMzh;
S96AD: }
public function getNilaiAllSiswa($arr_jadwal, $arr_id_siswa) { goto Qafmx;
yRy0j: $this->db->from("cbt_nilai");
goto r_bMO;
Qafmx: $this->db->select("*");
goto yRy0j;
FanbG: sp4C2: goto J2euD;
o8YE1: $result = $this->db->get()->result();
goto NMMDd;
hAFOL: $this->db->where_in("id_siswa", $arr_id_siswa);
goto o8YE1;
NMMDd: $retur = [];
goto h4JgV;
J2euD: return $retur;
goto WptGx;
r_bMO: $this->db->where_in("id_jadwal", $arr_jadwal);
goto hAFOL;
h4JgV: foreach ($result as $row) { $retur[$row->id_siswa] = $row;
DqaVQ: } goto FanbG;
WptGx: }
public function getAllNilaiSiswa($id_jadwal) { goto KR4Ht;
CA6Ri: rN1Qc: goto AjH7w;
ZkzxO: foreach ($result as $row) { $retur[$row->id_siswa] = $row;
eP6pv: } goto CA6Ri;
AjH7w: return $retur;
goto CUq10;
n_l6O: $retur = [];
goto ZkzxO;
ro4kE: $this->db->where("id_jadwal", $id_jadwal);
goto owmTK;
KR4Ht: $this->db->select("*");
goto zuhW9;
zuhW9: $this->db->from("cbt_nilai");
goto ro4kE;
owmTK: $result = $this->db->get()->result();
goto n_l6O;
CUq10: }
public function getTotalKoreksi() { goto v2sn_;
eM_Ui: foreach ($result as $row) { goto MkUXH;
MkUXH: if (!($row->id_siswa != null)) { goto Fcl7w;
} goto Me1z3;
Me1z3: $retur[$row->id_jadwal][$row->dikoreksi][] = $row->id_siswa;
goto cPMri;
cPMri: Fcl7w: goto u3zUo;
u3zUo: CDJkH: goto F2mKx;
F2mKx: } goto Xgoas;
wDBaP: $this->db->from("cbt_nilai");
goto ztaQu;
Xgoas: AKFKw: goto wq4Lc;
FBIhw: $retur = [];
goto eM_Ui;
ztaQu: $result = $this->db->get()->result();
goto FBIhw;
v2sn_: $this->db->select("id_jadwal, dikoreksi, id_siswa");
goto wDBaP;
wq4Lc: return $retur;
goto Gc1dW;
Gc1dW: }
public function getNilaiAnalisis($id_jadwal) { return $this->db->get_where("cbt_nilai", "id_jadwal=" . $id_jadwal)->result();
}
public function getLogUjian($siswa_id, $id_jadwal) { return $this->db->get_where("log_ujian", "id_siswa=" . $siswa_id . " AND id_jadwal=" . $id_jadwal)->result();
}
public function getNomorPeserta($id_siswa) { return $this->db->get_where("cbt_nomor_peserta", "id_siswa=" . $id_siswa)->row();
}
public function getAllNomorPeserta() { goto ZknCl;
xa7Zh: foreach ($result as $row) { $ret[$row->id_siswa] = $row;
DHqD0: } goto OVBVO;
ZknCl: $this->db->select("*");
goto Taj9T;
uKkHs: return $ret;
goto F9pEQ;
Gy2hw: $ret = [];
goto xa7Zh;
OVBVO: AfNi2: goto uKkHs;
Taj9T: $result = $this->db->get("cbt_nomor_peserta")->result();
goto Gy2hw;
F9pEQ: }
public function getDistinctTahun() { goto tN3x7;
DmVNY: $result = $this->db->get("cbt_rekap_nilai")->result();
goto LA8Iq;
tN3x7: $this->db->select("tp");
goto BWK38;
R__rR: return $ret;
goto lnKrA;
LA8Iq: $ret = [];
goto c4DnD;
c4DnD: foreach ($result as $row) { $ret[$row->tp] = $row->tp;
XZrda: } goto baTpD;
baTpD: D4j8e: goto R__rR;
BWK38: $this->db->distinct();
goto DmVNY;
lnKrA: }
public function getDistinctSmt() { goto ZW5Dp;
H2B5U: return $ret;
goto QL19y;
ZX_Wv: foreach ($result as $row) { $ret[$row->smt] = $row->smt;
hsjsO: } goto WZCdG;
ZW5Dp: $this->db->select("smt");
goto vExvT;
mxlcH: $ret = [];
goto ZX_Wv;
WZCdG: nV2mQ: goto H2B5U;
vExvT: $this->db->distinct();
goto sKFHv;
sKFHv: $result = $this->db->get("cbt_rekap_nilai")->result();
goto mxlcH;
QL19y: }
public function getDistinctJenisUjian() { goto xRdDd;
Dr64V: iosxP: goto MOfVn;
MOfVn: return $ret;
goto ZSoNK;
xRdDd: $this->db->select("tp, smt, kode_jenis");
goto LS0qY;
LS0qY: $this->db->distinct();
goto kwRzn;
kwRzn: $result = $this->db->get("cbt_rekap_nilai")->result();
goto CdDWE;
PTS0J: foreach ($result as $row) { $ret[$row->tp][$row->smt][$row->kode_jenis] = $row->kode_jenis;
gFzeu: } goto Dr64V;
CdDWE: $ret = [];
goto PTS0J;
ZSoNK: }
public function getDistinctJenis($tp, $smt) { goto MOH8d;
LGlvC: ibiSq: goto TPT19;
VPa9B: $this->db->distinct();
goto u_fke;
MOH8d: $this->db->select("kode_jenis");
goto VPa9B;
D7B2h: $ret = [];
goto CJAnK;
CJAnK: foreach ($result as $row) { $ret[$row->kode_jenis] = $row->kode_jenis;
suQbB: } goto LGlvC;
u_fke: $result = $this->db->get("cbt_rekap_nilai")->result();
goto D7B2h;
TPT19: return $ret;
goto PUSzF;
PUSzF: }
public function getDistinctKelas($id_jadwal = null) { goto tS4pT;
tS4pT: $this->db->select("a.tp, a.smt, a.kode_jenis, a.id_kelas, b.nama_kelas");
goto mbpQU;
pSBkJ: $this->db->where("id_jadwal", $id_jadwal);
goto GgYCg;
akJn0: xLM54: goto pvJHn;
eu_ZR: $result = $this->db->get()->result();
goto hEcEJ;
pvJHn: return $ret;
goto MfWsq;
Iwd1e: $this->db->join("master_kelas b", "b.id_kelas=a.id_kelas");
goto eu_ZR;
GgYCg: KBuQ8: goto Iwd1e;
qIZ1F: if (!($id_jadwal != null)) { goto KBuQ8;
} goto pSBkJ;
mbpQU: $this->db->distinct();
goto be0v8;
ATO23: foreach ($result as $row) { goto dzbU2;
y22Ov: $ret[$row->tp][$row->smt][$row->kode_jenis][$row->id_kelas] = $row->nama_kelas;
goto w5p5a;
w5p5a: yhjO7: goto seAXH;
seAXH: dL7eU: goto W52NF;
dzbU2: if (!($row->id_kelas != '')) { goto yhjO7;
} goto y22Ov;
W52NF: } goto akJn0;
hEcEJ: $ret = [];
goto ATO23;
be0v8: $this->db->from("cbt_rekap_nilai a");
goto qIZ1F;
MfWsq: } }
?>Did this file decode correctly?
Original Code
<?php
/* ________________________________________
| GarudaCBT |
| https://github.com/garudacbt/cbt |
|________________________________________|
*/
class Cbt_model extends CI_Model
{
public function get_where($table, $pk, $id, $join = null, $order = null) { goto RV4d1;
YfZjq: KG_Fg: goto SJAMb;
kSZ1k: foreach ($order as $field => $sort) { $this->db->order_by($field, $sort);
BGpqt: } goto YfZjq;
bE9lo: if (!($join !== null)) { goto p_UDq;
} goto VDplZ;
Uzv3i: $this->db->where($pk, $id);
goto bE9lo;
VDplZ: foreach ($join as $table => $field) { $this->db->join($table, $field);
R_mhI: } goto Z6Uhj;
Z6Uhj: J80Bl: goto UV7SR;
RV4d1: $this->db->select("*");
goto QOUhb;
jb_rk: if (!($order !== null)) { goto Ed3k9;
} goto kSZ1k;
GFsZN: return $query;
goto lKvIH;
UV7SR: p_UDq: goto jb_rk;
QOUhb: $this->db->from($table);
goto Uzv3i;
a29wT: $query = $this->db->get();
goto GFsZN;
SJAMb: Ed3k9: goto a29wT;
lKvIH: }
public function saveLog($id_siswa, $id_jadwal, $type, $desc) { goto f6SsT;
JtnFw: $ip = $this->input->ip_address();
goto tMWfK;
tAzN2: if ($agent == "unknown") { goto pYml_;
} goto zstRk;
zstRk: $os = $this->agent->platform();
goto JtnFw;
DB1Y8: pYml_: goto EcInN;
PFaUM: goto sBDo7;
goto DB1Y8;
ovEs6: $agent = $this->agent->mobile();
goto P2J8I;
aCIzX: goto tp8vY;
goto B3sT6;
B3sT6: tJmzJ: goto ovEs6;
ZSJCZ: $agent = "unknown";
goto S6wrG;
S6wrG: goto tp8vY;
goto bGxiI;
bGxiI: HtwID: goto oWQ3d;
P2J8I: tp8vY: goto tAzN2;
f6SsT: if ($this->agent->is_browser()) { goto HtwID;
} goto Is5PR;
oWQ3d: $agent = $this->agent->browser() . " " . $this->agent->version();
goto aCIzX;
Is5PR: if ($this->agent->is_mobile()) { goto tJmzJ;
} goto ZSJCZ;
EcInN: return "error";
goto lzMiz;
lzMiz: sBDo7: goto Bl_jD;
tMWfK: return $this->insertLog($id_siswa, $id_jadwal, $type, $desc, $agent, $os, $ip);
goto PFaUM;
Bl_jD: } private function insertLog($id_siswa, $id_jadwal, $type, $desc, $agent, $os, $ip) { goto FCb2m;
gZCzz: return $insert;
goto VP5Oc;
wzWwg: $insert = $this->db->update("log_ujian");
goto xD65y;
rFm4P: A9hMj: goto ZnJyX;
xD65y: thwTS: goto gZCzz;
TaNAm: $data = array("id_log" => $id_siswa . "0" . $id_jadwal . $type, "id_siswa" => $id_siswa, "id_jadwal" => $id_jadwal, "log_type" => $type, "log_desc" => $desc, "address" => $ip, "agent" => $agent, "device" => $os);
goto uJoKx;
gO_sf: $this->db->where("id_log", $id_siswa . "0" . $id_jadwal . $type);
goto wzWwg;
ZnJyX: $this->db->set("log_type", $type);
goto S3B3q;
uJoKx: $insert = $this->db->insert("log_ujian", $data);
goto qzDSI;
qzDSI: goto thwTS;
goto rFm4P;
FCb2m: $log = $this->db->where("id_log", $id_siswa . "0" . $id_jadwal . $type)->get("log_ujian")->row();
goto Fnwl8;
S3B3q: $this->db->set("log_desc", $desc);
goto gO_sf;
Fnwl8: if ($log != null) { goto A9hMj;
} goto TaNAm;
VP5Oc: }
public function getDataSiswa($username, $id_tp, $id_smt) { goto Z0fuU;
Dtl_i: $this->db->join("master_kelas c", "b.id_kelas=c.id_kelas AND c.id_tp=" . $id_tp . " AND c.id_smt=" . $id_smt, "left");
goto sjVqM;
MB1bE: $query = $this->db->get()->row();
goto aSkwB;
aSkwB: return $query;
goto cLXVy;
ViM3W: $this->db->from("master_siswa a");
goto tp_l1;
tp_l1: $this->db->join("kelas_siswa b", "a.id_siswa=b.id_siswa AND b.id_tp=" . $id_tp . " AND b.id_smt=" . $id_smt, "left");
goto Dtl_i;
sjVqM: $this->db->join("cbt_sesi_siswa d", "a.id_siswa=d.siswa_id", "left");
goto Mfzlj;
Z0fuU: $this->db->select("a.id_siswa, a.nisn, a.nis, a.nama, a.jenis_kelamin, a.username, a.password, a.agama, a.foto," . " b.id_kelas_siswa, b.id_tp, b.id_smt, b.id_siswa, b.id_kelas," . " c.nama_kelas, c.kode_kelas, c.level_id, " . " d.kelas_id, d.ruang_id, d.sesi_id");
goto ViM3W;
Mfzlj: $this->db->where("username", $username);
goto MB1bE;
cLXVy: }
public function getDataSiswaById($id_tp, $id_smt, $idSiswa) { goto Fee3b;
Kvc2A: $this->db->join("cbt_ruang i", "i.id_ruang=h.id_ruang", "left");
goto v2WLN;
q4a0w: $this->db->join("cbt_kelas_ruang h", "h.id_kelas=a.id_kelas", "left");
goto Kvc2A;
cJBIF: $this->db->join("master_siswa b", "b.id_siswa=a.id_siswa", "left");
goto ijFiC;
ijFiC: $this->db->join("cbt_sesi_siswa c", "c.siswa_id=a.id_siswa", "left");
goto P92Jz;
da9aF: $this->db->join("master_kelas f", "f.id_kelas=a.id_kelas", "left");
goto al7SH;
VRZ6f: return $this->db->get()->row();
goto skZkT;
yDVxb: $this->db->join("cbt_sesi e", "e.id_sesi=c.sesi_id", "left");
goto da9aF;
P92Jz: $this->db->join("cbt_ruang d", "d.id_ruang=c.ruang_id", "left");
goto yDVxb;
v2WLN: $this->db->join("cbt_sesi j", "j.id_sesi=h.id_sesi", "left");
goto tJdfY;
m2rD1: $this->db->where("a.id_siswa", $idSiswa);
goto VRZ6f;
al7SH: $this->db->join("cbt_nomor_peserta g", "g.id_siswa=a.id_siswa AND g.id_tp=" . $id_tp, "left");
goto q4a0w;
iGx70: $this->db->where("a.id_smt", $id_smt);
goto m2rD1;
tJdfY: $this->db->where("a.id_tp", $id_tp);
goto iGx70;
q94u6: $this->db->from("kelas_siswa a");
goto cJBIF;
Fee3b: $this->db->select("b.id_siswa, b.nama, b.jenis_kelamin, b.nis, b.nisn, b.username, b.password," . " b.foto, c.sesi_id, d.kode_ruang, e.kode_sesi, f.nama_kelas, g.nomor_peserta," . " h.set_siswa, i.kode_ruang as ruang_kelas, j.kode_sesi as sesi_kelas");
goto q94u6;
skZkT: }
public function getWaktuSesiById($id_sesi) { goto TUNqm;
cjkhZ: $result = $this->db->get("cbt_sesi")->row();
goto Aei3L;
TUNqm: $this->db->select("*");
goto dbEvG;
dbEvG: $this->db->where("id_sesi", $id_sesi);
goto cjkhZ;
Aei3L: return $result;
goto VxUzX;
VxUzX: }
public function getAllRuang() { goto fJnDe;
fJnDe: $result = $this->db->get("cbt_ruang")->result();
goto c4L5o;
BzUTW: foreach ($result as $key => $row) { $ret[$row->id_ruang] = $row->kode_ruang;
koWBb: } goto y7A0b;
wtMih: if (!$result) { goto diSwK;
} goto BzUTW;
y7A0b: vLWe8: goto FmKmy;
SELhl: return $ret;
goto izLCN;
c4L5o: $ret = [];
goto wtMih;
FmKmy: diSwK: goto SELhl;
izLCN: }
public function getKelasByLevel($level, $arrKelas) { goto mayez;
dZwaL: $this->db->where("level_id", $level);
goto CCn0U;
PvHjw: $result = $this->db->get("master_kelas")->result();
goto TMEfh;
TMEfh: return $result;
goto EnU13;
mayez: $this->db->select("id_kelas, kode_kelas");
goto dZwaL;
CCn0U: $this->db->where_in("id_kelas", $arrKelas);
goto PvHjw;
EnU13: }
public function getAllJurusan() { goto y5zT6;
X01i4: EZ470: goto z11BL;
CNdwk: if (!$result) { goto IkR2T;
} goto rEGdG;
rEGdG: foreach ($result as $key => $row) { $ret[$row->id_jurusan] = $row->kode_jurusan;
A1uHJ: } goto X01i4;
vGN7c: return $ret;
goto d0_Od;
y5zT6: $result = $this->db->get("master_jurusan")->result();
goto CNdwk;
z11BL: IkR2T: goto vGN7c;
d0_Od: }
public function getPengawas($id_pengawas) { goto KyT7T;
KyT7T: $this->db->select("id_pengawas, id_jadwal, id_tp, id_smt, id_ruang, id_sesi, id_guru");
goto Qvy6Z;
Qvy6Z: $this->db->from("cbt_pengawas");
goto XAQ9Q;
XAQ9Q: $this->db->where("id_pengawas", $id_pengawas);
goto kwh7t;
kwh7t: return $this->db->get()->row();
goto yU7fp;
yU7fp: }
public function getPengawasByGuru($tp, $smt, $id_guru) { goto Bnmap;
gC8Aq: $this->db->where("a.id_smt", $smt);
goto csrAw;
csrAw: $this->db->like("a.id_guru", $id_guru);
goto WW227;
XLtIA: $this->db->join("cbt_bank_soal c", "b.id_bank=c.id_bank");
goto fvTd5;
fvTd5: return $this->db->get()->result();
goto S19Lf;
kYGL3: $this->db->where("a.id_tp", $tp);
goto gC8Aq;
WW227: $this->db->join("cbt_jadwal b", "b.id_jadwal=a.id_jadwal");
goto XLtIA;
Bnmap: $this->db->select("a.id_pengawas, a.id_jadwal, a.id_tp, a.id_smt, a.id_ruang, a.id_sesi, a.id_guru," . " b.id_jadwal, b.tgl_mulai, b.tgl_selesai, c.bank_kode");
goto OMaMS;
OMaMS: $this->db->from("cbt_pengawas a");
goto kYGL3;
S19Lf: }
public function getPengawasByJadwal($tp, $smt, $id_jadwal, $sesi = null, $ruang = null) { goto g2Brm;
b9tuP: $this->db->from("cbt_pengawas");
goto DrT2v;
DrT2v: $this->db->where("id_tp", $tp);
goto V56pB;
jvQlO: return $result;
goto B4RQG;
V56pB: $this->db->where("id_smt", $smt);
goto ymkVp;
boq4u: $result = $this->db->get()->result();
goto jvQlO;
ymkVp: $this->db->where("id_jadwal", $id_jadwal);
goto fL8ph;
YVPFq: $this->db->where("id_sesi", $sesi);
goto SjuQg;
fL8ph: if (!($sesi != null)) { goto zjZIs;
} goto YVPFq;
PSlus: if (!($ruang != null)) { goto Cankt;
} goto y2X8j;
QHeY4: Cankt: goto boq4u;
y2X8j: $this->db->where("id_ruang", $ruang);
goto QHeY4;
g2Brm: $this->db->select("id_pengawas, id_guru");
goto b9tuP;
SjuQg: zjZIs: goto PSlus;
B4RQG: }
public function getAllPengawas($tp, $smt, $ruang = null, $sesi = null) { goto XF7ZU;
B42Ej: $result = $this->db->get()->result();
goto QtB4W;
ejtz3: foreach ($result as $key => $row) { $ret[$row->id_jadwal][$row->id_ruang][$row->id_sesi] = $row;
snSf8: } goto HP2Yr;
ianzc: mjdUZ: goto MDPwk;
iMTeb: $this->db->from("cbt_pengawas");
goto zgAVQ;
MDPwk: return $ret;
goto Y4Xw4;
xfDj0: qBdVz: goto cVLB3;
wy6su: if (!($ruang != null)) { goto qBdVz;
} goto M7LZW;
iavgo: $this->db->where("id_smt", $smt);
goto wy6su;
XF7ZU: $this->db->select("id_pengawas, id_jadwal, id_ruang, id_sesi, id_guru");
goto iMTeb;
N_UP6: $this->db->where("id_sesi", $sesi);
goto JSsSO;
H7Sw0: if (!$result) { goto mjdUZ;
} goto ejtz3;
M7LZW: $this->db->where("id_ruang", $ruang);
goto xfDj0;
zgAVQ: $this->db->where("id_tp", $tp);
goto iavgo;
HP2Yr: QV9bP: goto ianzc;
cVLB3: if (!($sesi != null)) { goto Iekbf;
} goto N_UP6;
JSsSO: Iekbf: goto B42Ej;
QtB4W: $ret = [];
goto H7Sw0;
Y4Xw4: }
public function getDistinctRuang($tp, $smt, $arrKelas) { goto zvMRn;
mn9Rj: $this->db->select("a.ruang_id, a.sesi_id, b.kode_ruang, b.nama_ruang, c.kode_sesi, c.nama_sesi");
goto H2exr;
guQUw: $this->db->where_in("kelas_id", $arrKelas);
goto ggCoh;
BxhTV: $this->db->join("cbt_sesi c", "c.id_sesi=a.sesi_id");
goto EmHWd;
Piulw: $ret = [];
goto Xb6Mi;
wqSq1: EsSDZ: goto p2Qvc;
LcjeZ: foreach ($result as $key => $row) { $ret[$row->ruang_id][$row->sesi_id] = $row;
BtisS: } goto wqSq1;
DM20D: $this->db->order_by("c.nama_sesi", "ASC");
goto ztzvH;
H2exr: $this->db->from("cbt_sesi_siswa a");
goto xOBwN;
zvMRn: $this->db->distinct("a.ruang_id");
goto mn9Rj;
p2Qvc: I424D: goto Y5g_K;
ggCoh: FpeLt: goto Bh_4l;
ztzvH: $result = $this->db->get()->result();
goto Piulw;
xOBwN: $this->db->join("cbt_ruang b", "b.id_ruang=a.ruang_id");
goto BxhTV;
Bh_4l: $this->db->order_by("b.nama_ruang", "ASC");
goto DM20D;
Y5g_K: return $ret;
goto t3oEF;
Xb6Mi: if (!$result) { goto I424D;
} goto LcjeZ;
EmHWd: if (!(count($arrKelas) > 0)) { goto FpeLt;
} goto guQUw;
t3oEF: }
public function getKelasUjian($kelas_id) { goto itaEx;
Edlse: rRwDS: goto TJeFo;
EUO0y: if (!$result) { goto uOSX5;
} goto PmFot;
itaEx: $this->db->select("kelas_id, ruang_id, sesi_id");
goto Ai8VN;
TXjqY: $ret = [];
goto EUO0y;
Zqwg6: $result = $this->db->get()->result();
goto TXjqY;
Ai8VN: $this->db->from("cbt_sesi_siswa");
goto AzWOU;
PmFot: foreach ($result as $key => $row) { $ret[$row->ruang_id][$row->sesi_id][] = $row->kelas_id;
LseSV: } goto Edlse;
AzWOU: $this->db->where("kelas_id", $kelas_id);
goto Zqwg6;
dIRQH: return $ret;
goto oCMRv;
TJeFo: uOSX5: goto dIRQH;
oCMRv: }
public function getDistinctKelasLevel($tp, $smt, $arrLevel) { goto LxXru;
ezh5H: $this->db->from("master_kelas");
goto QFffS;
QFffS: $this->db->where("id_tp", $tp);
goto rZuTR;
lZkD0: return $result;
goto vHQmP;
nYFSu: $result = $this->db->get()->result();
goto lZkD0;
LxXru: $this->db->select("id_kelas, level_id");
goto tVKyJ;
tVKyJ: $this->db->distinct();
goto ezh5H;
rZuTR: $this->db->where("id_smt", $smt);
goto QcnJA;
QcnJA: $this->db->where_in("level_id", $arrLevel);
goto nYFSu;
vHQmP: }
public function getAllJenisUjian() { goto VduaV;
VduaV: $result = $this->db->get("cbt_jenis")->result();
goto sOFlQ;
lzC11: if (!$result) { goto H2Jl1;
} goto H80Ew;
sOFlQ: $ret[''] = "Jenis Penilaian :";
goto lzC11;
Vhc7R: return $ret;
goto yUjNL;
xNYFr: H2Jl1: goto Vhc7R;
R3RAq: XEEOe: goto xNYFr;
H80Ew: foreach ($result as $key => $row) { $ret[$row->id_jenis] = $row->kode_jenis;
oC7pX: } goto R3RAq;
yUjNL: }
public function getAllJenisUjianByArrJenis($arrJenis) { goto foLa5;
foLa5: $this->db->where_in("id_jenis", $arrJenis);
goto xUe2q;
TVB3b: return $ret;
goto L4h13;
aFKW6: $ret[''] = "Jenis Penilaian :";
goto x3l5A;
xUe2q: $result = $this->db->get("cbt_jenis")->result();
goto aFKW6;
x3l5A: if (!$result) { goto HJNen;
} goto AKkez;
lmoUU: HJNen: goto TVB3b;
Dn2lc: umaWf: goto lmoUU;
AKkez: foreach ($result as $key => $row) { $ret[$row->id_jenis] = $row->kode_jenis;
MXqra: } goto Dn2lc;
L4h13: }
public function getPengawasHariIni($tgl) { goto CsHVA;
stE6v: return $this->db->get()->result();
goto iZN5H;
XdiTN: $this->db->join("cbt_pengawas b", "b.id_jadwal=a.id_jadwal");
goto Nd7o2;
hMIlV: $this->db->where("a.tgl_mulai <= '{$tgl}' AND a.tgl_selesai >= '{$tgl}'");
goto XdiTN;
CsHVA: $this->db->from("cbt_jadwal a");
goto hMIlV;
Nd7o2: $this->db->where("status", "1");
goto stE6v;
iZN5H: }
public function getJadwalGuru($tp, $smt, $guru) { goto ns4ad;
hGXp3: $this->db->where("a.id_smt", $smt);
goto J11WJ;
ns4ad: $this->db->select("a.id_jadwal, a.tgl_mulai, b.bank_kode, b.bank_kelas");
goto KGVH7;
KGVH7: $this->db->from("cbt_jadwal a");
goto nz829;
J11WJ: return $this->db->get()->result();
goto ZYPTa;
iS5m6: $this->db->where("a.id_tp", $tp);
goto hGXp3;
nz829: $this->db->join("cbt_bank_soal b", "b.id_bank=a.id_bank AND b.bank_guru_id=" . $guru);
goto iS5m6;
ZYPTa: }
public function getJadwalKelas($tp, $smt) { goto YjShu;
dpnxs: $this->db->from("cbt_jadwal a");
goto kLxFc;
KzuO8: $this->db->where("a.id_tp", $tp);
goto Rp6Ki;
YjShu: $this->db->select("a.id_jadwal, a.tgl_mulai, b.bank_kode, b.bank_kelas");
goto dpnxs;
dtQgz: return $this->db->get()->result();
goto o16rk;
Rp6Ki: $this->db->where("a.id_smt", $smt);
goto dtQgz;
kLxFc: $this->db->join("cbt_bank_soal b", "b.id_bank=a.id_bank");
goto KzuO8;
o16rk: }
public function getJadwalByJenis($jenis, $level, $dari, $sampai) { goto rRing;
t1PpD: $this->db->order_by("a.jam_ke", "ASC");
goto EBvmU;
rRing: $this->db->select("a.id_jadwal, a.id_bank, a.id_jenis, a.tgl_mulai, a.tgl_selesai, a.jam_ke," . " c.bank_kode, c.bank_level, c.bank_kelas, b.kode_jenis, b.nama_jenis, d.kode, d.nama_mapel");
goto Yvu8r;
U0XXc: $this->db->where("a.tgl_mulai <=", $sampai);
goto eySq8;
eySq8: x9vJE: goto CCcBf;
CLkCc: $this->db->where("a.tgl_mulai >=", $dari);
goto D37TD;
cjLVp: FxcJ6: goto HmEg5;
CCcBf: $this->db->order_by("a.tgl_mulai", "ASC");
goto t1PpD;
oIh_t: return $result;
goto HHC8D;
gt8gN: if (!($sampai != null)) { goto x9vJE;
} goto U0XXc;
Y0wXJ: $this->db->join("master_mapel d", "d.id_mapel=c.bank_mapel_id");
goto DxnKA;
Ktevq: $this->db->join("cbt_jenis b", "b.id_jenis=a.id_jenis");
goto RPyW6;
pptKH: $this->db->where("c.bank_level", $level);
goto cjLVp;
EBvmU: $result = $this->db->get()->result();
goto oIh_t;
HmEg5: if (!($dari != null)) { goto ZMGCA;
} goto CLkCc;
R7Rag: if (!($level != "0")) { goto FxcJ6;
} goto pptKH;
DxnKA: $this->db->where("a.id_jenis", $jenis);
goto R7Rag;
RPyW6: $this->db->join("cbt_bank_soal c", "c.id_bank=a.id_bank");
goto Y0wXJ;
Yvu8r: $this->db->from("cbt_jadwal a");
goto Ktevq;
D37TD: ZMGCA: goto gt8gN;
HHC8D: }
public function getAllJadwalByJenis($jenis, $tp, $smt) { goto cZFor;
SmwyJ: xGqpz: goto CM_Gl;
MpxtV: $this->db->where("a.id_smt", $smt);
goto J0umV;
xAwkz: $this->db->order_by("a.jam_ke", "ASC");
goto qQ2zf;
qQ2zf: $this->db->order_by("c.bank_level", "ASC");
goto pbDOW;
z9GOm: $this->db->from("cbt_jadwal a");
goto WUThf;
WJP9D: $ret = [];
goto P8bO_;
juo2x: foreach ($result as $key => $row) { $ret[$row->tgl_mulai][$row->id_mapel][] = $row;
TkChQ: } goto E8tLl;
UEgnx: s6sLz: goto KLxU_;
pbDOW: $result = $this->db->get()->result();
goto WJP9D;
cZFor: $this->db->select("a.id_jadwal, a.id_jenis, a.tgl_mulai, " . "c.bank_kode, c.bank_level, c.bank_kelas, b.kode_jenis, b.nama_jenis, d.id_mapel, d.kode, d.nama_mapel");
goto z9GOm;
QCXKJ: $this->db->where("a.id_jenis", $jenis);
goto SmwyJ;
WUThf: $this->db->join("cbt_jenis b", "b.id_jenis=a.id_jenis");
goto C43Of;
CM_Gl: $this->db->where("a.id_tp", $tp);
goto MpxtV;
C43Of: $this->db->join("cbt_bank_soal c", "c.id_bank=a.id_bank");
goto oOtpJ;
E8tLl: Jw141: goto UEgnx;
oOtpJ: $this->db->join("master_mapel d", "d.id_mapel=c.bank_mapel_id");
goto oILmf;
oILmf: if (!($jenis != null)) { goto xGqpz;
} goto QCXKJ;
KLxU_: return $ret;
goto Me1Xb;
P8bO_: if (!$result) { goto s6sLz;
} goto juo2x;
J0umV: $this->db->order_by("a.tgl_mulai", "ASC");
goto xAwkz;
Me1Xb: }
public function getAllBankSoal($guru = null) { goto dWmm2;
fb8MQ: if (!$result) { goto DyXAu;
} goto Y21Wo;
Ih7ZG: d7yPE: goto QbANU;
Hgd3N: y7HoG: goto esPJ2;
dWmm2: $this->db->select("id_bank, bank_kode");
goto Yoab5;
Y21Wo: foreach ($result as $key => $row) { $ret[$row->id_bank] = $row->bank_kode;
h32We: } goto Hgd3N;
Yoab5: if (!($guru !== null)) { goto d7yPE;
} goto K5X30;
QbANU: $result = $this->db->get("cbt_bank_soal")->result();
goto GUyFb;
K5X30: $this->db->where("bank_guru_id", $guru);
goto Ih7ZG;
GUyFb: $ret["0"] = "Pilih Bank Soal :";
goto fb8MQ;
esPJ2: DyXAu: goto Ss7Rb;
Ss7Rb: return $ret;
goto SNbB3;
SNbB3: }
public function getAllBankSoalByTp($id_tp, $id_smt, $guru = null) { goto OVAJB;
onqJt: $this->db->where("bank_guru_id", $guru);
goto TxbXv;
RZ8TN: $result = $this->db->get("cbt_bank_soal")->result();
goto q_2jk;
TQhQX: return $ret;
goto fjVZU;
q_2jk: $ret = [];
goto CN0Tx;
OVAJB: $this->db->select("id_bank, bank_kode, bank_mapel_id, tampil_pg, tampil_kompleks, tampil_jodohkan, tampil_isian, tampil_esai");
goto VLJEA;
H2YyY: foreach ($result as $key => $row) { $ret[$row->id_bank] = $row;
sZwLi: } goto XMR_x;
AurCu: $this->db->where("status_soal", "1");
goto E1Z2C;
TxbXv: TXsr3: goto RZ8TN;
VLJEA: $this->db->where("id_tp", $id_tp);
goto U0_iU;
CN0Tx: if (!$result) { goto W2Rl2;
} goto H2YyY;
E1Z2C: if (!($guru !== null)) { goto TXsr3;
} goto onqJt;
Di72a: $this->db->where("status", "1");
goto AurCu;
g3R7b: W2Rl2: goto TQhQX;
XMR_x: HohLb: goto g3R7b;
U0_iU: $this->db->where("id_smt", $id_smt);
goto Di72a;
fjVZU: }
public function getAllBankSoalByMapel($id_tp, $id_smt, $mapel) { goto lVyIC;
WcDSv: $ret = [];
goto d94GT;
VxpML: $this->db->where("status", "1");
goto X1FnO;
vMVAX: $this->db->from("cbt_bank_soal");
goto uDGjT;
ZxV32: foreach ($result as $key => $row) { $ret[$row->id_bank] = $row;
zNEAK: } goto xzpY5;
X1FnO: $result = $this->db->get()->result();
goto WcDSv;
TdggA: return $ret;
goto hKpHC;
zymlI: $this->db->where("bank_mapel_id", $mapel);
goto VxpML;
d94GT: if (!$result) { goto ui_tk;
} goto ZxV32;
PJWrp: $this->db->where("id_smt", $id_smt);
goto zymlI;
disyy: ui_tk: goto TdggA;
uDGjT: $this->db->where("id_tp", $id_tp);
goto PJWrp;
lVyIC: $this->db->select("id_bank, bank_kode, bank_mapel_id, tampil_pg, tampil_kompleks, tampil_jodohkan, tampil_isian, tampil_esai, status");
goto vMVAX;
xzpY5: YPmoW: goto disyy;
hKpHC: }
public function getJumlahJenisSoal($id_bank) { goto CRZdr;
oxZu8: foreach ($result as $row) { $ret[$row->jenis][] = $row;
HAo8r: } goto fb4KG;
b_s3t: $this->db->where("tampilkan", "1");
goto e1MfD;
TXpGv: $this->db->where("bank_id", $id_bank);
goto b_s3t;
PVZwO: if (!$result) { goto Wrufm;
} goto oxZu8;
fb4KG: Fmd1p: goto nmuc_;
zIKF4: return $ret;
goto cXB5U;
nmuc_: Wrufm: goto zIKF4;
BYgVk: $this->db->from("cbt_soal");
goto TXpGv;
BpfEI: $ret = [];
goto PVZwO;
CRZdr: $this->db->select("id_soal, jenis");
goto BYgVk;
e1MfD: $result = $this->db->get()->result();
goto BpfEI;
cXB5U: }
public function getJenis() { goto dduyU;
ftHi8: return $this->datatables->generate();
goto LWfxF;
dduyU: $this->datatables->select("*");
goto HFSW1;
HFSW1: $this->datatables->from("cbt_jenis");
goto ftHi8;
LWfxF: }
public function getJenisById($id) { goto gGrlY;
YZWAA: $this->db->from("cbt_jenis");
goto RzXMt;
gGrlY: $this->db->select("id_jenis, nama_jenis, kode_jenis");
goto YZWAA;
sHz7D: return $this->db->get()->row();
goto Pzggx;
RzXMt: $this->db->where(["id_jenis" => $id]);
goto sHz7D;
Pzggx: } function updateJenis() { goto JCGkU;
NxXxU: $name = $this->input->post("nama_jenis", true);
goto uCtzI;
zDQcS: $this->db->set("nama_jenis", $name);
goto CyOrN;
CyOrN: $this->db->set("kode_jenis", $kode);
goto REOun;
uCtzI: $kode = $this->input->post("kode_jenis", true);
goto zDQcS;
JCGkU: $id = $this->input->post("id_jenis");
goto NxXxU;
pWOm7: return $this->db->update("cbt_jenis");
goto vqciL;
REOun: $this->db->where("id_jenis", $id);
goto pWOm7;
vqciL: }
public function getRuang() { goto D7wr3;
R3wAJ: $this->datatables->from("cbt_ruang");
goto vv02u;
vv02u: return $this->datatables->generate();
goto OllQL;
D7wr3: $this->datatables->select("*, (SELECT COUNT(id_sesi) FROM cbt_sesi) AS jum_sesi");
goto R3wAJ;
OllQL: }
public function getRuangById($id) { goto J8gpR;
EtcCD: $this->db->from("cbt_ruang");
goto DAvpr;
DAvpr: $this->db->where(["id_ruang" => $id]);
goto w9EoC;
w9EoC: return $this->db->get()->row();
goto tT3Ll;
J8gpR: $this->db->select("id_ruang, nama_ruang, kode_ruang");
goto EtcCD;
tT3Ll: }
public function getRuangSesi($tp, $smt) { goto uRhB4;
Lg8ky: L6HlQ: goto P_nzR;
w1lWs: foreach ($result as $row) { $ret[$row->sesi_id][$row->ruang_id][$row->kelas_id] = $row->nama_kelas;
iyuja: } goto QUbCh;
KiAsd: $this->db->join("cbt_ruang b", "b.id_ruang=a.ruang_id");
goto OGOXm;
vAv7Y: if (!$result) { goto L6HlQ;
} goto w1lWs;
OGOXm: $this->db->join("cbt_sesi c", "c.id_sesi=a.sesi_id");
goto VTp9E;
uRhB4: $this->db->select("a.siswa_id, a.sesi_id, a.ruang_id, a.kelas_id, " . "b.nama_ruang, b.kode_ruang, c.nama_sesi, c.kode_sesi, d.nama_kelas");
goto mS2z3;
QUbCh: RJLdV: goto Lg8ky;
P_nzR: return $ret;
goto dVZki;
aP7Hg: $ret = [];
goto vAv7Y;
VTp9E: $this->db->join("master_kelas d", "d.id_kelas=a.kelas_id");
goto GGKD3;
mS2z3: $this->db->from("cbt_sesi_siswa a");
goto KiAsd;
Jff1o: $result = $this->db->get()->result();
goto aP7Hg;
GGKD3: $this->db->order_by("b.nama_ruang", "ASC");
goto siydQ;
siydQ: $this->db->order_by("c.nama_sesi", "ASC");
goto Jff1o;
dVZki: } function updateRuang() { goto Gbgl2;
aiSVX: $name = $this->input->post("nama_ruang", true);
goto M2wG8;
Gbgl2: $id = $this->input->post("id_ruang");
goto aiSVX;
ieOEb: $this->db->where("id_ruang", $id);
goto LA2fl;
LA2fl: return $this->db->update("cbt_ruang");
goto KynpV;
Y3nVj: $this->db->set("nama_ruang", $name);
goto Z_Lt_;
M2wG8: $kode = $this->input->post("kode_ruang", true);
goto Y3nVj;
Z_Lt_: $this->db->set("kode_ruang", $kode);
goto ieOEb;
KynpV: }
public function getSesi() { goto cZjIb;
cZjIb: $this->datatables->select("*");
goto qIt5P;
QD_1n: return $this->datatables->generate();
goto ZK4Zp;
qIt5P: $this->datatables->from("cbt_sesi c");
goto QD_1n;
ZK4Zp: }
public function getAllKodeSesi() { goto V7B0V;
gI6X9: $this->db->from("cbt_sesi");
goto AEJe1;
hOITb: if (!$result) { goto W6Jhn;
} goto Mx6yY;
V7B0V: $this->db->select("id_sesi, nama_sesi, kode_sesi");
goto gI6X9;
kA9av: return $ret;
goto fp1A2;
Mx6yY: foreach ($result as $row) { $ret[$row->kode_sesi] = $row;
AqXso: } goto Zi2Db;
K7E94: $ret = [];
goto hOITb;
Zi2Db: XOZbA: goto kjnJH;
AEJe1: $result = $this->db->get()->result();
goto K7E94;
kjnJH: W6Jhn: goto kA9av;
fp1A2: }
public function getSesiById($id) { goto vcn5L;
fAM_9: $this->db->where(["id_sesi" => $id]);
goto h38sP;
gd8XJ: $this->db->from("cbt_sesi");
goto fAM_9;
h38sP: return $this->db->get()->row();
goto SwLyy;
vcn5L: $this->db->select("id_sesi, nama_sesi, kode_sesi, waktu_mulai, waktu_akhir");
goto gd8XJ;
SwLyy: }
public function getSesiBySiswa($siswa_id) { goto KFEBA;
gZMN9: return $query;
goto vRfHq;
KFEBA: $this->db->where("siswa_id", $siswa_id);
goto bPHkG;
bPHkG: $query = $this->db->get("siswa_sesi")->result();
goto gZMN9;
vRfHq: } function updateSesi() { goto pmG0M;
ZDLEj: $mulai = $this->input->post("waktu_mulai", true);
goto Qbj22;
o9MfN: $this->db->set("waktu_mulai", $mulai);
goto usAHz;
beHDi: $name = $this->input->post("nama_sesi", true);
goto GZPnY;
Ct_g1: $this->db->where("id_sesi", $id);
goto NrSSz;
WXe5K: $this->db->set("nama_sesi", $name);
goto VlRNP;
VlRNP: $this->db->set("kode_sesi", $kode);
goto o9MfN;
NrSSz: return $this->db->update("cbt_sesi");
goto GHyHA;
pmG0M: $id = $this->input->post("id_sesi");
goto beHDi;
Qbj22: $akhir = $this->input->post("waktu_akhir", true);
goto WXe5K;
DDjS4: $this->db->set("aktif", 1);
goto Ct_g1;
usAHz: $this->db->set("waktu_akhir", $akhir);
goto DDjS4;
GZPnY: $kode = $this->input->post("kode_sesi", true);
goto ZDLEj;
GHyHA: }
public function getSiswaCbtInfo($id_siswa, $id_tp, $id_smt) { goto QysmJ;
pkNRT: $this->db->from("kelas_siswa a");
goto sPtwl;
qftQ2: $this->db->where("a.id_tp", $id_tp);
goto eNdN2;
QysmJ: $this->db->select("a.id_kelas_siswa, a.id_tp, a.id_smt, a.id_siswa, a.id_kelas," . " b.siswa_id, b.kelas_id, b.ruang_id, b.sesi_id," . " rk.id_ruang, rk.nama_ruang, rk.kode_ruang," . " sk.id_sesi, sk.nama_sesi, sk.kode_sesi, sk.waktu_mulai, sk.waktu_akhir");
goto pkNRT;
eNdN2: $this->db->where("a.id_smt", $id_smt);
goto qW4T1;
i73T4: $this->db->join("cbt_sesi sk", "b.sesi_id=sk.id_sesi", "left");
goto ACroI;
ACroI: $this->db->where("a.id_siswa", $id_siswa);
goto qftQ2;
sPtwl: $this->db->join("cbt_sesi_siswa b", "a.id_siswa=b.siswa_id", "left");
goto Ema50;
qW4T1: return $this->db->get()->row();
goto JJTE4;
Ema50: $this->db->join("cbt_ruang rk", "b.ruang_id=rk.id_ruang", "left");
goto i73T4;
JJTE4: }
public function getRuangSesiSiswa($id_kelas, $id_tp, $id_smt) { goto e3cGi;
Y3XpH: $this->db->where("a.id_kelas", $id_kelas);
goto DLSo1;
uT27c: $this->db->order_by("b.nama", "ASC");
goto g3St1;
JI8su: $this->db->join("cbt_ruang rk", "e.ruang_id=rk.id_ruang", "left");
goto BS8eC;
DLSo1: $this->db->where("a.id_tp", $id_tp);
goto iV0Dl;
iV0Dl: $this->db->where("a.id_smt", $id_smt);
goto uT27c;
g3St1: return $this->db->get()->result();
goto QAeOh;
qzjdP: $this->db->join("buku_induk i", "i.id_siswa=a.id_siswa AND =i.status=1");
goto Y3XpH;
FYHZo: $this->db->join("master_kelas c", "a.id_kelas=c.id_kelas", "left");
goto ol0AY;
BS8eC: $this->db->join("cbt_sesi sk", "e.sesi_id=sk.id_sesi", "left");
goto qzjdP;
gEoUa: $this->db->join("master_siswa b", "a.id_siswa=b.id_siswa", "left");
goto FYHZo;
e3cGi: $this->db->select("a.id_siswa, a.id_kelas," . " b.nama, b.nis, b.username," . " c.nama_kelas, c.kode_kelas," . " e.sesi_id, e.ruang_id," . " rk.id_ruang, rk.kode_ruang," . " sk.id_sesi, sk.kode_sesi");
goto zOtbF;
zOtbF: $this->db->from("kelas_siswa a");
goto gEoUa;
ol0AY: $this->db->join("cbt_sesi_siswa e", "a.id_siswa=e.siswa_id", "left");
goto JI8su;
QAeOh: }
public function getSiswaByKelas($id_tp, $id_smt, $id_kelas) { goto hKOhP;
tmQP1: Iqlvs: goto XmnUh;
qmQWn: $this->db->order_by("b.nama", "ASC");
goto X3LRF;
UXt8h: $this->db->where("c.siswa_id is NOT NULL", NULL, FALSE);
goto Crbjo;
Tp6ro: $this->db->where("g.id_siswa is NOT NULL", NULL, FALSE);
goto ipOfs;
UWzmO: $this->db->where("a.id_smt", $id_smt);
goto pDGjK;
lUKV6: $this->db->join("cbt_ruang d", "d.id_ruang=c.ruang_id", "left");
goto I8AsZ;
I8AsZ: $this->db->join("cbt_sesi e", "e.id_sesi=c.sesi_id", "left");
goto qANTE;
qANTE: $this->db->join("master_kelas f", "f.id_kelas=a.id_kelas", "left");
goto BYIHX;
BYIHX: $this->db->join("cbt_nomor_peserta g", "g.id_siswa=a.id_siswa AND g.id_tp=" . $id_tp, "left");
goto d5q62;
hKOhP: $this->db->select("b.id_siswa, b.nama, b.nis, b.nisn, b.username, b.password," . " b.foto, d.kode_ruang, e.kode_sesi, f.nama_kelas, f.kode_kelas, g.nomor_peserta");
goto dlHq7;
pAs3K: goto jRPIc;
goto tmQP1;
oTzD5: $this->db->where("a.id_tp", $id_tp);
goto UWzmO;
QzoRs: $this->db->where("b.id_siswa is NOT NULL", NULL, FALSE);
goto UXt8h;
GLBP4: $this->db->join("master_siswa b", "b.id_siswa=a.id_siswa", "left");
goto lnx7F;
Crbjo: $this->db->where("f.siswa_id is NOT NULL", NULL, FALSE);
goto Tp6ro;
lnx7F: $this->db->join("cbt_sesi_siswa c", "c.siswa_id=a.id_siswa", "left");
goto lUKV6;
X3LRF: return $this->db->get()->result();
goto R624z;
dlHq7: $this->db->from("kelas_siswa a");
goto GLBP4;
pDGjK: $this->db->where("a.id_siswa is NOT NULL", NULL, FALSE);
goto QzoRs;
d5q62: $this->db->join("buku_induk i", "i.id_siswa=a.id_siswa AND =i.status=1");
goto oTzD5;
epyWh: $this->db->where("a.id_kelas", $id_kelas);
goto pAs3K;
XmnUh: $this->db->where_in("a.id_kelas", $id_kelas);
goto nCqKH;
ipOfs: if (is_array($id_kelas)) { goto Iqlvs;
} goto epyWh;
nCqKH: jRPIc: goto qmQWn;
R624z: }
public function getSiswaById($id_tp, $id_smt, $idSiswa) { goto KNGtk;
TlZL8: $this->db->join("cbt_sesi j", "j.id_sesi=h.id_sesi", "left");
goto QiavQ;
QiavQ: $this->db->where("a.id_tp", $id_tp);
goto TXzXn;
ixCqI: $this->db->join("cbt_sesi e", "e.id_sesi=c.sesi_id", "left");
goto nz0Xm;
hRt5J: $this->db->from("kelas_siswa a");
goto br4gr;
TXzXn: $this->db->where("a.id_smt", $id_smt);
goto fhNb1;
fhNb1: $this->db->where("a.id_siswa", $idSiswa);
goto mJkix;
RxxB0: $this->db->join("cbt_ruang i", "i.id_ruang=h.id_ruang", "left");
goto TlZL8;
peYU3: $this->db->join("cbt_kelas_ruang h", "h.id_kelas=a.id_kelas", "left");
goto RxxB0;
KNGtk: $this->db->select("b.id_siswa, b.nama, b.nis, b.nisn, b.username, b.password," . " b.foto, d.kode_ruang, e.kode_sesi, f.nama_kelas, f.kode_kelas, g.nomor_peserta," . " h.set_siswa, i.kode_ruang as ruang_kelas, j.kode_sesi as sesi_kelas");
goto hRt5J;
b6Z78: $this->db->join("cbt_nomor_peserta g", "g.id_siswa=a.id_siswa AND g.id_tp=" . $id_tp, "left");
goto peYU3;
lyMPC: $this->db->join("cbt_sesi_siswa c", "c.siswa_id=a.id_siswa", "left");
goto gsML9;
mJkix: return $this->db->get()->row();
goto Vpmyb;
br4gr: $this->db->join("master_siswa b", "b.id_siswa=a.id_siswa", "left");
goto lyMPC;
gsML9: $this->db->join("cbt_ruang d", "d.id_ruang=c.ruang_id", "left");
goto ixCqI;
nz0Xm: $this->db->join("master_kelas f", "f.id_kelas=a.id_kelas", "left");
goto b6Z78;
Vpmyb: }
public function getAllPesertaByRuang($id_tp, $id_smt) { goto nw1Hl;
o18j_: $this->db->join("buku_induk i", "i.id_siswa=b.id_siswa AND =i.status=1");
goto meKfD;
uSWNc: $this->db->join("cbt_nomor_peserta g", "g.id_siswa=a.siswa_id AND g.id_tp=" . $id_tp, "left");
goto laB1Q;
QTl1g: $this->db->join("master_kelas f", "f.id_kelas=c.id_kelas");
goto o18j_;
JPpyj: return $ret;
goto F2_sU;
HSh5T: $this->db->from("cbt_sesi_siswa a");
goto qh6Mg;
JtdWJ: $this->db->order_by("e.kode_sesi");
goto mFXkm;
forik: $this->db->join("kelas_siswa c", "c.id_siswa=b.id_siswa AND c.id_tp=" . $id_tp . " AND c.id_smt=" . $id_smt . '');
goto QTl1g;
D8Be4: foreach ($result as $row) { $ret[$row->kode_ruang][$row->kode_sesi][] = $row;
vqck7: } goto i1WF2;
lR2DX: $this->db->join("cbt_ruang d", "d.id_ruang=a.ruang_id", "left");
goto uSWNc;
toji7: $this->db->order_by("f.kode_kelas");
goto Rlk3O;
L_nT5: $ret = [];
goto D8Be4;
i1WF2: BrKlP: goto JPpyj;
XPxRX: $result = $this->db->get()->result();
goto L_nT5;
meKfD: $this->db->order_by("d.kode_ruang");
goto JtdWJ;
Rlk3O: $this->db->order_by("b.nama");
goto XPxRX;
mFXkm: $this->db->order_by("f.level_id");
goto toji7;
qh6Mg: $this->db->join("master_siswa b", "b.id_siswa=a.siswa_id", "left");
goto lR2DX;
laB1Q: $this->db->join("cbt_sesi e", "e.id_sesi=a.sesi_id", "left");
goto forik;
nw1Hl: $this->db->select("b.id_siswa, b.nama, b.nis, b.nisn, b.username, b.password, b.foto, f.level_id," . " f.nama_kelas, f.kode_kelas," . " d.nama_ruang, d.kode_ruang," . " e.kode_sesi, e.nama_sesi," . " g.nomor_peserta");
goto HSh5T;
F2_sU: }
public function getAllPesertaByKelas($id_tp, $id_smt) { goto bJfQi;
uNDjR: $this->db->join("cbt_ruang d", "d.id_ruang=a.ruang_id", "left");
goto uHFbB;
c5L0g: $this->db->join("master_siswa b", "b.id_siswa=a.siswa_id", "left");
goto uNDjR;
nlgR9: $this->db->join("buku_induk i", "i.id_siswa=b.id_siswa AND =i.status=1");
goto NuljV;
UDVnw: $this->db->join("kelas_siswa c", "c.id_siswa=b.id_siswa AND c.id_tp=" . $id_tp . " AND c.id_smt=" . $id_smt . '');
goto Z7F1G;
bJfQi: $this->db->select("b.id_siswa, b.nama, b.nis, b.nisn, b.username, b.password, b.foto," . " f.nama_kelas, f.kode_kelas," . " d.nama_ruang, d.kode_ruang," . " e.kode_sesi, e.nama_sesi," . " g.nomor_peserta");
goto ABwOn;
UZRkC: $this->db->join("cbt_sesi e", "e.id_sesi=a.sesi_id", "left");
goto UDVnw;
DA9sr: $this->db->order_by("b.nama");
goto J2vcL;
xJYZx: return $ret;
goto E5Xki;
koB_W: p14xN: goto xJYZx;
ABwOn: $this->db->from("cbt_sesi_siswa a");
goto c5L0g;
J2vcL: $result = $this->db->get()->result();
goto sZ0A0;
Z7F1G: $this->db->join("master_kelas f", "f.id_kelas=c.id_kelas");
goto nlgR9;
h_0Jw: $this->db->order_by("f.kode_kelas");
goto DA9sr;
sZ0A0: $ret = [];
goto d9k_m;
d9k_m: foreach ($result as $row) { $ret[$row->kode_kelas][] = $row;
CvFJf: } goto koB_W;
NuljV: $this->db->order_by("f.level_id");
goto h_0Jw;
uHFbB: $this->db->join("cbt_nomor_peserta g", "g.id_siswa=a.siswa_id AND g.id_tp=" . $id_tp, "left");
goto UZRkC;
E5Xki: }
public function getSiswaByRuang($id_tp, $id_smt, $id_ruang, $sesi) { goto xKzzL;
pXDFz: $this->db->order_by("b.nama");
goto Ezoqi;
dNloh: $this->db->join("master_siswa b", "b.id_siswa=a.siswa_id", "left");
goto Tg4yK;
CbKfm: $this->db->where("a.sesi_id", $sesi);
goto pXDFz;
lI5Yx: $this->db->join("kelas_siswa c", "c.id_siswa=b.id_siswa AND c.id_tp=" . $id_tp . " AND c.id_smt=" . $id_smt . '');
goto GTKa2;
l81yl: $this->db->join("cbt_sesi e", "e.id_sesi=a.sesi_id", "left");
goto lI5Yx;
xKzzL: $this->db->select("a.ruang_id, a.sesi_id, b.id_siswa, b.nama, b.nis, b.nisn, b.username, b.password, b.foto," . " f.id_kelas, f.nama_kelas, f.kode_kelas," . " d.nama_ruang, d.kode_ruang," . " e.kode_sesi, e.nama_sesi," . " g.nomor_peserta");
goto kdybN;
Ezoqi: return $this->db->get()->result();
goto MBE3N;
gwRoj: $this->db->join("cbt_nomor_peserta g", "g.id_siswa=a.siswa_id AND g.id_tp=" . $id_tp, "left");
goto l81yl;
Tg4yK: $this->db->join("cbt_ruang d", "d.id_ruang=a.ruang_id", "left");
goto gwRoj;
j4B7S: $this->db->join("buku_induk i", "i.id_siswa=b.id_siswa AND =i.status=1");
goto hIVgq;
kdybN: $this->db->from("cbt_sesi_siswa a");
goto dNloh;
hIVgq: $this->db->where("a.ruang_id", $id_ruang);
goto CbKfm;
GTKa2: $this->db->join("master_kelas f", "f.id_kelas=c.id_kelas");
goto j4B7S;
MBE3N: }
public function getRuangSiswaByKelas($id_tp, $id_smt, $kelas, $sesi) { goto OafJm;
flZpl: $this->db->join("cbt_nomor_peserta g", "g.id_siswa=a.siswa_id AND g.id_tp=" . $id_tp, "left");
goto j9_IW;
RJ6bz: $this->db->from("cbt_sesi_siswa a");
goto h0Sn1;
d4mi_: $this->db->join("kelas_siswa c", "c.id_siswa=b.id_siswa AND c.id_tp=" . $id_tp . " AND c.id_smt=" . $id_smt . '');
goto eG3X7;
j9_IW: $this->db->join("cbt_sesi e", "e.id_sesi=a.sesi_id", "left");
goto d4mi_;
o3qRi: kXt6x: goto KfxzS;
h20TL: return $this->db->get()->result();
goto emQM4;
b7Xq0: $this->db->where_in("a.kelas_id", $kelas);
goto bqj1O;
OafJm: $this->db->select("b.id_siswa, b.nama, b.nis, b.nisn, b.username, b.password, b.foto," . " f.nama_kelas, f.kode_kelas," . " d.nama_ruang, d.kode_ruang," . " e.kode_sesi, e.nama_sesi," . " g.nomor_peserta");
goto RJ6bz;
WrZ3K: $this->db->where("a.sesi_id", $sesi);
goto o3qRi;
eG3X7: $this->db->join("master_kelas f", "f.id_kelas=c.id_kelas");
goto N7jaZ;
KfxzS: $this->db->order_by("b.nama");
goto h20TL;
UFo6e: $this->db->join("cbt_ruang d", "d.id_ruang=a.ruang_id", "left");
goto flZpl;
bqj1O: if (!($sesi != null)) { goto kXt6x;
} goto WrZ3K;
h0Sn1: $this->db->join("master_siswa b", "b.id_siswa=a.siswa_id", "left");
goto UFo6e;
N7jaZ: $this->db->join("buku_induk i", "i.id_siswa=b.id_siswa AND =i.status=1");
goto b7Xq0;
emQM4: }
public function getSiswaByKelasArray($id_tp, $id_smt, $arr_kelas) { goto iycdm;
r3eME: $this->db->join("master_kelas f", "f.id_kelas=a.id_kelas");
goto I_kbx;
XsnZv: $this->db->order_by("l.level", "ASC");
goto d838W;
N5hwO: xamTo: goto ORKGx;
I_kbx: $this->db->join("level_kelas l", "l.id_level=f.level_id");
goto KoDQ1;
ql0S7: $this->db->from("kelas_siswa a");
goto fX4_z;
QAnK_: $this->db->join("buku_induk i", "i.id_siswa=a.id_siswa AND =i.status=1");
goto Ru3bw;
y9h3H: $this->db->where("a.id_smt", $id_smt);
goto XsnZv;
S29rJ: return $this->db->get()->result();
goto hzWmx;
KoDQ1: $this->db->join("cbt_nomor_peserta g", "g.id_siswa=a.id_siswa AND g.id_tp=" . $id_tp, "left");
goto QAnK_;
fX4_z: $this->db->join("master_siswa b", "b.id_siswa=a.id_siswa");
goto r3eME;
ZBRGW: $this->db->where_in("a.id_kelas", $arr_kelas);
goto N5hwO;
d838W: $this->db->order_by("f.kode_kelas", "ASC");
goto HX2O7;
Ru3bw: if (in_array("Semua", $arr_kelas)) { goto xamTo;
} goto ZBRGW;
ORKGx: $this->db->where("a.id_tp", $id_tp);
goto y9h3H;
iycdm: $this->db->select("a.id_siswa," . " b.nama, b.nis, b.nisn, b.username, b.password," . " f.nama_kelas, f.kode_kelas, l.level, g.nomor_peserta");
goto ql0S7;
HX2O7: $this->db->order_by("b.nama", "ASC");
goto S29rJ;
hzWmx: }
public function getKelasList($tp, $smt) { goto ijAg2;
f6fsG: $this->db->join("master_jurusan c", "c.id_jurusan=a.jurusan_id", "left");
goto d0bZd;
EpFJS: $this->db->where("a.id_smt", $smt);
goto Oxj91;
NlTPt: $this->db->order_by("a.nama_kelas", "ASC");
goto EY75n;
st0of: $this->db->from("master_kelas a");
goto oDIpG;
EY75n: $query = $this->db->get();
goto kSC1O;
kSC1O: return $query->result();
goto B88yo;
ijAg2: $this->db->select("a.id_kelas, a.nama_kelas, a.kode_kelas, c.nama_jurusan, b.id_ruang, b.id_sesi, b.set_siswa");
goto st0of;
d0bZd: $this->db->join("level_kelas d", "d.id_level=a.level_id", "left");
goto WziPI;
WziPI: $this->db->where("a.id_tp", $tp);
goto EpFJS;
oDIpG: $this->db->join("cbt_kelas_ruang b", "a.id_kelas=b.id_kelas", "left");
goto f6fsG;
Oxj91: $this->db->order_by("a.level_id", "ASC");
goto NlTPt;
B88yo: }
public function getKelas($tp = null, $smt = null) { goto Bew5N;
Bew5N: $this->db->select("a.id_kelas, a.nama_kelas, a.kode_kelas, b.level");
goto qxAm5;
Ta5t6: $this->db->order_by("a.nama_kelas", "ASC");
goto MEoOl;
JT6wL: $this->db->where("a.id_tp", $tp);
goto MpMIh;
XvxZz: $this->db->join("level_kelas b", "b.id_level=a.level_id", "left");
goto sPWY1;
O_Eal: u0Csk: goto Ta5t6;
sPWY1: if (!($tp != null)) { goto k3lka;
} goto JT6wL;
Sw3c2: if (!($smt != null)) { goto u0Csk;
} goto zoL_X;
zoL_X: $this->db->where("a.id_smt", $smt);
goto O_Eal;
MEoOl: return $this->db->get()->result();
goto eOgLO;
MpMIh: k3lka: goto Sw3c2;
qxAm5: $this->db->from("master_kelas a");
goto XvxZz;
eOgLO: }
public function getDataTableBank($guru = null) { goto oD01t;
ta560: $this->datatables->join("master_jurusan d", "d.id_jurusan=a.bank_jurusan_id", "left");
goto OmSKR;
IDY1A: $this->datatables->from("cbt_bank_soal a");
goto rEMXA;
Wm18c: $this->datatables->join("master_guru c", "c.id_guru=a.bank_guru_id", "left");
goto ta560;
OmSKR: $this->datatables->join("cbt_jenis e", "e.id_jenis=a.bank_jenis_id", "left");
goto kafl_;
rEMXA: $this->datatables->join("master_mapel b", "b.id_mapel=a.bank_mapel_id", "left");
goto Wm18c;
oD01t: $this->datatables->select("a.id_bank, a.bank_kode, a.bank_level, a.tampil_pg, a.tampil_esai, a.status, b.nama_mapel, c.nama_guru");
goto IDY1A;
ePjlE: return $this->datatables->generate();
goto nOVCB;
kafl_: if (!($guru !== null)) { goto tRFo8;
} goto HJ0cC;
MdOCj: tRFo8: goto ePjlE;
HJ0cC: $this->datatables->where("a.bank_guru_id", $guru);
goto MdOCj;
nOVCB: }
public function getDataBank($guru = null, $mapel = null, $level = null) { goto CFVUx;
XEAE0: wyD65: goto ilU4X;
gkauX: $this->db->join("master_mapel b", "b.id_mapel=a.bank_mapel_id", "left");
goto nHgZ2;
ysqjo: if (!($mapel !== null)) { goto ReQkz;
} goto cqEk1;
NA32d: $this->db->where("a.bank_level", $level);
goto S22wu;
UtDp0: $result = $this->db->get()->result();
goto EHSZQ;
PL2jK: mUaw5: goto ysqjo;
wKPvo: $this->db->from("cbt_bank_soal a");
goto gkauX;
dYm1t: if (!($level !== null)) { goto Yw79N;
} goto NA32d;
ilU4X: return $ret;
goto YzhxQ;
CFVUx: $this->db->select("a.id_bank, a.id_tp, a.id_smt, a.bank_kode, a.bank_level, a.bank_kelas," . " a.tampil_pg, a.tampil_kompleks, a.tampil_jodohkan, a.tampil_isian, a.tampil_esai, a.bank_guru_id," . " b.nama_mapel, c.id_guru," . " (SELECT COUNT(id_soal) FROM cbt_soal WHERE cbt_soal.bank_id = a.id_bank) AS total_soal," . " (SELECT COUNT(id_jadwal) FROM cbt_jadwal WHERE cbt_jadwal.id_bank = a.id_bank AND cbt_jadwal.status="1") AS digunakan");
goto wKPvo;
G4Qmz: ReQkz: goto dYm1t;
Gdur7: if (!($guru !== null)) { goto mUaw5;
} goto fxEkw;
EHSZQ: $ret = [];
goto o9Nyd;
JSc8C: $this->db->order_by("a.bank_level", "ASC");
goto UtDp0;
o9Nyd: foreach ($result as $row) { $ret[$row->id_tp][$row->id_smt][] = $row;
ueRQx: } goto XEAE0;
nHgZ2: $this->db->join("master_guru c", "c.id_guru=a.bank_guru_id", "left");
goto Gdur7;
S22wu: Yw79N: goto JSc8C;
cqEk1: $this->db->where("a.bank_mapel_id", $mapel);
goto G4Qmz;
fxEkw: $this->db->where("a.bank_guru_id", $guru);
goto PL2jK;
YzhxQ: }
public function getDataBankById($id) { goto Mhwrl;
h5Fjc: $this->db->where("a.id_bank", $id);
goto jATBc;
jATBc: return $this->db->get()->row();
goto CGCx5;
xG8hR: $this->db->join("master_guru c", "c.id_guru=a.bank_guru_id", "left");
goto lONzf;
lONzf: $this->db->join("master_jurusan d", "d.id_jurusan=a.bank_jurusan_id", "left");
goto h5Fjc;
zQ8FR: $this->db->from("cbt_bank_soal a");
goto eAxEa;
Mhwrl: $this->db->select("a.*, b.nama_mapel, b.kode, c.nama_guru, d.nama_jurusan, d.kode_jurusan," . " (SELECT COUNT(id_jadwal) FROM cbt_jadwal WHERE cbt_jadwal.id_bank = a.id_bank AND cbt_jadwal.status="1") AS digunakan");
goto zQ8FR;
eAxEa: $this->db->join("master_mapel b", "b.id_mapel=a.bank_mapel_id", "left");
goto xG8hR;
CGCx5: }
public function getTotalSoal($id_bank, $jenis = null) { goto HEEKo;
Gs68q: return $this->db->get("cbt_soal")->num_rows();
goto duYqb;
HEEKo: $this->db->where("bank_id", $id_bank);
goto TeT7E;
jXrzN: $this->db->where("jenis", $jenis);
goto SHMhI;
TeT7E: if (!($jenis != null)) { goto oPuY6;
} goto jXrzN;
SHMhI: oPuY6: goto Gs68q;
duYqb: }
public function getNomorSoalById($id_soal) { goto kCEVx;
DjXPW: $this->db->where("id_soal", $id_soal);
goto iCXnk;
iCXnk: return $this->db->get("cbt_soal")->row();
goto kgHwX;
kCEVx: $this->db->select("nomor_soal, jenis, bank_id");
goto DjXPW;
kgHwX: }
public function getFileSoalById($id_soal) { goto qE8Ct;
CA02X: return $this->db->get("cbt_soal")->row();
goto IxVeW;
RVAC3: $this->db->where("id_soal", $id_soal);
goto CA02X;
qE8Ct: $this->db->select("file");
goto RVAC3;
IxVeW: }
public function getSoalByBank($id_bank) { goto tDIKt;
MOHHj: $this->db->order_by("nomor_soal");
goto pDrqt;
mK2Mv: $ret = [];
goto zZX_1;
h8Xvz: firKf: goto BvwEd;
m4rwu: $this->db->from("cbt_soal");
goto hQZU4;
zZX_1: foreach ($result as $row) { $ret[$row->jenis][$row->nomor_soal] = $row;
PPIuI: } goto h8Xvz;
WrNDr: $this->db->order_by("jenis");
goto MOHHj;
tDIKt: $this->db->select("id_soal, bank_id, mapel_id, jenis, nomor_soal, soal, opsi_a, opsi_b, opsi_c, opsi_d, opsi_e, jawaban");
goto m4rwu;
BvwEd: return $ret;
goto xAAp3;
pDrqt: $result = $this->db->get()->result();
goto mK2Mv;
hQZU4: $this->db->where("bank_id", $id_bank);
goto WrNDr;
xAAp3: }
public function getAllSoalByBank($id_bank, $jenis = null) { goto AUuSL;
M679H: return $this->db->get("cbt_soal")->result();
goto M196V;
bfGRj: $this->db->where("jenis", $jenis);
goto P5J5Y;
P5J5Y: Xh1RV: goto M679H;
AUuSL: $this->db->select("id_soal, bank_id, mapel_id, jenis, nomor_soal, soal, opsi_a, opsi_b, opsi_c, opsi_d, opsi_e, jawaban, tampilkan");
goto CPD5A;
Y0mAs: if (!($jenis != null)) { goto Xh1RV;
} goto bfGRj;
CPD5A: $this->db->where("bank_id", $id_bank);
goto Y0mAs;
M196V: }
public function getSoalByNomor($id_bank, $nomor, $jenis) { goto v4xAC;
qx856: $this->db->where("nomor_soal", $nomor);
goto pd1CR;
sz0NU: return $this->db->get("cbt_soal")->row();
goto oV49t;
pd1CR: $this->db->where("jenis", $jenis);
goto sz0NU;
CLxyr: $this->db->where("bank_id", $id_bank);
goto qx856;
v4xAC: $this->db->select("*");
goto CLxyr;
oV49t: }
public function getNomorSoalByBankJenis($id_bank, $jenis) { goto TFW4d;
jb3Fo: Q_wmx: goto Xibng;
ExiMH: foreach ($result as $key => $row) { $ret[$row->nomor_soal] = $row;
wq55G: } goto jb3Fo;
fJM1m: $this->db->where("jenis", $jenis);
goto QDWFK;
nZLS0: $ret = [];
goto ExiMH;
Xibng: return $ret;
goto b6xjV;
TFW4d: $this->db->select("id_soal, jenis, nomor_soal");
goto jQl05;
QDWFK: $result = $this->db->get("cbt_soal")->result();
goto nZLS0;
jQl05: $this->db->where("bank_id", $id_bank);
goto fJM1m;
b6xjV: }
public function getNomorSoalByBank($id_bank, $jenis = null) { goto ugUmv;
mn_6g: foreach ($result as $key => $row) { $ret[$row->id_soal] = $row;
nqc2h: } goto QNkIU;
W8ERD: $this->db->where("tampilkan", "1");
goto ecc7t;
vjopV: $result = $this->db->get("cbt_soal")->result();
goto AD3cs;
ecc7t: if (!($jenis != null)) { goto SVwLr;
} goto DUgkt;
evxJj: SVwLr: goto vjopV;
ugUmv: $this->db->select("id_soal, jenis, nomor_soal, jawaban");
goto qJySk;
VN6k9: return $ret;
goto Sf1Vh;
AD3cs: $ret = [];
goto mn_6g;
DUgkt: $this->db->where("jenis", $jenis);
goto evxJj;
QNkIU: yPhd3: goto VN6k9;
qJySk: $this->db->where("bank_id", $id_bank);
goto W8ERD;
Sf1Vh: }
public function getNomorSoalByArrIdBank($arr_id_bank, $jenis = null) { goto OeKdG;
lm5_R: $this->db->where("jenis", $jenis);
goto pyr4Y;
K1_iS: if (!($jenis != null)) { goto aLca_;
} goto lm5_R;
OeKdG: $this->db->select("id_soal, jenis, nomor_soal, jawaban");
goto MkOB1;
BY8gM: return $this->db->get("cbt_soal")->result();
goto ZPGZ4;
MkOB1: $this->db->where_in("bank_id", $arr_id_bank);
goto K1_iS;
pyr4Y: aLca_: goto BY8gM;
ZPGZ4: }
public function cekSoalAda($id_bank, $jenis) { goto kxhcZ;
kxhcZ: $this->db->select("id_soal, bank_id, jenis, nomor_soal");
goto PoGRT;
PoGRT: $this->db->where("bank_id", $id_bank);
goto FNaiz;
FNaiz: $this->db->where("jenis", $jenis);
goto r2f02;
r2f02: return $this->db->get("cbt_soal")->result();
goto x5WWR;
x5WWR: }
public function cekSoalKomplit($id_bank, $jenjang) { goto q_Sm0;
ih5F6: $this->db->where("bank_id", $id_bank)->where("soal NOT NULL")->or_where("opsi_a NOT NULL")->or_where("opsi_b NOT NULL")->or_where("opsi_c NOT NULL")->or_where("opsi_d NOT NULL")->or_where("jawaban NOT NULL");
goto g6Gov;
q_Sm0: $this->db->select("id_soal, bank_id, jenis, nomor_soal");
goto ih5F6;
Nx7KK: $this->db->or_where("opsi_e NOT NULL");
goto jhPcf;
qvBy2: return $this->db->get("cbt_soal")->result();
goto VmLmb;
g6Gov: if (!($jenjang == "3")) { goto dnUgD;
} goto Nx7KK;
jhPcf: dnUgD: goto qvBy2;
VmLmb: }
public function cekSoalBelumKomplit($jenis, $opsi_ganda) { goto AcFbF;
ohp0B: $this->db->where("jenis", $jenis);
goto xqDBt;
XK6Vp: if (!($jenis == "1")) { goto trzX8;
} goto lKdV4;
wOxLH: $this->db->where("opsi_d IS NULL")->or_where("opsi_d =""");
goto dMoTx;
lKdV4: $this->db->where("opsi_a IS NULL")->or_where("opsi_a =""");
goto qJWpl;
xqDBt: $this->db->where("soal IS NULL")->or_where("soal =""");
goto XK6Vp;
Rscdz: XUaNM: goto kj6gI;
EHDQL: $result = $this->db->get()->result();
goto Nn1we;
prZix: $this->db->where("opsi_c IS NULL")->or_where("opsi_c =""");
goto WCspx;
SnR23: if (!($opsi_ganda == "5")) { goto vQpnu;
} goto cqxdh;
u8iup: $this->db->where("opsi_e IS NULL")->or_where("opsi_e =""");
goto rPVwu;
rPVwu: vQpnu: goto oRd8I;
wOgLR: $this->db->where("opsi_a IS NULL")->or_where("opsi_a =""");
goto Es3ng;
AcFbF: $this->db->select("id_soal, bank_id, jenis, nomor_soal, mapel_id");
goto vQcdT;
o66BA: if (!($jenis == "2")) { goto R5CeH;
} goto wOgLR;
Es3ng: R5CeH: goto nNWvn;
mREE0: $ret = [];
goto EHDQL;
dMoTx: yx8pJ: goto SnR23;
kj6gI: return $ret;
goto F3wWW;
nNWvn: $this->db->where("jawaban IS NULL")->or_where("jawaban =""");
goto mREE0;
Nn1we: foreach ($result as $key => $row) { $ret[$row->bank_id][] = $row;
UCMWI: } goto Rscdz;
cqxdh: $this->db->where("opsi_d IS NULL")->or_where("opsi_d =""");
goto u8iup;
oRd8I: trzX8: goto o66BA;
vQcdT: $this->db->from("cbt_soal");
goto ohp0B;
WCspx: if (!($opsi_ganda == "4")) { goto yx8pJ;
} goto wOxLH;
qJWpl: $this->db->where("opsi_b IS NULL")->or_where("opsi_b =""");
goto prZix;
F3wWW: }
public function getNomorSoalTerbesar($id_bank, $jenis) { goto TcgLA;
Ve1Va: return $this->db->get("cbt_soal")->row();
goto WRrEA;
TcgLA: $this->db->select("nomor_soal");
goto xzlC7;
xzlC7: $this->db->where("bank_id", $id_bank)->where("jenis", $jenis);
goto P2XGT;
P2XGT: $this->db->order_by("nomor_soal", "DESC");
goto Ve1Va;
WRrEA: }
public function dummy($jenjang) { $data = array("id_bank" => '', "bank_jenis_id" => '', "bank_kode" => '', "bank_mapel_id" => '', "bank_level" => '', "bank_kelas" => serialize([]), "bank_guru_id" => '', "jml_soal" => "0", "bobot_pg" => "0", "tampil_pg" => "0", "opsi" => $jenjang == "1" ? "3" : ($jenjang == "2" ? "4" : ($jenjang == "3" ? "5" : '')), "jml_kompleks" => "0", "tampil_kompleks" => "0", "bobot_kompleks" => "0", "jml_jodohkan" => "0", "tampil_jodohkan" => "0", "bobot_jodohkan" => "0", "jml_isian" => "0", "tampil_isian" => "0", "bobot_isian" => "0", "jml_esai" => "0", "bobot_esai" => "0", "tampil_esai" => "0", "kkm" => '', "soal_agama" => "-", "status" => "1");
return $data;
}
public function saveBankSoal($tp, $smt) { goto u6We7;
a8Ho5: $this->db->insert("cbt_bank_soal", $data);
goto LU0Fn;
b1r6S: if (!$id) { goto KZdQO;
} goto s6Qyg;
Hz08H: fOhrI: goto omwa9;
Z4sdz: goto yqdOp;
goto rDUWl;
rPBNW: $kelas = [];
goto VzmWi;
MrwTr: yqdOp: goto AUBsB;
qgqOj: $rows = count($this->input->post("kelas", true));
goto rPBNW;
p0OS5: Fn6hN: goto kD6Au;
Lq2mn: $jumlah = serialize($kelas);
goto xL5QN;
xL5QN: $data = array("id_tp" => $tp, "id_smt" => $smt, "bank_kode" => strip_tags($this->input->post("kode", TRUE)), "bank_jenis_id" => strip_tags($this->input->post("jenis", TRUE)), "bank_mapel_id" => strip_tags($this->input->post("mapel", TRUE)), "bank_kelas" => $jumlah, "bank_level" => $this->input->post("level", TRUE), "bank_guru_id" => strip_tags($this->input->post("guru", TRUE)), "jml_soal" => strip_tags($this->input->post("tampil_pg", TRUE)), "tampil_pg" => strip_tags($this->input->post("tampil_pg", TRUE)), "bobot_pg" => strip_tags($this->input->post("bobot_pg", TRUE)), "opsi" => strip_tags($this->input->post("opsi", TRUE)), "jml_kompleks" => strip_tags($this->input->post("tampil_kompleks", TRUE)), "tampil_kompleks" => strip_tags($this->input->post("tampil_kompleks", TRUE)), "bobot_kompleks" => strip_tags($this->input->post("bobot_kompleks", TRUE)), "jml_jodohkan" => strip_tags($this->input->post("tampil_jodohkan", TRUE)), "tampil_jodohkan" => strip_tags($this->input->post("tampil_jodohkan", TRUE)), "bobot_jodohkan" => strip_tags($this->input->post("bobot_jodohkan", TRUE)), "jml_isian" => strip_tags($this->input->post("tampil_isian", TRUE)), "tampil_isian" => strip_tags($this->input->post("tampil_isian", TRUE)), "bobot_isian" => strip_tags($this->input->post("bobot_isian", TRUE)), "jml_esai" => strip_tags($this->input->post("bobot_esai", TRUE)), "bobot_esai" => strip_tags($this->input->post("bobot_esai", TRUE)), "tampil_esai" => strip_tags($this->input->post("tampil_esai", TRUE)), "status" => strip_tags($this->input->post("status", TRUE)), "soal_agama" => strip_tags($this->input->post("soal_agama", TRUE)));
goto b1r6S;
LU0Fn: $insert_id = $this->db->insert_id();
goto dMcGt;
OxoqK: l8GC4: goto Lq2mn;
UCRrr: return $this->db->update("cbt_bank_soal", $data);
goto Z4sdz;
rDUWl: KZdQO: goto a8Ho5;
Ieyv6: $kelas[] = ["kelas_id" => $this->input->post("kelas[" . $i . "]", true)];
goto p0OS5;
omwa9: if (!($i <= $rows)) { goto l8GC4;
} goto Ieyv6;
kD6Au: $i++;
goto MsNl4;
s6Qyg: $this->db->where("id_bank", $id);
goto UCRrr;
VzmWi: $i = 0;
goto Hz08H;
u6We7: $id = $this->input->post("id_bank", true);
goto qgqOj;
MsNl4: goto fOhrI;
goto OxoqK;
dMcGt: return $insert_id;
goto MrwTr;
AUBsB: }
public function dummyJadwal() { $data = array("id_bank" => '', "id_jadwal" => '', "id_jenis" => '', "tgl_mulai" => '', "tgl_selesai" => '', "durasi_ujian" => '', "bank_kelas" => serialize([]), "acak_soal" => '', "acak_opsi" => '', "hasil_tampil" => '', "token" => '', "status" => '', "ulang" => '', "jarak" => '', "reset_login" => '');
return $data;
}
public function getDistinctJenisJadwal($tp, $smt) { goto sueg4;
GOt_i: $result = $this->db->get()->result();
goto vvcBw;
BSfLm: $this->db->where("id_smt", $smt);
goto GOt_i;
sueg4: $this->db->select("id_jenis");
goto lf9br;
OPukt: $this->db->from("cbt_jadwal");
goto wDzwi;
wDzwi: $this->db->where("id_tp", $tp);
goto BSfLm;
vvcBw: return $result;
goto c7Vfw;
lf9br: $this->db->distinct();
goto OPukt;
c7Vfw: }
public function getDataJadwal($tp, $smt, $guru = null, $rekap = null) { goto UNi5f;
e6V_p: $this->db->where("a.rekap", $rekap);
goto Ff4sS;
N4liL: if (!($rekap !== null)) { goto KNGjW;
} goto e6V_p;
ZjKW1: PesMd: goto N4liL;
hajMO: $this->db->join("master_tp e", "a.id_tp=e.id_tp");
goto PgkkP;
PTd9k: if (!($guru !== null)) { goto PesMd;
} goto xdo7_;
nXHoK: $query = $this->db->get()->result();
goto kEKVi;
tHABe: $this->db->order_by("b.bank_level", "ASC");
goto nXHoK;
w8QcC: $this->db->join("level_kelas g", "b.bank_level=g.id_level");
goto PTd9k;
glNHj: $this->db->join("cbt_jenis c", "c.id_jenis=a.id_jenis", "left");
goto vfjlb;
vfjlb: $this->db->join("master_mapel d", "d.id_mapel=b.bank_mapel_id", "left");
goto hajMO;
xdo7_: $this->db->where("b.bank_guru_id", $guru);
goto ZjKW1;
Ff4sS: KNGjW: goto AWBQI;
PgkkP: $this->db->join("master_smt f", "a.id_smt=f.id_smt");
goto w8QcC;
kEKVi: return $query;
goto sgbXc;
Dd3j7: $this->db->join("cbt_bank_soal b", "b.id_bank=a.id_bank", "left");
goto glNHj;
UNi5f: $this->db->select("a.id_jadwal, a.id_tp, a.id_smt, a.id_bank, a.id_jenis, a.tgl_mulai," . " a.tgl_selesai, a.status, a.ulang, a.reset_login, a.rekap, a.jam_ke," . " e.id_tp, e.tahun, f.id_smt, f.nama_smt, g.level, b.bank_kode, b.bank_level, b.bank_kelas," . " c.kode_jenis, d.kode, d.nama_mapel," . " b.tampil_pg, b.tampil_kompleks, b.tampil_jodohkan, b.tampil_isian, b.tampil_esai, b.bank_guru_id," . " (SELECT COUNT(id_soal) FROM cbt_soal WHERE cbt_soal.bank_id = a.id_bank) AS total_soal");
goto xaPet;
xaPet: $this->db->from("cbt_jadwal a");
goto Dd3j7;
AWBQI: $this->db->order_by("a.tgl_mulai", "DESC");
goto tHABe;
sgbXc: }
public function getAllDataJadwal($guru = null, $mapel = null, $level = null) {
goto x8JvT;
bEGOj: X1H2H: goto MKS4X;
WSnzF: if (!($mapel !== null)) { goto PJ6nW;
} goto Eif_v;
EYbuf: $this->db->join("master_smt f", "a.id_smt=f.id_smt");
goto g6r6r;
g6r6r: $this->db->join("level_kelas g", "b.bank_level=g.id_level");
goto dE1r3;
F3oEj: $this->db->where("b.bank_level", $level);
goto O6PHV;
CZZhN: if (!($level !== null)) {
goto elVHc;
} goto F3oEj;
KB1KR: $this->db->join("cbt_bank_soal b", "b.id_bank=a.id_bank");
goto X1S8l;
bVAHP: $this->db->where("b.bank_guru_id", $guru);
goto e5V_Q;
yXsh3: PJ6nW: goto CZZhN;
O6PHV: elVHc: goto DOW2K;
X1S8l: $this->db->join("cbt_jenis c", "c.id_jenis=a.id_jenis", "left");
goto YRfKU;
qKLdn: $ret = [];
goto INolh;
x8JvT: $this->db->select("a.id_jadwal, a.tgl_mulai, a.tgl_selesai, a.status, a.durasi_ujian, a.acak_soal," . " a.acak_opsi, a.id_bank, a.id_jenis, a.hasil_tampil, a.status, a.ulang, a.reset_login, a.rekap," . " a.jam_ke, a.token, e.tahun, f.nama_smt, g.level, b.bank_kode, b.bank_level, b.bank_kelas, c.kode_jenis, d.kode, d.nama_mapel," . " b.tampil_pg, b.tampil_kompleks, b.tampil_jodohkan, b.tampil_isian, b.tampil_esai, b.bank_guru_id," . " (SELECT COUNT(id_soal) FROM cbt_soal WHERE cbt_soal.bank_id = a.id_bank) AS total_soal");
goto WAZnm;
WAZnm: $this->db->from("cbt_jadwal a");
goto KB1KR;
Eif_v: $this->db->where("b.bank_mapel_id", $mapel);
goto yXsh3;
j70ZI: $this->db->join("master_tp e", "a.id_tp=e.id_tp");
goto EYbuf;
LvFe1: $this->db->order_by("a.id_smt", "DESC");
goto xcUIW;
lyULk: $this->db->order_by("a.id_tp", "DESC");
goto LvFe1;
e5V_Q: RahlK: goto WSnzF;
MKS4X: return $ret;
goto ADO7m;
INolh: foreach ($query as $key => $row) { $ret["<b>" . $row->kode_jenis . "</b> " . $row->tahun . " smt " . $row->nama_smt][$row->level][] = $row;
lKymA: } goto bEGOj;
DOW2K: $this->db->order_by("b.bank_level", "ASC");
goto lyULk;
dE1r3: if (!($guru !== null)) { goto RahlK;
} goto bVAHP;
YRfKU: $this->db->join("master_mapel d", "d.id_mapel=b.bank_mapel_id", "left");
goto j70ZI;
xcUIW: $query = $this->db->get()->result();
goto qKLdn;
ADO7m: }
public function getJadwalTerpakai($id_jadwal = null) { goto XHgy0;
Jgwcm: $result = $this->db->get()->result();
goto DGKd0;
i0RJw: $this->db->where("id_jadwal", $id_jadwal);
goto R1Orw;
DGKd0: $ret = [];
goto LXAU5;
ZChSp: if (!($id_jadwal != null)) { goto alZFH;
} goto i0RJw;
Vttwv: dqiaV: goto rZ94P;
R1Orw: alZFH: goto Jgwcm;
XHgy0: $this->db->from("cbt_soal_siswa");
goto ZChSp;
LXAU5: foreach ($result as $key => $row) { $ret[$row->id_jadwal][$row->id_siswa] = $row;
RUMMi: } goto Vttwv;
rZ94P: return $ret;
goto CKzdF;
CKzdF: }
public function getBankTerpakai($id_bank = null) { goto buUi4;
buUi4: $this->db->from("cbt_soal_siswa");
goto Gnf1O;
yjol3: foreach ($result as $key => $row) { $ret[$row->id_bank][$row->id_siswa] = $row;
kq1GL: } goto mVaH4;
MDzfP: t93Gl: goto tWMYi;
X13As: return $ret;
goto w0n1e;
tWMYi: $result = $this->db->get()->result();
goto zmAKI;
Gnf1O: if (!($id_bank != null)) { goto t93Gl;
} goto t9DEX;
zmAKI: $ret = [];
goto yjol3;
mVaH4: j78rk: goto X13As;
t9DEX: $this->db->where("id_bank", $id_bank);
goto MDzfP;
w0n1e: }
public function getRekapByJadwalKelas($jadwal, $guru = null) { goto oWeyb;
w1E76: $this->db->where("id_jadwal", $jadwal);
goto lctfb;
v9TKK: $this->db->where("id_guru", $guru);
goto Hs8ag;
oWeyb: $this->db->from("cbt_rekap");
goto w1E76;
hLI0J: $result = $this->db->get()->row();
goto oGgJq;
Hs8ag: vquOL: goto hLI0J;
lctfb: if (!($guru !== null)) { goto vquOL;
} goto v9TKK;
oGgJq: return $result;
goto MD2Pq;
MD2Pq: }
public function getRekapJadwal($guru = null) { goto lbVux;
lbVux: $this->db->select("*");
goto oXzlf;
aduJC: ed0OG: goto z5UGj;
g72vx: if (!($guru !== null)) { goto ed0OG;
} goto N0izk;
dZ9Ul: return $query->result();
goto ATq3F;
oXzlf: $this->db->from("cbt_rekap");
goto g72vx;
Vcf_j: $query = $this->db->get();
goto dZ9Ul;
N0izk: $this->db->where("id_guru", $guru);
goto aduJC;
z5UGj: $this->db->order_by("tgl_mulai", "DESC");
goto Vcf_j;
ATq3F: }
public function getAllRekapByJenis($tp, $smt, $jenis, $level, $mapel, $jadwal = null, $guru = null) { goto WG8NS;
mcSMj: $this->db->where("bank_level", $level);
goto jDyDI;
qzWkx: if (!($guru != null)) { goto Ve3Mk;
} goto H6HXS;
kUh6v: if (!($mapel != "0")) { goto dPZxO;
} goto Kvk2b;
Kvk2b: $this->db->where("id_mapel", $mapel);
goto bCCHg;
jDyDI: $this->db->order_by("id_mapel", "ASC");
goto bD2Xp;
qDCvX: $this->db->where("smt", $smt);
goto OQtUK;
VnPHH: if (!($jadwal != null)) { goto g1izn;
} goto i1FiH;
b3VuG: Ve3Mk: goto PPFnt;
AfLtS: g1izn: goto qzWkx;
PPFnt: $this->db->where("tp", $tp);
goto qDCvX;
CQtWq: return $result;
goto UMutu;
bCCHg: dPZxO: goto VnPHH;
bD2Xp: $result = $this->db->get()->result();
goto CQtWq;
WG8NS: $this->db->from("cbt_rekap");
goto kUh6v;
OQtUK: $this->db->where("kode_jenis", $jenis);
goto mcSMj;
H6HXS: $this->db->where("id_guru", $guru);
goto b3VuG;
i1FiH: $this->db->where("id_jadwal", $jadwal);
goto AfLtS;
UMutu: }
public function getAllNilaiRekapByJenis($tp, $smt, $jenis, $kelas, $mapel, $jadwal = null, $guru = null) { goto gUFB1;
w2s6h: $this->db->where("a.tp", $tp);
goto Yy1qc;
x7SEs: $this->db->where("a.kode_jenis", $jenis);
goto SBGM0;
BGM5M: $this->db->join("buku_induk i", "i.id_siswa=a.id_siswa AND =i.status=1");
goto W67_D;
X9Vsv: BCpgd: goto by9A2;
TXHuG: if (!($guru != null)) { goto BCpgd;
} goto aGQAl;
gUFB1: $this->db->select("a.*, b.nomor_peserta, c.nama");
goto as0aw;
zfOFh: return $result;
goto lNmTW;
aGQAl: $this->db->where("a.id_guru", $guru);
goto X9Vsv;
v3HE8: if (!($jadwal != null)) { goto xvc16;
} goto b38AW;
y1ZAs: $result = $this->db->get()->result();
goto zfOFh;
by9A2: $this->db->where("a.id_kelas", $kelas);
goto w2s6h;
Yy1qc: $this->db->where("a.smt", $smt);
goto x7SEs;
as0aw: $this->db->from("cbt_rekap_nilai a");
goto JxNBp;
RY5H7: QBZ0b: goto v3HE8;
S7IWY: $this->db->join("master_siswa c", "c.id_siswa=a.id_siswa", "left");
goto BGM5M;
SBGM0: $this->db->order_by("c.nama", "ASC");
goto y1ZAs;
zcIxs: $this->db->where("a.id_mapel", $mapel);
goto RY5H7;
JxNBp: $this->db->join("cbt_nomor_peserta b", "b.id_siswa=a.id_siswa AND b.id_tp=a.id_tp", "left");
goto S7IWY;
E5HSZ: xvc16: goto TXHuG;
b38AW: $this->db->where("a.id_jadwal", $jadwal);
goto E5HSZ;
W67_D: if (!($mapel != "0")) { goto QBZ0b;
} goto zcIxs;
lNmTW: }
public function getAllRekap($guru = null) { goto YiLzO;
j5wpl: foreach ($result as $key => $row) { $ret[$row->id_jadwal] = $row;
dNIgf: } goto gVLjt;
gVLjt: x0yOq: goto fHBoy;
fOnr3: $ret = [];
goto j5wpl;
AjZJ1: $this->db->where("id_guru", $guru);
goto LfpNF;
D1vwh: $this->db->from("cbt_rekap");
goto H6x19;
LfpNF: PC390: goto dCq2b;
YiLzO: $this->db->select("id_rekap, id_tp, tp, id_smt, smt, id_jadwal, id_jenis, kode_jenis, id_bank, bank_kelas, nama_kelas, bank_kode, bank_level, id_mapel, nama_mapel, kode, tgl_mulai, tgl_selesai, id_guru, nama_guru");
goto D1vwh;
fHBoy: return $ret;
goto rOYjM;
H6x19: if (!($guru != null)) { goto PC390;
} goto AjZJ1;
dCq2b: $result = $this->db->get()->result();
goto fOnr3;
rOYjM: }
public function getJadwalById($id_jadwal, $sesi = null) { goto RuBSA;
VfPIm: $this->db->join("cbt_bank_soal b", "b.id_bank=a.id_bank", "left");
goto PdxRL;
M69IK: if (!($sesi != null)) { goto Py467;
} goto E6Lq_;
edvR5: $this->db->join("master_mapel d", "d.id_mapel=b.bank_mapel_id", "left");
goto M69IK;
sfPlx: $this->db->join("master_guru f", "f.id_guru=b.bank_guru_id", "left");
goto hoO5E;
E6Lq_: $this->db->join("cbt_sesi e", "e.id_sesi=" . $sesi, "left");
goto iDk6Y;
iDk6Y: Py467: goto sfPlx;
PNTc3: return $query;
goto X9YzK;
hoO5E: $this->db->where("a.id_jadwal", $id_jadwal);
goto GAyHe;
PURLK: $this->db->from("cbt_jadwal a");
goto VfPIm;
RuBSA: $this->db->select("a.*, b.opsi, b.bank_kode, b.bank_level, b.bank_kelas," . " b.tampil_pg, b.tampil_kompleks, b.tampil_jodohkan, b.tampil_isian, b.tampil_esai," . " b.bobot_pg, b.bobot_kompleks, b.bobot_jodohkan, b.bobot_isian, b.bobot_esai," . " b.id_bank, b.bank_guru_id, c.kode_jenis, c.nama_jenis," . " d.id_mapel, d.kode, d.nama_mapel, f.id_guru, f.nama_guru");
goto PURLK;
PdxRL: $this->db->join("cbt_jenis c", "c.id_jenis=a.id_jenis", "left");
goto edvR5;
GAyHe: $query = $this->db->get()->row();
goto PNTc3;
X9YzK: }
public function getJadwalByIdBank($id_bank) { goto NDmIk;
qMxlC: $this->db->join("master_mapel d", "d.id_mapel=b.bank_mapel_id", "left");
goto sgwpl;
Yfqca: $this->db->where("a.id_bank", $id_bank);
goto e63gf;
sGRZ0: return $query;
goto y79Cq;
NDmIk: $this->db->select("a.*, b.opsi, b.bank_kode, b.bank_level, b.bank_kelas," . " b.tampil_pg, b.tampil_kompleks, b.tampil_jodohkan, b.tampil_isian, b.tampil_esai," . " b.bobot_pg, b.bobot_kompleks, b.bobot_jodohkan, b.bobot_isian, b.bobot_esai," . " b.id_bank, b.bank_guru_id, c.kode_jenis, c.nama_jenis," . " d.id_mapel, d.kode, d.nama_mapel, f.id_guru, f.nama_guru");
goto JISpM;
HM_43: $this->db->join("cbt_jenis c", "c.id_jenis=a.id_jenis", "left");
goto qMxlC;
sgwpl: $this->db->join("master_guru f", "f.id_guru=b.bank_guru_id", "left");
goto Yfqca;
JISpM: $this->db->from("cbt_jadwal a");
goto hPnWN;
hPnWN: $this->db->join("cbt_bank_soal b", "b.id_bank=a.id_bank", "left");
goto HM_43;
e63gf: $query = $this->db->get()->row();
goto sGRZ0;
y79Cq: }
public function getAllJadwal($tp, $smt, $id_guru = null) { goto QFmkV;
Nsm8k: return $this->db->get()->result();
goto wI7OE;
FJ6ef: $this->db->where("b.id_tp", $tp);
goto ZXENA;
NwZmK: $this->db->where("a.bank_guru_id", $id_guru);
goto efI51;
ZXENA: $this->db->where("b.id_smt", $smt);
goto Nsm8k;
I3OaJ: $this->db->join("cbt_jadwal b", "b.id_bank=a.id_bank");
goto nka63;
efI51: hD_WH: goto FJ6ef;
QFmkV: $this->db->select("a.bank_kode, a.bank_kelas, b.id_jadwal");
goto EgX41;
EgX41: $this->db->from("cbt_bank_soal a");
goto I3OaJ;
nka63: if (!($id_guru != null)) { goto hD_WH;
} goto NwZmK;
wI7OE: }
public function getJadwalByArrId($arr_id_jadwal, $sesi = null) { goto lRktK;
cfZYv: $this->db->where_in("a.id_jadwal", $arr_id_jadwal);
goto Bydza;
FhzH0: $this->db->join("cbt_jenis c", "c.id_jenis=a.id_jenis", "left");
goto oBjdP;
oBjdP: $this->db->join("master_mapel d", "d.id_mapel=b.bank_mapel_id", "left");
goto t83Jh;
qsRsc: $this->db->from("cbt_jadwal a");
goto TD2Q3;
lRktK: $this->db->select("a.*, b.opsi, b.bank_kode, b.bank_level, b.bank_kelas," . " b.tampil_pg, b.tampil_kompleks, b.tampil_jodohkan, b.tampil_isian, b.tampil_esai," . " b.bobot_pg, b.bobot_kompleks, b.bobot_jodohkan, b.bobot_isian, b.bobot_esai," . " b.id_bank, b.bank_guru_id, c.kode_jenis, c.nama_jenis," . " d.id_mapel, d.kode, d.nama_mapel, f.id_guru, f.nama_guru");
goto qsRsc;
up_1a: $this->db->join("cbt_sesi e", "e.id_sesi=" . $sesi, "left");
goto jDezZ;
Bydza: $query = $this->db->get()->result();
goto idXiD;
z9hMW: $this->db->join("master_guru f", "f.id_guru=b.bank_guru_id", "left");
goto cfZYv;
t83Jh: if (!($sesi != null)) { goto YVCbt;
} goto up_1a;
idXiD: return $query;
goto hteTv;
jDezZ: YVCbt: goto z9hMW;
TD2Q3: $this->db->join("cbt_bank_soal b", "b.id_bank=a.id_bank", "left");
goto FhzH0;
hteTv: }
public function cekJadwalBankSoal($id_bank) { goto Nlahl;
VSvfV: $query = $this->db->get()->num_rows();
goto mCN6f;
qTaTg: $this->db->from("cbt_jadwal");
goto p8B8Q;
QV6hl: goto AeIiU;
goto d5Kb5;
Nlahl: $this->db->select("id_bank");
goto qTaTg;
UWt68: $this->db->where("id_bank", $id_bank);
goto QV6hl;
d5Kb5: vNWqx: goto IAVnL;
mCN6f: return $query;
goto j7RAa;
IAVnL: $this->db->where_in("id_bank", $id_bank);
goto xkheJ;
xkheJ: AeIiU: goto VSvfV;
p8B8Q: if (is_array($id_bank)) { goto vNWqx;
} goto UWt68;
j7RAa: }
public function cekJadwalSudahMulai($id_jadwal) { $query = $this->get_where("cbt_durasi_siswa", "id_jadwal", $id_jadwal)->num_rows();
return $query;
}
public function saveJadwalUjian($id_tp, $id_smt) { goto gSVnS;
A48W3: $bank_id = strip_tags($this->input->post("bank_id", TRUE));
goto xCw0t;
Rv3pl: return $this->db->update("cbt_jadwal", $data);
goto cSeo_;
MIm1j: $status = $this->input->post("status", TRUE);
goto Id_5A;
D5Mag: goto X4p7v;
goto Zypj9;
s6JJZ: if ($id == '') { goto wqN9W;
} goto FW3hK;
dPdxq: return false;
goto ImLq0;
Ivoqh: $data = array("id_tp" => $id_tp, "id_smt" => $id_smt, "id_bank" => $bank_id, "id_jenis" => $jenis_id, "tgl_mulai" => $mulai, "tgl_selesai" => $selesai, "durasi_ujian" => $durasi, "jarak" => $jarak, "acak_soal" => !$acak_soal ? "0" : $acak_soal, "acak_opsi" => !$acak_opsi ? "0" : $acak_opsi, "hasil_tampil" => !$hasil_tampil ? "0" : $hasil_tampil, "token" => !$token ? "0" : $token, "status" => !$status ? "0" : $status, "reset_login" => !$reset_login ? "0" : $reset_login);
goto s6JJZ;
Id_5A: $reset_login = $this->input->post("reset_login", TRUE);
goto A48W3;
ImLq0: ppYF8: goto D5Mag;
Zypj9: wqN9W: goto goSZ2;
FW3hK: if ($check != null && $check->id_jadwal != $id) { goto Hoput;
} goto RAqn1;
Vr4lH: $jarak = strip_tags($this->input->post("jarak", TRUE));
goto Qmfxd;
cSeo_: goto ppYF8;
goto h5dDf;
uGGyO: X4p7v: goto Z9cSZ;
syRN_: return false;
goto XUfM0;
XUfM0: TY9Mh: goto uGGyO;
ah5BB: DwIwt: goto syRN_;
e2hsB: return $insert_id;
goto ktrNB;
lU7iZ: $token = $this->input->post("token", TRUE);
goto MIm1j;
ktrNB: goto TY9Mh;
goto ah5BB;
goSZ2: if ($check != null) { goto DwIwt;
} goto HTe9E;
X2Hsu: $durasi = strip_tags($this->input->post("durasi_ujian", TRUE));
goto Vr4lH;
NAurA: $insert_id = $this->db->insert_id();
goto e2hsB;
ixcWw: $acak_opsi = $this->input->post("acak_opsi", TRUE);
goto w6NU1;
FrinE: $selesai = strip_tags($this->input->post("tgl_selesai", TRUE));
goto X2Hsu;
gSVnS: $id = $this->input->post("id_jadwal", true);
goto D3BPr;
w6NU1: $hasil_tampil = $this->input->post("hasil_tampil", TRUE);
goto lU7iZ;
RAqn1: $this->db->where("id_jadwal", $id);
goto Rv3pl;
cKWRE: $mulai = strip_tags($this->input->post("tgl_mulai", TRUE));
goto FrinE;
xCw0t: $jenis_id = strip_tags($this->input->post("jenis_id", TRUE));
goto cKWRE;
Qmfxd: $check = $this->db->where("id_bank", $bank_id)->where("id_jenis", $jenis_id)->get("cbt_jadwal")->row();
goto Ivoqh;
h5dDf: Hoput: goto dPdxq;
D3BPr: $acak_soal = $this->input->post("acak_soal", TRUE);
goto ixcWw;
HTe9E: $this->db->insert("cbt_jadwal", $data);
goto NAurA;
Z9cSZ: }
public function getJadwalTgl($guru = null) { goto L3U_m;
IshHS: return $query->result();
goto wSP6N;
L3U_m: $this->db->distinct();
goto ZLTWa;
MaRe2: $query = $this->db->get();
goto IshHS;
ZLTWa: $this->db->select("tgl_mulai");
goto qil8_;
qil8_: $this->db->from("cbt_jadwal");
goto MaRe2;
wSP6N: }
public function getDataJadwalByTgl($tgl) { goto Zfvlx;
E_lUr: $query = $this->db->get();
goto TIrop;
Zfvlx: $this->db->distinct();
goto B51L7;
B51L7: $this->db->select("tgl_mulai, tgl_selesai");
goto BB3JZ;
tXiPf: $this->db->where("tgl_mulai <= '{$tgl}' AND tgl_selesai >= '{$tgl}'");
goto E_lUr;
BB3JZ: $this->db->from("cbt_jadwal");
goto tXiPf;
TIrop: return $query->result();
goto aHUzZ;
aHUzZ: }
public function getDataGuru() { goto yB7JR;
vVYSl: $query = $this->db->get()->result();
goto pLrEQ;
pLrEQ: return $query;
goto hHWu0;
yB7JR: $this->db->select("a.id_guru, a.nama_guru, b.id_pengawas, b.id_jadwal");
goto U8Wcz;
KBRnN: $this->db->join("cbt_pengawas b", "b.id_guru = a.id_guru", "left");
goto vVYSl;
U8Wcz: $this->db->from("master_guru a");
goto KBRnN;
hHWu0: }
public function saveToken($post_token) { goto Q8aJY;
p3O9K: goto Xw6Ls;
goto xWw3u;
Eg5I4: $this->db->where("id_token", $id);
goto aXaHQ;
lxG2j: $jarak = $post_token->jarak;
goto p6fyx;
p6fyx: $data = array("token" => $tkn, "auto" => $auto, "jarak" => $jarak, "updated" => $post_token->updated);
goto D5xce;
DQivR: Xw6Ls: goto rtx7q;
aXaHQ: return $this->db->update("cbt_token", $data);
goto p3O9K;
D5xce: if (!$id) { goto iYOet;
} goto Eg5I4;
xWw3u: iYOet: goto MeLns;
sqmzV: $auto = $post_token->auto;
goto lxG2j;
Q8aJY: $id = isset($post_token->id_token) ? $post_token->id_token : false;
goto ABICs;
MeLns: $this->db->insert("cbt_token", $data);
goto uKs4b;
uKs4b: $insert_id = $this->db->insert_id();
goto L9pl5;
ABICs: $tkn = $post_token->token;
goto sqmzV;
L9pl5: return $insert_id;
goto DQivR;
rtx7q: }
public function updateToken($token, $auto) { goto lJgwp;
kwSNf: return $result;
goto RJ1P6;
lJgwp: $this->db->set("auto", $auto, FALSE);
goto XZB_d;
XZB_d: $this->db->where("token", $token);
goto R3LFs;
R3LFs: $this->db->update("cbt_token");
goto MUKPb;
MUKPb: $result = $this->db->get("cbt_token")->row();
goto kwSNf;
RJ1P6: }
public function getToken() { $result = $this->db->get("cbt_token")->row();
return $result;
}
public function getJadwalCbtKelas($id_tp, $id_smt) { goto VFM1q;
XPBOE: $this->db->join("cbt_bank_soal b", "b.id_bank=a.id_bank");
goto Mf5gI;
ZzT4Q: $this->db->where("a.id_smt", $id_smt);
goto C6zHb;
VFM1q: $this->db->select("a.id_jadwal, b.bank_kelas");
goto QEHy3;
C6zHb: return $this->db->get()->result();
goto mgw_7;
QEHy3: $this->db->from("cbt_jadwal a");
goto XPBOE;
Mf5gI: $this->db->where("a.id_tp", $id_tp);
goto ZzT4Q;
mgw_7: }
public function getInfoJadwal($id_bank) { goto aYXKp;
aYXKp: $this->db->select("a.id_bank, b.acak_soal, b.acak_opsi, a.opsi," . " a.tampil_pg, a.tampil_kompleks, a.tampil_jodohkan, a.tampil_isian, a.tampil_esai," . " a.bobot_pg, a.bobot_kompleks, a.bobot_jodohkan, a.bobot_isian, a.bobot_esai");
goto esaLQ;
DsF_Z: return $this->db->get()->row();
goto zieNp;
esaLQ: $this->db->from("cbt_bank_soal a");
goto gDS5c;
gDS5c: $this->db->join("cbt_jadwal b", "a.id_bank=b.id_bank");
goto Q8IzT;
Q8IzT: $this->db->where("a.id_bank", $id_bank);
goto DsF_Z;
zieNp: }
public function getAllIdSoal($id_bank) { goto Glni3;
gN1G9: $ret = [];
goto tXN8E;
ywV7Q: $this->db->where("bank_id", $id_bank);
goto q__0K;
OUz7c: foreach ($result as $row) { $ret[$row->jenis][] = $row;
mH6Xp: } goto Q5enY;
Szt7W: $this->db->where("tampilkan", "1");
goto ywV7Q;
Mn0AL: $this->db->from("cbt_soal");
goto Szt7W;
PV73U: DZxS3: goto X9Hq3;
q__0K: $result = $this->db->get()->result();
goto gN1G9;
Glni3: $this->db->select("id_soal, jenis, jawaban");
goto Mn0AL;
X9Hq3: return $ret;
goto D3tZ4;
tXN8E: if (!$result) { goto DZxS3;
} goto OUz7c;
Q5enY: oZNkx: goto PV73U;
D3tZ4: }
public function getJadwalCbt($id_tp, $id_smt, $level) { goto pESGn;
j2Qim: $this->db->where("a.status", "1");
goto NS6oe;
lW65V: $this->db->where("a.id_tp", $id_tp);
goto j2Qim;
rEoRi: $result = $this->db->get()->result();
goto zJK6L;
pESGn: $this->db->select("a.id_jadwal, a.id_tp, a.id_smt, a.id_bank, a.id_jenis, a.tgl_mulai, a.tgl_selesai," . " a.durasi_ujian, a.pengawas, a.acak_soal, a.acak_opsi, a.hasil_tampil, a.token, a.status, a.ulang," . " a.reset_login, a.rekap, a.jam_ke, a.jarak," . " c.bank_kode, c.bank_level, c.bank_kelas, c.tampil_pg, c.tampil_kompleks, c.tampil_jodohkan," . " c.tampil_isian, c.tampil_esai, c.soal_agama, " . " c.bobot_pg, c.bobot_kompleks, c.bobot_jodohkan, c.bobot_isian, c.bobot_esai, b.kode_jenis," . " b.nama_jenis, d.kode, d.nama_mapel");
goto FRsFp;
FRsFp: $this->db->from("cbt_jadwal a");
goto ODwDm;
NS6oe: $this->db->where("a.id_smt", $id_smt);
goto mHoAJ;
yjIWd: foreach ($result as $row) { $retur[$row->id_jadwal] = $row;
C3IGL: } goto xFcxd;
wF7UC: $this->db->where("c.status_soal", "1");
goto n_EsM;
xFcxd: adrnB: goto t5zsV;
n_EsM: $this->db->where("c.bank_level", $level);
goto C3b_C;
Al9rb: $this->db->join("cbt_bank_soal c", "c.id_bank=a.id_bank");
goto uFMFB;
zJK6L: $retur = [];
goto yjIWd;
mHoAJ: $this->db->where("c.status", "1");
goto wF7UC;
ODwDm: $this->db->join("cbt_jenis b", "b.id_jenis=a.id_jenis");
goto Al9rb;
t5zsV: return $retur;
goto p0H6L;
uFMFB: $this->db->join("master_mapel d", "d.id_mapel=c.bank_mapel_id");
goto lW65V;
C3b_C: $this->db->order_by("a.jam_ke");
goto rEoRi;
p0H6L: }
public function getJadwalByKelas($id_tp, $id_smt, $kelas) { goto cdUta;
E_RYA: $this->db->where("a.id_tp", $id_tp);
goto eopGi;
eopGi: $this->db->where("a.status", "1");
goto tB3Ol;
cdUta: $this->db->select("a.id_jadwal, a.id_tp, a.id_smt, a.id_bank, a.id_jenis, a.tgl_mulai, a.tgl_selesai," . " a.durasi_ujian, a.pengawas, a.acak_soal, a.acak_opsi, a.hasil_tampil, a.token, a.status, a.ulang," . " a.reset_login, a.rekap, a.jam_ke, a.jarak," . " c.bank_kode, c.bank_level, c.bank_kelas, c.tampil_pg, c.tampil_kompleks, c.tampil_jodohkan," . " c.tampil_isian, c.tampil_esai, c.soal_agama, " . " c.bobot_pg, c.bobot_kompleks, c.bobot_jodohkan, c.bobot_isian, c.bobot_esai, b.kode_jenis," . " b.nama_jenis, d.kode, d.nama_mapel");
goto eEwEk;
JZHkG: $this->db->where("c.status", "1");
goto HOReX;
cGmL0: $this->db->like("c.bank_kelas", $kelas);
goto DgfKA;
QkcmC: $retur = [];
goto v1ddD;
dAerE: return $retur;
goto DKFSC;
v1ddD: foreach ($result as $row) { $retur[$row->id_jadwal] = $row;
duNxA: } goto fSMSs;
eEwEk: $this->db->from("cbt_jadwal a");
goto So12G;
Di8Fc: $this->db->join("cbt_bank_soal c", "c.id_bank=a.id_bank");
goto Bu_V0;
Bu_V0: $this->db->join("master_mapel d", "d.id_mapel=c.bank_mapel_id");
goto E_RYA;
DgfKA: $this->db->order_by("a.jam_ke");
goto OGOXX;
So12G: $this->db->join("cbt_jenis b", "b.id_jenis=a.id_jenis");
goto Di8Fc;
OGOXX: $result = $this->db->get()->result();
goto QkcmC;
tB3Ol: $this->db->where("a.id_smt", $id_smt);
goto JZHkG;
HOReX: $this->db->where("c.status_soal", "1");
goto cGmL0;
fSMSs: E5iAd: goto dAerE;
DKFSC: }
public function getCbt($id_jadwal) { goto mS8ve;
x4F2D: $this->db->join("master_guru e", "e.id_guru=c.bank_guru_id", "left");
goto BH3JF;
ZC5ie: $this->db->join("cbt_bank_soal c", "c.id_bank=a.id_bank", "left");
goto LBs0K;
vPRrO: $this->db->from("cbt_jadwal a");
goto IgVam;
VOOy7: return $this->db->get()->row();
goto tw_NF;
BH3JF: $this->db->join("master_jurusan f", "f.id_jurusan=c.bank_jurusan_id", "left");
goto rdAKL;
DNmLT: $this->db->join("master_smt h", "h.id_smt=a.id_smt", "left");
goto HnGOS;
mS8ve: $this->db->select("a.id_jadwal, a.id_tp, a.id_smt, a.id_bank, a.id_jenis, a.tgl_mulai, a.tgl_selesai," . " a.durasi_ujian, a.pengawas, a.acak_soal, a.acak_opsi, a.hasil_tampil, a.token, a.status, a.ulang," . " a.reset_login, a.rekap, a.jam_ke, a.jarak," . " b.nama_jenis, b.kode_jenis," . " c.bank_kode, c.bank_level, c.bank_kelas, c.bank_mapel_id, c.bank_jurusan_id," . " c.bank_guru_id, c.bank_nama, c.jml_soal, c.jml_esai, c.tampil_pg, c.tampil_esai, c.bobot_pg," . " c.bobot_esai, c.opsi, c.date, c.status, c.soal_agama, c.id_tp, c.id_smt, c.deskripsi, c.jml_kompleks," . " c.tampil_kompleks, c.bobot_kompleks, c.jml_jodohkan, c.tampil_jodohkan, c.bobot_jodohkan, c.jml_isian," . " c.tampil_isian, c.bobot_isian, c.status_soal," . " d.id_mapel, d.nama_mapel, d.kode," . " e.id_guru, e.nama_guru," . " f.id_jurusan, f.nama_jurusan, f.kode_jurusan," . " g.tahun," . " h.smt, h.nama_smt," . " (SELECT COUNT(id_soal) FROM cbt_soal WHERE cbt_soal.bank_id = a.id_bank) AS total_soal");
goto vPRrO;
IgVam: $this->db->join("cbt_jenis b", "b.id_jenis=a.id_jenis", "left");
goto ZC5ie;
rdAKL: $this->db->join("master_tp g", "g.id_tp=a.id_tp", "left");
goto DNmLT;
HnGOS: $this->db->where("a.id_jadwal", $id_jadwal);
goto VOOy7;
LBs0K: $this->db->join("master_mapel d", "d.id_mapel=c.bank_mapel_id", "left");
goto x4F2D;
tw_NF: }
public function getCbtById($id_jadwal) { goto CV1Xz;
soFOO: $this->db->from("cbt_jadwal");
goto hZU4h;
CV1Xz: $this->db->select("*");
goto soFOO;
XXczg: return $this->db->get()->row();
goto Ztg33;
hZU4h: $this->db->where("id_jadwal", $id_jadwal);
goto XXczg;
Ztg33: }
public function getIdRuangById($array) { goto b5OjU;
TyxM8: if (!$result) { goto mxfD_;
} goto n1ejT;
b5OjU: $this->db->select("nama_ruang");
goto sD06d;
GuDhc: mxfD_: goto nLp5q;
lJzwY: $this->db->where("id_ruang", $array);
goto X9PVN;
wqjJ5: WQM_f: goto GuDhc;
X9PVN: $result = $this->db->get()->result();
goto TyxM8;
n1ejT: foreach ($result as $key => $row) { $ret[$row->id_ruang] = $row->kode_ruang;
v6DgL: } goto wqjJ5;
nLp5q: return $ret;
goto xehID;
sD06d: $this->db->from("cbt_ruang");
goto lJzwY;
xehID: }
public function getNamaRuangById($id) { goto rWceY;
XISVE: goto Ih_kR;
goto opydq;
opydq: GImfH: goto a7LIb;
RybpK: $result = $this->db->get()->row();
goto xID0S;
aCTIA: Ih_kR: goto CD9Qu;
BNqbk: return '';
goto XISVE;
pZ8_M: $this->db->from("cbt_ruang");
goto y2tcc;
rWceY: $this->db->select("nama_ruang");
goto pZ8_M;
y2tcc: $this->db->where("id_ruang", $id);
goto RybpK;
xID0S: if ($result) { goto GImfH;
} goto BNqbk;
a7LIb: return $result->nama_ruang;
goto aCTIA;
CD9Qu: }
public function getNamaSesiById($id) { goto vyN_G;
vyN_G: $this->db->select("nama_sesi");
goto i3lnn;
N4h1h: return $this->db->get()->row()->nama_sesi;
goto GxIkw;
i3lnn: $this->db->from("cbt_sesi");
goto wpzDq;
wpzDq: $this->db->where(["id_sesi" => $id]);
goto N4h1h;
GxIkw: }
public function getNamaKelasById($id) { goto MxcwH;
cKL9G: return $this->db->get()->row()->nama_kelas;
goto or1_b;
MxcwH: $this->db->select("nama_kelas");
goto ebLcY;
ebLcY: $this->db->from("master_kelas");
goto yz2U4;
yz2U4: $this->db->where(["id_kelas" => $id]);
goto cKL9G;
or1_b: }
public function getNamaGuruById($id) { goto x89wr;
U0x0f: $this->db->where("id_guru", $id);
goto juVH0;
RnThr: $this->db->from("master_guru");
goto U0x0f;
juVH0: return $this->db->get()->row()->nama_guru;
goto zwO48;
x89wr: $this->db->select("nama_guru");
goto RnThr;
zwO48: }
public function getElapsed($id) { goto sY9H9;
uZ0X3: $this->db->from("cbt_durasi_siswa");
goto UWy7K;
UWy7K: $this->db->where("id_durasi", $id);
goto Ndky1;
sY9H9: $this->db->select("id_durasi, id_siswa, id_jadwal, status, lama_ujian, mulai, selesai, reset");
goto uZ0X3;
Ndky1: return $this->db->get()->row();
goto FmSw_;
FmSw_: }
public function getSoalSiswa($id_bank, $id_siswa) { goto drTyd;
Pdr3w: $this->db->from("cbt_soal_siswa a");
goto H3_2k;
lGDmf: $this->db->where("a.id_siswa", $id_siswa);
goto pI4Iz;
tZlbU: $this->db->order_by("a.no_soal_alias");
goto AFU1b;
pI4Iz: $this->db->order_by("a.jenis_soal");
goto tZlbU;
drTyd: $this->db->select("a.*, b.jenis, b.nomor_soal, b.jawaban");
goto Pdr3w;
bYSfa: $this->db->where("a.id_bank", $id_bank);
goto lGDmf;
AFU1b: return $this->db->get()->result();
goto DDeny;
H3_2k: $this->db->join("cbt_soal b", "b.id_soal=a.id_soal", "left");
goto bYSfa;
DDeny: }
public function getJumlahSoalSiswa($id_bank, $id_siswa) { goto jpkf5;
uNvgC: $result = $this->db->get()->num_rows();
goto pj6Fj;
jpkf5: $this->db->select("id_soal_siswa");
goto sicOg;
pj6Fj: return $result;
goto WVmE_;
HjkP0: $this->db->where("id_bank", $id_bank);
goto fXqU2;
sicOg: $this->db->from("cbt_soal_siswa");
goto HjkP0;
fXqU2: $this->db->where("id_siswa", $id_siswa);
goto uNvgC;
WVmE_: }
public function getALLSoalSiswa($id_bank, $id_siswa) { goto AG_MF;
mcirB: $this->db->where("a.id_siswa", $id_siswa);
goto OCTLj;
H5eL8: $this->db->where("a.id_bank", $id_bank);
goto mcirB;
AG_MF: $this->db->select("a.id_soal_siswa, a.id_bank, a.id_jadwal, a.id_soal, a.id_siswa, a.jenis_soal," . " a.no_soal_alias, a.opsi_alias_a, a.opsi_alias_b, a.opsi_alias_c, a.opsi_alias_d, a.opsi_alias_e," . " a.jawaban_alias, a.jawaban_siswa, a.jawaban_benar, a.point_essai, a.soal_end, a.point_soal," . " b.id_soal, b.nomor_soal, b.soal, b.jawaban, b.opsi_a, b.opsi_b, b.opsi_c, b.opsi_d," . " b.opsi_e, b.tampilkan");
goto D1wsg;
ccCdw: $result = $this->db->get()->result();
goto KCE3u;
D1wsg: $this->db->from("cbt_soal_siswa a");
goto lFx2k;
OCTLj: $this->db->order_by("a.no_soal_alias");
goto ccCdw;
KCE3u: return $result;
goto yE_43;
lFx2k: $this->db->join("cbt_soal b", "b.id_soal=a.id_soal");
goto H5eL8;
yE_43: }
public function getJumlahJawaban($id_bank, $id_siswa) { goto D3kim;
mqsJE: $result = $this->db->get()->result();
goto QExft;
BSFih: $this->db->where("id_siswa", $id_siswa);
goto mqsJE;
Ot9tT: $this->db->where("id_bank", $id_bank);
goto BSFih;
cZZx4: $this->db->from("cbt_soal_siswa");
goto Ot9tT;
D3kim: $this->db->select("jawaban_siswa, id_siswa, id_bank");
goto cZZx4;
QExft: return $result;
goto HWAW_;
HWAW_: }
public function getSoalSiswaByJadwal($id_jadwal, $id_siswa) { goto WB8_h;
DgSHP: return $this->db->get()->result();
goto oqPC6;
PrCVt: $this->db->from("cbt_soal_siswa a");
goto xjFF8;
BJex1: $this->db->order_by("a.jenis_soal");
goto jhAKS;
xjFF8: $this->db->join("cbt_soal b", "b.id_soal=a.id_soal");
goto xCxQ7;
fI2hV: $this->db->where("a.id_siswa", $id_siswa);
goto XiYZv;
xCxQ7: $this->db->where("a.id_jadwal", $id_jadwal);
goto fI2hV;
WB8_h: $this->db->select("a.*, b.jenis, b.nomor_soal, b.soal, b.jawaban, b.opsi_a, b.opsi_b, b.opsi_c, b.opsi_d, b.opsi_e");
goto PrCVt;
XiYZv: $this->db->where("b.tampilkan", "1");
goto BJex1;
jhAKS: $this->db->order_by("b.nomor_soal");
goto DgSHP;
oqPC6: }
public function getSoalSiswaByNomor($id_soal_siswa) { goto QaVX0;
EHzLl: return $this->db->get()->row();
goto xETFR;
QaVX0: $this->db->select("a.id_soal_siswa, a.id_bank, a.opsi_alias_a, a.opsi_alias_b, a.opsi_alias_c, a.opsi_alias_d," . " a.opsi_alias_e, a.no_soal_alias, a.jawaban_alias, a.soal_end, a.jawaban_siswa," . " b.id_soal, b.jenis, b.nomor_soal, b.soal, b.jawaban, b.opsi_a, b.opsi_b, b.opsi_c, b.opsi_d, b.opsi_e, b.tampilkan," . " c.tampil_pg, c.tampil_kompleks, c.tampil_jodohkan, c.tampil_isian, c.tampil_esai,");
goto XyQvW;
dbsdl: $this->db->join("cbt_bank_soal c", "b.id_bank=a.id_bank");
goto TJr0D;
TJr0D: $this->db->where("a.id_soal_siswa", $id_soal_siswa);
goto E38uM;
XyQvW: $this->db->from("cbt_soal_siswa a");
goto MYpXI;
MYpXI: $this->db->join("cbt_soal b", "b.id_soal=a.id_soal");
goto dbsdl;
E38uM: $this->db->order_by("a.no_soal_alias");
goto EHzLl;
xETFR: }
public function getSettingKartu() { goto OZKE_;
uZmDd: return $this->db->get()->row();
goto gw3dS;
n68z_: $this->db->from("cbt_kop_kartu");
goto uZmDd;
OZKE_: $this->db->select("*");
goto n68z_;
gw3dS: }
public function getSettingKopAbsensi() { goto pHF0R;
s5KiK: $this->db->join("setting b", "b.id_setting=1", "left");
goto x2FyK;
culxd: $this->db->from("cbt_kop_absensi a");
goto s5KiK;
x2FyK: return $this->db->get()->row();
goto qHR0L;
pHF0R: $this->db->select("a.*, b.logo_kanan, b.logo_kiri, b.kepsek, b.tanda_tangan");
goto culxd;
qHR0L: }
public function getSettingKopBeritaAcara() { goto mtydb;
v3DWa: return $this->db->get()->row();
goto n7tGw;
mtydb: $this->db->select("a.*, d.logo_kanan, d.logo_kiri, d.kepsek, d.nip, d.tanda_tangan, d.sekolah");
goto uy4pI;
ocGsi: $this->db->join("setting d", "d.id_setting=1", "left");
goto v3DWa;
uy4pI: $this->db->from("cbt_kop_berita a");
goto ocGsi;
n7tGw: }
public function getDurasiSiswa($id) { return $this->db->get_where("cbt_durasi_siswa", "id_durasi=" . $id)->row();
}
public function getFilterJawabanSiswa($jadwal, $arrIdSiswa) { goto P49vZ;
QMzZD: return $this->db->get("cbt_soal_siswa")->result();
goto S3gQe;
kztt9: $this->db->where_in("id_siswa", $arrIdSiswa);
goto QMzZD;
P49vZ: $this->db->where("id_jadwal", $jadwal);
goto kztt9;
S3gQe: }
public function getFilterDurasiSiswa($jadwal, $arrIdSiswa) { goto TJW_P;
NgE3M: foreach ($result as $key => $row) { $ret[$row->id_durasi] = $row;
EF8Dg: } goto rtIez;
sSVQV: return $ret;
goto qb7lD;
ILv_e: $result = $this->db->get_where("cbt_durasi_siswa")->result();
goto OFmrA;
OFmrA: $ret = [];
goto NgE3M;
TJW_P: $this->db->where("id_jadwal", $jadwal);
goto ILv_e;
rtIez: JR2YK: goto sSVQV;
qb7lD: }
public function getJawabanByBank($id_bank, $id_siswa = null) { goto PoHaR;
mO6gw: $result = $this->db->get()->result();
goto RhLR0;
RhLR0: return $result;
goto EEKaz;
C3O8s: $this->db->join("cbt_soal b", "b.id_soal=a.id_soal");
goto WsrLA;
zH65d: $this->db->where("a.id_bank=", $id_bank);
goto mO6gw;
cYxy1: $this->db->where("a.id_siswa=", $id_siswa);
goto JwXnX;
JwXnX: ei12u: goto zH65d;
BnLQl: $this->db->from("cbt_soal_siswa a");
goto C3O8s;
WsrLA: if (!($id_siswa != null)) { goto ei12u;
} goto cYxy1;
PoHaR: $this->db->select("a.*, b.nomor_soal, b.jawaban");
goto BnLQl;
EEKaz: }
public function getJawabanSiswa($id) { goto dYHuS;
dYHuS: $this->db->select("id_soal_siswa, id_bank, id_jadwal, id_soal, id_siswa, jenis_soal, no_soal_alias, opsi_alias_a, opsi_alias_b, opsi_alias_c, opsi_alias_d, opsi_alias_e, jawaban_alias, jawaban_siswa, jawaban_benar, point_soal");
goto o3LlQ;
o3LlQ: $this->db->from("cbt_soal_siswa");
goto t4oUc;
t4oUc: $this->db->where("id_soal_siswa=", $id);
goto JyAj9;
JyAj9: return $this->db->get()->row();
goto Z1RHg;
Z1RHg: }
public function getJawabanSiswaByJadwal($id_jadwal, $id_siswa = null) { goto pW8SW;
nCFa2: lFc7l: goto DCE75;
nz7dj: $this->db->join("cbt_soal b", "b.id_soal=a.id_soal");
goto r7aPa;
x8Rzn: $this->db->where("b.tampilkan", "1");
goto X1GMr;
T9Y6o: goto NSc96;
goto nCFa2;
z6oK6: $this->db->where("a.id_jadwal=", $id_jadwal);
goto x8Rzn;
Ss1Nk: $this->db->from("cbt_soal_siswa a");
goto nz7dj;
X1GMr: $this->db->order_by("a.jenis_soal");
goto Jx6Ty;
insG2: if (is_array($id_siswa)) { goto lFc7l;
} goto MSWnh;
aoyn_: NSc96: goto Jw_lz;
DCE75: $this->db->where_in("a.id_siswa", $id_siswa);
goto aoyn_;
MSWnh: $this->db->where("a.id_siswa", $id_siswa);
goto T9Y6o;
Jx6Ty: $this->db->order_by("b.nomor_soal");
goto DbF9T;
r7aPa: if (!($id_siswa != null)) { goto UbVGm;
} goto insG2;
pW8SW: $this->db->select("a.*, b.jenis, b.nomor_soal, b.soal, b.jawaban, b.opsi_a, b.opsi_b, b.opsi_c, b.opsi_d, b.opsi_e, b.tampilkan");
goto Ss1Nk;
Jw_lz: UbVGm: goto z6oK6;
DbF9T: return $this->db->get()->result();
goto yQRto;
yQRto: }
public function getIdSiswaFromJawabanByJadwal($id_jadwal) { goto lqLKl;
lqLKl: $result = $this->db->get_where("cbt_soal_siswa", "id_jadwal=" . $id_jadwal)->result();
goto pv4gY;
ZfVJH: return $retur;
goto LxEeL;
Ux19J: qXHoD: goto ZfVJH;
pv4gY: $retur = [];
goto wKOZY;
wKOZY: foreach ($result as $row) { $retur[$row->id_siswa][] = $row;
G0POW: } goto Ux19J;
LxEeL: }
public function getDurasiSiswaByJadwal($id_jadwal, $id_siswa = null) { goto U1D4a;
i14bG: if (!($id_siswa != null)) { goto fwhSH;
} goto zuuUv;
MKR3g: return $this->db->get()->result();
goto uKqtX;
zuuUv: $this->db->where("id_siswa=", $id_siswa);
goto OcGRM;
U1D4a: $this->db->select("id_durasi, id_siswa, id_jadwal, status, lama_ujian, mulai, selesai, reset");
goto RHi_f;
OcGRM: fwhSH: goto MKR3g;
rzOFP: $this->db->where("id_jadwal=", $id_jadwal);
goto i14bG;
RHi_f: $this->db->from("cbt_durasi_siswa");
goto rzOFP;
uKqtX: }
public function getIdSiswaFromDurasiByJadwal($id_jadwal) { goto XCq_d;
ovD4Q: FVNbR: goto mXMgl;
mXMgl: return $retur;
goto rLcXz;
lvSNk: foreach ($result as $row) { $retur[$row->id_siswa] = $row;
T36p6: } goto ovD4Q;
wejGj: $retur = [];
goto lvSNk;
XCq_d: $result = $this->db->get_where("cbt_durasi_siswa", "id_jadwal=" . $id_jadwal)->result();
goto wejGj;
rLcXz: }
public function getLogUjianByJadwal($id_jadwal) { goto vnQnb;
k0cyN: $this->db->where("id_jadwal=", $id_jadwal);
goto Xmj68;
Xmj68: return $this->db->get()->result();
goto m1gI4;
ac7Wj: $this->db->from("log_ujian");
goto k0cyN;
vnQnb: $this->db->select("id_log, log_time, id_siswa, id_jadwal, log_type, log_desc, address, agent, device, reset");
goto ac7Wj;
m1gI4: }
public function getIdSiswaFromLogUjianByJadwal($id_jadwal) { goto XisYv;
xXCr0: $retur = [];
goto qeglD;
zv3Gu: return $retur;
goto YcKlh;
qeglD: foreach ($result as $row) { $retur[$row->id_siswa] = $row;
OFIAg: } goto YgJ5k;
YgJ5k: h8q8u: goto zv3Gu;
XisYv: $result = $this->db->get_where("log_ujian", "id_jadwal=" . $id_jadwal)->result();
goto xXCr0;
YcKlh: }
public function getNilaiSiswa($arr_jadwal, $id_siswa) { goto gKj9z;
ghK0Y: foreach ($result as $row) { $retur[$row->id_jadwal] = $row;
LWnlC: } goto jlSXn;
a1uYK: return $retur;
goto qiaKe;
hJ7YC: $retur = [];
goto ghK0Y;
gKj9z: $this->db->select("*");
goto YdIAm;
RPFcq: $this->db->where_in("id_jadwal", $arr_jadwal);
goto B8H2Q;
YdIAm: $this->db->from("cbt_nilai");
goto RPFcq;
jlSXn: oSxqZ: goto a1uYK;
B8H2Q: $this->db->where("id_siswa", $id_siswa);
goto EiQga;
EiQga: $result = $this->db->get()->result();
goto hJ7YC;
qiaKe: }
public function getNilaiSiswaByJadwal($id_jadwal, $id_siswa) { goto yQ5Vx;
D0UEe: return $result;
goto S96AD;
TrfNU: $this->db->where("id_siswa", $id_siswa);
goto QqSVm;
tMwA_: $this->db->where("id_jadwal", $id_jadwal);
goto TrfNU;
QqSVm: $result = $this->db->get()->row();
goto D0UEe;
eEMzh: $this->db->from("cbt_nilai");
goto tMwA_;
yQ5Vx: $this->db->select("*");
goto eEMzh;
S96AD: }
public function getNilaiAllSiswa($arr_jadwal, $arr_id_siswa) { goto Qafmx;
yRy0j: $this->db->from("cbt_nilai");
goto r_bMO;
Qafmx: $this->db->select("*");
goto yRy0j;
FanbG: sp4C2: goto J2euD;
o8YE1: $result = $this->db->get()->result();
goto NMMDd;
hAFOL: $this->db->where_in("id_siswa", $arr_id_siswa);
goto o8YE1;
NMMDd: $retur = [];
goto h4JgV;
J2euD: return $retur;
goto WptGx;
r_bMO: $this->db->where_in("id_jadwal", $arr_jadwal);
goto hAFOL;
h4JgV: foreach ($result as $row) { $retur[$row->id_siswa] = $row;
DqaVQ: } goto FanbG;
WptGx: }
public function getAllNilaiSiswa($id_jadwal) { goto KR4Ht;
CA6Ri: rN1Qc: goto AjH7w;
ZkzxO: foreach ($result as $row) { $retur[$row->id_siswa] = $row;
eP6pv: } goto CA6Ri;
AjH7w: return $retur;
goto CUq10;
n_l6O: $retur = [];
goto ZkzxO;
ro4kE: $this->db->where("id_jadwal", $id_jadwal);
goto owmTK;
KR4Ht: $this->db->select("*");
goto zuhW9;
zuhW9: $this->db->from("cbt_nilai");
goto ro4kE;
owmTK: $result = $this->db->get()->result();
goto n_l6O;
CUq10: }
public function getTotalKoreksi() { goto v2sn_;
eM_Ui: foreach ($result as $row) { goto MkUXH;
MkUXH: if (!($row->id_siswa != null)) { goto Fcl7w;
} goto Me1z3;
Me1z3: $retur[$row->id_jadwal][$row->dikoreksi][] = $row->id_siswa;
goto cPMri;
cPMri: Fcl7w: goto u3zUo;
u3zUo: CDJkH: goto F2mKx;
F2mKx: } goto Xgoas;
wDBaP: $this->db->from("cbt_nilai");
goto ztaQu;
Xgoas: AKFKw: goto wq4Lc;
FBIhw: $retur = [];
goto eM_Ui;
ztaQu: $result = $this->db->get()->result();
goto FBIhw;
v2sn_: $this->db->select("id_jadwal, dikoreksi, id_siswa");
goto wDBaP;
wq4Lc: return $retur;
goto Gc1dW;
Gc1dW: }
public function getNilaiAnalisis($id_jadwal) { return $this->db->get_where("cbt_nilai", "id_jadwal=" . $id_jadwal)->result();
}
public function getLogUjian($siswa_id, $id_jadwal) { return $this->db->get_where("log_ujian", "id_siswa=" . $siswa_id . " AND id_jadwal=" . $id_jadwal)->result();
}
public function getNomorPeserta($id_siswa) { return $this->db->get_where("cbt_nomor_peserta", "id_siswa=" . $id_siswa)->row();
}
public function getAllNomorPeserta() { goto ZknCl;
xa7Zh: foreach ($result as $row) { $ret[$row->id_siswa] = $row;
DHqD0: } goto OVBVO;
ZknCl: $this->db->select("*");
goto Taj9T;
uKkHs: return $ret;
goto F9pEQ;
Gy2hw: $ret = [];
goto xa7Zh;
OVBVO: AfNi2: goto uKkHs;
Taj9T: $result = $this->db->get("cbt_nomor_peserta")->result();
goto Gy2hw;
F9pEQ: }
public function getDistinctTahun() { goto tN3x7;
DmVNY: $result = $this->db->get("cbt_rekap_nilai")->result();
goto LA8Iq;
tN3x7: $this->db->select("tp");
goto BWK38;
R__rR: return $ret;
goto lnKrA;
LA8Iq: $ret = [];
goto c4DnD;
c4DnD: foreach ($result as $row) { $ret[$row->tp] = $row->tp;
XZrda: } goto baTpD;
baTpD: D4j8e: goto R__rR;
BWK38: $this->db->distinct();
goto DmVNY;
lnKrA: }
public function getDistinctSmt() { goto ZW5Dp;
H2B5U: return $ret;
goto QL19y;
ZX_Wv: foreach ($result as $row) { $ret[$row->smt] = $row->smt;
hsjsO: } goto WZCdG;
ZW5Dp: $this->db->select("smt");
goto vExvT;
mxlcH: $ret = [];
goto ZX_Wv;
WZCdG: nV2mQ: goto H2B5U;
vExvT: $this->db->distinct();
goto sKFHv;
sKFHv: $result = $this->db->get("cbt_rekap_nilai")->result();
goto mxlcH;
QL19y: }
public function getDistinctJenisUjian() { goto xRdDd;
Dr64V: iosxP: goto MOfVn;
MOfVn: return $ret;
goto ZSoNK;
xRdDd: $this->db->select("tp, smt, kode_jenis");
goto LS0qY;
LS0qY: $this->db->distinct();
goto kwRzn;
kwRzn: $result = $this->db->get("cbt_rekap_nilai")->result();
goto CdDWE;
PTS0J: foreach ($result as $row) { $ret[$row->tp][$row->smt][$row->kode_jenis] = $row->kode_jenis;
gFzeu: } goto Dr64V;
CdDWE: $ret = [];
goto PTS0J;
ZSoNK: }
public function getDistinctJenis($tp, $smt) { goto MOH8d;
LGlvC: ibiSq: goto TPT19;
VPa9B: $this->db->distinct();
goto u_fke;
MOH8d: $this->db->select("kode_jenis");
goto VPa9B;
D7B2h: $ret = [];
goto CJAnK;
CJAnK: foreach ($result as $row) { $ret[$row->kode_jenis] = $row->kode_jenis;
suQbB: } goto LGlvC;
u_fke: $result = $this->db->get("cbt_rekap_nilai")->result();
goto D7B2h;
TPT19: return $ret;
goto PUSzF;
PUSzF: }
public function getDistinctKelas($id_jadwal = null) { goto tS4pT;
tS4pT: $this->db->select("a.tp, a.smt, a.kode_jenis, a.id_kelas, b.nama_kelas");
goto mbpQU;
pSBkJ: $this->db->where("id_jadwal", $id_jadwal);
goto GgYCg;
akJn0: xLM54: goto pvJHn;
eu_ZR: $result = $this->db->get()->result();
goto hEcEJ;
pvJHn: return $ret;
goto MfWsq;
Iwd1e: $this->db->join("master_kelas b", "b.id_kelas=a.id_kelas");
goto eu_ZR;
GgYCg: KBuQ8: goto Iwd1e;
qIZ1F: if (!($id_jadwal != null)) { goto KBuQ8;
} goto pSBkJ;
mbpQU: $this->db->distinct();
goto be0v8;
ATO23: foreach ($result as $row) { goto dzbU2;
y22Ov: $ret[$row->tp][$row->smt][$row->kode_jenis][$row->id_kelas] = $row->nama_kelas;
goto w5p5a;
w5p5a: yhjO7: goto seAXH;
seAXH: dL7eU: goto W52NF;
dzbU2: if (!($row->id_kelas != '')) { goto yhjO7;
} goto y22Ov;
W52NF: } goto akJn0;
hEcEJ: $ret = [];
goto ATO23;
be0v8: $this->db->from("cbt_rekap_nilai a");
goto qIZ1F;
MfWsq: } }
?>Function Calls
| None |
Stats
| MD5 | ae02117ecdeb25457f4afb215da8a3a2 |
| Eval Count | 0 |
| Decode Time | 112 ms |