public function searchPersonalia($params)
{
// $EMP_ID=Yii::$app->user->identity->EMP_ID;
$profile = Yii::$app->getUserOpt->Profile_user();
$query = ModulEvent::find()->joinWith('modulPesonalia', false)->where(['p0001.USER_ID' => $profile->emp->EMP_ID]);
// add conditions that should always apply here
$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;
}
// grid filtering conditions
$query->andFilterWhere(['MODUL_ID' => $this->MODUL_ID]);
// $query->andFilterWhere(['like', 'title', $this->title])
// ->andFilterWhere(['like', 'USER_ID', $this->USER_ID])
// ->andFilterWhere(['like', 'CREATE_BY', $this->CREATE_BY])
// ->andFilterWhere(['like', 'UPDATE_BY', $this->UPDATE_BY]);
return $dataProvider;
}
public function actionJsoncalendar($start = NULL, $end = NULL, $_ = NULL)
{
//public function actionJsoncalendar(){
$events = array();
$eventCalendar = ModulEvent::find()->all();
//print_r($eventCalendar);
//die();
//Demo
$Event = new \yii2fullcalendar\models\Event();
//FIELD HARUS [id,start,end,title]
header('Content-type: application/json');
echo Json::encode($eventCalendar);
Yii::$app->end();
}
