U
    $i                     @   sB   d dl Z d dlZd dlmZ d dlmZ eee edddZdS )    N)date)List)transfer_daterowsreturnc           	      C   s   t  }tj|tjddd}| d}tdd |D }t|}|d||j	pPdt
|t
|dg |D ]b}||d	 |d
 |jpd|jpd|jpddt
|d d||jpdddddddd|jpddg qh| S )a  
    Build Kopramandiri bulk-transfer CSV.

    Header row:
        P,YYYYMMDD,<company_account>,<count>,<total>,

    Detail row per employee:
        <account_number>,<name>,<city>,<district>,<province>,IDR,<amount>,
        Trf InHouse,YYYYMMDD,<relationship>,,,,,,,Y,<email>,
    \
)quoting
escapecharlineterminatorz%Y%m%dc                 s   s   | ]}|d  V  qdS )amountN ).0rr   r   =/var/www/html/me.goteku.com/backend/app/helpers/csv_export.py	<genexpr>   s     z)build_kopramandiri_csv.<locals>.<genexpr>P account_numbernameZIDRr   zTrf InHouseIBUY)ioStringIOcsvwriter
QUOTE_NONEstrftimesumlenwriterowr   strcitydistrictprovincerelationship_typeemailgetvalue)	r   companyr   outputr   Zdate_strtotal_amountemployee_countrowr   r   r   build_kopramandiri_csv   sR    


     r-   )	r   r   datetimer   typingr   dictr!   r-   r   r   r   r   <module>   s   