| 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/helpdesk/__pycache__/ |
Upload File : |
o
hͦh�� � @ s> d dl Z d dlZd dlZd dlmZ d dlmZ d dlmZ d dlm Z d dl
m Z d dl m
Z
d dlmZmZ d d lmZmZmZ d d
lmZmZ d d lmZ d d lmZ d d
l m Z d dl m Z d dl!m"Z" d dl#m$Z$ d dl%m&Z&m'Z'm(Z(m)Z)m*Z* d dl+m,Z,m-Z-m.Z. d dl/m0Z0m1Z1 d dl2m3Z3 d dl4m5Z5 d dl6m7Z7m8Z8m9Z9m:Z: d dl;m<Z<m=Z=m>Z>m?Z?m@Z@mAZAmBZBmCZCmDZDmEZE d dlFmGZG d dlHmIZImJZJmKZKmLZLmMZMmNZNmOZOmPZPmQZQ d dlRmSZSmTZTmUZU d dlVmWZWmXZXmYZYmZZZ d d l[m\Z\ d d l]m^Z^ e�_e`�ZaeXeZd �d d � ��ZbeXeWeZd!�d"d#� ���ZceXeWeZd$�d%d&� ���ZdeXeZd'�d(d)� ��ZeeXeWd*d+� ��ZfeXd,d-� �ZgeXeWeZd.�d/d0� ���ZheXeWeZd1�d2d3� ���ZieXeWd4d5� ��ZjeXeWd6d7� ��ZkeXd8d9� �ZleXeZd:�d;d<� ��ZmeXd=d>� �ZneXeWd?d@� ��ZoeXeWdAdB� ��ZpeXdCdD� �ZqeXdEdF� �ZreXe5dGePdH�dIdJ� ��ZsdKdL� ZteXeWdMdN� ��ZueXdOdP� �ZveXdQdR� �ZweXdSdT� �ZxeXdUdV� �ZyeXeWdWdX� ��ZzeXeWdYdZ� ��Z{eXd[d\� �Z|eXd]d^� �Z}eXeWd_d`� ��Z~eXeWdadb� ��ZeXdcdd� �Z�eXdedf� �Z�eXeZdg�dhdi� ��Z�eXdjdk� �Z�eXdldm� �Z�eXdndo� �Z�eXdpdq� �Z�eXeZdr�dsdt� ��Z�eXeZdG�dudv� ��Z�eXdwdx� �Z�eXeWdydz� ��Z�eXeWd{d|� ��Z�eXeZd}�d~d� ��Z�eXd�d�� �Z�eXeZd��d�d�� ��Z�eXeZd��d�d�� ��Z�eXeWeZd��d�d�� ���Z�eXe d�d�g�eZd��d�d�� ���Z�eXeZd��d�d�� ��Z�eXeZd��d�d�� ��Z�dS )�� N)�datetime)� strtobool)�
itemgetter)�parse_qs)�messages)� Paginator)�ProtectedError�Q)� HttpResponse�HttpResponseRedirect� JsonResponse)�redirect�render)�render_to_string)�reverse)�gettext)�require_http_methods)�SearchQuerySet)�TagsForm)�filtersubordinates�get_key_instances�is_reportingmanager�
paginator_qry�sortby)�
Department� JobPosition�Tags)�Employee�EmployeeWorkInformation)�get_content_type)�ticket_owner_can_enter)�FAQCategoryFilter� FAQFilter� TicketFilter�
TicketReGroup)
�AttachmentForm� CommentForm�DepartmentManagerCreateForm�FAQCategoryForm�FAQForm�TicketAssigneesForm�
TicketForm�TicketRaisedOnForm�
TicketTagForm�TicketTypeForm)�is_department_manager) �FAQ�
TICKET_STATUS�
Attachment� ClaimRequest�Comment�DepartmentManager� FAQCategory�Ticket�
TicketType)�AddAssigneeThread�RemoveAssigneeThread�TicketSendThread)�hx_request_required�login_required�manager_can_enter�permission_required)�group_by_queryset)�notifyzhelpdesk.view_faqcategoryc C s( t j�� }|t| j�d�}t| d|d�S )z�
This function is responsible for rendering the FAQ category view.
Parameters:
request (HttpRequest): The HTTP request object.
)�faq_categories�fzhelpdesk/faq/faq_view.html��context)r6 �objects�allr" �GETr )�requestrB rE � rJ � /var/www/erp/helpdesk/views.py�faq_category_viewH s
�rL zhelpdesk.add_faqcategoryc C sT t � }| jdkr t | j�}|�� r |�� t�| td�� t � }d|i}t| d|�S )z�
This function is responsible for creating the FAQ Category.
Parameters:
request (HttpRequest): The HTTP request object.
Returns:
GET : return faq category create form template
POST : return faq category view
�POSTz&The FAQ Category created successfully.�form�%helpdesk/faq/faq_category_create.html) r( �methodrM �is_valid�saver �success�_r �rI rN rE rJ rJ rK �faq_category_create[ s
� rV zhelpdesk.change_faqcategoryc C sf t jj|d�}t|d�}| jdkr(t| j|d�}|�� r(|�� t� | t
d�� ||d�}t | d|�S )��
This function is responsible for updating the FAQ.
Parameters:
request (HttpRequest): The HTTP request object.
id : id of the faq to update.
Returns:
GET : return faq create form template
POST : return faq view
��id��instancerM z&The FAQ category updated successfully.)rN � faq_categoryrO ) r6 rF �getr( rP rM rQ rR r rS rT r )rI rY r\ rN rE rJ rJ rK �faq_category_updatex s
� r^ zhelpdesk.delete_faqcategoryc C sZ zt jj|d�}|�� t�| td�� td�W S ty, t� | td�� Y td�S w )NrX z/The FAQ category has been deleted successfully.� z$You cannot delete this FAQ category.�)<script>window.location.reload()</script>)
r6 rF r] �deleter rS rT r
r �error)rI rY �faqrJ rJ rK �faq_category_delete� s
�rd c C sH | j �� }t| j �j}t|�}tt|� |t| j �||d�}t| d|�S )��
This function is responsible for search and filter the FAQ.
Parameters:
request (HttpRequest): The HTTP request object.
Returns:
GET : return faq filter form template
POST : return faq view
)rB rC �pd� filter_dictz#helpdesk/faq/faq_category_list.html)rH � urlencoder! �qsr r r6 r )rI �
previous_datarB � data_dictrE rJ rJ rK �faq_category_search� s
� rl c K s2 t jj|d�}|t| j�|t� d�}t| d|d�S )z�
This function is responsible for rendering the FAQ view.
Parameters:
request (HttpRequest): The HTTP request object.
obj_id (int): The id of the the faq category.
��category)�faqsrC �cat_id� create_tag_fz helpdesk/faq/faq_list_view.htmlrD )r0 rF �filterr" rH r r )rI �obj_id�kwargsro rE rJ rJ rK �faq_view� s
�ru zhelpdesk.add_faqc C sX t d|id�}| jdkr!t | j�}|�� r!|�� t�| td�� ||d�}t| d|�S )z�
This function is responsible for creating the FAQ.
Parameters:
request (HttpRequest): The HTTP request object.
Returns:
GET : return faq create form template
POST : return faq view
rn ��initialrM z The FAQ created successfully.)rN rp � helpdesk/faq/faq_create.html) r) rP rM rQ rR r rS rT r )rI rs rN rE rJ rJ rK �
create_faq� s
� ry zhelpdesk.change_faqc C sl t jj|d�}t|d�}| jdkr(t| j|d�}|�� r(|�� t� | t
d�� |||j j d�}t
| d|�S )rW rX rZ rM z The FAQ updated successfully.)rN rc rp rx )r0 rF r] r) rP rM rQ rR r rS rT rn rY r )rI rs rc rN rE rJ rJ rK �
faq_update� s
� rz c
C s� | j �dd�}| j �dd�}| j �� }| j �dd�}tjjdd�}t|�}tt|� |rLt� �t |d�t |d�B ��
d �}d
d � |D �}tjj|d �}n
tjjdd�}|rYt t �S |rf|�
d� |j|d
�}|rm|�
d� |t| j �|||d�} t| d| �S )re rp r_ rn �searchT�� is_active)�question__icontains)�answer__icontains�defaultc S � g | ]}|j �qS rJ )�pk)�.0�resultrJ rJ rK �
<listcomp>+ � z faq_search.<locals>.<listcomp>)�pk__inrm )ro rC rf rg �query�helpdesk/faq/faq_list.html)rH r] rh r0 rF rr r r r r �usingr
rl �popr" r )
rI rY rn rj r� ro rk � results_list�
result_pksrE rJ rJ rK �
faq_search s:
�
� r� c C sT | j �� }t| j �j}|j|d�}t|�}tt|� |t| j �||d�}t| d|�S )z�
This function is responsible for filter the FAQ.
Parameters:
request (HttpRequest): The HTTP request object.
Returns:
GET : return faq filter form template
POST : return faq view
rm )ro rC rf rg r� ) rH rh r" ri rr r r r0 r )rI rY rj ro rk rE rJ rJ rK �
faq_filterB s
� r� c C s( t | j�j}t|�� �}d|i}t|�S )Nro )r" rH ri �list�valuesr )rI ro � data_list�responserJ rJ rK �faq_suggestion^ s
�r� zhelpdesk.delete_faqc C sh z t jj|d�}|jj}|�� t�| td�� |�� t
d�W S t y3 t� | td�� Y t
d�S w )NrX z+The FAQ "{}" has been deleted successfully.r_ zYou cannot delete this FAQ.r` )
r0 rF r] rn rY ra r rS rT �formatr
r rb )rI rY rc rp rJ rJ rK �
faq_deleteh s �
�r� c
C sl t jjdd�}| j�d�r| j�d�nd}| jj}| j�� }| j�d�}| j�d�}| j�d�}|j|d�|j| jd �B }g } | j�d
�rG|} g }
|jdd�} | jj} t | d �r|| j
j }
| j
j }|
rn| j|
j
d d
�}|
|7 }
|r|| j|j
dd
�}|
|7 }
| j| dd�}|
|7 }
t|�}tt |� d}t||�t| |�t|
|�t| j�tjt|t�� �� |d� }t| ||d�S )z�
This function is responsible for rendering the Ticket view.
Parameters:
request (HttpRequest): The HTTP request object.
Tr| �viewr� �my_page�all_page�allocated_page�� employee_id��
created_by�helpdesk.view_ticket�employee_work_info�
department�� raised_on�assigning_type� job_position�
individual)� assigned_tor� z helpdesk/ticket/ticket_view.html) �
my_tickets� all_tickets�allocated_ticketsrC � gp_fields�
ticket_statusr� �todayrg rD )r7 rF rr rH r] �user� employee_getrh �has_perm�hasattrr� �
department_id�job_position_idrY r r r r# r$ �fieldsr1 r r� �dater )rI �ticketsr� �employeerj �my_page_number�all_page_number�allocated_page_numberr� r� r� � ticket_listr� r� r� �
tickets_itemsrk �templaterE rJ rJ rK � ticket_viewx sZ
�
��
� r� c
C s t � }| j�d�r| j�d�}t d|id�}| jdkr�| j�� }| j�d�}tjj|d�}tjj |j
d�� � }dd� |D �}|rJt |d j
�|d
< nt�| d � t| d d
|i�S t || jd�}|�� r�|jdd�}t |d j
�|_|�� |j�d�} | D ] }
t|
|d�} | �� q}|D ]} |j�| � q�|j�� }
dd� |
D �}|�|j j � t | |dd�}|� � t� | t!d�� t"|�#� d�r�|�#� j$�� r�|�#� j$�� �%� j&}|�|j � t'j(| j)j*|ddddd d t+d d |j
id �d!� t,d"�S |t-� d#�}t| d |�S )$z�
This function is responsible for creating the Ticket.
Parameters:
request (HttpRequest): The HTTP request object.
Returns:
GET : return Ticket create form template
POST : return Ticket view
�statusrv rM � ticket_typerX )� tags__titlec S r� rJ r� )r� �wirJ rJ rK r� � r� z!ticket_create.<locals>.<listcomp>r r� z;No employee found with a matching tag for this ticket type.� helpdesk/ticket/ticket_form.htmlrN )�data�filesF��commit�
attachment��file�ticketc S r� rJ ��employee_user_id�r� r� rJ rJ rK r� � r� �create��typez The Ticket created successfully.� dept_managerz&You have been assigned to a new Ticketu0 لقد تم تعيينك لتذكرة جديدةz'Ihnen wurde ein neues Ticket zugewiesenz!Se te ha asignado un nuevo ticketu( Un nouveau ticket vous a été attribué�infinite�
ticket-detail� ticket_id�rt �� recipient�verb�verb_ar�verb_de�verb_es�verb_fr�iconr
r` )rN � t_type_form).r+ rH r] rP rM �copyr8 rF r rr �title�distinct�strrY r rb r �FILESrQ rR r� r� �getlistr2 r� �addrG �appendr� r� r; �startrS rT r� �get_raised_on_objectr� �first�managerrA �sendr� r� r r
r. )rI rN r� �mutable�ticket_type_id�ticket_type_obj� work_info_qs�matched_employeer� � attachmentsr� �attachment_instance�emp� employees� assignees� mail_threadr� rE rJ rJ rK �
ticket_create� sn ��
� � � r� c C s t jj|d�}| j�d�s"t| |�s"| jj|jks"| jj|j� � v rkt
|d�}| j dkr^t
| j | j
|d�}|�� r^|�� }|j�d�}|D ] }t||d�}|�� qEt�| td�� td�S ||t� d �}t| d
|�S t�| td �� | j�d d
�}d| jv r�t| d�S td|� d��S )a
This function is responsible for updating the Ticket.
Parameters:
request (HttpRequest): The HTTP request object.
ticket_id : id of the ticket to update.
Returns:
GET : return Ticket update form template
POST : return Ticket view
rX �helpdesk.change_ticketrZ rM r� r� � The Ticket updated successfully.r` )rN r� r� r� �You don't have permission.� HTTP_REFERER�/�HTTP_HX_REQUEST�decorator_404.html� <script>window.location.href = "�
"</script>)r7 rF r] r� r� r/ r� r� r� rG r+ rP rM r� rQ rR r� r� r2 r rS rT r
r. r �info�META) rI r� r� rN r� r� r� rE � previous_urlrJ rJ rK �
ticket_update s<
��
�
�r c C s� t jj|d�}| j�d�s|j| jjkst| |�r?|j |_|� � |jr.t
� | t d�� nt
� | t d�� t
| j�dd��S t
�| t d�� | j�dd�}d| jv rXt| d �S td
|� d ��S ) z�
This function is responsible for archiving the Ticket.
Parameters:
request (HttpRequest): The HTTP request object.
ticket_id : id of the ticket to update.
Returns:
return Ticket view
rX r� z$The Ticket un-archived successfully.z!The Ticket archived successfully.r� r� r� r� r� r r )r7 rF r] r� r� r� r� r/ r} rR r rS rT r r r r r
)rI r� r� r rJ rJ rK �ticket_archive= s&
��
�r c
C sr t jj|d�}|�� }| j�d�}| jj}|j|kr�||jks,||j �
� v s,| j� d�r�||_|� � t
�� }|�d�}dtd�|�� ||�� |d�}|j �
� }dd � |D �} | �|jj� t|�� d
�r||�� j�
� r||�� j�
� �� j}
| �|
j� tj| jj| d |j� d �d
ddddtdd|j id�d� t | |dd�} | � � ndtd�d�}|jdkr�t
� � |_ t!|�S ) z�
This function is responsible for changing the Ticket status.
Parameters:
request (HttpRequest): The HTTP request object.
ticket_id (int): The ID of the Ticket
Returns:
return Ticket view
rX r� r� z%b. %d, %Y, %I:%M %prS z'The Ticket status updated successfully.)r� �messager� �
pre_status�
cur_status�timec S r� rJ r� r� rJ rJ rK r� � r� z(change_ticket_status.<locals>.<listcomp>r� z-The status of the ticket has been changed to �.u( تم تغيير حالة التذكرة.u' Der Status des Tickets wurde geändert.z&El estado del ticket ha sido cambiado.u% Le statut du ticket a été modifié.r� r� r� r� r� �
status_changer� �dangerz You Don't have the permission.�r� r �resolved)"r7 rF r] �get_status_displayrM r� r� r� r� r� rG r� rR r �now�strftimerT �
get_full_namer� r� r� r� r� r� r� rA r� r rY r; r� r� �
resolved_dater ) rI r� r� r r� r� r
r� r� r� r� r� rJ rJ rK �change_ticket_statusk sf
�
�
� � �
�
r zhelpdesk.delete_ticket)�perm�modelc C s ztt jj|d�}|jdkrkt| |dd�}|�� |j�� }dd� |D �}|�|j j
� t |� � d�rI|� � j
�� rI|� � j
�� �� j}|�|j
� tj| jj|dd d
d d d
td�d� |�� t�| td��|�� nt�| td�� W n ty� t�| td�� Y nw t | j �dd��S )z�
This function is responsible for deleting the Ticket.
Parameters:
request (HttpRequest): The HTTP request object.
ticket_id (int): The ID of the Ticket
Returns:
return Ticket view
rX �newra r� c S r� rJ r� r� rJ rJ rK r� � r� z!ticket_delete.<locals>.<listcomp>r� � The ticket has been deleted.� تم حذف التذكرة.� Das Ticket wurde gelöscht� El billete ha sido eliminado.� Le ticket a été supprimé.r� � ticket-viewr� �.The Ticket "{}" has been deleted successfully.z%The ticket is not in the "New" status� You cannot delete this Ticket.r� r� ) r7 rF r] r� r; r� r� rG r� r� r� r� r� r� r� r� rA r� r� r� r ra r rS rT r� rb r r r )rI r� r� r� r� r� r� rJ rJ rK �
ticket_delete� sN
�
� � �� �r! c C sd | j j}|jj}|jj}tjjd|jdd�}tjjd|jdd�}tjjd|jdd�}||B |B }|S )NTr� )r} r� r� r� r� ) r� r� r� r� r� r7 rF rr rY )rI r� r� r� �tickets_items1�tickets_items2�tickets_items3r� rJ rJ rK �get_allocated_tickets� s ��� r% c
C s� | j �� }t| j �j}| j �d�}| j �d�}| j �d�}tj�� }tj�� }|j| j j
d�|j| j d�B }|jdd�} t | |d�} | j � d �rJ|} tj�� }
| j j
} | j
j} | j
j}
|jdd�}t| d
�r�| j
j} | j
j}
| rx|j| jd d �}|
r�|j|
jd
d �}|j| jdd �}d}| j �d�dkr�d}t|�t|� t|� }
| j �d�r�t| | d�} t| |d�}||B |B }
t| |
d�}
| j �d�}|dk�r|du�rt||| j �d�d�}t| || j �d�d�} t||| j �d�d�}t||| j �d�d�}t||| j �d�d�}d}t|�t|� t|� }
nt||�}t| |�} t|
|�}
t|�}tt|� || |
t| j �|t||t�� �� d� }t | ||�S )z�
This function is responsible for search and filter the Ticket.
Parameters:
request (HttpRequest): The HTTP request object.
Returns:
GET : return ticket filter form template
POST : return ticket view
r� r� r� r� r� Tr| zhelpdesk.add_ticketsr� r� r� r� r� r� z helpdesk/ticket/ticket_list.htmlr� �cardz helpdesk/ticket/ticket_card.htmlr �fieldr_ Nz!helpdesk/ticket/ticket_group.html) r� r� r� rC rf r� rg r' r� ) rH rh r# ri r] r7 rF �nonerr r� r� r r� r� r� r� r� rY r� r r@ r r r r1 r r� r� r )rI rj r� r� r� r� r" r# r� r� r� r� r� r� r� r$ r� r' rk rE rJ rJ rK �
ticket_filter� s�
�
��� ������
� r) c K s� t jj|d�}| j�d�s+|j�� | jjks+t| |�s+| jj|jks+| jj|j �
� v r�t � � �
� }t� }t� }|j�
� }g }|j�
� } |�� }
| D ] } |�d| | j
d�� qI|
D ]} |�d| | d d jd�� qXt|td �d
�}
d }|j| }d |j� d
�}|jdk r�t|j�� d�}d}n |jdkr�d}d}d}|jdkr�d}n
|jdkr�d}nd}||||tt |d�|
t � |||d� }t | d|d�S t � | t!d �� | j"�d d �}d | j"v r�t | d �S t#d!|� d"��S )#NrX r� �comment)r� r* r� �history�pairr )r� r+ r� r� )�keyrS zDue in z daysz
days overduer
z Due Today�warningr_ �low�1�medium�2�3rZ ) r� �c_form�f_formr� r� �tag_form�sorted_activity_listrq �color� remaining�ratingz"helpdesk/ticket/ticket_detail.htmlrD r� r� r� r� r� r r )$r7 rF r] r� r� r� �get_reporting_managerr� r/ r� rG r r r� r& r% �ticket_attachmentr* �trackingr� � history_date�sortedr �deadline�days�abs�priorityr1 r- r r r r rT r r
)rI r� rt r� r� r4 r5 r� �
activity_list�comments� trackingsr* r+ r7 r8 �remaining_daysr9 r: rE r rJ rJ rK �
ticket_detailh s|
��
� ��
�
�rH c C s( t jj|d��� }d|i}t| d|d�S )NrX r� z+helpdesk/ticket/ticket_individual_view.htmlrD )r7 rF rr r� r )rI r� r� rE rJ rJ rK �ticket_individual_view� s ��rI c C s� t jj|d��� }| j�d�s| j�d�st| |�r)|j�� }d|i}t | d|�S t
� | t d�� | j
�dd�}d | j
v rBt | d
�S td |� d ��S )
NrX z helpdesk.change_claimrequestr� �claim_requests�*helpdesk/ticket/ticket_claim_requests.htmlr� r� r� r� r� r r )r7 rF rr r� r� r� r/ �claimrequest_setrG r r r rT r r] r
)rI r� r� rJ rE r rJ rJ rK �view_ticket_claim_request� s$
�
��
�
�rM c C s� | j }tjj|d d�}| j�d�s | jj|jks t| |�rE|� d�}|j
� � |D ]}t jj|d�}|j
�
|� q*dtd�d�}t|�S t�| td�� | j�d d
�}d | jv r^t| d �S td
|� d��S )z-
method to update the tags of ticket
�ticketIdrX r� zselectedValues[]rS z$The Ticket tag updated successfully.r r� r� r� r� r� r r )rH r7 rF r] r� r� r� r� r/ r� �tags�clearr r� rT r r r r r r
)rI r� r� �tagids�tagId�tagr� r rJ rJ rK �ticket_update_tag� s.
��
�
�rT c C s� t jj|d�}| j�d�s| jj|jkrDt|d�}| jdkr;t| j |d�}|�
� r;|� � t �
| td�� tt|d�S t| d||d��S t �| td �� | j�d
d �}d | jv r]t| d
�S td|� d��S )NrX r� rZ rM z%Responsibility updated for the Ticket�r� z+helpdesk/ticket/forms/change_raised_on.html�rN r� r� r� r� r� r� r r )r7 rF r] r� r� r� r� r, rP rM rQ rR r rS rT r
rH r r r r
)rI r� r� rN r rJ rJ rK �ticket_change_raised_on� s.
�
�
�rW c C sV t jj|d�}| j�d�st| |�r�|jjddd�}t|d�}| j dkr�t| j
|d�}|� � r�|j dd � |j
d
jddd�}t|�t|� }t|�t|� }tjj|d �}tjj|d �} |� � t| ||�}
|
�� t| || �}
|
�� t�| td �� td
�S t| d||d��S t�| td�� | j�dd�} d| jv r�t| d�S td| � d��S )NrX r� rY T)�flatrZ rM Fr� r� )�id__inz Assinees updated for the Ticketr` z*helpdesk/ticket/forms/change_assinees.htmlrV r� r� r� r� r� r r )r7 rF r] r� r� r/ r� � values_listr* rP rM rQ rR � cleaned_data�setr rr r9 r� r: r rS rT r
r r r ) rI r� r� �prev_assignee_idsrN �new_assignee_ids�added_assignee_ids�removed_assignee_ids�added_assignees�removed_assigneesr� r rJ rJ rK �ticket_change_assignees sX �
����
�rc c C sV | j dkr)t| j�}|�� r |�� }d|j|jd�}t|�S |j� � }td|i�S dS )z^
This is an ajax method to return json response to create tag in the change tag form.
rM �no_error)�errors�tag_idr� re N)
rP r rM rQ rR rY r� r re �as_json�rI rN r[ r� re rJ rJ rK �
create_tagY s
�
�ri c C sv | j }|d }|d }z tjj|d�}tjj|d�}|j�|� td�}d}W n t� | td��}Y t
||d��S )z>
This is an ajax method to remove tag from a ticket.
r� rf rX rS �Failed)r r� ) rH r7 rF r] r rO �removerT r rb r )rI r� r� rf r� rS r r� rJ rJ rK �
remove_tago s rl c C s� t jj|d��� }d|i}|jrT|jj}tj�|�d dd� �� }t |�}zt
|d�� }|� � }W d � n1 s;w Y W n d}Y ||d< ||d< ||d< t | d |�S )
z�
This function used to view the uploaded document in the modal.
Parameters:
request (HttpRequest): The HTTP request object.
id (int): The id of the document.
Returns: return view_file template
rX �document� N�rb� file_content�file_extension� content_typez$helpdesk/ticket/ticket_document.html)
r2 rF rr r� r� �path�os�splitext�lowerr �open�readr ) rI �doc_id� document_objrE � file_pathrq rr r� rp rJ rJ rK �view_ticket_document� s,
���
�� r| c C s* t jj|d��� t�| td�� td�S )z�
This function used to delete the uploaded document in the modal.
Parameters:
request (HttpRequest): The HTTP request object.
id (int): The id of the document.
rX zDocument has been deleted.r` )r2 rF r] ra r rS rT r
)rI ry rJ rJ rK �delete_ticket_document� s r} c C s� | j dkrXtjj|d�}t| j�}|�� rZ|jdd�}| jj |_
||_ |�� | j rJt
| j �}|�� rJ| j �d�}|D ]}t
|||d��}|�� q;t�| td�� tt|d�S d S d S )
z= "
This method is used to create comment to a ticket
rM rX Fr� r� )r� r* r� z A new comment has been created.rU N)rP r7 rF r] r& rM rQ rR r� r� r� r� r� r% r� r rS rT r
rH ) rI r� r� r4 r* r5 r� r� �a_formrJ rJ rK �comment_create� s*
�
�r c C sr | j �d�}| j �d�}t|�dkr)tjj|d�}||_|�� t�| t d�� nt�
| t d�� ddi}t |�S ) N�
comment_id� new_commentrn rX z!The comment updated successfully.z-The comment needs to be atleast 2 charactors.re rd ) rM r] �lenr4 rF r* rR r rS rT rb r )rI r� r� r* r� rJ rJ rK � comment_edit� s �r� zhelpdesk.delete_commentc C sH t jj|d��� }|j}|�� t�| td�� |�� t
| j � dd��S )NrX z+{}'s comment has been deleted successfully.r� r� )
r4 rF rr r� r� ra r rS rT r� r r r] )rI r� r* r� rJ rJ rK �comment_delete� s �r� c C s� | j }|d }|dkrtj�dd�}dd� |D �}n&|dkr-tj�dd�}dd� |D �}n|dkr@tj�dd d
�}d d� |D �}d t|�i}t|�S )
zD
This is an ajax method to return list for raised on field.
r� r� rY c S � g | ] }|d |d d��qS )rY r� �rY �namerJ )r� �deptrJ rJ rK r� � � �z!get_raised_on.<locals>.<listcomp>r� c S r� )rY r� r� rJ )r� �jobrJ rJ rK r� r� r� �employee_first_name�employee_last_namec S s, g | ]}|d |d � d|d � �d��qS )rY r� � r� r� rJ r� rJ rJ rK r� s ���r� )rH r rF r� r r r� r )rI r� r� � departmentsr� � jobpositionsr� r� rJ rJ rK �
get_raised_on� s* ���� r� c C sL t jj|d�}tjj| jj|d��� s t| jj|d��� t | j
�dd��S )zM
This is a function to create a claim request for requested employee
rX )r� r� r� r� ) r7 rF r] r3 rr r� r� �existsrR r r )rI rY r� rJ rJ rK � claim_ticket s ��r� c C s t jj|d��� }|stddd�S t| j�dd��}|j}|j }d}|�r4t
d�}d }||j � � v�r3|j �
|� z.tj| jj|jd
|� d �d |� d �d
|� d�d|� d �d|� d�dtdd|jid�d� W n ty~ } z t�|� W Y d}~nd}~ww |j |jjks�|jj|j fD ]R} z9tj| jj| j|� d|� d �d|� d|� d �|� d|� d�|� d |� d �|� d |� d �dtdd|jid�d� W q� ty� } z t�|� W Y d}~q�d}~ww z:tj| jj|j j|� d|� d �d|� d|� d �|� d|� d�|� d |� d �|� d |� d �dtdd|jid�d� W nP t�y2 } z t�|� W Y d}~n=d}~ww n7t
d �}d }||j � � v �rk|j �|� tj| jj|jd |� �d |� d �d!|� d"�d#|� d �d$|� d%�dd&� |�� ||_| |_ |�� t d'|j � � |d(��}
t � | |� t|
�S ))zX
Function for approve claim request and send notifications to the responsibles.
rX zInvalid claim requesti� )r� �approve�FalseFz$Claim request approved successfully.Tz'You have been assigned to a new Ticket-r u1 لقد تم تعيينك لتذكرة جديدة z Ihnen wurde ein neues Ticket z zugewiesen.z"Se te ha asignado un nuevo ticket zUn nouveau ticket u vous a été attribué.r� r� r� r� r� Nz assigned to your ticket - u تم تعيين u إلى تذكرتك - z wurde Ihrem Ticket z ha sido asignado a tu ticket - u$ a été assigné à votre ticket - z$Claim request rejected successfully.z*Your claim request is rejected for Ticket-u7 تم رفض طلبك للمطالبة بالتذكرة u" Ihre Anspruchsanfrage für Ticket-z wurde abgelehnt.u> Tu solicitud de reclamación ha sido rechazada para el ticket u- Votre demande de réclamation pour le ticket u a été rejetée.)r� r� r� r� r� r� r� rK )rJ �refresh)!r3 rF rr r� r
r rH r] r� r� rT r� rG r� rA r� r� r� r� r rY � Exception�loggerrb r� rk rR � is_approved� is_rejectedr rL r rS ) rI �req_id�
claim_requestr� r� r� r� r �er� �htmlrJ rJ rK �approve_claim_request s� �
� ��
�
�
��
� ���3
�
� r� c C s� | j �d�}| j �d�}|rt�|�ni }| j �d�}| jj}t|tjj dd�d�}|dkrm|dkr<t|tj�
� d�}n|dkrLt|tjj |d �d�}n
t | �}t||d�}|j }d
d � |D �} |�
� }
| |
d �} t| �S d
S )zK
This method is used to return all the ids of the filtered tickets
�pagerr � tableNameTr| )�querysetrG �myr� c S s g | ]}t |j��qS rJ )r� rY )r� r� rJ rJ rK r� � s z)tickets_select_filter.<locals>.<listcomp>)�
ticket_ids� total_countN)rH r] �json�loadsr� r� r# r7 rF rr rG r% ri �countr ) rI � page_number�filtered�filters�tabler� �tickets_filterr� �filtered_ticketsr� r� rE rJ rJ rK �tickets_select_filter� s. ��
�r� r� c C s� | j d }t�|�}d}| j�d�dkrd}|D ]}tjj|d�}||_|�� qt �
| t d�� | j �dd �}d
|� d �}t
|�S ) zH
This is a ajax method used to archive bulk of Ticket instances
�idsFr} �TrueTrX r� r� r� r r )rM r� r� rH r] r7 rF r} rR r rS rT r r
)rI r� r} r� r� r �scriptrJ rJ rK �tickets_bulk_archive� s
r� c
C s. | j d }t�|�}|D ]y}zftjj|d�}t| |dd�}|�� |j� � }dd� |D �}|�
|j j � t
|�� d�rR|�� j� � rR|�� j� � �� j}|�
|j � tj| jj|dd d
d d d
td�d� |�� t�| td��|�� W q t y� t� | td�� Y q w | j �dd�}d|� d�} t | �S )zG
This is a ajax method used to delete bulk of Ticket instances
r� rX ra r� c S r� rJ r� r� rJ rJ rK r� � r� z'tickets_bulk_delete.<locals>.<listcomp>r� r r r r r r� r r� r r r� r� r r ) rM r� r� r7 rF r] r; r� r� rG r� r� r� r� r� r� r� r� rA r� r� r� r ra r rS rT r� r rb r r
)
rI r� r� r� r� r� r� r� r r� rJ rJ rK �tickets_bulk_delete� sR
�
� � � � r� c C sJ t � }| jdkrt | j| j�}|�� r|�� td�S d|i}t| d|�S )NrM r` rN z*helpdesk/faq/department_managers_form.html)r' rP rM r� rQ rR r
r rU rJ rJ rK �add_department_manager� s
� r� c C sZ t � }| jdkr#t | j| j�}|�� r#|�� t�| td�� t d�S d|i}t
| d|�S )NrM z,The department manager created successfully.r` rN �1department_managers/department_managers_form.html) r' rP rM r� rQ rR r rS rT r
r rU rJ rJ rK �create_department_manager� s
� r� c C sn t jj|d�}t|d�}| jdkr,t| j|d�}|�� r,|�� t� | t
d�� t d�S ||d�}t | d|�S )NrX rZ rM z,The department manager updated successfully.r` )rN �dep_idr� )
r5 rF r] r' rP rM rQ rR r rS rT r
r )rI r� �department_managerrN rE rJ rJ rK �update_department_manager
s
� r� z!helpdesk.delete_departmentmanagerc C s8 t jj|d�}|�� t�| td�� t| j�dd��S )NrX z4The department manager has been deleted successfullyr� r� ) r5 rF r] ra r rS rT r r )rI r� r� rJ rJ rK �delete_department_manager s r� c C s� t jj|d�}| j�d�s+|j�� | jjks+t| |�s+| jj|jks+| jj|j �
� v rY| j �d�}|dkr9d|_ n |dkrAd|_ nd|_ |�
� t�| td �� t| j�d
d ��S t�| td �� | j�d
d �}d
| jv rrt| d�S td|� d��S )zQ
This function is used to update the priority
from the detailed view
rX r� r: r0 r/ r2 r1 �highz Priority updated successfully.r� r� r� r� r� r r )r7 rF r] r� r� r� r; r� r/ r� rG rM rC rR r rS rT r r r r r
)rI r� r� r: r rJ rJ rK �update_priority) s0
��
�r� zhelpdesk.view_tickettypec C s t j�� }t| dd|i�S )z1
This method is used to show Ticket type
z!base/ticket_type/ticket_type.html� ticket_types)r8 rF rG r )rI r� rJ rJ rK �ticket_type_viewO s
�r� zhelpdesk.create_tickettypec C s� t � }| jdkrIt | j�}| j�d�r2|�� r'|�� }d|j|jd�}t |�S |j
� � }t d|i�S |�� rI|�� t � }t �
| td�� td�S t| dd |i�S )
�E
This method renders form and template to create Ticket type
rM �ajaxrd )re r� r� re z*Ticket type has been created successfully!r` �&base/ticket_type/ticket_type_form.htmlrN )r. rP rM rH r] rQ rR rY r� r re rg r rS rT r
r rh rJ rJ rK �ticket_type_create[ s0
�
��r� zhelpdesk.update_tickettypec C sp t jj|d�}t|d�}| jdkr/t| j|d�}|�� r/|�� t� }t� | t
d�� t d�S t | d||d��S )r� rX rZ rM z*Ticket type has been updated successfully!r` r� )rN � t_type_id)
r8 rF r] r. rP rM rQ rR r rS rT r
r )rI r� r� rN rJ rJ rK �ticket_type_update s
�r� rM �DELETEzhelpdesk.delete_tickettypec C sB t �|�}|r|�� t�| td�� t� S t�| td�� t� S )Nz*Ticket type has been deleted successfully!zTicket type not found)r8 �findra r rS rT rb r
)rI r� r� rJ rJ rK �ticket_type_delete� s
�r� z helpdesk.view_departmentmanagerc C s t j�� }d|i}t| d|�S )N�department_managersz,department_managers/department_managers.html)r5 rF rG r )rI r� rE rJ rJ rK �view_department_managers� s
� r� z!helpdesk.change_departmentmanagerc C sh | j �d�rtjj| j �d�d��� nd}|r!|j�� �dd�}nd}t |�}d|i}t
d|�}t |�S )z5
Method to return employee in the department
r� rX N�employee_id__id� employee_id__employee_first_namer� z employee/employees_select.html) rH r] r rF rr r� �employeeworkinformation_setrG rZ r� r r
)rI r� �employees_querysetr� rE �
employee_htmlrJ rJ rK �get_department_employees� s
��
�
r� )�r� �loggingrt r �distutils.utilr �operatorr � urllib.parser �django.contribr �django.core.paginatorr �django.db.modelsr r � django.httpr
r r �django.shortcutsr
r �django.template.loaderr � django.urlsr �django.utils.translationr rT � django.views.decorators.httpr �haystack.queryr �
base.formsr � base.methodsr r r r r � base.modelsr r r �employee.modelsr r �employee.viewsr �helpdesk.decoratorsr �helpdesk.filterr! r" r# r$ �helpdesk.formsr% r& r' r( r) r* r+ r, r- r. �helpdesk.methodsr/ �helpdesk.modelsr0 r1 r2 r3 r4 r5 r6 r7 r8 �helpdesk.threadingr9 r: r; �horilla.decoratorsr< r= r> r? �horilla.group_byr@ �notifications.signalsrA � getLogger�__name__r� rL rV r^ rd rl ru ry rz r� r� r� r� r� r� r r r r! r% r) rH rI rM rT rW rc ri rl r| r} r r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� rJ rJ rJ rK �<module> sN 0 ,
0
= P 2
-
F
4 h
M
" 8
!
!
b
# /
%
!