def monthly_mod_matrix(sheet, subreddit):
first_day_of_this_month = date.today().replace(day=1)
epoch_current_day = sleep.time()
epoch_first_day_of_this_month = int(first_day_of_this_month.strftime("%s"))
if date.today().day == 1 or date.today().day == 2:
last_month = first_day_of_this_month - datetimebs.timedelta(days=1)
last_month = last_month.replace(day=1)
epoch_first_day_last_month = int(last_month.strftime("%s"))
results = db.get_count_by_action_for_timeframe(
epoch_first_day_last_month, epoch_first_day_of_this_month, subreddit
)
try:
work_sheet = sheet.worksheet(last_month.strftime("%b %Y"))
except gspread.WorksheetNotFound:
work_sheet = sheet.add_worksheet(last_month.strftime("%b %Y"), 50, 52)
work_range = work_sheet.range("A1:AZ50")
generated_range = generate_modlog_range(work_range, results)
results = db.get_count_by_action_for_timeframe(epoch_first_day_of_this_month, epoch_current_day, subreddit)
try:
work_sheet = sheet.worksheet(first_day_of_this_month.strftime("%b %Y"))
except gspread.WorksheetNotFound:
work_sheet = sheet.add_worksheet(first_day_of_this_month.strftime("%b %Y"), 50, 52)
work_range = work_sheet.range("A1:AZ50")
generated_range = generate_modlog_range(work_range, results)
update_work_sheet(work_sheet, generated_range)
work_sheet = sheet.worksheet("Burden Sharing")
work_range = work_sheet.range("A2:A50")
date_string = first_day_of_this_month.strftime("%b %Y")
for cell in work_range:
if cell.value == date_string:
cell.value = '="' + cell.value + '"'
break
elif cell.value == "":
cell.value = '="' + date_string + '"'
break
else:
cell.value = '="' + cell.value + '"'
update_work_sheet(work_sheet, work_range)
def generate_mod_matrix(epoch_time, subreddit):
first_day_of_the_month = datetime.fromtimestamp(epoch_time).replace(day=1)
first_day_of_following_month = (first_day_of_the_month + datetimebs.timedelta(days=35)).replace(day=1)
results = db.get_count_by_action_for_timeframe(
int(first_day_of_the_month.strftime("%s")), int(first_day_of_following_month.strftime("%s")), subreddit
)
try:
work_sheet = sheet.worksheet(first_day_of_the_month.strftime("%b %Y"))
except gspread.WorksheetNotFound:
work_sheet = sheet.add_worksheet(first_day_of_the_month.strftime("%b %Y"), 50, 52)
work_range = work_sheet.range("A1:AZ50")
generated_range = generate_modlog_range(work_range, results)
update_work_sheet(work_sheet, work_range)
work_sheet = sheet.worksheet("Burden Sharing")
work_range = work_sheet.range("A2:A50")
date_string = first_day_of_the_month.strftime("%b %Y")
for cell in work_range:
if cell.value == date_string:
break
elif cell.value == "":
cell.value = '="' + date_string + '"'
break
else:
cell.value = '="' + cell.value + '"'
update_work_sheet(work_sheet, work_range)
