public function sqlLaporan() { $username = Yii::$app->user->identity->username; $connection = \Yii::$app->db; if (strtolower(Yii::$app->user->identity->level) == 'siswa') { $query = "SELECT * FROM siswa where email='{$username}';"; } if (strtolower(Yii::$app->user->identity->level) == 'guru') { $nip = Data::nip_guru(); $query = "SELECT * FROM matapelajaran_guru where nip='{$nip}';"; } $model = $connection->createCommand($query); $data = $model->queryAll(); $idkelas = null; $walikelas = Data::isWaliKelas(); if ($walikelas) { $idkelas = $walikelas['id_kelas']; } else { $idkelas = $data[0]['id_kelas']; } if ($idkelas) { $query = "SELECT\n nis,nama,kelas,minat,psikotes,tahun_ajaran,\n -- group_concat(penjurusan) as penjurusan,\n group_concat(penjurusan) as penjurusan,\n group_concat(bobot_nilai) as nilai_bobot,\n concat(minat,'<br>',bobot_minat) as nilai_bobot_minat,\n concat(minat,'<br>',bobot_psikotes) as nilai_bobot_psikotes,\n group_concat((bobot_nilai+bobot_minat+bobot_psikotes)) AS total,\n group_concat(penjurusan,'=',(bobot_nilai+bobot_minat+bobot_psikotes)) AS keputusan\n FROM nilai_pembobotan_kriteria where id_kelas=" . $idkelas . " group by nis ORDER BY nis,penjurusan DESC"; $dataProvider = new SqlDataProvider(['sql' => $query]); return $dataProvider; } else { throw new NotFoundHttpException('Guru Belum Diberikan Akses Ke kelas.'); } }
public function sqlWaliKelas() { $nip = null; if (Yii::$app->user->identity->level == 'guru') { $nip = Data::nip_guru(); } if (empty($nip)) { throw new NotFoundHttpException('Maaf Anda Tidak Diizinkan untuk mengakses halaman ini.'); } $walikelas = Data::isWaliKelas(); if (empty($walikelas)) { throw new NotFoundHttpException('Maaf Anda Tidak Diizinkan untuk mengakses halaman ini.'); } if (empty($walikelas['id_kelas'])) { throw new NotFoundHttpException('Maaf Anda Tidak Diizinkan untuk mengakses halaman ini.'); } $query = "SELECT n.`id_nilai`,n.`nis`,s.`id_kelas` ,concat(`k`.`kelas`, `k`.`sub_kls`) AS `kelas`\n ,s.`nama`,mp.`matapelajaran`,n.`nilai` FROM\n nilai n JOIN matapelajaran_guru mg ON n.`id_matapelajaran`=mg.`id_matapelajaran_guru`\n JOIN guru g ON mg.nip=g.`nip`\n JOIN siswa s ON s.`nis`=n.`nis`\n JOIN matapelajaran mp ON mp.`id_matapelajaran`=mg.`id_matapelajaran`\n join kelas k on k.id_kelas=s.id_kelas\n WHERE k.id_kelas=" . $walikelas['id_kelas']; $count = Yii::$app->db->createCommand($query)->queryScalar(); $dataProvider = new SqlDataProvider(['sql' => $query, 'totalCount' => (int) $count, 'pagination' => ['pagesize' => 100]]); return $dataProvider; }
?> </li> <!-- <li class="list-group-item"><?php echo Html::a('PENGAMPU', ['/matapelajaran-guru'], ['class' => 'btn btn-sm btn-primary btn-block']); ?> </li> --> <li class="list-group-item"><?php echo Html::a('NILAI', ['/nilai'], ['class' => 'btn btn-sm btn-primary btn-block']); ?> </li> <li class="list-group-item"><?php echo Html::a('BERITA', ['/berita'], ['class' => 'btn btn-sm btn-primary btn-block']); ?> </li> <?php if (\app\models\Data::isWaliKelas()) { ?> <li class="list-group-item"><?php echo Html::a('PENJURUSAN', ['/hasil-pembobotan'], ['class' => 'btn btn-sm btn-primary btn-block']); ?> </li> <li class="list-group-item"><?php echo Html::a('NILAI SISWA KELAS', ['/nilai/walikelas'], ['class' => 'btn btn-sm btn-primary btn-block']); ?> </li> <?php } ?> </ul> <?php