public function dateCheck($attribute) { $time = strtotime($this->{$attribute}); if ($this->isNewRecord && $time < strtotime(date('Y-m-d'))) { $this->addError($attribute, 'Нельзя установить дату меньше сегоднешней'); } elseif (($semester = Semesters::model()->find('start_date <= :date AND end_date >= :date', [':date' => $this->{$attribute}])) && $semester->id !== $this->id) { $this->addError($attribute, 'Уже есть семестр который перекрывают данную дату'); } }
public function actionCreate() { $model = new Holiday('insert'); $semester = Semesters::model()->actual(); if (Yii::app()->request->isPostRequest) { $holiday = Yii::app()->request->getParam('Holiday'); $model->setAttributes($holiday); if ($model->save()) { Yii::app()->user->setFlash('success', 'Выходной успешно создан'); $this->redirect(['index']); } } $this->render('form', ['model' => $model, 'semester' => $semester]); }
public function dateCheck($attribute) { /** @var Semesters $semester */ $semester = Semesters::model()->actual(); $time = strtotime($this->{$attribute}); if ($time < strtotime(date('Y-m-d'))) { $this->addError($attribute, 'Нельзя установить дату меньше сегоднешней'); return false; } elseif (date('N', $time) == 7) { $this->addError($attribute, 'Нельзя установить дату на воскресенье'); return false; } if ($time < strtotime($semester->start_date) || $time > strtotime($semester->end_date)) { $this->addError($attribute, 'Дата не может быть за пределами текущего семестра'); } }
/** * Данная функция фильтрует группы по наполненности расписания для текущего семестра * * @param bool $bool Параметр указыкает какие группы нужны. true - заполненные, false - не заполненные * @return Group */ public function filled($bool = true) { $schedule_table = ScheduleElement::model()->tableName(); $semester = Semesters::model()->actual(); if ($semester) { $criteria = $this->getDbCriteria(); $criteria->params[':semester_id'] = $semester->id; for ($i = 1; $i <= 2; $i++) { for ($j = 1; $j <= 6; $j++) { $sql = "(SELECT COUNT(*) FROM `{$schedule_table}` WHERE `{$schedule_table}`.`week_number` = {$i} AND `{$schedule_table}`.`week_day` = {$j} AND `{$schedule_table}`.`group_id` = `t`.`id` AND `{$schedule_table}`.`semester_id` = :semester_id) " . ($bool ? ">" : "=") . " 0"; $criteria->addCondition($sql, $bool ? 'AND' : 'OR'); } } } return $this; }
<?php /* @var $this CoursesController */ /* @var $model Courses */ /* @var $form CActiveForm */ $dataProgram = Programs::model()->findAll(); $optionArrayProgram = CHtml::listData($dataProgram, 'program_Id', 'program_Name'); $dataSemester = Semesters::model()->findAll(); $optionArraySemester = CHtml::listData($dataSemester, 'semester_Id', 'semesterInfo'); ?> <div class="form"> <?php $form = $this->beginWidget('CActiveForm', array('id' => 'courses-form', 'enableAjaxValidation' => false)); ?> <p class="note">Fields with <span class="required">*</span> are required.</p> <?php echo $form->errorSummary($model); ?> <div class="row"> <?php echo $form->labelEx($model, 'program_Id'); ?> <?php echo $form->dropDownList($model, 'program_Id', $optionArrayProgram); ?> <?php
public function actionAutopost() { $semester = Semesters::model()->actual(); if (!$semester) { throw new CException('Нет семестра'); } $tomorrow_date = (new DateTime())->add(new DateInterval("P1D"))->format('Y-m-d'); $tomorrow_time = strtotime($tomorrow_date); if (date('N', $tomorrow_time) == 7) { throw new CException('Завтра выходной'); } $current_hour = date('G'); $week_number = ($semester->week_number + date('W', $tomorrow_time) - date('W', strtotime($semester->start_date))) % 2 ? 1 : 2; $week_day = date('N', $tomorrow_time); /** @var GroupAutopost[] $autoposts */ if (!($autoposts = GroupAutopost::model()->with(['group' => ['with' => ['schedule_elements' => ['condition' => 'week_number = :week_number AND week_day = :week_day AND semester_id = :semester_id', 'params' => [':week_number' => $week_number, ':week_day' => $week_day, ':semester_id' => $semester->id]]]]])->findAllByAttributes(['hour' => $current_hour, 'status' => GroupAutopost::STATUS_ACTIVE]))) { throw new CException('Нет групп для автопостинга'); } foreach ($autoposts as $autopost) { $replaces = CHtml::listData(GroupReplace::model()->with(['subject', 'classroom', 'teacher'])->findAllByAttributes(['group_id' => $autopost->group_id, 'date' => $tomorrow_date]), 'number', function ($model) { return array_merge($model->attributes, ['teacher' => $model->teacher, 'classroom' => $model->classroom, 'subject' => $model->subject]); }); $schedule_elements = CHtml::listData($autopost->group->schedule_elements, 'number', function ($model) { return array_merge($model->attributes, ['teacher' => $model->teacher, 'classroom' => $model->classroom, 'subject' => $model->subject]); }); $schedule = $replaces + $schedule_elements; ksort($schedule); $schedule_text = 'Расписание на завтра:' . PHP_EOL; $schedule_count = 0; /** @var $holiday Holiday */ if ($holiday = Holiday::model()->findByAttributes(['date' => $tomorrow_date])) { $schedule_text .= 'Выходной - ' . $holiday->name; } else { if ($schedule) { foreach ($schedule as $subject) { if (isset($subject['cancel']) && $subject['cancel']) { continue; } $schedule_count++; $schedule_text .= $subject['number'] . ') ' . $subject['subject']->name; if ($subject['teacher']) { $schedule_text .= ', ' . $subject['teacher']->lastname . ' ' . mb_substr($subject['teacher']->firstname, 0, 1, "UTF-8") . '.' . mb_substr($subject['teacher']->middlename, 0, 1, "UTF-8") . '.'; } if ($subject['classroom']) { $schedule_text .= ' (' . $subject['classroom']->name . ')'; } if (isset($subject['comment']) && strlen($subject['comment'])) { $schedule_text .= ' - ' . $subject['comment']; } $schedule_text .= PHP_EOL; } } if (!$schedule || $schedule_count == 0) { $schedule_text .= 'Пар нет' . PHP_EOL; } } $schedule_text .= 'Данные предоставлены проектом @studyschedule (Расписание ККЭП)'; $params = http_build_query(['owner_id' => $autopost->page_id, 'message' => $schedule_text, 'from_group' => 1, 'access_token' => $autopost->access_token]); echo "----" . $autopost->group->number . "----" . PHP_EOL; $response = file_get_contents('https://api.vk.com/method/wall.post?' . $params); if ($response) { $answer = json_decode($response, true); var_dump($answer); if (isset($answer['error'])) { $autopost->status = GroupAutopost::STATUS_DISABLE; $autopost->save(); $email = $autopost->group->owner->email; $mail = new YiiMailer("autopost", ['group' => $autopost->group]); $mail->setFrom(isset(Yii::app()->params->YiiMailer->Username) ? Yii::app()->params->YiiMailer->Username : Yii::app()->params->adminEmail, 'Система управления учебным расписанием'); $mail->setTo($email); $mail->setSubject('Ошибка автопостинга в ВКонтакте'); $mail->send(); } } else { echo 'Error when send request...'; } echo PHP_EOL; } }
public function actionIndex() { /** @var Semesters $semester */ $semester = Semesters::model()->actual(); $this->render('index', ['group_count' => Group::model()->filled()->count(), 'replace_count' => GroupReplace::model()->count('date >= :start_semester AND date <= :end_semester', [':start_semester' => $semester->start_date, ':end_semester' => $semester->end_date]), 'ics_count' => IcsAnalytics::model()->count('time LIKE :date', [':date' => date('Y-m-d') . '%'])]); }
/** * Returns the data model based on the primary key given in the GET variable. * If the data model is not found, an HTTP exception will be raised. * @param integer $id the ID of the model to be loaded * @return Semesters the loaded model * @throws CHttpException */ public function loadModel($id) { $model = Semesters::model()->findByPk($id); if ($model === null) { throw new CHttpException(404, 'The requested page does not exist.'); } return $model; }
public function getCurrentWeekNumber() { $semester = Semesters::model()->actual(); $week_number = (date('W') - date('W', strtotime($semester->start_date))) % ($semester->week_number + 1) + 1; return $week_number; }
public function actionIndex($group = false) { /** @var Group $group */ if ($group != false && !($group = Group::model()->filled()->findByAttributes(['number' => $group]))) { throw new CHttpException(404, 'Данной группы не найден'); } /** @var Semesters $semester */ $semester = Semesters::model()->actual(); $current_date = date('Y-m-d'); $current_time = strtotime($current_date); if (!$semester) { throw new CHttpException(404, 'Сейчас нет семестра :-('); } $group_list = CHtml::listData(Group::model()->filled()->findAll(), 'number', 'number'); $schedule = []; if ($group) { $time_one_day = 60 * 60 * 24; for ($i = $current_time; $i <= $current_time + $time_one_day * 7; $i = $i + $time_one_day) { $week_day = date('N', $i); $date = date('d.n.Y', $i); /** @var Holiday $holiday */ if (($holiday = Holiday::model()->findByAttributes(['date' => date('Y-m-d', $i)])) || $week_day == 7) { $schedule[$date] = ['holiday' => true]; if ($holiday) { $schedule[$date]['name'] = $holiday->name; } continue; } $schedule[$date] = []; $week_number = ($semester->week_number + (date('W', $i) - date('W', strtotime($semester->start_date)))) % 2 ? 1 : 2; $schedule_elements = ScheduleElement::model()->findAllByAttributes(['group_id' => $group->id, 'semester_id' => $semester->id, 'week_number' => $week_number, 'week_day' => $week_day]); $numbers = [1, 2, 3, 4, 5]; /** @var ScheduleElement $schedule_element */ foreach ($schedule_elements as $schedule_element) { unset($numbers[array_search($schedule_element->number, $numbers)]); /** @var GroupReplace $replace */ $replace = GroupReplace::model()->findByAttributes(['date' => date('Y-m-d', $i), 'number' => $schedule_element->number, 'group_id' => $group->id]); if ($replace && $replace->cancel) { $schedule[$date][$schedule_element->number] = ['cancel' => true, 'replace' => true]; } elseif ($replace) { $schedule[$date][$schedule_element->number] = ['subject' => $replace->subject->name, 'replace' => true, 'comment' => $replace->comment]; if ($replace->teacher_id) { $schedule[$date][$schedule_element->number]['teacher'] = $replace->teacher->lastname . ' ' . mb_substr($replace->teacher->firstname, 0, 1, "UTF-8") . '.' . mb_substr($replace->teacher->middlename, 0, 1, "UTF-8") . '.'; } if ($replace->classroom_id) { $schedule[$date][$schedule_element->number]['classroom'] = $replace->classroom->name; } } else { $schedule[$date][$schedule_element->number] = ['subject' => $schedule_element->subject->name]; if ($schedule_element->teacher_id) { $schedule[$date][$schedule_element->number]['teacher'] = $schedule_element->teacher->lastname . ' ' . mb_substr($schedule_element->teacher->firstname, 0, 1, "UTF-8") . '.' . mb_substr($schedule_element->teacher->middlename, 0, 1, "UTF-8") . '.'; } if ($schedule_element->classroom_id) { $schedule[$date][$schedule_element->number]['classroom'] = $schedule_element->classroom->name; } } } if (count($numbers)) { foreach ($numbers as $number) { /** @var GroupReplace $replace */ $replace = GroupReplace::model()->findByAttributes(['date' => date('Y-m-d', $i), 'number' => $number, 'group_id' => $group->id]); if ($replace && $replace->cancel) { $schedule[$date][$replace->number] = ['cancel' => true, 'replace' => true]; } elseif ($replace) { $schedule[$date][$replace->number] = ['subject' => $replace->subject->name, 'replace' => true]; if ($replace->teacher_id) { $schedule[$date][$replace->number]['teacher'] = $replace->teacher->lastname . ' ' . mb_substr($replace->teacher->firstname, 0, 1, "UTF-8") . '.' . mb_substr($replace->teacher->middlename, 0, 1, "UTF-8") . '.'; } if ($replace->classroom_id) { $schedule[$date][$replace->number]['classroom'] = $replace->classroom->name; } } } } ksort($schedule[$date]); } } Yii::app()->clientScript->registerMetaTag('noarchive', 'robots'); $this->render('index', ['group' => $group ? $group->number : false, 'group_list' => $group_list, 'schedule' => $schedule]); }
public function actionUpdateReplace($replace_id) { $semester = Semesters::model()->actual(); if (!$semester) { throw new CHttpException(404, 'Сейчас нет семестра :-('); } /** @var GroupReplace $model */ $model = GroupReplace::model()->findByPk($replace_id); if (!$model || strtotime($model->date) < strtotime(date('Y-m-d'))) { throw new CHttpException(404, 'Замена не найдена'); } $classrooms = CHtml::listData(Classrooms::model()->byName()->findAll(), 'id', 'name'); $subjects = CHtml::listData(Subjects::model()->byName()->findAll(), 'id', 'name'); $teachers = CHtml::listData(Teachers::model()->byLastName()->findAll(), 'id', function ($model) { return join(' ', [$model->lastname, $model->firstname, $model->middlename]); }); if (Yii::app()->request->isPostRequest) { $replace = Yii::app()->request->getParam('GroupReplace'); $model->setAttributes($replace); $model->setAttributes(['group_id' => self::$group->id]); if ($model->save()) { Yii::app()->user->setFlash('success', 'Замена успешна обновлена'); $this->redirect(['replaces', 'id' => self::$group->number]); } } $this->render('replace/form', ['semester' => $semester, 'model' => $model, 'teachers' => $teachers, 'subjects' => $subjects, 'classrooms' => $classrooms, 'numbers' => [1 => 1, 2 => 2, 3 => 3, 4 => 4, 5 => 5]]); }
public function actionGroup($id) { if (!isset($_SERVER['HTTP_USER_AGENT'])) { throw new CHttpException(403, 'У вас нет useragent, поэтому сюда вам нельзя'); } /** @var Semesters $semester */ if (!($semester = Semesters::model()->with(['call_list', 'call_list_short'])->actual())) { throw new CHttpException(404, 'Сейчас нет семестра :-('); } // Аналитика if (!($unique_ics_id = Yii::app()->session->get('unique_ics_id', false))) { $unique_ics_id = uniqid(); Yii::app()->session->add('unique_ics_id', $unique_ics_id); } $analytics = new IcsAnalytics(); $analytics->setAttributes(['useragent' => $_SERVER['HTTP_USER_AGENT'], 'group' => $id, 'time' => date("Y-m-d H:i:s"), 'ip' => get_client_ip(), 'unique_id' => $unique_ics_id]); $analytics->save(); // Даты $count_days = 24; $current_date = date('Y-m-d'); $period_interval = new DateInterval('P1D'); $period_start = new DateTime($current_date); $period_start->modify('-' . floor($count_days / 2) . ' days'); $period_end = new DateTime($current_date); $period_end->modify('+' . floor($count_days / 2) . ' days'); $period = new DatePeriod($period_start, $period_interval, $period_end); $period_dates = []; $semester_start = new DateTime($semester->start_date); $semester_end = new DateTime($semester->end_date); /** @var DateTime $period_date */ foreach ($period as $period_date) { $period_dates[] = $period_date->format('Y-m-d'); } // Загрузка группы с расписанием и заменами за нужный период /** @var Group $group */ if (!($group = Group::model()->filled()->with(['schedule_elements' => ['with' => ['teacher' => ['alias' => 's_teacher'], 'classroom' => ['alias' => 's_classroom'], 'subject' => ['alias' => 's_subject']], 'condition' => 'semester_id = :semester_id', 'params' => [':semester_id' => $semester->id]], 'replaces' => ['together' => false, 'with' => ['teacher' => ['alias' => 'r_teacher'], 'classroom' => ['alias' => 'r_classroom'], 'subject' => ['alias' => 'r_subject']], 'condition' => 'date >= :start_date AND date <= :end_date', 'params' => [':start_date' => $period_start->format('Y-m-d'), ':end_date' => $period_end->format('Y-m-d')]]])->findByAttributes(['number' => $id]))) { throw new CHttpException(404, 'Группа не найдена или незаполнена'); } // Преобразование массивов /** @var CallListsElements[] $call_list */ $call_list = CHtml::listData($semester->call_list()->elements, 'number', function ($model) { return $model; }); /** @var CallListsElements[] $call_list_short */ $call_list_short = CHtml::listData($semester->call_list_short()->elements, 'number', function ($model) { return $model; }); $schedule_elements = []; for ($i = 1; $i <= 2; $i++) { for ($j = 1; $j <= 6; $j++) { $schedule_elements[$i][$j] = CHtml::listData(array_filter($group->schedule_elements, function ($model) use(&$i, &$j) { return $model->week_number == $i && $model->week_day == $j; }), 'number', function ($model) { return $model; }); ksort($schedule_elements[$i][$j], SORT_NUMERIC); } ksort($schedule_elements[$i], SORT_NUMERIC); } $replaces = []; foreach ($group->replaces as $replace) { $replaces[$replace->date][$replace->number] = $replace; } $calendar = new Calendar(); $calendar->setProdId('-//Sc0Rp1D//KKEP//RU'); $calendar->setTimezone(new DateTimeZone('Europe/Moscow')); $calendar->setCustomHeaders(['X-PUBLISHED-TTL' => 'PT1H', 'REFRESH-INTERVAL' => 'VALUE=DURATION:PT1H']); $holidays = CHtml::listData(Holiday::model()->findAllByAttributes(['date' => $period_dates]), 'date', 'name'); $short_days = CHtml::listData(ShortDay::model()->findAllByAttributes(['date' => $period_dates]), 'date', 'name'); /** @var DateTime $period_element */ foreach ($period as $period_element) { $week_day = $period_element->format('N'); $date_formatted = $period_element->format('Y-m-d'); if ($period_element < $semester_start || $week_day == 7 || array_key_exists($date_formatted, $holidays)) { continue; } if ($period_element > $semester_end) { break; } if ($week_day == 6 || array_key_exists($date_formatted, $short_days)) { $current_call_list = $call_list_short; } else { $current_call_list = $call_list; } $week_number = ($semester->week_number + ($period_element->format('W') - $semester_start->format('W'))) % 2 ? 1 : 2; /** @var ScheduleElement $schedule_element */ foreach ((isset($replaces[$date_formatted]) ? $replaces[$date_formatted] : []) + $schedule_elements[$week_number][$week_day] as $schedule_element) { if (isset($schedule_element->cancel) && $schedule_element->cancel) { continue; } $event = new CalendarEvent(); $start_time = clone $period_element; $call_list_start = explode(':', $current_call_list[$schedule_element->number]->start_time); $call_list_end = explode(':', $current_call_list[$schedule_element->number]->end_time); $start_time->setTime($call_list_start[0], $call_list_start[1]); $event->setStart($start_time); $end_time = clone $period_element; $end_time->setTime($call_list_end[0], $call_list_end[1]); $event->setEnd($end_time); $event->setSummary($schedule_element->subject->name); $event->setUid(md5($date_formatted . ' ' . $current_call_list[$schedule_element->number]->start_time)); if ($schedule_element->classroom_id || $schedule_element->teacher_id) { $location = new Location(); $desc = []; if ($schedule_element->teacher_id) { $desc[] = $schedule_element->teacher->lastname . ' ' . mb_substr($schedule_element->teacher->firstname, 0, 1, "UTF-8") . '.' . mb_substr($schedule_element->teacher->middlename, 0, 1, "UTF-8") . '.'; } if ($schedule_element->classroom_id) { $desc[] = $schedule_element->classroom->name; } $location->setName(implode(' | ', $desc)); $event->addLocation($location); } if ($schedule_element instanceof GroupReplace && strlen($schedule_element->comment)) { $event->setDescription($schedule_element->comment); } $calendar->addEvent($event); } } $calendarExport = new CalendarExport(new CalendarStream(), new Formatter()); $calendarExport->addCalendar($calendar); //header('Content-Type: text/calendar; charset=utf-8'); echo $calendarExport->getStream(); }