|
|
| 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") |
