U
    JYcÊk ã                   @   sÎ  d dl mZ d dlmZmZ d dlZd dlZ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 d dlZd d	lmZ d d
lmZ d dlmZmZmZmZ d dlmZ d dlmZ d dlmZ d dlm Z m!Z! 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+ d dl,m-Z- d dl.m/Z/m0Z0m1Z1m2Z2 d dl3m4Z4 d dl5m6Z6m7Z7m8Z8m9Z9m:Z:m;Z;m<Z<m=Z=m>Z>m?Z?m@Z@mAZAmBZB d dlCmDZD d dlEmFZFmGZGmHZHmIZImJZJmKZKmLZLmMZMmNZNmOZOmPZPmQZQmRZRmSZSmTZTmUZUmVZVmWZWmXZXmYZYmZZZm[Z[m\Z\m]Z]m^Z^m_Z_m`Z`maZa d dl*mbZb d dlcmdZdmeZe d dlfmgZgmhZhmiZimjZjmkZkmlZl d dlmmnZnmoZompZpmqZqmrZrmsZsmtZt d dlumvZvmwZwmxZx eƒ Zyd d lzm{Z{ d d!lCm|Z| d d"l}m~Z~ d#d$„ Zd%d&„ Z€d'd(„ Z�d)d*„ Z‚d+d,„ Zƒd-d.„ Z„ed/d0„ ƒZ…ed1d2„ ƒZ†ed3d4„ ƒZ‡ed5d6„ ƒZˆed7d8„ ƒZ‰ed9d:„ ƒZŠed;d<„ ƒZ‹ed=d>„ ƒZŒed?d@„ ƒZ�edAdB„ ƒZŽedCdD„ ƒZ�edEdF„ ƒZ�edGdH„ ƒZ‘edIdJ„ ƒZ’edKdL„ ƒZ“edMdN„ ƒZ”edOdP„ ƒZ•edQdR„ ƒZ–edSdT„ ƒZ—edUdV„ ƒZ˜edWdX„ ƒZ™edYdZ„ ƒZšed[d\„ ƒZ›ed]d^„ ƒZœed_d`„ ƒZ�edadb„ ƒZžedcdd„ ƒZŸededf„ ƒZ edgdh„ ƒZ¡edidj„ ƒZ¢edkdl„ ƒZ£edmdn„ ƒZ¤edodp„ ƒZ¥edqdr„ ƒZ¦edsdt„ ƒZ§edudv„ ƒZ¨edwdx„ ƒZ©edydz„ ƒ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°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“d”„ 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½ed¡d¢„ ƒZ¾ed£d¤„ ƒZ¿ed¥d¦„ ƒZÀd d§lCmÁ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Çed´dµ„ ƒ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ÎedÂdÃ„ ƒZÏedÄdÅ„ ƒZÐedÆdÇ„ ƒZÑedÈdÉ„ ƒZÒd dÊlÓmÔZÔ d dlÕZÕd dËlmÖZÖ edÌdÍ„ ƒZ×edÎdÏ„ ƒZØedÐdÑ„ ƒZÙedÒdÓ„ ƒZÚdÔdÕ„ ZÛdS )Öé    )Úisalpha)ÚdatetimeÚ	timedeltaN)Úexists)Úcontext)Únot_©Úname)Ú
FastParser)Úsettings)Úmessages)ÚauthenticateÚloginÚlogoutÚget_user_model)Úlogin_required)Úget_current_site)ÚObjectDoesNotExist)ÚrenderÚredirect)Ú	Paginator)Útimezone)Ú
force_text)Úurlsafe_base64_decode)Úmake_password)Úsearch)ÚCountryÚSubPublisherUserÚSubscriptionÚSubscriptionType)Úsend_mobile_otp_to_user)ÚAuthorÚMagMapAuthorÚMagazineCommissionInfoÚMagazineOfferinfoÚMagazineOrderinfoÚMagazinePurchaseInfoÚSystemCategoryÚMagazineCategoryÚMagazineInfoÚMegazinePagesÚLanguageÚUserMapOfferÚWithdrawalDetails)ÚQ)ÚAddOffersFormÚAddSubscriptionFormÚAddSystemCategoryFormÚAddAuthorFormÚAddLanguageFormÚAddMagazineCategoryFormÚAddMagazineInfoFormÚAddMegazinePagesFormÚAssignUsersToOffersFormÚChangePasswordFormÚCommissionFormÚCountryFormÚCountrySubscriptionFormÚForgetChangePasswordFormÚForgotPasswordFormÚMagazineAuthorFormÚProfileFormÚPublisherFormÚSubAdminFormÚSubPublisherFormÚSubscriptionCommisionFormÚSubscriptionTypeFormÚUpdateLanguageFormÚUserLoginFormÚUserRegisterFormÚVerifyMobileFormÚVerifyRegiterFormÚWithdrawalForm)Úcheck_password)Úsend_config_emailÚ
send_email)ÚGetAuhtorSerializerÚ!MagazineGroupwiseReportSerializerÚ"MagazinePurchaseInfoListSerializerÚ'MagazinePurchaseInfoSumAmountSerializerÚMagazineSellDetailsSerializerÚReportListSerializer)ÚDeliveryRequestStatusEmailTreadÚ ForgotPasswordVerificationThreadÚMagazineApprovedEmailTreadÚMagazineStatusEmailTreadÚ$SentForgotPasswordLinkViaEmailThreadÚSentOTPViaEmailThreadÚWithdrawRequestStatusEmailTread)ÚTopMegazineCategoriesÚget_MostSellMagazinesÚget_UserCount)Úget_random_string)ÚValue)ÚConcatc           	      C   sÊ  t ƒ }| jdk�r´t | jƒ}| ¡ �rªtdƒ | jd }| jd }| j d¡}t|dƒ |dkròt|dƒ t||d�}|rÚtjj	t
d	d
gd�|d� ¡ }|rÂtdƒ t| |ƒ ttjƒ ttjƒS t | d¡ ttjƒS nt | d¡ ttjƒS n¶|dk�r’t|dƒ t||d�}|�rztjj	t
ddgd�|d� ¡ }|�rbtdƒ t| |ƒ ttjƒ ttjƒS t | d¡ ttjƒS nt | d¡ ttjƒS nt | d¡ ttjƒS n
t | jƒ}d|dœ}t| d|ƒS )NÚPOSTZdffffffffffffffffffffffffÚusernameÚpasswordÚrolesz===========================<Úadmin)rb   rc   é   é   )Zroles_id__in©rb   z >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>zYou are not allowed to login.zInvalid credentials.Ú	publisheré   é   ZLogin©ÚtitleÚformszweb/login.html)rF   Úmethodra   Úis_validÚprintÚgetr   ÚUserÚobjectsÚfilterr.   Úlastr   r   ÚLOGIN_REDIRECT_URLr   r   Úerrorr   )	Úrequestrn   Úformrb   rc   r	   ÚuserZvalidate_userr   © r|   úS/var/www/html/staging.mfahmagazine.net/magazine_api/magazine_web_admin/web/views.pyÚ
user_login(   sT    















r~   c                 C   s  t ƒ }| jdk�rtjj| jd dd� ¡ }|rPtjj| jd d� ¡ }| ¡  tjj| jd d� ¡ }|�sút | jƒ}| jd }| jd }| jd	 }| jd
 }tdd„ |D ƒƒ�rìtdd„ |D ƒƒ�rìt	|ƒdk�rÞt	|ƒdk�rÞ||k�rÐ| 
¡ �rÂtddd�}	tdƒ tƒ }
| jd |
_| jd |
_| jd |
_| jd |
_t| jd	 ƒ|
_d|
_|	|
_|
 ¡  tjj| jd d�j| jd d� | jd }|
j}||
j|	|dœ}t|ƒ ¡  td|› �ƒS t | d¡ nt | d¡ nt | d¡ nt | d¡ nt | d¡ d|dœ}t| d|ƒS ) Nra   ÚemailF)rb   Úemail_varification©r   rh   Ú
first_nameÚ	last_namerc   Úconfirm_passwordc                 s   s   | ]}|  ¡ p| ¡ V  qd S ©N©r   Úisspace©Ú.0Úxr|   r|   r}   Ú	<genexpr>¢   s     z user_register.<locals>.<genexpr>c                 s   s   | ]}|  ¡ p| ¡ V  qd S r…   r†   ©r‰   Úyr|   r|   r}   r‹   ¢   s     é   rk   Ú
0123456789©Úallowed_charszsaved<------------------------rj   Ú
country_id)Úcountry)Úrequested_emailr	   ÚotpÚuseridú/auth/register/verification/úData is not valid.z-Password and Confirm Password is not matched.z?Password and Confirm Password length should minimum seven digitúName must be character.z$Emails is already registred with us.ZRegistrationrl   zweb/register.html)rG   ro   rs   rt   ru   ra   r   ÚallÚdeleteÚlenrp   r^   rq   r‚   rƒ   r   rb   r   rc   Úroles_idr•   ÚsaveÚupdateÚidrY   Ústartr   r   rx   r   )ry   rn   Zemail_verificationÚu1Zexistance_of_userr‚   rƒ   rc   r„   r•   r{   r”   r–   Úrecord_datar   r|   r|   r}   Úuser_register”   sR    




(

"

r¤   c                 C   s”   t ƒ }tjj|d� ¡ }|j}t|dƒ | jdkr€| jd }||krfd|_	| 
¡  t | d¡ tdƒS t | d¡ td	|› �ƒS d
|i}t| d|ƒS )N©r    z$OTP SCREEN GETED OTP<<<<<<<<<<<<<<<<ra   Zregister_otpTzAccount Create Successfuly.ú/úOtp is wrong!r—   rn   z web/Verify_register_account.html)rI   rs   rt   ru   rv   r•   rq   ro   ra   r€   rž   r   Úsuccessr   rx   r   )ry   r    rn   ÚusersZ	email_otpÚuser_otpr   r|   r|   r}   ÚVerify_register_accountÊ   s    


r«   c           	      C   sÞ   t ƒ }| j› d |  ¡ ›  }t|dƒ | jdkr¾| j d¡}tjj	|d� 
¡ }t|ƒ |r²tjj	|d� ¡ }|jd |j }|j}||||dœ}t|ƒ ¡  tdƒ t | d	¡ nt | d
¡ t| jƒ d|dœ}t| d|ƒS )Nz://z<====================Hostra   Zforgot_password_emailr�   ú )r”   r	   r–   Úbase_urlzEmail Successfully Delivered!z@Link to reset your password is successfully sented to your mail.zEnter email is not recognised!zForgot Passwordrl   zweb/forgot-password.html)r=   ÚschemeÚget_hostrq   ro   ra   rr   rs   rt   ru   r   rv   r‚   rƒ   r    rX   r¡   r   r¨   rx   r   )	ry   rn   r­   r”   r{   r	   r–   r£   r   r|   r|   r}   Úsent_forgot_password_urlÞ   s&    



r°   c           	      C   s²   t ƒ }tjj|d�}t|dƒ | jdkržt | jƒ}| ¡ rž| jd }| jd }||kr‚t|ƒ}tjj|d�j	|d� t
 | d¡ nt
 | d¡ td	|› d
�ƒS d|i}t| d|ƒS )Nr¥   z!<<<<<<<<<<<<<<<<<<<<<<<<<<<<,Userra   rc   r„   )rc   z&Your password is successfully Chnaged.ú-Password and Confirm Password is not matched!z/user/change_password/r¦   rn   zweb/change-password.html)r8   rs   rt   ru   rq   ro   ra   rp   r   rŸ   r   r¨   rx   r   r   )	ry   r    rn   r{   rz   rc   r„   Znew_passwordr   r|   r|   r}   Úchange_passwordø   s     




r²   c                 C   s   t | ƒ ttjƒS r…   )r   r   r   ÚLOGOUT_REDIRECT_URL)ry   r|   r|   r}   Úlogout_view  s    r´   c                 C   sò  | j j}| j j}tjjdd� ¡ }tjjdd� ¡ }tj ¡ }tj ¡ }t	j ¡ }t
j ¡ }tj ¡ }	|dkrøtjjdd� ¡ }
tj ¡ }tj ¡ }tj ¡ }tj ¡  d¡}t|dd| id	�}|j}d
}|rð|D ]}||d 7 }t|dƒ}qÒnd
}�nÎ|dk�r tjj|d� ¡ }g }|�r6|D ]}| |j¡ �q"tj t|d�t|d�B ¡ d¡}t|dd| id	�}|j}d
}|�rž|D ]}||d 7 }t|dƒ}�q~nd
}tjj|d� ¡ }g }|�rÖ|D ]}| |j¡ �qÂtjj|d� ¡ }
tjj|d� ¡ }tjj|d� ¡ }tjj|d� ¡ }n¦tjj|d� d¡}t|dd| id	�}|j}d
}|�rz|D ]}||d 7 }t|dƒ}�qZnd
}tjjdd� ¡ }
tjj|d� ¡ }tjj|d� ¡ }tjj|d� ¡ }d|||
||||||||	|dœ}t| d|ƒS )Nrg   ©r�   rj   ©rf   rg   rk   ú
-create_onTry   ©Úmanyr   r   Úammount©Úcreated_by_id©ZmagazineInfos__users_id__in©ÚmagazineInfos__users_id©Úid__in©Úusers_idZ	Dashboard)rm   Ú
sub_adminsÚ
publishersÚsub_publishersÚsystem_categoryÚmagazine_categoryÚmagazine_infoÚmagazine_pagesÚauthorÚ	languagesÚsubscriptionsÚoffersÚadmin_earning_amtzweb/dashboard/admin.html)r{   r�   r    rs   rt   ru   Úcountr'   r(   r+   r   r$   r)   r!   r*   r&   rš   Úorder_byrQ   ÚdataÚroundr   ÚappendrÃ   r.   r   )ry   Úrole_idÚuser_idrÄ   rÅ   rÇ   rÈ   rÌ   rÍ   rÎ   rÆ   rÉ   rË   rÊ   Úpurchase_inforÏ   ÚrowÚsubpubliserlistÚsubpliserappendÚsubpuliserrowr   r|   r|   r}   Úuser_dashboard  s–    








"órÜ   c                 C   s  | j }| j j}| j j}| j j}|d | }t||ƒ tƒ }| jdkròt| jƒ}| ¡ rò| j j	}| jd }	t
|	|ƒ}
|
rÞ| jd }| jd }||krÈt| jd ƒ|_	| ¡  ||dœ}t|ƒ ¡  tdƒS t | d¡ td	ƒS nt | d
¡ td	ƒS d|dœ}t| d|ƒS )Nr¬   ra   Úold_passwordrc   r„   )Ú	full_namer   z/user/dashboard/r±   z/user/forget_change_password/zOld Password is not matched!zForget Change Passwordrl   zweb/forget_password/index.html)r{   r   r‚   rƒ   rq   r<   ro   ra   rp   rc   rK   r   rž   rU   r¡   r   r   rx   r   )ry   r{   r   ÚfnameÚlnamerÞ   rn   rz   Zlast_passwordrÝ   Úcheckrc   Z
c_passwordr£   r   r|   r|   r}   Úforget_change_passwordv  s8    









râ   c                 C   sÊ   | j  dd¡}| jj}t|dƒ |rttj t|d�t|d�B t|d�B tdd�@ ¡}|sft	 
| d	¡ qˆt	 | d
¡ ntjjdd� d¡}t|dƒ t|dƒ}| j  d¡}| |¡}d||dœ}t| d|ƒS )Nr   Ú z7 <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<+_+_+++_+_+©Zfirst_name__icontains©Zlast_name__icontains©Zemail__icontainsrg   rµ   úNo Data Found!úData Found Successfully!ú-created_onz$<+==================================é   Úpagez	Sub Admin)rm   rÄ   r   zweb/sub_admin/index.html)ÚGETrr   r{   r    rq   rs   rt   ru   r.   r   rx   r¨   rÑ   r   Úget_pager   )ry   r   r    rÄ   Ú	paginatorÚpage_numberÚpage_objr   r|   r|   r}   Úsub_admin_view™  s    
0


rñ   c                 C   sÒ  t dƒ tƒ }| jj}| jdk�r¼| jd }| jd }| jd }tj t	|d�t	|d�B ¡}t |dƒ t
d	d
„ |D ƒƒ�r¦t
dd
„ |D ƒƒ�r¦|�sŽ| jd }| jd }t|ƒdk�rvt|ƒdk�rv||k�r^tƒ }	| jd |	_| jd |	_| jd |	_| jd |	_t|ƒ|	_d|	_|	 ¡  t |	dƒ tƒ }
||
_|	j|
_|
 ¡  t dƒ t | d¡ tdƒS t | d¡ t| jƒ}nt | d¡ t| jƒ}nt | d¡ t| jƒ}nt | d¡ t| jƒ}d|dœ}t| d|ƒS )NZYoYOra   r   r‚   rƒ   r�   rh   ú.++++++++++++++++++++++++++++++++++++++checkingc                 s   s   | ]}|  ¡ p| ¡ V  qd S r…   r†   rˆ   r|   r|   r}   r‹   ¼  s     z%add_sub_admin_view.<locals>.<genexpr>c                 s   s   | ]}|  ¡ p| ¡ V  qd S r…   r†   rŒ   r|   r|   r}   r‹   ¼  s     rc   r„   rŽ   rg   ú================>ú9<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<IN.ú!Data has been saved successfully.ú/user/dashboard/subadmin/ú-Password and confirm password does not match!ú0Your password must be greater than 6 characters.ú!This email is already registered!r™   zAdd Sub Adminrl   zweb/sub_admin/add.html)rq   rG   r{   r    ro   ra   rs   rt   ru   r.   rš   rœ   r‚   rƒ   r   rb   r   rc   r�   rž   r   r¼   rÃ   r   r¨   r   rx   r   ©ry   rn   r    r   rß   rà   Zcheck_emailrc   r„   r{   Zsub_userr   r|   r|   r}   Úadd_sub_admin_view±  sR    



(






rû   c                 C   s|   t d|ƒ tjj|d� ¡ }t |dƒ t| jp0d |d�}| jdkrf| ¡ rf| 	¡  t
 | d¡ tdƒS d|d	œ}t| d
|ƒS )Núid -----------------> r¥   z% <-----------------------------------©Úinstancera   ú#Data has been Updated successfully.rö   zEdit Sub Adminrl   zweb/sub_admin/edit.html)rq   rs   rt   ru   rv   rA   ra   ro   rp   rž   r   r¨   r   r   )ry   r    r{   rn   r   r|   r|   r}   Úedit_sub_admin_viewá  s    


r   c                 C   sV   t jj|d�}t|dƒ d|_| ¡  t|jdƒ t | |j› d|j	› d�¡ t
dƒS )Nr¥   ú==============Fú<===================r¬   z. (Subadmin) has been deactivated successfully.rö   ©rs   rt   rr   rq   Ú	is_activerž   r   r¨   r‚   rƒ   r   ©ry   r    r{   r|   r|   r}   Údelete_sub_admin_viewï  s    
r  c                 C   sV   t jj|d�}t|dƒ d|_| ¡  t|jdƒ t | |j› d|j	› d�¡ t
dƒS )Nr¥   r  Tr  r¬   ú, (Subadmin) has been activated successfully.rö   r  r  r|   r|   r}   Úactivate_sub_admin_viewù  s    
r  c                 C   s®   | j  dd¡}|rbtj t|d�t|d�B t|d�B tdd�@ ¡}|sTt | d¡ qvt | d	¡ ntjjdd� 	d
¡}t
|dƒ}| j  d¡}| |¡}d||dœ}t| d|ƒS )Nr   rã   rä   rå   ræ   rj   rµ   rç   rè   ré   rê   rë   Ú	Publisher©rm   rÅ   r   zweb/publisher/index.html)rì   rr   rs   rt   ru   r.   r   rx   r¨   rÑ   r   rí   r   )ry   r   rÅ   rî   rï   rð   r   r|   r|   r}   Úpublisher_view  s    0

r  c                 C   sÊ  t ƒ }| jj}| jdk�r´| jd }| jd }| jd }tj t|d�t|d�B ¡}t	|dƒ t
dd	„ |D ƒƒ�ržt
d
d	„ |D ƒƒ�rž|�s†| jd }| jd }t|ƒdk�rnt|ƒdk�rn||k�rVtƒ }	| jd |	_| jd |	_| jd |	_| jd |	_t|ƒ|	_d|	_|	 ¡  t	|	dƒ tƒ }
||
_|	j|
_|
 ¡  t	dƒ t | d¡ tdƒS t | d¡ t | jƒ}nt | d¡ t | jƒ}nt | d¡ t | jƒ}nt | d¡ t | jƒ}d|dœ}t| d|ƒS )Nra   r   r‚   rƒ   r�   rh   rò   c                 s   s   | ]}|  ¡ p| ¡ V  qd S r…   r†   rˆ   r|   r|   r}   r‹   !  s     z%add_publisher_view.<locals>.<genexpr>c                 s   s   | ]}|  ¡ p| ¡ V  qd S r…   r†   rŒ   r|   r|   r}   r‹   !  s     rc   r„   rŽ   rj   ró   rô   rõ   ú/user/dashboard/publisher/r÷   rø   rù   r™   zAdd Publisherrl   zweb/publisher/add.html©rG   r{   r    ro   ra   rs   rt   ru   r.   rq   rš   rœ   r‚   rƒ   r   rb   r   rc   r�   rž   r   r¼   rÃ   r   r¨   r   rx   r   rú   r|   r|   r}   Úadd_publisher_view  sP    



(






r  c                 C   sh   t jj|d� ¡ }t| jpd |d�}| jdkrR| ¡ rR| ¡  t	 
| d¡ tdƒS d|dœ}t| d|ƒS )	Nr¥   rý   ra   ú#Data has been updated successfully.r  zEdit Publisher Pagerl   zweb/publisher/edit.html)rs   rt   ru   rv   r@   ra   ro   rp   rž   r   r¨   r   r   ©ry   r    ri   rn   r   r|   r|   r}   Úedit_publisher_viewG  s    
r  c                 C   s@   t jj|d�}d|_| ¡  t | |j› d|j› d�¡ t	dƒS )Nr¥   Fr¬   z/ (Publisher) has been deactivated successfully.r  ©
rs   rt   rr   r  rž   r   r¨   r‚   rƒ   r   ©ry   r    ri   r|   r|   r}   Údelete_publisher_viewR  s
    r  c                 C   s@   t jj|d�}d|_| ¡  t | |j› d|j› d�¡ t	dƒS )Nr¥   Tr¬   r  r  r  r  r|   r|   r}   Úactivate_publisher_viewZ  s
    r  c                 C   sÊ  t ƒ }| jj}| jdk�r´| jd }| jd }| jd }tj t|d�t|d�B ¡}t	|dƒ t
dd	„ |D ƒƒ�ržt
d
d	„ |D ƒƒ�rž|�s†| jd }| jd }t|ƒdk�rnt|ƒdk�rn||k�rVtƒ }	| jd |	_| jd |	_| jd |	_| jd |	_t|ƒ|	_d|	_|	 ¡  t	|	dƒ tƒ }
||
_|	j|
_|
 ¡  t	dƒ t | d¡ tdƒS t | d¡ t | jƒ}nt | d¡ t | jƒ}nt | d¡ t | jƒ}nt | d¡ t | jƒ}d|dœ}t| d|ƒS )Nra   r   r‚   rƒ   r�   rh   rò   c                 s   s   | ]}|  ¡ p| ¡ V  qd S r…   r†   rˆ   r|   r|   r}   r‹   n  s     z)add_sub_publisher_view.<locals>.<genexpr>c                 s   s   | ]}|  ¡ p| ¡ V  qd S r…   r†   rŒ   r|   r|   r}   r‹   n  s     rc   r„   rŽ   rk   ró   rô   rõ   ú/user/dashboard/subpublisher/r÷   rø   rù   r™   zAdd SubPublisherrl   zweb/sub_publisher/add.htmlr  rú   r|   r|   r}   Úadd_sub_publisher_viewd  sP    



(






r  c                 C   sˆ  | j  dd¡}| jj}| jj}td|ƒ |dkr¦tdƒ |rŒtjjt	|d�t	|d�B t	|d�B d	d
� 
d¡}|s~t | d¡ q¤t | d¡ ntjjd	d
� ¡  
d¡}nªtjj|d� ¡ }g }|�rF|D ]}| |j¡ qÆ|�r0tjjt	|d�t	|d�B t	|d�B |d� 
d¡}|�s"t | d¡ nt | d¡ ntjj|d� 
d¡}n
tj ¡ }t|dƒ}| j  d¡}	| |	¡}
d|
|dœ}t| d|ƒS )Nr   rã   z
>>>>>>>>>>r¶   zadmin>>>>>>>>>>>>>>>rä   rå   ræ   rk   rµ   ré   rç   rè   r»   rÀ   rê   rë   r	  r
  zweb/sub_publisher/index.html)rì   rr   r{   r    r�   rq   rs   rt   ru   r.   rÑ   r   rx   r¨   rš   r   rÔ   rÃ   Únoner   rí   r   )ry   r   Zpubliser_idZrolesidrÅ   rÙ   rÚ   rÛ   rî   rï   rð   r   r|   r|   r}   Úsub_publisher_view“  s:    
00



r  c                 C   sh   t jj|d� ¡ }t| jpd |d�}| jdkrR| ¡ rR| ¡  t	 
| d¡ tdƒS d|dœ}t| d|ƒS )	Nr¥   rý   ra   r  r  zEdit SubPublisher Pagerl   zweb/sub_publisher/edit.html)rs   rt   ru   rv   rB   ra   ro   rp   rž   r   r¨   r   r   r  r|   r|   r}   Úedit_sub_publisher_viewÄ  s    
r  c                 C   s@   t jj|d�}d|_| ¡  t | |j› d|j› d�¡ t	dƒS )Nr¥   Fr¬   z3 (Sub-Publisher) has been deactivated successfully.r  r  ©ry   r    Zsub_publisherr|   r|   r}   Údelete_sub_publisher_viewÏ  s
    r  c                 C   s@   t jj|d�}d|_| ¡  t | |j› d|j› d�¡ t	dƒS )Nr¥   Tr¬   z1 (Sub-Publisher) has been activated successfully.r  r  r  r|   r|   r}   Úactivate_sub_publisher_view×  s
    r  c           	      C   s~  | j  dd¡}| jj}| jj}|dkrx|rftj t|d�t|d�B ¡}|sXt	 
| d¡ qvt	 | d¡ ntj ¡  d¡}nÎ|d	krâ|rÈtjjt|d�t|d�B | jjd
�}|sºt	 
| d¡ qàt	 | d¡ ntjj|d
� ¡  d¡}nd|�r.tjjt|d�t|d�B | jjd
�}|�s t	 
| d¡ nt	 | d¡ ntjj|d
� ¡  d¡}t|dƒ}| j  d¡}| |¡}d||dœ}t| d|ƒS )Nr   rã   r¶   )Zauthor_name__icontains)Zwriting_type__icontainsrç   rè   r·   rj   rÂ   rê   rë   r!   )rm   Úauthorsr   zweb/author/index.html)rì   rr   r{   r�   r    r!   rt   ru   r.   r   rx   r¨   rš   rÑ   r   rí   r   )	ry   r   r    rÖ   r  rî   rï   rð   r   r|   r|   r}   Úauthor_viewá  s8    $$

r  c                 C   s  t d| ƒ tƒ }| jdkròt| j| jƒ}| jd }| jd }tdd„ |D ƒƒrØtdd„ |D ƒƒr¼| ¡ r | ¡ }tj	j
|jd�j| jjd	� t | d
¡ tdƒS t | d¡ t| j| jƒ}qòt | d¡ t| j| jƒ}nt | d¡ t| j| jƒ}d|dœ}t| d|ƒS )Nz!+++++++++++++++++++++111111111111ra   Úauthor_nameÚwriting_typec                 s   s   | ]}|  ¡ p| ¡ V  qd S r…   r†   rˆ   r|   r|   r}   r‹     s     z"add_author_view.<locals>.<genexpr>c                 s   s   | ]}|  ¡ p| ¡ V  qd S r…   r†   rŒ   r|   r|   r}   r‹     s     r¥   rÂ   rõ   ú/user/dashboard/author/zSomething went wrong!úWriting type must be character!úName must be character!z
Add Authorrl   zweb/author/add.html)rq   r2   ro   ra   ÚFILESrš   rp   rž   r!   rt   ru   r    rŸ   r{   r   r¨   r   rx   r   )ry   rn   r   r!  rË   r   r|   r|   r}   Úadd_author_view
  s*    




r&  c                 C   sò   t d|ƒ tjj|d� ¡ }t| jp&d | jp.d |d�}| jdkrÜ| jd }| jd }t	dd„ |D ƒƒr¾t	d	d„ |D ƒƒrž| 
¡ r¼| ¡  t | d
¡ tdƒS qÜt | d¡ t| j| j|d�}nt | d¡ t| j| j|d�}d|dœ}t| d|ƒS )Nrü   r¥   rý   ra   r   r!  c                 s   s   | ]}|  ¡ p| ¡ V  qd S r…   r†   rˆ   r|   r|   r}   r‹   /  s     z#edit_author_view.<locals>.<genexpr>c                 s   s   | ]}|  ¡ p| ¡ V  qd S r…   r†   rŒ   r|   r|   r}   r‹   0  s     rÿ   r"  r#  r$  zEdit Authorrl   zweb/author/edit.html)rq   r!   rt   ru   rv   r2   ra   r%  ro   rš   rp   rž   r   r¨   r   rx   r   )ry   r    rË   rn   r   r!  r   r|   r|   r}   Úedit_author_view'  s$    





r'  c                 C   s2   t jj|d�}| ¡  tdƒ t | d¡ tdƒS )Nr¥   úDeleted<------ú#Data has been deleted successfully.r"  )r!   rt   rr   r›   rq   r   r¨   r   )ry   r    rË   r|   r|   r}   Údelete_author_view>  s
    r*  c           	      C   s´   | j  dd¡}| jj}| jj}|dkr||rltj t|d�¡}|sVt	 
| d¡ tdƒ q|t	 | d¡ tdƒ ntj ¡  d¡}t|d	ƒ}| j  d
¡}| |¡}d||dœ}t| d|ƒS )Nr   rã   r¶   ©Zcategory_name__icontainsrç   z-------------------is hererè   r·   rê   rë   zSystem Category)rm   Úsystem_categorysr   zweb/system_category/index.html)rì   rr   r{   r�   r    r'   rt   ru   r.   r   rx   rq   r¨   rš   rÑ   r   rí   r   )	ry   r   r    rÖ   r,  rî   rï   rð   r   r|   r|   r}   Úsystem_category_viewF  s"    



r-  c                 C   sì   t ƒ }| jdkrÖ| jd }tjj|d� ¡ }|r\t|ƒ t 	| d¡ t | j| j
ƒ}tdƒ nzt | j| j
ƒ}tdd„ |D ƒƒr¼| ¡ r | ¡  t | d¡ td	ƒS t 	| d¡ t | j| j
ƒ}nt 	| d
¡ t | j| j
ƒ}d|dœ}t| d|ƒS )Nra   Úcategory_name©r.  úCategory already exists.ú data  not foundc                 s   s   | ]}|  ¡ p| ¡ V  qd S r…   r†   rˆ   r|   r|   r}   r‹   l  s     z+add_system_category_view.<locals>.<genexpr>rõ   ú/user/dashboard/systemcategory/úCategory must be character.zAdd System Categoryrl   zweb/system_category/add.html)r1   ro   ra   r'   rt   ru   rv   rq   r   rx   r%  rš   rp   rž   r¨   r   r   ©ry   rn   r.  Úcategoryr   r|   r|   r}   Úadd_system_category_view]  s*    



r6  c                 C   s„  t d|ƒ tjj|d� ¡ }t| jp&d | jp.d |d�}| jdk�rn| jd }tjj|d� ¡ }|�r|j	|krÜt
dd„ |D ƒƒrÀ| ¡ r¤| ¡  t | d	¡ td
ƒS t | d¡ t| j| jƒ}nt | d¡ t| j| jƒ}n*t |ƒ t | d¡ t| j| jƒ}t dƒ nf| ¡ �rT| ¡ �r8| ¡  t | d	¡ td
ƒS t | d¡ t| j| jƒ}nt | d¡ t| j| jƒ}d|dœ}t| d|ƒS )Nrü   r¥   rý   ra   r.  r/  c                 s   s   | ]}|  ¡ p| ¡ V  qd S r…   r†   rˆ   r|   r|   r}   r‹   „  s     z,edit_system_category_view.<locals>.<genexpr>r  r2  r0  r3  r1  zEdit System Categoryrl   zweb/system_category/edit.html)rq   r'   rt   ru   rv   r1   ra   r%  ro   r    rš   rp   rž   r   r¨   r   rx   r   r   )ry   r    rÇ   rn   r.  r5  r   r|   r|   r}   Úedit_system_category_viewz  s@    






r7  c                 C   s*   t jj|d�}| ¡  t | d¡ tdƒS )Nr¥   r)  r2  )r'   rt   rr   r›   r   r¨   r   )ry   r    rÇ   r|   r|   r}   Údelete_system_category_view£  s    r8  c           	      C   s®   | j  dd¡}| jj}| jj}|dkrv|rftj t|d�t|d�B ¡}|sXt	 
| d¡ qvt	 | d¡ ntj ¡  d¡}t|d	ƒ}| j  d
¡}| |¡}d||dœ}t| d|ƒS )Nr   rã   r¶   r+  )Z"magazine_category_color__icontainsrç   rè   r·   rê   rë   zMagazine Category)rm   Úmagazine_categorysr   z web/magazine_category/index.html)rì   rr   r{   r�   r    r(   rt   ru   r.   r   rx   r¨   rš   rÑ   r   rí   r   )	ry   r   r    rÖ   r9  rî   rï   rð   r   r|   r|   r}   Úmagazine_category_view¬  s    

r:  c                 C   sì   t ƒ }| jdkrÖ| jd }tjj|d� ¡ }|r\t|ƒ t 	| d¡ t | j| j
ƒ}tdƒ nzt | j| j
ƒ}tdd„ |D ƒƒr¼| ¡ r | ¡  t | d¡ td	ƒS t 	| d
¡ t | j| j
ƒ}nt 	| d¡ t | j| j
ƒ}d|dœ}t| d|ƒS )Nra   r.  r/  r0  r1  c                 s   s   | ]}|  ¡ p| ¡ V  qd S r…   r†   rˆ   r|   r|   r}   r‹   Í  s     z-add_magazine_category_view.<locals>.<genexpr>rõ   ú!/user/dashboard/magazinecategory/zColor in hexcode.r3  zAdd Magazine Categoryrl   zweb/magazine_category/add.html)r4   ro   ra   r(   rt   ru   r   rq   r   rx   r%  rš   rp   rž   r¨   r   r   r4  r|   r|   r}   Úadd_magazine_category_viewÀ  s*    



r<  c                 C   sŽ  t jj|d� ¡ }t| jpd | jp$d |d�}| jdk�rx| jd }t jj|d� ¡ }|�r
|j|krÚt	dd„ |D ƒƒrº| 
¡ rš| ¡  t | d¡ td	ƒS t | d
¡ t| j| j|d�}nt | d¡ t| j| j|d�}n.t|ƒ t | d¡ t| j| j|d�}tdƒ nn| ¡ �rZ| 
¡ �r:| ¡  t | d¡ td	ƒS t | d¡ t| j| j|d�}nt | d¡ t| j| j|d�}d|dœ}t| d|ƒS )Nr¥   rý   ra   r.  r/  c                 s   s   | ]}|  ¡ p| ¡ V  qd S r…   r†   rˆ   r|   r|   r}   r‹   å  s     z.edit_magazine_category_view.<locals>.<genexpr>r  r;  r˜   r3  r0  r1  zData is not valid..zEdit Magazine Categoryrl   zweb/magazine_category/edit.html)r(   rt   ru   rv   r4   ra   r%  ro   r    rš   rp   rž   r   r¨   r   rx   rq   r   r   )ry   r    rÈ   rn   r.  r5  r   r|   r|   r}   Úedit_magazine_category_viewÛ  s>    





r=  c                 C   s*   t jj|d�}| ¡  t | d¡ tdƒS )Nr¥   r)  r;  )r(   rt   rr   r›   r   r¨   r   )ry   r    rÈ   r|   r|   r}   Údelete_magazine_category_view  s    r>  c                 C   sà  | j  dd¡}tƒ }| jj}| jj}|dkrú|rÜtt|ƒdƒ tj 	t
|d�t
|d�B t
|d�B t
|d�B t
|d	�B ¡}tj ¡ }z$t
t|ƒd
�}tj 	|¡ d¡}W n tk
rº   Y nX |sÎt | d¡ qöt | d¡ ntj ¡  d¡}tj ¡ }�n¬|dk�rØ|�r°tj ¡ }tjj	t
|d�t
|d�B t
|d�B t
|d�B t
|d	�B |d�}z$t
t|ƒd
�}tj 	|¡ d¡}W n tk
�rŒ   Y nX |�s¢t | d¡ nt | d¡ n&tj 	t
|d�¡ ¡  d¡}tj ¡ }nÎ|�r€tj ¡ }tj 	t
|d�t
|d�B t
|d�B t
|d�B t
|d	�B ¡}z$t
t|ƒd
�}tj 	|¡ d¡}W n tk
�r\   Y nX |�srt | d¡ nt | d¡ n&tj ¡ }tj 	t
|d�¡ ¡  d¡}t|dƒ}| j  d¡}| |¡}	d|	||dœ}
t| d|
ƒS )Nr   rã   r¶   ú.......................©Úname__icontains)Z!system_category_id__category_name)Z#magazine_category_id__category_name)Zauthor_id__author_name)Zlanguage_id__language)Úrattingr·   rç   rè   rj   rÂ   rê   rë   úMagazine Info)rm   Úmagazine_infosr   rÊ   zweb/magazine_info/index.html)rì   rr   r)   r{   r�   r    rq   Útypert   ru   r.   r*   rš   ÚfloatrÑ   Ú
ValueErrorr   rx   r¨   r   rí   r   )ry   r   rD  r    rÖ   rÊ   Z
filter_argrî   rï   rð   r   r|   r|   r}   Úmagazine_info_view  sf    :


>
:


rH  c                 C   sÖ  t ƒ }tƒ }tƒ }| jdk�r¼| jd }|dkr6d}n|dkrF|dk | j d¡}t | j| jƒ}t|dƒ t|jd	ƒ t| jƒ}t| j| jƒ}| 	¡ �r¨|j	�r¨| jd
 }| jd }| jd }t
|ƒ}| jd }	|sð|sðtdƒ t | d¡ �n®|�r |�r ||k�rt | d¡ tdƒ �qž||k �r@t | d¡ tdƒ �qž||k�sT||k�rž|�rx|j}
|
 d¡�rjt |¡}|j}| ¡ }tjj|jd�j|d� tjj|jd�j| jjd� tjj|jd�j|d� tjj|jd�j|	d� tƒ }|j|_| jd |_| jj|_||_| ¡  |d j}|D ],}tƒ }||_ |j|_| ¡  t|dƒ �q(t !| d¡ t"dƒS t | d¡ n¤| ¡ }tjj|jd�j|d� tjj|jd�j| jjd� tjj|jd�j|d� |d j}|D ],}tƒ }||_ |j|_| ¡  t|dƒ �qÚt !| d¡ t"dƒS �n~|�rà|�sà|�r8|j}
|
 d¡�r*t |¡}|j}| ¡ }tjj|jd�j|d� tjj|jd�j| jjd� tjj|jd�j|d� tƒ }|j|_| jd |_| jj|_||_| ¡  |d j}|D ],}tƒ }||_ |j|_| ¡  t|dƒ �qèt !| d¡ t"dƒS t | d¡ n¤| ¡ }tjj|jd�j|d� tjj|jd�j| jjd� tjj|jd�j|d� |d j}|D ],}tƒ }||_ |j|_| ¡  t|dƒ �qšt !| d¡ t"dƒS �n¾|�sžtdƒ |�rú|j}
|
 d¡�rìt |¡}|j}| ¡ }tjj|jd�j|d� tjj|jd�j| jjd� tjj|jd�j|d� tƒ }|j|_| jd |_| jj|_||_| ¡  |d j}|D ],}tƒ }||_ |j|_| ¡  t|dƒ �qªt !| d¡ t"dƒS t | d¡ n¤| ¡ }tjj|jd�j|d� tjj|jd�j| jjd� tjj|jd�j|d� |d j}|D ],}tƒ }||_ |j|_| ¡  t|dƒ �q\t !| d¡ t"dƒS td ƒ nt | d!¡ t"d"ƒS d#|||d$œ}t#| d%|ƒS )&Nra   Úform_select_typeÚstandardÚStandardÚ	DifferentúDiffrent IssuesÚpagesz<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<1z>>>>>>>>>>>>>>>>>>>>>>>Ú
rent_priceÚ	buy_priceÚyear_availableÚcommentzProvide price.:::::::::::::::z!Please provide rent or buy price.z*Buy price and rent price can not be same.1ZEqualz+Buy price can not be less then rent price.1ZGreaterú.pdfr¥   ©Úmagazine_typerÂ   ©Úyears_available)rR  rË   ú<============+ Is Savedrõ   ú/user/dashboard/magazineinfo/z-File not supported, only pdf file is allowed!z(injbdsbbjsbdjd<<<<<<<<<<<<<<<<<<<<<<<<<<ZNOTINúPlease enter valid data.z/user/dashboard/addmagazines/rC  )rm   rn   Úauthor_formsÚpages_formszweb/magazine_info/add.html)$r5   r>   r6   ro   ra   r%  rr   rq   Úerrorsrp   Úintr   rx   r	   ÚendswithÚPyPDF2ÚPdfFileReaderÚnumPagesrž   r)   rt   ru   r    rŸ   r{   r*   Úmagazine_idrN  rÃ   rï   rÒ   r"   Ú	author_idr¨   r   r   )ry   rn   r[  r\  rU  Ú	mag_pagesZrentZbuyrQ  rR  ÚfilenameÚreadpdfÚ
totalpagesZmgnÚauthor_listrØ   r  r   r|   r|   r}   Úadd_magazine_info_viewJ  s6   





















rj  c                 C   s¤  t d|ƒ tjj|d� ¡ }|j}t t|ƒƒ tjj|d� ¡ }t	jj|d� ¡ }t
| jp\d | jpdd |d�}t| jpvd | jp~d |d�}tjj|d� ¡ }|j}	tj ¡ }
t|
dd|id�}
|
j}
| jdk�rj| ¡ �rj| jd	 }t|ƒ}| jd
 }|dk�rd}n|dk�r|dk | ¡  tjj|d�j|d� tjj|d�j|d� |d j}|d k	�rt |¡}|j}|j}| d¡�rìt	jj|d� ¡ }|�rÄt	jj|d�j|d� t	jj|d�j|d� n&t	ƒ }||_||_||_|	|_| ¡  nt  !| d¡ t"d|› d�ƒS tjj|d� #¡ }| j $d¡}|D ]*}tƒ }||_%||_| ¡  t |dƒ �q*t  &| d¡ t"dƒS |j�s~t  !| d¡ t |j'ƒ d||
||dœ}t(| d|ƒS ) Nrü   r¥   ©rc  rý   TZ
magzine_idr¸   ra   rQ  rI  rJ  rK  rL  rM  rT  rV  rN  rS  )rN  ©rï   z+File not supported! only pdf file is allow.z/user/dashboard/editmagazines/r¦   rË   rX  r  rY  r˜   zEdit Megazine Info)rm   rn   ri  r\  re  zweb/magazine_info/edit.html))rq   r)   rt   ru   rv   rW  rE  r"   rš   r*   r5   ra   r%  r6   rÃ   r!   rN   rÒ   ro   rp   r^  rž   rŸ   r`  ra  rb  r	   r_  r   rc  rN  rï   r   rx   r   r›   Úgetlistrd  r¨   r]  r   )ry   r    rÉ   rQ  r  re  rn   r\  ÚmagrÖ   ri  rU  Úarg  rh  rf  Zauthor_datarØ   r   r|   r|   r}   Úedit_magazine_info_view  sx    










 ÿrp  c                 C   sî   t jj|d� ¡ }| jd }|dkr�d|_d|_| ¡  t 	| |j
› d�¡ d}|j}t|dƒ |||j
dd	œ}t|j
d
ƒ t|ƒ ¡  tdƒ |dkræd|_d|_| ¡  t 	| |j
› d�¡ d}|j}|||j
dd	œ}t|ƒ ¡  tdƒS )Nr¥   ZflexRadioDefaultZbutton1Tú has been aproved successfully.z#with commission as per your countryz!views???????????????????????????/ÚApproved)Úpublisher_idÚextraÚmagazine_nameÚstatusz***********************88viewsz*ajay......................................Zbutton2Fzwithout commissionrY  )r)   rt   ru   rv   ra   Úis_commissionÚ
is_aprovedrž   r   r¨   r	   rÃ   rq   rV   r¡   r   )ry   r    rÉ   Zvalue_clickrt  rs  r£   r|   r|   r}   Ú!activate_magazine_commission_viewN  s0    

ry  c                 C   s*   t jj|d�}| ¡  t | d¡ tdƒS )Nr¥   r)  rY  )r)   rt   rr   r›   r   r¨   r   )ry   r    rÉ   r|   r|   r}   Údelete_magazine_info_viewi  s    rz  c                 C   sx   | j jdkrltjj|d�}d|_| ¡  t | |j	› d�¡ |j
}||j	ddœ}t|ƒ ¡  tdƒ tdƒS tdƒS d S )	Nrf   r¥   Tz! has been activeate successfully.Z	Activated©rs  ru  rv  ú%Email Delivered!!! <-----------------rY  ©r{   r�   r)   rt   rr   r  rž   r   r¨   r	   rÃ   rW   r¡   rq   r   ©ry   r    Zmgzrs  r£   r|   r|   r}   Úactivate_magazine_viewq  s    r  c                 C   sx   | j jdkrltjj|d�}d|_| ¡  t | |j	› d�¡ |j
}||j	ddœ}t|ƒ ¡  tdƒ tdƒS tdƒS d S )	Nrf   r¥   Fz# has been deactiveate successfully.ZDeactivatedr{  r|  rY  r}  r~  r|   r|   r}   Údeactivate_magazine_view„  s    r€  c                 C   sx   | j jdkrltjj|d�}d|_| ¡  t | |j	› d�¡ |j
}||j	ddœ}t|ƒ ¡  tdƒ tdƒS tdƒS d S )	Nrf   r¥   Trq  rr  r{  r|  rY  ©r{   r�   r)   rt   rr   rx  rž   r   r¨   r	   rÃ   rV   r¡   rq   r   r~  r|   r|   r}   Úaprove_magazine_view—  s    r‚  c                 C   sx   | j jdkrltjj|d�}d|_| ¡  t | |j	› d�¡ |j
}||j	ddœ}t|ƒ ¡  tdƒ tdƒS tdƒS d S )	Nrf   r¥   Fz" has been disaproved successfully.ÚDisapprovedr{  r|  rY  r�  r~  r|   r|   r}   Údisaprove_magazine_view«  s    r„  c                 C   s  t d|ƒ | jdk�r| j d¡}|rü|j}| d¡ræt |¡}|j}t	j
j|d� ¡ }t |dƒ |rž| j d¡|_||_| ¡  t dƒ t | d¡ td	ƒS t	ƒ }||_| jj|_| j d¡|_||_| ¡  t | d
¡ td	ƒS nt | d¡ td	ƒS nt | d¡ td	ƒS td	ƒS )NzINSIDE/////////////////////////ra   rN  rS  rk  z<<<<<<<<<<>>>>>>>>>>>>>>>>>zDone<<<<<<<<<<<<<zFile Updated succesfully.rY  zFile uploaded succesfully.z/File not supported! Only PDF files are allowed.zPlease Provide a PDF file.)rq   ro   r%  rr   r	   r_  r`  ra  rb  r*   rt   ru   rv   rN  rï   rž   r   r¨   r   rc  r{   r    rÃ   rx   )ry   r    re  rf  rg  rh  rn  Úmagaziner|   r|   r}   Ú	UploadPDF¿  s<    






r†  c           	      C   sh  | j  dd¡}| jj}| jj}|dkrn|r\tj t|d�¡}|sNt	 
| d¡ qlt	 | d¡ ntj ¡  d¡}nÂ|dkrÒ|r´tj t|d�t|d	�¡}|s¦t	 
| d¡ qÐt	 | d¡ ntj t|d	�¡ ¡  d¡}n^|�rtj t|d�t|d	�¡}|�st	 
| d¡ nt	 | d¡ ntj t|d	�¡ ¡  d¡}t|d
ƒ}| j  d¡}| |¡}d||dœ}t| d|ƒS )Nr   rã   r¶   )Zmagazine_id__name__icontainsrç   rè   r·   rj   rÂ   rê   rë   zMagazine Pages)rm   rÊ   r   zweb/magazine_pages/index.html)rì   rr   r{   r�   r    r*   rt   ru   r.   r   rx   r¨   rš   rÑ   r   rí   r   )	ry   r   r    rÖ   rÊ   rî   rï   rð   r   r|   r|   r}   Úmagazine_pages_viewæ  s8    

r‡  c                 C   s*  t ƒ }| jdk�rt | j| jƒ}| j d¡}tdƒ |rü|j}| d¡ràt 	|¡}|j
}tdƒ | ¡ r¸| ¡ }tjj|jd�j|d� tjj|jd�j| jjd� t | d	¡ td
ƒS t | d¡ t | j| jƒ}td|jƒ nt | d¡ t | j| jƒ}nt | d¡ t | j| jƒ}d|i}t| d|ƒS )Nra   rN  ú(<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<pppprS  Z	Supportedr¥   rl  rÂ   rõ   ú/user/dashboard/magazinepages/rZ  ú<<<<<<<<<<<<<<<<<<ú,File not supported only pdf file is allowed.úPlease Choose a file.rn   zweb/magazine_pages/add.html)r6   ro   ra   r%  rr   rq   r	   r_  r`  ra  rb  rp   rž   r*   rt   ru   r    rŸ   r{   r   r¨   r   rx   r]  r   )ry   rz   Úfilerf  rg  rh  Ú	mgn_pagesr   r|   r|   r}   Úadd_magazine_pages_view  s4    

r�  c                 C   s:  t d|ƒ tjj|d� ¡ }t| jp&d | jp.d |d�}| jdk�r$t| j| jƒ}| j 	d¡}t dƒ |�r
|j
}| d¡rît |¡}|j}| ¡ rÆ| ¡ }	tjj|	jd�j|d� t | d	¡ td
ƒS t | d¡ t| j| jƒ}t d|jƒ nt | d¡ t| j| jƒ}nt | d¡ t| j| jƒ}d|dœ}
t| d|
ƒS )Nrü   r¥   rý   ra   rN  rˆ  rS  rl  r  r‰  rZ  rŠ  r‹  rŒ  úEdit Megazine Pagesrl   zweb/magazine_pages/edit.html)rq   r*   rt   ru   rv   r6   ra   r%  ro   rr   r	   r_  r`  ra  rb  rp   rž   r    rŸ   r   r¨   r   rx   r]  r   )ry   r    rÊ   rn   rz   r�  rf  rg  rh  rŽ  r   r|   r|   r}   Úedit_magazine_pages_view3  s4    



r‘  c                 C   s2   t jj|d�}| ¡  tdƒ t | d¡ tdƒS )Nr¥   r(  r)  r‰  )r*   rt   rr   r›   rq   r   r¨   r   )ry   r    rÊ   r|   r|   r}   Údelete_magazine_pages_viewW  s
    r’  c           	      C   s¶   | j  dd¡}| jj}| jj}|dkrp|r`tjjt|d�dd�}|sRt	 
| d¡ qnt	 | d¡ q~tjjdd�}ntjjdd�}t|d	ƒ}| j  d
¡}| |¡}d||dœ}t| d|ƒS )Nr   rã   r¶   )Zlanguage__icontainsrf   r¥   rç   rè   rê   rë   Ú	Languages)rm   rÌ   r   zweb/languages/index.html)rì   rr   r{   r�   r    r+   rt   ru   r.   r   rx   r¨   r   rí   r   )	ry   r   r    rÖ   rÌ   rî   rï   rð   r   r|   r|   r}   Úlanguages_view_  s     

r”  c                 C   sº   t ƒ }| jdkr¤| jd }tjj|d� ¡ }|r\t|ƒ t 	| d¡ t | j| j
ƒ}tdƒ nHt | jpfd ƒ}| ¡ rŽ| ¡  t | d¡ tdƒS t 	| d¡ t | jƒ}d|d	œ}t| d
|ƒS )Nra   Úlanguage©r•  úLanguage already exists.r1  rõ   ú/user/dashboard/languages/r“  rl   zweb/languages/add.html)r3   ro   ra   r+   rt   ru   r   rq   r   rx   r%  rp   rž   r¨   r   r   )ry   rn   r•  r   r|   r|   r}   Úadd_languages_viewy  s$    




r™  c                 C   s  t jj|d� ¡ }t| jpd |d�}| jdk�r| jd }t jj|d� ¡ }|rÎ|j|kr–| ¡ r~| 	¡  t
 | d¡ tdƒS t
 | d¡ t| jƒ}n6t|jd	ƒ t|ƒ t
 | d¡ t| j| jƒ}td
ƒ n:| ¡ rò| 	¡  t
 | d¡ tdƒS t
 | d¡ t| jƒ}d|dœ}t| d|ƒS )Nr¥   rý   ra   r•  r–  r  r˜  r—  z<<<<<<<<<<<<<<<r1  r�  rl   zweb/languages/edit.html)r+   rt   ru   rv   r3   ra   ro   r    rp   rž   r   r¨   r   rx   rq   r%  r   )ry   r    r•  rn   r   r|   r|   r}   Úedit_languages_view�  s4    




rš  c                 C   s2   t jj|d�}| ¡  tdƒ t | d¡ tdƒS )Nr¥   r(  r)  r˜  )r+   rt   rr   r›   rq   r   r¨   r   )ry   r    r•  r|   r|   r}   Údelete_languages_view²  s
    r›  c                 C   s  | j j}tjj|d� ¡ }|jj}t|ƒ t	| j
p4d | jp<d |d�}| jdk�rþ| j
d }| j
d }| j
d }| j
d }tdd	„ |D ƒƒ�rêtd
d	„ |D ƒƒ�rêtjj|dd� ¡ }	tjj|d� ¡ }
| ¡ �rÔ|	�r||_||_||_| ¡  t | d¡ tdƒS |
dk	�rjd|_|jdk�rÒtddd�}||_t||ƒ ||_||_||_| ¡  td| j j› �ƒS nh|jdk�r¾tddd�}||_t||ƒ ||_||_||_| ¡  td| j j› �ƒS t | d¡ tdƒS nt | d¡ tdƒS nt | d¡ tdƒS t| d||ddœƒS )Nr¥   rý   ra   r‚   rƒ   Úphone_numberÚaddressc                 s   s   | ]}|  ¡ p| ¡ V  qd S r…   r†   rˆ   r|   r|   r}   r‹   Æ  s     zuser_profile.<locals>.<genexpr>c                 s   s   | ]}|  ¡ p| ¡ V  qd S r…   r†   rŒ   r|   r|   r}   r‹   Æ  s     T)rœ  Úphone_varification)rœ  z*This number is already registered with us.ú/user/profile/Frk   r�   r�   ú/user/profile/verification/r  zAddress format is wrong.r™   zweb/user_profile/index.htmlZProfile)rn   Ú	user_datarm   )r{   r    rs   rt   ru   rv   r“   r	   rq   r?   ra   r%  ro   rš   r   rp   r‚   rƒ   r�  rž   r   rx   r   rž  r^   r•   r    r¨   r   )ry   r    r¡  rÐ   rz   r‚   rƒ   rœ  r�  ZnumberexistsZnumber1r•   r|   r|   r}   Úuser_profileº  s`    



(





r¢  c                 C   sŠ   t ƒ }tjj|d� ¡ }|j}| jdkrv| jd }||kr\d|_| 	¡  t
 | d¡ tdƒS t
 | d¡ td|› �ƒS d	|i}t| d
|ƒS )Nr¥   ra   Z
mobile_otpTr  rŸ  r§   r   rn   zweb/user_profile/update.html)rH   rs   rt   ru   rv   r•   ro   ra   rž  rž   r   r¨   r   rx   r   )ry   r    rn   r©   Zmob_otprª   r   r|   r|   r}   ÚVerify_mobile_numberñ  s    

r£  c                 C   sr   t d|ƒ tjj|d� ¡ }t| jp&d |d�}| jdkr\| ¡ r\| 	¡  t
 | d¡ tdƒS d|dœ}t| d	|ƒS )
Nrü   r¥   rý   ra   r  ú/user/dashboard/subscription/zEdit Subscriptionrl   úweb/subscription/edit.html)rq   r   rt   ru   rv   r0   ra   ro   rp   rž   r   r¨   r   r   )ry   r    rÍ   rn   r   r|   r|   r}   Úedit_subscription_view/  s    

r¦  c                 C   s   d S r…   r|   )ry   r    r|   r|   r}   Údelete_subscription_view<  s    r§  c                 C   s$   t jj|d�}d|_| ¡  tdƒS )Nr¥   Fr¤  ©r   rt   rr   Úsubscription_statusrž   r   ©ry   r    Úsubscriptionr|   r|   r}   Údeactivate_subscriptionE  s    r¬  c                 C   s$   t jj|d�}d|_| ¡  tdƒS )Nr¥   Tr¤  r¨  rª  r|   r|   r}   Úactivate_subscriptionM  s    r­  c                 C   s¤   | j  dd¡}|r\tt|ƒdƒ tj t|d�t|d�B ¡}|sNt 	| d¡ qlt 
| d¡ ntj ¡  d¡}t|d	ƒ}| j  d
¡}| |¡}d||dœ}t| d|ƒS )Nr   rã   r?  )Zusers_id__email__icontains)Zcode__icontainsrç   rè   ré   rê   rë   ÚSubscriptions)rm   rÎ   r   zweb/offers/index.html)rì   rr   rq   rE  r$   rt   ru   r.   r   rx   r¨   rš   rÑ   r   rí   r   )ry   r   rÎ   rî   rï   rð   r   r|   r|   r}   Úoffers_viewV  s     

ýr¯  c                 C   sL  t ƒ }tƒ }| jdk�r4t | jƒ}t| jƒ}|d j}|d j}| jd }tjj|d� ¡ }|rtt	 
| |› d�¡ nÀ|dkrøt|ƒdkr–t	 | d	¡ n`| ¡ rà| ¡ }|D ] }tƒ }	||	_|j|	_|	 ¡  qªt	 | d
¡ tdƒS t	 
| d¡ t | jƒ}n<| ¡ �r| ¡  t	 | d
¡ tdƒS t	 
| d¡ t | jƒ}d||dœ}
t| d|
ƒS )Nra   r©   Ú	for_usersÚcode©r±  ú is already exist.Z
Perticularr   zPlease Choose atleast on user.rõ   ú/user/dashboard/offers/z!End date must be after start datezEnd date can not be from past.z
Add Offers)rm   rn   Ú	user_formzweb/offers/add.html)r/   r7   ro   ra   rÒ   r$   rt   ru   r   r   rx   rœ   Úinforp   rž   r,   rÖ   r    Úmagazineoffer_idr¨   r   r   )ry   rn   rµ  Z	user_listr°  r±  Ú
check_coderÎ   rØ   r©   r   r|   r|   r}   Úadd_offers_viewˆ  sB    







r¹  c                 C   sº   t d|ƒ tjj|d� ¡ }t| jp&d |d�}| jdkr¤| jd }tjj|d� ¡ }t |dƒ |rtt	 
| |› d�¡ | ¡ r˜| ¡  t	 | d	¡ td
ƒS t	 
| d¡ d|dœ}t| d|ƒS )Nrü   r¥   rý   ra   r±  r²  z-<---------------------------- Code Existance.r³  r  r´  zData is not been saved.zEdit Offersrl   zweb/offers/edit.html)rq   r$   rt   ru   rv   r/   ra   ro   r   r   rx   rp   rž   r¨   r   r   )ry   r    rÍ   rn   r±  r¸  r   r|   r|   r}   Úedit_offers_view¶  s     




rº  c                 C   sB   t jj|d�}d|_| ¡  tdƒ t | d|j› d�¡ t	dƒS )Nr¥   FzDeactivated<------úOffer z# has been deactivated successfully.r´  ©
r$   rt   rr   Úoffer_statusrž   rq   r   r¨   r±  r   ©ry   r    rÎ   r|   r|   r}   Údeactivate_offersÍ  s    r¿  c                 C   sB   t jj|d�}d|_| ¡  tdƒ t | d|j› d�¡ t	dƒS )Nr¥   TzActivated<------r»  z! has been activated successfully.r´  r¼  r¾  r|   r|   r}   Úactivate_offers×  s    rÀ  c                 C   s2   t jj|d�}| ¡  tdƒ t | d¡ tdƒS )Nr¥   r(  r)  r´  )r$   rt   rr   r›   rq   r   r¨   r   r¾  r|   r|   r}   Údelete_offers_viewá  s
    rÁ  c                 C   s  | j  dd¡}| jj}t| jjdƒ | jjdk�rJ|�r�tjj|d� 	¡ }g }|rh|D ]}| 
|j¡ qVtj t|d�t|d�B t|d�B t|d	�B t|d
�B t|d�B t|d�B ¡ d¡}t|dd| id�}|j}d}|rþ|D ]}||d 7 }t|dƒ}qànd}tj t|d�t|d�B t|d�B t|d	�B t|d
�B t|d�B t|d�B ¡ d¡}t|dd| id�}|j}|�s‚t | d¡ nt | d¡ n¶tjj|d� 	¡ }g }|�rÄ|D ]}| 
|j¡ �q°tj 	¡  d¡}t|dd| id�}|j}d}|�r|D ]}||d 7 }t|dƒ}�qúnd}tj 	¡  d¡}t|dd| id�}|j}�n’| jjdk�rB|�rdtjj|d� 	¡ }g }|�r’|D ]}| 
|j¡ �q~tj t|d�t|d�B t|d�B t|d	�B t|d
�B t|d�B t|d�B t|d�t|d�B ¡ d¡}t|dd| id�}|j}d}|�r>|D ]}||d 7 }t|dƒ}�qnd}|�sVt | d¡ nt | d¡ nÚtjj|d� 	¡ }g }|�r˜|D ]}| 
|j¡ �q„tj t|d�t|d�B ¡ d¡}t|dd| id�}|j}d}|�r |D ]}||d 7 }t|dƒ}�qànd}tj t|d�t|d�B ¡ d¡}t|dd| id�}|j}�nš| jjdk�rÜ|�rNtjj|d� 	¡ }g }|�rŠ|D ]}| 
|j¡ �qvtjjt|d�t|d�B t|d�B t|d	�B t|d
�B t|d�B t|d�B |d� d¡}t|dd| id�}|j}d}|�r(|D ]}||d 7 }t|dƒ}�qnd}|�s@t | d¡ nt | d¡ nŽtjj|d� d¡}t|dd| id�}|j}d}|�r¨|D ]}||d 7 }t|dƒ}�qˆnd}tjj| jjd� d¡}t|dd| id�}|j}t|dƒ}	| j  d¡}
|	 |
¡}d|||dœ}t| d|ƒS )Nr   rã   z <======================r¶   r»   ©Zusers__first_name__icontains©Zusers__last_name__icontains©Z+magazineInfos__users__first_name__icontains)Z*magazineInfos__users__last_name__icontains©ZmagazineInfos__name__icontains)Z#magazineInfos__buy_price__icontains)Z$magazineInfos__rent_price__icontainsr·   Try   r¸   r   rº   rg   rç   rè   rj   r½   r¾   rk   é
   rë   ZSells)rm   Úpurchase_infosr   Ztotal_ammountzweb/sell/index.html)rì   rr   r{   r    rq   r�   r   rt   ru   rš   rÔ   rÃ   r&   r.   rÑ   rP   rÒ   rÓ   r   rx   r¨   rQ   r   rí   r   )ry   r   rÖ   rÙ   rÚ   rÛ   r×   rÏ   rØ   rî   rï   rð   r   r|   r|   r}   Ú
sells_viewê  sä    TT
f""
X

rÈ  )ÚCountc              	   C   s”  | j  dd¡}| jj}| jj}t||dƒ g }g }g }g }g }g }	|dk�rÎ|�r*t|dƒ tjj|d� 	¡ }
g }|
 
d¡jtdƒd� d	¡}|D ]}| |d
 ¡ q’tjj|d� 	¡ }t|dd�}|sÖt | d¡ nt | d¡ tj 	¡ }t|ƒ}tj 	¡ }t|ƒ}tj 	¡ }t|ƒ}|d }|d }n tj 	¡ }t|ƒ}tj 	¡ }t|ƒ}g }tj 
d¡jtdƒd� d	¡}|D ]}| |d
 ¡ �qttjj|d� 	¡ }t|dd�}tj 	¡ }t|ƒ}|d }|d }�nr|dk�rò|�rt|dƒ tjj|d� 	¡ }g }|�r|D ]}| |j¡ �qtj t|d�t|d�t|d�B ¡ 	¡ }
g }|
 
d¡jtdƒd� d	¡}|D ]}| |d
 ¡ �qhtjj|d� 	¡ }t|dd�}|�s°t | d¡ nt | d¡ tj t|d�t|d�B ¡}t|dƒ t|ƒ}tj t|d�t|d�B ¡}t|ƒ}nÞtjj|d� 	¡ }g }|�rD|D ]}| |j¡ �q0tj t|d�t|d�B ¡}t|dƒ t|ƒ}tj t|d�t|d�B ¡}t|ƒ}g }| 
d¡jtdƒd� d	¡}|D ]}| |d
 ¡ �qºtjj|d� 	¡ }t|dd�}�nN|dk�r@|�r¼tjj||d� 	¡ }
g }|
 
d¡jtdƒd� d	¡}|D ]}| |d
 ¡ �q:tjj|d� 	¡ }t|dd�}|
�s‚t | d¡ nt | d¡ tjj|d�}t|ƒ}tjj|d�}t|ƒ}n„tjj|d�}t|ƒ}tjj|d�}t|ƒ}g }| 
d¡jtdƒd� d	¡}|D ]}| |d
 ¡ �qtjj|d� 	¡ }t|dd�}t|jdƒ}| j  d¡}| |¡}d|||d |d |d |d |dœ}t| d|ƒS )Nr   rã   z&][[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[][r¶   z<================)ÚmagazineInfos__nameÚmagazineInfos)Ztruck_countz-truck_countr   rÀ   T)r¹   rç   rè   ÚlabelsrÒ   rj   r»   r½   r¾   z$<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<rk   )rÊ  r¿   rê   rë   ZReports)rm   rÌ  rÒ   Zmagazine_labelÚmagazine_dataÚcategory_labelÚcategory_dataÚMagazineSellDetailszweb/reports/index.html)rì   rr   r{   r�   r    rq   r&   rt   ru   rš   Úvalues_listÚannotaterÉ  rÑ   rÔ   r)   rR   r   rx   r¨   r\   r[   rs   r]   r   rÃ   r.   r   rÒ   rí   r   )ry   r   r�   rÖ   rÌ  rÒ   Zmagazine_labelsrÍ  rÎ  rÏ  ÚquerysetÚid_listZdatasetrØ   rÐ  Zmagazine_querysetZmagazine_datasetZcategory_querysetZcategory_datasetZuser_querysetr¡  rÙ   rÚ   rÛ   rî   rï   rð   r   r|   r|   r}   Úreport_viewŠ  sö    










(





ø
rÕ  c                 C   s†   | j  dd¡}|rDtj t|d�¡}|s6t | d¡ qNt | d¡ n
tj 	¡ }t
|dƒ}| j  d¡}| |¡}d||d	œ}t| d
|ƒS )Nr   rã   r@  rç   rè   rê   rë   r   )rm   Úcountrysr   zweb/country/index.html)rì   rr   r   rt   ru   r.   r   rx   r¨   rš   r   rí   r   )ry   r   rÖ  rî   rï   rð   r   r|   r|   r}   Úcountry_viewI	  s    


ýr×  c                 C   sŽ   t ƒ }| jdkrz| jd }tjj|d� ¡ }|rHt | d¡ t | jƒ}n2t | jpRd ƒ}| 	¡ rz| 
¡  t | d¡ tdƒS d|i}t| d|ƒS )	Nra   r	   r   úCountry already exists.ú Data has been saved successfullyú/user/dashboard/country_view/rn   zweb/country/add.html)r:   ro   ra   r   rt   ru   r   r   rx   rp   rž   r¨   r   r   )ry   rn   Úcountry_namer“   r   r|   r|   r}   Úadd_country_view^	  s    

rÜ  c                 C   s*   t jj|d�}| ¡  t | d¡ tdƒS )Nr¥   r)  rÚ  )r   rt   rr   r›   r   r¨   r   )ry   r    r“   r|   r|   r}   Údelete_countrys	  s    rÝ  c                 C   s¢   t |dƒ tjj|d� ¡ }t| jp&d |d�}t| jp8d |d�}tjj|d� 	¡  
d¡}| jdkr†| ¡ r†| ¡  t | d¡ tdƒS |||||d	œ}t| d
|ƒS )Nz---------------------------r¥   rý   ©r’   ré   ra   z"Data has been updated successfullyrÚ  )rn   Úsubscription_formr   Ú	countryidÚstuúweb/country/edit.html)rq   r   rt   ru   rv   r9   ra   rD   r   rš   rÑ   ro   rp   rž   r   r¨   r   r   )ry   r    r“   rn   rß  rá  r   r|   r|   r}   Úedit_country_viewz	  s    

rã  c                 C   s†  t jj| jd d� ¡ }t|jdƒ tƒ }| jdk�rr| jd }t	jj||d� 
¡ }|rö|dkr|t | d¡ td	|j› �ƒS t| jp†d ƒ}| ¡ rÔ| ¡ }t	jj|jd�j|jd
� t | d¡ td	| jd › �ƒS t | d¡ td	| jd › �ƒS n|t| j�pd ƒ}| ¡ �rR| ¡ }t	jj|jd�j|jd
� t | d¡ td	| jd › �ƒS t | d¡ td	| jd › �ƒS d|i}t| d|ƒS )Nrà  r¥   z==========================ra   rE  ©r’   rE  ZBuyú Only one time rent is applicableú"/user/dashboard/edit_country_view/rÞ  rÙ  zalready exists.rn   râ  )r   rt   ru   ra   rv   rq   r    rD   ro   r   r   r   rx   r   rp   rž   rŸ   r¨   r   )ry   r“   rn   rE  ÚsubsÚstr   r|   r|   r}   Úsubscription_sub_via_country‰	  s8    

ré  c                 C   s8   t jj|d�}|jj}| ¡  t | d¡ td|› �ƒS )Nr¥   r)  ræ  )	r   rt   rr   r“   r    r›   r   r¨   r   )ry   r    rç  r“   r|   r|   r}   Údelete_country_view¬	  s
    rê  c           
      C   sª  t jj|d� ¡ }|jj}|jj}t|dƒ t| j	p6d |d�}| j
dk�r”| j	d }t jj|dd� ¡ }t jj||d� ¡ }|�rNt|jdƒ |j|krÞ| ¡ rÂ| ¡  t | d	¡ td
|› �ƒS t | d¡ td|› �ƒS nn|j|k�r2| ¡ �r| ¡  t | d	¡ td
|› �ƒS t | d¡ td|› �ƒS nt | d¡ td|› �ƒS nF| ¡ �rz| ¡  t | d	¡ td
|› �ƒS t | d¡ td|› �ƒS ||dœ}	t| d|	ƒS )Nr¥   z6country name..........................................rý   ra   rE  ZRenträ  z1++++++++++++++++++++++++++++subs+++++++++++++++==r  ræ  zEnter valid data.z+/user/dashboard/edit_subscriptiontype_view/rå  )rn   rà  z"web/country/edit_subscription.html)r   rt   ru   rv   r“   r    r	   rq   rD   ra   ro   rp   rž   r   r¨   r   rx   r   )
ry   r    r   r“   rÐ   rn   rE  rç  Zsubs1r   r|   r|   r}   Úedit_subscriptiontype_view´	  sF    





rë  c                 C   s¬   | j  dd¡}tƒ }|rbtt|ƒdƒ tj t|d�t|d�B ¡}|sTt	 
| d¡ qrt	 | d¡ ntj ¡  d¡}t|d	ƒ}| j  d
¡}| |¡}d|||dœ}t| d|ƒS )Nr   rã   r?  )Zsubscription_type__icontains)Zcountry__name__icontainsrç   rè   ré   rê   rë   r®  )rm   rÍ   r   Úcountry_formúweb/subscription/index.html)rì   rr   r;   rq   rE  r   rt   ru   r.   r   rx   r¨   rš   rÑ   r   rí   r   )ry   r   rì  r«  rî   rï   rð   r   r|   r|   r}   Úsubscription_viewâ	  s$    

ürî  c                 C   s&  t jj|d� ¡ }|j}tƒ }| jdk�r| j d¡}t	jj|d� 
¡ }t jj|jd� 
¡ }g }|D ]}	| |	j¡ qdd}
|D ]`}t|jƒ|kr”q~q~t ƒ }|j|_|j|_|j|_|j|_|j|_|j|_|j|_| ¡  d}
q~|
dkrüt | d¡ td	ƒS t | d
¡ td	ƒS d|dœ}t| d|ƒS )Nr¥   ra   r	   ©Zname__in©Úsubscription_typer   rf   rõ   r¤  rØ  r   )rm   rì  rí  )r   rt   ru   rv   rñ  r;   ro   ra   rm  r   rš   rÔ   r’   r^  r    ÚdaysÚpriceÚdescriptionrE  Údiscountrž   r   r¨   r   r¶  r   )ry   r    rç  rE  rì  Ú	countriesrÒ   Úsubs_countryÚcontry_listr“   rÐ   rØ   Ú
subscrtionr   r|   r|   r}   Úadd_other_countryû	  s>    
rú  c                 C   s  g }t ƒ }tƒ }tj ¡  d¡}| jdk�rð| jd }| jd }| jd }t|ƒt|ƒ d }t|ƒt|ƒ }	t|	ƒt	|ƒ }
t | j| j
ƒ}t| jƒ}| ¡ �rä|d j}tjj|d� ¡ }g }|D ]}| |j¡ qÄ| jd	 }tjj|d
� ¡ }g }|D ]}| |j¡ qúd}tdd„ |D ƒƒ�rÖ|D ]x}t	|jƒ|k�rB�q(n\tƒ }| jd	 |_| jd |_| jd |_| jd |_|
|_| jd |_|j|_| ¡  d}�q(|dk�rÀt | d¡ tdƒS t | d¡ tdƒS nt | d¡ nt | d¡ d||||dœ}t| d|ƒS )Nré   ra   ró  rò  rõ  éd   r	   rï  rñ  rð  r   c                 s   s   | ]}|  ¡ p| ¡ V  qd S r…   r†   rˆ   r|   r|   r}   r‹   C
  s     z(add_subscription_view.<locals>.<genexpr>rô  rf   rõ   r¤  z,Country already exists on this subscription.z /user/dashboard/addsubscription/z$Subscription name must be character.úData not validr   )rm   rß  rn   r“   rç  zweb/subscription/add.html)rD   r;   r   rt   rš   rÑ   ro   ra   rF  r^  r%  rp   rÒ   r   ru   rÔ   r    r’   rñ  rò  ró  rô  Úper_month_pricerõ  rž   r   r¨   r   r¶  rx   r   )ry   Zcountry_listrn   rì  r«  Ú
subs_priceÚ	subs_daysÚsubs_discountÚsubs_disc_perÚsubs_disc_per_monthÚsubs_per_monthZ
country_forÒ   Zc_listrØ   Z	subs_namer÷  rø  r“   rÐ   rù  r   r|   r|   r}   Úadd_subscription_view
  s`    








r  c                 C   s  t jj|d� ¡ }t|dƒ t| jp&d |d�}| jdk�r| jd }| jd }| jd }t|ƒt|ƒ d }t|ƒt|ƒ }t|ƒt	|ƒ }	| 
¡ rê|	|_| ¡  t| jd	 ƒ | jd	 |j_| ¡  t| jd	 d
ƒ t | d¡ tdƒS t | d¡ td|› �ƒS |||dœ}
t| d|
ƒS )Nr¥   z------------------rý   ra   ró  rò  rõ  rû  Zcntryz<<<<<<<<<<<<<<<<<<<<<<<<<<z"Data has been updates successfullyr¤  rü  z+/user/dashboard/editsubscriptioncommission/)rn   rß  r«  r¥  )r   rt   ru   rv   rq   rC   ra   ro   rF  r^  rp   rý  rž   r“   r    r   r¨   r   rx   r   )ry   r    r«  rn   rþ  rÿ  r   r  r  r  r   r|   r|   r}   Ú!edit_subscription_commission_viewc
  s.    



r  c              	   C   sz  | j j}| j dd¡}g }tƒ }| jdkr t| jƒ}| ¡ r~| ¡ }t	j
j|jd�j| j jd� t	j
j|jd�j| j jd� n"t| jƒ}t | d¡ t|jdƒ | j jd	k�r8|�rxtj
 t|d
�t|d�B ¡ d¡}t|dd| id�}|j}g }|D ] }|d röt|dƒ | |¡ qöd}	|�rX|D ].}|d d k�r<�q&|	|d 7 }	t|	dƒ}	�q&nd}	t	j
jdd� ¡ }
d}d}n¼tj
 ¡  d¡}t|dd| id�}|j}g }|D ]$}|d �r¨t|dƒ | |¡ �q¨d}	|�r|D ].}|d d k�rò�qÜ|	|d 7 }	t|	dƒ}	�qÜnd}	d}d}t|ƒ t	j
jdd� ¡ }
�n | j jdk�rÂ|�r”tj
j|d� ¡ }g }|�r€|D ]}| |j¡ �qltj
 t|d
�t|d�B t|d�t|d�B ¡ d¡}t|dd| id�}|j}g }|D ]$}|d �rÔt|dƒ | |¡ �qÔd}	|�r:|D ].}|d d k�r�q|	|d 7 }	t|	dƒ}	�qnd}	t	j
 t| j jd�tdd�@ ¡ ¡ }t|ƒ t|jddd�ƒ}|	| }t|ƒ d}
�q8tj
j|d� ¡ }g }|�rÈ|D ]}| |j¡ �q´tj
 t|d�t|d�B ¡ d¡}t|dd| id�}|j}g }|D ]$}|d �r
t|dƒ | |¡ �q
d}	|�rp|D ].}|d d k�rT�q>|	|d 7 }	t|	dƒ}	�q>nd}	t	j
 t| j jd�tdd�@ ¡ ¡ }t|jddd�ƒ}|	| }t|ƒ d}
�nv| j jdk�r8|�rŠtj
jt|d
�|d� d¡}t|dd| id�}|j}g }|D ]$}|d �rt|dƒ | |¡ �qd}	|�rx|D ].}|d d k�r\�qF|	|d 7 }	t|	dƒ}	�qFnd}	d}d}d}
n®tj
j|d� d¡}t|dd| id�}|j}g }g }|D ]$}|d �rÂt|dƒ | |¡ �qÂd}	|�r(|D ].}|d d k�r�qö|	|d 7 }	t|	dƒ}	�qönd}	d}d}d}
t|dƒ}| j d ¡}|  |¡}||	||||||
d!œ}t!| d"|ƒS )#Nr   rã   ra   r¥   ©rÖ   )rÕ   zSomething went wrong.z<<<<<<<<Errorsr¶   r@  rÂ  r·   Try   r¸   r…  z<<<<<<<<<<<<<<<<<,r   Zadmin_amountrg   F)rx  rj   r»   )Zusers_id__inrÂ   Úwithdrawal_amount)ÚflatZpublisher_amountrk   rÆ  rë   )Zpurchase_info_groupsrÏ   Úwithdrawal_formr   r  Úwallet_amountÚrequestsÚpending_requestszweb/reports-new/demo.html)"r{   r    rì   rr   rJ   ro   ra   rp   rž   r-   rt   ru   rŸ   r�   r   rx   rq   r]  r)   r.   rÑ   rO   rÒ   rÔ   rÓ   rÐ   rš   r   rÃ   ÚsumrÑ  r   rí   r   )ry   rÖ   r   r  r	  Zform_idZpurchase_info_groupZpurchase_info_listrØ   rÏ   r  r  r
  rÙ   rÚ   rÛ   rî   rï   rð   r   r|   r|   r}   Úreport_tebular_view†
  sD   


"


4

$"

$





   ýr  c                 C   s€  | j  dd¡}| j  d¡}| j  d¡}tjj|d� ¡ }| jjdk�r¼|rÈtjjt	|d�t	|d�B t	|d	�B t	|d	�B t	|d
�B |d� 
¡ }t|dd| id�}|j}|r¶t | d¡ nt | d¡ d}nð|�r6|�r6tjj|||d� 
¡ }t|dd| id�}|j}d}|�r(t | d|› d|› d�¡ nt | d¡ n‚tjj|d� ¡ }t|dƒ tj ¡ t d¡ }tj ¡ t d¡ }	t|d|	ƒ tjj|	||d� 
¡ }t|dd| id�}|j}d}�n„| jjdk�r@|�rPtjjt	|d�t	|d�B t	|d	�B t	|d	�B t	|d
�B |d� 
¡ }t|dd| id�}|j}d}|�rBt | d¡ nt | d¡ nð|�r¾|�r¾tjj|||d� 
¡ }t|dd| id�}|j}d}|�r°t | d|› d|› d�¡ nt | d¡ n‚tjj|d� ¡ }t|dƒ tj ¡ t d¡ }tj ¡ t d¡ }	t|d|	ƒ tjj|	||d� 
¡ }t|dd| id�}|j}d}|j}
t|dƒ}| j  d¡}| |¡}|||
|dœ}t| d|ƒS ) Nr   rã   Údate_oneÚdate_twor¥   r¶   rÂ  rÃ  rÄ  rÅ  )rË  Try   r¸   zData Found Successfuly between.zNo Data Found.r   )Úcreate_on__gteÚcreate_on__lterË  zData Found Successfuly between z to Ú.zNo records Found.z<<<<<<<<<<<<<<<<<<<<<<rf   éâÿÿÿú<----------------->)rj   rk   rÆ  rë   )rÇ  rÏ   r…  r   z+web/reports-new/per_magazine_sell_list.html)rì   rr   r)   rt   ru   rv   r{   r�   r&   r.   rš   rS   rÒ   r   r¨   rx   rq   r   ÚdateÚtodayr   r	   r   rí   r   )ry   r    r   Ú
date_firstÚdate_secondrn  r×   rÏ   Ú
date_todayÚdate_30_day_beforer…  rî   rï   rð   r   r|   r|   r}   Úper_magazine_report_listh  s„    B
B
	

ür  c                 C   sÌ  | j  dd¡}| j  d¡}| j  d¡}| jjdk�rÂtj ¡ t d¡ }tj ¡ t d¡ }t|d|ƒ | j	d	k�rf| j
d
 }| j d¡}| j
d }| j
d }	t||||	ƒ tjj|	d� ¡ }
||
_||
_||
_|
 ¡  |
jj}|
jjd |
jj }|
j}|dk�r
d}n|dk�rd}t|ƒ ||||dœ}tdƒ t|ƒ ¡  t | d|› d|
j› d�¡ tdƒS |�r†tj t|d�¡ d¡}n:|�rª|�rªtjj||d� d¡}ntjj||d� d¡}nÐ| jjdk�r’tj ¡ }tj ¡ t d¡ }t|d|ƒ |�r"tjjt|d�| jj d� d¡}np|�rL|�rLtjj||| jj d� d¡}nFtj ¡ }tj ¡ t d¡ }t|d|ƒ tjj||| jj d� d¡}t!|dƒ}| j  d ¡}| "|¡}||||d!œ}t#| d"|ƒS )#Nr   rã   r  r  r¶   rf   r  r  ra   rv  Úadmin_imagerR  Z
request_idr¥   r¬   Ú1rr  Ú0rƒ  ©r”   r	   Úamountrv  r£   z	You just z's withdrawal request.ú*/user/dashboard/report/withdrawalrequests/r@  ré   )Úcreated_on__gteÚcreated_on__lterj   r  )r#  r$  rÖ   rÆ  rë   )Zwithdrawlistsr   r  r  z&web/reports-new/withdrwal_request.html)$rì   rr   r{   r�   r   r  r  r   rq   ro   ra   r%  r-   rt   ru   rv   r  rR  rx  rž   r   r‚   rƒ   r  rZ   r¡   r   r¨   r	   r   r.   rÑ   r    r   rí   r   )ry   r   r  r  r  r  rv  r  rR  r    Zrequest_datar”   r	   r!  r£   Zwithdrawlistrî   rï   rð   r   r|   r|   r}   Úwithdrawal_requestÇ  sj    





"


r%  c                 C   st   t jj|d� ¡ }d|_|jj}|jjd |jj }|j	}d}||||dœ}t
dƒ t|ƒ ¡  t | d¡ tdƒS )	Nr¥   Tr¬   rr  r   r£   úRequest approved successfully.r"  )r-   rt   ru   rv   rx  r{   r   r‚   rƒ   r  rq   rZ   r¡   r   r¨   r   ©ry   r    Zrequest_to_apporver”   r	   r!  rv  r£   r|   r|   r}   Úapprove_withdrawal_request
  s    r(  c                 C   s|   t jj|d� ¡ }d|_| ¡  |jj}|jjd |jj	 }|j
}d}||||dœ}tdƒ t|ƒ ¡  t | d¡ tdƒS )	Nr¥   Fr¬   rƒ  r   r£   r&  r"  )r-   rt   ru   rv   rx  rž   r{   r   r‚   rƒ   r  rq   rZ   r¡   r   r¨   r   r'  r|   r|   r}   Údisapprove_withdrawal_request  s    r)  )ÚHttpResponse)ÚPermissionDeniedc                 C   s¼   |j }|jj|jj }dd„ |D ƒ}tdd�}d|d< tj|dd�}| |¡ |D ]d}g }|D ]L}	t||	ƒ}
t	|
ƒr”z|
ƒ p~d	}
W n   d
}
Y nX |
d kr d	}
| 
|
¡ q^| |¡ qR|S )Nc                 S   s   g | ]
}|j ‘qS r|   r   )r‰   Úfieldr|   r|   r}   Ú
<listcomp>5  s     z download_csv.<locals>.<listcomp>útext/csv©Úcontent_typez!attachment; filename="export.csv"zContent-Dispositionú;)Ú	delimiterrã   zError retrieving value)ÚmodelÚ_metaÚfieldsÚmany_to_manyr*  ÚcsvÚwriterZwriterowÚgetattrÚcallablerÔ   )ry   rÓ  r3  Úmodel_fieldsÚfield_namesÚresponser8  rØ   Úvaluesr,  Úvaluer|   r|   r}   Údownload_csv1  s*    



r@  c                 C   s    t | tj ¡ ƒ}t|dd�}|S )Nr.  r/  )r@  r&   rt   rš   r*  )ry   rÒ   r=  r|   r|   r}   Ú
export_csvN  s    rA  c                 C   sø  | j  dd¡}| j  d¡}| j  d¡}| jjdk�r
|r tjjt|d�t|d�B t|d�B t|d	�B d
d� ¡  	d¡}t
|dƒ |r’t | d¡ nt | d¡ nf|rä|rätjj||d
d� ¡  	d¡}|rÖt | d¡ nt | d¡ n"tjjd
d� ¡  	d¡}t
|dƒ �n¸| jjdk�rÖ|�rÖtjj| jjd� ¡ }g }|�rV|D ]}| |j¡ �qBtjjt|d�t|d�B t|d�B t|d	�B t| jjd�t|d�B d
d� ¡  	d¡}t
|dƒ |�rÈt | d¡ nt | d¡ nþ|�rn|�rntjj| jjd� ¡ }g }|�r|D ]}| |j¡ �qtjjt| jjd�t|d�B ||d
d� ¡  	d¡}|�r`t | d¡ nt | d¡ nftjj| jjd� ¡ }g }|�r¦|D ]}| |j¡ �q’tjjt| jjd�t|d�B d
d� ¡  	d¡}nì| jjdk�rÂ|�r`tjjt|d�t|d�B t|d�B t|d	�B t| jjd�d
d� ¡  	d¡}t
|dƒ |�rRt | d¡ nt | d¡ nb|�rª|�rªtjj||d
| jjd� ¡ }|�rœt | d¡ nt | d¡ ntjjd
| jjd� ¡ }t|dƒ}| j  d¡}	| |	¡}
|
|dœ}t| d|ƒS )Nr   rã   r  r  r¶   rÅ  rÂ  rÃ  )Zdelivery_location__icontainsT)Úis_hard_copyr·   z<<<<<<<<<<<<<<<<<<<zData found successfully.zNo Data found.)r  r  rB  rj   r»   r¾   r½   rk   )r  r  rB  r¿   )rB  r¿   rÆ  rë   )Údelivery_datar   zweb/delivery/index.html)rì   rr   r{   r�   r&   rt   ru   r.   rš   rÑ   rq   r   r¨   rx   r   r    rÔ   rÃ   r   rí   r   )ry   r   r  r  rC  rÙ   rÚ   rÛ   rî   rï   rð   r   r|   r|   r}   ÚDelivery_ViewV  s~    >
T
20J



rD  c                 C   sd   t jjd|d� ¡ }d|_| ¡  |jj}|jjd |jj	 }||dœ}t
dƒ t|ƒ ¡  tdƒS )NT)rB  r    r¬   )r”   r	   r£   z/user/dashboard/delivery/)r&   rt   ru   rv   Úis_deliveredrž   r©   r   r‚   rƒ   rq   rT   r¡   r   )ry   r    Zdelivery_requestr”   r	   r£   r|   r|   r}   ÚApprove_Delivery¬  s    
rF  c                 C   s   t | ddd�S )Nzweb/404.htmli”  )rv  )r   )ry   Ú	exceptionr|   r|   r}   Ú	error_404º  s    rH  )ÜZcurses.asciir   r   r   r   Úgenericpathr   Úmultiprocessingr   Úoperatorr   Úunicodedatar	   Zxmlrpc.clientr
   r`  Údjango.confr   Údjango.contribr   Údjango.contrib.authr   r   r   r   Údjango.contrib.auth.decoratorsr   Údjango.contrib.sites.shortcutsr   Údjango.core.exceptionsr   Údjango.shortcutsr   r   Údjango.core.paginatorr   Údjango.utilsr   Údjango.utils.encodingr   Údjango.utils.httpr   Údjango.contrib.auth.hashersr   Újmespathr   Zbase.modelsr   r   r   r   Úmagazine.utilsr    Zmagazineapp.modelsr!   r"   r#   r$   r%   r&   r'   r(   r)   r*   r+   r,   r-   Údjango.db.modelsr.   Z	web.formsr/   r0   r1   r2   r3   r4   r5   r6   r7   r8   r9   r:   r;   r<   r=   r>   r?   r@   rA   rB   rC   rD   rE   rF   rG   rH   rI   rJ   rK   Z	web.emailrL   rM   Zweb.serializersrN   rO   rP   rQ   rR   rS   Z
web.threadrT   rU   rV   rW   rX   rY   rZ   Z	web.utilsr[   r\   r]   rs   Údjango.utils.cryptor^   r_   Údjango.db.models.functionsr`   r~   r¤   r«   r°   r²   r´   rÜ   râ   rñ   rû   r   r  r  r  r  r  r  r  r  r  r  r  r  r  r&  r'  r*  r-  r6  r7  r8  r:  r<  r=  r>  rH  rj  rp  ry  rz  r  r€  r‚  r„  r†  r‡  r�  r‘  r’  r”  r™  rš  r›  r¢  r£  r¦  r§  r¬  r­  r¯  r¹  rº  r¿  rÀ  rÁ  rÈ  rÉ  rÕ  r×  rÜ  rÝ  rã  ré  rê  rë  rî  rú  r  r  r  r  r%  r(  r)  Údjango.httpr*  r7  r+  r@  rA  rD  rF  rH  r|   r|   r|   r}   Ú<module>   s¨  <x $l6
a
"

/

	


/



	
.
0



	
(





(



(

>
 ;
H






&
'
$
#



!

6
=
	


1
-

	
	

 
 ?




"

-

#
C
"
 b
^
B




U
