-
Notifications
You must be signed in to change notification settings - Fork 0
/
codeblog.sql
325 lines (273 loc) · 153 KB
/
codeblog.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
-- phpMyAdmin SQL Dump
-- version 4.7.4
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Apr 07, 2020 at 03:48 PM
-- Server version: 10.1.30-MariaDB
-- PHP Version: 7.2.1
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";
/*!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 utf8mb4 */;
--
-- Database: `codeblog`
--
-- --------------------------------------------------------
--
-- Table structure for table `articles`
--
CREATE TABLE `articles` (
`article_id` int(11) NOT NULL,
`article_category_id` int(11) NOT NULL,
`article_title` varchar(255) NOT NULL,
`article_author` varchar(255) NOT NULL,
`author_id` varchar(255) NOT NULL,
`article_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`article_image` text NOT NULL,
`article_content` longtext NOT NULL,
`article_tags` varchar(255) NOT NULL,
`article_comment_count` int(11) DEFAULT '0',
`article_status` enum('Drafted','Published') NOT NULL DEFAULT 'Drafted',
`article_view_count` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `articles`
--
INSERT INTO `articles` (`article_id`, `article_category_id`, `article_title`, `article_author`, `author_id`, `article_date`, `article_image`, `article_content`, `article_tags`, `article_comment_count`, `article_status`, `article_view_count`) VALUES
(127, 1, 'Basics into Java', 'redhawk96', '5d1b45ebbca98', '2019-07-09 18:30:00', '1561831291.png', '<p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, \" times=\"\" new=\"\" roman\",=\"\" serif;=\"\" font-size:=\"\" 19px;\"=\"\">This article will be all about the system that we are going to develop for the Group Project of the Application Frameworks module for 3rd year 1st semester. Basic Functionality that will be delivered through this system are as follows.</p><ol style=\"margin-right: 0px; margin-bottom: 1.75em; margin-left: 2em; padding: 0px; list-style-position: outside; color: rgb(56, 56, 56); font-family: Georgia, \" times=\"\" new=\"\" roman\",=\"\" serif;=\"\" font-size:=\"\" 19px;\"=\"\"><li style=\"margin-top: 0.4375em;\">There are 3 user roles admin, instructor and students.</li><li style=\"margin-top: 0.4375em;\">Admin can create other admins and instructors. Students need to sign up to the system.</li><li style=\"margin-top: 0.4375em;\">Once admin creates an instructor, it should be notified to the instructor via email.</li><li style=\"margin-top: 0.4375em;\">Admins can create courses and add instructors to course. <span style=\"font-weight: 700;\">Instructors</span> get notifications on new course creations when logged in to the system. <span style=\"font-weight: 700;\">After instructor accept the course, Students can join the course.</span></li><li style=\"margin-top: 0.4375em;\">Instructors can create assignments and exams for a course with due dates. Student should get notifications on these. Instructor can edit these due dates (only to a date than a original one).</li><li style=\"margin-top: 0.4375em;\">Students can upload files for assignments and exams before the due date. Instructor should be able to view these files and enter marks for the assignment or exam. Student will get notified on these markings.</li><li style=\"margin-top: 0.4375em;\">System should be secured and cannot be accessed without proper authentication.</li><li style=\"margin-top: 0.4375em;\">Authorization should be maintained and students cannot create, edit assignments or exams.</li></ol><h2 style=\"clear: both; margin-top: 0.875em; margin-bottom: 0.4375em; font-family: -apple-system, BlinkMacSystemFont, \" segoe=\"\" ui\",=\"\" roboto,=\"\" oxygen-sans,=\"\" ubuntu,=\"\" cantarell,=\"\" \"helvetica=\"\" neue\",=\"\" sans-serif;=\"\" line-height:=\"\" 1.1;=\"\" color:=\"\" rgb(51,=\"\" 51,=\"\" 50);=\"\" font-size:=\"\" 32px;\"=\"\">Technology Stack used…</h2><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, \" times=\"\" new=\"\" roman\",=\"\" serif;=\"\" font-size:=\"\" 19px;\"=\"\">To develop this system, the following technologies/tools were recommended since they were during the module lectures.</p><ul style=\"margin-right: 0px; margin-bottom: 1.75em; margin-left: 2em; padding: 0px; list-style-position: outside; color: rgb(56, 56, 56); font-family: Georgia, \" times=\"\" new=\"\" roman\",=\"\" serif;=\"\" font-size:=\"\" 19px;\"=\"\"><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">HTML/JavaScript: </span>To design and program the front end</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">ReactJS</span>: A JavaScript Front-end library for designing reactive user interfaces.</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">NodeJS:</span> To develop the Back-end</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">ExpressJS:</span> A framework to develop web applications using NodeJS.</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">Spring Boot Framework:</span> Java Web framework to develop Web applications.</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">JSON based Web Services:</span> To communicate between Front-end and Back-end</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">NoSQL Database:</span> MongoDB will be used as the Database.</li></ul><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, \" times=\"\" new=\"\" roman\",=\"\" serif;=\"\" font-size:=\"\" 19px;\"=\"\">The backend service should be an API running JSON based web services. For this project, the backend will be devloped as a <span style=\"font-weight: 700;\">RESTful </span>web service.<span style=\"color: inherit; font-size: 14.25px; font-style: italic; text-align: center;\">Logos of the technologies/tools used</span></p><h2 style=\"clear: both; margin-top: 0.875em; margin-bottom: 0.4375em; font-family: -apple-system, BlinkMacSystemFont, \" segoe=\"\" ui\",=\"\" roboto,=\"\" oxygen-sans,=\"\" ubuntu,=\"\" cantarell,=\"\" \"helvetica=\"\" neue\",=\"\" sans-serif;=\"\" line-height:=\"\" 1.1;=\"\" color:=\"\" rgb(51,=\"\" 51,=\"\" 50);=\"\" font-size:=\"\" 32px;\"=\"\">Workload Distribution…</h2><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, \" times=\"\" new=\"\" roman\",=\"\" serif;=\"\" font-size:=\"\" 19px;\"=\"\">Four main functionalities of this project this were identified as follows.</p><ul style=\"margin-right: 0px; margin-bottom: 1.75em; margin-left: 2em; padding: 0px; list-style-position: outside; color: rgb(56, 56, 56); font-family: Georgia, \" times=\"\" new=\"\" roman\",=\"\" serif;=\"\" font-size:=\"\" 19px;\"=\"\"><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">Admin:</span> Responsible for adding new admins and managing the privileges for each admin along with administrating the whole system.</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">Course Management: </span>Handling course related functionalities starting from basic CRUD operations to allocating students for each course.</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">Student Management:</span> Management of Students by granting permission to enroll on courses, uploading assignments and setting a student profile.</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">Instructor Management:</span> This functionality is responsible for Adding new instructors to the system, Assigning courses for each instructor and creating assignments and exams for students.</li></ul><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, \" times=\"\" new=\"\" roman\",=\"\" serif;=\"\" font-size:=\"\" 19px;\"=\"\">I was responsible for handling the Admin part of the project. Let’s take a look at some of the interfaces that are finished up to now and the front-end source code.</p><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, \" times=\"\" new=\"\" roman\",=\"\" serif;=\"\" font-size:=\"\" 19px;\"=\"\"><span style=\"font-weight: 700;\">Admin Dashboard</span></p><figure class=\"wp-block-image is-resized\" style=\"display: table; margin-bottom: 1em; max-width: 100%; color: rgb(56, 56, 56); font-family: Georgia, \" times=\"\" new=\"\" roman\",=\"\" serif;=\"\" font-size:=\"\" 19px;\"=\"\"><img data-attachment-id=\"355\" data-permalink=\"https://ishansblog.video.blog/admin_dashboard/\" data-orig-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png\" data-orig-size=\"1902,883\" data-comments-opened=\"1\" data-image-meta=\"{\" aperture\":\"0\",\"credit\":\"\",\"camera\":\"\",\"caption\":\"\",\"created_timestamp\":\"0\",\"copyright\":\"\",\"focal_length\":\"0\",\"iso\":\"0\",\"shutter_speed\":\"0\",\"title\":\"\",\"orientation\":\"0\"}\"=\"\" data-image-title=\"admin_dashboard\" data-image-description=\"\" data-medium-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=300\" data-large-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=1024\" src=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=848&h=393\" alt=\"\" class=\"wp-image-355\" width=\"848\" height=\"393\" srcset=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=848&h=393 848w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=1693&h=786 1693w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=150&h=70 150w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=300&h=139 300w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=768&h=357 768w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=1024&h=475 1024w\" sizes=\"(max-width: 848px) 100vw, 848px\" style=\"max-width: 100%; height: auto; border: 0px; border-radius: 3px;\"><figcaption style=\"display: table-caption; margin-top: 0.5em; margin-bottom: 1em; color: inherit; text-align: center; font-size: 14.25px; font-style: italic; caption-side: bottom;\">admin dashboard</figcaption></figure><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, \" times=\"\" new=\"\" roman\",=\"\" serif;=\"\" font-size:=\"\" 19px;\"=\"\"><span style=\"font-weight: 700;\">Student Management</span></p><figure class=\"wp-block-image is-resized\" style=\"display: table; margin-bottom: 1em; max-width: 100%; color: rgb(56, 56, 56); font-family: Georgia, \" times=\"\" new=\"\" roman\",=\"\" serif;=\"\" font-size:=\"\" 19px;\"=\"\"><img data-attachment-id=\"356\" data-permalink=\"https://ishansblog.video.blog/admin_student/\" data-orig-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_student.png\" data-orig-size=\"1895,887\" data-comments-opened=\"1\" data-image-meta=\"{\" aperture\":\"0\",\"credit\":\"\",\"camera\":\"\",\"caption\":\"\",\"created_timestamp\":\"0\",\"copyright\":\"\",\"focal_length\":\"0\",\"iso\":\"0\",\"shutter_speed\":\"0\",\"title\":\"\",\"orientation\":\"0\"}\"=\"\" data-image-title=\"admin_student\" data-image-description=\"\" data-medium-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_student.png?w=300\" data-large-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_student.png?w=1024\" src=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_student.png?w=847&h=396\" alt=\"\" class=\"wp-image-356\" width=\"847\" height=\"396\" srcset=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_student.png?w=847&h=396 847w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_student.png?w=1692&h=792 1692w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_student.png?w=150&h=70 150w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_student.png?w=300&h=140 300w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_student.png?w=768&h=359 768w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_student.png?w=1024&h=479 1024w\" sizes=\"(max-width: 847px) 100vw, 847px\" style=\"max-width: 100%; height: auto; border: 0px; border-radius: 3px;\"><figcaption style=\"display: table-caption; margin-top: 0.5em; margin-bottom: 1em; color: inherit; text-align: center; font-size: 14.25px; font-style: italic; caption-side: bottom;\">Student Management of Admin</figcaption></figure><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, \" times=\"\" new=\"\" roman\",=\"\" serif;=\"\" font-size:=\"\" 19px;\"=\"\"><span style=\"font-weight: 700;\">Student Management Settings</span></p><figure class=\"wp-block-image is-resized\" style=\"display: table; margin-bottom: 1em; max-width: 100%; color: rgb(56, 56, 56); font-family: Georgia, \" times=\"\" new=\"\" roman\",=\"\" serif;=\"\" font-size:=\"\" 19px;\"=\"\"><img data-attachment-id=\"357\" data-permalink=\"https://ishansblog.video.blog/admin_student_settings/\" data-orig-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_student_settings.png\" data-orig-size=\"1902,932\" data-comments-opened=\"1\" data-image-meta=\"{\" aperture\":\"0\",\"credit\":\"\",\"camera\":\"\",\"caption\":\"\",\"created_timestamp\":\"0\",\"copyright\":\"\",\"focal_length\":\"0\",\"iso\":\"0\",\"shutter_speed\":\"0\",\"title\":\"\",\"orientation\":\"0\"}\"=\"\" data-image-title=\"admin_student_settings\" data-image-description=\"\" data-medium-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_student_settings.png?w=300\" data-large-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_student_settings.png?w=1024\" src=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_student_settings.png?w=879&h=430\" alt=\"\" class=\"wp-image-357\" width=\"879\" height=\"430\" srcset=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_student_settings.png?w=879&h=430 879w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_student_settings.png?w=1755&h=860 1755w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_student_settings.png?w=150&h=74 150w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_student_settings.png?w=300&h=147 300w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_student_settings.png?w=768&h=376 768w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_student_settings.png?w=1024&h=502 1024w\" sizes=\"(max-width: 879px) 100vw, 879px\" style=\"max-width: 100%; height: auto; border: 0px; border-radius: 3px;\"><figcaption style=\"display: table-caption; margin-top: 0.5em; margin-bottom: 1em; color: inherit; text-align: center; font-size: 14.25px; font-style: italic; caption-side: bottom;\">Student Management settings of Admin</figcaption></figure><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, \" times=\"\" new=\"\" roman\",=\"\" serif;=\"\" font-size:=\"\" 19px;\"=\"\"><span style=\"font-weight: 700;\">Instructor Management</span></p><figure class=\"wp-block-image is-resized\" style=\"display: table; margin-bottom: 1em; max-width: 100%; color: rgb(56, 56, 56); font-family: Georgia, \" times=\"\" new=\"\" roman\",=\"\" serif;=\"\" font-size:=\"\" 19px;\"=\"\"><img data-attachment-id=\"358\" data-permalink=\"https://ishansblog.video.blog/admin_instructors/\" data-orig-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors.png\" data-orig-size=\"1904,885\" data-comments-opened=\"1\" data-image-meta=\"{\" aperture\":\"0\",\"credit\":\"\",\"camera\":\"\",\"caption\":\"\",\"created_timestamp\":\"0\",\"copyright\":\"\",\"focal_length\":\"0\",\"iso\":\"0\",\"shutter_speed\":\"0\",\"title\":\"\",\"orientation\":\"0\"}\"=\"\" data-image-title=\"admin_instructors\" data-image-description=\"\" data-medium-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors.png?w=300\" data-large-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors.png?w=1024\" src=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors.png?w=837&h=388\" alt=\"\" class=\"wp-image-358\" width=\"837\" height=\"388\" srcset=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors.png?w=835&h=388 835w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors.png?w=1669&h=776 1669w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors.png?w=150&h=70 150w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors.png?w=300&h=139 300w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors.png?w=768&h=357 768w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors.png?w=1024&h=476 1024w\" sizes=\"(max-width: 837px) 100vw, 837px\" style=\"max-width: 100%; height: auto; border: 0px; border-radius: 3px;\"><figcaption style=\"display: table-caption; margin-top: 0.5em; margin-bottom: 1em; color: inherit; text-align: center; font-size: 14.25px; font-style: italic; caption-side: bottom;\">Instructor Management of Admin</figcaption></figure><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, \" times=\"\" new=\"\" roman\",=\"\" serif;=\"\" font-size:=\"\" 19px;\"=\"\"><span style=\"font-weight: 700;\">Instructor Management Settings</span></p><figure class=\"wp-block-image is-resized\" style=\"display: table; margin-bottom: 1em; max-width: 100%; color: rgb(56, 56, 56); font-family: Georgia, \" times=\"\" new=\"\" roman\",=\"\" serif;=\"\" font-size:=\"\" 19px;\"=\"\"><img data-attachment-id=\"359\" data-permalink=\"https://ishansblog.video.blog/admin_instructors_settings/\" data-orig-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors_settings.png\" data-orig-size=\"1903,882\" data-comments-opened=\"1\" data-image-meta=\"{\" aperture\":\"0\",\"credit\":\"\",\"camera\":\"\",\"caption\":\"\",\"created_timestamp\":\"0\",\"copyright\":\"\",\"focal_length\":\"0\",\"iso\":\"0\",\"shutter_speed\":\"0\",\"title\":\"\",\"orientation\":\"0\"}\"=\"\" data-image-title=\"admin_instructors_settings\" data-image-description=\"\" data-medium-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors_settings.png?w=300\" data-large-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors_settings.png?w=1024\" src=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors_settings.png?w=859&h=397\" alt=\"\" class=\"wp-image-359\" width=\"859\" height=\"397\" srcset=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors_settings.png?w=857&h=397 857w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors_settings.png?w=1713&h=794 1713w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors_settings.png?w=150&h=70 150w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors_settings.png?w=300&h=139 300w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors_settings.png?w=768&h=356 768w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors_settings.png?w=1024&h=475 1024w\" sizes=\"(max-width: 859px) 100vw, 859px\" style=\"max-width: 100%; height: auto; border: 0px; border-radius: 3px;\"><figcaption style=\"display: table-caption; margin-top: 0.5em; margin-bottom: 1em; color: inherit; text-align: center; font-size: 14.25px; font-style: italic; caption-side: bottom;\">Instructor Management settings of Admin</figcaption></figure><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, \" times=\"\" new=\"\" roman\",=\"\" serif;=\"\" font-size:=\"\" 19px;\"=\"\">Now let’s take a look at the front-end source of those interfaces.</p><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, \" times=\"\" new=\"\" roman\",=\"\" serif;=\"\" font-size:=\"\" 19px;\"=\"\"><br></p><div style=\"color: rgb(56, 56, 56); font-family: Georgia, \" times=\"\" new=\"\" roman\",=\"\" serif;=\"\" font-size:=\"\" 19px;\"=\"\"></div>', 'JavaScript', 1, 'Published', 11),
(129, 1, 'Basics into Java', 'redhawk96', '5d1b45ebbca98', '2019-07-09 18:30:00', '1561831291.png', '<br><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\">This article will be all about the system that we are going to develop for the Group Project of the Application Frameworks module for 3rd year 1st semester. Basic Functionality that will be delivered through this system are as follows.</p><ol style=\"margin-right: 0px; margin-bottom: 1.75em; margin-left: 2em; padding: 0px; list-style-position: outside; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\"><li style=\"margin-top: 0.4375em;\">There are 3 user roles admin, instructor and students.</li><li style=\"margin-top: 0.4375em;\">Admin can create other admins and instructors. Students need to sign up to the system.</li><li style=\"margin-top: 0.4375em;\">Once admin creates an instructor, it should be notified to the instructor via email.</li><li style=\"margin-top: 0.4375em;\">Admins can create courses and add instructors to course. <span style=\"font-weight: 700;\">Instructors</span> get notifications on new course creations when logged in to the system. <span style=\"font-weight: 700;\">After instructor accept the course, Students can join the course.</span></li><li style=\"margin-top: 0.4375em;\">Instructors can create assignments and exams for a course with due dates. Student should get notifications on these. Instructor can edit these due dates (only to a date than a original one).</li><li style=\"margin-top: 0.4375em;\">Students can upload files for assignments and exams before the due date. Instructor should be able to view these files and enter marks for the assignment or exam. Student will get notified on these markings.</li><li style=\"margin-top: 0.4375em;\">System should be secured and cannot be accessed without proper authentication.</li><li style=\"margin-top: 0.4375em;\">Authorization should be maintained and students cannot create, edit assignments or exams.</li></ol><h2 style=\"clear: both; margin-top: 0.875em; margin-bottom: 0.4375em; font-family: -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen-Sans, Ubuntu, Cantarell, "Helvetica Neue", sans-serif; line-height: 1.1; color: rgb(51, 51, 50); font-size: 32px;\">Technology Stack used…</h2><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\">To develop this system, the following technologies/tools were recommended since they were during the module lectures.</p><ul style=\"margin-right: 0px; margin-bottom: 1.75em; margin-left: 2em; padding: 0px; list-style-position: outside; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\"><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">HTML/JavaScript: </span>To design and program the front end</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">ReactJS</span>: A JavaScript Front-end library for designing reactive user interfaces.</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">NodeJS:</span> To develop the Back-end</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">ExpressJS:</span> A framework to develop web applications using NodeJS.</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">Spring Boot Framework:</span> Java Web framework to develop Web applications.</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">JSON based Web Services:</span> To communicate between Front-end and Back-end</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">NoSQL Database:</span> MongoDB will be used as the Database.</li></ul><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\">The backend service should be an API running JSON based web services. For this project, the backend will be devloped as a <span style=\"font-weight: 700;\">RESTful </span>web service.</p><figure class=\"wp-block-image\" style=\"margin-bottom: 1em; max-width: 100%; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\"><img data-attachment-id=\"350\" data-permalink=\"https://ishansblog.video.blog/tech_logos/\" data-orig-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/tech_logos.png\" data-orig-size=\"1227,152\" data-comments-opened=\"1\" data-image-meta=\"{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}\" data-image-title=\"tech_logos\" data-image-description=\"\" data-medium-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/tech_logos.png?w=300\" data-large-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/tech_logos.png?w=1024\" src=\"https://ishansblogvideo.files.wordpress.com/2019/05/tech_logos.png?w=1100\" alt=\"\" class=\"wp-image-350\" srcset=\"https://ishansblogvideo.files.wordpress.com/2019/05/tech_logos.png?w=1100 1100w, https://ishansblogvideo.files.wordpress.com/2019/05/tech_logos.png?w=150 150w, https://ishansblogvideo.files.wordpress.com/2019/05/tech_logos.png?w=300 300w, https://ishansblogvideo.files.wordpress.com/2019/05/tech_logos.png?w=768 768w, https://ishansblogvideo.files.wordpress.com/2019/05/tech_logos.png?w=1024 1024w, https://ishansblogvideo.files.wordpress.com/2019/05/tech_logos.png 1227w\" sizes=\"(max-width: 1100px) 100vw, 1100px\" style=\"max-width: 100%; height: auto; border: 0px; border-radius: 3px;\"><figcaption style=\"margin-top: 0.5em; margin-bottom: 1em; color: inherit; text-align: center; font-size: 14.25px; font-style: italic;\">Logos of the technologies/tools used</figcaption></figure><h2 style=\"clear: both; margin-top: 0.875em; margin-bottom: 0.4375em; font-family: -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen-Sans, Ubuntu, Cantarell, "Helvetica Neue", sans-serif; line-height: 1.1; color: rgb(51, 51, 50); font-size: 32px;\">Workload Distribution…</h2><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\">Four main functionalities of this project this were identified as follows.</p><ul style=\"margin-right: 0px; margin-bottom: 1.75em; margin-left: 2em; padding: 0px; list-style-position: outside; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\"><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">Admin:</span> Responsible for adding new admins and managing the privileges for each admin along with administrating the whole system.</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">Course Management: </span>Handling course related functionalities starting from basic CRUD operations to allocating students for each course.</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">Student Management:</span> Management of Students by granting permission to enroll on courses, uploading assignments and setting a student profile.</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">Instructor Management:</span> This functionality is responsible for Adding new instructors to the system, Assigning courses for each instructor and creating assignments and exams for students.</li></ul><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\">I was responsible for handling the Admin part of the project. Let’s take a look at some of the interfaces that are finished up to now and the front-end source code.</p><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\"><span style=\"font-weight: 700;\">Admin Dashboard</span></p><figure class=\"wp-block-image is-resized\" style=\"display: table; margin-bottom: 1em; max-width: 100%; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\"><img data-attachment-id=\"355\" data-permalink=\"https://ishansblog.video.blog/admin_dashboard/\" data-orig-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png\" data-orig-size=\"1902,883\" data-comments-opened=\"1\" data-image-meta=\"{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}\" data-image-title=\"admin_dashboard\" data-image-description=\"\" data-medium-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=300\" data-large-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=1024\" src=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=848&h=393\" alt=\"\" class=\"wp-image-355\" width=\"848\" height=\"393\" srcset=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=848&h=393 848w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=1693&h=786 1693w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=150&h=70 150w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=300&h=139 300w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=768&h=357 768w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=1024&h=475 1024w\" sizes=\"(max-width: 848px) 100vw, 848px\" style=\"max-width: 100%; height: auto; border: 0px; border-radius: 3px;\"><figcaption style=\"display: table-caption; margin-top: 0.5em; margin-bottom: 1em; color: inherit; text-align: center; font-size: 14.25px; font-style: italic; caption-side: bottom;\">admin dashboard</figcaption></figure><table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-spacing: 0px; border-collapse: separate; width: 1951px; margin: 0px !important; font-size: 1em !important; border: 0px !important; table-layout: auto !important; border-radius: 0px !important; background: none !important; bottom: auto !important; float: none !important; height: auto !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; box-sizing: content-box !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; direction: ltr !important; box-shadow: none !important;\"><tbody style=\"border-radius: 0px !important; background: none !important; border: 0px !important; bottom: auto !important; float: none !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; font-size: 1em !important; direction: ltr !important; box-shadow: none !important;\"><tr style=\"border-radius: 0px !important; background: none !important; border: 0px !important; bottom: auto !important; float: none !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; font-size: 1em !important; direction: ltr !important; box-shadow: none !important;\"><td class=\"gutter\" style=\"background: none !important; font-size: 1em !important; padding: 0px !important; border: 0px !important; border-radius: 0px !important; bottom: auto !important; float: none !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; direction: ltr !important; box-shadow: none !important; color: rgb(175, 175, 175) !important;\"></td></tr></tbody></table><div style=\"color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\"></div>', 'JavaScript', 0, 'Published', 0);
INSERT INTO `articles` (`article_id`, `article_category_id`, `article_title`, `article_author`, `author_id`, `article_date`, `article_image`, `article_content`, `article_tags`, `article_comment_count`, `article_status`, `article_view_count`) VALUES
(130, 1, 'Basics into Java', 'redhawk96', '5d1b45ebbca98', '2019-07-09 18:30:00', '1561831291.png', '<p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, \"Times New Roman\", serif; font-size: 19px;\">This article will be all about the system that we are going to develop for the Group Project of the Application Frameworks module for 3rd year 1st semester. Basic Functionality that will be delivered through this system are as follows.</p><ol style=\"margin-right: 0px; margin-bottom: 1.75em; margin-left: 2em; padding: 0px; list-style-position: outside; color: rgb(56, 56, 56); font-family: Georgia, \"Times New Roman\", serif; font-size: 19px;\"><li style=\"margin-top: 0.4375em;\">There are 3 user roles admin, instructor and students.</li><li style=\"margin-top: 0.4375em;\">Admin can create other admins and instructors. Students need to sign up to the system.</li><li style=\"margin-top: 0.4375em;\">Once admin creates an instructor, it should be notified to the instructor via email.</li><li style=\"margin-top: 0.4375em;\">Admins can create courses and add instructors to course. <span style=\"font-weight: 700;\">Instructors</span> get notifications on new course creations when logged in to the system. <span style=\"font-weight: 700;\">After instructor accept the course, Students can join the course.</span></li><li style=\"margin-top: 0.4375em;\">Instructors can create assignments and exams for a course with due dates. Student should get notifications on these. Instructor can edit these due dates (only to a date than a original one).</li><li style=\"margin-top: 0.4375em;\">Students can upload files for assignments and exams before the due date. Instructor should be able to view these files and enter marks for the assignment or exam. Student will get notified on these markings.</li><li style=\"margin-top: 0.4375em;\">System should be secured and cannot be accessed without proper authentication.</li><li style=\"margin-top: 0.4375em;\">Authorization should be maintained and students cannot create, edit assignments or exams.</li></ol><h2 style=\"clear: both; margin-top: 0.875em; margin-bottom: 0.4375em; font-family: -apple-system, BlinkMacSystemFont, \"Segoe UI\", Roboto, Oxygen-Sans, Ubuntu, Cantarell, \"Helvetica Neue\", sans-serif; line-height: 1.1; color: rgb(51, 51, 50); font-size: 32px;\">Technology Stack used…</h2><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, \"Times New Roman\", serif; font-size: 19px;\">To develop this system, the following technologies/tools were recommended since they were during the module lectures.</p><ul style=\"margin-right: 0px; margin-bottom: 1.75em; margin-left: 2em; padding: 0px; list-style-position: outside; color: rgb(56, 56, 56); font-family: Georgia, \"Times New Roman\", serif; font-size: 19px;\"><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">HTML/JavaScript: </span>To design and program the front end</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">ReactJS</span>: A JavaScript Front-end library for designing reactive user interfaces.</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">NodeJS:</span> To develop the Back-end</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">ExpressJS:</span> A framework to develop web applications using NodeJS.</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">Spring Boot Framework:</span> Java Web framework to develop Web applications.</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">JSON based Web Services:</span> To communicate between Front-end and Back-end</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">NoSQL Database:</span> MongoDB will be used as the Database.</li></ul><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, \"Times New Roman\", serif; font-size: 19px;\">The backend service should be an API running JSON based web services. For this project, the backend will be devloped as a <span style=\"font-weight: 700;\">RESTful </span>web service.</p><figure class=\"wp-block-image\" style=\"margin-bottom: 1em; max-width: 100%; color: rgb(56, 56, 56); font-family: Georgia, \"Times New Roman\", serif; font-size: 19px;\"><img data-attachment-id=\"350\" data-permalink=\"https://ishansblog.video.blog/tech_logos/\" data-orig-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/tech_logos.png\" data-orig-size=\"1227,152\" data-comments-opened=\"1\" data-image-meta=\"{\"aperture\":\"0\",\"credit\":\"\",\"camera\":\"\",\"caption\":\"\",\"created_timestamp\":\"0\",\"copyright\":\"\",\"focal_length\":\"0\",\"iso\":\"0\",\"shutter_speed\":\"0\",\"title\":\"\",\"orientation\":\"0\"}\" data-image-title=\"tech_logos\" data-image-description=\"\" data-medium-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/tech_logos.png?w=300\" data-large-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/tech_logos.png?w=1024\" src=\"https://ishansblogvideo.files.wordpress.com/2019/05/tech_logos.png?w=1100\" alt=\"\" class=\"wp-image-350\" srcset=\"https://ishansblogvideo.files.wordpress.com/2019/05/tech_logos.png?w=1100 1100w, https://ishansblogvideo.files.wordpress.com/2019/05/tech_logos.png?w=150 150w, https://ishansblogvideo.files.wordpress.com/2019/05/tech_logos.png?w=300 300w, https://ishansblogvideo.files.wordpress.com/2019/05/tech_logos.png?w=768 768w, https://ishansblogvideo.files.wordpress.com/2019/05/tech_logos.png?w=1024 1024w, https://ishansblogvideo.files.wordpress.com/2019/05/tech_logos.png 1227w\" sizes=\"(max-width: 1100px) 100vw, 1100px\" style=\"max-width: 100%; height: auto; border: 0px; border-radius: 3px;\"><figcaption style=\"margin-top: 0.5em; margin-bottom: 1em; color: inherit; text-align: center; font-size: 14.25px; font-style: italic;\">Logos of the technologies/tools used</figcaption></figure><h2 style=\"clear: both; margin-top: 0.875em; margin-bottom: 0.4375em; font-family: -apple-system, BlinkMacSystemFont, \"Segoe UI\", Roboto, Oxygen-Sans, Ubuntu, Cantarell, \"Helvetica Neue\", sans-serif; line-height: 1.1; color: rgb(51, 51, 50); font-size: 32px;\">Workload Distribution…</h2><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, \"Times New Roman\", serif; font-size: 19px;\">Four main functionalities of this project this were identified as follows.</p><ul style=\"margin-right: 0px; margin-bottom: 1.75em; margin-left: 2em; padding: 0px; list-style-position: outside; color: rgb(56, 56, 56); font-family: Georgia, \"Times New Roman\", serif; font-size: 19px;\"><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">Admin:</span> Responsible for adding new admins and managing the privileges for each admin along with administrating the whole system.</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">Course Management: </span>Handling course related functionalities starting from basic CRUD operations to allocating students for each course.</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">Student Management:</span> Management of Students by granting permission to enroll on courses, uploading assignments and setting a student profile.</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">Instructor Management:</span> This functionality is responsible for Adding new instructors to the system, Assigning courses for each instructor and creating assignments and exams for students.</li></ul><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, \"Times New Roman\", serif; font-size: 19px;\">I was responsible for handling the Admin part of the project. Let’s take a look at some of the interfaces that are finished up to now and the front-end source code.</p><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, \"Times New Roman\", serif; font-size: 19px;\"><span style=\"font-weight: 700;\">Admin Dashboard</span></p><figure class=\"wp-block-image is-resized\" style=\"display: table; margin-bottom: 1em; max-width: 100%; color: rgb(56, 56, 56); font-family: Georgia, \"Times New Roman\", serif; font-size: 19px;\"><img data-attachment-id=\"355\" data-permalink=\"https://ishansblog.video.blog/admin_dashboard/\" data-orig-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png\" data-orig-size=\"1902,883\" data-comments-opened=\"1\" data-image-meta=\"{\"aperture\":\"0\",\"credit\":\"\",\"camera\":\"\",\"caption\":\"\",\"created_timestamp\":\"0\",\"copyright\":\"\",\"focal_length\":\"0\",\"iso\":\"0\",\"shutter_speed\":\"0\",\"title\":\"\",\"orientation\":\"0\"}\" data-image-title=\"admin_dashboard\" data-image-description=\"\" data-medium-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=300\" data-large-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=1024\" src=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=848&h=393\" alt=\"\" class=\"wp-image-355\" width=\"848\" height=\"393\" srcset=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=848&h=393 848w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=1693&h=786 1693w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=150&h=70 150w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=300&h=139 300w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=768&h=357 768w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=1024&h=475 1024w\" sizes=\"(max-width: 848px) 100vw, 848px\" style=\"max-width: 100%; height: auto; border: 0px; border-radius: 3px;\"><figcaption style=\"display: table-caption; margin-top: 0.5em; margin-bottom: 1em; color: inherit; text-align: center; font-size: 14.25px; font-style: italic; caption-side: bottom;\">admin dashboard</figcaption></figure><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, \"Times New Roman\", serif; font-size: 19px;\"><span style=\"font-weight: 700;\">Student Management</span></p><figure class=\"wp-block-image is-resized\" style=\"display: table; margin-bottom: 1em; max-width: 100%; color: rgb(56, 56, 56); font-family: Georgia, \"Times New Roman\", serif; font-size: 19px;\"><img data-attachment-id=\"356\" data-permalink=\"https://ishansblog.video.blog/admin_student/\" data-orig-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_student.png\" data-orig-size=\"1895,887\" data-comments-opened=\"1\" data-image-meta=\"{\"aperture\":\"0\",\"credit\":\"\",\"camera\":\"\",\"caption\":\"\",\"created_timestamp\":\"0\",\"copyright\":\"\",\"focal_length\":\"0\",\"iso\":\"0\",\"shutter_speed\":\"0\",\"title\":\"\",\"orientation\":\"0\"}\" data-image-title=\"admin_student\" data-image-description=\"\" data-medium-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_student.png?w=300\" data-large-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_student.png?w=1024\" src=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_student.png?w=847&h=396\" alt=\"\" class=\"wp-image-356\" width=\"847\" height=\"396\" srcset=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_student.png?w=847&h=396 847w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_student.png?w=1692&h=792 1692w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_student.png?w=150&h=70 150w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_student.png?w=300&h=140 300w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_student.png?w=768&h=359 768w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_student.png?w=1024&h=479 1024w\" sizes=\"(max-width: 847px) 100vw, 847px\" style=\"max-width: 100%; height: auto; border: 0px; border-radius: 3px;\"><figcaption style=\"display: table-caption; margin-top: 0.5em; margin-bottom: 1em; color: inherit; text-align: center; font-size: 14.25px; font-style: italic; caption-side: bottom;\">Student Management of Admin</figcaption></figure><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, \"Times New Roman\", serif; font-size: 19px;\"><span style=\"font-weight: 700;\">Student Management Settings</span></p><figure class=\"wp-block-image is-resized\" style=\"display: table; margin-bottom: 1em; max-width: 100%; color: rgb(56, 56, 56); font-family: Georgia, \"Times New Roman\", serif; font-size: 19px;\"><img data-attachment-id=\"357\" data-permalink=\"https://ishansblog.video.blog/admin_student_settings/\" data-orig-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_student_settings.png\" data-orig-size=\"1902,932\" data-comments-opened=\"1\" data-image-meta=\"{\"aperture\":\"0\",\"credit\":\"\",\"camera\":\"\",\"caption\":\"\",\"created_timestamp\":\"0\",\"copyright\":\"\",\"focal_length\":\"0\",\"iso\":\"0\",\"shutter_speed\":\"0\",\"title\":\"\",\"orientation\":\"0\"}\" data-image-title=\"admin_student_settings\" data-image-description=\"\" data-medium-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_student_settings.png?w=300\" data-large-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_student_settings.png?w=1024\" src=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_student_settings.png?w=879&h=430\" alt=\"\" class=\"wp-image-357\" width=\"879\" height=\"430\" srcset=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_student_settings.png?w=879&h=430 879w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_student_settings.png?w=1755&h=860 1755w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_student_settings.png?w=150&h=74 150w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_student_settings.png?w=300&h=147 300w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_student_settings.png?w=768&h=376 768w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_student_settings.png?w=1024&h=502 1024w\" sizes=\"(max-width: 879px) 100vw, 879px\" style=\"max-width: 100%; height: auto; border: 0px; border-radius: 3px;\"><figcaption style=\"display: table-caption; margin-top: 0.5em; margin-bottom: 1em; color: inherit; text-align: center; font-size: 14.25px; font-style: italic; caption-side: bottom;\">Student Management settings of Admin</figcaption></figure><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, \"Times New Roman\", serif; font-size: 19px;\"><span style=\"font-weight: 700;\">Instructor Management</span></p><figure class=\"wp-block-image is-resized\" style=\"display: table; margin-bottom: 1em; max-width: 100%; color: rgb(56, 56, 56); font-family: Georgia, \"Times New Roman\", serif; font-size: 19px;\"><img data-attachment-id=\"358\" data-permalink=\"https://ishansblog.video.blog/admin_instructors/\" data-orig-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors.png\" data-orig-size=\"1904,885\" data-comments-opened=\"1\" data-image-meta=\"{\"aperture\":\"0\",\"credit\":\"\",\"camera\":\"\",\"caption\":\"\",\"created_timestamp\":\"0\",\"copyright\":\"\",\"focal_length\":\"0\",\"iso\":\"0\",\"shutter_speed\":\"0\",\"title\":\"\",\"orientation\":\"0\"}\" data-image-title=\"admin_instructors\" data-image-description=\"\" data-medium-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors.png?w=300\" data-large-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors.png?w=1024\" src=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors.png?w=837&h=388\" alt=\"\" class=\"wp-image-358\" width=\"837\" height=\"388\" srcset=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors.png?w=835&h=388 835w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors.png?w=1669&h=776 1669w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors.png?w=150&h=70 150w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors.png?w=300&h=139 300w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors.png?w=768&h=357 768w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors.png?w=1024&h=476 1024w\" sizes=\"(max-width: 837px) 100vw, 837px\" style=\"max-width: 100%; height: auto; border: 0px; border-radius: 3px;\"><figcaption style=\"display: table-caption; margin-top: 0.5em; margin-bottom: 1em; color: inherit; text-align: center; font-size: 14.25px; font-style: italic; caption-side: bottom;\">Instructor Management of Admin</figcaption></figure><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, \"Times New Roman\", serif; font-size: 19px;\"><span style=\"font-weight: 700;\">Instructor Management Settings</span></p><figure class=\"wp-block-image is-resized\" style=\"display: table; margin-bottom: 1em; max-width: 100%; color: rgb(56, 56, 56); font-family: Georgia, \"Times New Roman\", serif; font-size: 19px;\"><img data-attachment-id=\"359\" data-permalink=\"https://ishansblog.video.blog/admin_instructors_settings/\" data-orig-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors_settings.png\" data-orig-size=\"1903,882\" data-comments-opened=\"1\" data-image-meta=\"{\"aperture\":\"0\",\"credit\":\"\",\"camera\":\"\",\"caption\":\"\",\"created_timestamp\":\"0\",\"copyright\":\"\",\"focal_length\":\"0\",\"iso\":\"0\",\"shutter_speed\":\"0\",\"title\":\"\",\"orientation\":\"0\"}\" data-image-title=\"admin_instructors_settings\" data-image-description=\"\" data-medium-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors_settings.png?w=300\" data-large-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors_settings.png?w=1024\" src=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors_settings.png?w=859&h=397\" alt=\"\" class=\"wp-image-359\" width=\"859\" height=\"397\" srcset=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors_settings.png?w=857&h=397 857w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors_settings.png?w=1713&h=794 1713w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors_settings.png?w=150&h=70 150w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors_settings.png?w=300&h=139 300w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors_settings.png?w=768&h=356 768w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors_settings.png?w=1024&h=475 1024w\" sizes=\"(max-width: 859px) 100vw, 859px\" style=\"max-width: 100%; height: auto; border: 0px; border-radius: 3px;\"><figcaption style=\"display: table-caption; margin-top: 0.5em; margin-bottom: 1em; color: inherit; text-align: center; font-size: 14.25px; font-style: italic; caption-side: bottom;\">Instructor Management settings of Admin</figcaption></figure><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, \"Times New Roman\", serif; font-size: 19px;\">Now let’s take a look at the front-end source of those interfaces.</p><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, \"Times New Roman\", serif; font-size: 19px;\"><br></p><div style=\"color: rgb(56, 56, 56); font-family: Georgia, \"Times New Roman\", serif; font-size: 19px;\"></div>', 'JavaScript', 0, 'Published', 7),
(131, 1, 'Basics into Java', 'redhawk96', '5d1b45ebbca98', '2019-07-09 18:30:00', '1561831291.png', '<br><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\">This article will be all about the system that we are going to develop for the Group Project of the Application Frameworks module for 3rd year 1st semester. Basic Functionality that will be delivered through this system are as follows.</p><ol style=\"margin-right: 0px; margin-bottom: 1.75em; margin-left: 2em; padding: 0px; list-style-position: outside; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\"><li style=\"margin-top: 0.4375em;\">There are 3 user roles admin, instructor and students.</li><li style=\"margin-top: 0.4375em;\">Admin can create other admins and instructors. Students need to sign up to the system.</li><li style=\"margin-top: 0.4375em;\">Once admin creates an instructor, it should be notified to the instructor via email.</li><li style=\"margin-top: 0.4375em;\">Admins can create courses and add instructors to course. <span style=\"font-weight: 700;\">Instructors</span> get notifications on new course creations when logged in to the system. <span style=\"font-weight: 700;\">After instructor accept the course, Students can join the course.</span></li><li style=\"margin-top: 0.4375em;\">Instructors can create assignments and exams for a course with due dates. Student should get notifications on these. Instructor can edit these due dates (only to a date than a original one).</li><li style=\"margin-top: 0.4375em;\">Students can upload files for assignments and exams before the due date. Instructor should be able to view these files and enter marks for the assignment or exam. Student will get notified on these markings.</li><li style=\"margin-top: 0.4375em;\">System should be secured and cannot be accessed without proper authentication.</li><li style=\"margin-top: 0.4375em;\">Authorization should be maintained and students cannot create, edit assignments or exams.</li></ol><h2 style=\"clear: both; margin-top: 0.875em; margin-bottom: 0.4375em; font-family: -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen-Sans, Ubuntu, Cantarell, "Helvetica Neue", sans-serif; line-height: 1.1; color: rgb(51, 51, 50); font-size: 32px;\">Technology Stack used…</h2><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\">To develop this system, the following technologies/tools were recommended since they were during the module lectures.</p><ul style=\"margin-right: 0px; margin-bottom: 1.75em; margin-left: 2em; padding: 0px; list-style-position: outside; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\"><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">HTML/JavaScript: </span>To design and program the front end</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">ReactJS</span>: A JavaScript Front-end library for designing reactive user interfaces.</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">NodeJS:</span> To develop the Back-end</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">ExpressJS:</span> A framework to develop web applications using NodeJS.</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">Spring Boot Framework:</span> Java Web framework to develop Web applications.</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">JSON based Web Services:</span> To communicate between Front-end and Back-end</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">NoSQL Database:</span> MongoDB will be used as the Database.</li></ul><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\">The backend service should be an API running JSON based web services. For this project, the backend will be devloped as a <span style=\"font-weight: 700;\">RESTful </span>web service.</p><figure class=\"wp-block-image\" style=\"margin-bottom: 1em; max-width: 100%; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\"><img data-attachment-id=\"350\" data-permalink=\"https://ishansblog.video.blog/tech_logos/\" data-orig-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/tech_logos.png\" data-orig-size=\"1227,152\" data-comments-opened=\"1\" data-image-meta=\"{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}\" data-image-title=\"tech_logos\" data-image-description=\"\" data-medium-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/tech_logos.png?w=300\" data-large-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/tech_logos.png?w=1024\" src=\"https://ishansblogvideo.files.wordpress.com/2019/05/tech_logos.png?w=1100\" alt=\"\" class=\"wp-image-350\" srcset=\"https://ishansblogvideo.files.wordpress.com/2019/05/tech_logos.png?w=1100 1100w, https://ishansblogvideo.files.wordpress.com/2019/05/tech_logos.png?w=150 150w, https://ishansblogvideo.files.wordpress.com/2019/05/tech_logos.png?w=300 300w, https://ishansblogvideo.files.wordpress.com/2019/05/tech_logos.png?w=768 768w, https://ishansblogvideo.files.wordpress.com/2019/05/tech_logos.png?w=1024 1024w, https://ishansblogvideo.files.wordpress.com/2019/05/tech_logos.png 1227w\" sizes=\"(max-width: 1100px) 100vw, 1100px\" style=\"max-width: 100%; height: auto; border: 0px; border-radius: 3px;\"><figcaption style=\"margin-top: 0.5em; margin-bottom: 1em; color: inherit; text-align: center; font-size: 14.25px; font-style: italic;\">Logos of the technologies/tools used</figcaption></figure><h2 style=\"clear: both; margin-top: 0.875em; margin-bottom: 0.4375em; font-family: -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen-Sans, Ubuntu, Cantarell, "Helvetica Neue", sans-serif; line-height: 1.1; color: rgb(51, 51, 50); font-size: 32px;\">Workload Distribution…</h2><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\">Four main functionalities of this project this were identified as follows.</p><ul style=\"margin-right: 0px; margin-bottom: 1.75em; margin-left: 2em; padding: 0px; list-style-position: outside; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\"><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">Admin:</span> Responsible for adding new admins and managing the privileges for each admin along with administrating the whole system.</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">Course Management: </span>Handling course related functionalities starting from basic CRUD operations to allocating students for each course.</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">Student Management:</span> Management of Students by granting permission to enroll on courses, uploading assignments and setting a student profile.</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">Instructor Management:</span> This functionality is responsible for Adding new instructors to the system, Assigning courses for each instructor and creating assignments and exams for students.</li></ul><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\">I was responsible for handling the Admin part of the project. Let’s take a look at some of the interfaces that are finished up to now and the front-end source code.</p><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\"><span style=\"font-weight: 700;\">Admin Dashboard</span></p><figure class=\"wp-block-image is-resized\" style=\"display: table; margin-bottom: 1em; max-width: 100%; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\"><img data-attachment-id=\"355\" data-permalink=\"https://ishansblog.video.blog/admin_dashboard/\" data-orig-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png\" data-orig-size=\"1902,883\" data-comments-opened=\"1\" data-image-meta=\"{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}\" data-image-title=\"admin_dashboard\" data-image-description=\"\" data-medium-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=300\" data-large-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=1024\" src=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=848&h=393\" alt=\"\" class=\"wp-image-355\" width=\"848\" height=\"393\" srcset=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=848&h=393 848w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=1693&h=786 1693w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=150&h=70 150w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=300&h=139 300w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=768&h=357 768w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=1024&h=475 1024w\" sizes=\"(max-width: 848px) 100vw, 848px\" style=\"max-width: 100%; height: auto; border: 0px; border-radius: 3px;\"><figcaption style=\"display: table-caption; margin-top: 0.5em; margin-bottom: 1em; color: inherit; text-align: center; font-size: 14.25px; font-style: italic; caption-side: bottom;\">admin dashboard</figcaption></figure><table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-spacing: 0px; border-collapse: separate; width: 1951px; margin: 0px !important; font-size: 1em !important; border: 0px !important; table-layout: auto !important; border-radius: 0px !important; background: none !important; bottom: auto !important; float: none !important; height: auto !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; box-sizing: content-box !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; direction: ltr !important; box-shadow: none !important;\"><tbody style=\"border-radius: 0px !important; background: none !important; border: 0px !important; bottom: auto !important; float: none !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; font-size: 1em !important; direction: ltr !important; box-shadow: none !important;\"><tr style=\"border-radius: 0px !important; background: none !important; border: 0px !important; bottom: auto !important; float: none !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; font-size: 1em !important; direction: ltr !important; box-shadow: none !important;\"><td class=\"gutter\" style=\"background: none !important; font-size: 1em !important; padding: 0px !important; border: 0px !important; border-radius: 0px !important; bottom: auto !important; float: none !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; direction: ltr !important; box-shadow: none !important; color: rgb(175, 175, 175) !important;\"></td></tr></tbody></table><div style=\"color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\"></div>', 'JavaScript', 0, 'Published', 0);
INSERT INTO `articles` (`article_id`, `article_category_id`, `article_title`, `article_author`, `author_id`, `article_date`, `article_image`, `article_content`, `article_tags`, `article_comment_count`, `article_status`, `article_view_count`) VALUES
(132, 1, 'Basics into Java', 'redhawk96', '5d1b45ebbca98', '2019-06-13 18:30:00', '1561831291.png', '<p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\">This article will be all about the system that we are going to develop for the Group Project of the Application Frameworks module for 3rd year 1st semester. Basic Functionality that will be delivered through this system are as follows.</p><ol style=\"margin-right: 0px; margin-bottom: 1.75em; margin-left: 2em; padding: 0px; list-style-position: outside; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\"><li style=\"margin-top: 0.4375em;\">There are 3 user roles admin, instructor and students.</li><li style=\"margin-top: 0.4375em;\">Admin can create other admins and instructors. Students need to sign up to the system.</li><li style=\"margin-top: 0.4375em;\">Once admin creates an instructor, it should be notified to the instructor via email.</li><li style=\"margin-top: 0.4375em;\">Admins can create courses and add instructors to course. <span style=\"font-weight: 700;\">Instructors</span> get notifications on new course creations when logged in to the system. <span style=\"font-weight: 700;\">After instructor accept the course, Students can join the course.</span></li><li style=\"margin-top: 0.4375em;\">Instructors can create assignments and exams for a course with due dates. Student should get notifications on these. Instructor can edit these due dates (only to a date than a original one).</li><li style=\"margin-top: 0.4375em;\">Students can upload files for assignments and exams before the due date. Instructor should be able to view these files and enter marks for the assignment or exam. Student will get notified on these markings.</li><li style=\"margin-top: 0.4375em;\">System should be secured and cannot be accessed without proper authentication.</li><li style=\"margin-top: 0.4375em;\">Authorization should be maintained and students cannot create, edit assignments or exams.</li></ol><h2 style=\"clear: both; margin-top: 0.875em; margin-bottom: 0.4375em; font-family: -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen-Sans, Ubuntu, Cantarell, "Helvetica Neue", sans-serif; line-height: 1.1; color: rgb(51, 51, 50); font-size: 32px;\">Technology Stack used…</h2><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\">To develop this system, the following technologies/tools were recommended since they were during the module lectures.</p><ul style=\"margin-right: 0px; margin-bottom: 1.75em; margin-left: 2em; padding: 0px; list-style-position: outside; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\"><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">HTML/JavaScript: </span>To design and program the front end</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">ReactJS</span>: A JavaScript Front-end library for designing reactive user interfaces.</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">NodeJS:</span> To develop the Back-end</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">ExpressJS:</span> A framework to develop web applications using NodeJS.</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">Spring Boot Framework:</span> Java Web framework to develop Web applications.</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">JSON based Web Services:</span> To communicate between Front-end and Back-end</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">NoSQL Database:</span> MongoDB will be used as the Database.</li></ul><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\">The backend service should be an API running JSON based web services. For this project, the backend will be devloped as a <span style=\"font-weight: 700;\">RESTful </span>web service.</p><figure class=\"wp-block-image\" style=\"margin-bottom: 1em; max-width: 100%; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\"><img data-attachment-id=\"350\" data-permalink=\"https://ishansblog.video.blog/tech_logos/\" data-orig-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/tech_logos.png\" data-orig-size=\"1227,152\" data-comments-opened=\"1\" data-image-meta=\"{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}\" data-image-title=\"tech_logos\" data-image-description=\"\" data-medium-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/tech_logos.png?w=300\" data-large-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/tech_logos.png?w=1024\" src=\"https://ishansblogvideo.files.wordpress.com/2019/05/tech_logos.png?w=1100\" alt=\"\" class=\"wp-image-350\" srcset=\"https://ishansblogvideo.files.wordpress.com/2019/05/tech_logos.png?w=1100 1100w, https://ishansblogvideo.files.wordpress.com/2019/05/tech_logos.png?w=150 150w, https://ishansblogvideo.files.wordpress.com/2019/05/tech_logos.png?w=300 300w, https://ishansblogvideo.files.wordpress.com/2019/05/tech_logos.png?w=768 768w, https://ishansblogvideo.files.wordpress.com/2019/05/tech_logos.png?w=1024 1024w, https://ishansblogvideo.files.wordpress.com/2019/05/tech_logos.png 1227w\" sizes=\"(max-width: 1100px) 100vw, 1100px\" style=\"max-width: 100%; height: auto; border: 0px; border-radius: 3px;\"><figcaption style=\"margin-top: 0.5em; margin-bottom: 1em; color: inherit; text-align: center; font-size: 14.25px; font-style: italic;\">Logos of the technologies/tools used</figcaption></figure><h2 style=\"clear: both; margin-top: 0.875em; margin-bottom: 0.4375em; font-family: -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen-Sans, Ubuntu, Cantarell, "Helvetica Neue", sans-serif; line-height: 1.1; color: rgb(51, 51, 50); font-size: 32px;\">Workload Distribution…</h2><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\">Four main functionalities of this project this were identified as follows.</p><ul style=\"margin-right: 0px; margin-bottom: 1.75em; margin-left: 2em; padding: 0px; list-style-position: outside; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\"><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">Admin:</span> Responsible for adding new admins and managing the privileges for each admin along with administrating the whole system.</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">Course Management: </span>Handling course related functionalities starting from basic CRUD operations to allocating students for each course.</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">Student Management:</span> Management of Students by granting permission to enroll on courses, uploading assignments and setting a student profile.</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">Instructor Management:</span> This functionality is responsible for Adding new instructors to the system, Assigning courses for each instructor and creating assignments and exams for students.</li></ul><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\">I was responsible for handling the Admin part of the project. Let’s take a look at some of the interfaces that are finished up to now and the front-end source code.</p><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\"><span style=\"font-weight: 700;\">Admin Dashboard</span></p><figure class=\"wp-block-image is-resized\" style=\"display: table; margin-bottom: 1em; max-width: 100%; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\"><img data-attachment-id=\"355\" data-permalink=\"https://ishansblog.video.blog/admin_dashboard/\" data-orig-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png\" data-orig-size=\"1902,883\" data-comments-opened=\"1\" data-image-meta=\"{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}\" data-image-title=\"admin_dashboard\" data-image-description=\"\" data-medium-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=300\" data-large-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=1024\" src=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=848&h=393\" alt=\"\" class=\"wp-image-355\" width=\"848\" height=\"393\" srcset=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=848&h=393 848w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=1693&h=786 1693w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=150&h=70 150w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=300&h=139 300w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=768&h=357 768w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=1024&h=475 1024w\" sizes=\"(max-width: 848px) 100vw, 848px\" style=\"max-width: 100%; height: auto; border: 0px; border-radius: 3px;\"><figcaption style=\"display: table-caption; margin-top: 0.5em; margin-bottom: 1em; color: inherit; text-align: center; font-size: 14.25px; font-style: italic; caption-side: bottom;\">admin dashboard</figcaption></figure><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\"><span style=\"font-weight: 700;\">Student Management</span></p><figure class=\"wp-block-image is-resized\" style=\"display: table; margin-bottom: 1em; max-width: 100%; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\"><img data-attachment-id=\"356\" data-permalink=\"https://ishansblog.video.blog/admin_student/\" data-orig-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_student.png\" data-orig-size=\"1895,887\" data-comments-opened=\"1\" data-image-meta=\"{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}\" data-image-title=\"admin_student\" data-image-description=\"\" data-medium-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_student.png?w=300\" data-large-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_student.png?w=1024\" src=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_student.png?w=847&h=396\" alt=\"\" class=\"wp-image-356\" width=\"847\" height=\"396\" srcset=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_student.png?w=847&h=396 847w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_student.png?w=1692&h=792 1692w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_student.png?w=150&h=70 150w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_student.png?w=300&h=140 300w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_student.png?w=768&h=359 768w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_student.png?w=1024&h=479 1024w\" sizes=\"(max-width: 847px) 100vw, 847px\" style=\"max-width: 100%; height: auto; border: 0px; border-radius: 3px;\"><figcaption style=\"display: table-caption; margin-top: 0.5em; margin-bottom: 1em; color: inherit; text-align: center; font-size: 14.25px; font-style: italic; caption-side: bottom;\">Student Management of Admin</figcaption></figure><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\"><span style=\"font-weight: 700;\">Student Management Settings</span></p><figure class=\"wp-block-image is-resized\" style=\"display: table; margin-bottom: 1em; max-width: 100%; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\"><img data-attachment-id=\"357\" data-permalink=\"https://ishansblog.video.blog/admin_student_settings/\" data-orig-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_student_settings.png\" data-orig-size=\"1902,932\" data-comments-opened=\"1\" data-image-meta=\"{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}\" data-image-title=\"admin_student_settings\" data-image-description=\"\" data-medium-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_student_settings.png?w=300\" data-large-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_student_settings.png?w=1024\" src=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_student_settings.png?w=879&h=430\" alt=\"\" class=\"wp-image-357\" width=\"879\" height=\"430\" srcset=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_student_settings.png?w=879&h=430 879w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_student_settings.png?w=1755&h=860 1755w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_student_settings.png?w=150&h=74 150w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_student_settings.png?w=300&h=147 300w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_student_settings.png?w=768&h=376 768w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_student_settings.png?w=1024&h=502 1024w\" sizes=\"(max-width: 879px) 100vw, 879px\" style=\"max-width: 100%; height: auto; border: 0px; border-radius: 3px;\"><figcaption style=\"display: table-caption; margin-top: 0.5em; margin-bottom: 1em; color: inherit; text-align: center; font-size: 14.25px; font-style: italic; caption-side: bottom;\">Student Management settings of Admin</figcaption></figure><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\"><span style=\"font-weight: 700;\">Instructor Management</span></p><figure class=\"wp-block-image is-resized\" style=\"display: table; margin-bottom: 1em; max-width: 100%; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\"><img data-attachment-id=\"358\" data-permalink=\"https://ishansblog.video.blog/admin_instructors/\" data-orig-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors.png\" data-orig-size=\"1904,885\" data-comments-opened=\"1\" data-image-meta=\"{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}\" data-image-title=\"admin_instructors\" data-image-description=\"\" data-medium-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors.png?w=300\" data-large-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors.png?w=1024\" src=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors.png?w=837&h=388\" alt=\"\" class=\"wp-image-358\" width=\"837\" height=\"388\" srcset=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors.png?w=835&h=388 835w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors.png?w=1669&h=776 1669w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors.png?w=150&h=70 150w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors.png?w=300&h=139 300w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors.png?w=768&h=357 768w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors.png?w=1024&h=476 1024w\" sizes=\"(max-width: 837px) 100vw, 837px\" style=\"max-width: 100%; height: auto; border: 0px; border-radius: 3px;\"><figcaption style=\"display: table-caption; margin-top: 0.5em; margin-bottom: 1em; color: inherit; text-align: center; font-size: 14.25px; font-style: italic; caption-side: bottom;\">Instructor Management of Admin</figcaption></figure><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\"><span style=\"font-weight: 700;\">Instructor Management Settings</span></p><figure class=\"wp-block-image is-resized\" style=\"display: table; margin-bottom: 1em; max-width: 100%; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\"><img data-attachment-id=\"359\" data-permalink=\"https://ishansblog.video.blog/admin_instructors_settings/\" data-orig-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors_settings.png\" data-orig-size=\"1903,882\" data-comments-opened=\"1\" data-image-meta=\"{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}\" data-image-title=\"admin_instructors_settings\" data-image-description=\"\" data-medium-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors_settings.png?w=300\" data-large-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors_settings.png?w=1024\" src=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors_settings.png?w=859&h=397\" alt=\"\" class=\"wp-image-359\" width=\"859\" height=\"397\" srcset=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors_settings.png?w=857&h=397 857w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors_settings.png?w=1713&h=794 1713w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors_settings.png?w=150&h=70 150w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors_settings.png?w=300&h=139 300w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors_settings.png?w=768&h=356 768w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors_settings.png?w=1024&h=475 1024w\" sizes=\"(max-width: 859px) 100vw, 859px\" style=\"max-width: 100%; height: auto; border: 0px; border-radius: 3px;\"><figcaption style=\"display: table-caption; margin-top: 0.5em; margin-bottom: 1em; color: inherit; text-align: center; font-size: 14.25px; font-style: italic; caption-side: bottom;\">Instructor Management settings of Admin</figcaption></figure><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\">Now let’s take a look at the front-end source of those interfaces.</p><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\"><br></p><div style=\"color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\"></div>', 'JavaScript', 0, 'Published', 0),
(134, 1, 'Basics into Java', 'redhawk96', '5d1b45ebbca98', '2019-06-18 18:30:00', '1561831291.png', '<p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\">This article will be all about the system that we are going to develop for the Group Project of the Application Frameworks module for 3rd year 1st semester. Basic Functionality that will be delivered through this system are as follows.</p><ol style=\"margin-right: 0px; margin-bottom: 1.75em; margin-left: 2em; padding: 0px; list-style-position: outside; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\"><li style=\"margin-top: 0.4375em;\">There are 3 user roles admin, instructor and students.</li><li style=\"margin-top: 0.4375em;\">Admin can create other admins and instructors. Students need to sign up to the system.</li><li style=\"margin-top: 0.4375em;\">Once admin creates an instructor, it should be notified to the instructor via email.</li><li style=\"margin-top: 0.4375em;\">Admins can create courses and add instructors to course. <span style=\"font-weight: 700;\">Instructors</span> get notifications on new course creations when logged in to the system. <span style=\"font-weight: 700;\">After instructor accept the course, Students can join the course.</span></li><li style=\"margin-top: 0.4375em;\">Instructors can create assignments and exams for a course with due dates. Student should get notifications on these. Instructor can edit these due dates (only to a date than a original one).</li><li style=\"margin-top: 0.4375em;\">Students can upload files for assignments and exams before the due date. Instructor should be able to view these files and enter marks for the assignment or exam. Student will get notified on these markings.</li><li style=\"margin-top: 0.4375em;\">System should be secured and cannot be accessed without proper authentication.</li><li style=\"margin-top: 0.4375em;\">Authorization should be maintained and students cannot create, edit assignments or exams.</li></ol><h2 style=\"clear: both; margin-top: 0.875em; margin-bottom: 0.4375em; font-family: -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen-Sans, Ubuntu, Cantarell, "Helvetica Neue", sans-serif; line-height: 1.1; color: rgb(51, 51, 50); font-size: 32px;\">Technology Stack used…</h2><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\">To develop this system, the following technologies/tools were recommended since they were during the module lectures.</p><ul style=\"margin-right: 0px; margin-bottom: 1.75em; margin-left: 2em; padding: 0px; list-style-position: outside; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\"><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">HTML/JavaScript: </span>To design and program the front end</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">ReactJS</span>: A JavaScript Front-end library for designing reactive user interfaces.</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">NodeJS:</span> To develop the Back-end</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">ExpressJS:</span> A framework to develop web applications using NodeJS.</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">Spring Boot Framework:</span> Java Web framework to develop Web applications.</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">JSON based Web Services:</span> To communicate between Front-end and Back-end</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">NoSQL Database:</span> MongoDB will be used as the Database.</li></ul><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\">The backend service should be an API running JSON based web services. For this project, the backend will be devloped as a <span style=\"font-weight: 700;\">RESTful </span>web service.</p><figure class=\"wp-block-image\" style=\"margin-bottom: 1em; max-width: 100%; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\"><img data-attachment-id=\"350\" data-permalink=\"https://ishansblog.video.blog/tech_logos/\" data-orig-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/tech_logos.png\" data-orig-size=\"1227,152\" data-comments-opened=\"1\" data-image-meta=\"{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}\" data-image-title=\"tech_logos\" data-image-description=\"\" data-medium-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/tech_logos.png?w=300\" data-large-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/tech_logos.png?w=1024\" src=\"https://ishansblogvideo.files.wordpress.com/2019/05/tech_logos.png?w=1100\" alt=\"\" class=\"wp-image-350\" srcset=\"https://ishansblogvideo.files.wordpress.com/2019/05/tech_logos.png?w=1100 1100w, https://ishansblogvideo.files.wordpress.com/2019/05/tech_logos.png?w=150 150w, https://ishansblogvideo.files.wordpress.com/2019/05/tech_logos.png?w=300 300w, https://ishansblogvideo.files.wordpress.com/2019/05/tech_logos.png?w=768 768w, https://ishansblogvideo.files.wordpress.com/2019/05/tech_logos.png?w=1024 1024w, https://ishansblogvideo.files.wordpress.com/2019/05/tech_logos.png 1227w\" sizes=\"(max-width: 1100px) 100vw, 1100px\" style=\"max-width: 100%; height: auto; border: 0px; border-radius: 3px;\"><figcaption style=\"margin-top: 0.5em; margin-bottom: 1em; color: inherit; text-align: center; font-size: 14.25px; font-style: italic;\">Logos of the technologies/tools used</figcaption></figure><h2 style=\"clear: both; margin-top: 0.875em; margin-bottom: 0.4375em; font-family: -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen-Sans, Ubuntu, Cantarell, "Helvetica Neue", sans-serif; line-height: 1.1; color: rgb(51, 51, 50); font-size: 32px;\">Workload Distribution…</h2><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\">Four main functionalities of this project this were identified as follows.</p><ul style=\"margin-right: 0px; margin-bottom: 1.75em; margin-left: 2em; padding: 0px; list-style-position: outside; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\"><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">Admin:</span> Responsible for adding new admins and managing the privileges for each admin along with administrating the whole system.</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">Course Management: </span>Handling course related functionalities starting from basic CRUD operations to allocating students for each course.</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">Student Management:</span> Management of Students by granting permission to enroll on courses, uploading assignments and setting a student profile.</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">Instructor Management:</span> This functionality is responsible for Adding new instructors to the system, Assigning courses for each instructor and creating assignments and exams for students.</li></ul><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\">I was responsible for handling the Admin part of the project. Let’s take a look at some of the interfaces that are finished up to now and the front-end source code.</p><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\"><span style=\"font-weight: 700;\">Admin Dashboard</span></p><figure class=\"wp-block-image is-resized\" style=\"display: table; margin-bottom: 1em; max-width: 100%; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\"><img data-attachment-id=\"355\" data-permalink=\"https://ishansblog.video.blog/admin_dashboard/\" data-orig-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png\" data-orig-size=\"1902,883\" data-comments-opened=\"1\" data-image-meta=\"{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}\" data-image-title=\"admin_dashboard\" data-image-description=\"\" data-medium-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=300\" data-large-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=1024\" src=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=848&h=393\" alt=\"\" class=\"wp-image-355\" width=\"848\" height=\"393\" srcset=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=848&h=393 848w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=1693&h=786 1693w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=150&h=70 150w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=300&h=139 300w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=768&h=357 768w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=1024&h=475 1024w\" sizes=\"(max-width: 848px) 100vw, 848px\" style=\"max-width: 100%; height: auto; border: 0px; border-radius: 3px;\"><figcaption style=\"display: table-caption; margin-top: 0.5em; margin-bottom: 1em; color: inherit; text-align: center; font-size: 14.25px; font-style: italic; caption-side: bottom;\">admin dashboard</figcaption></figure><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\"><span style=\"font-weight: 700;\">Student Management</span></p><figure class=\"wp-block-image is-resized\" style=\"display: table; margin-bottom: 1em; max-width: 100%; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\"><img data-attachment-id=\"356\" data-permalink=\"https://ishansblog.video.blog/admin_student/\" data-orig-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_student.png\" data-orig-size=\"1895,887\" data-comments-opened=\"1\" data-image-meta=\"{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}\" data-image-title=\"admin_student\" data-image-description=\"\" data-medium-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_student.png?w=300\" data-large-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_student.png?w=1024\" src=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_student.png?w=847&h=396\" alt=\"\" class=\"wp-image-356\" width=\"847\" height=\"396\" srcset=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_student.png?w=847&h=396 847w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_student.png?w=1692&h=792 1692w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_student.png?w=150&h=70 150w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_student.png?w=300&h=140 300w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_student.png?w=768&h=359 768w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_student.png?w=1024&h=479 1024w\" sizes=\"(max-width: 847px) 100vw, 847px\" style=\"max-width: 100%; height: auto; border: 0px; border-radius: 3px;\"><figcaption style=\"display: table-caption; margin-top: 0.5em; margin-bottom: 1em; color: inherit; text-align: center; font-size: 14.25px; font-style: italic; caption-side: bottom;\">Student Management of Admin</figcaption></figure><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\"><span style=\"font-weight: 700;\">Student Management Settings</span></p><figure class=\"wp-block-image is-resized\" style=\"display: table; margin-bottom: 1em; max-width: 100%; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\"><img data-attachment-id=\"357\" data-permalink=\"https://ishansblog.video.blog/admin_student_settings/\" data-orig-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_student_settings.png\" data-orig-size=\"1902,932\" data-comments-opened=\"1\" data-image-meta=\"{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}\" data-image-title=\"admin_student_settings\" data-image-description=\"\" data-medium-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_student_settings.png?w=300\" data-large-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_student_settings.png?w=1024\" src=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_student_settings.png?w=879&h=430\" alt=\"\" class=\"wp-image-357\" width=\"879\" height=\"430\" srcset=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_student_settings.png?w=879&h=430 879w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_student_settings.png?w=1755&h=860 1755w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_student_settings.png?w=150&h=74 150w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_student_settings.png?w=300&h=147 300w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_student_settings.png?w=768&h=376 768w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_student_settings.png?w=1024&h=502 1024w\" sizes=\"(max-width: 879px) 100vw, 879px\" style=\"max-width: 100%; height: auto; border: 0px; border-radius: 3px;\"><figcaption style=\"display: table-caption; margin-top: 0.5em; margin-bottom: 1em; color: inherit; text-align: center; font-size: 14.25px; font-style: italic; caption-side: bottom;\">Student Management settings of Admin</figcaption></figure><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\"><span style=\"font-weight: 700;\">Instructor Management</span></p><figure class=\"wp-block-image is-resized\" style=\"display: table; margin-bottom: 1em; max-width: 100%; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\"><img data-attachment-id=\"358\" data-permalink=\"https://ishansblog.video.blog/admin_instructors/\" data-orig-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors.png\" data-orig-size=\"1904,885\" data-comments-opened=\"1\" data-image-meta=\"{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}\" data-image-title=\"admin_instructors\" data-image-description=\"\" data-medium-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors.png?w=300\" data-large-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors.png?w=1024\" src=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors.png?w=837&h=388\" alt=\"\" class=\"wp-image-358\" width=\"837\" height=\"388\" srcset=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors.png?w=835&h=388 835w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors.png?w=1669&h=776 1669w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors.png?w=150&h=70 150w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors.png?w=300&h=139 300w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors.png?w=768&h=357 768w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors.png?w=1024&h=476 1024w\" sizes=\"(max-width: 837px) 100vw, 837px\" style=\"max-width: 100%; height: auto; border: 0px; border-radius: 3px;\"><figcaption style=\"display: table-caption; margin-top: 0.5em; margin-bottom: 1em; color: inherit; text-align: center; font-size: 14.25px; font-style: italic; caption-side: bottom;\">Instructor Management of Admin</figcaption></figure><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\"><span style=\"font-weight: 700;\">Instructor Management Settings</span></p><figure class=\"wp-block-image is-resized\" style=\"display: table; margin-bottom: 1em; max-width: 100%; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\"><img data-attachment-id=\"359\" data-permalink=\"https://ishansblog.video.blog/admin_instructors_settings/\" data-orig-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors_settings.png\" data-orig-size=\"1903,882\" data-comments-opened=\"1\" data-image-meta=\"{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}\" data-image-title=\"admin_instructors_settings\" data-image-description=\"\" data-medium-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors_settings.png?w=300\" data-large-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors_settings.png?w=1024\" src=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors_settings.png?w=859&h=397\" alt=\"\" class=\"wp-image-359\" width=\"859\" height=\"397\" srcset=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors_settings.png?w=857&h=397 857w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors_settings.png?w=1713&h=794 1713w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors_settings.png?w=150&h=70 150w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors_settings.png?w=300&h=139 300w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors_settings.png?w=768&h=356 768w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors_settings.png?w=1024&h=475 1024w\" sizes=\"(max-width: 859px) 100vw, 859px\" style=\"max-width: 100%; height: auto; border: 0px; border-radius: 3px;\"><figcaption style=\"display: table-caption; margin-top: 0.5em; margin-bottom: 1em; color: inherit; text-align: center; font-size: 14.25px; font-style: italic; caption-side: bottom;\">Instructor Management settings of Admin</figcaption></figure><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\">Now let’s take a look at the front-end source of those interfaces.</p><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\"><br></p><div style=\"color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\"></div>', 'JavaScript', 0, 'Published', 0);
INSERT INTO `articles` (`article_id`, `article_category_id`, `article_title`, `article_author`, `author_id`, `article_date`, `article_image`, `article_content`, `article_tags`, `article_comment_count`, `article_status`, `article_view_count`) VALUES
(135, 1, 'Basics into Java', 'redhawk96', '5d1b45ebbca98', '2019-06-12 18:30:00', '1561831291.png', '<br><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\">This article will be all about the system that we are going to develop for the Group Project of the Application Frameworks module for 3rd year 1st semester. Basic Functionality that will be delivered through this system are as follows.</p><ol style=\"margin-right: 0px; margin-bottom: 1.75em; margin-left: 2em; padding: 0px; list-style-position: outside; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\"><li style=\"margin-top: 0.4375em;\">There are 3 user roles admin, instructor and students.</li><li style=\"margin-top: 0.4375em;\">Admin can create other admins and instructors. Students need to sign up to the system.</li><li style=\"margin-top: 0.4375em;\">Once admin creates an instructor, it should be notified to the instructor via email.</li><li style=\"margin-top: 0.4375em;\">Admins can create courses and add instructors to course. <span style=\"font-weight: 700;\">Instructors</span> get notifications on new course creations when logged in to the system. <span style=\"font-weight: 700;\">After instructor accept the course, Students can join the course.</span></li><li style=\"margin-top: 0.4375em;\">Instructors can create assignments and exams for a course with due dates. Student should get notifications on these. Instructor can edit these due dates (only to a date than a original one).</li><li style=\"margin-top: 0.4375em;\">Students can upload files for assignments and exams before the due date. Instructor should be able to view these files and enter marks for the assignment or exam. Student will get notified on these markings.</li><li style=\"margin-top: 0.4375em;\">System should be secured and cannot be accessed without proper authentication.</li><li style=\"margin-top: 0.4375em;\">Authorization should be maintained and students cannot create, edit assignments or exams.</li></ol><h2 style=\"clear: both; margin-top: 0.875em; margin-bottom: 0.4375em; font-family: -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen-Sans, Ubuntu, Cantarell, "Helvetica Neue", sans-serif; line-height: 1.1; color: rgb(51, 51, 50); font-size: 32px;\">Technology Stack used…</h2><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\">To develop this system, the following technologies/tools were recommended since they were during the module lectures.</p><ul style=\"margin-right: 0px; margin-bottom: 1.75em; margin-left: 2em; padding: 0px; list-style-position: outside; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\"><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">HTML/JavaScript: </span>To design and program the front end</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">ReactJS</span>: A JavaScript Front-end library for designing reactive user interfaces.</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">NodeJS:</span> To develop the Back-end</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">ExpressJS:</span> A framework to develop web applications using NodeJS.</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">Spring Boot Framework:</span> Java Web framework to develop Web applications.</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">JSON based Web Services:</span> To communicate between Front-end and Back-end</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">NoSQL Database:</span> MongoDB will be used as the Database.</li></ul><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\">The backend service should be an API running JSON based web services. For this project, the backend will be devloped as a <span style=\"font-weight: 700;\">RESTful </span>web service.</p><figure class=\"wp-block-image\" style=\"margin-bottom: 1em; max-width: 100%; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\"><img data-attachment-id=\"350\" data-permalink=\"https://ishansblog.video.blog/tech_logos/\" data-orig-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/tech_logos.png\" data-orig-size=\"1227,152\" data-comments-opened=\"1\" data-image-meta=\"{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}\" data-image-title=\"tech_logos\" data-image-description=\"\" data-medium-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/tech_logos.png?w=300\" data-large-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/tech_logos.png?w=1024\" src=\"https://ishansblogvideo.files.wordpress.com/2019/05/tech_logos.png?w=1100\" alt=\"\" class=\"wp-image-350\" srcset=\"https://ishansblogvideo.files.wordpress.com/2019/05/tech_logos.png?w=1100 1100w, https://ishansblogvideo.files.wordpress.com/2019/05/tech_logos.png?w=150 150w, https://ishansblogvideo.files.wordpress.com/2019/05/tech_logos.png?w=300 300w, https://ishansblogvideo.files.wordpress.com/2019/05/tech_logos.png?w=768 768w, https://ishansblogvideo.files.wordpress.com/2019/05/tech_logos.png?w=1024 1024w, https://ishansblogvideo.files.wordpress.com/2019/05/tech_logos.png 1227w\" sizes=\"(max-width: 1100px) 100vw, 1100px\" style=\"max-width: 100%; height: auto; border: 0px; border-radius: 3px;\"><figcaption style=\"margin-top: 0.5em; margin-bottom: 1em; color: inherit; text-align: center; font-size: 14.25px; font-style: italic;\">Logos of the technologies/tools used</figcaption></figure><h2 style=\"clear: both; margin-top: 0.875em; margin-bottom: 0.4375em; font-family: -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen-Sans, Ubuntu, Cantarell, "Helvetica Neue", sans-serif; line-height: 1.1; color: rgb(51, 51, 50); font-size: 32px;\">Workload Distribution…</h2><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\">Four main functionalities of this project this were identified as follows.</p><ul style=\"margin-right: 0px; margin-bottom: 1.75em; margin-left: 2em; padding: 0px; list-style-position: outside; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\"><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">Admin:</span> Responsible for adding new admins and managing the privileges for each admin along with administrating the whole system.</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">Course Management: </span>Handling course related functionalities starting from basic CRUD operations to allocating students for each course.</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">Student Management:</span> Management of Students by granting permission to enroll on courses, uploading assignments and setting a student profile.</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">Instructor Management:</span> This functionality is responsible for Adding new instructors to the system, Assigning courses for each instructor and creating assignments and exams for students.</li></ul><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\">I was responsible for handling the Admin part of the project. Let’s take a look at some of the interfaces that are finished up to now and the front-end source code.</p><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\"><span style=\"font-weight: 700;\">Admin Dashboard</span></p><figure class=\"wp-block-image is-resized\" style=\"display: table; margin-bottom: 1em; max-width: 100%; color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\"><img data-attachment-id=\"355\" data-permalink=\"https://ishansblog.video.blog/admin_dashboard/\" data-orig-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png\" data-orig-size=\"1902,883\" data-comments-opened=\"1\" data-image-meta=\"{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}\" data-image-title=\"admin_dashboard\" data-image-description=\"\" data-medium-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=300\" data-large-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=1024\" src=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=848&h=393\" alt=\"\" class=\"wp-image-355\" width=\"848\" height=\"393\" srcset=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=848&h=393 848w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=1693&h=786 1693w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=150&h=70 150w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=300&h=139 300w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=768&h=357 768w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=1024&h=475 1024w\" sizes=\"(max-width: 848px) 100vw, 848px\" style=\"max-width: 100%; height: auto; border: 0px; border-radius: 3px;\"><figcaption style=\"display: table-caption; margin-top: 0.5em; margin-bottom: 1em; color: inherit; text-align: center; font-size: 14.25px; font-style: italic; caption-side: bottom;\">admin dashboard</figcaption></figure><table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-spacing: 0px; border-collapse: separate; width: 1951px; margin: 0px !important; font-size: 1em !important; border: 0px !important; table-layout: auto !important; border-radius: 0px !important; background: none !important; bottom: auto !important; float: none !important; height: auto !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; box-sizing: content-box !important; font-family: Monaco, Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; direction: ltr !important; box-shadow: none !important;\"><tbody style=\"border-radius: 0px !important; background: none !important; border: 0px !important; bottom: auto !important; float: none !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; font-size: 1em !important; direction: ltr !important; box-shadow: none !important;\"><tr style=\"border-radius: 0px !important; background: none !important; border: 0px !important; bottom: auto !important; float: none !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; font-size: 1em !important; direction: ltr !important; box-shadow: none !important;\"><td class=\"gutter\" style=\"background: none !important; font-size: 1em !important; padding: 0px !important; border: 0px !important; border-radius: 0px !important; bottom: auto !important; float: none !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; direction: ltr !important; box-shadow: none !important; color: rgb(175, 175, 175) !important;\"></td></tr></tbody></table><div style=\"color: rgb(56, 56, 56); font-family: Georgia, "Times New Roman", serif; font-size: 19px;\"></div>', 'JavaScript', 0, 'Published', 0),
(136, 1, 'Basics into Java', 'redhawk96', '5d1b45ebbca98', '2019-06-11 18:30:00', '1561831291.png', '<p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, \" times=\"\" new=\"\" roman\",=\"\" serif;=\"\" font-size:=\"\" 19px;\"=\"\">This article will be all about the system that we are going to develop for the Group Project of the Application Frameworks module for 3rd year 1st semester. Basic Functionality that will be delivered through this system are as follows.</p><ol style=\"margin-right: 0px; margin-bottom: 1.75em; margin-left: 2em; padding: 0px; list-style-position: outside; color: rgb(56, 56, 56); font-family: Georgia, \" times=\"\" new=\"\" roman\",=\"\" serif;=\"\" font-size:=\"\" 19px;\"=\"\"><li style=\"margin-top: 0.4375em;\">There are 3 user roles admin, instructor and students.</li><li style=\"margin-top: 0.4375em;\">Admin can create other admins and instructors. Students need to sign up to the system.</li><li style=\"margin-top: 0.4375em;\">Once admin creates an instructor, it should be notified to the instructor via email.</li><li style=\"margin-top: 0.4375em;\">Admins can create courses and add instructors to course. <span style=\"font-weight: 700;\">Instructors</span> get notifications on new course creations when logged in to the system. <span style=\"font-weight: 700;\">After instructor accept the course, Students can join the course.</span></li><li style=\"margin-top: 0.4375em;\">Instructors can create assignments and exams for a course with due dates. Student should get notifications on these. Instructor can edit these due dates (only to a date than a original one).</li><li style=\"margin-top: 0.4375em;\">Students can upload files for assignments and exams before the due date. Instructor should be able to view these files and enter marks for the assignment or exam. Student will get notified on these markings.</li><li style=\"margin-top: 0.4375em;\">System should be secured and cannot be accessed without proper authentication.</li><li style=\"margin-top: 0.4375em;\">Authorization should be maintained and students cannot create, edit assignments or exams.</li></ol><h2 style=\"clear: both; margin-top: 0.875em; margin-bottom: 0.4375em; font-family: -apple-system, BlinkMacSystemFont, \" segoe=\"\" ui\",=\"\" roboto,=\"\" oxygen-sans,=\"\" ubuntu,=\"\" cantarell,=\"\" \"helvetica=\"\" neue\",=\"\" sans-serif;=\"\" line-height:=\"\" 1.1;=\"\" color:=\"\" rgb(51,=\"\" 51,=\"\" 50);=\"\" font-size:=\"\" 32px;\"=\"\">Technology Stack used…</h2><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, \" times=\"\" new=\"\" roman\",=\"\" serif;=\"\" font-size:=\"\" 19px;\"=\"\">To develop this system, the following technologies/tools were recommended since they were during the module lectures.</p><ul style=\"margin-right: 0px; margin-bottom: 1.75em; margin-left: 2em; padding: 0px; list-style-position: outside; color: rgb(56, 56, 56); font-family: Georgia, \" times=\"\" new=\"\" roman\",=\"\" serif;=\"\" font-size:=\"\" 19px;\"=\"\"><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">HTML/JavaScript: </span>To design and program the front end</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">ReactJS</span>: A JavaScript Front-end library for designing reactive user interfaces.</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">NodeJS:</span> To develop the Back-end</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">ExpressJS:</span> A framework to develop web applications using NodeJS.</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">Spring Boot Framework:</span> Java Web framework to develop Web applications.</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">JSON based Web Services:</span> To communicate between Front-end and Back-end</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">NoSQL Database:</span> MongoDB will be used as the Database.</li></ul><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, \" times=\"\" new=\"\" roman\",=\"\" serif;=\"\" font-size:=\"\" 19px;\"=\"\">The backend service should be an API running JSON based web services. For this project, the backend will be devloped as a <span style=\"font-weight: 700;\">RESTful </span>web service.<span style=\"color: inherit; font-size: 14.25px; font-style: italic; text-align: center;\">Logos of the technologies/tools used</span></p><h2 style=\"clear: both; margin-top: 0.875em; margin-bottom: 0.4375em; font-family: -apple-system, BlinkMacSystemFont, \" segoe=\"\" ui\",=\"\" roboto,=\"\" oxygen-sans,=\"\" ubuntu,=\"\" cantarell,=\"\" \"helvetica=\"\" neue\",=\"\" sans-serif;=\"\" line-height:=\"\" 1.1;=\"\" color:=\"\" rgb(51,=\"\" 51,=\"\" 50);=\"\" font-size:=\"\" 32px;\"=\"\">Workload Distribution…</h2><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, \" times=\"\" new=\"\" roman\",=\"\" serif;=\"\" font-size:=\"\" 19px;\"=\"\">Four main functionalities of this project this were identified as follows.</p><ul style=\"margin-right: 0px; margin-bottom: 1.75em; margin-left: 2em; padding: 0px; list-style-position: outside; color: rgb(56, 56, 56); font-family: Georgia, \" times=\"\" new=\"\" roman\",=\"\" serif;=\"\" font-size:=\"\" 19px;\"=\"\"><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">Admin:</span> Responsible for adding new admins and managing the privileges for each admin along with administrating the whole system.</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">Course Management: </span>Handling course related functionalities starting from basic CRUD operations to allocating students for each course.</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">Student Management:</span> Management of Students by granting permission to enroll on courses, uploading assignments and setting a student profile.</li><li style=\"margin-top: 0.4375em;\"><span style=\"font-weight: 700;\">Instructor Management:</span> This functionality is responsible for Adding new instructors to the system, Assigning courses for each instructor and creating assignments and exams for students.</li></ul><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, \" times=\"\" new=\"\" roman\",=\"\" serif;=\"\" font-size:=\"\" 19px;\"=\"\">I was responsible for handling the Admin part of the project. Let’s take a look at some of the interfaces that are finished up to now and the front-end source code.</p><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, \" times=\"\" new=\"\" roman\",=\"\" serif;=\"\" font-size:=\"\" 19px;\"=\"\"><span style=\"font-weight: 700;\">Admin Dashboard</span></p><figure class=\"wp-block-image is-resized\" style=\"display: table; margin-bottom: 1em; max-width: 100%; color: rgb(56, 56, 56); font-family: Georgia, \" times=\"\" new=\"\" roman\",=\"\" serif;=\"\" font-size:=\"\" 19px;\"=\"\"><img data-attachment-id=\"355\" data-permalink=\"https://ishansblog.video.blog/admin_dashboard/\" data-orig-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png\" data-orig-size=\"1902,883\" data-comments-opened=\"1\" data-image-meta=\"{\" aperture\":\"0\",\"credit\":\"\",\"camera\":\"\",\"caption\":\"\",\"created_timestamp\":\"0\",\"copyright\":\"\",\"focal_length\":\"0\",\"iso\":\"0\",\"shutter_speed\":\"0\",\"title\":\"\",\"orientation\":\"0\"}\"=\"\" data-image-title=\"admin_dashboard\" data-image-description=\"\" data-medium-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=300\" data-large-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=1024\" src=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=848&h=393\" alt=\"\" class=\"wp-image-355\" width=\"848\" height=\"393\" srcset=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=848&h=393 848w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=1693&h=786 1693w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=150&h=70 150w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=300&h=139 300w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=768&h=357 768w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_dashboard.png?w=1024&h=475 1024w\" sizes=\"(max-width: 848px) 100vw, 848px\" style=\"max-width: 100%; height: auto; border: 0px; border-radius: 3px;\"><figcaption style=\"display: table-caption; margin-top: 0.5em; margin-bottom: 1em; color: inherit; text-align: center; font-size: 14.25px; font-style: italic; caption-side: bottom;\">admin dashboard</figcaption></figure><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, \" times=\"\" new=\"\" roman\",=\"\" serif;=\"\" font-size:=\"\" 19px;\"=\"\"><span style=\"font-weight: 700;\">Student Management</span></p><figure class=\"wp-block-image is-resized\" style=\"display: table; margin-bottom: 1em; max-width: 100%; color: rgb(56, 56, 56); font-family: Georgia, \" times=\"\" new=\"\" roman\",=\"\" serif;=\"\" font-size:=\"\" 19px;\"=\"\"><img data-attachment-id=\"356\" data-permalink=\"https://ishansblog.video.blog/admin_student/\" data-orig-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_student.png\" data-orig-size=\"1895,887\" data-comments-opened=\"1\" data-image-meta=\"{\" aperture\":\"0\",\"credit\":\"\",\"camera\":\"\",\"caption\":\"\",\"created_timestamp\":\"0\",\"copyright\":\"\",\"focal_length\":\"0\",\"iso\":\"0\",\"shutter_speed\":\"0\",\"title\":\"\",\"orientation\":\"0\"}\"=\"\" data-image-title=\"admin_student\" data-image-description=\"\" data-medium-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_student.png?w=300\" data-large-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_student.png?w=1024\" src=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_student.png?w=847&h=396\" alt=\"\" class=\"wp-image-356\" width=\"847\" height=\"396\" srcset=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_student.png?w=847&h=396 847w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_student.png?w=1692&h=792 1692w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_student.png?w=150&h=70 150w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_student.png?w=300&h=140 300w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_student.png?w=768&h=359 768w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_student.png?w=1024&h=479 1024w\" sizes=\"(max-width: 847px) 100vw, 847px\" style=\"max-width: 100%; height: auto; border: 0px; border-radius: 3px;\"><figcaption style=\"display: table-caption; margin-top: 0.5em; margin-bottom: 1em; color: inherit; text-align: center; font-size: 14.25px; font-style: italic; caption-side: bottom;\">Student Management of Admin</figcaption></figure><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, \" times=\"\" new=\"\" roman\",=\"\" serif;=\"\" font-size:=\"\" 19px;\"=\"\"><span style=\"font-weight: 700;\">Student Management Settings</span></p><figure class=\"wp-block-image is-resized\" style=\"display: table; margin-bottom: 1em; max-width: 100%; color: rgb(56, 56, 56); font-family: Georgia, \" times=\"\" new=\"\" roman\",=\"\" serif;=\"\" font-size:=\"\" 19px;\"=\"\"><img data-attachment-id=\"357\" data-permalink=\"https://ishansblog.video.blog/admin_student_settings/\" data-orig-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_student_settings.png\" data-orig-size=\"1902,932\" data-comments-opened=\"1\" data-image-meta=\"{\" aperture\":\"0\",\"credit\":\"\",\"camera\":\"\",\"caption\":\"\",\"created_timestamp\":\"0\",\"copyright\":\"\",\"focal_length\":\"0\",\"iso\":\"0\",\"shutter_speed\":\"0\",\"title\":\"\",\"orientation\":\"0\"}\"=\"\" data-image-title=\"admin_student_settings\" data-image-description=\"\" data-medium-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_student_settings.png?w=300\" data-large-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_student_settings.png?w=1024\" src=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_student_settings.png?w=879&h=430\" alt=\"\" class=\"wp-image-357\" width=\"879\" height=\"430\" srcset=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_student_settings.png?w=879&h=430 879w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_student_settings.png?w=1755&h=860 1755w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_student_settings.png?w=150&h=74 150w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_student_settings.png?w=300&h=147 300w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_student_settings.png?w=768&h=376 768w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_student_settings.png?w=1024&h=502 1024w\" sizes=\"(max-width: 879px) 100vw, 879px\" style=\"max-width: 100%; height: auto; border: 0px; border-radius: 3px;\"><figcaption style=\"display: table-caption; margin-top: 0.5em; margin-bottom: 1em; color: inherit; text-align: center; font-size: 14.25px; font-style: italic; caption-side: bottom;\">Student Management settings of Admin</figcaption></figure><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, \" times=\"\" new=\"\" roman\",=\"\" serif;=\"\" font-size:=\"\" 19px;\"=\"\"><span style=\"font-weight: 700;\">Instructor Management</span></p><figure class=\"wp-block-image is-resized\" style=\"display: table; margin-bottom: 1em; max-width: 100%; color: rgb(56, 56, 56); font-family: Georgia, \" times=\"\" new=\"\" roman\",=\"\" serif;=\"\" font-size:=\"\" 19px;\"=\"\"><img data-attachment-id=\"358\" data-permalink=\"https://ishansblog.video.blog/admin_instructors/\" data-orig-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors.png\" data-orig-size=\"1904,885\" data-comments-opened=\"1\" data-image-meta=\"{\" aperture\":\"0\",\"credit\":\"\",\"camera\":\"\",\"caption\":\"\",\"created_timestamp\":\"0\",\"copyright\":\"\",\"focal_length\":\"0\",\"iso\":\"0\",\"shutter_speed\":\"0\",\"title\":\"\",\"orientation\":\"0\"}\"=\"\" data-image-title=\"admin_instructors\" data-image-description=\"\" data-medium-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors.png?w=300\" data-large-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors.png?w=1024\" src=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors.png?w=837&h=388\" alt=\"\" class=\"wp-image-358\" width=\"837\" height=\"388\" srcset=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors.png?w=835&h=388 835w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors.png?w=1669&h=776 1669w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors.png?w=150&h=70 150w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors.png?w=300&h=139 300w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors.png?w=768&h=357 768w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors.png?w=1024&h=476 1024w\" sizes=\"(max-width: 837px) 100vw, 837px\" style=\"max-width: 100%; height: auto; border: 0px; border-radius: 3px;\"><figcaption style=\"display: table-caption; margin-top: 0.5em; margin-bottom: 1em; color: inherit; text-align: center; font-size: 14.25px; font-style: italic; caption-side: bottom;\">Instructor Management of Admin</figcaption></figure><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, \" times=\"\" new=\"\" roman\",=\"\" serif;=\"\" font-size:=\"\" 19px;\"=\"\"><span style=\"font-weight: 700;\">Instructor Management Settings</span></p><figure class=\"wp-block-image is-resized\" style=\"display: table; margin-bottom: 1em; max-width: 100%; color: rgb(56, 56, 56); font-family: Georgia, \" times=\"\" new=\"\" roman\",=\"\" serif;=\"\" font-size:=\"\" 19px;\"=\"\"><img data-attachment-id=\"359\" data-permalink=\"https://ishansblog.video.blog/admin_instructors_settings/\" data-orig-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors_settings.png\" data-orig-size=\"1903,882\" data-comments-opened=\"1\" data-image-meta=\"{\" aperture\":\"0\",\"credit\":\"\",\"camera\":\"\",\"caption\":\"\",\"created_timestamp\":\"0\",\"copyright\":\"\",\"focal_length\":\"0\",\"iso\":\"0\",\"shutter_speed\":\"0\",\"title\":\"\",\"orientation\":\"0\"}\"=\"\" data-image-title=\"admin_instructors_settings\" data-image-description=\"\" data-medium-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors_settings.png?w=300\" data-large-file=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors_settings.png?w=1024\" src=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors_settings.png?w=859&h=397\" alt=\"\" class=\"wp-image-359\" width=\"859\" height=\"397\" srcset=\"https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors_settings.png?w=857&h=397 857w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors_settings.png?w=1713&h=794 1713w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors_settings.png?w=150&h=70 150w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors_settings.png?w=300&h=139 300w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors_settings.png?w=768&h=356 768w, https://ishansblogvideo.files.wordpress.com/2019/05/admin_instructors_settings.png?w=1024&h=475 1024w\" sizes=\"(max-width: 859px) 100vw, 859px\" style=\"max-width: 100%; height: auto; border: 0px; border-radius: 3px;\"><figcaption style=\"display: table-caption; margin-top: 0.5em; margin-bottom: 1em; color: inherit; text-align: center; font-size: 14.25px; font-style: italic; caption-side: bottom;\">Instructor Management settings of Admin</figcaption></figure><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, \" times=\"\" new=\"\" roman\",=\"\" serif;=\"\" font-size:=\"\" 19px;\"=\"\">Now let’s take a look at the front-end source of those interfaces.</p><p style=\"margin-bottom: 0.875em; color: rgb(56, 56, 56); font-family: Georgia, \" times=\"\" new=\"\" roman\",=\"\" serif;=\"\" font-size:=\"\" 19px;\"=\"\"><br></p><div style=\"color: rgb(56, 56, 56); font-family: Georgia, \" times=\"\" new=\"\" roman\",=\"\" serif;=\"\" font-size:=\"\" 19px;\"=\"\"></div>', 'JavaScript', 0, 'Published', 0);
-- --------------------------------------------------------
--
-- Table structure for table `categories`
--
CREATE TABLE `categories` (
`cat_id` int(11) NOT NULL,
`cat_title` varchar(255) NOT NULL,
`added_by` varchar(255) NOT NULL,
`added_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `categories`
--
INSERT INTO `categories` (`cat_id`, `cat_title`, `added_by`, `added_on`) VALUES
(1, 'Bootstrap', '5d1b45ebbca98', '0000-00-00 00:00:00'),
(2, 'IOS', '5d1b45ebbca98', '2019-07-06 11:21:24'),
(3, 'JavaScript', '5d1b45ebbca98', '2019-07-06 11:23:20'),
(5, 'NodeJs', '5d1b45ebbca98', '2019-07-06 11:54:13'),
(6, 'Android', '5d1b45ebbca98', '2019-07-06 15:26:50');
-- --------------------------------------------------------
--
-- Table structure for table `comments`
--
CREATE TABLE `comments` (
`comment_id` int(11) NOT NULL,
`article_id` int(11) NOT NULL,
`parent_comment_id` int(11) NOT NULL DEFAULT '0',
`comment_avatar` varchar(255) NOT NULL DEFAULT 'avatar7.jpg',
`comment_author` varchar(255) NOT NULL,
`comment_email` varchar(255) NOT NULL,
`comment_content` text NOT NULL,
`comment_status` enum('Pending','Approved') NOT NULL DEFAULT 'Pending',
`comment_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `comments`
--
INSERT INTO `comments` (`comment_id`, `article_id`, `parent_comment_id`, `comment_avatar`, `comment_author`, `comment_email`, `comment_content`, `comment_status`, `comment_date`) VALUES
(1, 127, 0, 'user-6.jpg', 'Uditha', '[email protected]', '<p>Heloo this is a test comment</p>\r\n', 'Approved', '2019-07-07 14:25:19'),
(2, 130, 0, 'user-6.jpg', 'John Doe', '[email protected]', '<p>Testing two </p>\r\n', 'Pending', '2019-09-17 13:13:30'),
(3, 127, 0, 'user-6.jpg', 'John Doe', '[email protected]', '<p>At vero eos et accusamus et iusto odio dignissimos ducimus qui deleniti atque...</p>\r\n', 'Pending', '2019-07-07 16:59:56');
-- --------------------------------------------------------
--
-- Table structure for table `error_log`
--
CREATE TABLE `error_log` (
`e_id` int(11) NOT NULL,
`r_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`r_user` varchar(255) NOT NULL,
`e_content` text NOT NULL,
`e_status` enum('unresolved','resolved') NOT NULL DEFAULT 'unresolved'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `logged_info`
--
CREATE TABLE `logged_info` (
`activity_id` int(11) NOT NULL,
`user_id` varchar(255) NOT NULL,
`activity_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`page_referrer` varchar(255) DEFAULT '-',
`logged_platform` varchar(255) DEFAULT ' -',
`device_os` varchar(255) DEFAULT ' -',
`os_version` varchar(255) DEFAULT ' -',
`logged_device_browser` varchar(255) DEFAULT ' -',
`logged_ip` varchar(255) DEFAULT ' -',
`logged_city` varchar(255) DEFAULT ' -',
`logged_region` varchar(255) DEFAULT ' -',
`logged_country` varchar(255) DEFAULT ' -'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `logged_info`
--
INSERT INTO `logged_info` (`activity_id`, `user_id`, `activity_time`, `page_referrer`, `logged_platform`, `device_os`, `os_version`, `logged_device_browser`, `logged_ip`, `logged_city`, `logged_region`, `logged_country`) VALUES
(1, '5d1b45ebbca98', '2019-07-02 15:39:11', 'http://localhost/iHeartCoding/Login', 'Windows', 'Windows NT 10.0', NULL, 'Google Chrome', '::1', NULL, NULL, NULL),
(2, '5d1b45ebbca98', '2019-07-03 12:22:48', 'http://localhost/iHeartCoding/Login', 'Windows', 'Windows NT 10.0', NULL, 'Google Chrome', '::1', NULL, NULL, NULL),
(3, '5d1b45ebbca98', '2019-07-04 06:04:16', 'http://localhost/iHeartCoding/Login', 'Windows', 'Windows NT 10.0', NULL, 'Google Chrome', '::1', NULL, NULL, NULL),
(4, '5d1b45ebbca98', '2019-07-06 06:12:18', 'http://localhost/iHeartCoding/login', 'Windows', 'Windows NT 10.0', NULL, 'Google Chrome', '::1', NULL, NULL, NULL),
(5, '5d1b45ebbca98', '2019-07-06 06:19:30', 'http://localhost/iHeartCoding/Login', 'Windows', 'Windows NT 10.0', NULL, 'Google Chrome', '::1', NULL, NULL, NULL),
(6, '5d1b45ebbca98', '2019-07-06 06:22:05', 'http://localhost/iHeartCoding/Login', 'Windows', 'Windows NT 10.0', NULL, 'Google Chrome', '::1', NULL, NULL, NULL),
(7, '5d1b45ebbca98', '2019-07-06 08:33:51', 'http://localhost/iHeartCoding/Login', 'Windows', 'Windows NT 10.0', NULL, 'Google Chrome', '::1', NULL, NULL, NULL),
(8, '5d1b45ebbca98', '2019-07-06 08:34:25', 'http://localhost/iHeartCoding/Login', 'Windows', 'Windows NT 10.0', NULL, 'Mozilla Firefox', '::1', NULL, NULL, NULL),
(9, '5d1b45ebbca98', '2019-07-06 08:35:20', 'http://localhost/iHeartCoding/Login', 'Windows', 'Windows NT 10.0', NULL, 'Unknown', '::1', NULL, NULL, NULL),
(10, '5d1b45ebbca98', '2019-07-06 08:35:50', 'http://localhost/iHeartCoding/Login', 'Windows', 'Windows NT 10.0', NULL, 'Google Chrome', '::1', NULL, NULL, NULL),
(11, '5d1b45ebbca98', '2019-07-06 14:20:23', 'http://localhost/iHeartCoding/Login', 'Windows', 'Windows NT 10.0', NULL, 'Google Chrome', '::1', NULL, NULL, NULL),
(12, '5d1b45ebbca98', '2019-07-06 14:21:24', 'http://localhost/iHeartCoding/Login', 'Windows', 'Windows NT 10.0', NULL, 'Google Chrome', '::1', NULL, NULL, NULL),
(13, '5d1b45ebbca98', '2019-07-06 14:28:19', 'http://localhost/iHeartCoding/Login', 'Windows', 'Windows NT 10.0', NULL, 'Google Chrome', '::1', NULL, NULL, NULL),
(14, '5d1b45ebbca98', '2019-07-06 14:35:46', 'http://localhost/iHeartCoding/Login', 'Windows', 'Windows NT 10.0', NULL, 'Google Chrome', '::1', NULL, NULL, NULL),
(15, '5d1b45ebbca98', '2019-07-06 16:43:32', 'http://localhost/iHeartCoding/Login', 'Windows', 'Windows NT 10.0', NULL, 'Google Chrome', '::1', NULL, NULL, NULL),
(16, '5d1b45ebbca98', '2019-07-07 06:37:50', 'http://localhost/iHeartCoding/Login', 'Windows', 'Windows NT 10.0', NULL, 'Google Chrome', '::1', NULL, NULL, NULL),
(17, '5d1b45ebbca98', '2019-07-07 06:45:18', 'http://localhost/iHeartCoding/Login', 'Windows', 'Windows NT 10.0', NULL, 'Google Chrome', '::1', NULL, NULL, NULL),
(18, '5d1b45ebbca98', '2019-07-07 07:36:16', 'http://localhost/iHeartCoding/Login', 'Windows', 'Windows NT 10.0', NULL, 'Google Chrome', '::1', NULL, NULL, NULL),
(19, '5d1b7674a6162', '2019-07-07 17:08:36', 'http://localhost/iHeartCoding/Login', 'Windows', 'Windows NT 10.0', NULL, 'Google Chrome', '::1', NULL, NULL, NULL),
(20, '5d1b45ebbca98', '2019-07-09 00:24:11', 'http://localhost/iHeartCoding/Login?login=false', 'Windows', 'Windows NT 10.0', NULL, 'Google Chrome', '::1', NULL, NULL, NULL),
(21, '5d1b45ebbca98', '2019-07-09 00:27:45', 'http://localhost/iHeartCoding/Login?login=false', 'Windows', 'Windows NT 10.0', NULL, 'Google Chrome', '::1', NULL, NULL, NULL),
(22, '5d1b45ebbca98', '2019-07-09 00:27:52', 'http://localhost/iHeartCoding/Login?login=false', 'Windows', 'Windows NT 10.0', NULL, 'Google Chrome', '::1', NULL, NULL, NULL),
(23, '5d1b7674a6162', '2019-07-10 13:43:57', 'http://localhost/iHeartCoding/Login?login=false', 'Windows', 'Windows NT 10.0', NULL, 'Google Chrome', '::1', NULL, NULL, NULL),
(24, '5d1b7674a6162', '2019-07-16 14:23:32', 'http://localhost/iHeartCoding/Login?login=false', 'Windows', 'Windows NT 10.0', NULL, 'Google Chrome', '::1', NULL, NULL, NULL),
(25, '5d1b7674a6162', '2019-07-17 03:55:25', 'http://localhost/iHeartCoding/Login', 'Windows', 'Windows NT 10.0', NULL, 'Google Chrome', '::1', NULL, NULL, NULL),
(26, '5d1b7674a6162', '2019-07-31 01:06:39', 'http://localhost/iHeartCoding/Login?login=false', 'Windows', 'Windows NT 10.0', NULL, 'Google Chrome', '::1', NULL, NULL, NULL),
(27, '5d1b7674a6162', '2019-09-14 14:09:42', 'http://localhost/iHeartCoding/Login?login=false', 'Windows', 'Windows NT 10.0', NULL, 'Google Chrome', '::1', NULL, NULL, NULL),
(28, '5d1b7674a6162', '2019-09-17 13:10:43', 'http://localhost/iHeartCoding/Login', 'Windows', 'Windows NT 10.0', NULL, 'Google Chrome', '::1', NULL, NULL, NULL),
(29, '5d1b7674a6162', '2020-04-07 13:45:09', 'http://localhost/iHeartCoding/Login', 'Windows', 'Windows NT 10.0', NULL, 'Google Chrome', '::1', NULL, NULL, NULL),
(30, '5d1b45ebbca98', '2020-04-07 13:47:41', 'http://localhost/iHeartCoding/Login', 'Windows', 'Windows NT 10.0', NULL, 'Google Chrome', '::1', NULL, NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE `users` (
`user_id` varchar(255) NOT NULL,
`username` varchar(255) NOT NULL,
`user_password` varchar(255) NOT NULL,
`user_firstName` varchar(255) NOT NULL,
`user_lastName` varchar(255) NOT NULL,
`user_email` varchar(255) NOT NULL,
`user_image` varchar(255) NOT NULL,
`user_role` enum('Subscriber','Moderator','Administrator') NOT NULL DEFAULT 'Subscriber',
`user_status` enum('Active','Disabled') NOT NULL DEFAULT 'Disabled',
`user_reg_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`user_description` text,
`user_intro` text,
`user_facebook_link` varchar(255) DEFAULT ' ',
`user_youtube_link` varchar(255) DEFAULT ' ',
`user_linkedin_link` varchar(255) DEFAULT ' ',
`user_website` varchar(255) DEFAULT ' '
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `users`
--
INSERT INTO `users` (`user_id`, `username`, `user_password`, `user_firstName`, `user_lastName`, `user_email`, `user_image`, `user_role`, `user_status`, `user_reg_date`, `user_description`, `user_intro`, `user_facebook_link`, `user_youtube_link`, `user_linkedin_link`, `user_website`) VALUES
('5d1b45ebbca98', 'redhawk96', 'c130a48a9c962a5975d7ded4858b2724a5ec2a05bc9544280ea9f01fa556cf7b5a5dccc3da1e5376', 'Uditha', 'Silva', '[email protected]', '1562068460.png', 'Moderator', 'Active', '2020-04-07 13:45:48', 'of type and scrambled it to make a type specimen book. It has survived not only five of tyof type and scramalso the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishincenturies, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishinbled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishinof type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishinpe and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishincenturies, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishin', 'of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishin', ' https://www.facebook.com/uditha.arjuna96', ' https://www.youtube.com/channel/UCF8jS4CUEUtbyvsZA98Twdw?view_as=subscriber', ' https://www.linkedin.com/in/arjuna96/', ' http://iheartcoding.ezyro.com'),
('5d1b7674a6162', 'redhawk95', 'c130a48a9c962a5975d7ded4858b2724a5ec2a05bc9544280ea9f01fa556cf7b5a5dccc3da1e5376', 'Uditha', 'Silva', '[email protected]', '1562080885.png', 'Administrator', 'Active', '2019-09-14 14:13:21', NULL, NULL, ' ', ' ', ' ', ' ');
-- --------------------------------------------------------
--
-- Table structure for table `user_activity`
--
CREATE TABLE `user_activity` (
`user_id` varchar(255) NOT NULL,
`f_logged` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`l_logged` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`v_times` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `user_activity`
--
INSERT INTO `user_activity` (`user_id`, `f_logged`, `l_logged`, `v_times`) VALUES
('5d1b1e0d5e96f', '2019-07-02 09:04:49', '2019-07-02 09:06:43', 5),
('5d1b45ebbca98', '2019-07-02 11:54:46', '2020-04-07 13:47:41', 33),
('5d1b7674a6162', '2019-07-02 15:22:17', '2020-04-07 13:45:08', 11);
--
-- Indexes for dumped tables
--
--
-- Indexes for table `articles`
--
ALTER TABLE `articles`
ADD PRIMARY KEY (`article_id`);
--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
ADD PRIMARY KEY (`cat_id`);
--
-- Indexes for table `comments`
--
ALTER TABLE `comments`
ADD PRIMARY KEY (`comment_id`);
--
-- Indexes for table `error_log`
--
ALTER TABLE `error_log`
ADD PRIMARY KEY (`e_id`);
--
-- Indexes for table `logged_info`
--
ALTER TABLE `logged_info`
ADD PRIMARY KEY (`activity_id`);
--
-- Indexes for table `users`
--
ALTER TABLE `users`
ADD PRIMARY KEY (`user_id`),
ADD UNIQUE KEY `user_email` (`user_email`),
ADD UNIQUE KEY `username` (`username`);
--
-- Indexes for table `user_activity`
--
ALTER TABLE `user_activity`
ADD PRIMARY KEY (`user_id`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `articles`
--
ALTER TABLE `articles`
MODIFY `article_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=137;
--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
MODIFY `cat_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `comments`
--
ALTER TABLE `comments`
MODIFY `comment_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `error_log`
--
ALTER TABLE `error_log`
MODIFY `e_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `logged_info`
--
ALTER TABLE `logged_info`
MODIFY `activity_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;
COMMIT;
/*!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 */;