| Server IP : 65.108.144.40 / Your IP : 216.73.217.165 Web Server : Apache/2.4.52 (Ubuntu) System : Linux ubuntu-8gb-hel1-1 5.15.0-173-generic #183-Ubuntu SMP Fri Mar 6 13:29:34 UTC 2026 x86_64 User : dev ( 1000) PHP Version : 8.2.30 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/erp/employee/__pycache__/ |
Upload File : |
o
hͦh� � @ s d Z ddlmZmZmZ ddlmZ ddlmZ ddlm Z m
Z
ddl m Z ddl
mZ ddlmZ dd lmZ dd
lmZ dd lmZ dd lmZ dd
lmZ ddl m Z ddl m Z m Z m!Z!m"Z"m#Z#m$Z$m%Z%m&Z& ddl'm(Z(m)Z) ddl*m+Z+ ddl,m-Z- ddl.m/Z/ ddl0m1Z1 ddl2m3Z3m4Z4 dd� Z5G dd� dej6�Z7G dd� de/�Z8G d d � d ej6�Z9G 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/�ZAG d.d/� d/e/�ZBdd0lCmDZD eD�Ed1� eD�Ed2� eD�Ed3� d4S )5zE
models.py
This module is used to register models for employee app
� )�date�datetime� timedelta)�apps)�settings)�
Permission�User)�ValidationError)�default_storage)�models)�QuerySet)� post_save)�receiver)�gettext)� gettext_lazy)�HorillaCompanyManager)�Company�
Department�
EmployeeShift� EmployeeType� JobPosition�JobRole�WorkType�validate_time_format)� format_time�strtime_seconds)�horilla_middlewares)�get_horilla_model_class)� HorillaModel��get_diff)�HorillaAuditInfo�HorillaAuditLogc C s | S )z9
Method to implement reporting manager_validator
� )�valuer# r# � /var/www/erp/employee/models.py�reporting_manager_validator+ s r& c s� e Zd ZdZded�fded�fded�fgZded �fd
ed �fd ed
�ffZejdddd�Z ej
e ej ddde
d�d�Zejdde
d�d�Zejddde
d�d�Zejdddd�Zejd dd �Zejd d �Zejdddd �Zejd!ddd �Zejd!ddd�Zejd!ddd�Zejd"ddd�Zej ddd#�Z ejd$dedd%�Z ejdddd �Z ej ddd#�Z!ejdddedd&�Z"ej ddd'�Z#ejd ddd�Z$ejd"ddd�Z%ejd"ddd�Z&ej'dd(�Z(ej)ddd#�Z*ej'ddddd)�Z+ej'ddddd)�Z,e-d*d+�Z.d,d-� Z/d.d/� Z0d0d1� Z1d2d3� Z2d4d5� Z3d6d7� Z4d8d9� Z5d:d;� Z6d<d=� Z7d>d?� Z8d@dA� Z9dBdC� Z:dDdE� Z;dFdG� Z<dHdI� Z=dJdK� Z>dLdM� Z?dNdO� Z@dPeAfdQdR�ZBdSdT� ZCG dUdV� dV�ZDdWdX� ZEdYdZ� ZFd[d\� ZG� fd]d^�ZH� ZIS )_�Employeez
Employee model
�male�Male�female�Female�other�Other�single�Single�married�Married�divorced�Divorced�2 T)�
max_length�null�blank� employee_getr �� on_deleter7 r6 � related_name� verbose_name�� Fz
First Name�r5 r6 r< z Last Name�r5 r6 r7 r< zemployee/profile�� upload_tor6 r7 � )r5 �unique� �r5 �r5 r7 r6 � � �r6 r7 �
)r5 r6 �choices�default)r5 r7 r6 rK rL �r7 r6 �rL )rL r6 r7 �editable� employee_work_info__company_id��related_company_fieldc C s d}| j r | j j}|S )zV
This method is used to return the profile image path of the employee
F)�employee_profile�url)�selfrT r# r# r% � get_imageu s zEmployee.get_imagec C s | j r | j� d| j � �S | jS )z7
Method will return employee full name
� )�employee_last_name�employee_first_name�rU r# r# r% �
get_full_name~ s
���zEmployee.get_full_namec C � t t | dd�dd�S )zK
This method is used to return the company of the employee
�employee_work_infoN�
company_id��getattrrZ r# r# r% � get_company� � zEmployee.get_companyc C s< | � � r| � � ntjjdd��� }|r |j}|r|S dS dS )NT)�hqz MMM. D, YYYY)ra r �objects�filter�first� date_format)rU �companyrg r# r# r% �get_date_format� s
�� zEmployee.get_date_formatc C r\ )zP
This method is used to return the job position of the employee
r] N�job_position_idr_ rZ r# r# r% �get_job_position� � �zEmployee.get_job_positionc C r\ )zN
This method is used to return the department of the employee
r] N�
department_idr_ rZ r# r# r% �get_department� rb zEmployee.get_departmentc C r\ )�I
This method is used to return the shift of the employee
r] N�shift_idr_ rZ r# r# r% � get_shift� rb zEmployee.get_shiftc C s t t | dd�d| j�S )ro r] N�email)r` rr rZ r# r# r% �get_mail� s zEmployee.get_mailc C s | � � S �N)rs rZ r# r# r% � get_email� � zEmployee.get_emailc C r\ )zM
This method is used to return the work type of the employee
r] N� work_type_idr_ rZ r# r# r% �
get_work_type� rb zEmployee.get_work_typec C r\ )�Q
This method is used to return the employee type of the employee
r] N�employee_type_idr_ rZ r# r# r% �get_employee_type� rl zEmployee.get_employee_typec C r\ )ry r] N�reporting_manager_idr_ rZ r# r# r% �get_reporting_manager� rl z Employee.get_reporting_managerc C s4 d| � � � d�}| jr| jj}t�|�r| jj}|S )zV
Method will retun the api to the avatar or path to the profile image
z!https://ui-avatars.com/api/?name=z&background=random)r[ rS �namer
�existsrT )rU rT �
full_filenamer# r# r% �
get_avatar� s �
zEmployee.get_avatarc C s� t �� }t�d�r| jj||d�nt� �� }td�}|� � r>|jdd�� � r,td�}|S |jdd�r8td�}|S td �}|S t�d
�rP| j
j|d �� � rPtd �}|S )
zM
This method is used to get the leave status of the employee
�leave��start_date__lte�
end_date__gte�Expected working�approved)�status�On Leave� requestedzWaiting ApprovalzCanceled / Rejected�
attendance��attendance_date�
On a break� r �todayr � is_installed�leaverequest_setre r �none�_r �employee_attendances)rU r� �leaves_requestsr� r# r# r% �get_leave_status� s0 �� �
�����zEmployee.get_leave_statusc C s� t �� }t�d�r| jj||d�nt� �� }td�}|� � rH|jdd�� � r,td�}|S |jdd�� � p9|jd d�}|rBtd
�}|S td �}|S t�d �rZ| j
j|d
�� � rZtd�}|S )zR
This method is used to get the leave Type status of the employee
r� r� r� � )�
leave_type_idzWork From Home�
first_half)�start_date_breakdown� second_halfzHalf Dayr� r� r� r� r� )rU r� r� r� �flagr# r# r% �get_leave_type� s2 �� �
�����zEmployee.get_leave_typec
C s� t �d�rlt�� }|tdd� }d}d}t| jj||gd��d��}t |�dkr0|d d}}nt |�dkr;|\}}nd \}}|}|sE|}t
t |d
d ��}d}d} |rW|� � }t
d|| �} t|�t| �|| |dud �S i S )
zO
This method is used to the employees current day shift status
r� � ��daysN)�attendance_date__inr� r � )NN� minimum_hour�0)�forecasted_at_work�forecasted_pending_hours�forecasted_at_work_seconds� forecasted_pending_hours_seconds�has_attendance)r r� r r� r �listr� re �order_by�lenr r` �get_at_work_from_activities�maxr )
rU r� � yesterday�today_attendance�yesterday_attendance� attendancesr� �minimum_hour_seconds�at_workr� r# r# r% �get_forecasted_at_work sD
��
��z Employee.get_forecasted_at_workc C s | j jt�� d��� S )zF
This method will returns employees todays attendance
r� )r� re r r� rf rZ r# r# r% �get_today_attendance@ s
��z Employee.get_today_attendancec C s� t �d�r tdd�}tdd�}|jj| jd�}|jj| jd�}nd}d}t �d�rDtdd�}tdd�}|jj| jd�}|jj| jd �}nd}d}tjj| jd
�} | �� sn|rZ|�� sn|r`|�� sn|rf|�� sn|rl|�� snd S g }
g } | �� r�|
�t d �d
d�� |�� r�|
�t d�dd�� |�� r�|
�t d�dd�� |�� r�|
�t d�dd�� |�� r�|
�t d�dd�� d|
i} z dt d�fgdd� t
jjd d �� d d d �D � }
|
| d!< W | S Y | S )"a�
Determine whether an employee is eligible for archiving based on their
involvement in various processes.
Returns:
dict or bool: A dictionary containing a list of related models
if the employee is not eligible for archiving,
otherwise, False.
This method checks the employee's association with different models,
such as reporting manager, recruitment stage, onboarding stage, onboarding task,
and recruitment manager. If the employee is not associated with any of these,
they are considered eligible for archiving. If they are associated,
a dictionary is returned with a list of related models of that employee.
�
onboarding�onboardingstage�onboardingtask�� employee_idN� recruitment�stage)�stage_managers)�recruitment_managers)r| FzReporting managerr| )r< �
field_namezRecruitment managerr� zRecruitment stage manager�recruitment_stage_managerszOnboarding stage manager�onboarding_stage_managerzOnboarding task manager�onboarding_task_manager�related_models� z---Choose employee---c S s, g | ]\}}}||r|� d |� �n|f�qS )rW r# )�.0r� �
first_name� last_namer# r# r% �
<listcomp>� s ���z2Employee.get_archive_condition.<locals>.<listcomp>T)� is_active�idrY rX �employee_choices) r r� r rd re �pk�EmployeeWorkInformationr �appendr� r' � values_list)rU �OnboardingStage�OnboardingTask�onboarding_stage_query�onboarding_task_query� Recruitment�Stage�recruitment_stage_query�recruitment_manager_query�reporting_manager_queryr� �related_model_fields�related_models_dict�REPLACE_EMPLOYEE_CHOICESr# r# r% �get_archive_conditionH s�
�����������������������
�
�z Employee.get_archive_condition�returnc C sF | j d ur| j nd}| jd urd| j� d�nd}| j� d|� d|� �S )Nr� �(�)rW )rX �badge_idrY )rU r� r� r# r# r% �__str__� s � zEmployee.__str__c C s� t �d�rHtdd�}ttjdd�}|durHt|d�r |jdu r@t� � �
� }|t dd� }|j j
||dd�jd dd
�}t|d|� |j}| j|v S d S ) zZ
This method is used to check if the user is in the list of online users.
r� �requestN�working_employeesr� r� T)�attendance_date__gte�attendance_date__lte�!attendance_clock_out_date__isnullr� )�flatF)r r� r r` r �_thread_locals�hasattrr� r �nowr r rd re r� �setattrr� )rU �
Attendancer� r� r� r� r# r# r% � check_online� s(
�
��
zEmployee.check_onlinec @ s: e Zd ZdZdZdZdgZejdgej dd�dd �gZ
d
S ) z
Employee.Metaz#
Recruitment model
)rY rX rr ))�change_ownprofilezUpdate own profile)�view_ownprofilezView Own ProfilerY r� F)�badge_id__isnull�unique_badge_id)�fields� conditionr~ N) �__name__�
__module__� __qualname__�__doc__�unique_together� permissions�orderingr �UniqueConstraint�Q� constraintsr# r# r# r% �Meta� s �
��r c C sH | j }t�� }t|j|j|j�}||k r t|jd |j|j�}|| jS )zC
This method will calculate the day until birthday
r� )�dobr r� �year�month�dayr� )rU �birthdayr� �
next_birthdayr# r# r% �days_until_birthday� s
z Employee.days_until_birthdayc C s( ddl m} |jj| �� d��d��� S )z;
This method is used to get last send mail
r )�EmailLog)�
to__icontainsz -created_at)� base.modelsr rd re rs r� rf )rU r r# r# r% �get_last_sent_mail� s
�zEmployee.get_last_sent_mailc C s t jj| d�}|S )z�
Function to get all Employee objects of subordinates reporting to a given manager.
:param manager: Employee object who is the reporting manager.
:return: QuerySet of Employee objects.
)�(employee_work_info__reporting_manager_id)r' rd re )rU � subordinatesr# r# r% �get_subordinate_employees� s �z"Employee.get_subordinate_employeesc s< t jj| jd��� }t� j|i |�� ttj dd �}|r1| j
s1| � � dur1d| _
t� j|i |�� | }|rE|j |j krE|j |j
_|j
�� |j
d u r�| j }| j}|j
rX|j
j nd}tjj||||d�} | sotjj|||d�} | | _
tjjdd�}
tjjd d�} | j�| � | j�|
� t| d
�s�tjj| d � | �� S | S ) N)r� r� FT)�usernamerr �password�is_new_employee)r rr r r� )�codenamer� r] r� )r' rd re r� rf �super�saver` r r� r� r� rr �employee_user_idr �phoner r � create_userr �get�user_permissions�addr� r� �
get_or_create) rU �args�kwargs�
prev_employeer� �employeer r �is_new_employee_flag�userr� r� �� __class__r# r% r sH
����
z
Employee.save)Jr� r� r� r� �trans�
choice_gender�choice_maritalr � CharFieldr� �
OneToOneFieldr �CASCADEr� r rY rX �
ImageFieldrS �
EmailFieldrr r � TextField�address�country�state�city�zip� DateFieldr �gender�
qualification� IntegerField�
experience�marital_status�children�emergency_contact�emergency_contact_name�emergency_contact_relation� BooleanFieldr� � JSONField�additional_info�is_from_onboarding�is_directly_convertedr rd rV r[ ra ri rk rn rq rs ru rx r{ r} r� r� r� r� r� r� �strr� r� r r r r r �
__classcell__r# r# r" r% r' 2 s�
�
��
� ����
� ���
,e r' c @ s@ e Zd ZdZejdded�d�Zejddd�Zde fd d
�Z
d S ) � EmployeeTagz
EmployeeTag Model
r4 T�Titler> rG )r5 r6 r� c C � | j � S rt ��titlerZ r# r# r% r� = rv zEmployeeTag.__str__N) r� r� r� r� r r' r� rG �colorrA r� r# r# r# r% rC 5 s
rC c s e Zd ZdZejeejddded�d�Z ej
e ej dded�d�Z
ej
eej dded�d�Zej
eej dded �d�Zej
eej dded
�d�Zej
eej dded �d�Zej
eej ddd ed
�d�Zej
eej dded�d�Zejeded�d�Zej ddded�d�Z ej ddded�d�Z ej dddd�Z ej
e!ej"dded�d�Z#ej$dded�d�Z%ej$ddd �Z&ej'ddd ed �d �Z(ej'ddd ed �d �Z)ej*ddd!�Z+ej,ddd d"�Z-e.d#e/gd$�Z0e1� Z2d%e3fd&d'�Z4� fd(d)�Z5� fd*d+�Z6d,d-� Z7d.d/� Z8� Z9S )0r� z'
EmployeeWorkInformation model
Tr] r' r9 z Job Position)r: r6 r7 r< r z Work Typez
Employee TypezJob Role�reporting_managerzReporting Managerr )r: r7 r6 r< z Employee tag�r7 r< r4 z
Work Locationr? rB �Email)r5 r7 r6 r< rF �Shiftz Joining Date)r6 r7 r< rM r z Basic Salary)r6 r7 rL r< zSalary Per HourrI )r6 r7 rL � history_set�r; �basesr� c C � | j � d| j� �S )N� - )r� rj rZ r# r# r% r� � � z EmployeeWorkInformation.__str__c s | � � t� j|i |�� d S rt )�
full_cleanr r �rU r r r" r# r% r � s z EmployeeWorkInformation.savec s t � j|i |�� d| _d S )NF)r �__init__� skip_historyrT r" r# r% rU � s
z EmployeeWorkInformation.__init__c C � t | �S �zS
This method is used to return the tracked history of the instance
r rZ r# r# r% �tracking� � z EmployeeWorkInformation.trackingc C sF | j }|du r dS t�� �� }|| }|j}|d }|| _| �� | S )zT
This method is to calculate the default value for experience field
Nr g �v@)� date_joiningr r� r r� r6 r )rU � joining_date� current_date�delta�
total_daysr6 r# r# r% �experience_calculator� s z-EmployeeWorkInformation.experience_calculator):r� r� r� r� r r( r' r) r� r� �
ForeignKeyr �PROTECTrj r rm r rw r rz r � job_role_idr| r r^ �ManyToManyFieldrC �tagsr' �locationr+ rr �mobiler �
DO_NOTHINGrp r2 r[ �contract_end_dater5 � basic_salary� salary_hourr= r> �
FloatFieldr6 r" r! �historyr rd rA r� r rU rY r` rB r# r# r" r% r� A s� ��������
� � ���
� � ��� r� c @ s� e Zd ZdZejeejdded�d�Z ej
dd�Z ej
dddd d
�Z ej
dd�Z
ejd d�Zej
dddd �Zej
ddd
�Zej
ddd
�Zej
ddd�Zej
ddddd�Zejddd�Zedd�Zdefdd�Zdd� ZdS )�EmployeeBankDetailsz#
EmployeeBankDetails model
T�employee_bank_detailsr' )r: r6 r; r< r4 rE Fr� )r5 r6 r7 rL � rF )r5 r7 z Bank Code #1)r5 r< z Bank Code #2r? rI �+employee_id__employee_work_info__company_idrQ r� c C rP )N�-)r� � bank_namerZ r# r# r% r� � rR zEmployeeBankDetails.__str__c C s@ | j d ur tjj| jd�j| j d�}|r tdtd�i��d S d S )Nr� )�account_numberrt zCBank details for an employee with this account number already exist)rt rn rd �excluder� re r r� )rU � bank_detailsr# r# r% �clean� s
������zEmployeeBankDetails.cleanN) r� r� r� r� r r( r' r) r� r� r' rs rt �branchr, r- r. r/ r0 �any_other_code1�any_other_code2r= r> r rd rA r� rw r# r# r# r% rn � s> � � �� rn c @ s, e Zd Zejdddd�Ze�� Zdd� ZdS )� NoteFileszemployee/NoteFilesT)rA r7 r6 c C s | j j�d�d S )N�/���)�filesr~ �splitrZ r# r# r% r� rR zNoteFiles.__str__N) r� r� r� r � FileFieldr~ �Managerrd r� r# r# r# r% r{ s r{ c @ sl e Zd ZdZejeejdd�Zej e
d�ddd�Z ej e
dd�Zejeejd �Zed
d �Zd efd
d�ZdS )� EmployeeNotez
EmployeeNote model
�
employee_name)r: r; � Descriptionrp T)r< r5 r6 �r7 �r: rq rQ r� c C rE rt )� descriptionrZ r# r# r% r� rv zEmployeeNote.__str__N)r� r� r� r� r ra r' r) r� r, r� r� rd r{ �
note_files�
updated_byr rd rA r� r# r# r# r% r� s �
��r� c @ s e Zd ZdZejdd�ZdS )�PolicyMultipleFilez$
PoliciesMultipleFile model
zemployee/policies)rA N)r� r� r� r� r r� �
attachmentr# r# r# r% r� " s r� c sz e Zd ZdZejdd�Ze�� Zej dd�Z
ej e ddd�Z
ej edd�Zej eded �d
�Zed �Z� fd d
�Z� ZS )�Policyz
Policies model
r4 rE TrN F)r7 rO r� r rJ r^ c s$ t � j|i |�� | j�� �� d S rt )r �delete� attachments�allrT r" r# r% r� 8 s z
Policy.delete)r� r� r� r� r r' rG r, �bodyr< �is_visible_to_allrd r' �specific_employeesr� r� r r� r^ r rd r� rB r# r# r" r% r� * s r� c @ s� e Zd ZdZded�fded�fded�fded �fd
ed �fgZejeej d d d
d�Z
ej ddd�Z ej
ded d d�Zej d d d�Zejd d dd�Zedegd�Zedd�Zdd � Zd d � Zeeed �d d!� �Zd"S )#�
BonusPointzS
Model representing bonus points for employees with associated conditions.
z==�equals�>z grater than�<z less thanz>=zgreater than or equalz<=zless than or equalT� bonus_point)r: r7 r6 r; r z&Use negative numbers to reduce points.)rL � help_text�d )r5 rK r7 r6 rM rp )r7 r6 r5 rM rN rq rQ c C s | j � d| j� d�S )NrQ z Points)r� �pointsrZ r# r# r% r� b s zBonusPoint.__str__c C rW rX r rZ r# r# r% rY e rZ zBonusPoint.tracking)�senderc K s* t jj|jd��� st jj|d� dS dS )a�
Creates a BonusPoint instance for a newly created Employee if one doesn't already exist.
Args:
sender (Employee): The model class (Employee) sending the signal.
instance (Employee): The instance of the Employee model triggering the
post-save signal.
**_kwargs: Additional keyword arguments passed by the signal.
)�employee_id__idr� N)r� rd re r� r �create)r� �instance�_kwargsr# r# r% �bonus_post_savek s �zBonusPoint.bonus_post_saveN) r� r� r� r� r� �
CONDITIONSr r( r' r) r� r5 r� r' �encashment_condition�redeeming_pointsr, �reasonr" r! rm r rd r� rY r r
r� r# r# r# r% r� = sF
�������
r� c @ s| e Zd ZdZded�fded�fded�fgZejdd �Zejd
ed �Z ej
d e d
�dd�Z de
fdd�ZG dd� d�ZdS )�
Actiontypez
Action type model
�warning�Warning�
suspension�
Suspension� dismissal� Dismissalr4 rE rG )r5 rK FzEnable login block :z[If is enabled, employees log in will be blocked based on period of suspension or dismissal.)rL r< r� r� c C rE rt rF rZ r# r# r% r� � rv zActiontype.__str__c @ s e Zd Zed�Zed�ZdS )zActiontype.Metaz Action Typez Action TypesN)r� r� r� r� r< �verbose_name_pluralr# r# r# r% r � s r N)r� r� r� r� r$ �choice_actionsr r' rG � action_typer< r� � block_optionrA r� r r# r# r# r% r� z s
� �r� c @ s� e Zd ZdZded�fded�fgZejeed�d�Z ej
e ej d�Z
ejd d
�Zejd edd �Zejd
dd�Zejddd
egd�Zejd
d�Zejdd
d
d�Zed�Zde fdd�Z G dd� d�Z d S ) �DisciplinaryActionz
Disciplinary model
r� �Days�hours�Hours� Employees)r< r� rp rE rJ )r5 rK rL Tr� )r6 rL r� z00:00)r5 rL r6 �
validators)r6 zemployee/discipliner@ rq r� c C rE rt )�actionrZ r# r# r% r� � rv zDisciplinaryAction.__str__c @ s e Zd ZdgZdS )zDisciplinaryAction.Metaz-idN)r� r� r� r� r# r# r# r% r � s
r N) r� r� r� r� r� rK r rd r' r� ra r� r) r� r, r� r' �unit_inr5 r� r r� r2 �
start_dater� r� r rd rA r� r r# r# r# r% r� � s* � �r� c @ s8 e Zd ZdZejddd�Zejedej d�Z
e d�Z dS ) �EmployeeGeneralSettingz
EmployeeGeneralSetting
� �GN0)r5 rL T)r6 r: r^ N)
r� r� r� r� r r' �badge_id_prefixra r r) r^ r rd r# r# r# r% r� � s
r� )�ACCESSBILITY_FEATURE)� gender_chartzCan view Gender Chart)�department_chartzCan view Department Chart)�employees_chartzCan view Employees ChartN)Fr� r r r � django.appsr � django.confr �django.contrib.auth.modelsr r �django.core.exceptionsr �django.core.files.storager
� django.dbr �django.db.models.queryr �django.db.models.signalsr
�django.dispatchr �django.utils.translationr r� r r$ � base.horilla_company_managerr r
r r r r r r r r �!employee.methods.duration_methodsr r �horillar �horilla.methodsr �horilla.modelsr �horilla_audit.methodsr �horilla_audit.modelsr! r" r& �Modelr' rC r� rn r{ r� r� r� r� r� r� r� �accessibility.accessibilityr� r� r# r# r# r% �<module> sV (
3=