| import pandas as pd |
| import streamlit as st |
|
|
| file_path = 'data_with_admin_v2.xlsx' |
| customer_service_df = pd.read_excel(file_path, sheet_name='CustomerService') |
|
|
| def customer_service_ui(): |
| st.title("Customer Service Functions") |
|
|
| if st.button("View Truck Owners Data", key="view_truck_owners_cs"): |
| truck_owners_df = pd.read_excel(file_path, sheet_name='Truck Owners') |
| st.dataframe(truck_owners_df) |
|
|
| if st.button("View Transporters Data", key="view_transporters_cs"): |
| transporters_df = pd.read_excel(file_path, sheet_name='Transporters') |
| st.dataframe(transporters_df) |
|
|
| st.subheader("Manage KYC and Operations") |
|
|
| if st.button("Verify Truck Owner KYC", key="verify_truck_owner_kyc"): |
| truck_owners_df = pd.read_excel(file_path, sheet_name='Truck Owners') |
| truck_owners_df['KYC Status'] = 'Verified' |
| truck_owners_df.to_excel(file_path, sheet_name='Truck Owners', index=False) |
| st.success("Truck Owner KYC Verified") |
|
|
| if st.button("Verify Transporter KYC", key="verify_transporter_kyc"): |
| transporters_df = pd.read_excel(file_path, sheet_name='Transporters') |
| transporters_df['KYC Status'] = 'Verified' |
| transporters_df.to_excel(file_path, sheet_name='Transporters', index=False) |
| st.success("Transporter KYC Verified") |
|
|
| if __name__ == "__main__": |
| customer_service_ui() |
|
|
