function tampiljadwal()
{
$konsentrasi = $_GET['konsentrasi'];
$tahun_akademik = $_GET['tahun_akademik'];
$semester = $_GET['semester'];
echo "<table class='table table-bordered' id='jadwal'>\n <tr><th width=7>No</th>\n <th width=120>Hari</th>\n <th>Kode</th>\n <th>Matakuliah</th>\n <th width=5>SKS</th>\n <th width=115>Ruang</th>\n <th width=154>Jam</th>\n <th>Dosen</th>\n <th></th></tr>";
$i = 1;
if ($semester == 0) {
// looping semester
$smt = getField('akademik_konsentrasi', 'jml_semester', 'konsentrasi_id', $konsentrasi);
for ($j = 1; $j <= $smt; $j++) {
echo "<tr class='success'><th colspan=9>SEMESTER {$j}</th></tr>";
$sql = " SELECT jk.*,mm.jam,mm.nama_makul,mm.kode_makul,mm.sks,mm.semester,jk.jam_mulai,jk.jam_selesai\n FROM akademik_jadwal_kuliah as jk,makul_matakuliah as mm\n WHERE mm.makul_id=jk.makul_id and jk.tahun_akademik_id={$tahun_akademik} and jk.konsentrasi_id={$konsentrasi} and jk.semester={$j}";
$data = $this->db->query($sql)->result();
$class = "class='form-control'";
foreach ($data as $r) {
echo "<tr><td>{$i}</td>\n <td>";
echo editcombo('hari', 'app_hari', 'col-sm-14', 'hari', 'hari_id', '', array('onchange' => 'simpanhari(' . $r->jadwal_id . ')', 'id' => 'hariid' . $r->jadwal_id), $r->hari_id);
echo "</td>\n <td>" . strtoupper($r->kode_makul) . "</td>\n <td>" . strtoupper($r->nama_makul) . "</td>\n <td align='center'>{$r->sks}</td>\n <td>";
echo editcombo('ruang', 'app_ruangan', 'col-sm-14', 'nama_ruangan', 'ruangan_id', '', array('onchange' => 'simpanruang(' . $r->jadwal_id . ')', 'id' => 'ruangid' . $r->jadwal_id), $r->ruangan_id);
echo "</td>\n <td>";
echo inputan('text', '', 'col-sm-9', '', 1, $r->jam_mulai, array('onKeyup' => 'simpanjam(' . $r->jadwal_id . ')', 'id' => 'jamid' . $r->jadwal_id));
echo inputan('text', '', 'col-sm-9', '', 1, $r->jam_selesai, array('disabled' => 'disabled'));
//echo editcombo('waktu_kuliah','akademik_waktu_kuliah','col-sm-13','keterangan','waktu_id','',array('onchange'=>'simpanjam('.$r->jadwal_id.')','id'=>'jamid'.$r->jadwal_id),$r->waktu_id);
echo "</td>\n <td>";
echo editcombo('dosen', 'app_dosen', 'col-sm-13', 'nama_lengkap', 'dosen_id', '', array('onchange' => 'simpandosen(' . $r->jadwal_id . ')', 'id' => 'dosenid' . $r->jadwal_id), $r->dosen_id);
echo "</td>\n <td><i class='gi gi-print' title='cetak absen'></i></td></tr>";
$i++;
}
}
} else {
$sql = " SELECT jk.*,mm.jam,mm.nama_makul,mm.kode_makul,mm.sks,mm.semester,jk.jam_mulai,jk.jam_selesai\n FROM akademik_jadwal_kuliah as jk,makul_matakuliah as mm\n WHERE mm.makul_id=jk.makul_id and jk.tahun_akademik_id={$tahun_akademik} and jk.konsentrasi_id={$konsentrasi} and jk.semester={$semester}";
$data = $this->db->query($sql)->result();
$class = "class='form-control'";
foreach ($data as $r) {
echo "<tr><td>{$i}</td>\n <td>";
echo editcombo('hari', 'app_hari', 'col-sm-14', 'hari', 'hari_id', '', array('onchange' => 'simpanhari(' . $r->jadwal_id . ')', 'id' => 'hariid' . $r->jadwal_id), $r->hari_id);
echo "</td>\n <td>" . strtoupper($r->kode_makul) . "</td>\n <td>" . strtoupper($r->nama_makul) . "</td>\n <td align='center'>{$r->sks}</td>\n <td>";
echo editcombo('ruang', 'app_ruangan', 'col-sm-14', 'nama_ruangan', 'ruangan_id', '', array('onchange' => 'simpanruang(' . $r->jadwal_id . ')', 'id' => 'ruangid' . $r->jadwal_id), $r->ruangan_id);
echo "</td>\n <td>";
echo inputan('text', '', 'col-sm-9', '', 1, $r->jam_mulai, array('onKeyup' => 'simpanjam(' . $r->jadwal_id . ')', 'id' => 'jamid' . $r->jadwal_id));
echo inputan('text', '', 'col-sm-9', '', 1, $r->jam_selesai, array('disabled' => 'disabled'));
//echo editcombo('waktu_kuliah','akademik_waktu_kuliah','col-sm-13','keterangan','waktu_id','',array('onchange'=>'simpanjam('.$r->jadwal_id.')','id'=>'jamid'.$r->jadwal_id),$r->waktu_id);
echo "</td>\n <td>";
echo editcombo('dosen', 'app_dosen', 'col-sm-13', 'nama_lengkap', 'dosen_id', '', array('onchange' => 'simpandosen(' . $r->jadwal_id . ')', 'id' => 'dosenid' . $r->jadwal_id), $r->dosen_id);
echo "</td>\n <td><i class='gi gi-print' title='cetak absen'></i></td></tr>";
$i++;
}
}
echo "</table>";
}
?>
</td>
</tr>
<tr>
<td width="050">Prodi / Konsentrasi</td><td>
<div class="col-sm-6">
<?php
$prodi = getField('akademik_konsentrasi', 'prodi_id', 'konsentrasi_id', $r['konsentrasi_id']);
?>
<?php
echo buatcombo('prodi', 'akademik_prodi', '', 'nama_prodi', 'prodi_id', $param, array('id' => 'prodi'));
?>
</div>
<div class="col-sm-6">
<?php
echo editcombo('konsentrasi', 'akademik_konsentrasi', '', 'nama_konsentrasi', 'konsentrasi_id', array('prodi_id' => $prodi), array('id' => 'konsentrasi'), $r['konsentrasi_id']);
?>
</div>
</td>
<td>Penghasilan Ayah, Ibu</td>
<td>
<?php
$penghasilan = array(0 => 'Satu Juta s/d dua juta', 2 => 'Dua Juta s/d Tiga Juta', 3 => 'Tiga Juta Lebih');
?>
<div class="col-sm-6">
<?php
echo form_dropdown('penghasilan_ayah', $penghasilan, $r['penghasilan_ayah'], "class='form-control'");
?>
</div>
<div class="col-sm-6">
</tr>
<tr>
<td width="180">Jenis Kelamin</td><td>
<div class="col-sm-3">
<?php
echo form_dropdown('gender', $gender, $r['gender'], $class);
?>
</div>
</td>
</tr>
<tr>
<td width="150">Agama ,Status Kawin</td><td>
<?php
echo editcombo('agama', 'app_agama', 'col-sm-2', 'keterangan', 'agama_id', '', '', $r['agama_id']);
?>
<div class="col-sm-2">
<?php
echo form_dropdown('kawin', $kawin, $r['status_kawin'], $class);
?>
</div>
</td>
</tr>
<tr>
<td width="150">Alamat</td><td>
<?php
echo textarea('alamat', '', 'col-sm-5', 2, $r['alamat']);
?>
</td>
echo form_open_multipart($this->uri->segment(1) . '/edit');
$jenjang = array('d1' => 'D1', 'd2' => 'D2', 'd3' => 'D3', 'd4' => 'D4', 's1' => 'S1');
echo "<input type='hidden' name='id' value='{$r['konsentrasi_id']}'>";
$semester = array(1 => 1, 2 => 2, 3 => 3, 4 => 4, 5 => 5, 6 => 6, 7 => 7, 8 => 8);
$class = "class='form-control'";
?>
<div class="panel panel-default">
<div class="panel-heading">
<h3 class="panel-title">Edit Record</h3>
</div>
<div class="panel-body">
<table class="table table-bordered">
<tr>
<td width="150">Nama Prodi</td><td>
<?php
echo editcombo('prodi', 'akademik_prodi', 'col-sm-3', 'nama_prodi', 'prodi_id', '', '', $r['prodi_id']);
?>
</td>
</tr>
<tr>
<td width="150">Nama Konsentrasi</td><td>
<?php
echo inputan('text', 'nama', 'col-sm-5', 'Nama prodi ..', 1, $r['nama_konsentrasi'], '');
?>
</td>
</tr>
<tr>
<td width="150">Ketua</td><td>
<?php
echo inputan('text', 'ketua', 'col-sm-4', 'Ketua ..', 0, $r['ketua'], '');
?>
<h3 class="panel-title">Entry Record</h3>
</div>
<div class="panel-body">
<table class="table table-bordered">
<tr>
<td width="150">Nama Submenu</td><td>
<?php
echo inputan('text', 'nama', 'col-sm-4', 'Nama Sub Menu ..', 1, $r['nama_submenu'], '');
?>
</td>
</tr>
<tr>
<td width="150">Mainmenu</td><td>
<?php
echo editcombo('mainmenu', 'mainmenu', 'col-sm-3', 'nama_mainmenu', 'id_mainmenu', '', '', $r['id_mainmenu']);
?>
</td>
</tr>
<tr>
<td width="150">Link</td><td>
<?php
echo inputan('text', 'link', 'col-sm-5', 'Link ...', 1, $r['link'], '');
?>
</td>
</tr>
<tr>
<td width="150">Icon</td><td>
<?php
echo inputan('text', 'icon', 'col-sm-2', 'Icon', 0, $r['icon'], '');
<h3 class="panel-title">Edit Record</h3>
</div>
<div class="panel-body">
<table class="table table-bordered">
<tr>
<td width="150">Nama Ruangan</td><td>
<?php
echo inputan('text', 'nama', 'col-sm-4', 'Nama ruangan ..', 1, $r['nama_ruangan'], '');
?>
</td>
</tr>
<tr>
<td width="150">Gedung</td><td>
<?php
echo editcombo('gedung', 'app_gedung', 'col-sm-7', 'nama_gedung', 'gedung_id', '', '', $r['gedung_id']);
?>
</td>
</tr>
<tr>
<td width="150">Kapasitas</td><td>
<?php
echo inputan('text', 'kapasitas', 'col-sm-3', 'Kapastitas ..', 0, $r['kapasitas'], '');
?>
</td>
</tr>
<tr>
<td width="150">Keterangan</td><td>
<?php
echo inputan('text', 'keterangan', 'col-sm-10', 'Keterangan ..', 0, $r['keterangan'], '');
?>
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>";
}