IDC checkout Function Analysis

1. Understanding of three user levels:

Generally, the user is the teacher on duty in the IDC room. The operator is mainly responsible for the normal loading and downloading of students; the operator is mainly responsible for student registration cards, returning cards, and managing student information; the Administrator checks the operators and checks the income. It can be similar to the guy, accountant, and boss in a restaurant.

 

2. Checkout

2.1 The interface is as follows:

2.2 During the checkout, we should first understand the origins of each amount and then know the calculation method. Figure:

The terms are explained as follows: (the query conditions for each table are ischeck = "not checked" and userid = "cmbuserid. Text ")

Total revenue: add the registration and recharge amount information to the recharge table {recharge_table}, and sum the "addcash" column to get the total recharge amount.

Return: sum the "cancelcash" column in the cancelcard_table to obtain the total return amount.

Actual revenue: total income-return

Net income: the amount consumed on the machine. net income for the sum of the consumecash column in The lined_table

Waiting for income: the balance in the student card (why is it called waiting for income, because the money has not been consumed, and it is also possible to return the money to the student, so it is called waiting for income)

2.3 procedure:

Enter the user name and check whether the user name exists.

Click buy card to display the purchase card information for this user. Recharge your account.

Click "summary" to display the basic checkout information, click "checkout" to modify the status of each table to "checked", and add the checkout information to the check_table table to provide data for future reports.

3. Conclusion: The bill is generated only after the bill is settled. The bill is a summary of the data center income and provides data for future reports. After analyzing the checkout function, you can understand the code.

IDC checkout Function Analysis