Skip to content

Commit eb5262e

Browse files
hb_java@sina.comhb_java@sina.com
hb_java@sina.com
authored and
hb_java@sina.com
committed
init quiz
1 parent 2a60c7e commit eb5262e

86 files changed

Lines changed: 7851 additions & 1874 deletions

File tree

Some content is hidden

Large Commits have some content hidden by default. Use the searchbox below for content that may be hidden.

‎helloworld-springboot/ngla.sql‎

Lines changed: 65 additions & 89 deletions
Original file line numberDiff line numberDiff line change
@@ -1,6 +1,6 @@
11
/*==============================================================*/
22
/* DBMS name: PostgreSQL 9.x */
3-
/* Created on: 2/12/2018 9:15:54 AM */
3+
/* Created on: 3/13/2018 3:57:14 PM */
44
/*==============================================================*/
55

66

@@ -12,6 +12,14 @@ drop table LA_GOLDEN_SAMPLE;
1212

1313
drop table LA_MESSAGE;
1414

15+
drop table LA_PAPER;
16+
17+
drop table LA_QUESTION;
18+
19+
drop table LA_QUIZ;
20+
21+
drop table LA_QUIZ_RECORD;
22+
1523
drop table LA_RECORD;
1624

1725
drop table LA_RL_HISTORY;
@@ -40,7 +48,7 @@ create table LA_COURSE (
4048
create table LA_CRS_HISTORY (
4149
HSTR_USR_ID varchar not null,
4250
HSTR_CRS_ID int not null,
43-
HSTR_UPDATE_TIME TIMESTAMP not null
51+
HSTR_UPDATE_TIME TIMESTAMP not null
4452
);
4553

4654
/*==============================================================*/
@@ -74,6 +82,61 @@ create table LA_MESSAGE (
7482
constraint PK_LA_MESSAGE primary key (MSG_ID)
7583
);
7684

85+
/*==============================================================*/
86+
/* Table: LA_PAPER */
87+
/*==============================================================*/
88+
create table LA_PAPER (
89+
PPR_ID SERIAL not null,
90+
PPR_QUZ_ID INT4 not null,
91+
PPR_USR_ID VARCHAR not null,
92+
PPR_CONTENT VARCHAR not null,
93+
PPR_STANDARD VARCHAR not null,
94+
PPR_ANSWER VARCHAR not null,
95+
PPR_UPDATE_TIME TIMESTAMP not null,
96+
PPR_SCORE INT4 null,
97+
PPR_TOTAL INT4 not null,
98+
PPR_INDEX INT4 not null,
99+
constraint PK_LA_PAPER primary key (PPR_ID)
100+
);
101+
102+
/*==============================================================*/
103+
/* Table: LA_QUESTION */
104+
/*==============================================================*/
105+
create table LA_QUESTION (
106+
QUST_QUIZ_ID int4 not null,
107+
QUST_SUBJECT varchar not null,
108+
QUST_CHOICES varchar not null,
109+
QUST_ANSWER varchar not null,
110+
QUST_NUMBER int4 not null
111+
);
112+
113+
/*==============================================================*/
114+
/* Table: LA_QUIZ */
115+
/*==============================================================*/
116+
create table LA_QUIZ (
117+
QUZ_ID SERIAL not null,
118+
QUZ_CRS_ID int4 not null,
119+
QUZ_ACTIVE_TIME TIMESTAMP not null,
120+
QUZ_AUDIENCE_TYPE VARCHAR(1) not null,
121+
QUZ_AUDIENCE_LIST VARCHAR not null,
122+
QUZ_ACTIVE BOOL not null,
123+
QUZ_UPDATE_TIME TIMESTAMP not null,
124+
constraint PK_LA_QUIZ primary key (QUZ_ID)
125+
);
126+
127+
/*==============================================================*/
128+
/* Table: LA_QUIZ_RECORD */
129+
/*==============================================================*/
130+
create table LA_QUIZ_RECORD (
131+
RCRD_ID SERIAL not null,
132+
RCRD_QUZ_ID int not null,
133+
RCRD_USR_ID VARCHAR not null,
134+
RCRD_ACTIVE BOOL not null,
135+
RCRD_SUBJECT varchar not null,
136+
RCRD_CHOICES varchar not null,
137+
constraint PK_LA_QUIZ_RECORD primary key (RCRD_ID)
138+
);
139+
77140
/*==============================================================*/
78141
/* Table: LA_RECORD */
79142
/*==============================================================*/
@@ -124,90 +187,3 @@ create table LA_USER (
124187
constraint PK_LA_USER primary key (USR_ID)
125188
);
126189

127-
insert into la_course(CRS_NAME,CRS_STARTDATE,CRS_ENDDATE,CRS_PRICE,CRS_ACTIVE)
128-
values
129-
('Englc: CNS Bi-Weekly Workshop - BU Product Introduction','3/1/2018','3/1/2018',299,true),
130-
('Englc: Code Craft:The Practice of Writing Excellent Code','3/2/2018','3/2/2018',299,true),
131-
('Englc: Communicating with Clarity and Confidence in Professional English','3/3/2018','3/3/2018',299,true),
132-
('Englc: Communication & Influence','3/4/2018','3/4/2018',299,true),
133-
('Englc: Core Python Programing','3/5/2018','3/5/2018',299,true),
134-
('Englc: CRDC Business Process & Compliance Training','3/6/2018','3/6/2018',0,true),
135-
('Englc: CRDC Compliance Workshop for People Manager','3/7/2018','3/7/2018',299,true),
136-
('Englc: CRDC New Star Program Campus New Hire Orientation','3/8/2018','3/8/2018',299,true),
137-
('Englc: CRDC New Star Program Orientation','3/9/2018','3/9/2018',299,true),
138-
('Englc: CRDC Rising Star Program Orientation for Intern','3/10/2018','3/10/2018',299,true),
139-
('Englc: Data Mining and Analytics: Developing Machine Learning with Python','3/11/2018','3/11/2018',299,true),
140-
('Englc: Data Mining and Analytics: Developing Web Crawler with Python','3/12/2018','3/12/2018',299,true),
141-
('Englc: Deep Learning Fundamental: Neural Networks and Algorithm','3/13/2018','3/13/2018',299,true),
142-
('Englc: Deep Learning with TensorFlow','3/14/2018','3/14/2018',350,true),
143-
('Englc: Deep Learning: Convolutional Neural Networks','3/15/2018','3/15/2018',350,true),
144-
('Englc: Deep Learning: Developing Neural Networks with Tensorflow','3/16/2018','3/16/2018',350,true),
145-
('Englc: Deep Learning: Recurrent Neural Network and Computing Accelation Technology','3/17/2018','3/17/2018',299,true),
146-
('Englc: Designing Your IOT: Architecture, Protocols and Implementation','3/18/2018','3/18/2018',299,true),
147-
('Englc: Developing Single Web Page with Angular.JS','3/19/2018','3/19/2018',299,true),
148-
('Englc: Docker Advanced: Cluster Management and Microservice Development','3/20/2018','3/20/2018',299,true),
149-
('Englc: Docker Fundamentals: Concept and Development Practice','3/21/2018','3/21/2018',299,true),
150-
('Englc: Effective Communication for Engineering Sustaining','3/22/2018','3/22/2018',299,true),
151-
('Englc: EMI Suppression and Anti-interference Design and Case Study','3/23/2018','3/23/2018',299,true),
152-
('Englc: English Email Writing Workshop','3/24/2018','3/24/2018',299,true),
153-
('Englc: From Backpack to Professional Effective Communication & Time Management','3/25/2018','3/25/2018',299,true),
154-
('Englc: From Backpack to Professional Understanding Cross-Culture Impacts & Effective Business Email Writing','3/26/2018','3/26/2018',299,true),
155-
('Englc: Front-End Web Architect: JavaScript Essential','3/27/2018','3/27/2018',299,true),
156-
('EngLc: Hadoop 2.0 Architecture and Practice','3/28/2018','3/28/2018',299,true),
157-
('Englc: High Impact Presentation Skills','3/29/2018','3/29/2018',299,true),
158-
('Englc: HTML5 & CSS3.0 Development (Filpped Classroom)','3/30/2018','3/30/2018',299,true),
159-
('Englc: Introduction to Git: Version Control and Management','3/31/2018','3/31/2018',299,true),
160-
('Englc: Introduction to RESTful Architecture','4/1/2018','4/1/2018',299,true),
161-
('Englc: Java Spring Training','4/2/2018','4/2/2018',299,true),
162-
('Englc: JavaScript & CSS2.0 Development (Filpped Classroom)','4/3/2018','4/3/2018',299,true),
163-
('Englc: Kubernetes Fundamentals: Concept, Architecture and Network Models','4/4/2018','4/4/2018',299,true),
164-
('Englc: Large Scale Website Architecture Design: Key Technologies','4/5/2018','4/5/2018',299,true),
165-
('Englc: Linux Virtualization and Hypervisor - KVM, XEN, DOCKER etc','4/6/2018','4/6/2018',230,true),
166-
('Englc: Machine Learning: Natural Language Processing (NLP)','4/7/2018','4/7/2018',245,true),
167-
('Englc: Micro Service Architecture and Practice','4/8/2018','4/8/2018',299,true),
168-
('Englc: Microservice Advanced: Key Technologies and Deployment','4/9/2018','4/9/2018',299,true),
169-
('Englc: Microservice Application Developing Fundamentals','4/10/2018','4/10/2018',299,true),
170-
('Englc: Networking Fundamental (CCNA Bootcamp)','4/11/2018','4/11/2018',499,true),
171-
('Englc: OpenStack Fundamental','4/12/2018','4/12/2018',299,true),
172-
('Englc: Presenting yourself with Confidence and Ease for Managers','4/13/2018','4/13/2018',299,true),
173-
('Englc: Python Programming Advanced Part I (Chinese Language)','4/14/2018','4/14/2018',299,true),
174-
('Englc: Python Programming Fundamental','4/15/2018','4/15/2018',299,true),
175-
('Englc: Redis NoSql Database Development','4/16/2018','4/16/2018',299,true),
176-
('Englc: Rising Star Challenge','4/17/2018','4/17/2018',0,true),
177-
('Englc: Scrum Fundamentals for Teams','4/18/2018','4/18/2018',350,true),
178-
('Englc: Signal Integrity Series - Channel Inter Symbol Interference and Crosstalk Analysis Methods','4/19/2018','4/19/2018',299,true),
179-
('Englc: Software Architecture: Best Practice and Case Study','4/20/2018','4/20/2018',299,true),
180-
('Englc: Spark Fundamentals - Concept, Ecosystem and Applications','4/21/2018','4/21/2018',299,true),
181-
('Englc: Spark Programming Training','4/22/2018','4/22/2018',299,true),
182-
('Englc: TCL Programming Fundamentals','4/23/2018','4/23/2018',299,true),
183-
('Englc: TechDive: Introduction to Virtual Reality','4/24/2018','4/24/2018',299,true),
184-
('Englc: THE NETWORK.INTUITIVE.Learning Workshop: Catalyst 9K and DNA Licensing Model','4/25/2018','4/25/2018',299,true),
185-
('Englc: Thermal Design, Analysis and Testing','4/26/2018','4/26/2018',299,true),
186-
('Englc: TLI - Influential Communication','4/27/2018','4/27/2018',299,true),
187-
('Englc: TLI - Innovation with Biz Acumen','4/28/2018','4/28/2018',299,true),
188-
('Englc: Unit Testing Best Practices for Software Developer','4/29/2018','4/29/2018',299,true),
189-
('Englc: Web Automation Test and CI: Framwork, Methodology and Tools','4/30/2018','4/30/2018',299,true),
190-
('Englc: Web UI Design Workshop','5/1/2018','5/1/2018',299,true),
191-
('Englc: WhatsTech: Automatic OpenStack: Ceilometer and Heat','5/2/2018','5/2/2018',299,true),
192-
('Englc: WhatsTech: Deep Dive to the Technologies of Cisco Intuitive Network','5/3/2018','5/3/2018',299,true),
193-
('Englc: WhatsTech: IOT Smart?Grid Application?Architecture and Solution','5/4/2018','5/4/2018',299,true),
194-
('Englc: WhatsTech: JD.com Infrastructure Evolution: Migration from Tradition to Cloud','5/5/2018','5/5/2018',299,true),
195-
('Englc: WhatsTech: Kubernetes Advanced: Network, Microservice and Usecase','5/6/2018','5/6/2018',299,true),
196-
('Englc: WhatsTech: Large Scale Website Architecture Design: Case Study from Ali.com and Wikipedia.org','5/7/2018','5/7/2018',299,true),
197-
('Englc: WhatsTech: OpenStack Networking Deep Dive','5/8/2018','5/8/2018',299,true),
198-
('Englc: WhatsTech:Large-scale Website Architecture: Key Technologies and Case Study','5/9/2018','5/9/2018',299,true),
199-
('Englc: White-Box Testing Training','5/10/2018','5/10/2018',299,true),
200-
('Englc: Written English Communication Workshop','5/11/2018','5/11/2018',299,true),
201-
('Englc-LSS: 1:1 Virtual English Training: Video with Teachers','5/12/2018','5/12/2018',299,true),
202-
('Englc-LSS: Agile Leadership Workshop','5/13/2018','5/13/2018',299,true),
203-
('Englc-LSS: Excel skills (Advanced)','5/14/2018','5/14/2018',299,true),
204-
('Englc-LSS: PowerPoint skills (Advanced)','5/15/2018','5/15/2018',299,true),
205-
('Englc-LSS:Oral English Boot Camp','5/16/2018','5/16/2018',299,true),
206-
('Englc-Tech: Code Refactoring: Improving the Design of Existing Code','5/17/2018','5/17/2018',299,true),
207-
('Englc-Tech: DevOps Training for WebEx','5/18/2018','5/18/2018',299,true),
208-
('Englc-Tech: Embedded Linux - Kernel APIs Introduction','5/19/2018','5/19/2018',299,true),
209-
('Englc-Tech: Embedded Linux - High-quality C Programming, Testing & Debugging','5/20/2018','5/20/2018',299,true),
210-
('Englc-Tech: Embedded Linux - Multi-process, Multi-thread Application Development and System Performance Profiling','5/21/2018','5/21/2018',299,true),
211-
('Englc-Tech: Network Fundamental','5/22/2018','5/22/2018',299,true),
212-
('Englc-Tech: Performance Testing Tuning','5/23/2018','5/23/2018',299,true),
213-
('Englc-Tech: Unit Testing Best Practices for Software Developer','5/24/2018','5/24/2018',299,true)

‎helloworld-springboot/src/main/UI/.htaccess‎

Lines changed: 9 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,9 @@
1+
<IfModule mod_rewrite.c>
2+
Options +FollowSymlinks
3+
RewriteEngine On
4+
RewriteBase /angularjs-website-folder/
5+
RewriteCond %{REQUEST_FILENAME} !-f
6+
RewriteCond %{REQUEST_FILENAME} !-d
7+
RewriteCond %{REQUEST_URI} !.*\.(css|js|html|png|jpg|jpeg|gif|txt)
8+
RewriteRule (.*) index.html [L]
9+
</IfModule>

‎helloworld-springboot/src/main/UI/bower.json‎

Lines changed: 4 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -31,7 +31,10 @@
3131
"jquery": "^3.3.1",
3232
"angular-ui-grid": "^4.2.2",
3333
"angular-sanitize": "~1.5.0",
34-
"angular-ui-select": "^0.19.8"
34+
"angular-ui-select": "^0.19.8",
35+
"bootstrap-datetimepicker": "^0.0.11",
36+
"eonasdan-bootstrap-datetimepicker": "^4.17.47",
37+
"smalot-bootstrap-datetimepicker": "bootstrap-datetimepicker-master#^2.4.4"
3538
},
3639
"repository": {
3740
"type": "git",

‎helloworld-springboot/src/main/UI/gulpfile.js‎

Lines changed: 8 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -8,7 +8,8 @@ var gulp = require('gulp'),
88
concat = require('gulp-concat'),
99
less = require('gulp-less'),
1010
rename = require('gulp-rename'),
11-
minifyHTML = require('gulp-htmlmin');
11+
minifyHTML = require('gulp-htmlmin'),
12+
history = require('connect-history-api-fallback');
1213

1314
var paths = {
1415
scripts: 'src/js/**/*.*',
@@ -91,7 +92,12 @@ gulp.task('webserver', function() {
9192
connect.server({
9293
root: '../webapp',
9394
livereload: true,
94-
port: 8888
95+
port: 8888,
96+
middleware: function(connect, opt) {
97+
return [ history({
98+
index: '/'
99+
}) ];
100+
}
95101
});
96102
});
97103

‎helloworld-springboot/src/main/UI/package-lock.json‎

Lines changed: 5 additions & 0 deletions
Some generated files are not rendered by default. Learn more about customizing how changed files appear on GitHub.

‎helloworld-springboot/src/main/UI/package.json‎

Lines changed: 3 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -19,5 +19,8 @@
1919
"gulp-usemin": "^0.3.7",
2020
"gulp-watch": "^4.3.5",
2121
"gulp-wrap": "^0.11.0"
22+
},
23+
"dependencies": {
24+
"connect-history-api-fallback": "^1.5.0"
2225
}
2326
}

‎helloworld-springboot/src/main/UI/src/index.html‎

Lines changed: 10 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -5,10 +5,12 @@
55
<meta name="viewport" content="width=device-width, initial-scale=1">
66

77
<title>Learning Assistant</title>
8+
<base href="/">
89
<!-- STYLES -->
910
<!-- build:css lib/css/main.min.css -->
1011
<link rel="stylesheet" type="text/css" href="components/bootstrap/dist/css/bootstrap.min.css">
1112
<link rel="stylesheet" type="text/css" href="components/bootstrap-datepicker/dist/css/bootstrap-datepicker.min.css">
13+
<link rel="stylesheet" type="text/css" href="components/smalot-bootstrap-datetimepicker/css/bootstrap-datetimepicker.min.css">
1214
<link rel="stylesheet" type="text/css" href="components/font-awesome/css/font-awesome.min.css">
1315
<link rel="stylesheet" type="text/css" href="components/rdash-ui/dist/css/rdash.min.css">
1416
<link rel="stylesheet" type="text/css" href="components/angular-ui-grid/ui-grid.min.css">
@@ -19,19 +21,22 @@
1921
<!-- SCRIPTS -->
2022
<!-- build:js lib/js/main.min.js -->
2123
<script type="text/javascript" src="components/jquery/dist/jquery.min.js"></script>
24+
<script type="text/javascript" src="/components/moment/min/moment.min.js"></script>
2225
<script type="text/javascript" src="components/bootstrap/dist/js/bootstrap.min.js"></script>
2326
<script type="text/javascript" src="components/angular/angular.min.js"></script>
2427
<script type="text/javascript" src="components/angular-sanitize/angular-sanitize.min.js"></script>
2528
<script type="text/javascript" src="components/angular-bootstrap/ui-bootstrap.min.js"></script>
2629
<script type="text/javascript" src="components/angular-bootstrap/ui-bootstrap-tpls.min.js"></script>
2730
<script type="text/javascript" src="components/bootstrap-datepicker/dist/js/bootstrap-datepicker.min.js"></script>
31+
<script type="text/javascript" src="components/smalot-bootstrap-datetimepicker/js/bootstrap-datetimepicker.min.js"></script>
2832
<script type="text/javascript" src="components/angular-cookies/angular-cookies.min.js"></script>
2933
<script type="text/javascript" src="components/angular-ui-router/release/angular-ui-router.min.js"></script>
3034
<script type="text/javascript" src="components/ng-table/bundles/ng-table.min.js"></script>
3135
<script type="text/javascript" src="components/angular-ui-select/dist/select.min.js"></script>
3236
<!-- endbuild -->
3337
<!-- Custom Scripts -->
3438
<script type="text/javascript" src="js/dashboard.min.js"></script>
39+
3540
</head>
3641
<body ng-controller="MasterCtrl">
3742
<div id="page-wrapper" ng-class="{'open': toggle}" ng-cloak>
@@ -52,7 +57,7 @@
5257
</li>
5358
5459
<li class="sidebar-list">
55-
<a href="#/tables">Tables <span class="menu-icon fa fa-table"></span></a>
60+
<a href="https://github.com/tables">Tables <span class="menu-icon fa fa-table"></span></a>
5661
</li>
5762
-->
5863
<li class="sidebar-list">
@@ -67,9 +72,12 @@
6772
<li class="sidebar-list">
6873
<a href="#/sample">Golden Sample<span class="menu-icon fa fa-university"></span></a>
6974
</li>
75+
<li class="sidebar-list">
76+
<a href="#/quizList">Quiz<span class="menu-icon fa fa-university"></span></a>
77+
</li>
7078
<!--
7179
<li class="sidebar-list">
72-
<a href="#/history">Course History<span class="menu-icon fa fa-history"></span></a>
80+
<a href="https://github.com/history">Course History<span class="menu-icon fa fa-history"></span></a>
7381
</li>
7482
-->
7583
</ul>

‎helloworld-springboot/src/main/UI/src/js/common/app.environments.js‎

Lines changed: 7 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -40,6 +40,13 @@
4040
deleteRole: '/api/role/{0}',
4141
addRole: '/api/role',
4242
updateRole: '/api/role',
43+
getQuiz: '/api/quiz/{0}',
44+
getQuizList: '/api/quiz/list',
45+
deleteQuiz: '/api/quiz/{0}',
46+
addQuiz: '/api/quiz',
47+
updateQuiz: '/api/quiz',
48+
updateQuizOnly: '/api/quiz/only',
49+
getQuestionList: 'api/question/list/{0}',
4350
getRecord: '/api/record/{0}',
4451
getRecordList: '/api/record/list',
4552
deleteRecord: '/api/record/{0}',

0 commit comments

Comments
 (0)