|
|
|
|
|
import streamlit as st |
|
|
|
|
|
def show_database_status(db): |
|
|
"""Show current database status""" |
|
|
st.sidebar.markdown("---") |
|
|
st.sidebar.subheader("📊 Database Status") |
|
|
|
|
|
try: |
|
|
if db: |
|
|
customers_count = len(db.get_dataframe('customers')) |
|
|
sales_count = len(db.get_dataframe('sales')) |
|
|
distributors_count = len(db.get_dataframe('distributors')) |
|
|
payments_count = len(db.get_dataframe('payments')) |
|
|
products_count = len(db.get_dataframe('products')) |
|
|
|
|
|
st.sidebar.metric("👥 Customers", customers_count) |
|
|
st.sidebar.metric("💰 Sales", sales_count) |
|
|
st.sidebar.metric("🤝 Distributors", distributors_count) |
|
|
st.sidebar.metric("💳 Payments", payments_count) |
|
|
st.sidebar.metric("📦 Products", products_count) |
|
|
else: |
|
|
st.sidebar.error("Database not available") |
|
|
|
|
|
except Exception as e: |
|
|
st.sidebar.error("Database connection issue") |
