+ Rt^RIt^RIt^RIt^RIt^RIt^RIt^RI t ^RI t ^RI t ^RI t ^RI t ^RIt^RIHtHt^RIHt^RIHtHtHtHtHtHtHtHtRtR.RltRR.R R .R R ./t ]!4t!]"!] PF!R R44t$]t%]t&] PF!RR4POR4Uu0uF+pVPQ4'gKVPQ4kK- upt)] PF!RR4t*]!RR4t+]!RR4t,] PZP]] PZP_]044t1]!4t2] PfPh!R/R^R^ /]2Bt5RRRR/t6Rt7Rt8!RR ]PrPt4t;!R!R"]Px]PrPz4t>]?R#8Xd]!R$R%4] P!]14]>!R]$3];4;_uu_4tA]B!R&]$ 24]B!R'4]B!R(4]B!R)] R*24]B!R+4]B!R,4]AP4RRR4R#R#uupi ]Dd ]B!R-4L"i;i +'giR#;i)0u Servidor proxy local para Dashboard Talento Humano. Sirve el HTML y enruta /proxy/* hacia la API real (evita CORS). También expone /proxy/historico/* consultando PostgreSQL local. Uso: python3 servidor.py Luego abrir: http://localhost:8081 Nurlparseparse_qs)date)API_BASENOMINA_API_KEY PYG_API_KEYPYG_URL db_configenv_boolrequire_secrets ssl_contextc\P!RT;'gR4pRPRV44pRP\VP 4P 444#)uNormaliza nombre: quita tildes, uppercase, ordena palabras alfabéticamente. El orden permite comparar nombres con apellido-primero (API) vs nombre-primero (historico).NFKDc3b"TF%p\P!V4'dK!VxK' R#5iN) unicodedata combining).0cs& h/Users/ricardomartinez/BIA CLAUDE PROYECTOS/Proyectos Claude IA/Talento Humano Api Dashboard/servidor.py norm_name..(sFA[-B-B1-Eaas/ / )r normalizejoinsorteduppersplit)snfkdascii_ss& r norm_namer#$sS  b 1DggFFFG 88F7==?0023 44cZV'dGVPR4Uu.uF*q"P4'gKVP4NK, upM.pV'gR.3#\V4^8XdV R2V^,.3#RPR.\V4,4pV RV R2V3#uupi)zDevuelve (fragmento_sql, params) para filtrar por razon_social, admitiendo valores separados por coma (p.ej. 'SERV,SERVMYS,SERVMAN').,rz = %s%sz IN ())rstriplenr)razoncolrrazones placeholderss&& r razon_wherer0+sEJ%++c"2@"2Qggiyqwwy"2@rG 2v  7|qe}wqzl**88TFS\12LU% ~Q ' 00 As B(B(MANMANTILLACDONCDLCCARFARANDA COLLECTION CARTAGENAPORT8080CORS_ALLOWED_ORIGINSz+http://localhost:8080,http://localhost:8081r& ADMIN_API_KEYrAPP_REQUIRE_ADMIN_AUTHTAPP_DEBUG_ERRORSFminconnmaxconnvaluetsi,c4\P!4p\R,'d+V\R,, \8d\R,#\P 4pVP 4pVP R4VP4pV'dV^,'d V^,MRp\PV4RVPR44wrVWV3\R&V\R&WV3# \PT4i;i)uT(ano, mes) del último período con datos en historico_nomina_pyg (fuente='nomina').r?r@zCSELECT MAX(periodo) FROM historico_nomina_pyg WHERE fuente='nomina'z2024-01c38"TFp\V4xK R#5ir)intrps& rr*_get_max_periodo_nomina..rs3 21A 2s-) time_PERIODO_NOMINA_CACHE_PERIODO_NOMINA_TTLDB_POOLgetconncursorexecutefetchoneputconnr)nowconncurrowperiodoanomess r_get_max_periodo_nominarYes ))+CW%%31Ft1L+LOb+b$W-- ?? Dkkm YZllnCFF#a& 3 c 23HC&)Z'"%($ : s(8D!D0 DDc"aa]tRt^xtoV3RltRtRtRtV3RltRt Rt Rt R t R t R tR tR R/RltRtRt]R4tRtRtRtRtRtRtRtRtRt]R4t]R4t]R4t Rt!R t"V3R!lt#R"t$Vt%V;t&#)# ProxyHandlerc4<\SV`!VR\/VBR#) directoryN)super__init__DIR)selfargskwargs __class__s&*,rr_ProxyHandler.__init__zs $8#88r$cVPPR4pR\9dVPRR4R#V'd4V\9d'VPRV4VPRR4R#R#R#)Origin*zAccess-Control-Allow-OriginVaryN)headersgetr9 send_header)raorigins& r _send_corsProxyHandler._send_cors}sc!!(+ & &   :C @ "66   :F C   VX .7Vr$cfVPPR4;'gVPR8H#)z /proxy/admin//proxy/historico/cecos-sync)path startswithras&r_is_admin_pathProxyHandler._is_admin_paths0 II  1 : :yy99 r$c@VP4'd \'gR#\'gVPRRRRR/4R#VPP RR4p\ P!V\4'gVPRRRRR /4R#R#) TiokFerrorz;ADMIN_API_KEY no configurado para endpoints administrativosz X-Admin-Keyriz No autorizado)ruREQUIRE_ADMIN_AUTHr: _send_jsonrjrkhmaccompare_digest)rasupplieds& r_require_admin_auth ProxyHandler._require_admin_auths""$$,>,>} OOCeV" <<##M26""8];; OOC$w!H Ir$c<VPR8XdVP4R#VPR8XdVP4R#VPPR4'dVP 4R#VPPR4'dVP 4R#VPPR4'dVP 4R#\SV`!4R#)z/proxy/nomina/hoteles-nitNz/proxy/nomina/conceptos-map /proxy/stats//proxy/historico//proxy/) rr_nomina_hoteles_nit_nomina_conceptos_maprs_stats _historico_proxyr^do_GET)rards&rrProxyHandler.do_GETs 993 3  $ $ &  YY7 7  & & (  YY ! !/ 2 2 KKM  YY ! !"5 6 6 OO  YY ! !) , , KKM GN r$cVP4'gR#VPR8XdVP4R#VPR8XdVP4R#VPR8XdVP 4R#VPR8XdVP 4R#VPR8XdVP 4R#VPR8XdVP4R#VPR8XdVP4R#VPR8XdVP4R#VPR 8XdVP4R#VPR 4VP4R#) Nrqz/proxy/admin/sync-hotelesz/proxy/admin/sync-cargosz/proxy/admin/sync-cecosz/proxy/admin/sync-irz/proxy/rrhh/ingresos-retirosz/proxy/nomina/reportez/proxy/pyg/reportez/proxy/admin/sync-conceptos) rrr _cecos_sync _sync_hoteles _sync_cargos_sync_cecos_xlsx_sync_ir _proxy_post_nomina_reporte _pyg_reporte_sync_conceptos_xlsx send_response end_headersrts&rdo_POSTProxyHandler.do_POSTs ''))  995 5     YY5 5    YY4 4     YY3 3  ! ! # YY0 0 MMO YY8 8     YY1 1  " YY. .     YY7 7  % % '   s #    r$cVP^4VP4VPRR4VPRR4VP4R#)zAccess-Control-Allow-MethodszPOST, GET, OPTIONSzAccess-Control-Allow-HeaderszContent-Type, X-Admin-KeyN)rrnrlrrts&r do_OPTIONSProxyHandler.do_OPTIONSsJ 3  79MN 79TU r$c Z ^RIp\PP\R4p\PP V4'g\ RV 24hVPV4p.ROVnVPR ,PRR7p\P4pVP4p^pVP4EFbwrxVPVR,4'g!\!VR,4P#4MRp V 'gKPVR,p VPV 4'g!\!V 4P%R4'dRM\!V 4P#4p VPVR,4'g!\!VR,4P#4MRp VPVR,4'g!\!VR,4P#4MRp VPVR,4'g\'VR,4MRpVPVR ,4'g\'VR ,4MRpVPVR ,4'g\'VR ,4M^pVPVR ,4'g!\!VR ,4P#4MRpVPVR ,4'g!\!VR ,4P#4MRpVP)RWWWVVV3 4V^, pEKe VP+4VP-4\P/V4\1RV R24\2P4!RRRV/4P74pVP9^4VP;RR4VP=4VP?4VP@PCV4R# \DdpTP9R4TP;RR4TP=4TP?4TP@PC\2P4!TPGTRR74P744Rp?R#Rp?ii;i)NzUnificacion_Hoteles.xlsxNo se encontró razon_socialhotel_name_api bu_codigo bu_nombreregistros_historicomeses_historico activos_apinombre_personalizadonotas:NNTdropu—a INSERT INTO hotel_unificacion (razon_social, hotel_name_api, bu_codigo, bu_nombre, registros_historico, meses_historico, activos_api, nombre_personalizado, notas, actualizado_en) VALUES (%s,%s,%s,%s,%s,%s,%s,%s,%s,NOW()) ON CONFLICT (razon_social) DO UPDATE SET hotel_name_api = EXCLUDED.hotel_name_api, bu_codigo = EXCLUDED.bu_codigo, bu_nombre = EXCLUDED.bu_nombre, registros_historico = EXCLUDED.registros_historico, meses_historico = EXCLUDED.meses_historico, activos_api = EXCLUDED.activos_api, nombre_personalizado = EXCLUDED.nombre_personalizado, notas = EXCLUDED.notas, actualizado_en = NOW() u% ✅ hotel_unificacion actualizada:  filasrx actualizadas Content-Typeapplication/json; charset=utf-8application/jsonFrx) rrrrrrrrr)$pandasosrrrr`existsFileNotFoundError read_excelcolumnsiloc reset_indexrLrMrNiterrowsisnastrr)rsrDrOcommitcloserQprintjsondumpsencoderrlrnrwfilewrite Exception_error_payload)rapdxlsxdfrSrTupdated_r-rshan_rawhanbucbunrhmhaanp_ntrespes& rrProxyHandler._sync_hotelessE T 77<<%?@D77>>$'''*:4&(ABBt$BBJ ((d(3B??$D;;=CG ;=771^CT;U;US>*+113[_,-!www//3w<3J3J53Q3QdX[\cXdXjXjXlDFGGAkND[D[c!K.)//1lpDFGGAkND[D[c!K.)//1lpDFGGANcLdDeDec!123lpDFGGAN_L`DaDac!-./lpDFGGAmL\D]D]c!M*+lmDFGGANdLeDfDfc!234::7CDKKMD   s #   ^-N O OO      JJ  T " T   s #   ^-? @ OO      JJ  TZZ(;(;A%(;(HIPPR S S  TsXA PCP!PAP?P?P1P 1P=1P/?P/DP R*BR%%R*c \^RIp\PP\R4p\PP V4'g\ RV 24hVPV^R7p.ROVnVPR.R 7PR R 7p\P4pVP4p^pVP4EFawrx\VR,4P!4p VP#VR,4'g!\VR,4P!4MRp VP#VR,4'g\%VR,4MRp VP#VR,4'g\%VR,4MRp VP#VR ,4'g\VR ,4R,MRp VP#VR ,4'g!\VR ,4P!4MRpVP'RWWW34V^, pEKd VP)4VP+4\P-V4\/RV R24\0P2!RR RV/4P54pVP7^4VP9RR4VP;4VP=4VP>PAV4R# \BdpTP7R4TP9RR4TP;4TP=4TP>PA\0P2!TPETRR74P544Rp?R#Rp?ii;i)rNzUnificacion_Cargos.xlsxrheadercargo_originalcargo_unificado num_hoteles registros_pg ultima_fechahotelessubsetTr:N Na INSERT INTO cargo_unificacion (cargo_original, cargo_unificado, num_hoteles, registros_pg, ultima_fecha, hoteles, actualizado_en) VALUES (%s,%s,%s,%s,%s,%s,NOW()) ON CONFLICT (cargo_original) DO UPDATE SET cargo_unificado = EXCLUDED.cargo_unificado, num_hoteles = EXCLUDED.num_hoteles, registros_pg = EXCLUDED.registros_pg, ultima_fecha = EXCLUDED.ultima_fecha, hoteles = EXCLUDED.hoteles, actualizado_en = NOW() u% ✅ cargo_unificacion actualizada: rrxrrrrrFr)rrrrrr)#rrrrrr`rrrrdropnarrLrMrNrrr)rrDrOrrrQrrrrrrlrnrrrrr)rarrrrSrTrrr-cocunhrpgufhotrrs& rrProxyHandler._sync_cargoss6 T 77<<%>?D77>>$'''*:4&(ABBtA.BCBJ#3"45AAtALB??$D;;=CG !,-.446?AwwqIZG[?\?\c!-./557bf46GGAmAR9S9Sc!N+,S1Y]79wwq|7L7Lc!I,'--/RV br/ 11 +&. KKM IIK. 9'&I J::tT>7CDKKMD   s #   ^-N O OO      JJ  T " T   s #   ^-? @ OO      JJ  TZZ(;(;A%(;(HIPPR S S  Ts9A LDL1L1L:8L3DL N+BN&&N+c  ^RIp\PP\R4p\PP V4'g\ RV 24hVPV^R7p.ROVnW3R,P4,pW3R,P\4PP4PP4R8g,pVPRR 7p\P!4pVP#4p^p^pVP%4Fwr\V R,4P4p VPV R,4'dF\V R,4P4R9d!\V R,4P4MRp V 'gKVP'R W34V 'd V^, pKV^, pK VP)4VP+4\P-V4\/R V R V R 24\0P2!RRRVRV/4P54p VP7^4VP9RR4VP;4VP=4VP>PAV 4R# \Bdp TP7R4TP9RR4TP;4TP=4TP>PA\0P2!TPET RR74P544Rp ? R#Rp ? ii;i)zJLee Unificacion_CECOs.xlsx y actualiza ceco_unificado en ceco_unificacion.NzUnificacion_CECOs.xlsxrr ceco_originalceco_unificadozLEYENDA:Trad INSERT INTO ceco_unificacion (ceco_original, ceco_unificado, actualizado_en) VALUES (%s, %s, NOW()) ON CONFLICT (ceco_original) DO UPDATE SET ceco_unificado = EXCLUDED.ceco_unificado, actualizado_en = NOW() u ✅ ceco_unificacion: z mappings aplicados, z sin unificadorxmapeados sin_unificadorrrrFr)rfuente empleados_apirrr)rnan)#rrrrrr`rrrrnotnaastyperr)rrrLrMrNrrOrrrQrrrrrrlrnrrrrr)rarrrrSrTrskippedrr-rrrrs& rrProxyHandler._sync_cecos_xlsxOs: T 77<<%=>D77>>$'''*:4&(ABBtA.BEBJ'--/0B'..s377==?CCIIKzYZBT*B??$D;;=CGG ?+,224#3!455#a@P>Q:R:X:X:Zbm:m+,-335 XqLGqLG'&* KKM IIK. ,WI5J7)Sab c::tT:wQXYZaacD   s #   ^-N O OO      JJ  T " T   s #   ^-? @ OO      JJ  TZZ(;(;A%(;(HIPPR S S  Ts'A K E7K DK M4BM//M4c\VPPR^44p\P!VP P V4PR44pVPR.4p\P4pVP4p.pVFpVPRR4P4pVPRR4p VPR^4p V'gKQVPRWW34VP4p V 'gKV ^,'gKVPV4K VP4VP!4\P#V4V'd\%R V 24\P&!R \)V4R V/4P+4p VP-^4VP/R R 4VP14VP34VP4P7V 4R# \8dp TP-R4TP/R R4TP14TP34TP4P7\P&!TP;T 44P+44Rp ? R#Rp ? ii;i)Content-Lengthutf-8cecoskeyrrAPIra INSERT INTO ceco_unificacion (ceco_original, ceco_unificado, fuente, empleados_api, notas) VALUES (%s, %s, %s, %s, 'Auto-detectado') ON CONFLICT (ceco_original) DO UPDATE SET empleados_api = EXCLUDED.empleados_api, actualizado_en = NOW() RETURNING (xmax = 0) AS es_nuevo u ✅ CECOs nuevos registrados: insertadosnuevosrrrrN)rDrjrkrloadsrfilereaddecoderLrMrNr)rOrPappendrrrQrrr*rrrlrnrrrrr)ralengthbodyrrSrTinserteditemrrcountrUrrs& rrProxyHandler._cecos_syncs/ J))*:A>?FZZ  7 > >w GHDXXgr*E??$D;;=CH%,224(E2/15 .0lln33q66OOC(#& KKM IIK OOD !8 CD::|S]HhOPWWYD   s #   ^-N O OO      JJ  T " J   s #   ^-? @ OO      JJ  TZZ(;(;A(>?FFH I I  Js-DH  H /AH BH K+BKKcaaRp^RIo^RIo\PP V4'g\ RV 24hSP VRR7p.R#OVnV3RlpV3RlpV3RlpV3Rlp\P4pVP4pVPR4VPR4VP4VPR4VP4U U u.uFwrV!V R,4V!V R,4V!V R,4V!V R,4V!V R ,4V!V R ,4V!V R ,4V!V R ,4V!V R ,4V!V R,4V!V R ,V R,V R ,43 NK p p p \PP!VRV 4VP4VPR4VP#4^,p VP%4\P'V4\)RV R24\*P,!RRRV /4P/4p VP1^4VP3RR4VP54VP74VP8P;V 4R#uup p i \<dpTP1R4TP3RR 4TP54TP74TP8P;\*P,!TP?TR!R"74P/44Rp?R#Rp?ii;i)$z/Users/ricardomartinez/Library/CloudStorage/OneDrive-farandahotels.com/Business Intelligence/Talento Humano/Base de Datos Historicos/Ingresos y Retiros Empleados Historicos.xlsxNuNo se encontró: Hoja1) sheet_namernombre_completoingresocargotipo_movimiento sueldo_base tipo_contratotermino operacion causa_retiroc<Ve.\V\4'dSPV4'dR#\V4P 4;'gR#r) isinstancefloatisnanrr))vnps&rcl!ProxyHandler._sync_ir..cls:9Au!5!5"((1++t1v||~---r$c<SPV4pSPV4'dR#VP4# R#;ir) Timestamprr)rr@rs& rcd!ProxyHandler._sync_ir..cds9$aB#%772;;4=BGGI=#ts'===Acb<\V4pSPV4'dR#T# R#;ir)rr)rfr s& rcn!ProxyHandler._sync_ir..cns/$aA#%88A;;45A5#ts!))).c<\V4P4R8XdSPV4pMSPV4pSPV4'dR#VP RVP R 2# R#;i)RNrH02d)rrr$ryearmonth)tipo ingreso_val termino_valr@rs&&& rcp!ProxyHandler._sync_ir..cpsh$4y(C/\\+6\\+6wwr{{4 ggYa~66#tsAA9A99A>am CREATE TABLE IF NOT EXISTS historico_ir ( id SERIAL PRIMARY KEY, razon_social TEXT, nombre_completo TEXT, ingreso DATE, cargo TEXT, tipo_movimiento TEXT, sueldo_base NUMERIC(14,2), tipo_contrato TEXT, termino DATE, operacion TEXT, causa_retiro TEXT, periodo VARCHAR(7) ) zb ALTER TABLE historico_ir ADD COLUMN IF NOT EXISTS periodo VARCHAR(7) z,TRUNCATE TABLE historico_ir RESTART IDENTITYa INSERT INTO historico_ir (razon_social,nombre_completo,ingreso,cargo,tipo_movimiento, sueldo_base,tipo_contrato,termino,operacion,causa_retiro,periodo) VALUES (%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s) z!SELECT COUNT(*) FROM historico_iru ✅ historico_ir actualizado: rrxTtotalrrrrFr) rrrrrrrrrr) rnumpyrrrrrrrrLrMrNrOrrpsycopg2extras execute_batchrPrrQrrrrrrlrnrrrrr)raXLSX_IRrr!r%r)r3rSrTrr-rowsr5rrr rs& @@rrProxyHandler._sync_irs ;  [ T ,77>>'**'*;G9(EFFw7;B@BJ . $  $ $??$D;;=C KK " KK  KKM KKF GKKM  *DA An%&1->+?(@"Qy\BRAgJA&7$8!92a >N;OAo&'AiL)9AkN#R.(9%:A'(!I,) E G *  OO ) )#0    KKM KK; <LLN1%E IIK. 4UG6B C::tT7E:;BBDD   s #   ^-N O OO      JJ  T "34 T   s #   ^-? @ OO      JJ  TZZ(;(;A%(;(HIPPR S S  Ts2,KB&DK>K M+BM&&M+rxNc/pVeW#R&\'d \V4MRVR&\'d^RIpVP4VR&V#)Nrxz Error internorytrace) DEBUG_ERRORSr traceback format_exc)raexcrxpayloadr@s&&$ rrProxyHandler._error_payload&sG >DM'3|3s8 < (335GG r$c\P!V\RR7PR4pVP V4VP RR4VP 4VP4VPPV4R#)Fdefault ensure_asciirrrN) rrrrrrlrnrrr)racodeobjr s&&& rr{ProxyHandler._send_json0sfzz#s?FFwO 4  )JK   r$c\VPPR^44pV'dVPP V4MRp\ P !T;'gR4V3#)rs{})rDrjrkrrrr)rar raws& r_read_json_bodyProxyHandler._read_json_body8sNT\\%%&6:;)/djjoof%Uzz#,,',,r$c D\V4\V43\48*#)ujRetorna True si (ano, mes) <= último período cargado en historico_nomina_pyg → usar caché PostgreSQL.)rDrY)rWrXs&&r_is_periodo_historico"ProxyHandler._is_periodo_historico=s C#c(#'>'@@@r$c  \V,p\PPW2R\RR/RR7p\PP V^<\ R7;_uu_4pVP4pRRR4VP^4VPRR4VP4VP4VPPX4R# +'giLp;i \PPdpTPTP 4TPRR4TP4TP4TPP\"P$!R\'T4/4P)44Rp?R#Rp?i\*dpTPR 4TPRR4TP4TP4TPP\"P$!R\'T4/4P)44Rp?R#Rp?ii;i) u/Proxy POST a la API externa con body ya leído. X-API-KeyrrPOSTdatarjmethodtimeoutcontextNry)rurllibrequestRequestAPI_KEYurlopenSSL_CTXrrrlrnrrrry HTTPErrorrIrrrrr)raapi_pathr urlreqrrWrs&&& r_proxy_post_bodyProxyHandler._proxy_post_bodyBs! E..(($g~?QR)C ''R'IITyy{J   s #   ^-? @ OO      JJ  T " JI||%% E   qvv &   ^-? @ OO      JJ  TZZ#a&(9:AAC D D E   s #   ^-? @ OO      JJ  TZZ#a&(9:AAC D D  EsEAC3'C 8A&C3 C0 +C33IBF-- I:I;B I  Ic "VP4wr\VPRR44P4p\ VPR^44p\ VPR^44pV'dV'dV'dVP WE4'd\ P4pVP\PPR7pVPRWEV34VP4pVP4\ PV4V'dVP!^VR,4#VP#RV4# \$d(p TP!R R \T 4/4uR p ? #R p ? ii;i) uJPOST /proxy/nomina/reporte con caché histórica PostgreSQL hasta 2026-05. hotel_nitrrWrXcursor_factoryam SELECT raw_data FROM historico_nomina_pyg WHERE fuente='nomina' AND registro_tipo='respuesta' AND ano=%s AND mes=%s AND nit=%s ORDER BY cargado_en DESC LIMIT 1 raw_data/nomina/reporter\ryN)rNrrkr)rDrQrLrMrNr7r8RealDictCursorrOrPrrQr{rgr) rarCraw_bodynitrWrXrSrTrUrs & rrProxyHandler._nomina_reporte`s. ; $ 4 4 6 Ggkk+r2399;Cgkk%+,Cgkk%+,Csst'A'A#'K'K({{(//2P2P{Q _ &lln W__T2??3J@@(():HE E ;??3#a&(9: : ;s1BEE B>E E F'F F Fc ^RIp^RIp\P4pVP VP P R7pVPR4VP4pVP4\PV4RVUu.uFp\V4NK up/p\P!V4P!4pVP#^4VP%RR4VP'4VP)4VP*P-V4R#uupi \dpR.R\T4/pRp?LRp?ii;i)z Lee hotel_unificacion JOIN empresas para devolver la lista de hoteles con NIT configurado, uno por fila (separados por BU cuando aplica). Responde: { hotels: [{label, nit, hotel_api, bu_codigo, bu_nombre}] } Nrka SELECT DISTINCT ON (h.nombre_personalizado, e.nit, h.bu_codigo) h.nombre_personalizado AS label, e.nit, h.hotel_name_api AS hotel_api, h.bu_codigo, h.bu_nombre, e.pyg_company_id FROM hotel_unificacion h JOIN empresas e ON h.razon_social = e.codigo WHERE e.nit IS NOT NULL AND e.nit <> '' AND h.hotel_name_api IS NOT NULL AND h.hotel_name_api <> '' AND h.nombre_personalizado NOT IN ('No mostrar') ORDER BY h.nombre_personalizado, e.nit, h.bu_codigo hotelsryrrr7psycopg2.extrasrLrMrNr8rorOfetchallrrQdictrrrrrrrlrnrrr rar7rSrTr;r-rWexrs & rr ProxyHandler._nomina_hoteles_nits  4 ,??$D;;hoo.L.L;MC KK "<<>D IIK.51tAw56Dzz$&&( 3 )JK   6 4b'3r73D 4s*B D0D+#D0+D00 E;EEc ^RIp^RIp\P4pVP VP P R7pVPR4VP4pVP4\PV4RVUu.uFp\V4NK up/p\P!V\R7P!4pVP#^4VP%RR4VP'4VP)4VP*P-V4R#uupi \dpR.R\T4/pRp?LRp?ii;i) uNGET /proxy/nomina/conceptos-map — devuelve tabla nomina_conceptos como JSON.Nrka; SELECT codigo, regexp_replace(codigo, '_v[0-9]+$', '') AS codigo_api, nombre, tipo, grupo, subgrupo, nombre_display, incluir FROM nomina_conceptos ORDER BY tipo, grupo NULLS LAST, subgrupo NULLS LAST, codigo conceptosry)rGrrrurys & rr"ProxyHandler._nomina_conceptos_maps 7 ,??$D;;hoo.L.L;MC KK <<>D IIK.4!84a$q'4!89Dzz$,335 3 )JK   "9 7Wc"g6D 7s*B D6D1#D61D66 EEEc ^RIp^RIp\PP \ R4p\PP V4'gC\PP\PP \ RR44pVPVR^R7p\VP4p\V4^8d^R^R^R^R ^R ^R ^R /pM^R^R^R^R ^R ^R ^R /pVP4UUu/uF wrxV\V48gKWW,VbK" p ppVPV R 7pVPR.R7p\P!4p V P#4p ^p VP%4EFwr\'VP)R R4;'gR4P+4P-4R8XdRMRpT P/R\'VR,4P+4VP1VR,4'd!\'VR,4P+4MRVP1VR,4'd!\'VR,4P+4MRVP1VP)R 44'd!\'VR ,4P+4MRVP1VP)R 44'd!\'VR ,4P+4MRVP1VP)R 44'd!\'VR ,4P+4MRV34V ^, p EK V P34V P/R4V P54^,pV P74\P9V 4RRRV RV/p\<P>!V4PA4pVPC^4VPERR4VPG4VPI4VPJPMV4R#uuppi \:dpRRR\'T4/pRp?LRp?ii;i)uQPOST /proxy/admin/sync-conceptos — lee Conceptos_Nomina_Mapeo.xlsx y upsert BD.NzConceptos_Nomina_Mapeo.xlsxz../../..uMapeo Agrupación)rrcodigonombrer0incluirgruposubgruponombre_display)rrSNFTa INSERT INTO nomina_conceptos (codigo, nombre, tipo, grupo, subgrupo, nombre_display, incluir) VALUES (%s,%s,%s,%s,%s,%s,%s) ON CONFLICT (codigo) DO UPDATE SET nombre = EXCLUDED.nombre, tipo = EXCLUDED.tipo, grupo = COALESCE(NULLIF(EXCLUDED.grupo,''), nomina_conceptos.grupo), subgrupo = COALESCE(NULLIF(EXCLUDED.subgrupo,''), nomina_conceptos.subgrupo), nombre_display = COALESCE(NULLIF(EXCLUDED.nombre_display,''), nomina_conceptos.nombre_display), incluir = EXCLUDED.incluir, actualizado_en = NOW() rDevengoz=SELECT COUNT(*) FROM nomina_conceptos WHERE grupo IS NOT NULLrx procesados con_gruporyrr)'rr7rrrrr`rabspathrlistrr*itemsrenamerrLrMrNrrrkr)rrOrrrPrrQrrrrrrlrnrrr)rarr7rrcolscol_mapinamerrSrTrrrUrrmsgrzrs& rr!ProxyHandler._sync_conceptos_xlsxs3 2 )77<<%BCD77>>$''wwrww||CEb'cdt0CANB #D4yA~Xq1VQy!GUVWacdeuvXq1VQy!GUVWacdeuv3:==?T?a#d)mmdgtm?FT6*B8*-B??$D;;=CG++-#&swwy'='D'D#E#K#K#M#S#S#UY\#\%bf H &,,.24((3x=2I2ICH &,,.r24((3v;2G2GCF $**,y24((3777;K2L2LCG %++-RV46HHSWWZ=P4Q4QCJ(..0W[:<((377K[C\:]:]C,-.446cg(1 -(. KKM KKW X||~a(H IIK.|Wk8LCzz#%%' 3 )JK   UUF 2R1C 2sTAQB/QQ Q(D5QAQ%AQ,AQ3BQQ Q<#Q77Q<c a#VP4wr\VPR^44p\VPR^44pVPR4pVPRR.4;'gR.pVUu.uF=p\V4P 4'gK$\V4P 4NK? ppV'EdV'EdV'EdVP W44'Ed\P4pVP\PPR7p V PRW4\V4V34V P4p V 'dV P4\P!V4\VPRR 44P 4p V U u.uFZp R V R ,R V R ,RV R,RV R,RV R,;'g^RV R,;'g^RRRV R,/NK\ p p VP#^RV R\V4RV VR 2RV /4#V PRW4\V434V P4pV P4\P!V4V'EdV#3Rlo#/pVFpVPR4;'gRP 4pVV9d V'dK=VR,;'g/PR/4pV.\%VP'44,F9pVPV/4PR.4pV'gK/S#!VV4K K V'gVF|pVR,;'g/PR/4p\%VP'44F9pVPV/4PR.4pV'gK/S#!VV4Kz K~ .R+Op/pVP)4F,wppVP+R4R,,pVV9gK'VVV&K. \-4.ppVFwppppp VV9dKVPV4;'gVPV4p!V!fKBVP/V4VP/VP1R!R"4P1R#R$4P1R%R&4P1R'R(44VP3R VR VRVRVRV!R,RV!R,RRRV /4K V'dPVP#^R\VPRR 44P 4R\V4RV VR 2RV/4#VP5WWSV4#uupiuup i \6d(p"TP#R)R*\T"4/4uR p"?"#R p"?"ii;i)-uxPOST /proxy/pyg/reporte con caché histórica PostgreSQL hasta 2026-03. Body: { nit, ano, mes, company_id, bu_codigos } rWrX company_id bu_codigosLocalrka SELECT concepto_codigo, concepto_nombre, grupo, subgrupo, SUM(valor)::float AS val, SUM(valor_ly)::float AS ly, BOOL_OR(COALESCE((raw_data->>'nomina_backed')::boolean, false)) AS nomina_backed FROM historico_nomina_pyg WHERE fuente='pyg' AND registro_tipo='concepto' AND ano=%s AND mes=%s AND company_id=%s AND LOWER(COALESCE(bu_codigo,'')) = ANY(%s) GROUP BY concepto_codigo, concepto_nombre, grupo, subgrupo ORDER BY grupo, subgrupo, concepto_nombre rqridconcepto_codigorconcepto_nombrerrvallyrpyg nomina_backedperiodr-r}a SELECT raw_data, bu_codigo FROM historico_nomina_pyg WHERE fuente='pyg' AND registro_tipo='respuesta' AND ano=%s AND mes=%s AND company_id=%s ORDER BY cargado_en DESC c l<VEFpVPRR4pVPR/4pVPR/4pRp\V\4'dtVP4F_wrx\V\\ 34'dTpM>\V\4'gK=VPRVPRR44pM VPR/4p Rp \V \4'dtV P4F_wrx\V\\ 34'dTp M>\V\4'gK=VPRVPRR44p M RTRVPRR4R T;'gRR T ;'gR/W&S !VPR .4V4EK R # rrmonthlyrealrArXr? last_yearlabelrrchildrenNrkrrxrrDr) nodesoutnnidrrrkrly_dataly_val_flattens && rr+ProxyHandler._pyg_reporte.._flatten?sk!&A&'eeD"oC&'eeIr&:G&-kk&"&=D&)C)$55,0JJLDA'1!c5\'B'B./)3At)<)<./eeE155#;N.OQV -9 '.kk+r&BG&)F)'488,3MMODA'1!c5\'B'B12E)3At)<)<12uaeeGS>Q1RTY -< )-c7AEE'"||~IIK!6gkk%45;;=C $ !% $!+<)= +<)=7":5Q4Q '?); " $ !% ??3c$c*o c#Y&7#i 1  J0 2 LLN  W__T29A.D ) $ 5 @ @GGIz1j$#J/552::5"E#'&4 +;";";B#&772r?#6#6vr#BD#t (t 4 % #< !* $-D#' #3#9#9r">">ub"IC&*388:&6'*wwr2':':62'F#'4$,T4$8$) '7%.!I."$J $ 1 ! R 0 201Ju-!- +.%-DMVI&%="d?H $ 1 L LZ^^G5L =()c!:!B!B4!L!T!TUYZ]!^!f!fgklo!pq%,, '8VWeZYa!5<uT{$e_m. NW%#s!#gkk%.C*D*J*J*L(#j/$SE#c*;'- 5 ((jsS SgP2 !%x ;??3#a&(9: : ;sA2V6V>!V $V VVCV<9V6V V)VA?VV&V8AVV5V AV%A V4AV5B4V*AV9V V W!W=WWc Haaa\VPRR44P4pS'gV'gVPRRR/4#\P 4pVP 4pVPRV34VP4p VP4\PV4V 'gVPRRRV 2/4#V ^,oV'd V'gVPRRR /4#V VR 2o\P!R SR SR RRVRR/4P4p VV3Rlp V !V4p V3RloV PR/4p /pVFpV PV/4pVPR.4pV'gK1/pS!VV4VP4FywppVV9dRVRVR,RRRR/VV&VV,R;;,VPRR4, uu&VV,R;;,VPRR4, uu&K{ K V'g(RV 9d!S!V R,PR.4V4V'gLRV9dEV !R.4p V PR/4p S!V PR/4PR.4V4.R+Op\4p.pVFwpppppVV9dKVPV4pVfK)VP!V4VP#RR4P#RR4P#R R!4P#R"R#4pVP!V4VP%RVR$VR%VR&VRVR,RVR,R'R(R)V/4K VP^RVR SR SR*V/4#),z?Llama a la API P&G real y devuelve conceptos de gasto personal.rqriryu$Faltan parámetros: company_id o nitz`SELECT DISTINCT pyg_company_id FROM empresas WHERE nit=%s AND pyg_company_id IS NOT NULL LIMIT 1rzNo hay pyg_company_id para NIT uFaltan parámetros: ano, mesr-rr scenario_idNbusiness_units include_kpisFc <\P!RSRSRRRVRR/4P4p\PP \ VR\RR /R R 7p\PPV^\R 7;_uu_4p\P!VP44uuRRR4# +'giR#;i rrrNrrFrTrrrUrVrY rrrr]r^r_r PYG_KEYrarbrr)bu_listr rfrrrs& r _request_pyg3ProxyHandler._pyg_reporte_api.._request_pygs::*&$ '%  vx ..((d$g~?QR)C ''R'IITzz$))+.JIIIs $B<< C c l<VEFpVPRR4pVPR/4pVPR/4pRp\V\4'dtVP4F_wrx\V\\ 34'dTpM>\V\4'gK=VPRVPRR44pM VPR/4p Rp \V \4'dtV P4F_wrx\V\\ 34'dTp M>\V\4'gK=VPRVPRR44p M RTRVPRR4R T;'gRR T ;'gR/W&S !VPR .4V4EK R #rr) rrrrrrrrrrr flatten_trees && rr3ProxyHandler._pyg_reporte_api..flatten_treesf%%b/%% 2.!++fb1dD)) $ %a#u66"#CU'400"#%%quuWc/B"CCU !- "++k26gt,, ' %a#u66%&F'400%&UU5!%%2E%FF !0 !#wgr0BE3::RUW[]c]j]jgjkQUU:r2C8)r$rrrrrrArrrrrrrrrrrrrrrrr}r)rrkr)r{rLrMrNrOrPrrQrrrrrrrr) rarCrrrWrXrqconrTrUpyg_bodyrrMrrbu_key bu_sectionrbu_flatrrrrrrrrrraltrrs &&&f&& @@rrProxyHandler._pyg_reporte_apis'++eR()//1sW6\,]^^//#C**,C KKz~A}C D,,.C IIK-sW8WX[W\6],^__QJ#??32P(QR RU3s)$:: j f d j e   68  / :& 9.wwub! F,J#3DG w '%mmo Ud?!%sGU7^UCQUWZ [DIS % EIIeS$99 S $EIIdS$99 .!3 W))&"5t <z1y)C''%$C "-11&"=t D 2u AJ =WfeX}$HHW%E} HHW //$s+33D=EEd3OWWX\]`aC HHSM  ut " BK(s # * & - %   r$c XVP\R4Rp\V,p\VPP R^44pVP PV4p\PPW$R\RR/RR7p\PPV^<\R7;_uu_4pVP4pRRR4VP^4VPRR4VP!4VP#4VP$P'X4R# +'giLp;i \P(P*dpTPTP,4TPRR4TP!4TP#4TP$P'\.P0!R \3T4/4P544Rp?R#Rp?i\6dpTPR 4TPRR4TP!4TP#4TP$P'\.P0!R \3T4/4P544Rp?R#Rp?ii;i) /proxyNrrTrrrUrVrYryr\)rrr*rrDrjrkrrr]r^r_r`rarbrrlrnrrrryrcrIrrrrr) rardrer r rfrrWrs & rrProxyHandler._proxy_post1s99S]^,h& E))*:A>?FZZ__V,D..(($g~?QR)C ''R'IITyy{J   s #   ^-? @ OO      JJ  T " JI||%% E   qvv &   ^-? @ OO      JJ  TZZ#a&(9:AAC D D E   s #   ^-? @ OO      JJ  TZZ#a&(9:AAC D D  EsEBE ?D8A&E 8 E E J)*BH J)J)B J$$J)c VP\R4Rp\V,p\PP VR\ /R7p\PPV^\R7;_uu_4pVP4pRRR4VP^4VPRR4VP4VP4VPPX4R# +'giLp;i \P P"dpTPTP$4TPRR4TP4TPP\&P(!R\+T4/4P-44Rp?R#Rp?i\.dpTPR4TPRR4TP4TPP\&P(!R\+T4/4P-44Rp?R#Rp?ii;i) r NrT)rjrYrrryr\)rrr*rr]r^r_r`rarbrrrlrnrrrryrcrIrrrrr)rardrerfrr rs& rrProxyHandler._proxyQs99S]^,h&nn$$S;2H$I E''R'IITyy{J   s #   ^-? @ OO      JJ  T " JI||%% E   qvv &   ^-? @     JJ  TZZ#a&(9:AAC D D E   s #   ^-? @     JJ  TZZ#a&(9:AAC D D  EsE.D<C5 A&D5 D DI'BF22 I?IA;IIc VPVR.4^,P4P4pV'dGVPR4Uu.uF*q3P4'gKVP4NK, up#.#uupi)uADevuelve lista de valores en mayúsculas; acepta comma-separated.rr&)rkr)rr)qsrrMrs&& r _parse_listProxyHandler._parse_listisbffS2$"((*002CF399S>?>aWWY  >?NBN?s B.Bc \V4^8XdVPV^,4RV R2#RPR.\V4,4pVPV4RV RV R2#)u3Agrega cláusula = o IN según cantidad de valores.zUPPER(z) = %sr&r') IN (r()r*rrextend)r,valsrr/s&&& r _where_inProxyHandler._where_inosg t9> HHT!W C5' 'xxT 23  uF<.22r$c  \V4^8Xd+VPV^,V^,.4RV RV R2#RPR.\V4,4pVPW,4RV RV RV RV R 2 #) uCláusula cargo con lookup en cargo_unificacion; soporta múltiples valores. Usa UPPER() en ambos lados para manejar datos con capitalización mixta.z(UPPER(z) = %s OR UPPER(z) IN ( SELECT UPPER(cargo_original) FROM cargo_unificacion WHERE UPPER(cargo_unificado) = %s))r&r'rz ) OR UPPER(z) IN ( SELECT UPPER(cargo_original) FROM cargo_unificacion WHERE UPPER(cargo_unificado) IN ())))r*rr)r,rrphs&&& r _where_cargoProxyHandler._where_cargoys t9> HHd1gtAw' (se#3C59<? ?XXtfs4y( ) 3%vbTSE:668T@ @r$c! 7aaFaGaHaIaJaK\SP4p\VP4pVPP R4R,p\ P 4pVP\PPR7oH/pVR8XdSHPR4SHP4R,pSHPR4SHP4R,pSHPR4SHP4R,pRVRVR V/pEMVR 8XEd VPR R .4^,p VPR R.4^,oKVPRR.4^,P4oJSPVR4oGSPVR4oFVPRR.4^,P4oI\ P"!V 4p \!V P$^, V P&^4P)4p VFVGVHVIVJVKV3Rlp V !V 4p V !V 4pSHPR4SHP+4Uu.uF qR ,NK ppR T RT RTRV P-4UUu.uFwppRVRVR,RVR,RVR,RVR,RVR,RVPV/4PR^4RVPV/4PR^4RVPV/4PR^4/ NK upp/pEMrVR 8XEd9VPR R .4^,p VPR R.4^,oKVPRR.4^,P4oJSPVR4oGSPVR4oFVPRR.4^,P4oIR!R".V .pp\/SK4wppV'd#VP1V4VP3V4SJ'd#VP1R#4VP1SJ4SG'd#VP1SP5R$SGV44SF'd#VP1SP7RSFV44SI'd'VP1R%4VP1R&SI R&24SHPR'R(P9V4 R)2V4^R*IHp/pSHP+4FpVR,VR,VR+,\?VR,,;'g^43wppppVV9d/VV&VVV,9d .VV,V&VV,V,P1RVR-V/4K .p\AV4Fp.^^ppp\AVV,4Fzp \AVV,V ,R.R/7p!\CR0V!44p"\EV!4p#VV", pVV#, pTP1RT RT"RV#'d V"V#,M^RV#R1V!/4K| TP1RTRTRV'd VV,M^RVR2V/4K R V RV/pEM2VR38XdLSHPR44SHP+4p$R5\EV$4R6V$Uu.uFp\GV4NK up/pEMVR78XdLSHPR84SHP+4p$R5\EV$4R6V$Uu.uFp\GV4NK up/pEMVR98XdISHPR:4SHP+4p$R5\EV$4R;V$Uu.uF qR<,NK up/pEM?VR=8XdLSHPR>4SHP+4p$R5\EV$4R6V$Uu.uFp\GV4NK up/pEMVR?8XdLSHPR@4SHP+4p$R5\EV$4R6V$Uu.uFp\GV4NK up/pEMVR8XEd(VPR R .4^,p VPR R.4^,oKVPRR.4^,P4oJRA.V .pp\/SKRBRC7wppV'd#VP1V4VP3V4SJ'd#VP1RD4VP1SJ4SHPRER(P9V4 RF2V4SHP+4p$R T R5\EV$4RV$Uu.uFp\GV4NK up/pEMlVRG8XdVPRR.4^,PI4oISI'gRH./pEM/\KSI4p%SHPRIV%34SHP+4p$RHV$Uu.uFp\GV4NK up/pEMVRJ8XEdVPRKR.4^,PI4p&V&'gRL./pEMSHPRMV&34SHP+4p$.p'V$EF$pVRN,;'g/p(T'P1ROVRO,RPVRP,RV(PR4R$V(PR$4RQV(PRQ4R,V(PRR4RSV(PRS4RTV(PRT4RUV(PRU4RVV(PRV4RWV(PRW4RXV(PRX4;'g.RYV(PRY4;'g.RZV(PRZ4;'g./4EK' RKV&R5\EV'4RLV'/pEMAVR8XEdNVPR[R\.4^,p)VPR]R^.4^,p*VPR R.4^,oKVPRR.4^,P4oJSPVR4oFVPRR.4^,P4oIVPR_R.4^,P4p+R`p,RaV, 2.p.p\/SKRBRC7wppV'd#VP1V4VP3V4SJ'd#VP1RD4VP1SJ4SF'd#VP1SP7RbSFV44SI'd'VP1Rc4VP1R&SI R&24V+'d#VP1Rd4VP1V+4V'dR(R(P9V4,MRp-SHPReV- RF2V)V*V)V*V)V*V)V*.V,4SHP+4p.R[T)R]T*R5\EV.4RfV.Uu.uFp\GV4NK up/pE MVRg8XEdVPR R\.4^,p VPR R.4^,oKVPRR.4^,P4oJSPVR4oGSPVR4oFVPRR.4^,P4oIVPR_R.4^,P4p+R!.V .pp\/SK4wppSKP Rh4Uu.uF*qPI4'gKVPI4NK, p/pV/U0U1u.uF"p0\LPV0.4Fp1V1NK K$ p2p0p1\LPO4U3U1u.uFp3V3Fp1V1NK K p4p3p1V'dV4'dRiP9Rj.\EV44,4p5RkV RlV5 Rm2p6\QV4V4U1u.uF p1R&V1 R&2NK up1,p7V2'dIRiP9Rj.\EV24,4p8RnV6 RoV8 Rm2p6T7V2U1u.uF p1R&V1 R&2NK up1, p7VP1V64VP3V74M*V'd#VP1V4VP3V4SJ'd#VP1R#4VP1SJ4SG'd#VP1SP5R$SGV44SF'd#VP1SP7RSFV44SI'd'VP1R%4VP1R&SI R&24V+'d#VP1Rp4VP1V+4SHPRqR(P9V4 Rr2V4SHP4p9RsV9'd V9Rs,M^/pEM=VRt8XEdVPR R .4^,p VPR R.4^,oKVPRR.4^,P4oJSPVR4oGSPVR4oFVPRR.4^,P4oIR!.V .pp\/SK4wppV'd#VP1V4VP3V4SJ'd#VP1R#4VP1SJ4SG'd#VP1SP5R$SGV44SF'd#VP1SP7RSFV44SI'd'VP1R%4VP1R&SI R&24SHPRuR(P9V4 Rv2VW.,4.ROp:SHP+4p;/pRaV, 2RR..pAp@\/SKRBRC7wppV'dEV>P1V4V?P3V4X@P1V4XAP3V4SJ'dEV>P1RD4V?P1SJ4X@P1RD4XAP1SJ4SF'dEV>P1SP7RbSFV?44X@P1SP7RbSFXA44SHPRR(P9V>4 RR(P9X@4 R2V?XA,4RfSHP+4Uu.uFp\GV4NK up/pEMVR8XEdVPR R.4^,oKVPRR.4^,P4oJR`p,RV, 2R..pp\/SK4wppV'd#VP1V4VP3V4SJ'd#VP1R#4VP1SJ4R(P9V4pBSHPRVB RV, RVB R2VV,4RfSHP+4Uu.uFp\GV4NK up/pEMVR8XdVPR R.4^,oKR`pCRVC 2R..pp\/SK4wppV'd#VP1V4VP3V4SHPRR(P9V4 R2V4RfSHP+4Uu.uFp\GV4NK up/pEMVR8XEdVPR R\.4^,p VPR R.4^,oKVPRR.4^,P4oJSPVR4oGSPVR4oFVPRR.4^,P4oIR`pCR!RVC 2.V .pp\/SK4wppV'd#VP1V4VP3V4SJ'd#VP1R#4VP1SJ4SG'd#VP1SP5R$SGV44SF'd#VP1SP7RSFV44SI'd'VP1R%4VP1R&SI R&24SHPRR(P9V4 R2V4RfSHP+4Uu.uFp\GV4NK up/pSHPS4\TPV!V\XRR7P[R4pDSP]^4SP_RR4SPa4SPc4SPdPgVD4\ PmV4R#uupiuuppiuupiuupiuupiuupiuupiuupiuupiuupiuupiuup1p0iuup1p3iuup1iuup1iuupiuupiuupiuupiuupiuupiuupi \hdpESP]R4SP_RR4SPa4SPc4SPdPg\TPV!SPkTE44P[44RpE?EEL(RpE?Eii;i \ PmT4i;i)rrkz max-periodoz5SELECT MAX(fecha)::text AS m FROM historico_empleadosmz*SELECT MAX(periodo) AS m FROM historico_irzHSELECT MAX(periodo) AS m FROM historico_nomina_pyg WHERE fuente='nomina' empleadosir nomina_pygsalariosfechaz 2026-03-01rrrcentrorrc<R.V.r!\S 4wr4V'd#VPV4VPV4S 'd#VPR4VPS 4S'd#VPS PRSV44S'd#VPS P RSV44S 'd'VPR4VPRS R24RRP V4 R2pS P WR4S P4Uu/uFqfR ,\V4bK up#uupi) fecha = %sUPPER(operacion) = %s centro_costorUPPER(nombre_completo) LIKE %s%aN SELECT TRIM(centro_costo) AS ceco, SUM(sueldo_base)::bigint AS salario_base, ROUND(AVG(sueldo_base))::int AS salario_promedio, COUNT(*)::int AS empleados, COUNT(*) FILTER (WHERE INITCAP(sexo) = 'Masculino')::int AS masculino, COUNT(*) FILTER (WHERE INITCAP(sexo) = 'Femenino')::int AS femenino FROM historico_empleados WHERE  AND z AND centro_costo IS NOT NULL GROUP BY TRIM(centro_costo) ORDER BY salario_base DESC LIMIT 20 ceco) r0rrrrrrOrwrx)r(wrrwrasqlr-cargoscentrosrTroperacr+ras& rq_cecos(ProxyHandler._historico..q_cecoss(>A3q(/FB188B<"*A!BAHHVDT$..RS*T!U$*;*;GVQ*O!P*J!KQXXXYZ`YaabVcMd  '||A/0CKK'8; G1fItAw.GGGs"EzSELECT DISTINCT razon_social FROM historico_empleados WHERE razon_social IS NOT NULL ORDER BY 1fecha_lyr.rr/ salario_basesalario_promedio masculinofemeninosalario_base_lysalario_promedio_ly empleados_lymatrizr)zcentro_costo IS NOT NULLr*r+r,r-z SELECT TRIM(centro_costo) AS ceco, COALESCE(cargo, 'Sin Cargo') AS cargo, nombre_completo, sueldo_base FROM historico_empleados WHERE r.zY ORDER BY TRIM(centro_costo), cargo, nombre_completo ) defaultdictrrsueldocVR,#)r)xs&r)ProxyHandler._historico.. s1X;r$)rc32"TF qR,xK R#5i)rCNrErEs& rr*ProxyHandler._historico.. s ?h8hpersonasr4z cargos-mapz SELECT cargo_original, cargo_unificado FROM cargo_unificacion ORDER BY cargo_original r5mapz cecos-mapz SELECT ceco_original, ceco_unificado, fuente, empleados_api, registros_pg, notas FROM ceco_unificacion ORDER BY ceco_original sociosz\ SELECT codigo_empleado FROM socios WHERE activo = true codigoscodigo_empleadoz hoteles-mapz SELECT razon_social, hotel_name_api, bu_codigo, bu_nombre, nombre_personalizado, activos_api FROM hotel_unificacion ORDER BY razon_social zingreso-real-mapus WITH base AS ( SELECT codigo_empleado, fecha, razon_social, fecha_ingreso, centro_costo, LAG(razon_social) OVER ( PARTITION BY codigo_empleado ORDER BY fecha ) AS prev_razon, LAG(fecha) OVER ( PARTITION BY codigo_empleado ORDER BY fecha ) AS prev_fecha FROM historico_empleados ), grp AS ( SELECT *, SUM(CASE WHEN razon_social IS DISTINCT FROM prev_razon -- Hueco real de empleo (salió y fue recontratado -- después) — no es un simple cierre mensual con -- 1 mes de retraso, así que no debe sumarse como -- antigüedad continua aunque sea la misma empresa. OR (prev_fecha IS NOT NULL AND fecha - prev_fecha > 62) THEN 1 ELSE 0 END) OVER (PARTITION BY codigo_empleado ORDER BY fecha) AS grupo FROM base ), block_start AS ( SELECT codigo_empleado, grupo, (array_agg(fecha_ingreso ORDER BY fecha ASC))[1] AS ingreso_real FROM grp GROUP BY codigo_empleado, grupo ), latest AS ( SELECT DISTINCT ON (codigo_empleado) codigo_empleado, fecha AS ultima_fecha, razon_social, grupo, TRIM(centro_costo) AS centro_costo FROM grp ORDER BY codigo_empleado, fecha DESC ) SELECT l.codigo_empleado, l.razon_social, l.ultima_fecha, l.centro_costo, bs.ingreso_real AS fecha_ingreso_real FROM latest l JOIN block_start bs ON bs.codigo_empleado = l.codigo_empleado AND bs.grupo = l.grupo z h.fecha = %szh.razon_social)r,zUPPER(h.operacion) = %sa SELECT h.codigo_empleado, h.nombre_completo, COALESCE(h.fecha_nacimiento, fn.fecha_nacimiento) AS fecha_nacimiento, INITCAP(h.sexo) AS sexo, h.fecha_ingreso, h.fecha_vencimiento_contrato, TRIM(h.centro_costo) AS centro_costo, h.cargo, h.sueldo_base::float AS sueldo_base, h.operacion, h.tipo_contrato, h.razon_social FROM historico_empleados h LEFT JOIN ( SELECT codigo_empleado, MAX(fecha_nacimiento) AS fecha_nacimiento FROM historico_empleados WHERE fecha_nacimiento IS NOT NULL GROUP BY codigo_empleado ) fn ON h.codigo_empleado = fn.codigo_empleado WHERE z@ ORDER BY h.nombre_completo trayectoria snapshotsu SELECT DISTINCT ON (fecha) fecha, cargo, sueldo_base::float AS sueldo_base, TRIM(centro_costo) AS centro_costo, tipo_contrato, fecha_ingreso, razon_social FROM historico_empleados WHERE ( SELECT string_agg(w, ' ' ORDER BY w) FROM unnest(string_to_array( upper(translate(nombre_completo, 'ÁÉÍÓÚÜÑáéíóúüñÀÈÌÒÙàèìòùÂÊÎÔÛâêîôûÃÕãõÄÖäö', 'AEIOUUNaeiouunAEIOUaeiouAEIOUaeiouAOaoAOao')), ' ')) AS w ) = %s ORDER BY fecha, id znomina-empleadoidentificacionperiodosa- SELECT ano, mes, raw_data FROM historico_nomina_pyg WHERE fuente='nomina' AND registro_tipo='empleado' AND raw_data->>'identificacion' = %s ORDER BY ano, mes rmrWrXrs_basicodiastotal_devengostotal_deduccionesaportes_patronalesnetor} provisionesseguridad_social fecha_iniz 2026-01-01 fecha_finz 2026-01-31sexoz('ELMA','FNS','FCZN')zh.razon_social NOT IN zh.cargoz UPPER(h.nombre_completo) LIKE %szUPPER(emp_sexo.sexo) = %sa SELECT h.nombre_completo AS nombres, COALESCE(u.hotel_name_api, h.razon_social) AS hotel_name, h.razon_social, h.cargo, h.tipo_contrato, h.sueldo_base::float AS sueldo, h.ingreso::text, h.termino::text AS vencimiento, h.causa_retiro, h.operacion, h.tipo_movimiento AS tipo FROM historico_ir h LEFT JOIN hotel_unificacion u ON u.razon_social = h.razon_social LEFT JOIN ( SELECT DISTINCT ON (codigo_empleado) codigo_empleado, sexo FROM historico_empleados WHERE sexo IS NOT NULL ORDER BY codigo_empleado, fecha DESC ) emp_sexo ON emp_sexo.codigo_empleado = h.codigo_empleado WHERE ( (h.tipo_movimiento = 'I' AND h.ingreso BETWEEN %s AND %s) OR (h.tipo_movimiento = 'R' AND h.termino BETWEEN %s AND %s) OR (h.tipo_movimiento = 'IR' AND (h.ingreso BETWEEN %s AND %s OR h.termino BETWEEN %s AND %s)) ) r;z activos-countr&z OR zUPPER(centro_costo) LIKE %sz((z&) AND NOT (razon_social = 'SERV' AND (r(z OR (razon_social = 'SERV' AND (zUPPER(sexo) = %sz| SELECT COUNT(*)::int AS activos FROM historico_empleados WHERE z activos antiguedadz WITH activos AS ( SELECT DISTINCT codigo_empleado, INITCAP(sexo) AS sexo FROM historico_empleados WHERE u ), primera AS ( SELECT h.codigo_empleado, MIN(h.fecha) AS primera_fecha FROM historico_empleados h INNER JOIN activos a ON h.codigo_empleado = a.codigo_empleado GROUP BY h.codigo_empleado ), bins AS ( SELECT p.codigo_empleado, act.sexo, EXTRACT(YEAR FROM AGE(%s::date, p.primera_fecha)) * 12 + EXTRACT(MONTH FROM AGE(%s::date, p.primera_fecha)) AS meses FROM primera p JOIN activos act ON act.codigo_empleado = p.codigo_empleado ) SELECT CASE WHEN meses < 6 THEN '0–6 meses' WHEN meses < 12 THEN '6–12 meses' WHEN meses < 24 THEN '1–2 años' WHEN meses < 36 THEN '2–3 años' WHEN meses < 48 THEN '3–4 años' ELSE '4+ años' END AS rango, CASE WHEN meses < 6 THEN 0 WHEN meses < 12 THEN 1 WHEN meses < 24 THEN 2 WHEN meses < 36 THEN 3 WHEN meses < 48 THEN 4 ELSE 5 END AS orden, sexo, COUNT(*)::int AS total FROM bins GROUP BY rango, orden, sexo ORDER BY orden MasculinoFemeninorangorangoscountsgeneroz ir-mensualzh.tipo_movimiento IN ('I','IR')zh.ingreso IS NOT NULLzh.tipo_movimiento IN ('R','IR')zh.termino IS NOT NULLz WITH ing AS ( SELECT DATE_TRUNC('month', h.ingreso)::date AS mes, COUNT(*)::int AS n FROM historico_ir h WHERE a  GROUP BY 1 ), ret AS ( SELECT DATE_TRUNC('month', h.termino)::date AS mes, COUNT(*)::int AS n FROM historico_ir h WHERE au GROUP BY 1 ), meses AS ( SELECT mes FROM ing UNION SELECT mes FROM ret ) SELECT TO_CHAR(m.mes, 'YYYY-MM') AS mes, COALESCE(i.n, 0) AS ingresos, COALESCE(r.n, 0) AS retiros FROM meses m LEFT JOIN ing i ON i.mes = m.mes LEFT JOIN ret r ON r.mes = m.mes ORDER BY m.mes zcohorte-retencionzrazon_social NOT IN zfecha >= '2024-01-01'z WITH nuevos AS ( SELECT e.codigo_empleado, e.fecha AS mes_cohort FROM historico_empleados e WHERE aE AND NOT EXISTS ( SELECT 1 FROM historico_empleados p WHERE p.codigo_empleado = e.codigo_empleado AND p.fecha = (e.fecha - INTERVAL '1 month')::date AND p.razon_social NOT IN z ) ), snaps AS ( SELECT DISTINCT codigo_empleado, fecha FROM historico_empleados WHERE a ), cohortes AS ( SELECT n.mes_cohort, COUNT(DISTINCT n.codigo_empleado) AS total, COUNT(DISTINCT n.codigo_empleado) FILTER (WHERE s1.codigo_empleado IS NOT NULL) AS m1, COUNT(DISTINCT n.codigo_empleado) FILTER (WHERE s2.codigo_empleado IS NOT NULL) AS m2, COUNT(DISTINCT n.codigo_empleado) FILTER (WHERE s3.codigo_empleado IS NOT NULL) AS m3, COUNT(DISTINCT n.codigo_empleado) FILTER (WHERE s6.codigo_empleado IS NOT NULL) AS m6, COUNT(DISTINCT n.codigo_empleado) FILTER (WHERE s9.codigo_empleado IS NOT NULL) AS m9, COUNT(DISTINCT n.codigo_empleado) FILTER (WHERE s12.codigo_empleado IS NOT NULL) AS m12 FROM nuevos n LEFT JOIN snaps s1 ON s1.codigo_empleado = n.codigo_empleado AND s1.fecha = (n.mes_cohort + INTERVAL '1 month')::date LEFT JOIN snaps s2 ON s2.codigo_empleado = n.codigo_empleado AND s2.fecha = (n.mes_cohort + INTERVAL '2 months')::date LEFT JOIN snaps s3 ON s3.codigo_empleado = n.codigo_empleado AND s3.fecha = (n.mes_cohort + INTERVAL '3 months')::date LEFT JOIN snaps s6 ON s6.codigo_empleado = n.codigo_empleado AND s6.fecha = (n.mes_cohort + INTERVAL '6 months')::date LEFT JOIN snaps s9 ON s9.codigo_empleado = n.codigo_empleado AND s9.fecha = (n.mes_cohort + INTERVAL '9 months')::date LEFT JOIN snaps s12 ON s12.codigo_empleado = n.codigo_empleado AND s12.fecha = (n.mes_cohort + INTERVAL '12 months')::date GROUP BY n.mes_cohort ) SELECT TO_CHAR(mes_cohort, 'YYYY-MM') AS cohorte, total, ROUND(m1 * 100.0 / NULLIF(total,0), 1)::float AS pct_1, ROUND(m2 * 100.0 / NULLIF(total,0), 1)::float AS pct_2, ROUND(m3 * 100.0 / NULLIF(total,0), 1)::float AS pct_3, ROUND(m6 * 100.0 / NULLIF(total,0), 1)::float AS pct_6, ROUND(m9 * 100.0 / NULLIF(total,0), 1)::float AS pct_9, ROUND(m12 * 100.0 / NULLIF(total,0), 1)::float AS pct_12 FROM cohortes WHERE total >= 8 ORDER BY mes_cohort zrotacion-heatmapa WITH base AS ( SELECT razon_social, fecha, COUNT(DISTINCT codigo_empleado) FILTER (WHERE operacion ILIKE '%%retiro%%') AS retiros, COUNT(DISTINCT codigo_empleado) FILTER (WHERE operacion ILIKE '%%operacion%%') AS activos FROM historico_empleados WHERE a GROUP BY razon_social, fecha ) SELECT razon_social, TO_CHAR(fecha, 'YYYY-MM') AS mes, ROUND(retiros * 100.0 / NULLIF(activos, 0), 1)::float AS pct FROM base ORDER BY razon_social, fecha z activos-hotelz SELECT razon_social, COUNT(DISTINCT codigo_empleado)::int AS activos FROM historico_empleados WHERE ze GROUP BY razon_social ORDER BY activos DESC FrFrrrrrNr)u 0–6 mesesu 6–12 mesesu 1–2 añosu 2–3 añosu 3–4 añosu4+ años)rcrd)7rrrrqueryrrLrMrNr7r8rorOrPrkrr date_type fromisoformatr.r/ isoformatrwrr0rrrrr collectionsrBrDrsumr*rxr)r#SERV_HOTEL_PATTERNSvaluesrrrrrrrrlrnrrrrrrQ)LraparsedrendpointrSrW max_empleadosmax_ir max_nominar&dr9r7currrr-r.r/r0rr1r2rBrrgrr result cargos_listctcerrLstemr; nombre_normrSrTrdfiffr_EXCL where_extrarows_ir razones_listrIrFserv_patterns_herepatsall_serv_patternsexcl_orsclauseparamscc_orsrURANGOSrows_antlookup gender_lookupwiaiwrar where_baseEXCL_Hr rr4r5rTrr6r+sLf @@@@@@rrProxyHandler._historicosDII&FLL);;$$%89"= J ";;hoo.L.L;MCD =( ST # s 3  HI, fg \\^C0 -& *Z'?B"6q9 "6q9??A**2x8**2w7"6q9??A#11%8$QVVaZ!<FFHHH4u~x( -.7:llnEn^,,nE(,zz| (4GD!#*>1B.3E1F';';&:-b1A1E1EnZ[1\1266$3C3G3GHZ\]3^*b1A1E1Ek[\1] (4  *X%?B"6q9 "6q9??A**2x8**2w7"6q9??A$&@AE71$U+B188B<"188$;NAHHT^^NGQ%OPAHHT%6%6w%JK188$DEqxxRSTZS[[\P]G^ ! #<<?+, 4A!"6AgJ:K8LcRSTaRbRgRgfgNh!hJAq!Q}d1gQ'baGAJ%%xHa&@A ( "4LD*,aRK!'T !3#)$t*U*;AV#W ?h ?? ]b"("#**#U*B.BbA'& , "4MM&*B"H#R + #), 8\)  ||~SYT2TDGT2 [(  ||~SYT2TDGT2X% ||~SYdCd"3 4 4dC ]*  ||~SYT2TDGT2// **V||~SYT2TDGT2 [(?B"6q9 "6q9??A&'%1$U0@ABqxx|QXXb\188$=>@P !&#<<?+,'*+,||~D 4!84a$q'4!8]*2$/288:',D"+F"3K KK!&&')(<<>D'4)@4a$q'4)@AD..!#(82$!?!B!H!H!J%&+DKK! )* ,<<>D!H!z]00b !1U8UAeH#RVVG_*BFF>,B' )<)266*+="BFF6N,bff5E.F/8K1L0"&&9M2N"BFF6N' )<)B)B)266-+@+F+FB.7I0J0P0Pb)"$).X"HDT! ?B ?B5a8 5a8>>@**2w75a8>>@5a8>>@.-dV45$U0@ABqxx|QXXb\188$=>@P188D$5$5i$KLHH?@HHq]+"=>=>wa8B  !6!M"7:"b"b"b"59;;>,,.["S\g6gT!Wg6_,,@C"6q9 "6q9??A**2x8**2w7"6q9??A"6q9??A$~w1$U+B9>S9I%W9IAWWYiaggi9I %W4@%lLDJ]JaJabfhjJkQaJkaL"%l4G4N4N4P%_4PDZ^UVaZ^a4P!%_+ &{{,I+JSQbMc+cdH!"%KH:UXYF!"X;L(M;La1QCq;L(MMF)!'.K-LsSeOf-f!g#$VH,LVHTW!X5G"H5GQqc85G"HHHHV$HHV$HHRL!((2,188$;NAHHT^^NGQ%OPAHHT%6%6w%JKAHH%EFSTU[T\\]Q^H_AHH%78!((4. !#<<?+,  lln!S3y>a@\)&&,@C&&"6q9&&"6q9??A**2x8**2w7&&"6q9??A$~w1$U+B188B<"188$;NAHHT^^NGQ%OPAHHT%6%6w%JKAHH%EFSTU[T\\]Q^H_ ! '||A/&0 *T%'U*)Xr<<>MS TV[!Z$C!CV T!A)/AgJ)BQwZ)OF1W:&y$==%aj1!F)<' J<" f@Avzz!Q/@@A}Q//@\)5a8 5a8>>@))"g6.24&9;134634&9;1346%U0@ABIIbM299R=IIbM299R=II78"))F:KII78"))F:KIId// 62FGIId// 62FG ! '||B/01 '||B/018"W9<#,,. A.Qa. AB005a8 5a8>>@..tf5/124$U+Bqxx|QXXb\188$;N$\\!_  ! *l+; <@&A *l!+!1bUc1f#,,. A.Qa. AB//5a80.vh7/124$U+Bqxx|QXXb\ ! '||A/ 0$%(#,,. A.Qa. AB_,?B5a8 5a8>>@**2x8**2w7&&"6q9??A0$(NAHHT^^NGQ%OPAHHT%6%6w%JKAHH%EFSTU[T\\]Q^H_ !#<<?+, #,,. A.Qa. AB IIK::dCeDKKGTD   s #   ^-N O OO      JJ  T " OOD !QF j33 D3t3P"9H*AX7&X%l%_)N#I|!UA@v!BF!B@!B:!B J   s #   ^-? @ OO      JJ  TZZ(;(;A(>?FFH I I  J OOD !s)G0AkAi*AkB#Ai)C=Ak')Ak)Ak;)Ak%BAk8DAkAAk(Ai <>Ak:Ai# >Ak Ai( >AkAi- />Ak-Ai2 B1Ak3A)AkAi704R,p.V.V,9gK'V-V,V.&K. \C4.p0p/V'Fwp1p2p3p4p5V1V/9dKV+PV14;'gV,PV14p6V6fKBV/PEV14V/PEV1PGR?R@4PGRARB4PGRCRD4PGRERF44T0P7R,T1RT2R-T3R.T4R/\IV64;'g^R0V5/4K V0'gEKV0VVV3&EK RGotRH.RORIRJ.RKRL.RMRN.RORP./p7VP#RQStS|S34/p8VP%4FpVRR,;'gR P-4o}V7PA4Fwp9p:\J;QJdV}3RSlV:4F 'gK R;M RM!V}3RSlV:44'gKHV9V89d RT^RURV/V8V9&V8V9,RT;;,^, uu&V8V9,RU;;,\IVPRU4;'g^4, uu&K K \MVt3RWlSPA444p;\O^V;\MRXV8P)444, 4pVPA4EFwp9pVR,oVPR24pVPR34;'gR+pSPSV3SPSR+3/44p?VPRY4;'gV.p@\9\&PWRZV@444pASSt8Xd TP7R T9RSR2TR8VR8,RbXGRcXBRdXCReXHRfXJRgXMRaXNRhTRiV^8d\[XMV, ^d,^4MR$/ 4EK V>P]RjR;Rk7\MRlV>44pO\MRmV>44pP\MRnV>44pQ\MRoV>44pR\MRpV>44pS\MRqV>44pTVR^8d\[XTXR, 4MR$pURS|RSRrT>RsRbXRReXSRfTURgXORaXPRhXQRiVQ^8d\[XOXQ, ^d,^4MR$//p EMVRt8XEd^R$I/pV^R$I0pW\VPRR.4^,4pX\VPRR .4^,4pYVP#Ru4VP%4pZVPQ4\ PSV4R;pVX VYR" 2p[Rv^Rw^Rx^Ry^RzVWPcVXVY4^,/p\^p]VZEFpVR2,pVR8,;'gR+P;4p^\dPf!R2\V4R{X[R|R$R}V^.R~R;/4Pi4p_\jPlPo\pV_R\rRR/RR7p`\jPlPuV`^\vR7;_uu_4pa\dPx!VaP{44pbR$R$R$4XbPR/4pcVcPX^VcPR+/44pdVdPR/4PX[/4oV3RlpeX\Rv;;,Ve!Rv4, uu&V\Rw;;,Ve!Rw4, uu&V\Ry;;,Ve!R4, uu&T\Rx;;,VbPR^4;'g^, uu&X]^, p]XVP}R4EK X\Rv,^8d)\[X\Rw,V\Rv,, ^d,^4MR$pfRX]RzX\Rz,RV\Rx,RvV\Rv,RwV\Rw,RVfRV\Ry,/p EMvVR8XEdoVPR2R .4^,pg\VPRR.4^,4pX\VPRR .4^,4pYVPR8R+.4^,P;4;'gR+phXg'gRR/p EMXX XYR" 2p[\dPf!R2\Xg4R{V[R|R$R}Xh.R~R;/4Pi4piVPQ4\ PSV4R;p\jPlPo\pViR\rRR/RR7pj\jPlPuVj^\vR7;_uu_4pk\dPx!VkP{44plR$R$R$4XlPR/4pmVmPXhVmPR+/44pnVnPR/4PX[/4oVlPR^4poV3Rlpp^R$I0pqVqPcXXXY4^,prR2\Xg4R{V[RVoRzVrRvVp!Rv4RwVp!Rw4RVp!R4RVp!R4RVp!R4RVp!R4RVp!R4RVp!R4/ p \dPf!V \*RR7PiR4psVP^4VPRR4VP4VP4VPPVs4V'g\ PSV4R$#R$#uupiuupiuupiuupiuupi \0d%p\3RS R S| R!SR" R#T 24R$p?EK7R$p?ii;iuupiuupi \0d(p\3R4T R5T R S| R!SR" R#T 2 4R$p?EKR$p?ii;i \0d(p\3R6T R5T R S| R!SR" R#T 2 4R$p?EKR$p?ii;iuupiuup"pi +'giELd;i \0dEp\3RTPR 4 R XX R!XYR" R#T 24XVP}R4R$p?EKR$p?ii;i +'giEL;i \0dpTPR4TPRR4TP4TP4TPP\dPf!TPT44Pi44R$p?ELR$p?ii;i T'g\ PST4ii;i)uGET /proxy/stats/resumen-hoteles?ano=2025&mes=1 Devuelve un resumen por hotel: empleados, costo nómina, ingresos P&G. Usa nómina viva cuando está disponible y cae a la caché local como respaldo. rrFrkzresumen-hotelesrW2025rX1rrz-AND LOWER(h.nombre_personalizado) = LOWER(%s)a  WITH hotel_bus AS ( SELECT h2.nombre_personalizado, ARRAY_AGG(LOWER(COALESCE(h2.bu_codigo, 'local')) ORDER BY h2.bu_codigo ASC NULLS LAST) AS all_bus FROM hotel_unificacion h2 JOIN empresas e2 ON h2.razon_social = e2.codigo WHERE e2.nit IS NOT NULL AND e2.nit <> '' AND h2.hotel_name_api IS NOT NULL AND h2.nombre_personalizado NOT IN ('No mostrar') GROUP BY h2.nombre_personalizado ) SELECT DISTINCT ON (h.nombre_personalizado) h.nombre_personalizado AS label, e.nit, e.codigo AS razon_social, h.bu_codigo, LOWER(h.bu_codigo) AS bu_lower, h.bu_nombre, e.pyg_company_id AS company_id, hb.all_bus FROM hotel_unificacion h JOIN empresas e ON h.razon_social = e.codigo JOIN hotel_bus hb ON h.nombre_personalizado = hb.nombre_personalizado WHERE e.nit IS NOT NULL AND e.nit <> '' AND h.hotel_name_api IS NOT NULL AND h.nombre_personalizado NOT IN ('No mostrar') za ORDER BY h.nombre_personalizado, h.bu_codigo ASC NULLS LAST rqz SELECT codigo, regexp_replace(codigo, '_v[0-9]+$', '') AS codigo_api, nombre, grupo, subgrupo, incluir FROM nomina_conceptos r codigo_apir|c<\T;'gR4pVP4p\T;'gR4P4P4pSPV RV 24;'gSPV4#)rr)rrr)rk)rrrIapi_keynom_keyconceptos_by_api_nameconceptos_by_codes&& r _nom_lookup(ProxyHandler._stats.._nom_lookupsqv||,D"jjlG!&,,B/557==?G044y'5KLkkPaPePefjPkkr$c`<S!W4p\T;'dVPR4RJ4#)rF)boolrkrrr!rs&& r _nom_incluir)ProxyHandler._stats.._nom_incluirs.#F3A C CaeeI&6e&CDDr$c^<S!W4pT;'g/PR4;'gR#)rrrkrs&& r _nom_grupo'ProxyHandler._stats.._nom_grupos*#F3AGG==177R7r$c^<S!W4pT;'g/PR4;'gR#)rrrrs&& r _nom_subgrupo*ProxyHandler._stats.._nom_subgrupos*#F3AGG==4:::r$c/pVFpVPR4;'g.Fp\VPR4;'g^4pV^8:dK0R\VPR4;'gR4,pWQ9d$RTRVPR4;'gRRR/W&W,R;;,V, uu&K K \VP 44#)r\aporte_empleadorSS_rrrvalorrA)rkrrrrp)empsss_mapempssaprIs& r_build_ss_patronal/ProxyHandler._stats.._build_ss_patronalsF#"%''*<"="C"C"CB!&rvv.@'A'F'FQ!GB!Qw (#(3rvvh/?/E/E2+F#FD#108$"&&QYJZJ`J`^`bikn/o "L1R71#D $  00r$c <T;'g/p\T;'gR4P4pVPR4;'g.Uu.uF>p\VPR4;'gR4P4V8XgK<VNK@ ppV'gkVR8XddVPR4;'g.Uu.uF>p\VPR4;'gR4P4R9gK<VNK@ pp\RV44p\ VPR4;'g/PR4;'g^4pV^8d Wg, M^p/p /p V'dVPR4;'g.Fp \V PR4;'gR4p V PR 4;'gRp V R ,V P 4,pRT R T R \ V PR 4;'g^4R \ V PR 4;'g^4/W&K EM1VEF*pVPR4;'g.EFp \V PR4;'gR4p V PR 4;'gRp V R ,V P 4,pW9d RV R V R R R R /W&V P R4'd@W,R ;;,\ V PR4;'g^4, uu&KW,R ;;,\ V PR4;'g^4, uu&EK EK- V P4FpS!VR,VR ,4'gK"VR ,^8d VR ,MVR ,pV^8:dKKVR,R ,VR ,P 4,pRVR,R VR ,RVRS!VR,VR ,4RS!VR,VR ,4/W&K V'd^MTpVPR4;'g.Fp\VPR4;'gR4p VPR 4;'gRp S!W4'gKR\\ VPR4;'g^4V,4pV^8:dKV R ,V P 4,pRV R V RVRS!W4RS!W4/W&K S!V4pVFpVR,p VR ,p S!W4'gK%\ VPR4;'g^4pV^8:dKRV R ,V P 4,pRV R V RVRS!W4RS!W4/W&K RV R\V4R\RV44R VR\RV44/#uupiuupi)rr"rrc3j"TF)p\VPR4;'g^4xK+ R#5i)rWNrrkrrs& rrEProxyHandler._stats.._nomina_pool_from_raw..s-([VZQRquu5E/F/K/K!)L)LVZ!33resumenrWr}rrrdevengos deduccionesrADXrrrrr[pool num_empleados dias_nominac3j"TF)p\VPR4;'g^4xK+ R#5i)rVNrrs& rrrfs(*Sd5v1C1C!+D+Ddr ss_patronalc3j"TF)p\VPR4;'g^4xK+ R#5i)rNrrrFs& rrrhs(*[{!5w1D1D1+E+E{r)rr) rrrkrnrrrsrproundr*)rMbuuse_raw_aggregatesbu_lowerrrrWraw_devratiorc_maprrIrrrr rprovision_ratiorFrrrrrrs&&& r_nomina_pool_from_raw2ProxyHandler._stats.._nomina_pool_from_raw sT))C"2==1779H$'GGK$8$>$>B$>$>aquu[177R8>>@HL$> H$7(+ (<(B(B(B (B!"155#5#@#@AGGI]ZA(B  &)([VZ([%[N#SWWY%7%=%=2$B$BCS$T$Y$YXYZG8?! N4EDE)!$!5!;!;!;A#&quuX'<'<"#=D#$55?#8#8bD"&*tzz|";C ($ ($ *E!%% 2C2H2Hq,I -uQUU=5I5N5NQ/O *EJ "<$(C%(WW[%9%?%?R%?'*155?+@+@b'A'(uuX'<'<"&*Sj4::<&?# :D(DR\^acpru1vEJ#'??4#8#8$)J}$=quuW~GZGZYZA[$[$=$)Jz$:eAEE'NDWDWVW>X$X$:&@$(!& +DNDNKK$26z2BQ2Fd:.DQ^L_!8$"8ns2T(^5I5I5KK$d8nhXPUWZ#ZXX%O& d8nd8n(U% !/,>a5O WW]399r9"155?#8#8b9 uuX44"+D77$#E!%%.*=*=A$>$PQ!8$"Sj4::<7$dHdE3#Z%;& d(A% :#5T":K)!(|!(|+D77$#BFF7O$8$8q9!8$"Sj4::<7$dHdE3#Z%;& d(A% * 'T%s*Sd*S'S"N%s*[{*['[ k  s$!X0X X!X "X >X c T;'g/P4UUu/uFwr#V\V4bK pppT;'g.FpVPR4'dK\VPR4;'g^4pV^8:dKIRR\ VPR44,RVPR4;'gRRTRVPR4;'gRRVPR4;'gR/VR\ VPR44,&K \ R VP 444#uuppi) rrrPYG_rrrrrc3j"TF)p\VPR4;'g^4xK+ R#5i)rNrrs& rr>ProxyHandler._stats.._payroll_total..{s(OAuQUU5\%6%6Q77r)rrxrkrrrnrp)r pyg_itemsrrrFrs&& r_payroll_total+ProxyHandler._stats.._payroll_totalks48JJB3E3E3GH3G41AtAwJ3GDH&__"_5511$#AEE%L$5$5A6!8$$fs155;/?&?$aeeHo&;&;!3#QUU7^%9%9r&j(9(?(?R ;Vc!%%+&667 -OOOOIsE a  SELECT DISTINCT ON (nit) nit, raw_data FROM historico_nomina_pyg WHERE fuente='nomina' AND registro_tipo='respuesta' AND ano=%s AND mes=%s ORDER BY nit, cargado_en DESC rmc <\P!RVRSRSRRRR/4P4p\PP \ R,VR\R R /R R 7p\PPV^\R 7;_uu_4p\P!VP44uuRRR4# +'giR#;i)rjrWrXincluir_empleadosTss_vistaambosrnrTrrrUrVrYN) rrrr]r^r_rr`rarbrr)rqr rfrrWrXs& r_fetch_nomina_live/ProxyHandler._stats.._fetch_nomina_lives::#Sss+T"G ' vx !..00 #444!,g~GY Z%1C  //R/QQUY#zz$))+6RQQQs $C C u* ⚠️ nómina en vivo falló para NIT z (rHr-z): Na WITH latest_nomina AS ( SELECT DISTINCT ON (nit) nit, raw_data FROM historico_nomina_pyg WHERE fuente='nomina' AND registro_tipo='respuesta' AND ano=%s AND mes=%s ORDER BY nit, cargado_en DESC ) SELECT nit, LOWER(COALESCE(emp->>'bu_codigo', 'local')) AS bu, COUNT(*)::int AS num_empleados, COALESCE(SUM((emp->>'dias')::float), 0) AS dias_nomina, COALESCE(SUM((emp->>'total_devengos')::float), 0) AS devengos, COALESCE(SUM( (SELECT COALESCE(SUM((ss->>'aporte_empleador')::float), 0) FROM jsonb_array_elements(emp->'seguridad_social') AS ss) ), 0) AS ss_patronal FROM latest_nomina, jsonb_array_elements(raw_data->'empleados') AS emp GROUP BY nit, bu raj SELECT company_id::int AS cid, LOWER(bu_kv.key) AS bu, MAX(CASE WHEN t->>'id' = '1-ingresos' THEN (t->'monthly'->'real'->>'value')::float END) AS ingresos_mes FROM historico_nomina_pyg, jsonb_each(raw_data->'pnl') AS bu_kv, jsonb_array_elements(bu_kv.value->'tree') AS t WHERE fuente='pyg' AND registro_tipo='respuesta' AND ano=%s AND mes=%s GROUP BY company_id, bu_kv.key cid ingresos_mesa  SELECT company_id::int AS cid, LOWER(COALESCE(bu_codigo,'')) AS bu, concepto_codigo AS id, concepto_nombre AS nombre, grupo, subgrupo, SUM(valor)::float AS val, BOOL_OR(COALESCE((raw_data->>'nomina_backed')::boolean, false)) AS nomina_backed FROM historico_nomina_pyg WHERE fuente='pyg' AND registro_tipo='concepto' AND ano=%s AND mes=%s GROUP BY company_id, LOWER(COALESCE(bu_codigo,'')), concepto_codigo, concepto_nombre, grupo, subgrupo rrrrrrc<aaaaT;'gRP4pS SR 2oVV3RlpV!V4pRoVV3Rlo/pVPR/4pVPV4;'gVPR4;'g/PR.4pV'gDVR8wd=V!R4pVPR/4pVPR/4PR.4pS!Wd4.ROp\4p.p VFwrrpW9gW9dKVPV 4VPV P RR4P R R 4P R R 4P R R44T P RT RT RT RT RVPV ^4;'g^RV/4K VPR^4;'g^V 3#)rr-c <\P!RSRSRRRV.RR/4P4p\PP \ VR\RR /R R 7p\PPV^\R 7;_uu_4p\P!VP44uuRRR4# +'giR#;irr)bu_coder rfrrrs& r _request_liveCProxyHandler._stats.._fetch_pyg_live.._request_lives#zz(#$f)4,wi*E +  "68 %nn44#$%0'>K]$^#)5 $^^33CW3UUY]#'::diik#:VUUUs $B== C c VPR/4PR/4p\V\4'dVP4Fyp\V\\ 34'd\ V4u#\V\4'gKD\ VPRVPR^44;'g^4u# R#rrrXr?rArkrrxrprDrnoderrs& r _flat_val?ProxyHandler._stats.._fetch_pyg_live.._flat_vals#xx 26::62F%dD11%)[[]#-a#u#>#>+08O#-a#6#6+0uaeeGQ>O1P1U1UTU+V$V &3 #r$c<VF6pS!V4WPRR4&S!VPR.4V4K8 R#rrrNr)rrrrrs&& rr>ProxyHandler._stats.._fetch_pyg_live.._flatten s8!&A3._fetch_pyg_lives--..0B #uSI.F; (+C#A D''%,CGGBKAA3777+;AArFFvrRDB'M+G4!ggeR0"www377CT(%M,5D "IKXG-"?g.A$)s!;!C!CD#!N!V!VW[]`!a!i!ijnps!tu!(( '$f#U&!488GQ#7#<#<1+] * LY 88L!4999DDr$rru- ⚠️ P&G en vivo falló para company_id=z bu=u> ⚠️ P&G en vivo (fallback local) falló para company_id=ay SELECT company_id::int AS cid, bu_codigo, raw_data FROM historico_nomina_pyg WHERE fuente='pyg' AND registro_tipo='respuesta' AND ano=%s AND mes=%s AND company_id = ANY(%s) ORDER BY company_id, cargado_en DESC rc VPR/4PR/4p\V\4'dVP4Fyp\V\\ 34'd\ V4u#\V\4'gKD\ VPRVPR^44;'g^4u# R#rrrs& r_fv ProxyHandler._stats.._fvh s#'88Ir#:#>#>vr#JD)$55)-A'1!c5\'B'B5QR8O'1!T':':5uVWV[V[\cefVgIhImImlmCn._flp s8%*7:1vEE$O 4 #AEE*b$93 ?&+r$Trrrrrrrrrrr 901418135z Hotel CaribezThe Clubz THE CLUB CTGz La Mantillar2z Casa Don Luisr4z FC Cartagenar6a  SELECT emp->>'centro_costo' AS cc, (emp->>'dias')::float AS dias FROM ( SELECT raw_data FROM historico_nomina_pyg WHERE fuente='nomina' AND registro_tipo='respuesta' AND nit=%s AND ano=%s AND mes=%s ORDER BY cargado_en DESC LIMIT 1 ) latest, jsonb_array_elements(latest.raw_data->'empleados') AS emp ccc3,<"TF qS9xK R#5irrE)rrFrs& rr&ProxyHandler._stats.. s51BwsrrVrAc3P<"TFwwrq1S8XgKVR,xK R#5irNrE)rrrrSERV_NITs& rrr s,%8M96A1V^Q^&Ao&&8Ms &&c32"TF qR,xK R#5i)rNrE)rrs& rrr s8cLbq6LbrKall_busc38"TFq;'gRxK R#5i)rNrE)rrs& rrr s1P1,,w,s  c3~<"TF2pSPSV3/4PR4;'g^xK4 R#5irrrrrq nomina_bu_maps& rrr s=-yqxlmm.?.?a".M.Q.QRa.b.g.gfg.gqx.= =c3~<"TF2pSPSV3/4PR4;'g^xK4 R#5i)rNrr s& rrr s=-wovjkm.?.?a".M.Q.QR_.`.e.ede.eovr rr)rrrr" emps_direct emps_outsourcdias_laborados dias_promedio costo_totalingresos pct_nominac(VR,;'g^#)rrE)r-s&rrG%ProxyHandler._stats.. s-(8(=(=A(=r$)rreversec32"TF qR,xK R#5i)rNrErr-s& rrr s"E1]#3#3rKc32"TF qR,xK R#5i)rNrErs& rrr "E1Z==rKc32"TF qR,xK R#5i)rNrErs& rrr rrKc3F"TFqR,;'g^xK R#5i)r"NrErs& rrr s"E1[>#6#6Q#6! !c3F"TFqR,;'g^xK R#5i)rNrErs& rrr s"JT%5#6#;#;!#;Trc3v"TF/qR,;'g^VR,;'g^,xK1 R#5i)rr"NrErs& rrr s2#OS!',,1;1D1D1EEts 999r;totalesz kpis-agregadoa# SELECT DISTINCT h.nombre_personalizado AS label, e.pyg_company_id AS company_id, LOWER(h.bu_codigo) AS bu_codigo FROM hotel_unificacion h JOIN empresas e ON h.razon_social = e.codigo WHERE e.pyg_company_id IS NOT NULL AND h.nombre_personalizado NOT IN ('No mostrar') AND h.hotel_name_api IS NOT NULL ORDER BY h.nombre_personalizado rooms_totalrooms_occupiedhab_fisguests days_in_monthrrrrrTrrrUrVrYkpi_snapshots_by_burcn<SPV4;'g/PR^4;'g^#rXr)rsnap2s&rkv2 ProxyHandler._stats..kv2U s.EIIaL,>,>B+C+CE1+M+R+RQR$Rr$ guests_totalhabitaciones_fisicasg333333?u% ⚠️ KPI ocupación falló para g333333?r occupancy_pctz kpis-hotelryzFalta company_idcn<SPV4;'g/PR^4;'g^#r(r)rsnaps&rkvProxyHandler._stats..kv s-#)<)<"(A(A%(K(P(Pq!Pr$rrhh_empleadosrrhh_empleados_activos rrhh_costorrhh_costo_totalrrhh_ausentismorrhh_ausentismo_mes rrhh_rotacionrrhh_tasa_rotacionrFrrrr)Fr)HCARIBEzH CARIBEzH CARIBE VENTAS)F urllib.parserrrrrirrLrMrNr7r8rorDrkr)rjrlrOrwrxrprrrQrr setdefaultrrrnextiterrrrrranyrnmaxrrQdaysfromkeysr*rsortrIcalendar monthrangerrrr]r^r_r rrarbrrsleeprrlrnrrrr)rarrrqrrrrS_conn_returnedrTrWrr& hotel_where hotel_argsr-r nit_countshconceptos_rowsrrrrnomina_raw_maprr ingresos_mappyg_conceptos_maprrrrr} need_pairsr need_cids resp_by_cidrrrCDEFrrrrflat_srr rcsrrrrnbr SERV_PATTERNS serv_by_labellblrserv_total_nom serv_otrosdias_mesr;nom_buraw_busrr  emps_servdias_dir dias_serv_nom serv_inforrdias_nom_totalrnom_calcrcostor tot_costo tot_devengos tot_ingresostot_empstot_dias tot_dias_nom tot_dias_prom_time_calano_kmes_k hoteles_kpiragg valid_countrbody_preq2resp2raw2snaps2snap_bu2r*occrrrrfrrMsnapssnap_bur#r1rEr%r rrrrrrrrrWrrrrXrqr r0r)s& @@@@@@@@@@@@@@@@@rrProxyHandler._statssi 4$))$&,,';;$$_5b9 K &;;hoo.L.L;MCD,,BFF5VH5a89BFF5SE2156w-a0668!#sA.88: !  "QK#('J !6#m$7: ;!<9< G1W:tAw.G  )A+5>>!E(A+F+JJqx(*  47<<>!B>a$q'>!BBP$Q.QS8%5q%8.$Q!(*%'A!!%% "5"N"Nx"N"NBOUUWG!!%%/"7"7R8>>@FFHGDE)WIQwi*@A( l E8; 1^^@P&  3Z !DG<<>!R>aE(AjM"9>!R7 11#s;;29..2BS2BQaeeEl%2BSm2DS2IN3/ T (3Z)!*HK||~ V~!E(AdG!4d1g!=~ V  3Z !VYUaUaUcdUcPQ51T7 3Q~5F5K5K! KUc d 3Z!%'!A%00!E(AdGL#r3;D-sBi8.%^^-eeL1UU:.99'"bGm$'++S"Iq9A=ARAVAVX[]_W`AaAa$I2A#w2O/Hi'!|y:B c2Y 7?H 13) <09. --c377")!1"!1A55.H7H7L7LaP\o_`_d_deo_p_{_{t{M|7}H<!%% *;*F*FwG!1" "z$(J)GJ&#q#J)G$H  % "3 2 4') "%,,.B!#ER _-G-G,N,N,P QA 313J A#1 '@  ,*4IS"!,#r!;!^!^{PSU\~?^B#%x"$&&"3C$'GGBK$c$c37773C$c$ctDQTQ[Q[Q]L^`bGc#h#hioqs#tD#%DdO%'F(, 1$%GGCL$4#$F?F1I)5(+ub"DDH @VUHb#&$;&*hhsm&F&Fvzz##&; $ $T#)>)F)FtC)P)X)XY]^a)b)j)jkops)t u " 4hQV+5xc VWYhjl+n!o EI "r?A 13) <+*42'"%On%5!j\#eW"&D%E !  S) +!# AD'--R..0B%2%8%8%: T3553335555"-76TTZZ!*37Aq!9Ic2q[9=T+U%VKO" 5&**3/,6NN3,Ba,G H JM!2!6!6Ry"!ERTI*8F+;YGE' 3RRvzz*7MRRQRHHK 0 0#rA > C C!QRHKK##$##!K.#$%+')(.'-%%"("($hYZl%0@30F*J`d!].~ =t L #"E"EE ""E"EE ""E"EE ""E"EE""JT"JJ"#OS#  CKQ,lX&= >TX 3sD#((('-%)",",$VbefVf% L0H30NPQ*Rlp  _,7BFF56(3A67BFF5C51!45  "lln  W__T2TN"GE#;/$a)91iOT__UE5RST5UW $A oC ~88??AG!!%(#c(Hf)41AG9*D-""68  &~~55#&%0'>K]$^#) 6  $^^33D"g3VVZ_#'::ejjl#;DW"&((+@""E#)::gvzz'27N#O"*,,vr":">">vr"JRM*]1CC*,-5E1FF-H ^1DD I:PRS1T1Y1YXYY#q(  D)3%@]+a/C 01C 4FFLaP59{#C,@*C N!C ,>$C0@,A#C"CM\) VVL2$7:  x!8!;< !6q!9:VVK';A>DDFQQ' !#%78D!&c{3F#zz$#j/ &%$(9+&$ +  vx IIK!6 ..00h!,g~GY Z%1C  //R/QQUY"jj5R"gg&;R@E#ii 599Wb3IJG%kk&"599&"ED!gg&'"_*=&"^*<("-E*F$"-?*@)"-B*C'"-A*B D::dCeDKKGTD   s #   ^-N O OO      JJ  T ""%"sH"C$Q@"S& T )m!$NseSUVYUZZ[\_`c[ddghigj"kllm4!W ex )x!$QRUQVVZ[]Z^^`ad`eefgjknfoorstru"vwwx )I!$bcfbggklnkooqruqvvwx{|xAADEFDG#HIII " *HlWVV%! EaeeGnEUUWX]W^^_`efi_jjmnompqr C( !TRQQH J   s #   ^-? @ OO      JJ  TZZ(;(;A(>?FFH I I  J"%"s>7C6A[ -AVA(A[ 0AV A[ AV&&A[ A[ &1A[ BA[ AV23A[ %AV AVA[  AV "*A[ $AW0)A[ $AW>AWA A[ AA[ 3A[ ?A[  A[ A[ AW6AA[ 7 A[ :A[ =A[ AXAX)A[ A[ AY8*AY# AY3AYAYA[ 0AY >A A[ A[ #AA[ $A[ +A[ ,A[ A3A[ =AA[ >BA[ A[ 7AA[ AA[ A[ :AA[ E A[ !AA[ "B A[ 0A[ A A[ BA[ 5A[ A[ ( A[ 3A[ HA[ @*A[ @X7A[ X>AYYA[ Y AY" Y AY%Y% AZ4Y08AZ/Z(A[ Z/AZ4Z4A[ Z7 A[ [ A[ [ A]0[BA]+]%A]3]+A]0]0A]3]3 A^c<RV^,9g/\V4^8d5V^,PR4'd\SV` !V.VO5!R#R#R#)r4N)r*rsr^ log_message)rafmtrbrds&&*rrProxyHandler.log_message sG Q CIMd1g6H6H6M6M G  +d +7NMr$rE)'__name__ __module__ __qualname____firstlineno__r_rnrurrrrrrrrrrr{rN staticmethodrQrgrrrrrrrrrrrrrr__static_attributes____classdictcell__ __classcell__)rd __classdict__s@@rr[r[xs9/ "2FTR7Tt<T~0JfbTJ- AAE<;>%P4;|`;DN `E@E0OO 33 @ @P "fW &r,,r$r[c"]tRtRtRtRtRtRtR#)ThreadingHTTPServeri zIServidor HTTP con soporte multi-hilo para atender peticiones en paralelo.TrEN)rrrr__doc__daemon_threadsallow_reuse_addressrrEr$rrr sSNr$r__main__rru,✅ Servidor corriendo en http://localhost:z1 Dashboard activos: /dashboard-empleados.htmlz0 Dashboard salarios: /dashboard-salarios.htmlu, Proxy API: /proxy/rrhh/... → z /rrhh/...u2 Proxy históricos: /proxy/historico/salariosz Ctrl+C para detener. u 🛑 Servidor detenido.)rrE)Er http.serverhttp socketserverurllib.requestr] urllib.errorrr|rrIr7rv psycopg2.poolrr<rrdatetimerrj app_configrrrr r r r r r#r0rorbrDgetenvr7r`rrr)r9r:rzr?rrdirnamer__file__r` DB_CONFIGrThreadedConnectionPoolrLrJrKrYserverSimpleHTTPRequestHandlerr[ThreadingMixIn HTTPServerrrchdirhttpdr serve_foreverKeyboardInterrupt)rms0rrs +&   5 1( ZL UG + ,  - 299VV $%  ))5 eCj||~ FLLN /2. 6=*E2 GGOOBGGOOH5 6 K  -- . . Rq R" R R!$c2&~(,4;;77~(,BR,55t{{7M7M  z$m4HHSM b$Z 6 6%