LidZddlmZmZmZmZddlZddlZddlmZm Z m Z ee Z ej dZdZe ddZe d d Ze d d Ze d dgdZe ddZe dkre ddddSdS)u&Finance Butler Dashboard — Flask App)Flaskrender_templatejsonifyrequestN)datetimedate timedeltaz,~/.hermes/profiles/finance-butler/finance.dbcZtjt}tj|_|S)N)sqlite3connectDB_PATHRow row_factory)cons ./home/debian/Projects/finance-dashboard/app.pyget_dbr s /' " "CkCO J/c tdS)Nz index.html)rrrindexrs < ( ((rz /api/summaryc 6t}|}tj}|d}|jd|j}|d|fdpd}|d}|dkr|n |r|dn|}||kr1|d|fdpd}|d|f }|d } |d } i} | D]M} |d | d f} | rt| nd| | d <N| g}d}| D]} | | d } | r| d | d znd}|r||z }| | d | d | d | d| r| d nd| r| dnd| r| dnd|dt||d|Dd| D||ddS)Nz%Y-%m-z.SELECT SUM(amount) FROM expenses WHERE month=?rHSELECT month FROM expenses WHERE month != '' ORDER BY month DESC LIMIT 1z SELECT parent, SUM(amount) as total FROM expenses WHERE month=? GROUP BY parent ORDER BY total DESC z SELECT month, SUM(amount) as total FROM expenses WHERE date >= date('now', '-6 months') GROUP BY month ORDER BY month zSELECT * FROM holdingsz SELECT close_price, change_amount, change_percent FROM stock_prices WHERE symbol=? ORDER BY date DESC LIMIT 1 symbol close_pricesharesname total_cost change_amountchange_percent)rrrrrr r! market_valuec,g|]}t|Srdict.0rs r zapi_summary..Ys111!d1gg111rc,g|]}t|Srr$r&s rr)zapi_summary..Zs777Qa777riq) display_month month_total by_parent months_trendholdingstotal_market_valuer)rcursorrtodaystrftimeyearmonthexecutefetchonefetchallr%closegetappendr)rcurr2 this_month current_monthr,latest_month_rowr+r-r.r/priceshp holdings_datar0 market_vals r api_summaryrEs$ ((C **,,C JLLE((Jz11EK11M++8=:Jhjj{{Rhjj&11__MMRb;u;KA;N;NhuM %%kk <}>N  (**Q      $8:: ;;    {{344==??H F 55 KK k^  &XZZ *+4d1gggq{IIKKKM    JJq{ # #9:Da &844  - * , kfIkL//0:1]++d34>Q//$56@a 011D&    &"11y11177,777!0  rz /api/expensesc8t}|}tjdd}t j}|r|dkrht}|d}| |r|dn| d}|d|f }| td|DS) Nr5currentrr%Y-%-mz SELECT date, account, amount, category, parent, note FROM expenses WHERE month=? ORDER BY date DESC, id DESC LIMIT 200 c,g|]}t|Srr$r&s rr)z api_expenses..s***DGG***r) rr1rargsr:rr2r6r7r9r3r8r)rr<r5r2con2rowrowss r api_expensesrP`s ((C **,,C L  Wb ) )E JLLE >(#;#; ;;     8::  IIKKK **T*** + ++rz/api/add_expensePOST)methodsc tj}tj}t }|}|d|ddf}|r|dnd}|d|d| d|d| d |d d |d |dd||d d|ddf| | tddiS)Nz1SELECT parent FROM categories WHERE subcategory=?categoryrGrz INSERT INTO expenses (date, month, account, amount, category, parent, note, person) VALUES (?,?,?,?,?,?,?,?) rz%Y/%m/%dr5rIaccountu現金amountnotepersonzamiokT) rjsonrr2rr1r6r:r7r3commitr9r)datar2rr<parents rapi_add_expenser_usL U>U=Whjj ! (VAYYbFKK  3344 %..2233 H%% X R    6""    JJLLLIIKKK D$<  rz/api/categoriesct}|d}|t d|DS)NzMSELECT subcategory, parent, type FROM categories ORDER BY parent, subcategoryc,g|]}t|Srr$r&s rr)z"api_categories..rKr)rr6r8r9r)rrOs rapi_categoriesrbsS ((C ;;f g g p p r rDIIKKK **T*** + ++r__main__z0.0.0.0iF)hostportdebug)__doc__flaskrrrrr osrrr __name__apppath expanduserr rrouterrErPr_rbrunrrrrps,,::::::::::::.......... eHoo '  K L L 3)))>JJJX?,,,( x00!!10!6 ,,,  zGGeG44444r