The employee plugin allows you to manage employees and their salaries. It is required for payroll checks. It is a full-stack plugin with regular CRUD routes and a front end.
This is the main area powered by this plugin:
For Developers
Employees are stored in the customers’ table. Their CUST_TYPE set to CUST_EMPLOYEE. Their details are stored in customer details just like other customers. For example here is a query to select employees with their salaries.
SELECT CAST(value AS INT) AS salary, customer.name, customer.id
FROM customerDetail
LEFT JOIN customer ON customer.id = customerId
WHERE customerDetail.name = 'salary' AND customerTypeKey = 'CUST_EMPLOYEE'