o
    ²ˆ™ho  ã                
   @   s  d dl mZmZ d dlmZ ddlmZ dZdZddedB d	dfd
d„Z	ddee dedB d	e
fdd„ZddedB d	dfdd„Zddee dedB d	e
fdd„ZddedB d	ee fdd„Zddedee dedB d	ee fdd„Zddede
dedB d	ee fdd„ZdS ) é    )ÚListÚDict)ÚClienté   )Úget_supabaseÚmoef_orgÚmoef_vipNÚsbÚreturnc                 C   ó(   | pt ƒ } |  t¡ ¡  dd¡ ¡  d S )NÚidéÿÿÿÿ)r   ÚtableÚ	ORG_TABLEÚdeleteÚneqÚexecute©r	   © r   ú5/var/www/html/govbot/app/services/moef_org_service.pyÚ	clear_org   ó   
r   Úrowsc                 C   ó4   | sdS |pt ƒ }| t¡ | ¡ ¡ }t|jpg ƒS ©Nr   )r   r   r   Úinsertr   ÚlenÚdata©r   r	   Úresr   r   r   Úbulk_insert_org   ó
   
r    c                 C   r   )NÚ
departmentÚ	__never__)r   r   Ú	VIP_TABLEr   r   r   r   r   r   r   Ú	clear_vip   r   r%   c                 C   r   r   )r   r   r$   r   r   r   r   r   r   r   r   Úbulk_insert_vip   r!   r&   c                 C   sp   | pt ƒ } |  t¡ d¡ ¡ }tƒ g }}|jpg D ]}| d¡p"d ¡ }|r5||vr5| 	|¡ | 
|¡ q|S )Nr"   Ú )r   r   r   Úselectr   Úsetr   ÚgetÚstripÚaddÚappend)r	   r   ÚseenÚoutÚrÚdr   r   r   Úget_all_departments   s   
€r2   r"   Ú	positionsc                 C   s<   |pt ƒ }| t¡ d¡ d| ¡ d|¡}| ¡ }|jpg S )Nú#department,name,position,task,phoner"   Úposition)r   r   r   r(   ÚeqÚin_r   r   )r"   r3   r	   Úqr   r   r   r   Úselect_vip_by_department(   s   
ý
r9   é2   ÚkeywordÚlimitc                 C   sN   | sg S |pt ƒ }d| › d| › d}| t¡ d¡ |¡ |¡ ¡ }|jp&g S )u]   
    ì´ë¦„(name) ë˜ëŠ” ë¶€ì„œ(department)ì— keywordê°€ í¬í•¨(ILIKE)ëœ í–‰ì„ ê²€ìƒ‰
    zname.ilike.%z%,department.ilike.%ú%r4   )r   r   r   r(   Úor_r<   r   r   )r;   r<   r	   Úcondr   r   r   r   Úsearch_moef_org2   s   
ü
r@   )N)r:   N)Útypingr   r   Úsupabaser   Úsupabase_servicer   r   r$   r   Úintr    r%   r&   Ústrr2   r9   r@   r   r   r   r   Ú<module>   s      (
(
