Spaces:
Running
Running
Download src/data_models.py from jonels1988/DocShopProE-Cloud: direct link, hf CLI and curl.
- Browser
- Download file 4.63 kB
-
https://huggingface.co/spaces/jonels1988/DocShopProE-Cloud/resolve/main/src/data_models.py
- Command line
-
hf download hf://spaces/jonels1988/DocShopProE-Cloud/src/data_models.py
-
curl -L -o data_models.py https://huggingface.co/spaces/jonels1988/DocShopProE-Cloud/resolve/main/src/data_models.py
4.63 kB
| from pydantic import BaseModel, Field, validator | |
| from typing import Optional, List, Dict, Any, Tuple | |
| from datetime import datetime | |
| from enum import Enum | |
| import pandas as pd | |
| class MatchStatus(str, Enum): | |
| EXACT_MATCH = "exact_match" | |
| PARTIAL_MATCH = "partial_match" | |
| UNMATCHED = "unmatched" | |
| APPROVED = "approved" | |
| DISCREPANCY = "discrepancy" | |
| class InvoiceRecord(BaseModel): | |
| """Canonical invoice record schema""" | |
| id: str | |
| document_type: str | |
| document_number: str | |
| reference_number: Optional[str] = None | |
| po_number: Optional[str] = None | |
| invoice_date: datetime | |
| due_date: Optional[datetime] = None | |
| total_billed: float | |
| amount_outstanding: float | |
| discount: Optional[float] = None | |
| credit_advances_applied: Optional[float] = None | |
| payment_amount: Optional[float] = None | |
| ar_status: Optional[str] = None | |
| open_balance: float | |
| class Config: | |
| arbitrary_types_allowed = True | |
| class PaymentRecord(BaseModel): | |
| """Canonical payment record schema""" | |
| id: str | |
| document_type: str = "Payment" | |
| document_number: str | |
| reference_number: Optional[str] = None | |
| po_number: Optional[str] = None | |
| invoice_date: datetime | |
| due_date: Optional[datetime] = None | |
| total_billed: float | |
| amount_outstanding: float | |
| discount: Optional[float] = None | |
| credit_advances_applied: Optional[float] = None | |
| payment_amount: float | |
| ar_status: Optional[str] = None | |
| open_balance: float | |
| class ReconciliationMatch(BaseModel): | |
| """Individual reconciliation match result""" | |
| record_id: str | |
| invoice_record: InvoiceRecord | |
| match_status: MatchStatus | |
| linked_payment_id: Optional[str] = None | |
| payment_suggestions: List[Tuple[PaymentRecord, float]] = [] # (payment, confidence_score) | |
| applied_payment_amount: Optional[float] = None | |
| final_ar_status: Optional[str] = None | |
| admin_notes: Optional[str] = None | |
| confidence_score: float = 0.0 | |
| is_approved: bool = False | |
| approved_by: Optional[str] = None | |
| approved_at: Optional[datetime] = None | |
| def to_dict(self) -> Dict[str, Any]: | |
| return { | |
| 'record_id': self.record_id, | |
| 'document_number': self.invoice_record.document_number, | |
| 'invoice_date': self.invoice_record.invoice_date.strftime('%Y-%m-%d') if self.invoice_record.invoice_date else '', | |
| 'total_billed': self.invoice_record.total_billed, | |
| 'amount_outstanding': self.invoice_record.amount_outstanding, | |
| 'payment_amount': self.applied_payment_amount or 0, | |
| 'match_status': self.match_status.value, | |
| 'confidence_score': f"{self.confidence_score:.1%}", | |
| 'is_approved': self.is_approved, | |
| 'actions': 'Review' if self.match_status in [MatchStatus.PARTIAL_MATCH, MatchStatus.UNMATCHED] else 'View' | |
| } | |
| class ReconciliationResult(BaseModel): | |
| """Complete reconciliation results""" | |
| matches: List[ReconciliationMatch] = [] | |
| statistics: Dict[str, Any] = {} | |
| def get_statistics(self) -> Dict[str, Any]: | |
| exact_matches = len([m for m in self.matches if m.match_status == MatchStatus.EXACT_MATCH]) | |
| partial_matches = len([m for m in self.matches if m.match_status == MatchStatus.PARTIAL_MATCH]) | |
| unmatched = len([m for m in self.matches if m.match_status == MatchStatus.UNMATCHED]) | |
| approved = len([m for m in self.matches if m.is_approved]) | |
| return { | |
| 'total_invoices': len(self.matches), | |
| 'total_payments': len([m for m in self.matches if m.payment_suggestions]), | |
| 'exact_matches': exact_matches, | |
| 'partial_matches': partial_matches, | |
| 'unmatched': unmatched, | |
| 'approved': approved, | |
| 'requires_action': partial_matches + unmatched | |
| } | |
| def to_dataframe(self) -> pd.DataFrame: | |
| """Convert results to pandas DataFrame for display""" | |
| if not self.matches: | |
| return pd.DataFrame() | |
| data = [match.to_dict() for match in self.matches] | |
| return pd.DataFrame(data) | |
| def get_record(self, record_index: int) -> Optional[ReconciliationMatch]: | |
| """Get specific record by index""" | |
| if 0 <= record_index < len(self.matches): | |
| return self.matches[record_index] | |
| return None | |
| class AdminCorrection(BaseModel): | |
| """Admin correction data model""" | |
| linked_payment_id: Optional[str] = None | |
| payment_amount: Optional[float] = None | |
| ar_status: Optional[str] = None | |
| admin_notes: Optional[str] = None | |
| action: str = "approve" # 'approve' or 'discrepancy' |