summaryrefslogtreecommitdiff
path: root/rust/schist_queries/src/utils/calculate_budgets_accrual.rs
blob: 1d4ed02579ac3bfa14022398bb280cda041ff79f (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
use anyhow::Result;
use schist_models::{
    budget_update::BudgetUpdate, category::Category, date_utc::DateUtc,
};
use schist_traits::nowlike::Nowlike;

pub fn calculate_budgets_accrual(category: &Category, budget_updates: &[BudgetUpdate]) -> Result<i64> {
    let mut budget_updates = budget_updates
        .iter()
        .filter(|bu| bu.category_id == category.id)
        .collect::<Vec<&BudgetUpdate>>();
    budget_updates.sort_by_key(|bu| bu.date.clone());
    budget_updates.reverse();

    let mut budgets_accrual = 0.0_f64;
    let mut calculated_back_to_date = DateUtc::now();

    for budget_update in budget_updates {
        let days_on_this_budget = calculated_back_to_date.day_diff(&budget_update.date);
        if days_on_this_budget == 0_u32 {
            return Err(anyhow::Error::msg(format!(
                "failed to calculate budgets accrual since two budget updates had the same date ({})",
                budget_update.date,
            )));
        }
        let budget_per_day = budget_update.new_budget as f64 / budget_update.new_period as f64;
        budgets_accrual += days_on_this_budget as f64 * budget_per_day;
        calculated_back_to_date = budget_update.date.clone();
    }

    Ok(budgets_accrual.floor() as i64)
}

#[cfg(test)]
mod test {
    use chrono::{Days, Utc};
    use schist_models::{budget_update::BudgetUpdate, category::Category, date_utc::DateUtc};
    use schist_traits::nowlike::Nowlike;

    use super::calculate_budgets_accrual;

    #[test]
    fn when_no_budget_updates_then_return_zero() {
        let category = Category {
            id: 0,
            name: String::from("Groceries"),
        };
        let budget_updates = [];

        let result = calculate_budgets_accrual(&category, &budget_updates);

        assert!(result.is_ok());
        assert_eq!(result.unwrap(), 0_i64);
    }

    #[test]
    fn when_one_budget_update_for_another_category_then_return_zero() {
        let category = Category {
            id: 0,
            name: String::from("Groceries"),
        };
        let budget_updates = [BudgetUpdate {
            id: 0,
            category_id: 1,
            date: DateUtc::now(),
            new_budget: 100,
            new_period: 1,
        }];

        let result = calculate_budgets_accrual(&category, &budget_updates);

        assert!(result.is_ok());
        assert_eq!(result.unwrap(), 0_i64);
    }

    #[test]
    fn when_one_budget_update_then_return_quantity_times_days_in_past() {
        let category = Category {
            id: 0,
            name: String::from("Groceries"),
        };
        let budget_updates = [BudgetUpdate {
            id: 0,
            category_id: 0,
            date: DateUtc::from(Utc::now().checked_sub_days(Days::new(120)).unwrap()),
            new_budget: 100,
            new_period: 1,
        }];

        let result = calculate_budgets_accrual(&category, &budget_updates);

        assert!(result.is_ok());
        assert_eq!(result.unwrap(), 12_000);
    }

    #[test]
    fn when_two_budget_updates_then_calculates_as_expected() {
        let category = Category {
            id: 0,
            name: String::from("Groceries"),
        };
        let budget_updates = [
            BudgetUpdate {
                id: 0,
                category_id: 0,
                date: DateUtc::from(&Utc::now().checked_sub_days(Days::new(60)).unwrap()),
                new_budget: 200,
                new_period: 1,
            },
            BudgetUpdate {
                id: 0,
                category_id: 0,
                date: DateUtc::from(&Utc::now().checked_sub_days(Days::new(120)).unwrap()),
                new_budget: 100,
                new_period: 1,
            },
        ];

        let result = calculate_budgets_accrual(&category, &budget_updates);

        assert!(result.is_ok());
        assert_eq!(result.unwrap(), 18_000);
    }

    #[test]
    fn when_two_budget_updates_on_same_day_then_returns_err() {
        let category = Category {
            id: 0,
            name: String::from("Groceries"),
        };
        let budget_updates = [
            BudgetUpdate {
                id: 0,
                category_id: 0,
                date: DateUtc::from_ymd(2020, 12, 25).unwrap(),
                new_budget: 200,
                new_period: 1,
            },
            BudgetUpdate {
                id: 0,
                category_id: 0,
                date: DateUtc::from_ymd(2020, 12, 25).unwrap(),
                new_budget: 100,
                new_period: 1,
            },
        ];
        let mut budget_updates_reversed = budget_updates.clone();
        budget_updates_reversed.reverse();

        let result_leftways = calculate_budgets_accrual(&category, &budget_updates);
        let result_rightways = calculate_budgets_accrual(&category, &budget_updates_reversed);

        assert!(result_leftways.is_err());
        assert!(result_rightways.is_err());
    }
}