B bU<!@sddlZddlZddlmZddlmZddlmZddl m Z ddl m Z dZ ddd d d d d dddddddddddddZdddddd d!d"d#d$d%d&d' Zddd d d d ddddddddddd(Zdd#d$d%d&d)Zd*d+d*d+d,d-d.d/d*d0 Zd1d2d3d1d4d5d6d7d8d9d:d;dd?d@dAdBdCdDdEdFdGdHdIdJdKdLdMdNdOdP ZdQdRZdSdTZdUdVZdWdXZdYdZZd[d\Zd]d^Zdid_d`ZdadbZdcddZdedfZdjdgdhZdS)kN) csrf_exempt) gettext_lazy)send_one_mail_with_attachments) file_upload) ReportParamz%Y-%m-%dz%Y/%m/%dz%Y.%m.%dz%d/%m/%Yz%d-%m-%Yz%m/%d/%Yz%m-%d-%Yz%y-%m-%dz%y/%m/%dz%d/%m/%yz%y.%m.%dz%Y%m%dz%Y%d%mz%m%d%Yz%d%m%Yz%y%m%dz%y%d%mz%m%d%yz%d%m%y)12345678910111213141516171819z%H:%Mz%I:%Mz%H:%M %pz%I:%M %pz%H:%M:%Sz%I:%M:%Sz %H:%M:%S %pz %I:%M:%S %pz%H%Mz%I%Mz%H%M%Sz%I%M%S) rrr r r r r rrrrr)0rr r r r rrrrrrrrrr)rrrrrZcheck_inZ check_outZ break_outZbreak_inZ overtime_inZ overtime_out) IOrrrr r r Z255ZPasswordZ Fingerprintz Employee IDZCardzFingerprint/PasswordzFingerprint/Cardz Password/CardzEmployee ID&FingerprintzFingerprint&PasswordzFingerprint&Cardz Password&CardzFingerprint&Password&Cardz Employee ID&Fingerprint&Passwordz Fingerprint & Card & Employee IDZFacezFace&Fingerprintz Face&Passwordz Face&CardzFace&Fingerprint&CardzFace&Fingerprint&Passwordz Finger VeinzFinger Vein&PasswordzFinger Vein&CardzFinger Vein&Password&CardZPalmz Palm&Cardz Palm&FacezPalm&FingerprintzPalm&Fingerprint&FaceZGPSZOther) rrrr r r r r rrrrrrrrrrrrZ20Z21Z22Z23Z24Z25Z26Z27Z28Z29Z101Z200cCs|r t|SdSdS)N)str)rvalparams company_idr#2G:\easytimepro\master/mysite/iclock\auto_export.py data_stringsr%cCs6|st|dkr.tt|}|r&|St|SdSdS)Nrr)rVERIFY_TYPE_MAPget)rr r!r" verify_typer#r#r$ format_verifysr)cCs\ddlm}|jt|d||d}|tt|dt|dt|i}|dS)Nr) C_ATT_RULE)r" func_keyskeyname)Zmysite.att.global_cacher*Z action_initrr'PUNCH_STATE_MAP)rr r!r"r*r+Z punch_valr#r#r$ format_punchs  (r/cCs<|r4|t|d}|t|d}|d|SdSdS)N short_date short_time r)strftime SHORT_DATE SHORT_TIME)rr r!r"val_dateval_timer#r#r$ format_dates  r8cCs"|r|t|d}|SdSdS)Nr0r)r3r4)rr r!r"r6r#r#r$format_short_datesr9cCs"|r|t|d}|SdSdS)Nr1r)r3r5)rr r!r"r7r#r#r$format_short_timesr:cCsJ|rBt|dd}|r<|t|kr<|t|d}||S|SndSdS)NZ pin_digitrrr)intr'len)rr r!r"Zmin_len_emp_codeZ zero_headr#r#r$format_emp_codesr=csddl}ddlm}tjdd}|d}|||}ddddd d d d d ddddd d dddfdd|D} t d| } fdd|D} g} | rt t t t ttd|dkrĈd}|dkr|jj ||jdd} n|jj ||jdd } ddr0t ddd} | j | d } d!r\t dd!d}| j |d"} | j| } | rx6| D].fd#dt| D}| |qrW| S)$Nr) Transaction data_templatez{\w+}Zemp_codeZemp__first_nameZemp__last_nameZemp__department__dept_codeZemp__department__dept_nameZ punch_timer(Z punch_stateZ work_codeZ emp__card_noZterminal__area__area_nameZterminal__aliasZ terminal_snZ temperatureZ mask_flag)z {emp_code}z {first_name}z {last_name}z {dept_code}z {dept_name}z {punch_time}z {verify_type}z {punch_state}z {work_code}z {card_number}z {area_name}z{terminal_alias}z {terminal_sn}z{date}z{time}z {temperature}z {mask_flag}csg|]}|dqS)N)r').0item)db_keysr#r$ sz$get_transactions..csg|]}|dr|qS)N)r')r@rA)rBr#r$rCs)z {verify_type}z {punch_time}z {emp_code}z{date}z{time}z {punch_state} query_fieldr)Zupload_time__gtZupload_time__lteemp__company_idZ upload_time)Zpunch_time__gtZpunch_time__lterEZ departments,)Zemp__department_id__inareas)Zterminal__area_id__incs0g|](\}}|t|jqSr#)r'r%r")r@iZdb_f)rBoptionr!rtransr#r$rCs)reZmysite.iclock.modelsr>jsonloadsr!r'compilefindallfilterr)r8r=r9r:r/objectsr"Zorder_bysplitvalues enumerateappend)startendrIrDrKr>r?_parammZ export_listZ export_keyspayloadZquerysetZdeptsrGtmpr#)rBrIr!rrJr$get_transactionssl              r\cCsddl}t|j}ddl}||}d}||}|} | d| | d| d|d} | d} | | | } t |}dd t|D} t ttt| }xLt|D]@\}}x6t|D]*\}}||||| |||||qWqW|dS) Nrr>ZArialcenterZvcenterr?z{\w+}cSsg|]\}}dd|DqS)cSsg|]}tt|ddqS))maxr<)r@rAr#r#r$rC/sz-generate_execl...r#)r@rHliner#r#r$rC/sz"generate_execl..)rKrLrMr! xlsxwriterZWorkbookZ add_worksheetZ add_formatZ set_font_nameZ set_borderZ set_alignrNrOlistrTmapr`zipwriteZ set_columnclose)data file_pathrIrKr!rbwbZ sheet_nameZwsZ cell_formatr?rXrYZwcellsZwcs row_indexrowZ col_indexcolr#r#r$generate_execls. %        rnc Csddl}t|j}|d}|d}|||}|rg}xdt|D]X\} } |} x$t|D]\} } | | | | } qZW| dddddd } || qDWd |}nd d |D}d |}t |d}| || WdQRXdS)Nrr?z{\w+}z\t z\r z\n rcSsg|]}d|qS)ro)join)r@rlr#r#r$rCIsz generate_csv..z w) rKrLrMr!rNrOrTreplacerUrropenrfrg)rhrirIrKr!r?rXrYrowsrkrlrow_datarHv full_datawfr#r#r$ generate_csv9s&       r{c Csddl}t|j}|d}|d}|||}|rg}xdt|D]X\} } |} x$t|D]\} } | | | | } qZW| dddddd } || qDWd |}nd d |D}d |}t |d}| || WdQRXdS)Nrr?z{\w+}z\troz\rrpz\nrqrcSsg|]}d|qS)ro)rr)r@rlr#r#r$rC`sz generate_txt..z rs) rKrLrMr!rNrOrTrtrUrrrurfrg)rhrirIrKr!r?rXrYrvrkrlrwrHrxryrzr#r#r$ generate_txtPs&       r|c$ Cs<ddlm}ddlm}ddlm}ddlm} ddlm } t ||||} t || rbt |j} n|} | dd} | dd }| d d}| d d}| d d }| dd}d}d}| ddkr| }n4| rtj| | }n|s|rtj| d}ndStj|st|tt| ddp*d}tt| ddpDd}|r\||}nd}|rr||}nd}d| d||}ytj|dj||d}|dkrt| ||n.|d krt| ||n|dkrt| ||tj|rv|rHddlm }m!}|}||j"dddd }t#dd|g|g|j"d!|||rf|d"krft$|||d#d$jt%| d%}Wn0t&k r} zd}t| }Wdd} ~ XYnXyT|s|j'j(|d&)}!|!s|j')}!d'}"||!|"||j*t||||d(+Wn4t&k r2} zddl,}#|#-Wdd} ~ XYnXt%| S))Nr)get_content_type_for_model)AdminLog)MyUser)tempDir)AutoExportTaskZ export_path export_formatZcsvZ export_email ftp_serverftp_path/user_idr:Z auto_export file_dater file_timez {0}{1}{2}Z file_prefixz{file}.{format})fileformat)ZxlsZxlsxZtxt)get_current_company_idset_current_company_idzauto export filez auto exportz Auto export)ZcontentfromZsubject)Z attachmentsr"z ----------)Zftp_idrirzExport: {total})total)idz Auto Export)useractionZcontent_type_idZ targets_repr description action_statusZop_time).Zdjango.contrib.admin.optionsr}Zmysite.base.modelsr~Zmysite.accounts.modelsrZ mysite.utilsrZmysite.base.models.auto_exportrr\ isinstancerLrMr!r'findospathrrexistsmakedirs FILE_DATEr FILE_TIMEr3rrnr{r|isfileZmysite.base.threadlocalsrrr"rrr< ExceptionrQrPfirstZpkZsave traceback print_exc)$Zdt_nowrVrWZtaskrDZrequestr}r~rrrrZr!rrZemailrrrrrZ save_pathrrZ_date_timefilenamerirrZtemp_current_company_idZbodyerrrr#r#r$transaction_auto_exportgs                       r)N)NN) rrLZdjango.views.decorators.csrfrZdjango.utils.translationr_Zmysite.admin.services.emailrZmysite.base.ftp_utilsrZ#mysite.att.models.model_reportparamrZautoexport_schedr4r5rrr.r&r%r)r/r8r9r:r=r\rnr{r|rr#r#r#r$s       >@