EDropScrap/StatCounter.py at master · spec45as/EDropScrap · 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
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
157
from MySql import MySqlManager


def printStats(isDota):
    sqlConfig = {}
    if isDota:
        # Just for tests, don't care guys
        sqlConfig['user'] = '046440198_dota'
        sqlConfig['password'] = '046440198_dota'
        sqlConfig['host'] = 'mysql.id222383009-0.myjino.ru'
        sqlConfig['database'] = 'id222383009-0_dota'
    else:
        # Just for tests, don't care guys
        sqlConfig['user'] = '046440198_easydr'
        sqlConfig['password'] = '046440198_easydr'
        sqlConfig['host'] = 'mysql.id222383009-0.myjino.ru'
        sqlConfig['database'] = 'id222383009-0_easydr'

    mysqlManager = MySqlManager(sqlConfig)
    allCategories = mysqlManager.getAllCategories()
    allItems = mysqlManager.getAllItems()
    allUsers = mysqlManager.getAllUsers()

    allCategoriesInfo = {}

    overallCompanyProfit = 0
    overallQuantity = 0

    for category in allCategories:
        categoryPrice = allCategories[category].price
        overallPrice = 0
        averagePrice = 0
        quantity = 0
        companyProfit = 0
        chance = 0.0
        profitable = 0.0
        looses = 0
        wins = 0
        items = []

        for item in allItems:
            if allItems[item].category == category:
                if allItems[item].price >= categoryPrice:
                    wins += allItems[item].quantity
                else:
                    looses += allItems[item].quantity

                quantity = quantity + allItems[item].quantity

                items.append(allItems[item])
                overallPrice = overallPrice + allItems[item].price * allItems[item].quantity

        groupedItems = {}
        for curItem in items:
            currentIndex = curItem.nameMD5
            if groupedItems.get(currentIndex, None) is None:
                groupedItems[currentIndex] = curItem
            else:
                groupedItems[currentIndex].quantity = groupedItems[currentIndex].quantity + curItem.quantity
                groupedItems[currentIndex].price = groupedItems[currentIndex].price + curItem.price

        for curItem in groupedItems:
            groupedItems[curItem].price = float(
                "{0:.1f}".format(float(groupedItems[curItem].price / groupedItems[curItem].quantity)))

        if quantity != 0:
            averagePrice = float("{0:.2f}".format(float(overallPrice / quantity)))
            companyProfit = categoryPrice * quantity - overallPrice
            profitable = float("{0:.2f}".format(float(averagePrice / categoryPrice * 100.0)))
            chance = float("{0:.2f}".format(float(wins / quantity * 100.0)))
            overallCompanyProfit = companyProfit + overallCompanyProfit
            overallQuantity = quantity + overallQuantity

            values = {}
            values['name'] = allCategories[category].categoryName
            values['categoryPrice'] = categoryPrice
            values['quantity'] = quantity
            values['looses'] = looses
            values['wins'] = wins
            values['averagePrice'] = averagePrice
            values['overallPrice'] = overallPrice
            values['companyProfit'] = companyProfit
            values['profitable'] = profitable
            values['chance'] = chance
            values['items'] = groupedItems

            allCategoriesInfo[allCategories[category].indexName] = values

    sortedAllCategoriesInfo = sorted(allCategoriesInfo, key=lambda dict: allCategoriesInfo[dict]['profitable'],
                                     reverse=True)


    def printOverallData():
        print('\nИтоговая прибыль компании easydrop.ru составила ' + str(overallCompanyProfit) + ' руб')
        print('Всего в базе ' + str(len(allUsers)) + ' игроков')
        print('Общее количество посчитанных дропов ' + str(overallQuantity) + ' штук\n')


    print('\n===================Начало вывода статистики===================\n')

    printOverallData()

    for currentCategory in sortedAllCategoriesInfo:
        currentCategoryDict = allCategoriesInfo[currentCategory]
        # №if currentCategoryDict['quantity'] < 50:
        #   continue
        print(currentCategoryDict['name'] + ' - Цена открытия: ' + str(currentCategoryDict['categoryPrice']) + ' руб.')
        print("Подробная информация о кейсе:")
        print('Этот кейс открыли как минимум ' + str(currentCategoryDict['quantity']) + ' раз')
        print('Из них выиграло ' + str(currentCategoryDict['wins']) + ' раз')
        print('Проиграло ' + str(currentCategoryDict['looses']) + ' раз')
        print('Выпавшие вещи в этом кейсе стоят в среднем ' + str(currentCategoryDict['averagePrice']) + ' руб.')
        print('В сумме вещей в этом кейсе выпало на ' + str(currentCategoryDict['overallPrice']) + ' руб.')
        print('В сумме easydrop заработал на этом кейсе ' + str(currentCategoryDict['companyProfit']) + ' руб.')
        print('Окупаемость в этом кейсе: ' + str(currentCategoryDict['profitable']) + '%')
        print('Шанс на выпадение окупаемой вещи в этом кейсе: ' + str(currentCategoryDict['chance']) + '%')

        print('\nПодробная статистика:\n')
        print('{name: <50}   {count}     {price}      {chance}'.format(name='Название', count='Кол-во', price='Цена',
                                                                       chance='Шанс'))
        print('================================================================================')
        sortedAllItems = sorted(currentCategoryDict['items'],
                                key=lambda dict: currentCategoryDict['items'][dict].quantity / currentCategoryDict[
                                    'quantity'], reverse=True)

        for itemIndex in sortedAllItems:
            curItem = currentCategoryDict['items'][itemIndex]
            try:  # баги с кодировкой
                print('{name: <50} {count: >4} шт {price: >8} руб   {chance: >5}%'.format(name=curItem.name,
                                                                                          count=curItem.quantity,
                                                                                          price=curItem.price,
                                                                                          chance=float(
                                                                                              "{0:.3f}".format(float(
                                                                                                  curItem.quantity /
                                                                                                  currentCategoryDict[
                                                                                                      'quantity'] * 100.0)))))
            except:
                print('# Current Line Error #')
        print('================================================================================\n\n\n')

    printOverallData()
    print('\n===================Конец вывода статистики===================\n')


if __name__ == "__main__":
    while True:
        print('1 - Dota 2\n2 - CS:GO')
        gameCommand = input("Введите число для дальнейших действий: ")
        if gameCommand == '1':
            printStats(True)
            break
        elif gameCommand == '2':
            printStats(False)
            break
        else:
            print('Неверная команда, попробуйте ещё раз')
            continue