o <6jу@sЖddlmZmZmZddlmZmZmZddlmZm Z m Z ddlmZddl mZmZmZmZmZdedefdd ДZd'dededefdd ДZd(dededefddДZdedefddДZdedeeeffddДZ d)dededeeeeffddДZd*dededefddДZ d+dededeedeeeeffdd ДZd)dededeeeffd!d"ДZdedefd#d$ДZ dedefd%d&ДZ!dS),щ)┌datetime┌ timedelta┌timezone)┌List┌Optional┌Tuple)┌func┌select┌and_)┌AsyncSession)┌User┌Movie┌ MovieView┌MandatoryChannel┌Language┌session┌returnc├є&Б|аttаtjбГбIdH}|абSйN)┌executer r┌countr┌id┌ scalar_oneйr┌resultйr·H/var/www/www-root/data/www/ai-bot.pdev.uz/bot/database/crud/analytics.py┌get_total_usersєАrщ┌daysc├єHБtаtjбt|dН}|аttаt j бГаt j|kббIdH}|а бS)z!Oxirgi N kunda yangi userlar soniйr N)r┌nowr┌utcrrr rrrr┌where┌ registered_atrйrr ┌sincerrrr┌get_new_users_countєА r)щc├r!)z Oxirgi N kunda faol userlar sonir"N)rr#rr$rrr rrrrr%┌last_active_atrr'rrr┌get_active_users_countr*r-c├s2Б|аttаtjбГаtjdkббIdH}|абSйNT) rr rrrrr%┌ is_bannedrrrrr┌get_banned_users_count#s А r0c├s<Б|аttjtаtjбГаtjббIdH}ddД|абDГS)zTillar bo'yicha user taqsimotiNcSsi|] }|dj|dУqS)rr)┌valueй┌.0┌rowrrr┌ 0єz)get_users_by_language..) rr r┌languagerrr┌group_by┌allrrrr┌get_users_by_language*sА ■r:щc├sДБtаtjбt|dН}|аttаt j баdбtаt j баdбГаt j |kбаtаt j ббаtаt j бббIdH}ddД|абDГS)z.Oxirgi N kun uchun kunlik ro'yxatdan o'tishlarr"┌daterNcSsg|] }t|jГ|jfСqSr)┌strr<rr2rrr┌ Ar6z+get_daily_registrations..)rr#rr$rrr rr<rr&┌labelrrr%r8┌order_byr9r'rrr┌get_daily_registrations3sА■ ∙ rAT┌only_activec├s>БttаtjбГ}|r|аtjdkб}|а|бIdH}|абSr.) r rrr rr%┌ is_activerr)rrB┌qrrrr┌get_total_moviesFsАrEщ N┌limitc├sрБ|rCtаtjбt|dН}|аtttа t jбаdбГа t tjt jkбаtjdkt j|kбаtjбаtа t jбабба|ббIdH}n$|аttГаtjdkбаtjабба|ббIdH}ddД|абабDГSddД|абDГS)uO Eng ko'p so'ralgan kinolar. days berilsa тАФ oxirgi N kun ichida. r"┌viewsTNcSsg|]}||jfСqSr)┌ view_count)r3┌movierrrr>fsz"get_top_movies..cSsg|]}|j|jfСqSr)r rHr2rrrr>hs)rr#rr$rrr r rrrrr?┌join┌movie_idr%rC┌ viewed_atr8r@┌descrGrI┌scalarsr9)rrGr r(rrrr┌get_top_moviesNs&А· №rPc├sКБtаtjбt|dН}|аttаdt j баdбtаt j баdбГаt j |kбаtаdt j ббаtаdt j бббIdH}ddД|абDГS)u3Soat bo'yicha faollik (peak hours) тАФ oxirgi N kunr"┌hourrNcSsi|] }t|jГ|jУqSr)┌intrQrr2rrrr5wsz'get_hourly_activity..)rr#rr$rrr r┌extractrrMr?rrr%r8r@r9r'rrr┌get_hourly_activityksА■ ∙ rTc├rr)rr rrrrrrrrr┌get_total_viewszrrUc ├sрБt|ГIdHt|ddНIdHt|ddНIdHt|ddНIdHt|ddНIdHt|ddНIdHt|ГIdHt|ГIdHdЬt|ГIdHt|ГIdHt|dddНIdHt|dddНIdHt|d d НIdHt|ddНIdHdЬdЬS) zAdmin uchun to'liq statistikaNrr"r;r+)┌total┌today┌week┌month┌ active_7d┌ active_30d┌banned┌by_languageщ)rGr rF)rG)rV┌total_views┌ top_today┌top_week┌top_all_time┌hourly_activity)┌users┌movies) rr)r-r0r:rErUrPrT)rrrr┌get_full_statsБs$А°·їrf)r)r+)r;)T)rFN)"rrr┌typingrrr┌ sqlalchemyrr r ┌sqlalchemy.ext.asyncior┌bot.database.modelsrr rrrrRrr)r-r0┌dictr=r:rA┌boolrErPrTrUrfrrrr┌s@ ■ ■