siArddlZddlZddlZddlZddlZ ddl m Z ddl m Z mZGdde jZy)N)settings) migrationsmodelsc6UeZdZdZdddddej ejgZejdde jddd d fd e jd fde jdddfgejdde jddd d fde jdfde jdgdddfde jddddfgejdde jdej jj"j$ddd d fgd!d id"#ejd$de jddd d fd%e j&ejj*&fgejd'de jddd d fd(e j&ejj*&fgejd)gde jddd d fd*e j,ddd+,fd-e j.dd./fd0e jd1d2fd3e j0dd4d5fd6e j.d d7d89fd:e j.dd;<fd=e j.d d><fde jdgd?d@ddAfde jdgdddfde jddddfdBe j.ddC<fdDe j2ddEdejjj6gFfdGe jdgdHdIdJddKfdLe j2ddMdejjj8gFfdNe j2ddOdPdejjj6gQfdRe j2ddOdSdejjj6gQfdTe j2ddOdUdejjj6gQfdVe j2ddOdWdejjj6gQfdXe j2ddOdYdejjj6gQfdZe j.d d[d\9fd]e j2dd^dejjj6gFfd_e jd`gdadbdcddfdee jdfgdIdgdhifdje jgdkdldmdhifdne j2dOdo<fdpe j2ddqd5fdre j2ddsd5fdte j.d d ufdve j.d d ufdwe j:d dej jj"j<dxyfdze j:dd dej jj"j>ejd{|fd}e j@dd~dddfde j:dd dej jj"j>dejdfde j:ddej jj"j<ddfde j@dddddfde j:ddej jj"j<ddfde j@dd dfdd)iejdgde jddd d fd*e j,ddd+,fd-e j.dd./fd0e jdd2fd3e j0ddd5fd6e j.d dd89fde j.d d<fde j.dd<fd=e j.d d<fde jdgd?d@ddAfde jdgdddfde jddddfde jdgdddhdAfdBe j.dd<fdDe j2dddejjj6gFfdGe jdgddddAfdLe j2ddOdMdejjj8gdfde j2dOejjj8gfdZe j.d dd9fd]e j2dddejjj6gFfd_e jd`gdadbdcddfdee jdfdgdIdgdhifdje jgdkdldmdhifdne j2dOdo<fdpe j2ddqd5fdre j2ddsd5fdte j.d d ufde j.d d ufdwe j:d dej jj"j<dxyfdze j:dd dej jj"j>ejd{|fd}e j@dddddfde j:dd dej jj"j>dejdfde j@dddddfde j@dd dfd!d iejdde jddd d fd*e j,ddd+,fd-e j.dd./fde jddfdGe jgddddfde j.d d/fde jBdfde jBddd¬ëfdwe j:d dej jj"j<dxyfdze j:dd dej jj"j>ejd{|fde j:dd dej jj"j>dejdfg dddgdǜejdde jddd d fd*e j,ddd+,fd-e j.dd./fde jdddȬ̫fde j0dάϫfde j0dddѬfde jgdӢdddլfde jgdעddcddج٫fde j2dddܬݫfde jgdߢdddᬼfde jddejjj6gdfde j&ddejj*fde j.ddd9fde j.ddd9fde j2ddddfde jBdddfdze j:dd dej jj"j>ejd{|fde j:ddej jj"j<dddfde j:ej jj"j<dddfde j:ddej jj"j<dddfde j:ddej jj"j<dddfde j:dd dej jj"j>dejdfde j:ddej jj"j<dddfde j:ddej jj"j<dddfde j:ddej jj"j<dddĬfgddhiejdgde jDdddd fd*e j,dd dd+ fd-e j.dd./fd e jddcdfd e jBdfd e j.d d fde jdddȬ̫fde j0dάϫfde j0dddѬfde jgdӢdddլfde jgdעddcddج٫fde j2dddܬݫfde jgdߢdddᬼfde jddejjj6gdfde jBdddfde j.ddd9fde j.ddd9fde j2ddddfde jBdddfde jFdd fde j,dfde jddfde jgdd fdze j:dd d dej jj"jHdejd{fde j:dd dej jj"jHdddfde j:dd dej jj"jHdddfde j:dd dej jj"jHdddĐfde j:d ej jj"jHddfde j@d !fd"e j:dej jj"j>dej#fde j:dd dej jj"jHdddfde j:dd dej jj"jHdddfde j:dd d dej jj"jHdejdfde j:dd dej jj"jHdddfde j:dd dej jj"jHdddfd$d%d&d'd(e%jjLe jNf#ejd)de jddd d fd*e j,ddd+,fd-e j.dd./fd*e jgd+d,d-.fd0e jdcfd/e j2dd/fd0e j0fde jBddfdBe j.dd ufdLe j2dd ufd1e j2ddd2fd3e jd4ϫfd5e j0d67fd8e jd9d dc:fd;e j.d fd<e j,dfd=e j:d dej jj"j>d>yfd?e j:dd dej jj"j<d@Afdze j:dd dej jj"j>ejd{|fdBe j@d dCDfde j:ej jj"j<ddEfde j:dd dej jj"j>dejdfgd!d iejdFde jddd d fdGe jddHejjj6gIfdwe j:dej jj"j$dxJfgejdKde jddd d fd*e j,ddd+,fd-e j.dd./fdLe jdMdNdOfdPe jdQdRgdSd-dTfdwe j:dej jj"j<dxJfdze j:dd dej jj"j>ejd{|fde j:dd dej jj"j>dejdfgdUdUdVejdWde jddd d fd*e j,ddd+,fd-e j.dd./fdXe jddYddZ[fd\e jdddfd]e j0fd^e j0fd_e jPfd`e j2dd fdIe j2dd fdae j2dd fdbe j2dd fdce j2dd fdde jgdeddcdTfdfe j.d d fdze j:dd dej jj"j>ejd{|fde j:ej jj"j<ddEfdge j@d dCDfde j:dd dej jj"j>dejdfgdhdigiejdjde jDdddd fd*e j,dd dd+ fd-e j.dd./fd e jddcdfd e jBdfd e j.d d fdXe jddYddZ[fd\e jdddfd]e j0fd^e j0fd_e jPfd`e j2dd fdIe j2dd fdae j2dd fdbe j2dd fdce j2dd fdde jgdeddcdTfdfe j.d d fde jFdd fde j,dfde jddfde jgdd fdze j:dd d dej jj"jHdejd{fde j:dd dej jj"jHdddfde j@d !fd"e j:dej jj"j>dej#fde j:dd d dej jj"jHdejdfde j:d ej jj"jHddkfgdldmd&d'd(e%jjLe jNf#ejdnde jddd d fdoe jgdpdqdrddstfdue j.d fdwe jddej jj"j$dxdvfgejdwde jddd d fd*e j,ddd+,fd-e j.dd./fd0e jdYfd*e jgdxdydz.fd{e j0fd(e j&dejj*|fd}e j2dېd~d9fde j2dېdd9fde jdېdd9fdDe j2d۬fdde jgddd dhfde jBddfd=e j:d dej jj"j>d>yfde j:d dej jj"j>ddfdze j:dd dej jj"j>ejd{|fde j:ej jj"j<ddEfde j:ddej jj"j<ddfde j:dd dej jj"j>dejdfde j@dd dfgdhdgiejdde jddd d fd-e j.dd./fde jBdddfd*e j,ddd+,fdze j:dd dej jj"j>ejd{|fde j:ej jj"j$dfde j@ddfde j:dd dej jj"j>dejdfde j:ej jj"j$dfg d!d iejdde jddd d fd*e j,ddd+,fd-e j.dd./fde j2dϫfde j2dddfde j2dOd/fdze j:dd dej jj"j>ejd{|fde j:ej jj"j$ddEfde j:dd dej jj"j>dejdfg d!d iejdde jddd d fde jdddfde jgddNdfde j0ddfde jdddNde)jjTgfde jdddNde)jjTgfde jdddfde jdddfde jBdfde jdddfde j.d fde j.d fde j2d۬fde j,ddfde j:ej jj"j<ddEfggZ+y( MigrationT)asset 0001_initial)baser )employeer ) horilla_auditr )leaver EncashmentGeneralSettingsidFID) auto_created primary_key serialize verbose_name bonus_amount)default leave_amountAmount)blanknullr)namefieldsMultipleConditionfield) max_length condition)equalz Equal (==)notequalzNot Equal (!=)ltz Less Than (<)gtzGreater Than (>)lezLess Than or Equal To (<=)gezGreater Than or Equal To (>=)) icontainsContains)rchoicesr!rvaluez6The value must be like the data stored in the database)r help_textr!rOverrideLeaveRequestleaverequest_ptrleave.leaverequest)r on_delete parent_linkrrtoabstract)r6)rroptionsbasesReimbursementFilefile) upload_toReimbursementMultipleAttachment attachment Allowance created_atz Created At) auto_now_addrr is_activez Is Active)rrtitlezTitle of the allowance)r3r! one_time_datez{The one-time allowance in which the allowance will apply to the payslips if the date between the payslip period)rr3rinclude_active_employeesz7Target allowance to all active employees in the companyzInclude all active employees)rr3r is_taxablez6This field is used to calculate the taxable allowances)rr3is_condition_basedzThis field is used to target allowance to the specific employees when the condition satisfies with the employee's information) 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)rr1r3r!ris_fixedz)To specify, the allowance is fixed or notamountzFixed amount for this allowance)rr3r validatorsbased_on) basic_payz Basic PayrK)overtimeOvertime)shift_idShift) work_type_id Work Type) attendance AttendancerbzGIf the allowance is not fixed then specifies how the allowance provided)rr1rr3r!rratezThe percentage of based onper_attendance_fixed_amountgz8The attendance fixed amount for one validated attendance)rrr3rr_per_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 monthrtzThe maximum amount for ?)r1rr3r!r if_choiceraz!The pay head for the if condition )r1rr3r! if_condition)r#r%r'r)r+r-)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)rrr7r9 created_byz Created By)rrrr7r9rexclude_employeeszqTo ignore the allowance to the employees when target them by all employees or through condition-basedallowance_excludedzemployee.employeezExclude Employees)rr3 related_namer9r modified_byz%(class)s_modified_byz Modified By)rrrr7rr9rrezbase.employeeshiftrf)rrr7r9rspecific_employeesz*Target allowance to the specific employeesallowance_specificzEmployees Specificrgz base.worktyperhother_conditionszpayroll.multiplecondition)rrr9r)rrr; 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))rbz 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)rartaxable_gross_payzTaxable Gross PayrzGIf the deduction is not fixed then specifies how the deduction providedz Employee rate)rrr3rr_r employer_rate)rr_zLimit 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_excludez*Target deduction to the specific employeesdeduction_specific FilingStatus filing_statusz Filing status)r!r)rarrrzBased on)r1rr!ruse_pyz Python Code python_code)r description Description)rr!rz Filing StatuszFiling Statusesz-id)rverbose_name_pluralorderingContract contract_namezContract Title.)r3r!rcontract_start_datez Start Date)rcontract_end_datezEnd Date wage_type))dailyDailymonthlyMonthly)hourlyHourlyrr[ pay_frequency))weeklyWeeklyr) semi_monthlyz Semi-MonthlyrY)r1rr!rrwagerz Basic Salary)rrrcontract_status)draftDraft)activeActive)expiredExpired) terminated TerminatedrStatusnotice_period_in_dayszNotice period in total days.z Notice Period)rr3r_rcontract_document)rrr?deduct_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)rrrrnote)rr!r department contractszbase.department Department)rrr7rr9r employee_id contract_setEmployee)r7rr9r job_positionzbase.jobpositionz Job Positionjob_rolez base.jobrolezJob Roleshift work_typezpayroll.filingstatusunique_together)rrrHistoricalContract)rrdb_indexr)rrrr history_titlehistory_descriptionhistory_highlight)rrd history_id)rr history_date)rhistory_change_reason)r!r history_type))+Created)~Changed)-Deleted)r1r!r)r db_constraintrrr7rr9r)rrrr7rr9rhistory_relation history_setzpayroll.contract)rr7rr9 history_tagszhorilla_audit.audittag)r9 history_user)rr7rr9zhistorical contractzhistorical contracts)z -history_datez -history_id)rr)rrr get_latest_by LoanAccounttype))loanLoan)advanced_salaryzAdvanced Salary)finezPenalty / Finer)r1rr! loan_amount provided_dateinstallment_amountzinstallment Amount installmentszTotal installmentsinstallment_start_datez(From the start date deduction will apply)r3apply_on end_of_month)rrr!settled settled_date allowance_idzpayroll.allowanceasset_idz asset.asset)rrrr7r9 deduction_idszpayroll.deduction)rr9)r7r9rPayrollGeneralSetting notice_periodzNotice period in days)rr3r_)rr7r9PayrollSettingscurrency_symbol$)rr!rposition)prefixPrefix)postfixPostfixr)r1rr!rzPayroll Settings)rrPayslip group_name2z Batch name)rr!rr reference start_dateend_date pay_head_data contract_wager deductionrstatus)r)review_ongoingzReview Ongoing) confirmed Confirmed)paidPaidsent_to_employeeinstallment_idsrz -end_dateHistoricalPayslipzpayroll.payslipzhistorical payslipzhistorical payslipsPayslipAutoGenerate 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)r1rr3r!r auto_generateCompany Reimbursement)) reimbursementrW)bonus_encashmentzBonus Point Encashment)leave_encashmentzLeave EncashmentrX allowance_on)rr? ad_to_encashzAvailable Days to encashzAvailable days cfd_to_encashzCarry Forward Days to encashzCarry forward daysbonus_to_encashzBonus points to encashz Bonus points)) requested Requested)approvedApproved)rejectedRejectedr`)r1rrr! approved_by)rrr7rr9 leave_type_idzleave.leavetypez Leave typeother_attachmentsz'payroll.reimbursementmultipleattachmentReimbursementrequestCommentcommentComment)r!rr)r7r9fileszpayroll.reimbursementfile)rr9 request_idzpayroll.reimbursement TaxBracket min_incomez Min. Income max_incomez Max. Incometax_ratezTax Ratefiling_status_id WorkRecord record_namework_record_type))FDPPresent)HDPzHalf Day Present)ABSAbsent)HDzHoliday/Company Leave)CONFConflict)DFTr)r1r!rdate)rrat_workz00:00)rrr!rr_min_hourat_work_second)rrrmin_hour_secondmessageis_attendance_recordis_leave_recordday_percentage last_updateN),__name__ __module__ __qualname__initialrswappable_dependencyrAUTH_USER_MODEL dependencies CreateModelr BigAutoField IntegerField CharField OneToOneFielddjangodbdeletionCASCADE FileFieldhorilla upload_path DateTimeField BooleanField DateField FloatFieldpayrollmin_zerorate_validator ForeignKeyPROTECTSET_NULLManyToManyField TextFieldBigIntegerField AutoField DO_NOTHINGsimple_historyHistoricalChangesModel JSONFieldr validate_time_format operationsC/var/www/python-projects/worksol/payroll/migrations/0001_initial.pyrr sA;G " $)!' ''(@(@A L  ,*v**$Z_nrst!4!4!4Q!?@!4!4!44dYa!bc   $*v**$Z_nrst*&**c:;.f..TD\ilswxy*&**AyGJQUVW    '#%9V%9%9tW]W`W`WgWgWpWpWxWxGKY]insG&HIE*   $*v**$Z_nrst)))GNN4N4NOP   2*v**$Z_nrst/v//'..:T:TUV   '*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&6TX_XfXfXrXr&st.0C0C0CD]FUl1mn/1D1D1DT^tCa2bc13D63D3D4YZaeuU4VW)))4PQ0v00teRVbhbkbkbrbrb{b{cEcEJRJbJbq} ~0v00t$RXR[R[RbRbRkRkRsRsCNSds @A 1 1 1FII^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'=?!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'<rs0  (I $$Ir