public function reject($id) { /* Record rejection of event */ $event = Calendar::find($id); $event->delete(); return Redirect::to('admin/calendar/pending'); }
public function destroy(Request $request, $id) { $v = Calendar::find($id); if ($v) { $v->delete(); Calendar::where("id", $id)->where('user_id', Auth::user()->id)->delete(); $request->session()->flash("notif", "schedule successfully deleted"); return ['error' => false]; } else { $request->session()->flash("notif", "schedule not available!"); return ['error' => true]; } }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Calendar::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, 'creator' => $this->creator, 'date_event' => $this->date_event]); $query->andFilterWhere(['like', 'text', $this->text]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Calendar::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); $query->joinWith(['access']); $dataProvider->sort->attributes['access'] = ['asc' => ['tbl_access.user_owner' => SORT_ASC], 'desc' => ['tbl_access.user_owner' => 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(['tbl_calendar.id' => $this->id, 'tbl_calendar.creator' => $this->creator, 'tbl_calendar.date_event' => $this->date_event, 'tbl_access.user_owner' => $this->access['user_owner']]); $query->andFilterWhere(['like', 'tbl_calendar.text', $this->text]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Calendar::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); $query->joinWith(['access']); $dataProvider->sort->attributes['access'] = ['asc' => ['clndr_access.user_id' => SORT_ASC], 'desc' => ['clndr_access.user_id' => 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(['clndr_calendar.id' => $this->id, 'clndr_calendar.creator' => $this->creator, 'clndr_access.user_guest' => $this->access['user_id']]); $query->andWhere('clndr_access.date = date(' . $this->access['date'] . ')'); $query->andWhere('date(clndr_calendar.date_event) = date(' . $this->access['date'] . ')'); $query->andFilterWhere(['like', 'clndr_calendar.text', $this->text]); //VAR_DUMP($query->createCommand()->getRawSql()); return $dataProvider; }
public static function getOtherCalendars() { $dataProvider = new ActiveDataProvider(['query' => \app\models\Calendar::find()->where(['sistem' => 1])]); return $dataProvider; }