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>"; }