public function index()
{
$users = User::orderBy('created_at', 'DESC')->paginate(5);
$majors = Major::orderBy('created_at', 'DESC')->paginate(5);
$subjects = Subject::orderBy('created_at', 'DESC')->paginate(5);
$classrooms = Classroom::orderBy('created_at', 'DESC')->paginate(5);
$announcements = Announcement::orderBy('created_at', 'DESC')->paginate(5);
return view('admin.home.home', compact('users', 'majors', 'subjects', 'classrooms', 'announcements'));
}
public function searchRecentAnnouncement($params, $size)
{
$query = Announcement::find()->orderBy(['created_at' => SORT_DESC]);
$dataProvider->sort->attributes['id'] = ['asc' => ['id' => SORT_ASC], 'desc' => ['id' => SORT_DESC]];
$dataProvider = new ActiveDataProvider(['query' => $query, 'sort' => ['defaultOrder' => ['id' => SORT_DESC]], 'pagination' => ['pageSize' => $size]]);
$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;
}
return $dataProvider;
}
public function index()
{
if (Auth::check()) {
if (Auth::user()->hasRole('staff')) {
return redirect()->intended('/lms-admin');
} else {
return redirect()->intended('/home');
}
}
$page_title = 'Login';
$announcements = Announcement::where('status', 'info')->limit(3)->get();
return view('auth.login', compact('page_title', 'announcements'));
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Announcement::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(['id' => $this->id, 'datetime' => $this->datetime, 'Administrator_id' => $this->Administrator_id]);
$query->andFilterWhere(['like', 'title', $this->title])->andFilterWhere(['like', 'content', $this->content]);
return $dataProvider;
}
public function actionIndex()
{
$lastBuildGuide = BuildGuide::getNewestBuildGuide();
if (Yii::$app->user->identity) {
if (Yii::$app->user->identity->isStaff()) {
$lastAnnounsment = Announcement::getNewestAnnounsment();
$newOrderCount = Order::getNewOrders();
return $this->render('staffIndex', ['lastAnnounsment' => $lastAnnounsment, 'newOrderCount' => $newOrderCount]);
} else {
$myBuild = BuildGuide::getMyNewestBuild();
return $this->render('index', ['lastBuildGuide' => $lastBuildGuide, 'myBuild' => $myBuild]);
}
} else {
return $this->render('index', ['lastBuildGuide' => $lastBuildGuide, 'myBuild' => NULL]);
}
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Announcement::find();
$dataProvider = new ActiveDataProvider(['query' => $query]);
$query->joinWith('userFk AS userFk');
$dataProvider->sort->attributes['userFk.username'] = ['asc' => ['userFk.username' => SORT_ASC], 'desc' => ['userFk.username' => SORT_DESC]];
$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(['announcement_id' => $this->announcement_id, 'user_fk' => $this->user_fk, 'announcement_date' => $this->announcement_date]);
$query->andFilterWhere(['like', 'title', $this->title])->andFilterWhere(['like', 'announcement', $this->announcement]);
$query->andFilterWhere(['like', 'userFk.username', $this->getAttribute('userFk.username')]);
return $dataProvider;
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Announcement::find();
$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 $query->asArray()->all();
}
$query->orFilterWhere(['like', 'title', $this->globalSearch])->orFilterWhere(['like', 'content', $this->globalSearch]);
$raw = $query->asArray()->all();
$returnArr = [];
foreach ($raw as $row) {
$detail = substr($row['content'], 0, 200) . '...';
$arrayRow = ['type' => 'announcement', 'id' => $row['id'], 'title' => $row['title'], 'detail' => $detail];
array_push($returnArr, $arrayRow);
}
return $returnArr;
}
public function lastAnnouncement()
{
$announcement = Announcement::find()->orderBy(['id' => SORT_DESC])->one();
return $announcement;
}
public function countAnnouncement()
{
$count = count(Announcement::find()->all());
return $count;
}
public function destroy($id)
{
Announcement::findOrFail($id)->delete();
\Flash::success('Pengumuman berhasil dihapus.');
return redirect()->back();
}
/**
* Finds the Announcement model based on its primary key value.
* If the model is not found, a 404 HTTP exception will be thrown.
* @param integer $id
* @return Announcement the loaded model
* @throws NotFoundHttpException if the model cannot be found
*/
protected function findModel($id)
{
if (($model = Announcement::findOne($id)) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not exist.');
}
}
public static function getNewestAnnounsment()
{
$lastAnnounsment = Announcement::find()->orderBy('announcement_date DESC')->one();
return $lastAnnounsment;
}
/**
* @return \yii\db\ActiveQuery
*/
public function getAnnouncements()
{
return $this->hasMany(Announcement::className(), ['user_fk' => 'user_id']);
}
public function destroy(Request $request, $id)
{
$v = Announcement::find($id);
if ($v) {
// retrieve image detail prior to deletion
$images = DB::table('files')->join('announcement_files', 'files.id', '=', 'announcement_files.file_id')->where('announcement_files.announcement_id', $id)->get();
$res = Announcement::where("id", $id)->where('user_id', Auth::user()->id)->delete();
if ($res) {
// delete also the images from db and local storage
if (count($images) > 0) {
foreach ($images as $image) {
try {
$imgFile = File::find($image->file_id);
if ($imgFile) {
$imgFile->delete();
\Illuminate\Support\Facades\File::delete(MyHelper::getImageFromStorage($id, $imgFile->new_filename));
}
} catch (\Exception $e) {
Log::info($e->getMessage());
}
}
}
$request->session()->flash("notif", "Announcement successfully deleted");
return ['error' => false];
} else {
return ['error' => true, 'message' => 'Failed to delete announcement!'];
}
} else {
$request->session()->flash("notif", "announcement not available!");
return ['error' => true];
}
}
public function index()
{
$announcements = Announcement::orderBy('created_at', 'DESC')->paginate(10);
$page_title = 'Pengumuman';
return view('user.global.announcements', compact('announcements', 'page_title'));
}
public function index()
{
$announcements = Announcement::where('date', '>=', date("Y-m-d"))->orderBy('date', 'asc')->get();
return view('announcements.index', ['announcements' => $announcements]);
}
/**
* Saves the Announcement
*
* @param Announcement $announcement
* @return bool
*/
public function save(Announcement $announcement)
{
return $announcement->save();
}
