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']); }