Web Application for Tax Management

A web development using PHP Laravel Framework & database ms sql server
this web application contains the following functionality
1.    Administrator Module
a.    User: CRUD
    This page allows the system administrator to create new user, update user, delete user, activate and deactivate user
    Each of the users must contain information such as user id, full name, login id, password, email address, status (active or inactive) and etc.


b.    User Group: CRUD
    This page allows the system administrator to create a new user group, update user group, delete user group, activate & deactivated user group
    Each of the user groups must contain information such as user group id, user group name, status (active or inactive) and etc. 
c.    Module: CRUD
    This page allows the system administrator to create a new module, update module name, delete the module
d.

User Authorization :
    This page allows the system administrator to assign user groups to the user; each user can have more than one user group.
    This page allows the system administrator to assign the module to the user group. I.E: User Group A has read-only for Exemption module; User Group B has read/edit for Exemption Module.
e.    System Properties:
    This page allows the system administrator to define the system properties, such as:
    Database connection: to define database connection details here.
    Logfile directory: to define the path for log file
    smtp: to define smtp details
    user email: to define emails that receive an email notification from the system.

f.    Domain:
    This page allows the system administrator to define the value list for drop-down field
    This page allows the system administrator to create a new drop-down field and define all the value list
    This page allows the system administrator to edit existing drop-down field
    This page allows the system administrator to delete the existing drop-down field.

g.    Third-Party Integration properties:
    This page allows the system administrator to define the database connection details for a third-party application. This information will be used to query information from another database/system.
    It includes information such as connection name, connection database, connection id, connection password and etc…..


    This page allows the system administrator to define more than one third-party integration properties. 

2.    User Module 1: Exemption Maintainance
    only the authorized user group is allowed to use this module
a.

Exemption Code
    This page allows the user to register new Exemption code and fill in other details, edit existing exemption code, activate or deactivate exemption code
b.    Exemption Line
    After creating the exemption code, then the user is allowed to create exemption lines.
    One exemption code can have more than one exemption line
    This page allows the user to edit and delete the exemption line.


    Each exemption line is required to define the alert level and cut off date.
    A formula will be applied.  It involves a connection to the third-party system/database and comparing the value. If a certain value of quantity reaches the alert level, the system will send an email notification to the user.



3.    User Module 2: Exemption Enquiry
    only the authorized user group is allowed to use this module
a.    This page allows the user to query the exemption code and views the details of its exemption line.
b.    The output of the inquiry can export into excel