B
cC @ s d dl m Z d dlmZ d dlmZmZ d dlmZ d dl m
Z
d dl m Z d dl m
Z
d dlmZmZ d d lmZ d d
lmZmZmZmZmZ d d lmZ d d lm Z m Z m Z m Z m Z d d
l!m"Z" d dl#m$Z$m%Z% G dd deZ&G dd deZ'dS ) )datetime) OrderedDict) gettext_lazyactivate)Response)action)status) serializers) DailyAttendanceReportViewSetDailyAttendanceSerializer) Transaction)temperature_updateget_real_colorget_mask_valueget_item_name_and_symbolget_item_symbols) PayloadBase)QCaseWhenValue TextField)
C_ATT_RULE) STATUS_VALIDSTATUS_RESIGN_PENDINGc @ s e Zd Ze ZejeddddZejeddddZejedddZ ejedddZ
ejedd dd
d Z G d d
d
Z dS ) DailyDetailsReportSerializerZreport_column_clockInTimeZget_clock_in_displayT)labelsource
allow_nullZreport_column_clockOutTimeZget_clock_out_display)r r Z report_column_attendance_statusattendance_status_ )r r r defaultc @ s e Zd ZeZdZdS )z!DailyDetailsReportSerializer.Meta)4emp_idZuuidZemp_codeZ
first_name last_nameZ nick_nameZgender dept_codeZ dept_nameZ
position_codeZ
position_nameatt_dateZweekdayZ
att_exceptionZ timetableZcheck_inZ check_outclock_in clock_outZ
total_timeZduty_wtZ actual_wtZ unscheduledZ total_workedZdurationZ
duty_durationZ break_outZbreak_inZbreak_durationZ actual_breakZ taken_breakZ
break_lateZ break_earlyZ break_absentZlateZ early_leaveabsentZwork_dayZ remainingZleaveZ normal_wtZ normal_otZ
weekend_otZ
holiday_otZot_lv1Zot_lv2Zot_lv3attendance_statusZ punch_setZtotal_ot clock_in_old
clock_out_oldN)__name__
__module__ __qualname__r ZmodelZfields r/ r/ FG:\easytimepro\master/mysite/att\api\views\view_report_dailydetails.pyMeta" s r1 N)
r, r- r. r Z CharFieldr" _r* r+ r& r' r) r1 r/ r/ r/ r0 r s
r c s e Zd ZeedZdd ZdddgZededed d
Z fd d Z d
d Z
dd Z dd Z e
dgdddd Zdd Zdd Zd d Zd#d d Zd$d!d"Z ZS )%DailyDetailsReportViewSet)listexportc C s t d tdS )NZenZdaily_details_report)r r2 )selfr/ r/ r0 get_file_title5 s z(DailyDetailsReportViewSet.get_file_titlein_tempout_tempdisplayed_maskZreport_column_in_tempZreport_column_out_tempZ report_column_displayed_mask)r8 r9 r: c s t t| }| jjj}| jjjs|j|d}| jjjs| jjj }| jjj
}i }| rd| |d< | rx| |d< |r|jf |}|
}tt|d}|dkr|ttdtd dB ttdB }|S )N)Zemp__company_idZemp__department__inZ
emp__area__in
resign_emp0)Z emp__status)superr3 get_querysetrequestusercurrent_companyZ is_employeefilterZ is_superuserZ
get_auth_deptZ
get_auth_areaexistsallZdistinctstrr getr r r )r6 queryset
company_idZ auth_deptZ auth_areafiltersr; ) __class__r/ r0 r> @ s(
z&DailyDetailsReportViewSet.get_querysetc C s* x"|D ]}|d rt jj|d |d d}| r|d }|j}|j}|j}t||}t||} t ||}
||d< | |d< |
|d< |d rt jj|d |d d} | r| d } | j}| j}
| j}t|
|}t|
|}t ||}
||d < ||d
< |
dd d krd |d< q|
d kr|
|d< qW |S )
Nr& r" )r" Z
punch_timer r8
in_temp_colorr: r' r9 out_temp_colorNoYes) r ZobjectsrB rC rH Z temperature mask_flagr
r r rF )r6 Z base_datadataZtrans_inZtran_inrH Z
celsius_inrO r8 Z
in_time_colorr: Z trans_outZtran_outZ celsius_outr9 Zout_time_colorr/ r/ r0 update_td_md_dataV s>
z+DailyDetailsReportViewSet.update_td_md_datac C s | j jj}| j}dttdddttd||dtdddttd||dtddtd d
td ttd ||d
tdttd||d
tdttd||d
tdtd dtdtd dtdttd||dtdttd||dtdttd||dtdttd||dtddttd||d tddttd ||d t d i}|j f |}x\|D ]T}|j
d kr\t |j j
|j j|j jd }t|j||| j}|ptd || j|_
q\W |S )!Nr FZ holiday_p)day_offclock_in__isnullclock_out__isnullthen Z weekdayoff_pr Zget_attendance_status)rS leave__gtrV rS )rS rV ZweekendZholiday)half_dayrV )rX rV r( )Z
absent__gtrV Zlate_in)Zlate__gtrV Z early_out)Zearly_leave__gtrV Zpresent)Zduty_worked__gtrV TZmiss_in)rT rU rV Zmiss_out)Z output_field)yearmonthdayrZ )r? r@ rA file_formatr r r r r Zannotater r r% r[ r\ r] r r" )r6 rG rH r^ valuesrP r% Zattendance_symbolr/ r/ r0 annotate_querysetw s:
z+DailyDetailsReportViewSet.annotate_querysetc O sj | | }| |}| |}|d k rR| j|dd}|j}| |}| |S | j|dd}t|jS )NT)many) Zfilter_querysetr> r` paginate_querysetget_serializerrP rQ Zget_paginated_responser )r6 r? argskwargsrG page
serializerrP r/ r/ r0 r4 s
z DailyDetailsReportViewSet.listrF F)methodsZdetailc
C s |j dd }|j ddd| _|j dd | _|j dd| _|j dd| _|j d d| _|j d
d| _|j d d| _ |j d d}|| _
| }| |}|d k r|
|}| j|d
d}n| j|d
d}|j d d}|j}| |}t|r|d ng } g }
x0| jD ]&} | | ks8| | jkr |
| q W | rT|
| _|dkrn| | j|} nd|dkr| || j|} nH|dkr| | j|} n.|dkr| | j|} nttdgtj d} | S )Nrf export_headersr ,Z export_style page_wiseF
start_dateend_datez
pdf-page-size orientation export_typeT)ra r ZcsvZxlsZtxtZpdf)ro zInvalid file format)r ) Z query_paramsrF splitri Zgroup_byrk rl rm Z
pdf_page_sizern r^ Zget_export_querysetr` rb rc rP rQ lenkeysexport_headers_proappendZ
export_to_csvZ
export_to_xlsZ
export_to_txtZ
export_to_pdfr r r ZHTTP_403_FORBIDDEN)
r6 r? rf r^ rG Z page_datarg rP Zserializer_dataZ data_fieldsZ headers_listheaderZresponser/ r/ r0 r5 sH
z DailyDetailsReportViewSet.exportc C s | dd |S )Nr zNo.)insert)r6 headersr/ r/ r0 update_export_headers s z/DailyDetailsReportViewSet.update_export_headersc C s |r| d | d |S )NrK rL )rt )r6 ri group_by_fieldr/ r/ r0 update_header_before_export s
z5DailyDetailsReportViewSet.update_header_before_exportc C s$ |dkr| dd |d= |d= |S )Nr$ r zNo.)rv )r6 rw ry r/ r/ r0 update_group_export_headers s
z5DailyDetailsReportViewSet.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 reportr% Nzzr8 zr9 rL r: rN z(YesrM z'Nor rY r ) enumerateri indexrE
isinstancer4 rv ) r6 datasri
extra_datairP att_date_index
in_temp_indexout_temp_indexdisplayed_mask_indexr r/ r/ r0 update_data_list sF
(
(
z*DailyDetailsReportViewSet.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 reportr% Nzzr8 rK zr9 rL r: rN z(YesrM z'Nor{ zit is sum field nowr r$ rY r ) r} ri r~ r r4 rE TypeErrorprintrv )r6 r ry r rP r vr r Zin_temp_color_indexr Zout_temp_color_indexr r er/ r/ r0 update_group_data_list s\
$ $
z0DailyDetailsReportViewSet.update_group_data_list)N)N)r, r- r. r Zserializer_dictr7 rs r2 Z extra_headers_translation_dictr> rQ r` r4 r r5 rx rz r| r r
__classcell__r/ r/ )rJ r0 r3 / s"
!"
+
1r3 N)(r collectionsr Zdjango.utils.translationr r2 r Zrest_framework.responser Zrest_framework.decoratorsr Zrest_frameworkr r Z0mysite.att.api.views.view_report_dailyattendancer
r Zmysite.iclock.modelsr Zmysite.att.utilsr
r r r r Zmysite.att.modelsr Zdjango.db.modelsr r r r r Zmysite.att.global_cacher Zmysite.admin.modelsr r r r3 r/ r/ r/ r0 s