G /iYjddlmZddlmZddlmZddlmZddlZddlm Z ddl m Z m Z m Z mZmZmZddlmZmZdd lmZdd lmZdd lmZdd lmZdd lmZddlmZddl m!Z!ddl"m#Z#ddl$m%Z%ddl&m'Z'ddl(m)Z)ddl*m+Z+ddl,m-Z-ddl.m/Z/ddl0m1Z1ddl2m3Z3ddl4m5Z5ddl6m7Z7ddl8m9Z9m:Z:ddl;mZ>m?Z?m@Z@mAZAmBZBmCZCmDZDmEZEmFZFmGZGmHZHmIZImJZJmKZKGddZLy)) HTTPException)datetime)Session)BytesION)A4)SimpleDocTemplate ParagraphSpacerTable TableStyleImage)getSampleStyleSheetParagraphStyle)inch)colors)JWTPayloadSchema)TblGroup)TblBrand) TblSegment)TblStoreFormat)TblCivil)TblDisplayRackingUnit) TblCarpentry)TblElectricalCabling)TblDisplayBoard)TblCommercialEquipment) TblInfoTech)TblVisualMerchElements) TblPlumbing)TblAdditionalInstallation)TblDepreciation) TblSummary SummaryBase)BrandSegment StoreFormatCivilDisplayRackingUnit CarpentryElectricalCabling DisplayBoardCommercialEquipmentInfoTechVisualMerchandisingElementsPlumbingAdditionalInstallations DepreciationCapitalExpensesSummaryModule1ReportPreviewc\eZdZdedefdZdedefdZdede fdZ dede fd Z ded e fd Z y ) Module1ReportServicedbtokenc ||_||_y)N)r6r7)selfr6r7s ?/var/www/html/retail-simulation-api/app/api/module_1/service.py__init__zModule1ReportService.__init__3s group_idreturnc |jjtjtj|k(j }|st dd|d|jjtj|j }|jjtj|j}|jjtj|j}|jjtj|j}|jjtj|j}|jjtj|j}|jjtj|j} |jjt j|j} |jjt"j|j} |jjt$j|j} |jjt&j|j} |jjt(j|j}|jjt*j|j}|jjt,jt,j|k(j } t/d|d|du|rt/d|j0d |j2t5|j6|j|j0|j2|j8 }t/d |j:d |j2nt5|}t/d d&d }||d||dz||dz|| dz|| dz|| dz|| ddz||ddz||ddz}|| d}||z}||d||dz||dz|| dz|| dz|| dz|| ddz||ddz||ddz}|| d}||z}t=||xsd|xsd|xsd|xsd|xsd|xsddd }t?d'id|d|rtAjB|n tAd|xsgDcgc]}tEjB|c}d|xsgDcgc]}tGjB|c}d|xsgDcgc]}tIjB|c}d|xsgDcgc]}tKjB|c}d|xsgDcgc]}tMjB|c}d| xsgDcgc]}tOjB|c}d| xsgDcgc]}tQjB|c}d| xsgD cgc]} tSjB| c} d| xsgD!cgc]}!tUjB|!c}!d | xsgD"cgc]}"tWjB|"c}"d!|xsgD#cgc]}#tYjB|#c}#d"|xsgD$cgc]}$t[jB|$c}$d#|d$|d%t]j^}%|%Scc}wcc}wcc}wcc}wcc}wcc}wcc}wcc} wcc}!wcc}"wcc}#wcc}$w)(Niz Group ID z not found in database) status_codedetail)r=z DEBUG: Group z depreciation_data exists: zDEBUG: Raw data - years: z , method: )depreciation_idr= slm_yearsdepreciation_method slm_remarkszDEBUG: Created obj - years: z$DEBUG: No data found, using defaultsc8tfd|xsgDS)Nc 3pK|]-}tt|ddvrt|dxsd/yw)store_format_typerN)strgetattr).0itemattr fmt_letters r: zSModule1ReportService._fetch_module1_data..sum_for_format..osA,DWT3F%K!LLtQ',1,,s36)sum) data_listrOrNs ``r:sum_for_formatz@Module1ReportService._fetch_module1_data..sum_for_formatns#&_"_ r<A total_costBgzAuto-generated dynamicallyz0CAPEX summary generated based on available data.) r=store_format_a_capital_excl_itstore_format_a_it_capitalstore_format_a_totalstore_format_b_capital_excl_itstore_format_b_it_capitalstore_format_b_totaladditional_remarks key_takeawaysr=brandsegments store_formatscivildisplay_racking_units carpentryelectrical_cablingdisplay_boardscommercial_equipmentinfotechvisual_merchandisingplumbingadditional_installations depreciationcapital_expenses_summary last_updated)total)0r6queryrfilterr=firstrr filter_byrallrrrrrrrrrrr r!printdepreciation_yearsrDr1rBremarkrCr2r3r$from_ormr%r&r'r(r)r*r+r,r-r.r/r0rnow)&r9r=group brand_data segment_datastore_format_data civil_datadisplay_racking_datacarpentry_dataelectrical_cabling_datadisplayboard_datacommercial_equipment_data infotech_datavisual_merch_data plumbing_dataadditional_installation_datadepreciation_datadepreciation_objrSformat_a_excl_it format_a_itformat_a_totalformat_b_excl_it format_b_itformat_b_totalrmssfcdrecr6ceitvmpai report_datas& r:_fetch_module1_dataz(Module1ReportService._fetch_module1_data7s h'..x/@/@H/LMSSUC)H:Mc8de eWW]]8,666IOOQ ww}}Z0::H:MQQS  GGMM.9CCXCVZZ\WW]]8,666IMMO #ww}}-BCMMW_M`ddf|4>>>QUUW"&''--0D"E"O"OYa"O"b"f"f"h GGMM/:DDhDW[[]$(GGMM2H$I$S$S]e$S$f$j$j$l! k2<>$5$I$I-44    01A1K1K0LJWgW{W{V|} ~+X>  8 :  :s +137 8^S1 24c: ;.4  5 6<  = .\B  C]C> ?93 M N %]C8 )K7 :s +137 8^S1 24c: ;.4  5 6<  = .\B  C]C> ?93 M N %]C8 )K7#9+;+Bs&1&8S!/!63+;+Bs&1&8S!/!63;L $  +  0:%.., 5A4FB4FH4Fag&&q)4FH @Q?VTV?VX?V;//3?VX  0:/?R/?A/?5>>!$/?A  OcNhfhNh"jNhr#5#>#>r#BNh"j  8F7K7KM7Ky))!,7KM KbJgegJgiJg2 1 : :2 >Jgi BSAXVXAXZAX"L11"5AXZ OhNmkmNm!oNmr"5">">r"BNm!o 8E7J7JL7Jh''+7JL WhVmkmVm!oVmr"="F"Fr"JVm!o 6C5Hb5HJ5Hqh''*5HJ WsVxvxVx%zVxr&=&F&Fr&JVx%z * &>! ""# (#IXA"jMiZ!oL!oJ%zsH:^0"^5 ^:2^?__ *__:_"_ _"2_'datac$t}t|tdddd}t}g} t ddd}d|_|j ||j tdd td |d d d dd}|j td||j tdd td|dddd d}|j td|ddgd|jjgd|jjgd|jjgg} t| } | jt!ddddd d!d"t"j$fd#d$g|j | |j tdd |j td%||j&D]} d&| j(gd'| j*gd(| j,gd)| j.gd*| j0gd+t3| j4gd,t3| j6gd-| j8gg} t| } | jt!dd.ddd d!d"t"j$fd#d$g|j | |j tdd/|j td0||j:D]}d1|j<gd2|j>gd3t3|j@gd4|jBgd'|j*gd5|jDgd6|jFgd7|jHgd8|jJgd9|jLgg }t|}|jt!dd.ddd d!d"t"j$fd#d$g|j ||j tdd/|jNr |j td:|gd;}|g}|jND]p}|j |jL|jPt3|jRt3|jTt3|jV|jXgrt|}|jt!ddd}|g}|jZD]p}|j |jL|j\t3|j^t3|j`t3|jV|jXgrt|}|jt!ddddl|>}?tjtjj|?dmnt|?do5}@|@j|jdpdpdp|?S#YxYw#1swY|?SxYw)qz=Generate comprehensive PDF report with all JSON response data)pagesize leftMargin rightMargin topMargin bottomMarginz TS Logo.pngK)widthheightLEFT CustomTitleHeading1Helvetica-Bold)parentfontSize spaceAfter alignmentfontNamezModule 1: Complete Report Data SectionHeaderHeading2 )rrr spaceBeforerzBrand InformationFieldValuez Brand Namez Brand Image Rationale)ALIGNrrrr)FONTNAMEr)rrr)FONTSIZErrGRIDrrg?)VALIGNrrTOP)WORDWRAPrrTSegmentsz Segment NameLocationzChief Wage Earner OccupationzMale EducationzFemale Educationz ISEC ValuezTotal PopulationzAdditional Details)rr)rrrrz Store Formatsz Store NamezStore Name Rationalez Store Size MerchandisezAdditional Location ParameterszService ParameterszTechnology AdoptionzOther ParametersStore Format Typez Civil Work)rzType of Civil Workz Rate Per Sqftz Total SqftTotalRemarks)rrrzDisplay Racking Units)rzType Display Racking UnitzNumber of Units Cost Per Unitrrr))rTypeUnitsrrr) LEFTPADDINGrr) RIGHTPADDINGrrr) TOPPADDINGrrr) BOTTOMPADDINGrrrzElectrical Cabling)rFeatureDetailszRate Per Sqft/UnitrrzDisplay Boards)rrSizez Pricing Typez Cost RaterrrzCommercial Equipment)rzType of EquipmentrrzEquipment Typerr)rrrrr-)rrCategoryrrrzAvailable CapitalzVisual Merchandising)rrCostrzInternal DisplayzExternal DisplayzFrequency Change/Yearr/)rrrrrzAdditional Installations)Name Descriptionrz Total CostrzCapital Expenses SummaryzStore Format A Capital Excl ITzRs. z,.2fzStore Format A IT CapitalzStore Format A TotalzStore Format B Capital Excl ITzStore Format B IT CapitalzStore Format B TotalzAdditional Remarksz Key TakeawayszDepreciation Informationz SLM Yearsz SLM Remarksz Other MethodszDepreciation MethodzLast Updated: z%Y-%m-%d %H:%M:%SNormalrz %Y%m%d_%H%M%Smodule1_complete_report_group__z.pdfzuploaded_files/T)exist_okwbN)hrrrrr hAlignappendr rr r_ brand_name brand_image rationaler setStyler rblackr` segment_namelocationchief_wage_earner_occupationmale_educationfemale_educationrJ isec_valuetotal_populationadditional_detailsra store_namestore_name_rationale store_size merchandiseadditional_location_parametersservice_parameterstechnology_adoptionother_parametersrHrbtype_of_civil_work rate_per_sqft total_sqftroremarksrctype_display_racking_unitnumber_of_units cost_per_unitrdtypeunitsrefeaturedetailsrate_per_sqft_or_unitrfsize pricing_type cost_ratergtype_of_equipmentequipment_typerhcategoryavailable_capitalricostinternal_displayexternal_displayfrequency_change_per_yearrjrkname descriptionrUrmrWrXrYrZr[r\r]r^rlrCrE other_methodsrDrnstrftimebuildseekrrzr=osmakedirspathdirnameopenwritegetvalue)Ar9rbufferdocstylesstorylogo title_style section_styler| brand_tablesegmentseg_data seg_tablestore store_data store_table civil_headers civil_rowsrb civil_table rack_headers rack_rowsrack rack_table carp_headers carp_rowscarp carp_table elec_headers elec_rowselec elec_table disp_headers disp_rowsdisp disp_table comm_headers comm_rowscomm comm_table it_headersit_rowsrit_table vm_headersvm_rowsrvm_table plumb_headers plumb_rowsplumb plumb_table add_headersadd_rowsadd add_table capex_data capex_tabledep_data dep_table timestampfilenamefilepathfsA r:_generate_pdf_reportz)Module1ReportService._generate_pdf_reports PR^`oqr$& c"=D DK LL  LL2 ' %]6*;MXZgiuvBRS  Y?MN VAr]#&vj?Q\^klz|HXY   Y2MBC(<9N9N*OR_aeakakawawQx|GIMISISI]I]{^_ J' Z)LN}@adjlrt|~ACICOCOcPRuw[)\] ^ [! VAr]#  Yz=9:}}G')=)=>WM]M]@^aBIBfBfagjz|C|R|RiSVhjqjBjBUCFRTWX_XjXjTkEloACFGNG_G_C`nadxzAzTzTcUVHhI   z+NPBcflntv~@CEKEQEQeRTwy]+^ _ ` LL # LL1 & %  Y >?''E')9)9:=SUZUoUo> LL; > ?fL%I  $"8"8$))S_VYZ^ZlZlVmorsws}s}o~AEAMAM"NO'y)J    3?13 =344536 , !  LL $ LL2 '  " " LL#7G HpL%I//  $"8"8$,, VYZ^ZtZtVuwz{|F|FxGIMIUIU"VW0y)J    3?13 =344536 , !  LL $ LL2 '    LL#3]C DzL%I++  $"8"8$))S^UYUfUfhklplzlzh{~ABFBLBL~MORSWS]S]O^`d`l`l"mn,y)J    3?13 =344536 , !  LL $ LL2 '  $ $ LL#9=I JFL%I11  $"8"8$:P:PRUVZV`V`Racfgkgygycz}A}P}PRUVZV`V`Racgcoco"pq2y)J    ,ORACdgmouwADFLFRFRfSUxz^,_!` a LL $ LL2 ' == LL:}= >zJ!lGmm 4 4bggr{{CPRPXPXM[^_a_o_o[pruvxv~v~rBEFHFZFZB[ \]$W~H   j*MO~Abekmsu}BDJDPDPdQSvx\*]^ _ LL " LL2 '  $ $ LL#9=I J|J!lG//RXXBGG c"((mUWUhUhjlj}j}@CDFD`D`@a bc0W~H   j*MO~Abekmsu}BDJDPDPdQSvx\*]^ _ LL " LL2 ' == LL:}= >RM'J!!5::s5;;/?UEXEXAY[^_d_j_j[kmrmzmz"{|' +K  -PSBDehnpvx@BEGMGSGSgTVy{_-`"a b LL % LL2 '  ( ( LL#=}M N[K#}H443??C@Q@QO>O>Y>Y:Z,[^kmqm~m~nKnK^LO^`d`q`q``N@CXZ^ZkZkZZB@AHhI   z+NPBcflntv~@CEKEQEQeRTwy]+^ _ ` LL #  VAr]# Y0A0A0J0JK^0_/`acijrcstu % ALLN++O< 3DMM?!I;dS$XJ/ BGGOOH-= (D !Q GGFOO% &"{  r"sAAI H! AII AIIAIcn|j|}|j|}|j|||S)z3Generate PDF and save to database, return file path)rrZ_save_file_path_to_db)r9r=r file_paths r:generate_and_save_pdfz*Module1ReportService.generate_and_save_pdfs8..x8 --k:  ""8Y7r<r]c 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_m1z6DEBUG: 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_moduploaded_filesz+DEBUG: Created new record with summary_id: z$ERROR saving file path to database: rN)rvr6rqr"rrrbrsrccommitrefreshrP summary_id Exceptionrollback traceback print_exc)r9r=r]rbexisting_summary new_summaryeris r:r\z*Module1ReportService._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~!" &]]D$ :**.8*F2C9G1P0R8;(P"P"r<