G /i}ddlmZddlmZddlmZmZddlZddl Z ddl m Z ddl m Z ddl mZddlmZmZmZmZmZmZdd lmZdd lmZdd lmZdd lmZdd lmZddl m!Z!ddl"m#Z#ddl$m%Z%ddl&m'Z'ddl(m)Z)ddl*m+Z+ddl,m-Z-ddl.m/Z/ddl0m1Z1ddl2m3Z3m4Z4m5Z5m6Z6m7Z7m8Z8m9Z9m:Z:m;Z;mZ>ddl?m@Z@GddZAy)) HTTPException)Session) Environment BaseLoaderN)datetime)BytesIO)A4)SimpleDocTemplate ParagraphSpacerTable TableStyleImage)getSampleStyleSheet)colors)TblCategoriesUnderPromotions)TblCompetitorLoyalty)TblCompetitorPricingAnalysis)TblCustomerEngagement)TblPromotionCompetitorAnalysis)TblRecoveryOfPromotional) TblStoreFormatepricingStrategies)TblCategoryPricingStrategis)TblDefineYourPromotions) TblSummary)TblGroup) SummaryCreate) CompetitorPricingAnalysisStoreFormatepricingStrategiesCategoryPricingStrategisDefineYourPromotionsPromotionalCalendarPromotionCompetitorAnalysisRecoveryOfPromotionalCategoriesUnderPromotionsCustomerEngagementCompetitorLoyaltySummaryModule6ReportPreview)JWTPayloadSchemacleZdZdedefdZdedefdZdedefdZ dede fd Z dede fd Z ded e fd Z y )Module6ReportServicedbtokenc ||_||_yN)r-r.)selfr-r.s F/var/www/html/retail-simulation-api/app/api/module_6_report/service.py__init__zModule6ReportService.__init__,s group_idreturnc@K|s tdd|jjtj |j xs9|jjt j |j xs|jjtj |j xs|jjtj |j xsy|jjtj |j xs9|jjtj |j xs|jjtj |j xs|jjtj |j xs||jjtj |j xs=|jjtj |j }|r|jjtj |j }|jjt j |j}|jjtj |j}|jjtj |j }|jjtj |j}|jjtj |j }|jjtj |j } |jjtj |j } |jjtj |j } |jjtj |j } t!||rt#j$|n t#||r#|D cgc]} t'j$| c} n t'|g|r#|Dcgc]}t)j$|c}n t)|g|rt+j$|n t+|t-|g|r|Dcgc]}t/|j0|j2rt5|j2ndt7|ddrt5t7|ddndt7|ddrt5t7|ddndd|j8c}n t/|g|rt;j$|n t;|| rt=j$| n t=|| rt?j$| n t?|| rtAj$| n tA|| rtCj$| n tC|tDjFjI S|jjtJj |j }|rt!|t#|t'|gt)|gt+|t-|gt/|gt;|t=|t?|tA|tC|tDjFjI Std d cc} wcc}wcc}ww) Nizgroup_id is required) status_codedetail)r5N/Ayour_store_typethroughout_the_year) promotion_idcompetitor_effortstop_promotion_typestop_categories_for_promotionsspillover_categoriesr5) r5competitor_pricing_analysisstore_format_pricing_strategiscategory_pricing_strategisdefine_your_promotions_strategypromotional_calendarpromotion_competitor_analysisrecovery_of_promotionalcategories_under_promotionscustomer_engagementcompetitor_loyaltysummary last_updatedizGroup ID not found in database)&rr-queryr filter_byfirstrrrrrrrrrallr)rmodel_validaterr r!r"r#r=r>strgetattrr5r$r%r&r'r(pd Timestampnowr)r1r5module_data_existscompetitor_pricing store_formatscategory_pricing define_promopromo_analysisrecoverycategories_under engagementloyalty_programrLscp group_existss r2_fetch_module6_dataz(Module6ReportService._fetch_module6_data0sC8NO O GGMM6 7 A A8 A T Z Z \ K GGMM: ; E Ex E X ^ ^ ` K GGMM5 6 @ @( @ S Y Y [ K GGMM1 2 < HHRZH[aacH#ww}}-IJTT^fTgmmo '<=GGQYGZ``bJ"ggmm,@AKKU]K^ddfOggmmJ/9989LRRTG'!l~,E,T,TUg,hE^hpEq|Iiv/wivde0M0\0\]^0_iv/wPmwP@OAvF`p+q`p[\,D,S,STU,V`p+qMeowMxLyeq0D0S0ST`0axLV^x_&98&L%M$ . / .!0%&^^HIH\H\3q/C/C+DbgX_`actvzX{C;Ld0S,TBGfmnorGIMgNc'!EZ\`:a6bTY-2!"  . /+Fx*X)YZb(=(L(LX(Vh}HPiQjz,E,T,TUe,fAZdlAmU_$6$E$Ej$QewBJfKXg#4#C#CO#Tm~IQnR;B..w7YaHb\\--/- 4 77==2<xsd|tt|j8xsd|t|j6xsd|g}|j |t'|d.}|j)t+ddddt,j.fddddt,j.fddd d!d"d#d$d%d&d'd(g |j ||j tdd |j td1|d|j tdd td|td|gtd|tt|j@jxsd|gtd2|tt|j@jBxsd|gtd3|tt|j@jDxsd|gtd4|tt|j@jFxsd|gtd5|tt|j@jHxsd|gg}t'|}|j)t+ddddt,j.fddddt,j.fddd d!d"d#d$d%d&d'd(g |j ||j tdd |j td6|d|j tdd td7|td0|td8|td9|td:|td;|g}|g}|jJD]}t|jLxsd|t|j<xsd|t|jNxsd|t|jPxsd|t|jRxsd|t|jTxsd|g}|j |t'|d.}|j)t+ddddt,j.fddddt,j.fdd|d|j tdd td?|td@|tdA|tdB|g}|g}|jVD]y}t|jXxsd|t|jZxsd|t|j\xsd|t|j^xsd|g}|j |{t'|d.}|j)t+ddddt,j.fddddt,j.fddd d!d"d#d$d%d&d'd(g |j ||j tdd |j tdC|d|j tdd td|td|gtdD|tt|j`jbxsd|gtdE|tt|j`jdxsdF|gtdG|tt|j`jfxsd|gg}t'|}|j)t+ddddt,j.fddddt,j.fddd d!d"d#d$d%d&d'd(g |j ||j tdd |j tdH|d|j tdd td|td|gtdI|tt|jhjjxsi|gg} t'| }!|!j)t+ddddt,j.fddddt,j.fddd d!d"d#d$d%d&d'd(g |j |!|j tdd |j tdJ|d|j tdd td|td|gtdK|tt|jljnxsd|gtdL|tt|jljpxsd|gg}"t'|"}#|#j)t+ddddt,j.fddddt,j.fddd d!d"d#d$d%d&d'd(g |j |#|j tdd |j tdM|d|j tdd td|td|gtd|tt|jrjxsd|gtdN|tt|jrjtxsd|gtdO|tt|jrjvxsd|gtdP|tt|jrjxxsd|gtdQ|tt|jrjzxsd|gtdR|tt|jrj|xsd|gtdS|tt|jrj~xsd|gtdT|tt|jrjxsdF|gtdU|tt|jrjxsd|gtdV|tt|jrjxsd|gtdW|tt|jrjxsd|gtdX|tt|jrjxsd|gg }$t'|$}%|%j)t+ddddt,j.fddddt,j.fddd d!d"d#d$d%d&d'd(g |j |%|j tdd |j tdY|d|j tdd td|td|gtdK|tt|jjnxsd|gtdL|tt|jjpxsd|gg}&t'|&}'|'j)t+ddddt,j.fddddt,j.fddd d!d"d#d$d%d&d'd(g |j |'|j tdd |j tdd |j tdZ|jjd[|d |j||jdFtjjd\}(d]|jd^|(d_})d`|)}*tjtjj|*dabt|*dc5}+|+j|jddddddtjjde|)S#Y8xYw#1swY1xYw)fz(Generate PDF report and return file path2)pagesize leftMargin rightMargin topMargin bottomMarginz TS Logo.pngK)widthheightLEFT Titlez(Module 7: Marketing & Communications NormalzMarketing PlanHeading2z Fieldz ValuezReference Competitorr:zPricing Strategyz$Which Category Generates Most IncomezKey Observation Around Pricingz Other RemarksGRIDrrrg?BOX)FONTNAMEr~rrzHelvetica-Bold)FONTSIZEr~rr{)rrrvr Helvetica)rrrr{) LEFTPADDINGr~r) RIGHTPADDINGr~rr) TOPPADDINGr~rr) BOTTOMPADDINGr~rr)VALIGNr~rTOP)ALIGNr~rru)WORDWRAPr~rTzIntegrated Marketing ActivitieszStore Format
TypezPricing
StrategiesRationalzOther
Strategy) repeatRowsz Brand JourneyCategoryz!Marketing Communications StrategyzOngoing Key PromotionszAmong Key Various PromotionzWhat Are The Same Keyz Other RemarkzPromotional CalendarMonthzType of
PromotionzSuccess
Metric ObjectiveRemarks)rr~r)rrrrzPromotion Competitor AnalysiszCompetitor
EffortszTop Promotion
Typesz!Top Categories
for PromotionszSpillover
CategorieszRecovery of PromotionalzBased UnderstandingzWhat Percentagerz What CategoryzCategories Under PromotionszOn Which CategoryzCustomer EngagementzPromotions SubmissionszPromotions SummarisezCompetitor LoyaltyzDo They Have Loyalty ProgramzLoyalty Program TypezKey Observations LoyaltyzIs It Useful For StorezWant Loyalty ProgramzDescribe Loyalty ProgramzBudget AllocatedzBenefits of Loyalty ProgramzPerils of Loyalty ProgramzDifference From Competitorz Other Notesr(zLast Updated: z%Y-%m-%d %H:%M:%Sz %Y%m%d_%H%M%Smodule6_complete_report_group__z.pdfzuploaded_files/T)exist_okwbNuploaded_files)Urr r rrhAlignappendr alignmentr fontSizeleadingrSrBreference_competitorpricing_strategy6which_category_generates_the_most_income_for_the_store+key_observation_around_pricing_in_the_store other_remarksr setStylerrblackrCstore_format_typechoose_a_pricing_strategiesrationalspecify_other_strategyrDcategorypricing_strategisrEongoing_key_promotionsamoung_key_variouse_promotionwhat_are_the_same_key other_remarkrFmonthtype_of_promotionsuccess_metric objectiveremarksrGr>r?r@rArHbased_unterstandingwhat_percentage what_categoryrIon_which_categoryrJpromotions_submissionspromotions_summariserKdo_they_have_a_loyalty_programloyalty_program_typekey_observations_loyaltyis_it_useful_for_storewant_loyalty_programdescribe_loyalty_programbudget_allocatedbenefits_of_loyalty_programperils_of_loyalty_programdifference_from_competitor other_notesrLrMstrftimebuildseekrrWr5osmakedirspathdirnameopenwritegetvaluejoin),r1ribufferdocstylesstorylogo title_style normal_style pricing_data pricing_table store_headers store_rowsstorerow store_tablecategory_headers category_rowsrcategory_table promo_data promo_tablecalendar_headers calendar_rowscalendarcalendar_tablecomp_analysis_headerscomp_analysis_rowscompcomp_analysis_table recovery_datarecovery_tablecategories_datacategories_tableengagement_dataengagement_table loyalty_data loyalty_table summary_data summary_table timestampfilenamefilepathfs, r2_generate_pdf_reportz)Module6ReportService._generate_pdf_reportsPR^`oqr$& c"=D DK LL  LL2 ' Wo !  YI;WX VAr]#h' ! !   Y/ 1CDE VAr]#~| 4iP\6] ^ -| #dNrNrOJOJOSNSKTVbAc d 4l CYsSWSwSwTVTVT_Z_P`bnFo p . =yTMqMqNHNHNQLQJRT`@a b ~| 4iDDhDhDuDuD~y~@BN7O P  J' Z VXsFLL 9 FHa 6 ; , 7 - 0 1 / 2 / / 0)    [! VAr]#  Y5vj7IJK VAr]# g| , j, / -| < *L 9 k< 0 i .  ** 11H(..1E<@(++4ulC(44=|L(11:ULI(,,5|D(**3e\B C   %2}; VXsFLL 9 FHa 6 ; , 7 - 0 1 / 2 / / 0, !   ^$ VAr]#  Y>z@RST VAr]# . = / > 9< H 0, ? ! 4466D$11:ULI$22;e\J$<<E|T$33U V (, 73tGcGcGsGsGxwxCy|H:I J  5yTEaEaEoEoExsxAy|H8I J  }- VXsFLL 9 FHa 6 ; , 7 - 0 1 / 2 / / 0, !   ^$ VAr]#  YPQR VAr]#~| 4iP\6] ^ *L 99SIiIiI{I{JB@BFCEQ #dNfNfN}N}OGBGKHJVAW X -| #dNeNeN|N|OFAFKGIUAV W -|  VAr]#~| 4iP\6] ^ / > #dllNqNqNzuzJ{~JAK L -| > --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_m6z6DEBUG: 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)r5 group_id_modrz+DEBUG: Created new record with summary_id: z$ERROR saving file path to database: rN)printr-rNrfilterrrPrcommitrefreshadd summary_id Exceptionrollback traceback print_exc)r1r5rrexisting_summary new_summaryers r2rz*Module6ReportService._save_file_path_to_db@s: "xj,L J<.Y Z#ww}}Z8?? @W@W[g@ghnnp MO2; /  01:<IK(%!-#,  K(  ,CKDZDZC[\] " GG    8< =     ! !  "sB5D:8BD:: F r/sr!"* &]]4 TKTPXL]RS.*0    ;q"q"r4