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;
}
