U h,{@sdZddlZddlZddlmZmZmZmZmZddl m Z ddl m Z m Z mZmZmZmZddlmZmZmZddlmZddlmZdd lmZmZmZdd lmZdd l m!Z!m"Z"m#Z#m$Z$m%Z%m&Z&dd l'm(Z(dd l)m*Z*ddl+m,Z,ddl-m.Z.ddl/m0Z0ddl1m2Z2ddlmZddlmZmZddl m Z m Z mZmZddlmZmZmZddl m!Z!m"Z"dd l'm(Z(ddl3m4Z5ddl6m7Z7ddl8m9Z9ddl:m;Z;mZ>m?Z?m@Z@mAZAmBZBddlCmDZDGddde2eZEGddde2eZFGdd d e2eZGGd!d"d"e2eZHGd#d$d$eZIGd%d&d&eZJGd'd(d(eZKGd)d*d*eZLe.e,d+d,Gd-d.d.eZMGd/d0d0eZNGd1d2d2eZOGd3d4d4eZPGd5d6d6eZQGd7d8d8eZRGd9d:d:eZSGd;d<dd>eZUGd?d@d@eZVGdAdBdBeZWGdCdDdDe2eZXGdEdFdFe2eZYGdGdHdHe2eZZGdIdJdJe2eZ[GdKdLdLe2eZ\GdMdNdNeZ]GdOdPdPeZ^GdQdRdReZ_GdSdTdTeZ`GdUdVdVeZaGdWdXdXeZbGdYdZdZeZcGd[d\d\eZdGd]d^d^eZeGd_d`d`eZfGdadbdbeZgdS)ca1Views for the channels app. This module contains all view classes for managing channels, jingles, adbreaks, and related functionality. All views inherit from Django's base View class to provide maximum flexibility and control over request handling. Author: Django Channels App Version: 1.0.0 Date: 2024 N)DictAnyListUnionOptional)logout) HttpRequest HttpResponse JsonResponseHttp404HttpResponseRedirectHttpResponseBadRequest)renderget_object_or_404redirect)reverse)View) Paginator EmptyPagePageNotAnInteger)messages)QCountAvgSumMaxMin)timezone)ValidationError) csrf_exempt)method_decorator)settings)LoginRequiredMixin)rr)rr r r )rrr)rr)gettext)cache) get_client_ip)Channel ChannelZone ChannelCodecJingleAdbreak EPGProgramChannelScheduleChannelZoneRelation)ActivitycseZdZdZdgZdZdddddd Zfd d Zee d d dZ edddZ ddZ ddZ ddZddZddZddZeeeefd ddZd d!Zd"d#Zd$d%Zeeeefd d&d'Zed(d)d*Zeeefd(d+d,Zeeejfd(d-d.Z ee!d d/d0Z"ee!d d1d2Z#ee!d d3d4Z$ee!d d5d6Z%ee!d d7d8Z&ee!d d9d:Z'ee!d d;d<Z(eed d=d>Z)ed?d d@dAZ*ee d fdBdC Z+Z,S)DChannelListViewa Channel List View This view is responsible for rendering the channels list page of the application. It extends the Django View class and defines the HTTP GET method to handle the request and return the rendered channels list page template with advanced filtering, searching, pagination, and AJAX support. Methods: get(request): Handles the HTTP GET request and returns the rendered channels list page template. Template: - 'channels/channel/list.html': The HTML template used to render the channels list page. Features: - Advanced filtering by type, status, zone, and date ranges - Full-text search across channel name, display name, and description - Pagination with customizable items per page - AJAX support for dynamic updates - Statistics and analytics - Export functionality - Real-time updates getzchannels/channel/list.htmlzChannels - AdtlasAdtlas Development TeamzzChannels management for Adtlas TV advertising solutions. This page provides comprehensive channel management and insights.z`Adtlas, channels, TV advertising solutions, channel management, broadcasting, data visualizationchannels)titleauthor descriptionkeywords active_menuc s$tjf|}|dtdi|S)z Add channels page context data. Args: **kwargs: Additional keyword arguments Returns: dict: Updated context data r3Channels)superget_context_dataupdate_)selfkwargscontext __class__./var/www/html/Focus/src/apps/channels/views.pyr:^s z ChannelListView.get_context_datarequestreturnc Os|jddkr||S||}t|||}|jdd}z||}Wn<tk rn|d}Yn t k r||j }YnX| || |||}t ||j|S)a Handles the HTTP GET request and returns the rendered channels list page template. Args: request (HttpRequest): The HTTP request object. *args: Variable length argument list. **kwargs: Arbitrary keyword arguments. Returns: HttpResponse: The rendered channels list page template. Query Parameters: - search: Search term for channel name/display_name/description - type: Filter by channel type - status: Filter by channel status - zone: Filter by channel zone - date_from: Start date for filtering - date_to: End date for filtering - date_range: Predefined date range - sort_by: Sorting field and direction - page: Page number for pagination - per_page: Number of items per page (default: 20) X-Requested-WithXMLHttpRequestpage)headersr0_handle_ajax_request_get_filtered_querysetr_get_items_per_pageGETget_pagerr num_pages_log_user_activity_build_contextr template_name) r=rEargsr>queryset paginator page_numberpage_objr?rBrBrCr0ns   zChannelListView.get)rEcCs`tjd}|||}|||}|||}|||}| ||}| ||}|S)z Build filtered queryset based on request parameters. Args: request: Django HTTP request object Returns: QuerySet: Filtered channel queryset zones) r&objectsallselect_relatedprefetch_related_apply_search_filter_apply_type_filter_apply_status_filter_apply_zone_filter_apply_date_filters_apply_sortingr=rErVrBrBrCrMs       z&ChannelListView._get_filtered_querysetcCsH|jdd}|rD|t|dt|dBt|dBt|dB}|S)z Apply search filter to queryset. Args: queryset: Base queryset request: Django HTTP request object Returns: QuerySet: Filtered queryset searchname__icontainsZdisplay_name__icontainsdescription__icontains)Zchannel_code__icontains)rOr0stripfilterr)r=rVrE search_queryrBrBrCr_s z$ChannelListView._apply_search_filtercCs.|jdd}|r*|dkr*|j|d}|S)z Apply channel type filter to queryset. Args: queryset: Base queryset request: Django HTTP request object Returns: QuerySet: Filtered queryset typergr\ channel_typerOr0rmrn)r=rVrErrrBrBrCr`s   z"ChannelListView._apply_type_filtercCs.|jdd}|r*|dkr*|j|d}|S)z Apply status filter to queryset. Args: queryset: Base queryset request: Django HTTP request object Returns: QuerySet: Filtered queryset statusrgr\rtrs)r=rVrE status_filterrBrBrCras   z$ChannelListView._apply_status_filtercCs.|jdd}|r*|dkr*|j|d}|S)z Apply zone filter to queryset. Args: queryset: Base queryset request: Django HTTP request object Returns: QuerySet: Filtered queryset zonergr\)Z zones__idrs)r=rVrEZ zone_filterrBrBrCrbs   z"ChannelListView._apply_zone_filterc Csd|jd}|jd}|jd}|rt}|dkrJ|j|d}n|dkrp|tjdd}|j|d}np|d kr|tj|d}|j|d }nF|d kr|j dd } |j| d }n$|d kr|tjdd} |j| d }|r z"tj |d} |j| d }Wnt k rYnX|r`z"tj |d} |j| d}Wnt k r^YnX|S)z Apply date range filters to queryset. Args: queryset: Base queryset request: Django HTTP request object Returns: QuerySet: Filtered queryset date_fromdate_to date_rangetoday)created_at__date yesterdayrJdays this_weekZcreated_at__date__gte this_monthday last_30_days%Y-%m-%d)Zcreated_at__date__lte) rOr0rnowdaterndatetime timedeltaweekdayreplacestrptime ValueError) r=rVrErxryrzr{r} week_start month_startr from_dateto_daterBrBrCrcs@      z#ChannelListView._apply_date_filtersc CsL|jdd}dddddddd d d d d g }||kr>||}n |d}|S)z Apply sorting to queryset. Args: queryset: Base queryset request: Django HTTP request object Returns: QuerySet: Sorted queryset sort_byname-name display_name -display_namerr -channel_typertz-status created_at -created_at updated_at -updated_at)rOr0order_by)r=rVrErvalid_sort_fieldsrBrBrCrd:s$    zChannelListView._apply_sortingcCsh|j}|j|||jdk|||||||||| |j |j |jd}| |j |S)a Build template context with all necessary data. Args: request: Django HTTP request object page_obj: Paginated page object paginator: Paginator instance Returns: dict: Template context rJ)r2rYrW is_paginated channel_typesstatus_choicesrZ filter_params sort_optionsstatsrz total_results current_page total_pages)user object_listrQ_get_channel_types_get_status_choices_get_available_zones_get_current_filters_get_sort_options _get_stats_get_date_rangecountnumberr; extra_context)r=rErYrWrr?rBrBrCrSWs$  zChannelListView._build_contextcCs ttdgS)zo Get available channel types. Returns: list: Channel type choices CHANNEL_TYPESgetattrr&r=rBrBrCrsz"ChannelListView._get_channel_typescCs ttdgS)zj Get available status choices. Returns: list: Status choices STATUS_CHOICESrrrBrBrCrsz#ChannelListView._get_status_choicescCstjjddddS)z Get zones available to the current user. Args: user: Current user object Returns: QuerySet: Available zones T is_activerr)r'r[rndistinctr)r=rrBrBrCrs  z$ChannelListView._get_available_zonesc Csr|jdd|jdd|jdd|jdd|jdd|jdd|jd d|jd d |jd d d S)z Get current filter parameters for template. Args: request: Django HTTP request object Returns: dict: Current filter values rfrgrpr\rtrwrxryrzrrper_page20) rfrprtrwrxryrzrr)rOr0)r=rErBrBrCrs         z$ChannelListView._get_current_filtersrFc CsLddddddddddd dd d dd d ddddddddddg S)zv Get available sorting options. Returns: list: Sort options for template rz Name (A-Z)valuelabelrz Name (Z-A)rzDisplay Name (A-Z)rzDisplay Name (Z-A)rrz Type (A-Z)rz Type (Z-A)rz Newest Firstrz Oldest FirstrzRecently UpdatedrBrrBrBrCrsz!ChannelListView._get_sort_optionsc Cstj}t}|tjdd}||j dd|j dd|j dd|j dd|j d d|j |d | d j t d d  d|j d d|j ddd S)z Get channels statistics for dashboard. Args: user: Current user object Returns: dict: Channels statistics r~activeruT is_onlinependinginactiveFrrridr-count)Z zones__isnull) total_channelsactive_channelsonline_channelsZpending_channelsinactive_channelsoffline_channelsrecent_channelsZchannels_by_typeZchannels_with_zonesZchannels_without_zones)r&r[r\rrrrrrrnvaluesannotaterrr)r=r base_querysetr{week_agorBrBrCrs(   zChannelListView._get_statsc CsZt}||tjdd|tj|d|jdd|tjdd|tjdddS)zz Get date range information for filtering. Returns: dict: Date range options rJr~rim)r{r}rrmin_datemax_date)rrrrrrr)r=r{rBrBrCrs  zChannelListView._get_date_rangecCsp|jd}|dkr||S|dkr0||S|dkrB||S|dkrT||S|dkrf||S||S)z Handle AJAX requests for dynamic updates. Args: request: Django HTTP request object Returns: JsonResponse: JSON response with data action get_zonesZget_channel_types quick_stats export_dataZ load_more)rOr0_get_zones_ajax_get_channel_types_ajax_get_quick_stats_ajax_export_channels_data_ajax_load_more_channels_ajax_get_filtered_channels_ajax)r=rErrBrBrCrLs      z$ChannelListView._handle_ajax_requestc Cs.|j}||}tdt|dddddS)z Get zones via AJAX. Args: request: Django HTTP request object Returns: JsonResponse: JSON response with zone data Trrregioncode)successrZ)rrr listr)r=rErrZrBrBrCrs  zChannelListView._get_zones_ajaxcCs |}tddd|DdS)z Get channel types via AJAX. Args: request: Django HTTP request object Returns: JsonResponse: JSON response with channel type data TcSsg|]}|d|ddqS)rrJrrB).0ctrBrBrC 8sz;ChannelListView._get_channel_types_ajax..)rr)rr )r=rErrBrBrCr*s  z'ChannelListView._get_channel_types_ajaxcCs|j}||}td|dS)z Get quick statistics via AJAX. Args: request: Django HTTP request object Returns: JsonResponse: JSON response with statistics T)rr)rrr )r=rErrrBrBrCr;s  z%ChannelListView._get_quick_stats_ajaxcCs,||}tdd|dd|dS)z Export channels data via AJAX. Args: request: Django HTTP request object Returns: JsonResponse: JSON response with export status TzExport prepared for channels#)rmessage download_urlr)rMr rrerBrBrCrMs z*ChannelListView._export_channels_data_ajaxc Cst|jdd}||}||}t||}z||}Wn&ttfk rdt dddYSXg}|j D]L}| |j |j t|ddt|ddt|d dt|d r|jndd qpt d |||r|nd |j|jdS)z Load more channels via AJAX for infinite scroll. Args: request: Django HTTP request object Returns: JsonResponse: JSON response with additional channels rIrJF Invalid pagererrorrrgrrrtr)rrrrrrtrTN)rr2has_next next_pagerr)intrOr0rNrMrrPrrr rappendrrrhasattrr isoformatrnext_page_numberrrQ) r=rErIrrVrWrY channels_datachannelrBrBrCrcs4         z(ChannelListView._load_more_channels_ajaxc Cs||}t|||}|jdd}z||}Wn&ttfk r\tdddYSXg}|j D]L}| |j |j t |ddt |ddt |d dt|d r|jnd d qhtd ||j|j|j||dS)z Get filtered channels via AJAX. Args: request: Django HTTP request object Returns: JsonResponse: JSON response with filtered channels rIrJFrrrrgrrrtrZr)rrrrrrt zone_countT)rr2rrrr has_previous)rMrrNrOr0rPrrr rrrrrrrZrrrQrr)r=rErVrWrIrYrrrBrBrCrs4      z+ChannelListView._get_filtered_channels_ajaxc CsDz$t|jdd}tdt|dWSttfk r>YdSXdS)z Get number of items per page from request or default. Args: request: Django HTTP request object Returns: int: Items per page r dN)rrOr0maxminr TypeError)r=rErrBrBrCrNs z#ChannelListView._get_items_per_pageNc CsX|j}tj|dd|r|jndd|t||jdd|||| ddd S) aZ Log user activity for auditing purposes. Records the user's action with relevant metadata including IP address, user agent, and timestamp for security and analytics purposes. Args: request (HttpRequest): The HTTP request object Returns: None Zviews_channelsUser Systemz viewed channels listHTTP_USER_AGENTrg)Zfilters_appliedZ results_countrrr5rE ip_address user_agentmetadataN) rr. log_activityemailr%METAr0rrMr)r=rErrBrBrCrRs   z"ChannelListView._log_user_activitycstj|f||S)a0 Override dispatch method for additional request processing. This method is called before any HTTP method handler. Useful for adding common logic like additional authentication checks, rate limiting, or request preprocessing. Args: request (HttpRequest): The HTTP request object *args: Variable length argument list **kwargs: Arbitrary keyword arguments Returns: HttpResponse: Result from the appropriate HTTP method handler )r9dispatch)r=rErUr>r@rBrCr szChannelListView.dispatch)-__name__ __module__ __qualname____doc__http_method_namesrTrr:rr r0rMr_r`rarbrcrdrstrrrSrrrrrrrrrrrr rLrrrrrrrNrRr  __classcell__rBrBr@rCr/:sH 33+  *)r/cseZdZdZddgZdZddddd Zfd d Zee e d d dZ ee e e e fd ddZee dddZeeeeefdddZddZddZde dddZde dd d!Zeeeefd"d#d$Zeeeefd"d%d&Zeeeefd"d'd(Zeeefd)d*d+Zeeefd)d,d-Zeed"d.d/Zee e d d0d1Zee d"d2d3Z ee d"d4d5Z!ee d"d6d7Z"ee d"d8d9Z#ee d"d:d;Z$dd?Z&d@dAZ'dBdCZ(dDdEZ)dFdGZ*dHdIZ+dJdKZ,dLdMZ-dNdOZ.dPdQZ/dRdSZ0dTdUZ1dVdWZ2dXdYZ3dZd[Z4d\d]Z5d^d_Z6d`daZ7dbdcZ8dddeZ9dfdgZ:dhdiZ;djdkZdpdqZ?drdsZ@dtduZAdvdwZBdxdyZCdzd{ZDed|d"d}d~ZEZFS)ChannelDetailViewa Channel Detail View This view is responsible for rendering the channel detail page of the application. It extends the Django View class and provides comprehensive channel information including zones, codecs, recent adbreaks, jingles, health status, analytics, and real-time monitoring data. Methods: get(request, channel_id): Handles the HTTP GET request and returns the rendered channel detail page template with comprehensive data. Template: - 'channels/channel/detail.html': The HTML template used to render the channel detail page. Features: - Comprehensive channel information display - Real-time health status monitoring - Advanced analytics and statistics - Interactive charts and graphs - AJAX support for dynamic updates - Export functionality for reports - Historical data analysis - Performance metrics tracking - Zone and codec management - Adbreak and jingle analysis r0postzchannels/channel/detail.htmlr1zODetailed channel information and analytics for Adtlas TV advertising solutions.zPAdtlas, channel details, TV advertising, channel analytics, broadcasting metricsr2)r4r5r6r7c sBttdrtjf|ni}||jdtd|jd|S)z Add channel detail page context data. Args: channel: Channel object **kwargs: Additional keyword arguments Returns: dict: Updated context data r:z - Channel Details - AdtlaszChannel Details)r3 page_title channel_name)rr9r:r;rr<)r=rr>r?r@rBrCr: s  z"ChannelDetailView.get_context_datarE channel_idrFcOs^|jddkr|||S|||}|jdd}|||||||}t||j|S)a Handles the HTTP GET request and returns the rendered channel detail page template. Args: request (HttpRequest): The HTTP request object. channel_id (int): Primary key of the channel to display. *args: Variable length argument list. **kwargs: Arbitrary keyword arguments. Returns: HttpResponse: The rendered channel detail page template. Raises: Http404: If channel with given ID doesn't exist or user doesn't have permission. Query Parameters: - tab: Active tab to display (overview, analytics, zones, adbreaks, jingles, health) - date_from: Start date for analytics filtering - date_to: End date for analytics filtering - date_range: Predefined date range for analytics - export: Export format (json, csv, pdf) rGrHtaboverview) rKr0rL_get_channel_with_permissionsrOrR_build_comprehensive_contextrrT)r=rErrUr>r active_tabr?rBrBrCr03s   zChannelDetailView.getcOsl|||}|jd}|dkr,|||S|dkr@|||S|dkrT|||St|d|||S)z Handle POST requests for channel operations. Args: request: HTTP request object channel_id: Channel ID Returns: HttpResponse or JsonResponse based on request type r update_statusZrefresh_healthrzInvalid action requested.)rPOSTr0Z_update_channel_statusZ_refresh_health_statusZ_export_channel_datarr)r=rErrUr>rrrBrBrCr]s      zChannelDetailView.post)rErcCs6ztt|d}|WStjk r0tdYnXdS)aE Get channel object with permission checks. Args: request: HTTP request object channel_id: Channel ID Returns: Channel: Channel object Raises: Http404: If channel doesn't exist or user lacks permission pkzChannel not foundN)rr& DoesNotExistr )r=rErrrBrBrCrvs  z/ChannelDetailView._get_channel_with_permissions)rErrFcCs|||||||||||||||||||||||| | | | | |d}||j||||S)a( Build comprehensive template context with all necessary data. Args: request: Django HTTP request object channel: Channel object active_tab: Currently active tab Returns: dict: Template context )rrrZcodecsrecent_adbreaksrecent_jinglesr analyticsZperformance_metrics health_statusmonitoring_dataZdate_range_optionsZexport_optionsZ chart_configsZ tab_configs breadcrumbs)_get_channel_zones_get_channel_codecs_get_recent_adbreaks_get_recent_jingles_get_channel_statistics_get_channel_analytics_get_performance_metrics_get_health_status_get_monitoring_data_get_date_range_options_get_export_options_get_chart_configurations_get_tab_configurations_get_breadcrumbsr;rr:)r=rErrr?rBrBrCrs(   ! z.ChannelDetailView._build_comprehensive_contextcCs,|jdjtdddtdddS)z Get zones associated with the channel. Args: channel: Channel object Returns: QuerySet: Channel zones with additional data radbreaksT)rZadbreaks__start_time) adbreak_count last_activityr)rZr]r^rrrrr=rrBrBrCr*s  z$ChannelDetailView._get_channel_zonescCst|ddpgS)z Get codecs associated with the channel. Args: channel: Channel object Returns: QuerySet: Channel codecs r#N)rr;rBrBrCr+s z%ChannelDetailView._get_channel_codecsr)limitcCs@ttdd}tjj||ddd dd|S)z Get recent adbreaks for the channel. Args: channel: Channel object limit: Number of adbreaks to return Returns: QuerySet: Recent adbreaks rr~r date__gtecampaignZadvertisements -start_timeN) rrrrr*r[rnr]r^r)r=rr<rrBrBrCr,s z&ChannelDetailView._get_recent_adbreakscCs"tjj|dddd|S)z Get recent jingles for the channel. Args: channel: Channel object limit: Number of jingles to return Returns: QuerySet: Recent jingles rcategoryrN)r)r[rnr]r)r=rr<rBrBrCr-s z%ChannelDetailView._get_recent_jinglesrDcCs ||\}}t}tjj|d}|j||gd}|j|t jj|d||j|d|j t dddpd|j t ddd pd|j t dd d pd|j tdd d pd|||||||||||||||j t ddddS)z Get comprehensive channel statistics. Args: channel: Channel object request: HTTP request object Returns: dict: Channel statistics rB) date__range)rduration)avgrFrtotalrH)rr)rr start_time)lastrJ) total_zonestotal_adbreaks total_jinglesr$today_adbreaksZavg_adbreak_durationZ total_airtimeZmax_adbreak_durationZmin_adbreak_durationZadbreaks_per_dayZ peak_hoursZzone_distributionuptime_percentageZ error_rater:)_get_analysis_date_rangerrrr*r[rnrZrr) aggregaterrrr_calculate_adbreaks_per_day_get_peak_hours_get_zone_distribution_calculate_uptime_calculate_error_rate)r=rrErxryr{Z adbreaks_qsZrecent_adbreaks_qsrBrBrCr.sX    z)ChannelDetailView._get_channel_statisticsc CsP||\}}||||||||||||||||||||dS)z Get detailed analytics data for charts and graphs. Args: channel: Channel object request: HTTP request object Returns: dict: Analytics data for visualization )Zdaily_adbreaksZhourly_distributionZzone_performanceZduration_trendsZcomparison_data)rP_get_daily_adbreaks_data_get_hourly_distribution_get_zone_performance_data_get_duration_trends_get_comparison_data)r=rrErxryrBrBrCr/>s      z(ChannelDetailView._get_channel_analyticscCs&||||||||dS)z Get performance metrics for the channel. Args: channel: Channel object request: HTTP request object Returns: dict: Performance metrics )signal_qualityZtransmission_statsZ error_logsZmaintenance_schedule)_get_signal_quality_get_transmission_stats_get_recent_errors_get_maintenance_schedule)r=rrErBrBrCr0Ss z*ChannelDetailView._get_performance_metricsrc Cs|d|j}t|}|r|S||t||||||| || || || |d }t ||d|S)z Get current health status of the channel. Args: channel: Channel object Returns: dict: Health status information channel_health_) rt last_checksignal_strengthZ connectivity disk_usage memory_usageZ cpu_usagewarningsZrecommendations,)rr$r0_determine_health_statusrr_get_signal_strength_check_connectivity_get_disk_usage_get_memory_usage_get_cpu_usage_get_health_warnings_get_health_recommendationsset)r=r cache_keyZ cached_health health_datarBrBrCr1es   z$ChannelDetailView._get_health_statuscCs.||||||||||dS)z Get real-time monitoring data. Args: channel: Channel object Returns: dict: Monitoring data ) live_statusZcurrent_broadcastZupcoming_schedulealertssystem_metrics)_get_live_status_get_current_broadcast_get_upcoming_schedule_get_active_alerts_get_system_metricsr;rBrBrCr2s z&ChannelDetailView._get_monitoring_datac CsD|jdd}|jd}|jd}t}|r~|r~z.tj|d}tj|d}||fWStk r|YnX|dkr||fS|dkr|tdd }||fS|dkr|td d |fS|d kr|td d |fS|d kr|j dd} | |fS|dkr2|j ddtdd } | j dd} | | fS|td d |fS)z Get date range for analysis from request parameters. Args: request: HTTP request object Returns: tuple: (date_from, date_to) rz last_7_daysrxryrr{r}rJr~rrrrr last_month) rOr0rrrrrrrr) r=rErzZ date_from_strZ date_to_strr{rxryr}rZlast_month_endZlast_month_startrBrBrCrPs8         z*ChannelDetailView._get_analysis_date_rangecCs|||}|jd}|dkr,|||S|dkr@|||S|dkrT|||S|dkrh|||S|dkr||||Stddd S) z Handle AJAX requests for dynamic updates. Args: request: Django HTTP request object channel_id: Channel ID Returns: JsonResponse: JSON response with requested data rZget_health_statusZget_analytics_dataZget_live_statsget_recent_activityZrefresh_monitoringFzInvalid actionr) rrOr0_get_health_status_ajax_get_analytics_data_ajax_get_live_stats_ajax_get_recent_activity_ajax_refresh_monitoring_ajaxr )r=rErrrrBrBrCrLs       z&ChannelDetailView._handle_ajax_requestcCs||}td|dS)z Get health status via AJAX. Args: request: HTTP request object channel: Channel object Returns: JsonResponse: Health status data T)rr')r1r )r=rErrrrBrBrCr~s z)ChannelDetailView._get_health_status_ajaxcCs|||}td|dS)z Get analytics data via AJAX for dynamic chart updates. Args: request: HTTP request object channel: Channel object Returns: JsonResponse: Analytics data T)rr&)r/r )r=rErZanalytics_datarBrBrCrs z*ChannelDetailView._get_analytics_data_ajaxc Cs^|||}||}td|didd|dd|dd|did d d d S) z Get live statistics via AJAX. Args: request: HTTP request object channel: Channel object Returns: JsonResponse: Live statistics TrsviewersrrNrOrrurcGood)Zcurrent_viewersZadbreaks_todayrOr\)rZ live_stats)r.r2r r0)r=rErrZ monitoringrBrBrCrs    z&ChannelDetailView._get_live_stats_ajaxc Cs||d}||d}g}|D]R}||j|jr<|jnd|jrNt|jndt|drht |j ddnddq g}|D]B}||jt |ddtt |d dt|d r|j ndd q|t d ||d dS)z Get recent activity via AJAX. Args: request: HTTP request object channel: Channel object Returns: JsonResponse: Recent activity data rANrr?rrg)rrIrE campaign_namerEr)rrrErT)r8jingles)rrecent_activity) r,r-rrrIrrEfloatrrr?rr ) r=rErr$r%Z adbreaks_dataadbreakZ jingles_datajinglerBrBrCrs0     z+ChannelDetailView._get_recent_activity_ajaxcCsDd|j}t|||}||}td||tdS)z Refresh monitoring data via AJAX. Args: request: HTTP request object channel: Channel object Returns: JsonResponse: Updated monitoring data raT)rr'r(Z last_updated) rr$deleter1r2r rrr)r=rErrqr'r(rBrBrCrGs     z*ChannelDetailView._refresh_monitoring_ajaxcCs@||jd}tjj|||gd}|dkrs rc@s4eZdZdZeeedddZeeedddZdS)ChannelUpdateViewa\View for updating existing channels. Handles both GET requests to display the update form pre-filled with current channel data and POST requests to process updates. Methods: get: Display channel update form post: Process form submission and update channel Template: channels/channel_form.html rcCs4tt|d}|tjtjd|jdd}t|d|S)aVDisplay channel update form. Args: request: HTTP request object channel_id: Primary key of channel to update Returns: HttpResponse: Rendered template with pre-filled form Raises: Http404: If channel with given ID doesn't exist r zUpdate Channel: zUpdate Channel)rrrrrr)rr&rrrr)r=rErrr?rBrBrCr0s  zChannelUpdateView.getc Cstt|d}zR|jddp&|j|_|jddp@|j|_|jd}|r^t||_|jdpn|j |_ |jdp|j |_ |jdd|_ |jd d|_ |jd d|_ |jd d|_|jd d|_|jd dk|_|jd}|rt||_|jd}|r4t||_|t|d|jdtd|jdWStk r}z&t|d||||WYSd}~XYnFtk r}z&t|d||||WYSd}~XYnXdS)aProcess channel update form submission. Args: request: HTTP request object with form data channel_id: Primary key of channel to update Returns: HttpResponse: Redirect to channel detail on success, or form with errors Raises: Http404: If channel with given ID doesn't exist r rrgrrrrrtr5rrrCrrrmax_ad_duration min_ad_gapr" updated successfully.rrrNzError updating channel: )rr&rr0rmrrrrrrrtr5rrrCrrrrsaverrrr!rrr)r=rErrrrrrrBrBrCrs<        zChannelUpdateView.postN r r rrrrr r0rrBrBrBrCrs rc@s4eZdZdZeeedddZeeedddZdS)ChannelDeleteViewa6View for deleting channels. Handles both GET requests to display confirmation page and POST requests to perform the actual deletion. Methods: get: Display deletion confirmation post: Process deletion request Template: channels/channel_confirm_delete.html rcCsHtt|d}tjj|d}tjj|d}|||d}t|d|S)aXDisplay channel deletion confirmation. Args: request: HTTP request object channel_id: Primary key of channel to delete Returns: HttpResponse: Rendered confirmation template Raises: Http404: If channel with given ID doesn't exist r rB)radbreaks_count jingles_countz$channels/channel/confirm_delete.html)rr&r*r[rnrr)r)r=rErrrrr?rBrBrCr0s zChannelDeleteView.getc Csptt|d}|j}z |t|d|dWn4tk rf}zt|d|W5d}~XYnXtdS)a\Process channel deletion request. Args: request: HTTP request object channel_id: Primary key of channel to delete Returns: HttpResponse: Redirect to channel list after deletion Raises: Http404: If channel with given ID doesn't exist r r" deleted successfully.zError deleting channel: Nzchannels:channel_list) rr&rrrrrrr)r=rErrrrrBrBrCrs $zChannelDeleteView.postNrrBrBrBrCrs rc@s"eZdZdZeeedddZdS)JingleListViewa View for displaying a list of jingles for a specific channel. Shows paginated jingles with filtering options by type and placement. Methods: get: Handle GET requests to display jingle list Template: channels/jingle_list.html rc Cstt|d}|jdd}|jdd}|jdd}t|jdd}tjj|d }|rf|j|d }|rv|j|d }|d }t ||} z| |} Wn<t k r| d} Yn t k r| | j } YnX|| tjtj||| jd } t|d| S)aZHandle GET request to display jingle list. Args: request: HTTP request object channel_id: Primary key of the channel Returns: HttpResponse: Rendered template with jingle list Raises: Http404: If channel with given ID doesn't exist r rprg placementrIrJrrrBrprr)rr jingle_typesPLACEMENT_TYPES selected_typeZselected_placementrMzchannels/jingle/list.html)rr&rOr0rr)r[rnrrrIrrrQ JINGLE_TYPESrrr) r=rErr jingle_typerrIrrrW jingles_pager?rBrBrCr0=s6      zJingleListView.getNr r rrrrr r0rBrBrBrCr2s rc@s"eZdZdZeeedddZdS)AdbreakListViewa View for displaying adbreaks for a specific channel. Shows paginated adbreaks with filtering by date range, type, and category. Methods: get: Handle GET requests to display adbreak list Template: channels/adbreak_list.html rc CsTtt|d}|jd}|jd}|jdd}|jdd}|jdd}t|jd d } |s~ttd d  }|st }t j j |||d } |r| j |d} |r| j |d} | dd} t| | } z| |} Wn@tk r| d} Yn"tk r(| | j} YnX|| t jt j||||| jd } t|d| S)a\Handle GET request to display adbreak list. Args: request: HTTP request object channel_id: Primary key of the channel Returns: HttpResponse: Rendered template with adbreak list Raises: Http404: If channel with given ID doesn't exist r  start_dateend_daterprgrCrIrJrrrr~rr> date__lterrC-dater@) rr8 adbreak_typescategory_choicesrrrZselected_categoryrLzchannels/adbreak/list.html)rr&rOr0rrrrrrr*r[rnrrrIrrrQADBREAK_TYPE_CHOICESCATEGORY_CHOICESrr)r=rErrrr adbreak_typerCrIrr8rW adbreaks_pager?rBrBrCr0~sN        zAdbreakListView.getNrrBrBrBrCrss rc@s4eZdZdZeeedddZeeedddZ dS)ChannelHealthViewaView for monitoring channel health status. Displays real-time health information and recent health check history. Methods: get: Display channel health dashboard post: Trigger manual health check Template: channels/channel_health.html rc Cstt|d}t}|tdd}tjj||d }d}|j r||j }|tddkrl|j rfdnd }n|td dkrd }nd }||||j |j d } t |d| S)aXDisplay channel health dashboard. Args: request: HTTP request object channel_id: Primary key of the channel Returns: HttpResponse: Rendered template with health information Raises: Http404: If channel with given ID doesn't exist r )hoursr=unknownrAminutesrofflinewarningcritical)rr'r$rbrzchannels/channel/health.html) rr&rrrr*r[rnrrlast_health_checkrr) r=rErrrZlast_24hr$r'time_since_checkr?rBrBrCr0s,   zChannelHealthView.getc Cstt|d}z,|}td|r"dndtddWStk r~}z(tdt|tdd d WYSd }~XYnXd S) aNTrigger manual health check for the channel. Args: request: HTTP request object channel_id: Primary key of the channel Returns: JsonResponse: Health check results Raises: Http404: If channel with given ID doesn't exist r Trrz#Health check completed successfully)rrt timestamprF)rrrruN) rr& check_healthr rrrrr)r=rErrZ health_resultrrBrBrCrs"     zChannelHealthView.postN) r r rrrrr r0r rrBrBrBrCrs -rr rc@s(eZdZdZdeeeedddZdS)ChannelAPIViewazRESTful API view for channel operations. Provides JSON API endpoints for channel CRUD operations. Supports GET (list/detail), POST (create), PUT (update), DELETE operations. Methods: get: Retrieve channel(s) as JSON post: Create new channel via JSON put: Update existing channel via JSON delete: Delete channel via JSON Nrc CszH|rtt|d}|j|j|j|j|j|j|j|j |j |j |j |j |j|j|j|jr`|jnd|j|jd}t|WStjd}|jd}|r|t|dt|dB}|jd}|r|j|d }t|jd d }t|jd d } t|| } | |} dd| D|| | j | j!| "| #dd}t|WSWn<t$k r} ztdt%| iddWYSd} ~ XYnXdS)aRetrieve channel(s) as JSON. Args: request: HTTP request object channel_id: Optional channel ID for single channel retrieval Returns: JsonResponse: Channel data or list of channels r N)rrrrrrrtr5rrrCrrrrrrrrrrfrhrjrprqrIrJrrc Ss.g|]&}|j|j|j|j|j|j|jdqSrrrrrrrtrrrrrBrBrCrhs z&ChannelAPIView.get..rIrrHZpagesrrr2 paginationrrru)&rr&rrrrrrrtr5rrrCrrrrrrrrrr r[r\rrOr0rnrrrrIrrQrrrr) r=rErrdatar2rfrrrIrrW channels_pagerrBrBrCr0-sh          zChannelAPIView.get)N) r r rrrrrr r0rBrBrBrCrs rc@s eZdZdZeedddZdS)JingleAPIListViewzAPI view for listing all jingles. Provides JSON endpoint for retrieving all jingles with optional filtering. Methods: get: Retrieve all jingles as JSON rDc Csz|jd}|jd}|jd}tj}|r@|j|d}|rP|j|d}|r`|j|d}|d}t|jdd }t|jd d }t||}| |} d d | D|||j |j | | dd} t| WStk r} ztdt| iddWYSd} ~ XYnXdS)zRetrieve all jingles as JSON. Args: request: HTTP request object Returns: JsonResponse: List of all jingles rprrrrrrrIrJrrc SsLg|]D}t|j|j|j|j|jt|jj|jj|jjd|j dqS)rrr)rrrprrErr) rrrrprrErrrrrrrBrBrCrs z)JingleAPIListView.get..rIrr total_countrr)rrrrruN)rOr0r)r[r\rnrrrrIrQrrrr rr) r=rErrrrrIrrWrrrrBrBrCr0s<            zJingleAPIListView.getNr r rrrr r0rBrBrBrCrsrc@s"eZdZdZeeedddZdS)ChannelJinglesAPIViewzAPI view for retrieving jingles for a specific channel. Provides JSON endpoint for getting all jingles associated with a channel. Methods: get: Retrieve jingles for a channel as JSON rc Csztt|d}tjj|d}|jd}|r8|j|d}|jd}|rT|j|d}|d}t|j |j |j dd d |D| d }t |WStk r}zt d t|id dWYSd}~XYnXdS)TRetrieve jingles for a channel as JSON. Args: request: HTTP request object channel_id: Primary key of the channel Returns: JsonResponse: List of jingles for the channel Raises: Http404: If channel with given ID doesn't exist r rBrprrrrrc Ss6g|].}t|j|j|j|j|j|j|jdqS))rrrprrE file_pathr) rrrrprrErrrrrBrBrCrs z-ChannelJinglesAPIView.get..)rrrMrrruN)rr&r)r[rnrOr0rrrrrrr r) r=rErrrrrrrrBrBrCr0s,          zChannelJinglesAPIView.getNr r rrrrr r0rBrBrBrCrsrc@s eZdZdZeedddZdS)AdbreakAPIListViewzAPI view for listing all adbreaks. Provides JSON endpoint for retrieving all adbreaks with optional filtering. Methods: get: Retrieve all adbreaks as JSON rDc Csvz2|jd}|jd}|jd}|jd}|jd}|s^ttdd}|srt}tjj ||d}|r|j |d }|r|j |d }|r|j |d }| d d }t |jdd}t |jdd} t || } | |} dd| D|| | j| j| | d||dd} t| WStk rp} ztdt| iddWYSd} ~ XYnXdS)zRetrieve all adbreaks as JSON. Args: request: HTTP request object Returns: JsonResponse: List of all adbreaks rrrrprCrr~)r>rrrrrr@rIrJrrc Ssbg|]Z}t|j|j|j|jr0|jnd|j|j|jt|j j|j j |j j ddqS)Nr)rrrIend_timerErprCr) rrrrrIr rErprCrrrrrrBrBrCrG s z*AdbreakAPIListView.get..rrr)r8rrzrrruN)rOr0rrrrrr*r[rnrrrrIrQrrrr rr)r=rErrrrrCr8rIrrWrrrrBrBrCr0 sT              zAdbreakAPIListView.getNrrBrBrBrCr  sr c@s"eZdZdZeeedddZdS)ChannelAdbreaksAPIViewzAPI view for retrieving adbreaks for a specific channel. Provides JSON endpoint for getting all adbreaks associated with a channel. Methods: get: Retrieve adbreaks for a channel as JSON rc Cshz$tt|d}|jd}|jd}|sFttdd}|sZt}t j j |||d}|jd}|r|j |d}|jd }|r|j |d }| d d }t d d|D} |r| t|nd} t|j|j|jddd|D|t| dt| dd||dd} t| WStk rb} ztdt| iddWYSd} ~ XYnXdS)aVRetrieve adbreaks for a channel as JSON. Args: request: HTTP request object channel_id: Primary key of the channel Returns: JsonResponse: List of adbreaks for the channel Raises: Http404: If channel with given ID doesn't exist r rrrr~rrprrCrrr@css|]}|jpdVqdSrNrErabrBrBrC sz-ChannelAdbreaksAPIView.get..rrc SsHg|]@}t|j|j|j|jr0|jnd|j|j|jdqSN)rrrIr rErprC) rrrrrIr rErprCr rBrBrCr s z.ChannelAdbreaksAPIView.get..rrLtotal_durationZaverage_durationr )rr8 statisticsrzrrruN)rr&rOr0rrrrrr*r[rnrsumlenrrrrrrr r) r=rErrrrr8rrCr avg_durationrrrBrBrCr0u sP            zChannelAdbreaksAPIView.getNr rBrBrBrCrl src@s eZdZdZeedddZdS)ChannelHealthAPIViewzAPI view for channel health monitoring. Provides JSON endpoint for retrieving health status of all channels. Methods: get: Retrieve channel health data as JSON rDc CszXtjd}|jd}|r0|j|d}|jd}|dk r\|dk}|j|d}g}|D]z}|j}|rt |} | dkrd nd } | d krd } nd } | t |j|j|j|j|j| |r|ndddqdt|} tdd|D} tdd|D} || | | | | | | t| dkr8| | dndddt d}t|WStk r}ztdt |iddWYSd}~XYnXdS)zRetrieve channel health data as JSON. Args: request: HTTP request object Returns: JsonResponse: Health status of all channels rrtruonlineNtruerrgrrXrrW@)rrrrtrr'rrOcss|]}|drdVqdS)rrJNrBrchrBrBrCr sz+ChannelHealthAPIView.get..css|]}|ddkrdVqdS)r'rrJNrBr rBrBrCr s rrrJ)rrrhealthy_channelsZunhealthy_channelsoverall_health_percentage)r2summary generated_atrr)r&r[r\rrOr0rnlowerrrr total_secondsrrrrrrtrrrrrr r)r=rEr2rvZ online_filterrrrrrbrr'rrr"rrrBrBrCr0 sX           zChannelHealthAPIView.getNrrBrBrBrCr src@s eZdZdZeedddZdS)ChannelHealthDashboardViewaView for displaying channel health monitoring dashboard. Shows comprehensive health status and monitoring information for all channels. Methods: get: Display health dashboard Template: channels/health_dashboard.html rDc Cstjd}|}|jdd}||}d}d}d}d} |D]X} | j} | rt| } | dkrt|d7}q| dkr|d7}q|d7}qD| d7} qDtt dd d d d d tt dd dddd g} |||||||| t |dkr||dndd| d }t |d|S)zHandle GET request to display health dashboard. Args: request: HTTP request object Returns: HttpResponse: Rendered template with health dashboard rTrrrgrJrrArz Channel 1zHealth check passedr)rreventrtrz Channel 2zConnection timeoutrr) r2rrrr"warning_channelscritical_channelsunknown_channelsr# recent_eventszchannels/health_dashboard.html) r&r[r\rrrnrrrr'rrr)r=rEr2rrrr"r*r+r,rrbrr-r?rBrBrCr0 sR         zChannelHealthDashboardView.getN)r r rrrr r0rBrBrBrCr( s r(c@s eZdZdZeedddZdS)ChannelAPIListViewzAPI view for listing all channels. Provides JSON endpoint for retrieving all channels with optional filtering. Methods: get: Retrieve all channels as JSON rDc Cs.z|jdd}|jd}|jd}tj}|rT|t|dt|dB}|rd|j|d}|rt|j|d}|d }t |jd d }t |jd d }t ||}| |} dd| D|||j |j | | dd} t| WStk r(} ztdt| iddWYSd} ~ XYnXdS)zRetrieve all channels as JSON. Args: request: HTTP request object Returns: JsonResponse: List of all channels rfrgrprtrhrjrqrurrIrJrrc SsLg|]D}t|j|j|j|j|j|j|j|j|j |j r@|j ndd qS)N) rrrrrrrtrrrCr) rrrrrrrrtrrrCrrrrBrBrCr s z*ChannelAPIListView.get..rrrrN)rOr0rmr&r[r\rnrrrrrIrQrrrr rr) r=rErorrrtr2rIrrWrrrrBrBrCr0l sD           zChannelAPIListView.getNrrBrBrBrCr.c sr.c@s"eZdZdZeeedddZdS)ChannelAPIDetailViewzAPI view for retrieving detailed channel information. Provides JSON endpoint for getting detailed information about a specific channel. Methods: get: Retrieve channel details as JSON rEr!rFc Cs$ztt|d}t|jddd}tjj|ddddd }t jj|d }t |j |j |j|j|j|j|j|jr|jjnd|j|j|j|j|j|j|j|j|jr|jnd|j|j ||d d |Dd }t!|WSt"k r}zt!d t |iddWYSd}~XYnXdS)aCRetrieve channel details as JSON. Args: request: HTTP request object pk: Primary key of the channel Returns: JsonResponse: Detailed channel information Raises: Http404: If channel with given ID doesn't exist r rrr5rBrr@NrAcSs2g|]*}t|j|j|j|j|jdqS))rrrIrErp)rrrrrIrErpr rBrBrCr sz,ChannelAPIDetailView.get..)rrrrrrrtrrr5rrrCrrrrrrrrZrr$rrru)#rr&rrZrr*r[rnrr)rrrrrrrrrtrrrr5rrrCrrrrrrrrr r) r=rEr!rrZr$rrrrBrBrCr0 sB  " zChannelAPIDetailView.getNr rBrBrBrCr/ sr/c@s eZdZdZeedddZdS)ChannelZoneAPIListViewzAPI view for listing all channel zones. Provides JSON endpoint for retrieving all zones with optional filtering. Methods: get: Retrieve all zones as JSON rDc Csz|jdd}tj}|r<|t|dt|dB}|d}t |jdd}t |jdd }t ||}| |}d d |D|||j |j ||d d }t|WStk r} ztdt| iddWYSd} ~ XYnXdS)zRetrieve all zones as JSON. Args: request: HTTP request object Returns: JsonResponse: List of all zones rfrgrhrkrrIrJrrcSs2g|]*}t|j|j|j|j|jdqS))rrr5channels_countr)rrrr5r2rrr)rrwrBrBrCr sz.ChannelZoneAPIListView.get..r)rZrrrruN)rOr0rmr'r[r\rnrrrrrIrQrrrr rr) r=rErorZrIrrW zones_pagerrrBrBrCr0 s8       zChannelZoneAPIListView.getNrrBrBrBrCr1 sr1c@s"eZdZdZeeedddZdS)ZoneChannelsAPIViewzAPI view for retrieving channels in a specific zone. Provides JSON endpoint for getting all channels associated with a zone. Methods: get: Retrieve channels in a zone as JSON )rEzone_idrFc CszVtt|d}tjj|dd}t|j|j|j ddd|D| d}t |WSt k r}zt dt|id d WYSd }~XYnXd S) aERetrieve channels in a zone as JSON. Args: request: HTTP request object zone_id: Primary key of the zone Returns: JsonResponse: List of channels in the zone Raises: Http404: If zone with given ID doesn't exist r rZr)rrr5c Ss2g|]*}t|j|j|j|j|j|j|jdqSr)rrrrrrrrtrrrBrBrCrY s z+ZoneChannelsAPIView.get..)rwr2rrrruN) rr'r&r[rnrrrrr5rr r)r=rEr5rwr2rrrBrBrCr0A s     zZoneChannelsAPIView.getNr rBrBrBrCr48 sr4c@s0eZdZdZeedddZeedddZdS)ChannelZoneListViewaEnhanced view for displaying a list of all channel zones. Features: - Advanced filtering by status, timezone, and activity - Enhanced search across multiple fields - Statistics and analytics - Bulk operations support - Export functionality - AJAX support for dynamic updates Methods: get: Handle GET requests to display zone list post: Handle bulk operations Template: channels/zone/list.html rDc CsB|jdd}|jdd}|jdd}|jdd}|jdd}|jd d }t|jd d }tjjtd td tdddtdd} |r| t|dt|dBt|dBt|dB} |r|dkr| j dd} n|dkr| j dd} |r| j |d} dddddg} || kr<|dkr0d|}| |} n | d} | } | j dd } | j dd } tjj ddd  d}t| |}z||}Wn@tk r|d }Yn"tk r||j}YnX|||||d||| | | |d! }|jd"d#kr6tt|d$|j| | | d%St|d&|S)'zHandle GET request to display enhanced zone list. Args: request: HTTP request object Returns: HttpResponse: Rendered template with zone list and statistics rfrgrtrsortrorderascrIrJrrr2r)Zchannels__status)rnchannel_relations)r2active_channels_countrelations_countrh)code__icontainsrk)Ztimezone__icontainsTrrFrr2rdesc-)flat) rZrorvtimezone_filterr sort_orderrrK active_zonesinactive_zonesavailable_timezonesrGrHzchannels/zone/list_partial.html)htmlrKrDrEzchannels/zone/list.html)rOr0rmrr'r[rrrrnrr values_listrrrIrrrQlstriprKr rcontentdecode)r=rErorvrBrrCrIrrZrrKrDrErFrWr3r?rBrBrCr0 s         zChannelZoneListView.getc CsB|jd}|jd}|s*tdddSztjj|d}|dkrb|jdd }t ||d n|d kr|jdd }t ||d nd|d kr|jdd }| rtdddWS| }| t ||dntdddWStdddWStk r<}z tddt|dWYSd}~XYnXdS)zHandle bulk operations on zones. Args: request: HTTP request object with bulk operation data Returns: JsonResponse: Result of bulk operation rzone_idsFzNo zones selected.rr)id__inactivateTrz zones activated successfully. deactivatez zones deactivated successfully.r)Zchannels__isnullz2Cannot delete zones that have associated channels.z zones deleted successfully.zInvalid action.z!Operation completed successfully.zError: N)rr0getlistr r'r[rnr;rrrexistsrrrr) r=rErrLrZupdatedZzones_with_channels deleted_countrrBrBrCr s4     zChannelZoneListView.postNrrBrBrBrCr7p s^r7c@s"eZdZdZeeedddZdS)ChannelZoneDetailViewaEnhanced view for displaying detailed information about a specific channel zone. Features: - Comprehensive zone information and statistics - Associated channels with filtering and pagination - Zone-specific configurations and relationships - Health monitoring and status tracking - Export and reporting capabilities Methods: get: Handle GET requests to display zone details Template: channels/zone/detail.html r0cCstt|d}|jdd}|jdd}|jdd}|jdd}t|jdd }tjj|d j t d t d t d d d d} |r| t |dt |dBt |dB} |r| j|d} |r| j|d} | dd} tjj|d dddd} | } | jdd} | jdd} | jdd}| dj t dd d!}| }| jd"d#}| jd$d%}| jdd&}ttjd'd(}| j|d)}| jd"d*}| jd+d*}t| |}z||}Wn@tk r|d}Yn"tk r&||j}YnXtj}tj}||| ||||| | | |||||||||||d,}|jd-d.krtt |d/|j!"| | | d0St |d1|S)2apHandle GET request to display enhanced zone details. Args: request: HTTP request object pk: Primary key of the zone to display Returns: HttpResponse: Rendered template with comprehensive zone details Raises: Http404: If zone with given ID doesn't exist r channel_searchrgchannel_statusrrrIrJrrr6zone_relationsepgprogram_setchannelschedule_set)Zzone_relations_countepg_programs_countschedules_countrZrhrj)Zchannel_number__icontainsrurqrrrwrcodecz -priority channel__namerr maintenancerrrTrnonevpn_typeftp_hostrr~)created_at__gterF)rwr2rXrVrWrrrrrrmaintenance_channelsrrrtotal_relationsactive_relations vpn_relations ftp_relationsravailable_statusesavailable_typesrGrHz#channels/zone/channels_partial.html)rGrrrzchannels/zone/detail.html)#rr'rOr0rmrr&r[rnrrr]r^rrr-rrexcluderrrrrrIrrrQrrrKr rrJrK)r=rEr!rwrVrWrrrIrr2rXrrrrgrrhrirjrkZthirty_days_agorrrrWrrlrmr?rBrBrCr0 s       !zChannelZoneDetailView.getNr r rrrrr r0rBrBrBrCrU srUc@s0eZdZdZeedddZeedddZdS)ChannelZoneCreateViewaEnhanced view for creating new channel zones. Features: - Comprehensive form validation - Support for all zone fields including timezone - Duplicate detection and prevention - AJAX form submission support - Activity logging Methods: get: Display zone creation form post: Process form submission and create zone Template: channels/zone/form.html rDc Cs8ddddddddd d d d d g }dd|dd}t|d|S)zDisplay enhanced zone creation form. Args: request: HTTP request object Returns: HttpResponse: Rendered template with empty form and timezone options UTCAmerica/New_YorkAmerica/ChicagoAmerica/DenverAmerica/Los_Angeles Europe/London Europe/Paris Europe/Berlin Europe/Madrid Europe/Rome Asia/Tokyo Asia/ShanghaiAustralia/SydneyzCreate New Channel Zonez Create ZoneT)rrcommon_timezones is_createchannels/zone/form.html)r)r=rEr~r?rBrBrCr0 s( zChannelZoneCreateView.getc Csz|jdd}|jdd}|jdd}|jdd}|jddk}g}|st|d nt|d kr|d |s|d nrr redirect_urlr rFrMNzError creating zone: )rr0rmupperrrr'r[rnrRrrrr.rrrrr%rrKr rr!rrr) r=rErrr5 timezone_valrerrorsrrwr error_msgrBrBrCr st                zChannelZoneCreateView.postNrrBrBrBrCrp s"rpc@s4eZdZdZeeedddZeeedddZdS)ChannelZoneUpdateViewaEnhanced view for updating existing channel zones. Features: - Comprehensive form validation with change tracking - Support for all zone fields including timezone - Duplicate detection (excluding current zone) - AJAX form submission support - Activity logging with change details Methods: get: Display zone update form post: Process form submission and update zone Template: channels/zone/form.html r0c Csltt|d}dddddddd d d d d dg }|j|krH||j||d|jd|dd}t|d|S)acDisplay enhanced zone update form. Args: request: HTTP request object pk: Primary key of zone to update Returns: HttpResponse: Rendered template with pre-filled form and timezone options Raises: Http404: If zone with given ID doesn't exist r rqrrrsrtrurvrwrxryrzr{r|r}z Update Zone: z Update ZoneF)rwrrr~rr)rr'rrr8rr)r=rEr!rwr~r?rBrBrCr0@ s2    zChannelZoneUpdateView.getc Cs\tt|d}zf|j|j|j|j|jd}|jdd }|jdd }|jdd }|jdd }|jd d k} g} |s| d nt |d kr| d |s| dnHt |dkr| dn0tj j|dj|jdr| d|dtj j|dj|jdr8| d|d| rd| D]} t|| qB|||WS||_||_||_||_| |_|g} |D]:\} }t|| }||kr| | d|d|dq| rtj j|jdd|jd|jd|jdd| t|dt|d |jd!|jd"d#krftd$d |jd!t d%d&|jid'd(WSt!d%|jdWSt"k r}zRd)|}t|||jd"d#krtd*|d+WYS|||WYSd,}~XYnrt#k rV}zRd-|}t|||jd"d#kr6td*|d+WYS|||WYSd,}~XYnXd,S).ayProcess enhanced zone update form submission. Args: request: HTTP request object with form data pk: Primary key of zone to update Returns: HttpResponse: Redirect to zone detail on success, or form with errors Raises: Http404: If zone with given ID doesn't exist r rrrgrr5rrqrrrrrrrrrrrrrz: "u" → ""r;r'zUpdated channel zone: rz ). Changes: ;rrrrGrHTrr!rrrFrMNzError updating zone: )$rr'rrr5rrrr0rmrrrr[rnrnr!rRrrritemsrr.rrrjoinr%rrKr rrrr)r=rEr!rwZoriginal_valuesrrr5rrrrchangesfieldoriginal_value new_valuerrrBrBrCrn s                   zChannelZoneUpdateView.postN r r rrrrr r0rrBrBrBrCr/ s.rc@s4eZdZdZeeedddZeeedddZdS)ChannelZoneDeleteViewaEnhanced view for deleting channel zones. Features: - Comprehensive dependency checking - Detailed impact analysis before deletion - Force deletion option for administrators - AJAX deletion support - Activity logging with dependency details Methods: get: Display deletion confirmation with impact analysis post: Process deletion request with safety checks Template: channels/zone/confirm_delete.html r0cCstt|d}tjj|d}|}|jdd}tjj|d}|}|jdd} |jdd } |jd d } d } d } |D] }| |j7} | |j 7} q|d kp|d kp| d kp| d k}|j j p|j j jd d }||||| | | | | |||ddd }t|d|S)aeDisplay enhanced zone deletion confirmation. Args: request: HTTP request object pk: Primary key of zone to delete Returns: HttpResponse: Rendered confirmation template with impact analysis Raises: Http404: If zone with given ID doesn't exist r r6rrur]TrrarbrgrdrAdministratorsrNr) rwr2r<r=active_relations_countvpn_relations_countftp_relations_countr[r\has_dependenciescan_force_deleter2z!channels/zone/confirm_delete.html)rr'r&r[rnrr-rnrYrZr is_superusergroupsrRr)r=rEr!rwr2r2r<rXr=rrrr[r\rrrr?rBrBrCr0 sH  zChannelZoneDeleteView.getc CsNtt|d}|j}|j}|jddk}ztjj|d}| }t jj|d } |dkr|sd|d|d } t || |j d d krtd | d WS|||WS|r|jjs|jjjddsd} t || |j d d krtd | d WS|||WSg} |dkr0| |d| dkrJ| | d|tjj|jdd|d|d|d| rd| ndd|t|dd|d} |r| r| dd| d 7} t || |j d d krtd!| td"d#WStd"WStk rH} z&t |d$| td%|dWYSd&} ~ XYnXd&S)'a\Process enhanced zone deletion request. Args: request: HTTP request object with form data pk: Primary key of zone to delete Returns: HttpResponse: Redirect to zone list on success Raises: Http404: If zone with given ID doesn't exist r  force_deleterr6r]rzCannot delete zone "z" because it has z> associated channels. Use force delete if you want to proceed.rGrHFrMrrzCYou do not have permission to force delete zones with dependencies.rz zone relationsrr'zDeleted channel zone: rz). Dependencies: z, Nonez. Force delete: rrrz Warning: This also removed r.Tzchannels:zone_listrzError deleting zone: rN)rr'rrrr0r&r[rnrr-rrrKr rrrrRrrr.rrr%rrrr)r=rEr!rw zone_nameZ zone_coderr2r2r=rZdependency_infoZ success_msgrrBrBrCr*s`   &   *     zChannelZoneDeleteView.postNrrBrBrBrCr s=rc@s0eZdZdZeedddZeedddZdS)JingleCreateViewaZView for creating new jingles. Handles both GET requests to display the creation form and POST requests to process form submission and create new jingle instances. Methods: get: Display jingle creation form post: Process form submission and create jingle Template: channels/jingle_form.html rDcCs4tjjddd}|tjtjddd}t|d|S)zDisplay jingle creation form. Args: request: HTTP request object Returns: HttpResponse: Rendered template with empty form rrurzCreate New Jinglez Create Jingle)r2rrrrzchannels/jingle/form.html)r&r[rnrr)rrrr=rEr2r?rBrBrCr0s zJingleCreateView.getc CsVz|jd}|jdd}|jd}|jd}|jd}|jd}t|||gsvt|d||WStt|d }t j j |||||rt |nd |d } t |d | jd td| jd WStk r} z$t|d| ||WYSd } ~ XYnDtk rP} z$t|d| ||WYSd } ~ XYnXd S)zProcess jingle creation form submission. Args: request: HTTP request object with form data Returns: HttpResponse: Redirect to jingle detail on success, or form with errors rrrgrprrEfilez%Channel, name, and type are required.r N)rrrprrErJingle "rchannels:jingle_detailrzError creating jingle: )rr0rmrr\rrrr&r)r[rrrrrr!rr) r=rErrrrrE file_uploadrrrrBrBrCrs6          zJingleCreateView.postNrrBrBrBrCr~s rc@s"eZdZdZeeedddZdS)JingleDetailViewaView for displaying detailed information about a specific jingle. Shows jingle details including metadata and playback information. Methods: get: Handle GET requests to display jingle details Template: channels/jingle_detail.html r0cCs$tt|d}||jd}t|d|S)aaHandle GET request to display jingle details. Args: request: HTTP request object pk: Primary key of the jingle to display Returns: HttpResponse: Rendered template with jingle details Raises: Http404: If jingle with given ID doesn't exist r rrzchannels/jingle/detail.htmlrr)rrr=rEr!rr?rBrBrCr0s zJingleDetailView.getNrorBrBrBrCrs rc@s4eZdZdZeeedddZeeedddZdS)JingleUpdateViewa3View for updating existing jingles. Handles both GET requests to display the update form and POST requests to process updates. Methods: get: Display jingle update form post: Process form submission and update jingle Template: channels/jingle_form.html r0cCsJtt|d}tjjddd}||tjtjd|jdd}t |d|S) aKDisplay jingle update form. Args: request: HTTP request object pk: Primary key of jingle to update Returns: HttpResponse: Rendered template with pre-filled form Raises: Http404: If jingle with given ID doesn't exist r rrurzUpdate Jingle: z Update Jingle)rr2rrrrzchannels/jingle_form.html) rr)r&r[rnrrrrr)r=rEr!rr2r?rBrBrCr0s  zJingleUpdateView.getc CsZtt|d}z|jd}|r,tt|d|_|jddpB|j|_|jdpV|j|_|jdpj|j |_ |jd}|rt ||_ |j d}|r||_ |t|d |jd td |jdWStk r}z&t|d ||||WYSd }~XYnFtk rT}z&t|d||||WYSd }~XYnXd S)axProcess jingle update form submission. Args: request: HTTP request object with form data pk: Primary key of jingle to update Returns: HttpResponse: Redirect to jingle detail on success, or form with errors Raises: Http404: If jingle with given ID doesn't exist r rrrgrprrErrrrrNzError updating jingle: )rr)rr0r&rrmrrprrrErrrrrrr!rrr)r=rEr!rrrErrrBrBrCrs.      zJingleUpdateView.postNrrBrBrBrCrs rc@s4eZdZdZeeedddZeeedddZdS)JingleDeleteViewa4View for deleting jingles. Handles both GET requests to display confirmation page and POST requests to perform the actual deletion. Methods: get: Display deletion confirmation post: Process deletion request Template: channels/jingle_confirm_delete.html r0cCs$tt|d}||jd}t|d|S)aMDisplay jingle deletion confirmation. Args: request: HTTP request object pk: Primary key of jingle to delete Returns: HttpResponse: Rendered confirmation template Raises: Http404: If jingle with given ID doesn't exist r rz#channels/jingle/confirm_delete.htmlrrrBrBrCr0Ms zJingleDeleteView.getc Cstt|d}|j}|j}z,|t|d|dtd|jdWSt k r}z&t |d|td|dWYSd}~XYnXdS) a[Process jingle deletion request. Args: request: HTTP request object with form data pk: Primary key of jingle to delete Returns: HttpResponse: Redirect to jingle list on success Raises: Http404: If jingle with given ID doesn't exist r rrzchannels:jingle_listrzError deleting jingle: rN) rr)rrrrrrr!rr)r=rEr!r jingle_namerrrBrBrCrbs zJingleDeleteView.postNrrBrBrBrCr@s rc@s0eZdZdZeedddZeedddZdS)AdbreakCreateViewa_View for creating new adbreaks. Handles both GET requests to display the creation form and POST requests to process form submission and create new adbreak instances. Methods: get: Display adbreak creation form post: Process form submission and create adbreak Template: channels/adbreak_form.html rDcCs4tjjddd}|tjtjddd}t|d|S)zDisplay adbreak creation form. Args: request: HTTP request object Returns: HttpResponse: Rendered template with empty form rrurzCreate New AdbreakzCreate Adbreak)r2rrrrchannels/adbreak/form.html)r&r[rnrr*rrrrrBrBrCr0s zAdbreakCreateView.getc Cs`z|jd}|jd}|jd}|jd}|jd}|jd}|jd}t||||gs~t|d||WStt|d } tjj | ||||rt |nd ||d } t |d | j d t d| jd WStk r} z$t|d| ||WYSd } ~ XYnDtk rZ} z$t|d| ||WYSd } ~ XYnXd S)zProcess adbreak creation form submission. Args: request: HTTP request object with form data Returns: HttpResponse: Redirect to adbreak detail on success, or form with errors rrrIr rErprCz1Channel, date, start time, and type are required.r N)rrrIr rErprCz!Adbreak created successfully for rchannels:adbreak_detailrzError creating adbreak: )rr0r\rrrr&r*r[rrrrrr!rr) r=rErrrIr rErrCrrrrBrBrCrs:            zAdbreakCreateView.postNrrBrBrBrCrs rc@s"eZdZdZeeedddZdS)AdbreakDetailViewaView for displaying detailed information about a specific adbreak. Shows adbreak details including timing and metadata. Methods: get: Handle GET requests to display adbreak details Template: channels/adbreak_detail.html r0cCs$tt|d}||jd}t|d|S)aeHandle GET request to display adbreak details. Args: request: HTTP request object pk: Primary key of the adbreak to display Returns: HttpResponse: Rendered template with adbreak details Raises: Http404: If adbreak with given ID doesn't exist r rrzchannels/adbreak/detail.htmlrr*rrr=rEr!rr?rBrBrCr0s zAdbreakDetailView.getNrorBrBrBrCrs rc@s4eZdZdZeeedddZeeedddZdS)AdbreakUpdateViewa7View for updating existing adbreaks. Handles both GET requests to display the update form and POST requests to process updates. Methods: get: Display adbreak update form post: Process form submission and update adbreak Template: channels/adbreak_form.html r0cCsTtt|d}tjjddd}||tjtjd|jj d|j dd}t |d |S) aNDisplay adbreak update form. Args: request: HTTP request object pk: Primary key of adbreak to update Returns: HttpResponse: Rendered template with pre-filled form Raises: Http404: If adbreak with given ID doesn't exist r rrurzUpdate Adbreak: z - zUpdate Adbreak)rr2rrrrr) rr*r&r[rnrrrrrrr)r=rEr!rr2r?rBrBrCr0s zAdbreakUpdateView.getc Csbtt|d}z|jd}|r,tt|d|_|jd}|rB||_|jd}|rX||_|jd}|rn||_|jd}|rt ||_ |jdp|j |_ |jdp|j |_ | t|d td |jdWStk r} z&t|d | |||WYSd } ~ XYnFtk r\} z&t|d | |||WYSd } ~ XYnXd S)a|Process adbreak update form submission. Args: request: HTTP request object with form data pk: Primary key of adbreak to update Returns: HttpResponse: Redirect to adbreak detail on success, or form with errors Raises: Http404: If adbreak with given ID doesn't exist r rrrIr rErprCzAdbreak updated successfully.rrNzError updating adbreak: )rr*rr0r&rrrIr rrErprCrrrrr!rrr) r=rEr!rrrrIr rErrBrBrCrs8         zAdbreakUpdateView.postNrrBrBrBrCrs rc@s4eZdZdZeeedddZeeedddZdS)AdbreakDeleteViewa6View for deleting adbreaks. Handles both GET requests to display confirmation page and POST requests to perform the actual deletion. Methods: get: Display deletion confirmation post: Process deletion request Template: channels/adbreak_confirm_delete.html r0cCs$tt|d}||jd}t|d|S)aPDisplay adbreak deletion confirmation. Args: request: HTTP request object pk: Primary key of adbreak to delete Returns: HttpResponse: Rendered confirmation template Raises: Http404: If adbreak with given ID doesn't exist r rz$channels/adbreak/confirm_delete.htmlrrrBrBrCr0Ws zAdbreakDeleteView.getc Cstt|d}|j}z$|t|dtd|jdWStk rz}z&t |d|td|dWYSd}~XYnXdS)a_Process adbreak deletion request. Args: request: HTTP request object with form data pk: Primary key of adbreak to delete Returns: HttpResponse: Redirect to adbreak list on success Raises: Http404: If adbreak with given ID doesn't exist r zAdbreak deleted successfully.zchannels:adbreak_listrzError deleting adbreak: rN) rr*rrrrrr!rr)r=rEr!rrrrBrBrCrls  zAdbreakDeleteView.postNrrBrBrBrCrJs rc@s"eZdZdZeeedddZdS) JingleAPIViewzAPI view for jingle operations. Provides JSON endpoints for jingle management within channels. Methods: get: Retrieve jingles for a channel rc Cstt|d}ztjj|dd}|jd}|r>|j|d}|jd}|rZ|j|d}t|jdd }t|jd d }t ||} | |} |j |j |j d d d| D||| j| j| | dd} t| WStk r} ztdt| iddWYSd} ~ XYnXdS)rr rBrrprrrrIrJrrrc Ss>g|]6}|j|j|j|j|j|jr*|jjnd|jdqS)N)rrrprrEfile_urlr) rrrprrErrrrrrBrBrCrs z%JingleAPIView.get..r)rrrrrruN)rr&r)r[rnrrOr0rrrIrrrrrQrrr rr) r=rErrrrrrIrrWrrrrBrBrCr0s>          zJingleAPIView.getNr r rrrrr r0rBrBrBrCrsrc@s"eZdZdZeeedddZdS)AdbreakAPIViewzAPI view for adbreak operations. Provides JSON endpoints for adbreak data retrieval and analysis. Methods: get: Retrieve adbreaks for a channel with filtering rc Cstt|d}zh|jd}|jd}|sFttdd}|sZt}t j j |||d}|jd}|r|j |d}|jd }|r|j |d }| d d }t d d|D} |r| t|nd} t|jdd} t|jdd} t|| } | | }|j|j|jd||dt|t| dt| dddd|D| | | j| j||dd}t|WStk r}ztdt|iddWYSd}~XYnXdS) aVRetrieve adbreaks for a channel as JSON. Args: request: HTTP request object channel_id: Primary key of the channel Returns: JsonResponse: List of adbreaks with statistics Raises: Http404: If channel with given ID doesn't exist r rrrr~rrprrCrrr@css|]}|jpdVqdSrrrrBrBrCr sz%AdbreakAPIView.get..rrIrJrrrr rrc SsNg|]F}|j|j|jr$|jnd|jr6|jnd|j|j|jdqSr)rrrrIr rErprCr rBrBrCr#s z&AdbreakAPIView.get..r)rrzrr8rrrruN)rr&rOr0rrrrrr*r[rnrrrrrrIrrrrrrQrrr rr)r=rErrrrr8rrCrrrIrrWrrrrBrBrCr0sf            % zAdbreakAPIView.getNrrBrBrBrCrsrc@s"eZdZdZeeedddZdS)ChannelStatsAPIViewzAPI view for channel statistics and analytics. Provides aggregated statistics and metrics for channels. Methods: get: Retrieve channel statistics rc Cs~tt|d}z.t}|}|tdd}|tdd}tjj||d }tjj||d } tjj||d } tjj||dj t ddd pd } tjj||dj t ddd pd } t jj|d  } d }|j |j|j|j|jd || | t| dt| ddd| i||jr"|jndd|d}t|WStk rx}ztdt|iddWYSd}~XYnXdS)aPRetrieve channel statistics as JSON. Args: request: HTTP request object channel_id: Primary key of the channel Returns: JsonResponse: Channel statistics and metrics Raises: Http404: If channel with given ID doesn't exist r rr~r)rrr=rErGrHrrBr)rrrrtrr)r{rr week_durationmonth_durationrMN)rOr)rZ adbreak_statsZ content_statsZ health_statsr%rrru)rr&rrrrr*r[rnrrQrr)rrrrtrrrrr rr)r=rErrrr{rZ month_agorNZ week_adbreaksZmonth_adbreaksrrrMrOrrrBrBrCr0Hsx    zChannelStatsAPIView.getNrrBrBrBrCr?sr)hrrrtypingrrrrrdjango.contrib.authr django.httprr r r r r django.shortcutsrrr django.urlsr django.viewsrdjango.core.paginatorrrrdjango.contribrdjango.db.modelsrrrrrr django.utilsrdjango.core.exceptionsrdjango.views.decorators.csrfrdjango.utils.decoratorsr django.confr!django.contrib.auth.mixinsr"django.utils.translationr#r<django.core.cacher$apps.common.utilsr%apps.channels.modelsr&r'r(r)r*r+r,r-apps.activities.modelsr.r/rrrrrrrrrrr rrr(r.r/r1r4r7rUrprrrrrrrrrrrrrrBrBrBrCs                  ( DKY[@AO] cLA\ZONNFA8! .#L"T?N"[?Mi