build web-app as per excel with PHP (Laravel or Codeigniter)
You can use [login to view URL] dashboard template or any other template.
users CRUD with 4 roles
admin - can do everything
manager - can do everything except delete and inactive engineer
clerk - log in and data entry of payroll (no delete)
engineer - log in and View their payments slips
Excel Sheet tabs:
1: Income Analysis (Main data entry for payroll)
2: Earnings statement excel sheet tab >>> Dashboard ( with a settings page to set Admin Fees %)
3: Sources (extracted information from other platforms)
Features:
1) Field Engineers must be able to log in to view Pay slips, and print /download them
2) Must be able to add Field Engineers to the system, and each must have a Unique ID
2)Payroll clerks/Managers/Admin must be able to log in, and create pay for
3) We need a front end, and admin panel to manage the system
4) Field engineers pays are calculated based on Hourly work, per Ticket, and also a Flat rate, and Engineer can work on a Ticket and have a combination of Flat rate AND HOURLY ON THE SAME ticket
5) make crud for drop-downs as in AO,AP,AQ column of Income Analysis
Note:
switch between Dark and Light Themes(this option is already in adminlte template so keep it as is.