U
    7b(                     @   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rzbt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rt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rdzt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   [