Overview The tables module manages restaurant tables, customer orders, order items, and invoice generation.
Mesa Restaurant table model with state management.
Primary key for the table. Auto-generated by Django.
Table name or identifier. Table description or notes. Current state of the table.
max_length: 20choices: ESTADO_CHOICESdefault: ‘disponible’ Estado Choices Available table states: Value Display disponibleDisponible ocupadaOcupada reservadaReservada fuera de servicioFuera de servicio
pedidos : Reverse relation to Pedido (related_name=‘pedidos’)
Pedido Customer order model tracking items ordered at a table.
Primary key for the order. Auto-generated by Django.
Reference to the table where the order was placed.
to: Mesaon_delete: SET_NULLrelated_name: ‘pedidos’null: Trueblank: True Users associated with this order.
to: User (Django auth)related_name: ‘pedidos_asociados’blank: True Timestamp when the order was created. Timestamp of last update. Current state of the order.
max_length: 20choices: ESTADO_CHOICESdefault: ‘en_proceso’ Estado Choices Available order states: Value Display en_procesoEn Proceso facturadoFacturado canceladoCancelado
Methods Calculates the total amount of the order by summing all item subtotals. def total ( self ): return sum (item.subtotal() for item in self .items.all())
Returns : Decimal representing the order total
items : Reverse relation to PedidoItem (related_name=‘items’)factura : Reverse OneToOne relation to Factura (related_name=‘factura’)
PedidoItem Individual item within an order.
Primary key for the order item. Auto-generated by Django.
Reference to the parent order.
to: Pedidoon_delete: CASCADErelated_name: ‘items’ Reference to the product being ordered.
to: Producto (from products app)on_delete: PROTECT Quantity of the product ordered.
default: 1Must be a positive integer
Unit price at the time of order.
max_digits: 10decimal_places: 2default: 0 Methods Calculates the subtotal for this item. def subtotal ( self ): return self .cantidad * self .precio_unitario
Returns : Decimal representing the item subtotal (quantity × unit price)The precio_unitario stores the price at the time of order, preserving historical pricing even if the product’s current price changes.
Factura Invoice model for completed orders.
Primary key for the invoice. Auto-generated by Django.
Reference to the order being invoiced.
to: Pedidoon_delete: PROTECTrelated_name: ‘factura’Each order can have only one invoice
Invoice number.
max_length: 20unique: TrueAuto-generated with 8-digit zero-padded format
Total invoice amount.
max_digits: 10decimal_places: 2default: 0Auto-calculated from order total if not provided
Methods Custom save method that:
Auto-generates invoice number if not provided (sequential, 8-digit zero-padded)
Auto-calculates total from order if not provided
def save ( self , * args , ** kwargs ): if not self .numero: last_numero = Factura.objects.order_by( '-id' ).values_list( 'numero' , flat = True ).first() next_number = '1' if not last_numero else str ( int (last_numero) + 1 ) self .numero = next_number.zfill( 8 ) if self .total is None : self .total = self .pedido.total() super ().save( * args, ** kwargs)
Invoice numbers are sequential and formatted as 8-digit strings (e.g., “00000001”, “00000002”).
Usage Examples Creating a Table from tables.models import Mesa mesa = Mesa.objects.create( nombre = "Mesa 1" , descripcion = "Mesa cerca de la ventana" , estado = "disponible" )
Creating an Order from tables.models import Pedido, PedidoItem, Mesa from products.models import Producto from django.contrib.auth.models import User # Get table and user mesa = Mesa.objects.get( nombre = "Mesa 1" ) user = User.objects.get( username = "mesero1" ) # Create order pedido = Pedido.objects.create( mesa = mesa, estado = "en_proceso" ) pedido.usuarios.add(user) # Add items to order producto1 = Producto.objects.get( nombre = "Coca-Cola 350ml" ) producto2 = Producto.objects.get( nombre = "Hamburguesa" ) PedidoItem.objects.create( pedido = pedido, producto = producto1, cantidad = 2 , precio_unitario = producto1.precio_venta ) PedidoItem.objects.create( pedido = pedido, producto = producto2, cantidad = 1 , precio_unitario = producto2.precio_venta ) # Get order total total = pedido.total()
Generating an Invoice from tables.models import Factura # Create invoice for order factura = Factura.objects.create( pedido = pedido ) # numero and total are auto-generated # Update order status pedido.estado = "facturado" pedido.save() # Update table status mesa.estado = "disponible" mesa.save()
Querying Orders # Get all orders for a table orden_mesa = Mesa.objects.get( nombre = "Mesa 1" ) pedidos = orden_mesa.pedidos.all() # Get active orders pedidos_activos = Pedido.objects.filter( estado = "en_proceso" ) # Get orders by user user_orders = user.pedidos_asociados.all() # Get order items with product details for item in pedido.items.select_related( 'producto' ): print ( f " { item.cantidad } x { item.producto.nombre } - $ { item.subtotal() } " )
Invoice Queries from django.utils import timezone from datetime import timedelta # Get today's invoices hoy = timezone.now().date() facturas_hoy = Factura.objects.filter( fecha__date = hoy) # Get invoices for date range fecha_inicio = timezone.now() - timedelta( days = 7 ) facturas_semana = Factura.objects.filter( fecha__gte = fecha_inicio) # Get invoice with order details factura = Factura.objects.select_related( 'pedido__mesa' ).get( numero = "00000001" ) print ( f "Factura: { factura.numero } " ) print ( f "Mesa: { factura.pedido.mesa.nombre } " ) print ( f "Total: $ { factura.total } " )
