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 hapus_jadwal()
{
if (Request::ajax()) {
$kode = Input::get('kode');
Jadwal::find($kode)->delete();
}
}
<?php
$bulan = date('m');
if ($bulan < 7) {
$smt = 2;
//jika th 2(1-6) maka tahun-1/tahun-2 2012/2013
$th_ajar = date('Y') - 1 . '/' . date('Y');
} elseif ($bulan < 13 && $bulan > 6) {
$smt = 1;
//jika th 1(7-12) maka tahun/tahun+1 2012/2013
$th_ajar = date('Y') . '/' . (date('Y') + 1);
}
?>
<?php
$jadwal = Jadwal::model()->findAll(array('condition' => "kode_guru='" . Yii::app()->user->id . "'"));
foreach ($jadwal as $pg => $pgi) {
?>
<pre>
<?php
echo "Nama\t\t: " . $pgi->kodeGuru->nama_guru . " (" . $pgi->kode_guru . ")" . $form->hiddenField($model, "kode_guru", array('value' => $pgi['kode_guru']));
?>
<?php
echo "Semester\t: " . $smt;
?>
<?php
echo "Mata Pelajaran\t: " . $pgi->kodeMapel->kodeMapel->mapel . " (" . $pgi['kode_mapel'] . ")" . $form->hiddenField($model, "kode_mapel", array('value' => $pgi['kode_mapel']));
?>
<?php
echo "Tahun Ajar\t: " . $th_ajar;
<?php
$idwaktu = CHtml::listData(Jadwal::model()->findAll(array('order' => 'idwaktu ASC', 'select' => 'idwaktu', 'distinct' => true)), 'idwaktu', 'idwaktu');
?>
<?php
echo $form->dropDownListRow($model, 'idwaktu', $idwaktu, array('class' => 'span5', 'empty' => '-- Pilih Waktu --', 'rel' => 'tooltip', 'data-placement' => 'right', 'title' => 'Langkah 1 Pilih Waktu'));
?>
<?php
$kode_guru = CHtml::listData(Jadwal::model()->findAll(array('order' => 'kode_guru ASC', 'select' => 'kode_guru', 'distinct' => true)), 'kode_guru', 'kode_guru');
?>
<?php
echo $form->dropDownListRow($model, 'kode_guru', $kode_guru, array('class' => 'span5', 'empty' => '-- Pilih Kode Guru --', 'rel' => 'tooltip', 'data-placement' => 'right', 'title' => 'Langkah 1 Pilih kode guru'));
?>
<?php
$kode_mapel = CHtml::listData(Jadwal::model()->findAll(array('order' => 'kode_mapel ASC', 'select' => 'kode_mapel', 'distinct' => true)), 'kode_mapel', 'kode_mapel');
?>
<?php
echo $form->dropDownListRow($model, 'kode_mapel', $kode_mapel, array('class' => 'span5', 'empty' => '-- Pilih Kode Mapel --', 'rel' => 'tooltip', 'data-placement' => 'right', 'title' => 'Langkah 1 Pilih kode mata pelajaran'));
?>
<?php
$th_ajar = CHtml::listData(SemesterAktif::model()->findAll(array('order' => 'th_ajar ASC', 'select' => 'th_ajar', 'distinct' => true)), 'th_ajar', 'th_ajar');
?>
<?php
echo $form->dropDownListRow($model, 'th_ajar', $th_ajar, array('class' => 'span5', 'empty' => '-- Pilih Tahun --', 'rel' => 'tooltip', 'data-placement' => 'right', 'title' => 'Langkah 1 Pilih tahun'));
?>
<?php
$smt = CHtml::listData(SemesterAktif::model()->findAll(array('order' => 'semester ASC', 'select' => 'semester', 'distinct' => true)), 'semester', 'semester');
?>
<?php
$form = $this->beginWidget('bootstrap.widgets.TbActiveForm', array('action' => Yii::app()->createUrl($this->route), 'method' => 'get'));
?>
<?php
$kelas = CHtml::listData(Jadwal::model()->findAll(array('condition' => "kode_guru='" . Yii::app()->user->id . "'", 'order' => 'kelas ASC', 'select' => 'kelas', 'distinct' => true)), 'kelas', 'kelas');
?>
<?php
echo $form->dropDownListRow($model2, 'kelas', $kelas, array('class' => 'span5', 'empty' => '-- Pilih Kelas --'));
?>
<?php
$lokal = CHtml::listData(Jadwal::model()->findAll(array('condition' => "kode_guru='" . Yii::app()->user->id . "'", 'order' => 'lokal ASC', 'select' => 'lokal', 'distinct' => true)), 'lokal', 'lokal');
?>
<?php
echo $form->dropDownListRow($model2, 'lokal', $lokal, array('class' => 'span5', 'empty' => '-- Pilih Lokal --'));
?>
<?php
//echo $form->textFieldRow($model,'nis',array('class'=>'span5'));
?>
<?php
//echo $form->textFieldRow($model,'kelas',array('class'=>'span5'));
?>
<?php
//echo $form->textFieldRow($model,'lokal',array('class'=>'span5','maxlength'=>1));
?>
</TD>
<TD ALIGN="CENTER"><CENTER>
<?php
//echo $form->textFieldGroup($model,'ID_KUR',array('widgetOptions'=>array('htmlOptions'=>array('class'=>'span5'))));
?>
<?php
$data = CHtml::listData(Jadwal::model()->findAll(), 'KODE_MK', 'KODE_MK');
echo $form->dropDownListGroup($model, 'KODE_MK', array('wrapperHtmlOptions' => array('class' => 'col-sm-5'), 'widgetOptions' => array('data' => $data, 'htmlOptions' => array())));
?>
</CENTER>
</TD>
<TD ALIGN="CENTER"><CENTER>
<?php
$data = CHtml::listData(Jadwal::model()->findAll(), 'KELAS', 'KELAS');
echo $form->dropDownListGroup($model, 'KELAS', array('wrapperHtmlOptions' => array('class' => 'col-sm-5'), 'widgetOptions' => array('data' => $data, 'htmlOptions' => array())));
?>
<CENTER>
</TD>
</TR>
<TR >
<TD ALIGN="CENTER" COLSPAN="4" ><CENTER>
<div class="form-actions">
<?php
$this->widget('booster.widgets.TbButton', array('buttonType' => 'submit', 'context' => 'primary', 'label' => $model->isNewRecord ? 'Search' : 'Save'));
?>
</div>
</CENTER>
<TD>
</TR>
function get_jadwal($id)
{
return Jadwal::where('id_table', $id)->where('jenis_jadwal', 'pengadaan')->first();
}
<?php
$kelas = "41B";
$mata_kuliah = "IF411111";
$model = BeritaAcaraDaftarHadir::model()->findAllByAttributes(array('TANGGAL' => $message, 'KODE_MK' => $mata_kuliah));
$model2 = Jadwal::model()->findAllByAttributes(array('TANGGAL' => $message, 'KODE_MK' => $mata_kuliah));
$model3 = BeritaAcaraDaftarHadir::model()->findAllByAttributes(array('TANGGAL' => $message, 'KODE_MK' => $mata_kuliah));
$mkul = Kurikulum::model()->findByAttributes(array('KODE_MK' => $mata_kuliah));
$dosen = Pengajar::model()->findByAttributes(array('KODE_MK' => $mata_kuliah));
$criteriaDataIb = new CDbCriteria();
$criteriaDataIb->condition = 'KODE_MK = :kodemk';
$criteriaDataIb->order = 'ID DESC';
$criteriaDataIb->limit = 1;
$criteriaDataIb->params = array('kodemk' => $mata_kuliah);
$tajaran = Jadwal::model()->find($criteriaDataIb);
$imagePath = Yii::getPathOfAlias('application.icons');
$baseUrl = Yii::app()->assetManager->publish($imagePath);
?>
<table>
<tr>
<td>
Institut Teknologi Del <br/>
Jl. Sisingamangaraja, Sitoluama, Laguboti <br/>
Toba Samosir, Sumatera Utara 22381 <br/>
Telp. 0632-331234
</td>
<td></td>
</tr>
<tr>
<td>
<h4><b>Daftar Hadir Mahasiswa Semester 1 T.A 2013/2014</b></h4>
<!-- Menampilkan dialog/popup ketika button di atas di klik -->
<?php
$this->beginWidget('zii.widgets.jui.CJuiDialog', array('id' => 'mydialog', 'options' => array('title' => 'Klik tanda <code>+</code> untuk input data siswa', 'autoOpen' => false, 'modal' => true, 'show' => array('effect' => 'blind', 'duration' => 1000), 'hide' => array('effect' => 'explode', 'duration' => 500), 'width' => 640, 'height' => 480)));
?>
<?php
//echo $this->renderPartial('_caridialog', array('model2'=>$model2,'model'=>$model));
?>
<?php
$this->widget('bootstrap.widgets.TbGridView', array('id' => 'penempatan-grid', 'dataProvider' => $model2->search(), 'type' => 'striped bordered condensed', 'filter' => $model2, 'columns' => array(array('name' => 'kelas', 'type' => 'raw', 'value' => '$data->kelas', 'filter' => CHtml::listData(Jadwal::model()->findAll(array('condition' => "kode_guru='" . Yii::app()->user->id . "'", 'order' => 'kelas ASC', 'select' => 'kelas', 'distinct' => true)), 'kelas', 'kelas')), array('name' => 'lokal', 'type' => 'raw', 'value' => '$data->lokal', 'filter' => CHtml::listData(Jadwal::model()->findAll(array('condition' => "kode_guru='" . Yii::app()->user->id . "'", 'order' => 'lokal ASC', 'select' => 'lokal', 'distinct' => true)), 'lokal', 'lokal')), 'nis', 'nis0.nama_lengkap', array('header' => '', 'type' => 'raw', 'value' => 'CHtml::Button(
"+"
, array(
"class" => "btn submit"
, "id" => "get_link"
, "onClick" => "$(\\"#mydialog\\").dialog(\\"close\\");$(\\"#Nilai_nis \\").val(\\"". $data->nis."\\");
$(\\"#Nilai_kelas \\").val(\\"". $data->kelas."\\");
$(\\"#Nilai_lokal \\").val(\\"". $data->lokal."\\");"))'))));
$this->endWidget('zii.widgets.jui.CJuiDialog');
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/");
}
}
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/>";
}
}
}
});
Route::get('getmatakuliah', function () {
$kode_mk = Input::get("mk");
$matakuliah = Matakuliah::whereRaw("KODE=?", array($kode_mk))->first();
if ($matakuliah != null) {
echo "<h1>" . $matakuliah->MATA_KULIAH . "</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=? && HARI = ?", array($matakuliah->KODE, $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/>";
}
}
}
});
<?php
$kode_guru = User::model()->findAll(array('select' => 'kode_guru', 'condition' => "id='" . Yii::app()->user->id . "'"));
foreach ($kode_guru as $kg) {
$jadwal = Jadwal::model()->findAll(array('condition' => "kode_guru='" . $kg['kode_guru'] . "'"));
foreach ($jadwal as $pg => $pgi) {
$box = $this->beginWidget('bootstrap.widgets.TbBox', array('title' => "Kelas " . $pgi['kelas'] . $pgi['lokal'] . " (" . $pgi['th_ajar'] . "/" . $pgi['semester'] . ")", 'headerIcon' => 'icon-th-list', 'htmlOptions' => array('class' => 'bootstrap-widget-table')));
$form = $this->beginWidget('bootstrap.widgets.TbActiveForm', array('id' => 'nilai-form', 'enableAjaxValidation' => false, 'type' => 'inline', 'htmlOptions' => array('class' => 'well')));
?>
<div class="well"><h5>
<?php
echo "Kode Mapel: " . $pgi['kode_mapel'] . $form->hiddenField($model, "kode_mapel", array('value' => $pgi['kode_mapel']));
?>
<?php
echo "| Nama: " . Yii::app()->user->name . " (" . $pgi['kode_mapel'] . ")" . $form->hiddenField($model, "kode_guru", array('value' => $pgi['kode_guru']));
?>
</h5></div>
<?php
echo $form->errorSummary($model);
?>
<hr>
<p class="help-block">Fields with <span class="required">*</span> are required.</p>
<table class="table table-bordered">
<thead>
<tr>
<th>nis</th>
<th>NAMA</th>
<th>NILAI AKHIR</th>
<th>UJIAN NASIONAL</th>
<th>UJIAN SEKOLAH</th>
<?php
include "jadwal.php";
$atur = new Jadwal();
if (isset($_POST['form_jadwal'])) {
if ($_POST['Nama'] !== "" && $_POST['Telp'] !== "" && $_POST['Email'] !== "" && $_POST['Tgl_Pernikahan'] !== "" && $_POST['Tgl_Temu_WP'] !== "" && $_POST['Tempat_Temu'] !== "") {
$plan = $atur->addPlan($_POST['Nama'], $_POST['Email'], $_POST['Telp'], $_POST['Tgl_Pernikahan'], $_POST['Tgl_Temu_WP'], $_POST['Tempat_Temu']);
header("Location:../view/sukses.php");
} else {
echo "data tidak boleh kosong ya :)";
}
//$plan = $atur->viewPlan();
//include '../view/aturjadwal.php';
}
public function updateJadwal()
{
$rules = array('update_ruang_id' => 'required', 'update_jadwal_hari' => 'required', 'update_shift' => 'required');
$validator = Validator::make(Input::all(), $rules);
if ($validator->fails()) {
return Redirect::to('/kordas/jadwal')->withErrors($validator);
} else {
$shift = Input::get('update_shift');
$JamMulai = "";
$JamSelesai = "";
switch ($shift) {
case "0":
$JamMulai = "Jam Mulai";
$JamSelesai = "Jam Selesai";
break;
case "1":
$JamMulai = "06:30:00";
$JamSelesai = "08:10:00";
break;
case "2":
$JamMulai = "08:30:00";
$JamSelesai = "10:10:00";
break;
case "3":
$JamMulai = "10:30:00";
$JamSelesai = "12:10:00";
break;
case "4":
$JamMulai = "12:30:00";
$JamSelesai = "14:10:00";
break;
case "5":
$JamMulai = "14:30:00";
$JamSelesai = "16:10:00";
break;
case "6":
$JamMulai = "16:30:00";
$JamSelesai = "18:10:00";
break;
case "7":
$JamMulai = "18:30:00";
$JamSelesai = "20:10:00";
break;
}
$jadwal = Jadwal::find(Input::get('update_jadwal_id'));
$jadwal->ruangan_id = Input::get('update_ruang_id');
$jadwal->jadwal_hari = Input::get('update_jadwal_hari');
$jadwal->jadwal_shift = Input::get('update_shift');
$jadwal->jadwal_jam_mulai = $JamMulai;
$jadwal->jadwal_jam_selesai = $JamSelesai;
$jadwal->save();
return Redirect::to('/kordas/jadwal');
}
}
?>
<?php
$this->widget('bootstrap.widgets.TbButton', array('buttonType' => 'reset', 'label' => 'Ulangi', 'icon' => 'icon-refresh icon-white', 'type' => 'danger'));
?>
<?php
$this->widget('bootstrap.widgets.TbButton', array('type' => 'danger', 'icon' => 'icon-share-alt icon-white', 'label' => 'Kembali', 'url' => array('index')));
?>
</div>
<?php
$this->endWidget();
?>
<!-- Menampilkan dialog/popup ketika button di atas di klik -->
<?php
$this->beginWidget('zii.widgets.jui.CJuiDialog', array('id' => 'mydialog', 'options' => array('title' => 'Klik tanda <code>+</code> untuk memilih jam mengajar!', 'autoOpen' => true, 'modal' => true, 'show' => array('effect' => 'blind', 'duration' => 1000), 'hide' => array('effect' => 'explode', 'duration' => 500), 'width' => 640, 'height' => 480)));
$this->widget('bootstrap.widgets.TbGridView', array('id' => 'penempatan-grid', 'dataProvider' => Jadwal::model()->idwaktujurnal(), 'type' => 'striped bordered condensed', 'columns' => array('idwaktu', 'kodeGuru.nama_guru', 'kelas', 'lokal', array('header' => '', 'type' => 'raw', 'value' => 'CHtml::Button(
"+"
, array(
"class" => "btn submit"
, "id" => "get_link"
, "onClick" => "$(\\"#mydialog\\").dialog(\\"close\\");$(\\"#Jurnal_idwaktu \\").val(\\"". $data->idwaktu."\\");
$(\\"#Jurnal_kode_mapel \\").val(\\"". $data->kode_mapel."\\");
$(\\"#Jurnal_kelas \\").val(\\"". $data->kelas."\\");
$(\\"#Jurnal_lokal \\").val(\\"". $data->lokal."\\");
$(\\"#Jurnal_idruang \\").val(\\"". $data->idruang."\\");
$(\\"#Jurnal_kurikulum \\").val(\\"". $data->kurikulum."\\");
"))'))));
$this->endWidget('zii.widgets.jui.CJuiDialog');
}
/**
* 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 the ID of the model to be loaded
*/
public function loadModel($id)
{
$model = Jadwal::model()->findByPk($id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
?>
<?php
?>
<?php
?>
<?php
$kode_mapel = Yii::app()->db->createCommand("select kode_mapel from jadwal where kode_guru='" . Yii::app()->user->id . "';")->queryScalar();
?>
<?php
echo $form->hiddenField($model, 'kode_mapel', array('class' => 'span5', 'maxlength' => 6, 'value' => $kode_mapel));
?>
<?php
$kelasArray = CHtml::listData(Jadwal::model()->findAll(array('order' => 'kelas ASC', 'condition' => "kode_guru='" . Yii::app()->user->id . "'", 'distinct' => true)), 'kelas', 'kelas');
?>
<?php
echo $form->hiddenField($model, 'kelas', array('class' => 'span5', 'maxlength' => 1));
?>
<?php
echo $form->hiddenField($model, 'lokal', array('class' => 'span5', 'maxlength' => 1));
?>
<?php
echo $form->hiddenField($model, 'kode_guru', array('class' => 'span5', 'maxlength' => 2, 'value' => Yii::app()->user->id));
?>
<?php
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);
}
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);
}
