vg :dZddlZddlZddlmZmZmZddlmZddlm Z ddl m Z ddl m Z ddlmZdd lmZmZmZdd lmZdd lmZdd lmZdd lmZddlmZddlm Z ddl!m"Z"m#Z#m$Z$m%Z%m&Z&m'Z'm(Z(ddl)m*Z*ddl+m,Z,m-Z-m.Z.ddl/m0Z0ddl1m2Z2ddl3m4Z4m5Z5ejle7Z8dZ9dZ:Gdde2Z;Gdde2Z<GddejzZ>e j~dr!ddl@mAZAGd d!eAZBeeeA"d#ZCe j~d$rdd%lDmEZEGd&d'eEZFeee."d(ZGd)ZHd*ed+fd,ed-fd.ed/fd0ed1fd2ed3fd4ed5fd6ed7fgZId*ed+fd,ed-fd.ed/fd0ed1fd2ed3fd4ed5fd8ed9fgZJd:ed;fd<ed=fd>ed?fd@edAfdBedCfdDedEfdFedGfdHedIfdJedKfdLedMfg ZKGdNdOejzZLGdPdQe2ZMGdRdSe2ZNGdTdUe2ZOGdVdWe2ZPdXZQeeeP"dYZRGdZd[ejzZSGd\d]e2ZT eTjjd^_jr,eTjjd^_jd`_GdadbejzZYGdcdde2ZZGdedfejzZ[GdgdhejzZ\gdiedjfdkdldmdndodpdqdrdsdtdudvdwdxdydzd{d|d}d~dddddddddddZ]GddejzZ^y#YxYw)z# models.py Used to register models N)datedatetime timedelta)forms)apps)messages)ValidationError)models) post_save pre_deletepre_save)receiver) QueryDict)timezone) gettext_lazy)HorillaCompanyManager)get_next_month_same_date)Company Department EmployeeShift JobPositionJobRoleWorkTypevalidate_time_format)strtime_seconds) BonusPointEmployeeEmployeeWorkInformation)horilla_middlewares) HorillaModel)HorillaAuditInfoHorillaAuditLogc6|dkrttdy)z2 The minimum value zero validation method rzValue must be greater than zeroNr _values )/var/www/horilla/payroll/models/models.pymin_zeror),s! qya ABCCcg}||z }t|jdzD]"}|t|z}|j|$|S)a Returns a list of all dates within a given date range. Args: start_date (date): The start date of the range. end_date (date): The end date of the range. Returns: list: A list of date objects representing all dates within the range. Example: start_date = date(2023, 1, 1) end_date = date(2023, 1, 10) date_range = get_date_range(start_date, end_date) )days)ranger-rappend) start_dateend_date date_listdeltai current_dates r(get_date_ranger64sT I z !E 5::> "'!I1$55 &' r*c eZdZdZdedfdedfdedfgZejdd ed  Zejd ed d ded Z ejdd Z ejdZ ejdedd Zejedd ej"ZeZdefdZGddZy) FilingStatusz FilingStatus model basic_pay Basic Pay gross_pay Gross Paytaxable_gross_payTaxable Gross PayFz Filing status) max_lengthblank verbose_namezBased on)r@choicesnullrAdefaultrBz Python Code)rBrFTrE Description)rArBr@rEeditable on_deletereturnc,t|jSN)str filing_statusselfs r(__str__zFilingStatus.__str__qs4%%&&r*ceZdZdgZy)FilingStatus.Meta-idN__name__ __module__ __qualname__orderingr*r(MetarUt 7r*r]N)rXrYrZ__doc__r%based_on_choicer CharFieldrPbased_on BooleanFielduse_py TextField python_code description ForeignKeyrPROTECT company_idrobjectsrOrSr]r\r*r(r8r8Ns  a n% a n% a 345O %F$$'M  v #z] H!V mU KF"&""-K"&""}%K #""dUfnnJ$%G''r*r8c &eZdZdZdedfdedfdedffZded fd ed fd ed ffZdedfd ed fgZejdrejdedfdedfdedfdedfdedffZ dedfge e jjddzZej$dededZej(eej,d ed!"Zej0ed#$Zej0d%d%ed&'Zej$edd ed()Zej$d*d%ed ed+,Zej:ed-d%d./Zej(e ej,d0d%d%ed12Zej$e dded3)Z ej(e!ej,d%d%d0ed45Z"ej(e#ej,d%d%d0ed65Z$ej(e%ej,d%d%d0ed75Z&ej(e'ej,d%d%d0ed85Z(ej(e)ej,d%d%d0ed95Z*ejVd:ed;e,ged<=Z-ej\d>d%d%?Z/ej`d%ed@edABZ1ej`d%edCedDBZ2ej:d%d%d.edEFZ3ejhd%d%dGHZ5e6dIe7gJZ8e9dKZdLe:fdMZ;dNZ<fdOZ=GdPdQZ>xZ?S#YxYw)RContractz Contract Model salarySalaryhourlyHourly commission CommissionweeklyWeeklymonthlyMonthly semi_monthlyz Semi-MonthlydailyDaily attendancedraftDraftactiveActiveexpiredExpired terminated TerminatedNoneidrPzContract Title.)r@ help_textrB contract_setr)rK related_namerBz Start DaterBTzEnd Date)rErArB Wage Type)rDr@rFrB Pay Frequency)r@rErDrFrBz Basic Salaryr)rBrErF contractsz Filing Status)rKrrErArBStatusr)rKrErArrBz Job PositionzJob RoleShift Work Typer?zNotice period in total days.z Notice Period)rFr validatorsrBzuploads/) upload_torErAzDeduct From Basic Payz'Deduct the leave amount from basic pay.rFrBrzCalculate Daily Leave AmountzTLeave amount will be calculated by dividing the basic pay by number of working days.zDeduction For One Leave Amount)rErArFrBrC)rErAr@ history_setrbases+employee_id__employee_work_info__company_idrLcR|jd|jd|jS)Nz - - ) contract_namecontract_start_datecontract_end_daterQs r(rSzContract.__str__s.$$%R(@(@'ATE[E[D\]]r*c|j/|j|jkrtdtdi|jdk(rtt j j|jdj|jjdk\rtjtd|jdk(rtt j j|jdj|jjdk\rtjtd |jd vr0|js#|jtd td iyyy) Nrz(End date must be greater than start dater~ employee_idcontract_statusrr,4An active contract already exists for this employee.r|2A draft contract already exists for this employee.)ryrvdeduction_for_one_leave_amountThis field is required)rrr r%rrmrkfilterrexcludepkcountr wage_typecalculate_daily_leave_amountrrQs r(cleanzContract.cleansq  ! ! -%%(@(@@%(!,V*WX  H ,  '' ,,h(WW UW ''HI   G +  '' ,,g(WW UW ''FG  >>1 14466>)91=U;VW?5 2r*cntjj|jj r|j %|jj j|_|j%|jj j|_|j%|jj j|_ |j%|jj j|_ |j%|jj j|_|j (|j t#j$krd|_|j&dk(rtt(jj|jdj+|j,j/dk\rt1j2t5d|j&dk(rtt(jj|jdj+|j6j/dk\rt1j2t5d t9|t|i||j&dk(rQ|j<E t?|j<}|jj }||_ |j;|S|S#tB$r'tDjGd |j<d Y|StH$r#}tDjGd |Yd}~|Sd}~wwxYw) Nrrr~rrr,rr|rzFailed to convert wage 'z' to an integer.zAn unexpected error occurred: )%rrkrrexists departmentemployee_work_info department_id job_positionjob_position_idjob_role job_role_id work_type work_type_idshiftshift_idrrtodayrrmrrrrr r%rsupersavewageint basic_salary ValueErrorloggererror Exception)rRargskwargswage_int work_infoe __class__s r(rz Contract.save<s " * * 1 1(( 2 &( &"&"2"2"E"E"S"S  ($($4$4$G$G$W$W!}}$ $ 0 0 C C O O ~~%!%!1!1!D!D!Q!Qzz!!--@@II  ! ! -$2H2H4::<2W#,D  H ,  '' ,,h(WW UW ''HI   G +  '' ,,g(WW UW ''FG   d%f%   8 + 0E Ctyy> ,,?? )1 &  t  W 8 CSTV  C =aSABB  CsAK,L4 L4L//L4ceZdZdZgdZy) Contract.Metaz6 Meta class to add additional options )rrrN)rXrYrZr_unique_togetherr\r*r(r]rvs Vr*r])@rXrYrZr_r%COMPENSATION_CHOICESPAY_FREQUENCY_CHOICES WAGE_CHOICESr is_installedr/CONTRACT_STATUS_CHOICESlistr8rk values_listFILING_STATUS_CHOICESr rarrhrrir DateFieldrrr pay_frequency FloatFieldrrPrrrrrrrrrrr IntegerFieldr)notice_period_in_days FileFieldcontract_documentrcdeduct_leave_from_basic_payrrrenoter"r!historyrrOrSrrr] __classcell__rs@r(rmrmxsu 1X; 1X; q' 1X; AiL! >*+ !G* AiL!L t&Xq{34 !G* 1X; AiL! q'   "$ai 1D  , ,T? C5 !  %F$$!$5"6Qz]M$&##..#z] K +&**,H((( AjM!  {^ I %F$$ %' M 6  !N*;$PQ RD%F%%.. ' M'f&&'x[ O #""..  |_ J%6$$..  ~& L!v  ..  z] H F  ..  wZ  E"!!..  {^ I0F//23:'  )((:DPTU"5&"5"5./=># $76#6#656 b $ &7V%6%6 78 &" 6  Tc BD"  G$$QRG^^$L8tVVw  s (.N Nrmc eZdZdZdedfdedfdedfded fd ed fd ed fgZejdddZejddeZ eje ejedZ ejddZejddegddZejddegddZej&dddZej&dddZej,dZejdddZej2dZej2dZej8dZej<ddZe dZ!fd Z"fd!Z#d"Z$xZ%S)# WorkRecordz WorkRecord Model FDPPresentHDPzHalf Day PresentABSAbsentHDzHoliday/Company LeaveCONFConflictDFTr}rT)r@rErA)r@rErDrrKrB)rErAz00:00)rErArrFr@r)rErArFrCr@r?FrFrcVtj|_t||i|yrN)rnow last_updaterrrRrrrs r(rzWorkRecord.saves"#<<>  d%f%r*cxt|d|jcxkrdksntt dy)N?z*Day percentage must be between 0.0 and 1.0)rrday_percentager r%rRrs r(rzWorkRecord.cleans5  d))0S0!!$P"QR R1r*ch|j |jS|jd|jS)N-) record_namework_record_typerrQs r(rSzWorkRecord.__str__s@+    ))*!DII;7 r*)&rXrYrZr_r%rDr rarrrhrrirrrrat_workmin_hourrat_work_secondmin_hour_secondrermessagercis_attendance_recordis_leave_recordrr DateTimeFieldrrrkrrrSrrs@r(rr~s )  $%& (  q()* : '  G#&""cDIK'v''14Q#&##FNN:K 6  T 2Df   G v   H)V((d$JN)f))t4KO 6  s +Df"4tDG.6..u=)f))%8O&V&&q1N&&&&D=K#$QRG& S  r*rr{) Attendancec0eZdZdZeeedZy)OverrideAttendance@ Class to override Attendance model save method senderc |jrnt|j}t|j}|j|k\rdnd}|j durdn|}|dk(r t dn t d}|dk(r||kDr t dn|}tjj|jd|j }tjj|j|j js tnBtjj|j|j j}|j|_ |j|_|j|_|j|_||_||_||_||_d|_|j r||d z kDrd nd |_|j-|dk(r|j.r t d}|dk(r t d}||_|j-|j&}|j$}|j0s d}t d}||_||_|j-yy)zA Overriding Attendance model save method rrFrzValidate the attendance ValidatedzIncomplete minimum hourT)rrrrrr?zHalf day leaverzCurrently workingN) first_saver minimum_hourattendance_worked_hourrattendance_validatedr%rrkrattendance_daterrfirstrrrrrrrrrrattendance_clock_out)r instancerrrstatusr work_records r(attendance_post_savez'OverrideAttendance.attendance_post_savesd """1(2G2G"H!01P1P!Q"*"9"9_"LRW#+#@#@E#Iv4:f4DA/0!K. ?^+K/0  )0077!11)- ( 4 48 &--44%55$,$8$85fhL $++22%55$,$8$83eg+3*>*> '#+#;#;  &.&E&E #'/'<'< $.= +-; */5 ,&- #37 000 .11D D$ .  "U?{'B'B 01GU? lG&- #  "%--$5544"F 34G&- #/5 ,  "#r*N)rXrYrZr_rr rrr\r*r(r r s$ )J /C # 0C #r*r r c tjj|jd|jj y)z; Overriding Attendance model delete method T)rrrN)rrkrrrdelete)r r_kwargss r(attendance_pre_deleter!s; !! ,,!%)) "  &(r*leave) LeaveRequestc<eZdZdZeeefdZxZS)OverrideLeaveRequestr r c 8|j|jk(r<|j|jk7r#|j|_tt |t|j|j}|jdk(rK|D]D} tjj||jjr+tjj||jn t}|j|_ d|_|j|k(r|jdk(s|j|k(r|jdk(rdnd|_|j|k(r|jdk(s|j|k(r|jdk(rdnd }||_||_|d k(rd n t%d |_|j Gy |D]<}tjjd||j j)>y #YxYw)zC Overriding LeaveRequest model save method approvedrT first_half second_halfrrrrrz$Half day Attendance need to validate)rrrN)r0r1end_date_breakdownstart_date_breakdownrr#rr6rrrkrrrrrrrr%rr)r rr  period_datesr work_entryrrs r(leaverequest_pre_savez*OverrideLeaveRequest.leaverequest_pre_save&s ##x'8'88//83P3PP.6.K.K+lH24)(*=*=x?P?PQL*,(*D) *1188%),4,@,@ 9 %fh ' '..55%),4,@,@6",#2:1E1E .59 2 (22d: ( = = M'00D8 ( ; ;} L ! "& #1 (22d: ( = = M'00D8 ( ; ;} L # "' 7= 3*.  &%!"#I!J#* #)Q*Z)D&&--(,!$,$8$8.fh  s EHH) rXrYrZr_rr r#r.rrs@r(r%r% s# (< 0?  1? r*r%c |jjdk(r |jnd}||jj}|s|t }|d|_||_|j r |j ntj|_ |j |jnd|_ |jyyy)z[ This method is used to override the save method for EmployeeWorkInformation Model TNz 's Contractr) r is_activerrrmr date_joiningrrrrrr)r rr active_employeecontract_existscontracts r( employeeworkinformation_pre_saver5os !) 4 4 > >$ FD")66==?zH(7'8 %DH "#2H )1)>)>%%HNNDT  (*2)>)>)J%%PQ M MMO#r*ch|dkrttd|dkDrttdy)z Percentage validator rzRate must be greater than 0dzRate must be less than 100Nr$r&s r(rate_validatorr8s9 qya =>?? s{a <=>>r*equalz Equal (==)notequalzNot Equal (!=)ltz Less Than (<)gtzGreater Than (>)lezLess Than or Equal To (<=)gezGreater Than or Equal To (>=) icontainsContainsr.RangechildrenChildrenmarital_statuszMarital Status experience Experienceemployee_work_info__experiencezCompany ExperiencegenderGendercountryCountrystateStatecontract_set__pay_frequencyrcontract_set__wage_typer$contract_set__department__departmentzDepartment on ContractceZdZdZej dZej deddZej ddde dZ y) MultipleConditionz! MultipleCondition Model rCrTr@rDrErA6The value must be like the data stored in the databaser@rErArN) rXrYrZr_r rafieldCONDITION_CHOICE conditionr%r'r\r*r(rRrRsb F   E!   0t4I F   LM  Er*rRc eZdZdZdedfdedfgZdedfded fgZejd r+d ed fd edfdedfd edfgZ ee z ZdedfgZ e jdddedZ e jddedZe j dededZe j$eedddedZe j$eed d!ded"#Ze j ded$%Ze j ded&%Ze jdedded'(Ze jdedd)Ze jddded*Ze j ded+%Ze j<ddeged,-Z e jddedded./Z!e j<dde"ged0-Z#e j<ddd1eged23Z$e j<ddd1eged43Z%e jLe'e jPdded5Z)e j<dd1deged67Z*e j<dd1deged87Z+e jLe,e jPdded5Z-e j<dd1deged97Z.e j ded:ed;Z/e j<ddeged<-Z0e jd=dd>d>ed?fgd@AZ1e jdBe dedCDZ2e jdBe3dEedFDZ4e j<d1edG%Z5e j<ddedHIZ6e j<ddedJIZ7e jLe8dde jPKZ9e j ddLZ:e j ddLZ;e<Z=e j$e>ddMZ?GdNdOZ@dPZAfdQZBdRZCdSeDfdTZEfdUZFxZGS)V Allowancez Allowance model ignorezExclude the allowance max_amountProvide max amountr9r:rBrCr{overtimeOvertimerrrrrrCFzTitle of the allowancerUTz{The one-time allowance in which the allowance will apply to the payslips if the date between the payslip periodrErArInclude all active employeesz7Target allowance to all active employees in the companyrEmployees Specificallowance_specificz*Target allowance to the specific employees)rBrArrExclude Employeesallowance_excludedzqTo ignore the allowance to the employees when target them by all employees or through condition-basedrBrrArz6This field is used to calculate the taxable allowancesrFrzThis field is used to target allowance to the specific employees when the condition satisfies with the employee's information"The related field of the employeesr@rDrErArrSrTz)To specify, the allowance is fixed or notzFixed amount for this allowancerErArrzGIf the allowance is not fixed then specifies how the allowance provided)r@rFrDrErArThe percentage of based onrz8The attendance fixed amount for one validated attendance)rErArFrrzThe fixed amount per childrenrKrErArBz=The fixed amount for one validated attendance with that shift)rErFrArrzjThe fixed amount for one hour overtime that are validated and approved the overtime attendancezAThe fixed amount for one validated attendance with that work typezHas max limit for allowancezLimit the allowance amountz$The maximum amount for the allowancermonth_working_daysFor working days on monthThe maximum amount for ?r@rErFrDr !The pay head for the if conditionr@rDrFrr<3Apply for those, if the pay-head conditions satisfyThe amount of the pay-head&The start amount of the pay-head rangerArEr$The end amount of the pay-head rangerIrFrJrArJc(eZdZdZgdZedZy)Allowance.Meta3 Meta class for additional options )title is_taxableis_condition_basedrVrXr'is_fixedamountrbrateper_attendance_fixed_amountrshift_per_attendance_amountamount_per_one_hrrwork_type_per_attendance_amountrZN)rXrYrZr_rr%rBr\r*r(r]r|s  $~ r*r]cBgd}|D]}t||dd|_y)z5Reset the this fields when is_fixed attribute is true) rbrrrrrrrmaximum_amountNF)setattr has_max_limit)rRattributes_to_reset attributes r(reset_based_onzAllowance.reset_based_ons/  - +I D)T * +"r*cTt||j|jsd|_d|_d|_|js |jsttd|js;|jr/|jdk(r |jsttd|jr8|jr|j r |j sttd|jdk(r"|jstdtdi|jdk(r |jsttd |jd k(r |jsttd |jd k(r |jsttd |jr%|j dkrtdtdi|j"r"|j$tdtdi|j"sd|_yy)NFIf the 'Is fixed' field is disabled, the 'Based on' field is required.r9z9Rate must be specified for allowances based on basic pay.zHIf condition based, all fields (field, value, condition) must be filled.r{rbzcIf based on is attendance, then per attendance fixed amount must be filled.rz0If based on is shift, then shift must be filled.rz8If based on is work type, then work type must be filled.rBz'The amount per children must be filled.rrz#Amount should be greater than zero.rr)rrclean_fixed_attributesrrVrXr'rrbr r%rrrrper_children_fixed_amountrrrrs r(rzAllowance.cleans   ##%&&DJ!DNDJ}}==%` }}4==K3O99%QR  " "::TZZt~~%b ==L (1Q1Q!J!  ==J &t}}!!$V"WX X ==N *43D3D!LM  ==J &t/M/M!!$M"NO O ==T[[1_!8Q/T-U"VW W   $"5"5"=!#3Q7O5P"QR R!!"&D "r*c|jsd|_|jr3|jtdtdi|j yy)zUClean the amount field and trigger the reset_based_on function based on the conditionNrr)rrr r%rrQs r(rz Allowance.clean_fixed_attributessH}}DK =={{"%x3K1L&MNN    ! r*rLc,t|jSrNrOr~rQs r(rSzAllowance.__str__4::r*ct||js>|jj s#|j sd|_t|yyyyNTrrinclude_active_employeesspecific_employeesrrrs r(rzAllowance.saveP  --++113++,0D ) GLN,4.r*)HrXrYrZr_r% exceed_choicer`rrattendance_choicesif_condition_choicer rar~r one_time_datercrManyToManyFieldrrexclude_employeesrr FIELD_CHOICErVrWrXr'rrr)rrbr8rrrrhrrirrrrrrrr maximum_unit if_choiceIF_CONDITION_CHOICE if_condition if_amount start_range end_rangerrjonly_show_under_employeeis_loanrrkrRother_conditionsr]rrrrOrSrrrs@r(rZrZs 1,-. q-./M a n% Qz]#O t& : ' 7 $ Q{^ , 1\? +   -- a n% F  U%1=U;V E%F$$  4 M 3v2256MN  0//+,)@A /..*+) ( %$$LMJ-,, `  F   89  E!   0t4I F   LM  E#v"""M NHV   :56 F v  U H 6     01  D#4&"3"3 :NO #!2 1 1 :34 !!v  .. wZ H#4&"3"3 :ST #*)) : 2 %6$$.. {^ L'8f&7&7 : O '#(F''4501M 'V&& ::; N $6## $%-.  - L!  #78 I $6###IJ L "!!"> ?I$&##+S)TK"!!+Q)RI#""dUfnnJ 3v2255Q!f!!%%@G#%G-v--&&2#"2'h"r*rZc ~eZdZdZdedfdedfgZdedfdedfdedfded fgZd ed fd ed fgZejdedZ ejddedZ ejdededZejeeddeddZejeedddedZejded !Zejded"!Zejded#!Zejdedded$%Zejdedd&Zejddded'(Zejddd)ded*fdedfded fged+,Zejded-!Zej:ddeged./Zejdedded0%Z ej:ddd1e!ged2ed34Z"ej:d1e!g5Z#ejded6ed7Z$ej:ddeged8/Z%ejd9dd:d:ed;fged<=Z&ejd)eded>?Z'ejd)e(d@edA?Z)ej:d1edB!Z*ej:ddedCDZ+ej:ddedEDZ,ejZe.ddej^FZ0ejddGZ1e2Z3ejddGZ4eje5ddHZ6dIZ7fdJZ8dKZ9dLe:fdMZ;fdNZ<xZ=S)O Deductionz Deduction model r9r:r;r<r=r>net_payzNet Payr[zExclude the deductionr\r]rCzTitle of the deduction)r@rTz{The one-time deduction in which the deduction will apply to the payslips if the date between the payslip periodr`Fraz7Target deduction to all active employees in the companyrrbdeduction_specificz*Target deduction to the specific employees)rBrrrArddeduction_excludezqTo ignore the deduction to the employees when target them by all employees or through condition-basedrfz3To specify the deduction is tax or normal deductionrgzfTo find taxable gross, taxable_gross = (basic_pay + taxable_deduction)-pre_tax_deductions zThis field is used to target deduction to the specific employees when the condition satisfies with the employee's informationrhrirSrTrUrqz Basic payzoUpdate compensation is used to update pay-head before any other deduction calculation starts)rErAr@rDrz)To specify, the deduction is fixed or notzFixed amount for this deductionrjzGIf the deduction is not fixed then specifies how the deduction providedrz Employee raterk)rErArFrrBr)rFrzHas max limit for deductionzLimit the deductionz$The maximum amount for the deductionrrmrnrorprrrsr<rtrurvrwrxrIryrzcbtjj|j}|S)zR Method to retrieve the payslip associated with this installment. installment_ids)Paysliprkrr)rRpayslips r(installment_payslipzDeduction.installment_payslips)//(((>DDFr*c t||jrd|_|js,|j s |j sttd|js,|j r |jsttd|jr$|j dvrtdtdi|jr$|j dvrtdtdi|jr$|j dvrtdtd i|jsd|_ nd|_d|_ |j|jr"|jtd td i|jr:|jr|j r |j"std td i|j 0|jr#|jtdtdiyyy)NFrzHEmployee rate must be specified for deductions that are not fixed amount)r=rbz7 Don't choose taxable gross pay when pretax is enabled.)rz- Don't choose net pay when pretax is enabled.z. Don't choose net pay when the tax is enabled.rzThis fields requiredrzdIf condition based, all fields (field, value, condition) must be filled.rr)rris_tax is_pretaxrrbupdate_compensationr r%rrclean_condition_based_onrrrrVr'rXrs r(rzDeduction.cleans   ;;"DN}}==)A)A%` }}tyy!^  >>dmm/DD!Q!  >>dmm{:!QNOP  ;;4==K7!QOPQ }}DK DMDI %%'   ""*%'7;Q9R&STT  " "::TZZt~~%,aG/  # # +}};;&)8Q7O5P*QRR' ,r*cH|jsd|_d|_d|_yy)z\ Clean the field, condition, and value attributes when not condition-based. N)rrVrXr'rQs r(rz"Deduction.clean_condition_based_on)s'&&DJ!DNDJ'r*rLc,t|jSrNrrQs r(rSzDeduction.__str__2rr*ct||js>|jj s#|j sd|_t|yyyyrrrs r(rzDeduction.save5rr*)>rXrYrZr_r%rr`rr rar~rrrcrrrrrrrrrrVrWrXr'rrrr)rrbr8r employer_raterrrrrrrrrrhrrirjrrrkis_installmentrRrrrrrOrSrrrs@r(rrs' a n% a n% a n% a n% a 345 AiL! O 1,-. q-./M F  q9Q7R SE$F$$  4 M 3v2256MN  0//+,)@A /..*+( ( !V IJF $## Q I-,, `  F   89  E!   0t4I F   LM  E +&** + !K. ) ) %   K "#v""?@H V   :56 F  v  U H 6     '01 D&F%%  M (F''45)*M 'V&& ::; N$6## $ !1%@#A B ./ L!  #78 I $6###IJ L "!!"> ?I$&##+S)TK"!!+Q)RI#""dUfnnJ 3v2255Q#%G(V((GN-v--:Sxr*rc.eZdZdZdedfdedfdedfded fgZejd d d ed  Zejddd d Z eje ejedZ ejZejZej"Zej&d dZej&d dZej&d dZej&d dZej&d dZejdd deZej4d dZedZej<edZ e!de"gZ#de$fdZ%fdZ&fdZ'dZ(d Z)d!Z*d"Z+Gd#d$Z,xZ-S)%rz Payslip model r|r}review_ongoingzReview Ongoing confirmed ConfirmedpaidPaid2Tz Batch name)r@rErArBrCF)r@uniquerErArrr)rErFr)r@rErFrDrrJrrrLcTd|jd|jd|jS)N Payslip for z - Period:  to rr0r1rQs r(rSzPayslip.__str__gs.d../{4??:K4PTP]P]__r*c4t|tj}|j|j krt dtdi|j|kDrt td|j |kDrt tdy)Nr1z mT:F+v**eD#$QRG,f,,YGO"  G``P & 0    3   r*rceZdZdZdedfdedfdedfgZejded Zejd Z eje ejed  Z ejdedZej Zejeej&ddZej*ddZej.edZej4ddZejddZejedddZej<edZej dZ ejdd dZ!ej4d Z"ejFd!Z$e%jLd"r!ejd#ejddd$Z'e(d%Z)d&Z*d'Z+fd(Z,d)Z-fd*Z.xZ/S)+ LoanAccountz> This modal is used to store the loan Account details loanLoanadvanced_salaryzAdvanced SalaryfinezPenalty / Fine)rFrDr@rrrrrAmount)rFrBFT)rKrJrErCrEr@rryzinstallment Amount)rBrArEzTotal installmentsrz(From the start date deduction will apply)r end_of_month)rFr@rJrrGassetz asset.Asset)rKrArErJrc8|jd|jS)Nr)r~rrQs r(rSzLoanAccount.__str__s**S!1!1 233r*c|j}|j}||z }|j}i}|}i}t|D]}||t |<t |}|S)z Method to calculate installment schedule for the loan. Returns: dict: A dictionary representing the installment schedule with installment dates as keys and corresponding installment amounts as values. ) loan_amount installmentsinstallment_start_dater.rOr)rRrtotal_installmentsinstallment_amountrinstallment_scheduleinstallment_dater%s r(get_installmentszLoanAccount.get_installmentss&& !..(+==!%!>*#dV4K+0K(KK $K+/K(!%K+0K(""&&x';';< r*c g}d}tjdr|jdnd}|r|r|jdk7rt }|j |_|j|_d|_|j |_d|_ d|_ |j|_ d|_ |jd|_|jj!|j"|j||_t&t(|;y|j*j-dd}t.j0j3|}|D cgc]$} |j3| j5s| &} } |j7} |s|j8s~t:j0j3| j=| j?D]#\} } tA|| | }|jC|%|j*j |y|j8r/t:j0j3| j=y| s| j?D]i\} } t:j0j3| |j"d|j j5rLtA|| | }|jC|k|j*j |yycc} w) z+ Post save method for loan account TrNFrrrrr)id__in)rrrr~)"rrrrrZrrr~rrrrrrrrrrr rrrrrrkrrrrrritemsrr/)r rcreatedrrrr deductionspayslips_with_deductions deduction_idbalance_deductioninstallment_dictrrrs r(create_installmentsr$6s L E ! ))1u5X]]f4{** ^^ (-%** (,% %33  (-% ##H$8$89 $ k8)+++7747H #*??#9#9 *$:$  !+ +22 ,3fh   $446'0@0@    $ $J $ 7 > > @"'') 1 "002B ##K0 1 'H " " & & 5        $ $,= $ > E E G%&++-9$&$,,33&6+3+?+?'+&nn 4 fh  '9$&8:J' %++K89 +&&**L9#%9 s)K)cXeZdZdZej dZejZy)ReimbursementMultipleAttachmentz0 ReimbursementMultipleAttachement Model payroll/reimbursementsrN) rXrYrZr_r r attachmentManagerrkr\r*r(r&r&s*"!!,DEJfnnGr*r&c FeZdZdZdedfdedfgZejdrejdedfded fd ed fd ed fgZ e jdZ e jeddZ e jee j dZe j$Ze j(ddZe j,eddZejdr'e jde j ddedZe j4dededZe j4ded ed!Ze j:ded"ed#Ze j4d$Ze jd%e dd&Z e jee jBdd'd(Z"e jFdd)*Z$e je%e jBdd+Z&e'd,Z(Gd-d.Z)d2fd/ Z*fd0Z+d1Z,xZ-S)3 Reimbursementz Reimbursement Model reimbursementbonus_encashmentzBonus Point Encashmentr"leave_encashmentzLeave Encashment requested Requestedr'ApprovedrejectedRejectedrr)rDr@rFrrr'T)rrEFrzzleave.LeaveTypez Leave type)rKrArErBrzAvailable Days to encashzAvailable days)rFrrBzCarry Forward Days to encashzCarry forward dayszBonus points to encashz Bonus pointsrrq)r@rDrFrJ approved_by)rKrErrJrCr)rKrErJrceZdZdgZy)Reimbursement.MetarVNrWr\r*r(r]r8r^r*r]c ttjdd}tjj r(tjj j nd}tjj r(tjj jnd}|jjd}|s|jj|_ |jdk(r|j tddi|jdk(r|j tddi|jdk(r|j d k(r!|j"|j$z|z|_t)t+|j"d zd z d |_t)t+|j$d zd z d |_|jj,j/|j j }|jd k(r#|j d k(r|j0|z|_|j dk7s |j2 t5|l|i||j dk(rg|j2Z|jdk(rd}nr|jd k(rd}t8jj;|j } | j<|j0k\r9d}| xj<|j0zc_d| _| j7nttjdd}|rtAjB|dnd}r|jD} |jF} | |j$k\rJ| |j"k\r;d}| |j$z |_"| |j"z |_#|j7n,>,B&Ca&G!!LD  #U4+<+->-F99/"GYY"44#G#-#5#5#9#9dFVFV#9#WL#**d.B.BB"&$++t/C/CC+.O +$))+")/>> 4##$MM ' [ $G%)7)F)F,:,L,L)*d.?.?? 1T5G5G G&*G .1B1B B+9!2D4F4F F+<+//1&- 3 B BIt'G ' ( $+$%)K%&!"$-KM262C2CM/*.**M'=AM:=BM:+/;;M(!&&(=BM:!44889I9IJ!&&((5D%+2<<+D+D("-DK d-f- *t/@/@/L--!%!2!299 22%*99NJ'5+< is in approved state, it cannot be deletedzReimbursement deleted) rrr<rrrLr%r~r rrsuccess)rRrrr:rrs r(rzReimbursement.deleteLs-<DfnnGr*r^c(eZdZdZej eejZej e ejZ ejde ddZ ejedZej"de dd Zd efd Zy ) ReimbursementrequestCommentz+ ReimbursementRequestComment Model )rKTCommentrC)rErBr@)rAz Created At) auto_now_addrBrErLc|jSrN)commentrQs r(rSz#ReimbursementrequestComment.__str__~s,, r*N)rXrYrZr_r rhr,CASCADE request_idrrrer%rerr^filesr created_atrOrSr\r*r(raraos#""=FNNKJ#&##HGKfDq|PSTG "F " "#4D AE%%%|_ J !!r*raczeZdZdZej degdZeje ejdZ y)PayrollGeneralSettingz PayrollGeneralSetting zNotice period in daysr?)rrrFT)rKrEN) rXrYrZr_r rr) notice_periodrhrrfrjr\r*r(rkrksB(F''):M #""7fnn4PJr*rkceZdZdZej dZej dddZejZ y)r=z) BonusPointGeneralSettings model r,rTr)rArErBN) rXrYrZr_r rr?r>r*rkr\r*r(r=r=s?'6&&q1L&6&&T8TLfnnGr*r=zlast dayzLast Day)11st)22nd)33rd)44th)55th)66th)77th)88th)99th)1010th)1111th)1212th)1313th)1414th)1515th)1616th)1717th)1818th)1919th)2020th)2121th)2222th)2323th)2424th)2525th)2626th)2727th)2828th)2929th)3030th)3131thceZdZdZej dedddZejdZ eje ejd d d Z d Zfd ZdefdZxZS)PayslipAutoGeneratez4 Model for generating payslip automatically r?rnzPayslip Generate Dayz5On this day of every month,Payslip will auto generate)r@rDrFrBrFrTrrlcV|jstjjdj rn|j s t dditjjdj}|j |j k7r t ddiyyy)N)rjrjz9Auto payslip generation for all company is already exists)rjrrkrrrr r)rRall_company_auto_payslips r(rzPayslipAutoGenerate.cleans#++22d2CJJL77%$&a (;'B'B'I'I(J(eg %(**dgg5%$&a6M r*cVddlm}|jr|t||i|y)Nr)auto_payslip_generate)payroll.schedulerr auto_generaterr)rRrrrrs r(rzPayslipAutoGenerate.saves&;    ! #  d%f%r*rLc:|jd|jdS)Nz |  ) generate_dayrjrQs r(rSzPayslipAutoGenerate.__str__s!##$C'8::r*)rXrYrZr_r raDAYSrrcr OneToOneFieldrrfrjrrrOrSrrs@r(rrsv$6##+I L(F''6M%%%6>>DyJ,&;;r*r)_r_rloggingrrrdjangor django.appsrdjango.contribrdjango.core.exceptionsr django.dbr django.db.models.signalsr r r django.dispatchr django.httpr django.utilsrdjango.utils.translationrr%base.horilla_company_managerr base.methodsr base.modelsrrrrrrr!employee.methods.duration_methodsremployee.modelsrrrhorillarhorilla.modelsr horilla_audit.modelsr!r" getLoggerrXrr)r6r8rmModelrrattendance.modelsrr r! leave.modelsr#r%r5r8rWrrrRrZrrrrr$r&r,rkrrupdater^rarkr=rrr\r*r(rs ..#2DD$!!6>1>II''B   8 $ D4'<'TCV|CVL? ? D4\",J#ZJ#Xj, - 4W)F|F^ (234.? a o#$% 1_  1  ! 1 ) *+ 1 , -.!J-  a o#$% 1_  1  ! 1 ) *+ 1 , -. aj:q)*+1\?#%q)='>? q{)  aj"Ao$67+/+Q/G-HI   &X Xv ^ ^B x lx vg&,g&T" )K(K:)K:\fllQLQj ##:#6==?$$J$7>>j>Q   !,!& QFLL Q !:!!! !  !  !!!!!!!!!! !!"#!$%!&'!()!*+!,-!./!01!23!45!67!89!:;!<=!>?!@A!H0;&,,0;o s ANN