o 0ehe@sddlZddlmZddlmZddlmZddlmZ ddl m Z m Z ddl mZGdd d eZGd d d eZGd d d eZGdddeZGdddeZGdddeZdS)N)Decimal)models)reverse) gettext_lazy)MinValueValidatorMaxValueValidator) BaseModelc @seZdZdZdedfdedfdedfded fd ed fd ed fgZejdej deddZ ej dededdZ ej ddededdZ ej deededdZejdejdddeded d!Zejdded"ed#d$Zejdded%ed&d$Zejd'd(dded)ed*d+Zejd'd(dded,ed-d+Zej d.d/ed0ed1d2Zejded3ed4d5ZGd6d7d7Zd8d9Zd:d;Zedd?Z d@S)AGeographicZonea Geographic zones for targeted TV advertising. Represents geographic regions where TV channels broadcast and where advertising campaigns can be targeted. Supports hierarchical zones (country > state > city > DMA) for precise geographic targeting. countryCountrystatezState/ProvincecityCityZdmazDesignated Market AreaZpostalz Postal CodeZcustomz Custom ZoneTFzZone ID primary_keydefaulteditable verbose_namez Zone Namez@Name of the geographic zone (e.g., "New York DMA", "California") max_lengthr help_textz Zone Codez7Unique identifier code for the zone (e.g., "NYC", "CA")runiquerrz Zone TypezType of geographic zonerchoicesrrself child_zonesz Parent Zonez4Parent geographic zone for hierarchical organization on_deletenullblank related_namerrZ Populationz(Total population in this geographic zoner!r"rrz TV Householdsz+Number of households with television access LatitudezGeographic latitude coordinate max_digitsdecimal_placesr!r"rr LongitudezGeographic longitude coordinate2UTCZTimezonez9Primary timezone for this zone (e.g., "America/New_York")rrrrActivez5Whether this zone is active for advertising targetingrrrc@sPeZdZedZedZddgZejddgdejddgdejdgdgZ d S) zGeographicZone.MetazGeographic ZonezGeographic Zones zone_typename is_activefields parent_zonecodeN __name__ __module__ __qualname___rverbose_name_pluralorderingrIndexindexesrArAHC:\Users\vibe-look\OneDrive\Desktop\Adtlas_V\src\apps\channels\models.pyMetahs rCcCs|jd|dSN ())r2Zget_zone_type_displayrrArArB__str__rzGeographicZone.__str__cCtdd|jidS)Nzchannels:zone_detailpkkwargsrrKrGrArArBget_absolute_urluzGeographicZone.get_absolute_urlcCs4|jg}|j}|r|d|j|j}|s d|S)z,Get the full hierarchical path of this zone.rz > N)r2r6insertjoin)rZ hierarchycurrentrArArBfull_hierarchyxs zGeographicZone.full_hierarchycC|jjddS)z$Get the count of direct child zones.Tr3N)rfiltercountrGrArArBget_child_zones_countsz$GeographicZone.get_child_zones_countN)!r9r:r;__doc__r<Z ZONE_TYPESr UUIDFielduuiduuid4id CharFieldr2r7r1 ForeignKeyCASCADEr6PositiveIntegerField population tv_households DecimalFieldlatitude longitudetimezone BooleanFieldr3rCrHrOpropertyrTrYrArArArBr s          r c @seZdZdZdedfdedfdedfded fd ed fd ed fgZejdededdZejdededdZ ejdeededdZ ej dej dddededdZ ejddeded d!Zejdded"ed#d$Zejded%ed&d'Zejded(ed)d'Zejded*ed+d'Zejeded,ed-d.Zejded/ed0d1ZGd2d3d3Zd4d5Zd6d7Zed8d9Zd:d;Z ded?d@Zejed+edAedBdCZejd*eedDedEd3Zejed+edFedGdCZejd+edHedIdJZejd+edKedLdMZejd+edNedOdMZej d+edPedQdMZ!ej"d+d+edRedSdTZ#ejd+edUedVdJZ$ejdWedXedYdJZ%ejd+edZed[dJZ&Gd\d]d]Z'd^d_Z(d`daZ)e*dbdcZ+dddeZ,dfS)g TVChannelz Television channels with comprehensive metadata and relationships. Represents individual TV channels with their broadcasting details, network affiliations, geographic coverage, and advertising inventory. Z terrestrialzTerrestrial/Over-the-Airrnz Cable ChannelrozSatellite ChannelZiptvz IPTV ChannelrpzStreaming Channelradioz Radio StationZgeneralzGeneral EntertainmentnewszNews & InformationsportsZSportsZmoviesZMoviesZkidszChildren's ProgrammingZ lifestylezLifestyle & RealityZ documentaryZ DocumentaryZmusicZMusicZ religiousZ ReligiousZ educationalZ EducationalZshoppingZShoppingZadultz Adult Contentrz Channel NamezFull name of the TV channelrrTz Call Signz:Official call sign or identifier (e.g., "WABC-TV", "ESPN")rzChannel Numberz?Channel number on cable/satellite systems (e.g., "7.1", "ESPN")z Channel TypezType of broadcasting technologyrrZNetworkz7Broadcasting network that owns or operates this channel)r r#rrChannelCoveragezCoverage Zonesz0Geographic zones where this channel is available)throughr#rrr%enzPrimary Languagez4Primary language of channel content (ISO 639-1 code)r.zSecondary Languagesz-Additional languages supported by the channelrzzContent Categoryz'Primary content category of the channelrxryz HD Availablez1Whether the channel broadcasts in high definitionr0rtzOfficial website of the channelrurvzURL to the channel logo imagerwz7Detailed description of the channel and its programmingz Launch Datez"Date when the channel was launchedr$r/z9Whether this channel is currently active and broadcastingFzPremium Channelz%Whether this is a premium/pay channelzAdvertising Enabledz.Whether advertising is allowed on this channelc@sheZdZedZedZddgZejddgdejddgdejd gdejd gdejdgdgZ d S) zTVChannel.Metaz TV Channelz TV Channelschannel_numberr2 channel_typer3r4networkcontent_category call_signNr8rArArArBrC|   rCcCr~rD)r2rrGrArArBrHrzTVChannel.__str__cCrJ)Nzchannels:channel_detailrKrLrNrGrArArBrOrPzTVChannel.get_absolute_urlcCstdd|jjdddDS)z3Calculate total population covered by this channel.css|] }|jjp dVqdS)rN)zonerc).0ZcoveragerArArB s  z6TVChannel.total_coverage_population..T)Zzone__is_activer3N)sumcoverage_detailsrWrGrArArBtotal_coverage_populations z#TVChannel.total_coverage_populationcCs|jj|ddS)z$Get coverage zones filtered by type.T)r1r3N)coverage_zonesrW)rr1rArArBget_coverage_zones_by_typesz$TVChannel.get_coverage_zones_by_typeN)-r9r:r;rZr<Z CHANNEL_TYPESZCONTENT_CATEGORIESrr_r2rrrr`rkrarManyToManyFieldr rZprimary_languagerrZsecondary_languagesrrrriZ hd_availablerrrrrrZ launch_dater3Z is_premiumZadvertising_enabledrCrHrOrjrrrArArArBrs                    rc @seZdZdZdedfdedfdedfded fd ed fgZejd ej d eddZ ej e ej deddZej eej deddZejdedededdZejddededgedededd Zejd d ed!ed"d#Zejddd d ededged$ed%d&Zejd d ed'ed(d#Zejd ed)ed*d+Zejd ed,ed-d.Z Gd/d0d0Z!d1d2Z"e#d3d4Z$d5S)6rz Through model for Channel-Zone relationships with coverage details. Defines the specific coverage relationship between a TV channel and a geographic zone, including signal strength, availability, and subscriber information. Z excellentzExcellent (90-100%)Zgoodz Good (70-89%)Zfairz Fair (50-69%)Zpoorz Poor (30-49%)ZmarginalzMarginal (10-29%)TFz Coverage IDrrChannelr r#rZchannel_coverageZonerzSignal Strengthz(Quality of signal reception in this zone)rrrrrrdz100.00zCoverage Percentagez.Percentage of zone area covered by the channel)r)r* validatorsrrrzSubscriber Countz"Number of subscribers in this zoner$zPenetration Ratez7Percentage of households that subscribe to this channel)r)r*r!r"rrrzLaunch Date in Zonez3Date when the channel became available in this zoner/z)Whether this coverage is currently activer0Notesz,Additional notes about coverage in this zoneruc@sVeZdZedZedZddgZddgZej ddgdej dgdej dgdgZ d S) zChannelCoverage.MetazChannel Coveragechannelr channel__nameZ zone__namer4signal_strengthr3N r9r:r;r<rr=unique_togetherr>rr?r@rArArArBrC  rCcCs|jjd|jjS)Nz in )rr2rrGrArArBrHrIzChannelCoverage.__str__cCs(|jjr|jrt|jj|jdSdS)zDEstimate potential viewers based on zone population and penetration.rN)rrdpenetration_rateintrGrArArBestimated_viewerssz!ChannelCoverage.estimated_viewersN)%r9r:r;rZr<ZSIGNAL_STRENGTH_CHOICESrr[r\r]r^r`rrarr rr_rrerrrZcoverage_percentagerbZsubscriber_countrrZlaunch_date_in_zonerir3rnotesrCrHrjrrArArArBrs      rc @s$eZdZdZdedfdedfdedfded fd ed fd ed fdedfdedfdedfg Zejdej deddZ ej e ej deddZejdededdZejdeded d!Zejd"eed#ed$d%Zejed&ed'd(Zejed)ed*d(Zejed+ed,d(Zejd-ded.ed/d0Zejd1ded2ed3d0Zejeded4ed5d6Zejd7ed8ed9d:Zejd7ed;ed<d:Zej ded=ed>d:Z!ej ded?ed@d:Z"ejd-dedAedBd0Z#GdCdDdDZ$dEdFZ%dGdHZ&e'dIdJZ(dKdLZ)dMS)NContentSchedulez Electronic Program Guide (EPG) integration for content scheduling. Manages the programming schedule for TV channels, including show times, content metadata, and advertising break opportunities. ZlivezLive ProgrammingZrecordedz Pre-recordedZrerunz Rerun/RepeatZmovieZMovieZseriesz TV Seriesrz News Programrz Sports EventZ commercialzCommercial BreakZ infomercialZ InfomercialTFz Schedule IDrZschedule_entriesrri,z Program Titlez)Title of the scheduled program or contentrrwz+Detailed description of the program contentrurz Content TypezType of scheduled contentrz Start Timez#Scheduled start time of the programrrzEnd Timez!Scheduled end time of the programzDuration (Minutes)zProgram duration in minutesrZGenrezProgram genre or categoryrsr%zContent Ratingz&Content rating (G, PG, PG-13, R, etc.)rxz5JSON data describing target audience for this programrzrzAdvertising Breaksz0Number of advertising breaks during this programr0zAd Break Durationz/Total duration of advertising breaks in secondsz Live Programz Whether this is a live broadcastZPremierez3Whether this is a premiere episode or first showingz External IDz.External system identifier for EPG integrationc@sheZdZedZedZddgZejddgdejddgdejdgdejdgdejd gdgZ d S) zContentSchedule.MetazContent SchedulezContent Schedulesr start_timer4end_time content_typeis_live external_idNr8rArArArBrCrrrCcCs|jd|jjd|jS)Nz on z at )titlerr2rrGrArArBrH~szContentSchedule.__str__cCrJ)Nzchannels:schedule_detailrKrLrNrGrArArBrOrPz ContentSchedule.get_absolute_urlcCs0ddlm}|}|j|ko|jkSS)z)Check if the program is currently airing.r)rhN) django.utilsrhnowrr)rrhrrArArBis_currently_airings z#ContentSchedule.is_currently_airingcCspddlm}|jr2|jr4|j|jkr|td|j|jd}t||jdkr6t||_dSdSdSdS)zValidate schedule entry data.r)ValidationErrorz#Start time must be before end time.<N) django.core.exceptionsrrrr< total_secondsabsduration_minutesr)rrZcalculated_durationrArArBcleans    zContentSchedule.cleanN)*r9r:r;rZr<Z CONTENT_TYPESrr[r\r]r^r`rrarr_rrrr DateTimeFieldrrrbrZgenreZratingrrrZadvertising_breaksZad_break_durationrirZ is_premiererrCrHrOrjrrrArArArBr s             rc @seZdZdZdedfdedfdedfded fd ed fd ed fdedfdedfgZdedfdedfdedfdedfdedfdedfgZeje ej dedd Z eje ej ded!d Z ejed"ed#d$Zejed%ed&d$Zejeed'ed(d)Zejeed*ed+d)Zejeed,ed-d)Zejeed.ed/d)Zejd0d1d2d2ed3ed4d5Zejed2ed6ed7d8ZGd9d:d:Zd;d<Zed=d>Zed?d@Z dAS)BAudienceDemographicsz Audience demographics and viewership analytics for channels and zones. Stores demographic data and viewership statistics for targeted advertising and audience analysis. z2-11zChildren (2-11)z12-17z Teens (12-17)z18-24zYoung Adults (18-24)z25-34zAdults (25-34)z35-44zAdults (35-44)z45-54zAdults (45-54)z55-64zAdults (55-64)z65+z Seniors (65+)z under-25kz Under $25,000z25k-50kz$25,000 - $50,000z50k-75kz$50,000 - $75,000z75k-100kz$75,000 - $100,000z 100k-150kz$100,000 - $150,000z over-150kz Over $150,000Z demographicsrrrzMeasurement Datez*Date when these demographics were measuredrz Total Viewersz+Total number of viewers in this demographiczAge Distributionz$JSON data with age group percentagesr0zGender Distributionz7JSON data with gender percentages (male, female, other)zIncome Distributionz)JSON data with income bracket percentageszEducation Distributionz*JSON data with education level percentagesrrTzViewing Hours/Weekz3Average viewing hours per week for this demographicr(zPeak Viewing Timesz'JSON array of peak viewing time periodsrzc@sVeZdZedZedZgdZddgZej ddgdej dgdej d gdgZ d S) zAudienceDemographics.MetazAudience Demographics)rrmeasurement_datez-measurement_daterrrr4r total_viewersNrrArArArBrCrrCcCs |jjd|jjd|jdS)Nz demographics in rErF)rr2rrrGrArArBrHs zAudienceDemographics.__str__cCs$|jsdSt|jddddS)z.Get the age group with the highest percentage.NcSs|dS)NrrA)xrArArBsz8AudienceDemographics.primary_age_group..)keyr)age_distributionmaxitemsrGrArArBprimary_age_groupsz&AudienceDemographics.primary_age_groupcCs|jr tt|jddSdS)z;Calculate a viewer engagement score based on viewing hours.g@rrN)viewing_hours_per_weekminfloatrGrArArBviewer_engagement_scoresz,AudienceDemographics.viewer_engagement_scoreN)!r9r:r;rZr<Z AGE_GROUPSZINCOME_BRACKETSrr`rrarr rrrrbrrrrZgender_distributionZincome_distributionZeducation_distributionrerrZpeak_viewing_timesrCrHrjrrrArArArBrs                r)r\decimalr django.dbr django.urlsrdjango.utils.translationrr<django.core.validatorsrrZapps.common.modelsrr rkrrrrrArArArBs     yn-h