consultar_clientes
ChatGPTUse this when the user asks who a customer is, searches a customer by name or phone, or asks how many trips that customer has requested, completed, cancelled, active, or completed as operationally countable. It also returns promotion points by active campaign, prizes won, whether a reward was selected or claimed, and whether it was delivered or redeemed. Repeated passenger records with the same normalized phone in Fusagasugá are reconciled as one customer. Cancelled requests before driver assignment are reported separately from trips.
consultar_clientes_nuevos
ChatGPTUse this when the user asks how many new customers signed up today, how many customers have their first registration on a date, or asks for today's new-customer count so far. A customer counts only on the date of the first record for their normalized phone. For today, the count runs from 00:00 to the current local time in Colombia and returns the exact cutoff timestamp.
consultar_clientes_por_conductor
ChatGPTUse this when the user asks how many unique customers a driver has served, which customers travelled with that driver, how many are repeat customers, or how many trips each customer had with the driver. It matches drivers by name, phone or current plate and is historical unless a Colombia date range is provided.
consultar_historial_cliente_conductores
ChatGPTUse this when the user asks how many times a customer travelled with each driver, which drivers served that customer, when the customer first registered, or whether the customer, driver, operator or system cancelled the customer's requests. It reconciles repeated customer records by normalized phone and is historical unless a Colombia date range is provided.
consultar_nuevos_conductores
ChatGPTUse this when the user asks which drivers entered Argodrive for the first time, how many true new entries exist, the USD 5 total, who managed them at first entry, or whether their first-entry charge is paid or pending. This tool excludes manager transfers and repeated/recreated driver records; never infer new-driver status from a driver's created_at field, current manager, vehicle or plate.
consultar_pagos_conductores
ChatGPTUse this when the user asks how many driver payments were recorded, who is paid/current, who owes, amounts collected or payment detail for a Wednesday-to-Tuesday billing week.
consultar_solicitudes_canceladas
ChatGPTUse this when the user asks which customer requests counted as cancelled in resumen_operativo. Returns customer name and phone, pickup, destination, cancellation time, audited actor and reason. Includes requests with and without an assigned driver by default. Dates select requests by their creation date in Colombia time, matching resumen_operativo.
consultar_totales_clientes_conductores
ChatGPTUse this when the user asks how many customers or drivers Argodrive has in total as of a date, or how many unique customers and true first-time drivers entered on that day. Customer totals deduplicate by phone; daily drivers exclude manager transfers and recreated profiles. For today, counts stop at the current time and include the local cutoff timestamp. Dates use Colombia time.
consultar_viajes
ChatGPTUse this when the user needs a list of trips for a date range, optionally filtered by trip status or driver or customer name/phone. Every trip returns the requesting customer's ID, name and phone, plus pickup and destination. Cancelled trips include the audited cancellation actor, actor name, reason and timestamp. The period is based on assignment time in Colombia.
fetch
ChatGPTUse this when a previous search returned an Argodrive item id and the user needs its full read-only detail.
informacion_piquera
ChatGPTUse this when the user wants general information about Exclusivos Fusagasugá, its current status, administrators, enabled services, total unique customers, total and active drivers, or how many customers and true first-time drivers have signed up today so far. The response always includes global totals, today's live counts, and the local cutoff time.
listar_administradores
ChatGPTUse this when the user asks who the administrators, operators or driver managers are in Exclusivos Fusagasugá and how many drivers each one manages.
ranking_conductores
ChatGPTUse this when the user asks which drivers completed the most trips today, this week, this month or during a date range. Ranking uses completed trips that count operationally and also reports total completed and non-counting trips. Dates use Colombia time.
resumen_operativo
ChatGPTUse this when the user asks how Argodrive operated on a date: requests, trips assigned, completed, cancelled, active trips, or available and busy drivers. Dates use Colombia time.
search
ChatGPTUse this when the user asks who a person is or wants to find an administrator, conductor, customer or the Exclusivos Fusagasugá agency by name, phone fragment or vehicle plate. Customer results include the registered phone number.
