~ iddlmZddlmZmZmZddlmZddlm Z ddl m Z m Z m Z mZmZddlmZmZddlmZddlmZdd lmZdd lmZdd lmZdd lmZdd lm Z ddl!m"Z"ddl#m$Z$ddl%m&Z&ddl'm(Z(ddl)m*Z*ddl+m,Z,ddl-m.Z.ddl/m0Z0ddl1m2Z2ddl3m4Z4ddl5m6Z6ddl7m8Z8ddl9m:Z:ddl;mZ>ddl?m@Z@ddlAmBZBddlCmDZDdd lEmFZFdd!lGmHZHd"d#lImJZJmKZKmLZLmMZMmNZNmOZOmPZPmQZQmRZRmSZSmTZTmUZUmVZVmWZWmXZXmYZYmZZZm[Z[m\Z\m]Z]m^Z^m_Z_m`Z`maZambZbmcZcmdZdmeZemfZfmgZgmhZhmiZimjZjmkZkmlZlmmZmmnZnmoZompZpd$eqd%erfd&ZsGd'd(ZtGd)d*ZuGd+d,ZvGd-d.ZwGd/d0ZxGd1d2Zyy3)4)Session)ListDictAnyBytesIOA4SimpleDocTemplate ParagraphSpacerTable TableStyle)getSampleStyleSheetParagraphStyleinchcolors)TblBrand) TblSegment)TblStoreFormat)TblCivil)TblDisplayRackingUnit) TblCarpentry)TblElectricalCabling)TblCommercialEquipment)TblDisplayBoard) TblInfoTech)TblVisualMerchElements) TblPlumbing)TblDepreciation)TblCatchmentPotential)TblCompetitorIntensity)TblLocationDetails)TblSalesEstimate)TblRentExpenses)TblLocationSpillageFactor)TblProjectedMarketShare)TblCompetitorBenchmarking)TblCorporateConceptOffice)TblStoreLevelStaffNeeds) TblUtility)TblOperatingExpenses)'AdaptingSupplyChainDataBrandReportDataModule3ReportResponseModule4ReportResponseModule7ReportResponseModule9ReportResponseSegmentReportDataStoreFormatReportDataCapitalExpenseReportDataDepreciationReportDataModule1ReportResponseCustomerSegmentEstimateCatchmentPotentialDataCompetitorBenchmarkDataLocationCharacteristicsSalesEstimateDataRentExpenseDataModule2ReportResponseVendorPriorityMatrixDataVendorScorecardDataPrivateLabellingDataCategoryCaptainshipDataModule5ReportResponseModule6ReportDataCompetitorPricingAnalysisStoreFormatPricingCategoryPricingCompetitorPromotionsAnalysisYearlyPromotionCompetitorLoyaltyAnalysisLoyaltyProgramCorporateOfficeRoleDataConceptOfficeRoleDataStoreLevelStaffData HRPolicyData UtilityDataUtilitiesFormatDataOperatingExpenseDataModule8ReportResponsegroup_idreturnc ddlm}gd}|D]3}|j||d|i}|j}|dkDs3yy#t$rYywxYw)z$Check if group_id exists in databaser)text)z9SELECT COUNT(*) FROM tbl_brand WHERE group_id = :group_idz;SELECT COUNT(*) FROM tbl_segment WHERE group_id = :group_idzBSELECT COUNT(*) FROM tbl_sales_estimate WHERE group_id = :group_idrXTF) sqlalchemyr[executescalar Exception)rXdbr[tables_to_checkqueryresultcounts E/var/www/html/retail-simulation-api/app/api/module_reports/service.pyvalidate_group_idrf1sb#  %EZZU j(-CDFMMOEqy %  s>AAA AAceZdZdefdZdedefdZdedee fdZ dede e e ffdZ dededefd Zdedefd Zdedefd Zdedefd Zdedefd Zy)Module1ReportServicer`c||_yNr`selfr`s re__init__zModule1ReportService.__init__I rXrYc"|jjtjtj|k(j }|s t ddSt |jxsd|j|jxsdS)z#Get brand information for the groupNot Set Not provided) brand_name rationale)rt brand_logoru) r`rbrfilterrXfirstr2rt brand_imageru)rmrXbrands reget_brand_dataz#Module1ReportService.get_brand_dataLss h'..x/@/@H/LMSSU"i>R R''49((oo7  rpc |jjtjtj|k(j }g}|D]t}|j t|j|j|j|j|j|j|j|jv|S)z#Get consumer segments for the group)name isec_segmentchief_wage_earner_occupationhighest_educated_malehighest_educated_femalelocationtotal_population other_details)r`rbrrwrXallappendr7r} ISEC_Segmentrrrrrr)rmrXsegments segment_datasegments reget_segments_dataz&Module1ReportService.get_segments_dataXs77==,33J4G4G84STXXZ G    1\\$11-4-Q-Q&-&C&C(/(G(G ))!(!9!9%33 !  rpc |jjtjtj|k(j }d}d}|D]}t |j|j|j|j|j|j|j|j}|jdk(r|}x|jdk(s|}|st dddddd}|st dddddd}||fS)z&Get store format data for both formatsN) store_name store_size merchandiseradditional_location_parametersservice_parameterstechnology_adoptionother_parametersStore Format AStore Format Brr)rrrrrr)r`rbrrwrXrr8rrrrrrrrstore_format_type)rmrX store_formatsformat_aformat_b store_formatdatas reget_store_formats_dataz+Module1ReportService.get_store_formats_dataks n5<<^=T=TX`=`aeeg )L )'22'22(44%../;/Z/Z#/#B#B$0$D$D!-!>!> D--1AA//3CC+*0,$)##,)H ,$)##,)H !!rprc t}|jjtj tj |k(tj |k(j}td|D|_ |jjtj tj |k(tj |k(j}td|D|_ |jjtj tj |k(tj |k(j}td|D|_ |jjtj tj |k(tj |k(j}td|D|_ |jjt j t j |k(t j |k(j}td|D|_ |jjt$j t$j |k(t$j&|j)ddk(j} td | D|_ |jjt,j t,j |k(t,j |k(j} td | D|_ |jjt0j t0j |k(j} td | Dd z |_ |jjt4j t4j |k(j} td | Dd z |_|j|jz|jz|jz|j"z|j*z|j.z|j2z|j6z|j8z|_|S#d|_YxYw#d|_YqxYw#d|_YxYw#d|_YxYw#d|_Y8xYw#d|_YxYw)z6Calculate capital expenses for a specific store formatc3K|]7}|js|js|j|jz9ywrj) rate_per_sqft total_sqft.0items re zBModule1ReportService.calculate_capital_expenses..s?"JS^4bfbtbty}zIzI$"4"4t"FS^ ? ??c3K|]7}|js|js|j|jz9ywrjnumber_of_units cost_per_unitrs rerzBModule1ReportService.calculate_capital_expenses..sN-acp[_txuIuINRN`N`T-A-ADDVDV-Vcprc3K|]7}|js|js|j|jz9ywrjrrs rerzBModule1ReportService.calculate_capital_expenses..sN+aapY]txuIuINRN`N`4+?+?$BTBT+Taprc3bK|]'}t|ddxsdt|ddxsdz)yw)havs_rate_unitr rate_unitNgetattrrs rerzBModule1ReportService.calculate_capital_expenses..sK.]L\DHwt=Mq/Q/VUV[bcgitvw[x[}|}.~L\s-/rc3>K|]}t|ddxsdywtotalrNrrs rerzBModule1ReportService.calculate_capital_expenses..s%/k[jSWgq0I0NQ0N[jFormatFormatec3>K|]}t|ddxsdywrrrs rerzBModule1ReportService.calculate_capital_expenses..s%1k]jUY'$2K2Pq2P]jrc3>K|]}t|ddxsdywrrrs rerzBModule1ReportService.calculate_capital_expenses..s%1f]eUY'$2K2Pq2P]erc3>K|]}t|ddxsdywrrrs rerzBModule1ReportService.calculate_capital_expenses..s%/d[cSWgq0I0NQ0N[crc3>K|]}t|ddxsdywrrrs rerzBModule1ReportService.calculate_capital_expenses..s"#^~tGD'1$=$B$B~r)r9r`rbrrwrXrrsum civil_workrracking_display_unitsrcarpentry_furniturerelectrical_cablingrcommercial_equipmentrstore_formate_typereplacesignage_display_boardsr information_technologyr!visual_merchandisingr"plumbingothersr) rmrXrexpenses civil_items racking_itemscarpentry_itemselectrical_itemsequipment_items display_itemsit_itemsvm_itemsplumbing_itemss recalculate_capital_expensesz/Module1ReportService.calculate_capital_expensess+-ggmmH-44    )  & &*; ;  #% ""JS^"JJ &;<CC ! * *h 6 ! 3 37H H  #% *--acp-a*a&''-- 5<<  ! !X -  * *.? ?  #% (++aap+a(a$ .#ww}}-ABII$--9$66:KK ce +..]L\.]+]H '  0"ggmm,BCJJ&//8;&88>$$0ce !$#^~#^ ^ab bH    ("@"@ @  ( ( )+3+F+F G  ) ) *,4,K,K L  + + ,/7.K.K L     !)  0 y .*-H ' 0,/H ) 2.1H + 2.1H + 0,/H ) $ #H sN.A6R1%A6SBS#A6SA'S-A'S<1 R= S  S S*- S9< Tc |jjtjtj|k(j }|s t ddSt t|ddt|ddt|ddS) zGet depreciation informationzStraight Line Method )depreciation_methoddepreciation_yearsrr other_methodsN)rrr)r`rbr#rwrXrxr:r)rmrX depreciations reget_depreciation_dataz*Module1ReportService.get_depreciation_datasww}}_5<<_=U=UYa=abhhj )$:#%  & ' 6KMc d&|5I2N!,F  rpc Pddlm}t||js|dd|d|j |}|j |}|j |\}}|j|d}|j|d}|j|} t||||||| S) z!Generate complete Module 1 reportr HTTPException Group ID  not found in database status_codedetailrr) brand_detailsconsumer_segmentsstore_format_astore_format_bcapital_expenses_format_acapital_expenses_format_br) fastapirrfr`r{rrrrr;) rmrXr brand_data segments_datarrcapital_expenses_acapital_expenses_bdepreciation_datas regenerate_module1_reportz,Module1ReportService.generate_module1_reports)!4773C)H:Mc8de e((2 ..x8 !88B(!<r5|jtd-|j4j>|d|jtd.|j4j@|d|jtd/|j4jB|d|j4jDr5|jtd0|j4jD|d|jtd d'|jtd1|jFj6d|d|jtd*|jFj8|d|jtd+|jFj:|d|jtd,|jFj<|d|jtd$|jFj0|d|jFj>r5|jtd-|jFj>|d|jtd.|jFj@|d|jtd/|jFjB|d|jFjDr5|jtd0|jFjD|d|jtd d |jtd2| |jtd d|jtd3|d|jH} td4|dtd5| jJd6|dgtd7|dtd5| jLd6|dgtd8|dtd5| jNd6|dgtd9|dtd5| jPd6|dgtd:|dtd5| jRd6|dgtd;|dtd5| jTd6|dgtd<|dtd5| jVd6|dgtd=|dtd5| jXd6|dgtd>|dtd5| jZd6|dgtd?|dtd5| j\d6|dgtd@|dtdA| j^d6d|dgg } ta| dBtbzdCtbzgD}|jetgdEdFdGdHdIthjjfdJdKdIdLthjlfdMdNdOdPdQg |j||jtd d'|jtdR|d|jn}td4|dtd5|jJd6|dgtd7|dtd5|jLd6|dgtd8|dtd5|jNd6|dgtd9|dtd5|jPd6|dgtd:|dtd5|jRd6|dgtd;|dtd5|jTd6|dgtd<|dtd5|jVd6|dgtd=|dtd5|jXd6|dgtd>|dtd5|jZd6|dgtd?|dtd5|j\d6|dgtdS|dtdA|j^d6d|dgg }ta|dBtbzdCtbzgD}|jetgdEdFdGdHdIthjjfdJdKdIdLthjlfdMdNdOdPdQg |j||jtd d |jtdT| |jtd dtdT|dt|jpjr|dgtdU|dttu|jpjv|dgg}ta|dBtbzdCtbzgD}|jetgdEdFdJdKdIdLthjlfdMdNdOdPdQg|j||jy||j{d|S)Vz4Generate PDF report for Module 1 in specified formatrrrrrr2pagesize leftMargin rightMargin topMargin bottomMargin CustomTitleHeading1r0Helvetica-Bold)parentfontSize spaceAfter alignmentfontNamez5Module 1: All about your Brand, Customers and Stores! SectionHeaderHeading2r)rrrrzBranding & Store DetailszName of the Store: NormalzLogo of the store: zRationale: rsz#Consumer Segments & Catchment Sizesz Segment : zzISEC Segmentation: u+• Chief Wage Earner's Occupation: u9• Education of the highest educated male adult: u;• Education of the highest educated female adult: u• Location: u• Catchment Size: Not specifiedzStore Format DetailszStore Format A: u$• Store Size (in sq. ft.): u• Merchandise: u• Pricing Strategy: u+• Additional Location Parameters: u• Service Parameters: u • Technology Adoption: u• Other Parameters: zStore Format B: zCapital ExpenseszStore Format Az Civil WorkRs. ,.2fzRacking and Display UnitszCarpentry and FurniturezElectrical and CablingzCommercial EquipmentzSignage and Display BoardszInformation TechnologyzVisual MerchandisingPlumbingOthersz TotalzRs. r colWidthsALIGNrrrLEFTVALIGNrrTOP BACKGROUNDrrrGRIDr?WORDWRAPrrT LEFTPADDINGrr RIGHTPADDINGrrr" TOPPADDINGrrr" BOTTOMPADDINGrrr"zStore Format BzTotal InvestmentszDepreciation MethodzDepreciation Years (in Years))>rrrfr`rrr r rrrr rrrtrvru enumeraterr}r~rrrrrrrrrpricing_strategyrrrrrrrrrrrrrrrrrrrsetStylerr lightgreyblackrrrstrrbuildseek)rmrXr report_databufferdocstylesstory title_style section_styleircapex_a capex_a_data capex_a_tablecapex_b capex_b_data capex_b_tablerdepreciation_tables regenerate_pdf_reportz(Module1ReportService.generate_pdf_report&s~)!4773C)H:Mc8de e228< PR^`oqr$&% *%%    YVXcde VAr]#' *%%    Y9=IJ VAr]#  Y!;K{?Y?Y?j?j>klntu}n~ A Y!6{7Q7Q7Z7Z6[\^dem^nop  % % D D LL%PQ\QkQkRKRKQL$MOUV^O_` a Y!@A[A[AnAn@oprxzBsCD E Y!A+B\B\BpBpAqrtz|DuEF G  % % 6 6 LL%B;C]C]CnCnBo#prxzBsCD E VAr]#  Y!4[5O5O5Z5Z4[[_`bhiqbrst Y!EkF`F`FkFkElmouv~oA B Y!9+:T:T:`:`9abdjksdtuv Y!>{?Y?Y?j?j>klntu}n~ A Y!6{7Q7Q7Z7Z6[\^dem^nop  % % D D LL%PQ\QkQkRKRKQL$MOUV^O_` a Y!@A[A[AnAn@oprxzBsCD E Y!A+B\B\BpBpAqrtz|DuEF G  % % 6 6 LL%B;C]C]CnCnBo#prxzBsCD E VAr]#  Y1=AB VAr]#  Y6x8HIJ77 |VH%5 6 DI[I[\`HaBbdjksdt8u v 2F84D EySWX_XuXuvzW{Q|EFNOHP Q 0&2B CYQUV]VqVqrvUwOx{ABJ{KFL M /1A BIPTU\UoUoptTuNvx~@HyIEJ K -vh/? @)dSZSoSoptRuLvx~@HyICJ K 3VH5E F TXY`YwYwx|X}R~AGHPAQIR S /1A BIPTU\UsUstxTyNz}CDL}MEN O -vh/? @)dSZSoSoptRuLvx~@HyICJ K z6(#3 4i$wGWGWX\F]@^`fgo`p6q r x!1 2IW^^TXDY>Z\bck\l4m n ~vh'7 8)ggmm\`MaaeDfhnowhx:y z  lqvqv6FG z / / 7Hf.>.> ? VXsFLL 9 0 0 1 / 2 +   ]# VAr]#  Y6x8HIJ77 |VH%5 6 DI[I[\`HaBbdjksdt8u v 2F84D EySWX_XuXuvzW{Q|EFNOHP Q 0&2B CYQUV]VqVqrvUwOx{ABJ{KFL M /1A BIPTU\UoUoptTuNvx~@HyIEJ K -vh/? @)dSZSoSoptRuLvx~@HyICJ K 3VH5E F TXY`YwYwx|X}R~AGHPAQIR S /1A BIPTU\UsUstxTyNz}CDL}MEN O -vh/? @)dSZSoSoptRuLvx~@HyICJ K z6(#3 4i$wGWGWX\F]@^`fgo`p6q r x!1 2IW^^TXDY>Z\bck\l4m n 16(3C DiRYZaZgZghlYmmqPrtz|DuEGF G  lqvqv6FG z / / 7Hf.>.> ? VXsFLL 9 0 0 1 / 2 +   ]# VAr]#  Y4mDE VAr]#,fX.> ?;KcKcKwKwyAIzJBK L 6x8H I9UXYdYqYqZEZEVFHNOWHXLY Z  ##444@PQ##J / / VXsFLL 9 0 0 1 / 2 0 %   '( % A rpc ddlm}t||js|dd|d d}|j |}|j |}|j |\}}|j|d}|j|d } |j|} td |jd |jtd ||jd t|dkDr|dnd} t|dkDr|dnd} g} | jd| jd| jd| jd| jd| jd| jd| jd| jd| jd| jd| jd| jd| jd| jd| jd| jd | jd!| jd"| jd#| jd$| jd%| jd&| jd'| jd(| jd)| jd*d+j| }|S#t$r}td,t|d}~wwxYw)-zModule1ReportService.generate_html_report..clean_valuess;!H %~!/F ) 1 1&" =I0&OO- > *C!#Y'>(19=v=sA AArrzDEBUG civil_work: 'z' hex: zDEBUG cleaned: ''Nr0zzzzz)Reporting Processes Reportzzz!

Reporting Processes

z?

The following report will be generated from this module.
z@Module 1: All about your Brand, Customers and Stores!

z

Capital Expenses

z

Store Format A

zFz)z8z6z5z3z9z5z3z'z%z+z
Civil Work0.00
Racking and Display Units0.00
Carpentry and Furniture0.00
Electrical and Cabling0.00
Commercial Equipment0.00
Signage and Display Boards0.00
Information Technology0.00
Visual Merchandising0.00
Plumbing0.00
Others0.00
Total0.00
zz zError generating HTML report: )rrrfr`r{rrrrprintrlenrjoinr_r.)rmrXrrTrrrrrrrsegment1segment2 html_parts html_contentes regenerate_html_reportz)Module1ReportService.generate_html_reports)!4773C)H:Mc8de eF G >&,,X6J 228 ?   < =   f g   I J   X Y   V W   U V   S T   Y Z   U V   S T   G H   E F   K L   j )   i (   i (99Z0L  GC!#G]C@GC%gPcTc ' D D W%,%B%B%Uo-:0E,= !   $rpc|jjtjtj|k(j }g}|D]u}|j tt|j|jxsd|jxsd|jxsdt|ddt|ddw|S)zGet catchment potential datarr assumptionsNsources)r~number_of_householdspercentage_of_segmentpotential_householdsrwrx)r`rbr$rwrXrrr=r.rryrzpotential_number_of_householdsr)rmrXcatchment_datapotential_datars reget_catchment_potential_dataz1Module2ReportService.get_catchment_potential_dataMs'<=DDEZEcEcgoEopttv"D  ! !"8 !2!23%)%>%>%C!&*&@&@&GC%)%H%H%MA#D->i6 # #rpc|jjtjtj|k(j }|r |j SdS)zGet estimated market sharer)r`rbr*rwrXrxmarket_share_estimate)rmrX market_shares reget_market_share_dataz*Module2ReportService.get_market_share_data^sIww}}%<=DDE\EeEeiqEqrxxz 5A|11JsJrpc|jjtjtj|k(j }|r |j SdS)zGet competition intensityrr)r`rbr%rwrXrxtotal_square_footage)rmrX competitions reget_competition_intensityz.Module2ReportService.get_competition_intensitycsIggmm$:;BBCYCbCbfnCnouuw 3>{//MIMrpc|jjtjtj|k(j }|r |j SdS)zGet spillage factorrr)r`rbr)rwrXrxestimated_spillage_factor)rmrXspillages reget_spillage_factorz(Module2ReportService.get_spillage_factorhsI77==!:;BBC\CeCeiqCqrxxz5=x11L9Lrpc |jjtjtj|k(j }g}|D]l}|j t|jxsd|jxsd|jxsdt|jxsd|jn|S)z Get competitor benchmarking datarr)reference_competitornumber_of_bills_per_monthnumber_of_items_per_billaverage_price_per_item other_remarks)r`rbr+rwrXrrr>rbills_per_monthitems_pre_billrN avg_price other_remark)rmrX competitorsbenchmark_data competitors re get_competitor_benchmarking_dataz5Module2ReportService.get_competitor_benchmarking_datamsggmm$=>EEF_FhFhltFtuyy{ %J  ! !"9%/%D%D%W*4*D*D*I)3)B)B)Ga',Z-A-A-FQ'G(55 # &rprc |jjtjtj|k(tj |k(j }|stdddddddS|jxsd}tt|jxsd|jxsdd|vd|vd |vt|jxr|jjd t|d dxsd|j S) z.Get location details for specific store formatrrF)trading_radius adjacenciescorner_property high_streetmall parking_spaceconversion_factorrKrzCorner Property HighstreetMallrr)rrrrrrradditional_details)r`rbr&rwrXrrxr?location_characteristicsrNrrbooldetailsgetr)rmrXrrcharacteristicss reget_location_details_dataz.Module2ReportService.get_location_details_data}s77==!34;;  ' '8 3  0 0L @  %'  *"+ %!#"% #;;Ar& !8!8!=A> ,,?-@$7?*x//YH4D4D4H4H4YZ%h0CSIPS'//  rpc |jjtjtj|k(tj |k(j }d}d}d}d}d}|D]} | jdk(rt| jxsd}nh| jdk(r| jxsd}nH| jdk(r| jxsd}n(| jdk(rt| jxsd}| js|| jd| jd z }||z|z} | d z} t||||| | |r|jd  Sd S) z1Get sales estimate data for specific store formatrrrKzGross Margin % EstimatezNumber of Bills per MonthzNumber of Items per Billz"Average Price per item (in Rupees)rz; 333333?N)cogs_percentagerrr sales_valuesales_potentialremarks) r`rbr'rwrXrr parameterrNvalueremarkr@rM) rmrXr sales_datarritems_per_billavg_price_per_itemrrrrs reget_sales_estimate_dataz,Module2ReportService.get_sales_estimate_datasdWW]]#34;;  % % 1  / /< ?  #%   D~~!::"' a"8#>>"&**/#==!%q#GG%*4::?%;"{{dnn-R }B??&69KK &+ +&5%3#5#++2GMM$'  9=  rpc |jjtjtj|k(tj |k(j }|stddddStt|jxsdt|jxsd|jxsdt|jxsd|jS)z/Get rent expense data for specific store formatrr)store_size_sqftrental_advance_amountrental_advance_periodrent_per_month)rrrrru)r`rbr(rwrXrrxrArNrrrrrational_for_rental_expenses)rmrXr rent_datas reget_rent_expense_dataz*Module2ReportService.get_rent_expense_datasGGMM/299  $ $ 0  - - =  %'  " #&)&'"  !)"6"6";!<"' (G(G(L1"M"+"A"A"FQ !9!9!>Q?<<   rpczddlm}t||js|dd|d|j |}|j |}|j |}|j|}|j|}|j|}|j|d} |j|d} |j|d} |j|d} |j|d} |j|d}t|Dcgc]}|jc}}t|||||||| | | | | | Scc}w) z3Generate complete Module 2 Location Analysis reportrrrrrrrr) customer_segmentsrqcatchment_potentialestimated_market_sharecompetition_intensityspillage_factorcompetitor_benchmarkinglocation_details_format_alocation_details_format_bsales_estimate_format_asales_estimate_format_brent_details_format_arent_details_format_b)rrrfr`rurrrrrrrrrrqrB)rmrXrrrrrrrlocation_details_alocation_details_bsales_estimate_asales_estimate_brent_details_arent_details_bsegrqs regenerate_module2_reportz,Module2ReportService.generate_module2_reportsg)!4773C)H:Mc8de e!;;HE"??I11(; $ > >x H228<"&"G"G"Q!;;HFVW!;;HFVW77BRS77BRS33H>NO33H>NO'*Vg*hVgs3+J+JVg*h&i#$/(C 3#/"7+$;&8&8$4$4"0"0  +isD8cddlm}t||js|dd|d|j |}d}|j D]1}|d|j d |jd d |jd d z }3|d|jd dz }d}d}d|d|d|jjd|d|jjd|jjdd|jjdd|d|d}|S)z0Generate HTML report using exact format providedrrrrrrrK  .1f% , z> Estimated Market Share z"% rru Location Analysis Report
Module 2: Location Analysis

Understanding Shoppers
  • • Shopping Frequency per Month
  • • Household Consumption per Month
  • • Total Household Consumption per Month

Catchment Potential uf
ISEC Category Percentage of Segment Number of Potential Households

Competition Intensity
  • • Total Square foot of the competition

Quality of Location
  • • Spillage Factor

Location Definition
Store Format A: uE
  • • Trading Radius u
  • • Adjacencies
  • • Corner Property
  • • Highstreet
  • • Mall
  • • Parking Space
Store Format B: u
  • • Adjacencies
  • • Corner Property
  • • Highstreet
  • • Mall
  • • Parking Space

    • Estimated Sales:
    Estimated Sales Store A Store B
    ₹ r u ₹ zi

    Rent Details
    Store Format A: u
    • • Rental Advance Amount (in Rupees)
    • • Rental Advance Period (in Months)
    • • Rent per Month (in Rupees)
    Store Format B: u
    • • Rental Advance Amount (in Rupees)
    • • Rental Advance Period (in Months)
    • • Rent per Month (in Rupees)
    )rrrfr`rrr~rzr{rrrrrrr) rmrXrr1catchment_rowscp format_a_name format_b_namer]s rer_z)Module2ReportService.generate_html_report s)!4773C)H:Mc8de e228< 11B # __   % %c *+  $ $Q '(   N2   / / 45   ) ( $ H  ,&'<|d |jtd4|d |jtd<|d |jtd=|d |jtd>|d |j;||j=d|S)?z@Generate PDF report using ReportLab with proper table formattingrrrrrrrrz"Module 2: Location Analysisrr0 zUnderstanding Shoppersu • Shopping Frequency per Monthu#• Household Consumption per Monthu)• Total Household Consumption per MonthzCatchment Potentialz ISEC CategoryzPercentage of SegmentzNumber of Potential Householdsr%rzEstimated Market SharerKr@rrFONTNAMErrrrrrrrrr r#r%r'zCompetition Intensityu(• Total Square foot of the competitionzQuality of Locationu• Spillage FactorzLocation Definitionz%Store Format A: Store Format Au• Trading Radius: u• Adjacenciesu• Corner Propertyu• Highstreetu• Mallu• Parking Spacez%Store Format B: Store Format BzEstimated Sales:zEstimated SaleszStore AzStore Br r zRent Detailsu%• Rental Advance Amount (in Rupees)u%• Rental Advance Period (in Months)u• Rent per Month (in Rupees))rrrfr`rrr r rrr rrr~rzr{rrrr+rrr-rrrrrrr/r0) rmrXrr1r2r3r4r5r}rcatchment_tabler sales_tables rer@z(Module2ReportService.generate_pdf_reports-)!4773C)H:Mc8de e228< PR^`oqr$&  YCVHEUVW VAr]#  Y>x@PQR YA6(CSTU YDfXFVWX YJFS[L\]^ VAr]#  Y;VH=MNO$_fX6FGSjlrs{l|I}@IJjlrs{l|@}~11B  ! !9R__fX>N#OQZ^`^v^vwz]{{|[}@FGO@PRQS\`b`w`wxy_z}CDL}MSN#O P2y)A6(CSTV_cndFdFGJcKKLaMOUV^O_W`bklnpvwp@bAB C1T61T63t8:TU   / ; VXq&,, 7 / 0 0 1 / 2 - "   _% VAr]#  Y=vh?OPQ YI6RZK[\] VAr]#  Y;VH=MNO Y4fX6FGH VAr]#  Y;VH=MNO YFxHXYZ Y!5k6[6[6j6j5klntu}n~ A Y0&2BCD Y4fX6FGH Y/1ABC Yz6(+;<= Y2F84DEF YFxHXYZ Y!5k6[6[6j6j5klntu}n~ A Y0&2BCD Y4fX6FGH Y/1ABC Yz6(+;<= Y2F84DEF VAr]#  Y8&:JKL (&*: ;YyRXYaRb=cenox{ABJ{KfL M r6(+ ,i${?b?b?n?nos>t8uw}GxH/IKTW[\g\\\K\KLP[QURTZ[cTdKe f J1T61T61T62JK Z / ; VXq&,, 7 / 0 0 1 / 2 )    [! VAr]#  Y4fX6FGH YFxHXYZ YFxHXYZ YFxHXYZ Y?AQRS YFxHXYZ YFxHXYZ YFxHXYZ Y?AQRS % A rpN)r`rarbrrnrcrr<rur=rrNrr.rrr>rr?rr@rrArrBrr_rr@rerprergrg/s/734@W;X2STBX=Y"KcKeK N#N#N MCMCM F]A^  # S Md @+ + 3+ K\+ Z c   .* * 8M* XTSTSTlqCqGqrprgc<eZdZdZdefdZdeddfdZdedefdZ y ) Module3ReportServicez?Service class for generating Module 3: Network Planning reportsr`c||_yrjrkrls rernzModule3ReportService.__init__rorprXrYr3cddlm}t||js|dd|dddlm}m}m}m}m }m }d d d d d ddddd ddddd ddddd ddddd g} | dd|dzz} g} | D]5} | j|| d | d!|d"zz| d#|d$zz| d%&7t| d'z|z} d(|d)zz}d|d*zz}d+|d,zz}d-|d.zz}d-|d/zz}d0|d1zz}d2|d3zz}d4|d,zz}|||||||z||z||||d5|d6zzd7|d8zz||z|z|zd$z|d6zz||z|z|zd9z|d8zz:}|| gd;|dz| g|dd>d5|d6zzd7|d8zz?|@S)Az.Generate Module 3 Network Planning report datarrrrrrr0)r3LocationSelectionDataNetworkPlanningDataTradingMonthsDataPreOperatingExpenseDataStoreInvestmentSummaryDataChennaigz@i%&z2Major metropolitan city with high retail potential)r}area populationru Coimbatoregn@iOz)Industrial hub with growing consumer baseMaduraig`b@i@Bz&Cultural center with stable populationTiruchirappalligd@iP z'Educational hub with young demographicsSalemg_@iq z,Emerging retail market with growth potentialNrr}rrriPru) location_name area_sqkmhousehold_populationruri`順i8i@ i NiIi:i'i(i@iiaiHYgj@ig@ii@)!capital_expenses_excl_it_format_a!capital_expenses_excl_it_format_bit_capital_expenses_format_ait_capital_expenses_format_b%total_store_capital_expenses_format_a%total_store_capital_expenses_format_brental_advance_format_arental_advance_format_bpre_operating_expenses_format_apre_operating_expenses_format_bmarketing_expenses_format_amarketing_expenses_format_b total_store_investments_format_a total_store_investments_format_b)UrbanSuburbanRuralr)store_format_a_monthsstore_format_b_months@)rrrr) target_storesgeography_selectionlocation_selectionsnetwork_planningtrading_monthspre_operating_expensesstore_investment_summary) rrrfr`schemasr3rrrrrrrX)rmrXrr3rrrrr locationsselected_locationsrlocr base_capex_a base_capex_b base_it_a base_it_b base_rental_a base_rental_b base_preop_a base_preop_brs regenerate_module3_reportz,Module3ReportService.generate_module3_reports)!4773C)H:Mc8de e  WTH I!5WB CWS{ |&V[D Ee6P~   '':X\(:; %C  & &'<!&kf+B7%(%6(U:J%Kk* ( &/014x? (V"34 (U"23 h./ h./ (U"23 (T/2 E!12 E!12 #=.:.:)2)22>2J2>2J$1$1,8,8(/8d?(C(/8d?(C-9I-E -UXd-dgl-lpx{p.A-9I-E -UXd-dgl-lpx{p.A$  "%' >x!| L 3,2]_`#:&),3x$,G,3x$,G$ &>  rpc ddlm}t||js|dd|d|j |}t }t |tdddd}t}g}|jtd |d |jtd d |jtd |d|jtd dgdg}|jD]}} |jt| j|dt| jdd|dt| jd|dt| j xsd|dgt#|dt$zdt$zdt$zdt$zg} | j't)dddddd t*j,fdd d!d"d#d$d%g |j| |jtd d |jtd&|dd't/|j0j2gd(t/|j0j4gg} t#| d)t$zd*t$zg} | j't)dd+dddd t*j,fdd,g|j| |jtd d |jtd-|d|jtd dgd.d/d0|j6j8d1d0|j6j:d1d2gd3d0|j6j<d1d0|j6j>d1d2gd4d0|j6j@d1d0|j6jBd1d5gd6d0|j6jDd1d0|j6jFd1d7gd8d0|j6jHd1d0|j6jJd1d9gg} t#| d*t$zd:t$zd:t$zdt$zg}|j't)ddd;ddt*jLfdddd t*j,fdd?g|j||jO||jQd|S)@z Generate PDF report for Module 3rrrrrrrrz!Module 3: Network Planningrr0r zLocation Selectionr)LocationArea Population Rationalerrz sq kmrzStrategic location?皙?皙 @rrrrrrrFONTSIZErrr&rr!rrr$rrr1r&rrr1r(rrr1zTrading MonthszStore Format A Trading MonthszStore Format B Trading Months@rrrrrr/rrrzStore Investment Summary)zInvestment ComponentzFormat AzFormat BSourcezCapital Expenses (Excl. IT)rC,.0fzModule 1zIT Capital ExpenseszRental AdvancezModule 2zPre-operating ExpenseszModule 3zTotal Store InvestmentsTotal?rrrrrrrr/rr ))rrrfr`r$rr r rrr rrrrrrurrr+rrr-r.rrrrrrrrrrrrr r r,r/r0)rmrXrr1r2r3r4r5 location_datarlocation_table trading_data trading_tableinvestment_datainvestment_tables rer@z(Module3ReportService.generate_pdf_reportis)!4773C)H:Mc8de e228< PR^`oqr$&  YBF:DVWX VAr]#  Y:F:.> ? VXq&,, 7 / - . #   %& % A rpN) r`rarb__doc__rrnrcr$rr@rerprerrs?I7K K 8OK Z^C^G^rprceZdZdZdefdZdeddfdZdedefdZ dede fd Z dede fd Z dedefd Zdede fd Zdedefd Zdede fdZdeddfdZdede fdZy)Module4ReportServicezBService class for generating Module 4: Category Management reportsr`c||_yrjrkrls rernzModule4ReportService.__init__rorprXrYr4c ddlm}t||js|dd|dddlm}m}m}m}m }m } dd l m } |jj| j| j|k(j!} || r | j&nd | r | j(nd | r | j*nd| r| j,r | j,nd} ddlm} |jj| j| j|k(j!}||r|j2r |j2nd|r|j4r |j4nd} ddlm}|jj|j|j|k(j!}|d|r |j:ndd|r |j<nd} ddlm }|jj|j|j|k(jC}|r1|d dDcgc]"}||jDjFd d!d"#$c}n"|d$d d%d!#|d&d'd(d)#|d*d+d!d%#g} dd,l$m%}|jj|j|j|k(jC}g}d.}|ro|D]i}|d/|jL|jN|jP|jN|jPzd0z 1}|jS|||jTz }kn^d$d%d2d3d&d(d!d3d*d!d4d3d5d(d"d3g}|D]C}||d6|d7|d8|d7|d8zd0z 1}|jS|||jTz }E|| |||||9S#t"$r} t%d | d } Yd } ~ @) category_name category_rolesales_contributionmargin_contribution GroceriesgA@ Electronicsz Cash Machine4@gD@ClothingFlagship)TblGrossMarginContributionz!Error loading gross margin data: rz Category d)racontribution_to_sales gross_marginsgross_margin_contribution.@)r}salesmargingF@z Home & Gardenr}rprq)competitor_researchcustomer_researchcategory_levelscategory_rolesgross_margin_contributions#total_weighted_average_gross_margin)+rrrfr`rr4rJrKrLrMrN,app.models.main.competitor_category_analysesrOrbrwrXrxr_rWrrPrQrR-app.models.main.consumer_preferences_researchrSrTrU%app.models.main.pre_selected_caregoryrV medium_value high_valueapp.models.main.categoryr^rchoose_categoryr*app.models.main.gross_margin_contributionsrjgross_idcontribution_to_total_salescontribution_to_gross_marginrrn)rmrXrr4rJrKrLrMrNrOcompetitor_datar^rrrS customer_datarsrVpre_selected_datartr^ categoriescatrurjgross_margin_datarvtotal_weighted_margingm contributionsample_contributionsrs regenerate_module4_reportz,Module4ReportService.generate_module4_reports)!4773C)H:Mc8de e   # b"ggmm,IJQQ-66(Beg 5IX!E!E^qYh)U)UnpM\?#I#IcEKZ_n`E`E/"G"GK~   ! d GGMM*HIPP.778Ceg 1GTYfY{Y{!C!CBvANS`SrSrm==y{   % T $ .D E L L&//8;!eg ,!)HY&7&D&D_a!'FW&7&B&B]_    <{3::$$0ce $BQ  (# !1177+#'$(   (   )+#'$(   +,#'$(   ((#'$(    8 # ] $ .H I P P*33x?!ce &(" # ':$-bkk]";*,*H*H"$"A"A.0.L.LrOnOn.nqt.t   +11,?%)O)OO%(%ttD&F#ddC(44H $ -:"&v,*.w-"&x..27md8n.Ls.R   +11,?%)O)OO%-% 3/+)'A0E   q # 3A37 8"O #  ! 1!5 6 M ! % 5aS9 : $  %   .qc2 3J   B # 5aS9 : "  #sA N$A O "A O2A P*'Q8A Q$ O-OO O/O**O/2 P;PP P="P88P= Q)Q$$Q)cddlm}t||js|dd|d|j |}d}|j D]>}|d|j d |jd |jd d |jd d z }@d}|jD]?}|d|j d |jd d |jd d |jd d z }Ad|jjd|jj d|jj"d|jj$d|j&j(d|j&j*d|j,j.d|j,j0d|j,j2d|j,j4d|d|d|j6d d}|S)z!Generate HTML report for Module 4rrrrrrrKz& z rz% z%% rLa3 Module 4: Category Management
    Module 4: Category Management

    Primary Research
    Competition Research:
    Reference Competitor zS
    Number of Categories Stocked zM
    Key Categories Stocked z
    What are some key observations around stocking and categories in the store? a
    Customer Research:

    Define Research Methodology (Sample Size, Probes, and Methods) ac
    What are some key observations around shopping behaviors around category by customers? ae

    Category Management
    Level of Category or Merchandise Number of Categories Available
    Store Format A rzE
    Store Format B ab

    Category Role Management

    a^
    Category Name Category Role Sales Contribution Margin Contribution

    Gross Margin Contributions

    z
    Category Name Contribution to Sales Gross Margins Gross Margin Contribution
    Total Weighted Average Gross Margin z*%
    )rrrfr`rrurarbrcrdrvrlrmrnrrrrPrQrRrsrTrUrtrZr[r\r]rw) rmrXrr1category_role_rowsrolegross_margin_rowsrr]s rer_z)Module4ReportService.generate_html_reportcs)!4773C)H:Mc8de e228<  ..D '''()''(),,S12--c23 #  /88B &%%&'--c23%%c*+11#67 "  9 ( , , A A BC  , , I I JK  , , C C DE  , , B B C DxyDyVyVykykxllxyDyVyVyhyhxii  ( ( = = >?  ( ( B B CD  ( ( = = >?  ( ( B B C D       45@4c4cdg3hiw` Drpc  ddlm}t||js|dd|dddlm}ddlm}m}m }m }m }dd l m } dd lm} dd lm} dd lm} |j)|} | }|||d d d d }| }g}|j+|d|d|j+|dd|j+|d|d|j+|dd|j+|d|dd| j,j.gdt1| j,j2gd| j,j4gd| j,j6gg}||d| zd| zg}|j9|ddd d!d| j:fd"d#d$g|j+||j+|dd%|j+|dd&|j+|d'|dd(| j<j>gd)| j<j@gg}||d*| zd+| zg}|j9|ddd d!d| j:fd"d#d$g|j+||j+|dd%|j+|dd&|j+|d,|dgd-d.| jBjDt1| jBjFgd/| jBjHt1| jBjJgg}||d0| zd1| zd2| zg}|j9|dd3dd d!d| j:fd4d#d$g|j+||j+|dd%|j+|dd&|j+|d5|dgd6g}| jLD]G}|j+|jN|jP|jRd7d8|jTd7d8gI||d9| zd:| zd0| zd0| zg}|j9|dd3dd d!d| j:fd4d;g|j+||j+|dd%|j+|dd&|j+|d<|dgd=g}| jVD]K}|j+|jN|jXd7d8|jZd7d8|j\d>d8gM|j+d?d@d@| j^d>d8g||d9| zd:| zd:| zd9| zg}|j9|dd3dAdd d!d| j:fd4d#d$g|j+||ja||jcd|S)Bz#Generate PDF report using ReportLabrrrrrrr r rrrrrrz$Module 4: Category Managementrr0r zPrimary Researchrr&zCompetition Research:rReference CompetitorzNumber of Categories StockedzKey Categories Stockedz=Key observations around stocking and categories in the store?r5rrrrrrr.rrrzCustomer Research:z>Define Research Methodology (Sample Size, Probes, and Methods)zHKey observations around shopping behaviors around category by customers?rr1zCategory Management)rKz Level of Category or MerchandisezNumber of Categories Availablerrr;皙@gffffff@r)rrrMIDDLEz&Category Role Management) Category Namez Category RolezSales ContributionzMargin Contributionrr?rr=z(Gross Margin Contributions)rzContribution to Salesz Gross MarginszGross Margin ContributionrLz#Total Weighted Average Gross MarginrKr<)2rrrfr`reportlab.lib.pagesizesr reportlab.platypusr r rrrreportlab.lib.stylesrreportlab.lib.unitsr reportlab.libriorrrrrrr.rPrQrRr+r-rsrTrUrtrZr[r\r]rurarbrcrdrvrlrmrnrwr/r0)rmrXrr r r rrrrrrrr1r2r3r4r5 comp_data comp_table cust_data cust_tablecat_data cat_table role_datar role_table margin_datar margin_tables rer@z(Module4ReportService.generate_pdf_reports)!4773C)H:Mc8de e.^^<,(228< PR^`oqr$&  YEvjGYZ[ VAr]#  Y8&:LMN VAq\" Y=vh?OPQ$[%D%D%Y%Y Z +S1P1P1m1m-n o %{'F'F']'] ^ NP[PoPoQFQF G  9T3t80DE J / VXq&,, 7 / - 0 (     Z  VAr]#  VAr]# Y:F8Leading brand expertise can help optimize category performancez=Vendor management strategy focuses on quality and reliabilityzRStrategic partnerships with key vendors while maintaining competitive alternatives)vendor_priority_matrixvendor_scorecardprivate_labellingradditional_remarks key_takeaways)rrrfr`,app.models.main.vendor_metrics_priority_listrrbrwrXrrCrrrrrDrErFrG) rmrXrr vendor_datarrareasrrrrs regenerate_module5_reportz,Module4ReportService.generate_module5_reportqs)!4773C)H:Mc8de e&  a''--(DELL,55Ace #. * #.$ -!%!3!!YY3) $ ? $ <  #. '*J.6!muX\*6(S\A],!"! 8"5hZ @ *&, zTf\` a $S[cg h '?4\bjn o $SX`c d 'EQUbjrw x '73SX`u v '<Yail m {cf\_ `   !)#[  !-"  !/#J  & $)%)  $-%*Z  $/%)  $%#9-/!5^n   a*( EE*2a-5A&vhZy=YD(41(< & "sAG=AG  -G G,Hc ddlm}t||js|dd|d|j |}d}|j D]<}|d|j d |jd |jd |jd z }>d}|jD]<}|d|jd |jd |jd |jd z }>d}|jD]B}|j d k(r |j"nd}|d|j$d |j d |d z }Dd} |j&D]B}|j&d k(r |j"nd}| d|j$d |j&d |d z } Dd |d|d|d| d } | S)z!Generate HTML report for Module 5rrrrrrrKrrrrra{ Module 5: Vendor Management, Category Captainship, Private Labelling

    Reporting Processes

    The following report will be generated from this module.

    Module 5: Vendor Management, Category Captainship, Private Labelling
    a
    Vendor Management Priority Matrix
    Priority Area Metrics Remarks

    Vendor Management Scorecard

    a)
    Metric Weightage Importance Best Alternative To A Negotiated Agreement (BATNA)

    a3
    Private Labelling
    Category Name Private Label Rationale

    z
    Category Captainship
    Category Name Category Captainship Rationale
    )rrrfr`rrrrrrrrrrrrrrurar) rmrXrr1priority_matrix_rowsrscorecard_rowsprivate_label_rowsrucaptainship_rowsr]s regenerate_module5_html_reportz1Module4ReportService.generate_module5_html_reports5)!4773C)H:Mc8de e228<  "66D ) ]]O YYK \\N \\N %  700D # [[M ^^  __  ZZL   N1 11D*.*<*<*E2I '    !    ! K #  244D*.*C*Cu*LRTI %    !  & & '( K !  5" D   "          WO brpc Z ddlm}t||js|dd|dddlm}ddlm}m}m }m }m }dd l m } dd lm} dd lm} dd lm} |j)|} | }|||d d d d }| }g}|j+|d|d|j+|dd|j+|d|d|j+|ddgdg}| j,D]H}|j+t/|j0|j2|j4|j6gJ||d| zd| zd| zd| zg}|j9|ddddd d| j:fd!d"d#g|j+||j+|dd|j+|d$|d|j+|ddgd%g}| j<D]B}|j+|j>|j@d&|jB|jDgD||d'| zd(| zd(| zd)| zg}|j9|ddddd d| j:fd!d"d#g|j+||j+|dd|j+|d*|d|j+|ddgd+g}| jFD]G}|jHd,k(r |jJnd-}|j+|jL|jH|gI||d| zd.| zd/| zg}|j9|ddddd d| j:fd!d"d#g|j+||j+|dd|j+|d0|d|j+|ddgd1g}| jND]G}|jNd,k(r |jJnd-}|j+|jL|jN|gI||d2| zd| zd3| zg}|j9|ddddd d| j:fd!d4d#g|j+||jQ||jSd|S)5z0Generate PDF report for Module 5 using ReportLabrrrrrrr r rrrrrrzKModule 5: Vendor Management, Category Captainship, Private Labellingrr0r z(Vendor Management Priority Matrixrr&)Priorityr(MetricsRemarks333333?gffffff?rrrrrrrrrr.rz"Vendor Management Scorecard)Metric Weightage ImportanceBATNArr;r,g333333@zPrivate Labelling)rz Private Labelr*rrKr+r-zCategory Captainship)rzCategory Captainshipr*?gffffff @r/rr)*rrrfr`rr rr r rrrrrrrrrrrrrrr.rrrrr+r-rrrrrrrrurarr/r0)rmrXrr r r rrrrrrrr1r2r3r4r5 priority_datarpriority_tablescorecard_datascorecard_table private_dataru private_tablecaptainship_datacaptainship_tables regenerate_module5_pdf_reportz0Module4ReportService.generate_module5_pdf_reportcs)!4773C)H:Mc8de e.^^<,(228< PR^`oqr$&  YlntuoAB C VAr]#  YI6R\K]^_ VAq\"CD 66D  #dmm"4diit||!\ ]7}T3t8SQUXWZ[_W_8`a / ; VXq&,, 7 / - 0 , !    ^$ VAr]#  YCVJEWXY VAq\"HI00D  ! !4;;4>>2B!0DdooW[WaWa"b c1 3t8SXsSWxY\]aYa:bc   / ; VXq&,, 7 / - 0 - "    _% VAr]#  Y96*;MNO VAq\"GH 11D*.*<*<*E2I   !3!3T5G5G S T2ls4xT3t86TU z / ; VXq&,, 7 / - 0 +     ]# VAr]#  YPQR VAq\"RS44D*.*C*Cu*LRTI  # #T%7%79R9RT]$^ _5""2s4xTSVW[S[>\]"": / ; VXq&,, 7 / - 0 / $    &' % A rpcddlm}t||js|dd|d ddlm}|jj |j|j|k(j}|r|jxsd}ngd }||t|z}tt|d d d d tdddtdddgtdddtdddgt!ddddd t#d!dd"d#d$d%&t#d'dd(d)d*d+&gt%dd,d-d.d/d01t'd,d2d3d4d5d6d78d9d:; S#gd }||t|z}YxYw)N3N'O$ !8%9!L(E!b_  #!1%9m #!1%/c " (%9g  *%/` #?%1#Y)d!h[ # #(#2#=PL  $*#6#7>L $ 9%1$(%d!Y&j\  + $m"%ck ]S n}WL L  LZK#.x#k:J/J#K s A3EEcV ddlm}t||js|dd|dddlm}ddlm}m}m }m }m }dd l m } dd lm} dd lm} dd lm} |j)|} | }|||d d d d }| }g}|j+|d|d|j+|dd|j+|d|d|j+|ddd| j,j.gd|| j,j0|dgd|| j,j2|dgd|| j,j4|dgd|| j,j6|dgg}||d| zd| zg}|j9|dd d!d"d#d| j:fd$d%d&g|j+||j+|dd|j+|d'|d|j+|ddgd(g}| j<D]>}|j+|j>|j0||j@|dg@||d)| zd*| zd+| zgd,| zgtC|z-}|j9|dd.d!d"d#d| j:fd$d/d&d0d1d2d3g |j+||j+|dd|j+|d4|d|j+|ddgd5g}| jDD]>}|j+|jF|j0||j@|dg@||d)| zd*| zd+| zgd,| zgtC|z-}|j9|dd.d!d"d#d| j:fd$d/d&d0d1d2d3g |j+||j+|dd|j+|d6|d|j+|ddgd7g}| jHD]}}|j+|jJ|jF||jL|d||jN|d||jP|d||jR|dg||d8| zd9| zd:| zd:| zd)| zd;| zgd<| zgtC|z-}|j9|dd.d!d"d#d| j:fd$d=d&d>d?d@dAg |j+||j+|dd|j+|dB|d|j+|dddC| jTjVrdDndEgdF|| jTjX|dgdG| jTjZdHgdI|| jTj\|dgdJ|| jTj^|dgdK|| jTj`|dgg}||d;| zdL| zg}|j9|dd d!d"d#d| j:fd$d/d&g|j+||jc||jed|S)Mz0Generate PDF report for Module 6 using ReportLabrrrrrrr r rrrrrrz0Module 6: Pricing, Promotions and Loyaltyrr0r z.Competitor Analysis on Pricing Strategyrr&rPricing StrategyrzHighest Income CategoryzKey Observationsz Other Remarksr@rrr6rrrrr=rz'Pricing Strategy by Store Format)z Store Formatrr*rrg @g?)r rowHeightsrr.)r!rrr)r$rrr)r&rrr)r(rrrz%Category-wise Pricing Strategy)Categoryrr*zYearly Promotion List)MonthrzPromotion TypezSuccess Metric Objectiverrrr+r;g?rr0r2r3r4zLoyalty Program Detailsz Has Programrr DescriptionzBudget (% of sales)rBenefitszPotential PerilsDifferentiationg@)3rrrfr`rr rr r rrrrrrrrrrrrrrrr*rrrr+r-rrrurXrrrrrrrrrrrrrrrr/r0)rmrXrr r r rrrrrrrr1r2r3r4r5 pricing_data pricing_table format_datar format_table category_datacategory_tablepromotion_datapromotion_table loyalty_data loyalty_tables regenerate_module6_pdf_reportz0Module4ReportService.generate_module6_pdf_report<s>)!4773C)H:Mc8de e.^^<,(228< PR^`oqr$&  YQSYZdSefg VAr]#  YOQWXbQcde VAq\"$[%C%C%X%X Y ;+I+I+Z+Z\bck\l!m n & +2P2P2h2hjpqyjz({ | ;+I+I+Z+Z\bck\l!m n i (F(F(T(TV\]eVfg h  ls4xT6JK z / ; VXq&,, 7 / - 0 +     ]# VAr]#  YH&Q[J\]^ VAq\"HI 44D    1 143H3H)TXTbTbdjksdtJuv w5[SXs4xT4R`cdh`h_ijmnyjz_z{ j / ; VXq&,, 7 / - 0 0 1 / 2 *    \" VAr]#  YFzHZ[\ VAq\"FG 00D  $--1F1F RVR`R`bhiqbrHs!t u1}T3t8SQUX8VdghldlcmnqroAdAB / ; VXq&,, 7 / - 0 0 1 / 2 , !   ^$ VAr]#  Y=vj?QRS VAq\"mn11D  ! !4::t}}iH[H[]cdl]m>n!*4+>+>x@P!Q!*4>>6(;K!L!*4<<9I!J#L M2  3t8SXsSWxY\]aYacfgkckmpqumu:vEHIMEMDNORSaObDbc   / ; VXq&,, 7 / - 0 0 1 / 2 - "   _% VAr]#  Y? ASTU VAq\"[%@%@%L%LERV W Ik&A&A&U&UW]^fWgh i "{'B'B'T'T&UUV$W X ;#>#>#G#GPXIYZ [ ;+F+F+M+MvV^O_!` a  +*E*E*U*UW]^fWg h i  ls4xT6JK z / ; VXq&,, 7 / - 0 +     ]# % A rpr5cL ddlm}t||js|dd|dddlm}ddlm m}|Gd d |Gd d |Gd d |Gdd|Gdd |Gdd |Gdd |G fdd}|diddddddd d!d"d#dd$d"d%d&d'd d(dgd)d*d+dd,d-.dd/d0.d!d1d2.d#d3d4.gd5d6d7d8|d9zzd:d;d d?d@dAdBdCdDdEF dGdHdIdJdKdLdMF dNdOdPdQdRdSdTF dUdVdWdXdCdYdZF d[dOd\d]d^dSd_F d`dOdadbdcdSddFgdedfdgdhidj dkl dml dnlgdo dpl dql drlgdsdtdu dvw dxw dyw dzw d{wgd|d}d~dddS)z9Generate Module 7: Marketing & Communications report datarrrrrr) dataclass)rOptionalc"eZdZUeed<eed<y)DModule4ReportService.generate_module7_report..BrandAttributer}customer_ratingNr`rarbr.__annotations__rerpreBrandAttributers I rpr!c,eZdZUeed<eed<eed<y)JModule4ReportService.generate_module7_report..CompetitorComparison attributereference_retailer own_brandNrrerpreCompetitorComparisonr#sN # #Nrpr'cTeZdZUeed<eed<eed<eed<eed<eed<eed<y) GModule4ReportService.generate_module7_report..MarketingActivity activity_namebudget_allocatedrmeasurement_metrictarget_shopper_journeyestimated_budgetrNr`rarbr.r rNrerpreMarketingActivityr)s* # #N # #$' '# #Lrpr0c,eZdZUeed<eed<eed<y)HModule4ReportService.generate_module7_report..CompetitorAnalysisr%marketing_activity_briefrNrrerpreCompetitorAnalysisr2s # #&) ) rpr4ceZdZUeed<y)CModule4ReportService.generate_module7_report..SpaceResource descriptionNrrerpre SpaceResourcer6 rpr8ceZdZUeed<y)FModule4ReportService.generate_module7_report..NonSpaceResourcer7NrrerpreNonSpaceResourcer;r9rpr<ceZdZUeed<y)JModule4ReportService.generate_module7_report..ConsumerJourneyStagestageNrrerpreConsumerJourneyStager> sJrpr@ceZdZUeed<WWed<eed<WWed<eed<eed<eed<eed<WWed <Wed <WWed <WWed <eed <WWed<eed<eed<eed<y)CModule4ReportService.generate_module7_report..Module7ReportrTbrand_attributesrcompetitor_comparisonsbrand_positioning_statementmarketing_budget_percentagebudget_rationaletotal_marketing_budgetmarketing_activitiescompetitor_analysisspace_resourcesnon_space_resourcesincome_percentageconsumer_journey_predictionsstrategy_evolutionrrNr/)r!r4r'r@rr0r<r8sre Module7ReportrB s"% %">2 2 $()=$> >), ,). .! !$) )"&'8"9 9!3 3!-0 0!%&6!7 7$ $*./C*D D # # # # rprPrTzConducted primary research with 150 customers using structured interviews and surveys to understand brand perception and key attributes associated with retail stores in our category.rCzQuality ProductszHigh importance)r}rzCompetitive PricingzVery importantzStore Accessibility ImportantzCustomer ServicezProduct VarietyzStore AmbiancezModerate importancez Brand Trust ConveniencerzResearch revealed strong preference for value-for-money proposition combined with quality assurance and convenient shopping experience.rDzPremium positioningzQuality at affordable prices)r$r%r&zHigher price pointzValue-focused pricingzLimited locationszStrategic locationszStandard servicezPersonalized servicerEzWe position ourselves as the trusted neighborhood retailer offering quality products at competitive prices with exceptional customer service, making everyday shopping convenient and affordable for families.rFr5rrGzAllocated 4.5% of sales for marketing to establish strong brand presence, drive customer acquisition, and maintain competitive positioning in the market.rHg@wArIzDigital Marketing Campaignr`z(Brand awareness and customer acquisitionz"Reach, engagement, conversion ratezAwareness stageg@w@z1Focus on social media and search engine marketing)r*r+rr,r-r.rzIn-store Promotionsrgz"Drive sales and customer retentionzSales uplift, footfall increasezPurchase and retentiong@z.Seasonal offers and loyalty program promotionszPrint AdvertisingrozLocal market penetrationzBrand recall, store visitszAwareness and considerationgz@z(Local newspapers and community magazineszRadio SponsorshiprzBrand visibility and recallzBrand mentions, audience reach@z Local radio station partnershipszCommunity Eventsz Community engagement and loyaltyz!Event attendance, brand sentimentzEngagement and loyaltyz)Local festivals and community initiativeszInfluencer PartnershipszTargeted audience reachzEngagement rate, conversionszConsideration and trialz&Local lifestyle and family influencersrJrzComprehensive omnichannel approach with heavy emphasis on festival-based promotions, celebrity endorsements, and aggressive pricing campaigns across TV, digital, and print media.zOur approach focuses on community-centric marketing with personalized customer engagement, local partnerships, and sustainable practices rather than mass market celebrity-driven campaigns.)r%r3rrKzAATM installation generating rental income and increasing footfall)r7uQCafé corner providing additional revenue stream and extended customer dwell timezJProduct demonstration kiosks for brand partnerships and promotional incomerLzDCustomer data monetization through targeted advertising partnershipsz=Private label product development and licensing opportunitiesz9Loyalty program partnerships with other service providersrMr-rNz@Increased digital touchpoints integration with physical shopping)r?z)i *y+i ,$,-i 0"">%)H'K+<%-O""7%)B'H+C%,L""5%)8'C+H%,F""5%);'G+<%,>""4%)@'J+C%,G"";%)7'E+D%,D]7"/i ^!3#/*^!_!_i j*mn*}~*vwii t!-st -lm -hi!si |"}i @%+mn$+ij$+bc$+cd$+gh *i L fMi N uOi PQi i rpc jddlm}t||js|dd|dddlm}ddlm}m}m }m }m }m } dd l m} dd lm} dd lm} dd lm} |j+|}| }|||d d d d }| }g}|j-|d|d|j-|dd|j-|d|d|j-|dd|j-|d|d|j-||j.|d|j-|dd|j-|d|d|j-|ddddgg}|j0D])}|j-|j2|j4g+||d| zd| zg}|j7|d d!d"d#d$d| j8fd%d&g|j-||j-|dd|j-|d'|j:|d|j-|dd|j-|d(|d|j-|ddgd)g}|j<D]4}|j-|j>|j@|jBg6||d*| zd*| zd*| zg}|j7|d d!d"d#d$d| j8fd%d+g|j-||j-|dd|j-|d,|d|j-||jD|d|j-|dd|j-|d-|d|j-|dd|j-|d.|dd/|jFd0gd1d2|jHd3gd4||jJ|dgg}||d*| zd5| zg}|j7|d d6d"d#d$d| j8fd%d&g|j-||j-|dd|j-|d7|d|j-|ddgd8g}|jLD]}|j-||jN|d|jPd9||jR|d||jT|d||jV|dd2|jXd3g||d:| zd;| zd:| zd<| zd<| zd<| zg}|j7|d d!d"d#d$d| j8fd%d=d>g|j-||j-|dd|j-|d?|dd@|jZj@gdA||jZj\|dgdB||jZj^|dgg}||d*| zd5| zg}|j7|d d6d"d#d$d| j8fd%d&g|j-||j-| |j-|dC|d|j-|dd|j-|dD|dta|jbdD]/\} }!|j-|| dE|!jd|d1|j-|dd|j-|dF|dta|jfdD]/\} }!|j-|| dE|!jd|d1|j-|dd|j-|dG|jhd0|d|j-|dd|j-|dH|dta|jjdD]/\} }"|j-|| dE|"jl|d1|j-|dd|j-|dI|d|j-||jn|d|j-|dd|j-|dJ|d|j-|dddK||jp|dgdL||jr|dgg}#||#d*| zd5| zg}$|$j7|d d6d"d#d$d| j8fd%d&g|j-|$|ju||jwd|S)MzLGenerate PDF report for Module 7: Marketing & Communications using ReportLabrrrrrrr )r r rrr PageBreakrrrrrrz/Module 7: Marketing & Communicationsrr0r z$Section 1: Branding & USPrr&zResearch Methodology:Heading3rrzKey Brand Attributes: AttributezCustomer Ratingr5rrrrrrrr=zOther Remarks: z-Multi-Attribute Competitor Comparison:)r[Reference Retailerz Own Brandrr.z#Brand Positioning Statement:z Section 2: Marketing PlanzMarketing Budget:zBudget Percentagez % of saleszTotal Budget (Y1)r r9r*rr6z'Integrated Marketing Activities:)ActivityzBudget %r rz Journey Stageu Amount (₹)rrrr+rrz%Competitor Marketing Analysis:r\zMarketing Activity BriefzOur Differentiationz)Section 3: Brand Journey (Year 3+)z"Space Resource Utilization:. z&Non-Space Resource Utilization:z$Estimated Additional Income: z.Consumer Journey Evolution Predictions:z$Marketing Strategy Evolution:zSection 4: SummaryAdditional Remarks Key Takeaways) ?19T3t80DE J / ; VXq&,, 7 / - (     Z  VAr]# Y!7 8Q8Q7RSU[\dUefg VAr]#  YNPVWaPbcd VAq\"EF 66D   dnnd.E.Et~~V W79T3t8SX0NO J / ; VXq&,, 7 / - (     Z  VAr]#  YDfZFXYZ Y{FFxHXYZ VAr]#  YA6*CUVW VAq\"  Y96*;MNO [%L%L$MZ"X Y D)K)KD(Q"R S )K$@$@&BRS T [SXs4x4HI j / ; VXq&,, 7 / - *     \" VAr]#  YH&Q[J\]^ VAq\"ij #88H  (00&2BC,,-Q/(,,fX.>?(55vh7GH(996(;KLx0067 " 9}T3t8SQUXWZ[_W_adeiaiknosks8tu / ; VXq&,, 7 / - 0 , !    ^$ VAr]#  YFzHZ[\ !;#B#B#U#U V ';3R3R3k3kmst|m})~  "Ik.M.M.].]_efn_o$p q  $$63t8SQUXBVW$$Z / ; VXq&,, 7 / - 1 &    () Y[!  YJFS]L^_` VAq\"  YCVJEWXY$[%@%@!DKAx LLaS8+?+?*@#A6(CST UE VAr]#  YGPZI[\]$[%D%DaHKAx LLaS8+?+?*@#A6(CST UI VAr]# Y!EkFcFcEddnoqwyArBC D VAr]#  YOQWXbQcde!+"J"JANHAu LLaS5;;-#8&:JK LO VAr]#  YEvjGYZ[ Y{==vh?OPQ VAr]#  Y:F:ce "D!!x43E3E3K3K3M'MQZ^b^p^p^v^v^xQx&&'>"&"4"4$($8$8$?C!WW\!WW\!WW\!WW\!WW\(#hO+Hs?7K,KLM("/$,60A$B\AL1x<\AL OA 21#6 7N sA E F'E==Fc  |jjtjtj|k(j }g}|D]}|jsd|jjvsd|jjvsI|jt|j|jxsd|jxsd|jxsd|jxsd|j xsd|j"xsd|s$tdd d d d d dtddd d dddg}|S#t $r}td|g}Yd}~d}~wwxYw)zGet concept office roles datazError loading concept data: Nrunitrrrvr~rr0rrr1rZz Unit ManagergAr"r&r)r`rbr,rwrXrr_rWrwrrrQrxrrrrr)rmrX concept_datar^ concept_rolesrs reget_concept_office_dataz,Module8ReportService.get_concept_office_data sX 77==)BCJJ)22h>ce   D!!v1C1C1I1I1K'KvY]YkYkYqYqYsOs$$%:"&"4"4$($8$8$?C!WW\!WW\!WW\!WW\!WW\&!%"0$,QQ &"0$,QR MC  04 5L sA E E)E$$E)c  |jjtjtj|k(j }i}|D]y}|jxsd}||vr|jxsdddd||<|jdk(r|jxsd||d<T|jd k(sd|jxsd||d <{g}|jD],\}}|jt||d |d|d  .|s,td ddd tdddd tdddd g}|S#t $r}td|g}Yd}~d}~wwxYw)zGet store level staff datazError loading staff data: Nrrr)average_salaryformat_a_countformat_b_countrrrrr) designationrrrzManager / Assistant ManagerrSrr Supervisorgj@r1zFront End Staffg@r&r)r`rbr-rwrXrr_rWrrrrditemsrrR) rmrX staff_datar^staff_by_designationstaffr staff_listrs reget_store_level_staff_dataz/Module8ReportService.get_store_level_staff_data s '>?FF'00H<ce  "E++8yK"66&+&:&:&Ac&'&'5$[1 ''+;;FKkkFVUV$[12BC))-==FKkkFVUV$[12BC  !5!;!;!= K   1'#$45#$45#$45  "># =#*#$Q $ ,#*#$Q $ 1#*#$RJ$c  .qc2 3J sA E E$ EE$ctdddS)zGet HR policy analysis datazReliance RetailzComprehensive employee training programs, performance-based incentives, flexible working hours, and career development opportunities with focus on customer service excellence.zOur HR policies emphasize work-life balance, continuous learning through digital platforms, and community engagement initiatives that differentiate us from traditional retail HR practices.)r%hr_activity_briefpolicy_differentiation)rS)rmrXs reget_hr_policy_analysisz+Module8ReportService.get_hr_policy_analysis s 0P$b  rprc |jjtjtj|k(tj |k(j }tdddd}tdd d d }td d dd}g}d} |D]} t| jxsd| jxsd| jxsd| jxsd} d| jjvr| }id| jjvr| }d| jjvsd| jjvr| }|j| | | jz } |j|jz|jz} |D]} | | jz } t!||||| S#t$r}td|g}Yd}~d}~wwxYw)z,Get utilities data for specific store formatzError loading utilities data: N ElectricitygL@z*Lighting, HVAC, refrigeration, POS systemsz?Peak usage during business hours, energy-efficient LED lighting) utility_namecost_per_monthkey_usage_parametersrWatergp@z+Cleaning, restrooms, food preparation areasz/Municipal water supply with backup storage tankzFuel Generationg@@z2Backup power during outages, generator maintenancez+Diesel generator for emergency power backupgd@rrrr electricitywaterfuel generator)rrfuel_generationadditional_utilitiestotal_utility_cost)r`rbr.rwrXrrr_rWrTrrrrrrrU) rmrXr utilitiesr^rrrr total_costutility utility_datautils reget_utilities_dataz'Module8ReportService.get_utilities_data s  j188##x/,, <ce "&"!MU   !!NE  &*!!UA   " !G&$11>Y&55<%,%A%A%T_6, L 4 4 : : <<* G006688$7//5577;'J^J^JdJdJf;f".$++L9l999 #!(!//%2F2FFIgIgg (D $-- -J)##+!5)   m  21#6 7I sAG G)G$$G)c  |jjtjtj|k(tj |k(j }g}|D]I}|jt|jxsd|jxsd|jxsdK|stddd td d d g}|S#t$r}td|g}Yd}~d}~wwxYw) z5Get operating expenses data for specific store formatzError loading expenses data: Nrrr expense_typepercentage_of_salesrzMaintenance and RepairsrzDRegular maintenance of equipment, fixtures, and store infrastructurezAdmin OverheadsrzSAdministrative costs including stationery, bank charges, and miscellaneous expenses)r`rbr/rwrXrrr_rWrrVoperating_expenses_typepercentage_of_sales_per_yearr)rmrXrrr^ expense_listexpenses reget_operating_expenses_dataz0Module8ReportService.get_operating_expenses_data1 s ww}}%9:AA$--9$77<Gce  G    4$<<I $+$H$H$OC6,!  $!:(+b %!2(+q L7  1!5 6H sAC C4C//C4c ddlm}t||js|dd|d|j |}|j |}|j |}|j|}|j|d}|j|d}|j|d} |j|d} t||||||| | d d S) z6Generate complete Module 8 Services & Utilities reportrrrrrrzStore Formate AzStore Formate Bz[Services and utilities strategy focuses on operational efficiency and employee satisfactionzxBalanced approach to human resource management with cost-effective utility solutions and sustainable operating practices) corporate_office_rolesconcept_office_rolesstore_level_staffhr_policy_analysisutilities_format_autilities_format_boperating_expenses_format_aoperating_expenses_format_brr) rrrfr`rrrrrrrW) rmrXrrrrrrrrrs regenerate_module8_reportz,Module8ReportService.generate_module8_reportU s)!4773C)H:Mc8de e"&!?!?!I#;;HE ;;HE!88B!44X?PQ!44X?PQ&*&F&FxQb&c#&*&F&FxQb&c#$#9!5/111(C(C|U  rpcvddlm}t||js|dd|d|j |}d}|j D]d}|d|j d |jd d |jd |jd |jd |jd |jd z }fd}|jD]d}|d|j d |jd d |jd |jd |jd |jd |jd z }fd}|jD]=}|d|jd |j d d |j"d |j$d z }?d } | |j&} | |j(} d} | |j*} | |j,}d|d|d|d|j.j0d|j.j2d|j.j4d| d| d| d|d|j6d|j8d}|S)z!Generate HTML report for Module 8rrrrrrrKr ₹r9rrcd|jjd|jjdd|jjd|jjd|j jd|j jdd|j jd|j jd|j jd|j jdd|j jd|j jd}|jD]=}|d|jd|jdd|jd|jd z }?|d|jddz }|S) Nrrr9rz% ruk Total Cost ₹z- ) rrrrrrrrr)utilities_datarowsrs regenerate_utility_rowszHModule8ReportService.generate_html_report..generate_utility_rows s  ' ' 4 4 56**99$?@  ' ' < < =>  ' ' / / 01  ! ! . . /0$$33D9:  ! ! 6 6 78  ! ! ) ) *+  + + 8 8 9:..==dCD  + + @ @ AB  + + 3 3 45 # D(';;     ##D)*  & & '( \\N   < 11$78   D Krpc rd}|D]/}|d|jd|jd|jdz }1|S)NrKrrrrr)rrrs regenerate_expense_rowszHModule8ReportService.generate_html_report..generate_expense_rows s]D#  ! ! "#  ( ( )* __    $Krpa Module 8: Services & Utilities
    Module 8: Services & Utilities
    Corporate & Concept Office

    Corporate Office

    a
    Role Category Cost to Company (Y1) per Head Year 1 Year 2 Year 3 Year 4 Year 5

    Concept Office

    z
    Role Category Cost to Company (Y1) per Head Year 1 Year 2 Year 3 Year 4 Year 5
    Store Level Services
    z
    Designation Average Salary Format A Count Format B Count
    Training & Talent Management
    Reference Retailer zH
    HR Activity Brief zM
    Policy Differentiation a
    Utilities

    Store Format A Utilities

    z
    Utility Type Cost per Month Key Usage Parameters Remarks

    Store Format B Utilities

    a
    Utility Type Cost per Month Key Usage Parameters Remarks
    Other Operating Expenses

    Store Format A Operating Expenses

    z
    Expense Type Percentage of Sales per Year Remarks

    Store Format B Operating Expenses

    zz
    Expense Type Percentage of Sales per Year Remarks
    Summary
    Additional Remarks D
    Key Takeaways )
    )rrrfr`rrrwrxryrzr{r|r}rrrrrrrrrrrr%rrrr)rmrXrr1corporate_rowsr concept_rows staff_rowsrrutilities_a_rowsutilities_b_rowsrexpenses_a_rowsexpenses_b_rowsr]s rer_z)Module8ReportService.generate_html_reportv s )!4773C)H:Mc8de e228< 66D #    !$$T*+ ]]O ]]O ]]O ]]O ]]O   N7 44D !    !$$T*+ ]]O ]]O ]]O ]]O ]]O   L5  22E      $$T*+  ! ! "#  ! ! "#   J3$ L11O1OP01O1OP 0 0W0WX/ 0W0WX <          + + > > ?@  + + = = >?  + + B B C D                 + + ,-  & & '({B Hrpc "ddlm}t||js|dd|d|j |}t }t |tdddd}t}g}|jtd |d |jtd d |jtd |d|jtd d|jtd|dtd|dtd|ddddddgg}|jD]} |j| jd| jdt| j t| j"t| j$t| j&t| j(gt+|dt,zdt,zdt,zdt,zdt,zdt,zdt,zg} | j/t1d d!d"d#d$d t2j4fd%d&d'g|j| |jtd d(|jtd)|dtd|dtd|ddddddgg} |j6D]} | j| jd| jdt| j t| j"t| j$t| j&t| j(gt+| dt,zdt,zdt,zdt,zdt,zdt,zdt,zg} | j/t1d d!d"d#d$d t2j4fd%d&d'g|j| |jtd d |jtd*|d|jtd dtd+|dtd,|dtd-|dtd.|dgg} |j8D]U}| j|j:d|j<dt|j>t|j@gWt+| d/t,zdt,zd0t,zd0t,zg}|j/t1d d!d"d#d$d t2j4fd%d1d'g|j||jtd d |jtd2|d|jtd dd3|jBjDgd4t|jBjF|dgd5t|jBjH|dgg}t+|d/t,zd6t,zg}|j/t1d d7d"d#d$d t2j4fd%d1g|j||jtd d |jtd8|d|jtd d|jtd9|dtd:|dtd;|dtd<|dtd=|dgg}|jK|jLjNjPd|jLjNjRdt|jLjNjT|dt|jLjNjV|dg|jLjXjPd|jLjXjRdt|jLjXjT|dt|jLjXjV|dg|jLjZjPd|jLjZjRdt|jLjZjT|dt|jLjZjV|dgg|jLj\D]]}|j|jPd|jRdt|jT|dt|jV|dg_|jd>d|jLj^dd?d?gt+|dt,zd0t,zd/t,zd@t,zg}|j/t1d d!dAdBdCd$t2j`fd"d#d$d t2j4fd%d&d'g|j||jtd d(|jtdD|dtd:|dtd;|dtd<|dtd=|dgg}|jK|jbjNjPd|jbjNjRdt|jbjNjT|dt|jbjNjV|dg|jbjXjPd|jbjXjRdt|jbjXjT|dt|jbjXjV|dg|jbjZjPd|jbjZjRdt|jbjZjT|dt|jbjZjV|dgg|jbj\D]]}|j|jPd|jRdt|jT|dt|jV|dg_|jd>d|jbj^dd?d?gt+|dt,zd0t,zd/t,zd@t,zg}|j/t1d d!dAdBdCd$t2j`fd"d#d$d t2j4fd%d&d'g|j||jtd d |jtdE|d|jtd d|jtdF|dtdG|dtdH|dtd=|dgg}|jdD]D}|j|jf|jhdIt|jV|dgFt+|d/t,zdt,zdJt,zg}|j/t1d d!d"d#d$d t2j4fd%d1d'g|j||jtd d(|jtdK|dtdG|dtdH|dtd=|dgg}|jjD]D}|j|jf|jhdIt|jV|dgFt+|d/t,zdt,zdJt,zg}|j/t1d d!d"d#d$d t2j4fd%d1d'g|j||jtd d |jtdL|d|jtd ddMt|jl|dgdNt|jn|dgg}t+|d/t,zd6t,zg}|j/t1d d7d"d#d$d t2j4fd%d1g|j||jq||jsd|S)Oz0Generate PDF report for Module 8 using ReportLabrrrrrrrrz)Module 8: Services & Utilitiesrr0r z%Corporate & Concept Officerr&zCorporate OfficerYz Role CategoryrzCost to Company (Y1) per HeadY1Y2Y3Y4Y5r r9r;rrrrrrrrrr.rrzConcept OfficezStore Level Services DesignationzAverage SalaryzFormat A CountzFormat B Countrr+r=z'Training & Talent Managementr\zHR Activity BriefzPolicy Differentiationrr6zUtilitieszStore Format A Utilitiesz Utility TypezCost per MonthzKey Usage Parametersrz Total CostrKrr<rrzStore Format B UtilitieszOther Operating Expensesz(Store Format A Operating Expensesz Expense TypezPercentage of Sales per Yearrrz(Store Format B Operating ExpenseszSummaryr_r`):rrrfr`rrr r rrr rrrwrxr.ryrzr{r|r}rrr+rrr-rrrrrrrr%rrextendrrrrrrrrrrr,rrrrrrrr/r0)rmrXrr1r2r3r4r5rrcorporate_tabler concept_tablerr staff_tablehr_datahr_tableutilities_a_datarutilities_a_tableutilities_b_datautilities_b_tableexpenses_a_datarexpenses_a_tableexpenses_b_dataexpenses_b_tablermrns rer@z(Module8ReportService.generate_pdf_reportf sR)!4773C)H:Mc8de e228< PR^`oqr$&  YJFS]L^_` VAr]#  YFzHZ[\ VAq\"  Y8&:LMN$_fX6FGSrtz|DuEJFHLNRTXZ^`def66D  ! !""t++D12DMM"DMM"DMM"DMM"DMM"# 7 3t8SXsSWxY\]aYacfgkckmpqumuwz{w;AB   / ; VXq&,, 7 / - 0 - "    _% VAr]#  Y6z8JKL"?F84DEyQprxzBsCHDFJLPRVX\^bcd 44D   ""t++D12DMM"DMM"DMM"DMM"DMM"! 5ls4xT3t8UXY]U]_bcg_gilmqiqsvw{s{6|} z / ; VXq&,, 7 / - 0 +     ]# VAr]#  YPQR VAq\" x0@A9M]_efn_oCpr{}MOUV^O_s`bkl|~DEM~NbOPQ  22E   !!u++D12E(()E(()  3J3t8SXs4xQTUYQY2Z[ Z / ; VXq&,, 7 / - 0 )     [! VAr]#  YH&Q[J\]^ VAq\"";#A#A#T#T U )K,J,J,\,\^dem^n"o p %y1O1O1f1fhnowhx'y z  SXs4x,@A* / ; VXq&,, 7 / - &     X VAr]#  Y16*3EFG VAq\"  Y@&BTUV&~vh7GH)TdflmufvJwzCDZ\bck\lzmoxyBDJKSDToUVW   + + 7 7 D DK22>>MMdS T {55AAVVX^_gXh i {55AAII6RZK[ \ ^ + + 1 1 > >K2288GGM N {55;;PPRXYaRb c {55;;CCVHEU V X + + ; ; H HK22BBQQRVW X {55EEZZ\bck\l m {55EEMMvV^O_ ` b !  22GGD  # #!!t**401$33VH5EF$,,x(89 % H  ;11DDTJ K !  ""2s4xTSVW[S[]`ae]e>fg"": / ; = 7Hf.>.> ? VXq&,, 7 / - 0 / $   &' VAr]#  Y@&BTUV&~vh7GH)TdflmufvJwzCDZ\bck\lzmoxyBDJKSDToUVW  + + 7 7 D DK22>>MMdS T {55AAVVX^_gXh i {55AAII6RZK[ \ ^ + + 1 1 > >K2288GGM N {55;;PPRXYaRb c {55;;CCVHEU V X + + ; ; H HK22BBQQRVW X {55EEZZ\bck\l m {55EEMMvV^O_ ` b !  22GGD  # #!!t**401$33VH5EF$,,x(89 % H  ;11DDTJ K !  ""2s4xTSVW[S[]`ae]e>fg"": / ; = 7Hf.>.> ? VXq&,, 7 / - 0 / $   &' VAr]#  Y@&BTUV VAq\"  YI6R\K]^_%nfX6FGSqsy{CtDJEGPQZ\bck\lGmno">>G  " "$$../q1'//6(+;<$ ?!SXs4xQTUYQY>G  " "$$../q1'//6(+;<$ ?!SXs4xQTUYQY. s*)z9IUMhMhMnMnMptyMy!9Is",,rz\Supply chain adaptation analysis completed based on category requirements and business needszoStrategic supply chain decisions should align with category performance and operational efficiency requirements)adapting_supply_chain_entries total_entriescategories_requiring_adaptationadaptation_needed_countadaptation_not_needed_countrr)rrrfr`rr6rrXrrrrrr) rmrXrr6adapting_entriesrrrrrunique_categoriesrs regenerate_module9_reportz,Module9ReportService.generate_module9_report s)!4773C)H:Mc8de e2 >>xH,- A $qLM&. #*2 '&))z9I)z&z #*7:Q*Q '+-'%E**002e;/66u7U7UV& 2C++!((-3%*:',=$;(C}L  rpc>ddlm}t||js|dd|d|j |}d}|j D]Z}dj |j}|d |jd |d |jd |jd |jd z }\d}t|jd D]\}} |d |d| dz }d|d|jd|jd|j d|d|j"d|j$d} | S)z!Generate HTML report for Module 9rrrrrrrK, rrrr0z
  • r^z
    • a Module 9: Backend & Supply Chain
    Module 9: Backend & Supply Chain

    Reporting Processes

    The following report will be generated from this module.

    Adapting Supply Chain Analysis
    z
    Entry ID Categories Remarks About Categories Adaptation Needed Point and Rationale
    Summary Statistics

    Total Entries: z>

    Categories Requiring Adaptation: zB

    Categories Not Requiring Adaptation: zc

    Categories Requiring Supply Chain Adaptation
      z
    Analysis Summary
    Additional Remarks rr)rrrfr`rrrYrrrrrr)rrrrrr) rmrXrr1supply_chain_rowsrcategories_strcategories_listr8rr]s rer_z)Module9ReportService.generate_html_report s)!4773C)H:Mc8de e228<  >>E!YYu'E'EFN &        1 1 23  ( ( )*  ) ) *+ "  ?$[%P%PRSTKAx aS8*E: :OU >  ( )4(A(A'BC::E:]:]9^_>>I>e>e=fg  + + ,-  & & '(k: xrpcJ ddlm}t||js|dd|d|j |}t }t |tdddd}t}g}|jtd |d |jtd d |jtd |d|jtd d|jtd|d|jtd dtd|dtd|dtd|dtd|dtd|dgg}|jD]} dj| j} |jtt| j |dt| |dt| j"|dt| j$|dt| j&|dgt)|dt*zdt*zdt*zdt*zdt*zg} | j-t/dd d!d"d#d t0j2fd$d%d&d'd(d)d*g |j| |jtd d |jtd+|d|jtd dtd,|dtt|j4|dgtd-|dtt|j6|dgtd.|dtt|j8|dgg} t)| d/t*zd0t*zg} | j-t/dd1d!d"d#d t0j2fd$d2d&d3d4d5d6g |j| |jtd d |j:r|jtd7|d|jtd dt=|j:d D](\}}|jt|d8||d*|jtd d |jtd9|d|jtd dtd:|dt|j>|dgtd;|dt|j@|dgg}t)|d0t*zdz0Generate PDF report for Module 9 using ReportLabrrrrrrrrz+Module 9: Backend & Supply Chainrr0r z%Adapting Supply Chain Analysisrrz&Supply Chain Adaptation Entriesrr&zEntry ID CategoriesrzAdaptation NeededzPoint & Rationaler rr;rr,rrrrrrrrr.rr0r2r3r4zSummary Statisticsz Total EntrieszCategories Requiring Adaptationz#Categories Not Requiring Adaptationr5rr6r7r r#r%r'z3Categories Requiring Supply Chain Adaptationr^zAnalysis Summaryr_r`rr=)#rrrfr`rrr r rrr rrrYrr.rrrrrrr+rrr-rrrrr)rrr/r0)rmrXrr1r2r3r4r5 supply_datarr  supply_tablermrnr8r analysis_dataanalysis_tables rer@z(Module9ReportService.generate_pdf_report=s)!4773C)H:Mc8de e228< PR^`oqr$&  YLfU_N`ab VAr]#  YFxHXYZ VAr]#  YGPZI[\] VAq\"!*fX.>?>E!YYu'E'EFN   #e//0&2BC.&*:;%>>x@PQ%55vh7GH%66x8HI   ?[SXs4xTSVW[S[]`ae]e4fg j / ; VXq&,, 7 / - 0 0 1 / 2 *    \" VAr]#  Y:F:N OQZ[^_j`G`G\HJPQYJZR[ \ ls4xT6JK z / ; VXq&,, 7 / . 0 0 1 / 2 +   ]# VAr]#  6 6 LL#XZ`akZlm n LL1 &()T)TVWX 8 Y!Bxj'96(;KLM Y LL2 '  Y8&:LMN VAq\"+VH-= > +JhJhjpqyjz@{ | x(8 99[E^E^`fgo`p;q r }T3t88LM / ; VXq&,, 7 / - 0 0 1 / 2 , !   ^$ % A rpN)r`rarbrErrnrcrrrr.r_rr@rerprerr smO7"s"tD]?^"H, , 8O, \XSXSXtsCsGsrprN)zsqlalchemy.ormrrUrrrrrrr rr r rrrrrrrrrrapp.models.main.brandrapp.models.main.segmentrapp.models.main.store_formaterapp.models.main.civilr$app.models.main.display_racking_unitrapp.models.main.carpentryr"app.models.main.electrical_cablingr$app.models.main.commercial_equipmentrapp.models.main.display_boardrapp.models.main.info_techr -app.models.main.visual_merchendising_elementsr!app.models.main.Plumbingr"app.models.main.depreciationr##app.models.main.catchment_potentialr$$app.models.main.competitor_intensityr% app.models.main.location_detailsr&app.models.main.sales_estimater'app.models.main.rent_expensesr(1app.models.main.location_spillage_factor_analysisr)&app.models.main.projected_market_sharer*'app.models.main.competitor_benchmarkingr+(app.models.main.corporate_concept_officer,'app.models.main.store_level_staff_needsr-app.models.main.utilityr."app.models.main.operating_expensesr/rr1r2r3r4r5r6r7r8r9r:r;r<r=r>r?r@rArBrCrDrErFrGrHrIrJrKrLrMrNrOrPrQrRrSrTrUrVrWrcrrfrhrgrrGrqrrerprer.s"""&VVD$ *.8*F2CG91P08EG?;9WJMNK.C           D,fGfGPeeNqqfGGR,w w reerp