ѳja > U d dl mZmZmZmZ d dlmZ d dl mZmZmZ d dlm Z d dl
m Z d dl Z d dl m
Z
mZmZmZmZmZmZ d dlmZmZ d d lmZ d dlZd dlZeee ef Z ee d
< d d d
ddddddd ddddddddgZ dd d dd d dd d dd d d d d dd d dd d dd d d dd!dd"d dd d#dd$d d%dd ddd!dd&d d'dddd d dd(d d)dddd*d dd ddd+d d,dddd*d dd ddd-d d.dddd*d dd ddd/d d0d1ddd*d dd ddd2d d3d4d5ddd!dd d6dd7d d8d4d9ddd:dd d;dd<d d= Z G d> d? Z! G d@ dA Z" G dB dC Z#dDe$fdEZ%dDe$fdFZ& G dG dHe Z' G dI dJe Z( G dK dLe Z) G dM dNe Z* G dO dPe Z+ G dQ dR Z, G dS dTe Z- G dU dVe Z. G dW dX Z/ G dY dZe Z0 G d[ d\e Z1 G d] d^e Z2 G d_ d`e Z3 G da db Z4 G dc dd Z5 G de dfe5 Z6 G dg dhe Z7di Z8dje9fdkZ:dldiZ;y)m )OptionalAny TypeAliasSelf)cached_property)r r Generator) defaultdict)sessionN)DebugIODatemisfgetJSON)Modelrow)DecimalRowsz'Run down building in a bad neighborhoodzNo heat but there's plenty of holes in the wall so build in air conditioning. Your employees are not going to like this but it's cheap. - $5,000 / QuarterLowi )titledetailvalueeffectcostz An old house on the edge of townzStructurally sound building and it even has a kitchen. It's awfully cramped but could be worse - $10,000 / QuarterMediumi' zLease a brand new buildingzPlenty of space and state of the art facilities. Mass transit right to the front door and a built in gym. Employees will be beating your door down to get a job here. - $20,000 / QuarterHigh i N zXYou need a new plant manager for your factory. Choose from the following top candidates)r pr_effect)zExpecting Mom - Age:27 - Very talented women with great credentials and job experience. She just found out she is expecting so she will need maternity leave in the near futurezThe Pro - Age 57 - Top of his class at the Wharton Business School. He has short stints at a ton of great companies but they all love himzHome Grown - Age 26 - Started at the company straight out of high school. Steady, on time, very dependable but with no management experience. descriptionoptionszDo you feel your business reflects your ethical beliefs? Would you have made different decisions if the employees were your family / friends?)z*Yes, I would love to work at this company!zVMiddle of the road. We tried to do the right thing for our customers and shareholdersz)No, we wanted to win so we were ruthless!u~ Marketing
You need donations for a silent auction but don’t shop downtown or patronize any local stores.
i)zWrite it in to your budgetz.Give your employees a stipend to spend locallyz0Continue to shop from larger brands saving moneyzvYour company plans to build a new distribution center that promises jobs but would displace a low-income neighborhood.)zDo you proceed for growthzGChoose an alternative site at higher cost but less community disruptionzMarketing
A popular but polarizing influencer offers to promote your brand for a significant fee. They have a large following but a history of public controversy.)z.Gamble and accept the partnership for exposurez0Distance your brand to avoid potential backlash?zXYour employees are complaining about substandard working conditions. How do you respond?i )z(Undergo massive updates of your facilityzBPut in the bare minimum repairs to keep employees from complaining
Do nothingzVYour new line has dropped and you have been informed there was a manufacturing defect.)z You recall the defective phonesz'You offer free fixes on all your phonesr& z
Human Resources
Your employees are using too many sick days to take care of their children. Production is suffering.)z(Provide a comprehensive day care packagez Provide a stipend for daycarer& zCongratulations! You have built a brand-new facility for your Company. Unfortunately,you had to remove 300 trees to make space for your building. How do you respond?i@ )z6Plant 300 trees on a different section of the propertyz Plant a portion of the treeszReplant zero treeszThe train carrying your shipment of batteries has derailed and caught fire. You have a potential environmental disaster on your hands.iP i)z*Clean it up and make it better than it wasz7Hire crisis management firm to blame it on someone elsezLPretend it didn't happen. Looks normal to me, trees always glow in the darkzA pandemic is spreading the globe. People are reluctant to leave their houses and there are supply shortages of all your components2 i)z*Allow your employees to stay home with payzTake reasonable precautions (Social Distancing, Hand Sanatizer,etc) and add extra shifts to reduce the number of people working at the same time. Production will take a hitz&It's just a cold. We can tough it out) ManagerEthicsAuctionInfrastructure SocialMedia
Conditions
ProductionDaycare
Deforestation
EnvironmentalPandemicc e Zd Zd Zy)Adminc t j j d xs g t j xs g dS )Nr# )OverheadDilemas)r8 r# getDilemmasselfs /var/www/bsim/io/app.pyr# z
Admin.options s= j "&&y17R
Z
!
'R
N)__name__
__module__ __qualname__r# r? r> r6 r6 s r? r6 c 2 e Zd ZdedefdZdedefdZd Zy)r8 keyreturnc ~ t D ]4 }|j dd |k( st |j dd c S y)Nr r r OVERHEADr: r r= rE items r> r z
Overhead.cost s? !d
hhwrc! TXXfQ
!
r? c ~ t D ]4 }|j dd |k( st |j dd c S y)Nr rH r r rI rK s r> r zOverhead.value s? #d
hhwrc! TXXhq
! ""#
r? c dt iS Nr# )rJ r< s r> r# zOverhead.options s
H r? N)r@ rA rB strintr r r# rC r? r> r8 r8 s- 3 3 C C r? r8 c e Zd ZU eed< dedefdZdefdZdededefd Z dedede
fd
Z d edefd Z defd
Z
defdZd Zy)r; errordatarF c 8 t | dkD r t | S g S Nr )lenr r= rT s r> fromJSONzDilemmas.fromJSON s Yq[
$- 8r? namec L t j |i j d S )Nr" )DILEMMASr: r= rZ s r> r" zDilemmas.description s d2 " "= 11r? dilemmaactionc 8 t t j |i j di j |i j d S # t $ r@}d| d| dt | | _ t
d| d| t d cY d }~S d }~ww xY w)Nr# r Trouble getting Dilemma cost ->
r r )r
r\ r: ExceptionrP rS r r= r^ r_ es r> r z
Dilemmas.cost s
HLL $ ( (2 6 : :6" E I I& Q
RR /yVHCAxP4:.witF8DE
A$; A
A B5BBBc 8 t t j |i j di j |i j d S # t $ r@}d| d| dt | | _ t
d| d| t d cY d }~S d }~ww xY w)Nr# r ra rb rc rd r )r r\ r: re rP rS r rf s r> prz Dilemmas.pr s
HLL $ ( (2 6 : :6" E I I+ V
WW /yVHCAxP4:.witF8DE
A$;rh dilemmasc N g }t | xs g D ] }t j |i j d i d}t j |i j di j D ] \ }}||d |< |d | d= |j | |S # Y 3xY w)Nr" r! r# r )r r\ r: itemsappend)r= rk allr^ rT optionvals r>
mk_quarterzDilemmas.mk_quarter s
#"(b g! gb155mDr
R4 \\'"-11)B?EEG
zvc !DOF
i -
::d
*
s B B$c i }t j |i j di j D ] \ }}|||< |d= |t j |i j d dS # Y =xY w)Nr# r r" )r# r" r\ r: rm r= rZ rT descrq s r>
client_optionzDilemmas.client_option
s~ $,,tB'++Ib9??A hd34: K x||D'<'@'@ 'O PP s A00A4c i }t j |i j di j D ]
\ }}|||< |S rO rt ru s r> rp zDilemmas.option sI $,,tB'++Ib9??A hd34:
+r? c g }t j D ]( \ }}|j |j d |d * |S )Nr" r r )r\ rm rn r: )r= rT rZ r s r> r# zDilemmas.options sH $ ^^% kd6;; JJ} %
+r? N)r@ rA rB rP __annotations__listrY r" r r rQ rj rr rw rp r# rC r? r> r; r; s
23 2s # ' S
c
d
QS Qc r? r; rF c t d d xs dS # t $ r.} t d| t dt d d Y d } ~ yd } ~ ww xY w)NUser Business_ID Trouble getting session userr rT zSession Businessr
re r rg s r> getBusIDr $ sM ' -2- ,!4 gfom&DE s A $AA c t d d S # t $ r+} t d| t dt d Y d } ~ yd } ~ ww xY w)Nr~ IDr r z Session Userr r r s r> getUserIDr , sB ,!4n'&/2 s A!=Ac j e Zd ZdZdedefdZdedefdZd Z de
defdZ d efd
Z def fd Z
xZS ) Global_SettingsGlobalqualityrF c i }t }t |j | d }|dz }dt |dz dt |dz |d< d|d iS )N
_Median_Priceg?$z - $g333333?price)r r get_valuer )r= r rT settingsr bottoms r> summaryzGlobal_Settings.summary7 sk $
(
H '- 8 9
:% 3;&a o&d1UT\?*;<$w-
$w- r? c | j }|j | x}r|j d S t d S )Nr )
median_pricesr: r )r= r pricesrL s r> median_pricez Global_Settings.median_price? s= &
ZZ
T
((7
$-r? c | j }|j d |j d |j d dS )NLow_Median_PriceMedium_Median_PriceHigh_Median_Price)r r r )cacher: rX s r> r z Global_Settings.median_pricesG s>
$
$ % HH* +
((&
'
r? r c | j | _ | j j d|g | j S NID=%squeryparmsqb_initqbfilter
select_oner= r s r> r: zGlobal_Settings.getO 2 LLN$'''..wbT.*
r? rE c | j | _ | j j d|g | j xs i }|j dd S )Nz`key`=%sr r rH )r r r r r: )r= rE ds r> r zGlobal_Settings.get_valueT sG LLN$'''..z..
oo 2!
wr r? c $ t | d S )NrE field)superr )r= __class__s r> r zGlobal_Settings.cacheZ s U ##r? )r@ rA rB tablerP dictr r r r rQ r: r r
__classcell__r s @r> r r 4 sc !# !$ !s w
$D $ $r? r c H e Zd Zd dedefdZedefd ZdededefdZy)
Business_Item
manuf_coefrF c J ddl m} t j } t |j | j dd i j d xs d }|t |dz z } ||dz S # t $ r }t d |
|d cY d }~S d }~ww xY w) Nr r
QualityrH r r d zTrouble getting Units Pricer i )Utilsr
r r r r: re r )r= r r
r r rg s r>
cost_per_unitzBusiness_Item.cost_per_unit^ s * * ,&
FJJtxx "-b 1 5 5g > D"
E41Z^ 4
DF) ,&9
C&=s AA: : B"B B" B"c | j d }t | j d }t | j d }t t j | d }t |dz }t t | j d |z }||z }|S # t $ r!}t d| Y d }~t d S d }~ww xY w)
Nr CapitalLoanr UnitszTrouble with total valuer r ) r: r
r r r r re r r ) r= r capitalloanmedianavg_valunit_valtotalrg s r> total_valuezBusiness_Item.total_valuek s 2
XXi
7
txx "
#7
DHHV
4
o ))WI]*CD E6
vax[7$((7#$w./8 x 5
< 2)q11 2s B$B' ' C0
C Crevexpensesc j t | j dd }t ||z |z
| d< | d S )Nr r r )r
r: )r= r r r s r> calc_capitalzBusiness_Item.calc_capital| s8
488F4 !$s4x)*$y/
i r? N)r ) r@ rA rB rQ r r propertyr r rC r? r> r r ] sJ 3 w ' 7 G r? r c e Zd ZU dZeed< d ZdZdedede fdZ
dedede de fd Z defd
Z d ede
fd Zddedee de
fdZdefdZd ede
fdZy
)Business id
Business_itemunitsr rF c d}t t j | d }t |dz }||z }t | S )Nr r r )r r r r
)r= r r rq r r s r> inventory_valuezBusiness.inventory_value sE # _
(
(G9M)B
C D&
fQhK'
#
3-r? r c p | j || }t ||z dz S # t d cY S xY w)N)r r O r )r r
)r= r r r inv_values r> calc_stock_pricezBusiness.calc_stock_price sA ##E'#B9
Y
E )
**
A$;s #&
5c t }t |j d xs d }d}| j D ]C }||d< ||d< d|d< d|d< d|d< | j | | j | dk sBd}E |S ) NInitial_Capitalr r r r PR_Scorer Stock_Price)r r
r ro update)r= gdatar statusbuss r> resetzBusiness.reset s
%
5??, - 2 3$ &
XXZ c3y>3v;3z?3w<3};;s
kk#
F
-r? r c | j | _ | j j d|g | j }i }|rt | }|j |d< i |d< t
j dt j | }d}t j D ]A }|j dd }||d |< |j |i j d xs d}C |S )
Nr r unit_cost
employee_list
Quarter_IDr r rH employees)
r r r r r r r group_byQuarters get_businessQuarter_Settingsactiver: )r= r r r plansprevsettingqids r> r: z Business.get s LLN$'''..wbT.* #
# s 3'')3{ 3 >>,xz'>'>r'B C5
4"$++- 3w
++d2
C $C 99S - 2D3
*r? Nr r c i }| j | _ |r | j j || | j D ] }|||j d < |S )Nr r )r r r selectr: )r= r r r rT r s r> r zBusiness.cache sW $ LLN$'
77>>E>*
[[] c 4
+r? c g }| j D ]? }t j |j d |d< |j | A |S )Nr r Quarter_Plan)ro r r r: rn )r= r r s r> detailszBusiness.details sP !
XXZ c!00SWWT]0K3~88C=
(r? c d | j | }t j | |d< |S )Nr r r )r: r r )r= r r s r> r zBusiness.detail s0 B#
//B/?#n *r? )r rH N)r@ rA rB r rQ r{ r row_clsrP r r r r r r: r r| r r r rC r? r> r r s
C C G S W
C
( htn d d
C
D
r? r c e Zd ZU dZeed< d ZdedefdZde defdZ
defdZ d edefd
Z defd Z
dd ed e defd
ZdefdZdefdZde dee defdZdefdZdde dee defdZy)r r r r rF c | j | _ | j j d|g | j S r r r s r> r: zQuarter_Settings.get r r? rZ c | j | _ | j j d|g j d | j xs i S )NzName=%sr 1)r r r limitr r] s r> get_namezQuarter_Settings.get_name sB LLN$'''..yv..44S9
b r? c | j | _ | j j ddi | j S )NActiver rT )r r r executer< s r>
deactivatezQuarter_Settings.deactivate s1 LLN$'''..xl.#
r? bus_idc 8 | j | _ i }| j D ] } |j d } |j d }t d| t j
| }|||< t j |j d || d< t j || d< | j || || d < d
|| d < t j |j d d
|| d< |S )NNamer z bus summaryr r r; Overhead_Settingsr quarter_nameProduction_Cost(
Efficiencyr rH Median)r r ro r: r r get_idr; rr r8 r# calc_production_costr r )r= r rT r rZ r bus_datas r> bus_summaryz Quarter_Settings.bus_summary s
LLN$' $
XXZ Nc
#''&/4
2}#&j 6 *848"*//
0CD48J#+:#5#5#748 !%!:!:&VZ!:![48 48L')11(,,y2LM48H N
+r? c | j | _ i }| j D ] } |j d } |j d }t }t j
| }|||< t j || d< | j || || d< d|| d< t j |j d d
|| d < |S ) Nr r r r r
r r r r rH r ) r r ro r: r r r r8 r# r r r )r= rT r rZ r r r s r> r zQuarter_Settings.summary s LLN$' $
XXZ
Nc
#''&/4
2 J6j 6 *848#+:#5#5#748 !%!:!:&VZ!:![48 48L')11(,,y2LM48H
N
+r? r c t j | }d}d} |r4t j | }t |j d }t t j
| }|j | S # t $ r2} t d| t d|g d}Y d } ~ t | S d } ~ ww xY w) Nr r )rZ Manufacturing_Cost)r re r z Trouble with Production Calc)r r: r r r r r r r r r floatr
re )
r= r r r r coefqr r rg s
r> r z%Quarter_Settings.calc_production_cost s
v #
$ $## #6A QUU'
( )D xz((0 13
t
,,
{"-D=A
4
4. s A)B C B??Cc g }| j d D ]5 }|j |j dd |j d d 7 |S )NActive=1r r rH r rz )ro rn r: )r= qdatar s r> r# zQuarter_Settings.options sL
% 88*8 % @a<<vb)!%%+>?@ ,r? c i }| j | _ | j D ] }|||j d < |S )Nr )r r r r: )r= rT r s r> r zQuarter_Settings.cache$ s@ $ LLN$' ;;= a4d
+r? r r c | j | _ | j j || | j S )Nr r r= r r s r> findzQuarter_Settings.find+ s0 LLN$'''..u5.)
r? c & | j d S )Nr r )ro r< s r> r zQuarter_Settings.active0 s
##r? Nc | j | _ |r | j j || | j j d t | j S )Nr r r )r r r orderr| r r# s r> ro zQuarter_Settings.all3 sI LLN$'
77>>E>*''--f-
dkkm r? rH rH N)r@ rA rB r rQ r{ r r r: rP r r r r r r r| r# r r r$ r ro rC r? r> r r s
C
! ! !
S T ,d "c s ' ,d D S x~ $
$T $ C $ r? r c e Zd ZU dZeed< d ZdefdZdedefdZ dedede
fdZ dede fd Z
dd ed ee d
e
de fdZdded
e
de fdZy
)r r r rF c | j | _ d| j _ | j j i | j S )NTr )r r debugdeleter r< s r> r zQuarters.reset> s8 LLN$'$''-''..b.
r? r c | j | _ | j j d|g | j S )Nz
Quarter_ID=%sr r )r= r s r> get_quarter_idzQuarters.get_quarter_idD s2 LLN$'''..j\.:
r? r c | j | _ | j j d||g t t | j dkD S )N Business_ID=%s and Quarter_ID=%sr r )r r r rW r| r )r= r r s r> check_existszQuarters.check_existsI sD LLN$'''..9Z@X.Y T$++-
!! ##r? c N | j | _ | j j d | j j d|g | j j d | j j d | j
| j S ) Nz0Quarters.*,Quarter_Settings.Name as Quarter_NamefieldsBusiness_ID=%sr z@join Quarter_Settings on Quarter_Settings.ID=Quarters.Quarter_ID)joinr r )r r r5 r r7 r'
parse_rowsr )r= r s r> r zQuarters.get_businessN ss LLN$'''..J.K''..'{m.<'',,V,W''--f-
''r? Nr r show_calcc | j | _ | j j d | j j d |r | j j || | j | j
| S )NzQuarters.*,(select Name from Business where ID=Quarters.Business_ID) as Business_Name,(select Name from Quarter_Settings where ID=Quarters.Quarter_ID) as Quarter_Namez(Quarters.Business_ID,Quarters.Quarter_IDr r )r r r5 r' r r8 r )r= r r r9 s r> ro z Quarters.allV sg LLN$'''.. z {''--@-A
77>>E>*
y 11r? rowsc J g }|D ] }t j |j d }i }t j t |j d }|rki d|j d d|j d d|j d d|j d d|j d d |j d d
|j d
d |j d d |j d d
t
|j d t |j d z d|j d d|j dd dt
|j d t |j d z d|j d d|j d d|j d }|s5|j d r$t |j dd dkD rd|d< nd|d< ||d< |j | |S )Ncalcr stock_pricepr_scorer r
capital_start capital_endrevenue expense_listr units_on_hand_startinventory_value_startr
units_on_handr r units_produced
units_soldprofitrH Fz .editableT) r r r: r r r r
rW rn )r= r; r9 r rr= cdata qsettingss r> r8 zQuarters.parse_rows_ s1 ! a
--f
&4
5 !((155 +>)?@9
488M*
$
IMM&)
TXXo.
488M*
txx "
DHH^,
$
488$9:
Qtxx 4 5$((CX:Y8Z Z
TXXo.
+a(
q+./!DHH_4M2NN
dhh /0
$((<(
dhhx !
E& f
#aeeF2.>*?*AAkNAkN1V988A;? @
(r? )rH NF)F)r@ rA rB r rQ r{ r r r r/ boolr2 r| r rP r ro r r8 rC r? r> r r : s
C C C D
$3 $# $$ $
(3 (4 (2C 2$ 2 2RV 2" $ " " " r? r c e Zd ZdefdZy)
Reports_PLrF c i S NrC r< s r> generatezReports_PL.generate s )r? N)r@ rA rB r rR rC r? r> rO rO s t r? rO c e Zd ZdedefdZy)Client_Dashboardr rF c R t }t j | }|t j | d|j |j
| t j dt j id}|j d sd|d< |S )Nr DashboardPL)r PlanStateQuarter_selectr ScheduleReportsr bus_initrY ) r r r: r r r# r r[ currentrO rR )r= r
q_settingsr rT s r> r zClient_Dashboard.summary s !*
Z^^v^
&(
*
!
!&
) &&( ,,V4j "
$ ((:
4=
+r? N)r@ rA rB rQ r r rC r? r> rT rT s r? rT c Z e Zd Zd ZdZdededefdZdede fdZ
d Z d
d
ed e e
de
fd Zy )Usersr~ userpasswordrF c | j | _ | j j d||g | j xs i }|S )NzUser=%s and Password=%sr r )r= rb rc rJ s r> authz
Users.auth s> LLN$'''..0X.G
oo 2!
(r? UserIDc | j | _ | j j d|g d| j _ | j xs i }t |j
d dkD S )Nr r Tr r )r r r r, r r r: )r= rf rJ s r> check_businesszUsers.check_business sZ LLN$'''..wfX..$''-
oo 2!
155 ""r? c t |j d t r(t j |j dd |d< t | S )NGroupsrH )
isinstancer: rP r r r rX s r> mk_rowz Users.mk_row s< "3'MM$((8B"784> Tr? Nr r c | j | _ | j j d |r | j j || t | j S )NzZUsers.*,(select Name from Business where Business.ID = Users.Business_ID) as Business_Namer4 r )r r r5 r r| r r# s r> ro z Users.all sJ LLN$'''..t.u
77>>E>*
dkkm r? r) )r@ rA rB r r rP r re rQ rM rh rl r r| ro rC r? r> ra ra s\ C # # #
C $ r? ra c e Zd Zg dg dg ddZddddZg dZdZd Zed
e fd Z
ed
e fd Z ed
e fd
Z
ed
efd Zy) Eval_Data)
AndersonThompsonMartinezWilliamsBrownMillerDavisGarcia RodriguezWilson)
JamesMichaelDavidJohnRobertDanielMatthew ChristopherAndrewJoseph)
EmilySophiaOliviaAvaIsabellaMia CharlotteAmeliaHarperEvelyn)lastmalefemale )r
r body)
ManagementLabor Marketingr0 r c N t j dd rd| _ y d| _ y )Nr r r r )random randrangegenderr< s r> __init__zEval_Data.__init__ s **1Q/$+X$+r? rF c n | j t j dt | j S rV )deptsr r rW r< s r>
departmentzEval_Data.department s&
F$$Qs4::7 88r? c . t j dd S )Nr C )r r r< s r> agez
Eval_Data.age s "R r? c " | j | j t j dt | j | j dz | j d t j dt | j d z S )Nr r )namesr r r rW r< s r> rZ zEval_Data.name s
DKK !1!1!C
4;;8O4P!Q RUX X[_[e[efl[mntn~n~ @A BE FJ FP FP QW FX BY oZ \[
[ [r? c d}| j d t j d| dt j d| dS )Nr r b)headr )r r r )r= cs r> profilezEval_Data.profile sL !
[[^ V - -a 2 3
4
f q#
$
%
r? N)r@ rA rB r profilesr r r r rP r rQ r rZ r r rC r? r> ro ro s
3%
L q " 8
> 9 9 9 !# ! ! [3 [ [ d r? ro c @ e Zd ZdZ fdZedededefd Z xZ S )Employee_EvaluationEmployee_Evaluationsc t |j d t r t |j d |d< t | | y )NProfile)rk r: rP r r r )r= rT r s r> r z Employee_Evaluation.__init__ s: #C( TXXi 014 ?'4r? r
quarter_idrF c t }|||j |j |j |j dd} | | S )Na Over the previous quarter, the employee demonstrated a strong work ethic and consistently met expectations when focused on assigned tasks. While they were frequently late to the office due to ongoing personal obligations, once present they showed determination and a willingness to put in extra effort to complete their work. There were occasional lapses in concentration, particularly during periods when personal matters required attention, which at times slowed progress or required follow-up. Despite these challenges, the employee remained reliable in delivering core responsibilities and was receptive to feedback. With improved time management and fewer external distractions, their overall performance has the potential to increase significantly in the coming quarter.)r r r Age
Departmentr Performance)ro rZ r r r )clsr r evrT s r> genzEmployee_Evaluation.gen sF {"
''
ZZ \
$
Tr? )
r@ rA rB r r classmethodrQ r r r r s @r> r r s6
C 3 4 r? r c h e Zd Zd ZdZdedee fdZdededee fdZ de
defd Z dedede
fd
Z y ) r r r rF c | j | _ | j j d|g t | j S r r r r r| r r s r> r: zEmployee_Evaluations.get s6 LLN$'''..wbT.*
dkkm r? r r c | j | _ | j j d||g t | j S )Nr1 r r )r= r r s r> get_quarterz Employee_Evaluations.get_quarter s: LLN$'''..9
@S.T
dkkm r? rT c t | S rQ )r rX s r> rl zEmployee_Evaluations.mk_row s
T ""r? c ||d}|S )N)r r rC )r= r r rT s r> r zEmployee_Evaluations.gen# s z 2$
+r? N)
r@ rA rB r r rQ r| r r: r r rl r rC r? r> r r sn c
S C DI
#d #s #S C D r? r c e Zd Zd ZdefdZy)r[ rF c | j | _ | j j d g }t j }| j D ] }t |d j }||z
}|j
|d< ||z
j dk\ |d< |j d|j dz d|d < |j | |S )
Nztimestamp desc timestampnowr futurez Days, i z Hoursdelta) r r r' r utcr full
total_secondsdayssecondsrn )r= rT r rL dttds r> r^ zSchedule.current) s LLN$'''-- ! $ #kkm dtK !%%'2 B24;V**,a/4>ggYgbjjD&8%9@4=;;t
+r? N)r@ rA rB r r| r^ rC r? r> r[ r[ ' s d r? r[ c L e Zd Zedeeef fd ZdedefdZ dedefdZ
y)RollrF c \ t j }t j dd }t j dd }|j dkD r(|j d |j d ||fS |j d |j d ||fS ) Nr )minutesecond; )hour r )r r replacer )r= r startends r> periodz Roll.period: s #
(
!1
-%"-#XXb[==b=;;B; +==a=;;B; +r? r c g }| j \ }}| j | _ | j j d||g | j j d|g |S )Nz]left join Roll on Roll.Student_ID = Students.ID and Roll.timestamp>=%s and Roll.timestamp<=%s)r7 r r6 r )r r r r7 r )r= r ro r r s r>
get_periodzRoll.get_periodH sh
# +5 LLN$''',,s }B CF |G, H''..'vh.7 *r? c p g }| j | _ | j j d|g |S )Nr6 r )r r r )r= r ro s r> studentsz
Roll.studentsP s0
# LLN$'''..'vh.7 *r? N) r@ rA rB r tuplerP r rQ r| r r rC r? r> r r 8 sI
E#c'N
C
D
#
$
r? r c e Zd ZdefdZy)r\ rF c l i }t j D ] }|||j d < |S )Nr )r ro r: )r= rT quarters r> outlookzReports.outlookW s: $!#'') 'g &4 F '
+r? N)r@ rA rB r r rC r? r> r\ r\ V s d r? r\ c e Zd ZU eed< eed< eed< eed< eed< dedefdZedefd Z edefd Z
edefd
Z edefd Z edefd Z
edefd
Zedefd Zedefd Zdeeef fdZdeeef fdZdedefdZdefdZdedefdZd Zdedededefd Z d defd Z y ) Base_Simulatorquarter_settings_global_settingsr r _logc V t j j |j d xs i | _ t j | _ || _ t | | _ | j j d | _ t t | _ t |j d | _ t | j j dd | _ t | j t! | j j d z | _ t! | j j d | _ t | j' d | _ | j$ | j( z | _ t | j j d xs d | _ t | j' d | _ t1 | j' d
| _ t | j j d | _ | j7 \ | _ | _ t! | j j d xs d
| _ t! | j j d | _ t! | j> | j< z | _ d
| _! | jE | j> | _# t d | _$ t | j j d | _% t1 | j' d | _& | jL | _' | jQ | jJ t | j' d | jN | _) tU | jR | jJ z dz | _+ tU | jR | j4 z | _, | j j dd | _- | j] y # d
| _+ Y dxY w)Nr r r
Labor_Costr r Employee_Salesrd RD_MedianRD_ROIr r r r marketing
Marketing_ROIMarketing_Medianr r r r
plant_sizerH )/r r r: r r r r r r r r r| r r
r
labor_rater wagesr globalsemployee_potentialemployee_salesrd_spend rd_medianr rd_coefr
calc_otherotherr? rF rG units_totalrH calc_prod_cost prod_costrB r
marketing_roi
marketing_effcalc_effmarketing_salesroundmarketing_resultmarketing_unitsr calc_revenue)r= r r s r> r zBase_Simulator.__init__e s *,22488\9RSYWY$)+113$$,
3
$( i($,$ $)3779%&$,d++// TBC$/ 1T\\%5%5k%B#CCD$*T\\%%k23$. dll+; < =$ )@)@@$DLL$$T*2d3$-T\\+./$.4<<)*$, !!'*+$* "__ .$*T] g./41$$,,**734$t**T-?-??@$$/&&t':':;$.4$,T\\%%k23$. o67$ **$ T^^1T\\RdEeCflpl~l~ $ !5!5!FG#M4 t 3 3djj @A$))--l2>$/ 4s *P P(rF c F t | j | j z S rQ )r
r rG r< s r>
manuf_costzBase_Simulator.manuf_cost s
4>>D / / / 00r? c f t | j }t |j xs d S )Nr )r r r r )r= r s r> r zBase_Simulator.unit_cost s) dhh # ""$, --r? c F | j \ }}|xs t d S rV )r r )r= r _s r> dilemma_costzBase_Simulator.dilemma_cost s! ?? &$q
r? c | j j d xs d} t j | }t | S # t
$ r"}t
d| t d cY d }~S d }~ww xY w)NoverheadrH z Troubling finding fixed costr r )r r: r8 r r
re r )r= tierr rg s r>
fixed_costzBase_Simulator.fixed_cost s]
,,
:
&
,"$
*//$
4
D'> -48
A$;s #A A0A+%A0+A0c | j j d dk( r t d S | j j d dk( r t d S | j j d dk( r t d S t d S ) Nr Smalli Mediamr% Larger r )r r: r
r< s r>
plant_costzBase_Simulator.plant_cost sq |,7
E(? .(:
E(? .'9
E(?
4.r? c v | j | j | j | j | j dS )N)z
Labor CostzProduction Costr FixedOther)r r r r r
r< s r> rC zBase_Simulator.expense_list s3
^^~~ ??
r? c ^ t | j j }t | S rQ )sumrC valuesr
)r= r s r> r zBase_Simulator.expenses s$
d &&(
)%
5/r? c | j }| j }| j }| j ||| }t t ||z d S )Nr r )r r r r r r )r= spendr r results r> rd_effzBase_Simulator.rd_eff sG
--% >>&
$ ==uF= =& q& !! $$r? c t | j j d xs d }t | j j d xs d }t d }d}d}|D ]J } |t j
||| z
}|t j ||| z
}|dz
}L ||fS # t $ r
}Y d }~_d }~ww xY w)Nr; rH r^ r )r^ r_ r ) r r r: r r
r; r rj re )r= rk actionsr rj r r^ rg s r> r zBase_Simulator.calc_other s
T**..z:@b
A(
T\\%%i06B
7'
1$"! g HJOOG71:O >>D(*--wqz-
::BqDA
b. s &AB33 CCc t | j j d }t | j j d }d}d}d}| j j d xs g D ]r }t j |i j di j || }t d| |sK||j d z
}||j d z
}t t
| |fS ) Nr^ r r; r# z Found detailr r r )r r r: r r\ r r )r= rk respr r rj problemr s r> calc_other_oldz Base_Simulator.calc_other_old s
T\\%%i0
1( !!), -$!
%"&&**:6<" "g LL $ ( (2 6 : :47 C6~6* VZZ
E&**[
!!B "
r? r c 2 t || j z S rQ )r
r )r= r s r> r z Base_Simulator.calc_prod_cost s
54>> ! ""r? c * t d| j t t | j | j
z }|| j kD r| j | _ n|| _ | j
| j z | _ | j S )NzCalc Units Totalr )r r r r r r rH rB )r= potentials r> r zBase_Simulator.calc_revenue sq d&6&67d**TZZ789)!!!%%4? 4?doo-$,
r? rE rq c @ | j | j | y rQ )r rn )r= rE rq s r> logzBase_Simulator.log s ))C. r? c . d}t }|j | j j dd }t j
|| j }|dz |z }|dk r| }|dz }|dz }|dk rd}t d|| j ||d |S )
Nr( r rH r r g ?z Price Eff)r r r effr )r r r r: r changer r )r= max_effr r r r- s r> calc_price_effz Base_Simulator.calc_price_eff s '
( i!; <&
,,vdjj
)%
)w #2X
3(#)#"W 3k ::
*r? r r r c | j }t |dz }t | }d}d}d} |dkD rI||k r|}|dz |z }
t ||
z } | | z
} ||z }|dk rd}||z
}|dkD rd}d}|dk rd}|dkD rIt | j j d dz } | }
| | z } | | |z z }t
d |
| | ||d
t | S ) Nr U r r r r r Economic_StrengthzPrice Efficiency)ototalr strength eff_total price_effr )r0 r absr r r: r r
)r= r r r r7 c_sizerJ r- incr eff_ratecvalr5 r4 r6 s r> r zBase_Simulator.calc_eff s !!#) frk &h!
# #
% D&j
F3w$ 8
fx
4D=5f91!e A83 #g
C
C Bh
C%
D* t$$(()<=
>
D( &8%uY') '
9 r? c X | j j || j d S )Nr )r r: )r= rE defaults r> r zBase_Simulator.globalsB s&
" "3w / 3 3G < r r ^ s
(4 (M (\ 1 1 1 . . . 7 4 w %U % %ws{+ $
U73; /
#s #w #
7
# #
2' ' 'U 'w 'R=S =r? r c . e Zd Zdedef fd Zd Z xZS )Q_Simr r c ( t | || y )Nr r )r r )r= r r r s r> r zQ_Sim.__init__F s '7s+r? c
| j | j z
| j z }| j | j z
}| j
j
dd }t j ||| }i d|d| j d| j | j | j dd| j | j t | j! d t# | j! d | j$ d
d | j d | j& d
| j d| j( d| j d| j | j z
d| j | j z
| j z d| j d|d| j* d| j, d| j. d| j | j0 ||dS )Nr rH r r r r? labor)r
labor_costsalesr r r )r r- r ceofrG r r r rC rB rI r r@ rA r r rG rH )rD rF r> )rB r r r rH r r: r r r? r r r r r r
r r r r rC r r rG rF )r= r rF r r> s r> r= z
Q_Sim.calcJ s
\\DMM
)T\\ 9'""T__4- HHLL2 &'
++M'Za+b+
W
dmm
NN
t|| ./
0 T\\/
* +
4::
4::!
" dmm#
$ $##%
&
T\\'
( DLL4== ()
*
dllT]]*dll
:+
, 4<<-
. /
0 1
2 t~~3
4 D''5
6 7
8 ++ =
r? )r@ rA rB r r r= r r s @r> r@ r@ E s ,4 ,D ,%r? r@ c D e Zd ZdefdZdedefdZd
dedee defd Z y) Simbusinessc t | }t |j }|dz }|dkD r|S y# t $ r$}t d| t d| Y d }~yd }~ww xY w)Nr r re r zTrouble with calc stockr )r r
r re r )r= rK r rq stockrg s r>
calc_stockzSim.calc_stockr s_
x 3
3?? 3 ;5 ai L
{"(h7
s +/ A AA r rF c d} t |d dkD sJ d t t |d }t | S # t $ r
}Y d }~yd }~ww xY w)Nr PR_Scoresz No PR Scores)rW r r re )r= r rj rg s r> pr_avgz
Sim.pr_avg s\ "
c+
!1>1
! #c+
2
B%<
s 9> A ANtestr c : ddl m} |}i }t j }t }|j }t } g }
|D ]e } ||| j
d xs! |j
di j
d || d< d|| d< d|| d < d|| d
< g || d < g t j } | D ] }
|
j
d }|j
| xs i }t |
|
j }||
d< |s|| j
dd }t |j
d } ||j
d }t j ||| |
d d< | j |
j
d t j | d |
j
d }|| j dg || d j |
|| j d |d || j d |d || j d |d || j d |d || dxx ||
d j
d d z
cc< || dxx ||
d j
d d z
cc< || dxx t |j
d z
cc< || d xx t |j
d z
cc< |j
d || d< |j
d || d< || d xx |j
d z
cc< || d j |j
d |
j | t! d!|j
| " |sp|j# D ]] \ }}| j% |# }|j ||| j' | |j
d |j
dd d$ _ |
|d%S )&Nr r r r r r r r r r rP r rB r= r rH rF r rD r> r )r r= r quarters rev_total
expense_totalrH
units_maderB r rG r? zUpdating Businessr )rK )r r r r r )sims bus_cache)r r
r r r r r: ro r@ r= r r r toJSON
setdefaultrn r rm rN rQ )r= rR r r
pbus_idrT gsettingsrK rY rT rX cb_idq_allr r r= r r r r r rM s r> rT z Sim.quarters s ' $ %%')
Z( nn )
Z( $ &e!"9U#3#7#7#?!@!tIMMRcdfDgDkDklsDt9UI #9UG "#9UJ %&9UM"#%9UK & *..
% !@g KK
&6mmF#)r8
H
-
2
2
4476?
##Ib1G
dhh' (E#$G%-Z%@%@uU\el%@%mGFOM" OOw{{4 0 T8JKOL T 3 V
2. VZ ''0 V AaD1 V !5 V QqT2 V QqT2 V[!Agfo&9&9)D&I$JJ! V_%'&/*=*=j*N(OO% V\"a (>&??" V\"a1A(B&CC" $ 99VW "&((9"59VY VZ DHHZ$88 V[!((*)=>;;t"
g(>?C!@F
__& Vzvc OOSO )E OOvEdkkRUFV`c`g`gho`p| }D }D EN OS }T UO VV ) ,,r? )FN)
r@ rA rB r rN rQ rQ rM r rT rC r? r> rJ rJ q sC
d
T
c
E- E-(3- E- E-r? rJ c d }|S )Nc |j d }|j d }dd| d| d}t j d| |S ) Nr~ levelr zUser z is not )r messageResponser )r: r r )argcargvrb rb responses r> rc z auth_failed..message sH
& $
((7
%U4&#@
A(++JH- /r? rC )funcrc s r> auth_failedri s r? rb c X t j dd| i d}d }|dk( r|S t S )Nz Auth argsLevelr Brentac fd}|S )Nc J t j d| |d | i | y )Ninside)re rf r )r r )re rf rh s r> wrapperz(auth..grab_func..wrapper s# ;;X4t#<=r? rC )rh rp s ` r> grab_funczauth..grab_func s
.r? Brent)r r ri )rb rb rq s r> re re s3 ;WUO4
GO r? r )<typingr r r r functoolsr r collectionsr flaskr
r r r r
r r r r dbr r decimalr mathr r r| r r{ rJ r\ r6 r8 r; rQ r r r r r r r rO rT ra ro r r r[ r r\ r r@ rJ ri rP re BW_ConfigrC r? r> r{ s@ . . % ) ) # . . .
4S=)Y ) 4 >l uz DG OS T
, 7} FN XY af g
& 1 HN XZ bg h k
v
Q
U
$ a
1
]
0
$ Q !
5
7
$ I
N
I 5
7
k /
I
$ i &
.
$ X /
$
$ x =
#
$ Z
1
>
S
$ W
1
t
-
Gt l $? ?B # 3 '$e '$R"D "HK
u K
Zj u j XG u G R u ( E :@ @D# 05 *u "
5
< e= e=N*N *Xb-% b-H s 5
r?