o
    ’x™h‰  ã                
   @   sø   d dl Z 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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 )é    N)ÚListÚDict)ÚClienté   )Úget_supabaseÚ	motie_orgÚ	motie_vipÚsbÚreturnc                 C   ó(   | pt ƒ } |  t¡ ¡  dd¡ ¡  d S ©NÚidéÿÿÿÿ)r   ÚtableÚ	ORG_TABLEÚdeleteÚneqÚexecute©r	   © r   ú6/var/www/html/govbot/app/services/motie_org_service.pyÚ	clear_org	   s   
r   Úrowsc                 C   ó4   | sdS |pt ƒ }| t¡ | ¡ ¡ }t|jpg ƒS )uZ   
    rows: [{department, name, position, task, phone}, ...]
    ë°˜í™˜: ì‚½ìž… ê±´ìˆ˜
    r   )r   r   r   Úinsertr   ÚlenÚdata©r   r	   Úresr   r   r   Úbulk_insert_org   s
   
r   c                 C   r   r   )r   r   Ú	VIP_TABLEr   r   r   r   r   r   r   Ú	clear_vip   s   
r!   c                 C   r   )Nr   )r   r   r    r   r   r   r   r   r   r   r   Úbulk_insert_vip   s
   
r"   Ú
departmentÚ	positionsc                 C   s<   |pt ƒ }| t¡ d¡ d| ¡ d|¡}| ¡ }|jpg S )uS   
    motie_orgì—ì„œ department ì¼ì¹˜ + position IN (...) ì¡°ê±´ìœ¼ë¡œ ì¶”ì¶œ
    ú#department,name,position,task,phoner#   Úposition)r   r   r   ÚselectÚeqÚin_r   r   )r#   r$   r	   Úqr   r   r   r   Úselect_vip_by_department$   s   
ý
r+   é2   ÚkeywordÚlimitc                 C   sZ   | sg S |pt ƒ }d| › d}d| › d| › d}| t¡ d¡ |¡ |¡ ¡ }|jp,g S )u\   
    ì´ë¦„(name) ë˜ëŠ” ë¶€ì„œ(department)ì— keywordê°€ 'í¬í•¨'(ILIKE)ëœ í–‰ ê²€ìƒ‰
    Ú.zname.ilike.%z%,department.ilike.%ú%r%   )r   r   r   r'   Úor_r.   r   r   )r-   r.   r	   ÚpatternÚcondr   r   r   r   Ú
search_org0   s   
ü
r4   )N)r,   N)ÚosÚtypingr   r   Úsupabaser   Úsupabase_servicer   r   r    r   Úintr   r!   r"   Ústrr+   r4   r   r   r   r   Ú<module>   s      ((