G /iTHddlmZddlmZddlZddlZddlmZddlm Z ddl m Z ddl m Z ddlmZmZdd lmZmZmZmZmZmZdd lmZdd lmZdd lmZdd lmZm Z ddl!m"Z"ddl#m$Z$ddl%m&Z&ddl'm(Z(ddl)m*Z*ddl+m,Z,ddl-m.Z.m/Z/m0Z0m1Z1m2Z2m3Z3ddl4m5Z5GddZ6y)) HTTPException)SessionN)datetime)BytesIO)A4)colors)getSampleStyleSheetParagraphStyle)SimpleDocTemplate ParagraphSpacerTable TableStyleImage)TblNetworkPlanning)TblTradingMonth)TblPreOperatingExpense) TblSummary SummaryBase)TblGroup)TblCivil) TblInfoTech)TblRentExpenses) TblUtility)TblStoreLevelStaffNeeds)NetworkPlanning TradingMonthsPreOperatingExpensesStoreInvestmentSummaryModule3SummaryModule3ReportPreview)JWTPayloadSchemacleZdZdedefdZdedefdZdede fdZ dede fd Z dede fd Z ded e fd Zy )Module3ReportServicedbtokenc ||_||_y)N)r%r&)selfr%r&s ?/var/www/html/retail-simulation-api/app/api/module_3/service.py__init__zModule3ReportService.__init__%s group_idreturnc K|s tdd|jjtj |j xs||jjt j |j xs=|jjtj |j }|r|jjtj |j}|jjt j |j }|jjtj |j }|jjtj |j }|jjtj |j}|jjtj |j}|jjtj |j} |jjtj |j} |jjtj |j} |j||||| | | } t!||D cgc]} t#di| j$c} xs t#g|rt'di|j$n t'|rt)di|j$n t)| |rt+di|j$n t+t,j.j1S|jjt2j |j }|rat!|t#|gt'|t)|t5|t+|t,j.j1Stddcc} ww) Nizgroup_id is required) status_codedetailr,)r,network_planningtrading_monthspre_operating_expensesstore_investment_summarysummary last_updatedizGroup ID not found in database)rr%queryr filter_byfirstrrallrrrrrr _create_store_investment_summaryr!r__dict__rrr pd Timestampnowrr)r(r,module_data_existsnetwork_recordstrading_recordpre_operating_recordsummary_record civil_datait_data rent_data utility_data staff_datastore_investmentn group_existss r)_fetch_module3_dataz(Module3ReportService._fetch_module3_data)sxC8NO O GGMM, - 7 7 7 J P P R W GGMM/ * 4 4h 4 G M M O W GGMM0 1 ; ;X ; N T T V  "ggmm,>?IIS[I\``bO!WW]]?;EExEX^^`N#'77==1G#H#R#R\d#R#e#k#k#m !WW]]:6@@(@SYY[Nx0::H:MQQSJggmmK0::H:MQQSG o6@@(@SWWYI77==4>>>QUUWL'>?IIS[I\``bJ $DD. GYP\^h  (!IX!YA/"?AJJ"?!Y!p^m^o]pKY}G~/F/FG_l_n`t';'\>R>[>['\{O{Q)9ESA)@)@AYgYi\\--/  77==2<|_ |jB|_"|jF|_$|jJ|_&|jN|_(|S) z6Create store investment summary from cross-module datar1c8tfd|xsgDS)Nc 3pK|]-}tt|ddvrt|dxsd/ywstore_format_typerN)strgetattr).0itemattr fmt_letters r) z`Module3ReportService._create_store_investment_summary..sum_for_format..hsA,DWT3F%K!LLtQ',1,,s36sum) data_listr[rZs ``r)sum_for_formatzMModule3ReportService._create_store_investment_summary..sum_for_formatgs#&_"_ r+c4tfd|xsgDS)Nc 3K|]=}tt|ddvr#|jxsd|jxsdz?ywrS)rVrW rate_per_sqft total_sqft)rXrYr[s r)r\zfModule3ReportService._create_store_investment_summary..sum_civil_for_format..osI,DWT3F%K!LL$$)doo.BC,sAAr])r_r[s `r)sum_civil_for_formatzSModule3ReportService._create_store_investment_summary..sum_civil_for_formatns#&_"_ r+ABrUr)total))rcapital_expenses_acapital_expenses_bit_capital_expenses_ait_capital_expenses_brVrTrental_advance_amountrental_advance_arent_per_monthrent_per_month_arental_advance_brent_per_month_b utilities_acost_per_month utilities_baverage_salarycountstore_formate_typeemployee_wages_aemployee_wages_bmarketing_expenses_store_amarketing_expenses_amarketing_expenses_store_bmarketing_expenses_bpre_operating_months_store_apre_operating_months_apre_operating_months_store_bpre_operating_months_b#calculated_pre_operating_expenses_apre_operating_expenses_a#calculated_pre_operating_expenses_bpre_operating_expenses_b#calculated_total_capital_expenses_atotal_store_capital_expenses_a#calculated_total_capital_expenses_btotal_store_capital_expenses_b#calculated_total_store_investment_atotal_store_investment_a#calculated_total_store_investment_btotal_store_investment_b)r(r,rErGrHrIrJrKrLr`rerentutilitystaffwages r)r=z5Module3ReportService._create_store_investment_summarycs18D  /C:s.S+.B:s.S+1?1M.1?1M.Dc$006B77484N4N4SRS 1484G4G4L1 1D228b99484N4N4SRS 1484G4G4L1 1 $Gc'339r:: ,,0F0F0K!K,G55;<< ,,0F0F0K!K, $ E((-A%++2BCDc%228b99 11T91E44:;; 11T91   4H4c4c4hgh  14H4c4c4hgh  16J6g6g6lkl  36J6g6g6lkl  39I8l8l  58H8l8l  5>N>r>r  ;>N>r>r  ;8H8l8l  58H8l8l  5r+datact}t|tdddd}t}g} t ddd}d|_|j ||j tdd td |d d d dd}|j td||j tddtd|ddd d}|j td||jrPgd} | g} |jD]} | j t| jxsdt| jxsdt| jxsdt| jxsdt| j xsdt| j"xsdt| j$xsdt| j&xsdt| j(xsdg t+| } | j-t/ddddddd t0j2fd!d"g|j | |j tdd#|d$} d%| _d&| _|j td'||j tdd td(| td)| td*| td+| g}tt|j8j:xsd| tt|j8j<xsd| tt|j8j>xsd| tt|j8j@xsd| g}||g}gd,}t+||d-}|j-t/dddd t0j2fd.dddt0j2fdd/d0d1d2d3d4d5d!dg |j ||j tdd#|d$}d6|_d7|_|j td8||j tdd td9|td:|td;|td<|td=|td>|td?|td@|g}tt|jBjDxsd|tt|jBjFxsd|tt|jBjHxsd|tt|jBjJxsd|tt|jBjLxsd|tt|jBjNxsd|tt|jBjPxsd|tt|jBjRxsd|g}||g}t+|dA}|j-t/dddd t0j2fd.dddt0j2fddBd0dCdDdEdFdGd!dd"g |j ||j tdd#|j tdH|gdI}|g}|j dJt|jTjVxsdt|jTjXxsdg|j dKt|jTjZxsdt|jTj\xsdg|j dLt|jTj^xsdt|jTj`xsdg|j dMt|jTjbxsdt|jTjdxsdg|j dNt|jTjfxsdt|jTjhxsdg|j dOt|jTjjxsdt|jTjlxsdg|j dPt|jTjnxsdt|jTjpxsdg|j dQt|jTjrxsdt|jTjtxsdg|j dRt|jTjvxsdt|jTjxxsdgt+|}|j-t/dddSdddd t0j2fd!d"g|j ||j tdd#|j tdT|dUdVgg}|j t|jzj|xsdt|jzj~xsdgt+|}|j-t/dddSdddd t0j2fd!d"g|j ||j tdd |j tdW|jjdX|d$|j||jdtjjdY}dZ|jd[|d\}d]|}tjtjj|d^_t|d`5}|j|jdadadatjjdb|S#Y xYw#1swY1xYw)cz%Generate PDF report from Module3 data2)pagesize leftMargin rightMargin topMargin bottomMarginz TS Logo.pngK)widthheightLEFT CustomTitleHeading1Helvetica-Bold)parentfontSize spaceAfter alignmentfontNamezModule 3: Network Planning SectionHeaderHeading2)rrrrzNetwork Planning) LocationStatezTotal HHz Target HHAreaActionz Format A Y5z Format B Y5zTotal Stores Y5zN/Ar)ALIGNrrrr)FONTNAMErrrr)FONTSIZErrGRIDrrg?)VALIGNrrTOP)WORDWRAPrrTNormal zTrading MonthszStore A
Trading
MonthszStore B
Trading
MonthszRationale Store AzRationale Store B)<rr) colWidths repeatRowsBOX)rrrr)rrrr Helvetica)rrrr) LEFTPADDINGrr) RIGHTPADDINGrrr) TOPPADDINGrr) BOTTOMPADDINGrrrg@zPre Operating Expensesz(Pre
Operating
Months
Store Az(Pre
Operating
Months
Store Bz"Marketing
Expenses
Store Az"Marketing
Expenses
Store BzAccounting Benefits
Store AzAccounting Benefits
Store BzOther Remarks
Store AzOther Remarks
Store B)r)rrrr)rrrr)rrrr)rrrr)rrrr)rrrrzStore Investment Summary)FieldzStore Format AzStore Format BzCapital Expenses AzIT Capital ExpenseszRental AdvancezRent Per Month UtilitieszEmployee WageszMarketing ExpenseszPre Operating MonthszTotal Store Investment)rrrrSummaryzNetwork SubmissionszNetwork SummarisezLast Updated: z%Y-%m-%d %H:%M:%Sz %Y%m%d_%H%M%Smodule3_complete_report_group__z.pdfzuploaded_files/T)exist_okwbNuploaded_files)Orr rr rhAlignappendr r r r2rVlocationstatetotal_hh target_hhareaaction format_a_y5 format_b_y5total_store_count_y5rsetStylerrblackrleadingr3store_a_trading_monthsstore_b_trading_monthsrationale_for_store_arationale_for_store_br4rrr{r}accounting_benefits_store_aaccounting_benefits_store_bother_remarks_store_aother_remarks_store_br5rirjrkrlrnrqrprrrsruryrzr|r~rrrrr6network_submissionsnetwork_summariser7strftimebuildseekrrAr,osmakedirspathdirnameopenwritegetvaluejoin)r(rbufferdocstylesstorylogo title_style section_stylenetwork_headers network_rowsnetwork network_table normal_styleheadersrow table_data column_widths trading_tablepre_op_normal_style pre_op_tableinvestment_headersinvestment_rowsinvestment_table summary_data summary_table timestampfilenamefilepathfs r)_generate_pdf_reportz)Module3ReportService._generate_pdf_reports) PR^`oqr$& c"=D DK LL  LL2 ' % *%%    Y;[IJ VAr]#' *%%    Y1=AB  PO+,L00##((1E2 ./((-A.)).Q/ )*/%0++0q1++0q1449: % 1",/M  " ":3?13 =34 /$  LL ' VAr]#h' !   Y/?@ VAr]# 6 E 6 E )< 8 )< 8   c$--DDMNP\ ] c$--DDMNP\ ] c$--CCLuM| \ c$--CCLuM| \  s^ * jMaP z VXsFLL 9 FHa 6 ; , 7 - 0 1 / 2 / / +   ]# VAr]#%X.'*$&'# Y7GH VAr]# @BU V @BU V :[>[>>?EDE;FHKLPLiLiLMLMLRQRHS T U 1!!* / ; - VXsFLL 9 / 0 . #    %& VAr]#  Yy-89.0CDE S!A!A!JUKSQUQ]Q]QoQoQxsxMyz{l+ z / ; - VXsFLL 9 / 0 +     ]#  VAr]# Y0A0A0J0JK^0_/`acijrcstu % ALLN++O< 3DMM?!I;dS$XJ/ BGGOOH-= (D !Q GGFOO% &"ww||,h77a  X" !sAp4, p<4p9<qcK|j|d{}|j|}|j|||S7)w)z3Generate PDF and save to database, return file pathN)rOr_save_file_path_to_db)r(r, report_data file_paths r)generate_and_save_pdfz*Module3ReportService.generate_and_save_pdfsD 44X>> --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_m3z6DEBUG: 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%r9rfilterr"r;rcommitrefreshadd summary_id Exceptionrollback traceback print_exc)r(r,rr"existing_summary new_summaryer+s r)rz*Module3ReportService._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 rHs_!" & D]];:I;**19.K;B"B"r+