Web based Course Registration Application

I am running an IT company providing web based solutions, I have a client running a small training center to teach some courses. I need someone who can help my client build a simple web based application to allow me to

1) enter registration details of trainees

2) access and edit registration records

3) identify if the minimum number of students has reached for a particular course (in order to start the course). If enough, trigger an email to confirm the course. Else trigger an email to postpone the course.

4) issue invoice based on registration record the course signed up and confirmed in step (3).

5) identify students apply for government grant.

6) track invoices for payment paid and unpaid

7) maintain a database of trainers /lecturers of their name, contact number, email, address, preference (day available) and rate (fee)

8) print & amend notes, reference materials, course outlines, feedback forms, answer sheets certificate, course pass stored in designated folder.

9) print & amend blank registration form for manual registration.

10) print & amend course brochures, terms of services, etc.. from designated folder.

11) print & amend receipt acknowledgment form.

12) print attendance list for use during first session of course.

13) print and amend course schedules

14) publish course schedules in website

15) send email with standard templates for students who passed, failed, did not achieve the required attendance.

17) record the attendance of students, the scores of each students, payment received/not received.

16) trigger emails to remind me of confirmation of course, unpaid fees, submission of answer, non-company cheque payment, failed students, passed students. (basically a to-do-list)

17) trigger email to trainers to advise them of courses starting soon.

I am using phprunner to create this web app but I am not very efficient in it yet. I hope to get someone who know phprunner well to complete what I have done so far.

I signed up hosting with 3ix.org. So I need you to help me upload and install into this hosting site.

## Deliverables

**More details :-**

The main page (see attachment)of the application will show 6 options

[1] Course Details Setting

[2] Course Registration

[3] Invoicing and Payment Tracking (printing of invoice and official receipt)

[4] Printing of invoices and receipts, course cert and course pass, etc.

[5] Email Templates

[6] Upload to MOM

Tables/ databases required

(1) Course Table, attendance status table, language table, etc..

(2) Class Table (Class - session : master - details)

(3) Registration Table

(4) Trainees Table

(5) Trainers Table

(6) Company Table

See attachments for clearer picture. I will need the system to be able to send notification (emails) to user once someone registered or the class max capacity is reached or the class minimum start number is reached. A few other email triggers may be needed as mentioned earlier.

**Take note of the relationship in the following databases:**

(1) Course Details Database has fields such as "Course Name", "Course Fee", "Course Code", "Class ID", "Course Day", "Class Session Start time", "Class Session End Time", "Preferred Trainer".

Course Name to Class ID : 1 to many

Course Name to Course Code : 1 to 1

Class ID to Session Session: 1 to many

Course Session to Preferred Trainer : 1 to 1

In layman terms, one course can have a few classes. Each class covers a few days, each day has a few sessions.

Eg. BCSS English Course costs S$368 and have 2 classes per month. Each class can be 4 Saturdays, 4 weekdays, or 10 evenings. Eg. 1 Saturday has 3 sessions. 1 evening has one 1 session.

(2) Registration Database has fields such as "Course Name", "Course Code", "Trainees", "Company".

Course Name should be a drop down menu allowing user to select one of the course.

Once a course name is selected, the user is allowed to choose the respective class ID under that particular course name

Each Class may be attended by a more than 1 trainees. Eg. a company send 3 trainees to attend for a particular class. Thus 1 class may have many trainees. The web form for this registration database should allow user to add more trainee (and trainee's details).

**Invoicing and Payment Tracking**

Upon registration, a record with the respective course fee and/or pass fee will be added into the invoice table.

A table showing all the record will be listed. User should be allowed to amend on selected record field such as fee, invoice items and payment status. User should also be allowed to add new invoice. Invoice, Receipt or reminder letter can be printed upon highlighting the record to be sent.

**Upload to MOM**

This is a very simple module that allow user to enter the scores / results /marks of the trainees and export the result in csv format. Output will be a cvs file.

**Email Templates**

All templates will be given but the user should be allowed to amend the existing templates.

**Printing**

All samples such as certs, pass, attendance register / list, Feedback form, trainer assignment table will be provided to you.

시스코 전자 공학 PHP 소프트웨어 아키텍처 소프트웨어 테스팅 웹 호스팅 웹사이트 관리 웹사이트 테스팅

프로젝트 ID: #2664072

프로젝트 소개