vg"&dZddlZddlZddlZddlmZddlmZmZmZddl m Z m Z ddl Z ddlmZddlmZddlmZdd lmZdd lmZmZdd lmZmZdd lmZmZmZdd l m!Z!ddl"m#Z#ddl$m%Z&ddl$m'Z(ddl)m*Z*ddl+m,Z,ddl-m.Z.ddl/m0Z0m1Z1m2Z2m3Z3m4Z4m5Z5m6Z6m7Z7m8Z8ddl9m:Z:m;Z;mZ>ddl?m@Z@mAZAmBZBmCZCmDZDmEZEddlFmGZGddlHmIZIddlJmKZKmLZLddlMddlNddlOddlPmQZQmRZRmSZSmTZTmUZUmVZVddlWddlXmYZYddlZm[Z[dZ\eBeEd d!Z]d"Z^eBeEd#d$Z_eBe@eCd#d%Z`eBe@eEd#d&ZaeBeEd'd(ZbeBeEd)d*ZceBe@eCd+d,Zdd-ZeeBe@eCd+dd.ZfeBeCd/d0ZgeBeCd/d1ZheBe@d2ZieBe@eCd3d4ZjeBe@eCd5d6ZkeBeCd3dd7ZleBeCd3d8ZmeBeCd3d9ZneBeCd3dd:ZoeBe@d;ZpeBe@eCd/d<ZqeBe@eCd=d>ZreBeCd?d@ZseBe@eCd?dAZteBe@eCd?dBZueBe@eCd=dCZveBe@eCdDdEZweBe@eCdFdGZxe*dHgeEdFdIZydJZzeBeCd=dKZ{eBdLZ|eBe@dMZ}eBe@eEdNdOZ~eBdPZeBe@dQZeBe@eEdRdSZeBe@eEdTdUZeBe@eEdTdVZeBeEdNdWZeBeEdNdXZeBe@dYZeBe@dZZeBe@d[ZeBd\ZeBe@d]ZeBd^ZeBe@d_ZeBe@d`ZeBeCd/daZeBdbZeBeEd5dcZeBddZeBdeZeBdfZeBdgZeBdhZeBdiZeBdjZeBe@dkZeBdlZeBe@dmZeBe@dnZeBe@doZeBe@edpZeBedqZeBe@edrZeBe@edsZeBdtZeBduZeBe*dHgeCd5dvZeBdwZeBdxZe*dHgeBdyZeBdzZeBd{ZeBe@d|ZeBe@eCd}d~ZeBe@dZeBe@dZeBe@dZeBe@dZeBe@dZeBdZeBe@dZeBeEddZeBeEddZeBe@dZeBdZejrdrddlWmZmZeBdZeBdZeBe@dZeBedZeBee@dZeBee@ddZeBee@eDdeddZeBee@eCddZeBee@eCddZeBee@dZeBee@dZeBee@dZejrdrdZeBeEddZeBdZeBdZeBdZeBdZy)z views.py N) defaultdict)datedatetime timedelta)parse_qsunquote)apps)messages) Paginator) transaction)ProtectedErrorQ) HttpResponse JsonResponse)get_object_or_404redirectrender)reverse force_str)gettext) gettext_lazy)require_http_methods) PenaltyFilter)PenaltyAccountForm) choosesubordinatesclosest_numbers eval_validate export_datafiltersubordinatesget_key_instancesget_paginationis_reportingmanagersortby) CompanyLeavesHolidaysPenaltyAccounts)Employee)hx_request_requiredloggerlogin_requiredmanager_can_enterowner_can_enterpermission_required)group_by_queryset)DYNAMIC_URL_PATTERNS)get_horilla_model_classremove_dynamic_url)*)attendance_dayscalculate_requested_dayscompany_leave_dates_list filter_conditional_leave_requestholiday_dates_listleave_requested_dates)LeaveMailSendThread)notifycn|D]D}|jD]/\}}||vr|j|||jd1F|jDcgc]\}}td|Ds|}}}|D]}||=tj||j }|j jdtjddddf}tdd|d d <tjd } |j| d d| jd} | jdd| jfd} ddlm} m} dt$j'| j| | t)jdScc}}w)zG Function used to generate error excle file for imported datas Nc3$K|]}|du ywN).0vs /var/www/horilla/leave/views.py z(generate_error_report..Os7QaT 7Qscolumnscy)Nztext-align: centerr?)xs rBz'generate_error_report..Us)subsetapplication/ms-excel content_typezattachment; filename=""Content-Disposition xlsxwriter)engineFSheet1)index sheet_namezA:ZctSr>)r2)request path_inforesponses rBget_error_sheetz.generate_error_report..get_error_sheet_s9%rIr)path urlpatternsz error-sheet-)namezleave/)itemsappendallpd DataFramekeysstyleapplymap IndexSlicer ExcelWriterto_excelsheets set_columnclose leave.urlsr[r\uuiduuid4r0) error_list error_data file_nameitemkeyvaluekeys_to_remove data_framestyled_data_framewriter worksheetrZr[r\rXrYs @@rBgenerate_error_reportrzDs#$**, #JCd{ T#Y' T"  ##)..0UC7Q57Q4QN sOj*//2CDJ"((11&r}}QT/B2)?@H(>yk&KH "# ^^H\ :FvUxH h'I # LLN-tzz|n-ItIYGH * $I 7s F1:F1zleave.add_leavetypec.t}|jdk(rnt|j|j}|j r>|j t j|tdttSt|dd|iS)z function used to create leave type. Parameters: request (HttpRequest): The HTTP request object. Returns: GET : return leave type creation template POST : return leave view POSTzNew leave type Created..z)leave/leave_type/leave_type_creation.htmlform) LeaveTypeFormmethodr|FILESis_validsaver success_rleave_type_viewr)rWr}s rBleave_type_creationrlss ?D~~W\\7==9 ==? IIK   Wa(B&C DO, , 'FQU WWrIcPt|t}|j|}|S)z- function used to paginate query set )r r"get_page)qryset page_number paginators rB paginator_qryrs(&."23I    ,F MrIzleave.view_leavetypec |tjjjd}tjj rFtjj j rtjj}|jjd}t||}|jj}t}tjt|jdd}|j!sd}nd}t#||||j$||dS) z function used to view leave type. Parameters: request (HttpRequest): The HTTP request object. Returns: GET : return leave type template T)is_compensatory_leavepageidflatz+leave/leave_type/leave_type_empty_view.htmlz%leave/leave_type/leave_type_view.html) leave_typesr}ra requests_ids) LeaveTypeobjectsr`excludeLeaveGeneralSettingfirstcompensatory_leaveGETgetr urlencodeLeaveTypeFilterjsondumpslist values_listexistsrr})rWquerysetrpage_obj previous_dataleave_type_filterr template_names rBrrs  $$&..T.JH##))+  ' ' - - / B B$$((*++//&)KX{3HKK))+M')::d8#7#74#7#HIJL ?? E ? #%**(    rIc&tj|}|jjd}|jjd}||d}|r3t j |}t ||\}}||d<||d<||d<t|d|S)z function used to view one leave type. Parameters: request (HttpRequest): The HTTP request object. Returns: GET : return one leave type view template instances_ids compensatory) leave_typerpreviousnextrz0leave/leave_type/leave_type_individual_view.html)rfindrrrloadsrr) rWrrrequests_ids_jsonrcontextr previous_idnext_ids rBleave_type_individual_viewrs#J 8;;??>2L'FGzz"34 .|R@ W) !"3 'Mw WWrIc tjj}|jj d}t |j|j }t||}|jj}tjt|jdd}t|}tt|t|d||||dS)z function used to filter view leave type. Parameters: request (HttpRequest): The HTTP request object. Returns: GET : return leave types template rrTrz!leave/leave_type/leave_types.html)rra filter_dictr)rrr`rrrqsrrrrrrrr!r)rWrrrrrr data_dicts rBrrs  $$&H++//&)K' X>AA. 2L"L7 ~~' LL'--*      NN    Wa(N&O PL) ) 1|4 !  " "M: >)w"8 9:(()s C""A D10D1zleave.delete_leavetypec , tjj|jt j |t d|j(jddk(r|j(jd d k(rx|j*jd }t-j.|}||vr|j1|t3t-j.||\}} t5d | d |St5d|j*j7St5t8S#tjttf$r#t j|t dY)t$r}t}|jD]0}|jt|j j"2dj%|}t j|t dj'|Yd}~d}~wwxYw)z function used to delete leave type. Parameters: request (HttpRequest): The HTTP request object. id : leave type id Returns: GET : return leave type view template rz!Leave type deleted successfully..Leave type not found.,z*This leave types are already in use for {}NHTTP_HX_REQUESTtrueHTTP_HX_TARGETobjectDetailsModalTargetrz"/leave/leave-type-individual-view/z?instances_ids=z/leave/type-filter?)rrrdeleter rrrrrrr setprotected_objectsadd___meta verbose_namejoinformatMETArrrremoverrrr) rWobj_idemodels_verbose_name_setsobjmodels_verbose_name_strrinstances_listprevious_instance next_instances rBleave_type_deleters (//1!$G"HI ||)*f4 <<  , -1K K#KKOOO =)60 , }4]O?SaRbc -gkk.C.C.E-FGHH O $$9  " "M: ><w"9 :;   #&5 && EC $ ( (CII,B,B)C D E#&**-E"F  <CC+    sA D88=H8HBHHleave.add_leaverequestcH|jjd}|jjdr(|jjddk(r tn t}|rat t |}t jj|jjdd}||jd_ n0t jj|jd_ td |d|jdd }t|S) N employee_idr}LeaveRequestUpdationFormr leave_type_idTrid__inz)leave/leave_request/leave_type_field.html)r} field_namefield)rrrLeaveRequestCreationFormrr(rrfilteravailable_leaverfieldsrnonerender_to_stringr)rWrr}employeeassigned_leave_typesleave_type_field_htmls rBget_employee_leave_typesrDs++//-0K ;;??6 " KKOOF #'A A !"& '  $X+>(0077++77d7S 8 1E O$-090A0A0F0F0H O$-,3)[[1  - ..rIcHtjj|}|jdjd}|jdjd}g}|D]}|j |j |j r ||||d}|Sd}|S)Nleave_request_idF is_approvedsequenceT)managersapproved requested approvals)LeaveRequestConditionApprovalrrorder_byr_ manager_idr)rrrequested_queryapproved_queryrmanagerresults rBmultiple_approvals_checkrds-55<window.location.reload();)zleave-request-and-approvez#leaveApproveCardBody/leave/request-filter?z #leaveRequestz+leave/leave_request/leave_request_form.html)r}rahx_url hx_target);rrsplitrr startswithrlencopypopruser employee_getrr`rrrrrrrrr|rrrrrequire_approvalrAvailableLeave created_byrequested_daysavailable_daysapproved_available_dayscarryforward_daysapproved_carryforward_daysstatusrrr_employee_user_id contextlibsuppress Exceptionr;sendr:startr rremployee_work_inforeporting_manager_idrr LeaveRequestrr)rWtype_idemp_idpart referer_partsr request_copyr}ravailable_leavesr initial_data leave_requestrrrrleaveconditional_requestsrr mail_threadleave_requestsreferrerr3r4s rBleave_request_creationr[wsu!)).9??DPR M{{))%0 5 5 78UF {{'')  $   Y '$..0 # %D<<,, '77;;= #,#4#4#;#;'33O$3O$<$ 5IDKK ( 16$! ( = gt-E FD~~' gmmD!'41IJ ==? IIUI3MD**;;tC+77 - ; ; "0"8"8"<"<"/[#=#,3<<+D+D (""$ ///2P2PP%447U7UU(66"967O2'99EA$5@EM<(669U9UU$2=J}?O?O>P%Q  2] !!#  !,R*ST((3 KK 11"/";";"N"N"c"c"t"t=m>W>W=XXYZ"RS`SlSlRmmn o"D]E^E^D__` a"I-JcJcIdde f"J=KdKdJeef g,!(!8T-BRBRAS;T!T  01 $7'(TUU)11557N>"a'#$OPP||3HSXXhnnS1!"566H345+ )# 5"    eJ  $  s$ WWAWB:WWWleave.view_leaverequestct|jjjdj }t |j }t ||d}|jjstjjdd}|Dcgc]}|jj}}|Dcgc]}|j|vs|j}}tjj|j }||z}jjd}t!||}t} |} g} t#j$dre| D]`} t'dd } | jj| j(| j*| j,g }|sP| j/| b|jd j1}t3j4t7|j8j;d d}|jd j1}|jd j1}|jj=}t?|}tAt|tC|d||| jD|||tFjH|tKjL|| d Scc}wcc}w)z function used to view leave request. Parameters: request (HttpRequest): The HTTP request object. Returns: GET : return leave request view template -idr\Fr is_rejectedrr recruitmentinterviewschedule app_labelmodelrinterview_date__rangerrDrTrr cancelledz%leave/leave_request/request_view.html) rYrar}requestsapproved_requestsrejected_requests gp_fieldsr current_daterleave_requests_with_interview)'LeaveRequestFilterrrrdistinctr7r r: is_superuserrrrrrrMrrr is_installedr1r start_dateend_dater_countrrr object_listrrrr!rr}LeaveRequestReGrouprrtoday)rWrmultiple_approvalsnormal_requestsmulti_approve_requests multi_idsrVrrleave_request_filterrYrorUInterviewSchedule interviewsrjrrkrlrrs rBleave_request_viewrs"'++.11::5AJJLH9'BKKM((!F!F!M!M5"N" AWWWW--00W W#2 UXXY5NEHH  '..55_5MVVX!33H++//&)KX{3H-/N$&! '+ DM!8'/B! +2299)55!,,!**':J-44]C! D$k288:H::d8#7#7#C#CDt#C#TUVL z:@@B {;AACKK))+M'IlI. /&(-- !2!2,33( JJL$-J  [X sKKKc|jjddk(r1t}t}||jd}t |d|St |tttdS)Nrr) excel_column export_filterz5leave/leave_request/leave_requests_export_filter.htmlrLeave_requestsrWre filter_class form_classrq)rrLeaveRequestExportFormrpr}rrrM)rWrrrs rBleave_requests_exportrXsu||)*f4-/ *, (*//    C  ')"  rIc |jj}t|jjj d}|}g}t j dre|D]`}tdd}|jj|j|j|jg}|sP|j|b|jjd}t|} t!||d}|j"j$st&jjdd } | Dcgc]}|j(j*} }|D cgc]} | j*| vs| j*}} t,jj| }|j/}| j/} || z}tj|j} |jjd }d }|jjd r t1|| d } |dk7r|t3| ||jjd d } | Dcgc]}|d }}g}|D].}|j4D]}|j|j*0t7j8t;|}d}n\t=| |jjd } t7j8| j4Dcgc]}|j*c}}g}|jjdst?|}tAt,|d|vr|d}tC|dkDr |dg|d<tE||| ||||jjd|tGjH|dScc}wcc} wcc}wcc}w)z function used to filter leave request. Parameters: request (HttpRequest): The HTTP request object. Returns: GET : return leave request view template r^rarbrcrfrr\Fr_rr)z'leave/leave_request/leave_requests.htmlr$r rz!leave/leave_request/group_by.html dashboardrDr/)rYrarrrrrnro)%rrrprrr rsr1rrrrtrur_rr7r r:rrrrrrMrqr$r/rwrrrrrr!r7rrry)rWrrrYrorUrrrrzr|r}rVr~rtemplateentry list_valuesid_listrtrrr status_lists rBr~r~qsKK))+M!'++.11::5AHN$&! '+ DM!8'/B! +2299)55!,,!**':J-44]C! D$ KKOOG $E9'B!'85NOH << $ $!>!F!F!M!M5"N" AWWWW--00W W+3Pehhi6OEHHPP ''..h.?  "H+446,,H-gkk8DGG++//&)K;H{{x %g/CXN {u(0 %)@& 3GGuV}G G  ,E!-- ,x{{+ , ,zz$w-0 6 - '++//&"9 zz)=)I)I JXX[[ J I ;;??; ']+ , 29) { a #.r?"3Ih  2$ 5( JJL-J   cXQ&H Ks5N1N6,N6 N;>Oleave.change_leaverequestcrtjj|}|j}|j}t |}|r|j j}tjj|jdd}||jddvr-|tjj|jz}||jd_ t||d}|jd k(rt |j |j"|}t||d}|j%rX|j'd }d}|rA|j't)j*|t-d t/j0t25t5j6|j8j:|jj<j>j@d |jdd|jdd|jdd|jdd|jddtCdd|jz dddtE|d||d} tG| jHjKddzStE|d||dS#1swYPxYw)z function used to update leave request. Parameters: request (HttpRequest): The HTTP request object. id : leave request id Returns: GET : return leave request update template POST : return leave request view rrrTrrrrr|Frz'Leave request is updated successfully..zLeave request updated for r'u+تم تحديث طلب الإجازة لـ u Urlaubsantrag aktualisiert für z&Solicitud de permiso actualizada para u$Demande de congé mise à jour pour rr+r,rNz,leave/leave_request/request_update_form.htmlr}rutf-8#)&rMrrrrrrr`rrrrrrrrr|rrrr rrrFrGrHr;rIr:r;rKrLrErrrcontentdecode) rWrrUrrr}rSrrrYs rBleave_request_updaters!((,,,3M!//M((H #] ;D#33779(0077#//d/K 8   4 @ @D @ Q Q#7):K:K:R:R ##;S;$ 1E O$- gt-E FD~~' LL'--- "'41IJ ==? IIUI3MD""$  !,U*VW((3 KK 11"/";";"N"N"c"c"t"t9-:S:S9TTUV"MmNgNgMhhi j"B=C\C\B]]^ _"HIbIbHccd e"F}G`G`Faab c,!(!8T-BRBRAS;T!T  "B!, $$$++G4;< 6  -  s $B:J--J6zleave.delete_leaverequestc|jj} tjj |}t j |td|j|jj dd}|dk(rGtjj}|j!rt#d|St%d St#t&S#tjttf$r"t j|tdYt$r"t j|tdYwxYw) z function used to delete leave request. Parameters: request (HttpRequest): The HTTP request object. id : leave request id Returns: GET : return leave request view template r$Leave request deleted successfully..Leave request not found.Related entries existsrN leaveRequestr2r.)rrrMrrr rrrrrrrr rr`rrrr)rWrrrUr4rYs rBleave_request_deleter,sKK))+M=$,,00B07 !$J"KL    !148IN"%--113  "4]ODE E LM M & ''  % %}j A?w"< => =w": ;<=sAC""=E !'E  E ctjj|}|j}|j}t jj||}|j |jz}|jdk7r||jk\r\|j|j kDrM|j|j z }|j |_ d|_|j|z |_||_ n1|j } | |jz |_|j|_ d|_|js$tt |;|jn|jj rTt"jj%|j'dtt |;|jna|j} | dD cgc]} | j(|jk(r| } } t"jj%| d| j+} d| _g}| dD]} |j/| j(t1|| j2kDrnt5j6t85t;j<|jj>|| j2d d d d ddd|j@ ddd| j| d| ddk(r"tt |;|jtCjD|tGdt5j6t85t;j<|jj>|jj(ddddddtIdd|j@z dddtK||d}|jMn9tCjN||dntCjN|tGd||}tQd |d!StS|jTjd"d!Scc} w#1swYxYw#1swYxYw)#a function used to approve a leave request. Parameters: request (HttpRequest): The HTTP request object. id : leave request id emp_id : employee id if the approval operation comes from "/employee/employee-view/{employee_id}/" template. Returns: GET : If `emp_id` is provided, it returns to the "/employee/employee-view/{employee_id}/" template after approval. Otherwise, it returns to the default leave request view template. rrrrrTrrrrrrrrrrrrNrz%Leave request approved successfully..z$Your Leave request has been approveduDتمت الموافقة على طلب الإجازة الخاص بكz!Ihr Urlaubsantrag wurde genehmigtz&Se ha aprobado su solicitud de permisou*Votre demande de congé a été approuvéeuser-request-viewr,approver#z5 dont have enough leave days to approve the request..zLeave request already approved/employee/employee-view/r r )+rMrrrrr=r@rBrDr?rArCrzsuperrr:rrrrupdaterErrr_r7rrFrGrHr;rIr;rr rrrr:rJrrHttpResponseRedirectr)rWrrOrUrrrtotal_available_leaverVtemprWrapprovercondition_approvalrrXs rBleave_request_approverMs  !((,,,3M++K!//M$,,00#1O &&)J)JJz) M$@$@ @++o.L.LL%447U7UU8G8V8V 512.#55= 1?FF - 9 9=;V;V '11HNN4D4I4I4KK ((#;<CC - 9 9=;V;V!((#45<< - 9 9=;V;V5" F D EE |/H/HI w*C(DE sF'G((=H)(H)c|jjd}|D]E}|r)tjj t |nd}t ||jGtdS)Nrrr.) r|rrMrrrleave_request_cancelrrrs rBleave_bulk_rejectrsk,,&&}5K!8 W>W+8+K+K+M((?@ = >>rIc^tjj|}|tj|j jdd}|j jd}|r3t j|}t||\}}||d<||d<||d<t|d|S) z function used to view one leave request. Parameters: request (HttpRequest): The HTTP request object. Returns: GET : return one leave request view template rr)rUrnrrrrrz)leave/leave_request/one_request_view.html) rMrrrryrrrrr)rWrrUrrrrrs rBone_request_viewr~s!((,,,3M& [[__[1G  8zz"34 .|R@ W) !"3 'F PPrIleave.add_availableleavect}t||d}tjj |j }|s/t j|tdt|d||dS|jdk(r|jr/t j|tdt|d||dSttt|j j#d}t%t&jj || j)dd }|j*r |j*nd }tt%||z }d }|rg} |D]} t'|| |j,} | j..|j0r"| j3| j4| | _|j6dk(r|s | j4}|| _t;| j<| j>zd | _ t;| j>d | _| jC| t&jjE| tG| }t jH|tdjK|t}tLjj |jOdd} | D cgc]G} tQjR|jTjV| jXddddddt[d I}} tG||k7r:t j|tdjKtG||z t|d||dScc} w)a  Assigns leave types to employees. Parameters: request (HttpRequest): The HTTP request object. obj_id: ID of the leave type. Returns: GET: Renders the leave type assignment form template. POST: Processes and assigns the leave type to selected employees. rrrz-leave/leave_assign/leave_assign_one_form.htmlrr|z4Compensatory leave type cannot be assigned manually.r)remployee_id__inTrNr)remployee_id_idr@) assigned_datercarryforward expirez1Successfully assigned leave type to {} employees.rrrE!New leave type is assigned to you/تم تعيين نوع إجازة جديد لكz+Ihnen wurde ein neuer Urlaubstyp zugewiesenz*Se le ha asignado un nuevo tipo de permiso0Un nouveau type de congé vous a été attribuérrrz=Leave type is already assigned to some selected {} employees.).LeaveOneAssignFormrrrrrr rrrrrrrmaprr|rrr=rcarryforward_expire_date total_days reset_dateresetset_reset_datercarryforward_type expired_datemaxr@rBtotal_leave_daysr_ bulk_creater7rrr(onlyr;rIr:r;rEr)rWrr}r employee_idsexisting_leaves_set expiry_date new_employeesassigned_countrSrrV employeesr notificationss rBleave_assign_onersb  D gt-G HD""))V)4::DDFO::gkkoootDEL1= f-<%} +.&!ZZ 5 G =w rIc *tjj}t}t ||d}t |j |j}|j j}|j jd}|j jd}d}|jd}|j jdrDt||d}tjt|dD cgc]} | jc} } |dk7rw|ut!|||} | D cgc]} | d  } } g}| D].}|j"D]} |j%| j0tjt'|} d }nCtjt|dD cgc]} | jc} } t||} t)|}t+t|t-||| ||||| d Scc} wcc} wcc} w) z function used to filter assign leave type to employees. Parameters: request (HttpRequest): The HTTP request object. Returns: GET : return leave type assigned view template rrr)z&leave/leave_assign/assigned_leave.htmlr^r$Nr rz leave/leave_assign/group_by.html)rSrarrrr)r=rr`rr rrrrrrr$rrrrr/rwr_rrr!r)rWrrassigned_leave_filterrrrrrSrrrrrrrtrs rBleave_assign_filterr^s%%))+H!#K!'85PQH/ XFIIKK))+M KKOOG $E++//&)K:H,55e<{{x !'+;XF"jj)67G)N OXX[[ O  {u($%5ukJ2:;uV}; ;  ,E!-- ,x{{+ , ,#jjg75"jj)67G)N OXX[[ O !!1;?'Ini0  ($    ' P< Ps>H0 H 1Hct}t||d}tjj dk(}|j dk(r[|j jd}|j jd}|r|rtjj|}tjj|}ttjj||jdd}g}t} t} |D]} |D]|} | j| jf} | |vrC|jt| | | j| j!| j"b| j!| j"~|rt%j&5tjj)|| D]_}t+j,t.5t1j2|j4j6|d d d d d dt9d dddat;j<|t?dddd| r7t;j@|t?djCtE| |r tGdStI|dd|iS#1swYxYw#1swYjxYw)z Function to assign multiple leave types to employees. Parameters: request (HttpRequest): The HTTP request object. Returns: GET: Render the leave assign form template. POST: Handle the leave type assignment. rrr|rrr)leave_type_id__inrrrr@rrz)Dir wurde ein neuer Urlaubstyp zugewiesenz*Se te ha asignado un nuevo tipo de permisorrrrNz"Leave types assigned successfully.z7Some leave types were already assigned to {} employees.r0z)leave/leave_assign/leave_assign_form.htmlr)%rrr=rrvrr|rrrr(rrrr_rrrEr atomicrrFrGrHr;rIr:r;rr rrrrr7rr)rWr} page_reloadleave_type_idsrrrexisting_assignmentsnew_assignmentssuccess_messages info_messagesrrassignment_keyuser_ids rB leave_assignr s  D gt-G HD ((..0A5K~~ --o>||++M: l#++22.2IK ((//|/DI#&&&--&4l.+o}=$ !O"u EM% E"- EJ&0mmX[[%AN%-AA'..*.8,4/9/D/D),,X-F-FG%))(*C*CD E E  '')W"**66G#3 '00; "KK ' 9 9*1%H(Y(S(T(Z%4)01D)E    $$Wa0T.UVW" OPWWM*  KL L <}d>S 3  WWs$3>J?1!> ??STD_EbEbDcctu-o.K.K-LL`aCODaDaCbbcd3O4Q4Q3RRgh($%89   7R}5   s BE99Fzleave.delete_availableleavec |jj} tjj |j t j|td|jj dx}r`tj|}t||\}}||vr|j|t!d|d|dtj"|Stjj%s t'd St!d |S#tj$r"t j|tdYt$r#t j|tdYwxYw) a Function to delete an assigned leave type of an employee. Parameters: - request (HttpRequest): The HTTP request object. - obj_id (int): Available leave ID. Returns: - Redirects to the assigned leave type view or refreshes the page. rz$Assigned leave successfully deleted.Assigned leave not found.zRelated entries exist.rz#/leave/available-leave-single-view/z/?z&instances_ids=r0z/leave/assign-filter?)rrr=rrrr rrrrr rrrrrrrr)rWrrarrrrs rBleave_assign_deletersM    B=""f"-446!$J"KL  88}8M2+:>6+R(= ^ #  ! !& )1-2$oVZV`V`aoVpUq r    ! ! ( ( *GHH +B40 11!  & &@w"= >? =w": ;<=sA D2E<'E<;E<r|c|jd}tj|}d}|D]8} tjj |}|j |dz }:tj|tdj|tdd iS#t$r)}tj|tdYd}~d}~wwxYw) z? This method is used to delete bulk of assigned leaves rrrr/rNz({} assigned leaves deleted successfully messageSuccess)r|rrr=rrrrHr rrrrr)rWrrvassigned_leave_idassigned_leavers rBleave_assign_bulk_deleter>s ,,u C **S/C E D D+3377;L7MN  ! ! # QJE D =>EEeL I. //  D NN7A&A$B C C Ds5B C(C  Cc ddg}tj|}td}d|d<|j|d |S#t$r}t|cYd }~Sd }~wwxYw) z Generate an empty Excel template for asisgn leave type to employee with predefined columns. Returns: HttpResponse: An HTTP response containing an empty Excel template with predefined columns. Employee Badge ID Leave TyperDrKrLz3attachment; filename="assign_leave_type_excel.xlsx"rOF)rSN)rarbrrhrH)_requestrErvrY exceptions rBassign_leave_type_excelrTsr '   \\'2 -CD A &' HE2 'I&&'s?A A  AA A c&ggggggd}|jdk(r|jd}tj|}|j d}t j jDcic]}|jj|}}tj jDcic]}|jj|}}tj jD cic]/} | jj| jjf| 1} } g} g} |D]U} | j!ddj#j}| j!ddj#j}|j!|}|j!|}g}||j%t'd ||j%t'd |r6d j)d |D| d |dvrdnd<| j%| |j|jf| vr!t'd| d<| j%| /| j%t|||j*X| rtj j-| d}| r t/| |d}t1|t1| z t1| t'd|d}t3d|}t5|Sycc}wcc}wcc} w)a  This function accepts a POST request containing an Excel file with assigned leave type to employee data. It processes the data, checks for errors, and either assigns leave types to employees or generates an error report in the form of an Excel file. )rrBadge ID ErrorLeave Type ErrorAssigned Errorz Other Errorsr|assign_leave_type_importrecordsrr rNzThis badge id does not exist.zThis leave type does not exist. c32K|]}t|ywr>r)r@rs rBrCz+assign_leave_type_import..sB%Yu-Bszbadge idrrrz5Leave type has already been assigned to the employee.r rzAssignLeaveError.xlsxzAssigned Leaves) created_count error_countrerXzimport_popup.html)rrra read_excelto_dictr(rr`badge_idlowerrr]r=rrrrstripr_rrrrrzr7rr)rWrpfilervassign_leave_dictsemprltralrSassign_leave_listro assign_leaver)assign_leave_typerrerrorsrXrhtmls rBr!r!ks  J~~}}78]]4( '// :;C:J:J:N:N:PQ3S\\'')3.Q Q5>5F5F5J5J5LMrrww}}*M M%,,002    ".."3"3 4b 8   .! L#''(;R@FFHNNPH , 0 0r B H H J P P R  }}X.H$):;JF a ?@A! a ABCHHB6BB(2fQi(?$EW!!,/ x{{+/??12K2 -.!!,/  $ $", (#-#8#8 7! H   " " . ./@ A -J(?I !!34s:Fz?()"    3W=D!!K RM s/"L3"L 74Lc|jjd}|r't}t}||d}t |d|St |t ttdS)Nr)r export_columnz3leave/leave_assign/assigned_leaves_export_form.htmlr Assign_Leaver)rrrAvailableLeaveColumnExportFormrrr=)rW hx_requestrr7rs rBassigned_leaves_exportr;sm!!"34J+- 68 **   A  (1  rIc|jjd}t}tjj ||j d_t|dd|iS)N department) department_id job_positionzleave/job_position_field.htmlr}) rrRestrictLeaveForm JobPositionrrrrr)rWr>r}s rBget_job_positionsrBs_KKOOL1M  D+6+>+>+E+E#,F,DKK( ':VTN KKrIzleave.add_restrictleavec |jj}|jdrt|t dd}n t|}t }|j dk(rt |j}|jrs|jt }tj|tdtjjj!dk(r t#dSt%|d||dS) z function used to create restricted days. Parameters: request (HttpRequest): The HTTP request object. Returns: GET : return restricted days creation form template POST : return restricted days view template r Nr|z%Restricted day created successfully..r/r.z!leave/restrict/restrict_form.htmlr}ra)rrr6rr7r@rr|rrr rr RestrictLeaverrrvrr)rW query_stringrr}s rBrestrict_creationrGs;;((*Lu% SZ\ :;  -  D~~ . ==? IIK$&D   Wa(O&P Q$$++-335:#$PQQ +]+ rIctjjddd}|jj }|jj d}t ||}t}t|d||j|dS)z function used to view restricted days. Parameters: request (HttpRequest): The HTTP request object. Returns: GET : return restricted days view template Nrrz!leave/restrict/view_restrict.html) restrictdayr}ra) rErr`rrrrRestrictLeaveFilterrr})rWrrrrrestrictday_filters rB restrict_viewrL s$$((*4R40HKK))+M++//&)KX{3H,. +#&++  rIctjj}|jj }t |j|j }|jjdr t||d}|jjd}t|ddd|}t|}tt|t|d|||dS)z function used to filter restricted days. Parameters: request (HttpRequest): The HTTP request object. Returns: GET : return restricted days view template r$rNrzleave/restrict/restrict.html)rIrar) rErr`rrrJrrr$rrr!r)rWrrrKrrrs rBrestrict_filterrN(s$$((*HKK))+M,W[[(CFF{{x #G-?J++//&)K/"5{CH'ImY/ & iP rIzleave.change_restrictleavec|jj}|jdrt|t dd}n t|}t j j|}t|}|jdk(rVt|j|}|jr/|jtj|tdt!|d|||dS) a function used to update restricted days. Parameters: request (HttpRequest): The HTTP request object. id : restricted days id Returns: GET : return restricted days update form template POST : return restricted days view template r Nrrr|z%Restricted day updated successfully..z(leave/restrict/restrict_update_form.htmlr )rrr6rr7rErrr@rr|rrr rrr)rWrrFrrIr}s rBrestrict_updaterPDs;;((*Lu% SZ\ :;  - ''++r+2K k 2D~~  D ==? IIK   Wa(O&P Q 2R}5 rIzleave.delete_restrictleavec|jj} tjj |j t j|tdtjjs tdStd|S#tj$r"t j|tdYkt$r"t j|tdYwxYw)z function used to delete restricted days. Parameters: request (HttpRequest): The HTTP request object. id : restricted days id Returns: GET : return restricted days view template rz%Restricted day deleted successfully..zRestricted day not found.rr./leave/restrict-filter?)rrrErrrr rrrrr rrr)rWrrFs rBrestrict_deleterSfs;;((*L=!!R!(//1!$K"LM  ' ' )HII -l^< ==  % %@w"= >? =w": ;<=sA B 2C>'C>=C>c |jj}|jdk(r|jj d} t j j|j}t|}tj|tdj|t#d|S#ttf$r"tj |tdY>tj |tdY`xYw)z function used to delete multiple restricted days. Parameters: request (HttpRequest): The HTTP request object. Returns: GET : return restricted days view template r|rrz-{} Leave restricted days deleted successfullyzRestricted Days not foundzSomething went wrongrR)rrrr|rrErrrr7r rrrrrrr)rWrarestrict_day_ids restrict_daysrvs rBrestrict_days_bulk_deleterWs    B~~"<<//6 ?)1188'9fh ()E   ABII%P  -bT2 33 z* D NN7A&A$B C ? NN7A&<$= >sA'B;;.D + D c|jjd}|dk(rtjj }Dcgc]}t |j }}t|}||d}t|Scc}w)Nrr`rU total_count) rrrErr`strrr7r)rWrrVdayrUrZrs rBrestrict_day_selectr]ss++//&)Ke%--113 /<=CFF ==&'K#3KPG   >sA<c|jjd}|jjd}|rtj|ni}|dk(rwt |t j j}|j}|Dcgc]}t|j}}|j}||d}t|Sycc}w)Nrrr`rrY) rrrrrJrErr`rr[rrvr) rWrfilteredfiltersrKrIrestrictday_idsrZrs rBrestrict_day_select_filterrcs++//&)K{{x(H&.djj"BGe0 m33779 022BTU;3{~~.UU(..0 '6{SG$$ VsC c !t|jjtdd}|jj }t jj|}t||d}|jdk(rt|j|j|}tj|jjdd }tj|jjd d }|jjd }|jjd } tjj||} | j | j"z} t%|||| } t'||} | Dcgc]}|j(} }t*jj-}t/|}t0jj-}t3|| |j4d k(r@|j6d k(r1t9t;| z!t=!fd| D}| |z } nOd}|j6d k(r| D] }||vs|dz }| |z } |j4d k(rt= fd| D}| |z } t>jjA|||jCddg}|jEr|jGdtIdnr|jJr| | krE|jMr"|jOd}d}||_(||_)|jPjTdk(r|jR}|jP}tjj||} |jV| j kDrM|jV| j z }| j |_,d| _| j"|z | _||_-n/| j |jVz | _|jV|_,d|_.| jO|r||_/|jOta|jbrta|jb}g}|dD]}|je|jftijjtl5tojp|jj |dddd d!d"d#d$|jb% dddts||d&'}|jutwjx|tId(tijjtl5tojp|jj |jRjzj|jfddd d!d"d#td)d*|jbz% dddtt>jjA|+dk(s*|jjd,jd-r td.St|d/||||d0S|jGdtId1t jjA||jd2_Et|d/||||d0Scc}w#1swYxYw#1swYxYw)3a function used to create user leave request. Parameters: request (HttpRequest): The HTTP request object. id : leave type id Returns: GET : return user leave request creation form template POST : user my leave view template r Nrrrrr|rrt%Y-%m-%drustart_date_breakdownend_date_breakdownyesc3&K|]}|v ywr>r?r@requested_date total_leavess rBrCz%user_leave_request..s$3A,.$rr/c3&K|]}|v ywr>r?r@rmcompany_leave_datess rBrCz%user_leave_request..s*&#&99*ro)rstart_date__lte end_date__gterir) status__inz6There is already a leave request for this date range..FrTrrrrrrrrrrrrrWr#r%r+r,rr zemployee-profile/r.z'leave/user_leave/user_request_form.html)r}rrra5You dont have enough leave days to make the request..r)Frrrr7r:r;rrrUserLeaveRequestFormrr|rrstrptimer=r@rBr5r9rr&r`r8r%r6exclude_company_leaveexclude_holidayrrsumrMrrr add_errorr limit_leaverrrrr<r?rArCrDr>rrr_rErFrGrHr;rIr:rJr rrKrLrrendswithrrrr)"rWrrrrr}rtrurhriravailable_total_leaver?requested_datesrholidays holiday_datescompany_leavestotal_leave_count holiday_countrmcompany_leave_countoverlapping_requestsrUrrrrVrWrrrXrrrns" @@rBuser_leave_requestrsGKK1134SZ\BM||((H""&&"&-J  (:F D~~#GLL'--(S&&w||'7'7 'EzR $$W\\%5%5j%A:N&||//0FG$\\--.BC(0044 5   * *_-N-N N 2 "68J 0 HE3BC49499;CC##'')*84 &..2246~zR  , , 5**e3M4G$G HIL #$ET$! ,.??NM))U2&5+N%6%* +"0-!?//58&)**9*'#"02E!E+33:: (* ; 'k:6' 7  & & ( NNaPQ ''>=R+R}} $  7 .8 +,4 ) ..??4G"/";";K$1$?$?M&4&<&<&@&@&3'A'O%33o6T6TT)88-<<= ,::&=:;6+==E(9DI @,::+::;(6 *88&=,6M(#((*/7M,!&&(/ 0@0@A/G),,0,$&';J'GFG$OOG,D,DEF'00; "KK ' 9 9*21+%P(i(](`(^%4+B=CSCSBT)U  #6Y#K %%'$$Wa0V.WX#,,Y7  #LL55&3&?&?&R&R&g&g&x&x!L$e$Y$\$Z!0%,^%< $]%5%5$67&8  $,,333I%ll..~>GG+ ,H 9 ",'    NNaOP -6,=,=,D,D,D,KDKK ) 1$    QDd  "  s Z7AZ<)A4[ <[ [c|jj}tjj |} |j j |jk(r|jdk7rot|j|}|jdk(r7t|j|j||j}|jr|jd}|j}|j }|j"}|j$}|j&} |j j } t(jj | | } | j*| j,z} t/||||} t1||}t2jj5}t7|}t8jj5}t;||| j<d k(r@| j>d k(r1tAtC|ztEfd |D}| |z } nOd }| j>d k(r|D] }||vs|d z }| |z } | j<d k(rtEfd |D}| |z } | | kr0|jtGjH|tKdn|jMdtKdtO|d|||dStGjP|tKdtSdS#tT$r)}tGjP|tKdYd}~nd}~wwxYwtO|d||dS)a function used to update user leave request. Parameters: request (HttpRequest): The HTTP request object. id : leave request id Returns: GET : return user leave request update form template POST : return user leave request view template rr)rrr|)rrFrrerjc3&K|]}|v ywr>r?rls rBrCz&user_request_update..s0 .+l:0rorr/c3&K|]}|v ywr>r?rqs rBrCz&user_request_update..s6$2!/2E E6roz$Leave request updated successfully..Nrwz)leave/user_leave/user_request_update.htmlr z&You can't update this leave request...r.User has no leave request..)+rrrMrrr:r;rrDrxrr|rrrrtrurhrirr=r@rBr5r9r&r`r8r%r6rzr{rrr|r rrr}rrrrH)rWrrrUr}rtrurhrirrrrr?rrrrrrrmrrrrrns @@rBuser_request_updaterwsOKK))+M ((,,,3MWB LL % %)B)B B$$ 2'&22]D~~'+LLMM**66  ==?$(IIUI$;M!.!9!9J,55H+8+M+M()6)I)I&!.!"H.BDV&N'%>%@N*B& +'#88EA&66%?'+C @S0S,T'U ,/02A0-)*8:K)K() %55>2A7#1]#B$1Q$6M7.Q-QN%)>>%**, ((#Q'M%N UV; '  NN7A&N$O P LM M Bw"? @AAB 3  s%H L BL !)L L=L88L=cx|jj} tjj |}|j j |jk(r/tj|td|jtjj|j j s t!dSt#d|S#tj$r"tj|tdYt$r"tj|tdYwxYw)z function used to delete user leave request. Parameters: request (HttpRequest): The HTTP request object. id : leave request id Returns: GET : return user leave request view template rrrrrvr.z/leave/user-request-filter?)rrrMrrr:r;rr rrrrrr rrr)rWrrrUs rBuser_request_deletersKK))+M=$,,00B07 << $ $ (A(A A   Wa(N&O P  "    & &7<<3L3L & MHII5m_EFF  $ $Bw"? @A =w": ;<=sA2C2D9'D98D9c |jj}|jj}|jj }|jj d}t||}t}|jsd}nd}t||||j|dS#t$r-tj|tdt!dcYSwxYw)z function used to view user assigned leave types. Parameters: request (HttpRequest): The HTTP request object. Returns: GET : return user assigned leave types view template rz+leave/user_leave/user_leave_empty_view.htmlz%leave/user_leave/user_leave_view.html) user_leavesr}raUser is not an employee..r )r:r;rr`rrrrrrrr}rHr rrr)rWrrrrrrrs rBuser_leave_viewr s<<,,++//1 --/ kkoof-  ;7 3 5 IMCM  '-22#    w"= >?}sB*B--3C#"C#c |jj}|jj}|jj }|jj d}t|j|j}t|}tt|t||}t|d|||dS#t$r4}tj |t#dt%dcYd}~Sd}~wwxYw)z function used to filter user assigned leave types. Parameters: request (HttpRequest): The HTTP request object. Returns: GET : return user assigned leave types view template rz leave/user_leave/user_leave.html)rrarrr N)r:r;rr`rrrrrrr!r=rrrHr rrr) rWrrrrrrrrs rBuser_leave_filterr+ s<<,,++//1 --/ kkoof- 3GKK J M M]+ .)4 !6 D  .$M) T  w"= >?}sB 188G! H$5W[[8T !4!7!7!@!@!GUjj %%11$T1B C $++22tww2GOO15P  ' ' - - /#++113FF'//664776KJzz|   5"*+00# ,299*)1N    w"= >?}s%CIE3I J)I>8J>Jc  |jj}|jjj d}|j j }|j jd}|j jd}|}g}tjdre|D]`}tdd} | jj|j|j|jg} | sP|j!|bt#||d}t%|j |j&} d } |d k7r|t)| ||j jdd} | D cgc]} | d  }} g}|D].}|j*D]}|j!|j,0t/j0t3|}d } n\t5| |j jd} t/j0| j*Dcgc]}|j,c}}t7|}t9t:|d|vr|d}t=|dkDr |dg|d<t>jj|j,}| |||tAjB|||d}tE|| |Scc} wcc}w#tF$r4}tIjJ|tMdtOdcYd }~Sd }~wwxYw)z function used to filter user leave request. Parameters: request (HttpRequest): The HTTP request object. Returns: GET : return user leave request view template r^rrrarbrcrfr$)z#leave/user_leave/user_requests.htmlr Nrzleave/user_leave/group_by.htmlrDr/rrv)rYrarrrnrrrorrr )(r:r;rr`rrrrr rsr1rrrrtrur_r$rrr/rwrrrrrrr!rMr7r=rryrrHr rrr)rWr:rrrrrYrorUrrrrrrrrtrrrrrrrs rBrr sN||((((,,.77> --/ kkoof-  ("(*%   ] +!/ H %<+3F%!/66== - 9 9%00%..+> 188G! H$'8X64W[[(KNN; B;5,"3#UGKKOOF,CV# 7JJU5=JKJG$ 0 % 1 10HNN8;;/0 0 ::d7m4L7H#0#W[[__V%<#  ::-@-L-LMML]+ , 2 y #H-K;!#'22&7 (##++22tww2G 2$ JJL'%-J  gx99IKN. w"= >?}sEC9K )B-'B2-B2ctjd}t|jdd}t j }t |d|||dS)z function used to view employees are leave today. Parameters: request (HttpRequest): The HTTP request object. Returns: GET : return Json response of employee rrhrTrzleave/on_leave.html)leavesrtoday_holidays)rMemployees_on_leave_todayrrr&rr)rWrrrs rBemployee_leaver s` 2 2* 2 EF**4d*;F8$$\288:DL$ ]]q])22:> JJ X%8%8U[[%QRS%T (:  G '17 ;;rIctj}tjj |j }t jj|}|jd}|jd}|jd}tjj|}|jr|jdjnd }|||||d d } t|d | S) z function used to view Employee dashboard in the leave module. Parameters: request (HttpRequest): The HTTP request object. Returns: GET : return Employee dasboard template. rErvrrhrrrrtNr)rYrrrrrzleave/employee_dashboard.html) rryr(rrr:rMrr&rrrr) rWryr:rYrrrrrrs rBemployee_dashboardrk s JJLE       >D!))00T0BN%%[%9I$$J$7H$$J$7H&&u&=H3;??3D,'--/$ )$ G ':G DDrIcg}tj}|jjd}|jj }t jj|}|r>tj|d}|j|j|j}n'|j|j|j}|Dcgc]}|j}}|d|d}td|Scc}w)z function used to view leave request table. Parameters: request (HttpRequest): The HTTP request object. Returns: GET : return leave requests table. rrv%Y-%mrstart_date__yearr)rYrrz1leave/leave_request/dashboard_leave_requests.html)rryrrr:r;rMrrrryrrrr)rWrryr\rrYrs rBdashboard_leave_requestr sL JJLE ++//& !C||((H!))00X0FN W-'..!ii#((/ (..#kkEJJ/ /==7GJJ=L=( $G 'NPW XX >sC;ctjj|j}tjj |j d}g}g}|D]O}|j|j|jz|j|jjQtd|dg}||tdd}t|S) z function used to generate available leave chart in employee dashboard. Parameters: request (HttpRequest): The HTTP request object. Returns: GET : return Json response of labels, dataset, message. rrvr)r@zTotal leaves availablelabelrz0Oops!! No leaves available for you this month...rdatasetr)r(rrr:r=rrr_r@rBrr]rr)rWr:rS leave_countrrVrrYs rBavailable_leave_chartr s       >D%--444FNNOK F!05//%2I2IIJ e))../0 /0 GGHH  !!rIc tj}|jjdr1|jjd}t j |d}t jjdd}|j|j|j}|jdd}g}g}|j|j|jD]}|j|jtt|D]}|j|gd tt|}t!d }|D]i} |j| |j|j } | D]:} || j"j$| xxt'| j(d z cc<<k|D] } | d } |D cgc] } || |  c} | d<"g}tt|D],}|j|j*d|j,.||t/dd}t1|Scc} w)z function used to generate employee leave chart in Admin dashboard. Parameters: request (HttpRequest): The HTTP request object. Returns: GET : return Json response of labels, dataset, message. rrTr)employee_id__is_activerDrleave_type_id__namerrc ttSr>)rfloatr?rIrBrHz&employee_leave_chart.. s E0BrI)rrrrrr#zNo leave request this monthr)rryrrrryrMrrrrrr_rrrrrr]roundr?employee_first_nameemployee_last_namerr)rWr\rYrrrrrtotal_leave_with_typerrrVr dataset_labelemployee_labelrYs rBemployee_leave_chartr s^ **,C{{vkkoof%W-!))00#J1N$**))chh+N!,,-B,NK FG"))))chh*,  h**+, 3{+, #   #f+ F'(BC&&SXX'  E !%"5"5":": ;E Be$$aG  B  YW QWX-mr?r^rvaluesrr)rWr\rdepdepartment_countsrU leave_datesrrV leave_dater=rvrrtrrYs rBdepartment_leave_chartr s **,C{{vkkoof%W-$$((*K6ABs*BB ((//z/BM!(())chh)MK FJ//1 @J   z22:> ? @ JCe''::HHH!#..1U5I5II1 J J/446& E A: MM* %&#**, -F!' 65A:e 6F 6rU G89H  !!?C&7sG28 G7G7cJtj}|jjdr1|jjd}t j |d}t jj}|Dcic]}|jd}}tjjd}|j|j|j}|D]:}|D]3}||jk(s||jxx|jz cc<5<g}|j!D]\} } | dk7s |j#| t%|j'} | D cgc] } | dk7s |  } } |d| igt)dd } t+| Scc}wcc} w) z function used to generate leave type chart in Admin dashboard. Parameters: request (HttpRequest): The HTTP request object. Returns: GET : return Json response of labels, dataset. rrrrrhrrz0No leave requests for any leave type this month.r)rryrrrryrrr`r]rMrrrrr?r^r_rrrr)rWr\rtypesleave_type_countrUrVlevrrrvrrtrYs rBleave_type_chartrM s **,C{{vkkoof%W-##'')K3>?% A ?? ((//z/BM!(())chh)MC CCe))) *e.B.BB* CC F-335& E A: MM* %&"))+ ,F!' 65A:e 6F 6  GHH  !!7@ 7sF- F 8F ctj}|t|jz }t dDcgc]}|t|z}}g}t j jd}g}|D](}|jD]} |j| *|D cgc]6} | j|jk(r| j|jk(r| 8} } |D]<} g} | D]}|| k(s | j||jt| >td|df}|D cgc]} | jd}} ||d}t|Scc}wcc} wcc} w) z function used to generate leave over a week chart in Admin dashboard. Parameters: request (HttpRequest): The HTTP request object. Returns: GET : return Json response of labels, dataset. daysrrhz Leave Trendsrz%d-%m-%Y)rr)rryrweekdayrangerMrrrr_rrr7rrr)rWry start_of_weeki week_dates leave_in_weekrUrrVrr\filtered_dates week_dater filtered_daterrrYs rBleave_over_periodr| s JJLEI5==?;;M=B1XF-)"33FJFM ((//z/BMK+//1 +J   z * ++   99 #EJJ(> N  ( + +M ) M* + SY' (~&! G?I Ii  , IF IH  !!GG&JsE',;E,=E1cH t|jjtdd}|jj }|j }t|}|jdk(r t|j|j|}t|jdt|k(rq|jrP|jd}d}|jj d k(r|j"}|j}t$j&j)|| } |j*| j,kDrM|j*| j,z } | j,|_d | _| j0| z | _| |_n/| j,|j*z | _|j*|_d |_| j|r;|jj |_|jt9|j rt9|j } g} | d D]} | j;| j<t?j@tB5tEjF|jj | d ddddddd|j  dddtIjJ|tMdt?j@tB5tEjF|jj |j"jNjPj<d|j"dd|j"dd|j"dd|j"dd|j"ddtSdd|j z dddtU||d !}|jWt|}ttXj&j[|"d#k(r t]d$St_|d%||d&StIj`|tMd't_|d%d(|i}t]|jbjed)d*zSt_|d%||d&S#1swYxYw#1swYxYw)+z function used to create leave request from calendar. Parameters: request (HttpRequest): The HTTP request object. Returns: GET : return leave request form template POST : return leave request view r Nrfr|rFrTrrrrrrrrrrrrrr%r&r'r(uNeuer Urlaubsantrag für z erstellt.r)r*r+r,rWr#rvr/r.z"leave/user_leave/request_form.htmlrDYou don't have permissionr}rr)3rrrr7r:r;rUserLeaveRequestCreationFormrr|rrrrrrr<rr=rrr?r@rArBrCrDr>rr_rErFrGrHr;rIr rrrKrLrr:rJrMrrrrrr)rWrr.rOr}rUrrrrrVrWrrrXrYs rBleave_request_creater shGKK1134SZ\BM ,, # #C VVF ' 5D~~+GLL'--RUV tyy' (CK 7}} $  7  ..??4G"/";";K$1$?$?M&4&<&<&@&@&3'A'O%33o6T6TT)88-<<= ,::&=:;6+==E(9DI @,::+::;(6 *88&=,6M(#((*/6||/H/HM,!&&(/ 0@0@A/G),,0,$&';J'GFG$OOG,D,DEF'00; "KK ' 9 9*21+%P(i(](`(^%4+B=CSCSBT)U  $$Wa0V.WX#,,Y7  #LL55&3&?&?&R&R&g&g&x&x#A-B[B[A\\]!^&VWdWpWpVqqr$s&? @Y@Y?ZZd$e&MmNgNgMhhi$j&N}OhOhNiij$k!0%,^%< $]%5%5$67&8  #6Y#K %%'7ED<//6666JKqP+H 4 '  NN7A&A$B C=~H   ''03XX  ,  k    s0AR 3B:R RR!c |jj}tjj j d}t |j|j}t||d}|jjd}t||}tjt|jj!dd}tjj#|j$j d}t |j|j}|jjd}t||}tjt|jj!dd}t } |jj'} t)| } t+t| } ||| | j,| t.j0||d } t3|d | S) z function used to view leave allocation request. Parameters: request (HttpRequest): The HTTP request object. Returns: GET : return leave allocation request view template r^!leave.view_leaveallocationrequestrrTrrvm_page)leave_allocation_requestsmy_leave_allocation_requestsrar}rrmrmy_requests_idszAleave/leave_allocation_request/leave_allocation_request_view.htmlr)r:r;LeaveAllocationRequestrr`rLeaveAllocationRequestFilterrrr rrrrrrwrrrrrr!r}LeaveAllocationRequestReGrouprr) rWrrrrrrmy_page_numberrleave_allocation_request_filterrrrs rBleave_allocation_request_viewr/ s||((H%--113<H++//&)K -h D:: & 2 2 > >t$ > OPL$:#A#A#H#HKK$I$huo!$@ 1$b![[__X.N#0$n$ jj ) 5 5 A A$T A RSO'C&D#KK))+M'I!"8)DI%>(D/44 299$* G K rIcRd}|jjddk(rd}|jjd}|r$tj|}t ||\}}t j |}||||jjdd}t|d| S) z function used to present the leave allocation request detailed view. Parameters: request (HttpRequest): The HTTP request object. req_id : leave allocation request id Returns: return leave allocation request single view F my_requestTrueTrr)leave_allocation_requestrrrrrzHleave/leave_allocation_request/leave_allocation_request_single_view.htmlr)rrrrrrrr) rWreq_idrrrrrrrs rB$leave_allocation_request_single_viewrg sJ{{|$.  8zz"34 .|VD W5::6B$< *[[__[1 G R rIc|jj}td|i}t||d}|jdj t jj|jz|jd_|jdk(rt|j|j}|jrY|jd}d|_|jtj |t#dt%j&t(5t+j,|jj|j.j0j2j4d |j.d d |j.d d |j.d d |j.d d|j.d dt7dd|j8z dddt;|dd|i}t=|j>jAddzSd|i}t;|d|S#1swYQxYw)z function used to create leave allocation request. Parameters: request (HttpRequest): The HTTP request object. Returns: GET : return leave allocation request form template POST : return leave allocation request view rr leave.add_leaveallocationrequestrr|Frz'New Leave allocation request is createdz)New leave allocation request created for r'u;تم إنشاء طلب تخصيص إجازة جديد لـ u0Neue Anfrage zur Urlaubszuweisung erstellt für u7Nueva solicitud de asignación de permisos creada para u5Nouvelle demande d'allocation de congé créée pour people-cicleleave-allocation-request-viewr,rNzCleave/leave_allocation_request/leave_allocation_request_create.htmlr}r$r)!r:r;LeaveAllocationRequestFormrrrr(rrrr|rrr skip_historyr rrrFrGrHr;rIrrKrLrErrrrrr)rWrr}rrYrs rBleave_allocation_request_creater s)||((H %}h.G HD gt-O PD*.+++h!!((',,(G+HDKK '~~)',, F ==?'+yyy'> $49 $ 1 $ ) ) +   Wa(Q&R S$$Y/  LL--6BBUUjj{{DE]EiEiDjjklYZrZ~Z~Y@ABNOgOsOsNttuvUVnVzVzU{{|}STlTxTxSyyz{'$%DE5889:;  UH    ''089 tnG M /  s *B:H44H=c|jjd}|jj}|jjd}|jjd}|jj }d}t |jj jd}tjj|jjd}t |j|j }t||d}|jjdr t||d}|rt|||d} t|||d} | D cgc]} | d  } } | D cgc]} | jD]}|j!}} }t!j"t%|}| D cgc]} | d  } } | D cgc]} | jD]}|j!}} }t!j"t%|}d }nt'||} t'||} t!j"t%| jj)d d }t!j"t%| jj)d d }t+|}t-t|}|j/dd| | |||||d}t1|||Scc} wcc}} wcc} wcc}} w)NrrrzAleave/leave_allocation_request/leave_allocation_request_list.htmlr^rvrr$rEleave/leave_allocation_request/leave_allocation_request_group_by.htmlrTr)rrrarrrrr)rrr:r;rrrrrrrrr r$r/rwrrrrrrr!r9r)rWrrrrrr"leave_allocation_requests_filtered%my_leave_allocation_requests_filteredrrrrrtrrrrrrs rBrr s KKOOG $E||((H++//&)K[[__X.NKK))+MRH*F *b%'-C,J,J,Q,QKK-R-huo*-I :-b**<35X*& {{x -3 7. *  $5 .{F% !(9 15.(( $ 3LLuV}L L%0 !ARAR 5=HKK   zz$w-0 2NOuV}O O%0 !ARAR 5=HKK   **T']3 S %2 . % !(5 1>( $zz *66BB4dBS T ** -99EEdQUEV W  'I!"8)DI MM(D!&?(D $*G '8W 55UM P s" K(5$K-> K3$K8ctjj|}t|}t ||d}|j dj tjj|jz|j d_|jdk7r|jdk(rt|j|j|}|jrZ|jd }d|_|jt#j$|t'd t)j*t,5t/j0|jj2|j4j6j8j:d |j4d d |j4d d|j4d d|j4d d|j4d dt=dd|j>z dddtA|d||d}tC|jDjGddzStA|d||dSt#jH|t'dtCdS#1swYzxYw)a! function used to update leave allocation request. Parameters: request (HttpRequest): The HTTP request object. req_id : leave allocation request id Returns: GET : return leave allocation request update template POST : return leave allocation request view rrr rrrr|Frz1Leave allocation request is updated successfully.z%Leave allocation request updated for r'u6تم تحديث طلب تخصيص الإجازة لـ u/Urlaubszuteilungsanforderung aktualisiert für u6Solicitud de asignación de licencia actualizada para u1Demande d'allocation de congé mise à jour pour r r r,rNzCleave/leave_allocation_request/leave_allocation_request_update.htmlr}rrr z You can't update this request...r.)%rrrrrrrr(rr:rDrr|rrrrr rrrFrGrHr;rIr;rrKrLrErrrrrrr)rWrrr}rYs rBleave_allocation_request_updater si 6==AAVAL %/G HD gt-O PD*.+++h!!((',,(G+HDKK ' &&*4 >>V #- gmm6ND}}+/99E9+B(8=(5(--/  QRS ((3 KK 11":"F"F"Y"Y"n"n""DE]EiEiDjjkl"XYqY}Y}X~~!A"QRjRvRvQwwx y"XYqY}Y}X~~!A"STlTxTxSyyz {+!()H!I !9!"?  "Y!V4 $$$++G4<=  QV ,  w"D EFHII;  s B:I77Jc tjj|}|jdk(r|j}|j j j|jjrC|j j j|jj}nt|j|}|xj|jz c_ |jd|_|jtj |t#dt%j&t(5t+j,|j.j0|jj2ddd d d d t5d d|j6z dddntj8|t#dt;|j<jddS#1swY.xYw)a function used to approve a leave allocation request. Parameters: request (HttpRequest): The HTTP request object. req_id : leave allocation request id Returns: GET :It returns to the default leave allocation request view template. rr)rrrz.Leave allocation request approved successfullyz/Your leave allocation request has been approvedu=تمت الموافقة على طلب تخصيص إجازتكz/Ihr Antrag auf Urlaubszuweisung wurde genehmigtu8Se ha aprobado su solicitud de asignación de vacacionesu7Votre demande d'allocation de congé a été approuvéerr r,rNz.The leave allocation request can't be approvedr r )rrrrDrrr`rrrrr=r@r?rr rrrFrGrHr;rIr:r;rErrrrr)rWrrrrs rB leave_allocation_request_approverY s 6==AAVAL&&+5+77  $ $ ( ( * V":"H"HV I VX  ((,,.&>&L&LM  -6DD$O &&*B*Q*QQ&*4 ' %%'!$T"UV   +  KK ))2>>OOFWIRQ$ !@A144567    w"R ST  0 0 E FF  s A HH chtjj|}|jdk(s|jdk(rt }|j dk(rt |j }|jrd|jd|_ |jdk(r|j}|j}tjj||jj}t!d|j"|z |_|j%d|_|j%t'j(|t+d t-j.t05t3j4|j6j8|jj:d d d d ddt=dd|j>z dddtAdStC|d||dSt'jD|t+dtAdS#1swYtAdSxYw)a function used to Reject leave allocation request. Parameters: request (HttpRequest): The HTTP request object. id : leave allocation request id Returns: GET : It returns to the default leave allocation request view template. rrrr|rrrrz.Leave allocation request rejected successfullyz/Your leave allocation request has been rejectedu*تم رفض طلب تخصيص إجازتكz/Ihr Antrag auf Urlaubszuweisung wurde abgelehntu9Se ha rechazado su solicitud de asignación de vacacionesu5Votre demande d'allocation de congé a été rejetéerr r,rNrzHleave/leave_allocation_request/leave_allocation_request_reject_form.htmlr.The leave allocation request can't be rejected)#rrrrD LeaveAllocationRequestRejectFormrr|rrrrr?r=rrrrr@rr rrrFrGrHr;rIr:r;rErrrrr)rWrrr}rr?rs rBleave_allocation_request_rejectr s 6==AAVAL '';6 # * *j 8/1 >>V #3GLLAD}}9=9J9J89T(6+22j@!9!G!GJ%=%L%LN&4&<&<&C&C&0$<$H$H'D'eg$69?99NJ6O2$((*2<(/(--/  QOP ((3 KK 11":"F"F"W"WN L Q [ W,!()H!I !9!"?  $$IJJ  VV ,  w"R STABB+ $$IJJs 1A HH1c< tjj|}|jdk7r0|j t j |tdnt j|td|jjd}|jj}|rL|dk(rGtjj}|j!rt#d |St%d S|r}|d k(rx|jjd }t'j(|}||vr|j+|t-t'j(||\}} t#d | d|St#t.S#tj$r#t j|tdYFt$r#t j|tdYpt$r#t j|tdYwxYw)z function used to delete leave allocation request. Parameters: request (HttpRequest): The HTTP request object. id : leave allocation request id Returns: GET : return leave allocation request view template rrz/Leave allocation request deleted successfully..z"Approved request can't be deleted.z#Leave allocation request not found.zRelated entries existrzview-containerz'/leave/leave-allocation-request-filter?robjectDetailsModalW25Targetrz,/leave/leave-allocation-request-single-view/?)rrrrDrr rrrrrr rrrr`rrrrrrrr) rWrrr4rleave_allocationsrrrrs rBleave_allocation_request_deleter" s<#9#A#A#E#E#E#P # * *j 8 $ + + -   LM  NN7A&J$K L   !12IKK))+MY"222::>>@  # # %Em_UV V EF F y$AA 8 M2 ^ #  ! !& )+: JJ} %v, (=:=/=/ Z   1 227 " . .Jw"G HI Jw"G HI <w"9 :;F2H'H0'HHc|jjd}|dk(rd|jjdrtj j }n*tj j|j}Dcgc]}t|j}}|j}||d}t|dScc}w)Nrr`rGemployee_id__employee_work_info__reporting_manager_id__employee_user_idrrZFsafe) rrr:rr=rr`rr[rrvrrWrrr.rrZrs rBassigned_leave_selectr*s++//&)Ke << !< =&..224I&..55X_XdXd6I,55CCK5L5//#K+KHG e ,, 6 C cF|jjd}|jjd}|rtj|ni}|dk(r|jj dr*t |tjj}n5t |tjj|j}|j}|Dcgc]}t|j}}|j}||d} t| Sycc}w)Nrrr`rr_r$r&)rrrrr:rrr=rr`rrr[rrvr rWrr`raemployee_filterfiltered_employeesr.rrZrs rBassigned_leave_select_filterr0s++//&)K{{x(H&.djj"BGe << !< =1."8"8"<"<">O2'//66\c\h\h7O-///ABCFF B B(..0 #/ LG$$+ CDc z|jd}tj|}d}|D]} tjj |}|j }|jdk(r|j|dz }n.tj|tdj||dkDr/tj|td j| t!d d iS#t$rB}tj|tdjt|Yd}~ d}~wwxYw) zA This method is used to delete a bulk of leave requests. rrrrr/z%{}'s leave request cannot be deleted.zAn error occurred: {}.Nz/{count} leave request(s) successfully deleted.)rvrr)r|rrrMrrrrDrr rrrrHr[rr)rWrrvrrUrrs rBleave_request_bulk_deleter3:s% ,,u C **S/C E P P(00448H4IM$00H##{2$$& =DDXNO P qy  ?FFUFS T I. // P NN7A&>&E&Ec!f&M$N O O PsA?C// D:87D55D:c|jjd}|dk(rd|jjdrtj j }n*tj j|j}Dcgc]}t|j}}|j}||d}t|dScc}w)Nrr`r\r$r&Fr') rrr:rrMrr`rr[rrvrr)s rBleave_request_selectr5\s++//&)Ke << !: ;$,,002I$,,33X_XdXd4I,55CCK5L5//#K+KHG e ,, 6r+cF|jjd}|jjd}|rtj|ni}|dk(r|jj dr*t |tjj}n5t |tjj|j}|j}|Dcgc]}t|j}}|j}||d} t| Sycc}w)Nrrr`r\r_r$r&)rrrrr:rrprMrr`rrr[rrvrr-s rBleave_request_select_filterr7ps++//&)K{{x(H&.djj"BGe << !: ;0,"6"6":":"<O1%--44\c\h\h5O-///ABCFF B B(..0 #/ LG$$+ Cr1c |jd}tj|}|D]} tjj |}|j }|j dk(r0|jtj|tdn.tj|tdj|tdd iS#t$r)}tj|tdYd}~d}~wwxYw) z? This method is used to delete bulk of leaves requests rrrzLeave request deleted.z/You cannot delete leave request with status {}.rNrr)r|rrrMrrrDrr rrrrrHr)rWrrrUrDrs rBuser_request_bulk_deleter9s ,,u C **S/CC C(00448H4IM"))F##{2$$&  ./ GNNvVWC" I. // C NN7A&@$A B B CsBC DDDc@|jjd}|jj}|dk(r tj j |}Dcgc]}t|j}}|j}||d}t|dScc}w)Nrr`rvr&Fr') rrr:r;rMrrr[rrvr)rWrr:rr.rrZrs rBuser_request_selectr;s++//&)K << $ $De ((//D/A +45CCK5L5//#K+KHG e ,, 6sBc|jjd}|jjd}|rtj|ni}|jj }|dk(ryt |tjj|}|j}|Dcgc]}t|j}}|j} || d} t| Sycc}w)Nrrr`rvr_r&)rrrrr:r;rrMrrrr[rrvr) rWrr`rar:r.r/r.rrZrs rBuser_request_select_filterr=s++//&)K{{x(H&.djj"BG << $ $De0 l2299d9K  -///ABCFF B B(..0 #/ LG$$Cs&C%c|jjd}|jjd} tj|dj }|j jdd}|jj dr|jj ddnd}|r1|r/tjj||jnd}|r |jnd}d}|r|jjr|r|jjk\rz|j|}|jjdvr/|jj |kr|jj n|}|jjd k(rd}||z }|||||d } t#|d | S#d}YoxYw) Nrrtrgrrrr) carryforwardrzno carryforward)r4rrr forcated_daysz7leave/leave_request/employee_available_leave_count.html)rrrryrrrr=rrrrrleave_type_next_reset_dateforcasted_leavesrcarryforward_maxr) rWrrtstart_date_formatr4rrrr@rs rBemployee_available_leave_countrEsKKOOO4M.J$--j*EJJL   !148I ;;  } -  M*1-  [ %%'[ & %'  >67-->>AQQ  ) ) : :"   ( ( : :>O O M)&*,& G JG Y s $GG zbase.add_penaltyaccountsc |jj}tjj |}t |j }tjj|j }|jdk(rt |j}|jr|j}t}||_|j|_|j |_|j |_|j"|_|j$|_|j't }t)j*|dt-|d||||dS)z5 This method is used to create the penalties rrfrvr|zPenalty/Fine addedz%leave/leave_request/penalty/form.html) availabler}rra)rrrMrrrrr=rrr|rrr'rdeduct_from_carry_forwardr minus_leavespenalty_amountrr rr)rW instance_idrrr}rGpenalty_instancepenaltys rBcut_available_leaverN s,KK))+M##'';'7H x';'; >!--?I!%%88MM ||0033u7H7H7K7KK!--@@UUff #LL55&)$)$5$5#66^!_&A%BSBSATTd$e','8'8&99f$g&A%BSBSATTo$p&>u?P?P>QQi$j%,^%<ehhZ?P%P!3  1144 ,,??TTWWX$//@@ #LL55&)!M$R$U$X$U%,-@%Ad588*DU%U!3 "-->>!--@@UUff #LL55&)$)$5$5#66^!_&A%BSBSATTd$e','8'8&99f$g&A%BSBSATTo$p&>u?P?P>QQi$j%,^%<ehhZ?P%P!3  ++<%>> << !A B w '!$?"@Ag344"**11X1FOOHK ??  }} %%g.[[. %--11Z1@  .D,.M!%M       } -  .  ;' 0 &*  rIc V |jj}tjj |j }|j j}t|j|d}|jdk(rt|j}|jr||j_||j_|j!t"jj |j%d}d}|j'sd}t|j|d}t)j*|t-d t.jj |j }|j'r|jj0j2 p|j jj|jjk(r|jj0j2j4} t7j8|j j| |jd d |jd |jdd|jdd|jdt;dd|jzd n|j jj|jj0j2jk(rc|jj4} t7j8|j j| dddddt;dd|jzd n1|jj4|jj0j2j4g} t7j8|j j| |jd d |jd |jdd|jdd|jdt;dd|jzd na|jj4} t7j8|j j| dddddt;dd|jzd t=|d|||dSt=|d|||dS)zU This method renders form and template to create Allocation request comments rrPrr|rTrUFTrVrvz3's leave allocation request has received a comment.u/تلقت طلب تخصيص الإجازة لـ rWz D D FE ,, # #C , #h? D~~0> ==?(+DMM %',DMM $ IIK4<<CC#Dh}%  K??$" 4(+hGD   Wa(E&F G/77>>!--?I!%%88MM ||0033u7H7H7K7KK!--@@UUff #LL55&)$)$5$5#66i!j&UV[VgVgUhhx$y','8'8&99u$v&QRWRcRcQdd%A&KEL]L]K^^v$w%,-L%M $UXXJ/&0!3  1144 ,,??TTWWX$//@@ #LL55&)!X$o$c$h$b%,-L%M $UXXJ/&0!3 "-->>!--@@UUff #LL55&)$)$5$5#66i!j&UV[VgVgUhhx$y','8'8&99u$v&QRWRcRcQdd%A&KEL]L]K^^v$w%,-L%M $UXXJ/&0!3  ++< r)rrrrrr:r;rrr#rr rrrr)rWriscriptrrs rB delete_allocationrequest_commentrzys F+00 )rrrrrr:r;rrr#rjrrrr rrrrrWryrrbrirs rBdelete_allocation_comment_filers F ++  e $C{{:&H\*J+00job_position_id company_idrurtrrprrrrrrrwrrrry) rWrrecordrrrr~rrs rB view_clashesrs |0@ AF }} "fmm{&B+3388:$0$8$8$=$=$?!&2&:&:&?&?&A#  ' 'GMGYGYGlGlGzGzIOI[I[InInI~I~@F@R@R@e@e@p@p !'$// ( W(W ) WQk*Qj-AA B# (%9$?$?;A;M;M;`;`;n;n%@% !';&A&A=C=O=O=b=b=r=r'B' #.gkk;OPSS()=w{{v?VW::%9%E%EFFL 0#+ JJL()B+F     Gs8I8zleave.view_leavegeneralsettingctjjxr(tjjj}t jj dddd\}}||d}t|d|S)NTzCompensatory Leave Typepaid)r]payment)rdefaults)enabled_compensatoryrzcompensatory_settings.html)rrrrrr get_or_creater)rWrrcreaters rBrrs ##**, C  ' ' - - / B B#**88"3G9J(<:VG '7 AArIzleave.add_leavegeneralsettingctjj}|r|n t}d|jj v|_|j d|jj vr*tj|tdtdStj|tdtdS)zN This method is used to enable/disable the compensatory leave feature rz+Compensatory leave is enabled successfully!z,Compensatory leave is disabled successfully!r ) rrrrrcrrr rrr)rWrs rBenable_compensatory_leavers -44::<06I6K-AGKKDTDTDV,V)w{{//11!$Q"RS   !$R"ST  rIcd}tj|}|jj|jk(s&|jj ds t |r:|jtj|tdt|Stj|tdd|jjd}t|S)z> This method is used to delete Leave request comments r  leave.delete_leaverequestcommentrxr= )rrr:r;rrr#rr rrrrrr)rWriryrs rBdelete_leaverequest_commentr s F!&&z2G !!W%8%88 << !C D w '!$C"DE   !$?"@A==D=O=O=R=R>@||$$%STW\\RH ;;??> *(;DD]SHQH(;DD]SH?H  $&   rIc\|jjdrZtjj |}|j j ds|j |j }d}nYtjj |}|j j ds|j |j }d}|jjj}|jtj|tdt||S) zF This method is used to delete Leave request comments rrrrzview-compensatory-leave-commentrzleave-request-view-commentrx)rrrrrr:rrrrrrr rrr)rWrirrrbs rB(delete_leaverequest_compensatory_commentrss ;;??> *5==DD DSG<<((>"..w||.T J &<#6.33$6==(.   Lg  rIc|jjd}|jj}|jjd}|jjd}|jj }d}t |jj jd}tjj|jjd}t |j|j }t||d}|jjdrt||d}t||d}|rt|||d} t|||d} | D cgc]} | d  } } | D cgc]} | jD]}|j!}} }t!j"t%|}| D cgc]} | d  } } | D cgc]} | jD]}|j!}} }t!j"t%|}d }nt'||} t'||} t!j"t%| jj)d d }t!j"t%| jj)d d }t+|}t-t|}|j/dd| | |||||d}t1|||Scc} wcc}} wcc} wcc}} w)zD function used to view compensatory leave requests. rrrz9leave/compensatory_leave/compensatory_leave_req_list.htmlr^rvrr$rrrTrN)rrrarrrrr)rrr:r;rrrrrrrrr r$r/rwrrrrrrr!r9r)rWrrrrrrcomp_leave_requests_filteredmy_comp_leave_requests_filteredrrrrrtrrrrrrs rBfilter_compensatory_leavers (<<,,kkoof-  2 --/ N(F KK( "XXe_ %+C*J*J*Q*Q +R+ (5/ (+I KK8+ " ((: 13V( $ ;;??8 $+15x, (/58(/ + "3,e[&# &7/& " 7JJU5=JKJ)4 %UEVEV9A G ::d7m4L6LMU5=MKM)4 %UEVEV9A G#jjg7OW #0,k# &3/& " ::(44@@D@QRL#jj+77CCDtCTUO ]+ %&> J  h%$7&<$(. gx99UK Ns/ K5$K: L$Lc|jj}d}d}|dk7r tjj |}t |}|j dk(rt |j|}|jr|j}t|j|jj|_|j|dk7r*tj |t#dt%dStj |t#dt%dS||d }t'|||S) a function used to create or update compensatory leave request. Parameters: request (HttpRequest): The HTTP request object. Returns: GET : return leave allocation request form template POST : return leave allocation request view z-leave/compensatory_leave/comp_leave_form.htmlNrrr|zCompensatory Leave updated.zCompensatory Leave created.r.)rr})r:r;rrrrrr|rrr4rrr`r?r rrrr)rWcomp_idrrrr}comp_reqrs rBcreate_compensatory_leavers<<,,B d?/77;;w;GH$h7 >>V #(ID}}99;*9(((*@*@*D*D*F+' d?$$Wa0M.NO$$PQQ$$Wa0M.NO#$PQQ! gx11rIz%leave.delete_compensatoryleaverequestT)permremanager_accesscZ tjj|j}t j |t d|jjddk(rttStdS#t j|t dY[xYw)z function used to delete compensatory leave request, and reload the list view of compensatory leave requests. rz#Compensatory leave request deleted.Sorry, something went wrong!rrr) rrrrr rrrrrrrrWrcomp_leave_reqs rBdelete_compensatory_leaverAs G5==AAWAMTTVN   Wa(M&N O ;;??6 "f ,56 6 EF F  G NN7A&D$E Fs A B!B*z%leave.change_compensatoryleaverequest)rc  tjj|}|jdk(rd|_|j |j t j|tdtjt5tj|jj|j j"ddddd t%d d |j&z d d d nt j(|td|j,jdr t/dSt1t2S#1swY>xYw#t j*|tdYdxYw)z function used to approve compensatory leave request, and reload the list view of compensatory leave requests. rrrz$Compensatory leave request approved.z1Your compensatory leave request has been approveduQتمت الموافقة على طلب إجازة الاعتذار الخاص بكz0Ihr Antrag auf Freizeitausgleich wurde genehmigtz6Su solicitud de permiso compensatorio ha sido aprobadau8Votre demande de congé compensatoire a été approuvéeview-compensatory-leaver,rrrrr r!rNz@The compensatory leave request is not in the 'requested' status.r individualr)rrrrDassign_compensatory_leave_typerr rrrFrGrHr;rIr:r;rrErrrrrrrrrs rBapprove_compensatory_leaverYsD G5==AAWAMN$$ 3(2%==?##%  !,R*ST((3 KK 11"0"<"<"M"MP s R X Z!()B!C !2!2 34"5    Z ;;??< ( EF F122/  & G NN7A&D$E Fs%BEAE /(E EE!E;c htjj|}|jdk(s|jdk(r4t }|j dk(r t |j }|jr|jd|_ d|_|j|jtj|tdtj t"5t%j&|j(j*|j,j.dd d d d t1d d|j2zdddt5dSt7|d||dStj8|tdt5dS#1swYt5dSxYw)a' function used to Reject compensatoey leave request. Parameters: request (HttpRequest): The HTTP request object. comp_id : compensatory leave request id Returns: GET : It returns to the default compensatory leave request view template. rrrr|rrz$Compensatory Leave request rejected.z1Your compensatory leave request has been rejectedu6تم رفض طلبك للإجازة التعويضيةz0Ihr Antrag auf Freizeitausgleich wurde abgelehntz5Se ha rechazado su solicitud de permiso compensatoriou6Votre demande de congé compensatoire a été rejetéerr,rNrz=leave/compensatory_leave/compensatory_leave_reject_form..html)r}rr)rrrrD"CompensatoryLeaveRequestRejectFormrr|rrrexclude_compensatory_leaverr rrrFrGrHr;rIr:r;rrErrrrr)rWrrr}s rBreject_compensatory_leaversy 299===I  K />3H3HJ3V57D~~'9',,G==?373D3DX3NN0,6N)"==?"'')$$Wa0V.WX#,,Y7  #LL55&4&@&@&Q&Q!T$\$V$[$\%,-F%G $^%6%6$78&9  ((MNNO'2  NN7A&V$W X EF F) ((MNNs 2AFF1c4|jjd}|r$tj|}t ||\}}t j j|}|t|jjd|d}t|d|S)a# function used to present the compensatory leave request detailed view. Parameters: request (HttpRequest): The HTTP request object. comp_leave_id : compensatory leave request id Returns: return compensatory leave request single view rrr)rrrrrz:leave/compensatory_leave/individual_view_compensatory.htmlr) rrrrrrrrr)rW comp_leave_idrrrrrrs rB"compensatory_leave_individual_viewrs$KKOOO< ::&78L#2<#O K199===O,'  (EF.#    H  rIctjj|jd}d}|j sd}|j r|j j d}|jd}tjj|}g}|D]4}t} || _ | j|j| 6|jj|t|d|||d S) zD This method is used to show Leave request comments rTrUFTrhrirrrp)rrrrrrrrrrjr,rr_rhrr) rWrr]r^rhrirrkr,rls rBview_compensatory_leave_commentrs3::AA$B (= !   K ==MM))'2E \2J5==AAZAPGK 2 0 2 %) """$""=1  2 GMM  { +  F$*+   rIc  tjj|j}|jj }t |j|d}|jjd}|dk(rdnd}|jj}|jdk(rt |j}|jr||j_||j_|j#t$jj| j'd }d } |j)sd } t |j|d}t+j,|t/d t0jj|j} | j)r|jj2j4 r|jj j|jjk(r|jj2j4j6} t9j:|jj | |jdd|jdd|jdd|jdd|jdt=dd|jzd n|jj j|jj2j4jk(rc|jj6} t9j:|jj | ddddd t=dd|jzd n2|jj6|jj2j4j6g} t9j:|jj | |jd!d"|jdd|jdd#|jdd|jdt=dd|jzd na|jj6} t9j:|jj | ddddd t=dd|jzd t?|d$|| |d%St?|d$|||||d&S)'z] This method renders form and template to create Compensatory leave comments rrPrrQrrRrSr|rTrUFTrVrvz5's Compensatory leave request has received a comment.u1تلقى طلب إجازة الاعتذار لـ rWz%Der Antrag auf Freizeitausgleich von z hat einen Kommentar erhalten.z)La solicitud de permiso compensatorio de rXu&La demande de congé compensatoire de rYrr,rZr[z7Your compensatory leave request has received a comment.uEتلقى طلب إجازة العوض الخاص بك تعليقًا.z>Ihr Antrag auf Freizeitausgleich hat einen Kommentar erhalten.z@Su solicitud de permiso compensatorio ha recibido un comentario.u=Votre demande de congé compensatoire a reçu un commentaire.z5's compensatory leave request has received a comment.u/تلقى طلب إجازة التعويض لـ z&El pedido de permiso compensatorio de rrp)r}rrarQr_) rrrrr:r;#CompensatoryLeaveRequestcommentFormrrrrrr|rrrrrrrrr rrrarKrLrEr;rIrr) rWr comp_leaver.r}rQr_rr]r^rcrds rB!create_compensatory_leave_commentrs.55<< <NTTV ll''2$'FF*E *"(N":@U --/ >>V #6w||DD}},/ )+5 ( :BBII)J(=)$ ("&K:,/FF*M  !,I*JK3;;BB * 6 6C ##%"..AAVV#$#<<4477:;Q;Q;T;TT * 6 6 I I ^ ^ o o #KK ' 9 9*-(2(>(>'??t%u*[\f\r\r[stD)E*OPZPfPfOghF)G*ST^TjTjSklG)H*PQ[QgQgPhiA)B)01J)K$("8*9%7 $LL5588)55HH]]``a#-"8"8"I"IC"KK ' 9 9*-%^(o(h(j(g)01J)K$("8*9%7 !+ 6 6 G G * 6 6 I I ^ ^ o o#C#KK ' 9 9*-(2(>(>'??t%u*YZdZpZpYqrB)C*OPZPfPfOghF)G*PQ[QgQgPhiD)E*PQ[QgQgPhiA)B)01J)K$("8*9%7 )44EE #LL55&)!Z$k$d$f$c%,-F%G $Z]]O4&5!3 N$,'2&3  F+#     rIrac|jjd}|jjd}|jjd} tj|d}tj|d}||z }t |j dzDcgc]}|t |z}}tdd } | jj|| } d t| jd d i} t| Scc}w#t$r*} tj| t| cYd} ~ Sd} ~ wwxYw)Nrtrurrgr/rrarbrc)rinterview_date__inrcandidate_id__nameTr)rrrryrrrr1rrrrrrHr*r) rWrtrurstart_date_obj end_date_objdeltar date_listrrrYrs rBcheck_interview_conflictsrvs1[[__\2 ;;??:.kkoom4  #%..z:FN#,,XzBL"\1E This method is used to view own profile of employee. rVrvTrNz"employee/profile/profile_view.html)rrleave_request_idsrnnow)r:r;r rsrMrrrr`rrrrrrrrrytimezonerr) rWr:r instancesrrrryrs rBemployee_profile_leave_tabrs+ <;?N$PXX[[$PQ 8,.   X %QsD%D*D*:D/cf|jj}|jjd}tjj dd}t ||d}t||}tj|Dcgc]}|jc}}t|d|||dScc}w)NrrT)rDrrz1request_and_approve/leave_allocation_approve.html)allocation_reqests reqests_idsra) rrrrrrr rrrrr)rWrrrrallocation_reqests_idss rBleave_allocation_approver@sKK))+M++//&)K/77>>4?,#%H''9;G!ZZ%788 ;"41    9sB.rr>)__doc__rrFr collectionsrrrr urllib.parserrpandasra django.appsr django.contribr django.core.paginatorr django.dbr django.db.modelsr r django.httprrdjango.shortcutsrrr django.urlsrdjango.utils.encodingrdjango.utils.translationrrrrdjango.views.decorators.httpr base.filtersr base.formsr base.methodsrrrrr r!r"r#r$ base.modelsr%r&r'employee.modelsr(horilla.decoratorsr)r*r+r,r-r.horilla.group_byr/horilla.horilla_settingsr0horilla.methodsr1r2leave.decorators leave.filters leave.forms leave.methodsr4r5r6r7r8r9 leave.modelsleave.threadingr:notifications.signalsr;rzrrrrrrrrrr[rrr~rrrrrrrrrrrrr r rrrr!r;rBrGrLrNrPrSrWr]rcrrrrrrrrrrrrrrrrrrrrrrr"leave_allocation_change_permissionr"leave_allocation_reject_permissionrr"leave_allocation_delete_permissionr"r*r0r3r5r7r9r;r=rErNrermrsrvrzrrrrrrrsrrrrris_compensatory_leave_enabledrrrrrrrrrrrrrrrr?rIrBrs  #..*#+!.2@@+26=&)   A@$/9G/(%P*+X,X*+,#-#L)*X+X.+,-<-.!/!H-.*%/*%Z+,/-/:&+,F-FR,-P.Pf,-..kk\./D0DN./(0(<./jG0jGZ./&F0&FR./ F0 F./S0Sl,?,?^,-Q.Q6-.v/vr./'0'T./0../404n-.P/Pf01$2$N01 22 2Fvh2304 0('.-.T"/T"n.LL./0D44123>12>3>012434:./!0!./ %0 % sslnnbGG6  F:EEPXXv>,-.0::201!<2!--&%%:vh0 04 - -%%,33l-.!/!Huup((Vppf((V  ,  099x56 B7 B456"  *  04\"V446  200*"$0 %0 d"$V:%V:p"$#2%#2J"$ 4& G %G "$CD#3E%#3J"$CD+GE%+GZ"$ % :"$ % B"$w %w t4]##>567&%%PBCBCJ##LrI