J)i d dl mZmZmZmZ d dlmZ d dlmZ d dl m
Z
d dl m Z d dl
mZmZ d dlmZmZmZmZmZmZ d dlmZ d d lmZ d d
lm Z d d l m Z m Z e Z e jC d e
ee ee fde"dede fd Z#e jC d ee ee fde"dede fd Z$e jC d ee ee fde"dede fd Z%y) ) APIRouterDependsResponse
HTTPException)Session)BytesIO)A4)colors)getSampleStyleSheetParagraphStyle)SimpleDocTemplate ParagraphSpacerTable
TableStyleImage)Module3ReportPreview)Module3ReportService)get_db)JWTPayloadSchemaget_current_studentz/{group_id}/preview3)response_modelgroup_iddbtokenc X K t || }|j | d{ S 7 w)z-Preview Module 3 Network Planning report dataN)r _fetch_module3_data)r r r services >/var/www/html/retail-simulation-api/app/api/module_3/router.pypreview_reportr s+ #2u-G,,X6 66 6s !*(*z/{group_id}/download3c 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 dd |j rt d |j D rg dg}
|j D ]v }|j s|j dk7 s d|j v rdnd}|
j |j xs d|j xs ddd|j xs dd |g x t# |
g d }|j% t' d d d!dt( j* fd"d#d$d%d&g |j | n|j t d'| |j t dd( |j t d)|
|j t dd d* }g d+d, ||j, j. ||j, j0 d-gd. ||j, j2 ||j, j4 d-gd/ ||j, j6 ||j, j8 d0gd1 ||j, j: ||j, j< d2gd3 ||j, j> ||j, j@ d4gg}t# |g d5 }|j% t' d d d!dt( j* fd"d#d$d6d&d7g |j | |j t dd( |jC | |jE d d8| d9}tG |jI d:d;d<| i= S 7 H# Y xY ww)>z0Download Module 3 Network Planning report as PDFN( )pagesize
leftMargin rightMargin topMargin bottomMargin CustomTitleHeading2 )parent alignmentHeading4Normalz TS Logo.png K )widthheightLEFT
zModule 3: Network Planning zLocation Selectionc 3 V K | ]! }|j xr |j d k7 # yw)N/AN)location).0ns r z"download_report..C s( &kSjaqzz'IajjE6I'ISjs '))LocationArea
Population Rationaler7 Mumbaiz2Major metropolitan city with high retail potentialz+Growing market with expansion opportunitiesr z.1fz sq km,)d P rB ) colWidthsGRIDr r rI )FONTNAMErG rH Helvetica)FONTSIZErG rH )ALIGNrG rH r3 )VALIGNrG rH TOP)rJ rG )rI r Helvetica-BoldzNo location data available z Store Investment Summaryc | xs d}d|dS )Nr zRs. z,.0f )amountvalues r format_currencyz(download_report..format_currencya s !eD\"" )zInvestment ComponentzFormat AzFormat BSourcezCapital Expenses (Excl. IT)zModule 1zIT Capital ExpenseszRental AdvancezModule 2zPre-operating ExpenseszModule 3zTotal Store InvestmentsTotal) rB rB rC )rO rG rH MIDDLE)rJ )r rI rH rQ module3_network_planning_z.pdfzapplication/pdfzContent-Dispositionzattachment; filename=)content
media_typeheaders)%r r r r
r r r r hAlignappendr r network_planninganyr8 areatotal_hhr setStyler r
blackstore_investment_summarycapital_expenses_acapital_expenses_bit_capital_expenses_ait_capital_expenses_brental_advance_arental_advance_b#calculated_pre_operating_expenses_a#calculated_pre_operating_expenses_b#calculated_total_store_investment_a#calculated_total_store_investment_bbuildseekr getvalue)r r r r reportbufferpdfelementsstyles title_style
section_stylenormallogo
location_datanetwork rationalelocation_tablerW investment_datainvestment_tablefilenames r download_reportr sF #2u-G..x8
8F
YF
FRBBZ\km
nCH
"F j!K
:&M
H
F
]#b9 q"
&
OOI :KHI OOF1bM"
OOI 9=IJ OOF1bM"
3&kSYSjSj&k#kHI
..G G$4$4$=U]ahaqaqUq P ze $$$$- ||(q-V4 '',1Q/ & / }8KL
VXq&,, 7 7 - / / ;
,
! ' ">GH OOF1bM"
OOI ? OP OOF1bM"#
C & 88KK L 88KK L
88NN O 88NN O
88II J 88II J
" 88\\ ] 88\\ ]
# 88\\ ] 88\\ ] %O0 _8KL j 1fll33)+.79*
OO$% OOF1bM"IIh
KKN*8*D9H !$&*?z(JK U 9(
s7 !Q6Q+A
Q6/AQ. 0B4Q6%Q65K7Q6.Q30Q6z /{group_id}/preview-report-pdf3c 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 Exceptionstr)r r r r r es r generate_and_serve_pdfr s{ W&r51!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 app.api.module_3.schemar app.api.module_3.servicer app.database.main.mysqlr app.dependency.authanticationr r module_3_report_routergetintr r r rT rX r r s* ? ? " & D ] ] 8 9 * O" 2CWX &/ %&9 :777 7 Y7 34 &/ %&9 :uuu u 5up => &/ %&9 :WWW W ?WrX