]Eh8HddlmZddlmZmZmZmZddlmZGddZ y)) SessionLocal) ProductModel MovementModelMovementProductModelKardexValueModel)Sessionc,eZdZdefdZddZdZdZy)KardexValueClassdbc||_y)N)r )selfr s R/var/www/intrajisbackend.com/public_html/app/backend/classes/kardex_value_class.py__init__zKardexValueClass.__init__s Nc | |jjtjtjt j t jt jjt }|jttjt j k(}g}|'|dkDr"|jt j |k(|'|dk7r"|jt j|k(|jt jdk(|r|j|}|jj!t jj#}|dkDr|j%}||zdz |z} |dks|| kDrdddS|j'|dz |zj)|j+} | sdddS| D cgc]<} | j | j| j| j| jd>} } t-| || ||| d S|j+} | D cgc]<} | j | j| j| j| jd>} } | Scc} wcc} w#t.$r} t1| }d|dcYd} ~ Sd} ~ wwxYw) NrerrorzInvalid page numberstatusmessagez No data foundidcode descriptionquantitycost) total_items total_pages current_pageitems_per_pagedata)r queryrqtyrrrrr select_from outerjoin product_idappend visibility_idfilterdistinctorder_byasccountoffsetlimitallprint Exceptionstr)r rr'branch_office_idpager!r#filtersrrr"rowserialized_datae error_messages rget_allzKardexValueClass.get_all sN AGGMM $$ %%!!((  k,' OO "2"="="PE G%*q.|*<=DBJ|00D89 NN<55: ;$ g.NN$--l.F.F.J.J.LMEax#kkm *^;a?NR !8tk1&-:OPP||TAX$?@FF~VZZ\&-/JJ" ##  &&HH#&?? #HH $####o&$/#.$(&4+ 99;D   ff"GG  O# "9##( AFM%-@ @ AsPFJ :JJAJ J5J AJ J J J;!J60J;6J;c |jjtjtj|k(j }|ri|j xsd}|jxsd}||z}|dkr|}td|}n!|dkDr||z||zz} t| |z }n|}||_||_n:t|td||dkDr|nd} |jj| |jjdddS#t$r5} |jjddt| dcYd} ~ Sd} ~ wwxYw) z Crear/actualizar registro de kardex con costo promedio ponderado qty_change: cantidad a sumar o restar (positivo para entradas, negativo para salidas) new_cost: costo unitario del nuevo movimiento r)r'r$rsuccesszKardex updated successfullyrrzError updating kardex: N)r r#rr*r'firstr$rmaxintaddcommitr3rollbackr4) r r' qty_changenew_costcurrent_kardex current_qty current_cost new_qty_total new_avg_costtotal_cost_value new_kardexr:s rstore_kardex_entryz#KardexValueClass.store_kardex_entryZsX - V!WW]]+;<CC ++z9eg ,005A -227a !,j 8  A%#/L$'=$9M"A~,8;,F8V`K`+a('*+;m+K'L '3 &3"&2#.)Az*%/!^  J' GGNN '4QR R V GG   %4KCPQF82TU U VsDD E*E E Ec |jjtjtjt j t jt jjt jttjt j k(jt j |k(j}|sdddSd|j |j|j|j |jnd|j |jndddS#t$r}dd t|dcYd}~Sd}~wwxYw) z< Obtener los datos de kardex por product_id rzProduct not foundrr>Nrr)rr"zError retrieving kardex data: )r r#rr$rrrrrr%r&r'r*r?r3r4)r r'resultr:s rget_by_product_idz"KardexValueClass.get_by_product_ids ]WW]] $$ %%!!((  k,'  "2"="="P)f:-eg ")6IJJ$ ))"KK#)#5#5.4jj.D !+1;;+BFKK    ]%4RSVWXSYRZ2[\ \ ]s%CD;"AD;; EEEE)NNNr )__name__ __module__ __qualname__rrr<rNrQrrr r s#7OAb3Vj!]rr N) app.backend.db.databaserapp.backend.db.modelsrrrrsqlalchemy.ormrr rVrrrZs0ee"k]k]r