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()