The sales report atDocumentation Index
Fetch the complete documentation index at: https://mintlify.com/EduCabrera-k/Menu_Hamburguesas/llms.txt
Use this file to discover all available pages before exploring further.
/reporte gives an at-a-glance summary of the restaurant’s performance for the current calendar day. It displays total revenue and a count of completed orders at the top, followed by a detailed table of every dispatched order. Orders appear in this report only after kitchen staff click DESPACHAR from the kitchen view.
Accessing the report
Navigate to/reporte in a browser. The page loads current-day data automatically — no date selection is required.
A link back to the kitchen dashboard (/cocina) is available at the top of the page.
What the report shows
Ventas Totales
The total revenue for the current day in MXN, calculated as the sum of each completed order’s
total field.Órdenes Finalizadas
The number of orders dispatched today, equal to the number of records in
historial_ventas with today’s date.Order table columns
ID
ID
The unique order number assigned when the customer placed the order.
Hora Pedido
Hora Pedido
The time the order was originally placed by the customer.
Hora Entrega
Hora Entrega
The time the order was dispatched by kitchen staff — stored as
fecha_finalizado when DESPACHAR is clicked.Productos
Productos
The list of items in the order with quantities, as originally submitted by the customer.
Monto
Monto
The total amount charged for the order in MXN.
How revenue is calculated
Each order’s total is computed from its individual line items when the order is placed. The report sums thetotal field across all completed orders for the day.
sales report route
The
total for each order reflects the sum of precio × cantidad for all items in that order, as set at the time of ordering.How orders get into the report
Orders move from the active queue to the sales report in a single step: when a kitchen staff member clicks DESPACHAR on a ticket in/cocina. At that moment, the order is copied to historial_ventas with a fecha_finalizado timestamp and removed from pedidos_activos.
See Using the Rendón Burgers kitchen dashboard for details on the dispatch process.
When there are no sales
If no orders have been dispatched yet for the current day, the report displays the following message in place of the table:Aún no hay ventas registradas en el historial.The stat cards will show MXN $0 and 0 completed orders.
The report resets at midnight each calendar day. It only shows orders where the
fecha field matches today’s date. Orders from previous days are stored in historial_ventas but are not included in this view.