Текст компонентов программы

User_controller.php

<?php

class UsersController extends AppController

{

var $name = 'User';

var $uses = array('User', 'Teacher', 'Chair', 'Subject', 'Semester', 'Spec', 'Plan') ;

function index(){

$this->pageTitle = "Вход в систему";

if (!empty($this->data)) {

$user = $this->User->findAll("login='".$this->data['User']['login']."' and psw='".$this->data['User']['psw']."'");

if (count($user > 0)) {

$this->Session->Write("user", $user[0]['User']['login']);

if ($user[0]['User']['status'] == 0) {

$this->Session->Write("admin", 1);

$this->redirect(array('controller'=>'users','action' => 'admin_actions'));

}

else {

$this->Session->Write("admin", 0);

$this->redirect(array('controller'=>'users','action' => 'user_plan'));

}

}

else {

$this->set('error', "Неверное имя пользователя или пароль");

}

}

}

//***************************************

// вывод учебного плана для преподавателя

//***************************************

function user_plan() {

if ($this->Session->Read('user') == '') {

return false ;

}

else {

$login = $this->Session->Read('user');

$user = $this->User->findAll("login='".$login."'");

if ($user[0]['User']['status'] == 1) {

$this->pageTitle = "Учебная карточка преподавателя";

$teacher = $this->Teacher->findAll('user_id='.$user[0]['User']['id']);

$this->set('teacher', $teacher);

$plans = $this->Plan->findAll('teacher_id='.$teacher[0]['Teacher']['id'].' order by semester_id');

$data = array();

$i = 0;

foreach ($plans as $plan) {

$data[$i]['id'] = $plan['Plan']['id'];

$data[$i]['students'] = $plan['Plan']['students'];

$data[$i]['groups'] = $plan['Plan']['groups'];

$this->Subject->id = $plan['Plan']['subject_id'];

$subject = $this->Subject->read();

$data[$i]['subject'] = $subject['Subject']['name'];

$data[$i]['subject_all'] = $subject['Subject'];

$this->Spec->id = $plan['Plan']['spec_id'];

$spec = $this->Spec->read();

$data[$i]['spec'] = $spec['Spec']['name'];

$this->Semester->id = $plan['Plan']['semester_id'];

$semester = $this->Semester->read();

$data[$i]['semester'] = $semester['Semester']['name'];

$i ++;

}

$this->set('data', $data);

}

}

}

//*********************************

// выбор действия администратором

//*********************************

function admin_actions() {

if (!$this->is_admin()) {

$this->redirect(array('controller'=>'users','action' => 'index'));

}

else {

$this->pageTitle = "Выбор действия для администратора";

}

}

//*****************************

// вывод нагрузки по кафедре

//******************************

function plan_chair($id_chair) {

if (!$this->is_admin()) {

$this->redirect(array('controller'=>'users','action' => 'index'));

}

else {

if (!empty($id_chair)) {

$this->pageTitle = "Просмотр нагрузки";

$this->Chair->id = $id_chair;

$chair = $this->Chair->read();

$this->set('chair', $chair['Chair']['name']);

$teachers = $this->Teacher->findAll('chair_id='.$id_chair);

$data = array();

$i = 0;

foreach ($teachers as $teacher) {

$plans = $this->Plan->findAll('teacher_id='.$teacher['Teacher']['id'].' order by semester_id');

$data[$i]['teacher'] = $teacher;

$j = 0;

foreach ($plans as $plan) {

$data[$i]['plan'][$j]['id'] = $plan['Plan']['id'];

$data[$i]['plan'][$j]['students'] = $plan['Plan']['students'];

$data[$i]['plan'][$j]['groups'] = $plan['Plan']['groups'];

$this->Subject->id = $plan['Plan']['subject_id'];

$subject = $this->Subject->read();

$data[$i]['plan'][$j]['subject'] = $subject['Subject']['name'];

$data[$i]['plan'][$j]['subject_all'] = $subject['Subject'];

$this->Spec->id = $plan['Plan']['spec_id'];

$spec = $this->Spec->read();

$data[$i]['plan'][$j]['spec'] = $spec['Spec']['name'];

$this->Semester->id = $plan['Plan']['semester_id'];

$semester = $this->Semester->read();

$data[$i]['plan'][$j]['semester'] = $semester['Semester']['name'];

$j ++;

}

$i ++;

}

$this->set('data', $data);

}

}

}

//*********************************

// выбор кафедры для просмотра нагрузки

//*********************************

function select_chair_plan() {

if (!$this->is_admin()) {

$this->redirect(array('controller'=>'users','action' => 'index'));

}

else {

$this->pageTitle = "Выбор кафедры для просмотра нагрузки";

$chairs = $this->Chair->findAll("order by name");

$this->set('chairs', $chairs);

}

}

//*********************************************

// выбор преподавателя для добавления нагрузки

//*********************************************

function select_teacher_plan () {

if (!$this->is_admin()) {

$this->redirect(array('controller'=>'users','action' => 'index'));

}

else {

$this->pageTitle = "Выбор преподавателя";

$teachers = $this->Teacher->findAll('order by last_name');

$this->set('teachers', $teachers);

}

}

//*************************************

// удаление из нагрузки преподавателя

//*************************************

function del_plan ($id_plan = null, $teacher_id = null) {

if (!$this->is_admin()) {

$this->redirect(array('controller'=>'users','action' => 'index'));

}

else {

if ((!empty($id_plan)) && (!empty($teacher_id))) {

$this->Plan->id = $id_plan;

$this->Plan->del();

$this->redirect(array('controller'=>'users','action' => 'plan', $teacher_id));

}

}

}

//****************************************

// добавление нагрузки преподавателю

//****************************************

function plan($id = null) {

if (!$this->is_admin()) {

$this->redirect(array('controller'=>'users','action' => 'index'));

}

else {

if (!empty($id)) {

$this->pageTitle = "Учебная карточка преподавателя";

if (!empty($this->data)) {

$ok = true;

if ((empty($this->data['Plan']['groups'])) || (empty($this->data['Plan']['students']))) {

$this->set('error', "Количество групп и студентов должно быть заполнено");

$ok = false ;

}

if ($ok) {

$data = array('Plan'=>array('teacher_id'=>$id, 'subject_id'=>$this->data['Subject']['name'], 'spec_id'=>$this->data['Spec']['name'], 'students'=>$this->data['Plan']['students'], 'groups'=>$this->data['Plan']['groups'], 'semester_id'=>$this->data['Semester']['name']));

$this->Plan->save($data);

$this->data['Plan']['groups'] = '';

$this->data['Plan']['students'] = '';

}

}

$this->Teacher->id = $id;

$teacher = $this->Teacher->read();

$this->set('teacher', $teacher);

$plans = $this->Plan->findAll('teacher_id='.$id.' order by semester_id');

$data = array();

$i = 0;

foreach ($plans as $plan) {

$data[$i]['id'] = $plan['Plan']['id'];

$data[$i]['students'] = $plan['Plan']['students'];

$data[$i]['groups'] = $plan['Plan']['groups'];

$this->Subject->id = $plan['Plan']['subject_id'];

$subject = $this->Subject->read();

$data[$i]['subject'] = $subject['Subject']['name'];

$data[$i]['subject_all'] = $subject['Subject'];

$this->Spec->id = $plan['Plan']['spec_id'];

$spec = $this->Spec->read();

$data[$i]['spec'] = $spec['Spec']['name'];

$this->Semester->id = $plan['Plan']['semester_id'];

$semester = $this->Semester->read();

$data[$i]['semester'] = $semester['Semester']['name'];

$i ++;

}

$this->set('data', $data);

$semesters = $this->Semester->findAll();

$this->set('semesters', $semesters);

$subjects = $this->Subject->findAll('where id not in (select plans.subject_id from plans) order by name');

$this->set('subjects', $subjects);

$specs = $this->Spec->findAll('order by name');

$this->set('specs', $specs);

}

}

}

//****************************

// добавление специальности

//****************************

function add_spec() {

if (!$this->is_admin()) {

$this->redirect(array('controller'=>'users','action' => 'index'));

}

else {

$this->pageTitle = "Добавление специальности";

if (!empty($this->data)) {

if (empty($this->data['Spec']['name'])) {

$this->set('error', 'Название специальности не введено');

}

else {

$this->Spec->save($this->data);

$this->set('error', 'Специальность успешно добавлена');

$this->data['Spec']['name'] = "";

}

}

$specs = $this->Spec->findAll('order by name');

$this->set("specs", $specs);

}

}

//*************************************

// выбор специальности для редактирования

//*************************************

function select_spec() {

if (!$this->is_admin()) {

$this->redirect(array('controller'=>'users','action' => 'index'));

}

else {

$this->pageTitle = "Выбор специальности для редактирования";

$specs = $this->Spec->findAll('order by name');

$this->set('specs', $specs);

}

}

//************************************

// редактирование специальности

//************************************

function edit_spec($id = null) {

if (!$this->is_admin()) {

$this->redirect(array('controller'=>'users','action' => 'index'));

}

else {

if (!empty($id)) {

if (!empty($this->data)) {

if (empty($this->data['Spec']['name'])) {

$this->set('error', 'Название специальности не введено');

}

else {

$this->Spec->id = $id;

$this->Spec->save($this->data);

$this->set('error', 'Специальность успешно отредактирована');

$this->data['Spec']['name'] = "";

}

}

$this->pageTitle = "Редактирование специальности";

$this->Spec->id = $id;

$spec = $this->Spec->read();

$this->set("spec", $spec);

}

}

}

//********************************

// добавление предмета

//********************************

function add_subject() {

if (!$this->is_admin()) {

$this->redirect(array('controller'=>'users','action' => 'index'));

}

else {

$this->pageTitle = "Добавление нового предмета";

if (!empty($this->data)) {

if (empty($this->data['Subject']['name'])) {

$this->set('error', 'Название дисциплины не введено');

}

else {

$this->data['Subject']['semester_id'] = $this->data['Semester']['name'];

$this->Subject->save($this->data);

$this->set('error', 'Дисциплина успешно добавлена');

$this->data['Subject']['name'] = "";

}

}

$subjects = $this->Subject->findAll('order by name');

$this->set('subjects', $subjects);

$semesters = $this->Semester->findAll();

$this->set('semesters', $semesters);

}

}

//*********************************

// выбор дисциплины для редактирования

//*********************************

function select_subject() {

if (!$this->is_admin()) {

$this->redirect(array('controller'=>'users','action' => 'index'));

}

else {

$this->pageTitle = "Выбор дисциплины для редактирования";

$subjects = $this->Subject->findAll('order by name');

$this->set('subjects', $subjects);

}

}

//*************************************

// редактирование дисциплины

//*************************************

function edit_subject($id = null) {

if (!$this->is_admin()) {

$this->redirect(array('controller'=>'users','action' => 'index'));

}

else {

if (!empty($id)) {

if (!empty($this->data)) {

if (empty($this->data['Subject']['name'])) {

$this->set('error', 'Название дисциплины не введено');

}

else {

$this->data['Subject']['semester_id'] = $this->data['Semester']['name'];

$this->Subject->id = $id;

$this->Subject->save($this->data);

$this->set('error', 'Дисциплина успешно изменена');

$this->data['Subject']['name'] = "";

}

}

$this->Subject->id = $id;

$subject = $this->Subject->read();

$this->set('subject', $subject);

$this->pageTitle = "Редактирование дисциплины";

$semesters = $this->Semester->findAll();

$this->set('semesters', $semesters);

$this->Semester->id = $subject['Subject']['semester_id'];

$semester = $this->Semester->read();

$this->set('semester', $semester['Semester']['name']);

}

}

}

//**********************************

// добавление кафедры

//**********************************

function add_chair() {

if (!$this->is_admin()) {

$this->redirect(array('controller'=>'users','action' => 'index'));

}

else {

if (!empty($this->data)) {

if (empty($this->data['Chair']['name'])) {

$this->set('error', "Введите название кафедры");

}

else {

$this->Chair->save($this->data);

$this->set('error', "Кафедра ".$this->data['Chair']['name']." успешно добавлена");

$this->data['Chair']['name'] = "";

}

}

$this->pageTitle = "Добавление новой кафедры";

$chairs = $this->Chair->findAll('order by name');

$this->set('chairs', $chairs);

}

}

//****************************************

// выбор кафедры для изменения названия

//****************************************

function select_chair() {

if (!$this->is_admin()) {

$this->redirect(array('controller'=>'users','action' => 'index'));

}

else {

$this->pageTitle = "Выбор кафедры для редактирования";

$chairs = $this->Chair->findAll("order by name");

$this->set('chairs', $chairs);

}

}

//*********************************

// редактирование кафедры

//*********************************

function change_chair($id = null) {

if (!$this->is_admin()) {

$this->redirect(array('controller'=>'users','action' => 'index'));

}

else {

if (!empty($id)) {

if (!empty($this->data)) {

$this->Chair->id = $id;

$data = array("Chair"=>array('name'=>$this->data['Chair']['name']));

$this->Chair->save($data);

$this->set('error', "Название успешно изменено");

}

$this->Chair->id = $id;

$chair = $this->Chair->read();

$this->set("chair", $chair);

}

}

}

//****************************************

// добавление новго пользователя администратором

//****************************************

function add_user() {

if (!$this->is_admin()) {

$this->redirect(array('controller'=>'users','action' => 'index'));

}

else {

$this->pageTitle = "Добавление нового пользователя";

if (!empty($this->data)) {

if (empty($this->data['User']['login'])) {

$this->set('error', "Не введен Логин пользователя");

return;

}

if (empty($this->data['User']['psw'])) {

$this->set('error', "Не введен пароль пользователя");

return;

}

if ($this->data['User']['psw'] != $this->data['User']['psw2']) {

$this->set('error', "Введенные пароли не совпадают");