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;
}
/**
* Creates a new Berita model.
* If creation is successful, the browser will be redirected to the 'view' page.
* @return mixed
*/
public function actionCreate()
{
$model = new Berita();
if ($model->load(Yii::$app->request->post())) {
$model->nip = \app\models\Data::nip_guru();
$model->tgl_input = date('Y-m-d H:i:S');
$model->isi_berita = $_POST['Berita']['isi_berita'];
// echo '<pre>';
// print_r($model);
// die();
if (!empty($model->nip)) {
if ($model->save()) {
Yii::$app->session->setFlash('success', 'Simpan Berhasil');
} else {
Yii::$app->session->setFlash('warning', 'Failed');
}
} else {
Yii::$app->session->setFlash('warning', 'Maaf Anda Bukan Guru');
}
} else {
Yii::$app->session->setFlash('danger', 'Error');
}
return $this->redirect(['index']);
}
