o = i@sddlmZddlZddlmZddlZddlZddlZddlZddl Z ddl m Z ddl Z ddl Z ddl mZddlmZmZmZddlZddlmZmZmZmZmZmZmZmZmZddlmZdd l m!Z!m"Z"dd l#m$Z$dd l%m&Z&dd l'm(Z(m)Z)dd l*m+Z+ede,ddZ-e .dZ/hdZ0dZ1dZ2eGdddZ3ddddZ4dZ5dZ6ddlZded!d"Z7d#d$Z8dfd%d&Z9dgd(d)Z:dZ5dZ6dhd-d.Z;d/Zm?Z?m@ZAdid4d5ZBe-jCd6d7d8d9e-jCd:d7d;d9e!d<fdjdBdCZDdDdEZEdFdGZFe!d<dHfdkdJdKZGdldMdNZHdmdPdQZIdndSdTZJe-KdUdVdWZLe-MdXdYdZZNe-Kd[d\d]ZOe-Md^d_d`ZPdodbdcZQdS)p) annotationsN)convert_from_bytes)datetime) dataclass)DictAnyTuple) Blueprintrequestrender_template_stringredirecturl_forflashsessionrender_template current_app)secure_filename)DecimalInvalidOperation)Session)Base)Invoice InvoiceItem) get_session wp_invoicesz /wp_invoices) url_prefix>jpgpdfpngjpegu Eres un verificador de facturas. Reconstruye la lógica contable, valida que las cifras cuadren y NO inventes datos. Si un dato no aparece impreso, deja su valor.verbatim = null y explica el porqué en notes. Formato y restricciones ESTRICTAS: - DEVUELVE ÚNICAMENTE UN JSON VÁLIDO Y MINIFICADO (una sola línea, sin markdown, sin comentarios). - NUNCA agregues texto fuera del JSON. - NO uses saltos de línea dentro de strings; reemplaza \n por espacios en valores de texto. - En arrays 'evidence' usa como máximo 3 tokens cortos (<=40 caracteres) y evita frases largas. - Evita comillas tipográficas; usa solo comillas ASCII. Distinciones: verbatim (impreso), computed (cálculo), evidence (IDs/bboxes), confidence (0..1). Detección tipo: 'Corporate' vs 'POS' según reglas ya especificadas. Reglas de cálculo y GST como se definieron. POS 2 líneas: fusiona adecuadamente header_line/pricing_line y valida qty*unit≈line_total (0.01). Marca inconsistencias aritméticas vs extraction_error vs human_error. Normaliza decimales con punto. SALIDA EXACTA en este esquema (sin comentarios):{'invoice_type':{'verbatim':'POS|Corporate','confidence':0},'header':{'supplier':{'name':{'verbatim':null,'computed':null,'confidence':0,'evidence':[],'notes':''},'abn':{'verbatim':null,'computed':null,'confidence':0,'evidence':[],'notes':''}},'invoice':{'number':{'verbatim':null,'computed':null,'confidence':0,'evidence':[]},'date':{'verbatim':null,'computed':null,'confidence':0,'evidence':[]},'time':{'verbatim':null,'computed':null,'confidence':0,'evidence':[]},'type':{'verbatim':null,'computed':null,'confidence':0,'evidence':[]}},'payment':{'method':{'verbatim':null,'computed':null,'confidence':0,'evidence':[]},'tendered_total':{'verbatim':null,'computed':null,'confidence':0,'evidence':[]}}},'items':[{'sku':{'verbatim':null,'computed':null,'confidence':0,'evidence':[],'notes':''},'description':{'verbatim':null,'computed':null,'confidence':0,'evidence':[]},'qty':{'verbatim':null,'computed':null,'confidence':0,'evidence':[]},'unit_price':{'verbatim':null,'computed':null,'confidence':0,'evidence':[]},'line_total':{'verbatim':null,'computed':null,'confidence':0,'evidence':[]},'checks':{'qty_x_unit_eq_total':false,'tolerance':0.01}}],'extras':[{'type':'surcharge|tip|donation|shipping|discount_global|rounding|fee','label':{'verbatim':null,'computed':null,'confidence':0,'evidence':[]},'amount':{'verbatim':null,'computed':null,'confidence':0,'evidence':[]},'tax_type':'taxable|gst_free|unknown'}],'totals':{'items_sum':{'verbatim':null,'computed':null,'confidence':0,'evidence':[]},'gst':{'verbatim':null,'computed':null,'confidence':0,'evidence':[],'notes':''},'grand_total':{'verbatim':null,'computed':null,'confidence':0,'evidence':[]},'checks':{'items_sum_matches_subtotal_or_total':false,'subtotal_plus_gst_plus_extras_equals_grand_total':false,'tendered_equals_grand_total':false}},'status':'consistent|extraction_error|human_error','notes':[]}z gpt-4.1-minic@s*eZdZUded<ded<dZded<dS) ExtractResultboolokzDict[str, Any] | NonedataN str | Noneerror)__name__ __module__ __qualname____annotations__r%r*r*Nr.lower.0xr*r*r+ j>z(_detect_gst_inclusive..csr?r@rArCr*r*r+rForGF)get isinstancer.rBanylistr! Exception)r5 gst_blockr9evid hay_noteshay_evid raw_noteshay_rawr*r*r+_detect_gst_inclusivebs $  rSc Csd|dpdid|dpdidd|dpdid|dp!diddiddidd|d p1did|d p9did d }t}|D]}td |}|rZ|t|dqFg}t|D]D}| d|d|dppdid|d|dp|did|d|dpdid|d|dpdid|d|dpdidqad|dpdid|dpdid|dpdid}|||fS)zArma un viewmodel con la misma estructura que usa el template (header/items/totals con subcampos .verbatim) a partir de los valores POST.verbatim supplier_namer: supplier_abn)nameabninvoice_number invoice_date)numberdatetimetypepayment_methodtendered_total)methodr`)supplierinvoicepaymentz items-(\d+)-items--sku -description-qty -unit_price -line_totalsku descriptionqty unit_price line_total items_sumr8 grand_total)rrr8rs) rHsetkeysrematchaddintgroupsortedappend)form header_vmidxskmitems_vmi totals_vmr*r*r+_build_viewmodel_from_formws@      rc Cs|}|drtjdd|tjd}zt|WStjy%Ynw|d}|dkr6td|dd }d }d}d }t ||d |d D];\}}|ra|rSd }qH|d krZd }qH|dkr`d }qH|dkrhd }qH|dkrq|d7}qH|dkr|d8}|dkr|d}nqH|d ur| d} | dkr| |kr| d}ntd|||||} zt| WStjytdd| } t| YSw)u Convierte 'raw' en JSON estricto: - quita ```json ... ``` si existe - recorta texto extraño - extrae el bloque { ... } hasta el último cierre balanceado (ignorando llaves dentro de strings) - intenta parsear; si hay comas colgantes, las limpia. z```z^```(?:json)?\s*|\s*```$r:)flags{zNo JSON object detectedrFN)start\T"re}zUnbalanced JSON bracesz ,(\s*[}\]])z\1) strip startswithrvsub IGNORECASEjsonloadsJSONDecodeErrorfind enumeraterfind) r5srin_stresclevelcutrchendsnippetsnippet2r*r*r+ coerce_jsons\        r pdf_bytescCs0t|ddd}t}|dj|dd|S)Nr)dpifmtrPNG)format)rioBytesIOsavegetvalue)rpagesbufr*r*r+_pdf_first_page_to_pngsr file_bytesfilenamemimetypec Cszddlm}|}|dkrLzt|}d}Wnty3}ztddd|dWYd}~WSd}~wwt|}d d td d d |d|dgd}nt|}d d td d d |d|dgd}|jjt |gddd}t |dd} | s}t | } td| ddt| } td| dWSty}z)tdz td| ddWn tyYnwtddt|dWYd}~Sd}~ww)u - Imágenes (png/jpg/jpeg): input_image + image_url (string con data URL base64) - PDFs: Files API (purpose="vision") y luego input_file con file_id - Sin response_format: coercion robusto a JSON con coerce_json() r)OpenAIapplication/pdf image/pngFNz No pude convertir PDF a imagen: )r"r#r%user input_text)r^text input_imagezdata:z;base64,)r^ image_url)rolecontenti g)modelinputmax_output_tokens temperature output_textzDEBUG raw(800):i T)r"r#zOpenAI extraction failedzDEBUG last raw(800):)openairrrLr r3 PROMPT_BASE responsescreate OPENAI_MODELgetattrrdumpsr6printrlog exceptionr.) rrrrclienteb64 user_messagerespr5r#r*r*r+extract_with_openais^      ru WP Invoices – Subir factura

Subir factura (pdf/png/jpg/jpeg)

{% with msgs = get_flashed_messages(with_categories=true) %} {% if msgs %}
    {% for c,m in msgs %}
  • {{c}}: {{m}}
    • {% endfor %}
{% endif %} {% endwith %}
u WP Invoices – Revisión

Revisión y edición

Header Proveedor (name):
Proveedor (ABN):
Invoice # :
Fecha :
Método pago :
Total pagado :
Items {% for i, it in enumerate(items) %} {% endfor %}
SKUDescripciónQtyUnitTotal
Totales Items sum:   GST:   Gran total:
JSON extraído (raw) {% if raw_json %} 
{{ raw_json | e }}
{% else %}

No hay JSON para mostrar.

{% endif %}
)MarkupescapevalrcCs|durdSt|S)Nr:)r.)rr*r*r+_safesrcCsttt|SN)r_escapervr*r*r+srsafe)rWcCst|Sr)r)seqr*r*r+rsr0.01aDecimal | NonebtolrcCs<|dus|dur dSz t|||kWStyYdSw)NF)absrL)rrrr*r*r+ _approx_equals rcCs t|tr ||St||dS)zCObtiene un campo desde dict o desde un objeto (modelo) por getattr.N)rIr6rHr)itfieldr*r*r+_val_gets   rcCs>|durdSt|tr |Sztt|WStyYdSwr)rIrr.rLrr*r*r+_to_dec_or_nones  rautogst_modec Cs~iid}dtdi}t|D]\} } tt| d} tt| d} tt| d} i}g}| dur5|d| dur>|dd}| dur_| dur_z | | td}Wn ty^d}Ynw| durl|d| 7<n |durx|d|7<|dur| durzt|| |krt|| |d <Wn tyd |d <Ynw|r||d <|r||d | <q|}|d krd}|durt|}t dt |t dt |dt dt t||dt dt ||dust||d|krz|dur||dnd }Wn tyd }Ynwt||dd<|dkrk|durj|durjt|}t|}|durj|durjzt|d|||krXt|d|||dd<Wntyid |dd<Ynwn|dkr|durt|}|durzt|d||krt|d||dd<Wntyd |dd<Ynw|dur|durz*||tdtd}t dt |t|||krt|||dd<Wntyd |dd<Ynw|dur/|dur/t|}t|}|dur/|dur/zt|||krt|||dd<Wnty.d |dd<Ynw|d  o9|d }|||fS)u Acepta items como lista de dicts Ó de modelos con attrs: qty, unit_price, line_total. Retorna (ok: bool, errors: dict, computed: dict). )itemsr7items_sum_calc0rorprqNrqty_unit_total_mismatchmismatchmissing_fieldsrr exclusiveitem_sum Citem_sumdiffsrr7items_sum_mismatchsum_plus_gst_mismatch inclusiveitems_sum_vs_total_mismatchz1.1impliedgst_inclusive_mismatchtendered_vs_grand_mismatch) rrrrr|quantizerLrr.r)rrrr8rsr`rrerrorscomputedrrrounitlineitem_errmissingexpectedmodediffrr"r*r*r+_validate_items_and_totalss             rpathcCstj|dddS)NT)exist_ok)osmakedirs)rr*r*r+ _ensure_dir&srrWcCs,|dd}ddd|DddS)N _r:css$|] }|s |dvr|VqdS))r -.N)isalnum)rDrr*r*r+rF,s"z _slugify_name..x)rreplacejoin)rWrr*r*r+ _slugify_name)srr$cCsPd}|rd|vr|ddd}|s |r t|pdd}|r&d|SdS)Nr rerr:)rsplitrB mimetypesguess_extensionlstrip)rrextr*r*r+_ext_from_mime_or_name.s  r/cCsttSr)r TPL_UPLOADr*r*r*r+ upload_form6srz/processc Cstjd}|stddttdS|}t|jpd}|j p+ddddd |d }t j d }t |t jt||}tj||}t|d  }||Wdn1s\wY|||td dtd<d|vr~|dddnd}|tvrtddttdSt|||} | jrt !dt"j#| j$ddddt%dt"j#| j$ddnt &d| j&td| j&dttdS| j$td<t"j#| j$dddtd<t"j#| j$d dd!td"<ttd#S)$Nfilez Selecciona un archivo de facturar%wp_invoices.upload_formrcrrz image/jpeg)rrrrzapplication/octet-streamINVOICE_STAGING_DIRwbZ)r orig_namer uploaded_atwpinv_staging_filer rerr:zFormato no permitidozExtraction OK: %sF) ensure_asciiizWP_INVOICES_EXTRACT:zExtraction ERROR: %suError en extracción: wpinv_extract),:) separatorsr#wp_inv_raw_minindentr#wp_inv_raw_prettyzwp_invoices.review)'r filesrHrr r readrrrrconfigruuiduuid4hexrrrropenwriterutcnow isoformatrrrBr ALLOWED_EXTSrr"rinforrr#rr%) fr#rrr staging_dirtmpnametmppathout extractedr*r*r+process;sR       $       r?z/reviewcCsdtd}|stddttdS|di}|dg}|di}td}td ||||d S) Nr$z,No hay datos para revisar. Sube una factura.r%rheaderrr7r,wp_invoices/review.html)r@rr7raw_json)rrHrr r r)r#r@rr7 raw_prettyr*r*r+reviewqs       rDz/savec( Csjd@dd}|d}|d}|d}|d}|d}|d pd}|d p$d}|d p*d}|d p0d} t} tjD]"} | d r[zt| ddd} | | Wq9tyZYq9wq9g} t | D]4}t |d |d|d |dt |d |dt |d |dt |d |dd}| |qbt }t|pd|pd|pd|pd|pdt |t |t |t | d }| D]}|j |qtdpi}t|}t| ||| |td|rdndd\}}}|s'tddtdpi}ttj\}}}tdptj|dd d!}|d"i}|d#g}|d$i}td%||||t|d&d'fS|dur0|d(}|||td)d}|rtj|d*drt j!d+} t"| tj#| |j$d,}!t"|!t%|d-|d.}"t&|j'p|d.pd/|j$}#tj#|!|#d0|"}$|$|_(d}|$}%tj)|%rtj#|!|#d1||"}%|d7}tj)|%st*+|d*|%tj#|!|#d2}&z3t,|&d3d4d5!}'tj-|j$|d.|d-|%|d6d7|'d dd8Wdn 1swYWn tyYnw|||t./d9|d.|%td:d;nt.0d<|j$td=|j$d>d;t1t2d?S)ANr:cSstj|p|Sr)r r}rHr)rWdefaultr*r*r+gszsave..grUrVrYrZr_r`rrr8rsrfr r)rergrhrirjrkrl) rUrVrYrZr_r`rrr8rsr$rrr)rrrr8rsr`rru?Hay inconsistencias aritméticas. Revisa los campos resaltados.r%r,Fr*r@rr7rA)r@rr7rBrrirr"rINVOICE_STORE_DIR08drr invoice_ _original _original_z_original.jsonwr/)encodingr!) invoice_id original_namer stored_pathr!)r#r+z&Archivo de factura %s almacenado en %sz#Archivo original guardado en disco.successz/No staging file found in session for invoice %szFactura guardada (id=z).r)r:)3rtr r}rurrysplitrxrLr{r _to_decimalr|rrrrrHrSrrrrrrrrcommitpoprrisfilerr/rridrrrY file_pathexistsshutilmover3dumploggingr8warningr r )(rFrUrVrYrZr_r`rrr8rsrridxrrrsessinvr5 gst_inclusiver"rrr#r~rrrCr@ items_data totals_datastaging store_dirinv_dirrbase dest_path final_path meta_pathmfr*r*r+rs                    $   rrc Cs8|sdSz |dd}t|WSttfyYdSw)Nr%r )rrrAttributeError)rs2r*r*r+rS!s  rS)r#r,r-r.)r5r6r-r!)r5r.r-r6)rr,r-r,)rr,rr.rr.r-r )rrr-r.)rrrrrrr-r!)rrrr.)rr.)rWr.r-r.)rr$rr$r-r.)rr$r-r)R __future__rr0 pdf2imagerrrr0rrZrrr] dataclassesrtypingrrrrvflaskr r r r r rrrrwerkzeug.utilsrdecimalrrsqlalchemy.ormrapps.wp_invoices.db.baserapps.wp_invoices.modelsrr config.dbrr&wp_invoices_bp getLoggerrr7rrr r3USE_FILES_API_FOR_PDF FILES_PURPOSErSrrrrr TPL_REVIEW markupsaferrrradd_app_template_globalrrrrrrrrHrpostr?rDrrSr*r*r*r+sx     ,     0   - C GK  p    5