o
hV @ s d dl mZ d dlmZmZmZmZmZ d dlm Z m
Z
m Z d dl m
Z
d dlmZmZmZ d dlmZ e ZdZd*d d
Zd+ddZd,ddZd-ddZejde
de d d e d d e d d e d d d fd.d'd(Zd)S )/ ) annotations)AnyDictListSetTuple) APIRouterRequestQuery) HTMLResponse) templatessblogger)Counter
txtstrreturnintc C s, | pd }|dr
dS |drdS dS )N u 위원장r u 간사 )strip
startswith)r t r 2/var/www/html/bot/app/web/pages/congress/search.py
_role_rank s r nr c C sD zt | }W n
ty Y dS w |dkrdS |dkr dS | dS )N-r u 초선r u 재선u 선)r Exception)r vr r r _label_election s
r" r!
str | Nonec C s" | pd }|rd| S dS )Nr z
)r joinsplit)r! sr r r _district_br s r' col List[str]c
s zt d| d jpg }W n ty2 } ztd| d| g }W Y d }~nd }~ww t }|D ]}|
| p@d }|rJ| | q8t
|S )Ncongress_member_cur' z distinct fetch fallback for z: r )r
tableselectlimitexecutedatar r warningsetgetr addsorted)r( rowsevalsrr! r r r _distinct_values s $
r: z/congress/search)response_classall)defaultr r )r= gerequestr committeepartyqpagec s |pd tdI d H }tdI d H } fdd}d}g } zBtdjdd d
}
||
} t| d d p>t| jp=g }|d t } | t d }
tdd
}||
| |
}| jpag } W n` t y } zTt
d| d z7tddd jpg } fddfdd|D }t|}|d t } | t }
|| |
} W n
t y g } d}Y nw W Y d }~nd }~ww | jdd d | D ]}t|d|d< t|d|d < q|d k}|t |pdk }td | ||| |||t |d S ) Nr committee_namerA c sN dkr
| d } dkr| d} r%d d}| dj|d} | S )Nr< rD rA %zdfull_name.ilike.{kw},name_hanja.ilike.{kw},party.ilike.{kw},district.ilike.{kw},role_name.ilike.{kw})kw)eqor_format)queryrF r@ rA q_normr r
apply_filters9 s
z&congress_search..apply_filtersr r* idexact)countrP r zcommittee_name,role_name,full_name,name_hanja,party,district,phone,room_no,photo_url,member_page_url,aide_staff,aide_secretary,aide_secretary2,election_countz)congress_member search fallback (reason: )zcommittee_name,role_name,full_name,name_hanja,party,district,phone,room_no,photo_url,member_page_url,aide_staff,aide_secretary,aide_secretary2,election_count,idr+ c
s dkr
| d kr
dS dkr| dkrdS s dS }d| dd| d d| dd| d
d| d dg }||v S ) Nr< rD FrA T full_namer
name_hanjadistrict role_name)r3 lowerr$ )r9 keytgtrK r r hit] s z congress_search..hitc s g | ]} |r|qS r r ).0r9 )rZ r r
g s z#congress_search..c S s t | dd| ddfS )NrV r rS )r r3 )r9 r r r p s z!congress_search..)rX election_countelection_labelrU district_brzcongress/search.html) r? r@ rA rB
committeespartiesr6 rC has_prevhas_nextper_pagetotal)r r: r
r, r- r/ getattrlenr0 PER_PAGEranger r r1 r. sortr" r3 r' r TemplateResponse)r? r@ rA rB rC ra rb rM rf r6 base
total_respstartendq2r7 r0 filteredr9 rc rd r )r@ rZ rA rL r congress_search, sj
rs N)r r r r )r r r r )r! r# r r )r( r r r) )
r? r r@ r rA r rB r rC r )
__future__r typingr r r r r fastapir r r
fastapi.responsesr app.web.depsr r
r collectionsr routerri r r" r' r: r3 rs r r r r s$