2026-07-27 14:11:52 info: Servidor escuchando en http://localhost:8000
2026-07-27 14:11:52 info: Conexión a la base de datos exitosa
2026-07-27 14:11:53 info: Entra a buscar las sucursales en el login
2026-07-27 14:12:21 info: Entrando a loguearse
2026-07-27 14:12:21 info: datos recibidos al loguerase
2026-07-27 14:12:21 info: {"email":"root","password":"123456","branch_id":null}
2026-07-27 14:12:25 info: root - Obtiene las ventas mensuales
2026-07-27 14:12:25 info: Datos recibidos al obtener las ventas mensuales
2026-07-27 14:12:25 info: {"type":"Negocio","branch_id":null,"company_id":6,"month":"2026-07"}
2026-07-27 14:12:33 info: root - Entra a buscar las sucursales
2026-07-27 14:12:34 info: root - Entra a buscar los viajes(index_branch_date) 
2026-07-27 14:12:37 info: root - Entra a la ruta unificada de viajes
2026-07-27 14:12:55 info: root - Entra a buscar las sucursales
2026-07-27 14:12:56 info: root - Obtiene las ventas mensuales
2026-07-27 14:12:56 info: Datos recibidos al obtener las ventas mensuales
2026-07-27 14:12:56 info: {"type":"Negocio","branch_id":null,"company_id":6,"month":"2026-07"}
2026-07-27 14:12:57 info: root - Entra a buscar los viajes(index_branch_date) 
2026-07-27 14:13:00 info: root - Entra a buscar las sucursales
2026-07-27 14:13:00 info: root - Entra a buscar los viajes(index_branch_date) 
2026-07-27 14:13:02 info: root - Entra a la ruta unificada de viajes
2026-07-27 14:13:27 info: root - Entra a la ruta unificada de viajes
2026-07-27 14:16:34 info: Servidor escuchando en http://localhost:8000
2026-07-27 14:16:34 info: Conexión a la base de datos exitosa
2026-07-27 14:16:35 info: Entra a buscar las sucursales en el login
2026-07-27 14:16:36 info: root - Obtiene las ventas mensuales
2026-07-27 14:16:36 info: Datos recibidos al obtener las ventas mensuales
2026-07-27 14:16:36 info: {"type":"Negocio","branch_id":null,"company_id":6,"month":"2026-07"}
2026-07-27 14:16:37 info: root - Entra a buscar las sucursales
2026-07-27 14:16:38 info: root - Entra a buscar los viajes(index_branch_date) 
2026-07-27 14:16:40 info: root - Entra a buscar las sucursales
2026-07-27 14:16:40 info: root - Entra a buscar los viajes(index_branch_date) 
2026-07-27 14:16:44 info: root - Entra a la ruta unificada de viajes
2026-07-27 14:17:41 info: root - Entra a la ruta unificada de viajes
2026-07-27 14:18:26 info: root - Crea un nuevo viaje
2026-07-27 14:18:26 info: datos recibidos al crear un viaje
2026-07-27 14:18:26 info: {"route_id":17,"branch_id":7,"vehicle_id":9,"schedule":"15:00","arrival":"2026-07-28 01:00:00","workers":[{"worker_id":6},{"worker_id":2}],"tripStops":[{"route_stop_id":1,"stop_order":1,"arrival_time":"2026-07-27 15:00:00","departure_time":"2026-07-27 15:05:00","can_board":true,"can_alight":false,"active":true,"source_type":"auto"},{"route_stop_id":2,"stop_order":2,"arrival_time":"2026-07-27 16:00:00","departure_time":"2026-07-27 16:05:00","can_board":true,"can_alight":false,"active":true,"source_type":"auto"},{"route_stop_id":3,"stop_order":3,"arrival_time":"2026-07-27 19:00:00","departure_time":"2026-07-27 19:05:00","can_board":true,"can_alight":true,"active":true,"source_type":"auto"},{"route_stop_id":4,"stop_order":4,"arrival_time":"2026-07-27 21:00:00","departure_time":"2026-07-27 21:05:00","can_board":true,"can_alight":true,"active":true,"source_type":"auto"},{"route_stop_id":5,"stop_order":5,"arrival_time":"2026-07-28 01:00:00","departure_time":"2026-07-28 01:05:00","can_board":false,"can_alight":true,"active":true,"source_type":"auto"}],"tripFares":[{"fare_segment_ticket_type_id":1,"price":7000,"active":false,"source_type":"auto"},{"fare_segment_ticket_type_id":2,"price":10000,"active":true,"source_type":"auto"},{"fare_segment_ticket_type_id":3,"price":9000,"active":true,"source_type":"auto"},{"fare_segment_ticket_type_id":4,"price":30000,"active":true,"source_type":"auto"},{"fare_segment_ticket_type_id":5,"price":40000,"active":true,"source_type":"auto"},{"fare_segment_ticket_type_id":6,"price":35000,"active":true,"source_type":"auto"},{"fare_segment_ticket_type_id":7,"price":15000,"active":true,"source_type":"auto"},{"fare_segment_ticket_type_id":8,"price":20000,"active":true,"source_type":"auto"},{"fare_segment_ticket_type_id":9,"price":18000,"active":true,"source_type":"auto"},{"fare_segment_ticket_type_id":10,"price":7000,"active":true,"source_type":"auto"},{"fare_segment_ticket_type_id":11,"price":10000,"active":true,"source_type":"auto"},{"fare_segment_ticket_type_id":12,"price":9000,"active":true,"source_type":"auto"}],"date":"2026-07-27T18:18:26.366Z"}
2026-07-27 14:18:26 info: Viaje creado exitosamente (ID: 875)
2026-07-27 14:18:27 info: root - Entra a buscar los viajes(index_branch_date) 
2026-07-27 14:18:46 info: root - Entra a buscar las sucursales
2026-07-27 14:18:48 info: root - Busca todas las plantillas de viaje
2026-07-27 14:19:07 info: root - Entra a la ruta unificada de viajes
2026-07-27 14:20:03 info: root - Crea una nueva plantilla de viaje
2026-07-27 14:20:03 info: datos recibidos al crear una plantilla de viaje
2026-07-27 14:20:03 info: {"route_id":17,"branch_id":7,"vehicle_id":9,"schedule":"15:30","duration":600,"recurrence_pattern":"daily","days_of_week":"0,1,2,3,4,5,6","active":true,"workers":[{"id":6,"workerName":"BENJAMIN BRITO","workerImage":"workers/6.png","roleId":3,"roleName":"Venta"},{"id":2,"workerName":"Administrador General","workerImage":"workers/default.jpg","roleId":1,"roleName":"Administrador"}],"tripStops":[{"route_stop_id":1,"stop_order":1,"can_board":true,"can_alight":false,"active":true},{"route_stop_id":2,"stop_order":2,"can_board":true,"can_alight":false,"active":true},{"route_stop_id":3,"stop_order":3,"can_board":true,"can_alight":true,"active":true},{"route_stop_id":4,"stop_order":4,"can_board":true,"can_alight":true,"active":true},{"route_stop_id":5,"stop_order":5,"can_board":false,"can_alight":true,"active":true}],"tripFares":[{"fare_segment_ticket_type_id":1,"price":7000,"active":false,"source_type":"auto"},{"fare_segment_ticket_type_id":2,"price":10000,"active":true,"source_type":"auto"},{"fare_segment_ticket_type_id":3,"price":9000,"active":true,"source_type":"auto"},{"fare_segment_ticket_type_id":4,"price":30000,"active":true,"source_type":"auto"},{"fare_segment_ticket_type_id":5,"price":40000,"active":true,"source_type":"auto"},{"fare_segment_ticket_type_id":6,"price":35000,"active":true,"source_type":"auto"},{"fare_segment_ticket_type_id":7,"price":15000,"active":true,"source_type":"auto"},{"fare_segment_ticket_type_id":8,"price":20000,"active":true,"source_type":"auto"},{"fare_segment_ticket_type_id":9,"price":18000,"active":true,"source_type":"auto"},{"fare_segment_ticket_type_id":10,"price":7000,"active":true,"source_type":"auto"},{"fare_segment_ticket_type_id":11,"price":10000,"active":true,"source_type":"auto"},{"fare_segment_ticket_type_id":12,"price":9000,"active":true,"source_type":"auto"}]}
2026-07-27 14:20:03 info: TripTemplate creado exitosamente (ID: 16)
2026-07-27 14:20:03 info: Viaje creado exitosamente (ID: 876)
2026-07-27 14:20:03 info: Creando relación TripWorker con ID: 7
2026-07-27 14:20:03 info: Creando relación TripWorker con ID: 7
2026-07-27 14:20:03 info: Relación TripWorker creada exitosamente (ID: 788)
2026-07-27 14:20:03 info: Relación TripWorker creada exitosamente (ID: 789)
2026-07-27 14:20:06 info: root - Busca todas las plantillas de viaje
2026-07-27 14:20:17 info: root - Entra a buscar las sucursales
2026-07-27 14:20:18 info: root - Entra a buscar los viajes(index_branch_date) 
2026-07-27 14:20:41 info: root - Entra a buscar las sucursales
2026-07-27 14:20:42 info: root - Entra a buscar los tickets de una sucursal en el dia 
2026-07-27 14:20:42 info: TripController->getTicketDate: TicketsNotFound
2026-07-27 14:20:44 info: root - Entra a buscar los viajes de una fecha dada
2026-07-27 14:20:44 info: datos recibidos
2026-07-27 14:20:44 info: {"branch_id":7,"date":"2026-07-27","trips":false}
2026-07-27 14:20:44 info: TripController->getTripDate: searchDate=2026-07-27
2026-07-27 14:20:56 info: root - Entra a buscar los viajes por tramo de una fecha dada
2026-07-27 14:20:56 info: TripController->getTripDateBySegment: datos recibidos
2026-07-27 14:20:56 info: {"branch_id":7,"origin_id":13,"destination_id":33,"date":"2026-07-27"}
2026-07-27 14:20:56 info: TripController->getTripDateBySegment: branch_id=7 origin_id=13 destination_id=33 date=2026-07-27
2026-07-27 14:20:56 info: TripController->getTripDateBySegment: currentChileDate=2026-07-27 searchDate=2026-07-27
2026-07-27 14:20:56 info: TripController->getTripDateBySegment: viajes encontrados para sucursal=7 fecha=2026-07-27 => 0
2026-07-27 14:21:00 info: root - Entra a buscar los viajes por tramo de una fecha dada
2026-07-27 14:21:00 info: TripController->getTripDateBySegment: datos recibidos
2026-07-27 14:21:00 info: {"branch_id":7,"origin_id":14,"destination_id":33,"date":"2026-07-27"}
2026-07-27 14:21:00 info: TripController->getTripDateBySegment: branch_id=7 origin_id=14 destination_id=33 date=2026-07-27
2026-07-27 14:21:00 info: TripController->getTripDateBySegment: currentChileDate=2026-07-27 searchDate=2026-07-27
2026-07-27 14:21:00 info: TripController->getTripDateBySegment: viajes encontrados para sucursal=7 fecha=2026-07-27 => 2
2026-07-27 14:21:00 info: TripController->getTripDateBySegment: trip=875 matchingTripFares=3
2026-07-27 14:21:00 info: TripController->getTripDateBySegment: trip=876 matchingTripFares=3
2026-07-27 14:21:00 info: TripController->getSegmentStopMinutes: stopType=origin routeStopId=1 tripStopId=1 minutes=0
2026-07-27 14:21:00 info: TripController->getSegmentStopMinutes: stopType=origin routeStopId=1 candidates=[{"route_stop_id":1,"minutes_from_origin":0},{"route_stop_id":2,"minutes_from_origin":60},{"route_stop_id":3,"minutes_from_origin":240},{"route_stop_id":4,"minutes_from_origin":360},{"route_stop_id":5,"minutes_from_origin":600}]
2026-07-27 14:21:00 info: TripController->getSegmentStopMinutes: stopType=destination routeStopId=5 tripStopId=5 minutes=600
2026-07-27 14:21:00 info: TripController->getTripDateBySegment: trip=875 originMinutes=0 destinationMinutes=600 baseSchedule=15:00 adjustedSchedule=2026-07-27 15:00 adjustedArrival=2026-07-28 01:00 segmentPrice=40000
2026-07-27 14:21:00 info: TripController->getSegmentStopMinutes: stopType=origin routeStopId=1 tripStopId=1 minutes=0
2026-07-27 14:21:00 info: TripController->getSegmentStopMinutes: stopType=origin routeStopId=1 candidates=[{"route_stop_id":1,"minutes_from_origin":0},{"route_stop_id":2,"minutes_from_origin":60},{"route_stop_id":3,"minutes_from_origin":240},{"route_stop_id":4,"minutes_from_origin":360},{"route_stop_id":5,"minutes_from_origin":600}]
2026-07-27 14:21:00 info: TripController->getSegmentStopMinutes: stopType=destination routeStopId=5 tripStopId=5 minutes=600
2026-07-27 14:21:00 info: TripController->getTripDateBySegment: trip=876 originMinutes=0 destinationMinutes=600 baseSchedule=15:30 adjustedSchedule=2026-07-27 15:30 adjustedArrival=2026-07-28 01:30 segmentPrice=40000
2026-07-27 14:21:53 info: Entra a buscar las sucursales en el login
2026-07-27 14:22:06 info: Entrando a loguearse
2026-07-27 14:22:06 info: datos recibidos al loguerase
2026-07-27 14:22:06 info: {"email":"root","password":"123456","branch_id":null}
2026-07-27 14:22:10 info: root - Obtiene las ventas mensuales
2026-07-27 14:22:10 info: Datos recibidos al obtener las ventas mensuales
2026-07-27 14:22:10 info: {"type":"Negocio","branch_id":null,"company_id":6,"month":"2026-07"}
2026-07-27 14:22:13 info: root - Entra a buscar las sucursales
2026-07-27 14:22:14 info: root - Entra a buscar los tickets de una sucursal en el dia 
2026-07-27 14:22:14 info: TripController->getTicketDate: TicketsNotFound
2026-07-27 14:22:17 info: root - Entra a buscar los viajes de una fecha dada
2026-07-27 14:22:17 info: datos recibidos
2026-07-27 14:22:17 info: {"branch_id":7,"date":"2026-07-27","trips":false}
2026-07-27 14:22:17 info: TripController->getTripDate: searchDate=2026-07-27
2026-07-27 14:22:27 info: root - Entra a buscar los viajes por tramo de una fecha dada
2026-07-27 14:22:27 info: TripController->getTripDateBySegment: datos recibidos
2026-07-27 14:22:27 info: {"branch_id":7,"origin_id":14,"destination_id":33,"date":"2026-07-27"}
2026-07-27 14:22:27 info: TripController->getTripDateBySegment: branch_id=7 origin_id=14 destination_id=33 date=2026-07-27
2026-07-27 14:22:27 info: TripController->getTripDateBySegment: currentChileDate=2026-07-27 searchDate=2026-07-27
2026-07-27 14:22:27 info: TripController->getTripDateBySegment: viajes encontrados para sucursal=7 fecha=2026-07-27 => 2
2026-07-27 14:22:27 info: TripController->getTripDateBySegment: trip=875 matchingTripFares=3
2026-07-27 14:22:27 info: TripController->getTripDateBySegment: trip=876 matchingTripFares=3
2026-07-27 14:22:27 info: TripController->getSegmentStopMinutes: stopType=origin routeStopId=1 tripStopId=1 minutes=0
2026-07-27 14:22:27 info: TripController->getSegmentStopMinutes: stopType=origin routeStopId=1 candidates=[{"route_stop_id":1,"minutes_from_origin":0},{"route_stop_id":2,"minutes_from_origin":60},{"route_stop_id":3,"minutes_from_origin":240},{"route_stop_id":4,"minutes_from_origin":360},{"route_stop_id":5,"minutes_from_origin":600}]
2026-07-27 14:22:27 info: TripController->getSegmentStopMinutes: stopType=destination routeStopId=5 tripStopId=5 minutes=600
2026-07-27 14:22:27 info: TripController->getTripDateBySegment: trip=875 originMinutes=0 destinationMinutes=600 baseSchedule=15:00 adjustedSchedule=2026-07-27 15:00 adjustedArrival=2026-07-28 01:00 segmentPrice=40000
2026-07-27 14:22:27 info: TripController->getSegmentStopMinutes: stopType=origin routeStopId=1 tripStopId=1 minutes=0
2026-07-27 14:22:27 info: TripController->getSegmentStopMinutes: stopType=origin routeStopId=1 candidates=[{"route_stop_id":1,"minutes_from_origin":0},{"route_stop_id":2,"minutes_from_origin":60},{"route_stop_id":3,"minutes_from_origin":240},{"route_stop_id":4,"minutes_from_origin":360},{"route_stop_id":5,"minutes_from_origin":600}]
2026-07-27 14:22:27 info: TripController->getSegmentStopMinutes: stopType=destination routeStopId=5 tripStopId=5 minutes=600
2026-07-27 14:22:27 info: TripController->getTripDateBySegment: trip=876 originMinutes=0 destinationMinutes=600 baseSchedule=15:30 adjustedSchedule=2026-07-27 15:30 adjustedArrival=2026-07-28 01:30 segmentPrice=40000
2026-07-27 14:22:42 info: root - Crea un nuevo ticket web
2026-07-27 14:22:42 info: Datos recibidos al crear un ticket web
2026-07-27 14:22:42 info: {"trip_id":875,"branch_id":7,"quantity":2,"price":35000,"fare_segment_id":3,"total":70000,"seats":[1,2],"ticketItems":[{"trip_fare_id":322,"quantity":1},{"trip_fare_id":323,"quantity":1}],"date":"2026-07-27T18:22:41.487Z","method":"Efectivo"}
2026-07-27 14:22:42 info: Ticket creado exitosamente (ID: 236)
2026-07-27 14:22:44 info: root - Entra a buscar los tickets de una sucursal en el dia 
2026-07-27 14:22:52 info: root - Crea un nuevo ticket web
2026-07-27 14:22:52 info: Datos recibidos al crear un ticket web
2026-07-27 14:22:52 info: {"trip_id":875,"branch_id":7,"quantity":1,"price":30000,"fare_segment_id":3,"total":30000,"seats":[1],"ticketItems":[{"trip_fare_id":322,"quantity":1}],"date":"2026-07-27T18:22:52.966Z","method":"Efectivo"}
2026-07-27 14:22:52 info: Ticket creado exitosamente (ID: 237)
2026-07-27 14:22:54 info: root - Entra a buscar los tickets de una sucursal en el dia 
2026-07-27 14:23:11 info: root - Elimina el ticket con ID 237
2026-07-27 14:23:11 info: Ticket eliminado exitosamente (ID: 237)
2026-07-27 14:23:12 info: root - Entra a buscar los tickets de una sucursal en el dia 
2026-07-27 14:23:50 info: root - Entra a buscar los datos de los pasajes de una fecha dada
2026-07-27 14:23:50 info: Datos recibidos al obtener los pasajes de una fecha dada
2026-07-27 14:23:50 info: {"id":6,"type":"Company","date":"2026-07-27"}
2026-07-27 14:23:50 info: root - Entra a buscar las sucursales
2026-07-27 14:23:51 info: root - Entra a buscar los datos de los pasajes de una fecha dada
2026-07-27 14:23:51 info: Datos recibidos al obtener los pasajes de una fecha dada
2026-07-27 14:23:51 info: {"id":6,"type":"Company","date":"2026-07-27"}
2026-07-27 14:24:05 info: root - Busca todas las sucursales con workers, incluyendo siempre al worker actual
2026-07-27 15:06:10 info: Servidor escuchando en http://localhost:8000
2026-07-27 15:06:10 info: Conexión a la base de datos exitosa
2026-07-27 15:06:11 info: root - Entra a buscar las sucursales
2026-07-27 15:06:12 info: root - Entra a buscar los tickets de una sucursal en el dia 
2026-07-27 15:06:16 info: root - Entra a buscar los viajes de una fecha dada
2026-07-27 15:06:16 info: datos recibidos
2026-07-27 15:06:16 info: {"branch_id":7,"date":"2026-07-27","trips":false}
2026-07-27 15:06:16 info: TripController->getTripDate: searchDate=2026-07-27
2026-07-27 15:06:26 info: root - Entra a buscar los viajes por tramo de una fecha dada
2026-07-27 15:06:26 info: TripController->getTripDateBySegment: datos recibidos
2026-07-27 15:06:26 info: {"branch_id":7,"origin_id":14,"destination_id":33,"date":"2026-07-27"}
2026-07-27 15:06:26 info: TripController->getTripDateBySegment: branch_id=7 origin_id=14 destination_id=33 date=2026-07-27
2026-07-27 15:06:26 info: TripController->getTripDateBySegment: currentChileDate=2026-07-27 searchDate=2026-07-27
2026-07-27 15:06:26 info: TripController->getTripDateBySegment: viajes encontrados para sucursal=7 fecha=2026-07-27 => 2
2026-07-27 15:06:26 info: TripController->getTripDateBySegment: trip=875 matchingTripFares=3
2026-07-27 15:06:26 info: TripController->getTripDateBySegment: trip=876 matchingTripFares=3
2026-07-27 15:06:26 info: TripController->getSegmentStopMinutes: stopType=origin routeStopId=1 tripStopId=1 minutes=0
2026-07-27 15:06:26 info: TripController->getSegmentStopMinutes: stopType=origin routeStopId=1 candidates=[{"route_stop_id":1,"minutes_from_origin":0},{"route_stop_id":2,"minutes_from_origin":60},{"route_stop_id":3,"minutes_from_origin":240},{"route_stop_id":4,"minutes_from_origin":360},{"route_stop_id":5,"minutes_from_origin":600}]
2026-07-27 15:06:26 info: TripController->getSegmentStopMinutes: stopType=destination routeStopId=5 tripStopId=5 minutes=600
2026-07-27 15:06:26 info: TripController->getTripDateBySegment: trip=875 originMinutes=0 destinationMinutes=600 baseSchedule=15:00 adjustedSchedule=2026-07-27 15:00 adjustedArrival=2026-07-28 01:00 segmentPrice=40000
2026-07-27 15:06:26 info: TripController->getSegmentStopMinutes: stopType=origin routeStopId=1 tripStopId=1 minutes=0
2026-07-27 15:06:26 info: TripController->getSegmentStopMinutes: stopType=origin routeStopId=1 candidates=[{"route_stop_id":1,"minutes_from_origin":0},{"route_stop_id":2,"minutes_from_origin":60},{"route_stop_id":3,"minutes_from_origin":240},{"route_stop_id":4,"minutes_from_origin":360},{"route_stop_id":5,"minutes_from_origin":600}]
2026-07-27 15:06:26 info: TripController->getSegmentStopMinutes: stopType=destination routeStopId=5 tripStopId=5 minutes=600
2026-07-27 15:06:26 info: TripController->getTripDateBySegment: trip=876 originMinutes=0 destinationMinutes=600 baseSchedule=15:30 adjustedSchedule=2026-07-27 15:30 adjustedArrival=2026-07-28 01:30 segmentPrice=40000
2026-07-27 15:06:45 info: Entra a buscar las sucursales en el login
2026-07-27 15:06:52 info: Entrando a loguearse
2026-07-27 15:06:52 info: datos recibidos al loguerase
2026-07-27 15:06:52 info: {"email":"root","password":"123456","branch_id":null}
2026-07-27 15:06:55 info: root - Obtiene las ventas mensuales
2026-07-27 15:06:55 info: Datos recibidos al obtener las ventas mensuales
2026-07-27 15:06:55 info: {"type":"Negocio","branch_id":null,"company_id":6,"month":"2026-07"}
2026-07-27 15:06:58 info: root - Entra a buscar las sucursales
2026-07-27 15:06:59 info: root - Entra a buscar los tickets de una sucursal en el dia 
2026-07-27 15:07:02 info: root - Entra a buscar los viajes de una fecha dada
2026-07-27 15:07:02 info: datos recibidos
2026-07-27 15:07:02 info: {"branch_id":7,"date":"2026-07-27","trips":false}
2026-07-27 15:07:02 info: TripController->getTripDate: searchDate=2026-07-27
2026-07-27 15:07:10 info: root - Entra a buscar los viajes por tramo de una fecha dada
2026-07-27 15:07:10 info: TripController->getTripDateBySegment: datos recibidos
2026-07-27 15:07:10 info: {"branch_id":7,"origin_id":14,"destination_id":33,"date":"2026-07-27"}
2026-07-27 15:07:10 info: TripController->getTripDateBySegment: branch_id=7 origin_id=14 destination_id=33 date=2026-07-27
2026-07-27 15:07:10 info: TripController->getTripDateBySegment: currentChileDate=2026-07-27 searchDate=2026-07-27
2026-07-27 15:07:10 info: TripController->getTripDateBySegment: viajes encontrados para sucursal=7 fecha=2026-07-27 => 2
2026-07-27 15:07:10 info: TripController->getTripDateBySegment: trip=875 matchingTripFares=3
2026-07-27 15:07:10 info: TripController->getTripDateBySegment: trip=876 matchingTripFares=3
2026-07-27 15:07:10 info: TripController->getSegmentStopMinutes: stopType=origin routeStopId=1 tripStopId=1 minutes=0
2026-07-27 15:07:10 info: TripController->getSegmentStopMinutes: stopType=origin routeStopId=1 candidates=[{"route_stop_id":1,"minutes_from_origin":0},{"route_stop_id":2,"minutes_from_origin":60},{"route_stop_id":3,"minutes_from_origin":240},{"route_stop_id":4,"minutes_from_origin":360},{"route_stop_id":5,"minutes_from_origin":600}]
2026-07-27 15:07:10 info: TripController->getSegmentStopMinutes: stopType=destination routeStopId=5 tripStopId=5 minutes=600
2026-07-27 15:07:10 info: TripController->getTripDateBySegment: trip=875 originMinutes=0 destinationMinutes=600 baseSchedule=15:00 adjustedSchedule=2026-07-27 15:00 adjustedArrival=2026-07-28 01:00 segmentPrice=40000
2026-07-27 15:07:10 info: TripController->getSegmentStopMinutes: stopType=origin routeStopId=1 tripStopId=1 minutes=0
2026-07-27 15:07:10 info: TripController->getSegmentStopMinutes: stopType=origin routeStopId=1 candidates=[{"route_stop_id":1,"minutes_from_origin":0},{"route_stop_id":2,"minutes_from_origin":60},{"route_stop_id":3,"minutes_from_origin":240},{"route_stop_id":4,"minutes_from_origin":360},{"route_stop_id":5,"minutes_from_origin":600}]
2026-07-27 15:07:10 info: TripController->getSegmentStopMinutes: stopType=destination routeStopId=5 tripStopId=5 minutes=600
2026-07-27 15:07:10 info: TripController->getTripDateBySegment: trip=876 originMinutes=0 destinationMinutes=600 baseSchedule=15:30 adjustedSchedule=2026-07-27 15:30 adjustedArrival=2026-07-28 01:30 segmentPrice=40000
2026-07-27 15:07:32 info: root - Crea un nuevo ticket web
2026-07-27 15:07:32 info: Datos recibidos al crear un ticket web
2026-07-27 15:07:32 info: {"trip_id":875,"branch_id":7,"quantity":1,"price":35000,"fare_segment_id":3,"total":35000,"seats":[3],"ticketItems":[{"trip_fare_id":324,"quantity":1}],"date":"2026-07-27T19:07:31.286Z","method":"Efectivo"}
2026-07-27 15:07:32 info: Ticket creado exitosamente (ID: 238)
2026-07-27 15:07:34 info: root - Entra a buscar los tickets de una sucursal en el dia 
2026-07-27 15:07:37 info: root - Crea un nuevo ticket web
2026-07-27 15:07:37 info: Datos recibidos al crear un ticket web
2026-07-27 15:07:37 info: {"trip_id":875,"branch_id":7,"quantity":2,"price":35000,"fare_segment_id":3,"total":70000,"seats":[4,3],"ticketItems":[{"trip_fare_id":322,"quantity":1},{"trip_fare_id":323,"quantity":1}],"date":"2026-07-27T19:07:37.746Z","method":"Efectivo"}
2026-07-27 15:07:38 info: Ticket creado exitosamente (ID: 239)
2026-07-27 15:07:39 info: root - Entra a buscar los tickets de una sucursal en el dia 
2026-07-27 15:20:46 info: root - Elimina el ticket con ID 238
2026-07-27 15:20:46 info: Ticket eliminado exitosamente (ID: 238)
2026-07-27 15:20:47 info: root - Entra a buscar los tickets de una sucursal en el dia 
2026-07-27 15:23:21 info: Servidor escuchando en http://localhost:8000
2026-07-27 15:23:21 info: Conexión a la base de datos exitosa
2026-07-27 15:23:22 info: root - Entra a buscar los viajes de una fecha dada
2026-07-27 15:23:22 info: datos recibidos
2026-07-27 15:23:22 info: {"branch_id":7,"date":"2026-07-27","trips":false}
2026-07-27 15:23:22 info: TripController->getTripDate: searchDate=2026-07-27
2026-07-27 15:23:37 info: root - Entra a buscar los viajes por tramo de una fecha dada
2026-07-27 15:23:37 info: TripController->getTripDateBySegment: datos recibidos
2026-07-27 15:23:37 info: {"branch_id":7,"origin_id":14,"destination_id":33,"date":"2026-07-27"}
2026-07-27 15:23:38 info: TripController->getTripDateBySegment: branch_id=7 origin_id=14 destination_id=33 date=2026-07-27
2026-07-27 15:23:38 info: TripController->getTripDateBySegment: currentChileDate=2026-07-27 searchDate=2026-07-27
2026-07-27 15:23:38 info: TripController->getTripDateBySegment: viajes encontrados para sucursal=7 fecha=2026-07-27 => 2
2026-07-27 15:23:38 info: TripController->getTripDateBySegment: trip=875 matchingTripFares=3
2026-07-27 15:23:38 info: TripController->getTripDateBySegment: trip=876 matchingTripFares=3
2026-07-27 15:23:38 info: TripController->getSegmentStopMinutes: stopType=origin routeStopId=1 tripStopId=1 minutes=0
2026-07-27 15:23:38 info: TripController->getSegmentStopMinutes: stopType=origin routeStopId=1 candidates=[{"route_stop_id":1,"minutes_from_origin":0},{"route_stop_id":2,"minutes_from_origin":60},{"route_stop_id":3,"minutes_from_origin":240},{"route_stop_id":4,"minutes_from_origin":360},{"route_stop_id":5,"minutes_from_origin":600}]
2026-07-27 15:23:38 info: TripController->getSegmentStopMinutes: stopType=destination routeStopId=5 tripStopId=5 minutes=600
2026-07-27 15:23:38 info: TripController->getTripDateBySegment: trip=875 originMinutes=0 destinationMinutes=600 baseSchedule=15:00 adjustedSchedule=2026-07-27 15:00 adjustedArrival=2026-07-28 01:00 segmentPrice=40000
2026-07-27 15:23:38 info: TripController->getSegmentStopMinutes: stopType=origin routeStopId=1 tripStopId=1 minutes=0
2026-07-27 15:23:38 info: TripController->getSegmentStopMinutes: stopType=origin routeStopId=1 candidates=[{"route_stop_id":1,"minutes_from_origin":0},{"route_stop_id":2,"minutes_from_origin":60},{"route_stop_id":3,"minutes_from_origin":240},{"route_stop_id":4,"minutes_from_origin":360},{"route_stop_id":5,"minutes_from_origin":600}]
2026-07-27 15:23:38 info: TripController->getSegmentStopMinutes: stopType=destination routeStopId=5 tripStopId=5 minutes=600
2026-07-27 15:23:38 info: TripController->getTripDateBySegment: trip=876 originMinutes=0 destinationMinutes=600 baseSchedule=15:30 adjustedSchedule=2026-07-27 15:30 adjustedArrival=2026-07-28 01:30 segmentPrice=40000
2026-07-27 15:23:58 info: root - Entra a buscar los viajes de una fecha dada
2026-07-27 15:23:58 info: datos recibidos
2026-07-27 15:23:58 info: {"branch_id":7,"date":"2026-07-27","trips":false}
2026-07-27 15:23:58 info: TripController->getTripDate: searchDate=2026-07-27
2026-07-27 15:24:06 info: root - Entra a buscar los viajes por tramo de una fecha dada
2026-07-27 15:24:06 info: TripController->getTripDateBySegment: datos recibidos
2026-07-27 15:24:06 info: {"branch_id":7,"origin_id":14,"destination_id":33,"date":"2026-07-27"}
2026-07-27 15:24:06 info: TripController->getTripDateBySegment: branch_id=7 origin_id=14 destination_id=33 date=2026-07-27
2026-07-27 15:24:06 info: TripController->getTripDateBySegment: currentChileDate=2026-07-27 searchDate=2026-07-27
2026-07-27 15:24:06 info: TripController->getTripDateBySegment: viajes encontrados para sucursal=7 fecha=2026-07-27 => 2
2026-07-27 15:24:06 info: TripController->getTripDateBySegment: trip=875 matchingTripFares=3
2026-07-27 15:24:06 info: TripController->getTripDateBySegment: trip=876 matchingTripFares=3
2026-07-27 15:24:06 info: TripController->getSegmentStopMinutes: stopType=origin routeStopId=1 tripStopId=1 minutes=0
2026-07-27 15:24:06 info: TripController->getSegmentStopMinutes: stopType=origin routeStopId=1 candidates=[{"route_stop_id":1,"minutes_from_origin":0},{"route_stop_id":2,"minutes_from_origin":60},{"route_stop_id":3,"minutes_from_origin":240},{"route_stop_id":4,"minutes_from_origin":360},{"route_stop_id":5,"minutes_from_origin":600}]
2026-07-27 15:24:06 info: TripController->getSegmentStopMinutes: stopType=destination routeStopId=5 tripStopId=5 minutes=600
2026-07-27 15:24:06 info: TripController->getTripDateBySegment: trip=875 originMinutes=0 destinationMinutes=600 baseSchedule=15:00 adjustedSchedule=2026-07-27 15:00 adjustedArrival=2026-07-28 01:00 segmentPrice=40000
2026-07-27 15:24:06 info: TripController->getSegmentStopMinutes: stopType=origin routeStopId=1 tripStopId=1 minutes=0
2026-07-27 15:24:06 info: TripController->getSegmentStopMinutes: stopType=origin routeStopId=1 candidates=[{"route_stop_id":1,"minutes_from_origin":0},{"route_stop_id":2,"minutes_from_origin":60},{"route_stop_id":3,"minutes_from_origin":240},{"route_stop_id":4,"minutes_from_origin":360},{"route_stop_id":5,"minutes_from_origin":600}]
2026-07-27 15:24:06 info: TripController->getSegmentStopMinutes: stopType=destination routeStopId=5 tripStopId=5 minutes=600
2026-07-27 15:24:06 info: TripController->getTripDateBySegment: trip=876 originMinutes=0 destinationMinutes=600 baseSchedule=15:30 adjustedSchedule=2026-07-27 15:30 adjustedArrival=2026-07-28 01:30 segmentPrice=40000
2026-07-27 15:24:23 info: root - Crea un nuevo ticket web
2026-07-27 15:24:23 info: Datos recibidos al crear un ticket web
2026-07-27 15:24:23 info: {"trip_id":875,"branch_id":7,"quantity":1,"price":30000,"fare_segment_id":3,"total":30000,"seats":[8],"ticketItems":[{"trip_fare_id":322,"quantity":1}],"date":"2026-07-27T19:24:23.241Z","method":"Efectivo"}
2026-07-27 15:24:23 info: Ticket creado exitosamente (ID: 240)
2026-07-27 15:24:25 info: root - Entra a buscar los tickets de una sucursal en el dia 
2026-07-27 15:24:29 info: root - Crea un nuevo ticket web
2026-07-27 15:24:29 info: Datos recibidos al crear un ticket web
2026-07-27 15:24:29 info: {"trip_id":875,"branch_id":7,"quantity":1,"price":30000,"fare_segment_id":3,"total":30000,"seats":[8],"ticketItems":[{"trip_fare_id":322,"quantity":1}],"date":"2026-07-27T19:24:29.579Z","method":"Efectivo"}
2026-07-27 15:24:30 error: TicketController->store_web: Los asientos ya están reservados: 8
2026-07-27 15:25:56 info: root - Cierra sessión
2026-07-27 15:25:58 info: Entra a buscar las sucursales en el login
2026-07-27 16:06:13 info: root - Entra a buscar los viajes de una fecha dada
2026-07-27 16:06:13 info: datos recibidos
2026-07-27 16:06:13 info: {"branch_id":7,"date":"2026-07-27","trips":false}
2026-07-27 16:06:13 info: TripController->getTripDate: searchDate=2026-07-27
2026-07-27 16:06:22 info: root - Entra a buscar los viajes por tramo de una fecha dada
2026-07-27 16:06:22 info: TripController->getTripDateBySegment: datos recibidos
2026-07-27 16:06:22 info: {"branch_id":7,"origin_id":14,"destination_id":33,"date":"2026-07-27"}
2026-07-27 16:06:22 info: TripController->getTripDateBySegment: branch_id=7 origin_id=14 destination_id=33 date=2026-07-27
2026-07-27 16:06:22 info: TripController->getTripDateBySegment: currentChileDate=2026-07-27 searchDate=2026-07-27
2026-07-27 16:06:22 info: TripController->getTripDateBySegment: viajes encontrados para sucursal=7 fecha=2026-07-27 => 2
2026-07-27 16:06:22 info: TripController->getTripDateBySegment: trip=875 matchingTripFares=3
2026-07-27 16:06:22 info: TripController->getTripDateBySegment: trip=876 matchingTripFares=3
2026-07-27 16:06:22 info: TripController->getSegmentStopMinutes: stopType=origin routeStopId=1 tripStopId=1 minutes=0
2026-07-27 16:06:22 info: TripController->getSegmentStopMinutes: stopType=origin routeStopId=1 candidates=[{"route_stop_id":1,"minutes_from_origin":0},{"route_stop_id":2,"minutes_from_origin":60},{"route_stop_id":3,"minutes_from_origin":240},{"route_stop_id":4,"minutes_from_origin":360},{"route_stop_id":5,"minutes_from_origin":600}]
2026-07-27 16:06:22 info: TripController->getSegmentStopMinutes: stopType=destination routeStopId=5 tripStopId=5 minutes=600
2026-07-27 16:06:22 info: TripController->getTripDateBySegment: trip=875 originMinutes=0 destinationMinutes=600 baseSchedule=15:00 adjustedSchedule=2026-07-27 15:00 adjustedArrival=2026-07-28 01:00 segmentPrice=40000
2026-07-27 16:06:22 info: TripController->getSegmentStopMinutes: stopType=origin routeStopId=1 tripStopId=1 minutes=0
2026-07-27 16:06:22 info: TripController->getSegmentStopMinutes: stopType=origin routeStopId=1 candidates=[{"route_stop_id":1,"minutes_from_origin":0},{"route_stop_id":2,"minutes_from_origin":60},{"route_stop_id":3,"minutes_from_origin":240},{"route_stop_id":4,"minutes_from_origin":360},{"route_stop_id":5,"minutes_from_origin":600}]
2026-07-27 16:06:22 info: TripController->getSegmentStopMinutes: stopType=destination routeStopId=5 tripStopId=5 minutes=600
2026-07-27 16:06:22 info: TripController->getTripDateBySegment: trip=876 originMinutes=0 destinationMinutes=600 baseSchedule=15:30 adjustedSchedule=2026-07-27 15:30 adjustedArrival=2026-07-28 01:30 segmentPrice=40000
2026-07-27 16:20:47 info: Servidor escuchando en http://localhost:8000
2026-07-27 16:20:48 info: Conexión a la base de datos exitosa
2026-07-27 16:20:48 info: Entra a buscar las sucursales en el login
2026-07-27 16:20:49 info: Entrando a loguearse
2026-07-27 16:20:49 info: datos recibidos al loguerase
2026-07-27 16:20:49 info: {"email":"root","password":"123456","branch_id":null}
2026-07-27 16:20:52 info: root - Obtiene las ventas mensuales
2026-07-27 16:20:52 info: Datos recibidos al obtener las ventas mensuales
2026-07-27 16:20:52 info: {"type":"Negocio","branch_id":null,"company_id":6,"month":"2026-07"}
2026-07-27 16:20:55 info: root - Entra a buscar las sucursales
2026-07-27 16:20:56 info: root - Entra a buscar los tickets de una sucursal en el dia 
2026-07-27 16:20:59 info: root - Entra a buscar los viajes de una fecha dada
2026-07-27 16:20:59 info: datos recibidos
2026-07-27 16:20:59 info: {"branch_id":7,"date":"2026-07-27","trips":false}
2026-07-27 16:21:00 info: TripController->getTripDate: searchDate=2026-07-27
2026-07-27 16:21:09 info: root - Entra a buscar los viajes por tramo de una fecha dada
2026-07-27 16:21:09 info: TripController->getTripDateBySegment: datos recibidos
2026-07-27 16:21:09 info: {"branch_id":7,"origin_id":14,"destination_id":33,"date":"2026-07-27"}
2026-07-27 16:21:09 info: TripController->getTripDateBySegment: branch_id=7 origin_id=14 destination_id=33 date=2026-07-27
2026-07-27 16:21:09 info: TripController->getTripDateBySegment: currentChileDate=2026-07-27 searchDate=2026-07-27
2026-07-27 16:21:09 info: TripController->getTripDateBySegment: viajes encontrados para sucursal=7 fecha=2026-07-27 => 2
2026-07-27 16:21:09 info: TripController->getTripDateBySegment: trip=875 matchingTripFares=3
2026-07-27 16:21:09 info: TripController->getTripDateBySegment: trip=876 matchingTripFares=3
2026-07-27 16:21:09 info: TripController->getSegmentStopMinutes: stopType=origin routeStopId=1 tripStopId=1 minutes=0
2026-07-27 16:21:09 info: TripController->getSegmentStopMinutes: stopType=origin routeStopId=1 candidates=[{"route_stop_id":1,"minutes_from_origin":0},{"route_stop_id":2,"minutes_from_origin":60},{"route_stop_id":3,"minutes_from_origin":240},{"route_stop_id":4,"minutes_from_origin":360},{"route_stop_id":5,"minutes_from_origin":600}]
2026-07-27 16:21:09 info: TripController->getSegmentStopMinutes: stopType=destination routeStopId=5 tripStopId=5 minutes=600
2026-07-27 16:21:09 info: TripController->getTripDateBySegment: trip=875 originMinutes=0 destinationMinutes=600 baseSchedule=15:00 adjustedSchedule=2026-07-27 15:00 adjustedArrival=2026-07-28 01:00 segmentPrice=40000
2026-07-27 16:21:09 info: TripController->getSegmentStopMinutes: stopType=origin routeStopId=1 tripStopId=1 minutes=0
2026-07-27 16:21:09 info: TripController->getSegmentStopMinutes: stopType=origin routeStopId=1 candidates=[{"route_stop_id":1,"minutes_from_origin":0},{"route_stop_id":2,"minutes_from_origin":60},{"route_stop_id":3,"minutes_from_origin":240},{"route_stop_id":4,"minutes_from_origin":360},{"route_stop_id":5,"minutes_from_origin":600}]
2026-07-27 16:21:09 info: TripController->getSegmentStopMinutes: stopType=destination routeStopId=5 tripStopId=5 minutes=600
2026-07-27 16:21:09 info: TripController->getTripDateBySegment: trip=876 originMinutes=0 destinationMinutes=600 baseSchedule=15:30 adjustedSchedule=2026-07-27 15:30 adjustedArrival=2026-07-28 01:30 segmentPrice=40000
2026-07-27 16:21:20 info: root - Crea un nuevo ticket web
2026-07-27 16:21:20 info: Datos recibidos al crear un ticket web
2026-07-27 16:21:20 info: {"trip_id":875,"branch_id":7,"quantity":1,"price":40000,"fare_segment_id":3,"total":40000,"seats":[7],"ticketItems":[{"trip_fare_id":323,"quantity":1}],"date":"2026-07-27T20:21:19.543Z","method":"Efectivo"}
2026-07-27 16:21:20 info: Ticket creado exitosamente (ID: 241)
2026-07-27 16:21:21 info: root - Entra a buscar los tickets de una sucursal en el dia 
2026-07-27 16:21:30 info: Servidor escuchando en http://localhost:8000
2026-07-27 16:21:31 info: Conexión a la base de datos exitosa
2026-07-27 16:21:31 info: root - Crea un nuevo ticket web
2026-07-27 16:21:31 info: Datos recibidos al crear un ticket web
2026-07-27 16:21:31 info: {"trip_id":875,"branch_id":7,"quantity":1,"price":30000,"fare_segment_id":3,"total":30000,"seats":[7],"ticketItems":[{"trip_fare_id":322,"quantity":1}],"date":"2026-07-27T20:21:27.012Z","method":"Efectivo"}
2026-07-27 16:21:31 info: Ticket creado exitosamente (ID: 242)
2026-07-27 16:21:33 info: root - Entra a buscar los tickets de una sucursal en el dia 
2026-07-27 16:21:42 info: root - Cierra sessión
2026-07-27 16:21:44 info: Entra a buscar las sucursales en el login
2026-07-27 16:22:01 info: root - Entra a buscar los viajes de una fecha dada
2026-07-27 16:22:01 info: datos recibidos
2026-07-27 16:22:01 info: {"branch_id":7,"date":"2026-07-27","trips":false}
2026-07-27 16:22:01 info: TripController->getTripDate: searchDate=2026-07-27
2026-07-27 16:23:47 info: root - Entra a buscar los viajes por tramo de una fecha dada
2026-07-27 16:23:47 info: TripController->getTripDateBySegment: datos recibidos
2026-07-27 16:23:47 info: {"branch_id":7,"origin_id":14,"destination_id":33,"date":"2026-07-27"}
2026-07-27 16:23:47 info: TripController->getTripDateBySegment: branch_id=7 origin_id=14 destination_id=33 date=2026-07-27
2026-07-27 16:23:47 info: TripController->getTripDateBySegment: currentChileDate=2026-07-27 searchDate=2026-07-27
2026-07-27 16:23:47 info: TripController->getTripDateBySegment: viajes encontrados para sucursal=7 fecha=2026-07-27 => 2
2026-07-27 16:23:48 info: TripController->getTripDateBySegment: trip=875 matchingTripFares=3
2026-07-27 16:23:48 info: TripController->getTripDateBySegment: trip=876 matchingTripFares=3
2026-07-27 16:23:48 info: TripController->getSegmentStopMinutes: stopType=origin routeStopId=1 tripStopId=1 minutes=0
2026-07-27 16:23:48 info: TripController->getSegmentStopMinutes: stopType=origin routeStopId=1 candidates=[{"route_stop_id":1,"minutes_from_origin":0},{"route_stop_id":2,"minutes_from_origin":60},{"route_stop_id":3,"minutes_from_origin":240},{"route_stop_id":4,"minutes_from_origin":360},{"route_stop_id":5,"minutes_from_origin":600}]
2026-07-27 16:23:48 info: TripController->getSegmentStopMinutes: stopType=destination routeStopId=5 tripStopId=5 minutes=600
2026-07-27 16:23:48 info: TripController->getTripDateBySegment: trip=875 originMinutes=0 destinationMinutes=600 baseSchedule=15:00 adjustedSchedule=2026-07-27 15:00 adjustedArrival=2026-07-28 01:00 segmentPrice=40000
2026-07-27 16:23:48 info: TripController->getSegmentStopMinutes: stopType=origin routeStopId=1 tripStopId=1 minutes=0
2026-07-27 16:23:48 info: TripController->getSegmentStopMinutes: stopType=origin routeStopId=1 candidates=[{"route_stop_id":1,"minutes_from_origin":0},{"route_stop_id":2,"minutes_from_origin":60},{"route_stop_id":3,"minutes_from_origin":240},{"route_stop_id":4,"minutes_from_origin":360},{"route_stop_id":5,"minutes_from_origin":600}]
2026-07-27 16:23:48 info: TripController->getSegmentStopMinutes: stopType=destination routeStopId=5 tripStopId=5 minutes=600
2026-07-27 16:23:48 info: TripController->getTripDateBySegment: trip=876 originMinutes=0 destinationMinutes=600 baseSchedule=15:30 adjustedSchedule=2026-07-27 15:30 adjustedArrival=2026-07-28 01:30 segmentPrice=40000
2026-07-27 16:27:39 info: root - Verifica asientos reservados
2026-07-27 16:27:39 info: Datos recibidos al verificar asientos reservados
2026-07-27 16:27:39 info: {"trip_id":875,"seats":[7,8,20],"fare_segment_id":3}
2026-07-27 16:31:52 info: Entra a buscar las sucursales en el login
2026-07-27 16:39:31 info: Entra a buscar las sucursales en el login
2026-07-27 16:46:25 info: Entra a buscar las sucursales en el login
2026-07-27 16:46:38 info: Entrando a loguearse
2026-07-27 16:46:38 info: datos recibidos al loguerase
2026-07-27 16:46:38 info: {"email":"root","password":"KwerHjXJ4aII8QJ","branch_id":null}
2026-07-27 16:46:40 info: root - Obtiene las ventas mensuales
2026-07-27 16:46:40 info: Datos recibidos al obtener las ventas mensuales
2026-07-27 16:46:40 info: {"type":"Negocio","branch_id":null,"company_id":6,"month":"2026-07"}
2026-07-27 16:46:40 error: Error al calcular la tasa de ocupación diaria: Unknown column 'Trip.code' in 'SELECT'
2026-07-27 16:46:40 error: TicketController->getMonthlySales:Unknown column 'Trip.code' in 'SELECT'
2026-07-27 16:46:43 info: root - Entra a buscar las sucursales
2026-07-27 16:46:44 info: root - Entra a buscar los viajes(index_branch_date) 
2026-07-27 16:46:44 error: TripController->index: Unknown column 'Trip.code' in 'SELECT'
2026-07-27 16:46:46 info: root - Entra a buscar los viajes(index_branch_date) 
2026-07-27 16:46:46 error: TripController->index: Unknown column 'Trip.code' in 'SELECT'
2026-07-27 16:46:54 info: root - Entra a buscar las sucursales
2026-07-27 16:46:55 info: root - Entra a buscar los tickets de una sucursal en el dia 
2026-07-27 16:46:55 error: TicketController->getTicketDate: Unknown column 'trip.code' in 'SELECT'
2026-07-27 16:46:57 info: root - Entra a buscar las sucursales
2026-07-27 16:46:58 info: root - Entra a buscar los viajes(index_branch_date) 
2026-07-27 16:46:58 error: TripController->index: Unknown column 'Trip.code' in 'SELECT'
2026-07-27 16:47:31 info: root - Entra a buscar las sucursales
2026-07-27 16:47:32 info: root - Entra a buscar los tickets de una sucursal en el dia 
2026-07-27 16:47:32 error: TicketController->getTicketDate: Unknown column 'trip.code' in 'SELECT'
2026-07-27 16:47:33 info: root - Entra a buscar las sucursales
2026-07-27 16:47:34 info: root - Entra a buscar los viajes(index_branch_date) 
2026-07-27 16:47:34 error: TripController->index: Unknown column 'Trip.code' in 'SELECT'
2026-07-27 16:47:36 info: root - Entra a buscar los viajes(index_branch_date) 
2026-07-27 16:47:36 error: TripController->index: Unknown column 'Trip.code' in 'SELECT'
2026-07-27 16:47:47 info: root - Entra a buscar las rutas
2026-07-27 16:47:47 error: RouteController->index:Unknown column 'Route.code' in 'SELECT'
2026-07-27 16:47:58 info: root - Entra a buscar las sucursales
2026-07-27 16:47:59 info: root - Entra a buscar los dispositivos de una sucursal dada
2026-07-27 16:48:01 info: root - Entra a buscar las ubicaciones
2026-07-27 16:48:03 info: root - Entra a buscar las rutas
2026-07-27 16:48:03 error: RouteController->index:Unknown column 'Route.code' in 'SELECT'
2026-07-27 16:48:26 info: root - Entra a buscar las sucursales
2026-07-27 16:48:28 info: root - Entra a buscar los viajes(index_branch_date) 
2026-07-27 16:48:28 error: TripController->index: Unknown column 'Trip.code' in 'SELECT'
2026-07-27 16:48:29 info: root - Entra a buscar los viajes(index_branch_date) 
2026-07-27 16:48:29 error: TripController->index: Unknown column 'Trip.code' in 'SELECT'
2026-07-27 16:48:40 info: root - Entra a buscar las rutas
2026-07-27 16:48:40 error: RouteController->index:Unknown column 'Route.code' in 'SELECT'
2026-07-27 16:49:41 info: root - Entra a buscar las sucursales
2026-07-27 16:49:42 info: root - Entra a buscar los tickets de una sucursal en el dia 
2026-07-27 16:49:42 error: TicketController->getTicketDate: Unknown column 'trip.code' in 'SELECT'
2026-07-27 16:49:47 info: root - Entra a buscar los tickets de una sucursal en el dia 
2026-07-27 16:49:47 error: TicketController->getTicketDate: Unknown column 'trip.code' in 'SELECT'
2026-07-27 16:50:51 info: root - Entra a buscar las sucursales
2026-07-27 16:50:53 info: root - Entra a buscar los tickets de una sucursal en el dia 
2026-07-27 16:50:53 info: root - Obtiene las ventas mensuales
2026-07-27 16:50:53 info: Datos recibidos al obtener las ventas mensuales
2026-07-27 16:50:53 info: {"type":"Negocio","branch_id":null,"company_id":6,"month":"2026-07"}
2026-07-27 16:50:53 info: TripController->getTicketDate: TicketsNotFound
2026-07-27 16:50:54 info: root - Entra a buscar las sucursales
2026-07-27 16:50:55 info: root - Entra a buscar los viajes(index_branch_date) 
2026-07-27 16:50:57 info: root - Entra a buscar los viajes(index_branch_date) 
2026-07-27 16:51:08 info: root - Entra a buscar las sucursales
2026-07-27 16:51:09 info: root - Entra a buscar los tickets de una sucursal en el dia 
2026-07-27 16:51:09 info: TripController->getTicketDate: TicketsNotFound
2026-07-27 16:51:11 info: root - Entra a buscar los tickets de una sucursal en el dia 
2026-07-27 16:51:46 info: root - Entra a buscar las sucursales
2026-07-27 16:51:47 info: root - Entra a buscar los viajes(index_branch_date) 
2026-07-27 16:51:48 info: root - Entra a buscar los viajes(index_branch_date) 
2026-07-27 16:51:52 info: root - Entra a buscar las rutas
2026-07-27 16:52:00 info: root - Entra a buscar las ubicaciones (origen y destino)
2026-07-27 16:52:09 info: root - Entra a buscar las compañías
2026-07-27 16:52:15 info: root - Entra a buscar los trabajadores
2026-07-27 16:52:24 info: root - entra a buscar los roles de type Sistema
2026-07-27 16:53:15 info: root - Crea un nuevo trabajador
2026-07-27 16:53:15 info: Datos recibidos al crear un trabajador
2026-07-27 16:53:15 info: {"name":"Yasmany","user":"yasmany","email":"yasmany@klint.cl","phone":"+56935878785","password":"Jason.89","rut":"12.124.524-8","role_id":"1","user_id":null}
2026-07-27 16:53:15 info: Verificando existencia por email, RUT o usuario en el repositorio
2026-07-27 16:53:16 info: root - Entra a buscar los trabajadores
2026-07-27 16:53:22 info: root - Entra a buscar las sucursales
2026-07-27 16:53:24 info: root - Busca todas las relaciones Branch-Worker
2026-07-27 16:53:36 info: root - Busca todas las relaciones Branch-Worker
2026-07-27 16:53:40 info: root - Entra a la ruta unificada de Asociar trabajador a la sucursal
2026-07-27 16:53:45 info: root - Crea una nueva relación Branch-Worker
2026-07-27 16:53:46 info: root - Busca todas las relaciones Branch-Worker
2026-07-27 16:54:12 info: root - Entra a buscar las compañías
2026-07-27 16:58:14 info: root - Entra a buscar los datos de los pasajes de una fecha dada
2026-07-27 16:58:14 info: Datos recibidos al obtener los pasajes de una fecha dada
2026-07-27 16:58:14 info: {"id":6,"type":"Company","date":"2026-07-27"}
2026-07-27 16:58:14 info: root - Entra a buscar las sucursales
2026-07-27 16:58:15 info: root - Entra a buscar los datos de los pasajes de una fecha dada
2026-07-27 16:58:15 info: Datos recibidos al obtener los pasajes de una fecha dada
2026-07-27 16:58:15 info: {"id":6,"type":"Company","date":"2026-07-27"}
2026-07-27 16:59:35 info: root - Entra a buscar las sucursales
2026-07-27 16:59:36 info: root - Entra a buscar los tickets de una sucursal en el dia 
2026-07-27 16:59:36 info: TripController->getTicketDate: TicketsNotFound
2026-07-27 16:59:38 info: root - Entra a buscar los tickets de una sucursal en el dia 
2026-07-27 17:00:28 info: root - Entra a buscar las sucursales
2026-07-27 17:00:30 info: root - Entra a buscar los tickets de una sucursal en el dia 
2026-07-27 17:00:30 info: root - Obtiene las ventas mensuales
2026-07-27 17:00:30 info: Datos recibidos al obtener las ventas mensuales
2026-07-27 17:00:30 info: {"type":"Negocio","branch_id":null,"company_id":6,"month":"2026-07"}
2026-07-27 17:00:30 info: TripController->getTicketDate: TicketsNotFound
2026-07-27 17:00:31 info: root - Entra a buscar las sucursales
2026-07-27 17:00:32 info: root - Entra a buscar los viajes(index_branch_date) 
2026-07-27 17:00:35 info: root - Entra a buscar los viajes(index_branch_date) 
2026-07-27 17:01:05 info: root - Entra a buscar las sucursales
2026-07-27 17:01:06 info: root - Entra a buscar los tickets de una sucursal en el dia 
2026-07-27 17:01:06 info: TripController->getTicketDate: TicketsNotFound
2026-07-27 17:02:18 info: root - Obtiene las ventas mensuales
2026-07-27 17:02:18 info: Datos recibidos al obtener las ventas mensuales
2026-07-27 17:02:18 info: {"type":"Negocio","branch_id":null,"company_id":6,"month":"2026-07"}
2026-07-27 17:02:27 info: root - Entra a buscar las sucursales
2026-07-27 17:02:28 info: root - entra a buscar las incidencias
2026-07-27 17:02:28 info: Datos recibidos buscar las incidencias
2026-07-27 17:02:28 info: {"company_id":6}
2026-07-27 17:02:28 info: JSON.stringify(incidents)
2026-07-27 17:02:28 info: []
2026-07-27 17:02:31 info: root - Busca todas las sucursales con workers, incluyendo siempre al worker actual
2026-07-27 17:03:18 info: root - Entra a buscar las sucursales
2026-07-27 17:03:19 info: root - Entra a buscar los viajes(index_branch_date) 
2026-07-27 17:03:23 info: root - Entra a buscar los viajes(index_branch_date) 
2026-07-27 17:03:37 info: root - Entra a buscar las sucursales
2026-07-27 17:03:38 info: root - Entra a buscar los tickets de una sucursal en el dia 
2026-07-27 17:03:38 info: TripController->getTicketDate: TicketsNotFound
2026-07-27 17:03:40 info: root - Entra a buscar los tickets de una sucursal en el dia