def update_connection(n):
if n > 0:
collect.get_data()
test2.sale_col = test2.get_col(test2.sale_col)
print('data have been updated')
return ''
def update_connection(n):
global df
global df_1
global df_final
global df_ko
global df_neuf
if n>0:
df = pd.read_csv('data/inventory.csv')
df['cost_price'] = df['cost_price'].round(2)
df = df[df['country'] == 'Mali']
df.fillna(0, inplace=True)
df_1 = df.groupby(['product_type', 'etat', 'cost_price', 'stock_type'], as_index=False).sum({'quantite': 'sum'})
df_final = df_1.copy()
df_final = df_final[(df_final['etat'] == 'Endommagé') | (df_final['etat'] == 'Neuf')]
df_final['Cout Total'] = (df_final['quantite'] * df_final['cost_price']).round(2)
# df_final.rename(columns={'serial':'Quantite'},inplace=True)
df_ko = df_final[df_final['etat'] == 'Endommagé']
df_neuf = df_final[df_final['etat'] == 'Neuf']
collect.get_data()
job2()
print('data have been updated')
return ''
def update_connection(n):
global sale_col
if n > 0:
collect.get_data()
sale_col = get_col(sale_col)
print('data have been updated')
return ''
def update_connection(n):
global data
if n > 0:
data = pd.read_csv('data/inventory.csv')
collect.get_data()
print('data have been updated')
return ''
def prep(path):
data, features = get_data(path)
features.sort()
label = []
new_data = []
for l in data:
new_row = []
if l[0] in affected_syscalls:
label.append(1)
else:
label.append(0)
memfreq = l[1]
for f in features:
if f not in memfreq.keys():
new_row.append(0)
else:
new_row.append(memfreq[f])
new_data.append(new_row)
return new_data, label
import dash_bootstrap_components as dbc
import dash_html_components as html
import dash_core_components as dcc
from dash.dependencies import Input, Output
import dash_table as dt
import psycopg2
from psycopg2 import Error
from sqlalchemy import text
from datetime import date
from datetime import timedelta
import collect
import atexit
from apscheduler.schedulers.background import BackgroundScheduler
collect.get_data()
scheduler = BackgroundScheduler(daemon=True)
scheduler.add_job(func=collect.get_data, trigger="interval", minutes=60)
scheduler.start()
df_ag_sup = pd.read_csv('Data/ag_sup.csv')
df_stock = pd.read_csv('Data/stock.csv')
df_vente = pd.read_csv('Data/vente.csv')
df_sup = pd.read_csv('Data/superviseur.csv')
df_ticket = pd.read_csv('Data/ticket.csv')
df_backlog = pd.read_csv('Data/backlog.csv')
table_header_style = {
# "backgroundColor": "#E5E2E2",
"color": "balck",
from collect import get_data from graph import mkgraph from subprocess import call mkgraph(list(get_data()), 'graph.png') call(['xloadimage', '-onroot', 'graph.png'])
