public function simpan_jadwal()
{
if (Request::ajax()) {
$setting = Setting::first();
$hari = Input::get('hari');
$guru = Input::get('guru');
$rombel = Input::get('rombel');
$jam = Input::get('jam');
$mapel = Input::get('mapel');
$cek = DB::table('jadwal')->where('kd_rombel', '=', $rombel)->where('hari', '=', $hari)->where('jam_ke', '=', $jam)->count();
if ($cek > 0) {
echo "error";
} else {
//cek apakah guru ini sudah mengajar ditempat lain atau belum
$cekguru = DB::table('jadwal')->where('kd_rombel', 'like', $setting->dari_tahun . '-' . $setting->sampai_tahun . "%")->where('id_guru', '=', $guru)->where('hari', '=', $hari)->where('jam_ke', '=', $jam)->where('kd_mapel', '=', $mapel)->count();
if ($cekguru > 0) {
echo "error2";
} else {
$jadwal = new Jadwal();
$jadwal->kd_rombel = Input::get('rombel');
$jadwal->hari = Input::get('hari');
$jadwal->jam_ke = Input::get('jam');
$jadwal->id_guru = Input::get('guru');
$jadwal->kd_mapel = Input::get('mapel');
$jadwal->save();
echo "sukses";
}
}
}
}
public function pengadaan_simpan()
{
$id = DB::table('pengadaans')->insertGetId(array('no_srt_permintaan' => Input::get('no_permintaan'), 'id_users' => Session::get('id_user'), 'sifat' => Input::get('sifat'), 'desk_kegiatan' => Input::get('desk_keg'), 'id_cat' => Input::get('jenis'), 'lokasi_kegiatan' => Input::get('lokasi'), 'alamat_pengerjaan' => Input::get('alamat'), 'telp_lokasi_pengerjaan' => Input::get('telp'), 'website' => Input::get('website'), 'sumber_dana' => Input::get('sumber_dana'), 'thn_anggaran' => Input::get('tahun'), 'pagu' => Input::get('pagu'), 'status' => 0, 'aksi' => 0));
/*$pengadaan = new Proyek();
$pengadaan->no_srt_permintaan = Input::get('no_permintaan');
$pengadaan->id_users = Session::get('id_user');
$pengadaan->sifat = Input::get('sifat');
$pengadaan->desk_kegiatan = Input::get('desk_keg');
$pengadaan->id_cat = Input::get('jenis');
$pengadaan->lokasi_kegiatan = Input::get('lokasi');
$pengadaan->alamat_pengerjaan = Input::get('alamat');
$pengadaan->telp_lokasi_pengerjaan = Input::get('telp');
$pengadaan->website = Input::get('website');
$pengadaan->sumber_dana = Input::get('sumber_dana');
$pengadaan->thn_anggaran = Input::get('tahun');
$pengadaan->pagu = Input::get('pagu');
$pengadaan->status ="0";
$pengadaan->aksi ="0";
$pengadaan->save();
*/
$jadwal = new Jadwal();
$jadwal->id_table = $id;
$jadwal->jenis_jadwal = "pengadaan";
$jadwal->thp1_dari = date('Y-m-d');
$jadwal->thp1_smp = date('Y-m-d');
$jadwal->save();
return Redirect::to('admin/permintaan/add/' . $id);
}
public function actionCek()
{
$model = new Jadwal();
// Uncomment the following line if AJAX validation is needed
// $this->performAjaxValidation($model);
if (isset($_POST['Jadwal'])) {
$model->attributes = $_POST['Jadwal'];
if ($model->save()) {
$this->redirect(array('view', 'id' => $model->ID));
}
}
$this->render('create', array('model' => $model));
}
public function storeJadwal()
{
$rules = array('lab_nama' => 'required', 'praktikum_id' => 'required', 'ruang_id' => 'required', 'jadwal_hari' => 'required', 'shift' => 'required', 'JamMulai' => 'required', 'JamSelesai' => 'required');
$validator = Validator::make(Input::all(), $rules);
if ($validator->fails()) {
return Redirect::to('/kordas/jadwal')->withErrors($validator);
} else {
$praktikum_nama = Praktikum::where('praktikum_id', '=', Input::get('praktikum_id'))->pluck('praktikum_nama');
$lab = strtoupper(substr(Input::get('lab_nama'), 0, 3));
$praktikum = strtoupper(substr($praktikum_nama, 0, 3));
$tahun = substr(date("Y"), -2);
$kode_ruang = Input::get('ruang_id');
$shift = Input::get('shift');
$jadwal_hari = Input::get('jadwal_hari');
$jadwal_hari_angka = 0;
if ($jadwal_hari === "Senin") {
$jadwal_hari_angka = 1;
} elseif ($jadwal_hari === "Selasa") {
$jadwal_hari_angka = 2;
} elseif ($jadwal_hari === "Rabu") {
$jadwal_hari_angka = 3;
} elseif ($jadwal_hari === "Kamis") {
$jadwal_hari_angka = 4;
} elseif ($jadwal_hari === "Jumat") {
$jadwal_hari_angka = 5;
} elseif ($jadwal_hari === "Sabtu") {
$jadwal_hari_angka = 6;
} else {
$jadwal_hari_angka = 0;
}
$format = $lab . "-" . $praktikum . "-" . $tahun . $kode_ruang . "-" . $shift . "-" . $jadwal_hari_angka;
$jadwal = new Jadwal();
$jadwal->jadwal_nama = $format;
$jadwal->jadwal_shift = $shift;
$jadwal->jadwal_jam_mulai = Input::get('JamMulai');
$jadwal->jadwal_jam_selesai = Input::get('JamSelesai');
$jadwal->ruangan_id = Input::get('ruang_id');
$jadwal->jadwal_hari = $jadwal_hari_angka;
$jadwal->jadwal_status = "1";
$jadwal->praktikum_id = Input::get('praktikum_id');
$jadwal->save();
return Redirect::to('/kordas/jadwal');
}
}
function negoSimpan($id)
{
$cek = $this->get_nego_null($id);
if ($cek > 1) {
Session::flash('messages', '
<div class="alert alert-danger alert-dismissable" style="margin-bottom:-20px;">
<button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button>
<strong>Peringatan...</strong><br>
Masih terdapat <strong>' . $cek . ' barang</strong> yang belum diisi harganya
</div>
');
//echo Input::get('hps_rekanan');
return Redirect::to('/admin/pengadaan/negosiasi/' . $id);
} else {
$pengadaan = Proyek::find($id);
$pengadaan->hps_deal = Input::get('hps_negosiasi');
$pengadaan->status = 3;
$pengadaan->aksi = 3;
$pengadaan->save();
$jadwal = Jadwal::where('id_table', $id)->where('jenis_jadwal', 'rekanan')->get();
if (count($jadwal) == 0) {
$data = new Jadwal();
$data->id_table = $id;
$data->jenis_jadwal = "rekanan";
$data->save();
}
Session::flash('messages', '
<div class="alert alert-info alert-dismissable" id="notif">
<button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button>
<strong>Informasi...</strong><br>
Negosiasi sudah di simpan
</div>
');
return Redirect::to('admin/pengadaan/');
}
}
