| 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/asset/__pycache__/ |
Upload File : |
o
hͦha
� @ s\ d Z ddlZddlZddlZddlmZmZ ddlmZ ddlZ ddl
m Z ddl m
Z
ddlmZ ddlmZ dd lmZ dd
lmZmZmZ dd lmZmZmZ dd l m Z dd
l m Z ddl!m"Z"m#Z#m$Z$m%Z%m&Z&m'Z'm(Z(m)Z)m*Z*m+Z+ ddl,m-Z-m.Z.m/Z/m0Z0m1Z1m2Z2m3Z3 ddl4m5Z5m6Z6m7Z7m8Z8m9Z9m:Z:m;Z; ddl<m=Z=m>Z>m?Z?m@Z@mAZAmBZBmCZC ddlDmEZE ddlFmGZGmHZH ddlImJZJ ddlKmLZLmMZMmNZNmOZOmPZP ddlQmRZR ddlSmTZT ddlUmVZV ddlWmXZX dd� ZYeMeLePd �d d � ���ZZeMd�d d ��Z[eMeLePd!�d"d#� ���Z\eMeLd$d%� ��Z]eMePd&d'�d(d)� ��Z^eMeLd*d+� ��Z_eMeLePd,d'�d-d.� ���Z`eMeLePd/d'�d0d1� ���ZaeMePd2d'�d3d4� ��Zbd5d6� ZceMePd7d'�d8d9� ��ZdeMePd7d'�d:d;� ��Zed<d=� ZfeMeLd>d?� ��ZgeMeLePd@d'�dAdB� ���ZhdCdD� ZieMePd@d'�dEdF� ��ZjeMePd@d'�dGdH� ��ZkeMdIdJ� �ZleMePdKd'�dLdM� ��ZmdNdO� ZneMePdP�dQdR� ��ZoeMdSdT� �ZpeMeLdUdV� ��ZqeMeLdWdX� ��ZreMeLdYdZ� ��Zsd[d\� Zted]d^�Zud_d`� Zvdadb� ZweMePd d'�dcdd� ��ZxeMdedf� �ZyeMePd7�dgdh� ��ZzeMePdid'�djdk� ��Z{eMePdld'�dmdn� ��Z|eMePdod'�dpdq� ��Z}eMePdrd'�dsdt� ��Z~eMeLdudv� ��ZeMdwdx� �Z�eMePd7d'�dydz� ��Z�eMePdPd'�d{d|� ��Z�eMePd}d'�d~d� ��Z�eMePd7d'�d�d�� ��Z�eMePd7d'�d�d�� ��Z�eMePd}d'�d�d�� ��Z�eMePd}d'�d�d�� ��Z�eMePd}d'�d�d�� ��Z�eMeOd�eG�d�d�� ��Z�eMeLd�d�� ��Z�eMeLd�d�� ��Z�dS )�z#"
asset.py
This module is used to � N)�date�datetime)�parse_qs)�messages)� ContentFile)�FileSystemStorage)� Paginator)�ProtectedError)� HttpResponse�HttpResponseRedirect� JsonResponse)�get_object_or_404�redirect�render)�reverse)� gettext_lazy)
�AssetAllocationFilter�AssetAllocationReGroup�AssetCategoryFilter�AssetExportFilter� AssetFilter�AssetHistoryFilter�AssetHistoryReGroup�AssetRequestFilter�AssetRequestReGroup�CustomAssetFilter)�AssetAllocationForm�AssetBatchForm�AssetCategoryForm� AssetForm�AssetReportForm�AssetRequestForm�AssetReturnForm)�Asset�AssetAssignment�
AssetCategory�AssetDocuments�AssetLot� AssetRequest� ReturnImages)�closest_numbers�
eval_validate�filtersubordinates�get_key_instances�get_pagination�
paginator_qry�sortby)�Company)�Employee�EmployeeWorkInformation)�settings)�hx_request_required�login_required�manager_can_enter�owner_can_enter�permission_required)�group_by_queryset)�HORILLA_DATE_FORMATS)�horilla_users_with_perms)�notifyc C sD z|� � t�| td�� W dS ty! t�| td�� Y dS w )zJ
Handle the deletion of an asset and provide message to the user.
zAsset deleted successfullyz You cannot delete this asset.N)�deleter �success�_r �error)�request�asset� rD �/var/www/erp/asset/views.py� asset_delN s �rF zasset.add_assetc C s� d|i}| j �d�rt| j |d�nt|d�}| jdkr8t| j|d�}|�� r8|�� t�| t d�� t
d|d�S d|i}t | d |�S )
a{
View function for creating a new asset object.
Args:
request (HttpRequest): A Django HttpRequest object that contains information
about the current request.
asset_category_id (int): An integer representing the ID of the asset category for which
the asset is being created.
Returns:
If the request method is 'POST' and the form is valid, the function saves the
new asset object to the database
and redirects to the asset creation page with a success message.
If the form is not valid, the function returns the asset creation page with the
form containing the invalid data.
If the request method is not 'POST', the function renders the asset creation
page with the form initialized with
the ID of the asset category for which the asset is being created.
Raises:
None
�asset_category_id�csrfmiddlewaretoken��initial�POSTzAsset created successfully�asset-creation)rG �asset_creation_formzasset/asset_creation.html) �GET�getr �methodrK �is_valid�saver r? r@ r r )rB rG � initial_data�form�contextrD rD rE �asset_creationY s
��
rV c C s� t � }|r1tjj|d�}t d|id�}| j�d�s1| jjtjj|dd�jks,| j� d�r-nt
t �S | j dkrrt | j
| jd|id�}|�� rr|�� }t�| td �� |�� rr| jrr| j�d
�D ]
}tjj||d � q^t| j�d d
��S t| d||d��S )z7
Function for adding asset report to the asset
��id�asset_idrI �
asset_listT)rY �return_date__isnull�asset.change_assetrK zReport added successfully.�file)� asset_reportr] � HTTP_REFERER�/z asset/asset_report_form.html)�asset_report_formrY )r r# �objectsrO rN �user� employee_getr$ �assigned_to_employee_id�has_permr � asset_request_allocation_viewrP rK �FILESrQ rR r r? r@ �getlistr& �creater �METAr )rB rY ra rC r^ r] rD rD rE �add_asset_report� s< ��
�
��rl r\ c
C s� | j dkr | j�d�}n | j dkr| j�d�}|sd}tjj|d�}t|d�}| j�� }| j dkrHt| j|d�}|�� rH|� � t
� | t d�� |||||j
jd�}| j�d �}|rvt�|�}| j�� } | �d d
� | �� }||d < ||d < t| d |d
�S )an
Updates an asset with the given ID.
If the request method is GET, it displays the form to update the asset. If the
request method is POST and the form is valid, it updates the asset and
redirects to the asset list view for the asset's category.
Args:
- request: the HTTP request object
- id (int): the ID of the asset to be updated
Returns:
- If the request method is GET, the rendered 'asset_update.html' template
with the form to update the asset.
- If the request method is POST and the form is valid, a redirect to the asset
list view for the asset's category.
rN � asset_underrK �asset_categoryrW ��instancez
Asset Updated)rp �
asset_formrm �pg� asset_cat_id� requests_idsN�pdzasset/asset_update.html�rU )rP rN rO rK r# rb r � urlencoderQ rR r r? r@ rG rX �json�loads�copy�popr )
rB rY rm rp rq �
previous_datarU �requests_ids_jsonrt � request_copyrD rD rE � asset_update� s:
�
r c C �b t jj|d�}d|i}| j�d�}|r+t�|�}t||�\}}||d< ||d< ||d< t| d|�S )a
Display information about a specific Asset object.
Args:
request: the HTTP request object
asset_id (int): the ID of the Asset object to retrieve
Returns:
A rendered HTML template displaying the information about the requested Asset object.
rW rC rt �previous�nextz asset/asset_information.html)r# rb rO rN rx ry r* r )rB rY rC rU r} rt � previous_id�next_idrD rD rE �asset_information� s
r� zasset.delete_asset)�permc C sj | j �� }|�dd� |�� }z tjj|d�}W n tjy3 t� | t
d�� t | j �dd�� Y S w |j
j}|j}| j �d�}tjj|d��� }|r�d } tj�� }
| j �� }t| j |
d
�} | j} t| t� �}
| j �d �}|
�|�}|||j
j| d �}|d
kr�t�| t
d�� n|r�t� | t
d�� nt| |� t | j �dd��S | j �dd�}t|�}|d
kr�t�| t
d�� t d|j� d|� d|� d��S |r�t� | t
d�� t d|j� d|� d|� d��S t| |� t t|��dkr�t d�S t� |j��rt d|j� d|� d|� d��S | j �d�}t �!|�}||v �r |�"|� t#t �!|�|�\}}t d|� d|� d|� d��S )aq Delete the asset with the given id.
If the asset is currently in use, display an info message and
redirect to the asset list.
Otherwise, delete the asset and display a success message.
Args:
request: HttpRequest object representing the current request.
asset_id: int representing the id of the asset to be deleted.
Returns:
If the asset is currently in use or the asset list filter is
applied, render the asset list template
with the corresponding context.
Otherwise, redirect to the asset list view for the asset
category of the deleted asset.
rt NrW zAsset not foundr_ r` rZ )rY � asset_filter��queryset�page)�assetsrr rG rm �In usezAsset is in usez Asset is used in allocation!.�[]z/asset/asset-information/z/?z&requests_ids=z&asset_info=true� �*<script>window.location.reload();</script>)$rN rz r{ rw r# rb rO � DoesNotExistr rA r@ r rk rG rX � asset_statusr$ �filter�first�allr �qsr r. �get_page�inforF r+ r �lenr
�findrx ry �remover* )rB rY r~ r| rC rs �status�asset_list_filter�asset_allocationrm r� �asset_filteredrZ � paginator� page_number�page_objrU �
instances_ids�instances_list�previous_instance�
next_instancerD rD rE � asset_delete� s|
�
�
��
�
��r� c C s� i }d}t | j�}|j}t|t� �}| j�d�}|�|�}t�dd� |j D ��} | j�
� }
t |
�} t t
| � ||
||t|�p?d| | d�}t| d|�S )a�
View function is used as asset list inside a category and also in
filter asset list
Args:
request (HttpRequest): A Django HttpRequest object that contains
information about the current request.
cat_id (int): An integer representing the id of the asset category
to list assets for.
Returns:
A rendered HTML template that displays a paginated list of assets in the given
asset category.
Raises:
None
� r� c S � g | ]}|j �qS rD rW ��.0rp rD rD rE �
<listcomp>l � z asset_list.<locals>.<listcomp>N)r� rr rG rm � asset_count� filter_dictrt zasset/asset_list.html)r rN r� r r. rO r� rx �dumps� object_listrw r r- r# r� r ) rB �cat_idrU rm r� rZ r� r� r� rt r| � data_dictrD rD rE rZ R s(
� rZ zasset.add_assetcategoryc C sn t � }| jdkr-t | j�}|�� r-|�� t�| td�� t � }tj �
� � � dkr-t d�S d|i}t
| d|�S )z�
Allow a user to create a new AssetCategory object using a form.
Args:
request: the HTTP request object
Returns:
A rendered HTML template displaying the AssetCategory creation form.
rK z#Asset category created successfullyr� r� �asset_category_formz%category/asset_category_creation.html)r rP rK rQ rR r r? r@ r% rb r� �countr
r )rB r� rU rD rD rE �asset_category_creation| s
r� zasset.change_assetcategoryc C sz | j �� }tjj|d�}t|d�}||d�}| jdkr7t| j|d�}|�� r3|� � t
� | t d�� n||d< t
| d|�S )z�
This view is used to update an existing asset category.
Args:
request: HttpRequest object.
id: int value representing the id of the asset category to update.
Returns:
Rendered HTML template.
rW ro )�asset_category_update_formrr rK z#Asset category updated successfullyr� z#category/asset_category_update.html)rN rw r% rb rO r rP rK rQ rR r r? r@ r )rB r� r| rn r� rU rD rD rE �asset_category_update� s
r� zasset.delete_assetcategoryc C sj | j �� }ztjj|d��� t�| td�� W n t� | td�� Y tj�
� s.t d�S t d|� ��S )z6
This method is used to delete asset category
rW zAsset category deleted.z(Assets are located within this category.r� z)/asset/asset-category-view-search-filter?)
rN rw r% rb rO r> r r? r@ rA r� r
r )rB r� r| rD rD rE �delete_asset_category� s
r� c
C s� | j �dd�}| j �� }tj�� }| j r"t| j |d�}|j}|j}nd}t |t
� �}| j �d�}|� |�}t |�} t
t| � t� }
| �d�rI| d= t� } t� } |
| ||| j|| | j �d�d�S ) zI
This view is used for pagination and filtering asset categories
�searchr� r� Nr� �type� dashboard)rM r� �asset_categories�asset_category_filter_form�asset_filter_formrr r� r� )rN rO rw r% rb r� r r� rT r r. r� r r- r r r )
rB r� r| �asset_category_queryset�asset_category_filtered� asset_category_filtered_form�asset_category_paginatorr� r� r� rM r� r� rD rD rE � filter_pagination_asset_category� s<
��
�r� zasset.view_assetcategoryc C s0 t j�� }|�� r d}nd}t| �}t| ||�S )aH
View function for rendering a paginated list of asset categories.
Args:
request (HttpRequest): A Django HttpRequest object that contains information
about the current request.
Returns:
A rendered HTML template that displays a paginated list of asset categories.
Raises:
None
z!category/asset_category_view.htmlzcategory/asset_empty.html)r% rb r� �existsr� r )rB r� �templaterU rD rD rE �asset_category_view� s
r� c C s t | �}t| d|�S )a�
View function for rendering a paginated list of asset categories with search and filter options.
Args:
request (HttpRequest): A Django HttpRequest object that contains information
about the current request.
Returns:
A rendered HTML template that displays a paginated list of asset
categories with search and filter options.
Raises:
None
z category/asset_category.html)r� r )rB rU rD rD rE �!asset_category_view_search_filter s r� c C sv dd� | �d�dd� � } ddddd�}|�| d�\}}|d kr/t|d
|jjid �}||fS |r5t|�nd}||fS ) zf
Determines the hx_url and hx_target based on the referer path
for asset request creation
r` � N)�asset-dashboard-requests�dashboardAssetRequests)�+asset-request-allocation-view-search-filter� asset_request_allocation_list)�profile-asset-tab� asset_target)r` �/asset/dashboard/z%/asset/asset-request-allocation-view/z/employee/employee-profile/)NNr� �emp_id��kwargs)�join�splitrO r rd rX )�refererrc �hx_map�hx_url� hx_targetrD rD rE �request_creation_hx_returns s �
��r� c C s� | j �dd�}t|| j�\}}t| jd�}|||d�}| jdkr<t| j| jd�}|�� r8|�� t �
| t d�� ||d< t | d|�S ) a,
Creates a new AssetRequest object and saves it to the database.
Renders the asset_request_creation.html template if the request method is GET.
If the request method is POST and the form data is valid, the new
AssetRequest is saved to the database and
the user is redirected to the asset_request_view_search_filter view.
If the form data is invalid, or if the request method is POST but the
form data is not present, the user is
presented with the asset_request_creation.html template with error
messages displayed.
r_ r` )rc )�asset_request_formr� r� rK zAsset request created!r� z.request_allocation/asset_request_creation.html)
rk rO r� rc r! rP rK rQ rR r r? r@ r )rB r� r� r� rT rU rD rD rE �asset_request_creation9 s
r� zasset.add_assetassignmentc
C s� t �|�}| �d�}d|� d�}|s t�| td�� t|�S |jjj dd�}| j
dkr�| j � � }|j
|d< | jj|d < t|| j�}|�� r�zK|jd
}d |_|�� |jd d
�} | jj| _| �� d|_|�� tj| jj| jjtd�t d�d|j � d|j� � dd� t� | td�� td�W S t y� }
zt�| td�t |
� � t|�W Y d}
~
S d}
~
ww n t� }||j!d
_"||d�} t#| d| �S )z}
Approves an asset request with the given ID and updates the corresponding asset record
to mark it as allocated.
r` z <script>window.location.href = "z ";</script>z Asset request does not exist.� Available�r� rK re �assigned_by_employee_idrY r� F)�commit�Approvedz%Your asset request has been approved!� asset-request-allocation-view�?asset_request_date=z&asset_request_status=� bag-check)� recipient�verbr �iconz$Asset request approved successfully!r� zAn error occurred: N)�asset_allocation_formrX z%request_allocation/asset_approve.html)$r( r� �build_absolute_urir rA r@ r
rG � asset_setr� rP rK rz �requested_employee_idrc rd r rh rQ � cleaned_datar� rR r� �asset_request_statusr= �sendre �employee_user_idr �asset_request_dater? � Exception�str�fieldsr� r ) rB �req_id�
asset_request� homepage_url�error_responser� � post_datarT rC �
allocation�erU rD rD rE �asset_request_approveW s\
�
���
���
r� c C s | j �d�st| j �dd��S | j �d�}|dkrAz t�| j�dd��}W n tjy1 g }Y nw ttdd |id
�d |� � �S | j �dd �}dd� |�
d�d
d � � }|� d�rdtd|j j
� ��S |�d�sm|dkrsttd��S ttd�� d| j�� � ��S )N�HTTP_HX_REQUESTr_ r` �HTTP_HX_TARGET�objectDetailsModalW25Targetrt r� z asset-request-individual-view�asset_request_idr� z?requests_ids=r� r� z/employee/employee-view/z/asset/asset-request-tab/r� r� r� �?)rk rO r rx ry rN �JSONDecodeErrorr r r� r� �
startswithr� rX �endswithrw )rB r� r� r� rt �referrerrD rD rE �reject_request_return� s6 ����
� �r c
C sn t jj|d�}|�� t�| td�� tj| j j
|j j dddddt
d�d |j� d
|j� � d d � t| ||�S )
a�
View function to reject an asset request.
Parameters:
request (HttpRequest): the request object sent by the client
req_id (int): the id of the AssetRequest object to reject
Returns:
HttpResponse: a redirect to the asset request list view with a success
message if the asset request is rejected successfully, or a redirect to the
asset request detail view with an error message if the asset request is not
found or already rejected
rW z Asset request has been rejected.z Your asset request rejected!.u0 تم رفض طلب الأصول الخاص بك!z"Ihr Antragsantrag wurde abgelehnt!u) ¡Se ha rechazado su solicitud de activo!u( Votre demande d'actif a été rejetée !r� r� z &asset_request_status=r� �r� r� �verb_ar�verb_de�verb_es�verb_frr r� )r( rb rO rR r r� r@ r= r� rc rd r� r� r r� r� r )rB r� r� rD rD rE �asset_request_reject� s&
���
r
c C s� t d| jjid�}d|i}| jdkrnt | j�}|�� rj|jjj}t j
j |d�� � }d|_
|�� |�� }| j�d�}g }| jrY|D ]}t� }||_|�� |�|� qA|jj|� t d| jjid�}t�| td�� ||d< t| d |�S )
zY
View function to create asset allocation.
Returns:
- to allocated view.
r� rI r� rK rW r� �
assign_imagesz Asset allocated successfully!.z1request_allocation/asset_allocation_creation.html)r rc rd rP rK rQ rp rY rX r# rb r� r� r� rR rh ri r) �image�appendr �addr r? r@ r ) rB rT rU rC rp �files� attachmentsr] �
attachmentrD rD rE �asset_allocate_creation� s6
�
� r c C s | j �� }tjj|d�}d|_|�� td��|j �}t
� | |� t d�}t
j| jj|d|j � d|j� �d|j � d|j� �d |j � d
|j� d �d |j � d
|j� �d|j � d|j� �td�d|j� d|j � d|j� � dd� | j�d�dkr�td�}t|� d|� ��S t| j�dd��S ) zK
Handle the initiation of a return request for an allocated asset.
rW Tz Return request for {} initiated.� asset.change_assetassignmentzReturn request for z initiated from u/ تم بدء طلب الإرجاع للمورد u من الموظف u Rückgabewunsch für z vom Mitarbeiter z
initiiertu Solicitud de devolución para z% iniciada por el empleado zDemande de retour pour u$ initiée par l'employé r� z?assigned_to_employee_id=z& asset_id=z&assigned_date=r� r r� �truer� r� r_ r` )rN rw r$ rb rO �return_requestrR r@ �formatrY r r? r< r= r� rc rd re r �
assigned_daterk r r )rB rY r| � asset_assign�message� permed_users�urlrD rD rE � asset_allocate_return_request� sL
�
�
�
�
�
����r r c C s� t � }tjj|dd��� }| jdkr�t | j| j�}|�� r�t jj|d��� }| j�
d�}| j�
d�}| j�
d�}| j� d�}g } ||d �}
t | d
|
�} |d kr�tjj|dd��� }||_
||_||_d |_|�� | jr�|D ]} t� }
| |
_|
�� | �|
� qn|jj| � d
|_|�� t�| td�� t| j � d�d �S d|_|�� tjj|dd��� }||_
||_||_|�� | jr�|D ]} t� }
| |
_|
�� | �|
� q�|jj| � t�| td�� t| j � d�d �S ||d �}
||
d< t | d
|
�S )z�
View function to return asset.
Args:
- asset_id: integer value representing the ID of the asset
Returns:
- message of the return
T)rY �return_status__isnullrK rW �
return_status� return_date�return_condition�
return_images)�asset_return_formrY z asset/asset_return_form.html�HealthyFr� zAsset Return Successful !.zutf-8�#<script>location.reload();</script>�
Not-AvailablezAsset Return Successful!.�asset_alocation) r" r$ rb r� r� rP rK rh rQ r# rO ri r r r r r rR r) r r
r! r r� r r� r@ r
�content�decode)rB rY r" r� rC �asset_return_status�asset_return_date�asset_return_conditionr r rU �responser] r rD rD rE �asset_allocate_return! s� ��
��
���� �
r- c C s� | j �d�}| j �d�}| j �d�}|du rd}| jj}tj�� }t| dtj�� dd�tjj | jjd �B }|�
� }| j �d
�rEt | |d
�}| j �d �rQt | |d �}|j |d �j d
d�j |d�}| j �
� }t| j |d�} t| j |d�j}
|dkr�|dur�t|
|| j �d�d�}
dd� |
D �} g } | D ]}
|
jD ]}| �|j� q�q�t�t| ��}nt|
| j �d��}
t�dd� |
jD ��}t| j |d�j}|dkr�|dur�t||| j �d�d�}dd� |D �} g } | D ]}
|
jD ]}| �|j� q�q�t�t| ��}nt|| j �d��}t�dd� |jD ��}t|| j �d��}t�dd� |jD ��}t| jt� �}| j �d�}|� |�}t |�}t t|� t t|� t t |� ||
|| j t� j t� j ||t!j"t#j"|||||d�S )a�
Filter and paginate asset request and allocation data based on search criteria and sort options.
This function handles the retrieval, filtering, and pagination of asset request and allocation
data.It processes GET parameters to search, sort, and filter asset requests and allocations,
and returns a context dictionary with the filtered data and associated forms for rendering in
a template.
r� �
request_field�allocation_fieldNr� �asset.view_assetrequestr� )rB r� r� �field)r� �
assign_sortby�request_sortby)re F)r )� asset_id__asset_name__icontainsr� r� c S � g | ]}|d �qS ��listrD �r� �entryrD rD rE r� � � z>filter_pagination_asset_request_allocation.<locals>.<listcomp>c S r� rD rW r� rD rD rE r� � r� c S r5 r6 rD r8 rD rD rE r� � r: c S r� rD rW r� rD rD rE r� � r� c S r� rD rW r� rD rD rE r� � r� )r� �asset_requests�asset_allocations�assets_filter_form�asset_request_filter_form� asset_allocation_filter_formrr r� �gp_request_fields�gp_Allocation_fieldsr. r/ rt �allocations_ids� asset_ids)$rN rO rc rd r$ rb r� r, r( r� �distinctr0 �excluderw r r r� r: r� r
rX rx r� r7 r/ r r r. r� r r- r# rT r r� r )rB � asset_request_allocation_searchr. r/ �employee�asset_assignmentr� r� r| �assets_filtered�asset_request_filtered� list_values�id_list�valuerp rt �asset_allocation_filteredrB �
assets_ids� assets_id�asset_paginatorr� r� rD rD rE �*filter_pagination_asset_request_allocationm s�
��
���
�
� �����
� ��
�rR r0 c C �\ t | �}d}| j�d�dkr| j�d�dus&| j�d�dkr(| j�d�dur(d}t| ||�S )z�
This view is used to display a paginated list of asset allocation requests.
Args:
request (HttpRequest): The HTTP request object.
Returns:
HttpResponse: The HTTP response object with the rendered HTML template.
z5request_allocation/asset_request_allocation_view.htmlr. r� Nr/ � request_allocation/group_by.html�rR rN rO r �rB rU r� rD rD rE rg � s
rg c C rS )a
This view handles the search and filter functionality for the asset request allocation list.
Args:
request: HTTP request object.
Returns:
Rendered HTTP response with the filtered and paginated asset request allocation list.
z5request_allocation/asset_request_allocation_list.htmlr. r� Nr/ rT rU rV rD rD rE �+asset_request_alloaction_view_search_filter� s rW c C sj t jj|d�}|j}||d�}| j�d�}|r/t�|�}t||�\}}||d< ||d< ||d< t| d|�S )z�
This function is responsible for view the individual own asset
Args:
request : HTTP request object
id (int): Id of the asset assignment
rW )rC rH rO r� r� z&request_allocation/individual_own.html) r$ rb rO rY rN rx ry r* r ) rB rY rH rC rU r} rt r� r� rD rD rE �own_asset_individual_view s
�
rX c C sz | j �dd��d� }tjj|d�}||d�}| j�d�}|r7t�|�}t||�\}}||d< ||d< ||d< t | d |�S )
ai
Display the details of an individual asset request.
This view retrieves the asset request with the given ID and renders it in the
'individual_request.html' template. If a JSON-encoded list of request IDs is
provided in the GET parameters, the view also determines the previous and next
request IDs for easy navigation.
Args:
request (HttpRequest): The HTTP request object containing metadata about the request.
id (int): The ID of the asset request to be viewed.
Returns:
HttpResponse: The rendered 'individual_request.html' template with the context data.
�HTTP_HX_CURRENT_URLr� z asset-request-allocation-view/rW )r� r� rt r� r� z*request_allocation/individual_request.html)
rk rO r r( rb rN rx ry r* r ) rB r� r� r� rU r} rt r� r� rD rD rE � asset_request_individual_view" s ��
rZ c C r� )a~
Display the details of an individual asset allocation.
This view retrieves the asset allocation with the given ID and renders it in the
'individual_allocation.html' template. If a JSON-encoded list of allocation IDs is
provided in the GET parameters, the view also determines the previous and next
allocation IDs for easy navigation.
Args:
request (HttpRequest): The HTTP request object containing metadata about the request.
id (int): The ID of the asset allocation to be viewed.
Returns:
HttpResponse: The rendered 'individual_allocation.html' template with the context data.
rW r� rB r� r� z-request_allocation/individual allocation.html)r$ rb rO rN rx ry r* r )rB �asset_allocation_idr� rU �allocation_ids_json�allocation_idsr� r� rD rD rE � asset_allocation_individual_viewF s
r^ c C s t �| �rdS | S )z%
Convert NaN values to None.
N)ru �isna)�valrD rD rE � convert_nand s
ra zcsv_tmp/)�locationc C s� t | �� �}t�d|�}t�|�}t|dd��C}t�|�}t|� g }|D ]-}|\}} }
} } }
}}t j
j |
d�\}}t j
j |d�\}}|�
t|| |
| | |||d�� q%W d � n1 s]w Y tj
�|� tj�|�rut�|� d S d S )Nz_tmp.csv�ignore)�errors��asset_category_name��
lot_number)�
asset_name�asset_description�asset_tracking_id�asset_purchase_date�asset_purchase_costr� rG �asset_lot_number_id)r �read�fsrR �path�open�csv�readerr� r% rb �
get_or_creater' r
r# � bulk_create�osr� r� )r] � file_content� file_name�tmp_file�csv_filert rZ �rowri rj rk rl rm rf r� �asset_lot_numberrn r@ � asset_lotrD rD rE �csv_asset_importp sP
�
���� � % �r c C s� | � � D ]T\}}t|d �}t|d �}t|d �}t|d �}t|d �}t|d �}t|d �} t|d �}
tjj|d �\} } tjj| d
�\}
} tjj|||||| |
|
d � qd S ) N�
Asset name� Description� Tracking id�
Purchase date�
Purchase cost�Category� Batch number�Statusre rg �ri rj rk rl rm rG r� rn )�iterrowsra r% rb ru r' r# rj )� dataframe�indexr| ri rj rk �
purchase_date�
purchase_cost�
category_namerh r� rn rj r} rD rD rE �spreadsheetml_asset_import� s0
���r� c
C sX | j �d�r t| d�S z�| jdkr�| j�d�}|durH|jdkrHzt|� t�| t d�� W nW t
yG } z
t� | |� � W Y d}~nCd}~ww |dur~|jdkr~zt �
|�}t|� t�| t d�� W n! ty} } z
t� | |� � W Y d}~n
d}~ww t� | t d �� tt�W S W tt�S t
y� } zt� | |� � W Y d}~tt�S d}~ww )
a/
Handle the import of asset data from an uploaded Excel file.
This view processes a POST request containing an Excel file, reads the data,
creates Asset objects from the data, and saves them to the database. If the
import is successful, a success message is displayed. Otherwise, appropriate
error messages are shown.
Args:
request (HttpRequest): The HTTP request object containing metadata about the request.
Returns:
HttpResponseRedirect: A redirect to the asset category view after processing the import.
r� zasset/asset_import.htmlrK � asset_importNztext/csvz Successfully imported AssetszAapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheetz
File Error)rk rO r rP rh � content_typer r r? r@ r� rA ru �
read_excelr� �KeyErrorr r� )rB r] � exceptionr� rD rD rE r� � sD
���
��
����r� c
C sh z g d�}t j|d�}tdd�}d|d< |j|dd� |W S ty3 } z
t|�W Y d }~S d }~ww )
zasset excel download view)r� r� r� r� r� r� r� r� ��columnszapplication/ms-excel�r� z)attachment; filename="my_excel_file.xlsx"�Content-DispositionF�r� N)ru � DataFramer
�to_excelr� )�_requestr� r� r, r� rD rD rE � asset_excel� s
��r� c
C s� t | jtj�� d�}| jdkr�tj�� }|s"t�| td�� t d�S t | j
|d�j }g g g g g g g g d�}g d�}|D ]h}|D ]c}t ||�}t
|t�r�| j} | j}
tjj|
d�} | �� rw| D ]} | j}
q^tjj|
d�}|�� }|rt|jnd}nd}t�t|�d ��� }t� � D ]
\}}||kr�|� |�}q�|| � |d
ur�|nd
� q?q;|D ]}|| d
gt |�t || � ||< q�t �!|�}|j"d d d
dddddd�d�}t#dd�}d|d< |j$|dd� |S d|i}t%| d|�S ) zasset export viewr� rK z There are no assets to export.zasset-category-viewr� )� employee_id)�companyz MMM. D, YYYYz%Y-%m-%dNr� r� r� r� r� r� r� r� r� zapplication/vnd.ms-excelr� z"attachment; filename="assets.xlsx"r� Fr� �asset_export_filterz!category/asset_filter_export.html)&r rN r# rb r� rP r �warningr@ r rK r� �getattr�
isinstancer rc rd r3 r� r� �
company_idr1 r� � date_formatr �strptimer� r; �items�strftimer
r� ru r� �renamer
r� r )rB r� � queryset_allr� �data�fields_to_checkrC r1 rM rc �empr� �i�employee_company� company_name� emp_companyr� �
start_date� format_name�
format_string�keyr� r, rU rD rD rE �asset_export_excel sv
�
�
� �#(
��
r� zasset.add_assetlotc C s
| j �d�r | j �d�n| j �� }t� }||ddd�}| jdkrt| j�}|�� r{|�� t� }t� | t
d�� t j �
� �� dkrG|sGtd�S |r{| j �d�}td |gd
�}t j �� �d ��� }| j �� }t|j�|d < |� d
|�� � �|d< d|d< ||d< t| d|�S )z asset batch number creation viewr� N)�asset_batch_form�hx_vals�hx_getr� rK z"Batch number created successfully.r� r$ rG rL )�args�-idrn r� r� z#objectCreateModalTargetr� r� z&batch/asset_batch_number_creation.html)rN rO rw r rP rK rQ rR r r? r@ r' rb r� r� r
r r� �order_byr� rz r� rX r )rB r� r� rU � category_idr rp � mutable_getrD rD rE �asset_batch_number_creationk s4 ��
r� zasset.view_assetlotc C sf t j�� }| j�� }t|t� �}| j�d�}|�|�}t � }|�
� r%d}nd}|||d�}t | ||�S )z{
View function to display details of all batch numbers.
Returns:
- all asset batch numbers based on page
r� z"batch/asset_batch_number_view.htmlz batch/asset_batch_empty.html)�
batch_numbersr� rr ) r' rb r� rN rw r r. rO r� r r� r ) rB �
asset_batchesr| �$asset_batch_numbers_search_paginatorr� �asset_batch_numbersr� r� rU rD rD rE �asset_batch_view� s
� r� zasset.change_assetlotc C s� t jj|d�}t jj|d�}t|d�}d|i}tjj|d�}|rBt|d�}|d jjj� ddi� ||d< | j
dkr>t d�nd |d
< | j
d krbt| j |d�}|�
� r^|�� t�| t d �� ||d< t| d
|�S )��
View function to return asset.
Args:
- batch_id: integer value representing the ID of the asset
Returns:
- message of the return
rW ro �asset_batch_update_form�rn rh �readonlyrN z#This batch number is already in-useN�in_use_messagerK zBatch updated successfully.z$batch/asset_batch_number_update.html)r' rb rO r r# r� r1 �widget�attrs�updaterP r@ rK rQ rR r r� r )rB �batch_id�asset_batch_number� asset_batchr� rU �assigned_batch_numberrD rD rE �asset_batch_update� s.
�
�
��
r� zasset.delete_assetlotc C s� | j �� }z.tjj|d�}tjj|d�}|r&t�| t d�� t
d|� ��W S |� � t� | t d�� W n" tj
yE t�| t d�� Y n tyU t�| t d�� Y nw tj�� s_td�S t
d|� ��S ) r� rW r� zBatch number in-usez!/asset/asset-batch-number-search?zBatch number deletedzBatch number not foundz$You cannot delete this Batch number.r$ )rN rw r' rb rO r# r� r rA r@ r r> r? r� r r
)rB r� r| r� r� rD rD rE �asset_batch_number_delete� s&
� �
r� c C sl | j �d�}|du r d}tj�� j|d�}| j �� }t|t� �}| j �d�}|� |�}||d�}t
| d|�S )z�
View function to return search data of asset batch number.
Args:
- id: integer value representing the ID of the asset
Returns:
- message of the return
r� Nr� )�lot_number__icontainsr� )r� rr z"batch/asset_batch_number_list.html) rN rO r' rb r� r� rw r r. r� r )rB � search_queryr� r| r� r� r� rU rD rD rE �asset_batch_number_search� s
� r� c C sF | j dkr | j�d�}|dur tjj|d�}|j�� }t|�S td�S )z�
View function to return update asset count at asset category.
Args:
- id: integer value representing the ID of the asset category
Returns:
- count of asset inside the category
rK rG NrW rA )rP rK rO r% rb r� r� r
)rB r� �categoryr� rD rD rE �asset_count_update
s
r� c C s. t j�� }t jjdd�}||d�}t| d|�S )zJ
This method is used to render the dashboard of the asset module.
r� r� )r� � asset_in_usezasset/dashboard.html)r# rb r� r� r )rB r� r� rU rD rD rE �asset_dashboard s
� r� c C s: t jjddd�}t�dd� |D ��}||d�}t| d|�S )aN
Handles the asset request approval dashboard view.
This view fetches and filters asset requests that are currently in the
"Requested" status and belong to employees who are active.
The filtered asset requests are then passed to the template for rendering,
along with a JSON-encoded list of the request IDs.
� RequestedT)r� � requested_employee_id__is_activec S r� rD rW r� rD rD rE r� ; r� z,asset_dashboard_requests.<locals>.<listcomp>)r; rt z#asset/dashboard_asset_requests.html)r( rb r� rx r� r )rB r; rt rU rD rD rE �asset_dashboard_requests, s �� r� zasset.view_assetassignmentc C s$ t jjddd�}d|i}t| d|�S )Nr� T)�asset_id__asset_status�"assigned_to_employee_id__is_activer< z%asset/dashboard_allocated_assets.html)r$ rb r� r )rB r< rU rD rD rE �asset_dashboard_allocatesC s �� r� c C sx t jjdd�}t jjdd�}t jjdd�}g d�}td�t|�t|�t|�gd�g}||td�d tj� d
�d �}t|�S ) zb
This function returns the response for the available asset chart in the asset dashboard.
r� r� r% r� )r� r� r% rC ��labelr� �Oops!! No Asset found...r` �images/ui/asset.png��labels�datasetr �
emptyImageSrc)r# rb r� r@ r� r4 �
STATIC_URLr )r� �asset_available�asset_unavailabler� r� r� r, rD rD rE �asset_available_chartO s �� �r� c C sz t j�� }g }|D ]}d}t|jjdd��}|�|� q dd� |D �}td�|d�g}||td�d tj � d
�d �}t
|�S ) za
This function returns the response for the asset category chart in the asset dashboard.
r r� r� c S r� rD re )r� r� rD rD rE r� w r� z(asset_category_chart.<locals>.<listcomp>z
assets in user� r� r` r� r� ) r% rb r� r� r� r� r
r@ r4 r� r )r� r� r� rn �category_countr� r� r, rD rD rE �asset_category_chartj s"
�� �r� c C s� | j �� d }tddi�j�d�}t|�}tt|� t|| j � d��}t
� dd� |j D ��}|t� |t
� j||d�}t| d |�S )
z�
This function is responsible for loading the asset history view
Args:
Returns:
returns asset history view template
z&returned_assets=True�returned_assets�Truer� r� c S r� rD rW r� rD rD rE r� � r� z!asset_history.<locals>.<listcomp>)�asset_assignments�fr� � gp_fieldsru rt z%asset_history/asset_history_view.html)rN rw r r� r� r r- r$ r/ rO rx r� r� r r� r )rB r| r� r� rt rU rD rD rE �
asset_history� s$ �
�� r� c C s` t t|d�}d|i}| j�d�}|r*t�|�}t||�\}}||d< ||d< ||d< t| d|�S )z�
this method is used to view details of individual asset assignments
Args:
request (HTTPrequest): http request
asset_id (int): ID of the asset assignment
Returns:
html: Returns asset history single view template
rW rH rt r� r� z,asset_history/asset_history_single_view.html)r
r$ rN rO rx ry r* r )rB rY rH rU r} rt r� r� rD rD rE �asset_history_single_view� s
�r� c C s� | j �� }t| j �j�d�}t| |d�}d}| j �d�}|dkrS|durSt||| j �d�d�}d}d d
� |D �}g }|D ]}|jD ]}|� |j
� qAq<t � t
|��} nt|| j �d��}t � d d
� |jD ��} t|�}
tt|
� t| |||
||| d ��S )
z�
This method is used to filter the asset history view or to group by the datas.
Args:
request (HTTPrequest):http request
Returns:
returns asset history list or group by
r� r0 z%asset_history/asset_history_list.htmlr1 r� Nr� zasset_history/group_by.htmlc S r5 r6 rD r8 rD rD rE r� � r: z(asset_history_search.<locals>.<listcomp>c S r� rD rW r� rD rD rE r� � r� )r� r� r1 ru rt )rN rw r r� r� r0 rO r: r� r
rX rx r� r7 r/ r r- r$ r ) rB r| r� r� r1 rK rL rM rp rt r� rD rD rE �asset_history_search� sB
�
��
��r� zasset.view_assetc C s` t jj|d�}|j�� }|j�� }|r t�dd� |D ��nt�g �}||||d�}t| d|d�S )z�
This function is used to view asset tab of an employee in employee individual view.
Parameters:
request (HttpRequest): The HTTP request object.
emp_id (int): The id of the employee.
Returns: return asset-tab template
rW c S r� rD rW r� rD rD rE r�
r� z asset_tab.<locals>.<listcomp>)r� �requestsrO rG ztabs/asset-tab.htmlrv ) r2 rb rO �requested_employeer� �allocated_employeerx r� r )rB r� rG �assets_requestsr� rO rU rD rD rE � asset_tab� s
��r� c C sD t jj|d�}|j�� }t�dd� |D ��}||d�}t| d|d�S )z�
This function is used to view asset tab of an employee in employee profile view.
Parameters:
request (HttpRequest): The HTTP request object.
emp_id (int): The id of the employee.
Returns: return profile-asset-tab template
rW c S r� rD rW r� rD rD rE r� $ r� z%profile_asset_tab.<locals>.<listcomp>)r� rO ztabs/profile-asset-tab.htmlrv )r2 rb rO r� r� rx r� r )rB r� rG r� rO rU rD rD rE �profile_asset_tab s
�r� c C sF t jj|d�}|j�� }t�dd� |D ��}|||d�}t| d|d�S )a
This function is used to view asset request tab of an employee in employee individual view.
Parameters:
request (HttpRequest): The HTTP request object.
emp_id (int): The id of the employee.
Returns: return asset-request-tab template
rW c S r� rD rW r� rD rD rE r� ; r� z%asset_request_tab.<locals>.<listcomp>)r; r� rt ztabs/asset_request_tab.htmlrv )r2 rb rO r� r� rx r� r )rB r� rG r� rt rU rD rD rE �asset_request_tab, s
�r� )N)��__doc__rs rx rw r r � urllib.parser �pandasru �django.contribr �django.core.files.baser �django.core.files.storager �django.core.paginatorr �django.db.modelsr � django.httpr
r r �django.shortcutsr
r r � django.urlsr �django.utils.translationr r@ �
asset.filtersr r r r r r r r r r � asset.formsr r r r r r! r" � asset.modelsr# r$ r% r& r' r( r) � base.methodsr* r+ r, r- r. r/ r0 � base.modelsr1 �employee.modelsr2 r3 �horillar4 �horilla.decoratorsr5 r6 r7 r8 r9 �horilla.group_byr: �horilla.horilla_settingsr; �horilla.methodsr< �notifications.signalsr= rF rV rl r r� r� rZ r� r� r� r� r� r� r� r� r� r r
r r r- rR rg rW rX rZ r^ ra rp r r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� rD rD rD rE �<module> sF 0$ $ $ & '5 V ( . 9 ! $
$ Jm
"
1 -
d #
1