data = context.sale_order_module.SaleOrderModule_zGetQuantityList()
context.Base_convertResultsToBigArray(data, reference='WendelinJupyter')

context.Base_fillPandasInventoryCategoryList('WendelinJupyter',)

swimsuit_uid = 17408
resource_product_line_uid = 19534

data_frame = context.Base_getInventoryDataFrame(
    is_accountable=False,
    omit_input=True,
    resource_uid=17408,
    from_date='2015-08-11',
    to_date='2015-09-13',
    simulation_state='planned',
    resource_product_line_uid='19534'
)
data_frame.head()


import random
import pandas as pd    


df = context.Base_getInventoryDataFrame(
    is_accountable=False,
    omit_input=True,
    simulation_state='planned',
    resource_uid=17408,
    from_date='2015-08-11',
    to_date='2015-09-13',
)

# bar chart: sum of quantity vs date by resource_uid/node_uid
columns = ['date', 'resource_uid', 'quantity', 'quantity', 'node_uid']
columns_to_delete = df.columns - columns
for column in columns_to_delete:
    df.drop(column, axis=1, inplace=True)
context.Base_renderAsHtml(
    context.Base_erp5PivotTableUI(df)
)

from IPython.display import Image

gif_url = 'https://media.giphy.com/media/xT9DPOo4UEuKSEPmoM/giphy.gif'
context.Base_renderAsHtml(
    Image(url=gif_url)
)