o yeh\-@sdZddlmZddlmZddlmZmZddlm Z ddl m Z ddl mZmZmZddlmZeZGd d d eeeZGd d d eZGd ddeeeZGdddeeeZdS)aaAdvertisers Models This module defines the database models for advertiser and brand management. It includes models for agencies, brands, and their relationships. Models: - Agency: Advertising agency information - Brand: Brand/advertiser information - BrandCategory: Brand categorization - UserAdvertiser: User-advertiser relationships )models)get_user_model)EmailValidator URLValidator)timezone) gettext_lazy) BaseModel AuditModel StatusModel)agencies_logo_upload_pathc@seZdZdZejddddZejddddZej e gdd Z ejd ddd d Z ej ddegd dZejddddZejddddd Zejddddd ZejeddddZejddddd ZejeejdddddZGdddZddZeddZedd Zd!S)"AgencyaAdvertising Agency model. Represents advertising agencies that manage multiple brands and campaigns. Agencies can have multiple users and brands associated with them. Attributes: name (str): Agency name description (str): Agency description email (str): Primary contact email phone (str): Primary contact phone website (str): Agency website URL address (str): Physical address city (str): City location country (str): Country location logo (ImageField): Agency logo contact_person (str): Primary contact person name is_active (bool): Whether agency is active TzAgency name (must be unique) max_lengthunique help_textz"Detailed description of the agencyblanknullrz$Primary contact email for the agency) validatorsrzPrimary contact phone numberrrrrzAgency website URLrrrrzPhysical address of the agencydzCity where agency is locatedzCountry where agency is locatedzAgency logo image upload_torrrz$Primary contact person at the agencyZowned_agenciesz!User who owns/manages this agency on_deleterr related_namerc@sFeZdZdZdZdZdgZejdgdejdgdejdgdgZ dS) z Agency.MetaZagenciesr ZAgenciesnamefieldsstatus created_atN) __name__ __module__ __qualname__db_table verbose_nameverbose_name_pluralorderingrIndexindexesr-r-KC:\Users\vibe-look\OneDrive\Desktop\Adtlas_V\src\apps\advertisers\models.pyMetazs   r/cCs|jS)N)rselfr-r-r.__str__szAgency.__str__cC|jjddS)z7Get total number of brands associated with this agency.activer"N)brandsfiltercountr0r-r-r. total_brandszAgency.total_brandscCs ddlm}|jj|ddS)z7Get total number of campaigns for this agency's brands.rCampaignr4)Zadvertiser__agencyr"N)apps.campaigns.modelsr<objectsr7r8)r1r<r-r-r.total_campaignss zAgency.total_campaignsN) r$r%r&__doc__r CharFieldr TextField description EmailFieldremailphoneURLFieldrwebsiteaddresscitycountry ImageFieldr logoZcontact_person ForeignKeyUserSET_NULLownerr/r2propertyr9r?r-r-r-r.r s   r c@s^eZdZdZejddddZejddddZej dej ddd d d Z Gd d d Z ddZ dS) BrandCategoryaFBrand Category model for organizing brands. Provides categorization for brands to help with organization and filtering in the system. Attributes: name (str): Category name description (str): Category description parent (ForeignKey): Parent category for hierarchical structure rTzCategory name (must be unique)rzDescription of the categoryrr1Z subcategoriesz-Parent category for hierarchical organizationrc@seZdZdZdZdZdgZdS)zBrandCategory.MetaZbrand_categorieszBrand CategoryzBrand CategoriesrN)r$r%r&r'r(r)r*r-r-r-r.r/s  r/cCs |jr |jjd|jS|jS)Nz > )parentrr0r-r-r.r2szBrandCategory.__str__N)r$r%r&r@rrArrBrCrNCASCADErTr/r2r-r-r-r.rSs,  rSc@seZdZdZejdddZejddddZej e ej dddd d Z ej e ejdd d Zejd ddddZejddegddZejddegddZejdddddZejdddddZejddddZejddddddZGdddZdd Zed!d"Z ed#d$Z!ed%d&Z"d'S)(BrandaBrand/Advertiser model. Represents brands or advertisers that create advertising campaigns. Brands are associated with agencies and can have multiple campaigns. Attributes: name (str): Brand name description (str): Brand description category (ForeignKey): Brand category agency (ForeignKey): Associated agency logo (ImageField): Brand logo website (str): Brand website contact_email (str): Brand contact email contact_phone (str): Brand contact phone industry (str): Industry sector target_audience (str): Primary target audience is_active (bool): Whether brand is active r zBrand or advertiser name)rrTz!Detailed description of the brandrr6zBrand category for organizationrzAgency managing this brandrrrz brands/logos/zBrand logo imagerzBrand website URLrzBrand contact emailrzBrand contact phone numberrrz3Industry sector (e.g., Automotive, Food & Beverage)z&Description of primary target audience zAnnual advertising budget) max_digitsdecimal_placesrrrc@sreZdZdZdZdZdgZejdgdejdgdejdgdejdgdejd gdgZ ej ddgd d gZ d S) z Brand.Metar6rVZBrandsrr agencycategoryr"r#Zunique_brand_per_agencyr!rN) r$r%r&r'r(r)r*rr+r,UniqueConstraint constraintsr-r-r-r.r/'s      r/cCs|jd|jjdS)N ())rr\r0r-r-r.r2:sz Brand.__str__cCr3)z-Get total number of campaigns for this brand.r4r5N) campaignsr7r8r0r-r-r.r?=r:zBrand.total_campaignscCs&ddlm}t}|jjd||dS)z.Get currently active campaigns for this brand.rr;r4)r"Zstart_date__lteZ end_date__gteN)r=r<rnowrcr7)r1r<rdr-r-r.active_campaignsBs zBrand.active_campaignscCs6ddlm}ddlm}|jj|dd}|dpdS)z2Calculate total budget spent across all campaigns.rr;)SumZbudget)totalrgN)r=r<django.db.modelsrfrc aggregate)r1r<rfresultr-r-r.total_budget_spentMs   zBrand.total_budget_spentN)#r$r%r&r@rrArrBrCrNrSrPr]r rUr\rLrMrGrrHrDrZ contact_emailZ contact_phoneZindustryZtarget_audience DecimalFieldZ annual_budgetr/r2rRr?rerkr-r-r-r.rVs    rVc@seZdZdZgdZejeejdddZ eje ejdddZ ej ded d d Z ejed d dZejd ddZGdddZddZddZdS)UserAdvertiseraUser-Advertiser relationship model. Manages the many-to-many relationship between users and advertisers/brands. Allows users to have access to specific brands with different permission levels. Attributes: user (ForeignKey): User account brand (ForeignKey): Associated brand role (str): User's role for this brand permissions (str): Specific permissions is_active (bool): Whether relationship is active ))viewerZViewer)editorEditor)managerManager)adminZ AdministratorZbrand_relationshipsz User accountrWZuser_relationshipszAssociated brandrrnzUser's role for this brand)rchoicesdefaultrTz5Specific permissions for this user-brand relationship)rurrz-Whether this relationship is currently active)rurc@s4eZdZdZdZdZddgZejddgdd gZ d S) zUserAdvertiser.MetaZuser_advertiserszUser-Advertiser RelationshipzUser-Advertiser RelationshipsZuser__usernameZ brand__nameuserbrandZunique_user_brand_relationshipr^N) r$r%r&r'r(r)r*rr_r`r-r-r-r.r/sr/cCs |jjd|jjd|jdS)Nz - rarb)rvusernamerwrroler0r-r-r.r2s zUserAdvertiser.__str__cCs |jdkrdS||jdgvS)z5Check if user has specific permission for this brand.rsTallowedN)ry permissionsget)r1 permissionr-r-r.has_permissions zUserAdvertiser.has_permissionN)r$r%r&r@Z ROLE_CHOICESrrNrOrUrvrVrwrAry JSONFielddictr{ BooleanField is_activer/r2r~r-r-r-r.rmYsB  rmN)r@ django.dbrdjango.contrib.authrdjango.core.validatorsrr django.utilsrdjango.utils.translationr_Zapps.common.modelsrr r Zapps.advertisers.utilsr rOr rSrVrmr-r-r-r.s    }-