]EhlddlmZmZmZmZmZmZmZddlm Z ddl m Z ddl m Z ddlmZmZmZddlmZddlmZddlZddlZddlZddlZGd d Zy) ) MovementModelMovementProductModel ProductModelBranchOfficeModel SupplierModelProductCategoryModelKardexValueModel) ProductClass)KardexValueClass)Session)descfuncor_) WhatsappClass)datetimeNcJeZdZdefdZd dZdZdZdZdZ d Z d Z d Z y) MovementClassdbc||_y)N)r)selfrs N/var/www/intrajisbackend.com/public_html/app/backend/classes/movement_class.py__init__zMovementClass.__init__s Nc l g}|r"|jtj|k(|"|jtj|k(|jj tj tjtjtjtjtjdjdtjjdjttj tjk(j|j!tj j#}|dkDr|j%}||zdz |z}|dks||kDrddd S|j'|dz |zj)|j+} | sdd d S| D cgc]G} | j | j| j| j,| j| jd I} } d | |||d S|j+} | D cgc]G} | j | j| j| j,| j| jd I} } | Scc} wcc} w#t.$r} ddt1| d cYd} ~ Sd} ~ wwxYw)uT Obtiene todos los movimientos con paginación y filtros opcionales N%d-%m-%Y %H:%i:%s added_datebranch_office_namererrorzInvalid page numberstatusmessagez No data found)idtype_idbranch_office_idr status_idrsuccess)r!data total_items total_pages current_pagezError retrieving movements: )appendrr$r%rqueryr#r&r date_formatrlabelr branch_office outerjoinfilterorder_byr countoffsetlimitallr Exceptionstr) rpageitems_per_pager$r%filtersr-r)r*r(movementserialized_dataes rget_allzMovementClass.get_allsC [G}44?@+}==AQQR DGGMM  %%..''  !9!9;NOUUVbc!//556JK i!#4#7#7=;Y;Y#Yf h  %%' ax#kkm *^;a?NR !8tk1&-:OPP||TAX$?@FF~VZZ\&-/JJ#'#( #++'//(0(A(A*2*E*E!)!3!3"*"5"5 $#(#((+#.#.$( yy{#'#( #++'//(0(A(A*2*E*E!)!3!3"*"5"5 $#(#('&9#(&#( [%4PQTUVQWPX2YZ Z [sPF J :JJ A J J!J5A J J J J3J.(J3.J3c |jjtjtjtj tj tjtjtjtjtjtjdjdtjtjdjdt j"jdt$j&jd j)t t jtjk(j)t$t$jtjk(j+tj,|k(j/}|sdddS|jjt0j2t0j4t0j6t0j8t:j<jd t:j jd t:j>jd jAt:t:j4t0j4k(j+t0j,|k(jC}|j,|jD|j |j |j|jF|j|jH|j|j|j|j|Dcgc]j}|j2|j4|jJ|jL|jN|j6|j8|j6|j8zd lc}d }d|dScc}w#tP$r}ddtS|dcYd}~Sd}~wwxYw)uE Obtiene un movimiento específico con sus productos r movement_daterr supplier_namerMovement not foundr product_nameproduct_descriptionproduct_barcode)movement_product_id product_idrErFrGcostqtysubtotal) movement_id movement_type description total_amountr%r supplier_idrCuser_rutr&rBrproductsr'r!r(zError retrieving movement: N)*rr-rr#r$rOrPr%rQrRr&rr.rBr/rrr0rsupplierr1r2rMfirstrrHrIrJrKrnamebarcodejoinr7rNrrCrErFrGr8r9)rrMmovement_queryproducts_queryproduct movement_datar?s rgetzMovementClass.getZsE Z!WW]]  %%))**..))&&''  !QRXXYhi  !9!9;NOUUVbc!//556JK&&,,_= i!#4#7#7=;Y;Y#Yi}//=3L3LLf))[8eg' *"")6JKK"WW]]$88$//$))$((!!''7((../DE$$**+<=dl559M9X9XXf$00K?ce  .99!/!=!=-99 . ; ;$2$C$C&4&G&G-99!/!=!=*33+55!/!=!=,77"0 1,3+F+F")"4"4$+$8$8+2+F+F'.'>'>#LL";; ' w{{ :  1M2(? ? 1 Z%4OPSTUPVx2XY Y Zs8G O&FO&(A/O! O&!O&& P /P?P P c  t|j|jdtjtj}|j j ||j j|j j|t|j }t|j }|jD]}|jdvr$t|j }|j }n!t|j}|j}t|j|j ||j"tjtj}|j j ||jdvr(|j%|j|jd} ny|jdvrk|j%|j|jd} | rBt'| t(r2| j+dd k(r|j j-| cS|j/|j||j" } | rBt'| t(r2| j+dd k(r|j j-| cS|jd k(s |j0d k(r0t3|j } | j5|j |j j7t8j;t8j |jk(j=} |j j7t>j;t>j |jk(j=} |j j7t@j;t@j | jBk(j=}|r|jDrtG|jDjI}|j j7tJj;tJj|jk(j=}|r |j"n |j"}tjL}d }|jNd}tG|jP}|d|d|}| jRd|d|d|j d|j }d}d}d}tU||jz}|d|d||||id|idddd|j dgid}dd|d}tWjX|d|||d !}|jZd"k7rt]d#|j^|j jd&d'|j d(S#t`$r"}t]d$tG|Yd%}~0d%}~wwxYw#t`$r5}|j j-d d)tG|d*cYd%}~Sd%}~wwxYw)+z9 Crear un nuevo movimiento con productos )r$r%r&r updated_daterIrMrKrJrraraddsubtractr!rrI qty_changenew_costrcr0102d-__SalidaInventario_https://libredte.cl JXou3uyrc7sNnP2ewOCX38tWZ6BTm4D1z 76063822-6 111000102debehaberIemitidosdtefoliofechaglosadetalle operacion documentosapplication/jsonBearer ) Content-Type Authorizationz/lce/lce_asientos/crear/)jsonheaderstimeoutz!Error al crear asiento contable: u(Error en creación de asiento contable: Nr'zMovement created successfully)r!r"rMzError creating movement: r )1rr$r%rutcnowrrhcommitrefreshr r rSabsquantityrrIr#rJ update_stock isinstancedictr^rollbackstore_kardex_entryalert_idr movementsr-rr2rVrrproduct_category_idaccounting_accountr9stripr nowmonthyearr0roundrequestspost status_codeprinttextr8) r form_data new_movement product_class kardex_class product_data qty_to_saveqty_for_kardexmovement_product stock_result kardex_resultwhatsapp_classr\r0product_categoryr kardex_value cost_to_userdayrr utf8_dater"url hash_valueemisoramountdatosrresponser?s rstorezMovementClass.storesR X(!))!*!;!;#??,%__. L GGKK % GGNN  GGOOL ))1M+DGG4L ) 2 2v S $$.#&|'<'<#="=K&2&;&;%;N"%l&;&;"U>UWcWlWlns#tL&&&0#0#=#=l>U>UWcWlWlnx#yL# <(F|j&d|-jj| d)z } | dkDr|jjon|jjq| dkDrdDnddE| dF|dG|| t| | r| dAdHngdIdJScc}w#tl$r1}.tid?|d@|j&dt|.YdA}.~.dA}.~.wwxYw#tl$r.}/tidB|j&dt|/YdA}/~/dA}/~/wwxYw#tl$r.}0| j+d| dzdCt|0YdA}0~0dA}0~0wwxYw#tl$r5}0|jjqddKt|0dcYdA}0~0SdA}0~0wwxYw)Lz Carga masiva de movimientos desde archivo Excel Columnas esperadas: sucursal, codigo, tipo de movimiento, cantidad, periodo )z.xlsxz.xlsrz*File must be an Excel file (.xlsx or .xls)r )sucursalcodigotipo de movimientocantidadperiodozMissing required columns: z, rrrrrrzRow rcz: Branch office 'z ' not foundz: Product with code ')rrcrgrdz: Invalid movement type 'z'. Must be 1, 2, 3, or 4z!: Quantity must be greater than 0r`)r$r%r&document_numberrrarbrerfrhrir!: r"rjz: Kardex error - rsrr76063822dror rn-0101-rp_SalidaInventario_Masiva_rtrurxryrzr{r~/api/lce/lce_asientos/crear/rrrrrrrz8Warning: Failed to create accounting entry for movement Error processing period z for movement Nz-Error creating accounting entry for movement z: Error processing row - r'z Processed z of z rows ) total_rowsprocessed_rows error_rowserrors)r!r"detailszError processing Excel file: )9filenameendswithfilereadpd read_excelioBytesIOcolumnsrYleniterrowsr9rintrr-rr2r#rVr,rrrrrhflushrrr rrrr^r rrrrr rIrJsplitrrr0rrrrr&rrr8rr)1rrrRcontentsdfrequired_columnscolmissing_columnsrrrindexrowr0 product_coderNrperiodr\rrrrrrrrcategoryTOKENurl_baserrryear_str month_strrr current_dayfecha_libredte fecha_mensajerr"rPr url_creater date_error impute_errorr?s1 rmassive_uploadzMovementClass.massive_uploads n \==))*;<")6bccyy~~'Hrzz(34B c .>Xs#RZZBWsXOX")8RSWS\S\]lSmRn6oppRJNJ!kkmC  sB$' OM#&s8}#5#;#;#=L$',@(A$BM"3z?3H Y0668F%)GGMM2C$D$K$K),, =%eg")"))D ;L]O[f*gh #ggmmL9@@$<7eg#"))D ;PQ]P^^i*jk %L8"))D ;TUbTcc{*|}  1}"))D ;\*]^ $1 -)6)9)9"$()#+??#4%-__%6 $LGGKK -GGMMO%.'*8}n *2&)(m )1(<#*::$0OO'#+??#4%-__%6 ($GGKK 01%1$9M$.'4'A'A'**hX]'^ '4'A'A'**hXb'c 'J|T,J|O_O_`hOimtOt&--UQYKr,BRBRS\B]A^._`$$4DGG#1L1L0MQOaNbbcdqcrsLMYM\M\L]]^_o_r_r^s/tG49x9O3PL2@181CL5.1<\6. 4*69,6;==@=Q129.7*-&E.5=:=YZ`Ya1bJ/7}}(2-2?Fug=N(-0hiuixixhyy{}E}J}J|K/L)M#a'NC L!   "(6'9)w''7tJ$r }dd|dtA|dcYd}~cSd}~wwxYw#t>$r/}tMd'|jdtA|Yd}~d}~wwxYw#t>$r5}|jjUdd*tA|dcYd}~Sd}~wwxYw)+z Imputa un movimiento creando asientos contables en LibreDTE Actualiza el status_id del movimiento y crea asientos contables para cada producto rrDr rrrsrrrpmprUnknownrorrrrnrrrrNrprqrtrurxryrzr{r~rrrrrzLibreDTE Response for product rz7Warning: Failed to create accounting entry for product zError processing product r'z:Movement imputed successfully. Accounting entries created.zError imputing movement: )+rr-rr2r#rVr&rrrarrMr7r rJr/rYrrIr rrrrrr%r0rrrrr8r9rrKrrrrrrrr) rrMrr=rrrrr pmp_resultr r\rr0rrrrrrrrrrr"rKrPrrr product_errorr?s rimputezMovementClass.imputes. Z Xww}}]3::=;K;K{;Z[aacH")6JKK"$H $,LLNH !!% .B C J J$00K?!ce %")6[\\7E,HF%6v  u!%(--33E:"d$loo9I9T9T&Tf$+;+F+FFeg 4>>>% /qC#ggmmL9@@$+;+F+FFeg# #ww}}-ABII,//73N3NN eg$8+F+F %)GGMM2C$D$K$K),,0I0II%eg"IV)D)D[d&)1)D)D)J)J)L&v.4ll3.?+)"8} #I'/lln&8&8 '+!QJE$rz() $ (-Sk -169+S)A+.i[$(@ "4 4A6H5I=/Ykltlwlwkxxy{K{N{NzOPG.223C#(s#3L"0!(!$$6 7%!,\& $&)&+-NVNfNfS1I1I-Jln!")'E.%-:-I&!RJ'}}""/6ug->,>! H:;K;N;N:OrRZR_R_Q`ab ++s2 WXhXkXkWllnowo|o|n}~ 3]v r GGNN $W {%v*1@XY_X``bcfgqcrbs>tuuvj!56F6I6I5J"SQ^M_L`ab X GG   %4McRSfX2VW W XsAS"A3S" S"DR'6S"8A%R'S"BR'!A2Q;DR'#S"; R$RR$R'S"R$$R'' S0$SS"SS"" T +*TT T )rrNN) __name__ __module__ __qualname__r rr@r^rrrrrr rrrr sJ7G[RIZVVXp$XL&XP&cPs\j_Xrr)app.backend.db.modelsrrrrrrr !app.backend.classes.product_classr &app.backend.classes.kardex_value_classr sqlalchemy.ormr sqlalchemyr rr"app.backend.classes.whatsapp_classrrrpandasrrrrrrrrsF^^^:C"&&<  z Xz Xr