public function jadwal()
{
$jadwals = Jadwal::where('jadwal_status', '=', 1)->get();
$labs = Lab::where('lab_status', '=', 1)->get();
$ruangs = Ruang::where('ruang_status', '=', 1)->get();
$praktikums = Praktikum::all();
return View::make('dashboard.kordas.DataMaster.jadwal')->with('jadwals', $jadwals)->with('labs', $labs)->with('ruangs', $ruangs)->with('praktikums', $praktikums);
}
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');
}
public function jadwalSimpan($id)
{
$page = Input::get('page');
if ($page == "add") {
$jadwal = Jadwal::where('id_table', '=', $id)->where('jenis_jadwal', '=', 'pengadaan')->update(array('thp1_dari' => date('Y-m-d', strtotime(Input::get('thp1_dari'))), 'thp1_smp' => date('Y-m-d', strtotime(Input::get('thp1_smp'))), 'thp2_dari' => date('Y-m-d', strtotime(Input::get('thp2_dari'))), 'thp2_smp' => date('Y-m-d', strtotime(Input::get('thp2_smp'))), 'thp3_dari' => date('Y-m-d', strtotime(Input::get('thp3_dari'))), 'thp3_smp' => date('Y-m-d', strtotime(Input::get('thp3_smp'))), 'thp4_dari' => date('Y-m-d', strtotime(Input::get('thp4_dari'))), 'thp4_smp' => date('Y-m-d', strtotime(Input::get('thp4_smp'))), 'thp5_dari' => date('Y-m-d', strtotime(Input::get('thp5_dari'))), 'thp5_smp' => date('Y-m-d', strtotime(Input::get('thp5_smp'))), 'thp6_dari' => date('Y-m-d', strtotime(Input::get('thp6_dari'))), 'thp6_smp' => date('Y-m-d', strtotime(Input::get('thp6_smp'))), 'thp7_dari' => date('Y-m-d', strtotime(Input::get('thp7_dari'))), 'thp7_smp' => date('Y-m-d', strtotime(Input::get('thp7_smp'))), 'thp8_dari' => date('Y-m-d', strtotime(Input::get('thp8_dari'))), 'thp8_smp' => date('Y-m-d', strtotime(Input::get('thp8_smp'))), 'thp9_dari' => date('Y-m-d', strtotime(Input::get('thp9_dari'))), 'thp9_smp' => date('Y-m-d', strtotime(Input::get('thp9_smp'))), 'thp10_dari' => date('Y-m-d', strtotime(Input::get('thp10_dari'))), 'thp10_smp' => date('Y-m-d', strtotime(Input::get('thp10_smp'))), 'thp11_dari' => date('Y-m-d', strtotime(Input::get('thp11_dari'))), 'thp11_smp' => date('Y-m-d', strtotime(Input::get('thp11_smp')))));
return Redirect::to("/admin/pengadaan/pilih/" . $id);
} else {
$jadwal = Jadwal::where('id_table', '=', $id)->where('jenis_jadwal', '=', 'pengadaan')->update(array('thp1_dari' => date('Y-m-d', strtotime(Input::get('thp1_dari'))), 'thp1_smp' => date('Y-m-d', strtotime(Input::get('thp1_smp'))), 'thp2_dari' => date('Y-m-d', strtotime(Input::get('thp2_dari'))), 'thp2_smp' => date('Y-m-d', strtotime(Input::get('thp2_smp'))), 'thp3_dari' => date('Y-m-d', strtotime(Input::get('thp3_dari'))), 'thp3_smp' => date('Y-m-d', strtotime(Input::get('thp3_smp'))), 'thp4_dari' => date('Y-m-d', strtotime(Input::get('thp4_dari'))), 'thp4_smp' => date('Y-m-d', strtotime(Input::get('thp4_smp'))), 'thp5_dari' => date('Y-m-d', strtotime(Input::get('thp5_dari'))), 'thp5_smp' => date('Y-m-d', strtotime(Input::get('thp5_smp'))), 'thp6_dari' => date('Y-m-d', strtotime(Input::get('thp6_dari'))), 'thp6_smp' => date('Y-m-d', strtotime(Input::get('thp6_smp'))), 'thp7_dari' => date('Y-m-d', strtotime(Input::get('thp7_dari'))), 'thp7_smp' => date('Y-m-d', strtotime(Input::get('thp7_smp'))), 'thp8_dari' => date('Y-m-d', strtotime(Input::get('thp8_dari'))), 'thp8_smp' => date('Y-m-d', strtotime(Input::get('thp8_smp'))), 'thp9_dari' => date('Y-m-d', strtotime(Input::get('thp9_dari'))), 'thp9_smp' => date('Y-m-d', strtotime(Input::get('thp9_smp'))), 'thp10_dari' => date('Y-m-d', strtotime(Input::get('thp10_dari'))), 'thp10_smp' => date('Y-m-d', strtotime(Input::get('thp10_smp'))), 'thp11_dari' => date('Y-m-d', strtotime(Input::get('thp11_dari'))), 'thp11_smp' => date('Y-m-d', strtotime(Input::get('thp11_smp')))));
$pengadaan = DB::table('pengadaans')->select('desk_kegiatan')->where('id', '=', $id)->first();
Session::flash('messages', '
<div class="alert alert-info alert-dismissable" id="notif">
<button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button>
<p style="font-size:18px"><i class="fa fa-check" ></i> Informasi : Data Jadwal Berhasil di Update </p>
<p>Judul Pengadaan : ' . $pengadaan->desk_kegiatan . ' </p>
</div>
');
return Redirect::to("/admin/pengadaan/");
}
}
function get_jadwal($id)
{
return Jadwal::where('id_table', $id)->where('jenis_jadwal', 'pengadaan')->first();
}
function jadwal($id)
{
$data = new stdclass();
$pengadaan = DB::table("pengadaans")->select('desk_kegiatan')->where("id", $id)->first();
$jadwal = Jadwal::where('id_table', $id)->where('jenis_jadwal', 'rekanan')->first();
$data->id = $id;
$data->thp1_dari = Date::parse($jadwal->thp1_dari)->format('j F Y');
$data->thp1_smp = Date::parse($jadwal->thp1_smp)->format('j F Y');
$data->thp2_dari = Date::parse($jadwal->thp2_dari)->format('j F Y');
$data->thp2_smp = Date::parse($jadwal->thp2_smp)->format('j F Y');
$data->thp3_dari = Date::parse($jadwal->thp3_dari)->format('j F Y');
$data->thp3_smp = Date::parse($jadwal->thp3_smp)->format('j F Y');
$data->thp4_dari = Date::parse($jadwal->thp4_dari)->format('j F Y');
$data->thp4_smp = Date::parse($jadwal->thp4_smp)->format('j F Y');
$data->judul = $pengadaan->desk_kegiatan;
return View::make('master', array('menu' => 'admin.rekanan_menu', 'page' => 'admin.rekanan.form_jadwal'))->with('data', $data);
}
