B
ÒîbC. ã @ s˜ d dl Z d dlZd dlmZ d dlmZmZ d dlm Z d dl
m Z d dl m
Z
d dlmZ d dlmZ d d lmZ G d
d „ d eƒZG d d
„ d
e
ƒZdS )é N)Úsettings)Ú gettext_lazyÚactivate)Ú serializers)Ú Transaction)Ú BaseTemperatureReportViewSet)Ú BaseTemperatureReportSerializer)Ú PayloadBase)Úresize_by_pixelc @ s2 e Zd ZejedƒdZdd„ ZG dd„ dƒZdS )Ú!VerificationPhotoReportSerializerZ report_column_verification_photo)Úlabelc C sÐ |j }|j}d}tjj||dd d¡ dd¡}| ¡ rj|d d }x†|D ]}|d dkrJ|d }P qJW nbtjj||dd d¡ dd¡}| ¡ rÌ|d d }x,|D ]$}|d dkr¤|d }td |ƒ P q¤W |S )
NÚ é )Úemp_idZpunch_time__dateZ punch_statez -punch_timeZ mask_flagÚidr Ú
punch_timeztransaction id) r Úatt_dater ÚobjectsÚfilterZorder_byÚ values_listÚexistsÚprint)ÚselfÚobjr r Ztransaction_idZcheckout_transactionÚiZcheckin_transaction© r úKG:\easytimepro\master/mysite/att\api\views\view_report_verificationphoto.pyÚget_verification_photo s*
z8VerificationPhotoReportSerializer.get_verification_photoc @ s e Zd ZeZdZdS )z&VerificationPhotoReportSerializer.Meta)ZuuidÚemp_codeZ
first_nameÚ last_nameZ nick_nameZgenderÚ dept_codeZ dept_nameZ
position_codeZ
position_namer Zclock_inZ clock_outr Úverification_photoN)Ú__name__Ú
__module__Ú __qualname__r ZmodelZfieldsr r r r ÚMeta2 s r% N) r" r# r$ r ZSerializerMethodFieldÚ_r! r r% r r r r r s r c @ sJ e Zd ZeedœZddd„Zddd„Zdd„ Zd d
„ Zd d „ Z d
d„ Z
dS )Ú VerificationPhotoReportViewSet)ÚlistZexportNc C sø xðt |ƒD ]â\}}y| j d¡}W n d}Y nX |rPd|| d ||< y| j d¡}W n d}Y nX |r¦|| r¦d|| d d t|| ƒ d ||< y| j d ¡}W n d}Y nX |rü|| rüd|| d
d t|| ƒ d ||< y| j d ¡} W n d} Y nX | r\|| r\|| }
|
d krJd
|| < n|
dkr\d|| < y| j d¡} W n d} Y nX | r¶|| } | | ¡}
|
r¶|
jdd}
d |
¡|| < t|tƒrÔ| d|d ¡ q t|ƒ}| dd¡ |||< q W |S )z"only use for att report pdf reportr NzzÚin_tempzÚout_tempÚout_temp_colorÚdisplayed_maskÚYesz(YesÚNoz'Nor! zUTF-8)Úencodingz$
r r r
)
Ú enumerateÚexport_headersÚindexÚstrÚtrans_id_to_base64ÚdecodeÚformatÚ
isinstancer( Úinsert)r Údatasr2 Ú
extra_datar ÚdataÚatt_date_indexÚ
in_temp_indexÚout_temp_indexÚdisplayed_mask_indexÚstatusÚ photo_indexÚtran_idÚ image_base64r r r Úupdate_data_list@ sZ
(
(
z/VerificationPhotoReportViewSet.update_data_listc C sD x<|D ]2}x*t |ƒD ] \}}y| j d¡}W n d}Y nX |rht|tƒrhd|| d ||< y | j d¡}| j d¡} W n d }} Y nX |rÊ|| rÊd|| d t|| ƒ d ||< y | j d ¡}
| j d
¡} W n d }
} Y nX |
r0||
r0d|| d t||
ƒ d ||
< y| j d ¡} W n d} Y nX | r|| r|| }
|
d kr~d
|| < n|
dkrd|| < y| j d¡}W n d}Y nX |rê|| }| |¡}|rê|jdd}d |¡||< |d= |d= |dkrt|tƒr | d|d ¡ qt|ƒ}| dd¡ |||< qW qW |S )z"only use for att report pdf reportr Nzzr) r* zr+ r, r- r. z(Yesr/ z'Nor! zUTF-8)r0 z$éÿÿÿÿr r r r
)
r1 r2 r3 r8 r( r4 r5 r6 r7 r9 )r r: Zgroup_by_fieldr; r< r Úvr= r> Zin_temp_color_indexr? Zout_temp_color_indexr@ rA rB rC rD r r r Úupdate_group_data_listz sf
$ $
z5VerificationPhotoReportViewSet.update_group_data_listc C s t dƒ tdƒS )NZenz Verification Photo (TD&MD)Report)r r& )r r r r Úget_file_title» s z-VerificationPhotoReportViewSet.get_file_titlec C s
|sd S t jj|d ddd¡}|r|d \}}}| d¡}d | d¡|¡}d ||¡}tj t j
|¡}tj ||¡} tj |¡st |¡ tj | ¡sâd
||¡}
tj t j
|
¡}
tj |
|¡} tj | ¡sÖd S t
| | d ƒ t| d ƒ} t | ¡ ¡}
|
S Q R X d S )
N)r r Ú terminal_snr r z%Y%mz {0}-{1}.jpgz %Y%m%d%H%M%Szverification_report/{0}/{1}zupload/{0}/{1}i A Úrb)r r r r Ústrftimer7 ÚosÚpathÚjoinr ÚADDITION_FILE_ROOTr Úmakedirsr
ÚopenÚbase64Z b64encodeÚread)r rC Útransr Úsnr Ú folder_nameÚ
photo_nameÚdest_file_pathÚdest_whole_pathÚsource_file_pathÚsource_whole_pathÚfZ base64_datar r r r5 ¿ s,
z1VerificationPhotoReportViewSet.trans_id_to_base64c C sè d }|s d S t jj|d ddd¡}|rä|d \}}}| d¡}d | d¡|¡}d ||¡} tj t j
| ¡} tj | |¡}tj | ¡s’t | ¡ tj |¡säd
||¡}
tj t j
|
¡}
tj |
|¡} tj | ¡sØd S t
| |d ƒ |S ) N)r r rJ r r z%Y%mz {0}-{1}.jpgz %Y%m%d%H%M%Szverification_report/{0}/{1}zupload/{0}/{1}i A )r r r r rL r7 rM rN rO r rP r rQ r
) r rC rZ rU r rV r rW rX rY r[ r\ r r r Útrans_id_to_urlÚ s*
z.VerificationPhotoReportViewSet.trans_id_to_urlc C s@ || dkr<| |¡}|r<| || ||¡ | || d¡ dS )z#use for update the data when insertzVerification Photoé_ N)r^ Z insert_imageZset_row)r Z worksheetZtranslated_headersZ col_indexZ row_indexZ
row_index_temZcol_dataZ
photo_pathr r r Úxls_update_extra_dataò s
z4VerificationPhotoReportViewSet.xls_update_extra_data)N)N) r" r# r$ r Zserializer_dictrE rH rI r5 r^ r` r r r r r' : s
:
Ar' )rS rM Z django.confr Zdjango.utils.translationr r& r Zrest_frameworkr Zmysite.iclock.modelsr Zmysite.att.api.viewsr Z0mysite.att.api.views.view_report_basetemperaturer Zmysite.att.modelsr Zmysite.tools.image_utilsr
r r' r r r r Ú s )