o eOj @s<ddlZddlmZmZmZddlmZddlmZm Z m Z m Z ddl m Z ddlmZddlmZddlmZmZmZmZdd lmZmZeZd Zd&d edededefddZed d'dedededefddZ eddedefddZ!e"ded fdeded efd!d"Z#e"d#dedefd$d%Z$dS)(N) APIRouterRequestFormRedirectResponse)selectfuncor_desc) selectinload)render)AsyncSessionFactory)User AdminAction MovieViewMovie)ban_user unban_usersuccessurlmsgtype_returncCs0d|vrdnd}t||d|d|ddS)N?&zmsg=z&type=i.) status_coder)rrrsepr@/var/www/www-root/data/www/ai-bot.pdev.uz/admin/routers/users.py _redirects r!allrequestpageqfilterc s|dt}t4IdH}ttttj}|rUd|d}zt|}|t tj |ktj |tj |}WntyT|t tj |tj |}Ynw|dkrb|tjdk}n |dkrn|tjdk}|tt|IdH} | } ||ttjt|IdH} t| } WdIdHn 1IdHswYt|d| | || rt | tnd||dS) Nr"%bannedTactiveFzusers/list.html)userstotalr% total_pagesr&r')!PER_PAGEr rroptionsr admin_profileintwherer telegram_id full_nameilikeusername ValueError is_bannedexecutercount select_fromsubquery scalar_oneorder_byr registered_atlimitoffsetlistscalarsr#r mathceil) r$r%r&r'rAsessionbasestidtotal_rr,users_rr+rrr user_listsB    " (rLz/{telegram_id}r3c s,t4IdHz}|tttj|kttjIdH}| }|s5t dddWdIdHS|tt t  t t jt jkt j|jktt jdIdH}dd|D}|ttt j|jkIdH}|}WdIdHn 1IdHswYt|d|||dS) Nz/usersFoydalanuvchi topilmadidangercSsg|]}|j|jfqSr)rr).0rowrrr Mszuser_detail..zusers/detail.html)user recent_views total_views)r r9rrr2r3r/r r0scalar_one_or_noner!rrjoinmovie_ididuser_idr>r viewed_atr@r#rr:r=r ) r$r3rFuser_rrSviews_rrT view_count_rrUrrr user_detail:s6        (r_z/{telegram_id}/banreasonc s|jj}t4IdH7}t|||pdt|dIdH}|r9|tt|ddt|d|id|IdHWdIdHn 1IdHsIwY|rVd|dnd}t d |||rcd Sd S) NzAdmin tomonidan ban qilindisubuser_banr`)admin_telegram_id action_type target_iddetailsFoydalanuvchi z ban qilindirM/users/rrN) stateadminr rr1addrstrcommitr!)r$r3r`rjrFokrrrr rbXs$    ( rbz/{telegram_id}/unbanc s|jj}t4IdH,}t||IdH}|r.|tt|ddt|d|IdHWdIdHn 1IdHs>wY|rKd|dnd}t d|||rXdSd S) Nra user_unban)rcrdrergz ban olib tashlandirMrhrrN) rirjr rrkrr1rlrmr!)r$r3rjrFrnrrrr rojs ( ro)rr)r"rr#)%rDfastapirrrfastapi.responsesr sqlalchemyrrr r sqlalchemy.ormr admin.responsesr bot.database.connectionr bot.database.modelsrrrrbot.database.crud.userrrrouterr.rlr!getr1rLr_postrbrorrrr s(    #