B
Òîb~ ã @ sÈ d dl Z d dlZd dlmZ d dlZd dlZd dlmZm Z d dl
m Z d dl m
Z
d dlmZ d dlmZmZ d dlmZ d d lmZ d d
lmZ G d d „ d e
ƒZG d
d„ deƒZG dd„ deƒZdS )é N)Úsettings)Ú gettext_lazyÚactivate)Ú serializers)Ú FilterSet)Ú
Unregister)Ú$BaseUnregisteredUserReportSerializerÚ!BaseUnregisteredUserReportViewSet)Úresize_by_pixel)Úshort_date_and_time_format)Útemperature_updatec @ sZ e Zd Zejr,ejdddZejdddZn ejdddZejdddZG dd„ dƒZ dS ) Ú UnregisteredUserReportFilterZpunch_time__dateZgte)Z
field_nameÚ lookup_exprZlte)Únamer c @ s e Zd ZeZddgZdS )z!UnregisteredUserReportFilter.MetaÚ
start_dateÚend_dateN)Ú__name__Ú
__module__Ú __qualname__r ÚmodelÚfields© r r úKG:\easytimepro\master/mysite/att\api\views\view_report_unregisteredusers.pyÚMeta s r N)
r r r ÚsixZPY3Údjango_filtersZ
DateFilterr r r r r r r r
s r
c @ sR e Zd ZejedƒdZe ¡ Ze ¡ Zdd„ Z dd„ Z
dd„ Z G d d
„ d
ƒZ d S ) Ú UnregisteredUserReportSerializerZ$report_column_unregistereduser_photo)Úlabelc C s |j r|j}|S dS )z€
get the first trans refer the payloadbase record
:param obj:
:return: trans id
Ú )Ú terminal_snÚid)ÚselfÚobjZtrans_idr r r Úget_unregistereduser_photo% s z;UnregisteredUserReportSerializer.get_unregistereduser_photoc C s y
|j }W n
dS t|ƒS )Nr )Ú
punch_timer )r! r" r$ r r r Úget_punch_time0 s
z/UnregisteredUserReportSerializer.get_punch_timec C s" y
|j }W n
dS t||jƒS )Nr )Ú temperaturer Z
company_id)r! r" r& r r r Úget_temperature7 s
z0UnregisteredUserReportSerializer.get_temperaturec @ s e Zd ZeZdZdS )z%UnregisteredUserReportSerializer.Meta)r r$ r& Ú mask_flagÚunregistereduser_photoN)r r r r r r r r r r r > s r N)
r r r r ZSerializerMethodFieldÚ_r) r$ r& r# r% r' r r r r r r s r c @ sD e Zd ZeZeedœZd
dd„Zdd„ Zdd„ Z d d
„ Z
d d „ Z dS )Ú UnregisteredUserReportViewSet)ÚlistZexportNc C sô xît |ƒD ]â\}}y| j d¡}W n d}Y nX |dkrr|| }|dkrVd||< qz|dkrhd||< qzd||< nd||< y| j d ¡}W n d}Y nX |dkrä|| } | | ¡}
|
rÖ|
jd
d }
d |
¡||< qìtd
ƒ||< q
d||< q
W |S )z"only use for att report pdf reportr( NÚNoneZYesz(YesZNoz'Nor r) zUTF-8)Úencodingz$
Zphoto_not_found)Ú enumerateÚexport_headersÚindexÚtrans_id_to_base64ÚdecodeÚformatr* ) r! Zdatasr0 Ú
extra_dataÚiÚdataZmask_flag_indexÚstatusZ photo_indexÚtran_idZ image_base64r r r Úupdate_data_listL s4
z.UnregisteredUserReportViewSet.update_data_listc C s t dƒ tdƒS )NZenZunregistered_users_report)r r* )r! r r r Úget_file_titlem s z,UnregisteredUserReportViewSet.get_file_titlec
C s |sd S t jj|d dd¡}|r|d \}}| 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 ƒ t|d ƒ} t | ¡ ¡} | S Q R X d S )
N)r r$ r r z%Y%mz {0}-{1}.jpgz %Y%m%d%H%M%Sr z unregistered_user_report/{0}/{1}zupload/{0}/{1}i A Úrb)r ÚobjectsÚfilterÚ values_listÚstrftimer4 ÚosÚpathÚjoinr ÚADDITION_FILE_ROOTÚexistsÚmakedirsr
ÚopenÚbase64Z b64encodeÚread)
r! r9 Útransr$ ÚsnÚ folder_nameÚ
photo_nameÚdest_file_pathÚdest_whole_pathÚsource_file_pathÚsource_whole_pathÚfZ base64_datar r r r2 q s,
z0UnregisteredUserReportViewSet.trans_id_to_base64c C sä d }|s d S t jj|d dd¡}|rà|d \}}| 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$ r r z%Y%mz {0}-{1}.jpgz %Y%m%d%H%M%Sr z unregistered_user_report/{0}/{1}zupload/{0}/{1}i A )r r= r> r? r@ r4 rA rB rC r rD rE rF r
) r! r9 rO rJ r$ rK rL rM rN rP rQ r r r Útrans_id_to_url‹ s*
z-UnregisteredUserReportViewSet.trans_id_to_urlc C sn || dkrj| |¡}|rX| || |d¡ | || ||dddœ¡ | || d¡ n| || |d¡ dS ) z#use for update the data when insertz
User Photoú é g333333ó?)Zx_scaleZy_scaleép zUser Photo Not FoundN)rS ÚwriteZ insert_imageZset_row)r! Z worksheetZtranslated_headersZ col_indexZ row_indexZ
row_index_temZcol_dataZ
photo_pathr r r Úxls_update_extra_data£ s
z3UnregisteredUserReportViewSet.xls_update_extra_data)N) r r r r
Z filter_classr Zserializer_dictr: r; r2 rS rX r r r r r+ E s
!r+ )rH rA Z django.confr r r Zdjango.utils.translationr r* r Zrest_frameworkr Z django_filters.rest_frameworkr Zmysite.iclock.modelsr Z6mysite.att.api.views.view_report_base_unregistereduserr r Zmysite.tools.image_utilsr
Zmysite.att.utilsr r r
r r+ r r r r Ú s %