/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Events::find();
$dataProvider = new ActiveDataProvider(['query' => $query]);
$this->load($params);
if (!$this->validate()) {
// uncomment the following line if you do not want to any records when validation fails
// $query->where('0=1');
return $dataProvider;
}
$query->andFilterWhere(['event_id' => $this->event_id, 'event_start_date' => $this->event_start_date, 'event_end_date' => $this->event_end_date, 'event_type' => $this->event_type, 'event_all_day' => $this->event_all_day, 'created_at' => $this->created_at, 'created_by' => $this->created_by, 'updated_at' => $this->updated_at, 'updated_by' => $this->updated_by, 'is_status' => $this->is_status]);
$query->andFilterWhere(['like', 'event_title', $this->event_title])->andFilterWhere(['like', 'event_detail', $this->event_detail])->andFilterWhere(['like', 'event_url', $this->event_url]);
return $dataProvider;
}
public function actionViewEvents($start = NULL, $end = NULL, $_ = NULL)
{
\Yii::$app->response->format = \yii\web\Response::FORMAT_JSON;
$eventList = Events::find()->where(['is_status' => 0])->all();
$events = [];
foreach ($eventList as $event) {
$Event = new \yii2fullcalendar\models\Event();
$Event->id = $event->event_id;
$Event->title = $event->event_title;
$Event->description = $event->event_detail;
$Event->start = $event->event_start_date;
$Event->end = $event->event_end_date;
$Event->color = $event->event_type == 1 ? '#00A65A' : ($event->event_type == 2 ? '#00C0EF' : ($event->event_type == 3 ? '#F39C12' : '#074979'));
$Event->textColor = '#FFF';
$Event->borderColor = '#000';
$Event->event_type = $event->event_type == 1 ? 'Holiday' : ($event->event_type == 2 ? 'Important Notice' : ($event->event_type == 3 ? 'Meeting' : 'Messages'));
$Event->allDay = $event->event_all_day == 1 ? true : false;
// $Event->url = $event->event_url;
$events[] = $Event;
}
return $events;
}