def _perform_layout(self):
ddk = import_ddk()
children = []
if self.title is not None:
children.append(ddk.Header([ddk.Title(self.title)]))
# Input card
sidebar_children = []
sidebar_children.append(
ddk.ControlCard(
children=self.get_containers("input"),
)
)
sidebar = ddk.Sidebar(
foldable=True,
children=sidebar_children,
style={"minWidth": self.sidebar_width if self.sidebar_width else "auto"},
)
children.append(sidebar)
output_card_children = []
output_card_children.extend(self.get_containers("output"))
output_card = ddk.ControlCard(output_card_children)
sidebar_companion = ddk.SidebarCompanion(output_card)
children.append(sidebar_companion)
return children
def _perform_layout(self):
ddk = import_ddk()
# Input card
input_card = ddk.ControlCard(
children=self.get_containers("input"),
width=self.input_width,
)
output_card_children = []
if self.title is not None:
output_card_children.append(ddk.CardHeader(title=self.title))
output_card_children.extend(self.get_containers("output"))
output_card = ddk.ControlCard(
children=output_card_children,
width=100 - self.input_width,
)
row_children = [input_card, output_card]
layout = ddk.Row(row_children)
return layout
def _perform_layout(self):
ddk = import_ddk()
import dash_core_components as dcc
children = []
if self.title is not None:
children.append(ddk.Header([ddk.Title(self.title)]))
# Input card
sidebar_children = []
sidebar_children.append(
ddk.ControlCard(
children=self.get_containers("input"),
)
)
sidebar = ddk.Sidebar(
foldable=True,
children=sidebar_children,
style={"minWidth": self.sidebar_width if self.sidebar_width else "auto"},
)
children.append(sidebar)
self._tabs.children = [
dcc.Tab(
value=role,
label=title,
children=ddk.ControlCard(list(reversed(self.get_containers(role)))),
)
for role, title in self.tab_roles.items()
]
sidebar_companion = ddk.SidebarCompanion(self._tabs)
children.append(sidebar_companion)
return children
def populate_modal(selected_ids, table_rows):
"""
Populate modal input rows based on the selected row from the table.
"""
data = chart_utils.get_loaded_data("SCHEDULEREPORTS_VISITSBYSTATUS",
"DATASET")
selected_rows = None
if selected_ids:
selected_rows = [table_rows[i] for i in selected_ids]
count = len(selected_ids)
# Autofill the dropdowns if one row is selected
if count == 1:
input_layout = custom_input_layout(
data,
selected_rows[0]["PATIENT"],
selected_rows[0]["TASK"],
selected_rows[0]["SCHEDULED_DATE"],
)
action_layout = take_action_layout(
data,
selected_rows[0]["ASSIGNED_TO"],
selected_rows[0]["STATUS"],
)
button_text = ("Take action (1 patient selected)", )
# Display the selected rows in a table if many rows are selected
else:
input_layout = fixed_input_layout(data, selected_rows)
action_layout = take_action_layout(data, None, None)
button_text = (
"Bulk action ({} patients selected)".format(count), )
# Display empty dropdowns if no rows are selected
else:
input_layout = custom_input_layout(data, None, None, None)
action_layout = take_action_layout(data, None, None)
button_text = "Take action"
redis_instance.hset("selected_rows", "DATASET", json.dumps(selected_rows))
modal_content = ddk.ControlCard(children=[input_layout, action_layout])
return modal_content, button_text, button_text
def _perform_layout(self):
ddk = import_ddk()
# No callbacks here. Must be constant or idempotent
card_children = []
if self.title:
card_children.append(ddk.CardHeader(title=self.title))
card_children.append(
html.Div(
style={"padding": 20}, children=html.Div(self.get_containers("output"))
)
)
card_children.append(html.Hr(style={"width": "100%", "margin": "auto"}))
card_children.extend(self.get_containers("input"))
layout = ddk.ControlCard(
children=card_children,
**filter_kwargs(width=self.width),
)
return layout
def layout():
# load data for display
orders_history_data = chart_utils.get_loaded_data("VW_ORDERS_HISTORY_FULL", "DATASET")
remove_cols = ['BRANCH', 'COLUMN_MAPPING', 'COLUMN_PARAMETERS']
type_arr = chart_utils.get_options(orders_history_data, "TYPE")
physician_arr = chart_utils.get_options(orders_history_data, "PHYSICIAN")
patient_arr = chart_utils.get_options(orders_history_data, "TYPE")
remove_cols = ['BRANCH', 'PAYOR', 'INTERNAL_REFERRAL_SOURCE',]
max_date = datetime.now()
pending_df = orders_history_data.loc[
orders_history_data["DATA_SOURCE_ARRAY"].str.contains(r'ORDERSPENDINGMDS', na=True)]
history_df = orders_history_data.loc[
orders_history_data["DATA_SOURCE_ARRAY"].str.contains(r'ORDERSHISTORY', na=True)]
tbs_df = orders_history_data.loc[
orders_history_data["DATA_SOURCE_ARRAY"].str.contains(r'ORDERSTOBESENT', na=True)]
children = html.Div(
[
ddk.Row(
[
ddk.DataCard(
id='orders_tobe_sent_count',
value=tbs_df.shape[0],
label = 'To Be Sent'
),
ddk.DataCard(
id='orders_pending_mds_count',
value=pending_df.shape[0] ,
label='Pending MD Signature'
),
ddk.DataCard(
id='orders_history_count',
value=history_df.shape[0] ,
label='Total Orders'
),
]
),
ddk.Row(
[
ddk.ControlCard(
[
html.Details(
[
html.Summary("About this app"),
html.P(
"""Select attributes to fine tune graphs and tables."""
),
]
),
ddk.ControlItem(
dcc.Dropdown(
options=type_arr,
multi=True,
placeholder="Select Type",
id="orders-type-selector"
# value=["Not Yet Started", "Saved"],
)
),
ddk.ControlItem(
dcc.Dropdown(
options=physician_arr,
multi=True,
placeholder="Select Physician",
id="orders-physician-selector"
# value=["Not Yet Started", "Saved"],
)
),
ddk.ControlItem(
dcc.Dropdown(
options=patient_arr,
multi=True,
placeholder="Select Patient",
id="orders-patient-selector"
# value=["Not Yet Started", "Saved"],
)
),
ddk.ControlItem(
dcc.DatePickerRange(
id="orders-date-picker",
min_date_allowed=pd.to_datetime(
orders_history_data["ORDER_DATE"].min()
),
max_date_allowed=max_date,
initial_visible_month=max_date,
start_date=max_date - timedelta(days=700),
end_date=max_date,
),
),
ddk.ControlItem(
html.Button(
id="orders-select-all-rows",
children="Select all matching records",
style={"margin": "auto"},
n_clicks=0,
)
),
],
width=25,
style={"overflow": "scroll"},
),
ddk.Card(
width=75,
children=[
ddk.CardHeader(
children=[
html.Div(
"Combined Orders View", style={"float": "left"},
),
]
),
ddk.Block(
ddk.DataTable(
columns=[
{"name": i.replace("_", " ").title(), "id": i}
for i in orders_history_data.columns if (i not in remove_cols)
],
data=orders_history_data.sort_values(by="PHYSICIAN").to_dict("records"),
filter_action="native",
page_action="native",
page_size=50,
row_selectable="multi",
id="orders-history-data-table",
style_cell={'fontSize': 12, 'font-family': 'sans-serif'},
style_table = {'overflowX': 'auto'},
),
style={"overflow": "scroll"}
),
]
),
]
),
]
)
return children
def layout():
patient_roster_data = patient_roster_df()
patient_roster_data["DOB"] = patient_roster_data["DOB"].astype(str)
redis_instance.hset("app-data", "PATIENT_ROSTER", json.dumps(patient_roster_data.to_dict("records")))
data = full_df()
data["SCHEDULED_DATE"] = data["SCHEDULED_DATE"].astype(str)
redis_instance.hset("app-data", "CENSUS_VISITS_BY_STATUS", json.dumps(data.to_dict("records")))
max_date = datetime.now()
children = html.Div(
[
ddk.Row(
[
ddk.Card(id="patient-roster-chart"),
]
),
ddk.Row(
[
ddk.ControlCard(
[
html.Details(
[
html.Summary("About this app"),
html.P(
"""Select attributes to fine tune graphs and tables."""
),
]
),
ddk.ControlItem(
dcc.Dropdown(
options=[
{"label": status, "value": status}
for status in sorted(
[
status
for status in data["STATUS"].unique()
if status
]
)
],
multi=True,
placeholder="Select Status",
id="census-status-selector"
#value=["Not Yet Started", "Saved"],
)
),
ddk.ControlItem(
dcc.Dropdown(
options=[
{"label": task, "value": task}
for task in sorted(
[
task
for task in data["TASK"].unique()
if task
]
)
],
multi=True,
placeholder="Select Task",
id="census-task-selector"
)
),
ddk.ControlItem(
dcc.Dropdown(
options=[
{"label": task_category, "value": task_category}
for task_category in sorted(
[
task_category
for task_category in data["TASK_CATEGORY"].unique()
if task_category
]
)
],
multi=True,
placeholder="Select Task Category",
id="census-task_category-selector"
)
),
ddk.ControlItem(
dcc.Dropdown(
options=[
{"label": clinician, "value": clinician,}
for clinician in sorted(
[
patient
for patient in data[
"ASSIGNED_TO"
].unique()
if patient
]
)
if clinician
],
multi=True,
placeholder="Select a Clinician",
id="census-clinician-selector",
)
),
ddk.ControlItem(
dcc.Dropdown(
multi=True,
placeholder="Select a Patient",
id="census-patient-selector",
)
),
ddk.ControlItem(
dcc.DatePickerRange(
id="census-date-picker",
min_date_allowed=pd.to_datetime(
data["SCHEDULED_DATE"].min()
),
max_date_allowed=max_date,
initial_visible_month=max_date,
start_date=max_date - timedelta(days=30),
end_date=max_date,
),
),
ddk.ControlItem(
html.Button(
id="census-select-all-rows",
children="Select all matching records",
style={"margin": "auto"},
n_clicks=0,
)
),
html.Div(
[
ddk.Modal(
id="census-modal-btn-outer",
children=[
html.Button(
id="census-expand-modal-2",
n_clicks=0,
children="Take action",
),
],
target_id="census-modal-content",
hide_target=True,
style={"float": "right"},
),
],
style={"margin": "auto"},
),
],
width=30,
style={"overflow": "scroll"},
),
ddk.Card(id="census-time-series"),
]
),
#ddk.Row(id="census-pie-charts"),
ddk.Card(
children=[
ddk.CardHeader(
children=[
html.Div(
"Table of selected tasks", style={"float": "left"},
),
html.Div(
[
ddk.Modal(
id="census-modal-btn-outer",
children=[
html.Button(
id="census-expand-modal",
n_clicks=0,
children="Take action",
)
],
target_id="census-modal-content",
hide_target=True,
style={"float": "right"},
),
ddk.Block(
id="census-modal-content",
children=html.Div(id="census-modal-div"),
style={
"width": "50%",
"margin": "auto",
"overflow": "scroll",
},
),
]
),
]
),
ddk.Block(
ddk.DataTable(
columns=[
{"name": i.replace("_", " ").title(), "id": i}
for i in data.columns if (i != 'BRANCH')
],
filter_action="native",
page_action="native",
page_size=50,
row_selectable="multi",
id="census-data-table",
style_cell={'fontSize': 12, 'font-family': 'sans-serif'}
),
style={"overflow": "scroll"}
),
]
),
]
)
return children
ddk.ControlCard(
id='map-controls',
children=[
ddk.CardHeader(title='Search for Funding'),
ddk.ControlItem(dcc.Dropdown(
id='province-dropdown',
options=[{
'label': i,
'value': i
} for i in province_list],
multi=True,
clearable=False,
value=province_list),
label='Province'),
ddk.ControlItem(dcc.Dropdown(
id='naics-dropdown',
options=[{
'label': i,
'value': i
} for i in naics_sect_list],
multi=True,
value=['Manufacturing'],
clearable=False,
),
label='NAICS Sector'),
ddk.ControlItem(dcc.Dropdown(
id='year-dropdown',
options=[{
'label': i,
'value': i
} for i in year_list],
multi=True,
clearable=False,
value=['2019_20 Only']),
label='Year'),
ddk.ControlItem(
dcc.Dropdown(
id='donor-dropdown',
options=[{
'label': i,
'value': i
} for i in donor_list],
multi=
True, # allow for multiple selections
value=
donor_list, # default value on app load
clearable=False,
),
label='Donor Program'),
ddk.ControlItem(
dcc.Input(
id='project-input',
maxLength=20,
multiple=False,
placeholder="enter keyword",
type="text",
disabled=True # DISABLED... for now!
),
label='Project Search')
]), # end of map-controls ControlCard
def layout():
# load data for display
orders_history_data = chart_utils.get_loaded_data("VIEW_ORDERSHISTORY", "DATASET")
orders_pending_mds_data = chart_utils.get_loaded_data("VIEW_ORDERSMANAGEMENT_ORDERSPENDINGMDS", "DATASET")
orders_tobe_sent_data = chart_utils.get_loaded_data("VIEW_ORDERSTOBESENT", "DATASET")
max_date = datetime.now()
order_number_data = pd.concat(
[orders_history_data["ORDER_NUMBER"], orders_pending_mds_data["ORDER_NUMBER"],
orders_tobe_sent_data["ORDER_NUMBER"]])
physician_data = pd.concat(
[orders_history_data["PHYSICIAN"], orders_pending_mds_data["PHYSICIAN"],
orders_tobe_sent_data["PHYSICIAN"]])
ordertype_data = pd.concat(
[orders_history_data["TYPE"], orders_pending_mds_data["TYPE"],
orders_tobe_sent_data["TYPE"]])
patient_data = pd.concat(
[orders_history_data["PATIENT"], orders_pending_mds_data["PATIENT"],
orders_tobe_sent_data["PATIENT"]])
children = html.Div(
[
ddk.Row(
[
ddk.DataCard(
id='orders_tobe_sent_count',
value=orders_tobe_sent_data.shape[0],
label = 'To Be Sent'
),
ddk.DataCard(
id='orders_pending_mds_count',
value=orders_pending_mds_data.shape[0] ,
label='Pending MD Signature'
),
ddk.DataCard(
id='orders_history_count',
value=orders_history_data.shape[0] ,
label='Total Orders'
),
]
),
ddk.Row(
[
ddk.ControlCard(
[
html.Details(
[
html.Summary("About this app"),
html.P(
"""Select attributes to fine tune graphs and tables."""
),
]
),
ddk.ControlItem(
dcc.Dropdown(
options=[
{"label": orderstype, "value": orderstype}
for orderstype in sorted(
[
orderstype
for orderstype in ordertype_data.unique()
if orderstype
]
)
],
multi=True,
placeholder="Select Type",
id="orders-type-selector"
# value=["Not Yet Started", "Saved"],
)
),
ddk.ControlItem(
dcc.Dropdown(
options=[
{"label": physician, "value": physician}
for physician in sorted(
[
physician
for physician in physician_data.unique()
if physician
]
)
],
multi=True,
placeholder="Select Physician",
id="orders-physician-selector"
# value=["Not Yet Started", "Saved"],
)
),
ddk.ControlItem(
dcc.Dropdown(
options=[
{"label": patient, "value": patient}
for patient in sorted(
[
patient
for patient in patient_data.unique()
if patient
]
)
],
multi=True,
placeholder="Select Patient",
id="orders-patient-selector"
# value=["Not Yet Started", "Saved"],
)
),
ddk.ControlItem(
dcc.DatePickerRange(
id="order-date-picker",
min_date_allowed=pd.to_datetime(
orders_history_data["ORDER_DATE"].min()
),
max_date_allowed=max_date,
initial_visible_month=max_date,
start_date=max_date - timedelta(days=30),
end_date=max_date,
),
),
ddk.ControlItem(
html.Button(
id="orders_tob_esent-select-all-rows",
children="Select all matching records",
style={"margin": "auto"},
n_clicks=0,
)
),
],
width=30,
style={"overflow": "scroll"},
),
ddk.Card(
children=[
ddk.CardHeader(
children=[
html.Div(
"Table of selected tasks", style={"float": "left"},
),
]
),
ddk.Block(
ddk.DataTable(
columns=[
{"name": i.replace("_", " ").title(), "id": i}
for i in orders_history_data.columns if (i != 'BRANCH')
],
data=orders_history_data.sort_values(by="PHYSICIAN").to_dict("records"),
filter_action="native",
page_action="native",
page_size=50,
row_selectable="multi",
id="orders-history-data-table",
style_cell={'fontSize': 12, 'font-family': 'sans-serif'}
),
style={"overflow": "scroll"}
),
]
),
]
),
]
)
return children
app = dash.Dash(__name__)
server = app.server
app.title = "AKDEL"
app.layout = ddk.App(children=[
ddk.Block(
ddk.ControlCard(
width=100,
rounded=True,
children=[
ddk.ControlItem(children=[
dcc.Dropdown(
id="dropdown", options=iex.companies, value="AAPL"),
ddk.ControlItem(width=50,
children=[
dcc.DatePickerRange(
id="datepicker",
start_date="2015-01-01",
end_date="2016-01-01",
display_format="YYYY-MM-DD")
])
])
],
)),
ddk.Block(children=[
ddk.DataCard(id="dc1", width=25, label="Dividend Yield", value="-"),
ddk.DataCard(id="dc2", width=25, label="Peg Ratio", value="-"),
ddk.DataCard(id="dc3", width=25, label="Beta", value="%"),
ddk.DataCard(id="dc4", width=25, label="Country", value="-"),
]),
ddk.Block(children=[
}, {
"label": "30 min",
"value": "30min"
}, {
"label": "1 hour",
"value": "1hour"
}]
app = dash.Dash()
app.layout = ddk.App(
show_editor=True,
children=[
ddk.ControlCard(
width=50,
children=[
ddk.ControlItem(children=[
dcc.Dropdown(id="dd1", options=symbols, value="BTCUSD")
])
]),
ddk.ControlCard(
width=25,
children=[
ddk.ControlItem(children=[
dcc.Dropdown(id="dd2", options=time, value="15min")
])
]),
ddk.ControlCard(
width=25,
children=[
ddk.ControlItem(
children=[dcc.Input(id="Input_Value", value=5)])
def layout():
# load data for display
episodesummdata = chart_utils.get_loaded_data(
"AXXESS_API.USER_INPUTS.VW_PENDING_ORDERS_TF_SIMPLE", "DATASET")
#reorder the columns
new_order = [
'INS_CODE', 'INITIAL_TIMELY_FILING', 'MRN', 'PATIENT',
'PATIENT_STATUS', 'DATE_OF_BIRTH', 'EPISODE_START_DATE',
'EPISODE_END_DATE', 'PHYSICIAN_NAME', 'PHYSICIAN_PHONE',
'PHYSICIAN_FACSIMILE', 'ORDERS_DETAILS', 'CONSOLIDATED_COMMENTS',
'COLOR', 'USER_UPDATE_DATE', 'NEW_COMMENTS', 'EPISODE_UNEARNED_AMOUNT',
'EPISODE_EARNED_AMOUNT', 'EPISODE_BILLED_AMOUNT', 'EPISODE_ADJUSTMENTS'
]
episodesummdata = episodesummdata[new_order]
claimsdetailsdata = chart_utils.get_loaded_data(
"AXXESS_API.RAW.VW_ALLPAYOR_BILLING_CLAIMS_DETAILS", "DATASET")
# print(episodesummdata.columns)
# print(claimsdetailsdata.columns)
gl_mrn_arr = chart_utils.get_options(episodesummdata, "MRN")
gl_ins_code_arr = chart_utils.get_options(episodesummdata, "INS_CODE")
gl_patient_arr = chart_utils.get_options(episodesummdata, "PATIENT")
gl_patient_status_arr = chart_utils.get_options(episodesummdata,
"PATIENT_STATUS")
remove_cols = ['BRANCH', 'COLUMN_MAPPING', 'COLUMN_PARAMETERS']
max_date = pd.to_datetime(episodesummdata['EPISODE_END_DATE']).max()
min_date = pd.to_datetime(episodesummdata['EPISODE_END_DATE']).min()
children = html.Div([
# block on the right
ddk.Block(
width=100,
children=[
ddk.Row([
ddk.Block(children=[
ddk.ControlCard(
orientation='horizontal',
width=100,
children=[
html.Details([
html.Summary("Filter here"),
html.
P("""Select attributes to fine tune tables."""
),
]),
ddk.ControlItem(
dcc.Dropdown(
options=gl_ins_code_arr,
multi=True,
placeholder="Select Ins code",
id="op-ins-code-selector"
# value=["Not Yet Started", "Saved"],
)),
ddk.ControlItem(
dcc.Dropdown(
options=gl_patient_arr,
multi=True,
placeholder="Select Patient",
id="op-patient-selector"
# value=["Not Yet Started", "Saved"],
)),
ddk.ControlItem(
dcc.Dropdown(
options=gl_mrn_arr,
multi=True,
placeholder="Select MRN",
id="op-mrn-selector"
# value=["Not Yet Started", "Saved"],
)),
ddk.ControlItem(
dcc.DatePickerRange(
id="op-episode-picker",
min_date_allowed=pd.to_datetime(
episodesummdata[
'EPISODE_START_DATE'].min()),
max_date_allowed=max_date,
initial_visible_month=max_date,
start_date=min_date,
end_date=max_date), ),
ddk.ControlItem(
html.Button(
id="op-select-all-rows",
children="Select all matching records",
style={"margin": "auto"},
n_clicks=0,
)),
],
)
]),
]),
ddk.Row([
ddk.Card(children=[
ddk.CardHeader(
title="Pending Orders",
children=[
html.Div([
ddk.Modal(
id="op-modal-btn-outer",
children=[
html.Button(
id="op-expand-modal",
n_clicks=0,
children="Take action",
)
],
target_id="op-modal-content",
hide_target=True,
style={"float": "right"},
),
ddk.Block(
id="op-modal-content",
children=html.Div(id="op-modal-div"),
style={
"width": "50%",
"margin": "auto",
"overflow": "scroll",
},
),
]),
],
),
ddk.Block(children=[
generate_table_layout(
episodesummdata, "PENDING ORDERS",
"pending_tf-table", "MRN", remove_cols)
])
]),
]),
ddk.Row([
ddk.Block(children=[
generate_table_layout(
claimsdetailsdata, "CLAIMS DETAILS",
"op_claims_details-table", "MRN", remove_cols)
])
]),
])
])
return children
dcc.Link('Team 2',
href=app.get_relative_path('/')),
]),
dcc.Link('Conditions', href=app.get_relative_path('/')),
dcc.Link('Historical', href=app.get_relative_path('/')),
dcc.Link('Portal', href=app.get_relative_path('/')),
])
app.layout = ddk.App([
ddk.Header([
ddk.Logo(src=app.get_asset_url('logo.png')),
ddk.Title(get_configuration()), menu
]),
ddk.Block(width=30,
children=[
ddk.ControlCard(controls),
ddk.ControlCard(controls),
ddk.ControlCard(controls),
]),
ddk.Block(width=70,
children=[
ddk.Row([
ddk.Card(width=50,
children=dcc.Markdown(
textwrap.dedent('''
Sed ut perspiciatis unde omnis iste natus
voluptatem accusantium doloremque laudantium,
totam rem aperiam, **expect similar results next week**
ab illo inventore veritatis et quasi architecto
beatae vitae dicta sunt explicabo.
'''))),
def layout():
data = chart_utils.get_loaded_data("SCHEDULEREPORTS_VISITSBYSTATUS","DATASET")
remove_cols = ['BRANCH','COLUMN_MAPPING', 'COLUMN_PARAMETERS']
max_date = datetime.now()
children = html.Div(
[
ddk.Row(
[
ddk.ControlCard(
[
html.Details(
[
html.Summary("About this app"),
html.P(
"""Select attributes to fine tune graphs and tables."""
),
]
),
ddk.ControlItem(
dcc.Dropdown(
options=[
{"label": status, "value": status,}
for status in sorted(
[
patient
for patient in data["STATUS"].unique()
if patient
]
)
],
multi=True,
placeholder="Select Status",
id="status-selector",
value=["Not Yet Started", "Saved"],
)
),
ddk.ControlItem(
dcc.Dropdown(
options=[
{"label": clinician, "value": clinician,}
for clinician in sorted(
[
patient
for patient in data[
"ASSIGNED_TO"
].unique()
if patient
]
)
if clinician
],
multi=True,
placeholder="Select a Clinician",
id="clinician-selector",
)
),
ddk.ControlItem(
dcc.Dropdown(
multi=True,
placeholder="Select a Patient",
id="patient-selector",
)
),
ddk.ControlItem(
dcc.DatePickerRange(
id="date-picker",
min_date_allowed=pd.to_datetime(
data["SCHEDULED_DATE"].min()
),
max_date_allowed=max_date,
initial_visible_month=max_date,
start_date=max_date - timedelta(days=30),
end_date=max_date,
),
),
ddk.ControlItem(
html.Button(
id="select-all-rows",
children="Select all matching records",
style={"margin": "auto"},
n_clicks=0,
)
),
html.Div(
[
ddk.Modal(
id="modal-btn-outer",
children=[
html.Button(
id="expand-modal-2",
n_clicks=0,
children="Take action",
),
],
target_id="modal-content",
hide_target=True,
style={"float": "right"},
),
],
style={"margin": "auto"},
),
],
width=30,
style={"overflow": "scroll"},
),
ddk.Card(id="time-series"),
]
),
ddk.Row(id="pie-charts"),
ddk.Card(
children=[
ddk.CardHeader(
title="Table of selected tasks",
children=[
html.Div(
[
ddk.Modal(
id="modal-btn-outer",
children=[
html.Button(
id="expand-modal",
n_clicks=0,
children="Take action",
)
],
target_id="modal-content",
hide_target=True,
style={"float": "right"},
),
ddk.Block(
id="modal-content",
children=html.Div(id="modal-div"),
style={
"width": "50%",
"margin": "auto",
"overflow": "scroll",
},
),
]
),
],
),
ddk.Block(
ddk.DataTable(
columns=[
{"name": i.replace("_", " ").title(), "id": i}
for i in data.columns if (i not in remove_cols)
],
data = data.sort_values(by="SCHEDULED_DATE").to_dict("records"),
filter_action="native",
page_action="native",
page_size=25,
row_selectable="multi",
id="data-table",
style_cell={'fontSize': 12, 'font-family': 'sans-serif'}
),
style={"overflow": "scroll"}
),
]
),
]
)
return children
def layout():
# load data for display
authorizations_data = chart_utils.get_loaded_data("VW_AUTHORIZATIONS", "DATASET")
patient_status_arr = chart_utils.get_options(authorizations_data, "PATIENTSTATUS")
discipline_arr = chart_utils.get_options(authorizations_data, "DISCIPLINE")
auth_type_arr = chart_utils.get_options(authorizations_data, "AUTHORIZATION_TYPE")
payer_arr = chart_utils.get_options(authorizations_data, "PAYER")
patient_arr = chart_utils.get_options(authorizations_data, "PATIENT")
remove_cols = ['BRANCH','COLUMN_MAPPING', 'COLUMN_PARAMETERS' ]
max_date = datetime.now()
#pending_df = authorizations_data.loc[authorizations_data["DATA_SOURCE_ARRAY"].str.contains(r'authsPENDINGMDS', na=True)]
#history_df = authorizations_data.loc[authorizations_data["DATA_SOURCE_ARRAY"].str.contains(r'authsHISTORY', na=True)]
#tbs_df = authorizations_data.loc[ authorizations_data["DATA_SOURCE_ARRAY"].str.contains(r'authsTOBESENT', na=True)]
children = html.Div(
[
ddk.Row(
[
ddk.DataCard(
id='auths_patient_status_count',
value=12 ,#tbs_df.shape[0],
label = 'Patient Status Count'
),
ddk.DataCard(
id='auths_auth_type_count',
value=13,#pending_df.shape[0] ,
label='Authorization Type Count'
),
ddk.DataCard(
id='auths_total_count',
value=authorizations_data.shape[0] ,
label='Total Authorizations'
),
]
),
ddk.Row(
[
ddk.ControlCard(
[
html.Details(
[
html.Summary("About this app"),
html.P(
"""Select attributes to fine tune graphs and tables."""
),
]
),
ddk.ControlItem(
dcc.Dropdown(
options=auth_type_arr,
multi=True,
placeholder="Select Authorization Type",
id="auths-auth-type-selector"
# value=["Not Yet Started", "Saved"],
)
),
ddk.ControlItem(
dcc.Dropdown(
options=discipline_arr,
multi=True,
placeholder="Select Discipline",
id="auths-discipline-selector"
# value=["Not Yet Started", "Saved"],
)
),
ddk.ControlItem(
dcc.Dropdown(
options=patient_arr,
multi=True,
placeholder="Select Patient",
id="auths-patient-selector"
# value=["Not Yet Started", "Saved"],
)
),
ddk.ControlItem(
dcc.Dropdown(
options=patient_status_arr,
multi=True,
placeholder="Select Discipline",
id="auths-patientstatus-selector"
# value=["Not Yet Started", "Saved"],
)
),
ddk.ControlItem(
dcc.Dropdown(
options=payer_arr,
multi=True,
placeholder="Select Payer",
id="auths-payer-selector"
# value=["Not Yet Started", "Saved"],
)
),
ddk.ControlItem(
dcc.DatePickerRange(
id="auths-date-picker",
min_date_allowed=pd.to_datetime(
authorizations_data["START_DATE"].min()
),
max_date_allowed=max_date,
initial_visible_month=max_date,
start_date=max_date - timedelta(days=700),
end_date=max_date +timedelta(days=700),
),
),
ddk.ControlItem(
html.Button(
id="auths-select-all-rows",
children="Select all matching records",
style={"margin": "auto"},
n_clicks=0,
)
),
],
width=25,
style={"overflow": "scroll"},
),
ddk.Card(
width=75,
children=[
ddk.CardHeader(
children=[
html.Div(
"Combined auths View", style={"float": "left"},
),
]
),
ddk.Block(
ddk.DataTable(
columns=[
{"name": i.replace("_", " ").title(), "id": i}
for i in authorizations_data.columns if (i not in remove_cols)
],
data=authorizations_data.sort_values(by="START_DATE").to_dict("records"),
filter_action="native",
page_action="native",
page_size=50,
row_selectable="multi",
id="auths-history-data-table",
style_cell={'fontSize': 12, 'font-family': 'sans-serif'},
style_table = {'overflowX': 'auto'},
),
style={"overflow": "scroll"}
),
]
),
]
),
]
)
return children
def layout():
# load data for display
episodicdata = chart_utils.get_loaded_data("AXXESS_API.RAW.MEDICARE_MCRADV_VISITPLANNING_NOAUTH", "DATASET")
pervisitdata = chart_utils.get_loaded_data("AXXESS_API.RAW.MANAGEDCARE_VISITPLANNING_NOAUTH", "DATASET")
currentepisodic = chart_utils.get_loaded_data("AXXESS_API.RAW.VW_MEDICARE_MCRADV_VISITPLANNING_CURRENT_EPISODES","DATASET")
lupa_riskdata = chart_utils.get_loaded_data("AXXESS_API.RAW.VW_MEDICARE_MCRADV_LUPA_RISK", "DATASET")
#reorder the columns
'''
new_order = ['INS_CODE',
'INITIAL_TIMELY_FILING',
'MRN',
'PATIENT',
'PATIENT_STATUS',
'DATE_OF_BIRTH',
'EPISODE_START_DATE',
'EPISODE_END_DATE',
'PHYSICIAN_NAME',
'PHYSICIAN_PHONE',
'PHYSICIAN_FACSIMILE',
'ORDERS_DETAILS',
'CONSOLIDATED_COMMENTS',
'COLOR',
'USER_UPDATE_DATE',
'NEW_COMMENTS',
'EPISODE_UNEARNED_AMOUNT',
'EPISODE_EARNED_AMOUNT',
'EPISODE_BILLED_AMOUNT',
'EPISODE_ADJUSTMENTS'
]
'''
gl_mrn_arr = chart_utils.get_options(episodicdata, "MRN")
gl_ins_code_arr = chart_utils.get_options(episodicdata, "INS_CODE")
gl_patient_arr = chart_utils.get_options(episodicdata, "PATIENT")
gl_patient_status_arr = chart_utils.get_options(episodicdata, "PATIENT_STATUS")
gl_pcc_arr = chart_utils.get_options(currentepisodic, "CASE_MANAGER_NAME")
gl_lupa_risk_arr = chart_utils.get_options(currentepisodic, "LUPA_RISK")
remove_cols = ['INS_CODE', 'OASIS_STATUS', 'OASIS_DETAILS', 'EPISODE_PRIMARY_INSURANCE_NAME', 'DATE_OF_BIRTH',
'PHONE','PHYSICIAN_FACSIMILE', 'PHYSICIAN_NAME', 'PHYSICIAN_PHONE', 'ZIP', 'ORDERS_STATUS', 'ORDERS_DETAILS',
'EARLY_LUPA_RISK', 'LATE_LUPA_RISK', 'EARLY_ORIGINAL_PROSPECTIVE_PAY',
'LATE_ORIGINAL_PROSPECTIVE_PAY', 'TOTAL_COST', 'TOTAL_PROFIT', 'EARLY_COST', 'EARLY_PROFIT',
'LATE_COST', 'LATE_PROFIT', 'EPISODE_BILLED_AMOUNT', 'EPISODE_ADJUSTMENTS', 'EPISODE_EARNED_AMOUNT',
'EPISODE_UNEARNED_AMOUNT', 'SCHEDULE_ACTIVE', 'COMPLETED_VISITS', 'TOTAL_VISITS' , 'TOTAL_BILLABLE_HHA_VISITS'
]
max_date = pd.to_datetime(episodicdata['EPISODE_END_DATE']).max()
today = dt.now().date()
sixtydaysprior = today
sixtydaysprior += datetime.timedelta(days=-60)
#min_date = pd.to_datetime(episodicdata['EPISODE_END_DATE']).min()
children = html.Div([
# block on the right
ddk.Block(
width=100,
children=[
ddk.Row([
ddk.Block(
children=[
ddk.ControlCard(
orientation='horizontal',
width = 100,
children=[
ddk.ControlItem(
dcc.Dropdown(
options=gl_ins_code_arr,
multi=True,
placeholder="Select",
id="vp-ins-code-selector",
# value=["Not Yet Started", "Saved"],
style = {
'fontSize': 12,
'font-family': 'sans-serif',
}
),
width = 10,
label='Billing Code',
style={
'fontSize': 12,
'font-family': 'sans-serif',
}
),
ddk.ControlItem(
dcc.Dropdown(
options=gl_patient_arr,
multi=True,
placeholder="Select",
id="vp-patient-selector",
style = {
'fontSize': 12,
'font-family': 'sans-serif',
}
),
width=10,
label='Patient',
label_text_alignment='center',
style={
'fontSize': 12,
'font-family': 'sans-serif',
}
),
ddk.ControlItem(
dcc.Dropdown(
options=gl_mrn_arr,
multi=True,
placeholder="Select",
id="vp-mrn-selector",
style={
'fontSize': 12,
'font-family': 'sans-serif',
}
),
width =10,
label='MRN',
label_text_alignment='center',
style={
'fontSize': 12,
'font-family': 'sans-serif',
}
),
ddk.ControlItem(
dcc.Dropdown(
options=gl_patient_status_arr,
id="vp-patient-status-selector",
multi=True,
placeholder="Select",
value=['Active'],
style={
'fontSize': 12,
'font-family': 'sans-serif',
}
),
width = 10,
label = 'Patient Status',
label_text_alignment='center',
style={
'fontSize': 12,
'font-family': 'sans-serif',
}
),
ddk.ControlItem(
dcc.Slider(
id='vp-margin-slider',
min=-50,
max=100,
step=10,
marks={-50: '-50',
-40: '-40',
-20: '-20',
-10: '-10',
0: '0',
10: '10',
20: '20',
40: '40',
60: '60',
80: '80',
100: '100',
},
value=20,
),
width = 20,
label='Margin (%)',
label_text_alignment='center',
style={
'fontSize': 12,
'font-family': 'sans-serif',
}
),
ddk.ControlItem(
dcc.Dropdown(
options=gl_pcc_arr,
multi=True,
placeholder="select",
id="vp-case-manager-selector",
style={
'fontSize': 12,
'font-family': 'sans-serif',
}
),
width=10,
label='Case Manager',
label_text_alignment= 'center',
style={
'fontSize': 12,
'font-family': 'sans-serif',
}
),
ddk.ControlItem(
dcc.DatePickerRange(
id="vp-episode-picker",
min_date_allowed=pd.to_datetime(episodicdata['EPISODE_START_DATE'].min()
),
max_date_allowed=max_date,
initial_visible_month=max_date,
start_date=sixtydaysprior,
end_date=max_date
),
width = 20,
label='Episode Range',
label_text_alignment='center',
style={
'fontSize': 12,
'font-family': 'sans-serif',
}
),
ddk.ControlItem(
dcc.Dropdown(
options=gl_lupa_risk_arr,
multi=True,
placeholder="select",
id="vp-lupa-risk-selector",
style={
'fontSize': 12,
'font-family': 'sans-serif',
}
),
width=10,
label='LUPA RISK',
label_text_alignment='center',
style={
'fontSize': 12,
'font-family': 'sans-serif',
}
),
], )
]
),
]),
ddk.Row([
ddk.Card(
children=[
ddk.CardHeader(
title="VISIT PLANNING",
children=[
html.Div(
[
ddk.Modal(
id="vp-modal-btn-outer",
children=[
html.Button(
id="vp-expand-modal",
n_clicks=0,
children="Take action",
)
],
target_id="vp-modal-content",
hide_target=True,
style={"float": "right"},
),
ddk.Block(
id="vp-modal-content",
children=html.Div(id="vp-modal-div"),
style={
"width": "50%",
"margin": "auto",
"overflow": "scroll",
},
),
ddk.DataCard(
id='vp_episodic_selected_count',
value=currentepisodic.shape[0],
label='Episodic Selected Count',
style={
'fontSize': 12,
'font-family': 'sans-serif',
}
),
]
),
],
),
ddk.Block(
dcc.Tabs(id='tabs-example',
value='tab-1',
children=[
dcc.Tab(label='EPISODIC',
children=[generate_table_layout(episodicdata, "","vp_episodic-table", "MRN", remove_cols)]
),
dcc.Tab(label='PERVISIT',
children=[generate_table_layout(pervisitdata, "","vp_pervisit-table", "MRN", remove_cols)]),
]
),
)
]
),
]),
]
)
])
return children
def layout():
# load data for display
episodesummdata = chart_utils.get_loaded_data(
"AXXESS_API.RAW.VW_ALLPAYOR_EPISODE_BILLING_TIMELYFILING", "DATASET")
#reorder the columns
new_order = [
'INSURANCE_CODE', 'INITIAL_TIMELY_FILING', 'MRN', 'PATIENT',
'PATIENT_STATUS', 'EPISODE_START_DATE', 'EPISODE_END_DATE',
'INSURANCE', 'AUTH_REQUIRED', 'EPISODE_UNEARNED_AMOUNT',
'EPISODE_EARNED_AMOUNT', 'EPISODE_BILLED_AMOUNT',
'EPISODE_ADJUSTMENTS', 'ORDERS_DETAILS', 'PHYSICIAN_NAME',
'PHYSICIAN_PHONE', 'PHYSICIAN_FACSIMILE',
'Auth #|Auth type|Range|Discipline|Authorized|Used|Unused|Units|'
]
episodesummdata = episodesummdata[new_order]
claimsdetailsdata = chart_utils.get_loaded_data(
"AXXESS_API.RAW.VW_ALLPAYOR_BILLING_CLAIMS_DETAILS", "DATASET")
# print(episodesummdata.columns)
# print(claimsdetailsdata.columns)
gl_mrn_arr = chart_utils.get_options(episodesummdata, "MRN")
gl_ins_code_arr = chart_utils.get_options(episodesummdata,
"INSURANCE_CODE")
gl_auth_reqd_arr = chart_utils.get_options(episodesummdata,
"AUTH_REQUIRED")
gl_patient_status_arr = chart_utils.get_options(episodesummdata,
"PATIENT_STATUS")
remove_cols = ['BRANCH', 'COLUMN_MAPPING', 'COLUMN_PARAMETERS']
max_date = pd.to_datetime(episodesummdata['EPISODE_END_DATE']).max()
min_date = pd.to_datetime(episodesummdata['EPISODE_END_DATE']).min()
children = html.Div([
# block on the right
ddk.Block(
width=100,
children=[
ddk.Row([
ddk.Block(children=[
ddk.ControlCard(
orientation='horizontal',
width=100,
children=[
html.Details([
html.Summary("Filter here"),
html.
P("""Select attributes to fine tune tables."""
),
]),
ddk.ControlItem(
dcc.Dropdown(
options=gl_ins_code_arr,
multi=True,
placeholder="Select Ins code",
id="billing-ins-code-selector"
# value=["Not Yet Started", "Saved"],
)),
ddk.ControlItem(
dcc.Dropdown(
options=gl_auth_reqd_arr,
multi=True,
placeholder="Select Auth Reqd Status",
id="billing-auth-reqd-selector"
# value=["Not Yet Started", "Saved"],
)),
ddk.ControlItem(
dcc.Dropdown(
options=gl_mrn_arr,
multi=True,
placeholder="Select MRN",
id="billing-mrn-selector"
# value=["Not Yet Started", "Saved"],
)),
ddk.ControlItem(
dcc.DatePickerRange(
id="billing-episode-picker",
min_date_allowed=pd.to_datetime(
episodesummdata[
'EPISODE_START_DATE'].min()),
max_date_allowed=max_date,
initial_visible_month=max_date,
start_date=min_date,
end_date=max_date), ),
ddk.ControlItem(
html.Button(
id="billing-select-all-rows",
children="Select all matching records",
style={"margin": "auto"},
n_clicks=0,
)),
],
)
]),
]),
ddk.Row([
ddk.Block(children=[
generate_table_layout(
episodesummdata, "ALL PAYOR EPISODES",
"all_payor_episodes-table", "MRN", remove_cols)
])
]),
ddk.Row([
ddk.Block(children=[
generate_table_layout(
claimsdetailsdata, "CLAIMS DETAILS",
"claims_details-table", "MRN", remove_cols)
])
]),
])
])
return children
