Download address: download.csdn.net/download/qq…

Project introduction

PHP based on Thinkphp3.2 graduation topic selection system source

System specifications

Undergraduate graduation design project selected topic system based on Thinkphp3.2 pick to at present, most universities have begun to apply more perfect management system, such as educational administration management system, student course selection management system of information management system, but in view of the student of graduation design related management operation, and some are still using the traditional working mode, In order to improve the efficiency of management, we design and develop “graduation design online management system”. The system is designed and built based on B/S architecture, and the overall development uses MVC design pattern. The dynamic web development language used is the popular PHP language, and the foreground uses HTML5 and CSS3, namely Media Query technology to develop the management system. The B/S architecture avoids cross-platform problems caused by the differences in operating systems. MVC design pattern separates logic operation, data processing and page display, and improves system development efficiency to a certain extent. The system consists of three modules, which are system management module, teacher operation module and student operation module respectively. The system management module can manage the personal information and messages of teachers and students, audit the subject declared by teachers, and send system messages to facilitate notification; The teacher operation module can declare the topic, browse the status of the students who have passed the audit topic, view the progress of the students who have selected the topic and the message notice; The student operation module can select the topic, view the contact information that the subject teacher can publish, withdraw the selected but not determined subject, browse the subject situation, submit the completion progress and message notification, etc. The use of this system will improve the efficiency of graduation design.

Key words: B/S architecture; MVC design framework; Graduation project topic selection; Management system

Abstract

Nowadays, most colleges and universities have been in use for more perfect management system, such as educational administration management system, student course selection management system of information management system, but in view of the student of graduation design related management operation, some colleges and universities are still using the traditional working mode, to provide the efficiency of information management, we designed and developed “graduation design online management system”. The system based on B / S architecture was designed and built. The overall development using the MVC design pattern, the use of dynamic web development language too popular PHP language, the front desk using the HTML 5 and CSS 3 Media Query technology development management system management system, B/S structure to avoid the problem caused by different operating system cross-platform, MVC design pattern makes the logic operation, data processing and the page display phase separation, in a certain extent, improve the efficiency of system development. This system has three modules, respectively, the administrator module, teacher module and student module. Administrators can manage personal information and message to teachers and students, the teachers declare project audit, and can send messages to inform; Teacher module can declare topic, browse has passed the audit subject subject status of students, view has been selected topic the student’s progress, and notification; Topic selection, students can view the subject teachers can be released by the contact information, for the selected topic for withdrawal operation, but has not yet been determined through project, submit the project schedule and alerts, etc. The use of the system will improve the graduation design of this part of the work efficiency.

Keywords: B/S Architecture; MVC design framework; graduate design topics; management system

1.1 Teachers’ needs In the topic selection of graduation project, teachers’ needs are: user personal information management; New project application, failed to pass the deletion, modification and re-application of the audit project; The selection of selected students; Project progress check and message management. 1.2 Students’ Needs In the topic selection of graduation project, students’ needs are: user personal information management; Subject to browse view, select and quit the operation; If the subject has been identified, the details of the subject can be viewed. Project schedule management; Management operations such as sending and receiving messages. 1.3 Requirements of Administrators In the topic selection of graduation project, the requirements of system administrators are as follows: Student management (new students, delete students, and students’ login system data initialization), teacher management, new teachers, delete, and teacher system login data initialization), project management, to review the new teacher, to subject, to delete an illegal subject), user management, the new administrator of each authority level, delete the administrator, the subset Permission group Administrator Initializes system login data) and message notification (publishing system messages of different objects, viewing and deleting all messages).

2 Design Mode 2.1 MVC Design Mode The MVC (Model View Controller) design mode is short for model-View-Controller. As a layered design concept, it aims to achieve a dynamic and separable program design, which is easier to modify and expand the program. And increase the reuse rate of certain parts of the program. 2.2 RBAC (Role-based Access Control) Role-based Access Control. System permissions are associated with user roles. Users get corresponding permissions by becoming members of appropriate roles. Role-based access control model is more neutral and flexible than mandatory access control and discretionary access control.

3 Overall system design 3.1 Overall Functional module System structure diagram 3.1.1 Teacher module The main page of teacher module includes personal management, new topics, topic list management, message management and progress list management. 3.1.2 Student Module The main page of student module includes personal management, my project, project list, project selection, message management and schedule management. 3.1.3 Administrator module Administrator module main page has personal management, student list management, teacher list management, subject list management, message list management, user list management. 3.2 Interface design 3.2.1 Teacher interface Teacher interface design layout is composed of horizontal navigation bar, breadcrumb navigation and page content. The background color of the horizontal navigation bar will change when the mouse hangs, and the background color of the selected column is different from that of the unselected column. The current column of breadcrumb navigation cannot be operated, and the parent column can be directly returned. Media Query technology is used to realize the responsive layout display, as shown in the figure, which is the page after the successful login of teachers. Teachers’ successful login figure 3.2.2 students interface interface design layout for the sidebar navigation, bread crumbs navigation and page content, the sidebar navigation mouse-over the background will change color, background color of the selected columns in did not select the background color, bread crumbs navigation current columns not operation, can be directly return value parent column, use the layout position and JS technology, Sliding display and hiding of the sidebar navigation can be realized, and the page can realize responsive layout, as shown in the figure, which is the page after the successful login of students. Students successful login figure 3.2.3 administrator backstage administrator interface design layout for integrated navigation (horizontal navigation bar for the primary section, the sidebar navigation for the child under the corresponding level column), bread crumbs navigation and page content, select the background color of primary and secondary columns in did not select the background color, bread crumbs navigation current columns cannot operation, The parent column can be returned directly. The page is in a responsive layout, as shown in the figure, which is the page after the super administrator successfully logs in. According to the demand analysis of the system, the system data entity relationship diagram, as shown in the figure: DATABASE entity relationship ER figure 3.3.2 Database constraint relationship diagram System database should contain data tables mainly have: The constraint relations among the system administrator table, administrator group permission table, professional information table, teacher information table, student information table, project schedule table, project information table, topic selection information table and message table are shown in the figure below: Table constraint diagram 3.3.3 Data table Structure The system uses data tables including administrator table, student table, teacher table, subject information table, message table, permission table, professional table, subject schedule table, topic selection table. The following is a brief overview of each table: 1. The administrator table is associated with the permission table to form the administrator role with different management permissions. The design of the table includes: number, login account, login password and other fields, as shown in the table: No. Column Name Data Type Primary Key Allowed Null Value Remarks 1 adminId int Yes No Primary key ID 2 adminName Varchar(32) No No Login account 3 adminPwd Varchar(32) No No Login password 4 AdminRealName Varchar(32) No Yes Real name 5 adminSex Tinyint No Yes User gender 6 adminAge Tinyint No Yes User age 7 adminPhone Varchar(11) No Yes Contact Information 8 adminEmail Varchar(32) No Yes Email address 9 adminAddress Varchar(256) No Yes Address 10 createTime Varchar(12) No No Creation time 11 UpdateTime Varchar(12) no no updateTime 12 state Tinyint no no permission group 2, the student table is used to store the student’s personal information and academic information. The table is designed as follows: Fields such as number, login account and login password are shown in the table: No column Name Data Type Primary Key Allowed Blank Value Remarks 1 stuId int Yes No Primary key ID 2 stuCard Varchar(32) No No Login account 3 stuPwd Varchar(32) No No Login password 4 StuRealName Varchar(32) No Yes Real name 5 stuSex Tinyint No Yes User gender 6 stuAge Tinyint No Yes User age 7 stuPhone Varchar(11) No Yes Contact information 8 StuEmail Varchar(32) No Yes Email address 9 stuMajor Tinyint No Yes Professional information 10 createTime Varchar(12) No No Creation time 11 updateTime Varchar(12) No No Update time 12 state Tinyint No No 3. The teacher table is mainly used to store teachers’ personal information, which is associated with the subject information table. The design of the table includes: number, login account, login password and other fields, as shown in the table: Student Table Sn Column Name Data Type Primary Key Allowed Null Value Remarks 1 thrId int Yes No Primary key ID 2 thrName Varchar(32) No No Login account 3 thrPwd Varchar(32) No No Login password 4 ThrRealName Varchar(32) No Yes Real name 5 thrSex Tinyint No Yes User gender 6 thrAge Tinyint No Yes User age 7 thrStudy Varchar(128) No Yes Research Direction 8 ThrPhone Varchar(11) No Yes Contact information 9 thrEmail Varchar(32) No Yes Email address 10 thrAddress Varchar(256) No Yes Office address 11 showState Char(4) No Yes optional 12 createTime Varchar(12) no no creation time 13 updateTime Varchar(12) no no updateTime 14 state Tinyint no no 4. The project table is used to store project information. Associated with the teacher table, the table design includes: no., teacher ID, topic title and other fields, as shown in the table: Item Table No. Column Name Data Type Primary Key Allowed Blank Value Remarks 1 gpId INT Yes No Primary key ID 2 gpThrId INT No No Teacher ID 3 gpTitle Varchar(128) No No Project title 4 gpContent Varchar(512) No No Project Content 5 gpAim Varchar(128) No No Project Objective 6 gpRequest Varchar(128) No No Project Requirements 7 gpMust Varchar(128) No No Required Knowledge 8 GpFormal Varchar(128) No No Submission Form 9 gpOthers Varchar(512) No Yes Others 10 gpSHState TINyInt No No Soft/hardware 11 createTime Varchar(12) No No Created at 12 updateTime Varchar(12) No No Updated at 13 State Tinyint No No Project status