whddlmZddlmZmZmZddlmZddlm Z ddl m Z m Z m Z mZmZddlmZmZddlmZddlmZGd d Zy ) )Session)DictAnyList)BytesIO)A4)SimpleDocTemplate ParagraphSpacerTable TableStyle)getSampleStyleSheetParagraphStyle)inch)colorsceZdZdZdefdZdededeee ffdZ dedeee ffdZ dedeee ffd Z dedeee ffd Z dedeee ffd Zdedeee ffd Zdedeee ffd Zdedeee ffdZdedeee ffdZdedeee ffdZdedeee ffdZdededeee ffdZdededefdZdeee fdefdZdeee fdefdZdeee fdefdZdeee fdefdZdeee fdefdZdeee fdefdZd eee fdefd!Zd"eee fdefd#Zd$eee fdefd%Zd&eee fdefd'Z defd(Z!dedede"fd)Z#d*eee fde$fd+Z%d,edefd-Z&y.)/DynamicReportServicezCService for generating dynamic reports using actual simulation datadbc||_y)N)r)selfrs M/var/www/html/retail-simulation-api/app/api/module_reports/dynamic_service.py__init__zDynamicReportService.__init__ s  simulation_idgroup_idreturnc^ ||id}|j||dd<|j||dd<|j||dd<|j||dd<|j ||dd<|j ||dd<|j ||dd <|j||dd <|j||dd <|j||dd <|S#t$r3}td t||j||cYd}~Sd}~wwxYw)z;Get all simulation data from database for dynamic reportingrrmodulesrmodule1module2module3module4module5module6module7module8module9module10zError getting simulation data: N)_get_module1_data_get_module2_data_get_module3_data_get_module4_data_get_module5_data_get_module6_data_get_module7_data_get_module8_data_get_module9_data_get_module10_data Exceptionprintstr_get_fallback_data)rrrsimulation_dataes rget_simulation_dataz(DynamicReportService.get_simulation_dataso) D!.$O594J4J84TOI &y 1594J4J84TOI &y 1594J4J84TOI &y 1594J4J84TOI &y 1594J4J84TOI &y 1594J4J84TOI &y 1594J4J84TOI &y 1594J4J84TOI &y 1594J4J84TOI &y 16:5L5LX5VOI &z 2" " D 3CF8< =**=(C C DsC-C00 D,9(D'!D,'D,c ddlm}ddlm}ddlm}|j j|j|j|k(j}|r |jnd|r |jnd|r |jndd}|j j|j|j|k(j}g}|D]@} |j| j | j"| j$| j&d B|j j|j|j|k(j} i} | D]I} | j(| j*| j,| j.| j&d | | j0<K||| d S#t2$r)} t5d t7| d digid cYd} ~ Sd} ~ wwxYw)zGet Module 1 data from databaser)TblBrand) TblSegment)TblStoreFormatzNot SetN Not provided) brand_name brand_logo rationale)name isec_segmenttotal_populationlocation) store_name store_size merchandisepricing_strategyrFbrandsegments store_formatszError getting Module 1 data: r@)app.models.main.brandr<app.models.main.segmentr=app.models.main.store_formater>rqueryfilterrfirstr@ brand_imagerBallappendrC ISEC_SegmentrErFrGrHrIrJstore_format_typer4r5r6)rrr<r=r>rL brand_datarM segments_datasegmentrN formats_data store_formatr9s rr*z&DynamicReportService._get_module1_data=s, ] 6 : DGGMM(+2283D3D3PQWWYE27e..Y38e//d05U__>Jww}}Z077 8K8Kx8WX\\^HM#$$#LL$+$8$8(/(@(@ ' 0 0 &$!GGMM.9@@AXAX\dAdeiikML - "."9"9"."9"9#/#;#;(4(E(E , 5 5 @ \;;<!.$)!-   ] 1#a&: ;*I6BY[\ \ ]sF-F00 G"9GG"G"c ddlm}ddlm}ddlm}|j j|j|j|k(j}g}|D]F}|jt|j|jxsd|jxsddH|j j|j|j|k(j}i} |D]3} | j } | | vri| | <| j"| | | j$<5|j j|j|j|k(j} i} | D]3}|j&|j(|j*d| |j,<5|| | dS#t.$r'}t1d t|giidcYd }~Sd }~wwxYw) zGet Module 2 data from databaser)TblCatchmentPotential)TblSalesEstimate)TblLocationDetailsg)rDpercentage_of_segmentpotential_households)trading_radius adjacencieslocation_characteristicscatchment_potentialsales_estimates locationszError getting Module 2 data: N)#app.models.main.catchment_potentialr`app.models.main.sales_estimatera app.models.main.location_detailsrbrrRrSrrVrWr6rXrcpotential_number_of_householdsstore_formate_typevalue parameterrerfrgrYr4r5)rrr`rarbcatchment_datacatchment_listcp sales_datarjsale format_type location_datarklocr9s rr+z&DynamicReportService._get_module2_datams3 W Q G K"WW]]+@AHH%..(:ce  N$%%$'$8-/-E-E-L,.,M,M,RQR'%'78?? ))X5ce !O""55 o535OK0?Czz ,T^^< #!GGMM*<=DD"++x7ce I$&)&8&8#&??030L0L4 #//0%(6#2&   W 1#a&: ;+-"SUV V WsF'F** G3GGGc ddlm}ddlm}|jj |j |j|k(j}g}|D]9}|j|jxsd|j|jd;|jj |j |j|k(j}i}|r?|jxsd|jxsd|j xsd|j"xsdd}||dS#t$$r&} t'dt)| gidcYd} ~ Sd} ~ wwxYw) zGet Module 3 data from databaser)TblNetworkPlanning)TblStoreInvestmentSummary) target_stores geographyyear)total_investment_format_atotal_investment_format_bcapital_expenses_format_acapital_expenses_format_b network_plansinvestment_summaryzError getting Module 3 data: N)app.models.main.network_planr|(app.models.main.store_investment_summaryr}rrRrSrrVrWr~geography_selectionrrT total_store_investments_format_a total_store_investments_format_b!capital_expenses_excl_it_format_a!capital_expenses_excl_it_format_br4r5r6) rrr|r} network_datarnetworkinvestment_datarr9s rr,z&DynamicReportService._get_module3_datasT& C G Z 77==);<CC"++x7ce M'$$%,%:%:%?a!(!eg "$ 1@1a1a1fef1@1a1a1fef1@1b1b1gfg1@1b1b1gfg &""/&8   C 1#a&: ;%'rB B CsDD E)E E Ec ddlm}ddlm}|jj |j |j|k(j}g}|D]:}|j|jr|jjnddddd<|jj |j |j|k(j}g}|D]@} |jd | j| jxsd| jxsdd B||d S#t$r&} t!d t#| ggd cYd } ~ Sd } ~ wwxYw)zGet Module 4 data from databaser) TblCategory)TblGrossMarginContributionUnknown Destination9@g>@) category_name category_rolesales_contributionmargin_contributionz Category )rcontribution_to_sales gross_margins categoriesmargin_contributionszError getting Module 4 data: N)app.models.main.categoryr*app.models.main.gross_margin_contributionsrrrRrSrrVrWchoose_categoryrqgross_idcontribution_to_total_salescontribution_to_gross_marginr4r5r6) rrrrr category_listcat margin_datargmr9s rr-z&DynamicReportService._get_module4_datasS# B < ]{3::;;O;OS[;[\``bJM!$$BEBUBUS%8%8%>%>[d%2*.+/ &"''--(BCJJ*33x?ce $& !$++'0 %>-/-K-K-Pq%'%D%D%I-",(<   B 1#a&: ;"$bA A BsD"D%% E.E EEc ddlm}ddlm}|jj |j |j|k(j}g}|D]P}|j|jxsd|jxsd|jxsd|jxsddR|jj |j |j|k(j}g}|D]P} |j| jxsd | jxsd | j xsd | j"xsd d R||dS#t$$r&} t'dt)| ggdcYd} ~ Sd} ~ wwxYw)zGet Module 5 data from databaser)TblVendorMetricsPriorityList)TblVendorScorecardQualityz Quality ScorezImportant for business)priorityareametricsremarkszMargin %rHighz15%)metric weightage importancebatnavendor_priority_matrixvendor_scorecardzError getting Module 5 data: N),app.models.main.vendor_metrics_priority_listr app.models.main.vendor_scorecardrrrRrSrrVrWrrrrrrrrr4r5r6) rrrr priority_datapriority_matrixrscorecard_data scorecardscorer9s rr.z&DynamicReportService._get_module5_datast' J a K!GGMM*FGNN,55Ace !O)&& ( 1 1 6Q$MM6Y'//B?'//K3K (*"WW]]+=>EE"++x7ce I'  #ll8j!&!8D"'"2"2"$>$RBR(/(@(@(XDX!(!2!2!O6O+*'9&8   H 1#a&: ;*,BG G HsDD E"E=EEc ddlm}ddlm}|jj |j |j|k(j}g}|D]P}|j|jxsd|jxsd|jxsd|jxsddR|jj |j |j|k(j}i}|r0|jxsd |j xsd |j"xsd d }||d S#t$$r&} t'dt)| gid cYd} ~ Sd} ~ wwxYw)zGet Module 7 data from databaser)TblIntegratedMarketing)TblMarketingCompetitorAnalysiszDigital MarketingrzBrand awarenesszReach and engagement) activity_namebudget_allocated objectivemeasurement_metricrz Comprehensive marketing approachzCommunity-focused marketing)reference_retailermarketing_activity_briefdifferentiationmarketing_activitiescompetitor_analysiszError getting Module 7 data: N)$app.models.main.integrated_marketingr-app.models.main.marketing_competitor_analysisrrrRrSrrVrWrrrrrTrrrr4r5r6) rrrrmarketing_datar marketingcompetitor_datarr9s rr0z&DynamicReportService._get_module7_dataIsc& K S d"WW]]+ABII&//8;ce $& + $++%.%<%<%S@S(1(B(B(Jd!*!4!4!I8I*3*F*F*`J` -,#ggmm,JKRR.778Ceg #% *9*L*L*\P\0?0X0X0~\~'6'F'F'gJg'#)=':   K 1#a&: ;,.rJ J KsD%D(( E1E EEc ddlm}ddlm}ddlm}|j j|j|j|k(j}g}|D]A}|j|jxsd|jxsd|jxsddC|j j|j|j|k(j}g} |D]L} | j| jxsd | j xsd | j"xsd| j$d N|j j|j|j|k(j} g} | D]=} | j| j&xsd | j(xsd | j*d?|| | dS#t,$r'}t/dt1|gggdcYd}~Sd}~wwxYw)zGet Module 8 data from databaser)TblCorporateConceptOffice)TblStoreLevelStaffNeeds) TblUtilityzSenior LeadershipgO2A) role_categorycost_to_companyy1_countManagerg@) designationaverage_salarycountrY ElectricitygL@) utility_namecost_per_monthrYcorporate_roles staff_needs utilitieszError getting Module 8 data: N)(app.models.main.corporate_concept_officer'app.models.main.store_level_staff_needsrapp.models.main.utilityrrrRrSrrVrWrry1rrrrprrrYr4r5r6)rrrrrcorporate_datarrole staff_datarstaffutilities_datarutilityr9s rr1z&DynamicReportService._get_module8_datass5 O Z W :"WW]]+DELL)22h>ce !O&&&%)%7%7%N;N'+';';'Hy $ 1(''>?FF'00H<ce K#""#(#4#4#A &+&:&:&Eg"[[-A).)A)A $$"WW]]:6==##x/ce I)  $+$8$8$IM&-&<&<&G)0)B)B"*$3*&   O 1#a&: ;')"2N N OsGG G8G3-G83G8c  ddlm}|jj|j |j |k(j }g}|D][}|j|j|jxsg|jxsd|jxsd|jxsdd]d|iS#t$r%}tdt|dgicYd}~Sd}~wwxYw) zGet Module 9 data from databaser)TblAdaptingSupplyChainNo) adapting_idrradaptation_neededrBsupply_chain_entrieszError getting Module 9 data: N)%app.models.main.adapting_supply_chainrrrRrSrrVrWrwhat_are_some_categoriesremarks_about_these_categoriesdo_you_think_you_needat_which_point_and_whyr4r5r6)rrrsupply_chain_datarentryr9s rr2z&DynamicReportService._get_module9_datas 0 T!% .D E L L&//8;!ce $& *$++#(#4#4"'"@"@"FB$CCIr).)D)D)L!&!=!=!C -+'(<  0 1#a&: ;*B/ / 0sB0B33 C!<CC!C!c ddlm}||j}|j|}i}|rd|vrO|d}|j dd|j dd|j dd |j d d d |d <d|vrO|d}|j dd|j dd|j dd|j d dd |d<d|vr>|d}|j dd|j dd|j ddd|d<||dS#t $r&} t dt| iidcYd} ~ Sd} ~ wwxYw)z;Get Module 10 data from database using the existing servicer)DatabaseServicemodel_a_assumptionsB6B7B82B9g@)sales_per_sqft gross_margin store_countinvestment_per_storezStore Format A ROImodel_b_assumptionsg@zStore Format B ROIonline_assumptionsB5i i ) customer_baseaverage_order_valuemarginzOnline Businessinputscalculated_metricszError getting Module 10 data: N)#app.api.module10_metrics.db_servicerrget_simulation_inputsgetr4r5r6) rrr db_servicer'rmodel_amodel_bonliner9s rr3z'DynamicReportService._get_module10_datass+ < K(1J55h?FG(F2$%:;G*1++dB*?(/ D"(='.{{4'<07 D#0F 5G01)F2$%:;G*1++dB*?(/ D"(='.{{4'<07 D#0F 5G01(61#$89F)/D&)A/5zz$/E"(**T2"62G-.!&-   < 23q6(; < ; ; Comprehensive Simulation Report - Group a��

Comprehensive Retail Simulation Report

Simulation ID: rz$
Group ID: rz,
Report Generated: z
rr  r!r"r#r$r%r&r'r(r)z
Summary & Conclusions

Key Insights:

  • Brand Strategy: rLr@z with rMz4 target segments
  • Network Planning: rz? network plans developed
  • Category Management: rz< categories analyzed
  • Marketing Activities: rz> marketing initiatives planned
  • Supply Chain: rzJ supply chain adaptations evaluated
)r:join_get_current_timestamp_generate_module1_html_generate_module2_html_generate_module3_html_generate_module4_html_generate_module5_html_generate_module6_html_generate_module7_html_generate_module8_html_generate_module9_html_generate_module10_htmllen)rrrr8 html_contents r"generate_comprehensive_html_reportz7DynamicReportService.generate_comprehensive_html_report s22=(K2 2 42 5=: 2 >% 2 *&5_%E$F+2 *G +2 ,!0 ;<-2 ,=(-2 .)-(C(C(E'F/2 .G/2 4_Y7 BCD52 4E52 6_Y7 BCD72 6E72 8_Y7 BCD92 8E92 :_Y7 BCD;2 :E;2 <_Y7 BCD=2 <E=2 >_Y7 BCD?2 >E?2 @_Y7 BCDA2 @EA2 B_Y7 BCDC2 BEC2 D_Y7 BCDE2 DEE2 Foi8DEFG2 FGG2 R-Y7 B7KLYZS2 R[aS2 Rbeetu~eAJfKLVfWbXaYS2 RYS2 T #?9#=i#H#YZ[U2 T\"U2 V#&oi&@&KL&Y"Z![W2 V\#W2 X$'y'A)'LMc'd#e"fY2 XgY2 Zy9)DE[\]^[2 Z_[2 hr module1_datac `|d}|d}|d}d}t|dD]*\}}|d|d|dd|d d|d xsd d|d d z },d}|jD]&\} } |d| d| dd| dd| dd| dd z }(d|dd|dxsdd|dd|r|ndd|r|d Sdd S)zGenerate Module 1 HTML sectionrLrMrNrrz. Segment  rCrDrE Not specifiedrF & rGrHrIrJz
Module 1: Brand, Customers & Stores
Brand Details
Brand Namer@z*
Brand LogorAr?z)
RationalerBz
Customer Segments
zHz
SegmentNameISEC CategoryPopulationLocation
No segments data available
Store Formats
zM
Format TypeStore NameSize (sq ft)MerchandisePricing Strategy
No store formats data available
) enumerateitems) rrCrLrMrN segments_htmlir\ formats_htmlrx format_datas rr6z+DynamicReportService._generate_module1_htmlDsW% +$_5  #Ha0JAw "C V_%&^,-./0CODEZ()*  M1 (5(;(;(= $K ! M" ./0 ./0 /01 !3456  L)>5 6;<5H4IJ %l 3 E~FG$[123 $])stu "\wx' &(wwx' r module2_datac |d}|d}|d}d}|D]}|d|dd|dd |d d d z }d |r|nddt|dt|dS)zGenerate Module 2 HTML sectionrirjrkrrHrDrErc% rd,rGz
Module 2: Location Analysis
Catchment Potential
zIz
ISEC CategoryPercentage of SegmentPotential Households
No catchment data available
Sales Estimates Summary

Store Formats Analyzed: z2

Location Parameters: z locations defined

)r@)rrP catchmentsalesrkcatchment_htmlrus rr7z+DynamicReportService._generate_module2_htmlws !67 ./ - B #'()/012./23  N &^+vwx1 25U =..1)n-=> r module3_datac  |d}|d}d}|D]}|d|dd|dd|dd z }d |r|nd d |jd ddd|jdddd|jdd|jddzdd S)zGenerate Module 3 HTML sectionrrrz+ Year rrEr~rrGz
Module 3: Network Planning
Network Expansion Plans
zHu
YearTarget StoresGeography
No network plans available
Investment Summary
Store Format A Investment₹rrz,.2fuQ
Store Format B Investment₹ruP
Total Capital Investment₹rr
r+)rrWr investment network_htmlplans rr8z+DynamicReportService._generate_module3_htmls$_5 !"67  !D !v,(/*+,+&'(  L" "\'qrsG HR~~VqstGuvzF{|GGQ~~VqstGuvzF{|FFPnnUprsFtxBxFxFGbdexfGfgkFll r module4_datac |d}|d}d}|D] }|d|dd|dd|dd |d d z }"d}|D]}|d|dd|d d |d d z }d|r|ndd|r|dSddS)zGenerate Module 4 HTML sectionrrrrHrrErrrRrz% rrz
Module 4: Category Management
Category Roles
zJz
CategoryRoleSales ContributionMargin Contribution
No categories data available
Gross Margin Contributions
zFrIr1)rr^rmarginscategories_htmlr margins_htmlr%s rr9z+DynamicReportService._generate_module4_htmls!,/ 56C $)*+)*+-./0./01   O F !O,-.3456O,-.  L (_-yz{ "\pq (ppq r module5_datac |d}|d}d}|D] }|d|dd|dd|dd|d d z }"d}|D] }|d|d d|d d |dd|dd z }"d|r|ndd|r|dSddS)zGenerate Module 5 HTML sectionrrrrHrrErrrrGrrrRrrz
Module 5: Vendor Management
Vendor Priority Matrix
CategorySales ContributionGross Margin
No margin data available
zOz
PriorityAreaMetricsRemarks
No priority matrix data available
Vendor Scorecard
zIrIr1)rrcrr priority_htmlrscorecard_htmlrs rr:z+DynamicReportService._generate_module5_htmls)&'?@ !34  'H "j)*+f%&'i()*i()*  M(E #8_%&;'()<()*7^$%  N $])z{| &^wx ,wwx r module6_datac |d}|d}d}|D]}|d|dd|dd|dd z }d |jd d d |jdd d|jdd d|r|d Sdd S)zGenerate Module 6 HTML sectionrrrrHr^rErJrBrGz
Module 6: Pricing & Promotions
Competitor Pricing Analysis
MetricWeightageImportanceBATNA
No scorecard data available
Reference CompetitorrrFz0
Pricing Strategyz0
Key Observationsrz
Store Format Pricing Strategies
zRrIrZ)rrgrrstrategies_htmlstrategys rr;z+DynamicReportService._generate_module6_htmls)*>?)*>?*H $n-./0123k*+,   O+* +=*@*@AWYh*i)jk&&8&<&<=OQ`&a%bc&&8&<&<=OQ`&a%bc (_CC .BCC r module7_datac |d}|d}d}|D] }|d|dd|dd|d d|d d z }"d |r|nd d|jddd|jddd|jddd S)zGenerate Module 7 HTML sectionrrrrHrrErrRrrrGz
Module 7: Marketing & Communications
Marketing Activities
Store FormatPricing StrategyRationale
No pricing strategies data available
zTzz
ActivityBudget %ObjectiveMeasurement Metric
No marketing activities data available
Competitor Marketing Analysis
z
Module 10: Metrics & Performance Indexes
Key Performance Metrics
Reference RetailerrrFz/
Marketing Briefrz/
DifferentiationrrYrZ)rrkrractivities_htmlactivitys rr<z+DynamicReportService._generate_module7_html%s+,BC*+@A,H $o./00123k*+,2345   O- (_.DEE( )<(?(?@TVe(f'gh%%8%<%<=WYh%i$jk%%8%<%<=NP_%`$ab r module8_datac .|d}|d}|d}d}|D]}|d|dd|dd d |d d z }d}|D]!}|d|d d|dd d |dd |dd z }#d} |D]} | d| dd| dd d | dd z } d|r|ndd|r|ndd| r| dSddS)zGenerate Module 8 HTML sectionrrrrrHru ₹rz,.0frErrGrrrrYrrz
Module 8: Services & Utilities
Corporate Office Roles
zOz
Role CategoryCost to CompanyYear 1 Count
No corporate roles data available
Store Level Staff
zEz
DesignationAverage SalaryCountStore Format
No staff data available
Utilities
zIrIr1) rrorrrcorporate_htmlr staff_htmlrutilities_htmlrs rr=z+DynamicReportService._generate_module8_htmlEs&'89"=1  - #D #/*+,./56*%&'  N$  E =)*+./567^$%./01  J! G #^,-. 01$780123  N! &^+|}~ Z#jkl &^wx% $,wwx% r module9_datac |d}d}|D]X}t|dtrdj|dn t|d}|d|dd|d|dd|d d|d d z }Zd |r|nd dt |dt d|DdS)zGenerate Module 9 HTML sectionrrrz, rHrrErrrBrGz
Module 9: Backend & Supply Chain
Supply Chain Adaptation Analysis
Utility TypeCost per MonthStore Format
No utilities data available
zLzL
IDCategoriesRemarksAdaptation NeededRationale
No supply chain data available

Total Entries: z1

Adaptations Needed: c3NK|]}|djdk(sdyw)ryesrN)lower).0r s r z>DynamicReportService._generate_module9_html..s61E@TuX]^qXrXxXxXzDYD@Ts%%z

) isinstancelistr4r6r@sum)rrtr entries_htmlr categories_strs rr>z+DynamicReportService._generate_module9_html}s+,BC )E?I%P\J]_c?dTYYu\':;jmnsuAoBkCN !=)*+#$%9%&'./01;'()  L* "\'uvw(),,@(A'BC--01E@T1E.E-FF  r module10_datac :|d}|d}d}|jD][\}}t|ts|jD]2\}}|d|d|jddj d|d z }4]d |r|nd d t |d t |dS)zGenerate Module 10 HTML sectionr'r(rz6
z - _ z7 z
zGzK
MetricValue
No metrics data available

Data Sources: zL input categories processed

Calculated Metrics: z# performance indicators

)rKr{dictreplacetitler@) rrr'r metrics_html metric_name metric_datakeyrqs rr?z,DynamicReportService._generate_module10_htmlsx( 45 (/  $K+t,"-"3"3"5JC )(MS[[c-B-H-H-J,KL2279%L#6)8 "\'pqr'(+6{m4--0\N;  rcLddlm}|jjdS)z Get current timestamp for reportr)datetimez%Y-%m-%d %H:%M:%S)rnowstrftime)rrs rr5z+DynamicReportService._get_current_timestamps%||~&&':;;rc |j||}t}t|tdddd}t }g}t d|ddddd }|j td ||j tddd t|d gd t|dgd|jgd|ddddgdtt|dddgdtt|dddgg} t| dtzdtzg} | jtdddd d!dt j"fd"d#g|j | |j tdd|j%|j'|||j)||j+d$|S)%z2Generate comprehensive PDF report with all modulesr)pagesize leftMargin rightMargin topMargin bottomMargin CustomTitleHeading1r"rrHelvetica-Bold)parentfontSize spaceAfter alignmentfontNamez&Comprehensive Retail Simulation Reportz Simulation IDrzGroup IDrzReport Generatedz Brand Namerr rLr@zTotal SegmentsrMz Network Plansr"rr) colWidths)ALIGNrrrLEFT)FONTNAMEr)rrrGRIDrr)VALIGNrrTOP)FONTSIZErr r)r:rr rrrrWr r r6r5r@r rsetStyler rblackextend_generate_pdf_module_sectionsbuildseek) rrrr8bufferdocstylesstory title_style summary_data summary_tables r!generate_comprehensive_pdf_reportz6DynamicReportService.generate_comprehensive_pdf_reports22=(KPR^`oqr$&% *%%    YGUV VAr]#c//"BC D _Z89 : ! ? ?95i@I,W X s3y'A)'LZ'X#YZ [ c#oi&@&KO&\"]^ _  lqvqv6FG z / ; VXq&,, 7 / . +     ]# VAr]#  T77PQ % A rr8c g}td|ddddtj}tddD]}d |}||d vs|d |}|j t d |d |j |||dk(rV|j t d |dd|d|j t dt|d|dn|dk(r/|j t dt|d|dn|dk(r/|j t dt|d|dne|dk(r/|j t dt|d|dn1|dk(r.|j t dt|d|dn|dk(r.|j t d t|d!|dn|d"k(r.|j t d#t|d$|dn|d%k(r.|j t d&t|d'|dne|d(k(r.|j t d)t|d*|dn2|d+k(r-|j t d,t|d-|d|j tdd|S).z%Generate PDF sections for all modules ModuleHeaderHeading2rr)rrrr textColorr modulerModule z: zBrand: rLr@Normalz Segments: rMrzCatchment Areas: rirzNetwork Plans: rz Categories: rzVendor Priorities: rzPricing Strategies: rzMarketing Activities: rzCorporate Roles: r zSupply Chain Entries: rrzPerformance Metrics: r() rrdarkbluerangerWr _get_module_namer@r )rr8rr module_style module_num module_key module_datas rrz2DynamicReportService._generate_pdf_module_sectionss& *%%oo   2,J!*.J_Y77-i8D  Y Bt?T?TU_?`>a'bdpqr?LLW[5I,5W4X+Y[abj[k!lmLLZK s;OdCe?f>g+hjpqyjz!{|1_LL_S_A]=^<_+`bhiqbr!st1_LL\#k,>W:X9Y+Z\bck\l!mn1_LL-@[QiEjAk@l+mouv~o"AB1_LL-A#kRfFgBhAi+jlrs{l|!}~1_LL-CC TjHkDlCm+npvwqA"BC1_LL->s;O`Ca?b>c+dflmufv!wx1_LL-CC TjHkDlCm+npvwqA"BC2%LL-B3{SgGhCiBj+kmst|m}!~ VAr]+='@ rrc Fddddddddd d d }|j|d |S) zGet module name by numberzBrand, Customers & StoreszLocation AnalysiszNetwork PlanningzCategory ManagementzVendor ManagementzPricing & PromotionszMarketing & CommunicationszServices & UtilitieszBackend & Supply ChainzMetrics & Performance Indexes) rrrrrrrrrrrrZ)rr module_namess rrz%DynamicReportService._get_module_name!sE+"!$"%+%'/   gj\,BCCrN)'__name__ __module__ __qualname____doc__rrintrr6rr:r*r+r,r-r.r/r0r1r2r3r7rBr6r7r8r9r:r;r<r=r>r?r5rrrrrr1rrrr sM7+D+D+DSRUX+DZ.]#.]$sCx..]`5W#5W$sCx.5Wn(C#(C$sCx.(CT%B#%B$sCx.%BN)J#)J$sCx.)JV'H#'H$sCx.'HR(K#(K$sCx.(KT7O#7O$sCx.7Or0#0$sCx.08-<3-<4S>-<^  s tCQTH~ &88s8WZ8t14S>1c1f4S>c>4S>c>&4S>&c&P'4S>'c'R4S>c>4S>c@64S>6c6p4S>c>T#s(^<<< /s/c/V]/b/T#s(^/X\/bD3D3DrrN)sqlalchemy.ormrtypingrrriorreportlab.lib.pagesizesrreportlab.platypusr r r r r reportlab.lib.stylesrrreportlab.lib.unitsr reportlab.librrr1rrrs1"""&VVD$ eDeDr