def accept(self):
data = []
data.append(self.txtDate.text())
data.append(self.cmbAccount.currentIndex() + 1)
idBookie = self.bookieIndexToId.get(self.cmbBookie.currentIndex())
data.append(idBookie)
if self.cmbType.currentIndex() == 1:
type = "-"
else:
type = ""
money = type + str(self.txtMoney.text())
money = str_to_float(money)
data.append(money)
columns = ["date", "account", "bookie", "money"]
bbdd = Bbdd()
bbdd.insert(columns, data, "movement")
money *= -1
data = ["'+bank+'" + str(money)]
columns = ["bank"]
account = self.cmbAccount.currentIndex()
bbdd.update(columns, data, "bank", "id=" + str(account + 1))
bbdd.close()
QMessageBox.information(self, "Añadido", "Movimiento añadido.")
self.close()
def accept(self):
money = str(str_to_float(self.txtMoney.text()))
data = [
self.cmbMonth.currentIndex(),
self.txtYear.text(),
self.txtName.text(), money
]
columns = ["month", "year", "name", "money"]
bbdd = Bbdd()
bbdd.update(columns, data, "conjunta", "id=" + str(self.id))
bbdd.deleteWhere("conjunta_tipster", "conjunta=" + str(self.id))
for i in self.selected:
if i in (0, 1):
continue
bbdd.insert(["conjunta", "tipster"], [self.id, i],
"conjunta_tipster")
bbdd.close()
QMessageBox.information(self, "Añadido", "Nueva conjunta añadida.")
self.close()
def accept(self):
money = str(self.txtMoney.text())
data = [
self.cmbMonth.currentIndex(),
self.txtYear.text(),
self.txtName.text(), money
]
columns = ["month", "year", "name", "money"]
bbdd = Bbdd()
bbdd.update(columns, data, "conjunta", "id=" + str(self.id))
bbdd.deleteWhere("conjunta_tipster", "conjunta=" + str(self.id))
for i in self.selected:
if i in (0, 1):
continue
bbdd.insert(["conjunta", "tipster"], [self.id, i],
"conjunta_tipster")
bbdd.close()
QMessageBox.information(self, _("Added"),
_("New joint purchase added."))
self.close()
def accept(self):
data = [self.txtName.text()]
columns = ["name"]
bbdd = Bbdd()
bbdd.update(columns, data, "market", "id=" + self.id)
bbdd.close()
QMessageBox.information(self, _("Updated"), _("Market updated."))
self.close()
def accept(self):
data = [self.txtName.text()]
columns = ["name"]
bbdd = Bbdd()
bbdd.update(columns, data, "tipster", "id=" + self.id)
bbdd.close()
QMessageBox.information(self, "Actualizado", "Tipster actualizado.")
self.close()
def accept(self):
data = [self.txtRegion.text()]
columns = ["name"]
bbdd = Bbdd()
bbdd.update(columns, data, "region", "id=" + self.id)
bbdd.close()
QMessageBox.information(self, _("Updated"), _("Updated region."))
self.close()
def accept(self):
data = [self.txtRegion.text()]
columns = ["name"]
bbdd = Bbdd()
bbdd.update(columns, data, "region", "id=" + self.id)
bbdd.close()
QMessageBox.information(self, "Actualizada", "Región actualizada.")
self.close()
def deleteItem(self):
resultado = QMessageBox.question(
self, "Eliminar", "¿Estas seguro que desas eliminarlo?",
QMessageBox.Yes | QMessageBox.No, QMessageBox.No)
if resultado == QMessageBox.Yes:
bd = Bbdd()
bd.delete("movement", self.itemSelected)
data = ["'+bank+'" + self.treeMovement.currentItem().text(5)]
columns = ["bank"]
bd.update(columns, data, "bank",
"name='" + self.treeMovement.currentItem().text(4) + "'")
bd.close()
self.mainWindows.setCentralWidget(Banks(self.mainWindows))
self.mainWindows.enableTools("bank")
def deleteItem(self):
resultado = QMessageBox.question(
self, _("Remove"), _("Are you sure you want to eliminate it?"),
QMessageBox.Yes | QMessageBox.No, QMessageBox.No)
if resultado == QMessageBox.Yes:
bd = Bbdd()
bd.delete("movement", self.itemSelected)
data = ["'+bank+'" + self.treeMovement.currentItem().text(5)]
columns = ["bank"]
bd.update(columns, data, "bank",
"name='" + self.treeMovement.currentItem().text(4) + "'")
bd.close()
self.mainWindows.setCentralWidget(Banks(self.mainWindows))
self.mainWindows.enableTools("bank")
def update(self):
if not self.isEmpty():
bd = Bbdd()
msg = bd.update(["name", "country"], [self.name, self.country],
"bookie", "id=" + self.id)
bd.close()
if msg != 0:
msg = "Se ha producido un error al actualizar la BBDD"
if self.ruta is not None:
try:
if not os.path.exists(
expanduser("~") + "/.betcon/resources/bookies"):
os.makedirs(
expanduser("~") + "/.betcon/resources/bookies")
copy2(
self.ruta,
expanduser("~") + "/.betcon/resources/bookies/" +
self.id + ".png")
img = Images(
expanduser("~") + "/.betcon/resources/bookies/" +
self.id + ".png")
img.resize(100, 20)
except:
msg = "Imágen incorrecta"
else:
msg = "Faltan datos por introducir"
return msg
def accept(self):
data = []
data.append(self.txtName.text())
idRegion = self.regionIndexToId.get(self.cmbRegion.currentIndex())
data.append(idRegion)
idSport = self.sportIndexToId.get(self.cmbSport.currentIndex())
data.append(idSport)
columns = ["name", "region", "sport"]
bbdd = Bbdd()
bbdd.update(columns, data, "competition", "id=" + self.id)
bbdd.close()
QMessageBox.information(self, "Actualizada",
"Competición actualizada.")
self.close()
def accept(self):
idTipster = self.tipsterIndexToId.get(self.cmbTipster.currentIndex())
print(idTipster)
money = str(self.txtMoney.text())
data = [
self.cmbMonth.currentIndex(),
self.txtYear.text(), idTipster, money
]
columns = ["month", "year", "tipster", "money"]
bbdd = Bbdd()
bbdd.update(columns, data, "tipster_month")
bbdd.close()
QMessageBox.information(self, _("Updated"),
_("Added tipster payment."))
self.close()
def update(self): if not self.isEmpty(): bd = Bbdd() msg = bd.update(["name"], [self.name], "bookie", "id="+self.id) bd.close() if msg != 0: msg = "Se ha producido un error al actualizar la BBDD" else: msg = "Faltan datos por introducir" return msg
def accept(self):
type = self.cmbType.currentIndex()
if type == 0:
type="+"
else:
type="-"
data = ["'+bank"+type+"'"+str(self.txtMoney.text())]
columns = ["bank"]
account = self.cmbAccount.currentIndex()
bbdd = Bbdd()
bbdd.update(columns, data, "bank", "id="+str(account+1))
bbdd.close()
QMessageBox.information(self, _("Added"), _("Added funds."))
self.close()
def accept(self): type = self.cmbType.currentIndex() if type == 0: type="+" else: type="-" data = ["'+bank"+type+"'"+str(str_to_float(self.txtMoney.text()))] columns = ["bank"] account = self.cmbAccount.currentIndex() bbdd = Bbdd() bbdd.update(columns, data, "bank", "id="+str(account+1)) bbdd.close() QMessageBox.information(self, "Añadido", "Fondos añadidos.") self.close()
def accept(self):
data = [self.txtName.text()]
columns = ["name"]
bbdd = Bbdd()
bbdd.update(columns, data, "sport", "id="+self.id)
bbdd.close()
if self.ruta is not None:
try:
if not os.path.exists(expanduser("~") + "/.betcon/resources/sports"):
os.makedirs(expanduser("~") + "/.betcon/resources/sports")
copy2(self.ruta, expanduser("~") + "/.betcon/resources/sports/" + self.id + ".png")
img = Images(expanduser("~") + "/.betcon/resources/sports/" + self.id + ".png")
img.resize(100, 20)
except:
msg = "Imágen incorrecta"
QMessageBox.information(self, _("Updated"), _("Updated sport."))
self.close()
def accept(self):
data = []
bbdd = Bbdd()
# dtDate
data.append(self.txtDate.date().toPyDate())
# cmbBookie
idBookie = self.bookieIndexToId.get(self.cmbBookie.currentIndex())
data.append(idBookie)
data.append(str(str_to_float(self.txtMoney.text())))
free = self.chkFree.isChecked()
data.append(free)
columns = ["date", "bookie", "money", "free"]
bbdd.update(columns, data, "bonus", "id=" + self.id)
QMessageBox.information(self, "Actualizado", "Bono actualizado.")
self.close()
def accept(self):
data = []
bbdd = Bbdd()
# dtDate
data.append(self.dtDate.dateTime().toPyDateTime())
# cmbSport
idSport = self.sportIndexToId.get(self.cmbSport.currentIndex())
data.append(idSport)
# cmbCompetition
idCompetition = self.competitionIndexToId.get(
self.cmbCompetition.currentIndex())
data.append(idCompetition)
# cmbRegion
idRegion = self.regionIndexToId.get(self.cmbRegion.currentIndex())
data.append(idRegion)
data.append(self.txtPlayer1.currentText())
data.append(self.txtPlayer2.currentText())
data.append(self.txtPick.text())
# cmbBookie
idBookie = self.bookieIndexToId.get(self.cmbBookie.currentIndex())
data.append(idBookie)
# cmbMarket
idMarket = self.marketIndexToId.get(self.cmbMarket.currentIndex())
data.append(idMarket)
# cmbTipster
idTipster = self.tipsterIndexToId.get(self.cmbTipster.currentIndex())
data.append(idTipster)
data.append(str(self.txtStake.text()))
data.append(str(self.txtOne.text()))
# cmbResult
data.append(self.cmbResult.currentIndex())
data.append(str(self.txtProfit.text()))
data.append(str(self.txtBet.text()))
data.append(str(self.txtQuota.text()))
data.append(1 if self.chkFree.isChecked() else 0)
columns = [
"date", "sport", "competition", "region", "player1", "player2",
"pick", "bookie", "market", "tipster", "stake", "one", "result",
"profit", "bet", "quota", "free"
]
bbdd.update(columns, data, "bet", "id=" + self.id)
if self.cmbMarket.currentText() == "Combinada":
columns = [
"bet", "date", "sport", "competition", "region", "player1",
"player2", "pick", "result"
]
bbdd.deleteWhere("combined", "bet=" + str(self.id))
for i in range(0, self.contComb):
data = []
data.append(self.id)
data.append(self.dates[i].dateTime().toPyDateTime())
idSport = self.sportIndexToId.get(
self.sports[i].currentIndex())
data.append(idSport)
idCompetition = self.competitionIndexToIdCmb[i].get(
self.competitions[i].currentIndex())
data.append(idCompetition)
idRegion = self.regionIndexToIdCmb[i].get(
self.regions[i].currentIndex())
data.append(idRegion)
data.append(self.players1[i].currentText())
data.append(self.players2[i].currentText())
data.append(self.picks[i].text())
data.append(self.results[i].currentIndex())
bbdd.insert(columns, data, "combined")
bbdd.close()
QMessageBox.information(self, _("Modified"), _("Modified bet."))
self.close()
