B
gcA @ s6 d dl Z d dlZd dlmZmZ d dlmZ d dlmZ d dlm Z
m Z d dl m
Z
d dlmZ d dlmZmZ d d lmZ d d
lmZ d d lmZmZ d d lmZm Z m Z m Z d d
l m Z d dl!m"Z" d dl#m$Z$ d dlmZ d dl%m&Z& d dlmZm'Z' G dd dej(Z)G dd deZ*G dd dej+eZ,dS ) N)MaxMin)Q) TruncDate) gettext_lazyactivate)Response) FilterSet)mixins serializers) STATUS_VALID)NoneSerializer)ReportUtilGenericViewSetReportGenericFilter)short_date_formatshort_time_format value_formatweekday_format) Transaction)
CHOICE_GENDER)get_system_setting)
C_ATT_RULE)r STATUS_RESIGN_PENDINGc @ s e Zd ZejedddZejedddddZejed d
dddZejed d dd
Z ej
eddZ ejedddd
Z ejedddd
Z
ejedddd
Zejedddd
Zej
edddZej
edddZej
edddZej
ed ddZej
ed dZejed d d dd!d"Zejed#d d dd$d"Zejed%d&dd
Zejd'dd(Zejd)dd(Zd*d+ Zd,d- Z d.d/ Z d0d1 Z d2d3 Z d4d5 Z G d6d7 d7Z!d8S )9FirstLastReportSerializerZreport_column_empCode
emp__emp_code)labelsourceZreport_column_firstNameemp__first_name-T)r r default
allow_nullZreport_column_lastNameemp__last_nameZreport_column_nickName
emp__nickname)r r r Zreport_column_gender)r Z report_column_departmentCodeemp__department__dept_codeZ report_column_departmentNameemp__department__dept_nameZreport_column_positionCode emp__position__position_codeZreport_column_positionName emp__position__position_nameZ report_column_attendanceDate)r r Z report_column_attendanceWeekdayZreport_column_firstPunchZreport_column_lastPunchZreport_column_totalDurationZreport_column_in_temp cal_in_temp)r Zdecimal_placesZ
max_digitsr r Zreport_column_out_temp cal_out_tempZ report_column_displayed_maskcal_displayed_maskcal_in_temp_color)r r cal_out_temp_colorc C s t t|d |d S )N emp__gender)dictr get)selfobj r3 CG:\easytimepro\master/mysite/att\api\views\view_report_firstlast.py
get_gender; s z$FirstLastReportSerializer.get_genderc C s | dd }|sdS t|S )Ndate )r0 r )r1 r2 att_dater3 r3 r4 get_att_date> s z&FirstLastReportSerializer.get_att_datec C s | dd }|sdS t| S )Nr6 r7 )r0 r weekday)r1 r2 r8 r3 r3 r4 get_weekdayD s z%FirstLastReportSerializer.get_weekdayc C s | dd }|sdS t|S )Nfirstr7 )r0 r )r1 r2 first_punchr3 r3 r4 get_first_punchJ s z)FirstLastReportSerializer.get_first_punchc C s | dd }|sdS t|S )Nlastr7 )r0 r )r1 r2
last_punchr3 r3 r4 get_last_punchP s z(FirstLastReportSerializer.get_last_punchc C s8 d}|d r4|d r4|d |d j }t|dddS |S )Nr7 r< r? ZdurationiQ g ?)Zsecondsr )r1 r2 totalr3 r3 r4 get_total_timeV s
z(FirstLastReportSerializer.get_total_timec @ s e Zd ZeZdZdS )z FirstLastReportSerializer.Meta)emp_code
first_name last_name nick_namegender dept_code dept_name
position_code
position_namer8 r: r= r@
total_timein_tempout_tempdisplayed_mask
in_temp_colorout_temp_colorN)__name__
__module__ __qualname__r modelfieldsr3 r3 r3 r4 Meta] s rX N)"rS rT rU r Z CharField_rD rE rF rG ZSerializerMethodFieldrH rI rJ rK rL r8 r: r= r@ rM Z DecimalFieldrN rO rP rQ rR r5 r9 r; r> rA rC rX r3 r3 r3 r4 r sF
r c @ sZ e Zd Zejr,ejdddZejdddZn ejdddZejdddZG dd dZ dS ) FirstLastReportFilterr6 Zgte)Z
field_name lookup_exprZlte)namer[ c @ s e Zd ZeZdddddgZdS )zFirstLastReportFilter.MetaZ employeesZ departmentsZareas
start_dateend_dateN)rS rT rU r rV rW r3 r3 r3 r4 rX n s rX N)
rS rT rU sixZPY3django_filtersZ
DateFilterr] r^ rX r3 r3 r3 r4 rZ f s rZ c s e Zd ZeZej ZeZ dgZ
e e dZ dZ
fddZdd Zdd Zd
d Zd d
Zdd Zdd Zdd Zdd Zdd Zd ddZd dd Z ZS ) FirstLastReportViewSetrD )listZexport)rM c
s6 | j jj}d|i}| j jj}| j jj}| j jj}tt| j f |}| j jj
si }| rh| |d< | r|| |d< | r| |d< |r|j f |}|
}tt|d}|dkr| ttdtd dB ttdB }|jtdd }|d
d d d
ddddddd }|jtdtddd }|S )NZemp__company_idZemp__department__inZ
emp__area__inZemp__position__in
resign_emp0)Z emp__status
punch_time)r6 emp_idr r r! r" r. r# r$ r% r& r6 )r< r? )requestuserZcurrent_companyZ
get_auth_deptZ
get_auth_areaZ get_auth_possuperra get_querysetfilterZ is_superuserexistsallZdistinctstrr r0 r r r Zannotater valuesr r Zorder_by) r1
company_idZ base_filterZ auth_deptZ auth_areaZauth_posquerysetfiltersrc ) __class__r3 r4 rj s>
z#FirstLastReportViewSet.get_querysetc C sH ddl m}m}m} |dkr |S x |D ]}tjj|d |d d}| r|d }|j}|j } |j
}
|| |} || |} ||
|}
| r| nd|d< | |d< |
|d < tjj|d |d
d}| r(|d }|j}|j }|j
}
|||}|||}||
|}
|r|nd|d < ||d < |d d
kr0d
|d < q(|
dkr(|
|d < q(W |S )z
for mask and cal in temp, base on the data of first Transaction
for cal out temp, base on the data of last Transaction
r )temperature_updateget_real_colorget_mask_valueNrf r< )rf re r) r, r+ r? r* r- NoYes) mysite.att.utilsrt ru rv r objectsrk rl rp Z temperature mask_flag)r1 rq rt ru rv dataZtrans_inZtran_inrp Z
celsius_inr{ rN Z
in_time_colorrP Z trans_outZtran_outZ celsius_outrO Zout_time_colorr3 r3 r4 cal_td_md_data s@
z%FirstLastReportViewSet.cal_td_md_datac O s\ | | }| |}| |}|d k rD| j|dd}| |jS | j|dd}t|jS )NT)Zmany)filter_querysetrj Zpaginate_querysetr} Zget_serializerZget_paginated_responser| r )r1 rg argskwargsrq ZpageZ
serializerr3 r3 r4 rb s
zFirstLastReportViewSet.listc C s | | }| |}|S )N)r~ rj r} )r1 rq r3 r3 r4 get_export_queryset s
z*FirstLastReportViewSet.get_export_querysetc C s | j | jtS )N)serializer_dictr0 actionr
)r1 r3 r3 r4 get_serializer_class s z+FirstLastReportViewSet.get_serializer_classc C s t d tdS )NZenzFirst & Last Report)r rY )r1 r3 r3 r4 get_file_title s z%FirstLastReportViewSet.get_file_titlec C s | dd |S )Nr zNo.)insert)r1 headersr3 r3 r4 update_export_headers s z,FirstLastReportViewSet.update_export_headersc C s: x4t |D ](\}}|d|d i |jddd q
W |S )NzNo. F)r? ) enumerateupdate move_to_end)r1 datasir| r3 r3 r4 update_datas_before_export s z1FirstLastReportViewSet.update_datas_before_exportc C s |r| d | d |S )NrQ rR )append)r1 export_headersgroup_by_fieldr3 r3 r4 update_header_before_export s
z2FirstLastReportViewSet.update_header_before_exportc C s$ |dkr| dd |d= |d= |S )NrI r zNo.)r )r1 r r r3 r3 r4 update_group_export_headers s
z2FirstLastReportViewSet.update_group_export_headersNc C s xt |D ]\}}y| jd}W n d}Y nX |rPd|| d ||< y| jd}W n d}Y nX |r|| rd|| d d t|| d ||< y| jd }W n d}Y nX |r|| rd|| d
d t|| d ||< y| jd } W n d} Y nX | r\|| r\|| }
|
d krJd
|| < n|
dkr\d|| < t|trz|d|d q t|}|dd |||< q W |S )z"only use for att report pdf reportr8 NzzrN zrO rR rP rx z(Yesrw z'Nor r r7 )r r indexrn
isinstancerb r ) r1 r r
extra_datar r| att_date_index
in_temp_indexout_temp_indexdisplayed_mask_indexstatusr3 r3 r4 update_data_list sF
(
(
z'FirstLastReportViewSet.update_data_listc C s0 x(|D ] }xt |D ]\}}y| jd}W n d}Y nX |rht|trhd|| d ||< y | jd}| jd} W n d }} Y nX |r|| rd|| d t|| d ||< y | jd }
| jd
} W n d }
} Y nX |
r0||
r0d|| d t||
d ||
< y| jd } W n d} Y nX | r|| r|| }
|
d kr~d
|| < n|
dkrd|| < y|d= |d= W n@ tk
r } z td |dd }|||< W dd}~X Y nX |dkrt|tr|d|d qt|}|dd |||< qW qW |S )z"only use for att report pdf reportr8 NzzrN rQ zrO rR rP rx z(Yesrw z'Nor zit is sum field nowr rI r r7 ) r r r r rb rn TypeErrorprintr )r1 r r r r| r vr r Zin_temp_color_indexr Zout_temp_color_indexr r er3 r3 r4 update_group_data_list- s\
$ $
z-FirstLastReportViewSet.update_group_data_list)N)N)rS rT rU r rV rz rj rq rZ Z filter_classZorderingr r Zsummary_fieldsr} rb r r r r r r r r r
__classcell__r3 r3 )rs r4 ra s s&
#&
1ra )-r_ r` Zdjango.db.modelsr r r Zdjango.db.models.functionsr Zdjango.utils.translationr rY r Zrest_framework.responser Z django_filters.rest_frameworkr Zrest_frameworkr
r Zmysite.admin.modelsr Zmysite.att.api.serializersr
Zmysite.att.api.utils_classr r ry r r r r Zmysite.iclock.modelsr Zmysite.personnel.db_constr Z mysite.utilsr Zmysite.att.global_cacher r ZModelSerializerr rZ ZListModelMixinra r3 r3 r3 r4 s* J