def recap_recent_update_item(update, context):
send_typing_state(update, context)
df = DataReport.recap_as_dataframe(db.get_recap_recent_update())
date_recap = datetime.datetime.today().strftime('%Y-%m-%d')
file_name = 'rekap item tanggal {}.xlsx'.format(date_recap)
df.to_excel(file_name, index=False)
context.bot.send_document(chat_id=update.effective_chat.id,
document=open(file_name, 'rb'),
filename=file_name)
def track_record(update, context):
send_typing_state(update, context)
serial_number = update.message.text.replace('/track_record',
'').strip().upper()
pd_id = db.get_product_id(serial_number)
if pd_id is None:
context.bot.send_message(chat_id=update.effective_chat.id,
text="serial number tidak ditemukan")
else:
track_records = db.get_track_record(pd_id)
if not track_records:
context.bot.send_message(
chat_id=update.effective_chat.id,
text="serial number ditemukan namun belum memiliki track record"
)
else:
df = DataReport.recap_as_dataframe(track_records)
date_recap = datetime.datetime.today().strftime('%Y-%m-%d')
file_name = 'rekap track record {} tanggal {}.xlsx'.format(
serial_number, date_recap)
df.to_excel(file_name, index=False)
context.bot.send_document(chat_id=update.effective_chat.id,
document=open(file_name, 'rb'),
filename=file_name)
