public function run()
{
DB::table('mahasiswa')->delete();
DB::table('wali')->delete();
DB::table('dosen')->delete();
$darwis = Dosen::create(array('nama' => 'Darwis', 'nip' => '12321310'));
$nabil = Mahasiswa::create(array('nama' => 'Nabil Farras', 'nim' => '1103124323', 'id_dosen' => $darwis->id));
$dani = Mahasiswa::create(array('nama' => 'Dani Firdaus', 'nim' => '11031202323', 'id_dosen' => $darwis->id));
$this->command->info('Mahasiswa telah diisi!');
Wali::create(array('nama' => 'Darto', 'id_mahasiswa' => $nabil->id));
Wali::create(array('nama' => 'Iman', 'id_mahasiswa' => $dani->id));
}
/**
* Returns the data model based on the primary key given in the GET variable.
* If the data model is not found, an HTTP exception will be raised.
* @param integer $id the ID of the model to be loaded
* @return Dosen the loaded model
* @throws CHttpException
*/
public function loadModel($id)
{
$model = Dosen::model()->findByPk($id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
<?php
/*
|--------------------------------------------------------------------------
| Application Routes
|--------------------------------------------------------------------------
|
| Here is where you can register all of the routes for an application.
| It's a breeze. Simply tell Laravel the URIs it should respond to
| and give it the Closure to execute when that URI is requested.
|
*/
Route::get('/', function () {
return View::make('hello');
});
Route::get('relasi-one', function () {
$mahasiswa = Mahasiswa::where('nim', '=', '1103124323')->first();
return $mahasiswa->wali->nama;
});
Route::get('relasi-Onemany1', function () {
$mahasiswa = Mahasiswa::where('nim', '=', '1103124323')->first();
return $mahasiswa->dosen->nama;
});
Route::get('relasi-Onemany2', function () {
$dosen = Dosen::where('nama', '=', 'Darwis')->first();
foreach ($dosen->mahasiswa as $temp) {
echo '<li> Nama : ' . $temp->nama . ' <strong>' . $temp->nim . '</strong></li>';
}
});
public function getDetail()
{
if (Input::has('kode_jadwal')) {
$kode_jadwal = Input::get('kode_jadwal');
$mk = Jadwal::where("ID_JADWAL", "=", $kode_jadwal);
if ($mk->count() == 1) {
$hari = $mk->get()[0]->HARI;
$arr_hari = array("SENIN", "SELASA", "RABU", "KAMIS", "JUMAT", "SABTU", "MINGGU");
$str_hari = $arr_hari[$hari];
$variables = array("NAMA_MK" => $mk->get()[0]->matakuliah->MATA_KULIAH, "KODE_MK" => $mk->get()[0]->matakuliah->KODE, "NAMA_DOSEN" => $mk->get()[0]->dosen->DOSEN, "KODE_DOSEN" => $mk->get()[0]->dosen->KODE_DOSEN, "RUANGAN" => $mk->get()[0]->ruang->RUANG, "ID_RUANG" => $mk->get()[0]->ruang->ID_RUANG, "KETERANGAN" => $mk->get()[0]->KETERANGAN, "JAM_MULAI" => $mk->get()[0]->JAM_MULAI, "JAM_AKHIR" => $mk->get()[0]->JAM_AKHIR, "JAM_AKHIR" => $mk->get()[0]->JAM_AKHIR, "HARI" => $str_hari);
return View::make('cdetail_jadwal', $variables);
}
} else {
if (Input::has('kode_dosen')) {
$kode_dosen = Input::get('kode_dosen');
$dosen = Dosen::where("KODE_DOSEN", "=", $kode_dosen);
if ($dosen->count() == 1) {
$jadwals = array();
$jadwals_count = array();
for ($i = 0; $i < 7; $i++) {
$jadwals[$i] = Jadwal::whereRaw("KODE_DOSEN = ? AND HARI = ?", array($kode_dosen, $i))->get()->sortBy("JAM_MULAI");
$jadwals_count[$i] = count($jadwals[$i]);
}
$variables = array("NAMA_DOSEN" => $dosen->get()[0]->DOSEN, "KODE_DOSEN" => $dosen->get()[0]->KODE_DOSEN, "JADWALS" => $jadwals, "JADWALS_COUNT" => $jadwals_count);
// var_dump($jadwals);
return View::make('cdetail_dosen', $variables);
}
} else {
if (Input::has('kode_mk')) {
$kode_matakuliah = Input::get('kode_mk');
$matakuliah = Matakuliah::where("KODE", "=", $kode_matakuliah);
if ($matakuliah->count() == 1) {
$jadwals = array();
$jadwals_count = array();
for ($i = 0; $i < 7; $i++) {
$jadwals[$i] = Jadwal::whereRaw("KODE = ? AND HARI = ?", array($kode_matakuliah, $i))->get()->sortBy("JAM_MULAI");
$jadwals_count[$i] = count($jadwals[$i]);
}
$variables = array("MATAKULIAH" => $matakuliah->get()[0]->MATA_KULIAH, "KODE_MATAKULIAH" => $matakuliah->get()[0]->KODE, "JADWALS" => $jadwals, "JADWALS_COUNT" => $jadwals_count);
return View::make('cdetail_matakuliah', $variables);
}
} else {
if (Input::has('id_ruang')) {
$id_ruang = Input::get('id_ruang');
$ruangan = Ruang::where("ID_RUANG", "=", $id_ruang);
if ($ruangan->count() == 1) {
$jadwals = array();
$jadwals_count = array();
for ($i = 0; $i < 7; $i++) {
$jadwals[$i] = Jadwal::whereRaw("ID_RUANG = ? AND HARI = ?", array($id_ruang, $i))->get()->sortBy("JAM_MULAI");
$jadwals_count[$i] = count($jadwals[$i]);
}
$variables = array("RUANGAN" => $ruangan->get()[0]->RUANG, "ID_RUANG" => $ruangan->get()[0]->ID_RUANG, "JADWALS" => $jadwals, "JADWALS_COUNT" => $jadwals_count);
return View::make('cdetail_ruang', $variables);
}
} else {
if (Input::has('hari')) {
$hari = Input::get('hari');
$jadwal = Jadwal::whereRaw("HARI=?", array($hari));
if ($jadwal->count() > 0) {
$variables = array("jadwals" => $jadwal, "HARI" => $hari);
return View::make('cdetail_hari', $variables);
}
}
}
}
}
}
// return View::make('cdetail_jadwal');
}
Route::get('/halo', function () {
return "Halo, bro";
});
Route::get('/', 'JadwalikController@utama');
Route::get('utama', 'JadwalikController@utama');
Route::get('besok', 'JadwalikController@besok');
Route::get('menu', 'JadwalikController@menu');
Route::get('dosen', 'JadwalikController@getDosen');
Route::get('matakuliah', 'JadwalikController@getMataKuliah');
Route::get('ruangan', 'JadwalikController@getRuangan');
Route::get('hari', 'JadwalikController@getHari');
Route::get('detail', 'JadwalikController@getDetail');
Route::get('about', 'JadwalikController@getAbout');
Route::get('getdosen', function () {
$kode_dosen = Input::get("kd");
$dosen = Dosen::whereRaw("KODE_DOSEN=?", array($kode_dosen))->first();
echo "<h1>" . $dosen->DOSEN . "</h1>";
$hari = array("Senin", "Selasa", "Rabu", "Kamis", "Jumat", "Sabtu", "Minggu");
for ($i = 0; $i < count($hari); $i++) {
echo "<h2>" . $hari[$i] . "</h2>";
$jadwals = Jadwal::whereRaw("KODE_DOSEN=? && HARI = ?", array($kode_dosen, $i));
foreach ($jadwals->get()->sortBy("JAM_MULAI") as $j) {
echo $j->matakuliah->MATA_KULIAH . "(" . $j->matakuliah->KODE . ")<br/>";
echo "<small>" . $j->dosen->DOSEN . "(" . $j->dosen->KODE_DOSEN . ")</small><br/>";
echo $j->JAM_MULAI . "-" . $j->JAM_AKHIR . " " . $j->ruang->RUANG . "<br/>";
echo "kelas:" . $j->kelas->NAMA_KELAS . "</br>";
echo "keterangan:" . $j->KETERANGAN . "</br>";
echo "<hr/>";
}
}
});
