o ݻehI0@sdZddlZddlmZddlmZddlmZddlm Z ddl m Z m Z ddl mZdd lmZGd d d eZGd d d eZGdddeZdS)z Campaigns Models Module This module contains all campaign-related models including: - Campaign model for advertising campaigns - CampaignSchedule for scheduling campaigns - CampaignBudget for budget management - CampaignPerformance for tracking metrics N)Decimal)models)reverse)timezone)MinValueValidatorMaxValueValidator) gettext_lazy) BaseModelc @seZdZdZdedfdedfdedfded fd ed fd ed fdedfgZdedfdedfdedfdedfdedfdedfgZdedfdedfd ed!fd"ed#fgZej d$e j d%ed&d'Z ej d(ed)ed*d+Zejd$ed,ed-d.Zej d/eded0ed1d2Zejd3ejd4ed5ed6d7Zejd8d9d4ed:ed;d<Zejd=d$d4ed>ed?d@ZejedAedBdCZejedDedEdCZejdFdeedGgedHedIdJZejdKdd$d$eedGgedLedMdNZejdOdd$d$eedGgedPedQdNZ ej d/ededRedSd2Z!ej"ededTedUdVZ#ej$e%d$edWedXdYZ&ej'dZed[ed\d]Z(ejdFded^ed_ed`daZ)ejd$edbedcd.Z*GdddedeZ+dfdgZ,dhdiZ-e.djdkZ/e.dldmZ0e.dndoZ1dpdqZ2drdsZ3dtS)uCampaignz Main campaign model for TV advertising campaigns. Represents an advertising campaign with all its properties including budget, schedule, targeting, and performance tracking. ZdraftZDraftpendingzPending ApprovalapprovedZApprovedactiveActivepausedZPaused completedZ Completed cancelledZ CancelledZbrand_awarenesszBrand AwarenessZproduct_launchzProduct LaunchZ promotionalZ PromotionalZseasonalZSeasonalZ event_basedz Event BasedZdirect_responsezDirect ResponseZLowZNormalZHighCriticalTFz Campaign ID) primary_keydefaulteditable verbose_namez Campaign Namez-Descriptive name for the advertising campaign) max_lengthr help_text Descriptionz JSONFielddictZtarget_demographicsPositiveBigIntegerFieldZtotal_impressionsr]ZnotesrIrNrRpropertyrTrYr^r_r`rGrGrGrHr s$                            r c @s.eZdZdZejeejdeddZ ejdejdeddZ ej eded d Z ej ed ed d Z ejeed eddZejdededgededdZejddddeedgededdZejdededdZejddeded ed!d"ZGd#d$d$Zd%d&Zed'd(Zd)S)*r&z Schedule model for campaign-channel relationships. Defines when and how a campaign runs on specific channels, including time slots, frequency, and channel-specific budgets. Zchannel_schedulesr r#r$rr%Zcampaign_schedulesChannelz Start Timez(Daily start time for ads on this channelr(zEnd Timez&Daily end time for ads on this channelz Days of Weekz5List of days when ads should run (0=Monday, 6=Sunday)r4rrZz Spots Per Dayz*Number of ad spots per day on this channel)rr-rrr.rTr*zChannel Budgetz!Budget allocated for this channelr/rzImpressions Deliveredz+Total impressions delivered on this channelr5z Amount SpentzAmount spent on this channelr6c@s*eZdZedZedZddgZdgZdS)zCampaignChannelSchedule.MetazCampaign Channel SchedulezCampaign Channel SchedulescampaignchannelZ channel__nameN)r?r@rArBrrCunique_togetherrDrGrGrGrHrI3s  rIcCs|jjd|jjSNz - )rvrKrwrLrGrGrHrN9rOzCampaignChannelSchedule.__str__cCs |jdS)z)Get daily frequency as a readable string.z spots/dayN) spots_per_dayrLrGrGrHdaily_frequency<s z'CampaignChannelSchedule.daily_frequencyN)r?r@rArarrir rjrBrvrw TimeField start_timeend_timerplistZ days_of_weekPositiveIntegerFieldrrrzrnrZchannel_budgetrrZimpressions_deliveredZ amount_spentrIrNrsr{rGrGrGrHr&st  r&cs eZdZdZejeejdeddZ ej ededdZ ej ded ed d Z ejded ed d ZejddedededdZejddddededdZejddededdZejddddededdZGdd d Zd!d"Zfd#d$ZZS)%CampaignPerformancez Daily performance tracking for campaigns. Stores daily metrics and performance data for campaigns, enabling detailed analytics and reporting. Zperformance_recordsr rtDatez Date for this performance recordr(rZ Impressionsz%Number of ad impressions on this dater4z Spots Airedz*Number of ad spots that aired on this dater.rr5z Daily SpendzAmount spent on this dater6r1TZCPMzCost per thousand impressions)r+r,r0rrrZReachz Estimated unique viewers reached)r0rrrrZ FrequencyzAverage frequency per viewerc@sHeZdZedZedZddgZdgZej ddgdej dgdgZ dS)zCampaignPerformance.MetazCampaign PerformancezCampaign Performance RecordsrvrUz-dater:N) r?r@rArBrrCrxrDrrErFrGrGrGrHrIs rIcCs|jjd|jSry)rvrKrUrLrGrGrHrNszCampaignPerformance.__str__cs<|jdkr|jdkr|j|jd|_tj|i|dS)zCalculate CPM when saving.riN)spend impressionscpmsupersave)rMargsrQ __class__rGrHrszCampaignPerformance.save)r?r@rArarrir rjrBrv DateFieldrUrrrrZ spots_airedrnrrrZreach frequencyrIrNr __classcell__rGrGrrHrBsl   r)rarcdecimalr django.dbr django.urlsr django.utilsrdjango.core.validatorsrrdjango.utils.translationrrBZapps.common.modelsr r r&rrGrGrGrHs      ZR