fkeenv / ledger-wise

0 stars 0 forks source link

Add HRIS #4

Closed fkeenv closed 1 month ago

fkeenv commented 2 months ago
fkeenv commented 2 months ago

To do: CRUD Positions

  1. Add positions table
  2. Departments has many positions; A Position belongs to a Department
  3. Employees has many Positions; Positions has many employees
  4. Position can have levels (rankings)

Additional notes: Maybe we can add https://github.com/lazychaser/laravel-nestedset for easier implementation of tree structure for organizational structure.

Done.

fkeenv commented 2 months ago

To do: Assign positions to an employee

  1. Create an api to assign an employee positions
  2. Create an api to assign a position to an employee

Done.

fkeenv commented 2 months ago

To do: CRUD Attendance

attendances table:

  • id
  • attendance_type
  • attendance_id
  • date
  • timestamps

attendance_times table:

  • id
  • attendance_id
  • time
  • type - enum(start, pause, afk, back, end)
  • timestamps

attendance_settings table

  • id
  • name
  • description
  • hours (number of hours per day)
  • timestamps

attendance_setting_position table

  • id
  • attendance_setting_id
  • position_id
  • timestamps

wip

Done.

fkeenv commented 1 month ago

To do: Employee Salary

  • [x] CRUD Employment benefits
    • This is for the company to setup employment benefits to be assigned to an employee i.e. SSS contribution, Pag-ibig contribution, etc.
  • [x] CRUD Employee benefits
    • Assign employment benefits to this table so we can know which benefit(s) an employee has/have.
  • [x] CRUD Employee settings
    • This is where HR can setup employee salary, tax, employment date, etc

Done.