============================================================
 DIAG Multi Empresa  -  2026-06-03 10:03:32
============================================================

[SESION]
  user_id    = NULL
  user_email = NULL
  user_tipo  = NULL
  user_nombre= NULL

[RUTAS]
  __DIR__       = /var/www/csnapps.com/public_html/Multi_Empresa/public
  realpath(..)  = /var/www/csnapps.com/public_html/Multi_Empresa
  basename(..)  = Multi_Empresa

[CONFIG]
  config file = /var/www/csnapps.com/public_html/Multi_Empresa/public/../config/master.php
  exists?     = YES
  master.host     = localhost
  master.dbname   = master_system
  master.username = root

[CONEXION MASTER] OK

[TABLAS en master_system]
  - audit_log
  - backup_log
  - company_info
  - cron_config
  - cron_executions
  - email_config
  - empresas
  - empresas_ia_config
  - external_system_events
  - external_system_payments
  - external_system_subscriptions
  - external_systems
  - payments
  - seller_sales
  - sellers
  - sesiones
  - subscription_events
  - subscriptions
  - system_prices
  - usuarios
  - usuarios_empresas

[usuarios] (master_system)
  id=1  email=csnbks@gmail.com  tipo=super_admin  plan_tier=50  estado=active  license=buy
  id=3  email=myrainbowfcc@outlook.com  tipo=owner  plan_tier=20  estado=suspended  license=buy
  id=4  email=ingcsn@att.net  tipo=owner  plan_tier=50  estado=suspended  license=lease
  total: 3

[empresas] (master_system)
  id=4  codigo=MYRAINBOWFCC-COMP-0001  nombre=My Rainbow FCC Co.  db_name=myrainbowfcc_comp_0001  creada_por=3  activa=0  created_at=2026-04-20 01:20:38
  id=5  codigo=MYRAINBOWFCC-COMP-0002  nombre=CSN (Computers)  db_name=myrainbowfcc_comp_0002  creada_por=3  activa=0  created_at=2026-04-20 01:30:24
  total: 2

[usuarios_empresas] (master_system)
  id=3  usuario_id=3  empresa_id=4  rol=admin  activo=1
  id=4  usuario_id=3  empresa_id=5  rol=admin  activo=1
  total: 2

[external_systems] (master_system)
  id=4  folder=Genesys_Construction  display=Genesys Construction  db=general_sales  status=trial
  id=6  folder=Jv_Produce  display=Jv Produce  db=jv_produce_db  status=trial
  id=11  folder=TaxServices  display=Tax Services  db=griceldatax_db  status=sold
  id=62  folder=Vargas_Trucking  display=Trucking — Vargas Trucking Inc  db=vargas_trucking_db  status=sold
  id=67  folder=Taqueiros  display=Taqueiros  db=taqueros  status=trial
  id=69  folder=Sample_Trucking  display=Trucking — Sample Trucking  db=sample_trucking_db  status=trial
  id=85  folder=CSN_Accounting  display=General Sales — CSN Accounting  db=csn_accounting_db  status=sold
  id=88  folder=GNZ_Remodeling  display=General Sales — GNZ Remodeling  db=gnz_remodeling_db  status=trial
  id=90  folder=Redwood_Tree  display=General Sales — Redwood Tree Services  db=redwood_tree_db  status=trial
  id=97  folder=My_Rainbow_Daycare  display=My Rainbow Daycare  db=my_rainbow_daycare_db  status=sold
  id=99  folder=Rainbow_Income  display=General Sales — Rainbow Income  db=rainbow_income_db  status=sold
  id=110  folder=Lambarena_Investments  display=General Sales — Lambarena Investments LLC  db=lambarena_investments_db  status=trial
  id=141  folder=Tacos_el_Guero  display=POS Point of Sale — Tacos el Guero  db=tacos_el_guero_db  status=trial
  id=142  folder=VME_Trucking  display=Trucking — VME  db=vme_trucking_db  status=trial
  total: 14

  Buscando match por folder actual ('Multi_Empresa'):
    NO MATCH

[BD CLIENTE - exploracion]
  No hay BD cliente separada (o coincide con master)

[SIMULACION QUERY DEL select_company.php]
  Usando user_id = 0  email = 
  Query 1: empresas por usuarios_empresas.usuario_id = 0 (master)
    total: 0

[FIN]