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