function pregistrasi()
{
$id_ms = $_GET['id'];
// get batas registrasi tahun akademik yang aktif
$thun_admk = $this->db->get_where('akademik_tahun_akademik', array('status' => 'y'))->row_array();
$thun_admk = $thun_admk['batas_registrasi'];
if (substr(waktu(), 0, 10) > $thun_admk) {
echo "<div class='alert alert-danger'>Batas Waktu Registrasi Sudah Lewat <i class='gi gi-remove'></i> </div>";
} else {
$sql = $this->db->query("select nim,semester_aktif from student_mahasiswa where mahasiswa_id='{$id_ms}'")->row_array();
$semester = $sql['semester_aktif'] + 1;
$data = array('nim' => $sql['nim'], 'tahun_akademik_id' => get_tahun_ajaran_aktif('tahun_akademik_id'), 'semester' => $semester, 'tanggal_registrasi' => waktu());
$this->db->insert($this->tables, $data);
$this->mcrud->update('student_mahasiswa', array('semester_aktif' => $semester), 'nim', $sql['nim']);
// insert krs automatic
$r = $this->db->query("select semester_aktif,konsentrasi_id from student_mahasiswa where mahasiswa_id='{$id_ms}'")->row_array();
$sms_aktf = $r['semester_aktif'];
$konsentrasi = $r['konsentrasi_id'];
// load jadwal kuliah
$jadwal = " SELECT jk.jadwal_id\n FROM makul_matakuliah as mm, akademik_jadwal_kuliah as jk\n WHERE jk.makul_id=mm.makul_id and mm.semester={$sms_aktf}";
$jadwal = $this->db->query($jadwal)->result();
foreach ($jadwal as $j) {
$this->db->insert('akademik_krs', array('nim' => $sql['nim'], 'jadwal_id' => $j->jadwal_id, 'semester' => $semester));
// insert to khs
$id_krs = $this->db->get_where('akademik_krs', array('nim' => $sql['nim'], 'jadwal_id' => $j->jadwal_id))->row_array();
$this->db->insert('akademik_khs', array('krs_id' => $id_krs['krs_id'], 'mutu' => 0, 'confirm' => '2'));
}
echo "<div class='alert alert-success'>Registrasi Berhasil<i class='gi gi-ok'></i> </div>";
}
}
function load_mahasiswa()
{
$jadwal_id = $_GET['jadwal_id'];
$tanggal = $_GET['tanggal'];
$thn = get_tahun_ajaran_aktif('tahun_akademik_id');
$d = $this->db->query("SELECT ad.nama_lengkap,mm.nama_makul \n FROM app_dosen as ad,makul_matakuliah as mm,akademik_jadwal_kuliah as jk \n WHERE jk.makul_id=mm.makul_id and jk.dosen_id=ad.dosen_id and jk.jadwal_id={$jadwal_id}")->row_array();
$sql = " SELECT sm.nim,sm.nama,kh.mutu,kh.khs_id,kh.tugas,kh.kehadiran,kh.grade\n FROM akademik_krs as ak,student_mahasiswa as sm,akademik_khs as kh,akademik_jadwal_kuliah as jk\n WHERE kh.krs_id=ak.krs_id and sm.nim=ak.nim and ak.jadwal_id='{$jadwal_id}' and jk.jadwal_id=ak.jadwal_id and jk.tahun_akademik_id='{$thn}'";
echo " <table class='table table-bordered'>\n <tr class='success'><th colspan=2>MATAKULIAH</th></tr>\n <tr><td width=120>Matakuliah</td><td>" . strtoupper($d['nama_makul']) . "</td></tr>\n <tr><td>Dosen Pengapu</td><td>" . strtoupper($d['nama_lengkap']) . "</td></tr>\n </table>\n <table class='table table-bordered'>\n <tr class='success'><th colspan=6>DATA MAHASISWA</th></tr>\n <tr><th>No</th><th>NIM</th><th>NAMA MAHASISWA</th><th width=120>Kehadiran</th></tr>";
$data = $this->db->query($sql)->result();
$no = 1;
foreach ($data as $r) {
$absen = array('h' => 'Hadir', 'a' => 'Alpa', 'i' => 'Izin');
echo "<tr>\n <td width='7'>{$no}</td>\n <td width='70'>" . strtoupper($r->nim) . "</td>\n <td>" . strtoupper($r->nama) . "</td>\n <td align='center' width='90'><div class='cols-4'>";
$absensi = $this->db->get_where('student_absen_detail', array('nim' => $r->nim, 'absen_id' => getField('student_absen', 'absen_id', 'tanggal', $tanggal)));
if ($absensi->num_rows() > 0) {
$absensi = $absensi->row_array();
echo form_dropdown('absen', $absen, $absensi['kehadiran'], "class='form-control' id='absenid" . $absensi['detail_id'] . "' onChange='simpanabsen(" . $absensi['detail_id'] . ")'");
//echo inputan('text', '','col-sm-12','Kehadiran', 0, $r->kehadiran,array('onkeyup'=>'simpankehadiran('.$r->khs_id.')','id'=>'ambilkehadiran'.$r->khs_id)).'</td>';
} else {
echo form_dropdown('absen', $absen, '', "class='form-control' onChange='belumabsen()'");
//echo inputan('text', '','col-sm-12','Kehadiran', 0, $r->kehadiran,array('onkeyup'=>'simpankehadiran('.$r->khs_id.')','id'=>'ambilkehadiran'.$r->khs_id)).'</td>';
}
echo "</div></tr>";
$no++;
}
echo " </table>";
}
function loaddata()
{
$id = $_GET['id_mahasiswa'];
$mhs = "SELECT sm.nim,sm.nama,sm.semester_aktif,ap.nama_prodi,ak.nama_konsentrasi\n FROM student_mahasiswa as sm,akademik_konsentrasi as ak,akademik_prodi as ap\n WHERE ap.prodi_id=ak.prodi_id and sm.konsentrasi_id=ak.konsentrasi_id and sm.mahasiswa_id={$id}";
$semester_aktif = getField('student_mahasiswa', 'semester_aktif', 'mahasiswa_id', $id);
$thn = get_tahun_ajaran_aktif('tahun_akademik_id');
$d = $this->db->query($mhs)->row_array();
$nim = getField('student_mahasiswa', 'nim', 'mahasiswa_id', $id);
$krs = "select ak.krs_id,mm.kode_makul,mm.nama_makul,mm.sks,ad.nama_lengkap\n FROM makul_matakuliah as mm,akademik_jadwal_kuliah as jk,akademik_krs as ak,app_dosen as ad\n WHERE mm.makul_id=jk.makul_id and ad.dosen_id=jk.dosen_id and jk.jadwal_id=ak.jadwal_id and jk.tahun_akademik_id='1' and ak.nim='{$nim}' and ak.semester='" . $d['semester_aktif'] . "'";
$data = $this->db->query($krs);
echo "\n <table class='table table-bordered'>\n <tr>\n <td width='150'>NAMA</td><td>" . strtoupper($d['nama']) . "</td>\n <td width=100>NIM</td><td>" . strtoupper($d['nim']) . "</td><td rowspan='2' width='70'><img src='" . base_url() . "assets/images/noprofile.gif' width='50'></td>\n </tr>\n <tr>\n <td>Prodi, Konsentrasi</td><td>" . strtoupper($d['nama_prodi'] . ' / ' . $d['nama_konsentrasi']) . "</td>\n <td>Semester</td><td>" . $d['semester_aktif'] . "</td>\n </tr>\n </table>\n \n <table class='table table-bordered' id='daftarkrs'>\n <tr><th width='5'>No</th>\n <th width='80'>KODE MP</th>\n <th>NAMA MATAKULIAH</th>\n <th width=10>SKS</th>\n <th>DOSEN PENGAPU</th>\n <th width='10'>Hapus</th></tr>";
$sks = 0;
if ($data->num_rows() < 1) {
echo "<tr><td colspan=6>DATA KRS TIDAK DITEMUKAN</td></tr>";
} else {
$no = 1;
foreach ($data->result() as $r) {
echo "<tr id='krshide{$r->krs_id}'>\n <td>{$no}</td>\n <td>" . strtoupper($r->kode_makul) . "</td>\n <td>" . strtoupper($r->nama_makul) . "</td>\n <td align='center'>" . $r->sks . "</td>\n <td>" . strtoupper($r->nama_lengkap) . "</td>\n <td align='center'><i class='fa fa-trash-o' onclick='hapus({$r->krs_id})'></i></td>\n </tr>";
$no++;
$sks = $sks + $r->sks;
}
}
echo "<tr><td colspan='3' align='right'>Total SKS</td><td>{$sks}</td><td colspan=2></td></tr><tr>\n <td colspan=6>\n <button onclick='loadtablemapel({$id})' class='btn btn-primary btn-sm'><i class='gi gi-shopping_cart'></i> Input KRS</button> ";
echo anchor('cetak/kum/' . $d['nim'] . '/' . $semester_aktif, '<i class="gi gi-print"></i> Cetak KUM', array('class' => 'btn btn-success btn-sm'));
echo "</td>\n </tr></table>";
}
</h2>
<div class="push">
<ol class="breadcrumb">
<li><i class='fa fa-home'></i> <a href="javascript:void(0)">Home</a></li>
<li><?php
echo anchor($this->uri->segment(1), $title);
?>
</li>
<li class="active">Data</li>
</ol>
</div>
<div class="col-md-3">
<table class="table table-bordered">
<tr class="success"><th>Kelas Ajar</th></tr>
<tr><th>Tahun Akademik <?php
echo get_tahun_ajaran_aktif('keterangan');
?>
</th></tr>
<td>
<div class="col-md-14">
<select id="jadwal" class="form-control">
<?php
foreach ($kelas as $k) {
echo "<option value='{$k->jadwal_id}'>" . strtoupper($k->nama_makul) . "</option>";
}
?>
</select>
</div>
</td>
</table>
<div id="hasil"></div>
function jadwalngajar()
{
$dosen = $this->session->userdata('keterangan');
$thn = get_tahun_ajaran_aktif('tahun_akademik_id');
$query = "SELECT ak.jenjang,ak.nama_konsentrasi,ar.nama_ruangan,mm.sks,mm.nama_makul,mm.kode_makul,ah.hari,aj.jam_mulai,aj.jam_selesai\n FROM akademik_jadwal_kuliah as aj,app_ruangan as ar,akademik_konsentrasi as ak,makul_matakuliah as mm,app_hari as ah\n WHERE ar.ruangan_id=aj.ruangan_id and ak.konsentrasi_id=aj.konsentrasi_id and mm.makul_id=aj.makul_id and ah.hari_id=aj.hari_id and aj.dosen_id=1 and aj.tahun_akademik_id";
$data['jadwal'] = $this->db->query($query)->result();
$data['title'] = "Jadwal Mengajar";
$data['dosen'] = $dosen;
$this->template->load('template', $this->folder . '/jadwalngajar', $data);
}
function form_berinilai()
{
$jadwal_id = $_GET['jadwal_id'];
$thn = get_tahun_ajaran_aktif('tahun_akademik_id');
$d = $this->db->query("SELECT ad.nama_lengkap,mm.nama_makul \n FROM app_dosen as ad,makul_matakuliah as mm,akademik_jadwal_kuliah as jk \n WHERE jk.makul_id=mm.makul_id and jk.dosen_id=ad.dosen_id and jk.jadwal_id={$jadwal_id}")->row_array();
$sql = " SELECT sm.nim,sm.nama,kh.mutu,kh.khs_id,kh.tugas,kh.kehadiran,kh.grade\n FROM akademik_krs as ak,student_mahasiswa as sm,akademik_khs as kh,akademik_jadwal_kuliah as jk\n WHERE kh.krs_id=ak.krs_id and sm.nim=ak.nim and ak.jadwal_id='{$jadwal_id}' and jk.jadwal_id=ak.jadwal_id and jk.tahun_akademik_id='{$thn}'";
echo " <table class='table table-bordered'>\n <tr class='success'><th colspan=2>MATAKULIAH</th></tr>\n <tr><td width=120>Matakuliah</td><td>" . strtoupper($d['nama_makul']) . "</td></tr>\n <tr><td>Dosen Pengapu</td><td>" . strtoupper($d['nama_lengkap']) . "</td></tr>\n </table>\n <table class='table table-bordered'>\n <tr class='success'><th colspan=7>FORM NILAI MAHASISWA</th></tr>\n <tr><th>No</th><th>NIM</th><th>NAMA MAHASISWA</th><th width=90>Kehadiran</th><th width=90>Tugas</th><th width=90>Mutu</th><th>Grade</th></tr>";
$data = $this->db->query($sql)->result();
$no = 1;
foreach ($data as $r) {
echo "<tr>\n <td width='7'>{$no}</td>\n <td width='70'>" . strtoupper($r->nim) . "</td>\n <td>" . strtoupper($r->nama) . "</td>\n <td align='center' width='90'>";
echo inputan('text', '', 'col-sm-12', 'Kehadiran', 0, $r->kehadiran, array('onkeyup' => 'simpankehadiran(' . $r->khs_id . ')', 'id' => 'ambilkehadiran' . $r->khs_id)) . '</td><td>';
echo inputan('text', '', 'col-sm-12', 'Tugas ..', 0, $r->tugas, array('onkeyup' => 'simpantugas(' . $r->khs_id . ')', 'id' => 'ambiltugas' . $r->khs_id)) . '</td><td>';
echo inputan('text', 'link', 'col-sm-12', 'Link ...', 1, $r->mutu, array('onkeyup' => 'simpan(' . $r->khs_id . ')', 'id' => 'ambil' . $r->khs_id));
echo "</td>\n <td width='80'>";
echo editcombo('grade', 'app_nilai_grade', 'col-sm-14', 'grade', 'grade', '', array('onChange' => 'simpangrade(' . $r->khs_id . ')', 'id' => 'ambilgrade' . $r->khs_id), $r->grade);
echo "</td>\n </tr>";
$no++;
}
echo " </table>";
}
