public function cetak_guru(Request $request) { $type = $request->input('type'); $guru = Guru::all(); switch ($type) { case 'pdf': $data['guru'] = Guru::all(); $pdf = PDF::loadView('admin.laporan.cetak_guru', $data)->setOrientation('landscape'); return $pdf->stream(); break; case 'excel': Excel::create('Data Guru', function ($excel) use($guru) { //set properties $excel->setTitle('Data Guru')->setCreator('Jamal Apriadi, S.Kom'); $excel->sheet('Laporan Nilai Siswa', function ($sheet) use($guru) { $row = 1; $sheet->row($row, array('No.', 'NIP', 'Nama', 'Mata Pelajaran')); foreach ($guru as $s) { $sheet->row(++$row, array($s->nip, $s->nama, $s->mapel->nm_mapel)); } }); })->export('xls'); break; default: # code... break; } }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Guru::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->andFilterWhere(['tgl_lahir' => $this->tgl_lahir]); $query->andFilterWhere(['wali_kelas' => $this->wali_kelas]); $query->andFilterWhere(['like', 'nip', $this->nip])->andFilterWhere(['like', 'password', $this->password])->andFilterWhere(['like', 'nama', $this->nama])->andFilterWhere(['like', 'alamat', $this->alamat])->andFilterWhere(['like', 'agama', $this->agama])->andFilterWhere(['like', 'email', $this->email])->andFilterWhere(['like', 'jns_kelamin', $this->jns_kelamin])->andFilterWhere(['like', 'tempat_lahir', $this->tempat_lahir])->andFilterWhere(['like', 'no_telp', $this->no_telp])->andFilterWhere(['like', 'foto', $this->foto]); return $dataProvider; }
public function getDelete($id) { $data = ['status' => Guru::remove($id)]; return response()->json($data); }
public static function guru() { $listData = ArrayHelper::map(Guru::find()->all(), 'nip', 'nama'); return $listData; }
/** * @return \yii\db\ActiveQuery */ public function getNipGuru() { return $this->hasOne(Guru::className(), ['nip' => 'nip']); }
/** * Finds the Guru model based on its primary key value. * If the model is not found, a 404 HTTP exception will be thrown. * @param string $id * @return Guru the loaded model * @throws NotFoundHttpException if the model cannot be found */ protected function findModel($id) { if (($model = Guru::findOne($id)) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } }
public function getGuru() { $guru = Guru::find($this->getNip()); return $guru; }
/** * Remove the specified resource from storage. * * @param int $id * @return \Illuminate\Http\Response */ public function destroy($id) { $guru = Guru::find($id); //cek detail_jadwal $detail = DB::table('soal')->where('author', $id)->count(); if ($detail > 0) { Session::flash('pesan', "Data Guru tidak dapat dihapus"); return Redirect::back(); } $guru->delete(); Session::flash('pesan', "Data berhasil dihapus"); return Redirect::to('admin/guru'); }
/** * Remove the specified resource from storage. * * @param int $id * @return \Illuminate\Http\Response */ public function destroy($id) { $guru = Guru::find($id); $guru->delete(); Session::flash('pesan', "Data berhasil dihapus"); return Redirect::to('admin/guru'); }