File: //home/arjun/projects/buyercall/buyercall/blueprints/leads/__pycache__/models.cpython-310.pyc
o
�we�F � @ s� d dl mZ d dlZd dlmZmZ d dlmZ d dlm Z d dl
m Z d dl m
Z
mZ d dlmZ d d lmZmZ d d
lmZ d d lmZ d d lmZ d d
lmZ G dd� dej �Z G dd� deej �Z G dd� deej �Z dS )� )� OrderedDictN)�or_�and_)�
postgresql)�hybrid_property)� load_only)�text�select)�UUID)�format_phone_number_bracket�format_phone_number)�EncryptedValue)�
ResourceMixin)�account_client)�dbc @ s� e Zd ZdZejejdd�Zejedd�de j
dd�Z ejeje� d�dd�Z
eje�� dd�Zeje�� dd�Zejejdd�Zeje�� dd d
�Zejd dd �Zejejej d
dddd�ddd�Zedd� �Zedd� �Zedd� �Z edd� �Z dS )� LeadNotes�
lead_notesT�� primary_key��as_uuid��unique�default�indexzleads.idF��nullable� �r �server_default�User)�backrefzusers.id�lead_notes_user_id_fkey�CASCADE��name�onupdate�ondelete�r r c C s( |}t j�tdi |��� t j�� dS )zk
Return whether or not the agent schedule was created successfully.
:return: bool
TN� )r �session�addr �commit)�cls�note�leadnoter) r) �C/home/arjun/projects/buyercall/buyercall/blueprints/leads/models.py�create- s
zLeadNotes.createc C sf |rt j�t�j|d��||||d�� t j�� dS t j�t�j|d��|||d�� t j�� dS )zk
Return whether or not the agent schedule was updated successfully.
:return: bool
)�id)�
updated_onr �
is_enabled�user_id)r3 r4 r5 T)r r* �queryr � filter_by�updater, )r- � lead_note_id�lead_note_text�lead_note_updated_date�lead_note_user_id�lead_note_enabledr) r) r0 r8 : s ��
��
zLeadNotes.updatec C � | j �d�S )z. Return the date the note was created
�%Y-%m-%d %H:%M:%S�r3 �strftime��selfr) r) r0 � date_editedQ � zLeadNotes.date_editedc C s d� | jj| jj�S )z@ Return the full name of the user that created the note
�{} {})�format�user� firstname�lastnamerB r) r) r0 �
user_fullnameW s zLeadNotes.user_fullnameN) �__name__�
__module__� __qualname__�
__tablename__r �Column�Integerr2 r
�uuid�uuid4�sid�
ForeignKey�lead_id�DateTime�
created_onr3 �Booleanr4 �Textr � relationshiprH r5 � classmethodr1 r8 �propertyrD rK r) r) r) r0 r s8 ��
r c @ s� e Zd Zeg d��Zeg d��ZdZejej dd�Z
eje dd�de j
dd�Zejddd �Zejd
d d d
dd�Zejej ejdddd�ddd�Z eje�d�dd�Zeje�d�ddd�Z eje�d�dddd�Zejed�dddd�Zejed�dddd�Zejed�dddd�Zejed�dddd�Z ejed�dddd�Z eje�� ddd�Z eje�d �dd �Z ejej dd�Z eje�!� dd�Z"eje�!� dd�Z#eje�d �dd�Z$eje�d�dddd�Z%eje�d�dddd�Z&eje�d�dddd�Z'eje�d �dddd�Z(ejed �ddd�Z)eje�d�dddd�Z*ejed!�ddd�Z+ejed!�ddd�Z,eje�d"�ddd�Z-eje�d"�ddd�Z.ejed�dddd�Z/e�ejejd#d$dd%d&��Z0ejej ejd'd(dd%d&�dd)�Z1e�ej ejd*d+dd%d&��Z2ejej ejd,d-ddd&�ddd�Z3ejej dd�Z4eje�5� ddd�Z6eje� � dd.d�Z7e�e�8� �Z9e�e:j;�Z<e=d/d0� �Z>e=d1d2� �Z?e=d3d4� �Z@eAd5d6� �ZBeAd7d8� �ZCeCjDd9d8� �ZCeCjEd:d8� �ZCeFd;d<� �ZGeFd=d>� �ZHeFd?d@� �ZIeFdAdB� �ZJeAdCdD� �ZKeKjEdEdD� �ZKeAdFdG� �ZLeLjEdHdG� �ZLeAdIdJ� �ZMeMjEdKdJ� �ZMeAdLdM� �ZNeFdNdO� �ZOeFdPdQ� �ZPeFdRdS� �ZQe=dTdU� �ZRdVS )W�Lead))�ringingr_ )� in-progressr` )� completedzlead has been captured)�missedz2lead was missed, and there will be no more retries)z
retry-pendingz+lead was missed, but we will call them back))znew leadzNew Lead)zgeneral interestzGeneral Interest)zfollow-up requiredzFollow-up Required)zapplication startedzApplication Started)zunder contractzUnder Contract)z$application submitted - credit unionz$Application Submitted - Credit Union)z application submitted - autopayz Application Submitted - AutoPay)z credit union declined no autopayz Credit Union Declined No AutoPay)zautopay declinedzAutoPay Declined)zcredit union contractedzCredit Union Contracted)zautopay contractedzAutoPay Contracted)zprevious customerzPrevious Customer)z service callz Service Call)z
accounts callz
Accounts Call)z
sold customerz
Sold Customer)zcompleted conversationzCompleted Conversation)zdo not contactzDo Not Contact�leadsTr r r �Agent)�back_populatesr �leadzall, delete-orphan�dynamiczdesc(LeadNotes.created_on))r! �cascade�lazy�order_by�partnership_accounts.idr# )r& r' Fr( � r �@ z no status)r r r r r � )r �
� i i � � widgets.guid�leads_widget_guid_fkeyzSET NULLr$ �phonenumbers.id�leads_inbound_fkey)r � agents.id�leads_agent_id_fkey� contacts.id�lead_contact_fkey�0c C sH |st d�S d�|�}t ttj�|�tj�|�tj�|�tj�|���S )z�
Search a resource by 1 or more fields.
:param query: Search query
:type query: str
:return: SQLAlchemy filter
r z%{0}%) r rG r r^ �email�ilikerI rJ �status)r- r6 � search_queryr) r) r0 �search s
��z Lead.searchc C s� ddl m}m} |j�|j|jk��� }|j�|j|jk��� }t |j�}|j
� |j �} |j
|_
|j|_|j|_|j|_|�� |S )Nr )� Partnership�PartnershipAccount)�'buyercall.blueprints.partnership.modelsr� r� r6 �filterr2 �partnership_account_id�first�partnership_idr �calls�get�call_sidr} �
start_time� starttime�end_time�endtime�duration�save)r- rf r� r� �partner_account�partner�
twilio_client�callr) r) r0 �update_lead_twilio s �
zLead.update_lead_twilioc C s^ t j�t j|kt j|kt j t jdkt jdk��tdd���t d���
� }|r-|j|j fS dS )z� Returns the last known first and last name for this phone number.
:param partnership_account_id: the ID of the current buyercall account
:param number: a US phone number in E.123 format (+1xxxyyyzzzz)
r �UnknownrI rJ zid desc)r r ) r^ r6 r� r� � phonenumberrI �optionsr rj r r� rJ )r- r� �numberrf r) r) r0 �get_last_known_name; s ���
zLead.get_last_known_namec C s2 ddl m} |j�| j|jk��� }|r|jS d S )Nr �rd )�"buyercall.blueprints.agents.modelsrd r6 r� �agent_assigned_idr2 r� � full_name)rC rd �agentsr) r) r0 �assigned_full_nameN s
�zLead.assigned_full_namec C s d� | j| j�S )NrF )rG rI rJ rB r) r) r0 r� U s zLead.full_namec C s2 d|v r|� dd�\| _| _d S |d| _| _d S )N� � r )�splitrI rJ )rC �valuer) r) r0 r� Y s c C s t j�| jd| j�S )Nr� )r �func�concatrI rJ )r- r) r) r0 r� ` s c C s& t j�t��| jtjkt j��� }|S )z4 Return the number of notes for this number
)r r6 �joinr^ r� r� r4 �count)rC � count_resultr) r) r0 �
note_countd s
��zLead.note_countc C s& t j�t j| jkt j| jk��� }|S )�4 Return the number of calls for this number
)r^ r6 r� r� r� r� )rC r� r) r) r0 �interaction_countp s
��zLead.interaction_countc C r> )r� r? )r� rA rB r) r) r0 �interaction_time| s zLead.interaction_timec C � | j d u rdS | j jS �Nr ��agentr� rB r) r) r0 �
agent_name� �
zLead.agent_namec C s | j o| j jp| jo
| jjpdS r� )�widgetr% �inbound�
friendly_namerB r) r) r0 �source� s � ��z Lead.sourcec C s, ddl m} ddlm} tj�|j|jd�S )Nr )�Widget��Phoner ) �#buyercall.blueprints.widgets.modelsr� �(buyercall.blueprints.phonenumbers.modelsr� r r� �coalescer% r� )r- r� r� r) r) r0 r� � s �c C s | j jpdS r� )r� r� rB r) r) r0 � source_name� s zLead.source_namec C �8 ddl m} t|j�d�g��|j| jk��d��d�S )Nr r� r% r� �phone) r� r� r r� �label�wherer2 �
inbound_id�limit)r- r� r) r) r0 r� � �
� �c C r� r� r� rB r) r) r0 �agent_full_name� r� zLead.agent_full_namec C r� )Nr r� r% r� r� ) r� rd r r� r� r� r2 �agent_idr� )r- rd r) r) r0 r� � r� c C s | j o| jp| jo
t| j�pdS r� )r� � widget_guidr� �strr� rB r) r) r0 � source_id� s
���zLead.source_idc C r> )z1 Return the date/time this lead occurred
r? )rX rA rB r) r) r0 �created_datetime� rE zLead.created_datetimec C r> )�; Return the date/time this lead record was updated
r? r@ rB r) r) r0 �updated_datetime� rE zLead.updated_datetimec C s� t | j�}ddlm} |j�t|j| jk|j|k��� � }|r*|j
r*d� |j
|j �S | j
r;| j
�� dkr;d� | j
�}nd}d� t| j�|�S )r� r )�ContactrF �unknownz({})r )r r� �$buyercall.blueprints.contacts.modelsr� r6 r� r r� �
phonenumber_1r� rI rG rJ � caller_id�lowerr )rC �formatted_numberr� �contact�call_idr) r) r0 �
contact_match� s
��
zLead.contact_matchc C s t j�t j|k��� }|S )z=
Get leads by partnership account id: `paid`
)r^ r6 r� r� �all)r- �paidrc r) r) r0 �get_by_partnership_account� s �z Lead.get_by_partnership_accountN)SrL rM rN r �STATUSES�PROGRESSrO r rP rQ r2 r
rR rS rT r[ r� r rU r� �String� call_sourcer} �progress_statusr
rI r� rJ r{ r� �my_phone�questionr� rW r� r� � call_typer� �transfer_call_id�missed_call_cause�cause_description�
recording_url� recording_id�transcription_text�transcription_text_2�transcription_1_confidence�transcription_2_confidence�originating_numberr� r� r� �
contact_idr� rZ �notes�
call_count�Float�response_time_secondsr �JSON�additional_infor\ r r� r� r r� r� �setter�
expressionr] r� r� r� r� r� r� r� r� r� r� r� r� r) r) r) r0 r^ ^ s, ��� ����������
��� ���� ��
r^ c @ s� e Zd ZdZejejdd�Zejejejddd�ddd�Z eje�
d �dd
�Z eje�
d �ddd�Z eje�
d �dd
�Z
ejejdd
�Zeje�� dd
�Zeje�� dd
�Zeje�
d �dd
�Zeje�
d �dd
�Zeje�
d �dd
�Zeje�
d
�dd
�Zeje�
d �dd
�Zejej
ejddd�ddd�Zejejejddd�ddd�Zejejejddd�ddd�Zejejejddd�ddd�Ze�e�� �Z dS )�
LeadReporting�leads_reportingTr rk �'lead_reporting_partnership_account_fkey)r% Fr( rl r rm ro rp rr � lead_reporting_widget_guid_fkey)r r rt � lead_reporting_inbound_id_fkeyrv � lead_reporting_agent_id_fkeyrx � lead_reporting_contact_id_fkeyN) rL rM rN rO r rP rQ r2 rU r� r� r� r} r� r� rW r� r� r� r� r� r� r� r� r� r� r� r� r� r) r) r) r0 r� � sP �� �� �� �� ��r� ) � collectionsr rR �
sqlalchemyr r �sqlalchemy.dialectsr �sqlalchemy.ext.hybridr �sqlalchemy.ormr �sqlalchemy.sqlr r � sqlalchemy.dialects.postgresqlr
� buyercall.blueprints.filtersr r �buyercall.lib.util_cryptor
� buyercall.lib.util_sqlalchemyr �buyercall.lib.util_twilior �buyercall.extensionsr �Modelr r^ r� r) r) r) r0 �<module> s& M