​

👥 HR & Payroll Module (hr_*)

​

1. Module Purpose

• Menyimpan master karyawan per company.
• Mencatat kehadiran (attendance) dan cuti.
• Menyimpan hasil payroll per periode.

​

2. Tables & Structure

​

3. Key Fields & Relationships

​

3.1 hr_emp

• Fields: company_id, emp_no, name, position, department, hire_date, status.
• FK: company_id → core_company.id.

​

3.2 hr_att

• Fields: emp_id, att_date, check_in, check_out, status (present, absent, leave, dsb.).
• FK: emp_id → hr_emp.id.

​

3.3 hr_leave

• Fields: emp_id, start_date, end_date, type, status (requested, approved, rejected).
• FK: emp_id → hr_emp.id.

​

3.4 hr_payroll

• Fields: emp_id, period_start, period_end, gross_salary, deduction, net_salary, status.
• FK: emp_id → hr_emp.id.
• Payroll batch bisa di-post ke GL via mapping COA (beban gaji, kas, utang gaji).

​

4. Business Flows

​

4.1 Kehadiran & Cuti → Payroll

1. Kehadiran harian dicatat di hr_att.
2. Cuti/izin di hr_leave.
3. Engine payroll mengambil data attendance & leave untuk menghitung gaji.
4. Hasilnya disimpan di hr_payroll, lalu di-post ke GL (gl_entry + gl_line).

​

5. Example Reports (SQL)

​

5.1 Rekap Kehadiran per Karyawan

SELECT
  e.emp_no,
  e.name,
  COUNT(CASE WHEN a.status = 'present' THEN 1 END) AS days_present,
  COUNT(CASE WHEN a.status = 'absent'  THEN 1 END) AS days_absent,
  COUNT(CASE WHEN a.status = 'leave'   THEN 1 END) AS days_leave
FROM hr_emp e
LEFT JOIN hr_att a ON a.emp_id = e.id
WHERE e.company_id = :company_id
  AND a.att_date BETWEEN :start_date AND :end_date
GROUP BY e.id;

​

5.2 Rekap Payroll per Periode

SELECT
  e.emp_no,
  e.name,
  p.period_start,
  p.period_end,
  p.gross_salary,
  p.deduction,
  p.net_salary
FROM hr_payroll p
JOIN hr_emp e ON e.id = p.emp_id
WHERE e.company_id = :company_id
  AND p.period_start >= :period_start
  AND p.period_end   <= :period_end;

​

5.3 Total Payroll per Departemen

SELECT
  e.department,
  SUM(p.net_salary) AS total_payroll
FROM hr_payroll p
JOIN hr_emp e ON e.id = p.emp_id
WHERE e.company_id = :company_id
  AND p.period_start >= :period_start
  AND p.period_end   <= :period_end
GROUP BY e.department;