h%HddlmZmZddlZddlmZddlmZGddZy)) FolioModel CashierModelN)Response)textc"eZdZddZddZdZy)CafClassNc ||_||_yN)dbdb2)selfr r s I/var/www/intrajisbackend.com/public_html/app/backend/classes/caf_class.py__init__zCafClass.__init__sc  |dk7r|jjtjtjtj tj tjtjtjtjjtj}|j}||zdz |z}|dks||kDry|j|dz |zj|j}|sy|Dcgc]]}|j|j|j |j|j |j|j|jd_}}|jjtj!tjdk(j} |||||| dS|jjtjtjtj tjtjtjjtjj}Dcgc]R}|j|j|j |j|j |j|jdT}}|Scc}wcc}w#t"$r} t%| } d| cYd} ~ Sd} ~ wwxYw) NrzInvalid page numberz No data found)idfoliobranch_office_id cashier_idbilled_status_idrequested_status_idused_status_id added_date) total_items total_pages current_pageitems_per_pagedatatotal_available_receipts)rrrrrrrzError: )r queryrrrrrrrrrorder_bycountoffsetlimitallfilter Exceptionstr) r pager data_queryrrrrserialized_datar e error_messages rget_allzCafClass.get_all s7 -qy!WW]]:==*:J:JJLgLgisjEjEGQG\G\^h^|^|~H~W~WYcYnYno !1!12)..0 *^;a?NR !8tk10!(($(n)DEKKN[__a*$( #) $hh!&,1,B,B&+&6&6,1,B,B/4/H/H*/*>*>&+&6&6 $ #) #),077==+D+K+KJLjLjnoLo+p+v+v+x($/#.$(&4+0H "WW]]:==*:J:JJLgLgisi~i~AKA_A_akazaz{ !1!12335$(#) $hh!&,1,B,B&+&6&6,1,B,B/4/H/H*/*>*>$#)#)'&G #)2#) -FM]O, , -sRCK6KKA"K:AKB#K5AK K K K=#K82K=8K=c n |jjtjtj|k(j }|s dd|ddS|j }|s dd|ddStd}|jj|||d}|j}|sdd |dSt||krdd t|d |d |dS|D cgc]} | j} } t| } t| } d dlm} | jj!d}td}|jj|||| | |||d|jj#d}|d| d| dz }|d|dz }|d|dz }|d|dz }|d|dz }|d|dz }t%| D]}|d|d|d|dz }d d!| d"| d#|t|| | ||||d$d%Scc} w#t&$r5}|jj)dd&t+|dcYd'}~Sd'}~wwxYw)(zg Crear CAF manual: seleccionar folios disponibles, actualizarlos y generar archivo SQL errorzCashier with ID z not found)statusmessagezCashier z* does not have a folio_segment_id assigneda% SELECT 0 as used_id, folio FROM folios WHERE folio_segment_id = :folio_segment_id AND cashier_id = 0 AND requested_status_id = 0 ORDER BY id DESC LIMIT :quantity )folio_segment_idquantityz*No hay folios disponibles para el segment z Solo hay z$ folios disponibles para el segment z, se solicitaron r)datetimez%Y-%m-%d %H:%M:%Sa UPDATE folios SET cashier_id = :cashier_id, branch_office_id = :branch_office_id, requested_status_id = 1, added_date = :added_date, updated_date = :updated_date WHERE folio <= :folio_max AND folio >= :folio_min AND folio_segment_id = :folio_segment_id AND cashier_id = 0 AND requested_status_id = 0 )rr folio_max folio_minr4r updated_datez-- CAF Manual Generated SQL z -- Range: z to  z -- Quantity: z-- Branch Office ID: z-- Cashier ID: z-- Folio Segment ID: z-- Generated Date: z zIINSERT INTO folios (used_id, folio, added_date, updated_date) VALUES (0, z, 'z', 'z'); successz+CAF manual creado exitosamente. Folios del z al z para segment )folios_assignedr8r7rrr4 sql_content)r2r3rzError creating manual CAF: N)r r!rr'rfirstr4rexecutefetchalllenrminmaxr6nowstrftimecommitsortedr(rollbackr))r rrr5cashierr4 select_queryresult folios_datarowfolios_numbersr8r7r6current_datetime update_queryr= folio_numberr-s rmanualzCafClass.manualFs<` Zhhnn\299,//Z:WX^^`G")8H T^6_``&77 #") Lv6wxx !LXX%%l$4$5F!//+K")8bcsbt6uvv;(*") #kBRASSwyIxJJ[\d[e7fgg4??Ccii?N?N+IN+I *'||~667JK  ! L HH  \($4&&$4. 0,  HHOO :K Z {$ykD DK ]8*B7 7K 23C2DBG GK _ZL; ;K 23C2DBG GK 01A0B$G GK &~ 6 j !jkwjxx{}M|NNRScRddi jj  j$H SWXaWbbprBqCD'*;'7!*!*(8",(8#.  ]@x Z HH   %4OPSTUPVx2XY Y ZsJAG6G61AG65$G6G6G11C?G61G66 H4?*H/)H4/H4r )r )__name__ __module__ __qualname__rr/rRrrrrs 8-tdZrr) app.backend.db.modelsrrjsonfastapi.responsesr sqlalchemyrrrWrrr\s: &dZdZr