System
Audit trail of every save, delete, import, and workflow update across the backend.
1,027 results · Page 1 of 21
{"document_type":"upload"}
{"backend_document_id":"25","document_type":"upload","title":"Codex - Documentation 04-25-2026","slug":"codex-documentation-04-25-2026","summary_text":"2026-04-25-codex-changes.md\r\nIt includes:\r\n\r\neverything created/updated/removed\r\ndatabase schema objects added\r\nDB data changes performed\r\nAPI endpoints/actions touched\r\nprocedures/functions and scripts added/changed\r\ncron/notification behavior\r\nvalidation performed today","content_markdown":null,"content_html":null,"file_name":"2026-04-25-codex-changes.md","stored_name":"20260425-182957-0b251cd7.md","mime_type":"application/octet-stream","file_size_bytes":"6092","storage_path":"/mnt/drive3/customerdb/backend/documents_storage/20260425-182957-0b251cd7.md","is_deleted":"0","created_at":"2026-04-25 18:29:57","updated_at":"2026-04-25 18:29:57","editor_content":"# CustomerDB Changes Log\nDate: 2026-04-25\nAuthor: Codex\n\n## Scope\nThis document summarizes all work completed today in this session, including created/updated/removed files, database schema objects introduced by code, API behaviors touched, and operational procedures/scripts added.\n\n## 1) Files Created\n- `backend/search_data_service.php`\n- `backend/search_data.php`\n- `webui/backend/search_data.php` (compatibility loader)\n- `webui/backend/search_data_service.php` (compatibility loader)\n- `/mnt/drive1/scripts/cleanup_customerdb_branches.sh` (runtime ops script; outside repo tree)\n\n## 2) Files Updated\n- `backend/module_service.php`\n- `backend/index.php`\n- `backend/page_helpers.php`\n- `webui/settings.html`\n- `backend/api/sysadmin.php`\n- `backend/sysadmin.php`\n- `backend/jobs/cron_runtime_service.php`\n- `backend/cron_manager.php`\n- `backend/search_data.php` (restyling updates for spreadsheet-like sections)\n- `backend/search_data_service.php` (provider detection/compat fixes)\n\n## 3) Files Removed\n- None.\n\n## 4) Database Schema Objects Added (by code)\nImplemented in `backend/search_data_service.php` via `app_install_search_data_schema(...)`:\n\n### Tables\n1. `backend_search_dataset`\n2. `backend_search_import_batch`\n3. `backend_search_dataset_field`\n4. `backend_search_data_row`\n\n### Indexes / Constraints (high level)\n- Unique dataset key by provider (`provider_name`, `dataset_key`)\n- Import batch indexes by dataset/status\n- Unique field key per dataset\n- Unique row identity hash per dataset\n- Analytical indexes on date/clicks/impressions\n\n## 5) Database Data Changes Performed Today\n- A cron job row was inserted in `cron_job`:\n - Label: `Cleanup Repo Branch Folders`\n - Schedule: `20 3 * * *`\n - Command: `bash /mnt/drive1/scripts/cleanup_customerdb_branches.sh`\n - Enabled: `1`\n- Search data smoke import was executed once in this environment for validation, which inserted dataset/import/data rows in the new search tables.\n\n## 6) New/Updated Backend Module\n### Module: Search Data Imports (`Bing / Google CSV + AI`)\n- New page: `backend/search_data.php`\n- New service: `backend/search_data_service.php`\n- Registered in backend module overview and dashboard card.\n- Added to module jump links and settings module visibility list.\n\n### Functional capabilities added\n- Adaptive CSV import for Google/Bing (and unknown/future providers).\n- Header evolution tracking (new columns are cataloged without code changes).\n- Batch import auditing (rows seen/inserted/updated/skipped).\n- Query context construction from imported tables.\n- Ollama-based AI question answering over imported data using existing settings:\n - `ollama_url`\n - `ollama_default_model`\n\n## 7) API Surface and Call Behavior Changes\n## Updated endpoint\n- `backend/api/sysadmin.php`\n\n### Updated actions\n1. `action=backups_list`\n - Added new `dir` key support:\n - `repo-branches` => `/mnt/drive3/customerdb_repo/branches`\n2. `action=backups_delete`\n - Previously file-only delete.\n - Now supports both file and folder delete.\n - Added safe recursive folder deletion with path-boundary checks.\n - Response now includes:\n - `deleted_type` (`file` or `folder`)\n\n### Existing actions used by UI (not newly created today, but part of touched API flow)\n- `logs_list`, `logs_read`, `logs_clear`\n- `scripts_list`, `scripts_read`, `scripts_save`, `scripts_run`, `scripts_notify_save`\n- `backups_list`, `backups_delete`\n\n## 8) Sysadmin UI Changes\nUpdated `backend/sysadmin.php`:\n- Backups tab now includes:\n - `customerdb_repo/branches/` source (`data-backupdir=\"repo-branches\"`)\n- Directory rows now include a `Delete Folder` button.\n- Delete handler updated to support file vs folder confirmation text.\n\n## 9) Cron / Ops Procedure Changes\n## Updated cron runtime service\nUpdated `backend/jobs/cron_runtime_service.php`:\n- Added constants:\n - `APP_BRANCH_CLEANUP_SCRIPT_PATH`\n - `APP_BRANCH_CLEANUP_TARGET_PATH`\n- Added helper:\n - `app_cron_ensure_branch_cleanup_script()`\n- `app_cron_migrate_command_paths(...)` now:\n - Ensures command normalization for `Cleanup Repo Branch Folders`\n - Ensures cleanup script exists on disk\n\n## Updated cron manager seeding\nUpdated `backend/cron_manager.php`:\n- Added seeded/ensured job:\n - `Cleanup Repo Branch Folders`\n - `20 3 * * *`\n - `bash /mnt/drive1/scripts/cleanup_customerdb_branches.sh`\n\n## Script created\n`/mnt/drive1/scripts/cleanup_customerdb_branches.sh`\n- Deletes first-level folders older than 5 days under:\n - `/mnt/drive3/customerdb_repo/branches`\n- Emits clear stdout status suitable for cron logs/notifications.\n\n## Notifications\nNo new notification channels were added.\nThe new cron job uses existing cron execution + notification flow:\n- Telegram (depending on settings)\n- Email (depending on settings)\n\n## 10) Jump-To-Module Improvements\nUpdated `backend/page_helpers.php`:\n- Jump dropdown list now sorted A-Z by label.\n- List expanded to include missing backend destinations.\n- Corrected invalid links for queue pages to existing routes:\n - `/upcoming.html`\n - `/workload.html`\n\n## 11) Styling/UI Updates Requested\nUpdated `backend/search_data.php`:\n- For sections:\n - `CSV Files`\n - `Dataset Totals`\n - `Recent Imports`\n- Removed rounded corners and applied spreadsheet-like flat table style (Excel-like grid presentation).\n\n## 12) Compatibility / Robustness Fixes Applied\nIn `backend/search_data_service.php`:\n- Added CSV parsing compatibility for `fgetcsv` escape parameter.\n- Replaced `mb_substr` with `substr` in one path to avoid missing extension errors in this environment.\n- Improved provider detection rules for Google export naming patterns:\n - `KeywordReport`\n - `PageTrafficReport`\n - `SearchPerformanceOverview`\n\n## 13) Validation Performed\n- PHP syntax checks (`php -l`) passed for all modified PHP files.\n- Search data smoke import executed successfully in this environment.\n- Verified script path existence after direct creation:\n - `/mnt/drive1/scripts/cleanup_customerdb_branches.sh`\n\n## 14) Notes\n- Existing unrelated local repo changes were not reverted.\n- No destructive git operations were used.\n","is_text_editable":1,"can_edit_inline":1}
{"backend_document_id":"25","document_type":"upload","title":"Subscription List - Auto Pay","slug":"subscription-list-auto-pay","summary_text":"Subscription List - Auto Pay","content_markdown":"Subscription List\r\nSunPass as used\r\nAmazon Prime 139 Nov 12 Yearly\r\nAsurion 16.99 month through Amazon\r\nAdobe Express 9.99 monthly\r\nChatGPT 20.00 Monthly\r\nSpectrum 79.99 Monthly\r\nMetroPCS 106.00 Monthly\r\nHulu 1.12 Monthly\r\nRoboForm Jan 31, 2030 199.00 Change license\r\nTunnelToTower 11.99 Monthly\r\nPasco Trash Last 01/21/2025 next 3 months 64.50\r\nGoogle Ella ICloud .99 Monthly\r\nGoogle Peter ICloud 2.99 Monthly\r\nZmodo - 49.99 Year 02/27/2025\r\nPeachock Oct 87.00\r\nMax Aug 169.99\r\nClaude $20\r\nCursor $20","content_html":"<p>Subscription List</p>\n<p>SunPass as used</p>\n<p>Amazon Prime 139 Nov 12 Yearly</p>\n<p>Asurion 16.99 month through Amazon</p>\n<p>Adobe Express 9.99 monthly</p>\n<p>ChatGPT 20.00 Monthly</p>\n<p>Spectrum 79.99 Monthly</p>\n<p>MetroPCS 106.00 Monthly</p>\n<p>Hulu 1.12 Monthly</p>\n<p>RoboForm Jan 31, 2030 199.00 Change license</p>\n<p>TunnelToTower 11.99 Monthly</p>\n<p>Pasco Trash Last 01/21/2025 next 3 months 64.50</p>\n<p>Google Ella ICloud .99 Monthly</p>\n<p>Google Peter ICloud 2.99 Monthly</p>\n<p>Zmodo - 49.99 Year 02/27/2025</p>\n<p>Peachock Oct 87.00</p>\n<p>Max Aug 169.99</p>\n<p>Claude $20</p>\n<p>Cursor $20</p>","file_name":"2026-04-25-codex-changes.md","stored_name":"20260425-182957-0b251cd7.md","mime_type":"application/octet-stream","file_size_bytes":"6092","storage_path":"/mnt/drive3/customerdb/backend/documents_storage/20260425-182957-0b251cd7.md","is_deleted":"0","created_at":"2026-04-25 18:29:57","updated_at":"2026-05-09 16:50:44","editor_content":"Subscription List\r\nSunPass as used\r\nAmazon Prime 139 Nov 12 Yearly\r\nAsurion 16.99 month through Amazon\r\nAdobe Express 9.99 monthly\r\nChatGPT 20.00 Monthly\r\nSpectrum 79.99 Monthly\r\nMetroPCS 106.00 Monthly\r\nHulu 1.12 Monthly\r\nRoboForm Jan 31, 2030 199.00 Change license\r\nTunnelToTower 11.99 Monthly\r\nPasco Trash Last 01/21/2025 next 3 months 64.50\r\nGoogle Ella ICloud .99 Monthly\r\nGoogle Peter ICloud 2.99 Monthly\r\nZmodo - 49.99 Year 02/27/2025\r\nPeachock Oct 87.00\r\nMax Aug 169.99\r\nClaude $20\r\nCursor $20","is_text_editable":1,"can_edit_inline":1}
[]
{"todo_module_item_id":"30","title":"Johnson & Johnson Insurance Due Dec","description_text":"Johnson & Johnson https://www.jjins.com/\r\nTransaction date Due Date Description Amount\r\n12/16/2025\t 12/16/2025\tInvoice / Renewal\t$5,850.50","is_completed":"0","due_date":null,"completed_date":null,"created_at":"2026-05-09 16:48:22","updated_at":"2026-05-09 16:48:22"}
{"todo_module_item_id":"30","title":"Johnson & Johnson Insurance Due Dec","description_text":"Johnson & Johnson https://www.jjins.com/\r\nTransaction date Due Date Description Amount\r\n12/16/2025\t 12/16/2025\tInvoice / Renewal\t$5,850.50","is_completed":"0","due_date":"2026-12-01 12:48:00","completed_date":null,"created_at":"2026-05-09 16:48:22","updated_at":"2026-05-09 16:49:07"}
[]
[]
{"todo_module_item_id":"31","title":"The Hartford Insurance Due Oct","description_text":"The Hartford Insurance https://account.thehartford.com/customer/login\r\nLast Payment Received\t10/16/2025\t$362.91","is_completed":"0","due_date":"2026-10-01 12:48:00","completed_date":null,"created_at":"2026-05-09 16:48:51","updated_at":"2026-05-09 16:48:51"}
[]
[]
{"todo_module_item_id":"30","title":"Johnson & Johnson Insurance Due Dec","description_text":"Johnson & Johnson https://www.jjins.com/\r\nTransaction date Due Date Description Amount\r\n12/16/2025\t 12/16/2025\tInvoice / Renewal\t$5,850.50","is_completed":"0","due_date":null,"completed_date":null,"created_at":"2026-05-09 16:48:22","updated_at":"2026-05-09 16:48:22"}
[]
[]
{"todo_module_item_id":"29","title":"Tapco Insurance Due December","description_text":"Tapco will come from Florida Strategic Insurance due 12/01/2026","is_completed":"0","due_date":"2026-10-31 12:47:00","completed_date":null,"created_at":"2026-05-09 16:47:15","updated_at":"2026-05-09 16:47:15"}
[]
{"todo_module_item_id":"28","title":"Install Dock Panel","description_text":"https://github.com/ovexro/dockpanel","is_completed":"0","due_date":"2026-05-08 14:30:00","completed_date":null,"created_at":"2026-05-08 18:30:52","updated_at":"2026-05-08 18:30:52"}
{"todo_module_item_id":"28","title":"Install Dock Panel","description_text":"https://github.com/ovexro/dockpanel","is_completed":"0","due_date":"2026-05-08 14:30:00","completed_date":null,"created_at":"2026-05-08 18:30:52","updated_at":"2026-05-09 15:48:25"}
[]
{"todo_module_item_id":"4","title":"Pharmacy Cream","description_text":null,"is_completed":"0","due_date":"2026-05-08 12:13:00","completed_date":null,"created_at":"2026-05-08 16:14:01","updated_at":"2026-05-08 16:14:01"}
{"todo_module_item_id":"4","title":"Pharmacy Cream","description_text":null,"is_completed":"1","due_date":"2026-05-08 12:13:00","completed_date":"2026-05-09 14:43:53","created_at":"2026-05-08 16:14:01","updated_at":"2026-05-09 14:43:53"}
[]
[]
{"customer_id":3369,"visit_id":129461,"email":"rae.flkey@yahoo.com","status":"sent","delivery_result":"Sent via SMTP (PHPMailer)"}
[]
[]
{"customer_id":488997,"visit_id":129068,"email":"eunicemonique@gmail.com","status":"sent","delivery_result":"Sent via SMTP (PHPMailer)"}
[]
[]
{"customer_id":488997,"visit_id":129068,"email":"eunicemonique@gmail.com","status":"sent","delivery_result":"Sent via SMTP (PHPMailer)"}
[]
[]
{"customer_id":495247,"visit_id":129426,"email":"patgln2004@yahoo.com","status":"sent","delivery_result":"Sent via SMTP (PHPMailer)"}
[]
[]
{"customer_id":489082,"visit_id":129394,"email":"lasagnas@aol.com","status":"sent","delivery_result":"Sent via SMTP (PHPMailer)"}
[]
[]
{"customer_id":495256,"visit_id":129437,"email":"sandraprece2@gmail.com","status":"sent","delivery_result":"Sent via SMTP (PHPMailer)"}
[]
[]
{"customer_id":495256,"visit_id":129437,"email":"sandraprece2@gmail.com","status":"sent","delivery_result":"Sent via SMTP (PHPMailer)"}
[]
[]
{"customer_id":3496,"visit_id":129044,"email":"sheilabeckman@yahoo.com","status":"sent","delivery_result":"Sent via SMTP (PHPMailer)"}
[]
[]
{"customer_id":2468,"visit_id":129464,"email":"roxann.diaz1223@gmail.com","status":"sent","delivery_result":"Sent via SMTP (PHPMailer)"}
[]
[]
{"customer_id":3456,"visit_id":307,"email":"klassykitty_2000@yahoo.com","status":"sent","delivery_result":"Sent via SMTP (PHPMailer)"}
[]
[]
{"customer_id":489068,"visit_id":129351,"email":"lawomansmom58@aol.com","status":"sent"}
[]
[]
{"customer_id":488980,"visit_id":128994,"email":"gunther_m@hcsb.k12.fl.us","status":"sent","delivery_result":"Sent via SMTP (PHPMailer)"}
[]
[]
{"customer_id":495273,"visit_id":129466,"email":"venkateshchanda2012@gmail.com","status":"sent","delivery_result":"Sent via SMTP (PHPMailer)"}
[]
[]
{"customer_id":489076,"visit_id":129381,"email":"ckkcchace@yahoo.com","status":"sent","delivery_result":"Sent via SMTP (PHPMailer)"}
[]
[]
{"customer_id":489075,"visit_id":129374,"email":"erin.buskey@gmail.com","status":"sent","delivery_result":"Sent via SMTP (PHPMailer)"}
[]
[]
{"customer_id":495254,"visit_id":129434,"email":"kelsey.renke@gmail.com","status":"sent","delivery_result":"Sent via SMTP (PHPMailer)"}
[]
[]
{"customer_id":495271,"visit_id":129457,"email":"havvasevimli@gmail.com","status":"sent","delivery_result":"Sent via SMTP (PHPMailer)"}
[]
[]
{"customer_id":3463,"visit_id":129492,"email":"jennyrosenberg06@gmail.com","status":"sent","delivery_result":"Sent via SMTP (PHPMailer)"}
[]
[]
{"customer_id":495289,"visit_id":129504,"email":"johnphillip4u@gmail.com","status":"sent","delivery_result":"Sent via SMTP (PHPMailer)"}
[]
[]
{"customer_id":3226,"visit_id":128973,"email":"emilianodel@gmail.com","status":"sent"}
[]
[]
{"customer_id":1257,"visit_id":129436,"email":"cherlyn8@aol.com","status":"sent","delivery_result":"Sent via SMTP (PHPMailer)"}
[]
[]
{"customer_id":488981,"visit_id":128999,"email":"mortonchantel20@gmail.com","status":"sent","delivery_result":"Sent via SMTP (PHPMailer)"}
[]
[]
{"customer_id":847,"visit_id":129326,"email":"cassandracardi@yahoo.com","status":"sent"}
[]
[]
{"duke_energy_reading_id":"2372","legacy_id":null,"reading_date":"2026-05-08","system_production_wh":"37.21","duke_energy":"2.10","total_usage":"-35.11","meter_grid":"40279.00","meter_solar":"43479.00","total_usage_meter":"-3200.00","total_meter":"99.00","percent_per_day":"0.1238","day_count":"8.00","used_value":"23.00","created_at":"2026-05-09 14:34:32","updated_at":"2026-05-09 14:34:32"}
[]
{"duke_meter_quick_capture_id":"10","capture_date":"2026-05-07","duke_meter":"40239.00","solar_meter":"43462.00","created_at":"2026-05-09 14:28:12","updated_at":"2026-05-09 14:28:12"}
[]
[]
[]
{"duke_energy_reading_id":"2371","legacy_id":null,"reading_date":"2026-05-07","system_production_wh":"30.61","duke_energy":"35.00","total_usage":"4.39","meter_grid":"40239.00","meter_solar":"43462.00","total_usage_meter":"-3223.00","total_meter":"76.00","percent_per_day":"0.1086","day_count":"7.00","used_value":"4.00","created_at":"2026-05-09 14:33:24","updated_at":"2026-05-09 14:33:24"}
[]
{"duke_meter_quick_capture_id":"11","capture_date":"2026-05-06","duke_meter":"40209.00","solar_meter":"43436.00","created_at":"2026-05-09 14:28:51","updated_at":"2026-05-09 14:28:51"}
[]
[]
[]
{"duke_energy_reading_id":"2370","legacy_id":null,"reading_date":"2026-05-06","system_production_wh":"27.26","duke_energy":"33.50","total_usage":"6.24","meter_grid":"40209.00","meter_solar":"43436.00","total_usage_meter":"-3227.00","total_meter":"72.00","percent_per_day":"0.1200","day_count":"6.00","used_value":"14.00","created_at":"2026-05-09 14:32:55","updated_at":"2026-05-09 14:32:55"}
[]
{"duke_meter_quick_capture_id":"8","capture_date":"2026-05-05","duke_meter":"40178.00","solar_meter":"43419.00","created_at":"2026-05-06 19:12:26","updated_at":"2026-05-06 19:12:26"}
[]
[]
[]
{"duke_energy_reading_id":"2369","legacy_id":null,"reading_date":"2026-05-05","system_production_wh":"26.17","duke_energy":"27.70","total_usage":"1.53","meter_grid":"40178.00","meter_solar":"43419.00","total_usage_meter":"-3241.00","total_meter":"58.00","percent_per_day":"0.1160","day_count":"5.00","used_value":"9.00","created_at":"2026-05-09 14:32:07","updated_at":"2026-05-09 14:32:07"}
[]
{"duke_meter_quick_capture_id":"7","capture_date":"2026-05-04","duke_meter":"40152.00","solar_meter":"43402.00","created_at":"2026-05-05 14:15:39","updated_at":"2026-05-05 14:15:39"}
[]
[]
{"duke_energy_reading_id":"2368","legacy_id":null,"reading_date":"2026-05-04","system_production_wh":"26.17","duke_energy":"27.70","total_usage":"1.53","meter_grid":"40152.00","meter_solar":"43402.00","total_usage_meter":"-3250.00","total_meter":"49.00","percent_per_day":"0.1225","day_count":"4.00","used_value":"-4.00","created_at":"2026-05-09 14:30:58","updated_at":"2026-05-09 14:30:58"}
[]
[]
[]
{"duke_energy_reading_id":"2368","legacy_id":null,"reading_date":"2026-05-04","system_production_wh":"26.17","duke_energy":"27.70","total_usage":"1.53","meter_grid":"40152.00","meter_solar":"43402.00","total_usage_meter":"-3250.00","total_meter":"49.00","percent_per_day":"0.1225","day_count":"4.00","used_value":"-4.00","created_at":"2026-05-09 14:30:58","updated_at":"2026-05-09 14:30:58"}
[]
[]
{"duke_meter_quick_capture_id":"11","capture_date":"2026-05-06","duke_meter":"40209.00","solar_meter":"43436.00","created_at":"2026-05-09 14:28:51","updated_at":"2026-05-09 14:28:51"}
[]
[]
{"duke_meter_quick_capture_id":"10","capture_date":"2026-05-07","duke_meter":"40239.00","solar_meter":"43462.00","created_at":"2026-05-09 14:28:12","updated_at":"2026-05-09 14:28:12"}
[]
[]
{"duke_meter_quick_capture_id":"9","capture_date":"2026-05-08","duke_meter":"40279.00","solar_meter":"43479.00","created_at":"2026-05-09 14:27:45","updated_at":"2026-05-09 14:27:45"}
[]
[]
{"items_updated":134,"price_date":"2026-05-09","gold_oz":4730.7,"silver_oz":80.86,"platinum_oz":2059.3,"total_gold_value":21977.47,"total_gold_profit":11648.31,"total_silver_value":36144.42,"total_silver_profit":21786.2,"total_platinum_value":1452.79,"total_platinum_profit":742}
[]
[]
{"gold_silver_price_id":"642","legacy_id":null,"set_date":"2026-05-09","gold_oz":"4730.7000","gold_gram":"166.8707","silver_oz":"80.8600","silver_gram":"2.8523","copper_oz":"0.3900","copper_gram":"0.0138","total_gold_profit":"0.00","total_silver_profit":"0.00","total_gold_value_price":"0.00","total_silver_value_price":"0.00","high_gold":"5354.5000","high_silver":"114.8800","platinum_oz":"2059.3000","platinum_gram":"72.6397","high_platinum":"2835.7000","total_platinum_value_price":"0.00","total_platinum_profit":"0.00","created_at":"2026-05-09 14:26:42","updated_at":"2026-05-09 14:26:42"}
[]
{"todo_module_item_id":"3","title":"Order Aaa Battery","description_text":null,"is_completed":"0","due_date":"2026-05-08 12:13:00","completed_date":null,"created_at":"2026-05-08 16:13:51","updated_at":"2026-05-08 16:13:51"}
{"todo_module_item_id":"3","title":"Order Aaa Battery","description_text":null,"is_completed":"1","due_date":"2026-05-08 12:13:00","completed_date":"2026-05-09 09:27:50","created_at":"2026-05-08 16:13:51","updated_at":"2026-05-09 09:27:50"}
[]
{"todo_module_item_id":"12","title":"Order Jumper Cables","description_text":null,"is_completed":"0","due_date":"2026-05-08 12:15:00","completed_date":null,"created_at":"2026-05-08 16:15:42","updated_at":"2026-05-08 16:15:42"}
{"todo_module_item_id":"12","title":"Order Jumper Cables","description_text":null,"is_completed":"1","due_date":"2026-05-08 12:15:00","completed_date":"2026-05-09 09:27:12","created_at":"2026-05-08 16:15:42","updated_at":"2026-05-09 09:27:12"}
[]
{"customer_totals_id":"19349","legacy_id":null,"customer_date":"2026-05-08 00:00:00","total_customers":"1.00","new_customers":"1.00","cash_sales":"0.00","edwards":"0.00","check_sales":"0.00","credit_card_sales":"100.00","total_sales":"100.00","total_sales_no_edwards":"100.00","dopu_can":"Drop Off","customer_name":"Beverly Oconnor","update_flag":null,"receipts":null,"skyler_worked":"0","skyler_pay":"0.00","ella_pay":"0.00","email":"prolineman19@yahoo.com","lola":null,"created_at":"2026-04-18 07:04:00","edwards_type":null,"tips":"0.00","visit_id":"129386","order_id":"104139","customer_id":"3501"}
{"customer_totals_id":"19349","legacy_id":null,"customer_date":"2026-05-08 00:00:00","total_customers":"1.00","new_customers":"1.00","cash_sales":"100.00","edwards":"0.00","check_sales":"0.00","credit_card_sales":"0.00","total_sales":"100.00","total_sales_no_edwards":"100.00","dopu_can":"Drop Off","customer_name":"Beverly Oconnor","update_flag":null,"receipts":null,"skyler_worked":"0","skyler_pay":"0.00","ella_pay":"0.00","email":"prolineman19@yahoo.com","lola":null,"created_at":"2026-04-18 07:04:00","edwards_type":null,"tips":"0.00","visit_id":"129386","order_id":"104139","customer_id":"3501"}
[]
{"customer_payment_transaction_id":"6580","payment_id":"64450","order_id":"104139","visit_id":"129386","customer_id":"3501","customer_name":"Beverly Oconnor","transaction_date":"2026-05-08 00:00:00","payment_method":null,"payment_type":"Deposit","bucket":"credit","amount":"100.00","tip_amount":"0.00","is_new_customer":"0","source":"payments","created_at":"2026-05-08 19:16:31","updated_at":"2026-05-08 19:16:31"}
{"customer_payment_transaction_id":"6580","payment_id":"64450","order_id":"104139","visit_id":"129386","customer_id":"3501","customer_name":"Beverly Oconnor","transaction_date":"2026-05-08 00:00:00","payment_method":null,"payment_type":"Deposit","bucket":"cash","amount":"100.00","tip_amount":"0.00","is_new_customer":"0","source":"payments","created_at":"2026-05-08 19:16:00","updated_at":"2026-05-08 19:16:00"}
[]
{"todo_module_item_id":"7","title":"Bank Imports","description_text":null,"is_completed":"0","due_date":"2026-05-08 12:14:00","completed_date":null,"created_at":"2026-05-08 16:14:39","updated_at":"2026-05-08 16:14:39"}
{"todo_module_item_id":"7","title":"Bank Imports","description_text":null,"is_completed":"1","due_date":"2026-05-08 12:14:00","completed_date":"2026-05-08 19:02:42","created_at":"2026-05-08 16:14:39","updated_at":"2026-05-08 19:02:42"}