U th@sddlZddlZddlZddlZddlZddlmZddlmZddl m Z ddl m Z ddl mZddlmZddlmZmZdd lmZmZmZdd lmZdd lmZdd lmZmZdd l m!Z!ddl"m#Z#m$Z$m%Z%m&Z&m'Z'ddl(m)Z)ddl*m+Z+ddl,m-Z-ddl.m/Z/ddl0m1Z1m2Z2ddl3m4Z4m5Z5m6Z6m7Z7m8Z8m9Z9GdddZ:ddl;me!dQddZ?e!dRddZ@e!dSd d!ZAe!d"d#ZBe!d$d%ZCe!d&d'ZDe!dTd(d)ZEe!d*d+ZFe!dUd,d-ZGe!dVd.d/ZHe!dWd0d1ZIe!d2d3ZJe!d4d5ZKe!d6d7ZLe!dXd9d:ZMe!dYd;d<ZNe!d=d>ZOd?d@ZPdd lmZddAlmZmZmZddBlQmRZRmSZSmTZTmUZUddClmVZVddDlWmXZXGdEdFdFeeZYGdGdHdHeeZZdIdJZ[GdKdLdLeeZ\GdMdNdNeeZ]GdOdPdPeeZ^dS)ZN)import_main_path)View)settings connection)timezone)messages)renderredirect) Paginator EmptyPagePageNotAnInteger)LoginRequiredMixin) gettext_lazy)DictAny)login_required)FExpressionWrapper FloatFieldQCountSubstr) get_client_ip)Channel)Activity) CampaignsAdspots)AgencyBrand Advertiser BrandCategory BrandStatus AgencyTypec@seZdZdZddZdS) EmptyAgencyz4Empty agency object for template use in create mode.cCs|d|_d|_d|_d|_d|_d|_d|_d|_d|_d|_ d|_ d|_ d|_ d|_ d|_d|_d|_d|_d|_d|_dS)NUTCen)pkidname legal_name descriptionemailphonewebsite founded_year agency_sizeemployee_countstreet_addresscitystate postal_codecountry time_zonelanguagelogoagency_type_idselfr?apps/agencies/views.py__init__"s(zEmptyAgency.__init__N)__name__ __module__ __qualname____doc__rAr?r?r?r@r% sr%)handle_uploaded_filec Cs`|j}tjj|jdd}tj|dd|r,|jndd|t||j ddid t |d d |iS) Nrowner is_deleted view_agenciesUser Systemz performed view_agenciesHTTP_USER_AGENTr&useractionr-requestZ ip_addressZ user_agentZmetadataagencies/agency/list.htmlagency) rOrobjectsfilterr log_activityr.rMETAgetr )rQrOagenciesr?r?r@rJAs  rJc Cs|j}|jdkr|jd}|jd}|s@t|dtdStjj |||t d}t j |dd|rl|jnd d |t||jd d t|j||d dtdSt|dS)NPOST name_agencydescription_agencyAgency name is required.zagencies:add_agencyrHr+r-datetime add_agencyrKrLz performed add_agencyrMr& agency_id agency_nameZ agency_descrNagencies:view_agencieszagencies/agency/add.html)rOmethodrZrXrerrorr rrTcreaternowrrVr.rrWstrr*r rQrOr[r\rSr?r?r@r`Ws6     r`c Cs|j}|jdkr|dk rtjj|d}|j|krDt|dtdSd|i}t j |dd|r`|j ndd ||t ||j d d t|j|j|jd d t|dd|iStdS)NrZr)z%You are not the owner of this agency.agencies:edit_agencyrS edit_agencyrKrLz performed view_agency with id: rMr&rarNzagencies/agency/edit.htmldatard)rOrerrTrXrHrrfr rrVr.rrWrir*r+r-r )rQ id_agencyrOrSrnr?r?r@rm~s,     rmc Cs|j}|jdkr|dk r|jd}|jd}|sHt|dtdStjj|d}|r^|n|j |_ |rn|n|j |_ | t j |dd|r|jnd d ||t||jd d t|j|j |j d dtdS)NrZr[r\r]rlrkrmrKrLz performed edit_agency with id: rMr&rarNrd)rOrerZrXrrfr rrTr+r-saverrVr.rrWrir*)rQrorOr+r-rSr?r?r@ update_agencys2     rqc Cs|j}|jdkr|dk rtjj|d}tj|_d|_|t j |dd|rT|j ndd||t ||j dd t|j|j|jd d td S) NrZrk delete_agencyrKrLz" performed delete_agency with id: rMr&rarNrd)rOrerrTrXr_rhrIrprrVr.rrWrir*r+r-r )rQrorOrSr?r?r@rss(   rscCst|ddtjj|jddiS)N1agencies/components/dropdown_agency_campaign.htmlrYrrG)r rrTrUrOrQr?r?r@ load_agencys rvcCsD|j}|jd}|jd}t|||td}|t|dS)Nr[r\r^rt)rOrZrXrrrhrpr rjr?r?r@ send_agencys  rwcCstjj|jddddd}g}|D]d}i}|d|d<tjj|dd}tjj|dd }t|dkr$|d |d <t||d <||q$|S) NrrGror+r_rrroT)Z id_brand__inZpacingdate campaigns) rrTrUrO values_listr rlenappend)rQZagencesresultZagencerbrandsr{r?r?r@ active_agencys&     rc Cs|j}|dkr|dkrtjj|d}tjj|dd}ddt|D}t jj|d}tjj|d d}t j |dd |r|j nd d ||t||jd did t|dd||t|diStjj|dd}dd|D}tjj|d d}g} |D]d}d} ztjj|d}t|} Wntjk rDd} YnXt|j|j| |jd} | | qt j |dd |r|j nd d|t||jd did t|dd| iSdS)Nr&rkbrandZchannelcSsg|] }|dqSrr?.0ir?r?r@ %sz$views_advertiser..pk__inZview_advertiserrKrLz# performed view_advertiser with id rMrNz&agencies/advertiser/views_adspots.htmlrn)adspotsrchannelsid_userrcSsg|] }|dqSrr?)rZ brand_tupler?r?r@r>s -created_atrid_brand name_brand total_adspotsr;Zview_advertisersz performed view_advertiserszagencies/advertiser/views.htmlr)rOr rTrXrrUr|Zdistinctlistrorder_byrrVr.rrWr r!r} DoesNotExistrir*r+logo_urlr~) rQrrOrrrZ brands_tuples brands_idrZ brand_dicrZadspotZ brand_datar?r?r@views_advertisersp       rc Cs2|j}tjj|jdd}|jdkrz|jdd}|jdd}|jdd}|jdd }|jd d k}|jd }g} |s| d nt |dkr| d|s| dn|t t j kr| d|t t j kr| d|rt |dkr| dd} d|jkr~|jd} d} | j| krH| ddddddg} | jdd} | | kr~| d | r| D]}t||qtd!WSz2tjj|d"}|dkrtjj|jdd}Wn,tk rt|d#td$YWSXt|t||}tjj||d%}|st||||||d&}| r| jdd} tjd'|dd(d| }|jj || d)d*| zHt!j"|d+d,|r|j#nd-d.|t$||j%d/dd0t&|j'id1Wnt(k rYnXntjj||d%}zt)|||d2}| Wnt(k rHYnXzHt!j"|d3d,|rb|j#nd-d4|t$||j%d/dd3t&|j'id1Wnt(k rYnXt*|d5|jd6td$WSt+k r}z&t|d7t&|td!WYSd}~XYnXn|t j t j d8}t,|d9|SdS):zT Handle brand/advertiser creation with proper validation and error handling rrGrZr+r&categoryr-statusactive is_featuredZonrSzBrand name is required.z(Brand name cannot exceed 255 characters.zCategory is required.zInvalid category selected.zInvalid status selected.iz*Description cannot exceed 1000 characters.Nr;P!Logo file size cannot exceed 5MB.jpgjpegpngsvgwebp.4Logo must be in JPG, JPEG, PNG, SVG, or WebP format.zagencies:add_advertiserrkz'User is not associated with any agency.agencies:views_advertiser)r+rS)r+rSr-rrr_2F)rpZ create_brandrKrLz performed create_brandrMrrN)rrrZcreate_advertiserz performed create_advertiserzBrand " " has been created successfully!z,An error occurred while creating the brand: )rYZbrand_categoriesZbrand_statuseszagencies/advertiser/add.html)-rOrrTrUrerZrXstripr~r}dictr"choicesr#FILESsizer+splitlowerrrfr countAttributeErrorprintfirstr existsuuidZuuid4hexr;rprrVr.rrWrir* ImportError Advertiserssuccess Exceptionr )rQrOrYr+rr-rrroerrors logo_filemax_sizeallowed_extensionsfile_extensionrfrSZ brand_existrZunique_filenameZadvertiser_userecontextr?r?r@add_advertiserfs                    "       rcCst|j|jdkr:t|tjj|d}t|dd|iStjj|jd d}dd|D}tjj|d  d }t|d d |iSdS) NrZrkzcore/edit_advertiser_id.htmlrrrcSsg|] }|dqSrr?rxr?r?r@rsz#edit_advertiser..r -id_brandzagencies/advertiser/edit.htmlr) rrer rTrXr rrUrOr|r)rQrrrrr?r?r@edit_advertiser s  rcCsHtjj|d}|jd}|jd}|jd}|jd}tj}z\d}t|dd} | d d } |d | d } t|j d d|| d|d| |_ Wn YnX|dkr||_ |dkr||_ |dkr||_ |dkr||_d} dt|j} t| || d} | |tjj|jddjddd}tdS)Nrkadvertiser_nameradvertiser_desc active_0_1ZAdvertisers_imgs r:-__.pngZadvertiser_logozstatic//r&zEdit AdvertirerzAdmin edit advertiser id: activityrzr-rr1rrr)r rTrXrZr_rhrireplacerFrr; brand_namerr-rrrrprrUsessionselect_relatedallr )rQrrrrrrrhpath now_infilefilenameactivitedescrrr?r?r@update_advertisers<      &rc Cs|jdkrltj}d}dt|}t|||d}|tjj|d}dt |j d}t||_ |t jj |j dd d }d d |D}tjj |d d} t|dd| iS)NrZzDisable AdvertirerzAdmin disable advertiser id: rrkrrryrrrcSsg|] }|dqSrr?rr?r?r@rRsz&disable_advertiser..rrzcore/advertiser/disable.htmlr)rer_rhrirrpr rTrXintrrrUrr|rr ) rQrrhrrrrrrrr?r?r@disable_advertiser@s    rcCs*|jd}tjj|d}t|dd|iS)NrSrx'core/dropdown_advertisers_campaign.htmlr)GETrXr rTrUr )rQrbZ advertisersr?r?r@load_advertisersXs rc Cs|jd}t||jd}t||jd}|jd}tj}d}t|dd}|dd }|d |d }|jd } tjj| d } | | |||||d|d} | t |j d| j ||d} | t |dS)Nr+rr-rzstatic/Advertisers_imgsrrrrrrrSrxr)rorr-rrr;r)Z id_user_idZ id_brand_idrr_r)rZrXrr_rhrirrrTrprrrr ) rQrrrrrhrrrrSr ZAdvertiser_userr?r?r@send_advertisers_s<        rc Cstjj|jddd}dd|D}tjj|dd}g}g}g}|D]J}tjj|d}t|}| ||j |j ||j d } t | | | qLt |td d D].}t|} || } || } | || qt ||S) NrrrcSsg|] }|dqSrr?rr?r?r@rsz$most_advertisers..rrrrr)rrTrUrr|r rrr}r~rrr;rrangemaxindexpop) rQrrZtotalsdicrrrtoutalrZ max_valueZ max_indexar?r?r@most_advertiserss2    rr&c& s|ddlm}m}m}ddlm}ddlm}dd}fdd}|jd krdd lm} ddl } | } | d } | d } | | }| d }tdt|d|jddd}|jddd}|jd}|dkrd}d}d}d}ddlm}d|d||f}|||d}||}g}d}|D]N}| |dd}|r~||kr~|dddddd|||}q@|D].}|d dkrt|n|t|d 7}qt|d!|||| d"Stjj|jd#d$ d%}d&d'|D}t!jj|dd("d)} g}!| D]F}"t#jj|"d*}#t$|#}$|"j%|"j&|"j'|$|"j(d+}%t|%|!|%q t|d,d-|!iSdS).Nr)rrrr) timedeltacs&dd|jDfdd|DS)'Return all rows from a cursor as a dictcSsg|] }|dqSrr?rcolr?r?r@rszBreport_advertiser_backup..dictfetchall..csg|]}tt|qSr?rziprrowcolumnsr?r@rsr-fetchallcursorr?rr@ dictfetchalls z.report_advertiser_backup..dictfetchallc sxz:(}||||}|W5QRWSQRXWn8tk rr}ztd|gWYSd}~XYnXdSNzAn error occurred: )rexecuterrrqueryZparamsrZrowsrrr?r@ my_custom_sqls  z/report_advertiser_backup..my_custom_sqlrZ)r_%Y-%m-%d Europe/Paris-Current UTC offset for France (Paris) is GMT+r start_dayrr&end_dayselected_brandrraz SELECT networkname, spotId, DATE_SUB(Verifs.airTime, INTERVAL 1 HOUR) as airTime, airStatusCode, purcent AS sfr_percentage, purcent*1.25*4500000/17 AS total_volume, Epg.emission_name FROM Verifs LEFT JOIN SFR_analytics ON SUBSTRING(Verifs.airTime, 12, 5) = SUBSTRING(SFR_analytics.`minute`, 1, 5) AND SUBSTRING(Verifs.airTime, 1, 10) = SUBSTRING(SFR_analytics.`day`, 1, 10) AND SFR_analytics.sfr_channel_name = '2M Maroc' LEFT JOIN Epg ON (Verifs.airTime < DATE_ADD(Epg.End_time, INTERVAL 1 HOUR) AND Verifs.airTime > DATE_ADD(Epg.Start_time, INTERVAL 1 HOUR)) WHERE Verifs.spotId LIKE %s AND Verifs.airStatusCode = '0001' AND Verifs.broadcastDate > %s AND Verifs.broadcastDate < %s GROUP BY networkname, spotId, airTime, airStatusCode, purcent, Epg.emission_name ORDER BY airTime a SELECT networkname, spotId, DATE_SUB(Verifs.airTime, INTERVAL 1 HOUR) as airTime, airStatusCode, purcent AS sfr_percentage, CAST(purcent * 1.25 * 4500000 / 17 AS UNSIGNED) AS total_volume, Epg.emission_name FROM Verifs LEFT JOIN SFR_analytics ON SUBSTRING(Verifs.airTime, 12, 5) = SUBSTRING(SFR_analytics.`minute`, 1, 5) AND SUBSTRING(Verifs.airTime, 1, 10) = SUBSTRING(SFR_analytics.`day`, 1, 10) AND SFR_analytics.sfr_channel_name = '2M Maroc' LEFT JOIN Epg ON (Verifs.airTime < DATE_ADD(Epg.End_time, INTERVAL 1 HOUR) AND Verifs.airTime > DATE_ADD(Epg.Start_time, INTERVAL 1 HOUR)) WHERE Verifs.spotId LIKE %s AND Verifs.airStatusCode = '0001' AND Verifs.broadcastDate > %s AND Verifs.broadcastDate < %s GROUP BY networkname, spotId, airTime, airStatusCode, purcent, Epg.emission_name ORDER BY airTime a SELECT networkname, spotId, DATE_SUB(Verifs.airTime, INTERVAL 1 HOUR) as airTime, airStatusCode, purcent AS sfr_percentage, CAST(purcent * 1.25 * 4500000 / 17 AS UNSIGNED) AS total_volume, Epg.emission_name FROM Verifs LEFT JOIN SFR_analytics ON SUBSTRING(Verifs.airTime, 12, 5) = SUBSTRING(SFR_analytics.`minute`, 1, 5) AND SUBSTRING(Verifs.airTime, 1, 10) = SUBSTRING(SFR_analytics.`day`, 1, 10) AND SFR_analytics.sfr_channel_name = '2M Maroc' Inner JOIN Epg ON (Verifs.airTime < DATE_ADD(Epg.End_time, INTERVAL 2 HOUR) AND Verifs.airTime > DATE_ADD(Epg.Start_time, INTERVAL 2 HOUR)) WHERE Verifs.spotId LIKE %s AND Verifs.airStatusCode = '0001' AND Verifs.broadcastDate > %s AND Verifs.broadcastDate < %s GROUP BY networkname, spotId, airTime, airStatusCode, purcent, Epg.emission_name ORDER BY airTime  SELECT networkname, spotId, DATE_SUB(Verifs.airTime, INTERVAL 1 HOUR) as airTime, airStatusCode, purcent AS sfr_percentage, CAST(MAX(purcent) * 1.25 * 4500000 / 17 AS UNSIGNED) AS total_volume, Epg.emission_name FROM Verifs LEFT JOIN ( SELECT sfr_channel_name, `minute`, `day`, MAX(purcent) as purcent FROM SFR_analytics WHERE sfr_channel_name = '2M Maroc' GROUP BY sfr_channel_name, `minute`, `day` ) AS SFR_analytics ON SUBSTRING(Verifs.airTime, 12, 5) = SUBSTRING(SFR_analytics.`minute`, 1, 5) AND SUBSTRING(Verifs.airTime, 1, 10) = SUBSTRING(SFR_analytics.`day`, 1, 10) Inner JOIN Epg ON (Verifs.airTime < DATE_ADD(Epg.End_time, INTERVAL 2 HOUR) AND Verifs.airTime > DATE_ADD(Epg.Start_time, INTERVAL 2 HOUR)) WHERE Verifs.spotId LIKE %s AND Verifs.airStatusCode = '0001' AND Verifs.broadcastDate > %s AND Verifs.broadcastDate < %s GROUP BY networkname, spotId, airTime, airStatusCode, purcent, Epg.emission_name ORDER BY airTime r%airTime%Y-%m-%d %H:%M:%S--Z networknamespotIdr total_volumeZ emission_namercore/view_report.htmlrntotalr  report_daterrrcSsg|] }|dqSrr?rr?r?r@rvsz,report_advertiser_backup..rrrrrrr-rr;zcore/advertiser/report.htmlr))django.db.modelsrrrdjango.db.models.functionsrr_rrepytzrhstrftimer utcoffset total_secondsrrrZrXr django.dbrrrstrptimerzr~r r!rTrUrr|r rrr}rrr-r;)&rQrrrrrrrrr_rcurrent_datetimerparis_tz paris_time utc_offsetr r r  query_oldZ query_ol3Z query_old4rr data_tuplerrnprocessed_data last_daterrow_daterrrrrrrr?rr@report_advertiser_backupsr           ,    r-c Csdd}dd}|jdkrxt}|d}td}t|}|d}td t |d |j d  d d } |j d d d } |j d} |dkrd} d} d}d}t }| } d| d| | f}|||||}g}d}d}|D]h}t|dd}|r6||kr6|dddddd|||}|ddk r|t |d7}qt|d||| |dStjj|jddjd d!d"}tjj|d#d$d%}g}|D]>}tjj|d&}t|}|j|j|j ||j!d'}||qt|d(d)|iSdS)*Ncs&dd|jDfdd|DS)rcSsg|] }|dqSrr?rr?r?r@rsz;report_advertiser..dictfetchall..csg|]}tt|qSr?rrrr?r@rsrrr?rr@rs z'report_advertiser..dictfetchallc Ssxz:t(}||||}|W5QRWSQRXWn8tk rr}ztd|gWYSd}~XYnXdSr)rrrrrrrr?r?r@rs  z(report_advertiser..my_custom_sqlrZrrr r rr rr&r r ryray SELECT networkname, spotId, DATE_SUB(Verifs.airTime, INTERVAL 1 HOUR) as airTime, airStatusCode, purcent AS sfr_percentage, CAST(MAX(purcent) * 1.25 * 4500000 / CASE WHEN DATE(Verifs.airTime) < '2024-03-18' THEN 17 ELSE 14 END AS UNSIGNED) AS total_volume, Epg.emission_name FROM Verifs LEFT JOIN ( SELECT sfr_channel_name, `minute`, `day`, MAX(purcent) as purcent FROM SFR_analytics WHERE sfr_channel_name = '2M Maroc' GROUP BY sfr_channel_name, `minute`, `day` ) AS SFR_analytics ON SUBSTRING(Verifs.airTime, 12, 5) = SUBSTRING(SFR_analytics.`minute`, 1, 5) AND SUBSTRING(Verifs.airTime, 1, 10) = SUBSTRING(SFR_analytics.`day`, 1, 10) INNER JOIN Epg ON (Verifs.airTime < DATE_ADD(Epg.End_time, INTERVAL 2 HOUR) AND Verifs.airTime > DATE_ADD(Epg.Start_time, INTERVAL 2 HOUR) AND Epg.verif_channel_id = Verifs.zonename) WHERE Verifs.spotId LIKE %s AND Verifs.airStatusCode = '0001' AND Verifs.broadcastDate > %s AND Verifs.broadcastDate < %s GROUP BY networkname, spotId, airTime, airStatusCode, purcent, Epg.emission_name ORDER BY airTime a Select MIN(networkname) AS networkname, MIN(networkname) AS networkname, MIN(spotId) AS spotId, MIN(Epg.emission_name) AS emission_name, SUBSTRING(DATE_SUB(Verifs.airTime, INTERVAL 2 HOUR), 1, 19) as airTime, CAST(MAX(purcent) * 1.25 * 4500000 / CASE WHEN DATE(Verifs.broadcastDate) < '20240317' THEN 17 ELSE 14 END AS UNSIGNED) AS total_volume FROM Verifs INNER JOIN SFR_analytics ON SUBSTRING(Verifs.airTime, 12, 5) = SUBSTRING(SFR_analytics.`minute`, 1, 5) AND SUBSTRING(Verifs.airTime, 1, 10) = SUBSTRING(SFR_analytics.`day`, 1, 10) AND SFR_analytics.sfr_channel_name = '2M Maroc' INNER JOIN Epg ON (Verifs.airTime < DATE_ADD(Epg.End_time, INTERVAL 1 HOUR) AND Verifs.airTime > DATE_ADD(Epg.Start_time, INTERVAL 1 HOUR)) WHERE Verifs.spotId LIKE %s AND Verifs.airStatusCode = '0001' AND Verifs.broadcastDate > %s AND Verifs.broadcastDate < %s GROUP BY SUBSTRING(Verifs.airTime, 1, 19), Verifs.broadcastDate ORDER BY airTime; a SELECT MIN(Verifs.networkname) AS networkname, MIN(spotId) AS spotId, CASE WHEN DATE(Verifs.airTime) > '2024-03-30' THEN SUBSTRING(Verifs.airTime, 1, 19) ELSE SUBSTRING(DATE_SUB(Verifs.airTime, INTERVAL 1 HOUR), 1, 19) END AS airTime, MIN(Epg.emission_name) AS emission_name, CAST(MAX(purcent) * 1.25 * 4500000 / CASE WHEN DATE(Verifs.broadcastDate) < '2024-03-17' THEN Channels_zone.market_share ELSE Channels_zone.market_share END AS UNSIGNED) AS total_volume FROM Verifs INNER JOIN Channels_zone ON Channels_zone.id_zone_channel = Verifs.zonename Inner JOIN ( SELECT sfr_channel_name, `minute`, `day`, MAX(purcent) AS purcent FROM SFR_analytics INNER JOIN Channels_zone ON Channels_zone.sfr_name = SFR_analytics.sfr_channel_name WHERE sfr_channel_name = Channels_zone.sfr_name GROUP BY sfr_channel_name, `minute`, `day` ) AS SFR_analytics ON ( SUBSTRING(Verifs.airTime, 12, 5) = SUBSTRING(SFR_analytics.`minute`, 1, 5) OR SUBSTRING(Verifs.airTime, 12, 5) = SUBSTRING(ADDTIME(SFR_analytics.`minute`, '00:01:00'), 1, 5) ) AND SUBSTRING(Verifs.airTime, 1, 10) = SUBSTRING(SFR_analytics.`day`, 1, 10) AND Channels_zone.sfr_name = SFR_analytics.sfr_channel_name INNER JOIN Epg ON ( Epg.verif_channel_id = Verifs.networkname AND Verifs.airTime < DATE_ADD(Epg.End_time, INTERVAL 2 HOUR) AND Verifs.airTime > DATE_ADD(Epg.Start_time, INTERVAL 2 HOUR) ) WHERE Verifs.spotId LIKE %s AND Verifs.airStatusCode = '0001' AND Verifs.broadcastDate > %s AND Verifs.broadcastDate < %s GROUP BY CASE WHEN DATE(Verifs.airTime) > '2024-03-30' THEN SUBSTRING(Verifs.airTime, 1, 19) ELSE SUBSTRING(DATE_SUB(Verifs.airTime, INTERVAL 1 HOUR), 1, 19) END, Verifs.broadcastDate, Channels_zone.market_share, SFR_analytics.sfr_channel_name ORDER BY airTime; rrrrrrrrrrrrT)Zflatrrrrrrzcore/report_advertiser.htmlr)"rer_rhrrrr r!rrrZrXrrr capitalizerr#rzr~r rrTrUrr|Brandsrrr}rrr-r;)rQrrrr$rr%r&r'r r r r(Zquery_11Zquery11rrr)rnr*r+rrr,rrrrrrZ brand_infor?r?r@report_advertisers`     "4   r0c sddlm}tjjdd}tjj|jdddj|dd d}g}g}ddl d fd d t t |D}|D],}| tjj|dd j| |d qz|||d}t|dd|iS)Nrrrrrrrdcount-dcount0123456789ABCDEFc s"g|]}dddqS#r&joinZsamplercharsrandomr?r@rvszstatsbrands..rr3)labelrncolorzcore/stats_brands.htmlr)rrrrTrUrrvaluesannotaterr=rr}r~r/rXrr ) rQrchadsr?rnr@adrr?r;r@ statsbrandsls  ,rFcsddlm}tjjdd}tjj|ddd}dd |D}tjjt|d  d j |d d  d }ddl dfdd t t|D}g}g}|D],}|tjj|ddj||dqdS)Nrr1rrrZ0001)Znetworkname__inZ airStatuscodercSsg|] }|dqSrr?)rZverifr?r?r@rsz brand_adspot..)Zname__inZ channel__inrr2r4r5c s"g|]}dddqSr6r9rr;r?r@rsrr>r3)rrrrTrUZVerifsr|rvrArBrr=rr}r~r/rXr)rrCZverifsrDr@r?rnrEr?r;r@ brand_adspots (rH)r r r ) HttpRequest HttpResponse JsonResponseHttp404)get_object_or_404)reversecs:eZdZdZdgZdZdddddd 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 eed d/d0Z!edd1d2Z"ee#d d3d4Z$Z%S)5AgencyListViewa Agency List View This view is responsible for rendering the agencies 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 agencies list page template with advanced filtering, searching, pagination, and AJAX support. Methods: get(request): Handles the HTTP GET request and returns the rendered agencies list page template. Template: - 'agencies/agency/list.html': The HTML template used to render the agencies list page. Features: - Advanced filtering by agency type, status, size, and date ranges - Full-text search across agency name, legal name, and description - Pagination with customizable items per page - AJAX support for dynamic updates - Statistics and analytics - Export functionality - Real-time updates rXrRzAgencies - FocuszFocus Development TeamzsAgency management for Focus advertising solutions. This page provides comprehensive agency management and insights.zXFocus, agencies, advertising solutions, agency management, marketing, data visualizationrY)titleZauthorr-keywords active_menuc s$tjf|}|dtdi|S)z Add agencies page context data. Args: **kwargs: Additional keyword arguments Returns: dict: Updated context data rPZAgencies)superget_context_dataupdater)r>kwargsr __class__r?r@rTs zAgencyListView.get_context_datarQreturnc Os|jddkr||S||}t|||}|jdd}z||}Wn"tt fk rr|d}YnX| || |||}t ||j |S)a Handles the HTTP GET request and returns the rendered agencies list page template. Args: request (HttpRequest): The HTTP request object. *args: Variable length argument list. **kwargs: Arbitrary keyword arguments. Returns: HttpResponse: The rendered agencies list page template. Query Parameters: - search: Search term for agency name/legal_name/description - agency_type: Filter by agency type ID - status: Filter by agency status - size: Filter by agency size - 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) zX-Requested-WithZXMLHttpRequestpagerr)ZheadersrX_handle_ajax_request_get_filtered_querysetr _get_items_per_pagerget_pager r _log_user_activity_build_contextr template_name) r>rQargsrVqueryset paginator page_numberpage_objrr?r?r@rXs   zAgencyListView.getrucCsxtjdd}|jjs,|j|jd}|||}| ||}| ||}| ||}| ||}| ||}|S)z Build filtered queryset based on request parameters. Args: request: Django HTTP request object Returns: QuerySet: Filtered agency queryset agency_typeZ team_membersrH)rrTrrZprefetch_relatedrO is_superuserrU_apply_search_filter_apply_agency_type_filter_apply_status_filter_apply_size_filter_apply_date_filters_apply_sorting)r>rQrdr?r?r@r]s       z%AgencyListView._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 searchr&)Zname__icontains)Zlegal_name__icontains)Zdescription__icontains)Zemail__icontains)rrXrrUr)r>rdrQ search_queryr?r?r@rk%s z#AgencyListView._apply_search_filterc CsT|jdd}|rP|dkrPzt|}|j|d}Wnttfk rNYnX|S)z Apply agency type filter to queryset. Args: queryset: Base queryset request: Django HTTP request object Returns: QuerySet: Filtered queryset rhr&r)r<)rrXrrrU ValueError TypeError)r>rdrQrhr<r?r?r@rl<s  z(AgencyListView._apply_agency_type_filtercCs|jdd}|r|dkr|dkr6|jddd}q|dkrN|jddd}q|d krf|jddd }q|d kr~|jddd }q|d kr|jdd}n |jdd}|S)z Apply status filter to queryset. Args: queryset: Base queryset request: Django HTTP request object Returns: QuerySet: Filtered queryset rr&rrTF is_activerIinactiveverified is_verifiedrIfeaturedrrIdeletedrIrrXrrU)r>rdrQZ status_filterr?r?r@rmRs   z#AgencyListView._apply_status_filtercCs.|jdd}|r*|dkr*|j|d}|S)z Apply agency size filter to queryset. Args: queryset: Base queryset request: Django HTTP request object Returns: QuerySet: Filtered queryset rr&r)r2r)r>rdrQZ size_filterr?r?r@rnps   z!AgencyListView._apply_size_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)Zcreated_at__date yesterdayrrZdaysZ this_week)created_at__date__gteZ this_monthZday last_30_daysr)Zcreated_at__date__lte) rrXrrhrzrUr_rweekdayrr#rs) r>rdrQrrrrr week_start month_startrZ from_dateZto_dater?r?r@ros@      z"AgencyListView._apply_date_filterscCsX|jdd}dddddddd d d d d ddddddg}||krJ||}n |d}|S)z Apply sorting to queryset. Args: queryset: Base queryset request: Django HTTP request object Returns: QuerySet: Sorted queryset sort_byr+-namer, -legal_nameagency_type__name-agency_type__namer1 -founded_yearr3-employee_countrz -is_verifiedr -is_featured created_atrZ updated_at -updated_at)rrXr)r>rdrQrZvalid_sort_fieldsr?r?r@rps0    zAgencyListView._apply_sortingcCs|j}|j|||jdk||||||||| |j |j |j|j dd|j dd|j dd|j ddd}||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 rrrqr&rhrr)rYrgreZ is_paginated agency_typesZstatus_choices size_choicesZ filter_paramsZ sort_optionsZstatsr total_results current_page total_pagesrrZselected_agency_typeZselected_statusZ selected_size)rO object_list num_pages_get_agency_types_get_status_choices_get_size_choices_get_current_filters_get_sort_options _get_stats_get_date_rangernumberrrXrU extra_context)r>rQrgrerOrr?r?r@ras,      zAgencyListView._build_contextc Cs`z tjWStk rZz$ttjjddddWYSgYYSXYnXdS)z Get available agency types for dropdown filter. Returns: QuerySet: AgencyType objects ordered by sort_order and name Fr~ sort_orderr+N)r$rTrrcreate_default_typesrUrr=r?r?r@rs z AgencyListView._get_agency_typescCs@dtdfdtdfdtdfdtdfd td fd td fgS) z Get available status choices for dropdown filter. Returns: list: Status choice tuples rz All StatusrZActiverwZInactiverxZVerifiedr{ZFeaturedr}ZDeletedrr=r?r?r@rs      z"AgencyListView._get_status_choicescCs@dtdfdtdfdtdfdtdfd td fd td fgS) z Get available agency size choices for dropdown filter. Returns: list: Agency size choice tuples rz All SizesstartupStartup (1-10 employees)smallSmall (11-50 employees)mediumMedium (51-200 employees)largeLarge (201-1000 employees) enterpriseEnterprise (1000+ employees)rr=r?r?r@r(s      z AgencyListView._get_size_choicesc 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 rqr&rhrrrrrrrr+per_pageZ20) rqrhrrrrrrr)rrXr>rQr?r?r@r8s         z#AgencyListView._get_current_filtersrZcCsdtdddtdddtdddtd dd td dd td ddtdddtdddtdddtdddtdddtdddtdddtdddtddgS) z Get available sorting options for dropdown. Returns: list: Sort options for template r+z Name (A-Z))valuer?rz Name (Z-A)r,zLegal Name (A-Z)rzLegal Name (Z-A)rz Type (A-Z)rz Type (Z-A)rzFounded (Newest)r1zFounded (Oldest)rzSize (Largest)r3zSize (Smallest)rzVerified FirstrzFeatured Firstrz Newest Firstrz Oldest FirstrzRecently Updatedrr=r?r?r@rNs                z AgencyListView._get_sort_optionsc Cstj}|js|j|d}t}|tj dd}| |jddd |jddd |jddd |jddd |jdd  |j|dd  |jdd  d j t d d d|jdd  dj t d d d|jddd d S)z Get agencies statistics for dashboard. Args: user: Current user object Returns: dict: Agencies statistics rirTFruryr|r~)rrIrr*)rz-countr2)Zagency_type__is_premiumrI) Ztotal_agenciesZactive_agenciesZinactive_agenciesZverified_agenciesZfeatured_agenciesZdeleted_agenciesZrecent_agenciesZagencies_by_typeZagencies_by_sizeZpremium_types_count)rrTrrjrUrrhrzr_rrrArBrr)r>rOZ base_querysetrZweek_agor?r?r@rgsD     zAgencyListView._get_statscCsLt}||tjdd|tj|d|jdd|tjdddS)zz Get date range information for filtering. Returns: dict: Date range options rrrrr)rrrrr)rrhrzr_rrr)r>rr?r?r@rs  zAgencyListView._get_date_rangec CsDz$t|jdd}tdt|dWSttfk r>YdSXdS)z Get number of items per page from request. Args: request: Django HTTP request object Returns: int: Number of items per page (default 20, max 100) r dN)rrrXrminrsrt)r>rQrr?r?r@r^s z"AgencyListView._get_items_per_pagecCsztj|jdd|jr|jjndd|t||jdd|jdd|jdd|jd d|jd d|jd d |jd d|jddddWn0tk r}zt d|W5d}~XYnXdS)z Log user activity for auditing purposes. Args: request: Django HTTP request object Zview_agencies_listrKrLz viewed agencies listrMr&rqrhrrrr+r[rrrr)rqrhrrrr[rrNFailed to log activity: N) rrVrOr.rrWrXrrr)r>rQrr?r?r@r`s&         z!AgencyListView._log_user_activityc CszP||}t|||}|jdd}||}g}|jD]}t|j|j |j pXd|j p`d|j |j pld|jptd|jr|jjnd|jr|jj nd|jr|jjnd|jr|jjndd|j|j|j|j|j|j|jr|jnd|jr|jjndd}||q@td ||j|j|j |!|"|!r4|#nd|"rH|$ndd WSt%k r} ztdt| d d d WYSd} ~ XYnXdS)z Handle AJAX requests for dynamic updates. Args: request: Django HTTP request object Returns: JsonResponse: JSON response with agencies data r[rrr&Nz#007bffF)r*r+ color_code is_premium)r*r+r,r-r.r/r0rhrvrzrr2r3r1rrT) rrYrrr has_previoushas_nextprevious_page_numbernext_page_number)rrfir)&r]r r^rrXr_rrir*r+r,r-r.r/r0rhrrrvrzrr2r3r1rZ isoformatr;urlr~rKrrrrrrrr) r>rQrdrerfrgZ agencies_datarS agency_datarr?r?r@r\s^      z#AgencyListView._handle_ajax_request)&rBrCrDrEhttp_method_namesrbrrTrIrJrXr]rkrlrmrnrorprrirrarrrrrrrrr_rzrr^r`rKr\ __classcell__r?r?rWr@rOs: 13 2'rOc@s,eZdZdZdgZdZeeedddZ dS)AgencyDetailViewz_Agency Detail View with related brands summary. Template: agencies/agency/detail.html rXzagencies/agency/detail.htmlrQr)rZc Cstt|d}|jjs(|j|jkr(tdtjj|d d d}t j |jdd|j |t||jdd d t|jid |||j d d d}t||j|S)NrkAgency not found)rSrSr+Zview_agency_detail_cbvzViewed agency detail (CBV): rMr&rbrNz - DetailsrY)rSrrPrR)rMrrOrjrHrLr rTrUrrrrVr+rrWrXrir*r rb)r>rQr)rSrrr?r?r@rXs&      zAgencyDetailView.getN) rBrCrDrErrbrIrirJrXr?r?r?r@r srcCs6ztjjddddWStk r0gYSXdS)z Helper function to get agency types for form dropdowns. Returns: QuerySet: AgencyType objects ordered by sort_order and name Fr~rr+N)r$rTrUrrr?r?r?r@get_agency_types0src@seZdZdZddgZdZeedddZeeddd Z ee dd d Z e ee d d dZ e dddZe edddZddZee e edddZeedddZddZdd Zd!d"Zd#d$Zd%d&Zd'd(Zeed)d*d+Zeed,d-d.Zeedd/d Z ee dd0d Z e ee d d1dZ e dd2dZe edd3dZd4dZee e edd5dZeedd6dZd7dZd8d Zd9d"Zd:d$Zd;d&Zdd.Zd?S)@AgencyCreateViewa Create a new Agency with comprehensive form handling. This view handles all agency form fields including: - Basic information (name, legal name, description) - Contact information (email, phone, website) - Business information (agency type, size, employee count, specializations) - Address information (street, city, state, country, postal code) - Localization (time zone, language) - Logo upload Template: agencies/agency/form.html rXpostagencies/agency/form.htmlrYc Cs^|}|}|}|}|}|}ddd||||||dtdd }t||j|S)z Render the agency creation form with all necessary dropdowns populated. Args: request: HTTP request object Returns: HttpResponse: Rendered form template Create New Agency Create AgencyTCreate Agency - FocusrY) form_title submit_text is_createrrspecialization_choicestimezone_choiceslanguage_choicescountry_choicesrPrSrR) rr_get_specialization_choices_get_timezone_choices_get_language_choices_get_country_choicesr%r rb) r>rQrrrrrrrr?r?r@rXPs( zAgencyCreateView.getc Csz||}|||}|r,||||WS|||}d|jkrT|||jd|||dt|d|j dt d|j dWSt k r}z(t |dt|||WYSd}~XYnHtk r}z(t |d t|||WYSd}~XYnXdS a Handle agency creation with comprehensive validation and error handling. Args: request: HTTP request object Returns: HttpResponse: Redirect to agency detail or form with errors r;rgAgency "ragencies:agency_detailrkValidation error: NAn unexpected error occurred: _extract_form_data_validate_form_data_render_form_with_errors_create_agencyr_handle_logo_upload _log_activityrrr+r r)ValidationErrorrfrirXrr>rQ form_datavalidation_errorsrSrr?r?r@rus"     zAgencyCreateView.postcCs |jdd|jdd|jdd|jdd|jdd|jdd|jdd|jd d|jd d|jd d|jd d |jdd|jd|jdd|jdd|jdd|jdd|jdddSz Extract all form data from the request. Args: request: HTTP request object Returns: dict: Extracted form data r+r&r,r-rhr.r/r0r1r2r3r9r'r:r(specializationsr4r5r6r7r8)r+r,r-r<r.r/r0r1r2r3r9r:rr4r5r6r7r8rZrXrZgetlistrr?r?r@rs&  z#AgencyCreateView._extract_form_datarrQrZc Csg}|ds|dnt|ddkr2|d|dsF|dn||ds^|d|dsr|d n8ztjj|dd Wn tjk r|d YnX|d rt|d dkr|d |drt|ddkr|d|dr||ds|d|dr8t|ddkr8|d|drzHt|d}t j }|dksr||dkr|d|ddWn t k r|dYnX|drz.t|d}|dks|dkr|dWn t k r|dYnX|d r,t|d d!kr,|d"|d#rRt|d#d$krR|d%|d&rxt|d&d$krx|d'|d(rt|d(dkr|d)d*|j kr|j d*}||}|||drtjj|d|jd+d,} | r|d-|S.a Validate all form data and return list of errors. Args: form_data: Extracted form data request: HTTP request object Returns: list: List of validation error messages r+r])Agency name cannot exceed 200 characters.r.Email address is required.#Please enter a valid email address.r<Agency type is required.r* Selected agency type is invalid.r,(Legal name cannot exceed 200 characters.r-*Description cannot exceed 2000 characters.r0!Please enter a valid website URL.r/r)Phone number cannot exceed 20 characters.r1lrr&Founded year must be between 1900 and r$Founded year must be a valid number.r3@B/Employee count must be between 1 and 1,000,000.&Employee count must be a valid number.r4r,Street address cannot exceed 255 characters.r5r"City cannot exceed 100 characters.r6#State cannot exceed 100 characters.r7(Postal code cannot exceed 20 characters.r;FZ name__iexactrHrIz*You already have an agency with this name.r~r}_is_valid_emailr$rTrXr _is_valid_urlrrrhyearrsr_validate_logo_fileextendrrUrOr r>rrQrr  current_yearrr logo_errorsexistingr?r?r@rsv                          z$AgencyCreateView._validate_form_datarcCsbg}d}|j|kr|ddddddg}d|jkrH|jdd nd }||kr^|d |S z Validate uploaded logo file. Args: logo_file: Uploaded file object Returns: list: List of validation errors rrrrrrrrrr&rrr~r+rrr>rrrrrr?r?r@r#s   " z$AgencyCreateView._validate_logo_filerrQc Cstjj|dd}|d|j||ddd}ddd d d d d dddddg }|D]}||rL||||<qL|dr~t|d|d<|drt|d|d<|dr|d|d<tjjf|}|Sz Create the agency with validated data. Args: form_data: Validated form data request: HTTP request object Returns: Agency: Created agency instance r<rr+r.T)r+rHrhr.rvr,r-r/r0r2r9r:r4r5r6r7r8r1r3rr$rTrXrOrrrgr>rrQrhroptional_fieldsfieldrSr?r?r@r=s>   zAgencyCreateView._create_agencycCs||_|dSz Handle logo file upload. Args: agency: Agency instance logo_file: Uploaded logo file Nr;rpr>rSrr?r?r@rosz$AgencyCreateView._handle_logo_uploadrQrrrZc Csv|D]}t||q|}|}|}|}|} |} ddd||||| | |tddd } t ||j | Sa. Render form with validation errors and preserve user input. Args: request: HTTP request object errors: List of error messages form_data: Form data to preserve Returns: HttpResponse: Form with errors rrTrrY) rrrrrrrrrrrSrPrR rrfrrrrrrr%r rb r>rQrrrfrrrrrrrr?r?r@rzs. z)AgencyCreateView._render_form_with_errorsrQrPc CszZtj|j|dd|jjd|d|j|t||jddt|j |j|ddWn0t k r}zt d |W5d }~XYnXd S z Log user activity. Args: request: HTTP request object agency: Agency instance action: Action type ('create', 'update', etc.) Z _agency_cbvrKrz d agency: rMr&)rbrcrPrNrN rrVrOr.r+rrWrXrir*rrr>rQrSrPrr?r?r@rs   zAgencyCreateView._log_activityc CslztjjddddWStk rfz$ttjjddddWYSgYYSXYnXdSzGet agency types for dropdown.Fr~rr+Nr$rTrUrrrr=r?r?r@rsz"AgencyCreateView._get_agency_typescCsddddddgSzGet agency size choices.)r&zSelect agency size...)rr)rr)rr)rr)rrr?r=r?r?r@rsz"AgencyCreateView._get_size_choicesc Csddddddddd d g S zGet specialization choices.)Ztv_advertisingzTV Advertising)Zdigital_marketingzDigital Marketing)Zcreative_serviceszCreative Services)Zmedia_planningzMedia Planning)Zbrand_strategyzBrand Strategy)Zpublic_relationszPublic Relations)Z social_mediaz Social Media)Zcontent_creationzContent Creation)Zdata_analyticszData Analytics)Z full_servicez Full Servicer?r=r?r?r@rsz,AgencyCreateView._get_specialization_choicesc Csddddddddd d g S zGet timezone choices.)r'r')zAmerica/New_Yorkz Eastern Time)zAmerica/Chicagoz Central Time)zAmerica/Denverz Mountain Time)zAmerica/Los_Angelesz Pacific Time)z Europe/Londonz London Time)rz Paris Time)z Europe/Berlinz Berlin Time)z Asia/Tokyoz Tokyo Time)zAustralia/Sydneyz Sydney Timer?r=r?r?r@rsz&AgencyCreateView._get_timezone_choicesc Csddddddddd d g S zGet language choices.)r(ZEnglish)ZesZSpanish)frZFrench)ZdeZGerman)itZItalian)ZptZ Portuguese)ZzhZChinese)ZjaZJapanese)ZkoZKorean)ZarZArabicr?r=r?r?r@rsz&AgencyCreateView._get_language_choicescCs*ddddddddd d d d d ddddddgSzGet country choices.)r&zSelect country...)ZUSz United States)ZCAZCanada)ZGBzUnited Kingdom)ZDEZGermany)ZFRZFrance)ZESZSpain)ZITZItaly)ZAUZ Australia)ZJPZJapan)ZCNZChina)INZIndia)ZBRZBrazil)ZMXZMexico)NLZ Netherlands)ZSEZSweden)ZNOZNorway)ZDKZDenmark)ZFIZFinlandr?r=r?r?r@r s(z%AgencyCreateView._get_country_choicesr.rZcCsddl}d}|||dk SzValidate email format.rNz0^[a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+\.[a-zA-Z]{2,}$rematchr>r.r6patternr?r?r@r  sz AgencyCreateView._is_valid_emailrrZcCsBz&ddlm}||}t|j|jgWStk r<YdSXdSzValidate URL format.r)urlparseFNZ urllib.parser<rZschemeZnetlocrr>rr<rr?r?r@r " s  zAgencyCreateView._is_valid_urlc Csz||}|||}|r,||||WS|||}d|jkrT|||jd|||dt|d|j dt d|j dWSt k r}z(t |dt|||WYSd}~XYnHtk r}z(t |d t|||WYSd}~XYnXdSrrrr?r?r@r, s"     cCs |jdd|jdd|jdd|jdd|jdd|jdd|jdd|jd d|jd d|jd d|jd d |jdd|jd|jdd|jdd|jdd|jdd|jdddSrrrr?r?r@rT s&  c Csg}|ds|dnt|ddkr2|d|dsF|dn||ds^|d|dsr|d n8ztjj|dd Wn tjk r|d YnX|d rt|d dkr|d |drt|ddkr|d|dr||ds|d|dr8t|ddkr8|d|drzHt|d}t j }|dksr||dkr|d|ddWn t k r|dYnX|drz.t|d}|dks|dkr|dWn t k r|dYnX|d r,t|d d!kr,|d"|d#rRt|d#d$krR|d%|d&rxt|d&d$krx|d'|d(rt|d(dkr|d)d*|j kr|j d*}||}|||drtjj|d|jd+d,} | r|d-|Srr rr?r?r@rz sv                          cCsbg}d}|j|kr|ddddddg}d|jkrH|jdd nd }||kr^|d |Srrrr?r?r@r s   " c Cstjj|dd}|d|j||ddd}ddd d d d d dddddg }|D]}||rL||||<qL|dr~t|d|d<|drt|d|d<|dr|d|d<tjjf|}|Srrrr?r?r@r s>   cCs||_|dSrrrr?r?r@r& sc Csv|D]}t||q|}|}|}|}|} |} ddd||||| | |tddd } t ||j | Sr!r"r#r?r?r@r1 s. c CszZtj|j|dd|jjd|d|j|t||jddt|j |j|ddWn0t k r}zt d |W5d }~XYnXd Sr%r&r'r?r?r@r[ s   c CslztjjddddWStk rfz$ttjjddddWYSgYYSXYnXdSr(r)r=r?r?r@rw scCsddddddgSr*r?r=r?r?r@r sc Csddddddddd d g Sr+r?r=r?r?r@r sc Csddddddddd d g Sr,r?r=r?r?r@r sc Csddddddddd d g Sr-r?r=r?r?r@r scCs*ddddddddd d d d d ddddddgSr0r?r=r?r?r@r s(cCsddl}d}|||dk Sr4r5r8r?r?r@r  scCsBz&ddlm}||}t|j|jgWStk r<YdSXdSr;r=r>r?r?r@r  s  N)rBrCrDrErrbrIrJrXrrrrrrrrrrirrrrrrrboolr r r?r?r?r@r>sH%(&`2 *   (&`2 *  rc@seZdZdZeeedddZeeedddZee ddd Z e ee d d d Z e d ddZ e edddZddZee e edddZeedddZeedddZeeddd Zd!d"Zd#d$Zd%d&Zd'd(Zd)d*Zd+d,Zd-S).AgencyUpdateViewzHUpdate an existing Agency. Template: agencies/agency/form.html rc Cstt|d}|jjs(|j|jkr(td|}|}|}| }| }| } |d|j dd|||||| d|j ddd } t |d | S NrkrUpdate Agency: Update AgencyFUpdate  - FocusrY) rSrrrrrrrrrrPrRrrMrrOrjrHrLrrrrrrr+r r>rQr)rSrrrrrrrr?r?r@rX s.   zAgencyUpdateView.getc CsLtt|d}|jjs(|j|jkr(tdz||}||||}|rX|||||WS| |||}d|j kr| ||j d| ||dt |d|jdtd|jdWStk r}z*t |dt||||WYSd }~XYnJtk rF}z*t |d t||||WYSd }~XYnXd S) a! Handle agency update with comprehensive validation and error handling. Args: request: HTTP request object pk: Agency primary key Returns: HttpResponse: Redirect to agency detail or form with errors rkrr;rUrz " has been updated successfully!rrNr)rMrrOrjrHrLr_validate_form_data_updater_update_agencyrrrrrr+r r)rrfrirXr)r>rQr)rSrrZupdated_agencyrr?r?r@r s(    zAgencyUpdateView.postrYcCs |jdd|jdd|jdd|jdd|jdd|jdd|jdd|jd d|jd d|jd d|jd d |jdd|jd|jdd|jdd|jdd|jdd|jdddSrrrr?r?r@r6 s&  z#AgencyUpdateView._extract_form_datarc Csg}|ds|dnt|ddkr2|d|dsF|dn||ds^|d|dsr|d n8ztjj|dd Wn tjk r|d YnX|d rt|d dkr|d |drt|ddkr|d|dr||ds|d|dr8t|ddkr8|d|drzHt|d}t j }|dksr||dkr|d|ddWn t k r|dYnX|drz.t|d}|dks|dkr|dWn t k r|dYnX|d r,t|d d!kr,|d"|d#rRt|d#d$krR|d%|d&rxt|d&d$krx|d'|d(rt|d(dkr|d)d*|j kr|j d*}||} || |dr|d|jkrtjj|d|jd+d,j|jd } | r|d-|S).a6 Validate all form data for update and return list of errors. Args: form_data: Extracted form data request: HTTP request object agency: Existing agency object Returns: list: List of validation error messages r+r]rrr.rrr<rrrr,rr-rrr0rr/rrr1rrrrrrr3rrrr4rrr5rrr6rr7rr;Fr z/You already have another agency with this name.)r~r}r r$rTrXrr rrrhr rsrrrr+rrUrOZexcluder*r) r>rrQrSrr rrrrrr?r?r@rH\ sz                         z+AgencyUpdateView._validate_form_data_updatercCsbg}d}|j|kr|ddddddg}d|jkrH|jdd nd }||kr^|d |Srrrr?r?r@r s   " z$AgencyUpdateView._validate_logo_filerc Cstjj|dd}|d|_||_|d|_ddddd d d d d dddg }|D]>}||rjt||||qLt||tt||t rdndqL|drt |d|_ nd|_ |drt |d|_ nd|_ |d|_ ||S)a Update the agency with validated data. Args: form_data: Validated form data request: HTTP request object agency: Existing agency object Returns: Agency: Updated agency instance r<rr+r.r,r-r/r0r2r9r:r4r5r6r7r8r&Nr1r3r)r$rTrXr+rhr.setattr isinstancegetattrrirr1r3rrp)r>rrQrSrhrrr?r?r@rI s<   " zAgencyUpdateView._update_agencycCs||_|dSrrrr?r?r@r sz$AgencyUpdateView._handle_logo_uploadr c Cs|D]}t||q|}|}|}|} |} |} |d|jdd|||| | | |d|jddd } t |d| S) aY Render form with validation errors and preserve user input. Args: request: HTTP request object errors: List of error messages form_data: Form data to preserve agency: Existing agency object Returns: HttpResponse: Form with errors rBrCFrDrErY) rSrrrrrrrrrrrPrRr) rrfrrrrrrr+r ) r>rQrrrSrfrrrrrrrr?r?r@r s.  z)AgencyUpdateView._render_form_with_errorsr$c CszZtj|j|dd|jjd|d|j|t||jddt|j |j|ddWn0t k r}zt d |W5d }~XYnXd Sr%r&r'r?r?r@rB s   zAgencyUpdateView._log_activityr3cCsddl}d}|||dk Sr4r5r8r?r?r@r ] sz AgencyUpdateView._is_valid_emailr:cCsBz&ddlm}||}t|j|jgWStk r<YdSXdSr;r=r>r?r?r@r c s  zAgencyUpdateView._is_valid_urlc CslztjjddddWStk rfz$ttjjddddWYSgYYSXYnXdSr(r)r=r?r?r@rn sz"AgencyUpdateView._get_agency_typescCsddddddgSr*r?r=r?r?r@ry sz"AgencyUpdateView._get_size_choicesc Csddddddddd d g Sr+r?r=r?r?r@r sz,AgencyUpdateView._get_specialization_choicesc Csddddddddd d g Sr,r?r=r?r?r@r sz&AgencyUpdateView._get_timezone_choicesc Csddddddddd d g Sr-r?r=r?r?r@r sz&AgencyUpdateView._get_language_choicescCs*ddddddddd d d d d ddddddgSr0r?r=r?r?r@r s(z%AgencyUpdateView._get_country_choicesN)rBrCrDrErIrirJrXrrrrrHrrIrrrr?r r rrrrrrr?r?r?r@r@ s$-&a5 +   r@c@sdeZdZdZeeedddZddZddZ d d Z d d Z d dZ ddZ eeedddZdS)AgencyDeleteViewzNSoft-delete an Agency. Template: agencies/agency/confirm_delete.html rc Cstt|d}|jjs(|j|jkr(td|}|}|}| }| }| } |d|j dd|||||| d|j ddd } t |d | SrArFrGr?r?r@rX s.   zAgencyDeleteView.getc CslztjjddddWStk rfz$ttjjddddWYSgYYSXYnXdSr(r)r=r?r?r@r sz"AgencyDeleteView._get_agency_typescCsddddddgSr*r?r=r?r?r@r sz"AgencyDeleteView._get_size_choicesc Csddddddddd d g Sr+r?r=r?r?r@r sz,AgencyDeleteView._get_specialization_choicesc Csddddddddd d g Sr,r?r=r?r?r@r sz&AgencyDeleteView._get_timezone_choicesc Csddddddddd d g Sr-r?r=r?r?r@r" sz&AgencyDeleteView._get_language_choicescCs*ddddddddd d d d d ddddddgSr0r?r=r?r?r@r1 s(z%AgencyDeleteView._get_country_choicesc Cstt|d}|jjs(|j|jkr(tdt|_d|_ | t j |jdd|j |t||jdddt|jid t|d |j d td S) NrkrrrZdelete_agency_cbvzDeleted (soft) agency (CBV): rMr&rbrNrz" deleted successfully.zagencies:agency_list)rMrrOrjrHrLrrhr_rIrprrVr+rrWrXrir*rrr )r>rQr)rSr?r?r@rI s"      zAgencyDeleteView.postN)rBrCrDrErIrirJrXrrrrrrrr?r?r?r@rM s  rM)N)N)N)N)N)N)N)r&)r&)_osrrZrequestsr_Zmultiprocessing.spawnrZ django.viewsrZ django.confrr"rZ django.utilsrZdjango.contribrZdjango.shortcutsr r Zdjango.core.paginatorr r r Zdjango.contrib.auth.mixinsrZdjango.utils.translationrrtypingrrZdjango.contrib.auth.decoratorsrrrrrrrrrZapps.common.utilsrZapps.channels.modelsrZapps.activities.modelsrZapps.campaigns.modelsrrZapps.agencies.modelsrr r!r"r#r$r%Zapps.core.utilsrFrJr`rmrqrsrvrwrrrrrrrrrr-r0rFrHZ django.httprIrJrKrLrMZ django.urlsrNrOrrrr@rMr?r?r?r@s                 &  &     I '  "   #  k b    l%-h