Leave Management App
This topic provides step-by-step instructions for building a Leave Management app using the WaveMaker Rapid-Application Development Platform.
This app allows an employee to apply for leave, and it will enable the manager to take action against the leave request.
Pre-Requisite: You are advised to understand the WaveMaker App Development Essentials before starting to build the app.
The following concepts are covered in building this application.
- Creating Basic Application
- Building the UI – Layouts, Templates and Widgets
- Connecting to Database
- Creating Variables to access database
- Creating Variables to access queries
- Securing the App
- Running the App
Creating a Basic Application
|1||Database||A predefined sample database is provided to work with.|
|2||Profile||This is an Employee Profile. It contains the list of employees from the same Department.|
|3||Employee List||View the list of employees within the organisation. Visible to Managers only.|
|4||Workflows||Keep track of the applied leaves and the statuses.|
|5||Security||Users get access to view specific pages only depending on the user-permission level.|
|6||Dashboard||Use charts to depict the leave utilisation of employees.|
WMFirst Steps - Page Creation, Page Navigation, Connect to Database
WMBuilding Employee List Page
WMBuilding Secure Pages - Profile, My Leaves
WMWorkflows - Apply Leave, Approve/Reject LeavesQueries needed in this step:
select e.firstname,e.lastname,e.picurl,e.birthdate,e.job_title,e.city, v.* from employee e,vacation v where e.emp_id=v.emp_id and manager_id=:data and status='Pending'
update Vacation set status = :status where id =:id
WMDashboard using Charts