§ «bj6dãóö—ddlmZddlmZddlmZddlmZddlm Z ddl mZd7d„Zd8d „Z d8d„Zd8d„Zd9d„Zd:d„Zd;d„Zdd„Zd?d"„Zd@d'„ZdAd+„ZdBd/„Zd0d1œdCd2„ZdDd3„Zd0d1œdEd4„Zd0d1œdEd5„Zdz"_category_meta../s-€Ð@Ð@Ð@°aC-Ô Ñ!Ô!¥;¨q¡>¤>Ð@Ð@Ð@r)rÚfetchall)rÚrowss rÚ_category_metar7-sI€Ø<Š<ðKñLôL÷UòUñWôW€DØ@Ð@¸4Ð@Ñ@Ô@Ð@rr0ú str | NoneÚmetaú list[str]cól—|r||vrgSg}|| d¦«}t¦«}|r~||vrz||vrv| t|¦«¦«| t|¦«¦«|t|¦« d¦«}|r||vr||v°v|S)NÚparent_category_id)ÚgetÚsetÚappendr Úadd)r0r9ÚoutÚparentÚseens rÚ _ancestor_idsrD2sÌ€Øð˜+¨TÐ1Ð1Øˆ Ø€CØ +Ô × "Ò "Ð#7Ñ 8Ô 8€FÝ‘U”U€DØ ð=V˜t^^¨°dÐ(:Ð(:Ø Š •3v‘;”;ÑÔÐØŠ•V‘”ÑÔÐØ•c˜&‘k”kÔ"×&Ò&Ð';Ñ<Ô<ˆðð=V˜t^^¨°dÐ(:Ð(:ð€JrNrÚdictcó–—|pt|¦«}| d|f¦« ¦«}td¦«}td¦«}|D]0}t |¦«}|ddvr||z }Œ!|ddvr||z }Œ1|t|¦«t|¦«t||z ¦«t |¦«dœS)Nú]SELECT * FROM budget_transactions WHERE status='confirmed' AND substr(transaction_date,1,7)=?rÚtransaction_type>ÚincomeÚrefund>ÚfeeÚexpense)rÚ income_chfÚexpense_chfÚnet_cashflow_chfÚtransaction_count)rrr5rrr+Úlen)rrÚselected_monthr6rIrLrÚamounts rÚget_monthly_summaryrT?s$€ØÐ2n¨TÑ2Ô2€NØ<Š<Ðwð{IðzKñLôL÷UòUñWôW€DÝ S‰\Œ\€FÝc‰lŒl€GØððˆÝ˜‘”ˆØÐ!Ô"Ð&:Ð:Ð:ØfÑˆFˆFØ Ð#Ô $Ð(:Ð :Ð :ØvÑˆGøØ#µ4¸±<´<ÕPTÐU\ÑP]ÔP]ÕswÐx~ðBIñyIñtJôtJõadðeiñajôajðkðkðkrú list[dict]c ó<—|pt|¦«}| d|f¦« ¦«}i}|D]™}| |d|d|dt d¦«ddœ¦«}|dxxt t|dp |dpd¦«¦«z cc<|d xxt |d ¦«z cc<Œšt| ¦«¦«}| d„d¬ ¦«d„|D¦«S)Naµ SELECT COALESCE(c.category_id, 'uncategorized') AS summary_category_id, COALESCE(c.name, 'Unkategorisiert') AS summary_category_name, t.transaction_type, t.amount_chf, t.amount_original, COUNT(*) AS count FROM budget_transactions t LEFT JOIN budget_categories c ON c.category_id=t.category_id WHERE t.status='confirmed' AND substr(t.transaction_date,1,7)=? AND t.transaction_type IN ('income','expense','refund','fee') GROUP BY COALESCE(c.category_id, 'uncategorized'), COALESCE(c.name, 'Unkategorisiert'), t.transaction_type, t.amount_chf, t.amount_original Úsummary_category_idÚsummary_category_namerr)r0Ú category_namerrPrrrPÚcountcó—|dS)Nr©)Úxs rúz&get_category_summary..es €˜a œo€rT©ÚkeyÚreversecóD—g|]}i|¥dt|d¦«i¥‘ŒS)r)r+r1s rú z(get_category_summary..fs4€ÐGÐGÐG¸1Ð6ˆqÐ6,¥ Q |¤_Ñ 5Ô 5Ð6Ð6ÐGÐGÐGr) rrr5Ú setdefaultrr ÚintÚlistÚvaluesÚsort)rrrRr6ÚtotalsrÚitemÚresults rÚget_category_summaryrlMsp€ØÐ2n¨TÑ2Ô2€NØ<Š<ð ð Ðñô÷‚hj„jð ð !€FØð7ð7ˆØ× Ò Ð%:Ô!;ÈSÐQfÔMgÐz}ðVô{WõgnðorñgsôgsðJKð>Lð>LñMôMˆØˆ\ÐÐÔg¥c¨#¨lÔ*;Ð*\¸sÐCTÔ?UÐ*\ÐY\Ñ&]Ô&]Ñ^Ô^Ñ^ÐÐÑØÐ Ð!Ð!Ô!¥S¨¨W¬Ñ%6Ô%6Ñ6Ð!Ð!Ñ!Ð!Ý &—-’-‘/”/Ñ "Ô "€FØ ‡K‚KÐ-Ð-°t€KÑ<Ô<Ð<ØGÐGÀÐGÑGÔGÐGrÚyearÚmonths_with_bookingsrec óÄ—tj¦«}t|j¦«|kr|j}nd}tdt dt||¦«¦«¦«S)Néé)rÚtodayr rmrÚmaxÚmin)rmrnrrÚelapseds rÚ_months_denominatorrvisS€ÝŒJ‰LŒL€EÝ ˆ5Œ:„˜$ÒÐØ”+ˆˆàˆÝˆq•#b#Ð2°GÑ<Ô<Ñ=Ô=Ñ>Ô>Ð>rÚ category_typeÚbudget_yearÚ forecast_yearÚactual_yearcó6—|dkr|dkrdS|dks|dks|dkrdS||z}|dkr,|td¦«krdS|td¦«krdSd S|td ¦«krdS|td¦«krd S|td¦«krdSdS)Nrúohne BudgetúNoch keine DatenrIÚ1õGrÃ¼nú0.90ÚGelbÚRotz1.15ÚKritischr)rwrxryrzrnÚratios rÚ_statusr…rsÍ€ØaÒÐ˜K¨!šO˜OØˆ}ØaÒÐÐ/°1Ò4Ð4¸ÀqÒ8HÐ8HØ!Ð!Ø˜KÑ'€EØ˜Ò Ð Ø•G˜C‘L”LÒ Ð Ø7Ø•G˜F‘O”OÒ#Ð#Ø6ØˆuØwv‰ŒÒÐØˆzØws‰|Œ|ÒÐØˆuØ•˜‘”ÒÐØˆvØˆ7rÚactualÚbudgetútuple[str, str]có—|dkr|dkrdS|dks|dkrdS||z}|dkr,|td¦«krdS|td¦«krdSd S|td¦«krd S|td¦«krdSdS) Nr)r|Úslate)r}rŠrIr~)rÚgreenr€)rÚyellow)r‚Úredr)rwr†r‡r„s rÚ _month_statusrŽ‡sª€Ø ‚{€{v ’zzØ%Ð%Ø ‚{€{f ’kkØ*Ð*ØV‰O€EØ˜Ò Ð Ø•G˜C‘L”LÒ Ð Ø#Ð#Ø•G˜F‘O”OÒ#Ð#Ø#Ð#Øˆ|Øws‰|Œ|ÒÐØˆ|Ø•˜‘”ÒÐØÐØÐrÚbudget_monthÚmonthlyúdict[str, Decimal]cóN—gd¢}g}t|d¬¦«D]Œ\}}|d›}| |td¦«¦«} t|| |¦«\} }| |›d|›|t| ¦«t|¦«t| |z ¦«| |dœ¦«Œ|S)N)ÚJanÚFebÚMrzÚAprÚMaiÚJunÚJulÚAugÚSepÚOktÚNovÚDezrq)ÚstartÚ02drÚ-)rÚmonth_labelÚ actual_chfÚ budget_chfÚdifference_chfÚstatusÚ bar_color)Ú enumerater=rrŽr?r+)rwrmrrÚlabelsrAÚidxÚlabelr`r†r¦Úcolors rÚ_monthly_analysisršsÏ€Ø aÐ aÐ a€FØ €CÝ ¨aÐ0Ñ0Ô0ðð‰ ˆˆUØˆlˆlˆØ—’˜S¥'¨#¡,¤,Ñ/Ô/ˆÝ% m°V¸\ÑJÔJ‰ ˆØ Š Ø__˜s__Ø Ý˜v™,œ,Ý˜|Ñ,Ô,Ý" 6¨LÑ#8Ñ9Ô9ØØð ð ñ ô ð ð ð€JrÚ2026©rmcó$‡‡ ‡!‡"‡#—t|¦«Š!| d|f¦« ¦«}| d|f¦« ¦«}iŠiŠ"iŠ#dTdUˆˆ"ˆ#fd„ }i}|D][}t|dpd ¦«}|r|‰!vrŒ!t t|dpd¦«¦«}t|dpd ¦«dd…} |||| ¦«‰!|} | ||| d| d| d¦«pdt d¦«t d¦«gdddœ ¦«t|‰!¦«D]v}‰!|}|||| |¦«d| |||d|d| d¦«pdt d¦«t d¦«gdddœ ¦«d<ŒwŒ]|D]é} t| d¦«}| ||| d| d| dpdt d¦«t d¦«gdt‰# |¦«¦«dœ ¦«}t| ¦«}t| ¦«}|dxx|z cc<|dxx|z cc<|d | d¦«d|d<Œêg}| ¦«D]6\}}‰ |t d¦«t¦«f¦«\}}t|¦«}|dkr |dsŒXt||¦«}|t |¦«z}|r|t d ¦«znt d¦«}|r|t d ¦«znt d¦«}||dz }t!|d|d|||¦«}‰" |i¦«Š tt#j¦«j¦«|krt#j¦«jd!›nd }| id|“d"|d"“d|d“d|drt+|d¦«nd“d|drt+|d¦«nd“d#t|d¦«“d$d%“d&t+‰ |t d¦«¦«¦«“d't+|¦«“d(ˆ fd)„t-d*d+¦«D¦«“d,t/|d||dr|dnt d¦«‰ ¦«“d-t+|¦«“d.t+|¦«“d/t+|¦«“d0t+|¦«“d1t+|t d ¦«z¦«“d2|“|d3kr|dd4krd5n |d3krd6nd ||dt| d¦«¦«t‰# |t¦«¦«¦«d7œ¥¦«Œ8| ˆ!fd8„¬9¦« dd:lm}d;„|||¬<¦« d=g¦«D¦«}|D]}| |d¦«}|r| d¦«d>krŒ:| id| d?¦«“d| d@¦«“d.| dA¦«“dB| dC¦«“dD| dE¦«“dF| dE¦«“dG| dG¦«“dH| dI¦«“d0| dJ¦«“d2| d2¦«dKkr| d2¦«n)| d2¦«p| d2¦«“dL| dL¦«“dM| dM¦«“dN| dN¦«“dO| dO¦«“dP| dP¦«“dQ| dQ¦«“dR| dR¦«“dS| dS¦«i¥¦«Œ!n#t8$rYnwxYw|S)VNa0 SELECT p.*, c.name AS category_name, c.category_type, c.sort_order FROM budget_plan_items p JOIN budget_categories c ON c.category_id=p.category_id WHERE p.is_active=1 AND c.is_active=1 AND substr(p.plan_month,1,4)=? ORDER BY c.sort_order, c.name, p.name a SELECT category_id, transaction_date, COALESCE(amount_chf, amount_original, '0') AS amount FROM budget_transactions WHERE status='confirmed' AND substr(transaction_date,1,4)=? AND transaction_type IN ('income','refund','expense','fee') r0r rSrÚmonth_noÚsource_childr8rÚNonecóÂ•—‰ |td¦«t¦«f¦«\}}| |¦«||z|f‰|<‰ |i¦« |td¦«¦«|z‰ |i¦«|<|r7‰ |t¦«¦« |¦«dSdS)Nr)r=rr>r@rd) r0rSr±r²ÚtotalÚmonthsr†Úmonthly_actualsÚrollup_child_idss €€€rÚ add_actualz1get_budget_status_by_category..add_actualÆsþø€ØŸ š ;µ¸±´½s¹u¼uÐ0EÑFÔF‰ ˆˆvØ Š 8ÑÔÐØ$ v™~¨vÐ6ˆˆ{ÑØ@O×@ZÒ@ZÐ[fÐhjÑ@kÔ@k×@oÒ@oÐpxõ{BðCFñ{Gô{GñAHôAHðKQñAQˆ×"Ò" ;°Ñ3Ô3°HÑ=Øð NØ×'Ò'¨µS±U´UÑ;Ô;×?Ò?ÀÑMÔMÐMÐMÐMð Nð NrÚrÚtransaction_dateééÚnamerwÚ sort_orderéçF) r0Úcategoryrwr¿rrxÚplansÚhas_planÚ is_rollupTrÄrYrrxrÂrÃrr!r rÁÚ has_budgetÚpurposeÚcategory_controlÚactual_current_monthÚactual_year_to_dater·cóz•—i|]7}|d›t‰ |d›td¦«¦«¦«“Œ8S)r r)r+r=r)r2ÚmÚcategory_monthlys €rr4z1get_budget_status_by_category..sGø€ÐwÐwÐwÐef 1 DÐ1A×1EÒ1EÈÀjÀjÕRYÐZ]ÑR^ÔR^Ñ1_Ô1_Ñ,`Ô,`ÐwÐwÐwrrqé Úmonthly_analysisÚactual_avg_monthryÚforecast_avg_monthÚdeviation_yearÚdeviation_monthr¦r|rIz(Ausgaben vorhanden, aber kein Budgetplanz)Einnahmen vorhanden, aber kein Budgetplan)Ústatus_hintrnÚ plan_namesrÄÚrollup_child_countcó”•—|ddkrdnd‰ |di¦« d¦«pd|dfS) NrwrIrrqr0r¿rÀrÁ)r=)r3r9s €rr^z/get_budget_status_by_category..sjø€ Q Ô%7¸8Ò%CÐ%C ÈÈDÏHÊHÐUVÐWdÔUeÐgiÑLjÔLj×LnÒLnÐo{ÑL|ÔL|ðMDðADðFGðHRôFSð T€r)r`)Úget_budget_planning_matrixcó —i|]}|d|“ŒSr/r\)r2rs rr4z1get_budget_status_by_category..s€ÐyÐyÐy°c˜#˜mÔ,¨cÐyÐyÐyrr¯r6rLÚbudget_month_chfÚbudget_year_chfÚbudget_adjusted_forecast_chfÚlinear_forecastÚlinear_forecast_chfÚactual_2025_yearÚprevious_year_total_chfÚprevious_year_totalÚprevious_year_monthsÚdeviation_previous_yearÚforecast_vs_previous_year_chfÚforecast_vs_budget_chfzBudget fehltÚdata_explorer_urlÚeffective_expenses_urlÚ monthly_chartÚhas_previous_yearÚknown_recurring_month_chfÚknown_recurring_year_chfÚfixed_cost_quote_percentÚ variable_actual_year_to_date_chf©N) r0r rSrr±r r²r8rr³)r7rr5r rrdr=rDÚboolr#r%r?Úitemsr>rQrvr…rrrrmrr+ÚrangerrhÚ'jarvis_finance.services.budget_planningr×ÚupdateÚ Exception)$rrmÚ plan_rowsÚtx_rowsr¹Úgroupedrr0rSr±ÚcatÚancestor_idÚancestorrrjÚbmÚbyÚresultsrzÚ month_setr¶ÚdenomÚ actual_avgryÚforecast_monthÚ deviationr¦Úcurrent_month_nor×Úplanning_by_idÚplanningr†rÌr9r·r¸s$ @@@@@rÚget_budget_status_by_categoryrsŠøøøøø€Ý˜$ÑÔ€DØ—’ð ð ˆñ ô ÷‚hj„jððlŠlð ð ˆñô÷‚hj„jðð35€FØ57€OØ,.ÐðNðNðNðNðNðNðNðNðNð "€GØðGñGˆÝ˜#˜mÔ,Ð2°Ñ3Ô3ˆØð ˜k°Ð5Ð5ØÝ˜S œ]Ð1¨cÑ2Ô2Ñ3Ô3ˆÝsÐ-Ô.Ð4°"Ñ5Ô5°a¸°cÔ:ˆØˆ ; ¨Ñ1Ô1Ð1Ø;ÔˆØ×Ò˜;¸ÐQTÐU[ÔQ\ÐorðtCôpDðTW÷T[òT[ð\hñTiôTiðTpðmpõBIðJMñBNôBNõ_fðgjñ_kô_kðvxðFKðZ_ð)`ð)`ñ aô að aÝ(¨°dÑ;Ô;ð Gð GˆKØ˜KÔ(ˆHØˆJ{ F¨H°kÑBÔBÐBðCGˆG×Ò˜{¸KÐU]Ð^dÔUeðyAðBQôyRðbj÷bnòbnðo{ñb|ôb|ðbCð@CõU\ð]`ñUaôUaõryðz}ñr~ôr~ðIKðY^ðmqð-rð-rñ sô sðtñ @ð @ñ Gð ð ð ˆÝ˜$˜}Ô-Ñ.Ô.ˆØ×!Ò! +Ø&Ø˜_Ô-Ø! /Ô2Ø˜|Ô,Ð3°Ý# C™LœLÝ" 3™<œ<ØØÝÐ.×2Ò2°;Ñ?Ô?Ñ@Ô@ð 0 ð 0 ñ ô ˆõ" $Ñ 'Ô 'ˆÝ Ñ &Ô &ˆØˆ^ÐÐÔ Ñ"ÐÐÑØˆ]ÐÐÔ˜rÑ!ÐÐÑØˆWŒ ×Ò˜T &œ\Ñ*Ô*Ð*ØˆˆZÑÐØ€GØ$Ÿ]š]™_œ_ð$ñ$ÑˆTØ!'§¢¨K½'À#¹,¼,ÍÉÌÐ9NÑ!OÔ!OÑˆYÝY‘”ˆØ˜!ÒÐ D¨Ô$4ÐØÝ# D¨&Ñ1Ô1ˆØ ¥7¨5¡>¤>Ñ1ˆ Ø6AÐS˜ ¥W¨T¡]¤]Ñ2Ð2ÅwÈsÁ|Ä|ˆ Ø:GÐY˜°©¬Ñ6Ð6ÍWÐUXÉ\Ì\ˆØ! D¨Ô$7Ñ7ˆ Ý˜˜oÔ.°°]Ô0CÀ]ÐT_ÐagÑhÔhˆØ*×.Ò.¨{¸BÑ?Ô?ÐÝ:=½d¼j¹l¼lÔ>OÑ:PÔ:PÐTXÒ:XÐ:Xdœj™lœlÔ0Ð6Ð6Ð6Ð^bÐØŠð Ø˜;ð à˜˜ZÔ(ð ð ˜T /Ô2ð ð ¸$¸zÔ:JÐTD nÔ!5Ñ6Ô6Ð6ÐPTð ð ¸¸ZÔ8HÐR4 ]Ô 3Ñ4Ô4Ð4Èdð ð $˜t JÔ/Ñ0Ô0ð ð Ð)ð ð #¥DÐ)9×)=Ò)=Ð>NÕPWÐX[ÑP\ÔP\Ñ)]Ô)]Ñ$^Ô$^ð ð "¥4¨Ñ#4Ô#4ð ð ÐwÐwÐwÐwÕjoÐpqÐsuÑjvÔjvÐwÑwÔwð ð Õ 1°$°Ô2GÈÐgkÐlvÔgwðPJÈtÐTbÔOcÐOcõ~EðFIñ~Jô~JðL\ñ!]ô!]ð ð ¥ ZÑ 0Ô 0ð ð T -Ñ0Ô0ð ð !¥$ ~Ñ"6Ô"6ð ð d 9™oœoð ð t Iµ¸± ´ Ñ$=Ñ>Ô>ð! ð" fð# ð$JPÐS`ÒI`ÐI`ÐeiÐjyÔezðGòfGðfGÐEÐEð}CðGTò}Tð}TðNyðNyðZ\Ø$*Ø˜wœ-Ý˜dŸhšh {Ñ3Ô3Ñ4Ô4Ý"%Ð&6×&:Ò&:¸;ÍÉÌÑ&NÔ&NÑ"OÔ"Oð- ð ð ñ ô ð ñ ð0‡L‚LðTðTðTðT€LñUôUðUð ØVÐVÐVÐVÐVÐVØyÐyÐ=WÐ=WÐX\ÐcgÐ=hÑ=hÔ=h×=lÒ=lÐmsÐuwÑ=xÔ=xÐyÑyÔyˆØð ñ ˆCØ%×)Ò)¨#¨mÔ*<Ñ=Ô=ˆHØð ˜sŸwšw Ñ7Ô7¸9ÒDÐDØØJŠJðØ §¢Ð-?Ñ @Ô @ðà˜xŸ|š|Ð,=Ñ>Ô>ðð §¢Ð.LÑ!MÔ!Mðð" 8§<¢<Ð0EÑ#FÔ#Fð ð # H§L¢LÐ1JÑ$KÔ$Kðð& x§|¢|Ð4MÑ'NÔ'Nð ð'¨¯ªÐ5KÑ(LÔ(Lðð*¨8¯<ª<Ð8WÑ+XÔ+Xðð! (§,¢,Ð/GÑ"HÔ"Hðð¨x¯|ª|¸HÑ/EÔ/EÈÒ/WÐ/W˜#Ÿ'š' (Ñ+Ô+Ð+Ð^f×^jÒ^jÐksÑ^tÔ^tð_JÐx{×xÒxðAIñyJôyJðð$ X§\¢\Ð2EÑ%FÔ%Fðð)¨(¯,ª,Ð7OÑ*PÔ*Pðð §¢¨oÑ!>Ô!>ðð$ X§\¢\Ð2EÑ%FÔ%Fðð,¨X¯\ª\Ð:UÑ-VÔ-Vðð +¨H¯LªLÐ9SÑ,TÔ,Tð!ð"+¨H¯LªLÐ9SÑ,TÔ,Tð#ð$3°H·L²LÐAcÑ4dÔ4dð%ðñ ô ð ñ ð øõ0ð ð ð Øˆð øøøà€NsØ+Ibâ b âb có´—|r|rt|¦«dkrtd¦«‚| d|f¦« ¦«}|std¦«‚|dd…}| d||f¦« ¦«}td„|D¦«t d¦«¦«}| d ||f¦« ¦«}td „|D¦«t d¦«¦«}||z } |dkrt d¦«n| |zt d¦«z} tt|d ¦«||¦«\}}i} |D]|}t|dp|dp |dpd¦«}| |t d¦«¦«t t|dp |dpd¦«¦«z| |<Œ}g}t| ¦«d„d¬¦«D]b\}}|dkrt d¦«n||zt d¦«z}| |t|¦«t|¦«dœ¦«Œcg}|D]X}t|¦«}t|dpd¦«|d<t!|d¦«|d<| |¦«ŒY|t|d¦«t|d ¦«|t|¦«t|¦«t| ¦«t| ¦«||t#d„|D¦«¦«rdnd||d|›d|›d |›d!œS)"Nr½z*category_id and month YYYY-MM are requiredzRSELECT category_id, name, category_type FROM budget_categories WHERE category_id=?zcategory not foundézz SELECT * FROM budget_plan_items WHERE is_active=1 AND category_id=? AND substr(plan_month,1,4)=? c3ó4K—|]}t|¦«V—ŒdSrí)r#)r2Úps rú z,get_category_month_detail..Es+èè€ÐCÐC°AÕ,¨QÑ/Ô/ÐCÐCÐCÐCÐCÐCrra SELECT t.*, a.name AS account_name, c.name AS category_name, COALESCE(li.line_item_count, 0) AS line_item_count FROM budget_transactions t JOIN budget_accounts a ON a.budget_account_id=t.account_id LEFT JOIN budget_categories c ON c.category_id=t.category_id LEFT JOIN ( SELECT transaction_candidate_id, COUNT(*) AS line_item_count FROM budget_import_line_items GROUP BY transaction_candidate_id ) li ON li.transaction_candidate_id=t.source_candidate_id WHERE t.status='confirmed' AND t.category_id=? AND substr(t.transaction_date,1,7)=? AND t.transaction_type IN ('expense','fee','income','refund') ORDER BY t.transaction_date, t.created_at c3ónK—|]0}tt|dp |dpd¦«¦«V—Œ1dS)rrrNrr1s rr z,get_category_month_detail..XsGèè€Ð`Ð`ÐST•'#˜a œoÐL°Ð3DÔ1EÐLÈÑMÔMÑNÔNÐ`Ð`Ð`Ð`Ð`Ð`rrÚ100rwÚpayeeÚaccount_nameÚsource_typeÚQuellerrcó—|dS)Nrqr\)Úkvs rr^z+get_category_month_detail..as €¸rÀ!¼u€rTr_)r«rÚ share_percentÚline_item_countÚarticle_rows_detail_onlyr¾c3ó&K—|]}|dV—Œ dS)r Nr\r1s rr z,get_category_month_detail..us&èè€Ð+HÐ+H¸1¨A¨g¬JÐ+HÐ+HÐ+HÐ+HÐ+HÐ+HrÚmerchantÚsourcez&/planning/budget/expenses/actual?year=z&month=z &category_id=)r0rÁrwrrr£r¥Údifference_percentr¦r§Úbreakdown_modeÚ breakdownÚtransactionsÚexpense_filter_url)rQÚ ValueErrorrrr5ÚsumrrŽr r=Úsortedrïr?r+r rerîÚany)rr0rr÷rmrôrrõr†Ú differenceÚdiff_pctr¦r¬rörr«rr&Úsharerrjs rÚget_category_month_detailr%7s½€ØðG˜eðG¥s¨5¡z¤z°A¢~ ~ÝÐEÑFÔFÐFØ ,Š,ÐkÐnyÐm{Ñ |Ô |÷FòFñHôH€CØð/ÝÐ-Ñ.Ô.Ð.Ø!Œ9€DØ—’ð ð dÐñô÷‚hj„jð õÐCÐC¸ÐCÑCÔCÅWÈSÁ\Ä\ÑRÔR€LØlŠlð ð eÐñ!ô÷"‚hj„jð#õ$Ð`Ð`ÐX_Ð`Ñ`Ô`ÕbiÐjmÑbnÔbnÑ oÔ o€FØ˜,Ñ&€JØ+¨qÒ0Ð0ws‰|Œ|ˆ|°zÀLÑ7PÕSZÐ[`ÑSaÔSaÑ7a€HÝ!¥# c¨/Ô&:Ñ";Ô";¸VÀ\ÑRÔRM€FˆEØ"$€GØð}ð}ˆÝC˜”LÐY C¨Ô$7ÐY¸3¸}Ô;MÐYÐQYÑZÔZˆØ Ÿš UG°C©L¬LÑ9Ô9½GÅCÈÈLÔHYÐHzÐ]`ÐarÔ]sÐHzÐwzÑD{ÔD{Ñ<|Ô<|Ñ|ˆ‰ˆØ€IÝ˜wŸ}š}™œÐ4DÐ4DÈdÐSÑSÔSðdðd‰ˆˆuØ &¨!¢ •˜‘”°%¸&±.Å7È5Á>Ä>Ñ2QˆØ×Ò 5½¸U¹¼ÕVZÐ[`ÑVaÔVaÐbÐbÑcÔcÐcÐcØ€LØð"ð"ˆÝ˜3ÑÔˆÝ"% cÐ*;Ô&<Ð&AÀÑ"BÔ"BˆÐ ÑÝ+/°Ð5FÔ0GÑ+HÔ+HˆÐ 'Ñ(Ø×Ò˜DÑ!Ô!Ð!Ð!à"Ý˜˜FœÑ$Ô$Ý˜S Ô1Ñ2Ô2ØÝ˜\Ñ*Ô*Ý˜6‘l”lÝ˜zÑ*Ô*Ý" 8™nœnØØÝ(+Ð+HÐ+HÀÐ+HÑ+HÔ+HÑ(HÔ(HÐV˜*˜*ÈhØØ$ØuÀtÐuÐuÐTYÐuÐuÐhsÐuÐuðððrcóò‡—| d‰f¦« ¦«}g}|D]•}tt|dpd¦«¦«}tt|dpd¦«¦«}| ‰|dt|¦«t|¦«t||z ¦«dœ¦«Œ–t |‰¬¦«}ˆfd„|D¦«}d „|D¦«} ‰|||| d œS)Na SELECT substr(transaction_date,1,7) AS month, SUM(CASE WHEN transaction_type IN ('income','refund') THEN CAST(COALESCE(amount_chf, amount_original, '0') AS REAL) ELSE 0 END) AS income, SUM(CASE WHEN transaction_type IN ('expense','fee') THEN CAST(COALESCE(amount_chf, amount_original, '0') AS REAL) ELSE 0 END) AS expense FROM budget_transactions WHERE status='confirmed' AND substr(transaction_date,1,4)=? GROUP BY substr(transaction_date,1,7) ORDER BY month rIrrLr)rmrrMrNrOr¯cóz•—g|]7}‰|d|d|d|d|d|d|ddœ‘Œ8S)r0rÁrwrxrÉryr¦)rmr0rÁrwrxrÉryr¦r\)r2r3rms €rrcz*get_budget_charts_2026..ŽsŸø€ðððà ð a¨ Ô&6ÀAÀjÄMÐdeÐfuÔdvðHIðJWôHXðqrðsHôqIð\]ð^mô\nðz{ð|DôzEð Fð Fðððrcó&—g|]}|ddv¯|‘ŒS)r¦>r‚rƒr\r1s rrcz*get_budget_charts_2026..’s'€ÐRÐRÐRa¨q°¬{Ð>QÐ/QÐ/QÐ/QÐ/QÐ/Qr)rmÚempty_stateÚcashflow_by_monthÚbudget_vs_actual_by_categoryÚforecast_overruns)rr5rr r?r+r) rrmÚ cash_rowsÚcashflowr3rIrLÚstatus_rowsÚbudget_vs_actualÚoverrunss ` rÚget_budget_charts_2026r2|sgø€Ø—’ð ð ˆñô÷‚hj„jðð€HØ ðcðcˆÝ˜Q˜xœ[Ð-¨AÑ.Ô.Ñ/Ô/ˆ½7Å3ÀqÈÄ|ÐGXÐWXÑCYÔCYÑ;ZÔ;Z°ØŠ °°'´ Í$ÈvÉ,Ì,ÕgkÐlsÑgtÔgtõKOðPVðY`ñP`ñKaôKaðbðbñ cô cð cð cÝ/°¸4Ð@Ñ@Ô@€KððððàðñôÐðSÐRÐ+ÐRÑRÔR€HàØ#|Ø%Ø(8Ø%ðððrc óT‡ ‡—d„t||¬¦«D¦«Šdˆfd„}|d¦«}|d ¦«}|d ¦«}|d¦«}ttj¦«j¦«|krtj¦«jd›nd Š t ˆ fd„‰D¦«td¦«¦«}||z }|r|td ¦«zntd¦«} ||z } td|||td„‰D¦«d¬¦«¦«}|dkrd}n| dkr| dkrdnd}nd}|t|¦«t|¦«t| ¦«t|¦«t|¦«t|¦«t|¦«t| ¦«||‰dœS)Ncó*—g|]}|ddk¯|‘ŒS)rwrIr\r1s rrcz%get_income_status..s(€ÐhÐhÐh!ÈÈ?ÔI[Ð_gÒIgÐIgˆAÐIgÐIgÐIgrr¯r`r rrcóX•‡—tˆfd„‰D¦«td¦«¦«S)Nc3ó`•K—|](}tt|‰pd¦«¦«V—Œ)dS)rNr)r2r3r`s €rr z/get_income_status..s..Ÿs;øèè€Ð>Ð>°A•GC #¤ ¨#Ñ.Ô.Ñ/Ô/Ð>Ð>Ð>Ð>Ð>Ð>rr)rr)r`r6s`€rÚszget_income_status..sžs/øø€ÝÐ>Ð>Ð>Ð>¸Ð>Ñ>Ô>ÅÈÁÄÑMÔMÐMrrrxryrÉr r!c 3ó¢•K—|]I}tt| d¦«pi ‰d¦«¦«¦«V—ŒJdS)r·rN)rr r=)r2r3rs €rr z$get_income_status..¥sXøèè€ÐxÐxÐno¥¨Q¯UªUÐ3DÑ-EÔ-EÐ-KÈ×,PÒ,PÐQaÐcfÑ,gÔ,gÑ(hÔ(hÑ iÔ iÐxÐxÐxÐxÐxÐxrrrIc3ó@K—|]}t|d¦«V—ŒdS)rnN)rer1s rr z$get_income_status..©s2èè€ÐLzÐLzÐpqÍSÐQRÐSiÔQjÑMkÔMkÐLzÐLzÐLzÐLzÐLzÐLzrr)ÚdefaultzNoch keine Ist-DatenzIm Planu Ãœber Planz Unter Plan)rmÚplanned_income_monthÚplanned_income_yearÚplanned_income_monthly_averageÚactual_income_current_monthÚactual_income_year_to_dateÚforecast_income_yearÚdeviation_current_monthrÑr¦Ústatus_labelÚ categories)r`r rr)rr rrrrmrrrr…rsr+)rrmr7rrxryrzrÈrAÚplanned_monthly_averagerÑr¦rBrr6s @@rÚget_income_statusrEœs0øø€ØhÐhÕ4°TÀÐEÑEÔEÐhÑhÔh€DðNðNðNðNðNðNà1^Ñ$Ô$€LØ!MÑ"Ô"€KØAoÑ&Ô&€MØ!Ð)Ñ*Ô*€KÝ69½$¼*¹,¼,Ô:KÑ6LÔ6LÐPTÒ6TÐ6T$œ*™,œ,Ô,Ð2Ð2Ð2ÐZ^ÐÝÐxÐxÐxÐxÐswÐxÑxÔxõ{BðCFñ{Gô{GñHôHÐØ2°\ÑAÐØ=HÐZ˜kG°D©M¬MÑ9Ð9ÍgÐVYÉlÌlÐØ ;Ñ.€NÝ X˜{¨M¸;ÍÐLzÐLzÐuyÐLzÑLzÔLzðEFðIGñIGôIGñHôH€FØaÒÐØ-ˆˆØ ˜1Ò Ð Ø$2°aÒ$7Ð$7yy¸\ˆˆà#ˆàÝ $ \Ñ 2Ô 2Ý# KÑ0Ô0Ý*.Ð/FÑ*GÔ*GÝ'+Ð,@Ñ'AÔ'AÝ&*¨;Ñ&7Ô&7Ý $ ]Ñ 3Ô 3Ý#'Ð(?Ñ#@Ô#@Ý˜~Ñ.Ô.ØØ$Øð ð ð rc ó¼—|pt|¦«}|dd…}t||¦«}| d|f¦« ¦«}| d|f¦« ¦«d}| d¦« ¦«d}| d|f¦« ¦«d}td„|D¦«¦«}t ||¬¦«} td „| D¦«td ¦«¦«} td„| D¦«td ¦«¦«}tt|d¦«¦«}tt|d ¦«¦«} | |z }|| z }|| z }td„| D¦«¦«}d„|D¦«}ddl m }|||›d¬¦«}| di¦«}d|i|¥idt|¦«“d|“dt|¦«“dt|¦«“dt| ¦«“dt|¦«“dt|¦«“dt|¦«“dt| ¦«“dt|¦«“d|“d | d!d"¦«“d#| d#d"¦«“d$| d%d¦«“d&| d'd¦«“d(t|¦«“d)t|¦«“¥| sd*n |sd+n |dkrd,nd-|sd.nd/| |t||¦«dd0…t|¦«dd1…d2œ¥S)3NrrGai SELECT COUNT(*) FROM budget_transactions t LEFT JOIN budget_transaction_tags tt ON tt.budget_transaction_id=t.budget_transaction_id LEFT JOIN budget_tags tag ON tag.tag_id=tt.tag_id WHERE t.status='confirmed' AND substr(t.transaction_date,1,7)=? AND (t.category_id IS NULL OR tag.name='Review' OR t.fx_status='missing') rzjSELECT COUNT(*) FROM budget_seed_candidates WHERE status IN ('pending','needs_review','edited','accepted')z€SELECT COUNT(*) FROM budget_transaction_candidates WHERE substr(transaction_date,1,4)=? AND status IN ('pending','needs_review')c3ó>K—|]}|d |ddv¯dV—ŒdS)r0NrH>rKrIrJrLrqr\r1s rr z&get_budget_overview..Ðseèè€ðIðI˜a¨1¨]Ô+;Ð+CÈÐJ\ÔH]ðbHðIHðIH˜ðIHðIHðIHðIHðIðIrr¯c3óvK—|]4}|ddk¯tt|dpd¦«¦«V—Œ5dS)rwrIrrNrr1s rr z&get_budget_overview..ÒsNèè€ÐxÐxÀQÐYZÐ[jÔYkÐowÒYwÐYw'¥# a¨Ô&7Ð&>¸3Ñ"?Ô"?Ñ@Ô@ÐYwÐYwÐYwÐYwÐxÐxrrc3óvK—|]4}|ddk¯tt|dpd¦«¦«V—Œ5dS)rwrLrrNrr1s rr z&get_budget_overview..ÓsNèè€ÐzÐzÀaÐZ[Ð\kÔZlÐpyÒZyÐZy7¥3 q¨Ô'8Ð'?¸CÑ#@Ô#@ÑAÔAÐZyÐZyÐZyÐZyÐzÐzrrMrNc3ó2K—|]}|ddk¯dV—ŒdS)r¦r}rqNr\)r2rjs rr z&get_budget_overview..Ùs1èè€ÐaÐa T¸DÀ¼NÐN`Ò<`Ð<`˜qÐ<`Ð<`Ð<`Ð<`ÐaÐarcóP—g|]#}|d |ddv¯t|¦«‘Œ$S)r0NrH>rKrIrJrLrr1s rrcz'get_budget_overview..Ús[€ðXðXðX¨Q¸!¸MÔ:JÐ:RÐWXÐYkÔWlðqWðXWðXW+ a™.œ.ðXWðXWðXWr)Úget_recurring_dashboardz-28)rrÚkpisÚ current_monthÚreview_countÚuncategorized_countÚpending_seed_candidate_countÚ#pending_transaction_candidate_countÚplanned_income_chfÚplanned_expense_chfÚplanned_net_chfÚactual_income_chfÚactual_expense_chfÚactual_net_chfÚopen_categories_without_actualsÚfixed_costs_month_chfÚmonthly_fixed_costs_chfz0.00rëÚopen_fixed_cost_candidate_countÚopen_candidate_countÚ missing_fixed_cost_payment_countÚmissing_payment_countÚplanned_budget_chfÚremaining_budget_chfÚno_plansÚ no_actualsÚover_budgetÚokznoch keine BuchungenzBuchungen vorhandenr¼é)Ú budget_statusÚ actuals_labelÚbudget_categoriesÚuncategorized_transactionsÚtop_categoriesÚrecent_transactions)rrTrr5rrrrr Ú(jarvis_finance.services.budget_recurringrLr=rer+rlr )rrrmrr6rOÚpending_seed_countÚpending_tx_candidatesÚ uncategorizedr/Úplanned_incomeÚplanned_expenseÚ actual_incomeÚactual_expenseÚplanned_netÚ actual_netÚremaining_totalÚopen_without_actualsÚuncategorized_rowsrLÚ recurringÚrecurring_kpiss rÚget_budget_overviewr|ÀsÜ€ØÐ)•^ DÑ)Ô)€EØ!Œ9€DÝ! $¨Ñ.Ô.€GØ<Š<ÐwÐzðzBñCôC÷LòLñNôN€DØ—<’<ð ð ˆñô÷‚hj„jô€LðŸšð'SñTôT÷]ò]ñ_ô_ð`aôbÐØ ŸLšLð*lðosðnuñvôv÷òñAôAðBCôDÐÝðIðI 4ðIñIôIñIôI€MÝ/°¸4Ð@Ñ@Ô@€KÝÐxÐxÈ+ÐxÑxÔxõ{BðCFñ{Gô{GñHôH€NÝÐzÐzÈ;ÐzÑzÔzõ}DðEHñ}Iô}IñJôJ€OÝC ¨Ô 5Ñ6Ô6Ñ7Ô7€MÝS ¨Ô!7Ñ8Ô8Ñ9Ô9€NØ ?Ñ2€KØ Ñ/€JØ%¨Ñ6€OÝÐaÐa¨[ÐaÑaÔaÑaÔaÐðXðX°$ðXñXôXÐØPÐPÐPÐPÐPÐPØ'Ð'¨°u°M°M°MÐBÑBÔB€IØ—]’] 6¨2Ñ.Ô.€Nà˜ðà ððð ˜LÑ)Ô)ðð ˜}ð ð 'Ð,>Ñ(?Ô(?ðð .sÐ3HÑ/IÔ/Ið ð d >Ñ2Ô2ðð t OÑ4Ô4ðð 4 Ñ,Ô,ðð T -Ñ0Ô0ðð d >Ñ2Ô2ðð $˜zÑ*Ô*ðð *Ð+?ðð ×!3Ò!3Ð4MÈvÑ!VÔ!Vðð # N×$6Ò$6Ð7QÐSYÑ$ZÔ$Zðð *¨>×+=Ò+=Ð>TÐVWÑ+XÔ+Xð!ð" +¨N×,>Ò,>Ð?VÐXYÑ,ZÔ,Zð#ð$ d ?Ñ3Ô3ð%ð& ¥ _Ñ 5Ô 5ð'ðð(,7ðM˜˜ÐQUð>L¸\¸\Ðm|ð@AònAðnAÐ\iÐ\iðGKØ7;ÐVÐ/Ð/ÐAVØ(Ø&8Ý.¨t°UÑ;Ô;¸B¸Q¸BÔ?Ý7¸Ñ=Ô=¸b¸q¸bÔAð3ðððr)rrrr )rr)r&rrr )rrrr,)r0r8r9r,rr:rí)rrrr8rrE)rrrr8rrU)rmr rnrerre)rwr rxrryrrzrrnrerr )rwr r†rr‡rrrˆ) rwr rmr rrrr‘rrU)rrrmr rrU)rrr0r rr rrE)rrrmr rrE)Ú __future__rÚdatetimerÚdecimalrÚsqlite3rÚ%jarvis_finance.services.budget_commonr Ú+jarvis_finance.services.budget_transactionsr rrr#r%r+r7rDrTrlrvr…rŽrrr%r2rEr|r\rrúrƒsFðØ"Ð"Ð"Ð"Ð"Ð"àÐÐÐÐÐØÐÐÐÐÐØÐÐÐÐÐà=Ð=Ð=Ð=Ð=Ð=ØPÐPÐPÐPÐPÐPðHðHðHðHðLðLðLðLððððððððð8ð8ð8ð8ðAðAðAðAð ð ð ð ðkðkðkðkðkðHðHðHðHðHð8?ð?ð?ð?ððððð*ðððð&ðððð&DJðGðGðGðGðGðGðTBðBðBðBðJ=Cððððððð@8>ð!ð!ð!ð!ð!ð!ðH8ð8ð8ð8ð8ð8ð8r