{"modules":{"blog":{"name":"blog","status":"active","summary":"Normalized blog pipeline data, content assets, AI tasks, and migration files.","stats":{"content_items":62,"sections":795,"faqs":298,"variants":907,"ai_tasks":914},"paths":["/mnt/drive3/customerdb/blog/mariadb_reengineering"]},"schedule":{"name":"schedule","status":"live","summary":"Setmore sync, appointment visibility, and morning job support for scheduling workflows.","stats":{"today_total":11,"today_setmore":11,"today_ea":0,"today_with_visit":11},"endpoints":["/backend/api/appointments.php","/backend/api/appointments_summary.php","/backend/api/setmore_import.php","/backend/api/setmore_appointments.php","/backend/api/job_runs.php"]},"alterations":{"name":"alterations","status":"staging","summary":"Alteration item staging imported from legacy Access exports and available for backend validation.","stats":{"raw_rows":0,"staged_rows":1509,"distinct_customers":995,"distinct_legacy_visits":1195,"paid_rows":0,"picked_up_rows":853},"endpoints":["/backend/api/alteration_items.php","/backend/api/alteration_items_summary.php"]},"hockerty":{"name":"hockerty","status":"live","summary":"Internal Hockerty catalog and visit-linked ticket details for non-customer-facing billing work.","stats":{"catalog_active_rows":35,"ticket_rows":3,"customer_rows":3,"internal_total":0},"endpoints":["/backend/hockerty.php","/backend/hockerty_invoices.php"]},"frontdesk_queue":{"name":"frontdesk_queue","status":"live","summary":"Pickup and work-needed queues for today, tomorrow, and the next 7 days.","stats":{"ready_today_tomorrow":6,"next_7_visits":20,"work_needed_visits":20,"work_needed_items":25},"endpoints":["/reports.html?type=ready","/upcoming.html","/workload.html"]},"reporting":{"name":"reporting","status":"live","summary":"Daily totals, ad hoc exports, report indexing, report folders, and PDF browser support.","stats":{"report_folders":265,"today_pdfs":20,"indexed_reports":11175,"job_runs":67},"paths":["/mnt/drive3/customerdb/frontend/reports"],"endpoints":["/backend/reporting_module.php","/backend/api/reports_daily.php","/backend/api/reports_adhoc.php","/backend/api/reports_export.php","/backend/api/reporting_module.php","/backend/api/job_runs.php"]},"bank":{"name":"bank","status":"live","summary":"Bank accounts, CSV imports, reconciliation, IRS classification, and bank reporting.","stats":{"banks":21,"transactions":4792,"unreconciled":4792,"locked":0},"endpoints":["/backend/bank.php","/backend/bank_import.php","/backend/bank_transactions.php","/backend/bank_report_categories.php","/backend/bank_classification_rules.php","/backend/bank_review.php","/backend/bank_reconcile.php","/backend/bank_reports.php","/backend/bank_amazon_import.php","/backend/bank_amazon_order.php","/backend/bank_amazon_ref.php","/backend/api/bank_data.php","/backend/api/bank_transactions.php","/backend/api/bank_reports.php"]},"gold_silver":{"name":"gold_silver","status":"live","summary":"Gold and silver inventory and price history can now be imported into backend tables and reviewed in backend pages.","stats":{"object_files":18,"table_files":8,"item_rows":134,"price_rows":642},"paths":["/mnt/drive3/customerdb/notused/Backend/Objects","/mnt/drive3/customerdb/notused/Backend/tables"],"endpoints":["/backend/gold_silver.php","/backend/api/gold_silver_data.php","/backend/api/gold_silver_import.php"]},"duke_daily":{"name":"duke_daily","status":"live","summary":"Duke daily energy and totals data can now be imported into backend tables and reviewed in backend pages.","stats":{"object_files":19,"table_files":6,"energy_rows":1202,"total_rows":36},"paths":["/mnt/drive3/customerdb/notused/Backend/Objects","/mnt/drive3/customerdb/notused/Backend/tables"],"endpoints":["/backend/duke_daily.php","/backend/duke_monthly.php","/backend/api/duke_data.php","/backend/api/duke_monthly_data.php","/backend/api/duke_import.php"]},"medication":{"name":"medication","status":"live","summary":"Track medications, fill dates, due dates, costs, and providers. Auto-calculates DateDue = DateFilled + DayAmount.","stats":{"total":51,"active":25},"endpoints":["/backend/medication.php","/backend/medication_report.php","/backend/api/medication_data.php","/backend/api/medication_import.php"]},"cust_email":{"name":"cust_email","status":"live","summary":"Track review request emails sent to customers after pickup, manage email templates, and log Google review counts.","stats":{"total_sent":96,"ready_count":96},"endpoints":["/backend/cust_email.php","/backend/cust_email_report.php","/backend/api/cust_email_data.php"]},"reminders":{"name":"reminders","status":"ready","summary":"CustomerDB backend reminder queue plus Ella DB editor (same `reminders` table as reminders.floridaalterations.com).","stats":{"total_rows":0,"pending_rows":0},"endpoints":["/backend/ella_reminders_crud.php","/backend/reminders.php","/backend/api/reminders_create.php"]},"ai_traffic":{"name":"ai_traffic","status":"live","summary":"Imported AI traffic and bot traffic CSV exports with per-source summaries and event table browsing.","stats":{"total_rows":17576,"source_count":14},"endpoints":["/backend/ai_traffic.php"]},"search_data":{"name":"search_data","status":"live","summary":"Adaptive Bing/Google search CSV imports with provider-aware dataset catalogs and Ollama analysis over imported tables.","stats":{"dataset_count":1,"row_count":173},"endpoints":["/backend/search_data.php"]},"tabby_terminal":{"name":"tabby_terminal","status":"ready","summary":"Web-based terminal emulator for running administrative PowerShell commands in the browser.","stats":{"shell_ready":0,"shell_name":""},"endpoints":["/backend/tabby_terminal.php","/backend/api/powershell_terminal.php"]},"stocks":{"name":"stocks","status":"live","summary":"Stock and crypto portfolio tracker with live Yahoo Finance prices. Add, edit, delete assets. Shows quantity, avg cost, live price, gain/loss.","stats":{"assets":12,"total_cost":5970.753243876201,"total_value":5902.153563698801},"endpoints":["/backend/api/stocks_summary.php","/backend/api/stocks_save.php","/backend/api/stocks_live.php"]},"receipts":{"name":"receipts","status":"live","summary":"Import and store receipt PDFs and images with dates and notes. Open, edit, or soft-delete records from one screen.","stats":{"receipts":1},"endpoints":["/backend/receipts.php","/backend/api/receipts.php","/backend/receipt_file.php"]},"todo_module":{"name":"todo_module","status":"live","summary":"Excel-style todo grid with completion tracking and activity log integration.","stats":{"items":31},"endpoints":["/backend/todo_module.php"]},"amazon_orders_module":{"name":"amazon_orders_module","status":"live","summary":"Frequently bought Amazon items with list/details view and activity logging.","stats":{"items":5},"endpoints":["/backend/amazon_orders_module.php"]}}}