Ctrl+K
- 1.52 kB initial commit
- 205 Bytes Build a full-featured, modular, and secure Human Resource Management System (HRMS) web application for a microfinance institution with over 50 staff members across multiple branches. The system should be built using Python, Streamlit for the UI, and SQL Server as the backend database. Ensure the app is suitable for a non-technical HR Manager to operate easily. The architecture should be clean and maintainable, with proper separation of logic, database operations, and user interface. Core Functionalities: ๐งโ๐ผ 1. Employee Management Add, edit, deactivate/reactivate employee records. Employee profile should include: Full Name, Gender, DOB, POB, Marital Status, Number of Children, CNPS Number, Account Number, Contact Info, Address, Branch, Department, Category, Position, Date Hired, Current Status (e.g., Active, On Maternity Leave, On Annual Leave). Photo upload and employee document management (e.g., ID, CV). Search and filter employee list. ๐๏ธ 2. Leave Management Employees are entitled to leave based on years of service: 1โ5 years: 18 days 6โ10 years: 21 days 11โ15 years: 24 days 16+ years: 30 days Leave request and approval workflow. Calculate and validate leave dates excluding weekends. Prevent double leave per year. Flag employees on leave for payroll calculations. ๐ฐ 3. Payroll Management Auto-calculate salary based on position, branch, and category rules. Handle fields like: Basic Salary, Seniority, Duty Cash, Housing, Transport, Urban Allowance, Gross, CNPS, Income Tax, CRTV, Council Tax, HLF, LDT, Net Pay, Deposit. Include personal deductions: Loans, Overdrafts, Savings, SO, SSS, Commitments, etc. Salary calculator should auto-populate and allow for adjustments. Prevent duplicate salary submission for same month. Detect if employee is on leave and set salary fields to zero except ID, CategoryID, PayDate. ๐งพ 4. Reports Salary Sheet Report (PDF & Excel) by PayDate with: A/C, Staff Name, Category, Basic, Housing, Transport, Gross, Tax, Commitments, Net Pay, etc. Totals at bottom. Landscape orientation, 50 records per page max. Employee List Report (filterable by Branch, Status, Category, etc.). Leave Report (taken, pending, remaining days). Export options: Excel & PDF with headers, org logo, address, and timestamp. ๐ 5. User Authentication & Role Permissions Admin, HR, Viewer roles. Admin can manage all features. HR can process payroll and manage leave. Viewer can only view reports and profiles. ๐ ๏ธ 6. Configuration Modules Manage dropdowns: Branches, Categories, Positions, Departments. Add/edit/remove these values from settings panel. ๐ฆ 7. App Design & Architecture Use pages/ directory in Streamlit for modular app navigation. Separate files for database operations (db_employee.py, db_payroll.py). Use a central payroll_functions.py to house payroll logic. Clean UI: card layouts, colored sections, responsive forms. Validation for all forms. ๐งฎ 8. Utilities Automated backup of database monthly. Notification/reminder for upcoming leave or expiring contracts. Dashboard overview: total employees, on leave, monthly payroll total, etc. ๐ง Technical Stack Frontend: Streamlit Backend: Python 3.11+ Database: SQL Server 2022 PDF Generation: reportlab, Excel Export: pandas + openpyxl Authentication: Streamlit session state / or custom login system Deployment: On-premises Windows PC (intranet) - Initial Deployment
- 34.8 kB Build a full-featured, modular, and secure Human Resource Management System (HRMS) web application for a microfinance institution with over 50 staff members across multiple branches. The system should be built using Python, Streamlit for the UI, and SQL Server as the backend database. Ensure the app is suitable for a non-technical HR Manager to operate easily. The architecture should be clean and maintainable, with proper separation of logic, database operations, and user interface. Core Functionalities: ๐งโ๐ผ 1. Employee Management Add, edit, deactivate/reactivate employee records. Employee profile should include: Full Name, Gender, DOB, POB, Marital Status, Number of Children, CNPS Number, Account Number, Contact Info, Address, Branch, Department, Category, Position, Date Hired, Current Status (e.g., Active, On Maternity Leave, On Annual Leave). Photo upload and employee document management (e.g., ID, CV). Search and filter employee list. ๐๏ธ 2. Leave Management Employees are entitled to leave based on years of service: 1โ5 years: 18 days 6โ10 years: 21 days 11โ15 years: 24 days 16+ years: 30 days Leave request and approval workflow. Calculate and validate leave dates excluding weekends. Prevent double leave per year. Flag employees on leave for payroll calculations. ๐ฐ 3. Payroll Management Auto-calculate salary based on position, branch, and category rules. Handle fields like: Basic Salary, Seniority, Duty Cash, Housing, Transport, Urban Allowance, Gross, CNPS, Income Tax, CRTV, Council Tax, HLF, LDT, Net Pay, Deposit. Include personal deductions: Loans, Overdrafts, Savings, SO, SSS, Commitments, etc. Salary calculator should auto-populate and allow for adjustments. Prevent duplicate salary submission for same month. Detect if employee is on leave and set salary fields to zero except ID, CategoryID, PayDate. ๐งพ 4. Reports Salary Sheet Report (PDF & Excel) by PayDate with: A/C, Staff Name, Category, Basic, Housing, Transport, Gross, Tax, Commitments, Net Pay, etc. Totals at bottom. Landscape orientation, 50 records per page max. Employee List Report (filterable by Branch, Status, Category, etc.). Leave Report (taken, pending, remaining days). Export options: Excel & PDF with headers, org logo, address, and timestamp. ๐ 5. User Authentication & Role Permissions Admin, HR, Viewer roles. Admin can manage all features. HR can process payroll and manage leave. Viewer can only view reports and profiles. ๐ ๏ธ 6. Configuration Modules Manage dropdowns: Branches, Categories, Positions, Departments. Add/edit/remove these values from settings panel. ๐ฆ 7. App Design & Architecture Use pages/ directory in Streamlit for modular app navigation. Separate files for database operations (db_employee.py, db_payroll.py). Use a central payroll_functions.py to house payroll logic. Clean UI: card layouts, colored sections, responsive forms. Validation for all forms. ๐งฎ 8. Utilities Automated backup of database monthly. Notification/reminder for upcoming leave or expiring contracts. Dashboard overview: total employees, on leave, monthly payroll total, etc. ๐ง Technical Stack Frontend: Streamlit Backend: Python 3.11+ Database: SQL Server 2022 PDF Generation: reportlab, Excel Export: pandas + openpyxl Authentication: Streamlit session state / or custom login system Deployment: On-premises Windows PC (intranet) - Initial Deployment
- 388 Bytes initial commit