G /iT$ddlmZddlmZddlZddlZddlmZddlm Z ddl m Z ddl m Z mZmZmZmZmZddlmZdd lmZdd lmZdd lmZdd lmZdd lmZddlm Z ddl!m"Z"ddl#m$Z$ddl%m&Z&m'Z'm(Z(m)Z)m*Z*m+Z+m,Z,m-Z-ddl.m/Z/GddZ0y)) HTTPException)SessionN)datetime)BytesIO)A4)SimpleDocTemplate ParagraphSpacerTable TableStyleImage)getSampleStyleSheet)colors)TblVendorMetricsPriorityList)TblVendorScorecard)TblPrivateLablling)TblCategoryCaptinshipPlanning) TblSummary)TblGroup) SummaryCreate)VendorPriorityMatrixVendorScorecardPrivateLabellingCategoryCaptainshipPrimaryResearch DamageExpirySummaryModule5ReportPreview)JWTPayloadSchemacleZdZdedefdZdedefdZdedefdZ dede fd Z dede fd Z ded e fd Z y )Module5ReportServicedbtokenc ||_||_yN)r"r#)selfr"r#s F/var/www/html/retail-simulation-api/app/api/module_5_report/service.py__init__zModule5ReportService.__init__"s group_idreturncK|s tdd|jjtj |j xs|jjt j |j xs|jjtj |j xs||jjtj |j xs=|jjtj |j }|rO|jjtj |j}|jjt j |j}|jjtj |j}|jjtj |j}|jjtj |j }t|tdd|Dcgc]}td i|jc}xs tg|D cgc]} td i| jc} xs tgt!ddd|D cgc]} t#d i| jc} xs t#g|D cgc]} t%d i| jc} xs t%g|rt'd i|jn t't(j*j- S|jjt.j |j } | r}t|tddt|gt|gt!dd dt#|gt%|gt'|t(j*j- Std d cc}wcc} wcc} wcc} ww) Nizgroup_id is required) status_codedetail)r*N/A)profiles_interviewedinsights_gathered)negotiation_strategyrecovery_percentage predictions) r*primary_researchvendor_priority_matrixvendor_scorecard damage_expiryprivate_labellingcategory_captainshipsummary last_updatedgizGroup ID not found in database)rr"queryr filter_byfirstrrrrallrrr__dict__rrrrrpd Timestampnowr) r&r*module_data_existsvendor_priorityr7r9r:r;vpvsplcc group_existss r'_fetch_module5_dataz(Module5ReportService._fetch_module5_data&sC8NO O GGMM6 7 A A8 A T Z Z \ K GGMM, - 7 7 7 J P P R K GGMM, - 7 7 7 J P P R K GGMM7 8 B BH B U [ [ ] K GGMM* % / / / B H H J  "ggmm,HISS]eSfjjlO#ww}}-?@JJT\J]aac  $ .@ A K KU] K ^ b b d #'77==1N#O#Y#Yck#Y#l#p#p#r ggmmJ/9989LRRTG'!!0).&+"Wf'fVePR(<(Kr{{(KVe'f(CklBkCK[!\K[R/"@BKK"@K[!\!sapar`s*).(, % N_"_M^r#3#Bbkk#BM^"_"wdtdvcwSg%hSgR&9&HBKK&HSg%h&DnAnCmD7>3'"2"23GI\\--/! ( 77==2<xsd|gtd<|tt|j<j@xsd=|gtd>|tt|j<jBxsd|gg}t|ddg}|j!t#ddddt$j&fddddt$j&fddd d!d"d#d$d%d&d'g |j ||j tdd |j td?|d|j tdd td@|tdA|tdB|g}|g}|jDD]`}t|jFxsd|t|jHxsd|t|jJxsd|g} |j | bgdC}t|d/}|j!t#ddddt$j&fddddt$j&fddd d!d0d1d2d3d&d'g |j ||j tdd |j tdD|d|j tdd td@|tdE|tdB|g}|g}|jLD]`}t|jFxsd|t|jNxsd|t|jJxsd|g} |j | bgdC}t|d/} | j!t#ddddt$j&fddddt$j&fddd d!d0d1d2d3d&d'g |j | |j tdd |j tdF|d|j tdd td|td|gtdG|tt|jPjRxsd=|gtdH|tt|jPjTxsd=|gtdI|tt|jPjVxsd=|gtdJ|tt|jPjXxsd=|gtdK|tt|jPjZxsd=|gtdL|tt|jPj\xsd=|gtdM|tt|jPj^xsd=|gtdN|tt|jPj`xsd=|gtdO|tt|jPjbxsd=|gtdP|tt|jPjdxsd=|gtdQ|tt|jPjfxsd=|gtdR|tt|jPjhxsd=|gtdS|tt|jPjjxsd=|gtdT|tt|jPjlxsd=|gtdU|tt|jPjnxsd=|gtdV|tt|jPjpxsd=|gtdW|tt|jPjrxsd=|gtdX|tt|jPjtxsd=|gg}!t|!ddg}"|"j!t#ddddt$j&fddddt$j&fddd d!d"d#d$d%d&d'g |j |"|j tdd |j tdd |j tdY|jvjydZ|d |j{||j}d-tjjyd[}#d\|jd]|#d^}$d_|$}%tjtjj|%d`at|%db5}&|&j|jdcdcdctjjdd|$S#YxYw#1swY1xYw)ez(Generate PDF report and return file path2)pagesize leftMargin rightMargin topMargin bottomMarginz TS Logo.pngK)widthheightLEFT z"Module 5: Vendor Management ReportTitle NormalzPrimary ResearchHeading2z Fieldz ValuezProfiles Interviewedr/zInsights GatherediT) colWidthsGRIDrrrig?BOX)FONTNAMErgrirzHelvetica-Bold)FONTSIZErgrlrb)rkrr]rh Helvetica)rmrnrhrb) LEFTPADDINGrgrh) RIGHTPADDINGrgrhrq) TOPPADDINGrgrh) BOTTOMPADDINGrgrhrt)VALIGNrgrhTOP)ALIGNrgrhr\zVendor Priority MatrixPriorityAreaMetricsRemarksr)<x) repeatRows)rprgrhrt)rrrgrhrt)rsrgrh)rurgrhrzVendor ScorecardMetric Weightage ImportanceBATNA)r~Pdz Damage ExpiryzNegotiation StrategyzRecovery Percentagenull PredictionszPrivate Labellingz Category Namez Private LabelRational)rXrzCategory CaptainshipzCategory
CaptainshiprzStore SubmissionszStore SummarisezLocation SubmissionszLocation SummarisezNetwork SubmissionszNetwork SummarisezCategory SubmissionszCategory SummarisezPromotions SubmissionszPromotions SummarisezMarketing SubmissionszMarketing SummarisezService SubmissionszService SummarisezBackend SubmissionszBackend SummarisezMetrics SubmissionszMetrics SummarisezLast Updated: z%Y-%m-%d %H:%M:%Sz %Y%m%d_%H%M%Smodule5_complete_report_group__z.pdfzuploaded_files/T)exist_okwbNuploaded_files)Jrrrrr hAlignappendr r fontSizeleadingstrr5r0r1r setStyler rblackr6priorityareametricsremarksr7metric weightage importancebatnar8r2r3r4r9 category_name private_labelrationalr:category_captinshipr;store_submissionsstore_summariselocation_submissionslocation_summarisenetwork_submissionsnetwork_summarisecategory_submissionscategory_summarisepromotions_submissionspromotions_summarisemarketing_submissionsmarketing_summariseservice_submissionsservice_summarisebackend_submissionsbackend_summarisemetrics_submissionsmetrics_summariser<strftimebuildseekrrEr*osmakedirspathdirnameopenwritegetvaluejoin)'r&rPbufferdocstylesstorylogo normal_style research_dataresearch_tableheaders table_rowsvendorrow column_widths vendor_tablescorecard_headersscorecard_rows scorecardscorecard_column_widthsscorecard_table damage_data damage_tableprivate_headers private_rowsprivateprivate_column_widths private_tablecaptainship_headerscaptainship_rows captainshipcaptainship_column_widthscaptainship_table summary_data summary_table timestampfilenamefilepathfs' r'_generate_pdf_reportz)Module5ReportService._generate_pdf_reportlsPR^`oqr$& c"=D DK LL  LL2 '  YCVG_UV VAr]#h' ! !  Y16*3EFG VAr]#~| 4iP\6] ^ -| L M }l 3Ys4CUCUCaCaCjej?kmy5z {  [S#J? j VXsFLL 9 FHa 6 ; , 7 - 0 1 / 2 / / *    \" VAr]#  Y2F:4FGH VAr]# o| 4 o| 4 j, /  (( --G'//85,G'//85,G'**3e\BC    $ .!0lq9 z VXsFLL 9 FHa 6 ; , 7 - 0 1 / 2 / / +   ]# VAr]#  Y5vj7IJK VAr]# o| 4 0, ? j, /  0044K+33 VAr]#~| 4iP\6] ^ *L 99SIgIgIqkqEruAF G *L 99SIgIgIqkqEruA #dllNqNqN{u{J|KAL M -| F G ,l ;Ys4<F G *L 99SIgIgIqkqEruAF G *L 99SIgIgIqkqEruAF G *L 99SIgIgIqkqEruA> --k:  ""8Y7?sAA*Arc d|d}td||jjtj tj |k(j }|rStd||_|jj|jj|tdy tdt|||}|jj||jj|jj|td|jy #t$rF}|jjtd |d d l}|jYd }~y d }~wwxYw) z;Save or update file path in summary table with group_id_modg_m5z6DEBUG: Looking for existing record with group_id_mod: z5DEBUG: Found existing record, updating uploaded_filesz"DEBUG: Updated record successfullyz1DEBUG: No existing record found, creating new one)r* group_id_modrz+DEBUG: Created new record with summary_id: z$ERROR saving file path to database: rN)printr"r>rfilterrr@rcommitrefreshadd summary_id Exceptionrollback traceback print_exc)r&r*rrexisting_summary new_summaryers r'rz*Module5ReportService._save_file_path_to_dbs: "xj,L J<.Y Z#ww}}Z8?? @W@W[g@ghnnp MO2; /  01:<IK(%!-#,  K(  ,CKDZDZC[\] " GG    8< =     ! !  "sB5D:8BD:: F rs[!" &]]4 U??V.*0   ;d"d"r)