U
    YŸHgY  ã                   @   sd   d dl mZ d dlmZ d dlmZ d dlmZ d dlm	Z	 G dd„ deƒZ
G dd	„ d	eejƒZd
S )é    )Úabsolute_import)Ú	BaseQuery)Údb)ÚTimestampMixin)ÚTimecategoryc                   @   s   e Zd Zdd„ ZdS )ÚUserRegistrationDataQueryc                 C   s   |   tj|k¡ ¡ S )N)ÚfilterÚUserRegistrationDataÚnameÚall)Úselfr
   © r   ú=/var/www/dostadmin/dostadmin/db_model/userregistrationdata.pyÚget_by_name
   s    z%UserRegistrationDataQuery.get_by_nameN)Ú__name__Ú
__module__Ú__qualname__r   r   r   r   r   r   	   s   r   c                   @   s8  e Zd ZdZeZG dd„ dƒZG dd„ dƒZG dd„ dƒZG dd	„ d	ƒZ	G d
d„ dƒZ
G dd„ dƒZG dd„ dƒZG dd„ dƒZG dd„ dƒZG dd„ dƒZejejddZe e d¡¡Ze ej¡Ze e d¡¡Ze ej¡Ze ej¡Ze ej¡Ze ej¡Ze e d¡¡Ze e d¡¡Ze ej ¡Z!e e d¡¡Z"e ej¡Z#e e d¡¡Z$e e d¡¡Z%e e d¡¡Z&e e d¡¡Z'e e d¡¡Z(e e d¡¡Z)e ej*¡Z+e e d¡¡Z,e ej¡Z-e ej¡Z.e ej¡Z/e e d¡¡Z0e ej¡Z1e e d¡¡Z2e e d¡¡Z3dd„ Z4dS ) r	   Úuserregistrationdatac                   @   s    e Zd ZdZdZdZdZdZdZdZ	dZ
d	Zd
ZdZdZeejjeejjeejjeejjeejjeejje	ejj	e
ejj
eejjeejjeejjeejjiZdS )z&UserRegistrationData.ChampionsFormTimeÚ9Ú10Ú11Ú12Ú1Ú2Ú3Ú4Ú5Ú6Ú7Ú8N)r   r   r   ÚNINE_AMÚTEN_AMÚ	ELEVEN_AMÚ	TWELVE_PMÚONE_PMÚTWO_PMÚTHREE_PMÚFOUR_PMÚFIVE_PMÚSIX_PMÚSEVEN_PMÚEIGHT_PMr   ÚCategoryZFORM_TIMESLOT_MAPr   r   r   r   ÚChampionsFormTime   sJ               ôr-   c                   @   s   e Zd ZdZdZdS )zUserRegistrationData.PhoneOwnerZMataZPitaN)r   r   r   ZMOTHERZFATHERr   r   r   r   Ú
PhoneOwner/   s   r.   c                   @   s   e Zd ZdZdZdS )zUserRegistrationData.GirldChildÚHaanÚNahiN©r   r   r   ÚYESZNOr   r   r   r   Ú
GirldChild3   s   r3   c                   @   s   e Zd ZdZdZdS )zUserRegistrationData.SmartPhoner/   r0   Nr1   r   r   r   r   Ú
SmartPhone7   s   r4   c                   @   s   e Zd ZdZdZdS )z&UserRegistrationData.ChildBetween3and6r/   r0   Nr1   r   r   r   r   ÚChildBetween3and6;   s   r5   c                   @   s   e Zd ZdZdZdS )z&UserRegistrationData.DroppedMissedcallr/   r0   Nr1   r   r   r   r   ÚDroppedMissedcall?   s   r6   c                   @   s   e Zd ZdZdZdS )z%UserRegistrationData.ReceivedCallbackr/   r0   Nr1   r   r   r   r   ÚReceivedCallbackC   s   r7   c                   @   s   e Zd ZdZdZdS )z$UserRegistrationData.WhatsappProgramr/   r0   Nr1   r   r   r   r   ÚWhatsappProgramG   s   r8   c                   @   s$   e Zd ZdZdZdZeeedœZdS )z%UserRegistrationData.MissedcallReasonÚNO_PHONEZNO_BALZDOST_NOT_REACH)é   é   é   N)r   r   r   r9   Z
NO_BALANCEZDOST_NOT_REACHABLEZMissedcallReasonMapr   r   r   r   ÚMissedcallReasonK   s   r=   c                   @   sD   e Zd ZdZdZdZdZedededediZeegZed	ed
iZ	dS )zUserRegistrationData.UserSourceu[   à¤¯à¤¹ à¤®à¥‡à¤°à¤¾ à¤ªà¤°à¤¿à¤µà¤¾à¤° à¤•à¤¾ à¤¸à¤¦à¤¸à¥à¤¯ à¤¯à¤¾ à¤®à¤¿à¤¤à¥à¤° à¤¹à¥ˆu   à¤ªà¤¡à¤¼à¥‹à¤¸ à¤¸à¥‡uE   à¤¦à¥‹à¤¸à¥à¤¤ à¤•à¥‡ à¤°à¥‡à¤«à¤¼à¤°à¥à¤°à¥‡à¤² à¤•à¥…à¤‚à¤ªà¥‡à¤¨u<   à¤¦à¥‹à¤¸à¥à¤¤ à¤•à¥‡ à¤«à¥‡à¤¸à¤¬à¥à¤• à¤•à¥ˆà¤‚à¤ªà¥‡à¤¨ÚFAMILYÚ	NEIGHBOURÚREFERRALZDIGITALZreferralZdigital_campaignN)
r   r   r   r>   r?   r@   ZDIGITAL_CAMPAIGNZUserSourceValueZChampionSourcesZUserSourcePartnerMapr   r   r   r   Ú
UserSourceR   s&       ü  þrA   T)Úprimary_keyé2   é   éd   éÈ   é
   c                 C   s
   d| j  S )NzUserRegistrationData )r
   )r   r   r   r   Ú__repr__ƒ   s    zUserRegistrationData.__repr__N)5r   r   r   Ú__tablename__r   Úquery_classr-   r.   r3   r4   r5   r6   r7   r8   r=   rA   r   ÚColumnÚIntegerÚidÚStringr
   ÚBooleanZhas_girl_childÚphoneÚFloatZsubmitters_latitudeZsubmitters_longitudeZis_mothers_numberZhas_smartphoneZ	time_slotÚemailÚDateTimeZsignup_timeZhouse_numberZis_duplicateZaddress_line_1Zaddress_line_2Z	city_nameZ
state_nameZcountry_nameZpostal_codeÚDateZ	child_dobÚprogram_nameZis_child_3_6Zhas_dropped_missedcallZhas_received_callbackZmissedcall_reasonZwhatsapp_programZwa_phoneZuser_sourcerH   r   r   r   r   r	      sR   r	   N)Ú
__future__r   Úflask_sqlalchemyr   Ú	dostadminr   Údostadmin.mixinsr   Údostadmin.db_modelr   r   ÚModelr	   r   r   r   r   Ú<module>   s   