def saveTableItems(self):
n = self.rowCount()
for i in range(n):
item = self.cellWidget(i, 0)
if item.checkState() == QtCore.Qt.Checked:
alert = Alerte.filter(id=self.data[i][3]).get()
alert.status = False
alert.save()
def save_al(list_):
"""Enregistrer les alertes qui sont dans la liste"""
for el in list_:
try:
al = Alerte.filter(objets=el[0]).get()
except:
al = Alerte()
al.objets = unicode(el[0])
al.date_a = el[1]
al.status = True
al.save()
def alerte():
list_al , msg = [], ""
min_nbr_day = 0
max_nbr_day = 4
try:
alerte = Alerte.get()
except:
alerte = None
if alerte:
for al in Alerte.filter(status=True):
dat = (al.date_a - datetime.now()).days
if dat <= max_nbr_day and dat >= min_nbr_day:
list_al.append(al)
msg += "%d jr(s) pour: %s " % (dat, al.objets)
return list_al, msg
