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