vgі dZddlZddlZddlmZddlmZddlmZddl m Z ddl m Z ddl mZmZmZmZmZd Zej(ej*ej,ej.ej0ej2ej4ed Zd d id d id did didZiddddddddddddddddddddd d!d"d#dgd$d%d&d'd(d)d*d+d,d-d.d.d/id0gd1gd2dd3dd4d5d6d7d8dd9d:d6gd;d dd6d?d@d"ddAd6dBdCd"d:d:d6gdDdEdFddGdHdIgdJdKdLd"dMdNd6gdOdPdQdRddSdTdUdVZdWZdXZdYZ dZZ!d[Z"d\Z#d]Z$d^Z%d_Z&d`Z'daZ(dbZ)dcZ*ddZ+deZ,dfZ-dgZ.dhZ/e'e(e)e*e+e,e-e.e/di Z0y)jz This module contains various functions for calculating payroll-related information for employees. It includes functions for calculating gross pay, taxable gross pay, allowances, tax deductions, pre-tax deductions, and post-tax deductions. N)apps)get_horilla_model_classupdate_compensation_deduction) compute_limit)models) AllowanceContract Deduction LoanAccountMultipleConditioncyN)abs 0/var/www/horilla/payroll/methods/payslip_calc.py return_noners )equalnotequalltgtlege icontainsrangefilterc<||jj||fddS)NT) employee_idwork_type_id__idattendance_date__rangeattendance_validated) work_type_ididemployee allowance start_dateend_dates rr++s'# ) 6 6 9 9'18&<$( E rc<||jj||fddS)NT)r shift_id__idr"r#)shift_idr%r&s rr+r+3s'#%..11'18&<$( E rc|||fdddS)NT)r r"attendance_overtime_approver#rr&s rr+r+;s#'18&<+/$( E rc|||fddS)NTr r"r#rr&s rr+r+Cs#'18&<$(E r)r$r.overtime attendancenet_payg](@r' allowanceszLow Basic Pay AssistanceT allowance_idtitle is_taxableamount z!Bonus point Redeem for Adam Luis gR@ Motorcycleg@zMeal AllowanceFg@ gross_payg..@ contract_wageg@ basic_payg."P@ paid_daysg5@ unpaid_daysg?taxable_gross_payg]tE@basic_pay_deductionsgross_pay_deductionspretax_deductionszSocial Security (FICA)g颋.:@g@ deduction_idr; is_pretaxr=employer_contribution_rate>zLate Come penaltygi@gpost_tax_deductionsz Medicare taxg.F~@g333333?7ESIg @ITesttax_deductionsKztest tax netpaygE]t@g@rLr;is_taxr=rNnet_deductionsJz Test Netpayg2iV/v@g@total_deductionsgE]t@ loss_of_payg.ۘ@z 2024-02-01z 2024-02-29zFeb 01 2024 - Feb 29 2024) federal_taxr)r*rc2|jd}|D]t}tjt5t |j t r |jdj }dddt||d}|s|S|S#1swYxYw)a Retrieves the value of a nested attribute from a related object dynamically. Args: obj: The base object from which to start accessing attributes. attribute_path (str): The path of the nested attribute to retrieve, using double underscores ('__') to indicate relationship traversal. Returns: The value of the nested attribute if it exists, or None if it doesn't exist. __T) is_activeN) split contextlibsuppress Exception isinstancefirstr rgetattr)objattribute_path attributesattrs r dynamic_attrrls %%d+J   + 9#))+x0jj4j0668 9c4& ;  J J 9 9s ?B  B cvd}d}||z}fddD\}}}t||d||}|d||ddS) a Calculate the gross pay for an employee within a given date range. Args: employee: The employee object for whom to calculate the gross pay. start_date: The start date of the period for which to calculate the gross pay. end_date: The end date of the period for which to calculate the gross pay. Returns: A dictionary containing the gross pay as the "gross_pay" key. rDtotal_allowancec3(K|] }| ywrr).0keykwargss r z&calculate_gross_pay..s&s &s)r'r)r*rBcompensation_amount deductions)rBrDrur) _argsrrrDrnrBr'r)r*updated_gross_pay_datas ` rcalculate_gross_payrxsr{#I./O)+I&E&"Hj(;)[*h,,AB,\: rc|d}tdi|}|d}tdi|}td|dD}td|dD}||z |z }d|iS)a Calculate the taxable gross pay for an employee within a given date range. Args: employee: The employee object for whom to calculate the taxable gross pay. start_date: The start date of the period for which to calculate the taxable gross pay. end_date: The end date of the period for which to calculate the taxable gross pay. Returns: A dictionary containing the taxable gross pay as the "taxable_gross_pay" key. r7rBc30K|]}|ds|dyw)r<r=Nr)rpr(s rrsz.calculate_taxable_gross_pay..s%& & (&c30K|]}|dr|dyw)rMr=Nr)rp deductions rrsz.calculate_taxable_gross_pay..s%!  [ ! (!r{rJrGr)rxcalculate_pre_tax_deductionsum)rvrrr7rBpre_tax_deductionsnon_taxable_allowance_totalpretax_deduction_totalrGs rcalculate_taxable_gross_payrs %J#-f-I+&I4>v>"%&#L1&# !!+,?@! "$??BXX. rc |d}|d}|d}|d}|d}tjj|}tjjdj| }tjjd j| }||z|z} | j| j| j } g} g} g} g} g}| D]}|j rt |jjd dd}|j}|j}|jjjdd}|j|||fd}|D]U}t||d}|?t j#|d}t%||d}|||r|dz}Od}nd}n|s| j||j&t(vrst)|j&d||||}t+j,dsDt/dd}|jjd i|so| j|| j|| D]1}|j0r| j|!| j|3| D]}|j2r3|j4}||d<||d<t7d i|}| j|Bt8j#|j&}|d i||||dd||d}||d<||d<t7d i|}| j|| D]}|j2r3|j4}||d<||d<t7d i|}|j|Bt8j#|j&}|d i||||||d}||d<||d<t7d i|}|j|g}t;| | D];\}}|j<|j>|j0|d}|j|=t;| |D];\}}|j<|j>|j0|d}|j|=d|iS)!aK Calculate the allowances for an employee within the specified payroll period. Args: employee (Employee): The employee object for which to calculate the allowances. start_date (datetime.date): The start date of the payroll period. end_date (datetime.date): The end date of the payroll period. r'r)r*rDday_dict)specific_employeesT)is_condition_basedexclude_employees)include_active_employeesone_time_date__ltone_time_date__gtfield conditionvalue _rNr6rAFrr4 app_labelmodelr= componentr'r)r*rr7rnrDr)r'r)r*rrrDr9r7r) r objectsrexcludedistinctrlistother_conditions values_listrrrlowerreplaceappendrloperator_mappinggettypebased_onfilter_mappingr is_installedrr<is_fixedr=if_condition_oncalculation_mappingzipr%r;)rrr'r)r*rDrspecific_allowancesconditional_allowancesactive_employeesr7employee_allowancestax_allowancesno_tax_allowancestax_allowances_amtno_tax_allowances_amtr( conditionscondition_fieldcondition_operatorcondition_value applicablerval operator_func filter_params Attendancer=calculation_functionserialized_allowancesserialized_allowances rcalculate_allowancer s j!H %Jj!H{#Ij!H#++22h2O&..555NVV"W!((///NVV"W%'==@PPJ Z8 8 ,  N&6  ' '**66w WUJ(ooO!*!4!4 'oo335==c3GO   0BOT UJ'  "8Yq\:?$4$8$81$FM&/d3i ! &=O$S/:%/$%6  %* !&J #**95!!^3 .y/A/A B8 LiX! $$\2!8".l"J1z))00A=A+229=#**95M&6P)0     ! !) ,  $ $Y / 0 $.   %%F%F8 "+F; $.v.F  % %f -#6#:#:9;M;M#N )  (", (!*"&'+!* (  F &F8 "+F; $.v.F  % %f -3.6'1   %%F%F8 "+F; $.v.F ! ( ( 0$7#:#:9;M;M#N )  (", (!* (!*  F &F8 "+F; $.v.F ! ( ( 0/10!1CD; 6%LL__#..   $$%9:;!!24IJ; 6%LL__#..   $$%9:; / 00rc|d}|d}|d}tjjj|dd}tjjjdddj |}||z}|j | j | j d }g}g} |D]d} t j | j} | di|||| |d |d |d|dd} | |d<| |d<tdi|} |j| ft||D]F\} } | j| j| j| | jd} | j| Hd| iS)a Calculates the tax deductions for the specified employee within the given date range. Args: employee (Employee): The employee for whom the tax deductions are being calculated. start_date (date): The start date of the tax deduction period. end_date (date): The end date of the tax deduction period. allowances (dict): Dictionary containing the calculated allowances. total_allowance (float): The total amount of allowances. basic_pay (float): The basic pay amount. day_dict (dict): Dictionary containing working day details. Returns: dict: A dictionary containing the serialized tax deductions. r'r)r*FTrrMrXrrMrXrrrupdate_compensation__isnullr7rnrDrrr=rrWrUr)rr rrrrrrrrrr%r;rX employer_rate)rvrrr'r)r*specific_deductionsactive_employee_deductionrudeductions_amtserialized_deductionsr}rr=serialized_deductions rcalculate_tax_deductionrs j!H %Jj!H **2299#uT:!' 0 0 8 8 ? ?!%t!@! gg)%'@@JZ8 8 , U 3 N& 266y7I7IJ%  $($&$\2#)*;#<#K0":.   "x'{ *6*f%#&$!^<; 6%LL__&&*3*A*A   $$%9:; 3 44rcZ|d}|d}|d}tjjj|dd}tjjjdddj |}tjjjddd j |}||z|z}|j | j | j d }|jd } g} g} g} |D]%} | j rt | jjddd}| j}| j}| jjjdd}|j|||ftj!|}d}|D]U}t#||d}|?tj!|d}t%||d}|||r|dz}Od}nd}n|s| j| | j| (| D]} | j&r/| j(|d<| |d<| jt+di|>t,j!| j.}|di|||| |d|d|d|dd}||d<| |d<| jt+di|t1| | D]F\} }| j2| j4| j6|| j8d}| j|H| | dS) a This function retrieves pre-tax deductions applicable to the employee and calculates their amounts Args: employee: The employee object for whom to calculate the pre-tax deductions. start_date: The start date of the period for which to calculate the pre-tax deductions. end_date: The end date of the period for which to calculate the pre-tax deductions. Returns: A dictionary containing the pre-tax deductions as the "pretax_deductions" key. r'r)r*TFrrrMrXrrrrris_installmentrrrrrrr6rAr=rr7rnrDrrrK)rJ installmentsr)rr rrrrrrrrrrrrrrrrlrrr=rrrrr%r;rMr)rvrrr'r)r*rconditional_deductionrrurrpre_tax_deductions_amtrr}rrrrrrrrrr=rs rr~r~sj!H %Jj!H **2299#tE:#,,44;;4< gg)!' 0 0 8 8 ? ?!%e!@! gg)%'<'>y?Q?Q'R$- $,&0$,%.&0+:%.$,  $*x &/{#(262'..v6376!!46MN; 6%LL__",,*3*A*A   $$%9:;)O    *,7+C ( ) 0 01M NO 5:$ rc x|d}g}|Dcgc]}|d }}g}|D]5}t|||} | |d<||d<tdi|} |j| 7d} t||D]K\}} |j|j |j | |jd} | | z} |j| M|| dScc}w) a_ Calculates the deductions based on the net pay amount. Args: net_pay (float): The net pay amount. net_pay_deductions (list): List of net pay deductions. day_dict (dict): Dictionary containing working day details. Returns: dict: A dictionary containing the serialized deductions and deduction amount. rr}r=rrrK)net_pay_deductions net_deductionr)calculate_based_on_net_payrrrr%r;rMr) r5rrrrritemru deduction_amtr}r=rrs rcalculate_net_pay_deductionrsj!H$&!0BC${#CJCM% +IwI!x'{ *6*V$ % M ]; C 6%LL__",,*3*A*A  . %,,-AB C<& 'Ds B7cp|d}|d}|d}d}t|}t|tstdi|d}|jdk(r|n|}|j dk(r%|j |cxkr|jksnd}|Stj|j }|||jsd}|S)a This method is used to check the allowance or deduction through the the conditions Args: employee (obj): Employee instance amount (float): calculated amount of the component component (obj): Allowance or Deduction instance start_date (obj): Start date of the period end_date (obj): End date of the period Returns: _type_: _description_ rrDr=rrBrr) floatrer rx if_choice if_condition start_range end_rangerr if_amount)rvrrrrDr=rBrrs rrrs{#I{#I H FI 6]F i +'   $-#6#6+#Ei9O($$N9;N;NNF M),,Y-C-CD _i.A.ABF Mrcf|d}|d}|d}|j}||zdz }t|||}|S)a Calculate the amount of an allowance or deduction based on the employee's basic pay with rate provided in the allowance or deduction object Args: employee (Employee): The employee object for whom to calculate the amount. start_date (datetime.date): The start date of the period for which to calculate the amount. end_date (datetime.date): The end date of the period for which to calculate the amount. component (Component): The allowance or deduction object that defines the rate or percentage to apply. Returns: The calculated allowance or deduction amount based on the employee's basic pay. rrDrd)rater)rvrrrrDrrr=s rcalculate_based_on_basic_payrsM {#I{#Ij!H >>D   #F 9fh 7F MrcT|d}tdi|}|j}|d|zdz }|S)a Calculate the amount of an allowance or deduction based on the employee's gross pay with rate provided in the allowance or deduction object Args: employee (Employee): The employee object for whom to calculate the amount. start_date (datetime.date): The start date of the period for which to calculate the amount. end_date (datetime.date): The end date of the period for which to calculate the amount. component (Component): The allowance or deduction object that defines the rate or percentage to apply. Returns:+- The calculated allowance or deduction amount based on the employee's gross pay. rrBrr)rxr)rvrrrrBrr=s rcalculate_based_on_gross_payrs="{#I#-f-I >>D { #d *S 0F MrcX|d}tdi|}|d}|j}||zdz }|S)a Calculate the amount of an allowance or deduction based on the employee's taxable gross pay with rate provided in the allowance or deduction object Args: employee (Employee): The employee object for whom to calculate the amount. start_date (datetime.date): The start date of the period for which to calculate the amount. end_date (datetime.date): The end date of the period for which to calculate the amount. component (Component): The allowance or deduction object that defines the rate or percentage to apply. Returns: The calculated component amount based on the employee's taxable gross pay. rrGrr)rr)rvrrrrGrr=s r$calculate_based_on_taxable_gross_payr6sE {#I3=f=)*=> >>D  % +F Mrctt|j}||zdz }t|||}t|||}|S)a Calculates the amount of an allowance or deduction based on the net pay of an employee. Args: component (Allowance or Deduction): The allowance or deduction object. net_pay (float): The net pay of the employee. day_dict (dict): Dictionary containing working day details. Returns: float: The calculated amount of the component based on the net pay. r)rrr)rr5rrr=s rrrNsA  D t^c !F 9fh 7F 9fh 7F Mrctjdsytdd}|d}|d}|d}|d}|d}|jj |||fd j }||j z} t|| |} | S) : Calculates the amount of an allowance or deduction based on the attendance of an employee. Args: employee (Employee): The employee for whom the attendance is being calculated. start_date (date): The start date of the attendance period. end_date (date): The end date of the attendance period. component (Allowance or Deduction): The allowance or deduction object. day_dict (dict): Dictionary containing working day details. Returns: float: The calculated amount of the component based on the attendance. r4rrr'r)r*rrTr2)rrrrrcountper_attendance_fixed_amountr) rvrrrr'r)r*rrrr=s rcalculate_based_on_attendancerbs   \ *(<|TJj!H %Jj!H{#Ij!H    % % *H5! &  eg  Y:: :F 9fh 7F Mrc@tjdsytdd}|d}|d}|d}|d}|d}|jj}|j j ||||fd j} | |jz} t|| |} | S) aH Calculates the amount of an allowance or deduction based on the employee's shift attendance. Args: employee (Employee): The employee for whom the shift attendance is being calculated. start_date (date): The start date of the attendance period. end_date (date): The end date of the attendance period. component (Allowance or Deduction): The allowance or deduction object. day_dict (dict): Dictionary containing working day details. Returns: float: The calculated amount of the component based on the shift attendance. r4rrr'r)r*rrT)r r.r"r#) rrrr.r%rrrshift_per_attendance_amountr) rvrrrr'r)r*rrr.rr=s rcalculate_based_on_shiftrs   \ *(<|TJj!H %Jj!H{#Ij!H!!$$H    % % *H5! &   eg  Y:: :F 9fh 7F Mrc@tjdsytdd}|d}|d}|d}|d}|d}|jj |||fd }t d |D} |j } | d z } | | z} t| d } t|| |} | S)aA Calculates the amount of an allowance or deduction based on employee's overtime hours. Args: employee (Employee): The employee for whom the overtime is being calculated. start_date (date): The start date of the overtime period. end_date (date): The end date of the overtime period. component (Allowance or Deduction): The allowance or deduction object. day_dict (dict): Dictionary containing working day details. Returns: float: The calculated amount of the allowance or deduction based on the overtime hours. r4rrr'r)r*rrT)r r"r0c34K|]}|jywr)overtime_second)rpr4s rrsz.calculate_based_on_overtime..sL*:--LsirA) rrrrrramount_per_one_hrroundr) rvrrrr'r)r*rr attendancesr3amount_per_houramount_per_secondr=s rcalculate_based_on_overtimers   \ *(<|TJj!H %Jj!H{#Ij!H$$++ *H5$(,K L LLH11O'73 ) )F 61 F 9fh 7F Mrc@tjdsytdd}|d}|d}|d}|d}|d}|jj}|j j ||||fd j} | |jz} t|| |} | S) a Calculates the amount of an allowance or deduction based on the employee's attendance with a specific work type. Args: employee (Employee): The employee for whom the attendance is being considered. start_date (date): The start date of the attendance period. end_date (date): The end date of the attendance period. component (Allowance or Deduction): The allowance or deduction object. day_dict (dict): Dictionary containing working day details. Returns: float: The calculated amount of the allowance or deduction based on the attendance with the specified work type. r4rrr'r)r*rrT)r r$r"r#) rrrr$r%rrrwork_type_per_attendance_amountr) rvrrrr'r)r*rrr$rr=s rcalculate_based_on_work_typers   \ *(<|TJj!H %Jj!H{#Ij!H)),,L    % %! *H5! &   eg  Y>> >F 9fh 7F Mrct|d}|d}|d}|j}||jz}t|||}|S)rr'rr)childrenper_children_fixed_amountr)rvrrr'rrrr=s rcalculate_based_on_childrenr sPj!H{#Ij!H   E Y88 8F 9fh 7F Mr) rDrBrGr5r4r.r3r$r)1__doc__rboperator django.appsrhorilla.methodsrpayroll.methods.deductionsrpayroll.methods.limitsrpayroll.modelsrpayroll.models.modelsr r r r r reqnerrrrcontainsrrtetsrlrxrrrr~rrrrrrrrrrrr rrrrrsJ4D0! [[ ++ ++ ++ ++""          3 Fd !dd/  8  !  %  'd:";d<W=d>"?d@AdB3CdD-/@AEdFBGdHBIdJ-(*-  (*-  Kdj#(*.  *.  *-  kdX&'*-  Ydj"'*-  kd|)}d~$d@ (GdN2@B[1|<5~fVReP$ND400("J"J%P%P0.-=)/(+0+ r