Xhz<ddlmZmZmZmZmZmZmZmZm Z m Z ddl m Z ddl m Z ddlmZddlmZddlmZddlZddlZddl mZGd d Zy) ) HonoraryModel EmployeeModelEmployeeLaborDatumModel UserModelBranchOfficeModelSupervisorModel BankModel RegionModel CommuneModelHonoraryReasonModel)desc)datetime) SettingClass) CommuneClass) HelperClassN)funccDeZdZdZd dZdZdZdZdZdZ d Z d Z y) HonoraryClassc||_y)N)db)selfrs N/var/www/intrajisbackend.com/public_html/app/backend/classes/honorary_class.py__init__zHonoraryClass.__init__ s Nc  g}|"|jtj|k(|'|dk7r"|jtj|k(t ||dk(s |dk(s|dk(r|j j tjtjtjtjtjtjtjjt t jtjk(jttjtj"k(jttj$tj&k(j(|j+tjj-}|j/|dz |zj1|j3} |j5} | |zdz |z} |dks|| kDry| sy| D cgc]R} | j| j| j| j| j| j| jdT} } n.|j j tjtjtjtjtjtjtjjt t jtjk(jttjtj"k(jttj$tj&k(j)tj&|k(j(|j+tjj-}|j/|dz |zj1|j3} |j5} | |zdz |z} |dks|| kDry| sy| D cgc]R} | j| j| j| j| j| j| jdT} } | | ||| dScc} wcc} w#t6$r}t9|}d |cYd}~Sd}~wwxYw) NzInvalid page number No data found) status_idid requested_byhonorary_reasonreplacement_employee_rutreplacement_employee_full_name added_date) total_items total_pages current_pageitems_per_pagedataError: )appendrbranch_office_idr%printrqueryr!r"r full_namer r$r&r' outerjoinrhonorary_reason_idrutr#filterorder_byr offsetlimitallcount Exceptionstr)rsearch_branch_office_id search_rutr5rol_idpager+filters data_queryr,r(r)honoraryserialized_datae error_messages rget_allzHonoraryClass.get_allsdP -G&2}==AXXY%**:}EEST &M{fkVq[TWW]]=+B+BMDTDTV_ViVik~lOlOQ^QwQwyFyeyegtgg@I/1B1E1EIgIg1ghI13F3I3I]MmMm3mnIi-:T:T)TUF  h}77<<>? "(($(n)DEKKN[__a(..0 *^;a?NR !8tk10*#'#("*!3!3"++$,$6$6'/'?'?080Q0Q6>6]6]"*"5"5$#(#(TWW]]=+B+BMDTDTV_ViVik~lOlOQ^QwQwyFyeyegtgg@I/1B1E1EIgIg1ghI13F3I3I]MmMm3mnIi-:T:T)TUF=55<=F h}77<<>?"(($(n)DEKKN[__a(..0 *^;a?NR !8tk10*#'#("*!3!3"++$,$6$6'/'?'?080Q0Q6>6]6]"*"5"5$#(#( +* $"0'  S#(>#($ -FM]O, , -sWHR<R<R<!AR28GR< R< R<AR7( R<2 R<< SSSSc |jjtjt t||k(j }id|j d|jd|jd|jd|jd|jd|jd|jd |jd |jd t!|j"d t!|j$d |j&dt!|j(dt!|j*dt!|j,dt!|j.t!|j0t!|j2d}t5j6|S#t8$r}t!|}d|cYd}~Sd}~wwxYw)Nr4r/ foreigner_idbank_idaccount_type_id schedule_id region_id commune_idr#r!employee_to_replacer%r&addressaccount_number start_dateend_date)amount observationr-)rr1rr6getattrfirstr4r/rJrKrLrMrNrOr#r!r=rPr%r&rQrRrSrTrUrVjsondumpsr<)rfieldvaluer,rErFrGs rgetzHonoraryClass.getds -77==/66w}e7TX]7]^ddfD$d&=&="D$9$9 1 14<<  "4#7#7  t// T^^doo 1 1T^^&s4+C+C'D+C0M0M,N1$2U2U3t||,!#d&9&9": c$//2!"C .#$dkk*"4#3#34'O,::o. . -FM]O, , -sF!F$$ G-G<GGc  t}|j|_|j|_|j|_|j|_|j |_|j |_|j|_|j|_||_ d|_ |j|_ |j|_ |j|_ |j|_|j|_|j dk7r |j dk7r|j |_|j"dk7r |j"dk7r|j"|_|j$|_|j&|_t)j*|_t)j*|_|j0j3||j0j5y#t6$r}t9|}d|cYd}~Sd}~wwxYw)NNonerr-)rr4r/rJrKrMrNrOrLr#r!rPr%r&rQrRrSrTrVrUrnowr' updated_dateraddcommitr<r=)rr#honorary_inputsrDrFrGs rstorezHonoraryClass.stores -$H*9*L*LH '(7(H(HH %$3$@$@H !.66H #2#>#>H !0!:!:H "1"<"#>H -44HO"*,,.H $,LLNH ! GGKK ! GGNN  -FM]O, , -sGG H(G=7H=Hc |jjtjtj|k(j }|j |_|j|_|j|_|j|_ |j|_ |j|_ |j|_ |j|_ d|_|j|_|j |_|j"|_|j$|_|j&|_|j(dk7r |j(dk7r|j(|_|j*dk7r |j*dk7r|j*|_|j,|_|j.|_t1j2|_t1j2|_|jj9||jj;|jdk(r|j=|y#t>$r}tA|}d|cYd}~Sd}~wwxYw)Nrr`rr-)!rr1rr6r"rXr4r/rJrKrMrNrOrLr!rPr%r&rQrRrSrTrVrUrrar'rbrcrdsendr<r=)rr"rerDrFrGs rgeneratezHonoraryClass.generates" -ww}}]3::=;K;Kr;QRXXZH*9*L*LH '(7(H(HH %$3$@$@H !.66H #2#>#>H !0!:!:H "1"<"#>H -44HO"*,,.H $,LLNH ! GGKK ! GGNN ++q0 /* -FM]O, , -sH8H;; IIIIc\ |jjtjtj|k(j }|r6|jj ||jjyy#t$r}t|}d|cYd}~Sd}~wwxYw)Nrr r-) rr1rr6r"rXdeleterdr<r=)rr"r,rFrGs rrkzHonoraryClass.deletes -77==/66}7G7G27MNTTVDt$ & -FM]O, , -sBB B+B& B+&B+cF|jjtjtj|jk(jt j tjt|jddk(j}|S)N ) rr1rr6r%rdater'r=r;)rr,s rvalidatezHonoraryClass.validatesww}}]+22=3Y3Y]a]z]z3z{CCDHDMDMN[NfNfDgknoso~o~k@CACkDDDEKKM rc(d}|jjtjtj|jk(j }t |jj}|jdz}tj|}d}|jjtjtj|jk(j }|jdz|zdz|zdzt|jz} tjdt|j } t#t%| t'|ddz } t%| t%|j z } t#| | z } || d | i|| d | id d d dddgid} ddz}t)j*|| d|dd}|jjtjtj|jk(j }d|_t/j0|_|jj5||jj7y)N JXou3uyrc7sNnP2ewOCX38tWZ6BTm4D1z-01 443000344_ _Honorario_. setting_datapercentage_honorary_billi& 221000223)debehaberIemitidosr)dtefolio)fechaglosadetalle operacion documentosz/https://libredte.cl/api/lce/lce_asientos/crear/76063822Bearer application/json Authorizationz Content-Type)rYheadersz%Accounting entry created successfully)rr1rr6r"rXrr]periodrconvert_to_utf8rr/ branch_officer=remove_from_stringrUroundintfloatrequestspostr!rrarbrcrd)r form_dataTOKENrDsettings american_date utf8_date expense_typergloss gross_amounttax net_amountr,urlresponses rimputezHonoraryClass.imputes^277==/66}7G7G9<<7WX^^`(,,.!((50 // > "  &78??  H$=$= = %'  ++    ill# $ #}77S=QR S.x7OPj7k1llm ,#hoo"66<#-. '"<%j#S !#%%'!.@:M=='.ug%6$677==/66}7G7G9<<7WX^^` (   H 6rc t|jj}t|jjd|j}t j }t jdt|j}tt|t|ddz }d}tjdddd id |id di|j|j |j"|j$d d d|j z|dgdd}dt|ddzdd}t'j(d|||} t+| j,y)Nr"rurvrwz4https://apigateway.cl/api/v1/sii/bte/emitidas/emitirpassz 76063822-6JYM1)r5claveFchEmis RUTEmisor)RUTRecep RznSocRecepDirRecep CmnaRecep)IdDocEmisorReceptorzBoleta de Honorarios para )NmbItem MontoItem) EncabezadoDetalle)authboletarapigetaway_tokenrrPOST)rr,r)rrr]rrOrget_time_Y_m_drr=rUrrrrYrZr%r&rQcommunerrequestr0text) rr,rr current_daterUrpayloadrrs rrhzHonoraryClass.send$sg(,,.tww'++D$//B"}335 11#s4;;7GHs6{U8N+CD^+_%``aD**$*+7-3-&)"-6|2*-83*9=8U8U;?;^;^8< 9@ 5* 3& 8TVZVyVy7y9?)*0&!+"B'Xn-EFX-Y)ZZ.  ##FCwO hmmr)NNNNrrm) __name__ __module__ __qualname__rrHr]rfrirkrorrhrrrr s6R-j-@ -D#-J - D7N4rr)app.backend.db.modelsrrrrrrr r r r sqlalchemyr r!app.backend.classes.setting_classr!app.backend.classes.commune_classr app.backend.classes.helper_classrrrYrrrrrrs;BBB::8 MMr