public function setSchedulleDays($model) { if ($model->employee_id > 0) { $employee = MastersEmployees::model()->findByPk($model->employee_id); if (count($employee) == 0) { $model->employee_id = ''; } else { $c = new CDbCriteria(); $c->select = 'schedulle_date, DAY(schedulle_date) AS sch_day, shift_id'; $c->compare('employee_id', $model->employee_id); $c->compare('department_id', $employee->department_id); $c->compare('YEAR(schedulle_date)', $model->year); $c->compare('MONTH(schedulle_date)', $model->month + 1); $schedulles = AttendanceSchedulle::model()->findAll($c); foreach ($schedulles as $schedulle) { $model->days[$schedulle->sch_day] = $schedulle->shift_id; } } } return $model; }
public function actionEmployeeSchedulle() { header('Content-type: application/json'); $schedulles = AttendanceSchedulle::model()->findAll(); $data = array(); foreach ($schedulles as $schedulle) { $data[] = array('title' => $schedulle->shift->name, 'start' => $schedulle->schedulle_date, 'allDay' => true); } echo CJSON::encode($data); }