
    7h                     4    d dl mZmZmZmZmZ  G d d      Zy)   )Module10RequestModule10ResponseMetricValueYearlyIncreaseOverviewc                   8    e Zd ZdZd	dZdedefdZdedefdZ	y)
Module10ServiceWorkingz0Working Module 10 service with real Excel valuesNc                     || _         y N)db)selfr   s     O/var/www/html/retail-simulation-api/app/api/module10_metrics/service_working.py__init__zModule10ServiceWorking.__init__   s	        requestreturnc                 l  K   t        ddd      t        ddd      t        ddd      t        dd	d
      t        ddd      t        ddd      t        ddd      t        ddd      t        ddd      d	}i }|j                         D ]  \  }}|j                  |j                  |j                  }}}|dk7  r||z
  |z  dz  nd}	|dk7  r||z
  |z  dz  nd}
|dk7  r||z
  |z  dz  nd}t        t        |	d      t        |
d      t        |d            ||<    g }|j                         D ]T  \  }}|j                  }|dkD  r|j                  | d| d       /|dk  s5|j                  | dt        |       d       V t        t        |      |dddd       }t        d!g d|||"      S w)#z?Calculate metrics using real Excel values from your screenshotsg     r@g     |@g     ˻@)Y1Y5Y12g     7g     g     g     @g    @g    D@g      ]@g      @g     @g     Ag    Ǿ=Ag     R@g        g     )	SaleszGross MarginzTotal IncomezOperating ExpenseszNumber of Physical StoreszNet Sales per Day- Rsz,Net Sales per Day Per Sqft (Retail Area)- Rsz!Breakeven Sales (Net) Per day- Rsz
EBITDA (%)    d      )Y1_to_Y5_growthY5_to_Y12_growthOverall_Y1_to_Y12_growthz: Strong growth of %iz: Significant decline of z3Initial performance established with 300 Lacs salesz.Mid-term growth achieved with 2,015 Lacs salesz.Long-term target reached with 7,115 Lacs sales)Y1_baseline
Y5_midtermY12_longterm)total_metrics_analyzedkey_insightsperformance_summaryz+Module 10 - Metrics and Performance Indexes)moduleyears_analyzedmetrics_valuesyearly_increasesoverview)r   itemsr   r   r   r   roundr   appendabsr   lenr   )r   r   metrics_datar(   metric_namemetric_valuey1y5y12y1_to_y5	y5_to_y12overallr#   metricgrowthoverall_growthr)   s                    r   calculate_metricsz(Module10ServiceWorking.calculate_metrics	   s    
 !Ef&A'8	yQ'8	yQ"-G"R)4%U)S%0Gi%X<G4TW]`<a1<QT1U%W'J

 )5););)=%K&//<??L<L<LCB13qbB,aH357#(b3.I13qbB,aG,: %h 2!&y!!4).w):-[) *> .446NFF#<<N###vh.A.AQQR$ST#%##vh.GNH[G\\]$^_ 7 #&|#4%TN P!
  @.'-
 	
s   E"F4%AF4simulation_idc                 Z   K   ddl m}  |       }| j                  |       d{   S 7 w)zBCalculate metrics using simulation ID (same as direct calculation)r   )r   N)schemar   r;   )r   r<   r   r   s       r   calculate_from_simulationz0Module10ServiceWorking.calculate_from_simulationC   s*      	,!#++G4444s   "+)+r   )
__name__
__module____qualname____doc__r   r   r   r;   intr?    r   r   r	   r	      s3    :8
 8
CS 8
t5S 5EU 5r   r	   N)r>   r   r   r   r   r   r	   rE   r   r   <module>rF      s    \ \E5 E5r   