{2ia^ddlZddlZddlmZddlmZddlmZmZm Z m Z ddl m Z ddl mZddlmZddlmZdd lmZdd lmZdd lmZdd lmZdd lmZddlmZddlmZddl m!Z!ddl"m#Z#ddl$m%Z%ddl&m'Z'ddl(m)Z)ddl*m+Z+ddl,m-Z-ddl.m/Z/ddl0m1Z1ddl2m3Z3ddl4m5Z5ddl6m7Z7ddl8m9Z9ddl:m;Z;ddlm?Z?dd l@mAZAdd!lBmCZCdd"lDmEZEdd#lFmGZGdd$lHmIZIdd%lJmKZKdd&lLmMZMdd'lNmOZOdd(lPmQZQdd)lRmSZSdd*lTmUZUdd+lVmWZWdd,lXmYZYdd-lZm[Z[dd.l\m]Z]dd/l^m_Z_dd0l`maZadd1lbmcZcdd2ldmeZedd3lfmgZgdd4lhmiZidd5ljmkZkdd6llmmZmdd7lnmoZodd8lpmqZqdd9lrmsZsdd:ltmuZudd;lvmwZwddl|m}Z}dd?l~mZdd@lmZddAlmZddBlmZddClmZddDlmZddElmZddFlmZddGlmZddHlmZddIlmZddJlmZddKlmZddLlmZddMlmZddNlmZddOlmZddPlmZddQlmZddRlmZddSlmZddTlmZddUlmZddVlmZddWlmZddXlmZddYlmZddZlmZdd[lmZdd\lmZdd]lmZdd^lmZdd_lmZdd`lmZddalmZddblmZddclmZdddlmZddelmZddflmZddglmZddhlmZddilmZddjlmZddklmZddllmZddmlmZddnlmZddolmZddplmZddqlmZddrlmZddslmZddtlmZddulmZddvlmZddwlmZmZmZmZmZddxlmZeZedyefdzZeejejejed{|Zejd}d~e dede fdZeje dgd{dgdgdgejeddgejeddgejeddgejeddgejeddgeje!ddgeje#ddgeje%ddgeje'ddgeje)ddgeje+ddgeje-ddgeje/ddgeje1ddgeje3ddgeje5ddgeje7ddgeje9ddgeje;ddgeje=ddgeje?ddgejeAddgejeCddgejeEddgejeGddgejeIddgejeKddgejeMddgejeOddgejeQddgejeSddgejeUddgejeWddgejeYddgeje[ddgeje]ddgejekddgeje_ddgejeaddgejecddgejeeddgejegddgejeiddgejemddgejeoddgejeqddgejesddgejeuddgejewddgejeyddgeje{ddgeje}ddgejeddgejeddgejeddgejeddgejeddgejeddgejeddgejeddgejeddgejeddgejeddgejeddgejeddgejeddgejeddgejeddgejeddgejeddgejeddgejeddgejeddgejeddgejeddgejeddgejeddgejeddgejeddgejeddgejeddgejeddgejeddgejeddgejeddgejeddgejeddgejeddgejeddgejeddgejeddgejeddgejeddgejeddgejeddgejeddgejeddgejeddgejeddgejeddgejeddgejeddgejeddgejeddgejeddgejed~e dedefdZejed~e dedefdZejed~e dedefdZejed~e dedefdZejed~e dedefdZej dd{dedefdZejdeddedZ ejddZ ej dee fdefdZ ejdeddy(N)Callable)asynccontextmanager)FastAPI HTTPExceptionRequestResponse)CORSMiddleware) JSONResponse) StaticFiles)ProgrammingError)Depends)OAuth2PasswordBearer) user_router) brand_router)segment_router)store_formate_router)student_router)simulation_router) group_router)customer_location_router)catchment_potential_router)network_planning_router)payment_router) excel_router) civil_router)display_racking_unit_router)commercial_equipment_router)plumbing_router)trading_month_router)pre_operating_router)competitor_analysis_router)displayboard_router)competitor_bench_marking_router)carpentry_router)info_tech_router)visual_merch_elements_router)depreciation_router)#competitor_category_analyses_router)pre_select_category_router) gross_margin_contribution_router)#vendor_metrics_priority_list_router)vendor_scorecard_router)private_lablling_router)#category_captinship_planning_router)additional_installation_router)sales_estimate_router)rent_expenses_router)"competitor_pricing_analysis_router)corporate_store_router) category_definition_excel_router)%competitor_analysis_comparison_router)corporate_concept_office_router)utility_router)operating_expenses_router)store_formate_pricing_router)store_level_staff_router)centralised_and_direct_router)category_wish_inventory_routre)shrinkage_areas_reasons_router)inventory_excel_router)online_policies_router) sales_router)recurring_operating_router)digital_asset_router)marketing_competitor_router)competitorintensity_router)projected_market_share_router)location_spillage_router)location_details_router)electrical_cabling_router)!category_pricing_strategis_router)define_your_promotions_router)$promotion_competitor_analysis_router)recovery_promotional_router)customer_engagement_router)competitor_loyalty_router)!brand_attribute_assessment_router)branding_attributes_router)integrated_marketing_router)annexures_router)optimising_assets_router)short_negotiation_final_router)-margin_and_sales_contribution_analysis_router) online_pre_select_service_router)adapting_supply_chain_router)critical_for_business_router)#expanded_performance_metrics_router)"categories_under_promotions_router)comparative_analysis_router)$measuring_sales_profitability_router)pre_selected_service_router)concept_office_router)store_investment_summary_router)summary_router)cash_conversion_cycle_router)visual_merch_Strategy_router) stu_router) master_router)user_simulation_router)category_simulation_router)physical_store_formats_router)cap_ex_refurbish_router)online_store_format_router)module_1_report_router)module_2_report_router)module_3_report_router)module_4_report_router)module_5_report_router)module_6_report_router)module_7_report_router)module_8_report_router)module_9_report_router)module_10_report_router)all_content_router)promotion_calender_router)institution_router)landing_page_router)settings)MongoDBSingleton)OperationalError) handle_generic_exception_handlerhandle_programming_errorhttp_exception_error_handler handel_operational_error_handlerhandel_attribute_error_handler)CustomResponse_appc"Kt}dyw)zInitialize the application.N)mongodb_instance)r_s //var/www/html/retail-simulation-api/app/main.pylifespanrs A  T)titleversion descriptionrdebughttprequest call_nextreturncKtj}||d{}tj|z }t||jd<|S75w)a Add process time header to the response. Args: request (Request): The incoming request. call_next (Callable): The next callable in the middleware chain. Returns: Response: The response with added process time header. NzX-Process-Time)timestrheaders)rr start_timeresponse process_times radd_process_time_headerrsPJw''H99;+L),\):H%& O(s AA6A*) allow_originsallow_credentials allow_methods allow_headersexpose_headersz/FASTAPIUser)prefixtagsBrandSegmentz Store FormateStudent SimulationGroupzCustomer LocationzCatchment PotentialzNetwork PlanningPaymentzDownload ExcelzCivil and Backroom WorkzDisplay and Racking UnitszCommercial EquipmentPlumbingzTrading MonthszPre-Operating ExpenseszCompetitor Analysisz Display BoardzCompetitor Bench Marking Carpentryz Info TechzVisual Merchandising Elements DepreciationzCompetitor Category AnalyseszPre Selected CategoryzGross Margin ContributionzVendor Metrics priority ListzVendor ScorecardzPrivate LabllingzCategory Captinship PlanningzAdditional InstallationzSales Estimatez Rent ExpenseszCompetitor Pricing Analysisz Store Formate pricing StrategieszCorporate Storez Training Talent Management ExcelzCompetitor Analysis ComparisonzCorporate Concept OfficeUtilityzOperating ExpenseszStore Level StaffzCentralised and DirectzCategory Wish InventoryzShrinkage Areas ReasonszInventory ExcelzOnline Policies ExcelSaleszRecurring Operatingz Digital AssetzMarketing CompetitorzCompetitor IntensityzProjected Market SharezLocation Spillage FactorzLocation DetailszElectrical CablingzCategory Pricing StrategiszDefine Your PromotionszPromotion Competitor AnalysiszRecovery of PromotionalzCustomer Engagement StrategieszCompetitor LoyaltyzBrand Attribute AssessmentzBranding AttributeszIntegrated Marketing AnnexureszOptimising AssetszShort Negotiation Finalz&Margin and Sales Contribution AnalysiszOnline Pre Selected ServicezAdapting Supply ChainzCritical for BusinesszExpanded Performance MetricszCategories Under PromotionszComparative AnalysiszMeasuring Sales ProfitabilityzPre Selected ServicezConcept OfficezStore Investment SummarySummaryzCash Conversion CyclezVisual Merchandising Strategyz Student ExcelMasterzUser SimulationzCategory SimulationzPhysical Store FormatszCap-Ex RefurbishzOnline Store FormatzModule 1zModule 2zModule 3zModule 4zModule 5zModule 6zModule 7zModule 8zModule 9z Module 10z All ContentzPromotion Calender Institutionz Landing Pageexcc"Kt||Sw)zHandle HTTP exceptions.)r}rrs rexception_handlerr's ( 55rc6Kt||d{S7w)z)Handle MySQL ProgrammingError exceptions.N)r|rs rprogramming_error_handlerr-s*'37 77 7 c6Kt||d{S7w)zHandle generic exceptions.N)r{rs rgeneric_exception_handlerr3s2'3? ?? ?rc6Kt||d{7wN)r~rs roperational_error_handlerr9s0#> >> >rc6Kt||d{S7wr)rrs rattribute_error_handlerr>s/= == =rz/migrate)response_model_exclude_nonemessagec LK tjdddddj|gtjgdtdd S#tj$r}t d t | d}~wt$r}t d t | d}~wwxYww) Nalembicrevisionz--autogeneratez-mz"{}")rupgradehead1zMigration successful)statusri) status_codedetail) subprocessrunformatrCalledProcessErrorrr Exception)res rrun_migrationsrCs<  :/?v}}U\G]^_ * S2HII  ( (<CF;; <CF;;app.api.online_policies.routerr?app.api.sales.routerr@+app.api.recurring_operating_expenses.routerrA(app.api.digital_asset_acquisition.routerrB,app.api.marketing_competitor_analysis.routerrC#app.api.competitor_intensity.routerrD%app.api.projected_market_share.routerrE0app.api.location_spillage_factor_analysis.routerrFapp.api.location_details.routerrG!app.api.electrical_cabling.routerrH)app.api.category_pricing_strategis.routerrI.app.api.define_your_promotions_strategy.routerrJ,app.api.promotion_competitor_analysis.routerrK&app.api.recovery_of_promotional.routerrL-app.api.customer_engagement_strategies.routerrM)app.api.competitor_loyalty_program.routerrN)app.api.brand_attribute_assessment.routerrO"app.api.branding_attributes.routerrP#app.api.integrated_marketing.routerrQapp.api.annexures.routerrR,app.api.optimising_assets_for_revenue.routerrS&app.api.short_negotiation_final.routerrT5app.api.margin_and_sales_contribution_analysis.routerrU0app.api.online_pre_selected_service_level.routerrV$app.api.adapting_supply_chain.routerrW$app.api.critical_for_business.routerrX+app.api.expanded_performance_metrics.routerrY*app.api.categories_under_promotions.routerrZ#app.api.comparative_analysis.routerr[,app.api.measuring_sales_profitability.routerr\#app.api.pre_selected_service.routerr]app.api.concept_office.routerr^'app.api.store_investment_summary.routerr_app.api.summary.routerr`$app.api.cash_conversion_cycle.routerra,app.api.visual_merchandising_strategy.routerrbapp.api.student_excel.routerrcapp.api.master.routerrdapp.api.user_simulation.routerre"app.api.category_simulation.routerrf%app.api.physical_store_formats.routerrgapp.api.cap_ex_refurbish.routerrh"app.api.online_store_format.routerriapp.api.module_1.routerrjapp.api.module_2.routerrkapp.api.module_3.routerrlapp.api.module_4_report.routerrmapp.api.module_5_report.routerrnapp.api.module_6_report.routerroapp.api.module_7_report.routerrpapp.api.module_8_report.routerrqapp.api.module_9_report.routerrrapp.api.module_10_report.routerrsapp.api.all_content.routerrt!app.api.promotion_calender.routerruapp.api.institution.routerrvapp.api.landing_page.routerrw app.configrxapp.database.main.mongoryrzapp.exceptionsr{r|r}r~rapp.utils.schemas_utilsrrr PROJECT_NAME API_VERSION DESCRIPTIONr middlewareradd_middlewareinclude_routerrrrrrAttributeErrorrrrrmountuser_oauth2_schemeon_eventrrrrrrrsr $*==2*++1,-1=17-EI:16-MK3=FI<S55U<[LU[CC[T?=YAU_S2GXKOQQAA-RITJOUCGWX]NTOWIK5QQo]MM[YK]K?S1MU3/AIOCI:::AAAAAAC9G9;4+3#%        $$ 7xH$%%%5 ;zA< 'C>*I;G' /ARS>*I;G$Jl^L9+F*I;G,ZG[F\]+JFYEZ[0KcJde1*LeKfg1*LeKfg)*DUCVW)*D[C\]< 'C-jH]G^_' /ARS.zI_H`a-jH^G_`0KcJde+JF`Eab*:EWDXY,ZG[F\]4ZOkNlm0KcJde7 RqQrs.zIbHcd-jHhGij,ZG[F\]4ZOkNlm-jH]G^_.zI_H`a#J[MJ+JFYEZ[1*LeKfg@\D[EF3JNkMlm/ JaIbc/ JaIbc6zQoPpq5jPmOno.zI_H`a7 RqQrs.zI_H`a(CSBTU2:MgLhi>*I;G/ JaIbc/ JiIjk:j7HI=8*E)*DUCVW-jH]G^_0KcJde*:EWDXY-jH]G^_)*J<P)*J<P)*J<P)*J<P)*J<P)*J<P)*J<P)*J<P)*J<P*:[MR%j O,ZG[F\]%j O&z@PQ}%6W6=6\6&6 '(8W8;K8P\8)8 y!@W@9@@"@ '(?W?;K?P]?)?~&>7>>=>'>5<#<<6<$ *[959 E*3HI i++\ !*+B B"B DK[ \r