File: //home/arjun/projects/buyercall/buyercall/blueprints/admin/__pycache__/views.cpython-310.pyc
o
�we�� � @ s� d dl Zd dlZd dlmZmZmZmZmZm Z m
Z
m Z d dl m
Z
mZ d dlmZ d dlmZ d dlmZ d dlmZ d dlmZ d d lmZ d d
l m Z d d l m Z d d l m!Z!m"Z" d d
l#m$Z$ d dl%m&Z& d dl'm(Z( d dl)m*Z* d dl+m,Z, d dl%m-Z-m.Z.m/Z/m0Z0 d dl1m2Z2m3Z3m4Z4m5Z5m6Z6m7Z7m8Z8m9Z9m:Z:m;Z;m<Z<m=Z= d dl>m?Z?m@Z@ d dlAmBZB d dlAmCZC d dlDmEZEmFZF edeGddd�ZHeHjIe
e dd d d �d d � ���ZIeH�Jd!�d"d#� �ZKeHjJd$d%d&id'�eH�Jd(�e d�d)d*� ���ZLeH�Jd+�eCjMe
e d�d,d-� ����ZNeHjJd.d/d0gd1�e dd d �d2d3� ��ZOeHjJd4d5gd1�e
e d�d6d7� ���ZPeHjJd8d0gd1�e d�d9d:� ��ZQeHjJd;d%d&id'�d<d=� �ZReH�Jd>�d?d@� �ZSeHjJdAd/d0gd1�dBdC� �ZTeHjJdDd0gd1�dEdF� �ZUeHjJdGd%d&id'�e d �dHdI� ��ZVeH�JdJ�e d �dKdL� ��ZWeHjJdMd/d0gd1�e(e d �dNdO� ���ZXeHjJdPd0d5gd1�e(e d �dQdR� ���ZYeH�JdS�e dd �dTdU� ��ZZeH�JdV�e dd �dWdX� ��Z[eHjJdYd0d/gd1�e dd �dZd[� ��Z\eHjJd\d0d/gd1�e dd �d]d^� ��Z]eHjJd_d0d/gd1�e dd �d`da� ��Z^eHjJdbd/d0gd1�eCjMe dd �dcdd� ���Z_eHjJded0d/gd1�e dd �dfdg� ��Z`eHjJdhd0d/gd1�e dd �didj� ��Zadkdl� ZbdS )m� N)� Blueprint� current_app�redirect�request�flash�url_for�jsonify�render_template)�login_required� current_user)�gettext)�and_)�text)�InvalidRequestError)� AESCipher)� Dashboard)�
role_required)�Agent)�User�UserExternalApiAutoPostTie)�Issue)� Partnership)�handle_stripe_exceptions)�Coupon)� Subscription)�PartnershipAccountCreditTie�PartnershipAccount�0ExternalApiServiceProvidersPartnershipAccountTie�ExternalApiServiceProviders) �
SearchForm�BulkDeleteForm�UserForm�UserCancelSubscriptionForm� IssueForm�IssueContactForm�
CouponForm�SevenHundredCreditForm�SevenHundredPrequalifyForm�FinservPrequalifyForm�AMSEvolutionForm�
NeoVerifyForm)�Report�
ReportUserTie)�db)�csrf)�
DataTables�ColumnDT�admin� templatesz/admin)�template_folder�
url_prefix�partner�sysadmin�
limitsysadminc C s dS )z/ We are protecting all of our admin endpoints. N� r8 r8 r8 �B/home/arjun/projects/buyercall/buyercall/blueprints/admin/views.py�before_request+ s r: � c C s� t d�} tj}tj}|rtj}tjdkrtj|k} tjdkr,ttj|ktj� g d���} tjdv r6t
� t�nt � dd�}tjdkrEt
�
� nd}t
�ttj| �}t
�t�}td||||d �S )
N�1 = 1r5 r1 )r6 r7 r5 r )�query�totalr6 zadmin/page/dashboard.jinja2)�group_and_count_plans�group_and_count_coupons�group_and_count_users�group_and_count_issues)r r �partnership_account_id�is_viewing_partnership�'get_user_viewing_partnership_account_id�roler �partnership_idr
�notin_r r? �listr@ �group_and_countrB r )�
filter_exprC �!partnership_account_group_viewingr? r@ rA rB r8 r8 r9 � dashboard4 s0
�
�
�
�rM z/users�page� )�defaultsz/users/page/<int:page>c C s� t � }t� }tj}tj}|rtj}t�tj �
dd�tj �
dd��}d� |d |d �}tj �
tj|ktjd k��
tj�d���
t�tj �
d d
����tj�� t|���| d d �}td
|||d�S )N�sort�name� direction�ascz{0} {1}r rO F�qr; � Tzadmin/user/index.jinja2)�form� bulk_form�users)r r r rC rD rE r �sort_byr �args�get�formatr= �filterrG �is_deactivated�is_�search�order_byrF �descr �paginater )rN � search_formrX rC rL rZ � order_values�paginated_usersr8 r8 r9 rY U s* �
��rY z
/user-datac C s� t j} t j}|r t j} ttj�ttj�ttj�ttj �ttj
�ttj �ttj �g}|r8t
tj| kt jdk�}nt jtjkt
tj| kt jdk�B }tj�� �t��|��tj�d��}ttj||�}t|�� �S )Nr1 F)r rC rD rE r0 r �id� firstname�lastname�email� phonenumber�last_sign_in_on�
sign_in_countr
rF r- �sessionr= � select_fromr^ r_ r` r/ r r[ r �
output_result)rC rL �columns� filter_byr= � row_tabler8 r8 r9 �datat s* �
�$ ru z/users/edit/<int:id>�GET�POST)�methodsc C s� t j�| �}t|d�}g |j_dd� tj�� D �}|D ]
}|dkr(|jj�|� qt j
}t j dkr7ddg|j _dd l m
} d
}|�|d �}|r^d }t�| |d �} | rZ| jrZd |j_nd
|j_d
}
|�|d
�} | rd }
t�| |d
�} | r{| jr{d |j_nd
|j_d
}
|�|d�}|r�d }
t�| |d�}|r�|jr�d |j_nd
|j_|�� �rNt �|tj�d�tj�d��r�ttd�d� t t d��S |� |� |j dkr�d |_ |� � tj�d�}d
}|r�|dkr�d }t�!| |d |� tj�d�}d
}|r�|dkr�d }t�!| |d
|� tj�d�}d
}|�r|dk�rd }t�!| |d|� t"� |_#|jjD ]} t$� }| |_%|j&|_'|j
|_(t)j*�+|� �q$t)j*�,� ttd�d� t t d��S |j�-dd� |j#D �� t.d ||||
|
d �S ) N��objc S s g | ]}|j |jf�qS r8 )rh rR )�.0�reportr8 r8 r9 �
<listcomp>� s z users_edit.<locals>.<listcomp>)� z Partner Channel Account Reportr1 )r1 �Admin)�agentr � )r FzAMS 2000T�
AMS Evolution�
NEO VerifyrF �activez+You are the last admin, you cannot do that.�danger� admin.usersr; �ams_2000�y�
ams_evolution�
neo_verifyz!User has been saved successfully.�successc S s g | ]}|j j�qS r8 )r| rh )r{ �linkr8 r8 r9 r} s zadmin/user/edit.jinja2)rW �user�ams_2000_provider_exists�ams_evo_provider_exists�neo_verify_provider_exists)/r r= r\ r! � reports_list�choicesr+ �all�appendr rC rF �partnership.modelsr �exists_for_service_providerr �!get_service_provider_access_state�
is_allowedr� ru r� r� �validate_on_submit�
is_last_adminr rW r �_r r � populate_obj�username�save�!set_service_provider_access_staterI �reportsr, � report_idrh �user_id�partnership_accounts_idr- ro �add�commit� process_datar )rh r� rW r� �rrC r �ams_2000_account_tie�!partnership_account_ams_2000_ties�ams_2000_exists�ams_evo_account_tie� partnership_account_ams_evo_ties� ams_evolution_user_tie_exists�neo_verify_account_tie�#partnership_account_neo_verify_ties�neo_verify_user_tie_existsr� �ams_2000_resultr� �ams_evolution_resultr� �neo_verify_resultr� r8 r8 r9 �
users_edit� s�
�
��
��
��
��
�r� z/users/delete/<int:id>�DELETEc C s t �| �}t|d�S )N)r� )r �deactivate_userr )rh �resultr8 r8 r9 � user_delete s
r� z/users/cancel_subscriptionc C sf t � } | �� r-tj�tj�d��}|r&|j}|�|�r%t t
d|j d�d� nt t
d�d� t t
d��S )Nrh z-Subscription has been cancelled for %(user)s.)r� r� z4No subscription was cancelled, something went wrong.r� r� )r" r� r r= r\ r rW � subscription�cancelr r� rR r r )rW r� r� r8 r8 r9 �users_cancel_subscription s
���� r� z/issuesc C � t d�S )Nzadmin/issue/index.jinja2�r �rN r8 r8 r9 �issues* s r� z /issues-datac C sX t j} t j}|r t j} ttj�ttj�tt j�ttj
�ttj �ttj �ttj
�g}| tjk| tjk@ }t jr>|r>| tjk}nLt jdkrut jru|suddlm} tj�|j��|jt jk��� }|durot|�dkrotj�|�}n| tjk}nt jdkr�t jtjk}n t jdv r�td�}t � d� |�� tj�� � ttt ��|�}t t!j"||�}t#|�$� �S ) �Return server side data.r1 r )�PartnershipAccountGroupTieNr5 )r6 r7 r< z every: {})%r rC rD rE r0 r rh r rR r �status�label�
created_onrk rG �is_admin_user_with_groupsrF �'buyercall.blueprints.partnership.modelsr� r- ro r= r^ � partnership_account_group_idr� �len�in_r �log�errorr] rp r/ r r[ r rq )rC rL rr rs r� �groupsr= rt r8 r8 r9 � issues_data0 sP � �
� �
��
r� z/issues/edit/<int:id>c C s� t j�| �}tjdkr|r|jdkrt �|�}t|d�}td|j |j
d�}d}d� |j �}td||d �}t
|j||d
�}|�� rW|�|� |�� ttd �d � ttd
��S td|||d�S )Nrv �unreadry z$[BuyerCall issue] Re: %(issue_type)s)�
issue_typez
You opened an issue regarding:z
---
{0}
---
z.Hello,%(body)s:%(issue)s
Thanks,
Support team)�body�issue)rk �subject�messagez"Issue has been saved successfully.r� � admin.issueszadmin/issue/edit.jinja2)rW � contact_formr� )r r= r\ r �methodr� �unread_to_openr# r� �LABELr� r] �questionr$ rk r� r� r� r r r r )rh r� rW r� � body_string� issue_stringr� r� r8 r8 r9 � issues_edith s.
� ��
�r� z/issues/contact/<int:id>c C sn t j�| �}|r*ddlm} |�| tj�d�tj�d�� t �|� t t
d�d� nt t
d�d� t t d ��S )
Nr )�deliver_support_emailr� r� z1The person who sent the issue has been contacted.r� z+Issue no longer exists, no e-mail was sent.r� r� )
r r= r\ � buyercall.blueprints.admin.tasksr� �delayr rW �set_as_contactedr r� r r )rh r� r� r8 r8 r9 �issues_contact� s
�
� r� z/couponsc C r� )Nzadmin/coupon/index.jinja2r� r� r8 r8 r9 �coupons� s r� z
/coupons-datac
C s� t tjdd�t tjdd�t tj�t tjdd�t tjdd�t tjdd�t tjdd�t tj dd�t tj
dd�t tj dd�g
} t j
�� �t�}ttj|| �}t|�� �S )r� �none)�
search_method)r0 r rh r� �code�duration� redeem_by�times_redeemed�
amount_off� percent_off�duration_in_months�max_redemptionsr- ro r= rp r/ r r[ r rq )rr r= rt r8 r8 r9 � coupons_data� s �
r� z /coupons/newc
C s� t � } t| d�}|�� rT|�| � | j| j| j| j| j| j | j
| j d�}zt � |�r8t
td�d� ttd��W S W n tyS } zt
t|j�d� W Y d }~nd }~ww td|| d�S ) Nry )r� r� r� r� �currencyr� r� r� z%Coupon has been created successfully.r� �
admin.couponsr� zadmin/coupon/new.jinja2)rW �coupon)r r% r� r� r� r� r� r� r� r� r� r� �creater r� r r r �_messager )r� rW �params�er8 r8 r9 � coupons_new� s.
�
� ��r� z/coupons/delete/<int:id>c C s t j�| �}|�� ttd��S )Nr� )r r= r\ �deleter r )rh r� r8 r8 r9 �coupons_delete� s r� z
/integrationsc C s t jdkr ttd��S td�S )Nr� �
user.settingsz&admin/integrations/integrations.jinja2)r rF r r r r8 r8 r8 r9 � integrations� s
r� z/compliance_dashboardc C sx t jdks
t jdkrttd��S t j} d }t j}t�|d�}ddl m
} |r2|t jd�}|j � � }nd}t
d| ||d �S )
Nr� �
automotiver� �creditr )�seven_hundred_credit_clientr; z.admin/integrations/compliance_dashboard.jinja2)r� �credit_credentials�url)r rF �
business_typer r rh rC r �)partner_account_seven_hundred_credit_info�!buyercall.lib.util_credit_reportsr� �
credit_report�get_compliance_dashboardr )r� r� �partner_accountr� �clientr� r8 r8 r9 �compliance_dashboard� s �r z2/integrations/<int:paid>/seven hundred_full_creditc C s, t � }t|d�}| }d}d}t j�tt j|kt j|kt j|k���� }|d u�r |jdk�r t j
d }t |�}|j d urH|j durH|�
|j �} nd} |jd ur[|jdur[|�
|j�}
nd}
|jd urn|jdurn|�
|j�} nd} t|j|
| | |j|j|jd�}|�� �rt |�}zg|jj|_|jjd ur�|jjdur�|�|jj�|_|j jd ur�|j jdur�|�|j j�|_ |jjd ur�|jjdur�|�|jj�|_|jj|_|jj|_|jj|_|�� tj�� tt d�d� t t d ��W S t � t!�"� � tj�#� tt d
�d � Y nnt$||||� t%d |d
�S )Nry � 700Creditr� �CRYPTO_SECRET_KEYr; �r� � api_account� api_username� api_password�experian_enabled�transunion_enabled�equifax_enabled�>The 700 Credit API Credentials have been updated successfully.r� �admin.integrations�eAn error occurred while saving the 700 Credit API Credentials. Please contact support for assistance.r� zHadmin/integrations/seven_hundred_credit/seven_hundred_full_credit.jinja2�rW )&r r& r= r^ r
�service_provider� product_typerC �firstr �configr r �decryptr
r r� r
r r r� ru �encryptr� r- ro r� r r� r r r� r� � traceback�
format_exc�rollback�new_credit_credentials_setr � �paid�
credit_objectrW �partner_account_id�provider�product�credit_profile� encrypt_key�cipher�decrypted_username�decrypted_account�decrypted_passwordr8 r8 r9 �seven_hundred_full_credit s|
���
�
���r* z8/integrations/<int:paid>/seven hundred_prequalify_creditc C s6 t � }t|d�}| }d}d}t j�tt j|kt j|kt j|k���� }|d u�r|jdk�rt j
d }t |�}|j d urH|j durH|�
|j �} nd} |jd ur[|jdur[|�
|j�}
nd}
|jd urn|jdurn|�
|j�} nd} t|j|
| | |j|j|jd�}|�� �r
t |�}zg|jj|_|jjd ur�|jjdur�|�|jj�|_|j jd ur�|j jdur�|�|j j�|_ |jjd ur�|jjdur�|�|jj�|_|jj|_|jj|_|jj|_|�� tj�� tt d�d� t t d ��W S t �y t �!t"�#� � tj�$� tt d
�d � Y n w nt%||||� t&d |d
�S )Nry r �
prequalifyr r; r r r� r r r� zNadmin/integrations/seven_hundred_credit/seven_hundred_prequalify_credit.jinja2r )'r r' r= r^ r
r r rC r r r r r r r
r r� r
r r r� ru r r� r- ro r� r r� r r � Exceptionr� r� r r r r r r r8 r8 r9 � seven_hundred_prequalify_creditJ s~
���
�
����r- z2/integrations/<int:paid>/finserv_prequalify_creditc C s t � }t|d�}| }d}d}t j�tt j|kt j|kt j|k���� }|d ur�|jdkr�t j
d }t |�}|j d urF|j durF|�
|j �} nd} |jd urY|jdurY|�
|j�}
nd}
|jd url|jdurl|�
|j�} nd} t|j| |
| d�}|�� r�t |�}z[|jj|_|j jd ur�|j jdur�|�|j j�|_ |jjd ur�|jjdur�|�|jj�|_|jjd ur�|jjdur�|�|jj�|_d|_|�� tj�� ttd�d � tt d
��W S t � t � � � tj�!� ttd �d � Y nnt"||||� t#d
|d�S )Nry �Finservr+ r r; )r� r r r
T�;The Finserv API Credentials have been updated successfully.r� r zbAn error occurred while saving the Finserv API Credentials. Please contact support for assistance.r� z;admin/integrations/finserv/finserv_prequalify_credit.jinja2r )$r r( r= r^ r
r r rC r r r r r r r r
r� r� ru r r
r� r- ro r� r r� r r r� r� r r r r r ) r r rW r! r" r# r$ r% r& r' r) r( r8 r8 r9 �finserv_prequalify_credit� sr
���
�
���r0 z /integrations/adf_email_importc C s� d} t j}t j}|r
t j}tj�tj|k��� }|ra|j d ur"|j } t
j dkra|j d u ra|j �
dd��
dd��
dd�}d�dd� |D ��}d �|dt|j� ��� } | |_ tj�� ttd
�d � td | d
�S )Nr; rw � �.r� �-c s s � | ] }|� � r|V qd S )N)�isalnum)r{ r� r8 r8 r9 � <genexpr>� s � z#adf_email_import.<locals>.<genexpr>z{}{}@inbound.buyercall.comz#ADF import email address generated.r� z;admin/integrations/adf_email_import/adf_email_import.jinja2)�adf_assigned_email)r rC rD rE r r= r^ rh r r6 r r� rR �replace�joinr] �str�lowerr- ro r� r r� r )� adf_emailrC rL r �name_before_format�name_after_formatr8 r8 r9 �adf_email_import� s0 �
�r> z*/integrations/<int:paid>/ams_evolution_dmsc
C s( t jd }t|�}t� }t|d�}| }d}tj�tj|k�� � }|�rtj�tj
|j ktj |k�� � }|d u�r=|j
d urI|j
dkrI|�|j
�} nd} |jd ur\|jdkr\|�|j�}
nd}
|jd uro|jdkro|�|j�} nd} |jd ur|jdkr|j} nd} |jd ur�|jdkr�|�|j�}
nd}
t|j| | |
| |
d�}|�� �r<z|jj|_|jjd ur�|jjdur�|�|jj�|_|jjd ur�|jjdur�|�|jj�|_
|jjd ur�|jjdur�|�|jj�|_|jjd ur�|jjdur�|�|jj�|_|jjd u�r
|jjdu�r
|jj|_|� � t j � � t t!d�d� t"t#d��W S t$�%t&�'� � t j �(� t t!d �d
� Y n�n�z�|�� �r�|�r�|jj|_| |_ |j |_
|jjd u�rh|jjdu�rh|�|jj�|_|jjd u�r~|jjdu�r~|�|jj�|_
|jjd u�r�|jjdu�r�|�|jj�|_|jjd u�r�|jjdu�r�|�|jj�|_|jjd u�r�|jjdu�r�|jj|_|� � t j � � t t!d�d� t"t#d��W S W n+ t)�y } z t$�%t&�'� � t$�%|� t j �(� t t!d �d
� W Y d }~nd }~ww t*d |d
�S t t!d�d� t"t#d��S )Nr ry r� r; )r� r
r r �api_url�
api_secretzAThe AMS Evolution API Credentials have been updated successfully.r� r zdAn error occurred while saving the AMS Evolution Credentials. Please contact support for assistance.r� zcAn error occurred while saving the AMS Evolution Credentials. Please contact supportfor assistance.z/admin/integrations/ams/ams_evolution_dms.jinja2r �HA service provider was not found. Please contact support for assistance.)+r r r r r) r r= r^ rR r � external_api_service_provider_idrh rC r� r �password� client_idr� �secretr� r� ru r
r r r r@ r? r� r- ro r� r r� r r r� r� r r r r, r )r r% r& �
dms_objectrW r! r" r �partner_service_providerr' r) r( r� �decrypted_secretr� r8 r8 r9 �ams_evolution_dms� s�
� ��
�
��
�
���� rI z'/integrations/<int:paid>/neo_verify_cmsc
C s� t jd }t|�}t� }t|d�}| }d}tj�tj|k�� � }|�rEtj�tj
|j ktj |k�� � }|d ur�|j
d urE|j
dkrE|j
} nd} |jd urX|jdkrX|�|j�}
nd}
t|j| |
d�}|�� r�zA|jj|_|jjd ur�|jjdur�|�|jj�|_|jjd ur�|jjdur�|jj|_
|�� tj�� tt d�d� t t d��W S t � t!�"� � tj�#� tt d �d
� Y nn~zR|�� �r|�r|jj|_| |_ |j |_
|jjd ur�|jjdur�|�|jj�|_|jjd ur�|jjdur�|jj|_
|�� tj�� tt d�d� t t d��W S W n+ t$�y> } z t � t!�"� � t � | � tj�#� tt d �d
� W Y d } ~ nd } ~ ww t%d |d
�S tt d�d� t t d��S )Nr ry r� r; )r� r? r@ z>The NEO Verify API Credentials have been updated successfully.r� r zaAn error occurred while saving the NEO Verify Credentials. Please contact support for assistance.r� z`An error occurred while saving the NEO Verify Credentials. Please contact supportfor assistance.z,admin/integrations/neo/neo_verify_cms.jinja2r rA )&r r r r r* r r= r^ rR r rB rh rC r� rE r r) r� r� ru r@ r r? r� r- ro r� r r� r r r� r� r r r r, r ) r r% r& rF rW r! r" r rG r� rH r� r8 r8 r9 �neo_verify_cmsi s�
� ���
��
�
���� rJ c
C sD t jd }|�� dkr|dkrt| d�}n-|�� dkr%|dkr%t| d�}n |�� dkr5|dkr5t| d�}n
ttd�d� tt d ��S |dkr�z{|�
� r�t |�}|| _ |j
j| _
|| _|| _|jjd urq|jjd
urq|�|jj�| _|jjd ur�|jjd
ur�|�|jj�| _|jjd ur�|jjd
ur�|�|jj�| _|jj| _|jj| _|jj| _| �� tj�� ttd �d � tt d ��W S W d S t y� } z t � t � � � t � |� tj�!� ttd
�d� W Y d }~d S d }~ww |dk�r�zv|�
� �rft |�}|| _ |j
j| _
|| _|| _|jjd u�r |jjd
u�r |�|jj�| _|jjd u�r6|jjd
u�r6|�|jj�| _|jjd u�rL|jjd
u�rL|�|jj�| _d| _| �� tj�� ttd�d � tt d ��W S W d S t �y� } z t � t � � � t � |� tj�!� ttd�d� W Y d }~d S d }~ww ttd�d � tt d ��S )Nr r� r ry r+ r. z>The product type and credit provider mapping is not available.r� r r; r r� z`An error occurred while saving the 700 Credit Credentials. Please contact supportfor assistance.Tr/ z]An error occurred while saving the Finserv Credentials. Please contact supportfor assistance.rA )"r r r: r& r' r( r r� r r r� r r r� ru rC r r
r r r r
r r r� r- ro r� r, r� r� r r r )r r" r r r% rW r& r� r8 r8 r9 r � s�
�
���
�
��� r )c�loggingr� r �flaskr r r r r r r r � flask_loginr
r � flask_babelr r� �
sqlalchemyr
�sqlalchemy.sqlr � stripe.errorr �buyercall.lib.util_cryptor �!buyercall.blueprints.admin.modelsr �$buyercall.blueprints.user.decoratorsr �"buyercall.blueprints.agents.modelsr � buyercall.blueprints.user.modelsr r �!buyercall.blueprints.issue.modelsr r� r �'buyercall.blueprints.billing.decoratorsr �*buyercall.blueprints.billing.models.couponr �0buyercall.blueprints.billing.models.subscriptionr r r r r � buyercall.blueprints.admin.formsr r r! r" r# r$ r% r& r' r( r) r* �#buyercall.blueprints.reports.modelsr+ r, �buyercall.extensionsr- r. �
datatablesr/ r0 �__name__r1 r: �routerM rY �exemptru r� r� r� r� r� r� r� r� r� r� r� r� r r* r- r0 r> rI rJ r r8 r8 r8 r9 �<module> s� ( 8 �
%
m
7
C C =# s U