Завершение работы программы.

    Завершение работы программы обеспечиваются стандартными средствами операционной системы или выполнением функции, описанной ниже.

    Для завершения требуется нажать на кнопку «X»в правом, верхнем углу приложения. После чего программа спросит уверены ли вы, что хотите выйти, если ответить да, то программа закроется иначе ничего не произойдёт.

 

ПРИЛОЖЕНИЕ 5СЕРВЕРНАЯЧАСТЬПРОЕКТА

CREATE DATABASE IF NOT EXISTS `educational_part` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `educational_part`;

-- MySQL dump 10.13 Distrib 5.7.17, for Win64 (x86_64)

--

-- Host: localhost Database: educational_part

-- ------------------------------------------------------

-- Server version 5.7.18-log

 

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

/*!40101 SET NAMES utf8 */;

/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;

/*!40103 SET TIME_ZONE='+00:00' */;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

 

--

-- Table structure for table `table_group`

--

 

DROP TABLE IF EXISTS `table_group`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `table_group` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`name` varchar(45) NOT NULL,

`course` int(11) NOT NULL,

`semester` int(11) NOT NULL,

PRIMARY KEY (`id`),

UNIQUE KEY `name_c_s_UNIQUE` (`name`,`semester`,`course`)

) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

 

--

-- Dumping data for table `table_group`

--

 

LOCK TABLES `table_group` WRITE;

/*!40000 ALTER TABLE `table_group` DISABLE KEYS */;

INSERT INTO `table_group` VALUES (6,'БГ',1,1),(7,'БГ-15',1,2);

/*!40000 ALTER TABLE `table_group` ENABLE KEYS */;

UNLOCK TABLES;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

 

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;

/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;

/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;

/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

 

-- Dump completed on 2017-05-31 22:55:13

 

CREATE DATABASE IF NOT EXISTS `educational_part` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `educational_part`;

-- MySQL dump 10.13 Distrib 5.7.17, for Win64 (x86_64)

--

-- Host: localhost Database: educational_part

-- ------------------------------------------------------

-- Server version 5.7.18-log

 

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

/*!40101 SET NAMES utf8 */;

/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;

/*!40103 SET TIME_ZONE='+00:00' */;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

 

--

-- Table structure for table `table_haviness`

--

 

DROP TABLE IF EXISTS `table_haviness`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `table_haviness` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`id_import` int(11) NOT NULL,

`id_p_h` int(11) NOT NULL,

`hours` int(11) NOT NULL,

`changeP` int(11) DEFAULT '0',

`yes_no` varchar(45) DEFAULT 'Нет',

PRIMARY KEY (`id`),

UNIQUE KEY `unique_import_p_h` (`id_import`,`id_p_h`),

KEY `haviness_p_h_idx` (`id_p_h`),

CONSTRAINT `haviness_import` FOREIGN KEY (`id_import`) REFERENCES `table_import` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,

CONSTRAINT `haviness_p_h` FOREIGN KEY (`id_p_h`) REFERENCES `table_prepods_hours` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION

) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

 

--

-- Dumping data for table `table_haviness`

--

 

LOCK TABLES `table_haviness` WRITE;

/*!40000 ALTER TABLE `table_haviness` DISABLE KEYS */;

INSERT INTO `table_haviness` VALUES (30,175,6,68,0,'Нет'),(31,176,6,89,0,'Нет'),(32,177,6,47,0,'Нет'),(33,209,6,77,0,'Нет'),(34,210,6,94,0,'Нет'),(35,211,6,60,0,'Нет');

/*!40000 ALTER TABLE `table_haviness` ENABLE KEYS */;

UNLOCK TABLES;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

 

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;

/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;

/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;

/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

 

-- Dump completed on 2017-05-31 22:55:13

 

CREATE DATABASE IF NOT EXISTS `educational_part` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `educational_part`;

-- MySQL dump 10.13 Distrib 5.7.17, for Win64 (x86_64)

--

-- Host: localhost Database: educational_part

-- ------------------------------------------------------

-- Server version 5.7.18-log

 

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

/*!40101 SET NAMES utf8 */;

/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;

/*!40103 SET TIME_ZONE='+00:00' */;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

 

--

-- Table structure for table `table_import`

--

 

DROP TABLE IF EXISTS `table_import`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `table_import` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`id_predmet` int(11) NOT NULL,

`id_group` int(11) NOT NULL,

`type_lesson` varchar(100) NOT NULL,

`hours` int(11) NOT NULL,

`years` int(11) NOT NULL,

PRIMARY KEY (`id`),

UNIQUE KEY `unique_table_import` (`id_predmet`,`id_group`,`years`,`type_lesson`),

KEY `id_ti_predmet_idx` (`id_predmet`),

KEY `id_ti_grup_idx` (`id_group`),

CONSTRAINT `id_ti_grup` FOREIGN KEY (`id_group`) REFERENCES `table_group` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,

CONSTRAINT `id_ti_predmet` FOREIGN KEY (`id_predmet`) REFERENCES `table_predmets` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION

) ENGINE=InnoDB AUTO_INCREMENT=222 DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

 

--

-- Dumping data for table `table_import`

--

 

LOCK TABLES `table_import` WRITE;

/*!40000 ALTER TABLE `table_import` DISABLE KEYS */;

INSERTINTO `table_import` VALUES (153,47,6,'Самостоятельные',17,2017),(154,47,6,'Лекции',34,2017),(155,48,6,'Самостоятельные',17,2017),(156,48,6,'Лекции',34,2017),(157,49,6,'Самостоятельные',17,2017),(158,49,6,'Практические занятия',34,2017),(159,50,6,'Самостоятельные',25,2017),(160,50,6,'Лекции',51,2017),(161,51,6,'Самостоятельные',17,2017),(162,51,6,'Лекции',34,2017),(163,52,6,'Самостоятельные',17,2017),(164,52,6,'Лекции',18,2017),(165,52,6,'Практические занятия',16,2017),(166,53,6,'Самостоятельные',17,2017),(167,53,6,'Лекции',24,2017),(168,53,6,'Практические занятия',10,2017),(169,54,6,'Самостоятельные',25,2017),(170,54,6,'Лекции',2,2017),(171,54,6,'Практические занятия',49,2017),(172,55,6,'Самостоятельные',17,2017),(173,55,6,'Лекции',30,2017),(174,55,6,'Практические занятия',4,2017),(175,56,6,'Самостоятельные',0,2017),(176,56,6,'Лекции',0,2017),(177,56,6,'Практические занятия',0,2017),(178,57,6,'Самостоятельные',18,2017),(179,57,6,'Лекции',24,2017),(180,57,6,'Практические занятия',10,2017),(181,58,6,'Самостоятельные',26,2017),(182,58,6,'Лекции',25,2017),(183,58,6,'Лабораторные занятия',26,2017),(184,59,6,'Самостоятельные',25,2017),(185,59,6,'Лекции',41,2017),(186,59,6,'Лабораторные занятия',10,2017),(187,47,7,'Самостоятельные',22,2017),(188,47,7,'Лекции',44,2017),(189,48,7,'Самостоятельные',26,2017),(190,48,7,'Лекции',51,2017),(191,49,7,'Самостоятельные',22,2017),(192,49,7,'Практические занятия',44,2017),(193,50,7,'Самостоятельные',33,2017),(194,50,7,'Лекции',66,2017),(195,51,7,'Самостоятельные',25,2017),(196,51,7,'Лекции',51,2017),(197,52,7,'Самостоятельные',22,2017),(198,52,7,'Лекции',22,2017),(199,52,7,'Практические занятия',22,2017),(200,53,7,'Самостоятельные',22,2017),(201,53,7,'Лекции',42,2017),(202,53,7,'Практические занятия',2,2017),(203,54,7,'Самостоятельные',33,2017),(204,54,7,'Лекции',2,2017),(205,54,7,'Практические занятия',64,2017),(206,55,7,'Самостоятельные',18,2017),(207,55,7,'Лекции',30,2017),(208,55,7,'Практические занятия',6,2017),(209,56,7,'Самостоятельные',0,2017),(210,56,7,'Лекции',0,2017),(211,56,7,'Практические занятия',0,2017),(212,57,7,'Самостоятельные',51,2017),(213,57,7,'Лекции',83,2017),(214,57,7,'Практические занятия',20,2017),(215,58,7,'Самостоятельные',22,2017),(216,58,7,'Лекции',24,2017),(217,58,7,'Лабораторные занятия',20,2017),(218,59,7,'Самостоятельные',23,2017),(219,59,7,'Лекции',13,2017),(220,59,7,'Практические занятия',10,2017),(221,59,7,'Лабораторные занятия',22,2017);

/*!40000 ALTER TABLE `table_import` ENABLE KEYS */;

UNLOCK TABLES;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

 

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;

/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;

/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;

/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

 

-- Dump completed on 2017-05-31 22:55:12

 

CREATE DATABASE IF NOT EXISTS `educational_part` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `educational_part`;

-- MySQL dump 10.13 Distrib 5.7.17, for Win64 (x86_64)

--

-- Host: localhost Database: educational_part

-- ------------------------------------------------------

-- Server version 5.7.18-log

 

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

/*!40101 SET NAMES utf8 */;

/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;

/*!40103 SET TIME_ZONE='+00:00' */;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

 

--

-- Table structure for table `table_journal_list`

--

 

DROP TABLE IF EXISTS `table_journal_list`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `table_journal_list` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`date_t` date NOT NULL,

`hours` int(11) NOT NULL,

`type_lesson` varchar(45) NOT NULL,

`themes` varchar(255) NOT NULL,

`quest` longblob,

`id_haviness` int(11) NOT NULL,

`nameFile` varchar(255) DEFAULT NULL,

PRIMARY KEY (`id`),

KEY `id_table_haviness_idx` (`id_haviness`),

CONSTRAINT `id_table_haviness` FOREIGN KEY (`id_haviness`) REFERENCES `table_haviness` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION

) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

 

--

-- Dumping data for table `table_journal_list`

--

 

LOCK TABLES `table_journal_list` WRITE;

/*!40000 ALTER TABLE `table_journal_list` DISABLE KEYS */;

/*!40000 ALTER TABLE `table_journal_list` ENABLE KEYS */;

UNLOCK TABLES;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

 

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;

/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;

/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;

/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

 

-- Dump completed on 2017-05-31 22:55:13

 

CREATE DATABASE IF NOT EXISTS `educational_part` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `educational_part`;

-- MySQL dump 10.13 Distrib 5.7.17, for Win64 (x86_64)

--

-- Host: localhost Database: educational_part

-- ------------------------------------------------------

-- Server version 5.7.18-log

 

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

/*!40101 SET NAMES utf8 */;

/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;

/*!40103 SET TIME_ZONE='+00:00' */;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

 

--

-- Table structure for table `table_predmets`

--

 

DROP TABLE IF EXISTS `table_predmets`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `table_predmets` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`name` varchar(255) NOT NULL,

`s_name` varchar(45) NOT NULL DEFAULT 'Empty',

PRIMARY KEY (`id`),

UNIQUE KEY `name_sname_UNIQUE` (`name`,`s_name`)

) ENGINE=InnoDB AUTO_INCREMENT=60 DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

 

--

-- Dumping data for table `table_predmets`

--

 

LOCK TABLES `table_predmets` WRITE;

/*!40000 ALTER TABLE `table_predmets` DISABLE KEYS */;

INSERT INTO `table_predmets` VALUES (53,'Биология','БД.07'),(49,'Иностранный язык','БД.03'),(58,'Информатика и ИКТ','ПД.03'),(50,'История','БД.04'),(48,'Литература','БД.02'),(56,'Математика','ПД.01'),(55,'ОБЖ','БД.09'),(51,'Обществознание','БД.05'),(59,'Основы программирования','ОП.05'),(47,'Русский язык','БД.01'),(57,'Физика','ПД.02'),(54,'Физическая культура','БД.08'),(52,'Химия','БД.06');

/*!40000 ALTER TABLE `table_predmets` ENABLE KEYS */;

UNLOCK TABLES;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

 

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;

/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;

/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;

/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

 

-- Dump completed on 2017-05-31 22:55:14

 

CREATE DATABASE IF NOT EXISTS `educational_part` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `educational_part`;

-- MySQL dump 10.13 Distrib 5.7.17, for Win64 (x86_64)

--

-- Host: localhost Database: educational_part

-- ------------------------------------------------------

-- Server version 5.7.18-log

 

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

/*!40101 SET NAMES utf8 */;

/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;

/*!40103 SET TIME_ZONE='+00:00' */;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

 

--

-- Table structure for table `table_prepods`

--

 

DROP TABLE IF EXISTS `table_prepods`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `table_prepods` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`surname` varchar(45) NOT NULL,

`name` varchar(45) NOT NULL,

`patronomyc` varchar(45) NOT NULL,

PRIMARY KEY (`id`),

UNIQUE KEY `sname_name_pat_UNIQUE` (`surname`,`name`,`patronomyc`)

) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

 

--

-- Dumping data for table `table_prepods`

--

 

LOCK TABLES `table_prepods` WRITE;

/*!40000 ALTER TABLE `table_prepods` DISABLE KEYS */;

INSERT INTO `table_prepods` VALUES (24,'Эшанов','Алишер','Алимович');

/*!40000 ALTER TABLE `table_prepods` ENABLE KEYS */;

UNLOCK TABLES;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

 

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;

/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;

/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;

/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

 

-- Dump completed on 2017-05-31 22:55:13

 

CREATE DATABASE IF NOT EXISTS `educational_part` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `educational_part`;

-- MySQL dump 10.13 Distrib 5.7.17, for Win64 (x86_64)

--

-- Host: localhost Database: educational_part

-- ------------------------------------------------------

-- Server version 5.7.18-log

 

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

/*!40101 SET NAMES utf8 */;

/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;

/*!40103 SET TIME_ZONE='+00:00' */;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

 

--

-- Table structure for table `table_prepods_hours`

--

 

DROP TABLE IF EXISTS `table_prepods_hours`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `table_prepods_hours` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`id_prepods` int(11) NOT NULL,

`hoursPLAN` int(11) NOT NULL DEFAULT '0',

`hoursFACT` int(11) NOT NULL DEFAULT '0',

`hoursMAX` int(11) NOT NULL DEFAULT '0',

PRIMARY KEY (`id`),

UNIQUE KEY `id_prepods_UNIQUE` (`id_prepods`),

CONSTRAINT `id_table_Prepod` FOREIGN KEY (`id_prepods`) REFERENCES `table_prepods` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION

) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

 

--

-- Dumping data for table `table_prepods_hours`

--

 

LOCK TABLES `table_prepods_hours` WRITE;

/*!40000 ALTER TABLE `table_prepods_hours` DISABLE KEYS */;

INSERT INTO `table_prepods_hours` VALUES (6,24,435,0,720);

/*!40000 ALTER TABLE `table_prepods_hours` ENABLE KEYS */;

UNLOCK TABLES;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

 

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;

/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;

/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;

/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

 

-- Dump completed on 2017-05-31 22:55:13

 

CREATE DATABASE IF NOT EXISTS `educational_part` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `educational_part`;

-- MySQL dump 10.13 Distrib 5.7.17, for Win64 (x86_64)

--

-- Host: localhost Database: educational_part

-- ------------------------------------------------------

-- Server version 5.7.18-log

 

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

/*!40101 SET NAMES utf8 */;

/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;

/*!40103 SET TIME_ZONE='+00:00' */;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

 

--

-- Table structure for table `table_student`

--

 

DROP TABLE IF EXISTS `table_student`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `table_student` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`surname` varchar(45) NOT NULL,

`name` varchar(45) NOT NULL,

`patronomyc` varchar(45) NOT NULL,

`id_group` int(11) NOT NULL,

PRIMARY KEY (`id`),

UNIQUE KEY `sname_name_pat_Student_UNIQUE` (`surname`,`name`,`patronomyc`),

KEY `id_group_Student_idx` (`id_group`),

CONSTRAINT `id_group_Student` FOREIGN KEY (`id_group`) REFERENCES `table_group` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

 

--

-- Dumping data for table `table_student`

--

 

LOCK TABLES `table_student` WRITE;

/*!40000 ALTER TABLE `table_student` DISABLE KEYS */;

/*!40000 ALTER TABLE `table_student` ENABLE KEYS */;

UNLOCK TABLES;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

 

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;

/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;

/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;

/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

 

-- Dump completed on 2017-05-31 22:55:13

 

CREATE DATABASE IF NOT EXISTS `educational_part` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `educational_part`;

-- MySQL dump 10.13 Distrib 5.7.17, for Win64 (x86_64)

--

-- Host: localhost Database: educational_part

-- ------------------------------------------------------

-- Server version 5.7.18-log

 

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

/*!40101 SET NAMES utf8 */;

/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;

/*!40103 SET TIME_ZONE='+00:00' */;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

 

--

-- Table structure for table `table_users`

--

 

DROP TABLE IF EXISTS `table_users`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `table_users` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`login_user` varchar(45) NOT NULL,

`password_user` varchar(45) NOT NULL,

PRIMARY KEY (`id`),

UNIQUE KEY `login_user_UNIQUE` (`login_user`)

) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

 

--

-- Dumping data for table `table_users`

--

 

LOCK TABLES `table_users` WRITE;

/*!40000 ALTER TABLE `table_users` DISABLE KEYS */;

INSERT INTO `table_users` VALUES (3,'Admin','Iamadmin');

/*!40000 ALTER TABLE `table_users` ENABLE KEYS */;

UNLOCK TABLES;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

 

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;

/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;

/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;

/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

 

-- Dump completed on 2017-05-31 22:55:13

 

CREATE DATABASE IF NOT EXISTS `educational_part` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `educational_part`;

-- MySQL dump 10.13 Distrib 5.7.17, for Win64 (x86_64)

--

-- Host: localhost Database: educational_part

-- ------------------------------------------------------

-- Server version 5.7.18-log

 

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

/*!40101 SET NAMES utf8 */;

/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;

/*!40103 SET TIME_ZONE='+00:00' */;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

 

--

-- Table structure for table `table_zametki`

--

 

DROP TABLE IF EXISTS `table_zametki`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `table_zametki` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`date` date NOT NULL,

`name` varchar(45) NOT NULL,

`text` text,

`id_prepod` int(11) NOT NULL,

PRIMARY KEY (`id`),

UNIQUE KEY `index2` (`date`,`name`),

KEY `id_prepods_zametki_idx` (`id_prepod`),

CONSTRAINT `id_prepods_zametki` FOREIGN KEY (`id_prepod`) REFERENCES `table_prepods` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION

) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

 

--

-- Dumping data for table `table_zametki`

--

 

LOCK TABLES `table_zametki` WRITE;

/*!40000 ALTER TABLE `table_zametki` DISABLE KEYS */;

/*!40000 ALTER TABLE `table_zametki` ENABLE KEYS */;

UNLOCK TABLES;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

 

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;

/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;

/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;

/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

 

-- Dumpcompletedon 2017-05-31 22:55:13

 

ПРИЛОЖЕНИЕ 6 КЛИЕНТСКАЯ ЧАСТЬ ПРОЕКТА

mainwindow.h

#ifndef MAINWINDOW_H

#define MAINWINDOW_H

 

#include <QMainWindow>

#include <QSettings>

#include <QDateTime>

#include <QFile>

#include <QFileDialog>

#include <QLabel>

#include <QToolBar>

#include <QCloseEvent>

#include <QDebug>

#include <QShortcut>

 

#include "datebase.h"

 

#include "Forms/formsettingsconnect.h"

#include "Forms/formabout.h"

#include "Forms/formauthorization.h"

#include "Forms/formoneimport.h"

#include "Forms/formsqltablemodel.h"

#include "Forms/formsqlrealtiontwomodel.h"

#include "Forms/formviewtable.h"

#include "Forms/formheaviness.h"

#include "Forms/formjournal.h"

#include "Forms/formhoursdetal.h"

#include "Forms/formprepodszametka.h"

 

namespace Ui {

class MainWindow;

}

 

class MainWindow: public QMainWindow

{

Q_OBJECT

 

public:

explicit MainWindow(QWidget *parent = 0);

~ MainWindow ();

 

void loadingSettings(); //Загрузканастроек.

void setBasicFunctions(); //Установка базовых настроек.

void setToolBar(); //Установка инструментов.

void initializationEntrance(); //Инициализация

 

public slots:

void menuSettingsConnectSlot(); //Настройки.

void menuAboutSlot(); //Опрограмме.

 

//Документы

void menuFormOneImport(); // Экспортформа. (Шахтинская форма)

void menuCreateOneForm(); // Создание шахтенской формы.

void menuHeavines(); // Нагрузка.

void menuJournal(); //Электронный журнал.

void menuHoursDetal(); // Подробная расчасовка.

void menuPrepodZametka(); //Заметки преподователя.

void menuUPrepodZametka(); //Обновление заметки преподователя.

 

//Редактирование таблиц

void menuSqlTablePrepods(); // Таблица преподавателей.

void menuSqlTableGroup(); // Таблица групп.

void menuSqlTablePredmets(); //Таблица преподавателей.

void menuSqlRelationTableStudent(); //Таблица студентов.

void menuSqlRelationTableHoursPrepod(); //Таблица часов предметов.

 

//Просмотр таблиц

void menuViewPrepods(); //Просмотр таблицы преподователей.

void menuViewGroup(); //Просмотр таблицы групп.

void menuViewPredmets(); //Просмотр таблицы предметов.

void menuViewStudent(); //Просмотр таблицы студентов.

void menuViewTableHoursPrepod(); //Таблица часов предметов.

 

void messangeBox(QString title, QString text); //Окнооповещения.

void saveLog(QString textLog); //Записьвконфиг.

void closeTab(int indexWidget); //Закрытиевкладки.

void reconnectionDateBase(); //Переподключение к базе данных.

 

void authorizationAccept(); //Авторизация пройдена.

void exitApp(); //Выход из приложения.

 

void emptyJournal(); //Закрытиежурнала.

 

protected:

virtual void closeEvent (QCloseEvent *event);

 

private:

Ui::MainWindow *ui;

 

DateBase *bd; //Подключениекбд.

 

//Файлнастроек.

const QString fileSettings = "Settings.ini"; //Файлнастроек.

QString user; //Имя администратора бд.

QString password; //Пароль администратора.

QString ip; //Ip адресс базы данных.

QString path; //Путь к базе данных.

 

//Общие переменные.

const QString fileLog = "log.txt"; //Файл журнала.

bool firstSaveLog = false; //Переменная первой записи в лог.

 

//Виджеты

QLabel *connectDateBase; //Надпись состояния базы данных.

QLabel *buildVersion; //Надпись версии программы.

 

 void setShortcut(); //Назначение горячих клавиш.

};

 

#endif // MAINWINDOW_H

mainwindow.cpp

#include "mainwindow.h"

#include "ui_mainwindow.h"

 

MainWindow::MainWindow(QWidget *parent):

QMainWindow(parent),

ui(new Ui::MainWindow)

{

ui->setupUi(this);

//Загрузкапараметровнастройки.

saveLog("MainWindow: loadingSettings!");

loadingSettings();

 

//Объявлениепеременных.

bd = new DateBase(ip,path,user,password);

connectDateBase = new QLabel;

buildVersion = new QLabel;

 

//Расположениевиджетов.

ui->statusBar->addWidget(connectDateBase);

ui->statusBar->addWidget(buildVersion);

 

//Подлкючениеслотов.

connect(bd,SIGNAL(saveLog(QString)),this,SLOT(saveLog(QString)));

connect(bd, SIGNAL(authorizationAccept()),this,SLOT(authorizationAccept()));

connect(bd,SIGNAL(messangeBox(QString,QString)),this,SLOT(messangeBox(QString,QString)));

 

connect(ui->mainTabs,SIGNAL(tabCloseRequested(int)),this,SLOT(closeTab(int)));

 

connect(ui->actionSettingsConnect,SIGNAL(triggered(bool)),this,SLOT(menuSettingsConnectSlot()));

connect(ui->actionAbout,SIGNAL(triggered(bool)),this,SLOT(menuAboutSlot()));

connect(ui->actionExportOneForm,SIGNAL(triggered(bool)),this,SLOT(menuFormOneImport()));

connect(ui->actionCreateOneForm,SIGNAL(triggered(bool)),this,SLOT(menuCreateOneForm()));

 

connect(ui->actionSqlTablePrepods,SIGNAL(triggered(bool)),this,SLOT(menuSqlTablePrepods()));

connect(ui->actionSqlTablePredmets,SIGNAL(triggered(bool)),this,SLOT(menuSqlTablePredmets()));

connect(ui->actionSqlTableGroup,SIGNAL(triggered(bool)),this,SLOT(menuSqlTableGroup()));

connect(ui->actionSqlTableStudent,SIGNAL(triggered(bool)),this,SLOT(menuSqlRelationTableStudent()));

connect(ui->actionSqlTableHoursPrepods,SIGNAL(triggered(bool)),this,SLOT(menuSqlRelationTableHoursPrepod()));

 

connect(ui->actionViewPrepods,SIGNAL(triggered(bool)),this,SLOT(menuViewPrepods()));

connect(ui->actionViewGroup,SIGNAL(triggered(bool)),this,SLOT(menuViewGroup()));

connect(ui->actionViewPredmets,SIGNAL(triggered(bool)),this,SLOT(menuViewPredmets()));

connect(ui->actionViewStudent,SIGNAL(triggered(bool)),this,SLOT(menuViewStudent()));

connect(ui->actionViewHoursPrepods,SIGNAL(triggered(bool)),this,SLOT(menuViewTableHoursPrepod()));

 

connect(ui->actionHeaviness_3,SIGNAL(triggered(bool)),this,SLOT(menuHeavines()));

connect(ui->actionJournal, SIGNAL(triggered(bool)),this, SLOT(menuJournal()));

connect(ui->actionHoursDetal,SIGNAL(triggered(bool)),this,SLOT(menuHoursDetal()));

connect(ui->actionPrepodZamet,SIGNAL(triggered(bool)),this,SLOT(menuPrepodZametka()));

 

//Дополнительный вызов функций.

setBasicFunctions(); //Инициализация некоторых функций.

setToolBar(); //Создание инструментов.

initializationEntrance(); //Старт программы.

}

 

MainWindow::~ MainWindow ()

{

delete ui;

}

 

void MainWindow::loadingSettings()

{

//Настройки.

QSettings *settings = new QSettings(fileSettings, QSettings:: IniFormat);

//Загрузкапараметров.

settings->beginGroup("DateBase");

user = settings->value("User").toString();

password = settings->value("Password").toString();

ip = settings->value("Ip").toString();

path = settings->value("Path").toString();

//Записьвлог.

saveLog("MainWindow: User: " + user);

saveLog("MainWindow: Path: " + password);

saveLog("MainWindow: Ip: " + ip);

saveLog("MainWindow: Path: " + path);

}

 

void MainWindow::setBasicFunctions()

{

QString styleBuild = "QLabel {"

               "border-style: solid;"

               "border-width: 1px;"

               "border-color: black;"

               "color: blue;"

               "}";

QString styleColorTrue = "QLabel {"

                        "border-style: solid;"

                        "border-width: 1px;"

                        "border-color: black;"

                        "color: green;"

                        "}";

QString styleColorFalse = "QLabel {"

                         "border-style: solid;"

                         "border-width: 1px;"

                         "border-color: black;"

                        "color: red;"

                        "}";

buildVersion->setText("Версияпрограммы: build 0.3");

if(bd->isConnect()){

   connectDateBase->setText("Состояниеподключения: Подключён!");

   connectDateBase->setStyleSheet(styleColorTrue);

} else {

   connectDateBase->setText("Состояниеподключения: Отключён!");

   connectDateBase->setStyleSheet(styleColorFalse);

}

buildVersion->setStyleSheet(styleBuild);

}

 

void MainWindow::setToolBar()

{

ui->mainToolBar->addSeparator();

ui->mainToolBar->addAction(QIcon(":resources/icons/ReconnectionDateBase.png"),"Переподключениекбазеданных (Ctrl+R)",this,SLOT(reconnectionDateBase()));

}

 

void MainWindow::initializationEntrance()

{

ui->menuBar->setDisabled(true);

ui->mainToolBar->setDisabled(true);

 

FormAuthorization *formAuthorization = new FormAuthorization;

ui->mainTabs->addTab(formAuthorization,"Авторизацияпользователя");

formAuthorization->show();

ui->mainTabs->setCurrentWidget(formAuthorization);

connect(formAuthorization, SIGNAL(menuSettingsSlot()),this,SLOT(menuSettingsConnectSlot()));

connect(formAuthorization,SIGNAL(exitApp()),this,SLOT(exitApp()));

connect(formAuthorization,SIGNAL(saveLog(QString)),this,SLOT(saveLog(QString)));

connect(formAuthorization,SIGNAL(authorization(QString,QString)),bd,SLOT(authorizationSql(QString,QString)));

formAuthorization->loadUserSettings();

}

 

void MainWindow::menuSettingsConnectSlot()

{

saveLog("MainWindow: Настройкиподключения.");

FormSettingsConnect *formSettings = new FormSettingsConnect;

ui->mainTabs->addTab(formSettings,"Настройкиподключения");

formSettings->loadSettings(fileSettings);

connect(formSettings,SIGNAL(saveLog(QString)),this,SLOT(saveLog(QString)));

connect(formSettings,SIGNAL(reconnectionDateBase()),this,SLOT(reconnectionDateBase()));

formSettings->show();

ui->mainTabs->setCurrentWidget(formSettings);

}

 

void MainWindow::menuAboutSlot()

{

saveLog("MainWindow: Опрограмме.");

FormAbout *formAbout = new FormAbout;

ui->mainTabs->addTab(formAbout,"Опрограмме");

formAbout->show();

ui->mainTabs->setCurrentWidget(formAbout);

}

 

void MainWindow::saveLog(QString textLog)

{

qDebug() << "TextLog: " << textLog;

QFile logFile(fileLog);

if(logFile. open (QIODevice:: Append)){

   if(firstSaveLog){

       QString logText = QDateTime::currentDateTime().toString("dd.MM.yyyy HH:mm") + ": " + textLog + "\r\n";

       logFile.write(logText.toUtf8());

   } else {

       QString logText = QDateTime::currentDateTime().toString("dd.MM.yyyy HH:mm") + ": " + textLog + "\r\n";

       logFile.write("\r\n\r\n");

       logFile.write(logText.toUtf8());

       firstSaveLog = true;

   }

   logFile. close ();

}

}

 

void MainWindow::closeTab(int index)

{

ui->mainTabs->removeTab(index);

}

 

void MainWindow::reconnectionDateBase()

{

//Загрузкапараметровнастройки.

saveLog("MainWindow: loadingSettings!");

loadingSettings();

//Перезагрузкабд.

bd = new DateBase(ip,path,user,password);

connect(bd,SIGNAL(saveLog(QString)),this,SLOT(saveLog(QString)));

connect(bd, SIGNAL(authorizationAccept()),this,SLOT(authorizationAccept()));

connect(bd,SIGNAL(messangeBox(QString,QString)),this,SLOT(messangeBox(QString,QString)));

//Дополнительныйвызовфункций.

setBasicFunctions();

}

 

void MainWindow::menuHeavines()

{

FormHeaviness *formHeaviness = new FormHeaviness(bd);

ui->mainTabs->addTab(formHeaviness, "Ф:Нагрузка");

formHeaviness->show();

ui->mainTabs->setCurrentWidget(formHeaviness);

connect(formHeaviness,SIGNAL(saveLog(QString)),this,SLOT(saveLog(QString)));

connect(formHeaviness,SIGNAL(messangeBox(QString,QString)),this,SLOT(messangeBox(QString,QString)));

}

 

void MainWindow::authorizationAccept()

{

ui->menuBar->setDisabled(false);

ui->mainToolBar->setDisabled(false);

 

ui->mainTabs->setTabsClosable(true);

ui->mainTabs->setTabBarAutoHide(false);

 

for(int i = 0; i < ui->mainTabs->count(); i++){

   ui->mainTabs->removeTab(i);

}

 

setShortcut();

}

 

void MainWindow::exitApp()

{

QMessageBox::StandardButton reply;

reply = QMessageBox::question(this,"Оповещение","Выуверены, чтохотитевыйти?",QMessageBox:: Yes |QMessageBox:: No);

if(reply == QMessageBox:: Yes)

   exit(0);

}

 

void MainWindow::emptyJournal()

{

qDebug() << "asdasd";

ui->mainTabs->removeTab(ui->mainTabs->currentIndex());

}

 

void MainWindow::messangeBox(QString title, QString text)

{

QMessageBox::information(this,title,text);

}

 

void MainWindow::menuFormOneImport()

{

QString fileName = QFileDialog::getOpenFileName(this, "Выбиритешахтинскуюформудляимпорта.","","Import Files (*.osf)");

if(!fileName.isEmpty()){

   FormOneImport *formOneImport = new FormOneImport(fileName);

   ui->mainTabs->addTab(formOneImport, "Ш/Ф:" + fileName.split("/").at(fileName.split("/").size()-1));

   formOneImport->show();

   ui->mainTabs->setCurrentWidget(formOneImport);

   connect(formOneImport,SIGNAL(saveLog(QString)),this,SLOT(saveLog(QString)));

   connect(formOneImport,SIGNAL(messangeBox(QString,QString)),this,SLOT(messangeBox(QString,QString)));

   connect(formOneImport,SIGNAL(saveDatabaseSignal(ImportTableData*)),bd,SLOT(insertImportTableDate(ImportTableData*)));

}

}

 

void MainWindow::menuCreateOneForm()

{

FormOneImport *formOneImport = new FormOneImport(NULL);

ui->mainTabs->addTab(formOneImport, "Ш/Ф:Новая");

formOneImport->show();

ui->mainTabs->setCurrentWidget(formOneImport);

connect(formOneImport,SIGNAL(saveLog(QString)),this,SLOT(saveLog(QString)));

connect(formOneImport,SIGNAL(messangeBox(QString,QString)),this,SLOT(messangeBox(QString,QString)));

connect(formOneImport,SIGNAL(saveDatabaseSignal(ImportTableData*)),bd,SLOT(insertImportTableDate(ImportTableData*)));

}

 

void MainWindow::menuJournal()

{

FormJournal *formJournal = new FormJournal(bd);

ui->mainTabs->addTab(formJournal, "Э.Журнал");

formJournal->show();

ui->mainTabs->setCurrentWidget(formJournal);

connect(formJournal,SIGNAL(saveLog(QString)),this,SLOT(saveLog(QString)));

connect(formJournal,SIGNAL(messangeBox(QString,QString)),this,SLOT(messangeBox(QString,QString)));

connect(formJournal,SIGNAL(closeEmpty()),this,SLOT(emptyJournal()));

}

 

void MainWindow::menuHoursDetal()

{

FormHoursDetal *formHoursDetal = new FormHoursDetal(bd->getViewTable(7));

ui->mainTabs->addTab(formHoursDetal, "Подробныечасы");

formHoursDetal->show();

ui->mainTabs->setCurrentWidget(formHoursDetal);

connect(formHoursDetal,SIGNAL(saveLog(QString)),this,SLOT(saveLog(QString)));

connect(formHoursDetal,SIGNAL(messangeBox(QString,QString)),this,SLOT(messangeBox(QString,QString)));

}

 

void MainWindow::menuPrepodZametka()

{

FormPrepodsZametka *fPz = new FormPrepodsZametka;

fPz->setBd(bd);

ui->mainTabs->addTab(fPz, "Заметкипреподавателя");

fPz->show();

ui->mainTabs->setCurrentWidget(fPz);

fPz->update();

connect(fPz,SIGNAL(updateZ()),this, SLOT(menuUPrepodZametka()));

}

 

void MainWindow::menuUPrepodZametka()

{

ui->mainTabs->removeTab(ui->mainTabs->currentIndex());

FormPrepodsZametka *fPz = new FormPrepodsZametka;

fPz->setBd(bd);

ui->mainTabs->addTab(fPz, "Заметки преподавателя");

fPz->show();

ui->mainTabs->setCurrentWidget(fPz);

fPz->update();

}

 

void MainWindow::menuSqlTablePrepods()

{

FormSqlTAbleModel *formSqlTablePrepods = new FormSqlTAbleModel(bd->getModelTable(1),"Номерпреподавателя@Фамилия@Имя@Отчество");

ui->mainTabs->addTab(formSqlTablePrepods, "Т:Преподавателей");

formSqlTablePrepods->show();

ui->mainTabs->setCurrentWidget(formSqlTablePrepods);

connect(formSqlTablePrepods,SIGNAL(saveLog(QString)),this,SLOT(saveLog(QString)));

connect(formSqlTablePrepods,SIGNAL(messangeBox(QString,QString)),this,SLOT(messangeBox(QString,QString)));

}

 

void MainWindow::menuSqlTableGroup()

{

FormSqlTAbleModel *formSqlTableGroup = new FormSqlTAbleModel(bd->getModelTable(2),"Номергруппы@Название@Курс@Семестр");

ui->mainTabs->addTab(formSqlTableGroup, "Т:Групп");

formSqlTableGroup->show();

ui->mainTabs->setCurrentWidget(formSqlTableGroup);

connect(formSqlTableGroup,SIGNAL(saveLog(QString)),this,SLOT(saveLog(QString)));

connect(formSqlTableGroup,SIGNAL(messangeBox(QString,QString)),this,SLOT(messangeBox(QString,QString)));

}

 

void MainWindow::menuSqlTablePredmets()

{

FormSqlTAbleModel *formSqlTablePredmets = new FormSqlTAbleModel(bd->getModelTable(3),"Номерпредмета@Название@Шифр");

ui->mainTabs->addTab(formSqlTablePredmets, "Т:Предметов");

formSqlTablePredmets->show();

ui->mainTabs->setCurrentWidget(formSqlTablePredmets);

connect(formSqlTablePredmets,SIGNAL(saveLog(QString)),this,SLOT(saveLog(QString)));

connect(formSqlTablePredmets,SIGNAL(messangeBox(QString,QString)),this,SLOT(messangeBox(QString,QString)));

}

 

void MainWindow::menuSqlRelationTableStudent()

{

QList<int> list;

FormSqlRealtionTwoModel *formSqlRelationTableStudent = new FormSqlRealtionTwoModel(bd->getModelTwoRelationTable(1),"Номерстудента@Фамилия@Имя@Отчество@Названиегруппы","Номергруппы@Название@Курс@Семестр",4,list);

ui->mainTabs->addTab(formSqlRelationTableStudent, "Т:Студентов");

formSqlRelationTableStudent->show();

ui->mainTabs->setCurrentWidget(formSqlRelationTableStudent);

connect(formSqlRelationTableStudent,SIGNAL(saveLog(QString)),this,SLOT(saveLog(QString)));

connect(formSqlRelationTableStudent,SIGNAL(messangeBox(QString,QString)),this,SLOT(messangeBox(QString,QString)));

}

 

void MainWindow::menuSqlRelationTableHoursPrepod()

{

QList<int> list;

list.append(2);

list.append(3);

FormSqlRealtionTwoModel *formSqlRelationTableHoursPrepod = new FormSqlRealtionTwoModel(bd->getModelTwoRelationTable(2),"Номерзаписи@Фамилия@Плановыечасы@Фактическиечасы@Максимальныечасы","Номерпреподавателя@Фамилия@Имя@Отчество",1,list);

ui->mainTabs->addTab(formSqlRelationTableHoursPrepod, "Т:Ч.Преподавателей");

formSqlRelationTableHoursPrepod->show();

ui->mainTabs->setCurrentWidget(formSqlRelationTableHoursPrepod);

connect(formSqlRelationTableHoursPrepod,SIGNAL(saveLog(QString)),this,SLOT(saveLog(QString)));

connect(formSqlRelationTableHoursPrepod,SIGNAL(messangeBox(QString,QString)),this,SLOT(messangeBox(QString,QString)));

}

 

void MainWindow::menuViewPrepods()

{

QStringList listHeader;

listHeader.append("Номерпреподавателя");

listHeader.append("Фамилия");

listHeader.append("Имя");

listHeader.append("Отчество");

FormViewTable *formViewPrepods = new FormViewTable(bd->getViewTable(1),listHeader);

ui->mainTabs->addTab(formViewPrepods, "П:Преподавателей");

formViewPrepods->show();

ui->mainTabs->setCurrentWidget(formViewPrepods);

connect(formViewPrepods,SIGNAL(saveLog(QString)),this,SLOT(saveLog(QString)));

connect(formViewPrepods,SIGNAL(messangeBox(QString,QString)),this,SLOT(messangeBox(QString,QString)));

}

 

void MainWindow::menuViewGroup()

{

QStringList listHeader;

listHeader.append("Номергруппы");

listHeader.append("Названиегруппы");

listHeader.append("Курс");

listHeader.append("Семестр");

FormViewTable *formViewGroup = new FormViewTable(bd->getViewTable(2),listHeader);

ui->mainTabs->addTab(formViewGroup, "П:Групп");

formViewGroup->show();

ui->mainTabs->setCurrentWidget(formViewGroup);

connect(formViewGroup,SIGNAL(saveLog(QString)),this,SLOT(saveLog(QString)));

connect(formViewGroup,SIGNAL(messangeBox(QString,QString)),this,SLOT(messangeBox(QString,QString)));

}

 

void MainWindow::menuViewPredmets()

{

QStringList listHeader;

listHeader.append("Номерпредмета");

listHeader.append("Названиепредмета");

listHeader.append("Шифрпредмета");

FormViewTable *formViewPredmets = new FormViewTable(bd->getViewTable(3),listHeader);

ui->mainTabs->addTab(formViewPredmets, "П:Предметов");

formViewPredmets->show();

ui->mainTabs->setCurrentWidget(formViewPredmets);

connect(formViewPredmets,SIGNAL(saveLog(QString)),this,SLOT(saveLog(QString)));

connect(formViewPredmets,SIGNAL(messangeBox(QString,QString)),this,SLOT(messangeBox(QString,QString)));

}

 

void MainWindow::menuViewStudent()

{

QStringList listHeader;

listHeader.append("Номерстудента");

listHeader.append("Фамилия");

listHeader.append("Имя");

listHeader.append("Отчество");

listHeader.append("Названиегруппы");

listHeader.append("Курс");

listHeader.append("Семестр");

FormViewTable *formViewStudent = new FormViewTable(bd->getViewTable(4),listHeader);

ui->mainTabs->addTab(formViewStudent, "П:Студентов");

formViewStudent->show();

ui->mainTabs->setCurrentWidget(formViewStudent);

connect(formViewStudent,SIGNAL(saveLog(QString)),this,SLOT(saveLog(QString)));

connect(formViewStudent,SIGNAL(messangeBox(QString,QString)),this,SLOT(messangeBox(QString,QString)));

}

 

void MainWindow::menuViewTableHoursPrepod()

{

QStringList listHeader;

listHeader.append("Номерзаписи");

listHeader.append("Фамилия");

listHeader.append("Имя");

listHeader.append("Отчество");

listHeader.append("Плановыечасы");

listHeader.append("Фактическиечасы");

listHeader.append("Максимальныечасы");

FormViewTable *formViewHoursPrepod = new FormViewTable(bd->getViewTable(5),listHeader);

ui->mainTabs->addTab(formViewHoursPrepod, "П:Ч.Преподавателей");

formViewHoursPrepod->show();

ui->mainTabs->setCurrentWidget(formViewHoursPrepod);

connect(formViewHoursPrepod,SIGNAL(saveLog(QString)),this,SLOT(saveLog(QString)));

connect(formViewHoursPrepod,SIGNAL(messangeBox(QString,QString)),this,SLOT(messangeBox(QString,QString)));

}

 

void MainWindow:: closeEvent (QCloseEvent *event)

{

QMessageBox::StandardButton reply;

reply = QMessageBox::question(this,"Оповещение","Выуверены, чтохотитевыйти?",QMessageBox:: Yes |QMessageBox:: No);

if(reply == QMessageBox:: No)

   event->ignore();

}

 

void MainWindow::setShortcut()

{

QShortcut *keyCtrlI = new QShortcut(this);

keyCtrlI