def get_todo(profile_id):
todo_list = []
todo = frappe.db.sql(
"select name from tabToDo where profile_id = '%s' and date >= CURDATE() order by creation desc"
% profile_id)
for td in todo:
td = frappe.get_doc("ToDo", td[0])
todo_list.append({
"desc": td.description,
"todo_id": td.name,
"date": get_formatted_date_time(td.date),
"priority": td.priority
})
return todo_list
def get_appointments(data):
fields, values, tab = get_data_to_render(data)
pos = 0
for filed_dict in fields:
pos = +1
if 'rows' in filed_dict.keys():
rows = filed_dict.get('rows')
break
data = json.loads(data)
apts_list = fetch_values_from_db(data)
for d in apts_list:
rows.extend([[
get_formatted_date_time(d.from_date_time), d.provider_name,
d.reason
]])
return {'rows': rows, 'listview': fields}
def build_appointments_data(data):
rows = [[
"Date Time",
"Providers Name",
"Reason For Visit",
]]
if (data):
for d in data:
rows.extend([[
get_formatted_date_time(d["from_date_time"]),
d["provider_name"], d["reason"]
]])
else:
rows.extend([["NO DATA", "", ""]])
appointments_dic = {
"fieldname": "appointments",
"fieldtype": "table",
"label": "Appointments",
"rows": rows
}
return appointments_dic
