Payment Reports

The goal of this task is to generate reports regarding payments data required in admission process. The list of students who pay admission form fee, their sum and date-wise lists of payment.

These are explained below:

  • Payment Information of all Applicants for Admission Test Fee:

First the admin select in reports section from the menu, then he select the category Payment Information from the reports section, where he selects the Payment information of all applicants report there you have to code in this sense that your system interact with database, gets the result and shows on your interface in the form of list or table.

PAYMENT INFO OF ADMISSION TEST

  • Date wise Admission Test Fee Report:

First the admin select in reports section from the menu, then he select the category Payment Information from the reports section, where he selects the Date wise Admission Test Fee report there you have to code in this sense that your system interact with database, gets the result and shows on your interface in the form of list or table.

DATEWISE ADMISSION TEST FEE

Below Diagram shows the Sequence, how the admin can interact with system and gets the required Reports of Applicant’s Payment Record of those that are enrolled for admission test.

sequence_payment

Here is the Database script of table that is required for these reports.

Applicant database table and Payments