public function actionDosen()
{
$dosen = AitkRDosen::findOne(['account_id' => Yii::$app->user->id]);
/* HAPUS INI UNTUK PENGGUNAAN RBAC */
/* * **** */
if (!isset($dosen)) {
throw new \yii\web\HttpException(403, 'You not authorized to enter this', 405);
}
if (Yii::$app->user->isGuest) {
$this->redirect(Yii::$app->homeUrl);
}
/* * **** */
$matkul = \backend\modules\aitk\models\AitkDosenmatakuliah::findAll(['dosen_id' => $dosen->dosen_id]);
$arrMtaId = array();
foreach ($matkul as $mta) {
$arrMtaId[] = $mta["matakuliah_id"];
}
$allIzin = AitkMatakuliahizin::find()->where(["matakuliah_id" => $arrMtaId])->all();
$searchModel = new AitkRequestSearch();
$dataProvider = $searchModel->search(Yii::$app->request->queryParams);
return $this->render('dosen', ['searchModel' => $searchModel, 'dataProvider' => $dataProvider, 'dosen' => $dosen, 'allIzin' => $allIzin]);
}
public function InsertMatakuliahizin($request_id)
{
$allIzin = AitkTemptable::findAll(['request_id' => $request_id]);
$rows = array();
foreach ($allIzin as $izin) {
$rows[] = ['matakuliah_id' => $izin->matakuliah_id, 'sesi' => $izin->sesi, 'request_id' => $izin->request_id];
}
Yii::$app->db->createCommand()->batchInsert(AitkMatakuliahizin::tableName(), ['matakuliah_id', 'sesi', 'request_id'], $rows)->execute();
}
/**
* @return \yii\db\ActiveQuery
*/
public function getAitkMatakuliahizins()
{
return $this->hasMany(AitkMatakuliahizin::className(), ['dosen_id' => 'dosen_id']);
}
</li>
</ul>
<span class=" label label-success ">
* Lainnya : Data yang dengan pengisian form tidak lengkap oleh mahasiswa.
</span>
</div>
<div class="col-lg-12">
<div class="table-responsive">
<?php
Pjax::begin();
$dataProvider = new ActiveDataProvider(['query' => AitkMatakuliahizin::find()->where(['matakuliah_id' => $ObjMatakuliah->matakuliah_id]), 'pagination' => ['pageSize' => 3], 'sort' => ['defaultOrder' => ['request_id' => SORT_DESC]]]);
echo GridView::widget(['dataProvider' => $dataProvider, 'showOnEmpty' => false, 'columns' => [['class' => 'yii\\grid\\SerialColumn'], ['attribute' => 'request_id', 'value' => 'request.waktu_start', 'label' => 'Tanggal Request'], ['attribute' => 'sesi', 'label' => 'Sesi', 'format' => 'raw', 'value' => function ($data) {
return $data->sesi === 'T' ? "<span class='label label-info'>Teori</span>" : "<span class='label label-warning'>Praktikum</span>";
}], ['attribute' => 'request_id', 'value' => 'request.mahasiswa.nama_mahasiswa', 'label' => 'Mahasiswa'], ['attribute' => 'request_id', 'value' => 'request.mahasiswa.kelas.kode_kelas', 'label' => 'Kelas']]]);
Pjax::end();
?>
</div>
</div>
</div>
</div>
</div>
<?php
$i++;
}
/**
* @return \yii\db\ActiveQuery
*/
public function getAitkMatakuliahizin()
{
return $this->hasOne(AitkMatakuliahizin::className(), ['matakuliahizin_id' => 'matakuliah_id']);
}
