`iw d dl mZ ddlmZmZmZmZmZmZm Z m
Z
m Z d dl m
Z
d dl mZ d dlZddlmZ d dlmZ dd lmZ d d
lmZmZ d d lmZ d dlZd d lmZ d d
l m Z d dl m Z d dl Z d dl!m"Z" d dl#Z#d dl$Z$d dl%m&Z& d dl'Z(d dl)Z*d dl+m,Z- d dl.m/Z/ d dl0Z0d dl1Z1d dl2m3Z4 d dl5m6Z7 d dl8m.Z9 ddlm:Z: G d dejv ZzNo Image)imager urlselfobjs 2/var/www/skyplay_api_hub/ott_subscription/admin.pyr# zOTTAdmin.image_tag' s) 99 z#))-- 8H IJ J )r# Nfields)r r r! r" r' r# ) __name__
__module__ __qualname__ list_display list_filter
search_fieldsr# readonly_fields fieldsets r- r, r r " s9 IL K M
%O
U
Ir- r c e Zd ZdZdZdZdZy)OTTAggregatorAdmin)r r statusr: r r N)r/ r0 r1 r2 r3 r4
list_editabler7 r- r, r9 r9 7 s -L K$M Mr- r9 c e Zd ZdZdZdZy)OTTPlanGroupAdmin)r
group_code platform_id description)r r@ platform_id__name)rA N)r/ r0 r1 r2 r4 r3 r7 r- r, r? r? @ s GL?M"Kr- r? c x e Zd ZdZdZdZdZd Zde_ d Z de _
d e _ d
Z d e _ fd Z xZ
S )
OTTPlanAdmin) get_platformr r
plan_groupvalidity_monthsr: get_ottspriceflexible_plan_flag)rA r: rK rH rG )r r rC rH )ottsc dj |j j D cg c] }|j c} S c c}w )N, )joinrL allr )r* r+ otts r, rI zOTTPlanAdmin.get_ottsO s- yychhlln=s#((=>>=s AOTTsc . |j j S N)rA r r) s r, rF zOTTPlanAdmin.get_platformT s ###r- rC Platformc |j S rT )rJ r) s r, rJ zOTTPlanAdmin.priceZ s yyr- Pricec |j dk( r#t j j d |d< t | ||fi |S )NrA activer; queryset)r r objectsfiltersuperformfield_for_foreignkey)r* db_fieldrequestkwargs __class__s r, r^ z%OTTPlanAdmin.formfield_for_foreignkey_ sD ==M )!.!6!6!=!=X!=!NF: w/'LVLLr- )r/ r0 r1 r2 r3 r4 filter_horizontalrI short_descriptionrF admin_order_fieldrJ r^
__classcell__rb s @r, rE rE H sV JLdKLM!?!'H $%8L"%/L" %EM Mr- rE c 8 e Zd ZdZdZdZdZdZ fdZd Z xZ
S )SkylinkPlanAdmin)r r amountr: bandwidth_verified_flag bandwidthjiohotstar_flag server_type)rn r: rk rl rm ) ott_plans)r r rl rj z3ott_subscription/admin/skylinkplan_change_list.htmlc t | }t d| j j | j
d g}||z S )Nz graph-view/zskylinkplan-graphr% )r] get_urlsr
admin_site
admin_view
graph_viewr* urls custom_urlsrb s r, rq zSkylinkPlanAdmin.get_urlso sD w ! : :4?? KRe f
T!!r- c
t j j j dd }t d }|D ] }|j
r/|j xs d}|j j }nd}t j d|j j }|r|j d nd}|| | j |j t |j |j d d
d
t# t% |j' fd
} | D ]/ }
t# t% | |
j'
fd
| |
< 1 | dd} t) |d| S )Nrl r c t t S rT )r listr7 r- r, z-SkylinkPlanAdmin.graph_view..y s k$&7 r- Unknown Other Plans(\d+)r Others)r rj rm c | dk( r t d S t j d| }|rt |j d S t d S )Nr} infr~ r )floatresearchintgroup)bwms r, bandwidth_sort_keyz7SkylinkPlanAdmin.graph_view..bandwidth_sort_key sA ]" U|# (B'A&'3qwwqz? 9U5\ 9r- c N t | S # t $ r t d cY S w xY w)Nr )r
ValueErrorr )ps r, price_sort_keyz3SkylinkPlanAdmin.graph_view..price_sort_key s)
$1v
$ U|#
$s
$$c | d S Nr r7 )xr s r, r{ z-SkylinkPlanAdmin.graph_view.. s DVWXYZW[D\ r- )keyc | d S r r7 )r r s r, r{ z-SkylinkPlanAdmin.graph_view.. s WefghifjWk r- z2SkylinkPlan Roadmap View (Grouped by Price Prefix))roadmaptitlez-ott_subscription/admin/skylinkplan_graph.html)r r[ rP order_byr rk rl stripr r matchr r appendr rj rm dictsorteditemsr )r* r` all_plansr planraw_bwrl r price_prefixsorted_roadmapr contextr r s @@r, rt zSkylinkPlanAdmin.graph_viewv sS ''++-66{FK 78 D++ 49 "LLN 0 0 2 ) HHXtyy'89E-25;;q>L
I | , 3 3 ,#'#7#75
( : $ fW]]_:\ ]^ nB!%f^B-?-E-E-GMk&l!mN2 n &I
)XZabbr- ) r/ r0 r1 r2 r3 rc r4 change_list_templaterq rt rf rg s @r, ri ri h s, ALeK&;MP"-cr- ri c e Zd ZdZdZdZdZdZd Zde_ d Z
d e
_ d
Z d e _ d Z d
e _ d Z
de
_ d Zde_ d Zde_ dZdZd fd Z xZS )OTTActivationLogAdmin) client_id phone_numberrA plan_idactivation_date_istbilling_from_date_listbilling_end_date_listr: messagesubscription_tiers_displaypayment_gatewayamount_display)r: rA subscription_tiersr )r rC r r )z-activation_dateactivation_datec t j d }|j j | j d S )N Asia/Kolkata%Y-%m-%d %H:%M:%S)pytztimezoner
astimezonestrftime)r* r+ ists r, r z)OTTActivationLogAdmin.activation_date_ist s3 mmN+""--c2;;{} indentzInvalid JSON or Empty)jsonloadsinputr dumpsr TypeError)r* r+
input_datas r, formatted_inputz%OTTActivationLogAdmin.formatted_input sH + CII.J
:a0PQ QI& +* + ?A AAzFormatted Inputc t j |j }t dt j |d S # t
t f$ r Y yw xY wr )r r outputr r r r )r* r+ output_datas r, formatted_outputz&OTTActivationLogAdmin.formatted_output sH + **SZZ0K
;q0QR RI& +* +r zFormatted Output)r r )r r r r c T t | || }|r|j dk( r|dz
}|S )Nr ) razorpay_order_idrazorpay_payment_idrazorpay_signaturer r cashfree_order_idcashfree_payment_idcashfree_payment_session_idcashfree_raw_response)r] get_readonly_fieldsr )r* r` r+ r5 rb s r, r z)OTTActivationLogAdmin.get_readonly_fields s; '5gsC 3))V3
O r- rT )r/ r0 r1 r2 r3 r4 orderingdate_hierarchyr rd r r r r r r excluder5 r rf rg s @r, r r s
L UKQM$H&NQ -D) 0I, /F+33F 0 (;N$+ ):O%+ *<&"GmO r- r c e Zd ZeZdZdZdZdZdZ d Z
de
_ d Z d e _ d
Z
d e
_ d Zd
e_ dZ fdZd Z xZS )JioHotstarCodeAdmin) idr activated_flagactivated_date_ist
billing_cycleexpired_date_listr r activated_client_idclient_phone_numbertype)r activated_dater r )r r r )z-activated_dater c |j rkt j d }|j }t | r t j j | }|j
| j d S y)Nr r r )r r r r utclocalizer r r s r, r z&JioHotstarCodeAdmin.activated_date_ist s] --/C##B|XX&&r*==%../BC Cr- zActivated Date (IST)c |j rct j d }t j |j t
j }|j | j d S yr r r s r, r z*JioHotstarCodeAdmin.billing_from_date_list sR --/C!!#"7"7BB==%..z: :r- r c |j rct j d }t j |j t
j }|j | j d S yr r r s r, r z)JioHotstarCodeAdmin.billing_end_date_list r r- r c |j rct j d }t j |j t
j }|j | j d S yr ) expired_dater r r r r r r r r s r, r z%JioHotstarCodeAdmin.expired_date_list! sR --/C!!#"2"2DHH=B==%..z: :r- zExpired Date (IST)z5ott_subscription/admin/jiohotstarcode_changelist.htmlc t | }t d| j j | j
d g}||z S )Nz usage-graph/%ott_subscription_jiohotstarcode_graphr% )r] rq r rr rs usage_graph_viewru s r, rq z JioHotstarCodeAdmin.get_urls/ sJ w ! **4+@+@A<
T!!r- c d }|j j d }|j j d }|j j d }|j j d }| j j j }|r|j | }|r |j t
| } |r$t j |d j nd } |r$t j |d j nd } |r|j | }| r|j |
}t j j |j d dd }
|
j rt j g d
}
t j |
d d |
d < |
d j# j% ddd |
d< |
d j& j |
d< |
d j) d |
d< |
d j) d |
d< i } |
j s|
|
d dk( j+ ddg j- j/ d } |
d j1 j3 }
|t5 |
}t7 t9 |
| }t; j< | ddddddg| }|j? ddt7 d d d d t7 d t7 d ! t7 t7 d " # |jA t7 d$ t7 d%& ' tC jD |d(d)d*d(i+ | d,< |
j+ ddg j- jG d-. j/ }tI jJ }|jM D ] \ }}|d }|j dd- }|j dd- }|jO tI jP |g|g| d/|j |d d01 |jO tI jP |g|g| d2d3d01 |j? d4d5d6ddt7 d d d d t7 t7 d " t7 t7 d " 7 tC jD |d(d(d*d(i+ | d8< |
d jS j/ }ddg|_* t; jV |ddd9: }|jA d;< |j? dd= tC jD |d(d(d*d(i+ | d>< |
|
d dk( j+ ddg j- jG d-. jY j/ }t; jZ |d|jT d?d d@|A }|j? dd= tC jD |d(d(d*d(i+ | dB< |
|
d dk( j] dgC } | j s$| d jS j_ dD j` } | | d jc | } | j+ ddg j- jG d-. } tI jJ tI jd | jf j | j` ji tj | jT ji tj dEdFG H } | j? dIdJdKddL tC jD | d(d(d*d(i+ | dM< |
|
d dk( d j] }!|!j s|!jm nd }"|!j s|!jo nd }#t5 |
|
d dk( |"|#|
|
d dk( d jS jq dN}$ni }$| j j js ddO ju }%| j j js ddO ju jw d }&t7 | jx j{ | dP| |$|||||%|&Q
}'t} |dR|' S # t $ r Y w xY w# t $ r d }Y w xY w# t $ r d } Y w xY w)SNc p t j }dt j dz z }d}t | D cg c]" }t j ||| z z dz || $ c}D cg c]6 \ }}}dt |dz dt |dz dt |dz d8 c}}}S c c}w c c}}}w ) Ng ?r gffffff?g ?zrgb( rN ))randomrangecolorsys
hsv_to_rgbr )nhsvirgbs r, get_color_palettez?JioHotstarCodeAdmin.usage_graph_view..get_color_palette> s
Afmmo))AA
#1X ''QUc(91a@ Aq! s1S5zl"S3ZL3qu:,a@
s 'B,,;B1r r
start_dateend_date)r )r r )activated_date__date__gte)activated_date__date__lter )r r r )columnscoerce)errors Activated Unactivated)TFr: dater| countr% TzDaily Activations by Type)r ycolormarkersr
hover_datacolor_discrete_mapi ( )lr tr -
)size) tickangletickfont)r* )autosizeheightmarginxaxisyaxis r )width)markerlineFcdn displaylogo) full_htmlinclude_plotlyjsconfig
line_chartr )
fill_valuez - ActivatedzCount: %{y})r r r marker_color
hovertemplatez - UnactivatedgreystackzTotal Activations by Typer )barmoder yaxis_titler+ r, r- r. r/ bar_chartzActivation Status Share)namesvaluesr z2Status: %{label}
Count: %{value})r< )r+ r, pie_chartr z%Cumulative Activations (Stacked Area))r r r color_discrete_sequence
area_chart)subset YlGnBuz?Date: %{x}
Billing Cycle: %{y}
Count: %{z})zr r
colorscaler< )dataz Heatmap: Billing Cycle vs DateDatez
Billing Cycle)r xaxis_titler@ r+ r, heatmap)total_activationsr r by_type)flatz JioHotstar Activation Graphs) r graphssummary
selected_typeselected_cycleselected_start selected_end type_optionsbilling_cycle_optionsz0ott_subscription/admin/jiohotstarcode_graph.html)?GETgetmodelr[ rP r\ r r r strptimer pd DataFrame from_recordsrC empty to_datetimenotnullmapr fillnagroupbyr( reset_indexuniquetolistlenr zippxr3
update_layout
update_tracespioto_htmlunstackgoFigureiterrows add_traceBar value_countsr piecumsumareadropnanlargestindexisinHeatmapTastypestrr maxto_dict values_listdistinctr rr each_contextr )(r* r` r type_filterr r r rZ parsed_start
parsed_enddfcontext_graphs
daily_summarytypes
color_palette color_mapfig_linebar_datafig_bar_rowr% activated_countunactivated_countpie_datafig_pie area_datafig_areaheat_df
top_cycles
heat_filtered heatmap_data fig_heatmap valid_dates
start_summary end_summary
summary_statsrY rZ r s( r, r z$JioHotstarCodeAdmin.usage_graph_view< s
kkoof- 8
[[__\2
;;??:.::%%))+ K8H
#??]9K?L OY8,,ZDIIK_cL KS**8Z@EEGY]J NH LH
\\
&
&x7GQ`'a
b
88 &QRB !~~b1A.B8 T *+33599Ub:cd8 (),,116
Z&&y16
1 8 8 C?xx r(|{ : ; C CVVDT U Z Z \ h hnu h vMvJ%%'..0E -c%j 9M S
67I ww 7&$1wi#, H
" " bB"3R$B-@DbM2
#
" "$A,T] " K+.;;x5chq~ AF qG ,HN< ( zz68"45::<DDPQDR^^`HiikG"++-
3K"%''+q"9$'GGM1$=!!!"&&c&' 3l+!* q$!7"> # !!"&&c() 3n-!'"> #
(
! !'9Tbitx BE OS VX \^ bd hj Ok
"
&
"
&
"
( +.++gafr BG rH +IN; ' (|002>>@H (' 2H ffXXgMfgG ! !0d ! e ! !4 ! <*-++gafo| D oE +FN; ' 2h<;67??@PQVVX``lm`nuuw D D FIwwVy'8'8'<=(5H
" "D " =+.;;x5chr BG rH ,IN< ( H 45<<_DU<VG== $_ 5 B B D M Ma P V V
'(@(E(Ej(Q R
, 4 4fo5N O T T V ^ ^jk ^ l iiRZZ"nn++"((//4"**11#6 '"c . )): & / ! * -0KK ugl wD FK vL -My) R\[ 89&AHHJK5@5F5FKOO -DM3>3D3D+//+$K &)BxLK,G)H%I + ' blk 9:6BOOQYY[ M Mzz))55f45HQQS $
2 2 > >UY > Z c c e n no~ OO ( ( 10!!%(%!%"7
)[]deem
L
J s6 +b (b/ 0(c b,+b,/ b>=b> cc)r/ r0 r1 r resource_classr2 r3 r4 r r r rd r r r r rq r rf rg s @r, r r s| +N ZLOKJM#H%N ,B( 0I, /F+ +?' S "rfr- r c 4 e Zd ZdZdZdZdZdZd Zde_ y)IptvRequestAdmin)r r email requested_atactivation_code activated_by activated_atget_reason_not_activated)r r r )r )z
-requested_atc |j S rT )reason_not_activatedr) s r, r z)IptvRequestAdmin.get_reason_not_activated s '''r- zReason for not activatedN)
r/ r0 r1 r2 r5 r4 r3 r r rd r7 r- r, r r s- L =O:M#K!H(1K .r- r c e Zd ZdZdZdZdZy)SupportVideoAdmin)r r" r! r" r$ )r subtitleN)r/ r0 r1 r2 r= r3 r4 r7 r- r, r r s 5L!M K)Mr- r c e Zd ZdZdZdZdZy)TVChannelAdmin)r r r" r! r$ r< r N)r/ r0 r1 r2 r3 r4 r r7 r- r, r r s e Zd ZdZdZdZdZdZd Zde_ edz
Zy )
CashfreePaymentAdmin) r customer_emailcustomer_phonerA r r" rj currencypayment_statuspaid_at
created_at)r rA r )r r" r rC r r )z -created_at)r r
extra_datac ~ dd l } |j |j d S # t $ r |j cY S w xY w)Nr r r )r r r Exception)r* r+ r s r, formatted_extra_dataz)CashfreePaymentAdmin.formatted_extra_data3 s: " 4::cnnQ7 7 ">> ! "s $ <<z
Extra Data)r N)
r/ r0 r1 r2 r3 r4 r r5 r rd r7 r- r, r r s; L @KtM H=O" .:*00Or- r )RequestFactory)SessionMiddleware)ManualOTTActivationr )fetch_watcho_datafetch_ottplay_datafetch_playbox_datac . e Zd ZdZdZdZdZ fdZ xZS )ManualOTTActivationAdmin)
r platformr
platform_2plan_2
first_name last_namesky_idr: r )r r: )r r r r )r c t | ||| j rj r j s d_ d_ j y j r+j s d_ d_ j y j r+j s d_ d_ j y g }fd} |j |j j j r8j r,|j |j j |D cg c]
}|d dk( s | }}|D cg c]
}|d dk( s | } }t | dk( rd_ d _ nat | dk( r*d_ d
j d | D }
d |
_ n)d
_ d
j d | D }
d|
_ j y c c}w c c}w # t $ r1} d_ t | _ j Y d } ~ y d } ~ ww xY w)NFailedz2First Platform, Plan and Phone number are requiredz(Second plan selected but Plan is missingzSecond platform missingc
j | j |j d
j
j t
dd
j
d}t
}|j dt j | d }t d }|j | |j j | j d k( r t | }nQ| j d
k( r t! | }n6| j d k( r t# | }nd | j$ |j d
dS t j& |j( j+ d }|j. dk( rdnd }t0 j2 j5
j | |j ||j7 d |j7 d |j7 d |j7 d |j7 d
j
|| j$ |j |j7 d dS # t, $ r ddi}Y w xY w# t, $ r.} d | j$ |j t9 | dcY d } ~ S d } ~ ww xY w)Nr r )r rA r manual_flagr r r address_cityz
/fake-url/zapplication/json)rL content_typec y rT r7 )reqs r, r{ zGManualOTTActivationAdmin.save_model..activate.. s r- watchoottplayplay_boxr zPlatform not supported)r: r r r zutf-8r zInvalid API response Successr response_statusr endpoint)
r rA r r: r r r r r r ) r r r r getattrr r postr r r process_requestsessionsaver r r r r r contentdecoder status_coder r[ creater\ r ) r r payloadfactory fake_request
middlewareresponse
response_data
result_statuser+ s r, activatez5ManualOTTActivationAdmin.save_model..activate~ sB ! - - '{{ 77 !nn ]] gr2 #
G %&G"<< ZZ( / ( L ++;H ]]i/ 1, ?H ]]j0 1, ?H #+$,MM $ #; H$(JJx/?/?/F/Fw/O$PM .6-A-AS-H h
!((// ! . . ( II( ) - -i 8'++G4$1$5$56G$H(,,X6 * . .z :!$!1!1 0 , (
II , 0 0 ; ' ! H%.0F$GMH4
& (
II "1v
sD =A+H: *.H' CH: '
H74H: 6H77H: : I1#I,&I1,I1r: r r z All plans activated successfullyrN c 3 D K | ] }|d d|d d|d d ywr z - r z (r r Nr7 .0r s r, z6ManualOTTActivationAdmin.save_model.. 7 + }oS6 2a l^1E+ z All failed: zPartial Successc 3 D K | ] }|d d|d d|d d ywr r7 r s r, r z6ManualOTTActivationAdmin.save_model.. r r zFailed: )r]
save_modelr r r r: r r r r r rk rO r r )
r* r` r+ formchangeactivation_resultsr r success_resultsfailed_resultsfailed_detailsr rb s
` r, r z#ManualOTTActivationAdmin.save_model` s
7Cv6
||38833C3C!CJNCK HHJ >>#**!CJDCK HHJ ::cnn!CJ3CK HHJ
L b0
% % sxx0
~~#**")) S^^SZZ8 += YQ( y@Xq YO Y); WAq{h?Va WN W>"a' &
@ _%* %
!% + ++ "
!-^,< = /
!% + ++ "
!) (8 9 HHJ7 Z W8 !CJ a&CK HHJJ sD A4H
G=G=H
H(H,BH =
H I'H<<I) r/ r0 r1 r2 r3 r4 r5 r rf rg s @r, r r E s+ L )KM &O_ _r- r )Sdjango.contribr modelsr r r r r r
r r r
django.utils.htmlr r r r import_export.adminr resourcesr r r django.template.responser r collectionsr django.urlsr django.db.modelsr r django.utils.timezoner r csv django.httpr pandasr_ seabornsnsmatplotlib.pyplotpyplotpltior base64r plotly.expressexpressrm plotly.graph_objects
graph_objectsrs plotly.iorp r
ModelAdminr siteregisterr9 r? rE ri r r r r r r django.testr "django.contrib.sessions.middlewarer r ott_subscription.viewsr r r r r7 r- r, r! s B B B ' ) " 6 - # 5 # " *
$
! #u $
C " ))
M#5 6#(( #
L"3 4M5## M8
G\ *;cu'' ;c|
K!1 2P E , , P d
$&; < rf0 rf rfn Lu'' L L0 *(( * * U%% 15++ 1 !1: ! & @ 9 \ \ #$yu / / y %yr-