| 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/attendance/views/__pycache__/ |
Upload File : |
o
hͦh�: � @ s� d Z ddlZddlmZmZ ddlmZ ddlmZ ddlm Z ddl
m Z ddl
mZmZmZ dd lmZmZmZmZ dd
lmZmZmZ dd lmZ dd l m Z m Z dd
l m Z ddl!m"Z" ddl#m$Z$ ddl%m&Z&m'Z'm(Z( ddl)m*Z* d-dd�Z+dd� Z,e'e(d�dd� ��Z-e'e&dd� ��Z.e'e&dd � ��Z/e'e&d d � ��Z0d-d d �Z1d.d!d"�Z2d.d#d$�Z3d%d&� Z4e'd'd(� �Z5d)d*� Z6e'd+d,� �Z7dS )/zX
dashboard.py
This module is used to register endpoints for dashboard-related requests
� N)�date�datetime)�apps)� JsonResponse)�render)� gettext_lazy)�AttendanceFilters�AttendanceOverTimeFilter�LateComeEarlyOutFilter)�get_month_start_end_dates�get_week_start_end_dates�pending_hour_data�worked_hour_data)�
Attendance�AttendanceLateComeEarlyOut� AttendanceValidationCondition)�strtime_seconds)�filtersubordinates�
paginator_qry)�
Department)�Employee)�settings)�hx_request_required�login_required�permission_required)�get_horilla_model_classc C sJ d}t jj|d�}|dur|j|d�}tjj|dd�}t|�t|� }|S )zC
This method is used to find count for on time attendances
r )�attendance_dateN)�.employee_id__employee_work_info__department_id� late_come)� attendance_id__attendance_date�type)r �objects�filterr �len)�request�today�week_day�
department�on_time� attendancesr � r* �*/var/www/erp/attendance/views/dashboard.py� find_on_time( s ��r, c C sL t jjdd�}t�d�rtddd�}|jjdd�}ng }t|�t|� }|S )zT
This method is used to find count of expected attendances for the week day
T)� is_active�leave� leaverequest)� app_label�model�Approved)�status)r r! r" r � is_installedr r# )r& � employees� LeaveRequest�on_leave�expected_attendancesr* r* r+ �find_expected_attendances: s
r9 zattendance.view_attendancec C s� t �� }|�d��� }t| ||d�}t|d�}t|�}|| }t|d�}d}d} d}
|dkrF|| d d�}|| d d�} || d d�}
t| d|||| |||
d ��S )
zR
This method is used to render individual dashboard for attendance module
z%A)r% r& )�
start_date)r& r �d z.2fz#attendance/dashboard/dashboard.html)r( �
on_time_ratior �late_come_ratior8 �marked_attendances�marked_attendances_ratio) r r% �strftime�lowerr, �find_late_comer# r9 r ) r$ r% r& r( r �
late_come_objr> r8 r< r= r? r* r* r+ � dashboardH s6
���rD c C s, t �� }tjjd|d�}d|i}t| d|�S )a\
Fetches and displays employees who left early (early outs) for the current day.
This view retrieves all records from the `AttendanceLateComeEarlyOut` model
where the type is "early_out" and the associated attendance date matches the current date.
The results are passed to the template `on_break_employees.html` for rendering
� early_out)r r �on_breakz,attendance/dashboard/on_break_employees.html)r r% r r! r" r )r$ r% �
early_outs�contextr* r* r+ �on_break_employeesr s
�� rI c
C s� d}| j �dd�}dd�|�d�dd� � }|dkr d}| j�d�}tj�� }td�}|dur:|j dur:t|j �}t
jj |dddd �}t | d
|d �}d d
� |D �}t
�t|��}t||�}|||d�} t| d| �S )a�
Displays and validates employee overtime records for the dashboard.
This view retrieves a paginated list of employee attendance records with
overtime that meets or exceeds a specified minimum threshold, which is defined
in the `AttendanceValidationCondition` model. Only records that are validated
but not yet approved are included, and the results are filtered based on the
user's subordinate permissions.
N� HTTP_REFERER�/� T�page�00:00F��overtime_second__gte�attendance_validated�employee_id__is_active�attendance_overtime_approve�attendance.change_overtime�r$ �perm�querysetc S � g | ]}|j �qS r* ��id)�.0�otr* r* r+ �
<listcomp>� � z/dashboard_approve_overtimes.<locals>.<listcomp>)�overtime_attendances�ot_attendances_ids�main_dashboardz(attendance/dashboard/overtime_table.html)�META�get�join�split�GETr r! �firstr �minimum_overtime_to_approver r" r �json�dumps�listr r )
r$ ra �referer� page_number� condition�min_ot�ot_attendances�id_listr` rH r* r* r+ �dashboard_approve_overtimes� s:
��
� rr c C s� d}| j �dd�}dd�|�d�dd� � }|dkr d}| j�d�}tjjddd�}t| d |d
�}d d � |D �}t �
t |��}t ||�}|||d
�}t
| d|�S )aG
Displays and validates employee attendance records for the dashboard.
This view retrieves a paginated list of attendance records that have not yet
been validated. Only records belonging to active employees and accessible
subordinates, as determined by the user's permissions, are included in the results.
NrJ rK rL TrM F)rQ rR rT rU c S rX r* rY )r[ �valr* r* r+ r] � r^ z2dashboard_validate_attendances.<locals>.<listcomp>)�validate_attendances�validate_attendances_idsra z+attendance/dashboard/to_validate_table.html)rb rc rd re rf r r! r" r ri rj rk r r )r$ ra rl rm rt �validate_id_listru rH r* r* r+ � dashboard_validate_attendances� s,
��
� rw c C s t | ||d��j}|S )z6
This method is used to find total attendance
)�attendance_date__gte�attendance_date__lter' )r �qs)r: r' �end_date�
attendancer* r* r+ �total_attendance� s ���r} c C s6 |durt d|| |d��j}|S t d| |d��j}|S )z1
This method is used to find late comers
Nr �r r' rx ry �r rx ry �r
rz )r: r' r{ rC r* r* r+ rB � �( �������rB c C s6 |durt d|| |d��j}|S t d| |d��j}|S )zT
This method is used to find early out attendances and it returns query set
NrE r~ r r� )r: r{ r' �
early_out_objr* r* r+ �find_early_out r� r� c
C s� g }g }g }d}|dkr|}|}|dkrt |�\}}|dkr$t|�\}}|dkr,|}|}t|||d�}t|||d�}t|||d�}t|�t|� }i } |sQ|sQ|r^|j|t|�t|�gd�} | rb| S d S )
z@
This method is used to generate all the dashboard data
r �day�weekly�monthly�
date_range�r: r' r{ )r' r: r{ ��label�dataN)r r r} rB r� r# r' )
r$ r: r r{ �deptr| rC r� r( r� r* r* r+ �generate_data_set s< ��� � r� c C s� t d�t d�t d�g}g }t�� }|}d}| j�d�r!| j�d�}| j�d�r-| j�d�}| j�d�r9| j�d�}tj�� }|D ]
}|�t | ||||�� q@t d�}t
t d|��}t |||d ��S )
z�
This method is used to render json response of dashboard data
Returns:
JsonResponse: returns data set as json
zOn Timez Late Comez Early Outr r r{ z#No records available at the moment.N)�dataSet�labels�message)
�_r r% rf rc r r! �all�appendr� rk r" r ) r$ r� �data_setr: r{ r � departmentsr� r� r* r* r+ �dashboard_attendanceG s( �
r� c C sF t | j�j}ttjjddd��}|t||�t||�gd�}t d|i�S )z,
pending hours chart dashboard view
r' T)�flat)r� �datasetsr� )
r rf rz rk r r! � values_listr
r r )r$ �recordsr� r� r* r* r+ �
pending_hoursk s �� r� c C s | j �d�r | j �d�nt�� }| j �d�r | j �d�nd}| j �d�r*| j �d�n|}|dkr4|}|}|dkr>t|�\}}|dkrHt|�\}}|dkrP|}|}t|d |d�}tj� � }t
d �}|d urn|j d urnt
|j �}|j |d
d
d
d �}g }g } |D ]}|j
r�|j
jr�|j
jjr�|�|j
jjj� q}tt|��}|D ]
}
| �|
d d
�� q�|D ]'}|j
jjr�|j
jjj} |j} | d }
| D ]}
|
d | kr�|
d |
7 < q�q�dg d�g}t| |�D ]\}}
|
|d kr�|d d �|d � q�||| td�dtj� d�d�}t|�S )Nr r r� r{ r� r� r� r� rN TrO r )r' �ot_hoursi r' r� � r� r� z!No validated Overtimes were foundrK zimages/ui/overtime-icon.png)�datasetr� �department_totalr� �
emptyImageSrc)rf rc r r% r r r} r r! rg r rh r" � employee_id�employee_work_info�
department_idr� r' rk �set�approved_overtime_second�zipr� r �
STATIC_URLr )r$ r: �
chart_typer{ r| rn ro r) r� r� �departr' r\ �ot_hrsr� � depart_total�responser* r* r+ �department_overtime_chart| s� � �
����
��
� ��� � �r� )N)NN)8�__doc__ri r r � django.appsr � django.httpr �django.shortcutsr �django.utils.translationr r� �attendance.filtersr r r
�attendance.methods.utilsr r r
r �attendance.modelsr r r �attendance.views.viewsr � base.methodsr r � base.modelsr �employee.modelsr �horillar �horilla.decoratorsr r r �horilla.methodsr r, r9 rD rI rr rw r} rB r� r� r� r� r� r* r* r* r+ �<module> sP
( ,
$
/
#