J)i6K d dl mZmZmZmZ d dlmZ d dlmZ d dl m
Z
d dl Z d dl m
Z
d dlmZ d dlmZ d d lmZmZmZmZmZmZ d d
lmZ d d lm Z d d l m Z d d
l m Z m!Z! d dl"m#Z# d dlmZm$Z$ d dl%m&Z& e Z'e'jQ de ee ee! fde)dede fd Z*e'jQ d ee ee! fde)dede fd Z+e'jQ d ee ee! fde)dede fd Z,y) ) APIRouterDependsResponse
HTTPException) FileResponse)Session)BytesION)A4)colors)getSampleStyleSheet)SimpleDocTemplate ParagraphSpacerTable
TableStyleImage)Module1ReportPreview)Module1ReportService)get_db)JWTPayloadSchemaget_current_student)
TblSummary)r ParagraphStyle)inchz/{group_id}/preview1)response_modelgroup_iddbtokenc K t || }|j | S # t $ r t $ r }t ddt | d }~ww xY ww)N zError: status_codedetail)r _fetch_module1_datar Exceptionstr)r r r servicees >/var/www/html/retail-simulation-api/app/api/module_1/router.pypreview_reportr* s] H&r%0**844
Hgc!fX4FGGHs$ A ! AAA AAz/{group_id}/download1c j2 K t || }|j | }t |j D cg c]* }dt |j
v s|j xs d, c} }t |j D cg c]* }dt |j
v s|j xs d, c} }t |j D cg c]* }dt |j
v s|j xs d, c} }t |j D cg c]* }dt |j
v s|j xs d, c} } t |j D cg c]* }dt |j
v s|j xs d, c} }
t |j D cg c]* }dt |j
v s|j xs d, c} } t |j D cg c]* }dt |j
v s|j xs d, c} } t |j D cg c] }|j xs d c} }
t |j D cg c] }|j xs d c} }t |j D cg c] }|j xs d c} }||z |z | z |
z | z | z |
z |z |z }t |j D cg c]* }dt |j
v s|j xs d, c} }t |j D cg c]* }dt |j
v s|j xs d, c} }t |j D cg c]* }dt |j
v s|j xs d, c} }t |j D cg c]* }dt |j
v s|j xs d, c} }t |j D cg c]* }dt |j
v s|j xs d, c} }t |j D cg c]* }dt |j
v s|j xs d, c} }t |j D cg c]* }dt |j
v s|j xs d, c} }|
}|}|}||z |z |z |z |z |z |z |z |z }t# } t% | t& dddd } t) } g } t+ ddd } d
| _ | j/ | | j/ t1 d d t3 d
| d ddd d }!| j/ t5 d|! | j/ t1 d d t3 d| d dd d }"| j/ t5 d|" | j/ t1 d d | j/ t5 d|j6 j8 xs d | d | j/ t5 d |j6 j: xs d | d | j/ t1 d d | j/ t5 d |" | j/ t1 d d t= |j> d D ]b \ }#}$|$j@ r|$j@ dk7 r |$j@ nd!|# }%| j/ t5 d"|# d#|% d$| d | j/ t1 d d% | j/ t5 d&|$jB xs d | d | j/ t1 d d' | j/ t5 d(|$jD dk7 r |$jD nd) | d | j/ t1 d d* | j/ t5 d+|$jF dk7 r |$jF nd) | d | j/ t1 d d* | j/ t5 d,|$jH dk7 r |$jH nd) | d | j/ t1 d d* | j/ t5 d-|$jJ dk7 r |$jJ nd) | d | j/ t1 d d* | j/ t5 d.|$jL xs d) | d | j/ t1 d d/ e | j/ t5 d0|" | j/ t1 d d tO |jP dkD r|jP d jR dk7 r|jP d }&| j/ t5 d1|&jR d$| d | j/ t1 d d% | j/ t5 d2|&jT xs d3 | d | j/ t1 d d* | j/ t5 d4|&jV xs d5 | d | j/ t1 d d* | j/ t5 d6tY |&d7d8 | d | j/ t1 d d* | j/ t5 d9tY |&d:d5 | d | j/ t1 d d* | j/ t5 d-|&jJ xs d5 | d | j/ t1 d d* | j/ t5 d;|&jZ xs d5 | d | j/ t1 d d* | j/ t5 d<|&j\ xs d5 | d | j/ t1 d d* | j/ t5 d=|&j^ xs d5 | d n| j/ t5 d>| d | j/ t1 d d% | j/ t5 d?| d | j/ t1 d d* | j/ t5 d@| d | j/ t1 d d* | j/ t5 dA| d | j/ t1 d d* | j/ t5 dB| d | j/ t1 d d* | j/ t5 dC| d | j/ t1 d d* | j/ t5 dD| d | j/ t1 d d* | j/ t5 dE| d | j/ t1 d d* | j/ t5 dF| d | j/ t1 d d tO |jP d kD r|jP d jR dk7 r|jP d }'| j/ t5 dG|'jR d$| d | j/ t1 d d% | j/ t5 d2|'jT xs d3 | d | j/ t1 d d* | j/ t5 d4|'jV xs d5 | d | j/ t1 d d* | j/ t5 d6tY |'d7d8 | d | j/ t1 d d* | j/ t5 d9tY |'d:d5 | d | j/ t1 d d* | j/ t5 d-|'jJ xs d5 | d | j/ t1 d d* | j/ t5 d;|'jZ xs d5 | d | j/ t1 d d* | j/ t5 d<|'j\ xs d5 | d | j/ t1 d d* | j/ t5 d=|'j^ xs d5 | d n| j/ t5 dH| d | j/ t1 d d% | j/ t5 d?| d | j/ t1 d d* | j/ t5 d@| d | j/ t1 d d* | j/ t5 dA| d | j/ t1 d d* | j/ t5 dB| d | j/ t1 d d* | j/ t5 dC| d | j/ t1 d d* | j/ t5 dD| d | j/ t1 d d* | j/ t5 dE| d | j/ t1 d d* | j/ t5 dF| d | j/ t1 d d | j/ t5 dI|" | j/ t1 d d | j/ t5 dJ| d | j/ t1 d d t5 dK| d t5 dL|dM| d gt5 dN| d t5 dL|dM| d gt5 dO| d t5 dL|dM| d gt5 dP| d t5 dL| dM| d gt5 dQ| d t5 dL|
dM| d gt5 dR| d t5 dL| dM| d gt5 dS| d t5 dL| dM| d gt5 dT| d t5 dL|
dM| d gt5 dU| d t5 dL|dM| d gt5 dV| d t5 dL|dM| d gt5 dW| d t5 dX|dMd$| d gg }(ta |(dYtb z dZtb z g[ })|)je tg d\d]d^d_d`th jj fdadbd`dcth jl fdddedfdgdhg | j/ |) | j/ t1 d di | j/ t5 dj| d | j/ t1 d d t5 dK| d t5 dL|dM| d gt5 dN| d t5 dL|dM| d gt5 dO| d t5 dL|dM| d gt5 dP| d t5 dL|dM| d gt5 dQ| d t5 dL|dM| d gt5 dR| d t5 dL|dM| d gt5 dS| d t5 dL|dM| d gt5 dT| d t5 dL|dM| d gt5 dU| d t5 dL|dM| d gt5 dV| d t5 dL|dM| d gt5 dk| d t5 dX|dMd$| d gg }*ta |*dYtb z dZtb z g[ }+|+je tg d\d]d^d_d`th jj fdadbd`dcth jl fdddedfdgdhg | j/ |+ | j/ t1 d d | j/ t5 dl|" | j/ t1 d d t5 dl| d t5 |jn jp xs d5| d gt5 dm| d t5 t |jn jr xs d | d gg},ta |,d*tb z dntb z g[ }-|-je tg d\d]dadbd`dcth jl fdddodpdqdrg | j/ |- | ju | | jw d ty | j{ dsdtduiv S c c}w c c}w c c}w c c}w c c}w c c}w c c}w c c}w c c}w c c}w c c}w c c}w c c}w c c}w c c}w c c}w c c}w # Y xY ww)wNAr B2 )pagesize
leftMargin rightMargin topMargin bottomMarginz TS Logo.png K )widthheightLEFT
CustomTitleHeading1 zHelvetica-Bold)parentfontSize
spaceAfter alignmentfontNamez Module 1: Store Format & Details
SectionHeaderHeading2 )r? r@ rA rC zBranding & Store Details zName of the Store: zN/ANormalzRationale: z#Consumer Segments & Catchment Sizes zSegment z Segment z: z zISEC Segmentation: u+ • Chief Wage Earner's Occupation: z
Not specified u9 • Education of the highest educated male adult: u; • Education of the highest educated female adult: u • Location: u • Catchment Size: zStore Format DetailszStore Format A: u$ • Store Size (in sq. ft.): g u • Merchandise: zNot Setu" • Merchandise Rationale: merchandise_rationalez Not providedu • Pricing Strategy: pricing_strategyu • Service Parameters: u • Technology Adoption: u • Other Parameters: z Store Format A: Not Setu' • Store Size (in sq. ft.): 0.0u • Merchandise: Not Setu. • Merchandise Rationale: Not providedu$ • Pricing Strategy: Not Setu • Location: Not Setu& • Service Parameters: Not Setu' • Technology Adoption: Not Setu$ • Other Parameters: Not SetzStore Format B: z Store Format B: Not SetzCapital ExpenseszStore Format Az
Civil WorkzRs. z,.2fzRacking and Display UnitszCarpentry and FurniturezElectrical and CablingzCommercial EquipmentzSignage and Display BoardszInformation TechnologyzVisual MerchandisingPlumbingOthersz TotalzRs. g @g ?) colWidths)ALIGNr r rW r8 )VALIGNrU rV TOP
BACKGROUND)r rW rV GRIDrU g ?)WORDWRAPrU rV T) LEFTPADDINGrU rV rL ) RIGHTPADDINGrU rV rL )
TOPPADDINGrU rV rL )
BOTTOMPADDINGrU rV rL
zStore Format BzTotal InvestmentszDepreciation Methodz Depreciation Years (in Years) )r] rU rV rK )r^ rU rV rK )r_ rU rV rK )r` rU rV rK zapplication/pdfzContent-Dispositionz'attachment; filename=module1_report.pdf)content
media_typeheaders)>r r$ sumcivilr& store_format_typetotaldisplay_racking_units carpentryelectrical_cablingcommercial_equipmentdisplay_boardsinfotechvisual_merchandisingplumbingadditional_installations
total_costr r
r
r r hAlignappendr r r brand
brand_name rationale enumeratesegments segment_name
isec_value chief_wage_earner_occupationmale_educationfemale_educationlocationtotal_populationlen
store_formats
store_name
store_size merchandisegetattrservice_parameterstechnology_adoptionother_parametersr r setStyler r lightgreyblack depreciationdepreciation_method slm_yearsbuildseekr getvalue).r r r r' reportitemformat_a_civilformat_a_displayformat_a_carpentryformat_a_electricalformat_a_equipmentformat_a_signage format_a_itformat_a_visualformat_a_plumbingformat_a_othersformat_a_totalformat_b_civilformat_b_displayformat_b_carpentryformat_b_electricalformat_b_equipmentformat_b_signage format_b_itformat_b_visualformat_b_plumbingformat_b_othersformat_b_totalbufferdocstylesstorylogo title_style
section_styleisegmentr{ sf_asf_b capex_a_data
capex_a_table capex_b_data
capex_b_tabledepreciation_datadepreciation_tables. r) download_reportr % s #2e,G
(
(
2F fllildcSQUQgQgMhFh$**//lijN8T8T{8TX[_bcgcycy_zXzDJJO!O8T{| &:J:J q:J$cUXY]YoYoUpNpdjjoAo:J qr 6;T;T {;T4X[_bcgcycy_zXztzzQ;T {| &:U:U |:U$Y\`cdhdzdz`{Y{djjoAo:U |}8M8Mt8MQTX[\`\r\rXsQsDJJO!O8Mtu6??i?4cSQUQgQgMhFhtzzQ?ijKv7R7RS7Rt4::??7RSTO I TZZ_1_ IJF<[<[\<[D4??/a/<[\]O)),>>ATT - .0; <>M N + , fllildcSQUQgQgMhFh$**//lijN8T8T{8TX[_bcgcycy_zXzDJJO!O8T{| &:J:J q:J$cUXY]YoYoUpNpdjjoAo:J qr 6;T;T {;T4X[_bcgcycy_zXztzzQ;T {| &:U:U |:U$Y\`cdhdzdz`{Y{djjoAo:U |}8M8Mt8MQTX[\`\r\rXsQsDJJO!O8Mtu6??i?4cSQUQgQgMhFhtzzQ?ijK%O)%O)),>>ATT - .0; <>M N + , YF
FRBBZ\km
nC
"F E
]#b9
T
VAr]#
!j!!
K
LL={KL LL2 #j!! M
LL5}EF LL1 LL 7 8O8O8XSX7YZ\bck\lmn LL / 0F0F0O%/PQSYZbScde LL2
LL@-PQ LL2 3
7/6/C/CH\H\`eHew++muvwuxky
YQCr, t DfXFVWX
VAq\"
Y!;GwtM_aj?k>l mouv~o A B
VAq\"
Y!6t}}7Q 6R SU[\dUefg
VAq\"
Y!@AXAXAe\e@f giopxiyz{
VAq\"
Y!A$BZBZBg^gAh ikqrzk{|}
VAq\"
Y!>t?T?T?aXa>b ceklteuvw Y ?AQRS
VAq\"
Y H&QYJZ[\
VAq\"
Y @&BRST
VAq\"
Y OQWX`Qabc
VAq\"
Y EvhGWXY
VAq\"
Y =vh?OPQ
VAq\"
Y GPXIYZ[
VAq\"
Y H&QYJZ[\
VAq\"
Y EvhGWXY LL2 6 1$)=)=a)@)K)Ku)T##A&
Y!4T__4ET JFS[L\]^
VAq\"
Y!EdooF\Y\E] ^`fgo`pqr
VAq\"
Y!9$:J:J:Wi9X Y[abj[klm
VAq\"
Y!CGDRikyDzC{ | E FN O P Q
VAq\"
Y!>wtM_aj?k>l mouv~o A B
VAq\"
Y!6t}}7Q 6R SU[\dUefg
VAq\"
Y!@AXAXAe\e@f giopxiyz{
VAq\"
Y!A$BZBZBg^gAh ikqrzk{|}
VAq\"
Y!>t?T?T?aXa>b ceklteuvw Y ?AQRS
VAq\"
Y H&QYJZ[\
VAq\"
Y @&BRST
VAq\"
Y OQWX`Qabc
VAq\"
Y EvhGWXY
VAq\"
Y =vh?OPQ
VAq\"
Y GPXIYZ[
VAq\"
Y H&QYJZ[\
VAq\"
Y EvhGWXY LL2
LL-}=> LL2
LL2F84DEF LL2 <!1 2I^TXDY>Z\bck\l4mn .x0@ A9tTdeiSjMkmst|m}C~ ,fX.> ?TRdeiQjKkmst|m}A~ +VH-= > DQdeiPjJkmst|m}@~ )6(+; {| /1A BIPTUefjTkNlntu}n~D A +VH-= > DQ\]aPbJceklteu@vw )6(+; xy :vh / 0)dCTUYBZ<[]cdl]m2no 8VH - . D QU@V:WY_`hYi0jk >6(#3 4i'.Y]I^^b@ceklteu6vw L ,3t8SX2FGM:++ w&*:*:; 3 5,,-+.
'
LL LL2
LL2F84DEF LL2 <!1 2I^TXDY>Z\bck\l4mn .x0@ A9tTdeiSjMkmst|m}C~ ,fX.> ?TRdeiQjKkmst|m}A~ +VH-= > DQdeiPjJkmst|m}@~ )6(+; {| /1A BIPTUefjTkNlntu}n~D A +VH-= > DQ\]aPbJceklteu@vw )6(+; xy :vh / 0)dCTUYBZ<[]cdl]m2no 8VH - . D QU@V:WY_`hYi0jk -vh/? @)gVdeiUjjnLoqw yA rB CC D L ,3t8SX2FGM:++ w&*:*:; 3 5,,-+.
'
LL LL2
LL0-@A LL2
(&*: ;YvGZGZGnGnG{r{ ~D EM ~N >O P 2F84D EyQTU[UhUhUrUrUwvwQx {A BJ {K HL M
0QtVQtV:Ad3Ad+7Ad3" Ad?AdAd3+ Ad
Ad
Ad34 AdAd#Ad3= AdAd,Ad3 Ad #Ad 5Ad3 Ad!,Ad!>Ad3 Ad&5Ad&AAd3 AAd+ AO
Ad3d+Ad0d-Ad3z /{group_id}/preview-report-pdf1c K t || }|j | }| |dS # t $ r t $ r }t ddt | d}~ww xY ww)z4Generate PDF report and return file path information)r file_pathr zError generating PDF: r! N)r generate_and_save_pdfr r% r& )r r r r' r r( s r) generate_and_serve_pdfr I sr W&r%011(; !"
W6LSQRVH4UVVWs$ A!& AAAAA)-fastapir r r r fastapi.responsesr sqlalchemy.ormr ior osreportlab.lib.pagesizesr
reportlab.libr reportlab.lib.stylesr reportlab.platypusr
r r r r r app.api.module_1.schemar app.api.module_1.servicer app.database.main.mysqlr app.dependency.authanticationr r app.models.main.summaryr r reportlab.lib.unitsr module_1_report_routergetintr* r r r) r s@ ? ? * " & 4 ] ] 8 9 * O . D $ # 2CWX &/ %&9 : H H H H Y H 34 &/ %&9 :``` ` 5`F => &/ %&9 :WWW W ?Wr