def daily_check():
bot.send_message(const.sysadmin, "Началась ежедневная проверка")
db = connect()
cur = db.cursor()
r = 'SELECT uid, end_date FROM payments'
cur.execute(r)
res = cur.fetchall()
r = "SELECT state, days FROM demo WHERE id = 1"
cur.execute(r)
state, days_left = cur.fetchone()
if state:
if days_left == 0:
r = "UPDATE demo SET state = 0 WHERE id = 1"
else:
r = "UPDATE demo SET days = days - 1 WHERE id = 1"
cur.execute(r)
today = str(datetime.datetime.now()).split(' ')[0]
after_tomorrow = parser.parse(today) + datetime.timedelta(days=2)
for user in res:
if after_tomorrow == parser.parse(str(user[1])):
text = 'У вас истекает подписка.'
bot.send_message(user[0], text, reply_markup=markups.payBtnMarkup())
time.sleep(0.1)
if parser.parse(str(user[1])) <= parser.parse(today):
text = 'Время действия вашей подписки окончено.'
bot.send_message(user[0], text)
r = 'DELETE FROM payments WHERE uid=%s'
cur.execute(r, (user[0],))
r = "INSERT INTO lost_subs(uid, end_date) VALUES (%s, %s)"
cur.execute(r, (user[0], user[1]))
time.sleep(0.1)
db.commit()
db.close()
def daily_check():
db = sql.connect("localhost", "root", "churchbynewton", "TRADER")
cur = db.cursor()
r = 'SELECT uid, end_date FROM payments'
res = cur.execute(r).fetchall()
today = str(datetime.datetime.now()).split(' ')[0]
after_tomorrow = parser.parse(today) + datetime.timedelta(days=2)
for user in res:
if after_tomorrow == parser.parse(str(user[1])):
text = 'У вас истекает подписка.'
bot.send_message(user[0], text, reply_markup=markups.payBtnMarkup())
time.sleep(0.1)
if parser.parse(str(user[1])) <= parser.parse(today):
text = 'Время действия вашей подписки окончено.'
bot.send_message(user[0], text)
r = 'DELETE FROM payments WHERE uid=?'
cur.execute(r, (user[0],))
time.sleep(0.1)
db.commit()
db.close()
def choose_duration(call):
bot.send_message(call.message.chat.id, const.profitMsg, reply_markup=markups.payBtnMarkup())
def showProfit(call):
bot.send_message(call.message.chat.id,
const.profitMsg,
reply_markup=markups.payBtnMarkup())