def export(self):
bd = Bbdd()
file = OrderedDict()
data = bd.select("bet")
dataOds = [[
"Fecha", "Deporte", "Competicion", "Región", "Local", "Visitante",
"Pick", "Casa", "Mercado", "Tipster", "Stake", "Unidad",
"Resultado", "Beneficio", "Apuesta", "Cuota", "Gratuita"
]]
for i in data:
row = []
row.append(i[1])
row.append(bd.getValue(i[2], "sport"))
row.append(bd.getValue(i[3], "competition"))
row.append(bd.getValue(i[4], "region"))
row.append(i[5])
row.append(i[6])
row.append(i[7])
row.append(bd.getValue(i[8], "bookie"))
row.append(bd.getValue(i[9], "market"))
row.append(bd.getValue(i[10], "tipster"))
row.append(i[11])
row.append(i[12])
row.append(i[13])
row.append(i[14])
row.append(i[15])
row.append(i[16])
row.append("No" if i[17] == 0 else "Sí")
dataOds.append(row)
bd.close()
file.update({"Apuestas": dataOds})
save_data(self.directory, file)
def initData(self):
bd = Bbdd()
name = bd.getValue(self.id, "tipster")
self.txtName.setText(name)
bd.close()
def initTree(self):
bd = Bbdd()
data = bd.select("tipster_month", "year, month")
items = []
for i in data:
id = i[0]
year = i[2]
month = numberToMonth(i[1]+1)
tipster = bd.getValue(i[3], "tipster")
money = i[4]
item = QTreeWidgetItem([str(id), str(year), str(month), str(tipster), str(money)])
items.append(item)
self.treeMain.addTopLevelItems(items)
data = bd.select("conjunta", "year, month")
if len(data) < 1:
self.lblConjunta.setVisible(False)
self.treeConjunta.setVisible(False)
else:
items = []
for i in data:
id = i[0]
year = i[3]
month = numberToMonth(i[2] + 1)
name = i[1]
money = i[4]
item = QTreeWidgetItem([str(id), str(year), str(month), str(name), str(money)])
items.append(item)
self.treeConjunta.addTopLevelItems(items)
bd.close()
def initData(self):
bd = Bbdd()
name = bd.getValue(self.id, "region")
self.txtRegion.setText(name)
bd.close()
def setCompetition(self):
self.cmbCompetition.clear()
bd = Bbdd()
idRegion = self.regionIndexToId.get(self.cmbRegion.currentIndex())
idSport = self.sportIndexToId.get(self.cmbSport.currentIndex())
where = "region=" + str(idRegion) + " AND sport=" + str(idSport)
data = bd.select("competition", "name", where)
index, idCmb = 0, 0
idBd = bd.getValue(self.id, "bet", "competition")
self.competitionIndexToId = {}
index = 0
for i in data:
id = i[0]
if id == idBd:
idCmb = index
name = i[1]
self.cmbCompetition.addItem(name)
self.competitionIndexToId[index] = id
index += 1
if index == 0:
self.btnAccept.setDisabled(True)
else:
self.btnAccept.setDisabled(False)
self.cmbCompetition.setCurrentIndex(idCmb)
bd.close()
def initTree(self):
self.treeBookie.clear()
data = Bookie.selectAll()
items = []
for i in data:
bank = Bookie.sumAll("bookie=" + str(i.id))
bank = 0.0 if bank is None else bank
bonus = Bookie.sumBonus("bookie=" + str(i.id))
bonus = 0.0 if bonus is None else bonus
bank += bonus
if 0.01 > bank > -0.01:
continue
item = QTreeWidgetItem(
[i.name, "{0:.2f}".format(bank) + self.coin])
items.append(item)
self.treeBookie.addTopLevelItems(items)
self.treeMovement.clear()
bd = Bbdd()
data = bd.select("movement", "date DESC")
items = []
for i in data:
id = i[0]
try:
sDate = datetime.strptime(i[1], "%d/%m/%y")
except:
sDate = datetime.strptime(i[1], "%d/%m/%Y") # Fix for Windows
sDate = date.strftime(sDate, "%Y/%m/%d")
account = i[2]
if account == 1:
account = "Banco"
elif account == 2:
account = "Paypal"
elif account == 3:
account = "Skrill"
bookie = bd.getValue(i[3], "bookie")
money = i[4]
if money < 0:
type = _("Withdrawal to the bank.")
else:
type = _("Deposit at bookie")
item = QTreeWidgetItem([
str(sDate),
str(id), bookie, type,
str(account),
str(money) + self.coin
])
items.append(item)
self.treeMovement.addTopLevelItems(items)
bd.close()
def initTree(self):
bd = Bbdd()
data = bd.select("competition", "name")
items = []
for i in data:
id = i[0]
name = i[1]
region = bd.getValue(i[2], "region")
sport = bd.getValue(i[3], "sport")
item = QTreeWidgetItem([str(name), str(id), region, str(sport)])
items.append(item)
self.treeMain.addTopLevelItems(items)
self.treeMain.sortByColumn(0, QtCore.Qt.AscendingOrder)
bd.close()
def initTree(self):
bd = Bbdd()
data = bd.select("competition", "name")
index = 0
items = []
for i in data:
index += 1
id = i[0]
name = i[1]
region = bd.getValue(i[2], "region")
sport = bd.getValue(i[3], "sport")
item = QTreeWidgetItem([str(index), str(id), str(name), region, str(sport)])
items.append(item)
self.treeMain.addTopLevelItems(items)
bd.close()
def changeItem(self): if self.itemSelected != -1: self.treeMain.topLevelItem(self.indexSelected).setText(3, "") self.treeMain.topLevelItem(self.indexSelected).setText(9, "") self.itemSelected = self.treeMain.currentItem().text(1) self.indexSelected = int(self.treeMain.currentItem().text(0)) - 1 bd = Bbdd() sport = bd.getValue(self.treeMain.currentItem().text(1), "bet", "sport") sport = bd.getValue(sport, "sport") self.treeMain.currentItem().setText(3, sport) bookie = bd.getValue(self.treeMain.currentItem().text(1), "bet", "bookie") bookie = bd.getValue(bookie, "bookie") self.treeMain.currentItem().setText(9, bookie) bd.close() self.mainWindows.enableActions()
def initData(self):
bd = Bbdd()
# txtName
name = bd.getValue(self.id, "competition")
self.txtName.setText(name)
# cmbRegion
data = bd.select("region", "name")
self.regionIndexToId = {}
index, idCmb = 0, 0
idBd = bd.getValue(self.id, "competition", "region")
for i in data:
id = i[0]
if id == idBd:
idCmb = index
name = i[1]
self.cmbRegion.addItem(name)
self.regionIndexToId[index] = id
index += 1
self.cmbRegion.setCurrentIndex(idCmb)
# cmbSport
bd = Bbdd()
data = bd.select("sport", "name")
self.sportIndexToId = {}
index, idCmb = 0, 0
idBd = bd.getValue(self.id, "competition", "sport")
for i in data:
id = i[0]
if id == idBd:
idCmb = index
name = i[1]
self.cmbSport.addItem(name)
self.sportIndexToId[index] = id
index += 1
self.cmbSport.setCurrentIndex(idCmb)
bd.close()
def initTree(self):
year = self.cmbYear.currentText()
month = self.cmbMonth.currentText()
month = monthToNumber(month)
self.treeMain.clear()
bd = Bbdd()
data = bd.select("bet", "date DESC", "date LIKE '" + year + "-" + month + "%'")
index = 0
items = []
for i in data:
index += 1
id = i[0]
date = i[1][:-3]
competition = bd.getValue(i[3], "competition")
region = bd.getValue(i[4], "region")
player1 = i[5]
player2 = i[6]
pick = i[7]
#bookie = bd.getValue(i[8], "bookie")
market = bd.getValue(i[9], "market") # TODO Preload in dictionary
tipster = bd.getValue(i[10], "tipster") # TODO Preload in dictionary
stake = i[11]
one = i[12]
result = numberToResult(i[13])
profit = i[14]
bet = i[15]
quota = i[16]
item = QTreeWidgetItem([str(index), str(id), str(date), "", str(competition), str(region), player1,
player2, pick, "", market, tipster, str(stake), str(one) + self.coin, str(bet) + self.coin,
str(quota), str(result), str(profit) + self.coin])
item = paint_row(item, profit, i[13])
if os.path.isfile(expanduser("~") + "/.betcon/resources/sports/" + str(i[2]) + ".png"):
item.setBackground(3, QBrush(QPixmap(expanduser("~") + "/.betcon/resources/sports/" + str(i[2]) + ".png")))
else:
if os.path.isfile(directory + "/../resources/sports/" + str(i[2]) + ".png"):
item.setBackground(3, QBrush(QPixmap(directory + "/../resources/sports/" + str(i[2]) + ".png")))
else:
sport = bd.getValue(i[2], "sport")
item.setText(3, sport)
if os.path.isfile(expanduser("~") + "/.betcon/resources/bookies/" + str(i[8]) + ".png"):
item.setBackground(9, QBrush(QPixmap(expanduser("~") + "/.betcon/resources/bookies/" + str(i[8]) + ".png")))
else:
if os.path.isfile(directory + "/../resources/bookies/" + str(i[8]) + ".png"):
item.setBackground(9, QBrush(QPixmap(directory + "/../resources/bookies/" + str(i[8]) + ".png")))
else:
bookie = bd.getValue(i[8], "bookie")
item.setText(9, bookie)
items.append(item)
self.treeMain.addTopLevelItems(items)
bd.close()
def setRegion(self):
self.btnAccept.setDisabled(False)
self.cmbRegion.clear()
bd = Bbdd()
idSport = self.sportIndexToId.get(self.cmbSport.currentIndex())
where = " sport=" + str(idSport)
data = bd.select("competition", None, where, "region")
dataRegion = ""
if len(data) > 0:
sData = "("
j = 0
for i in data:
if j == len(data) - 1:
sData += str(i[0]) + ")"
else:
sData += str(i[0]) + ", "
j += 1
where = " id in " + sData
dataRegion = bd.select("region", "name", where)
if len(dataRegion) < 1:
self.btnAccept.setDisabled(True)
bd.close()
else:
self.regionIndexToId = {}
index, idCmb = 0, 0
idBd = bd.getValue(self.id, "bet", "region")
for i in dataRegion:
id = i[0]
if id == idBd:
idCmb = index
name = i[1]
self.cmbRegion.addItem(name)
self.regionIndexToId[index] = id
index += 1
self.cmbRegion.setCurrentIndex(idCmb)
bd.close()
self.setCompetition()
else:
self.btnAccept.setDisabled(True)
bd.close()
if len(data) == 0 or len(dataRegion) == 0:
self.btnAccept.setDisabled(True)
else:
self.btnAccept.setDisabled(False)
def initTree(self):
bd = Bbdd()
data = bd.select("bonus", "date")
items = []
for i in data:
id = i[0]
date = i[1]
bookie = bd.getValue(i[2], "bookie")
money = i[3]
free = _("Yes") if str_to_bool(i[4]) else _("No")
item = QTreeWidgetItem([str(date), str(id), str(bookie), str(money) + self.coin, str(free)])
items.append(item)
self.treeMain.addTopLevelItems(items)
bd.close()
def initTree(self):
bd = Bbdd()
data = bd.select("bet", "date DESC")
index = 0
items = []
for i in data:
index += 1
id = i[0]
date = i[1]
competition = bd.getValue(i[3], "competition")
region = bd.getValue(i[4], "region")
player1 = i[5]
player2 = i[6]
pick = i[7]
#bookie = bd.getValue(i[8], "bookie")
market = bd.getValue(i[9], "market")
tipster = bd.getValue(i[10], "tipster")
stake = i[11]
one = i[12]
result = i[13]
profit = str(i[14])
bet = str(i[15])
quota = i[16]
item = QTreeWidgetItem([
str(index),
str(id),
str(date), "",
str(competition),
str(region), player1, player2, pick, "", market, tipster,
str(stake),
str(one),
str(bet),
str(quota),
str(result),
str(profit)
])
profit = str_to_float(profit)
if result == "Pendiente":
for j in range(18):
item.setBackground(j, QBrush(Qt.yellow))
else:
if profit < 0:
for j in range(18):
item.setBackground(j, QBrush(Qt.red))
elif profit > 0:
for j in range(18):
item.setBackground(j, QBrush(Qt.green))
else:
for j in range(18):
item.setBackground(j, QBrush(Qt.cyan))
if os.path.isfile(directory + "/../resources/sports/" + str(i[2]) +
".png"):
item.setBackground(
3,
QBrush(
QPixmap(directory + "/../resources/sports/" +
str(i[2]) + ".png")))
else:
sport = bd.getValue(i[2], "sport")
item.setText(3, sport)
if os.path.isfile(directory + "/../resources/bookies/" +
str(i[8]) + ".png"):
item.setBackground(
9,
QBrush(
QPixmap(directory + "/../resources/bookies/" +
str(i[8]) + ".png")))
else:
bookie = bd.getValue(i[8], "bookie")
item.setText(9, bookie)
items.append(item)
self.treeMain.addTopLevelItems(items)
bd.close()
def initData(self):
# dtDate
bd = Bbdd()
sDate = bd.getValue(self.id, "bet", "date")
date = QDateTime.fromString(sDate, "yyyy-MM-dd hh:mm:ss")
self.dtDate.setDateTime(date)
# cmbSport
data = bd.select("sport", "name")
self.sportIndexToId = {}
index, idCmb = 0, 0
idBd = bd.getValue(self.id, "bet", "sport")
for i in data:
id = i[0]
if id == idBd:
idCmb = index
name = i[1]
self.cmbSport.addItem(name)
self.sportIndexToId[index] = id
index += 1
self.cmbSport.setCurrentIndex(idCmb)
# cmbBookie
data = bd.select("bookie", "name")
index, idCmb = 0, 0
idBd = bd.getValue(self.id, "bet", "bookie")
self.bookieIndexToId = {}
index = 0
for i in data:
id = i[0]
if id == idBd:
idCmb = index
name = i[1]
country = i[2]
if LibYaml().interface['bookieCountry'] == 'Y':
name += ' (' + country + ')'
self.cmbBookie.addItem(name)
self.bookieIndexToId[index] = id
index += 1
self.cmbBookie.setCurrentIndex(idCmb)
self.players = bd.executeQuery(
"SELECT player1 AS player FROM bet UNION SELECT player2 AS player FROM bet ORDER BY player"
)
self.players = [row[0] for row in self.players]
self.txtPlayer1.addItems(self.players)
self.txtPlayer2.addItems(self.players)
# txtPlayer1
player1 = bd.getValue(self.id, "bet", "player1")
self.txtPlayer1.setCurrentText(player1)
# txtPlayer2
player2 = bd.getValue(self.id, "bet", "player2")
self.txtPlayer2.setCurrentText(player2)
# txtPick
pick = bd.getValue(self.id, "bet", "pick")
self.txtPick.setText(pick)
# cmbMarket
data = bd.select("market", "name")
index, idCmb = 0, -1
idBd = bd.getValue(self.id, "bet", "market")
self.marketIndexToId = {}
index = 0
for i in data:
id = i[0]
if id == idBd:
idCmb = index
name = i[1]
self.cmbMarket.addItem(name)
self.marketIndexToId[index] = id
index += 1
self.cmbMarket.setCurrentIndex(idCmb)
# cmbTipster
data = bd.select("tipster", "name")
index, idCmb = 0, 0
idBd = bd.getValue(self.id, "bet", "tipster")
self.tipsterIndexToId = {}
index = 0
for i in data:
id = i[0]
if id == idBd:
idCmb = index
name = i[1]
self.cmbTipster.addItem(name)
self.tipsterIndexToId[index] = id
index += 1
self.cmbTipster.setCurrentIndex(idCmb)
# txtStake
stake = bd.getValue(self.id, "bet", "stake")
self.txtStake.setValue(stake)
# txtOne
one = bd.getValue(self.id, "bet", "one")
self.txtOne.setValue(one)
# txtBet
bet = bd.getValue(self.id, "bet", "bet")
self.txtBet.setValue(bet)
# txtQuota
quota = bd.getValue(self.id, "bet", "quota")
self.txtQuota.setValue(quota)
# txtProfit
profit = bd.getValue(self.id, "bet", "profit")
self.txtProfit.setValue(profit)
result = bd.getValue(self.id, "bet", "result")
self.cmbResult.setCurrentIndex(int(result))
freeBet = bd.getValue(self.id, "bet", "free")
self.chkFree.setChecked(freeBet)
bd.close()
self.setRegion()
# Combined
self.contComb = 0
self.dates = []
self.sports = []
self.regions = []
self.competitions = []
self.players1 = []
self.players2 = []
self.picks = []
self.results = []
self.buttons = []
self.regionIndexToIdCmb = []
self.competitionIndexToIdCmb = []
def setId(self, id): self.id = id bd = Bbdd() self.name = bd.getValue(self.id, "bookie") bd.close()
