U
    Ž7þb(  ã                   @   sŠ   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mZ d dlmZmZmZ eƒ Zdd	„ Zd
d„ Zdd„ Zdd„ ZdS )é    )Úlabel)Úcount)Úcheck)Úget_user_model)ÚCount)ÚCountryÚSubPublisherUser)ÚMagazineCommissionInfoÚMagazineOrderinfoÚMagazinePurchaseInfoc                 C   sœ  �zzt jj| d� ¡ }|jdkr¢zbtjj|d� ¡ }|rp|j}tjj|d� ¡ }|rb|j}|W W S d}|W W S nt	dƒ W W dS W n tj
k
rœ   Y W dS X �nØ|jdk�r
z:|j}tjj|d� ¡ }|rÚ|j}|W W S d}|W W S W n tj
k
�r   Y W dS X �np|jdk�rzt jj|d� ¡ }|�rlt	|d	ƒ |jdk�r¦tjj|jd� ¡ }|�rf|jW S |j}tjj|d� ¡ }	|	�rž|	j}
|
�r–|
W S W dS nW dS nÄ|jdk�rdz’tjj|d� ¡ }|�r:|j}tjj|d� ¡ }|�rô|jW W S |j}tjj|d� ¡ }	|	�r0|	j}
|
�r&|
W W S W W dS nW W dS nW W dS W n tj
k
�r`   Y W dS X nW dS nt	d
ƒ W dS W n t j
k
�r–   Y dS X d S )N)Úidé   )Úusers)Úuser_idé#   z------------------é   )é   é   z<<<<<<<<<<<<<<<<<<<<<<UserzNo User<<<<<<<<<<<<<<)ÚUserÚobjectsÚfilterÚlastÚroles_idr   Úcreated_by_idr	   Úmagazine_commissionÚprintÚDoesNotExistr   Ú
country_idr   Ú
commission)Úactive_userÚuseridÚ
userrecordZsubpubliserZ
publiseridZcommission_infor   Z
user_checkÚ	countryidZcountry_dataZcheck_commission_in_country© r#   úS/var/www/html/staging.mfahmagazine.net/magazine_api/magazine_web_admin/web/utils.pyÚget_mgn_commision   sˆ    






r%   c                 C   s„   g }g }g }dddg}| D ]D}|j dkr4| |¡ q|j dkrJ| |¡ q|j dkr| |¡ qt|ƒt|ƒt|ƒg}||dœ}|S )Nz	Sub AdminÚ	PublisherzSub Publisherr   r   r   ©ÚlabelsÚdata)r   ÚappendÚlen)Úuser_querysetZ	sub_adminÚ	publisherÚsub_publisherr(   Úqr)   Údatasetr#   r#   r$   Úget_UserCountg   s     



þr1   c                 C   sf   g }g }| rX|   d¡jtdƒd� d¡d d… }|D ] }| |d ¡ | |d ¡ q4n ||dœ}|S )NÚmagazineInfos__name©Útruck_countú-truck_counté   r   r   r'   )Úvalues_listÚannotater   Úorder_byr*   )Úmagazine_querysetÚmagazine_labelsÚmagazine_dataZmgnfÚrowr#   r#   r$   Úget_MostSellMagazines~   s    $þr>   c                 C   sn   g }g }| r`|   d¡jtdƒd� d¡d d… }t|ƒ |D ] }| |d ¡ | |d ¡ q<n ||dœ}|S )NZ/magazineInfos__magazine_category__category_namer3   r5   r6   r   r   r'   )r7   r8   r   r9   r   r*   )Úcategory_querysetr(   r)   Z
filterdatar=   Úcategory_datasetr#   r#   r$   ÚTopMegazineCategories”   s    $þrA   N)ZcProfiler   Ú	itertoolsr   Ztabnannyr   Údjango.contrib.authr   Údjango.db.modelsr   Úbase.modelsr   r   Úmagazineapp.modelsr	   r
   r   r   r%   r1   r>   rA   r#   r#   r#   r$   Ú<module>   s   [