Project Details
In my residential area, I was tasked with managing monthly retribution fees. When I first undertook this responsibility, all records were kept manually, making it extremely difficult to track payment history for each resident. This was especially challenging as I didn’t know the names of homeowners associated with house numbers.
Solutions
Need a quick solutions, I decided to implement a custom database structure using the WordPress engine.
The system includes three relational tables:
- Resident information table
- Transaction table
- Transaction details table
Results
- All resident data displayed in a table with Javascript-based filtering by name, house number, and block with
create,update,delete functionality
- Complete transaction history for each resident
- Monthy retribution data to identify residents with outstanding payments for specific months
- Transactions processing within WordPress with exportable invoices that can be sent directly to residents via WhatsApp
