Watch
1
0
Fork
You've already forked arc
0
forked from hesabix/arc
arc/hesabixAPI/app/services/product_bulk_upsert_service.py
2026-08-07 22:52:03 +00:00

247 lines
9.7 KiB
Python
Executable file

"""
ایجاد/ویرایش گروهی کالا برای یکپارچه‌سازی (مثل ووکامرس / مهاجرت هلو).
موجودی اولیه در صورت ارسال، از مسیر create/update_with_opening_balance اعمال می‌شود.
"""
from typing import Any, Dict, List, Optional
from pydantic import ValidationError
from sqlalchemy.exc import IntegrityError
from sqlalchemy.orm import Session
from adapters.api.v1.schema_models.product import ProductCreateRequest, ProductUpdateRequest
from adapters.db.models.product import Product
from app.core.auth_dependency import AuthContext
from app.core.permissions import has_business_permission_for_business
from app.core.responses import ApiError
from app.services.product_opening_balance_service import (
create_product_with_opening_balance,
update_product_with_opening_balance,
)
from app.services.product_service import (
create_product,
delete_product,
invalidate_products_cache,
update_product,
)
MAX_BULK_PRODUCT_ITEMS = 1000
def _api_err(ae: ApiError) -> Dict[str, str]:
d = getattr(ae, "detail", None)
if isinstance(d, dict):
p = d.get("error") or {}
return {"code": str(p.get("code") or "API_ERROR"), "message": str(p.get("message") or str(ae))}
return {"code": "API_ERROR", "message": str(ae)}
def _payload_has_opening_balance(payload: Dict[str, Any]) -> bool:
ob = payload.get("opening_balance")
return isinstance(ob, dict)
def bulk_upsert_products_integration(
db: Session,
business_id: int,
auth_context: AuthContext,
body: Dict[str, Any],
) -> Dict[str, Any]:
items = body.get("items")
if not isinstance(items, list):
raise ApiError("INVALID_REQUEST", "items باید آرایه باشد", http_status=400)
if len(items) > MAX_BULK_PRODUCT_ITEMS:
raise ApiError(
"BULK_TOO_LARGE",
f"حداکثر {MAX_BULK_PRODUCT_ITEMS} آیتم در هر درخواست مجاز است",
http_status=400,
)
create_if_update_missing = bool(body.get("create_if_update_missing", True))
can_add = has_business_permission_for_business(auth_context, db, business_id, "products", "add")
can_edit = has_business_permission_for_business(auth_context, db, business_id, "products", "edit")
can_edit_ob = has_business_permission_for_business(
auth_context, db, business_id, "opening_balance", "edit"
)
user_id = auth_context.get_user_id()
def _create_product_deferred(session: Session, bid: int, pdata: Any) -> Dict[str, Any]:
return create_product(session, bid, pdata, defer_cache_invalidation=True)
def _update_product_deferred(
session: Session,
pid: int,
bid: int,
pdata: Any,
*,
user_id: Optional[int] = None,
) -> Optional[Dict[str, Any]]:
return update_product(
session, pid, bid, pdata, defer_cache_invalidation=True, user_id=user_id
)
results: List[Dict[str, Any]] = []
any_success = False
for idx, raw in enumerate(items):
base = {"index": idx}
if isinstance(raw, dict) and raw.get("client_ref") is not None:
base["client_ref"] = str(raw.get("client_ref") or "").strip() or None
else:
base["client_ref"] = None
if not isinstance(raw, dict):
results.append(
{**base, "status": "failed", "product_id": None, "error_code": "INVALID_ITEM", "message": "آیتم نامعتبر"}
)
continue
payload = raw.get("payload")
if not isinstance(payload, dict):
results.append(
{**base, "status": "failed", "product_id": None, "error_code": "INVALID_PAYLOAD", "message": "payload الزامی است"}
)
continue
wants_ob = _payload_has_opening_balance(payload)
if wants_ob and not can_edit_ob:
results.append(
{
**base,
"status": "failed",
"product_id": None,
"error_code": "OPENING_BALANCE_PERMISSION_REQUIRED",
"message": "برای ثبت تعداد اولیه به دسترسی ویرایش تراز افتتاحیه نیاز است",
}
)
continue
raw_pid = raw.get("product_id")
hesabix_product_id = None
if raw_pid not in (None, ""):
try:
hesabix_product_id = int(raw_pid)
except (ValueError, TypeError):
hesabix_product_id = None
if hesabix_product_id is not None and hesabix_product_id <= 0:
hesabix_product_id = None
def _row(st: str, pid: Any, err: Optional[str], msg: Optional[str]) -> Dict[str, Any]:
o: Dict[str, Any] = {**base, "status": st, "product_id": pid}
if err:
o["error_code"] = err
if msg:
o["message"] = msg
return o
need_create = hesabix_product_id is None
if not need_create:
if not can_edit:
results.append(_row("failed", None, "FORBIDDEN", "مجوز ویرایش محصولات نیست"))
continue
belongs = (
db.query(Product.id)
.filter(Product.id == hesabix_product_id, Product.business_id == business_id)
.first()
)
if not belongs:
if create_if_update_missing:
need_create = True
else:
results.append(_row("failed", None, "PRODUCT_NOT_FOUND", "کالا برای ویرایش یافت نشد"))
continue
else:
try:
p_upd = ProductUpdateRequest.model_validate(payload)
except ValidationError as ve:
results.append(_row("failed", None, "VALIDATION_ERROR", str(ve)))
continue
try:
if wants_ob:
existing = db.get(Product, hesabix_product_id)
previous_warehouse_id = (
existing.default_warehouse_id if existing is not None else None
)
out = update_product_with_opening_balance(
db,
business_id,
user_id,
hesabix_product_id,
p_upd,
update_product_fn=_update_product_deferred,
previous_warehouse_id=previous_warehouse_id,
)
else:
out = update_product(
db,
hesabix_product_id,
business_id,
p_upd,
defer_cache_invalidation=True,
user_id=user_id,
)
except ApiError as ae:
e = _api_err(ae)
results.append(_row("failed", None, e["code"], e["message"]))
continue
except IntegrityError as ie:
results.append(_row("failed", None, "INTEGRITY_ERROR", str(getattr(ie, "orig", ie) or ie)))
continue
if out and isinstance(out.get("data"), dict):
nid = out["data"].get("id")
any_success = True
results.append(
_row("updated", int(nid) if nid is not None else hesabix_product_id, None, None)
)
continue
if out is None and create_if_update_missing:
need_create = True
else:
results.append(_row("failed", None, "UPDATE_FAILED", "به‌روزرسانی ناموفق بود"))
continue
if need_create:
if not can_add:
results.append(_row("failed", None, "FORBIDDEN", "مجوز ایجاد محصولات نیست"))
continue
try:
p_new = ProductCreateRequest.model_validate(payload)
except ValidationError as ve:
results.append(_row("failed", None, "VALIDATION_ERROR", str(ve)))
continue
try:
if wants_ob:
cr = create_product_with_opening_balance(
db,
business_id,
user_id,
p_new,
create_product_fn=_create_product_deferred,
delete_product_fn=delete_product,
)
else:
cr = create_product(db, business_id, p_new, defer_cache_invalidation=True)
pdata = cr.get("data") or {}
nid = pdata.get("id")
any_success = True
results.append(_row("created", int(nid) if nid is not None else None, None, None))
except ApiError as ae:
e = _api_err(ae)
results.append(_row("failed", None, e["code"], e["message"]))
except IntegrityError as ie:
results.append(_row("failed", None, "INTEGRITY_ERROR", str(getattr(ie, "orig", ie) or ie)))
if any_success:
invalidate_products_cache(business_id=business_id)
summary = {
"total": len(items),
"created": sum(1 for r in results if r.get("status") == "created"),
"updated": sum(1 for r in results if r.get("status") == "updated"),
"failed": sum(1 for r in results if r.get("status") == "failed"),
}
return {"results": results, "summary": summary}