o
    ۷h4                     @   s  d dl mZ d dlmZ d dlmZ G dd deZG dd deZG dd	 d	eZG d
d deZ	G dd deZ
G dd deZG dd deZG dd deZG dd deZG dd deZG dd deZG dd deZG dd deZG dd deZG d d! d!eZG d"d# d#eZG d$d% d%eZG d&d' d'eZG d(d) d)eZG d*d+ d+eZG d,d- d-eZG d.d/ d/eZG d0d1 d1eZG d2d3 d3eZG d4d5 d5eZG d6d7 d7eZG d8d9 d9eZ G d:d; d;eZ!G d<d= d=eZ"d>S )?    )models)	FETModels)nowc                   @   s   e Zd ZejddZejddddZejddddZej	ddZ
ejd	dZejddddZejd	dZej	ddZejddZejddd
Zejddd
ZdS )EmployeePaystructureTnull              
max_digitsdecimal_placesdefaultFr      r   blankN)__name__
__module____qualname__r   IntegerFieldemployee_idDecimalFieldstandard_ctc	gross_payBooleanFieldis_tdsSmallIntegerFieldpf_type	take_homestatusis_esi	emp_grade	DateField	from_dateto_date r&   r&   </var/www/FinalPayroll/payrollservice/models/payrollmodels.pyr      s    r   c                   @   s   e Zd ZejeejddZejddZ	ejddZ
ejdddddZejdddd	Zejd
dZejddZejddZejddZejddZejddZejdddddZdS )EmployeePaystructure_detailsT	on_deleter   r   r      r
   r   r   r   r   r	   r   Fr   r   N)r   r   r   r   
ForeignKeyr   CASCADEemp_payr   paycomponentpaycomponent_typer   paycomponent_percentageamountr   company_contributiontyper#   r$   r%   r    r   segmentsegment_percentager&   r&   r&   r'   r(      s    r(   c                   @   sp   e Zd ZejddZejddZejddZej	ddddZ
ejddZejddZejddZejd	dZd
S )EmployeePaystructure_deductionsTr   r   r	   r
   r   r   r   FN)r   r   r   r   r   r   r   paycomponent_idr5   r   r3   r#   r$   r%   r    r   is_customdeductr&   r&   r&   r'   r8   !   s    r8   c                   @   s   e Zd ZejddZejdddZejddddZ	ejddddZ
ejddddZejdd	d
Zejdd	d
ZejddZejddZejddZejddZejddZejedZejddZejd	dZejddZejdddZejdddZdS )Employeemonthly_payinfoTr      
max_lengthr   r   r	   r
   r   r   )r   r   Fr   r   N)r   r   r   r   r   r   	CharFieldcoder   r   r   r   r   payable_days	paid_days
pay_statuspay_moder   r   r   r    r#   r   payroll_dateref_id	is_deductDateTimeField	paid_datetransaction_numremarksr&   r&   r&   r'   r;   ,   s&    r;   c                   @   s   e Zd ZejeejddZejddZ	ejddZ
ejdddddZejdd	Zejdd
ddZejddZejddZejddZejdd	ZejddZejdddddZdS )Employeemonthlypay_detailsTr)   r   r   r+   r
   r,   Fr   r	   r   r   N)r   r   r   r   r-   r;   r.   empmonthly_payr   r0   r1   r   r2   r   r4   r3   r5   r#   r$   r%   r    r   r6   r7   r&   r&   r&   r'   rL   @   s    rL   c                   @   s   e Zd ZejddZejddZejddZej	ddZ
ej	ddZej	edZejddddZejddZejd	dZejd
dZdS )Employeemonthlypay_deductionsTr   r   r   r	   r
   r   r   FN)r   r   r   r   r   r   r   r9   r5   r#   r$   r%   r   deduct_dater   r3   deduction_statusr    r   
is_advancer&   r&   r&   r'   rN   O   s    rN   c                   @   s   e Zd ZejddZejddZejddZ	ejddZ
ejddZejddddZejddddZejddZejddddZejddZejddZejd	dd
ZejddZdS )EmployeeadvancedetailsTr   r   r	   r
   r   r   r   r<   r=   N)r   r   r   r   r   r   r   r5   r#   r$   r%   advance_statusr   actual_amountpayable_amount	TextFieldreason
emi_amountr    rH   amount_reciveddater?   r@   rK   r&   r&   r&   r'   rS   \   s    rS   c                   @   sV   e Zd ZejeejddZejddZ	ej
ddddZej
ddddZejdd	Zd
S )EmployeeadvancepaymentTr)   r   r   r	   r
   r   r   r   N)r   r   r   r   r-   rS   r.   advancerH   rI   r   balance_amountpaid_amountr   r    r&   r&   r&   r'   r[   l   s    r[   c                   @   sz   e Zd ZejddZejddZejddZejddZ	ejddZ
ejddZejddZejdddZejddZdS )PayrolltranTr      r=   r   r   N)r   r   r   r   r   ref_typer   rF   tran_status	tran_fromtran_tor#   r$   	tran_dater?   rK   r    r&   r&   r&   r'   r_   s   s    r_   c                   @   s`   e Zd Ze ZejddddZejdddZ	e Z
ejdddZe ZejddddZdS )Payrollaudit   T)r>   r   r   r   N)r   r   r   r   r   rF   r?   ra   rW   datar   rH   dater   
req_statusactionr&   r&   r&   r'   rf   ~   s    rf   c                   @   sT   e Zd ZejddZejddZejddZej	ddZ
ejddZej	ddZdS )PayrollprocesschangeTr   r   r   N)r   r   r   r   r   r   r#   r$   r%   r   
pay_changerW   rX   r    r&   r&   r&   r'   rl      s    rl   c                   @   sf   e Zd ZejddZejddZejddZ	ejddZ
ejddZejdddddZejd	dZd
S )Employeeadditional_allowanceTr   Fr   r   r	   r
   )r   r   r   r   r   N)r   r   r   r   r   r   r   r5   r#   active_dateend_dater   custom_deductr   r3   r    r&   r&   r&   r'   rn      s    rn   c                   @   s&   e Zd ZejdddZejedZdS )Payapprovedqueue   Tr=   r   N)	r   r   r   r   r?   r@   r#   r   ri   r&   r&   r&   r'   rr      s    rr   c                   @   s   e Zd ZejdddZejdddZejddZej	ddZ
ej	ddZej	ddZejddZejddZejddZejddd	d
ZejddZejddZejddZejddZdS )PayrollComponentr<   Tr=      r   Fr   r	   r
   r   r   N)r   r   r   r   r?   namer@   r   allowance_typer   
is_default
pf_includeis_deductioncat_id	subcat_idglnor   
percentager   r    grader#   r$   r%   r&   r&   r&   r'   rt      s    rt   c                   @   sN   e Zd ZejeejddZejddZ	ej
ddZej
ddZejddZdS )PayrollDeductionTr)   r   r   r   N)r   r   r   r   r-   rt   SET_NULLpayrollcompr   r5   r#   r$   r%   r    r&   r&   r&   r'   r      s    r   c                   @   s   e Zd ZejdddZejddddZejddddZej	dd	Z
ej	dd	Zejdd	Zejdd	ZejdddZejd
dZejddddZdS )CompanyContributionr<   Tr=   ru   r	   r
   r   r   r   r   r   N)r   r   r   r   r?   rv   r   r~   r3   r#   effective_fromeffective_tor   r{   r|   r}   r   r    
sal_amountr&   r&   r&   r'   r      s    r   c                   @   s   e Zd ZejdddZejdddZejddddZejddddZ	ej
d	d
Zejdd
ZejddZejddZejdddZejddddZdS )EmployeePFStructurer<   Tr=   ru   r	   r
   r   r   Fr   r   r   N)r   r   r   r   r?   rv   r@   r   r~   r3   r   is_standardr   r    r   r{   r|   r}   r   r&   r&   r&   r'   r      s    r   c                   @   sB   e Zd ZejdddZejddddZejddZ	ejd	d
Z
dS )ComponentTyper<   Tr=   ru   r	   r
   r   r   r   r   N)r   r   r   r   r?   rv   r   r~   r   categoryr    r&   r&   r&   r'   r      s
    r   c                   @   s<   e Zd ZejddZejddZejddZejddZ	dS )PaycomponentFlagmasterTr   r   r   N)
r   r   r   r   r   map_idra   rF   r   r    r&   r&   r&   r'   r      s
    r   c                   @   sb   e Zd ZejdddZejeejddZ	ej
ddZejdddd	Zej
d
dZejdddZdS )Segmentr<   Tr=   r)   r   ru   r	   r
   r   r   r   N)r   r   r   r   r?   rv   r-   r   r   component_typer   r5   r   r~   r    r}   r&   r&   r&   r'   r      s    r   c                   @   s<   e Zd ZejeejddZejeejddZ	ej
ddZdS )PaycomponentSegmentmappingTr)   r   r   N)r   r   r   r   r-   rt   r   r0   r   r6   r   r    r&   r&   r&   r'   r      s    r   c                   @   sf   e Zd ZejdddZejddZejdddZej	ddZ
ejddZejddZejdddZd	S )
PayrollTemplatex   Tr=   r   ru   r   r   @   N)r   r   r   r   r?   rv   r   r   r@   r   r    r#   
valid_fromvalid_tor}   r&   r&   r&   r'   r      s    r   c                   @   sb   e Zd ZejeejddZejddZ	ej
ddZejddddZejddddZejdd	Zd
S )PayrollmastersmappingTr)   r   ru   r	   r
   r   r   r   N)r   r   r   r   r-   r   r   templater   r6   r   r0   r   r~   r3   r    r&   r&   r&   r'   r      s    r   c                   @   s@   e Zd ZejdddZejddZejdddZejddZ	dS )ReportColumns}   Tr=   r   r   r   N)
r   r   r   r   r?   rv   r   r5   link_columnsr    r&   r&   r&   r'   r      s
    r   c                   @   s2   e Zd ZejdddZejddZejddZ	dS )ReportTemplater   Tr=   r   r   r   N)
r   r   r   r   r?   rv   r   bank_idr   r    r&   r&   r&   r'   r      s    r   c                   @   sH   e Zd ZejeejddZejeejddZ	ej
ddZejddZdS )ReportTemplateDetailsTr)   r   r   r   N)r   r   r   r   r-   r   r   report_templater   reportcolumnsr   orderr   r    r&   r&   r&   r'   r     s
    r   c                   @   sl   e Zd Ze Ze Ze ZejddZ	ejddZ
ejddZejddZejddZejddZdS )PayrollTestTr   r   r   N)r   r   r   r   r   r   monthyear
FloatFieldpresent_countleave_countpremission_hrdurationr    rB   r&   r&   r&   r'   r     s    r   c                   @   s4   e Zd ZejdddZejdddZejddZdS )payrollschedularTr   r   N)	r   r   r   r   rH   startendrW   messager&   r&   r&   r'   r     s    r   c                   @   s2   e Zd ZejddZejdddZejddZdS )PayrollManualRunSchedularFr   Tr   N)	r   r   r   r   r   is_completedrH   ri   	is_manualr&   r&   r&   r'   r     s    r   N)#	django.dbr   db.vsolvmodelsr   django.utils.timezoner   r   r(   r8   r;   rL   rN   rS   r[   r_   rf   rl   rn   rr   rt   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r&   r&   r&   r'   <module>   s@    	

	