Watch
1
0
Fork
You've already forked arc
0
forked from hesabix/arc
arc/hesabixAPI/adapters/api/v1/inventory_lots.py
Babak Alizadeh f7c9fcd603 feat(inventory): add opt-in lot and expiry tracking for perishables
Keep non-perishables unchanged; dates live on homogeneous lots with FEFO picking, expired-sale blocks, and write-off via waste/GEI.

Co-authored-by: Cursor <cursoragent@cursor.com>
2026-11-02 23:22:50 +03:30

83 lines
3 KiB
Python

from datetime import date
from typing import Any, Dict, Optional
from fastapi import APIRouter, Depends, Query, Request
from sqlalchemy.orm import Session
from adapters.db.models.product import Product
from adapters.db.session import get_db
from app.core.auth_dependency import AuthContext, get_current_user
from app.core.permissions import require_business_access
from app.core.responses import ApiError, success_response
from app.services.inventory_lot_service import compute_lot_dates, list_lot_balances
router = APIRouter(prefix="/inventory-lots", tags=["inventory_lots"])
@router.get("/business/{business_id}/products/{product_id}")
@require_business_access("business_id")
def list_product_lots(
request: Request,
business_id: int,
product_id: int,
warehouse_id: Optional[int] = Query(default=None),
variant_id: Optional[int] = Query(default=None),
sellable_only: bool = Query(default=False),
as_of_date: Optional[str] = Query(default=None),
ctx: AuthContext = Depends(get_current_user),
db: Session = Depends(get_db),
) -> Dict[str, Any]:
if not ctx.can_read_section("inventory"):
raise ApiError("FORBIDDEN", "Missing business permission: inventory.read", http_status=403)
from app.services.inventory_lot_service import business_as_of
explicit = None
if as_of_date:
try:
explicit = date.fromisoformat(as_of_date[:10])
except ValueError:
raise ApiError("INVALID_DATE", "تاریخ نامعتبر است", http_status=400)
as_of = business_as_of(business_id, explicit)
items = list_lot_balances(
db,
business_id,
product_id,
warehouse_id,
as_of,
sellable_only=sellable_only,
variant_id=variant_id,
)
return success_response(data={"items": items, "as_of_date": as_of.isoformat()}, request=request)
@router.get("/business/{business_id}/products/{product_id}/preview-dates")
@require_business_access("business_id")
def preview_lot_dates(
request: Request,
business_id: int,
product_id: int,
manufacturing_date: Optional[str] = Query(default=None),
expiry_date: Optional[str] = Query(default=None),
ctx: AuthContext = Depends(get_current_user),
db: Session = Depends(get_db),
) -> Dict[str, Any]:
if not ctx.can_read_section("products"):
raise ApiError("FORBIDDEN", "Missing business permission: products.read", http_status=403)
product = (
db.query(Product)
.filter(Product.id == int(product_id), Product.business_id == int(business_id))
.first()
)
if product is None:
raise ApiError("NOT_FOUND", "کالا یافت نشد", http_status=404)
from app.services.inventory_lot_service import _as_date
dates = compute_lot_dates(
product,
manufacturing_date=_as_date(manufacturing_date),
expiry_date=_as_date(expiry_date),
)
return success_response(
data={k: (v.isoformat() if v else None) for k, v in dates.items()},
request=request,
)