J)i d dl mZmZmZmZ d dlmZ d dlmZ d dl m
Z
d dl m Z d dl
mZmZ d dlmZmZmZmZmZmZmZ d dlmZ d d lmZ d d
l m Z d d l m Z m Z e Z!e!jE d e
ee ee fde#dede fd Z$e!jE d ee ee fde#dede fd Z%e!jE d ee ee fde#dede fd Z&y) ) APIRouterDependsResponse
HTTPException)Session)BytesIO)A4)colors)getSampleStyleSheetParagraphStyle)SimpleDocTemplate ParagraphSpacerTable
TableStyleImage PageBreak)Module2ReportPreview)Module2ReportService)get_db)JWTPayloadSchemaget_current_studentz/{group_id}/preview2)response_modelgroup_iddbtokenc X K t || }|j | d{ S 7 w)z.Preview Module 2 Location Analysis report dataN)r _fetch_module2_data)r r r services >/var/www/html/retail-simulation-api/app/api/module_2/router.pypreview_reportr! s+ #2u-G,,X6 66 6s !*(*z/{group_id}/download2c K t || }|j | d{ }t }t |t dddd }g }t }t
d|d d } |d }
|d } t d
d d
} d| _ |j | |j t dd |j t d| |j t dd |j t d|
|j t d| |j t d| |j t d| |j t dd |j t d|
|j t dd g dg}
|j D ]U }|
j t |j xs d |j xs d dt |j xs d g W t# |
g d }|j% t' d d d dt( j* fd!d"d#d$d%d&d'g |j | |j t dd t- |d(d }|j t d)| d| |j t dd |j t d*|
|j t d+| t- |d,d- }|j t | | |j t dd |j t d.|
|j t d/| t- |d0d- }|j t | | |j t dd |j t d1|
|j. D ] }|j0 xs d2}|j t d3| | |j t d4|j2 xs d | |j t d5| |j t d6| |j t d7| |j t d8| |j t d9| |j t dd: |j t dd |j t5 |j t d;|
|j t dd g d<g}t- |d=d }t- |d>d }|j dd?|d@d?|d@g t# |g dA }|j% t' d d d dt( j* fd!d"d#d$d%d&d'g |j | |j t dd |j t dB|
|j6 D ] }|j0 xs d2}|j t d3| | |j t dC|j8 xs dD | |j t dE|j: xs dD | |j t dF|j< xs dD | |j t dd: |j t ddG |j? | |jA dD dH| dI}tC |jE dJdKdL| iM S 7 /# Y xY ww)Nz1Download Module 2 Location Analysis report as PDFN( )pagesize
leftMargin rightMargin topMargin bottomMargin CustomTitleHeading2 )parent alignmentHeading4Normalz TS Logo.png K )widthheightLEFT
zModule 2: Location Analysis z Understanding Shoppersu • Shopping Frequency per Monthu# • Household Consumption per Monthu) • Total Household Consumption per Month zCatchment Potential)z
ISEC CategoryzPercentage of Segmentz Number of Potential Households g %)i r0 ) colWidthsGRIDr r r@ )FONTNAMEr> r? Helvetica)ALIGNr> r? r4 )VALIGNr> r? TOP) LEFTPADDINGr> r? ) RIGHTPADDINGr> r? rG )
BOTTOMPADDINGr> r? )
TOPPADDINGr> r? rJ estimated_market_sharezEstimated Market Share: z Competition Intensityu( • Total Square foot of the competitiontotal_sqft_of_competitionzN/AzQuality of Locationu • Spillage Factorspillage_factorzLocation DefinitionAzStore Format: u • Trading Radius: u • Adjacenciesu • Corner Propertyu • Highstreetu • Mallu • Parking SpacerJ zEstimated Sales)zEstimated SaleszStore AzStore Bestimated_sales_aestimated_sales_bzRs.z,.2f)x rR rR zRent Detailsu' • Rental Advance Amount (in Rupees): r u' • Rental Advance Period (in Months): u • Rent per Month (in Rupees): rG module2_location_analysis_z.pdfzapplication/pdfzContent-Dispositionzattachment; filename=)content
media_typeheaders)#r r r r
r r r r hAlignappendr r catchment_potentialstr ISEC_Segmentpercentage_of_segment potential_number_of_householdsr setStyler r
blackgetattrlocation_detailsstore_format_typetrading_radiusr
rent_expensesrental_advance_amountrental_advance_periodrent_per_monthbuildseekr getvalue)r r r r reportbufferpdfelementsstyles title_style
section_stylenormallogocatchment_dataccatchment_table
est_markettotal_competitionspillagelocationfmt
sales_datasale_asale_b sales_tablerentfilenames r download_reportr s #2u-G..x8
8F
YF
FRBBZ\km
nCH
"F j!K
:&M
H
F
]#b9 q"
&
OOI ;[IJ OOF1bM"
OOI =}MN OOI @&IJ OOI CVLM OOI I6RS OOF1aL!
OOI :MJK OOF1bM"bcN
'
' $" %&&-#.a 0 006B 7
( NoFO Z 1fll33++,-.+ )
OOO$ OOF1bM"!93?J OOI 8 A FOP OOF1bM"
OOI OOF1aL!
OOI :MJK OOI 3V<=v 0%8H OOI
V45 OOF1aL!
OOI :MJK++((/C N3%"8&AB $89P9P9WTW8X"Y[abc "3V<= "7@A "2F;< *f56 "5v>?q! % ,
OOF1aL!
OOIK OOI 6
FG OOF1bM";K 1fll33++,-.+ %
OOK OOF1bM"
OOI 3]CD$$$$+ N3%"8&AB $KDLfLfLkjkKl"mouvw $KDLfLfLkjkKl"mouvw $DTEXEXE]\]D^"_aghiq! %
%
OOF1aL!IIh
KKN+H:T:H !$&*?z(JK } 9(
s* !] ]A
] /A] 0Z#] ]] z /{group_id}/preview-report-pdf2c K t || }|j | d{ }| |dS 7 # t $ r t $ r }t ddt | d}~ww xY ww)z4Generate PDF report and return file path informationN)r file_pathi zError generating PDF: ) status_codedetail)r generate_and_save_pdfr ExceptionrZ )r r r r r es r generate_and_serve_pdfr s{ W&r%0!77AA !"
B
W6LSQRVH4UVVWs1 A# 0 .0 A#0 A AA A#N)'fastapir r r r sqlalchemy.ormr ior reportlab.lib.pagesizesr
reportlab.libr
reportlab.lib.stylesr r reportlab.platypusr
r r r r r r app.api.module_2.schemar app.api.module_2.servicer app.database.main.mysqlr app.dependency.authanticationr r module_2_report_routergetintr! r r r r s- ? ? " & D h h h 8 9 * O" 2CWX &/ %&9 :777 7 Y7 34 &/ %&9 :III I 5IX => &/ %&9 :WWW W ?Wr