Activity Log

[]

[]

{"bank_classification_rule_id":"33","rule_name":"STORE 1854 → Home Repair or Service","rule_scope":"global","bank_account_id":null,"match_field":"description","match_type":"contains","match_value":"STORE 1854","transaction_type":"Personal","report_category":"Home Repair or Service","review_required":"0","priority":"25","is_active":"1","created_at":"2026-05-03 15:09:16","updated_at":"2026-05-03 15:09:16"}

[]

[]

{"bank_report_category_node_id":"50","parent_id":"4","name":"Home Repair or Service","sort_order":"0","is_active":"1","created_at":"2026-05-03 15:08:43","updated_at":"2026-05-03 15:08:43"}

[]

[]

{"bank_report_category_node_id":"49","parent_id":"6","name":"Home Repair or Service","sort_order":"0","is_active":"1","created_at":"2026-05-03 15:08:37","updated_at":"2026-05-03 15:08:37"}

[]

[]

{"bank_report_category_node_id":"48","parent_id":"4","name":"Automotive","sort_order":"0","is_active":"1","created_at":"2026-05-03 15:07:45","updated_at":"2026-05-03 15:07:45"}

[]

[]

{"bank_report_category_node_id":"47","parent_id":"6","name":"Automotive","sort_order":"0","is_active":"1","created_at":"2026-05-03 15:07:36","updated_at":"2026-05-03 15:07:36"}

[]

{"bank_transaction_id":"4493","legacy_id":null,"bank_import_batch_id":"10","bank_account_id":"1","transaction_uid":"hash:7eab55d959c939c1d36ab90893c3848e15fca6a2","transaction_date":"2026-04-07","description":"Reward Points Redemption","original_description":"REWARD POINTS REDEMPTION","raw_category":"Bonus","category_name":"Bonus","subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"Reward Points","amount":"-55.81","fees":"0.00","total_amount":"-55.81","transaction_status":"Posted","tx_year":"2026","tx_month":"4","transaction_type":"Needs Review","report_category":"Uncategorized","report_category_node_id":null,"review_status":"Needs Review","classification_rule_id":null,"classification_notes":null,"amazon_order_id":null,"amazon_match_method":null,"amazon_lookup_code":null,"classified_at":"2026-05-02 17:13:11","receipt_file_path":null,"receipt_original_name":null,"receipt_uploaded_at":null,"bank_information":"USAA","business_flag":"0","locked_flag":"0","reconciled_flag":"0","reconcile_notes":null,"raw_json":"{\"date\":\"2026-04-07\",\"description\":\"Reward Points Redemption\",\"originaldescription\":\"REWARD POINTS REDEMPTION\",\"category\":\"Bonus\",\"amount\":\"-55.81\",\"status\":\"Posted\"}","created_at":"2026-04-28 18:56:17","updated_at":"2026-05-02 17:13:11"}

{"bank_transaction_id":"4493","legacy_id":null,"bank_import_batch_id":"10","bank_account_id":"1","transaction_uid":"hash:7eab55d959c939c1d36ab90893c3848e15fca6a2","transaction_date":"2026-04-07","description":"Reward Points Redemption","original_description":"REWARD POINTS REDEMPTION","raw_category":"Bonus","category_name":"Bonus","subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"Reward Points","amount":"-55.81","fees":"0.00","total_amount":"-55.81","transaction_status":"Posted","tx_year":"2026","tx_month":"4","transaction_type":"Personal","report_category":"Income","report_category_node_id":"5","review_status":"Approved","classification_rule_id":null,"classification_notes":null,"amazon_order_id":null,"amazon_match_method":null,"amazon_lookup_code":null,"classified_at":"2026-05-03 15:06:28","receipt_file_path":null,"receipt_original_name":null,"receipt_uploaded_at":null,"bank_information":"USAA","business_flag":"0","locked_flag":"0","reconciled_flag":"0","reconcile_notes":null,"raw_json":"{\"date\":\"2026-04-07\",\"description\":\"Reward Points Redemption\",\"originaldescription\":\"REWARD POINTS REDEMPTION\",\"category\":\"Bonus\",\"amount\":\"-55.81\",\"status\":\"Posted\"}","created_at":"2026-04-28 18:56:17","updated_at":"2026-05-03 15:06:28"}

[]

[]

{"bank_classification_rule_id":"32","rule_name":"REWARD → Income","rule_scope":"global","bank_account_id":null,"match_field":"description","match_type":"contains","match_value":"REWARD","transaction_type":"Personal","report_category":"Income","review_required":"0","priority":"25","is_active":"1","created_at":"2026-05-03 15:06:28","updated_at":"2026-05-03 15:06:28"}

[]

{"bank_transaction_id":"4499","legacy_id":null,"bank_import_batch_id":"10","bank_account_id":"1","transaction_uid":"hash:ae5b303fd9afb223304e1fd8005decf90c5eb593","transaction_date":"2026-04-01","description":"McDonald's","original_description":"MCDONALD'S F6961         MIAMI        FL","raw_category":"Fast Food","category_name":"Fast Food","subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"McDonald's","amount":"21.17","fees":"0.00","total_amount":"21.17","transaction_status":"Posted","tx_year":"2026","tx_month":"4","transaction_type":"Needs Review","report_category":"Uncategorized","report_category_node_id":null,"review_status":"Needs Review","classification_rule_id":null,"classification_notes":null,"amazon_order_id":null,"amazon_match_method":null,"amazon_lookup_code":null,"classified_at":"2026-05-02 17:13:11","receipt_file_path":null,"receipt_original_name":null,"receipt_uploaded_at":null,"bank_information":"USAA","business_flag":"0","locked_flag":"0","reconciled_flag":"0","reconcile_notes":null,"raw_json":"{\"date\":\"2026-04-01\",\"description\":\"McDonald's\",\"originaldescription\":\"MCDONALD'S F6961         MIAMI        FL\",\"category\":\"Fast Food\",\"amount\":\"21.17\",\"status\":\"Posted\"}","created_at":"2026-04-28 18:56:17","updated_at":"2026-05-02 17:13:11"}

{"bank_transaction_id":"4499","legacy_id":null,"bank_import_batch_id":"10","bank_account_id":"1","transaction_uid":"hash:ae5b303fd9afb223304e1fd8005decf90c5eb593","transaction_date":"2026-04-01","description":"McDonald's","original_description":"MCDONALD'S F6961         MIAMI        FL","raw_category":"Fast Food","category_name":"Fast Food","subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"McDonald's","amount":"21.17","fees":"0.00","total_amount":"21.17","transaction_status":"Posted","tx_year":"2026","tx_month":"4","transaction_type":"Personal","report_category":"Dining","report_category_node_id":"15","review_status":"Approved","classification_rule_id":null,"classification_notes":null,"amazon_order_id":null,"amazon_match_method":null,"amazon_lookup_code":null,"classified_at":"2026-05-03 15:06:02","receipt_file_path":null,"receipt_original_name":null,"receipt_uploaded_at":null,"bank_information":"USAA","business_flag":"0","locked_flag":"0","reconciled_flag":"0","reconcile_notes":null,"raw_json":"{\"date\":\"2026-04-01\",\"description\":\"McDonald's\",\"originaldescription\":\"MCDONALD'S F6961         MIAMI        FL\",\"category\":\"Fast Food\",\"amount\":\"21.17\",\"status\":\"Posted\"}","created_at":"2026-04-28 18:56:17","updated_at":"2026-05-03 15:06:02"}

[]

[]

{"bank_classification_rule_id":"31","rule_name":"MCDONALD → Dining","rule_scope":"global","bank_account_id":null,"match_field":"description","match_type":"contains","match_value":"MCDONALD","transaction_type":"Personal","report_category":"Dining","review_required":"0","priority":"25","is_active":"1","created_at":"2026-05-03 15:06:02","updated_at":"2026-05-03 15:06:02"}

[]

{"bank_transaction_id":"4504","legacy_id":null,"bank_import_batch_id":"10","bank_account_id":"1","transaction_uid":"hash:dd0d1a3c4224c75e74d797c2a02512eab7f9d8f8","transaction_date":"2026-03-27","description":"Tires Plus","original_description":"TIRES PLUS 520756        TAMPA        FL","raw_category":"Service & Parts","category_name":"Service & Parts","subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"Tires Plus","amount":"572.78","fees":"0.00","total_amount":"572.78","transaction_status":"Posted","tx_year":"2026","tx_month":"3","transaction_type":"Needs Review","report_category":"Uncategorized","report_category_node_id":null,"review_status":"Needs Review","classification_rule_id":null,"classification_notes":null,"amazon_order_id":null,"amazon_match_method":null,"amazon_lookup_code":null,"classified_at":"2026-05-02 17:13:12","receipt_file_path":null,"receipt_original_name":null,"receipt_uploaded_at":null,"bank_information":"USAA","business_flag":"0","locked_flag":"0","reconciled_flag":"0","reconcile_notes":null,"raw_json":"{\"date\":\"2026-03-27\",\"description\":\"Tires Plus\",\"originaldescription\":\"TIRES PLUS 520756        TAMPA        FL\",\"category\":\"Service & Parts\",\"amount\":\"572.78\",\"status\":\"Posted\"}","created_at":"2026-04-28 18:56:17","updated_at":"2026-05-02 17:13:12"}

{"bank_transaction_id":"4504","legacy_id":null,"bank_import_batch_id":"10","bank_account_id":"1","transaction_uid":"hash:dd0d1a3c4224c75e74d797c2a02512eab7f9d8f8","transaction_date":"2026-03-27","description":"Tires Plus","original_description":"TIRES PLUS 520756        TAMPA        FL","raw_category":"Service & Parts","category_name":"Service & Parts","subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"Tires Plus","amount":"572.78","fees":"0.00","total_amount":"572.78","transaction_status":"Posted","tx_year":"2026","tx_month":"3","transaction_type":"Needs Review","report_category":"Uncategorized","report_category_node_id":null,"review_status":"Needs Review","classification_rule_id":null,"classification_notes":null,"amazon_order_id":null,"amazon_match_method":null,"amazon_lookup_code":null,"classified_at":"2026-05-02 17:13:12","receipt_file_path":"/tmp/customerdb/bank_receipts/tx_4504_20260503_150436_3e0f2367_Tires_Plus_Caravan_Invoice154074.pdf","receipt_original_name":"Tires Plus Caravan Invoice154074.Pdf","receipt_uploaded_at":"2026-05-03 15:04:36","bank_information":"USAA","business_flag":"0","locked_flag":"0","reconciled_flag":"0","reconcile_notes":null,"raw_json":"{\"date\":\"2026-03-27\",\"description\":\"Tires Plus\",\"originaldescription\":\"TIRES PLUS 520756        TAMPA        FL\",\"category\":\"Service & Parts\",\"amount\":\"572.78\",\"status\":\"Posted\"}","created_at":"2026-04-28 18:56:17","updated_at":"2026-05-03 15:04:36"}

{"workflow_status":"drop_off","visit_id":129342,"order_id":104095}

[]

{"workflow_id":"18","source":"setmore","source_key":"30cf48a2-52ea-4568-bcf1-2bdb0f8d6d53","appointment_date":"2026-05-02","customer_id":"489065","visit_id":"129342","order_id":"104095","workflow_status":"drop_off","payment_state":"deposit","payment_method":"Credit","payment_amount":"99.99","paid_in_advance":"0","report_required":"1","report_attached":"0","report_checked_at":"2026-05-02 18:01:22","provider_notes_text":"[Workflow] Status: drop off | Payment State: deposit | Payment: Credit $99.99 | Paid In Advance: No | Report Required: Yes | Report Attached: No","operator_notes":null,"no_show_email_key":"none","created_at":"2026-05-02 18:01:22","updated_at":"2026-05-02 18:01:22","payment_breakdown_json":"[{\"method\":\"Credit\",\"amount\":99.99}]"}

{"workflow_status":"rescheduled","visit_id":129474,"order_id":106610}

[]

{"workflow_id":"17","source":"setmore","source_key":"d251d06c-de64-4686-951c-6760a3c7dec6","appointment_date":"2026-05-02","customer_id":"3514","visit_id":"129474","order_id":"106610","workflow_status":"rescheduled","payment_state":null,"payment_method":null,"payment_amount":"0.00","paid_in_advance":"0","report_required":"0","report_attached":"0","report_checked_at":"2026-05-02 18:00:19","provider_notes_text":"[Workflow] Status: rescheduled | Payment State: n/a | Payment: None | Paid In Advance: No | Report Required: No | Report Attached: No","operator_notes":null,"no_show_email_key":"none","created_at":"2026-05-02 18:00:19","updated_at":"2026-05-02 18:00:19","payment_breakdown_json":"[]"}

{"type":"mysqli_sql_exception","file":"/tmp/tmp_paydetail.php","line":6,"trace":"#0 /tmp/tmp_paydetail.php(6): mysqli->query()\n#1 {main}"}

{"type":"mysqli_sql_exception","file":"/tmp/tmp_audit3.php","line":5,"trace":"#0 /tmp/tmp_audit3.php(5): mysqli->query()\n#1 {main}"}

{"type":"mysqli_sql_exception","file":"/tmp/tmp_audit2.php","line":5,"trace":"#0 /tmp/tmp_audit2.php(5): mysqli->query()\n#1 {main}"}

{"type":"mysqli_sql_exception","file":"/tmp/tmp_direct_audit.php","line":11,"trace":"#0 /tmp/tmp_direct_audit.php(11): mysqli->query()\n#1 {main}"}

{"action":"schedule_update_workflow","source":"setmore","source_key":"48acd131-1bb9-468d-9364-a44c25191e95","type":"Error","file":"/mnt/drive3/customerdb/backend/operations_service.php","line":601,"trace":"#0 /mnt/drive3/customerdb/backend/schedule.php(23): app_schedule_update_workflow()\n#1 /mnt/drive3/customerdb/webui/backend/schedule.php(5): require('...')\n#2 {main}"}

[]

{"bank_transaction_id":"4733","legacy_id":null,"bank_import_batch_id":"19","bank_account_id":"11","transaction_uid":"hash:70150c09a343752823ae1a59075cdb48719968aa","transaction_date":"2026-04-30","description":"SUNO INC.","original_description":null,"raw_category":"Merchandise","category_name":"Merchandise","subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"SUNO INC.","amount":"96.00","fees":"0.00","total_amount":"96.00","transaction_status":null,"tx_year":"2026","tx_month":"4","transaction_type":"Needs Review","report_category":"Uncategorized","report_category_node_id":null,"review_status":"Needs Review","classification_rule_id":null,"classification_notes":null,"amazon_order_id":null,"amazon_match_method":null,"amazon_lookup_code":null,"classified_at":"2026-05-02 13:29:45","receipt_file_path":null,"receipt_original_name":null,"receipt_uploaded_at":null,"bank_information":"CapitalOne","business_flag":"0","locked_flag":"0","reconciled_flag":"0","reconcile_notes":null,"raw_json":"{\"transactiondate\":\"2026-04-30\",\"posteddate\":\"2026-05-01\",\"cardno\":\"0926\",\"description\":\"SUNO INC.\",\"category\":\"Merchandise\",\"debit\":\"96.00\",\"credit\":\"\"}","created_at":"2026-05-02 13:29:45","updated_at":"2026-05-02 13:29:45"}

{"bank_transaction_id":"4733","legacy_id":null,"bank_import_batch_id":"19","bank_account_id":"11","transaction_uid":"hash:70150c09a343752823ae1a59075cdb48719968aa","transaction_date":"2026-04-30","description":"SUNO INC.","original_description":null,"raw_category":"Merchandise","category_name":"Merchandise","subcategory_name":null,"irs_category":null,"irs_use":null,"merchant_prefix":"SUNO INC.","amount":"96.00","fees":"0.00","total_amount":"96.00","transaction_status":null,"tx_year":"2026","tx_month":"4","transaction_type":"Needs Review","report_category":"Uncategorized","report_category_node_id":null,"review_status":"Needs Review","classification_rule_id":null,"classification_notes":null,"amazon_order_id":null,"amazon_match_method":null,"amazon_lookup_code":null,"classified_at":"2026-05-02 13:29:45","receipt_file_path":"/tmp/customerdb/bank_receipts/tx_4733_20260502_171219_78d2c9f3_Suno_-_Receipt-2617-3614-2169.pdf","receipt_original_name":"Suno - Receipt-2617-3614-2169.pdf","receipt_uploaded_at":"2026-05-02 17:12:19","bank_information":"CapitalOne","business_flag":"0","locked_flag":"0","reconciled_flag":"0","reconcile_notes":null,"raw_json":"{\"transactiondate\":\"2026-04-30\",\"posteddate\":\"2026-05-01\",\"cardno\":\"0926\",\"description\":\"SUNO INC.\",\"category\":\"Merchandise\",\"debit\":\"96.00\",\"credit\":\"\"}","created_at":"2026-05-02 13:29:45","updated_at":"2026-05-02 17:12:19"}

{"mode":"upload_receipt","type":"RuntimeException","file":"/mnt/drive3/customerdb/webui/backend/bank_service.php","line":224,"trace":"#0 /mnt/drive3/customerdb/webui/backend/bank_transactions.php(41): app_bank_upload_receipt()\n#1 {main}"}

{"file":"/mnt/drive3/customerdb/webui/backend/bank_service.php","line":223,"severity_code":2}

{"mode":"upload_receipt","type":"RuntimeException","file":"/mnt/drive3/customerdb/webui/backend/bank_service.php","line":224,"trace":"#0 /mnt/drive3/customerdb/webui/backend/bank_transactions.php(41): app_bank_upload_receipt()\n#1 {main}"}

{"file":"/mnt/drive3/customerdb/webui/backend/bank_service.php","line":223,"severity_code":2}

{"action":"import_csv","type":"RuntimeException","file":"/mnt/drive3/customerdb/backend/ambient_weather_service.php","line":135,"trace":"#0 /mnt/drive3/customerdb/backend/ambient_weather.php(26): app_ambient_weather_import_csv()\n#1 /mnt/drive3/customerdb/webui/backend/ambient_weather.php(5): require('...')\n#2 {main}"}

{"mode":"upload_receipt","type":"Error","file":"/mnt/drive3/customerdb/webui/backend/bank_transactions.php","line":41,"trace":"#0 {main}"}

{"rows_seen":38,"rows_imported":8,"rows_updated":30,"rows_skipped":0,"source_filename":"2026-05-02_transaction_download.csv"}

[]

{"bank_import_batch_id":"19","bank_account_id":"11","import_date":"2026-05-02","start_date":"2026-03-02","end_date":null,"sort_name":null,"import_notes":null,"source_filename":"2026-05-02_transaction_download.csv","import_status":"imported","rows_seen":"38","rows_imported":"8","rows_updated":"30","rows_skipped":"0","created_at":"2026-05-02 13:29:45","updated_at":"2026-05-02 13:29:45"}

{"action":"schedule_update_workflow","source":"setmore","source_key":"35776c34-4908-4575-9077-b607bfdcdf3a","type":"mysqli_sql_exception","file":"/mnt/drive3/customerdb/backend/operations_service.php","line":582,"trace":"#0 /mnt/drive3/customerdb/backend/operations_service.php(582): mysqli->query()\n#1 /mnt/drive3/customerdb/backend/schedule.php(23): app_schedule_update_workflow()\n#2 /mnt/drive3/customerdb/webui/backend/schedule.php(5): require('...')\n#3 {main}"}

{"action":"schedule_update_workflow","source":"setmore","source_key":"35776c34-4908-4575-9077-b607bfdcdf3a","type":"mysqli_sql_exception","file":"/mnt/drive3/customerdb/backend/operations_service.php","line":582,"trace":"#0 /mnt/drive3/customerdb/backend/operations_service.php(582): mysqli->query()\n#1 /mnt/drive3/customerdb/backend/schedule.php(23): app_schedule_update_workflow()\n#2 /mnt/drive3/customerdb/webui/backend/schedule.php(5): require('...')\n#3 {main}"}

{"action":"schedule_update_workflow","source":"setmore","source_key":"35776c34-4908-4575-9077-b607bfdcdf3a","type":"mysqli_sql_exception","file":"/mnt/drive3/customerdb/backend/operations_service.php","line":518,"trace":"#0 /mnt/drive3/customerdb/backend/operations_service.php(518): mysqli->query()\n#1 /mnt/drive3/customerdb/backend/schedule.php(23): app_schedule_update_workflow()\n#2 /mnt/drive3/customerdb/webui/backend/schedule.php(5): require('...')\n#3 {main}"}

{"workflow_status":"drop_off","visit_id":129468,"order_id":106604}

[]

{"workflow_id":"15","source":"setmore","source_key":"f8c81391-ede5-4574-a54d-733b389ca1e1","appointment_date":"2026-05-01","customer_id":"495275","visit_id":"129468","order_id":"106604","workflow_status":"drop_off","payment_state":null,"payment_method":null,"payment_amount":"0.00","paid_in_advance":"0","report_required":"1","report_attached":"1","report_checked_at":"2026-05-01 20:54:10","provider_notes_text":null,"operator_notes":null,"no_show_email_key":"none","created_at":"2026-05-01 20:54:10","updated_at":"2026-05-01 20:54:10","payment_breakdown_json":"[]"}

{"workflow_status":"no_show","visit_id":129467,"order_id":106603}

[]

{"workflow_id":"14","source":"visit","source_key":"129467","appointment_date":"2026-05-01","customer_id":"495274","visit_id":"129467","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-05-01 20:36:19","provider_notes_text":null,"operator_notes":"{\"Project Details\":\"Getting a prom dress shortened\",\"When Needed?\":\"Needed by may 9th for prom\"}","no_show_email_key":"none","created_at":"2026-05-01 20:36:19","updated_at":"2026-05-01 20:36:19","payment_breakdown_json":"[]"}

{"workflow_status":"scheduled","visit_id":129479,"order_id":106615}

[]

{"workflow_id":"13","source":"setmore","source_key":"35776c34-4908-4575-9077-b607bfdcdf3a","appointment_date":"2026-05-01","customer_id":"847","visit_id":"129479","order_id":"106615","workflow_status":"scheduled","payment_state":null,"payment_method":null,"payment_amount":"0.00","paid_in_advance":"0","report_required":"1","report_attached":"1","report_checked_at":"2026-05-01 20:33:21","provider_notes_text":null,"operator_notes":null,"no_show_email_key":"none","created_at":"2026-05-01 20:33:21","updated_at":"2026-05-01 20:33:21","payment_breakdown_json":"[]"}

{"action":"schedule_update_workflow","source":"setmore","source_key":"35776c34-4908-4575-9077-b607bfdcdf3a","type":"mysqli_sql_exception","file":"/mnt/drive3/customerdb/backend/operations_service.php","line":518,"trace":"#0 /mnt/drive3/customerdb/backend/operations_service.php(518): mysqli->query()\n#1 /mnt/drive3/customerdb/backend/schedule.php(23): app_schedule_update_workflow()\n#2 /mnt/drive3/customerdb/webui/backend/schedule.php(5): require('...')\n#3 {main}"}

[]

[]

{"customer_id":489061,"visit_id":129328,"email":"regiazuly2597@gmail.com","status":"sent","delivery_result":"Sent via SMTP (PHPMailer)"}

[]

[]

{"customer_id":3390,"visit_id":129357,"email":"lynziesmith2010@icloud.com","status":"sent","delivery_result":"Sent via SMTP (PHPMailer)"}

[]

[]

{"customer_id":3483,"visit_id":129359,"email":"nfridy@gmail.com","status":"sent","delivery_result":"Sent via SMTP (PHPMailer)"}

[]

[]

{"customer_id":3193,"visit_id":129051,"email":"teelkim@aol.com","status":"sent","delivery_result":"Sent via SMTP (PHPMailer)"}

[]

[]

{"customer_id":429498,"visit_id":110275,"email":"dtsrichter@earthlink.net","status":"sent","delivery_result":"Sent via SMTP (PHPMailer)"}

[]

[]

{"customer_id":429509,"visit_id":129327,"email":"chloempaquette@gmail.com","status":"sent","delivery_result":"Sent via SMTP (PHPMailer)"}

[]

[]

{"customer_id":2573,"visit_id":129053,"email":"carriejoy3521@gmail.com","status":"sent","delivery_result":"Sent via SMTP (PHPMailer)"}

[]

[]

{"customer_id":489088,"visit_id":129415,"email":"kamatamabhinav@gmail.com","status":"sent","delivery_result":"Sent via SMTP (PHPMailer)"}

[]

{"daily_customer_totals_id":"5699","legacy_id":null,"customer_date":"2026-04-17 00:00:00","total_customers":"13.00","new_customers":"5.00","cash_sales":"30.25","edwards":"0.00","check_sales":"0.00","credit_card_sales":"278.08","total_sales":"323.08","total_sales_no_edwards":"323.08","dopu_can":null,"customer_name":null,"update_flag":null,"receipts":null,"skyler_worked":"0","skyler_pay":"0.00","ella_pay":"0.00","email":null,"lola":null,"created_at":"2026-04-27 15:30:07","edwards_type":null,"tips":"14.75"}

{"daily_customer_totals_id":"5699","legacy_id":null,"customer_date":"2026-04-17 00:00:00","total_customers":"13.00","new_customers":"5.00","cash_sales":"80.25","edwards":"0.00","check_sales":"0.00","credit_card_sales":"637.72","total_sales":"716.97","total_sales_no_edwards":"717.97","dopu_can":null,"customer_name":null,"update_flag":null,"receipts":null,"skyler_worked":"0","skyler_pay":"0.00","ella_pay":"0.00","email":null,"lola":null,"created_at":"2026-04-27 15:30:00","edwards_type":null,"tips":"14.75"}

[]

{"daily_customer_totals_id":"5725","legacy_id":null,"customer_date":"2026-04-27 00:00:00","total_customers":"8.00","new_customers":"7.00","cash_sales":"0.00","edwards":"0.00","check_sales":"0.00","credit_card_sales":"123.05","total_sales":"123.05","total_sales_no_edwards":"123.05","dopu_can":null,"customer_name":null,"update_flag":null,"receipts":null,"skyler_worked":"0","skyler_pay":"0.00","ella_pay":"0.00","email":null,"lola":null,"created_at":"2026-04-30 14:00:45","edwards_type":null,"tips":"0.00"}

{"daily_customer_totals_id":"5725","legacy_id":null,"customer_date":"2026-04-27 00:00:00","total_customers":"8.00","new_customers":"7.00","cash_sales":"0.00","edwards":"150.00","check_sales":"0.00","credit_card_sales":"123.05","total_sales":"273.05","total_sales_no_edwards":"123.05","dopu_can":null,"customer_name":null,"update_flag":null,"receipts":null,"skyler_worked":"0","skyler_pay":"0.00","ella_pay":"0.00","email":null,"lola":null,"created_at":"2026-04-30 14:00:00","edwards_type":null,"tips":"0.00"}

[]

{"customer_totals_id":"20362","legacy_id":null,"customer_date":"2026-04-29 13:36:00","total_customers":"1.00","new_customers":"1.00","cash_sales":"0.00","edwards":"150.00","check_sales":"0.00","credit_card_sales":"0.00","total_sales":"0.00","total_sales_no_edwards":"0.00","dopu_can":"Pick Up","customer_name":"Edwards Pick Up","update_flag":null,"receipts":null,"skyler_worked":"0","skyler_pay":"0.00","ella_pay":"0.00","email":"","lola":null,"created_at":"2026-04-30 13:37:31","edwards_type":null,"tips":"0.00","visit_id":null,"order_id":null,"customer_id":null}

{"customer_totals_id":"20362","legacy_id":null,"customer_date":"2026-04-27 13:36:00","total_customers":"1.00","new_customers":"1.00","cash_sales":"0.00","edwards":"150.00","check_sales":"0.00","credit_card_sales":"0.00","total_sales":"0.00","total_sales_no_edwards":"0.00","dopu_can":"Pick Up","customer_name":"Edwards Pick Up","update_flag":null,"receipts":null,"skyler_worked":"0","skyler_pay":"0.00","ella_pay":"0.00","email":null,"lola":null,"created_at":"2026-04-30 13:37:00","edwards_type":null,"tips":"0.00","visit_id":null,"order_id":null,"customer_id":null}

{"table":"daily_customer_totals","type":"mysqli_sql_exception","file":"/mnt/drive3/customerdb/backend/live_table_manager_service.php","line":212,"trace":"#0 /mnt/drive3/customerdb/backend/live_table_manager_service.php(212): mysqli->query()\n#1 /mnt/drive3/customerdb/backend/live_table_manager.php(33): app_live_table_save()\n#2 /mnt/drive3/customerdb/webui/backend/live_table_manager.php(5): require('...')\n#3 {main}"}

[]

[]

{"customer_date":"2026-04-29 13:36:00","customer_name":"Edwards Pick Up","dopu_can":"Pick Up","edwards":150}

{"type":"mysqli_sql_exception","file":"C:\\code\\customerdb\\tmp_hockerty_scan.php","line":29,"trace":"#0 C:\\code\\customerdb\\tmp_hockerty_scan.php(29): mysqli->query('SELECT vhi.visi...')\n#1 {main}"}

{"mode":"import_zip","type":"RuntimeException","file":"/mnt/drive3/customerdb/webui/backend/bank_amazon_import.php","line":22,"trace":"#0 {main}"}

{"mode":"import_zip","type":"RuntimeException","file":"/mnt/drive3/customerdb/webui/backend/bank_amazon_import.php","line":24,"trace":"#0 {main}"}

{"mode":"import_zip","type":"RuntimeException","file":"/mnt/drive3/customerdb/webui/backend/bank_amazon_import.php","line":24,"trace":"#0 {main}"}

{"mode":"import_zip","type":"RuntimeException","file":"/mnt/drive3/customerdb/webui/backend/bank_amazon_import.php","line":24,"trace":"#0 {main}"}

← Prev 1 … 5341 5342 5343 5344 5345 … 5441 Next →