G /ikDddlmZddlmZddlmZmZddlZddl Z ddl m Z ddl m Z ddl mZddlmZmZmZmZmZmZmZdd lmZdd lmZdd lmZdd lmZdd lm Z ddl!m"Z"ddl#m$Z$ddl%m&Z&ddl'm(Z(ddl)m*Z*ddl+m,Z,m-Z-m.Z.m/Z/m0Z0m1Z1m2Z2m3Z3ddl4m5Z5GddZ6y)) HTTPException)Session) Environment BaseLoaderN)datetime)BytesIO)A4)SimpleDocTemplate ParagraphSpacerTable TableStyleImage PageBreak)getSampleStyleSheet)colors)TblBrandAttributeAssessment)TblBrandingAttributes)TblIntegratedMarketing)TblMarketingCompetitor)TblOptimisingAssets) TblSummary)TblGroup) SummaryCreate)BrandAttributeAssessmentBrandingAttributesMarketingAndCommunicationIntegratedMarketingMarketingCompetitorOptimisingAssetsSummaryModule7ReportPreview)JWTPayloadSchemacleZdZdedefdZdedefdZdede fdZ d ede fd Z dede fd Z ded e fd Z y)Module7ReportServicedbtokenc ||_||_y)N)r&r')selfr&r's F/var/www/html/retail-simulation-api/app/api/module_7_report/service.py__init__zModule7ReportService.__init__$s group_idreturnc K|s tdd|jjtj |j xs9|jjt j |j xs|jjtj |j xs|jjtj |j xs||jjtj |j xs=|jjtj |j }|r|jjtj |j }|jjt j |j }|jjtjtjj |j }|jjtj |j}|jjtj |j }|jjtj |j}|jjtj |j } t|} |rt|j|j t#|j$t&rdj)|j$nt+|j$xsd|j,|j.} g} |D]0} | j1t3| j4t#| j6t&rdj)| j6nt+| j6xsdt#| j8t&rdj)| j8nt+| j8xsd| j:t#| j<t&rdj)| j<nt+| j<xsd| j>| j.3tA|| |rtCdi|jDn tC|tG|r |jnd |r |jnd| |D cgc]} tIdi| jDc} xs tI|g|rtKdi|jDn tK|| xs t3|g| rtMdi| jDn tM|tNjPjS S|jjtTj |j }|rxtA|t|tC|tG|tI|gtK|t3|gtM|tNjPjS Std d cc} ww)z,Fetch module 7 data from all related tables.izgroup_id is required) status_codedetail)r-z, N/A)brand_iddefine_research_methodologyname_top_10_attributesremarksr-) optimising_idspace_resources_for_incomenon_space_resources_for_incomepercentage_of_salespredictions_around_changes"changes_in_marketing_communicationr-g)marketing_budgetrationalr-) r-brand_attribute_assessmentbranding_attributesmarketing_and_communicationintegrated_marketingmarketing_competitoroptimising_assetssummary last_updatedizGroup ID not found in database)+rr&queryr filter_byfirstrrrrrr=r>allrr3r4 isinstancer5listjoinstrr6r-appendr r7r8r9r:r;r<r"r__dict__rrrr!pd Timestampnowr)r)r-module_data_existsr?r@marketing_and_communication_rowrBrCrDrEbrand_assessment_dataoptimising_assets_dataoaim group_existss r*_fetch_module7_dataz(Module7ReportService._fetch_module7_data(svC8NO O GGMM5 6 @ @( @ S Y Y [ K GGMM/ 0 : :H : M S S U K GGMM0 1 ; ;X ; N T T V K GGMM0 1 ; ;X ; N T T V K GGMM- . 8 8( 8 K Q Q S  K GGMM* % / / / B H H J  )-7R)S)])]go)])p)v)v)x &"&''--0E"F"P"PZb"P"c"i"i"k .2ggmm>7@@ )%&( "'&--.>"$"2"2[efhgDgDFJ\Ktyy9V9V/WQTUWUrUrU{v{Q|cmnpoPoPRVdW499R=^=^3_]`acaBaBaKFK]L(*(>(>[efhgDgDFJ\Ktyy9V9V/WQTUWUrUrU{v{Q|797\7\[[/((!+@Zm$6$V9L9U9U$VtFPXtY,EYx%D%U%UBIh<EEns%- Th%hSgR&9&HBKK&HSg%h&UnAKSnTmU]q%8%Y;O;X;X%YxKU]x^"8"a=MW_=`3'"2"23GU]D^\\--/ " 77==2<

Module 7 Report – Marketing & Communication

Brand Attribute Assessment

Define Research Methodology{{ report.brand_attribute_assessment.define_research_methodology }}
Top 10 Attributes{{ report.brand_attribute_assessment.name_top_10_attributes }}
Remarks{{ report.brand_attribute_assessment.remarks }}

Branding Attributes

Attributes{{ report.branding_attributes.attributes }}
Reference Retailer 1{{ report.branding_attributes.reference_retailer_1 }}
Reference Retailer 2{{ report.branding_attributes.reference_retailer_2 }}
Own Brand{{ report.branding_attributes.own_brand }}

Marketing & Communication

Marketing Budget{{ report.marketing_and_communication.marketing_budget }}
Rationale{{ report.marketing_and_communication.rational }}

Integrated Marketing Activities

{% for im in report.integrated_marketing %}
Activity Name{{ im.activity_name }}
Budget Allocated{{ im.budget_allocated }}
Objective{{ im.objective }}
Measurement{{ im.measurment }}
Target Shopper Journey{{ im.target_shopper_journey }}
Actions{{ im.actions }}
{% endfor %}

Marketing Competitor Analysis

Reference Retailer{{ report.marketing_competitor.name_of_the_refereance_retailer }}
Marketing Communication{{ report.marketing_competitor.marketing_communication }}
Planned Activities{{ report.marketing_competitor.plan_activities }}

Optimising Assets for Revenue

{% for oa in report.optimising_assets %}
Space Resources for Income{{ oa.space_resources_for_income }}
Non-space Resources for Income{{ oa.non_space_resources_for_income }}
Percentage of Sales{{ oa.percentage_of_sales }}
Predictions Around Changes{{ oa.predictions_around_changes }}
Changes in Marketing Communication{{ oa.changes_in_marketing_communication }}
{% endfor %}

Summary

Marketing Submissions{{ report.summary.marketing_submissions }}
Summary{{ report.summary.marketing_summarise }}
)loader)r])rr from_stringrender)r)r]templateenvs r* _render_htmlz!Module7ReportService._render_html}s:I T.x(//v/>>s8:datac"t}t|tdddd}t}g} t ddd}d|_|j ||j tdd |d }d|_|j td ||j tdd |d }d|_ d |_ d} |j td|d|j tdd td|td|gtd|tt|jjxsd|gtd|tt|jjxsd|gtd|tt|jj xsd|gg} t#| } | j%t'ddddt(j*fddddt(j*fdddd d!d"d#d$d%d&d'g |j | |j tdd(|j td)|d|j tdd td|td|gtd*|tt|j,j.xsd|gtd+|tt|j,j0xsd|gtd,|tt|j,j2xsd|gtd-|tt|j,j4xsd|gtd.|tt|j,j6xsd|gg} t#| } | j%t'ddddt(j*fddddt(j*fdddd d!d"d#d$d%d&d'g |j | |j tdd(|j td/|d|j tdd td|td|gtd0|t| |j8j:|gtd1|tt|j8j<xsd|gg}t#|}|j%t'ddddt(j*fddddt(j*fdddd d!d"d#d$d%d&d'g |j ||j tdd(|j td2|d|j tdd td3|td4|td5|td6|td7|td8|g}|g}|j>D]}t|j@xsd|t|jBr| |jBnd9|t|jDxsd|t|jFxsd|t|jHxsd|t|jJxsd|g}|j |t#|d:}|j%t'ddddt(j*fddddt(j*fdd;dd|tt|jLjNxsd|gtd?|tt|jLjPxsd|gtd@|tt|jLjRxsd|gg}t#|}|j%t'ddddt(j*fddddt(j*fdddd d!d"d#d$d%d&d'g |j ||j tdd(|j tU|j tdA|d|j tdd tdB|tdC|tdD|tdE|tdF|g}|g}|jVD]}t|jXxsd|t|jZxsd|tt|j\xsdG|t|j^xsd|t|j`xsd|g}|j |t#|d:}|j%t'ddddt(j*fddddt(j*fdd;dd.format_currencys~1&' 'r,zBrand Attribute AssessmentHeading2z Fieldz ValuezDefine Research Methodologyr2zName Top 10 AttributesRemarksGRIDrrrg?BOX)FONTNAMErrrzHelvetica-Bold)FONTSIZErrrw)rrrrr Helvetica)rrrrw) LEFTPADDINGrr) RIGHTPADDINGrrr) TOPPADDINGrrr) BOTTOMPADDINGrrr)VALIGNrrTOP)ALIGNrrrq)WORDWRAPrrT zBranding Attributes AttributeszReference Retailer 1zReference Retailer 2z Own BrandzBrand Positioning StatementzMarketing and CommunicationzMarketing BudgetRationalzIntegrated MarketingzActivity
NamezBudget
Allocated Objective MeasurementzTarget Shopper
JourneyActionsry) repeatRows)rrr)rrrrzMarketing CompetitorzName of Reference RetailerzMarketing CommunicationzPlan Activitiesz Brand JourneyzSpace Resources
for Incomez"Non-Space Resources
for IncomezPercentage
of SaleszPredictions Around
Changesz&Changes in Marketing
Communicationrr!zMarketing SubmissionszMarketing SummarisezLast Updated: z%Y-%m-%d %H:%M:%Sz %Y%m%d_%H%M%Smodule7_complete_report_group__z.pdfzuploaded_files/T)exist_okwbNuploaded_files)Crr r rrhAlignrPr alignmentr fontSizeleadingrOr?r4r5r6r setStylerrblackr@ attributesreference_retailer_1reference_retailer_2 own_brandbrand_positioning_statementrAr=r>rB activity_namebudget_allocated objective measurmenttarget_shopper_journeyactionsrCname_of_the_reference_retailermarketing_communicationplan_activitiesrrDr8r9r:r;r<rEmarketing_submissionsmarketing_summariserFstrftimebuildseekrrTr-osmakedirspathdirnameopenwritegetvaluerN)!r)rebufferdocstylesstorylogo title_style normal_styler{ brand_data brand_table branding_databranding_tablemarketing_datamarketing_tableintegrated_headersintegrated_rows integratedrowintegrated_tablecompetitor_datacompetitor_tableassets_headers assets_rowsasset assets_table summary_data summary_table timestampfilenamefilepathfs! r*_generate_pdf_reportz)Module7ReportService._generate_pdf_reports* PR^`oqr$& c"=D DK LL  LL2 ' Wo !  YI;WX VAr]#h' ! !  (  Y;VJ=OPQ VAr]#~| 4iP\6] ^ 4l CYsSWSrSrTOTOTXSXPY[gFh i / > #dNmNmOEOEONINKOQ]A^ _ y, /3t?^?^?f?f?ojo;pr~1 A  J' Z VXsFLL 9 FHa 6 ; , 7 - 0 1 / 2 / / 0)    [! VAr]#  Y4fZ6HIJ VAr]#~| 4iP\6] ^ |\ 2Ic$BZBZBeBeBnin>oq}4~  -| PQR VAr]#~| 4iP\6] ^ )< 8)OTXTtTtUFUFEGIU;V W z< 0)C@`@`@i@i@rmr 6 E > M  && ++E%::Ce\R%>>G%V#e77<1=|L%::Ce\R%BBKe\Z C   s #,[Q7 j VXsFLL 9 FHa 6 ; , 7 - 0 1 / 2 / / 0*    \" VAr]#  Yy&*<=> VAr]#~| 4iP\6] ^ . =yT\\MoMoMxsxIy|H@I J ,l ;Ys4<E F l+ z VXsFLL 9 FHa 6 ; , 7 - 0 1 / 2 / / 0+    ]# VAr]#  VAr]# Y0A0A0J0JK^0_/`acijrcstu % ALLN++O< 3DMM?!I;dS$XJ/ BGGOOH-= (D !Q GGFOO% &"ww||,h77o  f" !sAs=5 t=ttcK|j|d{}|j|}|j|||S7)w)z3Generate PDF and save to database, return file pathN)r\r_save_file_path_to_db)r)r- report_data file_paths r*generate_and_save_pdfz*Module7ReportService.generate_and_save_pdfsD 44X>> --k:  ""8Y7?sAA*Arc d|d}td||jjtj tj |k(j }|rStd||_|jj|jj|tdy tdt|||}|jj||jj|jj|td|jy #t$rF}|jjtd |d d l}|jYd }~y d }~wwxYw) z;Save or update file path in summary table with group_id_modg_m7z6DEBUG: Looking for existing record with group_id_mod: z5DEBUG: Found existing record, updating uploaded_filesz"DEBUG: Updated record successfullyz1DEBUG: No existing record found, creating new one)r- group_id_modrz+DEBUG: Created new record with summary_id: z$ERROR saving file path to database: rN)printr&rHrfilterrrJrcommitrefreshadd summary_id Exceptionrollback traceback print_exc)r)r-rrexisting_summary new_summaryers r*rz*Module7ReportService._save_file_path_to_dbs: "xj,L J<.Y Z#ww}}Z8?? @W@W[g@ghnnp MO2; /  01:<IK(%!-#,  K(  ,CKDZDZC[\] " GG    8< =     ! !  "sB5D:8BD:: F r sd!"* &hhh4 REGPM.*0   ;r"r"r,