| import pandas as pd |
| import streamlit as st |
|
|
| file_path = 'data_with_admin_v2.xlsx' |
| transporters_df = pd.read_excel(file_path, sheet_name='Transporters') |
|
|
| def add_transporter(name, company, load_requirements, source, destination): |
| global transporters_df |
| new_id = transporters_df['Transporter ID'].max() + 1 |
| new_row = pd.DataFrame({ |
| 'Transporter ID': [new_id], |
| 'Name': [name], |
| 'Company': [company], |
| 'Load Requirements': [load_requirements], |
| 'Source': [source], |
| 'Destination': [destination], |
| 'KYC Status': ['Pending'] |
| }) |
| transporters_df = pd.concat([transporters_df, new_row], ignore_index=True) |
| transporters_df.to_excel(file_path, sheet_name='Transporters', index=False) |
| return transporters_df |
|
|
| def transporter_ui(): |
| st.title("Transporter Functions") |
|
|
| with st.form(key='add_transporter_form'): |
| name = st.text_input("Name", key="transporter_name") |
| company = st.text_input("Company", key="transporter_company") |
| load_requirements = st.text_input("Load Requirements", key="transporter_load_requirements") |
| source = st.text_input("Source", key="transporter_source") |
| destination = st.text_input("Destination", key="transporter_destination") |
| submit_button = st.form_submit_button(label='Add Transporter') |
|
|
| if submit_button: |
| transporters_df = add_transporter(name, company, load_requirements, source, destination) |
| st.success("Transporter added successfully!") |
|
|
| if st.button("View Transporters Data", key="view_transporters"): |
| st.dataframe(transporters_df) |
|
|
| st.subheader("Transporter Verification Status") |
| st.dataframe(transporters_df[['Transporter ID', 'Name', 'Company', 'KYC Status', 'Load Requirements', 'Source', 'Destination']]) |
|
|
| if __name__ == "__main__": |
| transporter_ui() |
|
|
