WP Retribution with Custom Table Database

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:

1. Resident information table
2. Transaction table
3. Transaction details table

Results

1. All resident data displayed in a table with Javascript-based filtering by name, house number, and block with create, update, delete functionality

2. Complete transaction history for each resident

3. Monthy retribution data to identify residents with outstanding payments for specific months

3. Transactions processing within WordPress with exportable invoices that can be sent directly to residents via WhatsApp