System settings overview, schema health, table detection, and operational notes for 4 P’s.
These pages are built to live in the same root folder as claims.php, plans.php, invoices.php, payments.php, and the other 4 P’s pages. They are not written for an /admin subfolder unless paths are rewritten.
This page uses require_once __DIR__ . '/app/db.php'; and expects your shared PDO connection to be available from that file.
This page expects includes/fourps-nav.php to be a partial include and loads it with require __DIR__ . '/includes/fourps-nav.php';
This page checks for either base table names or fourps_* table names and looks for alternate column names before showing information.
| Area | Resolved Table | Status | Rows |
|---|---|---|---|
| Customers | customers | Found | 1 |
| Properties | properties | Found | 1 |
| Plans | plans | Found | 1 |
| Inspections | inspections | Found | 8 |
| Inspection Items | inspection_items | Found | 90 |
| Claims | claims | Found | 1 |
| Claim Items | claim_items | Found | 1 |
| Invoices | invoices | Found | 1 |
| Payments | payments | Found | 1 |
| Table | Check | Resolved Column |
|---|---|---|
| customers | Customer name column | Not found |
| customers | Customer email column | |
| properties | Property customer link | customer_id |
| properties | Property address column | Not found |
| plans | Plan customer link | customer_id |
| plans | Plan property link | property_id |
| claims | Claim customer link | customer_id |
| claims | Claim amount column | Not found |
| invoices | Invoice total column | total_amount |
| invoices | Invoice balance column | balance_due |
| payments | Payment amount column | amount |
| payments | Payment invoice link | invoice_id |