File: //home/arjun/projects/buyercall/buyercall/blueprints/form_leads/__pycache__/models.cpython-310.pyc
o
�we) � @ sX d dl Zd dlmZmZ d dlZd dlZd dlmZ d dlm Z d dl
m Z d dl m
Z d dlmZ d dlmZmZmZ d d lmZ d d
lmZ d d lmZ d d lmZ G d
d� de e j �Z G dd� de e j �Z G dd� de j �Z G dd� de e j �Z G dd� de j �Z!G dd� de j �Z"G dd� de j �Z#G dd � d e e j �Z$G d d � d e e j �Z%dS ) � N)�date�datetime)�uuid4)�
ResourceMixin)�db)�
postgresql)�hybrid_property)�select�func�and_)�UUID)�tzware_datetime)�
AwareDateTime)�or_c @ s� e Zd ZdZeje�� dd�Zeje�� dd�Zejej dd�Z
e�ej ej ddd��Z e�ej ej d d
d��Z
e�ej ej d d d��Zeje�d
�dd�Zedd� �Zedd� �Zedd� �ZdS )�ExternalApiFormLeadPostTie� external_api_form_lead_post_tieF��nullableT�� primary_key�external_forms.id� form_id_form_lead_post_tie_fkey��name�
form_leads.id�$form_lead_id_form_lead_post_tie_fkey�!external_api_service_providers.id�+service_provider_id_form_lead_post_tie_fkey� c C sT t � }||_||_||_||_t�tj�|_ t�tj�|_
t j �
|� t j �� dS )z4
Sets a form/external service post.
N)r �form_id� form_lead_id� external_api_service_provider_id�external_api_lead_idr �now�pytz�utc�
created_on�
updated_onr �session�add�commit)�clsr r r! r" �new_post� r- �H/home/arjun/projects/buyercall/buyercall/blueprints/form_leads/models.py� set_external_api_form_lead_post% s z:ExternalApiFormLeadPostTie.set_external_api_form_lead_postc C s. d}t j�t j|kt j|k��� }|rd}|S )z;
Returns whether or not leads posts exist.
FT)r �query�filterr r! �first)r+ r r! �result�lead_post_existsr- r- r. �existing_posts_for_lead5 s
��z2ExternalApiFormLeadPostTie.existing_posts_for_leadc C s� i }ddl m}m} |j�|��|j|k��|j��|j ��
� }|rmt j�t j |kt j
�|���t j
t j��
� }|D ]2} |D ]-}
| j|
j krk| j
|vrZg || j
< || j
�|
j � q>|
j || j
vrk|| j
�|
j � q>q:|S )ze
Returns a dictionary/map of external service provider posts associated to the lead.
� ��0ExternalApiServiceProvidersPartnershipAccountTie�ExternalApiServiceProviders)�partnership.modelsr8 r9 r0 �joinr1 �partnership_account_id�active�
with_entities�id�allr r r �in_r! �append) r+ r �
form_lead_idsr< r3 r8 r9 �service_providers�posts�post�providerr- r- r. �existing_posts_for_leadsF s> �
���
�� z3ExternalApiFormLeadPostTie.existing_posts_for_leadsN)�__name__�
__module__� __qualname__�
__tablename__r �Column�DateTimer& r' �Integerr? �
ForeignKeyr r r! �Stringr" � classmethodr/ r5 rH r- r- r- r. r s& ��
r c @ s� e Zd ZdZeje�� dd�Zeje�� dd�Zejej ej
ddd�ddd�Z ejej ej
d d
d�dd �Z ejd e�
� dd
d�Zedd� �Zedd� �Zedd� �ZdS )�ExternalApiFormAutoPostTie� external_api_form_auto_post_tieFr r � form_id_form_auto_post_tie_fkeyr T)r �indexr �+service_provider_id_form_auto_post_tie_fkeyr �is_automatically_sent�0�r �server_defaultc C s t j�t j|k��� }|S )z�
Returns a list of existing form/external service provider ties.
:return: list of form/external api service provider tie objects
)rS r0 r1 r r@ )r+ r �tiesr- r- r. �get_existing_tiesz s z,ExternalApiFormAutoPostTie.get_existing_tiesc C sj d}ddl m}m} tj�|��|��|j|k��|j |k��
� }|r3t j�t j |kt j
|jk��
� }|S )z�
Returns an existing form/external service provider tie.
:return: a form/external api service provider tie object
Nr6 r7 )r: r8 r9 r r( r0 r; r1 r r< r2 rS r r! r? )r+ r r< �service_provider_name�service_provider_tier8 r9 �service_providerr- r- r. � get_service_provider_send_state� s$ �
��z:ExternalApiFormAutoPostTie.get_service_provider_send_statec
C s� ddl m}m} tj�|��|��|j|k��|j |k��
� }|rft j�t j |kt j
|jk��
� }|r>||_t�tj�|_n!t � } || _ |j| _
|| _t�tj�| _t�tj�| _tj�| � tj�� dS dS )z<
Sets a form/external service provider tie.
r6 r7 N)r: r8 r9 r r( r0 r; r1 r r< r2 rS r r! r? rX r r# r$ r% r' r& r) r* )
r+ r r< r^ �valuer8 r9 r` r_ �new_tier- r- r. �!set_service_provider_access_state� s8 �
�� �z<ExternalApiFormAutoPostTie.set_service_provider_access_stateN)rI rJ rK rL r rM rN r& r' rO rP r r! �BooleanrX rR r] ra rd r- r- r- r. rS k s* �� ��
rS c @ s� e Zd ZdZeje�d�dd�Zeje�d�ddd�Ze�e�d��Z ejej
dd �Z ejej
dd �Z ejej
ddd�Zeje�d
�dd �Zeje�d�dd d�Zejej
ddd�Zejej
dd �Zed d
� �Zedd� �Zedd� �Zedd� �ZdS )�ExternalFormFieldDefinition� external_form_field_definitions�2 Tr �
FrY rZ r r � c C s* i }t j�� �� }|D ]}|||j< q |S )z�
Return a dictionary containing all the form field definitions.
Key - field id
Value - external form field definition object
:return: dictionary object
)rf r0 r1 r@ �field_id)r+ r3 � form_fields�
form_fieldr- r- r. �api_get_field_definitions� s
z5ExternalFormFieldDefinition.api_get_field_definitionsc C s0 t j�tj��tjdk��� }dd� |D �}|S )zl
Return a list of the required fields for a form.
:return: list of required fields
Tc S � g | ]}|j �qS r- �rk ��.0�xr- r- r. �
<listcomp>� � zGExternalFormFieldDefinition.api_get_required_fields.<locals>.<listcomp>)r r( r0 rf rk r1 �requiredr@ )r+ rl � field_idsr- r- r. �api_get_required_fields� s �z3ExternalFormFieldDefinition.api_get_required_fieldsc C s^ ||krdS |dur-dt |�vr||krdS dS t |��d�}|D ] }||kr* dS q!dS dS )zp
Return whether or not a field id provided matches a field definition
:return: boolean
TN�,F)�str�split)r+ rk �definition_field_id�definition_old_field_id�split_old_fields�fieldr- r- r. �check_field_id_match� s �z0ExternalFormFieldDefinition.check_field_id_matchc C s g }|r~|D ]w}|rD|j rD|j |krD|�|j � |jrAdt|j�v r;t|j��d�}|D ] }||vr7|�|� q, |S |�|j� |S |jr}dt|j�v rit|j��d�}||v rh|�|j � |�|� |S q|j|kr}|�|j� |�|j � |S q|S )z�
Return a list of related fields (there can be several fields for the sa,e type."
:return: string array
ry )rk rB � old_field_idrz r{ �extend)r+ rk �field_definitionsr3 r r~ � old_fieldr- r- r. �get_all_related_fields sB
� ��
�
� z2ExternalFormFieldDefinition.get_all_related_fieldsN)rI rJ rK rL r rM rQ rk r� �typerO �
min_length�
max_lengthre rv � display_name�category�
show_in_table�positionrR rn rx r� r� r- r- r- r. rf � s(
rf c @ sD e Zd ZdZejddd�Zejddd�Ze�d�Zej ej
dd�Z ej e� d �d
dd �Z
ej e� d �d
d d
�Zej ej
e�d�dd�Ze� ej
ejdddd��Zej ejd
dd
�Zej ejd
dd
�Zej ejd
dd
�Zej e� d�d
d d
�Zej ejd
dd
�Zej ejd
dd
�Zej ejd
dd
�Zej e� d�d
d d
�Z ej e� d�d
d d
�Z ej ejd
dd
�Z ej ej
ejdd ddd �ddd �Z ej e� d �d
d d
�Z ej e�� d
d
d �Z!ej ejd
dd
�Z"ej e�#� dd!�Z$ej e�� d
dd
d"�Z%ej ejd
dd
�Z&e'd#d$� �Z(e'd%d&� �Z)e'd'd(� �Z*e+d)d*� �Z,e+d+d,� �Z-e+d-d.� �Z.d/S )0� ExternalForm�external_forms�FormLead�form��backref�ExternalFormField�WidgetTr rh F�r rV rj rZ �partnership_accounts.id�rV z
widgets.id�CASCADEzSET NULL)�onupdate�ondeleterY z{}z{"emails": ""}�@ �1� i zphonenumbers.id� auto_sms_message_inbound_fkey�r r� r� �rV r i �r �defaultr )r r[ r� c C � | j �d�S )z4 Return the date/time this form was created
�%Y-%m-%d %H:%M:%S�r& �strftime��selfr- r- r. �created_datetimew � z ExternalForm.created_datetimec C r� )z4 Return the date/time this form was updated
r� �r' r� r� r- r- r. �updated_datetime} r� z ExternalForm.updated_datetimec C s$ | j dur| j dur| j �d�S dS )z= Return the date/time this phone was deactivated on.
Nrj r� )�deactivated_onr� r� r- r- r. �deactivated_on_datetime� s z$ExternalForm.deactivated_on_datetimec
C s� d}d}z�i }i }|dur|� dd�|d< nd|d< |dur'|� dd�|d< nd|d< i d|�dd�d|�d |�d
|�d |�d |�d
|�d|�d| �d|
�d| �d| �d|
�d|�d|�d|�}tdi |��}tj�|� tj�� t�� }|dur�g }|D ] }|| }d}|jdu r�|j}|� t
|j |j |j
|j|d�� q~t|�dkr�tj�|� tj�� |j }n|j }W ||fS W ||fS d}t�dt�� � Y ||fS ) zy
Return the id of the new form that was created. If positive, then successful.
:return: integer
���rj N� �emailsr< � public_idr� �
routing_id�is_external_api_auto�email_addresses�adf_email_addresses�
email_subject�partial_data_email�full_submit_email�send_auto_email�send_auto_email_subject�send_auto_email_msg�
send_auto_sms�send_auto_sms_inbound_id�send_auto_sms_msg�auto_prequalify_credit)r r� rk r� r� r zUnable to create form.zError creating form. r- )�replacer� r r( r) r* rf rn r� rB r� r? r� rk r� �len�bulk_save_objects�log�error� traceback�
format_exc)r+ r< r� � widget_idr� r� r� r� r� r� r� r� r� r� r� r� r� r3 �
error_message�adf_email_dict�
email_dict� form_params�new_formr� �fields_to_insert� field_key� field_valuer- r- r. �
api_create� s�
�������� �
� � �
�����
�
�� �zExternalForm.api_createc C s� d}d}z�t j�tt j|kt j|kt jdk���� }|dur�i }i }|dur1|�dd�|d< ||_ |dur@|�dd�|d< ||_
|durG||_ |durN||_ |durU||_
|dur\||_| durc| |_|
durj|
|_|durq||_| durx| |_| dur| |_|
dur�|
|_|dur�||_|dur�||_|dur�||_tj�� d}nd}W ||fS W ||fS ty� d}d}t � d t � � � �� Y ||fS w )
za
Return whether or not the form was updated successfully.
:return: bool
Frj Nr� r� TzForm not found.zUnable to update form.zError updating form. ) r� r0 r1 r r? r< �is_deactivatedr2 r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r r( r* � Exceptionr� r� r� r� )r+ r< r r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r3 r� r� r� r� r- r- r. �
api_update� sr
��
� ��zExternalForm.api_updatec C sP d}t j�tt j|kt j|k���� }|dur&d|_t� � |_
t j �
� d}|S )ze
Return whether or not the form was deactivated successfully.
:return: bool
FNT)r� r0 r1 r r? r< r2 r� r r# r� r r( r* )r+ r? r< r3 r� r- r- r. �api_deactivate2 s �
zExternalForm.api_deactivateN)/rI rJ rK rL r � relationship�leads�fields�routingrM rO r? rQ r� r� rP r< r� re r� �pg�JSONr� r� r� r� r� r� r� r� r� r� r� �is_conditional_notification�conditional_criteriarN r� r� r� �propertyr� r� r� rR r� r� r� r- r- r- r. r� = sb
����
R
Rr� c @ s� e Zd ZdZejeje�d�dd�Zejejdd�Z eje�
d�dd�Z ejej
dd�Z ejej
ddd �Z ed
d � �Zed d
� �ZdS )r� �external_form_fieldsr Tr Fr rh rY rZ c C s( t j�t j|k��� }dd� |D �}|S )zM
Return a list form fields for a form
:return: list
c S ro r- rp rq r- r- r. rt d ru z5ExternalFormField.get_form_fields.<locals>.<listcomp>)r� r0 r1 r r@ )r+ r r� rw r- r- r. �get_form_fieldsY s �z!ExternalFormField.get_form_fieldsc C s, t j�t�tj���tj|k�� � pd}|S )zX
Return the largest position for a form field
:return: integer
r )
r r( r0 r
�maxr� r� r1 r �scalar)r+ r r3 r- r- r. �get_form_field_max_positionh s ��z-ExternalFormField.get_form_field_max_positionN)rI rJ rK rL r rM rO rP r r� rQ rk r� re r� rR r� r� r- r- r- r. r� H s �
r� c @ s� e Zd ZdZejejdd�Zejeje�d�dd�Z ejeje�d�dd�Z
ejeje�d�dd�Z eje� d�d d
d �Z
eje� d �d d
d �Zeje� d ed�Zedd� �Zedd� �ZdS )�FormLog� form_logsTr r r� r r � F�failedrZ i rj r� c
C sz d}t j�tt j|kt j|k���� }|dks|dkr d}nd}|dur;t|j||||d�} t j
� | � t j
� � dS dS )z%
Create a form log.
rj �� �� �successr� N)r r �status� descriptionr! )
r� r0 r1 r r? r< r2 r� r r r( r) r* )
r+ r< r r� r� � provider_idrG �formatted_status� form_lead� new_form_logr- r- r. �create� s( ��� �zFormLog.createc C s. t j�tt j|kt j|k���� }|rdS dS )z[
Check whether or not the lead was posted to a specified provider before.
TF)r� r0 r1 r r r! r2 )r+ r r! r3 r- r- r. �logs_exist_for_lead� s ��zFormLog.logs_exist_for_leadN)rI rJ rK rL r rM rO r? rP r r r! rQ r� r� r r
� posted_onrR r� r� r- r- r- r. r� v s �
r� c @ sP e Zd ZdZejeje�d�dd�Zeje� d�dd�Z
e�ej �Z dd� Z dS ) �
FormLeadField�form_lead_fieldsr Tr rh c C s || _ || _d S )N)rk r� )r� rk r� r- r- r. �__init__� s
zFormLeadField.__init__N)
rI rJ rK rL r rM rO rP �lead_idrQ rk r� r� r- r- r- r. r� � s � r� c @ s. e Zd ZdZejddd�Zejejdd�Z eje
dd�de dd�Z ejeje�
d �d
d �Zejeje�
d �dd
�Zeje�d�dd �Zejejd
dd�Zejejej
ddddd�ddd�Zedd� �Zedd� �Zedd� �Zed d � �Zejd d � �Zed d � �Z e d!d"� �Z e d#d$� �Z e d(d%d&��Z d'S ))r� �
form_leadsr� �leadr� Tr )�as_uuid)�uniquer� rV r Fr r� r� rh rY rZ � contacts.id�form_lead_contact_fkeyr� r� r� c C sL t j�t��tt j�d�t j�d��t j| j k��
� }|d ur$|j }|S dS )Nz%privacypolicyfield%z%privacypolicy%rj ) r� r0 r; r� r1 r rk �liker� r? r2 r� )r� �
tos_resultr3 r- r- r. �tos� s
�
��z FormLead.tosc C r� )z1 Return the date/time this lead occurred
r� r� r� r- r- r. �interaction_time� r� zFormLead.interaction_timec C r� )z4 Return the date/time this lead was updated
r� r� r� r- r- r. r� � r� zFormLead.updated_datetimec C s | j o| j jpdS �Nrj )r� r� r� r- r- r. �source s ��zFormLead.sourcec C s& t tjg��tj| jk��d��d�S )N� r� )r r� r� �wherer? r �limit�label)r+ r- r- r. r s �
� �c C s | j o| jpdS r )r� r r� r- r- r. � source_id s
��zFormLead.source_idc C sT d}d}zt j�|� t j�� d}W n d}d}t�dt�� � Y |||fS )za
Return whether or not the lead was created successfully.
:return: lead
Frj TzUnable to create lead.�Error creating lead. )r r( r) r* r� r� r� r� )r+ r� r3 r� r- r- r. r� s
zFormLead.api_createc
C sp d}d}|D ]~}|}|| } |j D ]r}
|
j|kr�| r | |
_|
jdks'|
jdkr1 t�d�|
j�� |
jdkr@ t�d�|
j�� |
jdksJ|
jd krT t�d
�|
j�� |
jd krc t�d �|
j�� |
jd
kr�ddlm} | j� | j
|j k�� � } |
j| _
tj�� qqz tj�� d}W ||fS ty� }
ztj�� d}t�dt�� � �� W Y d}
~
||fS d}
~
ww )zi
Return whether or not the form lead was updated successfully.
:return: boolean
Frj �
cumemberfield�ssnfieldz.The updated encoded form lead ssn number is {}�cosignerssnfieldz7The updated encoded form lead cosigner ssn number is {}�
datepicker�dobfieldz/The updated encoded form lead updated dob is {}�cosignerdateofbirthfieldz0The updated encoded form lead cosigner dob is {}�repfieldr6 )�ContactTr N)r� rk r� r� �info�format�contacts.modelsr r0 r1 r? �
contact_idr2 �agent_assignedr r( r* r� �rollbackr� r� r� )r+ r r� �posted_form_lead_fieldsr� r3 r� � posted_fieldrk r� r r �contact�er- r- r. r� + sN
��
�
��zFormLead.api_updatec C s& t j�t j|k�}|r|�� S |�� S )z�
Get the form_leads in a particular partnership account of id: `paid`.
if count_only = True, return the count instead of objects.
)r� r0 r1 r< �countr@ )r+ �paid�
count_onlyr� r- r- r. �get_by_partnership_account[ s �z#FormLead.get_by_partnership_accountN)F)!rI rJ rK rL r r� r� rM rO r? r r �sidrP r r< rQ r" re �
email_sentr r� r r r� r r �
expressionr rR r� r� r r- r- r- r. r� � sT ����
/r� c @ s� e Zd ZdZejejdd�Zejejejddd�ddd�Z ejejejd d
d�ddd �Z
eje� d �dd
�Z ejej
dd
�Zejejejddd�ddd �ZdS )�FormLeadReporting�form_leads_reportingTr r � form_lead_reporting_form_id_fkeyr Fr� r� �,form_lead_reporting_partnership_account_fkeyr� rh r r� �#form_lead_reporting_contact_id_fkeyN)rI rJ rK rL r rM rO r? rP r r< rQ r" re r! r r- r- r- r. r# g s$ �� �
�r# )&�loggingr� r r r� r$ �uuidr � buyercall.lib.util_sqlalchemyr �buyercall.extensionsr �sqlalchemy.dialectsr r� �sqlalchemy.ext.hybridr �sqlalchemy.sqlr r
r � sqlalchemy.dialects.postgresqlr �buyercall.lib.util_datetimer
r �
sqlalchemyr �Modelr rS rf r� r� r� r� r� r# r- r- r- r. �<module> s4 YXz
.A "