ygjddlZddlmZddlmZmZddlZddl Z ddl Z GddejZ y)N)settings) migrationsmodelsc*4XeZdZdZdddddej ejdgZgejdgd e jddd d fd e jdddfde jddfde jddfde jdddfde jd ddfde jdd fd!e jd d" fd#e jdgd$d%dd&fd'e jdgd(dd)fd*e jdd+dd,fd-e jdd. fd/e j dd0dejjj$g1fd2e jdgd3d4d5dd6fd7e j dd8dejjj&g1fd9e j dd:d;dejjj$g<fd=e j dd:d>dejjj$g<fd?e j dd:d@dejjj$g<fdAe j dd:dBdejjj$g<fdCe j dd:dDdejjj$g<fdEe jd dFdGfdHe j ddIdejjj$g1fdJe jdKgdLdMdNdOfdPe jdQgd4dRdSTfdUe jgdVdWdXdSTfdYe j d:dZ fd[e j dd\dfd]e j dd^dfd_e jd d `fdae jd d `fdbe j(d dej,jj.j0dcdfdee j(dd dej,jj.j2ejdfgfdhe j4ddidjdkdlmfdne j(dd dej,jj.j2doejdpqfdrdisejdtd e jddd d fd e jdddfde jddfdue jdvdwdtxfdye jdz{fd|e jddd}~fde jgdddwdfde jgdddNddfde j dddfde jgdddwdfde j6ddejjj$gdfde j8dddfde jdddfde jdddfde j ddddfde j:dddfdee j(dd dej,jj.j2ejdfgfde j(ddej,jj.j0dddfde j(ej,jj.j0ddkdfgejdgd e jddd d fd e jdddfde jddfde jddfde jdddfde jd ddfde jd d fde jdd fd!e jd d fd#e jdgd$d%dd&fd'e jdgd(dd)fd*e jdd+dd,fde jdgdddSd&fd-e jdd fd/e j dddejjj$g1fd2e jdgdddd&fd7e j dd:d8dejjj&gdfde j d:ejjj&gfdEe jd dd¬fdHe j dddejjj$g1fdJe jdKgdLdMdNdOfdPe jdQdgd4dRdSTfdUe jgdVdWdXdSTfdYe j d:dZ fd[e j dd\dfd]e j dd^dfd_e jd d `fde jd d `fdbe j(d dej,jj.j0dcdfdee j(dd dej,jj.j2ejdfgfdhe j4ddddkdlmfdne j(dd dej,jj.j2doejdpqfdd isejdd e jddd d fde j6dˬ̫fde j6dddά~fgejdd e jddd d fd e jdddfde jddfde jddѬҫfd2e jgdӢdddլfde jd d׬fde j:d٫fde j:ddd۬ܫfdbe j(d dej,jj.j0dcdfdee j(dd dej,jj.j2ejdfgfdne j(dd dej,jj.j2doejdpqfg ddgisejdd e jddd d fd#e jdfd'e jdgd(dd)fd*e jdd+dd,fgejdde j<dej,jj.j>ddd dfgdd idejdde j<dej,jj.j>ddd dfgdd idejdd e jddd d fd e jdddfde jddfde jdfde jgdddfde jfde j8ddfde j dddfde j dddfde j6dddfd/e j d̫fde jgddd dSfde j:ddfde j(d dej,jj.j2ddfde j(d dej,jj.j2ddkfdee j(dd dej,jj.j2ejdfgfde j(ej,jj.j0dkdfd e j(ddej,jj.j0d d  fdne j(dd dej,jj.j2doejdpqfgddgisejd d e jddd d fde j8dfgejdd e jddd d fde j8dfgejdd e jddd d fde jddwdfde jgdddfde jddfde jdddde jjBgfde jdddde jjBgfde j6dddfd e j6dddfde j:dfd!e jdddfd"e jd ̫fd#e jd ̫fd$e j d̫fd%e jddfde j(ej,jj.j0dkdfgejd&d e jddd d fd e jdddfde jddfd'e j d({fd)e j ddd*~fd+e j d:d,fdee j(dd dej,jj.j2ejdfgfd-e j(ej,jj.j>d.dѐfdne j(dd dej,jj.j2doejdpqfg dd isejd/d e jddd d fde jddfd0e j:ddd12fd e jdddfdee j(dd dej,jj.j2ejdfgfde j(ej,jj.j>dk3fd4e j4dd56fdne j(dd dej,jj.j2doejdpqfd7e j(ej,jj.j>d83fg dd isejDdd9e j4dd d:;<ejd=d e jddd d fd>e jgd?d@dAddBCfdDe jd ̫fdbe j<ddej,jj.j>dcdE fgejdFd e jddd d fd e jdddfde jddfdGe jddddHIfdJe jdddfdKe jfdLe jfdMe jFfdNe j ddOfd4e j ddOfdPe j ddOfdQe j ddOfdRe j ddOfde jgdSddNdTfdUe jd dOfdee j(dd dej,jj.j2ejdfgfde j(ej,jj.j0dkdfdVe j4d dWXfdne j(dd dej,jj.j2doejdpqfgdݐdYgisejdZd e jddd d fd e jdddfde jddfd[e jd\dd]fd^e jd_d`gdadbdTfdbe j(dej,jj.j0dccfdee j(dd dej,jj.j2ejdfgfdne j(dd dej,jj.j2doejdpqfgdd isejddd e jddd d fdee j6ddfejjj$ggfdbe j(dej,jj.j>dccfgejdhd e jddd d fd e jdddfde jddfde jgdidjdbfde jdNfdke j ddάfdle jfde j:ddfd-e jdd `fd7e j dd `fdme j dddn~fdoe j6dp{fdqe jdrsfdte jdud dNvfdwe jd ̫fdxe jd٫fde j(d dej,jj.j2ddfdye j(dd dej,jj.j0dz{fdee j(dd dej,jj.j2ejdfgfd|e j4d dWXfde j(ej,jj.j0dkdfdne j(dd dej,jj.j2doejdpqfgdd isejd}d e jHdddd ~fd e jdd ddfde jddfde jddNdfde j:d٫fde jd dOfdGe jddddHIfdJe jdddfdKe jfdLe jfdMe jFfdNe j ddOfd4e j ddOfdPe j ddOfdQe j ddOfdRe j ddOfde jgdSddNdTfdUe jd dOfde jJdd fde jdfde jddfde jgddːfdee j(dd d dej,jj.jLdejdffde j(dd dej,jj.jLddkdfde j(d ej,jj.jLddfde j4dfde j(dej,jj.j2dejfdne j(dd d dej,jj.jLdejdpfgddddde'jjPe jRfejdgd e jHdddd ~fd e jdd ddfde jddfde jddNdfde j:d٫fde jd dOfdue jdvdwdtxfdye jdz{fd|e jddd}~fde jgdddwdfde jgdddNddfde j dddfde jgdddwdfde j6ddejjj$gdfde j:dddfde jdddfde jdddfde j ddddfde j:dddfde jJdd fde jdfde jddfde jgddːfdee j(dd d dej,jj.jLdejdffde j(dd dej,jj.jLdddfde j(dd dej,jj.jLddkdfde j(dd dej,jj.jLdd.dfde j(d ej,jj.jLddfde j4dfde j(dej,jj.j2dejfde j(dd dej,jj.jLdddfde j(dd dej,jj.jLdddfdne j(dd d dej,jj.jLdejdpfde j(dd dej,jj.jLdddfde j(dd dej,jj.jLdddfddddde'jjPe jRfejDdQde j4dd d;<ejDdQde j4ddddkdm<ejDdde j(ddej,jj.j0dd.d<ejDdde j(ddej,jj.j0ddd<ejDdde j(ddej,jj.j0ddd<ejDddne j(dd dej,jj.j2doejdpq<ejDdde j(ddej,jj.j0ddd<ejDdde j(ddej,jj.j0ddd<ejDdde j4dd d;<ejDdde j(ddej,jj.j0dd <ejDdde j4ddddkdm<ejDdde j(ddej,jj.j0dd <ejTddhejTddhZ+y( MigrationT)employee 0001_initial)assetr )leaver ) horilla_auditr )baser ) attendancer AllowanceidFID) auto_created primary_key serialize verbose_name created_atz Created At) auto_now_addnullr is_activez Is Active)defaultrtitlezTitle of the allowance) help_text max_length one_time_datez{The one-time allowance in which the allowance will apply to the payslips if the date between the payslip period)blankrrinclude_active_employeesz7Target allowance to all active employees in the companyzInclude all active employees)rrr is_taxablez6This field is used to calculate the taxable allowances)rris_condition_basedzThis field is used to target allowance to the specific employees when the condition satisfies with the employee's informationfield) childrenChildren)marital_statuszMarital Status) experience Experience)employee_work_info__experiencezCompany Experience)genderGender)countryCountry)stateState)contract_set__pay_frequency Pay Frequency)contract_set__wage_type Wage Type)$contract_set__department__departmentzDepartment on Contractz"The related field of the employees)r choicesrrr condition)equalz Equal (==)notequalzNot Equal (!=)ltz Less Than (<)gtzGreater Than (>)lezLess Than or Equal To (<=)gezGreater Than or Equal To (>=)) icontainsContains)r r7rrvaluez6The value must be like the data stored in the database)r rrris_fixedz)To specify, the allowance is fixed or notamountzFixed amount for this allowance)r rr validatorsbased_on) basic_payz Basic Payr%)overtimeOvertime)shift_idShift) work_type_id Work Type)r AttendancerMzGIf the allowance is not fixed then specifies how the allowance provided)r r7rrrrratezThe percentage of based onper_attendance_fixed_amountgz8The attendance fixed amount for one validated attendance)r rrrrJper_children_fixed_amountzThe fixed amount per childrenshift_per_attendance_amountz=The fixed amount for one validated attendance with that shiftamount_per_one_hrzjThe fixed amount for one hour overtime that are validated and approved the overtime attendancework_type_per_attendance_amountzAThe fixed amount for one validated attendance with that work type has_max_limitzLimit the allowance amountzHas max limit for allowancemaximum_amountz$The maximum amount for the allowance maximum_unit)month_working_dayszFor working days on monthr^zThe maximum amount for ?)r7rrrr if_choicerLz!The pay head for the if condition )r7rrr if_condition)r9r;r=r?rArC)rangeRanger@z3Apply for those, if the pay-head conditions satisfy if_amountzThe amount of the pay-head start_rangez&The start amount of the pay-head range end_rangez$The end amount of the pay-head rangeonly_show_under_employee)reditableis_loan company_idz base.company)rir on_deleteto created_byz Created By)r rirrlrmrexclude_employeeszqTo ignore the allowance to the employees when target them by all employees or through condition-basedallowance_excludedzemployee.employeezExclude Employees)r r related_namermr modified_byz%(class)s_modified_byz Modified By)r rirrlrqrmrr)namefieldsoptionsContract contract_namezContract Title.)rrrcontract_start_datez Start Date)rcontract_end_datezEnd Date)r rr wage_type))dailyDailymonthlyMonthly)hourlyHourlyrr5)r7rrr pay_frequency))weeklyWeeklyr~) semi_monthlyz Semi-Monthlyr3)r7rrrrwagerz Basic Salary)rrrcontract_status)draftDraft)activeActive)expiredExpired) terminated TerminatedrStatusnotice_period_in_dayszNotice period in total days.z Notice Period)rrrJrcontract_documentzuploads/)r r upload_todeduct_leave_from_basic_payz'Deduct the leave amount from basic pay.zDeduct From Basic Paycalculate_daily_leave_amountzTLeave amount will be calculated by dividing the basic pay by number of working days.zCalculate Daily Leave Amountdeduction_for_one_leave_amountzDeduction For One Leave Amount)r rrrnote)r rr department contractszbase.department Department)r rrlrqrmr employee_id contract_setEmployee)rlrqrmr)rsrt DeductionzTitle of the deductionz{The one-time deduction in which the deduction will apply to the payslips if the date between the payslip periodz7Target deduction to all active employees in the companyis_taxz3To specify the deduction is tax or normal deduction is_pretaxzfTo 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 informationupdate_compensation))rMz Basic pay gross_payz Gross Paynet_payzNet PayzoUpdate compensation is used to update pay-head before any other deduction calculation startsz)To specify, the deduction is fixed or notzFixed amount for this deduction)rLrtaxable_gross_payzTaxable Gross PayrzGIf the deduction is not fixed then specifies how the deduction providedz Employee rate)r rrrrJr employer_rate)rrJzLimit the deductionzHas max limit for deductionz$The maximum amount for the deductionris_installmentzqTo ignore the deduction to the employees when target them by all employees or through condition-baseddeduction_excludeabstractEncashmentGeneralSettings bonus_amount)r leave_amountAmount FilingStatus filing_statusz Filing status)rr)rLrrrzBased onuse_pyz Python Code python_code)r description Description)r rrorderingz-idMultipleCondition)rOverrideAttendanceattendance_ptrattendance.attendance)rrl parent_linkrrrm)r)rsrtrubasesOverrideLeaveRequestleaverequest_ptrleave.leaverequest)r Reimbursement2type)) reimbursementr)bonus_encashmentzBonus Point Encashment)leave_encashmentzLeave Encashmentr)r7rr allowance_on attachmentzpayroll/reimbursements)rr ad_to_encashzAvailable Days to encashzAvailable days cfd_to_encashzCarry Forward Days to encashzCarry forward daysbonus_to_encashzBonus points to encashz Bonus pointsstatus)) requested Requested)approvedApproved)rejectedRejectedr)r7rrir)rr allowance_idzpayroll.allowance approved_by)rirrlrqrm)rlrmr leave_type_idzleave.leavetypez Leave type)r rrlrmrReimbursementFilefilezpayroll/request_files)rReimbursementMultipleAttachment WorkRecord record_namework_record_type))FDPPresent)HDPzHalf Day Present)ABSAbsent)HDzHoliday/Company Leave)CONFConflict)DFTr)r7rrdate)r rat_workz00:00)r rrrrJmin_hourat_work_second)r rrmin_hour_secondmessageis_attendance_recordis_leave_recordday_percentage last_update TaxBracket min_incomez Min. Income max_incomez Max. Incometax_ratezTax Ratefiling_status_idzpayroll.filingstatusReimbursementrequestCommentcommentComment)rrr)rlrmfileszpayroll.reimbursementfile)r rm request_idzpayroll.reimbursementother_attachmentsz'payroll.reimbursementmultipleattachment)r rirm) model_namersr$PayslipAutoGenerate generate_day) )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)3131thrz5On this day of every month,Payslip will auto generatezPayslip Generate Day)r7rrrr auto_generateCompanyPayslip group_namez Batch name)r rrr reference start_dateend_date pay_head_data contract_wage)rrr deductionr)r)review_ongoingzReview Ongoing) confirmed Confirmed)paidPaid)r7rrrsent_to_employeeinstallment_idszpayroll.deduction)rirmz -end_datePayrollSettingscurrency_symbol$)rrrposition)prefixPrefix)postfixPostfixrW)rrlrmPayrollGeneralSetting notice_periodzNotice period in days)rrrJ LoanAccount))loanLoan)advanced_salaryzAdvanced Salary)finezPenalty / Finer] loan_amount provided_dateinstallment_amountzinstallment Amount installmentszTotal installmentsinstallment_start_datez(From the start date deduction will apply)rapply_on end_of_month)rrirsettled settled_dateasset_idz asset.asset)r rirrlrm deduction_idsHistoricalPayslip)rr db_indexr)r rirr history_titlehistory_descriptionhistory_highlight history_id)rr history_date)rmhistory_change_reasond history_type))+Created)~Changed)-Deleted)r7rrv)r db_constraintrirrlrqrmr)r r|rrlrqrmrhistory_relation history_setzpayroll.payslip)r|rlrqrm history_tagszhorilla_audit.audittag)rm history_user)rrlrqrmzhistorical payslipzhistorical payslips)z -history_datez -history_id)rrrq)rverbose_name_pluralr get_latest_byHistoricalContractz Filing Statuszpayroll.contract job_positionzbase.jobpositionz Job Positionjob_rolez base.jobrolezJob Roleshiftzbase.employeeshiftrQ work_typez base.worktyperSzhistorical contractzhistorical contractsother_conditionszpayroll.multipleconditionspecific_employeesz*Target deduction to the specific employeesdeduction_specificzEmployees Specificcontract allowancerPz*Target allowance to the specific employeesallowance_specificrR)rryrz)rsunique_together)rr"r#r$r8rGrHrIrKrUrVrPrXrYrRrZN),__name__ __module__ __qualname__initialrswappable_dependencyrAUTH_USER_MODEL dependencies CreateModelr BigAutoField DateTimeField BooleanField CharField DateField FloatFieldpayrollmin_zerorate_validator ForeignKeydjangodbdeletionPROTECTSET_NULLManyToManyField IntegerField FileField TextField OneToOneFieldCASCADEr validate_time_formatAddField JSONFieldBigIntegerField AutoField DO_NOTHINGsimple_historyHistoricalChangesModelAlterUniqueTogether operations3/var/www/horilla/payroll/migrations/0001_initial.pyrr s6=G %!!) ' ''(@(@A&L| #*v**$Z_nrst#3v33D_klm#1f11$[YZ#*&**5MZ]^_ # !"2&"2"2JGNR#ST # ,-@V-@-@[TcA.BC #2v224LD EF#&':v':':5U\(]^#*&**@zFjwzAEFG#.f..TD\ilswxy#*&**AyGJQUVW#0V00Ituv#,6,,4Cdko~E~L~L~S~S~\~\}]^_#-V--DCgq|HQ^ahlmn#***A]dhv}wEwEwLwLw[w[v\]^# /0A0A0AVYf`gky@yGyGyNyNyWyWxX1YZ!#"-.?f.?.?dTWdCJN\c\j\j\q\q\z\z[{/|}##$/0A0A0AVYfelp~E~L~L~S~S~\~\}]1^_%#&%&7f&7&7dC\HOSahaoaoavavaa`@'AB'#(34EF4E4EDZ]jmtxFMFTFTF[F[FdFdEe5fg)#*!"5&"5"5eOk{X#YZ+#,"#46#4#44Kqx|KRKYKYK`K`KiKiJj$kl-#. !1!1!1;n:ozNZtACJN"OP/#0.f..8R7S]huXeghi1#2 !1!1!1;LVZf[hj"kl3#4/f//Gcde5#6 1 1 1Hpw{ |}7#8/f//dFlswxy9#:,-@V-@-@Y^-_`;#</F//NO=#>0v00%dV\V_V_VfVfVoVoVwVw}K LM?#@0v00teRVbhbkbkbrbrb{b{cEcEJRJbJbq} ~A#B%&^ho|NV%WX(*=&*=*=bTrAHAOAOAVAVA_A_@`o~+@$&6f&6&6TXb&cd.0C0C0CD]FUl1mn/1D1D1DT^tCa2bc13D63D3D4YZaeuU4VW)))4PQ0v00teRVbhbkbkbrbrb{b{cEcEJRJbJbq} ~0v00t$RXR[R[RbRbRkRkRsRsCNSds @A 1 1 1FII%&?!5!5!54!@A!2!2!2EX^XaXaXhXhXqXqXzXz@S"TU.V..TEPT`f`i`i`p`p`y`yaBaBGTUV0v00teRVbhbkbkbrbrb{b{cEcEJRJbJbq} ~ "8&"8"8%L_"`a 1 1 1FII!5'<^ho|NV%WX$)*=&*=*=bTrAHAOAOAVAVA_A_@`o~+@$%&6f&6&6TcX\&]^$ /0C0C0CD]FUl1mn!$"01D1D1DT^tCa2bc#$$23D63D3D4YZaeuU4VW%$&)))4PQ'$(/v//DERS)$* !5!5!5t!DE+$,)*:&*:*:cPT*UV-$. !1!1!1:p}~!A/$00v00t5[`gkw}xAxAxHxHxQxQx\x\kns{sKsKZf gh1$20v00t5W[gmgpgpgwgwhAhAhLhL[^ctCO PQ3$4 1 1 1EX\hnhqhqhxhxiBiBiMiM\_dwFP!QR5$6!"3&"3"3$eZ^jpjsjsjzjzkDkDkOkO^af|KZ#[\7$8$%6V%6%6UV\V_V_VfVfVoVoVzVzJW\n&op9$: !7!7!7;S!TU;$< !2!2!2 HXHXHaHaHjHjy|BJBZBZ"[\=$> !2!2!2UY]ioiririyiyjCjCjNjN]`ewFT"UV?$@.V..TUYekeneneueue~e~fJfJY\ao~HIJA$B 1 1 1E\ahlx~yByByIyIyRyRy]y]lot|tLtL[h!ijC$D+&++$eRVbhbkbkbrbrb{b{cGcGVY^rAHIJE$F/f//d%VZflfofofvfvffgKgKZ]bq@KLMG$L!6'=rs- ( J $$Jr