System

Activity Log

Unified timeline of data changes (saves, imports, deletes) and backend errors. Filter by type, area, severity, or search.

Errors only Changes only Backend Home
Data changes (total)1,202
Errors (total)273,133
Today · changes173
Today · errors102,039
Reset

274,335 results · Page 5480 of 5487

cust_email · send_email
2026-04-21 13:17:31 · anonymous · /backend/cust_email.php?ok=emailed
change
review_request #20
Context 
[]
Before 
[]
After 
{"customer_id":148013,"visit_id":129055,"email":"carol.massote89@gmail.com","status":"sent","delivery_result":"Sent via SMTP (PHPMailer)"}
cust_email · send_email
2026-04-21 13:17:17 · anonymous · /backend/cust_email.php?ok=emailed
change
review_request #19
Context 
[]
Before 
[]
After 
{"customer_id":3541,"visit_id":129350,"email":"tdosu15@gmail.com","status":"sent","delivery_result":"Sent via SMTP (PHPMailer)"}
cust_email · send_email
2026-04-21 13:17:00 · anonymous · /backend/cust_email.php?ok=emailed
change
review_request #18
Context 
[]
Before 
[]
After 
{"customer_id":448245,"visit_id":129052,"email":"tiffanyverner@yahoo.com","status":"sent","delivery_result":"Sent via SMTP (PHPMailer)"}
cust_email · send_email
2026-04-21 13:16:45 · anonymous · /backend/cust_email.php?ok=emailed
change
review_request #17
Context 
[]
Before 
[]
After 
{"customer_id":488969,"visit_id":128963,"email":"tracynightwatch@gmail.com","status":"sent","delivery_result":"Sent via SMTP (PHPMailer)"}
cust_email · send_email
2026-04-21 13:16:36 · anonymous · /backend/cust_email.php?ok=emailed
change
review_request #16
Context 
[]
Before 
[]
After 
{"customer_id":489081,"visit_id":129390,"email":"unichen620@gmail.com","status":"sent","delivery_result":"Sent via SMTP (PHPMailer)"}
cust_email · send_email
2026-04-21 13:16:28 · anonymous · /backend/cust_email.php?ok=sent
change
review_request #15
Context 
[]
Before 
[]
After 
{"customer_id":430,"visit_id":129414,"email":"vgonzalez-saez@hotmail.com","status":"sent","delivery_result":"Sent via SMTP (PHPMailer)"}
cust_email · mark_sent
2026-04-21 13:16:20 · anonymous · /backend/cust_email.php?ok=emailed
change
review_request #14
Context 
[]
Before 
[]
After 
{"customer_id":3423,"visit_id":129041,"email":"laurawhitney02@gmail.com","status":"sent"}
cust_email · send_email
2026-04-21 13:16:12 · anonymous · /backend/cust_email.php?ok=emailed
change
review_request #13
Context 
[]
Before 
[]
After 
{"customer_id":200478,"visit_id":129013,"email":"wneifa@gmail.com","status":"sent","delivery_result":"Sent via SMTP (PHPMailer)"}
cust_email · send_email
2026-04-21 13:16:04 · anonymous · /backend/cust_email.php?ok=emailed
change
review_request #12
Context 
[]
Before 
[]
After 
{"customer_id":429500,"visit_id":129398,"email":"martin110406@sbcglobal.net","status":"sent","delivery_result":"Sent via SMTP (PHPMailer)"}
cust_email · send_email
2026-04-21 13:15:56 · anonymous · /backend/cust_email.php?ok=emailed
change
review_request #11
Context 
[]
Before 
[]
After 
{"customer_id":3534,"visit_id":129329,"email":"zuheily2001@gmail.com","status":"sent","delivery_result":"Sent via SMTP (PHPMailer)"}
cust_email · send_email
2026-04-21 13:15:46 · anonymous · /backend/cust_email.php?ok=emailed
change
review_request #10
Context 
[]
Before 
[]
After 
{"customer_id":200479,"visit_id":129016,"email":"wbrittney89@ymail.com","status":"sent","delivery_result":"Sent via SMTP (PHPMailer)"}
cust_email · send_email
2026-04-21 13:15:40 · anonymous · /backend/cust_email.php?ok=emailed
change
review_request #9
Context 
[]
Before 
[]
After 
{"customer_id":489005,"visit_id":129410,"email":"nanafrog24@gmail.com","status":"sent","delivery_result":"Sent via SMTP (PHPMailer)"}
cust_email · send_email
2026-04-21 13:15:28 · anonymous · /backend/cust_email.php?ok=sent
change
review_request #8
Context 
[]
Before 
[]
After 
{"customer_id":40315,"visit_id":5504,"email":"bethakirby61@gmail.com","status":"sent","delivery_result":"Sent via SMTP (PHPMailer)"}
cust_email · mark_sent
2026-04-21 13:15:16 · anonymous · /backend/cust_email.php?ok=sent
change
review_request #7
Context 
[]
Before 
[]
After 
{"customer_id":3532,"visit_id":128985,"email":"barbieb84@gmail.fom","status":"sent"}
cust_email · mark_sent
2026-04-21 13:15:10 · anonymous · /backend/cust_email.php?ok=emailed
change
review_request #6
Context 
[]
Before 
[]
After 
{"customer_id":448253,"visit_id":129411,"email":"annemr0229@gmail.com","status":"sent"}
cust_email · send_email
2026-04-21 13:14:54 · anonymous · /backend/cust_email.php?ok=emailed
change
review_request #5
Context 
[]
Before 
[]
After 
{"customer_id":3503,"visit_id":129045,"email":"angiedelossantos742@gmail.com","status":"sent","delivery_result":"Sent via SMTP (PHPMailer)"}
cust_email · send_email
2026-04-21 13:13:35 · anonymous · /backend/cust_email.php?ok=sent
change
review_request #4
Context 
[]
Before 
[]
After 
{"customer_id":200481,"visit_id":34954,"email":"aodonahoe@gmail.com","status":"sent","delivery_result":"Sent via SMTP (PHPMailer)"}
cust_email · mark_sent
2026-04-21 13:13:23 · anonymous · /backend/cust_email.php
change
review_request #3
Context 
[]
Before 
[]
After 
{"customer_id":148003,"visit_id":22301,"email":"kimberlymatt2017@gmail.com","status":"sent"}
cust_email.php
2026-04-21 12:48:19 · anonymous · /backend/cust_email.php
error
app_log_backend_change(): Argument #6 ($before) must be of type array, null given, called in /mnt/drive3/customerdb/backend/cust_email_service.php on line 687
Script: /mnt/drive3/customerdb/webui/backend/cust_email.php
IP: 192.168.7.27
Context 
{"mode":"mark_sent","type":"TypeError","file":"/mnt/drive3/customerdb/backend/bootstrap.php","line":434,"trace":"#0 /mnt/drive3/customerdb/backend/cust_email_service.php(687): app_log_backend_change()\n#1 /mnt/drive3/customerdb/backend/cust_email.php(25): app_review_request_mark_sent()\n#2 /mnt/drive3/customerdb/webui/backend/cust_email.php(5): require('...')\n#3 {main}"}
cust_email_service.php
2026-04-21 12:16:30 · anonymous · /backend/cust_email.php?ok=test_sent&email=peterdixon5775%40outlook.com&tab=ready
error
Unmatched '}'
Script: /mnt/drive3/customerdb/webui/backend/cust_email.php
IP: 192.168.7.27
Context 
{"type":"ParseError","file":"/mnt/drive3/customerdb/backend/cust_email_service.php","line":124,"trace":"#0 /mnt/drive3/customerdb/webui/backend/cust_email.php(5): require()\n#1 {main}"}
cust_email.php
2026-04-21 12:03:58 · anonymous · /backend/cust_email.php
error
Syntax error
Script: /mnt/drive3/customerdb/webui/backend/cust_email.php
IP: 192.168.7.27
Context 
{"mode":"import_customers","type":"JsonException","file":"/mnt/drive3/customerdb/backend/cust_email.php","line":101,"trace":"#0 /mnt/drive3/customerdb/backend/cust_email.php(101): json_decode()\n#1 /mnt/drive3/customerdb/webui/backend/cust_email.php(5): require('...')\n#2 {main}"}
cust_email.php
2026-04-21 12:03:04 · anonymous · /backend/cust_email.php
error
Syntax error
Script: /mnt/drive3/customerdb/webui/backend/cust_email.php
IP: 192.168.7.27
Context 
{"mode":"import_customers","type":"JsonException","file":"/mnt/drive3/customerdb/backend/cust_email.php","line":101,"trace":"#0 /mnt/drive3/customerdb/backend/cust_email.php(101): json_decode()\n#1 /mnt/drive3/customerdb/webui/backend/cust_email.php(5): require('...')\n#2 {main}"}
bills.php
2026-04-21 11:53:09 · admin@ellasalterations.com · /backend/bills.php
error
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CONFLICT(year, month, bills_account_id) DO UPDATE SET op...' at line 3
Script: /mnt/drive3/customerdb/webui/backend/bills.php
IP: 192.168.7.27
Context 
{"type":"mysqli_sql_exception","file":"/mnt/drive3/customerdb/backend/bills.php","line":19,"trace":"#0 /mnt/drive3/customerdb/backend/bills.php(19): mysqli->prepare()\n#1 /mnt/drive3/customerdb/backend/bills.php(246): dbQuery()\n#2 /mnt/drive3/customerdb/webui/backend/bills.php(5): require('...')\n#3 {main}"}
bills.php
2026-04-21 11:53:04 · admin@ellasalterations.com · /backend/bills.php
error
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CONFLICT(year, month, bills_item_id) DO UPDATE SET payment_d...' at line 3
Script: /mnt/drive3/customerdb/webui/backend/bills.php
IP: 192.168.7.27
Context 
{"type":"mysqli_sql_exception","file":"/mnt/drive3/customerdb/backend/bills.php","line":19,"trace":"#0 /mnt/drive3/customerdb/backend/bills.php(19): mysqli->prepare()\n#1 /mnt/drive3/customerdb/backend/bills.php(378): dbQuery()\n#2 /mnt/drive3/customerdb/webui/backend/bills.php(5): require('...')\n#3 {main}"}
bills.php
2026-04-21 11:53:04 · admin@ellasalterations.com · /backend/bills.php
error
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CONFLICT(year, month, bills_item_id) DO UPDATE SET payment_d...' at line 3
Script: /mnt/drive3/customerdb/webui/backend/bills.php
IP: 192.168.7.27
Context 
{"type":"mysqli_sql_exception","file":"/mnt/drive3/customerdb/backend/bills.php","line":19,"trace":"#0 /mnt/drive3/customerdb/backend/bills.php(19): mysqli->prepare()\n#1 /mnt/drive3/customerdb/backend/bills.php(378): dbQuery()\n#2 /mnt/drive3/customerdb/webui/backend/bills.php(5): require('...')\n#3 {main}"}
bills.php
2026-04-21 11:53:03 · admin@ellasalterations.com · /backend/bills.php
error
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CONFLICT(year, month, bills_item_id) DO UPDATE SET payment_d...' at line 3
Script: /mnt/drive3/customerdb/webui/backend/bills.php
IP: 192.168.7.27
Context 
{"type":"mysqli_sql_exception","file":"/mnt/drive3/customerdb/backend/bills.php","line":19,"trace":"#0 /mnt/drive3/customerdb/backend/bills.php(19): mysqli->prepare()\n#1 /mnt/drive3/customerdb/backend/bills.php(378): dbQuery()\n#2 /mnt/drive3/customerdb/webui/backend/bills.php(5): require('...')\n#3 {main}"}
bills.php
2026-04-21 11:48:20 · admin@ellasalterations.com · /backend/bills.php
error
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CONFLICT(year, month, bills_account_id) DO UPDATE SET op...' at line 3
Script: /mnt/drive3/customerdb/webui/backend/bills.php
IP: 192.168.7.27
Context 
{"type":"mysqli_sql_exception","file":"/mnt/drive3/customerdb/backend/bills.php","line":19,"trace":"#0 /mnt/drive3/customerdb/backend/bills.php(19): mysqli->prepare()\n#1 /mnt/drive3/customerdb/backend/bills.php(246): dbQuery()\n#2 /mnt/drive3/customerdb/webui/backend/bills.php(5): require('...')\n#3 {main}"}
bills.php
2026-04-21 11:48:18 · admin@ellasalterations.com · /backend/bills.php
error
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CONFLICT(year, month, bills_item_id) DO UPDATE SET payment_d...' at line 3
Script: /mnt/drive3/customerdb/webui/backend/bills.php
IP: 192.168.7.27
Context 
{"type":"mysqli_sql_exception","file":"/mnt/drive3/customerdb/backend/bills.php","line":19,"trace":"#0 /mnt/drive3/customerdb/backend/bills.php(19): mysqli->prepare()\n#1 /mnt/drive3/customerdb/backend/bills.php(378): dbQuery()\n#2 /mnt/drive3/customerdb/webui/backend/bills.php(5): require('...')\n#3 {main}"}
cust_email.php
2026-04-21 11:31:22 · anonymous · /backend/cust_email.php
error
Call to undefined function app_log_change()
Script: /mnt/drive3/customerdb/webui/backend/cust_email.php
IP: 192.168.7.27
Context 
{"mode":"send_email","type":"Error","file":"/mnt/drive3/customerdb/backend/cust_email_service.php","line":277,"trace":"#0 /mnt/drive3/customerdb/backend/cust_email.php(20): app_review_request_send_email()\n#1 /mnt/drive3/customerdb/webui/backend/cust_email.php(5): require('...')\n#2 {main}"}
live_table_manager · update
2026-04-20 16:37:23 · anonymous · /backend/live_table_manager.php?table=customer_payment_transactions&edit=6112&q=
change
customer_payment_transactions #6112
Context 
[]
Before 
{"customer_payment_transaction_id":"6112","payment_id":"64091","order_id":"104165","visit_id":"129412","customer_id":"148006","customer_name":"Alison Belletete","transaction_date":"2026-04-20 00:00:00","payment_method":"Cash","payment_type":"Deposit","bucket":"cash","amount":"100.00","tip_amount":"0.00","is_new_customer":"0","source":"payments","created_at":"2026-04-20 16:35:33","updated_at":"2026-04-20 16:35:33"}
After 
{"customer_payment_transaction_id":"6112","payment_id":"64091","order_id":"104165","visit_id":"129412","customer_id":"148006","customer_name":"Alison Belletete","transaction_date":"2026-04-20 00:00:00","payment_method":"Cash","payment_type":"Payment","bucket":"cash","amount":"270.00","tip_amount":"0.00","is_new_customer":"0","source":"payments","created_at":"2026-04-20 16:35:00","updated_at":"2026-04-20 16:35:00"}
live_table_manager · delete
2026-04-20 16:36:50 · anonymous · /backend/live_table_manager.php?table=customer_payment_transactions&q=&ok=deleted
change
customer_payment_transactions #6113
Context 
[]
Before 
{"customer_payment_transaction_id":"6113","payment_id":"64092","order_id":"104165","visit_id":"129412","customer_id":"148006","customer_name":"Alison Belletete","transaction_date":"2026-04-20 00:00:00","payment_method":"Cash","payment_type":"Balance","bucket":"cash","amount":"270.00","tip_amount":"0.00","is_new_customer":"0","source":"payments","created_at":"2026-04-20 16:35:33","updated_at":"2026-04-20 16:35:33"}
After 
{"deleted":true}
live_table_manager · delete
2026-04-20 16:36:44 · anonymous · /backend/live_table_manager.php?table=customer_payment_transactions&edit=6115&ok=saved
change
customer_payment_transactions #6114
Context 
[]
Before 
{"customer_payment_transaction_id":"6114","payment_id":"64093","order_id":"104165","visit_id":"129412","customer_id":"148006","customer_name":"Alison Belletete","transaction_date":"2026-04-20 00:00:00","payment_method":"Cash","payment_type":"Tip","bucket":"tip","amount":"69.20","tip_amount":"69.20","is_new_customer":"0","source":"payments","created_at":"2026-04-20 16:35:33","updated_at":"2026-04-20 16:35:33"}
After 
{"deleted":true}
live_table_manager · update
2026-04-20 16:36:35 · anonymous · /backend/live_table_manager.php?table=customer_payment_transactions&edit=6115&q=
change
customer_payment_transactions #6115
Context 
[]
Before 
{"customer_payment_transaction_id":"6115","payment_id":"64094","order_id":"104165","visit_id":"129412","customer_id":"148006","customer_name":"Alison Belletete","transaction_date":"2026-04-20 00:00:00","payment_method":"Cash","payment_type":"Deposit","bucket":"cash","amount":"170.00","tip_amount":"0.00","is_new_customer":"0","source":"payments","created_at":"2026-04-20 16:35:33","updated_at":"2026-04-20 16:35:33"}
After 
{"customer_payment_transaction_id":"6115","payment_id":"64094","order_id":"104165","visit_id":"129412","customer_id":"148006","customer_name":"Alison Belletete","transaction_date":"2026-04-20 00:00:00","payment_method":"Cash","payment_type":"Deposit","bucket":"cash","amount":"100.00","tip_amount":"0.00","is_new_customer":"0","source":"payments","created_at":"2026-04-20 16:35:00","updated_at":"2026-04-20 16:35:00"}
documents · upload
2026-04-20 14:36:27 · anonymous · /backend/documents.php
change
backend_document #23
Context 
{"file_name":"ESSENTIAL_FILES_ANALYSIS.md","mime_type":"application/octet-stream"}
Before 
[]
After 
{"backend_document_id":"23","document_type":"upload","title":"All Essential Files for Customer DB","slug":"all-essential-files-for-customer-db","summary_text":"All Essential Files for Customer DB","content_markdown":null,"content_html":null,"file_name":"ESSENTIAL_FILES_ANALYSIS.md","stored_name":"20260420-183627-ab045aa6.md","mime_type":"application/octet-stream","file_size_bytes":"9785","storage_path":"/mnt/drive1/customerdb/backend/documents_storage/20260420-183627-ab045aa6.md","is_deleted":"0","created_at":"2026-04-20 14:36:27","updated_at":"2026-04-20 14:36:27","editor_content":"# Essential Files Analysis - C:\\code\\customerdb\n\n**Generated:** April 17, 2026\n\n---\n\n## Summary\n\nThis document identifies which files are essential to keep vs which can be safely removed to reduce disk usage and simplify the codebase.\n\n**Estimated Space Savings:** ~200+ MB\n\n---\n\n## KEEP - Essential Files\n\n### Core Application\n\n```\nC:\\code\\customerdb\\backend\\           # Main PHP backend (98 files)\nC:\\code\\customerdb\\frontend\\          # Front Desk app (15 HTML pages)\nC:\\code\\customerdb\\frontend\\api\\       # Frontend API endpoints\nC:\\code\\customerdb\\scripts\\           # Import/sync scripts\nC:\\code\\customerdb\\migrations\\         # SQL migrations\nC:\\code\\customerdb\\csv\\               # Active CSV data\nC:\\code\\customerdb\\docs\\             # Documentation\nC:\\code\\customerdb\\backups\\           # Database backups (prune old)\nC:\\code\\customerdb\\mariadb_core_schema.sql\nC:\\code\\customerdb\\backup.sh\n```\n\n### Backend - Essential Files (98 PHP files)\n\n| File | Purpose |\n|------|---------|\n| `bootstrap.php` | Core bootstrap |\n| `customer_service.php` | Customer management |\n| `customer.php` | Customer API |\n| `visit_service.php` | Visit records |\n| `visit.php` | Visit API |\n| `customer_totals_service.php` | Daily totals |\n| `report_service.php` | Reporting (80KB) |\n| `schedule.php` | Appointment scheduling |\n| `setmore_service.php` | Setmore integration |\n| `email_service.php` | Email handling |\n| `bank_service.php` | Banking |\n| `gold_silver_service.php` | Precious metals |\n| `duke_service.php` | Energy tracking |\n| `payroll_service.php` | Payroll |\n| `stocks_crypto_service.php` | Investments |\n| `medication_service.php` | Medication tracking |\n| `backup_database_service.php` | Database backup |\n| `cron_manager.php` | Cron management |\n| `nightly_reports_service.php` | Nightly reports |\n| `morning_jobs_service.php` | Morning batch jobs |\n| `square_terminal_service.php` | Square POS |\n| `live_table_manager_service.php` | Live data tables |\n| `notifications_service.php` | Notifications |\n\n**API Endpoints:** 58 files in `/backend/api/` - all active REST endpoints\n\n### Frontend - HTML Pages (15 files)\n\n| File | Purpose |\n|------|---------|\n| `visit.html` | Visit management (254KB) |\n| `customer.html` | Customer records |\n| `index.html` | Main dashboard |\n| `reports.html` | Reports viewer |\n| `schedule.html` | Schedule view |\n| `work_order.html` | Work orders |\n| `workload.html` | Workload view |\n| `receipt.html` | Receipt printing |\n| `login.html` | Authentication |\n| `upcoming.html` | Upcoming appointments |\n| `square_customer.html` | Square integration |\n| `item_types.html` | Item types |\n| `todo.html` | Todo lists |\n| `customer_display.html` | Customer display |\n\n### Scripts - Essential (7 files)\n\n| Script | Purpose |\n|--------|---------|\n| `import_csv_v2.py` | CSV import |\n| `import_access_v2.py` | Access DB import |\n| `access_to_mariadb_parser.py` | Access parser |\n| `import_legacy_totals_from_excel.ps1` | Excel import |\n| `sync_backend_mirror.ps1` | Mirror sync |\n| `check_backend_mirror.ps1` | Mirror check |\n| `signature_blob_loader.py` | Signature loader |\n\n### Migrations - Essential (3 files)\n\n| File | Purpose |\n|------|---------|\n| `20260407_add_conversion_job.sql` | Conversion job table |\n| `20260411_order_items_item_type_name_no_fk.sql` | Item type changes |\n| `20260416_blog_prompt_templates.sql` | Blog prompts |\n\n### CSV Data - Essential\n\n| File | Purpose |\n|------|---------|\n| `CustomerTable.csv` | Customer records |\n| `CustomerVisits.csv` | Visit records |\n| `CustomerTotals.csv` | Daily totals |\n| `AlterationItems.csv` | Alteration items |\n\n---\n\n## REMOVE - Redundant/Unused Files\n\n### Priority 1 - Safe to Delete (Complete Directories)\n\n| Directory | Size | Action |\n|-----------|------|--------|\n| `notused\\` | ~85 MB | DELETE ENTIRE |\n| `venv\\` | ~100 MB | DELETE ENTIRE |\n| `OldFiles\\` | ~1 MB | DELETE ENTIRE |\n| `.vs\\` | ~1 MB | DELETE ENTIRE |\n| `.vscode\\` | small | DELETE |\n\n#### notused/ Contents (DELETE ALL)\n```\nnotused\\access_to_mariadb_parser (1).py   # duplicates\nnotused\\access_to_mariadb_parser (2).py   # duplicates\nnotused\\customerdb_v2_staging_schema.sql  # duplicate\nnotused\\mariadb_core_schema.sql          # duplicate\nnotused\\mariadb-12.2.2-winx64.msi        # MariaDB installer (89MB!)\nnotused\\Backend\\                         # old PHP code\nnotused\\backups\\                         # old backups\nnotused\\csv\\                           # old CSVs\nnotused\\docs\\                          # old docs\nnotused\\schema\\                        # old schemas\nnotused\\scripts\\                      # old scripts\nnotused\\webui\\                        # old webui\n```\n\n### Priority 2 - Duplicate WebUI (Check First)\n\n| Directory | Purpose |\n|-----------|---------|\n| `webui\\` | ~15 MB - mirrors backend/frontend |\n\nThis directory appears to mirror the main `backend/` and `frontend/` directories. If `webui` is NOT served as a separate application, DELETE ENTIRE:\n\n```\nwebui\\backend\\         # 89 files - duplicate of ../backend/\nwebui\\frontend\\       # mirrors ../frontend/\nwebui\\api\\           # similar to ../frontend/api/\n```\n\n### Priority 3 - Temporary Files\n\nDelete all files matching patterns:\n```\ntmp_*.php     (~30 files)  # temp PHP scripts\ntmp_*.sql     (~30 files)  # temp SQL queries\ntmp_*.sh      (1 file)    # temp shell scripts\ntmp_*.csv     (1 file)    # temp CSV files\n```\n\nExamples:\n- `tmp_check_129411.sql`\n- `tmp_nightly_preview.php`\n- `tmp_compare_sheet_customer_totals.sql`\n- `tmp_mirror_drive.sh`\n- `tmp_customertotalsaccess.csv`\n\n### Priority 4 - Check Before Delete\n\n| Directory | Purpose | Action |\n|-----------|---------|--------|\n| `blog\\` | Blog module | Verify if used, else DELETE |\n| `Topaz\\` | Signature pad drivers | Verify if needed, else DELETE |\n| `wordpress-plugin\\` | WP integration | Verify if used, else DELETE |\n| `schedule\\` | Laravel scheduling app | Verify if integrated, else DELETE |\n| `csv\\back\\` | 8 backup CSVs | Likely duplicate, verify then DELETE |\n\n### Priority 5 - Backup Files\n\n| File Pattern | Action |\n|-------------|--------|\n| `*.bak_*` | DELETE |\n| `*.bak` | DELETE |\n| `*.backup` | DELETE |\n| `*~` | DELETE |\n\n### Priority 6 - Root Level Large Unused Files\n\n| File | Size | Action |\n|------|------|--------|\n| `Items To Test or Comlete.odt` | 26KB | Move to docs or DELETE |\n\n---\n\n## Directory Structure After Cleanup\n\n```\ncustomerdb/\n├── backend/                    # KEEP - Main PHP backend\n│   ├── api/                    # KEEP - API endpoints\n│   ├── jobs/                   # KEEP - Cron jobs\n│   └── bin/                    # KEEP - Binaries\n├── frontend/                   # KEEP - Front Desk app\n│   ├── api/                   # KEEP - API calls\n│   └── reports/               # KEEP - PDF reports\n├── scripts/                   # KEEP - Import scripts\n├── migrations/                 # KEEP - DB migrations\n├── csv/                       # KEEP - Active data\n│   └── back/                 # DELETE - backup copies\n├── docs/                      # KEEP - Documentation\n├── backups/                   # KEEP - Keep latest, prune old\n├── schema/                   # KEEP or DELETE (empty)\n├── mariadb_core_schema.sql        # KEEP - Core schema\n├── migrate_add_visit_type.sql   # KEEP - Migration\n├── backup.sh                # KEEP - Backup script\n├── .gitignore              # KEEP\n│\n├── notused/                 # DELETE ENTIRE (~85 MB)\n├── OldFiles/               # DELETE ENTIRE (~1 MB)\n├── .vs/                    # DELETE (~1 MB)\n├── .vscode/                # DELETE\n├── venv/                   # DELETE (~100 MB)\n├── webui/                  # DELETE OR VERIFY FIRST\n├── blog/                   # VERIFY - then delete\n├── Topaz/                  # VERIFY - then delete\n├── wordpress-plugin/        # VERIFY - then delete\n├── schedule/               # VERIFY - then delete\n└── tmp_*.*                 # DELETE ALL (~2 MB)\n```\n\n---\n\n## Space Savings Summary\n\n| Category | Savings |\n|----------|----------|\n| `notused/` directory | ~85 MB |\n| `venv/` directory | ~100 MB |\n| `tmp_*` files | ~2 MB |\n| `OldFiles/` | ~1 MB |\n| `.vs`, `.vscode` | ~1 MB |\n| `webui/` (if duplicate) | ~15 MB |\n| `csv/back/` | ~2 MB |\n| **TOTAL** | **~200+ MB** |\n\n---\n\n## Commands to Remove Files\n\n### PowerShell - Delete Priority 1 (Safe to Delete)\n\n```powershell\n# Delete notused directory\nRemove-Item -Recurse -Force \"C:\\code\\customerdb\\notused\"\n\n# Delete OldFiles directory\nRemove-Item -Recurse -Force \"C:\\code\\customerdb\\OldFiles\"\n\n# Delete .vs directory\nRemove-Item -Recurse -Force \"C:\\code\\customerdb\\.vs\"\n\n# Delete .vscode directory\nRemove-Item -Recurse -Force \"C:\\code\\customerdb\\.vscode\"\n\n# Delete venv directory\nRemove-Item -Recurse -Force \"C:\\code\\customerdb\\venv\"\n```\n\n### PowerShell - Delete Temporary Files\n\n```powershell\n# Delete all tmp_* files in root\nGet-ChildItem \"C:\\code\\customerdb\" -Filter \"tmp_*\" | Remove-Item -Force\n\n# Delete backup files\nGet-ChildItem \"C:\\code\\customerdb\" -Filter \"*.bak*\" | Remove-Item -Force\n```\n\n### PowerShell - Delete Duplicate WebUI (After Verification)\n\n```powershell\n# Only run if webui is NOT served separately\nRemove-Item -Recurse -Force \"C:\\code\\customerdb\\webui\"\n```\n\n---\n\n## Verification Checklist Before Delete\n\n- [ ] **webui/** - Is port 8894 served from this directory? If yes, KEEP. If served from `backend/`, DELETE.\n- [ ] **blog/** - Is blog feature actively used in the application?\n- [ ] **Topaz/** - Is the Topaz signature pad still in use?\n- [ ] **wordpress-plugin/** - Is WordPress integration still active?\n- [ ] **schedule/** - Is the Laravel scheduling app still integrated?\n\n---\n\n*End of Analysis*","is_text_editable":1,"can_edit_inline":1}
tabby_terminal.php
2026-04-20 14:29:30 · anonymous · /backend/tabby_terminal.php
error
Call to undefined function app_settings_map()
Script: /mnt/drive1/customerdb/webui/backend/tabby_terminal.php
IP: 192.168.7.66
Context 
{"type":"Error","file":"/mnt/drive1/customerdb/backend/tabby_terminal.php","line":15,"trace":"#0 /mnt/drive1/customerdb/webui/backend/tabby_terminal.php(5): require()\n#1 {main}"}
tabby_terminal.php
2026-04-20 14:28:22 · anonymous · /backend/tabby_terminal.php
error
Call to undefined function app_settings_map()
Script: /mnt/drive1/customerdb/webui/backend/tabby_terminal.php
IP: 34.203.10.131
Context 
{"type":"Error","file":"/mnt/drive1/customerdb/backend/tabby_terminal.php","line":15,"trace":"#0 /mnt/drive1/customerdb/webui/backend/tabby_terminal.php(5): require()\n#1 {main}"}
tabby_terminal.php
2026-04-20 14:28:20 · anonymous · /backend/tabby_terminal.php
error
Call to undefined function app_settings_map()
Script: /mnt/drive1/customerdb/webui/backend/tabby_terminal.php
IP: 34.203.10.131
Context 
{"type":"Error","file":"/mnt/drive1/customerdb/backend/tabby_terminal.php","line":15,"trace":"#0 /mnt/drive1/customerdb/webui/backend/tabby_terminal.php(5): require()\n#1 {main}"}
tabby_terminal.php
2026-04-20 14:28:19 · anonymous · /backend/tabby_terminal.php
error
Call to undefined function app_settings_map()
Script: /mnt/drive1/customerdb/webui/backend/tabby_terminal.php
IP: 34.203.10.131
Context 
{"type":"Error","file":"/mnt/drive1/customerdb/backend/tabby_terminal.php","line":15,"trace":"#0 /mnt/drive1/customerdb/webui/backend/tabby_terminal.php(5): require()\n#1 {main}"}
tabby_terminal.php
2026-04-20 14:28:19 · anonymous · /backend/tabby_terminal.php
error
Call to undefined function app_settings_map()
Script: /mnt/drive1/customerdb/webui/backend/tabby_terminal.php
IP: 34.203.10.131
Context 
{"type":"Error","file":"/mnt/drive1/customerdb/backend/tabby_terminal.php","line":15,"trace":"#0 /mnt/drive1/customerdb/webui/backend/tabby_terminal.php(5): require()\n#1 {main}"}
tabby_terminal.php
2026-04-20 14:28:16 · anonymous · /backend/tabby_terminal.php
error
Call to undefined function app_settings_map()
Script: /mnt/drive1/customerdb/webui/backend/tabby_terminal.php
IP: 34.203.10.131
Context 
{"type":"Error","file":"/mnt/drive1/customerdb/backend/tabby_terminal.php","line":15,"trace":"#0 /mnt/drive1/customerdb/webui/backend/tabby_terminal.php(5): require()\n#1 {main}"}
tabby_terminal.php
2026-04-20 14:28:15 · anonymous · /backend/tabby_terminal.php
error
Call to undefined function app_settings_map()
Script: /mnt/drive1/customerdb/webui/backend/tabby_terminal.php
IP: 34.203.10.131
Context 
{"type":"Error","file":"/mnt/drive1/customerdb/backend/tabby_terminal.php","line":15,"trace":"#0 /mnt/drive1/customerdb/webui/backend/tabby_terminal.php(5): require()\n#1 {main}"}
tabby_terminal.php
2026-04-20 14:27:57 · anonymous · /backend/tabby_terminal.php
error
Call to undefined function app_settings_map()
Script: /mnt/drive1/customerdb/webui/backend/tabby_terminal.php
IP: 192.168.7.66
Context 
{"type":"Error","file":"/mnt/drive1/customerdb/backend/tabby_terminal.php","line":15,"trace":"#0 /mnt/drive1/customerdb/webui/backend/tabby_terminal.php(5): require()\n#1 {main}"}
schedule · create
2026-04-20 13:54:03 · admin@ellasalterations.com · /api/appointment_workflow.php
change
appointment_workflow #visit:129358
Context 
{"workflow_status":"no_show","visit_id":129358,"order_id":104111}
Before 
[]
After 
{"workflow_id":"9","source":"visit","source_key":"129358","appointment_date":"2026-04-20","customer_id":"489071","visit_id":"129358","order_id":null,"workflow_status":"no_show","payment_state":null,"payment_method":null,"payment_amount":"0.00","paid_in_advance":"0","report_required":"0","report_attached":"0","report_checked_at":"2026-04-20 13:54:02","provider_notes_text":null,"operator_notes":null,"no_show_email_key":"none","created_at":"2026-04-20 13:54:02","updated_at":"2026-04-20 13:54:02"}
customer_totals · create
2026-04-20 10:56:45 · anonymous · /backend/customer_totals.php
change
customer_totals #20323
Context 
[]
Before 
[]
After 
{"customer_date":"2026-04-20 14:55:00","customer_name":"Edwards","dopu_can":"Edwards","edwards":100,"edwards_type":"mileage","update_flag":"47"}
sysadmin.php
2026-04-19 16:28:30 · anonymous · /backend/api/sysadmin.php?action=backups_list&dir=customerdb-backup
error
DirectoryIterator::__construct(/mnt/drive1/customerdb-backup): Failed to open directory: No such file or directory
Script: /mnt/drive1/customerdb/webui/backend/api/sysadmin.php
IP: 192.168.7.35
Context 
{"type":"UnexpectedValueException","file":"/mnt/drive1/customerdb/webui/backend/api/sysadmin.php","line":290,"trace":"#0 /mnt/drive1/customerdb/webui/backend/api/sysadmin.php(290): DirectoryIterator->__construct()\n#1 {main}"}
schedule · create
2026-04-19 15:46:07 · admin@ellasalterations.com · /api/appointment_workflow.php
change
appointment_workflow #visit:129401
Context 
{"workflow_status":"no_show","visit_id":129401,"order_id":104154}
Before 
[]
After 
{"workflow_id":"8","source":"visit","source_key":"129401","appointment_date":"2026-04-19","customer_id":"3478","visit_id":"129401","order_id":null,"workflow_status":"no_show","payment_state":null,"payment_method":null,"payment_amount":"0.00","paid_in_advance":"0","report_required":"0","report_attached":"0","report_checked_at":"2026-04-19 15:46:07","provider_notes_text":null,"operator_notes":"Status: 3/23/2026 Drop Off","no_show_email_key":"none","created_at":"2026-04-19 15:46:07","updated_at":"2026-04-19 15:46:07"}
live_table_manager · delete
2026-04-19 13:19:54 · anonymous · /backend/live_table_manager.php?table=customer_payment_transactions&q=chevy&ok=deleted
change
customer_payment_transactions #5982
Context 
[]
Before 
{"customer_payment_transaction_id":"5982","payment_id":"63997","order_id":"104085","visit_id":"129332","customer_id":"489019","customer_name":"Chevy Stern","transaction_date":"2026-04-12 00:00:00","payment_method":"Square","payment_type":"Deposit","bucket":"credit","amount":"45.60","tip_amount":"0.00","is_new_customer":"0","source":"payments","created_at":"2026-04-19 13:15:17","updated_at":"2026-04-19 13:15:17"}
After 
{"deleted":true}
live_table_manager · delete
2026-04-19 13:19:49 · anonymous · /backend/live_table_manager.php?table=customer_payment_transactions&edit=5983&q=chevy
change
customer_payment_transactions #5983
Context 
[]
Before 
{"customer_payment_transaction_id":"5983","payment_id":"63998","order_id":"104085","visit_id":"129332","customer_id":"489019","customer_name":"Chevy Stern","transaction_date":"2026-04-12 00:00:00","payment_method":"Square","payment_type":"Deposit","bucket":"credit","amount":"40.00","tip_amount":"0.00","is_new_customer":"0","source":"payments","created_at":"2026-04-19 13:15:17","updated_at":"2026-04-19 13:15:17"}
After 
{"deleted":true}
live_table_manager · delete
2026-04-19 13:18:05 · anonymous · /backend/live_table_manager.php?table=customer_payment_transactions&q=chevy&ok=deleted
change
customer_payment_transactions #5984
Context 
[]
Before 
{"customer_payment_transaction_id":"5984","payment_id":"63999","order_id":"104085","visit_id":"129332","customer_id":"489019","customer_name":"Chevy Stern","transaction_date":"2026-04-12 00:00:00","payment_method":"Square","payment_type":"Balance","bucket":"credit","amount":"40.00","tip_amount":"0.00","is_new_customer":"0","source":"payments","created_at":"2026-04-19 13:15:17","updated_at":"2026-04-19 13:15:17"}
After 
{"deleted":true}
live_table_manager · delete
2026-04-19 13:17:53 · anonymous · /backend/live_table_manager.php?table=customer_payment_transactions&q=chevy
change
customer_payment_transactions #5985
Context 
[]
Before 
{"customer_payment_transaction_id":"5985","payment_id":"64000","order_id":"104085","visit_id":"129332","customer_id":"489019","customer_name":"Chevy Stern","transaction_date":"2026-04-12 00:00:00","payment_method":"Square","payment_type":"Tip","bucket":"tip","amount":"0.00","tip_amount":"0.00","is_new_customer":"0","source":"payments","created_at":"2026-04-19 13:15:17","updated_at":"2026-04-19 13:15:17"}
After 
{"deleted":true}
← Prev 1 … 5478 5479 5480 5481 5482 … 5487 Next →