def ui_table_from_df(df: pd.DataFrame,
name: str = '',
sortables: list = None,
filterables: list = None,
searchables: list = None,
min_widths: dict = None,
max_widths: dict = None,
multiple: bool = False,
link_col: str = None,
height: str = '500px') -> ui.table:
"""
Convert a dataframe into Q ui.table format.
"""
if not sortables:
sortables = []
if not filterables:
filterables = []
if not searchables:
searchables = []
if not min_widths:
min_widths = {}
if not max_widths:
max_widths = {}
columns = [
ui.table_column(
name=str(x),
label=str(x),
sortable=True if x in sortables else False,
filterable=True if x in filterables else False,
searchable=True if x in searchables else False,
min_width=min_widths[x] if x in min_widths.keys() else None,
max_width=max_widths[x] if x in max_widths.keys() else None,
link=True if x == link_col else False) for x in df.columns.values
]
try:
table = ui.table(name=name,
columns=columns,
rows=[
ui.table_row(name=str(i),
cells=[
str(df[col].values[i])
for col in df.columns.values
]) for i in range(df.shape[0])
],
multiple=multiple,
height=height)
except Exception:
table = ui.table(
name=name,
columns=[ui.table_column('x', 'x')],
rows=[ui.table_row(name='ndf', cells=[str('No data found')])])
return table
async def render_customer_selector(q: Q):
clear_page(q)
columns = [
ui.table_column(name=column,
label=column,
sortable=True,
searchable=True)
for column in q.app.customer_df.columns
]
rows = [
ui.table_row(name=str(index), cells=row.tolist())
for index, row in q.app.customer_df.applymap(str).iterrows()
]
q.client.cards.add('customer_table')
q.page['customer_table'] = ui.form_card(
box='customer_table',
items=[
ui.message_bar(text='Click "Status" to review a customer',
type='info'),
ui.table(
name='customer_table',
columns=columns,
rows=rows,
groupable=True,
multiple=False,
)
])
def make_issue_table(allow_multiple_selection=False):
return ui.table(
name='issues',
columns=columns,
rows=[ui.table_row(name=issue.id, cells=[issue.text, issue.status, str(issue.views)]) for issue in issues],
multiple=allow_multiple_selection
)
def dai_instances_table(dai_instances: list):
# dai instances in ui.table
return ui.table(
name='table_dai',
columns=[
ui.table_column(name='id',
label='Id',
min_width='50px',
max_width='51px',
link=False),
ui.table_column(name='name', label='Name', link=False),
ui.table_column(name='status',
label='Status',
cell_type=ui.icon_table_cell_type(color='#CDDD38'),
link=False),
ui.table_column(name='description',
label='Description',
link=False),
ui.table_column(name='version', label='Version', link=False)
],
rows=[
ui.table_row(str(i), [
str(dai_instances[i]['id']), dai_instances[i]['name'],
ICON_MAP[dai_instances[i]['status']],
dai_instances[i]['status'], dai_instances[i]['version']
]) for i in range(len(dai_instances))
])
def render_customer_details_table(q: Q, df, row):
q.page.add(
'risk_table_row',
ui.form_card(box='risk_table_selected',
items=[
ui.table(name='risk_table_row',
columns=[
ui.table_column(name="attribute",
label="Attribute",
sortable=False,
searchable=False,
max_width='100'),
ui.table_column(name="value",
label="Value",
sortable=False,
searchable=False,
max_width='100')
],
rows=get_transformed_df_rows(
q, df.loc[[row]]),
groupable=False,
resettable=False,
multiple=False,
height='100%')
]))
def make_ui_table(file_path: str,
name: str,
n_rows: int = 20,
first_col: str = None):
"""Creates a ui.table object from a csv file"""
df = pd.read_csv(file_path)
df = df.replace(np.nan, '', regex=True)
n_rows = min(n_rows, df.shape[0])
columns = [
ui.table_column(name=str(x), label=str(x), sortable=True)
for x in df.columns.values
]
if first_col is not None:
columns[0] = ui.table_column(name=first_col,
label=first_col,
sortable=True)
table = ui.table(name=name,
columns=columns,
rows=[
ui.table_row(name=str(i),
cells=[
str(df[col].values[i])
for col in df.columns.values
]) for i in range(n_rows)
])
return table
async def serve(q: Q):
if not q.client.initialized:
q.page['form'] = ui.form_card(
box='1 1 -1 11',
items=[
ui.textbox(name='search',
label='Search',
placeholder='Enter a keyword...',
trigger=True),
ui.table(name='issues',
columns=[
ui.table_column(name=name, label=name)
for name in column_names
],
rows=df_to_rows(addresses))
])
q.client.initialized = True
else:
items = q.page['form'].items
search_box = items[0].textbox
table = items[1].table
term: str = q.args.search
term = term.strip() if term else ''
search_box.value = term
table.rows = df_to_rows(
search_df(addresses, term) if len(term) else addresses)
await q.page.save()
async def serve(q: Q):
q.page['example'] = ui.form_card(box='1 1 6 7', items=[
ui.table(
name='issues',
columns=columns,
rows=[ui.table_row(name=issue.id, cells=[issue.text, issue.tag]) for issue in issues],
)
])
await q.page.save()
async def serve(q: Q):
q.page['form'] = ui.form_card(box='1 1 -1 11', items=[
ui.table(
name='issues',
columns=columns,
rows=[ui.table_row(
name=issue.id,
cells=[issue.text, issue.status, issue.notifications, issue.icon, str(issue.views),
str(issue.progress)]) for issue in issues],
)
])
await q.page.save()
def make_ui_table(file_path: str, n_rows: int, name: str):
"""Creates a ui.table object from a csv file"""
df = pd.read_csv(file_path)
n_rows = min(n_rows, df.shape[0])
table = ui.table(
name=name,
columns=[ui.table_column(name=str(x), label=str(x), sortable=True) for x in df.columns.values],
rows=[ui.table_row(name=str(i), cells=[str(df[col].values[i]) for col in df.columns.values])
for i in range(n_rows)]
)
return table
async def serve(q: Q):
if q.args.show_inputs:
q.page['example'].items = [
ui.text(f'selected={q.args.issues}'),
ui.button(name='show_form', label='Back', primary=True),
]
else:
q.page['example'] = ui.form_card(box='1 1 -1 11', items=[
ui.table(
name='issues',
columns=columns,
rows=[ui.table_row(name=issue.id, cells=[issue.text]) for issue in issues],
values=['I1', 'I2', 'I3']
),
ui.button(name='show_inputs', label='Submit', primary=True)
])
await q.page.save()
def render_leaderboard(q: Q):
logger.debug("Creating leaderboard")
for c in q.client.cards:
del q.page[c]
# Create columns for our issue table.
columns = [
ui.table_column(name="user", label="User"),
ui.table_column(name="total",
label="Total Count",
sortable=True,
data_type="number"),
] + [
ui.table_column(
name=t.common_name,
label=t.common_name.title(),
sortable=True,
data_type="number",
) for t in q.client.trees.trees
]
rows = []
for filename in os.listdir(q.user.user.user_dir):
trees = Trees(file=os.path.join(q.user.user.user_dir, filename))
rows += [
ui.table_row(
name="row",
cells=[q.user.user.name,
str(trees.get_total_trees())] +
[str(t.count) for t in trees.trees],
)
]
table = ui.table(
name="tree_table",
columns=columns,
rows=rows,
downloadable=True,
)
q.page["leaderboard"] = ui.form_card(box=ui.boxes(ui.box("body"),
ui.box("top"),
ui.box("top")),
items=[table])
q.client.cards.append("leaderboard")
async def render(self, q: Q):
"""
Render card in Wave.
Args:
q: Wave server
"""
card = ui.form_card(box=self.box,
items=[
ui.table(name='table_tokens',
columns=self.get_wave_table_columns(),
rows=self.get_wave_table_rows(),
downloadable=True,
resettable=True)
],
title=self.title,
commands=self.commands)
q.page[self.name] = card
def render_home(q: Q):
init(q)
df = predictor.get_testing_data_as_pd_frame()
predicted_df = predictor.get_predict_data_as_pd_frame()
drop_column_from_df(df, 'default.payment.next.month')
add_column_to_df(df, predicted_df, 'Default Prediction Rate', 'predict')
df = round_df_column(df, 'Default Prediction Rate', 4)
q.page["risk_table"] = ui.form_card(
box='risk_table',
items=[
ui.message_bar(text='Double click to review a customer',
type='info'),
ui.table(name='risk_table',
columns=get_column_headers_for_df(df, True),
rows=get_rows(q, df),
groupable=True,
multiple=False,
height="800px")
])
async def serve(q: Q):
q.page['form'] = ui.form_card(
box='1 1 -1 11',
items=[
ui.table(name='issues',
columns=columns,
rows=[
ui.table_row(name=issue.id,
cells=[
issue.text, issue.status,
issue.notifications, issue.icon,
str(issue.views), issue.progress,
issue.created
]) for issue in issues
],
groupable=True,
downloadable=True,
resettable=True,
height='800px')
])
await q.page.save()
def make_table(q: Q):
n = 10
q.client.df = pd.DataFrame({
'length':
np.random.rand(n),
'width':
np.random.rand(n),
'data_type':
np.random.choice(a=['Train', 'Test'], size=n, p=[0.8, 0.2])
})
table = ui.table(name='my_table',
columns=[
ui.table_column(name=x, label=x)
for x in q.client.df.columns.tolist()
],
rows=[
ui.table_row(name=i,
cells=q.client.df.values[i].tolist())
for i in range(n)
])
q.page['show_table'] = ui.form_card(box='1 1 6 6', items=[table])
async def serve(q: Q):
hash = q.args['#']
if hash == 'form':
q.page['navigation'] = ui.form_card(box='1 1 -1 11', items=[
ui.table(
name='issues',
columns=columns,
rows=[ui.table_row(
name=issue.id,
cells=[issue.to_sid, issue.from_sid, issue.quote, issue.author,
issue.quote_category, issue.vote, str(issue.quote_length), str(issue.num_unique_words)]
) for issue in issues],
groupable=True,
downloadable=False,
resettable=True,
height='800px'
),
ui.button(name='show_tabs', label='Back', primary=True),
])
elif hash == 'home':
q.page['navigation'] = ui.form_card(box='1 1 4 -1', items=[
ui.text(sample_markdown),
ui.button(name='show_tabs', label='Back', primary=True),
])
else:
q.page['navigation'] = ui.tab_card(
box='1 1 4 1',
items=[
ui.tab(name='#home', label='Home'),
ui.tab(name='#form', label='Quote Table')
],
link = True,
)
await q.page.save()
async def show_private_leaderboard(q: Q):
columns = [
ui.table_column(
name='game_id',
label='Game #',
sortable=False,
searchable=False,
max_width='150',
data_type='string',
link=False,
),
ui.table_column(
name='number',
label='Number',
sortable=True,
max_width='90',
data_type='number',
),
ui.table_column(
name='num_of_guesses',
label='# of Guesses',
sortable=True,
max_width='120',
data_type='number',
),
ui.table_column(
name='status',
label='Status',
sortable=False,
filterable=True,
max_width='90',
data_type='string',
cell_type=ui.icon_table_cell_type(),
),
ui.table_column(
name='game_time',
label='Time (s)',
sortable=True,
max_width='150',
data_type='number',
),
]
scores = [
ui.table_row(
name=game.game_id,
cells=[
str(idx),
str(game.number),
str(len(game.guesses)),
'MedalSolid' if game.status == 'done' else 'Running',
str(game.time_seconds()),
],
) for idx, game in enumerate(q.user.player.games.values(), 1)
]
leaderboard = ui.table(
name='leaderboard',
columns=columns,
rows=scores,
groupable=False,
downloadable=False,
resettable=False,
height='600px',
)
del q.page['starting_game']
q.page['leaderboard'] = ui.form_card(
box='3 2 5 9',
items=[
ui.label('Scores from your games'),
leaderboard,
ui.text_xs('Рађ'),
ui.buttons(
items=[
ui.button(name='start_game', label='Play', primary=True),
ui.button(name='leaderboard',
label='Show all games',
primary=True),
],
justify='center',
),
],
)
await q.page.save()
async def showProducts(q: Q):
global filter_product
global filter_manufacturer
global filter_supplier
global unit_measure
global gqty
items = [ui.tabs(name='menu', value=q.args.menu, items=tabs)]
print('---------------------------')
print('== PRODUCT TAB == ')
print('q.args.show_tables: ' + str(q.args.show_tables) +
', q.args.show_inputs: ' + str(q.args.show_inputs))
## the user have clicked 'Add' button but haven't clicked 'Submit' button yet
if (q.args.show_tables == None or q.args.show_tables == False) and (
q.args.show_inputs or q.args.product or q.args.manufacturer
or q.args.supplier or q.args.qty):
## need to get manufacturer data first (later used for the dropdown when adding new supplier)
df_m = pd.DataFrame(l_manufacturers,
columns=['manufacturer', 'product'])
df_s = pd.DataFrame(l_suppliers,
columns=['supplier', 'manufacturer', 'product'])
## if there is no manufacturer data
if len(df_m) == 0:
items.extend([
ui.message_bar(type='info',
text='Try adding manufacturer first'),
ui.button(name='goto_manufacturer',
label='Close',
primary=True)
])
## if there is no supplier data
elif len(df_s) == 0:
items.extend([
ui.message_bar(type='info', text='Try adding supplier first'),
ui.button(name='goto_supplier', label='Close', primary=True)
])
## if there is data on manufacturer and supplier, when the user click 'Add Product' button
else:
items.append(ui.text_xl(content='Add Product'))
print('q.args.product: ' + str(q.args.product) +
', q.args.manufacturer: ' + str(q.args.manufacturer) +
', q.args.supplier: ' + str(q.args.supplier))
if q.args.product and (filter_product == None
or q.args.product != filter_product):
filter_product = q.args.product
filter_manufacturer = None
filter_supplier = None
unit_measure = None
# selling_price = None
gqty = None
elif q.args.manufacturer and (
filter_manufacturer == None
or q.args.manufacturer != filter_manufacturer):
filter_manufacturer = q.args.manufacturer
filter_supplier = None
unit_measure = None
# selling_price = None
gqty = None
elif q.args.supplier and (filter_supplier == None
or q.args.supplier != filter_supplier):
filter_supplier = q.args.supplier
unit_measure = None
# selling_price = None
gqty = None
if q.args.qty:
gqty = q.args.qty
print(filter_product, filter_manufacturer, filter_supplier)
## PRODUCT
if filter_product != None:
items.append(
ui.dropdown(name='product',
label='Product',
choices=[
ui.choice(name=x, label=x)
for x in df_m['product'].unique()
],
trigger=True,
value=filter_product))
tmp_m = df_m[df_m['product'] ==
q.args.product]['manufacturer'].unique()
else:
items.append(
ui.dropdown(name='product',
label='Product',
choices=[
ui.choice(name=x, label=x)
for x in df_m['product'].unique()
],
trigger=True))
tmp_m = df_m['manufacturer'].unique()
## MANUFACTURER
if filter_manufacturer != None:
items.append(
ui.dropdown(
name='manufacturer',
label='Manufacturer',
choices=[ui.choice(name=x, label=x) for x in tmp_m],
trigger=True,
value=filter_manufacturer))
tmp_s = df_s[(df_s['product'] == filter_product)
& (df_s['manufacturer'] == filter_manufacturer
)]['supplier'].unique()
else:
items.append(
ui.dropdown(
name='manufacturer',
label='Manufacturer',
choices=[ui.choice(name=x, label=x) for x in tmp_m],
trigger=True))
tmp_s = df_s['supplier'].unique()
## SUPPLIER
if filter_supplier != None:
items.append(
ui.dropdown(
name='supplier',
label='Supplier',
choices=[ui.choice(name=x, label=x) for x in tmp_s],
trigger=True,
value=filter_supplier))
# selling_price = df_s[(df_s['product']==filter_product)&(df_s['manufacturer']==filter_manufacturer)
# &(df_s['supplier']==filter_supplier)]['selling_price'].values[0]
# unit_measure = df_s[(df_s['product']==filter_product)&(df_s['manufacturer']==filter_manufacturer)
# &(df_s['supplier']==filter_supplier)]['uom'].values[0]
else:
items.append(
ui.dropdown(
name='supplier',
label='Supplier',
choices=[ui.choice(name=x, label=x) for x in tmp_s],
trigger=True))
# selling_price = None
# items.append(ui.date_picker(name='purchase_date', label='Purchase Date'))
# items.append(ui.textbox(name='qty', label='Qty'))
# ## SELLING PRICE
# if selling_price!=None:
# items.append(ui.textbox(name='selling_price', label='Selling Price', value = str(selling_price)))
# else:
# items.append(ui.textbox(name='selling_price', label='Selling Price'))
# ## UOM
# if unit_measure!=None:
# items.append(ui.textbox(name='uom', label='Unit of Measurement', value = unit_measure, readonly = True))
# else:
# items.append(ui.dropdown(name='uom', label='Unit of Measurement', choices=[
# ui.choice(name=x, label=x) for x in uom
# ]))
# items.extend([
# # ui.date_picker(name='mfg_date', label='Mfg Date'),
# # ui.date_picker(name='exp_date', label='Exp Date'),
# ui.textbox(name='selling_price', label='Selling Price'),
# # ui.textbox(name='operational_cost', label='Operational Cost'),
# # ui.textbox(name='lvl', label='Order Point by level(%)'),
# # ui.textbox(name='schedule', label='Order Point Schedule (days)'),
# # ui.textbox(name='schedule_qty', label='Scheduled Qty'),
# # ui.textbox(name='rate', label='Avg. Consumption'),
# # ui.dropdown(name='freq', label='Consumption Frequency', choices=[
# # ui.choice(name=x, label=x, value='daily', readonly=True) for x in consumption
# # ]),
# ui.button(name='show_tables', label='Submit', primary=True)])
items.extend([
# ui.textbox(name='selling_price', label='Selling Price'),
ui.button(name='show_tables', label='Submit', primary=True)
])
else: ## first iteration goes here
filter_product = None
filter_manufacturer = None
filter_supplier = None
unit_measure = None
selling_price = None
gqty = None
## if q.args.show_tables == True
if q.args.show_tables:
# l_products.append([q.args.product, q.args.manufacturer, q.args.supplier, q.args.purchase_date, q.args.qty,
# q.args.uom, q.args.selling_price, q.args.mfg_date, q.args.exp_date, q.args.selling_price,
# q.args.operational_cost, q.args.lvl, q.args.schedule, q.args.schedule_qty, q.args.rate])
# p = Products(q.args.product, q.args.manufacturer, q.args.supplier, q.args.purchase_date, q.args.qty,
# q.args.uom, q.args.selling_price, q.args.mfg_date, q.args.exp_date, q.args.selling_price,
# q.args.operational_cost, q.args.lvl, q.args.schedule, q.args.schedule_qty, q.args.rate)
# l_products.append([q.args.product, q.args.manufacturer, q.args.supplier,
# q.args.uom])
l_products.append(
[q.args.product, q.args.manufacturer, q.args.supplier])
# p = Products(q.args.product, q.args.manufacturer, q.args.supplier,
# q.args.uom)
p = Products(q.args.product, q.args.manufacturer, q.args.supplier)
products.append(p)
items.append(
ui.message_bar(type='success',
text='You have successfully added a product'))
## if there is a product data
if len(products) > 0:
items.append(
ui.table(
name='products',
columns=column_product_table,
rows=[
ui.table_row(
name=product.id,
# cells=[product.product, product.manufacturer, product.supplier, product.selling_price,
# product.uom]
cells=[
product.product, product.manufacturer,
product.supplier
]) for product in products
],
groupable=True,
downloadable=True,
resettable=True,
height='500px'))
else: ## if there is no product data
items.append(ui.text_l(content='No Product found'))
# items.append(ui.button(name='show_inputs', label='Add Product', primary=True))
items.append(
ui.buttons([
ui.button(name='show_inputs',
label='Add Product',
primary=True),
ui.button(name='delete_button', label='Delete Product'),
ui.button(name='edit_button', label='Edit Product'),
]))
q.page['example'] = ui.form_card(box='1 2 -1 -1', items=items)
await q.page.save()
async def showManufacturers(q: Q):
items = [ui.tabs(name='menu', value=q.args.menu, items=tabs)]
print('---------------------------')
print('== MANUFACTURER TAB == ')
## when user is adding new manufacturer
if q.args.show_inputs:
items.extend([
ui.text_xl(content='Add Manufacturer'),
ui.textbox(name='manufacturer', label='Manufacturer'),
ui.textbox(name='product', label='Product'),
# ui.dropdown(name='uom', label='Unit of Measurement', choices=[
# ui.choice(name=x, label=x) for x in uom
# ]),
ui.button(name='show_tables', label='Submit', primary=True)
])
# ## when user is editing existing manufacturer
# elif q.args.edit_button:
# items.extend([ui.text_xl(content='Edit Manufacturer'),
# ui.textbox(name='manufacturer', label='Manufacturer'),
# # ui.textbox(name='product', label='Product'),
# # ui.dropdown(name='uom', label='Unit of Measurement', choices=[
# # ui.choice(name=x, label=x) for x in uom
# # ]),
# ui.button(name='show_tables', label='Submit', primary=True)])
## default goes here
else:
## user have click has clicked 'Submit' button after adding supplier
if q.args.show_tables:
l_manufacturers.append([q.args.manufacturer, q.args.product])
m = Manufacturers(q.args.manufacturer, q.args.product)
manufacturers.append(m)
items.append(
ui.message_bar(type='success',
text='You have successfully added a product'))
## GET ALL MANUFACTURERS DATA
## default view (if there's a manufacturer data)
if len(manufacturers) > 0:
items.append(
ui.table(name='manufacturers',
columns=column_manufacturer_table,
rows=[
ui.table_row(name=manufacturer.id,
cells=[
manufacturer.manufacturer,
manufacturer.product
]) for manufacturer in manufacturers
],
groupable=True,
downloadable=True,
resettable=True,
height='500px'))
## GET ALL MANUFACTURERS DATA
## default view (if there's no manufacturer data)
else:
items.append(ui.text_l(content='No Manufacturer found'))
# items.append(ui.button(name='show_inputs', label='Add Manufacturer', primary=True))
items.append(
ui.buttons([
ui.button(name='show_inputs',
label='Add Manufacturer',
primary=True),
ui.button(name='delete_button', label='Delete Manufacturer'),
ui.button(name='edit_button', label='Edit Manufacturer'),
]))
q.page['example'] = ui.form_card(box='1 2 -1 -1', items=items)
await q.page.save()
async def showSuppliers(q: Q):
items = [ui.tabs(name='menu', value=q.args.menu, items=tabs)]
print('items in supplier: ' + str(items))
## if user clicks 'Add Supplier'
if q.args.show_inputs:
## need to get manufacturer data first (later used for the dropdown when addiing new supplier)
df_m = pd.DataFrame(l_manufacturers,
columns=['manufacturer', 'product'])
## if there is no Manufacter data, then the user should add manufacturer data first
if len(df_m) == 0:
items.extend([
ui.message_bar(type='info',
text='Try adding manufacturer first'),
ui.button(name='goto_manufacturer',
label='Close',
primary=True)
])
## there's a manufacturer data, then go here
else:
items.extend([
ui.text_xl(content='Add Supplier'),
ui.textbox(name='supplier', label='Supplier'),
ui.dropdown(
name='manufacturer',
label='Manufacturer',
choices=[ ## dropdown existing manufacturers
ui.choice(name=x, label=x)
for x in df_m['manufacturer'].unique()
]),
ui.dropdown(
name='product',
label='Product',
choices=[ ## dropdown existing items
ui.choice(name=x, label=x)
for x in df_m['product'].unique()
]), ## product should based on the what manufacturer have
# ui.dropdown(name='uom', label='Unit of Measurement', choices=[ ## dropdown unit of measurement based on UOM variable above
# ui.choice(name=x, label=x) for x in uom
# ]),
# ui.textbox(name='selling_price', label='Price'),
# ui.textbox(name='lead_time', label='Lead Time(days)'),
# ui.textbox(name='delivery_time', label='Delivery Time(days)'),
ui.button(name='show_tables', label='Submit',
primary=True) ## submit button
])
## user hasn't clicked 'Add suppliers' button
else:
## user have click has clicked 'Submit' button after adding supplier
if q.args.show_tables:
l_suppliers.append(
[q.args.supplier, q.args.manufacturer, q.args.product]) ## !!!
s = Suppliers(q.args.supplier, q.args.manufacturer, q.args.product)
suppliers.append(s)
items.append(
ui.message_bar(type='success',
text='You have successfully added a supplier'))
## default view (if there's suppliers data)
if len(suppliers) > 0:
items.append(
ui.table(name='suppliers',
columns=column_supplier_table,
rows=[
ui.table_row(name=supplier.id,
cells=[
supplier.supplier,
supplier.manufacturer,
supplier.product
]) for supplier in suppliers
],
groupable=True,
downloadable=True,
resettable=True,
height='500px'))
## default view (if there's a supplier data)
else:
items.append(ui.text_l(content='No Supplier found'))
# items.append(ui.button(name='show_inputs', label='Add Supplier', primary=True))
items.append(
ui.buttons([
ui.button(name='show_inputs',
label='Add Supplier',
primary=True),
ui.button(name='delete_button', label='Delete Supplier'),
ui.button(name='edit_button', label='Edit Supplier'),
]))
q.page['example'] = ui.form_card(box='1 2 -1 -1', items=items)
await q.page.save()
async def serve(q: Q):
q.page['example'] = ui.form_card(box='1 1 4 10', items=[
ui.text_xl(content='Extra-large text, for headings.'),
ui.text_l(content='Large text, for sub-headings.'),
ui.text_m(content='Body text, for paragraphs and other content.'),
ui.text_s(content='Small text, for small print.'),
ui.text_xs(content='Extra-small text, for really small print.'),
ui.separator(label='A separator sections forms'),
ui.progress(label='A progress bar'),
ui.progress(label='A progress bar'),
ui.message_bar(type='success', text='Message bar'),
ui.textbox(name='textbox', label='Textbox'),
ui.label(label='Checkboxes'),
ui.checkbox(name='checkbox1', label='A checkbox'),
ui.checkbox(name='checkbox1', label='Another checkbox'),
ui.checkbox(name='checkbox1', label='Yet another checkbox'),
ui.toggle(name='toggle', label='Toggle'),
ui.choice_group(name='choice_group', label='Choice group', choices=[
ui.choice(name=x, label=x) for x in ['Egg', 'Bacon', 'Spam']
]),
ui.checklist(name='checklist', label='Checklist', choices=[
ui.choice(name=x, label=x) for x in ['Egg', 'Bacon', 'Spam']
]),
ui.dropdown(name='dropdown', label='Dropdown', choices=[
ui.choice(name=x, label=x) for x in ['Egg', 'Bacon', 'Spam']
]),
ui.dropdown(name='dropdown', label='Multi-valued Dropdown', values=[], choices=[
ui.choice(name=x, label=x) for x in ['Egg', 'Bacon', 'Spam']
]),
ui.combobox(name='combobox', label='Combobox', choices=['Choice 1', 'Choice 2', 'Choice 3']),
ui.slider(name='slider', label='Slider'),
ui.range_slider(name='range_slider', label='Range slider', max=99),
ui.spinbox(name='spinbox', label='Spinbox'),
ui.date_picker(name='date_picker', label='Date picker'),
ui.color_picker(name='color_picker', label='Color picker'),
ui.buttons([
ui.button(name='primary_button', label='Primary', primary=True),
ui.button(name='standard_button', label='Standard'),
ui.button(name='standard_disabled_button', label='Standard', disabled=True),
]),
ui.file_upload(name='file_upload', label='File upload'),
ui.table(name='table', columns=[
ui.table_column(name='col1', label='Column 1'),
ui.table_column(name='col2', label='Column 2'),
], rows=[
ui.table_row(name='row1', cells=['Text A', 'Text B']),
ui.table_row(name='row2', cells=['Text C', 'Text D']),
ui.table_row(name='row3', cells=['Text E', 'Text F']),
]),
ui.link(label='Link'),
ui.tabs(name='tabs', items=[
ui.tab(name='email', label='Mail', icon='Mail'),
ui.tab(name='events', label='Events', icon='Calendar'),
ui.tab(name='spam', label='Spam'),
]),
ui.expander(name='expander', label='Expander'),
ui.frame(path='https://example.com'),
ui.markup(content=html),
ui.template(
content=menu,
data=pack(dict(dishes=[
dict(name='Spam', price='$2.00'),
dict(name='Ham', price='$3.45'),
dict(name='Eggs', price='$1.75'),
]))
),
ui.picker(name='picker', label='Picker', choices=[
ui.choice('choice1', label='Choice 1'),
ui.choice('choice2', label='Choice 2'),
ui.choice('choice3', label='Choice 3'),
]),
ui.stepper(name='stepper', items=[
ui.step(label='Step 1', icon='MailLowImportance'),
ui.step(label='Step 2', icon='TaskManagerMirrored'),
ui.step(label='Step 3', icon='Cafe'),
]),
ui.visualization(
plot=ui.plot([ui.mark(type='interval', x='=product', y='=price', y_min=0)]),
data=data(fields='product price', rows=[(c, x) for c, x, _ in [f.next() for _ in range(n)]], pack=True),
),
ui.vega_visualization(
specification=spec,
data=data(fields=["a", "b"], rows=[
["A", rnd()], ["B", rnd()], ["C", rnd()],
["D", rnd()], ["E", rnd()], ["F", rnd()],
["G", rnd()], ["H", rnd()], ["I", rnd()]
], pack=True),
),
ui.button(name='show_inputs', label='Submit', primary=True),
])
await q.page.save()
async def render_customer_page(q: Q):
clear_page(q)
row_index = int(q.args.customer_table[0])
customer_row = q.app.customer_df.loc[row_index]
score = q.app.predictions_df.loc[row_index]
approve = bool(score < APPROVAL_THRESHOLD)
contribs = q.app.contributions_df.loc[row_index].drop('BiasTerm')
q.client.selected_customer_id = customer_row['ID']
# details
q.client.cards.add('customer_features')
q.page['customer_features'] = ui.form_card(
box='customer_features',
items=[
ui.table(name='customer_features',
columns=[
ui.table_column(name='attribute',
label='Attribute',
sortable=False,
searchable=False,
max_width='100'),
ui.table_column(name='value',
label='Value',
sortable=False,
searchable=False,
max_width='100')
],
rows=[
ui.table_row(name=index, cells=[index, row])
for index, row in customer_row.map(str).iteritems()
],
groupable=False,
resettable=False,
multiple=False,
height='525px')
])
# summary
top_feature = contribs.idxmin(axis=1) if approve else contribs.idxmax(
axis=1)
explanation_data = {
'will_or_will_not': 'will' if approve else 'will not',
'top_contributing_feature': top_feature,
'value_of_top_contributing_feature': str(customer_row[top_feature]),
'accept_or_reject': 'approve' if approve else 'reject',
}
explanation = (
"- This customer **{{will_or_will_not}}** most probably settle the next month credit card balance.\n"
"- Having a **{{top_contributing_feature}}** of **{{value_of_top_contributing_feature}}** is the top reason for that.\n"
"- It's recommended to **{{accept_or_reject}}** this customer.")
q.client.cards.add('customer_risk_explanation')
q.page['customer_risk_explanation'] = ui.markdown_card(
box='customer_risk_explanation',
title='Summary on Customer',
content='=' + explanation,
data=explanation_data,
)
# shap plot
shap_values = list(zip(contribs.index, contribs))
shap_values.sort(key=lambda x: x[1])
q.client.cards.add('customer_shap_plot')
q.page['customer_shap_plot'] = ui.plot_card(
box='customer_shap_plot',
title='Effectiveness of each attribute on defaulting next payment',
data=data(['label', 'value'], rows=shap_values),
plot=ui.plot([
ui.mark(type='interval',
x='=value',
x_title='Feature Contributions',
y='=label')
]))
# approve/reject buttons
q.client.cards.add('button_group')
q.page['button_group'] = ui.form_card(box='button_group',
items=[
ui.buttons([
ui.button(name='approve',
label='Approve',
primary=approve),
ui.button(
name='reject',
label='Reject',
primary=not approve),
])
])
async def show_leaderboard(q: Q):
columns = [
ui.table_column(
name='name',
label='Name',
sortable=True,
searchable=False,
max_width='230',
data_type='string',
link=False,
),
ui.table_column(
name='number',
label='Number',
sortable=True,
max_width='100',
data_type='number',
),
ui.table_column(
name='num_of_guesses',
label='# of Guesses',
sortable=True,
max_width='120',
data_type='number',
),
ui.table_column(
name='game_time',
label='Time (s)',
sortable=True,
max_width='160',
data_type='number',
),
]
scores = [
ui.table_row(
name=game.game_id,
cells=[
q.app.players[game.player_id].name,
str(game.number),
str(len(game.guesses)),
str(game.time_seconds()),
],
) for game in q.app.games.values()
]
leaderboard = ui.table(
name='leaderboard',
columns=columns,
rows=scores,
groupable=False,
downloadable=False,
resettable=False,
height='600px',
)
del q.page['starting_game']
q.page['leaderboard'] = ui.form_card(
box='3 2 5 9',
items=[
ui.label('Scores'),
leaderboard,
ui.text_xs('Рађ'),
ui.buttons(
items=[
ui.button(name='start_game', label='Play', primary=True),
ui.button(name='leaderboard',
label='Refresh',
primary=True),
ui.button(
name='private_leaderboard',
label='Show my games only',
primary=True,
),
],
justify='center',
),
],
)
await q.page.save()
async def serve(q: Q):
if not q.client.initialized:
image = 'https://images.pexels.com/photos/220453/pexels-photo-220453.jpeg?auto=compress&h=750&w=1260'
f = FakeCategoricalSeries()
q.client.primary = '#000000'
q.client.page = '#e2e2e2'
q.client.card = '#ffffff'
q.client.text = '#000000'
q.page['meta'] = ui.meta_card(
box='',
theme='custom',
layouts=[
ui.layout(breakpoint='xs',
zones=[
ui.zone('header'),
ui.zone('content',
direction=ui.ZoneDirection.ROW,
zones=[
ui.zone('colors', size='340px'),
ui.zone('preview')
]),
ui.zone('footer')
])
])
q.page['header'] = ui.header_card(box='header',
title='Theme generator',
subtitle='Color your app easily',
icon='Color',
icon_color='$card')
q.page['form'] = ui.form_card(box='colors',
items=[
ui.color_picker(
name='primary',
label='Primary',
trigger=True,
alpha=False,
inline=True,
value=q.client.primary),
ui.color_picker(name='text',
label='Text',
trigger=True,
alpha=False,
inline=True,
value=q.client.text),
ui.color_picker(name='card',
label='Card',
trigger=True,
alpha=False,
inline=True,
value=q.client.card),
ui.color_picker(name='page',
label='Page',
trigger=True,
alpha=False,
inline=True,
value=q.client.page),
ui.text_xl('Check contrast'),
get_contrast('text', 'card', q),
get_contrast('card', 'primary', q),
get_contrast('text', 'page', q),
get_contrast('page', 'primary', q),
ui.text_xl('Copy code'),
ui.frame(content=get_theme_code(q),
height='180px'),
])
q.page['sample'] = ui.form_card(
box='preview',
items=[
ui.text_xl(content='Sample App to show colors'),
ui.progress(label='A progress bar'),
ui.inline([
ui.checkbox(name='checkbox1',
label='A checkbox',
value=True),
ui.checkbox(name='checkbox2', label='Another checkbox'),
ui.checkbox(name='checkbox3',
label='Yet another checkbox'),
ui.toggle(name='toggle', label='Toggle', value=True),
]),
ui.inline([
ui.date_picker(name='date_picker', label='Date picker'),
ui.picker(name='picker',
label='Picker',
choices=[
ui.choice('choice1', label='Choice 1'),
ui.choice('choice2', label='Choice 2'),
ui.choice('choice3', label='Choice 3'),
]),
ui.combobox(name='combobox',
label='Combobox',
choices=['Choice 1', 'Choice 2', 'Choice 3']),
ui.persona(title='John Doe',
subtitle='Data Scientist',
size='s',
image=image),
]),
ui.slider(name='slider', label='Slider', value=70),
ui.link(label='Link'),
ui.inline(justify='between',
items=[
ui.stepper(name='stepper',
width='500px',
items=[
ui.step(label='Step 1',
icon='MailLowImportance'),
ui.step(
label='Step 2',
icon='TaskManagerMirrored'),
ui.step(label='Step 3',
icon='Cafe'),
]),
ui.tabs(name='menu',
value='email',
items=[
ui.tab(name='email',
label='Mail',
icon='Mail'),
ui.tab(name='events',
label='Events',
icon='Calendar'),
ui.tab(name='spam', label='Spam'),
]),
]),
ui.inline(items=[
ui.table(
name='table',
width='50%',
columns=[
ui.table_column(
name='name', label='Name', min_width='80px'),
ui.table_column(name='surname',
label='Surname',
filterable=True),
ui.table_column(name='age',
label='Age',
sortable=True),
ui.table_column(
name='progress',
label='Progress',
cell_type=ui.progress_table_cell_type(
color='$themePrimary')),
],
rows=[
ui.table_row(name='row1',
cells=['John', 'Doe', '25', '0.90']),
ui.table_row(name='row2',
cells=['Ann', 'Doe', '35', '0.75']),
ui.table_row(
name='row3',
cells=['Casey', 'Smith', '40', '0.33']),
],
height='330px',
),
ui.visualization(
width='50%',
plot=ui.plot([
ui.mark(type='interval',
x='=product',
y='=price',
y_min=0)
]),
data=data(fields='product price',
rows=[(c, x) for c, x, _ in
[f.next() for _ in range(20)]],
pack=True),
),
]),
ui.buttons([
ui.button(name='primary_button',
label='Primary',
primary=True),
ui.button(name='standard_button', label='Standard'),
ui.button(name='standard_disabled_button',
label='Disabled',
disabled=True),
ui.button(name='icon_button',
icon='Heart',
caption='Tooltip text'),
]),
])
q.page['footer'] = ui.footer_card(
box='footer', caption='(c) 2021 H2O.ai. All rights reserved.')
q.client.themes = [
ui.theme(name='custom',
text=q.client.text,
card=q.client.card,
page=q.client.page,
primary=q.client.primary)
]
q.client.initialized = True
if q.args.primary:
q.client.themes[0].primary = q.args.primary
q.client.primary = q.args.primary
if q.args.text:
q.client.themes[0].text = q.args.text
q.client.text = q.args.text
if q.args.card:
q.client.themes[0].card = q.args.card
q.client.card = q.args.card
if q.args.page:
q.client.themes[0].page = q.args.page
q.client.page = q.args.page
q.page['meta'].themes = q.client.themes
q.page['form'].items[5] = get_contrast('text', 'card', q)
q.page['form'].items[6] = get_contrast('card', 'primary', q)
q.page['form'].items[7] = get_contrast('text', 'page', q)
q.page['form'].items[8] = get_contrast('page', 'primary', q)
q.page['form'].items[10].frame.content = get_theme_code(q)
await q.page.save()
async def responsive_layout(q: Q):
if not q.user.columns:
q.user.columns = [
ui.table_column(name='Index',
label='Index',
searchable=True,
sortable=True,
data_type='number'),
ui.table_column(name='Started', label='Started', searchable=True),
ui.table_column(name='Ended', label='Ended', searchable=True),
ui.table_column(name='Duration',
label='Duration (mins)',
data_type='number'),
ui.table_column(name='Scores', label='Scores', data_type='number'),
]
if not q.client.LB_columns:
q.client.LB_columns = [
ui.table_column(name='User',
label='User',
searchable=True,
max_width='100px'),
ui.table_column(name='Scores',
label='Scores',
searchable=True,
max_width='100px',
sortable=True),
]
q.page['meta'] = ui.meta_card(
box='',
title='Streak Counter',
layouts=[
ui.layout(
# If the viewport width >= 0:
breakpoint='xs',
zones=[
# 80px high header
ui.zone('header', size='80px'),
# Use remaining space for content
ui.zone('content')
]),
ui.layout(
# If the viewport width >= 768:
breakpoint='m',
zones=[
# 80px high header
ui.zone('header', size='80px'),
# Use remaining space for body
ui.zone(
'body',
direction=ui.ZoneDirection.ROW,
zones=[
# 250px wide sidebar
ui.zone('sidebar', size='250px'),
# Use remaining space for content
ui.zone('content'),
]),
ui.zone('footer'),
]),
ui.layout(
# If the viewport width >= 1200:
breakpoint='xl',
width='1200px',
zones=[
# 80px high header
ui.zone('header', size='80px'),
# Use remaining space for body
ui.zone(
'body',
direction=ui.ZoneDirection.ROW,
zones=[
# 300px wide sidebar
ui.zone('sidebar', size='300px'),
# Use remaining space for other widgets
ui.zone(
'other',
zones=[
# Use one half for charts
ui.zone('charts',
direction=ui.ZoneDirection.ROW),
# Use other half for content
ui.zone('content', size='500px'),
]),
]),
ui.zone('footer'),
])
])
q.page['header'] = ui.header_card(
# Place card in the header zone, regardless of viewport size.
box='header',
title='Code Streak Counter',
subtitle='Count your programming Streak while staying healthy !!!',
)
q.page['LeaderBoard'] = ui.form_card(
# If the viewport width >= 0, place in content zone.
# If the viewport width >= 768, place in sidebar zone.
# If the viewport width >= 1200, place in sidebar zone.
box=ui.boxes('content', 'sidebar', 'sidebar'),
# title='Leader Board',
items=[
ui.text_l(content=f"Hi {q.auth.username.capitalize()}..!"),
ui.text_xl(
content=
f"Your Total Score: {q.user.stop_watch.df['Scores'].sum()}"),
ui.table(
name='leaderboard',
columns=q.client.LB_columns,
rows=[
ui.table_row(name=user, cells=[user, str(score)])
for user, score in q.app.lb_dict.items()
],
groupable=False,
downloadable=True,
resettable=False,
height='425px',
),
ui.link(name='logout',
label='Log Out',
button=True,
path=f'/_logout',
target='_current')
],
)
q.page['stopwatch'] = ui.form_card(
box=ui.boxes(
# If the viewport width >= 0, place as second item in content zone.
ui.box(zone='content', order=2),
# If the viewport width >= 768, place in content zone.
'content',
# If the viewport width >= 1200, place as first item in charts zone, use 2 parts of available space.
ui.box(zone='charts', order=1, size=2),
),
items=[
ui.text_xl(
content=
f"<h1><center>{str(q.user.stop_watch.minutes).zfill(2)} : {str(q.user.stop_watch.seconds).zfill(2)}</center></h1>"
),
ui.text_l(content=f"<center>Lets crack some code!</center>"),
ui.buttons([
ui.button(name='start', label='Start', primary=True),
ui.button(name='stop', label='Stop', primary=False)
],
justify='center')
],
)
q.page['UserStreaks'] = ui.markdown_card(
box=ui.boxes(
# If the viewport width >= 0, place as third item in content zone.
ui.box(zone='content', order=3),
# If the viewport width >= 768, place as second item in content zone.
ui.box(zone='content', order=2),
# If the viewport width >= 1200, place as second item in charts zone, use 1 part of available space.
ui.box(zone='charts', order=2, size=1),
),
title='User Streaks',
content="""=Last Streak Started: {{streak_start}}
<p data-test='UserStreaks_Last_Ended'>Last Streak Ended: {{streak_end}}</p>
<p data-test='UserStreaks_Total_Streaks'>Total Streaks: {{total_streaks}}</p>
Total Coding Time: {{total_time}}
""",
data=dict(streak_start=q.user.stop_watch.last_start,
streak_end=q.user.stop_watch.last_stop,
total_streaks=q.user.stop_watch.total_streaks,
total_time=f"{str(q.user.stop_watch.total_hours).zfill(2)} :\
{str(q.user.stop_watch.total_minutes).zfill(2)} : \
{str(q.user.stop_watch.total_seconds).zfill(2)}"))
q.page['history'] = ui.form_card(
box=ui.boxes(
# If the viewport width >= 0, place as fourth item in content zone.
ui.box(zone='content', order=4),
# If the viewport width >= 768, place as third item in content zone.
ui.box(zone='content', order=3),
# If the viewport width >= 1200, place in content zone.
'content'),
items=[
ui.table(name='streaks_table',
columns=q.user.columns,
rows=[
ui.table_row(name=str(row.Index + 1),
cells=[
str(row.Index + 1), row.Started,
row.Ended,
str(row.Duration),
str(row.Scores)
])
for row in q.user.stop_watch.df.itertuples()
],
groupable=False,
downloadable=True,
resettable=False,
height='425px')
],
title='History',
)
q.page['footer'] = ui.footer_card(box='footer', caption='(c) 2021 H2O.ai ')
