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