def create_cheque_schedules(date):
statement = CHEQUE_SCHEDULE.replace("(date)", str(date))
total_schedules = execute_select_query(statement)
output = [item for t in total_schedules for item in t]
output.sort()
for i in output:
statement = CHEQUE_SCHEDULE_DETAILS.replace("(scheduleGroup)",
f"{i}").replace(
"(date)", str(date))
accounts_in_schedule = execute_select_query(statement)
schedule_transactions = {}
for schedule in accounts_in_schedule:
schedule_transactions = create_account_dictionary(
schedule_transactions, schedule)
schedule_reference = select_account_and_add_to_schedule(
schedule_transactions, "cheque", i)
schedule_reference_dict = {
"schedule_number": schedule_reference,
"schedule_date": str(datetime.date.today())
}
for schedule in accounts_in_schedule:
update_query(
"transaction", schedule_reference_dict,
f"account_no = '{schedule[0]}' and rd_date = '{str(schedule[3])}' and is_cash = {False} and schedule_group = {i}"
)
def create_cheque_schedules(date):
statement = CHEQUE_SCHEDULE.replace("(date)", str(date))
total_schedules = execute_select_query(statement)
output = [item for t in total_schedules for item in t]
output.sort()
for i in output:
statement = CHEQUE_SCHEDULE_DETAILS.replace("(scheduleGroup)",
f"{i}").replace(
"(date)", str(date))
accounts_in_schedule = execute_select_query(statement)
for schedule in accounts_in_schedule:
create_sheet(i, schedule)