Examination - PaperLessEdu/schoolerp-web-ui GitHub Wiki
Examination Module
- Create exam
Table Name: exam_master
Method: POST
| Field | Description |
|---|---|
| exam_master_id | Primary key |
| academicYearId | Foreign key of academic year table |
| standardId | Foreign key of standard table |
| name |
- Schedule Exam
Table Name: exam_timetable
Method: POST
| Field | Description |
|---|---|
| exam_timetable_id | Primary key |
| exam_master_id | Foreign key of exam_master table |
| subjectId | Foreign key of subject table |
| examType | |
| date | |
| startTime | |
| endTime | |
| outOfMarks | |
| passingMarks | |
| scoreType |
Request Payload for first two API's
{ "academicYearId": 1, "standardId": 1, "name": "Unit Test 1", "examSchedule": [ { "subjectId": 1, "distribution": [ { "examType": "Theory", "date": "", "startTime": "", "endTime": "", "scoreType": "Marks", "outOfMarks": 50, "passingMarks": 35 }, { "examType": "Oral", "date": "", "startTime": "", "endTime": "", "scoreType": "Grade", "outOfMarks": null, "passingMarks": null }, { "examType": "Practical", "date": "", "startTime": "", "endTime": "", "scoreType": "Marks", "outOfMarks": 30, "passingMarks": 12 } ] } ] }
curl -X POST
http://localhost:9090/examination
-H 'Cache-Control: no-cache'
-H 'Content-Type: application/json'
-H 'Postman-Token: ad39afb6-60cc-4547-8e86-88f54bd7fa5b'
-d '{
"academicYearId": 1,
"standardId": 1,
"name": "Unit Test 1",
"examSchedule": [{
"subjectId": 1,
"distribution": [{
"examType": "Theory",
"date": "2018-01-01",
"startTime": "2015-07-05T22:16:18Z",
"endTime": "2015-07-05T22:16:18Z",
"scoreType": "Marks",
"outOfMarks": 50,
"passingMarks": 35
}, {
"examType": "Oral",
"date": "2018-01-01",
"startTime": "2015-07-05T22:16:18Z",
"endTime": "2015-07-05T22:16:18Z",
"scoreType": "Grade",
"outOfMarks": null,
"passingMarks": null
}, {
"examType": "Practical",
"date": "2018-01-01",
"startTime": "2015-07-05T22:16:18Z",
"endTime": "2015-07-05T22:16:18Z",
"scoreType": "Marks",
"outOfMarks": 30,
"passingMarks": 12
}
]
}
]
}
'
GET api TEMP response
[{"exammasterid":801,"academicyear":{"academicYearId":2,"name":"2018-2019","startDate":"2018-05-31T18:30:00.000+0000","endDate":"2019-05-30T18:30:00.000+0000","weekendType":"EverySunday","create_dt":"2018-07-02T15:33:23","last_update_dt":"2018-07-02T15:33:23","current":true},"standard":{"standard_id":3,"name":"11th","create_dt":"2018-07-02T15:33:40","last_update_dt":"2018-07-02T15:33:40"},"name":"Unit Test 5"}]
Expected GET response
http://dev.cloudscripts.co.in/schoolManagement/examination?academicYearId=1&standardId=1
[ { "name": "Unit Test 1", "examSchedule": [ { "subjectId": 313, "distribution": [ { "date": "2018-07-29T18:30:00.000Z", "startTime": "14:00", "endTime": "15:00", "examType": "Theory", "scoreType": "Marks", "marksOutOf": 80, "passingMarks": 35 }, { "date": "2018-07-30T18:30:00.000Z", "startTime": "13:00", "endTime": "14:30", "examType": "Oral", "scoreType": "Marks", "marksOutOf": 20, "passingMarks": 7 } ] }, { "subjectId": 314, "distribution": [ { "date": "2018-07-30T18:30:00.000Z", "startTime": "16:00", "endTime": "17:00", "examType": "Theory", "scoreType": "Grade", "marksOutOf": null, "passingMarks": null } ] } ] }, { "name": "Unit Test 2", "examSchedule": [ { "subjectId": 313, "distribution": [ { "date": "2018-07-29T18:30:00.000Z", "startTime": "14:00", "endTime": "15:00", "examType": "Theory", "scoreType": "Marks", "marksOutOf": 80, "passingMarks": 35 } ] }, { "subjectId": 314, "distribution": [ { "date": "2018-07-30T18:30:00.000Z", "startTime": "16:00", "endTime": "17:00", "examType": "Theory", "scoreType": "Grade", "marksOutOf": null, "passingMarks": null } ] } ] } ]
get actual response
[ { "name": "Unit Test 5", "examSchedule": [ { "subjectId": 1, "distribution": [ { "date": "2017-12-31T18:30:00.000+0000", "startTime": "12:30 AM", "endTime": "1:30 PM", "examType": "Oral", "scoreType": "Grade", "marksOutOf": 0, "passingMarks": 0 }, { "date": "2017-12-31T18:30:00.000+0000", "startTime": "11:30 AM", "endTime": "12:30 pm", "examType": "Practical", "scoreType": "Marks", "marksOutOf": 30, "passingMarks": 12 }, { "date": "2017-12-31T18:30:00.000+0000", "startTime": "2015-07-05T22:16:18Z", "endTime": "2015-07-05T22:16:18Z", "examType": "Theory", "scoreType": "Marks", "marksOutOf": 50, "passingMarks": 35 } ] } ] }, { "name": "Unit Test 2", "examSchedule": [ { "subjectId": 1, "distribution": [ { "date": "2017-12-31T18:30:00.000+0000", "startTime": "2015-07-05T22:16:18Z", "endTime": "2015-07-05T22:16:18Z", "examType": "Theory", "scoreType": "Marks", "marksOutOf": 50, "passingMarks": 35 }, { "date": "2017-12-31T18:30:00.000+0000", "startTime": "12:30 AM", "endTime": "1:30 PM", "examType": "Oral", "scoreType": "Grade", "marksOutOf": 0, "passingMarks": 0 }, { "date": "2017-12-31T18:30:00.000+0000", "startTime": "11:30 AM", "endTime": "12:30 pm", "examType": "Practical", "scoreType": "Marks", "marksOutOf": 30, "passingMarks": 12 } ] } ] }, { "name": "Unit Test 2", "examSchedule": [ { "subjectId": 1, "distribution": [ { "date": "2018-01-01T00:00:00.000+0000", "startTime": "2015-07-05T22:16:18Z", "endTime": "2015-07-05T22:16:18Z", "examType": "Theory", "scoreType": "Marks", "marksOutOf": 50, "passingMarks": 35 }, { "date": "2018-01-01T00:00:00.000+0000", "startTime": "12:30 AM", "endTime": "1:30 PM", "examType": "Oral", "scoreType": "Grade", "marksOutOf": 0, "passingMarks": 0 }, { "date": "2018-01-01T00:00:00.000+0000", "startTime": "11:30 AM", "endTime": "12:30 pm", "examType": "Practical", "scoreType": "Marks", "marksOutOf": 30, "passingMarks": 12 } ] } ] }, { "name": "Unit Test 23", "examSchedule": [ { "subjectId": 1, "distribution": [ { "date": "2018-01-01T00:00:00.000+0000", "startTime": "2015-07-05T22:16:18Z", "endTime": "2015-07-05T22:16:18Z", "examType": "Theory", "scoreType": "Marks", "marksOutOf": 50, "passingMarks": 21 }, { "date": "2018-01-01T00:00:00.000+0000", "startTime": "12:30 AM", "endTime": "1:30 PM", "examType": "Oral", "scoreType": "Grade", "marksOutOf": 0, "passingMarks": 0 }, { "date": "2018-01-01T00:00:00.000+0000", "startTime": "11:30 AM", "endTime": "12:30 pm", "examType": "Practical", "scoreType": "Marks", "marksOutOf": 30, "passingMarks": 11 } ] } ] } ]
- Exam Result
Table Name: exam_result
Method: POST
| Field | Description |
|---|---|
| exam_result_id | Primary key |
| exam_master_id | Foreign key of exam_master table |
| exam_timetable_id | Foreign key of exam_timetable_id |
| studentId | Foreign key of student table |
| standardId | Foreign key of standard table |
| subjectId | Foreign key of subject table |
| examType | Theory | Oral | Practical |
| scoreType | Marks | Grade |
| marks | |
| grade |