Purchases API - Inventario

Overview

The Purchases API handles two types of purchases:

Product purchases - Inventory replenishment with automatic stock updates
Asset/furniture purchases - Fixed assets and equipment

Additionally manages general business expenses (Gastos).

Compra Model (Purchase)

integer

Unique purchase identifier (auto-generated)

integer

Foreign key to Proveedor (supplier, optional)

datetime

Purchase timestamp (default: current time)

string

Purchase type: productos or activos

decimal

Total purchase amount (10 digits, 2 decimals, default: 0.00)

integer

Foreign key to User who created the purchase

CompraDetalle Model (Purchase Detail)

integer

Detail line identifier

integer

Foreign key to parent Compra

integer

Foreign key to Producto (optional, null for new products)

string

Product category (max 255 characters, optional)

integer

Quantity purchased (positive integer, default: 1)

decimal

Unit purchase price WITHOUT IVA (10 digits, 2 decimals)

decimal

Unit price WITH IVA (auto-calculated, default: 0.00)

decimal

Line total with IVA (cantidad × precio_con_iva, default: 0.00)

decimal

Selling price to set for this batch (10 digits, 2 decimals)

boolean

Whether product has expiration date (default: false)

date

Expiration date (required if tiene_caducidad=true)

Activo Model (Asset)

integer

Asset identifier

integer

OneToOne foreign key to Compra (tipo=‘activos’)

string

Asset name (max 255 characters)

text

Asset description (optional)

decimal

Asset value (10 digits, 2 decimals)

date

Acquisition date

Gasto Model (Expense)

integer

Expense identifier

integer

Foreign key to User

string

Expense concept (max 150 characters)

text

Detailed description (optional)

decimal

Amount (12 digits, 2 decimals)

date

Expense date (auto-set on creation)

List Purchases

Requires authentication and admin role.

curl -X GET http://localhost:8000/compras/ \
  -H "Cookie: sessionid=<your-session>"

Response

Returns rendered HTML with list of purchases for the authenticated user.

Create Purchase (Products)

Requires authentication and admin role.

curl -X POST http://localhost:8000/compras/crear/ \
  -H "Cookie: sessionid=<session>; csrftoken=<token>" \
  -H "X-CSRFToken: <token>" \
  -H "Content-Type: application/x-www-form-urlencoded" \
  -d "tipo=productos" \
  -d "proveedor=5" \
  -d "total=5000.00"

Request Parameters

string

required

Purchase type: productos or activos

integer

Supplier ID (optional)

decimal

default:"0.00"

Total amount (typically calculated from details)

Adding Purchase Details

Details are added separately (typically via formset in web UI):

curl -X POST http://localhost:8000/compras/crear/ \
  -d "producto=10" \
  -d "cantidad=50" \
  -d "precio=80.00" \
  -d "precio_venta=100.00" \
  -d "tiene_caducidad=true" \
  -d "fecha_caducidad=2025-12-31"

integer

Existing product ID (optional, can create new product)

string

Product category for new products

integer

required

Quantity purchased

decimal

required

Unit price WITHOUT IVA

decimal

required

Selling price to set for product

boolean

default:"false"

Whether product expires

date

Expiration date (YYYY-MM-DD format, required if tiene_caducidad=true)

Response

Success: Redirects to purchase list with flash message

Business Logic on Purchase Creation

Stock Update: producto.stock += cantidad
Price Update: producto.precio_compra = precio
Selling Price: producto.precio = precio_venta
IVA Calculation: precio_con_iva = precio * 1.19 (19% tax)
Subtotal: subtotal_con_iva = cantidad * precio_con_iva

Create Purchase (Assets)

curl -X POST http://localhost:8000/compras/crear/ \
  -H "Cookie: sessionid=<session>; csrftoken=<token>" \
  -H "X-CSRFToken: <token>" \
  -d "tipo=activos" \
  -d "proveedor=3" \
  -d "total=15000.00" \
  -d "nombre=Office Desk" \
  -d "descripcion=Executive wooden desk" \
  -d "valor=15000.00" \
  -d "fecha_adquisicion=2024-03-15"

Asset Parameters

string

required

Asset name

text

Asset description

decimal

required

Asset value

date

required

Acquisition date (YYYY-MM-DD)

View Purchase Detail

curl -X GET http://localhost:8000/compras/detalle/<pk>/ \
  -H "Cookie: sessionid=<session>"

integer

required

Purchase ID

Response

Returns rendered HTML with purchase details including all line items.

Delete Purchase

Requires authentication and admin role.

curl -X POST http://localhost:8000/compras/eliminar/<pk>/ \
  -H "Cookie: sessionid=<session>; csrftoken=<token>" \
  -H "X-CSRFToken: <token>"

integer

required

Purchase ID to delete

Response

Success: Purchase and related details/assets deleted, redirects to list

Deleting a purchase does NOT restore product stock. Consider carefully before deletion.

AJAX/API Endpoints

Get Product Data

curl -X POST http://localhost:8000/compras/ajax/obtener-producto-datos/ \
  -H "Cookie: sessionid=<session>; csrftoken=<token>" \
  -H "Content-Type: application/json" \
  -H "X-CSRFToken: <token>" \
  -d '{"producto_id": 10}'

integer

required

Product ID to fetch

Response

{
  "success": true,
  "producto": {
    "id": 10,
    "nombre": "Laptop Dell XPS 15",
    "precio_compra": "1200.00",
    "precio_venta": "1500.00",
    "stock": 8,
    "categoria": "Electronics"
  }
}

Get Purchase Detail (AJAX)

curl -X GET http://localhost:8000/compras/api/detalle-compra/<compra_id>/ \
  -H "Cookie: sessionid=<session>"

integer

required

Purchase ID

Response

{
  "id": 12,
  "proveedor": {
    "id": 5,
    "nombre": "TechSupply S.A.",
    "empresa": "TechSupply"
  },
  "fecha": "2024-03-15T09:00:00-05:00",
  "tipo": "productos",
  "total": "5950.00",
  "detalles": [
    {
      "producto": {
        "id": 10,
        "nombre": "Laptop Dell XPS 15"
      },
      "cantidad": 5,
      "precio": "1000.00",
      "precio_con_iva": "1190.00",
      "subtotal_con_iva": "5950.00",
      "precio_venta": "1500.00"
    }
  ]
}

Expenses (Gastos)

List Expenses

curl -X GET http://localhost:8000/compras/gastos/ \
  -H "Cookie: sessionid=<session>"

Create Expense

Requires authentication and admin role.

curl -X POST http://localhost:8000/compras/gastos/nuevo/ \
  -H "Cookie: sessionid=<session>; csrftoken=<token>" \
  -H "X-CSRFToken: <token>" \
  -d "concepto=Office Rent" \
  -d "descripcion=Monthly rent payment" \
  -d "monto=2500000.00"

string

required

Expense concept (max 150 characters)

text

Detailed description (optional)

decimal

required

Amount (e.g., “2500000.00”)

Response

Success: Expense created, redirects to expenses list

Update Expense

curl -X POST http://localhost:8000/compras/gastos/editar/<pk>/ \
  -H "Cookie: sessionid=<session>; csrftoken=<token>" \
  -H "X-CSRFToken: <token>" \
  -d "concepto=Office Rent (Updated)" \
  -d "monto=2600000.00"

integer

required

Expense ID to update

Delete Expense

curl -X POST http://localhost:8000/compras/gastos/eliminar/<pk>/ \
  -H "Cookie: sessionid=<session>; csrftoken=<token>" \
  -H "X-CSRFToken: <token>"

integer

required

Expense ID to delete

Example Workflow

Complete Purchase Flow

# 1. Login as admin
curl -c cookies.txt -X POST http://localhost:8000/login/ \
  -d "username=admin&password=mypass"

# 2. Get product data for purchase
curl -b cookies.txt -X POST http://localhost:8000/compras/ajax/obtener-producto-datos/ \
  -H "Content-Type: application/json" \
  -H "X-CSRFToken: <token>" \
  -d '{"producto_id": 10}'

# Response shows current stock: 8

# 3. Create purchase order
curl -b cookies.txt -X POST http://localhost:8000/compras/crear/ \
  -H "X-CSRFToken: <token>" \
  -d "tipo=productos" \
  -d "proveedor=5" \
  -d "producto=10" \
  -d "cantidad=20" \
  -d "precio=1100.00" \
  -d "precio_venta=1550.00"

# Result:
# - Stock updated: 8 + 20 = 28
# - precio_compra updated: 1100.00
# - precio (selling) updated: 1550.00
# - Total: 20 × 1100.00 × 1.19 = 26,180.00

# 4. View purchase detail
curl -b cookies.txt http://localhost:8000/compras/detalle/12/

# 5. Record business expense
curl -b cookies.txt -X POST http://localhost:8000/compras/gastos/nuevo/ \
  -H "X-CSRFToken: <token>" \
  -d "concepto=Utilities" \
  -d "monto=350000.00"

Products API - Stock updates from purchases
Suppliers API - Purchase order suppliers
See source: applications/compras/models.py and applications/compras/views.py

​Overview

​Compra Model (Purchase)

​CompraDetalle Model (Purchase Detail)

​Activo Model (Asset)

​Gasto Model (Expense)

​List Purchases

​Response

​Create Purchase (Products)

​Request Parameters

​Adding Purchase Details

​Response

​Business Logic on Purchase Creation

​Create Purchase (Assets)

​Asset Parameters

​View Purchase Detail

​Response

​Delete Purchase

​Response

​AJAX/API Endpoints

​Get Product Data

​Response

​Get Purchase Detail (AJAX)

​Response

​Expenses (Gastos)

​List Expenses

​Create Expense

​Response

​Update Expense

​Delete Expense

​Example Workflow

​Complete Purchase Flow

​Related Endpoints

Overview

Compra Model (Purchase)

CompraDetalle Model (Purchase Detail)

Activo Model (Asset)

Gasto Model (Expense)

List Purchases

Response

Create Purchase (Products)

Request Parameters

Adding Purchase Details

Response

Business Logic on Purchase Creation

Create Purchase (Assets)

Asset Parameters

View Purchase Detail

Response

Delete Purchase

Response

AJAX/API Endpoints

Get Product Data

Response

Get Purchase Detail (AJAX)

Response

Expenses (Gastos)

List Expenses

Create Expense

Response

Update Expense

Delete Expense

Example Workflow

Complete Purchase Flow

Related Endpoints