
    #Aj                         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
mZmZmZmZmZmZmZ  e       Zej'                  d      defd       Zy	)
    )	APIRouterRequest)AsyncSession)render)AsyncSessionFactory)get_total_usersget_total_moviesget_total_viewsget_new_users_countget_active_users_countget_banned_users_countget_daily_registrationsget_top_moviesz
/dashboardrequestc                   K   t               4 d {   }t        |       d {   }t        |       d {   }t        |       d {   }t	        |d       d {   }t	        |d       d {   }t        |d       d {   }t        |       d {   }t        |d       d {   }	t        |d       d {   }
d d d       d {    	D cg c]  }|d   	 }}|	D cg c]  }|d   	 }}t        | d||
	      S 7 7 7 7 7 7 7 7 7 u7 b7 T# 1 d {  7  sw Y   dxY wc c}w c c}w w)
N   )days      
   )limitr   zdashboard/index.html)
total_userstotal_moviestotal_views	new_todaynew_week	active_7dbanned
reg_labelsreg_data
top_movies)
r   r   r	   r
   r   r   r   r   r   r   )r   sessionr   r   r   r   r   r   r   	reg_chartr!   rr   r    s                 HC:\Users\koklo\Documents\pet_projects\kinoBot\admin\routers\dashboard.py	dashboardr&      s<    "$$+G44-g66+G44-gA>>	,W1==0qAA	-g661'CC	)'<<
 %$ !**	1!A$	J*'(i!iH(!  %464>=A6C< %$$$ +(s   EDED-DD-DD-
DD-D D-4D!5D-	D#
D-D%D-1D'2D-D)D-ED+EE+E1E=ED-D-D-D-!D-#D-%D-'D-)D-+E-D?3D64D?;EN)fastapir   r   sqlalchemy.ext.asyncior   admin.responsesr   bot.database.connectionr   bot.database.crud.analyticsr   r	   r
   r   r   r   r   r   routergetr&        r%   <module>r0      sM    & / " 7	 	 	 
 LW  r/   