def sumAll(where=None):
bd = Bbdd()
data = bd.sum("movement", "money", where)
if where is None:
profit = bd.sum("bet", "profit")
data += profit
elif where[0] == "b":
profit = bd.sum("bet", "profit", where)
data += profit
bd.close()
return data
def initTree(self):
bd = Bbdd()
money = {}
data = bd.select("conjunta")
for i in data:
data2 = bd.select("conjunta_tipster", None,
"conjunta=" + str(i[0]))
if len(data2) > 1:
money_tipster = i[4] / len(data2)
for j in data2:
try:
money[j[1]] += money_tipster
except:
money[j[1]] = money_tipster
data = bd.select("tipster", "name")
items = []
for i in data:
id = i[0]
name = i[1]
cost = bd.sum("tipster_month", "money", "tipster=" + str(id))
if id in money.keys():
cost += money[id]
profit = bd.sum("bet", "profit", "tipster=" + str(id))
balance = profit - cost
if cost == 0:
cost = "--" + self.coin
else:
cost = "{0:.2f}".format(cost) + self.coin
profit = "{0:.2f}".format(profit) + self.coin
balance = "{0:.2f}".format(balance) + self.coin
item = QTreeWidgetItem([name, str(id), cost, profit, balance])
item = paint_row(item, balance)
items.append(item)
self.treeMain.addTopLevelItems(items)
bd.close()
def initData(self):
self.txtDeposit.setText("{0:.2f}".format(Bookie.sumAll("money>0")) +
self.coin)
self.txtTakeOut.setText("{0:.2f}".format(Bookie.sumAll("money<0")) +
self.coin)
bookies = Bookie.sumAll()
bonus = Bookie.sumBonus()
self.txtBonus.setText("{0:.2f}".format(bonus) + self.coin)
self.txtBookie.setText("{0:.2f}".format(bookies + bonus) + self.coin)
bd = Bbdd()
tipsters = bd.sum("tipster_month", "money")
conjuntas = bd.sum("conjunta", "money")
self.txtTipster.setText("-" + str(tipsters + conjuntas) + self.coin)
profits = bd.sum("bet", "profit") + bonus
self.txtProfit.setText("{0:.2f}".format(profits - tipsters -
conjuntas) + self.coin)
bets = bd.sum("bet", "bet")
try:
yields = "{0:.2f}%".format((profits / bets) * 100)
except ZeroDivisionError:
yields = "0.0%"
self.txtYield.setText(yields)
# CC
cc = bd.select("bank", None, "id=1", "bank")
cc = cc[0][0]
self.txtCc.setText("{0:.2f}".format(cc) + self.coin)
# Paypal
paypal = bd.select("bank", None, "id=2", "bank")
paypal = paypal[0][0]
self.txtPaypal.setText("{0:.2f}".format(paypal) + self.coin)
# SKRILL
skrill = bd.select("bank", None, "id=3", "bank")
skrill = skrill[0][0]
self.txtSkrill.setText("{0:.2f}".format(skrill) + self.coin)
total = "{0:.2f}".format(cc + paypal + skrill + bonus + bookies)
self.txtTotal.setText(total + self.coin)
def sumBonus(where=None):
bd = Bbdd()
if where:
where = "free='True' and " + where
else:
where = "free='True' "
data = bd.sum("bonus", "money", where)
bd.close()
return data
def initTree(self):
bd = Bbdd()
money = {}
data = bd.select("conjunta")
for i in data:
data2 = bd.select("conjunta_tipster", None,
"conjunta=" + str(i[0]))
if len(data2) > 1:
money_tipster = i[4] / len(data2)
for j in data2:
try:
money[j[1]] += money_tipster
except:
money[j[1]] = money_tipster
data = bd.select("tipster", "name")
index = 0
items = []
for i in data:
index += 1
id = i[0]
name = i[1]
cost = bd.sum("tipster_month", "money", "tipster=" + str(id))
if id in money.keys():
cost += money[id]
cost = "{0:.2f}".format(cost)
profit = bd.sum("bet", "profit", "tipster=" + str(id))
profit = "{0:.2f}".format(profit)
item = QTreeWidgetItem([str(index), str(id), name, cost, profit])
items.append(item)
self.treeMain.addTopLevelItems(items)
bd.close()
