def hitung(self, update, context, args, due):
try:
z = self.t1.is_alive()
chat_id = update.message.chat_id
if due <= 0:
update.message.reply_text(kamus("jadwal_lewat"))
return
pesan = ' '.join(update.message.text.split(" ")[2:])
# match = re.match(r'^[A-Za-z0-9 ?!\/&,.:@]*$', pesan )
# if match :
sekarang = '{:%Y-%m-%d %H:%M:%S}'.format(
datetime.datetime.now() +
datetime.timedelta(seconds=0, hours=0))
waktu = '{:%Y-%m-%d %H:%M:%S}'.format(
datetime.datetime.now() +
datetime.timedelta(seconds=due, hours=0))
chat_id = update.message["chat"]["id"]
chat_type = update.message["chat"]["type"]
user_id = update.message.from_user.id
user_name = update.message.from_user.username
sql = "INSERT INTO daftar_timer (waktu, chat_id, chat_type, user_id, user_name, pesan, done, sholat, kota) VALUES (?,?,?,?,?,?,?,'','')"
cur.execute(
sql, (waktu, chat_id, chat_type, user_id, user_name, pesan, 0))
db.commit()
update.message.reply_text(kamus("jadwal_set") % (sekarang, waktu))
# else:
# update.message.reply_text('incorrect string')
except Exception as e:
update.message.reply_text('%s\n%s' % (kamus("mogok"), e))
def agenda(self, update, context):
try:
z = self.t1.is_alive()
user_id = update.message.from_user.id
chat_id = update.message["chat"]["id"]
sql = "SELECT waktu, pesan, sholat, kota FROM daftar_timer WHERE user_id = '%s' AND chat_id = '%s' AND done = 0" % (
user_id, chat_id)
bar, jum = eksekusi(sql)
if jum == 0:
update.message.reply_text(kamus("jadwal_kosong"))
else:
cek = []
for i in range(jum):
waktu = bar[i][0]
sekarang = '{:%Y-%m-%d %H:%M:%S}'.format(
datetime.datetime.now() +
datetime.timedelta(seconds=0, hours=0))
if sekarang > waktu:
teks = kamus("sholat_lewat")
done = "UPDATE daftar_timer SET done = 1 WHERE waktu = '%s' and chat_id = '%s' AND user_id = '%s'" % (
waktu, chat_id, user_id)
cur.execute(done)
db.commit()
else:
teks = ""
cek.append("%s %s %s %s %s" %
(waktu, bar[i][1], bar[i][2], bar[i][3], teks))
cek.sort()
agenda = ''.join('%s \n' % cek[i] for i in range(len(cek)))
update.message.reply_text(kamus("jadwal_list") % agenda)
except Exception as e:
update.message.reply_text('%s\n%s' % (kamus("mogok"), e))
def timer(self,bot,update):
while True:
sekarang = datetime.datetime.now()
hari = datetime.datetime.strftime(sekarang.date(),"%a")
user_id = update.message.from_user.id
waktu = '{:%Y-%m-%d %H:%M:%S}'.format(datetime.datetime.now()+datetime.timedelta(seconds = 0, hours=0))
sql = "SELECT waktu, pesan, chat_id, user_name, sholat, kota FROM daftar_timer WHERE waktu = '%s'"%waktu
# print (sql)
try:
bar, jum = eksekusi(sql)
if jum == 0:
pass
else:
for i in range(jum):
chat_id = bar[i][2]
if len(bar[i][4]) > 1:
if bar[i][1]== 'sholat':
kata = "\n\n%s"%kamus("sholat_footnote")
else:
kata = ""
if hari == "Sun":
sholat_waktu = bar[i][1]
if sholat_waktu == "waktu":
sholat_waktu = "time"
else:
sholat_waktu = "prayer"
if bar[i][4] == "terbit":
sholat = "sunrise"
else:
sholat = bar[i][4]
pesan = (kamus("sholat_teks")%(sholat,sholat_waktu, bar[i][5], bar[i][3],kata))
else:
pesan = (kamus("sholat_teks")%(bar[i][1], bar[i][4], bar[i][5], bar[i][3],kata))
else:
if (bar[i][1].split()[0])=="banned":
try:
user_id = (bar[i][1].split()[1])
bot.send_sticker(chat_id, 'CAADBQADSQ4AAs_rwQcgxkK2JzKWwhYE') # banhammer marie sticker
bot.kick_chat_member(chat_id, user_id)
pesan = ("banned @%s"%(bar[i][3]))
except:
pesan = ("%s - @%s"%(bar[i][1],bar[i][3]))
else:
pesan = ("%s - @%s"%(bar[i][1],bar[i][3]))
bot.send_message(text = pesan,chat_id = chat_id)
done = "UPDATE daftar_timer SET done = 1 WHERE waktu = '%s' and chat_id = '%s' AND user_id = '%s'"%(waktu,chat_id,user_id)
cur.execute(done)
db.commit()
time.sleep(1)
except Exception as e:
update.message.reply_text("Error %s"%e)
def set_timer(self, update, context):
args = context.args
if args[0].upper() == 'SHOLAT':
try:
kota = ' '.join(args[1:]).upper()
self.jadwal_sholat(update, context, kota)
except:
self.help(update, context)
else:
try:
huruf = ''
try:
angka = re.match("([0-9]+)([a-zA-Z]+)", args[0]).group(1)
huruf = re.match("([0-9]+)([a-zA-Z]+)", args[0]).group(2)
except:
angka = args[0]
satuan = 1
if huruf == 's' or huruf == 'd' or huruf == '':
satuan = 1
elif huruf == 'm':
satuan = 60
elif huruf == 'h' or huruf == 'j':
satuan = 3600
else:
update.message.reply_text(kamus("cmd_salah"))
return
self.hitung(update, context, args, int(angka) * satuan)
except (IndexError, ValueError):
self.set_jam(update, context, args)
def start(self, update, context):
try:
z = self.t1.is_alive()
except:
self.t1 = threading.Thread(target=self.timer,
args=(update, context))
self.t1.start()
update.message.reply_text(kamus("cmd_start"))
def start(self,bot, update):
try:
z = self.t1.isAlive()
except:
self.t1 = threading.Thread(target=self.timer, args=(bot,update))
self.t1.start()
# _thread.start_new_thread(self.timer,(bot,update))
update.message.reply_text(kamus("cmd_start"))
def set_tanggal(self, update, context):
try:
current = datetime.datetime.now() + datetime.timedelta(seconds=0,
hours=0)
self.hitung(
update, context, args, job_queue, chat_data,
int((datetime.datetime.strptime("%s %s" % (args[0], args[1]),
"%Y-%m-%d %H:%M:%S") -
current).total_seconds()) + 1)
except:
update.message.reply_text(kamus("cmd_error"))
def dqotd(update,context):
args = context.args
chat_id = update.message["chat"]["id"]
if len(args) == 0:
update.message.reply_text(kamus("quote_kurang"))
elif str(args[0]).isdigit():
hitung = "SELECT quote FROM qotd WHERE chat_id = '%s'"%(chat_id)
bar, jum = eksekusi(hitung)
if jum == 0:
update.message.reply_text(kamus("dqotd_not_found"))
else:
try:
lock.acquire(True)
sql = ("UPDATE qotd SET hapus = 1 WHERE chat_id = '%s' AND nomor = '%s'"%(chat_id, args[0]))
cur.execute(sql)
db.commit()
finally:
lock.release()
update.message.reply_text(kamus("dqotd_sukses"))
else:
update.message.reply_text(kamus("quote_kurang"))
def qotd(bot: Bot, update: Update, args):
chat_id = update.message["chat"]["id"]
if len(args) == 0:
m = update.effective_message
try:
waktu = str(m.reply_to_message.date.strftime('%Y-%m-%d %H:%M:%S'))
quote = m.reply_to_message.text.replace("'", "''")
cek = "SELECT nomor FROM qotd WHERE quote = '%s'" % (quote)
barC, jumC = eksekusi(cek)
if jumC >= 1:
update.message.reply_text(
str(kamus("qotd_dobel")) % (barC[0][0]))
else:
try:
user_name = update.message["reply_to_message"][
"forward_from"]["username"]
user_id = update.message["reply_to_message"][
"forward_from"]["id"]
except:
user_name = m.reply_to_message.from_user.username
user_id = m.reply_to_message.from_user.id
chat_type = update.message["chat"]["type"]
hitung = "SELECT quote FROM qotd WHERE chat_id = '%s'" % (
chat_id)
bar, jum = eksekusi(hitung)
jum = jum + 1
try:
lock.acquire(True)
sql = "INSERT INTO qotd (nomor,waktu, chat_id, chat_type, user_id, user_name, quote, hapus) VALUES ('%s','%s','%s','%s','%s','%s','%s','%s')" % (
jum, waktu, chat_id, chat_type, user_id, user_name,
quote, 0)
cur.execute(sql)
db.commit()
finally:
lock.release()
update.message.reply_text(
str(kamus("quote_simpan")) % (jum, jum, jum))
except Exception as e:
update.message.reply_text('%s\n%s' % (kamus("quote_mogok"), e))
elif str(args[0]).isdigit():
sql = "SELECT quote, user_id, nomor,user_name FROM qotd WHERE chat_id = '%s' AND nomor = '%s'" % (
chat_id, args[0])
bar, jum = eksekusi(sql)
if jum == 0:
update.message.reply_text(kamus("quote_not_found"))
else:
# user_name = bot.get_chat(bar[0][1]).username
user_name = bar[0][3]
# print (bot.get_chat(bar[0][1]))
teks = "<i>{}</i>\n\n@{}:{}".format(html.escape(bar[0][0]),
user_name, bar[0][2])
try:
m_id = update.message["reply_to_message"]["message_id"]
bot.send_message(chat_id=update.message.chat_id,
reply_to_message_id=m_id,
text=teks,
parse_mode=ParseMode.HTML)
except:
update.message.reply_html(teks)
try:
lock.acquire(True)
sql_hit = "UPDATE qotd SET hit = hit+1 WHERE chat_id = '%s' AND nomor = '%s'" % (
chat_id, bar[0][2])
cur.execute(sql_hit)
db.commit()
finally:
lock.release()
else:
update.message.reply_text(
"Silahkan reply atau forward chat yang akan di quote")
def timer(self, update, context):
bot = context.bot
while True:
sekarang = datetime.datetime.now()
hari = datetime.datetime.strftime(sekarang.date(), "%a")
user_id = update.message.from_user.id
waktu = '{:%Y-%m-%d %H:%M:%S}'.format(
datetime.datetime.now() +
datetime.timedelta(seconds=0, hours=0))
sql = "SELECT waktu, pesan, chat_id, user_name, sholat, kota FROM daftar_timer WHERE waktu = '%s'" % waktu
sql_corona = "SELECT waktu, area, chat_id, positif, sembuh, meninggal, waktu_berikutnya FROM kawalCoronaSub WHERE langganan = 1"
try:
barCor, jumCor = eksekusi(sql_corona)
if jumCor == 0:
pass
else:
for i in range(jumCor):
cek_date = barCor[i][6]
if cek_date > waktu:
pass
elif cek_date < waktu:
# menghitung ulang saat waktu nya kelewat
berikutnya = sekarang + datetime.timedelta(
seconds=300, hours=0)
berikutnya = '{:%Y-%m-%d %H:%M:%S}'.format(
berikutnya)
chat_id = barCor[i][2]
provinsi = barCor[i][1]
sql_update = "UPDATE kawalCoronaSub SET waktu_berikutnya=? WHERE chat_id = ? AND area = ? AND langganan = 1"
arg_update = (berikutnya, chat_id, provinsi)
cur.execute(sql_update, arg_update)
db.commit()
else:
try:
total_lama = barCor[i][3] + barCor[i][
4] + barCor[i][5]
chat_id = barCor[i][2]
provinsi = barCor[i][1]
kode, tampil, positif, sembuh, meninggal = kawalCorona.stat_corona(
update, context, provinsi, chat_id)
pesan = kawalCorona.corGraph(
update, context, provinsi, chat_id)
total_baru = int(positif) + int(sembuh) + int(
meninggal)
if int(positif) - barCor[i][3] > 0:
selisih_positif = "+%s" % (int(positif) -
barCor[i][3])
else:
selisih_positif = "-%s" % (barCor[i][3] -
int(positif))
if int(sembuh) - barCor[i][4] > 0:
selisih_sembuh = "+%s" % (int(sembuh) -
barCor[i][4])
else:
selisih_sembuh = "-%s" % (barCor[i][4] -
int(sembuh))
if int(meninggal) - barCor[i][5] > 0:
selisih_meninggal = "+%s" % (
int(meninggal) - barCor[i][5])
else:
selisih_meninggal = "-%s" % (
barCor[i][5] - int(meninggal))
tampil.append(
"``` Data sebelumnya %s\n Positif\t\t: %s\t\t%s\n Sembuh\t\t\t: %s\t\t%s\n Meninggal: %s\t\t%s```"
% (barCor[i][0], barCor[i][3],
selisih_positif, barCor[i][4],
selisih_sembuh, barCor[i][5],
selisih_meninggal))
if total_lama != total_baru:
tampil = (''.join(
'%s \n' % tampil[j]
for j in range(len(tampil))))
if pesan:
filename = "%s%s" % (provinsi, chat_id)
file = open("%s.png" % filename, "rb")
context.bot.sendPhoto(
chat_id=chat_id,
photo=file,
caption=tampil,
parse_mode=ParseMode.MARKDOWN)
else:
bot.send_message(
text=tampil,
chat_id=chat_id,
parse_mode=ParseMode.MARKDOWN)
sekarang = '{:%Y-%m-%d %H:%M:%S}'.format(
sekarang)
sqlStat = "INSERT INTO kawalCorona (tanggal, chat_id,area,positif,sembuh,meninggal) VALUES (?,?,?,?,?,?)"
argStat = (sekarang, chat_id, provinsi,
positif, sembuh, meninggal)
cur.execute(sqlStat, argStat)
db.commit()
except:
pass
bar, jum = eksekusi(sql)
if jum == 0:
pass
else:
for i in range(jum):
chat_id = bar[i][2]
if len(bar[i][4]) > 1:
if bar[i][1] == 'sholat':
kata = "\n\n%s" % kamus("sholat_footnote")
else:
kata = ""
if hari == "Sun":
sholat_waktu = bar[i][1]
if sholat_waktu == "waktu":
sholat_waktu = "time"
else:
sholat_waktu = "prayer"
if bar[i][4] == "terbit":
sholat = "sunrise"
else:
sholat = bar[i][4]
pesan = (kamus("sholat_teks") %
(sholat, sholat_waktu, bar[i][5],
bar[i][3], kata))
else:
pesan = (kamus("sholat_teks") %
(bar[i][1], bar[i][4], bar[i][5],
bar[i][3], kata))
else:
if (bar[i][1].split()[0]) == "banned":
try:
user_id = (bar[i][1].split()[1])
bot.kick_chat_member(chat_id, user_id)
pesan = ("banned @%s" % (bar[i][3]))
except:
pesan = ("ane gagal %s - @%s" %
(bar[i][1], bar[i][3]))
bot.send_sticker(
chat_id,
'CAACAgUAAxkBAAIVY18FFska2MmU5E4nPNco6m0RTRQhAALaAAM_5Bom20PZpUJeLM8aBA'
) # banhammer marie sticker
done = "UPDATE new_members SET done = 1, age = '%s' WHERE chat_id = '%s' AND user_id = '%s'" % (
0, chat_id, user_id)
cur.execute(done)
db.commit()
else:
pesan = ("%s - @%s" % (bar[i][1], bar[i][3]))
bot.send_message(text=pesan, chat_id=chat_id)
done = "UPDATE daftar_timer SET done = 1 WHERE waktu = '%s' and chat_id = '%s' AND user_id = '%s'" % (
waktu, chat_id, user_id)
cur.execute(done)
db.commit()
time.sleep(1)
except Exception as e:
update.message.reply_text("Error %s" % e)
def jadwal_sholat(self, update, context, kota):
try:
z = self.t1.is_alive()
nama = kota
sekarang = datetime.datetime.now()
tanggal = sekarang.strftime('%Y-%m-%d')
jam = sekarang.strftime('%H:%M')
hari = datetime.datetime.strftime(sekarang.date(), "%a")
chat_id = update.message["chat"]["id"]
chat_type = update.message["chat"]["type"]
user_id = update.message.from_user.id
user_name = update.message.from_user.username
cek = "SELECT waktu FROM daftar_timer WHERE kota = '%s' AND DATE(waktu) = '%s' AND chat_id = '%s'" % (
nama, tanggal, chat_id)
bar, jum = eksekusi(cek)
if jum == 0:
url_kota = "https://api.banghasan.com/sholat/format/json/kota"
r = requests.get(url_kota)
kota_all = r.json()['kota']
for a in kota_all:
if a['nama'] == nama.upper():
update.message.reply_text(
str(kamus("id_ketemu")) % a['id'])
url = "https://api.banghasan.com/sholat/format/json/jadwal/kota/%s/tanggal/%s" % (
a['id'], tanggal)
r = requests.get(url)
sholat_all = r.json()['jadwal']['data']
jadwal = []
t = ""
m = ""
for k, v in sholat_all.items():
if k != 'tanggal':
waktu = '%s %s:00' % (tanggal, v)
if k == 'terbit' or k == 'imsak':
keterangan = "waktu"
else:
keterangan = "sholat"
if k == 'terbit':
t = datetime.datetime.strptime(v, '%H:%M')
if k == 'maghrib':
m = datetime.datetime.strptime(v, "%H:%M")
if hari == "Fri" and k == "dzuhur":
sholat = "jumat"
else:
sholat = k
if jam < v:
status = ""
sql = "INSERT INTO daftar_timer (waktu, chat_id, chat_type, user_id, user_name, pesan, done, sholat, kota) VALUES ('%s','%s','%s','%s','%s','%s','%s','%s','%s')" % (
waktu, chat_id, chat_type, user_id,
user_name, keterangan, 0, sholat, nama)
cur.execute(sql)
db.commit()
else:
status = (kamus("sholat_lewat"))
jadwal.append('%s %s %s' % (v, sholat, status))
tahajud = (t - ((m - t) / 3)).strftime("%H:%M")
if jam < tahajud:
status = ""
waktu_tahajud = '%s %s:00' % (tanggal, tahajud)
sql = "INSERT INTO daftar_timer (waktu, chat_id, chat_type, user_id, user_name, pesan, done, sholat, kota) VALUES ('%s','%s','%s','%s','%s','%s','%s','%s','%s')" % (
waktu_tahajud, chat_id, chat_type, user_id,
user_name, "sholat", 0, "tahajud", nama)
cur.execute(sql)
db.commit()
else:
status = (kamus("sholat_lewat"))
jadwal.append('%s %s %s' %
(tahajud, 'tahajud', status))
jadwal.sort()
agenda_sholat = ''.join('%s \n' % jadwal[i]
for i in range(len(jadwal)))
update.message.reply_text(
str(kamus("sholat_jadwal")) %
(nama, tanggal, agenda_sholat))
break
else:
update.message.reply_text(
kamus("kota_tidak_ketemu") % url_kota)
else:
update.message.reply_text(
str(kamus("sholat_sudah_setting") % nama))
except Exception as e:
update.message.reply_text('%s\n%s' % (kamus("mogok"), e))
def help_timer(bot: Bot, update: Update):
update.message.reply_text(kamus("cmd_help_timer"))
def help_jadwal_sholat(bot: Bot, update: Update):
update.message.reply_text(kamus("cmd_help_jadwal_sholat"))
def help_qotd(bot: Bot, update: Update):
update.message.reply_text(kamus("cmd_help_qotd"))
