@ՃhddlZddlmZmZmZmZmZddlmZddl m Z ddl m Z ddlm Z mZmZddlmZmZddlmZdd lmZddlZGd d Zy) N)DteModelBranchOfficeModel CustomerModel SupplierModel CommuneModel)descmysql) HelperClass)castDatefuncdatetime timedelta)or_) relativedeltaceZdZdZdZdZddZ ddZ ddZd Z dd Z d Z d Z d Z dZdZdZddlmZmZdZdZdZdZdZdZdefdZy)DteClassc||_y)N)db)selfrs I/var/www/intrajisbackend.com/public_html/app/backend/classes/dte_class.py__init__zDteClass.__init__ s cx |jjtjtj|k(jtj |k(jtj |k(j}|dkDryy#t$r}t|}d|cYd}~Sd}~wwxYw)NrError: ) rqueryrfilterfoliorutdte_version_idcount Exceptionstr)rr!r"r# folio_counte error_messages rvalidate_old_dtezDteClass.validate_old_dtes -''--18859PQXXYaYeYeilYlmttu}vMvMQ_v_`ffhKQ -FM]O, , -sBB B9B4.B94B9c  |jjtjtjtj tj tjtjtjtjjttjtjk(jtjt!tjt!tjt!tj}t"dkDr[|j%}t'|j(j+t-j.ddi|t0zdz t0z}t'|t"dks t"|kDrdddS|j3t"dz t0zj5t0j7}|sdd dS|Dcgc]z}|j|j|j |j |j|j|jr|jj9d nd|jd |}}||t"t0|d S|j7}|Dcgc]z}|j|j|j |j |j|j|jr|jj9d nd|jd |}}|Scc}wcc}w#t:$r}t=|}d|dcYd}~Sd}~wwxYw) Nr literal_bindsTdialectcompile_kwargsrerrorInvalid page numberstatusmessage No data found%d-%m-%Yidbranch_office_idr!total entrance_hour exit_hour added_date branch_office total_items total_pages current_pageitems_per_pagedata)rrrr8r9r!r:r;r<r=rr> outerjoinr filtersorder_byrpager$print statementcompiler r.rCoffsetlimitallstrftimer%r&) rrr@rArDdteserialized_datar(r)s r get_old_dteszDteClass.get_old_dtessN A DGGMM ))&&""##!// i!#4#7#78;T;T#Tf hX(()X++,X''( (ax#kkm eoo--emmoWfhlVm-no*^;a?NR k"!8tk1&-:OPP||TAX$?@FF~VZZ\&-/JJ" ##&&(+(<(< YY YY%(%6%6!$IL#.."9"9*"E]a%(%6%6 $ ## ##$/#.$(&4+ yy{" ##&&(+(<(< YY YY%(%6%6!$IL#.."9"9*"E]a%(%6%6 $ ## ##'&G ##0 ## AFM%-@ @ AsQF4L47AL4>L4A?L*L4L4'A?L/&L4* L44 M=M MMNrc  g} |"| jtj|k(|"| jtj|k(|"| jtj|k(|2| jtj j d|d|"| jtj|k\|"| jtj|k|"| jtj|k(|"| jtj|k(| "| jtj| k(|jjtjtjtjtjtjtjtjt j"j%t t jtjk(j&| j)t+tjt+tjt+tj} | dkDr7| j-}t/| j0j3t5j6ddi|| zdz | z}t/|| dks| |kDrddd S| j9| dz | zj;| j=}|sdd d S|Dcgc]z}|j|j|j|j|j|j|jr|jj?d nd|j"d |}}||| | |d S| j=}|Dcgc]z}|j|j|j|j|j|j|jr|jj?d nd|j"d |}}|Scc}wcc}w#t@$r}tC|}d|d cYd}~Sd}~wwxYw)N%rr,Tr-rr0r1r2r5r6r7r?)"appendrr!r9r"customerliker=r: supervisor_id status_idrrr8r;r<rr>rEr rGrr$rIrJrKr r.rLrMrNrOr%r&)rr!r9r"rVsinceuntilamountrXrYrHrCrFrr@rArDrPrQr(r)s rget_allzDteClass.get_allpsc AG x~~67+x88? DGGMM ))&&""##!// i!#4#7#78;T;T#Tf hX(()X++,X''( (ax#kkm eoo--emmoWfhlVm-no*^;a?NR k"!8tk1&-:OPP||TAX$?@FF~VZZ\&-/JJ" ##&&(+(<(< YY YY%(%6%6!$IL#.."9"9*"E]a%(%6%6 $ ## ##$/#.$(&4+ yy{" ##&&(+(<(< YY YY%(%6%6!$IL#.."9"9*"E]a%(%6%6 $ ## ##'&G ##0 ## AFM%-@ @ AsPK2Q5:Q0Q4A?Q3 Q=QA?QQ Q R'Q<6R<Rc  g} |r"| jtj|k(|r"| jtj|k(|r"| jtj|k(|r2| jt j jd|d|r"| jtj|k(|r"| jtj|k(|r"| jtj|k(|r"| jtj|k(| jtjdk7| "| jtj| k(| jtjjddg|jjtj tjtjtjtj"tj$tjtj&t jt j tj(tj*t,j. j1t,t,j tjk(j1t t jtjk(j2| j5tj j7} | j9}|dk(r ddgdd| dS|| zdz | z}| dks| |kDrd d d S| dz | z}| j;|j=| j?}dd l m!}tE| jFjI|jJd di|dz}tM|| z|}tEd|d|d||Dcgc]}|j |j|j|j(|j|j |j|j"|j&|j|j$|j*r|j*jOdnd|j.d }}d||| | |||dScc}w#tP$r}d tS|d cYd}~Sd}~wwxYw)NrTrokr5r3r4rDr@rArBrr0r1r2r r,Tr-Mostrando resultados del  al  de r6 r8r9r! dte_type_idr:rVr"r; payment_daterYr<r=r>r3r@rArBrC from_itemto_itemrD*rUrr!r9r"rrVrWperiodr:rXrYr#in_rrr8r;r<rhrgr=rr>rEr rGrr$rLrMrNsqlalchemy.dialectsr rIrJrKr.minrOr%r&rr!r9r"rVrmr\rXrYr#rHrCrFrr@rArLrDr start_itemend_itemrPrQr(s rget_all_with_customerzDteClass.get_all_with_customersp :Gx~~67x88? NN8<<4/ 0)x66.HI NN8--111a&9 :DGGMM ))&&""""%%!!&&$$##!//i!#4#7#78;T;T#Ti}00HLL@f'(h   ") 2 ++-Ka".#$#$$( '7!;NKax4+-")6KLLQh.0F<<'--n=AACD 2 %//))-%--/SbdhRi)j k !J6N2K@H -j\hZtK=Y Z"ff$'$8$8"LLww!$!2!2 # 0 0 ]] ]]EH^^cnn55jAY]!$!2!2 O"** $"0'#'  !6 :%#a&9 9 :s>MSSBS? NN8<<4/ 0)x66.HI NN8--112$7 8DGGMM ))&&""""%%!!&&$$##!//i!#4#7#78;T;T#Ti}00HLL@f'(h   ") 2 ++-Ka".#$#$$( '7!;NKax4+-")6KLLQh.0F<<'--n=AACD 2 %//))-%--/SbdhRi)j k !J6N2K@H -j\hZtK=Y Z"ff$'$8$8"LLww!$!2!2 # 0 0 ]] ]]EH^^cnn55jAY]!$!2!2 O"** $"0'#'  !6 :%#a&9 9 :s>L?SSBS;B6R>1 S>S S$ SS$S$cL|jjtjtj|j k(j }d|_|j|_|j|_ |j|_ |j|_ ||_ |jj|jj!|dddS#t"$r5}|jj%ddt'|dcYd}~Sd}~wwxYw)NrvsuccesszDte updated successfullyr2r0r)rrrr r8dte_idfirstrYpayment_type_iddeposited_amountpayment_amountpayment_number deposit_daterhsupportcommitrefreshr%rollbackr&)r form_datarrPr(s rupload_deposit_transferz DteClass.upload_deposit_transfersggmmH%,,X[[Ir?r0r2)&rUrr!r9r"rrrWr=r:rXrYr#rrr8r;r<rr>rEr rGrr&rJrKr r.replacerIexecuterLrMfetchalllenrOr%)rr!r9r"rrZr[r\rXrYrgr#rHrCrFr query_sqlrLrDr@rAdata_paginatedrPrQr(r)s r get_received_tributary_documentsz)DteClass.get_received_tributary_documentss] AG x~~67+x88? NN8<<4/ 0 NN822nD EDGGMM ))&&""""!!&&##!// i!#4#7#78;T;T#Ti}00HLL@f#$h   "% .EOO33EMMO]lnr\s3tuI"))$4I +Y 7Qh.0F77??5??#9#9&#A#G#G#WXaacDd)K&7!;NK!N( )ff$'$8$8LLww!$!2!2 ]] ]]EH^^cnn55jAY]!$!2!2  )O ) +* $"0'   ), AFM%-@ @ As1OQ5B Q0& Q50Q55 R>R RRcd}d}tj|tjj dd}dd|d}t j |||} |j}td |t|tr|}n&t|tr d |vr|d }n td y|s td ytd t|d|d|D]} |jjtjtj |k(j#} | sdt%|z}i}t j&d|||}t|j(|j}tdtd|j+dd|j+dtd|j+dtd|j+dtd|j+dtd|j+dtd|j+d td!|j+d"td#|j+d$d%|j+d&d'td(|j+d)|j+dd*} | j-d+d*j-d,d*j/} |jjt0jt3j4t0j6j9d-|j+d&d*j5d-j#} t|| j:| j<|j+d|j+d"|j+dd*| |j+d tj. }|jj?| |jjAtd/| j+dd0d1td4| j+d5d6| j+d7d8| j+dd9| j+d:d;| j+d<d=| j+d>d?| j+d@dA| j+dBdC| j+dDrdEndFdG|jjtDjtDjF| j+d7k(jtDjHdHk(jK}|dIk(r&| j+d5dJk(rdK}n-| j+d5dLk(rdM}n| j+d5dNk(rdO}|jjtLjtLjN| j+dPk(j#}|jjtDjtDj |k(tDjPk(tDjHdHk(tDjRtjj dQk(tDjF| j+d7k(jK}|jjtLjtLjN| j+dPk(jK}|dIk(r$|dIkDrtEdoidR|j<dSdIdT|dUdHdVdWd7| j+d7d|dX| j+d<dYdIdZtU| j+d<d[z d\| j+d<tU| j+d<d[z z d]dId<| j+d<d^dId_dId`dIdadIdbdIdcdIdddIdedIdfd*dgd*dhtjj dQdi| j+d:}|jj?| |jjAtdj| j+d7d1tdl| j+d7dmy#tB$r7}t%|}td2| j+dd0d3|Yd}~d}~wwxYw#tB$r6}t%|}tdk| j+d7d3|Yd}~ld}~wwxYw#tjV$r#tdnt|j(YywxYw)pN8https://libredte.cl/api/dte/dte_emitidos/buscar/76063822 JXou3uyrc7sNnP2ewOCX38tWZ6BTm4D1%Y-%m-01receptor fecha_desdeapplication/jsonBearer Accept AuthorizationheadersrDRespuesta recibida:dtes2No se encontraron documentos o formato inesperado.*No se encontraron documentos para ese RUT.Se encontraron  documentos para el RUT : 0https://libredte.cl/api/dte/contribuyentes/info/GETInformación del contribuyente:RUT: r"-dvRazón Social: razon_socialGiro: giroActividad Económica: actividad_economica Teléfono: telefonoEmail: email Dirección: direccionComuna: comuna ( comuna_glosa)uÚltima Modificación: modificado+56 rT r" region_id commune_idrVaddressactivityphonerr=Cliente Cliente Desconocido guardado correctamente.zError al guardar el cliente : z Tipo: tipoz Folio: r!u$ Razón Social: z Fecha: fechaz Total: r:z Estado: estadoz Track ID: track_idz Usuario: usuariou# ¿Tiene XML?: has_xmlSíNozW ----------------------------- rrFactura electrónica!Boleta electrónica'Nota de crédito electrónica= sucursal_sii%Y-%mr9 cashier_idrgr#rYr_ cash_amount card_amountsubtotal ףp= ?taxdiscountticket_serial_number ticket_hourticket_transaction_numberticket_dispenser_number ticket_numberticket_station_number ticket_saticket_correlativer;r<rmr=DTE con folio "Error al guardar el DTE con folio El DTE con folio  ya existe en la base de datos.#La respuesta no es un JSON válido:),jsondumpsrnowrOrequestspostrI isinstancelistdictrrrrr r"r{r&requesttextgetrstriprrlowercommunerWrr8addrr%rr!r#r$rdte_codergrmroundJSONDecodeError)rr"urltokenpayloadrresponserDrrPrV raw_phone cleaned_phone commune_datastore_customerr(r)dte_qtyrgr>validate_dte_existencebranch_office_qty store_dtes r import_by_rutzDteClass.import_by_rutIsH2**#<<>22:>   )&ug.  ==gGDX !==?D ' .$%D$'FdNF|JKBC OCI;.Fse3O PA a77==7>>}?P?PTW?WX^^`LsSVxWCG'//sGRYZH(--(#==?D;<E$((5/!2!DHHTN3CDEODHH^,D+EFGF488F#3"4562488?GDHHW$5#678L+)>(?@AHTXXh%7$8488N;S:TTUVW3DHH\4J3KLM $R 8I$-$5$5eR$@$H$Hb$Q$W$W$YM#'77==#>#E#E$(JJ|/C/C$D$I$IAdhhWegiNjNpNpNrMsstJu$v$""'%'!&3"."8"8#/??!%.!9 $ 5!%&"!5+"hhw/#+<<> &NGGKK/@(AV)W(XXpqr 776?+,GGG,-.$$'GGN$;#<=GGG,-.GGG,-. WWX./0"wwz234!ggi012#,/GGI,>5D"IJ% ( )''--188377SZK[9[\ccdld{d{@AeABHHJa<wwv*@@&( ,AA&( ,KK&( $(GGMM2C$D$K$K-66#''.:QQ%%'".2WW]]8-D-K-K$LLC/$00K?$33q8$OOx||~/F/Fw/OO$NNcggg.>> .  %' +)- 6G(H(O(O-66#''.:QQ)%'&.27H17L$,%-:-=-=%'(%)4%,- % '( % #&'''"2 %!$%),(8%)*%&+3777+;D+@%A%!$ 059I$9N3O O%&'%#&'''"2%23%)*% 78!%"56#%$+,%%&34'%('()%*01+%,+--%.')/%0$,<<>#:#:7#C1%2(+www'73% 8 I.h(swww/?.@@XYZ -cggg.>-??^_`CA a`%@(+A  d?| j)d@dA| j)dBrdCndDdE|jjtBjtBjD| j)d5k(jG}|dFk(r| j)d3dGk(rdH}n0| j)d3dIk(rdJ}n| j)d3dKk(rdL}n|jjtHjtHjJ| j)dMk(j%}|jjtBjtBj|k(tBjL|k(tBjNdNk(tBjPtjjdOk(jG}|jjtHjtHjJ| j)dMk(jG}|dFk(r$|dFkDrtCdnidP|j:dQdFdR|dSdNdTdUd5| j)d5d|dV| j)d:dWdFdXtS| j)d:dYz dZ| j)d:tS| j)d:dYz z d[dFd:| j)d:d\dFd]dFd^dFd_dFd`dFdadFdbdFdcdFddtjjdOded)dfd)dg| j)d8}|jj=| |jj?t dh| j)d5d0at dk| j)d5dly#t@$r"}t d1t'|Yd}~gd}~wwxYw#t@$r4}t di| j)d5djt'|Yd}~d}~wwxYw#tjT$r$t dmt |jVY .wxYw)oN 66666666-6rrrrrrrrrrrrrrrrrrrr"rrrrrrrrrrrrrrrrrrrrrrrTrrrrzError al guardar el cliente: z Tipo: rz Folio: r!u Razón Social: z Fecha: rz Total: r:z Estado: rz Track ID: rz Usuario: ru ¿Tiene XML?: rrrz' ----------------------------- rrrrrrrrrrr9rrgr#rYr_rrrrrrrrrrrrrrrmr;r<r=rrrrrrr),rrrr r"rNrIrrrrrOrrrrrrr{r&rrrrrrrrWrr8rrr%rr!r$rrrgr#rmrrr)r customersrVr"rrrrrrDrrPinfo_urlrrrrr(r rgr>r r r s rrefresh_import_by_rutzDteClass.refresh_import_by_rutsGGMM-077 8I8I\8YZ^^` !^ %H (,, ,,CLC6Ejj'||~66zB"G -#*5'!2G  }}S'HHL %}}+T2dD)Dd+$XXYZ[$(HHZ$< (1(9(9%(D(L(LSRT(U([([(] '+ww}}\'B'I'I JJ|';';<AAAdhh~_aFbFhFhFjEkklBmn(%'%*7 #@Ll&<&1A1A)+,)-8)01 ) +, ) '*ggg&6 )%()-0GGG,<)-.)*/swww/?$/F)G)%(GGG$4uSWWW=MPT=T7U$U)*+)'*ggg&6)67)-.) ;e?c|ddk(s|ddk(rd|d<|ddk(rd|d<dt|dzdzt|dzd zt|d zd z}i}i}tjd ||| }|jSNrol_idr_r`rz*https://jisparking.com/api/dte/receivable//r"z ?api_token= api_tokenrPOSTrr&rrr user_inputsrrrrs rget_total_quantityzDteClass.get_total_quantity x A %X)>!)C$%K ! x A %$%K !:C H@U>ZPWEX3XY__a >!+,>!?%l3'}5!)  !  '}5 '}5$J/u%$J/!)&00F%G'}5+55P*Q)33L(M )9!"'11H&I#$%[1%&$..B#C'()9)*%[1+,&l3-C2 GGKK  1    1 #A  00 1s<D D;!D60D;6D;c|jjtjtj|k(j }|dkDryy)Nrr)rrrr r!r$)rr!check_existences r existencezDteClass.existencesA''--1#VHNNe$;<"UW  Q rrc8tj|dj}tj|tjj }|t dz}|jjtjtj|k(jtj|k(jtj|k\jtj|kj}||k(rdSdS)Nz%Y-%m-%dr)daysr)rstrptimedatecombinerptimerrrrr r9rr=r$) rtotal_machine_ticketr9rr=added_date_obj start_dateend_datequantitys rvalidate_quantity_ticketsz"DteClass.validate_quantity_ticketss!**:zBGGI%%nhll6G6G6IJ  q 1177==* VH--1AA B VH'':5 6 VH'':5 6 VH''(2 3 UW  44q;!;rc|jjtjtj j tj|k(j tj|k(j tjdk(j ttjt|k(j}|xsdS)Nr`r)rrrsumrrr r9rrYr r=r scalar)rr9rr=r\s rverifiy_credit_note_amountz#DteClass.verifiy_credit_note_amountstxx(<(<=> VH--1AA B VH'':5 6 VH&&!+ , VD,,d3zA B VX {rcF|dk(r |jjtjtj|k(jtj |k(jt tjt|k(jtj|k(j}|r6|jj||jjyy |jjtjtj|k(jtj |k(jt tjt|k(j}|r=|D]} |jj| |jjyy#t$r}t|}d|cYd}~Sd}~wwxYw#t$r}t|}d|cYd}~Sd}~wwxYw)Nrr5r)rrrr r9rr r=r r!r{deleterr%r&rN) rr!r9rr=singlerDr(r)records rr;zDteClass.deletes Q; 1ww}}X.#VH$=$=AQ$QR#VH$7$7:$EF#VD)<)OJ HX H0 2c!fXFGG Hs,F&L M$M  Mr!c d}d}d}dd|d}|jjtjtj|k(jtj dk(j }|std|y td |jid dd dd dddddddddddd|jddddddddddddddddddd} tj|||}|j|j} | r| djd } td| d } |d!| d!| d"} tj| |#} | j| j}|jd$ijd%ijd&}td'||r@d(||_ |jj|jj|ytd)y #t $r.}td*|jd+t#|Yd}~y d}~wwxYw),Nrrhrirrrru!No se encontró el DTE con folio r#rjrkrlrmrnrorprrPr!rrqrrrsrtr:rurvrwrzrr{r|rr}rr~rrrru(No se obtuvo código o authorizationCoderr)rrrr r!r#r{rIrrrrrrrrr%r&)rr!rrrrrPrrrDrkrrrrrr(s rget_dte_authorization_codez#DteClass.get_dte_authorization_codes2K C )&ug.  GGMM( # VHNNe+ , VH++q0 1 UW  5eW= > h " d   $    t  D     4  SYY  4  4  d  D  D  T 4! " 4# $' ,( }}ZwOH  % % '==?DaX.*F3* +_AfXQzlBij ( Xw G ..0)..0 S"%S,S,- #+-?@%$>?Q>R"SCKGGNN$GGOOC( < =  ,SYYKr#a&B C s(DH H I$II) NNNNNNNNNrr@) NNNNNNNNNNNrr@)__name__ __module__ __qualname__rr*rRr]rtrwrrr rrr!r&r)rrr5r9r;r^rfrintrrrrrr s -OAddAP  ~:F  ~:@F$^A@h!T`%D""&P -<"'1R1#f4bHUUrr)rapp.backend.db.modelsrrrrr sqlalchemyrror app.backend.classes.helper_classr r r rrrrdateutil.relativedeltarrrrrrrs5ii%8''(0 jjr