/** * Finds the UserActivity model based on its primary key value. * If the model is not found, a 404 HTTP exception will be thrown. * @param integer $id * @return UserActivity the loaded model * @throws NotFoundHttpException if the model cannot be found */ protected function findModel($id) { if (($model = DataManagement::findOne($id)) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } }
<div class="navbar-custom-menu"> <ul class="nav navbar-nav"> <?php if (Yii::$app->user->isGuest) { ?> <li class=""> <?php echo Html::a('Log In', ['/login'], ['data-method' => 'post', 'class' => 'btn btn-flat']); ?> </li> <?php } else { $base = DataManagement::findOne(['nik' => Yii::$app->user->getId()]); $user = User::findOne(['id' => Yii::$app->user->getId()]); if (!empty($base)) { $name = $base->nama; } else { $name = $user->username; } ?> <li class="dropdown user user-menu"> <a href="#" class="dropdown-toggle" data-toggle="dropdown"> <span class="hidden-xs"> <?php echo $name; ?> </span> </a>
$data = BaseUpdatable::find()->select('nik')->where(['no_kk' => $model->id, 'status_keluarga' => 3])->asArray()->all(); $istri = BaseUpdatable::find()->select('nik')->where(['no_kk' => $model->id, 'status_keluarga' => 2])->one()['nik']; $nik = ""; foreach ($data as $val) { if ($nik != "") { $nik .= ","; } $nik .= $val['nik']; } if (!empty($nik)) { $dataNama = DataManagement::find()->select('nama')->where('nik in (' . $nik . ')')->asArray()->all(); } else { $dataNama = []; } $namaIstri = DataManagement::findOne($istri)['nama']; $nama = ""; foreach ($dataNama as $val) { if ($nama != "") { $nama .= ", "; } $nama .= $val['nama']; } ?> <?php echo DetailView::widget(['model' => $model, 'attributes' => ['id', ['attribute' => 'kepala_keluarga', 'value' => DataManagement::findOne($model->kepala_keluarga)->nama], 'tanggal_terbit', 'tanggal_pembaruan', ['label' => 'Status', 'value' => $model->status == 1 ? 'Aktif' : 'Tidak Aktif'], ['label' => 'Anak', 'value' => $nama], ['label' => 'Istri', 'value' => $namaIstri]]]); ?> </div><!--box footer--> </div><!--box--> </div> </div>
private function exportAktivitasUser() { $isi = UserActivity::find()->orderBy('timestamp desc')->asArray()->all(); //VarDumper::dump($isi,5678); $filename = 'Data_Aktivitas_User-' . Date('YmdGis') . '.xls'; header("Content-type: application/msexcel"); header("Content-Disposition: attachment; filename=" . $filename); header("Pragma: no-cache"); header("Expires: 0"); echo "<style> .str{ mso-number-format:\\@; } </style>"; echo '<table border="1" width="100%"> <thead> <tr> <th>NIK</th> <th>Nama</th> <th>Aksi</th> <th>Timestamp</th> </tr> </thead>'; foreach ($isi as $data) { $nama = DataManagement::findOne($data['nik'])->nama; echo ' <tr> <td>' . $data['nik'] . '</td> <td>' . $nama . '</td> <td>' . $data['action'] . '</td> <td>' . $data['timestamp'] . '</td> </tr> '; } }