Py_Expense_template/status.py at master · Nicolass67/Py_Expense_template · GitHub

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
from PyInquirer import prompt
import csv
import json

def show_status():

    f = open("expense_report.csv", "r")
    u = open("users.csv", 'r')

    myReaderU = csv.reader(u)
    users = []

    for elem in myReaderU:
        users.append(elem[0])

    myReader = csv.reader(f)

    line_number = 0

    for row in myReader:
        participants = get_participants(line_number)

        spender = get_spender(line_number)

        price = get_price(line_number)

        doit_a = price/(len(participants) - 1)

        for elem in participants:
            if (elem != spender):
                print(elem + " doit " + str(doit_a) + " à " + spender)

        line_number += 1

    f.close

    return True

def get_participants(line_number):

    f = open("expense_report.csv", "r")

    myReader = csv.reader(f)

    participants = ""

    actual_line = 0

    for row in myReader:
        if (line_number == actual_line):
            participants += row[3]
        actual_line += 1

    participants_list = []
    for elem in participants.split("-"):
        participants_list.append(elem)


    f.close

    return participants_list

def get_spender(line_number):

    f = open("expense_report.csv", "r")

    myReader = csv.reader(f)

    spender = ""

    actual_line = 0

    for row in myReader:
        if (line_number == actual_line):
            spender += row[2]
        actual_line += 1

    f.close

    return spender


def get_price(line_number):

    f = open("expense_report.csv", "r")

    myReader = csv.reader(f)

    price = 0

    actual_line = 0

    for row in myReader:
        if (line_number == actual_line):
            price += int(row[0])
        actual_line += 1

    f.close

    return price