Maintenance tools overview for data readiness, file checks, schema review, and operational cleanup planning in 4 P’s.
Back up the database and copy the current PHP files before replacing or adding multiple pages.
Run system-status.php, audit.php, and reports.php to confirm the tables, columns, and linked records are still healthy.
Check which alternate column names are being detected so pages do not silently stop showing data.
If a detail page shows record not found, verify the record id in the URL and confirm the table actually contains that id.
These pages are written for the main 4 P’s app folder, not an /admin subfolder, unless they are rewritten for new relative paths.
Use audit.php to catch records that lost customer, property, plan, inspection, claim, invoice, or payment links.
| File | Path | Status |
|---|---|---|
| DB connection file | /home/truslsca/4psplatform.com/app/db.php | Found |
| Navigation include | /home/truslsca/4psplatform.com/includes/fourps-nav.php | Found |
| Main dashboard file | /home/truslsca/4psplatform.com/fourps-dashboard.php | Found |
| Reports page | /home/truslsca/4psplatform.com/reports.php | Found |
| Search page | /home/truslsca/4psplatform.com/search.php | Found |
| Audit page | /home/truslsca/4psplatform.com/audit.php | Found |
| System status page | /home/truslsca/4psplatform.com/system-status.php | Found |
| Area | Resolved Table | Rows | Status |
|---|---|---|---|
| Customers | customers | 1 | Ready |
| Properties | properties | 1 | Ready |
| Plans | plans | 1 | Ready |
| Inspections | inspections | 8 | Ready |
| Inspection Items | inspection_items | 90 | Ready |
| Claims | claims | 1 | Ready |
| Claim Items | claim_items | 1 | Ready |
| Invoices | invoices | 1 | Ready |
| Payments | payments | 1 | Ready |
| Check | Count | Status |
|---|---|---|
| Properties without customer | 0 | OK |
| Plans without customer | 0 | OK |
| Plans without property | 0 | OK |
| Claims without customer | 0 | OK |
| Claims without property | 0 | OK |
| Claims without plan | 0 | OK |
| Claims without inspection | 0 | OK |
| Invoices without customer | 0 | OK |
| Invoices without property | 0 | OK |
| Invoices without claim | 0 | OK |
| Payments without invoice | 0 | OK |