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
