J)iA d dl mZmZmZ d dlmZ d dlmZ d dlm Z d dl
m Z d dl m
Z
mZ d dlmZmZmZmZmZmZmZ d dlmZ d d lmZ d d
lm Z d d l m Z d d l m Z m!Z! e Z"e"jG d
e ee ee! fde$dede fd Z%e"jG d ee ee! fde$dede fd Z&e"jG d ee ee! fde$dede fd Z'y) ) APIRouterDependsResponse)Session)BytesIO)A4)colors)getSampleStyleSheetParagraphStyle)SimpleDocTemplate ParagraphSpacerTable
TableStyleImage PageBreak)inch)Module8ReportPreview)Module8ReportService)get_db)JWTPayloadSchemaget_current_studentz/{group_id}/preview8)response_modelgroup_iddbtokenc X K t || }|j | d { S 7 w)N)r _fetch_module8_data)r r r services E/var/www/html/retail-simulation-api/app/api/module_8_report/router.pypreview_reportr! s+ #2u-G,,X6 66 6s !*(*z /{group_id}/preview-report-pdf8c b K t || }|j | d { }| |dS 7 w)N)r file_path)r generate_and_save_pdf)r r r r r# s r preview_report_pdfr% s7 #2u-G 33H==I y 99 >s !/-
/z/{group_id}/download8c j K t || }|j | d { }t }t |t dt
z dt
z }g }t
} t ddd } d| _ |j | |j t dd |j t d
|d |j t dd |j t d
|d |j t dd |j t d|d t dddd }
dt d|
ddddd gg} |j D ] } | j | j xs d | j rd | j d nd | j rt# | j nd!| j$ rt# | j$ nd!| j& rt# | j& nd!| j( rt# | j( nd!| j* rt# | j* nd!g t- | d"t
z d"t
z d#t
z d#t
z d#t
z d#t
z d#t
z g$ }
|
j/ t1 d%d&d'dt2 j4 fd(d)d*d+d,g |j |
|j t dd |j t d-|d dt d|
ddddd gg}|j6 D ] }|j |j xs d |j rd |j d nd |j rt# |j nd!|j$ rt# |j$ nd!|j& rt# |j& nd!|j( rt# |j( nd!|j* rt# |j* nd!g t- |d"t
z d"t
z d#t
z d#t
z d#t
z d#t
z d#t
z g$ }|j/ t1 d%d&d'dt2 j4 fd(d)d*d+d,g |j | |j t dd. |j t d/|d |j t dd g d0g}|j8 D ] }|j |j: xs d |j< rd |j< d nd |j> rt# |j> nd!|j@ rt# |j@ nd!g t- |d1t
z d"t
z d2t
z d2t
z g$ }|j/ t1 d%d&d'dt2 j4 fd(d)d*d+d,g |j | |j t dd. |j tC |j t d3|d |j t dd t d4dd5d67 }t d8dd5d6d9 }t d:| t |jD jF xs d | gt d;| t |jD jH xs d | gt d<| t |jD jJ xs d | gg}t- | }|j/ t1 d%d&d'dt2 j4 fd=d>d*d+d,d?d@dAdBg
|j | |j t dd. |j t dC|d |j t dd |j t dD|d t dE| t dF| t dG| t dH| gg}dI}|jL D ] }|jN dJk( s|j t |jP xs d | t |jR rd |jR d nd | t |jT xs d | t |jV xs d | g ||jR xs dIz
} t- | }|j/ t1 d%d&d'dt2 j4 fd(d)d*d+d,d?d@dAdBg
|j | t dK| t dL|d dM| t dN| t dN| gg} t- | } | j/ t1 d%d&d'dt2 j4 fdOd*dPdQg |j | |j t dd |j t dR|d t dE| t dF| t dG| t dH| gg} dI} |jL D ] }|jN dSk( s| j t |jP xs d | t |jR rd |jR d nd | t |jT xs d | t |jV xs d | g | |jR xs dIz
} t- | } | j/ t1 d%d&d'dt2 j4 fd(d)d*d+d,d?d@dAdBg
|j | t dK| t dL| d dM| t dN| t dN| gg}!t- |! }"|"j/ t1 d%d&d'dt2 j4 fdOd*dPdQg |j |" |j t dd. |j tC |j t dT|d |j t dd |j t dU|d t dV| t dW| t dH| gg}#|jX D ]{ }$|$jN dXk( s|#j t |$jZ xs d | t |$j\ r|$j\ dYndZ| t |$jV xs d | g } t- |# }%|%j/ t1 d%d&d'dt2 j4 fd(d)d*d+d,d?d@dAdBg
|j |% |j t dd |j t d[|d t dV| t dW| t dH| gg}&|jX D ]{ }$|$jN d\k( s|&j t |$jZ xs d | t |$j\ r|$j\ dYndZ| t |$jV xs d | g } t- |& }'|'j/ t1 d%d&d'dt2 j4 fd(d)d*d+d,d?d@dAdBg
|j |' |j t dd. |j t d]|d |j t dd t d^| t |j^ j` xs d | gt d_| t |j^ jb xs d | gg}(t- |( })|)j/ t1 d%d&d'dt2 j4 fd=d>d*d+d,d?d@dAdBg
|j |) |je | |jg dI d`| da}*ti |jk dbdcdd|* ie S 7 # Y xY ww)fNg ?)pagesize topMargin bottomMarginz TS Logo.png K )widthheightLEFT
z%Module 8: Services & UtilitiesTitle z!Corporate & Concept OfficeHeading2 z Corporate OfficeHeading3 header_style Helvetica-Bold)fontSizefontName alignmentz
Role Categoryz%Cost to
Company (Y1)
per HeadY1Y2Y3Y4Y5zN/AzRs. z,.0fzRs. 00g ?g333333?) colWidthsGRIDr r rF )FONTNAMErD )rF r r8 )rG )r r/ rE Helvetica)FONTSIZErD rE r7 )ALIGNrD rE CENTER)VALIGNrD rE MIDDLEz Concept Office zStore Level Services) DesignationzAverage SalaryzFormat A
CountzFormat B
Count g333333?z#Training & Talent Management
cell_style CJK)r9 leadingwordWrapcentered_cell_style)r9 rT rU r; zName of Reference RetailerzCProvide a brief about chosen Human and Employee Management ActivityzLHow are your policies/plan/activities different from those of this retailer?)rG rD )r rF r8 )rG )r/ r rE rH )
TOPPADDINGrD rE r4 )
BOTTOMPADDINGrD rE r4 ) LEFTPADDINGrD rE r4 ) RIGHTPADDINGrD rE r4 zUtilitiesz Store Format A Utilitiesz Utility TypezCost per MonthzKey Usage ParametersRemarksr zStore Formate AzTotal CostzRs. z )rG rD rE r8 )rJ rD rE r. )rL rD rE TOPz Store Format B UtilitieszStore Formate Bz Other Operating Expensesz(Store Format A Operating Expensesz Expense Typez Percentage of Sales per YearzStore Format A%z0%z(Store Format B Operating ExpenseszStore Format BzSummaryzService SubmissionszService Summarisemodule8_report_z.pdfzapplication/pdfzContent-Dispositionzattachment; filename=)content
media_typeheaders)6r r r r r r r
r hAlignappendr r
r corporate_concept_office
role_categorycost_to_companyy1stry2y3y4y5r setStyler r blackconcept_officestore_level_staff_needs designationaverage_salaryformat_a_countformat_b_countr training_talent_managementname_of_reference_retailer employee_management_activitypoliceis_plan_activities utilitiesstore_format_type utility_namecost_per_monthkey_usage_parametersremarkoperating_expensesoperating_expenses_type percentage_of_sales_per_yearsummaryservice_submissionsservice_summarisebuildseekr getvalue)+r r r r reportbufferpdfelementsstyleslogor6 corp_datacorp
corp_table concept_dataconcept
concept_table
store_datastore store_tablerQ rV
training_datatraining_table util_a_data total_cost_autil util_a_table total_a_data
total_a_table util_b_data total_cost_b util_b_table total_b_data
total_b_table op_a_dataop
op_a_table op_b_data
op_b_table summary_data
summary_tablefilenames+ r download_reportr ' sW #2u-G..x8
8F
YF
FR3t8RUVZRZ
[CH
"F
]#b9 q"
&
OOI EvgWX OOF1bM"
OOI A6*CUVW OOF1aL!
OOI >z@RST!.1GWcdeL!9-TVb#ceikoquw{ ~B C DI// '%262F2Fd4''- .G GGCL GGCL GGCL GGCL GGCL
0 ySXs4xT3t8UXY]U]_bcg_gilmqiq,rsJ
3 573)-.
$
OOJ OOF1bM"
OOI PQR$i0WYe&fhlnrtxz~ AE F GL(( ! ! *U5<5L5Ld7**40 1RY &zzC
Os &zzC
Os &zzC
Os &zzC
Os &zzC
Os
) ,3t8SXs4xQTUYQY[^_c[cehimemorswow2xyM: 3 573)-.
'
OOM" OOF1bM"
OOI ;VJ=OPQ OOF1aL!YZJ// &272F2Fd5''- .G).)=)=C$$ %3).)=)=C$$ %3
0
qvs4xT3t8.TUK 3 573)-.
%
OOK OOF1bM"
OOIK OOI CVJEWXY OOF1aL! q"uUJ()>TVafrst /1D E 644OOXSXZm n p XZm n 644QQZUZ\o p r acv w 644MMVQVXk l n M =)NJ 3 573)-.+.,- (
OON# OOF1bM"
OOI 0&2DEF OOF1aL!
OOI ?
ASTU n.ABIN^`sDt 46IJIV_atLuw xKL ! !%6 6 $++4u6IJt?R?RD!4!4T :;X_atu$33QR$++.0CD
D / / 41 4L ! %L* 3 573)-.+.,- &
OOL! 24GH)V]^jko]pptTu xK KL r#672GZ9[] ^L,'M: 3 58)++ '
OOM" OOF1bM"
OOI ?
ASTU n.ABIN^`sDt 46IJIV_atLuw xKL ! !%6 6 $++4u6IJt?R?RD!4!4T :;X_atu$33QR$++.0CD
D / / 41 4L ! %L* 3 573)-.+.,- &
OOL! 24GH)V]^jko]pptTu xK KL r#672GZ9[] ^L,'M: 3 58)++ '
OOM" OOF1bM"
OOIK OOI ?
ASTU OOF1aL!
OOI H&Q[J\]^N,?@)Ljl CAI':;= >I''
#3 3 "44=?RS2CbCbR < < =Q?hl oB C")),u.AB
( y!J
3 573)-.+.,- $
OOJ OOF1bM"
OOI H&Q[J\]^N,?@)Ljl CAI':;= >I''
#3 3 "44=?RS2CbCbR < < =Q?hl oB C")),u.AB
( y!J
3 573)-.+.,- $
OOJ OOF1bM"
OOI .z0BCD OOF1aL!
(*= > &..JlJlJupu xK AL M &(; r s* 0 0 " & D h h h $ ? @ * O" 2CWX &/ %&9 :777 7 Y7 => &/ %&9 :::: : ?: 34 &/ %&9 :HHH H 5Hr